Deal Explorer
106 deals · All three stores · December 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.
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.
Filters and controlsnone applied
This filter selects
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
- 106
- Matching the current filters
- Retail units
- 92
- 14 matched transactions are not retail
- Total gross
- $321,935
- Retail rows only
- Front gross
- $213,657
- Back gross
- $108,277
- Closed at a front loss
- 23
The transactions behind the aggregate
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.
| Deal | Sale date | Store | Vehicle | Sale type | Sale price | Front gross | Back gross | Total gross | Days |
|---|---|---|---|---|---|---|---|---|---|
| SLE-00000645 | 30 December 2025 | Granite Chevrolet | 2022 Chevrolet Tahoe Z71Used | Used Retail | $17,982 | $1,721 | $2,603 | $4,324 | 125 |
| SLE-00000646 | 31 December 2025 | Granite Chevrolet | 2026 Chevrolet Blazer 2LTNew | New Retail | $38,127 | $995 | $1,556 | $2,551 | 69 |
| SLE-00000647 | 31 December 2025 | Granite Pre-Owned | 2024 Ford F-150 XLUsed | Used Retail | $33,655 | $5,699 | $911 | $6,610 | 61 |
| SLE-00000648 | 31 December 2025 | Granite Subaru | 2025 Subaru Ascent TouringNew | Lease | $35,401 | -$418loss | $500 | $82 | 77 |
| SLE-00000649 | 31 December 2025 | Granite Pre-Owned | 2022 Ford Escape SUsed | Used Retail | $13,225 | $795 | $804 | $1,599 | 138 |
| SLE-00000650 | 31 December 2025 | Granite Subaru | 2025 Subaru Forester BaseUsed | Used Retail | $42,268 | $7,125 | $585 | $7,710 | 36 |
- SLE-0000064530 December 20252022 Chevrolet Tahoe Z71Granite ChevroletVEH-0000700UsedUsed Retail
- Sale price
- $17,982
- Front
- $1,721
- Back
- $2,603
- Total
- $4,324
Source: Showroom Walk-inSalesperson: EMP-00003125 days in stock - SLE-0000064631 December 20252026 Chevrolet Blazer 2LTGranite ChevroletVEH-0000094NewNew RetailTrade
- Sale price
- $38,127
- Front
- $995
- Back
- $1,556
- Total
- $2,551
Source: Showroom Walk-inSalesperson: EMP-0001069 days in stock - SLE-0000064731 December 20252024 Ford F-150 XLGranite Pre-OwnedVEH-0000192UsedUsed RetailTrade
- Sale price
- $33,655
- Front
- $5,699
- Back
- $911
- Total
- $6,610
Walk-in or unattributedSalesperson: EMP-0002961 days in stock - SLE-0000064831 December 20252025 Subaru Ascent TouringGranite SubaruVEH-0000257NewLease
- Sale price
- $35,401
- Front
- -$418loss
- Back
- $500
- Total
- $82
Walk-in or unattributedSalesperson: EMP-0001877 days in stock - SLE-0000064931 December 20252022 Ford Escape SGranite Pre-OwnedVEH-0000455UsedUsed Retail
- Sale price
- $13,225
- Front
- $795
- Back
- $804
- Total
- $1,599
Source: Service Lane OpportunitySalesperson: EMP-00026138 days in stock - SLE-0000065031 December 20252025 Subaru Forester BaseGranite SubaruVEH-0000900UsedUsed Retail
- Sale price
- $42,268
- Front
- $7,125
- Back
- $585
- Total
- $7,710
Source: Showroom Walk-inSalesperson: EMP-0001836 days in stock
Unit, lead source and attribution for these deals
| Deal | Unit | Lead source | Salesperson | Desk | Finance |
|---|---|---|---|---|---|
| SLE-00000645 | VEH-0000700 | Showroom Walk-in | EMP-00003 | EMP-00008 | EMP-00005 |
| SLE-00000646 | VEH-0000094 | Showroom Walk-in | EMP-00010 | EMP-00002 | EMP-00005 |
| SLE-00000647 | VEH-0000192 | Walk-in or unattributed | EMP-00029 | EMP-00030 | EMP-00028 |
| SLE-00000648 | VEH-0000257 | Walk-in or unattributed | EMP-00018 | EMP-00014 | EMP-00017 |
| SLE-00000649 | VEH-0000455 | Service Lane Opportunity | EMP-00026 | EMP-00024 | EMP-00028 |
| SLE-00000650 | VEH-0000900 | Showroom Walk-in | EMP-00018 | EMP-00014 | 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.