Utilization report

The utilization report shows on how many of the expected days each vehicle was used, as a percentage. It sorts your vehicles into actively used, underutilized and not used.

Use it to find vehicles you could sell or share, or to check that the fleet is used evenly.

What is in the report

  • One row is one vehicle, with its figures for the whole period. Every vehicle you chose gets a row, also the ones that did not drive.

  • The report covers whole days in the report’s time zone. You pick dates, not times, in the When step.

  • Expected days are the days a vehicle could be used: every day of the period, or only Monday to Friday. Days that have not started yet are not counted. Today counts as soon as it starts.

  • An active day is an expected day with at least one trip. A trip counts on the day it started.

  • Utilization is the share of the expected days the vehicle was used. A vehicle that drove on 6 of 7 days has 85.7 %.

  • Each vehicle is classified:

    • Actively used – utilization at or above the Underutilized below (%) setting.

    • Underutilized – utilization below that setting, but at least one active day.

    • Not used – no active days at all.

  • Every vehicle gets the same expected days, also a vehicle that was added in the middle of the period.

Settings

For the utilization report the third step is called Settings. It has no filters, so every vehicle you chose is in the report.

Utilization settings

The Utilization settings card with Expected days and Underutilized below
  • Expected days:

    • All calendar days – every day counts. This is the default.

    • Monday to Friday – only weekdays count. Trips made at the weekend are left out of every figure, including the distance, trips and driving time.

  • Underutilized below (%) – a vehicle with a lower utilization is Underutilized, otherwise Actively used. A whole number from 1 to 100, 50 at first. It does not remove any vehicles from the report.

Vehicle order

The Vehicle order card

Sort vehicles by Utilization, Vehicle name, Active days, Distance, Trips or Driving time, Ascending or Descending. At first the least used vehicle comes first.

When the rows are split by period, each vehicle’s rows stay together in date order, and the vehicles are sorted by their totals for the whole period.

Columns

Columns marked ✓ are in the report by default. The vehicle columns can be added too. All figures count only the expected days.

Column

What it shows

Default

Utilization (%)

Active days divided by expected days, as a percentage

✓

Active days

Expected days with at least one trip

✓

Expected days

The days the vehicle could be used, as set in Expected days

✓

Inactive days

Expected days without trips

✓

Distance (km)

How far the vehicle drove on its finished trips

✓

Trips

The number of trips

✓

Driving time

The time spent on trips. A trip still going on counts until the end of the period or until the report was made.

✓

Average distance per active day (km)

How far the vehicle drove on average on the days it was used. Empty for a vehicle without active days.

✓

Last activity

When the last trip ended, or the time the report was made while it is still going on

✓

Utilization classification

Actively used, Underutilized or Not used

Days since last activity

How many days have passed since the vehicle was last used, up to the end of the period or today. 0 means it was used on that day.

Period

The days the row covers: the whole period, or one day, week or month when the rows are split

First activity

When the first trip started

Stop time

The time the vehicle stood parked during its working days, between the first and the last trip of each day

Engine idle time

The time the vehicle stood still with the engine running. Waits shorter than 3 minutes, such as at traffic lights, are not counted.

Average trips per active day and Average driving time per active day

The trips and the driving time on average on the days the vehicle was used

Max daily distance (km)

The longest distance driven in one day

Average daily distance (km)

How far the vehicle drove per expected day, counting the expected days it did not drive

Summary

Every utilization report starts with these figures:

Figure

What it is

Vehicles

The number of vehicles in the report

Fleet utilization (%)

How much of the fleet’s available time was used: the share of all expected vehicle-days with a trip

Expected vehicle-days and Active vehicle-days

The expected and the active days of all vehicles added up. 12 vehicles over 7 days make 84 expected vehicle-days.

Actively used vehicles, Underutilized vehicles and Not used vehicles

How many vehicles are in each class

Total distance (km), Total trips and Total driving time

The sums of all vehicles

Most utilized vehicle

The vehicle with the highest utilization, for example Sprinter 01 (85.7%). Vehicles that were not used are skipped.

Least utilized vehicle

The vehicle with the lowest utilization, for example Trailer 12 (0%)

In the Summary step, the first choice is One row per vehicle. Click Add a summary table to change the list or add tables:

  • Split each row by Day, Week or Month gives every vehicle a row for each period, so you see its utilization week by week. The Period column is added at the front so you can tell the rows apart.

  • A row for each Vehicle group adds a table with the utilization of each group. Vehicle alone adds no table, because every vehicle already has its own row.

Summary tables show Vehicles, Utilization (%), Active days, Expected days, Distance (km), Trips and Driving time. See the Summary step.

Example

A utilization report for one week, with the default settings. Click a picture to see it full size.

The first page of a utilization report with the notes and the Summary The vehicle list with the utilization, active, expected and inactive days

Good to know

  • With Monday to Friday, a vehicle that only drives at weekends shows as Not used.

  • A report for This month made in the morning counts today as an expected day, and most vehicles have not driven yet. Make it at the end of the day, or pick the dates up to yesterday.

  • A vehicle added in the middle of the period has the same expected days as the others, so it looks less used than it was.

  • Public holidays count as expected days.