IDEAS home Printed from https://ideas.repec.org/a/ana/journl/v9y2023i1p1-31.html
   My bibliography  Save this article

Combined Forecasts of Intermittent Demand for Stock-keeping Units (SKUs)

Author

Listed:
  • Aysun Kapucugil Ikiz

    (Dokuz Eylul University, Faculty of Business, Department of Business Administration)

  • Gizem Halil Utma

    (Izmir University of Economics, Faculty of Business, Department of Business Administration)

Abstract

Effective inventory management requires accurate forecasts for stock-keeping units (SKUs), especially for the strategic ones for companies’ operations and after-sales services like providing spare parts. Forecasting is a challenging task for such SKUs as they usually have intermittent demand (ID) patterns, consisting of many periods with zero demand and infrequent demand arrivals. Given the highly uncertain nature of ID for SKUs, this study developed a methodological framework for combining statistical and judgmental forecasts and assessed the performance of the proposed framework by using accuracy and bias measures. The forecasting process has several steps, including data preparation, data categorization based on demand patterns, generating statistical and judgmental forecasts, combining statistical and judgmental forecasts, and evaluating the forecast performance. These steps were illustrated on a real-world dataset that contains monthly customer demand data for after-sales spare parts. Results showed that combination is the best method for the majority of SKUs. This paper contributes to the limited literature by addressing the gap between the combined and ID forecasts. The proposed framework gives practitioners and researchers a comprehensive overview to help them make more accurate forecasts while encouraging the use of simple but structured approaches.

Suggested Citation

  • Aysun Kapucugil Ikiz & Gizem Halil Utma, 2023. "Combined Forecasts of Intermittent Demand for Stock-keeping Units (SKUs)," World Journal of Applied Economics, WERI-World Economic Research Institute, vol. 9(1), pages 1-31, June.
  • Handle: RePEc:ana:journl:v:9:y:2023:i:1:p:1-31
    DOI: 10.22440/wjae.9.1.1
    as

    Download full text from publisher

    File URL: https://journal.econworld.org/index.php/econworld/article/view/217/79
    Download Restriction: no

    File URL: https://libkey.io/10.22440/wjae.9.1.1?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
    ---><---

    References listed on IDEAS

    as
    1. Hasni, M. & Babai, M.Z. & Aguir, M.S. & Jemai, Z., 2019. "An investigation on bootstrapping forecasting methods for intermittent demands," International Journal of Production Economics, Elsevier, vol. 209(C), pages 20-29.
    2. Eroglu, Cuneyt & Croxton, Keely L., 2010. "Biases in judgmental adjustments of statistical forecasts: The role of individual differences," International Journal of Forecasting, Elsevier, vol. 26(1), pages 116-133, January.
    3. A V Kostenko & R J Hyndman, 2006. "A note on the categorization of demand patterns," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 57(10), pages 1256-1257, October.
    4. Clemen, Robert T., 1989. "Combining forecasts: A review and annotated bibliography," International Journal of Forecasting, Elsevier, vol. 5(4), pages 559-583.
    5. Fischer, Ilan & Harvey, Nigel, 1999. "Combining forecasts: What information do judges need to outperform the simple average?," International Journal of Forecasting, Elsevier, vol. 15(3), pages 227-246, July.
    6. Kourentzes, Nikolaos, 2013. "Intermittent demand forecasts with neural networks," International Journal of Production Economics, Elsevier, vol. 143(1), pages 198-206.
    7. 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.
    8. Fildes, Robert & Petropoulos, Fotios, 2015. "Simple versus complex selection rules for forecasting many time series," Journal of Business Research, Elsevier, vol. 68(8), pages 1692-1701.
    9. 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.
    10. Philip Hans Franses & Rianne Legerstee, 2010. "Do experts' adjustments on model-based SKU-level forecasts improve forecast quality?," Journal of Forecasting, John Wiley & Sons, Ltd., vol. 29(3), pages 331-340.
    11. Green, Kesten C. & Armstrong, J. Scott, 2007. "Structured analogies for forecasting," International Journal of Forecasting, Elsevier, vol. 23(3), pages 365-376.
    12. Kourentzes, Nikolaos, 2014. "On intermittent demand model optimisation and selection," International Journal of Production Economics, Elsevier, vol. 156(C), pages 180-190.
    13. 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.
    14. Costantino, Francesco & Di Gravio, Giulio & Patriarca, Riccardo & Petrella, Lea, 2018. "Spare parts management for irregular demand items," Omega, Elsevier, vol. 81(C), pages 57-66.
    15. Claeskens, Gerda & Magnus, Jan R. & Vasnev, Andrey L. & Wang, Wendun, 2016. "The forecast combination puzzle: A simple theoretical explanation," International Journal of Forecasting, Elsevier, vol. 32(3), pages 754-762.
    16. Lawrence, Michael & Goodwin, Paul & O'Connor, Marcus & Onkal, Dilek, 2006. "Judgmental forecasting: A review of progress over the last 25 years," International Journal of Forecasting, Elsevier, vol. 22(3), pages 493-518.
    17. M. J. Lawrence & R. H. Edmundson & M. J. O'Connor, 1986. "The Accuracy of Combining Judgemental and Statistical Forecasts," Management Science, INFORMS, vol. 32(12), pages 1521-1532, December.
    18. Chan, Felix & Pauwels, Laurent L., 2018. "Some theoretical results on forecast combinations," International Journal of Forecasting, Elsevier, vol. 34(1), pages 64-74.
    19. Z S Hua & B Zhang & J Yang & D S Tan, 2007. "A new approach of forecasting intermittent demand for spare parts inventories in the process industries," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 58(1), pages 52-61, January.
    20. Davydenko, Andrey & Fildes, Robert, 2013. "Measuring forecasting accuracy: The case of judgmental adjustments to SKU-level demand forecasts," International Journal of Forecasting, Elsevier, vol. 29(3), pages 510-522.
    21. J E Boylan & A A Syntetos & G C Karakostas, 2008. "Classification for forecasting and stock control: a case study," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 59(4), pages 473-481, April.
    22. 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.
    23. Bunn, Derek W. & Salo, Ahti A., 1993. "Forecasting with scenarios," European Journal of Operational Research, Elsevier, vol. 68(3), pages 291-303, August.
    24. Ghobbar, A.A & Friend, C.H, 2002. "Sources of intermittent demand for aircraft spare parts within airline operations," Journal of Air Transport Management, Elsevier, vol. 8(4), pages 221-231.
    25. A H C Eaves & B G Kingsman, 2004. "Forecasting for the ordering and stock-holding of spare parts," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 55(4), pages 431-437, April.
    26. Fildes, Robert, 1992. "The evaluation of extrapolative forecasting methods," International Journal of Forecasting, Elsevier, vol. 8(1), pages 81-98, June.
    27. Green, Kesten C. & Armstrong, J. Scott, 2015. "Simple versus complex forecasting: The evidence," Journal of Business Research, Elsevier, vol. 68(8), pages 1678-1685.
    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. Perera, H. Niles & Hurley, Jason & Fahimnia, Behnam & Reisi, Mohsen, 2019. "The human factor in supply chain forecasting: A systematic review," European Journal of Operational Research, Elsevier, vol. 274(2), pages 574-600.
    3. Pinçe, Çerağ & Turrini, Laura & Meissner, Joern, 2021. "Intermittent demand forecasting for spare parts: A Critical review," Omega, Elsevier, vol. 105(C).
    4. 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.
    5. 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.
    6. Abolghasemi, Mahdi & Hurley, Jason & Eshragh, Ali & Fahimnia, Behnam, 2020. "Demand forecasting in the presence of systematic events: Cases in capturing sales promotions," International Journal of Production Economics, Elsevier, vol. 230(C).
    7. R Fildes & K Nikolopoulos & S F Crone & A A Syntetos, 2008. "Forecasting and operational research: a review," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 59(9), pages 1150-1172, September.
    8. 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.
    9. Kourentzes, Nikolaos, 2014. "On intermittent demand model optimisation and selection," International Journal of Production Economics, Elsevier, vol. 156(C), pages 180-190.
    10. Ulrich, Matthias & Jahnke, Hermann & Langrock, Roland & Pesch, Robert & Senge, Robin, 2022. "Classification-based model selection in retail demand forecasting," International Journal of Forecasting, Elsevier, vol. 38(1), pages 209-223.
    11. Armstrong, J. Scott & Green, Kesten C. & Graefe, Andreas, 2015. "Golden rule of forecasting: Be conservative," Journal of Business Research, Elsevier, vol. 68(8), pages 1717-1731.
    12. Leitner, Johannes & Leopold-Wildburger, Ulrike, 2011. "Experiments on forecasting behavior with several sources of information - A review of the literature," European Journal of Operational Research, Elsevier, vol. 213(3), pages 459-469, September.
    13. Kamal Sanguri & Kampan Mukherjee, 2021. "Forecasting of intermittent demands under the risk of inventory obsolescence," Journal of Forecasting, John Wiley & Sons, Ltd., vol. 40(6), pages 1054-1069, September.
    14. Wang, Xiaoqian & Hyndman, Rob J. & Li, Feng & Kang, Yanfei, 2023. "Forecast combinations: An over 50-year review," International Journal of Forecasting, Elsevier, vol. 39(4), pages 1518-1547.
    15. Makridakis, Spyros & Hyndman, Rob J. & Petropoulos, Fotios, 2020. "Forecasting in social settings: The state of the art," International Journal of Forecasting, Elsevier, vol. 36(1), pages 15-28.
    16. Makridakis, Spyros & Spiliotis, Evangelos & Assimakopoulos, Vassilios, 2020. "The M4 Competition: 100,000 time series and 61 forecasting methods," International Journal of Forecasting, Elsevier, vol. 36(1), pages 54-74.
    17. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2022. "Retail forecasting: Research and practice," International Journal of Forecasting, Elsevier, vol. 38(4), pages 1283-1318.
    18. Heinecke, G. & Syntetos, A.A. & Wang, W., 2013. "Forecasting-based SKU classification," International Journal of Production Economics, Elsevier, vol. 143(2), pages 455-462.
    19. A A Syntetos & M Z Babai & Y Dallery & R Teunter, 2009. "Periodic control of intermittent demand items: theory and empirical analysis," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 60(5), pages 611-618, May.
    20. Spiliotis, Evangelos & Nikolopoulos, Konstantinos & Assimakopoulos, Vassilios, 2019. "Tales from tails: On the empirical distributions of forecasting errors and their implication to risk," International Journal of Forecasting, Elsevier, vol. 35(2), pages 687-698.

    More about this item

    Keywords

    Statistical forecasting; Judgmental forecasting; Combining forecasts; Intermittent demand; Stock-keeping Units;
    All these keywords.

    JEL classification:

    • C44 - Mathematical and Quantitative Methods - - Econometric and Statistical Methods: Special Topics - - - Operations Research; Statistical Decision Theory
    • C53 - Mathematical and Quantitative Methods - - Econometric Modeling - - - Forecasting and Prediction Models; Simulation Methods
    • M11 - Business Administration and Business Economics; Marketing; Accounting; Personnel Economics - - Business Administration - - - Production Management

    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:ana:journl:v:9:y:2023:i:1:p:1-31. 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: Unal Tongur (email available below). General contact details of provider: https://edirc.repec.org/data/ewanatr.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.