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-00000353	30 September 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSCertified	Certified Retail	$44,706	$9,555	$2,803	$12,357	54
SLE-00000354	30 September 2025	Granite Chevrolet	2024 Ford F-150 XLUsed	Used Retail	$39,267	$4,338	$1,259	$5,597	26
SLE-00000355	30 September 2025	Granite Subaru	2018 Nissan Rogue SUsed	Wholesalenot retail	$4,109	-$694loss	$0	-$694	70

SLE-0000035330 September 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000169CertifiedCertified Retail
Sale price
$44,706
Front
$9,555
Back
$2,803
Total
$12,357
Source: Paid Search Non-BrandSalesperson: EMP-0001254 days in stock
SLE-0000035430 September 2025
2024 Ford F-150 XL
Granite ChevroletVEH-0000337UsedUsed RetailTrade
Sale price
$39,267
Front
$4,338
Back
$1,259
Total
$5,597
Walk-in or unattributedSalesperson: EMP-0001226 days in stock
SLE-0000035530 September 2025
2018 Nissan Rogue S
Granite SubaruVEH-0000412UsedWholesale
Sale price
$4,109
Front
-$694loss
Back
$0
Total
-$694
Walk-in or unattributedSalesperson: EMP-0001570 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-00000353	VEH-0000169	Paid Search Non-Brand	EMP-00012	EMP-00002	EMP-00005
SLE-00000354	VEH-0000337	Walk-in or unattributed	EMP-00012	EMP-00002	EMP-00005
SLE-00000355	VEH-0000412	Walk-in or unattributed	EMP-00015	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.