Application of K-Means Clustering for Consumable Inventory Expenditure at BKPSDM of Kudus Regency

Windraningsih; R. Rhoedy  Setiawan; Supriyono

doi:10.24036/jtip.v19i1.1106

Authors

Windraningsih Universitas Muria Kudus
R. Rhoedy Setiawan Universitas Muria Kudus
Supriyono Universitas Muria Kudus

DOI:

https://doi.org/10.24036/jtip.v19i1.1106

Keywords:

▪ K-Means Clustering ▪ CRISP-DM ▪ Inventory Expenditure ▪ Web-Based System ▪ BKPSDM

Abstract

The management of consumable inventory expenditure at the Human Resources and Personnel Development Agency (BKPSDM) of Kudus Regency still encounters challenges due to manual and unsystematic data analysis processes. This study aims to classify inventory usage data using the K-Means Clustering method supported by the CRISP-DM framework. The variables used include the quantity and total value of item expenditures. A web-based system was also developed to support the clustering process and provide analysis results more effectively. The K-Means++ algorithm was implemented to obtain better centroid initialization. The findings show three main clusters representing low, medium, and high expenditure levels. The system presents clustering results in tables and charts, making them easier to interpret for decision-making. This research is expected to support inventory planning and improve efficiency in inventory management at BKPSDM Kudus.

References

J. Han, M. Kamber, and J. Pei, Konsep dasar dan teknik lanjutan dalam data mining, 3rd ed. Elsevier, 2012.

Wu, X. & Kumar, V., The Top Ten Algorithms in Data Mining. London: CRC Press. 2009.

Zhao, S., Yang, R., Meng, F., and Cai, L., The standard K-Means algorithm is known to be sensitive to the selection of initial centroids, which can lead to inconsistent clustering results and convergence to local optima, especially on complex or large datasets. Elsevier, 2025.

Khalish, F., Piranti, N.M., and Martadireja, O., “Implementasi Data Mining Menggunakan Teknik Clustering dengan Metode K-Means”, Jurnal Ilmiah Ilmu Pendidikan, vol. 8, no. 5, pp. 5392-5397, 2025.

Arthur, D. & Vassilvitskii, S., “k-means++: The Advantages of Careful Seeding.” SODA ’07: Proceedings of the Eighteenth Annual ACM-SIAM Symposium on Discrete Algorithms, 2007, pp. 1027–1035, https://dl.acm.org/doi/10.5555/1283383.1283494.

G. Richards, Warehouse management: A complete guide to improving efficiency and minimizing costs in the modern warehouse, Kogan Page Publishers, 2014.

P. Chapman, J. Clinton, R. Kerber, T. Khabaza, T. Reinartz, C. Shearer, and R. Wirth, CRISP-DM 1.0: Step-by-Step Data Mining Guide. SPSS Inc., 2000.

D. Kurniawansyah and J. Devitra, “Sistem informasi untuk manajemen stok barang habis pakai di instansi lingkungan hidup,” Jurnal Manajemen Sistem Informasi, vol. 8, no. 4, pp. 568–581, 2023.

T. B. Pamungkas, S. Maesaroh, and P. Ardiansyah, “Implementasi data mining pada stok penggunaan barang di GMF Aeroasia menggunakan algoritma K-means clustering,” Jurnal Ilmiah Sains dan Teknologi, vol. 7, no. 2, pp. 112–123, 2023.

Supriyono, K . F. Ferine, D. Puspitasari, Rulinawaty, and E. Timotius, “Implementation of data mining with Apriori techniques to determine the pattern of purchasing of agricultural equipment (Case study: XYZ Store),” Journal of Physics: Conference Series, vol. 1933, no. 1, 2021.

R. R. Setiawan, “Desain informasi untuk penelitian database berbasis web,” Jurnal Sistem Informasi dan Teknologi, vol. 1, no. 2, pp. 3–10, 2018.

R. Setiawan, D. L. Fithri, A. P. Utomo, and F. Nugraha, “Penerapan optimalisasi marketplace untuk pemasaran produk pada UMKM keripik pare Alena Desa Damaran, Kecamatan Kota Kabupaten Kudus,” Muria Jurnal Layanan Masyarakat, 2022.

T. S. Ardan, S. A. Mujiatno, and B. A. Akbar, “Implementasi data analytics menggunakan metodologi CRISP-DM (Studi kasus data bike sales in Europe pada platform Kaggle),” JSiI | Jurnal Sistem Informasi, vol. 12, no. 2, pp. 10–15, 2025.

A. Gunawan, S. Ningsih and D.A. Lantana, Pengantar BASIS DATA, PT. Literasi Nusantara Abadi Grup, 2023.

Alfandi. M. Sofyan & Fatah. Zaehol, “Penerapan Data Mining Menggunakan Metode K-Means Clustering Untuk Analisa Penjualan Toko Umama Hijab Kaliwates jember”, Jurnal Riset Sistem Informasi, vol. 1, no. 4, hlm. 94–102, 2024.

H. K. N. Iman, N. Latifah, S. Supriyono, and F. Nugraha, “Pemanfaatan metode decision tree dengan algoritma C4.5 untuk prediksi potensi kunjungan wisatawan,” Jurnal Sistem Komputer dan Informatika (JSON), vol. 5, no. 3, p. 611, 2024.

F. Nurdiyansyah and I. Akbar, “Implementasi algoritma K-means untuk menentukan persediaan barang pada poultry shop,” Jurnal Teknologi dan Manajemen Informatika, vol. 7, no. 2, pp. 86–94, 2021.

A. M. H. Pardede et al., “Implementation of data mining to classify the consumer’s complaints of electricity usage based on consumer’s locations using clustering method,” Journal of Physics: Conference Series, vol. 1363, p. 012079, 2019.

A. P. Rizkyandri, Jasmir, and Y. Arvita, “Implementasi Metode K-Means Clustering Untuk Menentukan Persediaan Barang Pada Toko SS Baby Shop,” Jurnal Informatika dan Rekayasa Komputer (JAKAKOM), vol. 3, no. 2, pp. 712–718, 2023.

D. Ruswanti, D. Susilo and Riani, ”Implementasi CRISP-DM pada Data Mining untuk Melakukan Prediksi Pendapatan dengan Algoritma C.45,” GO INFOTECH: JURNAL ILMIAH STMIK AUB, vol. 30, no. 1, pp.111-121, 2024.

N. C. Ningsih, D. Novaliendry, Y. Hendriyani, and D. Asmara, “Grouping of Student Achievement Based on Student Names in Class VII of SMPN 28 Sarolangun Using the K-Means Clustering Method,” Jurnal Teknologi Informasi dan Pendidikan, vol. 18, no. 2, pp. 864-882, 2025.

A. B. P. Pradata, Supriyono, and D. L. Fithri, “Web-Based Expert System for Dental Disease Diagnosis Using the Certainty Factor Method: A Case Study at Al-Fatah Primary Clinic,” Jurnal Teknologi Informasi dan Pendidikan, vol. 18, no. 2, pp. 984-1005, 2025.

A. F. Hakim, Y. Irawan, and R. R. Setiawan, “Implementation of the CRISP-DM Methodology and Naive Bayes Algorithm on a Raw Material Requirement Prediction System to Reduce Food Waste (Case Study: Adamsafee Bakery, Resto, & Cafe),” Jurnal Teknologi Informasi dan Pendidikan, vol. 18, no. 2, pp. 968-983., 2025.