Do you want to continue working where you left off? P28. Construct a sequential decision tree for this decision situation and determine whether the company should make a bid.Įxcel File Edit View Insert Format Tools 69% 1 Mon 12:02 AM a OOO AutoSave OFF BESU: Data Window Help Ch12-Decision Analysis_empty Review View Add-ins Tell me Q Home Insert Draw Page Layout Formulas Data Share Comments = X Insert Calibri (Body) V 11 ~ AF A Σ General Conditional Formatting Format as Table Cell Styles = 28 0 4 DX Delete v Paste BIU Av $ % ) 4 -29 Ideas Sort & Filter A Format Find & Select Sensitivity Yes No Open recovered workbooks? Your recent changes were saved. If the company does not make a bid, it will invest in an alternative venture with a guaranteed profit of $30 million. 20 -40 Subcontract: Outcome Probability Profit ($1,000,000s) Moderate success 1.00 250 The cost of preparing the contract proposal is $2 million. 10 -100 Use present process: Outcomes Probability Profit ($1,000,000s) Great success. Transcribed image text: Outcomes Probability Profit ($1,000,000s) Great success.