## Transportation KPIs

Here are the main KPIs for the Transportation They are part of the Transport Dashboard or Balanced Scorecard.

Please see the following table.

-> Recommended bibliography about transportation KPIs

Activity | Subject | Calculation |

Cost | Cost value evolution vs. Budget | |

Cost value as a % of COGS evolution vs. budget | COGS Cost of Goods Sold = Beginning Merchandise Inventory + Net Purchases of Merchandise – Ending Merchandise | |

Transport cost / transported value (at cost) | Can be detailed by internal and subcontracted transport, by transportation means… | |

Average cost for 1 order line, m3, ton, palet,… transported | ||

Upstream transport cost | Total transport cost | |

Internal transport cost ÷ total transport cost | ||

External transport cost ÷ total transport cost | ||

Value of trucks rent or amortization | ||

Transport cost ÷ COGS | ||

Downstream transport cost | Total transport cost | |

Internal transport cost ÷ total transport cost | ||

External transport cost ÷ total transport cost | ||

Value of trucks rent or amortization | ||

Transport cost ÷ COGS | ||

Upstream transport | Equipment (trucks) | Number of trucks |

Activity | Number of km, number of hours in use, number of point of collect per day … | |

Value of goods transported (at cost)÷ COGS | ||

Average number of stops per trip | ||

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 | Equipment (trucks) | Number of trucks |

Activity | Number of km, number of hours in use, number of deliveries…. per day | |

Value of goods transported (at cost)÷ COGS | ||

Average number of stops ÷ trip | ||

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 | |

Quality | Transport discrepancies | Total value of lost products (at cost) ÷ total value of goods transported (at cost) during the same period |

Dispute | Number of order lines in dispute ÷ Total number of order lines delivered during the same period | |

Goods amount delivered in dispute (at cost) ÷ Total goods amount delivered (at cost) during the same period | ||

Service | Deliveries on time rate | Number of deliveries on time ÷ total number of deliveries during the same period |

HR | Productivity | Number of customers orders dispatched per day per FTE |

Waiting time per trip, per truck… | ||

Payroll | Value of truck drivers salary | |

Number of drivers | ||

Average cost of a driver | Payroll ÷ number of drivers |