Calibrating Sales Forecast in a Pandemic Using Competitive Online Non-Parametric Regression

42 Pages Posted: 13 Aug 2020 Last revised: 11 Apr 2022

See all articles by David Simchi-Levi

David Simchi-Levi

Massachusetts Institute of Technology (MIT) - School of Engineering

Rui Sun

Massachusetts Institute of Technology (MIT) - Institute for Data, Systems, and Society (IDSS)

Michelle Xiao Wu

Massachusetts Institute of Technology (MIT) - Institute for Data, Systems, and Society (IDSS)

Ruihao Zhu

Cornell University; Cornell SC Johnson College of Business

Date Written: August 9, 2020

Abstract

Motivated by our collaboration with Anheuser-Busch InBev (AB InBev), a consumer packaged goods (CPG) company, we consider the problem of forecasting sales under the coronavirus disease 2019 (COVID-19) pandemic. Our approach combines non-parametric regression, game theory, and pandemic modeling to develop a data-driven competitive online non-parametric regression method. Specifically, the method takes the future COVID-19 cases estimates, which can be simulated via the SIR (i.e., Susceptible-Infectious-Removed) epidemic model, as an input, and outputs the level of calibration for the baseline sales forecast generated by AB InBev's offline learning algorithm. In generating the calibration level, we focus on an online learning setting, where our algorithm sequentially predicts the label (i.e., the level of calibration) of a random covariate (i.e., the current number of active cases) given past observations and the generative process (i.e., the SIR epidemic model) of future covariates. To provide robust performance guarantee, we derive our algorithm by minimizing regret, which is the difference between the squared l_2-norm associated with labels generated by the algorithm and labels generated by an adversary and the squared l_2-norm associated with labels generated by the best isotonic (non-decreasing) function in hindsight and the adversarial labels. We develop a computationally-efficient algorithm that attains the minimax-optimal regret over all possible choices of the labels (possibly non-i.i.d. and even adversarial). We demonstrate the performances of our algorithm on both synthetic and AB InBev’s datasets (from March 2020 to March 2021) of three different geographical regions . The AB InBev’s numerical experiments show that our method is capable of reducing the forecasting error in terms of WMAPE (i.e., weighted mean absolute percentage error) and MSE (i.e., mean squared error) by more than 37% for the company.

Keywords: sales forecast, online learning, non-parametric regression, COVID-19 pandemic

Suggested Citation

Simchi-Levi, David and Sun, Rui and Wu, Michelle Xiao and Zhu, Ruihao, Calibrating Sales Forecast in a Pandemic Using Competitive Online Non-Parametric Regression (August 9, 2020). Available at SSRN: https://ssrn.com/abstract=3670264 or http://dx.doi.org/10.2139/ssrn.3670264

David Simchi-Levi

Massachusetts Institute of Technology (MIT) - School of Engineering ( email )

MA
United States

Rui Sun

Massachusetts Institute of Technology (MIT) - Institute for Data, Systems, and Society (IDSS) ( email )

77 Massachusetts Avenue
E18-436
Cambridge, MA 02139-4307
United States

Michelle Xiao Wu

Massachusetts Institute of Technology (MIT) - Institute for Data, Systems, and Society (IDSS) ( email )

United States

Ruihao Zhu (Contact Author)

Cornell University ( email )

Ithaca, NY 14853
United States

Cornell SC Johnson College of Business ( email )

Ithaca, NY 14850
United States

Do you have a job opening that you would like to promote on SSRN?

Paper statistics

Downloads
1,003
Abstract Views
4,808
Rank
46,860
PlumX Metrics