P1-5A Prepare a cost of goods manufactured schedule and a correct income statement Empire Company is a manufacturer of smart phones. Its controller resigned in October 2017 An inexperienced assistant accountant has prepared the following income statement for the month of October 2017 EMPIRE COMPANY income Statement For the Month Ended October 31, 2017 $780,000 Sales Revenue Less: Operating Expenses Raw materials purchases Direct labor costs Advertising expense Selling and administrative salaries factory facilities Depreciation on sales equipment Depreciation on factory equipment Indirect labor cost Utilities expense $264,000 190,000 90,000 75,000 60,000 45,000 31,000 28,000 12,000 8,000 nt on $803,000 ($23,000) Insurance expense Net loss Prior to October 2017, the company had been profitable every month. The company's president is concerned about the accuracy of the income statement. As her friend, you have been asked to review the income statement and make necessary corrections. After examining other manufacturing cost data, you have acquired additional information as follows. 1. Inventory balances at the beginning and end of October were: October 1 $18,000 20,000 30,000 October 31 $29,000 14,000 50,000 Raw materials Work in process Finished goods Only 75% of the utilities expense and 60% of the insurance expense apply to factory 2. operations. The remaining amounts should be charged to selling and administrative activities Instructions (a) Prepare a schedule of cost of goods manufactured for October 2017. (b) Prepare a correct income statement for October 2017. NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?" Prepare a schedule of cost of goods manufactured for October 2017 (a) EMPIRE COMPANY Cost of Goods Manufactured Schedule For the Month Ended October 31, 2017 Work in process inventory, October 1 Direct materials Value Raw materials inventory, October 1 Raw materials purchases Value Value Total raw materials available for use 7 Value Less: Raw materials inventory, October 31 Direct materials used Value Direct labor Manufacturing overhead Factory facility rent Depreciation on factory equipment Indirect labor Value Value Value Factory utilities Factory insurance Total manufacturing overhead 7 7 7 Total manufacturing costs Total cost of work in process Less: Work in process, October 31 Cost of goods manufactured 7 7 Value 7 (b) Prepare a correct income statement for October 2017. EMPIRE COMPANY Income Statement For the Month Ended October 31, 2017 Sales Revenue Cost of goods sold Finished goods inventory, October 1 Cost of goods manufactured Cost of goods available for sale Less: Finished goods inventory, October 31 Cost of goods sold Gross profit Operating expenses Advertising expense Selling and administrative salaries Depreciation expense-sales equipment Insurance expense Utilities expense Total operating expenses Value Value ? Value ? Value Value Value Net income After you have completed P1-5A, consider the additional question. 1. Assume that utilities expense and insurance expense changed to $15,000 and $9,000 respectively. Also assume that 80% of utilities expense and 65% of insurance expense apply to factory operations. Show the impact of these changes on the cost of goods manufactured schedule and the income statement