Data indicators that should be paid attention to in supply chain operation

(1) Inventory turnover rate. Inventory turnover rate is the number of inventory turnover in a certain period, also called inventory turnover rate. The greater the turnover rate, the better the sales situation.

Inventory turnover rate can be calculated by quantity or amount, and the formula is:

Inventory turnover rate = total issue quantity (amount) in a certain period/average inventory quantity (amount) in this period ×100%;

Where average inventory quantity (amount) = inventory quantity at the beginning (amount+inventory quantity at the end (amount) /2.

For example, if the annual sales of a product is 6.5438+0 million yuan and the average inventory amount is 250,000 yuan, its inventory turnover rate is 654.38+000/25 = 4.

(2) Inventory turnover days. Inventory turnover days refers to the number of days that an enterprise experiences from product warehousing to consumption and sales. The less turnover days, the faster zero inventory/inventory can be realized. (But the inventory is too small to meet the needs of circulation, so the inventory turnover days are not as few as possible. )

The calculation formula of inventory turnover days is:

Inventory turnover days =360/ year inventory turnover times

Inventory turnover times = annual sales cost/annual average inventory amount

Average inventory amount = (beginning amount+end amount) /2

That is, inventory turnover days =360/ annual inventory turnover times = 360/ (annual sales cost/average inventory amount) =360/{ annual sales cost/(inventory amount at the beginning of the year+inventory amount at the end of the year) /2} = 180* (inventory amount at the beginning of the year+inventory amount at the end of the year)/sales cost.

For example, if the annual sales of a product is 6,543.8+0,000 yuan and the average inventory amount is 500,000 yuan, the inventory turnover times are 654.38+0,000/50 = 2, and the inventory turnover days are 360/2 = 654.38+0,80 days.

(3) Order inventory satisfaction rate. The order inventory satisfaction rate refers to the percentage that all the products in the order are in the inventory system when the customer issues the order demand, and can meet the customer demand immediately. The lower the satisfaction rate, the greater the probability of shortage (but it does not mean that there will be shortage).

The calculation of inventory satisfaction rate is mathematically expressed by probability, that is, the probability that the current inventory can meet all orders.

(4) Warehouse shortage rate. The out-of-stock rate of warehouse reflects the information of the degree of influence on customer demand due to insufficient storage or poor management of goods in logistics warehousing.

Out-of-stock rate is a reverse index to measure the level of warehousing service. The greater the shortage rate data, the worse the service level.

Warehouse shortage rate can be calculated according to orders, or according to goods or quantity. The calculation formula is:

Warehouse shortage rate = shortage quantity/demand × 100%

For example, an inventory received a customer order 1000 yesterday, and was short of 50 orders, so the warehouse shortage rate =50/ 1000* 100%=5%.

(5) Safety stock. Safety stock is a buffer stock to prevent uncertain factors of future material supply or demand, such as a large number of sudden orders, unexpected interruption or sudden delay in delivery. ). Its size depends on the uncertainty of supply and demand, customer service level (or order satisfaction rate), shortage cost and inventory holding cost.

(6) Procurement preparation time. Procurement lead time refers to the time required for commodity procurement, from placing a purchase order to the whole cycle of supplier stocking, supplier delivery to the target warehouse and warehousing;

(1) warehouse material throughput. Refers to the throughput of goods in the warehouse, that is, the quantity of all goods in and out, reflecting the workload and receiving and sending capacity of the warehouse during this period.

The calculation formula is:

Material throughput = material incoming quantity+material outgoing quantity+material outgoing quantity.

(2) Receiving and sending error rate. The error rate of receipt and delivery refers to the ratio of the cumulative number of receipt and delivery errors in the calculation period to the total number of receipt and delivery items in the same period. It reflects the accuracy of warehousing and warehousing, and is also an index to measure the quality of goods warehousing and warehousing.

The calculation formula is:

Receipt and delivery error rate = cumulative receipt and delivery error items in the calculation period/total receipt and delivery items in the same period.

(3) Library capacity. Warehouse capacity refers to the quantity of goods that the warehouse can hold, and it is one of the indexes to evaluate the quality of the warehouse. Storage capacity is the maximum number of items that can be stacked in the warehouse after removing the necessary passages and gaps.

(4) Utilization ratio of warehouse area. The utilization rate of warehouse area is the ratio of the used area of warehouse to the total construction area of warehouse. The utilization rate of warehouse area is an important indicator to measure the utilization degree of warehouse, and it is also one of the main economic indicators to reflect the management level of warehouse.

(5) Utilization rate of warehouse capacity. The utilization rate of warehouse capacity is the ratio of the actual quantity or volume of goods in stock to the quantity or volume that the warehouse should store. The higher the capacity utilization rate of the warehouse, the higher the actual area utilization rate of the warehouse.

(6) Inventory accuracy. Inventory accuracy is the proportion of items whose physical inventory is consistent with the book inventory, which reflects the management level of the warehouse and is directly related to any factors that affect the change of physical inventory, such as warehousing, warehousing and in-warehouse management.

The calculation formula is:

Inventory accuracy = the number of items whose physical inventory is consistent with the book inventory/the total number of items × 100%.

(1) Timely delivery rate of orders. The timely delivery rate of orders is the rate at which enterprises can deliver orders to customer service according to the promised time. It is the key index for enterprises to satisfy customers, which directly affects the reputation of enterprises and the number of orders.

Calculation formula:

Order timely delivery rate = number of orders delivered on time/number of orders to be delivered × 100%.

(2) Order return rate. Return rate refers to the proportion of products that are returned for various reasons after being sold. The order return rate is an indicator of service, commodity quality and commodity price.

Calculation formula:

Order return rate = number of returned orders/total number of orders sold in the same period × 100%.

(3) Time limit for order fulfillment. The limit of performance is the whole cycle time from placing an order to sending the package to the customer for signature. The efficiency of order fulfillment reflects the storage capacity, logistics distribution capacity and system circulation capacity of enterprises. If the performance limit is too long, it is necessary to analyze in detail which link is the problem and optimize it accordingly.

Calculation formula:

Order execution limit = order signing time-order release time

(4) Order opening rate. When the goods of an order cannot be sent from one warehouse, it needs to be split into multiple orders and sent from different warehouses. The split rate reflects the rationality of inventory distribution. With a high rate of bill removal, the logistics cost will also rise, and the user experience will also decline because users have to collect parcels many times.

Calculation formula:

Order opening rate = number of opening orders/total number of delivery orders in the same period × 100%.

(5) flattening effect. Xiao Ping generally considers the sales volume of stores or warehouses, which refers to how much turnover can be generated per ping area. Xiao Ping represents the productivity of a store area, and productivity represents efficiency. The higher the floor efficiency, the better the operation of the store.

The calculation formula of lawn effect is:

Efficiency = average daily turnover/shop area

(1) gross profit margin. Gross profit margin is the percentage of gross profit and sales income (or operating income). Gross profit margin reflects the value-added part of a commodity after its production is transformed into an internal system, that is, the more value-added, the more gross profit will naturally be.

Calculation formula:

Gross profit margin = (total sales revenue-product sales cost)/total sales revenue × 100%

(2) net interest rate. Refers to the comparative relationship between net profit (the amount after deducting income tax from the total profit of the current period, that is, the after-tax profit of the enterprise) and sales revenue, which is used to measure the ability of the enterprise to obtain sales revenue in a certain period of time. How much operating profit can this index cost achieve?

The calculation formula is:

Net profit rate of sales = (net profit/sales revenue) × 100%

(3) Inventory cost. Inventory cost refers to all kinds of expenses incurred in the process of ordering, purchasing and storing inventory, as well as economic losses caused by inventory shortage. It generally includes:

Acquisition cost. Refers to the cost of purchasing goods and obtaining the ownership of goods, which usually includes purchase price, freight and miscellaneous fees, loading and unloading fees, etc.

Order cost. Refers to the relevant expenses incurred in the process of ordering, including the expenses of purchasing department, document processing fees in the process of ordering, post and telecommunications fees, etc.

Storage cost. Refers to the expenses incurred in the storage process, including the management fee, rent, depreciation fee, repair fee, insurance premium and interest on occupied funds of the warehouse house.

Out of stock cost. Refers to the economic losses caused by the failure to store enough inventory to meet the needs of production and operation, such as shutdown loss caused by inventory shortage, marginal profit loss caused by production reduction, fines paid for delayed delivery, and loss of goodwill.

(4) Accounts payable. Accounts payable is the part that should be paid for the purchase of raw materials (sales cost), while accounts receivable is the part that should be recovered from sales income, which is reflected in the income statement and expenditure, but it has not been realized.

Accounts receivable reflect the bargaining power of enterprises to downstream customers, while accounts payable reflect the bargaining power of upstream suppliers. Therefore, in procurement and supply chain management, strengthening the management and control ability of procurement to suppliers will help improve the bargaining power and competitiveness of the company.

Comparative gross profit margin: if (accounts receivable-accounts payable)/accounts receivable >; Gross profit margin, the overall bargaining power of the enterprise is weak (income is confiscated, but payment is made), otherwise the bargaining power is strong.

(5) the ratio of production to demand. The production and sales rate refers to the ratio of the number of products produced by an enterprise to the demand of its users for the product in a certain period of time.

Production and demand rate = the number of products produced by node enterprises in a certain period of time/the demand of upper node enterprises for this product in a certain period of time.

This index reflects the relationship between supply and demand between the upper and lower node enterprises. The closer the production and demand rate is to 1, it shows that the supply and demand relationship between the upper and lower nodes is coordinated and the on-time delivery rate is high. On the contrary, it shows that the on-time delivery rate of subordinate node enterprises is low or the enterprises are comprehensive.