Business Block Lead Time Report (rep_block_leadtime)

The Business Block Lead Time Report is used to display multiple statuses (by date) and revenue types for Business Block bookings. The purpose of this report is to show the total lead time elapsed between the date the booking is created and the day the booking arrives at the hotel. This report reflects all booking status changes by date and the total number of days the booking stayed at each status. This report is particularly helpful for identifying the booking patterns of customers in order to accurately forecast anticipated group business and the time frame in which it will transpire. With options to select up to six different statuses and up to four different revenue types, this report can be either very simple or highly detailed.

Selection Criteria

Property: Enter or select the property. You can select multiple properties from a hub location. 

Date Range: Select the From and To dates to display the booking lead time for this time period.

Current Status: Select bookings by their current statuses. This filter is multi-select.

Account: Select the space type for which the report should be printed as, Single, Combo, or Both.

Market Segment: Select bookings in a particular market segment.

Status 1 - 6: Select the order in which the booking statuses display in the report.

Revenue Type 1- 4: Select the order of revenue type to display in the report. Each revenue type is multi-select. See Configuring Catering Revenue Types.

Currency: Available when the Ability to Quote Rates in Foreign Currency OPERA Control is active.

Report Data

This report presents each booking as a single record that displays from left to right. The columns on the right side display the arrival date, current status, block name, and booking ID for a single record. The center of the report displays the ordered statuses, the date each booking was changed from one status to another, and the number of days each booking was in specific status.

The far-right side of the report displays the date that the booking was placed in actual status; this is a default for this report and cannot be user defined. Each record can reflect up to four revenue types and their associated totals. Each record also contains, by default, the initial rooms count, average room rate (which is calculated inclusive of packages and taxes), total room count, and the total number of lead days per booking.

Catering Revenue prints per the regular principle: if an event is actual, the Actual/Billed revenue prints. If there are no Actual/Billed revenue and/or the event is not actual yet, the Guaranteed/Expected revenues print. If Guaranteed Revenue is higher than Expected Revenue, Guaranteed Revenue prints. If Expected/Guaranteed Revenues does not exist, the Forecast Revenues prints.

An exception to the above rule is made when the Use Forecast Revenue OPERA Control is active. In this case all events are created with the flag Use Forecast Revenue checked. While this flag is checked, all catering revenue in this report only come from the forecast figures, even if expected or guaranteed figures exist. The flag is unchecked automatically when the event turns actual but can also manually be deselected earlier in the life of the event.

The report summary at the end of the report shows the following:

• Total Number of Bookings.

• Total Number of Actual Bookings.

• Total Number of Room Nights.

  • For Master Allocations (indicated on this report by an asterisk (*) preceding the Block Name), the total number of room nights are the total number of available rooms, not the number of rooms blocked.

• Total Number of Actual Room Nights.

• Average Lead Time (for all bookings).

• Average Actual Lead Time (for bookings in Actual status).

• Conversion Bookings.

• Conversion Room Nights.