Management at Washington Hospital Center is thinking about two investments. One is an MRI machine, which can make $100,000 in good economic conditions or $60,000 in bad economic conditions. Another is a CT scanner, which can make $150,000 in good economic conditions of $10,000 in bad economic conditions. Thus the decision depends on the economic conditions. What is the probability of good economic conditions that equates the two investments?
1. Maximax
2. Maximin
3. Equal likihood
Create a sensitivity graph comparing the different alternatives as the probability of economic conditions changes.
I need a sensitivity graph to compare the different alternatives as the probability of economic conditions changes.
a.
The payoff table is shown below
b.
1.
The max of each decision is 100000 and 150000. Among them the maximum value is with 150000. This means the best decision is CT scanner using maximax criteria.
2.
The min of each decision is 60000 and 10000. Among them the maximum value is 60000. This means the best decision is MRI machines.
3.
The average value of each decision is (100000+60000)/2 =80000 and (150000+10000)/2 = 80000. The equal likelihood decision provides the same value. So either of the decision can be chosen.
4.
The regret table is shown below
The maximum regret of each decision is 50000. This means using minimum regret approach can choose either of the decisions.
The probability of good economy where the both = X then we can solve for X by
100000*X + 60000*(1-X) = 150000*X + 10000*(1-X)
60000 – 40000X = 10000 + 140000X
50000 = 100000X
X = 0.5
At 50% probability, the two investments are equal.
The senstivity graph is shown below

Management at Washington Hospital Center is thinking about two investments. One is an MRI machine, which...
Kelly is contemplating on returning to graduate school to earn her MBA. She knows from experience, that she can get a well paying job after undergraduate school. The probability of getting a job with a salary of $20,000/year is 75% and a job with a salary of $30,000/year is 25%. However, if she chooses to attend and finish graduate school, her salary would likely increase. The probability of getting a job with a salary of $40,000/year is 75% and getting...
Please show work on excel spreadsheet with sensitivity tables
one should be of exact value. thank you
A new small manufacturing company, which produces toys, has to decide whether it wants to distribute its product through a wholesale distributor, go directly to department stores, or open its own store. The table below shows the revenue results for each decision. Construct an Excel spreadsheet to answer the following: a, What is the probability value of good economic conditions that will make...
1. An investor has been thinking about starting her own independent women's beautification business. The investor's problem is to decide how large her business should be. The annual returns will depend on both the size of her business and a number of marketing factors related to the beauty industry and demand for beautification. The following payoff table gives the profits that would be realized during the next year for each of four investment alternatives (in 000'OMR) Size of Station Good...