please use excel and show cell formulas

1) An operations manager must purchase new equipment and has developed a table of conditional values for the various alternatives (equipment options) and states of nature (demand market conditions). it the probabilities associated with the states of nature are 0.4 for a good market, 0.40 for an average market, and 0.20 for a poor market, determine: (a) the alternative that provides the greatest expected monetary value (EMV) (15 pts) (b) the expected value of perfect information (EVPI) (10 pts)