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-00000167	11 August 2025	Granite Chevrolet	2022 Chevrolet Camaro ZL1Certified	Certified Retail	$24,886	$4,577	$1,497	$6,074	31
SLE-00000168	11 August 2025	Granite Subaru	2026 Subaru Ascent BaseNew	New Retail	$37,307	$1,168	$944	$2,112	37
SLE-00000169	11 August 2025	Granite Chevrolet	2024 Chevrolet Blazer EV LTUsed	Used Retail	$34,992	$7,435	$1,419	$8,853	117
SLE-00000170	12 August 2025	Granite Pre-Owned	2020 Ford F-150 XLTUsed	Used Retail	$12,496	$1,325	$929	$2,254	131
SLE-00000171	12 August 2025	Granite Subaru	2026 Subaru Ascent BaseNew	New Retail	$36,772	$260	$396	$656	27
SLE-00000172	12 August 2025	Granite Pre-Owned	2019 Dodge Charger R/TUsed	Wholesalenot retail	$6,547	-$1,144loss	$0	-$1,144	68
SLE-00000173	12 August 2025	Granite Chevrolet	2026 Chevrolet Silverado EV RSTNew	New Retail	$44,782	-$494loss	$512	$19	14
SLE-00000174	12 August 2025	Granite Subaru	2025 Subaru Impreza BaseNew	Lease	$22,808	-$620loss	$905	$285	84
SLE-00000175	12 August 2025	Granite Subaru	2021 Subaru Ascent BaseUsed	Used Retail	$14,606	$1,314	$937	$2,250	27
SLE-00000176	12 August 2025	Granite Chevrolet	2017 Chevrolet Camaro 1LTUsed	Wholesalenot retail	$4,126	-$1,304loss	$0	-$1,304	60
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-00000181	13 August 2025	Granite Pre-Owned	2017 Toyota RAV4 XLEUsed	Used Retail	$4,373	$363	$572	$934	44
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-0000016711 August 2025
2022 Chevrolet Camaro ZL1
Granite ChevroletVEH-0000669CertifiedCertified Retail
Sale price
$24,886
Front
$4,577
Back
$1,497
Total
$6,074
Source: Third-Party Marketplace ListingSalesperson: EMP-0000331 days in stock
SLE-0000016811 August 2025
2026 Subaru Ascent Base
Granite SubaruVEH-0000820NewNew RetailTrade
Sale price
$37,307
Front
$1,168
Back
$944
Total
$2,112
Source: Paid Search BrandSalesperson: EMP-0002237 days in stock
SLE-0000016911 August 2025
2024 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000845UsedUsed Retail
Sale price
$34,992
Front
$7,435
Back
$1,419
Total
$8,853
Source: Paid Search Non-BrandSalesperson: EMP-00006117 days in stock
SLE-0000017012 August 2025
2020 Ford F-150 XLT
Granite Pre-OwnedVEH-0000092UsedUsed Retail
Sale price
$12,496
Front
$1,325
Back
$929
Total
$2,254
Source: Customer ReferralSalesperson: EMP-00027131 days in stock
SLE-0000017112 August 2025
2026 Subaru Ascent Base
Granite SubaruVEH-0000098NewNew Retail
Sale price
$36,772
Front
$260
Back
$396
Total
$656
Source: Dealer Website ChatSalesperson: EMP-0002227 days in stock
SLE-0000017212 August 2025
2019 Dodge Charger R/T
Granite Pre-OwnedVEH-0000265UsedWholesale
Sale price
$6,547
Front
-$1,144loss
Back
$0
Total
-$1,144
Walk-in or unattributedSalesperson: EMP-0002968 days in stock
SLE-0000017312 August 2025
2026 Chevrolet Silverado EV RST
Granite ChevroletVEH-0000286NewNew Retail
Sale price
$44,782
Front
-$494loss
Back
$512
Total
$19
Source: Showroom Walk-inSalesperson: EMP-0000314 days in stock
SLE-0000017412 August 2025
2025 Subaru Impreza Base
Granite SubaruVEH-0000338NewLease
Sale price
$22,808
Front
-$620loss
Back
$905
Total
$285
Source: Direct Site VisitSalesperson: EMP-0001884 days in stock
SLE-0000017512 August 2025
2021 Subaru Ascent Base
Granite SubaruVEH-0000505UsedUsed Retail
Sale price
$14,606
Front
$1,314
Back
$937
Total
$2,250
Walk-in or unattributedSalesperson: EMP-0001827 days in stock
SLE-0000017612 August 2025
2017 Chevrolet Camaro 1LT
Granite ChevroletVEH-0000864UsedWholesale
Sale price
$4,126
Front
-$1,304loss
Back
$0
Total
-$1,304
Walk-in or unattributedSalesperson: EMP-0000360 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
SLE-0000018113 August 2025
2017 Toyota RAV4 XLE
Granite Pre-OwnedVEH-0000854UsedUsed Retail
Sale price
$4,373
Front
$363
Back
$572
Total
$934
Source: Paid Search Non-BrandSalesperson: EMP-0002544 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

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-00000167	VEH-0000669	Third-Party Marketplace Listing	EMP-00003	EMP-00008	EMP-00005
SLE-00000168	VEH-0000820	Paid Search Brand	EMP-00022	EMP-00023	Unattributed
SLE-00000169	VEH-0000845	Paid Search Non-Brand	EMP-00006	EMP-00002	EMP-00005
SLE-00000170	VEH-0000092	Customer Referral	EMP-00027	EMP-00030	EMP-00028
SLE-00000171	VEH-0000098	Dealer Website Chat	EMP-00022	EMP-00013	EMP-00017
SLE-00000172	VEH-0000265	Walk-in or unattributed	EMP-00029	EMP-00030	Unattributed
SLE-00000173	VEH-0000286	Showroom Walk-in	EMP-00003	EMP-00002	EMP-00005
SLE-00000174	VEH-0000338	Direct Site Visit	EMP-00018	EMP-00013	EMP-00017
SLE-00000175	VEH-0000505	Walk-in or unattributed	EMP-00018	EMP-00014	EMP-00017
SLE-00000176	VEH-0000864	Walk-in or unattributed	EMP-00003	EMP-00008	Unattributed
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
SLE-00000181	VEH-0000854	Paid Search Non-Brand	EMP-00025	EMP-00030	EMP-00028
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

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.