In: Accounting
Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as shown by its most recent monthly contribution format income statement, which follows:
Sales | $ | 1,678,000 | |
Variable expenses | 648,560 | ||
Contribution margin | 1,029,440 | ||
Fixed expenses | 1,132,000 | ||
Net operating income (loss) | $ | (102,560 | ) |
In an effort to isolate the problem, the president has asked for an income statement segmented by division. Accordingly, the Accounting Department has developed the following information:
Division |
|||||||||
East | Central | West | |||||||
Sales | $ | 428,000 | $ | 660,000 | $ | 590,000 | |||
Variable expenses as a percentage of sales | 52 | % | 27 | % | 42 | % | |||
Traceable fixed expenses | $ | 282,000 | $ | 327,000 | $ | 194,000 | |||
Required:
1. Prepare a contribution format income statement segmented by divisions, as desired by the president.
2-a. As a result of a marketing study, the president believes that sales in the West Division could be increased by 11% if monthly advertising in that division were increased by $25,000. Calculate the incremental net operating income.
2-b. Would you recommend the increased advertising?
No | |
Yes |
1. Contribution format income statement segmented by divisions
Divisions | ||||
Total company | East | Central | West | |
Sales | $1,678,000 | $428,000 | $660,000 | $590,000 |
Variable expense | $648,560 | $222,560 | $178,200 | $247,800 |
Contribution margin | $648,560 | $205,440 | $481,800 | $342,200 |
Traceable Fixed expense | $803,000 | $282,000 | $327,000 | $194,000 |
Divisional segment margin | $226,440 | ($76,560) | $154,800 | $148,200 |
Common fixed expense not traceable to divisions | $329,000 | |||
Net operating income (loss) | ($102,560) |
Common fixed expense not traceable to divisions= $1,132,000 - $803,000 =$329,000
2.a
Incremental west division sales (590,000×11%) | $64,900 |
Contribution margin ratio ($342,200/$590,000) | 58% |
Incremental contribution margin | $37,642 |
Less: Incremental advertising expense | ($25,000) |
Incremental net operating income | $12,642 |
2.b
Yes, the additional program should be initiated.
____×____
All the best