IDEAS home Printed from https://ideas.repec.org/a/wly/jforec/v43y2024i5p1661-1681.html
   My bibliography  Save this article

Improving demand forecasting for customers with missing downstream data in intermittent demand supply chains with supervised multivariate clustering

Author

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

Abstract

In a collaborative supply chain arrangement like vendor‐managed inventory, information on product demand at the point of sale is expected to be shared among members of the supply chain. However, in practice, obtaining such information can be costly, and some members may be unwilling or unable to provide the necessary access to the data. As such, large collaborative supply chains with multiple members may operate under a mixed‐information scenario where point‐of‐sale demand information is not known for all customers. Other sources of demand information exist and are becoming more available along supply chains using Industry 4.0 technologies and can serve as a substitute, but the data may be noisy, distorted, and partially missing. Under mixed information, leveraging existing customers' point‐of‐sale demand to improve the intermittent demand forecast of customers with missing information has yet to be explored. We propose a supervised demand forecasting method that uses multivariate time series clustering to map multiple sources of demand data. Members with missing downstream demand data have their resulting demand forecast improved by averaging over customers with similar delivery patterns for their final demand forecast. Our results show up to a 10% accuracy improvement over traditional intermittent demand forecasting methods with missing information.

Suggested Citation

  • 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.
  • Handle: RePEc:wly:jforec:v:43:y:2024:i:5:p:1661-1681
    DOI: 10.1002/for.3095
    as

    Download full text from publisher

    File URL: https://doi.org/10.1002/for.3095
    Download Restriction: no

    File URL: https://libkey.io/10.1002/for.3095?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. 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. 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. Bartezzaghi, Emilio & Verganti, Roberto & Zotteri, Giulio, 1999. "A simulation framework for forecasting uncertain lumpy demand," International Journal of Production Economics, Elsevier, vol. 59(1-3), pages 499-510, March.
    7. Kück, Mirko & Freitag, Michael, 2021. "Forecasting of customer demands for production planning by local k-nearest neighbor models," International Journal of Production Economics, Elsevier, vol. 231(C).
    8. 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.
    9. 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.
    10. Glenn Milligan & Martha Cooper, 1985. "An examination of procedures for determining the number of clusters in a data set," Psychometrika, Springer;The Psychometric Society, vol. 50(2), pages 159-179, June.
    11. 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.
    12. 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.
    13. 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.
    14. Mohamed Ben-Daya & Elkafi Hassini & Zied Bahroun, 2019. "Internet of things and supply chain management: a literature review," International Journal of Production Research, Taylor & Francis Journals, vol. 57(15-16), pages 4719-4742, August.
    15. Giorgino, Toni, 2009. "Computing and Visualizing Dynamic Time Warping Alignments in R: The dtw Package," Journal of Statistical Software, Foundation for Open Access Statistics, vol. 31(i07).
    16. 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.
    17. 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.
    18. E A Shale & J E Boylan & F R Johnston, 2006. "Forecasting for intermittent demand: the estimation of an unbiased average," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 57(5), pages 588-592, May.
    19. Ling Li, 2007. "Supply Chain Management: Concepts, Techniques and Practices:Enhancing Value Through Collaboration," World Scientific Books, World Scientific Publishing Co. Pte. Ltd., number 6273, February.
    20. 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.
    21. Kourentzes, Nikolaos, 2013. "Intermittent demand forecasts with neural networks," International Journal of Production Economics, Elsevier, vol. 143(1), pages 198-206.
    22. Syntetos, Aris A. & Boylan, John E., 2005. "The accuracy of intermittent demand estimates," International Journal of Forecasting, Elsevier, vol. 21(2), pages 303-314.
    23. Kourentzes, Nikolaos, 2014. "On intermittent demand model optimisation and selection," International Journal of Production Economics, Elsevier, vol. 156(C), pages 180-190.
    24. Nikolopoulos, Konstantinos I. & Babai, M. Zied & Bozos, Konstantinos, 2016. "Forecasting supply chain sporadic demand with nearest neighbor approaches," International Journal of Production Economics, Elsevier, vol. 177(C), pages 139-148.
    25. 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.
    26. 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.
    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. Serban, Nicoleta & Wasserman, Larry, 2005. "CATS: Clustering After Transformation and Smoothing," Journal of the American Statistical Association, American Statistical Association, vol. 100, pages 990-999, September.
    29. 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. 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).
    2. 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.
    3. Kourentzes, Nikolaos & Athanasopoulos, George, 2021. "Elucidate structure in intermittent demand series," European Journal of Operational Research, Elsevier, vol. 288(1), pages 141-152.
    4. 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.
    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. 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.
    7. Pinçe, Çerağ & Turrini, Laura & Meissner, Joern, 2021. "Intermittent demand forecasting for spare parts: A Critical review," Omega, Elsevier, vol. 105(C).
    8. 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.
    9. 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.
    10. 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).
    11. 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.
    12. 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.
    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. 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.
    15. 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.
    16. 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.
    17. 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.
    18. 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.
    19. Nikolopoulos, Konstantinos, 2021. "We need to talk about intermittent demand forecasting," European Journal of Operational Research, Elsevier, vol. 291(2), pages 549-559.
    20. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2022. "Retail forecasting: Research and practice," International Journal of Forecasting, Elsevier, vol. 38(4), pages 1283-1318.

    More about this item

    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:wly:jforec:v:43:y:2024:i:5:p:1661-1681. 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: Wiley Content Delivery (email available below). General contact details of provider: http://www3.interscience.wiley.com/cgi-bin/jhome/2966 .

    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.