make a schedule of cost of goods manufactured a manufacturing income statement

Cost of Goods Manufactured Data :

Direct labor 173000

Depreciation 20800

Purchases of direct material 351200

Beginning work-in-process 80700

Ending direct materials 65800

Indirect materials 20000

Plant utilities, insurance and Property taxes 20300

Ending work-in-process 27400

Beginning direct materials 70100

Indirect labor 34000

Manufacturing Income Statement Data

Net sales revenue 1004000

Income taxes 5500

Beginning finished goods 1000

Supplies expense 6200

Ending finished goods inventory 91700

Cost of goods manufactured 661500

Wage expense 120500

Depreciation expense 9000

Rent expense 100100

Insurance expense 10300