Question

#19 What is the EVPI? Success Moderate Success Failure Probability 0.3 0.3 0.4 Sell Company 99 99 Form Joint Venture 210 120 Sell Software on own 420 121 -100 Submit Answer format: Number: Round to: 1 decimal places, unanswered not submitted

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

- 2x EH EI EI EKT ELI EMI ENI EOI EPI EO ER 1 STATS - Microsoft Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View Add-Ins % Cut Σ AutoSum : A Calibri 11 A A = = = V Wrap Text General Ea Copy Fill 2 m Paste B I U B- E A = 5 st Fat Merge Merge & Center - Center $ $ Format Painter % % , .0 .00 8.8 Conditional Format Cell Insert Delete Format Sort & Find & Formatting as Table Styles Clear Filter Select Clipboard Font Alignment Number Styles Cells Editing EL55 Fax EE EF EG 39 40 EVPI = EXPECTED VALUE UNDER PERFECT INFORMATION 41 DEMAND SUCCESS MODERATE FAILURE 42 SUCCESS 43 PROBABILITY 0.3 0.4 EMV 44 EXPANSION 45 SELL COMPANY 99 99 99 99 (=SEH$43*EH45+SEI$43*E145+SEJ$43*EJ45] 46 FROM JV 210 120 128.6 (=$EH$43*EH46+SEI$43*E146+$E$43*EJ46] 47 SELL SOFTWARE ON OWN 420 121 -100 122.3 [=$EH$43*EH47+SEI$43*E147+$E$43*EJ47] 48 49 ANSWER EVPL = EPPI-EMV (0.3 X 420 +0.3 X 121 + 0.4 X 99 ) - 128.6 73.3 51 (SELECT THE HIGHEST VALUE FROM EACH COLUMN X PROB) 0.3 74 50 52 53 54 55 56 57 H P EMV MEAN STDV assignment DEAR Sheet2 COV TIME SERIES corr REGRESSION range CAMERA TREND freg_MATRIX V FV DIVIDEND ferences INTERVAL, NORMAL BO HYPOTHIC 130% _ Rea 0 + S E O * 10 ENG 30-10-2019