Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Magellan Inn's expenses for two different months at different volumes. What are the total estimated monthly fixed costs? January May management salaries 15,000 Rooms Occupied
Magellan Inn's expenses for two different months at different volumes. What are the total estimated monthly fixed costs? January May management salaries 15,000 Rooms Occupied 2,500 3,500 per room costs utilites 8,500 Payroll: building rent 7,000 interest expense 1,500 Management Salarie $15,000 $15,000 fixed 6.00 $ 4.29 insurance 3,500 Hourly Wages 45,000 65,000 variable 18.00 18.57 Total 35,500 Employee benefits 9,200 10,700 mixed 3.68 3.06 Supplies 2,500 3,000 variable 1.00 0.86 What are the total estimated variable costs per room sold? Utilities 8,500 8,500 fixed 3.40 2.43 Enter your response in this area, show your work. Other operating cost 4,500 5,000 mixed 1.80 1.43 Building rent 7,000 7,000 fixed 2.80 2.00 Interest expense 1,500 1,500 fixed 0.60 0.43 Insurance 3,500 3,500 fixed 1.40 1.00 Required: Identify each cost as fixed, variable, or mixed. Develop a single equation to estimate total costs at various levels of activity. USE COLUMN D ABOVE Enter your response in this area, show your work. Project the total costs if 3,500 rooms are sold. Enter your response in this area, show your work
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started