Where there is a ? mark, there needs to be a formula (+B15-B5) Thanks!

A 1 Chapter 6: Applying Excel 2 $50 $11 3 Data 4 Selling price per unit 5 Manufacturing costs: 6 Variable per unit produced: 7 Direct materials 8 Direct labor 9 Variable manufacturing overhead 10 Fixed manufacturing overhead per year 11 Selling and administrative expenses: 12 Variable per unit sold 13 Fixed per year $6 $120,000 $70,000 14 15 Year 1 Year 2 16 Units in beginning inventory 17 Units produced during the year 10,000 6,000 18 Units sold during the year 8,000 8,000 19 20 Enter a formula into each of the cells marked with a ? below 21 Review Problem 1: Contrasting Variable and Absorption Costing 22 23 Compute the Ending Inventory 24 Year 1 Year 2 25 Units in beginning inventory 26 Units produced during the year Year 2 27 Units sold during the year 28 Units in ending inventory 29 30 Compute the Absorption Costing Unit Product Cost 31 Year 1 32 Direct materials 33 Direct labor 34 Variable manufacturing overhead 35 Fixed manufacturing overhead 36 Absorption costing unit product cost 37 38 Construct the Absorption Costing Income Statement 39 Year 1 40 Sales 41 Cost of goods sold 42 Gross margin 43 Selling and administrative expenses 44 Net operating income ? Year 2 ? ? ? 47 Year 46 Compute the Variable Costing Unit Product Cost Year 1 48 Direct materials 49 Direct labor 50 Variable manufacturing overhead 51 Variable costing unit product cost 52 Year 1 Year 2 53 Construct the Variable Costing Income Statement 54 55 Sales 56 Variable expenses: 57 Variable cost of goods sold 58 Variable selling and administrative expenses 59 Contribution margin 60 Fixed expenses: 61 Fixed manufacturing overhead 62 Fixed selling and administrative expenses 63 Net operating income