Deal Explorer

97 deals · All three stores · October 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-10Remove 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

October 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: 97; Matching the current filters
Retail units: 80; 17 matched transactions are not retail
Total gross: $256,409; Retail rows only

Front gross: $151,720
Back gross: $104,689
Closed at a front loss: 28

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-00000405	16 October 2025	Granite Subaru	2018 Subaru Crosstrek BaseUsed	Used Retail	$3,490	-$260loss	$914	$654	23
SLE-00000401	15 October 2025	Granite Subaru	2024 Subaru Outback WildernessUsed	Used Retail	$24,451	$3,950	$1,892	$5,842	28
SLE-00000398	14 October 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSNew	Lease	$38,069	$1,479	$1,150	$2,629	33
SLE-00000399	14 October 2025	Granite Chevrolet	2026 Chevrolet Traverse High CountryNew	New Retail	$37,909	$1,072	$1,017	$2,089	25
SLE-00000400	14 October 2025	Granite Subaru	2021 Subaru Forester BaseUsed	Used Retail	$17,233	$2,706	$1,562	$4,268	15
SLE-00000394	13 October 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSNew	New Retail	$35,972	-$12loss	$1,199	$1,187	44
SLE-00000395	13 October 2025	Granite Chevrolet	2025 Chevrolet Blazer EV LTUsed	Used Retail	$36,329	$4,534	$1,955	$6,489	24
SLE-00000396	13 October 2025	Granite Subaru	2021 Subaru Forester BaseUsed	Used Retail	$14,038	$1,020	$969	$1,989	94
SLE-00000397	13 October 2025	Granite Chevrolet	2021 Chevrolet Equinox LTUsed	Used Retail	$18,063	$3,135	$1,445	$4,579	55
SLE-00000390	11 October 2025	Granite Subaru	2025 Subaru Ascent Onyx EditionNew	New Retail	$36,890	-$663loss	$2,548	$1,884	51
SLE-00000391	11 October 2025	Granite Chevrolet	2024 Chevrolet Traverse LTNew	New Retail	$37,042	$1,880	$1,199	$3,078	23
SLE-00000392	11 October 2025	Granite Pre-Owned	2022 Ford Escape SUsed	Used Retail	$13,554	$2,801	$249	$3,050	58
SLE-00000393	11 October 2025	Granite Pre-Owned	2026 Chevrolet Blazer EV LTUsed	Used Retail	$39,691	$6,741	$1,944	$8,685	84
SLE-00000388	10 October 2025	Granite Subaru	2025 Subaru Forester BaseCertified	Dealer Tradenot retail	$32,645	$983	$0	$983	10
SLE-00000389	10 October 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSNew	Dealer Tradenot retail	$33,381	-$2,329loss	$0	-$2,329	78
SLE-00000386	8 October 2025	Granite Chevrolet	2019 Chevrolet Equinox LSCertified	Certified Retail	$10,089	$746	$1,586	$2,332	81
SLE-00000387	8 October 2025	Granite Subaru	2026 Subaru Ascent BaseNew	New Retail	$38,373	$1,014	$2,780	$3,794	37
SLE-00000383	7 October 2025	Granite Chevrolet	2019 Chevrolet Equinox LTUsed	Used Retail	$7,945	$346	$816	$1,162	8
SLE-00000384	7 October 2025	Granite Chevrolet	2024 Chevrolet Traverse LTUsed	Used Retail	$27,972	$4,070	$1,148	$5,218	82
SLE-00000385	7 October 2025	Granite Pre-Owned	2019 Dodge Charger R/TUsed	Wholesalenot retail	$5,727	-$558loss	$0	-$558	49
SLE-00000378	6 October 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	New Retail	$36,958	$265	$1,947	$2,212	75
SLE-00000379	6 October 2025	Granite Subaru	2018 Subaru Crosstrek BaseCertified	Certified Retail	$5,370	$446	$832	$1,278	11
SLE-00000380	6 October 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSNew	New Retail	$35,193	-$797loss	$181	-$616	129
SLE-00000381	6 October 2025	Granite Pre-Owned	2024 Ford F-150 XLUsed	Dealer Tradenot retail	$34,389	$625	$0	$625	38
SLE-00000382	6 October 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSNew	New Retail	$38,059	$2,453	$2,861	$5,314	34

SLE-0000040516 October 2025
2018 Subaru Crosstrek Base
Granite SubaruVEH-0000730UsedUsed RetailTrade
Sale price
$3,490
Front
-$260loss
Back
$914
Total
$654
Source: Third-Party Trade Valuation PortalSalesperson: EMP-0001623 days in stock
SLE-0000040115 October 2025
2024 Subaru Outback Wilderness
Granite SubaruVEH-0000137UsedUsed Retail
Sale price
$24,451
Front
$3,950
Back
$1,892
Total
$5,842
Source: Dealer Website FormSalesperson: EMP-0001628 days in stock
SLE-0000039814 October 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000062NewLeaseTrade
Sale price
$38,069
Front
$1,479
Back
$1,150
Total
$2,629
Walk-in or unattributedSalesperson: EMP-0000333 days in stock
SLE-0000039914 October 2025
2026 Chevrolet Traverse High Country
Granite ChevroletVEH-0000091NewNew RetailTrade
Sale price
$37,909
Front
$1,072
Back
$1,017
Total
$2,089
Source: Third-Party Trade Valuation PortalSalesperson: EMP-0000325 days in stock
SLE-0000040014 October 2025
2021 Subaru Forester Base
Granite SubaruVEH-0000787UsedUsed Retail
Sale price
$17,233
Front
$2,706
Back
$1,562
Total
$4,268
Source: Showroom Walk-inSalesperson: EMP-0001615 days in stock
SLE-0000039413 October 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000121NewNew Retail
Sale price
$35,972
Front
-$12loss
Back
$1,199
Total
$1,187
Source: Service Lane OpportunitySalesperson: EMP-0000744 days in stock
SLE-0000039513 October 2025
2025 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000147UsedUsed Retail
Sale price
$36,329
Front
$4,534
Back
$1,955
Total
$6,489
Source: Paid Search Non-BrandSalesperson: EMP-0000624 days in stock
SLE-0000039613 October 2025
2021 Subaru Forester Base
Granite SubaruVEH-0000431UsedUsed RetailTrade
Sale price
$14,038
Front
$1,020
Back
$969
Total
$1,989
Walk-in or unattributedSalesperson: EMP-0001694 days in stock
SLE-0000039713 October 2025
2021 Chevrolet Equinox LT
Granite ChevroletVEH-0000584UsedUsed RetailTrade
Sale price
$18,063
Front
$3,135
Back
$1,445
Total
$4,579
Walk-in or unattributedSalesperson: EMP-0000655 days in stock
SLE-0000039011 October 2025
2025 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000119NewNew Retail
Sale price
$36,890
Front
-$663loss
Back
$2,548
Total
$1,884
Walk-in or unattributedSalesperson: EMP-0001551 days in stock
SLE-0000039111 October 2025
2024 Chevrolet Traverse LT
Granite ChevroletVEH-0000552NewNew Retail
Sale price
$37,042
Front
$1,880
Back
$1,199
Total
$3,078
Source: Showroom Walk-inSalesperson: EMP-0001223 days in stock
SLE-0000039211 October 2025
2022 Ford Escape S
Granite Pre-OwnedVEH-0000680UsedUsed Retail
Sale price
$13,554
Front
$2,801
Back
$249
Total
$3,050
Source: Paid Search Non-BrandSalesperson: EMP-0002558 days in stock
SLE-0000039311 October 2025
2026 Chevrolet Blazer EV LT
Granite Pre-OwnedVEH-0000891UsedUsed RetailTrade
Sale price
$39,691
Front
$6,741
Back
$1,944
Total
$8,685
Source: Service Lane OpportunitySalesperson: EMP-0002584 days in stock
SLE-0000038810 October 2025
2025 Subaru Forester Base
Granite SubaruVEH-0000056CertifiedDealer Trade
Sale price
$32,645
Front
$983
Back
$0
Total
$983
Walk-in or unattributedSalesperson: EMP-0001610 days in stock
SLE-0000038910 October 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000318NewDealer Trade
Sale price
$33,381
Front
-$2,329loss
Back
$0
Total
-$2,329
Walk-in or unattributedSalesperson: EMP-0000378 days in stock
SLE-000003868 October 2025
2019 Chevrolet Equinox LS
Granite ChevroletVEH-0000647CertifiedCertified Retail
Sale price
$10,089
Front
$746
Back
$1,586
Total
$2,332
Source: Showroom Walk-inSalesperson: EMP-0001281 days in stock
SLE-000003878 October 2025
2026 Subaru Ascent Base
Granite SubaruVEH-0000788NewNew Retail
Sale price
$38,373
Front
$1,014
Back
$2,780
Total
$3,794
Source: Direct Mail ResponseSalesperson: EMP-0001537 days in stock
SLE-000003837 October 2025
2019 Chevrolet Equinox LT
Granite ChevroletVEH-0000441UsedUsed Retail
Sale price
$7,945
Front
$346
Back
$816
Total
$1,162
Walk-in or unattributedSalesperson: EMP-000108 days in stock
SLE-000003847 October 2025
2024 Chevrolet Traverse LT
Granite ChevroletVEH-0000479UsedUsed Retail
Sale price
$27,972
Front
$4,070
Back
$1,148
Total
$5,218
Walk-in or unattributedSalesperson: EMP-0000382 days in stock
SLE-000003857 October 2025
2019 Dodge Charger R/T
Granite Pre-OwnedVEH-0000612UsedWholesale
Sale price
$5,727
Front
-$558loss
Back
$0
Total
-$558
Walk-in or unattributedSalesperson: EMP-0002549 days in stock
SLE-000003786 October 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000146NewNew RetailTrade
Sale price
$36,958
Front
$265
Back
$1,947
Total
$2,212
Source: Dealer Website FormSalesperson: EMP-0001675 days in stock
SLE-000003796 October 2025
2018 Subaru Crosstrek Base
Granite SubaruVEH-0000435CertifiedCertified Retail
Sale price
$5,370
Front
$446
Back
$832
Total
$1,278
Source: Community Partner ReferralSalesperson: EMP-0001611 days in stock
SLE-000003806 October 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000436NewNew Retail
Sale price
$35,193
Front
-$797loss
Back
$181
Total
-$616
Source: Paid Social Video CampaignSalesperson: EMP-00012129 days in stock
SLE-000003816 October 2025
2024 Ford F-150 XL
Granite Pre-OwnedVEH-0000574UsedDealer Trade
Sale price
$34,389
Front
$625
Back
$0
Total
$625
Walk-in or unattributedSalesperson: EMP-0002938 days in stock
SLE-000003826 October 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000640NewNew Retail
Sale price
$38,059
Front
$2,453
Back
$2,861
Total
$5,314
Source: Customer ReferralSalesperson: EMP-0000334 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-00000405	VEH-0000730	Third-Party Trade Valuation Portal	EMP-00016	EMP-00014	EMP-00017
SLE-00000401	VEH-0000137	Dealer Website Form	EMP-00016	EMP-00014	EMP-00017
SLE-00000398	VEH-0000062	Walk-in or unattributed	EMP-00003	EMP-00001	EMP-00005
SLE-00000399	VEH-0000091	Third-Party Trade Valuation Portal	EMP-00003	EMP-00008	EMP-00005
SLE-00000400	VEH-0000787	Showroom Walk-in	EMP-00016	EMP-00023	EMP-00017
SLE-00000394	VEH-0000121	Service Lane Opportunity	EMP-00007	EMP-00001	EMP-00005
SLE-00000395	VEH-0000147	Paid Search Non-Brand	EMP-00006	EMP-00002	EMP-00005
SLE-00000396	VEH-0000431	Walk-in or unattributed	EMP-00016	EMP-00023	EMP-00017
SLE-00000397	VEH-0000584	Walk-in or unattributed	EMP-00006	EMP-00001	EMP-00005
SLE-00000390	VEH-0000119	Walk-in or unattributed	EMP-00015	EMP-00013	EMP-00017
SLE-00000391	VEH-0000552	Showroom Walk-in	EMP-00012	EMP-00002	EMP-00005
SLE-00000392	VEH-0000680	Paid Search Non-Brand	EMP-00025	EMP-00024	EMP-00028
SLE-00000393	VEH-0000891	Service Lane Opportunity	EMP-00025	EMP-00024	EMP-00028
SLE-00000388	VEH-0000056	Walk-in or unattributed	EMP-00016	EMP-00023	Unattributed
SLE-00000389	VEH-0000318	Walk-in or unattributed	EMP-00003	EMP-00002	Unattributed
SLE-00000386	VEH-0000647	Showroom Walk-in	EMP-00012	EMP-00008	EMP-00005
SLE-00000387	VEH-0000788	Direct Mail Response	EMP-00015	EMP-00013	EMP-00017
SLE-00000383	VEH-0000441	Walk-in or unattributed	EMP-00010	EMP-00001	EMP-00005
SLE-00000384	VEH-0000479	Walk-in or unattributed	EMP-00003	EMP-00008	EMP-00005
SLE-00000385	VEH-0000612	Walk-in or unattributed	EMP-00025	EMP-00030	Unattributed
SLE-00000378	VEH-0000146	Dealer Website Form	EMP-00016	EMP-00013	EMP-00017
SLE-00000379	VEH-0000435	Community Partner Referral	EMP-00016	EMP-00014	EMP-00017
SLE-00000380	VEH-0000436	Paid Social Video Campaign	EMP-00012	EMP-00002	EMP-00005
SLE-00000381	VEH-0000574	Walk-in or unattributed	EMP-00029	EMP-00024	Unattributed
SLE-00000382	VEH-0000640	Customer Referral	EMP-00003	EMP-00002	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.