Deal Explorer
35 deals · Granite Subaru · October 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 controls2 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
- 35
- Matching the current filters
- Retail units
- 30
- 5 matched transactions are not retail
- Total gross
- $69,354
- Retail rows only
- Front gross
- $31,509
- Back gross
- $37,845
- Closed at a front loss
- 12
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-00000387 | 8 October 2025 | Granite Subaru | 2026 Subaru Ascent BaseNew | New Retail | $38,373 | $1,014 | $2,780 | $3,794 | 37 |
| SLE-00000378 | 6 October 2025 | Granite Subaru | 2026 Subaru Ascent Onyx EditionNew | New Retail | $36,958 | $265 | $1,947 | $2,212 | 75 |
| SLE-00000379 | 6 October 2025 | Granite Subaru | 2018 Subaru Crosstrek BaseCertified | Certified Retail | $5,370 | $446 | $832 | $1,278 | 11 |
| SLE-00000369 | 4 October 2025 | Granite Subaru | 2024 Subaru Outback WildernessNew | Wholesalenot retail | $24,577 | -$3,577loss | $0 | -$3,577 | 142 |
| SLE-00000373 | 4 October 2025 | Granite Subaru | 2022 Subaru Crosstrek LimitedCertified | Lease | $13,349 | $333 | $514 | $847 | 178 |
| SLE-00000375 | 4 October 2025 | Granite Subaru | 2023 Dodge Charger SXTUsed | Used Retail | $20,869 | $1,846 | $1,400 | $3,245 | 64 |
| SLE-00000376 | 4 October 2025 | Granite Subaru | 2025 Subaru Impreza BaseNew | New Retail | $23,373 | -$222loss | $636 | $414 | 54 |
| SLE-00000367 | 3 October 2025 | Granite Subaru | 2025 Subaru Ascent TouringNew | Lease | $36,083 | -$88loss | $1,429 | $1,341 | 146 |
| SLE-00000362 | 2 October 2025 | Granite Subaru | 2026 Subaru Ascent BaseUsed | Used Retail | $34,659 | $1,758 | $1,557 | $3,315 | 98 |
| SLE-00000356 | 1 October 2025 | Granite Subaru | 2025 Subaru Forester BaseNew | New Retail | $39,127 | $2,279 | $1,090 | $3,369 | 23 |
- SLE-000003878 October 20252026 Subaru Ascent BaseGranite SubaruVEH-0000788NewNew Retail
- Sale price
- $38,373
- Front
- $1,014
- Back
- $2,780
- Total
- $3,794
Source: Direct Mail ResponseSalesperson: EMP-0001537 days in stock - SLE-000003786 October 20252026 Subaru Ascent Onyx EditionGranite SubaruVEH-0000146NewNew RetailTrade
- Sale price
- $36,958
- Front
- $265
- Back
- $1,947
- Total
- $2,212
Source: Dealer Website FormSalesperson: EMP-0001675 days in stock - SLE-000003796 October 20252018 Subaru Crosstrek BaseGranite SubaruVEH-0000435CertifiedCertified Retail
- Sale price
- $5,370
- Front
- $446
- Back
- $832
- Total
- $1,278
Source: Community Partner ReferralSalesperson: EMP-0001611 days in stock - SLE-000003694 October 20252024 Subaru Outback WildernessGranite SubaruVEH-0000663NewWholesale
- Sale price
- $24,577
- Front
- -$3,577loss
- Back
- $0
- Total
- -$3,577
Walk-in or unattributedSalesperson: EMP-00018142 days in stock - SLE-000003734 October 20252022 Subaru Crosstrek LimitedGranite SubaruVEH-0000780CertifiedLease
- Sale price
- $13,349
- Front
- $333
- Back
- $514
- Total
- $847
Source: Repeat Customer OutreachSalesperson: EMP-00016178 days in stock - SLE-000003754 October 20252023 Dodge Charger SXTGranite SubaruVEH-0000882UsedUsed Retail
- Sale price
- $20,869
- Front
- $1,846
- Back
- $1,400
- Total
- $3,245
Source: Third-Party Marketplace ListingSalesperson: EMP-0001664 days in stock - SLE-000003764 October 20252025 Subaru Impreza BaseGranite SubaruVEH-0000884NewNew RetailTrade
- Sale price
- $23,373
- Front
- -$222loss
- Back
- $636
- Total
- $414
Source: Direct Site VisitSalesperson: EMP-0001854 days in stock - SLE-000003673 October 20252025 Subaru Ascent TouringGranite SubaruVEH-0000769NewLeaseTrade
- Sale price
- $36,083
- Front
- -$88loss
- Back
- $1,429
- Total
- $1,341
Source: Third-Party Marketplace ListingSalesperson: EMP-00016146 days in stock - SLE-000003622 October 20252026 Subaru Ascent BaseGranite SubaruVEH-0000408UsedUsed RetailTrade
- Sale price
- $34,659
- Front
- $1,758
- Back
- $1,557
- Total
- $3,315
Source: Showroom Walk-inSalesperson: EMP-0001598 days in stock - SLE-000003561 October 20252025 Subaru Forester BaseGranite SubaruVEH-0000317NewNew RetailTrade
- Sale price
- $39,127
- Front
- $2,279
- Back
- $1,090
- Total
- $3,369
Source: Radio Spot ResponseSalesperson: EMP-0001623 days in stock
Unit, lead source and attribution for these deals
| Deal | Unit | Lead source | Salesperson | Desk | Finance |
|---|---|---|---|---|---|
| SLE-00000387 | VEH-0000788 | Direct Mail Response | EMP-00015 | EMP-00013 | EMP-00017 |
| SLE-00000378 | VEH-0000146 | Dealer Website Form | EMP-00016 | EMP-00013 | EMP-00017 |
| SLE-00000379 | VEH-0000435 | Community Partner Referral | EMP-00016 | EMP-00014 | EMP-00017 |
| SLE-00000369 | VEH-0000663 | Walk-in or unattributed | EMP-00018 | EMP-00013 | Unattributed |
| SLE-00000373 | VEH-0000780 | Repeat Customer Outreach | EMP-00016 | EMP-00013 | EMP-00017 |
| SLE-00000375 | VEH-0000882 | Third-Party Marketplace Listing | EMP-00016 | EMP-00013 | EMP-00017 |
| SLE-00000376 | VEH-0000884 | Direct Site Visit | EMP-00018 | EMP-00014 | EMP-00017 |
| SLE-00000367 | VEH-0000769 | Third-Party Marketplace Listing | EMP-00016 | EMP-00023 | EMP-00017 |
| SLE-00000362 | VEH-0000408 | Showroom Walk-in | EMP-00015 | EMP-00023 | EMP-00017 |
| SLE-00000356 | VEH-0000317 | Radio Spot Response | EMP-00016 | EMP-00013 | 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.