If Exxon uses FIFO for its inventory valuation, calculate the cost of ending inventory and cost of goods sold if ending inventory is $110$ barrels of

crude oil.

Required:

Please use the above information to answer the following:

Note: Use cells A$4$ to D$10$ from the given information to complete this question.

Formula may only include

cell references $($no values$).$