"States-of-Nature": Three possible market outcomes (great market; acceptable market; and bad market) There are also updated payoff scenarios as included in the following table: Alternative Large Plant Medium Plant Small Plant Do Nothing Payoffs for Each "State-of-Nature" Acceptable Great Market Market Bad Market $250.000 $100,000 -$225.000 $170,000 $50,000 - 100.000 $125,000 $25,000 -$40,000 $0 $0 $0 Using the above information, construct an Excel sheet to analyze the following alternatives. For each scenario, what is the best alternative and resulting payoff? Please write your an- swers below and submit your Excel spreadsheet to Canvas. a. Optimistic - (Maximax) -(10 points) b. Pessimistic - (Maximin) -(10 points) c. Criterion of Realism (a = 0.60) - Perform all of the manual calculations for this sce- nario below. (i.e., write out the mathematical equation and show your work in addi- tion to uploading the Excel spreadsheet to Canvas). (20 points) "States-of-Nature": Three possible market outcomes (great market; acceptable market; and bad market) There are also updated payoff scenarios as included in the following table: Alternative Large Plant Medium Plant Small Plant Do Nothing Payoffs for Each "State-of-Nature" Acceptable Great Market Market Bad Market $250.000 $100,000 -$225.000 $170,000 $50,000 - 100.000 $125,000 $25,000 -$40,000 $0 $0 $0 Using the above information, construct an Excel sheet to analyze the following alternatives. For each scenario, what is the best alternative and resulting payoff? Please write your an- swers below and submit your Excel spreadsheet to Canvas. a. Optimistic - (Maximax) -(10 points) b. Pessimistic - (Maximin) -(10 points) c. Criterion of Realism (a = 0.60) - Perform all of the manual calculations for this sce- nario below. (i.e., write out the mathematical equation and show your work in addi- tion to uploading the Excel spreadsheet to Canvas). (20 points)