Formu a: Multiply; Cell Referencing Using Excel to Determine Ending Inventory PROBLEM In its first month of operations, Melanie Company made three purchases of merchandise in the following sequence: Student Work Area Required: Provide input into colls shaded in yollow in this template. Use a coll references and mathematical formulas for calculations Purchase $ Units 300 400 at at at 2 3 Unit Cost $ 6.00 $ 8.00 $ 9.00 Compute the cost of the ending inventory under the a. FIFO method 500 Unit Cost Total Cost Units 200 FIFO Molanle uses a periodic Inventory system. It also provided the following information: Units on hand 200 Compute the cost of the ending Inventory under the b. LIFO method Unit Cost Total Cost Units 200 LIFO