Determine the best supplier for company using expected value- Operation Management

Determine the best supplier for company using expected value- Operation Management

Leevi Starch in Problem S1-7 estimates that the probabilities of future global changes in oil prices are 0.09 that they will decrease, 0.27 that they will remain the same, and 0.64 that they will decrease. a. Determine the best supplier for the company using expected value. b. If the company wants to hire an energy analyst to help it determine more accurately what future oil prices will do, what is the maximum amount it should pay the analyst? Can you please show all of your working for the answer? I will like to learn and fully understand how to solve the problem. Oil Prices Supplier Decrease Same Increase China $2.70 $3.90 $6.30 India 2.1 3.8 6.5 Phillipines 1.7 4.3 6.1 Brazil 3.5 4.5 5.7 Mexico 4.1 5.1 5.4 I need the formula to plug it into excel.

Order from us and get better grades. We are the service you have been looking for.