Rooms Forecast Report

Owned by Julie Leake (Unlicensed)
Last updated: Jul 05, 2019 by mhigginbotham (Unlicensed)

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 forecast 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

OptionDescription

Period End Date

Designate the appropriate date range for the report. You can use the calendar or arrows to select the date.

Market Group

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

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

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:

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

Report Terms & Definitions

TermDefinition

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.


Related topics:

Unable to render {include} The included page could not be found.