Deal Explorer

97 deals · All three stores · October 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-10Remove 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

October 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: 97; Matching the current filters
Retail units: 80; 17 matched transactions are not retail
Total gross: $256,409; Retail rows only

Front gross: $151,720
Back gross: $104,689
Closed at a front loss: 28

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-00000430	24 October 2025	Granite Chevrolet	2025 Chevrolet Blazer EV LTNew	New Retail	$37,318	$1,768	$1,095	$2,863	17
SLE-00000421	23 October 2025	Granite Pre-Owned	2020 Ford F-150 XLTUsed	Wholesalenot retail	$10,240	-$709loss	$0	-$709	41
SLE-00000422	23 October 2025	Granite Chevrolet	2024 Chevrolet Traverse LTNew	New Retail	$35,527	-$979loss	$2,138	$1,159	61
SLE-00000423	23 October 2025	Granite Pre-Owned	2026 Chevrolet Traverse High CountryUsed	Wholesalenot retail	$32,267	-$3,444loss	$0	-$3,444	19
SLE-00000424	23 October 2025	Granite Subaru	2018 Subaru Outback LimitedUsed	Used Retail	$7,132	$146	$1,618	$1,764	69
SLE-00000425	23 October 2025	Granite Pre-Owned	2024 Chrysler Pacifica Hybrid SelectUsed	Wholesalenot retail	$23,787	-$2,981loss	$0	-$2,981	55
SLE-00000426	23 October 2025	Granite Chevrolet	2024 Chevrolet Silverado EV RSTNew	Lease	$43,516	$895	$1,616	$2,512	7
SLE-00000417	22 October 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSNew	Dealer Tradenot retail	$36,251	-$927loss	$0	-$927	55
SLE-00000418	22 October 2025	Granite Pre-Owned	2022 Chevrolet Bolt EUV PremierUsed	Used Retail	$13,951	$835	$648	$1,483	132
SLE-00000419	22 October 2025	Granite Pre-Owned	2022 Hyundai Tucson LimitedUsed	Used Retail	$21,511	$2,077	$591	$2,668	5
SLE-00000420	22 October 2025	Granite Subaru	2020 Ford Escape TitaniumUsed	Used Retail	$9,095	$438	$145	$584	22
SLE-00000414	21 October 2025	Granite Subaru	2016 Subaru Legacy BaseUsed	Used Retail	$3,911	$163	$1,066	$1,230	21
SLE-00000415	21 October 2025	Granite Subaru	2016 Toyota Camry SEUsed	Used Retail	$4,238	$309	$876	$1,185	26
SLE-00000416	21 October 2025	Granite Chevrolet	2022 Chevrolet Tahoe LTUsed	Used Retail	$20,162	$3,948	$2,879	$6,827	149
SLE-00000413	20 October 2025	Granite Pre-Owned	2016 Volkswagen Jetta SELUsed	Dealer Tradenot retail	$2,520	-$354loss	$0	-$354	19
SLE-00000410	18 October 2025	Granite Subaru	2020 Subaru Outback Onyx Edition XTUsed	Used Retail	$10,821	$1,654	$2,546	$4,200	25
SLE-00000411	18 October 2025	Granite Pre-Owned	2026 Chevrolet Colorado WTUsed	Used Retail	$52,808	$11,145	$1,513	$12,659	15
SLE-00000412	18 October 2025	Granite Chevrolet	2026 Chevrolet Silverado EV RSTNew	Lease	$45,653	$307	$491	$798	15
SLE-00000406	17 October 2025	Granite Chevrolet	2018 Subaru Outback LimitedUsed	Used Retail	$3,990	$72	$724	$797	10
SLE-00000407	17 October 2025	Granite Chevrolet	2024 Chevrolet Traverse LTNew	New Retail	$37,181	$1,149	$1,695	$2,844	45
SLE-00000408	17 October 2025	Granite Pre-Owned	2024 Ford F-150 XLUsed	Used Retail	$32,765	$4,188	$585	$4,773	53
SLE-00000409	17 October 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	New Retail	$36,328	-$1,157loss	$591	-$566	46
SLE-00000402	16 October 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSNew	New Retail	$33,783	-$2,153loss	$1,782	-$372	147
SLE-00000403	16 October 2025	Granite Chevrolet	2025 Chevrolet Blazer EV LTNew	Lease	$36,516	-$272loss	$1,045	$773	55
SLE-00000404	16 October 2025	Granite Chevrolet	2026 Chevrolet Blazer EV LTNew	New Retail	$37,427	-$104loss	$642	$538	65

SLE-0000043024 October 2025
2025 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000747NewNew Retail
Sale price
$37,318
Front
$1,768
Back
$1,095
Total
$2,863
Source: Email Marketing ResponseSalesperson: EMP-0000317 days in stock
SLE-0000042123 October 2025
2020 Ford F-150 XLT
Granite Pre-OwnedVEH-0000020UsedWholesale
Sale price
$10,240
Front
-$709loss
Back
$0
Total
-$709
Walk-in or unattributedSalesperson: EMP-0002741 days in stock
SLE-0000042223 October 2025
2024 Chevrolet Traverse LT
Granite ChevroletVEH-0000227NewNew Retail
Sale price
$35,527
Front
-$979loss
Back
$2,138
Total
$1,159
Walk-in or unattributedSalesperson: EMP-0000761 days in stock
SLE-0000042323 October 2025
2026 Chevrolet Traverse High Country
Granite Pre-OwnedVEH-0000396UsedWholesale
Sale price
$32,267
Front
-$3,444loss
Back
$0
Total
-$3,444
Walk-in or unattributedSalesperson: EMP-0002619 days in stock
SLE-0000042423 October 2025
2018 Subaru Outback Limited
Granite SubaruVEH-0000628UsedUsed RetailTrade
Sale price
$7,132
Front
$146
Back
$1,618
Total
$1,764
Walk-in or unattributedSalesperson: EMP-0001869 days in stock
SLE-0000042523 October 2025
2024 Chrysler Pacifica Hybrid Select
Granite Pre-OwnedVEH-0000734UsedWholesale
Sale price
$23,787
Front
-$2,981loss
Back
$0
Total
-$2,981
Walk-in or unattributedSalesperson: EMP-0002555 days in stock
SLE-0000042623 October 2025
2024 Chevrolet Silverado EV RST
Granite ChevroletVEH-0000800NewLease
Sale price
$43,516
Front
$895
Back
$1,616
Total
$2,512
Source: Customer ReferralSalesperson: EMP-000067 days in stock
SLE-0000041722 October 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000052NewDealer Trade
Sale price
$36,251
Front
-$927loss
Back
$0
Total
-$927
Walk-in or unattributedSalesperson: EMP-0000355 days in stock
SLE-0000041822 October 2025
2022 Chevrolet Bolt EUV Premier
Granite Pre-OwnedVEH-0000359UsedUsed Retail
Sale price
$13,951
Front
$835
Back
$648
Total
$1,483
Walk-in or unattributedSalesperson: EMP-00027132 days in stock
SLE-0000041922 October 2025
2022 Hyundai Tucson Limited
Granite Pre-OwnedVEH-0000365UsedUsed RetailTrade
Sale price
$21,511
Front
$2,077
Back
$591
Total
$2,668
Source: Showroom Walk-inSalesperson: EMP-000265 days in stock
SLE-0000042022 October 2025
2020 Ford Escape Titanium
Granite SubaruVEH-0000532UsedUsed Retail
Sale price
$9,095
Front
$438
Back
$145
Total
$584
Source: Service Lane OpportunitySalesperson: EMP-0001522 days in stock
SLE-0000041421 October 2025
2016 Subaru Legacy Base
Granite SubaruVEH-0000004UsedUsed RetailTrade
Sale price
$3,911
Front
$163
Back
$1,066
Total
$1,230
Source: Service Lane OpportunitySalesperson: EMP-0001621 days in stock
SLE-0000041521 October 2025
2016 Toyota Camry SE
Granite SubaruVEH-0000077UsedUsed Retail
Sale price
$4,238
Front
$309
Back
$876
Total
$1,185
Source: Paid Search BrandSalesperson: EMP-0001826 days in stock
SLE-0000041621 October 2025
2022 Chevrolet Tahoe LT
Granite ChevroletVEH-0000527UsedUsed RetailTrade
Sale price
$20,162
Front
$3,948
Back
$2,879
Total
$6,827
Walk-in or unattributedSalesperson: EMP-00006149 days in stock
SLE-0000041320 October 2025
2016 Volkswagen Jetta SEL
Granite Pre-OwnedVEH-0000334UsedDealer Trade
Sale price
$2,520
Front
-$354loss
Back
$0
Total
-$354
Walk-in or unattributedSalesperson: EMP-0002919 days in stock
SLE-0000041018 October 2025
2020 Subaru Outback Onyx Edition XT
Granite SubaruVEH-0000188UsedUsed RetailTrade
Sale price
$10,821
Front
$1,654
Back
$2,546
Total
$4,200
Source: Repeat Customer OutreachSalesperson: EMP-0001625 days in stock
SLE-0000041118 October 2025
2026 Chevrolet Colorado WT
Granite Pre-OwnedVEH-0000804UsedUsed Retail
Sale price
$52,808
Front
$11,145
Back
$1,513
Total
$12,659
Source: Showroom Walk-inSalesperson: EMP-0002715 days in stock
SLE-0000041218 October 2025
2026 Chevrolet Silverado EV RST
Granite ChevroletVEH-0000881NewLease
Sale price
$45,653
Front
$307
Back
$491
Total
$798
Source: Customer ReferralSalesperson: EMP-0000615 days in stock
SLE-0000040617 October 2025
2018 Subaru Outback Limited
Granite ChevroletVEH-0000493UsedUsed RetailTrade
Sale price
$3,990
Front
$72
Back
$724
Total
$797
Source: Customer ReferralSalesperson: EMP-0000610 days in stock
SLE-0000040717 October 2025
2024 Chevrolet Traverse LT
Granite ChevroletVEH-0000498NewNew Retail
Sale price
$37,181
Front
$1,149
Back
$1,695
Total
$2,844
Source: Organic Search LandingSalesperson: EMP-0000645 days in stock
SLE-0000040817 October 2025
2024 Ford F-150 XL
Granite Pre-OwnedVEH-0000641UsedUsed Retail
Sale price
$32,765
Front
$4,188
Back
$585
Total
$4,773
Source: Showroom Walk-inSalesperson: EMP-0002653 days in stock
SLE-0000040917 October 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000870NewNew Retail
Sale price
$36,328
Front
-$1,157loss
Back
$591
Total
-$566
Source: Customer ReferralSalesperson: EMP-0001646 days in stock
SLE-0000040216 October 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000118NewNew Retail
Sale price
$33,783
Front
-$2,153loss
Back
$1,782
Total
-$372
Source: Paid Search BrandSalesperson: EMP-00010147 days in stock
SLE-0000040316 October 2025
2025 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000233NewLeaseTrade
Sale price
$36,516
Front
-$272loss
Back
$1,045
Total
$773
Source: Showroom Walk-inSalesperson: EMP-0000355 days in stock
SLE-0000040416 October 2025
2026 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000625NewNew RetailTrade
Sale price
$37,427
Front
-$104loss
Back
$642
Total
$538
Source: Showroom Walk-inSalesperson: EMP-0000665 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-00000430	VEH-0000747	Email Marketing Response	EMP-00003	EMP-00001	EMP-00005
SLE-00000421	VEH-0000020	Walk-in or unattributed	EMP-00027	EMP-00024	Unattributed
SLE-00000422	VEH-0000227	Walk-in or unattributed	EMP-00007	EMP-00002	EMP-00005
SLE-00000423	VEH-0000396	Walk-in or unattributed	EMP-00026	EMP-00024	Unattributed
SLE-00000424	VEH-0000628	Walk-in or unattributed	EMP-00018	EMP-00023	EMP-00017
SLE-00000425	VEH-0000734	Walk-in or unattributed	EMP-00025	EMP-00024	Unattributed
SLE-00000426	VEH-0000800	Customer Referral	EMP-00006	EMP-00002	EMP-00005
SLE-00000417	VEH-0000052	Walk-in or unattributed	EMP-00003	EMP-00008	Unattributed
SLE-00000418	VEH-0000359	Walk-in or unattributed	EMP-00027	EMP-00030	EMP-00028
SLE-00000419	VEH-0000365	Showroom Walk-in	EMP-00026	EMP-00024	EMP-00028
SLE-00000420	VEH-0000532	Service Lane Opportunity	EMP-00015	EMP-00023	EMP-00017
SLE-00000414	VEH-0000004	Service Lane Opportunity	EMP-00016	EMP-00023	EMP-00017
SLE-00000415	VEH-0000077	Paid Search Brand	EMP-00018	EMP-00013	EMP-00017
SLE-00000416	VEH-0000527	Walk-in or unattributed	EMP-00006	EMP-00002	EMP-00005
SLE-00000413	VEH-0000334	Walk-in or unattributed	EMP-00029	EMP-00024	Unattributed
SLE-00000410	VEH-0000188	Repeat Customer Outreach	EMP-00016	EMP-00013	EMP-00017
SLE-00000411	VEH-0000804	Showroom Walk-in	EMP-00027	EMP-00024	EMP-00028
SLE-00000412	VEH-0000881	Customer Referral	EMP-00006	EMP-00008	EMP-00005
SLE-00000406	VEH-0000493	Customer Referral	EMP-00006	EMP-00002	EMP-00005
SLE-00000407	VEH-0000498	Organic Search Landing	EMP-00006	EMP-00002	EMP-00005
SLE-00000408	VEH-0000641	Showroom Walk-in	EMP-00026	EMP-00030	EMP-00028
SLE-00000409	VEH-0000870	Customer Referral	EMP-00016	EMP-00023	EMP-00017
SLE-00000402	VEH-0000118	Paid Search Brand	EMP-00010	EMP-00002	EMP-00005
SLE-00000403	VEH-0000233	Showroom Walk-in	EMP-00003	EMP-00008	EMP-00005
SLE-00000404	VEH-0000625	Showroom Walk-in	EMP-00006	EMP-00008	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.