In the pension fund problem, you know that if the amount of money allocated initially is less than the amount found by Solver, James will not be able to meet all of the pension fund payments. Use the current model to demonstrate that this is true. To do so, enter a value less than the optimal value in cell B16. Then run Solver, but remove the Money_allocated cell as a changing cell and as the objective cell. What do you find?
Answer to relevant QuestionsContinuing 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 ...In the capital budgeting model in Figure 14.40, investment 4 has the largest ratio of NPV to cash requirement, but it is not selected in the optimal solution. How much NPV is lost if Tatham is forced to select investment 4? ...In the optimal solution to the Great Threads model, the labor hour and cloth constraints are both binding—the company is using all it has. a. Use SolverTable to see what happens to the optimal solution when the amount of ...In the Great Threads model, we found an upper bound on production of any clothing type by calculating the amount that could be produced if all of the resources were devoted to this clothing type.a. What if you instead use a ...A bus company believes that it will need the following numbers of bus drivers during each of the next five years: 60 drivers in year 1; 70 drivers in year 2; 50 drivers in year 3; 65 drivers in year 4; 75 drivers in year 5. ...
Post your question