$[6$:$52$ PM$,2/4/2024]$ Moaaz Abourayya: The group would like to confirm $150$ guest rooms arriving on Monday, May $09$ for $3$ nights

The group will spend $$10,000$ per day in food and beverage associated with this meeting.

Their budget is $$275$ per night.

The transient rate that would be displaced on those nights would be $$350.$

Fill in the data in the yellow highlighted boxes with the information above. Upload the worksheet with your replies to the questions below

$1.$ Would this group be profitable for the hotel?

$2.$ What recommendations do you have for the sales manager to propose to the group to make the group more attractive for the hotel?

Remember $-$ every group is about rates, dates and space $-$ you can give the group any two $-$ as long as you control the third.

There are several factors that must be taken into consideration when evaluating the profit contribution of a Group which can be negotiated.

How much will the group spend in addition to rooms?

What is the profit on the additional amount spent? Catering dollars deliver significantly less profit than room revenue, so this must be calculated at a much lower profit percentage.

Is there meeting room rental or audio visual revenue with the group?

Are there rebates or commissions to be paid to the group?

$[6$:$59$ PM$,2/4/2024]$ Moaaz Abourayya: Understanding the Data and Structure:

The spreadsheet is designed to track hotel occupancy over a week.

It lists transient demand, forecasted group definitions, and total demand for each day of the week.

The highlighted yellow section seems to indicate new group opportunity room nights, which could be the potential room nights available for a new group booking.

The lower section of the spreadsheet includes financial summaries like new group revenue, displaced transient revenue, new group Food & Beverage $($F&B$),$ meeting room rental, and total group profit.

Explanation:

Hotel Capacity and Demand Tracking:

The top part of the spreadsheet is used to track the capacity of a hotel and its demand over the course of a week. Hotel capacity is a fixed number, in $...$

$[7$:$00$ PM$,2/4/2024]$ Moaaz Abourayya: Analyzing the Data:

The "Hotel Capacity" is given as

rooms.

The transient demand and forecasted group defines the expected occupancy.

The "New Group Opportunity Room Nights" seems to be calculated by subtracting the total demand from the hotel capacity, which indicates the number of rooms still available for booking.

The financial summaries will be calculated based on the room bookings and associated revenues, such as the Average Daily Rate $($ADR$),$ total revenue, profit percentage, and actual profit.

Explanation:

Calculating Opportunity and Displacement:

The section labeled "New Group Opportunity Room Nights" and "Total Estimated Roomnight Displacement" is likely used to calculate how many additional rooms could potentially be sold to groups $($opportun$...$

$[7$:$06$ PM$,2/4/2024]$ Moaaz Abourayya: Revenue Manager Comparison

Revenue managers A & B manage competing hotels with identical products and services. Using the information below, calculate the rooms, ADR, and revenue of each segment and the total rooms occupied, ADR, and revenue for the day for each hotel.

$($This exercise should preferably be completed in spreadsheet software $-$ attach if possible$)$

Revenue Manager A

Retail: $50$ rooms, $$12,500$ revenue

Business Transient: $$200$ ADR, $$8,000$ revenue

Government: $25$ rooms, $$170$ ADR

OTA: $40$ rooms, $$6,400$ revenue

Group: $35$ rooms, $$180$ ADR

Contract: $20$ rooms, $$120$

Revenue Manager B

Retail: $70$ rooms, $$240$ ADR

Business Transient: $50$ rooms, $$9,750$ revenue

Government: $5$ rooms, $$850$ revenue

OTA: $$9,100$ revenue, $$130$ ADR

Group: $40$ rooms, $$160$ ADR

Contract: The revenue manager decided not to pursue any contract business