Use this program to:

• Produce a report of royalties due from Hertz Brazil licensees for their monthly royalty and marketing fees.

Prior to producing this report, the following set up is necessary:

1. Edit Licensee Fees

A record must be set up for each Posting Company. It is in this record where the percentage royalty rates are entered as well as the transaction rate applied to closed RAs. These rates are used by the Licensee Royalty Report to generate calculations. Refer to the chapter titled Edit Licensee Fees for detailed instructions.

2. Edit Optional Items

All options other than Time, Mileage, Drop and LDW which are to be subject to the royalty percent must be flagged as "Pay Royalty" = "Y" in the program Edit Optional items.

This report may be configured to run automatically at night. Users interested in this feature should contact Thermeon's Customer Support Dept. for further information.

To access the program, type ROYRPT (RET) at any menu "OPTION:" field or the appropriate number on the Hertz Brazil Menu. The screen will then display:

OPTION: LICENSEE ROYALTY REPORT 1 Location TUS 2 Start Date 01-01-05 3 End Date 01-31-05 4 Detail/Summary D 5 Print/Display P Printer: /dev/tty 1PRINT 2 3ERASE 4 5 6 7HELP 8

Enter data as follows:

1. LOCATION	For the renting location, enter: Up to 6 alphanumeric characters to select a single location. A Group Name representing several locations (see the Chapter Edit Group Names for a discussion on location groups). Remember, the first character of a Group Name is the plus sign "+". "ALL" to include all locations Press RETURN to accept the default location. EXAMPLE:Type TUS (RET)
2. START DATE	Using the selected date format, enter the Starting Date. Press RET to default to the first day of last month. EXAMPLE: Type 10105 (RET) Closed and posted RAs with closing dates between the Start Date and End Date will be included in the report. In addition, edits to posted RAs that occurred during the date range will be included in the calculations.
3. END DATE	Using the selected date format, enter the Ending Date. Press RET to default to the last day of last month. EXAMPLE: Type 13105 (RET) Closed and posted RAs with closing dates between the Start Date and End Date will be included in the report.
4. DETAIL/ SUMMARY	Select the report format. D=Detailed Report; each RA will be listed. S=Summary Report; only totals for each section will be included. EXAMPLE: Type D (RET)
5. PRINT/ DISPLAY	Enter: P = Print a hard copy of this report on your terminal's assigned printer or send it as an e-mail. See the Edit Terminal Records Chapter for instructions on how to assign printers and send reports as e-mails. D = Display this report on this screen.See the General Data Entry Instructions Chapter on how to control the screen display. EXAMPLE: Type P (RET)
6. DETAIL VEHICLE LIST?	This Y/N field turns on or off the printing of the Vehicle Data Section described later in this chapter. Enter: Y = YES, the Vehicle Data Section should print after the royalty report. N = NO, the vehicle Data Section will not print after the royalty report. EXAMPLE: Type Y (RET)
7. DETAIL RESERVATION LIST?	This Y/N field turns on or off the printing of the Reservation Fees and Reservation Turndown Sections described later in this chapter. Enter: Y = YES, the Reservation Sections should print after the royalty report. N = NO, the Reservation Sections will not print after the royalty report. EXAMPLE: Type Y (RET)

PRESS "F1" AT "OPTION:" TO BEGIN.

Notes about this report:

RAs are sorted into 4 possible types and subtotals print for each type:

Daily Rental
Billing Cycle field is blank and the rental length is less than 25 days. Or, data is entered in the Billing Cycle field and it was closed for less than 25 days and never cloned. Or it's a multi month rental and the rate code on the RA is not the same as the rate on the previous RA nor the same as the Min/Max Change To rate codes on the previous RA.

Multi-Month Rental
Billing Cycle field is blank and the rental is 25 days or longer. Or it's a multi-month rental and the rate code on this RA is the same as the rate code on the previous RA or the same as the Min/Max Change To rate codes on the previous RA..

Lease
Lease RA and the "Unit Owned" field in the Inventory record is other than "N".

Fleet Management
Lease RA and the "Unit Owned" field in the Inventory record is "N".

The count for the number of RAs is based on the number of RAs with DBR closing dates that fall within the date range. Posted RAs that were edited during the date range are not included in the count of RAs reported.

Columns:

A	Vehicle Number
B	RA Number
C	T & K Discounted Revenue The sum of Time, Miles (Kms), Upsells, Option "D.TAR", less Discounts, Customer Service Adjustments, and Promos.
D	Drop Revenue Drop charges
E	Chauffeur Revenue All options marked with a "Y" in the "Pay Royalty" column of the Edit Optional Items screen.
F	LDW Revenue All "L" type options.
G	Royalty Charge The sum of the previous 4 columns that are subject to royalty
H	Other Revenue The sum of all other options not defined above including taxes.
I	Total Gross Revenue The sum of the previous columns.Matches RA gross total.
J	Royalty % The royalty percentage from the Edit Licensee Fees record.
K	Royalty Amount - The result of multiplying columns C, D, E, and F by the Royalty percentage in J.
L	Marketing Percent The marketing percentage from the Edit Licensee Fees record.
M	Marketing Amount The result of multiplying columns C, D, E, and F by the Marketing percentage in L.

RA Data Section

The following data is shown in summary for each rental type (Daily, Multi-Month, Lease, Fleet Management) for the date range and location(s) requested::

• Number of RAs Opened
• Number of RAs Closed(from the Revenue Section of this report)
• Total number of rental 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.

Vehicle Data Section

This section reports all vehicles owned by the reporting location regardless of their physical location at the end of the reporting period. For example, a licensee owned vehicle that was physically at a corporate location will be reported under the licensee location.

Using the closed RAs from the Revenue Section of this report, the RAs are sorted by Rate Class. The data is then sorted and summarized into the following categories:

• Number of RA's by Class for Owned vehicles
• Number of RAs by Class for Non-owned vehicles
• Total RAs by Class
• Number of Rental Days by Class

Reservation Fees Section

This section summarizes all reservations delivered during the reporting period (create date/ time falls within the reporting period), for pickup locations that fall within the selected locations and have a create Location of SA073 or BCD70 or have an employee code RESINT.

• Reservations included have a status other than "T" (turndown) or "C" (cancelled )
• Cross month voids are deducted. (A cross month void is a reservation that was created earlier than the date range requested but canceled during the date range requested.)
• The net result multiplied by the Res Fee amount (from the Edit Licensee Fees control file) to generate the Res Fee owed by the licensee(s).
• Net reservations are also calculated for the prior 3 months

Reservation Turndown Section

Reservations in turndown status (Status "T") are reported with the following breakdowns:

• Number of turndowns this period (Codes from 100 to 399 for the requested locations and the create date of the reservations fall within the requested date range.)
• Number of turndowns for the previous 3 months (Codes from 100 to 399 for the requested locations and for the previous 3 months.)
• Number of offsells for 4 months (Codes 107, 207, and 307 are reported for the same 4 month period:the month requested plus the 3 previous months)
• Percentage of offsells for the the 4 month period.