Tabellab

Reorder Point and Inventory Position: When to Order

Lesson 6 of 20 Lab 🔒 Locked

Lessons in this course

  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