Please help with the additional question on the bottom as well. Thank you very much

The flovingae akeon t reod o Casion Company for he Beal e de n .017 8,000 Factory Machinery Depreciation 39,600Factory Utilities 96,000 Office Utilities Expense 75,900Sales Revenue 19,800 Sales Discounts 18,600Plant Manager's Salary 139,250 Factory Property Taxes 24,460 Factory Repairs 27,000Raw Materials Purchases $16,000 27,600 8,650 534,000 4,200 58,000 9,600 1,400 96,400 32,000 $4 Raw Materials Inventory,7/1/16 Raw Materials Inventory, 6/30/17 Finished Goods Inventory, 7/1/16 Finished Goods Inventory, 6/30/17 Work in Process Inventory, 7/1/16 Work in Process Inventory, 6/30/17 Direct Labor Indirect Labor Accounts Receivable Factory Insurance 10 13 14 15 16 Instructions 17 (a) Prepare a cost of goods manufactured schedule. (Assume all raw materials used were direct materials.) 18 (b) Prepare an income statement through gross profit. 19 (c) Prepare the current assets section of the balance sheet at June 30, 2017 20 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a"?". 21 4,600 Cash 23 24 (a) Prepare a cost of goods manufactured schedule. (Assume all raw materials used were direct materials) 25 26 CLARKSON COMPANY Cost of Goods Manufactured Schedule For the Year Ended June 30, 2017 28 Work in process inventory, July 1, 2016 Direct materials Value 31 Raw materials inventory, July 1, 2016 Raw materials purchases Total raw materials available for use Less: Raw materials inventory, June 30,2017 Direct materials useod Valuc Value 34 35 36 37 Value Direct labor Manufacturing overhead Value Plant manager's salary Factory utilities Indirect labor Factory machinery depreciation Factory property taxes Factory insurance Value Value Value Value Value Value 41 43