does anyone know what type of excel tool I can use to calculate sales and cogs with this information?

EE LOTT Formatting Table Styles Paste B 1 H9 0 1 x fx 2640 M N 1 re 1 2 3 5,523 PS> M 5 4.406 7 442 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 #1 SP / Unit COGS/Unit MMA SP / Unit COGS/Unit Product Unit COGS/Unit $ SOS 15 Gold $ 28 Product 1 5 2,911 1.747 $ RSS 27 Silver $ 49 22 Product 2 $ 9,689 $ 175 firone $ 3$ 18 Product $ 6,1675 4.502 5 330 $ 09 Copper $ 365 16 Product 5 5,130 2,719 $ 1,000 5 410 Brass $ 36 S 14 Products $ 5.50 $ Sapphire $ 325 16 Product $ 1,315 5 579 Ruby $ 305 17 Product 7 1,802 S 1,19 Emerald $ 28 S 16 Products 264015 1,716 $ 27 $ 10 Products 9,7765 5,866 Jade 5 26 $ 11 Product 10$ 4,570 S 3,016 Amethyst $ 26 S 13 Product 115 3,286 2,267 Garnet $ 25$ 11 Product 12 S 9,894 7,816 Aquamarines 22 5 9 Product 13 S 2.795 S 1,286 Peridot 5 19 $ 7 Product 14 $ 7,488 5,766 Tanzanite $ 1$ 9 Product 155 3,443 $ 2,479 Opal $ 16 5 5 Product 16 7025 Moonstone 5 15$ S Product 17$ 3,995 1,918 Jasper $ 145 5 Product 18$ 8.5755 5831 Citrine $ 11$ Product 19 $ 4,264 $ 3,155 Quote $ 105 3 Product 20 $ 9,3045 6,234 Product 215 4,537 S 2.813 Product 22 2,7655 2.018 Product 235 9.843 6,103 Product 24 $ 4,8355 1.982 Product 25 4,351 3,307 Product 26 $ 5,791 $ 3.533 Product 275 5.4095 3,786 Product 285 8285 571 Product 29 $ 9,3425 4.110 Product 305 9,3535 5,051 Product 315 8.54) S 5.00 Product 325 8.4515 6,507 Product 33 5 5,860 3,361 Product 34 S 6,556 4.524 Product 35$ 7.1615 5.084 Product 365 2,300 $ 1.656 Product 375 6,968 5 4041 Product 3 S 214 $ 146 Carlow Instructions 2020 Data 2021 Data Shipping Exp Reference 29 30 31 12 33 34 35 36 32 38 39 Sales & COGS Reference Formatting as abas nivel vfs 1 COGS 5 Pro 2 5 6 1 5 1 4 4 M SIZEL SX SES SIPES SZEL SES SEM S24 SIZES WILL SIS SI 21-5 120-5 2 5 4 2 3 2 5 4 4 1 . 1 4 1 1 6 1 1 GO 59 02 41 43 54 3 12 34 81 14 46 69 90 53 61 AT 50 70 41 AS 95 25 > 93 99 91 C D Da Salesperson camer Pro Mater 12/1/2018 CUST-028 PROO-101 MATL-Copper 12/01/2012 CUS1028 PROD-200 MATL-Motone 12/1 SPOR CUST-125 PROD-112 Matmerald 12/31 32 CUST-083 PADO-142 WATU 12/10 - 12 CUST10 PROD-131 MAT 12/11/2010 CUST-132 PROD-131 MATL- 12/11/2014 CUSTON PROD-137 MATL- 12/11 CUST-122 PROD-172 MAL- 12/01/2018 CUSTOT PROD 019 MATLAB 12/10/2D SP-23 CUST FROO 166 MATL-Peridot 12/02 SP1 CUST-043 PROD 135 MATL Amethyst 1200 CUSTOS PROD-135 MATLAT 12/10/20 SP.13 CUSTOS PRODOS MAT-Puty 12/30/2015 CUST-121 PROD-022 MATL- 12/10/2015 CUST.110 PROD-024 Made 12/10 SP.OG CUST-100 YROO-133 MATIC 12/30/30 -17 CUST-02) PROD-168 MATL Tanzanite 12/20/20 SP-12 CUST-054 PROD 100 MAILS 12/30/20 19 CUSTOMS PROD-021 MATL T 12/30/20 SPOL CUS1114 PRO-132 MATM 12/30/2016 CUST.114 -PROD OG MATI-God 12/30/20 SPOR CUST-047 FROD-123 MALA 12/30/20 -24 CUST-063 PROD-173 MATL-Curie 12/30/10 CST 011 PROO-051 MATLS 120/20 DE CUST-071 PROD-142 MATLO 120 00 CUST 133 PROD-100 MATL Car 12/01 CUST-125 PROD 194 MAL 12/10/20 Sos CUST-091 PROD-031 MAL- 12/30/2020 CUSTO PROO-OS7 MAT! nono SP 22 CUSTO PROO 151 MATL-by 12/ono 15 CUSTOL PRODIS MAT by 12/29120 SP CUST-130 PROO 059 MATI Shite 12/29/2001 CUSTOD PRODOT2 MAT Shire 12/2011 CUST-065 FROO 051 MALI 12/29/20 SP-14 CUSTO PROO-156 MTL Aquine 12/29/2005 CUST.020 FROO MAL-Emerald CIL PROD-017 MAT by Warehousing MA- MLA 59 ME) WA MSA-3 MSA 44 MART MESA 61 MSA 4 MAD MAS MSA 54 MSA MSA-2 MATO MIA MSA.33 MA74 MSA 11 MA 44 MA.CO MAS SAMO USAS MA 11 MA14 MIA 74 MASS MIA 34 3 2 1 4 SIZES M BLOOKUP LOCS Location Locations Location Lord Locations Location Location Locations Location Location Location Lond Location Location Location Location Location Location LOC Locations Location Locations Local Cacations Lorent Lars Locron catent Location Location Law Location Location Locations Location LORE Location LO Lace Location co Location Location La Lint Land Location LO Location Location Lot Land L Location Lot Lot Location Location Lou Location La Location Location Loco La 3 4 5 5 5 3 1 2 . 1 3 1 . 4 5 5 5. 5 2 2 2 4 6 5 1 1 1 4 WES M SEM SEL 1 1 6 0 3 4 1 9 21 1 SEKS SIZE SEL . 5 MO 1 1 1 SEL SES SU 2 35 S6 90 2 17 SI 52 53 VES MSA MA VSA MAS MA1 MI 1 1 1 3 1 2 SEX WERS 4) Calculate Sales and COGS for each sales transaction. To calculate Sales: [units (Size SP/unit) units (Material SP/unit)] + [#units (Product SP/unit)). COGS = [#units Size COGS/unit)] . (Hunits (Material COGS/unit)] + [units (Product COGS/unit). Hint: Before you can perform this calculation, you will need to use text manipulation formulas to match different kinds of data (e,"PROD-001" vs "Product 1"). Then you can use reference or other formulas to retrieve the data for the calculations. As always, you should make sure to show all of your work to the extent that I can verify the methods that you used and preferably you should use formulas and systematic approaches (L.e., avoiding manually-typed text and judgment). Using helper columns is acceptable and heavily encouraged. Good luck! Mint Data EE LOTT Formatting Table Styles Paste B 1 H9 0 1 x fx 2640 M N 1 re 1 2 3 5,523 PS> M 5 4.406 7 442 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 #1 SP / Unit COGS/Unit MMA SP / Unit COGS/Unit Product Unit COGS/Unit $ SOS 15 Gold $ 28 Product 1 5 2,911 1.747 $ RSS 27 Silver $ 49 22 Product 2 $ 9,689 $ 175 firone $ 3$ 18 Product $ 6,1675 4.502 5 330 $ 09 Copper $ 365 16 Product 5 5,130 2,719 $ 1,000 5 410 Brass $ 36 S 14 Products $ 5.50 $ Sapphire $ 325 16 Product $ 1,315 5 579 Ruby $ 305 17 Product 7 1,802 S 1,19 Emerald $ 28 S 16 Products 264015 1,716 $ 27 $ 10 Products 9,7765 5,866 Jade 5 26 $ 11 Product 10$ 4,570 S 3,016 Amethyst $ 26 S 13 Product 115 3,286 2,267 Garnet $ 25$ 11 Product 12 S 9,894 7,816 Aquamarines 22 5 9 Product 13 S 2.795 S 1,286 Peridot 5 19 $ 7 Product 14 $ 7,488 5,766 Tanzanite $ 1$ 9 Product 155 3,443 $ 2,479 Opal $ 16 5 5 Product 16 7025 Moonstone 5 15$ S Product 17$ 3,995 1,918 Jasper $ 145 5 Product 18$ 8.5755 5831 Citrine $ 11$ Product 19 $ 4,264 $ 3,155 Quote $ 105 3 Product 20 $ 9,3045 6,234 Product 215 4,537 S 2.813 Product 22 2,7655 2.018 Product 235 9.843 6,103 Product 24 $ 4,8355 1.982 Product 25 4,351 3,307 Product 26 $ 5,791 $ 3.533 Product 275 5.4095 3,786 Product 285 8285 571 Product 29 $ 9,3425 4.110 Product 305 9,3535 5,051 Product 315 8.54) S 5.00 Product 325 8.4515 6,507 Product 33 5 5,860 3,361 Product 34 S 6,556 4.524 Product 35$ 7.1615 5.084 Product 365 2,300 $ 1.656 Product 375 6,968 5 4041 Product 3 S 214 $ 146 Carlow Instructions 2020 Data 2021 Data Shipping Exp Reference 29 30 31 12 33 34 35 36 32 38 39 Sales & COGS Reference Formatting as abas nivel vfs 1 COGS 5 Pro 2 5 6 1 5 1 4 4 M SIZEL SX SES SIPES SZEL SES SEM S24 SIZES WILL SIS SI 21-5 120-5 2 5 4 2 3 2 5 4 4 1 . 1 4 1 1 6 1 1 GO 59 02 41 43 54 3 12 34 81 14 46 69 90 53 61 AT 50 70 41 AS 95 25 > 93 99 91 C D Da Salesperson camer Pro Mater 12/1/2018 CUST-028 PROO-101 MATL-Copper 12/01/2012 CUS1028 PROD-200 MATL-Motone 12/1 SPOR CUST-125 PROD-112 Matmerald 12/31 32 CUST-083 PADO-142 WATU 12/10 - 12 CUST10 PROD-131 MAT 12/11/2010 CUST-132 PROD-131 MATL- 12/11/2014 CUSTON PROD-137 MATL- 12/11 CUST-122 PROD-172 MAL- 12/01/2018 CUSTOT PROD 019 MATLAB 12/10/2D SP-23 CUST FROO 166 MATL-Peridot 12/02 SP1 CUST-043 PROD 135 MATL Amethyst 1200 CUSTOS PROD-135 MATLAT 12/10/20 SP.13 CUSTOS PRODOS MAT-Puty 12/30/2015 CUST-121 PROD-022 MATL- 12/10/2015 CUST.110 PROD-024 Made 12/10 SP.OG CUST-100 YROO-133 MATIC 12/30/30 -17 CUST-02) PROD-168 MATL Tanzanite 12/20/20 SP-12 CUST-054 PROD 100 MAILS 12/30/20 19 CUSTOMS PROD-021 MATL T 12/30/20 SPOL CUS1114 PRO-132 MATM 12/30/2016 CUST.114 -PROD OG MATI-God 12/30/20 SPOR CUST-047 FROD-123 MALA 12/30/20 -24 CUST-063 PROD-173 MATL-Curie 12/30/10 CST 011 PROO-051 MATLS 120/20 DE CUST-071 PROD-142 MATLO 120 00 CUST 133 PROD-100 MATL Car 12/01 CUST-125 PROD 194 MAL 12/10/20 Sos CUST-091 PROD-031 MAL- 12/30/2020 CUSTO PROO-OS7 MAT! nono SP 22 CUSTO PROO 151 MATL-by 12/ono 15 CUSTOL PRODIS MAT by 12/29120 SP CUST-130 PROO 059 MATI Shite 12/29/2001 CUSTOD PRODOT2 MAT Shire 12/2011 CUST-065 FROO 051 MALI 12/29/20 SP-14 CUSTO PROO-156 MTL Aquine 12/29/2005 CUST.020 FROO MAL-Emerald CIL PROD-017 MAT by Warehousing MA- MLA 59 ME) WA MSA-3 MSA 44 MART MESA 61 MSA 4 MAD MAS MSA 54 MSA MSA-2 MATO MIA MSA.33 MA74 MSA 11 MA 44 MA.CO MAS SAMO USAS MA 11 MA14 MIA 74 MASS MIA 34 3 2 1 4 SIZES M BLOOKUP LOCS Location Locations Location Lord Locations Location Location Locations Location Location Location Lond Location Location Location Location Location Location LOC Locations Location Locations Local Cacations Lorent Lars Locron catent Location Location Law Location Location Locations Location LORE Location LO Lace Location co Location Location La Lint Land Location LO Location Location Lot Land L Location Lot Lot Location Location Lou Location La Location Location Loco La 3 4 5 5 5 3 1 2 . 1 3 1 . 4 5 5 5. 5 2 2 2 4 6 5 1 1 1 4 WES M SEM SEL 1 1 6 0 3 4 1 9 21 1 SEKS SIZE SEL . 5 MO 1 1 1 SEL SES SU 2 35 S6 90 2 17 SI 52 53 VES MSA MA VSA MAS MA1 MI 1 1 1 3 1 2 SEX WERS 4) Calculate Sales and COGS for each sales transaction. To calculate Sales: [units (Size SP/unit) units (Material SP/unit)] + [#units (Product SP/unit)). COGS = [#units Size COGS/unit)] . (Hunits (Material COGS/unit)] + [units (Product COGS/unit). Hint: Before you can perform this calculation, you will need to use text manipulation formulas to match different kinds of data (e,"PROD-001" vs "Product 1"). Then you can use reference or other formulas to retrieve the data for the calculations. As always, you should make sure to show all of your work to the extent that I can verify the methods that you used and preferably you should use formulas and systematic approaches (L.e., avoiding manually-typed text and judgment). Using helper columns is acceptable and heavily encouraged. Good luck! Mint Data