The Research on Pricing and Replenishment Optimization of Fresh Supermarket Vegetable Products based on Sales Data

Jintao Yang; Zhuo Liu; Shuo Huang; Gangtong Zhou; Weizhi Li

doi:10.62051/gabkvf34

Authors

Jintao Yang
Zhuo Liu
Shuo Huang
Gangtong Zhou
Weizhi Li

DOI:

https://doi.org/10.62051/gabkvf34

Keywords:

Vegetable Sales Management; Supermarket Replenishment and Pricing Decisions; Sales Trend Correlation Analysis; Time Series Forecasting Analysis; Multi-objective Programming Model.

Abstract

This study delves into the challenges and complexities of vegetable sales management in modern commercial environments, particularly in fresh food supermarkets. By utilizing descriptive statistics and visual analysis of sales data, the study reveals the correlations between different vegetable categories and quantifies these correlations using Pearson's correlation coefficient. Subsequently, by integrating time series analysis and multi-objective programming, a mathematical model is constructed, aimed at maximizing profits under specific constraints. The innovation of this research lies in its comprehensive consideration of category-level sales management and the application of modern optimization algorithms for replenishment and pricing strategies. The uniqueness of this paper is in its integrative approach to the vegetable sales problem, providing refined mathematical models and advanced optimization methods. Finally, the paper thoroughly describes the steps of the research design, including sales data analysis, cost markup analysis, and the construction of an optimization model based on time series analysis and multi-objective programming, intending to offer supermarkets a vegetable sales management plan adaptable to market changes.

Downloads

Download data is not yet available.

References

Chen T, Zhou L, Guo S. Research on Pricing and Replenishment Strategy for Vegetable Commodities based on Non-linear Programming[J]. Transactions on Economics, Business and Management Research, 2023, p. 19-24.

Fan Fengyan: Research on Supermarket Fresh Food Pricing Model (Master, Fujian Normal University, China 2019) [D], p. 9.

Zou Guangjun, Fu Shaochuan. Joint Replenishment Optimization of Multiple Perishable Products under Random Demand [J]. Management Science and Engineering. Vol. 7 (2018) No.1, p. 9-19.

Zhanyu S X H. Optimal pricing and replenishment policy for perishable food supply chain under inflation[J]. Computers Industrial Engineering,2021,158107433-107433, p. 2-19.

Doganis, P., et al., Time series sales forecasting for short shelf-life food products based on artificial neural networks and evolutionary computing. Journal of Food Engineering, 2006. 75(2), p. 196-204.

Wahedi H, Wrona K, Heltoft M, et al. Improving Accuracy of Time Series Forecasting by Applying an ARIMA-ANN Hybrid Model[C]//IFIP International Conference on Advances in Production Management Systems. Cham: Springer Nature Switzerland, 2022: p. 3-10.

Aram A H A. A novel hybrid model to forecast seasonal and chaotic time series [J]. Expert Systems with Applications, 2024,239p. 2-15.

Fengli J X Z J X R W. Multivariable time series forecasting using model fusion[J]. Information Sciences, 2022, 585262-274. p. 5.

Junior P R, Salomon F L R, de Oliveira Pamplona E. ARIMA: An applied time series forecasting model for the Bovespa stock index[J]. Applied Mathematics, 2014, p. 3.

Yugal P R K. Multi-step time series analysis and forecasting strategy using ARIMA and evolutionary algorithms [J]. International Journal of Information Technology,2021,14(1):p. 1-15.