With keeping in mind these numerous constraints, we set a minimum total equity allocation of 56%, as well as a maximum standard deviation of 13.99%. The Solver model came up with a result of 5.17% return, yielding a Sharpe ratio of 0.262, which was a marginal improvement over the current Sharpe ratio of 0.23, while increasing return by 0.90%, representing a 21.08% increase in the overall portfolio return. Weighted Optimal Sharpe Weight Expected Return Weighted Return STDEV STDEV T-Bills 20.00% 1.50% 0.30% 3.50% 0.700000% Mid-Bonds 10.40% 3.50% 0.36% 9% 0.936000% Long-Bonds 1.80% 4% 0.07% 11.50% 0.207000% International Bonds 1.80% 3.20% 0.06% 10% 0.180000% Real Estate 10.00% 5% 0.50% 9% 0.900000% North American Equities 34.20% 6.50% 2.22% 18.50% 6.327000%