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: Number Date Transaction of Units Per Unit Total $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 4,200,000 Jan. 1 Inventory 7,500 $75.00 85.00 11,250150.00 3,750150.00 1,500150.00 87.50 27,000 160.00 25,500 160.00 89.50 30,000 160.00 90.00 26,250 160.00 22,500 10 Purchase 28 Sale 30 Sale Feb. 5 Sale 54,000 10 Purchase 16 Salee 28 Sale Mar. 5 Purchase 45,000 14 Sale 25 Purchase 30 Sale 7,500 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 weighte average cost method. Round unit cost to two decimal places, if necessary. Round all total cost amounts to the nearest dollar