In the pension fund model, 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?
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.