AUDIT SISTEM INFORMASI  TERHADAP PERHITUNGAN WEIGHTED PRODUCT (WP) DI EXCEL

J. Prayoga; Muhammad Gifary; Aldi Wiranata; Maulana Maulana; Naufal Nafriwan; Rizqa Azahra Nst; Reva Nurul Kalista

doi:10.46576/syntax.v6i2.8065

AUDIT SISTEM INFORMASI TERHADAP PERHITUNGAN WEIGHTED PRODUCT (WP) DI EXCEL

J. Prayoga, Muhammad Gifary, Aldi Wiranata, Maulana Maulana, Naufal Nafriwan, Rizqa Azahra Nst, Reva Nurul Kalista

Abstract

Penggunaan Microsoft Excel sebagai alat bantu perhitungan dalam Sistem Pendukung Keputusan (SPK) dengan metode Weighted Product (WP) semakin umum digunakan. Namun, perhitungan manual di Excel rentan terhadap kesalahan input, ketidaktepatan formula, dan inkonsistensi normalisasi bobot yang dapat menyebabkan hasil perankingan tidak valid. Penelitian ini bertujuan untuk melakukan audit sistem informasi terhadap file Excel yang digunakan dalam perhitungan metode WP guna memastikan integritas, akurasi, dan reliabilitas hasil.Audit dilakukan pada tiga komponen utama, yaitu input data, proses perhitungan (normalisasi bobot serta perhitungan nilai S dan V), dan output perankingan. Proses audit meliputi verifikasi kesesuaian rumus WP dengan teori, pengecekan konsistensi formula Excel, serta analisis kebenaran hasil perhitungan menggunakan data smartphone Xiaomi sebagai studi kasus.Hasil audit menunjukkan bahwa Excel dapat digunakan sebagai alat SPK sederhana apabila formula diterapkan secara benar dan konsisten sesuai aturan WP. Beberapa area kritis yang perlu diperhatikan meliputi penggunaan referensi absolut dan konsistensi formula antar baris. Penelitian ini menunjukkan bahwa audit sistem informasi berperan penting dalam menjaga integritas, akurasi, dan reliabilitas perhitungan WP di Excel serta memberikan rekomendasi untuk meminimalkan risiko kesalahan perhitungan.

Kata Kunci: Audit Sistem Informasi, Weighted Product, Microsoft Excel, Verifikasi Formula, Sistem Pendukung Keputusan.

ABSTRACT

The use of Microsoft Excel as a computational support tool in Decision Support Systems (DSS) applying the Weighted Product (WP) method has become increasingly common. However, manual calculations in Excel are prone to input errors, formula inaccuracies, and inconsistencies in weight normalization that may lead to invalid ranking results. This study aims to conduct an information system audit of an Excel file used to calculate the WP method to ensure the integrity, accuracy, and reliability of the calculations. The audit focuses on three main components: data input, calculation processes (weight normalization and S and V calculations), and ranking output. The audit includes verification of WP formulas against theoretical principles, consistency checks of Excel formulas, and validation of calculation results using Xiaomi smartphone data as a case study. The results show that Excel can function as a simple DSS tool if formulas are correctly and consistently applied according to WP rules. Critical issues identified include the use of absolute cell references and consistency of formulas across rows. This study demonstrates the role of information system audits in ensuring reliable WP calculations in Excel and provides recommendations to minimize calculation errors.

Keywords: Information System Audit, Weighted Product, Microsoft Excel, Formula Verification, Decision Support System.

Full Text:

PDF (Bahasa Indonesia)

References

T. A. Berno Doduk, H. Supriyanto, M. Al Hafidz, M. S. Prasetya, and M. A. Karyawan, “Analysis the Application of the Weighted Product Method in Decision Support Systems for Assistance Programmes for MSMEs,” J. Sisfokom (Sistem Inf. dan Komputer), vol. 13, no. 1, pp. 1–6, 2024, doi: 10.32736/sisfokom.v13i1.1777.

Lusiana Wulansari, Asri, and Nur Azizah Muchtar, “Decision Support System for Specialization Selection Based on Student Interests and Abilities Using the Weighted Product Method,” Ceddi J. Educ., vol. 2, no. 2, pp. 24–35, 2023, doi: 10.56134/cje.v2i2.53.

R. Nuraini, D. Alamsyah, R. S. Septarini, and A. A. J. Sinlae, “Completion of Multi-Criteria Decision Making Using the Weighted Product Method on the Server Maintenance Vendor Selection System,” J. Tek. Inform. C.I.T Medicom, vol. 14, no. 1, pp. 27–35, 2022, doi: 10.35335/cit.vol14.2022.247.pp27-35.

V. Sharma et al., “Multi-Criteria Decision Making Methods for Selection of Lightweight Material for Railway Vehicles,” Materials (Basel)., vol. 16, no. 1, pp. 1–23, 2023, doi: 10.3390/ma16010368.

Z. Wang, S. R. Nabavi, and G. P. Rangaiah, “Multi-Criteria Decision Making in Chemical and Process Engineering: Methods, Progress, and Potential,” Processes, vol. 12, no. 11, 2024, doi: 10.3390/pr12112532.

I. Ramadhan and U. Zaky, “Method Comparison Analysis Simple Additive Weighting (Saw) With Weighted Product (Wp) Method in Supporting the Decision To Accept New Employees,” Int. J. Eng. Technol. Nat. Sci., vol. 2, no. 1, pp. 11–17, 2020, doi: 10.46923/ijets.v2i1.66.

Y. Fitriansyah and M. Mardiani, “Sistem Pendukung Keputusan Pemilihan Karyawan Terbaik Pada PT. Garam Menggunakan Metode Weighted Product,” MDP Student Conf., vol. 4, no. 1, pp. 76–83, 2025, doi: 10.35957/mdp-sc.v4i1.11135.

I. R. Mukhlis et al., “Penerapan Metode Weighted Product dalam Sistem Pendukung Keputusan Program Penerimaan Bantuan Beras,” J. Ilmu Komput. dan Desain Komun. Vis., vol. 9, no. 2, pp. 476–490, 2024.

A. Rama and B. Priambodo, “Implementasi Metode Weighted Product (WP) pada Sistem Pendukung Keputusan Penentuan Prioritas Maintenance Aset di PT. ISS Indonesia,” J. Kolaboratif Sains, vol. 7, no. 1, pp. 498–508, 2024, doi: 10.56338/jks.v7i1.4919.

D. E. H. Purnomo, Y. A. Sunardiansyah, and N. Hutasoit, “Rancang Bangun Sistem Pendukung Keputusan Untuk Penilaian Kinerja Karyawan Dengan Metode Weighted Product (WP),” JTII (Jurnal Teknol. Inf. Indones., vol. 7, no. 1, pp. 1–7, 2022.

S. Zakeri, P. Chatterjee, D. Konstantas, and F. Ecer, A decision analysis model for material selection using simple ranking process, vol. 13, no. 1. Nature Publishing Group UK, 2023. doi: 10.1038/s41598-023-35405-z.

A. M. AlAli, A. Salih, and A. Hassaballa, “Geospatial-Based Analytical Hierarchy Process (AHP) and Weighted Product Model (WPM) Techniques for Mapping and Assessing Flood Susceptibility in the Wadi Hanifah Drainage Basin, Riyadh Region, Saudi Arabia,” Water (Switzerland), vol. 15, no. 10, 2023, doi: 10.3390/w15101943.

M. Marsono, A. H. Nasyuha, and Y. Syahra, “Decision Support System for Selecting Online Teaching Methods Using the Fuzzy MCDM Algorithm,” Sinkron, vol. 8, no. 3, pp. 1495–1504, 2024, doi: 10.33395/sinkron.v8i3.13731.

E. R. Susanto and R. Ramadhani, “Optimalisasi Bonus Tahunan Pegawai Dengan Menggunakan Metode Weight Product (Wp),” JIPI (Jurnal Ilm. Penelit. dan Pembelajaran Inform., vol. 10, no. 1, pp. 1–10, 2025, doi: 10.29100/jipi.v10i1.5567.

M. H. Natanael and D. Kusumaningsih, “Penerapan Metode Weighted Product Pada Sistem Penunjang Keputusan Untuk Pemilihan Anggota Terbaik Naposo,” Technol. J. Ilm., vol. 12, no. 1, p. 41, 2021, doi: 10.31602/tji.v12i1.4181.

DOI: https://doi.org/10.46576/syntax.v6i2.8065