Please use excel and show work / explain. Thank you!

A company sells a single product and had the following beginning inventory, purchases, and sales during March. image0015eb99897.gif ... $6 Beginning Inventory March 6 Purchase 8 Purchase 10 Sale 12 Sale 30 Purchase Number of units Price per unit 20 40 $8 50 $7 45 $12 35 $12 25 $9 1) The company uses a periodic inventory system and determines cost on a FIFO basis. Ending inventory cost 2) The company uses a periodic inventory system and determines cost on a weighted average basis. (Round average cost per unit to 2 decimals.) Ending inventory cost