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.

Notice that cost of goods sold, $$3,917\mathrm{.}22,$ plus ending inventory, $$3,992\mathrm{.}78,$ equals cost of goods available for sale, $$7,910\mathrm{.}00.$

I need help figuring out the exact excel formulas for the answers... most are correct just wrong formula