Can you please show me how to solve the following question. Thank you

Required information The following information applies to the questions displayed below./ The following data is provided for Garcon Company and Pepper Company. Garcon Company $ 12,900 18,300 7,400 33,750 20,000 21,650 27,700 6,000 13,800 10,600 27,000 1,750 5,660 38,000 51,600 195,030 25,000 222,500 16,600 Pepper Company $ 19,150 20,100 13,350 22,750 35,800 15,300 19,000 9,400 14,250 4,900 52,000 8,500 2,000 58,000 56,800 290,010 23,700 160,825 20,700 Beginning finished goods inventory Beginning work in process inventory Beginning raw materials inventory Rental cost on factory equipment Direct labor Ending finished goods inventory Ending work in process inventory Ending raw materials inventory Factory utilities Factory supplies used General and administrative expenses Indirect labor Repairs-Factory quipment Raw materials purchases Selling expenses Sales Cash Factory equipment, net Accounts receivable, net Required 1. Complete the table to find the cost of goods manufactured for both Garcon Company and Pepper Company for the year ended December 31, 2017. 2. Complete the table to calculate the cost of goods sold for both Garcon Company and Pepper Company for the year ended December 31, 2017 Complete this question by entering your answers in the tabs below. Required 1Required 2 Complete the table to find the cost of goods manufactured for both Garcon Company and Pepper Company for the year ended December 31, 2017. Garcon Company Pepper Company Direct materials Raw materials available for use Direct materials used Factory overhead Total factory overhead Total manufacturing costs Total cost of work in process Total cost of work in process Cost of goods manufactured Required 1 Required 2 Complete the table to calculate the cost of goods sold for both Garcon Company and Pepper Company for the year ended December 31, 2017 Garcon Company Company Pepper Cost of goods available for sale Cost of goods sold