please answer in an excel sheet,thank you
Chapter 6: Applying Excel: Excel Worksheet (Algo) (Part 1 of 2) Download the Applying Excel form and enter formules in all cells that contain question marks For example, in co26 enter the formular Aner entering formula in at of the cells that contained question marks, verify that the dollar amounts match the numbers in Review Problem The LIFO inventory flow assumption is used throughout the problem Check your worksheet by changing the units sold in the Otto 6.000 for You 2. The cost of goods sold under absorption conting for Year 2 should now be $240,000 to check cell The formula in cel should be 26-27.0263627 C26036C2C8your worksheet is operating properly, the net operating income under both absorption costing and variable conting should be 504,000 for Year 2. That is the loss Year 2 $34000 under both method you do not get these answers in the sons in your worksheet and correct them Assume that the units produced in year 2 were sold ist Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse Next, click Save. You will use this worksheet to answer the questions in Part 2 L12 4x fx D G $50 Year 2 6000 8.000 Year 2 2 2 7 A B 1 Chapter 6: Applying Excel 2 3 Data 4 Selling price per unit 5 Manufacturing costs 6 Variable per unit produced 7 Direct materials $11 8 Direct labor Se 9 Variable manufacturing overhead 53 10 Food manufacturing overhead per your $120.000 11 Selling and administrative experten 12 Variable per unit sold $4 13 Fixed per year $70.000 14 15 Year 1 16 Units in beginning inventory 0 17 Units produced during the year 10.000 18 Units soldering the year 1000 19 20 Enter a formula into each the colle marked with a below 21 Review Problem 1: Contrasting Variable and Absorption Costing 22 23 Compute the Ending Inventory 24 You 1 25 Units in beginning invertory 0 26 Units produced during the year ? 27 Units sold ouring the year 7 28 Unitsin ending inventory 2 29 30 Compute the Absorption Costing Unit Product Cost 31 Year 1 32 Direct mails ? 3a Direct labor 34 Variable maracturing overhead ? 35 Fixed manufacturing overhead 2 36 Absorption conting unit product cost 2 37 3 Construct the Absorption Costing Income Statement 29 Year 1 40 Sales 41 Cost goods sold 42 Gross margin 43 Selling and distrative expenses 17 44 Net operating income 7 45 46 Compute the Variable Costing Unit Product Cost 47 Year 1 48 Directors 2 49 Direct labor 7 50 Variable manufacturing over 2 51 Variable cooling unit productos 52 53 Construct the Variable Costing Income Statement 54 55 Sales 55 Variable expenses 57 Variable of goods sold 7 2 58 Variable selling and administrative expenses 59 Contribution margin 60 Fixed expenses 7. 01 Fixed manufacturing overhead 62 Fixed song and administrative expense 7 63 Not operating income Year 2 2 9 ? 2 7 Year 2 7 7 You 2 2 7 ? Year 2 > 65 + Chapter 6 Form Ready
