Research on Pricing and Replenishment Decision of Vegetable Products Based on Optimization Algorithms
DOI:
https://doi.org/10.54097/qn4yrs13Keywords:
Spearman Correlation Analysis, Time Series Prediction Model, Multiple Linear Regression Model.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.
Downloads
References
Li Huaixiang, Zhuo Zhihai. Improved 2D CA-CFAR based on Grubbs criterion [J]. Journal of Beijing University of Information Technology: Natural Science Edition, 2023, 38
Wang Zirun, Wang Qianyi, Wang Xiaomeng, Yuan Wenjia, Wei Xiao, Liu Wei, Fan Xiuzhu. Research on supplier selection strategy based on dynamic weighting method from the perspective of returning home employment [J]. Technology and Market, 2023,30 (07)
Cao Yili, Gao Min, Sun He, et al. A dynamic reactive power compensation device loss calculation method based on regression prediction: CN202211362059.6 [P]
Xu Wenting, Xu Liqun: A Study on the Optimal Combination Strategy of Profits for Volatile Products Influenced by Multiple Factors [J]. Shanghai Management Science 2016
Li Yuan. Research on Dual Channel Retail Pricing and Inventory Joint Optimization Considering Reference Price Effect [D]. Yanshan University, 2022
Zhao Ling, Liu Zhixue. Joint replenishment and pricing strategy considering customer returns and fixed costs [J]. Operations Research and Management, 2022
Cibicong, Zhang Pinyi. Financial Time Series Prediction Based on ARIMA-LSTM Model [J]. Statistics and Decision, 2022 (11): 5
Yu Shixin, Yao Zejia, Wang Haodong, et al. Bank loan strategy based on BP neural network and linear programming model [J] two thousand and twenty-one
Wu Lifang. A multi-stage pricing model for fresh agricultural products considering freshness and consumer utility [J]. Comprehensive Transportation, 2022,
Li Jiaxu. A Study on the Pricing of Dual Channel Air Tickets under Demand Orientation [J]. Logistics Technology, 2021, 40 (7): 8
Downloads
Published
Conference Proceedings Volume
Section
License
Copyright (c) 2024 Journal of Education, Humanities and Social Sciences
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.