Requirement $3.$ Compute cost of goods sold and gross profit using the weighted$-$average inventory costing method. $($Round weighte

Begin by computing the cost of goods sold and cost of ending merchandise inventory using the weighted$-$average inventory costing $n$ each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of me

$\backslash$table$[[,$Purchases,Cost of Goods Sold,Inventory on Hand$],[,,\backslash$table$[[$Unit$],[$Date$]],\backslash$table$[[$Total$],[$Cost$]],$Quantity,$\backslash$table$[[$Unit$],[$Cost$]],\backslash$table$[[$Total$],[$Cost$]],$Quantity,$\backslash$table$[[$Unit$],[$Cost$]],\backslash$table$[[$Total$],[$Cost$]]],[$Jul$.1,,,,,,,,,],[11,,,,,,,,,],[23,,,,,,,,,],[26,,,,,,,,,],[29,,,,,,,,,],[$Totals$,,,,,,,,,]]$

More info

$\backslash$table$[[$Jul$.1,$Beginning merchandise inventory,$20$ tires @ $$66$ each$],[$Jul$.11$ Purchase,$8$ tires @ $$73$ each,$],[$Jul$.23,$Sale,$15$ tires @ $$88$ each$],[$Jul$.26$ Purchase,$13$ tires @ $$84$ each,$],[$Jul$.29,$Sale,$15$ tires @ $$88$ each$]]$