Spare parts inventory for maintenance storerooms
Most spare parts sit for months. The one that matters may be used once in five years, on the day a line stops. The storeroom's job is to have it, find it and know where it went.
Plan criticality-based counts
A maintenance storeroom is an unusual kind of inventory. A few parts, such as filters, belts and fasteners, move every week. Most sit for months. Some are held for a failure that may never come, and when it does, the cost is downtime, not a late order. Maintenance systems (a CMMS or an EAM) are built to plan the work, and the storeroom record is often the part that drifts. We build the stocking rules, counting program and issue tracking that keep it right, connected to the maintenance and purchasing systems you already run.
Stocking rules for intermittent demand
ASCM describes the order point (reorder point) as “normally calculated as forecasted usage during the replenishment lead time plus safety stock”, and safety stock as stock planned “to protect against fluctuations in demand or supply.” The standard safety stock formula, a safety factor times the standard deviation of demand over the lead time, assumes that demand over the lead time is roughly normal.
A part used twice a year does not behave that way. Its average demand over a six-week lead time is about a quarter of a unit, and the formula returns a fraction too. Stocking a slow mover is a decision about risk instead: what a stockout costs, how long the part takes to arrive, and whether the failed part can be repaired. We set rules by class:
- Regular movers such as filters and belts: reorder points and safety stock from issue history. The safety stock calculator and reorder point calculator show the arithmetic.
- Slow movers: a minimum and maximum set by policy, often a minimum of one for anything critical.
- Insurance spares: held by decision, reviewed on a schedule, and kept off the dead-stock report so nobody clears them out to free space.
All of it depends on usage history built from issues to work orders, not from purchase orders.
Criticality-based stocking and counting
Criticality is a rating on each part, based on the equipment it serves and what happens if the part is not there: a stopped line, a safety risk, a workaround, or little effect. We record it on the part, agree how it is set and who can change it, and use it in three places: stocking rules, purchasing priority and counting.
ASCM notes that cycle counts happen more often for high-value or fast-moving items. In a storeroom, critical parts belong on that list too, even when they never move. Counting a critical spare also checks its condition: shelf-life dates, packaging, and the periodic care that stored rotating equipment needs. The cycle count planner sizes the workload by class.
Kitting for work orders
Planned work should not start with a technician searching the shelves. When a work order is scheduled, its parts are reserved, picked into a kit, staged in a marked location with the work order number, and issued by scan when the job starts. Unused parts come back by scan and return to stock. Shortages show up days before the job, while there is still time to buy or reschedule, instead of on the morning of a planned shutdown.
Storeroom issue and return tracking
Every issue should name a work order or an asset. That record is how you learn what each machine actually consumes, and it is the usage history the stocking rules need. The common gaps are after-hours withdrawals and returns that are never recorded. Depending on how your storeroom is staffed, we build scan-based self-checkout, an after-hours log that is reconciled the next morning, or an interface to secured dispensing equipment you already own.
Repairable spares get their own statuses: issued, removed, sent for repair on a purchase order, received back and returned to stock. That way a rebuilt pump is a known asset on a shelf, not a surprise in a vendor’s shop.
Integration with a CMMS or EAM
The maintenance system usually holds assets, work orders and often the parts catalog. The ERP usually holds purchasing, receipts and costs. A storeroom tool sits between them, or inside one of them. During requirements analysis we settle which system is the record for the part master, stock balances and cost. Then we build the interfaces: planned parts and reservations from work orders, issues and returns back to the work order, requisitions to purchasing, and receipts back to stock. That work is described under ERP and WMS integration.
Example (fictional). A corrugated box plant stocks part EX-40217, a gearbox for a conveyor on its main line, with a minimum of one. The maintenance system shows one on hand. When the gearbox fails on a Saturday, the shelf is empty: it was taken two months earlier for another line on a paper slip that was never entered. The written requirement becomes: “Any withdrawal of a part rated critical requires a scan to a work order or asset. A critical part at zero on hand creates a requisition and alerts the maintenance planner the same day. Critical parts are counted monthly.” The acceptance test tries to issue the last critical unit without a work order and checks that the issue is blocked, then issues it with one and checks that the requisition appears.
Where to start
Start with the parts that would stop production. A Scope and plan engagement lists them, records how each is stocked, counted and issued today, and writes requirements with acceptance tests. Criticality ratings and issue tracking make a sensible first build, because the stocking rules depend on both. After go-live, onboarding and training covers storeroom staff and technicians on every shift, and the inventory management software page describes what the build can include.
Scope your project.
Tell us what you need to track, which systems you run and when it has to work. We reply with questions or a time to talk.