Preprint has been published in a journal as an article
Preprint / Version 1

Data-Driven Strategies for Fuel Distribution in Indonesia: A case Study of PT Pertamina Patra Niaga


Strategi Distribusi Bahan Bakar di Indonesia Berbasis Data: Studi Kasus di PT Pertamina Patra Niaga

##article.authors##

DOI:

https://doi.org/10.21070/ups.3895

Keywords:

churn, customer segmentation, salesman clustering, decision tree, k-means clustering

Abstract

PT Pertamina as a key supplier in Indonesia's competitive fuel market. To maintain its market edge, PT Pertamina must understand and predict customer behavior and loyalty. This study uses a combination of the RFM method, decision tree algorithms, and k-means clustering to analyze customer loyalty, salesperson performance, and potential customer churn, with a focus on the relationship between churn and salesperson expertise. The research utilizes sales transaction data from PT Pertamina Patra Niaga Regional Jatimbalinus. Findings from the decision tree algorithm show a high loyalty rate among customers, with 100% confusion matrix. Salespersons are categorized into two performance-based clusters: 'good performance' and 'poor performance'. A key discovery is the identification of a customer group likely to churn, a factor not influenced by salesperson performance. Understanding these aspects can help the company refine its strategies, potentially reducing churn and bolstering its position in the fuel market.

Downloads

Download data is not yet available.

References

W. M. Putri, R. Rusdah, L. Suryadi, and D. Anubhakti, “Prediksi Kelulusan Mahasiswa Fakultas Teknologi Informasi ISB Atma Luhur Menggunakan Algoritma C4.5,” J. SISFOKOM (Sistem Inf. dan Komputer), vol. 12, no. 03, pp. 363–369, 2023.

A. Pandey, “Study and Analysis of K-Means Clustering Algorithm Using Rapidminer A CASE STUDY ON STUDENTS’ EXAM RESULT,” J. Eng. Res. Appl. www.ijera.com, vol. 4, no. 12, pp. 60–64, 2014, [Online]. Available: www.ijera.com

N. W. Wardani, G. R. Dantes, and G. Indrawan, “Prediksi Customer Churn Dengan Algoritma Decision Tree C4 . 5,” J. Resist., vol. 1, no. 1, pp. 16–24, 2018.

F. Soufitri, E. Purwawijaya, E. H. Hasibuan, and R. N. Singarimbun, “Testing C4.5 Algorithm Using Rapid Miner Applications In Determining Customer Satisfaction Levels,” J. Infokum, vol. 9, no. 2, pp. 510–517, 2021, [Online]. Available: http://infor.seaninstitute.org/index.php/infokum/index

E. Muningsih, I. Maryani, and V. R. Handayani, “Penerapan Metode K-Means dan Optimasi Jumlah Cluster dengan Index Davies Bouldin untuk Clustering Propinsi Berdasarkan Potensi Desa,” J. Sains dan Manaj., vol. 9, no. 1, pp. 95–100, 2021, [Online]. Available: https://ejournal.bsi.ac.id/ejurnal/index.php/evolusi/article/view/10428/4839

E. K. Tarigan, "Juridical analysis of retail fuel oil sales according to the oil and gas law (law number 22 of 2001)," J. Lex Justitia, vol. 2, no. 2, pp. 121-134, 2021, [Online]. Available: http://ejournal.potensi-utama.ac.id/ojs/index.php/LexJustitia/article/view/1347.

A. Munawar et al., "Cluster Application with K-Means Algorithm on the Population of Trade and Accommodation Facilities in Indonesia," J. Phys. Conf. Ser., vol. 1933, no. 1, 2021, doi:

1088/1742-6596/1933/1/012027S.

F. Rahman, I. I. Ridho, M. Muflih, S. Pratama, M. R. Raharjo, and A. P. Windarto,

"Application of Data Mining Technique using K-Medoids in the Case of Export of Crude Petroleum Materials to the Destination Country," IOP Conf. Ser. Mater. Sci. Eng., vol. 835, no. 1, 2020, doi: 10.1088/1757-899X/835/1/012058.

J. R. Riwukore, L. Marnisah, and F. Habaora, “Employee Performance Analysis Based on the Effect of Discipline, Motivation, and Organizational Commitment at the Regional Secretariat of the Kupang City Government,” J. Maksipreneur Manajemen, Koperasi, dan Entrep., vol. 12, no. 1, p. 76, 2022, doi: 10.30588/jmp.v12i1.1009.

P. A. Sampurna and T. Miranti, “The Effect of Service Quality, Banking Digitalization, and Customer Relationship Management (CRM) on Customer Loyalty,” J. Maksipreneur Manajemen, Koperasi, dan Entrep., vol. 12, no. 1, p. 303, 2022, doi: 10.30588/jmp.v12i1.1138

J. F. Sofyan and M. Rianty, “Karakteristik Manajemen dan Kepemimpinan Transformasional sebagai Penentu Kreativitas Karyawan yang Dimediasi oleh Kepuasaan Kerja,” J. Maksipreneur Manajemen, Koperasi, dan Entrep., vol. 12, no. 2, p. 448, 2023, doi: 10.30588/jmp.v12i2.1186.

F. P. Ferdy Pangestu, N. Y. Nur Yasin, R. C. Ronald Chistover Hasugian, and Y. Yunita, “Penerapan Algoritma K-Means Untuk Mengklasifikasi Data Obat,” J. Sisfokom (Sistem Inf. dan Komputer), vol. 12, no. 1, pp. 53–62, 2023, doi: 10.32736/sisfokom.v12i1.1461.

A. A. Syahidah and M. F. Aransyah, “Pengaruh E-Service Quality dan E-Trust Terhadap E-Customer Loyalty Pada Pengguna Dompet Digital DANA Melalui E-Satisfaction Sebagai Variabel Intervening,” J. Sisfokom (Sistem Inf. dan Komputer), vol. 12, no. 1, pp. 36–44, 2023, doi: 10.32736/sisfokom.v12i1.1593.

A. Rosyida and T. Bayu Sasongko, “Deteksi Dini Penyakit Alzheimer dengan Algoritma C4.5 Berbasis BPSO (Binary Particle Swarm Optimization),” J. SISFOKOM (Sistem Inf. dan Komputer), vol. 12, pp. 341–349, 2023.

D. E. Sondakh, R. C. Maringka, F. P. Ayorbaba, J. S. C. B. T. Mangi, and S. R. Pungus, “Emotion Mining Review Pengguna Aplikasi Mobile Banking BRImo Menggunakan Algoritma Decision Tree,” vol. 12, pp. 350–355, 2023.

F. Warda, F. N. Fajri, and A. Tholib, “Classification of Final Project Titles Using Bidirectional Long Short Term Memory at the Faculty of Engineering Nurul Jadid University,” J. Sisfokom (Sistem Inf. dan Komputer), vol. 12, no. 3, pp. 356–362, 2023, doi: 10.32736/sisfokom.v12i3.1723.

R. Vannya and A. Hermawan, “Analisis Performa klasifikasi Kesegaran Daging Ayam menggunakan Naïve Bayes , Decision Tree , dan,” vol. 12, pp. 394–400, 2023

M. W. Sari, N. N. Deswira, and A. Risdwiyanto, “Determinasi Kepuasan Kerja dan Implikasinya terhadap Turnover Intention: Studi pada PT Hayati Pratama Mandiri Padang,” J. Maksipreneur Manajemen, Koperasi, dan Entrep., vol. 12, no. 2, p. 346, 2023, doi: 10.30588/jmp.v12i2.430.

E. Fatmasari and B. S. Dwiyanto, “Analisis Kinerja Keuangan dengan Metode Economic Value-Added pada Studi Kasus Perusahaan Subsektor Pertambangan Minyak dan Gas Bumi yang Terdaftar di Indeks Saham Syariah Indonesia (ISSI),” J. Maksipreneur Manajemen, Koperasi, dan Entrep., vol. 9, no. 1, p. 17, 2019, doi: 10.30588/jmp.v9i1.435.

K. S. Utami, “Green consumers behavior: Consumer behavior in purchasing environmentally friendly products,” Manag. Coop. Entrep., vol. 9, no. 2, pp. 208–223, 2020, [Online]. Available: http://ejournal.up45.ac.id/index.php/maksipreneur/article/download/499/526

R. B. Prakarsa, W. Yadiati, and N. R. H. Suciati, “Pengaruh Risk Profile, Good Corporate Governance, Earning, Capital terhadap Value of Firm di Bursa Efek Indonesia,” J. Maksipreneur Manajemen, Koperasi, dan Entrep., vol. 9, no. 2, p. 137, 2020, doi: 10.30588/jmp.v9i2.530.

I. L. Natapermana, W. Yadiati, and E. Nurhayati, “Pengaruh Implementasi Good Corporate Governance dan Strategi Bisnis terhadap Kinerja Perusahaan: Studi Kasus BUMN di Indonesia Tahun 2013-2018,” J. Maksipreneur Manajemen, Koperasi, dan Entrep., vol. 9, no. 2, p. 153, 2020, doi: 10.30588/jmp.v9i2.579.

A. Junaidi, “Sisfokom-Maret2019-604-1539-1-PB,” vol. 08, pp. 61–67, 2019.

W. Marantika and S. Sarsono, “Pengaruh Kualitas Produk, Word of Mouth, dan Store Image terhadap Keputusan Pembelian: Studi pada Pengunjung Toko Amigo Pedan,” J. Maksipreneur Manajemen, Koperasi, dan Entrep., vol. 10, no. 1, p. 114, 2020, doi: 10.30588/jmp.v10i1.633.

A. Khomsiyah and S. Sanaji, “Pengaruh Loyalitas dan Fanatisme Supporter pada Klub terhadap Keputusan Pembelian Merchandise Orisinal: Studi pada Supporter Persela Lamongan,” J. Maksipreneur Manajemen, Koperasi, dan Entrep., vol. 10, no. 2, p. 242, 2021, doi: 10.30588/jmp.v10i2.756

D. M. D. Prama Yanti and I. G. Sanica, “Menelisik Pengelolaan Human Capital di Dunia Bisnis dalam Era New Normal: Studi Kasus pada Generasi Milenial di Bali,” J. Maksipreneur Manajemen, Koperasi, dan Entrep., vol. 11, no. 1, p. 122, 2021, doi: 10.30588/jmp.v11i1.840.

M. A. S. Arifin, H. Oktafia, and L. Wijaya, “Deteksi Botnet IoT Menggunakan Autoencoder dan Decision Tree,” vol. 12, pp. 329–334, 2023.

Posted

2024-02-05