please use excel

Kozler Company uses the perpetual inventory system and had the following purchases and sales during March. 100 3/1 Beginning inventory 3/3 Purchase 3/4 Sales 3/10 Purchase 3/16 Sales 3/19 Purchase 3/25 Sales $50 $55 $60 70 80 120 $80 $90 S90 200 40 Instructions 1. Using the perpetual inventory and sales data above, calculate the value assigned to cost of goods sold in March and to the ending inventory at March 31 using (a) FIFO and (b) LIFO 2. Assume that Kozler used the periodic inventory system and calculate the value assigned to cost of goods sold in March and to the ending inventory at March 31 using (a) FIFO and (b) LIFO