From the text, do the following problems: Ch. 10, #9 all parts Hints: - 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. |

Subject | Business |

Due By (Pacific Time) | 10/03/2013 12:00 am |

Tutor | Rating |
---|---|

pallavi Chat Now! |
out of 1971 reviews More.. |

amosmm Chat Now! |
out of 766 reviews More.. |

PhyzKyd Chat Now! |
out of 1164 reviews More.. |

rajdeep77 Chat Now! |
out of 721 reviews More.. |

sctys Chat Now! |
out of 1600 reviews More.. |

sharadgreen Chat Now! |
out of 770 reviews More.. |

topnotcher Chat Now! |
out of 766 reviews More.. |

XXXIAO Chat Now! |
out of 680 reviews More.. |