Question 1. Investor Group specialized in recommending long-term financial portfolios for wealthy clients. One such client wishes to invest $750,000 in the following bonds

The client has made the following specifications: 1) At least 50% should be invested in long-term bonds (maturing in 10+ years). 2) No more than 35% can be invested in DynaStar, Eagle Vision, and OptiPro. a) Formulate a LP model to maximize the annual return. b) Solve the model with the Excel Solver and attach your solution from Excel

Annul Return Company Years to Maturity Rating Acme chemical 8.65% 17 1-Excellent DynaStar 9.50% 3-Good Eagle Vision 10.00% 4-Fair Micro Modeling 8.75% 1-Excellent OptiPro 9.25% 3-Good Sabre Systems 9.00% 2-Very Good Annul Return Company Years to Maturity Rating Acme chemical 8.65% 17 1-Excellent DynaStar 9.50% 3-Good Eagle Vision 10.00% 4-Fair Micro Modeling 8.75% 1-Excellent OptiPro 9.25% 3-Good Sabre Systems 9.00% 2-Very Good