UNP Journal of Statistics and Data Science
Vol. 4 No. 2 (2026): UNP Journal of Statistics and Data Science

A Predicting the Future: A Forecast of Bukittinggi's Original Local Revenue from 1996 to 2024

Fedisha Elfiri Fedisha (Unknown)
Fadhilah Fitri (Universitas Negeri Padang)
Zilrahmi (Universitas Negeri Padang)



Article Info

Publish Date
31 May 2026

Abstract

In the past decade, Bukittinggi City’s locally generated revenue (PAD) has experienced considerable instability. A significant decline occurred during the 2020 pandemic, followed by external disruptions such as the 2024 Mount Marapi eruption. These conditions complicate regional financial planning and highlight the importance of reliable forecasting. This study aims to forecast PAD for the 2025–2029 period using the ARIMA (Autoregressive Integrated Moving Average) method. Annual data from 1996–2024 were obtained from official publications of Indonesia’s Central Bureau of Statistics (BPS) Bukittinggi. The analysis procedure included exploratory data analysis, variance stationarity testing using Box-Cox transformation, mean stationarity testing through the Augmented Dickey-Fuller test supported by ACF and PACF plots, tentative model identification, parameter estimation, residual diagnostics using the Ljung-Box and Shapiro-Wilk tests, and model selection based on the smallest MAPE value. The results showed that the data became stationary after Box-Cox transformation and second-order differencing. Among the candidate models, ARIMA(3,2,0) was selected as the best model because all parameters were statistically significant (p-value < 0.05), the residuals satisfied the white noise assumption, and the model produced the lowest MAPE value. Forecasting results indicate an increasing PAD trend from approximately 240.23 million Rupiah in 2025 to 429.57 million Rupiah in 2029. However, prediction intervals widened over time, indicating increasing uncertainty in long-term forecasts. Therefore, the local government should implement adaptive fiscal policies and strengthen regional revenue sources to anticipate future PAD fluctuations

Copyrights © 2026






Journal Info

Abbrev

ujsds

Publisher

Subject

Computer Science & IT Decision Sciences, Operations Research & Management Mathematics Social Sciences

Description

UNP Journal of Statistics and Data Science is an open access journal (e-journal) launched in 2022 by Department of Statistics, Faculty of Science and Mathematics, Universitas Negeri Padang. UJSDS publishes scientific articles on various aspects related to Statistics, Data Science, and its ...