Deal Explorer

35 deals · Granite Subaru · 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

Reset filters

Filters and controls2 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: 35; Matching the current filters
Retail units: 30; 5 matched transactions are not retail
Total gross: $69,354; Retail rows only

Front gross: $31,509
Back gross: $37,845
Closed at a front loss: 12

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-00000451	31 October 2025	Granite Subaru	2025 Subaru Impreza BaseNew	New Retail	$22,901	-$568loss	$1,343	$775	65
SLE-00000448	29 October 2025	Granite Subaru	2021 Subaru Forester BaseUsed	Used Retail	$14,823	$2,361	$1,821	$4,182	44
SLE-00000442	28 October 2025	Granite Subaru	2022 Subaru Outback BaseCertified	Certified Retail	$19,150	$1,190	$790	$1,980	61
SLE-00000447	28 October 2025	Granite Subaru	2026 Subaru Outback Onyx Edition XTNew	New Retail	$30,855	$309	$825	$1,134	49
SLE-00000438	27 October 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	Wholesalenot retail	$36,285	-$2,216loss	$0	-$2,216	76
SLE-00000439	27 October 2025	Granite Subaru	2025 Subaru Impreza SportCertified	Certified Retail	$29,517	$5,773	$779	$6,552	60
SLE-00000440	27 October 2025	Granite Subaru	2017 Subaru Impreza SportUsed	Used Retail	$2,661	-$521loss	$1,556	$1,035	132
SLE-00000441	27 October 2025	Granite Subaru	2026 Subaru Ascent BaseNew	New Retail	$40,950	$2,892	$800	$3,692	31
SLE-00000437	26 October 2025	Granite Subaru	2025 Subaru Ascent Onyx EditionNew	New Retail	$36,264	-$932loss	$2,332	$1,401	47
SLE-00000431	25 October 2025	Granite Subaru	2023 Subaru Impreza BaseCertified	Wholesalenot retail	$14,792	-$741loss	$0	-$741	44
SLE-00000432	25 October 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	New Retail	$37,111	$807	$458	$1,265	87
SLE-00000428	24 October 2025	Granite Subaru	2023 Toyota RAV4 XLEUsed	Wholesalenot retail	$20,815	-$1,123loss	$0	-$1,123	66
SLE-00000429	24 October 2025	Granite Subaru	2022 Kia Telluride EXUsed	Used Retail	$20,635	$4,260	$228	$4,489	43
SLE-00000424	23 October 2025	Granite Subaru	2018 Subaru Outback LimitedUsed	Used Retail	$7,132	$146	$1,618	$1,764	69
SLE-00000420	22 October 2025	Granite Subaru	2020 Ford Escape TitaniumUsed	Used Retail	$9,095	$438	$145	$584	22
SLE-00000414	21 October 2025	Granite Subaru	2016 Subaru Legacy BaseUsed	Used Retail	$3,911	$163	$1,066	$1,230	21
SLE-00000415	21 October 2025	Granite Subaru	2016 Toyota Camry SEUsed	Used Retail	$4,238	$309	$876	$1,185	26
SLE-00000410	18 October 2025	Granite Subaru	2020 Subaru Outback Onyx Edition XTUsed	Used Retail	$10,821	$1,654	$2,546	$4,200	25
SLE-00000409	17 October 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	New Retail	$36,328	-$1,157loss	$591	-$566	46
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-00000400	14 October 2025	Granite Subaru	2021 Subaru Forester BaseUsed	Used Retail	$17,233	$2,706	$1,562	$4,268	15
SLE-00000396	13 October 2025	Granite Subaru	2021 Subaru Forester BaseUsed	Used Retail	$14,038	$1,020	$969	$1,989	94
SLE-00000390	11 October 2025	Granite Subaru	2025 Subaru Ascent Onyx EditionNew	New Retail	$36,890	-$663loss	$2,548	$1,884	51
SLE-00000388	10 October 2025	Granite Subaru	2025 Subaru Forester BaseCertified	Dealer Tradenot retail	$32,645	$983	$0	$983	10

SLE-0000045131 October 2025
2025 Subaru Impreza Base
Granite SubaruVEH-0000446NewNew RetailTrade
Sale price
$22,901
Front
-$568loss
Back
$1,343
Total
$775
Walk-in or unattributedSalesperson: EMP-0001865 days in stock
SLE-0000044829 October 2025
2021 Subaru Forester Base
Granite SubaruVEH-0000251UsedUsed Retail
Sale price
$14,823
Front
$2,361
Back
$1,821
Total
$4,182
Source: Showroom Walk-inSalesperson: EMP-0001544 days in stock
SLE-0000044228 October 2025
2022 Subaru Outback Base
Granite SubaruVEH-0000061CertifiedCertified RetailTrade
Sale price
$19,150
Front
$1,190
Back
$790
Total
$1,980
Walk-in or unattributedSalesperson: EMP-0001861 days in stock
SLE-0000044728 October 2025
2026 Subaru Outback Onyx Edition XT
Granite SubaruVEH-0000746NewNew Retail
Sale price
$30,855
Front
$309
Back
$825
Total
$1,134
Source: Third-Party Marketplace ListingSalesperson: EMP-0001649 days in stock
SLE-0000043827 October 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000155NewWholesale
Sale price
$36,285
Front
-$2,216loss
Back
$0
Total
-$2,216
Walk-in or unattributedSalesperson: EMP-0001676 days in stock
SLE-0000043927 October 2025
2025 Subaru Impreza Sport
Granite SubaruVEH-0000176CertifiedCertified RetailTrade
Sale price
$29,517
Front
$5,773
Back
$779
Total
$6,552
Source: Service Lane OpportunitySalesperson: EMP-0001860 days in stock
SLE-0000044027 October 2025
2017 Subaru Impreza Sport
Granite SubaruVEH-0000467UsedUsed Retail
Sale price
$2,661
Front
-$521loss
Back
$1,556
Total
$1,035
Source: Paid Social Feed CampaignSalesperson: EMP-00016132 days in stock
SLE-0000044127 October 2025
2026 Subaru Ascent Base
Granite SubaruVEH-0000658NewNew Retail
Sale price
$40,950
Front
$2,892
Back
$800
Total
$3,692
Source: Service Lane OpportunitySalesperson: EMP-0001531 days in stock
SLE-0000043726 October 2025
2025 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000862NewNew Retail
Sale price
$36,264
Front
-$932loss
Back
$2,332
Total
$1,401
Walk-in or unattributedSalesperson: EMP-0001647 days in stock
SLE-0000043125 October 2025
2023 Subaru Impreza Base
Granite SubaruVEH-0000087CertifiedWholesale
Sale price
$14,792
Front
-$741loss
Back
$0
Total
-$741
Walk-in or unattributedSalesperson: EMP-0001844 days in stock
SLE-0000043225 October 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000206NewNew RetailTrade
Sale price
$37,111
Front
$807
Back
$458
Total
$1,265
Source: Direct Mail ResponseSalesperson: EMP-0001587 days in stock
SLE-0000042824 October 2025
2023 Toyota RAV4 XLE
Granite SubaruVEH-0000139UsedWholesale
Sale price
$20,815
Front
-$1,123loss
Back
$0
Total
-$1,123
Walk-in or unattributedSalesperson: EMP-0001666 days in stock
SLE-0000042924 October 2025
2022 Kia Telluride EX
Granite SubaruVEH-0000520UsedUsed Retail
Sale price
$20,635
Front
$4,260
Back
$228
Total
$4,489
Source: Paid Search BrandSalesperson: EMP-0001643 days in stock
SLE-0000042423 October 2025
2018 Subaru Outback Limited
Granite SubaruVEH-0000628UsedUsed RetailTrade
Sale price
$7,132
Front
$146
Back
$1,618
Total
$1,764
Walk-in or unattributedSalesperson: EMP-0001869 days in stock
SLE-0000042022 October 2025
2020 Ford Escape Titanium
Granite SubaruVEH-0000532UsedUsed Retail
Sale price
$9,095
Front
$438
Back
$145
Total
$584
Source: Service Lane OpportunitySalesperson: EMP-0001522 days in stock
SLE-0000041421 October 2025
2016 Subaru Legacy Base
Granite SubaruVEH-0000004UsedUsed RetailTrade
Sale price
$3,911
Front
$163
Back
$1,066
Total
$1,230
Source: Service Lane OpportunitySalesperson: EMP-0001621 days in stock
SLE-0000041521 October 2025
2016 Toyota Camry SE
Granite SubaruVEH-0000077UsedUsed Retail
Sale price
$4,238
Front
$309
Back
$876
Total
$1,185
Source: Paid Search BrandSalesperson: EMP-0001826 days in stock
SLE-0000041018 October 2025
2020 Subaru Outback Onyx Edition XT
Granite SubaruVEH-0000188UsedUsed RetailTrade
Sale price
$10,821
Front
$1,654
Back
$2,546
Total
$4,200
Source: Repeat Customer OutreachSalesperson: EMP-0001625 days in stock
SLE-0000040917 October 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000870NewNew Retail
Sale price
$36,328
Front
-$1,157loss
Back
$591
Total
-$566
Source: Customer ReferralSalesperson: EMP-0001646 days in stock
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-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-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-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-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

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-00000451	VEH-0000446	Walk-in or unattributed	EMP-00018	EMP-00023	EMP-00017
SLE-00000448	VEH-0000251	Showroom Walk-in	EMP-00015	EMP-00013	EMP-00017
SLE-00000442	VEH-0000061	Walk-in or unattributed	EMP-00018	EMP-00014	EMP-00017
SLE-00000447	VEH-0000746	Third-Party Marketplace Listing	EMP-00016	EMP-00013	EMP-00017
SLE-00000438	VEH-0000155	Walk-in or unattributed	EMP-00016	EMP-00014	Unattributed
SLE-00000439	VEH-0000176	Service Lane Opportunity	EMP-00018	EMP-00014	EMP-00017
SLE-00000440	VEH-0000467	Paid Social Feed Campaign	EMP-00016	EMP-00013	EMP-00017
SLE-00000441	VEH-0000658	Service Lane Opportunity	EMP-00015	EMP-00013	EMP-00017
SLE-00000437	VEH-0000862	Walk-in or unattributed	EMP-00016	EMP-00013	EMP-00017
SLE-00000431	VEH-0000087	Walk-in or unattributed	EMP-00018	EMP-00013	Unattributed
SLE-00000432	VEH-0000206	Direct Mail Response	EMP-00015	EMP-00013	EMP-00017
SLE-00000428	VEH-0000139	Walk-in or unattributed	EMP-00016	EMP-00013	Unattributed
SLE-00000429	VEH-0000520	Paid Search Brand	EMP-00016	EMP-00023	Unattributed
SLE-00000424	VEH-0000628	Walk-in or unattributed	EMP-00018	EMP-00023	EMP-00017
SLE-00000420	VEH-0000532	Service Lane Opportunity	EMP-00015	EMP-00023	EMP-00017
SLE-00000414	VEH-0000004	Service Lane Opportunity	EMP-00016	EMP-00023	EMP-00017
SLE-00000415	VEH-0000077	Paid Search Brand	EMP-00018	EMP-00013	EMP-00017
SLE-00000410	VEH-0000188	Repeat Customer Outreach	EMP-00016	EMP-00013	EMP-00017
SLE-00000409	VEH-0000870	Customer Referral	EMP-00016	EMP-00023	EMP-00017
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-00000400	VEH-0000787	Showroom Walk-in	EMP-00016	EMP-00023	EMP-00017
SLE-00000396	VEH-0000431	Walk-in or unattributed	EMP-00016	EMP-00023	EMP-00017
SLE-00000390	VEH-0000119	Walk-in or unattributed	EMP-00015	EMP-00013	EMP-00017
SLE-00000388	VEH-0000056	Walk-in or unattributed	EMP-00016	EMP-00023	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.