Suppose you are told that your company’s sales take on the form: Unit Sales (Q) = 35*SF*(3000+A)0.5 SF = Seasonal Factor (decimal) à Takes on values from 0-2 in tenths (0, 0.1, 0.2, …1.8, 1.9, 2.0) A = Advertising ($) If you are told that SF = 1.4 find the following. (a) What is the amount of Advertising that is needed to get Q = 10,000 units WHAT-IF ANALYSIS – Goal seek S.F 1.4 A Q (b) (b) If you are told that SF = 1.4, for all levels of Advertising from 0 -$25,000 in increments of $1000, find the level of unit sales. Provide me a summary table of your results and also create a plot to illustrate your solutions. (c) Finally, create a tornado chart for the original unit sales we would see for SF = 1.0 to 2.0 and A = 5,000 – 25,000 in increments of $5000.