I$\text{'}$m$\backslash$table$[[$Date$,$Explanation,Units,Unit,ost,,I Cost$],[$Jan$.1,$Beginning Inventory,$30,$$$,8,$$$,240],[$Mar$.22,$Purchase,$100,,9,,900],[$Jul$.3,$Purchase,$200,,10,,2,000],[$Oct$.31,$Purchase,$80,,12,,960],[,$Total units available for sale,$410,,,$$$,4,100],[,$Units in ending inventory,$(104),,,,],[,$Units sold,$306,,,,]]$

Step $1$

Ending Inventory

$\backslash$table$[[$Ending Inventory$],[$Total Cost,,Total Units,,Weighted$-$Average Unit Cost$],[$$$,,,=$$$,],[$Ending Inventory Units,$s^2,$Unit Cost,,Total Cost$],[,$$$,,=$$$,]]$