'Spare Parts List Template'

Reduce stockouts and excess inventory simultaneously

Bad spare parts management costs money in two directions: over-stocking ties up capital in slow-moving inventory ($50K-$300K of dust-collecting spares is common in unmanaged SMB operations), and under-stocking causes repair delays (a 2-hour repair becomes 2 days when the right part is out of stock). This template helps you build a parts register that addresses both problems by linking parts to assets, setting min/max stock levels, and tracking consumption against work orders.

Step 1: ABC classification

ABC analysis sorts parts by consumption value:

Step 2: Criticality overrides ABC

ABC tells you about cost and usage. It does not tell you about consequence. A part that is rarely used (C class) but catastrophic when unavailable (production stops, safety risk, regulatory citation) still needs minimum stock regardless of usage. Assign a separate criticality rating — Critical / Important / Standard — to every part. Critical C parts get minimum stock of at least 1 unit even when consumption is rare.

Step 3: Setting minimum stock levels

Formula: Min = (Average daily usage × Supplier lead time in days) + Safety stock. Example: hydraulic seal used 2 per week, 5-day supplier lead time. Daily usage = 0.28. Lead-time consumption = 0.28 × 5 = 1.4. Safety stock for A part = 2 weeks consumption = 4. Minimum = 1.4 + 4 = 5.4 → round up to 6 units. Safety stock guidelines:

Step 4: Linking parts to assets

The most powerful spare parts practice is linking parts to the assets that consume them. When a technician completes a PM and logs a filter change, the inventory automatically decreases by one filter. When stock drops below minimum, an alert fires. Without this linkage, parts counting is manual and surprises happen — "we are out of bearings" arrives at the worst possible moment, during an emergency repair. In the spreadsheet template, link parts to assets via the "Linked asset(s)" column. In a real CMMS like Maintoro, this linkage is automatic when parts are issued through work orders.

Common mistakes in parts inventory

Five most common mistakes:

Beyond spreadsheets — automated parts management

Modern CMMS like Maintoro automates the parts-to-work-order linkage and surfaces real-time low-stock alerts. Issue a part to a work order on mobile during a repair — inventory automatically decreases. Stock drops below minimum — alert fires to maintenance manager. Reorder triggers can integrate with procurement systems via API. Most SMB teams report carrying-cost reductions of 15–30% within the first year of structured parts management, with simultaneous reduction in stockout-driven repair delays.

Reduce stockouts and excess inventory simultaneously

Step 2: Criticality overrides ABC

Step 3: Setting minimum stock levels

Step 4: Linking parts to assets

Beyond spreadsheets — automated parts management

Spare Parts List Template

What is included

Reduce stockouts and excess inventory simultaneously

Step 1: ABC classification

Step 2: Criticality overrides ABC

Step 3: Setting minimum stock levels

Step 4: Linking parts to assets

Common mistakes in parts inventory

Beyond spreadsheets — automated parts management

Parts inventory in Maintoro

Spare Parts List Template

What is included

Reduce stockouts and excess inventory simultaneously

Step 1: ABC classification

Step 2: Criticality overrides ABC

Step 3: Setting minimum stock levels

Step 4: Linking parts to assets

Common mistakes in parts inventory

Beyond spreadsheets — automated parts management

Parts inventory in Maintoro