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 1 ST QUARTER TOTAL APRIL MAY JUNE 2 ND QUARTER TOTAL JULY AUGUST SEPTEMBER 3 RD QUARTER OCTOBER NOVEMBER DECEMBER 4 TH QUARTER YEAR TOTAL 2 HOW MANY ROOMS ARE SOLD PER QUARTER IN EACH ROOM CATEGORY 1 ST QUARTER 2 ND QUARTER 3 RD QUARTER 4 TH 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 1 ST QUARTER (January march) 2 ND QUARTER (April June) 3 RD QUARTER(July september) 4 TH QUARTER(October december) 15 HOW MANY GUESTS ORDER THE CAESAR EACH QUARTER 1 ST QUARTER (January march) 2 ND QUARTER (April june) 3 RD QUARTER(July september) 4 TH 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

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on May 03, 2024

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

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
1^ST QUARTER TOTAL
APRIL
MAY
JUNE
2^ND QUARTER TOTAL
JULY
AUGUST
SEPTEMBER
3^RD QUARTER
OCTOBER
NOVEMBER
DECEMBER
4^TH QUARTER
YEAR TOTAL=

2. HOW MANY ROOMS ARE SOLD PER QUARTER IN EACH ROOM CATEGORY?

	1^ST QUARTER	2^ND QUARTER	3^RD QUARTER	4^TH 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?

1^ST QUARTER (January - march)
2^ND QUARTER (April-June)
3^RD QUARTER(July-september)
4^TH QUARTER(October-december)

15. HOW MANY GUESTS ORDER THE CAESAR EACH QUARTER

1^ST QUARTER (January - march)
2^ND QUARTER (April-june)
3^RD QUARTER(July-september)
4^TH 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.