I just need to figure out what the moving average cost is for the ending inventory. And if you could include an explanation in how you found the average cost on the 18th that would be great because so far I have this. Just so I can understand how to determine the avg cost for a date that has both a purchase and selling of goods.

Date	Buy	COGS	UNITS	AVG Cost	Inventory Cost
2	1700*3.39	0	1700	3.39	5763
7		1200*3.39=4068	500	3.39	1695
10	1100*3.62		1600	3.5481	5677
13		1000*3.5481	600	3.5481	2129
18	1500*3.73	800*?	1300

Some of the information found on a detail inventory card for Concord Inc. for the first month of operations is as follows. Received Balance, No. of Units Issued, No. of Units No. of Units 1,700 Date January Unit Cost $3.39 1,200 1,100 3.62 1,500 3.73 1,000 800 1,100 1,700 500 1,600 600 1,300 200 2,000 700 2,800 1,000 1,800 3.84 1,300 2,100 3.96 1,800 If the perpetual inventory record is kept in dollars, and costs are computed at the time of each withdrawal, would the amounts shown as ending inventory in (1), (2), and (3) above be the same? What amount would be shown as ending inventory? (Round average cost per unit to 4 decimal places, e.g. 2.7621 and final answers to 0 decimal places, e.g. 6,548.) (3) (1) FIFO (2) LIFO Average-cost Would amount be same Yes No Ending Inventory 3960 T 3786