How to manage used-car inventory aging at a small dealership

Manage used-car inventory aging with a weekly list of unsold vehicles, sorted by days since acquisition. Flag vehicles at your review dates, check what's keeping each one from selling, and assign one action with a deadline. For a vehicle you've already tried to move, compare a current net wholesale offer with the likely proceeds and added costs of another short retail attempt.

Start with a shared spreadsheet, your acquisition records, and the listings buyers can see. On a small lot, one manager can run the review with the people who handle listings and sales. Keep the meeting focused on decisions that can change before next week.

Build a report you can act on

Use one row per stock number. Record the acquisition date, retail-ready date, status, dollars invested to date, and asking price. Add the date of the last price change, the latest shopper activity you can verify, and three fields for decisions: next action, owner, and deadline. If a vehicle has a pending deal, include it until the deal closes and mark it pending so nobody starts a conflicting sale.

Pick one acquisition-date convention, such as the date on the purchase record. Subtract it from the report date using calendar days, with acquisition day as day zero. Keep the acquisition date when you relist a car or move it to another location. Count days since retail readiness separately. A car owned for 45 days but ready for only 10 needs a different review from one buyers could test-drive for all 45 days. If it's still blocked, record the reason and next update in your reconditioning workflow.

Summarize both number of cars and dollars invested by age bucket. One expensive pickup may account for more of your older inventory dollars than several lower-priced sedans. The National Automobile Dealers Association inventory worksheet groups units and inventory dollars by age. Use the same dollar basis for every row so the buckets are comparable.

Use age to trigger a decision

Try these review points as an initial store policy. Adjust them to your vehicle mix, cash needs, and how long it takes to get a usable wholesale bid. Add each review to the calendar when you buy the car so a unit crossing a threshold between meetings still gets attention.

• Day 30. Confirm the car is ready and the public listing is live and accurate. If buyers can see and drive it, check recent inquiries and comparable asking prices. Pick one correction you can verify.
• Day 45. Check whether the correction happened and whether buyer activity changed. If the car still sits, write down the evidence for a price change or a short retail test. Get a wholesale quote while you still have time to compare options.
• Day 60. Decide whether to take a wholesale offer or approve a dated retail extension. If you extend, record the price, the condition that would end the test early, and who makes the decision when the extension expires.

Use your own dates. A paperwork hold can deserve attention the day you discover it. A specialty vehicle may earn more time if you can explain the buyer pool and afford the wait.

Find the problem before cutting the price

Open the live listing on a phone. Check the primary photo, trim, mileage, price, availability, and whether the inquiry path reaches the right person. If the listing was missing from a channel you rely on, restore it and record when it went live there. If messages came in but nobody replied, assign a person to work the queue and track the result.

When the listing and follow-up are working, compare a handful of currently advertised vehicles. Start with a similar year, trim, mileage, condition, and history in the area buyers actually shop. Save the links and date. Widen the search if you have too few credible matches and write down the differences. Asking prices help you see what shoppers can choose today. Use your own recent closed deals, when comparable, to estimate what you might actually collect.

Make one clear decision per car. If you lower the asking price, verify that the change appears where customers see it and record the date. At the next review, compare inquiries, appointments, or test drives over similar stretches of time. Note anything else that changed, such as a holiday closure or a new listing channel. With one car and a handful of leads, a change in activity is a clue and rarely enough to isolate a cause.

Compare a short retail test with wholesale

Use an actual offer if you can get one. Confirm the expiration, conditions, and who pays any selling fee or transport. Put the net amount you could receive now beside the net amount you expect if a retail sale closes during your proposed extension. Subtract remaining sale expenses and the extra costs you expect to incur during the extension. Record what you would do if retail fails and how much the backup offer might change.

Hypothetical example: At day 60, a dealer has a $10,000 wholesale offer and would pay $200 for transport, leaving $9,800 today. A seven-day retail test could bring in $10,500 if a sale closes. After $300 in remaining retail sale expenses and $150 in extra holding costs, the retail scenario nets $10,050. That's $250 above the current wholesale option. If retail fails and the dealer can still net $9,800 on a later wholesale sale, the same $150 in added holding costs reduces the delayed outcome to $9,650. Confirm the quote window before assuming the offer will be there next week.

These are assumed amounts for comparing next steps. Use the dollars already invested to understand the result on the vehicle separately. They are common to both choices in this example.

Close the review with a decision log

End the meeting with a row someone can act on: Stock 214 | manager | confirm wholesale quote by Thursday noon | accept the offer if no retail sale has closed by Friday at 5 p.m. and the confirmed net meets the approved floor. At the next review, mark the action complete, overdue, or superseded and record the reason. Once a month, look back at the vehicles you wholesaled or extended. If several arrived with the same unresolved issue or drew few shoppers at similar prices, turn that observation into a question to check before the next purchase.