Question
1 . COMPUTE THE OPERATING REVENUE FROM OPERATINGTO DECEMBER. ROOMS FOOD BEVERAGE TOTAL OPERATING REVENUE JANUARY FEBRUARY MARCH 1 ST QUARTER TOTAL APRIL MAY JUNE
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. HOW MANY NUMBERS OF GUESTS ARE SERVED IN THE RESTAURANT EACH MONTH?
JANUARY | FEBRUARY | MARCH | APRIL | MAY | JUNE | JULY | AUGUST | MAY | JUNE | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER |
4. How many maximum Number of Guests that could be served in the restaurant in one day?
5. How many more guests could have been served each month?
JANUARY | FEBRUARY | MARCH | APRIL | MAY | JUNE | JULY | AUGUST | MAY | JUNE | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER |
6. What is the Average Sales Revenue per server per quarter
1ST QUARTER | 2ND QUARTER | 3RD QUARTER | 4TH QUARTER |
7. What percentage of your total operationg revenue is ?
ROOMS | |
FOOD | |
BEVERAGE |
8. What is the average food and beverage check?
FOOD | |
BEVERAGE |
9. HOW MANY GUESTS ORDER THE CHICKEN EACH QUARTER?
1ST QUARTER (January - march) | |
2ND QUARTER (April-June) | |
3RD QUARTER(July-september) | |
4TH QUARTER(October-december) |
10. HOW MANY GUESTS ORDER THE CAESAR EACH QUARTER
1ST QUARTER (January - march) | |
2ND QUARTER (April-june) | |
3RD QUARTER(July-september) | |
4TH QUARTER(October-december) |
11. What is the percentage of hotel guests that use the restaurant (capture)? Please also show the formula
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. - c. Hint: Be aware of how many days in each month there are! Elbow Bend Hotel Food and Beverage Information - Hours of Operation: 5 pm - 9 pm daily - Seats available: 80 - seat turns 2 1. The restaurant's best-selling entre is a chef's signature chicken dish. It accounts for 30% of all food menu items sold. 2. The restaurant's best-selling beverage is an East Village Caesar. It accounts for 10% of all beverage menu items sold. 3. The restaurant needs 1 server and 2 culinary staff for every 20 guests. 4. All server shifts are 6 hours and culinary shifts are 8 hours. Budgeted sales for each month are as follows 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. - c. Hint: Be aware of how many days in each month there are! Elbow Bend Hotel Food and Beverage Information - Hours of Operation: 5 pm - 9 pm daily - Seats available: 80 - seat turns 2 1. The restaurant's best-selling entre is a chef's signature chicken dish. It accounts for 30% of all food menu items sold. 2. The restaurant's best-selling beverage is an East Village Caesar. It accounts for 10% of all beverage menu items sold. 3. The restaurant needs 1 server and 2 culinary staff for every 20 guests. 4. All server shifts are 6 hours and culinary shifts are 8 hours. Budgeted sales for each month are as followsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started