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.
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-00000249 | 30 August 2025 | Granite Subaru | 2020 Ford Escape TitaniumUsed | Wholesalenot retail | $6,387 | -$1,923loss | $0 | -$1,923 | 31 |
| SLE-00000246 | 29 August 2025 | Granite Subaru | 2026 Subaru Ascent Onyx EditionNew | New Retail | $39,131 | $1,570 | $1,266 | $2,836 | 42 |
| SLE-00000244 | 28 August 2025 | Granite Subaru | 2025 Subaru Forester BaseNew | New Retail | $38,445 | $730 | $569 | $1,298 | 63 |
| SLE-00000245 | 28 August 2025 | Granite Subaru | 2025 Subaru Ascent TouringNew | New Retail | $34,864 | -$970loss | $537 | -$433 | 155 |
| SLE-00000237 | 27 August 2025 | Granite Subaru | 2026 Subaru Ascent Onyx EditionUsed | Used Retail | $43,807 | $8,594 | $1,358 | $9,952 | 26 |
| SLE-00000239 | 27 August 2025 | Granite Subaru | 2020 Subaru Impreza BaseUsed | Used Retail | $10,161 | $1,581 | $732 | $2,313 | 106 |
| SLE-00000243 | 27 August 2025 | Granite Subaru | 2026 Subaru Ascent BaseNew | New Retail | $35,953 | -$2,177loss | $971 | -$1,206 | 133 |
| SLE-00000230 | 26 August 2025 | Granite Subaru | 2025 Subaru Impreza SportCertified | Certified Retail | $30,849 | $6,928 | $1,039 | $7,968 | 24 |
| SLE-00000231 | 26 August 2025 | Granite Subaru | 2018 Subaru Crosstrek BaseCertified | Certified Retail | $4,555 | $25 | $808 | $833 | 4 |
| SLE-00000232 | 26 August 2025 | Granite Subaru | 2026 Subaru Ascent Onyx EditionNew | New Retail | $35,981 | -$168loss | $928 | $761 | 82 |
| SLE-00000234 | 26 August 2025 | Granite Subaru | 2018 Subaru Crosstrek BaseUsed | Used Retail | $5,599 | $494 | $1,665 | $2,159 | 59 |
| SLE-00000226 | 25 August 2025 | Granite Subaru | 2025 Subaru Forester BaseNew | New Retail | $37,697 | $1,258 | $1,855 | $3,114 | 32 |
| SLE-00000227 | 25 August 2025 | Granite Subaru | 2021 Subaru Forester BaseCertified | Certified Retail | $22,360 | $5,750 | $1,406 | $7,156 | 9 |
| SLE-00000222 | 23 August 2025 | Granite Subaru | 2025 Subaru Ascent Onyx EditionNew | New Retail | $35,019 | -$1,614loss | $308 | -$1,306 | 177 |
| SLE-00000223 | 23 August 2025 | Granite Subaru | 2018 Ford F-150 LariatUsed | Used Retail | $6,325 | $506 | $1,985 | $2,491 | 35 |
| SLE-00000211 | 21 August 2025 | Granite Subaru | 2025 Subaru Ascent Onyx EditionNew | New Retail | $37,018 | $1,464 | $207 | $1,671 | 28 |
| SLE-00000210 | 20 August 2025 | Granite Subaru | 2022 Subaru WRX GTUsed | Used Retail | $23,133 | $3,389 | $887 | $4,276 | 27 |
| SLE-00000197 | 16 August 2025 | Granite Subaru | 2024 Subaru Outback WildernessNew | New Retail | $29,420 | $907 | $2,700 | $3,607 | 32 |
| SLE-00000198 | 16 August 2025 | Granite Subaru | 2019 Subaru Forester BaseUsed | Used Retail | $10,844 | $892 | $561 | $1,453 | 29 |
| 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-00000196 | 15 August 2025 | Granite Subaru | 2026 Subaru Ascent Onyx EditionNew | Dealer Tradenot retail | $37,821 | -$178loss | $0 | -$178 | 31 |
| SLE-00000192 | 14 August 2025 | Granite Subaru | 2024 Jeep Wrangler SportUsed | Used Retail | $28,155 | $2,817 | $374 | $3,191 | 71 |
| SLE-00000177 | 13 August 2025 | Granite Subaru | 2026 Subaru Ascent Onyx EditionNew | New Retail | $40,502 | $1,616 | $808 | $2,423 | 29 |
| SLE-00000171 | 12 August 2025 | Granite Subaru | 2026 Subaru Ascent BaseNew | New Retail | $36,772 | $260 | $396 | $656 | 27 |
- SLE-0000024930 August 20252020 Ford Escape TitaniumGranite SubaruVEH-0000246UsedWholesale
- Sale price
- $6,387
- Front
- -$1,923loss
- Back
- $0
- Total
- -$1,923
Walk-in or unattributedSalesperson: EMP-0001831 days in stock - SLE-0000024629 August 20252026 Subaru Ascent Onyx EditionGranite SubaruVEH-0000173NewNew RetailTrade
- Sale price
- $39,131
- Front
- $1,570
- Back
- $1,266
- Total
- $2,836
Source: Paid Search Non-BrandSalesperson: EMP-0002242 days in stock - SLE-0000024428 August 20252025 Subaru Forester BaseGranite SubaruVEH-0000228NewNew Retail
- Sale price
- $38,445
- Front
- $730
- Back
- $569
- Total
- $1,298
Walk-in or unattributedSalesperson: EMP-0002263 days in stock - SLE-0000024528 August 20252025 Subaru Ascent TouringGranite SubaruVEH-0000522NewNew RetailTrade
- Sale price
- $34,864
- Front
- -$970loss
- Back
- $537
- Total
- -$433
Walk-in or unattributedSalesperson: EMP-00015155 days in stock - SLE-0000023727 August 20252026 Subaru Ascent Onyx EditionGranite SubaruVEH-0000031UsedUsed Retail
- Sale price
- $43,807
- Front
- $8,594
- Back
- $1,358
- Total
- $9,952
Source: Third-Party Marketplace ListingSalesperson: EMP-0002226 days in stock - SLE-0000023927 August 20252020 Subaru Impreza BaseGranite SubaruVEH-0000481UsedUsed Retail
- Sale price
- $10,161
- Front
- $1,581
- Back
- $732
- Total
- $2,313
Source: Showroom Walk-inSalesperson: EMP-00022106 days in stock - SLE-0000024327 August 20252026 Subaru Ascent BaseGranite SubaruVEH-0000825NewNew RetailTrade
- Sale price
- $35,953
- Front
- -$2,177loss
- Back
- $971
- Total
- -$1,206
Source: Customer ReferralSalesperson: EMP-00022133 days in stock - SLE-0000023026 August 20252025 Subaru Impreza SportGranite SubaruVEH-0000536CertifiedCertified Retail
- Sale price
- $30,849
- Front
- $6,928
- Back
- $1,039
- Total
- $7,968
Source: Customer ReferralSalesperson: EMP-0001624 days in stock - SLE-0000023126 August 20252018 Subaru Crosstrek BaseGranite SubaruVEH-0000565CertifiedCertified Retail
- Sale price
- $4,555
- Front
- $25
- Back
- $808
- Total
- $833
Source: Showroom Walk-inSalesperson: EMP-000184 days in stock - SLE-0000023226 August 20252026 Subaru Ascent Onyx EditionGranite SubaruVEH-0000604NewNew Retail
- Sale price
- $35,981
- Front
- -$168loss
- Back
- $928
- Total
- $761
Source: Showroom Walk-inSalesperson: EMP-0001882 days in stock - SLE-0000023426 August 20252018 Subaru Crosstrek BaseGranite SubaruVEH-0000720UsedUsed RetailTrade
- Sale price
- $5,599
- Front
- $494
- Back
- $1,665
- Total
- $2,159
Source: Paid Search Non-BrandSalesperson: EMP-0002259 days in stock - SLE-0000022625 August 20252025 Subaru Forester BaseGranite SubaruVEH-0000311NewNew RetailTrade
- Sale price
- $37,697
- Front
- $1,258
- Back
- $1,855
- Total
- $3,114
Source: Dealer Website ChatSalesperson: EMP-0002232 days in stock - SLE-0000022725 August 20252021 Subaru Forester BaseGranite SubaruVEH-0000369CertifiedCertified RetailTrade
- Sale price
- $22,360
- Front
- $5,750
- Back
- $1,406
- Total
- $7,156
Source: Customer ReferralSalesperson: EMP-000229 days in stock - SLE-0000022223 August 20252025 Subaru Ascent Onyx EditionGranite SubaruVEH-0000538NewNew Retail
- Sale price
- $35,019
- Front
- -$1,614loss
- Back
- $308
- Total
- -$1,306
Walk-in or unattributedSalesperson: EMP-00018177 days in stock - SLE-0000022323 August 20252018 Ford F-150 LariatGranite SubaruVEH-0000545UsedUsed RetailTrade
- Sale price
- $6,325
- Front
- $506
- Back
- $1,985
- Total
- $2,491
Source: Third-Party Marketplace ListingSalesperson: EMP-0001635 days in stock - SLE-0000021121 August 20252025 Subaru Ascent Onyx EditionGranite SubaruVEH-0000210NewNew Retail
- Sale price
- $37,018
- Front
- $1,464
- Back
- $207
- Total
- $1,671
Source: Showroom Walk-inSalesperson: EMP-0001528 days in stock - SLE-0000021020 August 20252022 Subaru WRX GTGranite SubaruVEH-0000833UsedUsed Retail
- Sale price
- $23,133
- Front
- $3,389
- Back
- $887
- Total
- $4,276
Source: Dealer Website FormSalesperson: EMP-0001527 days in stock - SLE-0000019716 August 20252024 Subaru Outback WildernessGranite SubaruVEH-0000244NewNew RetailTrade
- Sale price
- $29,420
- Front
- $907
- Back
- $2,700
- Total
- $3,607
Source: Community Partner ReferralSalesperson: EMP-0001632 days in stock - SLE-0000019816 August 20252019 Subaru Forester BaseGranite SubaruVEH-0000568UsedUsed RetailTrade
- Sale price
- $10,844
- Front
- $892
- Back
- $561
- Total
- $1,453
Source: Dealer Website FormSalesperson: EMP-0001829 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 - SLE-0000019615 August 20252026 Subaru Ascent Onyx EditionGranite SubaruVEH-0000775NewDealer Trade
- Sale price
- $37,821
- Front
- -$178loss
- Back
- $0
- Total
- -$178
Walk-in or unattributedSalesperson: EMP-0001831 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-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-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
Unit, lead source and attribution for these deals
| Deal | Unit | Lead source | Salesperson | Desk | Finance |
|---|---|---|---|---|---|
| SLE-00000249 | VEH-0000246 | Walk-in or unattributed | EMP-00018 | EMP-00014 | Unattributed |
| SLE-00000246 | VEH-0000173 | Paid Search Non-Brand | EMP-00022 | EMP-00013 | EMP-00017 |
| SLE-00000244 | VEH-0000228 | Walk-in or unattributed | EMP-00022 | EMP-00014 | EMP-00017 |
| SLE-00000245 | VEH-0000522 | Walk-in or unattributed | EMP-00015 | EMP-00014 | EMP-00017 |
| SLE-00000237 | VEH-0000031 | Third-Party Marketplace Listing | EMP-00022 | EMP-00013 | EMP-00017 |
| SLE-00000239 | VEH-0000481 | Showroom Walk-in | EMP-00022 | EMP-00013 | EMP-00017 |
| SLE-00000243 | VEH-0000825 | Customer Referral | EMP-00022 | EMP-00023 | EMP-00017 |
| SLE-00000230 | VEH-0000536 | Customer Referral | EMP-00016 | EMP-00023 | EMP-00017 |
| SLE-00000231 | VEH-0000565 | Showroom Walk-in | EMP-00018 | EMP-00014 | EMP-00017 |
| SLE-00000232 | VEH-0000604 | Showroom Walk-in | EMP-00018 | EMP-00014 | EMP-00017 |
| SLE-00000234 | VEH-0000720 | Paid Search Non-Brand | EMP-00022 | EMP-00013 | EMP-00017 |
| SLE-00000226 | VEH-0000311 | Dealer Website Chat | EMP-00022 | EMP-00013 | EMP-00017 |
| SLE-00000227 | VEH-0000369 | Customer Referral | EMP-00022 | EMP-00014 | EMP-00017 |
| SLE-00000222 | VEH-0000538 | Walk-in or unattributed | EMP-00018 | EMP-00013 | EMP-00017 |
| SLE-00000223 | VEH-0000545 | Third-Party Marketplace Listing | EMP-00016 | EMP-00023 | EMP-00017 |
| SLE-00000211 | VEH-0000210 | Showroom Walk-in | EMP-00015 | EMP-00023 | EMP-00017 |
| SLE-00000210 | VEH-0000833 | Dealer Website Form | EMP-00015 | EMP-00013 | EMP-00017 |
| SLE-00000197 | VEH-0000244 | Community Partner Referral | EMP-00016 | EMP-00023 | EMP-00017 |
| SLE-00000198 | VEH-0000568 | Dealer Website Form | EMP-00018 | EMP-00014 | 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 |
| SLE-00000196 | VEH-0000775 | Walk-in or unattributed | EMP-00018 | EMP-00013 | Unattributed |
| SLE-00000192 | VEH-0000889 | Walk-in or unattributed | EMP-00016 | EMP-00023 | EMP-00017 |
| SLE-00000177 | VEH-0000156 | Organic Search Landing | EMP-00022 | EMP-00014 | EMP-00017 |
| SLE-00000171 | VEH-0000098 | Dealer Website Chat | EMP-00022 | 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.