IDEAS home Printed from https://ideas.repec.org/a/brc/brccej/v7y2022i2p161-173.html
   My bibliography  Save this article

Application Of Autoregressive Integrated Moving Average And Holt Winters Methods For Optimum Sales Forecasting In The Manufacturing Sector

Author

Listed:
  • Sulaimon Olanrewaju ADEBIYI

    (Department of Business Administration, University of Lagos, Akoka, Lagos, Nigeria)

  • Oluwayemisi Temitope SODOLAMU

    (Department of Business Administration, University of Lagos, Akoka, Lagos, Nigeria)

Abstract

This study investigated into the application of autoregressive integrated moving average (ARIMA) and Holt winters methods for optimum sales forecasting of Nestle Nigeria plc, Lagos Nigeria. The purpose of this study is to examine sales forecasting model using ARIMA and Holt Winters methods for short-term decision-making. The specific objectives are to: assess the future sales of Nestle Nigeria Plc. using ARIMA forecasting model, evaluate the future sales of Nestle Nigerian Plc. using Holt Winters forecasting model, examine the optimum forecasting model between ARIMA and Holt Winter for Nestle Nigeria Plc, determine the appropriate forecasting model for Nestle Nigeria Plc. short term forecasting. Secondary data were sourced from yearly sales revenue data of Nestle Nigeria Plc., from 1990 to 2017 and analysed with the aid of Minitab software. Holt winters multiplicative model MAPE, MAD and MSD were 2.3, 1.7 and 4.8 respectively, while ARIMA is 1.8, 1., and 5.4 respectively. The result shows that the appropriate model is ARIMA model for Nestle Nig. to predict short term forecasting since, it has the lower value of the performance metrics. The result also revealed that ARIMA method seem more effective and powerful going by the MAPE result. It was recommended that in advance of attempting simple method of prediction, it is helpful in trying more complex ones equally they have the capacity to make available additional and precise outcomes in certain conditions.

Suggested Citation

  • Sulaimon Olanrewaju ADEBIYI & Oluwayemisi Temitope SODOLAMU, 2022. "Application Of Autoregressive Integrated Moving Average And Holt Winters Methods For Optimum Sales Forecasting In The Manufacturing Sector," Contemporary Economy Journal, Constantin Brancoveanu University, vol. 7(2), pages 161-173.
    • Handle: RePEc:brc:brccej:v:7:y:2022:i:2:p:161-173
    as

    Download full text from publisher

    File URL: http://www.revec.ro/papers/220220.pdf
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. 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.
    2. Richard M. Cyert & James G. March & William H. Starbuck, 1961. "Two Experiments on Bias and Conflict in Organizational Estimation," Management Science, INFORMS, vol. 7(3), pages 254-264, 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. repec:prg:jnlcfu:v:2022:y:2022:i:1:id:572 is not listed on IDEAS
    2. Cabral, Joilson de Assis & Freitas Cabral, Maria Viviana de & Pereira Júnior, Amaro Olímpio, 2020. "Elasticity estimation and forecasting: An analysis of residential electricity demand in Brazil," Utilities Policy, Elsevier, vol. 66(C).
    3. Das, Prashant & Füss, Roland & Hanle, Benjamin & Russ, Isabel Nina, 2020. "The cross-over effect of irrational sentiments in housing, commercial property, and stock markets," Journal of Banking & Finance, Elsevier, vol. 114(C).
    4. Thé, Jesse & Yu, Hesheng, 2017. "A critical review on the simulations of wind turbine aerodynamics focusing on hybrid RANS-LES methods," Energy, Elsevier, vol. 138(C), pages 257-289.
    5. Ioannis Badounas & Georgios Pitselis, 2020. "Loss Reserving Estimation With Correlated Run-Off Triangles in a Quantile Longitudinal Model," Risks, MDPI, vol. 8(1), pages 1-26, February.
    6. Chang, Andrew C. & Hanson, Tyler J., 2016. "The accuracy of forecasts prepared for the Federal Open Market Committee," Journal of Economics and Business, Elsevier, vol. 83(C), pages 23-43.
    7. Michael Kostmann & Wolfgang K. Härdle, 2019. "Forecasting in Blockchain-Based Local Energy Markets," Energies, MDPI, vol. 12(14), pages 1-27, July.
    8. Hayat, Aziz & Bhatti, M. Ishaq, 2013. "Masking of volatility by seasonal adjustment methods," Economic Modelling, Elsevier, vol. 33(C), pages 676-688.
    9. Pankaj Kumar, 2021. "Deep Hawkes Process for High-Frequency Market Making," Papers 2109.15110, arXiv.org.
    10. Bloom, David E. & Canning, David & Fink, Gunther & Finlay, Jocelyn E., 2007. "Does age structure forecast economic growth?," International Journal of Forecasting, Elsevier, vol. 23(4), pages 569-585.
    11. Mengyang Wang & Hui Wang & Jiao Wang & Hongwei Liu & Rui Lu & Tongqing Duan & Xiaowen Gong & Siyuan Feng & Yuanyuan Liu & Zhuang Cui & Changping Li & Jun Ma, 2019. "A novel model for malaria prediction based on ensemble algorithms," PLOS ONE, Public Library of Science, vol. 14(12), pages 1-15, December.
    12. Taleb, Nassim Nicholas, 2020. "On the statistical differences between binary forecasts and real-world payoffs," International Journal of Forecasting, Elsevier, vol. 36(4), pages 1228-1240.
    13. Marcelo Bourguignon, 2016. "Poisson–geometric INAR(1) process for modeling count time series with overdispersion," Statistica Neerlandica, Netherlands Society for Statistics and Operations Research, vol. 70(3), pages 176-192, August.
    14. Ling Tang & Chengyuan Zhang & Tingfei Li & Ling Li, 2021. "A novel BEMD-based method for forecasting tourist volume with search engine data," Tourism Economics, , vol. 27(5), pages 1015-1038, August.
    15. 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.
    16. Yelland, Phillip M., 2010. "Bayesian forecasting of parts demand," International Journal of Forecasting, Elsevier, vol. 26(2), pages 374-396, April.
    17. Oscar Claveria & Enric Monte & Salvador Torra, 2018. "A Data-Driven Approach to Construct Survey-Based Indicators by Means of Evolutionary Algorithms," Social Indicators Research: An International and Interdisciplinary Journal for Quality-of-Life Measurement, Springer, vol. 135(1), pages 1-14, January.
    18. Rounaghi, Mohammad Mahdi & Nassir Zadeh, Farzaneh, 2016. "Investigation of market efficiency and Financial Stability between S&P 500 and London Stock Exchange: Monthly and yearly Forecasting of Time Series Stock Returns using ARMA model," Physica A: Statistical Mechanics and its Applications, Elsevier, vol. 456(C), pages 10-21.
    19. Oscar Claveria & Enric Monte & Salvador Torra, 2017. "Let the data do the talking: Empirical modelling of survey-based expectations by means of genetic programming," IREA Working Papers 201711, University of Barcelona, Research Institute of Applied Economics, revised May 2017.
    20. 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.
    21. Michael Vössing & Niklas Kühl & Matteo Lind & Gerhard Satzger, 2022. "Designing Transparency for Effective Human-AI Collaboration," Information Systems Frontiers, Springer, vol. 24(3), pages 877-895, June.

    More about this item

    Keywords

    Forecasting; ARIMA; MAPE; Holt Winter; Decision-Making; Performance metrics;
    All these keywords.

    JEL classification:

    • C53 - Mathematical and Quantitative Methods - - Econometric Modeling - - - Forecasting and Prediction Models; Simulation Methods
    • L25 - Industrial Organization - - Firm Objectives, Organization, and Behavior - - - Firm Performance

    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:brc:brccej:v:7:y:2022:i:2:p:161-173. 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: Cristina GANESCU (email available below). General contact details of provider: http://www.univcb.ro/ .

    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.