This is on EXCEL, Can you show the formulas used for each cell. I cannot just put the answer. Please helppp!! E22=Determine the cost assigned to ending inventory and to cost of goods sold using the LIFO method.Periodic LIFO\table[[,Cost of Goods Available for Sale,Cost of Goods Sold,Ending Inventory],[,Number of units,Cost per unit,Cost of Goods Available for Sale,Number of units sold,Cost per unit,Cost of Goods Sold,# of units in ending inventory,Cost per unit,Ending Inventory],[Beginning inventory,3,000,$6.00,$18,000,,$6.00,,,$6.00,],[Purchase on April 10,1,200,$6.30,7,560,,$6.30,,,$6.30,],[Purchase on April 25,1,400,$7.20,10,080,,$7.20,,,$7.20,],[Total,5,600,,$35,640,,,,,,]]36373. Determine the cost assigned to ending inventory and to cost of goods sold using the average cost method.38Weighted average - Periodic\table[[,Cost of Goods Available for Sale,Cost of Goods Sold,Ending Inventory],[,Number of units,Average Cost per unit,Cost of Goods Available for Sale,Number of units sold,Average Cost per Unit,Cost of Goods Sold],[Beginning inventory,3,000,,$18,000,,,,,,],[Purchase on April 10,1,200,,7,560,,,,,,],[Purchase on April 25,1,400,,10,080,,,,,,],[Total,5,600,,,,,,,,]]464748D8Graded WorksheetWorkbook Statistics