please complete all parts of the excel sheet. include the formulas. thank you

1. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods: 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.) 1. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods: 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.)