In: Accounting
Modern Company has four divisions. The budgeted revenues and expenses for each division for 2021 follows:
Division |
||||
A |
B |
C |
D |
|
Sales |
$504,000 |
$948,000 |
$960,000 |
$1,240,000 |
Cost of goods sold |
440,000 |
930,000 |
765,000 |
925,000 |
Selling & admin costs |
96,000 |
202,500 |
144,000 |
210,000 |
Operating income (loss) |
$(32,000) |
$(184,500) |
$51,000 |
$105,000 |
Further analysis of costs reveals the following percentages of variable costs in each division:
A |
B |
C |
D |
|
Cost of goods sold |
90% |
80% |
90% |
85% |
Selling & admin costs |
50% |
50% |
60% |
60% |
Closing down any division would result in a savings of 40% of the fixed costs of that division.
Required:
Item |
||
SOLUTION:
A | B | |
Sales Revenue | 504000 | 948000 |
Variable Costs | ||
Variable Cost of Goods Sold | 396,000 | 744,000 |
Selling and Administrative Expenses | 48,000 | 101,250 |
Total Variable Costs | 444,000 | 845,250 |
Contribution Margin | 60,000 | 102,750 |
Division A | Continue |
Eliminate (1-40%) |
Net Income Increase(Decrease |
Contribution Margin | 60000 | - | (60000) |
Fixed Expenses | |||
Cost of Goods Sold | 44000 | 26400 | 17600 |
Selling and Administrative Expenses | 48000 | 28800 | 19200 |
Total Fixed Expenses | 92000 | 27600 | 36800 |
Increase ( decrease) in Net Operating Income | (23200) |
Division B | Continue |
Eliminate (1-40%) |
Net Income Increase(Decrease |
Contribution Margin | 102750 | - | (102750) |
Fixed Expenses | |||
Cost of Goods Sold | 186000 | 111600 | 74400 |
Selling and Administrative Expenses | 101250 | 60750 | 40500 |
Total Fixed Expenses | 287250 | 27600 | 114900 |
Increase ( decrease) in Net Operating Income | 12150 |
Division B should be closed as there will be Positive impact of $ 12150 in net income..