Before
- Weekly gut-feel forecasting for hundreds of promo SKUs
- Forecast variance swinging wildly up to ±44%
- Simultaneous overstocks and stockouts in the same store
- 30 hours/week locked in spreadsheet forecasting
Measured result
€593K
promo sales protected
303
sold-outs prevented
Rohlik planners forecast hundreds of promo SKUs each week across five country operations.
Forecast variance ranged from ±20% to ±44%, creating simultaneous overstocks and stock-outs in the same store.
Spreadsheet forecasting also consumed 30 planner hours per week, leaving less capacity for longer-term demand work and category strategy.
Before
After Duvo
Our planners used to spend 30 hours a week trapped in spreadsheets, running gut-feel forecasts that often led to simultaneous overstocks and stockouts. Now that Duvo runs daily forecasting from primary signals and automatically places the orders, we've eliminated quarterly disaster weeks and returned nearly four FTEs of capacity to long-horizon demand planning.
Supply Chain Director
Rohlik Group
Pulls the data
Duvo pulls campaigns, sales history, availability and pricing data daily across all 5 markets.
Generates the forecast
Duvo turns the campaign, sales, availability, and pricing inputs into a daily per-SKU forecast.
Places the order
Places the order automatically based on the generated forecast.
Flags exceptions
Flags missing data via Slack for the planner to resolve, so they spend time on exceptions, not running the forecast itself.
Evidence status
Measured result
Rohlik directly measured 303 sold-outs over the live forecasting period. The €593K result equals sold-outs multiplied by average promo-SKU revenue contribution.
Systems involved
Data warehouse, Ordering system, Slack
Control points