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.

Reviews

Write a Review

 

Operation Management Questions & Answers

  The ethical issues organizations face when implementing

Include the URL if you used an electronic source and if you used a printed source please attach a copy of the data to your paper.

  Improve the company and increase shareholder value

What actions do you recommend that Walt Disney Company’s management take to improve the company and increase shareholder value? Your recommended actions must be supported with a convincing, analysis-based argument.

  The fixed cost for a machine

The fixed cost for a machine is $6,400, and its variable cost is $3.50 per unit. ABC charges $7.50 to balance one wheel. What is the break-even point in units?

  Describe the commonly used project selection techniques

Briefly describe the commonly used project selection techniques. Discuss which project selection techniques you think organizations use most often for justifying information technology projects.

  Difference between a successful person

Consider the following statement: “The major difference between a successful person and one that is not successful is that the successful person, over time, tends to make better decisions than the less successful person.” Discuss whether or not you b..

  Decided to express your feelings about it on your blog

You had a bad day at work and decided to express your feelings about it on your blog. Among other things, you mentioned that you believe your boss is dishonest and might be stealing from the company because she keeps buying expensive jewelry for hers..

  Models of operations and information management

Critically analyse the theory, concepts and models of operations and information management and demonstrate an understanding of the strategic importance of information management in global organisations.

  Analyze reliability of computer-driven shoe machines process

Analyze reliability of computer-driven shoe machines process in Shuz world Shanghai plant.

  What is the purpose of environmental analysis

What is the purpose of environmental analysis. What are the implications of environmental analysis in the creation of your strategic plan. What are the major benefits of competitive analysis as part of your strategic planning process

  What would his total ordering cost be for the year

There are 360 working days per year and the lead-time is 5 days. If Mark orders 200 units each time he places an order, what would his total ordering cost be for the year?

  Stiff pushback and negative feedback from employees

SCENARIO: Your boss has sent you to McAllen to a small company that wants to incorporate the use of teams in projects and activities. Their ideas have been met with "stiff" pushback and negative feedback from employees. You're to present a presentati..

  Value chain management and employee satisfaction

This week you will consider the human resource aspects and enablers of value chain management. It is widely accepted there is a distinct, measurable and positive relationship between employee satisfaction and customer satisfaction. Assume you are wor..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd