The SweetTooth Candy Company knows it will need 10 tons of sugar 6 months from now to implement its production plans. Jean Dobson, SweetTooth’s purchasing manager, has essentially two options for...

The SweetTooth Candy Company knows it will need 10 tons of sugar 6 months from now to implement its production plans. Jean Dobson, SweetTooth’s purchasing manager, has essentially two options for acquiring the needed sugar. She can either buy the sugar at the going market price when she needs it, 6 months from now, or she can buy a futures contract now. The contract guarantees delivery of the sugar in 6 months, but the cost of purchasing it will be based on today’s market price. Assume that possible sugar futures contracts available for purchase are for 5 tons or 10 tons only. No futures contracts can be purchased or sold in the intervening months. Thus, SweetTooth’s possible decisions are (1) purchase a futures contract for 10 tons of sugar now, (2) purchase a futures contract for 5 tons of sugar now and purchase 5 tons of sugar in 6 months, or (3) purchase all 10 tons of needed sugar in 6 months. The price of sugar bought now for delivery in 6 months is $0.0851 per pound. The transaction costs for 5-ton and 10-ton futures contracts are $65 and $110, respectively. Finally, Ms. Dobson has assessed the probability distribution for the possible prices of sugar 6 months from now (in dollars per pound). The file P10_35.xlsx contains these possible prices and their corresponding probabilities.

a. Given that SweetTooth wants to acquire the needed sugar in the least costly way, create a cost table that specifies the cost (in dollars) associated with each possible decision and possible sugar price in the future.

b. Use PrecisionTree to identify the decision that minimizes SweetTooth’s expected cost of meeting its sugar demand.

c. Perform a sensitivity analysis on the optimal decision and summarize your findings. In response to which model inputs is the expected cost value most sensitive?