Question: c) (5 points) How much should MacDonald pay to acquire another acre-ft of water? d) (5 points) What happens to the optimal plan if the


c) (5 points) How much should MacDonald pay to acquire another acre-ft of water? d) (5 points) What happens to the optimal plan if the profit from wheat triples (\$360/acre)? What happens to the optimal profit? e) (5 points) MacDonald can lease another plot of land (50 acres). How much would the profit increase if he leases this land? Would he need more than 1000 acre-ft of water to use the additional land? -) Excel Answer Report: Target Cell (Max) Aniizatakia ralla -) Excel Sensitivity Report Adiustable Cells Constraints c) (5 points) How much should MacDonald pay to acquire another acre-ft of water? d) (5 points) What happens to the optimal plan if the profit from wheat triples (\$360/acre)? What happens to the optimal profit? e) (5 points) MacDonald can lease another plot of land (50 acres). How much would the profit increase if he leases this land? Would he need more than 1000 acre-ft of water to use the additional land? -) Excel Answer Report: Target Cell (Max) Aniizatakia ralla -) Excel Sensitivity Report Adiustable Cells Constraints
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
