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. 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.
    2. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2019. "Retail forecasting: research and practice," MPRA Paper 89356, University Library of Munich, Germany.
    3. Geurts, Michael D. & Patrick Kelly, J., 1986. "Forecasting retail sales using alternative models," International Journal of Forecasting, Elsevier, vol. 2(3), pages 261-272.
    4. 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.
    5. 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.
    6. 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.
    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.
    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. 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.
    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. 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).
    8. 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.
    9. Aye, Goodness C. & Balcilar, Mehmet & Gupta, Rangan & Majumdar, Anandamayee, 2015. "Forecasting aggregate retail sales: The case of South Africa," International Journal of Production Economics, Elsevier, vol. 160(C), pages 66-79.
    10. 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.
    11. Oscar Claveria & Enric Monte & Salvador Torra, 2016. "Modelling cross-dependencies between Spain’s regional tourism markets with an extension of the Gaussian process regression model," SERIEs: Journal of the Spanish Economic Association, Springer;Spanish Economic Association, vol. 7(3), pages 341-357, August.
    12. Thais de Castro Moraes & Xue‐Ming Yuan & Ek Peng Chew, 2024. "Hybrid convolutional long short‐term memory models for sales forecasting in retail," Journal of Forecasting, John Wiley & Sons, Ltd., vol. 43(5), pages 1278-1293, August.
    13. 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.
    14. 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.
    15. Xiaojie Xu & Yun Zhang, 2022. "Forecasting the total market value of a shares traded in the Shenzhen stock exchange via the neural network," Economics Bulletin, AccessEcon, vol. 42(3), pages 1266-1279.
    16. Oscar Claveria & Enric Monte & Salvador Torra, 2014. "“A multivariate neural network approach to tourism demand forecasting”," AQR Working Papers 201410, University of Barcelona, Regional Quantitative Analysis Group, revised May 2014.
    17. Sohrabpour, Vahid & Oghazi, Pejvak & Toorajipour, Reza & Nazarpour, Ali, 2021. "Export sales forecasting using artificial intelligence," Technological Forecasting and Social Change, Elsevier, vol. 163(C).
    18. Claveria, Oscar & Torra, Salvador, 2014. "Forecasting tourism demand to Catalonia: Neural networks vs. time series models," Economic Modelling, Elsevier, vol. 36(C), pages 220-228.
    19. Vortelinos, Dimitrios I., 2017. "Forecasting realized volatility: HAR against Principal Components Combining, neural networks and GARCH," Research in International Business and Finance, Elsevier, vol. 39(PB), pages 824-839.
    20. 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.

    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.