please make sure you provide the correct answer it is important question

C DE F G H COST OF GOODS MANUFACTURED SCHEDULE 2 3 KRAMER MANUFACTURING 4 COST OF GOODS MANUFACTURED SCHEDULE 5 FOR YEAR ENDED 12/31/2020 o toul to un GIVEN: Story: Kramer began with beginning work in process of FORMULAS 30,000 The company began with materials in the amount of: Materials purchased amounted to: 65,000 100,000 =B9+B10 The ending inventory was: 35,000 =B11-B12 The direct labor was: 130,000 Indirect Labor was: Depreciation on Factory Equpment was: Factory Supplies and Utilities were: 24,000 10,000 10,000 7 Beginning Work in Process Inventory 8 Direct Materials: 9 Beginning Materials Inventory 1/1/2020 Materials Purchases 11 Cost of Materials Available 12 Less Materials Inventory 12/31/2020 13 Direct Materials Used 14 Direct Labor Cost 15 Factory Overhead: 16 Indirect Labor Cost 17 Depreciation on Factory Equipment 18 Factory Supplies and Utility Costs 19 Total Factory Overhead 20 Total Manufacturing Costs Incurred 21 Total Manufacturing Costs 22 Less Work in Process Inventory 12/31/2020 23 Cost of Goods Manufactured 24 25 26 NELSON MANUFACTURING COMPANY 27 COST OF GOODS MANUFACTURED 28 FOR YEAR ENDED 12/31/2020 29 30 Using the amounts in the GIVEN section, can you create the COGM? 31 32 =SUM(B16:B18) =C13+C14+c19 =D7+D20 Ending Work in Process was: 24,000 - =D21-D22 GIVEN: 1/1/2020 Story: Nelson began with beginning work in process of The company began with materials in the amount of: Materials purchased amounted to: 12/31/2020 The ending inventory of materials was: The direct labor cost was: Indirect Labor cost was: Depreciation an Factory Equpment was: Factory Supplies and Utilities were: 12/21/22 Ending Worl in Dencocene: 40,000 80,000 120,000 60,000 125.000 30,000 15,000 18,000 21 33 34 C D F F G H i FORMULAS GIVEN: Story: Kramer began with beginning work in process of 30,000 The company began with materials in the amount of: Materials purchased amounted to: 65,000 100,000 =B9+B10 The ending inventory was: =B11-B12 35,000 The direct labor was: 130,000 3 KRAMER MANUFACTURING 4 COST OF GOODS MANUFACTURED SCHEDULE 5 FOR YEAR ENDED 12/31/2020 6 7 Beginning Work in Process Inventory 8 Direct Materials: 9 Beginning Materials Inventory 1/1/2020 10 Materials Purchases 11 Cost of Materials Available 12 Less Materials Inventory 12/31/2020 13 Direct Materials Used 14 Direct Labor Cost 15 Factory Overhead: 16 Indirect Labor Cost 17 Depreciation on Factory Equipment 18 Factory Supplies and Utility Costs 19 Total Factory Overhead 20 Total Manufacturing Costs Incurred 21 Total Manufacturing Costs 22 Less Work in Process Inventory 12/31/2020 23 Cost of Goods Manufactured 24 25 26 NELSON MANUFACTURING COMPANY 27 COST OF GOODS MANUFACTURED 28 FOR YEAR ENDED 12/31/2020 29 30 Using the amounts in the GIVEN section, can you create the COGM? 31 32 33 34 35 Indirect Labor was: Depreciation on Factory Equpment was: Factory Supplies and Utilities were: 24,000 10,000 10,000 =SUM(B16:B18) =C13+C14+c19 =D7+D20 Ending Work in Process was: 24,000 =D21-D22 GIVEN: 1/1/2020 Story: Nelson began with beginning work in process of The company began with materials in the amount of: Materials purchased amounted to: 12/31/2020 The ending inventory of materials was: The direct labor cost was: Indirect Labor cost was: Depreciation on Factory Equpment was: Factory Supplies and Utilities were: 12/31/2020 Ending Work in Process was: 40,000 80,000 120,000 60,000 125,000 30,000 15,000 18.000 34,000 26