pls include the formulas and how you got the total

Sydney Corporation uses a PERIODIC inventory system, and provides the following information relat month of April 2022 Compute the number of units on hand at the end of the month. Required: 1. Determine the cost assigned to ending inventory and to cost of goods sold using the FIFO method 2 Determine the cost assigned to ending inventory and to cost of goods sold using the LIFO method 3. Determine the cost assigned to ending inventory and to cost of goods sold using the average cost Navigotion: 1. Use the Open Excel in New Tab button to launch this question 2. When finished in Excel, use the Sove ond Return to Assignment button in the lower right to return Sydney Corporation uses a PERIODIC inventory system, and provides the following information related to its inventory during the month of April 2022 Compute the number of units on hand at the end of the month. Required: 1. Determir the cost assigned to ending inventory and to cost of goods sold using the Fifo miethod 2. Determine the cost assigned to ending inventaty and to cost of goods sold using the Lifo method. 3 Determine the cost assloned to ending inventory and to cost of coods solf wistg the averape cost inethod Novigation: 3 Sydney Corporation uses a PERIODIC inventory system, and provides the following information related to its inventory during the month of A. Apdi 2023. Compute the number of units on hand at the end of the month. Required: 1. Determine the cost assigned to ending inventory and to cost of goods sold using the Fifo method. 1. Determine the cost assgned to ending inventory and to cost of goods sold using the fifo method. 2. Determine the cost assiged to ending inventory and to cost of goods sold uning the LiFo method. 2. Detertrine the cost assigned to ending inventory and to cost of goods sold using the ufo method. 3. Deteimne the coit uspened to ending inventory and ta cont of fobds sold using the averuge cust method. 3. Determine the cost assigned to ending inventory and to cost of goods sold using the average cost method