Question

In: Accounting

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 night and the cost of food which is $6.00 per person per night.

Instructions:

(a)what are total fixed cost and Variable cost per person per night ?


b)Determine the number of rentals and the sales revenue Kelly needs to break even using the contribution margin technique.

(c) If the current level of rentals is 4,000, by what percentage (Margin of Safety) can rentals decrease before Kelly has to worry about having a net loss?

(d) Kelly is considering upgrading the breakfast service to attract more business and increase prices. This will cost an additional $5.00 for food costs per person per night. Kelly feels she can increase the room rate to $65 per person per night. Determine the number of rentals and the sales revenue Kelly needs to break even if the changes are made.

e) Determine the contribution margin per person per night ?

Solutions

Expert Solution

a) Fixed cost is the cost which remain occurs for a given time period and do not change (i.e. remains fixed) and the varuiable is the cost which changes proportionly with change in sales volume but it remains same per unit of output.

Fixed Cost per year = Depreciation+Salary of maintenance person+Salary of Cleaning Person+Rates and Taxes

= $60,000+$30,000+$24,000+$10,000 = $124,000

Variable Cost per person per night = Laundry Service+Cost of foods

= $4.00+$6.00 = $10.00 per person per night

Therefore the total fixed cost is $124,000 and variable cost is $10.00 per person per night.

b) Break Even point is the point at which the profit is zero and fixed cost is equal to contribution margin. The calculation of break even number of rentals and break even sales revenue is shown as follows:-

Contribution Margin per person per night = Room Rent per person per night - Variable cost per person per night

= $50.00 - $10.00 = $40.00

Break Even number of rentals = Total Fixed Cost/Contribution Margin per person per night

= $124,000/$40.00 = 3,100 rentals

Break Even Sales Revenue = Break Even Rentals*Room Rent per person per night

= 3,100 rentals*$50.00 = $155,000

c) Break Even Rentals = 3,100

Current Level of Rentals = 4,000

Margin of Safety = Current Level - Break Even

= 4,000 - 3,100 = 900

Margin of Safety % = Margin of Safety/Current Level of Rentals

= 900/4,000 = 0.225 or 22.5%

d) New Contribution Margin per person per night = Room Rent - Variable cost

= $65.00 - ($10.00+$5.00) = $50.00

Break Even number of rentals = Total Fixed Cost/Contribution Margin per person per night

= $124,000/$50.00 = 2,480 rentals

Break Even Sales Revenue = Break Even Rentals*Room Rent per person per night

= 2,480 rentals*$65.00 = $161,200

  


Related Solutions

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...
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,700 per year. The rooms rent at an average price of $128 per person per night including breakfast. Other costs are laundry and cleaning service at a cost of $10.7 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...
Benoit is opening a bed and breakfast inn in a popular beach resort town. He hopes...
Benoit is opening a bed and breakfast inn in a popular beach resort town. He hopes to appeal to professional couples and retirees who want a high-end beach vacation experience but with a more home style experience – basically the experience of living in a luxurious beach house but with all the amenities of a high end hotel. Benoit’s B&B is directly on the beach and a few of the rooms have ocean views and in the evenings, from the...
B. Jane Botosan operates a Hostelworld in an area near Amsterdam. Depreciation on the hotel is...
B. Jane Botosan operates a Hostelworld in an area near Amsterdam. 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 per night and the...
Mermaid Beach Hotel Ltd (Mermaid Hotel) operates a seaside hotel on the Sunshine Coast, providing accommodation,...
Mermaid Beach Hotel Ltd (Mermaid Hotel) operates a seaside hotel on the Sunshine Coast, providing accommodation, bar and restaurant facilities for tourists. Casual and part-time wages are a major expense item, particularly during summer, when up to an additional 30 staff members are employed. In order to keep track of casual and part-time wages, Mermaid Hotel’s operations manager prepares a weekly roster (using Excel) showing: • employee name • employment position (e.g. bar staff) • days and hours rostered for...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT