The Daily Performance Report is a utilization report used to compare today's business with any period in the past.

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:

Y = Yes, include wholesale revenue

N = No, do not include wholesale revenue

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:

Y = Yes, include reservation revenue

N = No, do not include reservation revenue

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:

T = Time. Calculate the "On-Rent Revenue Per Day" based on the figure in in the "Rental Revenue" column. The Rental Revenue is Time, Mileage/Kms, less discounts and possibly LDW. See the User Tip below regarding LDW.

G = Gross. Calculate the "On-Rent Revenue Per Day" based on the figure in the "Gross Revenue" column. The Gross Revenue is all revenue less taxes, with 'taxes' being those options that are set up as Option Type 't' or 'f'.

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:

N = No, do not create an export file.

Y = Yes, create an export file.

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.

Y = Yes, drop the digits after the decimal point on the Totals. For example, a total of $3,456.98 would print as $3,456.

N = No, print the complete totals on the Total line.

EXAMPLE: Type N (RET)

18. SORT ORDER

Enter one of the following characters to indicate how the data should be sorted:

L =Location

V =Vehicle

C =Class

M =Model

EXAMPLE: Type V (RET)

19. DETAIL/ SUMMARY

Enter 1 alpha character to select the report format.

D = Detail
S
= Summary

EXAMPLE: Type D (RET)

20. PRINT/ DISPLAY/CSV

Enter:

P = Print a hard copy of this report on your terminal's assigned printer or send it as an email.

D = Display this report on the terminal screen. See the General Data Entry Instructions Chapter on how to control the screen display.

C = CSV. In order to get the CSV file, you must first use Change User Environment to set your CARS+ Report Printer to a value that causes the output to be opened or saved as a file. The current CARS+ Report Printer setting is displayed to the right of this field on the same line. Please refer to the chapter for Edit Terminal Records or Change User Environment for more information on setting up printing to a file and/or opening a file in the default program for that file.

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.


Overdue Contracts

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.