The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are as follows: Number Transaction of Units Per Unit Jan. Inventory 8.000 10 Purchase 240.000 82,00 28 Sale 12,000 144.00 5575.000 1,963.000 1,728.000 575.000 230.400 4,867,200 4,435.200 Feb. Sale 10 Purchase 16 Sale 28 Sale Hats Purchase 14 Sale 25 Purchase 144.00 4.50 15400 154.00 1.690 57,650 28.850 27.200 45,000 32.000 8.000 28.000 36.50 154.00 4,188.00 4,152.000 4,925.000 87.00 154.00 4,312.000 Required: 1. Record the inventory, purchases, and cost of goods 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. Round all total cost amounts to the nearest dollar. Midnight Supplies Schedule of Cost of Goods Sold Weighted Average Cost Method For the Three Months Ended March 31 Cost of Goods Sold Unit Cest Purchases Unit Cost Date Inventory Unit Com Quantity Total Cost Quantity Total Cost Quantity Total Cout An. 1 n. 10 5 n. 30 Feb 10 reb. 16 Feb 28 Mar. 14 Mar. 25 Mar 31 Bances 2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period. Total cost of goods sold 3. Determine the ending inventory cost as of March 31. Please answer correctly so I may check my work