Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Develop a decision analysis formulation of this problem by identifying the decision alternatives, state of nature, and the payoff table.
Solve it all
I want to answer to solve ㅠㅠㅠㅠ.
Q1. A builder has located a piece of property that she would like to but and eventually build on. The land is currently zoned for four homes per acre, but she is planning to request new zoning. What she builds depends on approval of zoning requests and your analysis of this problem to advise her. With her input and your help, the decision process has been reduced to the following costs, alternatives, and probabilities
Cost of land $2 MillionProbability of rezoning .6If the land is rezoned, there will be additional costs for new roads, lighting, and so on of $1 million.
If the land is rezoned, the contractor must decide whether to build a shopping center or 1,500 apartments that the tentative plan shows would be possible. If she builds a shopping center, there is a 70% chance that she can sell the shopping center to a large department store chin for $4 million over her construction cost, which excludes the land; and there is a 30% chance that she can…
Knowledge Booster
Similar questions
- Distinguish between the Expected Monetary Value (EMV) criterion and theExpected Utility Value criterion to decision makingarrow_forwardThe following payoff table shows a profit for a decision analysis problem with two decision alternatives and three states of nature. In order to get full credit, show your all work done step by step including cell calculations using excel functions. State of Nature Decion Alternatives s1 s2 s3 d1 250 100 50 d2 100 75 100 a) Construct a decision tree for this problem. b) Suppose that the decision-maker obtains the probabilities P(s1)=0.65, P(s2)=0.15, and P(s3)=0.20. Use the expected value approach to determine the optimal decision.arrow_forwardYou are given the following payoff table (in units of thousands of dollars) for a decision analysis problem: S1 220 S2 170 S3 A1 110 A2 200 150 180 Prior Probability 0.5 0.4 0.1 (a) Which alternative should be chosen under the maximin payoff criterion? (b) Which alternative should be chosen under the maximum likelihood criterion? (c)Which alternative should be chosen under Bayes' decision rule?arrow_forward
- A financial institution is considering investing in a portfolio of stocks. How can decision theory guide the institution in selecting the optimal mix of stocks based on expected returns and risk preferences?arrow_forwardIdentify and explain the 5-step decision making process and give an example of a situation where this process can be usedarrow_forwardGive proper and detailed explanationarrow_forward
- Supposed that a decision-maker faced with four decision alternatives and four states of nature develops the following profit payoff table.1. If the decision-maker knows nothing about the probabilities of the four states of nature, what is the recommended decision using the MAXIMAX criterion?2. What decision alternative will he choose if using the MAXIMIN criterion?3. What about MINIMAX REGRET CRITERION?4. What decision would he make if using the criterion of realism at alpha 0.6 is used?arrow_forwardSupposed that a decision-maker faced with four decision alternatives and four states of nature develops the following profit payoff table.1. If the decision-maker knows nothing about the probabilities of the four states of nature, what is the recommended decision using the MAXIMAX criterion?2. What decision alternative will he choose if using the MAXIMIN criterion?3. What about MINIMAX REGRET CRITERION?4. What decision would he make if using the criterion of realism at alpha 0.6 is used?arrow_forwardThe following payoff table shows profit for a decision analysis problem with two decision alternatives and three states of nature. States of Nature Decision Alternative $1 52 53 d1 d2 240 90 15 90 90 65 Suppose that the decision maker obtained the probabilities P(s₁) = 0.65, P(s2) = 0.15, and P(S3) = 0.20. Use the expected value approach to determine the optimal decision. EV(d₁) EV(d2) = = The optimal decision is --?--✓arrow_forward
- A television network earns an average of $1.6 million each season from a hit program and loses an averageof $400,000 each season on a program that turns out to be a flop, and of all programs picked up by thisnetwork in recent years, 25% turn out to be hits and 75% turn out to be flops. a) Construct a decision tree to help the television network identify the strategy that maximizes itsexpected profit in responding to a newly proposed television program. Make sure to label all decisionand chance nodes and include appropriate costs, payoffs and probabilities. b) What should the network do? What is their expected profit? c) The network can conduct market research to determine whether a program will be a hit or a flop. Ifthe market research report is perfectly reliable, what is the most the network should be willing to payfor it? Can you please include pictures of excel sheets. Having trouble determining what the excel sheet should look likearrow_forwardAn electronics factory operates on four production lines: laptops, mobiles, desktop computers, smart boards, and there were three cases of demand (weak, medium, and high), and the matrix of returns was as follows: Laptops Mobiles Risk Desktop Computers Smart Boards High 40 45 35 30 Economic state Medium 25 15 30 20 1. The problem presented above is decision-making under Certainty Uncertainty Weak 10 5 -10 -5 Save All Answers Save and Submitarrow_forwardRobert Ragsdale is trying to decide if he should purchase repair and replacement insurance on a new laptop computer that he is planning to purchase. The policy costs $400.00 at the time of purchase, and over the next three years will replace the laptop if it is stolen or repair it if it is broken. The following table contains the total costs of this decision. Which alternative is best, according to each of the following decision criteria? Maximin Maximax Laplace Minimax regretarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,