AutoSave off Week2HomeworkChapters56 Question 30 Protected View O Search (Al-Q File Home Insert Draw Page Layout Formulas Data Review View Help PROTECTED VIEW Be cantful-htes from the Internet.can.contain viruses. Unless you need to edit its safer to stay in Protected View VIXVfx Formula: Multiply, Cell Referencing Al A D 1 Formula: Multiply; Cell Referencing 2 G H Toutle Editing M N 3 Using Excel to Determine Ending Inventory 4 5 In its first month of operations, McLanie Company made PROBLEM 6 three purchases of merchandise in the following sequence: 7 Purchase $ Units 1 300 at 9 Unit Cost $6.00 10 2 400 at $ 8.00 11 3 500 at $ 9.00 12 13 McLanie uses a periodic inventory system. It also provided. 14 the following information: 15 16 Units on hand 200 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 FIFO 200 Compute the cost of the ending inventory under the b. LIFO method Units Unit Cost Total Cost LIFO 200