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-00000356	1 October 2025	Granite Subaru	2025 Subaru Forester BaseNew	New Retail	$39,127	$2,279	$1,090	$3,369	23
SLE-00000362	2 October 2025	Granite Subaru	2026 Subaru Ascent BaseUsed	Used Retail	$34,659	$1,758	$1,557	$3,315	98
SLE-00000367	3 October 2025	Granite Subaru	2025 Subaru Ascent TouringNew	Lease	$36,083	-$88loss	$1,429	$1,341	146
SLE-00000369	4 October 2025	Granite Subaru	2024 Subaru Outback WildernessNew	Wholesalenot retail	$24,577	-$3,577loss	$0	-$3,577	142
SLE-00000373	4 October 2025	Granite Subaru	2022 Subaru Crosstrek LimitedCertified	Lease	$13,349	$333	$514	$847	178
SLE-00000375	4 October 2025	Granite Subaru	2023 Dodge Charger SXTUsed	Used Retail	$20,869	$1,846	$1,400	$3,245	64
SLE-00000376	4 October 2025	Granite Subaru	2025 Subaru Impreza BaseNew	New Retail	$23,373	-$222loss	$636	$414	54
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-00000387	8 October 2025	Granite Subaru	2026 Subaru Ascent BaseNew	New Retail	$38,373	$1,014	$2,780	$3,794	37
SLE-00000388	10 October 2025	Granite Subaru	2025 Subaru Forester BaseCertified	Dealer Tradenot retail	$32,645	$983	$0	$983	10
SLE-00000390	11 October 2025	Granite Subaru	2025 Subaru Ascent Onyx EditionNew	New Retail	$36,890	-$663loss	$2,548	$1,884	51
SLE-00000396	13 October 2025	Granite Subaru	2021 Subaru Forester BaseUsed	Used Retail	$14,038	$1,020	$969	$1,989	94
SLE-00000400	14 October 2025	Granite Subaru	2021 Subaru Forester BaseUsed	Used Retail	$17,233	$2,706	$1,562	$4,268	15
SLE-00000401	15 October 2025	Granite Subaru	2024 Subaru Outback WildernessUsed	Used Retail	$24,451	$3,950	$1,892	$5,842	28
SLE-00000405	16 October 2025	Granite Subaru	2018 Subaru Crosstrek BaseUsed	Used Retail	$3,490	-$260loss	$914	$654	23
SLE-00000409	17 October 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	New Retail	$36,328	-$1,157loss	$591	-$566	46
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-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-00000420	22 October 2025	Granite Subaru	2020 Ford Escape TitaniumUsed	Used Retail	$9,095	$438	$145	$584	22
SLE-00000424	23 October 2025	Granite Subaru	2018 Subaru Outback LimitedUsed	Used Retail	$7,132	$146	$1,618	$1,764	69
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-00000431	25 October 2025	Granite Subaru	2023 Subaru Impreza BaseCertified	Wholesalenot retail	$14,792	-$741loss	$0	-$741	44

SLE-000003561 October 2025
2025 Subaru Forester Base
Granite SubaruVEH-0000317NewNew RetailTrade
Sale price
$39,127
Front
$2,279
Back
$1,090
Total
$3,369
Source: Radio Spot ResponseSalesperson: EMP-0001623 days in stock
SLE-000003622 October 2025
2026 Subaru Ascent Base
Granite SubaruVEH-0000408UsedUsed RetailTrade
Sale price
$34,659
Front
$1,758
Back
$1,557
Total
$3,315
Source: Showroom Walk-inSalesperson: EMP-0001598 days in stock
SLE-000003673 October 2025
2025 Subaru Ascent Touring
Granite SubaruVEH-0000769NewLeaseTrade
Sale price
$36,083
Front
-$88loss
Back
$1,429
Total
$1,341
Source: Third-Party Marketplace ListingSalesperson: EMP-00016146 days in stock
SLE-000003694 October 2025
2024 Subaru Outback Wilderness
Granite SubaruVEH-0000663NewWholesale
Sale price
$24,577
Front
-$3,577loss
Back
$0
Total
-$3,577
Walk-in or unattributedSalesperson: EMP-00018142 days in stock
SLE-000003734 October 2025
2022 Subaru Crosstrek Limited
Granite SubaruVEH-0000780CertifiedLease
Sale price
$13,349
Front
$333
Back
$514
Total
$847
Source: Repeat Customer OutreachSalesperson: EMP-00016178 days in stock
SLE-000003754 October 2025
2023 Dodge Charger SXT
Granite SubaruVEH-0000882UsedUsed Retail
Sale price
$20,869
Front
$1,846
Back
$1,400
Total
$3,245
Source: Third-Party Marketplace ListingSalesperson: EMP-0001664 days in stock
SLE-000003764 October 2025
2025 Subaru Impreza Base
Granite SubaruVEH-0000884NewNew RetailTrade
Sale price
$23,373
Front
-$222loss
Back
$636
Total
$414
Source: Direct Site VisitSalesperson: EMP-0001854 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-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-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-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-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-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-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-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-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-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-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-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-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-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-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

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-00000356	VEH-0000317	Radio Spot Response	EMP-00016	EMP-00013	EMP-00017
SLE-00000362	VEH-0000408	Showroom Walk-in	EMP-00015	EMP-00023	EMP-00017
SLE-00000367	VEH-0000769	Third-Party Marketplace Listing	EMP-00016	EMP-00023	EMP-00017
SLE-00000369	VEH-0000663	Walk-in or unattributed	EMP-00018	EMP-00013	Unattributed
SLE-00000373	VEH-0000780	Repeat Customer Outreach	EMP-00016	EMP-00013	EMP-00017
SLE-00000375	VEH-0000882	Third-Party Marketplace Listing	EMP-00016	EMP-00013	EMP-00017
SLE-00000376	VEH-0000884	Direct Site Visit	EMP-00018	EMP-00014	EMP-00017
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-00000387	VEH-0000788	Direct Mail Response	EMP-00015	EMP-00013	EMP-00017
SLE-00000388	VEH-0000056	Walk-in or unattributed	EMP-00016	EMP-00023	Unattributed
SLE-00000390	VEH-0000119	Walk-in or unattributed	EMP-00015	EMP-00013	EMP-00017
SLE-00000396	VEH-0000431	Walk-in or unattributed	EMP-00016	EMP-00023	EMP-00017
SLE-00000400	VEH-0000787	Showroom Walk-in	EMP-00016	EMP-00023	EMP-00017
SLE-00000401	VEH-0000137	Dealer Website Form	EMP-00016	EMP-00014	EMP-00017
SLE-00000405	VEH-0000730	Third-Party Trade Valuation Portal	EMP-00016	EMP-00014	EMP-00017
SLE-00000409	VEH-0000870	Customer Referral	EMP-00016	EMP-00023	EMP-00017
SLE-00000410	VEH-0000188	Repeat Customer Outreach	EMP-00016	EMP-00013	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-00000420	VEH-0000532	Service Lane Opportunity	EMP-00015	EMP-00023	EMP-00017
SLE-00000424	VEH-0000628	Walk-in or unattributed	EMP-00018	EMP-00023	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-00000431	VEH-0000087	Walk-in or unattributed	EMP-00018	EMP-00013	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.