show working out in Excel form

4. Smooth Sounds manufactures and sells a new line of MP-3 players. Unfortunately, Smooth Sounds suffered serious fire damage at its home office. As a result, the accounting record for October were partially destroyed- and completely jumbled. Smooth Sounds has hired you to help figure out the missing pieces of the accounting puzzle. Work in process inventory, October 31. $1,500 Accounts payable, October 1... Finished goods inventory, October 1.... 4.300 Direct materials used in October Direct labour in October... 3,000 Accounts payable, October 31, Purchase of direct materials in October 9,000 Accounts receivable, October 31., Work in process inventory, October 1... Direct materials inventory, Oct. 31. Revenues in October... 27.000 Manufacturing Overhead in October.. Accounts receivable, October 1. 2,000 Gross profit in October 12,000 $3,000 8,000 5,200 6,500 3,000 6,300 0 ***** Required: Compute the following amounts i) Manufacturing costs Cost of goods manufactured in October iii) Cost of goods sold in October iv) Beginning direct materials inventory v Ending finished goods inventory