Rate Plan Summary
Report Description: The Rate Plan Summary report provides revenue, stays, ADR, occupancy contribution and RevPAR contribution statistics by rate plan for a defined date.
Date Range: This report can render the data for up to 365 days in the past
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Date |
Date of the associated reservations |
Not Applicable |
Not Applicable |
|
Day of Week |
Day of Week (Example - Sunday, Monday) |
Not Applicable |
Not Applicable |
|
Rate Plan |
Rate plan name |
Not Applicable |
Not Applicable |
|
Rate Plan Code |
Rate plan code |
Not Applicable |
Not Applicable |
|
Market Segment |
Market segment associated with the reservation |
Not Applicable |
Not Applicable |
|
Revenue |
Revenue for the associated date |
NO |
=sum(rate plan revenue) |
|
Stays |
Number of stays associated with the rate plan |
Not Applicable |
=sum(rate plan stays) |
|
ADR |
Average Daily Rate for the date and rate plan |
NO |
ADR = (revenue / occupied rooms) |
|
Occupancy Contribution |
Occupancy contribution associated with the rate plan across the occupancy for the day |
Not Applicable |
occupancy contribution = (stays) / (inventory - OOO) |
|
Revenue Contribution |
RevPAR contribution associated with the rate plan across the occupancy for the day |
NO |
revenue contribution = (revenue / total hotel inventory) |
Misc Report Information:
Available Features:
-
Export: ability to download and save the file into an alternate format.
-
Filter: filter a range of data based on criteria defined by the user.
-
Highlight: also known as conditional formatting is the ability to highlight certain values making them easier to identify.
-
Bar Graph: ability to view Occupancy Contribution, Revenue and Stays data in a bar chart.
-
Grouping: ability to view the data grouped by: All, Rate Plan, Rate Plan Code, Market Segment, Day of Week
-
Pie Chart: ability to view grouped data in a Pie Chart view.
Available Configuration:
-
User Preferences: allows the user to customize their report view by repositioning or removing columns.
-
Property Preferences: allows the property to customize the report view for all users by repositioning or removing columns.
Baseline Configuration:
-
Property Preferences Settings:
-
Following columns to be disabled for initial deployment:
-
Not Applicable
-
-