Please solve using excel

Q2 (15 points): Zhu Manufacturing is considering the introduction of a family of new products. Long-term demand for the product group is somewhat predictable, so the manufacturer must be concerned with the risk of choosing a process that is inappropriate. Faye Zhu is VP of operations. She can choose among batch manufacturing or custom manufacturing, or she can invest in group technology. Faye won't be able to forecast demand accurately until after she makes the process choice. Demand will be classified into four compartments: poor, fair, good, and excellent. The following table indicates the payoffs (profits) associated with each process/demand combination, as well as the probabilities of each long-term demand level. 2.A. Based on expected value, what choice offers the greatest gain? 2.B. What would Faye Zhu be willing to pay for a forecast that would accurately determine the level of demand in the future? Poor Fair Good Excellent Probability 0.15 0.35 0.4 0.1 Batch Process $ 100,000.00 $ 300,000.00 $ 650,000.00 $ 800,000.00 Custom Process $(1,000,000.00) $ (500,000.00) $ 500,000.00 $ 2,000,000.00 Group Technology $ (200,000.00) $ 700,000.00 $ 800,000.00 $1,000,000.00