blog

Questions/Mathematics/Statistics Sensitivity Analysis Using Excel

Questions/Mathematics/Statistics Sensitivity Analysis Using Excel OsewoldGodidOsewoldGodid Willing to pay \$10.00 Posted 2 years ago Past due An orange grower in Florida faces a dilemma. The weather forecast is for cold weather, and there is a 50% chance that the temperature tonight will be cold enough to freeze and destroy his entire crop, which is worth some \$50,000. He can take two possible actions to try to alleviate his loss if the temperature drops. First he could set burners in the orchard; this would cost \$5000, but he could still expect to incur damage of approximately \$15,000 to \$20,000. Second, he could set up sprinklers to spray the trees. If the temperature drops, the water would freeze on the fruit and provide some insulation. This method is cheaper (\$2000), but less effective. With the sprinklers, he could expect to incur as much as \$25,000 to \$30,000 of the loss with no protective action.

Compare the grower’s expected values for the three alternatives he has, considering the various possible loss scenarios for the burners and the sprinklers. Which alternative would you suggest the grower to take? Why?

Is this the question you were looking for? If so, place your order here to get started!