Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

in excel please, thank you! Jane operates a hotel. Depreciation expense on the hotel is 56,000 per month Jane pays a maintenance person $4,000 per

image text in transcribed

in excel please, thank you!

Jane operates a hotel. Depreciation expense on the hotel is 56,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 PEM, Inc makes a single product. First year income statement is Variable costs per unit Material Labor Overhead Selling Fixed costs $ 6.00 Overhead $ 300,000.00 ($12/unit) $ 9.00 Selling $ 190,000.00 $ 3.00 $ 5.00 Units sold 25,000 Units Producer 25,000 End Inventory Sale price $ 50.00 Traditional Profit & Loss Statement 0 0 0 1,250,000 Sales (25,000 at $50) Cost of Goods Sold: Cost of Goods Sold (25000*30) 750,000 Gross Profit 500,000 Variable Selling (25000*5) Fixed selling 125,000 190,000 Net Income 185,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Finance A Focused Approach

Authors: Michael C. Ehrhardt, Eugene F. Brigham

6th edition

978-1305637108

Students also viewed these Accounting questions