Please read allof the instructions carefully before completing. Part 1: Use the information in Part 1 for GEM Company to complete a Cost of Goods Manufactured Statement and a Cost of Goods Sold Statement for the year ended 2022. All reports should be prepared in Excel with good form. The following cost and inventory data were taken from the records of the GEM Company for the year 2022: Costs incurred: 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 2022. Assume the company produced and sold 15,000 units and there were no units in inventory on July 1, 2022. All reports should be prepared in Excel with good form. The cost accountant for the GEM Company has provided you with the following information for the month of July