I need help in this question, please do it in word, do not solve it as picture. Please do it correctly

Modern Dcor Furniture began June with a merchandise inventory of 60 sofas that cost a total of $600,000. During the month, Modern Dcor purchased and sold merchandise on account as follows: Prepare a perpetual inventory record, using the average cost method, and determine the company's cost of goods sold, ending merchandise inventory, and gross profit