Investment Advisors, Inc., is a brokerage firm that manages stock portfolios for a number of clients. A particular portfolio consists of U shares of U.S. Oil and H shares of Huber Steel. The annual return for U.S. Oil is $3 per share and the annual return for Huber Steel is $5 per share. U.S. Oil sells for $25 per share and Huber Steel sells for $50 per share. The portfolio has $80 , 000 to be invested. The portfolio risk index ( 0.50 per share of U.S. Oil and 0.25 per share for Huber Steel) has a maximum of 700. In addition, the portfolio is limited to a maximum of 1000 shares of U.S. Oil. The linear programming formulation that will maximize the total annual return of the portfolio is as follows: 1. Spreadsheet Model with Solver setup 2\% 2. User Interface (be sure to set Object Properties as appropriate) 2\% 3. VBA Code to link Model and Interface 2% 4. VBA Code for Formatting 2% 5. VBA Code for Error Trapping 2% Investment Advisors, Inc., is a brokerage firm that manages stock portfolios for a number of clients. A particular portfolio consists of U shares of U.S. Oil and H shares of Huber Steel. The annual return for U.S. Oil is $3 per share and the annual return for Huber Steel is $5 per share. U.S. Oil sells for $25 per share and Huber Steel sells for $50 per share. The portfolio has $80 , 000 to be invested. The portfolio risk index ( 0.50 per share of U.S. Oil and 0.25 per share for Huber Steel) has a maximum of 700. In addition, the portfolio is limited to a maximum of 1000 shares of U.S. Oil. The linear programming formulation that will maximize the total annual return of the portfolio is as follows: 1. Spreadsheet Model with Solver setup 2\% 2. User Interface (be sure to set Object Properties as appropriate) 2\% 3. VBA Code to link Model and Interface 2% 4. VBA Code for Formatting 2% 5. VBA Code for Error Trapping 2%