Vehicle replacement scoring worksheet

Score a unit on age, usage, service severity, reliability, repair cost and condition to produce a defensible replacement priority — the model most public fleets use to rank a replacement list.

The method behind this is explained in Building a replacement scoring model .

Everything runs in your browser. Nothing you type is sent anywhere, stored, or logged.

Age & usage

Age (years in service) 1 point per year.

Odometer (miles) or hour meter

Usage measured in

Service severity

Type of service

Reliability

Unscheduled in-shop events in the last 12 months

Repair cost

Lifetime maintenance & repair to date ($) Excluding accident damage and scheduled PM consumables.

Current replacement cost ($)

Scored as a percentage of replacement cost: under 20% = 1 point, 20–39% = 2, 40–59% = 3, 60–79% = 4, 80%+ = 5.

Condition

Overall physical condition

Replacement score

—

Age	—
Usage	—
Service severity	—
Reliability	—
Repair cost	—
Condition	—
Total	—

Sources

APWA — Certified Public Fleet Professional program Primary — the point-factor approach is taught in the public fleet curriculum
South Florida Water Management District — Fleet replacement lifecycle analysis (PDF) Primary — a published public-agency lifecycle study
Automotive Fleet — How to calculate optimal replacement cycles — trade press