he Music Store carries a large inventory of guitars and other musical instruments. Company records indicate the llowing for a particular line of guitars. Date Item Quantity Unit Cost 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.) Apr. $900 Date Quantity Unit Cost Total Cost 1 5 Apr. 900 1 Balance 6 Sale 8 Purchase 17 Sale 30 Purchase 4500 5 3 10 4 5 828 6 828 Bal. 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. Bal. Bal. End. Inv. Now, determine the cost of goods sold. Enter the transactions in chronological order. Date Quantity Unit Cost Total Cost Apr. II Total Time Remaining: 01:17:30 Next 1:42 PM B 181 59C 11 ENG