What it is
The Vehicle Replacement & Lifecycle Planner is a spreadsheet that scores every unit in a fleet for replacement and recommends keep, monitor or replace for each one. You enter the roster once — model year, current odometer, age in years, last-12-month maintenance spend and estimated resale value — and the workbook computes a weighted 0–100 replacement score per vehicle, flags the units that have passed their economic life, sizes the replacement capital budget by year, and rolls the whole picture up into a fleet-renewal dashboard. It replaces gut feel about which trucks are 'getting old' with a defensible score.
The score is a weighted blend of three normalized signals: age against your age limit, mileage against your mileage limit, and the maintenance-to-resale ratio against your ratio limit. Age and mileage are weighted 30% each and the maintenance-to-resale ratio 40%, on the logic that what a vehicle costs to keep relative to what it's worth is the strongest replacement signal. The default 0.5 ratio limit applies the classic rule: replace when a year of maintenance approaches half the vehicle's remaining resale value.
Beyond scoring, the planner is a capital-planning tool. The budget sheet phases renewals across years so capital outlay is smoothed rather than spiking, computing annual and cumulative capital from the number of units and average replacement price per year. The dashboard quantifies the renewal rate, so you can tell whether you're running an aging fleet that needs phased investment or a young one with room to extend.
What it's used for
Fleets use this planner to time replacements on economics instead of breakdowns, and to turn a vague sense that 'the fleet is getting old' into a scored, budgeted renewal plan. It is the strategic counterpart to day-to-day maintenance — deciding which assets to keep alive and which to retire.
- ✓ Scoring every unit for replacement on a consistent 0–100 scale that blends age, mileage and maintenance-to-resale ratio.
- ✓ Identifying which vehicles have passed their economic life and belong in the renewal queue.
- ✓ Applying the classic replacement rule — retire when annual maintenance approaches half of remaining resale value.
- ✓ Phasing replacement capital across years so a single year's outlay doesn't spike uncomfortably.
- ✓ Sizing the total fleet-renewal capital requirement as the headline figure for a business case.
- ✓ Measuring the fleet's replacement rate to judge whether it is aging too fast or can be extended.
- ✓ Prioritizing a renewal queue by sorting units on replacement score, with 'monitor' units flagged for the next quarter.
Who uses it
Replacement planning sits where operations meets capital budgeting, so it is used by fleet leadership and finance together. The transparent scoring makes the recommendations defensible to the people who approve the spend.
Context & good to know
Every vehicle has an economic life — the point where the rising cost of keeping it (maintenance, downtime, fuel, falling resale) overtakes the cost of replacing it. Get the timing wrong in either direction and it's expensive: replace too early and you waste capital on units that still had value; too late and repair, downtime and reliability costs eat the saving while resale value keeps falling. The planner exists to find that crossover point with a number instead of a hunch, which is why the maintenance-to-resale ratio carries the heaviest weight in the score.
Common US light/medium-duty reference points put replacement around 8–10 years or 120,000–150,000 miles, but those are starting points to tune for your duty cycle, not rules. A severe-duty urban stop-start fleet wears out faster than a light-highway one, so the planner lets you set your own age, mileage and ratio thresholds. Fleet platforms like Fleetio and Geotab increasingly surface lifecycle and replacement analytics from accumulated cost and telematics data, and this workbook gives a buyer the underlying model — useful both standalone and as a way to understand what those analytics compute.
Replacement planning is fundamentally a capital-smoothing exercise as much as a per-vehicle decision. If a fleet was bought in a cluster, it ages in a cluster, and a naive replacement policy creates a capital spike when they all hit end-of-life together. The budget sheet exists to push lower-score 'monitor' units into later years and flatten that curve, turning a lumpy, unpredictable capital demand into a phased plan that finance can fund.
The dashboard's replacement-rate signal is a strategic gauge. A renewal rate above roughly 30% in a single cycle indicates an aging fleet with concentrated future repair and downtime risk that should be phased over the budget years; below about 15% suggests a young fleet where you can safely extend holding periods and defer capital. Reading that rate tells a fleet manager whether the immediate problem is too much aging at once or an opportunity to keep assets longer.