Inventory
Stock held at one snapshot date. Positions, never summed across dates.
Granite Subaru · Snapshot 31 August 2025 · Aged over 60 days
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.
The aged threshold is an ARPI project default, not an industry benchmark, and it is a different number from the top age bucket. The market estimate is synthetic and is not a market valuation.
Filters and controls2 applied
What the market estimate is, and what the aged threshold means
The market price estimate is a synthetic reference value generated for this fictional dataset. It is not a market valuation and is drawn from no auction result, guidebook or licensed benchmark. Price to market compares the asking price against it and describes the difference; it is not evidence that a price is right or wrong.
The aged threshold is an ARPI project default, not an industry benchmark. It is a different number from the top age bucket: a unit past the threshold may sit in any bucket above it.
Price movement is derived from consecutive month-end snapshots of the same unit at the same store. It is an observed change in the advertised price and is not evidence of a manager decision, a pricing strategy or a repricing action; ARPI models none of those.
Unit counts and investment are positions at the snapshot date. They add across units and stores on that date and never across dates.
The lot at this date
- Active units
- 90
- Held at this date
- Inventory investment
- $1,928,452
- Acquisition plus reconditioning. Not the accounting book value.
- Median days in stock
- 36
- Mean 51.9 days. The gap is the aged tail.
- Aged over 60 days
- 30
- 33.3% of units · ARPI project default, not a benchmark
- Price-to-market coverage
- 85.6%
- 13 units carry no synthetic estimate and therefore no ratio
- Repriced since the prior month end
- 50
- An observed change in the advertised price, not evidence of a decision
Every figure on this rail is a position at 31 August 2025. Positions add across units and stores on that date and never across dates.
Age, and the capital in it
Units and investment by age band
5 age bands. 0-30: 39, 31-60: 21, 61-90: 15, 91-120: 6, Over 120: 9. A position at 31 August 2025, never a total across dates.
- 0-3039$794,386
- 31-6021$448,461
- 61-9015$317,857
- 91-1206$154,023
- Over 1209$213,725
Read age bucket as a table
| Days in stock | Units | Share of units | Investment |
|---|---|---|---|
| 0-30 | 39 | 43.3% | $794,386 |
| 31-60 | 21 | 23.3% | $448,461 |
| 61-90 | 15 | 16.7% | $317,857 |
| 91-120 | 6 | 6.7% | $154,023 |
| Over 120 | 9 | 10.0% | $213,725 |
Ramp turns at the 60-day aged threshold, an ARPI project default rather than an industry benchmark. A unit past it may sit in any bucket above it.
Age against asking price
Days in stock against price to market
One mark per unit at this snapshot. Horizontal is the asking price against the synthetic market estimate; vertical is days in stock; mark area is inventory investment; colour is the exported age band.
77 units plotted by days in stock against price to market, sized by inventory investment, at 31 August 2025. Price to market runs from 0.880 to 1.121; days in stock reach 212. 13 of 90 units carry no synthetic estimate, so they have no ratio and are not plotted.
Older ↑
Lower price to marketdashed rule: asking price equals the synthetic estimateHigher price to market →
- 0-30
- 31-60
- 61-90
- 91-120
- Over 120
13 of 90 units carry no synthetic market estimate, so they have no ratio and are not plotted. A missing estimate is a missing value and is never substituted with zero.
Every plotted unit’s exact days in stock, price-to-market ratio and inventory investment are in the unit table below, which opens from its own summary and also lists the units this plot cannot place.
Price movement
Advertised price, then and now
Original and current asking price summed over the units in each age band, with the reduction taken since listing. Each measure is scaled to its own largest band.
Original asking: 0-30 $948,323, 31-60 $527,716, 61-90 $381,047, 91-120 $182,653, Over 120 $261,623. Current asking: 0-30 $947,571, 31-60 $521,380, 61-90 $371,021, 91-120 $175,915, Over 120 $244,171. Markdown since listing: 0-30 $752, 31-60 $6,336, 61-90 $10,026, 91-120 $6,738, Over 120 $17,452.
- 0-30
- 31-60
- 61-90
- 91-120
- Over 120
Original asking
- $948,323
- $527,716
- $381,047
- $182,653
- $261,623
Current asking
- $947,571
- $521,380
- $371,021
- $175,915
- $244,171
Markdown since listing
- $752
- $6,336
- $10,026
- $6,738
- $17,452
50 units were advertised lower at this snapshot than at the prior month end. That is a different interval from the markdown above, which is measured since the unit was listed, and it is an observed change in the advertised price rather than evidence of a decision.
Read advertised price, then and now as a table
| Age band | Original asking | Current asking | Markdown since listing |
|---|---|---|---|
| 0-30 | $948,323 | $947,571 | $752 |
| 31-60 | $527,716 | $521,380 | $6,336 |
| 61-90 | $381,047 | $371,021 | $10,026 |
| 91-120 | $182,653 | $175,915 | $6,738 |
| Over 120 | $261,623 | $244,171 | $17,452 |
VEH-0000794
Operational position
- Snapshot date
- 31 August 2025
- Days in stock
- 5
- Age bucket
- 0-30
- Odometer
- 28 mi
- Asking price
- $32,018
- Original asking price
- $32,018
- Synthetic market estimate
- $29,196 · synthetic estimate
- Price to market
- 1.097
- Since prior snapshot
- First appearance — no prior observation
- Inventory investment
- $28,429
Accounting position
- Control account
- 1210 · New Vehicle Inventory
- Acquisition cost
- $28371.00
- Transportation
- $895.00
- Reconditioning
- $58.00
- Accessories
- $0.00
- Other capitalized
- $0.00
- Write-down
- $0.00
- Current book value
- $29324.00
- Floorplan principal
- $28371.00 · liability context
Floorplan principal is a liability carried alongside the unit. It is not part of book value and is never netted against it; ARPI publishes no net inventory position and models no floorplan interest, curtailment or carrying cost.
Every unit on the lot
Read all 90 units at this snapshot date as a table
| Unit | Store | Vehicle | Days | Bucket | Asking | Est. (synthetic) | Price to market | Since prior | Investment |
|---|---|---|---|---|---|---|---|---|---|
| VEH-0000010 | GSA-002 | 2025 Subaru Ascent | 13 | 0-30 | $38,605 | $37,065 | 1.042 | First appearance | $35,187 |
| VEH-0000049 | GSA-002 | 2025 Subaru Impreza | 87 | 61-90 | $24,440 | No estimate | — | -$223.99 | $22,495 |
| VEH-0000053 | GSA-002 | 2022 Subaru WRX | 59 | 31-60 | $22,871 | $24,839 | 0.921 | -$395.52 | $17,815 |
| VEH-0000061 | GSA-002 | 2022 Subaru Outback | 3 | 0-30 | $21,005 | $21,429 | 0.980 | First appearance | $17,209 |
| VEH-0000076 | GSA-002 | 2025 Subaru Impreza | 3 | 0-30 | $25,655 | $24,310 | 1.055 | First appearance | $23,692 |
| VEH-0000079 | GSA-002 | 2021 Subaru Ascent | 180 | Over 120 | $19,011 | No estimate | — | -$719.81 | $17,069 |
| VEH-0000084 | GSA-002 | 2025 Subaru Impreza | 3 | 0-30 | $24,154 | $22,416 | 1.078 | First appearance | $21,966 |
| VEH-0000093 | GSA-002 | 2022 Subaru Outback | 171 | Over 120 | $18,623 | No estimate | — | -$345.99 | $15,368 |
| VEH-0000119 | GSA-002 | 2025 Subaru Ascent | 10 | 0-30 | $39,786 | $40,436 | 0.984 | First appearance | $36,803 |
| VEH-0000126 | GSA-002 | 2019 Subaru Forester | 68 | 61-90 | $5,371 | $5,369 | 1.000 | -$94.52 | $4,580 |
| VEH-0000133 | GSA-002 | 2025 Subaru Ascent | 76 | 61-90 | $38,844 | $38,976 | 0.997 | -$356.00 | $34,790 |
| VEH-0000139 | GSA-002 | 2023 Toyota RAV4 | 12 | 0-30 | $28,083 | No estimate | — | First appearance | $21,188 |
| VEH-0000141 | GSA-002 | 2020 Subaru Outback | 40 | 31-60 | $10,743 | $11,498 | 0.934 | -$185.79 | $8,181 |
| VEH-0000142 | GSA-002 | 2025 Subaru Ascent | 26 | 0-30 | $39,201 | $37,343 | 1.050 | First appearance | $36,261 |
| VEH-0000143 | GSA-002 | 2025 Subaru Impreza | 66 | 61-90 | $26,605 | $25,339 | 1.050 | -$468.20 | $22,310 |
| VEH-0000146 | GSA-002 | 2026 Subaru Ascent | 39 | 31-60 | $38,648 | $42,714 | 0.905 | -$350.99 | $35,943 |
| VEH-0000152 | GSA-002 | 2026 Subaru Outback | 13 | 0-30 | $33,400 | $32,814 | 1.018 | First appearance | $29,985 |
| VEH-0000155 | GSA-002 | 2026 Subaru Ascent | 19 | 0-30 | $41,376 | $45,793 | 0.904 | First appearance | $37,751 |
| VEH-0000166 | GSA-002 | 2017 Toyota RAV4 | 20 | 0-30 | $4,461 | $4,328 | 1.031 | First appearance | $3,519 |
| VEH-0000176 | GSA-002 | 2025 Subaru Impreza | 3 | 0-30 | $31,473 | $33,296 | 0.945 | First appearance | $22,994 |
| VEH-0000196 | GSA-002 | 2022 Subaru Outback | 2 | 0-30 | $19,619 | $19,317 | 1.016 | First appearance | $14,709 |
| VEH-0000206 | GSA-002 | 2026 Subaru Ascent | 32 | 31-60 | $38,916 | $38,403 | 1.013 | -$353.43 | $35,554 |
| VEH-0000214 | GSA-002 | 2026 Subaru Ascent | 47 | 31-60 | $39,564 | $35,283 | 1.121 | -$359.31 | $36,821 |
| VEH-0000221 | GSA-002 | 2025 Subaru Impreza | 10 | 0-30 | $25,400 | $26,273 | 0.967 | First appearance | $22,868 |
| VEH-0000238 | GSA-002 | 2026 Subaru Ascent | 62 | 61-90 | $47,296 | $50,244 | 0.941 | -$832.33 | $33,915 |
| VEH-0000240 | GSA-002 | 2020 Subaru Impreza | 78 | 61-90 | $9,603 | $10,024 | 0.958 | -$169.00 | $7,648 |
| VEH-0000247 | GSA-002 | 2022 Subaru Crosstrek | 160 | Over 120 | $11,957 | $12,750 | 0.938 | -$222.16 | $10,597 |
| VEH-0000253 | GSA-002 | 2025 Subaru Ascent | 47 | 31-60 | $39,209 | $35,091 | 1.117 | -$356.08 | $36,150 |
| VEH-0000280 | GSA-002 | 2025 Subaru Impreza | 72 | 61-90 | $23,945 | $26,487 | 0.904 | -$421.39 | $19,401 |
| VEH-0000325 | GSA-002 | 2025 Subaru Impreza | 32 | 31-60 | $25,199 | $22,668 | 1.112 | -$228.85 | $23,409 |
| VEH-0000331 | GSA-002 | 2024 Ford F-150 | 18 | 0-30 | $41,477 | No estimate | — | First appearance | $31,107 |
| VEH-0000355 | GSA-002 | 2024 Ford F-150 | 57 | 31-60 | $44,868 | No estimate | — | -$775.94 | $33,550 |
| VEH-0000387 | GSA-002 | 2022 Subaru Outback | 22 | 0-30 | $19,489 | $21,537 | 0.905 | First appearance | $14,563 |
| VEH-0000388 | GSA-002 | 2023 Subaru Impreza | 91 | 91-120 | $22,470 | $21,985 | 1.022 | -$402.51 | $17,237 |
| VEH-0000398 | GSA-002 | 2018 Ford F-150 | 65 | 61-90 | $11,027 | $11,599 | 0.951 | -$194.07 | $8,769 |
| VEH-0000408 | GSA-002 | 2026 Subaru Ascent | 66 | 61-90 | $37,136 | $36,615 | 1.014 | -$653.53 | $32,151 |
| VEH-0000410 | GSA-002 | 2025 Subaru Forester | 13 | 0-30 | $49,021 | $46,197 | 1.061 | First appearance | $36,123 |
| VEH-0000412 | GSA-002 | 2018 Nissan Rogue | 40 | 31-60 | $5,435 | No estimate | — | -$94.00 | $4,053 |
| VEH-0000423 | GSA-002 | 2026 Subaru Ascent | 86 | 61-90 | $38,973 | $39,587 | 0.985 | -$357.18 | $37,046 |
| VEH-0000429 | GSA-002 | 2025 Subaru Ascent | 65 | 61-90 | $38,274 | $41,532 | 0.922 | -$350.77 | $34,951 |
| VEH-0000431 | GSA-002 | 2021 Subaru Forester | 51 | 31-60 | $15,849 | $16,327 | 0.971 | -$274.09 | $12,268 |
| VEH-0000446 | GSA-002 | 2025 Subaru Impreza | 4 | 0-30 | $24,698 | $26,645 | 0.927 | First appearance | $22,719 |
| VEH-0000450 | GSA-002 | 2018 Subaru Crosstrek | 16 | 0-30 | $6,139 | $6,175 | 0.994 | First appearance | $4,660 |
| VEH-0000454 | GSA-002 | 2025 Subaru Ascent | 6 | 0-30 | $43,338 | No estimate | — | First appearance | $33,535 |
| VEH-0000457 | GSA-002 | 2021 Subaru Ascent | 32 | 31-60 | $20,944 | $20,259 | 1.034 | -$362.20 | $15,261 |
| VEH-0000467 | GSA-002 | 2017 Subaru Impreza | 75 | 61-90 | $2,939 | $3,105 | 0.947 | -$51.73 | $2,432 |
| VEH-0000494 | GSA-002 | 2022 Subaru WRX | 129 | Over 120 | $25,372 | $28,822 | 0.880 | -$462.79 | $18,841 |
| VEH-0000499 | GSA-002 | 2024 Subaru Impreza | 9 | 0-30 | $22,168 | $22,475 | 0.986 | First appearance | $16,847 |
| VEH-0000510 | GSA-002 | 2018 Subaru Crosstrek | 9 | 0-30 | $3,105 | $3,000 | 1.035 | First appearance | $2,583 |
| VEH-0000513 | GSA-002 | 2026 Subaru Ascent | 142 | Over 120 | $38,403 | $39,439 | 0.974 | -$358.53 | $35,665 |
| VEH-0000517 | GSA-002 | 2016 Volkswagen Jetta | 59 | 31-60 | $3,160 | No estimate | — | -$54.65 | $2,466 |
| VEH-0000529 | GSA-002 | 2020 Subaru Outback | 114 | 91-120 | $11,425 | $11,985 | 0.953 | -$204.67 | $8,820 |
| VEH-0000541 | GSA-002 | 2024 Chevrolet Blazer EV | 51 | 31-60 | $35,273 | $35,757 | 0.987 | -$610.01 | $26,616 |
| VEH-0000549 | GSA-002 | 2026 Subaru Ascent | 57 | 31-60 | $38,812 | $36,765 | 1.056 | -$352.48 | $35,406 |
| VEH-0000550 | GSA-002 | 2021 Subaru Ascent | 16 | 0-30 | $19,547 | $20,714 | 0.944 | First appearance | $14,481 |
| VEH-0000558 | GSA-002 | 2026 Subaru Ascent | 20 | 0-30 | $40,890 | $37,379 | 1.094 | First appearance | $36,333 |
| VEH-0000559 | GSA-002 | 2021 Subaru Forester | 13 | 0-30 | $15,549 | $14,660 | 1.061 | First appearance | $12,046 |
| VEH-0000564 | GSA-002 | 2017 Subaru Impreza | 9 | 0-30 | $3,238 | $3,232 | 1.002 | First appearance | $2,634 |
| VEH-0000566 | GSA-002 | 2022 Subaru Crosstrek | 59 | 31-60 | $15,846 | $16,522 | 0.959 | -$274.03 | $12,708 |
| VEH-0000576 | GSA-002 | 2026 Subaru Ascent | 212 | Over 120 | $38,413 | $42,876 | 0.896 | $0.00 | $36,229 |
| VEH-0000580 | GSA-002 | 2021 Subaru Forester | 64 | 61-90 | $23,665 | $26,300 | 0.900 | -$416.45 | $17,065 |
| VEH-0000597 | GSA-002 | 2026 Subaru Ascent | 47 | 31-60 | $39,940 | $43,028 | 0.928 | -$362.72 | $37,068 |
| VEH-0000615 | GSA-002 | 2019 Kia Sportage | 27 | 0-30 | $8,110 | No estimate | — | First appearance | $6,060 |
| VEH-0000620 | GSA-002 | 2020 Chrysler Pacifica | 22 | 0-30 | $9,185 | $9,311 | 0.987 | First appearance | $7,654 |
| VEH-0000628 | GSA-002 | 2018 Subaru Outback | 16 | 0-30 | $7,766 | $7,133 | 1.089 | First appearance | $6,236 |
| VEH-0000653 | GSA-002 | 2025 Subaru Ascent | 181 | Over 120 | $36,885 | $36,610 | 1.008 | -$350.92 | $35,158 |
| VEH-0000663 | GSA-002 | 2024 Subaru Outback | 108 | 91-120 | $29,246 | $30,706 | 0.953 | -$270.52 | $27,404 |
| VEH-0000666 | GSA-002 | 2019 Subaru Forester | 33 | 31-60 | $10,971 | $10,343 | 1.061 | -$189.74 | $8,452 |
| VEH-0000688 | GSA-002 | 2019 Subaru Forester | 2 | 0-30 | $7,699 | $7,426 | 1.037 | First appearance | $6,141 |
| VEH-0000704 | GSA-002 | 2016 Subaru Legacy | 32 | 31-60 | $4,125 | $4,284 | 0.963 | -$71.34 | $3,307 |
| VEH-0000708 | GSA-002 | 2026 Subaru Outback | 11 | 0-30 | $35,328 | $35,556 | 0.994 | First appearance | $26,512 |
| VEH-0000709 | GSA-002 | 2024 Jeep Wrangler | 19 | 0-30 | $29,292 | $27,889 | 1.050 | First appearance | $24,377 |
| VEH-0000724 | GSA-002 | 2025 Subaru Forester | 114 | 91-120 | $37,541 | No estimate | — | -$672.49 | $29,945 |
| VEH-0000740 | GSA-002 | 2026 Subaru Ascent | 30 | 0-30 | $39,749 | No estimate | — | First appearance | $35,541 |
| VEH-0000749 | GSA-002 | 2025 Subaru Ascent | 33 | 31-60 | $39,752 | No estimate | — | -$361.01 | $35,755 |
| VEH-0000769 | GSA-002 | 2025 Subaru Ascent | 113 | 91-120 | $38,353 | $37,186 | 1.031 | -$354.76 | $35,421 |
| VEH-0000770 | GSA-002 | 2018 Subaru Crosstrek | 48 | 31-60 | $4,897 | $5,020 | 0.975 | -$84.69 | $3,732 |
| VEH-0000780 | GSA-002 | 2022 Subaru Crosstrek | 144 | Over 120 | $14,437 | $16,345 | 0.883 | -$263.34 | $12,267 |
| VEH-0000786 | GSA-002 | 2026 Subaru Ascent | 88 | 61-90 | $39,273 | $36,553 | 1.074 | -$359.94 | $37,133 |
| VEH-0000794 | GSA-002 | 2026 Subaru Outback | 5 | 0-30 | $32,018 | $29,196 | 1.097 | First appearance | $28,429 |
| VEH-0000808 | GSA-002 | 2025 Subaru Forester | 112 | 91-120 | $36,880 | $35,912 | 1.027 | -$341.14 | $35,196 |
| VEH-0000817 | GSA-002 | 2020 Chevrolet Suburban | 15 | 0-30 | $10,244 | $9,353 | 1.095 | First appearance | $7,618 |
| VEH-0000823 | GSA-002 | 2025 Subaru Impreza | 48 | 31-60 | $26,359 | $27,245 | 0.968 | -$239.38 | $23,945 |
| VEH-0000840 | GSA-002 | 2020 Subaru Impreza | 20 | 0-30 | $10,289 | $10,767 | 0.956 | First appearance | $8,057 |
| VEH-0000846 | GSA-002 | 2025 Subaru Impreza | 12 | 0-30 | $24,648 | $24,243 | 1.017 | First appearance | $22,810 |
| VEH-0000875 | GSA-002 | 2025 Subaru Impreza | 3 | 0-30 | $24,749 | $25,141 | 0.984 | First appearance | $22,069 |
| VEH-0000878 | GSA-002 | 2025 Subaru Ascent | 153 | Over 120 | $41,069 | $46,402 | 0.885 | -$763.03 | $32,530 |
| VEH-0000882 | GSA-002 | 2023 Dodge Charger | 30 | 0-30 | $22,619 | $22,066 | 1.025 | First appearance | $18,273 |
| VEH-0000884 | GSA-002 | 2025 Subaru Impreza | 20 | 0-30 | $24,997 | $23,852 | 1.048 | First appearance | $22,845 |
| VEH-0000895 | GSA-002 | 2016 Subaru Legacy | 66 | 61-90 | $3,630 | $3,478 | 1.044 | -$63.88 | $3,172 |