Deal Explorer

106 deals · All three stores · 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 and controlsnone 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: 106; Matching the current filters
Retail units: 92; 14 matched transactions are not retail
Total gross: $321,935; Retail rows only

Front gross: $213,657
Back gross: $108,277
Closed at a front loss: 23

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-00000545	1 December 2025	Granite Chevrolet	2026 Chevrolet Blazer EV LTNew	Lease	$39,071	$562	$880	$1,442	27
SLE-00000546	1 December 2025	Granite Chevrolet	2024 Chevrolet Traverse LTNew	New Retail	$34,600	-$716loss	$1,871	$1,155	97
SLE-00000547	1 December 2025	Granite Subaru	2026 Subaru Outback Onyx Edition XTNew	New Retail	$31,761	$391	$578	$969	30
SLE-00000548	1 December 2025	Granite Chevrolet	2021 RAM 1500 TradesmanUsed	Dealer Tradenot retail	$16,111	-$1,071loss	$0	-$1,071	75
SLE-00000549	2 December 2025	Granite Chevrolet	2024 Chevrolet Blazer EV LTNew	Lease	$36,474	$574	$611	$1,185	32
SLE-00000550	2 December 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSUsed	Used Retail	$40,080	$5,561	$978	$6,539	55
SLE-00000551	2 December 2025	Granite Pre-Owned	2020 Jeep Wrangler SportUsed	Used Retail	$14,300	$3,372	$2,175	$5,547	20
SLE-00000552	3 December 2025	Granite Subaru	2020 Ford F-150 XLTUsed	Used Retail	$15,125	$2,131	$289	$2,420	64
SLE-00000553	3 December 2025	Granite Pre-Owned	2022 Hyundai Elantra SELUsed	Used Retail	$11,539	$1,507	$755	$2,262	103
SLE-00000554	3 December 2025	Granite Chevrolet	2023 Chevrolet Equinox LSUsed	Wholesalenot retail	$20,604	-$1,405loss	$0	-$1,405	91
SLE-00000555	4 December 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	New Retail	$38,612	$1,632	$404	$2,036	63
SLE-00000556	4 December 2025	Granite Subaru	2024 Chevrolet Blazer EV LTUsed	Used Retail	$31,987	$4,621	$1,534	$6,155	146
SLE-00000557	5 December 2025	Granite Pre-Owned	2024 Jeep Wrangler RubiconUsed	Used Retail	$31,742	$2,690	$452	$3,142	162
SLE-00000558	5 December 2025	Granite Pre-Owned	2025 Chevrolet Tahoe LSUsed	Used Retail	$42,518	$5,577	$1,536	$7,114	94
SLE-00000559	5 December 2025	Granite Chevrolet	2025 Chevrolet Blazer EV LTNew	New Retail	$36,164	$1,078	$2,489	$3,567	35
SLE-00000560	5 December 2025	Granite Chevrolet	2021 Toyota Camry XSEUsed	Used Retail	$15,177	$2,269	$1,607	$3,877	70
SLE-00000561	5 December 2025	Granite Subaru	2019 Subaru Forester BaseCertified	Certified Retail	$11,418	$1,549	$1,158	$2,708	3
SLE-00000562	5 December 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	New Retail	$37,092	$676	$1,773	$2,450	238
SLE-00000563	5 December 2025	Granite Pre-Owned	2023 Dodge Charger SXTUsed	Used Retail	$23,904	$3,256	$1,130	$4,385	14
SLE-00000564	5 December 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	Lease	$38,817	$1,734	$968	$2,703	116
SLE-00000565	5 December 2025	Granite Subaru	2017 Subaru Impreza SportUsed	Used Retail	$2,925	-$459loss	$708	$249	105
SLE-00000566	6 December 2025	Granite Pre-Owned	2016 Toyota Camry SEUsed	Used Retail	$3,696	$117	$1,863	$1,981	94
SLE-00000567	6 December 2025	Granite Subaru	2018 Subaru Crosstrek BaseUsed	Wholesalenot retail	$2,689	-$736loss	$0	-$736	47
SLE-00000568	6 December 2025	Granite Chevrolet	2024 Chevrolet Blazer EV LTUsed	Wholesalenot retail	$23,336	-$1,457loss	$0	-$1,457	105
SLE-00000569	6 December 2025	Granite Pre-Owned	2026 Subaru Ascent Onyx EditionUsed	Used Retail	$40,787	$4,187	$1,516	$5,704	123

SLE-000005451 December 2025
2026 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000080NewLeaseTrade
Sale price
$39,071
Front
$562
Back
$880
Total
$1,442
Walk-in or unattributedSalesperson: EMP-0000327 days in stock
SLE-000005461 December 2025
2024 Chevrolet Traverse LT
Granite ChevroletVEH-0000112NewNew Retail
Sale price
$34,600
Front
-$716loss
Back
$1,871
Total
$1,155
Walk-in or unattributedSalesperson: EMP-0001297 days in stock
SLE-000005471 December 2025
2026 Subaru Outback Onyx Edition XT
Granite SubaruVEH-0000187NewNew RetailTrade
Sale price
$31,761
Front
$391
Back
$578
Total
$969
Source: Community Partner ReferralSalesperson: EMP-0001530 days in stock
SLE-000005481 December 2025
2021 RAM 1500 Tradesman
Granite ChevroletVEH-0000422UsedDealer Trade
Sale price
$16,111
Front
-$1,071loss
Back
$0
Total
-$1,071
Walk-in or unattributedSalesperson: EMP-0000775 days in stock
SLE-000005492 December 2025
2024 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000372NewLease
Sale price
$36,474
Front
$574
Back
$611
Total
$1,185
Source: Paid Search BrandSalesperson: EMP-0000632 days in stock
SLE-000005502 December 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000791UsedUsed Retail
Sale price
$40,080
Front
$5,561
Back
$978
Total
$6,539
Walk-in or unattributedSalesperson: EMP-0001255 days in stock
SLE-000005512 December 2025
2020 Jeep Wrangler Sport
Granite Pre-OwnedVEH-0000874UsedUsed RetailTrade
Sale price
$14,300
Front
$3,372
Back
$2,175
Total
$5,547
Walk-in or unattributedSalesperson: EMP-0002520 days in stock
SLE-000005523 December 2025
2020 Ford F-150 XLT
Granite SubaruVEH-0000026UsedUsed RetailTrade
Sale price
$15,125
Front
$2,131
Back
$289
Total
$2,420
Source: Dealer Website FormSalesperson: EMP-0001864 days in stock
SLE-000005533 December 2025
2022 Hyundai Elantra SEL
Granite Pre-OwnedVEH-0000085UsedUsed RetailTrade
Sale price
$11,539
Front
$1,507
Back
$755
Total
$2,262
Source: Dealer Website FormSalesperson: EMP-00025103 days in stock
SLE-000005543 December 2025
2023 Chevrolet Equinox LS
Granite ChevroletVEH-0000420UsedWholesale
Sale price
$20,604
Front
-$1,405loss
Back
$0
Total
-$1,405
Walk-in or unattributedSalesperson: EMP-0001091 days in stock
SLE-000005554 December 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000443NewNew Retail
Sale price
$38,612
Front
$1,632
Back
$404
Total
$2,036
Source: Dealer Website FormSalesperson: EMP-0001563 days in stock
SLE-000005564 December 2025
2024 Chevrolet Blazer EV LT
Granite SubaruVEH-0000541UsedUsed RetailTrade
Sale price
$31,987
Front
$4,621
Back
$1,534
Total
$6,155
Source: Paid Search BrandSalesperson: EMP-00015146 days in stock
SLE-000005575 December 2025
2024 Jeep Wrangler Rubicon
Granite Pre-OwnedVEH-0000163UsedUsed Retail
Sale price
$31,742
Front
$2,690
Back
$452
Total
$3,142
Source: Dealer Website FormSalesperson: EMP-00025162 days in stock
SLE-000005585 December 2025
2025 Chevrolet Tahoe LS
Granite Pre-OwnedVEH-0000284UsedUsed Retail
Sale price
$42,518
Front
$5,577
Back
$1,536
Total
$7,114
Walk-in or unattributedSalesperson: EMP-0002694 days in stock
SLE-000005595 December 2025
2025 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000306NewNew Retail
Sale price
$36,164
Front
$1,078
Back
$2,489
Total
$3,567
Source: Third-Party Marketplace ListingSalesperson: EMP-0000335 days in stock
SLE-000005605 December 2025
2021 Toyota Camry XSE
Granite ChevroletVEH-0000343UsedUsed Retail
Sale price
$15,177
Front
$2,269
Back
$1,607
Total
$3,877
Source: Service Lane OpportunitySalesperson: EMP-0000670 days in stock
SLE-000005615 December 2025
2019 Subaru Forester Base
Granite SubaruVEH-0000462CertifiedCertified RetailTrade
Sale price
$11,418
Front
$1,549
Back
$1,158
Total
$2,708
Walk-in or unattributedSalesperson: EMP-000183 days in stock
SLE-000005625 December 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000513NewNew Retail
Sale price
$37,092
Front
$676
Back
$1,773
Total
$2,450
Source: Paid Search Non-BrandSalesperson: EMP-00016238 days in stock
SLE-000005635 December 2025
2023 Dodge Charger SXT
Granite Pre-OwnedVEH-0000542UsedUsed Retail
Sale price
$23,904
Front
$3,256
Back
$1,130
Total
$4,385
Walk-in or unattributedSalesperson: EMP-0002514 days in stock
SLE-000005645 December 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000558NewLease
Sale price
$38,817
Front
$1,734
Back
$968
Total
$2,703
Walk-in or unattributedSalesperson: EMP-00015116 days in stock
SLE-000005655 December 2025
2017 Subaru Impreza Sport
Granite SubaruVEH-0000564UsedUsed RetailTrade
Sale price
$2,925
Front
-$459loss
Back
$708
Total
$249
Source: Customer ReferralSalesperson: EMP-00016105 days in stock
SLE-000005666 December 2025
2016 Toyota Camry SE
Granite Pre-OwnedVEH-0000022UsedUsed Retail
Sale price
$3,696
Front
$117
Back
$1,863
Total
$1,981
Source: Organic Search LandingSalesperson: EMP-0002694 days in stock
SLE-000005676 December 2025
2018 Subaru Crosstrek Base
Granite SubaruVEH-0000132UsedWholesale
Sale price
$2,689
Front
-$736loss
Back
$0
Total
-$736
Walk-in or unattributedSalesperson: EMP-0001647 days in stock
SLE-000005686 December 2025
2024 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000377UsedWholesale
Sale price
$23,336
Front
-$1,457loss
Back
$0
Total
-$1,457
Walk-in or unattributedSalesperson: EMP-00012105 days in stock
SLE-000005696 December 2025
2026 Subaru Ascent Onyx Edition
Granite Pre-OwnedVEH-0000633UsedUsed Retail
Sale price
$40,787
Front
$4,187
Back
$1,516
Total
$5,704
Source: Showroom Walk-inSalesperson: EMP-00026123 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-00000545	VEH-0000080	Walk-in or unattributed	EMP-00003	EMP-00008	EMP-00005
SLE-00000546	VEH-0000112	Walk-in or unattributed	EMP-00012	EMP-00002	EMP-00005
SLE-00000547	VEH-0000187	Community Partner Referral	EMP-00015	EMP-00023	EMP-00017
SLE-00000548	VEH-0000422	Walk-in or unattributed	EMP-00007	EMP-00008	Unattributed
SLE-00000549	VEH-0000372	Paid Search Brand	EMP-00006	EMP-00002	EMP-00005
SLE-00000550	VEH-0000791	Walk-in or unattributed	EMP-00012	EMP-00002	EMP-00005
SLE-00000551	VEH-0000874	Walk-in or unattributed	EMP-00025	EMP-00024	EMP-00028
SLE-00000552	VEH-0000026	Dealer Website Form	EMP-00018	EMP-00013	Unattributed
SLE-00000553	VEH-0000085	Dealer Website Form	EMP-00025	EMP-00024	EMP-00028
SLE-00000554	VEH-0000420	Walk-in or unattributed	EMP-00010	EMP-00008	Unattributed
SLE-00000555	VEH-0000443	Dealer Website Form	EMP-00015	EMP-00013	EMP-00017
SLE-00000556	VEH-0000541	Paid Search Brand	EMP-00015	EMP-00023	EMP-00017
SLE-00000557	VEH-0000163	Dealer Website Form	EMP-00025	EMP-00024	EMP-00028
SLE-00000558	VEH-0000284	Walk-in or unattributed	EMP-00026	EMP-00030	EMP-00028
SLE-00000559	VEH-0000306	Third-Party Marketplace Listing	EMP-00003	EMP-00002	EMP-00005
SLE-00000560	VEH-0000343	Service Lane Opportunity	EMP-00006	EMP-00008	EMP-00005
SLE-00000561	VEH-0000462	Walk-in or unattributed	EMP-00018	EMP-00013	EMP-00017
SLE-00000562	VEH-0000513	Paid Search Non-Brand	EMP-00016	EMP-00023	EMP-00017
SLE-00000563	VEH-0000542	Walk-in or unattributed	EMP-00025	EMP-00024	EMP-00028
SLE-00000564	VEH-0000558	Walk-in or unattributed	EMP-00015	EMP-00013	EMP-00017
SLE-00000565	VEH-0000564	Customer Referral	EMP-00016	EMP-00023	EMP-00017
SLE-00000566	VEH-0000022	Organic Search Landing	EMP-00026	EMP-00024	EMP-00028
SLE-00000567	VEH-0000132	Walk-in or unattributed	EMP-00016	EMP-00013	Unattributed
SLE-00000568	VEH-0000377	Walk-in or unattributed	EMP-00012	EMP-00008	Unattributed
SLE-00000569	VEH-0000633	Showroom Walk-in	EMP-00026	EMP-00024	EMP-00028

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.