Problem 4 tab shows a decision tree with 6 nodes. Each node has a cell with yellow background color above it.

1. Enter appropriate formulas in all cells with the yellow background to evaluate the decision tree. Show the winning project (A, B, or C) in the space provided by entering a formula inside cell B5.
2. How should the payoff on node 2 (currently $75) be changed to make Project A the winner?
3. How should the probability on node 2 branch (currently 0.25) be changed to make Project A the winner?

C D E F G H J K B 1 PROBLEM 4 (25 Points) $75 ANSWERS for Problem 4 5 Winning Option: Evaluation for Node 6: $ $40 0.45 9.35 $70 Evaluation for Node 5: Evaluation for Node 4: Evaluation for Node 3: Evaluation for Node 2: Evaluation for Node 1: 0.25 $50 Formula typed in cell B5: a 15 uns $60 New Payoff (repl. $75) on Node 2: 0.85 $70 New Prob. (repl. 0.25) on Node 2: C D E F G H J K B 1 PROBLEM 4 (25 Points) $75 ANSWERS for Problem 4 5 Winning Option: Evaluation for Node 6: $ $40 0.45 9.35 $70 Evaluation for Node 5: Evaluation for Node 4: Evaluation for Node 3: Evaluation for Node 2: Evaluation for Node 1: 0.25 $50 Formula typed in cell B5: a 15 uns $60 New Payoff (repl. $75) on Node 2: 0.85 $70 New Prob. (repl. 0.25) on Node 2