Use this program to obtain analysis of expected rental revenue based on reservation data. The report is divided into two sections:

• Revenue Section - This section includes revenue from reservations and RAs where the pickup date falls within the date range requested. There is a wide choice of how to sort the revenue, such as by travel agent, booking location, rental location, source code, vehicle class, rate, tour operator, etc. Revenue is shown in columns -- up to 7 categories can be selected for the columns (example: Time & Mileage, LDW, GPS units, etc.)

• Analysis Section - The second section of the report, using the same sort criteria, calculates such figures as the rental days, revenue per day, average fleet size, revenue per fleet unit, number of transactions (RAs and reservations), revenue per RA, and average rental length.

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 Fleet Revenue Analysis Report, type FLTREV (RET) at any menu "OPTION:" field or the appropriate line number on the RV Operations sub-menu of the Brand Specific Menus. The screen will then display:

OPTION: __ FLEET REVENUE ANALYSIS REPORT 1 Start DBR Date 02-23-11 2 End DBR Date 12-31-11 3 Location TUS (Loc, +Group, or ALL) 4 Sort By L 5 Detail/Summary D (D=detail--new page/loc) 6 Section B (B=Both,R=Revenue,A=Analysis) 7 Print/Display D Printer: /dev/tty 8 Tour Revenue? I (I=include,E=exclude,O=only) 9 Vchr/Cust/Both Select (with an 'X') up to 7 items to be reported T&M CSADJ KEY SEAT DROP CLEAN LDW SLI AGE24 DISC MAP SRCHG APTAX DMG MILE UPGRD BOXES DRIVR MISC BSEAT FFSUS PAI BUYDW FUEL PEC CARD GPS PRF CCFEE GPSRP RACK 1SAVE 2 +39 3ERASE 4 -39 5BACKUP 6 7HELP 8

Enter data as follows:

1. START DBR DATE	Using the selected date format, enter the starting date. Press RET to default to yesterday's date. Reservations with return dates within this date range will be included in the report. EXAMPLE: Press (RET)
2. END DBR DATE	Using the selected date format, enter the ending date. Press RET to default to the end of the current year. Reservations with return dates within this date range will be included in the report. EXAMPLE: Press (RET)
3. LOCATION	Enter up to 6 alphanumeric characters to indicate the Opening Location making one of the following choices: Enter up to 6 alphanumeric characters to select RAs for a single location. Enter 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).
4. SORT BY	Enter one of the following characters to indicate the primary sort order for the data: A = Travel Agent B = Booking Location C = CDPID# G = Salesmen I = Individual RA J = Reservation L = Location M = Rental Agent O = Tour Operator R = Rate S = Source code T = RA Type V = Vehicle class W = Owning Location EXAMPLE: Type S (RET) User tip: Reservations with the sort item chosen are listed first. Reservations without the sort item are grouped together at the end. For example, if Tour Operator is selected as the primary sort, the data from all reservations with a Tour operator are listed first. Then the data from non-tour reservations are grouped together.
5. DETAIL/ SUMMARY	Enter: D = Detailed Report. When reporting multiple locations, product a separate page for each location. S = Summary Report. When reporting multiple locations, summarized all locations on one page. EXAMPLE: Type D (RET) User tip: When the report is run for a single location, there is no difference between the detail and summary version.
6. SECTION	Enter 1 alpha character to select which information should be included in the report. A = Analysis section (statistics and averages) only B = Both Revenue and Analysis sections R = Revenue section only EXAMPLE: Type B (RET)
7. PRINT/ DISPLAY	Enter: P = Print a hard copy of this report on your terminal's assigned printer or send the report in an e-mail. See the Edit Terminal Record Chapter for instructions on how to assign printers and send reports in e-mails. 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)
8. TOUR REVENUE	Enter: I = Include transactions whether or not they have with tour revenue E = Exclude transactions with tour revenue O = Report only transactions with tour revenue EXAMPLE: Type I (RET)
9. VCHR/ CUST/ BOTH	This field is accessible only when Field 8 is set to "O" - report only transactions with tour revenue. Enter: V = Include the voucher revenue only C = Include the customer's revenue only (out of voucher revenue) B = Include both the voucher and out of voucher revenue EXAMPLE: Press (RET)

The remaining fields on the screen are used to select which items will be included on the report. Up to 7 items can be selected. The possible choices, using the Option Codes, are listed on the screen.

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.

The first item in the list, T&M, combines Time and Mileage (Km) revenue.

Items not selected will be totaled together under the "Other Revenue" column on page 1.

The screen will then display:

OPTION: __ FLEET REVENUE ANALYSIS REPORT 1 Start DBR Date 02-23-11 2 End DBR Date 12-31-11 3 Location TUS (Loc, +Group, or ALL) 4 Sort By L 5 Detail/Summary D (D=detail--new page/loc) 6 Section B (B=Both,R=Revenue,A=Analysis) 7 Print/Display D Printer: /dev/tty 8 Tour Revenue? I (I=include,E=exclude,O=only) 9 Vchr/Cust/Both Select (with an 'X') up to 7 items to be reported X T&M CSADJ KEY SKI DROP CLEAN X LDW SLI AGE24 DISC MAP SRCHG APTAX DMG MILE UPGRD BOXES DRIVR MISC X BSEAT FFSUS PAI BUYDW FUEL X PEC CARD X GPS PRF CCFEE GPSRP RACK 1SAVE 2 +39 3ERASE 4 -39 5BACKUP 6 7HELP 8

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

NOTES ON READING THE REPORT

Revenue Section (page 1)

User tip: This section includes anticipated revenue from reservation with return dates within the date range.

1. Going across the page are the seven columns of revenue, plus columns for "Other Revenue" and "Total Reported Revenue".
   
   Other Revenue=Total of all charges that are not shown in an individual column except taxes (options that are marked as types 'T', 'f', or 't'.)
   Total Revenue = All charges except taxes.
2. Going down the left hand edge are the sorted items.
3. A subtotal then prints for all RAs reported above.
4. The Total line includes the subtotals mentioned above. This report is designed so that regardless of what sort options are chosen, the grand total of the Total Revenue column will always be the same when run for the same date and location ranges and when the same items are excluded.

Analysis Section (page 2)

The following are the definitions of the columns reported:

Total Revenue= All charges except taxes

Rental Days = Total number of chargeable days for the transactions

Revenue per Day = Total Revenue divided by Rental days.

Average Fleet Size = Average fleet during this time

Revenue per Unit = Total revenue divided by Average Fleet

Number of RAs = Number of Reservations reported

Revenue per RA = Revenue divided by Number of RAs (reservations and RAs).

Length of rental = Rental Days divided by Number of RAs (reservations and RAs).

Percent of RAs = Percent that sort item is of the total RAs reported.