This program is used to produce a report showing reservation and revenue performance by source of business.

In order for this report to be meaningful, the source code field on both the Reservation and RA Open programs must be entered during the normal course of business.

User tip: The Source Code can be set as a required field in the Edit Main Control Record.

When this is done, this report then becomes a powerful tool in analyzing your business and determining what advertising and marketing strategies have been successful and where future efforts should be aimed.

The Source Analysis Report shows statistical information about reservations and closed RAs by source code. For each source code, the report has four major groups of information from left to right:

  1. RESERVATIONS. This first group totals reservations by status and gives the percent of filled to total, and the percent of total reservations for this source code vs. the total reservations for all source codes.
  2. RAs BY RESERVATION. The second group totals void and closed RAs made from reservations, and gives T&M and gross revenue amounts and percents. (Note that LDW may be included in the revenue figure - see the User Tip: below.) The percents in this case are the percents of T&M or gross revenue for a RA of this kind derived from a reservation vs. the total revenue for all RAs of this kind.
  3. RAs BY WALK-IN. The third group shows the same information as group 2 except that the figures are for closed RAs which are due to walk-in business (RAs generated without a reservation) as opposed to RAs from reservations.
  4. RA TOTALS. This fourth group totals both the T&M and the Gross revenue and gives percents for RAs from both group 2 and group 3. Again, this is closed RAs.

User Tip: The "T&M Revenue" figure is sensitive to the entry made in a field in the Edit Miscellaneous Control Fields. (Refer to page 2, field 30 "INCLUDE IN T&M ON DBR".) The setting for that field determines whether or not "L" type options (LDW) are included in the Rental Revenue column.


HOW EDITS TO POSTED RAs ARE REPORTED

This report is a "Contract Oriented Report". As such, edits to posted RAs will be reflected on this report on the Close DBR Date of the RA. They will not be reflected on the date the edit was made. For example, if an RA has a close DBR Date of June 1st and and edit is made on June 20 which impacts the revenue, that edit will be reflected on this report for the date of June 1st. If a report has already been run for June 1st, it is now out of date and will need to be replaced by a new report for June 1st which has been run after the edit was made. For a detailed discussion of Contract Oriented Reports vs. Revenue Oriented Reports, please see the manual chapter for the Extra Revenue Report.


To access the Source Analysis Report, type SOURCE (RET) at any menu "OPTION:" field or the appropriate line number on the Month-End menu. The screen will then display:

OPTION: __ SOURCE ANALYSIS REPORT

1 Start Date 08-31-12
2 End Date 08-31-12
3 Date Type D (D=DBR Date, P=Pick-up Date)
4 Location ALL
5 Source Code ALL
6 Monthly Totals N
7 Print Description N
8 Print/Display P Printer: dev/tty



1BEGIN 2 3 4 5BACKUP 6 7HELP 8

Enter data as follows:

1. START DATE

For reservations, the date range always refers to the pick-up date.

For closed RAs, the date range can be for either the closing DBR date or the pick-up (opening) date. Remember, only closed and voided RAs are reported. RAs that are still open are ignored.

Also, the difference in date selection means that the first two groups, Reservations and RAs by Reservation do not necessarily represent the same set of reservations. For example, if there are ten filled reservations shown in the first group of columns, that does not necessarily mean there will be ten closed RAs shown in the second group. (A reservation can be filled during the selected date range and the RA may still be open.)

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

EXAMPLE: Type 08-01-12 (RET)

2. END DATE

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

EXAMPLE: Type 08-31-12 (RET)

3. DATE TYPE

Enter 1 alpha character to indicate which date is to be used in selecting RAs for this report. (Reservations are always reported by their pick-up date.)

D = DBR Date. The date range entered above will select closed RAs by their closing DBR date.
P = Pick Up Date. The date range entered above will select closed RAs by their pick-up (opening) date.

EXAMPLE: Type D (RET)

Refer to the field "Monthly Totals" (below) for information on ways that these two fields interact.

4. LOCATION

Enter:

  1. Up to 6 alphanumeric characters to select a single location where RAs were opened.
  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)

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 AAA (RET)

6. MONTHLY TOTALS

If the report period is greater than 30 days, you have the option to have a subtotal print after every calendar month. Note that reporting periods of a month or less may also produce a 'multiple month' report - see the User tip below.

Enter one alpha character to indicate whether or not monthly subtotals should be calculated.

Y = Yes, calculate and print a subtotal for each calendar month if applicable. Closed RAs selected for the report according to the data entered in the fields above will be reported in the month in which they opened.

N = No, do not calculate and print monthly subtotals

EXAMPLE: Type N (RET)

User tip: When this field is set to "Y" and the date range is a month or less, it can still produce a report that has data shown in two or more months. This can happen when the "Date Type" field is set to "DBR" date and there are batch closed RAs that have an opening date in one month and a DBR date in the date range requested.. For example, consider a RA that was batch closed in August (and has the August date as its DBR date), but was open in July.

When the report is run for the month of August:

  • if DBR date is selected in Date Type, and Monthly Totals are NOT requested, the RA will be included with all other RAs selected.
  • if DBR date is selected in Date Type, and Monthly Totals ARE requested, the RA will be listed under the month of July. (It is included in the report because it has an August DBR date, but listed by its pick-up date under July.)

Note that regardless of entering a "Y" or "N" in this field, the same RAs are included in the report. This field only affects how the RA revenue is sorted.

7. PRINT DESCRIPTION

Indicate whether or not the description for the Source Code should print on the report.

Y = Yes, print the Source Code descriptions.

N = No, print only the Source Code itself.

EXAMPLE:Type Y (RET)

8. PRINT/ DISPLAY

Enter:

P = Print a hard copy of this report on your terminal's assigned printer or send the report 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 your terminal screen. See the General Data Entry Instructions Chapter on how to control the screen display.

EXAMPLE: Type P (RET)

The screen will then display:

OPTION: __ SOURCE ANALYSIS REPORT

1 Start Date 08-01-12
2 End Date 08-31-12
3 Date Type D (D=DBR Date, P=Pick Up Date)
4 Location TUS
5 Source Code AAA
6 Monthly Totals N
7 Print Description Y
8 Print/Display P Printer: /dev/tyy


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

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