Spare parts reorder point: a free calculator and Excel template
Use the free reorder point calculator, no signup →
Or download the free Excel template →
In 10 seconds
- Reorder point = what you use while the order is on its way, plus safety stock.
- The more critical the part, the more safety stock it gets.
- Order when the shelf count reaches the reorder point. Order enough to get back to the max.
Every maintenance crew has been there. The machine is down, the part should be on the shelf, and the bin is empty. Or the opposite: a shelf full of belts for a machine you sold two years ago. Both come from the same thing. Nobody decided when to reorder each part, so it happens by memory.
A reorder point fixes that. It is one number per part: when the count on the shelf drops to it, you order. It takes a few minutes per part to set, and the math is simple enough to check by hand.
What you need for each part
- How many you use. Per month is easiest. Look at the last six to twelve months, not last week.
- Lead time. The real number of days from order to the part on your shelf, not the number the supplier quotes.
- How critical it is. A, B or C (more on that below).
The formula
- Used during lead time = usage per day × lead time in days.
- Safety stock = a factor for the class × the spread of usage during the lead time. If you don’t know the spread, use the square root of the usage during lead time. That fits parts that fail at random, which most spares do.
- Reorder point (min) = used during lead time + safety stock, rounded up to a whole part.
- Max = reorder point + one order. One order is your usage for the number of days you want an order to last.
A worked example
You use 6 heater bands a month. The supplier takes 14 days. A dead heater band stops a press, so it is class A.
- Used during lead time: 6 × 14 ÷ 30 = 2.8.
- Safety stock: 2.33 × √2.8 = 3.9.
- Reorder point: 2.8 + 3.9 = 6.7, so reorder at 7.
- One order that lasts 30 days is 6 parts, so the max is 13.
So when the bin is down to 7 heater bands, order enough to get back to 13. If there are 5 on the shelf, order 8.
Classes A, B and C
Not every part deserves the same safety stock. The class says how much it hurts when the bin is empty.
- A, critical: it stops a line and has no workaround. Set to be on the shelf 99% of the time. Factor 2.33.
- B, important: it slows you down or has a slow workaround. 95%. Factor 1.65.
- C, routine: easy to get or easy to live without for a day. 90%. Factor 1.28.
Going from 95% to 99% costs more stock than it sounds like. Save class A for the parts that really stop production.
Rules that keep it working
- Count the shelf on a schedule. A reorder point only works if the count is right.
- Update usage every quarter. Machines age and usage changes.
- Use the real lead time. If a supplier is often late, use the late number.
- Write the reorder point on the bin label, so anyone pulling the last parts knows to say something.
When the spreadsheet stops working
The Excel template is a good start, and for a small crew it may be all you need. It stops working when the count on the sheet and the count on the shelf drift apart. That happens when parts are pulled at 2 a.m. and nobody updates the file, or when usage lives in one file and work orders live somewhere else.
In vMaint, parts are tracked by bin and pulled against the work order that used them, so the count stays current and usage comes from real history instead of a guess.
See how vMaint tracks spare parts →
The best time to reorder a part is before the machine needs it.