complete a schedule of cost of goods manufactured and a Manufacturing Company Income statement. Using July-August column only. thank you

Manufacturing Costs From the data in this file ACC 206 Final Paper CGS.xls, complete a Schedule of Cost of Goods Manufactured and a Manufacturing Company Income statement. Use the Cost of Goods Manufactured that was developed in the Schedule of Cost of Goods Statement in the income statement. (See pages 974 through 975 in the text) Use the column that corresponds to your course. For example, if your course stated May 22, you would use the data from the May-June column. Use the column based upon this course start date Jul-Aug 173000 May-Jun Mar-Apr 171000 Jan-Feb Cost of Goods Manufactured Data Direct labor Depreciation Purchases of direct material 172000 170000 20800 351200 20600 20400 20200 350900 350600 350300 80700 80525 80350 80175 Beginning work-in-process Ending direct materials Indirect materials 65600 65800 65200 65400 20000 19250 18500 17750 19725 20300 19150 18575 Plant utilities, insurance and Property taxes Ending work-in-process 27400 27300 27200 27100 70100 70075 70050 70025 Beginning direct materials 32500 34000 31000 29500 Indirect labor Manufacturing Income Statement Data. 1003000 1004000 1002000 Net sales revenue 1001000 55000 54000 54500 53500 Income taxes Beginning finished goods Supplies expense Ending finished goods inventory Cost of goods manufactured Wage expense Depreciation expense Rent expense Insurance expense 750 1000 250 500 5600 5900 6200 5300 61275 61700 60425 60850 660375 660750 661125 661500 120125 120250 120375 120500 6750 7500 8250 9000 100025 100050 100075 100100 10075 10150 10225 10300