Warehouse Inventory Optimization & Replenishment

E-commerce & Retail: Safety stock was set by rule of thumb across 120 stores and two warehouses, tying up cash in slow movers. Working Capital -20%, Fill…

Client: Multi-location Retailer. Industry: E-commerce & Retail.

Challenge: Safety stock was set by rule of thumb across 120 stores and two warehouses, tying up cash in slow movers.

Solution: Store-level demand forecasts feed a service-level-based safety-stock and reorder-point model, with daily replenishment orders pushed into the ERP.

Technologies: statsforecast, Python, dbt, Snowflake, ERP Integration.

  • Working Capital: -20%
  • Fill Rate: 97%
  • Stores: 120
  • Manual Orders: -90%