ArticleOpen Access http://dx.doi.org/10.26855/acc.2024.04.006
Pricing and Replenishment of Vegetable Commodities Based on Machine Learning and Operations Research
Zhenpu Li
Chongqing Jiaotong University, Chongqing, China.
*Corresponding author: Zhenpu Li
Published: May 15,2024
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.
Keywords
XGBoost, ARIMA, Multivariate nonlinear programming, linear programming
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.
Copyright
© 2024 by the author(s).
This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution-NonCommercial-NoDerivatives (CC BY-NC-ND) license, which permits non-commercial use, distribution, and reproduction in any medium, provided the original work is properly cited and is not modified or adapted.
https://creativecommons.org/licenses/by-nc-nd/4.0/
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: http://dx.doi.org/10.26855/acc.2024.04.006