Cover Picture

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

  1. From the Fleet360 Navigation menu, expand the Home area

  2. Expand the Analytics section

  3. Click on Dashboard

  4. 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

  • 1 year

  • 2 years

  • 3+ years

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%