decision Making Decision Analytics
mathgenuis2021
attachment_2.xlsxQ1
| Payoff (Profit $m) | ||||||||||||||||
| EMV | ||||||||||||||||
| 1 | ||||||||||||||||
| EMV | ||||||||||||||||
| EMV | ||||||||||||||||
| EMV | ||||||||||||||||
| EMV | ||||||||||||||||
| EMV | ||||||||||||||||
| EMV | 1 | |||||||||||||||
| EMV | ||||||||||||||||
| EMV | ||||||||||||||||
| EMV | ||||||||||||||||
| EMV | ||||||||||||||||
| EMV | ||||||||||||||||
| Part a) which policy should be selected? | ||||||||||||||||
| Part b) Sensitivity Analysis for the probability of launching "Before the rival" in the "Bring Launch Forward" policy | Part b) Sensitivity Analysis for the probability of launching "Before the rival" in the " Don't Bring Launch Forward" policy | |||||||||||||||
| Probability | Bring Launch Forward | Don't Bring Launch Forward | Probability | Bring Launch Forward | Don't Bring Launch Forward | |||||||||||
| $0.00 | $0.00 | $0.00 | $0.00 | |||||||||||||
| 0.00 | 0.00 | |||||||||||||||
| 0.10 | 0.10 | |||||||||||||||
| 0.20 | 0.20 | |||||||||||||||
| 0.30 | 0.30 | |||||||||||||||
| 0.40 | 0.40 | |||||||||||||||
| 0.50 | 0.50 | |||||||||||||||
| 0.60 | 0.60 | |||||||||||||||
| 0.70 | 0.70 | |||||||||||||||
| 0.80 | 0.80 | |||||||||||||||
| 0.90 | 0.90 | |||||||||||||||
| 1.00 | 1.00 | |||||||||||||||
| Part b) Plot of Sensitivity Analysis | Part b) Plot of Sensitivity Analysis | |||||||||||||||
| Part b: Interpretation of sensitivity analysis | Part b: Interpretation of sensitivity analysis | |||||||||||||||
Increasing advertising
Don't increase ads.
Bring Launch Forward
After the rival
Before the rival
High circ
Low circ
High circ
High circ
Low circ
Low circ
Increasing advertising
Don't increase ads.
High circ
High circ
Low circ
After the rival
Before the rival
High circ
Low circ
Don't Bring Launch Forward
Don't Launch
Low circ
