Part 1: Use the information in Part 1 for ABC Company to complete a Cost of Goods Manufactured Statement and a Cost of Goods Sold Statement for the year ended 2021. All reports should be prepared in Excel with good form. The following cost and inventory data were taken from the records of the ABC Company for the year 2021: Costs incurred: Depreciation, factory equipment $30,000 Depreciation office equipment 7,000 Supplies, factory 1,500 Maintenance, factory equipment 20.0001 Utilities, factory 8,000 Sales commissions 30.000 Indirect labor 54,500 Rent, factory building 70.000 Purchases of direct materials (net) 124,000 Direct labor 80,000 Advertising expense 90,000 Inventories: Direct materials Work in process Finished goods January 1 December 31 $9,000 $11,000 6.000 21,000 69,000 24,000 Part 2: Use only the information in Part 2 to prepare a Contribution Margin Income Statement and a Gross Margin Income Statement for the month of July 2021. Assume the company produced and sold 10,000 units and there were no units in inventory on July 1, 2021. All reports should be prepared in Excel with good form. The cost accountant for the ABC Company has provided you with the following information for the month of July: Total Fixed Costs Direct labor Direct materials Manufacturing overhead Marketing costs Administrative costs Selling price Variable costs Per unit $27.50 84.75 14.25 5.30 2.90 210.00 $120,000 50,000 75.000 Submission method: Please include all of your reports in the same excel file