File Home Insert Draw Page Layout A1 Formulas Data Review PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless y XVfx A Chapter 7: Applying Excel B C D E 1 Chapter 7: Applying Excel 2 3 Data 4 Selling price per unit $50 5 Manufacturing costs 6 Variable per unit produced Direct materials $11 8 Direct labor $6 9 10 12 13 14 15 16 Units in beginning inventory 17 Units produced during the year 18 Units sold during the year 19 Variable manufacturing overhead 11 Selling and administrative expenses: Variable per unit sold Fixed per year $3 Fixed manufacturing overhead per year $120,000 $4 $70,000 Year 1 Year 2 0 10,000 6,000 8,000 8,000 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 ? 27 Units sold during the year ? 28 Units in ending inventory ? ??? ? 29 ????? 30 Compute the Absorption Costing Unit Product Cost 31 Year 1 Year 2 32 Direct materials 33 Direct labor ? ? 34 Variable manufacturing overhead 35 Foxed manufacturing overhead 36 Absorption costing unit product cost ? ? ? Chapter 7 Form Ready P 76F