How to Track Used Car Reconditioning Days to Frontline in Excel
The recon report says finished cars reached the front line faster this week. Seven cars are still at the same stage, and none of them count in that completed average. The used-car manager needs to know which vehicles can realistically make Saturday’s lineup.
Report completed days to frontline and current stage aging side by side. For every open vehicle, retain the stage-entry time, hold reason, next owner and target frontline date.
The completed average improved while work piled up
This dealership counts elapsed calendar days and reviews its open vehicle list Thursday morning.
| Measure or stock number | This week | Decision |
|---|---|---|
| Completed vehicles | 12 at 3.6 days average | Compare with last week’s 4.2 days |
| Open vehicles in Parts Hold | 7 | Check ETA and next owner |
| U-4817 | 6 days in Parts Hold | Call for a confirmed ETA |
| U-4822 | 5 days in Parts Hold | Confirm whether repair can be resequenced |
The average tells you what happened to the 12 vehicles already out of recon. Parts Hold deserves the first look before the weekend plan is set.
Build the aging view from the stage history
Export the vehicle list, recon stage history, and parts or sublet tracker. Use the dealership’s stock record or verified VIN mapping. For each open vehicle, find the latest valid entry into its current stage. Preserve reopened and repeated stages if you also report cumulative time spent.
Agree on the clock and show unknowns
Define when frontline timing starts, and use calendar or business days consistently. A missing stage-entry timestamp belongs in a review list. Add owner, hold reason, and a confirmed ETA where available.
Bring a short exception list to the morning meeting
Put the weekly completed view and open vehicle list in the same workbook. Add target frontline date so age can be read alongside the upcoming sales need.
Which open stock numbers are past our stage-age target or risk missing frontline? Show current stage, time in stage, hold reason, next owner and source rows.
Call on the oldest blocking items first and compare the same stock numbers the next morning.
NADA reconditioning stages · vAuto recon strategy
The figures and identifiers in this example are synthetic. The displayed arithmetic was checked independently. A live Jolene.pro result could not be verified.
Try this with your own spreadsheet at Jolene.pro. Follow Jolene.pro on LinkedIn for more spreadsheet guides.
For more checked examples, see Jolene.pro Workbook Studies.