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$

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

$\backslash$table$[[$Ending Inventory $-$ Perpetual FIFO:,$\backslash$table$[[$Units in$],[$Ending$],[$Inventory$]],$@$,\backslash$table$[[$Cost per$],[$unit$]],=,\backslash$table$[[$Inventory$],[$Balance$]]],[$Total Ending Inventory for January,$-380$ units,$10,,,]]$

Instructions

FIFO

LIFO