The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month perlod are as follows: Number Date Transaction of Units Per Unit Total Jan. 1 Inventory 10 Purchase 28 Sale 30 Sale 7,500 $75.00 $562,500 22,500 85.00 1,912,500 11,250 150.00 1,687,500 3,750 150.00 562,500 1,500 150.00 54,000 87.50 4,725,000 27,000 160.00 4,320,000 25,500 160.004080,000o 45,000 89.50 4,027,500 30,000 160.00 4,800,000 7,500 90.00 26,250 160.00 4,200,000 225,000 10 Purchase 16 Sale 28 Sale Mar. 5 Purchase 14 Sale 25 Purchase 30 Sale 675,000 Required: Exhibit 5, using the 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in y. Round all total cost amounts to the nearest dollar Midnight Supplies Schedule of Cost of Goods Sold Check My Work Total Cost Jan. 10 Mar. 30