Make up an example, as described in Problem 54, with 20 possible investments. However, do it so

Question:

Make up an example, as described in Problem 54, with 20 possible investments. However, do it so that the ratios of NPV to cash requirement are in a very tight range, from 3.0 to 3.2. Then use Solver to find the optimal solution when the Solver tolerance is set to its default value of 5%, and record the solution. Next, solve again with the tolerance set to zero. Do you get the same solution? Try this on a few more instances of the model, where you keep tinkering with the inputs. The question is whether the tolerance matters in these types of narrow-range problems.

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

Step by Step Answer:

Related Book For  book-img-for-question

Data Analysis And Decision Making

ISBN: 415

4th Edition

Authors: Christian Albright, Wayne Winston, Christopher Zappe

Question Posted: