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 Transaction of Units Per Unit Total Date Jan. 1 Inventory $74.00 7,800 23,400 10 Purchase 84.00 28 Sale 148.00 11,700 3,900 $577,200 1,965,600 1,731,600 577,200 230,880 4,857,840 30 Sale 148.00 Feb. 5 Sale 1,560 148.00 10 Purchase 56,160 86.50 16 Sale 28,080 158.00 28 Sale 26,520 158.00 Mar. 5 Purchase 46,800 88.50 4,436,640 4,190,160 4,141,800 4,929,600 694,200 4,313,400 14 Sale 31,200 158.00 25 Purchase 89.00 7,800 27,300 30 Sale 158.00 Required: COM Required: 1. Record the inventory, purchases, and cost of goods sold data in perpetual entory within the chiedere method istimal places, freca to the nearest dollar Midnight Supplies Schedule of Cost of Goode Sald Weighted Average Cout Method For the Three Month Ended Warch 31 Purchases Cest of de Sold Inventory Date Quantity Unit Cost Total Cost Quantity Unit Cost Total Coat Unit Cast Total Coel Jan 1 Jan 10 an 28 lano Trebs Feb 10 Pet 16 Hart Mar 25 30 Mat30 Balance 2. Determine the other coat of you, and the worse for the period Totales Total cost of goods Gross pro Determine the entry son Mar. 25 Mar. 30 Mar. 31 Balances 2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period. Total sales Total cost of goods sold Gross profit 3. Determine the ending inventory cost as of March 31