Deal Explorer

136 deals · All three stores · August 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-08Remove 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

August 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: 136; Matching the current filters
Retail units: 116; 20 matched transactions are not retail
Total gross: $353,812; Retail rows only

Front gross: $226,505
Back gross: $127,307
Closed at a front loss: 36

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-00000151	8 August 2025	Granite Pre-Owned	2020 Chrysler Pacifica LimitedUsed	Used Retail	$11,447	$892	$988	$1,880	56
SLE-00000152	8 August 2025	Granite Pre-Owned	2021 Jeep Grand Cherokee OverlandUsed	Used Retail	$16,994	$3,236	$1,333	$4,569	11
SLE-00000153	8 August 2025	Granite Chevrolet	2024 Chevrolet Blazer EV LTNew	Lease	$34,315	-$599loss	$1,252	$653	148
SLE-00000154	8 August 2025	Granite Subaru	2025 Subaru Impreza BaseCertified	Certified Retail	$22,878	$3,083	$1,287	$4,370	32
SLE-00000155	8 August 2025	Granite Pre-Owned	2024 Jeep Wrangler SportUsed	Used Retail	$30,721	$3,242	$622	$3,863	46
SLE-00000144	7 August 2025	Granite Subaru	2020 Subaru Impreza BaseCertified	Certified Retail	$9,674	$1,290	$335	$1,625	50
SLE-00000145	7 August 2025	Granite Pre-Owned	2024 Chevrolet Camaro 1LTUsed	Wholesalenot retail	$23,015	-$1,966loss	$0	-$1,966	47
SLE-00000146	7 August 2025	Granite Pre-Owned	2022 Hyundai Elantra SELUsed	Used Retail	$14,359	$2,271	$373	$2,644	33
SLE-00000147	7 August 2025	Granite Pre-Owned	2016 Jeep Grand Cherokee LaredoUsed	Wholesalenot retail	$3,232	-$813loss	$0	-$813	29
SLE-00000143	6 August 2025	Granite Chevrolet	2024 Chevrolet Camaro 1LTCertified	Certified Retail	$33,095	$4,254	$1,937	$6,190	28
SLE-00000135	5 August 2025	Granite Chevrolet	2025 Chevrolet Blazer EV LTNew	Dealer Tradenot retail	$41,034	$2,595	$0	$2,595	143
SLE-00000136	5 August 2025	Granite Pre-Owned	2025 Chevrolet Blazer EV LTUsed	Wholesalenot retail	$30,027	$241	$0	$241	57
SLE-00000137	5 August 2025	Granite Chevrolet	2026 Chevrolet Blazer EV LTNew	New Retail	$36,057	-$1,584loss	$1,113	-$471	75
SLE-00000138	5 August 2025	Granite Subaru	2023 Ford Bronco Sport Big BendUsed	Used Retail	$17,285	$1,754	$1,338	$3,092	113
SLE-00000139	5 August 2025	Granite Chevrolet	2025 Chevrolet Blazer EV LTNew	Lease	$35,573	-$661loss	$1,925	$1,264	122
SLE-00000140	5 August 2025	Granite Chevrolet	2024 Chevrolet Traverse LTNew	New Retail	$35,142	$512	$2,258	$2,770	15
SLE-00000141	5 August 2025	Granite Subaru	2026 Subaru Ascent BaseNew	Lease	$36,671	-$675loss	$693	$17	63
SLE-00000142	5 August 2025	Granite Pre-Owned	2024 Ford F-150 XLUsed	Used Retail	$37,651	$6,688	$687	$7,375	28
SLE-00000130	4 August 2025	Granite Pre-Owned	2020 Subaru Impreza BaseUsed	Used Retail	$9,931	$1,479	$1,241	$2,720	88
SLE-00000131	4 August 2025	Granite Chevrolet	2026 Chevrolet Blazer 2LTNew	New Retail	$39,102	$587	$1,659	$2,246	94
SLE-00000132	4 August 2025	Granite Pre-Owned	2020 Subaru Outback Onyx Edition XTUsed	Used Retail	$13,294	$2,115	$1,805	$3,921	108
SLE-00000133	4 August 2025	Granite Subaru	2020 Subaru Impreza BaseUsed	Used Retail	$7,325	$513	$1,099	$1,612	52
SLE-00000134	4 August 2025	Granite Chevrolet	2025 Chevrolet Tahoe LTNew	New Retail	$38,024	$1,544	$1,678	$3,222	55
SLE-00000121	2 August 2025	Granite Subaru	2021 Subaru Forester BaseUsed	Used Retail	$18,366	$2,037	$1,197	$3,234	171
SLE-00000122	2 August 2025	Granite Chevrolet	2019 Chevrolet Equinox LSUsed	Used Retail	$8,185	$1,242	$532	$1,774	23

SLE-000001518 August 2025
2020 Chrysler Pacifica Limited
Granite Pre-OwnedVEH-0000330UsedUsed RetailTrade
Sale price
$11,447
Front
$892
Back
$988
Total
$1,880
Source: Showroom Walk-inSalesperson: EMP-0002556 days in stock
SLE-000001528 August 2025
2021 Jeep Grand Cherokee Overland
Granite Pre-OwnedVEH-0000356UsedUsed Retail
Sale price
$16,994
Front
$3,236
Back
$1,333
Total
$4,569
Source: Television Spot ResponseSalesperson: EMP-0002511 days in stock
SLE-000001538 August 2025
2024 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000811NewLease
Sale price
$34,315
Front
-$599loss
Back
$1,252
Total
$653
Source: Showroom Walk-inSalesperson: EMP-00007148 days in stock
SLE-000001548 August 2025
2025 Subaru Impreza Base
Granite SubaruVEH-0000838CertifiedCertified Retail
Sale price
$22,878
Front
$3,083
Back
$1,287
Total
$4,370
Walk-in or unattributedSalesperson: EMP-0001532 days in stock
SLE-000001558 August 2025
2024 Jeep Wrangler Sport
Granite Pre-OwnedVEH-0000867UsedUsed Retail
Sale price
$30,721
Front
$3,242
Back
$622
Total
$3,863
Source: Service Lane OpportunitySalesperson: EMP-0002946 days in stock
SLE-000001447 August 2025
2020 Subaru Impreza Base
Granite SubaruVEH-0000209CertifiedCertified Retail
Sale price
$9,674
Front
$1,290
Back
$335
Total
$1,625
Source: Showroom Walk-inSalesperson: EMP-0001850 days in stock
SLE-000001457 August 2025
2024 Chevrolet Camaro 1LT
Granite Pre-OwnedVEH-0000414UsedWholesale
Sale price
$23,015
Front
-$1,966loss
Back
$0
Total
-$1,966
Walk-in or unattributedSalesperson: EMP-0002547 days in stock
SLE-000001467 August 2025
2022 Hyundai Elantra SEL
Granite Pre-OwnedVEH-0000460UsedUsed Retail
Sale price
$14,359
Front
$2,271
Back
$373
Total
$2,644
Walk-in or unattributedSalesperson: EMP-0002933 days in stock
SLE-000001477 August 2025
2016 Jeep Grand Cherokee Laredo
Granite Pre-OwnedVEH-0000523UsedWholesale
Sale price
$3,232
Front
-$813loss
Back
$0
Total
-$813
Walk-in or unattributedSalesperson: EMP-0002929 days in stock
SLE-000001436 August 2025
2024 Chevrolet Camaro 1LT
Granite ChevroletVEH-0000500CertifiedCertified RetailTrade
Sale price
$33,095
Front
$4,254
Back
$1,937
Total
$6,190
Walk-in or unattributedSalesperson: EMP-0000628 days in stock
SLE-000001355 August 2025
2025 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000016NewDealer Trade
Sale price
$41,034
Front
$2,595
Back
$0
Total
$2,595
Walk-in or unattributedSalesperson: EMP-00006143 days in stock
SLE-000001365 August 2025
2025 Chevrolet Blazer EV LT
Granite Pre-OwnedVEH-0000158UsedWholesale
Sale price
$30,027
Front
$241
Back
$0
Total
$241
Walk-in or unattributedSalesperson: EMP-0002757 days in stock
SLE-000001375 August 2025
2026 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000211NewNew Retail
Sale price
$36,057
Front
-$1,584loss
Back
$1,113
Total
-$471
Walk-in or unattributedSalesperson: EMP-0000375 days in stock
SLE-000001385 August 2025
2023 Ford Bronco Sport Big Bend
Granite SubaruVEH-0000267UsedUsed Retail
Sale price
$17,285
Front
$1,754
Back
$1,338
Total
$3,092
Walk-in or unattributedSalesperson: EMP-00016113 days in stock
SLE-000001395 August 2025
2025 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000394NewLeaseTrade
Sale price
$35,573
Front
-$661loss
Back
$1,925
Total
$1,264
Source: Dealer Website FormSalesperson: EMP-00007122 days in stock
SLE-000001405 August 2025
2024 Chevrolet Traverse LT
Granite ChevroletVEH-0000617NewNew RetailTrade
Sale price
$35,142
Front
$512
Back
$2,258
Total
$2,770
Walk-in or unattributedSalesperson: EMP-0000315 days in stock
SLE-000001415 August 2025
2026 Subaru Ascent Base
Granite SubaruVEH-0000626NewLease
Sale price
$36,671
Front
-$675loss
Back
$693
Total
$17
Source: Customer ReferralSalesperson: EMP-0001863 days in stock
SLE-000001425 August 2025
2024 Ford F-150 XL
Granite Pre-OwnedVEH-0000776UsedUsed Retail
Sale price
$37,651
Front
$6,688
Back
$687
Total
$7,375
Source: Paid Search BrandSalesperson: EMP-0002528 days in stock
SLE-000001304 August 2025
2020 Subaru Impreza Base
Granite Pre-OwnedVEH-0000426UsedUsed Retail
Sale price
$9,931
Front
$1,479
Back
$1,241
Total
$2,720
Walk-in or unattributedSalesperson: EMP-0002988 days in stock
SLE-000001314 August 2025
2026 Chevrolet Blazer 2LT
Granite ChevroletVEH-0000471NewNew Retail
Sale price
$39,102
Front
$587
Back
$1,659
Total
$2,246
Walk-in or unattributedSalesperson: EMP-0001094 days in stock
SLE-000001324 August 2025
2020 Subaru Outback Onyx Edition XT
Granite Pre-OwnedVEH-0000492UsedUsed RetailTrade
Sale price
$13,294
Front
$2,115
Back
$1,805
Total
$3,921
Source: Paid Search BrandSalesperson: EMP-00029108 days in stock
SLE-000001334 August 2025
2020 Subaru Impreza Base
Granite SubaruVEH-0000610UsedUsed Retail
Sale price
$7,325
Front
$513
Back
$1,099
Total
$1,612
Source: Service Lane OpportunitySalesperson: EMP-0001552 days in stock
SLE-000001344 August 2025
2025 Chevrolet Tahoe LT
Granite ChevroletVEH-0000670NewNew Retail
Sale price
$38,024
Front
$1,544
Back
$1,678
Total
$3,222
Source: Customer ReferralSalesperson: EMP-0001255 days in stock
SLE-000001212 August 2025
2021 Subaru Forester Base
Granite SubaruVEH-0000135UsedUsed RetailTrade
Sale price
$18,366
Front
$2,037
Back
$1,197
Total
$3,234
Source: Direct Site VisitSalesperson: EMP-00018171 days in stock
SLE-000001222 August 2025
2019 Chevrolet Equinox LS
Granite ChevroletVEH-0000270UsedUsed Retail
Sale price
$8,185
Front
$1,242
Back
$532
Total
$1,774
Walk-in or unattributedSalesperson: EMP-0001223 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-00000151	VEH-0000330	Showroom Walk-in	EMP-00025	EMP-00024	EMP-00028
SLE-00000152	VEH-0000356	Television Spot Response	EMP-00025	EMP-00024	EMP-00028
SLE-00000153	VEH-0000811	Showroom Walk-in	EMP-00007	EMP-00008	EMP-00005
SLE-00000154	VEH-0000838	Walk-in or unattributed	EMP-00015	EMP-00023	EMP-00017
SLE-00000155	VEH-0000867	Service Lane Opportunity	EMP-00029	EMP-00030	EMP-00028
SLE-00000144	VEH-0000209	Showroom Walk-in	EMP-00018	EMP-00023	EMP-00017
SLE-00000145	VEH-0000414	Walk-in or unattributed	EMP-00025	EMP-00024	Unattributed
SLE-00000146	VEH-0000460	Walk-in or unattributed	EMP-00029	EMP-00024	EMP-00028
SLE-00000147	VEH-0000523	Walk-in or unattributed	EMP-00029	EMP-00030	Unattributed
SLE-00000143	VEH-0000500	Walk-in or unattributed	EMP-00006	EMP-00002	EMP-00005
SLE-00000135	VEH-0000016	Walk-in or unattributed	EMP-00006	EMP-00008	Unattributed
SLE-00000136	VEH-0000158	Walk-in or unattributed	EMP-00027	EMP-00030	Unattributed
SLE-00000137	VEH-0000211	Walk-in or unattributed	EMP-00003	EMP-00001	EMP-00005
SLE-00000138	VEH-0000267	Walk-in or unattributed	EMP-00016	EMP-00014	EMP-00017
SLE-00000139	VEH-0000394	Dealer Website Form	EMP-00007	EMP-00008	EMP-00005
SLE-00000140	VEH-0000617	Walk-in or unattributed	EMP-00003	EMP-00002	EMP-00005
SLE-00000141	VEH-0000626	Customer Referral	EMP-00018	EMP-00014	Unattributed
SLE-00000142	VEH-0000776	Paid Search Brand	EMP-00025	EMP-00024	EMP-00028
SLE-00000130	VEH-0000426	Walk-in or unattributed	EMP-00029	EMP-00030	EMP-00028
SLE-00000131	VEH-0000471	Walk-in or unattributed	EMP-00010	EMP-00001	EMP-00005
SLE-00000132	VEH-0000492	Paid Search Brand	EMP-00029	EMP-00024	EMP-00028
SLE-00000133	VEH-0000610	Service Lane Opportunity	EMP-00015	EMP-00023	EMP-00017
SLE-00000134	VEH-0000670	Customer Referral	EMP-00012	EMP-00002	EMP-00005
SLE-00000121	VEH-0000135	Direct Site Visit	EMP-00018	EMP-00014	EMP-00017
SLE-00000122	VEH-0000270	Walk-in or unattributed	EMP-00012	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.