Question

In: Accounting

Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as...

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

Solutions

Expert Solution

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


Related Solutions

Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as...
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,581,000 Variable expenses 552,420 Contribution margin 1,028,580 Fixed expenses 1,131,000 Net operating income (loss) $ (102,420) 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 $ 391,000 $...
Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as...
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,612,000 Variable expenses 541,980 Contribution margin 1,070,020 Fixed expenses 1,177,000 Net operating income (loss) $ (106,980) 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 $ 402,000 $...
Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as...
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,617,000 Variable expenses 586,830 Contribution margin 1,030,170 Fixed expenses 1,133,000 Net operating income (loss) $ (102,830) 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 $ 447,000 $...
Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as...
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,617,000 Variable expenses 586,830 Contribution margin 1,030,170 Fixed expenses 1,133,000 Net operating income (loss) $ (102,830) 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 $ 447,000 $...
Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as...
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,613,000 Variable expenses 594,690 Contribution margin 1,018,310 Fixed expenses 1,120,000 Net operating income (loss) $ (101,690) 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 $ 393,000 $...
Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as...
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,687,000 Variable expenses 602,830 Contribution margin 1,084,170 Fixed expenses 1,193,000 Net operating income (loss) $ (108,830) 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 $ 447,000 $...
Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as...
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,569,000 Variable expenses 656,910 Contribution margin 912,090 Fixed expenses 1,003,000 Net operating income (loss) $ (90,910) 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 $ 429,000 $...
Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as...
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,633,000 Variable expenses 578,910 Contribution margin 1,054,090 Fixed expenses 1,159,000 Net operating income (loss) $ (104,910) 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 $ 413,000 $...
Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as...
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,586,000 Variable expenses 623,640 Contribution margin 962,360 Fixed expenses 1,059,000 Net operating income (loss) $ (96,640) 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 $ 416,000 $...
Wingate Company, a wholesale distributor of electronic equipment, has been experiencing losses for some time, as...
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,561,000 Variable expenses 548,660 Contribution margin 1,012,340 Fixed expenses 1,114,000 Net operating income (loss) $ (101,660) 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 $ 381,000 $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT