Set up the problem shown below and use Solver to verify that you will get $5,266.67 in interest per year. You have $120,000 to invest in 4 CDs. The rates are shown in the following table: CDs Amount Invested Interest Rate A $ - 3% B $ - 4% C $ - 4.50% D $ - 5% There is a constraint that the money invested in CD B be exactly twice the amount of money invested in CD A. This means that you can dispense with one of the decision variables. An obvious choice is to pick one of A or B, and just use that. However, other substitutions are also possible and can, under certain circumstances, make the problem easier. Let E=A+B, be a new variable. If you know the value of E, then together with the requirement that B=2A, you can figure out the values of A and B. Using E in place of A and B, what new expression should replace the objective .03A+.04B+.045C+.05D? .07E+.045C+.05D .03bar(6)E+.045C+.05D frac(9E,100)+frac(9C,200)+frac(D,20) .03E+.045C+.05D