Grouping of Retail Items by Using K-Means Clustering

Kusrini Kusrini
DOI: https://doi.org/10.1016/j.procs.2015.12.131
2015-01-01
Procedia Computer Science
Abstract:Two main activities in retail business are to determine the amount of stock that should be maintained and the profit margin for each item. As the inventory principle stated, both processes required to make categories group of ‘fast moving’ and ‘slow moving’ and use it as the consideration for the processes. Citramart Minimarket as a retail business has not yet been used that grouping and consideration in their sales information system for processing their item's minimum stock level and profit margin. The process is still done manually by arbitrary observations from a stock division staff. The categories that is used to determine the minimum stock and profit margin are also not the moving speed of item but rather the kind of items.This study aim to support the process of determining the minimum stock and profit margin by building a model that can group items into categories ‘fast moving’ and slow moving’ using k-means clustering. K-means clustering is used in this study because the number of clusters required in categorization of items already set. The group cluster which has highest centroid will be the fast moving group, while the lowest centroid is the slow moving group. The data to be used in the research is taken from sales data for year 2014 and 2015. The clustering scenario uses combination of time, e.g. yearly and monthly, and variable, e.g. count of items and their transaction values. Using 3 clusters and delta value 0.2, the resulting best scenario is using yearly time and transaction value variable. The test is conducted by calculating the xie-beny index which results 36.265.
English Else
What problem does this paper attempt to address?