Preventive Maintenance Plan
If your maintenance is firefighting, this template moves you to preventive in one afternoon: inventory, self-marking calendar, breakdown log and the numbers that prove you're improving.
What you get
→ Equipment inventory
Every machine with its code, line, criticality (A/B/C) and year. Criticality decides where preventive goes first.
→ Self-marking calendar
Set task, frequency and start month; the year's X marks appear by themselves. No dragging cells.
→ Intervention log
Every breakdown and every preventive job with downtime hours and cost. Stop depending on the maintenance guy's memory.
→ Summary with the KPIs that matter
Downtime hours, repair cost, MTTR and preventive/corrective ratio with its traffic light: planned or firefighting?
→ Worst equipment in plain sight
The machine with the most downtime hours shows itself in the summary: the next candidate for a serious plan.
→ PDF guide (4 pages)
How to start preventive without stopping the factory, first-week quick wins and classic mistakes. EN/ES.
Single bilingual file: headers and instructions in Spanish and English. Calculation cells are locked so nobody breaks the formulas; you only type in the input cells.
What it looks like inside
How it works
- Build the inventory: machine by machine, with A/B/C criticality. One afternoon, coffee in hand.
- Enter the preventive tasks for A equipment first: frequency and start month. The calendar draws itself.
- Log every intervention (breakdown or preventive) with its downtime hours and cost.
- Check the summary every month: if the preventive/corrective ratio is red, you're still a firefighter; if it climbs, you're winning.
A breakdown costs 5 to 10 times more than the preventive work that avoids it. This template won't make breakdowns disappear: it tells you what they cost and where to start removing them.
Who it's for
For the plant or maintenance manager of an industrial SME (one person or a small team) with no CMMS and no budget for one, who wants to move from corrective to preventive with a serious Excel.