Based on the commodity information of the supermarket in the annex, the detailed data of historical sales flow, the wholesale price of vegetable commodities and the recent loss rate of vegetable commodities, and through the data analysis of each category and each single product, the automatic pricing and replenishment decision-making model of commodities is established. Use the optimization evaluation algorithm to formulate the total daily replenishment and pricing strategy of each category and each single product. In order to solve the first problem, firstly, the outliers in the original data of Annexes 2 and 3 are cleaned, normalized, feature selected and dimensionally reduced. Secondly, a quarter is taken as a sales cycle of supermarkets, so as to find the proportion of sales volume of a certain category in the same quarter of three years to the total sales volume, and give the distribution law of sales volume of different categories, the results are shown. Considering different periods again, the daily sales volume distribution law is calculated by taking one day as a sales cycle, and the results are shown. Finally, the Pearson grade correlation coefficient is used to judge the relationship between the processing indicators, and the matrix heat map is obtained. According to the two results, it was concluded that there was a significant positive correlation between the sales volume of mosaic and cauliflower vegetables, and a significant negative correlation between the sales volume of nightshade and aquatic root vegetables. In view of the second problem, firstly, considering the functional relationship between the total sales volume and the cost pricing, the correlation analysis and linear fitting were carried out to obtain the linear relationship between the sales price of each category and the maximum value of the sales volume of each category in July of the previous year can be described as Through further nonlinear fitting and optimization problem solving, the total daily replenishment volume and pricing strategy of each vegetable category in the coming week (July 1-7, 2023) are shown in Table 1 and Table 2, which makes the supermarket have the largest revenue In response to the third question, based on the known data, we can analyze the data requirements for each data: we need to know the sales volume of various vegetables during this period, we need to determine the purchase cost of each vegetable, we need to understand the past pricing strategy and response, and we need to know the inventory of various vegetables on June 30. On this basis, a multi-objective dynamic programming model is established, and the total number of saleable items is 30 by using the greedy algorithm to obtain the replenishment quantity of single items on July 1, and the pricing strategy is further solved by using the linear equation fitted in problem 2. In response to the fourth problem , on the basis of the existing sales, wholesale price and loss rate data, in order to better formulate the replenishment and pricing decisions of vegetable products, supermarkets also need to consider and collect the following 12 aspects of relevant data to assist in planning the pricing and replenishment decisions of vegetable products, such as: customer preference and satisfaction survey, seasonality and availability of vegetables, competitor information, inventory costs and storage conditions, historical sales data and trend analysis, customer flow and purchase period, nutritional value and health benefits of vegetables, Socio-economic factors, external environmental factors, policy and regulatory factors, technological and innovation factors, and supply chain and logistics information to ensure more comprehensive and accurate decision-making. Among them, the analysis of historical sales data and trends is mainly carried out.
Read full abstract