Hobby Shop Incorporated produces three different models with the following annua

Question

Hobby Shop Incorporated produces three different models with the following annual data (this is the base case) Plane Car Boat Total Selling price per unit 20 14 24 Variable cost per unit 5 7 8 Expected unit sales 30,000 50,000 20,000 100,000 Sales mix % 30% 50% 20% 100% Fixed costs 650,000 Assume the sales mix remains the same at all levels of sales.

d Using the base case information, prepare a contribution margin income statement for the year

Amount $

Contribution (Selling price - variable cost) units sold

=[(20-5) 30000 + (14-7) 50000 + (24-8) 20000 ]

$1,120,000

Less: Fixed Cost

($650,000)

Net Operating Income

$470,000

h Go back to the base case contribution margin income statement prepared in requirement d. What would the operating profit be if the Plane sales price (1) increases 10 percent, or (2) decreases 10 percent? (Assume total sales remains at 100,000 units.)

i Go back to the base case contribution margin income statement prepared in requirement d. If the sales mix shifts more toward the Car product than to the other two products, would the break-even point in units increase or decrease? Explain and provide calculations.

Amount $

Contribution (Selling price - variable cost) units sold

=[(20-5) 30000 + (14-7) 50000 + (24-8) 20000 ]

$1,120,000

Less: Fixed Cost

($650,000)

Net Operating Income

$470,000

Explanation / Answer

h) Increase 10% Contribution (Selling price - variable cost) units sold [(20 x 1.10)-5) 30000 + (14-7) 50000 + (24-8) 20000 ] $1,180,000.00 Less: Fixed Cost -$650,000.00 Net Operating Income $530,000.00 Decrease 10% Contribution (Selling price - variable cost) units sold [(20 x .90)-5) 30000 + (14-7) 50000 + (24-8) 20000 ] $1,060,000.00 Less: Fixed Cost -$650,000.00 Net Operating Income $410,000.00 b) Base BEP = Plane Car Boat Total Selling Price per unit 20 14 24 58 Less: Variable cost per unit -5 -7 -8 -20 Contribution Margin 15 7 16 38 X Sales mix 30.00% 50.00% 20.00% 100.00% Weighted Average CM per Unit 4.5 3.5 3.2 $11.20 BEP = Fixed Cost/ Weighted Average CM per Unit = $650,000/$11.20 58,036 units Change the sales mix New BEP = Plane Car Boat Total Selling Price per unit 20 14 24 58 Less: Variable cost per unit -5 -7 -8 -20 Contribution Margin 15 7 16 38 X Sales mix 20.00% 70.00% 10.00% 100.00% Weighted Average CM per Unit 3 4.9 1.6 $9.50 BEP = Fixed Cost/ Weighted Average CM per Unit = $650,000/$11.20 68,421 units BEP units will increase if we change the sales mix putting more in the car .

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.