If youre going to use excel please use screenshots NOT copy and paste

* Reconsider Problem 16.1. Christine has done more detailed planning for this project and so now has the expanded activity list shown below. Follow the instructions for Problem 16.1 with this expanded activity list. 1. Christine Phillips is in charge of planning and coordinating next spring's sales management training program for her company. Christine has listed the following activity information for this project: Problem 2 (65 points) Hillier Chapter 9,9.16 (e-book page 455). Read the problem description. When the credit-rating organization is not used, below is the corresponding payoff table a) Use the EMV/EP criterion to determine which decision alternative should be chosen. Justify and show your work/calculations. (6 points) b) What is the expected value of perfect information (EVPI)? Show your work/calculations. (6 points) c) Does the value of the EVPI indicate that consideration should be given to using the credit-rating organization? Justify. (3 points) Assume now that the credit-rating organization is used. d) Use the likelihoods/conditional and prior probabilities to calculate all the posteriors/revised probabilities. Show your work/calculations. (15 points) Round the probabilities to three decimal points. e) Draw and solve the decision tree for this entire problem to determine the optimal decision strategy that Vincent's should follow. (Show your work/calculations). Verbally communicate the decision strategy. (30 points) Round the probabilities on the decision tree to one decimal point. f) Find the expected value of sample information (i.e., EVSI). If the fees for using the credit-rating organization is open to negotiation, how large can the fee be before the use of this organization would no longer be worthwhile? Show your work/calculations. (5 points)