Vegetable Sales Transaction Segmentation using K-Means Clustering for Sales Strategy Optimization

Dimas Wahyu Eko Prasetyo, Charitas Fibriani (SCOPUS ID=57192643331)

Abstract


Managing fresh vegetable inventory requires accurate decision-making because of its limited shelf life and variations in unit prices and sales volumes. This study aims to segment vegetable sales transactions at D2 Vegetables, a vegetable supplier, using K-Means Clustering based on unit price and sales volume; evaluate cluster quality; and develop operational recommendations based on the characteristics of each segment. The dataset consists of 1,016 vegetable sales transactions recorded from June 25, 2024, to June 23, 2025. The analytical procedures included data preprocessing, standardization, determination of the optimal number of clusters using the Elbow Method, evaluation using the Silhouette Coefficient and Davies-Bouldin Index, K-Means clustering, and comparison with Agglomerative Hierarchical Clustering. Internal evaluation indicated that K = 2 achieved the highest Silhouette Coefficient (0.6114) and the lowest Davies-Bouldin Index (0.5156). However, K = 3 was selected by considering the Elbow pattern, cluster structure quality, and interpretability of the resulting three transaction segments. At K = 3, K-Means achieved a Silhouette Coefficient of 0.5719 and a Davies-Bouldin Index of 0.6029, outperforming Agglomerative Clustering, which achieved scores of 0.5031 and 0.6595, respectively. The resulting segmentation comprised 682 Standard transactions (67.13%), 235 Bulk transactions (23.13%), and 99 Premium transactions (9.74%). The Bulk segment had the highest total sales volume, the Standard segment had the largest number of transactions and the greatest diversity of vegetable types, while the Premium segment had the highest average unit price and relatively low sales volume. The segmentation results can serve as a decision-support basis for procurement planning, inventory management, storage allocation, and segment-specific promotional strategies, enabling operational decisions to be aligned with the characteristics of each transaction segment.

Keywords


K-Means Clustering; transaction segmentation; fresh vegetables; inventory; cluster evaluation

Full Text:

PDF

References


D. G. Gioia, L. K. Felizardo, dan P. Brandimarte, “Simulation-based Inventory Management of Perishable Products Via Linear Discrete Choice Models,” Comput. Oper. Res., Vol. 157, Sep 2023, DOI: 10.1016/j.cor.2023.106270.

L. Xiao dan J. Zhang, “A New Customer Segmentation Framework based on the Gaussian Mixture Model and ASSUMPTION-FREE K-MC2,” Electronics (Switzerland), Vol. 13, No. 17, Sep 2024, DOI: 10.3390/electronics13173523.

M. S. E. Kasem, M. Hamada, dan I. Taj-Eddin, “Customer Profiling, Segmentation, and Sales Prediction using AI in Direct Marketing,” Neural Comput. Appl., Vol. 36, No. 9, hlm. 4995–5005, Mar 2024, DOI: 10.1007/s00521-023-09339-6.

M. Alves Gomes dan T. Meisen, “A Review on Customer Segmentation Methods for Personalized Customer Targeting in E-Commerce Use Cases,” Information Systems and e-Business Management, Vol. 21, No. 3, hlm. 527–570, Sep 2023, DOI: 10.1007/s10257-023-00640-4.

A. Kaur, Y. Kumar, dan J. Sidhu, “Exploring Meta-Heuristics for Partitional Clustering: Methods, Metrics, Datasets, and Challenges,” Artif. Intell. Rev., Vol. 57, No. 10, Okt 2024, DOI: 10.1007/s10462-024-10920-1.

J. Salminen, M. Mustak, M. Sufyan, dan B. J. Jansen, “How can Algorithms Help in Segmenting Users and Customers? A Systematic Review and Research Agenda for Algorithmic Customer Segmentation,” Journal of Marketing Analytics, Vol. 11, No. 4, hlm. 677–692, Des 2023, DOI: 10.1057/s41270-023-00235-5.

L. M. Harahap, W. Fuadi, L. Rosnita, E. Darnila, dan R. Meiyanti, “Klastering Sayuran Unggulan menggunakan Algoritma K-Means,” Jurnal Teknik Informatika dan Sistem Informasi, Vol. 8, No. 3, hlm. 567–579, Des 2022, DOI: 10.28932/jutisi.v8i3.5277.

S. Pujiono, R. Astuti, dan F. Muhamad Basysyar, “Implementasi Data Mining untuk menentukan Pola Penjualan Produk menggunakan Algoritma K-Means Clustering,” Jurnal Mahasiswa Teknik Informatika, Vol. 8, No. 1, hlm. 615–620, Feb 2024.

T. T. Alifa, R. Astuti, dan F. M. Basysyar, “Implementasi Data Mining menggunakan Algoritma K-means Clustering dalam Analisis Penjualan Produk,” Jurnal Mahasiswa Teknik Informatika, Vol. 8, No. 1, hlm. 602–607, Feb 2024.

E. Lianita, A. Pratama, dan A. F. Ulva, “Penerapan Metode K-Means Clustering untuk Pemetaan Produktivitas Sayur-Sayuran berbasis Sistem Informasi Geografis di Provinsi Sumatera Utara,” Jurnal Sistem dan Teknologi Informasi (JustIN), Vol. 12, No. 2, hlm. 232–238, Apr 2024, DOI: 10.26418/justin.v12i2.72934.

T. Amalina, D. B. A. Pramana, dan B. N. Sari, “Metode K-Means Clustering dalam Pengelompokan Penjualan Produk Frozen Food,” Jurnal Ilmiah Wahana Pendidikan, Vol. 8, No. 15, hlm. 574–583, Sep 2022, DOI: 10.5281/zenodo.7052276.

M. H. Adlun, R. Astuti, dan F. M. Basysyar, “Pengelompokan Data Penjualan Sembako berdasarkan Perilaku Pembeli menggunakan Algoritma K-Means Clustering,” Jurnal Mahasiswa Teknik Informatika, Vol. 8, No. 4, hlm. 7699–7703, Agu 2024.

A. Yahya dan R. Kurniawan, “Implementasi Algoritma K-Means untuk Pengelompokan Data Penjualan berdasarkan Pola Penjualan,” MALCOM: Indonesian Journal of Machine Learning and Computer Science, Vol. 5, No. 1, hlm. 350–358, Jan 2025, DOI: 10.57152/malcom.v5i1.1773.

J. Pahrudin dan S. Mulyeni, “Implementasi Algoritma K-Means Clustering dengan Python untuk Analisis Produksi Bawang Merah di Indonesia,” SOSIAL: Jurnal Ilmiah Pendidikan IPS, Vol. 3, No. 4, hlm. 01–15, Okt 2025, DOI: 10.62383/sosial.v3i4.1228.

E. Wahyudin, R. A. Rudin, Kaslani, dan S. E. Permana, “Penerapan Data Mining Pengelompokan Produktivitas Padi menggunakan Algoritma K-means pada Provinsi Jawa Barat,” Jurnal Mahasiswa Teknik Informatika, Vol. 8, No. 1, hlm. 522–528, Feb 2024, [Daring]. Tersedia pada: https://opendata.jabarprov.go.id/id/dataset/produktivit

A. P. Rizkyandri, Jasmir, dan Y. Arvita, “Implementasi Metode K-Means Clustering untuk menentukan Persediaan Barang pada Toko SS BabyShop,” Jurnal Informatika Dan Rekayasa Komputer (JAKAKOM), Vol. 3, No. 2, hlm. 712–718, Sep 2023, DOI: 10.33998/jakakom.v3i2.

M. C. Gumilang dan I. Tahyudin, “Optimasi Manajemen Stok melalui Pengelompokan Produk Ritel berdasarkan Data Penjualan dengan K-Means,” Jurnal Algoritma, Vol. 22, No. 2, hlm. 644–655, Nov 2025, DOI: 10.33364/algoritma/v.22-2.2526.

D. Indriani, B. Irawan, dan A. Bahtiar, “Penerapan Algoritma K-means Clustering untuk menentukan Persediaan Stok Barang,” Jurnal Mahasiswa Teknik Informatika, Vol. 8, No. 1, hlm. 182–187, Feb 2024.

I. Frandika, S. Hud Bayor, dan W. Handoko, “Penerapan K-Means Clustering untuk Segmentasi Penjualan di Minimarket Mardi dengan Pendakatan Machine Learning,” Journal Of Computer Science And Technology (JOCSTEC), Vol. 3, No. 3, hlm. 174–182, Sep 2025, DOI: 10.59435/jocstec.v3i3.574.

M. Fajar, N. Rahaningsih, dan R. D. Dana, “Analisis Pola Penjualan Obat di Apotek An-Naafi menggunakan Metode K-means Clustering,” Jurnal Mahasiswa Teknik Informatika, vol. 8, no. 1, hlm. 486–492, Feb 2024.

M. R. Muttaqin, T. I. Hermanto, dan M. A. Sunandar, “Penerapan K-Means Clustering dan Cross-Industry Standard Process For Data Mining (CRISP-DM) untuk mengelompokan Penjualan Kue,” KOMPUTASI: Jurnal Ilmiah Ilmu Komputer dan Matematika, Vol. 19, No. 1, hlm. 38–53, Jan 2022, [Daring]. Tersedia pada: https://journal.unpak.ac.id/index.php/komputasi

W. T. Pambudi dan A. Witanti, “Penerapan Algoritma K-means untuk Menganalisis Data Penjualan pada Toko Ayu Collection berbasis WEB,” Jurnal Sistem Informasi dan Bisnis Cerdas (SIBC), Vol. 15, No. 1, hlm. 1–9, Feb 2022.




DOI: https://doi.org/10.32520/stmsi.v15i8.6674

Article Metrics

Abstract view : 1 times
PDF - 0 times

Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.