eBook Cakulator Weighted Average Cost Method with Perpetual Inventory The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31, are as follows: Number Date Transaction Per Unit Total 7,500 $75.00 Jan. 1 10 28 30 Inventory Purchase Sale 22.500 11,250 5.00 150.00 150.00 Sale 3,750 Sale 150.00 10 87.50 Purchase Sale 16 28 160.00 $562,500 1,912,500 1,687,500 562,500 225,000 4,725,000 4,320,000 4,080,000 4,027,500 4,800,000 675,000 200.000 Sale 1,500 54,000 27,000 25,500 45,000 30,000 7,500 26.250 160.00 Mars Purchase 39.50 14 Sale 160.00 25 30 Purchase Sale 90.00 160.00 eBook Calculator Required: 1. Record the inventory, purchases, and cost of merchandise sold data in a perpetual Inventory record similar to the one illustrated in Exhibit 5, using the weighted average cost method. Round unit cost to two decimal places, if necessary. Schedule of Cont of Merchandise Sold Welghted Average Cost Method For the three months andad March 31 Purchases Cost of Merchandise Sold Unit Cost Total Cost Date Quantity Unit Cost Total Cost Quantity Quantity Jan. 1 Jan. 10 Jan 28 Jan. 30 Feb. 5 Feb. 10 [Feb. 16 Feb. 28 Mors Check My Work Previous Next 2. Determine the total sales, the total cost of merchandise sold, and the gross profit from sales for the period. Total sales Total cost of merchandise sold Gross profit from sales 3. Determine the ending inventory cost as of March 31