please show all formulas, values and run solver

An investment company currently has $1 million available for investment in five different stocks. The company wants to maximize the interest carned over the next year. The five investment possibilities along with the expected interest camed are shown below. To manage risk, the investment firm wishes to have at least 35% of the investment in stocks A and B. Furthermore, no more than 15% of the investment may be in stock E. Formulation: Max0.07A+0.09B+0.08C+0.10D+0.11E Subject to: Constraint 1:A+B+C+D+E1,000,000 Constraint 2: A +B350,000 Constraint 3: E150,000 A,B,C,D,E0 Part A) (10 points) Use the Sensitivity Report to answer the following questions: a. What is the optimal total expected interest camed for next year? b. What is the dollar amount that should be invested in cach stock? c. Which constraints are binding? Which constraints are not binding? d. Is the solution to the problem unique or are there alternate optimal solutions? c. Does the optimal solution call for investing the entire $1,000,000 ? Part B) (20 points) Use the Sensitivity Report to answer the following questions: a. What would be the impact on the optimal allocation if the expected interest carned on stock A decreases to 6% ? b. What would be the impact on the optimal allocation if the expected interest earned on stock A increases to 10% ? c. What should the minimal expected interest earned for stock C be before it would be desirable to invest in this particular stock? d. What would be the impact on the optimal allocation and the objective function value if the expected interest carned on stock B decreases by 1% ? Part C) (20 points) Use the Sensitivity Report to answer the following questions: a. Suppose that the amount of money available for investment increases by $50,000. What impact would this have on the current optimal objective function value? b. Suppose that total investment in stocks A and B must be at least 40% of the total amount available for investment (i.c., $400,000 ). What impact would this have on the current optimal objective function value? c. Suppose that the total investment in stocks A and be must be at least 30% of the total amount available for investment. What impact would this have on the current optimal objective function value? d. Assume that no more than 30% of the investment may be in stock E. What impact would this have on the current optimal objective function value