HELLO,

I need help with the following homework. I did the first couple of parts but with the last one I'm lost. I included all my work, the first screen is what is missing, the last 2 is what I already did.

Your answer is correct. What course of action do you recommend for each division? Division I Division II continued Eliminated X Your answer is incorrect. Try again. Prepare a columnar condensed income statement for Pronghorn Company, assuming Division II is eliminated. Division II's unavoidable fixed costs are allocated equally to the continuing divisions. (If amount decreases net Income then enter the amount using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) PRONGHORN COMPANY CVP Income Statement For the Quarter Ended Divisions Total Sales Variable costs Cost of goods sold Selling and administrative Total variable costs Contribution margin niin on Fixed costs into bidd Cost of goods sold Selling and administrative Total fixed costs Income (loss) from operations Pronghorn Company has four operating divisions. During the first quarter of 2017, the company reported aggregate income from operations of $211,100 and the following divisional results. Division I II III IV Sales Cost of goods sold $246,000 198,000 76,900 $ (28,900) $195,000 192,000 55,000 $ (52,000) $498,000 304,000 56,000 $138,000 $452,000 247,000 51,000 $154,000 Selling and administrative expenses Income (loss) from operations Analysis reveals the following percentages of variable costs in each division. Cost of goods sold Selling and administrative expenses I 73 % 41 II 92 % 6 0 III 77% 48 I 79 % 62 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). Consensus is that one or both of the divisions should be discontinued. Your answer is correct. Compute the contribution margin for Divisions I and II. (Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) Division I Division II Contribution margin $169,931 +14,640 Your answer is correct. Compute the contribution margin for Divisions I and II. (Enter negative amounts using either a negative sign preceding the number e.g.-45 or parentheses e.g. (45).) Contribution margin Division 1 $169,931 Division II -14,640 Your answer is correct. Prepare an incremental analysis concerning the possible discontinuance of Division I. (Round answers to 0 decimal places, e.g. 1525. If amount decreases net income then enter the amount using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) Continue Eliminate 29931 Net Income Increase (Decrease) $ -69931 Contribution margin Fixed costs Cost of goods sold Selling and administrative Total fixed expenses Income (loss) from operations 126730 22686 73460 745371 198831 $728900 76730 22686 149416 5-49416 49416 15-20516 Your answer is partially correct. Try again. Prepare an incremental analysis concerning the possible discontinuance of Division II. (Round answers to o decimal places, e.g. 1525. If amount decreases net income then enter the amount using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).) Continue Eliminate -14,640 Net Income Increase (Decrease) $14,640 Contribution margin Fixed costs Cost of goods sold Selling and administrative 115360 1 7680 17680 2000 Total fixed expenses 11000 18680 $18680) T18680 Income (loss) from operations 51-52,000 133,320