please inlcude full answer WITH the numbers

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: $ Advertising Expense Depreciation, factory equipment Depreciation, office equipment Direct labor Indirect labor Maintenance, factory equipment Purchases of direct materials (net) Rent, factory building Sales commissions 3 Supplies, factory 1 Utilities, factory 99,000 33,000 77,000 88,000 59,950 22,000 136,400 77,000 33,000 1,650 8,800 I $ 3 Inventories: 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 30.25 94.92 17.10 5.83 3.19 231 126,000 55,000 78,750 1 o Units produced and sold 10,000