Education, Science, Technology, Innovation and Life
Open Access

### Research on replenishment strategy of superstore fresh goods based on STL-ARIMA

#### Author(s)

Yujing Zhang 1, Hongling Qin 2, Zhihan Wei 1, Yu Dai 3, Linwen Zhang 4

#### Affiliation(s)

1 School of Mathematics and Computer Science, Chongqing College of International Business and Economics, Chongqing, 401520, China
2 Chongqing Science City Xi Yong First Primary School, Chongqing, 400030, China
3 School of Bioinformatics, Chongqing University of Posts and Telecommunications, Chongqing, 400065, China
4 Faculty of Electronics and Information, Chengdu Jincheng College, Chengdu, 611731, China

Yujing Zhang

#### ABSTRACT

This article provides a comprehensive analysis and modelling of vegetable sales data. Firstly, the statistical analysis of the data was carried out by counting the monthly sales by category and individual item respectively and plotting the combination of sales volume and sales for each category of vegetables as well as the circle plot for individual items of vegetables so as to study the relationship and trend between them. The correlation coefficients between different vegetable categories and individual items were further calculated by Pearson's test, and strong correlations between edibles and aquatic roots and tubers, as well as correlation characteristics between chilli, cauliflower and foliar categories were found. In modelling cost-plus pricing, the article predicts the total replenishment and pricing strategy for the coming week by analysing the relationship between sales volume and cost-plus pricing and obtaining a fitted equation. For data processing, the article adopts the method of nearest neighbour interpolation to fill in missing values and data smoothing, decomposes the data into seasonal, trend and residual terms by STL decomposition, and establishes an ARIMA model to predict the sales volume in the coming week. Overall, this paper digs deeper into the relationships and trends in vegetable sales data through statistical analysis and modelling methods, which provides strong support and reference for the development of future sales strategies.

#### KEYWORDS

ARIMA Model, Correlation, Replenishment Strategy

#### CITE THIS PAPER

Yujing Zhang, Hongling Qin, Zhihan Wei, Yu Dai, Linwen Zhang, Research on replenishment strategy of superstore fresh goods based on STL-ARIMA. Information Systems and Economics (2024) Vol. 5: 131-140. DOI: http://dx.doi.org/10.23977/infse.2024.050318.

#### REFERENCES

[1] Li Teng, Zhang Rulan, Sun Yan. Research on dynamic optimisation strategy of return position allocation for intelligent warehouse shelves [J/OL]. Frontiers of Engineering Management Science and Technology, 1-10[2024-04-28].
[2] Xie WJ. A review of research on joint replenishment problem [J]. China Storage and Transportation, 2024, (04): 138-139.
[3] Guo Y. Impact of digital transformation on supply chain management [J]. Old Brand Marketing, 2024, (06): 42-44.
[4] Nie Yuxuan. Research on automatic pricing and replenishment strategy of fresh commodities based on ARIMA prediction optimisation model - taking vegetable commodities as an example [J]. Commercial Exhibition Economy, 2024, (05): 19-22.
[5] Guan ZZ, Wang YW, Kang HWF. A study on supply chain ordering strategy preference considering returns [J]. Industrial Engineering, 2024, 27 (01): 120-127.
[6] Jia Mengyao, Zhang Jihui. Optimisation of site selection-inventory-distribution integration considering disruption risk [J/OL]. Complex Systems and Complexity Science, 1-10[2024-04-28].
[7] Ma Chao, He Juan, Huang Fuyou,et al. VMI Supply Chain Coordination Considering Loss Avoidance and Replenishment Strategies [J]. Operations Research and Management, 2024, 33 (01): 69-75.
[8] Huang Lixue, Yao Guanxin. Research on horizontal replenishment of fresh produce in supermarket chains [J]. Logistics Science and Technology, 2024, 47 (01): 100-104.
[9] Li Z, Zhang X P, Zhou Y F, et al. Performance assessment of blood supply chain based on complex adaptive system and depot ageing strategy [J]. Business Research, 2023, 30 (06): 106-117.
[10] Lin Qinwei. Research on dynamic optimisation method of automotive MRO parts supply chain based on CPFR [D]. Jimei University, 2023.