Monthly Excel reporting - Improve vehicle utilisation across your fleet
The monthly summary report provides a clear picture of the movement and usage of all vehicles in a specific group, for a calendar month. Groups can be categorised according to vehicle type, region of operation, depot or function.
Details of vehicle usage
The report is structured to provide a separate detailed worksheet for each vehicle in a designated group, allowing easy viewing of the number of trips made, mileage recorded, expected fuel consumption and length of time that it has been away from base - for every day of the month.
Fleet summary information
In addition to the detailed vehicle-specific worksheets the report also provides two further worksheets and a chart which summarise vehicle usage in terms of mileage covered, and fleet and driver capacity utilisation – which may be calculated in a variety of ways.
Calculating fleet utilisation - time spent away from the specified base location (which may be different for each vehicle)
Travelling time - total time from first to last use of vehicle during each shift.
Additional report features
The report has a user-friendly 'view down' spreadsheet layout, featuring vehicle-specific columns and utilisation is summarised on a daily and monthly basis. Weekends can be included or excluded at vehicle level. Pop-up help boxes describe the way the various features and calculations are used. Excess hours are highlighted – management can specify shift times and any overtime hours will be shown. Monthly recorded mileages can be compared against the vehicle odometer readings. Additional vehicle movement data and analysis can be appended to each monthly vehicle summary page.
Sample Excel reports available online include -