# Essay Decision Analysis

646 Words 3 Pages
DECISION ANALYSIS ASSIGNMENT 1

Case Problem 1: Planning Advertising Campaign

EXCEL sensitivity report for the Flamingo Grill case problem:

Managerial Report
Question 1:
Data given for Flamingo Grill case problem:
Total budget = \$279000 Advertising media | Exposure rating per ad | New customers per ad | Cost per ad (\$) | HJ consultant limit application to | Television | 90 | 4000 | 10000 | 10 | Radio | 25 | 2000 | 3000 | 15 | Newspaper | 10 | 1000 | 1000 | 20 |

After consideration of limit for each advertising media: Advertising media | Exposure rating per ad | New customers per ad | Cost per ad (\$) | Television | 55 | 1500 | 10000 | Radio | 20 | 1200 | 3000 | Newspaper | 5 | 800 | 1000 |

Model:
Decision
dvertising campaign was to maximize the number of potential new customers reached:
EXCEL sensitivity report for the Flamingo Grill case problem:

Managerial Report
Data given for Flamingo Grill case problem:
Total budget = \$279000 Advertising media | Exposure rating per ad | New customers per ad | Cost per ad (\$) | HJ consultant limit application to | Television | 90 | 4000 | 10000 | 10 | Radio | 25 | 2000 | 3000 | 15 | Newspaper | 10 | 1000 | 1000 | 20 |

After consideration of limit for each advertising media: Advertising media | Exposure rating per ad | New customers per ad | Cost per ad (\$) | Television | 55 | 1500 | 10000 | Radio | 20 | 1200 | 3000 | Newspaper | 5 | 800 | 1000 |

Model:
Decision variables: Advertising media | Num of campaigns for max effectiveness | Num of campaigns for reduced effectiveness | TOTAL | Television | 10 | 4 | 14 | Radio | 15 | 13 | 28 | Newspaper | 20 | 35 | 55 | TOTAL | 45 | 52 | |

TOTAL NEW CUSTOMERS REACHED = 139600
TOTAL EXPOSURE = 2130
Constraints:
* Must reach at least 100000 new customers
139600 ≥ 100000 * Total campaign slots for maximum effectiveness smaller or same with limit
Television: 10 ≤ 10
28 ≥ 28 * Use not more than 20 television ads
Television: 14 ≤ 20 * Television budget should be at least \$140000

## Related Documents

• ###### Essay Decision Analysis

Science, 10e (Taylor) Chapter 12 Decision Analysis 1) A state of nature is an actual event that may occur in the future. Answer: TRUE Diff: 1 Page Ref: 527 Main Heading: Components of Decision Making Key words: state of nature 2) A payoff table is a means of organizing a decision situation, including the payoffs from different decisions given the various states of nature. Answer: TRUE Diff: 1 Page Ref: 527 Main Heading: Components of Decision Making Key words: payoff table…

Words: 5136 - Pages: 21
• ###### Decision Making Analysis Essay

Decision Making Analysis “I think that decision making is the fundamental challenge for organizations that aspire to be collaborative. There are a lot of things we can do to solicit input, to involve people, to inform people, but so often the rubber hits the road at decision points, when a group of people have to sit around a table or in a circle and deliberate around a specific decision, and the mindset and the skill set and the methods are important here. And an organization and leaders need…

Words: 682 - Pages: 3
• ###### Essay Decision Analysis Task 3

Recommend which method (i.e., using reconditioned equipment, purchasing new equipment in its Shanghai plant, or outsourcing to another manufacturing operation) Shuzworld should use for the manufacturing of its sneakers, utilizing the appropriate decision analysis tool. Shuzworld has decided to produce the Samba Sneaker, a bright colored shoe marketed for teens and pre-teens. The company needs to decide which would be more economical: reconditioning their existing equipment for this production, buying…

Words: 2878 - Pages: 12
• ###### Decision Analysis Essay

DECISION ANALYSIS Definition: A systematic procedure based on thinking patterns used to make choices in the hopes that they are good ones. It involves considering the Elements of a good choice and weighing them against your MUSTS/WANTS and any risks before making a final decision: The book is full of mumbo jumbo on this, but it isn't rocket science. We do some decision analysis almost every time we take a course of action. 1.Develop a Goal or Decision Statement. ACTION Oriented statement.…

Words: 1582 - Pages: 7
• ###### Decision Analysis Essay

Decision Analysis 3/1/2014 Unknown A. Workflow In order to improve the workflow in the plant, Shuzworld will have to improve the layout of their facility in order to create their product in a cost efficient and productive manner. This will enable Shuzworld to increase productivity, while ensuring the quality that consumers have grown to be accustomed to. Shuzworld will be able to accomplish this by equalizing the task times at the company’s work stations in order to ensure that employee…

Words: 5152 - Pages: 21
• ###### Essay Industry Analysis For Investment Decision

Industry Analysis for Investment Decision The industry analysis plays a crucial role for making effective decisions with regard to investment and strategy formulation. Since strategic decisions are long term and irreversible analyzing the external environment for an industry is very essential. This paper performs industry analysis for automobile industry. An industry is a group of firms producing products that are close substitutes. In the course of competition, these firms influence one another…

Words: 2701 - Pages: 11
• ###### Essay An Analysis Of Graham Allison's Essence Of Decision

In Essence of decision, Graham Allison leverages the incredible events of the Cuban missile crisis to challenge the way people think about foreign and military affairs. He compares the application of three analytical models to showcase the limitations of the rational actor model, arguing that the crisis could be better understood when the organizational behavior and government politics model are applied as well. Treating these models as lenses, Allison provides the reader with both an in-depth explanation…

Words: 900 - Pages: 4
• ###### Decision Analysis Task 2 Essay

Decision Analysis Task 2: A. Develop a distribution pattern that meets availability and demand constraints and minimizes total shipping costs for Shuzworld, utilizing the appropriate decision analysis tool. Your current distribution pattern should have Shanghai shipping 1300 units to Warehouse 2, Shuzworld H shipping 300 units to Warehouse 1, 200 units to Warehouse 2 and 1800 units to Warehouse 3, and Shuzworld F shipping 2200 units to Warehouse 1. This transportation plan results in an Optimal…

Words: 2118 - Pages: 9
• ###### Essay Case Analysis : ' A Morally Flawed Decision

1. Choose one morally questionable decision made by any character in the movie & describe the scene in which that decision is made. Then describe the object, the intention, & the cirumstance of that decision. Based on your analysis of these three factors, to what degree do you think this character is guilty of an immoral action? (5 points) In the movie, a morally questionable decision is made by Andy when he decides to escape prison and steal the Warden’s money from his bank account . The object…

Words: 952 - Pages: 4
• ###### Essay Dmd Case Analysis of Making a Decision of Buying a House

Assignment Form |Course: | Data, Model and Decision | |Instructor: | Dr. Feng Haolin | |Homework: |Decision Analysis | |Name: | Group 1. Li Yuechuan/ Pankaj Malhotra/ Liang Yuan/…

Words: 1201 - Pages: 5