Make sure you use 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.

Required: $2.$ Determine the cost assigned to ending inventory and to cost of goods sold using weighted average."

Make sure you give cell references for every calculations. For example B$1-$A$2$ or D$4/$C$2$

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\mathrm{.}00$ $$1,500$

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

January $25$ Sales $80$ $$15\mathrm{.}00$ $$1,200$

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

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

eighted Average Cost of Goods Sold Inventory Balance

Date Activities Units "Cost

per unit" Cost of goods sold Units Cost per unit Total Cost

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

January $10$ Sales $100$

January $20$ Purchase

January $25$ Sales $80$

January $30$ Purchase

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