
Forecast Report
OVERVIEW
The Forecast Report highlights occupancy and room revenue for a given date range. The report provides the details for the requested days and a comparison of that day to the prior year.
REPORT FILTERS
DATE RANGE (FROM/TO) | Select a date range. |
OPTION(S) | Choose from SELECT ALL, EXCLUDE NON-GUARANTEED, and/or INCLUDE TAX. |
COMPANY/TA/GROUP | Search for a Company, Travel Agent, or Group. |
MARKET(S) | Choose from SELECT ALL or other individual markets. |
SOURCE(S) | Choose from SELECT ALL or other individuals sources. |
ORGIN(S) | Choose from SELECT ALL or other individual origins. |
REPORT OUTPUT
The Forecast Report can be printed or exported via CSV, and it will appear in the Reports Inbox as pictured in the section below. You will see the following fields on the report:
- FORECAST
- DATE
- ARRIVAL
- DEPARTURE
- OCCUPANCY
- OCCUPANCY %
- ADULTS
- CHILDREN
- REVENUE
- ADR
- LAST YEAR
- DATE
- OCCUPANCY %
- VARIANCE
REPORT TERMS
Forecast
- ARR (Arrivals)
- Count of reservations with an arrival date for that day. This includes individual reservations and picked-up group/allotment reservations.
- Exclusions: Day use, no show, cancelled, and not picked-up groups/allotments.
- DEP (Departures)
- Count of reservations with a departure date for that day. This includes individual reservations and picked-up group/allotment reservations.
- Exclusions: Day use reservations, no show reservations, cancelled reservations, not picked-up groups/allotments.
- OCC (Occupied)
- Count of arrival reservations + stayover reservations (arrival date in the past and departure date in the future). This includes individual reservations, definite group rooms, and picked-up allotment reservations.
- Exclusions: Day use reservations, no show reservations, cancelled reservations, and not picked-up allotments.
- OCC % (Occupancy %)
- (Number of rooms occupied divided by number of rooms in the hotel) multiplied by 100.
- Exclusions: Suite and pseudo rooms.
- ADULT
- Number of adults from all reservation records (excluding cancelled and no show), arrival and stayover for that date (individual reservations, picked-up group/allotment reservations), PLUS not picked-up group rooms calculated based on occupancy.
- CHILD
- Number of children and infants from all reservation records (excluding cancelled and no show) and arrival and stayover for that date (individual reservations, picked-up group/allotment reservations).
- REV (Room Revenue)
- This is the total sum of all posted revenue classified as room. This includes any report date in the future, any revenue from not picked-up group room blocks, and any projected revenue from reservations that are not cancelled. For historical dates, the revenue should match the journal.
- ADR (Average Daily Rate)
- Room revenue divided by occupied rooms.
Last Year
- ADR (Average Daily Rate)
- Room revenue for the same date last year divided by occupied rooms for the same date last year.
- OCCUPANCY %
- (Number of occupied rooms one year ago divided by the number of rooms in the hotel one year ago) multiplied by 100.
- VARIANCE
- Occupancy % minus Occupancy % last year.
Items to Note:
- Not Picked-Up Group Room Block Revenue
- Projected revenue from a group room block is a calculation based on the total sum of remaining occupancies and corresponding rate amounts.
- Single Occupancy
- Single Occupancy Amount multiplied by the Single Occupancy Size.
- Double Occupancy
- Single Occupancy Amount multiplied by the Double Occupancy Size.
- Triple Occupancy
- (Double Occupancy Amount + Extra Adult Occupancy Amount) multiplied by the Triple Occupancy Size.
- Quadruple Occupancy
- (Double Occupancy Amount + Extra Adult Occupancy Amount multiplied by 2) multiplied by the Quadruple Occupancy Size.
- Suites
- For suite reservations, the number of component rooms is used for calculations.
REPORTS INBOX
PRINT REPORT
CSV EXPORT