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

Period: 2025-12Remove 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

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-00000600	18 December 2025	Granite Chevrolet	2022 Ford Escape SUsed	Used Retail	$12,392	$559	$1,697	$2,257	210
SLE-00000601	18 December 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	New Retail	$36,556	$265	$374	$639	139
SLE-00000602	18 December 2025	Granite Chevrolet	2026 Chevrolet Blazer 2LTNew	New Retail	$38,914	$750	$931	$1,680	2
SLE-00000593	16 December 2025	Granite Subaru	2024 Subaru Impreza RSNew	New Retail	$23,797	$930	$1,082	$2,011	57
SLE-00000594	16 December 2025	Granite Pre-Owned	2025 Chevrolet Tahoe LSUsed	Used Retail	$36,997	$6,976	$1,139	$8,114	111
SLE-00000595	16 December 2025	Granite Chevrolet	2026 Chevrolet Colorado Z71Used	Used Retail	$47,243	$6,482	$1,027	$7,509	22
SLE-00000596	16 December 2025	Granite Chevrolet	2026 Chevrolet Colorado WTNew	Lease	$50,043	$4,036	$1,715	$5,750	13
SLE-00000597	16 December 2025	Granite Pre-Owned	2024 Chevrolet Silverado EV RSTUsed	Used Retail	$40,180	$4,265	$458	$4,723	90
SLE-00000591	15 December 2025	Granite Pre-Owned	2026 Chevrolet Blazer 2LTUsed	Used Retail	$38,552	$5,591	$1,023	$6,614	42
SLE-00000592	15 December 2025	Granite Chevrolet	2026 Chevrolet Colorado WTUsed	Used Retail	$50,855	$11,592	$1,255	$12,847	109
SLE-00000587	13 December 2025	Granite Subaru	2018 Subaru Crosstrek BaseCertified	Certified Retail	$5,363	-$47loss	$1,548	$1,501	120
SLE-00000588	13 December 2025	Granite Pre-Owned	2019 Hyundai Elantra LimitedUsed	Used Retail	$6,027	$477	$819	$1,297	52
SLE-00000589	13 December 2025	Granite Chevrolet	2024 Chevrolet Blazer EV LTNew	Lease	$37,951	$2,163	$1,331	$3,494	15
SLE-00000590	13 December 2025	Granite Subaru	2025 Subaru Impreza SportUsed	Wholesalenot retail	$21,640	-$524loss	$0	-$524	81
SLE-00000581	12 December 2025	Granite Chevrolet	2023 Chevrolet Equinox LSUsed	Used Retail	$22,890	$1,885	$607	$2,492	64
SLE-00000582	12 December 2025	Granite Pre-Owned	2018 Honda Odyssey TouringUsed	Wholesalenot retail	$4,575	-$521loss	$0	-$521	120
SLE-00000583	12 December 2025	Granite Chevrolet	2025 Chevrolet Blazer EV LTNew	New Retail	$35,977	-$1,808loss	$2,195	$387	51
SLE-00000584	12 December 2025	Granite Chevrolet	2022 Chevrolet Tahoe LTUsed	Used Retail	$21,269	$3,981	$1,586	$5,567	44
SLE-00000585	12 December 2025	Granite Subaru	2025 Subaru Impreza BaseNew	Lease	$24,220	$911	$897	$1,808	23
SLE-00000586	12 December 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSNew	Lease	$37,091	$182	$1,928	$2,110	74
SLE-00000578	11 December 2025	Granite Chevrolet	2026 Chevrolet Colorado WTNew	New Retail	$44,993	$1,163	$1,727	$2,890	127
SLE-00000579	11 December 2025	Granite Chevrolet	2026 Chevrolet Blazer EV LTNew	New Retail	$36,776	$149	$1,374	$1,523	41
SLE-00000580	11 December 2025	Granite Chevrolet	2026 Chevrolet Blazer 2LTNew	New Retail	$38,026	$521	$1,606	$2,127	10
SLE-00000574	10 December 2025	Granite Subaru	2025 Subaru Impreza BaseNew	New Retail	$24,110	$492	$1,072	$1,565	111
SLE-00000575	10 December 2025	Granite Pre-Owned	2023 Dodge Charger SXTUsed	Used Retail	$23,956	$3,718	$684	$4,402	43

SLE-0000060018 December 2025
2022 Ford Escape S
Granite ChevroletVEH-0000593UsedUsed Retail
Sale price
$12,392
Front
$559
Back
$1,697
Total
$2,257
Walk-in or unattributedSalesperson: EMP-00012210 days in stock
SLE-0000060118 December 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000740NewNew Retail
Sale price
$36,556
Front
$265
Back
$374
Total
$639
Source: Organic Search LandingSalesperson: EMP-00016139 days in stock
SLE-0000060218 December 2025
2026 Chevrolet Blazer 2LT
Granite ChevroletVEH-0000767NewNew Retail
Sale price
$38,914
Front
$750
Back
$931
Total
$1,680
Source: Customer ReferralSalesperson: EMP-000122 days in stock
SLE-0000059316 December 2025
2024 Subaru Impreza RS
Granite SubaruVEH-0000153NewNew Retail
Sale price
$23,797
Front
$930
Back
$1,082
Total
$2,011
Source: Dealer Website FormSalesperson: EMP-0001557 days in stock
SLE-0000059416 December 2025
2025 Chevrolet Tahoe LS
Granite Pre-OwnedVEH-0000282UsedUsed RetailTrade
Sale price
$36,997
Front
$6,976
Back
$1,139
Total
$8,114
Source: Dealer Website FormSalesperson: EMP-00026111 days in stock
SLE-0000059516 December 2025
2026 Chevrolet Colorado Z71
Granite ChevroletVEH-0000405UsedUsed RetailTrade
Sale price
$47,243
Front
$6,482
Back
$1,027
Total
$7,509
Walk-in or unattributedSalesperson: EMP-0000722 days in stock
SLE-0000059616 December 2025
2026 Chevrolet Colorado WT
Granite ChevroletVEH-0000598NewLease
Sale price
$50,043
Front
$4,036
Back
$1,715
Total
$5,750
Source: Customer ReferralSalesperson: EMP-0001013 days in stock
SLE-0000059716 December 2025
2024 Chevrolet Silverado EV RST
Granite Pre-OwnedVEH-0000879UsedUsed Retail
Sale price
$40,180
Front
$4,265
Back
$458
Total
$4,723
Walk-in or unattributedSalesperson: EMP-0002690 days in stock
SLE-0000059115 December 2025
2026 Chevrolet Blazer 2LT
Granite Pre-OwnedVEH-0000115UsedUsed RetailTrade
Sale price
$38,552
Front
$5,591
Back
$1,023
Total
$6,614
Source: Repeat Customer OutreachSalesperson: EMP-0002542 days in stock
SLE-0000059215 December 2025
2026 Chevrolet Colorado WT
Granite ChevroletVEH-0000194UsedUsed RetailTrade
Sale price
$50,855
Front
$11,592
Back
$1,255
Total
$12,847
Source: Community Partner ReferralSalesperson: EMP-00010109 days in stock
SLE-0000058713 December 2025
2018 Subaru Crosstrek Base
Granite SubaruVEH-0000450CertifiedCertified RetailTrade
Sale price
$5,363
Front
-$47loss
Back
$1,548
Total
$1,501
Source: Paid Social Feed CampaignSalesperson: EMP-00015120 days in stock
SLE-0000058813 December 2025
2019 Hyundai Elantra Limited
Granite Pre-OwnedVEH-0000643UsedUsed Retail
Sale price
$6,027
Front
$477
Back
$819
Total
$1,297
Source: Customer ReferralSalesperson: EMP-0002752 days in stock
SLE-0000058913 December 2025
2024 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000685NewLeaseTrade
Sale price
$37,951
Front
$2,163
Back
$1,331
Total
$3,494
Walk-in or unattributedSalesperson: EMP-0001015 days in stock
SLE-0000059013 December 2025
2025 Subaru Impreza Sport
Granite SubaruVEH-0000782UsedWholesale
Sale price
$21,640
Front
-$524loss
Back
$0
Total
-$524
Walk-in or unattributedSalesperson: EMP-0001581 days in stock
SLE-0000058112 December 2025
2023 Chevrolet Equinox LS
Granite ChevroletVEH-0000023UsedUsed Retail
Sale price
$22,890
Front
$1,885
Back
$607
Total
$2,492
Source: Dealer Website FormSalesperson: EMP-0000764 days in stock
SLE-0000058212 December 2025
2018 Honda Odyssey Touring
Granite Pre-OwnedVEH-0000081UsedWholesale
Sale price
$4,575
Front
-$521loss
Back
$0
Total
-$521
Walk-in or unattributedSalesperson: EMP-00026120 days in stock
SLE-0000058312 December 2025
2025 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000168NewNew RetailTrade
Sale price
$35,977
Front
-$1,808loss
Back
$2,195
Total
$387
Source: Dealer Website ChatSalesperson: EMP-0000751 days in stock
SLE-0000058412 December 2025
2022 Chevrolet Tahoe LT
Granite ChevroletVEH-0000470UsedUsed Retail
Sale price
$21,269
Front
$3,981
Back
$1,586
Total
$5,567
Source: Showroom Walk-inSalesperson: EMP-0000344 days in stock
SLE-0000058512 December 2025
2025 Subaru Impreza Base
Granite SubaruVEH-0000489NewLeaseTrade
Sale price
$24,220
Front
$911
Back
$897
Total
$1,808
Source: Direct Site VisitSalesperson: EMP-0001823 days in stock
SLE-0000058612 December 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000868NewLease
Sale price
$37,091
Front
$182
Back
$1,928
Total
$2,110
Source: Customer ReferralSalesperson: EMP-0000674 days in stock
SLE-0000057811 December 2025
2026 Chevrolet Colorado WT
Granite ChevroletVEH-0000051NewNew RetailTrade
Sale price
$44,993
Front
$1,163
Back
$1,727
Total
$2,890
Walk-in or unattributedSalesperson: EMP-00003127 days in stock
SLE-0000057911 December 2025
2026 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000321NewNew RetailTrade
Sale price
$36,776
Front
$149
Back
$1,374
Total
$1,523
Source: Customer ReferralSalesperson: EMP-0000341 days in stock
SLE-0000058011 December 2025
2026 Chevrolet Blazer 2LT
Granite ChevroletVEH-0000766NewNew Retail
Sale price
$38,026
Front
$521
Back
$1,606
Total
$2,127
Walk-in or unattributedSalesperson: EMP-0001210 days in stock
SLE-0000057410 December 2025
2025 Subaru Impreza Base
Granite SubaruVEH-0000221NewNew RetailTrade
Sale price
$24,110
Front
$492
Back
$1,072
Total
$1,565
Source: Third-Party Marketplace ListingSalesperson: EMP-00015111 days in stock
SLE-0000057510 December 2025
2023 Dodge Charger SXT
Granite Pre-OwnedVEH-0000281UsedUsed Retail
Sale price
$23,956
Front
$3,718
Back
$684
Total
$4,402
Walk-in or unattributedSalesperson: EMP-0002543 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-00000600	VEH-0000593	Walk-in or unattributed	EMP-00012	EMP-00008	EMP-00005
SLE-00000601	VEH-0000740	Organic Search Landing	EMP-00016	EMP-00014	EMP-00017
SLE-00000602	VEH-0000767	Customer Referral	EMP-00012	EMP-00008	EMP-00005
SLE-00000593	VEH-0000153	Dealer Website Form	EMP-00015	EMP-00023	EMP-00017
SLE-00000594	VEH-0000282	Dealer Website Form	EMP-00026	EMP-00024	EMP-00028
SLE-00000595	VEH-0000405	Walk-in or unattributed	EMP-00007	EMP-00008	EMP-00005
SLE-00000596	VEH-0000598	Customer Referral	EMP-00010	EMP-00001	EMP-00005
SLE-00000597	VEH-0000879	Walk-in or unattributed	EMP-00026	EMP-00024	EMP-00028
SLE-00000591	VEH-0000115	Repeat Customer Outreach	EMP-00025	EMP-00024	EMP-00028
SLE-00000592	VEH-0000194	Community Partner Referral	EMP-00010	EMP-00008	EMP-00005
SLE-00000587	VEH-0000450	Paid Social Feed Campaign	EMP-00015	EMP-00014	EMP-00017
SLE-00000588	VEH-0000643	Customer Referral	EMP-00027	EMP-00024	EMP-00028
SLE-00000589	VEH-0000685	Walk-in or unattributed	EMP-00010	EMP-00002	EMP-00005
SLE-00000590	VEH-0000782	Walk-in or unattributed	EMP-00015	EMP-00023	Unattributed
SLE-00000581	VEH-0000023	Dealer Website Form	EMP-00007	EMP-00001	EMP-00005
SLE-00000582	VEH-0000081	Walk-in or unattributed	EMP-00026	EMP-00030	Unattributed
SLE-00000583	VEH-0000168	Dealer Website Chat	EMP-00007	EMP-00008	EMP-00005
SLE-00000584	VEH-0000470	Showroom Walk-in	EMP-00003	EMP-00001	EMP-00005
SLE-00000585	VEH-0000489	Direct Site Visit	EMP-00018	EMP-00023	EMP-00017
SLE-00000586	VEH-0000868	Customer Referral	EMP-00006	EMP-00002	EMP-00005
SLE-00000578	VEH-0000051	Walk-in or unattributed	EMP-00003	EMP-00008	EMP-00005
SLE-00000579	VEH-0000321	Customer Referral	EMP-00003	EMP-00001	EMP-00005
SLE-00000580	VEH-0000766	Walk-in or unattributed	EMP-00012	EMP-00002	EMP-00005
SLE-00000574	VEH-0000221	Third-Party Marketplace Listing	EMP-00015	EMP-00023	EMP-00017
SLE-00000575	VEH-0000281	Walk-in or unattributed	EMP-00025	EMP-00030	EMP-00028

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.