Reports v2: Room Forecast

Created by Alex Savchuk, Modified on Fri, Mar 15 at 7:10 PM by Alex Savchuk

The Room Forecast Report shows the status of the rooms that have been booked for the date range selected on the report. This report can be pulled for past, present, and future date ranges.

This report cannot be run for 'Multiple' Properties. In the case of multiple properties, a single property needs to be selected, for this report to be run.

Input

Stay on Date Range	The predefined options, along with a custom date picker for this field are - Today, This Week, This Month, Next 7 Days, Next 30 Days, Next 90 Days.
Break Out By	Break-out by Room class - Displays the report data for each room class, within the selected date range. Break-out by Market Segment - Displays the report data for each Market Segment, within the selected date range.
Group Rows By	The data in the report can be grouped by – Days, Weeks, Months, Year
Include Performance Metrics	Select this option to include the revenue metrics like Revenue, RevPAR and ADR, on the report output. ('Yes' by default).
Include Group Reservations	Includes data for Group Reservations. ('Yes' by default)
Include Inactive/ Obsolete Rooms	Includes data for Inactive or Obsolete rooms. ('No' by default)

Output

The output of the Room Forecast report has been reformatted and has tooltips to explain all columns.

 Abbreviations used on this report

Abbreviations	Definitions
OOO	Out of Order
OCC%	Occupancy Percentage
AVL	# of rooms available
GST	total # guests on all reservations
ARV	Arrivals
S/O	Stay-overs
DEP	Departures
NGTD	Non-Guaranteed reservations (Reservations with the status On Hold, Confirmed or Reserved)
GTD	Reservations with the Guaranteed statusF
GTD%	Percentage of reservations that have the status Guaranteed
BLK	Group block reservations
P/U	Number of reservations picked up from Group blocks
P/U %	Pick up the percentage of reservations picked up from Group blocks
ADR	Average Daily Rate
RevPAR	Revenue Per Available Room

Calculations

Rooms

TOT	SOLD	OOO	OCC %	AVL
Total number of physical rooms present	Number of rooms sold (b)	Number of rooms set to maintenance (c)	Occupancy percentage=Percentage of rooms occupied	Available rooms= Total number of physical rooms – number of rooms sold – number of rooms set to maintenance
a	b	c	=b/(a-c)	=a-(b+c)

Total

GST	ARV	S/O	DEP
Total number of guests present on all reservations	Total number of arrivals	Number of reservations staying over	Total number of departures

Arrivals

NGTD	GTD	GTD%
Non-guaranteed reservations-with statuses on-hold, reserved and confirmed	Reservations with guaranteed status-with credit card saved as the payment method	Percentage of reservations with guaranteed status

Groups

BLK

PU%

REVENUE

Total number of rooms blocked for a particular group block, on a given day, as on the printed-on time of the report

Number of reservations picked up from Group blocks

Picks up the percentage of reservations picked up from Group blocks

Revenue from reservations associated with groups

Estimated Totals

REVENUE

ADR (Average Daily Rate)

RevPAR (Revenue Per Available Room)

Total revenue from all reservations on a given date

Total revenue/ total number of rooms sold

Total room revenue/ Total rooms (excluding out of order rooms)

=d/b

Refer to the ROOMS table for the value of b

=d/(a-c)

Refer to the ROOMS table for the value of a and c

Attachments (3)

rf.png
109 KB

rf1.png
180 KB

rf2.png
188 KB