2 Function SUM; Formula: Multiply, Subtract; Cell Referencing 3 Using Excel to Compute Ending Inventory Using FIFO 4 and LIFO 5 PROBLEM 6 In its first month of operations, Weatherall Company made 7 three purchases of merchandise in the following sequence: 8 9 10 11 12 13 Purchase $ Units Unit Cost 300 $ 6.00 2 400 7.00 3 200 8.00 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work area as indicated. List the newer units first for FIFO and the older units first for LIFO Compute the cost of the ending inventory under the a FIFO method Units Unit Cost Total Cost 14 Weatherall uses a periodic inventory system. It also 15 provided the following information: 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Units on hand 380 b LIFO method