Association Rules Mining for Designing Product Bundling Strategy (Study Case at a Cafe in Jakarta)
DOI:
https://doi.org/10.31334/logistik.v7i2.3466Keywords:
Data Mining, Association Rules, Apriori Algorithm, Customer Relationship Management, Product Bundling,Abstract
Cafe X is a modern and prominent coffee shop in town that sells specialty beverage products with a total of 73 variations. Sales transactions that occurred in March 2021 at that Cafe reached an average of 300 times per day. All this time, the transaction data is only used to calculate inventory replenishment and to observe sales profits whereas it can actually be utilized to reveal information related to customer behavior in buying products by finding the association or pattern between product sales. The purpose of this study is to obtain association models between items that can be used as a base to arrange recommendations for selling beverage products at Cafe X using a data mining method, namely the association rules with the Apriori algorithm. The transaction data specified for data processing are payment transactions of a total of 3,100 data records. From the analysis results, it is known that there are 8 product association rules that meet the minimum support of 0.01 and the minimum confidence of 0.5, which means that these rules can be used as an alternative basis for determining business strategy at Cafe X. Based on the association information between products, the customer relationship management (CRM) strategy that can be applied at Cafe X is the promotion strategy of product bundling. From a number of recommended bundled products, it is found that there are opportunities to increase sales for four products, they are MD001, TH002, LB001, and TU001.References
Sub Direktorat Statistik Tanaman Perkebunan, Statistik Kopi Indonesia 2019. Badan Pusat Statistik Indonesia, 2019.
United States Of Department, “Coffee: World Markets and Trade,†Foreign Agric. Serv. Off. Glob. Anal., 2019, [Online]. Available: http://www.fas.usda.gov/htp/coffee/2009/December_2009/2009_coffee_december.pdf.
Kementrian Perindustrian Republik Indonesia, Peluang Usaha IKM Kopi. Jakarta: Kementerian Perindustrian Republik Indonesia, 2017.
Toffin, “Riset Toffin,†tofin.id, 2020. https://toffin.id/riset-toffin/#:~:text=Hasil riset Toffin bersama Majalah,2016 yang hanya sekitar 1.000. (accessed Apr. 22, 2021).
Gobiz, “5 Tips dan Strategi Meningkatkan Penjualan Usaha Anda,†2021. https://gobiz.co.id/pusat-pengetahuan/strategi-penjualan/.
A. Carissa, “Penerapan Customer Relationship Management (CRM) Sebagai Upaya untuk Meningkatkan Loyalitas pelanggan (Studi Kasus pada Bandung Sport Distro Malang),†J. Adm. Bisnis S1 Univ. Brawijaya, vol. 15, no. 1, p. 84471, 2014.
F. Buttle and S. Maklan, Customer Relationship Management, 3rd ed. 2 Park Square, Milton Park, Abingdon, Oxon OX14 4RN: Routledge, 2015.
M. K. Kang, “Market Basket Analysis: Identify the changing trends of market data,†Procedia Comput., pp. 78–85, 2016.
M. SyahruRomadhon and A. Kodar, “Implementasi Metode Market Basket Analysis (Mba) Menggunakan Algoritma Apriori Dalam Transaksi Penjualan (Studi Kasus: Kafe Ruang Temu),†J. SAINTEKOM, vol. 10, no. 2, p. 138, 2020, doi: 10.33020/saintekom.v10i2.137.
M. F. Mulya, N. Rismawati, and A. R. Rizky, “Analisis dan Implementasi Data Mining Menggunakan Algoritma Apriori untuk Meningkatkan Penjualan pada Kantin Universitas Tanri Abeng,†Fakt. Exacta, vol. 12, no. 3, pp. 210–218, 2019, doi: 10.30998/faktorexacta.v12i3.4541.
Informatika, “Data Mining Untuk Permasalahan Bisnis dan Keuangan,†FTI UNSERA, 2017. http://informatika.fti-unsera.id.
F. Nurchalifatun, “Penerapan Metode Asosiasi Data Mining Menggunakan Algortima Apriori untuk Mengetahui Kombinasi antar Itemset pada Pondok Kopi,†Data Min., 2017.
D. Anderson, “How Customized Data Mining Benefits Your Business,†2018. https://www.dataversity.net/ (accessed Jul. 29, 2021).
N. Wardani, Penerapan Data Mining Dalam Analytic CRM, no. May. 2020.
S. Li, “A Gentle Introduction on Market Basket Analysis — Association Rules,†towardsdatascience, 2017. https://towardsdatascience.com/ (accessed Jul. 20, 2021).
Bavarsad, “Studying the Factors Affecting the Customer Relations Management (CRM) in Maroon Petrochemical Company,†Interdiscip. J. Contemp. Res. Bus., 2013.
C. Zhang and S. Zhang, Association Rule Mining: Models and Algorithms. Berlin: Springer, 2002.
A. Maheshwari, Data Analytics. Chennai: McGraw Hill Education (India) Private Limited, 2017.
Downloads
Published
Issue
Section
License
Please find the rights and licenses in Jurnal Logistik Indonesia. By submitting the article/manuscript of the article, the author(s) agree with this policy. No specific document sign-off is required.
1. License
The non-commercial use of the article will be governed by the Creative Commons Attribution license as currently displayed on Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License
2. Author(s)' Warranties
The author warrants that the article is original, written by stated author(s), has not been published before, contains no unlawful statements, does not infringe the rights of others, is subject to copyright that is vested exclusively in the author and free of any third party rights, and that any necessary written permissions to quote from other sources have been obtained by the author(s).
3. User Rights
Jurnal Logistik Indonesia spirit is to disseminate articles published are as free as possible. Under the Creative Commons license, Jurnal Logistik Indonesia permits users to copy, distribute, display, and perform the work for non-commercial purposes only. Users will also need to attribute authors and Jurnal Logistik Indonesia on distributing works in the journal and other media of publications.
4. Co-Authorship
If the article was jointly prepared by more than one author, any authors submitting the manuscript warrants that he/she has been authorized by all co-authors to be agreed on this copyright and license notice (agreement) on their behalf, and agrees to inform his/her co-authors of the terms of this policy. Jurnal Logistik Indonesia will not be held liable for anything that may arise due to the author(s) internal dispute. Jurnal Logistik Indonesia will only communicate with the corresponding author.
5. Miscellaneous
Jurnal Logistik Indonesia will publish the article (or have it published) in the journal if the article’s editorial process is successfully completed. Jurnal Logistik Indonesia editors may modify the article to a style of punctuation, spelling, capitalization, referencing and usage that deems appropriate. The author acknowledges that the article may be published so that it will be publicly accessible and such access will be free of charge for the readers as mentioned in point 3.
Every accepted manuscript should be accompanied by "Copyright Transfer Agreement" prior to the article publication.
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
