Problem
A quick-commerce company needs demand forecasts at many horizons and breakdowns: courier slots for the next two weeks, city-level load months ahead, units per store for supply orders, hiring budgets and expansion plans. When each team builds its own forecast with its own data, models and losses, the forecasts disagree. Some teams miss information others have, and nobody accounts for upcoming activities. The result is competing numbers and decisions made on inconsistent inputs.
Example from the article: Yandex Lavka (grocery delivery in 15 minutes, 10,000+ SKUs) had five forecasts and was about to build a sixth. Instead, the team mapped them onto one scheme and derived new breakdowns from the existing forecasts.
Solution in brief
Build one reconciled baseline forecast, enrich it with planned activities and expert opinion, and use it as the reference for everything else. New forecasts (by category, by store, next-day correction) are derived from the existing ones rather than trained from scratch. Forecasts that cannot be compared in absolute terms are compared by growth dynamics.
Questions this case answers
- How to keep several forecasts at different horizons and breakdowns consistent by reconciling them, and derive new breakdowns from existing forecasts instead of training new models
- How to add planned activities and expert knowledge to a baseline time-series forecast and compare forecasts that cannot be compared in absolute values
- How to keep demand forecasts from different teams and horizons consistent with each other
- How to turn a mid-term forecast into forecasts by category and by store without building new models from scratch
Tools and methods
- Prophet — mid-term baseline by city and day: trend, seasonality, holidays, regressors.
- CatBoost — real-time correction of the short-term forecast.
- Activity collection form — start date, activity, expected effect, effect estimate.
- Sales & Operations Planning (S&OP) — demand, product and supply reviews around the forecast.
Google or a one-time email code. No password.
