IDEAS home Printed from https://ideas.repec.org/a/inm/ormnsc/v70y2024i10p6502-6518.html
   My bibliography  Save this article

Calibrating Sales Forecasts in a Pandemic Using Competitive Online Nonparametric Regression

Author

Listed:
  • David Simchi-Levi

    (Institute for Data, Systems, and Society, Massachusetts Institute of Technology, Cambridge, Massachusetts 02139; Department of Civil and Environmental Engineering, Cambridge, Massachusetts 02139; Operations Research Center, Massachusetts Institute of Technology, Cambridge, Massachusetts 02139)

  • Rui Sun

    (Amazon, Seattle, Washington 98109)

  • Michelle Xiao Wu

    (Institute for Data, Systems, and Society, Massachusetts Institute of Technology, Cambridge, Massachusetts 02139)

  • Ruihao Zhu

    (SC Johnson College of Business, Cornell University, Ithaca, New York 14853)

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 nonparametric regression, game theory, and pandemic modeling to develop a data-driven competitive online nonparametric regression method. Specifically, the method takes the future COVID-19 case estimates, which can be simulated via the susceptible-infectious-removed (SIR) epidemic model as an input, and outputs the level of calibration for the baseline sales forecast generated by AB InBev. 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 ℓ 2 -norm associated with labels generated by the algorithm and labels generated by an adversary and the squared ℓ 2 -norm associated with labels generated by the best isotonic (nondecreasing) 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 data sets of three different markets (each corresponds to a country) from March 2020 to March 2021. The AB InBev’s numerical experiments show that our method is capable of reducing the forecast error in terms of weighted mean absolute percentage error (WMAPE) and mean squared error (MSE) by more than 37% for the company.

Suggested Citation

  • David Simchi-Levi & Rui Sun & Michelle Xiao Wu & Ruihao Zhu, 2024. "Calibrating Sales Forecasts in a Pandemic Using Competitive Online Nonparametric Regression," Management Science, INFORMS, vol. 70(10), pages 6502-6518, October.
  • Handle: RePEc:inm:ormnsc:v:70:y:2024:i:10:p:6502-6518
    DOI: 10.1287/mnsc.2023.4969
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/mnsc.2023.4969
    Download Restriction: no

    File URL: https://libkey.io/10.1287/mnsc.2023.4969?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:inm:ormnsc:v:70:y:2024:i:10:p:6502-6518. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Chris Asher (email available below). General contact details of provider: https://edirc.repec.org/data/inforea.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.