please give the right answer with some clean work

G18 V :X fx D E F G H K 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 A B 1 COST OF GOODS MANUFACTURED SCHEDULE 2 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 Indirect Labor was: Depreciation on Factory Equpment was: Factory Supplies and Utilities were: 24,000 10,000 10,000 =SUM(B16:118) =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./21/2000 Ending Warle in Dracce.mn 40,000 80,000 120,000 60,000 125,000 30,000 15,000 18,000 21000 32 33 34 25 4 Sheet1 100 Ready TOODE G H K 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 OF GOODS MANUFACTURED SCHEDULE 5 FOR YEAR ENDED 12/31/2020 5 7 Beginning Work in Process Inventory 3 Direct Materials: 2 Beginning Materials Inventory 1/1/2020 0 Materials Purchases 1 Cost of Materials Available 2 Less Materials Inventory 12/31/2020 3 Direct Materials Used 4 Direct Labor Cost 5 Factory Overhead: 6 Indirect Labor Cost 7 Depreciation on Factory Equipment 8 Factory Supplies and Utility Costs 9 Total Factory Overhead 20 Total Manufacturing Costs Incurred 21 Total Manufacturing Costs 2 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 83 34 =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 35 36