Retail Inventory Optimization and Auto-Replenishment

Retail & E-commerce — Across 120 stores and two warehouses, safety stock followed rules of thumb, locking cash into slow-selling items. Results: Working…

Client: Retailer with Multiple Locations. Sector: Retail & E-commerce.

The challenge: Across 120 stores and two warehouses, safety stock followed rules of thumb, locking cash into slow-selling items.

What we built: Demand forecasts for each store drive a safety-stock and reorder-point model based on target service levels, and daily replenishment orders flow straight into the ERP.

Tech used: statsforecast, Python, dbt, Snowflake, ERP Integration.

  • Working Capital Tied Up: -20%
  • Fill Rate: 97%
  • Stores Covered: 120
  • Manual Ordering: -90%