Please help me woth this question using excel

The Gorman Manufacturing Company must decide whether to manufacture a component part at its Milan, Michigan, plant or purchase the component part from a supplier The resulting profit is dependent on the demand for the product. The following payoff table shows the projected profit (in thousands of dollars): State of Nature Low Demand Medium Demand High Demand 81 92 Decision Alternative 53 Manufacture, d -20 40 100 Purchase, d 10 45 70 The state-of-nature probabilities are P(s) 0.30, P(s) 0.30, and P(ss) - 0,40. Do not round your intermediate calculations. (a) Use a decision tree to recommend a decision. Manufacture component part (b) Use EVPI to determine whether Gorman should attempt to obtain a better estimate of demand. Enter your answer in thousands dollars. For example, an answer of $200 thousands should be entered as 200,000. Gorman should attempt to obtain a better estimate of demand, as the additional information could be worth up to s for Gorman. (c) A test market study of the potential demand for the product is expected to report either a favorable (F) or unfavorable (U) condition. The relevant conditional probabilities are as follows: P(UiS) = 0.90 P(FI1) - 0.10 P(F|52) = 0.40 PIUS2) =0,60 P(FIS) = 0.60 PIUSI - CAO What is the probability that the market research report will be favorable? [Hint: We can find this value by summing the joint probability values as follows: P(F) = P(FNS) + P(F52) + P(F53)=P(S1)P(Fiss) + P(52)P(FIS)) + P(s)P(Fis)).] If required, round your answer to three decimal places. Gorman. (c) A test market study of the potential demand for the product is expected to report either a favorable (F) or unfavorable (U) condition. The relevant conditional probabilities are as follows: P(FIS1)-0.10 P(U/s1) - 0.90 P(FIS) 0.40 P(U152) 0.60 P(FIS) 0.60 P(Usa) 0.40 What is the probability that the market research report will be favorable? [Hint: We can find this value by summing the joint probability values as follows: P(F) P(FOS) + P(FOS) + P(FOS) P(S1)P(FI1) + P(s)P(FIS) P(ga)P(FIS) 1 If required, round your answer to three decimal places. (d) What is Gorman's optimal decision strategy? Choose the correct option. A. Conduct test market, and manufacture component part, regardless of the market research report 8. Conduct test market, and purchase component part, regardless of the market research report C. Conduct test market, and manufacture component part if market is favorable, or purchase component part if market is unfavorable D. Do not conduct test market, and purchase component part E. Do not conduct test market, and manufacture component part (e) What is the expected value of the market research information? Enter your answer in thousands dollars. For example, an answer of $200 thousands should be entered as 200,000. If your answer is zero, enter "0