make sure you have right answer and give me some clean work please

Huids commerit Share PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing D2 V : X V fx A B D E F G H 1 K L M N O 3. 4 TOTAL SCORE: #N/A 5 DATA 1: 6 7 NOTE: THE DATA WILL SAY "#N/A" UNTIL YOU ENTER YOUR ATTENDANCE NUMBER IN CELL D2. EACH STUDENT IS ASSIGNED SLIGHTLY DIFFERENT SETS OF DATA. 8 9 10 11 12 13 Beginning Raw Materials Inventory 1/1 Ending Raw Materials 12/31 Raw Material Purchases Direct Labor Cost Factory Overhead Beginning Work in Process 1/1 Ending Work in Process 12/31 Beginning Finished Goods 1/1 Ending Finished Goods 12/31 Sales Operating Expenses Income Tax Rate #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 40% 14 15 16 17 18 19 CK 20 #N/A 21 #N/A 22 #N/A 23 #N/A 24 #N/A 25. #N/A 26 #N/A 27 #N/A 28 #N/A 29 #N/A 30 31 32 33 34 35 36 EX1 COMPUTE THE FOLLOWING ITEMS; SEE HINTS! If your answer matches mine, a 1 will appear in the CK column. 1 Direct Materials Used Beg. Raw Mt/s + Raw Mtl Purchases - Ending Raw Mtls 2 Total Manufacturing Costs Incurred Direct Materials + Direct Labor + Factory Overhead 3 Total Manufacturing Costs Total Mfg Costs Incurred + Beg. Work in Process 4 Cost of Goods Manufactured Total Mfg Costs - Ending Work in Process 5 Cost of Goods Sold Beg. Finished Goods + COGM - Ending Finished Goods 6 Gross Profit Sales - Cost of Goods Sold 7 Earnings Before Taxes Gross Profit - Operating Expenses 8 Income Tax Amount Earnings Before Taxes * D16 9 Net Income Earnings Before Taxes - Income Tax Amount PUT ALL ANSWERS (OR FORMULAS) IN THE GREEN SECTIONS. THANKS! EXCEL: = D6 +D8 - D7 Don't forget the = sign! EXCEL: = D20 + D9 +D10 EXCEL: = D21 +D11 EXCEL: - D22-D12 EXCEL: = D13 + D23-D14 EXCEL: = D15 - D24 EXCEL: = D25-D16 EXCEL: = D26 * D17 EXCEL: = D26 - D27 OK, TRY THE PROBLEM AGAIN USING THE BLUE DATA. DATA 2: Beginning Raw Materials Inventory 1/1 Ending Raw Materials 12/31 Raw Material Purchases Direct Labor Cost Factory Overhead ----I. :- COGM-Problem #N/A #N/A #N/A #N/A #N/A MALA 100% 10:56 PM 2/24/2022 Ready HE TED VIEW Be carefultiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing x D E F G H 1 K L M N D #N/A OK, TRY THE PROBLEM AGAIN USING THE BLUE DATA. #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 40% PUT YOUR ANSWERS OR FORMULAS FOR EXERCISE 2 IN THE BLUE SECTION. 2. V : x x A B C DATA 2: Beginning Raw Materials Inventory 1/1 Ending Raw Materials 12/31 1 Raw Material Purchases Direct Labor Cost 5 Factory Overhead 7 Beginning Work in Process 1/1 3 Ending Work in Process 12/31 Beginning Finished Goods 1/1 Ending Finished Goods 12/31 1 Sales 2 Operating Expenses 3 Income Tax Rate 4 5 CK 6 #N/A 1 Direct Materials Used -7 #N/A 2 Total Manufacturing Costs Incurred 8 #N/A 3 Total Manufacturing Costs 19 #N/A 4 Cost of Goods Manufactured 50 #N/A 5 Cost of Goods Sold 51 #N/A 6 Gross Profit 52 #N/A 7 Earnings Before Taxes 53. #N/A 8 Income Tax Amount 54 #N/A 9 Net Income 55 #N/A 56 57 58 DATA 3: 59 Beginning Raw Materials Inventory 1/1 60 Ending Raw Materials 12/31 61 Raw Material Purchases 62 Direct Labor Cost Factory Overhead . OK, TRY THE PROBLEM AGAIN USING THE ORANGE DATA. #N/A #N/A #N/A #N/A #N/A #N/A 100% Page Layout Formulas Data Review View Help PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Comments Share Enable Editing D2 & XV fx X B D E F G H 1 J K L M N o P CA 4 Cost of Goods Manufactured 5 Cost of Goods Sold 6 Gross Profit 7 Earnings Before Taxes 8 Income Tax Amount 9 Net Income A 49 #N/A 50 #N/A 51 #N/A 52 #N/A 53 #N/A 54 #N/A 55 #N/A 56 57 58 59 60 61 62 63 DATA 3: 64 Beginning Raw Materials Inventory 1/1 Ending Raw Materials 12/31 Raw Material Purchases Direct Labor Cost Factory Overhead Beginning Work in Process 1/1 Ending Work in Process 12/31 Beginning Finished Goods 1/1 Ending Finished Goods 12/31 Sales Operating Expenses Income Tax Rate #N/A OK, TRY THE PROBLEM AGAIN USING THE ORANGE DATA. #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 40% 65 66 67 PUT YOUR ANSWERS OR FORMULAS FOR EXERCISE 3 IN THE ORANGE SECTION. 68 69 70 71. 72 CK 73 #N/A 74 #N/A 75 #N/A 76 #N/A 77 #N/A 78 #N/A 79 #N/A 80 #N/A 81 #N/A 82 #N/A 1 Direct Materials Used 2 Total Manufacturing Costs incurred 3 Total Manufacturing Costs 4 Cost of Goods Manufactured 5 Cost of Goods Sold 6 Gross Profit 7 Earnings Before Taxes 8 Income Tax Amount 9 Net Income 10:57 PM 00) D 2124/2022 COGM-Problem Huids commerit Share PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing D2 V : X V fx A B D E F G H 1 K L M N O 3. 4 TOTAL SCORE: #N/A 5 DATA 1: 6 7 NOTE: THE DATA WILL SAY "#N/A" UNTIL YOU ENTER YOUR ATTENDANCE NUMBER IN CELL D2. EACH STUDENT IS ASSIGNED SLIGHTLY DIFFERENT SETS OF DATA. 8 9 10 11 12 13 Beginning Raw Materials Inventory 1/1 Ending Raw Materials 12/31 Raw Material Purchases Direct Labor Cost Factory Overhead Beginning Work in Process 1/1 Ending Work in Process 12/31 Beginning Finished Goods 1/1 Ending Finished Goods 12/31 Sales Operating Expenses Income Tax Rate #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 40% 14 15 16 17 18 19 CK 20 #N/A 21 #N/A 22 #N/A 23 #N/A 24 #N/A 25. #N/A 26 #N/A 27 #N/A 28 #N/A 29 #N/A 30 31 32 33 34 35 36 EX1 COMPUTE THE FOLLOWING ITEMS; SEE HINTS! If your answer matches mine, a 1 will appear in the CK column. 1 Direct Materials Used Beg. Raw Mt/s + Raw Mtl Purchases - Ending Raw Mtls 2 Total Manufacturing Costs Incurred Direct Materials + Direct Labor + Factory Overhead 3 Total Manufacturing Costs Total Mfg Costs Incurred + Beg. Work in Process 4 Cost of Goods Manufactured Total Mfg Costs - Ending Work in Process 5 Cost of Goods Sold Beg. Finished Goods + COGM - Ending Finished Goods 6 Gross Profit Sales - Cost of Goods Sold 7 Earnings Before Taxes Gross Profit - Operating Expenses 8 Income Tax Amount Earnings Before Taxes * D16 9 Net Income Earnings Before Taxes - Income Tax Amount PUT ALL ANSWERS (OR FORMULAS) IN THE GREEN SECTIONS. THANKS! EXCEL: = D6 +D8 - D7 Don't forget the = sign! EXCEL: = D20 + D9 +D10 EXCEL: = D21 +D11 EXCEL: - D22-D12 EXCEL: = D13 + D23-D14 EXCEL: = D15 - D24 EXCEL: = D25-D16 EXCEL: = D26 * D17 EXCEL: = D26 - D27 OK, TRY THE PROBLEM AGAIN USING THE BLUE DATA. DATA 2: Beginning Raw Materials Inventory 1/1 Ending Raw Materials 12/31 Raw Material Purchases Direct Labor Cost Factory Overhead ----I. :- COGM-Problem #N/A #N/A #N/A #N/A #N/A MALA 100% 10:56 PM 2/24/2022 Ready HE TED VIEW Be carefultiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing x D E F G H 1 K L M N D #N/A OK, TRY THE PROBLEM AGAIN USING THE BLUE DATA. #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 40% PUT YOUR ANSWERS OR FORMULAS FOR EXERCISE 2 IN THE BLUE SECTION. 2. V : x x A B C DATA 2: Beginning Raw Materials Inventory 1/1 Ending Raw Materials 12/31 1 Raw Material Purchases Direct Labor Cost 5 Factory Overhead 7 Beginning Work in Process 1/1 3 Ending Work in Process 12/31 Beginning Finished Goods 1/1 Ending Finished Goods 12/31 1 Sales 2 Operating Expenses 3 Income Tax Rate 4 5 CK 6 #N/A 1 Direct Materials Used -7 #N/A 2 Total Manufacturing Costs Incurred 8 #N/A 3 Total Manufacturing Costs 19 #N/A 4 Cost of Goods Manufactured 50 #N/A 5 Cost of Goods Sold 51 #N/A 6 Gross Profit 52 #N/A 7 Earnings Before Taxes 53. #N/A 8 Income Tax Amount 54 #N/A 9 Net Income 55 #N/A 56 57 58 DATA 3: 59 Beginning Raw Materials Inventory 1/1 60 Ending Raw Materials 12/31 61 Raw Material Purchases 62 Direct Labor Cost Factory Overhead . OK, TRY THE PROBLEM AGAIN USING THE ORANGE DATA. #N/A #N/A #N/A #N/A #N/A #N/A 100% Page Layout Formulas Data Review View Help PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Comments Share Enable Editing D2 & XV fx X B D E F G H 1 J K L M N o P CA 4 Cost of Goods Manufactured 5 Cost of Goods Sold 6 Gross Profit 7 Earnings Before Taxes 8 Income Tax Amount 9 Net Income A 49 #N/A 50 #N/A 51 #N/A 52 #N/A 53 #N/A 54 #N/A 55 #N/A 56 57 58 59 60 61 62 63 DATA 3: 64 Beginning Raw Materials Inventory 1/1 Ending Raw Materials 12/31 Raw Material Purchases Direct Labor Cost Factory Overhead Beginning Work in Process 1/1 Ending Work in Process 12/31 Beginning Finished Goods 1/1 Ending Finished Goods 12/31 Sales Operating Expenses Income Tax Rate #N/A OK, TRY THE PROBLEM AGAIN USING THE ORANGE DATA. #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 40% 65 66 67 PUT YOUR ANSWERS OR FORMULAS FOR EXERCISE 3 IN THE ORANGE SECTION. 68 69 70 71. 72 CK 73 #N/A 74 #N/A 75 #N/A 76 #N/A 77 #N/A 78 #N/A 79 #N/A 80 #N/A 81 #N/A 82 #N/A 1 Direct Materials Used 2 Total Manufacturing Costs incurred 3 Total Manufacturing Costs 4 Cost of Goods Manufactured 5 Cost of Goods Sold 6 Gross Profit 7 Earnings Before Taxes 8 Income Tax Amount 9 Net Income 10:57 PM 00) D 2124/2022 COGM