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-00000253	1 September 2025	Granite Chevrolet	2024 Chevrolet Camaro 1LTUsed	Used Retail	$36,703	$7,729	$770	$8,499	17
SLE-00000254	1 September 2025	Granite Subaru	2025 Subaru Impreza SportUsed	Used Retail	$25,628	$2,568	$1,423	$3,991	67
SLE-00000255	1 September 2025	Granite Pre-Owned	2020 Jeep Wrangler SportUsed	Used Retail	$13,108	$1,809	$1,815	$3,623	107
SLE-00000256	1 September 2025	Granite Chevrolet	2020 Chevrolet Blazer 3LTCertified	Certified Retail	$13,412	$1,824	$1,841	$3,665	25
SLE-00000257	1 September 2025	Granite Chevrolet	2017 Toyota RAV4 XLEUsed	Used Retail	$5,874	$629	$304	$933	55
SLE-00000258	2 September 2025	Granite Chevrolet	2026 Chevrolet Silverado 1500 WTNew	New Retail	$42,970	-$1,811loss	$509	-$1,302	124
SLE-00000259	2 September 2025	Granite Subaru	2019 Subaru Forester BaseUsed	Used Retail	$5,064	-$266loss	$1,105	$839	70
SLE-00000260	2 September 2025	Granite Chevrolet	2019 Kia Sportage EXUsed	Used Retail	$4,270	$244	$3,034	$3,278	29
SLE-00000261	2 September 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	New Retail	$38,524	$707	$1,614	$2,321	49
SLE-00000262	2 September 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSNew	New Retail	$37,917	$1,171	$881	$2,052	63
SLE-00000263	2 September 2025	Granite Chevrolet	2021 Toyota RAV4 Hybrid XLEUsed	Used Retail	$19,597	$3,242	$768	$4,009	68
SLE-00000264	2 September 2025	Granite Subaru	2025 Subaru Ascent TouringNew	New Retail	$36,673	$167	$2,513	$2,681	35
SLE-00000265	3 September 2025	Granite Pre-Owned	2018 GMC Acadia SLTUsed	Used Retail	$9,409	$1,230	$264	$1,494	26
SLE-00000266	3 September 2025	Granite Chevrolet	2022 Hyundai Tucson LimitedUsed	Used Retail	$21,006	$2,309	$1,098	$3,408	141
SLE-00000267	3 September 2025	Granite Subaru	2018 Ford F-150 LariatUsed	Used Retail	$10,517	$999	$1,644	$2,642	68
SLE-00000268	3 September 2025	Granite Pre-Owned	2017 Toyota RAV4 XLEUsed	Used Retail	$4,584	$487	$963	$1,450	9
SLE-00000269	4 September 2025	Granite Subaru	2024 Ford F-150 XLUsed	Used Retail	$41,734	$7,435	$1,962	$9,396	61
SLE-00000270	5 September 2025	Granite Chevrolet	2026 Chevrolet Blazer EV LTNew	Lease	$38,517	$1,339	$1,087	$2,426	31
SLE-00000271	5 September 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSUsed	Wholesalenot retail	$27,244	-$3,039loss	$0	-$3,039	44
SLE-00000272	5 September 2025	Granite Chevrolet	2026 Chevrolet Blazer EV LTUsed	Used Retail	$41,846	$6,420	$908	$7,328	46
SLE-00000273	5 September 2025	Granite Chevrolet	2025 Chevrolet Blazer EV LTNew	New Retail	$37,442	$2,668	$2,140	$4,808	14
SLE-00000274	6 September 2025	Granite Subaru	2022 Subaru WRX GTCertified	Lease	$21,723	$3,158	$338	$3,496	65
SLE-00000275	6 September 2025	Granite Chevrolet	2022 Chevrolet Tahoe LTCertified	Certified Retail	$21,685	$2,666	$644	$3,309	158
SLE-00000276	6 September 2025	Granite Chevrolet	2025 Chevrolet Blazer EV LTNew	Dealer Tradenot retail	$38,707	$888	$0	$888	12
SLE-00000277	6 September 2025	Granite Chevrolet	2019 Chevrolet Equinox LTUsed	Wholesalenot retail	$4,169	-$990loss	$0	-$990	117

SLE-000002531 September 2025
2024 Chevrolet Camaro 1LT
Granite ChevroletVEH-0000071UsedUsed RetailTrade
Sale price
$36,703
Front
$7,729
Back
$770
Total
$8,499
Source: Direct Site VisitSalesperson: EMP-0000617 days in stock
SLE-000002541 September 2025
2025 Subaru Impreza Sport
Granite SubaruVEH-0000143UsedUsed RetailTrade
Sale price
$25,628
Front
$2,568
Back
$1,423
Total
$3,991
Source: Organic Search LandingSalesperson: EMP-0001667 days in stock
SLE-000002551 September 2025
2020 Jeep Wrangler Sport
Granite Pre-OwnedVEH-0000417UsedUsed Retail
Sale price
$13,108
Front
$1,809
Back
$1,815
Total
$3,623
Source: Direct Mail ResponseSalesperson: EMP-00029107 days in stock
SLE-000002561 September 2025
2020 Chevrolet Blazer 3LT
Granite ChevroletVEH-0000448CertifiedCertified Retail
Sale price
$13,412
Front
$1,824
Back
$1,841
Total
$3,665
Source: Television Spot ResponseSalesperson: EMP-0001225 days in stock
SLE-000002571 September 2025
2017 Toyota RAV4 XLE
Granite ChevroletVEH-0000587UsedUsed Retail
Sale price
$5,874
Front
$629
Back
$304
Total
$933
Walk-in or unattributedSalesperson: EMP-0001055 days in stock
SLE-000002582 September 2025
2026 Chevrolet Silverado 1500 WT
Granite ChevroletVEH-0000089NewNew RetailTrade
Sale price
$42,970
Front
-$1,811loss
Back
$509
Total
-$1,302
Walk-in or unattributedSalesperson: EMP-00006124 days in stock
SLE-000002592 September 2025
2019 Subaru Forester Base
Granite SubaruVEH-0000126UsedUsed Retail
Sale price
$5,064
Front
-$266loss
Back
$1,105
Total
$839
Walk-in or unattributedSalesperson: EMP-0002270 days in stock
SLE-000002602 September 2025
2019 Kia Sportage EX
Granite ChevroletVEH-0000528UsedUsed RetailTrade
Sale price
$4,270
Front
$244
Back
$3,034
Total
$3,278
Source: Showroom Walk-inSalesperson: EMP-0000329 days in stock
SLE-000002612 September 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000597NewNew RetailTrade
Sale price
$38,524
Front
$707
Back
$1,614
Total
$2,321
Walk-in or unattributedSalesperson: EMP-0002249 days in stock
SLE-000002622 September 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000637NewNew RetailTrade
Sale price
$37,917
Front
$1,171
Back
$881
Total
$2,052
Source: Customer ReferralSalesperson: EMP-0000363 days in stock
SLE-000002632 September 2025
2021 Toyota RAV4 Hybrid XLE
Granite ChevroletVEH-0000712UsedUsed Retail
Sale price
$19,597
Front
$3,242
Back
$768
Total
$4,009
Source: Organic Search LandingSalesperson: EMP-0000368 days in stock
SLE-000002642 September 2025
2025 Subaru Ascent Touring
Granite SubaruVEH-0000749NewNew Retail
Sale price
$36,673
Front
$167
Back
$2,513
Total
$2,681
Source: Showroom Walk-inSalesperson: EMP-0001635 days in stock
SLE-000002653 September 2025
2018 GMC Acadia SLT
Granite Pre-OwnedVEH-0000043UsedUsed Retail
Sale price
$9,409
Front
$1,230
Back
$264
Total
$1,494
Source: Service Lane OpportunitySalesperson: EMP-0002526 days in stock
SLE-000002663 September 2025
2022 Hyundai Tucson Limited
Granite ChevroletVEH-0000380UsedUsed Retail
Sale price
$21,006
Front
$2,309
Back
$1,098
Total
$3,408
Source: Showroom Walk-inSalesperson: EMP-00012141 days in stock
SLE-000002673 September 2025
2018 Ford F-150 Lariat
Granite SubaruVEH-0000398UsedUsed RetailTrade
Sale price
$10,517
Front
$999
Back
$1,644
Total
$2,642
Source: Organic Search LandingSalesperson: EMP-0001868 days in stock
SLE-000002683 September 2025
2017 Toyota RAV4 XLE
Granite Pre-OwnedVEH-0000893UsedUsed RetailTrade
Sale price
$4,584
Front
$487
Back
$963
Total
$1,450
Source: Showroom Walk-inSalesperson: EMP-000259 days in stock
SLE-000002694 September 2025
2024 Ford F-150 XL
Granite SubaruVEH-0000355UsedUsed RetailTrade
Sale price
$41,734
Front
$7,435
Back
$1,962
Total
$9,396
Source: Dealer Website FormSalesperson: EMP-0001661 days in stock
SLE-000002705 September 2025
2026 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000067NewLease
Sale price
$38,517
Front
$1,339
Back
$1,087
Total
$2,426
Source: Paid Search BrandSalesperson: EMP-0000331 days in stock
SLE-000002715 September 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000288UsedWholesale
Sale price
$27,244
Front
-$3,039loss
Back
$0
Total
-$3,039
Walk-in or unattributedSalesperson: EMP-0000344 days in stock
SLE-000002725 September 2025
2026 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000555UsedUsed RetailTrade
Sale price
$41,846
Front
$6,420
Back
$908
Total
$7,328
Source: Organic Search LandingSalesperson: EMP-0000646 days in stock
SLE-000002735 September 2025
2025 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000561NewNew RetailTrade
Sale price
$37,442
Front
$2,668
Back
$2,140
Total
$4,808
Source: Showroom Walk-inSalesperson: EMP-0001214 days in stock
SLE-000002746 September 2025
2022 Subaru WRX GT
Granite SubaruVEH-0000053CertifiedLease
Sale price
$21,723
Front
$3,158
Back
$338
Total
$3,496
Source: Organic Search LandingSalesperson: EMP-0001565 days in stock
SLE-000002756 September 2025
2022 Chevrolet Tahoe LT
Granite ChevroletVEH-0000336CertifiedCertified Retail
Sale price
$21,685
Front
$2,666
Back
$644
Total
$3,309
Source: Dealer Website FormSalesperson: EMP-00006158 days in stock
SLE-000002766 September 2025
2025 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000371NewDealer Trade
Sale price
$38,707
Front
$888
Back
$0
Total
$888
Walk-in or unattributedSalesperson: EMP-0000312 days in stock
SLE-000002776 September 2025
2019 Chevrolet Equinox LT
Granite ChevroletVEH-0000483UsedWholesale
Sale price
$4,169
Front
-$990loss
Back
$0
Total
-$990
Walk-in or unattributedSalesperson: EMP-00003117 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-00000253	VEH-0000071	Direct Site Visit	EMP-00006	EMP-00002	EMP-00005
SLE-00000254	VEH-0000143	Organic Search Landing	EMP-00016	EMP-00023	EMP-00017
SLE-00000255	VEH-0000417	Direct Mail Response	EMP-00029	EMP-00030	EMP-00028
SLE-00000256	VEH-0000448	Television Spot Response	EMP-00012	EMP-00002	EMP-00005
SLE-00000257	VEH-0000587	Walk-in or unattributed	EMP-00010	EMP-00002	EMP-00005
SLE-00000258	VEH-0000089	Walk-in or unattributed	EMP-00006	EMP-00008	EMP-00005
SLE-00000259	VEH-0000126	Walk-in or unattributed	EMP-00022	EMP-00023	EMP-00017
SLE-00000260	VEH-0000528	Showroom Walk-in	EMP-00003	EMP-00002	EMP-00005
SLE-00000261	VEH-0000597	Walk-in or unattributed	EMP-00022	EMP-00023	EMP-00017
SLE-00000262	VEH-0000637	Customer Referral	EMP-00003	EMP-00002	EMP-00005
SLE-00000263	VEH-0000712	Organic Search Landing	EMP-00003	EMP-00008	EMP-00005
SLE-00000264	VEH-0000749	Showroom Walk-in	EMP-00016	EMP-00014	EMP-00017
SLE-00000265	VEH-0000043	Service Lane Opportunity	EMP-00025	EMP-00024	EMP-00028
SLE-00000266	VEH-0000380	Showroom Walk-in	EMP-00012	EMP-00008	Unattributed
SLE-00000267	VEH-0000398	Organic Search Landing	EMP-00018	EMP-00013	EMP-00017
SLE-00000268	VEH-0000893	Showroom Walk-in	EMP-00025	EMP-00024	EMP-00028
SLE-00000269	VEH-0000355	Dealer Website Form	EMP-00016	EMP-00023	EMP-00017
SLE-00000270	VEH-0000067	Paid Search Brand	EMP-00003	EMP-00001	EMP-00005
SLE-00000271	VEH-0000288	Walk-in or unattributed	EMP-00003	EMP-00008	Unattributed
SLE-00000272	VEH-0000555	Organic Search Landing	EMP-00006	EMP-00008	EMP-00005
SLE-00000273	VEH-0000561	Showroom Walk-in	EMP-00012	EMP-00001	EMP-00005
SLE-00000274	VEH-0000053	Organic Search Landing	EMP-00015	EMP-00013	EMP-00017
SLE-00000275	VEH-0000336	Dealer Website Form	EMP-00006	EMP-00008	EMP-00005
SLE-00000276	VEH-0000371	Walk-in or unattributed	EMP-00003	EMP-00008	Unattributed
SLE-00000277	VEH-0000483	Walk-in or unattributed	EMP-00003	EMP-00002	Unattributed

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.