Vehicles Due for Replacement by Year

Vehicles Due for Replacement by Year

For an explanation of how points are calculated for the Fleet360 Vehicles Due for Replacement by Year, please see the Fleet360 Replacement Scoring guide

Summary/Use Case

Report Summary

The Vehicles Due for Replacement by Year report provides a detailed list of vehicles that are scheduled for replacement based on criteria such as age, usage, and replacement points. This report is valuable for fleet managers to strategically plan and budget for upcoming vehicle replacements and ensure operational efficiency. It is generally used by departments responsible for capital planning.

Use Case

  • Helps plan and prioritize fleet replacements by year

  • Supports budgeting efforts by providing estimated replacement costs

  • Allows filtering by customer, department, facility, or replacement year

  • Highlights vehicles that have met or exceeded replacement criteria

Location: Where to Find It

Reports > RTA Standard Reports > Vehicle > Vehicles Due for Replacement by Year

image-20250421-205841.png

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

Parameter List

image-20250421-210922.png

Parameter Name

Value (Default)

Value (Notes)

Parameter Name

Value (Default)

Value (Notes)

Please select Customer or Department for grouping (None to skip grouping)

Customer

This parameter will set a primary grouping and sort underneath Facility. Choosing ‘None’ will default to a Class grouping and sort (if marked ‘True’).

Include Class grouping and totals?

False

Selecting ‘True’ will add a grouping for Class. False will default to a normal sort of vehicle number.

Inflation (Will apply only if Class and Vehicle Inflation values are 0 or null)

0.03

Applied only when Class and Vehicle Inflation fields are null

Data Filter List

image-20250421-210942.png

Filter Name

Recommended Filter Condition(s)

Value (Options)

Value (Default)

Value (Notes)

Filter Name

Recommended Filter Condition(s)

Value (Options)

Value (Default)

Value (Notes)

Facility

Equal To

1

1

Displays a single facility

Customer Number

Is Between

Any Customer Number Range

blank - “zzzzzzzzzzzzzzzz”

Filters by customer number range

Department Number

Is Between

Any Department Number Range

blank - “zzzzzzzzzzzzzzzz”

Filters by department number range

Replacement Years (Enter 4-digit year; 0 includes all years)

Greater Than Or Equal To

Any 4-digit year

0

This selects the year range for identify vehicles due for replacement. Note: selecting the current year will filter out any vehicles that are overdue for replacements

Total Points

Is Between

1 to 25

1 to 25

Points are a scoring mechanism used to determine replacement readiness. See Replacement Scoring for more information scoring.

Report Output and Data Elements

Report Output

The Vehicles Due for Replacement by Year report generates a list of vehicles that meet or exceed the replacement threshold based on the selected filters. The output includes vehicle details, grouping by department and customer (if selected), and subtotal and total summaries. Totals include Department Totals and Year Totals for estimated replacement cost and vehicle count.

image-20250421-211001.png

Report Data Elements

Column Number

Column Title

Data Notes

Column Number

Column Title

Data Notes

1

Vehicle

Vehicle ID and associated department/customer group

2

Year

Year of manufacture

3

Make

Manufacturer of the vehicle

4

Model

Specific model name

5

Class

Vehicle classification

6

Customer

Associated customer code

7

Department

Department number using the vehicle

8

Life Meter

Usage meter (e.g., miles or hours)

9

Exp Repl Year

Expected replacement year

10

Life (Years)

Expected lifespan of the vehicle in years

11

Acq Cost

Original acquisition cost of the vehicle

12

Inflation

Inflation factor applied to cost

13

Total Points

Replacement readiness score based on various criteria

14

Estimated Replacement Cost

Projected replacement cost including inflation adjustments

Report Summary

The final section of the Vehicles Due for Replacement by Year report provides a consolidated view of the report. This page gives a snapshot at the projected financial impact and the count of vehicles planned for replacement across the next 10 years. This snapshot enables long-term planning by clearly identifying peak replacement years—such as 2032 and 2033—and helps prioritize budgeting and procurement cycles accordingly.

image-20250421-212227.png