In the pension fund problem, if the amount of money initially is less than the amount found by Solver, then 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 into cell B16. Then run Solver, but remove the Money_allocated cell as a changing cell and as the target cell. (If there is no target cell, Solver simply tries to find a solution that satisfies all of the constraints.) What do you find?
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here