Deal Explorer

136 deals · All three stores · August 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-08Remove 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

August 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: 136; Matching the current filters
Retail units: 116; 20 matched transactions are not retail
Total gross: $353,812; Retail rows only

Front gross: $226,505
Back gross: $127,307
Closed at a front loss: 36

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-00000192	14 August 2025	Granite Subaru	2024 Jeep Wrangler SportUsed	Used Retail	$28,155	$2,817	$374	$3,191	71
SLE-00000193	15 August 2025	Granite Chevrolet	2025 Chevrolet Tahoe LSNew	New Retail	$37,585	-$932loss	$773	-$159	137
SLE-00000194	15 August 2025	Granite Subaru	2018 Honda CR-V EXUsed	Used Retail	$6,071	$152	$590	$742	86
SLE-00000195	15 August 2025	Granite Subaru	2021 Subaru Forester BaseCertified	Certified Retail	$20,028	$4,225	$596	$4,821	29
SLE-00000196	15 August 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	Dealer Tradenot retail	$37,821	-$178loss	$0	-$178	31
SLE-00000197	16 August 2025	Granite Subaru	2024 Subaru Outback WildernessNew	New Retail	$29,420	$907	$2,700	$3,607	32
SLE-00000198	16 August 2025	Granite Subaru	2019 Subaru Forester BaseUsed	Used Retail	$10,844	$892	$561	$1,453	29
SLE-00000199	16 August 2025	Granite Chevrolet	2025 Chevrolet Tahoe LTNew	New Retail	$36,271	-$134loss	$734	$600	58
SLE-00000200	16 August 2025	Granite Pre-Owned	2020 Subaru Outback Onyx Edition XTUsed	Used Retail	$8,498	$1,283	$592	$1,875	4
SLE-00000201	16 August 2025	Granite Pre-Owned	2020 Chevrolet Blazer 3LTUsed	Used Retail	$8,530	$969	$860	$1,829	38
SLE-00000202	16 August 2025	Granite Pre-Owned	2017 Toyota RAV4 XLEUsed	Used Retail	$4,902	$658	$536	$1,194	19
SLE-00000203	18 August 2025	Granite Chevrolet	2019 Dodge Charger R/TUsed	Used Retail	$8,238	$408	$2,129	$2,537	53
SLE-00000204	18 August 2025	Granite Chevrolet	2022 Chevrolet Camaro ZL1Certified	Certified Retail	$21,883	$3,148	$287	$3,434	145
SLE-00000205	18 August 2025	Granite Chevrolet	2026 Chevrolet Colorado WTNew	New Retail	$45,267	-$87loss	$500	$413	3
SLE-00000206	18 August 2025	Granite Chevrolet	2022 Chevrolet Tahoe LTCertified	Certified Retail	$23,404	$3,232	$1,357	$4,589	60
SLE-00000207	19 August 2025	Granite Pre-Owned	2020 Chevrolet Suburban PremierUsed	Used Retail	$14,263	$1,000	$326	$1,326	75
SLE-00000208	19 August 2025	Granite Chevrolet	2024 Chevrolet Traverse LTUsed	Dealer Tradenot retail	$28,270	$1,046	$0	$1,046	41
SLE-00000209	19 August 2025	Granite Pre-Owned	2019 Chevrolet Equinox LTUsed	Dealer Tradenot retail	$5,087	-$389loss	$0	-$389	64
SLE-00000210	20 August 2025	Granite Subaru	2022 Subaru WRX GTUsed	Used Retail	$23,133	$3,389	$887	$4,276	27
SLE-00000211	21 August 2025	Granite Subaru	2025 Subaru Ascent Onyx EditionNew	New Retail	$37,018	$1,464	$207	$1,671	28
SLE-00000212	21 August 2025	Granite Pre-Owned	2026 Chevrolet Colorado WTUsed	Used Retail	$45,322	$3,836	$1,159	$4,995	90
SLE-00000213	22 August 2025	Granite Pre-Owned	2023 Ford Bronco Sport Big BendUsed	Used Retail	$16,663	$2,504	$1,570	$4,074	52
SLE-00000214	22 August 2025	Granite Chevrolet	2026 Chevrolet Blazer EV LTNew	Lease	$38,401	-$139loss	$729	$589	15
SLE-00000215	22 August 2025	Granite Chevrolet	2026 Chevrolet Blazer EV LTNew	New Retail	$38,515	$1,973	$1,319	$3,292	18
SLE-00000216	23 August 2025	Granite Chevrolet	2025 Chevrolet Blazer EV LTNew	New Retail	$35,172	-$601loss	$1,573	$973	127

SLE-0000019214 August 2025
2024 Jeep Wrangler Sport
Granite SubaruVEH-0000889UsedUsed RetailTrade
Sale price
$28,155
Front
$2,817
Back
$374
Total
$3,191
Walk-in or unattributedSalesperson: EMP-0001671 days in stock
SLE-0000019315 August 2025
2025 Chevrolet Tahoe LS
Granite ChevroletVEH-0000007NewNew Retail
Sale price
$37,585
Front
-$932loss
Back
$773
Total
-$159
Walk-in or unattributedSalesperson: EMP-00007137 days in stock
SLE-0000019415 August 2025
2018 Honda CR-V EX
Granite SubaruVEH-0000066UsedUsed Retail
Sale price
$6,071
Front
$152
Back
$590
Total
$742
Walk-in or unattributedSalesperson: EMP-0001586 days in stock
SLE-0000019515 August 2025
2021 Subaru Forester Base
Granite SubaruVEH-0000215CertifiedCertified Retail
Sale price
$20,028
Front
$4,225
Back
$596
Total
$4,821
Source: Showroom Walk-inSalesperson: EMP-0001829 days in stock
SLE-0000019615 August 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000775NewDealer Trade
Sale price
$37,821
Front
-$178loss
Back
$0
Total
-$178
Walk-in or unattributedSalesperson: EMP-0001831 days in stock
SLE-0000019716 August 2025
2024 Subaru Outback Wilderness
Granite SubaruVEH-0000244NewNew RetailTrade
Sale price
$29,420
Front
$907
Back
$2,700
Total
$3,607
Source: Community Partner ReferralSalesperson: EMP-0001632 days in stock
SLE-0000019816 August 2025
2019 Subaru Forester Base
Granite SubaruVEH-0000568UsedUsed RetailTrade
Sale price
$10,844
Front
$892
Back
$561
Total
$1,453
Source: Dealer Website FormSalesperson: EMP-0001829 days in stock
SLE-0000019916 August 2025
2025 Chevrolet Tahoe LT
Granite ChevroletVEH-0000588NewNew RetailTrade
Sale price
$36,271
Front
-$134loss
Back
$734
Total
$600
Source: Showroom Walk-inSalesperson: EMP-0000358 days in stock
SLE-0000020016 August 2025
2020 Subaru Outback Onyx Edition XT
Granite Pre-OwnedVEH-0000743UsedUsed Retail
Sale price
$8,498
Front
$1,283
Back
$592
Total
$1,875
Source: Community Partner ReferralSalesperson: EMP-000254 days in stock
SLE-0000020116 August 2025
2020 Chevrolet Blazer 3LT
Granite Pre-OwnedVEH-0000753UsedUsed Retail
Sale price
$8,530
Front
$969
Back
$860
Total
$1,829
Source: Showroom Walk-inSalesperson: EMP-0002538 days in stock
SLE-0000020216 August 2025
2017 Toyota RAV4 XLE
Granite Pre-OwnedVEH-0000755UsedUsed Retail
Sale price
$4,902
Front
$658
Back
$536
Total
$1,194
Source: Service Lane OpportunitySalesperson: EMP-0002919 days in stock
SLE-0000020318 August 2025
2019 Dodge Charger R/T
Granite ChevroletVEH-0000019UsedUsed Retail
Sale price
$8,238
Front
$408
Back
$2,129
Total
$2,537
Source: Paid Search BrandSalesperson: EMP-0000353 days in stock
SLE-0000020418 August 2025
2022 Chevrolet Camaro ZL1
Granite ChevroletVEH-0000151CertifiedCertified Retail
Sale price
$21,883
Front
$3,148
Back
$287
Total
$3,434
Source: Dealer Website FormSalesperson: EMP-00012145 days in stock
SLE-0000020518 August 2025
2026 Chevrolet Colorado WT
Granite ChevroletVEH-0000478NewNew Retail
Sale price
$45,267
Front
-$87loss
Back
$500
Total
$413
Source: Organic Search LandingSalesperson: EMP-000063 days in stock
SLE-0000020618 August 2025
2022 Chevrolet Tahoe LT
Granite ChevroletVEH-0000699CertifiedCertified RetailTrade
Sale price
$23,404
Front
$3,232
Back
$1,357
Total
$4,589
Source: Dealer Website FormSalesperson: EMP-0000660 days in stock
SLE-0000020719 August 2025
2020 Chevrolet Suburban Premier
Granite Pre-OwnedVEH-0000154UsedUsed Retail
Sale price
$14,263
Front
$1,000
Back
$326
Total
$1,326
Source: Dealer Website FormSalesperson: EMP-0002975 days in stock
SLE-0000020819 August 2025
2024 Chevrolet Traverse LT
Granite ChevroletVEH-0000763UsedDealer Trade
Sale price
$28,270
Front
$1,046
Back
$0
Total
$1,046
Walk-in or unattributedSalesperson: EMP-0000641 days in stock
SLE-0000020919 August 2025
2019 Chevrolet Equinox LT
Granite Pre-OwnedVEH-0000861UsedDealer Trade
Sale price
$5,087
Front
-$389loss
Back
$0
Total
-$389
Walk-in or unattributedSalesperson: EMP-0002564 days in stock
SLE-0000021020 August 2025
2022 Subaru WRX GT
Granite SubaruVEH-0000833UsedUsed Retail
Sale price
$23,133
Front
$3,389
Back
$887
Total
$4,276
Source: Dealer Website FormSalesperson: EMP-0001527 days in stock
SLE-0000021121 August 2025
2025 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000210NewNew Retail
Sale price
$37,018
Front
$1,464
Back
$207
Total
$1,671
Source: Showroom Walk-inSalesperson: EMP-0001528 days in stock
SLE-0000021221 August 2025
2026 Chevrolet Colorado WT
Granite Pre-OwnedVEH-0000632UsedUsed RetailTrade
Sale price
$45,322
Front
$3,836
Back
$1,159
Total
$4,995
Walk-in or unattributedSalesperson: EMP-0002590 days in stock
SLE-0000021322 August 2025
2023 Ford Bronco Sport Big Bend
Granite Pre-OwnedVEH-0000464UsedUsed RetailTrade
Sale price
$16,663
Front
$2,504
Back
$1,570
Total
$4,074
Source: Repeat Customer OutreachSalesperson: EMP-0002652 days in stock
SLE-0000021422 August 2025
2026 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000524NewLease
Sale price
$38,401
Front
-$139loss
Back
$729
Total
$589
Source: Community Partner ReferralSalesperson: EMP-0000615 days in stock
SLE-0000021522 August 2025
2026 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000654NewNew Retail
Sale price
$38,515
Front
$1,973
Back
$1,319
Total
$3,292
Source: Showroom Walk-inSalesperson: EMP-0000318 days in stock
SLE-0000021623 August 2025
2025 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000111NewNew Retail
Sale price
$35,172
Front
-$601loss
Back
$1,573
Total
$973
Source: Organic Search LandingSalesperson: EMP-00012127 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-00000192	VEH-0000889	Walk-in or unattributed	EMP-00016	EMP-00023	EMP-00017
SLE-00000193	VEH-0000007	Walk-in or unattributed	EMP-00007	EMP-00002	EMP-00005
SLE-00000194	VEH-0000066	Walk-in or unattributed	EMP-00015	EMP-00013	EMP-00017
SLE-00000195	VEH-0000215	Showroom Walk-in	EMP-00018	EMP-00014	EMP-00017
SLE-00000196	VEH-0000775	Walk-in or unattributed	EMP-00018	EMP-00013	Unattributed
SLE-00000197	VEH-0000244	Community Partner Referral	EMP-00016	EMP-00023	EMP-00017
SLE-00000198	VEH-0000568	Dealer Website Form	EMP-00018	EMP-00014	EMP-00017
SLE-00000199	VEH-0000588	Showroom Walk-in	EMP-00003	EMP-00008	EMP-00005
SLE-00000200	VEH-0000743	Community Partner Referral	EMP-00025	EMP-00024	EMP-00028
SLE-00000201	VEH-0000753	Showroom Walk-in	EMP-00025	EMP-00030	EMP-00028
SLE-00000202	VEH-0000755	Service Lane Opportunity	EMP-00029	EMP-00024	EMP-00028
SLE-00000203	VEH-0000019	Paid Search Brand	EMP-00003	EMP-00008	EMP-00005
SLE-00000204	VEH-0000151	Dealer Website Form	EMP-00012	EMP-00002	Unattributed
SLE-00000205	VEH-0000478	Organic Search Landing	EMP-00006	EMP-00002	Unattributed
SLE-00000206	VEH-0000699	Dealer Website Form	EMP-00006	EMP-00008	EMP-00005
SLE-00000207	VEH-0000154	Dealer Website Form	EMP-00029	EMP-00024	EMP-00028
SLE-00000208	VEH-0000763	Walk-in or unattributed	EMP-00006	EMP-00001	Unattributed
SLE-00000209	VEH-0000861	Walk-in or unattributed	EMP-00025	EMP-00030	Unattributed
SLE-00000210	VEH-0000833	Dealer Website Form	EMP-00015	EMP-00013	EMP-00017
SLE-00000211	VEH-0000210	Showroom Walk-in	EMP-00015	EMP-00023	EMP-00017
SLE-00000212	VEH-0000632	Walk-in or unattributed	EMP-00025	EMP-00024	EMP-00028
SLE-00000213	VEH-0000464	Repeat Customer Outreach	EMP-00026	EMP-00024	EMP-00028
SLE-00000214	VEH-0000524	Community Partner Referral	EMP-00006	EMP-00008	EMP-00005
SLE-00000215	VEH-0000654	Showroom Walk-in	EMP-00003	EMP-00002	EMP-00005
SLE-00000216	VEH-0000111	Organic Search Landing	EMP-00012	EMP-00008	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.