The Tour Profitability Report sorts RAs by tour operator and reports incremental revenue items sold which were not covered by the tour voucher. It is designed so that there is one page for each operator showing the number of RAs, average length of an RA, each optional charge (separately), total extra revenue, and the average extra revenue per day.

Note: If vouchers are invoiced at open, the program reads all RAs (open, closed and posted). If vouchers are not invoiced at open, it reads only closed and posted RAs.

Inclusive voucher options are ignored by this report and not included as add-on revenue.

To access the Tour Profitability Report, type TOURPROF (RET) at any menu "OPTION:" field or the appropriate line number on the Incremental Sales Menu on the Month End Menu. The screen will then display:

OPTION: __ TOUR PROFITABILITY REPORT

1 Start Date 07-03-12
2 End Date 07-03-12
3 Start Cust # FIRST
4 End Cust # LAST
5 Location ALL
6 Source Subsort? N
7 Truncate Decimals? N
8 Create Flat File? N
9 Flat File Name TOURPRF.TXT
10 Print/Display P Printer: LASER
11 Create Employee ALL
12 Voucher Class ALL




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

Enter data as follows:

1. START DATE

Using your selected date format, enter the Starting date. Press RET to default to the current day.

EXAMPLE: Type 061612 (RET)

Enter up to 6 alphanumeric characters to indicate the customer number of a single customer whose tour RAs you would like to examine. Press RET to default to ALL tour operator customers.

EXAMPLE: Press RET

2. END DATE

Using your selected date format, enter the Ending date. Press RET to default to the current day.

EXAMPLE: Type 063012 (RET)

3. START CUST #

Enter up to 6 alphanumeric characters representing a particular tour operator customer number to start with or press (RET) to begin with the "FIRST" customer number.

EXAMPLE: Type ABCTR (RET)

4. END CUST #

Enter up to 6 alphanumeric characters representing a particular tour operator customer number to end with or press (RET) to end with the "LAST" customer number.

EXAMPLE: Type ABCTR (RET)

5. LOCATION

Enter up to 6 alphanumeric characters to indicate the opening location of the RAs making one of the following choices:

Enter:

  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 accept the default of "ALL" locations.

EXAMPLE: Type TUS (RET).

6. SOURCE SUBSORT

As stated above, this report sorts information by tour operator. This field is used to indicate whether or not you want the data further sorted under each tour operator's customer number by source code.

Y = Yes, use the source code to sort the data under each customer number reported.

N = No, don't bother to sort the data for each customer by source code.

EXAMPLE: Type Y (RET)

7. TRUNCATE DECIMALS

This field is used to indicate whether or not you want the digits beyond the decimal points to print on the "totals" line.

Y = Yes, drop the digits after the decimal point on the Grand Totals lines on both pages of the reports. For example, an actual total of $3,456.98 would print as $3,456.

N = No, print the actual totals on the Grand Total line.

EXAMPLE: Type N (RET)

8. CREATE FLAT FILE

Enter one alphanumeric character to indicate whether or not a flat file should be created when running this report.

Y = Data will be copied to another part of the disk. For instructions on how to copy this information to another media, call Thermeon.

N = No, not creating a flat file.

EXAMPLE: Type Y (RET)

9. FLAT FILE NAME

If a flat file is being created (Field #8), enter a name for it. Press RET to default to: TOURPRF.TXT

EXAMPLE: Press (RET)

If creating a flat file, pressing the "F4" key when the cursor is at the main "OPTION:" will display a help text file about the format of the ASCII flat file.

10. 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)
11. CREATE EMPLOYEE
 Use this field to limit the report to those transactions that where the reservation was created by a single employee. Enter up to 6 alphanumeric characters representing the employee user code. Press (RET) to include reservations created by all employees.

EXAMPLE: Press (RET)
12. VOUCHER CLASS
 Use this field to limit the report to transactions that had a single vehicle class on the voucher. Press (RET) to include reservations where the voucher was for all vehicle classes.

EXAMPLE: Type MVAR (RET)

The screen will then display:

OPTION: __ TOUR PROFITABILITY REPORT

1 Start Date 06-16-12
2 End Date 06-30-12
3 Start Cust # ABCTR
4 End Cust # ABCTR
5 Location TUS
6 Source Subsort? Y
7 Truncate Decimals? N
8 Create Flat File? Y
9 Flat File Name TOURPRF.TXT
10 Print/Display P Printer: LASER
11 Create Employee ALL
12 Voucher Class MVAR





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


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