Secondary Sales Demand Forecasting: Beverage Producer


Secondary Sales Demand Forecasting: Beverage Producer


Multinational Brewing Company


Faced with limited product data points, Stemly obtained over 89% forecast accuracy at a monthly level.


  • Demand forecasting for a customer in South America
  • Looking for a step-change in improvement in forecast accuracies
  • Automate understanding of the changes in the demand patterns and ability to get insights.
  • Ability to automate demand review collaborative process with Demand planners, demand managers, sales, and marketing teams
  • Improvements in storage cost to serve and inventory turnovers through forecast accuracy


  • Data received for 465 products from 2014 – May 2019
  • The forecast was conducted for M-1 and M-3 (for Jun-Aug 2019) at two level of:
    • Month / Product / Region / Zone / Channel
    • Month / Product
  • Forecasts generated with multiple statistical (ARIMA, Holt Winter, etc) and machine learning (CatBoost, XG Boost, Random Forest) techniques
  • Analyses:
    • Exploratory Data Analysis
    • Feature engineering and importance
    • Forecasts outputs and error analysis (MAPE)


  • M-1 Forecast accuracy is 89% at the product / monthly level
  • M-3 Forecast accuracy is 84% at the product / monthly level
  • Did not have data on prices and promotions
  • Insights will improve significantly with such data

Related Stories

Dairy & Milk

Primary & Secondary Sales Forecasting: Dairy Producer

Read Story

Product Recipe Blending Optimization: Processing & Manufacturing

Read Story
Global Luxury Cosmetics

Demand Forecasting: E-Commerce

Read Story