A financial advisor is about to build an investment portfolio for a client who has $100,000 to invest. The four investments available are A, B, C, and D. Investment A will earn 4 percent and has a risk of two "points" per $1,000 invested. B earns 6 percent with 3 risk points; C earns 9 percent with 7 risk points; and D earns 11 percent with a risk of 8 . The client has put the following conditions on the investments: A is to be no more than one-half of the total invested. A cannot be less than 20 percent of the total investment. D cannot be less than C. Total points must be at or below 1,000 . 1. Formulate the problem - i.e., write the decision variables, objective function and constraints. 2. Solve the problem, setting it up in Excel and using Solver. A financial advisor is about to build an investment portfolio for a client who has $100,000 to invest. The four investments available are A, B, C, and D. Investment A will earn 4 percent and has a risk of two "points" per $1,000 invested. B earns 6 percent with 3 risk points; C earns 9 percent with 7 risk points; and D earns 11 percent with a risk of 8 . The client has put the following conditions on the investments: A is to be no more than one-half of the total invested. A cannot be less than 20 percent of the total investment. D cannot be less than C. Total points must be at or below 1,000 . 1. Formulate the problem - i.e., write the decision variables, objective function and constraints. 2. Solve the problem, setting it up in Excel and using Solver