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-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-00000598	18 December 2025	Granite Subaru	2025 Subaru Ascent Onyx EditionNew	New Retail	$36,421	$484	$2,140	$2,625	122
SLE-00000599	18 December 2025	Granite Subaru	2024 Chevrolet Silverado EV RSTUsed	Used Retail	$39,654	$7,967	$797	$8,764	38
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-00000603	19 December 2025	Granite Subaru	2023 Volkswagen Atlas SELUsed	Dealer Tradenot retail	$22,653	-$758loss	$0	-$758	31
SLE-00000604	19 December 2025	Granite Pre-Owned	2021 RAM 1500 TradesmanUsed	Wholesalenot retail	$14,782	-$1,567loss	$0	-$1,567	48
SLE-00000605	19 December 2025	Granite Pre-Owned	2018 Honda Odyssey TouringUsed	Used Retail	$6,854	$898	$1,063	$1,961	115
SLE-00000606	19 December 2025	Granite Pre-Owned	2016 Jeep Grand Cherokee LaredoUsed	Used Retail	$4,583	$155	$1,535	$1,690	74
SLE-00000607	19 December 2025	Granite Pre-Owned	2023 Chevrolet Equinox PremierUsed	Used Retail	$27,039	$5,141	$535	$5,677	9
SLE-00000608	19 December 2025	Granite Subaru	2025 Subaru Impreza BaseNew	New Retail	$23,178	-$903loss	$2,205	$1,302	69
SLE-00000609	20 December 2025	Granite Chevrolet	2026 Chevrolet Colorado WTNew	Lease	$47,299	$3,968	$955	$4,923	38
SLE-00000610	20 December 2025	Granite Pre-Owned	2018 Hyundai Tucson SEUsed	Used Retail	$7,046	$1,151	$652	$1,803	43
SLE-00000611	20 December 2025	Granite Chevrolet	2026 Chevrolet Colorado WTNew	Wholesalenot retail	$39,661	-$5,885loss	$0	-$5,885	24
SLE-00000612	20 December 2025	Granite Subaru	2024 Subaru Impreza RSNew	New Retail	$22,179	-$195loss	$1,039	$844	66
SLE-00000613	22 December 2025	Granite Chevrolet	2024 Chevrolet Silverado EV RSTNew	Lease	$45,295	$1,701	$598	$2,298	41
SLE-00000614	23 December 2025	Granite Subaru	2020 Subaru Outback Onyx Edition XTCertified	Certified Retail	$13,655	$2,169	$1,062	$3,231	24
SLE-00000615	23 December 2025	Granite Subaru	2024 Subaru Impreza RSNew	New Retail	$22,221	$141	$558	$699	48
SLE-00000616	23 December 2025	Granite Subaru	2024 Subaru Impreza RSNew	New Retail	$23,130	$496	$1,328	$1,824	42
SLE-00000617	23 December 2025	Granite Chevrolet	2024 Chevrolet Silverado EV RSTNew	New Retail	$46,319	$2,600	$735	$3,335	34
SLE-00000618	24 December 2025	Granite Chevrolet	2025 Chevrolet Tahoe LTNew	New Retail	$37,477	$713	$1,937	$2,650	105
SLE-00000619	24 December 2025	Granite Chevrolet	2022 Chevrolet Camaro ZL1Certified	Certified Retail	$28,258	$6,236	$1,850	$8,086	36

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-0000059818 December 2025
2025 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000010NewNew RetailTrade
Sale price
$36,421
Front
$484
Back
$2,140
Total
$2,625
Walk-in or unattributedSalesperson: EMP-00015122 days in stock
SLE-0000059918 December 2025
2024 Chevrolet Silverado EV RST
Granite SubaruVEH-0000335UsedUsed Retail
Sale price
$39,654
Front
$7,967
Back
$797
Total
$8,764
Source: Dealer Website ChatSalesperson: EMP-0001538 days in stock
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-0000060319 December 2025
2023 Volkswagen Atlas SEL
Granite SubaruVEH-0000033UsedDealer Trade
Sale price
$22,653
Front
-$758loss
Back
$0
Total
-$758
Walk-in or unattributedSalesperson: EMP-0001531 days in stock
SLE-0000060419 December 2025
2021 RAM 1500 Tradesman
Granite Pre-OwnedVEH-0000217UsedWholesale
Sale price
$14,782
Front
-$1,567loss
Back
$0
Total
-$1,567
Walk-in or unattributedSalesperson: EMP-0002948 days in stock
SLE-0000060519 December 2025
2018 Honda Odyssey Touring
Granite Pre-OwnedVEH-0000465UsedUsed Retail
Sale price
$6,854
Front
$898
Back
$1,063
Total
$1,961
Source: Third-Party Trade Valuation PortalSalesperson: EMP-00025115 days in stock
SLE-0000060619 December 2025
2016 Jeep Grand Cherokee Laredo
Granite Pre-OwnedVEH-0000531UsedUsed Retail
Sale price
$4,583
Front
$155
Back
$1,535
Total
$1,690
Source: Customer ReferralSalesperson: EMP-0002674 days in stock
SLE-0000060719 December 2025
2023 Chevrolet Equinox Premier
Granite Pre-OwnedVEH-0000650UsedUsed Retail
Sale price
$27,039
Front
$5,141
Back
$535
Total
$5,677
Source: Service Lane OpportunitySalesperson: EMP-000269 days in stock
SLE-0000060819 December 2025
2025 Subaru Impreza Base
Granite SubaruVEH-0000789NewNew Retail
Sale price
$23,178
Front
-$903loss
Back
$2,205
Total
$1,302
Source: Dealer Website ChatSalesperson: EMP-0001669 days in stock
SLE-0000060920 December 2025
2026 Chevrolet Colorado WT
Granite ChevroletVEH-0000264NewLease
Sale price
$47,299
Front
$3,968
Back
$955
Total
$4,923
Source: Showroom Walk-inSalesperson: EMP-0000638 days in stock
SLE-0000061020 December 2025
2018 Hyundai Tucson SE
Granite Pre-OwnedVEH-0000418UsedUsed Retail
Sale price
$7,046
Front
$1,151
Back
$652
Total
$1,803
Source: Customer ReferralSalesperson: EMP-0002943 days in stock
SLE-0000061120 December 2025
2026 Chevrolet Colorado WT
Granite ChevroletVEH-0000698NewWholesale
Sale price
$39,661
Front
-$5,885loss
Back
$0
Total
-$5,885
Walk-in or unattributedSalesperson: EMP-0001024 days in stock
SLE-0000061220 December 2025
2024 Subaru Impreza RS
Granite SubaruVEH-0000848NewNew Retail
Sale price
$22,179
Front
-$195loss
Back
$1,039
Total
$844
Source: Service Lane OpportunitySalesperson: EMP-0001866 days in stock
SLE-0000061322 December 2025
2024 Chevrolet Silverado EV RST
Granite ChevroletVEH-0000234NewLeaseTrade
Sale price
$45,295
Front
$1,701
Back
$598
Total
$2,298
Source: Community Partner ReferralSalesperson: EMP-0000341 days in stock
SLE-0000061423 December 2025
2020 Subaru Outback Onyx Edition XT
Granite SubaruVEH-0000001CertifiedCertified Retail
Sale price
$13,655
Front
$2,169
Back
$1,062
Total
$3,231
Source: Service Lane OpportunitySalesperson: EMP-0001524 days in stock
SLE-0000061523 December 2025
2024 Subaru Impreza RS
Granite SubaruVEH-0000048NewNew RetailTrade
Sale price
$22,221
Front
$141
Back
$558
Total
$699
Source: Paid Search BrandSalesperson: EMP-0001848 days in stock
SLE-0000061623 December 2025
2024 Subaru Impreza RS
Granite SubaruVEH-0000639NewNew Retail
Sale price
$23,130
Front
$496
Back
$1,328
Total
$1,824
Source: Direct Site VisitSalesperson: EMP-0001542 days in stock
SLE-0000061723 December 2025
2024 Chevrolet Silverado EV RST
Granite ChevroletVEH-0000843NewNew RetailTrade
Sale price
$46,319
Front
$2,600
Back
$735
Total
$3,335
Source: Showroom Walk-inSalesperson: EMP-0001234 days in stock
SLE-0000061824 December 2025
2025 Chevrolet Tahoe LT
Granite ChevroletVEH-0000578NewNew Retail
Sale price
$37,477
Front
$713
Back
$1,937
Total
$2,650
Walk-in or unattributedSalesperson: EMP-00010105 days in stock
SLE-0000061924 December 2025
2022 Chevrolet Camaro ZL1
Granite ChevroletVEH-0000772CertifiedCertified Retail
Sale price
$28,258
Front
$6,236
Back
$1,850
Total
$8,086
Source: Paid Search Non-BrandSalesperson: EMP-0001036 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-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-00000598	VEH-0000010	Walk-in or unattributed	EMP-00015	EMP-00013	EMP-00017
SLE-00000599	VEH-0000335	Dealer Website Chat	EMP-00015	EMP-00023	Unattributed
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-00000603	VEH-0000033	Walk-in or unattributed	EMP-00015	EMP-00013	Unattributed
SLE-00000604	VEH-0000217	Walk-in or unattributed	EMP-00029	EMP-00024	Unattributed
SLE-00000605	VEH-0000465	Third-Party Trade Valuation Portal	EMP-00025	EMP-00030	EMP-00028
SLE-00000606	VEH-0000531	Customer Referral	EMP-00026	EMP-00024	EMP-00028
SLE-00000607	VEH-0000650	Service Lane Opportunity	EMP-00026	EMP-00030	Unattributed
SLE-00000608	VEH-0000789	Dealer Website Chat	EMP-00016	EMP-00023	EMP-00017
SLE-00000609	VEH-0000264	Showroom Walk-in	EMP-00006	EMP-00001	EMP-00005
SLE-00000610	VEH-0000418	Customer Referral	EMP-00029	EMP-00024	EMP-00028
SLE-00000611	VEH-0000698	Walk-in or unattributed	EMP-00010	EMP-00008	Unattributed
SLE-00000612	VEH-0000848	Service Lane Opportunity	EMP-00018	EMP-00013	EMP-00017
SLE-00000613	VEH-0000234	Community Partner Referral	EMP-00003	EMP-00008	EMP-00005
SLE-00000614	VEH-0000001	Service Lane Opportunity	EMP-00015	EMP-00023	EMP-00017
SLE-00000615	VEH-0000048	Paid Search Brand	EMP-00018	EMP-00013	EMP-00017
SLE-00000616	VEH-0000639	Direct Site Visit	EMP-00015	EMP-00023	EMP-00017
SLE-00000617	VEH-0000843	Showroom Walk-in	EMP-00012	EMP-00001	EMP-00005
SLE-00000618	VEH-0000578	Walk-in or unattributed	EMP-00010	EMP-00008	EMP-00005
SLE-00000619	VEH-0000772	Paid Search Non-Brand	EMP-00010	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.