Enterprise Report - Rates Inventory and Availability Calendar
Enterprise Rates Inventory & Availability Calendar
Report Description: The Enterprise Rates Inventory & Availability Calendar Report offers a forward-looking overview of revenue and occupancy for a region by providing a detailed breakdown of the total occupancy and revenue for a defined date of a specific property; 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: Up to 30 days in the future
Occupancy and Revenue Section: provides an overview of revenue and occupancy for the defined dates for all properties in the region.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Property Code | Identifies the hotel code | Not Applicable | Not Applicable |
Property Name | Identifies the name of the hotel | Not Applicable | Not Applicable |
Property City | Identifies the City the hotel is operating | Not Applicable | Not Applicable |
Property State | Identifies the State the hotel is operating | Not Applicable | Not Applicable |
Rate Plan Code | Code given for the rate plan | Not Applicable | Not Applicable |
Rate Plan Name | Name for the rate plan | Not Applicable | Not Applicable |
Room Type Code | Unique code assigned to the room type | Not Applicable | Not Applicable |
Room Type Name | Name of the room type | Not Applicable | Not Applicable |
Total Rooms | Total number of rooms Total rooms does not consider OOO for the day | Not Applicable | =sum(total Inventory) |
Sold Rooms Including Group Picked Up | Total number of rooms that have been sold including group allocated rooms. | Not Applicable | =sum(transient reservations) + (group rooms picked up) |
Out of Order | Total number of rooms that are currently out of order or unavailable | Not Applicable | =sum(out of order rooms) |
Available Rooms | Total number of rooms that are currently available for sale | Not Applicable | available rooms = (total inventory) - (sold rooms - group allocated - out of order) |
Arrivals | Number of expected arrivals on the date being forecasted | Not Applicable | =sum(arrivals) |
Stayovers | Number of guests who are expected to extend their stay beyond the date being forecasted | Not Applicable | =sum(stayover reservations) |
Departures | Number of guests who are expected to check out on the date being forecasted | Not Applicable | =sum(departures) |
Room Revenue | Total number of rooms that have been sold including group allocated rooms. | Not Applicable | =sum(transient reservations) + (group rooms picked up) |
ADR | Average daily rate for all occupied rooms | NO | ADR = (revenue / rooms sold) |
Occupancy | The number of rooms that are currently occupied by guests | NO | sum= (rooms sold / 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) |