IDEAS home Printed from https://ideas.repec.org/a/gam/jmathe/v10y2022i17p3179-d905933.html
   My bibliography  Save this article

Dynamic Model Selection Based on Demand Pattern Classification in Retail Sales Forecasting

Author

Listed:
  • Erjiang E

    (School of Management, Guangxi Minzu University, Nanning 530006, China)

  • Ming Yu

    (Department of Industrial Engineering, Tsinghua University, Beijing 100084, China)

  • Xin Tian

    (School of Economics and Management, University of Chinese Academy of Sciences, Beijing 100190, China
    Research Center on Fictitious Economy and Data Science, Chinese Academy of Sciences, Beijing 100190, China)

  • Ye Tao

    (Beijing Haolinju CVS Co., Ltd., Beijing 100190, China)

Abstract

Many forecasting techniques have been applied to sales forecasts in the retail industry. However, no one prediction model is applicable to all cases. For demand forecasting of the same item, the different results of prediction models often confuse retailers. For large retail companies with a wide variety of products, it is difficult to find a suitable prediction model for each item. This study aims to propose a dynamic model selection approach that combines individual selection and combination forecasts based on both the demand patterns and the out-of-sample performance for each item. Firstly, based on both metrics of the squared coefficient of variation (CV 2 ) and the average inter-demand interval (ADI), we divide the demand patterns of items into four types: smooth, intermittent, erratic, and lumpy. Secondly, we select nine classical forecasting methods in the M-Competitions to build a pool of models. Thirdly, we design two dynamic weighting strategies to determine the final prediction, namely DWS-A and DWS-B. Finally, we verify the effectiveness of this approach by using two large datasets from an offline retailer and an online retailer in China. The empirical results show that these two strategies can effectively improve the accuracy of demand forecasting. The DWS-A method is suitable for items with the demand patterns of intermittent and lumpy, while the DWS-B method is suitable for items with the demand patterns of smooth and erratic.

Suggested Citation

  • Erjiang E & Ming Yu & Xin Tian & Ye Tao, 2022. "Dynamic Model Selection Based on Demand Pattern Classification in Retail Sales Forecasting," Mathematics, MDPI, vol. 10(17), pages 1-16, September.
  • Handle: RePEc:gam:jmathe:v:10:y:2022:i:17:p:3179-:d:905933
    as

    Download full text from publisher

    File URL: https://www.mdpi.com/2227-7390/10/17/3179/pdf
    Download Restriction: no

    File URL: https://www.mdpi.com/2227-7390/10/17/3179/
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Robert Fildes, 1989. "Evaluation of Aggregate and Individual Forecast Method Selection Rules," Management Science, INFORMS, vol. 35(9), pages 1056-1065, September.
    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. 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.
    4. Assimakopoulos, V. & Nikolopoulos, K., 2000. "The theta model: a decomposition approach to forecasting," International Journal of Forecasting, Elsevier, vol. 16(4), pages 521-530.
    5. Ramya Neelamegham & Pradeep K. Chintagunta, 2004. "Modeling and Forecasting the Sales of Technology Products," Quantitative Marketing and Economics (QME), Springer, vol. 2(3), pages 195-232, September.
    6. Lihki Rubio & Keyla Alba, 2022. "Forecasting Selected Colombian Shares Using a Hybrid ARIMA-SVR Model," Mathematics, MDPI, vol. 10(13), pages 1-21, June.
    7. Claeskens, Gerda & Magnus, Jan R. & Vasnev, Andrey L. & Wang, Wendun, 2016. "The forecast combination puzzle: A simple theoretical explanation," International Journal of Forecasting, Elsevier, vol. 32(3), pages 754-762.
    8. 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.
    9. Petropoulos, Fotios & Svetunkov, Ivan, 2020. "A simple combination of univariate models," International Journal of Forecasting, Elsevier, vol. 36(1), pages 110-115.
    10. David Simchi-Levi & Michelle Xiao Wu, 2018. "Powering retailers’ digitization through analytics and automation," International Journal of Production Research, Taylor & Francis Journals, vol. 56(1-2), pages 809-816, January.
    11. Makridakis, Spyros & Hibon, Michele, 2000. "The M3-Competition: results, conclusions and implications," International Journal of Forecasting, Elsevier, vol. 16(4), pages 451-476.
    12. Peng, Bo & Song, Haiyan & Crouch, Geoffrey I., 2014. "A meta-analysis of international tourism demand forecasting and implications for practice," Tourism Management, Elsevier, vol. 45(C), pages 181-193.
    13. Arunraj, Nari Sivanandam & Ahrens, Diane, 2015. "A hybrid seasonal autoregressive integrated moving average and quantile regression for daily food sales forecasting," International Journal of Production Economics, Elsevier, vol. 170(PA), pages 321-335.
    14. Holt, Charles C., 2004. "Author's retrospective on 'Forecasting seasonals and trends by exponentially weighted moving averages'," International Journal of Forecasting, Elsevier, vol. 20(1), pages 11-13.
    15. Makridakis, Spyros & Spiliotis, Evangelos & Assimakopoulos, Vassilios, 2018. "The M4 Competition: Results, findings, conclusion and way forward," International Journal of Forecasting, Elsevier, vol. 34(4), pages 802-808.
    16. Holt, Charles C., 2004. "Forecasting seasonals and trends by exponentially weighted moving averages," International Journal of Forecasting, Elsevier, vol. 20(1), pages 5-10.
    17. Suresh Divakar & Brian T. Ratchford & Venkatesh Shankar, 2005. "Practice Prize Article—: A Multichannel, Multiregion Sales Forecasting Model and Decision Support System for Consumer Packaged Goods," Marketing Science, INFORMS, vol. 24(3), pages 334-350, July.
    18. Kuo, R. J., 2001. "A sales forecasting system based on fuzzy neural network with initial weights generated by genetic algorithm," European Journal of Operational Research, Elsevier, vol. 129(3), pages 496-517, March.
    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. Liu, Hsiu-Wen, 2024. "Mining spatial-temporal patterns from customer data to improve forecasting of customer flow across multiple sites," Journal of Retailing and Consumer Services, Elsevier, vol. 79(C).
    2. Tendai Makoni & Delson Chikobvu, 2023. "Assessing and Forecasting the Long-Term Impact of the Global Financial Crisis on New Car Sales in South Africa," Data, MDPI, vol. 8(5), pages 1-16, April.
    3. Wen Zhang & Xiaofeng Xu & Jun Wu & Kaijian He, 2023. "Preface to the Special Issue on “Computational and Mathematical Methods in Information Science and Engineering”," Mathematics, MDPI, vol. 11(14), pages 1-4, July.

    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. Meira, Erick & Cyrino Oliveira, Fernando Luiz & de Menezes, Lilian M., 2022. "Forecasting natural gas consumption using Bagging and modified regularization techniques," Energy Economics, Elsevier, vol. 106(C).
    3. 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.
    4. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2019. "Retail forecasting: research and practice," MPRA Paper 89356, University Library of Munich, Germany.
    5. Pantelis Agathangelou & Demetris Trihinas & Ioannis Katakis, 2020. "A Multi-Factor Analysis of Forecasting Methods: A Study on the M4 Competition," Data, MDPI, vol. 5(2), pages 1-24, April.
    6. Kang, Yanfei & Spiliotis, Evangelos & Petropoulos, Fotios & Athiniotis, Nikolaos & Li, Feng & Assimakopoulos, Vassilios, 2021. "Déjà vu: A data-centric forecasting approach through time series cross-similarity," Journal of Business Research, Elsevier, vol. 132(C), pages 719-731.
    7. 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.
    8. 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.
    9. R Fildes & K Nikolopoulos & S F Crone & A A Syntetos, 2008. "Forecasting and operational research: a review," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 59(9), pages 1150-1172, September.
    10. 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.
    11. Kang, Yanfei & Cao, Wei & Petropoulos, Fotios & Li, Feng, 2022. "Forecast with forecasts: Diversity matters," European Journal of Operational Research, Elsevier, vol. 301(1), pages 180-190.
    12. Theodosiou, Marina, 2011. "Forecasting monthly and quarterly time series using STL decomposition," International Journal of Forecasting, Elsevier, vol. 27(4), pages 1178-1195, October.
    13. 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.
    14. Petropoulos, Fotios & Makridakis, Spyros & Assimakopoulos, Vassilios & Nikolopoulos, Konstantinos, 2014. "‘Horses for Courses’ in demand forecasting," European Journal of Operational Research, Elsevier, vol. 237(1), pages 152-163.
    15. Gardner, Everette Jr., 2006. "Exponential smoothing: The state of the art--Part II," International Journal of Forecasting, Elsevier, vol. 22(4), pages 637-666.
    16. Makridakis, Spyros & Spiliotis, Evangelos & Assimakopoulos, Vassilios, 2022. "Predicting/hypothesizing the findings of the M5 competition," International Journal of Forecasting, Elsevier, vol. 38(4), pages 1337-1345.
    17. 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.
    18. Andrea Kolková & Petr Rozehnal, 2022. "Hybrid demand forecasting models: pre-pandemic and pandemic use studies," Equilibrium. Quarterly Journal of Economics and Economic Policy, Institute of Economic Research, vol. 17(3), pages 699-725, September.
    19. Wang, Xiaoqian & Hyndman, Rob J. & Li, Feng & Kang, Yanfei, 2023. "Forecast combinations: An over 50-year review," International Journal of Forecasting, Elsevier, vol. 39(4), pages 1518-1547.
    20. Wellens, Arnoud P. & Boute, Robert N. & Udenio, Maximiliano, 2024. "Simplifying tree-based methods for retail sales forecasting with explanatory variables," European Journal of Operational Research, Elsevier, vol. 314(2), pages 523-539.

    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:gam:jmathe:v:10:y:2022:i:17:p:3179-:d:905933. 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: MDPI Indexing Manager (email available below). General contact details of provider: https://www.mdpi.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.