Tabellab

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.

20 lessons 20 labs Certificate

  • 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

  1. Demand History Cleanup: SKU Codes, Promo and Stockout WeeksLabFree
  2. Moving Average Forecast: Simple and WeightedLab Locked
  3. Forecast Error: MAD, MAPE and BiasLab Locked
  4. Seasonality Index: Spreading an Annual Forecast over MonthsLab Locked
  5. Safety Stock: z × σ × √Lead Time with NORM.S.INVLab Locked
  6. Reorder Point and Inventory Position: When to OrderLab Locked
  7. Projected Inventory Balance: Week by WeekLab Locked
  8. Order Suggestions: Minimum Order Quantity and Pack Size with CEILINGLab Locked
  9. ABC Classification: Annual Value and Cumulative ShareLab Locked
  10. Supplier Lead Times: Average, Variability and On-Time RateLab Locked
  11. Service Level: Unit Fill Rate and Line Fill RateLab Locked
  12. Planner Dashboard: Forecast Chart, Weeks of Cover and AlertsLab Locked
  13. Promotion Uplift: Lift Factors from Past Promos, a Promo Forecast and the Extra OrderLab Locked
  14. From Units to Cartons, Pallets and Trucks: ROUNDUP, Pallet Layers and Truck FillLab Locked
  15. Excess and Slow-Moving Stock: Units Above Target Cover, Excess Value and Weeks Since Last SaleLab Locked
  16. Shelf Life and Expiry Risk: FEFO Order, Weeks Left and Units at RiskLab Locked
  17. Short Supply: Fair-Share Allocation in Whole Cartons and Fill Rate per DestinationLab Locked
  18. Stock Across Warehouses: Cover per Site, Surplus, Shortfall and TransfersLab Locked
  19. Open Purchase Orders: Needed-By vs Confirmed Dates, Days Late and the Expedite ListLab Locked
  20. Final Project – Weekly Replenishment Plan: Safety Stock, Reorder Points, Order Quantities, Pallets and Order ValueLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy