Spare Parts Tracking Without a Warehouse System

The 80/20 rule for maintenance parts

Most small factories stock somewhere between 50 and 500 unique maintenance parts. That sounds like a lot to manage, but the 80/20 rule applies here: roughly 20% of your parts cover 80% of your scheduled PMs. Filters, belts, bearings, O-rings, lubricants, and a handful of machine-specific items make up the core.

Start there. You don't need to catalog every washer and bolt on day one. Identify the parts that show up on your PM checklists, make sure you're tracking those, and expand later. Trying to inventory everything at once is the fastest way to abandon the project.

Why “we'll order it when we need it” costs 2–3x more

The reactive ordering strategy sounds reasonable until you do the math. When a PM is due and the part isn't in stock, one of three things happens:

1. The PM gets deferred — you push it out until the part arrives. The machine keeps running without the service, accumulating wear. Deferred PMs are how $50 filter changes turn into $5,000 pump replacements.
2. You pay for expedited shipping — overnight freight on a $12 filter costs $45. That's $57 for a filter. Do that 20 times a year and you've spent $900 in unnecessary shipping.
3. Someone makes an emergency run to the supply house — a tech drives 30 minutes each way, spends 15 minutes finding the part, and pays retail. You've lost an hour of labor plus the markup. And the machine sat idle the whole time.

Planned ordering is cheaper in every dimension: lower part cost (you can buy in reasonable quantities), standard shipping rates, and zero downtime waiting for parts.

Setting reorder points that actually work

A reorder point is the inventory level that triggers a purchase. The formula is straightforward:

Reorder Point = (Usage Rate × Lead Time) + Safety Stock

Let's make that concrete. Say you use 4 hydraulic filters per month and your supplier delivers in 5 business days (roughly one week). Your usage during lead time is 1 filter. Add 1 filter as safety stock, and your reorder point is 2.

When your stock drops to 2 filters, the alert fires, you place the order, and the new filters arrive before you run out. No emergency, no expedited shipping, no deferred PM.

For critical parts with long lead times (specialty bearings, OEM-only components, imported seals), bump the safety stock higher. A 6-week lead time on a $200 bearing means you might keep 2–3 on hand. The carrying cost is trivial compared to the downtime risk.

Organizing your parts room

The most common way to organize a maintenance storeroom is alphabetically. It's also the worst way. Nobody remembers whether the item is called a “drive belt,” a “V-belt,” or a “motor belt.”

Instead, organize by equipment. All the parts for Press #3 go in one section. All the parts for the air compressor go in another. When a tech grabs the PM checklist for Press #3, they walk to one shelf and find everything they need.

• Label every bin — part number, description, the equipment it serves, and the reorder point
• Use a consistent location system — aisle-shelf-bin (e.g., A-3-2) so techs can find parts without a scavenger hunt
• Keep high-use items at eye level — filters and lubricants that get pulled weekly shouldn't be on the top shelf
• Lock the room or cage — not because you don't trust your people, but because uncontrolled access makes accurate counts impossible

Linking parts to PMs

The real power of tracking parts in your maintenance system — rather than a separate spreadsheet — is the link between parts and PM tasks. When you create a PM schedule for “Change hydraulic oil filter on Press #3 every 500 hours,” you attach the specific filter part number to that PM.

This gives you two things:

• Pre-staging — the tech knows what to grab before they walk to the machine, not after they've already started the job and found out they need a gasket they don't have
• Automatic consumption tracking — when the PM is completed, the part is logged as used. No separate step, no manual inventory adjustment.

Without this link, you're relying on someone to remember to update the inventory count. That works for about two weeks before the counts drift and the reorder alerts stop being accurate.

Tracking parts cost per asset

Once you're logging parts consumption against specific equipment, you unlock one of the most useful reports in maintenance: parts cost per asset over time.

This is how you identify money pits. Maybe your #7 press consumes $1,200/month in hydraulic seals while every other press averages $200. That's not a parts problem — it's a machine problem. The cylinder is scored, the alignment is off, or the operating pressure is too high. Without the data, you'd never notice because each individual seal replacement seems routine.

Parts cost data also feeds capital planning. When repair and parts costs on a machine exceed 40–50% of the replacement cost per year, it's time to start budgeting for a new one. That's a conversation backed by numbers, not gut feeling.

What you don't need

Let's be clear about what small maintenance teams can skip:

• Barcode scanners — nice to have, not necessary. Manual counts and check-out logging work fine under 500 SKUs.
• Warehouse management software (WMS) — these are built for distribution centers moving thousands of SKUs daily. Your maintenance storeroom is not that.
• Purchase order automation — a reorder alert that emails the right person is plenty. Full PO workflows add complexity without adding value at this scale.
• ABC classification analysis — useful in theory, overkill in practice for a 100-part storeroom. Just track everything and set reorder points.

Getting started this week

1. Pull your PM checklists — identify every part referenced in your active PM schedules. This is your starting inventory list.
2. Count what's on the shelf — walk the storeroom with a clipboard. Record part number, description, quantity on hand, and location.
3. Set reorder points — use the formula above. Estimate usage rates from your PM frequency and adjust after 90 days of actual data.
4. Link parts to PMs in your system — attach the filter part number to the filter change PM. Attach the belt to the belt replacement PM. This is the step that makes everything else work.
5. Designate who orders — reorder alerts need a human at the other end. Assign one person to receive alerts and place orders.

The goal isn't warehouse-grade inventory management. It's making sure the $12 filter is on the shelf when the $200/hour machine needs it. That's a solvable problem — and it doesn't require enterprise software to solve it.