IDEAS home Printed from https://ideas.repec.org/a/eee/ejores/v307y2023i3p1146-1160.html
   My bibliography  Save this article

Lumpy and intermittent retail demand forecasts with score-driven models

Author

Listed:
  • Sarlo, Rodrigo
  • Fernandes, Cristiano
  • Borenstein, Denis

Abstract

Irregular demand in retail is characterized by stock keeping units (SKUs) that present high intermittency, and simultaneously, high erraticness (classified as lumpy demand) or low erraticness (classified as intermittent demand), following the classification of Syntetos et al. (2005). These SKUs are basically defined by periods of zero sales interleaved with positive sales producing series with some degree of variability. Many SKUs at the store/daily level can be characterized as presenting such a type of demand. Therefore methods for adequately forecasting irregular time series are necessary for proper inventory management. This article derives models for intermittent and lumpy time series using the framework of score-driven models as developed by Creal et al. (2013) and Harvey (2013). More precisely we derive Poisson, negative binomial, hurdle Poisson, and hurdle negative binomial models and apply them to real data obtained from a large Brazilian retail chain, comparing the performance of the proposed models to adequate competing methods from the ‘slow’/intermittent demand forecasting literature. Forecasting accuracy is evaluated based on point forecasts and the entire predictive distribution. Our results show that the score-driven models perform well compared to intermittent traditional forecasting methods, providing competitive forecasting models for irregular demand in retailing.

Suggested Citation

  • Sarlo, Rodrigo & Fernandes, Cristiano & Borenstein, Denis, 2023. "Lumpy and intermittent retail demand forecasts with score-driven models," European Journal of Operational Research, Elsevier, vol. 307(3), pages 1146-1160.
  • Handle: RePEc:eee:ejores:v:307:y:2023:i:3:p:1146-1160
    DOI: 10.1016/j.ejor.2022.10.006
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0377221722007743
    Download Restriction: Full text for ScienceDirect subscribers only

    File URL: https://libkey.io/10.1016/j.ejor.2022.10.006?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
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Zou, Hui, 2006. "The Adaptive Lasso and Its Oracle Properties," Journal of the American Statistical Association, American Statistical Association, vol. 101, pages 1418-1429, December.
    2. A A Syntetos & J E Boylan & J D Croston, 2005. "On the categorization of demand patterns," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 56(5), pages 495-503, May.
    3. Fotios Petropoulos & Nikolaos Kourentzes, 2015. "Forecast combinations for intermittent demand," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 66(6), pages 914-924, June.
    4. Nikolopoulos, Konstantinos, 2021. "We need to talk about intermittent demand forecasting," European Journal of Operational Research, Elsevier, vol. 291(2), pages 549-559.
    5. F R Johnston & J E Boylan & E A Shale, 2003. "An examination of the size of orders from customers, their characterisation and the implications for inventory control of slow moving items," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 54(8), pages 833-837, August.
    6. Snyder, Ralph D. & Ord, J. Keith & Beaumont, Adrian, 2012. "Forecasting the intermittent demand for slow-moving inventories: A modelling approach," International Journal of Forecasting, Elsevier, vol. 28(2), pages 485-496.
    7. Hyndman, Rob J. & Koehler, Anne B., 2006. "Another look at measures of forecast accuracy," International Journal of Forecasting, Elsevier, vol. 22(4), pages 679-688.
    8. Willemain, Thomas R. & Smart, Charles N. & Schwarz, Henry F., 2004. "A new approach to forecasting intermittent demand for service parts inventories," International Journal of Forecasting, Elsevier, vol. 20(3), pages 375-387.
    9. Syntetos, Aris A. & Nikolopoulos, Konstantinos & Boylan, John E., 2010. "Judging the judges through accuracy-implication metrics: The case of inventory forecasting," International Journal of Forecasting, Elsevier, vol. 26(1), pages 134-143, January.
    10. Hoeltgebaum, Henrique & Borenstein, Denis & Fernandes, Cristiano & Veiga, Álvaro, 2021. "A score-driven model of short-term demand forecasting for retail distribution centers," Journal of Retailing, Elsevier, vol. 97(4), pages 715-725.
    11. K Nikolopoulos & A A Syntetos & J E Boylan & F Petropoulos & V Assimakopoulos, 2011. "An aggregate–disaggregate intermittent demand approach (ADIDA) to forecasting: an empirical proposition and analysis," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 62(3), pages 544-554, March.
    12. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2019. "Retail forecasting: research and practice," MPRA Paper 89356, University Library of Munich, Germany.
    13. Michele Caivano & Andrew Harvey & Alessandra Luati, 2016. "Robust time series models with trend and seasonal components," SERIEs: Journal of the Spanish Economic Association, Springer;Spanish Economic Association, vol. 7(1), pages 99-120, March.
    14. Zied Babai, Mohamed & Syntetos, Aris & Teunter, Ruud, 2014. "Intermittent demand forecasting: An empirical study on accuracy and the risk of obsolescence," International Journal of Production Economics, Elsevier, vol. 157(C), pages 212-219.
    15. Kourentzes, Nikolaos, 2013. "Intermittent demand forecasts with neural networks," International Journal of Production Economics, Elsevier, vol. 143(1), pages 198-206.
    16. Gutierrez, Rafael S. & Solis, Adriano O. & Mukhopadhyay, Somnath, 2008. "Lumpy demand forecasting using neural networks," International Journal of Production Economics, Elsevier, vol. 111(2), pages 409-420, February.
    17. Syntetos, Aris A. & Boylan, John E., 2005. "The accuracy of intermittent demand estimates," International Journal of Forecasting, Elsevier, vol. 21(2), pages 303-314.
    18. Claudia Czado & Tilmann Gneiting & Leonhard Held, 2009. "Predictive Model Assessment for Count Data," Biometrics, The International Biometric Society, vol. 65(4), pages 1254-1261, December.
    19. Kourentzes, Nikolaos, 2014. "On intermittent demand model optimisation and selection," International Journal of Production Economics, Elsevier, vol. 156(C), pages 180-190.
    20. Kolassa, Stephan, 2016. "Evaluating predictive count data distributions in retail sales forecasting," International Journal of Forecasting, Elsevier, vol. 32(3), pages 788-803.
    21. Somnath Mukhopadhyay & Adriano O. Solis & Rafael S. Gutierrez, 2012. "The Accuracy of Non‐traditional versus Traditional Methods of Forecasting Lumpy Demand," Journal of Forecasting, John Wiley & Sons, Ltd., vol. 31(8), pages 721-735, December.
    22. Syntetos, Aris A. & Boylan, John E., 2006. "On the stock control performance of intermittent demand estimators," International Journal of Production Economics, Elsevier, vol. 103(1), pages 36-47, September.
    23. Drew Creal & Siem Jan Koopman & André Lucas, 2013. "Generalized Autoregressive Score Models With Applications," Journal of Applied Econometrics, John Wiley & Sons, Ltd., vol. 28(5), pages 777-795, August.
    24. Teunter, Ruud H. & Syntetos, Aris A. & Zied Babai, M., 2011. "Intermittent demand: Linking forecasting to inventory obsolescence," European Journal of Operational Research, Elsevier, vol. 214(3), pages 606-615, November.
    25. R H Teunter & L Duncan, 2009. "Forecasting intermittent demand: a comparative study," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 60(3), pages 321-329, March.
    26. Gardner, Everette Jr. & Koehler, Anne B., 2005. "Comments on a patented bootstrapping method for forecasting intermittent demand," International Journal of Forecasting, Elsevier, vol. 21(3), pages 617-618.
    Full references (including those not matched with items on IDEAS)

    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. 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.
    2. Evangelos Spiliotis & Spyros Makridakis & Artemios-Anargyros Semenoglou & Vassilios Assimakopoulos, 2022. "Comparison of statistical and machine learning methods for daily SKU demand forecasting," Operational Research, Springer, vol. 22(3), pages 3037-3061, July.
    3. Pinçe, Çerağ & Turrini, Laura & Meissner, Joern, 2021. "Intermittent demand forecasting for spare parts: A Critical review," Omega, Elsevier, vol. 105(C).
    4. Kourentzes, Nikolaos & Athanasopoulos, George, 2021. "Elucidate structure in intermittent demand series," European Journal of Operational Research, Elsevier, vol. 288(1), pages 141-152.
    5. Jože Martin Rožanec & Blaž Fortuna & Dunja Mladenić, 2022. "Reframing Demand Forecasting: A Two-Fold Approach for Lumpy and Intermittent Demand," Sustainability, MDPI, vol. 14(15), pages 1-21, July.
    6. Syntetos, Aris A. & Zied Babai, M. & Gardner, Everette S., 2015. "Forecasting intermittent inventory demands: simple parametric methods vs. bootstrapping," Journal of Business Research, Elsevier, vol. 68(8), pages 1746-1752.
    7. Li, Chongshou & Lim, Andrew, 2018. "A greedy aggregation–decomposition method for intermittent demand forecasting in fashion retailing," European Journal of Operational Research, Elsevier, vol. 269(3), pages 860-869.
    8. Pennings, Clint L.P. & van Dalen, Jan & van der Laan, Erwin A., 2017. "Exploiting elapsed time for managing intermittent demand for spare parts," European Journal of Operational Research, Elsevier, vol. 258(3), pages 958-969.
    9. Mariusz Doszyn, 2020. "Accuracy of Intermittent Demand Forecasting Systems in the Enterprise," European Research Studies Journal, European Research Studies Journal, vol. 0(4), pages 912-930.
    10. Kourentzes, Nikolaos, 2014. "On intermittent demand model optimisation and selection," International Journal of Production Economics, Elsevier, vol. 156(C), pages 180-190.
    11. Babai, M.Z. & Dallery, Y. & Boubaker, S. & Kalai, R., 2019. "A new method to forecast intermittent demand in the presence of inventory obsolescence," International Journal of Production Economics, Elsevier, vol. 209(C), pages 30-41.
    12. Tian, Xin & Wang, Haoqing & E, Erjiang, 2021. "Forecasting intermittent demand for inventory management by retailers: A new approach," Journal of Retailing and Consumer Services, Elsevier, vol. 62(C).
    13. Kolassa, Stephan, 2016. "Evaluating predictive count data distributions in retail sales forecasting," International Journal of Forecasting, Elsevier, vol. 32(3), pages 788-803.
    14. Prak, Dennis & Rogetzer, Patricia, 2022. "Timing intermittent demand with time-varying order-up-to levels," European Journal of Operational Research, Elsevier, vol. 303(3), pages 1126-1136.
    15. Kourentzes, Nikolaos, 2013. "Intermittent demand forecasts with neural networks," International Journal of Production Economics, Elsevier, vol. 143(1), pages 198-206.
    16. Pierre Dodin & Jingyi Xiao & Yossiri Adulyasak & Neda Etebari Alamdari & Lea Gauthier & Philippe Grangier & Paul Lemaitre & William L. Hamilton, 2023. "Bombardier Aftermarket Demand Forecast with Machine Learning," Interfaces, INFORMS, vol. 53(6), pages 425-445, November.
    17. Hu, Qiwei & Boylan, John E. & Chen, Huijing & Labib, Ashraf, 2018. "OR in spare parts management: A review," European Journal of Operational Research, Elsevier, vol. 266(2), pages 395-414.
    18. Ye, Yuan & Lu, Yonggang & Robinson, Powell & Narayanan, Arunachalam, 2022. "An empirical Bayes approach to incorporating demand intermittency and irregularity into inventory control," European Journal of Operational Research, Elsevier, vol. 303(1), pages 255-272.
    19. Lolli, F. & Gamberini, R. & Regattieri, A. & Balugani, E. & Gatos, T. & Gucci, S., 2017. "Single-hidden layer neural networks for forecasting intermittent demand," International Journal of Production Economics, Elsevier, vol. 183(PA), pages 116-128.
    20. Zhu, Sha & Dekker, Rommert & van Jaarsveld, Willem & Renjie, Rex Wang & Koning, Alex J., 2017. "An improved method for forecasting spare parts demand using extreme value theory," European Journal of Operational Research, Elsevier, vol. 261(1), pages 169-181.

    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:eee:ejores:v:307:y:2023:i:3:p:1146-1160. 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: Catherine Liu (email available below). General contact details of provider: http://www.elsevier.com/locate/eor .

    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.