CMMS, EAM & Spare Parts Management calculator

Spare Parts Fill Rate Calculator

Spare parts fill rate is the percentage of valid maintenance parts requests that the storeroom can satisfy immediately from on-hand stock, without a rush order or a wait. It is the single most-watched service metric for an MRO storeroom because a part that isn't there when a technician needs it can stall a critical repair and extend equipment downtime. Reliability managers, storeroom leads, and CMMS administrators use fill rate to balance carrying cost against availability — too low and machines wait on parts, too high and you've over-invested in slow-moving inventory. It directly connects storeroom stocking policy (min/max levels, ROP, safety stock) to the maintenance team's wrench time and ultimately to plant uptime.

What this calculator does

  • Measure spare parts fill rate by comparing parts requests filled from stock with total valid MRO parts requests.
  • a maintenance or asset-management team needs to evaluate service level, reorder points, supplier performance, and storeroom stocking effectiveness for a MRO parts demand period
  • It computes the share of valid spare parts requests filled immediately from stock and how that fill rate compares to your target.

Formula used

  • Spare Parts Fill Rate rate = parts requests filled immediately from stock ÷ valid spare parts requests × 100
  • Spare Parts Fill Rate gap to target = spare parts fill rate rate - target parts fill rate

Inputs explained

  • parts requests filled immediately from stock: Count only work orders, assets, parts requests, cycle-count lines, or records that meet the stated maintenance or storeroom requirement.
  • valid spare parts requests: Use the matching total due, reviewed, counted, requested, or scheduled population from the same site and reporting period.
  • target parts fill rate: Enter the approved KPI target, service level, audit expectation, or internal maintenance control limit.

How to use the result

  • Use it monthly or per period to grade storeroom service and to decide whether stocking levels on critical and high-velocity parts need adjusting.
  • A high fill rate alone can mask overstocking; pair it with inventory turns and stockout-on-critical-parts data to judge whether the result is healthy or just expensive.

Common questions

  • How do you calculate spare parts fill rate? Divide the parts requests filled immediately from stock by the number of valid spare parts requests, then multiply by 100. With 1,280 of 1,450 requests filled from stock, the fill rate is 88.3%.
  • What is a good spare parts fill rate? World-class MRO storerooms often target 95-97% overall, with near-100% on critical spares. The example's 88.3% sits 6.7 points below a 95% target, indicating stocking gaps on parts technicians actually ask for.
  • What's the difference between fill rate and service level? Fill rate measures the fraction of demand met from stock (line or request based), while service level (cycle service level) is the probability of not stocking out in a replenishment cycle. Fill rate ties more directly to technician experience at the counter.
  • Should I count backorders as filled? No. Fill rate counts only requests satisfied immediately from on-hand stock. A request that becomes a backorder or rush order is a miss, even if it's eventually fulfilled.
  • Why is my fill rate below target even with high inventory value? Inventory dollars often pile up on slow-moving or wrong parts. If your 88.3% sits under a 95% target, you likely have the wrong mix — stockouts on fast-moving critical spares while capital sits in rarely-requested items.

Last reviewed 2026-05-12.