Supply Chain KPIs

Here are the main KPIs for the Supply Chain. They are part of the Supply Chain Dashboard or  Balanced Scorecard.

Please see the following table.

-> Recommended bibliography about the Supply Chain KPIs

Activity Subject Calculation
Corporate data and structure Gross sales
COGS (Cost Of Goods Sold) or Cost of sales COGS = Beginning Merchandise Inventory + Net Purchases of Merchandise – Ending Merchandise
Total logistics cost as % of COGS Logistics cost ÷ COGS
Logistics network Number of Warehouses
Number of branches
Suppliers Number of suppliers
Number of A suppliers ABC Classification (A class represents 80% of the purchase amount)
A suppliers as % of total suppliers Number of A suppliers ÷ total number of suppliers
Products Product families managed % of turnover represents by product family 1, 2, 3, …
Flows Flows per distribution channels % of total flow represented by flow 1, 2, 3,…
Logistics network Number of Warehouses
Warehouse shipments value (COGS) Value of the warehouse shipments
Warehouse Indoor surface
Warehouse Outdoor surface
Number of deliveries
Number of order lines delivered
Number of employees
Replenishment inter branches Replenishment inter-branches Replenishment from other branches ÷ total replenishment flow
Customer delivery on behalf of other branches Delivery on behalf of other branches as % of total deliveries Delivery on behalf of other branches ÷ total deliveries
Cross-dock – Inventory Warehouses % of the warehouses flows realized through Inventory picking
% of the warehouses flows realized through cross-docking
Branches % of the branches flows realized through Inventory picking
% of the branches flows realized through cross-docking
Inventory Warehouses Inventory level vs target Total warehouses Inventory value
Branches Inventory level vs target Total branches Inventory value
Total Inventory level vs target Total Inventory value
Inventory cover vs target Average value of Inventory ÷ average daily consumption
Shrinkage vs target Total shrinkage value ÷ COGS
Warehouse Costs Number of employees
Payroll
General costs
Equipment
Rent
Others
Total without transport vs target
Transportation between Warehouse – branches
Total Transportation included vs target
Rent as % of Inventory value Rent ÷ Inventory value
Payroll as % of COGS Payroll ÷ COGS
Logistics costs in branches Number of logistics employees
Logistics Payroll
Logistics equipment
Rent of logistics surfaces
Others
Total logistics cost vs target
Rent (logistics surfaces) as % of Inventory value Rent (logistics surfaces)÷ Inventory value
Logistics Payroll as % of COGS Logistics payroll ÷ COGS
Upstream transport Total transport cost vs target
Internal transport cost as % of the total transport cost Internal transport cost ÷ total transport cost
Number of drivers
Payroll
Average cost of a driver Payroll ÷ number of drivers
Equipment (trucks) Value of trucks rent or amortization
Number of trucks
External transport cost External transport cost ÷ total transport cost
Annual volume transported (tons, volumes…)
Capacity use rate Number of hours used ÷ number of hours available during the same period
Capacity used (m3)÷ capacity available (m3) during the same period
Km unloaded rate Number of km realized unloaded ÷ total number of km during the same period
Downstream transport Total transport cost vs target
Internal transport cost as % of the total transport cost Internal transport cost ÷ total transport cost
Number of drivers
Payroll Value of truck drivers salary
Average cost of a driver Payroll ÷ number of drivers
Equipment (trucks) Value of trucks rent or amortization
Number of trucks
External transport cost External transport cost ÷ total transport cost
Total transport cost as % of delivered sales Transport cost ÷ delivered sales value
Annual number of deliveries (or tons, volumes delivered…)
Capacity use rate Number of hours used ÷ number of hours available during the same period
Capacity used (m3)÷ capacity available (m3) during the same period
Km unloaded rate Number of km realized unloaded ÷ total number of km during the same period
Reverse Logistics Total value of goods returned by clients
Total value of goods returned to suppliers
Total value of goods in warehouses
Service Service rate – DIFOT (Delivery In Full On Time) Number of order lines received on time during the considered period ÷ total number of order lines received during the considered period
Product availability Number of product SKUs in shortage ÷ total number of active SKUs
Supply-Chain Dashboard – Balanced scorecard


Recommended bibliography