|
|
|
Three Month Forecast Report (three_month_forecast with FOR5.FMX)
The Three Month Forecast is a three-month outlook report based on the number of room nights, room revenue, and average rate per market main group per month. The report can only be printed for three months at a time and can print either forecasted or statistical happenings. The report shows the actuals for last year, actuals or forecast for this year, and the budget for last year. You can include individual reservations that are deduct or non-deduct, block reservations (blocked and picked up) that are deduct or non-deduct (not including block rooms when the block status is INQUIRY, REGRET and LOST), and revenue figures. If you include revenue, you must choose whether to show the net room rate or the package room rate.
All columns can be compared with other forecast reports except for the Double Occupancy %. This is due to the fact Double Occupancy % is calculated by Persons – Rooms/Rooms. Other reports calculate Multiple Occupancy % (number of rooms occupied by more than one person/rooms occupied).
If the CASHIERING > BUDGETS application function is set to Y, the report output includes a column for defined budgets for market codes. If attempting to compare the report against the Actuals and Forecast, the three_month_forecast should be run for all reservations (i.e., deduct and non-deduct) as budgets do not take the reservations status into consideration. Additionally, if the Room Class functionality is activated and the user selects to filter on a specific room class, the budgets column does not appear. This report only prints budgets that are configured for calendar months, if fiscal periods are used and budgets defined for periods, this report does not include the fiscal defined budgets.
Year. Select the top half of the button to increase the year by one and the bottom half of the button to decrease the year by one.
Months. Select the down arrow to select the three month period that you would like to view the data for.
Room Class. When the GENERAL > ROOM CLASS application function is set to Y, select specific room classes from the Room Class multi-select list of values in order to view this data on the report. When selecting all the room class options from the Room Class list of values, all of the room class selections are populated in this field.
Individuals Deduct. Includes individual deducts.
Individuals Non-Deduct. Includes individual non-deducts.
Include Owner Only. Includes the owner only. This is only available when the OVOS license is activated.
Blocks Deduct. Includes block deducts.
Blocks Non-Deduct. Includes block non-deducts.
Revenue. Includes the revenue.
OOO in Occ. %. Exclude OOO rooms from the total rooms when calculating the occupancy percentage. The ROOMS MANAGEMENT > OUT OF ORDER application setting must be active for this check box to appear.
Net Room Rate. Room Revenue only reflects the revenues posted with transactions marked as room revenue. For each reservation, this can be matched to Reservation > Options > Rate Info > column of Room Revenue for selected date.
Package Rate. Room Revenue reflects all room revenue, package revenue, and taxes per night per reservation. For each reservation, this can be matched to Reservation > Options > Rate Info > Total value for selected date. The taxes include tax on the room as well as any taxes generated by a package.
Note: Prices and allowances displayed for packages will be the price and allowance from the configuration of the package when it was attached to the reservation. Since the package price and allowance is stored at the reservation level, package prices and allowances can be different from reservation to reservation and from within the Package configuration to the reservation.
