Application of K-Means Clustering Algorithm in Edam Burger Sales Information System for Inventory Control Optimization
DOI:
https://doi.org/10.69916/jkbti.v5i3.565Keywords:
sales application, K-Means algorithm, clustering, inventory control, waterfallAbstract
Manual sales and inventory management in small culinary enterprises often leads to data inaccuracies, stock mismanagement, and underutilized transactional data. This study aims to design a web-based sales information system integrated with the K-Means clustering algorithm to optimize inventory control at Edam Burger & Frozen Foods. Utilizing the Waterfall methodology, the system was developed using the Laravel framework and MySQL. The analytical engine processed five months of transactional data across fifteen products, applying Min-Max Normalization to equalize the scales of sales volume, revenue, and transaction frequency. The K-Means algorithm successfully segmented the product catalog into three distinct categories based on performance: one high-selling core product (6.7%), three medium-selling secondary items (20%), and eleven low-selling complementary products (73.3%). Black Box Testing confirmed a 100% functional success rate across all system modules. The primary novelty of this research lies in seamlessly embedding the K-Means engine directly into the operational dashboard, overcoming the common barrier of offline, standalone data mining. This integration enables real-time, data-driven procurement strategies, providing actionable recommendations: prioritizing continuous stock availability for high-demand items, scheduling regular restocking for medium items, and minimizing capital tied up in low-moving inventory to reduce food waste. Ultimately, this integrated approach empowers small business owners to transition from intuition-based management to systematic, algorithm-driven inventory optimization. This study successfully bridges the gap between routine transactions and strategic analytics.
Downloads
References
V. Y. P. Ardhana, “Application of the Extreme Programming Method in a Web-Based Sales Information System,” JISMDB, vol. 1, no. 2, pp. 227–235, 2024.
F. L. D. Cahyanti, E. Firasari, and U. Khultsum, “Web-Based Sales Information System for SME Rukun Makmur Tlingsing,” Nuansa Inform., vol. 18, 2024.
A. E. Yanuar and M. A. Senubekti, “Perancangan Aplikasi Penjualan Online Berbasis Website (Studi Kasus: Bakso Emsa),” J. Nuansa Inform., vol. 16, no. 1, 2022.
H. D. Dermawan, R. Kurniawan, and Y. A. Wijaya, “Sales Data Analysis Using K-Means Clustering at Daun Indah Store on Shopee,” CESS, vol. 9, no. 1, pp. 175–191, 2024.
S. Kumar, R. Rani, S. K. Pippal, and R. Agrawal, “Customer segmentation in e-commerce: K-means vs hierarchical clustering,” Telkomnika (Telecommunication Comput. Electron. Control., vol. 23, no. 1, pp. 119–128, 2025, doi: 10.12928/TELKOMNIKA.v23i1.26384.
H. Mukhtar and others, “K-Means Algorithm for Customer Behavior Clustering,” SEIS, vol. 4, no. 2, pp. 96–101, 2024.
A. M. Ikotun, A. E. Ezugwu, L. Abualigah, B. Abuhaija, and J. Heming, “K-means clustering algorithms: A comprehensive review, variants analysis, and advances in the era of big data,” Inf. Sci. (Ny)., vol. 622, pp. 178–210, 2023, doi: https://doi.org/10.1016/j.ins.2022.11.139.
M. Ahmed, R. Seraj, and S. M. S. Islam, “The k-means algorithm: A comprehensive survey and performance evaluation,” Electron., vol. 9, no. 8, pp. 1–12, 2020, doi: 10.3390/electronics9081295.
R. I. Manarung, E. Widodo, and A. M. Rifai, “Sales Data Clustering Using the K-Means Algorithm to Determine Retail Product Needs,” Int. J. Softw. Eng. Comput. Sci., vol. 5, no. 1, pp. 226–234, 2025, doi: 10.35870/ijsecs.v5i1.4090.
B. I. Nugroho, A. Rafhina, P. S. Ananda, and G. Gunawan, “Customer segmentation in sales transaction data using k-means clustering algorithm,” J. Intell. Decis. Support Syst., vol. 7, no. 2, pp. 130–136, 2024, doi: 10.35335/idss.v7i2.236.
T. Amalina, D. B. A. Pramana, and B. N. Sari, “Metode K-Means Clustering dalam Pengelompokan Penjualan Produk Frozen Food,” J. Ilm. Wahana Pendidik., vol. 8, pp. 574–583, 2022.
D. Sunia, J. Jasmir, and B. Purnama, “Implementation of Data Mining to Determine Inventory at Mahkota Mart Using K-Means,” JAKAKOM, vol. 6, no. 1, 2026.
B. Shen, “E-commerce Customer Segmentation via Unsupervised Machine Learning,” in The 2nd International Conference on Computing and Data Science, in CONF-CDS 2021. New York, NY, USA: Association for Computing Machinery, 2021. doi: 10.1145/3448734.3450775.
B. Sembiring, S. Natalia, H. Winata, and S. Kusnasari, “Pengelompokan Prestasi Siswa Menggunakan Algoritma K-Means,” J. Sist. Inf. Triguna Dharma (JURSI TGD), vol. 1, no. 1, p. 31, 2022, doi: 10.53513/jursi.v1i1.4784.
H. Humaidi and I. F. Hanif, “Perancangan Sistem Informasi Keuangan dan Aset Berbasis Web (Studi Kasus: PT Informatika Media Pratama),” vol. 1, no. 1, pp. 25–33, 2022.
R. Triyanto, “Rancang Bangun Aplikasi Penjualan Berbasis Website (Studi Kasus : Toko Waroeng Bola),” J. Sist. Inf. dan Sains Teknol., vol. 2, no. 1, pp. 1–9, 2020, doi: 10.31326/sistek.v2i1.670.
S. F. Fakhirah and others, “Design and Development of an E-Commerce Website Using the Waterfall Method with the Laravel Framework,” JTOS, vol. 8, no. 2, pp. 441–452, 2025.
P. Kustanto, W. A. Kurniawan, A. Noe’man, Nurfiyah, and Ridwan, “Implementation of Priority Scheduling Algorithm in Designing Infrastructure Damage Reporting System,” Greenation Int. J. Eng. Sci., vol. 2, no. 3, pp. 98–112, 2024, doi: 10.38035/gijes.v2i3.
E. Bu’ulolo, “K-NN Algorithm with Min-Max Normalization for Selecting Eligible Students for the KIP Kuliah Merdeka Scholarship,” SIMKOM, vol. 9, no. 2, pp. 184–194, 2024.
X. Pei et al., “Robustness of machine learning to color, size change, normalization, and image enhancement on micrograph datasets with large sample differences,” Mater. Des., vol. 232, p. 112086, 2023, doi: 10.1016/j.matdes.2023.112086.
F. P. Dewi, P. S. Aryni, and Y. Umaidah, “Implementasi Algoritma K-Means Clustering Seleksi Siswa Berprestasi Berdasarkan Keaktifan dalam Proses Pembelajaran,” JISKA (Jurnal Inform. Sunan Kalijaga), vol. 7, no. 2, pp. 111–121, 2022, doi: 10.14421/jiska.2022.7.2.111-121.
Downloads
Published
Scite Metrics
Altmetric
How to Cite
Issue
Section
License
Copyright (c) 2026 Muhammad Rofiq Ubaidillah, R Wisnu Prio Pamungkas, Prio Kustanto
This work is licensed under a Creative Commons Attribution 4.0 International License.
Most read articles by the same author(s)
- R Wisnu Prio Pamungkas, Dimas Alfauzi Hidayatullah, Alya Priscilla Putri, Vicky Eka Syahputra, Putra Aldi Purnama, MYVIRTUALCLINIC: PENGEMBANGAN APLIKASI TELEMEDICINE BERBASIS MOBILE DENGAN PENDEKATAN GOAL-DIRECTED DESIGN (GDD) UNTUK LAYANAN KESEHATAN DI ERA DIGITAL , Jurnal Kecerdasan Buatan dan Teknologi Informasi: Vol. 4 No. 1 (2025): January 2025
- R Wisnu Prio Pamungkas, Rakhmi Khalida, DESIGN AND DEVELOPMENT OF AN EARLY WARNING SYSTEM THROUGH CONTINUOUS AUDITING AND CONTINUOUS MONITORING IN PUBLIC SECTOR PROCUREMENT , Jurnal Kecerdasan Buatan dan Teknologi Informasi: Vol. 5 No. 2 (2026): May 2026
- Ilham maulana, R Wisnu Prio Pamungkas, Fried Sinlae, Software Development Safety Monitoring Interface for Elevator Systems Using Bitwise Decoding and Finite State Machines , Jurnal Kecerdasan Buatan dan Teknologi Informasi: Vol. 5 No. 3 (2026): September 2026 In progress.
- Fairuz Hadi, R Wisnu Prio Pamungkas, Fried Sinlae, Optimization of Fuzzy Tsukamoto for Waste Paper Quality Unfitness Weighting , Jurnal Kecerdasan Buatan dan Teknologi Informasi: Vol. 5 No. 3 (2026): September 2026 In progress.
- M.Syahrul, R Wisnu Prio Pamungkas, Fried Sinlae, Fraud Detection in Subsidized LPG Gas Distribution at the Base Level as a Monitoring System Using the Mamdani Fuzzy Logic Algorithm , Jurnal Kecerdasan Buatan dan Teknologi Informasi: Vol. 5 No. 3 (2026): September 2026 In progress.
- Pahrizal, R Wisnu Prio Pamungkas, Fried Sinlae, Transformation of Basketball Academy Athlete Performance Evaluation Using Information Technology and the Weighted Product Method , Jurnal Kecerdasan Buatan dan Teknologi Informasi: Vol. 5 No. 3 (2026): September 2026 In progress.
- Rizky Fadillah Putra Pratama, R Wisnu Prio Pamungkas, Fried Sinlae, Web-Based Stock Overstock Warning System for Spare Parts Inventory Using Linear Regression , Jurnal Kecerdasan Buatan dan Teknologi Informasi: Vol. 5 No. 3 (2026): September 2026 In progress.
- Mona Dewintha Agustine, Adi Muhajirin, Prio Kustanto, Cosmetic Product Segmentation Analysis Using K-Means Clustering at PT Mandom Bekasi , Jurnal Kecerdasan Buatan dan Teknologi Informasi: Vol. 5 No. 3 (2026): September 2026 In progress.
menuterbaru
