Optimizing the Sales Law and Replenishment Decision Analysis of Fresh Supermarket Products

Abstract

In the field of fresh food supermarkets, due to the relatively limited shelf-life of vegetable products, their quality will gradually deteriorate with the sales time. Therefore, supermarkets need to perform daily rationing replenishment operations based on the historical sales data and demand of the products. This paper is based on the collected product information of vegetable categories, detailed vegetable sales flow data, wholesale prices of vegetable products, and recent vegetable product wastage rates. Data analysis and visualization techniques are used to analyze the distribution pattern of vegetable sales in each category and single product. Next, a functional relationship between total sales volume and cost-plus pricing of vegetable categories was constructed. Regression forecasts were used to simulate the future wholesale prices of vegetable categories.