Question

In: Accounting

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

A) Determine the sales revenue Jane needs to break even.

B) Determine the number of rentals Jane needs to earn a target net income of $50,000.

C) Jane is considering changing the business strategy. She considers installing additional cleaning machines which will decrease laundry and cleaning service per person per night by $3. However, fixed depreciation cost will increase by $4,010. Determine the number of rentals Jane needs to break even if the changes are made.

D) Determine the number of rentals at which Jane would be indifferent between the current and proposed business models. (Hint: Consider net income figures.)

Solutions

Expert Solution

A)

Revenue per person per night=$128

Variable Costs per person per night:

Laundry and Cleaning Service =$10.7

Cost of food=$5.1

Total Variable cost per person per night=10.7+5.1=$15.8

Unit Contribution margin =128-15.8=$112.2

Fixed Costs per Year:

Depreciation=$60000

Maintenance Salary=$41000

Cleaning Salary=$24000

Taxes=$10700

Total annual fixed costs=60000+41000+24000+10700=$135,700

Break Even Point in person night=Fixed Cost/Unit Contribution margin=135700/112.2=1210 person night

Break Even Sales(Per Year) =1210*128=$154,880

B) Target net Income =$50,000

Break even number of Rentals=1210

Contribution margin per rental=$112.2

Number of Rental required =1210+(50000/112.2)=1655

C) New Unit Contribution Margin=$112.2+$3=$115.2

New Annual Fixed Costs=$135,700+$4010=$139,710

Number of rentals to Break Even =Fixed Costs/Unit Contribution margin=139710/115.2=1213

D)Assume the indifferent number of rentals =N

Profit as per current model =(N-1210)*112.2

Profit as per proposed model =(N-1213)*115.2

To be indifferent:

(N-1210)*112.2=(N-1213)*115.2

N*(115.2-112.2)=1213*115.2-1210*112.2=3975.6

N*3=3975.6

N=3975.6/3=1325 (Rounded to whole number)

Number of required rentals=1325


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...
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...
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...
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...
1. A resort is roping of a children's swimming area in the lake at the resort....
1. A resort is roping of a children's swimming area in the lake at the resort. They have 150m of rope to use. What is the maximum area they can rope off for the children's swimming section, assuming that they do not need to run the rope along the beach side of the area? (use optimization) 2. Vivian makes hand made soap and sells them at a craft shows. She found that at one show she sold 450 soaps at...
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...
A hot, wet summer is causing a mosquito population explosion in a lake resort area. The...
A hot, wet summer is causing a mosquito population explosion in a lake resort area. The number of mosquitos is increasing at an estimated rate of n(t) = 1900 + 10e0.5t per week (where t is measured in weeks). By how much does the mosquito population increase between the fifth and ninth weeks of summer? (Round your answer to three decimal places.) ______mosquitos Please show all work, step by step, line by line. Please justify each step so that I...
Hotel Sport is in the suburb of large metropolitan area near a sports complex that has...
Hotel Sport is in the suburb of large metropolitan area near a sports complex that has a stadium suitable for baseball and soccer games. The 250-room independent hotel is a select-service property in the mid-range category. Its rate structure is simple: Rack                                         $190 Weekend                                 $159 Low season/Government    $140 Groups (of 15+)                     $130 Best available rate                 $120 Late August is traditionally a slow season in the hotel and business picks up in September after area businesses and government offices...
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