Application of the K-Means Algorithm to Segmentation of Consumer Interest in Silver Craft "Kreasi Slaka Bali"

2021 ◽  
Vol 9 (4) ◽  
pp. 541
Author(s):  
I Gusti Ayu Widiantari Putri ◽  
Ida Bagus Gede Dwidasmara
Keyword(s):  
Product Price ◽  
Number Of Clusters ◽  
Product Size ◽  
Transaction Data ◽  
Consumer Interest ◽  
Product Manufacturing ◽  
Level Of Difficulty ◽  
A Company ◽  
Material Preparation ◽  
Product Weight

Kreasi Slaka Bali is a company engaged in the silver handicraft sector. Each stage of the process is still done manually, starting from material preparation, handmade work, until making the packaging for delivery. Certainly, this requires more time to be able to produce an item of the same quality in each production. The need for extra time and business in product manufacturing, the company needs a marketing strategy that can be seen from consumer interest in the product. So this research discusses consumer interest based on transaction data by forming clusters based on purchases amount with other attributes, namely the product price, product size, product weight, and level of difficulty. The data used is transaction data for 2 transactions in 2019. The algorithm used is K-Means with the Elbow Method to determine the number of clusters. There are clusters of k = 5 with the cluster that has the most data in the first cluster (k = 0) with a total purchase of 193 products with an average price of US $ 69,554688.

scholarly journals Customer segmentation using bisecting k-means algorithm based on recency, frequency, and monetary (RFM) model

2019 ◽  
Vol 8 (2) ◽  
pp. 78-83
Author(s):  
Novianti Puspitasari ◽  
Joan Angelina Widians ◽  
Noval Bayu Setiawan
Keyword(s):  
Customer Loyalty ◽  
Customer Segmentation ◽  
Number Of Clusters ◽  
Transaction Data ◽  
Model Based ◽  
Silhouette Coefficient ◽  
Rfm Model ◽  
A Company ◽  
Coefficient Method

Information on customer loyalty characteristics in a company is needed to improve service to customers. A customer segmentation model based on transaction data can provide this information. This study used parameters from the recency, frequency, and monetary (RFM) model in determining customer segmentation and bisecting k-means algorithm to determine the number of clusters. The dataset used 588 sales transactions for PT Dinar Energi Utama in 2017. The clusters formed by the bisecting k-means and k-means algorithm were tested using the silhouette coefficient method. The bisecting k-means algorithm can form the best customer segmentation into three groups, namely Occasional, Typical, and Gold, with a silhouette coefficient of 0.58132.

Perancangan Strategi Penjualan Menggunakan Dinamika Sistem Pada CV. Gajah Mungkur

2020 ◽  
Vol 5 (4) ◽  
pp. 215
Author(s):  
Maulana Hassan Syafrudin ◽  
Nunung Nurhasanah
Keyword(s):  
Swot Analysis ◽  
Online Marketing ◽  
Dynamics Simulation ◽  
Scenario Simulation ◽  
Dynamic Approach ◽  
Product Price ◽  
Output Analysis ◽  
Uncertainty Factors ◽  
The Right ◽  
A Company

<p><em>Abstrak</em> – <strong>CV. Gajah Mungkur adalah salah satu perusahaan yang bergerak di bidang bordir kain. Perusahaan ini mengalami pasang surut penjualan produknya selama dua tahun terakhir. Untuk itu dalam penelitian ini menggunakan strategi seperti analisis SWOT sebagai pendekatan perusahaan menghadapi persaingan bisnis penjualan serta pendekatan dinamika sistem dalam memberikan rekomendasi terhadap keputusan atau kebijakan perusahaan terkait nilai omset penjualan dan nilai profit perusahan yang dipengaruhi oleh faktor ketidakpastian (uncertainty). Berdasarkan hasil pengolahan ANP dengan software Super Decisions, didapatkan bahwa alternatif strategi yang tepat bagi perusahaan CV. Gajah Mungkur untuk melanjutkan proses bisnisnya yang lebih baik adalah dengan cara memberikan promo diskon dan melakukan pemasaran secara online. Berdasarkan analisis output hasil simulasi skenario, bahwa bila perusahaan menerapkan skenario diskon harga produk sebesar 5% perusahaan akan mendapatkan penambahan jumlah penjualan sebanyak 139.258 unit. Kemudian bila perusahaan menerapkan skenario diskon produk sebesar 10% perusahaan akan mendapatkan penambahan jumlah penjualan sebanyak 151.918 unit. Selanjutnya adalah bila perusahaan menerapkan skenario diskon produk sebesar 15% perusahaan akan mendapatkan penambahan jumlah penjualan sebanyak 164.577 unit. Selain itu bila perusahaan menerapkan pemasaran secara online, bila perusahaan menerapkan promosi online salah satunya di online shop shopee maka perusahaan akan mendapatkan penambahan jumlah penjualan sebanyak 174.533 unit.</strong></p><p><em>Abstract</em> - <strong>CV. Gajah Mungkur is one of the companies engaged in fabric embroidery. This company has experienced ups and downs in the sales of its products as per the data for the last two years. For this reason, this study uses strategies such as SWOT analysis as a company approach to dealing with sales business competition as well as a system dynamic approach in providing recommendations on company decisions or policies related to the value of sales turnover and the value of company profits which are influenced by uncertainty factors. The results of this study are based on the results of ANP processing with Super Decisions, it was found that the right alternative strategy for CV. Gajah Mungkur, to continue its better business process, is by providing discount promos and marketing online. Based on the output analysis scenario simulation results, that if the company applies a 5% discount on product price scenarios, the company will get an additional sales volume of 139,258 units. Then if the company applies a product discount scenario of 10%, the company will get an additional sales number of 151,918 units. Furthermore, if the company applies a product discount scenario of 15%, the company will get an additional sales number of 164,577 units. Besides, if the company implements online marketing, if the company implements online promotions, one of which is the online shopee, the company will get an additional sales number of 174,533 unit.</strong></p><p><strong><em>Keywords - </em></strong><em>SWOT, ANP, System Dynamics Simulation</em><em>.</em></p>

scholarly journals SISTEM APLIKASI BERBASIS OPTIMASI METODE ELBOW UNTUK PENENTUAN CLUSTERING PELANGGAN

JOUTICA ◽  
2018 ◽  
Vol 3 (1) ◽  
pp. 117 ◽  
Author(s):  
Elly Muningsih ◽  
Sri Kiswati
Keyword(s):  
Data Center ◽  
Clustering Algorithm ◽  
Visual Basic ◽  
Customer Management ◽  
Number Of Clusters ◽  
Transaction Data ◽  
Development Method ◽  
Popular Method ◽  
Or Groups ◽  
Cluster 2

Customer is a very important asset for the company. Having customers who are loyal to the company is an absolute and important for the progress of the company. This study aims to help companies, especially in the online shop to create a better customer management by identifying and grouping customers into several clusters or groups to know the characteristics of their loyalty to the company. The method used in this research is K-Means method which is one of the best and most popular method in clustering algorithm. To overcome the weakness of the K-Means method in determining the number of clusters, we use the Elbow method where this method gets the comparison of the number of clusters added by calculating the SSE (Sum of Square Error) of each cluster value. This research starts from collecting the necessary data and will be processed. From total transaction data 478 then done cleaning of data and result 73 data. Then the data processed with RapidMiner software from Cluster 2 up to 10 to search the data center of each cluster. From the calculated SSE value found that the best number of clusters is 3. The end result of the research is a Visual Basic based application program that is expected to provide ease in grouping or clustering customers. Software development method using Waterfall method.

Analyzing a Potential Warranty Call Center Budget Overrun: Using Database Queries to Solve Business Problems

2005 ◽  
Vol 19 (1) ◽  
pp. 97-111 ◽  
Author(s):  
A. Faye Borthick ◽  
Donald R. Jones
Keyword(s):  
Call Center ◽  
Personal Computers ◽  
Database Queries ◽  
Transaction Data ◽  
Database Querying ◽  
Microsoft Access ◽  
Business Operations ◽  
Level Data ◽  
Warranty Service ◽  
A Company

In this case, students develop and use database queries to analyze possible causes of a potential budget overrun for telephone warranty service for a company that sells personal computers (PCs). Students query a Microsoft Access® database with tables for sales of PCs, estimates for technician time, employees, technician costs, and service minutes provided. The queries illustrate those that accountants could prepare to analyze transaction-level data to develop insights about business operations. Query-based approaches to analyzing transaction data are likely to become more common as businesses take advantage of the wealth of data available to them for solving business problems and exploiting emerging opportunities. This case is appropriate for students with rudimentary database querying proficiency, e.g., at the level developed by Borthick et al.'s (2001) case on assuring compliance for responses to website referrals.

scholarly journals Pemodelan Cluster Loyalitas Customer Menggunakan Algoritma K-Means Dengan Parameter LRIFMQ

Jurnal INFORM ◽  
2020 ◽  
Vol 5 (2) ◽  
pp. 54
Author(s):  
Aloysius Matz Teguh Utomo
Keyword(s):  
Calculated Data ◽  
Optimal Number ◽  
Customer Segmentation ◽  
Number Of Clusters ◽  
Silhouette Coefficient ◽  
Customer Lifetime ◽  
One Year ◽  
The Right ◽  
Hierarchy Process ◽  
A Company

Loyal customers are one of the factors that determine the development of a business. Therefore, businesses need a strategy to keep customers loyal, even making customers who were previously less loyal to become more loyal. The strategy used must be right on target according to customer segmentation. The purpose of this paper is to model a cluster of customer loyalty to help businesses in making the right decisions of marketing strategy. Segmentation is done using the k-means algorithm with LRIFMQ (length, recency, interval, frequency, monetary, quantity) as parameters, and the CLV (customer lifetime value) of each cluster is calculated. Data obtained from PT. XYZ (a company engaged in food processing) for one year (1 January 2019 - 31 December 2019), with 337.739 transactions, and 26.683 customers. AHP (analytical hierarchy process) method is used for LRIFMQ weighting because this method has a consistency index calculation. The silhouette coefficient is used to calculate the cluster quality and determine the optimal number of clusters. The best results are obtained with the silhouette coefficient value of 0,632904 with the number of clusters 6.

scholarly journals Using the Mathematical Model on Precision Marketing with Online Transaction Data Computing

2021 ◽  
Vol 2021 ◽  
pp. 1-7
Author(s):  
Jun Wu ◽  
Li Shi ◽  
Guangshu Xu ◽  
Yu-Hsi Yuan ◽  
Sang-Bing Tsai ◽  
...  
Keyword(s):  
Mathematical Model ◽  
Performance Comparison ◽  
Marketing Strategies ◽  
Transaction Data ◽  
Recommendation Algorithms ◽  
Decision Making System ◽  
Data Source ◽  
The Mathematical Model ◽  
A Company ◽  
Real World Problems

In this paper, a decision-making system for precision marketing is presented to deal with real-world problems based on real e-business data collected in a company in Beijing. During the data preprocessing, the authors conducted a cleaning course to make sure the data to be analyzed in the latter part of the paper were credential. Based on the processed data, the authors analyzed consumer purchasing behaviors using three classic recommendation algorithms and made a performance comparison of the three algorithms. At the end of this paper, the authors proposed a series of precision marketing strategies which had been adopted by the data source company and had been proved to be effective in improving the performance.

scholarly journals PERANCANGAN SISTEM INFORMASI DATABASE PEMBELIAN DAN PENJUALAN PRODUK PADA SHAVIRA PANCAKE BANDA ACEH

2020 ◽  
Vol 5 (2) ◽  
pp. 193-199
Author(s):  
Furqaan Putra ◽  
Rudy Fachruddin
Keyword(s):  
Data Collection ◽  
Qualitative Method ◽  
Application System ◽  
Transaction Data ◽  
Microsoft Access ◽  
Long Time ◽  
Speed Up ◽  
Manual Recording ◽  
A Company ◽  
Banda Aceh

Purchase and sales are things which often heard in a company. The use of manual recording results in a number of problems in the company. Seeing the results of purchases, sales and transaction data manually would take a long time. This study aims to design a database of purchases and sales information systems to help employees manage purchase and sale transactions easier, therefore reducing errors and speed up the proccess of transaction calculations. The system designed in this study uses Microsoft Access. This study uses descriptive qualitative method, data collection techniques was done by conducting interviews, observations, and literature studies carried out directly with the owner of the company. This study produces an application system that would ease future corporate activities.

scholarly journals Strengthening Competitiveness of Multinationals through Relocation of Production to Asia

2015 ◽  
Vol 11 (27) ◽  
pp. 99
Author(s):  
Daniel Feyerlein
Keyword(s):  
Strategic Management ◽  
Multinational Corporations ◽  
Research Study ◽  
Willingness To Accept ◽  
Local Production ◽  
Product Price ◽  
Delivery Costs ◽  
A Company ◽  
Made In

<p>This article asks whether a strategic opportunity exists for a company producing products with the label ‘Made in Germany’ to relocate production to Asia while retaining German engineering. This article focuses on the prevailing market situations of several multinational corporations based in Germany, which are encountering growing competition from Asia due to disadvantages in product price, delivery costs and transportation time that are related to a non-adapted and non-future oriented sourcing concept. Through an empirical research study, respondents from Asia were asked about their willingness to accept the price of a ‘Made in Germany’ product, the importance of price, their opinion about delivery issues, and their acceptance of local production in Asia. Total responses of N = 636 (100.0%) were collected, including n = 108 (17.0%) responses from Asia. The results are addressed to strategic management for German companies that can gain competitiveness through a relocation of production to Asia while considering long-term requirements. The results of the study suggest that the fundamental strategy of pairing German engineering with local production in Asia is worth pursuing in which the market conditions of tomorrow are considered.</p>

Prediksi Minat Konsumen Terhadap Produk Perusahaan Direcet Selling Tianshi Menggunakan Artificial Neural Network (ANN)

2020 ◽  
pp. 30-35
Author(s):  
Khairunnisa Samosir
Keyword(s):  
Neural Network ◽  
Artificial Neural Network ◽  
High Demand ◽  
Consumer Interest ◽  
Sales Data ◽  
Health Products ◽  
Artificial Neural ◽  
Artificial Neural Network Ann ◽  
A Company

Tiansi is a company that markets health products. This company has difficulty predicting people's interest in products that are in high demand. By knowing precisely the consumer interest in the product, it will increase sales. The research aims to predict consumer interest in Tiansi products appropriately. The method used is one of the Artificial Neural Network (ANN) techniques, namely Backpropagation with Momentum. The sales data tested were sourced from Stockist 319 Padang. The results of this research that can precisely determine consumer interest are architecture 5-2-1 and 5-3-1. So that this research is very helpful in the procurement of goods to increase the value of sales.

scholarly journals Communicating Eco-Friendly Benefits: Why Accidental Improvements May Be Better Received by Consumers

2016 ◽  
Vol 8 (1) ◽  
pp. 42-45
Author(s):  
George E. Newman ◽  
Ravi Dhar ◽  
Margarita Gorlin
Keyword(s):  
Fair Trade ◽  
Environmental Benefits ◽  
Social Benefits ◽  
Green Products ◽  
Market Segments ◽  
Basic Product ◽  
Consumer Interest ◽  
Environmental Improvements ◽  
A Company

Abstract Doing good does not necessarily imply doing well for a company. Ironically, in the case of green products it can even be quite the contrary. Deliberately enhancing a product with environmental benefits to make it more appealing may actually lead to a decrease in consumer interest because consumers suspect that quality was reduced on other dimensions. Even explicitly stating that the company cares about both the environment and quality is not sufficient to overcome consumers’ skepticism, according to our experiments. Fortunately, there are ways to communicate environmental improvements successfully. Companies improving a basic product feature like making something more eco-friendly should either position the improvement as unintended or emphasize that the primary goal is improving the quality of the product. Focusing on eco-conscious market segments also helps to avoid harm and might even be beneficial. Improvements on dimensions that are not inherent to a product’s composition, like fair trade or other social benefits, turned out to be less critical in the experiments.

Sign in / Sign up

Export Citation Format

Share Document