Current location - Recipe Complete Network - Catering franchise - Purchasing data analysis
Purchasing data analysis

It is not enough for the purchaser to know how to purchase the goods at the lowest price and the most favorable terms, because as the purchasing agent of consumers, the purchaser must know the consumption characteristics of the target customers from the past sales data and consumer analysis, so as to improve the purchasing efficiency and improve the consumer satisfaction.

application of metadata analysis

1. Performance? =? Number of visitors × unit price =? Number of items sold × unit price =? Rice effect × number of meters =? Per capita productivity value × total working hours =? Turnover per hour × business hours × business days

2. Commodity turnover rate? =? Monthly turnover ÷ monthly average inventory

3. Cross contribution rate? =? Gross profit ÷ average inventory =? Commodity turnover × gross profit margin

4. Unit price? =? Turnover ÷ number of products sold

5. Rice efficiency = turnover ÷ number of meters

6. Average efficiency = turnover ÷ square area

DM data analysis

1. Promotion flexibility: single product performance growth index, which can be used to analyze product selection

2. Gross profit increase and decrease: single product gross profit growth index.

3. Achievement rate of performance and gross profit: it can be used to analyze the accuracy of forecast and promotion effect

4. Promotion proportion: it can be used to analyze the promotion intensity and the rationality of proportion.