Application of ARIMA Method in Predicting Volume of Clean Water Usage in Manado City

Christina Irwan; Djoni Hatidja; Jantje Denny Prang; Nelson Nainggolan

doi:10.35799/jis.v26i2.58295

Authors

Christina Irwan Department of Mathematics Sam Ratulangi University, Manado, Indonesia
Djoni Hatidja Department of Mathematics Sam Ratulangi University, Manado, Indonesia https://orcid.org/0000-0003-2137-1479
Jantje Denny Prang Department of Mathematics Sam Ratulangi University, Manado, Indonesia
Nelson Nainggolan Department of Mathematics Sam Ratulangi University, Manado, Indonesia https://orcid.org/0000-0002-1825-5576

DOI:

https://doi.org/10.35799/jis.v26i2.58295

Keywords:

Manado City, Wanua Wenang, water usage, prediction

Abstract

This study aims to determine an Autoregressive Integrated Moving Average (ARIMA) model and forecast the volume of clean water consumption in Manado City for the subsequent six months. The data used in this study were obtained from monthly clean water consumption statistics in Manado City, spanning from January 2016 to October 2023. A total of 94 data points were utilized: 86 were used for model development, while the final 8 were reserved for model testing and validation. The results indicate that ARIMA(2,2,1) is the optimal model for forecasting clean water consumption volume in Manado City. The ARIMA(2,2,1) model is expressed as: . The six-month forecast-covering November 2023 to April 2024 projects water consumption volumes ranging from 365,840 to 377,962 m³, with the peak occurring in December 2023. The predictions suggest a downward trend in water consumption volume of 2.65% between November 2023 and April 2024. These findings demonstrate that the ARIMA(2,2,1) model has the potential to serve as a tool for estimating clean water demand, thereby supporting the planning of water supply and distribution by water utility providers in Manado City.

References

Aprilianti, A. E., Ahsan, M., & Nugraha, D. A. (2019). Prediksi Harga Air Pelanggan Perusahaan Daerah Air Minum (PDAM) Menggunakan Metode ARIMA (Autoregressive Integrated Moving Average). Seminar Nasional FST 2019 Universitas Kanjuruhan Malang, 781–789.

Asfihani, M. A. (2017). Peramalan Volume Pemakaian Air di PDAM Kota Surabaya dengan Menggunakan Metode Time Series [Skripsi]. Institut Teknologi Sepuluh Nopember, Surabaya.

Cryer, J. D., & Chan, K. S. (2008). Time Series Analysis with Applications in R Second Edition. Wiley Online Library.

Ekayanti, R., Mara, M. N., & Sulistianingsih, E. (2014). Analisis Model Intervensi Fungsi Step untuk Peramalan Kenaikan Tarif Dasar Listrik (TDL) Terhadap Besarnya Pemakaian Listrik. Jurnal Bimaster: Buletin Ilmiah Matematika, Statistika Dan Terapannya, 3(3), 175–184.

Erdin. (2020). Peramalan Jumlah Penyediaan Air Bersih oleh Perusahaan Daerah Air Minum (PDAM) terhadap masyarakat di Kabupaten Gowa Tahun 2020 dengan Metode ARIMA [Skripsi]. Universitas Islam Negeri Alauddin Makassar, Makassar.

Hadiansyah, A. (2020). Peramalan Penjualan Cat Pada Pt. Hij Menggunakan Autoregressive Integrated Moving Average [Thesis]. Universitas Komputer Indonesia, Bandung.

Hyndman, R. J., & Koehler, A. B. (2006). Another look at measures of forecast accuracy. International Journal of Forecasting, 22(4), 679–688. https://doi.org/10.1016/j.ijforecast.2006.03.001

Jannah, M., & Fitri, I. N. (2019). Penaksiran Parameter Model Autoregressive Orde (1) Dengan Menggunakan Metode Likelihood Maksimum. MAP (Mathematics and Applications) Journal, 1(2), 38–48.

Kurnia, N. (2022). Penerapan Peramalan Penjualan Sembako Menggunakan Metode Single Moving Average (Studi Kasus Toko Kelontong Dedeh Retail). Jurnal Ilmiah Wahana Pendidikan, 8(17), 307–316.

Mokorimban, F. E., Langi, Y. A. R., & Nainggolan, N. (2021). Penerapan Metode Autoregressive Integrated Moving Average (ARIMA) dalam Model Intervensi Fungsi Step terhadap Indeks Harga Konsumen di Kota Manado. D’Cartesian: Jurnal Matematika Dan Aplikasi, 10(2), 91–99.

Nurhidayat, T. I., & Kurniawan, R. (2022). Forecasting Demand Menggunakan Model ARIMA Pada Pemakaian Air Bersih Produksi PDAM Kabupaten Kediri. Seminar Nasional Manajemen, Ekonomi Dan Akuntansi, 408–414.

Panjaitan, H., Prahutama, A., & Sudarno, S. (2018). Peramalan Jumlah Penumpang Kereta Api Menggunakan Metode Arima, Intervensi Dan Arfima (Studi Kasus: Penumpang Kereta Api Kelas Lokal Ekonomi DAOP IV Semarang). Jurnal Gaussian, 7(1), 96–109.

Razali, S. N. A. M., Rusiman, M. S., Zawawi, N. I., & Arbin, N. (2018). Forecasting of Water Consumptions Expenditure Using Holt-Winter’s and ARIMA. Journal of Physics: Conference Series, 995, 012041. https://doi.org/10.1088/1742-6596/995/1/012041

Rofik, M. Z. (2017). Peramalan Pemakaian Air Bersih di PDAM Sumber Pocong Kabupaten Bangkalan [Skripsi]. Institut Teknologi Sepuluh Nopember, Surabaya.

Ruslam. (2020). Peramalan Curah Hujan di Wilayah Sulawesi Barat Menggunakan Metode ARIMA Subset Musiman [Skripsi]. Universitas Sulawesi Barat, Majene.

Wei, W. W. S. (2006). Time Series Analysis Univariate and Multivariate Methods Second Edition. Pearson Education Inc.