Utilization
To open the Utilization tab, hover over the Product Support link from anywhere within IntelliDealer and select Rental> Supervisor from the drop down list.
The Utilization tab allows you to display how well the rental fleet is being utilized in terms of dollars and days rented by Stock number, Category/Class/Subclass and Group.
The following sorting options appear on the Utilization tab:
| Sort by | |
|---|---|
| Field | Description |
| Display | Sort the search results by display. |
| Available Days | Sort the search results by available days. |
| Rental Days | Sort the search results by rental days. |
| Day Utilization | Sort the search results by day utilization. |
| Potential $ | Sort the search results by potential money. |
| Actual $ | Sort the search results by actual money. |
| Dollar Utilization | Sort the search results by dollar utilization. |
| Financial Utilization | Sort the search results by financial utilization. |
The following display options appear on the Utilization tab:
| Display by | |
|---|---|
| Field | Description |
| Stock Number | Display the search results by stock number. |
| Category/Class/Subclass | Display the search results by category/class/subclass. |
| Group | Display the search results by group. |
The following search fields appear on the Utilization tab:
| Field | Description |
|---|---|
| Select Stock Number | Search for rental utilization by entering a stock number. |
| Select Category | Search for rental utilization by entering a category. |
| Select Class | Search for rental utilization by entering a class. |
| Select Date Range |
Narrow down the rental utilization search results by selecting a date range. |
| Select Subclass | Search for rental utilization by entering a subclass. |
| Select Group | Search for rental utilization by entering a group. |
| Select Location |
Search for rental utilization by entering a branch location. Note: If the Prevent Rental From Non-Assigned Loc switch is set to N (No) in the DIVTAB1 table, you will not be able to perform any branch-specific rental utilization analysis. |
The following fields appear on the Utilization tab:
Note: All fields used in these calculations are from the original details of the contracts, or are derived based on contract details, as in the case of where there are no "standard rates" on file. Except for the "Days In Period" which is the number of days that the rental overlapped the selected analysis period, based on the date out and date in from the contract line.
| Field | Description |
|---|---|
| Stock Number |
The rental unit's stock number. Note: If the Stock Number sorting option is selected and the stock number appears highlighted, it means the selected unit is currently on rent. |
| Available Days | The number of days the unit was available to rent during the period being analyzed. |
| Rental Days | The number of days the unit was on rent during the period being analyzed. |
| Day Utilization |
The Day Utilization percentage is calculated from the rented days and potential days. Day Utilization Percentage = (Rental Days/Available Days) x 100 |
| Potential $ |
The potential dollar amount is calculated by first determining a base daily rate for the item. This will be derived by taking the largest duration defined for the unit (usually a month) from all the rentals that have just been accumulated, and factoring that down to a per-day value, based on how many hours are in the duration. This per-day amount is then multiplied by how many days the unit was available in the analysis period to arrive at the potential dollar amount for that period. Potential Dollars = Available Days x Stock Number's Largest Duration Rate/(Largest Duration Hours / 24) |
| Actual $ |
The actual dollar amount value is calculated by the contract amount multiplied by the days in the selected period, divided by the contract’s actual days out. Actual $ = Contract Line Rental Amount x Days in the Analysis Period/Contract Actual Days Out Note: Days In Period is the number of days that the rental overlapped the selected analysis period, based on the date out and date in from the contract line. |
| Dollar Utilization |
The Dollar Utilization percent is calculated from the actual rental dollars and potential dollars. Dollar Utilization = (Actual $/Potential $) x 100 |
| Financial Utilization |
The financial utilization is calculated from the selected unit's Actual $ amount for the selected time period divided by the original cost of the unit (as listed in the Invoice Amount field of the Equipment Profile). Note: If you have selected the Category/ Class/ Subclass option in the Display By field, the financial utilization value displayed will be for all the units that fall within each specific category/ class/ subclass combination.(Actual $ amount for the selected time period divided by the original costs for all units associated to the category/class/subclass combination.) |
Click on a Stock Number to open the Equipment Profile screen.
The following is a description of the totals that appear on the Utilization tab:
| Total | Description |
|---|---|
| Total Available Days | The total available days for all listed rentals. |
| Total Rental Days | The total rental days for all listed rentals. |
| Total Potential $ | The total potential dollar amount for all listed rentals. |
| Total Actual $ | The total actual dollar amount for all listed rentals. |
The following is a description of the averages that appear on the Utilization tab:
| Average | Description |
|---|---|
| Average Available Days | The total available days for all listed rentals divided by the number of rentals on the list of search results. |
| Average Rental Days | The total rental days for all listed rentals divided by the number of rentals on the list of search results. |
| Average Day Utilization |
The total average day utilization divided by the number of rentals on the list of search results. |
| Average Potential $ | The total potential dollar amount divided by the number of rentals on the list of search results. |
| Average Actual $ | The total actual dollar amount divided by the number of rentals on the list of search results. |
| Average Dollar Utilization | The total dollar utilization divided by the number of rentals on the list of search results. |
| Average Financial Utilization | The total Actual $ amount for all units listed in the search results divided by the total original cost of those units (as listed in the Invoice Amount field of their respective Equipment Profiles). |
Click the Print Utilization Report link to generate the Rental Utilization Analysis Report (DZRPT01) using the Print Utilization Report screen.
Click the Print Utilization Audit Report link to generate the ARA Rental Utilization Analysis Report (RM127), the ARA Rental Rate Trial and Age Analysis Report (RM127A), and the Utilization Rate Change Analysis Report (RM127RC). For more information regarding these reports, see the Rental Utilization Reports topic.
Note: The Utilization Rate Change Analysis Report will only be generated if you select a Date Range of at least 1 month.