Fleet Replacement by Year

Summary/Use Case

Report Summary

The Fleet Replacement by Year report provides insights into the acquisition costs and replacement planning for fleet vehicles by facility and department. Fleet managers can use this report to budget for upcoming vehicle replacements and understand the total costs associated with fleet maintenance and lifecycle management.

Use Case

  • Plan vehicle replacement schedules by assessing current vehicle lifecycle and costs.

  • Budget for upcoming fiscal years by forecasting replacement and acquisition costs.

  • Evaluate facility- and department-specific vehicle expenses to optimize resource allocation.

  • Analyze fleet age and condition to improve operational efficiency.

  • Justify budget needs for vehicle replacement to stakeholders.

Location: Where to Find It

Reports > RTA Standard Reports > Vehicle > Fleet Replacement by Year

image-20241107-200141.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-20241107-200210.png

Parameter Name

Value (Default)

Value (Notes)

Interest Rate

0.08

Default rate applied for calculations

Inflation

0.06

Default rate applied for future cost estimates

Data Filter List

image-20241107-200233.png

Filter Name

Recommended Filter Condition(s)

Value (Options)

Value (Default)

Facility

Equal To

1 - 99999

1

Department Number

Is Between

blank - zzzzzzzzzz

blank - zzzzzzzzzz

Report Output and Data Elements

The Fleet Replacement by Year report provides a comprehensive view grouped by Department. It includes data such as acquisition costs, replacement years, and lifecycle details for each vehicle. Totals are presented at the bottom, including the count of vehicles due for replacement and department-specific cost total projections.

Report Output

image-20241107-200303.png

Report Data Elements

Column Number

Column Title

Data Notes

1

Life Meter

Current meter reading for vehicle life assessment

2

Exp Rep Year

Expected replacement year for the vehicle

3

Life (Years)

Total expected lifespan of the vehicle in years

4

Acquisition $ Purchase

Purchase cost of the vehicle

5

Acquisition $ Upfit

Upfit cost for additional equipment or modifications

6

Acquisition $ Total

Total acquisition cost, combining purchase and upfit expenses

7-12

Calendar Year (Current to 5 Years)

Projected expenses per year, detailing payment, fuel, and maintenance costs