!! Have excel do all calculations !!

!! Please show formulas !!

Quantitative Methods problem

3. Georgias Best is a family - owned farm in southern Georgia that specializes in producing peaches to sell at a local farmers market . Each case of peaches costs $ 36 to process and sells for $ 65 . If there are cases leftover at the end of the selling period , they are of no commercial value and fed to the pigs.

The probability that demand for 50 cases is 0.10, 100 cases is 0.30, for 150 cases is 0.40, and for 200 cases is 0.20.

A) Construct a payoff table for this problem by calculating payoff values for the following table : Cases demanded 50, 100, 150, 200. Cases produced 50, 100, 150, 200.

B) Calculate the Expected Monetary Value for each alternative .

C) Give a recommendation to GB as to how many cases of peaches they should produce for the farmer's market.

D) Calculate the Expected Value with Perfect Information and the Expected Value of Perfect Information for this problem.

E) How would you interpret the Expected Value of Perfect Information result ?

3. Georgia's Best is a family-owned farm in southern Georgia that specializes in producing peaches to sell at a local farmer's market. Each case of peaches costs $36 to process and sells for $65. If there are cases leftover at the end of the selling period, they are of no commercial value and fed to the pigs. The probability that demand for 50 cases is 0.10, 100 cases is 0.30, for 150 cases is .40, and for 200 cases is 0.20 a. Construct a payoff table for this problem by calculating payoff values for the following table: Cases demanded 100 150 50 200 Cases produced CI 50 100 150 200 b. Calculate the Expected Monetary Value for each alternative. c. Give a recommendation to GB as to how many cases of peaches they should produce for the farmer's market. d. Calculate the EVwithPI and the EY PI for this problem. + e. How would you interpret the EXOf PI result