Town Furniture began June with merchandise inventory of 42 sofas that cost a total of $32,760. During the month, the company purchased and sold merchandise on account as follows: June 7 June 14 June 18 June 27 Purchase Sale Purchase Sale 27 sofas $710 each 20 sofas $1,000 each 52 sofas $740 each 45 sofas $1,050 each 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. (Round weighted-average cost per unit to the nearest cent and all other amounts to the nearest dollar.) Start by entering the beginning inventory balances. 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 inventory purchased, sold, and on hand at the end of the period. Purchases Cost of Goods Sold Unit Total Unit Total Inventory on Hand Unit Total Date Quantity Cost Cost Quantity Cost Cost Quantity Cost Cost