17 supply chain KPIs every supply chain manager needs

17 supply chain KPIs every supply chain manager needs

The 17 key metrics for supply chain management, from perfect order rate to inventory velocity, each with a short explanation, formula and benchmarks.

by Tonnis de Boer

October 10, 2017

Supply chain platform illustration for the article on supply chain KPIs

Supply chain managers deal with more process variation, shorter lead times and a growing need to manage by exception. To make fast decisions, you need KPIs that are simple, easy to interpret and that support your decisions. Better still are actionable insights: a KPI combined with the action you should take when it moves.

Below are 17 supply chain KPIs, grouped by theme, each with a short explanation and a formula.

Order and delivery KPIs

1. Perfect order measurement

The percentage of orders delivered without errors. Errors can occur in forecasting, warehouse picking, invoicing and shipping. Many companies break the KPI down by stage, for example: procurement 99.99%, production 99.12%, transportation 99.02% and warehousing 99.98%.

Formula: ((total orders - orders with errors) / total orders) x 100

2. Customer order cycle time

How long it takes to deliver a customer order after you receive the purchase order. You can measure the actual cycle time or the promised cycle time.

Formula (actual): actual delivery date - purchase order creation date

Formula (promised): requested delivery date - purchase order creation date

3. Fill rate

The percentage of a customer's order that is filled with the first shipment. You can measure it in items, SKUs or order value. Fill rate affects both customer satisfaction and transport efficiency.

Formula: (1 - ((total items - shipped items) / total items)) x 100

4. On-time shipping rate

The percentage of items, SKUs or order value shipped on or before the requested date. A high rate points to an efficient supply chain and supports customer satisfaction.

Formula: (number of items shipped on time / total items) x 100

5. Supply chain cycle time

How long it would take to fill a customer order if you had no inventory at all. A short cycle time indicates an efficient, agile supply chain.

Formula: sum of the longest lead times for each stage of the cycle

Freight KPIs

6. Freight bill accuracy

The percentage of freight bills without errors. Billing accuracy affects both profitability and customer satisfaction.

Formula: (error-free freight bills / total freight bills) x 100

7. Freight cost per unit

The freight cost per item or SKU. The goal is to keep it as low as possible.

Formula: total freight cost / number of items

Cash flow KPIs

8. Cash-to-cash cycle time

The number of days between paying for materials and getting paid for your product. It shows how long working capital is tied up. A short cycle indicates a lean, profitable supply chain. It is usually averaged per week, month or quarter. When many materials are involved, use a weighted average materials payment date.

Formula: customer order payment date - materials payment date

9. Days sales outstanding

How quickly you collect revenue from customers. The lower, the better.

Formula: (receivables / sales) x days in period

10. Average payment period for production materials

The average time between receiving materials and paying for them. A longer period is better for your cash position.

Formula: (materials payables / total cost of materials) x days in period

Inventory KPIs

11. Inventory days of supply

The number of days it would take to run out of stock without replenishment. Keeping this low reduces the risk of excess and obsolete stock and frees up cash.

Formula: inventory on hand / average daily usage

12. Inventory turnover

How many times your inventory cycles per year. Higher turnover points to an efficient supply chain.

Formula: cost of goods sold / average inventory

13. Inventory turnover ratio (ITR)

How many times the average inventory in your warehouse is sold or turned. It is calculated as the cost of goods sold (COGS) divided by the average inventory investment.

Formula: COGS / ((opening stock + closing stock) / 2)

There is no single standard. Typical targets by type of organisation:

  • product leaders: 3 to 4
  • operational excellence organisations, such as low-cost airlines and wholesalers: 8 to 9
  • distributors with a wide range of brands: 5 to 7

The right target also depends on the gross margin of the SKUs or brands involved.

14. Turn-earn index (TEI)

TEI combines gross margin and inventory turnover. SKUs or brands with a low margin should have a high ITR. SKUs or brands with a high margin can accept a medium or low ITR.

Formula: ITR x gross profit % x 100

A TEI of 150 to 180 is considered best practice. For example, a TEI of 160 can mean a 20% margin with 8 turns per year, or a 40% margin with 4 turns per year.

15. Gross margin return on investment (GMROI)

The gross profit you earn for every euro (or other currency unit) invested in average inventory. Track it monthly to see which SKUs or brands generate the most gross profit from their inventory.

Formula: gross profit / ((opening stock + closing stock) / 2) x 100

A GMROI of 200 to 225 is considered best practice.

16. Days of supply (DOS)

A common efficiency KPI, calculated per month.

Formula: (average inventory / monthly demand) x 30

There is no fixed target. Compare DOS with the upcoming sales forecast to set stock levels. DOS does not tell you how well your inventory matches demand. For that you need inventory velocity.

17. Inventory velocity (IV)

The percentage of your opening stock that is expected to be consumed in the next period. IV shows how well inventory matches demand and helps you prevent excess stock.

Formula: opening stock / next month's sales forecast

Benchmarks:

  • continuous SKUs: 60 to 70%
  • fast-moving SKUs: 75 to 80%
  • below 60%: excess stock
  • above 80%: risk of stock-outs, which calls for a Kanban pull system

Segment your SKUs before you measure

Not every SKU should be treated the same way. Use the Pareto principle to classify SKUs as fast-moving, continuous, intermittent or slow-moving. You can base the classification on monthly sales volume, margin percentage or number of warehouse exits, and use the average of the three weightings. Then apply the right KPIs and targets to each group.

This list builds on 12 key metrics for supply chain management by Mamta Sethi.

Want real-time insight into supplier confirmations and delivery performance? Book a demo.