De AaBocedAaBbcAaBbce AaB Abbed Natmal) Nool Heading Heading needle Subtitle|Sube graph corption lite ESETETHER 1. Dov adland complete the spreadsheet found in the Variable sorption costing Spreadsheet Dropbox by inserting slor cell references in al cells highlighted yellow. Each requires a formula oricell reference has a question mark in it. Originally, in Year 1, 20,000 units are produced, and 16,000 are sold and 28,000 units are produced in Year 2 and 32,000 us are sold since more units are produced in Year 2, the absorption unit product cost will decrease because you're ading the fixed overhead over more units. So...when you calculate labsorption COGS in Year 2, you will need to use the year 1 product cost for the older units you sold and the Year 2 product t for the newer units you sold. The absorption costing net nating income should be $176,000 in Year 1 and $488,000 in on 2 and the variable costing net operating income should be $148,000 in Year 1 and $516,000 in Year 2.1 12. Check the accuracy of the formulas in your spreadsheet by and changing the number of units produced in Year 2 to 17,500 (cell c12) and the number of units sold in Year 2 to 21,500 (cell 018) thelabsorption costing net operating income in Year 2 should now bels246,500l and the manable costing net operating income in Year 2 should be skool Your Yerlinet operating incomes shouldn't changedhe newmen netoperating incomesdam! calculate correcto USOD O MU submittit Paste * Format Painter Cpboard PODE H53 DM 45 DL 46 Variable Manuf OIH 47 Total Unit Product Cost Year 2 49 Variable Costing Income Statements: Year 51- Sales 52 Variable expenses: 5 COGS 2 54 Variable Selling and Admin expense 55 Contribution Margin 56 Fixed expenses: 57 Fixed Manuf OH 58 Fixed Selling and Admin expense 59 Net Operating Income On || 60 De AaBocedAaBbcAaBbce AaB Abbed Natmal) Nool Heading Heading needle Subtitle|Sube graph corption lite ESETETHER 1. Dov adland complete the spreadsheet found in the Variable sorption costing Spreadsheet Dropbox by inserting slor cell references in al cells highlighted yellow. Each requires a formula oricell reference has a question mark in it. Originally, in Year 1, 20,000 units are produced, and 16,000 are sold and 28,000 units are produced in Year 2 and 32,000 us are sold since more units are produced in Year 2, the absorption unit product cost will decrease because you're ading the fixed overhead over more units. So...when you calculate labsorption COGS in Year 2, you will need to use the year 1 product cost for the older units you sold and the Year 2 product t for the newer units you sold. The absorption costing net nating income should be $176,000 in Year 1 and $488,000 in on 2 and the variable costing net operating income should be $148,000 in Year 1 and $516,000 in Year 2.1 12. Check the accuracy of the formulas in your spreadsheet by and changing the number of units produced in Year 2 to 17,500 (cell c12) and the number of units sold in Year 2 to 21,500 (cell 018) thelabsorption costing net operating income in Year 2 should now bels246,500l and the manable costing net operating income in Year 2 should be skool Your Yerlinet operating incomes shouldn't changedhe newmen netoperating incomesdam! calculate correcto USOD O MU submittit Paste * Format Painter Cpboard PODE H53 DM 45 DL 46 Variable Manuf OIH 47 Total Unit Product Cost Year 2 49 Variable Costing Income Statements: Year 51- Sales 52 Variable expenses: 5 COGS 2 54 Variable Selling and Admin expense 55 Contribution Margin 56 Fixed expenses: 57 Fixed Manuf OH 58 Fixed Selling and Admin expense 59 Net Operating Income On || 60