Room Type Summary
Report Description: The Room Type Summary report displays a summary of room types and their performance during a specified date range. This report helps property staff identify trends and patterns in room types in order to make informed decisions about promotions, revenue management and resource allocation.
Date Range: The report can render the data for up to 90 days in the past
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Date |
The date for which the forecast is provided |
Not Applicable |
Not Applicable |
|
Day of Week |
The day of the week corresponding to the date |
Not Applicable |
Not Applicable |
|
Room Type Name |
Name of the room type being summarized |
Not Applicable |
Not Applicable |
|
Room Type Code |
Unique code assigned to the room type |
Not Applicable |
Not Applicable |
|
Adult |
Number of adult guests associated with the reservation |
Not Applicable |
=sum(adults) |
|
Children |
Number of child guests associated with the reservation |
Not Applicable |
=sum(children) |
|
Total Guests |
Total guests associated with the reservation |
Not Applicable |
=sum(adult) + (children) |
|
Room Available |
Total number of rooms available for the room type being summarized |
Not Applicable |
room available = (total room type inventory - sold) |
|
Vacant Rooms |
Number of rooms for the room type that are currently vacant and available for sale |
Not Applicable |
=sum(vacant room type count) |
|
Out of Order |
Number of rooms for the room type that are currently out of order or unavailable |
Not Applicable |
=sum(room type OOO count) |
|
Sold |
Number of rooms for the room type that have been sold |
Not Applicable |
=sum(room type sold count) |
|
Room Revenue |
Total revenue generated from the sale of the room type during the specified date range |
NO |
=sum(room type revenue) |
|
ADR |
Average daily rate for the room type |
NO |
ADR = (room type revenue) / (room type sold) |
|
Occupancy |
Percentage of sold rooms out of the total available rooms for the room type |
Not Applicable |
occupancy = (room type sold) / (total room type inventory) |
|
RevPAR with OOO Rooms |
Revenue generated per available room for the room type, including down rooms |
NO |
=sum(room type revenue) / (room type available ) |
|
RevPAR without OOO Rooms |
Revenue generated per available room for the room type, excluding down rooms |
NO |
=sum(room type revenue) / (room type available - OOO) |
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 Adults, Children, Total Guests, Room Available, Vacant Rooms, Down, Sold and Room Revenue data in a bar chart.
-
Grouping: ability to view the data grouped by: All, Room Type Name, 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
-
-