Replacement Scoring
- Andrew Finch
- Merlin Villela
For an explanation of how points are calculated for the Fleet360 Replacement Scoring Report, please see the Points Breakdown section below
Summary/Use Case
Report Summary
The Replacement Scoring report provides a detailed breakdown of vehicle replacement scoring across a fleet. The report includes key replacement related data such as points, year, life meter, purchase price, maintenance cost, and condition, organized by facility and vehicle. Fleet managers can use this report to assess the replacement needs and overall condition of vehicles, enabling informed decision-making on vehicle replacements.
Use Case
Identify vehicles that need replacement based on scoring and condition thresholds
Prioritize vehicle replacements to optimize maintenance costs and reduce downtime
Monitor high-maintenance vehicles for budgeting and cost management
Support lifecycle management decisions by assessing vehicle age and usage metrics
Plan for long-term fleet replacement and budget allocation
Location: Where to Find It
Reports > RTA Standard Reports > Vehicle > Replacement Scoring
Data Filter Prompts
You will be prompted for filtering of the Data to specify and narrow down the data that will be pulled. See Data Filter List Below for Options.
Data Filter List
Filter Name | Recommended Filter Condition(s) | Value (Options) | Value (Default) |
|---|---|---|---|
Facility | Equal To | 1 - 99999 | 1 |
Vehicle | Is Between | blank - zzzzzzzz | blank - zzzzzzzz |
Report Output and Data Elements
The Replacement Scoring Report provides a visual and tabular breakdown of vehicle conditions, categorized from "Excellent" to "Needs Replacement" based on the scoring metrics. This report allows users to view the vehicle details and replacement prioritization across the fleet at a glance. Key highlights include categorization by vehicle condition, point scoring, and life meter values. See below for explanation of points calculations.
Report Output
Report Data Elements
Column Number | Column Title | Data Notes |
|---|---|---|
1 | Vehicle | Identifier for each vehicle within the fleet |
2 | Points | Replacement score based on the vehicle's age, usage, and condition metrics |
3 | Year | Model year of the vehicle |
4 | Life Meter | Usage metric, such as mileage or hours |
5 | Purchase Price | Original purchase price of the vehicle |
6 | Maintenance Cost | Total cost of maintenance over the vehicle's lifetime |
7 | Repairs | Total number of repairs conducted on the vehicle since the start of the previous year |
8 | Condition | Overall condition classification on a scale of 0 - 5 |
Points Breakdown
Points
Points for Age, Mileage, Maintenance, and Service Counts are determined when they fall within the following percentages:
<20% = 1 point
20% to 39% = 2 points
40% to 59% = 3 points
60% to 79% = 4 points
>79% = 5 points
Age Projection
Age Projection is the percentage of the vehicles current age divided by the Estimated Years. The Estimated Years is what you entered in the Class Code that the vehicle is assigned. The closer the vehicle’s current age is to the projected life, the higher the replacement number.
(Current Year - Vehicle Year) / (Estimated Life)
Example: The year is 2018, so a 2015 Vehicle is 3 years old (2018 – 2015 = 3). The class code’s Estimated Life is 10 years,
3 ÷ 10 = .30 or 30%. 30% is equal to 2 points.
Meter Projection
(Mileage/Kilometers/Hour will be referred to as Units in this example).
The Units Projection is the percentage of the vehicle’s current Life Units divided by the Estimated Primary Units. The Estimated Primary Units is what you entered in the Class Code that the vehicle is assigned. The closer the vehicles current life units are to the Estimated Primary Units, the higher the replacement number.
(Units) / (Projected Replacement Units)
Example: The vehicle’s life meter is 58,000 and the Estimated Primary Units is 150,000.
58,000 ÷ 150,000 = .387 or 38.7%. 38.7% is equal to 2 points.
Maintenance Costs Comparison
The Maintenance Cost Comparison is the vehicle’s work order costs (from Open AND Closed work orders) from the following categories:
Inside parts, labor, and tires
Outside parts, labor, and tires
Miscellaneous work order costs
(Total Maintenance Costs) / (Vehicle Purchase Price)
Example: The vehicles maintenance cost is $6,359.00 and the purchase price was $52,000.00.
6,359.00 ÷ 52,000.00 = .122 or 12.2%. 12.2% is equal to 1 point.
Service Count Per Year
Is a calculation of: Subtract the number of WO’s (or WO lines) from the Min Service Count. Divide this by the sum of the Min and Max Service Count (that you entered in the Class file), to get the percentage. The WO’s (or WO lines) number used in the calculation is the count of WO’s (or WO lines) since the first day of the previous year. Both WO and WO lines are calculated from Closed work orders.
Example: In Class File > Replacement > Replacement Info, the Minimum Service Count is 1, the Maximum Service Count is 10, and the Vehicle’s WO count since the first day of the previous year is 4 WO’s.
(# of WOs) 4 – (Min Cnt) 1 = 3
(Max Cnt) 10 - (Min Cnt) 1 = 9,
3 ÷ 9 = .33 or 33%
33% = 2 points.
Condition
Mechanical/Body Assessment is based on the condition you assess the vehicle to be (Enter 1 through 5).
For the condition you’ll want to consider inspections of the body condition, rust, interior condition, accident history, and future repairs. Lower numbers would indicate a good condition and high numbers would indicate a poor condition.
1 = Excellent condition - Interior and exterior no signs of wear, mechanically sound
2 = Vehicle better than average - Minimal wear inside and out, minor scratches dents, mechanically sound
3 = Average or normal wear and tear, with light cosmetic damage, mechanically sound)
4 = Excessive Wear and Tear - Dents & scratches, body damage, interior wear, engine or transmission not mechanically sound
5 = Severe Wear and Tear - May have collision damage, signs of severe abuse, engine or transmission in poor condition, although unit may be operable it’s near the end of its useful life)