Inventory replenishment
Calculates weekly demand from recent sales, accounts for on-hand and on-order inventory, and generates order quantities by vendor
How it works
-
Upload a completed replenishment plan
A workbook from a previous cycle, including the vendor summary used by buyers to create purchase orders
-
Add the planning inputs
The inventory snapshot, recent sales history, open purchase orders, the reorder policy, and the SKU and vendor master
-
Skipper learns the inventory planning rules
How the sales history determines average weekly demand, how lead time and safety stock determine target inventory, whether allocated units count as available, and how net requirements round to full case packs
-
Upload the new inventory snapshot for each review
Skipper recalculates the plan, groups orders and values by vendor, and lists SKU-level exceptions
Input files
- inventory_snapshot_202X-07-31.xlsx On-hand and allocated quantities by SKU and warehouse as of the snapshot date
- sales_history_8_weeks.xlsx Units sold by SKU by week, over the window used to derive demand
- open_purchase_orders.xlsx Quantities already on order, with expected receipt dates
- reorder_policy.xlsx Safety stock weeks, review period, and target weeks of supply by category
- sku_vendor_master.xlsx Vendor, unit cost, case pack, and lead time for each SKU
Output workbook
replenishment_plan_202X-07.xlsx
- Summary SKUs below target weeks of supply, total order value, and exceptions
- Replenishment Plan On-hand and on-order quantities, average weekly demand, target stock, net requirement, and the case-pack order quantity
- Vendor PO Summary Suggested units and order value by vendor
- Checks Reconciliation of plan quantities to the inventory snapshot and sales history