$\backslash$table$[[$Date$,$Activities,Units Acquired at cost$,$Units Sold at Retail$],[$August $1,$Beginning inventory,$160$ units e $$10=$$$1,600,],[$August $5,$Purchase,$100$ units e $$12=$$$1,200,],[$August $10,$Sale,,$120$ units sold$],[$August $15,$Purchase,$130$ units e $$13=$$$1,690,],[$August $25,$Sale,,$110$ units sold$]]$

Use the above information to calculate ending inventory using LIFO for a company that uses a perpetual inventory system.

$\backslash$table$[[$Date$,$Goods purchased,Cost of Goods Sold,Inventory Balance$],[\backslash$table$[[$Number of$],[$units$]],\backslash$table$[[$Cost per$],[$unit$]],\backslash$table$[[$Number$],[$of units$],[$sold$]],\backslash$table$[[$Cost per$],[$unit$]],\backslash$table$[[$Cost of Goods$],[$Sold$]],\backslash$table$[[$Number of$],[$units$]],$Cost per unit,Inventory Balance$],[$August $1,,,,,,],[$August $5],[,,,,,,,,],[\backslash$table$[[$Total August $5],[$August $10]]],[$August $10],[,,,,,,,,],[,,,,,,,,],[$August $15],[$Total August $15],[],[$August $25],[,,,,,,,,],[$Total August $25,,,,,,7,,]]$