AI Decision Support for Demand Forecasting and Retail Stock Using Random Forest
DOI:
https://doi.org/10.47709/brilliance.v5i2.5901Keywords:
decision support system, artificial intelligence, demand prediction, inventory management, random forestAbstract
Out-of-stock or excess inventory is a major challenge in retail supply chain management, especially in dynamic urban areas. This stock imbalance not only causes financial losses, but can also reduce customer satisfaction due to products being unavailable when needed. This study developed an artificial intelligence (AI)-based decision support system using the Random Forest algorithm to predict daily demand in retail stores. The model was trained using historical sales data that included various variables such as date, product category, and previous sales trends. After the training process, the model was implemented in the form of an interactive web application using Streamlit, which allows users to easily access the system through a browser without the need for special installation.
Testing results show that the model is capable of predicting demand for the next 7 days with a fairly good level of accuracy, as indicated by a Mean Absolute Error (MAE) value of ±4.613 units per day. This application not only provides demand predictions but also presents data visualizations and automatic restocking recommendations based on the prediction results. Thus, this system is expected to help store managers make more accurate, efficient, and data-driven restocking decisions. Additionally, the use of Streamlit simplifies the process of distributing the system widely and enhances accessibility for end-users, including those without a technical background. This research opens opportunities for further development through the integration of real-time data and other AI methods to improve prediction accuracy in the future.
References
IJARCCE. (2025). Demand forecasting in retail using ML and big data. International Journal of Advanced Research in Computer and Communication Engineering, 14(2), 235–242.
Islam, M. T., Hossain Ayon, E., Ghosh, B. P., Chowdhury, S. M., Shahid, R., & dkk. (2024). Revolutionizing retail: A hybrid machine learning approach for precision demand forecasting and strategic decision-making in global commerce. Journal of Computer Science and Technology Studies, 6(1), 1–15.
Iyer, N., Singh, R., Patel, S., & Singh, A. (2021). Enhancing retail sales forecasting with LSTM networks and Random Forest regression: A comparative analysis. Journal of AI & ML Research, 10(8), 45–56.
Karmode, S. (2024). AI-based demand sensing: Improving forecast accuracy in supply chains. Journal of Industrial Engineering Research, 4(2).
Li, Y., Zou, C., Berecibar, M., Nanini-Maury, E., Chan, J. C. W., Van den Bossche, P., ... & Omar, N. (2018). Random forest regression for online capacity estimation of lithium-ion batteries. Applied energy, 232, 197-210.
Muchtar, I. R., & Afiyati. (2024). Comparison of Linear Regression and Random Forest Algorithms for Premium Rice Price Prediction: Case Study West Java. ResearchGate.
Petropoulos, F., Apiletti, D., Assimakopoulos, V., Babai, M. Z., Barrow, D. K., Taieb, S. B., ... & Ziel, F. (2022). Forecasting: theory and practice. International Journal of forecasting, 38(3), 705-871.
Punia, S., Nikolopoulos, K., Singh, S. P., Madaan, J. K., & Litsiou, K. (2020). Deep learning with long short-term memory networks and random forests for demand forecasting in multi-channel retail. International Journal of Production Research, 58(16), 4964–4979.
Rodriguez-Galiano, V., Sanchez-Castillo, M., Chica-Olmo, M., & Chica-Rivas, M. J. O. G. R. (2015). Machine learning predictive models for mineral prospectivity: An evaluation of neural networks, random forests, regression trees and support vector machines. Ore geology reviews, 71, 804-818.
Sarwandi, L. T. S., Hasibuan, N. A., Sudipa, I. G. I., Syahrizal, M., Alwendi, M., Muqimuddin, B. D. M., ... & Israwan, L. F. (2023). Decision support system. Graha partner education.
Segal, M. R. (2004). Machine learning benchmarks and random forest regression.
Springer. (2022). A comparative study of demand forecasting models for a multi-channel retail company: A novel hybrid machine learning approach. Operations Research Forum, 3, Article 58.
ThroughPut AI. (2024). Demand sensing: The ultimate guide. ThroughPut AI. Retrieved from
Zhang, Y., & Li, P. (2025). Demand and sales forecasting using Random Forest and linear regression. In Proceedings of the International Conference on Machine Learning Applications (pp. 421–432).
Zhao, J. (2025). Sales forecasting in retail supply chain management. In Proceedings of the 1st International Conference on E-commerce and Artificial Intelligence (ECAI 2024) (pp. 542–546).
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Anni Zulfia, Tasya Nadhira Ilfa, Zayyani Damia, T. Sukma Achriadi Sukiman, Annisa Karima
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
info@itscience.org, web: 
