📆 Revision Date:
Occupancy by Room Type
Report Description: The Occupancy by Room Type Report provides a snapshot of expected occupancy levels for a hotel during a specific time period. This report helps property staff identify trends and patterns in occupancy in order to make informed decisions about revenue management and resource allocation.
Date Range: This report is available on the current date 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 recorded action |
Not Applicable |
Not Applicable |
|
Day of Week |
Day of the week for the date reported |
Not Applicable |
Not Applicable |
|
Room Type Name |
Name of the room type |
Not Applicable |
Not Applicable |
|
Room Type Code |
Unique code assigned to the room type |
Not Applicable |
Not Applicable |
|
Total Rooms |
Total number of rooms occupied on the date selected |
Not Applicable |
=sum(total room type) |
|
Available Rooms |
Total number of rooms for the mentioned room type that are currently available for sale |
Not Applicable |
room available = (total room type inventory - sold) |
|
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 Rooms Including Group Picked Up |
Number of rooms for the room type that have been sold in both general and group inventory |
Not Applicable |
=sum(room type sold count) |
|
Group Allocations |
Total sum of authorized rooms (AU Counts) for the room types. |
Not Applicable |
=sum(room type authorized/sold) |
|
Adults |
Number of adults for the sold room type |
Not Applicable |
=sum(adults) |
|
Children |
Number of children for the sold room type |
Not Applicable |
=sum(children) |
|
Room Revenue |
Total revenue generated from the sale of the room type during the specified date range |
Not Applicable |
=sum(room type revenue) |
|
Group Revenue |
Total member reservation revenue for the stay night |
Not Applicable |
=sum(Group reservations(s) accommodation revenue). Excludes tax. |
|
ADR |
Average daily rate for the room type |
Not Applicable |
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 |
Not Applicable |
=sum(room type revenue) / (room type available ) |
|
RevPar without OOO Rooms |
Revenue generated per available room for the room type, excluding down rooms |
Not Applicable |
=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.
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.