Study on the pricing and replenishment of vegetable commodities based on the optimization model

Authors

  • Yongqiang Yin
  • Xuening Kong
  • Runqi Cao

DOI:

https://doi.org/10.54097/mrrks648

Keywords:

Pearson Person Correlation, Cluster Analysis, ARIMA Time Series Model, Demand Price Elasticity.

Abstract

Based on the problems of short shelf life, inventory control and pricing management, marketing, economics, operation research, and the control optimal theory, this paper establishes the regression prediction analysis model; establish the optimization model, formulate the total amount of daily replenishment; analyze the deficiencies of the model. Finally, the combination of the research results gives the replenishment and pricing decision to improve the revenue of the supermarket. In this study, the correlation degree between the two variables of each vegetable category and the single product sales volume was measured, and the time series analysis was used to identify the sales trend. Then according to the correlation analysis of descriptive statistics, using cosine similarity formula, analyze the data units, the total sales dimension normalization, using the method of standardize the correlation between item and category, using pearson correlation coefficient and Spearman correlation coefficient to study the relationship between category and sales, establish Spearman correlation coefficient to determine the final correlation coefficient, cluster analysis of each category, analysis of the correlation. By processing the relevant data, establish the ARIMA time series model, forecast on July 1,2023-July 7, the relevant data, using the adftest function time series stability test, fit the ARIMA time series model, using differential sequence to time series analysis, calculate vegetable sales and sales price of elastic demand function, finally find the optimal solution through the particle swarm algorithm.

Downloads

Download data is not yet available.

References

Li Yali. Consider the collaborative decision of joint replenishment and pricing for investment in preservation technology [D]. Chongqing: Chongqing Jiaotong University, 2022.

Sun Yuping. Research on short-term demand forecast and inventory allocation of fresh commodities [D]. China University of Petroleum, 2021

Scientific Platform Serving for Statistics Professional 2021. SPSSPRO.(Version 1.0.11)[Online Application Software].Retrieved from https://www.spsspro.com .

Zhong Yao, Nie Ying, Guo Jianxin, et al. Study on the characteristics and rules of vegetable price fluctuation in Beijing [J]. Price Theory and Practice, 2023 (6): 1-6.

Jian-bo wang. Research on the management of fresh Goods in Beijing Yonghui Supermarket [D]. Beijing University of Chemical Technology, 2020

Li Fangdi, Zhao Shangwen. Analysis of vegetable price trend in the first half of 2022 [J]. Agricultural Science and Technology and Information, 2023 (6): 162-165.

Department of Trade and Foreign Economic and Statistics, National Bureau of Statistics. China Trade and Foreign Economic Statistical Yearbook [M]. Beijing: China Statistics Press, 2021. Department of Trade and External Economic Relations Statistics.China trade and external economic statistical yearbook-2021[M].Beijing:China Statistics Press,2021.

AnKui. M Research on collaborative optimization of fresh supermarket supply chain inventory [D]. Guiyang: Guizhou University, 2021

Lu Jing. Research on inventory control and dynamic pricing of fresh agricultural products [D]. Tianjin: Tianjin University, 2019.

The compilation Committee of China Statistical Yearbook-2021. China Statistical Yearbook-2021 [M]. Beijing: China Statistics Publishing House, 2021. China Statistical Yearbook-2021 Editorial Board.China statistical yearbook-2021[M].Beijing:China Statistics Press, 2021.

Downloads

Published

09-05-2024