Replacement Plan Dashboard
Currently, replacement in reporting displays the first round of replacements. In order to properly budget and plan for future replacements we’ve added the second, third, fourth+ replacements rounds to the Replacement Plan Dashboard.
The dashboard displays the 20-year replacement plans based on the specified replacement parameters. It will also display the class codes and assets that are missing replacement parameters to help fleets understand whether the replacement plan can be relied on or if it is missing needed data.
The tables below will break down the descriptions and definitions found in the dashboard.
Accessing the Replacement Plan Dashboard
From the Fleet360 Navigation menu, expand the Home area
Expand the Analytics section
Click on Dashboard
From the dropdown in the upper right, click on Replacement Plan Dashboard
Definitions
Terms | Definition |
Benchmark Replacement Plan | This is the 20 year replacement plan based on the asset’s projected life and/or projected life meter. An asset is replaced either based on its age or primary meter depending on which occurs first. The replacement by primary meter is based on its average annual primary meter and the projected life meter. |
Overdue Assets | These assets are past due for replacement. i.e. They should have been replaced before now based on either their projected life or projected life meter. |
Replacement Cost | Purchase Price + Upfitting Costs inflated using the inflation rate assigned. If there is no inflation rate, then the total replacement cost is not inflated. This assumes that the purchase price and upfitting costs are in today’s dollars, so year 1 will not be inflated. |
Dashboard Widget Explanations
In this sheet you can filter by Zone, Region, Facility Number, Facility Abbreviation, Class Code, Department Number and Customer Number. All widgets in this sheet have a table that shows the data used in the calculation.
For example, the table for the Active Class Code widget lists the facility number, active class codes, class description and active asset count. For all widgets’ table the class code and vehicle number can be clicked on and in a new tab the user will be directed to either the class code or vehicle in Fleet360. This will allow the user to easily fix any missing data.
Name | Type | Description | Conditional Formatting |
Percent of Assets in Replacement Plan | KPI | Percentage of Active Assets that have either a projected life or projected life meter. | Green >= 97.25% Yellow >= 75% Red >= 25% Dark Red <25% |
Percent of Class Codes in Replacement Plan | KPI | Percentage of Active Class Codes that have either a projected life or projected life meter. | Green >= 97.25% Yellow >= 75% Red >= 25% Dark Red <25% |
20 Year Replacement Plan: Asset Count by Replacement Round | Bar Chart | 20 Year Replacement Benchmark Replacement Plan Asset Count with each replacement round (up to 10 rounds) labeled by color |
|
20 Year Replacement Plan: Asset Cost by Replacement Round | Bar Chart | 20 Year Replacement Benchmark Replacement Plan Asset Cost with each replacement round (up to 10 rounds) labeled by color |
|
‘2025’ Ontime vs Overdue Replacement Count | Pie Chart | Number of assets that will be replaced in ‘2025’ according to the plan that are overdue compared to those that are being replaced on time | Red = Overdue Blue = Green |
‘2025’ Ontime vs Overdue Replacement Cost | Pie Chart | Cost of assets that will be replaced in ‘2025’ according to the plan that are overdue compared to those that are being replaced on time | Red = Overdue Blue = Green |
Assets Replacement Cycle: Age vs Meter | Pie Chart | Count of assets that are replaced by its projected life or projected life meter. |
|
Years Past Replacement for Overdue Assets | Pie Chart | Count of overdue assets that are overdue by
| Green: 1 Year Yellow: 2 Years Red: 3+ Years |
Active Class Codes | KPI | Count of Active Class Codes | N/A |
Class Codes in Replacement Plan | KPI | Count of Active Class Codes that are in the replacement plan | N/A |
Class Codes Missing Replacement Cycles | KPI | Percent of active class codes that do not have either a projected life cycle or projected life meter | Dark Red >=75% Red >= 25% Yellow >= 2.5% Green < 2.5% |
Class Codes Missing Replacement Costs | KPI | Percent of active class codes that do not have a replacement cost | Dark Red >=75% Red >= 25% Yellow >= 2.5% Green < 2.5% |
Class Codes Missing Inflation Rate | KPI | Percent of active class codes that do not have an annual inflation rate | Dark Red >=75% Red >= 25% Yellow >= 2.5% Green < 2.5% |
Active Assets | KPI | Count of Active Assets | N/A |
Assets in Replacement Plan | KPI | Count of Active Assets that are in the replacement plan | N/A |
Assets Missing Replacement Cycles | KPI | Percent of active assets that do not have either a projected life cycle or projected life meter | Dark Red >=75% Red >= 25% Yellow >= 2.5% Green < 2.5% |
Assets Missing Replacement Costs | KPI | Percent of active assets that do not have a replacement cost | Dark Red >=75% Red >= 25% Yellow >= 2.5% Green < 2.5% |
Assets Missing Inflation Rate | KPI | Percent of active assets that do not have an annual inflation rate | Dark Red >=75% Red >= 25% Yellow >= 2.5% Green < 2.5% |
Assets Missing Model Year or Inservice Date | KPI | Percent of active assets that do not have a model year or Inservice date. This prevents the asset from being in the replacement plan since their replacement cannot be estimated due to not having the metrics required to calculate age or annual primary meters. | Dark Red >=75% Red >= 25% Yellow >= 2.5% Green < 2.5% |
Assets Missing Primary Meter Reading | KPI | Percent of active assets that have a primary meter (not none) but no meter reading | Dark Red >=75% Red >= 25% Yellow >= 2.5% Green < 2.5% |
Assets Missing Original Purchase Price | KPI | Percent of active assets that do not have a purchase price in the asset file | Dark Red >=75% Red >= 25% Yellow >= 2.5% Green < 2.5% |