Use Solver to create Answer and Sensitivity Reports for question 24 at the end of chapter 2

Question:

Use Solver to create Answer and Sensitivity Reports for question 24 at the end of chapter 2 and answer the following questions:

a. How much can the price of watermelons drop before it is no longer optimal to plant any watermelons?
b. How much does the price of cantaloupes have to increase before it is optimal to only grow cantaloupes?
c. Suppose the price of watermelons drops by $60 per acre and the price of cantaloupes increases by $50 per acre. Is the current solution still optimal?
d. Suppose the farmer can lease up to 20 acres of land from a neighboring farm to plant additional crops. How many acres should the farmer lease and what is the maximum amount he should pay to lease each acre?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: