Continuing the previous problem in a slightly different direction, continue to use the Money_allocated cell as a

Question:

Continuing the previous problem in a slightly different direction, continue to use the Money_allocated cell as a changing cell, and add a constraint that it must be less than or equal to any value, such as $195,000, that is less than its current optimal value. With this constraint, James will again not be able to meet all of the pension fund payments. Create a new target cell to minimize the total amount of payments not met. The easiest way to do this is with IF functions. Unfortunately, this makes the model nonsmooth, and Solver might have trouble finding the optimal solution. Try it and see.

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

Step by Step Answer:

Related Book For  book-img-for-question

Practical Management Science, Revised

ISBN: 9781118373439

3rd Edition

Authors: Wayne L Winston, S. Christian Albright

Question Posted: