Use this program to produce a report to assess the anticipated revenue from reservations. This can be used to analyze yield management pricing and to analyze the performance of individual suppliers in terms of reservations.

NOTE: This report produces meaningful data only when all reservations reported are in the same currency. Systems that have reservations in multiple currencies should only use this report when the selection criteria (such as rate product) have been set such that all reservations reported are in the same currency.

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

OPTION:___ Reservation Yield Report

1 Start Create Date EARLIEST 21 Primary Sort 1 Pickup Date
2 End Create Date LATEST 22 Secondary Sort
3 Start Pickup Date 08-28-08 23 SubTotals 1 Primary
4 End Pickup Date 09-27-08 24 Detail/Summary D
5 Source Code ALL 25 Print/Display/CSV D
6 Vehicle Class/Grp ALL 26 Printer /dev/tty
7 Rate Set ALL 27 ProRate at start? N
8 Start Rate Product FIRST 28 ProRate at end? Y
9 End Rate Product LAST 29 Revenue Type 1 1=T&M, 2=TotRev
10 Start Employee FIRST
11 End Employee LAST
12 Start Vendor FIRST
13 End Vendor LAST
14 Start CDP FIRST
15 End CDP LAST
16 Location/Grp ALL
17 Res Type ALL
18 Exclude Cancelled N
19 Include Requests Y Y)es, N)o, O)nly
20 RA type ALL

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


Enter data as follows:

1. START CREATE DATE

The date/time range entered in Fields 1 and 2 refer to the date the reservation was created in the system. Using the selected date format, enter the Starting Date. Press RET to default to "EARLIEST".

EXAMPLE: Press (RET)

2. END CREATE DATE

Enter the ending create date. Press RET to default to "LATEST".

EXAMPLE: Press (RET)

3. START PICKUP DATE

Using the selected date format, enter the starting pick up date. Press RET to default to the current date.

Open and filled reservations with a pick up date between the start and ending date range entered in this field and the next one will be included.

When run for a start date in the future, open reservations with a pick up date between the current date and before the start date but with a return date after the start date will be included.

EXAMPLE: Press (RET)

4. END PICKUP DATE

Using the selected date format, enter the ending pick-up date. Press RET to default to the date that is one month from the current date.

EXAMPLE: Type 10-31-08 (RET)

5. SOURCE CODE

For the Source Code, enter:

  1. Up to 5 alphanumeric characters to select a single Source Code.
  2. A Source Group Code representing several Source Codes (see the Chapter Edit Source Groups for details). Remember, the first character of a Group Name is the plus sign "+".
  3. Press (RET) to include “ALL” Sources.

EXAMPLE: Type TR (RET)

6. VEHICLE CLASS/ GROUP

Use this field to limit the report to reservations for a particular vehicle Class or Class Group. Enter up to 4 alphanumeric characters for a vehicle Class or up to 6 (including the plus + sign) for a Class Group. To include all vehicle Classes, press (RET).

EXAMPLE: Type F (RET)

7. RATE SET

Use this field to limit the report to reservations from a particular Rate Set by entering up to 2 alphanumeric characters representing the Rate Set. To include all Rates Sets, press (RET).

EXAMPLE: Type A (RET)

8. START RATE PRODUCT

Use this field and the next one to limit the report to reservations with certain Rate Product codes. Enter up to 12 alphanumeric characters representing the Rate code. Or press (RET) to begin with the "FIRST" one.

EXAMPLE: Type TR101 (RET)

9. END RATE PRODUCT

Use this field and the previous one to limit the report to reservations with certain Rate Product codes. Enter up to 12 alphanumeric characters representing the ending Rate code, or press (RET) to end with the "LAST" one.

EXAMPLE: Type TR299 (RET)

10. START EMPLOYEE

Use this field and the next one to limit the report to reservations made by certain employees . Enter up to 6 alphanumeric codes representing the starting Employee Code, or press (RET) to begin with the "FIRST" one.

EXAMPLE: Type MMG (RET)

11. END EMPLOYEE

Use this field and the previous one to limit the report to reservations made by certain employees. Enter up to 6 alphanumeric codes representing the ending Employee Code, or press (RET) to end with the "LAST" one.

EXAMPLE: Press (RET)

12. START VENDOR

Use this field and the next one to limit the report to reservations showing certain Vendors. Enter up to 8 alphanumeric codes representing the starting Vendor code, or press (RET) to begin with the "FIRST" one.

EXAMPLE: Press (RET)

13. END VENDOR

Use this field and the previous one to limit the report to reservations showing certain Vendors. Enter up to 8 alphanumeric codes representing the ending Vendor code,Or press (RET) to end with the "LAST" one.

EXAMPLE: Press (RET)

14. START CDP

Use this field and the next one to limit the report to reservations with certain CDPID numbers. Enter up to 10 alphanumeric codes representing the starting CDPID number, or press (RET) to begin with the "FIRST" one.

EXAMPLE: Press (RET)

15. END CDP

Use this field and the previous one to limit the report to reservations with certain CDPID numbers. Enter up to 10 alphanumeric codes representing the ending CDPID number, or press (RET) to end with the "LAST" one.

EXAMPLE: Press (RET)

16. LOCATION/ GROUP

For the reservation pickup location, enter:

  1. Up to 6 alphanumeric characters to select 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. "ALL" to include all locations

Press RETURN to accept the default location.

EXAMPLE: Type TUS (RET)

17. RES TYPE

Enter up to two alphanumeric characters representing a single Reservation Type Code to restrict this report to just reservations created with that Type Code. Or press RETURN to default to reservations of ALL types.

EXAMPLE: Press (RET)

18. EXCLUDE CANCELLED

This field allows you to exclude canceled reservations from the report. Enter:

Y = Yes, exclude canceled reservations.

N = No, do not exclude them.

EXAMPLE: Type N (RET)

19. INCLUDE REQUESTS

Use this field to include requests for reservations. Enter:

Y = Yes, include requests.

N = No, exclude requests.

O = Report requests only.

EXAMPLE: Type N (RET)
20. RA TYPE
 Use this field to limit the report reservations with a single RA Type Code. Or, press (RET) to include all Types.

EXAMPLE: PRESS (RET)

21. PRIMARY SORT

Select a primary sort:

1 = Pickup Date

2 = Source

3 = Source Group

4 = Vendor

5 = Location

6 = Class

7 = Month

8 = Create Date

9 = RA Type

10 - Salesman Code

Press Shift/F7 to view a list of the sort choices.

EXAMPLE: Type 3 (RET)

User tip: When Salesman Code is the selected sort, a separate row is provided for each code. Those reservations that do not have a CDPID with a salesman code a grouped as a final subtotal.

22. SECONDARY SORT

Select a secondary sort:

1 = Pickup Date

2 = Class

3 = Location

4 = Rate

5 = Empl

6 = Month

7 = Create Date

Press Shift/F7 to view a list of the sort choices.

EXAMPLE: Type 1 (RET)

23. SUBTOTALS

Select a subtotal level"

1 = Primary - subtotal for each item selected for the primary sort.

2 = Secondary - subtotal for each item selected for the secondary sort.

3 = Both- subtotal for each item selected for the both the primary and secondary sorts.

4 = None - no subtotals requested

Press Shift/F7 to view a list of the sort choices.

EXAMPLE: Type 1 (RET)

24. DETAIL/ SUMMARY

Enter 1 alpha character to select the report format.

D = Detailed Report - Each reservation is listed and subtotals are shown as requested.

S = Summary Report - individual reservations are not listed; only the subtotals requested are shown.

EXAMPLE: Type D (RET)

25. PRINT/
DISPLAY/ CSV

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 this screen. See the General Data Entry Instructions Chapter on how to control the screen display.

C = CSV. In order to get the CSV file, field 26 below must be set to a value that causes the output to be opened or saved as a file. For most users, the value of CSV or EDITOR will work for this purpose. The current CARS+ Report Printer setting is displayed and may be changed in the next field. Please refer to the chapter for Edit Terminal Records or Change User Environment for more information on setting up printing to a file and/or opening a file in the default program for that file.

EXAMPLE: Type P (RET)

26. PRINTER

This field defaults to the printer that will be used if either "P" or "C" is requested in the Print/Display/CSV field above. Examples are PDF (for printing to PDF), CSV (for receiving the CSV file) or /dev/tty (for printing directly to a printer).

Ask Thermeon’s Customer Support Dept. for details.

EXAMPLE: Press (RET)
27. PRORATE AT START
 For reservations that begin before the requested date range and have a return date within the date range, this field determines if the revenue within the date range should be included. Enter:

Y = Yes, include the revenue for the days within the requested date range when the reservation pick up date is before the Start Pickup Date entered in Field 3.

N = No, do not include the revenue for the days within the date range when the reservation pick up date is before the Start Pickup Date entered in Field 3. (In other words, include only reservations that have a pickup date within the date range entered.)

EXAMPLE: Type Y (RET)

User tip: Refer to the discussion on "Revenue calculations" (below) for details.
28. PRORATE AT END
 For reservations that begin during the requested date range and have a return date beyond the end date, this field determines how the revenue on these reservations are reported. Enter:

Y = Yes, the revenue will be prorated for the days within the requested date range when the reservation return date is beyond the End Pickup Date entered in Field 4.

N = No, revenue for reservations that extend beyond the End date will NOT be prorated, all revenue for the reservation will be reported.

EXAMPLE: Type N (RET)
29. REVENUE TYPE
 This field determines if the revenue shown should be time and mileage only or the total of all charges on the reservation including options,taxes, and fees. Enter:

1= The revenue should be time and mileage only.

2 = The revenue should include all charges on reservation.


EXAMPLE: Type N (RET)


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


Notes about this report:

Revenue calculations:

On inclusive rates, the included items are extracted before reporting the T&M revenue and calculating the Average Revenue per Day (ARD).

When a tour voucher is on the reservation, the visible rate on the reservation (Main window) is not used to estimate the time revenue. Instead, the rate on the voucher customer's voucher rate product is used to estimate the revenue for the entire reservation period.

For insurance replacement rentals, the retail rate (rate in the main window) is used to estimate the Time revenue.

Time revenue is estimated for the reservation period.

Reservations that start within the requested date range and have a return date later than the date range:

And Field 28 = Y

The revenue on the entire reservation is estimated. The number of days that fall within that requested date range are calculated and compared to the total days of the reservation and a percentage is determined. The rental is treated "as if" it checked in at midnight on the cut off date of the report ( For example, a 10 day reservation with 3 days falling within the pick up date range would be calculated at 30%.) The Time revenue for the entire reservation is then multiplied by the percentage to produce a prorated Time revenue for the reporting period.

And Field 28 = N

The revenue on the entire reservation is estimated and reported

Reservations that begin before the requested date range and have a return date within the date range:

And Field 27 = Y

A calculation is done to include the revenue on the days within the date range. The revenue on the entire reservation is estimated. The number of days that fall within that requested date range are calculated and compared to the total days of the reservation and a percentage is determined. ( For example, a 10 day reservation with 3 days falling within the pick up date range would be calculated at 30%.) In this case, the rental is treated as if it started at midnight the morning of the first date on the date range. The Time revenue for the entire reservation is then multiplied by the percentage to produce a prorated Time revenue for the reporting period.

And Field 27 = N

No revenue from reservations that begin prior to the start date will be reported.

When the report is run for more than one month, revenue is prorated for each month with subtotals shown for each month.


Column headings:

Most of the column headings on the report are self-explanatory. Those that may not be are listed below:

PU Date 	Pick up date
CR Date 	Create date
Set     	Rate set
ARD     	Average Revenue per Day(days are 'elapsed' days).  
                When there is more than 1 additional hour, a day is added to the elapsed days.

Rate Product
For Hertz operations receiving reservations electronically: When a template rate was used to accept the reservation, this report will show the requested reservation rate product (RQ rate).