Forecast Report

Modified on: Wed, 23 Jan, 2019 at 9:35 AM

Applies to:          Rover PMS             Rover Overlay

Forecast Report


The Forecast Report displays your property’s projected revenue (forecast) and historical revenue (last year) based on confirmed reservation counts for a date or date range. This report does not generate data for cancellations or no show reservations. 


Include Tax? 


Depending on your forecasting needs, you may want to set your report to include (or exclude) taxes. By default, taxes will not be included. However, to include this parameter, simply (1) select Include Tax from the filter settings on the Reports page, or (2) select the grey tab from the bottom left of Forecasting page to reveal the hidden configuration menu. 





REPORT STRUCTURE  

 

*Note that the darker gray rows indicate weekend dates (Saturday and Sunday). 






REPORT TERMS


FORECAST


Date: 

  • The day the report is retrieving historical/forecasted data on.  


Arr (Arriving)

  • All reservation records with an arrival date that matches the selected date. 

  • Includes individual reservations, group (picked-up), and allotments (picked-up). 


Dep (Departing) 

  • All reservation records with a departure date that matches the selected date. 

  • Includes individual reservations, group (picked-up), and allotments (picked-up). 


Occ (Occupied) 

  • All arriving as well as in-house records that fall within the selected date/date range (the date must be on or after the reservation’s arrival date AND before the reservation’s departure date). 

  • This report includes individual reservations, group (picked-up), and allotments (picked-up) AND any group block/allotment rooms that have not been picked up yet. 

    • Example (Group): A group block was created requiring 10 Superior King rooms, and only 5 rooms have been picked up. The 5 picked up rooms AND the remaining 5 Superior King rooms will all be calculated into the total occupancy (until the rooms are released back into the hotel's total room inventory). 

    • Example (Reservation): If a guest were arriving on September 11th and departing on September 15th, only the following dates will be considered for occupancy stats (OCC): Sept 11th, Sept 12th, Sept 13th, and Sept 14th 

      • Here is a breakdown of the totals: 

        • Sept 11th: 1 count will be figured into the total ARRs and 2 counts for OCCs. 

        • Sept 12th: 1 count will be included in the total number of OCCs. 

        • Sept 13th: 1 count will be included in the total number of OCCs. 

        • Sept 14th: 1 count will be included in the total number of OCCs.

        • Sept 15th: 1 DEP count will be figured into the total departures. 


Occ 100% (Occupancy Percent) 

  • Number of rooms occupied (rooms sold) divided by the total number of rooms in the hotel. 


Adult: 

  • The number of adults with matching arrival and stayover dates, including individual, group (picked-up), and allotments (picked-up). 

  • PLUS, rooms that have been blocked for group/allotments but have not been assigned to a reservation yet.  


Child: 

  • The number of children and infants from all reservation records with matching arrival and stayover dates, including individual, group (picked-up), and allotments (picked-up). 


Rev (Room Revenue) 

  • The projected room revenue pulled from all future reservation records, including individual, group (picked-up), and allotments (picked-up). 

  • PLUS, rooms that have been blocked for group/allotments but have not been assigned to a reservation yet.  


ADR (Average Daily Rate) 

  • The total room revenue divided by the date’s occupied rooms. 


LAST YEAR 


ADR (Average Daily Rate) 

  • The total room revenue divided by occupied rooms (based on the same date exactly one year ago). 


Occ 100% (Occupancy Percent) 

  • Number of occupied rooms divided by the number of rooms in the hotel one year ago. 


Variance 

  • Current occupancy percentage minus the occupancy percentage from last year.




REPORT FILTERS 


1. Date Range

  • Select a date or date range.


2. Options(s)

  • Exclude Non-Guaranteed: Check to remove any non-guaranteed (i.e. non picked-up rooms associated with groups/allotments).

  • Include Tax: Check to include tax calculations.  


3. Company/TA/Group

  • Enter a prompt to search for a particular Company, Travel Agent, or Group.  


4. Market(s)

  • You may choose to sort by market. Markets help your property classify how revenue is generated based on reservation bookings (Settings > Reservations > Markets). The Market toggle needs to be ON or Rover will not collect these details during reservation creation or from the reservation's Stay Card.


5. Sources(s)

  • You may choose to sort by sources. Rover will display the different "source" or channel(s) through which reservations are obtained (Settings > Reservations > Source). The Sources toggle needs to be ON or Rover will not collect these details during reservation creation or from the reservation's Stay Card.


6. Origins(s)

  • You may choose to sort by origin of booking. Rover will display the different "origins" or avenue(s) through which reservations are booked based on your property's setup (Settings > Reservations > Origin of Booking). The Origin of Booking toggle needs to be ON or Rover will not collect these details during reservation creation or from the reservation's Stay Card.




SHOW OR EXPORT?


Lastly, you have the option to choose to "show" the report based on your configurations as well as export a .csv file of the report.


SHOW


Specify your report's configuration options and click show.


QS2mK0h5ABkUbzs7DXfiNRdQgtTZaZKk0g.png


EXPORT 


Or click the the export button to download a .csv file of the report. The export button appears in two places: (1) at the bottom of the Forecast Configure Report and (2) in the right hand corner of the Forecast Report. 


7_9rFv-4MTIUyZICYEIfOiOulJ8OAAEh5g.png

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.