FORMULAS REQUIRED FOR EXCEL. please complete the excel sheets by providing formulas to input in excel.

1. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods. 1) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic FIFO. 2) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic LIFO. 3) Using Periodic Weighted Average, first calculate the cost per unit using the formula below. Next, apply that same cost per unit to calculate both the Ending Inventory and Cost of Goods Sol WeightedCostofGoodsAvailableforSaleAverageCost=NumberofUnitsAvailableforSale 4) Use the given information and your calculated numbers to complete the Cost of Goods Sold Eauation below for all three inventory methods. (All numbers should be nositive.) 4) Use the given information and your calculated numbers to complete the Cost of Goods Sold Equation below for all three inventory methods. (All numbers should be positive.)