(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 sal-

ary 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