Use this report to obtain performance reporting and analysis of optional revenue by reservation. The data reported is from reservations which are selected by their booking date *date created) and by their pickup date. This report is modeled after the Revenue Analysis Report. While the Revenue Analysis Report shows revenue generated by closed RAs, this report estimates the revenue that reservations generate.

To access the Reservation Revenue Analysis Report, type RSREVA (RET) at any menu "OPTION:" field or the appropriate line number on the Manager's Sales Reports Sub-Menu of the Daily Procedures Menu. The screen will then display:


OPTION: __ RESERVATION REVENUE ANALYSIS REPORT

1 Start Booking Date 10-20-14 2 End Booking Date 10-20-14
3 Start Pickup Date 10-20-14 4 End Pickup Date 10-31-14
5 Booking Location TUS (Loc, +Group, or ALL)
6 Sort By S (L=Operating Loc, B=Booking Loc, V=Veh-class, R=Rate, T=RA
Type, S=Source code, O=Tour Optr, A=Trvl Agt, M=Rntl Agt, K=BookAgt)
7 Section B (B=Both,R=Revenue,A=Analysis)
8 Print/Display P Printer: laser 12 Res Revenue only Y/N? Y
9 Tour Revenue I (I=include, E=exclude, O=only)
10 Include Cancellations Y Y/N/A 11 Include Zero Deposits Y Y/N
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 AGE22 DISC PEC
X AGE24 DRIVR PH CD
X APTAX FFSNW RRACK
X FUEL FFSUS SEAT
MISC FFTAX SLI
BSEAT GARS SRCHG
ABAST LDW1
AC LDW2

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


Enter data as follows:

1. START BOOKING DATE

Using the selected date format, enter the starting booking date. This is the date when the reservation was created. Press RET to default to today's date.

EXAMPLE: Type 010113 (RET)

2. END BOOKING DATE

Using the selected date format, enter the ending booking date. Press RET to default to today's date.

EXAMPLE: Type 123113 (RET)
3. START PICKUP DATE

Using the selected date format, enter the starting pickup date. Press RET to default to today's date.

EXAMPLE: Type 010114 (RET)
4. END DBR DATE

Using the selected date format, enter the ending pickup date. Press RET to default to yesterday's date.

EXAMPLE: Type 123114 (RET)

User Tip: The two sets of date ranges. The date examples ask for reservations booked during 2013 that have pick up dates in 2014.

5. BOOKING LOCATION

Enter up to 6 alphanumeric characters to indicate the Location the user was at who originally created the reservations. Enter one of the following choices:

  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 default to ALL locations.

EXAMPLE: Type TUS (RET).

6. SORT BY

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

L = Reservation Pickup location
B = Reservation Booking location
V = Reservation vehicle class
R = Reservation Rate Code
T = RA Type Code
S = Reservation Source Code
O = Tour Operator
A = Travel Agency (Commissionable vendor)
M = Rental Agent who opened the RA based on the reservation if the reservation is filled, else the reservation create employee is used
K = Reservationist who created the reservation

Like the Revenue Analysis Report, this sort selection will define the Y axis of the printed report.

EXAMPLE: Type S (RET)
7. SECTION
 Like the Revenue Analysis that it is patterned after, this report has two sections. Enter one of the following codes to indicate the sections that are to be printed:

R = Revenue, this section reports the estimated revenue that the reservations will generate.

A = Analysis, this section reports average length of reservations, the average revenue per day, average revenue per reservation, etc.

B = Both. Enter this code to print both the Revenue and Analysis sections

EXAMPLE: Type B (RET)
8. PRINT/DISPLAY

Enter:

P = Print a hard copy of this report on your terminal's assigned printer. See the Edit Terminal Record Chapter for instructions on how to assign printers.

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)

9. TOUR REVENUE

Enter one of the following:

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

E = 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.

O = Only, that revenue associated with the voucher should be reported, any out of voucher revenue should be ignored.

EXAMPLE: Press (RET)

10. INCLUDE CANCELLATIONS?

Enter:

Y = Yes, include reservations that were later canceled but were open during the date range requested.

N = No, do not include canceled reservations.

EXAMPLE: Type N (RET)
11. INCLUDE ZERO DEPOSITS

Enter:

Y = Yes, include reservations that were opened without a deposit.

N = No, do not include reservations without a deposit (as the no-show factor on these is higher).

EXAMPLE: Type N (RET)
12 RES REVENUE ONLY

Enter:

Y = Yes, on filled reservations, exclude any charges that were added to the RA and were not part of the reservation.

N = No, on filled reservations report all revenue that is on the rental agreement.

EXAMPLE: Type N (RET)


The remaining fields on the screen are used to select up to seven items which will be included on the report. Items appear as either:

1. A unique column on the report. Up to seven items can appear this way.

2. Not in a unique column but rather subtotaled together with all other charges in an "Other Revenue" column. As a result, this revenue is included in the Total Revenue figure (far right column of page 1 of the report.)

3. Excluded from the Total Revenue figure all together.

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.

2. To exclude an item from being included in the Total Revenue figure on both sections of the report, place a capital "N" in front of the choice. There is a limit of 80 imposed for items that may be excluded from Total Revenue. Even though they are excluded from Total Revenue columns in both sections of the report, they will be included in the "Gross Revenue" column in the second section.

3. All other items, those without an X or N, will be totaled together under the "Other Revenue" column on page 1.

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.

This report contains a calculation of rental length called "DBR Days" (or just "Days"). One of two possible formulas are used in CARS+ to calculate this figure. To chose the formula to be used in this as well as over fifty other CARS+ reports, go to Page 5, Field 3 of Edit Miscellaneous Control Fields.