Reorder Point Worksheet

Continuous-review policy: watch inventory position; when position ≤ reorder point, order the fixed quantity Q for that SKU.

Date:  
Review cycle:  
Prepared by:  
Day convention (circle): calendar days / business days — use for BOTH demand and lead time
Definitions. On-hand = sellable units in the store (not damaged/expired/sold). On-order = confirmed open purchase orders (scheduled receipts). Committed = customer backorders — deduct only if your system does not already show an "available" quantity net of them (never deduct twice).
Formulas. Avg daily demand = units sold ÷ days in period (document the period and any adjustment; sales during stockouts understate true demand). Lead-time demand = avg daily demand × lead time (days, order to shelf-ready, from delivery records). Safety stock: days-of-cover = avg daily demand × N days, or max-minus-average = (max daily demand − avg daily demand) × lead time — record the method per SKU below. Reorder point = lead-time demand + safety stock. Inventory position = on-hand + on-order − committed. Order the fixed Q when position ≤ reorder point.
SKU / ItemAvg daily demandLead time (days) Lead-time demandSafety stockSS method (D/M) Reorder pointOn-hand (sellable)On-order (confirmed) CommittedInventory positionOrder?Fixed Q

Rules printed on this sheet: max-minus-average assumes a fixed lead time and the maximum daily demand persisting through the whole lead time — it does not cover late deliveries and achieves no defined service level. Never reorder on on-hand alone — use inventory position, or you will double-order while purchase orders are in transit. Inventory position does not reveal stockout risk before a late order arrives — watch confirmed arrival dates separately. Review reorder points quarterly or after any surprise stockout/overstock. Build them only on numbers you trust — investigate mismatches first. If your chosen fixed Q falls below the supplier minimum (MOQ), decide deliberately: raise Q, drop the SKU, change supplier, or combine orders. Real limits: cash tied up, expiry, shelf/backroom space.