IDEAS home Printed from https://ideas.repec.org/a/eee/proeco/v234y2021ics0925527321000207.html
   My bibliography  Save this article

Forecasting a customer's Next Time Under Safety Stock

Author

Listed:
  • Ducharme, Corey
  • Agard, Bruno
  • Trépanier, Martin

Abstract

Under intermittent demand, demand time series can contain noise and have intermittent characteristics which render their modeling difficult. Models for producing forecasts in these conditions are optimized on errors that are calculated on out-of-sample forecasts of demand time series. This is insufficient in an intermittent demand context, as intermittent demand time series tend to provide poor representations of the underlying stock behavior. In this paper, we propose a new, intuitive, and robust method of error measurement for evaluating intermittent demand time series forecasting models by estimating stock-out situations from demand forecasts. This metric is called the Next Time Under Safety Stock. Applying our error measurement to common intermittent time series forecasting models reveals that forecast combination remains the most competitive modeling framework. A case study allows for a comparison between available sources of demand information when forecasting for these stock-out events. Significant correlation is also found between our new error measurement and common time series error measurements, which allows them to serve as replacements, but with reduced efficacy.

Suggested Citation

  • 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).
  • Handle: RePEc:eee:proeco:v:234:y:2021:i:c:s0925527321000207
    DOI: 10.1016/j.ijpe.2021.108044
    as

    Download full text from publisher

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

    File URL: https://libkey.io/10.1016/j.ijpe.2021.108044?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. 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. Petropoulos, Fotios & Kourentzes, Nikolaos & Nikolopoulos, Konstantinos, 2016. "Another look at estimators for intermittent demand," International Journal of Production Economics, Elsevier, vol. 181(PA), pages 154-161.
    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. Kourentzes, Nikolaos & Trapero, Juan R. & Barrow, Devon K., 2020. "Optimising forecasting models for inventory planning," International Journal of Production Economics, Elsevier, vol. 225(C).
    5. 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.
    6. Kim, Sungil & Kim, Heeyoung, 2016. "A new metric of absolute percentage error for intermittent demand forecasts," International Journal of Forecasting, Elsevier, vol. 32(3), pages 669-679.
    7. Kourentzes, Nikolaos & Petropoulos, Fotios & Trapero, Juan R., 2014. "Improving forecasting by estimating time series structural components across multiple frequencies," International Journal of Forecasting, Elsevier, vol. 30(2), pages 291-302.
    8. Ali, Mohammad M. & Babai, Mohamed Zied & Boylan, John E. & Syntetos, A.A., 2017. "Supply chain forecasting when information is not shared," European Journal of Operational Research, Elsevier, vol. 260(3), pages 984-994.
    9. Petropoulos, Fotios & Wang, Xun & Disney, Stephen M., 2019. "The inventory performance of forecasting methods: Evidence from the M3 competition data," International Journal of Forecasting, Elsevier, vol. 35(1), pages 251-265.
    10. Kourentzes, Nikolaos & Barrow, Devon & Petropoulos, Fotios, 2019. "Another look at forecast selection and combination: Evidence from forecast pooling," International Journal of Production Economics, Elsevier, vol. 209(C), pages 226-235.
    11. Zhou, Chenxi & Viswanathan, S., 2011. "Comparison of a new bootstrapping method with parametric approaches for safety stock determination in service parts inventory systems," International Journal of Production Economics, Elsevier, vol. 133(1), pages 481-485, September.
    12. Kourentzes, Nikolaos, 2013. "Intermittent demand forecasts with neural networks," International Journal of Production Economics, Elsevier, vol. 143(1), pages 198-206.
    13. Syntetos, Aris A. & Boylan, John E., 2005. "The accuracy of intermittent demand estimates," International Journal of Forecasting, Elsevier, vol. 21(2), pages 303-314.
    14. 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.
    15. 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.
    16. Stephan Kolassa & Wolfgang Schütz, 2007. "Advantages of the MAD/Mean Ratio over the MAPE," Foresight: The International Journal of Applied Forecasting, International Institute of Forecasters, issue 6, pages 40-43, Spring.
    17. Nikolopoulos, Konstantinos, 2021. "We need to talk about intermittent demand forecasting," European Journal of Operational Research, Elsevier, vol. 291(2), pages 549-559.
    18. 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.
    19. 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.
    20. 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.
    21. 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.
    22. Lawrence, Michael & O'Connor, Marcus, 2005. "Judgmental forecasting in the presence of loss functions," International Journal of Forecasting, Elsevier, vol. 21(1), pages 3-14.
    23. Kourentzes, Nikolaos, 2014. "On intermittent demand model optimisation and selection," International Journal of Production Economics, Elsevier, vol. 156(C), pages 180-190.
    24. 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.
    25. Murray, Paul W. & Agard, Bruno & Barajas, Marco A., 2018. "ASACT - Data preparation for forecasting: A method to substitute transaction data for unavailable product consumption data," International Journal of Production Economics, Elsevier, vol. 203(C), pages 264-275.
    26. 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.
    27. Zhou, Maosen & Dan, Bin & Ma, Songxuan & Zhang, Xumei, 2017. "Supply chain coordination with information sharing: The informational advantage of GPOs," European Journal of Operational Research, Elsevier, vol. 256(3), pages 785-802.
    28. Babai, Zied & Boylan, John E. & Kolassa, Stephan & Nikolopoulos, Konstantinos, 2016. "Supply chain forecasting: Theory, practice, their gap and the futureAuthor-Name: Syntetos, Aris A," European Journal of Operational Research, Elsevier, vol. 252(1), pages 1-26.
    29. 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.
    30. Holweg, Matthias & Disney, Stephen & Holmström, Jan & Småros, Johanna, 2005. "Supply Chain Collaboration:: Making Sense of the Strategy Continuum," European Management Journal, Elsevier, vol. 23(2), pages 170-181, April.
    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. Corey Ducharme & Bruno Agard & Martin Trépanier, 2024. "Improving demand forecasting for customers with missing downstream data in intermittent demand supply chains with supervised multivariate clustering," Journal of Forecasting, John Wiley & Sons, Ltd., vol. 43(5), pages 1661-1681, August.
    2. Pinçe, Çerağ & Turrini, Laura & Meissner, Joern, 2021. "Intermittent demand forecasting for spare parts: A Critical review," Omega, Elsevier, vol. 105(C).
    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. Schlaich, Tim & Hoberg, Kai, 2024. "When is the next order? Nowcasting channel inventories with Point-of-Sales data to predict the timing of retail orders," European Journal of Operational Research, Elsevier, vol. 315(1), pages 35-49.
    6. Kourentzes, Nikolaos & Athanasopoulos, George, 2021. "Elucidate structure in intermittent demand series," European Journal of Operational Research, Elsevier, vol. 288(1), pages 141-152.
    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. Kolassa, Stephan, 2016. "Evaluating predictive count data distributions in retail sales forecasting," International Journal of Forecasting, Elsevier, vol. 32(3), pages 788-803.
    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. Wang, Shengjie & Kang, Yanfei & Petropoulos, Fotios, 2024. "Combining probabilistic forecasts of intermittent demand," European Journal of Operational Research, Elsevier, vol. 315(3), pages 1038-1048.
    11. 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).
    12. 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.
    13. 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.
    14. Hasni, M. & Aguir, M.S. & Babai, M.Z. & Jemai, Z., 2019. "On the performance of adjusted bootstrapping methods for intermittent demand forecasting," International Journal of Production Economics, Elsevier, vol. 216(C), pages 145-153.
    15. 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.
    16. G. Peter Zhang & Yusen Xia & Maohua Xie, 2024. "Intermittent demand forecasting with transformer neural networks," Annals of Operations Research, Springer, vol. 339(1), pages 1051-1072, August.
    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. 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.
    19. Petropoulos, Fotios & Wang, Xun & Disney, Stephen M., 2019. "The inventory performance of forecasting methods: Evidence from the M3 competition data," International Journal of Forecasting, Elsevier, vol. 35(1), pages 251-265.
    20. 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.

    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:proeco:v:234:y:2021:i:c:s0925527321000207. 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/ijpe .

    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.