| SKU / Item | Avg daily demand | Lead time (days) | Lead-time demand | Safety stock | SS method (D/M) | Reorder point | On-hand (sellable) | On-order (confirmed) | Committed | Inventory position | Order? | 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.