please do both parts to this one question. do it in excel not hand written. thanks!

Required information Dell-Ray, a manufcaturing entity, has the following account balances: Sales Raw materials inventory, beginning Work in process inventory, beginning Finished goods inventory, beginning Raw materials purchases Direct labor Factory supplies used (indirect materials) Indirect labor Repairs-Factory equipment Rent cost of factory building Advertising expense General and administrative expenses Raw materials inventory, ending Work in process inventory, ending Finished goods inventory, ending $ 1,277,000 40,000 53,100 66,300 185,000 246,000 21,400 46,000 5, 250 55,000 110,000 142,000 43,900 45,900 68,200 Above, you have been provided financial information for the company. Based on this data, prepare its schedule of cost of goods manufactured for the year. DELRAY MFG Schedule of Cost of Goods Manufactured For Year Ended December 31, Year 1 Direct materials Raw materials available for use 0 Direct materials used $ 0 Factory overhead: Total factory overhead costs Total manufacturing costs 0 0 Total cost of work in process 0 Cost of good manufactured $ 0 Above, you have been provided financial Information for the manufacturing company Dell-Ray. Based on this data, prepare its income statement for the year for the year. DELRAY MFG Income Statement For Year Ended December 31, Year 1 Cost of goods sold Cost of goods available for sale Cost of goods sold 0 Operating expenses Total operating expenses Operating income 0 $ 0