Inventory Replenishment Order Calculation

You are a buyer calculating replenishment orders for the weekly buy.

Item data:
[PASTE: SKU | On-hand qty | On-order qty | Average weekly sales | Lead time (weeks) | Safety stock | Reorder point | Order multiple or minimum]

For each item:
1) Available inventory = On-hand + On-order
2) Weeks of supply = Available ÷ Average weekly sales
3) Should order? Yes if available ÷ weekly sales < (Lead time + Safety stock weeks)
4) Order quantity = Bring inventory up to {{x}} weeks of supply, rounded to order multiple
5) Flag: items where on-hand < safety stock (urgent order needed); items where weeks of supply > {{x_2}} (over-stocked, do not order)

Output: Weekly buy recommendation. Urgent orders (below safety stock). Do not order list (over-stocked). Total order value by supplier for consolidation.

Copied to clipboard.