Research on Automatic Pricing and Replenishment Strategy of Vegetable Commodities Based on Fourier Series Fitting and Linear Programming

Abstract

Vegetable goods are a common category of goods sold in superstores. In order to determine the relationship between commodity price and sales quantity, and develop a reasonable replenishment and pricing strategy, this paper firstly uses the curve fitter linear regression in the MATLAB toolbox to analyse the relationship between total sales volume of different categories and cost plus pricing, and secondly, uses the curve fitter Fourier series in the MATLAB toolbox to fit the sales volume curve in June and calculates the degree of fit for validation to predict the sales volume of each vegetable category in the first week of July, calculate the daily replenishment volume, and determine the pricing of each category using the results of linear regression. Vegetable category sales, calculating daily replenishment, and using linear regression results to determine pricing for each category. Then, we consider the pricing and replenishment strategy when the total number of single items is restricted, and construct a linear programming decision optimisation model with single items as the main body, taking the replenishment quantity of single items as the decision variable, the restriction of the total number of single items, the minimum display quantity and the satisfaction of category demand as the constraints, and the maximum revenue of the superstore as the objective function, and then we construct the linear programming decision optimisation model, and find out the pricing and replenishment quantities for a total of 28 individual items as well as for each single item.