The Company recorded the follow that by the conventory Use these in front of the quantity and alcool when the numbers are sted from inventory.Runt vrage couper witte two decal and total cost to the rest de QUHU Cont 51.000 2 10 2 Puch 15 1000 33 > Ahment Power con How contact 1 The Music Store carries a large inventory of guitars and other musical instruments Company records indicate the following for a particular line of guitars Date Item Quantity Unit Cost Apr 1 Balance 4 $1,060 6 Sale 8 Purchase 10 982 17 Sale 30 Purchase 5 982 2 4 Required Assume that the store uses the moving weighted average cost method. Prepare The Music Store's perpetual inventory record for the guitars on the moving weighted average cost basis Round average cost per unit to the nearest cent and all other amounts to the nearest dollar UI First, make an inventory schedule and enter each purchase and sale. Start by entering the opening balance of inventory Be sure to calculate the balance after each transaction (Use parentheses or a minus sign in front of the quantity and the total cost when those numbers are subtracted from inventory. Round average cost per unit to two decimals (X.XX) and total cost to the nearest dollar.) Date Unit Cost Total Cost Quantity 4 Apr 1060 4240 6 -2 1060 -2120 Bal 1060 Lord 2120 9820 8 10 982 Bal 12 Bal End Inv Now determine the cost of goods sold Enter the transactions in chronological order Date Quantity Unit Cost Total Cost \Apr Total