Excel for Supply Planners: Demand Forecast, Safety Stock & Replenishment
20 hands-on labs for new demand and supply planners: clean demand history, moving average forecasts, MAD, MAPE and bias, season index, safety stock with NORM.S.INV, reorder point, projected inventory balance, MOQ and pack-size orders, ABC classes, supplier lead times, fill rate, a planner dashboard, promotion lift, cartons, pallets and trucks, excess and slow movers, shelf-life risk, fair-share allocation, warehouse rebalancing, open purchase orders and a weekly replenishment plan.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This beginner course teaches the Excel work of a demand and supply planner in 20 interactive labs, following Maya, a new planner at the fictional Lakeshore Kitchenware. You clean the demand history, build simple and weighted moving averages, measure MAD, MAPE and bias, spread an annual forecast with season indices and set safety stock with NORM.S.INV. You calculate reorder points, roll a projected inventory balance forward, turn needs into MOQ and pack-size orders, rank items with ABC classes, rate supplier lead times and fill rates and build a planner dashboard. The later labs plan promotion lifts, convert orders into cartons, pallets and trucks, value excess and slow-moving stock, calculate shelf-life risk under FEFO, share short supply fairly, rebalance stock between warehouses, chase late purchase orders and run a complete weekly replenishment plan. Every cell is checked instantly.
Lessons
- 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
Learner reviews
Be the first to review this course.