eBook Calculator 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 Jan. 1 Inventory 7,700 $78.00 $600,600 10 Purchase 23,100 88.00 2,032,800 28 Sale 11,550 156.00 1,801,800 30 Sale 3,850 156.00 600,600 Feb. 5 Sale 1,540 156.00 240,240 10 Purchase 55,440 90.50 5,017,320 16 Sale 27,720 166.00 4,601,520 28 Sale 26,180 166.00 4,345,880 Mar. 5 Purchase 46,200 92.50 4,273,500 14 Sale 30,800 166.00 5,112,800 25 Purchase 7,700 93.00 716,100 30 Sale 166.00 4,473,700 Required: 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit weighted average cost method. Round unit cost to two decimal places, if necessary. Round all total cost amounts to the nearest dollar. Midnight Supplies 26,950