Wholesale Inventory Management Optimization: Methodological Approach with XGBoost, SVR, and Random Forest Algorithms
DOI:
10.47709/brilliance.v3i2.3336Keywords:
XGBoost, Random Forest, Support Vector Regression, Suply Chain Optimization, Wholesale Iventory ManagementDimension Badge Record
Abstract
This research aims to optimize wholesale inventory management at PT Primafood International Pasir Putih 2 by implementing leading algorithms, namely XGBoost, Support Vector Regression (SVR), and Random Forest. In the wholesale industry, effective inventory management plays a crucial role in maintaining smooth production processes and enhancing company profitability. Despite the acknowledged benefits of inventory management, there are aspects that remain not fully disclosed, particularly concerning demand uncertainty and market fluctuations. This study addresses these gaps by exploring the potential of these three algorithms. Experimental methods with a quantitative approach were employed to shape and prepare the dataset. The analysis and predictions' results using XGBoost, SVR, and Random Forest were evaluated using metrics such as Mean Squared Error (MSE), F1-Score, and Accuracy. The evaluation indicates that XGBoost and SVR exhibit optimal performance with low MSE values of 7714.446 and 119.315, high F1-Scores (0.92), and good accuracy levels (0.86 and 0.85), respectively. While Random Forest shows a higher MSE, it still delivers solid performance with an F1-Score of 0.89 and an accuracy rate of 0.81. These findings suggest that all three algorithms can be considered to enhance inventory management performance at PT Primafood International Pasir Putih 2, with significant potential benefits for overall industry development. This research provides valuable insights for decision-making at the business and industrial levels, highlighting the effectiveness of each algorithm in the context of predicting stock level.
Abstract viewed = 179 times
References
Aditama, N., & Munir, R. (2022). Indonesian Street Food Calorie Estimation Using Mask R-CNN and Multiple Linear Regression. In 2022 Second International Conference on Power, Control and Computing Technologies (ICPC2T) (pp. 1–6). IEEE. doi:10.1109/ICPC2T53885.2022.9776804
Bertolini, M., Mezzogori, D., Neroni, M., & Zammori, F. (2021). Machine Learning for industrial applications: A comprehensive literature review. Expert Systems with Applications, 175, 114820. doi:10.1016/j.eswa.2021.114820
Cao, L., Xu, L., Goodman, E. D., Bao, C., & Zhu, S. (2020). Evolutionary Dynamic Multiobjective Optimization Assisted by a Support Vector Regression Predictor. IEEE Transactions on Evolutionary Computation, 24(2), 305–319. doi:10.1109/TEVC.2019.2925722
Demidova, L., & Ivkina, M. (2019). Defining the Ranges Boundaries of the Optimal Parameters Values for the Random Forest Classifier. In 2019 1st International Conference on Control Systems, Mathematical Modelling, Automation and Energy Efficiency (SUMMA) (pp. 518–522). IEEE. doi:10.1109/SUMMA48161.2019.8947569
Gupta, R., Yadav, A. K., Jha, S., & Pathak, P. K. (2022). Time Series Forecasting of Solar Power Generation Using Facebook Prophet and XG Boost. In 2022 IEEE Delhi Section Conference (DELCON) (pp. 1–5). IEEE. doi:10.1109/DELCON54057.2022.9752916
Jain, G., & Prasad, R. R. (2020). Machine learning, Prophet and XGBoost algorithm: Analysis of Traffic Forecasting in Telecom Networks with time series data. In 2020 8th International Conference on Reliability, Infocom Technologies and Optimization (Trends and Future Directions) (ICRITO) (pp. 893–897). IEEE. doi:10.1109/ICRITO48877.2020.9197864
Jakkraphobyothin, K., Srifa, S., & Chinda, T. (2018). Factor Analysis of Inventory Management in Thai Construction Industry. In 2018 3rd Technology Innovation Management and Engineering Science International Conference (TIMES-iCON) (pp. 1–5). IEEE. doi:10.1109/TIMES-iCON.2018.8621817
Kurniawati, N., Novita Nurmala Putri, D., & Kurnia Ningsih, Y. (2020). Random Forest Regression for Predicting Metamaterial Antenna Parameters. In 2020 2nd International Conference on Industrial Electrical and Electronics (ICIEE) (pp. 174–178). IEEE. doi:10.1109/ICIEE49813.2020.9276899
Lohrmann, C., & Luukka, P. (2019). Classification of intraday S&P500 returns with a Random Forest. International Journal of Forecasting, 35(1), 390–407. doi:10.1016/j.ijforecast.2018.08.004
Lolli, F., Balugani, E., Ishizaka, A., Gamberini, R., Rimini, B., & Regattieri, A. (2019). Machine learning for multi-criteria inventory classification applied to intermittent demand. Production Planning & Control, 30(1), 76–89. doi:10.1080/09537287.2018.1525506
Mouhajir, M., Nechba, M., & Sedjari, Y. (2023). High Performance Computing Applied to Logistic Regression: A CPU and GPU Implementation Comparison. In 2023 IEEE International Conference on Artificial Intelligence, Blockchain, and Internet of Things (AIBThings) (pp. 1–5). IEEE. doi:10.1109/AIBThings58340.2023.10291024
Mukherjee, A., & Ramachandran, P. (2018). Prediction of GWL with the help of GRACE TWS for unevenly spaced time series data in India?: Analysis of comparative performances of SVR, ANN and LRM. Journal of Hydrology, 558, 647–658. doi:10.1016/j.jhydrol.2018.02.005
Ni, D., Xiao, Z., & Lim, M. K. (2020). A systematic review of the research trends of machine learning in supply chain management. International Journal of Machine Learning and Cybernetics, 11(7), 1463–1482. doi:10.1007/s13042-019-01050-0
Ntakolia, C., Kokkotis, C., Karlsson, P., & Moustakidis, S. (2021). An explainable machine learning model for material backorder prediction in inventory management. Sensors, 21(23). doi:10.3390/s21237926
Panahi, M., Sadhasivam, N., Pourghasemi, H. R., Rezaie, F., & Lee, S. (2020). Spatial prediction of groundwater potential mapping based on convolutional neural network (CNN) and support vector regression (SVR). Journal of Hydrology, 588, 125033. doi:10.1016/j.jhydrol.2020.125033
Roy, S. S., Chopra, R., Lee, K. C., Spampinato, C., & ivatlood, B. M. (2020). Random forest, gradient boosted machines and deep neural network for stock price forecasting: a comparative analysis on South Korean companies. International Journal of Ad Hoc and Ubiquitous Computing, 33(1), 62. doi:10.1504/IJAHUC.2020.104715
S, Krishnakumar., Refonaa, J., Jany Shabu, S. L., Dion Paul, K., Dhamodaran, S., & Mary, V. A. (2023). MediStock: Medical Inventory Management System. In 2023 4th International Conference on Electronics and Sustainable Communication Systems (ICESC) (pp. 738–743). IEEE. doi:10.1109/ICESC57686.2023.10193177
Saadah, S., & Salsabila, H. (2021). Prediksi Harga Bitcoin Menggunakan Metode Random Forest. Jurnal Komputer Terapan, 7(1), 24–32. doi:10.35143/jkt.v7i1.4618
Sairam, P. V., & K, Logu. (2022). Automatic Stock Market Prediction using Novel Long Short Term Memory Algorithm compared with Logistic Regression for improved F1 score. In 2022 2nd International Conference on Innovative Practices in Technology and Management (ICIPTM) (pp. 578–582). IEEE. doi:10.1109/ICIPTM54933.2022.9754116
Sandag, G. A. (2020). Prediksi Rating Aplikasi App Store Menggunakan Algoritma Random Forest. CogITo Smart Journal, 6(2), 167–178. doi:10.31154/cogito.v6i2.270.167-178
Sari, V., Firdausi, F., & Azhar, Y. (2020). Perbandingan Prediksi Kualitas Kopi Arabika dengan Menggunakan Algoritma SGD, Random Forest dan Naive Bayes. Edumatic: Jurnal Pendidikan Informatika, 4(2), 1–9. doi:10.29408/edumatic.v4i2.2202
Sun, Y., Ding, S., Zhang, Z., & Jia, W. (2021). An improved grid search algorithm to optimize SVR for prediction. Soft Computing, 25(7), 5633–5644. doi:10.1007/s00500-020-05560-w
Svoboda, J., & Minner, S. (2022). Tailoring inventory classification to industry applications: the benefits of understandable machine learning. International Journal of Production Research, 60(1), 388–401. doi:10.1080/00207543.2021.1959078
Tang, Y., Yan, H., Tang, J., & Chien, Y.-R. (2022). A Fast Kernel Least Mean Square Algorithm. In 2022 IET International Conference on Engineering Technologies and Applications (IET-ICETA) (pp. 1–2). IEEE. doi:10.1109/IET-ICETA56553.2022.9971688
Tao, Y., Yan, H., Gao, H., Sun, Y., & Li, G. (2019). Application of SVR optimized by Modified Simulated Annealing (MSA-SVR) air conditioning load prediction model. Journal of Industrial Information Integration, 15, 247–251. doi:10.1016/j.jii.2018.04.003
Yaqin, A., Rahardi, M., Abdulloh, F. F., Kusnawi, Budiprayitno, S., & Fatonah, S. (2022). The Prediction of COVID-19 Pandemic Situation in Indonesia Using SVR and SIR Algorithm. In 2022 6th International Conference on Information Technology, Information Systems and Electrical Engineering (ICITISEE) (pp. 570–573). IEEE. doi:10.1109/ICITISEE57756.2022.10057813
Yigit, M. E., Gunel, T., & Gunel, G. O. (2018). PSO Based Approach to the Synthesis of a Cylindrical-Rectangular Ring Microstrip Conformal Antenna Using SVR Models with RBF and Wavelet Kernels. In 2018 18th Mediterranean Microwave Symposium (MMS) (pp. 13–16). IEEE. doi:10.1109/MMS.2018.8612069
Zhan, Y., Zhang, H., & Liu, Y. (2021). Forecast of Meteorological and Hydrological Features Based on SVR Model. In 2021 4th International Conference on Advanced Electronic Materials, Computers and Software Engineering (AEMCSE) (pp. 579–583). IEEE. doi:10.1109/AEMCSE51986.2021.00123
Zhang, X., Gao, G., Lou, P., Yan, J., & Hu, J. (2019). Identification of Critical Process Parameters for Carbon Fiber Precursor Based on XGBoost Algorithm. In 2019 11th International Conference on Intelligent Human-Machine Systems and Cybernetics (IHMSC) (pp. 20–24). IEEE. doi:10.1109/IHMSC.2019.10100
Zheng, J., Wang, Y., Li, S., & Chen, H. (2021). The Stock Index Prediction Based on SVR Model with Bat Optimization Algorithm. Algorithms, 14(10), 299. doi:10.3390/a14100299
Zhu, H., & Hu, J. (2019). Air Quality Forecasting Using SVR with Quasi-Linear Kernel. In 2019 International Conference on Computer, Information and Telecommunication Systems (CITS) (pp. 1–5). IEEE. doi:10.1109/CITS.2019.8862114
Zhu, J.-M., Geng, Y.-G., Li, W.-B., Li, X., & He, Q.-Z. (2022). Fuzzy Decision-Making Analysis of Quantitative Stock Selection in VR Industry Based on Random Forest Model. Journal of Function Spaces, 2022, 1–12. doi:10.1155/2022/7556229
Downloads
ARTICLE Published HISTORY
Accepted Date: 2023-12-19
Published Date: 2023-12-29
How to Cite
Issue
Section
License
Copyright (c) 2023 Carli Apriansyah Hutagalung Hutagalung, Gisela Anastacia Rosalind, Dewi Masito Setyo Tuhu, Ayu Agustianingsih
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
info@itscience.org, web: 
