Forecasting the Average Monthly Retail Price of Diesel in Bangkok

Main Article Content

Warangkhana Riansut

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:


equation


where equation = 1 represented August 2022.

Article Details

How to Cite
Riansut, W. (2024). Forecasting the Average Monthly Retail Price of Diesel in Bangkok. Rajamangala University of Technology Srivijaya Research Journal, 16(3), 842–853. Retrieved from https://li01.tci-thaijo.org/index.php/rmutsvrj/article/view/257209
Section
Research Article

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)