Abstract:With the improvement of people's living standards, people's requirements for the freshness and variety richness of food are also constantly increasing. Due to the short shelf life of fresh vegetable products, reasonable prediction and formulation of pricing and replenishment strategies have a significant impact on supermarket revenue. This article first cleans the data and uses Excel and Grabbs statistics to determine the missing and abnormal values of the data. The missing values are supplemented by 0, and the abnormal values are determined and eliminated through manual intervention. Conduct descriptive statistics on the preprocessed data to obtain partial data features of categories classified by day and month. Analyze numerical features to determine the distribution pattern of data using monthly classification, and then use SPSS PRO to conduct Spearman correlation analysis to obtain the relationship between vegetable categories. Next, this article quantifies six data indicators, including daily sales volume of each category, average unit price during normal sales, and discount degree. Then, MATLAB is used for regression fitting analysis to obtain the relationship expressions between each indicator and the total sales volume. Excel analysis is used to summarize the data to obtain the available variety information of each item of vegetables in the supermarket from June 24th to 30th, And use Python software to establish a time series prediction model to analyze and process the information of supermarket products, and obtain the demand for individual products on July 1st. Using the single product selected by the supermarket as the 0-1 decision variable, and the total operating profit and supply demand relationship of the supermarket as the dual objective variables, a multiple linear regression model is constructed to obtain the final replenishment policy and pricing decision. The data in this paper is from the National College Students Mathematical Modeling Competition C question.

Asymmetry in Retail, Wholesale, and Shipping Point Pricing for Fresh Vegetables

Dynamics and Interdependencies among Different Shipping Freight Markets

Pricing and Replenishment Decision of Vegetable Products

Asymmetric price transmission in perishable crops value chain: A NARDL approach

Asymmetric price adjustment: evidence from weekly product-level scanner price data

The Evolution of the Pricing Mechanism in the Polish Vegetable Markets: An Empirical Test

An ARIMA-based study of pricing and replenishment decisions for vegetable commodities

Automatic Pricing and Replenishment Strategies for Vegetable Products Based on Data Analysis and Nonlinear Programming

The dynamics of fresh fruit and vegetable pricing in the supermarket channel

Pricing and replenishment strategy formulation for the fresh produce market

Asymmetric Price Volatility Transmission in Agricultural Supply Chains: Evidence from the Chinese Pork Market

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

Study on International Price Volatility Transmission Mechanism of Agricultural Products——Literature Review from Asymmetric Perspective

Pricing of fresh agricultural product supply chain under transportation interruption

Vegetable Pricing and Restocking with Markov Models

Exchange rate uncertainty and US bilateral fresh fruit and fresh vegetable trade: an application of the gravity model

Automated pricing and replenishment strategies for vegetable products based on SVR and simulated annealing

Research on the Profit Maximization Model for Automatic Pricing and Restocking of Vegetable Commodities

Asymmetric Volatility Varies in Different Dry Bulk Freight Rate Markets under Structure Breaks

A qualitative and quantitative analysis of vegetable pricing in supermarket

Research on Pricing and Replenishment Decision of Vegetable Products Based on Optimization Algorithms