QUESTION 2 The following data have been taken from the accounting records of Jimbob Co. for the year ended December 31,2021. Deprem Factory Building 300,000 10,000 Depciation Pactory Holding 50,000 Depreciation Sales Department autonobirs 10,000 Danet Wages Factory 200,000 Dunct Benefits Factory Employers 30,000 Factory Manager's Salary and Benefits 50,000 Finished Goods Investory Beginning 20.000 Finished Goods Investory, Ending 30,000 Head Office Salaries and Brerlits Oder Administrative Expenses 50,000 Other Manufacturing Overhead Expenses 40,000 Other Selling Expenses 30.000 Raw Materials Inventory, Begining 10,000 Raw Materials Enleg 15,000 Raw Material Pechased 200,000 Sales Department Salanes and Commissions 150,000 Sales Revenue 1.200.000 Tility Cost Factory 50,000 Utibly Costs Sales Office 20.000 Work in Process Inventory, Begming 100,000 Work in Process eventory Ending 110,000 For the toolbar pres: ALT+F10 (PC) or ALT+F-F10 (M Required: a Prepare a Schedule of Cost of Goods Manufactured in good form b. Compute the Cost of Goods Sold Using data from your answers above as needed, purpare an Income Statement in good form Please answer each question in a blank Excel workbook using only on 1 sheet pisses destly identify each question .. Question 1 and then immediately below Question 2. Attach Excel Workbook to my email "vide@niscaracollege.co.address.a end. You can not enter you answer in or through Blackboard!