Days in stock is not just a merchandising metric. Every day a vehicle sits on the lot, it ties up capital, carries insurance and lot costs, and usually needs a larger price reduction to move. Measuring aging with a consistent formula turns a vague feeling about slow stock into a number the dealership can act on.

Treat days in stock as a cost, not a curiosity

A vehicle that sits for 90 days is not the same asset it was at day 10. The capital used to buy and prepare it could have been working in another unit, the market value of the unit drifts, and the dealership keeps paying insurance, lot, and reconditioning costs while it waits.

The practical consequence is simple: slower stock must earn a bigger gross profit per vehicle to produce the same return. When a dealership ignores aging, it quietly overestimates the profitability of its average deal.

Estimate the holding cost per unit per day

A precise number requires real accounting, but a practical estimate is better than no number. Start with the total investment in the unit (purchase price plus attached costs), apply the dealership's annual cost of capital, divide by 365, and add fixed daily costs such as insurance, lot rent allocation, and security.

Example: a $15,000 unit with 9% capital cost carries about $3.70 per day in capital alone. Add $1–2 of daily fixed costs and the unit costs roughly $150–170 per month before a single repair or price reduction. Run this estimate per unit and per age bucket, and the stock report starts answering 'how much is this costing us?' instead of only 'how long has it been here?'.

  • Use total investment, not just purchase price, in the capital base
  • Keep one consistent capital rate and daily-cost policy across units
  • Recompute when a unit moves between statuses or gains new costs

Set review thresholds that mean something

Common review points are 30, 60, and 90 days, but the thresholds only matter when they trigger a defined response. Pair the age of each unit with its total cost and current buyer interest, so a 45-day unit with active inquiries is treated differently from a 45-day unit with none.

The inventory view should make aging visible in the normal working list, not in a monthly report that arrives after the decision window closes.

Make the response specific, not a discount reflex

An aging unit can justify a price change, better merchandising, fresh photos, targeted follow-up with interested buyers, a reconditioning review, or a wholesale exit. Choosing among these requires the unit's cost history and buyer activity, not a blanket rule like 'reduce every 90-day car by $1,000'.

The goal is to convert aging from a passive observation into an owner-assigned next action for every unit that is not progressing.

Keep the record current so the math stays real

Days in stock and holding cost are only as good as the underlying record. Purchase price, transport, inspection, repairs, parts, and status changes need to land on the vehicle record as they happen; otherwise the holding-cost estimate quietly drifts away from reality.

Car Dealer Tracker keeps purchase details, attached costs, current status, and days on lot on one vehicle record, on iPhone, iPad, Android, and the web, so the aging review works with current data instead of a spreadsheet snapshot.