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

Kania Lovia Tiarazahra(1), Rita Ambarwati(2*)

(1) Universitas Muhammadiyah Sidoarjo
(2) Universitas Muhammadiyah Sidoarjo
(*) Corresponding Author

Abstract


Fuel oil or what is often referred to as BBM is one of the basic needs to drive all community activities. So the government appointed PT Pertamina as a single company which is a state-owned company to facilitate fuel needs for all levels of society. However, with increasing demand, the government formed a new policy to allow private companies to come in to meet all fuel demand. With this, PT Pertamina is no longer the only fuel supplier in Indonesia and must continue to develop mature strategies so that profits do not fade. One way is by examining sales data and predicting customer loyalty. The RFM method followed by the decision tree algorithm and k-means clustering is applied in this research, with the output being able to determine the level of customer loyalty, the level of salesman performance, as well as predicting the potential for customers to churn and its correlation with the salesman's skills. The data used as a reference for the research is sales transaction data obtained from PT Pertamina Patra Niaga Regional Jatimbalinus. And from the research, results showed that the majority of PT Pertamina Patra Niaga Regional Jatimbalinus customers are loyal customers. With a salesman, performance is divided into good performance and less good performance. This grouping is obtained based on the salesman's overall performance track record. As for customer churn predictions, it was found that there was 1 group of customers who were predicted to churn heavily, but this was not influenced by salesman performance, as evidenced by transaction track records in existing data

Keywords


Churn; Customer Segmentation; Salesman Clustering; Decision Trees; K-means Clustering

Full Text:

PDF

References


N. D. Japari, A. Zafrullah TN, and F. R. Djoemadi, "The Role of Pt. Pertamina as a fuel oil supply provider in Indonesia," Calyptra, vol. 7, no. 2, pp. 1-12, 2019.

R. Muliono and Z. Sembiring, "Data Mining Clustering Using K-Means Algorithm for Clustering Lecturer Teaching Tridarma Level," CESS (Journal Comput. Eng. Syst. Sci., vol. 4, no. 2, pp. 2502-714, 2019.

E. Muningsih, I. Maryani, and V. R. Handayani, "Application of K-Means Method and Optimization of Number of Clusters with Davies Bouldin Index for Clustering Provinces Based on Village Potential," 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.

A. A. Syaifuddin and T. Al-Fiyah, "Implementation of Integrated Marketing Communication in Supporting Marketing and Brand Equity of BMT Mandiri Artha Sejahtera East Java," Juornal Econ. Policy ..., vol. 03, no. 02, pp. 37-51, 2022, [Online]. Available:

https://ejournal.uinsatu.ac.id/index.php/jesk/article/view/7126%0Ahttps://ejournal.uinsatu.ac.id/index.php/jesk/article/download/7126/2115.

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.

Y. Primawati, I. Verdian, and G. W. Nurcahyo, "K- Means Clustering on Based Classification Method of Sales Agent," J. Comput. Since Inf. Technol., vol. 7, no. 2, pp. 1-6, 2021, doi:

35134/jcsitech.v7i2.1.

P. Algorithm, C. Using, and A. Rapid, "In determining the level of customer satisfaction," vol. 0, no. 2, pp. 510-517, 2021.

M. A. Kadafi, "Evaluate the potential bankruptcy of Indonesian oil and gas mining companies in the 2013-2015 period," Forum Ekon., vol. 21, no. 2, pp. 154-164, 2019, [Online]. Available: http://journal.feb.unmul.ac.id/index.php/FORUMEKONOMI.

[R. Novendri, R. Andreswari, and ..., "Implementation of Data Mining to Predict Customer Churn Using Naive Bayes Algorithm," eProceedings ..., vol. 8, no. 2, pp. 2762-2773, 2021, [Online].

Available: https://openlibrarypublications.telkomuniversity.ac.id/index.php/engineering/article/download/146 78/14455 sdfdsfdsf.

N. L. Widyastuti and H. Nugroho, "The Impact of Covid-19 on the Oil and Gas Industry:

Policy Recommendations for Indonesia," J. Perenc. Pembang. Indonesia. J. Dev. Plan., vol. 4, no. 2, pp. 166-176, 2020, doi: 10.36574/jpp.v4i2.116dfdsfdsfdsf.

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.




DOI: https://doi.org/10.32736/sisfokom.v13i1.2030

Refbacks

  • There are currently no refbacks.


Indexed By:

 


Creative Commons License
Jurnal Sisfokom (Sistem Informasi dan Komputer) has ISSN 2301-7988 and e-ISSN 2581-0588 which is published by Lembaga Penelitian dan Pengabdian Masyarakat (LPPM) ISB Atma Luhur under a Creative Commons Attribution-ShareAlike 4.0 International License.
Web Analytics Made Easy - StatCounter