Research on Sales Decision of Vegetable Products Based on Time Series Analysis

Wenting Ma; Jiawei Yang; Haitao Zhao

doi:10.62051/169dm530

Authors

Wenting Ma
Jiawei Yang
Haitao Zhao

DOI:

https://doi.org/10.62051/169dm530

Keywords:

Vegetable Sales; Factor Analysis; ARIMA; Genetic Algorithm.

Abstract

This article studies the automatic pricing and replenishment decision-making of vegetable products. Through factor analysis and time series analysis, analyze the inherent laws, and combine mathematical programming with genetic algorithm to make sales decisions for vegetable products. Firstly, the data is preprocessed using time series analysis to predict and fill in missing values from September 12, 2022 to October 14, 2022, when the data is empty. Secondly, the relationship between vegetable types was analyzed. JB and Q_Q tests were conducted on the daily sales of each category, and it was found that the data did not follow a normal distribution. Therefore, this article uses Spearman correlation coefficient to analyze the correlation between different categories and finds that the flavor, taste, or cooking characteristics of edible mushrooms and water rhizomes are complementary and can be used in combination. To analyze the relationship between the sales volume and price of vegetable varieties, this article uses linear regression analysis to find that there is a negative correlation between sales volume and price. Finally, considering the shortcomings of time series analysis and factor analysis models, combined with practical considerations, the data to be collected includes competitor data, seasonal sales data, market trends and consumer insights data, inventory data, weather data, promotion and discount data, purchasing power data, customer feedback and demand data, vegetable supply chain data, and loss rate data.

Downloads

Download data is not yet available.

References

[1] Wang Xiaotong Research on Inventory Control Strategy for Fresh Fruit and Vegetable Products in Chain Supermarkets Based on DIT [D] Southeast University, 2020.

[2] Zeng Minmin Research on Dynamic Pricing Strategy of Fresh Community Supermarkets Based on Time Scenario a [D] Southwest University of Finance and Economics, 2021.

[3] Chen Jun A Study on Ordering Strategy and Supply Demand Coordination of Fresh Agricultural Products Supply Chain Considering Circulation Loss Control [D] Chongqing University, 2009.

[4] Lin Tingting The vegetable sales model, problems, and countermeasures in Lishui District, Nanjing City [J] Shanghai Agricultural Technology, 2022 (01): 1 - 3.

[5] Zhang Fan Research on Agricultural Product Sales Strategies Considering Variable Opacity [D] Tianjin University, 2020.

[6] Cao Han Research on Predicting Sales of Catering Industry Dishes Based on Deep Learning [D] Xi'an University of Technology, 2019.

[7] Liang Shuting. A Study on the Community Fresh Retail Terminal Inventory Strategy with the Joint Influence of Time and Inventory Quantity on Deterioration Rate [D]. Beijing Jiaotong University, 2020.

[8] Mao Lisha. Research on Pricing Strategies and Production and Sales Models of Vegetable Wholesale Market from the Perspective of Supply Chain [D]. Central South University of Forestry and Technology, 2023.

[9] Zhou Xiangyu, Li Si. Short term prediction of express delivery business volume in Jiangsu Province based on TOPSIS criterion and SARIMA model [J]. Science and Industry, 2023, 23 (17): 136 - 142.

[10] Yang Yang, Tian Dingsheng, Zhang Bao'an, et al. Research on Urban Economy and Population Prediction Based on ARIMA Model [J]. Comprehensive Transportation, 2023,45 (11): 79-85+97.