A Study on Replenishment Decision of Vegetable Goods Based on Polynomial Regression and Arima Time Series Forecasting

Authors

  • Zikai Zhao

DOI:

https://doi.org/10.54097/dxay3d51

Keywords:

Regression model; ARIMA time series; Wavelet filter function; vegetable commodity replenishment decisions.

Abstract

In a fresh food superstore, the superstore replenishes daily based on the historical sales and demand of vegetable commodities. To formulate the optimal replenishment decision, this paper analyses the sales flow, purchase cost, and loss of a supermarket in a period, and through the use of a variety of models, it can give a reference opinion on the formulation of automatic pricing and replenishment decisions for vegetable commodities. The first text describes the process of analyzing the relationship between total sales volume and cost-plus pricing, including data integration, preprocessing, and multiple regression analysis methods. Through these analyses, a general relationship between total sales volume and merchandise selling price is identified. Univariate linear regression, polynomial regression, random forest regression, and BP neural network regression models were all used to analyze this relationship. The focus is then on the total daily replenishment and pricing strategy for the coming week to maximize the superstore's revenue. The text details the use of ARIMA time series analysis methods, as well as steps for noise reduction and forecasting using Wavelet wavelet functions. Through these methods, the text provides sales forecast results for different vegetable categories for the coming week for the superstore management's reference.

Downloads

Download data is not yet available.

References

PAN Xiaofei, XIE Zhiheng, WANG Shuyun. Optimal decision-making of fresh food superstore preservation efforts and pricing considering loss aversion [J]. Highway Traffic Science and Technology, 2022, 39(06):177-185+190.

WANG Yongsheng. Research on enterprise value creation path based on core competitiveness evolution [D]. Xi'an University of Technology, 2023.

Du Ji-liang, Hou J, Wu Shangyu et al. Evaluation model of discount strength in shopping malls [J]. Science and Technology Wind, 2019(32):235.

Li Xiaolu, Zhou Shuguang. Research on the Development Problems of China's Fresh Food Supermarket Retail Industry [J]. Commercial Economy Research, 2021(23):35-37.

Ren H.R.,Zhu Y.Y.. Research on data pricing model based on data market type [J]. Big Data, 2023, 9(4):116-138. DOI:10.11959/j.issn.2096-0271.2023052.

Deepa R, Pradeep M, Soumik R, et al. Modelling of rainfall time series using NAR and ARIMA model over western Himalaya, India[J]. Arabian Journal of Geosciences, 2022, 15(23).

Arfaoui S, Mabrouk B A, Cattani C. Wavelet Analysis: Basic Concepts and Applications [M].CRC Press: 2021-01-12.

Zeng St. Exploration on the operation of township superstores under the background of new urbanization [J]. Chinese and foreign entrepreneurs, 2015(08):44-45.

WANG Mengwei, ZHOU Yue, BAI Li et al. Early warning analysis of price fluctuation of spicy vegetables in China [J/OL]. China Melon and Vegetable: 1-16[2023-10-25].

Yanjun Hu, Pingchuan Zhang, Zheng Shang et al. Research on garlic price prediction based on deep learning [J]. Journal of Henan Institute of Science and Technology (Natural Science Edition), 2023, 51(03):35-42.

Downloads

Published

29-03-2024

How to Cite

Zhao, Z. (2024). A Study on Replenishment Decision of Vegetable Goods Based on Polynomial Regression and Arima Time Series Forecasting. Highlights in Business, Economics and Management, 29, 156-163. https://doi.org/10.54097/dxay3d51