Maintenance Spares Optimizer
Optimize spare parts inventory using MTBF and Lead Time demand. Enter values for instant results with step-by-step formulas.
Formula
ROP = (LeadTime × UsageRate) + (Z × √LeadTimeUsage)
Reorder Point (ROP) ensures you have enough parts to survive the Lead Time. It combines Expected Demand (LeadTime × Usage) plus a Safety Buffer (Z × StdDev) to account for randomness in failure rates.
Worked Examples
Example 1: Critical Motor
Problem:MTBF 1000h, Lead Time 30 days, Usage 24h/day
Solution:High demand during long lead time requires significant buffer.
Result:Spares: 3 units
Example 2: Consumable Filter
Problem:MTBF 500h, Lead Time 2 days, Usage 8h/day
Solution:Short lead time minimizes risk.
Result:Spares: 1 unit
Example 3: Rare Failure
Problem:MTBF 50,000h, Lead Time 14 days
Solution:Demand is near zero. Keep 1 just in case (Insurance spare).
Result:Spares: 1 unit
Frequently Asked Questions
Does this assume Poisson distribution?
Yes, spare parts demand is typically modeled as a Poisson process because failures are random, independent events.
What about 'Insurance Spares'?
Parts that rarely break (MTBF > 10 years) but are critical. Standard formulas say 0 stock, but you keep 1 for insurance against catastrophic risk.
Why not just buy tons of spares?
Capital is tied up in inventory (holding cost). Parts degrade (rust, seals dry out). Efficient MRO balances risk vs cost.
Background & Theory
The Poisson Distribution
Spare parts failures are "rare events". We use Poisson statistics to model the probability of $N$ failures occurring during the Lead Time. The goal is to set stock levels such that the probability of running out (Stockout) is acceptable (e.g., <5%).
Criticality Matrix
- Criticality A (High): Production stoppage. Safety Issue. Keep high safety stock (99%+).
- Criticality B (Medium): Reduced rate. Workaround available. Moderate stock (95%).
- Criticality C (Low): No impact. Cosmetic. Order on demand (0 stock).
Optimization Levers
To reduce inventory without increasing risk:
- Reduce Lead Time: Expedited shipping is cheaper than holding inventory.
- Increase MTBF: Better maintenance/lubrication.
- Standardize: Use the same motor across multiple machines (Risk Pooling).
History
The "Just in Case" Era
Historically, factories kept massive "boneyards" of spare parts. If a machine broke, they had the part. This maximized uptime but killed cash flow.
Lean MRO & JIT
In the 1980s, Lean manufacturing pushed to reduce inventory. "Just In Time" (JIT) applied to spares too. However, unlike raw materials, machine failures are random. Applying JIT blindly to critical spares led to catastrophic downtime when parts weren't available.
Reliability Centered Maintenance (RCM)
Modern approaches use RCM. We classify parts by criticality. Critical parts get safety stock. Non-critical parts are "run to failure" and ordered on demand. Predictive Maintenance (IoT sensors) is now reducing the need for statistical guessing by telling us exactly when a bearing will fail.
Common Misconceptions
- Myth: "We have 2 pumps, so we need 2 spares." Reality: Highly unlikely both break at once. 1 spare might cover 5 pumps (Pooling).
- Myth: "Lead time is 2 days." Reality: Vendor says 2 days. Accounting takes 1 day, receiving takes 1 day. Actual lead time is 4 days.