Maintenance & Reliability: MTBF, MTTR, Preventive Intervals & Spare Parts

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Summarise a quarter's failure log per machine with COUNTIF and SUMIF, calculate MTBF, MTTR and availability for each one and the availability of the whole line.
• Turn an MTBF into a failure rate and expected failures per year, build the reliability curve R(t) with EXP, and see how series and redundant pumps change the odds.
• Rank eight bearing failures, linearise the Weibull distribution with LN, read the shape β with SLOPE and the scale η from INTERCEPT, and test a PM interval.
• Compare the cost per operating hour of running each asset to failure with a preventive plan, pick the cheaper strategy per asset and add up the saving.
• Build a cost-per-hour table for eight overhaul intervals, find the cheapest interval with MIN and INDEX/MATCH and chart the U-shaped cost curve.
• Turn yearly part usage into demand during the lead time, read the service level of today's stock with POISSON.DIST, find the smallest stock that meets a 95% target and cost holding it.
• Score failure modes with a risk priority number, rank them, sort them into A/B/C classes with a nested IF, and highlight the high-severity modes that a ranking alone would hide.
• Roll the maintenance backlog forward week by week, express it in crew-weeks, size the planning team and estimate how long contractor support needs to bring the backlog back to target.