Formula: Multiply: Cell Referencing Using Excel to Determine Ending Inventory PROBLEM In its first month of operations, McLanie Company made three purchases of merchandise in the following sequence 8 Purchase $ Units Unit Cost 9 300 at $ 6.00 10. 2 400 at $ 8.00 11 3 500 at $ 9.00 12. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use a cell references and mathematical formulas for calculations Compute the cost of the ending inventory under the a FIFO method Units Unit Cost Total Cost McLanie uses a periodic inventory system. It also provided 14 the following information FIFO 200 Compute the cost of the ending inventory under the 15 16 Units on hand 17 18 19 200 b. LIFO method Units Unit Cost Total Cost LIFO 200