Rate Plan Summary .ng
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