Deal Explorer
38 deals · Granite Subaru · 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 controls1 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
- 38
- Matching the current filters
- Retail units
- 35
- 3 matched transactions are not retail
- Total gross
- $102,305
- Retail rows only
- Front gross
- $64,846
- Back gross
- $37,459
- Closed at a front loss
- 10
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-00000623 | 25 December 2025 | Granite Subaru | 2025 Subaru Forester BaseUsed | Used Retail | $45,709 | $11,097 | $1,229 | $12,327 | 8 |
| SLE-00000625 | 25 December 2025 | Granite Subaru | 2023 Chevrolet Trailblazer LSUsed | Used Retail | $17,838 | $1,107 | $2,017 | $3,124 | 100 |
| SLE-00000626 | 25 December 2025 | Granite Subaru | 2018 Subaru Crosstrek BaseCertified | Certified Retail | $5,278 | $371 | $692 | $1,063 | 92 |
| SLE-00000628 | 26 December 2025 | Granite Subaru | 2025 Subaru Impreza BaseNew | New Retail | $23,393 | -$43loss | $234 | $191 | 42 |
| SLE-00000629 | 26 December 2025 | Granite Subaru | 2022 Subaru Crosstrek LimitedUsed | Used Retail | $12,852 | $1,280 | $1,010 | $2,290 | 114 |
| SLE-00000630 | 27 December 2025 | Granite Subaru | 2025 Subaru Impreza BaseNew | New Retail | $23,933 | -$181loss | $1,577 | $1,396 | 53 |
| SLE-00000632 | 27 December 2025 | Granite Subaru | 2024 Subaru Outback WildernessUsed | Used Retail | $24,849 | $4,599 | $992 | $5,591 | 14 |
| SLE-00000633 | 27 December 2025 | Granite Subaru | 2019 Kia Sportage EXUsed | Used Retail | $7,057 | $247 | $115 | $361 | 145 |
| SLE-00000634 | 27 December 2025 | Granite Subaru | 2026 Subaru Ascent Onyx EditionNew | New Retail | $38,053 | $1,986 | $739 | $2,725 | 21 |
| SLE-00000638 | 29 December 2025 | Granite Subaru | 2022 Subaru BRZ LimitedUsed | Used Retail | $24,207 | $5,335 | $1,190 | $6,525 | 110 |
| SLE-00000640 | 29 December 2025 | Granite Subaru | 2026 Subaru Ascent BaseNew | Lease | $37,790 | $444 | $1,556 | $2,000 | 97 |
| SLE-00000648 | 31 December 2025 | Granite Subaru | 2025 Subaru Ascent TouringNew | Lease | $35,401 | -$418loss | $500 | $82 | 77 |
| SLE-00000650 | 31 December 2025 | Granite Subaru | 2025 Subaru Forester BaseUsed | Used Retail | $42,268 | $7,125 | $585 | $7,710 | 36 |
- SLE-0000062325 December 20252025 Subaru Forester BaseGranite SubaruVEH-0000671UsedUsed RetailTrade
- Sale price
- $45,709
- Front
- $11,097
- Back
- $1,229
- Total
- $12,327
Source: Showroom Walk-inSalesperson: EMP-000168 days in stock - SLE-0000062525 December 20252023 Chevrolet Trailblazer LSGranite SubaruVEH-0000759UsedUsed Retail
- Sale price
- $17,838
- Front
- $1,107
- Back
- $2,017
- Total
- $3,124
Source: Showroom Walk-inSalesperson: EMP-00016100 days in stock - SLE-0000062625 December 20252018 Subaru Crosstrek BaseGranite SubaruVEH-0000802CertifiedCertified RetailTrade
- Sale price
- $5,278
- Front
- $371
- Back
- $692
- Total
- $1,063
Source: Organic Search LandingSalesperson: EMP-0001692 days in stock - SLE-0000062826 December 20252025 Subaru Impreza BaseGranite SubaruVEH-0000307NewNew RetailTrade
- Sale price
- $23,393
- Front
- -$43loss
- Back
- $234
- Total
- $191
Source: Paid Search BrandSalesperson: EMP-0001642 days in stock - SLE-0000062926 December 20252022 Subaru Crosstrek LimitedGranite SubaruVEH-0000586UsedUsed Retail
- Sale price
- $12,852
- Front
- $1,280
- Back
- $1,010
- Total
- $2,290
Walk-in or unattributedSalesperson: EMP-00016114 days in stock - SLE-0000063027 December 20252025 Subaru Impreza BaseGranite SubaruVEH-0000226NewNew RetailTrade
- Sale price
- $23,933
- Front
- -$181loss
- Back
- $1,577
- Total
- $1,396
Source: Service Lane OpportunitySalesperson: EMP-0001653 days in stock - SLE-0000063227 December 20252024 Subaru Outback WildernessGranite SubaruVEH-0000474UsedUsed Retail
- Sale price
- $24,849
- Front
- $4,599
- Back
- $992
- Total
- $5,591
Source: Paid Search BrandSalesperson: EMP-0001514 days in stock - SLE-0000063327 December 20252019 Kia Sportage EXGranite SubaruVEH-0000615UsedUsed Retail
- Sale price
- $7,057
- Front
- $247
- Back
- $115
- Total
- $361
Source: Dealer Website FormSalesperson: EMP-00016145 days in stock - SLE-0000063427 December 20252026 Subaru Ascent Onyx EditionGranite SubaruVEH-0000801NewNew RetailTrade
- Sale price
- $38,053
- Front
- $1,986
- Back
- $739
- Total
- $2,725
Source: Showroom Walk-inSalesperson: EMP-0001621 days in stock - SLE-0000063829 December 20252022 Subaru BRZ LimitedGranite SubaruVEH-0000205UsedUsed Retail
- Sale price
- $24,207
- Front
- $5,335
- Back
- $1,190
- Total
- $6,525
Walk-in or unattributedSalesperson: EMP-00018110 days in stock - SLE-0000064029 December 20252026 Subaru Ascent BaseGranite SubaruVEH-0000790NewLease
- Sale price
- $37,790
- Front
- $444
- Back
- $1,556
- Total
- $2,000
Source: Paid Search BrandSalesperson: EMP-0001697 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-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-00000623 | VEH-0000671 | Showroom Walk-in | EMP-00016 | EMP-00013 | Unattributed |
| SLE-00000625 | VEH-0000759 | Showroom Walk-in | EMP-00016 | EMP-00014 | EMP-00017 |
| SLE-00000626 | VEH-0000802 | Organic Search Landing | EMP-00016 | EMP-00023 | EMP-00017 |
| SLE-00000628 | VEH-0000307 | Paid Search Brand | EMP-00016 | EMP-00023 | EMP-00017 |
| SLE-00000629 | VEH-0000586 | Walk-in or unattributed | EMP-00016 | EMP-00013 | EMP-00017 |
| SLE-00000630 | VEH-0000226 | Service Lane Opportunity | EMP-00016 | EMP-00023 | EMP-00017 |
| SLE-00000632 | VEH-0000474 | Paid Search Brand | EMP-00015 | EMP-00014 | EMP-00017 |
| SLE-00000633 | VEH-0000615 | Dealer Website Form | EMP-00016 | EMP-00014 | EMP-00017 |
| SLE-00000634 | VEH-0000801 | Showroom Walk-in | EMP-00016 | EMP-00013 | Unattributed |
| SLE-00000638 | VEH-0000205 | Walk-in or unattributed | EMP-00018 | EMP-00014 | EMP-00017 |
| SLE-00000640 | VEH-0000790 | Paid Search Brand | EMP-00016 | EMP-00013 | EMP-00017 |
| SLE-00000648 | VEH-0000257 | Walk-in or unattributed | EMP-00018 | EMP-00014 | EMP-00017 |
| 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.