Make sure you use the cell references for everything with proper formuals.

Laker Company reported the following January purchases and sales data for its only product. The Company uses a perpetual inventory system. Required: $1)$ Complete the table to determine the cost assigned to ending inventory and cost using special identification.

Make Sure you use the proper cell referencing and formula for each fills. For example C$1*$B$3$ or A$3-$B$4$

Cost of Goods Sold Ending Inventory

Units available Units "Cost

per unit" Total cost Units Cost per unit Total Cost

$140$ units from beginning inventory $$6\mathrm{.}00$ $$6\mathrm{.}00$

$60$ units purchased on January $20$ $$5\mathrm{.}00$ $$5\mathrm{.}00$

$180$ units purchased on January $30$ $$4\mathrm{.}50$ $$4\mathrm{.}50$

Totals $0$ $$0\mathrm{.}000$ $$0\mathrm{.}00$