Maejo Information Technology and Innovation Journal (MITIJ)
 Search | First Page   
 
 
 
» Home
» Current Issue
» Archives
» Journal Search/Article
» Register (OJS/PKP)
 

                               :: Article details ::
Return to search menu 
Article name
Forecasting Feed Corn Prices in Thailand Using Time Series Models and a Business Intelligence Dashboard
Article type
Research article
Authors Prapaporn Chubsuwan(1*), Kasidis Srikongplee(1) and Supapong Pinveha(2)
Office Department of Business Computer, Mahasarakham Business School, Mahasarakham University(1), Department of Management, Mahasarakham Business School, Mahasarakham University(2) *Corresponding author: prapaporn.c@acc.msu.ac.th
Journal name Vol. 12 No.2 (2026): May - August
Abstract

        Agricultural price forecasting plays an important role in production planning, cost management, and decision-making in the agricultural sector. However, many previous studies have primarily focused on forecasting techniques without integrating Business Intelligence systems for data analysis and decision support. This study aimed to 1) analyze trends in animal feed corn prices in Thailand using historical data, 2) develop and compare the performance of time series forecasting models, and 3) develop a Business Intelligence dashboard to support data analysis and decision-making. The study used monthly animal feed corn price data from 2021 to 2025, comprising 60 monthly observations. The dataset was divided chronologically into training and testing sets at a ratio of 80:20. The forecasting models included Simple Linear Regression, Moving Average, Exponential Smoothing, and Holt–Winters Exponential Smoothing. The results showed that the Exponential Smoothing model (α = 0.95) achieved the highest forecasting accuracy with a MAPE of 2.473%, followed by Moving Average (3.249%) and Holt–Winters (3.875%), while Simple Linear Regression produced the highest forecasting error. In addition, an interactive dashboard was developed using Looker Studio to visualize actual price data and forecasting results. The findings indicate that integrating accurate forecasting models with Business Intelligence systems can effectively support agricultural data analysis and decision-making.

Keywords price forecasting; feed corn; time series analysis; moving average; business intelligence
Page number 383-400
ISSN ISSN 3027-7280 (Online)
DOI
ORCID_ID 0009-0001-7210-3645
Article file https://mitij.mju.ac.th/ARTICLE/R69071.pdf
  
Reference 
  Hyndman, R. J., & Athanasopoulos, G. (2021). Forecasting: Principles and Practice (3 ed.). OTexts. https://otexts.com/fpp3/
  Khan, M. A., Saqib, S., Alyas, T., Rehman, A. U., Saeed, Y., Zeb, A., Zareei, M., & Mohamed, E. M. (2020). Effective Demand Forecasting Model Using Business Intelligence Empowered With Machine Learning. IEEE Access, 8, 116013-116023. https://doi.org/10.1109/ACCESS.2020.3003790
  Khan, W., Ghazanfar, M. A., Azam, M. A., Karami, A., Alyoubi, K. H., & Alfakeeh, A. S. (2020). Stock market prediction using machine learning classifiers and social media, news. Journal of Ambient Intelligence and Humanized Computing, 13(7), 3433-3456. https://doi.org/10.1007/s12652-020-01839-w
  Montgomery, D. C., Peck, E. A., & Vining, G. G. (2021). Introduction to Linear Regression Analysis (6th ed.). John Wiley & Sons.
  Rathod, S., Chitikela, G., Bandumula, N., Ondrasek, G., Ravichandran, S., & Sundaram, R. M. (2022). Modeling and Forecasting of Rice Prices in India during the COVID-19 Lockdown Using Machine Learning Approaches. Agronomy, 12(9), 2133.
  Sharda, R., Delen, D., & Turban, E. (2018). Business Intelligence, Analytics, and Data Science: A Managerial Perspective. Pearson.
  Sridevy, S., Nirmala Devi, M., & Sankar, M. (2023). Decision Support Systems in Agricultural Industry Perspective. International Journal of Statistics and Applied Mathematics, 8(2S), 29-31. https://doi.org/10.22271/maths.2023.v8.i2Sa.984
  Wang, C., & Sun, Z. (2021). Monthly pork price forecasting method based on Census X12-GM(1,1) combination model. PLOS ONE, 16(5), e0251436. https://doi.org/10.1371/journal.pone.0251436
  Wang, F., & Aviles, J. (2023). Enhancing Operational Efficiency: Integrating Machine Learning Predictive Capabilities in Business Intelligence for Informed Decision-Making.
  Zamani, A., Haghbin, H., Hashemi, M., & Hyndman, R. (2019). Seasonal Functional Autoregressive Models. https://EconPapers.repec.org/RePEc:msh:ebswps:2019-16
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Return to search menu
       
Editorial Board of Maejo Information Technology and Innovation Journal MAEJO UNIVERSITY
No. 63 Moo 4, Nong Han Subdistrict, San Sai District, Chiang Mai Province 50290  mitij@mju.ac.th