Room Type Summary .ng
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) |
Down | 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