Create tornado chart for the original unit sales

Assignment Help Operation Management

Reference no: EM131147220

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.

Reference no: EM131147220

Questions Cloud

Benefit for organizations to have motivated employees : Explain what motivation is and the benefit for organizations to have motivated employees. In addition, identify and describe the most valuable asset an organization has and how they keep them motivated.

Capacity cutdown at chrysler : I signed on as Chrysler CEO in July 2007. Theindustry was robust, but the brand had lost its identity. The first six monthswere great. Then came the financial crisis. In strategic capacityplanning, what other capital intensive resources should Robert..

Discuss the dimensions of product quality : Discuss the dimensions of product quality and explain why quality is such an important product strategy objective for Starbucks. Marketing Real People, Real Choices, Seventh Edition, by Michael R. Soloman, Greg W. Marshall, and Elnora W. Stuart. Publ..

Create tornado chart for the original unit sales : 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. c..

Legal environment of business : Caton Avenue Associates was a limited partnership that owned rental property. Caton paid Theodore Dalmazio, one of the general partners, a management fee to manage the property. Assume that you are the judge in the trial court hearing this lawsuit. H..

Why does the government regulate business activities : Why does the government regulate business activities? If businesses are truly overburdened by regulation, why doesn't the government repeal regulation?

Effective organizations understand : Effective organizations understand that leadership succession planning is essential to promote continuity and long-term organizational health. Select a recent article from current events (past 90 days) related to succession planning.

Think toward independent living communities : The company is a non medical in home care company. What needs could your products (in home care) provide for businesses? Think toward independent living communities as well as assisted living communities.

User Account

All Pages