This question is regarding an excel spreadsheet which requires you to input formulas into the cells corresponding with variable and absorption costing. I'm having diffculties finding the correct formulas to input into the cells. The cells with questions mark require formulas. I have already filled some of the cells out, but would appreciate a check on my answers.

Edit Font Alignment | Fill : Arial Wr Clear Paste B58 1-1 Chapter 6: Applying Excel 3 Data 4 Selling price per unit 5 Manufacturing costs 6 Variable per unit produced $11 Direct materials Direct labor Var 8 riable manufacturing overhead $3 $120,000 10 Fixed manufacturing overhead per year 11 Selling and administrative expenses: 12 Variable per unit sold 13 Fixed per year 14 15 16 Units in beginning inventory 17 Units produced during the year 18 Units sold during the year 19 20 Enter a formula into each of the cells marked with a ? below 21 Review Problem 1: Contrasting Variable and Absorption Costing $4 $70,000 Year 1 Year 2 10,000 8,000 6,000 8,000 23 Compute the Ending Inventory 24 Year 1 Year 2 25 Units in beginning inventory 26 Units produced during the year 27 Units sold during the year 28 Units in ending i 29 30 Compute the Absorption Costing Unit Product Cost 31 32 Direct materials 33 Direct labor 34 Variable manufacturing overhead 6,000 8,000 2.000 Year 1 Year 2 $11 $11 35 Fixed manufacturing overhead 36 Absorption costing unit product cost 37 38 Construct the Absorption Costing Income Statement 39 40 Sales 41 Cost of goods sold 42 Gross margin 43 Selling and administrative expenses 44 Net operating income 20 32 Year 1 400,000$ 400,00o Year 2 80,000 102,000 22,000 240,000 160,000 102,000