Use this program to obtain performance reporting and analysis of optional revenue by vehicle number. The data reported is from both open and closed RAs which are selected by their DBR Date as well as adjustments made to posted RAs within the date range.

A Note About Types of Reports:

Because of the way RA revenue records are stored, reports in CARS+ fall into one of the following categories depending on how they read and access data in CARS+:

1. Contract Oriented Reports

These reports, such as the Operations DBR, read the RA File by the closing DBR date and report ALL revenue for the RA -- regardless of when the revenue item was added to or removed from the rental agreement. All revenue and utilization reports in CARS+ not listed in the next section as a "Revenue Oriented Report" fall into this category.

2. Revenue Oriented Reports

Reports of this type reports revenue based on the DBR date of each individual charge. Therefore, the same RA can appear on several reports run for different date ranges. When a posted RA is edited, the resulting change will be reflected on reports run forthe time of the edit.

Reports that fall into this category are:

Accounting DBR

Extra Revenue Report

Revenue Analysis Report

Vehicle Optional Item Revenue

For example, assume the Vehicle Optional Item Revenue for the month of April included RA # 1234 which had LDW revenue of $30.00.

However, in May the posted contract was edited because it was discovered that the LDW charge should have been only $25.00. When the Vehicle Optional Item Revenue is run for May, RA # 1234 will be included again -- this time with a negative $5.00 for LDW because of the edit entered in May to the posted RA.

Because the separately dated edits to previously posted contract can exist, you should realize that it is possible to have contracts listed with negative amounts on this report and to have negative percentages.

User tip - Clean up the selection of options: Use the "Expire Date" field on page 2 of the Edit Optional Items program to indicate when options are no longer active and should not appear as choices on this report. If the date range for the report is later than the expiration date entered, the Option will not be listed as a choice.

To access the Revenue Analysis Report, type VEHOPTRP (RET) at any menu "OPTION:" field or the appropriate line number on the Incremental Sales menu. The screen will then display:

OPTION: __ VEHICLE OPTIONAL ITEM REVENUE

1 Starting Date 09-01-11
2 Ending Date 09-15-11
3 Starting Vehicle
4 Ending Vehicle
5 Location TUS (Loc, +Group, or ALL)
6 Sort Order 2 (1=Date, 2=RA Number, 3=Option Code)
7 Tour Revenue Y/N N
8 Print/Display P
Select (with an 'X') up to 7 items to be reported
X T&M BRACK LDW3
X Drop Chrge CSADJ MISC
X PPD-FUEL CLEAN PAI
X All Cvgs DISC PEC
X All Opts DRIVR PH CD
X TAX FFSNW RRACK
X FUEL FFSUS SEAT
MISC FFTAX SLI
AGE24 GARS SRCHG
APTX GPS UPGRD
MISC LDW UPSEL
ABAST LDW1
AC LDW2

1SAVE 2 +39 3ERASE 4 -39 5BACKUP 6 7HELP 8


Enter data as follows:

1. STARTING DATE

Using your selected date format, enter the Starting DBR date. Press RET to default to yesterday's date.

EXAMPLE: Type 080111 (RET)

2. ENDING DATE

Using your selected date format, enter the Ending DBR date. Press RET to default to yesterday's date.

EXAMPLE: Type 083111 (RET)

3. STARTING VEHICLE
Enter the vehicle number of the first vehicle to be reported or type "FIRST" to start with the first vehicle on file.

EXAMPLE: Type 10000 (RET)

4. ENDING VEHICLE
Enter the vehicle number of the last vehicle to be reported or type "LAST" to end with the last vehicle on file.

EXAMPLE: Type 10050 (RET)

5. LOCATION

Enter up to 6 alphanumeric characters to indicate the Opening Location making one of the following choices:

Up to 6 alphanumeric characters to select RAs for a single location.
A Group Name representing several locations.(The first character of a Group Name is the plus sign "+".)
Press RETURN to default to ALL locations.

EXAMPLE: Type TUS (RET).

6. SORT ORDER

Enter one of the following characters to indicate the sort order for the data:

1 = Sort by RA DBR Date

2 = Sort by RA Number

3 = Sort by Option Code

EXAMPLE: Type 2 (RET)

7. TOUR REVENUE

Enter one of the following:

Y = Yes, revenue from optional items that were included in a tour voucher should be reported.

N = No, revenue from optional items that were included in a tour voucher should NOT be reported. This report should only report optional revenue that was paid for by the renter.

EXAMPLE: Press (RET)

8. PRINT/ DISPLAY

Enter:

P = Print a hard copy of this report on your terminal's assigned printer or send as an email. See the Edit Terminal Record Chapter for instructions on how to assign printers and send reports as emails.

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

EXAMPLE: Type P (RET)


The remaining fields on the screen are used to select up to seven items which will be included on the report.

The possible choices are listed on the screen.

1. To select an item for the detailed columns, place a capital "X" in front of the choice. Although each choice on the screen is not numbered, each one is a separate data entry field and can be accessed by pressing the RET key the appropriate number of times.

User tip - Clean up the selection of options: Use the "Expire Date" field on page 2 of the Edit Optional Items program to indicate when options are no longer active and should not appear as choices on this report. If the date range for the report is later than the expiration date entered, the Option will not be listed as a choice.


PRESS "F1" AT THE "OPTION" TO BEGIN PRINTING.


NOTES ON READING THE REPORT

User tip: Beacuse this report includes both closed and open RAs, it is not possible to compare it to the Accounting DBR, a feature of many of the other Revenue Oriented Reports. RAs are sorted first by the vehicle involved and then subsorted by the sort option selected on the screen. The data reported is:

  1. RA Open Date
  2. Vehicle Class
  3. Vehicle Number
  4. RA-Open Location
  5. RA Number
  6. Number of people in the party
  7. Renter's last name
  8. Seven columns with the revenue for each item
A subtotal will print after each vehicle