Demand Forecasting for Improved Inventory Management in Small and Medium-Sized Businesses

Dian Indri Purnamasari; Vynska Amalia Permadi; Asep  Saepudin; Riza Prapascatama  Agusdin

doi:10.23887/janapati.v12i1.57144

Authors

Dian Indri Purnamasari Universitas Pembangunan Nasional Veteran Yogyakarta
Vynska Amalia Permadi Universitas Pembangunan Nasional Veteran Yogyakarta
Asep Saepudin Universitas Pembangunan Nasional Veteran Yogyakarta
Riza Prapascatama Agusdin Universitas Pembangunan Nasional Veteran Yogyakarta

DOI:

https://doi.org/10.23887/janapati.v12i1.57144

Keywords:

Demand Forecasting, Inventory Management, Machine Learning, Small and Medium-Sized Businesses

Abstract

Small and medium-sized businesses are constantly seeking new methods to increase productivity across all service areas in response to increasing consumer demand. Research has shown that inventory management significantly affects regular operations, particularly in providing the best customer relationship management (CRM) service. Demand forecasting is a popular inventory management solution that many businesses are interested in because of its impact on day-to-day operations. However, no single forecasting approach outperforms under all scenarios, so examining the data and its properties first is necessary for modeling the most accurate forecasts. This study provides a preliminary comparative analysis of three different machine learning approaches and two classic projection methods for demand forecasting in small and medium-sized leathercraft businesses. First, using K-means clustering, we attempted to group products into three clusters based on the similarity of product characteristics, using the elbow method's hyperparameter tuning. This step was conducted to summarize the data and represent various products into several categories obtained from the clustering results. Our findings show that machine learning algorithms outperform classic statistical approaches, particularly the ensemble learner XGB, which had the least RMSE and MAPE scores, at 55.77 and 41.18, respectively. In the future, these results can be utilized and tested against real-world business activities to help managers create precise inventory management strategies that can increase productivity across all service areas.

Author Biographies

Dian Indri Purnamasari, Universitas Pembangunan Nasional Veteran Yogyakarta

Asep Saepudin, Universitas Pembangunan Nasional Veteran Yogyakarta

Riza Prapascatama Agusdin, Universitas Pembangunan Nasional Veteran Yogyakarta

References

McKinsey & company, “Using customer analytics to boost corporate performance Marketing Practice Key insights from McKinsey’s DataMatics 2013 survey,” 2014.

A. Singh, M. Wiktorsson, and J. B. Hauge, “Trends In Machine Learning To Solve Problems In Logistics,” Procedia CIRP, vol. 103, pp. 67–72, 2021, doi: 10.1016/j.procir.2021.10.010.

A. Tufano, R. Accorsi, and R. Manzini, “A machine learning approach for predictive warehouse design,” The International Journal of Advanced Manufacturing Technology, vol. 119, no. 3–4, pp. 2369–2392, Mar. 2022, doi: 10.1007/s00170-021-08035-w.

A. M. Atieh et al., “Performance Improvement of Inventory Management System Processes by an Automated Warehouse Management System,” Procedia CIRP, vol. 41, pp. 568–572, 2016, doi: 10.1016/j.procir.2015.12.122.

T. Lima de Souza, D. Barbosa de Alencar, A. P. Tregue Costa, and M. C. Aparício de Souza, “Proposal for Implementation of a Kanban System in the Auxiliary Inventory Sector in a Auto Parts Company,” Int J Innov Educ Res, vol. 7, no. 10, pp. 849–859, Oct. 2019, doi: 10.31686/ijier.vol7.iss10.1833.

Xie Haiyan, “EMPIRICAL STUDY OF AN AUTOMATED INVENTORY MANAGEMENT SYSTEM WITH BAYESIAN INFERENCE ALGORITHM,” Int J Res Eng Technol, vol. 04, no. 10, pp. 398–405, Oct. 2015, doi: 10.15623/ijret.2015.0410065.

X. Guo, C. Liu, W. Xu, H. Yuan, and M. Wang, “A Prediction-Based Inventory Optimization Using Data Mining Models,” in 2014 Seventh International Joint Conference on Computational Sciences and Optimization, Jul. 2014, pp. 611–615. doi: 10.1109/CSO.2014.118.

L. Lin, W. Xuejun, H. Xiu, W. Guangchao, and S. Yong, “Enterprise Lean Catering Material Management Information System Based on Sequence Pattern Data Mining,” in 2018 IEEE 4th International Conference on Computer and Communications (ICCC), Dec. 2018, pp. 1757–1761. doi: 10.1109/CompComm.2018.8780656.

Box George E. P., Jenkins Gwilym M., Reinsel Gregory C., and Ljung Greta M., Time Series Analysis: Forecasting and Control. Wiley, 2015.

V. Assimakopoulos and K. Nikolopoulos, “The theta model: a decomposition approach to forecasting,” Int J Forecast, vol. 16, no. 4, pp. 521–530, Oct. 2000, doi: 10.1016/S0169-2070(00)00066-2.

K. Nikolopoulos, V. Assimakopoulos, N. Bougioukos, A. Litsa, and F. Petropoulos, “The Theta Model: An Essential Forecasting Tool for Supply Chain Planning,” 2011, pp. 431–437. doi: 10.1007/978-3-642-25646-2_56.

H. Lütkepohl, “Vector autoregressive models,” in Handbook of Research Methods and Applications in Empirical Macroeconomics, Edward Elgar Publishing, 2013, pp. 139–164. doi: 10.4337/9780857931023.00012.

L. Breiman, J. H. Friedman, R. A. Olshen, and C. J. Stone, Classification And Regression Trees. Routledge, 2017. doi: 10.1201/9781315139470.

D. F. Specht, “A general regression neural network,” IEEE Trans Neural Netw, vol. 2, no. 6, pp. 568–576, 1991, doi: 10.1109/72.97934.

N. S. Altman, “An Introduction to Kernel and Nearest-Neighbor Nonparametric Regression,” Am Stat, vol. 46, no. 3, p. 175, Aug. 1992, doi: 10.2307/2685209.

D. J. C. MacKay, “Bayesian neural networks and density networks,” Nucl Instrum Methods Phys Res A, vol. 354, no. 1, pp. 73–80, Jan. 1995, doi: 10.1016/0168-9002(94)00931-7.

C. K. I. Williams and C. E. Rasmussen, “Gaussian Processes for Regression,” in Proceedings of the 8th International Conference on Neural Information Processing Systems, 1995, pp. 514–520.

S. Hochreiter and J. Schmidhuber, “Long Short-Term Memory,” Neural Comput, vol. 9, no. 8, pp. 1735–1780, Nov. 1997, doi: 10.1162/neco.1997.9.8.1735.

Zhengyou Zhang, M. Lyons, M. Schuster, and S. Akamatsu, “Comparison between geometry-based and Gabor-wavelets-based facial expression recognition using multi-layer perceptron,” in Proceedings Third IEEE International Conference on Automatic Face and Gesture Recognition, pp. 454–459. doi: 10.1109/AFGR.1998.670990.

Medsker L.R. and Jain L.C., Recurrent neural networks: design and applications. CRC Press, 1999.

Buhmann M. D., Radial Basis Functions: Theory and Implementations, vol. 12. Cambridge University Press, 2003.

N. K. Ahmed, A. F. Atiya, N. el Gayar, and H. El-Shishiny, “An Empirical Comparison of Machine Learning Models for Time Series Forecasting,” Econom Rev, vol. 29, no. 5–6, pp. 594–621, Aug. 2010, doi: 10.1080/07474938.2010.481556.

J. J. Montaño Moreno, A. Palmer Pol, and P. Muñoz Gracia, “Artificial neural networks applied to forecasting time series.,” Psicothema, vol. 23, no. 2, pp. 322–9, Apr. 2011.

S. Makridakis, E. Spiliotis, and V. Assimakopoulos, “Statistical and Machine Learning forecasting methods: Concerns and ways forward,” PLoS One, vol. 13, no. 3, p. e0194889, Mar. 2018, doi: 10.1371/journal.pone.0194889.

F. E. H. Tay and L. J. Cao, “Improved financial time series forecasting by combining Support Vector Machines with self-organizing feature map,” Intelligent Data Analysis, vol. 5, no. 4, pp. 339–354, Nov. 2001, doi: 10.3233/IDA-2001-5405.

G. P. Zhang, “Time series forecasting using a hybrid ARIMA and neural network model,” Neurocomputing, vol. 50, pp. 159–175, Jan. 2003, doi: 10.1016/S0925-2312(01)00702-0.

C. N. Babu and B. E. Reddy, “A moving-average filter based hybrid ARIMA–ANN model for forecasting time series data,” Appl Soft Comput, vol. 23, pp. 27–38, Oct. 2014, doi: 10.1016/j.asoc.2014.05.028.

R. Wirth and J. Hipp, “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, 2000, pp. 29–39.

F. Petropoulos, R. J. Hyndman, and C. Bergmeir, “Exploring the sources of uncertainty: Why does bagging for time series forecasting work?,” Eur J Oper Res, vol. 268, no. 2, pp. 545–554, Jul. 2018, doi: 10.1016/j.ejor.2018.01.045.

C. S. Bojer and J. P. Meldgaard, “Kaggle forecasting competitions: An overlooked learning opportunity,” Int J Forecast, vol. 37, no. 2, pp. 587–603, Apr. 2021, doi: 10.1016/j.ijforecast.2020.07.007.