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 LFO. (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 inventory methods. (Alt numbers should be positive.)