A group of medical professionals is considering constructing a private clinic. If a patient demand for the clinic is high, the physicians could realize a net profit of $120,000. If the demand is low, they could lose $55,000. Of course, they do not have to proceed at all, in which case there is no cost. In the absence of any market data, the best the physicians can guess is that there is a 50-50 chance the demand would be high.

a) Create a decision tree.

b) What should the medical professionals do? What is the payoff?

c) The physicians have been approached by a market research firm that offers to perform a study of the market at a fee of $5,000. The market researchers claim that their experience enables them to use Bayes theorem to make the following statements of probability:

-probability of high demand given a positive survey result = 0.82

-probability of low demand given a positive survey result = 0.18

-probability of high demand given a negative survey result = 0.11

-probability of low demand given a negative survey result = 0.89

-probability of a positive survey result = 0.55

-probability of a negative study result = 0.45

Based on these probabilities, using the same payoff values as part A, what should the medical professionals do? What is the payoff?

d) Submit excel file

Must use excel. Thank you!