Deal Explorer
136 deals · All three stores · 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 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
- 136
- Matching the current filters
- Retail units
- 116
- 20 matched transactions are not retail
- Total gross
- $353,812
- Retail rows only
- Front gross
- $226,505
- Back gross
- $127,307
- Closed at a front loss
- 36
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-00000227 | 25 August 2025 | Granite Subaru | 2021 Subaru Forester BaseCertified | Certified Retail | $22,360 | $5,750 | $1,406 | $7,156 | 9 |
| SLE-00000228 | 25 August 2025 | Granite Pre-Owned | 2021 Tesla Model 3 Long RangeUsed | Wholesalenot retail | $11,228 | -$1,344loss | $0 | -$1,344 | 20 |
| SLE-00000229 | 25 August 2025 | Granite Chevrolet | 2026 Chevrolet Colorado WTNew | New Retail | $47,926 | $457 | $1,337 | $1,794 | 37 |
| SLE-00000224 | 24 August 2025 | Granite Chevrolet | 2024 Chevrolet Silverado EV RSTNew | Lease | $43,522 | -$249loss | $1,878 | $1,630 | 74 |
| SLE-00000216 | 23 August 2025 | Granite Chevrolet | 2025 Chevrolet Blazer EV LTNew | New Retail | $35,172 | -$601loss | $1,573 | $973 | 127 |
| SLE-00000217 | 23 August 2025 | Granite Pre-Owned | 2020 Chrysler Pacifica LimitedUsed | Wholesalenot retail | $10,018 | -$161loss | $0 | -$161 | 50 |
| SLE-00000218 | 23 August 2025 | Granite Pre-Owned | 2017 Subaru Impreza SportUsed | Wholesalenot retail | $2,543 | -$587loss | $0 | -$587 | 23 |
| SLE-00000219 | 23 August 2025 | Granite Pre-Owned | 2023 Volkswagen Atlas SELUsed | Used Retail | $24,815 | $4,724 | $280 | $5,004 | 15 |
| SLE-00000220 | 23 August 2025 | Granite Chevrolet | 2024 Chrysler Pacifica Hybrid SelectUsed | Used Retail | $31,660 | $6,095 | $751 | $6,847 | 95 |
| SLE-00000221 | 23 August 2025 | Granite Chevrolet | 2024 Chevrolet Traverse LTNew | Lease | $36,793 | $1,516 | $1,807 | $3,323 | 35 |
| 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-00000213 | 22 August 2025 | Granite Pre-Owned | 2023 Ford Bronco Sport Big BendUsed | Used Retail | $16,663 | $2,504 | $1,570 | $4,074 | 52 |
| SLE-00000214 | 22 August 2025 | Granite Chevrolet | 2026 Chevrolet Blazer EV LTNew | Lease | $38,401 | -$139loss | $729 | $589 | 15 |
| SLE-00000215 | 22 August 2025 | Granite Chevrolet | 2026 Chevrolet Blazer EV LTNew | New Retail | $38,515 | $1,973 | $1,319 | $3,292 | 18 |
| SLE-00000211 | 21 August 2025 | Granite Subaru | 2025 Subaru Ascent Onyx EditionNew | New Retail | $37,018 | $1,464 | $207 | $1,671 | 28 |
| SLE-00000212 | 21 August 2025 | Granite Pre-Owned | 2026 Chevrolet Colorado WTUsed | Used Retail | $45,322 | $3,836 | $1,159 | $4,995 | 90 |
| SLE-00000210 | 20 August 2025 | Granite Subaru | 2022 Subaru WRX GTUsed | Used Retail | $23,133 | $3,389 | $887 | $4,276 | 27 |
| SLE-00000207 | 19 August 2025 | Granite Pre-Owned | 2020 Chevrolet Suburban PremierUsed | Used Retail | $14,263 | $1,000 | $326 | $1,326 | 75 |
| SLE-00000208 | 19 August 2025 | Granite Chevrolet | 2024 Chevrolet Traverse LTUsed | Dealer Tradenot retail | $28,270 | $1,046 | $0 | $1,046 | 41 |
| SLE-00000209 | 19 August 2025 | Granite Pre-Owned | 2019 Chevrolet Equinox LTUsed | Dealer Tradenot retail | $5,087 | -$389loss | $0 | -$389 | 64 |
| SLE-00000203 | 18 August 2025 | Granite Chevrolet | 2019 Dodge Charger R/TUsed | Used Retail | $8,238 | $408 | $2,129 | $2,537 | 53 |
| SLE-00000204 | 18 August 2025 | Granite Chevrolet | 2022 Chevrolet Camaro ZL1Certified | Certified Retail | $21,883 | $3,148 | $287 | $3,434 | 145 |
| SLE-00000205 | 18 August 2025 | Granite Chevrolet | 2026 Chevrolet Colorado WTNew | New Retail | $45,267 | -$87loss | $500 | $413 | 3 |
| SLE-00000206 | 18 August 2025 | Granite Chevrolet | 2022 Chevrolet Tahoe LTCertified | Certified Retail | $23,404 | $3,232 | $1,357 | $4,589 | 60 |
- 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-0000022825 August 20252021 Tesla Model 3 Long RangeGranite Pre-OwnedVEH-0000421UsedWholesale
- Sale price
- $11,228
- Front
- -$1,344loss
- Back
- $0
- Total
- -$1,344
Walk-in or unattributedSalesperson: EMP-0002720 days in stock - SLE-0000022925 August 20252026 Chevrolet Colorado WTGranite ChevroletVEH-0000687NewNew Retail
- Sale price
- $47,926
- Front
- $457
- Back
- $1,337
- Total
- $1,794
Walk-in or unattributedSalesperson: EMP-0001037 days in stock - SLE-0000022424 August 20252024 Chevrolet Silverado EV RSTGranite ChevroletVEH-0000696NewLeaseTrade
- Sale price
- $43,522
- Front
- -$249loss
- Back
- $1,878
- Total
- $1,630
Source: Third-Party Marketplace ListingSalesperson: EMP-0001074 days in stock - SLE-0000021623 August 20252025 Chevrolet Blazer EV LTGranite ChevroletVEH-0000111NewNew Retail
- Sale price
- $35,172
- Front
- -$601loss
- Back
- $1,573
- Total
- $973
Source: Organic Search LandingSalesperson: EMP-00012127 days in stock - SLE-0000021723 August 20252020 Chrysler Pacifica LimitedGranite Pre-OwnedVEH-0000127UsedWholesale
- Sale price
- $10,018
- Front
- -$161loss
- Back
- $0
- Total
- -$161
Walk-in or unattributedSalesperson: EMP-0002950 days in stock - SLE-0000021823 August 20252017 Subaru Impreza SportGranite Pre-OwnedVEH-0000230UsedWholesale
- Sale price
- $2,543
- Front
- -$587loss
- Back
- $0
- Total
- -$587
Walk-in or unattributedSalesperson: EMP-0002523 days in stock - SLE-0000021923 August 20252023 Volkswagen Atlas SELGranite Pre-OwnedVEH-0000294UsedUsed RetailTrade
- Sale price
- $24,815
- Front
- $4,724
- Back
- $280
- Total
- $5,004
Source: Dealer Website FormSalesperson: EMP-0002715 days in stock - SLE-0000022023 August 20252024 Chrysler Pacifica Hybrid SelectGranite ChevroletVEH-0000315UsedUsed Retail
- Sale price
- $31,660
- Front
- $6,095
- Back
- $751
- Total
- $6,847
Source: Third-Party Marketplace ListingSalesperson: EMP-0001295 days in stock - SLE-0000022123 August 20252024 Chevrolet Traverse LTGranite ChevroletVEH-0000326NewLease
- Sale price
- $36,793
- Front
- $1,516
- Back
- $1,807
- Total
- $3,323
Source: Showroom Walk-inSalesperson: EMP-0001235 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-0000021322 August 20252023 Ford Bronco Sport Big BendGranite Pre-OwnedVEH-0000464UsedUsed RetailTrade
- Sale price
- $16,663
- Front
- $2,504
- Back
- $1,570
- Total
- $4,074
Source: Repeat Customer OutreachSalesperson: EMP-0002652 days in stock - SLE-0000021422 August 20252026 Chevrolet Blazer EV LTGranite ChevroletVEH-0000524NewLease
- Sale price
- $38,401
- Front
- -$139loss
- Back
- $729
- Total
- $589
Source: Community Partner ReferralSalesperson: EMP-0000615 days in stock - SLE-0000021522 August 20252026 Chevrolet Blazer EV LTGranite ChevroletVEH-0000654NewNew Retail
- Sale price
- $38,515
- Front
- $1,973
- Back
- $1,319
- Total
- $3,292
Source: Showroom Walk-inSalesperson: EMP-0000318 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-0000021221 August 20252026 Chevrolet Colorado WTGranite Pre-OwnedVEH-0000632UsedUsed RetailTrade
- Sale price
- $45,322
- Front
- $3,836
- Back
- $1,159
- Total
- $4,995
Walk-in or unattributedSalesperson: EMP-0002590 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-0000020719 August 20252020 Chevrolet Suburban PremierGranite Pre-OwnedVEH-0000154UsedUsed Retail
- Sale price
- $14,263
- Front
- $1,000
- Back
- $326
- Total
- $1,326
Source: Dealer Website FormSalesperson: EMP-0002975 days in stock - SLE-0000020819 August 20252024 Chevrolet Traverse LTGranite ChevroletVEH-0000763UsedDealer Trade
- Sale price
- $28,270
- Front
- $1,046
- Back
- $0
- Total
- $1,046
Walk-in or unattributedSalesperson: EMP-0000641 days in stock - SLE-0000020919 August 20252019 Chevrolet Equinox LTGranite Pre-OwnedVEH-0000861UsedDealer Trade
- Sale price
- $5,087
- Front
- -$389loss
- Back
- $0
- Total
- -$389
Walk-in or unattributedSalesperson: EMP-0002564 days in stock - SLE-0000020318 August 20252019 Dodge Charger R/TGranite ChevroletVEH-0000019UsedUsed Retail
- Sale price
- $8,238
- Front
- $408
- Back
- $2,129
- Total
- $2,537
Source: Paid Search BrandSalesperson: EMP-0000353 days in stock - SLE-0000020418 August 20252022 Chevrolet Camaro ZL1Granite ChevroletVEH-0000151CertifiedCertified Retail
- Sale price
- $21,883
- Front
- $3,148
- Back
- $287
- Total
- $3,434
Source: Dealer Website FormSalesperson: EMP-00012145 days in stock - SLE-0000020518 August 20252026 Chevrolet Colorado WTGranite ChevroletVEH-0000478NewNew Retail
- Sale price
- $45,267
- Front
- -$87loss
- Back
- $500
- Total
- $413
Source: Organic Search LandingSalesperson: EMP-000063 days in stock - SLE-0000020618 August 20252022 Chevrolet Tahoe LTGranite ChevroletVEH-0000699CertifiedCertified RetailTrade
- Sale price
- $23,404
- Front
- $3,232
- Back
- $1,357
- Total
- $4,589
Source: Dealer Website FormSalesperson: EMP-0000660 days in stock
Unit, lead source and attribution for these deals
| Deal | Unit | Lead source | Salesperson | Desk | Finance |
|---|---|---|---|---|---|
| SLE-00000227 | VEH-0000369 | Customer Referral | EMP-00022 | EMP-00014 | EMP-00017 |
| SLE-00000228 | VEH-0000421 | Walk-in or unattributed | EMP-00027 | EMP-00024 | Unattributed |
| SLE-00000229 | VEH-0000687 | Walk-in or unattributed | EMP-00010 | EMP-00008 | EMP-00005 |
| SLE-00000224 | VEH-0000696 | Third-Party Marketplace Listing | EMP-00010 | EMP-00008 | EMP-00005 |
| SLE-00000216 | VEH-0000111 | Organic Search Landing | EMP-00012 | EMP-00008 | EMP-00005 |
| SLE-00000217 | VEH-0000127 | Walk-in or unattributed | EMP-00029 | EMP-00030 | Unattributed |
| SLE-00000218 | VEH-0000230 | Walk-in or unattributed | EMP-00025 | EMP-00024 | Unattributed |
| SLE-00000219 | VEH-0000294 | Dealer Website Form | EMP-00027 | EMP-00030 | EMP-00028 |
| SLE-00000220 | VEH-0000315 | Third-Party Marketplace Listing | EMP-00012 | EMP-00001 | EMP-00005 |
| SLE-00000221 | VEH-0000326 | Showroom Walk-in | EMP-00012 | EMP-00001 | EMP-00005 |
| 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-00000213 | VEH-0000464 | Repeat Customer Outreach | EMP-00026 | EMP-00024 | EMP-00028 |
| SLE-00000214 | VEH-0000524 | Community Partner Referral | EMP-00006 | EMP-00008 | EMP-00005 |
| SLE-00000215 | VEH-0000654 | Showroom Walk-in | EMP-00003 | EMP-00002 | EMP-00005 |
| SLE-00000211 | VEH-0000210 | Showroom Walk-in | EMP-00015 | EMP-00023 | EMP-00017 |
| SLE-00000212 | VEH-0000632 | Walk-in or unattributed | EMP-00025 | EMP-00024 | EMP-00028 |
| SLE-00000210 | VEH-0000833 | Dealer Website Form | EMP-00015 | EMP-00013 | EMP-00017 |
| SLE-00000207 | VEH-0000154 | Dealer Website Form | EMP-00029 | EMP-00024 | EMP-00028 |
| SLE-00000208 | VEH-0000763 | Walk-in or unattributed | EMP-00006 | EMP-00001 | Unattributed |
| SLE-00000209 | VEH-0000861 | Walk-in or unattributed | EMP-00025 | EMP-00030 | Unattributed |
| SLE-00000203 | VEH-0000019 | Paid Search Brand | EMP-00003 | EMP-00008 | EMP-00005 |
| SLE-00000204 | VEH-0000151 | Dealer Website Form | EMP-00012 | EMP-00002 | Unattributed |
| SLE-00000205 | VEH-0000478 | Organic Search Landing | EMP-00006 | EMP-00002 | Unattributed |
| SLE-00000206 | VEH-0000699 | Dealer Website Form | EMP-00006 | EMP-00008 | EMP-00005 |
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.