In this section
Export a Monthly Utilization Report to Excel
Monthly Utilization Report
The Monthly Utilization report displays vehicle utilization over a selected previous period by a single location or all
locations grouped by categories. Included in the report also are indicators of
Average Days per Contract and Average Rate. Please note that the report cannot
be run for a period of less than three days. We recommend that reporting
periods be one month or more.
The Utilization figure is arrived at by
:
- Calculating the Average
Number of Vehicles (ANV) available over the reporting period (must be more than
3 days, with longer periods producing a more accurate average number).
- Calculating the Total
Days Available (TDA) = ANV * No. of days over the reporting period
- Calculating the Total
Days Rented (TDR) over the reporting period.
- Utilization = TDR / TDA
* 100
Back to top
Generate a Monthly Utilization
Report
To generate a Monthly Utilization Report first navigate to the Monthly Utilization Report page (Reports menu > Monthly Financial Reports tab > Monthly Utilization Report icon), see Fig. 1.

Fig. 1. Opening the Monthly Utilization Report page
On the Monthly Utilization Report
page (see Fig. 2):
a. Select the vehicle location/ region.
b. Select the vehicle category.
c. Select the date range for the report.

Fig. 2. Monthly Utilization report options
Click View to generate the
report (see Fig. 3).

Fig. 3. A generated Monthly Utilization report
Once a report has been generated, the report can be
printed or exported to Excel.
NOTE: Table 1 shows descriptions of each column found
in the Monthly Utilization Report.
Back to top
Print a Monthly Utilization
Report
To print a Monthly Utilization Report first generate a Report
(see Generate a Monthly Utilization
Report).
On the Monthly Utilization Report page,
click the Print icon to display a printer-friendly version of the report (see Fig. 4).

Fig. 4. A printer friendly Monthly
Utilization Report
You may then print the report using your browser's
Print feature.
Back to top
Export a Monthly Utilization Report to Excel
Once you have generated a Monthly Utilization Report (see Generate a Monthly Utilization Report) click the "Excel" button to download the report.
To open the report in Microsoft Excel navigate to your download folder and open the file in Excel (see Fig. 5).

Fig. 5. The Monthly Utilization Report open in Excel
Table 1. The Monthly Utilization Report column descriptions
Column Name
|
Description
|
Category
|
The vehicle category
|
Average No. of Vehicles
|
The average number of vehicles on fleet per
category
|
No. of Contracts
|
Total number of contracts (hires) over the
reporting period
|
Average Days Per Contract
|
Total Days Rented / No. of Contracts
|
Average Rate
|
Sum (Daily Rates) / No. of Contracts
|
Days Rented
|
Total days rented over the reporting period
|
Total Days Available
|
Total days in reporting period * average number
of vehicles
|
Utilization Rate
|
Total Days Rented / Total Days Available * 100
|
Back to top