INTI Nusa Mandiri
Vol. 20 No. 1 (2025): INTI Periode Agustus 2025

RANCANG BANGUN APLIKASI PREDIKSI TAGIHAN AIR BERBASIS WEB MENGGUNAKAN REGRESI LINIER BERGANDA

Arum , Arum Fatmawati (Unknown)
Pajri, Afril Efan (Unknown)
Sahri (Unknown)



Article Info

Publish Date
21 Aug 2025

Abstract

The management of water billing in the PAMSIMAS service in Sidobandung Village is still conducted manually and does not provide early information regarding bill estimates, often resulting in delayed payments by customers. This study aims to design and develop a web-based water bill prediction application using the Multiple Linear Regression (MLR) method, capable of delivering fast, accurate, and accessible billing estimates. The dataset used in this research consists of historical monthly water usage and billing data from January to December 2024, with a structure comprising 231 rows of customer data and 30 feature columns. The research stages include data preprocessing, model training using MLR, integration of the model into a web-based system, and evaluation of prediction results using the Mean Squared Error (MSE) and R-squared ( ) metrics. Evaluation results showed that the model achieved an MSE of 18,882 and an  of 0,8, indicating a fairly good and stable prediction performance. The system allows customers to log in, view predicted water bills for the 13th month based on previous data, and access graphical visualizations of usage and cost trends. Meanwhile, the admin can efficiently manage customer data through a dedicated dashboard. With the implementation of this application, the management and prediction process of water billing becomes more transparent, efficient, and helps customers in planning their water expenses more precisely .

Copyrights © 2025






Journal Info

Abbrev

inti

Publisher

Subject

Computer Science & IT

Description

The INTI Nusa Mandiri Journal is intended as a media for scientific studies on the results of research, thought and analysis-critical studies on the issues of Computer Science, Information Systems and Information Technology, both nationally and internationally. The scientific article in question is ...