Work Orders Overview
This report focuses on the analysis of the number of work orders in maintenance backlog. I work order is a documentation which is generated in a computer maintenance management system (CMMS) to specify the details of work that needs to be carried out on an item of equipment e.g. a pump, a motor, a vessel, a valve etc.
The work order has a number of fields that allow data to be captured related to the work order record. Important fields include the work criticality, the target date, the department responsible for the work, the state of readiness of the work to be carried out, the number of man-hours required to carry out the work and the work order priority.
The target date is a date which the work needs to be completed before. If the target date is in the past then the work order is overdue and is deemed to be in the company's backlog of activities. The higher the backlog and the longer work has been in backlog, the higher the risk that equipment will fail and result in an impact on one or more aspects of the business. e.g. personal safety, the environment or ability of the company to maintain the production of its products.
Report Layout
The top left of the report displays an overview of the total number for work orders and the man-hours required to liquidate the work. This is a key metric to understand the overall backlog. The higher the backlog the higher the risk that important equipment will fail and result in an impact on the companies business performance.
Next, I've split the total backlog in work criticality. This provides a breakdown of how that total work is split across different criticalities of work. e.g. safety, environment, production etc.
The grid in the middle of the page is a heat map designed to highlight which department has the highest number of man-hours in the backlog. This allows the company management to understand which department may require additional resources in order to liquidate their work orders.
The bar charts on the left show two additional aspects of the backlog. The first is splits it by priority, the second by the number of days overdue, split into grouping bins based on the number of days they have been in backlog.
There are drill throughs enabled on the matrix and the bar charts, as well as a drill through button at the top right to view the work order details lists.
For more details on how I built this dashboard courses at https://effectivedashboards.com.
Jason.
eyJrIjoiYWM0NTliM2EtOGU4OS00MTRmLWJkYmYtYmYxOThkNGJkOWNhIiwidCI6ImYzMDVmNDA4LTk1M2YtNGIzZS1hNTljLTk2MjBhYzJhZGI1OSJ9&pageName=ReportSection
