Periodic Inventory by three methods The units of an item available for sale during the year were as follows: Inventory 2,700 units at $5 Feb. 17 Purchase 2,800 units at $6 Jul. 21 Purchase 2,900 units at $7 Nov. 23 Purchase 1,600 units at $8 There are 2,200 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 x Open spreadsheet a. Determine the inventory cost by the first in, first-out method. Round your answer to the nearest dollar. 17,000 b. Determine the inventory cost by the last in first-out method. Round your answer to the nearest dollar 36,600 X c. Determine the inventory cost by the weighted average cost method. Round your answer to the nearest dollar