Question

repare a contribution format income statement segmented by divisions. 2-a. 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%. Assuming these estimates are accurate, how much would the company's net operating income increase (decrease) if the proposal is implemented

Answer 1

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