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-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-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-00000182	14 August 2025	Granite Pre-Owned	2025 Chevrolet Tahoe LSUsed	Used Retail	$35,897	$5,992	$935	$6,927	24
SLE-00000183	14 August 2025	Granite Chevrolet	2024 Ford F-150 XLUsed	Used Retail	$35,932	$6,594	$558	$7,151	29
SLE-00000184	14 August 2025	Granite Pre-Owned	2018 Subaru Crosstrek BaseUsed	Used Retail	$6,220	$847	$732	$1,578	44
SLE-00000185	14 August 2025	Granite Chevrolet	2023 Chevrolet Trailblazer LSUsed	Used Retail	$18,428	$3,483	$639	$4,122	59
SLE-00000186	14 August 2025	Granite Chevrolet	2019 Chevrolet Equinox LSCertified	Certified Retail	$10,941	$1,667	$1,992	$3,658	48
SLE-00000187	14 August 2025	Granite Chevrolet	2021 Chevrolet Equinox LTUsed	Used Retail	$17,749	$2,985	$1,196	$4,180	56
SLE-00000188	14 August 2025	Granite Pre-Owned	2024 Chrysler Pacifica Hybrid SelectUsed	Used Retail	$27,195	$2,882	$426	$3,307	58
SLE-00000189	14 August 2025	Granite Pre-Owned	2018 Toyota Highlander XLEUsed	Used Retail	$5,354	$565	$929	$1,494	41
SLE-00000190	14 August 2025	Granite Chevrolet	2022 Chevrolet Camaro ZL1Certified	Wholesalenot retail	$19,581	-$1,353loss	$0	-$1,353	41
SLE-00000191	14 August 2025	Granite Chevrolet	2024 Chevrolet Blazer EV LTNew	New Retail	$35,323	$658	$1,448	$2,106	42
SLE-00000192	14 August 2025	Granite Subaru	2024 Jeep Wrangler SportUsed	Used Retail	$28,155	$2,817	$374	$3,191	71
SLE-00000177	13 August 2025	Granite Subaru	2026 Subaru Ascent Onyx EditionNew	New Retail	$40,502	$1,616	$808	$2,423	29
SLE-00000178	13 August 2025	Granite Pre-Owned	2017 Lexus RX 350 BaseUsed	Used Retail	$8,503	$1,562	$655	$2,216	8
SLE-00000179	13 August 2025	Granite Chevrolet	2024 Chevrolet Silverado EV RSTNew	New Retail	$43,498	$1,217	$2,504	$3,721	83
SLE-00000180	13 August 2025	Granite Chevrolet	2024 Chevrolet Silverado EV RSTCertified	Certified Retail	$39,046	$7,239	$546	$7,784	58

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-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-0000018214 August 2025
2025 Chevrolet Tahoe LS
Granite Pre-OwnedVEH-0000174UsedUsed Retail
Sale price
$35,897
Front
$5,992
Back
$935
Total
$6,927
Source: Dealer Website FormSalesperson: EMP-0002924 days in stock
SLE-0000018314 August 2025
2024 Ford F-150 XL
Granite ChevroletVEH-0000266UsedUsed RetailTrade
Sale price
$35,932
Front
$6,594
Back
$558
Total
$7,151
Source: Showroom Walk-inSalesperson: EMP-0000329 days in stock
SLE-0000018414 August 2025
2018 Subaru Crosstrek Base
Granite Pre-OwnedVEH-0000304UsedUsed Retail
Sale price
$6,220
Front
$847
Back
$732
Total
$1,578
Source: Paid Search Non-BrandSalesperson: EMP-0002544 days in stock
SLE-0000018514 August 2025
2023 Chevrolet Trailblazer LS
Granite ChevroletVEH-0000463UsedUsed Retail
Sale price
$18,428
Front
$3,483
Back
$639
Total
$4,122
Source: Showroom Walk-inSalesperson: EMP-0001059 days in stock
SLE-0000018614 August 2025
2019 Chevrolet Equinox LS
Granite ChevroletVEH-0000506CertifiedCertified Retail
Sale price
$10,941
Front
$1,667
Back
$1,992
Total
$3,658
Walk-in or unattributedSalesperson: EMP-0000348 days in stock
SLE-0000018714 August 2025
2021 Chevrolet Equinox LT
Granite ChevroletVEH-0000537UsedUsed RetailTrade
Sale price
$17,749
Front
$2,985
Back
$1,196
Total
$4,180
Source: Showroom Walk-inSalesperson: EMP-0000356 days in stock
SLE-0000018814 August 2025
2024 Chrysler Pacifica Hybrid Select
Granite Pre-OwnedVEH-0000614UsedUsed Retail
Sale price
$27,195
Front
$2,882
Back
$426
Total
$3,307
Walk-in or unattributedSalesperson: EMP-0002558 days in stock
SLE-0000018914 August 2025
2018 Toyota Highlander XLE
Granite Pre-OwnedVEH-0000839UsedUsed Retail
Sale price
$5,354
Front
$565
Back
$929
Total
$1,494
Walk-in or unattributedSalesperson: EMP-0002941 days in stock
SLE-0000019014 August 2025
2022 Chevrolet Camaro ZL1
Granite ChevroletVEH-0000865CertifiedWholesale
Sale price
$19,581
Front
-$1,353loss
Back
$0
Total
-$1,353
Walk-in or unattributedSalesperson: EMP-0001041 days in stock
SLE-0000019114 August 2025
2024 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000887NewNew RetailTrade
Sale price
$35,323
Front
$658
Back
$1,448
Total
$2,106
Source: Showroom Walk-inSalesperson: EMP-0001042 days in stock
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-0000017713 August 2025
2026 Subaru Ascent Onyx Edition
Granite SubaruVEH-0000156NewNew RetailTrade
Sale price
$40,502
Front
$1,616
Back
$808
Total
$2,423
Source: Organic Search LandingSalesperson: EMP-0002229 days in stock
SLE-0000017813 August 2025
2017 Lexus RX 350 Base
Granite Pre-OwnedVEH-0000200UsedUsed Retail
Sale price
$8,503
Front
$1,562
Back
$655
Total
$2,216
Source: Service Lane OpportunitySalesperson: EMP-000298 days in stock
SLE-0000017913 August 2025
2024 Chevrolet Silverado EV RST
Granite ChevroletVEH-0000275NewNew Retail
Sale price
$43,498
Front
$1,217
Back
$2,504
Total
$3,721
Source: Dealer Website FormSalesperson: EMP-0001083 days in stock
SLE-0000018013 August 2025
2024 Chevrolet Silverado EV RST
Granite ChevroletVEH-0000299CertifiedCertified Retail
Sale price
$39,046
Front
$7,239
Back
$546
Total
$7,784
Source: Customer ReferralSalesperson: EMP-0000758 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-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-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-00000182	VEH-0000174	Dealer Website Form	EMP-00029	EMP-00030	EMP-00028
SLE-00000183	VEH-0000266	Showroom Walk-in	EMP-00003	EMP-00001	Unattributed
SLE-00000184	VEH-0000304	Paid Search Non-Brand	EMP-00025	EMP-00030	EMP-00028
SLE-00000185	VEH-0000463	Showroom Walk-in	EMP-00010	EMP-00002	EMP-00005
SLE-00000186	VEH-0000506	Walk-in or unattributed	EMP-00003	EMP-00001	EMP-00005
SLE-00000187	VEH-0000537	Showroom Walk-in	EMP-00003	EMP-00002	EMP-00005
SLE-00000188	VEH-0000614	Walk-in or unattributed	EMP-00025	EMP-00024	EMP-00028
SLE-00000189	VEH-0000839	Walk-in or unattributed	EMP-00029	EMP-00024	EMP-00028
SLE-00000190	VEH-0000865	Walk-in or unattributed	EMP-00010	EMP-00002	Unattributed
SLE-00000191	VEH-0000887	Showroom Walk-in	EMP-00010	EMP-00002	EMP-00005
SLE-00000192	VEH-0000889	Walk-in or unattributed	EMP-00016	EMP-00023	EMP-00017
SLE-00000177	VEH-0000156	Organic Search Landing	EMP-00022	EMP-00014	EMP-00017
SLE-00000178	VEH-0000200	Service Lane Opportunity	EMP-00029	EMP-00030	EMP-00028
SLE-00000179	VEH-0000275	Dealer Website Form	EMP-00010	EMP-00002	EMP-00005
SLE-00000180	VEH-0000299	Customer Referral	EMP-00007	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.