Maintenance Spare Parts Inventory: Setting Reorder Points from Your PM Schedule
Most stockouts are visible weeks ahead in the PM schedule. Here is how to tie parts to PM tasks and set reorder points from the work you have already planned.

The Bearing That Was Due Thursday
The PM for the cooling water pump was on the schedule for Thursday. The technician pulled the work order, walked to the stockroom, and found the bin for the right bearing empty. The last two had gone into an emergency repair three weeks earlier. Nobody reordered because nobody saw the PM coming. The supplier quoted four weeks. The PM slipped, then slipped again, and then the pump failed on its own.
Nothing about that was a surprise. The PM was on the calendar for months. The part it needed was a known quantity. The information to prevent the stockout existed in the schedule the whole time. It just lived in a different spreadsheet from the stockroom count.
This article shows you how to connect the two. You will walk away able to list the parts each PM task consumes, turn that list into a planned-usage forecast, and set reorder points from it.
Why PM Work Is the Best Forecast for Maintenance Spare Parts Inventory
Most advice on maintenance spare parts inventory starts with past usage: look at what you issued last year and stock accordingly. That works for parts consumed at random. It works poorly for a plant that runs a preventive maintenance program, because a large share of what you consume is planned.
Think about what a PM task actually uses. A quarterly pump inspection might use a coupling insert, a gasket, and grease. A belt-drive PM uses a belt set. A filter change uses filters. You wrote the interval. You know the next due date. So you also know, with reasonable accuracy, when those parts will leave the shelf.
That gives you two kinds of demand:
- Planned demand. Parts consumed by scheduled PM tasks. You can forecast it from the calendar.
- Unplanned demand. Parts consumed by breakdowns and corrective work. You can only estimate it from history.
A good maintenance spare parts inventory treats these separately. Planned demand drives the reorder point. Unplanned demand drives the safety stock and the critical-spares list. Mixing them into a single "average monthly usage" number hides the part of your demand that you could have predicted exactly.
If you have not built the schedule yet, start with how to build a preventive maintenance schedule. Everything below assumes you have assets, tasks, and intervals in one place.
Step One: Attach Parts to Each PM Task
The foundation is a simple list. For every PM task in your schedule, write down the parts and consumables it uses, and how many per execution.
Use one row per task-and-part pair:
| PM task | Asset | Part | Qty per task | Interval |
|---|---|---|---|---|
| Quarterly pump inspection | Cooling water pump P-12 | Coupling insert | 1 | 3 months |
| Quarterly pump inspection | Cooling water pump P-12 | Grease cartridge | 1 | 3 months |
| Semi-annual belt check | Air handler AH-3 | Belt set | 1 | 6 months |
Be disciplined about two things.
Count what really gets consumed. If the task says "replace if worn," decide whether you stock for the replacement every time or only some of the time. Write your assumption down. An honest "replace about half the time" is better than ignoring the part or assuming a replacement every time.
Standardize part numbers. If the same bearing appears under three descriptions, your stockroom count and your PM list will never reconcile. Pick one part number per item and use it everywhere, including on the bin label.
Once the list exists, you can roll it up. Count how many of each part the whole schedule will consume over the next quarter. That number is your planned demand. This same roll-up also tells you which parts are shared across many assets, which matters a lot when you decide how deep to stock.
Setting a Spare Parts Reorder Point From Planned Usage
The reorder point is the on-hand quantity at which you place an order, so that stock arrives before you run out. The basic formula is short:
Reorder point = (planned usage per week × lead time in weeks) + safety stock
Planned usage comes from your PM roll-up. Lead time is how long the supplier really takes, measured from the day you place the order to the day the part is on your shelf. Safety stock is the cushion for the unplanned demand and for late deliveries.
Here is a worked example with round numbers. These inputs are illustrative only. Use your own.
- Your PM schedule will consume 13 sealed bearings over the next 13 weeks. Planned usage is 1 per week.
- Your supplier's lead time, in your experience, is 4 weeks.
- Demand during the lead time is 1 × 4 = 4 bearings.
- Past breakdowns suggest you occasionally need a couple of extras. You set safety stock at 2.
- Reorder point = 4 + 2 = 6 bearings.
So when the bin drops to 6, you order. If the schedule is steady, the new bearings arrive just as the stock approaches the safety level, and the PMs keep running.
Two points make this more than arithmetic.
Lead time is the number people get wrong. The quoted lead time is not always the real one. Track the actual date you ordered and the actual date the part arrived for a handful of orders, and use the longer realistic figure. A part with an unpredictable supplier needs more safety stock than the same part from a reliable local distributor.
Recalculate when the schedule changes. If you move a PM interval from six months to three, planned usage doubles. The reorder point has to follow. This is the real benefit of tying parts to the schedule: when the plan changes, you can see the stockroom consequence immediately instead of discovering it at the bin.
For a PM that already slipped because a part was missing, the pattern is familiar. We cover that failure mode in why PM tasks get missed, and parts availability is one of the most avoidable causes.
Build a Critical Spares List Before You Need One
Reorder points work for parts you consume regularly. A critical spare is different. It may never be used under normal conditions, and when you need it, you need it now.
The test for a critical spare combines two questions:
- What happens if the asset is down? Does it stop the line, create a safety exposure, or have no backup?
- How long to get the part? If the answer is weeks, and the asset is a single point of failure, you stock it even if usage is close to zero.
The first question is exactly what an asset criticality ranking answers. If you have already scored your equipment by consequence and likelihood, use that ranking to decide where spares are worth their shelf cost. Our guide to asset criticality ranking walks through the method.
A short list is enough to start. For each top-tier asset, name the one to three parts that, if they failed, would leave you down the longest. Typical candidates are a motor for a one-of-a-kind process, a drive or controller with a long lead time, or a gearbox for a line with no standby. For these, set the minimum stock level by judgment and lead time, not by usage formula, and write the reason next to it.
Why bother? Because the cost of waiting is the cost of downtime, and that cost is substantial. For a sourced view of how large it can be, see our breakdown of the cost of unplanned downtime. Compare that to the carrying cost of one extra spare, which we do not quote here because it depends on the part, your cost of capital, and your storage. Calculate your own for the five or ten parts on your critical list.
Kit Parts to PM Work Orders
Once parts are linked to tasks, you can go one step further and kit them. Parts kitting means pulling every part and consumable a PM needs and staging them together before the work starts.
Kitting helps in three ways:
- It exposes shortages early. You find the missing part when you build the kit, days before the PM, not when the technician is standing at the machine.
- It protects wrench time. A technician who walks to the stockroom three times for one PM is not working on the equipment. Planning the job includes planning the parts.
- It keeps counts honest. If the kit is issued against the work order, the stock count drops when the part is consumed, not weeks later when someone remembers.
A practical rhythm: each week, look at next week's PMs, pull the parts list for each, check stock against it, and stage what is there. Anything short triggers an immediate order or a reschedule. This is the stockroom side of planning-first maintenance, and it costs a few minutes per week once the task-to-part list exists.
Spot Dead Stock Before It Spots You
The opposite problem is just as real. Shelves fill with parts nobody uses, bought for equipment that has since been replaced, or ordered in a larger quantity than any schedule justified. This is dead stock. It ties up money and space, and it hides the parts you really need.
Linking parts to PM tasks gives you a clean test. Any part that has:
- no PM task consuming it,
- no spot on the critical spares list, and
- no issue in a long period you choose (for example, two years of no use)
is a candidate for review. Do not discard it automatically. Check first whether the asset it serves still exists, whether the part is interchangeable with something you do use, and whether a supplier will take it back. Then decide: keep it deliberately as a critical spare, return it, sell it, or write it off.
Run this review on a fixed schedule, such as once or twice a year. Add a "last issued" date to each part and the review becomes a filter instead of an archaeology project.
Putting It in One Workbook
You can do all of this in a spreadsheet. The structure is a parts list with columns for on-hand quantity, planned usage from the PM schedule, lead time, safety stock, reorder point, and last-issued date, plus a flag when on-hand falls to or below the reorder point.
If you would rather start from a built layout, the Spare Parts & Consumables Tracker (PM-Linked) takes on-hand and reorder point in and gives a stockout alarm and dead-stock value out. It is a spreadsheet template, not a CMMS, so it works from the quantities you enter and does not pull usage on its own. You can find it at Spare Parts & Consumables Tracker. Other planning workbooks that pair with it are collected in the preventive maintenance templates hub.
Whatever tool you choose, the sequence stays the same. Link parts to PM tasks. Roll up planned usage. Set reorder points from usage and real lead time. Protect the assets that matter most with a short critical spares list. Review dead stock on a schedule. Done in that order, your maintenance spare parts inventory stops being a surprise and starts being a view of the schedule you already built.
Ready to go beyond the guide?
Get more guides like this in your inbox
Related guides
PM Program FundamentalsWeekly Maintenance Scheduling: Loading Crew Hours Without Overbooking
A weekly schedule is where the PM plan meets real crew hours. Here is how to load the week by priority and capacity so the plan is one your team can finish.
PM Program FundamentalsHow to Structure a PM Schedule Template for Multiple Asset Types
A PM schedule template that works for one asset type often breaks when you add a second. Here's how to structure columns and intervals so it scales.
PM Program FundamentalsPM Scheduling Methods: Calendar-Based, Usage-Based, and Condition-Based Triggers
Not every asset should run on the same clock. Here's how to pick calendar-based, usage-based, or condition-based triggers for each piece of equipment.