Requirement 3. Determine the amount that would be reported in ending merchandise inventory on November 15 using the weighted average inventory costing method Enter the fansactionchological orded calfarding the emertory on band balances after each transaction once all of the transactions have been entered into the perpetual record calculate the quantity and total cost ef inventory purchasedsoldand on hand at end of the penodcent) Purchases Cost of Goods Sold Inventory on Hand Total linis Total I Init Total Purchases Cost of Goods Sold Inventory on Hand Unit Total Unit Total Unit Total Date Quantity Cost Cost Quantity Cost Cost Quantity Cost Cost Nov. 2 2.15 6 2 2.80 6 2 80 8 6 13 3 2.85 14 4 16 0 Data Table X Purchase 166 crates 604 each Jul 1Sale 180 crates @ 104 each Jul 18 Purchase 114 crates @ 175 each Jul. 26 Sale 150 crates $112 each Print Done