Designing Customer Target Recommendation System Using K-Means Clustering Method

UD Swiss is a company engaged in the field of goods distribution located in Cirebon. In achieving sales targets, customer marketing department sets customer targets to be visited based on the type and location of outlets. However, the method of targeting customers does not achieve the sales target yet due to the differences in the characteristics of purchases per product category for each type of outlet. The research in this paper focuses on the analysis and implementation of management information system to help the company gain knowledge in targeting customers based on the profile and characteristics of each customer group in doing transactions. The information system is made to load each of the knowledge generated by the analysis of customers’ characteristic using the k-means clustering. The system is designed to use the programming language “Groovy and Grails” and is built using the .NET Framework that can run on the Java platform with support of PostgreSQL as a database. Grouping customers using k-means clustering method generates groups of potential customers who are considered to be the target in the process of product sales. Customers who have an average purchase at least Rp 2,028,813.00 per transaction with the minimum purchase frequency of 25 transactions a year is a potential customer.

Download Full-text

IMPLEMENTASI ALGORITMA K-MEANS UNTUK PEMILIHAN KERAMIK DAN PELANGGAN POTENSIAL PADA CV. JAYA TUNGGAL KERAMIK

Jurnal Algoritma, Logika dan Komputasi ◽

10.30813/j-alu.v3i2.2157 ◽

2020 ◽

Vol 3 (2) ◽

Author(s):

Yuliana Yuliana ◽

Mario Richie ◽

Halim Agung

Keyword(s):

Cluster Center ◽

Test Results ◽

Inventory Data ◽

Clustering Method ◽

Regular Customer ◽

Using Data ◽

Iterative Partitioning ◽

A Company ◽

Potential Customers

CV. Jaya Tunggal Keramik is a company that sale of ceramics. CV. Jaya Tunggal Keramik experienced some problems regarding ceramics and customers such as difficulties in sale ceramics to customers so that some ceramic products accumulate in the warehouse, such as being damaged and ceramic display becomes less good because it is stored too long and difficulty retaining customers because some customers do not want to order ceramic products. Lack of precise decision taken by the management CV. Jaya Tunggal Keramik in determining the strategy to supply ceramic and how to make it CV. Jaya Tunggal Keramik is difficult to estimate the stock of ceramic products to be provided and it is difficult to determine which potential customers can be maintained as a regular customer. This research uses K-Means algorithm. K-Means algorithm is a partitioning clustering method that separates data into different groups with iterative partitioning. By using this application, users can find out the estimated stock and price of ceramics as well as information about potential customers. Testing in this research using data of November 2017 that compared with data of December 2017. Based on ceramic data test results, there are some ceramics that are not in accordance with the predicted results so it can be concluded that the K-Means algorithm on the test inventory data inventory in this study is not fully can provide accurate estimates, this is because the use of the K-Means algorithm is strongly influenced by the cluster center results and the attributes used.

Download Full-text

ANALISIS PERANCANGAN APLIKASI SISTEM INFORMASI E-MCARD BERBASIS ANDROID PADA PT. XYZ

Rang Teknik Journal ◽

10.31869/rtj.v2i1.1107 ◽

2019 ◽

Vol 2 (1) ◽

Author(s):

Meritha Indah Sari ◽

Danny Yudin Djahidin

Keyword(s):

Information Technology ◽

Information System ◽

Data Processing ◽

Pharmaceutical Company ◽

Marketing Department ◽

Analysis Process ◽

A Company ◽

Role Of Information ◽

Analyze Data

PT. XYZ is a local Indonesian pharmaceutical company that is currently developing,where in the development of a company the role of Information Technology is very important along with the very rapid development.PT. XYZ in the application of Information Technology data processing is quite good and has an information system that can be used to analyze data. But there are still problems in the process of making a report about a Marketing employees visit that affects the salaries and incentives of the Marketing department.The purpose of this study is to be able to measure the process of achieving the target of visits given by the Company to each of the Marketing Department Employees,product promotion to doctors, and help monitor sales targets, where researchers use the SWOT and Fishbone Analysis Methods in the analysis process. Keywords: Analisis, Perancangan, Android, SWOT, Fishbone

Download Full-text

RANCANGAN SISTEM INFORMASI E-COMMERCE UNTUK USAHA FASHION BOUNTYCLOTHING PADA CV. AI

JUMINTEN ◽

10.33005/juminten.v1i4.137 ◽

2020 ◽

Vol 1 (4) ◽

pp. 24-36

Author(s):

Ari Prasetyo Wibowo ◽

Sumiati Sumiati ◽

Dwi Sukma Donoriyanto

Keyword(s):

Economic Growth ◽

Information System ◽

Young People ◽

Current System ◽

Global Market ◽

The Internet ◽

Customer Support ◽

Product Sales ◽

A Company ◽

People Today

Pertumbuhan ekonomi berkembang semakin pesat sejak dimulainya pasar global. Setiap pengusaha bersaing dalam mengembangkan usahanya masing-masing. Dalam era globalisasi saat ini banyak pengusaha yang telah menerapakan penjualan dengan menggunakan intenet. E-commerce adalah bagian dari E-busniess yang berhubungan dengan kegiatan jual-beli barang/jasa melalui internet. E-commerce juga meliputi aktivitas yang mendukung transaksi tersebut, seperti periklanan, pemasaran, dukungan konsumen, keamanan, pengiriman, dan pembayaran. CV. AI adalah perusahaan yang bergerak dalam produksi pakaian, seperti kemeja , jacket, dan lainnya yang menunjang fashion anak muda jaman sekarang. Sistem penjual dan pemasaran produk yang berjalan saat ini dengan mengikuti pameran, cara ini masih dirasakan kurang optimal. Tujuan dalam penelitian ini adalah untuk merancang system informasi penjualan produk berbasis aplikasi. CV. AI menginginkan dalam mengembangkan usahanya memiliki media jual – beli yang tidak terhalang jarak, waktu dan mempermudah melakukan pembelian. Economic growth is growing more rapidly since the start of the global market. Every entrepreneur competes in developing their respective businesses. In the current era of globalization, many entrepreneurs have applied sales using the internet. E-commerce is part of E-business related to the sale and purchase of goods / services via the internet. E-commerce also includes activities that support these transactions, such as advertising, marketing, customer support, security, shipping, and payment. CV. AI is a company engaged in the production of clothing, such as shirts, jackets, and others that support the fashion of young people today. The current system of selling and marketing products by participating in exhibitions is still not optimal. The purpose of this research is to design an application-based product sales information system. CV AI wants to develop its business to have a buying and selling media that is not blocked by distance, time and makes it easier to make purchases.

Download Full-text

Implementation of Booking Performance Application Using Bootstrap Case Study in PT XYZ

REMIK (Riset dan E-Jurnal Manajemen Informatika Komputer) ◽

10.33395/remik.v4i1.10206 ◽

2019 ◽

Vol 4 (1) ◽

pp. 10

Author(s):

Arfan Sansprayada ◽

Kartika Mariskhana

Keyword(s):

Information System ◽

Business Processes ◽

System Development ◽

Basic Requirement ◽

Application Development ◽

Information System Development ◽

Special Expertise ◽

A Company ◽

Need For Information

Abstract—The need for information system development in a company is a basic requirement that must be met by each company in order to run its business processes properly. This is the basic key in a company in order to provide maximum results to find as many profits or profits. Application development or requirements in the application also provide speed for employees to carry out their activities to work properly and optimally. The development of the era requires that companies must be productive and have innovations so that the business wheel of the company can run well. This is based on the development of technology that is so fast that it requires special expertise in its application. This research is expected to be able to help some problems that exist in a company. Where its application can make it easier for employees to carry out their respective duties and roles in order to maximize their potential. For companies, the application of this application can accommodate the company's business wheels so that they can be properly and correctly documented . Keywords : Systems, Information, Applications

Download Full-text

Sistem Informasi Pelayanan Jasa pada Lucky Photo

Jurnal Teknologi dan Informasi ◽

10.34010/jati.v11i1.4225 ◽

2021 ◽

Vol 11 (1) ◽

pp. 81-95

Author(s):

T Pradita ◽

A Mubarok

Keyword(s):

Information System ◽

Customer Service ◽

Service System ◽

The Internet ◽

Application System ◽

Web Based ◽

Customer Data ◽

Service Information ◽

Internet Media ◽

A Company

The development of services has developed into the internet media, to make it easier for customers and employees in managing a job. In the problem of Lucky Photo, which covers services including printing, sales, stock of goods, purchases, and reports are not effective properly. The researcher aims to develop a service system entitled Service Information Systems at Lucky Photo. By building a web-based application, a waterfall method is needed to become a benchmark for the creation of a service information system, so the results will be obtained on a web-based application system to demand progress in a company, including services that become easier, easier customer service in conduct transactions, generate reports, and process customer data. So it can be concluded that with the construction of a new Service Information System it will be easier to make transactions, make it easier for customers, create reports, and process customer data that is embedded in the Mysql database which will become a well-systemized report.

Download Full-text

Rancang Bangun Sistem Informasi Penjualan Obat Berbasis Website dengan Menggunakan Metode Waterfall

Indonesian Journal on Software Engineering (IJSE) ◽

10.31294/ijse.v6i1.7911 ◽

2020 ◽

Vol 6 (1) ◽

pp. 71-82

Author(s):

Ahmad Fauzi ◽

Dewi Wulandari

Keyword(s):

Information System ◽

Data Processing ◽

Quality Of Data ◽

Microsoft Excel ◽

Web Based ◽

Drug Sales ◽

Uml Modeling ◽

Computer Based ◽

A Company

Abstract: In this era of globalization, information technology is speeding up. In managing the information required good technology because the information has a greatvalue for a company. And computer technology today with its increasingly sophisticated processing speed has enabled the development of computer-based information systems. Problems that exist in Kauman Apothecary is about the data processing that is still done manually, ranging from the admission process of incoming drugs, drugs out, often the absence of matching stock between the data with the original drug, as well as in making reports that still use microsoft excel. The design of the system is described by UML modeling, drug sales information system on web-based pharmacy kauman intranet this is the best solution, can improve the quality of data processing drugs in pharmacies kauman. And with the creation of this information system, can help simplify data processing moreleverage, while keeping data safe and minimize the data kerangkapan. The design of web-based drug sales information system is made using PHP and MySQL.Keywords: Information System, Sales, Kauman PharmacyAbstrak: Dalam era globalisasi sekarang ini, teknologi informasi melaju dengan cepatnya.Dalam mengelola informasi dibutuhkan teknologi yang baik karena informasi mempunyai nilai yang besar bagi suatu perusahaan. Dan teknologi komputer sekarang ini dengan kecepatan prosesnya yang semakin canggih telah memungkinkan pengembangan sistem informasi berbasis komputer. Masalah yang ada pada Apotek Kauman yaitu mengenai pengolahan data-datanya yang masih dilakukan secara manual, mulai dari proses penerimaan obat masuk, obat keluar, sering tidak adanya kecocokan stok antara data dengan obat aslinya, serta dalam membuat laporan yang masih menggunakan microsoft excel. Perancangan sistem digambarkan dengan pemodelan UML, sistem informasi penjualan obat pada apotek kauman berbasis web intranet ini merupakan solusi yang terbaik, dapat meningkatkan kualitas pengolahan data obat di apotek kauman. Dan dengan dibuatnya sistem informasi ini, dapat membantu mempermudah pengolahan data lebih maksimal, sekaligus menjaga data tetap aman dan meminimalisir adanya kerangkapan data. Perancangan sistem informasi penjualan obat berbasis web ini dibuat menggunakan PHP dan MySQLKata Kunci: Sistem Informasi, Penjualan, Apotek Kauman.

Download Full-text

ANALISIS PENERAPAN SISTEM INFORMASI MANAJEMEN PADA TOKO HAI BABY SHOP DI KABUPATEN TULUNGAGUNG

10.31219/osf.io/gq5vm ◽

2021 ◽

Author(s):

Eriko Febriansyah ◽

Andara Muhlisidina ◽

Febby Nilam sari

Keyword(s):

Information System ◽

Management Information System ◽

Financial Data ◽

Data Sources ◽

Primary Data ◽

Management Information ◽

Procedure Guidelines ◽

Library Studies ◽

A Company

The research aims to know the application of the Management Information System used in the management of financial data to be more effective for the long-term continuity in the Pratama’s Baby Shop store. In an enterprise the revenue and expense cycles are important, for economic growth can be seen from both cycles. Baby Shop Hai stores is a company that movesin to buy baby things. The method of data collection used is with observation, and library studies. The data sources used are the primary data of the general images of the company, the corporate documents, transaction evidence, company procedure guidelines on the Management information system income and expenses. Studies indicate that sales operations still have a few flaws and that improvements should be made especially to running systems.

Download Full-text

Strategies of SMM Management, Comparison of Instagram and Facebook Social Networks

Nile Journal of Business and Economics ◽

10.20321/nilejbe.v3i5.90 ◽

2017 ◽

Vol 3 (5) ◽

pp. 51

Author(s):

Ramis Akhmedov

Keyword(s):

Social Networks ◽

Social Media ◽

Customer Relationship ◽

Social Media Marketing ◽

Crm System ◽

Research Questions ◽

Short Time ◽

A Company ◽

Potential Customers ◽

The Ideal

SMM occupies an important role in the lives of people and so many people are represented in social networks, it provides the ideal platform for companies so they can communicate with their current and potential customers. This study continues to explore how companies can use social media marketing to build and maintain relationships with customers. This investigates through conducted research questions. How SMM is effective in terms of CRM? Can Facebook replace CRM system? Why do people choose to follow a company on Instagram? To analyze more clearly the focus will be on Instagram and Facebook applications, which in a short time acquired great popularity among private users as well as among the companies. The purpose of this study is to indicate the integration of customer relationship management (CRM) with social media marketing (SMM) strategies, and defines its benefits for business.

Download Full-text

KOMPARASI METODE CLUSTERING K-MEANS DAN K-MEDOIDS DENGAN MODEL FUZZY RFM UNTUK PENGELOMPOKAN PELANGGAN

Evolusi : Jurnal Sains dan Manajemen ◽

10.31294/evolusi.v6i2.4600 ◽

2018 ◽

Vol 6 (2) ◽

Author(s):

Elly Muningsih - AMIK BSI Yogyakarta

Keyword(s):

Data Clustering ◽

Small Data ◽

Clustering Methods ◽

Monetary Model ◽

Clustering Method ◽

Online Sales ◽

Rfm Model ◽

Potential Customers ◽

Cluster 2 ◽

Better Than

Abstract ~ The K-Means method is one of the clustering methods that is widely used in data clustering research. While the K-Medoids method is an efficient method used for processing small data. This study aims to compare two clustering methods by grouping customers into 3 clusters according to their characteristics, namely very potential (loyal) customers, potential customers and non potential customers. The method used in this study is the K-Means clustering method and the K-Medoids method. The data used is online sales transaction. The clustering method testing is done by using a Fuzzy RFM (Recency, Frequenty and Monetary) model where the average (mean) of the third value is taken. From the data testing is known that the K-Means method is better than the K-Medoids method with an accuracy value of 90.47%. Whereas from the data processing carried out is known that cluster 1 has 16 members (customers), cluster 2 has 11 members and cluster 3 has 15 members. Keywords : clustering, K-Means method, K-Medoids method, customer, Fuzzy RFM model. Abstrak ~ Metode K-Means merupakan salah satu metode clustering yang banyak digunakan dalam penelitian pengelompokan data. Sedangkan metode K-Medoids merupakan metode yang efisien digunakan untuk pengolahan data yang kecil. Penelitian ini bertujuan untuk membandingkan atau mengkomparasi dua metode clustering dengan cara mengelompokkan pelanggan menjadi 3 cluster sesuai dengan karakteristiknya, yaitu pelanggan sangat potensial (loyal), pelanggan potensial dan pelanggan kurang (tidak) potensial. Metode yang digunakan dalam penelitian ini adalah metode clustering K-Means dan metode K-Medoids. Data yang digunakan adalah data transaksi penjualan online. Pengujian metode clustering yang dilakukan adalah dengan menggunakan model Fuzzy RFM (Recency, Frequenty dan Monetary) dimana diambil rata-rata (mean) dari nilai ketiga tersebut. Dari pengujian data diketahui bahwa metode K-Means lebih baik dari metode K-Medoids dengan nilai akurasi 90,47%. Sedangkan dari pengolahan data yang dilakukan diketahui bahwa cluster 1 memiliki 16 anggota (pelanggan), cluster 2 memiliki 11 anggota dan cluster 3 memiliki 15 anggota. Kata kunci : clustering, metode K-Means, metode K-Medoids, pelanggan, model Fuzzy RFM.

Download Full-text

Perancangan Sistem Informasi Monitoring Persediaan Bahan Kimia dengan Pendekatan Persediaan Continuous Review (Studi Kasus: Departemen Printing-Dyeing PT Kusumahadi Santosa)

PERFORMA Media Ilmiah Teknik Industri ◽

10.20961/performa.14.2.11038 ◽

2015 ◽

Vol 14 (2) ◽

Author(s):

Ikhsan Aditama ◽

Yusuf Priyandari ◽

Wakhid Ahmad Jauhari

Keyword(s):

Information System ◽

Textile Industry ◽

Process Management ◽

Web Applications ◽

Inventory Model ◽

System Management ◽

Functional Requirements ◽

Information Systems Management ◽

Continuous Review ◽

A Company

PT Kusumahadi Santosa is a company engaged in manufacturing, the textile industry. One of the major processes that occurs within the company is printing process where types of chemicals that are used are more than 250 different types. However, in conducting the management of chemical inventories, the company still use the manual process which has not been computerized. As a result, there are some problem occurs, such as miscalculation of 5%-30% in the process of recording the amount of chemicals, process of discharging chemicals not recorded, control and planning of chemical inventories is not optimum that will indirectly result in losses company. Therefore, it is necessary to design information system management inventory for controlling chemical inventories. Information system management is designed in the form of web applications and integrated with continuous review inventory model. In addition, the system is equipped with functional and non-functional requirements to fix of the previous system. By adopting the proposed information systems management, the process management of chemicals can be managed more effectively and efficiently. The proposed information system which integrated the system with continuous review inventory model can be adopted by the company for managing the inventories and reducing the inventory cost.

Download Full-text