Education, Science, Technology, Innovation and Life
Open Access
Sign In

Supermarket Vegetable Commodities Based on TOPSIS-ARIMA Modeling Optimization Research on Replenishment and Pricing

Download as PDF

DOI: 10.23977/acss.2023.071110 | Downloads: 6 | Views: 231

Author(s)

Zhao Xin 1, Lu Wenjun 2, Jiang Manyi 1, Song Zijun 1

Affiliation(s)

1 Department of Economic Management and Law, South China University, Hengyang, 421001, China
2 School of Resources, Environment and Safety Engineering, South China University, Hengyang, 421001, China

Corresponding Author

Zhao Xin

ABSTRACT

With the development of social economy, green and healthy food has gradually become the primary choice of consumers, thus intensifying the competition of vegetable commodities, resulting in the supply of vegetables sometimes exceeds the demand. However, since vegetables are characterized by a short freshness period and deterioration of dish quality, different factors affecting the sales and selling price of the commodities are considered comprehensively to meet the superstore to obtain the maximum return. Firstly, considering that the cost-plus pricing of vegetable commodities has a strong correlation with the discount price, transportation loss rate and storage time, the Topsis model is established to evaluate the different degrees of influence of the above factors, which results in the degrees of influence of the discount price, the transportation loss rate and the storage time on the cost-plus pricing of 21%, 42% and 37%, respectively. Secondly, we calculated the values of the above four indexes and obtained the linear fitting function between the total sales volume and the indexes, and concluded that the discount price is positively related to the total sales volume, with the maximum slope of 9.3218 and the minimum of 0.64; while the cost-plus pricing is negatively correlated with the total sales volume, with the minimum slope of -13.12 and the maximum slope of -0.944, which indicates that when the discount degree is bigger and the cost-plus pricing is lower, each vegetable category will be affected by the discount price and the cost-plus pricing. The lower the discount level and the lower the cost-plus pricing, the higher the sales volume of each vegetable category. Then the autoregressive model (AR) and autoregressive integral sliding average model (ARIMA) are used to fit the maximum value of interest to the sales price and sales volume of cauliflower and aquatic roots and tubers over time in three years to form a training set, and finally the daily replenishment total and pricing of each vegetable category in the coming week are predicted to give advice to the superstores on replenishment and pricing to maximize the revenue of the superstores.

KEYWORDS

Autoregressive modeling, autoregressive integral sliding average modeling, cost-plus determination

CITE THIS PAPER

Zhao Xin, Lu Wenjun, Jiang Manyi, Song Zijun, Supermarket Vegetable Commodities Based on TOPSIS-ARIMA Modeling Optimization Research on Replenishment and Pricing. Advances in Computer, Signals and Systems (2023) Vol. 7: 65-73. DOI: http://dx.doi.org/10.23977/acss.2023.071110.

REFERENCES

[1] Yang Shuai, Huang Xiangmeng, Wang Junbin. Research on joint optimization strategy of fresh food shelf allocation and pricing [J].Supply chain management, 2022,3 (08):49-59.
[2] Cui Ligang, Li Yali, Liu Jinxing, etc. Joint decision-making on multi-product replenishment and pricing considering investment in preservation technology [J]. Industrial Engineering and Management, 2023, 28 (03) : 17-26.
[3] Yao Ziwei. Research on price decision of fresh products considering price and price reduction time [D].Southeast University, 2022.
[4] Wang Heng, Xu Qi. Research on retailer pricing and ordering strategy based on option contract under the correlation between market demand and sales price [J].Journal of Ningxia University ( Natural Science Edition ), 2017,38 ( 04 ) : 332-337.
[5] Yang Renti, Chen Wenzhang. When analyzing the test error, the t-test criterion is used to eliminate the bad value and its electrical algorithm [J].Sichuan Machinery, 1982 (05): 25-30.
[6] Abdelhakim A, Christian F. Two-stage weighted least squares estimator of the conditional mean of observation-driven time series models [J]. Journal of Econometrics, 2023,237(2PB). 
[7] Wang Yan. Applied Time Series Analysis [M]. Beijing: Renmin University of China Press, 2005.
[8] Soumik R, Achal L, Pradeep M, et al. An ARIMA-LSTM model for predicting volatile agricultural price series with random forest technique[J]. Applied Soft Computing,2023,149(PA). 
[9] Yanbo, Xu. Optimization model of rural supermarket location based on Entropy Weight TOPSIS[C]//International Conference on E-business & E-government. IEEE, 2011.DOI:10.1109/ICEBEG.2011.5881553.
[10] Özbilge Armağan, Hassini Elkafi, Parlar Mahmut. Optimal pricing and donation policy for fresh goods[J]. European Journal of Operational Research,2024,312(1). 
[11] Jiang Y,Shang J,Liu Y, et al. Redesigning promotion strategy for e-commerce competitiveness through pricing and recommendation[J]. International Journal of Production Economics,2015,167.

Downloads: 13683
Visits: 260414

Sponsors, Associates, and Links


All published work is licensed under a Creative Commons Attribution 4.0 International License.

Copyright © 2016 - 2031 Clausius Scientific Press Inc. All Rights Reserved.