1. Home
  2. Tools
  3. Critical spares calculator

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

Demand for the part
Service level
Costs
Shortage
If it fails with no spare

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.

Miguel Pengel, principal engineer, Pardus Consulting

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.

Discuss your project About Pardus

Discuss a project with Pardus.

Outline the plant, the assets or the question. An engineer will make contact to arrange a scoping discussion, and a written proposal follows once the scope is agreed.