In: Accounting
Miller Company’s contribution format income statement for the most recent month is shown below: Total Per Unit Sales (34,000 units) $ 272,000 $ 8.00 Variable expenses 170,000 5.00 Contribution margin 102,000 $ 3.00 Fixed expenses 43,000 Net operating income $ 59,000 Required: (Consider each case independently): 1. What is the revised net operating income if unit sales increase by 13%? 2. What is the revised net operating income if the selling price decreases by $1.40 per unit and the number of units sold increases by 22%? 3. What is the revised net operating income if the selling price increases by $1.40 per unit, fixed expenses increase by $6,000, and the number of units sold decreases by 4%? 4. What is the revised net operating income if the selling price per unit increases by 20%, variable expenses increase by 40 cents per unit, and the number of units sold decreases by 6%?
Answer
Existing
Units |
34,000 |
Sales |
$ 272,000 |
Variable Expenses |
$ 170,000 |
Contribution Margin |
$ 102,000 |
Fixed Expenses |
$ 43,000 |
Net Operating Income |
$ 59,000 |
Case 1
Units (34,000 + 13%) |
38,420 |
|
Sales |
$ 307,360 |
|
Variable Expenses |
$ 192,100 |
|
Contribution Margin |
$ 115,260 |
|
Fixed Expenses |
$ 43,000 |
|
Net Operating Income |
$ 72,260 |
|
Net Operating income will increase by $13,260 (72,260 - 59,000) |
||
Case 2
Units (34,000 + 22%) |
41,480 |
|
New Selling Price ($8 - $1.4) |
$ 6.6 |
|
Sales |
$ 273,768 |
|
Variable Expenses |
$ 207,400 |
|
Contribution Margin |
$ 66,368 |
|
Fixed Expenses |
$ 43,000 |
|
Net Operating Income |
$ 23,368 |
|
Net Operating income will decrease by $35,632 (59,000 - 23,368) |
||
Case 3
Units (34,000 - 4%) |
32,640 |
|
New Selling Price ($8 + $1.4) |
$ 9.4 |
|
New Fixed Cost (43,000 + 6,000) |
$ 49,000 |
|
Sales |
$ 306,816 |
|
Variable Expenses |
$ 163,200 |
|
Contribution Margin |
$ 143,616 |
|
Fixed Expenses |
$ 49,000 |
|
Net Operating Income |
$ 94,616 |
|
Net Operating income will increase by $35,616 (94,616 - 59,000) |
||
Case 4
Units (34,000 - 6%) |
31,960 |
|
New Selling Price ($8 + 20%) |
$ 9.6 |
|
New Variable expenses ($5+$0.4) |
$ 5.4 |
|
Sales |
$ 306,816 |
|
Variable Expenses |
$ 172,584 |
|
Contribution Margin |
$ 134,232 |
|
Fixed Expenses |
$ 43,000 |
|
Net Operating Income |
$ 91,232 |
|
Net Operating income will increase by $32,232 (91,232 - 59,000) |
||