E 2 Scenario Sales of ShoeLily.com's products follow a peculiar, but predictable, pattern that determines how many units will sell in any given year. This pattern is shown below Unit Sales 1998 23 1999 2000 2001 2002 2003 2004 2005 2006 29 26 39 29 43 223 15 8 4 2 1 discontinued 20 26 22 28 14 7 4 2 65 33 36 45 23 12 58 87 44 48 60 37 52 56 28 31 28 42 21 19 29 24 21 49 68 78 95 123 176 181 164 179 Shoe Color 1995 1996 1997 D Red 28 42 21 Green White Brown 4 Yellow 5 Black 6 Orange Purple 8 Total 28 42 22 1 90T234567 28 50 Questions A) Which color will sell the most units in 2007? B) Which color will sell the most units combined in the 2007 to 2009 period? Please show all your analysis, leave formulas in cells, and specify any assumptions you make.