Booking Pace and Occupancy Forecasting Overview

The Booking Pace and Occupancy Forecasting module provides RDP customers the ability to analyze forecasted revenue and occupancy and compare the forecasts to the same time last year.  Over 20 reports are included, all of which can be modified with Crystal Reports.  A wide variety of additional reports can easily be created to analyze data.  For example, on 2/1/2004, you could run a report that showed the total number of rooms booked, and revenue for the period 3/1/2004 to 6/30/2004.  The report includes totals for the same time frame last year (i.e., on 2/1/2003, what was booked for 3/1/2003 to 6/30/2003).  This allows management to analyze if the booking pace is ahead or behind last year.  Any date ranges are possible.

Each night the system takes a "snapshot" of all reservations and stores this data in a forecast file.  This data is stored forever, limited only by available disk space.  The data includes a wide variety of sorting capabilities

Weekly Production Report

Below is a screen shot of the Weekly Production report.  It shows total rooms/revenue for each week, along with the growth percentage from the previous week.  The far right offers comparisons to the same periods last year. 

Six Month Projection

The Six Month Projection Report is designed to show Reservation totals for the current month and next 5 calendar months.

Six Month Booking Reports:  The Six Month Booking Reports shows occupied rooms sold and occupancy percentages for up to 6 months from the user defined "Booking Date."  RDP offers a variety of Six Month Reports that allow a focus on Group/Wholesalers, Market Codes, Source of Business, etc. 

Guest Origin Report

Guest Origin report tracks Room Nights or Occupied Counts per Salesperson.  User defined parameters allow any date range to be chosen.  In the example below the user inputs a date range of  7/1/2002 – 7/31/2002. Once dates are chosen, Occupied Counts are grouped per Region.  Region in this case is defined as North East, Mid West, South, etc.  These regions are defined in the CC table in RDP.  Within each Region, Room Nights Sold or Occupied Counts are further broken down per Salesperson.  Within each Salesperson, Occupied Counts are separated for each State within their Territory.  RDP has also created similar reports to show financial production instead of Room Nights.

Weekly Growth Comparison Between Two Dates

Growth Reports:  To help analyze growth and booking pace, RDP has created a variety of "Growth Reports."  These reports take two date inputs and then do comparisons and variances between them.  Currently RDP offers daily, weekly, and monthly options, but further reports can be created based on specific property requests.

Forecasting Snapshot for One Date

Travel Agent/Wholesaler/Tour Operator Forecast

The Wholesaler / Tour Operator Forecast is a Monthly Cross Tab report showing Occupied Nights for each day of the month per Wholesaler.  This report could be run for larger or smaller date ranges.  Grand and Variance Totals for Current and Prior Week per Agent are displayed in Report Footer.  RDP has also provided a separate version of this report without the Cross Tab chart.  This allows for a larger range to be run without the formatting issues associated with Cross Tabs.

Wholesaler/Agent Performance by Office

Wholesaler/Agent Room Night Comparison

Their are two different versions of the Room Night Comparison report.  Both versions focus on Travel Agent/Wholesaler production.  One version reports on Occupied Counts, and the second version reports on Room Revenue. 

The Room Night comparison always shows a four-month window of reservation activity.  The report prompts you once for beginning date.  The report will run from that date, and the next three calendar months.  Occupied Counts or Revenue Amounts will display per month for the current year and prior year along with a Variance amount between the two.  Total amounts display in far right column of report. 

Grand Totals and Variance Totals for each month are displayed in Report Footer.

Additional Reports Available

The Booking Pace and Occupancy Forecasting module is available today with over 20 reports.  Like all RDP modules, further enhancements and capabilities will be added based up feedback and requests of RDP customers.  RDP has always had the philosophy that the customer is responsible for the future of RDP. and enhancements and future improvements will be done based on what the customer wants.  Please Contact RDP Sales at 970/845-1140 for questions or custom report requests.