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-00000181	13 August 2025	Granite Pre-Owned	2017 Toyota RAV4 XLEUsed	Used Retail	$4,373	$363	$572	$934	44
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-00000164	11 August 2025	Granite Subaru	2026 Chevrolet Silverado EV RSTUsed	Wholesalenot retail	$37,920	-$5,529loss	$0	-$5,529	17
SLE-00000165	11 August 2025	Granite Subaru	2022 Ford Escape SUsed	Used Retail	$16,392	$2,025	$1,608	$3,633	33
SLE-00000166	11 August 2025	Granite Chevrolet	2018 Nissan Rogue SUsed	Wholesalenot retail	$5,774	-$1,017loss	$0	-$1,017	7
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-00000156	9 August 2025	Granite Pre-Owned	2018 GMC Acadia SLTUsed	Used Retail	$5,242	$719	$773	$1,493	28
SLE-00000157	9 August 2025	Granite Subaru	2025 Subaru Impreza BaseUsed	Dealer Tradenot retail	$20,481	-$1,972loss	$0	-$1,972	54
SLE-00000158	9 August 2025	Granite Pre-Owned	2020 Kia Telluride SXUsed	Used Retail	$9,003	$583	$825	$1,408	68
SLE-00000159	9 August 2025	Granite Pre-Owned	2021 Chevrolet Equinox LTUsed	Used Retail	$16,872	$1,847	$1,601	$3,449	86
SLE-00000160	9 August 2025	Granite Chevrolet	2022 Chevrolet Bolt EUV PremierUsed	Used Retail	$14,872	$2,661	$939	$3,600	38
SLE-00000161	9 August 2025	Granite Subaru	2025 Subaru Impreza SportCertified	Certified Retail	$27,036	$4,650	$811	$5,461	16
SLE-00000162	9 August 2025	Granite Subaru	2025 Subaru Ascent TouringNew	Lease	$37,528	$1,249	$1,467	$2,716	82
SLE-00000163	9 August 2025	Granite Chevrolet	2026 Chevrolet Blazer EV LTNew	New Retail	$38,665	$1,682	$940	$2,622	36
SLE-00000148	8 August 2025	Granite Chevrolet	2026 Chevrolet Colorado Z71New	New Retail	$47,101	$499	$2,034	$2,533	31
SLE-00000149	8 August 2025	Granite Pre-Owned	2023 Ford Bronco Sport Big BendUsed	Used Retail	$18,156	$2,801	$1,093	$3,894	39
SLE-00000150	8 August 2025	Granite Subaru	2020 Subaru Outback Onyx Edition XTUsed	Used Retail	$9,061	$482	$972	$1,455	62

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-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-0000016411 August 2025
2026 Chevrolet Silverado EV RST
Granite SubaruVEH-0000278UsedWholesale
Sale price
$37,920
Front
-$5,529loss
Back
$0
Total
-$5,529
Walk-in or unattributedSalesperson: EMP-0001517 days in stock
SLE-0000016511 August 2025
2022 Ford Escape S
Granite SubaruVEH-0000627UsedUsed Retail
Sale price
$16,392
Front
$2,025
Back
$1,608
Total
$3,633
Source: Third-Party Marketplace ListingSalesperson: EMP-0002233 days in stock
SLE-0000016611 August 2025
2018 Nissan Rogue S
Granite ChevroletVEH-0000657UsedWholesale
Sale price
$5,774
Front
-$1,017loss
Back
$0
Total
-$1,017
Walk-in or unattributedSalesperson: EMP-000037 days in stock
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-000001569 August 2025
2018 GMC Acadia SLT
Granite Pre-OwnedVEH-0000145UsedUsed RetailTrade
Sale price
$5,242
Front
$719
Back
$773
Total
$1,493
Source: Customer ReferralSalesperson: EMP-0002728 days in stock
SLE-000001579 August 2025
2025 Subaru Impreza Base
Granite SubaruVEH-0000184UsedDealer Trade
Sale price
$20,481
Front
-$1,972loss
Back
$0
Total
-$1,972
Walk-in or unattributedSalesperson: EMP-0001854 days in stock
SLE-000001589 August 2025
2020 Kia Telluride SX
Granite Pre-OwnedVEH-0000197UsedUsed RetailTrade
Sale price
$9,003
Front
$583
Back
$825
Total
$1,408
Source: Showroom Walk-inSalesperson: EMP-0002568 days in stock
SLE-000001599 August 2025
2021 Chevrolet Equinox LT
Granite Pre-OwnedVEH-0000219UsedUsed RetailTrade
Sale price
$16,872
Front
$1,847
Back
$1,601
Total
$3,449
Walk-in or unattributedSalesperson: EMP-0002586 days in stock
SLE-000001609 August 2025
2022 Chevrolet Bolt EUV Premier
Granite ChevroletVEH-0000235UsedUsed RetailTrade
Sale price
$14,872
Front
$2,661
Back
$939
Total
$3,600
Source: Showroom Walk-inSalesperson: EMP-0000338 days in stock
SLE-000001619 August 2025
2025 Subaru Impreza Sport
Granite SubaruVEH-0000301CertifiedCertified Retail
Sale price
$27,036
Front
$4,650
Back
$811
Total
$5,461
Source: Showroom Walk-inSalesperson: EMP-0002216 days in stock
SLE-000001629 August 2025
2025 Subaru Ascent Touring
Granite SubaruVEH-0000416NewLease
Sale price
$37,528
Front
$1,249
Back
$1,467
Total
$2,716
Source: Dealer Website FormSalesperson: EMP-0002282 days in stock
SLE-000001639 August 2025
2026 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000771NewNew Retail
Sale price
$38,665
Front
$1,682
Back
$940
Total
$2,622
Walk-in or unattributedSalesperson: EMP-0001236 days in stock
SLE-000001488 August 2025
2026 Chevrolet Colorado Z71
Granite ChevroletVEH-0000113NewNew RetailTrade
Sale price
$47,101
Front
$499
Back
$2,034
Total
$2,533
Walk-in or unattributedSalesperson: EMP-0001231 days in stock
SLE-000001498 August 2025
2023 Ford Bronco Sport Big Bend
Granite Pre-OwnedVEH-0000201UsedUsed RetailTrade
Sale price
$18,156
Front
$2,801
Back
$1,093
Total
$3,894
Source: Showroom Walk-inSalesperson: EMP-0002939 days in stock
SLE-000001508 August 2025
2020 Subaru Outback Onyx Edition XT
Granite SubaruVEH-0000231UsedUsed Retail
Sale price
$9,061
Front
$482
Back
$972
Total
$1,455
Source: Third-Party Marketplace ListingSalesperson: EMP-0002262 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-00000181	VEH-0000854	Paid Search Non-Brand	EMP-00025	EMP-00030	EMP-00028
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-00000164	VEH-0000278	Walk-in or unattributed	EMP-00015	EMP-00023	Unattributed
SLE-00000165	VEH-0000627	Third-Party Marketplace Listing	EMP-00022	EMP-00023	EMP-00017
SLE-00000166	VEH-0000657	Walk-in or unattributed	EMP-00003	EMP-00002	Unattributed
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-00000156	VEH-0000145	Customer Referral	EMP-00027	EMP-00030	EMP-00028
SLE-00000157	VEH-0000184	Walk-in or unattributed	EMP-00018	EMP-00023	Unattributed
SLE-00000158	VEH-0000197	Showroom Walk-in	EMP-00025	EMP-00030	EMP-00028
SLE-00000159	VEH-0000219	Walk-in or unattributed	EMP-00025	EMP-00030	EMP-00028
SLE-00000160	VEH-0000235	Showroom Walk-in	EMP-00003	EMP-00001	EMP-00005
SLE-00000161	VEH-0000301	Showroom Walk-in	EMP-00022	EMP-00013	Unattributed
SLE-00000162	VEH-0000416	Dealer Website Form	EMP-00022	EMP-00023	EMP-00017
SLE-00000163	VEH-0000771	Walk-in or unattributed	EMP-00012	EMP-00001	EMP-00005
SLE-00000148	VEH-0000113	Walk-in or unattributed	EMP-00012	EMP-00001	EMP-00005
SLE-00000149	VEH-0000201	Showroom Walk-in	EMP-00029	EMP-00030	EMP-00028
SLE-00000150	VEH-0000231	Third-Party Marketplace Listing	EMP-00022	EMP-00023	EMP-00017

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.