Problem 3 tab shows a decision tree with 7 nodes Each node has a cell with yellow background color above it Enter appropriate formulas in all cells with the yellow background to evaluate the decision tree Show the winning project (A or B) in the space provided by entering a formula inside cell B5 How should the payoff on node 4 (currently $40) be changed to make the Project A the winner How should the probability on node 4 branch (currently 0 6) be changed to make Project A the winner B C D E F G H J K L M PROBLEM 3 (25 Points) $80 $40 ANSWERS for Problem 2 Evaluation for Node 7 5 Winning Project $30 Evaluation for Node 6 Evaluation for Node 5 $70 Evaluation for Node 4 Evaluation for Node 3 $90 Evaluation for Node 2 Evaluation for Node 1 ($10) Formula typed in cell B5 New payoff (replace $40) for Node 4 ($20) New prob (replace 0 6) on Node 4 $80

The Answer is in the image, click to view ...

Question: Problem 3 tab shows a decision tree with 7 nodes. Each node has a cell with yellow background color above it. Enter appropriate formulas in

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

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

B C D E F G H J K L M PROBLEM 3 (25 Points) -- $80 $40 ANSWERS for Problem 2 Evaluation for Node 7: 5 Winning Project: $30 Evaluation for Node 6: Evaluation for Node 5: $70 Evaluation for Node 4: Evaluation for Node 3: $90 Evaluation for Node 2: Evaluation for Node 1: ($10) Formula typed in cell B5: New payoff (replace $40) for Node 4= ($20) New prob. (replace 0.6) on Node 4= $80

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Problem 3 tab shows a decision tree with 7 nodes. Each node has a cell with yellow background color above it. Enter appropriate formulas in all cells with the yellow background to evaluate the...

Problem 4 tab shows a decision tree with 6 nodes. Each node has a cell with yellow background color above it. Enter appropriate formulas in all cells with the yellow background to evaluate the...

Step 1: Save this worksheet as petty.xlsx Step 2: Apply a currency format with two decimal places to the data where appropriate. Step 3: Insert a row between rows 1 and 2 and remove the blank row 4....

CASE its lose in ROSE TREE REGIONAL AIRLINE or ad- ying Decision Support Using Microsoft Excel Solver PREVIEW onse Tree Regional Airline provides passenger transportation services and small-parcel...

I have this Accounts assignment that needs to be done. Need help on that Statement of individual work Individual work required This project is designed to assure that all students, individually, have...

PUAD 630 - A NALYTICAL T ECHNIQUES U NIVERSITY OF B ALTIMORE , C OLLEGE OF P UBLIC A FFAIRS S EZGIN AYABAKAN , P H D Assignment 5 Individual or in Pairs Due Date: Dec 07, 2015 at 10:00AM There are...

C D E F G H J K L M N O P O F On the tab labeled "Network Diagram", I have provided a modified visual representation of the network for Problem #9 on Page 227. On the tab labeled Production Plan,"...

12:38 4 Assignment Details MTH 154-N41A: Quantitative Reasoning (SP21) MTH 154 Excel Project In this major project, you will create an Excel file and answer questions about linear and exponential...

PROJECT SCOPE [Instructions for what to include in this section: Define the scope of work that will be undertaken to provide the deliverable(s) mentioned in the Project Charter (PC). Craft this...

Hello, Can you help me with this assignment? the instruction for this assignment is in the attachment below CIS 1220 Final Exam Problem Statement Fashion Impressions is a designer clothing...

For a solute that is dissolved in a solvent to produce asolution: Given the chemical formulas of the solvent and the solute, themass of the solute, the final volume of the solution, the...

? ? The financial statements of P&G are presented in Appendix B. The company s complete annual report, including the notes to the financial statements, is available online. Click here to view...

Project eyN UM tee) Ratios - BAM rae Ratios - Park Pets You are the sole owner of Barks and Meows Inc. (BAM) pet store in Beaumont. You have been in business for 5 years and things are going very...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...