Make up an example, as described in the previous problem,

Make up an example, as described in the previous problem, with 20 possible investments. However, do it so the ROIs are in a very tight range, such as from 12% to 13%. Then use Solver to find the optimal solution when the Solver Integer Optimality setting is 5%, and record the solution. Next, solve again with the setting at 0%. Do you get the same solution? Try this on a few more instances of the model, where you keep changing the inputs. The question is whether the Integer Optimality setting matters in these types of “close call” problems.

Data from Previous Problem:

Expand and then solve the capital budgeting model in Figure 6.5 so that 20 investments are now possible. You can make up the data on cash requirements, NPVs, and the budget, but use the following guidelines:

• The cash requirements and NPVs for the various investments can vary widely, but the ROIs should be between 10% and 15% for each investment.
• The budget should allow somewhere between 5 and 10 of the investments to be selected.

Figure 6.5:

Contact Us

Enjoy 24/7 customer support for any queries or concerns you have.

Phone: +1 213 3772458

Email: support@gradeessays.com