Solution — Automotive Retail

Used Vehicle Inventory Dashboard

A representative build: a used vehicle operation instrumented at the unit level — true days in inventory, landed cost with reconditioning charged back to the buyer who sourced it, and a recon clock broken into the stages where days actually disappear.

Unit Level

Every metric reachable down to a single stock number

6 Recon Stages

Arrival through merchandising, timed separately

Landed Cost

Fees, transport, and recon charged back to the acquisition source

~8 Weeks

Assessment to deployment, once stage capture was agreed

The situation

A store carrying more sixty-day units than it wanted, running the standard monthly aging conversation, and getting the standard result: a markdown on the worst offenders, a resolution to buy better, and the same conversation four weeks later.

Nobody was doing anything wrong. The information available — an aging bucket report and a gut sense of which buyer was hitting — simply could not distinguish a buying problem from a recon problem from a merchandising problem. So each month the fix was applied to whichever explanation was most recently persuasive.

What we built

A unit-level inventory dashboard joining the DMS, the inventory management tool, auction records, and internal recon repair orders, with a small process change in the shop to capture stage timestamps that did not previously exist.

Clock

True days in inventory

Age from acquisition rather than stock-in. The gap averaged six days, all of it depreciation that had never been attributed to anything.

Cost

Landed cost by source

Hammer price plus fees plus transport plus reconditioning, charged back to the channel and the buyer. Two channels that looked comparable on purchase price were not comparable at all once recon was attached.

Recon

Staged cycle time

Arrival to inspection, inspection to approval, approval to start, parts wait, work to completion, completion to photographs. Shown as a distribution, because the average was hiding the tail that mattered.

Market

Cost-to-market over time

Investment against a moving market value, so repricing decisions were made against where the unit sits today rather than against what it cost.

Merch

Merchandising readiness

Days from lot-ready to fully live: photographed, described, and syndicated everywhere. A ready unit nobody can see ages exactly like an unready one.

Action

Daily action list

Units crossing an age threshold, stalled in a stage, ready but unmerchandised, or overdue a price change against policy. One list, owned by one person, refreshed every morning.

Learning

Wholesale post-mortem

Every wholesaled unit traced back to its acquisition and recon history, turning a write-off into a data point about buying.

Discipline

Price change adherence

Whether markdowns were actually happening at the intervals the pricing policy claimed. Frequently they were not, and nobody had a way to see it.

The stage capture problem, honestly

The recon stage report is the most valuable thing on this dashboard and the only part that required the store to change how it works. The timestamps did not exist in any system; capturing them meant a technician and a porter each marking two additional touchpoints.

We raised this as a go or no-go during scoping rather than building the report and hoping the data would appear. A store unwilling to make that change should not pay for reporting that depends on it, and we would rather lose that piece of scope than deliver a stage report quietly padded with estimates.

What the dashboard does not compute. It will not tell you what a unit would have sold for had it been ready a week earlier. That number requires assumptions we would be inventing, and a figure like that gets quoted in meetings long after the caveat is forgotten.

Build sequence

Phase Work
Weeks 1–2 Assessment, metric definitions, and the stage capture decision with the used vehicle manager and service director.
Weeks 2–5 Extracts from DMS, inventory management, and auction records. Landed cost and true days in inventory live.
Weeks 4–7 Stage capture in the shop, recon cycle reporting, and merchandising readiness.
Weeks 7–8 Daily action list, source and buyer scorecards, wholesale post-mortem, and the morning review it feeds.

Outcomes

About this page. This describes a real build and the decisions behind it. Your sources, your constraint, and your timeline will differ — we are describing an approach, not quoting a project.

Frequently Asked Questions

How much shop process change does the stage capture require?

Two additional touchpoints, marked by people already handling the vehicle — typically a few seconds each. It is small, but it is not zero, and it only works if the service director is behind it. We treat it as a decision to make rather than a detail to mention after signing.

Can this run without changing anything in the shop?

Yes, with less. Landed cost, true days in inventory, cost-to-market, merchandising readiness, price adherence, and the wholesale post-mortem all come from data that already exists. Only the staged recon breakdown needs new capture, and it can be added later.

We move units between rooftops. Does age follow the vehicle?

Yes, and this matters more than it sounds. Transfers preserve the acquisition date and the full history, so a unit does not become fresh by moving. Groups whose aging report resets on transfer are usually carrying more old inventory than they think.

Does this replace our inventory management tool?

No. We read from it. It stays the pricing and market-position tool; what we add is the join to DMS cost detail, internal recon orders, and auction records that no inventory tool has access to.

Which problem is your aging actually?

Buying, recon, or merchandising. Send us ninety days of stock and recon data and we will show you the split.

Schedule a Consultation