Deal Explorer
97 deals · All three stores · 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.
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 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
- 97
- Matching the current filters
- Retail units
- 80
- 17 matched transactions are not retail
- Total gross
- $256,409
- Retail rows only
- Front gross
- $151,720
- Back gross
- $104,689
- Closed at a front loss
- 28
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-00000431 | 25 October 2025 | Granite Subaru | 2023 Subaru Impreza BaseCertified | Wholesalenot retail | $14,792 | -$741loss | $0 | -$741 | 44 |
| SLE-00000432 | 25 October 2025 | Granite Subaru | 2026 Subaru Ascent Onyx EditionNew | New Retail | $37,111 | $807 | $458 | $1,265 | 87 |
| SLE-00000433 | 25 October 2025 | Granite Pre-Owned | 2016 Toyota Camry SEUsed | Used Retail | $3,981 | $482 | $1,512 | $1,994 | 29 |
| SLE-00000434 | 25 October 2025 | Granite Chevrolet | 2026 Chevrolet Colorado Z71New | New Retail | $46,206 | $1,909 | $790 | $2,699 | 35 |
| SLE-00000435 | 25 October 2025 | Granite Chevrolet | 2026 Chevrolet Silverado 1500 WTUsed | Used Retail | $51,757 | $8,098 | $2,038 | $10,136 | 35 |
| SLE-00000436 | 25 October 2025 | Granite Pre-Owned | 2024 Nissan Frontier PRO-4XUsed | Used Retail | $38,392 | $7,490 | $107 | $7,597 | 61 |
| SLE-00000437 | 26 October 2025 | Granite Subaru | 2025 Subaru Ascent Onyx EditionNew | New Retail | $36,264 | -$932loss | $2,332 | $1,401 | 47 |
| SLE-00000438 | 27 October 2025 | Granite Subaru | 2026 Subaru Ascent Onyx EditionNew | Wholesalenot retail | $36,285 | -$2,216loss | $0 | -$2,216 | 76 |
| SLE-00000439 | 27 October 2025 | Granite Subaru | 2025 Subaru Impreza SportCertified | Certified Retail | $29,517 | $5,773 | $779 | $6,552 | 60 |
| SLE-00000440 | 27 October 2025 | Granite Subaru | 2017 Subaru Impreza SportUsed | Used Retail | $2,661 | -$521loss | $1,556 | $1,035 | 132 |
| SLE-00000441 | 27 October 2025 | Granite Subaru | 2026 Subaru Ascent BaseNew | New Retail | $40,950 | $2,892 | $800 | $3,692 | 31 |
| SLE-00000442 | 28 October 2025 | Granite Subaru | 2022 Subaru Outback BaseCertified | Certified Retail | $19,150 | $1,190 | $790 | $1,980 | 61 |
| SLE-00000443 | 28 October 2025 | Granite Chevrolet | 2024 Chevrolet Silverado EV RSTUsed | Used Retail | $38,268 | $5,477 | $2,364 | $7,841 | 40 |
| SLE-00000444 | 28 October 2025 | Granite Pre-Owned | 2020 Kia Telluride SXUsed | Wholesalenot retail | $9,327 | -$1,123loss | $0 | -$1,123 | 48 |
| SLE-00000445 | 28 October 2025 | Granite Pre-Owned | 2020 Ford F-150 XLTUsed | Used Retail | $18,084 | $2,931 | $700 | $3,631 | 75 |
| SLE-00000446 | 28 October 2025 | Granite Chevrolet | 2018 Chevrolet Silverado 1500 LTUsed | Used Retail | $5,479 | $430 | $1,490 | $1,920 | 68 |
| SLE-00000447 | 28 October 2025 | Granite Subaru | 2026 Subaru Outback Onyx Edition XTNew | New Retail | $30,855 | $309 | $825 | $1,134 | 49 |
| SLE-00000448 | 29 October 2025 | Granite Subaru | 2021 Subaru Forester BaseUsed | Used Retail | $14,823 | $2,361 | $1,821 | $4,182 | 44 |
| SLE-00000449 | 30 October 2025 | Granite Chevrolet | 2021 Chevrolet Equinox LTUsed | Used Retail | $14,884 | $1,774 | $1,229 | $3,004 | 59 |
| SLE-00000450 | 30 October 2025 | Granite Chevrolet | 2019 Chevrolet Equinox LSUsed | Used Retail | $11,650 | $1,556 | $1,912 | $3,467 | 43 |
| SLE-00000451 | 31 October 2025 | Granite Subaru | 2025 Subaru Impreza BaseNew | New Retail | $22,901 | -$568loss | $1,343 | $775 | 65 |
| SLE-00000452 | 31 October 2025 | Granite Chevrolet | 2024 Chevrolet Blazer EV LTNew | Lease | $37,445 | $1,570 | $2,307 | $3,877 | 18 |
- SLE-0000043125 October 20252023 Subaru Impreza BaseGranite SubaruVEH-0000087CertifiedWholesale
- Sale price
- $14,792
- Front
- -$741loss
- Back
- $0
- Total
- -$741
Walk-in or unattributedSalesperson: EMP-0001844 days in stock - SLE-0000043225 October 20252026 Subaru Ascent Onyx EditionGranite SubaruVEH-0000206NewNew RetailTrade
- Sale price
- $37,111
- Front
- $807
- Back
- $458
- Total
- $1,265
Source: Direct Mail ResponseSalesperson: EMP-0001587 days in stock - SLE-0000043325 October 20252016 Toyota Camry SEGranite Pre-OwnedVEH-0000368UsedUsed Retail
- Sale price
- $3,981
- Front
- $482
- Back
- $1,512
- Total
- $1,994
Source: Customer ReferralSalesperson: EMP-0002729 days in stock - SLE-0000043425 October 20252026 Chevrolet Colorado Z71Granite ChevroletVEH-0000386NewNew RetailTrade
- Sale price
- $46,206
- Front
- $1,909
- Back
- $790
- Total
- $2,699
Source: Customer ReferralSalesperson: EMP-0000735 days in stock - SLE-0000043525 October 20252026 Chevrolet Silverado 1500 WTGranite ChevroletVEH-0000793UsedUsed RetailTrade
- Sale price
- $51,757
- Front
- $8,098
- Back
- $2,038
- Total
- $10,136
Source: Showroom Walk-inSalesperson: EMP-0001035 days in stock - SLE-0000043625 October 20252024 Nissan Frontier PRO-4XGranite Pre-OwnedVEH-0000834UsedUsed RetailTrade
- Sale price
- $38,392
- Front
- $7,490
- Back
- $107
- Total
- $7,597
Source: Customer ReferralSalesperson: EMP-0002561 days in stock - SLE-0000043726 October 20252025 Subaru Ascent Onyx EditionGranite SubaruVEH-0000862NewNew Retail
- Sale price
- $36,264
- Front
- -$932loss
- Back
- $2,332
- Total
- $1,401
Walk-in or unattributedSalesperson: EMP-0001647 days in stock - SLE-0000043827 October 20252026 Subaru Ascent Onyx EditionGranite SubaruVEH-0000155NewWholesale
- Sale price
- $36,285
- Front
- -$2,216loss
- Back
- $0
- Total
- -$2,216
Walk-in or unattributedSalesperson: EMP-0001676 days in stock - SLE-0000043927 October 20252025 Subaru Impreza SportGranite SubaruVEH-0000176CertifiedCertified RetailTrade
- Sale price
- $29,517
- Front
- $5,773
- Back
- $779
- Total
- $6,552
Source: Service Lane OpportunitySalesperson: EMP-0001860 days in stock - SLE-0000044027 October 20252017 Subaru Impreza SportGranite SubaruVEH-0000467UsedUsed Retail
- Sale price
- $2,661
- Front
- -$521loss
- Back
- $1,556
- Total
- $1,035
Source: Paid Social Feed CampaignSalesperson: EMP-00016132 days in stock - SLE-0000044127 October 20252026 Subaru Ascent BaseGranite SubaruVEH-0000658NewNew Retail
- Sale price
- $40,950
- Front
- $2,892
- Back
- $800
- Total
- $3,692
Source: Service Lane OpportunitySalesperson: EMP-0001531 days in stock - SLE-0000044228 October 20252022 Subaru Outback BaseGranite SubaruVEH-0000061CertifiedCertified RetailTrade
- Sale price
- $19,150
- Front
- $1,190
- Back
- $790
- Total
- $1,980
Walk-in or unattributedSalesperson: EMP-0001861 days in stock - SLE-0000044328 October 20252024 Chevrolet Silverado EV RSTGranite ChevroletVEH-0000122UsedUsed Retail
- Sale price
- $38,268
- Front
- $5,477
- Back
- $2,364
- Total
- $7,841
Source: Showroom Walk-inSalesperson: EMP-0000340 days in stock - SLE-0000044428 October 20252020 Kia Telluride SXGranite Pre-OwnedVEH-0000223UsedWholesale
- Sale price
- $9,327
- Front
- -$1,123loss
- Back
- $0
- Total
- -$1,123
Walk-in or unattributedSalesperson: EMP-0002648 days in stock - SLE-0000044528 October 20252020 Ford F-150 XLTGranite Pre-OwnedVEH-0000512UsedUsed RetailTrade
- Sale price
- $18,084
- Front
- $2,931
- Back
- $700
- Total
- $3,631
Walk-in or unattributedSalesperson: EMP-0002775 days in stock - SLE-0000044628 October 20252018 Chevrolet Silverado 1500 LTGranite ChevroletVEH-0000714UsedUsed Retail
- Sale price
- $5,479
- Front
- $430
- Back
- $1,490
- Total
- $1,920
Source: Showroom Walk-inSalesperson: EMP-0000368 days in stock - SLE-0000044728 October 20252026 Subaru Outback Onyx Edition XTGranite SubaruVEH-0000746NewNew Retail
- Sale price
- $30,855
- Front
- $309
- Back
- $825
- Total
- $1,134
Source: Third-Party Marketplace ListingSalesperson: EMP-0001649 days in stock - SLE-0000044829 October 20252021 Subaru Forester BaseGranite SubaruVEH-0000251UsedUsed Retail
- Sale price
- $14,823
- Front
- $2,361
- Back
- $1,821
- Total
- $4,182
Source: Showroom Walk-inSalesperson: EMP-0001544 days in stock - SLE-0000044930 October 20252021 Chevrolet Equinox LTGranite ChevroletVEH-0000805UsedUsed Retail
- Sale price
- $14,884
- Front
- $1,774
- Back
- $1,229
- Total
- $3,004
Source: Organic Search LandingSalesperson: EMP-0001059 days in stock - SLE-0000045030 October 20252019 Chevrolet Equinox LSGranite ChevroletVEH-0000809UsedUsed Retail
- Sale price
- $11,650
- Front
- $1,556
- Back
- $1,912
- Total
- $3,467
Source: Dealer Website FormSalesperson: EMP-0000343 days in stock - SLE-0000045131 October 20252025 Subaru Impreza BaseGranite SubaruVEH-0000446NewNew RetailTrade
- Sale price
- $22,901
- Front
- -$568loss
- Back
- $1,343
- Total
- $775
Walk-in or unattributedSalesperson: EMP-0001865 days in stock - SLE-0000045231 October 20252024 Chevrolet Blazer EV LTGranite ChevroletVEH-0000651NewLeaseTrade
- Sale price
- $37,445
- Front
- $1,570
- Back
- $2,307
- Total
- $3,877
Walk-in or unattributedSalesperson: EMP-0000718 days in stock
Unit, lead source and attribution for these deals
| Deal | Unit | Lead source | Salesperson | Desk | Finance |
|---|---|---|---|---|---|
| SLE-00000431 | VEH-0000087 | Walk-in or unattributed | EMP-00018 | EMP-00013 | Unattributed |
| SLE-00000432 | VEH-0000206 | Direct Mail Response | EMP-00015 | EMP-00013 | EMP-00017 |
| SLE-00000433 | VEH-0000368 | Customer Referral | EMP-00027 | EMP-00024 | EMP-00028 |
| SLE-00000434 | VEH-0000386 | Customer Referral | EMP-00007 | EMP-00002 | EMP-00005 |
| SLE-00000435 | VEH-0000793 | Showroom Walk-in | EMP-00010 | EMP-00002 | EMP-00005 |
| SLE-00000436 | VEH-0000834 | Customer Referral | EMP-00025 | EMP-00024 | EMP-00028 |
| SLE-00000437 | VEH-0000862 | Walk-in or unattributed | EMP-00016 | EMP-00013 | EMP-00017 |
| SLE-00000438 | VEH-0000155 | Walk-in or unattributed | EMP-00016 | EMP-00014 | Unattributed |
| SLE-00000439 | VEH-0000176 | Service Lane Opportunity | EMP-00018 | EMP-00014 | EMP-00017 |
| SLE-00000440 | VEH-0000467 | Paid Social Feed Campaign | EMP-00016 | EMP-00013 | EMP-00017 |
| SLE-00000441 | VEH-0000658 | Service Lane Opportunity | EMP-00015 | EMP-00013 | EMP-00017 |
| SLE-00000442 | VEH-0000061 | Walk-in or unattributed | EMP-00018 | EMP-00014 | EMP-00017 |
| SLE-00000443 | VEH-0000122 | Showroom Walk-in | EMP-00003 | EMP-00008 | EMP-00005 |
| SLE-00000444 | VEH-0000223 | Walk-in or unattributed | EMP-00026 | EMP-00024 | Unattributed |
| SLE-00000445 | VEH-0000512 | Walk-in or unattributed | EMP-00027 | EMP-00030 | EMP-00028 |
| SLE-00000446 | VEH-0000714 | Showroom Walk-in | EMP-00003 | EMP-00008 | EMP-00005 |
| SLE-00000447 | VEH-0000746 | Third-Party Marketplace Listing | EMP-00016 | EMP-00013 | EMP-00017 |
| SLE-00000448 | VEH-0000251 | Showroom Walk-in | EMP-00015 | EMP-00013 | EMP-00017 |
| SLE-00000449 | VEH-0000805 | Organic Search Landing | EMP-00010 | EMP-00002 | Unattributed |
| SLE-00000450 | VEH-0000809 | Dealer Website Form | EMP-00003 | EMP-00001 | EMP-00005 |
| SLE-00000451 | VEH-0000446 | Walk-in or unattributed | EMP-00018 | EMP-00023 | EMP-00017 |
| SLE-00000452 | VEH-0000651 | Walk-in or unattributed | EMP-00007 | 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.