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 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use a cell references and mathematical formulas for calculations. Purchase $ 1 2 3 Units 300 400 500 at at at Unit Cost $ 6.00 $ 8.00 $ 9.00 Compute the cost of the ending inventory under the a. FIFO method Units Unit Cost Total Cost FIFO 200 McLanie uses a periodic inventory system. It also provided the following information: Units on hand Compute the cost of the ending inventory under the b. LIFO method 200 Unit Cost Total Cost Units 200 LIFO