Deal Explorer

106 deals · All three stores · December 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 and controlsnone 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

December 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: 106; Matching the current filters
Retail units: 92; 14 matched transactions are not retail
Total gross: $321,935; Retail rows only

Front gross: $213,657
Back gross: $108,277
Closed at a front loss: 23

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-00000620	25 December 2025	Granite Chevrolet	2023 Chevrolet Equinox LSCertified	Wholesalenot retail	$21,314	-$2,212loss	$0	-$2,212	71
SLE-00000621	25 December 2025	Granite Subaru	2020 Subaru Outback Onyx Edition XTCertified	Certified Retail	$13,480	$2,432	$1,168	$3,600	64
SLE-00000622	25 December 2025	Granite Chevrolet	2026 Chevrolet Colorado Z71New	New Retail	$45,471	$183	$841	$1,024	36
SLE-00000623	25 December 2025	Granite Subaru	2025 Subaru Forester BaseUsed	Used Retail	$45,709	$11,097	$1,229	$12,327	8
SLE-00000624	25 December 2025	Granite Pre-Owned	2025 Chevrolet Tahoe LSUsed	Used Retail	$36,161	$5,614	$1,771	$7,385	51
SLE-00000625	25 December 2025	Granite Subaru	2023 Chevrolet Trailblazer LSUsed	Used Retail	$17,838	$1,107	$2,017	$3,124	100
SLE-00000626	25 December 2025	Granite Subaru	2018 Subaru Crosstrek BaseCertified	Certified Retail	$5,278	$371	$692	$1,063	92
SLE-00000627	26 December 2025	Granite Pre-Owned	2021 Chevrolet Corvette Stingray 1LTUsed	Wholesalenot retail	$15,766	-$1,190loss	$0	-$1,190	34
SLE-00000628	26 December 2025	Granite Subaru	2025 Subaru Impreza BaseNew	New Retail	$23,393	-$43loss	$234	$191	42
SLE-00000629	26 December 2025	Granite Subaru	2022 Subaru Crosstrek LimitedUsed	Used Retail	$12,852	$1,280	$1,010	$2,290	114
SLE-00000630	27 December 2025	Granite Subaru	2025 Subaru Impreza BaseNew	New Retail	$23,933	-$181loss	$1,577	$1,396	53
SLE-00000631	27 December 2025	Granite Pre-Owned	2016 Volkswagen Jetta SUsed	Used Retail	$3,137	$202	$1,300	$1,502	37
SLE-00000632	27 December 2025	Granite Subaru	2024 Subaru Outback WildernessUsed	Used Retail	$24,849	$4,599	$992	$5,591	14
SLE-00000633	27 December 2025	Granite Subaru	2019 Kia Sportage EXUsed	Used Retail	$7,057	$247	$115	$361	145
SLE-00000634	27 December 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	New Retail	$38,053	$1,986	$739	$2,725	21
SLE-00000635	29 December 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSNew	Lease	$37,984	$2,784	$586	$3,370	26
SLE-00000636	29 December 2025	Granite Chevrolet	2022 Ford Escape SUsed	Used Retail	$13,771	$2,045	$1,472	$3,517	41
SLE-00000637	29 December 2025	Granite Chevrolet	2026 Chevrolet Colorado WTNew	Lease	$47,633	$2,865	$593	$3,458	26
SLE-00000638	29 December 2025	Granite Subaru	2022 Subaru BRZ LimitedUsed	Used Retail	$24,207	$5,335	$1,190	$6,525	110
SLE-00000639	29 December 2025	Granite Chevrolet	2022 Chevrolet Tahoe Z71Certified	Certified Retail	$23,096	$5,250	$282	$5,533	31
SLE-00000640	29 December 2025	Granite Subaru	2026 Subaru Ascent BaseNew	Lease	$37,790	$444	$1,556	$2,000	97
SLE-00000641	29 December 2025	Granite Chevrolet	2024 Chevrolet Blazer EV LTNew	New Retail	$36,969	$1,595	$967	$2,563	25
SLE-00000642	30 December 2025	Granite Chevrolet	2016 Chevrolet Malibu LSUsed	Used Retail	$3,240	-$306loss	$808	$502	21
SLE-00000643	30 December 2025	Granite Pre-Owned	2021 Chevrolet Equinox LTUsed	Used Retail	$18,514	$3,606	$976	$4,582	85
SLE-00000644	30 December 2025	Granite Chevrolet	2024 Chevrolet Camaro 1LTUsed	Used Retail	$36,265	$7,437	$1,269	$8,706	29

SLE-0000062025 December 2025
2023 Chevrolet Equinox LS
Granite ChevroletVEH-0000393CertifiedWholesale
Sale price
$21,314
Front
-$2,212loss
Back
$0
Total
-$2,212
Walk-in or unattributedSalesperson: EMP-0001271 days in stock
SLE-0000062125 December 2025
2020 Subaru Outback Onyx Edition XT
Granite SubaruVEH-0000466CertifiedCertified RetailTrade
Sale price
$13,480
Front
$2,432
Back
$1,168
Total
$3,600
Source: Showroom Walk-inSalesperson: EMP-0001564 days in stock
SLE-0000062225 December 2025
2026 Chevrolet Colorado Z71
Granite ChevroletVEH-0000636NewNew Retail
Sale price
$45,471
Front
$183
Back
$841
Total
$1,024
Source: Dealer Website ChatSalesperson: EMP-0001236 days in stock
SLE-0000062325 December 2025
2025 Subaru Forester Base
Granite SubaruVEH-0000671UsedUsed RetailTrade
Sale price
$45,709
Front
$11,097
Back
$1,229
Total
$12,327
Source: Showroom Walk-inSalesperson: EMP-000168 days in stock
SLE-0000062425 December 2025
2025 Chevrolet Tahoe LS
Granite Pre-OwnedVEH-0000673UsedUsed Retail
Sale price
$36,161
Front
$5,614
Back
$1,771
Total
$7,385
Source: Customer ReferralSalesperson: EMP-0002951 days in stock
SLE-0000062525 December 2025
2023 Chevrolet Trailblazer LS
Granite SubaruVEH-0000759UsedUsed Retail
Sale price
$17,838
Front
$1,107
Back
$2,017
Total
$3,124
Source: Showroom Walk-inSalesperson: EMP-00016100 days in stock
SLE-0000062625 December 2025
2018 Subaru Crosstrek Base
Granite SubaruVEH-0000802CertifiedCertified RetailTrade
Sale price
$5,278
Front
$371
Back
$692
Total
$1,063
Source: Organic Search LandingSalesperson: EMP-0001692 days in stock
SLE-0000062726 December 2025
2021 Chevrolet Corvette Stingray 1LT
Granite Pre-OwnedVEH-0000138UsedWholesale
Sale price
$15,766
Front
-$1,190loss
Back
$0
Total
-$1,190
Walk-in or unattributedSalesperson: EMP-0002534 days in stock
SLE-0000062826 December 2025
2025 Subaru Impreza Base
Granite SubaruVEH-0000307NewNew RetailTrade
Sale price
$23,393
Front
-$43loss
Back
$234
Total
$191
Source: Paid Search BrandSalesperson: EMP-0001642 days in stock
SLE-0000062926 December 2025
2022 Subaru Crosstrek Limited
Granite SubaruVEH-0000586UsedUsed Retail
Sale price
$12,852
Front
$1,280
Back
$1,010
Total
$2,290
Walk-in or unattributedSalesperson: EMP-00016114 days in stock
SLE-0000063027 December 2025
2025 Subaru Impreza Base
Granite SubaruVEH-0000226NewNew RetailTrade
Sale price
$23,933
Front
-$181loss
Back
$1,577
Total
$1,396
Source: Service Lane OpportunitySalesperson: EMP-0001653 days in stock
SLE-0000063127 December 2025
2016 Volkswagen Jetta S
Granite Pre-OwnedVEH-0000363UsedUsed RetailTrade
Sale price
$3,137
Front
$202
Back
$1,300
Total
$1,502
Walk-in or unattributedSalesperson: EMP-0002737 days in stock
SLE-0000063227 December 2025
2024 Subaru Outback Wilderness
Granite SubaruVEH-0000474UsedUsed Retail
Sale price
$24,849
Front
$4,599
Back
$992
Total
$5,591
Source: Paid Search BrandSalesperson: EMP-0001514 days in stock
SLE-0000063327 December 2025
2019 Kia Sportage EX
Granite SubaruVEH-0000615UsedUsed Retail
Sale price
$7,057
Front
$247
Back
$115
Total
$361
Source: Dealer Website FormSalesperson: EMP-00016145 days in stock
SLE-0000063427 December 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000801NewNew RetailTrade
Sale price
$38,053
Front
$1,986
Back
$739
Total
$2,725
Source: Showroom Walk-inSalesperson: EMP-0001621 days in stock
SLE-0000063529 December 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000034NewLease
Sale price
$37,984
Front
$2,784
Back
$586
Total
$3,370
Source: Dealer Website ChatSalesperson: EMP-0000326 days in stock
SLE-0000063629 December 2025
2022 Ford Escape S
Granite ChevroletVEH-0000167UsedUsed Retail
Sale price
$13,771
Front
$2,045
Back
$1,472
Total
$3,517
Source: Community Partner ReferralSalesperson: EMP-0001241 days in stock
SLE-0000063729 December 2025
2026 Chevrolet Colorado WT
Granite ChevroletVEH-0000203NewLease
Sale price
$47,633
Front
$2,865
Back
$593
Total
$3,458
Source: Customer ReferralSalesperson: EMP-0001026 days in stock
SLE-0000063829 December 2025
2022 Subaru BRZ Limited
Granite SubaruVEH-0000205UsedUsed Retail
Sale price
$24,207
Front
$5,335
Back
$1,190
Total
$6,525
Walk-in or unattributedSalesperson: EMP-00018110 days in stock
SLE-0000063929 December 2025
2022 Chevrolet Tahoe Z71
Granite ChevroletVEH-0000616CertifiedCertified RetailTrade
Sale price
$23,096
Front
$5,250
Back
$282
Total
$5,533
Source: Service Lane OpportunitySalesperson: EMP-0000631 days in stock
SLE-0000064029 December 2025
2026 Subaru Ascent Base
Granite SubaruVEH-0000790NewLease
Sale price
$37,790
Front
$444
Back
$1,556
Total
$2,000
Source: Paid Search BrandSalesperson: EMP-0001697 days in stock
SLE-0000064129 December 2025
2024 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000818NewNew Retail
Sale price
$36,969
Front
$1,595
Back
$967
Total
$2,563
Walk-in or unattributedSalesperson: EMP-0001225 days in stock
SLE-0000064230 December 2025
2016 Chevrolet Malibu LS
Granite ChevroletVEH-0000179UsedUsed Retail
Sale price
$3,240
Front
-$306loss
Back
$808
Total
$502
Walk-in or unattributedSalesperson: EMP-0000321 days in stock
SLE-0000064330 December 2025
2021 Chevrolet Equinox LT
Granite Pre-OwnedVEH-0000236UsedUsed Retail
Sale price
$18,514
Front
$3,606
Back
$976
Total
$4,582
Source: Third-Party Trade Valuation PortalSalesperson: EMP-0002685 days in stock
SLE-0000064430 December 2025
2024 Chevrolet Camaro 1LT
Granite ChevroletVEH-0000484UsedUsed RetailTrade
Sale price
$36,265
Front
$7,437
Back
$1,269
Total
$8,706
Walk-in or unattributedSalesperson: EMP-0000729 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-00000620	VEH-0000393	Walk-in or unattributed	EMP-00012	EMP-00001	Unattributed
SLE-00000621	VEH-0000466	Showroom Walk-in	EMP-00015	EMP-00014	EMP-00017
SLE-00000622	VEH-0000636	Dealer Website Chat	EMP-00012	EMP-00002	EMP-00005
SLE-00000623	VEH-0000671	Showroom Walk-in	EMP-00016	EMP-00013	Unattributed
SLE-00000624	VEH-0000673	Customer Referral	EMP-00029	EMP-00030	EMP-00028
SLE-00000625	VEH-0000759	Showroom Walk-in	EMP-00016	EMP-00014	EMP-00017
SLE-00000626	VEH-0000802	Organic Search Landing	EMP-00016	EMP-00023	EMP-00017
SLE-00000627	VEH-0000138	Walk-in or unattributed	EMP-00025	EMP-00024	Unattributed
SLE-00000628	VEH-0000307	Paid Search Brand	EMP-00016	EMP-00023	EMP-00017
SLE-00000629	VEH-0000586	Walk-in or unattributed	EMP-00016	EMP-00013	EMP-00017
SLE-00000630	VEH-0000226	Service Lane Opportunity	EMP-00016	EMP-00023	EMP-00017
SLE-00000631	VEH-0000363	Walk-in or unattributed	EMP-00027	EMP-00030	EMP-00028
SLE-00000632	VEH-0000474	Paid Search Brand	EMP-00015	EMP-00014	EMP-00017
SLE-00000633	VEH-0000615	Dealer Website Form	EMP-00016	EMP-00014	EMP-00017
SLE-00000634	VEH-0000801	Showroom Walk-in	EMP-00016	EMP-00013	Unattributed
SLE-00000635	VEH-0000034	Dealer Website Chat	EMP-00003	EMP-00002	Unattributed
SLE-00000636	VEH-0000167	Community Partner Referral	EMP-00012	EMP-00008	EMP-00005
SLE-00000637	VEH-0000203	Customer Referral	EMP-00010	EMP-00002	EMP-00005
SLE-00000638	VEH-0000205	Walk-in or unattributed	EMP-00018	EMP-00014	EMP-00017
SLE-00000639	VEH-0000616	Service Lane Opportunity	EMP-00006	EMP-00008	EMP-00005
SLE-00000640	VEH-0000790	Paid Search Brand	EMP-00016	EMP-00013	EMP-00017
SLE-00000641	VEH-0000818	Walk-in or unattributed	EMP-00012	EMP-00002	EMP-00005
SLE-00000642	VEH-0000179	Walk-in or unattributed	EMP-00003	EMP-00001	Unattributed
SLE-00000643	VEH-0000236	Third-Party Trade Valuation Portal	EMP-00026	EMP-00024	EMP-00028
SLE-00000644	VEH-0000484	Walk-in or unattributed	EMP-00007	EMP-00001	EMP-00005

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.