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

  Difference between productivity and its subcomponents

Describe the differences between productivity and its subcomponents total measure productivity, partial measure productivity.

  What management concerns made bp reexamine

What management concerns made BP reexamine their leadership model? What business issues did they face? How did this form of human expression assist in moving the top management perception of the organizational culture forward?

  What is the new waiting time at lhs

What is the new waiting time at LHS? Is it less than or greater than the waiting time of LHS before the merger? (Assume that the coefficient of variance of customer inter-arrival times is 1).

  Prepare the aggregate plan to cover six periods

Prepare the aggregate plan to cover six periods. period 1 forecast 200, period 2 forecast 200, period 3 forecast 300, period 4 forecast 400, period 5 forecast 500, period 6 forecast 200. cost output regular time $2 per skateboard, temp workforce rate..

  What are the primary elements of each risk control

What are the primary elements of each of the three types of risk control? Assume you are in a hazard hunt; list a few factors in your job that may contribute to a hazard and how likely is it that a hazardous situation will occur?

  Logistics management and supply chain management

Differentiate between the concept of logistics management and supply chain management, including the relationship of each to the concept of the value-added chain. ?Describe the differences between physically efficient and market responsive supply cha..

  Working as individual or in team of three or more people

Working as an individual or in a team of three or more people, use DMAIC to improve a process in one or more of the organizations listed below:

  Create a series of three standard billboards

Create a series of three standard billboards that would grab a commuter's attention and motivate them to visit the store. Describe your three billboards in detail.

  Compare the product and service design processes

The growth of the service economy has seen even traditional product-focused companies aggressively pursuing a service design to add value to their product offering. Explain the differences between a product design and a service design. Compare the..

  The statement has been made that a quality system is not

the statement has been made that a quality system is not just a series of boxes and arrows. it is an interconnected

  Economic order quantity-minimum total annual cost

The Wallace Stationary Company purchases paper from the Seaboard Paper Company. Wallace produces stationary that require 1,415,000 sq. yards of stationary per year. The cost per order for the company is $2,200; the cost of holding 1 yard of paper in ..

  Reflected in their pricing strategy

Suppliers have to choose different pricing strategies depending on the market they’re in. Expand upon this concept in a discussion board post. Consider: How might pricing strategies differ among carriers in competitive, oligopolistic, and monopolisti..

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