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:

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 $ 670,000 $ 510,000
Variable expenses as a percentage of sales 46 % 23 % 43 %
Traceable fixed expenses $ 284,000 $ 329,000 $ 209,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 $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?

2-b. Would you recommend the increased advertising?

Solutions

Expert Solution

1
Contribution format income statement segmented by divisions :
Division
Total company East Central West
Sales 1561000 381000 670000 510000
Variable expenses 548660 175260 154100 219300
Contribution margin 1012340 205740 515900 290700
Traceable fixed expenses 822000 284000 329000 209000
Divisional segment margin 190340 (78260) 186900 81700
Common fixed expenses not traceable to divisions 292000
Net operating loss (101660)
Working :
Common fixed expenses not traceable to divisions = Total fixed expenses - Total traceable fixed expenses = 1114000 - 822000 292000
2A If sales is increased by 19% without any change in the variable expenses ratio, then the contribution margin will also increase by 19%
West division
Increase in contribution margin ( 290700 * 19% ) 55233
(-) Increase in advertising expense 25000
Incremental net operating income 30233
Net operating income will increase by 30233
2B Answer : Yes
Increase in advertising expense is resulting in increase in net operating income

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,676,000 Variable expenses 553,600 Contribution margin 1,122,400 Fixed expenses 1,235,000 Net operating income (loss) $ (112,600) 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 $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT