Abstract:Vegetables have a short period of freshness, and therefore, the purchase of vegetables has to be carefully matched with sales, especially in the "small production and big market" setting prevalent in China. Therefore, it is worthwhile to develop a systematic and comprehensive mathematical model of replenishment plans and pricing strategies for each category of vegetables and individual products. In this paper, we analyze the following three questions: Question One:What is the distribution law and relationship between the sales volume of vegetable categories and single products? Question Two: What is the relationship between total sales volume and cost-plus pricing of vegetable categories? And is it possible to provide the daily total replenishment and pricing strategy of each vegetable category for the following week to maximize supermarket profit? Question Three: How can we incorporate the market demand for single vegetable products into a profit-maximizing program for supermarkets? Is it possible to further formulate the replenishment plan requirements for single products? To answer the first question, we created pivot tables to analyze occupancy. We found that mosaic leaves, peppers, and edible mushrooms accounted for a larger proportion of occupacy, while cauliflowers, aquatic rhizomes, and eggplants accounted for a smaller proportion. For the single items, lettuce, cabbage, green pepper, screw pepper, enoki mushroom, and shiitake mushroom accounted for a large proportion of their respective categories. We used the Pearson correlation coefficient and the Mfuzz package based on fuzzy c-means (FCM) algorithm to analyze the correlation between vegetable categories and single products. We found that there was a strong correlation between vegetable categories. Moreover, the sale of vegetable items belonging to the same category exhibited the same patterns of change over time. In order to address the second question, we established the LightGBM sales forecasting model. Combined with previous sales data, we forecasted and planned an efficient daily replenishment volume for each vegetable category in the coming week. In addition, we developed a pricing strategy for vegetable categories to maximize supermarket profits. For the third question, we built a dynamic programming model combining an optimal replenishment volume with a product pricing strategy for single items, which let the supermarket maximize its expected profits.

A Study on Pricing and Replenishment of Vegetable Commodities Based on Goal Planning and Time Series Forecasting Models

Research On LSTM-Based Pricing Strategy for Vegetable Category Wholesale Price Prediction and Multi-Objective Planning

Automatic Pricing and Replenishment Decision-Making for Vegetable Commodities Based on Bi-directional Long Short-Term Memory Recurrent Neural Networks and Markov Prediction Models

Pricing and Replenishment Prediction Model for Vegetable Commodities Based on Mixed Integer Linear Programming Optimization XGBoost

Research on Pricing and Replenishment Strategies of Supermarket Vegetables Based on LSTM Neural Network and Goal Planning

Optimization of vegetable commodity replenishment and sales strategy based on time series model and multiple linear regression model

Research on accurate prediction of vegetable commodity pricing strategy and dynamic replenishment quantity based on optimization model

Replenishment And Automatic Pricing Strategy for Vegetable Products Based on Genetic Algorithm

Prediction and Replenishment Decision Making for Automatic Pricing of Vegetable Commodities Based on LSTM Models

Automatic Pricing and Replenishment Strategy for Vegetable Products Based on Time-Series Analysis and BP Neural Fitting

Random Forest-Based Restocking and Pricing Prediction for Vegetable Items

Study on the pricing and replenishment of vegetable commodities based on the optimization model

Research on Vegetable Cost Pricing and Sales Forecast Based on PSO Optimization and Forecast Model

Optimization Of Replenishment and Sales Strategies of Vegetable Commodities Based on Multiple Linear Regression and Non-Linear Programming

Automatic Pricing and Replenishment Decision for Vegetable Products based on Planning Model and Regression Algorithm

Optimization Of Vegetable Sales Strategies and Daily Replenishment in Supermarkets

Research on the Optimization of Pricing and the Replenishment Decision-Making Problem Based on LightGBM and Dynamic Programming

An ARIMA-based study of pricing and replenishment decisions for vegetable commodities

Optimization of Vegetable Restocking and Pricing Strategies for Innovating Supermarket Operations Utilizing a Combination of ARIMA, LSTM, and FP-Growth Algorithms

Research on Establishing Inbound Strategies for Supermarkets based on LSTM and Gaussian Process Regression Modeling

Data-Driven Approach to Enhancing Supermarket Vegetable Sales Strategies