Elbow Bend Hotel Rooms Information Total Rooms=100 Deluxe room=40 Executive rooms= 50 Suites= 10 Suites are 100%
Question:
Elbow Bend Hotel Rooms Information
- Total Rooms=100
- Deluxe room=40
- Executive rooms= 50
- Suites= 10
- Suites are 100% sold every month and the other two categories split the rest of the rooms sold equally.
- Half of the rooms sold every day have double occupancy.
Elbow Bend Hotel Food and Beverage Information
- Hours of Operation: 6 pm - 9 pm daily
- 365 days a year
- Seats available: 80
- seat turns 2
- The restaurant's best-selling entre is a chef's signature chicken dish. It accounts for 30% of all food menu items sold.
- The restaurant's best-selling beverage is an East Village Caesar. It accounts for 10% of all beverage menu items sold.
- The restaurant needs 1 server for every 30 guests and 2 culinary staff for every 20 guests.
- All server shifts are 6 hours and culinary shifts are 7 hours.
| Budgeted sales for each month are as follows: | |||||||||||||
| Rooms | F&B | ||||||||||||
| Occ % | ADR | Avg Chq | 75% | is generated from food sales | $933,750 | ||||||||
| $285.00 | $40.00 | 25% | is generated from beverage sales | $311,250 | |||||||||
| January | 49.00% | $ 432,915.00 | $ 49,800 | ||||||||||
| February | 55.00% | $ 438,900.00 | $ 62,250 | ||||||||||
| March | 75.00% | $ 662,625.00 | $103,750 | ||||||||||
| April | 73.00% | $ 624,150.00 | $103,750 | ||||||||||
| May | 72.00% | $636,120.00 | $112,050 | ||||||||||
| June | 73.00% | $624,150.00 | $112,050 | ||||||||||
| July | 85.00% | $750,975.00 | $124,500 | ||||||||||
| August | 65.00% | $555,750.00 | $ 124,500 | ||||||||||
| September | 75.00% | $641,250.00 | $ 12,050 | ||||||||||
| October | 72.00% | $636,120.00 | $ 124,500 | ||||||||||
| November | 60.00% | $513,000.00 | $ 112,050 | ||||||||||
| December | 45.00% | $397,575.00 | $103,750 | ||||||||||
| 66.58% | $6,913,530.00 | $ 1,245,000 | |||||||||||
| Total Revenue: | $ 8,158,530.00 | ||||||||||||
1 . COMPUTE THE OPERATING REVENUE FROM OPERATINGTO DECEMBER.
| ROOMS | FOOD | BEVERAGE | TOTAL OPERATING REVENUE | |
| JANUARY | ||||
| FEBRUARY | ||||
| MARCH | ||||
| 1ST QUARTER TOTAL | ||||
| APRIL | ||||
| MAY | ||||
| JUNE | ||||
| 2ND QUARTER TOTAL | ||||
| JULY | ||||
| AUGUST | ||||
| SEPTEMBER | ||||
| 3RD QUARTER | ||||
| OCTOBER | ||||
| NOVEMBER | ||||
| DECEMBER | ||||
| 4TH QUARTER | ||||
| YEAR TOTAL= |
2. HOW MANY ROOMS ARE SOLD PER QUARTER IN EACH ROOM CATEGORY?
| 1ST QUARTER | 2ND QUARTER | 3RD QUARTER | 4TH QUARTER | |
| DELUXE | ||||
| EXECUTIVE | ||||
| SUITES | ||||
| TOTAL | ||||
| CALCULATE THE RevPar BY QUARTER |
3. SEARCH AND NAME A OF COMPETITOR OF ELBOW BLEN HOTEL ______________________________________
4. WHAT IS THE AVERAGE ROOM RATE OF THE COMPETITOR FOR A ROOM IN MARCH ___________________________________
4a. WHAT IS THE REVENUE FOR THE COMPETITOR CHOSEN BASED ON ELBOW BEND HOTEL MARCH OCCUPANCY______________________________________________________________________
4b. BASED ON YOUR ABOVE CALCULATIONS, CREATE ONE RECOMMENDATION FOR ELBOW BEND HOTEL THAT WOULD HELP INCREASE OCCUPANCY OR THE AVERAGE DAILY RATE FOR AMRCH 2024(next year).______________________________________________________________________________
5. HOW MANY NUMBERS OF GUESTS ARE SERVED IN THE RESTAURANT BY DAY EACH MONTH?
| JANUARY | FEBRUARY | MARCH | APRIL | MAY | JUNE | JULY | AUGUST | MAY | JUNE | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER |
6. HOW MANY GUESTS COULD BE SERVED IN THE RESTAURANT BY DAY: ___________
7. HOW MANY MORE GUESTS COULD HAVE BEEN SERVED EACH DAY?
| JANUARY | FEBRUARY | MARCH | APRIL | MAY | JUNE | JULY | AUGUST | MAY | JUNE | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER |
8. WHAT IS THE AVERAGE SALES REVENUE PER SERVER FROM JANUARY TO MARCH? _____________
9. WHAT IS THE AVERAGE SALES REVENUE PER SERVER FROM APRIL TO JUNE? ______________
10. WHAT IS THE AVERAGE SALES REVENUE PER SERVER FROM JULY TO SEPTEMBER? __________
11. WHAT IS THE AVERAGE SALES REVENUE PER SERVER FROM OCTOBER TO DECEMBER? _________
12. WHAT is the PERCENTAGE OF YOUR TOTAL OPERATING REVENUE?
| ROOMS | |
| FOOD | |
| BEVERAGE |
13. WHAT IS THE AVERAGE FOOD AND BEVERAGE CHECK?
| FOOD | |
| BEVERAGE |
14. HOW MANY GUESTS ORDER THE CHICKEN EACH QUARTER?
| 1ST QUARTER (January - march) | |
| 2ND QUARTER (April-June) | |
| 3RD QUARTER(July-september) | |
| 4TH QUARTER(October-december) |
15. HOW MANY GUESTS ORDER THE CAESAR EACH QUARTER
| 1ST QUARTER (January - march) | |
| 2ND QUARTER (April-june) | |
| 3RD QUARTER(July-september) | |
| 4TH QUARTER(October-december) |
16. WHAT IS THE PERCENTAGE OF HOTEL GUESTS THAT USE THE RESTAURANT (CAPTURE)?
17. BASED ON YOUR ABOVE CALCULATIONS, CREATE ONE RECOMMENDATION FOR THE ELBOW BEND HOTEL THAT WOULD HELP TO INCREASE RESTAURANT TRAFFIC OR AVERAGE GUEST CHECK.
Expert Answer:
