Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A motel has a rooms department and a dining room, and fixed cost is $470,000. Annual sales revenue and cost figures are as follows: RoomsFoodTotal

A motel has a rooms department and a dining room, and fixed cost is $470,000. Annual sales revenue and cost figures are as follows:

RoomsFoodTotal

Sales Revenue$750,000$250,000$1,000,000

Variable Costs(187,500)( 150,000)( 337,500)

Contribution Margin$562,500$ 100,000$662,500

a. If we want to double the current operating income before tax with variable costs remaining the same and covering fixed costs, what increase in room revenue is needed? (4 points)

b. If we want to double the current total operating income before tax with direct costs remaining the same and covering fixed costs, what increase in food sales revenue is needed? (4 points)

c. If we want to double the current operating income before tax with direct costs remaining the same, what will increase in sales revenue have to be if the increase is provided jointly by both departments combined? Assume sales revenue ratios stay as originally stated. (5 points)

d. What would total sales revenue have to be to achieve all of the following: (7 points)

  • Additional operating income of $50,000
  • Additional fixed cost of $20,000
  • The sales revenue ratio changes from 75% for rooms and 25% for food to 70% for rooms and 30% for food.
  • Rooms variable cost increase to 30% and food variable cost decrease to 50%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Payroll Accounting 2020

Authors: Bernard J. Bieg, Judith A. Toland

30th edition

357117174, 978-0357117170

More Books

Students also viewed these Accounting questions

Question

Please show work in excel. Thank you.

Answered: 1 week ago

Question

2. It is the results achieved that are important.

Answered: 1 week ago