Application of data mining on inventory grouping using clustering method
DOI:
https://doi.org/10.35335/cit.Vol15.2023.608.pp228-239Keywords:
Clustering Method, Data Mining, Goods Inventory GroupingAbstract
Data mining in the business field is considered important, because the inventory system of goods in a store and what types of goods are the top priorities that must be stocked to anticipate the vacancy of goods, so that the store owner can find out the most sold items and the lack of stock items. The existence of daily sales transaction activities at Sahabat Komputer stores will produce a pile of data that is getting bigger and bigger, so that it can cause new problems. If this is allowed, the transaction data will become a pile of data that is detrimental because it requires an increasingly large storage media or database. One way to overcome this is to keep the availability of various types of continuous goods in the warehouse. To find out what items are purchased by consumers, the technique of analyzing the inventory of goods in the warehouse is carried out. Application of Clustering, helps in grouping data of the same characteristics into the same region. And from the whole it can be concluded that in cluster 1 the stock is available on average 1-100 pcs, the number of sales is 1-100 pcs and the sales volume per month is 1-100 units. In cluster 2 there is an average available stock of 101-200 pcs, 101-200 pcs sales quantity of 101-200 units, and monthly sales volume of 101-200 pcs. And in cluster 3 there is an average available stock of 301-400 pcs, the number sold is 401-500 pcs, and the monthly sales volume reaches 301-400 pcs.
Downloads
References
J. F. Kros, J. F. Kirchoff, and M. Falasca, “The impact of buyer-supplier relationship quality and information management on industrial vending machine benefits in the healthcare industry,” J. Purch. Supply Manag., vol. 25, no. 3, p. 100506, 2019.
W. C. Copacino, Supply chain management: The basics and beyond. Routledge, 2019.
K. Rubel, “Increasing the Efficiency and Effectiveness of Inventory Management by Optimizing Supply Chain through Enterprise Resource Planning Technology,” EFFLATOUNIA-Multidisciplinary J., vol. 5, no. 2, pp. 1739–1756, 2021.
E. Ramos, T. J. Pettit, M. Flanigan, L. Romero, and K. Huayta, “Inventory management model based on lean supply chain to increase the service level in a distributor of automotive sector,” Int. J. Supply Chain Manag, vol. 9, no. 2, pp. 113–131, 2020.
Y. Guo, N. Wang, Z.-Y. Xu, and K. Wu, “The internet of things-based decision support system for information processing in intelligent manufacturing using data mining technology,” Mech. Syst. Signal Process., vol. 142, p. 106630, 2020.
S. Teerasoponpong and A. Sopadang, “Decision support system for adaptive sourcing and inventory management in small-and medium-sized enterprises,” Robot. Comput. Integr. Manuf., vol. 73, p. 102226, 2022.
A. M. Ikotun, A. E. Ezugwu, L. Abualigah, B. Abuhaija, and J. Heming, “K-means clustering algorithms: A comprehensive review, variants analysis, and advances in the era of big data,” Inf. Sci. (Ny)., vol. 622, pp. 178–210, 2023.
Z. Fayyaz, M. Ebrahimian, D. Nawara, A. Ibrahim, and R. Kashef, “Recommendation systems: Algorithms, challenges, metrics, and business opportunities,” Appl. Sci., vol. 10, no. 21, p. 7748, 2020.
M. K. Gupta and P. Chandra, “A comprehensive survey of data mining,” Int. J. Inf. Technol., vol. 12, no. 4, pp. 1243–1257, 2020.
X. Liu, Y. Ding, H. Tang, and F. Xiao, “A data mining-based framework for the identification of daily electricity usage patterns and anomaly detection in building electricity consumption data,” Energy Build., vol. 231, p. 110601, 2021.
A. E. Ezugwu et al., “A comprehensive survey of clustering algorithms: State-of-the-art machine learning applications, taxonomy, challenges, and future research prospects,” Eng. Appl. Artif. Intell., vol. 110, p. 104743, 2022.
D. Antons, E. Grünwald, P. Cichy, and T. O. Salge, “The application of text mining methods in innovation research: current state, evolution patterns, and development priorities,” R&D Manag., vol. 50, no. 3, pp. 329–351, 2020.
M. Subramaniyan, A. Skoogh, A. S. Muhammad, J. Bokrantz, B. Johansson, and C. Roser, “A generic hierarchical clustering approach for detecting bottlenecks in manufacturing,” J. Manuf. Syst., vol. 55, pp. 143–158, 2020.
M. Z. Rodriguez et al., “Clustering algorithms: A comparative approach,” PLoS One, vol. 14, no. 1, p. e0210236, 2019.
P. Govender and V. Sivakumar, “Application of k-means and hierarchical clustering techniques for analysis of air pollution: A review (1980–2019),” Atmos. Pollut. Res., vol. 11, no. 1, pp. 40–56, 2020.
C. Bouveyron, G. Celeux, T. B. Murphy, and A. E. Raftery, Model-based clustering and classification for data science: with applications in R, vol. 50. Cambridge University Press, 2019.
H. Teichgraeber and A. R. Brandt, “Clustering methods to find representative periods for the optimization of energy systems: An initial framework and comparison,” Appl. Energy, vol. 239, pp. 1283–1293, 2019.
B. E. Jin and D. C. Shin, “Changing the game to compete: Innovations in the fashion retail industry from the disruptive business model,” Bus. Horiz., vol. 63, no. 3, pp. 301–311, 2020.
S. Verma and A. Gustafsson, “Investigating the emerging COVID-19 research trends in the field of business and management: A bibliometric analysis approach,” J. Bus. Res., vol. 118, pp. 253–261, 2020.
U. Awan, S. Shamim, Z. Khan, N. U. Zia, S. M. Shariq, and M. N. Khan, “Big data analytics capability and decision-making: The role of data-driven insight on circular economy performance,” Technol. Forecast. Soc. Change, vol. 168, p. 120766, 2021.
R. G. Richey Jr, S. Chowdhury, B. Davis?Sramek, M. Giannakis, and Y. K. Dwivedi, “Artificial intelligence in logistics and supply chain management: A primer and roadmap for research,” Journal of Business Logistics, vol. 44, no. 4. Wiley Online Library, pp. 532–549, 2023.
M. McMaster, C. Nettleton, C. Tom, B. Xu, C. Cao, and P. Qiao, “Risk management: Rethinking fashion supply chain management for multinational corporations in light of the COVID-19 outbreak,” J. Risk Financ. Manag., vol. 13, no. 8, p. 173, 2020.
J. Huber and H. Stuckenschmidt, “Daily retail demand forecasting using machine learning with emphasis on calendric special days,” Int. J. Forecast., vol. 36, no. 4, pp. 1420–1438, 2020.
G. D. Konstantakopoulos, S. P. Gayialis, and E. P. Kechagias, “Vehicle routing problem and related algorithms for logistics distribution: A literature review and classification,” Oper. Res., pp. 1–30, 2020.
M. Sinurat, M. Heikal, A. Simanjuntak, R. Siahaan, and R. N. Ilham, “Product Quality On Consumer Purchase Interest With Customer Satisfaction As A Variable Intervening In Black Online Store High Click Market: Case Study on Customers of the Tebing Tinggi Black Market Online Store,” Morfai J., vol. 1, no. 1, pp. 13–21, 2021.
N. H. Tien et al., “The formation and development of CRM system at Thien Hoa electronics supermarket in Vietnam,” Int. J. Res. Growth Eval., vol. 2, no. 4, pp. 752–760, 2021.
R. Buaton and M. K. Relita, “Metode Menyelesaikan Data Mining, Sistem Pakar dan Sistem Pendukung Keputusan,” Medan. STMIK KAPUTAMA, 15AD.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2023 Suci Ramadani, Syukri Hidayat, Ramahdanty Ramahdanty
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
