ENHANCING SERVICE EFFICIENCY THROUGH AN EXCEL MACRO- BASED INFORMATION SYSTEM: EVIDENCE FROM SANKEN SAMARINDA SERVICE CENTER
Main Article Content
Tandi Kadang
Tiara
Andi Nurhasanah
Angga Kusumah
Feti Fahmimroah
This study aims to develop an information system using Microsoft Excel Macros to improve service efficiency at the Sanken Samarinda Service Center. The background of this research lies in the operational condition that still relies heavily on manual record-keeping, resulting in data entry delays, calculation errors, and slow report generation. The development of this information system is expected to accelerate the administrative processes of sales and services while increasing data accuracy. The research applied a mixed-methods approach, employing observation, interviews, documentation, and literature review for data collection. The incremental model was used for system development, allowing design and testing to be carried out progressively. The findings indicate that implementing a Macro Excel-based system reduces data entry time by up to 50%, improves operational efficiency, and enables automatic and accurate report generation. In terms of effectiveness, the system successfully optimizes resource utilization and minimizes human error. These findings reinforce the theory of information technology efficiency, showing that simple software tools like Microsoft Excel can serve as economical and effective alternatives to support business process digitalization.
Azhar, Z., Hutahaean, J., Siagian, Y., & Syah, A. Z. (2019). Pelatihan Microsoft Excel 2010 Pada Siswa Lembaga Kursus Pendidikan (LKP) Mandiri. Jurnal Anadara Pengabdian Kepada Masyarakat, 1(2), 2657–0351.
Creswell, J. W., & Creswell, J. D. (2017). Research Design: Qualitative, Quantitative, and Mixed Methods Approaches. SAGE Publications. https://books.google.co.id/books?id=335ZDwAAQBAJ
Dinul Haq, M., & Dian, Y. (2024). Perancangan Aplikasi Pencatatan Penjualan Berbasis Web Dengan Fitur Analisis Penjualan Pada Toko Fadhil Elektronik. JEKIN - Jurnal Teknik Informatika, 4(2), 355–365. https://doi.org/10.58794/jekin.v4i2.771
Dua, I. L., & Rumerung, J. J. (2022). Kajian Efisiensi dan Efektivitas Kerja Karyawan Bidang Administrasi pada PT. Manado Media Grafika. 4(1).
Herlina, Rusman, A. D. P., & Suwardoyo, U. (2022). Penerapan Sistem Informasi Berbasis IT Pengolahan Data Rekam Medis untuk Peningkatan Pelayanan di Rumah Sakit. Penerbit NEM. https://books.google.co.id/books?id=8XCAEAAAQBAJ
Irviani, E. Y., & Anggraeni, E. Y. (2017). Pengantar Sistem Informasi. Yogyakarta: CV. Andi Offset.
Irwansyah, E., & Moniaga, J. V. (2014). Pengantar Teknologi Informasi. deePublish.
Lee, C. (2016). Belajar Excel Macro VBA Step-by-Step. Jakarta: Elex Media Komputindo.
Muhayminah, D. (2022). Sistem Informasi Service Dan Penjualan Sparepart Mobil Pada Astra Auto2000 Samarinda Dengan Menggunakan Macro Microsoft Excel. Politeknik Negeri Samarinda.
Musa, I., Patabang, L., & Rindi, R. M. (2021). Penerapan Sistem Informasi Pasien Pada Puskesmas Harapan Baru Samarinda Dengan Menggunakan Macro Microsoft Excel.
Primawanti, E. P., & Ali, H. (2022). Pengaruh Teknologi Informasi, Sistem Informasi Berbasis Web dan Knowledge Management terhadap Kinerja Karyawan (Literature Review Executive Support Sistem (ess) for Business). Jurnal Ekonomi Manajemen Sistem Informasi, 3(3), 267–285. https://doi.org/10.31933/jemsi.v3i3.818
Rini, A., & Azdy, R. A. (2016). Implementasi Incremental Model Pada Sistem Informasi Penyewaan Barang dan Jasa PT. Sriwijaya Indah Persada Palembang Implementation Of Incremental Model On Good Rental And Services Information System Pt. Sriwijaya Indah Persada Palembang. Teknomatika, 06(02).
Siregar, L. Y., & Nasution, M. I. P. (2020). Perkembangan Teknologi Informasi terhadap Peningkatan Bisnis Online. Hirarki : Jurnal Ilmiah Manajemen dan Bisnis, 2(1), 71–75. https://doi.org/10.30606/hjimb
Sugiyono, P. D. (2019). Metode Penelitian Kuantitatif Kualitatif dan R&D. ALFABETA, CV.
