Improving fleet utilisation
The monthly report allows you to identify those vehicles which are not being used to capacity. From the utilisation chart (see below) you can easily home in on the problem areas. Within the same workbook the user can go into the utilisation detail for that vehicle - which will quickly highlight the routes or days of the month on which the use of the vehicle could be improved.
Here are some of the potential benefits:
- By rescheduling calls or routes to other vehicles, improvements of up to 15% in capacity are often achievable.
- Vehicles can be re-allocated or transferred to other depots.
- Purchase of additional vehicles for the fleet can be deferred until the existing vehicles are fully utilised.
Vehicle utliisation for the month is shown in a Excel bar chart
Low percentage utilisation can be sufficient justification for deferring purchase of additional fleet vehicles.
The monthly mileage report shows the distance covered by each vehicle for every day of the month.
Sample Excel reports available online include -