Rooms Forecast Report

The Room Forecast Report lets you evaluate forecast accuracy by comparing both your forecast and LMS's forecast to actual data. Forecasting the occupied rooms helps you staff your department appropriately for the level of business. This report not only shows how many rooms are forecasted for future days, but also helps you gauge their accuracy.

Click image to view a sample report.

Key Information

Sources of information:
- Forecasts for rooms, guests, and arrivals for Group and Contract segments are supplied by the Reservations/Sales departments, depending on your property.
- The Reservations department supplies book counts for all Transient segments (though not detailed on the report, these counts are essential to the forecast process). LMS then generates a forecast for Transient segments.
Each market segment has four associated KBIs (Rooms, Guests, Arrivals, and Departures). This report summarizes its data by segment, as well as simple variance percentages between the actuals and forecast.

Report Options

Period End Date	Allows you to designate the appropriate date range for the report. You can use the calendar or arrows to select the date.
Market Group	Allows you to determine whether one specific market group or all market groups are included in the report. Market groups are used as reporting mechanisms to help you track and forecast categories of rooms and guests.
Market Segment Types	Allows you to determine which market segment type(s) are included in the report. There are two main categories of market segments: Rooms, which represent market segments that are room-related, are categorized into several market segment types (Contract, Group, Transient, and Non-Revenue), and Casino. The casino type is a unique entity. Contract. Represents rooms that are held each day for an organization at an agreed-upon rate. For example, rooms held for airline personnel. If you have several contracts and rates, and need to see the different rates associated with the number of people per each rate, you may want to create market segments for each, and choose the same Type. Group. Represents rooms used by organizations or associations. Your Sales Department usually books this segment type. If you have certain groups with special needs, or other issues that require more resources than normal, you may want to create other segments. For example, you may have a group that routinely requires more time to clean their rooms which means that you would need to staff differently when they are in residence. Transient. Represents guests who made their own reservations (through a travel agent or your reservations department) and are not associated with a group or contract. Typically, business or commercial travelers and tourists comprise the transient market segment. If you need to know the different types of guests in this group, you may want to create separate market segments for each. For example, for marketing purposes you may want to know how many guests are AAA, AARP, etc. Casino. Represents the Casino type of market segment that is used to forecast Casino Admissions, Players, or Guests. This segment type is not included on any market segment reports that are associated with an occupied hotel room. Non-Revenue. Denotes rooms which are provided on a complimentary basis for any of a variety of reasons. Many properties do not use this category as they prefer to associate complimentary rooms with the group or transient segments. For example, some group contracts call for one complimentary room for a certain number of rooms bought by a group. Thus, the complimentary group rooms would appropriately be associated with the Group segment as is impacts occupancy in that segment and, in some organizations, are incorporated in the ADR calculation.
Summary	Displays only totals for each market segment type.
Detail	Displays data for each market segment, as well as totals for the market segment type.
Arrivals, Guests and/or Departures	Allows you to denote whether you wish to have this additional data displayed in the report.
Print Row with Zero Values	Displays all market segments, even if they have zero values.

Running the Report

To run the report:

Choose Labor from the Reports menu.
Click Forecasting and select Rooms Forecast. The Options dialog box appears.
Enter a Period End Date or you may use the calendar or arrows to select a date.
Select a specific Market Group or All market groups from the drop-down list.
Select the Market Segment Types that you want to view. You may select any or all of the types.
Select either Summary or Detail.
Select Arrivals, Guests and/or Departures if desired.
Select or de-select Print Row with Zero Values.
Click the Run icon. The report is displayed.

Report Terms & Definitions

Actual	Displays the actual business volume per segment that occurred on that day. This information is available after the forecast week has taken place.
Stat Forecast	Displays the forecast per segment based on forecasting methodologies established in the system configuration process.
Stat Variance	Displays the variance between actuals and the statistical forecast per segment.
Mgr Forecast	Displays the manager's forecast that you generated. These are the numbers that you feel the unit will do based on your experience. LMS will plan labor based on your edits.
Mgr Variance	Displays the variance between actuals and the manager's forecast.
Avail. Rooms Fst	Displays the results of configured rooms minus the sum of all market segments being forecasted.
Avail Rooms Act	Displays the results of configured rooms minus the sum of all market segments that were sold.
Pickup Rooms	Displays the number of rooms gained since the forecast was completed. This calculation is based on the forecasted rooms minus actual rooms sold.

Rooms Forecast Report

Key Information

Report Options

Running the Report

Report Terms & Definitions

Related topics: