This report is meant to identify possible abnormalities in the rates on RAs.

The Rate Exception Report is made up of the following three sections:

1. RATE VARIANCE SECTION. This section reports manual edits that were made to rental rates on an RA. The report shows the increase or decrease that was made on mileage, hourly, daily, etc. charges. Rental agreements are sorted by employee who made the edits.

2. CLASS VARIANCE SECTION. Shows rentals where the Rate Class and the Vehicle Class are not the same, that is, rentals where the rate used was not appropriate for the vehicle rented. An example of this would be a forced upgrade on a reservation rental.

3. RES VARIANCE SECTION. Shows rentals where either class, rate product, or rate class, or rate do not match what was reserved. In this category you are given the option to include or exclude upsells.

To access the Rate Exception Report, type RTEXCP (RET) at any menu "OPTION:"field or the appropriate line number on the Daily Audit Reports sub-menu of the Daily Procedures Menu. The screen will then display:

OPTION: RATE EXCEPTION REPORT

1 Start DBR Date 03-03-10
2 End DBR Date 03-03-10
3 Employee ALL
4 Location ALL

Variance selections:
5 Rate$ variance Y
6 Class variance Y
7 Res variance Y
8 Exclude upsells N
9 Comm RA's only N
10 Print/Display P


1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8


Enter data as follows:

1. START DBR DATE

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

EXAMPLE: Type 030110(RET)

2. END DBR DATE

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

EXAMPLE: Type 030210(RET)

3. EMPLOYEE

Enter up to 6 alphanumeric characters to select a single Employee Code. Press RET to default to All Employees.

EXAMPLE: Type JEG (RET)

4. LOCATION

Enter up to 6 alphanumeric characters to indicate the Customers Pick-Up Location.

Enter:

  1. Up to 6 alphanumeric characters to select RAs opened at a single location.
  2. 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 "+".
  3. Press RETURN to default to ALL locations.

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)


VARIANCE SELECTIONS

There are three possible sections to this report. Fields 5 through 7 allow you to select which sections are to be printed.

5. RATE$ VARIANCE

Enter:

Y = Ras with manually edited rates are reported.

N = Manually edited RAs will not be reported.

EXAMPLE: Type Y (RET)

6. CLASS VARIANCE

Enter:

Y = RAs whose Rate Class and Vehicle Class are not the same are reported. RAs whose Vehicle and Rate Class do not match but which have a sold Upsell option are NOT reported.

N = Differences in Class will not be reported.

EXAMPLE: Type Y (RET)

7. RES VARIANCE

Enter:

Y = RAs whose Vehicle Class, Rate Product or Rate Class differs from what was reserved will be reported. Also includes rate amounts that differ (manually edited rates on the RA).

N = RAs which do not match their reservation will not be reported.

EXAMPLE: Type Y (RET)

8. EXCLUDE UPSELLS

This field is only meaningful if reservation variances in Field 7 above has been selected.

Y = Exclude from the Reservation Variance section RAs which had an upsell over what was reserved. For this report ALONE, a upsell is defined as a rental where all FOUR of the following statements are true:

  1. The Vehicle Class on the rental does not equal the Vehicle Class on the reservation.
  2. The Vehicle Class and the Rate Class on the rental are the same.
  3. The daily rate on the RA is greater than the daily rate on the reservation.
  4. There was no upsell option sold on the rental.

N = Include upsells in the Reservation Variance section.

EXAMPLE: Type Y (RET)

Further Explanation: This report is meant to identify possible abnormalities in the rates on RAs. If the Vehicle Class on the RA is different that the reserved class and an Upsell Option was sold, there is nothing abnormal about that. So rentals with a sold Upsell Option are never reported. This field does not involve rentals of this type. But there is a second way to "upsell" a client: if a renter reserved an economy car at the economy rate yet the counter gives them a mid-size car and charges them the mid-size rate, that too is an upsell. But in this case, there was not a separate upsell charge added to the rental. It is upsells of this second variety that are included or excluded by this field. As the renter did pay for what he left with, normally these do not represent a potential problem and should be excluded from the report.

9. COMM RA'S ONLY
Enter:

Y = Include only those RAs that have a vendor commission.

N = Include RAs regardless of vendor commission.

EXAMPLE: Type N (RET)


10. PRINT/ DISPLAY

Enter:

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

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

EXAMPLE: Type P RET)


The screen will then display:

OPTION: RATE EXCEPTION REPORT

1 Start DBR Date 03-01-10
2 End DBR Date 03-02-10
3 Employee JEG
4 Location TUS

Variance selections:
5 Rate$ variance Y
6 Class variance Y
7 Res variance Y
8 Exclude upsells Y
9 Comm RA's only N
10 Print/Display P


1BEGIN 2 3ERASE 4 5BACKUP 6 7HELP 8


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


HINTS ON READING THE REPORT

Column Headings:

Loc

The location at which the variance occurred. This location can be a foreign location in the case of one-way rentals where the variance occurred on the Batch Close screen. Entering a Batch Close variance may be required to match actual closing amounts.

Empl

The employee who made the change. In the case where the same type of change was made multiple times on the same RA, the last employee is shown. For example, if manual edits were made both on the reservation and also RA closed, the closing employee's code will show here.

ROC

This single character shows where the change occurred. The codes are:

R = Variance occurred on the Reservation screen.

O = Variance occurred on the RA Open screen.

C = Variance occurred on the RA Close screen.

Rented Veh

Class Code of the vehicle that was actually rented.

Rented Rate

Rate Product Code when RA closed.

Rented Cls

Rate Class Code used on RA.

Reserved Veh

Class of vehicle reserved.

Reserved Rate

Rate Product reserved.

Reserved Cls

Rate Class reserved.

Mile, Hour, etc.

Data appears in these remaining columns only in the Rate Variance section. The difference between the original rates and the edited rates are shown. For example, "-.050" in the Mile column indicates that the mileage rate was reduced by 5 cents per mile. While a "5.00" in the Day/1 column indicates that the daily rate or the Tier 1 rate was increased by $5.00 per day.


Multiple listings

Because multiple changes can be made during the life of an RA, a rental may appear in more than one section. For example, if a forced upgrade occurred at the time of open and the rates were edited at close, the RA would appear in both the Rate Variance and Class Variance sections.