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 $ 108,000 Depreciation, factory equipment 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 $ 9,600 ! Utilities, factory Inventories: Direct materials Work in Process Finished Goods January 1 December 31 is $ 9,900 $ 12,100 6,600 23,100 es $ 75,900 $ 26,400