# Question: Continuing the previous problem in a slightly different direction continue

Continuing the previous problem in a slightly different direction, continue to use the Money_allocated cell as a changing cell, but 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 objective 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 non-smooth, and Solver might have trouble finding the optimal solution. Try it and see.

## Answer to relevant Questions

Solve the following modifications of the capital budgeting model in Figure 14.40. a. Suppose that at most two of projects 1 through 5 can be selected.b. Suppose that if investment 1 is selected, then investment 3 must also ...As it currently stands, investment 7 in the capital budgeting model in Figure 14.40 has the lowest ratio of NPV to cash requirement, 2.5. Keeping this same ratio, can you change the cash requirement and NPV for investment 7 ...In the optimal solution to the Great Threads model, no pants are produced. Suppose Great Threads has an order for 300 pairs of pants that must be produced. Modify the model appropriately and use Solver to find the new ...In the last sheet of the finished version of the Fixed Cost Manufacturing file, we illustrated one way to model the Great Threads problem with IF functions, but saw that this approach doesn’t work. Try a slightly different ...A pharmaceutical company produces the drug NasaMist from four chemicals. Today, the company must produce 1000 pounds of the drug. The three active ingredients in NasaMist are A, B, and C. By weight, at least 8% of NasaMist ...Post your question