Maintenance storerooms balance availability against capital, storage, obsolescence, and purchasing cost. Reorder-point, safety-stock, and economic-order-quantity formulas are useful worksheets, but they are only as good as the demand history, supplier lead-time data, cost basis, and criticality review behind them.
MRO spare parts often include slow-moving and intermittent items. A local Poisson prompt can be useful for low annual issue counts, while a normal prompt can be useful for faster-moving consumables. Neither branch proves the part history fits the model. Treat the math as a source-aware screen that must be reconciled with CMMS/ERP records, OEM support, shelf life, vendor constraints, production consequence, and qualified maintenance/supply-chain review.
ABC Segmentation: Not All Parts Are Equal
Segmentation starts by separating spend, demand velocity, and consequence. ABC analysis is often used to rank annual spend, but the exact cutoffs are site policy and data-quality decisions rather than universal constants.
Higher-spend and higher-consequence items usually deserve more frequent review, cleaner demand history, tighter source control, and active vendor management. Lower-spend consumables may use simpler min/max review, but the chosen policy still needs cycle-count accuracy and procurement approval.
But ABC alone is insufficient for MRO. A cheap consumable (like a V-belt) might be a C item by spend but is needed immediately when it breaks. A $10,000 spare motor might be an A item by spend but is only needed once every five years. You need a second dimension: criticality.
VED (Vital, Essential, Desirable) or a similar criticality score adds the consequence of stockout. A vital spare whose absence creates safety, environmental, regulatory, or production consequences may justify a higher service-level prompt than its spend category suggests. A desirable spare with tolerable downtime may use a lower prompt. The target should be set by operations, reliability, safety, finance, and procurement review before the arithmetic is treated as a stocking policy.
AV (high-spend, vital): tight source control and high review priority
AE, BV: active review and vendor/lead-time checks
AD, BE, CV: moderate review with documented assumptions
BD, CE, CD: simpler controls only when downtime and safety consequences are acceptable
Spare Parts Reorder Calculator
Calculate reorder points, safety stock, and economic order quantities for MRO spare parts. Uses Poisson distribution for slow-moving items and normal distribution for fast-movers.
Reorder Point and Safety Stock: The Math
The reorder point (ROP) is the inventory level at which you place a replenishment order. It equals the average demand during lead time plus safety stock: ROP = d * L + SS, where d is average daily demand, L is lead time in days, and SS is safety stock.
Safety stock is the buffer against variability. For fast-moving items (10+ units per year), the normal distribution works: SS = z * sigma * sqrt(L), where z is the z-score for your target service level (1.28 for 90%, 1.65 for 95%, 2.33 for 99%), sigma is the standard deviation of daily demand, and sqrt(L) scales for the lead time period.
For slow-moving items (fewer than 10 per year in the ToolGrit screen), the app switches to a Poisson prompt because demand is discrete and low-count. This is still a simplified local model. Intermittent bursts, shutdown work, repair campaigns, obsolete parts, and insurance spares may need a different review method.
Example: a part with annual demand of 4, lead time of 3 months, and a 95% cycle-service prompt has mean demand during lead time = 4 * (3/12) = 1.0 units. A Poisson CDF review gives P(X=0) = 0.368, P(X<=1) = 0.736, P(X<=2) = 0.920, and P(X<=3) = 0.981. The local prompt would be ROP = 3 units, but field use still depends on criticality, lead-time confidence, supplier options, and approval workflow.
ROP = d × L + SS
Fast-movers (normal): SS = z × σ × √L
Slow-movers (Poisson): SS from CDF lookup at target service level
Service level z-scores:
90% → z = 1.28
95% → z = 1.65
99% → z = 2.33
Economic Order Quantity for MRO
The economic order quantity (EOQ) balances ordering costs against holding costs. The classic formula is: EOQ = sqrt(2 * D * S / H), where D is annual demand, S is the cost per order (administrative processing, receiving, inspection), and H is the annual holding cost per unit (unit cost times holding rate percentage).
For higher-volume consumables like filters and gaskets, EOQ can expose whether the entered ordering-cost and holding-cost assumptions point toward larger or smaller order quantities. If you use 500 filters per year at $10 each, with a $75/order assumption and 25% holding-rate assumption, EOQ screens to about 173 filters per order. That result is only useful if the cost basis, shelf life, storage capacity, vendor terms, and issue history are source-backed.
For slow-moving items, EOQ may be less important than criticality and availability review. A low mathematical order quantity does not decide whether an insurance spare should be stocked, and it does not override OEM support, shelf life, or downtime consequence.
EOQ should be reconciled against minimum order quantities (MOQs), price breaks, package quantities, shelf life, revision control, and supplier lead-time behavior. A mathematically optimal EOQ of 15 is not directly actionable if the vendor minimum is 50 or if the part expires before use.
EOQ = √(2 × D × S / H)
D = annual demand (units)
S = entered cost per order
H = annual holding cost per unit = unit price × holding rate
Use finance-approved cost basis before relying on the result.
Insurance Spares: When Statistics Do Not Apply
Insurance spares are components stocked not because they are consumed regularly but because the consequence of not having one when needed is catastrophic. A $50,000 motor for a critical production line that fails once every 10 years but takes 16 weeks to procure is an insurance spare. Statistical demand models (Poisson, normal distribution) are not useful here because there is no meaningful demand history to analyze.
The stocking decision for insurance spares is a risk analysis, not a demand forecast. The review should ask what downtime can be tolerated, whether repair or rental alternatives exist, whether the OEM still supports the part, whether a stored spare will remain usable, and who has authority to approve the capital tied up in inventory.
Insurance spares can be expensive to carry. A high-value motor sitting on a shelf creates capital, storage, preservation, obsolescence, and testing questions. The justification should come from documented consequence and source-backed alternatives, not from a statistical reorder-point formula alone.
Review insurance spares annually. Equipment retirements, obsolescence of spare parts, and changes in vendor lead times can all change the stocking decision. A motor that used to take 16 weeks might now be available from a third-party rebuilder in 4 weeks, reducing the need to stock a new spare.
Measuring Storeroom Performance
You cannot improve what you do not measure. Common MRO storeroom metrics include cycle service level, fill rate, inventory turnover, stockout frequency, dead or inactive stock, issue-history accuracy, receiving accuracy, and cycle-count accuracy. Targets should be set by site policy, part class, and consequence, not copied blindly from a generic benchmark.
Service level is only one metric. High service level with low inventory value may be the goal for some parts, while safety-critical or production-critical spares may justify different tradeoffs. Achieving any target requires accurate demand data, reliable lead-time review, receiving discipline, issue tracking, and cycle counting.
Inventory turnover for MRO storerooms can be lower than manufacturing or retail because many MRO items are slow-moving or consequence-driven. Low turnover is not automatically bad if the item is a justified insurance spare, and high turnover is not automatically good if it creates repeated stockouts.
Inactive stock review should separate obsolete parts from justified insurance spares. Equipment status, revision level, shelf life, OEM support, repair alternatives, and disposal value should be checked before scrapping, retaining, or buying more.
Cycle service level and fill rate by part class
Inventory turnover interpreted with criticality
Inactive stock split into obsolete vs justified spares
Inventory accuracy and cycle-count variance
Stockout frequency with downtime consequence