From the text, do the following problems:
Ch. 10, #9 all parts
- This problem looks a lot like example 10.18 from the text and you should be able to use the Excel formulation with minimal modifications.
- The problems from chapter 10 require non-linear optimization, as you might guess from the title of the chapter! Unfortunately, non-linear optimization doesn't always play "nice" and I've had different experiences with these problems with different versions of Solver. If you start with zeroes in the decision variable cells, you may get weird results - if that happens, try starting values that are close to what you would expect the results to be.
Ch. 11, #2, plus, run the sensitivity report and use it to answer the following questions:
- By how much (and in which direction) would the price of fertilizer A have to change before the solution changes?
- If your groundskeeper decides that the phosphorous requirement has to be increased to 16 pounds, how does the total cost of the optimum solution change?
Ch. 11, #5, all parts. This, like the problem above, calls for linear optimization, so use Simplex LP Solver for both. It would be quite easy to set this up so that it was not actually linear, so be careful! Specifically, this means that you should set market potential as a constraint, not something to be embedded in the objective function.