Room Revenue Analysis (stayanalysis2 with ORSSTAY2.FMX)

Note: When printing this Report help topic, we recommend printing with Landscape page orientation.

This report estimates the room revenue production within a selected date range. The room revenue report displays columns containing the number of Nights and Total Room Revenue, along with other filter criteria. The report divides the total revenue by the revenue amount per stay, and by the number of nights in the stay. See the calculation process below.

Room Revenue Analysis Calculation

Example:

Date Range Filter is: 01/01/05 – 01/31/05.

John Smith stayed at a selected property from 12/27/05 - 01/03/05 = 7 nights total.

The calculation process for room revenue by this report would be: Room Revenue for the entire stay is recorded (from the Stay Record) at $700.00. $700.00 divided by 7 nights = $100.00 revenue per night. Because the selected date range filter began at 01/01/05 and John stayed beginning 12/27/05, only two nights of room revenue would be calculated from this stay (from 01/01/05 through 01/03/05). 2 nights x $100.00 = $200.00 room revenue for that date range. Other stays generating room revenue within the date range would be calculated and added to this room revenue in the same manner.

Selection Criteria

Property. Select the property whose room revenue you want to view.

Revenue Date. Select the date range for the room revenue based on the revenue posting date. For V6/V7 properties, this would always be departure date -1.

Profile Filters

Select the profile filter parameters: Profile Country, Profile State, Property Country, Interest, Membership Type, Membership Level, Member Since date From/To, Age Bucket.

Profile Radio Button. Select one radio button for the profile type statistics for the room revenue: Company, Travel Agent, Group, Source, or Individual.
Rollup Entry field and LOV. Enter a profile name for the profile type or query the database for a profile.
Rollup. Selecting this radio button enables the report to combine the room revenue statistics of the selected profile with all subsidiaries (Company profile) and relationships (all profile types).
- None. No rollup (combined) statistics will be included.
- Master Account. When Company is selected, customers using the OCIS Corporate Agreement can view the Master Account and Subsidiaries rollup data.
- Relationship. Rollup statistics are available for all profile relationship types, if the relationship is between the same profile type. (This is available for customers having set up relationships in Configuration>Profiles>Relationship Types. The From Type and To Type must be of the same profile type, such as COMPANY to COMPANY, TRAVEL_AGENT to TRAVEL_AGENT, but not COMPANY to D-Individual. See Relationship Types for details.)
  When Relationship s selected, the LOV appears where users can select the type of relationship, i.e. FAMILY. Also, when this radio button is selected, the Hierarchy button appears where users can select and view the current profile’s hierarchical position in a “tree view” style diagram. Users can select the relationship type on the Hierarchy screen and reposition it at which level downwards they wish to report.

Stay Filters

Select the stay parameters you want included: Origin code, Market Code, Market Group, Source Code, Room Type, Rate Category, Rate Code, Minimum nights and enter room revenue amount ranges.

Group by

Group 1 and Group 2. Select one per group from the LOV: Property, Origin, Profile, Source, Country, State, Market Code or Age Bucket.

Order by

Order by. Select from the LOV the value of how you want the information ordered. Select if you want to display the information in Descending Order.