AAA Hotel is a large 300-room hotel with five ballrooms that can accommodate 200 guests respectively and up to 600 guests in a banquet setting. As the hotels sales representative, you received two new clients from Bills Jewelry and ABC Charity who want the same event dates. However, your hotel rooms would be overbooked if you take both meeting groups. Besides, there are already confirmed bookings with other organizations (see details in Table 1). You know that Bills Jewelry has a higher life-time value for the hotel but ABC Charity will occupy a large quantity of rooms as well as the use of a large banquet.

4. Explain how you would manage the meeting clients in order to maximize the hotels revenue. Propose three possible solutions, compare their estimated total meeting and room minimum guarantee you are expecting to receive on March 7-8 in the table below. Explain your final decision.

Table 1. AAA Hotel: Room Inventory Report as of December 4, 2021

Action / explanation Total estimated minimum guarantee for March 7-8 Solution 1 Solution 2 Solution 3 Notes: Average Room price is $1000 per night Suite price is $5000 per night Su M Total Total by Acc. 10 11 75% 40% 100 90 100 90 50 AAA Hotel (300 Rooms) Room Inventory Report March 4-12, 2021 Days of Week M T w Th F Sa Date 4 5 6 7 8 9 2020 Occupancy: 80% 80% 50% 65% 100% 90% AVG group demand 90 100 90 90 100 100 AVG transient demand (Include walk-in guests) 110 100 90 90 180 170 Definite Room Bookings @ $1000 per room on average & $5000 for suites XXX Association 100 100 100 XXX Financial Company 50 50 SHTM Alumni 50 50 Tentative Room Bookings Bill's Jewelry 20 20 ABC Charity Annual Fundraising Event 180 180 Rooms occupied 350 400 Estimated income with minimum guaranteed XXX Association (Meeting) 30.000 30,000 30.000 XXX Association (Average Rooms) 100,000 100,000 100.000 XXX Financial Company (Meetings) 120.000 120.000 XXX Financial Company (Average Rooms) 50.000 50.000 SHTM Alumni( Meeting) 20,000 20,000 20.000 SHTM Alumni (Average Rooms) 50,000 50.000 50.000 Tentative Bookings (estimated guaranteed meeting package) Bill's Jewelry (Meeting) 120,000 120.000 Bill's Jewelry (Rooms - suits + 2 average rooms) 80.000 100.000 ABC Charity Annual Fundraising Event (Meeting) 220,000 220,000 ABC Charity Annual Fundraising Event(Average Rooms) 180,000 180.000 Total daily estimated revenue 800,000 990,000 March 7-8 estimated revenue 1,790,000 90,000 300.000 390,000 120.000 360,000 50.000 510.000 150,000 60,000 150,000 210.000 240.000 180,000 420.000 440.000 360.000 800.000 1,790,000 Action / explanation Total estimated minimum guarantee for March 7-8 Solution 1 Solution 2 Solution 3 Notes: Average Room price is $1000 per night Suite price is $5000 per night Su M Total Total by Acc. 10 11 75% 40% 100 90 100 90 50 AAA Hotel (300 Rooms) Room Inventory Report March 4-12, 2021 Days of Week M T w Th F Sa Date 4 5 6 7 8 9 2020 Occupancy: 80% 80% 50% 65% 100% 90% AVG group demand 90 100 90 90 100 100 AVG transient demand (Include walk-in guests) 110 100 90 90 180 170 Definite Room Bookings @ $1000 per room on average & $5000 for suites XXX Association 100 100 100 XXX Financial Company 50 50 SHTM Alumni 50 50 Tentative Room Bookings Bill's Jewelry 20 20 ABC Charity Annual Fundraising Event 180 180 Rooms occupied 350 400 Estimated income with minimum guaranteed XXX Association (Meeting) 30.000 30,000 30.000 XXX Association (Average Rooms) 100,000 100,000 100.000 XXX Financial Company (Meetings) 120.000 120.000 XXX Financial Company (Average Rooms) 50.000 50.000 SHTM Alumni( Meeting) 20,000 20,000 20.000 SHTM Alumni (Average Rooms) 50,000 50.000 50.000 Tentative Bookings (estimated guaranteed meeting package) Bill's Jewelry (Meeting) 120,000 120.000 Bill's Jewelry (Rooms - suits + 2 average rooms) 80.000 100.000 ABC Charity Annual Fundraising Event (Meeting) 220,000 220,000 ABC Charity Annual Fundraising Event(Average Rooms) 180,000 180.000 Total daily estimated revenue 800,000 990,000 March 7-8 estimated revenue 1,790,000 90,000 300.000 390,000 120.000 360,000 50.000 510.000 150,000 60,000 150,000 210.000 240.000 180,000 420.000 440.000 360.000 800.000 1,790,000