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

$\backslash$table$[[$Date$,\backslash$table$[[\backslash$table$[[$Units$],[$purchased$]]],[580]],\backslash$table$[[\backslash$table$[[$Cost per$],[$unit$]]],[$$$15$