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
Shoe Color	1995	1996	1997	1998	1999	2000	2001	2002	2003	2004	2005	2006
Red	92	149	75	86	109	56	30	15	8	8	discontinued
Green				41	66	34	39	50	25	12	7	4
White						140	227	115	135	168	86	45
Brown								68	110	56	65	81
Yellow									25	41	20	23
Black										44	71	36
Orange											38	62
Purple												24
Total	92	149	75	127	175	230	296	248	302	329	288	274
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.