Create a tornado chart for the original unit sales we would


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 by 0.2 (0, 0.2, 0.4, …1.8, 2.0) A = Advertising ($) If you are told that SF = 1.0 find the following. (a) What is the amount of Advertising that is needed to get Q = 10,000 units (b) If you are told that SF = 1.8, for all levels of Advertising from 0 -$25,000 in increments of $2000, 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 (by 0.2) and A = 5,000 – 25,000 in increments of $5000.

Request for Solution File

Ask an Expert for Answer!!
Financial Management: Create a tornado chart for the original unit sales we would
Reference No:- TGS02374699

Expected delivery within 24 Hours