Comparative Analysis of Multicriteria Inventory Classification and Forecasing: A Case Study in PT XYZ
|
Keywords:
Inventory Management, Small and Medium-sized Enterprise, Technique for Order Preference by Similarity to Ideal Soluti, ARIMA, LSTM
AbstractOne crucial aspect of supply chain management is inventory management. Inefficient inventory management can lead to various issues, such as product expiration, where a high number of items in the warehouse either have expired or are approaching expiration. This issue is experienced by a distribution SME in Indonesia, PT XYZ. Without such classifications, it becomes challenging to predict demand and manage stock levels efficiently. Therefore, the aim of this study is to classify inventory to identify the most important items to business and make a forecasting model of sales quantity to predict inventory replenishment using machine learning algorithms. To advance our research, we adopted the Cross Industry Standard Process for Data Mining (CRISP-DM) methodology. For inventory classification, we conducted a hybrid approach that combined TOPSIS (Technique for Order Preference by Similarity to Ideal Solution) and ABC analysis (A: high-value items, B: medium-value items, and C: low-value items). The data employed in this study comprised secondary data, including purchase orders, sales orders, and stock movement records. The result reveals that 11 of the total 383 items under class A are important items for business. After obtaining labels from the ABC Analysis, we proceed to train models using KNN, SVC, and Random Forest for predicting inventory classification. Notably, the Random Forest model showcased remarkable performance and outperformed the rest of the models, achieving an accuracy of 99.21%. For inventory forecasting ARIMA displays a competitive performance with RMSE value 5.305 and MAE value 3.476, indicating a relatively accurate prediction with lower forecasting errors than two other modelsDownloads
Download data is not yet available.
ReferencesWisetsri, W., Donthu, S., Mehbodniya, A., Vyas, S., Quiñonez-Choquecota, J., & Neware, R. (2022). An investigation on the impact of digital revolution and machine learning in supply chain management. Materials Today: Proceedings, 56, 3207-3210. https://doi.org/10.1016/j.matpr.2021.09.367 Boute, R. N., Gijsbrechts, J., Van Jaarsveld, W., & Vanvuchelen, N. (2022). Deep reinforcement learning for inventory control: A roadmap. European Journal of Operational Research, 298(2), 401-412. https://doi.org/10.1016/j.ejor.2021.07.016 Harifi, S., Khalilian, M., Mohammadzadeh, J., & Ebrahimnejad, S. (2021). Optimization in solving inventory control problem using nature inspired Emperor Penguins Colony algorithm. Journal of Intelligent Manufacturing, 32, 1361-1375. https://doi.org/10.1007/s10845-020-01616-8 Wang, Z., & Mersereau, A. J. (2017). Bayesian inventory management with potential change‐points in demand. Production and Operations Management, 26(2), 341-359. https://doi.org/10.1111/poms.12650 Islam, S. S., Pulungan, A. H., & Rochim, A. (2019, December). Inventory management efficiency analysis: A case study of an SME company. In Journal of Physics: Conference Series (Vol. 1402, No. 2, p. 022040). IOP Publishing. https://doi.org/10.1088/1742-6596/1402/2/022040 Munyaka, J. B., & Yadavalli, V. S. S. (2022). Inventory management concepts and implementations: a systematic review. South African Journal of Industrial Engineering, 33(2), 15-36. https://doi.org/10.7166/33-2-2527 Teplická, K., & Čulková, K. (2020). Using of optimizing methods in inventory management of the company. Acta logistica, 7(1), 9-16. https://doi.org/10.22306/al.v7i1.150 Hartley, J. L., & Sawaya, W. J. (2019). Tortoise, not the hare: Digital transformation of supply chain business processes. Business Horizons, 62(6), 707-715. https://doi.org/10.1016/j.bushor.2019.07.006 Wirth, R., & Hipp, J. (2000, April). CRISP-DM: Towards a standard process model for data mining. In Proceedings of the 4th international conference on the practical applications of knowledge discovery and data mining (Vol. 1, pp. 29-39). Brzozowska, J., Pizoń, J., Baytikenova, G., Gola, A., Zakimova, A., & Piotrowska, K. (2023). Data engineering in CRISP-DM process production data–case study. Applied Computer Science, 19(3). https://doi.org/10.35784/acs-2023-26 El-Morr, C., Jammal, M., Ali-Hassan, H., & El-Hallak, W. (2022). Machine Learning for Practical Decision Making. International Series in Operations Research and Management Science. https://doi.org/10.1007/978-3-031-16990-8_4 Pohl, M., Haertel, C., Staegemann, D., & Turowski, K. (2023). The Linkage to Business Goals in Data Science Projects. Retrieved from https://aisel.aisnet.org/acis2023/60/ Ramadhan, Z. I., & Widiputra, H. (2024). Comparative Analysis of Recurrent Neural Network Models Performance in Predicting Bitcoin Prices. Jurnal RESTI (Rekayasa Sistem dan Teknologi Informasi), 8(3), 377-388. https://doi.org/10.29207/resti.v8i3.5810 Papathanasiou, J., Ploskas, N., Papathanasiou, J., & Ploskas, N. (2018). Topsis (pp. 1-30). Springer International Publishing. https://doi.org/10.1007/978-3-319-91648-4_1 Chakraborty, S. (2022). TOPSIS and Modified TOPSIS: A comparative analysis. Decision Analytics Journal, 2, 100021. https://doi.org/10.1016/j.dajour.2021.100021 Hwang, C.-L., & Yoon, K. (1981). Multiple Attribute Decision Making. In Lecture Notes in Economics and Mathematical Systems. Springer Berlin Heidelberg. https://doi.org/10.1007/978-3-642-48318-9 Cortes, C. (1995). Support-Vector Networks. Machine Learning Cheng, D., Zhang, S., Deng, Z., Zhu, Y., & Zong, M. (2014). k NN algorithm with data-driven k value. In Advanced Data Mining and Applications: 10th International Conference, ADMA 2014, Guilin, China, December 19-21, 2014. Proceedings 10 (pp. 499-512). Springer International Publishing. https://doi.org/10.1007/978-3-319-14717-8_39 Breiman, L. (2001). Random forests. Machine learning, 45, 5-32. Zhang, J., Liu, H., Bai, W., & Li, X. (2024). A hybrid approach of wavelet transform, ARIMA and LSTM model for the share price index futures forecasting. The North American Journal of Economics and Finance, 69, 102022. https://doi.org/10.1016/j.najef.2023.102022 Zaini, N., Ahmed, A. N., Ean, L. W., Chow, M. F., & Malek, M. A. (2023). Forecasting of fine particulate matter based on LSTM and optimization algorithm. Journal of Cleaner Production, 427, 139233. https://doi.org/10.1016/j.jclepro.2023.139233 Chai, T., & Draxler, R. R. (2014). Root mean square error (RMSE) or mean absolute error (MAE)?–Arguments against avoiding RMSE in the literature. Geoscientific model development, 7(3), 1247-1250. https://doi.org/10.5194/gmd-7-1247-2014 Garcia-Arteaga, J., Zambrano-Zambrano, J., Parraga-Alava, J., & Rodas-Silva, J. (2024). An effective approach for identifying keywords as high-quality filters to get emergency-implicated Twitter Spanish data. Computer Speech & Language, 84, 101579. https://doi.org/10.1016/j.csl.2023.101579 Greenland, A. (2021). Deployment and Life Cycle Management. In INFORMS Analytics Body of Knowledge (pp. 275-310). INFORMS. https://doi.org/10.1002/9781119505914.ch8 Shekhovtsov, A., & Kołodziejczyk, J. (2020). Do distance-based multi-criteria decision analysis methods create similar rankings?. Procedia Computer Science, 176, 3718-3729. https://doi.org/10.1016/j.procs.2020.09.015 |
Published
2024-12-31
Section
Articles
How to Cite
Purwandaru, D., Ruldeviyani, Y., Nugraheni, S., & Prisillia, G. (2024). Comparative Analysis of Multicriteria Inventory Classification and Forecasing: A Case Study in PT XYZ. Jurnal Informatika Ekonomi Bisnis, 6(4), 732-739. https://doi.org/10.37034/infeb.v6i4.1014
 This work is licensed under a Creative Commons Attribution 4.0 International License. |
