TYPES OF UTILIZATION REPORTS
This is one of two types of CARS+ utilization reports. The types are:
1. Point-in-Time utilization
a. Current Utilization Report
b. Fleet UtilizationReport
c. Owned Fleet Utilization Report
2. Historical utilization
a. Two Month Performance Report
b. Twelve Month Performance Report
c. Daily Performance Report
d. Average Utilization Report
A "Point-in-Time" utilization report gives the utilization percent at the exact moment that the report is run. A "Historic" utilization report gives the utilization for a span of time in the past (example: last week, last month, this week to date, etc.).
Of the four Historical reports listed above, the first two are based on closed and posted contracts only. These reports give the most accurate revenue utilization figures. The last two are based on both open and closed RAs.
DIFFERENCE BETWEEN THE AVERAGE UTILIZATION REPORT AND DAILY PERFORMANCE REPORT
The following are the major differences between the Average Utilization Report (AUR) and the Daily Performance Report (DPR):
1. The AUR is based on the concept of chargeable days. For example, most operations would charge 2 full days for a rental that ran for 1 day and 12 hours. This would be reported as 2 days on the AUR.
2. The DPR is based on actual elapsed time. Therefore the 1 day 12 hour rental would be reported at 1.5 days.
3. If a rental either starts or stops outside the reporting period, the DPR will calculate the number of minutes the rental was on rent within the reporting period and express that in fractional days.
4. In the same situation, the AUR will ignore fractions of days at either the start or end of the reporting period if the fraction is less than 3 hours in length.
5. The DPR is actually two utilization reports in one. The left half of the report gives the utilization for the requested historical period. The right half always gives the utilization for the current calendar day. The current calendar day section includes not only open RAs but also all open reservations with today's date as their pickup date. This allows you to compare today to a period in the past.
6. The Daily Performance Report is sensitive to the entry made in a field in the Edit Miscellaneous Control Files that determines whether or not "L" type coverages (LDW) are included in the Rental Revenue column.
7. The AUR is based on time charges only - mileage/kms are not included. The DPR includes mileage/km revenue.
To access the Daily Performance Report, type SALES (RET) at any menu "OPTION:" field or the appropriate line number on the Utilization Menu. The screen will then display:
| OPTION: __ DAILY PERFORMANCE REPORT 1 Start Date 04-01-12 20 Print/Display P Printer: /dev/tty 2 End Date 04-22-12 3 Start Veh # FIRST 4 End Veh # LAST 5 Location ALL 6 Class ALL 7 Start Model FIRST 8 End Model LAST 9 Fleet Type ALL 10 Include Wholesale Y/N? Y 11 Include Res's Y/N? Y 12 Revenue Calculation G (T=T&M Only, G=Gross) 13 Exclude Vehicle Status 14 Owning Location TUS 15 Rack Rate Product (Blank=Use Location Defaults) 16 Create Export File Y/N? N 17 Truncate Decimals Y/N? N 18 Sort Order L (L=Location, V=Vehicle, C=Class, M=Model) 19 Detail/Summary/CSV S Printer: prtspool 1SAVE 2 3ERASE 4 5BACKUP 6 7HELP 8 |
Enter data as follows:
|
1. START DATE |
Using your selected date format, enter the Starting date. Press RET to default to the first day of the current month. EXAMPLE: Press (RET) |
|
2. END DATE |
Using your selected date format, enter the Ending date. Press RET to default to the current day. EXAMPLE: Press (RET) |
|
3.START VEH # |
Enter up to 6 alphanumeric characters to indicate the Starting Vehicle Number. Press RET to default to the FIRST Vehicle Number. EXAMPLE: Press (RET) |
|
4. END VEH # |
Enter up to 6 alphanumeric characters to indicate the Ending Vehicle Number. Press RET to default to the LAST Vehicle Number. EXAMPLE: Press (RET) |
|
5. LOCATION |
Enter up to 6 alphanumeric characters to indicate the Pick-Up Location making one of the following choices: Enter: 1. Up to 6 alphanumeric characters to select RAs for a single location. 2. A Group Name representing several locations.(The first character of a Group Name is the plus sign "+".) 3. Press RETURN to accept the default location. Note: Your user access may be limited as to the locations for which you can run this report. If your access is restricted and you attempt to enter a location or location group which is outside your allowed parameters, the following message will be displayed at the bottom of the screen and your selection will be ignored: RESTRICTED REPORT LOCATION EXAMPLE: Type TUS (RET). |
|
6. CLASS |
To limit the report to one Vehicle Class, enter up to 4 alphanumeric characters to select a Class Code. Press RET to default to ALL Classes. EXAMPLE: Type MVAR (RET) |
|
7. START MODEL |
Fields 7 and 8 are use to limit the report to one Model Code or a group of Model codes. Enter up to 8 alphanumeric characters to indicate the Starting Model Code. Press RET to default to the FIRST Model Code. EXAMPLE: PRess (RET) |
|
8. END MODEL |
Enter up to 8 alphanumeric characters to indicate the Ending Model Code. Press RET to default to the LAST Model Code. EXAMPLE: Press (RET) |
|
9. FLEET TYPE |
To limit the report to a particular Fleet Type, enter a single character representing the Fleet Type. Otherwise, press (RET) to include all Fleet Types. EXAMPLE: Press (RET) |
|
10.INCL WHOLESALE |
The entry in this field determines whether or not the report will include wholesale (insurance and tour) revenue. Regular revenue earned on wholesale rentals is always included. Enter:
EXAMPLE: Type Y (RET) |
|
11. INCL RES'S |
The entry in this field determines whether or not the report should include revenue that would be earned if every reservation for the current day filled into an RA. Enter:
EXAMPLE: Type Y (RET) |
|
12. REV CALC |
The entry in this field determines whether the calculation for the "On-Rent Revenue Per Day" column should be based on the "Rental Revenue" or the "Gross Revenue". (Note that it does not influence the figures that are reported in the Rental Revenue or Gross Revenue columns.) Enter:
EXAMPLE: Type T (RET) |
|
13. EXCL VEH STATUS |
Enter up to 10 vehicle status codes that should be excluded from the report. Vehicles in these statuses will be excluded. Enter the status codes one after another with no spaces or punctuation between them. EXAMPLE:Type GTW(RET) |
|
14. OWNING LOCATION |
If your organization is set up to use fleet pools and your default location references a fleet pool, this field defaults to the appropriate pool location. Otherwise, this field will show your default location. Enter up to 6 alphanumeric characters to indicate the owning location for the vehicles to be included in this report. Enter: 1. Up to 6 alphanumeric characters to select a single location. 2. A Group Name representing several locations.(The first character of a Group Name is the plus sign "+".) 3. Press RETURN to accept the default location. EXAMPLE: Type TUS (RET). |
|
15. RACK RATE PROD |
Enter up to 5 alphanumeric characters that represent a rate product that will be used for comparison to the actual revenue earned per day to determine the revenue utilization. If this field is left blank, the default rate product from the Location file will be used as the rack rate for comparison purposes. EXAMPLE: Press (RET) User tip: Some rental operations use inclusive rates where tax and/or GST may be included. Since tax and GST are extracted from the Gross Revenue on this report, you may want to use a non-inclusive rate code in this field to make a more accurate comparison. |
|
16. CREATE EXPORT FILE |
This feature allows you to send the data to an ASCII file which can be imported into a spreadsheet program (such as EXCEL.) The file consists of the same data in the same order as the printed report, but contains data only (Column headings, totals, and page numbers are not part of the file.) Data is tab-delimited. The file is stored under the name: DLYSLS.TXT in a "tmp" directory. Or Change the Report Printer via CHGRPT. In field 1 enter EDITOR and then press F1 and when running this Sales report with a Y in this field 16, it will ask what format you want to report to be in.. Enter csv and it will open up in Excel and use your Text to Column wizard to format. Because the file has the same name each time it is run, the previous version is overwritten. Note, therefore, that in order not to lose the data you must copy the data to disk before creating another file. Enter:
EXAMPLE: Type N (RET) Contact Thermeon's Customer Support Dept. for more information and guidance in setting up the "tmp" directory which is necessary prior to using this feature. User Tip: The difference between Export File in this field vs CSV File in Field 19. The Export File option (this field) should only be used by operations running CARS+ on their own hosted servers. For users using CARS+ Internet, use the CSV option (Field 19) as the resulting file will be delivered to your PC. |
|
17. TRUNCATE DECIMALS |
This field is used to indicate whether or not the digits beyond the decimal points should be included in the Total line.
EXAMPLE: Type N (RET) |
|
18. SORT ORDER |
Enter one of the following characters to indicate how the data should be sorted:
EXAMPLE: Type V (RET) |
|
19. DETAIL/ SUMMARY |
Enter 1 alpha character to select the report format.
EXAMPLE: Type D (RET) |
|
20. PRINT/ DISPLAY/CSV |
Enter:
EXAMPLE: Type P (RET) |
The screen will then display:
| OPTION: __ DAILY PERFORMANCE REPORT 1 Start Date 04-01-12 20 Print/Display P Printer: /dev/tty 2 End Date 04-22-12 3 Start Veh # FIRST 4 End Veh # LAST 5 Location TUS 6 Class MVAR 7 Start Model FIRST 8 End Model LAST 9 Fleet Type ALL 10 Include Wholesale Y/N? Y 11 Include Res's Y/N? Y 12 Revenue Calculation T (T=T&M Only, G=Gross) 13 Exclude Vehicle Status GTW 14 Owning Location TUS 15 Rack Rate Product (Blank=Use Location Defaults) 16 Create Export File Y/N? N 17 Truncate Decimals Y/N? N 18 Sort Order V (L=Location, V=Vehicle, C=Class, M=Model) 19 Detail/Summary/CSV D Printer: prtspool 1SAVE 2 3ERASE 4 5BACKUP 6 7HELP 8 |
PRESS "F1" AT THE "OPTION" TO BEGIN PRINTING.
Notes about the report:
Vehicle Location
Note that vehicles are reported under their current location.
If a vehicle is out on an open overdue contract, the revenue per day is calculated based on the revenue through the current day -- not through the anticipated return date. This calculation is based on the assumption that even if the vehicle is overdue, it is still earning revenue.
Fleet Days
Fleet days are the number of days the vehicle has been in the fleet during the time period requested. The days are calculated as follows:
The rounded number of total accrued minutes is divided by 1440 (with 1440 being the number of minutes in a day.)
Revenue
Gross Revenue on this report does not include tax or GST (option types 't' and 'f'). If the rental rate included these items, they are extracted.
The
"Rental Revenue" figure is sensitive to
the entry made in a field in the Edit
Miscellaneous Control Files. (Refer to page 2, field 30 "INCLUDE IN
T&M ON DBR".) The setting for that field determines whether or not
"L" type options (LDW) are
included in the Rental Revenue column.
Projected Revenue Today - Revenue %
This percentage is a result of comparing the Gross Revenue for the current day to the rate in the Rack Rate field (if the default of "G" is in Field 12, Revenue Calculation.) If Field 12 is change to "T" (T&M only), then the percentage is a result of comparing the T&M Revenue for the current day to the rate in the Rack Rate field.
Inclusive Rates
Inclusive rates have the included items extracted before they are reported in the "Rental Revenue" column.