( Chapter 6.App ; Home Insert Draw Page Layout Formulas Data Review Viev Arial 10 Paste A1xfx Chapter 6: Applying Excel 3 Data $50 4 Seling price per unt Manufacturing costs 6 Variable per unit produced: Dinect materials $11 $6 $3 $120,000 8 Direct labor 9 Variable manufacturing overhead Fxed manufacturing overhead per year 11 Selling and admin strative expenses: 2Verieble per unit sold 13 Fxed per year 14 15 16 Unilts in beginning inventory $4 $70,000 Year 1 Year 2 10,0006,000 8,0008,000 Units produced during the year 18 Units sold during the year 20 Enter a fomule into each of the cells marked with a ? below 21 Review Problem 1: Contrasting Variable and Absorption Costing 23 Compute the Ending Inventory 25 |Units i beginning inventory Year 1 Year 2 Units produced during the year 27 Units sold during the year 28 Units in ending inventory 29 30 Compute the Absorpion Cosing Unit Produet Cost 31 32 Drect materals 33 Direct labor 34 Variable manufacturing overhead 35 Fixed manufacturing overhead 36 Absorption costing unit product cost 37 Year1 Year 2 8 Cons truct the Absorption Costing Income Statement 39 40 Sales 41 Cost of goods sold 42 Gross margin 43 Seling and administrative expenses 44 Net operating income 45 46 Compute the Varlable Costing Unit Product Cost 47 48 Direct materials 49 Direct labor Year 1 Year 2 Year 1 Year 2 S0 Varlable manufacturing overhead 51 Varlable costing unt product cost Chapter 6 Form+ Chapter-6-Applying Home Insert Draw Page Layout Formulas Data ReviewView L. AI : | j5c Chapter 6: Applying Excel 25 wrap Text Gene Arial Paste 38 Cons truet the Absorption Costing Income Statement Year 1Year 2 41 Cost of goods sokd 42 Gross margin 43 Seling and administrative expenses 4 Net operating income 46 Compute the Variable Costing Unit Produet Cost Year tlYear2 48 Direct 9 Direct labor 50 Veiable manufacturing ovemead Variable costing unt product cost 53 Construct the Variable Cosing Income Statement Year 1 Year 2 55 Sales 56 Vaiable expenses Variable cost of goods sold 58 Variable seling and administrative expenses 59 Contribution margin 60 Fued expenses 61 Fxed manufacturing overhead 62 Flxed selling and administrative expenses 63 Net operating income 64 65 67 68 69 70 72 73 74 75 76 79 81