Question Completion:
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 Variable expenses Contribution margin Fixed expenses Net operating income (loss) $ 1,509,000 567,040 941,968 1,036,000 $ (94,040) 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 Central $389,000 $600,000 $520,000 East West Sales Variable expenses as a percentage of sales Traceable fixed expenses 27% 36% $283,000 $336,000 $203,000
Prepare a contribution format income statement segmented by divisions Division Total Company East Central West
The Marketing Department has proposed increasing the West Division's monthly advertising by $25,000 based on the belief that it would increase that division's sales by 19%.
Answer:
Wingate Company
a. Contribution format income statement segmented by divisions
Division Total Company East Central West
Sales $ 1,509,000 $389,000 $600,000 $520,000
Variable expenses 567,040 217,840 162,000 187,200
Contribution margin 941,960 $171,160 $438,000 $332,800
Traceable fixed expenses 822,000 $283,000 $336,000 $203,000
Non-traceable fixed expense 214,000
Net operating income (loss) $ (94,040) ($111,840) $102,000 $129,800
b. If the marketing department's proposal is implemented, the net operating loss will decrease by $38,232, i.e from $94,040 to $55,808.
Explanation:
a) Data and Calculations:
Wingate's most recent monthly contribution format income statement:
Sales $ 1,509,000
Variable expenses 567,040
Contribution margin 941,968
Fixed expenses 1,036,000
Net operating income (loss) $ (94,040)
Additional information:
Division Central East West
Sales $389,000 $600,000 $520,000
Variable expenses as a
percentage of sales 56% 27% 36%
Traceable fixed expenses $283,000 $336,000 $203,000
Increase in Division West's fixed expenses by $25,000
Expected increase in Division West's sales = 19%
Contribution format income statement segmented by divisions
Division Total Company East Central West
Sales $ 1,509,000 $389,000 $600,000 $520,000
Variable expenses 567,040 217,840 162,000 187,200
Contribution margin 941,968 $171,160 $438,000 $332,800
Traceable fixed expenses 822,000 $283,000 $336,000 $203,000
Non-traceable fixed expense 214,000
Net operating income (loss) $ (94,040) ($111,840) $102,000 $129,800
Based on new proposal:
Contribution format income statement segmented by divisions
Division Total Company East Central West
Sales $ 1,607,800 $389,000 $600,000 $618,800
Variable expenses 602,608 217,840 162,000 222,768
Contribution margin 1,005,192 $171,160 $438,000 $396,032
Traceable fixed expenses 847,000 $283,000 $336,000 $228,000
Non-traceable fixed expense 214,000
Net operating income (loss) $ (55,808) ($111,840) $102,000 $168,032