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: Advertising Expense Depreciation, factory equipment $ 108,000 36,000 Depreciation, office equipment 84,000 Direct labor 96,000 Indirect labor 54,500 Maintenance, factory equipment 20,000 Purchases of direct materials (net) 124,000 Rent, factory building 84,000 Sales commissions 36,000 ) Supplies, factory 1,800 Utilities, factory $ 9,600 1 Inventories: January 1 December 31 5 Direct materials $ 9,900 $ 12,100 5 Work in Process 6,600 23,100 Finished Goods $ 75,900 $ 26,400