Skip to content
Omnikalc

Spare parts provisioning calculator

Enter the number of units in service, their MTBF, the period and the confidence level to get the expected failures and the number of spares that covers them.

Updated on
Your inputs

Value out of range

h

Value out of range

h

Value out of range

%

Value out of range

Results

Spares to stock

19

Expected failures in the period
13.14
Probability that the spares cover all failures
95.34 %
Coverage with one spare fewer
92.45 %
Probability of a stock-out
4.66 %
Average spares used
13.14

The spare parts calculator gives the expected number of failures and the number of spares to stock so that the failures are covered with the confidence you choose, using the Poisson law.

How the calculation works

  • Enter the number of units in service and the MTBF of one unit.
  • Enter the period to cover and the confidence level.
  • The calculator gives the expected failures, the spares to stock, the coverage reached, the coverage with one spare fewer and the risk of a stock-out.

Example

12 units with an MTBF of 8,000 h that run 8,760 h a year are expected to fail 12 × 8,760 / 8,000 = 13.14 times. To cover the failures with 95 % confidence, you need 19 spares: they cover 95.34 % of the cases, against 92.45 % with one spare fewer. The risk of a stock-out is 4.66 %.

Why it matters

The calculator helps maintenance planners, reliability engineers and small fleets owners to size a spare parts stock for pumps, motors, bulbs, drives or any part with random failures.

Good to know

Take the MTBF from the data sheet or, better, from your own failure records, because the catalog value is often optimistic. The period is the time you have to wait for a replenishment, not the year: if parts arrive in four weeks, cover four weeks of operation and reorder when you use a spare. A critical part with a long lead time deserves a higher confidence level, such as 99 %, while a cheap part can be covered at 90 %. If the units do not run all the time, use the running hours of the period. For a repairable part with a short repair loop, the stock can be much lower, so adjust the period to the repair time. The result is a number of whole parts and always rounds up.

The MTBF and availability calculator gives the failure rate, the system reliability calculator combines components, the Poisson distribution calculator gives the probabilities and the EOQ calculator sizes an order.

Frequently asked questions

How are spare parts counted with the Poisson law?

If the units fail at random with a constant failure rate, the number of failures in the period follows a Poisson law whose mean is μ = N t / MTBF. The number of spares s is the smallest value such that the probability of at most s failures reaches the confidence level you want.

Why not just stock the expected number?

Stocking the mean number of failures leaves about a 40 to 50 % chance of running out, because the actual count varies from year to year. A few more spares cut this risk fast. The calculator shows the coverage of the chosen number and of one spare fewer, so you can see the cost of each step.

What does the model leave out?

It assumes a constant failure rate, repairs that are not counted and a spare that is available at the time of failure. If repaired parts return to stock, you need fewer spares, and if the lead time is long, use the period of the lead time. For wearing parts, a Weibull model is more suitable. Above 40 expected failures the calculator uses a normal approximation.

Was this calculator helpful?

Thanks for your feedback!

Results are estimates provided for information purposes. They do not replace professional advice.