Rental Utilization Report


Reports Menu -> Utilization -> Rental Utilization Reporting Menu -> Rental Utilization Report

The formula used to calculate the Rental Utilization Percent is, the number of Days Rented over the number of Days Available, times 100.
The higher the percentage, the greater the demand for that rental product by your customers.

The revenue and utilization information for an alternate period, such as the same period in the prior year, can also be calculated when spreadsheet output is generated for product detail, without using summarized totals or date detail.

The prompts are:

FROM DIVISION
Leave this field blank to include all divisions, or type in the beginning division for the range, or select one from the drop-down list.
TO DIVISION
Leave this field blank to include all divisions, or type in the ending division, for the range, or select one from the drop-down list.

Note: This report does not respect divisional restrictions set by operator Access Values.


FROM PRODUCT CLASS
Leave this field blank to include all classes, or type in the beginning product class, or select one from the Product Class Search window.
TO PRODUCT CLASS
Leave this field blank to include all classes, or type in the ending product class, or select one from the window.

FROM PRODUCT GROUP
Leave this field blank to include all groups, or type in the beginning group, or select one from the Group Search window.
TO PRODUCT GROUP
Leave this field blank to include all groups, or type in the ending group, or select one from the window.

FROM PRODUCT NUMBER
Leave this field blank to include all products, or type in the product number, or select one from the Inventory Search window.
TO PRODUCT NUMBER
Leave this field blank to include all products, or type in the product number, or select one from the window.

USE SUMMARIZED TOTALS
Uncheck this box if the financial data has not been summarized in Summarize for Inventory Reports by Period, then enter the desired date range as prompted.

Check this box if to use the summarized financial data as outlined in Summarize for Inventory Reports by Period.
The report dates will display the summarized date range, and cannot be changed unless the data is re-summarized.


FROM DATE
This is the starting date for the report.

If summarized data is to be used the summarized start date is displayed, and cannot be changed unless the data is re-summarized.
If the report is not using summarized data, the date defaults to the first day of the current month and can be over-typed if required.

Note: Because this report is based on the Monthly History (RSMH), the calculation only reports on an asset after it has been in the fleet for a full month.
Any partial beginning months from the date acquired for a new asset are ignored.


TO DATE
This is the ending date for the report.

If summarized data is to be used the summarized end date is displayed, and date cannot be changed unless the data is re-summarized.
If the report is not using summarized data, the date defaults to the last day of the current month and can be over-typed if required.


ALTERNATE FROM DATE
The alternate date information is only generated on the spreadsheet when the Product Detail is printed but without the Date Detail and without using the Summarized Totals.

The alternate starting date for utilization statistics defaults to the same period in the previous year, but the starting date can be over-typed as required.

This information is not printed on the report output because of space limitations.


ALTERNATE TO DATE
This is the alternate ending date used when the alternate period utilization information is printed on the spreadsheet.

PRINT PRODUCT DETAIL
Check this box to print financial information for each product in the range.
Uncheck this box to print class totals only.

PRINT DATE DETAIL
This option is enabled if Print Product Detail has been selected to allow Date Details on the products.

Check this box to print date detail for each product.
Uncheck this box to print totals and no date detail.


IGNORE DIVISIONS
Check this box to print overall totals instead of totals by division.
Uncheck this box to print separate totals by part, for each division.

LIST PRODUCTS WITH NO ACTIVITY
Check this box to include all products.
Uncheck this box to ignore products having no income in the specified date range.

PRODUCTS TO INCLUDE
Select one of the following options:
  • Select Bulk to include only Bulk rental equipment in the report.
  • Select Non-Bulk to include only Non-Bulk equipment in the report.
  • Select Both to include both rental equipment in the selected range, in the report.

REPORT OPTIONS
This value defaults to the operator preference as defined in Operators.
Select one of the output options to Print a report or export the data to Excel as outlined in Report Options.

The spreadsheet option also outputs alternate period rental utilization information for the product detail option, when summarized totals and date detail are not selected.


Finished?
A printer can be confirmed or re-selected from the Printer option located on the menu bar at the top of the screen.

Click the ACCEPT button to begin printing the report, or CANCEL to abort.


Topic Keyword: RSMH11
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)