Spare Parts Reorder Calculator - Safety Stock, ROP & EOQ for MRO
Calculate Reorder Points and Safety Stock for Slow-Moving and Fast-Moving Maintenance Spare Parts
Free MRO spare parts inventory calculator for maintenance planners, storeroom managers, and reliability engineers. Enter annual demand, lead time, unit cost, and service level target, and the calculator determines the reorder point (ROP), safety stock, and economic order quantity (EOQ). Uses Poisson distribution for slow-moving items (fewer than 10 uses per year) and normal distribution for fast-movers. Shows the total inventory cost including holding cost, ordering cost, and stockout risk.
Optimize PM intervals to predict part consumption
PM Interval Optimizer →Calculate bearing life to forecast replacement demand
Bearing Life Calculator →Read the spare parts inventory management guide
Spare Parts Inventory Guide →How It Works
-
Enter Demand Data
Input the average annual demand (usage) for the part. For parts consumed during PM tasks, multiply the PM frequency by the quantity per task. For failure-driven replacements, use historical consumption data from your CMMS work order history.
-
Set Lead Time
Enter the supplier lead time in days or weeks. Use the realistic lead time, not the best-case number. If the vendor says 2-4 weeks, use 4 weeks. If you need to include internal procurement processing time, add that to the vendor lead time.
-
Specify Service Level
Choose the target service level (probability of not stocking out during a replenishment cycle). Typical values: 90% for non-critical consumables, 95% for important maintenance parts, 98-99% for critical spares where stockout means production loss.
-
Enter Cost Parameters
Input the unit cost of the part, the annual holding cost rate (typically 20-30% of part value for industrial storerooms), and the cost per purchase order (administrative cost of placing an order, typically $50-150 in industrial settings).
-
Review Results
See the calculated reorder point, safety stock quantity, economic order quantity, and total annual inventory cost breakdown (holding + ordering + expected stockout cost). The calculator indicates whether Poisson or normal distribution was used based on demand velocity.
Built For
- Maintenance planners setting min/max levels in CMMS for PM-driven consumable parts like filters, belts, and seals
- Storeroom managers optimizing safety stock for slow-moving critical spares like specialty bearings and control boards
- Reliability engineers calculating optimal stocking levels for insurance spares on critical equipment
- Procurement specialists determining economic order quantities to balance holding costs and ordering costs
- Plant managers justifying storeroom inventory investment to finance departments with quantified stockout risk
- CMMS administrators building automated reorder triggers based on calculated ROP values
- Maintenance supervisors evaluating vendor-managed inventory proposals against internally optimized stocking levels
Features & Capabilities
Dual Distribution Model
Automatically selects between Poisson distribution (for slow-moving items with fewer than 10 annual demands) and normal distribution (for fast-movers with 10+ annual demands). Slow-moving spare parts do not follow normal distribution assumptions, making Poisson essential for accurate safety stock.
Reorder Point Calculation
ROP = average demand during lead time + safety stock. For normal distribution: safety stock = z-score times standard deviation of demand during lead time. For Poisson: safety stock is derived from the cumulative Poisson probability function at the target service level.
Economic Order Quantity
Classic EOQ formula: sqrt(2 times annual demand times ordering cost / annual holding cost per unit). Shows the order quantity that minimizes total annual inventory cost (holding + ordering). Includes adjustments for minimum order quantities and price breaks.
Total Cost Breakdown
Displays annual holding cost, annual ordering cost, and expected annual stockout cost as separate line items. This makes it clear whether the dominant cost driver is carrying too much inventory or ordering too frequently.
Criticality Adjustment
Select criticality level (A/B/C) to automatically adjust service level targets. Critical-A parts default to 98% service level, important-B parts to 95%, and routine-C parts to 90%. Override manually for specific situations.
Lead Time Variability
Optionally enter lead time standard deviation to account for unreliable suppliers. Variable lead times significantly increase safety stock requirements and are a common source of stockout when ignored.
Frequently Asked Questions
Learn More
MRO Spare Parts Inventory: Reorder Points, Safety Stock, and Storeroom Strategy
How to calculate reorder points and safety stock for maintenance spare parts, handle slow-moving items with Poisson distribution, and build a storeroom strategy that balances cost against stockout risk.
Related Tools
Shop Heater BTU Sizing Calculator
Calculate the exact BTU output your shop or garage heater needs. Factors in wall R-values, ceiling insulation, slab edge loss, overhead door infiltration, and air changes per hour to size propane, natural gas, and electric heaters correctly.
Overhead Door Infiltration Loss Calculator
Calculate heat loss through overhead doors in shops, garages, and warehouses. Compares open-door vs closed-door losses, seal condition impact, and annual cost of infiltration with payback on door seals and high-speed doors.
Long-Run Voltage Drop Calculator
Calculate voltage drop for long wire runs to detached shops, barns, garages, and outbuildings. Compares copper vs aluminum, shows motor starting voltage impact, and recommends the right wire size for your distance and load.