Maintenance & Reliability: MTBF, MTTR, Preventive Intervals & Spare Parts
Turn a failure log into MTBF, MTTR and line availability, model reliability with EXP and a Weibull fit, weigh preventive maintenance against run-to-failure, find the cheapest PM interval, size spares with POISSON.DIST, rank failure modes by RPN and keep the backlog in check – every cell checked as you go.
The first lesson is free — no account needed.
About this course
A maintenance and reliability course that plans the upkeep of one fictional production line in a spreadsheet, for maintenance planners and managers, reliability and plant engineers, CMMS analysts and engineering students. You summarise a failure log into MTBF, MTTR and availability per machine and for the whole line, turn an MTBF into a failure rate and a reliability curve with EXP for series and redundant pumps, fit a Weibull shape and scale to bearing failures with LN and SLOPE, compare the cost per operating hour of preventive maintenance with run-to-failure, find the cheapest overhaul interval on a U-shaped cost chart, size spare parts for a 95% service level with POISSON.DIST, rank failure modes by risk priority number, and roll the maintenance backlog forward in crew-weeks. Illustrative data. The first lab is free.
Lessons
- Failure Log to MTBF, MTTR & Availability per AssetFree
- Failure Rate & Reliability over Time: R(t) = e^(−λt) Pro
- Weibull Basics: Shape β from a Linearised Fit Pro
- Preventive vs Run-to-Failure: Cost per Operating Hour Pro
- Optimal Preventive Interval: Cost-Rate Table & Chart Pro
- Spare Parts Stock with Poisson Demand Pro
- Criticality Ranking: Risk Priority Number Pro
- Maintenance Backlog & Planner Workload Pro