Please show your calculation work for each question.Please answer the question regarding the analysis of the ratio.

1. The Sheraton Waikiki has a total of 1,636 rooms.1,279 rooms were sold last night.Calculate the Room Occupancy Percentage (ROP).Is this a good occupancy percentage?Why or why not?

1. The Sheraton Waikiki has a total of 1,636 rooms.1,279 rooms were sold last night.Total room revenue = $395,827.Calculate the Average Daily Rate (ADR).The targeted goal for ADR was $319.00.Did we meet our ADR goal?If over our goal, by what amount did we exceed our goal?If under our goal, by what amount are we short of our goal?

1. The Sheraton Waikiki has a total of 1,636 rooms.1,279 rooms were sold last night.A total of 3,672 guests were registered.Calculate the Average Guests Per Room Sold.What does this number tell us about the types of guests staying at the Sheraton last night?

1. The Sheraton Waikiki has a total of 1,636 rooms.1,279 rooms were sold last night.A total of 3,672 guests were registered.Total room revenue = $395,827.Total other revenue (including food & beverage, banquets, spa, retail) = $155,263.Calculate the Revenue Per Available Customer.Based on the calculations in #2 and #3, each guest spends approximately $107.83 for the room rate cost.What is the dollar amount being spent on other areas such as F&B, Spa, Retail?(Revenue Per Available Customer - Room Rate Cost per Customer).If you are the hotel manager are you happy with the spending in your hotel? Why or why not?

1. The Sheraton Waikiki has a total of 1,636 rooms.1,279 rooms were sold last night.Total room revenue = $395,827.Calculate the Revenue per Available Room (RevPAR).The market competition has an ADR of $259.00.Are better or worse than our competition?By what amount?

1. The Sheraton Waikiki has a total of 1,636 rooms.1,279 rooms were sold last night.A total of 3,672 guests were registered.Total room revenue = $395,827.The Average Rack Rate = $468.Calculate the Yield Statistic.Is this a good yield?Why or why not?

Actual Rooms RevenuePotential Room Revenue

(Potential Room Revenue = Average Rack Rate X Total Available Rooms

Chapter 12 -Evaluating Financial PerformanceExercise

Please show your calculation work for each question.Please answer the question regarding the analysis of the ratio.

1.Rooms Division Budgeting

Budgeted Room Revenue for November = $12,575,000

Calculate the budgeted dollar amount from the following budgeted cost percentages:

• Front Office Labor = 11%
• Housekeeping Labor = 20%
• Guest Supplies = 14%
• Office Supplies = 8%

2.Rooms Division Actual Results

Actual Room Revenue for November = $10,653,972

Calculate the cost percentages for the following expense totals for the month of November:

• Front Office Labor = $1,598,095.80
• Housekeeping Labor = $1,917,714.96
• Guest Supplies = $1,704,635,52
• Office Supplies = $745,778.04
• Total $5,966,224.05

3.Rooms Division Results Analysis

1. By what dollar amount was actual revenue short from budgeted revenue?

1. Were our actual total expenses over budget or under budget?

1. By what total percent were we over budget or under budget?

1. In what department areas did we overspend?

1. In what department areas did we save costs?

1. Describe 3 ways we could reduce expenses in the following month?