I've walked into a lot of maintenance storerooms, and I can count on one hand the ones where the system matched the shelf. The finished goods warehouse at the same plant is often at 97 percent or better. The storeroom down the hall is at 60.
That isn't because maintenance people are careless. The storeroom serves a different kind of work, and most of the controls in it were designed for a shipping warehouse.
The 2 AM problem
A line goes down on third shift. The mechanic needs a bearing, a seal kit and a proximity sensor, and the storeroom attendant went home at 4:30.
So the mechanic grabs a key, or finds the door propped open, takes the parts and fixes the line. That's the right call. Production is losing thousands of dollars an hour.
What doesn't happen is the issue transaction. Nobody keys it in at 2 AM, and by morning nobody remembers exactly what was taken. Add a few breakdowns a week and the counts are fiction within a quarter.
Locking the storeroom tighter doesn't work. People find a way in when a line is down, and they should. What works is a way to record it that takes under 30 seconds: a clipboard on the door with part number, quantity, work order and initials, or a shared tablet with a scan and a quantity field and nothing else.
Then someone on day shift enters that log first thing every morning. That's the step that gets skipped, so put it on a named person's checklist. "The storeroom" isn't a person.
No issue transaction during the day, either
Plenty of storerooms don't have a clean issue process even when staffed. Parts get handed across a counter with "I'll put it on the work order later," and later rarely comes.
The cause is usually that issuing a part takes too many screens. If a mechanic has to find the work order, look up the part and fill in four fields, they'll skip it.
Set the rule that nothing leaves without a work order number, then make the transaction as short as you can. Scan the work order, scan the part, enter a quantity. If your maintenance system can't do that, a paper issue ticket entered in batches twice a day beats a slow screen nobody uses.
Duplicate part numbers
This is the quiet one. The same bearing lives in your system three times: under the manufacturer's number, under the machine builder's number, and under an internal number somebody made up in 2014.
Each record has its own count, and the shelf has one bin with eleven bearings in it. One record says 4, one says 0, one says 9. Purchasing sees zero on the record they use and orders more.
I routinely find 10 to 20 percent duplication in MRO item masters. It inflates inventory value and causes stockouts at the same time, which is an impressive trick. The cleanup goes like this:
- Export the item master with description, manufacturer and manufacturer part number.
- Sort by manufacturer part number and flag exact matches.
- Normalize the descriptions (strip spaces, make "BRG" and "BEARING" the same word) and review near matches by hand.
- Merge into one record per physical part, with cross-references for the other numbers.
- Write a rule for creating new parts, and give one person the authority to do it.
Step 5 is what keeps it clean. Skip it and you'll be back at 15 percent duplicates in three years.
Rebuilt parts
Gearboxes and pumps often get pulled, sent out for rebuild and returned to stock. That gives you one part in three states: new, waiting for rebuild, and rebuilt.
Most systems treat all three as the same item at the same cost. So a dead pump on a pallet waiting for the repair shop counts as an available spare, and when the line goes down, somebody grabs it.
Give each state its own identity, whether that's an item number with a suffix, a separate location or a status code. What matters is that "ready to install" only counts things that are ready to install. Keep cores waiting for rebuild in their own tagged area. A shelf labeled NOT AVAILABLE works better than you'd expect.
Free stock and private stashes
Many storerooms run free-issue bins for fasteners and consumables, and that's fine. Counting every bolt is a waste of time.
The trouble starts when free stock creeps. Someone drops a box of $40 fittings into a free bin because it's convenient, and now they're untracked. Set a dollar threshold, something like $5 a unit, above which items have to be tracked.
Then there are the private stashes: toolboxes and cabinets full of parts mechanics squirreled away because they didn't trust the storeroom. A policy won't fix that. Make the storeroom trustworthy and the stashes shrink on their own.
Counting slow movers
Many MRO parts move once or twice a year, so a count schedule built on ABC value alone misses the ones that matter. I count on two triggers. Count any part when it's issued, as part of the issue, since the person is standing at the shelf anyway and it takes about ten seconds. And count critical spares on a fixed schedule, quarterly at minimum, whether they've moved or not.
Where to start
Don't fix all of this at once. Start with the after-hours log and the work order rule, because together they stop new errors piling up. Then do the duplicate cleanup, then separate the rebuilt parts. Most of it comes down to clear rules and one person who owns them.