Research on Vegetable Product Replenishment Decision Based on K-means Algorithm

Abstract

The decision-making and pricing of supermarket restocking is a complex task that requires considering factors such as market demand, supply changes, and operating costs, making scientific and accurate decisions, providing customers with rich and fresh vegetable products, and promoting sustainable development. The pricing of vegetables in supermarkets generally adopts the "cost plus pricing" method, and supermarkets will formulate reasonable sales prices based on comprehensive considerations such as procurement costs, transportation costs, and operating costs. For products that may be damaged during transportation and have poor product quality, supermarkets usually offer discounts to meet customer needs and reduce food waste. This article first uses Excel software to describe and statistically analyze the data, transpose and visualize the data. Then, using the K-means algorithm in cluster analysis, the distribution patterns and interrelationships of vegetable categories and single product sales were analyzed in more detail. Finally, using Excel software, calculate the cost plus pricing for each vegetable category based on the formula "cost plus pricing=unit cost (1+cost profit margin)", and reasonable analysis is carried out according to the calculation results.This study on the calculation of cost-plus pricing for each vegetable category is of great significance to ensure the economic benefits of vegetable suppliers, improve the sustainability of agricultural production, optimize resource allocation, enhance market competitiveness, and promote the healthy development of the vegetable industry.