need the formulas
C25 XV for ? Fixed per year A B 1 Chapter 6: Applying Excel 2 3 Data 4 Selling price per unit $50 5. Manufacturing costs 6 Variable per unit produced 7 Direct materials $11 8 Direct labor $6 9 Variable manufacturing overhead $3 10 Fixed manufacturing overhead per year $120,000 11 Selling and administrative expenses 12 Variable per unit sold $4 13 $70,000 14 15 Year 1 Year 2 16 Units in beginning inventory 0 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 0 26 Units produced during the year 2 ? 27 Units sold during the year 2 2 28 Units in ending inventory 2 2 29 30 Compute the Absorption Costing Unit Product Cost 31 Year 1 Year 2 Chapter 6 Form Ready 22 Direct materiale Type here to search ot C25 P D 2 ? B o Compute the Absorption Costing Unit Product Cost -1 Year 1 Year 2 52 Direct materials ? 3 Direct labor ? ? 34 Variable manufacturing overhead 2 ? 35 Fixed manufacturing overhead 2 ? 36 Absorption costing unit product cost ? ? 37 38 Construct the Absorption Costing Income Statement 39 Year 1 Year 2 40 Sales 2 2 41 Cost of goods sold ? 42 Gross margin ? 43 Selling and administrative expenses ? ? 44 Net operating income ? ? 45 46 Compute the Variable Costing Unit Product Cost 47 Year 1 Year 2 48 Direct materials 2 49 Direct labor 50 Variable manufacturing overhead 51 Variable costing unit product cost 52 53 Construct the Variable Costing Income Statement 54 Year 1 55 Sales 56 Variable expenses 57 Variable cost of goods sold 2 58 Variable selling and administrative expenses 2 ? 59. Contribution margin ? 60 Fixed expenses Chapter 6 Form Ready 2 ? ? 2 2 Year 2 2 2 2 Year 2 44 Net operating income ? 75 16 Compute the Variable Costing Unit Product Cost Year 1 Year 2 48 Direct materials ? 2 49 Direct labor ? 2 50 Variable manufacturing overhead ? ? 51 Variable costing unit product cost ? 2 52 53 Construct the Variable Costing Income Statement 54 Year 1 55 Sales 56 Variable expenses 57 Variable cost of goods sold ? 58 Variable selling and administrative expenses 2 2 59 Contribution margin 60 Fixed expenses 61 Fixed manufacturing overhead 2 62 Fixed selling and administrative expenses ? ? 63 Net operating income 64 Chapter 6 Form Ready Eo 2 ? 2 ? ? ? ? . 2 ? 2 ? 2
