please provide a solution as soon as possible

Creative Kaos 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. $960 1 Balance 6 Sale 8 Purchase 17 Sale 30 Purchase 4 2 10 4 5 888 888 Required Assume that the store uses the moving-weighted-average-cost method. Prepare Creative Kaos 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