The prospectus of an investment fund states that all money is to be invested in bonds that are rated A, AA, and AAA. No more than 30% of the total investment is in A and AA bonds collectively, and at least 50% is in AA and AAA bonds collectively. The A, AA, and AAA bonds have annual yields of 8%, 7%, and 6% respectively. Determine (a) the percentages of the total investment that should be committed to each type of bond, so that the fund maximizes its annual yield, and (b) the annual yield. Provide your answers as percentages, rounded to 1 decimal point (e.g. 10.0%). Use the Excel linear programming template which has been provided, or create your own LP model in Excel. Note that in order to receive full marks, your solution must be provided in Excel, and must be solved using Excels Solver Add-in.

Template Definitions F(x) Define function 1 Define variable 1 2 Define variable 2 3 Define variable 3 4 Define variable 4 5 Define variable 5 Variables Objective Function Objective Function Coefficients Values 0.0 - Solution for function F(x) Sign LHS 0.0 0.0 Equation 1 Equation 2 Equation 3 Equation 4 Equation 5 Equation 6 Equation 7 Equation 8 Equation 9 Equation 10 Constraints Constraint 1 Constraint 2 Constraint 3 Constraint 4 Constraint 5 Constraint 6 Constraint 7 Constraint 8 Constraint 9 Constraint 10 " " " V V IIIIIIVVV!!!! V V X X 0.0 0.0 0.0 Template Definitions F(x) Define function 1 Define variable 1 2 Define variable 2 3 Define variable 3 4 Define variable 4 5 Define variable 5 Variables Objective Function Objective Function Coefficients Values 0.0 - Solution for function F(x) Sign LHS 0.0 0.0 Equation 1 Equation 2 Equation 3 Equation 4 Equation 5 Equation 6 Equation 7 Equation 8 Equation 9 Equation 10 Constraints Constraint 1 Constraint 2 Constraint 3 Constraint 4 Constraint 5 Constraint 6 Constraint 7 Constraint 8 Constraint 9 Constraint 10 " " " V V IIIIIIVVV!!!! V V X X 0.0 0.0 0.0