### Create an Account

Home / Questions / Hello Experts I need help with the following question Can you please provide clear step by...

# Hello Experts I need help with the following question Can you please provide clear step by step answer in excel and show your work so with formulas if possible so I can follow and learn Thank you

Hello Experts- I need help with the following question. Can you please provide clear step by step answer in excel and show your work so with formulas if possible so I can follow and learn. Thank you in advance for your help!

Question:

A television network earns \$2.5 million dollars each season for a hit program and loses \$0.5 million each season for a flop. In general, 19% of the programs are considered hits and 81% of the programs are flops. At a cost of \$400,000 a research firm will analyze the pilot episode and issue a report predicting whether the program is going to be a hit or a flop. From the past data, if the program is going to be a hit, there is a 90% chance that the research firm predicted it is going to be a hit. On the other hand, there is a 20% chance the research firm predicted that the program is going to be a hit, but ended as a flop.

a. Formulate this problem and use decision tree to model this problem and calculate the Expected Monetary Value.

b. Calculate EVPI. Use both decision tree and Influence diagram. Is the information from the research firm is worth spending \$400,000.

c. Calculate EVII.

Apr 04 2020 View more View Less Subscribe To Get Solution