E•ENGINEERING
DESK TOOLS
All guides
Maintenance6 min readUpdated 5 October 2026

Spare parts reorder levels and stock coverage

Separate stock physically available today from inventory position and incoming purchase orders.

Agree the item and the demand basis

A reorder level answers one question: at what stock position should an order be placed so that the part arrives before stock runs out? It needs a single part code, a single unit of issue and an average daily usage taken from a representative period. Record whether you used calendar days or working days, and use the same basis for lead time, because the formula multiplies the two.

Worked example 1. A bearing was issued 26 times in the last 365 days. Average daily usage = 26 ÷ 365 = 0.0712 units per day. With a 28-day lead time, expected demand during lead time is 0.0712 × 28 = 1.99 units, and with a safety stock of 1 unit the reorder point is the next whole number above 1.99 + 1, which is 3 units. Round up, not to the nearest value, because a fractional part is still a unit you would need.

Intermittent demand needs care. Usage for a critical spare may be zero for months and then jump. A small average does not automatically justify holding nothing, so combine the arithmetic with an equipment-risk review.

Separate three stock quantities

The spare parts reorder calculator keeps stock quantities apart because they answer different questions.

QuantityMeaningUsed for
On handPhysically received stockValue, and what a repair can use today
Inventory positionOn hand + incoming − reserved or backorderedReorder trigger and replenishment gap
Available coverage(On hand − reserved) ÷ daily usageDays of supply from shelf stock

Incoming orders count toward the position because an order is already open, but they cannot support a repair before they arrive. Reserved and backordered quantities should not overlap; entering the same unit in both double-counts the commitment.

Calculate the reorder point and the trigger

Reorder point = ⌈daily usage × lead time + safety stock⌉, rounded up to a whole unit. The trigger is met when the inventory position is at or below the reorder point.

Worked example 2. Daily usage is 2 units, lead time is 10 days and safety stock is 5 units. Reorder point = 2 × 10 + 5 = 25 units. On hand is 20, incoming is 5 and commitments are 2. Inventory position = 20 + 5 − 2 = 23. Because 23 is at or below 25, the threshold has been reached even though an order is already open. Available coverage uses shelf stock after commitments: (20 − 2) ÷ 2 = 9.0 days.

A calculator result tells you to look at the order, not to place a duplicate. Check the promised delivery date of the 5 incoming units, because if they arrive late the 9 days of shelf cover is the real protection.

Choose a target and the replenishment gap

Target stock = ⌈daily usage × (lead time + coverage period) + safety stock⌉. Suggested replenishment = the larger of zero and (target − inventory position). The coverage period is the number of additional days of demand you want to buy beyond the lead time.

Worked example 3. Continue example 2 with 5 additional coverage days. Target = 2 × (10 + 5) + 5 = 35 units. Gap = 35 − 23 = 12 units. This is a planning figure, not an economic order quantity, because it does not weigh ordering cost against holding cost.

Worked example 4. A seal has usage of 0.35 units per day, lead time 28 days, safety stock 3, unit cost 320, 6 on hand and nothing incoming or reserved. Reorder point = ⌈0.35 × 28 + 3⌉ = ⌈12.8⌉ = 13. Position = 6, so the trigger is met. With 30 coverage days, target = ⌈0.35 × 58 + 3⌉ = ⌈23.3⌉ = 24, and the gap is 24 − 6 = 18 units, an estimate of 18 × 320 = 5,760. Coverage from shelf stock is 6 ÷ 0.35 = 17.1 days, shorter than the 28-day lead time, which is the practical warning.

If 8 units were already on order and 1 reserved, the position would be 6 + 8 − 1 = 13, exactly at the reorder point, and the gap drops to 11 units (3,520). Shelf coverage would still be (6 − 1) ÷ 0.35 = 14.3 days, so the open order does not cover the lead-time exposure.

Common mistakes

  • Mixing calendar-day usage with working-day lead time, or the reverse.
  • Not rounding up. A reorder point of 12.8 should be treated as 13.
  • Counting incoming orders as shelf stock when calculating days of cover.
  • Subtracting reserved stock twice, or listing the same quantity as both reserved and backordered.
  • Using last year's lead time after repeated late deliveries.
  • Setting safety stock to zero for a critical spare because average usage is low.
  • Ignoring supplier minimum order quantity, pack size and shelf life when reading the gap.
  • Treating the target as an economic order quantity.
  • Averaging demand over a period that includes a one-off shutdown or project.

Checks before you trust the result

  • Verify the usage period and the day basis, and check it against the issue transactions.
  • Check that the unit of issue matches the unit of purchase.
  • Confirm lead time from recent order and receipt dates, not from the quotation.
  • Reconcile on-hand stock to a physical count before reading coverage.
  • Confirm that incoming orders are confirmed and have promised dates.
  • Compare available coverage in days with the lead time; if coverage is shorter, the stock is exposed regardless of position.
  • Check the consequence of stock-out for the equipment before accepting a low safety stock.
  • Review the numbers again after each late delivery or change in demand.

Frequently asked questions

Does the calculator handle intermittent demand?

No. It assumes reasonably steady demand and a safety stock that you choose. For intermittent critical spares add failure history and equipment-risk review.

Why can the trigger be met when an order is open?

The position can still be at or below the reorder point if the open quantity is small relative to demand and commitments. It is a prompt to check, not to duplicate the order.

What if usage is zero?

Coverage cannot be computed and is reported as no recorded usage. The reorder point is then just the safety stock.

Is the replenishment value an order budget?

It is an estimate from unit cost. Confirm price breaks, freight and tax separately.

Recording the data and carrying it into the register

Record usage, lead time, safety stock and the date each was reviewed next to the part code, so a later reader can reproduce the figure. The free spare parts register template has the fields to hold the result: enter the reorder point as the Reorder level (min) and the target as the Maximum level. Remember that the register compares physical quantity on hand with the minimum, while this calculator uses inventory position, so open orders may be visible only here. See the register guide for the columns and statuses, and use downtime cost to document why a critical spare is justified.

Try it with the calculators

Browse all Excel templates and dashboard previews