Critical Spare Parts Calculator

The question every maintenance store faces

A spare part on the shelf costs money every year it sits there. A spare part that is not on the shelf costs nothing, right up to the day the equipment fails and everyone waits six weeks for a delivery. Most stocking decisions are made by gut feeling, or by whoever was burned last time. This calculator puts both sides in the same currency so the decision can be argued with numbers.

It is meant for critical, slow-moving parts: pump shafts and impellers, mechanical seals, gearboxes, motors, heat exchanger plates, control valves, VFD boards. Fast-moving consumables like filters and gaskets follow different logic, and for planned outages the question is simpler: are the parts physically on site the day before? The shutdown readiness checklist covers that.

Two inputs are usually the hardest to pin down. The hourly cost of downtime can be built up line by line with the downtime cost calculator, and the mean time between failures comes straight out of your failure records with the MTBF calculator.

How the calculation works

The calculator uses a base-stock model, a standard method in spare parts planning. You keep s spares. Each time one is used, you immediately order a replacement, which arrives after the lead time. Equipment only waits when more failures happen during a lead time than you have spares on the shelf.

Failures are assumed to be random and independent, which makes the number of failures during one lead time follow a Poisson distribution with mean:

The expected number of units waiting for a part at any moment (often called expected backorders) is:

Multiply that by the hours in a year and by the share of each day that counts as lost production, and you get the expected waiting hours per year. Downtime cost is those hours times your hourly cost. Holding cost is the number of spares times price times the holding rate. The recommended stock is the level with the lowest total.

A worked example

Take one critical circulation pump in a district heating plant. Its mechanical seal and bearing kit costs 6,000, fails on average every three years, and the supplier needs 45 days to deliver. When the pump is down, the plant loses about 400 per hour, around the clock. (If you are sizing or checking the pipework that pump serves, the pipe pressure drop calculator does that part.)

With no spare, the expected waiting time is 360 hours a year, which is about 144,000 a year in downtime cost. One spare on the shelf costs 1,200 a year to hold and cuts expected waiting to around 7 hours, for a total of about 4,100. A second spare costs another 1,200 a year but brings total cost down to roughly 2,400, because it covers the unlucky case of a second failure before the first replacement arrives.

Now add a standby pump that takes over automatically, and drop the downtime cost to 40 per hour to reflect running without backup. The answer changes: one spare is still worth it, but the second one is not. Redundancy and spare parts do the same job, and paying for both is often where money leaks.

What the model leaves out

Real equipment is messier than the formula, and it helps to know where.

Wear-out parts do not fail at random. A bearing that is eight years old is more likely to fail than a new one, so if your units are all the same age, failures can bunch together and the calculator will underestimate risk. Lead times are not fixed either; the 45 days quoted in a calm year can become 120 in a bad one. It is worth running the calculator with a pessimistic lead time as well as the usual one.

Some costs are hard to put into an hourly number at all: a safety incident, an environmental release, heating cut off to a hospital in January. If a failure has consequences like that, the part belongs on the shelf regardless of what the arithmetic says.

Sponsored

Frequently asked questions

What holding cost rate should I use?

Holding cost covers capital tied up in the part, storage, insurance, handling and the risk that the part becomes obsolete or deteriorates on the shelf. Many companies use 15 to 25 percent of the part price per year. If your finance team has a cost of capital figure, start there and add a few points for storage and obsolescence.

How do I estimate the failure rate?

Use your own maintenance history first: how many times has this part been replaced across all identical units in the last five or ten years? Divide by the number of unit-years. If you have no history, manufacturer MTBF data or industry reliability handbooks give a starting point, but treat them as optimistic.

What if there is a standby unit?

Then a failure does not stop production straight away; you lose redundancy instead. Enter a much lower downtime cost that reflects the risk of running without backup, for example the cost of a second failure multiplied by its probability, or the cost of the extra measures you take while the standby is the only unit running.

Does the calculator account for the time to install the part?

No. It counts only the time spent waiting for a part that is not in stock, because that is the part of downtime a spare actually removes. Installation time is roughly the same whether the part came from your store or from the supplier.