The Apple Company reported the following January purchases and sales data for its only product. The company uses a perpetual inventory system.

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$[[$Date$,\backslash$table$[[$Units$],[$purchased$]],\backslash$table$[[$Cost per$],[$unit$]],\backslash$table$[[$Total Cost$],[$of$],[$Purchase$]],$Units Sold,$\backslash$table$[[$Selling$],[$Price per$],[$unit$]],\backslash$table$[[$Total$],[$Sales$]]],[$Jan$.1,$Beginning inventory,$200,$$$10,$$$2,000,,],[$Jan$.11,$Sales,,,,$160,$$$30,$$$4,800$