A grapefruit farmer in central Florida is trying to decide whether to take protective action to limit damage to his crop in the event that the overnight temperature falls to a level well below freezing. He is concerned that if the temperature falls sufficiently low and he fails to make an effort to protect his grapefruit trees, he runs the risk of losing his entire crop, which is worth approximately $75,000. Based on the latest forecast issued by the National Weather Service, the farmer estimates that there is a 60% chance that he will lose his entire crop if it is left unprotected. Alternatively, the farmer can insulate his fruit by spraying water on all of the trees in his orchards. This action, which would likely cost the farmer C dollars, would prevent total devastation but might not completely protect the grapefruit trees from incurring some damage as a result of the unusually cold overnight temperatures.

The file P10_68.xlsx contains the assessed distribution of possible damages (in dollars) to the insulated fruit in light of the cold weather forecast. Of course, this farmer seeks to minimize the expected total cost of coping with the threatening weather.

a. Find the maximum value of C below which the farmer will choose to insulate his crop in hopes of limiting damage as result of the unusually cold weather.

b. Set C equal to the value identified in part

a. Perform sensitivity analysis to determine under what conditions, if any, the farmer would be better off not spraying his grapefruit trees and taking his chances in spite of the threat to his crop.