Web-Based Boarding House Management Information System with Dashboard Analytics and Multiple Linear Regression for Rental Income Prediction
Article Sidebar
Main Article Content
Small boarding-house businesses commonly rely on receipts and annual notebooks to record tenants, rental periods, payments, unit availability, and income. Such practices can support daily operations, but they make historical retrieval, operational monitoring, and decision support increasingly difficult as the number of records grows. This study develops a web-based boarding house management information system that integrates operational data management, dashboard analytics, and rental-income prediction for Surapati Boarding House in Bandung, Indonesia. The application was developed with Laravel 12, PHP, and MySQL, while the predictive model was trained offline in Python using scikit-learn. Because the original tenant and payment records contain private information, a simulated historical dataset was constructed from the property’s operational characteristics. The dataset contains 54 monthly observations from January 2022 to June 2026. The independent variables were occupied Type A units, occupied Type B units, and payment arrears, while monthly rental income was the dependent variable. After cleaning currency-formatted values and removing invalid rows, the data were divided into 43 training observations and 11 testing observations. The resulting multiple linear regression model was integrated into the Laravel analytics page through its estimated intercept and coefficients. The system provides authentication, unit and tenant master data, rental transactions, payment records, operational summaries, due-date reminders, and an analytics interface that compares actual and predicted income. Model evaluation produced an R-squared value of 95.85%, a mean absolute error of IDR 250,715.83, a root mean squared error of IDR 303,605.01, and a mean absolute percentage error of 1.39%. These results indicate close agreement between predicted and simulated actual income. However, the findings are limited to the simulated case-study dataset and require validation using anonymized real operational data before broader deployment.
Downloads
References
Ahad, A., & Assegaff, S. (2022). Rancang bangun sistem informasi eksekutif dashboard monitoring produksi. 7(2), 300–314.
Arigie, M., Fadillah, R., & Wahyuni, S. N. (2024). Pengembangan sistem informasi pengelolaan kos berbasis website dengan menggunakan framework CodeIgniter pada Wisma Mutiara Selaras. 1(2), 37–45.
Basir, A., & Saifudin, A. (2022). Rancang bangun sistem informasi rumah kos berbasis web dengan metode terapan. Jurnal Teknologi Sistem Informasi, 5(2), 139–144. https://doi.org/10.32493/jtsi.v5i2.20691
Fadianty, R. (2024). Penerapan data mining dengan algoritma regresi linear berganda untuk memprediksi omset penjualan minyak goreng. Building of Informatics, Technology and Science, 6(2). https://doi.org/10.47065/bits.v6i2.5951
Hasti, N., & Zaelani, M. I. (2023). Sistem informasi pengelolaan Rumah Kost Budi Sari berbasis website. 2(2), 26–32.
Hjelle, S., Mikalef, P., Altwaijry, N., & Parida, V. (2024). Organizational decision making and analytics: An experimental study on dashboard visualizations. Information & Management, 61(6), 104011. https://doi.org/10.1016/j.im.2024.104011
James, G., Witten, D., Hastie, T., Tibshirani, R., & Taylor, J. (2023). An introduction to statistical learning, with applications in Python. Springer. https://doi.org/10.1007/978-3-031-38747-0
Laravel. (2025). Laravel documentation. https://laravel.com/docs
Maryani, M., et al. (2022). Comparison of the system development life cycle and prototype model for software engineering. International Journal of Emerging Technology and Advanced Engineering, 12(4), 155–162. https://doi.org/10.46338/ijetae0422
Nizar, C. (2021). Rancang bangun sistem informasi sewa rumah kost (E-Kost) berbasis website. 3(1), 1–10.
Nugraheny, D., Indrianingsih, Y., Kurniawan, S., & Sunaryo, H. (2023). Prediksi target pendapatan minimum CV Bunga Dasimoen Florist menggunakan metode regresi linier berganda berbasis web. Angkasa, 15(1), 89–98. https://doi.org/10.28989/angkasa.v15i1.1592
Scikit-learn developers. (2025). LinearRegression documentation. https://scikit-learn.org/stable/modules/generated/sklearn.linear_model.LinearRegression.html
Setiawan, R., Supriatna, A. D., & Kusuma, A. H. (2021). Rancang bangun sistem informasi pengelolaan Rumah Kos Deo Garut berbasis web. Jurnal Algoritma, 17(2), 368–377. https://doi.org/10.33364/algoritma/v.17-2.368
Susnjak, T., Ramaswami, G. S., & Mathrani, A. (2022). Learning analytics dashboard: A tool for providing actionable insights to learners. International Journal of Educational Technology in Higher Education. https://doi.org/10.1186/s41239-021-00313-7
This work is licensed under a Creative Commons Attribution 4.0 International License.
All articles published in our journal are licensed under CC-BY 4.0, which permits authors to retain copyright of their work. This license allows for unrestricted use, sharing, and reproduction of the articles, provided that proper credit is given to the original authors and the source.