ILHAM NT
WORK ORDER
ANALYTICS
FOR WEEKLY KPI
By: ILHAM TRILAKSONO
Background
Addressing Mr. Febri (from PEPC) question from my
previous post. I believe this is important to convey.
01
To understand the importance of work
order analytics for maintenance.
WORK ORDER
02
ANALYTICS
To introduce key weekly KPIs for
maintenance
OBJECTIVE To demonstrate how to analyze work
03 order data to measure maintenance
performance
04 To provide insights on using work order
analytics to improve maintenance
WORK ORDER
A maintenance work order is a formal request for maintenance or repair tasks,
ensuring that facilities and equipment are running efficiently and safely.
DATA ANALYTICS
Data analytics is the process of examining and analyzing raw data to extract
valuable insights and information. It involves a combination of tools,
techniques, and methodologies to uncover trends, patterns, and relationships
within data sets.
WHY DATA ANALYTICS?
Data analytics derived from work order information enables us to
make better and more informed decisions to maintain asset
reliability in the future.
01 02 03
Work Order (WO) history can Identifying whether maintenance Analyze MTBF(if needed),
assist in accurate maintenance work is effective and efficient, and Backlogs, Schedule Compliance
planning, faster failure detection, detecting which assets are for weekly KPI to improve job
and more mature follow-up consuming high costs to minimize package planning process
action formulation. expenses.
DETERMINE WO DATA
REQUIREMENT
USE SMRP BEST PRACTICE
TO DETERMINE KPI!!
Define Organization Define KPI’s, Transform data Communicate to all
Vision, mission, required data and requirement on WO stakeholder t
Objective, and target Methods to Form complete required
Measure data on WO
DATA ANALYTICS
PROCESS
WO EXAMPLE
Data input from Workorder
DATA ANALYTICS TYPE
Example :
Descriptive
WO Ratio (maintenance Mix)
Diagnostics
MTBF, Failure Mode Analysis
Predictive
Historical data analytics for filter replacement,
Analiyze Asset Availability using Machine learning
Prespective
Advanced Asset Availability Analysis using
Machine learning,
Simulation, etc
WEEKLY KPI
CREW CAPACITY 630 Manhours
1. Planned WO Executed by Counting
PLANNED WORK EXECUTED
Count of WONUM Column Labels
Row Labels EXECUTED NOT EXECUTED Grand Total
PLANNED 96.20% 2.17% 98.37%
UNPLANNED 1.63% 0.00% 1.63%
Grand Total 97.83% 2.17% 100.00%
2. Unplanned WO Executed by Labor Hour(manhours)
UNPLANNED WORK EXECUTED
Sum of ACTLABHRS Column Labels
Row Labels EXECUTED NOT EXECUTED Grand Total
PLANNED 73.06% 0.91% 73.97%
UNPLANNED 26.03% 0.00% 26.03%
Grand Total 99.09% 0.91% 100.00%
Note : Please read the SMRP Best Practice book for a deeper
understanding.
WEEKLY KPI
3. Schedule Compliance (Count Based)
Row Labels Count of WONUM
EXECUTED 97.83%
NOT EXECUTED 2.17%
Grand Total 100.00%
COMPLIANCE 97.83%
This metric is a measure of adherence to the weekly maintenance work schedule, expressed as
a percent of total number of scheduled work orders
4. Schedule Compliance (Manhour Based)
Row Labels Sum of ACTLABHRS
EXECUTED 327.4166667
NOT EXECUTED 3
Grand Total 330.4166667
COMPLIANCE 52.45%
This metric is a measure of adherence to the maintenance schedule, expressed as a percent of total time
available to schedule.
Note : Please read the SMRP Best Practice book for a deeper
understanding.
WEEKLY KPI
5. Backlog Analysis
PLANNED BACKLOG 52.45%
Planned Backlog is the combination of the quantity of work that has been fully planned for
READY BACKLOG 2.38%
Row Labels Sum of ACTLABHRS execution, but is not ready to be scheduled and work that is ready to be performed. Also
PLANNED WORK 315.4166667 known as ready work.
READY WORK 15
Grand Total 330.4166667 Ready backlog is the quantity of work that has been fully prepared for execution, but has
not yet been executed. It is work for which all planning has been done and materials
procured, but is waiting to be scheduled for execution.
6. COST Compliance
Row Labels Sum of TOTAL ACT COST
NON PM 51.49%
PLANNED 42.91%
UNPLANNED 8.58%
PM 48.51%
PLANNED 48.51%
Grand Total 100.00%
This metric is the ratio of the actual cost incurred on a work order to the
estimated cost for that work order
Note : Please read the SMRP Best Practice book for a deeper
understanding.
PLANNER WEEKLY KPI
Planning Ratio
This metric is the amount of planned maintenance work that was completed
versus the total maintenance labor hours, expressed as a percentage.
Planning Variance Index
Number of Closed workorder in which actual costs are within 10% of planned cost
Note : Please read the SMRP Best Practice book for a deeper
understanding.
SKILLS & KNOWLEDGE
YOU NEED TO ANALYZE WORK ORDER DATA!
01 02 03
You need to learn how to measure You need to learn excel logic, You need to learn POWER BI to
Maintenance KPI by learning cleansing data on Excel and Pivot advancing Data Visualization. So
some reference like SMRP, EPRI, etc Table for analyze WO Data your information will be more eye
catching
MTBF ANALYSIS
Count of Work Order Column Labels MTBF is the average length of operating time
Row Labels 1 3 4 5 6 10 12 Grand Total between one maintenance action and another
2023 1 1 2 maintenance action for an asset or component. This
2024 1 1 2 4 1 9
metric is applied only for maintenance actions which
Grand Total 1 1 2 4 1 1 1 11
require or result in function interruption.
2023 2023 Total 2024 2024 Total
Row Labels 6 10 1 3 4 5 12
Chain Broken 1 1 This metric is used to measure the effectiveness of
Fly Ash Leak 1 1
the maintenance strategy for an asset or
Foreign Material 1 1
Out of Track 1 1 component.
Sprocket Broken 1 1 4 1 7
Grand Total 1 1 2 1 1 2 4 1 9 MTBF can be analyzed using Ms. Excel pivot
table using WO start date information.
EXAMPLE OF ADVANCED WO DATA VISUALIZATION
WO Cost Pareto Anaysis
Pareto analysis helps identify
which assets incur significant
repair costs, enabling
maintenance improvement
efforts to focus there
WO TRENDING (Counting)
WO Trending helps to
visualize workload and the
frequency of failures
occurring.
EXAMPLE OF ADVANCED WO DATA VISUALIZATION
Failure Mode Analysis
(WO Counting)
Helping you identify the most
common failures.
Failure WO Mix Analysis
Assisting you in identifying
the most frequent failures in
which areas and disciplines,
to aid in improving asset
criticality
ILHAM NT
THANK YOU!
Ilham Trilaksono
Planner
info@[Link]
[Link]
Indonesia