Optimization of vegetable commodity replenishment and sales strategy based on time series model and multiple linear regression model

Ke Xu; Wenqin Chen; Chengzhi Wang

doi:10.54097/dgjzjh73

Authors

Ke Xu
Wenqin Chen
Chengzhi Wang

DOI:

https://doi.org/10.54097/dgjzjh73

Keywords:

Vegetable commodities, multiple linear regression, time series forecasting.

Abstract

Vegetable commodities have a short freshness period and their quality can change from good to bad. So the study of automatic pricing and replenishment decision of vegetable commodities is of great significance for the superstore itself. In this paper, we first discuss the total sales volume of each vegetable category (cost-plus pricing by single product selling price, wholesale selling price and wastage rate), and use the construction of multiple linear regression model to discuss the relationship between the total sales volume and the above three indicators. Next, the least squares estimation algorithm and Matlab were used to simulate and analyse the correlation between the cauliflower and foliage categories. In order to formulate the total daily replenishment and pricing strategy for the vegetable category in the coming week, a time series model was built to predict the total sales volume for the next 7 days by using 30 days of data changes. Finally, a moving average method is used to forecast the total daily replenishment amount, which maximises the supermarket's profitability.

Downloads

Download data is not yet available.

References

Cai Jianhu,Cao Weizang,Zhou Qian et al. Research on VMI inventory decision-making model for assembly system under supplier output uncertainty environment [J/OL].China Management Science, 1-14[2023-11-08]

Tianjin's "food basket" stable in autumn [N].Tianjin Daily, 2023-08-24 (010).

Zheng L.Research on dynamic bulk inventory replenishment problem of community group-buying retailers [D].Zhongnan University of Economics and Law, 2022.

Lai ZK.Beijing Fengtai makes every effort to protect residents' "food basket"[N].Workers' Daily, 2022-04-26 (004).

Wu YAN.Increasing replenishment frequency to ensure personnel input [N].Shenzhen Special Zone News, 2022-03-15 (A03).

Liang, Shuting.Research on the inventory strategy of community fresh food retail terminal where time and stock quantity jointly affect spoilage rate [D].Beijing Jiaotong University, 2020.

Qiao Yannan.Research on the optimisation scheme of Q supermarket outlet layout based on improved SLP [D].Tianjin University of Finance and Economics, 2020.

Epidemic now, supermarket fresh C position "leading the way", these fresh basic skills must be strengthened [J].Corporate Observer, 2020, (03): 111-113.

ZHANG Jingfang,XIANG Wanli.Application of dynamic buffer inventory model in inventory management of agricultural products [J].Logistics Technology, 2018, 37 (12): 83-88.

HAN HAN GWANG.Research on inventory management programme of frozen products category in community vegetable direct shops in Urumqi [D].Xinjiang Agricultural University, 2017.