Critical spares calculator: how many spares to hold
How many critical spares to hold: a free calculator for the number for a target service level, the stock with the lowest total cost, reorder points, insurance spares and ABC/VED ranking. It works from MTBF or from Weibull shape and scale.
Critical spares calculator
Runs in your browser. Nothing you enter is sent to a server or stored.
How to use it
Choose the method. MTBF suits random failures, such as electronics, or parts where only an MTBF is known. Weibull suits wear-out parts such as bearings, seals and pumps, and also counts the spares used by planned replacements. Enter the population (the number of identical components installed), the operating hours per year (8,760 for 24/7), and the MTBF, or beta, eta and the PM interval. Then pick the service level: the chance of no stock-out over the period. Five tabs cover the usual spares questions: spares for a service level, the stock with the lowest total cost, a reorder point with safety stock, an insurance spare decision for expensive slow movers, and an ABC/VED ranking of a parts list.
How to read the result
The calculator returns the recommended stock and the service level it achieves, from the Poisson distribution of the number of failures in the period. Its table lists each stock level with its chance of covering every failure; the first level at or above your target is the recommendation. Service level here means the chance of no stock-out over the whole period with no replenishment, not the fill rate. For wear-out parts the calculator counts the failures a new fleet will actually have in the period, which is well below the steady-state rate in the first year, and rounds the planned replacements up.
A worked example
Ten identical components run 8,760 hours a year with an MTBF of 25,000 hours, so the expected number of failures is 10 x 8,760 / 25,000 = 3.504 a year. At a 95% target, 6 spares cover every failure in the year with a probability of 93.4%, short of the target; 7 spares give 97.3%, so the recommendation is 7.
What to do with the numbers
How to calculate critical spares quantities in Excel
The same method in a spreadsheet, with a mining example.
Weibull calculator
Get beta and eta for the Weibull method from your failure data.
Reliability engineering
A spares review across a fleet, done on your CMMS data.
Questions people ask
What service level should critical spares have?
Set it from the cost of a stock-out against the cost of holding the part. As a starting point, 95% suits standard parts, 99% critical spares and 99.9% safety-critical items. The lowest-total-cost tab finds the level the economics support.
What is the difference between the MTBF and Weibull methods?
The MTBF method assumes failures happen at a constant rate, which suits random failures. The Weibull method lets the rate change with age, which suits wear-out parts, and it counts the spares used by planned replacements.
Does it account for lead time?
The service-level tab sizes the stock for the hours you enter, with no replenishment in between. For parts you reorder, the reorder point tab takes the lead time and its variation and returns the reorder point and safety stock.
Who built it
The tool was built by Pardus Consulting and uses the same methods the firm applies on client work. When the question is bigger than a calculator, the analysis is run on your own CMMS data and signed by a registered professional engineer.