Introduction
Spare parts inventory sits at the intersection of two costly problems. Keep too little, and a critical component stockout can turn a two-hour repair into a two-day equipment shutdown. Keep too much, and capital is locked up in shelves full of parts that may never be used — some of which will eventually expire, corrode, or become obsolete. Most maintenance organizations live somewhere in the uncomfortable middle, managing inventory reactively and discovering gaps only when they hurt.
The good news is that most organizations are already generating the data needed to make better inventory decisions. Work orders capture parts consumption. Asset records carry failure history. PM schedules show future demand. A structured approach to spare parts management — supported by a CMMS that connects these data sources — can dramatically reduce both stockouts and carrying costs simultaneously.
The True Cost of Getting Inventory Wrong
The Cost of a Stockout
When a part is needed and not available, the cost extends well beyond the part itself:
- Production downtime: A manufacturing line stopped waiting for a $40 seal can generate thousands of dollars per hour in lost output
- Emergency procurement: Rush orders and expedited shipping frequently cost three to five times the standard price
- Technician idle time: A maintenance crew standing by while parts are sourced represents paid hours with zero productive output
- Customer or tenant impact: In commercial facilities and service environments, equipment failures have direct service delivery consequences
- Compounding failures: Some equipment failures, if not repaired promptly, cause secondary damage to adjacent systems
Industry estimates place the average cost of unplanned downtime in manufacturing between $50,000 and $250,000 per hour, depending on the industry. Even facilities with more modest downtime costs typically find that stockout-related delays are a significant and largely preventable expense.
The Cost of Overstocking
Excess inventory carries its own real costs that organizations frequently underestimate:
- Carrying costs: Capital tied up in inventory typically costs 20-30% of inventory value annually when financing costs, storage, insurance, and obsolescence are included
- Obsolescence: Parts held for aging equipment that gets replaced represent a complete write-off
- Storage space: Inventory requires shelving, climate control, and physical space that has alternative uses
- Management overhead: More SKUs mean more time spent on cycle counts, organization, and procurement administration
ABC Analysis: Prioritizing Your Inventory Effort
Not all spare parts deserve the same level of management attention. ABC analysis segments inventory by usage value to focus effort where it matters most.
A Items: High Value, High Attention
A items represent roughly 10-20% of SKUs but account for 70-80% of total inventory value. These parts warrant:
- Tight reorder point management with frequent review
- Safety stock calculations based on actual demand variability
- Close supplier relationships and lead time monitoring
- Cycle counts monthly or quarterly
B Items: Moderate Value, Moderate Attention
B items (roughly 30% of SKUs, 15-25% of value) require standard management practices: defined reorder points, periodic review, and semi-annual cycle counts.
C Items: Low Value, Light-Touch Management
C items (50-60% of SKUs, 5-10% of value) are typically inexpensive consumables and fasteners. These are often best managed with simple two-bin systems or high safety stock to minimize management overhead. The cost of a stockout rarely justifies the effort of sophisticated demand planning for a $2 o-ring.
Setting Reorder Points and Safety Stock
The Reorder Point Formula
A reorder point triggers a purchase order when stock falls to a level that covers demand during the procurement lead time.
Reorder Point = (Average Daily Usage x Lead Time in Days) + Safety Stock
Example: A bearing with average usage of 1.5 units per day, a 10-day lead time, and a safety stock of 5 units has a reorder point of (1.5 x 10) + 5 = 20 units.
Calculating Safety Stock
Safety stock protects against two sources of uncertainty: demand variability (you might use parts faster than average) and supply variability (your supplier might deliver late). A simple safety stock formula:
Safety Stock = Z x Standard Deviation of Demand x Square Root of Lead Time
Where Z is a service level factor (1.28 for 90% service level, 1.65 for 95%, 2.05 for 98%).
For most maintenance organizations, a simpler heuristic works well during initial implementation: set safety stock equal to the maximum demand during the lead time minus the average demand during the lead time. This is easy to calculate from historical data and produces reasonable results.
Critical Spares: A Special Category
Some parts fall outside normal reorder point logic entirely. Critical spares for single-point-of-failure equipment — components whose failure would cause catastrophic downtime and which have multi-week lead times — should be stocked regardless of usage frequency. The carrying cost of one spare motor on a shelf is trivial compared to the cost of a three-week lead time on an emergency replacement.
Identify critical spares through a structured criticality assessment: which equipment, if failed and unrepaired for more than 24-48 hours, would cause unacceptable consequences? Stock at least one spare for the highest-failure-risk components of that equipment.
Demand Forecasting for Maintenance Inventory
Unlike manufacturing inventory where bills of materials define demand precisely, maintenance parts demand is probabilistic. These approaches improve forecast accuracy:
Consumption-Based Forecasting
Pull actual parts consumption history from your CMMS work orders. Average monthly usage, adjusted for seasonality (HVAC filters are used more before cooling season; snow removal equipment parts peak in winter), provides a solid baseline demand estimate.
PM Schedule-Driven Demand
Planned maintenance tasks consume parts on a predictable schedule. If you perform 50 annual compressor PMs and each requires a specific filter kit, you know exactly how many filter kits you need per year. This PM-driven demand can be calculated directly from your PM schedule and should be separated from reactive demand in your forecasting model.
Failure Rate-Based Forecasting
For reactive parts, historical failure rates by asset type and age provide probabilistic demand estimates. An asset fleet with a 15% annual bearing failure rate and 200 units in service implies approximately 30 bearing replacements per year — which can be distributed across months based on historical failure seasonality.
Bin Management and Physical Organization
The best inventory data is worthless if technicians cannot find parts quickly or if parts are stored in ways that lead to errors.
Two-Bin System for C Items
For low-value consumables, a two-bin system eliminates complex tracking overhead. When the first bin is empty, move to the second bin and place a reorder. When the replenishment arrives, refill both bins. Simple, visual, and zero administrative burden.
Location Codes and Barcode Labeling
Every storage location should have a unique location code, and every part bin should be labeled with a barcode or QR code. This enables technicians to scan parts out of inventory directly from their mobile device at the point of use — eliminating end-of-shift inventory reconciliation and ensuring consumption is recorded in real time.
Kitting for Scheduled PMs
For preventive maintenance tasks that consume a predictable set of parts, pre-assembling kits before the scheduled work date reduces technician trip time, eliminates parts shortages discovered mid-job, and makes inventory consumption tracking automatic. Kitting is especially valuable for major overhaul PMs that require ten or more parts.
Integrating Inventory With Work Orders
The most powerful lever for improving inventory management is connecting parts consumption directly to work orders in your CMMS.
Parts Request on Work Order Creation
When a technician receives a work order, they should be able to request parts from within the same interface — triggering a pick request to the storeroom or a reservation against available stock. This creates visibility into parts demand before technicians arrive at the asset.
Automatic Inventory Deduction on Work Order Completion
When a technician closes a work order and records the parts used, inventory quantities should update automatically. Manual inventory transactions — updating a spreadsheet, walking to a whiteboard — create friction that leads to inaccurate counts.
Parts Availability Alerts
When a work order references a part that is at or below safety stock, the CMMS should alert the storeroom manager and, if possible, trigger a purchase order automatically. This closes the loop between maintenance demand and procurement without requiring a dedicated review cycle.
Measuring Inventory Performance
Track these metrics to gauge the health of your spare parts program:
- Fill rate: Percentage of parts requests fulfilled from stock without delay. Target 95%+ for critical parts
- Stockout frequency: Number of stockout events per month by part category
- Inventory turnover: Annual parts consumption divided by average inventory value. Low turnover (under 1x) indicates excess stock; high turnover (above 12x) suggests risk of stockout
- Carrying cost as a percentage of inventory value: Benchmark against the 20-30% industry norm
- Obsolescence write-offs: Parts written off annually as a percentage of total inventory value
Conclusion
Spare parts inventory management is not about having every part available at all times — that would require infinite capital and storage space. It is about intelligently matching stock levels to failure risk, criticality, and lead times so that the right parts are available when and where they are needed.
ABC analysis, properly calculated reorder points, safety stock for demand variability, PM-driven demand forecasting, and direct integration with work orders give maintenance organizations a systematic foundation for getting that balance right.
FacilityLane connects inventory directly to work orders, PM schedules, and asset failure history — providing the data foundation for smarter parts decisions and automatic reorder management. See how it works by scheduling a personalized demo with our team.