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

Using shared sell-through data to forecast wholesaler demand in multi-echelon supply chains

Author

Listed:
  • Van Belle, Jente
  • Guns, Tias
  • Verbeke, Wouter

Abstract

Operational forecasting in supply chain management supports a variety of short-term planning decisions, such as production scheduling and inventory management. In this respect, improving short-term forecast accuracy is a way to build a more agile supply chain for manufacturing companies. Demand forecasting often relies on well-established univariate forecasting methods to extrapolate historical demand. Collaboration across the supply chain, including information sharing, is suggested in the literature to improve upon the forecast accuracy of such traditional methods. In this paper, we review empirical studies considering the use of downstream information in demand forecasting and investigate different modeling approaches and forecasting methods to incorporate such data. Where empirical findings on information sharing mainly focus on point-of-sale data in two-level supply chains, this research empirically investigates the added value of using sell-through data originating from intermediaries, next to historical demand figures, in a multi-echelon supply chain. In a case study concerning a US drug manufacturer, we evaluate different methods to incorporate this data and consider both time series methods and machine learning techniques to produce multi-step ahead weekly forecasts. The results show that the manufacturer can effectively improve its short-term forecast accuracy by integrating sell-through data into the forecasting process and provide useful insights as to the different modeling approaches used. The conclusion holds for all forecast horizons considered, though it is most pronounced for one-step ahead forecasts. Therefore, our research provides a clear incentive for manufacturers to assess the forecast accuracy that can be achieved by using sell-through data.

Suggested Citation

  • Van Belle, Jente & Guns, Tias & Verbeke, Wouter, 2021. "Using shared sell-through data to forecast wholesaler demand in multi-echelon supply chains," European Journal of Operational Research, Elsevier, vol. 288(2), pages 466-479.
  • Handle: RePEc:eee:ejores:v:288:y:2021:i:2:p:466-479
    DOI: 10.1016/j.ejor.2020.05.059
    as

    Download full text from publisher

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

    File URL: https://libkey.io/10.1016/j.ejor.2020.05.059?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. Wright, Marvin N. & Ziegler, Andreas, 2017. "ranger: A Fast Implementation of Random Forests for High Dimensional Data in C++ and R," Journal of Statistical Software, Foundation for Open Access Statistics, vol. 77(i01).
    2. Bergmeir, Christoph & Hyndman, Rob J. & Koo, Bonsoo, 2018. "A note on the validity of cross-validation for evaluating autoregressive time series prediction," Computational Statistics & Data Analysis, Elsevier, vol. 120(C), pages 70-83.
    3. Zhang, Cheng & Tan, Gek-Woo & Robb, David J. & Zheng, Xin, 2006. "Sharing shipment quantity information in the supply chain," Omega, Elsevier, vol. 34(5), pages 427-438, October.
    4. Hyndman, Rob J. & Khandakar, Yeasmin, 2008. "Automatic Time Series Forecasting: The forecast Package for R," Journal of Statistical Software, Foundation for Open Access Statistics, vol. 27(i03).
    5. Srinivasan Raghunathan, 2001. "Information Sharing in a Supply Chain: A Note on its Value when Demand Is Nonstationary," Management Science, INFORMS, vol. 47(4), pages 605-610, April.
    6. Byrne, P.J. & Heavey, Cathal, 2006. "The impact of information sharing and forecasting in capacitated industrial supply chains: A case study," International Journal of Production Economics, Elsevier, vol. 103(1), pages 420-437, September.
    7. Tashman, Leonard J., 2000. "Out-of-sample tests of forecasting accuracy: an analysis and review," International Journal of Forecasting, Elsevier, vol. 16(4), pages 437-450.
    8. Friedman, Jerome H. & Hastie, Trevor & Tibshirani, Rob, 2010. "Regularization Paths for Generalized Linear Models via Coordinate Descent," Journal of Statistical Software, Foundation for Open Access Statistics, vol. 33(i01).
    9. Kuhn, Max, 2008. "Building Predictive Models in R Using the caret Package," Journal of Statistical Software, Foundation for Open Access Statistics, vol. 28(i05).
    10. Sagaert, Yves R. & Aghezzaf, El-Houssaine & Kourentzes, Nikolaos & Desmet, Bram, 2018. "Tactical sales forecasting using a very large set of macroeconomic indicators," European Journal of Operational Research, Elsevier, vol. 264(2), pages 558-569.
    11. 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.
    12. Hartzel, Kathleen S. & Wood, Charles A., 2017. "Factors that affect the improvement of demand forecast accuracy through point-of-sale reporting," European Journal of Operational Research, Elsevier, vol. 260(1), pages 171-182.
    13. Kourentzes, Nikolaos & Petropoulos, Fotios, 2016. "Forecasting with multivariate temporal aggregation: The case of promotional modelling," International Journal of Production Economics, Elsevier, vol. 181(PA), pages 145-153.
    14. Trapero, Juan R. & Pedregal, Diego J. & Fildes, R. & Kourentzes, N., 2013. "Analysis of judgmental adjustments in the presence of promotions," International Journal of Forecasting, Elsevier, vol. 29(2), pages 234-243.
    15. 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.
    16. Huang, Tao & Fildes, Robert & Soopramanien, Didier, 2014. "The value of competitive information in forecasting FMCG retail product sales and the variable selection problem," European Journal of Operational Research, Elsevier, vol. 237(2), pages 738-748.
    17. Ma, Shaohui & Fildes, Robert & Huang, Tao, 2016. "Demand forecasting with high dimensional data: The case of SKU retail sales forecasting with intra- and inter-category promotional information," European Journal of Operational Research, Elsevier, vol. 249(1), pages 245-257.
    18. Spyros Makridakis & Evangelos Spiliotis & Vassilios Assimakopoulos, 2018. "Statistical and Machine Learning forecasting methods: Concerns and ways forward," PLOS ONE, Public Library of Science, vol. 13(3), pages 1-26, March.
    19. Trapero, Juan R. & Kourentzes, N. & Fildes, R., 2012. "Impact of information exchange on supplier forecasting performance," Omega, Elsevier, vol. 40(6), pages 738-747.
    20. Zhang, Guoqiang & Eddy Patuwo, B. & Y. Hu, Michael, 1998. "Forecasting with artificial neural networks:: The state of the art," International Journal of Forecasting, Elsevier, vol. 14(1), pages 35-62, March.
    21. Juan R Trapero & Nikolaos Kourentzes & Robert Fildes, 2015. "On the identification of sales forecasting models in the presence of promotions," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 66(2), pages 299-307, February.
    22. Hau L. Lee & V. Padmanabhan & Seungjin Whang, 1997. "Information Distortion in a Supply Chain: The Bullwhip Effect," Management Science, INFORMS, vol. 43(4), pages 546-558, April.
    23. Kyu Kim, Kyung & Yul Ryoo, Sung & Dug Jung, Myung, 2011. "Inter-organizational information systems visibility in buyer-supplier relationships: The case of telecommunication equipment component manufacturing industry," Omega, Elsevier, vol. 39(6), pages 667-676, December.
    24. Frank Chen & Zvi Drezner & Jennifer K. Ryan & David Simchi-Levi, 2000. "Quantifying the Bullwhip Effect in a Simple Supply Chain: The Impact of Forecasting, Lead Times, and Information," Management Science, INFORMS, vol. 46(3), pages 436-443, March.
    25. Sanders, Nada R. & Graman, Gregory A., 2009. "Quantifying costs of forecast errors: A case study of the warehouse environment," Omega, Elsevier, vol. 37(1), pages 116-125, February.
    26. G. Di Pillo & V. Latorre & S. Lucidi & E. Procacci, 2016. "An application of support vector machines to sales forecasting under promotions," 4OR, Springer, vol. 14(3), pages 309-325, September.
    27. 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.
    28. Williams, Brent D. & Waller, Matthew A. & Ahire, Sanjay & Ferrier, Gary D., 2014. "Predicting retailer orders with POS and order data: The inventory balance effect," European Journal of Operational Research, Elsevier, vol. 232(3), pages 593-600.
    29. 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.
    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)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Xiaodan Zhu & Anh Ninh & Hui Zhao & Zhenming Liu, 2021. "Demand Forecasting with Supply‐Chain Information and Machine Learning: Evidence in the Pharmaceutical Industry," Production and Operations Management, Production and Operations Management Society, vol. 30(9), pages 3231-3252, September.
    2. Van Belle, Jente & Crevits, Ruben & Verbeke, Wouter, 2023. "Improving forecast stability using deep learning," International Journal of Forecasting, Elsevier, vol. 39(3), pages 1333-1350.

    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. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2022. "Retail forecasting: Research and practice," International Journal of Forecasting, Elsevier, vol. 38(4), pages 1283-1318.
    2. Huber, Jakob & Stuckenschmidt, Heiner, 2020. "Daily retail demand forecasting using machine learning with emphasis on calendric special days," International Journal of Forecasting, Elsevier, vol. 36(4), pages 1420-1438.
    3. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2019. "Retail forecasting: research and practice," MPRA Paper 89356, University Library of Munich, Germany.
    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. Sagaert, Yves R. & Aghezzaf, El-Houssaine & Kourentzes, Nikolaos & Desmet, Bram, 2018. "Tactical sales forecasting using a very large set of macroeconomic indicators," European Journal of Operational Research, Elsevier, vol. 264(2), pages 558-569.
    6. Ma, Shaohui & Fildes, Robert, 2021. "Retail sales forecasting with meta-learning," European Journal of Operational Research, Elsevier, vol. 288(1), pages 111-128.
    7. Trapero, Juan R. & Kourentzes, N. & Fildes, R., 2012. "Impact of information exchange on supplier forecasting performance," Omega, Elsevier, vol. 40(6), pages 738-747.
    8. 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.
    9. Makridakis, Spyros & Spiliotis, Evangelos & Assimakopoulos, Vassilios, 2022. "M5 accuracy competition: Results, findings, and conclusions," International Journal of Forecasting, Elsevier, vol. 38(4), pages 1346-1364.
    10. Ma, Shaohui & Fildes, Robert, 2020. "Forecasting third-party mobile payments with implications for customer flow prediction," International Journal of Forecasting, Elsevier, vol. 36(3), pages 739-760.
    11. 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.
    12. Hewamalage, Hansika & Bergmeir, Christoph & Bandara, Kasun, 2021. "Recurrent Neural Networks for Time Series Forecasting: Current status and future directions," International Journal of Forecasting, Elsevier, vol. 37(1), pages 388-427.
    13. 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).
    14. Semenoglou, Artemios-Anargyros & Spiliotis, Evangelos & Makridakis, Spyros & Assimakopoulos, Vassilios, 2021. "Investigating the accuracy of cross-learning time series forecasting methods," International Journal of Forecasting, Elsevier, vol. 37(3), pages 1072-1084.
    15. Sagaert, Yves R. & Kourentzes, Nikolaos & De Vuyst, Stijn & Aghezzaf, El-Houssaine & Desmet, Bram, 2019. "Incorporating macroeconomic leading indicators in tactical capacity planning," International Journal of Production Economics, Elsevier, vol. 209(C), pages 12-19.
    16. Ma, Shaohui & Fildes, Robert, 2017. "A retail store SKU promotions optimization model for category multi-period profit maximization," European Journal of Operational Research, Elsevier, vol. 260(2), pages 680-692.
    17. Athanasopoulos, George & Kourentzes, Nikolaos, 2023. "On the evaluation of hierarchical forecasts," International Journal of Forecasting, Elsevier, vol. 39(4), pages 1502-1511.
    18. Gür Ali, Özden & Gürlek, Ragıp, 2020. "Automatic Interpretable Retail forecasting with promotional scenarios," International Journal of Forecasting, Elsevier, vol. 36(4), pages 1389-1406.
    19. Evangelos Spiliotis & Fotios Petropoulos & Vassilios Assimakopoulos, 2023. "On the Disagreement of Forecasting Model Selection Criteria," Forecasting, MDPI, vol. 5(2), pages 1-12, June.
    20. Sroginis, Anna & Fildes, Robert & Kourentzes, Nikolaos, 2023. "Use of contextual and model-based information in adjusting promotional forecasts," European Journal of Operational Research, Elsevier, vol. 307(3), pages 1177-1191.

    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:288:y:2021:i:2:p:466-479. 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.