Question

In: Accounting

P6.10 The Resolute Resort hotel currently operates at 75% occupancy, using a rack rate for all...

P6.10 The Resolute Resort hotel currently operates at 75% occupancy, using a rack rate for all rooms of $60 and a marginal cost per room sold of $ 8 . calculate the occupancy figures for discount grid using discount percentages of 5%,15%,and 20%

P6.11 Motley Motel's potential average room rate is calculated to be $62.Assume that this motel had three market segments.Vacation travelers use 75% of the room nights and are charged 100% of the rack rate. business travelers use 15% of the room nights and are charged 90% of the rack rate.sport teams acounts for 10% of the room nights and are charged 80% of the rack rate.

a. calculate the room rate by market segment.

2. Prove that your calculations are correct,assuming that total annual room nights are 7,300.

Solutions

Expert Solution

1 Rate 60
Discount (%) 5 15 20
Rate after discount 57 51 48
Occupancy rate (%) 75 75 75
Rooms 7500
Occupancy figures are        3,20,625        2,86,875        2,70,000

2.Room rate per segment-

Segment Discount Room rate Occupancy
Vacation travellers 5% 95% 75%
Business Travellers 15% 85% 15%
Sport teams 20% 80% 10%

Average rate per room= Rate*Occupancy*Room/ Total Rooms

62= (75%*7500*0.95X+15%*7500*0.85X+10%*7500*0.8X)/7500

62 = 0.92 x

x= 67.39 $

Standard rate= 67.39

Rate per segment wise-

Vacation travellers rate             64.02 95% of X
Business Travellers             57.28 85% of X
Sport teams             53.91 80% of X

Related Solutions

Jace collected the following data on the quarterly room occupancy (in hundreds) for a resort hotel...
Jace collected the following data on the quarterly room occupancy (in hundreds) for a resort hotel in Iowa. Year quarter Occupancy 2013 1 16 2 21 3 9 4 18 2014 1 15 2 20 3 10 4 18 2015 1 17 2 24 3 13 4 22 2016 1 17 2 25 3 11 4 21 2017 1 18 2 26 3 14 4 25 Plot the data and describe any trend and seasonal effects you observe in the...
Using Loops for the Hotel Occupancy calculator. You will write a program that calculates the occupancy...
Using Loops for the Hotel Occupancy calculator. You will write a program that calculates the occupancy of a hotel. Rules: 1# The hotel must have more than 2 floors and less than or equal 5 floors. 2# Each floor in the hotel can have a different number of rooms on the floor. 3# You must set the number of occupied rooms. Again, there must less rooms occupied than the number of rooms. 4# Using the total number of rooms and...
Following are the number of victories for the Blue Sox and the hotel occupancy rate for...
Following are the number of victories for the Blue Sox and the hotel occupancy rate for the past eight years. You have been asked to test three forecasting methods to see which method provides a better forecast for the Number of Blue Sox Wins. Year Number of Blue Sox Wins Occupancy Rate 1 70 78% 2 67 83 3 75 86 4 87 85 5 87 89 6 91 92 7 89 91 8 85 94 For the following, you...
IN JAVA Write a program that calculates the occupancy rate for each floor of a hotel....
IN JAVA Write a program that calculates the occupancy rate for each floor of a hotel. (Use a sentinel value and please point out the sentinel in bold.) The program should start by asking for the number of floors in the hotel. A loop should then iterate once for each floor. During each iteration, the loop should ask the user for the number of rooms on the floor and the number of them that are occupied. After all the iterations,...
Write a program that calculates the occupancy rate for each floor of a hotel. (Use a...
Write a program that calculates the occupancy rate for each floor of a hotel. (Use a sentinel value and please point out the sentinel in bold.) The program should start by asking for the number of floors in the hotel. A loop should then iterate once for each floor. During each iteration, the loop should ask the user for the number of rooms on the floor and the number of them that are occupied. After all the iterations, the program...
The Typhoon Resort, which has 100 rooms, has currently been experiencing an occupancy dip to a...
The Typhoon Resort, which has 100 rooms, has currently been experiencing an occupancy dip to a 60.00% level. The current rack rate is $80.00 with a marginal cost of $20.00 per room. The management of this resort would like to see the options when they apply $10.00 and 10.00% discounts from the current rack rate separately. Based on these two discount situations, what equivalent occupancy percentages must be achieved to maintain the same levels of contribution margin for both $10.00...
Kelly Hayes operates a bed and breakfast hotel in a beach resort area of Noosa. Depreciation...
Kelly Hayes operates a bed and breakfast hotel in a beach resort area of Noosa. Depreciation on the hotel is $60,000 per year. Kelly employs a maintenance person at an annual salary of $30,000 per year and a cleaning person at an annual salary of $24,000 per year. Rates and taxes are $10,000 per year. The rooms rent at an average price of $50 per person per night including breakfast. Other costs are laundry service at $4.00 per person per...
Jane Botosan operates a bed and breakfast hotel in a resort area near Lake Michigan. Depreciation...
Jane Botosan operates a bed and breakfast hotel in a resort area near Lake Michigan. Depreciation on the hotel is $60,000 per year. Jane employs a maintenance person at an annual salary of $32,000 and a cleaning person at an annual salary of $24,000. Real estate taxes are $10,000 per year. The rooms rent at an average price of $60 per person per night including breakfast. Other costs are laundry and cleaning service at a cost of $10 per person...
Jane Botosan operates a bed and breakfast hotel in a resort area near Lake Michigan. Depreciation...
Jane Botosan operates a bed and breakfast hotel in a resort area near Lake Michigan. Depreciation on the hotel is $60,000 per year. Jane employs a maintenance person at an annual salary of $41,000 and a cleaning person at an annual salary of $24,000. Real estate taxes are $10,000 per year. The rooms rent at an average price of $60 per person per night including breakfast. Other costs are laundry and cleaning service at a cost of $10 per person...
Q1) Jane Botosan operates a bed and breakfast hotel in a resort area near Lake Michigan....
Q1) Jane Botosan operates a bed and breakfast hotel in a resort area near Lake Michigan. Depreciation on the hotel is $60,000 per year. Jane employs a maintenance person at an annual salary of $41,000 and a cleaning person at an annual salary of $24,000. Real estate taxes are $10,600 per year. The rooms rent at an average price of $127 per person per night including breakfast. Other costs are laundry and cleaning service at a cost of $10.6 per...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT