In your assigned group, complete the following project using the resources provided and guidelines below. Each team will submit one final submission on behalf of all members. 

Refer to the course schedule for due dates and the instructions for details.

The Elbow Bend Hotel

The Elbow Bend Hotel is located in Calgary’s East Village and has 100 Rooms total. The breakdown of room types is as follows:

 40 Deluxe Rooms, 50 Executive Rooms and 10 Suites. 

The Suites are always 100% sold out every month. The other two room types split equally to account for the remainder of rooms sold. Half of the rooms sold every day have double occupancy.         

The hotel has one casual fine- dining restaurant that is open for dinner daily from 6:00pm-9:00pm. It has 80 seats and is open year-round to support the hotel guests. The best-selling entrée in the restaurant is the Chef Signature Chicken. It accounts for 30% of all food menu items sold, while the best-selling beverage is the East Village Caesar which accounts for 10% of all beverage menu items sold.

The restaurant can turn twice in one service period. This outlet requires one server for every 30 guests and two culinary staff for every 20 guests. All server shifts are 6 hours long. All culinary shifts are 7 hours long. 

                        

Use this information and the provided excel template to complete your assignment and the associated questions. 

Instructions

• Working with your assigned group, use the following figure and the description above to answer the Assignment 1 questions. (You will also be provided with an excel template with the same information to support your work).

Figure 1.

 

Include the following:

• 1 completed Excel Workbook per team
• Use the excel workbook to create a Revenue Budget. Include a monthly, quarterly and one-year budget. (16 marks)

Calculate the following:

1. Calculate the number of rooms sold per night, in each room category, by quarter. (16 marks)
2. 3.Calculate RevPAR by quarter. (4 marks)

1. a. Research an area competitor of the Elbow Bend Hotel in East Village Calgary. Provide the average daily room rate for your chosen competitor for the month of March 2023 based on your calculations from their live company website. 

b. Calculate the following for your competitor. If they had your occupancy percentage for the month of March 2023 (Elbow Bend Hotel), how much revenue would they make for the month of March 2023?

c). Based on your above calculations, create one recommendation for the Elbow Bend Hotel that would help to increase occupancy or the average daily rate for March 2024 (next year). (Q4 total 6 marks)

1. Calculate how many guests are served in the on-site restaurant per day, each month. (12 marks)
2. Calculate the number of guests that could be served by the restaurant in one day. (1 marks)
3. Calculate how many more guests the restaurant could have serviced each day per month. (12 marks)
4. Calculate the Average Sales Revenue per server, per quarter. (4 marks)
5. Calculate the percentage of your total operating revenue that accounts for Rooms, Food, and Beverage. (3 marks)
6. Calculate the average food and beverage check. (2 marks)
7. Calculate how many guests order the Chef Signature Chicken each quarter. (4 marks)
8. Calculate how many guests order the East Village Caesar each quarter. (4 marks)
9.  If all restaurant guests are guests of the hotel, what percentage of hotel guests were captured by the hotel restaurant? (Calculate the percentage of hotel guests that use the restaurant). (1 mark) 

Based on your above calculations, create one recommendation for the Elbow Bend Hotel that would help to increase restaurant traffic or average guest check. 

Budgeted sales for each month are as follows: Rooms F&B Occ % ADR Avg Chq $285.00 $40.00 75% 25% is generated from food sales. $933,750 is generated from beverage sales $311,250 January February March April 49.00% 55.00% 75.00% 73.00% $ 432,915.00 $ 49,800.00 $ 438,900.00 $ 62,250.00 $ 662,625.00 $ 103,750.00 $ 624,150.00 $ 103,750.00 May 72.00% $ 636,120.00 $ 112,050.00 June 73.00% $ 624,150.00 $ 112,050.00 July 85.00% $ 750,975.00 $ 124,500.00 August September October November December 65.00% $ 555,750.00 $ 124,500.00 75.00% $ 641,250.00 $ 112,050.00 72.00% $ 636,120.00 $ 124,500.00 60.00% $ 513,000.00 $ 112,050.00 45.00% $ 397,575.00 66.58% $ 6,913,530.00 $ $ 103,750.00 1,245,000 Total Revenue: $ 8,158,530.00