Automated Pricing and Replenishment Decisions for Vegetable Products Based on Data Analysis

Authors

  • Yefan Shen
  • Yongkang Zhao
  • Xinwei Hao

DOI:

https://doi.org/10.54097/p8h08r67

Keywords:

Pearson Correlation Coefficient, Linear Regression Model, ARIMA Model, Greedy Algorithm.

Abstract

This study delves into the critical factors for the successful operation of vegetable products supermarkets: efficient inventory management and accurate market demand analysis. Given the perishability of vegetables, their variety, and the complexity of supply chains, a linear regression model and the method of least squares have been developed to estimate model parameters. Additionally, the ARIMA model is utilized to forecast the unit prices of commodities. In a more comprehensive approach, considering various influencing factors, a combinatorial optimization algorithm (integrating linear regression and greedy algorithm) is employed to determine the optimal replenishment strategy. Based on this, the study forecasts the sales volume and unit prices for various categories over the next seven days, and accordingly, establishes the pricing strategy and predicted replenishment volume for each category. The research underscores the necessity for retailers to precisely analyze sales data and market trends, optimize supply chain management, and formulate effective pricing strategies to cope with seasonal variations and limited sales space. These measures are essential to satisfy consumer demand and enhance profitability.

Downloads

Download data is not yet available.

References

Wang X. Joint Decision Making of Replenishment, Pricing, and Fresh Keeping Input in Fruit and Vegetable Cold Chain: Based on Markov Process[J]. Mobile Information Systems, 2022, 2022.

Kaya O, Bayer H. Pricing and lot-sizing decisions for perishable products when demand changes by freshness[J]. Journal of Industrial and Management Optimization, 2020, 17(6): 3113-3129.

Chen W, Liu H, Xu D. Dynamic pricing strategies for perishable product in a competitive multi-agent retailers’ market[J]. Journal of Artificial Societies and Social Simulation, 2018, 21(2).

Fattah J, Ezzine L, Aman Z, et al. Forecasting of demand using ARIMA model[J]. International Journal of Engineering Business Management, 2018, 10: 1847979018808673.

KumarMahto A, Biswas R, Alam M A. Short term forecasting of agriculture commodity price by using ARIMA: based on Indian market[C]//Advances in Computing and Data Sciences: Third International Conference, ICACDS 2019, Ghaziabad, India, April 12–13, 2019, Revised Selected Papers, Part I 3. Springer Singapore, 2019: 452-461.

Matyjaszek M, Fernández P R, Krzemień A, et al. Forecasting coking coal prices by means of ARIMA models and neural networks, considering the transgenic time series theory[J]. Resources Policy, 2019, 61: 283-292.

Azadi Z, Eksioglu S D, Eksioglu B, et al. Stochastic optimization models for joint pricing and inventory replenishment of perishable products[J]. Computers & industrial engineering, 2019, 127: 625-642.

Du W, Zuo Y. How to Set Reasonable Prices for Vegetable Products? A Comprehensive Model Study Based on Multiple Algorithms[J]. Highlights in Science, Engineering and Technology, 2023, 70: 456-462.

Galda I. Literature Review-Dynamic Pricing in Food Supply Chains[J]. 2022.

Khan M A A, Shaikh A A, Panda G C, et al. Inventory system with expiration date: Pricing and replenishment decisions[J]. Computers & Industrial Engineering, 2019, 132: 232-247.

Downloads

Published

16-05-2024