Weighted Average Cost Method wth 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 Jan. 1 Inventory 7,500 $75.00 $562,500 10 Purchase 22,500 85.00 1.912,500 11,250 150.00 1.687,500 3,750 150.00 562,500 1.500 150.00225,000 10 Purchase 54,000 87.5 4.725,000 27,000 160.00 4.320,000 25.500 160.00 4.080,000 Mar. 5 Purchase 45,000 89.50 4.027,500 30,000 160.004,800.000 25 Purchase 7.500 90.00675,000 28 Sale 30 Sale Feb. 5 Sale 16 Sale 28 Sale 14 Sale 30 Sale 26.250 160.004.200.000 Required i. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the on"strated an Ech bit unit cost to two decimal places. if necessary. Round al total cost amounts to the nearest dellar Schedule of Cost of Goods Soled Weighted Average Cost Method For the Three Honths Ended March 31 / Goods Sold