In: Accounting
Exercise 6-11 Segmented Income Statement [LO6-4]
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:
Sales | $ | 1,600,000 |
Variable expenses | 641,400 | |
Contribution margin | 958,600 | |
Fixed expenses | 1,054,000 | |
Net operating income (loss) | $ | (95,400) |
In an effort to resolve the problem, the company would like to prepare an income statement segmented by division. Accordingly, the Accounting Department has developed the following information:
Division |
|||||||||
East | Central | West | |||||||
Sales | $ | 400,000 | $ | 670,000 | $ | 530,000 | |||
Variable expenses as a percentage of sales | 61 | % | 34 | % | 32 | % | |||
Traceable fixed expenses | $ | 281,000 | $ | 323,000 | $ | 195,000 | |||
Required:
1. Prepare a contribution format income statement segmented by divisions.
2-a. The Marketing Department has proposed increasing the West Division's monthly advertising by $29,000 based on the belief that it would increase that division's sales by 10%. Assuming these estimates are accurate, how much would the company's net operating income increase (decrease) if the proposal is implemented?
2-b. Would you recommend the increased advertising?