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-00000142	5 August 2025	Granite Pre-Owned	2024 Ford F-150 XLUsed	Used Retail	$37,651	$6,688	$687	$7,375	28
SLE-00000143	6 August 2025	Granite Chevrolet	2024 Chevrolet Camaro 1LTCertified	Certified Retail	$33,095	$4,254	$1,937	$6,190	28
SLE-00000144	7 August 2025	Granite Subaru	2020 Subaru Impreza BaseCertified	Certified Retail	$9,674	$1,290	$335	$1,625	50
SLE-00000145	7 August 2025	Granite Pre-Owned	2024 Chevrolet Camaro 1LTUsed	Wholesalenot retail	$23,015	-$1,966loss	$0	-$1,966	47
SLE-00000146	7 August 2025	Granite Pre-Owned	2022 Hyundai Elantra SELUsed	Used Retail	$14,359	$2,271	$373	$2,644	33
SLE-00000147	7 August 2025	Granite Pre-Owned	2016 Jeep Grand Cherokee LaredoUsed	Wholesalenot retail	$3,232	-$813loss	$0	-$813	29
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-00000151	8 August 2025	Granite Pre-Owned	2020 Chrysler Pacifica LimitedUsed	Used Retail	$11,447	$892	$988	$1,880	56
SLE-00000152	8 August 2025	Granite Pre-Owned	2021 Jeep Grand Cherokee OverlandUsed	Used Retail	$16,994	$3,236	$1,333	$4,569	11
SLE-00000153	8 August 2025	Granite Chevrolet	2024 Chevrolet Blazer EV LTNew	Lease	$34,315	-$599loss	$1,252	$653	148
SLE-00000154	8 August 2025	Granite Subaru	2025 Subaru Impreza BaseCertified	Certified Retail	$22,878	$3,083	$1,287	$4,370	32
SLE-00000155	8 August 2025	Granite Pre-Owned	2024 Jeep Wrangler SportUsed	Used Retail	$30,721	$3,242	$622	$3,863	46
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-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-000001425 August 2025
2024 Ford F-150 XL
Granite Pre-OwnedVEH-0000776UsedUsed Retail
Sale price
$37,651
Front
$6,688
Back
$687
Total
$7,375
Source: Paid Search BrandSalesperson: EMP-0002528 days in stock
SLE-000001436 August 2025
2024 Chevrolet Camaro 1LT
Granite ChevroletVEH-0000500CertifiedCertified RetailTrade
Sale price
$33,095
Front
$4,254
Back
$1,937
Total
$6,190
Walk-in or unattributedSalesperson: EMP-0000628 days in stock
SLE-000001447 August 2025
2020 Subaru Impreza Base
Granite SubaruVEH-0000209CertifiedCertified Retail
Sale price
$9,674
Front
$1,290
Back
$335
Total
$1,625
Source: Showroom Walk-inSalesperson: EMP-0001850 days in stock
SLE-000001457 August 2025
2024 Chevrolet Camaro 1LT
Granite Pre-OwnedVEH-0000414UsedWholesale
Sale price
$23,015
Front
-$1,966loss
Back
$0
Total
-$1,966
Walk-in or unattributedSalesperson: EMP-0002547 days in stock
SLE-000001467 August 2025
2022 Hyundai Elantra SEL
Granite Pre-OwnedVEH-0000460UsedUsed Retail
Sale price
$14,359
Front
$2,271
Back
$373
Total
$2,644
Walk-in or unattributedSalesperson: EMP-0002933 days in stock
SLE-000001477 August 2025
2016 Jeep Grand Cherokee Laredo
Granite Pre-OwnedVEH-0000523UsedWholesale
Sale price
$3,232
Front
-$813loss
Back
$0
Total
-$813
Walk-in or unattributedSalesperson: EMP-0002929 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
SLE-000001518 August 2025
2020 Chrysler Pacifica Limited
Granite Pre-OwnedVEH-0000330UsedUsed RetailTrade
Sale price
$11,447
Front
$892
Back
$988
Total
$1,880
Source: Showroom Walk-inSalesperson: EMP-0002556 days in stock
SLE-000001528 August 2025
2021 Jeep Grand Cherokee Overland
Granite Pre-OwnedVEH-0000356UsedUsed Retail
Sale price
$16,994
Front
$3,236
Back
$1,333
Total
$4,569
Source: Television Spot ResponseSalesperson: EMP-0002511 days in stock
SLE-000001538 August 2025
2024 Chevrolet Blazer EV LT
Granite ChevroletVEH-0000811NewLease
Sale price
$34,315
Front
-$599loss
Back
$1,252
Total
$653
Source: Showroom Walk-inSalesperson: EMP-00007148 days in stock
SLE-000001548 August 2025
2025 Subaru Impreza Base
Granite SubaruVEH-0000838CertifiedCertified Retail
Sale price
$22,878
Front
$3,083
Back
$1,287
Total
$4,370
Walk-in or unattributedSalesperson: EMP-0001532 days in stock
SLE-000001558 August 2025
2024 Jeep Wrangler Sport
Granite Pre-OwnedVEH-0000867UsedUsed Retail
Sale price
$30,721
Front
$3,242
Back
$622
Total
$3,863
Source: Service Lane OpportunitySalesperson: EMP-0002946 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-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

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-00000142	VEH-0000776	Paid Search Brand	EMP-00025	EMP-00024	EMP-00028
SLE-00000143	VEH-0000500	Walk-in or unattributed	EMP-00006	EMP-00002	EMP-00005
SLE-00000144	VEH-0000209	Showroom Walk-in	EMP-00018	EMP-00023	EMP-00017
SLE-00000145	VEH-0000414	Walk-in or unattributed	EMP-00025	EMP-00024	Unattributed
SLE-00000146	VEH-0000460	Walk-in or unattributed	EMP-00029	EMP-00024	EMP-00028
SLE-00000147	VEH-0000523	Walk-in or unattributed	EMP-00029	EMP-00030	Unattributed
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
SLE-00000151	VEH-0000330	Showroom Walk-in	EMP-00025	EMP-00024	EMP-00028
SLE-00000152	VEH-0000356	Television Spot Response	EMP-00025	EMP-00024	EMP-00028
SLE-00000153	VEH-0000811	Showroom Walk-in	EMP-00007	EMP-00008	EMP-00005
SLE-00000154	VEH-0000838	Walk-in or unattributed	EMP-00015	EMP-00023	EMP-00017
SLE-00000155	VEH-0000867	Service Lane Opportunity	EMP-00029	EMP-00030	EMP-00028
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-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

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.