Customer Segmentation Using the K-means Clustering Algorithm and Recency Frequency Monetary Model at Pharmaceutical Product Wholesaler

Authors

  • Nur Muhammad Iqbal Universitas Pertamina
  • Yelita Anggiane Iskandar Universitas Pertamina
  • Ferani Eva Zulvia Universitas Pertamina

DOI:

https://doi.org/10.53893/ijrvocas.v4i2.293

Keywords:

Pharmaceutical Distributor, Customer Relationship Management, K-Means Clustering Algorithm, Recency Frequency Monetary

Abstract

PT Kimia Farma Trading and Distribution (KFTD) is a company engaged in the distribution and trading services of Indonesian health products, on a national scale. In 2022, the company aims to increase sales to be awarded as one of the top 3 national pharmaceutical product distributors by 2024. Their current strategy is to provide customers with delayed payment permission and integrated complaint services. However, the offers and services are the same for all customers which does not consider customer track record hence it is not cost-effective. One way to increase sales is by enhancing customer satisfaction and loyalty by implementing Customer Relationship Management (CRM) strategies. Several strategies can be carried out, namely analysis of associations related to pharmaceutical products, and analysis of customer segmentation and clustering of products. The method used in this study was the K-means clustering algorithm combined with the Recency Frequency Monetary (RFM) model. Experiments showed that the optimal clustering results are 4 therefore they are categorized into 4 customer segments, namely Superstar, Golden, Typical, and Occasional Customers.

References

A. Wibowo and A. R. Handoko, "Segmentasi Pelanggan Ritel Produk Farmasi Obat Menggunakan Metode Data Mining Klasterisasi Dengan Analisis Recency Frequency Monetary (RFM) Termodifikasi," J. Teknol. Inf. dan Ilmu Komput, 2020.

W. Dysyandi, W. Sumaryono, S. Widyastuti and H. Lesmana, "Bauran Pemasaran Tentang Konsep Apotek Modern Serta Strategi Pemasarannya," JRB-Jurnal Riset Bisnis, vol. 3, no. 1, pp. 1-8, 2019.

R. Febrian, F. Dzulfaqor, M. N. Lestari, A. A. Romadhon and E. Widodo, "Analisis Pola Pembelian Obat di Apotek Uii Farma Menggunakan Metode Algoritma Apriori," in Seminar Nasional Teknologi Informasi dan Multimedia 2018, Yogyakarta, 2018.

R. A. Hendrawan, A. Utamima and A. Husna, "Segmentasi dan Evaluasi Loyalitas Pelanggan Distributor Produk Etikal Farmasi Berdasarkan Nilai Pelanggan," in Seminar Nasional Sistem Informasi Indonesia (SESINDO), 2015.

P. Kotler and K. L. Keller, Manajemen Pemasaran, 2009.

N. Lubis, "Penerapan Customer Relationship Management (CRM) dengan Menggunakan Metode LRFM Analysis," Jurnal Dinamika Manajemen dan Bisnis, vol. 1, no. 2, 2018.

A. Ramadhan, Z. Efendi and Mustakim, "Perbandingan K-Means dan Fuzzy C-Means untuk Pengelompokan Data User Knowledge Modeling," in Seminar Nasional Teknologi Informasi Komunikasi dan Industri, 2017.

A. D. Savitri, F. A. Bachtiar and N. Y. Setyawan, "Segmentasi Pelanggan Menggunakan Metode K-Means Clustering Berdasarkan Model RFM Pada Klinik Kecantikan (Studi Kasus: Belle Crown Malang)," Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer, vol. 2, no. 9, pp. 2957-2966, 2018.

J. Arisandi and Samsuryadi, "Prediksi Kebutuhan Buah dengan Segmentasi Pasar Menggunakan K-Means," in Annual Research Seminar 2016, 2016.

D. F. Pramesti, T. M. Furqon and C. Dewi, "Implementasi Metode K-medoids Clustering untuk Pengelompokan Data Potensi Kebakaran Hutan/Lahan Berdasarkan Persebaran Titik Panas (Hotspot)," Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer, vol. 1, no. 9, pp. 723-732, 2017.

B. E. Adiana, I. Soesanti and A. E. Permanasari, "Analisis Segmentasi Pelanggan Menggunakan Kombinasi RFM Model dan Teknik Clustering," Jurnal Terapan Teknologi Informasi, vol. 2, no. 1, pp. 23-32, 2018.

Suyanto, Data Mining: For Data Classification and Clustering, Bandung: Informatics Publishers, 2017.

Widiarina and R. S. Wahono, "Algoritma Cluster Dinamik untuk Optimasi Cluster pada Algoritma K-means dalam Pemetaan Nasabah Potensial," Journal of Intelligent Systems, vol. 1, no. 1, pp. 33-36, 2015.

A. A. A. Hidayat, Metode Penelitian Kesehatan: Paradigma Kuantitatif, Surabaya: Health Books Publishing, 2015.

F. Alipour, K. Idris, I. A. Ismail, J. A. Uli and R. Karimi, "Learning Organization and Organizational Performance: Mediation Role of Intrapreneurship," European Journal of Social Sciences, vol. 21, no. 4, pp. 547-555, 2011.

P. Temporal and M. Trott, Romancing the Customer: Maximizing Brand Value Through Powerful Relationship Management, John Wiley & Sons, 2001.

W. G. Zikmund, R. McLeod and F. W. Gilbert, Customer Relationship Management: Integrating Marketing Strategy and Information Technology, Hoboken: Wiley, 2003.

R. Butt, Introduction to Numerical Analysis Using MATLAB, Laxmi Publications, Ltd., 2008.

F. Buttle and S. Maklan, Customer Relationship Management: Concepts and Technologies, Routledge, 2019.

D. J. Hand, "Principles of Data Mining," in Drug Safety, 2007.

A. M. Hughes, Strategic Database Marketing, McGraw-Hill Pub. Co., 2005.

M. J. Zaki and W. Meira, Data Mining and Analysis: Fundamental Concepts and Algorithms, Cambridge University Press, 2014.

Y. Agusta, "K-means–Penerapan, Permasalahan dan Metode Terkait," Jurnal Sistem dan informatika, vol. 3, no. 1, pp. 47-60, 2007.

J. Han, J. Pei and H. Tong, Data mining: Concepts and Techniques, Morgan Kaufmann, 2022.

Additional Files

Published

2024-08-31

How to Cite

Iqbal, N. M., Iskandar, Y. A., & Zulvia, F. E. (2024). Customer Segmentation Using the K-means Clustering Algorithm and Recency Frequency Monetary Model at Pharmaceutical Product Wholesaler. International Journal of Research in Vocational Studies (IJRVOCAS), 4(2), 53–60. https://doi.org/10.53893/ijrvocas.v4i2.293