Study on Pricing and Replenishment Decision of Vegetable Products Based on SARIMA Model

Authors

  • Feifan Yu
  • Lei You
  • Xinyue Han
  • Haoze Ma
  • hijun Sun
  • Liyin Zhang
  • Yuesheng Zhao

DOI:

https://doi.org/10.62051/qex0yt47

Keywords:

Heat map; Ridge Regression; SARIMA.

Abstract

In fresh food superstores, vegetable commodities are characterized by a short shelf life and deterioration in quality over time. To meet market demand and profit, merchants usually sell vegetables with shipping losses and deteriorating quality at a discount. Therefore, the pricing and replenishment strategies of vegetables have an important impact on the profit maximization of fresh produce superstores. The aim of this paper is to reveal the patterns by processing and analyzing the past sales data. The distribution pattern between different categories of vegetables is obtained through Pearson's coefficient. Then the correlation coefficients between different vegetable categories were calculated by ridge regression model. In the order of aquatic root vegetables, cauliflower vegetables, leafy vegetables, pepper vegetables, eggplant vegetables and edible mushroom vegetables, the coefficients of sales unit price were -0.535, -0.936, -2.498, -0.658, -0.279 and -1.157 respectively. Then the optimal model and the daily replenishment and pricing strategy for maximizing the revenue were determined by using the SARIMA model. The above model helps the superstore to adjust the replenishment plan and pricing strategy, and to better meet the market demand and increase sales revenue and profit. Also, it can be extended from a specific problem to other products with similar characteristics.

Downloads

Download data is not yet available.

References

[1] Yang Tianshan, Yuan Gonglin. Research on dynamic pricing and replenishment strategy of perishables considering investment in green distribution technology [J]. China Management Science, 2023, 31 (11): 279 - 287.

[2] Li Panfeng, Ma Zujun, Sun Hao. Research on blood supply and demand prediction based on SARIMA combined forecasting model[J]. Industrial Engineering and Management, 2023, 28 (03): 176 - 186.

[3] Zhang Jing, Liu Jifang, Zhou Xiangyang, et al. Analysis of the vegetable market situation in 2022 and outlook for 2023[J]. Chinese Vegetables, 2023, (01): 1 - 6.

[4] Yuan Jingting, Li Cuixia. Study on Dual-Channel Dynamic Pricing Mechanism of Dairy Products Considering Quality Loss and Random Demand [J]. Modern Management, 2023, 43 (06): 108 - 119.

[5] Yang N. The unique role in the solution of multicollinearity problems by ridge regression analysis [J]. Statistics and Decision Making, 2004 (3): 14 - 15.

[6] He Jinting, Chen Xingyan, Tao Tao, et al. Research on Furniture Order Demand Forecasting Method Based on SARIMA-BP Combination Model [J]. Furniture and Interior Decoration, 2024, 31 (02): 26 - 30.

[7] Zhou Xiangyu, Li Si. Short-term Forecasting of Express Delivery Volume in Jiangsu Province Based on TOPSIS Criteria and SARIMA Model [J]. Science and Technology & Industry, 2023, 23 (17): 136 - 142.

[8] Tang Jingyun, Xi Xin, Zhao Peng. Optimization of LSTM Model Based on Sales Forecasting [J]. Journal of Taiyuan Normal University (Natural Science Edition), 2024, 23 (01): 45 - 52.

[9] Liu Feng, Wang Rujing, Li Chuanxi. Application of ARIMA model in agricultural product price prediction [J]. Computer Engineering and Applications, 2009, 45 (25): 238 - 239+248.

[10] Fan Yingjie, Zhang Qing. Short-term prediction of heating energy consumption in green buildings based on time series autoregressive model [J]. Computer Measurement and Control, 2023, 31 (04): 289 - 294.

Downloads

Published

12-08-2024

How to Cite

Yu, F. (2024) “Study on Pricing and Replenishment Decision of Vegetable Products Based on SARIMA Model”, Transactions on Computer Science and Intelligent Systems Research, 5, pp. 1379–1386. doi:10.62051/qex0yt47.