Show $me$ the steps $to$ solve $in$ Excel, preferablly.

Drop down list options are all the following: $d1,d2,d1ord2$

The following payoff table shows profit for a decision analysis problem with two decision alternatives and three states $of$ nature.

The probabilities for the states $of$ nature are $P(s_1)=0\mathrm{.}65,P(s_2)=0\mathrm{.}15,$ and $P(s_3)=0\mathrm{.}20.$

$(a)$ What $is$ the optimal decision strategy $if$ perfect information were available?

$If{s}_1$ then

; $If{s}_2$ then

; $If{s}_3$ then

$(b)$ What $is$ the expected value for the decision strategy developed $in$ part $(a)?$

$(c)$ Using the expected value approach, what $is$ the recommended decision without perfect information? What $is$ its expected value?

The recommended decision without perfect information $is$

$EV=$

$(d)$ What $is$ the expected value $of$ perfect information?

$E\frac{V}{P}$I $=$