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-00000278	6 September 2025	Granite Subaru	2016 Subaru Legacy BaseUsed	Used Retail	$3,952	-$105loss	$1,006	$901	38
SLE-00000279	6 September 2025	Granite Chevrolet	2024 Chevrolet Traverse LTNew	New Retail	$36,689	$1,831	$2,073	$3,904	60
SLE-00000280	8 September 2025	Granite Chevrolet	2019 Dodge Charger R/TUsed	Used Retail	$6,655	$399	$1,600	$1,999	62
SLE-00000281	8 September 2025	Granite Chevrolet	2026 Chevrolet Colorado WTNew	New Retail	$48,042	$1,022	$1,942	$2,964	144
SLE-00000282	8 September 2025	Granite Subaru	2025 Subaru Impreza SportNew	New Retail	$23,062	$243	$1,788	$2,031	11
SLE-00000283	8 September 2025	Granite Chevrolet	2024 Chevrolet Blazer EV LTNew	New Retail	$33,894	-$281loss	$1,743	$1,462	186
SLE-00000284	9 September 2025	Granite Chevrolet	2022 Chevrolet Tahoe LTUsed	Used Retail	$25,757	$5,153	$715	$5,868	116
SLE-00000285	9 September 2025	Granite Pre-Owned	2016 Jeep Grand Cherokee LaredoUsed	Used Retail	$4,721	$284	$1,284	$1,569	75
SLE-00000286	10 September 2025	Granite Pre-Owned	2026 Subaru Ascent Onyx EditionUsed	Dealer Tradenot retail	$37,780	$2,115	$0	$2,115	83
SLE-00000287	10 September 2025	Granite Pre-Owned	2023 Ford Bronco Sport Big BendUsed	Used Retail	$18,722	$2,147	$326	$2,473	126
SLE-00000288	11 September 2025	Granite Chevrolet	2026 Chevrolet Colorado WTNew	New Retail	$47,123	$1,321	$810	$2,131	139
SLE-00000289	11 September 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	New Retail	$37,478	-$93loss	$1,624	$1,530	58
SLE-00000290	11 September 2025	Granite Pre-Owned	2024 Jeep Wrangler RubiconUsed	Used Retail	$36,473	$8,174	$1,460	$9,634	72
SLE-00000291	11 September 2025	Granite Pre-Owned	2023 Audi Q5 PremiumUsed	Used Retail	$35,882	$5,506	$1,073	$6,579	19
SLE-00000292	11 September 2025	Granite Chevrolet	2024 Chevrolet Silverado EV RSTCertified	Certified Retail	$43,581	$9,862	$2,249	$12,111	37
SLE-00000293	12 September 2025	Granite Subaru	2025 Subaru Impreza BaseNew	Lease	$22,909	-$335loss	$1,205	$869	99
SLE-00000294	12 September 2025	Granite Subaru	2025 Subaru Ascent Onyx EditionCertified	Certified Retail	$46,753	$10,352	$1,782	$12,135	8
SLE-00000295	12 September 2025	Granite Subaru	2016 Volkswagen Jetta SUsed	Wholesalenot retail	$2,164	-$1,052loss	$0	-$1,052	71
SLE-00000296	13 September 2025	Granite Subaru	2025 Subaru Impreza BaseCertified	Dealer Tradenot retail	$18,352	-$1,799loss	$0	-$1,799	85
SLE-00000297	13 September 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSUsed	Wholesalenot retail	$28,567	-$3,062loss	$0	-$3,062	38
SLE-00000298	13 September 2025	Granite Pre-Owned	2023 Dodge Charger SXTUsed	Used Retail	$25,892	$4,564	$1,226	$5,789	28
SLE-00000299	13 September 2025	Granite Chevrolet	2026 Chevrolet Colorado Z71New	Lease	$45,212	$307	$1,259	$1,566	10
SLE-00000300	14 September 2025	Granite Pre-Owned	2017 Toyota RAV4 XLEUsed	Used Retail	$7,463	$1,134	$1,103	$2,237	11
SLE-00000301	15 September 2025	Granite Subaru	2020 Subaru Outback Onyx Edition XTCertified	Certified Retail	$10,605	$1,674	$1,175	$2,849	55
SLE-00000302	15 September 2025	Granite Chevrolet	2024 Chevrolet Silverado EV RSTCertified	Certified Retail	$42,264	$7,079	$568	$7,646	5

SLE-000002786 September 2025
2016 Subaru Legacy Base
Granite SubaruVEH-0000704UsedUsed Retail
Sale price
$3,952
Front
-$105loss
Back
$1,006
Total
$901
Source: Paid Search Non-BrandSalesperson: EMP-0001638 days in stock
SLE-000002796 September 2025
2024 Chevrolet Traverse LT
Granite ChevroletVEH-0000885NewNew Retail
Sale price
$36,689
Front
$1,831
Back
$2,073
Total
$3,904
Source: Service Lane OpportunitySalesperson: EMP-0000360 days in stock
SLE-000002808 September 2025
2019 Dodge Charger R/T
Granite ChevroletVEH-0000070UsedUsed RetailTrade
Sale price
$6,655
Front
$399
Back
$1,600
Total
$1,999
Source: Organic Search LandingSalesperson: EMP-0000362 days in stock
SLE-000002818 September 2025
2026 Chevrolet Colorado WT
Granite ChevroletVEH-0000533NewNew Retail
Sale price
$48,042
Front
$1,022
Back
$1,942
Total
$2,964
Walk-in or unattributedSalesperson: EMP-00010144 days in stock
SLE-000002828 September 2025
2025 Subaru Impreza Sport
Granite SubaruVEH-0000875NewNew RetailTrade
Sale price
$23,062
Front
$243
Back
$1,788
Total
$2,031
Walk-in or unattributedSalesperson: EMP-0001611 days in stock
SLE-000002838 September 2025
2024 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000897NewNew RetailTrade
Sale price
$33,894
Front
-$281loss
Back
$1,743
Total
$1,462
Source: Community Partner ReferralSalesperson: EMP-00003186 days in stock
SLE-000002849 September 2025
2022 Chevrolet Tahoe LT
Granite ChevroletVEH-0000402UsedUsed RetailTrade
Sale price
$25,757
Front
$5,153
Back
$715
Total
$5,868
Source: Customer ReferralSalesperson: EMP-00007116 days in stock
SLE-000002859 September 2025
2016 Jeep Grand Cherokee Laredo
Granite Pre-OwnedVEH-0000797UsedUsed RetailTrade
Sale price
$4,721
Front
$284
Back
$1,284
Total
$1,569
Source: Showroom Walk-inSalesperson: EMP-0002575 days in stock
SLE-0000028610 September 2025
2026 Subaru Ascent Onyx Edition
Granite Pre-OwnedVEH-0000316UsedDealer Trade
Sale price
$37,780
Front
$2,115
Back
$0
Total
$2,115
Walk-in or unattributedSalesperson: EMP-0002683 days in stock
SLE-0000028710 September 2025
2023 Ford Bronco Sport Big Bend
Granite Pre-OwnedVEH-0000375UsedUsed Retail
Sale price
$18,722
Front
$2,147
Back
$326
Total
$2,473
Source: Showroom Walk-inSalesperson: EMP-00027126 days in stock
SLE-0000028811 September 2025
2026 Chevrolet Colorado WT
Granite ChevroletVEH-0000125NewNew RetailTrade
Sale price
$47,123
Front
$1,321
Back
$810
Total
$2,131
Source: Service Lane OpportunitySalesperson: EMP-00010139 days in stock
SLE-0000028911 September 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000214NewNew Retail
Sale price
$37,478
Front
-$93loss
Back
$1,624
Total
$1,530
Source: Showroom Walk-inSalesperson: EMP-0001858 days in stock
SLE-0000029011 September 2025
2024 Jeep Wrangler Rubicon
Granite Pre-OwnedVEH-0000242UsedUsed RetailTrade
Sale price
$36,473
Front
$8,174
Back
$1,460
Total
$9,634
Source: Paid Search BrandSalesperson: EMP-0002972 days in stock
SLE-0000029111 September 2025
2023 Audi Q5 Premium
Granite Pre-OwnedVEH-0000383UsedUsed Retail
Sale price
$35,882
Front
$5,506
Back
$1,073
Total
$6,579
Walk-in or unattributedSalesperson: EMP-0002619 days in stock
SLE-0000029211 September 2025
2024 Chevrolet Silverado EV RST
Granite ChevroletVEH-0000622CertifiedCertified Retail
Sale price
$43,581
Front
$9,862
Back
$2,249
Total
$12,111
Source: Service Lane OpportunitySalesperson: EMP-0000637 days in stock
SLE-0000029312 September 2025
2025 Subaru Impreza Base
Granite SubaruVEH-0000049NewLease
Sale price
$22,909
Front
-$335loss
Back
$1,205
Total
$869
Source: Dealer Website FormSalesperson: EMP-0001699 days in stock
SLE-0000029412 September 2025
2025 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000291CertifiedCertified Retail
Sale price
$46,753
Front
$10,352
Back
$1,782
Total
$12,135
Source: Customer ReferralSalesperson: EMP-000158 days in stock
SLE-0000029512 September 2025
2016 Volkswagen Jetta S
Granite SubaruVEH-0000517UsedWholesale
Sale price
$2,164
Front
-$1,052loss
Back
$0
Total
-$1,052
Walk-in or unattributedSalesperson: EMP-0001871 days in stock
SLE-0000029613 September 2025
2025 Subaru Impreza Base
Granite SubaruVEH-0000280CertifiedDealer Trade
Sale price
$18,352
Front
-$1,799loss
Back
$0
Total
-$1,799
Walk-in or unattributedSalesperson: EMP-0001685 days in stock
SLE-0000029713 September 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000310UsedWholesale
Sale price
$28,567
Front
-$3,062loss
Back
$0
Total
-$3,062
Walk-in or unattributedSalesperson: EMP-0000638 days in stock
SLE-0000029813 September 2025
2023 Dodge Charger SXT
Granite Pre-OwnedVEH-0000399UsedUsed RetailTrade
Sale price
$25,892
Front
$4,564
Back
$1,226
Total
$5,789
Source: Dealer Website FormSalesperson: EMP-0002628 days in stock
SLE-0000029913 September 2025
2026 Chevrolet Colorado Z71
Granite ChevroletVEH-0000447NewLease
Sale price
$45,212
Front
$307
Back
$1,259
Total
$1,566
Walk-in or unattributedSalesperson: EMP-0000310 days in stock
SLE-0000030014 September 2025
2017 Toyota RAV4 XLE
Granite Pre-OwnedVEH-0000109UsedUsed RetailTrade
Sale price
$7,463
Front
$1,134
Back
$1,103
Total
$2,237
Source: Direct Mail ResponseSalesperson: EMP-0002611 days in stock
SLE-0000030115 September 2025
2020 Subaru Outback Onyx Edition XT
Granite SubaruVEH-0000141CertifiedCertified RetailTrade
Sale price
$10,605
Front
$1,674
Back
$1,175
Total
$2,849
Walk-in or unattributedSalesperson: EMP-0001555 days in stock
SLE-0000030215 September 2025
2024 Chevrolet Silverado EV RST
Granite ChevroletVEH-0000305CertifiedCertified RetailTrade
Sale price
$42,264
Front
$7,079
Back
$568
Total
$7,646
Source: Showroom Walk-inSalesperson: EMP-000075 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-00000278	VEH-0000704	Paid Search Non-Brand	EMP-00016	EMP-00023	Unattributed
SLE-00000279	VEH-0000885	Service Lane Opportunity	EMP-00003	EMP-00008	EMP-00005
SLE-00000280	VEH-0000070	Organic Search Landing	EMP-00003	EMP-00008	EMP-00005
SLE-00000281	VEH-0000533	Walk-in or unattributed	EMP-00010	EMP-00002	EMP-00005
SLE-00000282	VEH-0000875	Walk-in or unattributed	EMP-00016	EMP-00014	EMP-00017
SLE-00000283	VEH-0000897	Community Partner Referral	EMP-00003	EMP-00001	EMP-00005
SLE-00000284	VEH-0000402	Customer Referral	EMP-00007	EMP-00002	EMP-00005
SLE-00000285	VEH-0000797	Showroom Walk-in	EMP-00025	EMP-00030	EMP-00028
SLE-00000286	VEH-0000316	Walk-in or unattributed	EMP-00026	EMP-00024	Unattributed
SLE-00000287	VEH-0000375	Showroom Walk-in	EMP-00027	EMP-00024	EMP-00028
SLE-00000288	VEH-0000125	Service Lane Opportunity	EMP-00010	EMP-00008	EMP-00005
SLE-00000289	VEH-0000214	Showroom Walk-in	EMP-00018	EMP-00013	EMP-00017
SLE-00000290	VEH-0000242	Paid Search Brand	EMP-00029	EMP-00024	EMP-00028
SLE-00000291	VEH-0000383	Walk-in or unattributed	EMP-00026	EMP-00024	EMP-00028
SLE-00000292	VEH-0000622	Service Lane Opportunity	EMP-00006	EMP-00008	EMP-00005
SLE-00000293	VEH-0000049	Dealer Website Form	EMP-00016	EMP-00014	EMP-00017
SLE-00000294	VEH-0000291	Customer Referral	EMP-00015	EMP-00013	EMP-00017
SLE-00000295	VEH-0000517	Walk-in or unattributed	EMP-00018	EMP-00013	Unattributed
SLE-00000296	VEH-0000280	Walk-in or unattributed	EMP-00016	EMP-00023	Unattributed
SLE-00000297	VEH-0000310	Walk-in or unattributed	EMP-00006	EMP-00002	Unattributed
SLE-00000298	VEH-0000399	Dealer Website Form	EMP-00026	EMP-00024	EMP-00028
SLE-00000299	VEH-0000447	Walk-in or unattributed	EMP-00003	EMP-00008	EMP-00005
SLE-00000300	VEH-0000109	Direct Mail Response	EMP-00026	EMP-00030	EMP-00028
SLE-00000301	VEH-0000141	Walk-in or unattributed	EMP-00015	EMP-00014	EMP-00017
SLE-00000302	VEH-0000305	Showroom Walk-in	EMP-00007	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.