Required: 1) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic FIFO. (Use cells A4 to D10 from the given information to complete this question.) 2) Calculate both the Ending Inventory and Cost of Goods Sold using Periodic LIFO. (Use cells A4 to D10 from the given information to complete this question.) 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 Sold. (Use cells A4 to D10 from the given information to complete this question.) 4) Use the given information and your calculated numbers to complete the Cost of Goods Sold Equation below for all three methods. (All numbers should be positive.) 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.) (Use cells A4 to D10 from the given information to complete this question.) Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. Nothing in this area will be graded, but it will be submitted with your assignment