Needing a hand with the LIFO section.

$1.$ Based on the information given above, calculate cost of goods sold and ending inventory using the FIFO method.

$2.$ Calculate cost of goods sold and ending inventory using the LIFO method.

$3.$ Calculate cost of goods sold and ending inventory using the Weighted Average Method.

$4.$ Calculate gross profit under all three methods.

Requirement $1$: Cost of Goods Sold and Ending Inventory under FIFO

$($Use cells A$2$ to E$12$ from the given information above to complete this question. To calculate the number of units sold within each batch, use the MIN function.$)$