IDEAS home Printed from https://ideas.repec.org/p/hal/wpaper/hal-02794320.html
   My bibliography  Save this paper

Hierarchical robust aggregation of sales forecasts at aggregated levels in e-commerce, based on exponential smoothing and Holt's linear trend method

Author

Listed:
  • Malo Huard

    (Milvue [Paris], LMO - Laboratoire de Mathématiques d'Orsay - Université Paris-Saclay - CNRS - Centre National de la Recherche Scientifique)

  • Rémy Garnier

    (Cdiscount)

  • Gilles Stoltz

    (LMO - Laboratoire de Mathématiques d'Orsay - Université Paris-Saclay - CNRS - Centre National de la Recherche Scientifique, HEC Paris - Ecole des Hautes Etudes Commerciales, CELESTE - Statistique mathématique et apprentissage - Inria Saclay - Ile de France - Inria - Institut National de Recherche en Informatique et en Automatique - LMO - Laboratoire de Mathématiques d'Orsay - Université Paris-Saclay - CNRS - Centre National de la Recherche Scientifique)

Abstract

We revisit the interest of classical statistical techniques for sales forecasting like exponential smoothing and extensions thereof (as Holt's linear trend method). We do so by considering ensemble forecasts, given by several instances of these classical techniques tuned with different (sets of) parameters, and by forming convex combinations of the elements of ensemble forecasts over time, in a robust and sequential manner. The machine-learning theory behind this is called "robust online aggregation", or "prediction with expert advice", or "prediction of individual sequences" (see Cesa-Bianchi and Lugosi, 2006). We apply this methodology to a hierarchical data set of sales provided by the e-commerce company Cdiscount and output forecasts at the levels of subsubfamilies, subfamilies and families of items sold, for various forecasting horizons (up to 6-week-ahead). The performance achieved is better than what would be obtained by optimally tuning the classical techniques on a train set and using their forecasts on the test set. The performance is also good from an intrinsic point of view (in terms of mean absolute percentage of error). While getting these better forecasts of sales at the levels of subsubfamilies, subfamilies and families is interesting per se, we also suggest to use them as additional features when forecasting demand at the item level.

Suggested Citation

  • Malo Huard & Rémy Garnier & Gilles Stoltz, 2020. "Hierarchical robust aggregation of sales forecasts at aggregated levels in e-commerce, based on exponential smoothing and Holt's linear trend method," Working Papers hal-02794320, HAL.
  • Handle: RePEc:hal:wpaper:hal-02794320
    Note: View the original document on HAL open archive server: https://hal.science/hal-02794320
    as

    Download full text from publisher

    File URL: https://hal.science/hal-02794320/document
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Amat, Christophe & Michalski, Tomasz & Stoltz, Gilles, 2018. "Fundamentals and exchange rate forecastability with simple machine learning methods," Journal of International Money and Finance, Elsevier, vol. 88(C), pages 1-24.
    2. Anestis Antoniadis & Efstathios Paparoditis & Theofanis Sapatinas, 2006. "A functional wavelet–kernel approach for time series prediction," Journal of the Royal Statistical Society Series B, Royal Statistical Society, vol. 68(5), pages 837-857, November.
    3. Yossi Aviv, 2003. "A Time-Series Framework for Supply-Chain Inventory Management," Operations Research, INFORMS, vol. 51(2), pages 210-227, April.
    4. Jian Hu & Junxuan Li & Sanjay Mehrotra, 2019. "A Data-Driven Functionally Robust Approach for Simultaneous Pricing and Order Quantity Decisions with Unknown Demand Function," Operations Research, INFORMS, vol. 67(6), pages 1564-1585, November.
    5. Taylor, James W., 2010. "Triple seasonal methods for short-term electricity demand forecasting," European Journal of Operational Research, Elsevier, vol. 204(1), pages 139-152, July.
    6. Carbonneau, Real & Laframboise, Kevin & Vahidov, Rustam, 2008. "Application of machine learning techniques for supply chain demand forecasting," European Journal of Operational Research, Elsevier, vol. 184(3), pages 1140-1154, February.
    7. Gardner, Everette Jr., 2006. "Exponential smoothing: The state of the art--Part II," International Journal of Forecasting, Elsevier, vol. 22(4), pages 637-666.
    8. James W. Taylor, 2008. "A Comparison of Univariate Time Series Methods for Forecasting Intraday Arrivals at a Call Center," Management Science, INFORMS, vol. 54(2), pages 253-265, February.
    9. Wang Chi Cheung & David Simchi-Levi & He Wang, 2017. "Technical Note—Dynamic Pricing and Demand Learning with Limited Price Experimentation," Operations Research, INFORMS, vol. 65(6), pages 1722-1731, December.
    10. Tatsiana Levina & Yuri Levin & Jeff McGill & Mikhail Nediak, 2009. "Dynamic Pricing with Online Learning and Strategic Consumers: An Application of the Aggregating Algorithm," Operations Research, INFORMS, vol. 57(2), pages 327-341, April.
    11. Thomas M. Cover, 1991. "Universal Portfolios," Mathematical Finance, Wiley Blackwell, vol. 1(1), pages 1-29, January.
    12. Kris Johnson Ferreira & Bin Hong Alex Lee & David Simchi-Levi, 2016. "Analytics for an Online Retailer: Demand Forecasting and Price Optimization," Manufacturing & Service Operations Management, INFORMS, vol. 18(1), pages 69-88, February.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Ghelasi, Paul & Ziel, Florian, 2024. "Hierarchical forecasting for aggregated curves with an application to day-ahead electricity price auctions," International Journal of Forecasting, Elsevier, vol. 40(2), pages 581-596.
    2. Paul Ghelasi & Florian Ziel, 2023. "Hierarchical forecasting for aggregated curves with an application to day-ahead electricity price auctions," Papers 2305.16255, arXiv.org.
    3. Paweł Ziemba & Aneta Becker & Jarosław Becker, 2021. "Forecasting and Assessment of the Energy Security Risk in Fuzzy Environment," Energies, MDPI, vol. 14(18), pages 1-20, September.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Barrow, Devon & Kourentzes, Nikolaos, 2018. "The impact of special days in call arrivals forecasting: A neural network approach to modelling special days," European Journal of Operational Research, Elsevier, vol. 264(3), pages 967-977.
    2. Andrea Bastianin & Marzio Galeotti & Matteo Manera, 2019. "Statistical and economic evaluation of time series models for forecasting arrivals at call centers," Empirical Economics, Springer, vol. 57(3), pages 923-955, September.
    3. James W. Taylor, 2012. "Density Forecasting of Intraday Call Center Arrivals Using Models Based on Exponential Smoothing," Management Science, INFORMS, vol. 58(3), pages 534-549, March.
    4. Ulrich, Matthias & Jahnke, Hermann & Langrock, Roland & Pesch, Robert & Senge, Robin, 2021. "Distributional regression for demand forecasting in e-grocery," European Journal of Operational Research, Elsevier, vol. 294(3), pages 831-842.
    5. Victor Martínez‐de‐Albéniz & Arnau Planas & Stefano Nasini, 2020. "Using Clickstream Data to Improve Flash Sales Effectiveness," Production and Operations Management, Production and Operations Management Society, vol. 29(11), pages 2508-2531, November.
    6. Theresa Maria Rausch & Tobias Albrecht & Daniel Baier, 2022. "Beyond the beaten paths of forecasting call center arrivals: on the use of dynamic harmonic regression with predictor variables," Journal of Business Economics, Springer, vol. 92(4), pages 675-706, May.
    7. Weron, Rafał, 2014. "Electricity price forecasting: A review of the state-of-the-art with a look into the future," International Journal of Forecasting, Elsevier, vol. 30(4), pages 1030-1081.
    8. Trapero, Juan R. & Kourentzes, N. & Fildes, R., 2012. "Impact of information exchange on supplier forecasting performance," Omega, Elsevier, vol. 40(6), pages 738-747.
    9. Ayman A. Amin & Saeed A. Alghamdi, 2023. "Bayesian Identification Procedure for Triple Seasonal Autoregressive Models," Mathematics, MDPI, vol. 11(18), pages 1-13, September.
    10. Cho, Haeran & Goude, Yannig & Brossat, Xavier & Yao, Qiwei, 2013. "Modeling and forecasting daily electricity load curves: a hybrid approach," LSE Research Online Documents on Economics 49634, London School of Economics and Political Science, LSE Library.
    11. Yelland, Phillip M., 2010. "Bayesian forecasting of parts demand," International Journal of Forecasting, Elsevier, vol. 26(2), pages 374-396, April.
    12. Petropoulos, Fotios & Apiletti, Daniele & Assimakopoulos, Vassilios & Babai, Mohamed Zied & Barrow, Devon K. & Ben Taieb, Souhaib & Bergmeir, Christoph & Bessa, Ricardo J. & Bijak, Jakub & Boylan, Joh, 2022. "Forecasting: theory and practice," International Journal of Forecasting, Elsevier, vol. 38(3), pages 705-871.
      • Fotios Petropoulos & Daniele Apiletti & Vassilios Assimakopoulos & Mohamed Zied Babai & Devon K. Barrow & Souhaib Ben Taieb & Christoph Bergmeir & Ricardo J. Bessa & Jakub Bijak & John E. Boylan & Jet, 2020. "Forecasting: theory and practice," Papers 2012.03854, arXiv.org, revised Jan 2022.
    13. Mauro Bernardi & Francesco Lisi, 2020. "Point and Interval Forecasting of Zonal Electricity Prices and Demand Using Heteroscedastic Models: The IPEX Case," Energies, MDPI, vol. 13(23), pages 1-34, November.
    14. Chethana Dharmawardane & Ville Sillanpää & Jan Holmström, 2021. "High-frequency forecasting for grocery point-of-sales: intervention in practice and theoretical implications for operational design," Operations Management Research, Springer, vol. 14(1), pages 38-60, June.
    15. Yang, Dazhi & Sharma, Vishal & Ye, Zhen & Lim, Lihong Idris & Zhao, Lu & Aryaputera, Aloysius W., 2015. "Forecasting of global horizontal irradiance by exponential smoothing, using decompositions," Energy, Elsevier, vol. 81(C), pages 111-119.
    16. Antoniadis, Anestis & Brossat, Xavier & Cugliari, Jairo & Poggi, Jean-Michel, 2016. "A prediction interval for a function-valued forecast model: Application to load forecasting," International Journal of Forecasting, Elsevier, vol. 32(3), pages 939-947.
    17. Sule Birim & Ipek Kazancoglu & Sachin Kumar Mangla & Aysun Kahraman & Yigit Kazancoglu, 2024. "The derived demand for advertising expenses and implications on sustainability: a comparative study using deep learning and traditional machine learning methods," Annals of Operations Research, Springer, vol. 339(1), pages 131-161, August.
    18. Aljuneidi, Tariq & Punia, Sushil & Jebali, Aida & Nikolopoulos, Konstantinos, 2024. "Forecasting and planning for a critical infrastructure sector during a pandemic: Empirical evidence from a food supply chain," European Journal of Operational Research, Elsevier, vol. 317(3), pages 936-952.
    19. Dai, Hongyan & Xiao, Qin & Chen, Songlin & Zhou, Weihua, 2023. "Data-driven demand forecast for O2O operations: An adaptive hierarchical incremental approach," International Journal of Production Economics, Elsevier, vol. 259(C).
    20. Kim, Myung Suk, 2013. "Modeling special-day effects for forecasting intraday electricity demand," European Journal of Operational Research, Elsevier, vol. 230(1), pages 170-180.

    More about this item

    Keywords

    ensemble forecasts; prediction with expert advice; exponential smoothing; Holt's linear trend method; e-commerce data;
    All these keywords.

    NEP fields

    This paper has been announced in the following NEP Reports:

    Statistics

    Access and download statistics

    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:hal:wpaper:hal-02794320. 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.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with 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: CCSD (email available below). General contact details of provider: https://hal.archives-ouvertes.fr/ .

    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.