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-00000117	1 August 2025	Granite Subaru	2025 Subaru Forester BaseNew	Lease	$39,861	$1,610	$641	$2,251	35
SLE-00000118	1 August 2025	Granite Chevrolet	2026 Chevrolet Silverado EV RSTNew	New Retail	$47,079	$1,432	$1,515	$2,947	35
SLE-00000119	1 August 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSUsed	Used Retail	$35,929	$5,776	$1,058	$6,834	22
SLE-00000120	1 August 2025	Granite Pre-Owned	2023 Audi Q5 PremiumUsed	Dealer Tradenot retail	$26,720	$1,420	$0	$1,420	86
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-00000123	2 August 2025	Granite Subaru	2024 Subaru Outback WildernessNew	New Retail	$27,506	-$42loss	$733	$691	27
SLE-00000124	2 August 2025	Granite Chevrolet	2023 Chevrolet Trailblazer LSUsed	Used Retail	$18,054	$3,348	$243	$3,591	25
SLE-00000125	2 August 2025	Granite Subaru	2024 Subaru Impreza RSNew	New Retail	$22,051	-$1,387loss	$1,284	-$103	129
SLE-00000126	2 August 2025	Granite Subaru	2026 Subaru Outback Onyx Edition XTNew	Lease	$30,837	$528	$1,410	$1,938	87
SLE-00000127	2 August 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSNew	Lease	$37,157	$994	$448	$1,442	72
SLE-00000128	2 August 2025	Granite Subaru	2018 Subaru Crosstrek BaseUsed	Used Retail	$3,674	-$31loss	$1,384	$1,353	38
SLE-00000129	2 August 2025	Granite Chevrolet	2024 Chevrolet Silverado EV RSTCertified	Certified Retail	$41,863	$10,759	$2,468	$13,227	33
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-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-000001171 August 2025
2025 Subaru Forester Base
Granite SubaruVEH-0000178NewLease
Sale price
$39,861
Front
$1,610
Back
$641
Total
$2,251
Walk-in or unattributedSalesperson: EMP-0001835 days in stock
SLE-000001181 August 2025
2026 Chevrolet Silverado EV RST
Granite ChevroletVEH-0000611NewNew Retail
Sale price
$47,079
Front
$1,432
Back
$1,515
Total
$2,947
Walk-in or unattributedSalesperson: EMP-0000635 days in stock
SLE-000001191 August 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000756UsedUsed RetailTrade
Sale price
$35,929
Front
$5,776
Back
$1,058
Total
$6,834
Source: Dealer Website FormSalesperson: EMP-0001022 days in stock
SLE-000001201 August 2025
2023 Audi Q5 Premium
Granite Pre-OwnedVEH-0000837UsedDealer Trade
Sale price
$26,720
Front
$1,420
Back
$0
Total
$1,420
Walk-in or unattributedSalesperson: EMP-0002986 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
SLE-000001232 August 2025
2024 Subaru Outback Wilderness
Granite SubaruVEH-0000353NewNew RetailTrade
Sale price
$27,506
Front
-$42loss
Back
$733
Total
$691
Walk-in or unattributedSalesperson: EMP-0001827 days in stock
SLE-000001242 August 2025
2023 Chevrolet Trailblazer LS
Granite ChevroletVEH-0000425UsedUsed Retail
Sale price
$18,054
Front
$3,348
Back
$243
Total
$3,591
Source: Radio Spot ResponseSalesperson: EMP-0000425 days in stock
SLE-000001252 August 2025
2024 Subaru Impreza RS
Granite SubaruVEH-0000452NewNew RetailTrade
Sale price
$22,051
Front
-$1,387loss
Back
$1,284
Total
-$103
Walk-in or unattributedSalesperson: EMP-00022129 days in stock
SLE-000001262 August 2025
2026 Subaru Outback Onyx Edition XT
Granite SubaruVEH-0000468NewLease
Sale price
$30,837
Front
$528
Back
$1,410
Total
$1,938
Walk-in or unattributedSalesperson: EMP-0002287 days in stock
SLE-000001272 August 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000469NewLeaseTrade
Sale price
$37,157
Front
$994
Back
$448
Total
$1,442
Source: Customer ReferralSalesperson: EMP-0000372 days in stock
SLE-000001282 August 2025
2018 Subaru Crosstrek Base
Granite SubaruVEH-0000765UsedUsed Retail
Sale price
$3,674
Front
-$31loss
Back
$1,384
Total
$1,353
Source: Organic Search LandingSalesperson: EMP-0002238 days in stock
SLE-000001292 August 2025
2024 Chevrolet Silverado EV RST
Granite ChevroletVEH-0000842CertifiedCertified Retail
Sale price
$41,863
Front
$10,759
Back
$2,468
Total
$13,227
Source: Showroom Walk-inSalesperson: EMP-0000333 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-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

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-00000117	VEH-0000178	Walk-in or unattributed	EMP-00018	EMP-00014	EMP-00017
SLE-00000118	VEH-0000611	Walk-in or unattributed	EMP-00006	EMP-00008	EMP-00005
SLE-00000119	VEH-0000756	Dealer Website Form	EMP-00010	EMP-00008	EMP-00005
SLE-00000120	VEH-0000837	Walk-in or unattributed	EMP-00029	EMP-00024	Unattributed
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
SLE-00000123	VEH-0000353	Walk-in or unattributed	EMP-00018	EMP-00013	EMP-00017
SLE-00000124	VEH-0000425	Radio Spot Response	EMP-00004	EMP-00001	EMP-00005
SLE-00000125	VEH-0000452	Walk-in or unattributed	EMP-00022	EMP-00023	EMP-00017
SLE-00000126	VEH-0000468	Walk-in or unattributed	EMP-00022	EMP-00023	EMP-00017
SLE-00000127	VEH-0000469	Customer Referral	EMP-00003	EMP-00008	Unattributed
SLE-00000128	VEH-0000765	Organic Search Landing	EMP-00022	EMP-00014	EMP-00017
SLE-00000129	VEH-0000842	Showroom Walk-in	EMP-00003	EMP-00002	EMP-00005
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-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

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.