Please fill in all the boxes and calculate the quantity and total cost of merchandise inventory purchased, sold, and on hand at the end of the period.

Exercise World began May with merchandise inventory of 95 crates of vitamins that cost a total of $3,800. During the month, Exercise World purchased and sold merchandise on account as follows: 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.) Cost of Goods Sold Purchases Unit Cost Inventory on Hand Inventor Unit Total Unit Total Total Date Quantity Cost Quantity Cost Cost Quantity Cost Cost May 1 Totals Data Table May 5 Purchase 13 Sale 155 crates @ 180 crates @ 193 crates @ 200 crates @ $ $ $ $ 71 each 104 each 75 each 106 each 18 Purchase 26 Sale Print Print Done Done