Please include cell references and the calculations so I can learn the material :) !! Thank you so much!!

AutoSave O OFF n . C G E ... Inventory Costing Methods case project (1) Home Insert Draw Page Layout Formulas Data Review View Automate ? Tell me Comments Share New Office All Automate Script Scripts Scripts a Task 123 X fx G H 1 K L M N Q R Using the LIFO method, complete the steps below to calculate the ending inventory units, inventory account balance, and cost of goods sold account balance at the end of the period. Sale Price Date Activity Units Purchase Price (per unit) (per unit) 1-Feb Beginning Inventory 100 $ 5-Feb Purchase 700 S 9-Apr Sale 1 600 90 9-May Purchase 500 $ 56 10 10-Jul Sale 2 600 90 11 10-Sep Purchase 400 $ 58 12 15-Oct Sale 3 400 90 13 5-Nov Purchase 900 $ 62 14 18-Dec Sale 4 200 90 15 1. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 1. Must show each component of the calculation on a separate line. Refer to the Excel examples. ( 3 points total. For all calculations, you must 16 use a formula in the cell to get full credit). 17 Cost of Goods Sold Total COGS after Sale Inventory Remaining Total Inventory Balance after Sale 1 18 19 20 Totals: 21 2. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 2. Must show each component of the calculation on a separate line. Refer to the Excel examples. ( 3 points total. For all calculations, you must 22 use a formula in the cell to get full credit). 23 Cost of Goods Sold Total COGS after Sale 2 Inventory Remaining Total Balance after Sale 2 24 25 26 Totals: 27 3. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 3. Must show each component of the calculation on a separate line. Refer to the Excel examples. ( 3 points total. For all calculations, you must 28 use a formula in the cell to get full credit). 29 Cost of Goods Sold Total COGS after Sale 3 Inventory Remaining Total Balance after Sale 3 30 31 32 Totals: 23 4. Compute the Cost of Goods Sold and ending inventory (units and value) after Sale 4. Must show each component of the calculation on a separate line. Refer to the Excel examples.( 3 points total. For all calculations, you must 34 use a formula in the cell to get full credit). 35 Cost of Goods Sold Total COGS after Sale 4 Inventory Remaining Total Balance after Sale 4 36 37 38 Totals 39 40 5. Calculate the values below (3 points total. For all calculations, must use a formula in the cell to get full credit) 41 Ending inventory units: 42 Ending inventory account balance: 43 Cost of Goods Sold account balance: 44 45 Part 1-LIFO Part 2-Weighted Average Part 3-FIFO Part 4-Analysis + Ready Accessibility: Good to go + 83%