Please solve all the parts. Please use excel sheet to answer. Upload the screenshot of the excel with answers and formula used. For the written question please type it by computer.

Wil rate the answer for sure. Thanks

Samantha is considering whether she should add an additional sandwich item at her barbeque stand next year. The profit per game will depend on whether the football team had a winning season or not. The possible profits from each possible food item, given a winning season, an average season, and a losing season are shown in the following payoff table: Winning Average Losing Alternatives Season Season Season .55 .2 .25 $202.56 $41.42 $105.64 $475.48 $298.00 $245.25 Probability Barbeque Hot Dogs Pulled Pork Sandwiches Hot Link Sandwiches Frito Chili Pie Hamburgers $200.00 $160.00 $150.00 $767.75 $250.00 $50.00 For each of the decision making criterions, calculate and select the best alternative. 1. Maximax, Maximin, Minimax Regret, Equally Likely, Hurwicz (a = .4) 2. Compute the expected value for each alternative. 3. Develop the opportunity loss table and compute the expected opportunity loss for each product. 4. Determine how much Samantha will be willing to pay a SWOSU MBA student to provide better information about future football seasons. 5. Write an analysis of your calculations and discuss what Samantha should do based on your calculations