Deal Explorer

64 deals · Granite Subaru, Granite Pre-Owned · December 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

Store: GSA-002,GSA-003Remove 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

December 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: 64; Matching the current filters
Retail units: 57; 7 matched transactions are not retail
Total gross: $192,956; Retail rows only

Front gross: $131,565
Back gross: $61,391
Closed at a front loss: 14

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-00000647	31 December 2025	Granite Pre-Owned	2024 Ford F-150 XLUsed	Used Retail	$33,655	$5,699	$911	$6,610	61
SLE-00000648	31 December 2025	Granite Subaru	2025 Subaru Ascent TouringNew	Lease	$35,401	-$418loss	$500	$82	77
SLE-00000649	31 December 2025	Granite Pre-Owned	2022 Ford Escape SUsed	Used Retail	$13,225	$795	$804	$1,599	138
SLE-00000650	31 December 2025	Granite Subaru	2025 Subaru Forester BaseUsed	Used Retail	$42,268	$7,125	$585	$7,710	36
SLE-00000643	30 December 2025	Granite Pre-Owned	2021 Chevrolet Equinox LTUsed	Used Retail	$18,514	$3,606	$976	$4,582	85
SLE-00000638	29 December 2025	Granite Subaru	2022 Subaru BRZ LimitedUsed	Used Retail	$24,207	$5,335	$1,190	$6,525	110
SLE-00000640	29 December 2025	Granite Subaru	2026 Subaru Ascent BaseNew	Lease	$37,790	$444	$1,556	$2,000	97
SLE-00000630	27 December 2025	Granite Subaru	2025 Subaru Impreza BaseNew	New Retail	$23,933	-$181loss	$1,577	$1,396	53
SLE-00000631	27 December 2025	Granite Pre-Owned	2016 Volkswagen Jetta SUsed	Used Retail	$3,137	$202	$1,300	$1,502	37
SLE-00000632	27 December 2025	Granite Subaru	2024 Subaru Outback WildernessUsed	Used Retail	$24,849	$4,599	$992	$5,591	14
SLE-00000633	27 December 2025	Granite Subaru	2019 Kia Sportage EXUsed	Used Retail	$7,057	$247	$115	$361	145
SLE-00000634	27 December 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	New Retail	$38,053	$1,986	$739	$2,725	21
SLE-00000627	26 December 2025	Granite Pre-Owned	2021 Chevrolet Corvette Stingray 1LTUsed	Wholesalenot retail	$15,766	-$1,190loss	$0	-$1,190	34
SLE-00000628	26 December 2025	Granite Subaru	2025 Subaru Impreza BaseNew	New Retail	$23,393	-$43loss	$234	$191	42
SLE-00000629	26 December 2025	Granite Subaru	2022 Subaru Crosstrek LimitedUsed	Used Retail	$12,852	$1,280	$1,010	$2,290	114
SLE-00000621	25 December 2025	Granite Subaru	2020 Subaru Outback Onyx Edition XTCertified	Certified Retail	$13,480	$2,432	$1,168	$3,600	64
SLE-00000623	25 December 2025	Granite Subaru	2025 Subaru Forester BaseUsed	Used Retail	$45,709	$11,097	$1,229	$12,327	8
SLE-00000624	25 December 2025	Granite Pre-Owned	2025 Chevrolet Tahoe LSUsed	Used Retail	$36,161	$5,614	$1,771	$7,385	51
SLE-00000625	25 December 2025	Granite Subaru	2023 Chevrolet Trailblazer LSUsed	Used Retail	$17,838	$1,107	$2,017	$3,124	100
SLE-00000626	25 December 2025	Granite Subaru	2018 Subaru Crosstrek BaseCertified	Certified Retail	$5,278	$371	$692	$1,063	92
SLE-00000614	23 December 2025	Granite Subaru	2020 Subaru Outback Onyx Edition XTCertified	Certified Retail	$13,655	$2,169	$1,062	$3,231	24
SLE-00000615	23 December 2025	Granite Subaru	2024 Subaru Impreza RSNew	New Retail	$22,221	$141	$558	$699	48
SLE-00000616	23 December 2025	Granite Subaru	2024 Subaru Impreza RSNew	New Retail	$23,130	$496	$1,328	$1,824	42
SLE-00000610	20 December 2025	Granite Pre-Owned	2018 Hyundai Tucson SEUsed	Used Retail	$7,046	$1,151	$652	$1,803	43
SLE-00000612	20 December 2025	Granite Subaru	2024 Subaru Impreza RSNew	New Retail	$22,179	-$195loss	$1,039	$844	66

SLE-0000064731 December 2025
2024 Ford F-150 XL
Granite Pre-OwnedVEH-0000192UsedUsed RetailTrade
Sale price
$33,655
Front
$5,699
Back
$911
Total
$6,610
Walk-in or unattributedSalesperson: EMP-0002961 days in stock
SLE-0000064831 December 2025
2025 Subaru Ascent Touring
Granite SubaruVEH-0000257NewLease
Sale price
$35,401
Front
-$418loss
Back
$500
Total
$82
Walk-in or unattributedSalesperson: EMP-0001877 days in stock
SLE-0000064931 December 2025
2022 Ford Escape S
Granite Pre-OwnedVEH-0000455UsedUsed Retail
Sale price
$13,225
Front
$795
Back
$804
Total
$1,599
Source: Service Lane OpportunitySalesperson: EMP-00026138 days in stock
SLE-0000065031 December 2025
2025 Subaru Forester Base
Granite SubaruVEH-0000900UsedUsed Retail
Sale price
$42,268
Front
$7,125
Back
$585
Total
$7,710
Source: Showroom Walk-inSalesperson: EMP-0001836 days in stock
SLE-0000064330 December 2025
2021 Chevrolet Equinox LT
Granite Pre-OwnedVEH-0000236UsedUsed Retail
Sale price
$18,514
Front
$3,606
Back
$976
Total
$4,582
Source: Third-Party Trade Valuation PortalSalesperson: EMP-0002685 days in stock
SLE-0000063829 December 2025
2022 Subaru BRZ Limited
Granite SubaruVEH-0000205UsedUsed Retail
Sale price
$24,207
Front
$5,335
Back
$1,190
Total
$6,525
Walk-in or unattributedSalesperson: EMP-00018110 days in stock
SLE-0000064029 December 2025
2026 Subaru Ascent Base
Granite SubaruVEH-0000790NewLease
Sale price
$37,790
Front
$444
Back
$1,556
Total
$2,000
Source: Paid Search BrandSalesperson: EMP-0001697 days in stock
SLE-0000063027 December 2025
2025 Subaru Impreza Base
Granite SubaruVEH-0000226NewNew RetailTrade
Sale price
$23,933
Front
-$181loss
Back
$1,577
Total
$1,396
Source: Service Lane OpportunitySalesperson: EMP-0001653 days in stock
SLE-0000063127 December 2025
2016 Volkswagen Jetta S
Granite Pre-OwnedVEH-0000363UsedUsed RetailTrade
Sale price
$3,137
Front
$202
Back
$1,300
Total
$1,502
Walk-in or unattributedSalesperson: EMP-0002737 days in stock
SLE-0000063227 December 2025
2024 Subaru Outback Wilderness
Granite SubaruVEH-0000474UsedUsed Retail
Sale price
$24,849
Front
$4,599
Back
$992
Total
$5,591
Source: Paid Search BrandSalesperson: EMP-0001514 days in stock
SLE-0000063327 December 2025
2019 Kia Sportage EX
Granite SubaruVEH-0000615UsedUsed Retail
Sale price
$7,057
Front
$247
Back
$115
Total
$361
Source: Dealer Website FormSalesperson: EMP-00016145 days in stock
SLE-0000063427 December 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000801NewNew RetailTrade
Sale price
$38,053
Front
$1,986
Back
$739
Total
$2,725
Source: Showroom Walk-inSalesperson: EMP-0001621 days in stock
SLE-0000062726 December 2025
2021 Chevrolet Corvette Stingray 1LT
Granite Pre-OwnedVEH-0000138UsedWholesale
Sale price
$15,766
Front
-$1,190loss
Back
$0
Total
-$1,190
Walk-in or unattributedSalesperson: EMP-0002534 days in stock
SLE-0000062826 December 2025
2025 Subaru Impreza Base
Granite SubaruVEH-0000307NewNew RetailTrade
Sale price
$23,393
Front
-$43loss
Back
$234
Total
$191
Source: Paid Search BrandSalesperson: EMP-0001642 days in stock
SLE-0000062926 December 2025
2022 Subaru Crosstrek Limited
Granite SubaruVEH-0000586UsedUsed Retail
Sale price
$12,852
Front
$1,280
Back
$1,010
Total
$2,290
Walk-in or unattributedSalesperson: EMP-00016114 days in stock
SLE-0000062125 December 2025
2020 Subaru Outback Onyx Edition XT
Granite SubaruVEH-0000466CertifiedCertified RetailTrade
Sale price
$13,480
Front
$2,432
Back
$1,168
Total
$3,600
Source: Showroom Walk-inSalesperson: EMP-0001564 days in stock
SLE-0000062325 December 2025
2025 Subaru Forester Base
Granite SubaruVEH-0000671UsedUsed RetailTrade
Sale price
$45,709
Front
$11,097
Back
$1,229
Total
$12,327
Source: Showroom Walk-inSalesperson: EMP-000168 days in stock
SLE-0000062425 December 2025
2025 Chevrolet Tahoe LS
Granite Pre-OwnedVEH-0000673UsedUsed Retail
Sale price
$36,161
Front
$5,614
Back
$1,771
Total
$7,385
Source: Customer ReferralSalesperson: EMP-0002951 days in stock
SLE-0000062525 December 2025
2023 Chevrolet Trailblazer LS
Granite SubaruVEH-0000759UsedUsed Retail
Sale price
$17,838
Front
$1,107
Back
$2,017
Total
$3,124
Source: Showroom Walk-inSalesperson: EMP-00016100 days in stock
SLE-0000062625 December 2025
2018 Subaru Crosstrek Base
Granite SubaruVEH-0000802CertifiedCertified RetailTrade
Sale price
$5,278
Front
$371
Back
$692
Total
$1,063
Source: Organic Search LandingSalesperson: EMP-0001692 days in stock
SLE-0000061423 December 2025
2020 Subaru Outback Onyx Edition XT
Granite SubaruVEH-0000001CertifiedCertified Retail
Sale price
$13,655
Front
$2,169
Back
$1,062
Total
$3,231
Source: Service Lane OpportunitySalesperson: EMP-0001524 days in stock
SLE-0000061523 December 2025
2024 Subaru Impreza RS
Granite SubaruVEH-0000048NewNew RetailTrade
Sale price
$22,221
Front
$141
Back
$558
Total
$699
Source: Paid Search BrandSalesperson: EMP-0001848 days in stock
SLE-0000061623 December 2025
2024 Subaru Impreza RS
Granite SubaruVEH-0000639NewNew Retail
Sale price
$23,130
Front
$496
Back
$1,328
Total
$1,824
Source: Direct Site VisitSalesperson: EMP-0001542 days in stock
SLE-0000061020 December 2025
2018 Hyundai Tucson SE
Granite Pre-OwnedVEH-0000418UsedUsed Retail
Sale price
$7,046
Front
$1,151
Back
$652
Total
$1,803
Source: Customer ReferralSalesperson: EMP-0002943 days in stock
SLE-0000061220 December 2025
2024 Subaru Impreza RS
Granite SubaruVEH-0000848NewNew Retail
Sale price
$22,179
Front
-$195loss
Back
$1,039
Total
$844
Source: Service Lane OpportunitySalesperson: EMP-0001866 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-00000647	VEH-0000192	Walk-in or unattributed	EMP-00029	EMP-00030	EMP-00028
SLE-00000648	VEH-0000257	Walk-in or unattributed	EMP-00018	EMP-00014	EMP-00017
SLE-00000649	VEH-0000455	Service Lane Opportunity	EMP-00026	EMP-00024	EMP-00028
SLE-00000650	VEH-0000900	Showroom Walk-in	EMP-00018	EMP-00014	EMP-00017
SLE-00000643	VEH-0000236	Third-Party Trade Valuation Portal	EMP-00026	EMP-00024	EMP-00028
SLE-00000638	VEH-0000205	Walk-in or unattributed	EMP-00018	EMP-00014	EMP-00017
SLE-00000640	VEH-0000790	Paid Search Brand	EMP-00016	EMP-00013	EMP-00017
SLE-00000630	VEH-0000226	Service Lane Opportunity	EMP-00016	EMP-00023	EMP-00017
SLE-00000631	VEH-0000363	Walk-in or unattributed	EMP-00027	EMP-00030	EMP-00028
SLE-00000632	VEH-0000474	Paid Search Brand	EMP-00015	EMP-00014	EMP-00017
SLE-00000633	VEH-0000615	Dealer Website Form	EMP-00016	EMP-00014	EMP-00017
SLE-00000634	VEH-0000801	Showroom Walk-in	EMP-00016	EMP-00013	Unattributed
SLE-00000627	VEH-0000138	Walk-in or unattributed	EMP-00025	EMP-00024	Unattributed
SLE-00000628	VEH-0000307	Paid Search Brand	EMP-00016	EMP-00023	EMP-00017
SLE-00000629	VEH-0000586	Walk-in or unattributed	EMP-00016	EMP-00013	EMP-00017
SLE-00000621	VEH-0000466	Showroom Walk-in	EMP-00015	EMP-00014	EMP-00017
SLE-00000623	VEH-0000671	Showroom Walk-in	EMP-00016	EMP-00013	Unattributed
SLE-00000624	VEH-0000673	Customer Referral	EMP-00029	EMP-00030	EMP-00028
SLE-00000625	VEH-0000759	Showroom Walk-in	EMP-00016	EMP-00014	EMP-00017
SLE-00000626	VEH-0000802	Organic Search Landing	EMP-00016	EMP-00023	EMP-00017
SLE-00000614	VEH-0000001	Service Lane Opportunity	EMP-00015	EMP-00023	EMP-00017
SLE-00000615	VEH-0000048	Paid Search Brand	EMP-00018	EMP-00013	EMP-00017
SLE-00000616	VEH-0000639	Direct Site Visit	EMP-00015	EMP-00023	EMP-00017
SLE-00000610	VEH-0000418	Customer Referral	EMP-00029	EMP-00024	EMP-00028
SLE-00000612	VEH-0000848	Service Lane Opportunity	EMP-00018	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.