Question: PLEASE DO IT ON EXCEL. THANK YOU Jane operates a hotel. Depreciation expense on the hotel is $6,000 per month Jane pays a maintenance person

PLEASE DO IT ON EXCEL. THANK YOU

Jane operates a hotel. Depreciation expense on the hotel is $6,000 per month Jane pays a maintenance person $4,000 per month and a cleaning person $3,000 per month. Real Estate taxes are $2,000 per month. The rooms rent for $60 per night, including breakfast. Other costs are laundry and cleaning service of $15 per room per night and the cost of food which is $5 per room per night. 1 How many rooms do they have to rent per month to break even? 2 If they rent 300 rooms one month, how much is their profit or loss? 3 Jane wants to serve a better breakfast but it will cost an additional $5 per room or $10 per room. She will also change the price per room per night to $75. What is the break even in rooms with these changes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!