Occupancy Summary .ng
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