please Answer the question in an EXCEL format

- Exercise 2-29 Schedules of Cost of Goods Manufactured and Sold; Income Statement ( LO 2-1, 2-3, 2-6) Alecadria Aluminum Compary, a manufacturer of recyelable soda cans, had the folowing inverrocy balances at the beginting and end of 20x1. Sales reveme was $1,105,000 for the year. Selling and administatine evenemes for the year anouated to $110.000. The firm's tax rate is 40 percent. Requlred: 1. Prepare a schiofule of cost of goods manufictured. 2. Prepare a schediule of cost of goods sold. 3. Prepare an income statement. direct labor is $390,000 and utilites coss $35,000