Make sure you give proper cell referencing for everything with proper formulas.

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

$4.$ Determine the cost assigned to ending inventory and to cost of goods sold using LIFO."

Make sure to provide cell referencing. For example B$1+$C$2$ or D$2*$A$3.$

Date Activities Units Acquired at Cost Units sold at Retail

Units "Cost

per unit" Total cost Units Selling price per unit Total Sales

January $01$ Beginning inventory $140$ $$6\mathrm{.}00$ $$840$

January $10$ Sales $100$ $$15$ $$1,500$

January $20$ Purchase $60$ $$5\mathrm{.}00300$

January $25$ Sales $80$ $$15$ $$1,200$

January $30$ Purchase $180$ $$4\mathrm{.}50810$

$$ Totals $380$ $$1,950180$ $$2,700$

Perpetual LIFO Cost of Goods Sold $-$ Jan $10$ Cost of Goods Sold $-$ Jan $25$ Ending Inventory

Units available Units "Cost

per unit" Cost of goods sold Units "Cost

per unit" Cost of goods sold Units "Cost

per unit" Inventory

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

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

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

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