The project challenges
- The commercial department had one forecast, the marketing representatives had the other. The data and departments conflicted with each other.
- Everything was done in Excel. The company's management was choosing as the sales plan that forecast which was higher.
- Accuracy remained too low. Since the company operates in Russia and CIS countries covering all sales channels, every mistake in the forecast has led to losses.
- In the tea market, 70% of the sales share is promotional. The accuracy of promo forecasting, in fact, is a major part of the accuracy of the whole forecasting demand cycle.
- It was impossible to plan a discount calendar in Excel and keep a track of all the factors that would affect the level of sales with the existing tools. Moreover, it is impossible to correctly calculate the effectiveness of the promotion without an accurate analysis of the sales baseline.