Replacement Scoring Report (SQL Only)

(SQL System Only)

This Report will give information based off the APWA standard of 5 categories which include: 

• Projected age “life expectancy” 
• Condition 
• Projected meter “life expectancy” 
• Maintenance costs compared to purchase price of vehicle 

• Service count per year (either line or work order count) 

This new feature can be set up under the Vehicle Class Replacement tab located in the Class Codes. A vehicle condition field has been added so that mechanics closing the work on a vehicle can update its condition. This can be done through paperless shop or on the Master > Vehicle > File Maintenance screen. 

This report uses the AWPA Standards to score, each category can reach up to 5 points, 5 being the highest. The higher your number reaches, the more likely the vehicle needs to be replaced.  

How is it scored? 

Age (This takes a percentage between the projected life and the current age of the vehicle. The closer the vehicle’s current age to the projected life the higher the replacement number) This is based off the class and what you enter for the projected life of a vehicle.  

A car with 8 years projected life with only 1 year on it would score a 1 

A car with 8 years projected life with 7-8 years on it would score a 5 

Mileage/Kilometers/Hours (Other levels increment by 20% intervals) 

Km/Mi/Hrs. are less than 20% of the vehicle 1 

Km/Mi/Hrs. are greater than 81% of vehicle and equipment guideline5 

Lifecycle Operating & Maintenance Costs (Other levels increment by 20% intervals) 

Lifecycle O & M costs are less than 20% of the original purchase cost 1 

Lifecycle O & M costs are greater than 81% of the original purchase cost 5 

Vehicle WO History (This takes 1/5th of the number you enter for each level) 

Less than 5 WO Line/ WO Count per year1 

More than 20 WO line/WO count per year5 

Mechanical/ Body Assessment (Based off the condition assigned) 

No visual damage or rust good drivetrain and engine1 

Previous accident damage, poor body condition, bad interior, etc.5 

Setting up the Replacement Scoring Report 

1. Select Master > Vehicle > Class Codes 

1. Select your Class Code 

1. Select the Vehicle Class Replacement Tab 

1. Enter your estimated years, meter, resale value, and service requests min and max 

1. Choose whether you would like to go off total WO line count or total WO count 

Running the Replacement Scoring Report 

1. Select Reports > Total Vehicle Cost > Replacement Scoring 

1. Choose your Facility 

1. Choose between Department, Vehicle, or Class 

1. Enter your range 

1. Click OK