Periodic inventory by three methods ? File Home Insert Draw Page Layout Formulas Data Review View Help Editing The units of an item available for sale during the year were as follows: 60 .00 .00 0 Jan. 1 Inventory Purchase 2,200 units at $3 3,300 units at $4 Feb. 17 Jul. 21 Purchase 3,200 units at $5 1 Nov. 23 Purchase 1,300 units at $6 There are 1,500 units of the item in the physical inventory at December 31. The periodic inventory system is used. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Mv Arial 10 B Excel shortcuts enabled C17 fx To make Excel's keyboard shortcuts work in A Excel for the web, we had to override some Periodic inventory by three methods 2 The units of an item available for sale during the year were as follows: browser shortcuts. To undo this, go to Help, then select Keyboard Shortcuts, and uncheck 4 Quantity Override browser shortcuts. 5 Jan. 1, beginning inventory 2.200 6 Feb. 17 purchase 3,300 Undo Got it 7 Jul. 21, purchase 3,200 8 Nov. 23, purchase 1,300 9 Dec 31, ending inventory 1,500 10 Using formulas and cell references, perform the required analysis, and input your answers into the Inventory Cost column. Transfer the numeric results for the green entry cells (B14:B16) into the 11 appropriate fields in CNOWV2 for grading. 12 13 Method Inventory Cost Formulas 14 FIFO 15 LIFO 16 Weighted average cost 17 18 19 20 21 22 23 Open spreadsheet a. Determine the inventory cost by the first-in, first-out method. Round your answer to the nearest dollar. b. Determine the inventory cost by the last-in, first-out method. Round your answer to the nearest dollar. $ c. Determine the inventory cost by the weighted average cost method. Round your answer to the nearest dollar