Applying excel $6$: calculate ending inventory and cost of goods sold using perpetual fifo and lifo

$\backslash$table$[[$Date$,\backslash$table$[[$Units$],[$purchased$]],\backslash$table$[[$Cost per$],[$unit$]],\backslash$table$[[$Total Cost$],[$of$],[$Purchase$]],$Units Sold,$\backslash$table$[[$Selling$],[$Price per$],[$unit$]],\backslash$table$[[$Total$],[$Sales$]]],[$Jan$\mathrm{.}1$ Beginning inventory,$200,$$$10,$$$2,000,,,],[$Jan$.11$ Sales,,,,$160,$$$30,$$$4,800$