|
|
|
Forecast / Availability Book (REP_ROOMS.REP with REP_ROOMS.FMX)
This form has the ability to print the rooms forecast report as well as the rooms availability report. These two reports form a unit that combined paints an accurate pictures of the on-the-books group business for the coming month(s) compared to targets and budgets. The rooms forecast sheet will show a daily breakdown of number of rooms booked versus number or rooms picked-up for each group horizontally across the page, so that a whole month worth of business can be viewed at once.
The availability sheet contains several sections of different data. It summarizes the day-by-day group business by booking status and compares it against the Sales Allowance (if existing). Also on a per day basis the contract figures, target figures, current total pick-up are displayed and several variances are calculated. At the bottom of this sheet the monthly group budget prints and can also be compared against the figures currently on the books.
Note: Due to the fact that this report uses configured periods as date parameters rather than calendar dates, this report can not be used with the Report Scheduler.
Please note that this report is primarily meant as a forecast tool, not as a report that will report production. Therefore the figures on this report, if printed for past dates, should not be balanced or compared against any of the booking production reports. This report can be run in PMS only properties as well as in S&C.
Note: When printing this Report help topic, we recommend printing with Landscape page orientation.
Note: This report requires that the user be granted the BLOCK PRINT permission in the selected property to run the report. Also, the Property LOV in this report is further limited by the properties to which the user has the appropriate access granted.
Property. Available when OPS_MHT2 license is active. Choose the property for which the report should be printed.
Date Range - Include Past Dates. Select this option to allow this report to print dates prior to the current date.
Period From/To. Allows the selection of a date range either spanning one or several calendar month(s) or fiscal periods, depending on how the hotel has been configured.
Rooms Availability/Forecast Flags. Allow to select if either only the forecast sheet should print, only the availability sheet or both.
Origin. Business block origin. Select the down arrow to choose one or more of the following (available values depend on the active modules and licenses):
Name. Possible options are Business Block Name or Primary Account Name. Whatever option is chosen here will print on the booking forecast sheet.
Note: When this report is printed by Account Name, the following logic is used: If a Company profile is attached to the booking, then the Company profile will print. If no Company profile is attached, but an Agent profile is present, then the Agent profile will print. If no Company and no Agent profiles are attached, but a Source profile is present, then the Source profile will print.
Status. Only bookings of the selected status(es) will be included in the report.
Note: The data on the Rooms Forecast and Rooms Availability reports is sorted by status code in the configured sequence order.
Summary Info Status. Allows the selection of one or several combined statuses that will be used to be compared to contract, pick-up, and target figures in the summary section of the report. These statuses will also be combined for a group ADR and Total Room Revenue for each date.
Budget Status 1&2. Allows the selection of one or several status in each filter field to compare against the group budget for the month.
RevPor Type. Will show an LOV of configured catering revenue types. The catering revenue that is linked to the revenue types selected here will be taken into account when calculating the revenue per occupied room on the forecast sheet (the catering revenue of the selected types plus the room revenue divided by number of room nights make up the calculation of the RevPor figures).
Note: For Master Allocations, calculations RevPor are based on the number of available rooms, not the number of rooms blocked.
Market Segment. Will include only bookings of the market segments chosen in this field.
Net Revenue. Select this flag to display Net room revenues. When this flag is NOT selected, gross room revenue will be calculated.
Copies. Determines the number of copies that will print, when the Print button is selected.
Currency. Select the currency in which the revenues on this report will display.
Preview. Use the preview option to view the generated output of this report in PDF format.
Print. Use the Print button to print the report to the selected output.
File. Prints the generated report output to an *.rtf file.
Close. Closes this report screen.
The Availability Book. The first section of the availability book is made up of the total per booking status of the data that is displayed in detail on the forecast book. The totals per status that shown are: average rate, total number of room nights, total revenue, followed by a breakdown of room nights day-by-day for the whole month for the appropriate status across the page. If the hotel operates with a sales allowance, the total rooms per day allocated to the sales allowance will print above the first status total. Following the status details a ‘Rooms Available’ line will print. The total that are displayed in this line are calculated by deducting all room nights of deduct-inventory status from the total sales allowance for the day. The last line in this section shows the sum of all rooms by day that are lined to bookings. Please note that even lost and cancelled status total are added in order to arrive at the total ( if these have been included in the status selection).
The second part of the availability book contains section titled summary information. All information that is printed in the section pertaining to current revenue and average rates depends on the ‘Summary Information Status’ filter .The average rate and revenue for each day in the printed month will show, followed by details of contracted room nights, revenues and average rates, picked-up room nights (picked up rooms are never reported for Master Allocations), revenues and average rates, and daily targets for room nights, revenues and average rates if these have been entered. Subsequent rows will show the calculated variance of current figures to contract figures (as entered into the contract room grid on each booking, if used) as well as the calculated variance of current figures to daily targets. All of the above figures are calculated and displayed on a day-by-day basis. For Master Allocations, calculations are based on available rooms, not the number of rooms blocked.
The last section of the report shows the group budget figures that have been entered for the month and the status summaries for the whole month of those statuses that have been selected in budget status 1 and budget status 2 in the filter form. The totals for the statuses selected in budget status 2 will be compared against the budget and the variance printed.
The Forecast Book. If multiple booking statuses have been selected to be included in the report the report is sorted first by booking status in alphabetic order of status code. Within each status code group bookings are sorted by arrival date. For each booking two lines are printed horizontally across the page. The first line per booking contains the status, the internal booking Id number, the booking name or primary account name depending on what had been chosen in the Name filter on the report order form. The rooms owner initials will print, followed by the average rate, total number of room nights, revenue per occupied room (calculated by adding room revenue and catering revenue of the catering revenue types selected on the filter and then dividing the total sum by the total number of room nights. The last two details to print are the room revenue and the market segment the booking belongs to. The rest of the line is divided into number of days of the appropriate month or fiscal period and shows the number of room nights booked on each day for the booking. The second line contains the pickup figures (picked up rooms are never reported for Master Allocations) of the same booking as total and per day, if pick-up exists. For Master Allocations, calculations for Rooms, RevPor and Revenue are based on the number of available rooms, not the number of rooms blocked.
Note: When the application function Blocks>Master Allocations is active, and a Master Allocation is included on this report, these blocks are indicated by an asterisk(*) to the left of the Business Block Names, as well as in the footer.
