Module 6.1: Inventory Optimization

  • ABC/XYZ inventory classification
  • Economic Order Quantity (EOQ) analysis
  • Safety stock calculations
  • Reorder point optimization
  • Inventory simulation modeling

Module 6.2: Warehouse Analytics

  • Slotting optimization analysis
  • Pick path analysis
  • Labor productivity metrics
  • Warehouse capacity utilization
  • Analyzing warehouse KPIs

Module 6.3: Network Optimization

  • Distribution center location analysis
  • Transportation route optimization
  • Network modeling techniques
  • Cost-to-serve analysis by customer/product
  • Make vs. buy analysis

Hands-On Exercise:

  • Perform ABC analysis on 1000 SKUs
  • Calculate optimal safety stock levels
  • Analyze warehouse picking efficiency
  • Create a cost-to-serve model by customer segment

Tools Covered: Excel Solver, optimization software introduction