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-00000217	23 August 2025	Granite Pre-Owned	2020 Chrysler Pacifica LimitedUsed	Wholesalenot retail	$10,018	-$161loss	$0	-$161	50
SLE-00000218	23 August 2025	Granite Pre-Owned	2017 Subaru Impreza SportUsed	Wholesalenot retail	$2,543	-$587loss	$0	-$587	23
SLE-00000219	23 August 2025	Granite Pre-Owned	2023 Volkswagen Atlas SELUsed	Used Retail	$24,815	$4,724	$280	$5,004	15
SLE-00000220	23 August 2025	Granite Chevrolet	2024 Chrysler Pacifica Hybrid SelectUsed	Used Retail	$31,660	$6,095	$751	$6,847	95
SLE-00000221	23 August 2025	Granite Chevrolet	2024 Chevrolet Traverse LTNew	Lease	$36,793	$1,516	$1,807	$3,323	35
SLE-00000222	23 August 2025	Granite Subaru	2025 Subaru Ascent Onyx EditionNew	New Retail	$35,019	-$1,614loss	$308	-$1,306	177
SLE-00000223	23 August 2025	Granite Subaru	2018 Ford F-150 LariatUsed	Used Retail	$6,325	$506	$1,985	$2,491	35
SLE-00000224	24 August 2025	Granite Chevrolet	2024 Chevrolet Silverado EV RSTNew	Lease	$43,522	-$249loss	$1,878	$1,630	74
SLE-00000225	25 August 2025	Granite Pre-Owned	2025 Chevrolet Blazer EV LTUsed	Used Retail	$41,991	$8,762	$680	$9,442	14
SLE-00000226	25 August 2025	Granite Subaru	2025 Subaru Forester BaseNew	New Retail	$37,697	$1,258	$1,855	$3,114	32
SLE-00000227	25 August 2025	Granite Subaru	2021 Subaru Forester BaseCertified	Certified Retail	$22,360	$5,750	$1,406	$7,156	9
SLE-00000228	25 August 2025	Granite Pre-Owned	2021 Tesla Model 3 Long RangeUsed	Wholesalenot retail	$11,228	-$1,344loss	$0	-$1,344	20
SLE-00000229	25 August 2025	Granite Chevrolet	2026 Chevrolet Colorado WTNew	New Retail	$47,926	$457	$1,337	$1,794	37
SLE-00000230	26 August 2025	Granite Subaru	2025 Subaru Impreza SportCertified	Certified Retail	$30,849	$6,928	$1,039	$7,968	24
SLE-00000231	26 August 2025	Granite Subaru	2018 Subaru Crosstrek BaseCertified	Certified Retail	$4,555	$25	$808	$833	4
SLE-00000232	26 August 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	New Retail	$35,981	-$168loss	$928	$761	82
SLE-00000233	26 August 2025	Granite Pre-Owned	2016 Subaru Outback PremiumUsed	Used Retail	$3,935	$421	$2,018	$2,439	7
SLE-00000234	26 August 2025	Granite Subaru	2018 Subaru Crosstrek BaseUsed	Used Retail	$5,599	$494	$1,665	$2,159	59
SLE-00000235	26 August 2025	Granite Pre-Owned	2016 Toyota Camry SEUsed	Used Retail	$3,627	$305	$447	$753	75
SLE-00000236	26 August 2025	Granite Chevrolet	2024 Chevrolet Traverse LTNew	New Retail	$36,904	-$128loss	$3,115	$2,987	70
SLE-00000237	27 August 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionUsed	Used Retail	$43,807	$8,594	$1,358	$9,952	26
SLE-00000238	27 August 2025	Granite Chevrolet	2025 Chevrolet Blazer EV LTNew	New Retail	$36,333	$284	$1,346	$1,630	22
SLE-00000239	27 August 2025	Granite Subaru	2020 Subaru Impreza BaseUsed	Used Retail	$10,161	$1,581	$732	$2,313	106
SLE-00000240	27 August 2025	Granite Pre-Owned	2024 Subaru Impreza RSUsed	Wholesalenot retail	$16,498	-$2,064loss	$0	-$2,064	53
SLE-00000241	27 August 2025	Granite Chevrolet	2019 Chevrolet Equinox LTUsed	Wholesalenot retail	$4,349	-$1,074loss	$0	-$1,074	35

SLE-0000021723 August 2025
2020 Chrysler Pacifica Limited
Granite Pre-OwnedVEH-0000127UsedWholesale
Sale price
$10,018
Front
-$161loss
Back
$0
Total
-$161
Walk-in or unattributedSalesperson: EMP-0002950 days in stock
SLE-0000021823 August 2025
2017 Subaru Impreza Sport
Granite Pre-OwnedVEH-0000230UsedWholesale
Sale price
$2,543
Front
-$587loss
Back
$0
Total
-$587
Walk-in or unattributedSalesperson: EMP-0002523 days in stock
SLE-0000021923 August 2025
2023 Volkswagen Atlas SEL
Granite Pre-OwnedVEH-0000294UsedUsed RetailTrade
Sale price
$24,815
Front
$4,724
Back
$280
Total
$5,004
Source: Dealer Website FormSalesperson: EMP-0002715 days in stock
SLE-0000022023 August 2025
2024 Chrysler Pacifica Hybrid Select
Granite ChevroletVEH-0000315UsedUsed Retail
Sale price
$31,660
Front
$6,095
Back
$751
Total
$6,847
Source: Third-Party Marketplace ListingSalesperson: EMP-0001295 days in stock
SLE-0000022123 August 2025
2024 Chevrolet Traverse LT
Granite ChevroletVEH-0000326NewLease
Sale price
$36,793
Front
$1,516
Back
$1,807
Total
$3,323
Source: Showroom Walk-inSalesperson: EMP-0001235 days in stock
SLE-0000022223 August 2025
2025 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000538NewNew Retail
Sale price
$35,019
Front
-$1,614loss
Back
$308
Total
-$1,306
Walk-in or unattributedSalesperson: EMP-00018177 days in stock
SLE-0000022323 August 2025
2018 Ford F-150 Lariat
Granite SubaruVEH-0000545UsedUsed RetailTrade
Sale price
$6,325
Front
$506
Back
$1,985
Total
$2,491
Source: Third-Party Marketplace ListingSalesperson: EMP-0001635 days in stock
SLE-0000022424 August 2025
2024 Chevrolet Silverado EV RST
Granite ChevroletVEH-0000696NewLeaseTrade
Sale price
$43,522
Front
-$249loss
Back
$1,878
Total
$1,630
Source: Third-Party Marketplace ListingSalesperson: EMP-0001074 days in stock
SLE-0000022525 August 2025
2025 Chevrolet Blazer EV LT
Granite Pre-OwnedVEH-0000232UsedUsed Retail
Sale price
$41,991
Front
$8,762
Back
$680
Total
$9,442
Source: Third-Party Trade Valuation PortalSalesperson: EMP-0002614 days in stock
SLE-0000022625 August 2025
2025 Subaru Forester Base
Granite SubaruVEH-0000311NewNew RetailTrade
Sale price
$37,697
Front
$1,258
Back
$1,855
Total
$3,114
Source: Dealer Website ChatSalesperson: EMP-0002232 days in stock
SLE-0000022725 August 2025
2021 Subaru Forester Base
Granite SubaruVEH-0000369CertifiedCertified RetailTrade
Sale price
$22,360
Front
$5,750
Back
$1,406
Total
$7,156
Source: Customer ReferralSalesperson: EMP-000229 days in stock
SLE-0000022825 August 2025
2021 Tesla Model 3 Long Range
Granite Pre-OwnedVEH-0000421UsedWholesale
Sale price
$11,228
Front
-$1,344loss
Back
$0
Total
-$1,344
Walk-in or unattributedSalesperson: EMP-0002720 days in stock
SLE-0000022925 August 2025
2026 Chevrolet Colorado WT
Granite ChevroletVEH-0000687NewNew Retail
Sale price
$47,926
Front
$457
Back
$1,337
Total
$1,794
Walk-in or unattributedSalesperson: EMP-0001037 days in stock
SLE-0000023026 August 2025
2025 Subaru Impreza Sport
Granite SubaruVEH-0000536CertifiedCertified Retail
Sale price
$30,849
Front
$6,928
Back
$1,039
Total
$7,968
Source: Customer ReferralSalesperson: EMP-0001624 days in stock
SLE-0000023126 August 2025
2018 Subaru Crosstrek Base
Granite SubaruVEH-0000565CertifiedCertified Retail
Sale price
$4,555
Front
$25
Back
$808
Total
$833
Source: Showroom Walk-inSalesperson: EMP-000184 days in stock
SLE-0000023226 August 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000604NewNew Retail
Sale price
$35,981
Front
-$168loss
Back
$928
Total
$761
Source: Showroom Walk-inSalesperson: EMP-0001882 days in stock
SLE-0000023326 August 2025
2016 Subaru Outback Premium
Granite Pre-OwnedVEH-0000678UsedUsed Retail
Sale price
$3,935
Front
$421
Back
$2,018
Total
$2,439
Source: Customer ReferralSalesperson: EMP-000257 days in stock
SLE-0000023426 August 2025
2018 Subaru Crosstrek Base
Granite SubaruVEH-0000720UsedUsed RetailTrade
Sale price
$5,599
Front
$494
Back
$1,665
Total
$2,159
Source: Paid Search Non-BrandSalesperson: EMP-0002259 days in stock
SLE-0000023526 August 2025
2016 Toyota Camry SE
Granite Pre-OwnedVEH-0000819UsedUsed RetailTrade
Sale price
$3,627
Front
$305
Back
$447
Total
$753
Source: Television Spot ResponseSalesperson: EMP-0002975 days in stock
SLE-0000023626 August 2025
2024 Chevrolet Traverse LT
Granite ChevroletVEH-0000860NewNew Retail
Sale price
$36,904
Front
-$128loss
Back
$3,115
Total
$2,987
Source: Paid Social Video CampaignSalesperson: EMP-0001270 days in stock
SLE-0000023727 August 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000031UsedUsed Retail
Sale price
$43,807
Front
$8,594
Back
$1,358
Total
$9,952
Source: Third-Party Marketplace ListingSalesperson: EMP-0002226 days in stock
SLE-0000023827 August 2025
2025 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000357NewNew Retail
Sale price
$36,333
Front
$284
Back
$1,346
Total
$1,630
Walk-in or unattributedSalesperson: EMP-0000322 days in stock
SLE-0000023927 August 2025
2020 Subaru Impreza Base
Granite SubaruVEH-0000481UsedUsed Retail
Sale price
$10,161
Front
$1,581
Back
$732
Total
$2,313
Source: Showroom Walk-inSalesperson: EMP-00022106 days in stock
SLE-0000024027 August 2025
2024 Subaru Impreza RS
Granite Pre-OwnedVEH-0000511UsedWholesale
Sale price
$16,498
Front
-$2,064loss
Back
$0
Total
-$2,064
Walk-in or unattributedSalesperson: EMP-0002953 days in stock
SLE-0000024127 August 2025
2019 Chevrolet Equinox LT
Granite ChevroletVEH-0000677UsedWholesale
Sale price
$4,349
Front
-$1,074loss
Back
$0
Total
-$1,074
Walk-in or unattributedSalesperson: EMP-0001035 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-00000217	VEH-0000127	Walk-in or unattributed	EMP-00029	EMP-00030	Unattributed
SLE-00000218	VEH-0000230	Walk-in or unattributed	EMP-00025	EMP-00024	Unattributed
SLE-00000219	VEH-0000294	Dealer Website Form	EMP-00027	EMP-00030	EMP-00028
SLE-00000220	VEH-0000315	Third-Party Marketplace Listing	EMP-00012	EMP-00001	EMP-00005
SLE-00000221	VEH-0000326	Showroom Walk-in	EMP-00012	EMP-00001	EMP-00005
SLE-00000222	VEH-0000538	Walk-in or unattributed	EMP-00018	EMP-00013	EMP-00017
SLE-00000223	VEH-0000545	Third-Party Marketplace Listing	EMP-00016	EMP-00023	EMP-00017
SLE-00000224	VEH-0000696	Third-Party Marketplace Listing	EMP-00010	EMP-00008	EMP-00005
SLE-00000225	VEH-0000232	Third-Party Trade Valuation Portal	EMP-00026	EMP-00030	EMP-00028
SLE-00000226	VEH-0000311	Dealer Website Chat	EMP-00022	EMP-00013	EMP-00017
SLE-00000227	VEH-0000369	Customer Referral	EMP-00022	EMP-00014	EMP-00017
SLE-00000228	VEH-0000421	Walk-in or unattributed	EMP-00027	EMP-00024	Unattributed
SLE-00000229	VEH-0000687	Walk-in or unattributed	EMP-00010	EMP-00008	EMP-00005
SLE-00000230	VEH-0000536	Customer Referral	EMP-00016	EMP-00023	EMP-00017
SLE-00000231	VEH-0000565	Showroom Walk-in	EMP-00018	EMP-00014	EMP-00017
SLE-00000232	VEH-0000604	Showroom Walk-in	EMP-00018	EMP-00014	EMP-00017
SLE-00000233	VEH-0000678	Customer Referral	EMP-00025	EMP-00024	EMP-00028
SLE-00000234	VEH-0000720	Paid Search Non-Brand	EMP-00022	EMP-00013	EMP-00017
SLE-00000235	VEH-0000819	Television Spot Response	EMP-00029	EMP-00030	EMP-00028
SLE-00000236	VEH-0000860	Paid Social Video Campaign	EMP-00012	EMP-00008	EMP-00005
SLE-00000237	VEH-0000031	Third-Party Marketplace Listing	EMP-00022	EMP-00013	EMP-00017
SLE-00000238	VEH-0000357	Walk-in or unattributed	EMP-00003	EMP-00002	EMP-00005
SLE-00000239	VEH-0000481	Showroom Walk-in	EMP-00022	EMP-00013	EMP-00017
SLE-00000240	VEH-0000511	Walk-in or unattributed	EMP-00029	EMP-00030	Unattributed
SLE-00000241	VEH-0000677	Walk-in or unattributed	EMP-00010	EMP-00002	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.