****PLEASE SOLVE LP IN EXCEL****

The Strategic Investment Corporation is developing a mix of investments to meet the needs of a client with one million dollars to invest. A mix of five investments is being considered, with data on each as shown below: Average Maximum Minimum Investment Annual Return Investment Investment A 10% 500,000 none B 12% 275,000 none C 16% 250,000 5,000 D 14% 125,000 10,000 E 9% none 5,000 The total average return must be at least 12.5%, all the money must be invested, and investments A and B together must not be over $700,000. Formulate the LP formulation for this problem. ANSWER: X1 = dollars invested in A; X2 = in B; X3 = in C; X4 = in D; X5 = in E