check

Data Table Oct. 5 Purchase 140 crates @ $ 87 each 160 crates @ $ 96 each 13 Sale 18 Purchase 154 crates @ $ 91 each 26 Sale 200 crates @ $ 108 each Requirement 3. Prepare a perpetual inventory record, using the weighted average inventory costing method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit. Begin by computing the cost of goods sold and cost of ending merchandise inventory using the weighted average inventory costing method. Enter the transactions in chronological order, calculating new inventory on hand balances after each transaction. Once all of the transactions have been entered into the perpetual record, calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the period. (Round weighted-average cost per unit to the nearest cent and all other amounts to the nearest dollar.) Purchases Cost of Goods Sold Inventory on Hand Unit Total Unit Total Unit Total Date Quantity Cost Cost Quantity Cost Cost Quantity Cost Cost Oct. 1 76 60 4560 5 140 87 12180 216 77.5 16740 13 160 77.5 12400 56 77.5 4340 18 154 91 14014 210 87.4 18354 26 200 87.4 17480 10 87.4 874 26194 29880 874 Totals 294 360 10