Calculate asset KPIs

Completed

You can calculate numerous Key Performance Indicators (KPIs) for assets and asset types. You use KPIs to get an overview of performance on assets in relation to, for example, uptime, downtime, repair time, and Mean Time Between Failure (MTBF).

  1. Select Asset management > Inquiries > Assets > Asset KPIs.
  2. In the Calculate asset KPIs dialog box, select the Time scale to be used in the calculation.
  3. Select the period in the From date and To date fields.
  4. On the Records to include FastTab, you can select specific assets and asset types to be included in the calculation, if necessary.
  5. Select OK to start the calculation.
  6. On the Overview FastTab, the results of the calculation are displayed in grid view. Each asset is displayed on a separate line.
  7. On the KPIs for selected line FastTab, calculations for the asset are selected on the Overview FastTab. The KPI values are categorized regarding Time, Availability, Work orders, Maintenance, Faults, Maintenance downtime, and Cost.

Screenshot of Asset KPIs page.

Here's an overview of the fields you find in the Calculate asset KPIs dialog box.

Field Description
Asset The Asset ID.
Total time Total time is set up in the calendar that is used in the calculation. If the asset is related to a resource, a related resource calendar is used. If the asset isn't related to a resource, then the calendar that is selected in the Standard calendar field, found in Asset Management parameters page, is used.
Uptime Total time with the downtime subtracted.
Downtime Maintenance downtime registrations that are made on the asset in the defined period.
Repair time Total number of work hours that are consumed on repair work orders.
Availability % Uptime divided by the total time and then multiplied by 100.
Number of faults Number of fault causes that are registered on fault symptoms on an asset in a defined period.
MTBF Mean Time Between Failure is the total time divided by the number of faults that are registered on the asset in a defined period of time. If the number of faults is set to zero, then MRT is set to repair time.
Fail rate 1 divided by the Mean Time Between Failure (MTBF).
MRT Mean Repair Time is the repair time divided by the number of faults that are registered on the asset during a defined period. If the number of faults is zero, then the MRT is set to repair time.
Number of stops Number of maintenance downtime registrations that are created on an asset.
MTBS Mean Time Between Stops is the total time divided by the number of maintenance downtime registrations. If the number of maintenance downtime registrations is zero, then the value is set to the total time.
Preventive cost The costs that are posted on the asset that is related to Preventive work order types in the defined period.
Corrective cost The costs that are posted on the asset that is related to Corrective work order types in the defined period.
Replacement value The defined value on an asset if replacement is needed.
Asset type The Identification of the asset type that is selected with the asset.
Manufacturer The identification of the manufacturer that is selected on the asset.
Model The identification of the manufacturer model that is selected on the asset.
From date Start date of the KPI calculation. If the asset was created after the start date that was selected for the calculation, the start date of the asset is shown in this field
To date End date of the KPI calculation. If the asset was registered as inactive before the end date that was selected for the calculation, the date from which the asset was no longer active is shown in this field.
Time scale During calculation of KPIs, you select a time scale to be used: Hours, Days, or Weeks.
Availability Uptime divided by total time.
Work orders Total number of work orders that are included in KPI calculation.
Work order time Total number of work hours that are consumed on the work orders.
Primary work orders The number of primary work orders that are included in KPI calculation.
Secondary work orders The number of secondary work orders that are included in KPI calculation.
Maintenance work orders Number of maintenance work orders that are included in KPI calculation. A maintenance work order is a work order with no related fault causes
Maintenance time Total number of work hours that are consumed on maintenance work orders
Repair work orders Number of repair work orders that are included in KPI calculation. A repair work order is a work order with a related fault cause.
Reliability % A calculation based on the expected exponential development in fault registrations on an asset; meaning that, over time, the asset becomes less reliable due to wear and tear. The calculation of this KPI is based on MTBF and total time.
MTPS Mean Time Production Stops, which is maintenance downtime divided by number of maintenance downtime registrations. If the number of maintenance downtime registrations is zero in the selected period, the MTPS value is set to zero
Total cost Total costs that are posted on the asset in the selected period.
Investment cost Costs that are posted on the asset that is related to the cost type of Investment in the defined period.

Consider the following factors when calculating asset KPIs:

  • Select multiple assets in All assets and then select the Asset KPIs button on the General tab. Then, select OK in the Calculate asset KPIs dialog box to calculate KPIs for your selected assets.

  • The results from a KPI calculation might or might not include maintenance downtime registrations, depending on the setup and use of maintenance downtime reason codes.