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
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
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
Filter Name | Recommended Filter Condition(s) | Value (Options) | Value (Default) | Value (Notes) |
|---|---|---|---|---|
Facility | Equal To | 1-99999 | 1 | Allows filtering by specific facility ID |
Department Number | Is Between | " " to "zzzzzzzzzz" | " " to "zzzzzzzzzz" | The range represents all possible department numbers |
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
Report Data Elements
Column Number | Column Title | Data Notes |
|---|---|---|
1 | Life Meter | The current lifecycle stage of the vehicle |
2 | Exp Repl Year | The expected replacement year for the vehicle |
3 | Life (Years) | Total lifecycle duration in years |
4 | Acquisition $ | Breakdown of costs associated with acquiring the vehicle, including purchase, uplift, and total costs |
5 | Fiscal Year (2024-2029) | Projected costs for each fiscal year across multiple columns |