Skip to content

KPIs

Overview

The main goal of the TOP dashboard project is to have KPI's on the truck, the driver and the client and slice it by various dimensions.

TOP

KPQ

Product/Service: How can we detect quickly that the TCO of a truck is off target?

Sales: How can we know which client is strong in what geographical region according to revenue, loading meters, load & unload times?

Financial: How can we know the costs and revenues per driver? Also per truck, region, division...

Divisions

  1. City Trailers (Benelux)

  2. C/R (Combi)

  3. T/O (Big Trailers)

  4. /A Multi subcontractors

  5. O/A Benelux

  6. External

Product/Service

  • TCO -> not elaborated on this during consulting

Sales

  • How is the distribution of our revenue per client in a specific region/country?
  • What are the load & unload times for every client?
  • What are the average loading meters per client?

Financial

  • What is the revenue per truck/driver/client/division/region?
  • What are the costs per truck/driver/client/division/region?
  • What is the profitability per truck/driver/client/division/region?
  • How can we improve our profitability?

KPIs

Profitability

\(R\) = Revenue
\(C^{Total}\) = Total cost
\(C^{Variable}_{km}\) = Variable cost per Km
\(C^{Vast}_{km}\) = Fixed cost per Km (given in Excel)
\(C^{Overhead}\) = Overhead Cost

\(C^{Peage}_{km}\) = Peage cost per Km
\(WD\) = Work day -> days on which at least 1 entry in TX Connect

Profit

\[ E = R - C^{Total} - C^{Overhead} \]

Special Case External (License number 9900)

\[ E^{External} = R - C^{Total} \]

Revenue

  • \(R_{WD} = \frac{R}{\#WD}\): Revenue per working day

  • \(R_h = \frac{R}{\#hour}\): Revenue per hour

  • \(R_{km} = \frac{R}{\#km}\): Revenue per kilometer

Cost

\(C^{Overhead} = C^{Overhead}_{WD} * \#WD\)

with \(C^{Overhead}_{WD}\) provided in Excel

  • \(C_{h} = \frac{C^{Total}}{\#h}\)

  • \(C_{km} = \frac{C^{Total}}{\#km}\)

  • \(Peage\% = \frac{C^{Peage}}{C^{Total}}\)

Drops per day

\(\#Drops_d=\frac{\#{Drops}}{\#days}\), for a given time period

Where a drop is an unload.

Number of Pallets

\(\#Pallets = \frac{1}{2}\cdot\#M^{load}\)

Where \(M^{load}\) is the number of load-meters.

(un)Loading Time

\(t^{load}_{pallet} = \frac{t^{load}}{\#Pallets}\)

\(t^{unload}_{pallet} = \frac{t^{unload}}{\#Pallets}\)