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-00000249	30 August 2025	Granite Subaru	2020 Ford Escape TitaniumUsed	Wholesalenot retail	$6,387	-$1,923loss	$0	-$1,923	31
SLE-00000250	30 August 2025	Granite Pre-Owned	2022 Ford Escape SUsed	Used Retail	$14,285	$3,171	$364	$3,535	26
SLE-00000251	30 August 2025	Granite Chevrolet	2024 Chevrolet Silverado EV RSTNew	Lease	$44,971	$2,146	$1,007	$3,152	25
SLE-00000252	30 August 2025	Granite Chevrolet	2022 Chevrolet Tahoe LTCertified	Certified Retail	$22,196	$3,728	$1,478	$5,206	3
SLE-00000246	29 August 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	New Retail	$39,131	$1,570	$1,266	$2,836	42
SLE-00000247	29 August 2025	Granite Chevrolet	2026 Chevrolet Colorado WTUsed	Used Retail	$51,242	$8,474	$835	$9,309	63
SLE-00000248	29 August 2025	Granite Pre-Owned	2022 Chevrolet Tahoe Z71Used	Used Retail	$21,284	$3,472	$2,114	$5,585	59
SLE-00000244	28 August 2025	Granite Subaru	2025 Subaru Forester BaseNew	New Retail	$38,445	$730	$569	$1,298	63
SLE-00000245	28 August 2025	Granite Subaru	2025 Subaru Ascent TouringNew	New Retail	$34,864	-$970loss	$537	-$433	155
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-00000242	27 August 2025	Granite Chevrolet	2026 Chevrolet Blazer EV LTNew	Lease	$39,904	$1,818	$989	$2,807	40
SLE-00000243	27 August 2025	Granite Subaru	2026 Subaru Ascent BaseNew	New Retail	$35,953	-$2,177loss	$971	-$1,206	133
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-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-0000024930 August 2025
2020 Ford Escape Titanium
Granite SubaruVEH-0000246UsedWholesale
Sale price
$6,387
Front
-$1,923loss
Back
$0
Total
-$1,923
Walk-in or unattributedSalesperson: EMP-0001831 days in stock
SLE-0000025030 August 2025
2022 Ford Escape S
Granite Pre-OwnedVEH-0000248UsedUsed RetailTrade
Sale price
$14,285
Front
$3,171
Back
$364
Total
$3,535
Source: Showroom Walk-inSalesperson: EMP-0002626 days in stock
SLE-0000025130 August 2025
2024 Chevrolet Silverado EV RST
Granite ChevroletVEH-0000287NewLease
Sale price
$44,971
Front
$2,146
Back
$1,007
Total
$3,152
Source: Paid Search BrandSalesperson: EMP-0001225 days in stock
SLE-0000025230 August 2025
2022 Chevrolet Tahoe LT
Granite ChevroletVEH-0000745CertifiedCertified Retail
Sale price
$22,196
Front
$3,728
Back
$1,478
Total
$5,206
Source: Showroom Walk-inSalesperson: EMP-000103 days in stock
SLE-0000024629 August 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000173NewNew RetailTrade
Sale price
$39,131
Front
$1,570
Back
$1,266
Total
$2,836
Source: Paid Search Non-BrandSalesperson: EMP-0002242 days in stock
SLE-0000024729 August 2025
2026 Chevrolet Colorado WT
Granite ChevroletVEH-0000518UsedUsed Retail
Sale price
$51,242
Front
$8,474
Back
$835
Total
$9,309
Source: Showroom Walk-inSalesperson: EMP-0000363 days in stock
SLE-0000024829 August 2025
2022 Chevrolet Tahoe Z71
Granite Pre-OwnedVEH-0000719UsedUsed Retail
Sale price
$21,284
Front
$3,472
Back
$2,114
Total
$5,585
Source: Showroom Walk-inSalesperson: EMP-0002659 days in stock
SLE-0000024428 August 2025
2025 Subaru Forester Base
Granite SubaruVEH-0000228NewNew Retail
Sale price
$38,445
Front
$730
Back
$569
Total
$1,298
Walk-in or unattributedSalesperson: EMP-0002263 days in stock
SLE-0000024528 August 2025
2025 Subaru Ascent Touring
Granite SubaruVEH-0000522NewNew RetailTrade
Sale price
$34,864
Front
-$970loss
Back
$537
Total
-$433
Walk-in or unattributedSalesperson: EMP-00015155 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
SLE-0000024227 August 2025
2026 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000726NewLease
Sale price
$39,904
Front
$1,818
Back
$989
Total
$2,807
Source: Dealer Website FormSalesperson: EMP-0001240 days in stock
SLE-0000024327 August 2025
2026 Subaru Ascent Base
Granite SubaruVEH-0000825NewNew RetailTrade
Sale price
$35,953
Front
-$2,177loss
Back
$971
Total
-$1,206
Source: Customer ReferralSalesperson: EMP-00022133 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-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

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-00000249	VEH-0000246	Walk-in or unattributed	EMP-00018	EMP-00014	Unattributed
SLE-00000250	VEH-0000248	Showroom Walk-in	EMP-00026	EMP-00030	EMP-00028
SLE-00000251	VEH-0000287	Paid Search Brand	EMP-00012	EMP-00002	EMP-00005
SLE-00000252	VEH-0000745	Showroom Walk-in	EMP-00010	EMP-00002	EMP-00005
SLE-00000246	VEH-0000173	Paid Search Non-Brand	EMP-00022	EMP-00013	EMP-00017
SLE-00000247	VEH-0000518	Showroom Walk-in	EMP-00003	EMP-00002	Unattributed
SLE-00000248	VEH-0000719	Showroom Walk-in	EMP-00026	EMP-00030	EMP-00028
SLE-00000244	VEH-0000228	Walk-in or unattributed	EMP-00022	EMP-00014	EMP-00017
SLE-00000245	VEH-0000522	Walk-in or unattributed	EMP-00015	EMP-00014	EMP-00017
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
SLE-00000242	VEH-0000726	Dealer Website Form	EMP-00012	EMP-00002	EMP-00005
SLE-00000243	VEH-0000825	Customer Referral	EMP-00022	EMP-00023	EMP-00017
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-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

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.