Occupancy Summary
Report Description: The Occupancy Summary report provides a detailed breakdown of the total occupancy for a defined date, including room revenue, room availability, sold rooms, room status, guest statistics, and revenue per available room (REVPAR), aiding in monitoring and optimizing hotel occupancy.
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 for which the occupancy is being forecasted |
Not Applicable |
Not Applicable |
|
Day of Week |
Day of the week for the date being forecasted |
Not Applicable |
Not Applicable |
|
Room Revenue |
Total room revenue |
NO |
=sum(room revenue) |
|
Total Rooms |
Total number of rooms
Total rooms does not consider OOO for the day |
Not Applicable |
=sum(total inventory) |
|
Sold Rooms |
Total number of rooms that have been sold excluding group allocated rooms. |
Not Applicable |
=sum(transient reservations) + (group reservations) |
|
Rooms Sold Excluding Complementary |
Rooms sold for the date excluding complimentary rooms |
Not Applicable |
rooms sold = (sold rooms) - (comp rooms) |
|
Out of Order |
Total number of rooms that are currently out of order or unavailable |
Not Applicable |
=sum(out of order rooms) |
|
Vacant Rooms |
Number of rooms available for occupancy |
Not Applicable |
=sum(total rooms) - (sold rooms + down rooms) |
|
Clean Rooms |
Number of rooms ready for guest check-in |
Not Applicable |
=sum(total rooms) - (dirty rooms) |
|
Dirty Rooms |
Number of rooms awaiting cleaning |
Not Applicable |
=sum(dirty rooms) |
|
Stayover Rooms |
Number of rooms where guests are staying for consecutive nights |
Not Applicable |
=sum(stayover rooms) |
|
Same Day Bookings |
Number of rooms booked on the same day of arrival |
Not Applicable |
=sum(same day bookings) |
|
Comp Rooms |
Number of complimentary rooms provided |
Not Applicable |
=sum(complimentary rooms) |
|
House Rooms |
Number of rooms used by the hotel staff |
Not Applicable |
=sum(house rooms) |
|
Zero Rate Rooms |
Number of rooms booked at a zero rate |
Not Applicable |
=sum(zero rate rooms) |
|
Day Use Rooms |
Number of rooms booked for day use only |
Not Applicable |
=sum(day use rooms) |
|
Total No Shows |
Total number of reservations where guests did not arrive
This number excludes late cancellations |
Not Applicable |
=sum(no shows) |
|
Total Cancellations |
Total number of reservations canceled by guests
This number includes late cancellations |
Not Applicable |
=sum(total cancellations) |
|
Total Guests |
Total number of guests accommodated |
Not Applicable |
=sum(adults) + (children) |
|
Total Guest Certificates |
Total number of guest certificates used |
Not Applicable |
=sum(guest certificates) |
|
ADR |
Average daily rate for all occupied rooms |
NO |
ADR = (revenue / rooms sold) |
|
ADR without Complementary and House Rooms |
Average daily rate for the specified date, excluding COMP and HOUSE USE rooms |
NO |
ADR = (revenue) / (rooms sold - comp and house use rooms) |
|
Occupancy including OOO, Comp and House Use |
Occupancy including down (out of order), complementary and house use rooms |
Not Applicable |
occupancy = (rooms sold / number of rooms available) |
|
Occupancy excluding OOO, Comp and House Use |
Occupancy excluding out of order, complementary and house use rooms |
Not Applicable |
occupancy = (rooms sold) / ((number of rooms available - (OOO - comp - house use)) |
|
Occupancy including OOO Excluding Comp and House Use |
Occupancy including out of order but excluding comp and house use rooms |
Not Applicable |
occupancy = (rooms sold) / ((number of rooms available - (comp and house use)) |
|
Occupancy Excluding OOO Including Comp and House Use |
Occupancy excluding down (out of order), including complimentary and house use rooms |
Not Applicable |
occupancy = (rooms sold) / ((number of rooms available - (out of order)) |
|
RevPAR with OOO Rooms |
Revenue generated per available room, including out of order rooms |
NO |
RevPar = (room revenue) / (number of rooms available) |
|
RevPAR without OOO Rooms |
Revenue generated per available room, excluding out of order rooms |
NO |
RevPar = (room revenue) / (number of rooms 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 room revenue and sold rooms data in a bar chart.
-
Grouping: ability to view the data grouped by: All, 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
-
-