Implementation and Training of a VBA for Service Information System using Waterfall Model: A Case Study of Laundry Hasanah

Zulfahmi Noor; Lintang Puja Prameswarie; Siti Irma Fadilla; Sheila Carol Dorothy Kemur; Arif Mustakim; Nur Ainun Musvirah; Nurmasitya Kemalaintan; Fauziah Fauziah

doi:10.55681/swarna.v5i5.2335

Authors

Zulfahmi Noor Politeknik Sinar Mas Berau Coal
Lintang Puja Prameswarie Politeknik Sinar Mas Berau Coal
Siti Irma Fadilla Politeknik Sinar Mas Berau Coal
Sheila Carol Dorothy Kemur Politeknik Sinar Mas Berau Coal
Arif Mustakim Politeknik Sinar Mas Berau Coal
Nur Ainun Musvirah Politeknik Sinar Mas Berau Coal
Nurmasitya Kemalaintan Politeknik Sinar Mas Berau Coal
Fauziah Fauziah Universitas Negeri Makassar

DOI:

https://doi.org/10.55681/swarna.v5i5.2335

Keywords:

Implementation System, Service Operation, Dashboard, VBA, Waterfall

Abstract

The advancement of information technology has driven the digitalization of the MSME sector; however, most businesses still rely on manual systems that are inefficient and prone to errors. This issue is also encountered by Laundry Hasanah MSME in Berau Regency in managing its service operations. Therefore, this study aims to develop and implement a service information system based on Visual Basic for Applications (VBA) to improve data processing efficiency and enhance service quality, which is expected to have a significant impact on the business sustainability of Laundry Hasanah. The development and design method employed in this study and community service activity is the Waterfall model, consisting of the stages of analysis, design, implementation, and testing. The implementation results indicate that the system is capable of accelerating the recording process, reducing errors, and improving service quality in a more effective and accurate manner. Based on the design and implementation of the VBA based laundry service information system, it can be concluded that the application was systematically designed and developed in accordance with the Waterfall model. Each stage, from requirements analysis to maintenance, was carried out sequentially and consistently, ensuring that the development process was structured, controlled, and capable of minimizing potential errors.

Downloads

Download data is not yet available.

References

Abdurahman, M., & Thohir, M. I. (2026). Perancangan Website Pelayanan Menggunakan Metode Waterfall Di Puskemas Kabupaten Sukabumi. Jurnal Pengabdian Masyarakat Bhinneka, 4(3), 4036–4043. https://doi.org/10.58266/jpmb.v4i3.1081

Aditiya, M. V., Prakasa, G. E., Kristiyanto, Y., Sarah, S., Muzaeni, A., & Susanto, Y. (2026). Development of a web-based waste bank information system using the waterfall method. International Journal of Informatics, Economics, Management and Science, 5(1), 55. https://doi.org/10.52362/ijiems.v5i1.2261

Alanuari, A. H., & Harits, A. (2026). Perancangan Sistem Informasi Jasa Dan Pelayanan Kalibrasi Berbasis Website Menggunakan Metode Agile (Studi Kasus : Pusat Sarana Pengendalian. Journal.Jci.Co.Id/Jisbt, 2(1), Page. https://journal.jci.co.id/jisbt

Annisa Ilmi Suqni, S., Ummul Khair, A., & Manajemen, P. (2026). Malomo: Jurnal Manajemen dan Akuntansi Pengaruh Kualitas Pelayanan Dan Harga Terhadap Kepuasan Konsumen Usaha Mahya Laundry Di Btn Graha Kalegowa (Vol. 4, Number 1).

Ariq Firdaus, M., & Suharso, W. (2026). Web-Based Retail Information System for Managing Goods and Sales Using Waterfall Method. 15(1), 139–0150. https://doi.org/10.32832/astonjadro.v15i1.20044

Armanto, E. D., Karman, J., & Rizki, F. (2026). Perancangan Website E-Commerce Untuk Mendukung Digitalisasi Usaha Mikro Kecil dan Menengah Menggunakan Metode Waterfall. Journal of Informatics Management and Information Technology, 6(1), 66–74. https://doi.org/10.47065/jimat.v6i1.906

Cahyani, H., & Anisa, D. (2026). Perancangan Antarmuka Sistem Informasi Sensus Harian Rawat Inap Menggunakan Metode Waterfall. 3(1), 17–30. Https://Ojsiibn1.Indobarunasional.Ac.Id/Index.Php/Jutekdisijutekdisijurnalteknologidigitaldansisteminformasihttps://Ojsiibn1.Indobarunasional.Ac.Id/Index.Php/Jutekdisi

Diasti, A. K., Amalia, R., & Nengsih, R. (2026). Penerapan Metode Analytics Hierarchy Process (Ahp) Dalam Peminatan Customer Untuk Jenis Paket Laundry Kukusan Di Beji Depok. In Seminar Nasional Riset Dan Inovasi Teknologi (Semnas Ristek).

Fachri, B., & Rizal, C. (2024). Penerapan Metode Waterfall Dalam Perancangan Sistem Informasi Merdeka Belajar Kampus Merdeka Berbasis Web (Vol. 2). Online. https://kampusmerdeka.kemdikbud.go.id/,

Ginting, A., Prasista Bangun, E., Br Purba Universitas Mandiri Bina Prestasi Sri Wahyuni, K., Nurmalasari Pasaribu, E., & Bangun, O. (2026). Studi Analisis Model Waterfall Pada Pengembangan Sistem Informasi. 5, 2026. https://ejournal.nlc-education.or.id/index.php/JNSI/issue/view/34

Herasmus, H., & Suryadi, A. (2026). Manajemen Proyek Pengembangan Sistem Informasi Layanan Pelanggan Berbasis Website pada PT. XYZ Divisi Pelanggan. https://doi.org/10.55382/jurnalpustakadata.v6i1.1726

Iswandi, & M I A Siregar. (2026). Perancangan Sistem Maintenance Sarana Dan Prasarana Berbasis Web Pada Smak Padang.

Leo, T., KN, ⁠Sang Ayu Putu Novi Krisna Dewi, SKP, R. S. A., Namira, ⁠Raida, Handayani, ⁠Sarry, Suhartiningsih, ⁠Sukmawati Eka, & Rohendi, A. (2026). Service Marketing Mix (7Ps) sebagai Alat Strategis dalam Mengelola Pelayanan Prima: Systematic Literature Review. RIGGS: Journal of Artificial Intelligence and Digital Business, 5(1), 5622–5628. https://doi.org/10.31004/riggs.v5i1.6638

Mahardika, F., Zulfan, A., & Suseno, A. T. (2023). Implementasi Metode Waterfall pada Sistem Informasi Kepegawaian Berbasis Web. Blend Sains Jurnal Teknik, 2(2), 135–143. https://doi.org/10.56211/blendsains.v2i2.300

Natarajan, T., & Pichai, S. (2024). Transition from Waterfall to Agile Methodology: An Action Research Study. IEEE Access, 12, 49341–49362. https://doi.org/10.1109/ACCESS.2024.3384097

Patasya, A., & Meutia, S. (2026). Pengaruh Kualitas Pelayanan Terhadap Kepuasan Pelanggan Pada Usaha Xy Laundry. 12(02).

Prayitno, G., & Bryan Imbiri, I. (2026). Optimalisasi Pengelolaan Arsip Digital: Implementasi Sistem Berbasis Web dengan Metode Waterfall di DPPKP Provinsi Papua Tengah. Jurnal Teknologi Dan Informatika, 3, 71–85. https://doi.org/10.70539/jti.v3i2.93

Rahman, W., Pramuntadi, A., Hardan Gutama, D., & Danianti, D. (2026). Perancangan Aplikasi Berbasis Website Untuk Jasa Pelayanan Cuci Baju (Laundry) (Studi Kasus: Milano Laundry). In Jurnal Mahasiswa Teknik Informatika (Vol. 10, Number 1).

Ramadhan, A. R., Pratama, N. D., Ada, Y., Fladea, S. A., Putri, T. R., & Wijaya, S. A. (2026). Perancangan Sistem Informasi Jual Beli Mobil Second Menggunakan Metode Waterfall Di PT. Oto Multiartha. RIGGS: Journal of Artificial Intelligence and Digital Business, 4(4), 12579–12589. https://doi.org/10.31004/riggs.v4i4.5741

Ridwan, M., & Fitri, I. (2021). Rancang Bangun Marketplace Berbasis Website menggunakan Metodologi Systems Development Life Cycle (SDLC) dengan Model Waterfall. Jurnal Teknologi Informasi Dan Komunikasi), 5(2), 2021. https://doi.org/10.35870/jti

Rishad, I., & Bakhtiar, A. (2026). Penerimaan Order Dengan Menggunakan Visual Basic For Applications (Vba) Pada Cv. Chandradimuka Makmur Perkasa.

Soewandi, K. A., Wirapraja, A., & Soedargo, D. S. O. (2026). Development of a Web-Based Laundry Information System with Customer Self-Service Using the Rapid Application Development Method. G-Tech: Jurnal Teknologi Terapan, 10(1), 11–21. https://doi.org/10.70609/g-tech.v10i1.8334

Thummadi, B. V., & Lyytinen, K. (2020). How much method-in-use matters? A case study of agile and waterfall software projects and their design routine variation. Journal of the Association for Information Systems, 21(4), 864–900. https://doi.org/10.17705/1jais.00623

Umagapi, D., & Ambarita, A. (2026). Pengembangan Aplikasi Pencatatan Arus Kas Dana Desa Berbasis Desktop Menggunakan Metode Prototyping Di Desa Pintatu Kabupaten Halmahera Timur.

Valerian, A., Bernady, D., Wahyudi, F., Dinatha, J. P., & Barletyano, D. (2025). Implementasi Unit Testing, Integration Testing, System Testing, Dan Validation Testing Pada Aplikasi Berbasis Website (Studi Kasus: Kafe Saturdays). In Jurnal Mahasiswa Teknik Informatika) (Vol. 9, Number 4).

Wahyu Simbolon, R., & Maria Putri Komul, T. (2026). Rancang Bangun Sistem Informasi Penjualan Obat Berbasis Website Pada Apotek Filia. https://doi.org/10.37817/ikraith-informatika.v9i3

Z Noor, Jumatiah, Haura Nurhaliza, & Aqila Khoirul Umam. (2026). Smart Waste Bin Design with Automatic Waste Sorting System, Ergonomic, Functional, Aesthetic, and IoT-Based Integrated Point System. https://doi.org/.

Z Noor, & Safitriani, D. (2026). Implementasi Filter Air Sederhana untuk Pemenuhan Air Bersih di Kampung Birang Implementation of a Simple Water Filter to Fulfill Clean Water Needs in Kampung Birang (Vol. 10, Number 1). http://journal.unhas.ac.id/index.php/panritaabdi