Question 6 (33 marks) *this question must be completed in Excel. Prepare, in good format, a schedule of cost of goods manufactured and Statement of Comprehensive Income using the information below for the company, Consolidated Minerals Ltd., for the year ended December 31, 2019: Direct materials, January 1, 2019 Work in process, January 1, 2019 Finished goods, January 1, 2019 Direct materials, December 31, 2019 Work in process, December 31, 2019 Finished goods, December 31, 2019 Purchase of direct materials Direct Manufacturing labour Depreciation-plant, building and equipment Plant supervisory salaries Miscellaneous plant overhead $ Revenues $ Marketing, distribution and customer-service costs $ Plant supplies used Plant utilities Indirect manufacturing labour 35,000 110,000 265,000 8,000 250,000 280,000 8,500 83,000 55,000 102,000 99,000 525,000 43,000 22,000 75,500 39,000