Occupancy by Room Type .ng
📆 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.