Open Purchase Orders: Needed-By vs Confirmed Dates, Days Late and the Expedite List
Lessons in this course
- Demand History Cleanup: SKU Codes, Promo and Stockout WeeksFree
- Moving Average Forecast: Simple and Weighted Locked
- Forecast Error: MAD, MAPE and Bias Locked
- Seasonality Index: Spreading an Annual Forecast over Months Locked
- Safety Stock: z × σ × √Lead Time with NORM.S.INV Locked
- Reorder Point and Inventory Position: When to Order Locked
- Projected Inventory Balance: Week by Week Locked
- Order Suggestions: Minimum Order Quantity and Pack Size with CEILING Locked
- ABC Classification: Annual Value and Cumulative Share Locked
- Supplier Lead Times: Average, Variability and On-Time Rate Locked
- Service Level: Unit Fill Rate and Line Fill Rate Locked
- Planner Dashboard: Forecast Chart, Weeks of Cover and Alerts Locked
- Promotion Uplift: Lift Factors from Past Promos, a Promo Forecast and the Extra Order Locked
- From Units to Cartons, Pallets and Trucks: ROUNDUP, Pallet Layers and Truck Fill Locked
- Excess and Slow-Moving Stock: Units Above Target Cover, Excess Value and Weeks Since Last Sale Locked
- Shelf Life and Expiry Risk: FEFO Order, Weeks Left and Units at Risk Locked
- Short Supply: Fair-Share Allocation in Whole Cartons and Fill Rate per Destination Locked
- Stock Across Warehouses: Cover per Site, Surplus, Shortfall and Transfers Locked
- Open Purchase Orders: Needed-By vs Confirmed Dates, Days Late and the Expedite List Locked
- Final Project – Weekly Replenishment Plan: Safety Stock, Reorder Points, Order Quantities, Pallets and Order Value Locked