help!!

Download and complete the spreadsheet found in the Variable and Absorption costing Spreadsheet Dropbox by inserting formulas or cell references in all cells highlighted yellow. Each cell that requires a formula or cell reference has a question mark in it. Originally, in Year 1, 20,000 units are produced, and 16,000 units are sold, and 28,000 units are produced in Year 2 and 32,000 units are sold. Since more units are produced in Year 2, the absorption unit product cost will decrease because you're spreading the fixed overhead over more units. So....when you calculate absorption 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 cost for the newer units you sold. The absorption costing net operating income should be $176,000 in Year 1 and $488,000 in Year 2 and the variable costing net operating income should be $148,000 in Year 1 and $516,000 in Year 2. Check the accuracy of the formulas in your spreadsheet by changing the number of units produced in Year 2 to 17,500 (cell C17) and the number of units sold in Year 2 to 21,500 (cell C18). The absorption costing net operating income in Year 2 should now be $246,500 and the variable costing net operating income in Year 2 should be $274,500. Your Year 1 net operating incomes shouldn't change. If the new Year 2 net operating incomes don't calculate correctly, fix the errors in your spreadsheet before you submit it. 1 Miller Corporation produces and sells a single product, a wooden jewelry box. Cost and operating data are given below: $50 $15 $8 3 Selling price per unit 4 Manufacturing costs: 5 Variable (per unit): 6 DM 7 DL 8 Variable Manuf O/H 9 Fixed Manuf O/H per year 10 11 Selling and Admin costs: 12 Variable (per unit) 13 Fixed Selling and Admin expense per year $2 $140,000 $2 $80,000 15 Year 1 Year 2 16 Units in beginning inventory 17 Units produced during the year 18 Units sold during the year 0 20,000 16,000 4,000 28,000 32,000 20 Absorption Costing: 22 Calculate Unit Product Cost: Year 1 Year 2 24 DM 25 DL 26 Variable Manuf O/H 27 Fixed Manuf O/H 28 Total Unit Product Cost 30 Absorption Costing Income Statements: Year 1 Year 2 32 Sales 33 Cost of Goods Sold 34 Gross Profit 35 Selling and Admin Expense: 36 Variable Selling and Admin expense 37 Fixed Selling and Admin expense 18 Net Operating Income 10 Variable Costing: 12 Calculate Unit Product Cost: 14 DM 45 DL 46 Variable Manuf O/H 27 Total Unit Product Cost 9 Variable Costing Income Statements: 51 Sales 52 Variable expenses: 53 COGS 54 Variable Selling and Admin expense 55 Contribution Margin 56 Fixed expenses: 57 Fixed Manuf O/H 58 Fixed Selling and Admin expense 59 Net Operating Income