Forecasting the Average Monthly Retail Price of Diesel in Bangkok
Main Article Content
Abstract
This research aims to forecast diesel prices using the average monthly retail diesel prices in Bangkok obtained from the Bank of Thailand website from January 2003 to October 2022, totaling 238 months. The researcher divided the time series into two sets. The first set comprised 235 months from January 2003 to July 2022. It was used to create a forecasting model using four statistical methods, namely, the Box-Jenkins method, Holt’s exponential smoothing method, Brown’s exponential smoothing method, and the damped trend exponential smoothing method. The second set comprised the last 3 months, from August to October 2022. It was used to compare the accuracy of the forecast models based on the lowest mean absolute percentage error (MAPE) and root mean square error (RMSE). The study found that the forecasting model using Holt’s exponential smoothing method was the most accurate, with MAPE = 0.3053 and RMSE = 0.1158. The model was as follows:
where = 1 represented August 2022.
Article Details
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
The content and information in the article published in Journal of Rajamangala University of Technology Srivijaya It is the opinion and responsibility of the author of the article. The editorial journals do not need to agree. Or share any responsibility.
References
Bank of Thailand. 2022. Prices of major industrial commodities. Available Source: https:// www.bot.or.th/App/BTWS_STAT/statistics/ReportPage.aspx?reportID=90&language=th, December 8, 2022. (in Thai)
Bowerman, B.L. and O’Connell, R.T. 2000. Forecasting and Time Series: An Applied Approach. 3rd ed. Duxbury Press, California.
Box, G.E.P., Jenkins, G.M., Reinsel, G.C. and Ljung, G.M. 2015. Time Series Analysis: Forecasting and Control. 5th ed. Prentice Hall, New Jersey.
iEnergyGuru. 2022. Diesel fuel. Available Source: https://ienergyguru.com/knowledgebase/diesel-fuel/, December 14, 2022. (in Thai)
Investing.com. 2021. 6 factors causing crude oil prices to fluctuate throughout 2021. Available Source: https://th.investing. com/analysis/article-200438822, December 9, 2022. (in Thai)
Jumlong, M. and Naknok, S. 2018. A study of factors affecting and forecasting the price of diesel oil in Thailand, pp. 818-828. In Graduate School Mini-Conference 2018. Suan Sunandha Rajabhat University, Bangkok. (in Thai)
Keerativibool, W. 2013a. Forecasting model for the retail prices of gasohol 91 in Bangkok and peripheral areas. Thaksin University Journal 16(3 special issue): 1-10. (in Thai)
Keerativibool, W. 2013b. Forecasting model for the retail prices of gasohol 95 in Bangkok and peripheral areas. KMUTT Research and Development Journal 36(4): 423-438. (in Thai)
Ket-iam, S. 2003. Forecasting Technique. 2nd ed. Thaksin University, Songkhla. (in Thai)
Manmin, M. 2006. Time Series and Forecasting. Foreprinting, Bangkok. (in Thai)
RYT9. 2022. In 2022 Why is the world oil price dropping? Thailand's not decreasing? Available Source: https://www.ryt9. com/s/prg/3307823, December 9, 2022. (in Thai)
Tangsai, S., Kumwong, P. and Dansawad, N. 2019. A comparison of the forecasting method for the monthly consumption of diesel in Thailand, pp. 392-400. In the 7th Academic Science and Technology Conference 2019. Rangsit University, Pathum Thani. (in Thai)