Vegetable Replenishment and Pricing Planning Based on ARIMA Forecasting

Authors

  • Xinchao Shao
  • Fuxi Xiao
  • Fansheng Sun

DOI:

https://doi.org/10.54097/7hq45336

Keywords:

Unitary Linear Regression, ARIMA, Nonlinear Programming, Replenishment and Pricing.

Abstract

In fresh food supermarkets, vegetables have a short shelf life and can deteriorate quickly, necessitating daily replenishment and pricing decisions based on historical sales to maximize profits. This article, based on the historical sales data of vegetable products from a major supermarket, constructs a replenishment and pricing planning model based on ARIMA forecasting for six types of vegetables, seeking the optimal replenishment and pricing strategy for the next seven days. The results indicate that leafy and flowering vegetables, as well as eggplant-type vegetables, require more replenishment on Fridays and weekends, whereas aquatic root vegetables need more on Thursdays and Fridays. The replenishment of chili vegetables and edible mushrooms fluctuates, and there is a constraint relationship between pricing and replenishment volume. This study aims to assist merchants in making reasonable replenishment and pricing decisions to reduce costs and maximize economic benefits.

Downloads

Download data is not yet available.

References

Dharavath R, Khosla E. Seasonal ARIMA to Forecast Fruits and Vegetable Agricultural Prices[C]//2019 IEEE International Symposium on Smart Electronic Systems (iSES) (Formerly iNiS). IEEE, 2019.

Biao Z, Lingxian Z, Zetian F U, et al. Analysis and Forecast of Vegetable Price Trend Based on Seasonal Index[J]. Northern Horticulture, 2017.

Fengyan F. Study on the pricing model of fresh commodities in supermarket [D]. Fujian Normal University, 2020.

Wujun, Cao, Xiali, et al. Pricing Policy of Supermarket's Fresh Agricultural Products Based on Demand-Price Elasticity[C]//The. 2012.

Tang C S, Rajaram K, Alptekino. Lu A, et al. The Benefits of Advance Booking Discount Programs: Model and Analysis [J]. Management Science, 2004, 50(4):465-478.

Jia J, Hu Q. Dynamic ordering and pricing for a perishable goods supply chain [J]. Computers & Industrial Engineering, 2011, 60(2):302-309.

Shukla M, Jharkharia S. Applicability of ARIMA Models in Wholesale Vegetable Market: An Investigation [J]. International Journal of Information Systems and Supply Chain Management (IJISSCM), 2013, 6(3):105-119.

Mingming Z, Yipeng H, Junqin W, et al. Forecast of Vegetable Prices in China Based on ARMA Model——A Case Study of Cabbage, Cucumber and Tomatoes[J]. Journal of Changjiang Vegetables, 2015.

Minmin Z. Research on dynamic pricing strategy of fresh community supermarket based on time context A [D]. Southwest University of Finance and Economics, 2022.

Mi1randa Suci, Helia Vembri Noor. Quantitative analysis on the fluctuation of vegetable price in supermarket [J]. MATEC Web of Conferences, 2018, 154.

Downloads

Published

09-05-2024

How to Cite

Shao, X., Xiao, F., & Sun, F. (2024). Vegetable Replenishment and Pricing Planning Based on ARIMA Forecasting. Highlights in Business, Economics and Management, 33, 317-323. https://doi.org/10.54097/7hq45336