REQUIRED: Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. Each Jellow cell must include a formula using cell references, EVEN IF THE FORMULA RESULT IS ZERO. Notice that the sum of cost of goods sold, $23,980, plus ending inventory, $0, equals total cost of goods available for sale, $28,360