Deal Explorer
45 deals · Granite Subaru · 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.
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
- 45
- Matching the current filters
- Retail units
- 41
- 4 matched transactions are not retail
- Total gross
- $98,767
- Retail rows only
- Front gross
- $57,175
- Back gross
- $41,592
- Closed at a front loss
- 13
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-00000117 | 1 August 2025 | Granite Subaru | 2025 Subaru Forester BaseNew | Lease | $39,861 | $1,610 | $641 | $2,251 | 35 |
| SLE-00000121 | 2 August 2025 | Granite Subaru | 2021 Subaru Forester BaseUsed | Used Retail | $18,366 | $2,037 | $1,197 | $3,234 | 171 |
| SLE-00000123 | 2 August 2025 | Granite Subaru | 2024 Subaru Outback WildernessNew | New Retail | $27,506 | -$42loss | $733 | $691 | 27 |
| SLE-00000125 | 2 August 2025 | Granite Subaru | 2024 Subaru Impreza RSNew | New Retail | $22,051 | -$1,387loss | $1,284 | -$103 | 129 |
| SLE-00000126 | 2 August 2025 | Granite Subaru | 2026 Subaru Outback Onyx Edition XTNew | Lease | $30,837 | $528 | $1,410 | $1,938 | 87 |
| SLE-00000128 | 2 August 2025 | Granite Subaru | 2018 Subaru Crosstrek BaseUsed | Used Retail | $3,674 | -$31loss | $1,384 | $1,353 | 38 |
| SLE-00000133 | 4 August 2025 | Granite Subaru | 2020 Subaru Impreza BaseUsed | Used Retail | $7,325 | $513 | $1,099 | $1,612 | 52 |
| SLE-00000138 | 5 August 2025 | Granite Subaru | 2023 Ford Bronco Sport Big BendUsed | Used Retail | $17,285 | $1,754 | $1,338 | $3,092 | 113 |
| SLE-00000141 | 5 August 2025 | Granite Subaru | 2026 Subaru Ascent BaseNew | Lease | $36,671 | -$675loss | $693 | $17 | 63 |
| SLE-00000144 | 7 August 2025 | Granite Subaru | 2020 Subaru Impreza BaseCertified | Certified Retail | $9,674 | $1,290 | $335 | $1,625 | 50 |
| SLE-00000150 | 8 August 2025 | Granite Subaru | 2020 Subaru Outback Onyx Edition XTUsed | Used Retail | $9,061 | $482 | $972 | $1,455 | 62 |
| SLE-00000154 | 8 August 2025 | Granite Subaru | 2025 Subaru Impreza BaseCertified | Certified Retail | $22,878 | $3,083 | $1,287 | $4,370 | 32 |
| SLE-00000157 | 9 August 2025 | Granite Subaru | 2025 Subaru Impreza BaseUsed | Dealer Tradenot retail | $20,481 | -$1,972loss | $0 | -$1,972 | 54 |
| 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-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-00000168 | 11 August 2025 | Granite Subaru | 2026 Subaru Ascent BaseNew | New Retail | $37,307 | $1,168 | $944 | $2,112 | 37 |
| SLE-00000171 | 12 August 2025 | Granite Subaru | 2026 Subaru Ascent BaseNew | New Retail | $36,772 | $260 | $396 | $656 | 27 |
| 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-00000177 | 13 August 2025 | Granite Subaru | 2026 Subaru Ascent Onyx EditionNew | New Retail | $40,502 | $1,616 | $808 | $2,423 | 29 |
| SLE-00000192 | 14 August 2025 | Granite Subaru | 2024 Jeep Wrangler SportUsed | Used Retail | $28,155 | $2,817 | $374 | $3,191 | 71 |
| SLE-00000194 | 15 August 2025 | Granite Subaru | 2018 Honda CR-V EXUsed | Used Retail | $6,071 | $152 | $590 | $742 | 86 |
| SLE-00000195 | 15 August 2025 | Granite Subaru | 2021 Subaru Forester BaseCertified | Certified Retail | $20,028 | $4,225 | $596 | $4,821 | 29 |
- SLE-000001171 August 20252025 Subaru Forester BaseGranite SubaruVEH-0000178NewLease
- Sale price
- $39,861
- Front
- $1,610
- Back
- $641
- Total
- $2,251
Walk-in or unattributedSalesperson: EMP-0001835 days in stock - SLE-000001212 August 20252021 Subaru Forester BaseGranite SubaruVEH-0000135UsedUsed RetailTrade
- Sale price
- $18,366
- Front
- $2,037
- Back
- $1,197
- Total
- $3,234
Source: Direct Site VisitSalesperson: EMP-00018171 days in stock - SLE-000001232 August 20252024 Subaru Outback WildernessGranite SubaruVEH-0000353NewNew RetailTrade
- Sale price
- $27,506
- Front
- -$42loss
- Back
- $733
- Total
- $691
Walk-in or unattributedSalesperson: EMP-0001827 days in stock - SLE-000001252 August 20252024 Subaru Impreza RSGranite SubaruVEH-0000452NewNew RetailTrade
- Sale price
- $22,051
- Front
- -$1,387loss
- Back
- $1,284
- Total
- -$103
Walk-in or unattributedSalesperson: EMP-00022129 days in stock - SLE-000001262 August 20252026 Subaru Outback Onyx Edition XTGranite SubaruVEH-0000468NewLease
- Sale price
- $30,837
- Front
- $528
- Back
- $1,410
- Total
- $1,938
Walk-in or unattributedSalesperson: EMP-0002287 days in stock - SLE-000001282 August 20252018 Subaru Crosstrek BaseGranite SubaruVEH-0000765UsedUsed Retail
- Sale price
- $3,674
- Front
- -$31loss
- Back
- $1,384
- Total
- $1,353
Source: Organic Search LandingSalesperson: EMP-0002238 days in stock - SLE-000001334 August 20252020 Subaru Impreza BaseGranite SubaruVEH-0000610UsedUsed Retail
- Sale price
- $7,325
- Front
- $513
- Back
- $1,099
- Total
- $1,612
Source: Service Lane OpportunitySalesperson: EMP-0001552 days in stock - SLE-000001385 August 20252023 Ford Bronco Sport Big BendGranite SubaruVEH-0000267UsedUsed Retail
- Sale price
- $17,285
- Front
- $1,754
- Back
- $1,338
- Total
- $3,092
Walk-in or unattributedSalesperson: EMP-00016113 days in stock - SLE-000001415 August 20252026 Subaru Ascent BaseGranite SubaruVEH-0000626NewLease
- Sale price
- $36,671
- Front
- -$675loss
- Back
- $693
- Total
- $17
Source: Customer ReferralSalesperson: EMP-0001863 days in stock - SLE-000001447 August 20252020 Subaru Impreza BaseGranite 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-000001508 August 20252020 Subaru Outback Onyx Edition XTGranite 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-000001548 August 20252025 Subaru Impreza BaseGranite 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-000001579 August 20252025 Subaru Impreza BaseGranite 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-000001619 August 20252025 Subaru Impreza SportGranite 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 20252025 Subaru Ascent TouringGranite 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-0000016411 August 20252026 Chevrolet Silverado EV RSTGranite 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 20252022 Ford Escape SGranite 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-0000016811 August 20252026 Subaru Ascent BaseGranite 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-0000017112 August 20252026 Subaru Ascent BaseGranite SubaruVEH-0000098NewNew Retail
- Sale price
- $36,772
- Front
- $260
- Back
- $396
- Total
- $656
Source: Dealer Website ChatSalesperson: EMP-0002227 days in stock - SLE-0000017412 August 20252025 Subaru Impreza BaseGranite SubaruVEH-0000338NewLease
- Sale price
- $22,808
- Front
- -$620loss
- Back
- $905
- Total
- $285
Source: Direct Site VisitSalesperson: EMP-0001884 days in stock - SLE-0000017512 August 20252021 Subaru Ascent BaseGranite 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-0000017713 August 20252026 Subaru Ascent Onyx EditionGranite SubaruVEH-0000156NewNew RetailTrade
- Sale price
- $40,502
- Front
- $1,616
- Back
- $808
- Total
- $2,423
Source: Organic Search LandingSalesperson: EMP-0002229 days in stock - SLE-0000019214 August 20252024 Jeep Wrangler SportGranite SubaruVEH-0000889UsedUsed RetailTrade
- Sale price
- $28,155
- Front
- $2,817
- Back
- $374
- Total
- $3,191
Walk-in or unattributedSalesperson: EMP-0001671 days in stock - SLE-0000019415 August 20252018 Honda CR-V EXGranite SubaruVEH-0000066UsedUsed Retail
- Sale price
- $6,071
- Front
- $152
- Back
- $590
- Total
- $742
Walk-in or unattributedSalesperson: EMP-0001586 days in stock - SLE-0000019515 August 20252021 Subaru Forester BaseGranite SubaruVEH-0000215CertifiedCertified Retail
- Sale price
- $20,028
- Front
- $4,225
- Back
- $596
- Total
- $4,821
Source: Showroom Walk-inSalesperson: EMP-0001829 days in stock
Unit, lead source and attribution for these deals
| Deal | Unit | Lead source | Salesperson | Desk | Finance |
|---|---|---|---|---|---|
| SLE-00000117 | VEH-0000178 | Walk-in or unattributed | EMP-00018 | EMP-00014 | EMP-00017 |
| SLE-00000121 | VEH-0000135 | Direct Site Visit | EMP-00018 | EMP-00014 | EMP-00017 |
| SLE-00000123 | VEH-0000353 | Walk-in or unattributed | EMP-00018 | EMP-00013 | EMP-00017 |
| SLE-00000125 | VEH-0000452 | Walk-in or unattributed | EMP-00022 | EMP-00023 | EMP-00017 |
| SLE-00000126 | VEH-0000468 | Walk-in or unattributed | EMP-00022 | EMP-00023 | EMP-00017 |
| SLE-00000128 | VEH-0000765 | Organic Search Landing | EMP-00022 | EMP-00014 | EMP-00017 |
| SLE-00000133 | VEH-0000610 | Service Lane Opportunity | EMP-00015 | EMP-00023 | EMP-00017 |
| SLE-00000138 | VEH-0000267 | Walk-in or unattributed | EMP-00016 | EMP-00014 | EMP-00017 |
| SLE-00000141 | VEH-0000626 | Customer Referral | EMP-00018 | EMP-00014 | Unattributed |
| SLE-00000144 | VEH-0000209 | Showroom Walk-in | EMP-00018 | EMP-00023 | EMP-00017 |
| SLE-00000150 | VEH-0000231 | Third-Party Marketplace Listing | EMP-00022 | EMP-00023 | EMP-00017 |
| SLE-00000154 | VEH-0000838 | Walk-in or unattributed | EMP-00015 | EMP-00023 | EMP-00017 |
| SLE-00000157 | VEH-0000184 | Walk-in or unattributed | EMP-00018 | EMP-00023 | Unattributed |
| 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-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-00000168 | VEH-0000820 | Paid Search Brand | EMP-00022 | EMP-00023 | Unattributed |
| SLE-00000171 | VEH-0000098 | Dealer Website Chat | EMP-00022 | EMP-00013 | EMP-00017 |
| 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-00000177 | VEH-0000156 | Organic Search Landing | EMP-00022 | EMP-00014 | EMP-00017 |
| SLE-00000192 | VEH-0000889 | Walk-in or unattributed | EMP-00016 | EMP-00023 | EMP-00017 |
| SLE-00000194 | VEH-0000066 | Walk-in or unattributed | EMP-00015 | EMP-00013 | EMP-00017 |
| SLE-00000195 | VEH-0000215 | 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.