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.

Date Units Per unit

April $1$ Inventory on hand $3,000$ units at cost of $ $6\mathrm{.}00$ per unit

April $7$ Sold $2,400$ units for $ $20\mathrm{.}00$ each

April $10$ Purchase $1,200$ units at a cost of $ $6\mathrm{.}30$ per unit

April $19$ Sold $900$ units for $ $20\mathrm{.}00$ each

April $25$ Purchase $1,400$ units at a cost of $ $7\mathrm{.}20$ per unit

April $30$ Inventory on hand $?$ units

Required:

Determine the cost assigned to ending inventory and to cost of goods sold using the FIFO method.

Determine the cost assigned to ending inventory and to cost of goods sold using the LIFO method.

Determine the cost assigned to ending inventory and to cost of goods sold using the average cost method.

Navigation:

Use the Open Excel in New Tab button to launch this question.

When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.

I want help with the formula to enter answer on the excel.