Please Shoe Excel Solution with formulas

A manufacturing company should decide whether to produce a compenent part at its plant or purchase it from a supplier. The expected profit is dependent on the product demand. The chance that the demand is low is 30%, that the demand is medium is 30%, and that the demand is high is 40%. The following payoff table shows the projected profit: State of nature Decision Alternative Low Demand Medium Demand High Demand Manufacturing in house - $10,000 $ 30,000 $70,000 Purchasing from a supplier $5,000 $ 35,000 $40,000 In this table you can see that, for example, when the demand is low, if the manufacturer purchases the part from the supplier, its profit is $5,000, but if the manufacturer produces the part in its plant, the profit is - $10,000. A. Calculate the manufacturer's expected profit, if it produces the parts in its plant (1 point)? B. Calculate the manufacturer's expected profit, if it purchases the parts from the supplier (1 point)? C. What is the appropriate decision and why (0.5 point)? Please show the calculation otherwise you cannot get any score. You can do the calculation on a sheet of paper, and then paste it in this sheet