^{Please Solve This Excel Worksheet and List your Formulas, and How you got your answers so that I can learn from what you did. Please take your time as I know this will take a while!}

K LM L B C D E F G H I J Use only a combination of text manipulation (i.e., MID, CONCATENATE, TRIM, etc.) and/or logical and conditional formulas (i.e., IF, AND, etc.) to populate the green cells below. Product Base Sales COGS Color Plus x #units Sales COGS Plus x #units Size Sales COGS 5 Product1.5000.500. Orange.5.2.XS.2.1 6 Product2.7500.1000.Blue.4.2.5.4.2 7 Product3.2500.200.Red.3.1.M.10.4 8 Product4.8000.2000.Pink.3.1.L.20.9 9 Product5.10000.1750.Grey.5.3.XL.30.16 10 Product6.1500.75. Green.3.1 11 Product7.4000.600.Yellow.7.3 12 Product8.8500,1750.Purple.9.4 13 Product9.11000.3500. Brown.8.4 14 Product10.9000.4000.White.6.3 15 Black.11.5 16 Tan.7.3 17 Teal.6.3 18 Maroon. 10.4 19 Olive.3.2