ANALYSIS AND COMPARING FORECASTING RESULTS USING TIME SERIES METHOD TO PREDICT SALES DEMAND ON COVID-19 PANDEMIC ERA

Paduloh Paduloh, Abdul Ustari

Abstract


The Covid-19 pandemic has made uncertainty in demand very high; there have been many changes in demand due to changes in the market and people's buying methods. So that forecasting accuracy is significant for every industry, at least the forecast that is closest to the conditions faced by the company so that the company does not lose money due to forecasting errors. Time series is a widely used model for forecasting using past data. This study aims to minimize forecasting errors by analyzing which demand forecasting model is most suitable for demand conditions based on historical data on demand for masterbatch products. The method used in this study is a time series model, which consists of the season naive method, holt exponential smoothing, exponential triple smoothing, and autoregressive integrated moving average (ARIMA). Data processing is done using Rstudio software. The results show that the ARIMA method (2,1,0) (1,1,0) is the best because it has the smallest error rate value with case studies and exact data; the standard error size values used are ME, RMSE, MAE, MPE, MAPE, MASE, and ACF1. This study analyzes forecasting during the Covid-19 pandemic using time series and compares them to find the best results. Then the results of this study can be used as a reference by companies and researchers in determining the model used to make forecasts.


Keywords


Time Series, ARIMA, Masterbatch, Rstudio.

Full Text:

PDF

References


S. J. Taylor and B. Letham, “Business Time Series Forecasting at Scale,” PeerJ Prepr. 5e3190v2, vol. 35, no. 8, pp. 48–90, 2017, [Online]. Available: https://peerj.com/preprints/3190/%0Ahttp://ezproxy.bangor.ac.uk/login?url=http://search.ebscohost.com/login.aspx?direct=true&db=c8h&AN=108935824&site=ehost-live%0Ahttps://peerj.com/preprints/3190/%0Ahttps://peerj.com/preprints/3190.pdf.

C. Y. Chiang, W. T. Lin, and N. C. Suresh, “An empirically-simulated investigation of the impact of demand forecasting on the bullwhip effect: Evidence from U.S. auto industry,” Int. J. Prod. Econ., vol. 177, pp. 53–65, 2016, doi: 10.1016/j.ijpe.2016.04.015.

C. Chatfield, TIME-SERIES FORECASTING. Boca Raton London New York Washington, D.C.: CHAPMAN & HALL/CRC, 2000.

P. Paduloh and T. Djatna, “Proposed Reversed Supply Chain as Problem Solver for Case of Returned Beef Products During the Covid- 19 Pandemic,” vol. 203, pp. 169–173, 2021.

P. Paduloh, T. Djatna, M. Muslich, and S. Sukardi, “Impact Of Reverse Supply Chain On Bullwhip Effects In Beef Supply,” Ijscm, vol. 9, no. 5, pp. 184–194, 2020, [Online]. Available: http://excelingtech.co.uk/.

G. P. Zhang, “Neural networks for time-series forecasting,” Handb. Nat. Comput., vol. 1–4, pp. 461–477, 2012, doi: 10.1007/978-3-540-92910-9_14.

H. Tyralis and G. Papacharalampous, “Variable selection in time series forecasting using random forests,” Algorithms, vol. 10, no. 4, 2017, doi: 10.3390/a10040114.

B. M. Pavlyshenko, “Machine-learning models for sales time series forecasting,” Data, vol. 4, no. 1, pp. 1–11, 2019, doi: 10.3390/data4010015.

O. B. Sezer, M. U. Gudelek, and A. M. Ozbayoglu, “Financial time series forecasting with deep learning: A systematic literature review: 2005–2019,” Appl. Soft Comput. J., vol. 90, pp. 2005–2019, 2020, doi: 10.1016/j.asoc.2020.106181.

E. Fradinata, S. Suthummanon, W. Suntiamorntut, and M. M. Noor, “Compare the forecasting method of artificial neural network and support vector regression model to measure the bullwhip effect in supply chain,” J. Mech. Eng. Sci., vol. 13, no. 2, pp. 4816–4834, 2019.

C. Deb, F. Zhang, J. Yang, S. E. Lee, and K. W. Shah, “A review on time series forecasting techniques for building energy consumption,” Renew. Sustain. Energy Rev., vol. 74, no. February, pp. 902–924, 2017, doi: 10.1016/j.rser.2017.02.085.

D. M. Gligor, “The role of demand management in achieving supply chain agility,” Supply Chain Manag., vol. 19, pp. 577–591, 2014, doi: 10.1108/SCM-10-2013-0363.

J. G. De Gooijer and R. J. Hyndman, “25 Years of Time Series Forecasting,” Int. J. Forecast., vol. 22, no. 3, pp. 443–473, 2006, doi: 10.1016/j.ijforecast.2006.01.001.

F. Petropoulos, X. Wang, and S. M. Disney, “The inventory performance of forecasting methods: Evidence from the M3 competition data,” Int. J. Forecast., vol. 35, no. 1, pp. 251–265, 2019, doi: 10.1016/j.ijforecast.2018.01.004.

X. Li, B. Pan, R. Law, and X. Huang, “Forecasting tourism demand with composite search index,” Tour. Manag., vol. 59, no. August 2016, pp. 57–66, 2017, doi: 10.1016/j.tourman.2016.07.005.

T. H. H. Aldhyani, M. Alrasheedi, A. A. Alqarni, M. Y. Alzahrani, and A. M. Bamhdi, “Intelligent Hybrid Model to Enhance Time Series Models for Predicting Network Traffic,” IEEE Access, vol. 8, pp. 130431–130451, 2020, doi: 10.1109/ACCESS.2020.3009169.

S. Chopra and P. Meindl, Supply Chain Managment: Strategy, Planning, and Operation, 7th ed. Kepos: Pearson, 2016.

R. J. Hyndman and G. Athanasopoulos, Forecasting : Principles and Practice, 2nd ed. Monash University, Australia., 2018.

J. Fattah, L. Ezzine, Z. Aman, H. El Moussami, and A. Lachhab, “Forecasting of demand using ARIMA model,” Int. J. Eng. Bus. Manag., vol. 10, pp. 1–9, 2018, doi: 10.1177/1847979018808673.

J. Arreola Hernandez and M. A. M. Al Janabi, “Forecasting of dependence, market, and investment risks of a global index portfolio,” J. Forecast., vol. 39, no. 3, pp. 512–532, 2020, doi: 10.1002/for.2641.

H. Hasbullah and Y. Santoso, “Overstock Improvement by Combining Forecasting , EOQ , and ROP,” J. PASTI, vol. XIV, no. 3, pp. 230–242, 2020.

D. P. Sari, M. Mujiya Ulkhaq, D. I. Rinawati, and D. R. Rasyida, “Barriers of reverse logistics implementation: A case study in a car battery industry in Indonesia,” Int. J. Supply Chain Manag., vol. 7, no. 5, pp. 53–67, 2018.

S. K. Paul, “Supplier selection for managing supply risks in supply chain: a fuzzy approach,” Int. J. Adv. Manuf. Technol., vol. 79, no. 1–4, pp. 657–664, 2015, doi: 10.1007/s00170-015-6867-y.

K. Schredelseker and F. Hauser, Lecture Notes in Economics and Mathematical Systems: Preface, vol. 614. 2008.

V. Wineka Nirmala, D. Harjadi, and R. Awaluddin, “Sales Forecasting by Using Exponential Smoothing Method and Trend Method to Optimize Product Sales in PT. Zamrud Bumi Indonesia During the Covid-19 Pandemic,” Int. J. Eng. Sci. Inf. Technol., vol. 1, no. 4, pp. 59–64, 2021, doi: 10.52088/ijesty.v1i4.169.

F. Alasali, K. Nusair, L. Alhmoud, and E. Zarour, “Impact of the covid-19 pandemic on electricity demand and load forecasting,” Sustain., vol. 13, no. 3, pp. 1–22, 2021, doi: 10.3390/su13031435.

F. Ahmed, V. U. Amsterdam, F. Guneri, and D. Akbiyik, “A comparative and forecasting study of workplace visits during pandemic in 2020,” no. July, 2021.

P. K. Dr et al., “Forecasting the dynamics of COVID-19 pandemic in Top 15 countries in April 2020: ARIMA model with machine learning approach,” medRxiv, no. April, 2020, doi: 10.1101/2020.03.30.20046227.




DOI: https://doi.org/10.21776/10.21776/ub.jemis.2022.010.01.4

Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.