IDEAS home Printed from https://ideas.repec.org/a/vrs/manmar/v15y2020i2p186-202n4.html
   My bibliography  Save this article

Demand Forecasting of Retail Sales Using Data Analytics and Statistical Programming

Author

Listed:
  • Lalou Panagiota

    (National Technical University Athens, School of Mechanical Engineering, Athens, Greece)

  • Ponis Stavros T.

    (National Technical University Athens, School of Mechanical Engineering, Athens, Greece)

  • Efthymiou Orestis K.

    (Trade Logistics S.A.)

Abstract

Forecasting the demand of network of retail sales is a rather challenging task, especially nowadays where integration of online and physical store orders creates an abundance of data that has to be efficiently stored, analyzed, understood and finally, become ready to be acted upon in a very short time frame. The challenge becomes even bigger for added-value third party logistics (3PL) operators, since in most cases and demand forecasting aside, they are also responsible for receiving, storing and breaking inbound quantities from suppliers, consolidating and picking retail orders and finally plan and organize shipments on a daily basis. This paper argues that data analytics can play a critical role in contemporary logistics and especially in demand data management and forecasting of retail distribution networks. The main objective of the research presented in this paper is to showcase how data analytics can support the 3PL decision making process on replenishing the network stores, thus improving inventory management in both Distribution Centre (DC) and retail outlet levels and the workload planning of human resources and DC automations. To do so, this paper presents the case of a Greek 3PL provider fulfilling physical store and online orders on behalf of a large sporting goods importer operating a network of 129 stores in five different countries. The authors utilize the power of ‘R’, a statistical programming language, which is well-equipped with a multitude of libraries for this purpose, to compare demand forecasting methods and identify the one producing the smallest forecast error.

Suggested Citation

  • Lalou Panagiota & Ponis Stavros T. & Efthymiou Orestis K., 2020. "Demand Forecasting of Retail Sales Using Data Analytics and Statistical Programming," Management & Marketing, Sciendo, vol. 15(2), pages 186-202, June.
  • Handle: RePEc:vrs:manmar:v:15:y:2020:i:2:p:186-202:n:4
    DOI: 10.2478/mmcks-2020-0012
    as

    Download full text from publisher

    File URL: https://doi.org/10.2478/mmcks-2020-0012
    Download Restriction: no

    File URL: https://libkey.io/10.2478/mmcks-2020-0012?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. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2019. "Retail forecasting: research and practice," MPRA Paper 89356, University Library of Munich, Germany.
    2. Au, Kin-Fan & Choi, Tsan-Ming & Yu, Yong, 2008. "Fashion retail forecasting by evolutionary neural networks," International Journal of Production Economics, Elsevier, vol. 114(2), pages 615-630, August.
    3. Zhang, G. Peter & Qi, Min, 2005. "Neural network forecasting for seasonal and trend time series," European Journal of Operational Research, Elsevier, vol. 160(2), pages 501-514, January.
    4. Wong, W.K. & Guo, Z.X., 2010. "A hybrid intelligent model for medium-term sales forecasting in fashion retail supply chains using extreme learning machine and harmony search algorithm," International Journal of Production Economics, Elsevier, vol. 128(2), pages 614-624, December.
    5. Diebold, Francis X & Mariano, Roberto S, 2002. "Comparing Predictive Accuracy," Journal of Business & Economic Statistics, American Statistical Association, vol. 20(1), pages 134-144, January.
    6. Geurts, Michael D. & Patrick Kelly, J., 1986. "Forecasting retail sales using alternative models," International Journal of Forecasting, Elsevier, vol. 2(3), pages 261-272.
    7. Boone, Tonya & Ganeshan, Ram & Jain, Aditya & Sanders, Nada R., 2019. "Forecasting sales in the supply chain: Consumer analytics in the big data era," International Journal of Forecasting, Elsevier, vol. 35(1), pages 170-180.
    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. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2022. "Retail forecasting: Research and practice," International Journal of Forecasting, Elsevier, vol. 38(4), pages 1283-1318.
    2. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2019. "Retail forecasting: research and practice," MPRA Paper 89356, University Library of Munich, Germany.
    3. Swaminathan, Kritika & Venkitasubramony, Rakesh, 2024. "Demand forecasting for fashion products: A systematic review," International Journal of Forecasting, Elsevier, vol. 40(1), pages 247-267.
    4. Md. Iftekharul Alam Efat & Petr Hajek & Mohammad Zoynul Abedin & Rahat Uddin Azad & Md. Al Jaber & Shuvra Aditya & Mohammad Kabir Hassan, 2024. "Deep-learning model using hybrid adaptive trend estimated series for modelling and forecasting sales," Annals of Operations Research, Springer, vol. 339(1), pages 297-328, August.
    5. Omar, Haytham & Klibi, Walid & Babai, M. Zied & Ducq, Yves, 2023. "Basket data-driven approach for omnichannel demand forecasting," International Journal of Production Economics, Elsevier, vol. 257(C).
    6. 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.
    7. Wong, W.K. & Guo, Z.X., 2010. "A hybrid intelligent model for medium-term sales forecasting in fashion retail supply chains using extreme learning machine and harmony search algorithm," International Journal of Production Economics, Elsevier, vol. 128(2), pages 614-624, December.
    8. Shuyun Ren & Hau-Ling Chan & Tana Siqin, 2020. "Demand forecasting in retail operations for fashionable products: methods, practices, and real case study," Annals of Operations Research, Springer, vol. 291(1), pages 761-777, August.
    9. Emmanuel Sirimal Silva & Hossein Hassani & Dag Øivind Madsen & Liz Gee, 2019. "Googling Fashion: Forecasting Fashion Consumer Behaviour Using Google Trends," Social Sciences, MDPI, vol. 8(4), pages 1-23, April.
    10. Sohrabpour, Vahid & Oghazi, Pejvak & Toorajipour, Reza & Nazarpour, Ali, 2021. "Export sales forecasting using artificial intelligence," Technological Forecasting and Social Change, Elsevier, vol. 163(C).
    11. 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.
    12. Majd Kharfan & Vicky Wing Kei Chan & Tugba Firdolas Efendigil, 2021. "A data-driven forecasting approach for newly launched seasonal products by leveraging machine-learning approaches," Annals of Operations Research, Springer, vol. 303(1), pages 159-174, August.
    13. Gradojevic, Nikola & Kukolj, Dragan & Adcock, Robert & Djakovic, Vladimir, 2023. "Forecasting Bitcoin with technical analysis: A not-so-random forest?," International Journal of Forecasting, Elsevier, vol. 39(1), pages 1-17.
    14. Charalampos Stasinakis & Georgios Sermpinis & Konstantinos Theofilatos & Andreas Karathanasopoulos, 2016. "Forecasting US Unemployment with Radial Basis Neural Networks, Kalman Filters and Support Vector Regressions," Computational Economics, Springer;Society for Computational Economics, vol. 47(4), pages 569-587, April.
    15. Jan G. De Gooijer & Rob J. Hyndman, 2005. "25 Years of IIF Time Series Forecasting: A Selective Review," Monash Econometrics and Business Statistics Working Papers 12/05, Monash University, Department of Econometrics and Business Statistics.
    16. Heni Boubaker & Giorgio Canarella & Rangan Gupta & Stephen M. Miller, 2023. "A Hybrid ARFIMA Wavelet Artificial Neural Network Model for DJIA Index Forecasting," Computational Economics, Springer;Society for Computational Economics, vol. 62(4), pages 1801-1843, December.
    17. Dinis, Duarte & Barbosa-Póvoa, Ana & Teixeira, Ângelo Palos, 2022. "Enhancing capacity planning through forecasting: An integrated tool for maintenance of complex product systems," International Journal of Forecasting, Elsevier, vol. 38(1), pages 178-192.
    18. Akylas Stratigakos & Athanasios Bachoumis & Vasiliki Vita & Elias Zafiropoulos, 2021. "Short-Term Net Load Forecasting with Singular Spectrum Analysis and LSTM Neural Networks," Energies, MDPI, vol. 14(14), pages 1-13, July.
    19. Grzegorz Marcjasz & Bartosz Uniejewski & Rafal Weron, 2017. "Importance of the long-term seasonal component in day-ahead electricity price forecasting revisited: Neural network models," HSC Research Reports HSC/17/03, Hugo Steinhaus Center, Wroclaw University of Science and Technology.
    20. Marcjasz, Grzegorz & Uniejewski, Bartosz & Weron, Rafał, 2019. "On the importance of the long-term seasonal component in day-ahead electricity price forecasting with NARX neural networks," International Journal of Forecasting, Elsevier, vol. 35(4), pages 1520-1532.

    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:vrs:manmar:v:15:y:2020:i:2:p:186-202:n:4. 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: Peter Golla (email available below). General contact details of provider: https://www.sciendo.com .

    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.