Please show work and equations for this format. Thank you!

P12-5 Brislin Company has four operating divisions. During the first quarter of 2017, the company reported aggregate income from operations of $213,000 and the following divisional results. $250,000 200,000 Sales Cost of goods sold Selling and administrative expenses Income (loss) from operations Division III $200,000 $500,000 192,000 300,000 60,000 $(52,000) $140,000 IV $450,000 250,000 50,000 $150,000 $(25,000) Analysis reveals the following percentages of variable costs in each division. Cost of goods sold 70% 90% 80% Selling and administrative expenses 40 60 50 N 75% 60 (a) $80,000 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 (I and II). Con sensus is that one or both of the divisions should be discontinued. Instructions (a) Compute the contribution margin for Divisions I and II. (b) Prepare an incremental analysis concerning the possible discontinuance of (1) Divi. sion I and (2) Division II. What course of action do you recommend for each division? (c) Prepare a columnar condensed income statement for Brislin Company, assuming Division II is eliminated. (Use the CVP format.) Division II's unavoidable fixed costs are allocated equally to the continuing divisions. (d) Reconcile the total income from operations ($213,000) with the total income from operations without Division II. (a) Refer to Learning Objective 6 and given information within the problem Division Division 11 Sales Variable costs Cost of goods sold Selling and administrative Total variable expenses Contribution margin (0) (0) Net Income Increase (Decrease) Continue Eliminate Division Contribution margin (above) Fixed costs Cost of goods sold Selling and administrative Total fixed expenses Income (loss) from operations (b)(2) Continue Eliminate Net Income Increase (Decrease) Division 11 Contribution margin (above) Fixed costs Cost of goods sold Selling and administrative Total fixed expenses Income (loss) from operations Recommendations for Division II: Recommendations for Division 1: c) Show work or include formulas for each cell Refer to LO6 Brislin Company CVP Income Statement For The Quarter Ended March 31, 2017 Divisions Total Sales Variable costs Cost of good sold Selling & administrative Total variable costs Contribution margin Fixed costs Cost of goods sold Selling and administrative Total fxed costs Income (loss) from operations (d)