(Book is Business Analytics: Methods, Models, and Decisions, Second Edition by Jim Evans)
Review the retirement-planning situation described in Chapter 11 (Example 11.11). Modify the spread- sheet to include the assumptions that the annual salary increase is triangular with a minimum of 1%, most likely value of 3%, and maximum value of 5%, and that the annual investment return is triangular with minimum of 5%, most likely value of 8%, and maximum value of 9%. Use Analytic Solver Platform to find the distribution of the ending retirement fund balance under these assumptions. How do the results compare with the base case?