Preview File Edit View Go Tools Window Help Name: Instructor: P18-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 Date: Course: Sales Revenue $780,000 Less: Operating Expenses Raw materials purchases $264,000 Direct labor costs 190,000 Advertising expense 90,000 Selling and administrative salaries 75,000 Rent on factory facilities 60,000 Depreciation on sales equipment 45,000 Depreciation on factory equipment 31,000 Indirect labor cost 28,000 Utilities expense 12,000 Insurance expense 8,000 803,000 Net loss ($23,000) 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: 2. Raw materials Work in process Finished goods October 1 October 31 $18,000 $29,000 20,000 14,000 30,000 50,000 Only 75% of the utilities expense and 60% of the insurance expense apply to factory operations. The remaining amounts should be charged to selling and administrative activities. Instructions (a) (b) Prepare a schedule of cost of goods manufactured for October 2017. 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 "?". (a) Prepare a schedule of cost of goods manufactured for October 2017. 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 Value Raw materials purchases Value Total raw materials available for use ? Less: Raw materials inventory, October 31 Value Direct materials used ? Direct labor Value Manufacturing overhead Factory facility rent Value Depreciation on factory equipment Value Indirect labor Value Factory utilities Factory insurance ? ? Total manufacturing overhead ? Total manufacturing costs ? Total cost of work in process ? Value Less: Work in process, October 31 Cost of goods manufactured ? a Sun Nov 12 2:00 PM