Every maintenance manager faces the same dilemma: keep too many spare parts and watch working capital disappear into slow-moving stock. Keep too few and risk hours or days of unplanned downtime waiting for delivery.
The inventory balancing act is one of the toughest decisions in maintenance operations. But it does not have to be guesswork. With the right calculations and a structured approach, you can set inventory levels that minimize both stockout risk and carrying cost.
This guide covers the key formulas — safety stock, reorder point, min-max levels — and how to apply them to your spare parts inventory.
The Key Concepts
Before running calculations, you need to understand five fundamental terms:
Min level. The lowest quantity you want to hold before triggering a replenishment order. Set based on lead time consumption plus safety stock.
Max level. The upper limit you want to hold. Prevents overstocking and excessive capital tie-up. Usually calculated as min level + economic order quantity.
Reorder point (ROP). The inventory level at which you must place a new order. When stock drops to this level, you order more.
Safety stock. The buffer quantity you hold above expected lead time demand. Protection against variability — both demand spikes and late deliveries.
Lead time. The time between placing an order and receiving the part, measured in days. Includes supplier processing, shipping, receiving, and inspection.
How to Calculate Safety Stock
Safety stock is the most critical number in spare parts planning. Get this wrong, and you either waste capital or risk downtime.
The standard formula:
Safety Stock = (Max Daily Usage × Max Lead Time) − (Avg Daily Usage × Avg Lead Time)
Let us walk through an example.
A factory uses a specific bearing on three conveyor motors. Usage varies from 0 to 2 units per day, averaging 0.8 per day. The supplier usually delivers in 14 days, but has taken up to 21 days during peak seasons.
Max daily usage: 2 units
Max lead time: 21 days
Avg daily usage: 0.8 units
Avg lead time: 14 days
Safety stock = (2 × 21) − (0.8 × 14)
= 42 − 11.2
= 30.8 → **31 units**
This factory should hold 31 units of safety stock for this bearing. That buffers against the worst case: the supplier being slow while usage spikes.
When to Adjust Safety Stock
The formula above gives a baseline. Adjust it based on:
- Criticality. Safety stock for a part that stops a bottleneck machine should be higher than the formula suggests — even 2–3×.
- Supplier reliability. If your supplier has consistent 95%+ on-time delivery, you can reduce the max lead time in the formula.
- Seasonality. If usage spikes during certain months (e.g., harvest season for F&B plants), recalculate safety stock for peak periods separately.
How to Set the Reorder Point
Once safety stock is calculated, the reorder point follows directly:
Reorder Point = (Avg Daily Usage × Avg Lead Time) + Safety Stock
Using the same bearing example:
Avg daily usage × Avg lead time = 0.8 × 14 = 11.2
Safety stock = 31
Reorder point = 11.2 + 31 = **42 units**
When the bearing stock level hits 42 units, place a new order. By the time the order arrives (14 days later, on average), you will have consumed about 11 units during lead time, leaving approximately 31 units — exactly your safety stock.
Visualizing the Cycle
- Day 0: Receive 80 units (max level). Stock = 80.
- Stock decreases by ~0.8 units per day during normal operation.
- Day ~48: Stock hits 42 (reorder point). Place order.
- Days 48–62 (14 days lead time): Stock drops by ~11 more units to ~31.
- Day 62: New order arrives. Stock jumps back to ~111 (31 safety stock + 80 new).
- Cycle repeats.
This system ensures you never dip below safety stock — as long as usage and lead time stay within expected ranges.
Min and Max Levels
With safety stock and reorder point defined, set min and max levels:
- Min level = Safety stock + lead time demand. In the example: 31 + 11 = 42 (same as ROP).
- Max level = Min level + order quantity. If you order 80 units: 42 + 80 = 122 units.
Some organizations set min level equal to safety stock and ROP slightly above it. The naming convention varies, but the logic is the same — you need a trigger point (ROP) and a floor (safety stock).
ABC Analysis for Inventory Segmentation
Not all spare parts deserve the same level of attention. ABC analysis helps you prioritize:
| Class | % of SKUs | % of Spend | Strategy |
|---|---|---|---|
| A | 10–20% | 70–80% | Tight controls, frequent review, higher safety stock, dual sourcing |
| B | 20–30% | 15–20% | Moderate controls, periodic review, standard safety stock |
| C | 50–70% | 5–10% | Simple min-max, bulk ordering, minimal safety stock |
A-items are your critical spares — expensive components that stop production when they fail. These get the full safety stock treatment above. Validate their min-max levels quarterly.
B-items get standard calculations with monthly or quarterly review.
C-items (nuts, bolts, seals, o-rings, consumables) are cheap and fast-moving. Set generous min-max levels and review them annually. The carrying cost is low, and the administrative cost of tight control exceeds the potential savings.
Slow-Moving vs. Fast-Moving Parts
Different usage patterns require different strategies:
Fast-Moving Parts
Parts consumed at least once per month. Examples: lubricants, filters, gaskets, belt sets.
- Use the standard safety stock and ROP formulas above.
- Review min-max levels quarterly.
- Consider bulk purchasing to reduce per-unit cost and ordering frequency.
Slow-Moving Parts
Parts consumed less than once per quarter. Examples: specialized seals, circuit boards, custom-machined components.
The standard safety stock formula often produces unrealistic numbers for slow-movers because daily usage is near zero most days and spikes only when a failure occurs.
Alternative approach: Set stock level to 1 or 2 units based on criticality and lead time. If the part is critical and lead time is 12 weeks, stock 1 unit and set ROP to 1. When you use it, order the next one immediately (two-bin system).
Insurance spares: Very large or expensive parts (transformers, gearboxes, large motors) purchased once and held for years. These are capital decisions, not inventory calculations. Justify them based on downtime cost vs. holding cost.
How CMMS Tracks Inventory
Manual calculations are a good starting point, but keeping them accurate requires real-time data. This is where a CMMS with an inventory module changes the game.
Automatic usage tracking. Every time a part is issued to a work order, the CMMS deducts it from stock instantly. No manual counting, no spreadsheets to update.
Auto-reorder alerts. When stock hits the reorder point, the system generates a purchase requisition automatically. Can also send notifications to the purchasing team via email or in-app.
Lead time tracking. The CMMS records actual lead times from every purchase order, building a reliable history so your safety stock calculations use real data, not guesses.
Part-to-asset linking. Each spare part is linked to the specific assets it fits. When creating a work order, the system shows exactly which parts are needed and whether they are in stock.
Usage analytics. Reports show which parts are consumed fastest, which assets consume the most spares, and where your inventory budget is going. This data feeds directly into ABC analysis and min-max adjustments.
Cycle counting tools. Schedule and track partial inventory counts to maintain accuracy without shutting down for full stocktakes.
Moving from Reactive to Planned
Most factories start with reactive inventory management: a part runs out, someone panic-orders it, and the cycle repeats. Moving to planned inventory management takes three steps:
- Calculate baseline levels using the formulas above for your top 50 A-items.
- Enter min-max levels into your CMMS and enable auto-reorder alerts.
- Review and adjust quarterly. Compare actual consumption to your assumptions. Tighten safety stock where usage is consistent. Increase it where variability is high.
Within two quarters, you will have data-driven inventory levels instead of gut-feel stock decisions. Stockouts decrease. Carrying costs drop. And your maintenance team spends less time chasing parts and more time maintaining equipment.
Ready to Take Control of Your Spare Parts Inventory?
OpexMX is a CMMS built for Indonesian manufacturing teams. Our inventory module handles safety stock calculations, auto-reorder alerts, part-to-asset BOM linking, and usage analytics — all in one system.
Contact us for a demo or start your free trial today.