Periodic inventory by three methods The units of an item avalable for sale during the year were as follows: Jan. 1 Inventory 2,400 units at $3 Feb. 17 Purchase 3,800 units at $5 Jut. 21 Purchase 2,700 units at $7 Nov, 23 Purchase 1,100 units at $9 There are 1,500 unis of the item in the physical inventory at December 31. The periodic inventory system is used. This information has been collected in the Microsot Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions beliow. Open spreadsheet a. Determine the inventory cost by the first-in, first-out method. x b. Determine thif inventory cost by the Iant-in, first-out method. x c. Determine the inventory cost by the weiphted averogo cost method. Round your answer to the nearest doltar