Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are as follows: Date Transaction Total Number of Units 7,400 22,200 Jan. 1 Inventory $532,800 Per Unit $72.00 82.00 144.00 1,820,400 10 28 Purchase Sale 11,100 1,598,400 3,700 144.00 532,800 30 Feb. 5 Sale Sale 1,480 144.00 213,120 10 Purchase 53,280 84.50 16 28 Sale Sale Mar. 5 Purchase 26,640 25,160 44,400 29,600 7,400 25,900 154.00 154.00 86.50 154.00 87.00 154.00 4,502,160 4,102,560 3,874,640 3,840,600 4,558,400 643,800 3,988,600 14 Sale 25 30 Purchase Sale Required: 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrat unit cost to two decimal places, if necessary. Round all total cost amounts to the nearest dollar. Check My Work ebook Calculator For the Three Months Ended March 31 Cost of Goods Sold Quantity Unit Cost te Purchases Unit Cost Quantity Total Cost Total Cost Quantity Inventory Unit Cost 72.00 72 x Total Co 532,80 82.00 $ 7,400 7,400 x 18,500 1,820,400 11,100 3,700 1,480 53,280 84.50 4,502,160 26,640 44,400 86.50 3,840,600 29,600 87.00 643,800 25,900 mine the total sales, the total cost of goods sold, and the gross profit from sales for the period. olds in the ending inventory costs of March 31