Zhenpu Li
Chongqing Jiaotong University, Chongqing, China.
*Corresponding author: Zhenpu Li
Abstract
To enhance replenishment and pricing decisions for fresh vegetable products in fresh food supermarkets, this study develops machine learning time series forecasting and operations research models. By examining the historical sales and demand patterns, we investigate the relationships between different categories of vegetables and their sales volumes. We then investigate optimal replenishment and pricing strategies under different demand and supply scenarios. The sales unit price, category name, wholesale price, and loss rate were linked via product coding for data preprocessing, showing no missing values. The sales volumes of six vegetable categories were analyzed using the Kruskal-Wallis non-parametric test, followed by a differential analysis. The results indicated a significant difference between sales volume and category code. Finally, an XGBoost model was established to explore the impact of relevant features on sales volume. This study utilized the magnitude of the R-squared values in SPSS software to assess the goodness of fit and choose suitable models. Subsequently, a replenishment plan for supermarkets was established. Experimental forecasting and demand forecasting were conducted using ARIMA time series analysis to determine the total daily replenishment quantity for the upcoming seven days.
References
[1] Wang Kunzhang, Jiang Shubo, Zhang Hao, et al. Regression classification regression life prediction model based on XGBoost [J]. China Test, 2023, 49 (08): 104-109.
[2] Wei Siyu Prediction of China's GDP Based on Time Series Models [D]. Shandong University, 2023. DOI: 10.27272/d.cnki. gshdu. 2022-003785.
[3] Li Dechang, Dong Jianfeng, Su Jiawang, et al. Information Science Hotspot Keywords and Theme Development Prediction Based on Grey Prediction GM (1,1) Model [J]. Technology and Market, 2023, 30 (08): 137-142.
[4] Gui Sisi, Sun Wei, Xu Xiaofeng. Analysis of Automobile Sales Forecast Based on ARIMA and Linear Regression Combination Model [J]. Computer and Digital Engineering, 2021,49 (08): 1719-1723.
[5] Deng Qi, Gao Jianjun, Ge Dongdong, et al. Modern Optimization Theory and Application [J]. Chinese Science: Mathematics, 2020, 50 (07): 899-968.
How to cite this paper
Pricing and Replenishment of Vegetable Commodities Based on Machine Learning and Operations Research
How to cite this paper: Zhenpu Li. (2024) Pricing and Replenishment of Vegetable Commodities Based on Machine Learning and Operations Research. Advances in Computer and Communication, 5(2), 128-134.
DOI: https://dx.doi.org/10.26855/acc.2024.04.006