Optimization research on automatic pricing and replenishment decision method for vegetable commodities

Abstract

This paper addresses the issues of replenishment and pricing of vegetable commodities in fresh food supermarkets. By analyzing sales data and loss rate data, mathematical models are established to solve the following problems. Spearman correlation analysis and cluster analysis methods are employed. Firstly, data preprocessing is conducted by excluding returned vegetable products from a certain supermarkets distribution, and then integrating sales transaction details and wholesale price-related data. Secondly, monthly data is used to succinctly present the sales distribution patterns of various categories and individual items of vegetables through line charts. Finally, the models of Spearman correlation analysis and cluster analysis are respectively applied to illustrate the relationship between the sales volume of 6 major categories of vegetables and 251 individual items. Linear regression models, time series analysis, and XG-Boost regression analysis models are used. This paper requires replenishment plans to be made by category, analyzing the relationship between the total sales volume and cost-plus pricing of various vegetable categories. Firstly, a linear regression model is applied to fit historical sales volume and cost-plus pricing, resulting in a linear functional relationship, indicating that only the sales volume of tomatoes is negatively correlated with cost-plus pricing. Based on historical sales data, the daily replenishment total for each vegetable category within the next week is predicted. Predictive models and time series analysis are employed. Meanwhile, for pricing strategies, the XGBoost algorithm is utilized to provide reasonable pricing strategies. Based on the optimal solution, replenishment plans and pricing strategies for the next week are formulated to ensure the maximization of sales revenue objectives.