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

Period: 2025-12Remove 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: 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-00000576	10 December 2025	Granite Chevrolet	2024 Chevrolet Blazer EV LTNew	Dealer Tradenot retail	$35,213	$313	$0	$313	91
SLE-00000577	10 December 2025	Granite Pre-Owned	2020 Ford F-150 XLTUsed	Wholesalenot retail	$11,709	-$932loss	$0	-$932	98
SLE-00000573	9 December 2025	Granite Pre-Owned	2020 Chrysler Pacifica Hybrid SelectUsed	Used Retail	$9,782	$1,723	$836	$2,559	78
SLE-00000572	8 December 2025	Granite Chevrolet	2024 Chevrolet Silverado EV RSTNew	Dealer Tradenot retail	$41,771	-$1,049loss	$0	-$1,049	45
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-00000570	6 December 2025	Granite Subaru	2022 Subaru BRZ LimitedUsed	Used Retail	$23,070	$4,479	$2,339	$6,818	18
SLE-00000571	6 December 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSNew	New Retail	$38,935	$1,324	$2,419	$3,742	53
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-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-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-00000549	2 December 2025	Granite Chevrolet	2024 Chevrolet Blazer EV LTNew	Lease	$36,474	$574	$611	$1,185	32

SLE-0000057610 December 2025
2024 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000571NewDealer Trade
Sale price
$35,213
Front
$313
Back
$0
Total
$313
Walk-in or unattributedSalesperson: EMP-0001091 days in stock
SLE-0000057710 December 2025
2020 Ford F-150 XLT
Granite Pre-OwnedVEH-0000608UsedWholesale
Sale price
$11,709
Front
-$932loss
Back
$0
Total
-$932
Walk-in or unattributedSalesperson: EMP-0002598 days in stock
SLE-000005739 December 2025
2020 Chrysler Pacifica Hybrid Select
Granite Pre-OwnedVEH-0000475UsedUsed RetailTrade
Sale price
$9,782
Front
$1,723
Back
$836
Total
$2,559
Source: Service Lane OpportunitySalesperson: EMP-0002978 days in stock
SLE-000005728 December 2025
2024 Chevrolet Silverado EV RST
Granite ChevroletVEH-0000329NewDealer Trade
Sale price
$41,771
Front
-$1,049loss
Back
$0
Total
-$1,049
Walk-in or unattributedSalesperson: EMP-0001045 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
SLE-000005706 December 2025
2022 Subaru BRZ Limited
Granite SubaruVEH-0000693UsedUsed Retail
Sale price
$23,070
Front
$4,479
Back
$2,339
Total
$6,818
Source: Paid Social Video CampaignSalesperson: EMP-0001618 days in stock
SLE-000005716 December 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000762NewNew RetailTrade
Sale price
$38,935
Front
$1,324
Back
$2,419
Total
$3,742
Source: Paid Search Non-BrandSalesperson: EMP-0000753 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-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-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-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

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-00000576	VEH-0000571	Walk-in or unattributed	EMP-00010	EMP-00002	Unattributed
SLE-00000577	VEH-0000608	Walk-in or unattributed	EMP-00025	EMP-00030	Unattributed
SLE-00000573	VEH-0000475	Service Lane Opportunity	EMP-00029	EMP-00024	EMP-00028
SLE-00000572	VEH-0000329	Walk-in or unattributed	EMP-00010	EMP-00001	Unattributed
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
SLE-00000570	VEH-0000693	Paid Social Video Campaign	EMP-00016	EMP-00013	EMP-00017
SLE-00000571	VEH-0000762	Paid Search Non-Brand	EMP-00007	EMP-00001	EMP-00005
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-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-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-00000549	VEH-0000372	Paid Search Brand	EMP-00006	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.