Factories · workshops · food plants · facilities

Preventive maintenance schedule – 52-week plan, work orders and reliability

Some tasks are due every month, others every 500 running hours, and some at whichever comes first. The schedule handles all three, builds a 52-week plan from the work orders and ranks the assets that break down most, so the maintenance team knows where its hours are going.

  • 80 assets and 200 PM tasks
  • Intervals by date, hours, cycles or km
  • 1,200 work orders with downtime and cost
  • 150 spare parts with stock levels
Add to basket
Planned Maintenance Schedule – Dashboard

Meter readings that forecast the due date

For a task triggered by hours, cycles or km, METER READINGS takes regular readings from the hour meter, stroke counter or odometer. The workbook works out the use per day and forecasts when the task will fall due, with a maximum number of months as a backstop.

What is in the file

  • START
  • SETTINGS
  • ASSETS
  • PM TASKS
  • 52-WEEK PLAN
  • WORK ORDERS
  • METER READINGS
  • SPARE PARTS
  • RELIABILITY
  • DASHBOARD
File format
.xlsx
Tabs
10
Capacity
80 assets · 200 PM tasks · 1,200 work orders · 1,500 meter readings · 150 spare parts
Requires
Excel 2016+ / Microsoft 365
Macros
None

The 52-week plan

  • ✓ for work done, taken from the work orders
  • ● for planned tasks
  • ! for overdue tasks
  • Planned hours per week to balance the workload

The plan year starts on the date you set in SETTINGS.

Inside the workbook

Questions and answers

How is PM compliance calculated?
It is the share of preventive maintenance jobs that were done within their window during the period you choose.
Where do I begin?
List the assets first, then the tasks for each from the manufacturer's manual and your breakdown history, with an interval and the last date done.
Does it cover statutory inspections?
You can add them as tasks with their interval, but the legal requirements for lifting equipment, pressure systems and similar must be checked separately.

Reliability per asset

RELIABILITY shows for each asset the PM jobs done and on time, PM compliance, breakdowns, MTBF, MTTR, availability and cost, and ranks the worst performers. WORK ORDERS records labour, parts, contractor cost and downtime for PM, breakdowns and corrective jobs.

Plan the maintenance before the breakdown plans it for you

Add the schedule to your basket and continue to payment.

Add to basket