Skip to main content
Back to case studies
Supply Chain

Inventory Optimization System

Regional Grocery & General Merchandise Retailer — 180 stores across 6 states.

2025

18%
Faster Turnover
-62%
Stockout Rate
$28M
Working Capital Freed
-59%
Markdown Losses

The challenge

What we found.

A regional retailer operating 180 stores across 6 states was losing market share due to inventory issues. They faced an 8.2% stockout rate on high-velocity items, while simultaneously holding $34M in dead stock annually.

Their legacy forecasting system used simple moving averages and couldn't handle local demand variations, weather-driven shifts, or promotional cannibalization. Inventory turnover was lagging at 8.4× vs. industry leaders at 12–14×.

The approach

How we built it.

PRR implemented a multi-echelon inventory optimization system:

  • Demand sensing ML models incorporating POS data, weather, local events, and competitor pricing
  • Network optimization to determine optimal inventory positioning across 12 DCs and 180 stores
  • Automated replenishment with dynamic safety stock and reorder points by SKU-location
  • Markdown optimization using price elasticity models to minimize end-of-season losses
Optimization Loop
  1. 01
    Sense
    Multivariate demand signal
  2. 02
    Optimize
    Multi-echelon positioning
  3. 03
    Act
    Auto-replenishment

The outcome

The impact.

MetricBeforeAfterImprovement
Stockout rate8.2%3.1%-62%
Inventory turnover8.4×11.2×+33% faster
Dead stock value$34M$19M-44%
Markdown losses22%9%-59%
Annual impact: $28M working capital freed + $12M reduced markdowns

Stack

Tools used.

Azure Machine LearningAzure Synapse AnalyticsProphet + Custom ModelsJDA / Blue Yonder IntegrationPower BI

Optimize your supply chain.

Move inventory faster and smarter. Let's optimize your network flow.