Browse
 
Tools
Rss Categories

1. Utilization Report

Reference Number: AA-00641 Views: 5889 Created: 2011-12-12 12:02 Last Updated: 2017-03-28 13:38 0 Rating/ Voters

In this section

Monthly Utilization Report

Generate a Monthly Utilization Report

Print a Monthly Utilization Report

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