REQUIRED: Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. Each yellow cell must include a formula using cell references, EVEN IF THE FORMULA RESULT IS ZERO.

$\backslash$table$[[$Date$,,\backslash$table$[[$Units$],[$purchased$]],\backslash$table$[[$Cost per$],[$unit$]],\backslash$table$[[$Total Cost$],[$of Purchase$]],$Units Sold,$\backslash$table$[[$Selling Price$],[$per unit$]],$Total Sales$],[$Jan$.1,$Beginning inventory,$580,$$$15,$$$8,700,,,],[$Jan$.11,$Sales,,,,$460,$$$50,$$$23,000$