Project #13693 - Homework 2

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
Report DMCA
TutorRating
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..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy