IDEAS home Printed from https://ideas.repec.org/a/ers/journl/vxxiiiy2020i4p912-930.html
   My bibliography  Save this article

Accuracy of Intermittent Demand Forecasting Systems in the Enterprise

Author

Listed:
  • Mariusz Doszyn

Abstract

Purpose: The main purpose of this article is to find the best forecasting method for intermittent demand times series, from the company’s point of view. Design/Methodology/Approach: Intermittent demand forecasting systems were constructed based on the Croston’s, SBA, TSB, SES and MA methods. A real database from the warehouse center, containing over sixteen thousand items, was used. Accuracy measures were also discussed. Forecasting methods were compared for all products and for separate demand categories (intermittent, lumpy, erratic, smooth). Findings: It was determined that the TSB method outperforms other methods for all products. The worst procedures were found to be Croston’s and SBA, which performed even worse than SES or MA. The same conclusions were true for intermittent and lumpy categories. In case of erratic and smooth items different results were obtained. It was determined that the SBA method performed best, while the TSB method yielded the poorest results. Practical Implications: The main conclusion is that to judge accuracy of forecasting systems first the proper forecast error measures should be chosen. Based on obtained results, TSB method seems to be the best for intermittent demand times series and this method is recommended for enterprises dealing with intermittent demand. Originality/value: Since such error measures as MASE or scaled MAE favored an underestimated (or even zero) forecast, in the article a new error metric is proposed, which was named scaled Compound Error (sCE). It is a scaled error, and it considers forecast biasedness.

Suggested Citation

  • 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.
  • Handle: RePEc:ers:journl:v:xxiii:y:2020:i:4:p:912-930
    as

    Download full text from publisher

    File URL: https://www.ersj.eu/journal/1723/download
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. 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.
    2. Wallström, Peter & Segerstedt, Anders, 2010. "Evaluation of forecasting error measurements and techniques for intermittent demand," International Journal of Production Economics, Elsevier, vol. 128(2), pages 625-636, December.
    3. Goodwin, Paul & Lawton, Richard, 1999. "On the asymmetry of the symmetric MAPE," International Journal of Forecasting, Elsevier, vol. 15(4), pages 405-408, October.
    4. 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.
    5. Mariusz Doszyń, 2019. "Intermittent demand forecasting in the Enterprise: Empirical verification," Journal of Forecasting, John Wiley & Sons, Ltd., vol. 38(5), pages 459-469, August.
    6. Syntetos, Aris A. & Boylan, John E., 2005. "The accuracy of intermittent demand estimates," International Journal of Forecasting, Elsevier, vol. 21(2), pages 303-314.
    7. Willemain, Thomas R. & Smart, Charles N. & Shockor, Joseph H. & DeSautels, Philip A., 1994. "Forecasting intermittent demand in manufacturing: a comparative evaluation of Croston's method," International Journal of Forecasting, Elsevier, vol. 10(4), pages 529-538, December.
    8. 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.
    9. Rob J. Hyndman & Lydia Shenstone, 2005. "Stochastic models underlying Croston's method for intermittent demand forecasting," Journal of Forecasting, John Wiley & Sons, Ltd., vol. 24(6), pages 389-402.
    10. Snyder, Ralph, 2002. "Forecasting sales of slow and fast moving inventories," European Journal of Operational Research, Elsevier, vol. 140(3), pages 684-699, August.
    11. Boylan, J.E. & Syntetos, A.A., 2007. "The accuracy of a Modified Croston procedure," International Journal of Production Economics, Elsevier, vol. 107(2), pages 511-517, June.
    12. Prestwich, S.D. & Tarim, S.A. & Rossi, R. & Hnich, B., 2014. "Forecasting intermittent demand by hyperbolic-exponential smoothing," International Journal of Forecasting, Elsevier, vol. 30(4), pages 928-933.
    13. 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.
    14. Syntetos, A. A. & Boylan, J. E., 2001. "On the bias of intermittent demand estimates," International Journal of Production Economics, Elsevier, vol. 71(1-3), pages 457-466, May.
    15. 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.
    16. 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.
    17. 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.
    18. Kourentzes, Nikolaos, 2014. "On intermittent demand model optimisation and selection," International Journal of Production Economics, Elsevier, vol. 156(C), pages 180-190.
    19. Kolassa, Stephan, 2016. "Evaluating predictive count data distributions in retail sales forecasting," International Journal of Forecasting, Elsevier, vol. 32(3), pages 788-803.
    20. Rob J. Hyndman, 2006. "Another Look at Forecast Accuracy Metrics for Intermittent Demand," Foresight: The International Journal of Applied Forecasting, International Institute of Forecasters, issue 4, pages 43-46, June.
    21. 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.
    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. Pinçe, Çerağ & Turrini, Laura & Meissner, Joern, 2021. "Intermittent demand forecasting for spare parts: A Critical review," Omega, Elsevier, vol. 105(C).
    2. Kourentzes, Nikolaos & Athanasopoulos, George, 2021. "Elucidate structure in intermittent demand series," European Journal of Operational Research, Elsevier, vol. 288(1), pages 141-152.
    3. 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.
    4. 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.
    5. Mariusz Doszyn, 2020. "Biasedness of Forecasts Errors for Intermittent Demand Data," European Research Studies Journal, European Research Studies Journal, vol. 0(Special 1), pages 1113-1127.
    6. 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.
    7. Kolassa, Stephan, 2016. "Evaluating predictive count data distributions in retail sales forecasting," International Journal of Forecasting, Elsevier, vol. 32(3), pages 788-803.
    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. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2022. "Retail forecasting: Research and practice," International Journal of Forecasting, Elsevier, vol. 38(4), pages 1283-1318.
    10. Aiping Jiang & Qiuguo Chi & Junjun Gao & Maoguo Wu, 2019. "An Integrated Approach to Forecasting Intermittent Demand for Electric Power Materials," Computational Economics, Springer;Society for Computational Economics, vol. 53(4), pages 1309-1335, April.
    11. 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.
    12. Kourentzes, Nikolaos, 2013. "Intermittent demand forecasts with neural networks," International Journal of Production Economics, Elsevier, vol. 143(1), pages 198-206.
    13. Kourentzes, Nikolaos, 2014. "On intermittent demand model optimisation and selection," International Journal of Production Economics, Elsevier, vol. 156(C), pages 180-190.
    14. 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.
    15. Ducharme, Corey & Agard, Bruno & Trépanier, Martin, 2021. "Forecasting a customer's Next Time Under Safety Stock," International Journal of Production Economics, Elsevier, vol. 234(C).
    16. 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).
    17. 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.
    18. Altay, Nezih & Rudisill, Frank & Litteral, Lewis A., 2008. "Adapting Wright's modification of Holt's method to forecasting intermittent demand," International Journal of Production Economics, Elsevier, vol. 111(2), pages 389-408, February.
    19. Prestwich, S.D. & Tarim, S.A. & Rossi, R., 2021. "Intermittency and obsolescence: A Croston method with linear decay," International Journal of Forecasting, Elsevier, vol. 37(2), pages 708-715.
    20. 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.

    More about this item

    Keywords

    Intermittent demand forecasting; accuracy measures; scaled compound error; Croston’s method; SBA method; TSB method; exponential smoothing.;
    All these keywords.

    JEL classification:

    • C53 - Mathematical and Quantitative Methods - - Econometric Modeling - - - Forecasting and Prediction Models; Simulation Methods
    • E27 - Macroeconomics and Monetary Economics - - Consumption, Saving, Production, Employment, and Investment - - - Forecasting and Simulation: Models and Applications
    • L81 - Industrial Organization - - Industry Studies: Services - - - Retail and Wholesale Trade; e-Commerce

    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:ers:journl:v:xxiii:y:2020:i:4:p:912-930. 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: Marios Agiomavritis (email available below). General contact details of provider: https://ersj.eu/ .

    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.