Analysis Of Decision-Making Mechanism for Pricing and Replenishment of Vegetable Commodities Based on Least Squares And ARIMA
DOI:
https://doi.org/10.54097/cxd2wt73Keywords:
Vegetable commodities, Pricing replenishment, least squares, ARIMA prediction, Optimization.Abstract
This study provides an in-depth study of automatic pricing and replenishment decision-making mechanisms for vegetable commodities based on the relevant data provided. In the research process, firstly, the data were carried out for pre-processing. Secondly, a one-way linear regression model was developed using the least squares method to investigate the relationship between sales volume and cost-plus pricing for each category. The resulting one-dimensional linear regression equations were well fitted, with goodness of fit R2 greater than 0.6. Then, based on the data characteristics of the different categories, appropriate values of q, d and p were selected and a time series (ARIMA) model was built to predict the wholesale price of each category in the coming week. With the final superstore profit as the objective function and the total daily replenishment as the decision variable, an optimization model was constructed for determining the daily replenishment and pricing strategy of each category, and a sensitivity analysis of the model was conducted.
Downloads
References
Cui Xiuhong, Zhang Jiangwei. Vegetable prices have risen, grain and oil prices remain stable: Comments on Beijing Wholesale Price Index of Agricultural Products in December 2020 [J]. Price Theory and Practice,2020(12):160.
https://www.cnhnb.com/hangqing/
Kourosh S M, A. S F. Selecting representative geological realizations to model subsurface [formula omitted] storage under uncertainty [J]. International Journal of Greenhouse Gas Control,2023,127.
Yuan K,Liu H,Han Y. Differential Item Functioning Analysis Without A Priori Information on Anchor Items: QQ Plots and Graphical Test [J]. Psychometrika,2021,86(2).
Wang Ya Nan, Liu Chang. Spearman: From the establishment of the two-factor Theory of Intelligence to the breakthrough in methodology [J]. Journal of Nanjing Normal University (Social Sciences Edition),2011(06):95-101.
He Ling, Wu Lingda, CAI Yichao. Application Research of Computers,2007(01):10-13. (in Chinese)
http://www.nmc.cn/publish/observations/hourly-temperature.html
Fatemeh A, Sanaz S, Taha K, et al.Roadmap for outlier detection in univariate linear calibration in analytical chemistry: Tutorial review[J].Journal of Chemometrics,2022,37(1).
Lei Yu, Zhao Danning, CAI Hongbing et al. Singular spectrum analysis and integrated ARIMA model to predict day long change [J/OL]. Journal of wuhan university (information science edition): 1-17 [2023-09-10].
Xiaohui Y, Zezhong H, Riying X, et al.Optimisation and analysis of an integrated energy system with hydrogen supply using solar spectral beam splitting pre-processing[J].Energy,2024,287.
Downloads
Published
Issue
Section
License
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
