Answer:
Windgate Company
1. Segmented Income Statement
Company East Central West
Sales $ 1,645,000 $445,000 $610,000 $590,000
Variable expenses 623,950 235,850 140,300 247,800
Contribution margin 1,021,050 209,150 469,700 342,200
Fixed expenses Traceable 759,000 229,000 327,000 203,000
Fixed expenses: Common 364,000
Net operating income (loss) $ (101,950) ($19,850) $142,700 $139,200
2-a. Division West:
Sales $660,800 (590,000 x 1.12)
Variable expenses 247,800
Contribution 413,000
Fixed Costs 224,000
Net operating income (loss) $ 189,000
Difference = $49,800 ($189,000 - 139,200)
The net operating income would increase by $49,800.
2-b. I would recommend the increased advertising. It brings in more profit than the costs.
Explanation:
a) Data:
Income Statement
Sales $ 1,645,000
Variable expenses 623,950
Contribution margin 1,021,050
Fixed expenses 1,123,000
Net operating income (loss) $ (101,950)
b) Windgate Company's segmented income statement has enabled the tracing of fixed costs to the three divisions and the calculation of net operating income for the three divisions. Thus, revealing that Division East was not profitable. From this information, management can decide to make some changes or altogether dispose of Division East in order to redeem the fortunes of the company.
