Partially complete excel assignment. Instructions are on sheet 1.

ACC 3020 - Fall 2016 Excel Case #2 - Incremental Analysis Enter your name: Enter your WSU Access ID: fm0239 Consider the following information regarding Wayne Manufacturing Company and the following instructions. This is similar and 20-5B in our textbook. Wayne Manufacturing Company has four operating divisions. During the first quarter of 2016, the company reported the d below and aggregate income shown below. Division: Sales $ Cost of goods sold Selling and adminis Income (loss) from $ North 368,072 $ 216,513 43,303 108,257 $ Analysis reveals the following percentages of variable costs in each division. Division: North Cost of goods sold 70% Selling and adminis 40% South 281,467 180,428 57,737 43,303 South 80% 50% Discontinuance of any division would save 50% of the fixed costs and expenses for that division. Top management is very concerned about the unprofitable divisions (East and West). Consensus is that one or both of the discontinued. Instructions - Your solutions should be clearly labeled on Solutions of this workbook. (a) Compute the contribution margin for the East and West Divisions. (See illustration 20-17 for guidance, if needed.) (b) Prepare an incremental analysis concerning the possible discontinuance of (1) East Division and (2) West Division. What you recommend for each division? Should either be closed? (See illustration 20-18 for guidance, if needed.) (c) Prepare a columnar condensed income statement for Wayne Manufacturing, assuming the division(s) that should be eli eliminated. Use the CVP format. Remember: Closed division's unavoidable fixed costs are allocated equally to the continuin Illustrations 20-16 and 20-17 for guidance, if needed.) e following instructions. This is similar to Problems 20-5A of 2016, the company reported the divisional results shown $ $ East 223,730 $ 194,862 46,912 (18,043) $ Aggregate West Income 129,908 108,257 50,520 (28,868) $ 104,649 East West 75% 65% 90% 70% at division. Consensus is that one or both of the divisions should be 20-17 for guidance, if needed.) Division and (2) West Division. What course of action do guidance, if needed.) ming the division(s) that should be eliminated are are allocated equally to the continuing divisions. (See East (a) (b) Sales Variable Costs Cost of goods sold Selling and administrative Total variable expenses Contribution margin West 223730 129908 194862 46912 241774 -18044 108257 50520 158777 -28869 East Sales Variable Costs Contribution margin Fixed costs Net income Continue Eliminate $223,730.00 Wayne Manufacturing Company CVP Income Statement For the Quarter ended March 31, 2016 Net income Increase (Decrease) 0 -223730 0 0 Net income Increase (Decrease) West Continue Sales Variable costs Contribution margin Fixed costs Net income Eliminate 129908 0 0 0 0 0