Hello, I kindly ask you to solve this problem 2-1 with Required questions a and b in excel. Thank you

70 Chapter 2 JOB-ORDERING COSTING AND MOL Required a. Prepare a schedule of cost of goods manufactured. b. Prepare an income statement for fiscal 2006. Ignore income taxes. PROBLEM(2-2) Cost of Goods Manufactured and Cost of Goods Sold Design Works International manufactures custom tiles. The following information relates to the fiscal year ending December 31, 2006. 20 PROBLEMS PROBLEM 2-1. Cost of Goods Manufactured, Cost of Goods Sold, and Income The following information is available for Costa's Custom Glass for the fiscal year end- ing December 31, 2006. Beginning balance in Work in Process $ 200,000 Ending balance in Work in Process 250,000 Beginning balance in Finished Goods 500,000 Ending balance in Finished Goods 400,000 Direct material cost 1,000,000 Direct labor cost 3,000,000 Manufacturing overhead 2,000,000 Selling expenses 300,000 General and administrative expenses 200,000 Sales 7,000,000