Deal Explorer

103 deals · All three stores · September 2025

Granite Auto Group is fictional. Operating figures are synthetic.· data and methodology

Every warehouse record in this project is synthetic. Granite Auto Group and its three stores are fictional. No real dealership, customer, employee or lending data exists anywhere in the project.

Dataset v17 · developmentAs of 31 December 2025Real-engine validation pending

Real-engine validation pending. Neither accepted ADR-0008 path has recorded a result, so nothing on this page may be read as evidence that the Power BI semantic model has been validated. This console renders exported SQL figures; rendering a number in HTML proves nothing about a DAX measure.

The evidence behind both statements

How this is built, governed and validated

Filters

Period: 2025-09Remove this filter

Reset filters

Filters and controls1 applied

Period

Store

Condition

Selects deals by the vehicle's condition.

Lead source

Selects deals with a linked lead from that source. Walk-in deals are excluded when a source is chosen.

This filter selects

September 2025

Deals counts every matched transaction; the money figures are over the retail rows only, because a wholesale disposal belongs in the table below and not in a retail gross total. A deal that closed at a front-end loss is counted rather than suppressed.

Deals: 103; Matching the current filters
Retail units: 88; 15 matched transactions are not retail
Total gross: $356,938; Retail rows only

Front gross: $248,374
Back gross: $108,564
Closed at a front loss: 22

The transactions behind the aggregate

Sales & Gross for this scope

A wholesale disposal or dealer trade is shown and labelled as not retail: it is a real transaction, and judging it by retail measures would be the error, not showing it.

Finalized transactions matching the current filters, one row per deal.
Deal	Sale date	Store	Vehicle	Sale type	Sale price	Front gross	Back gross	Total gross	Days
SLE-00000303	15 September 2025	Granite Chevrolet	2019 Chevrolet Equinox LTCertified	Certified Retail	$10,881	$1,511	$1,595	$3,106	84
SLE-00000304	15 September 2025	Granite Chevrolet	2026 Chevrolet Traverse High CountryNew	New Retail	$38,349	$1,932	$1,819	$3,751	56
SLE-00000305	15 September 2025	Granite Pre-Owned	2018 Subaru Crosstrek BaseUsed	Used Retail	$3,258	$178	$670	$848	76
SLE-00000306	15 September 2025	Granite Chevrolet	2026 Chevrolet Silverado 1500 WTNew	New Retail	$50,015	$3,084	$2,008	$5,092	40
SLE-00000307	16 September 2025	Granite Chevrolet	2021 Chevrolet Equinox LTUsed	Used Retail	$14,577	$2,570	$1,107	$3,677	28
SLE-00000308	16 September 2025	Granite Pre-Owned	2023 Ford Bronco Sport Big BendUsed	Used Retail	$17,286	$3,506	$1,912	$5,418	24
SLE-00000309	16 September 2025	Granite Subaru	2025 Subaru Ascent Onyx EditionNew	New Retail	$35,856	$316	$831	$1,147	92
SLE-00000310	16 September 2025	Granite Chevrolet	2026 Chevrolet Colorado WTNew	New Retail	$47,875	$3,259	$3,043	$6,302	0
SLE-00000311	16 September 2025	Granite Chevrolet	2025 Chevrolet Blazer EV LTNew	New Retail	$38,741	$1,734	$1,329	$3,063	47
SLE-00000312	16 September 2025	Granite Chevrolet	2023 Chevrolet Equinox PremierCertified	Certified Retail	$22,084	$2,148	$832	$2,980	88
SLE-00000313	17 September 2025	Granite Chevrolet	2024 Chevrolet Silverado EV RSTNew	New Retail	$45,775	$525	$1,025	$1,551	82
SLE-00000314	17 September 2025	Granite Pre-Owned	2021 Chevrolet Equinox LTUsed	Used Retail	$21,317	$4,597	$563	$5,160	22
SLE-00000315	17 September 2025	Granite Subaru	2020 Subaru Outback Onyx Edition XTCertified	Certified Retail	$10,944	$1,374	$534	$1,909	131
SLE-00000316	17 September 2025	Granite Subaru	2019 Subaru Forester BaseUsed	Wholesalenot retail	$6,155	-$737loss	$0	-$737	19
SLE-00000317	18 September 2025	Granite Pre-Owned	2020 Ford F-150 XLTUsed	Wholesalenot retail	$12,193	-$1,371loss	$0	-$1,371	24
SLE-00000318	18 September 2025	Granite Chevrolet	2022 Chevrolet Camaro ZL1Used	Used Retail	$20,700	$2,079	$1,169	$3,248	91
SLE-00000319	18 September 2025	Granite Subaru	2026 Subaru Outback Onyx Edition XTNew	Lease	$29,584	$405	$734	$1,139	23
SLE-00000320	19 September 2025	Granite Chevrolet	2024 Chevrolet Traverse LTCertified	Certified Retail	$37,172	$8,989	$616	$9,606	10
SLE-00000321	19 September 2025	Granite Chevrolet	2026 Chevrolet Silverado EV RSTUsed	Used Retail	$54,578	$11,301	$1,050	$12,351	18
SLE-00000322	19 September 2025	Granite Chevrolet	2017 Chevrolet Camaro 1LTUsed	Wholesalenot retail	$3,745	-$1,010loss	$0	-$1,010	15
SLE-00000323	20 September 2025	Granite Subaru	2025 Subaru Ascent TouringNew	New Retail	$37,186	$286	$1,176	$1,462	67
SLE-00000324	20 September 2025	Granite Pre-Owned	2026 Chevrolet Blazer EV LTUsed	Used Retail	$40,373	$8,326	$757	$9,083	113
SLE-00000325	20 September 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSNew	New Retail	$38,366	$2,321	$1,837	$4,158	24
SLE-00000326	20 September 2025	Granite Pre-Owned	2016 Jeep Grand Cherokee LaredoUsed	Used Retail	$3,975	$130	$979	$1,110	39
SLE-00000327	20 September 2025	Granite Subaru	2025 Subaru Forester BaseUsed	Used Retail	$34,996	$4,301	$1,210	$5,510	134

SLE-0000030315 September 2025
2019 Chevrolet Equinox LT
Granite ChevroletVEH-0000476CertifiedCertified RetailTrade
Sale price
$10,881
Front
$1,511
Back
$1,595
Total
$3,106
Source: Showroom Walk-inSalesperson: EMP-0001284 days in stock
SLE-0000030415 September 2025
2026 Chevrolet Traverse High Country
Granite ChevroletVEH-0000738NewNew Retail
Sale price
$38,349
Front
$1,932
Back
$1,819
Total
$3,751
Source: Showroom Walk-inSalesperson: EMP-0001256 days in stock
SLE-0000030515 September 2025
2018 Subaru Crosstrek Base
Granite Pre-OwnedVEH-0000739UsedUsed RetailTrade
Sale price
$3,258
Front
$178
Back
$670
Total
$848
Source: Dealer Website FormSalesperson: EMP-0002676 days in stock
SLE-0000030615 September 2025
2026 Chevrolet Silverado 1500 WT
Granite ChevroletVEH-0000803NewNew Retail
Sale price
$50,015
Front
$3,084
Back
$2,008
Total
$5,092
Walk-in or unattributedSalesperson: EMP-0001240 days in stock
SLE-0000030716 September 2025
2021 Chevrolet Equinox LT
Granite ChevroletVEH-0000013UsedUsed Retail
Sale price
$14,577
Front
$2,570
Back
$1,107
Total
$3,677
Source: Third-Party Marketplace ListingSalesperson: EMP-0000728 days in stock
SLE-0000030816 September 2025
2023 Ford Bronco Sport Big Bend
Granite Pre-OwnedVEH-0000096UsedUsed Retail
Sale price
$17,286
Front
$3,506
Back
$1,912
Total
$5,418
Walk-in or unattributedSalesperson: EMP-0002724 days in stock
SLE-0000030916 September 2025
2025 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000133NewNew Retail
Sale price
$35,856
Front
$316
Back
$831
Total
$1,147
Source: Dealer Website FormSalesperson: EMP-0001692 days in stock
SLE-0000031016 September 2025
2026 Chevrolet Colorado WT
Granite ChevroletVEH-0000293NewNew RetailTrade
Sale price
$47,875
Front
$3,259
Back
$3,043
Total
$6,302
Source: Showroom Walk-inSalesperson: EMP-000120 days in stock
SLE-0000031116 September 2025
2025 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000303NewNew RetailTrade
Sale price
$38,741
Front
$1,734
Back
$1,329
Total
$3,063
Source: Dealer Website FormSalesperson: EMP-0001047 days in stock
SLE-0000031216 September 2025
2023 Chevrolet Equinox Premier
Granite ChevroletVEH-0000354CertifiedCertified RetailTrade
Sale price
$22,084
Front
$2,148
Back
$832
Total
$2,980
Source: Direct Site VisitSalesperson: EMP-0000688 days in stock
SLE-0000031317 September 2025
2024 Chevrolet Silverado EV RST
Granite ChevroletVEH-0000260NewNew RetailTrade
Sale price
$45,775
Front
$525
Back
$1,025
Total
$1,551
Walk-in or unattributedSalesperson: EMP-0001282 days in stock
SLE-0000031417 September 2025
2021 Chevrolet Equinox LT
Granite Pre-OwnedVEH-0000514UsedUsed Retail
Sale price
$21,317
Front
$4,597
Back
$563
Total
$5,160
Source: Email Marketing ResponseSalesperson: EMP-0002922 days in stock
SLE-0000031517 September 2025
2020 Subaru Outback Onyx Edition XT
Granite SubaruVEH-0000529CertifiedCertified RetailTrade
Sale price
$10,944
Front
$1,374
Back
$534
Total
$1,909
Source: Service Lane OpportunitySalesperson: EMP-00015131 days in stock
SLE-0000031617 September 2025
2019 Subaru Forester Base
Granite SubaruVEH-0000688UsedWholesale
Sale price
$6,155
Front
-$737loss
Back
$0
Total
-$737
Walk-in or unattributedSalesperson: EMP-0001819 days in stock
SLE-0000031718 September 2025
2020 Ford F-150 XLT
Granite Pre-OwnedVEH-0000229UsedWholesale
Sale price
$12,193
Front
-$1,371loss
Back
$0
Total
-$1,371
Walk-in or unattributedSalesperson: EMP-0002924 days in stock
SLE-0000031818 September 2025
2022 Chevrolet Camaro ZL1
Granite ChevroletVEH-0000784UsedUsed Retail
Sale price
$20,700
Front
$2,079
Back
$1,169
Total
$3,248
Source: Dealer Website FormSalesperson: EMP-0001091 days in stock
SLE-0000031918 September 2025
2026 Subaru Outback Onyx Edition XT
Granite SubaruVEH-0000794NewLease
Sale price
$29,584
Front
$405
Back
$734
Total
$1,139
Source: Third-Party Trade Valuation PortalSalesperson: EMP-0001523 days in stock
SLE-0000032019 September 2025
2024 Chevrolet Traverse LT
Granite ChevroletVEH-0000057CertifiedCertified RetailTrade
Sale price
$37,172
Front
$8,989
Back
$616
Total
$9,606
Walk-in or unattributedSalesperson: EMP-0001010 days in stock
SLE-0000032119 September 2025
2026 Chevrolet Silverado EV RST
Granite ChevroletVEH-0000129UsedUsed RetailTrade
Sale price
$54,578
Front
$11,301
Back
$1,050
Total
$12,351
Source: Customer ReferralSalesperson: EMP-0000318 days in stock
SLE-0000032219 September 2025
2017 Chevrolet Camaro 1LT
Granite ChevroletVEH-0000557UsedWholesale
Sale price
$3,745
Front
-$1,010loss
Back
$0
Total
-$1,010
Walk-in or unattributedSalesperson: EMP-0001015 days in stock
SLE-0000032320 September 2025
2025 Subaru Ascent Touring
Granite SubaruVEH-0000253NewNew RetailTrade
Sale price
$37,186
Front
$286
Back
$1,176
Total
$1,462
Source: Showroom Walk-inSalesperson: EMP-0001867 days in stock
SLE-0000032420 September 2025
2026 Chevrolet Blazer EV LT
Granite Pre-OwnedVEH-0000322UsedUsed Retail
Sale price
$40,373
Front
$8,326
Back
$757
Total
$9,083
Walk-in or unattributedSalesperson: EMP-00029113 days in stock
SLE-0000032520 September 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000630NewNew Retail
Sale price
$38,366
Front
$2,321
Back
$1,837
Total
$4,158
Source: Repeat Customer OutreachSalesperson: EMP-0001224 days in stock
SLE-0000032620 September 2025
2016 Jeep Grand Cherokee Laredo
Granite Pre-OwnedVEH-0000718UsedUsed RetailTrade
Sale price
$3,975
Front
$130
Back
$979
Total
$1,110
Walk-in or unattributedSalesperson: EMP-0002539 days in stock
SLE-0000032720 September 2025
2025 Subaru Forester Base
Granite SubaruVEH-0000724UsedUsed Retail
Sale price
$34,996
Front
$4,301
Back
$1,210
Total
$5,510
Source: Paid Search BrandSalesperson: EMP-00015134 days in stock

Unit, lead source and attribution for these deals

Unit identifier, lead source and staff attribution for the deals listed above, in the same order. Synthetic employee codes; no name exists anywhere in ARPI.
Deal	Unit	Lead source	Salesperson	Desk	Finance
SLE-00000303	VEH-0000476	Showroom Walk-in	EMP-00012	EMP-00002	EMP-00005
SLE-00000304	VEH-0000738	Showroom Walk-in	EMP-00012	EMP-00008	EMP-00005
SLE-00000305	VEH-0000739	Dealer Website Form	EMP-00026	EMP-00030	EMP-00028
SLE-00000306	VEH-0000803	Walk-in or unattributed	EMP-00012	EMP-00008	EMP-00005
SLE-00000307	VEH-0000013	Third-Party Marketplace Listing	EMP-00007	EMP-00008	EMP-00005
SLE-00000308	VEH-0000096	Walk-in or unattributed	EMP-00027	EMP-00024	EMP-00028
SLE-00000309	VEH-0000133	Dealer Website Form	EMP-00016	EMP-00023	EMP-00017
SLE-00000310	VEH-0000293	Showroom Walk-in	EMP-00012	EMP-00001	EMP-00005
SLE-00000311	VEH-0000303	Dealer Website Form	EMP-00010	EMP-00001	EMP-00005
SLE-00000312	VEH-0000354	Direct Site Visit	EMP-00006	EMP-00002	EMP-00005
SLE-00000313	VEH-0000260	Walk-in or unattributed	EMP-00012	EMP-00008	EMP-00005
SLE-00000314	VEH-0000514	Email Marketing Response	EMP-00029	EMP-00024	EMP-00028
SLE-00000315	VEH-0000529	Service Lane Opportunity	EMP-00015	EMP-00023	Unattributed
SLE-00000316	VEH-0000688	Walk-in or unattributed	EMP-00018	EMP-00013	Unattributed
SLE-00000317	VEH-0000229	Walk-in or unattributed	EMP-00029	EMP-00024	Unattributed
SLE-00000318	VEH-0000784	Dealer Website Form	EMP-00010	EMP-00008	EMP-00005
SLE-00000319	VEH-0000794	Third-Party Trade Valuation Portal	EMP-00015	EMP-00014	EMP-00017
SLE-00000320	VEH-0000057	Walk-in or unattributed	EMP-00010	EMP-00008	EMP-00005
SLE-00000321	VEH-0000129	Customer Referral	EMP-00003	EMP-00001	Unattributed
SLE-00000322	VEH-0000557	Walk-in or unattributed	EMP-00010	EMP-00002	Unattributed
SLE-00000323	VEH-0000253	Showroom Walk-in	EMP-00018	EMP-00023	EMP-00017
SLE-00000324	VEH-0000322	Walk-in or unattributed	EMP-00029	EMP-00024	EMP-00028
SLE-00000325	VEH-0000630	Repeat Customer Outreach	EMP-00012	EMP-00001	EMP-00005
SLE-00000326	VEH-0000718	Walk-in or unattributed	EMP-00025	EMP-00024	EMP-00028
SLE-00000327	VEH-0000724	Paid Search Brand	EMP-00015	EMP-00014	EMP-00017

Each deal id opens its Deal Jacket: the transaction explained to the cent, with the cost components behind its front gross, its trade context, staff attribution, lead timeline, integrity checks and lineage.