Reference no: EM13951228
Decision Analysis Problem: You are a potential business owner in the hoomaflopper industry. You have hired Dustin R. Mopps as your industry insider to help you decide which businesses to focus on potentially buying. He has collected useful data from multiple sources for you. The problem with Mr. Mopps is that he is a terrible decision analyst. So, it is up to you to figure out what to do.
Dustin found a business for you to look into for a possible purchase: property ID number 51 in your data set, valued at $188,000. If this property is indeed viable, it is estimated to earn you $500,000 in the first year of business. However, you will have to pay $60,000 to perform a systems audit and refurbish it right after you buy it. Your back-of-the-envelope estimate is that there is X chance that you could realize the $500,000. You will need to spend a little time to figure out X for your model.
Alternatively, you could hire Dustin to first do some real estate legwork for you, since real estate data is his specialty. He will ask for $16,000 to do further market research for you. From sneakily talking to his other clients, you estimate the probability as 60% that Dustin's market research will be favorable, if the business is going to be viable. The probability of an unfavorable report from Dustin is 70% if the business will not be viable. In other words, you trust him, but not that much. He might be able to give you an edge. You need to know if it is worth paying him the $16,000 or not. Keep all of these values in mind for your conditional probability calculations.
1. Open the ProblemSet 5 Tree file in Excel
a. Using the information provided with the problem, fill in all of the blue cells on the Excel worksheet.
c. Calculate the sheet (hit F9)
2.
3. Provide the answers to the questions that follow:
a. Describe and interpret what is going on in this tree in about 250 words.
b. Include a discussion on what the optimal strategy is and why is it the optimal strategy?
c. Include a statement of what the expected value is? What does expected value mean here?
d. Change the values in cells B:20 to B:26. These contain the costs and payouts. Change these one at a time and calculate sheet. Discuss what threshold values flip the decision tree to recommending a different strategy?
|
Blue ocean innovative strategy frameworks
: Read and Review the analysis and respond to this analysis by offering potential critical directing questions and specific and constructive ideas for improving analysis.
|
|
Would intelligence develop would we be able to understand it
: What would happen if we had dedicated computers with a huge number of neuron circuits
|
|
How can carco maximize the number of new customers created
: How can Carco maximize the number of new customers created by advertising? First formulate the problem then solve it with Excel's solver!
|
|
Attractiveness of under armour situation
: What does a SWOT analysis reveal about the overall attractiveness of Under Armour's situation? Which one of the five generic competitive strategies discussed in Chapter 5 most closely approximates the competitive approach that Under Armour is emplo..
|
|
Potential business owner in the hoomaflopper industry
: Decision Analysis Problem: You are a potential business owner in the hoomaflopper industry. You have hired Dustin R. Mopps as your industry insider to help you decide which businesses to focus on potentially buying.
|
|
Ethical behavior of employees
: To maintain compliance, organizations develop policies that guide the ethical behavior of employees. In order to explore the differences between laws and policies, please discuss the following:
|
|
What can you tell me about hybrid databases
: What can you tell me about hybrid databases? What are the positives and negatives? Are they better than using a OO or Relational database specifically? (Research will be necessary and do not rely solely on Wikipedia)
|
|
Team creativity and brainstorming
: This week you explored team creativity and brainstorming. For five days, keep a creative idea journal. Each day you should come up with 5-10 fresh ideas (these can be business concepts or strategies,
|
|
State the hypotheses to test the main effects of gender
: For this example, what specific test might you use to test whether the average number of offspring has changed over the years? Why would you use this specific type of test? Describe a brief scenario where you may need to use nonparametric statistic..
|