P/S : Do Not Use Microsoft EXCEL to explain the answers. Please show and explain the answers in WORDS.

You will need to zoom in to look at the questions. If you are using Window OS please hold CTRL and use your mouse wheel to scroll in. If you are using MacOS, please hold Command and use your mouse wheel to scroll in. Thanks

A client of an investment firm has $10,000 available for investment. He has instructed that his money be invested in three stocks so that no more than $5,000 is invested in any one stock but at least $1,000 is invested in each stock. He has further instructed the firm to use its current data and invest in a manner that maximizes his expected overall gain during a one-year period. VARIABLE CURRENT ALLOWABLE COEF INCREASE 10.000000 INFINITY 10.000000 2.500000 25.000000 15.000001 ALLOWABLE DECREASE 3.750000 INFINITY 5.000000 The stocks, the current price per share, and the firm's projected stock price a year from now are summarized in the following table. Stock Current Price Projected Price 1 Year Hence James Industries QM Inc. Delicious Candy Co $25 $50 $100 $35 $60 $125 constraints CURRENT RHS 10000.000000 5000.000000 5000.000000 5000.000000 1000.000000 1000.000000 1000.000000 ALLOWABLE INCREASE 1000.000000 3000.000000 INFINITY INFINITY 4000.000000 3000.000000 3000.000000 MON ALLOWABLE DECREASE 3000.000 1000.000 4000.000 1000.000 INFINITY 1000.000000 INFINITY This problem was formulated as follows: xl=number of shares of James Industries to purchase, x2= number of shares of QM Inc. to purchase, and x3=number of shares of Delicious Candy Co. to purchase. MAX 10x1+10x2+25x3 a.) How many each type of shares they need to buy in order to maximize total gain? What is total gain? b.) If the client had an additional $1000 available for investing how much would the expected overall one-year gain increase? 25x1+50x2+100x3 1000 100x3 > 1000 x1, x2, x3 > 0 ($ available) (max. $ stock 1) (max. $ stock 2) (max. $ stock 3) (min. S stock 1) (min. S stock 2) (min. S stock 3) c) If the client increased the allowed maximum investment amount to $6000 for just one stock? Which one it should be and Why? d) Based on your stock choice in (c) above, how much would the objective function increase? e) Suppose that the return on per share increases from $25 to Sto 35 for Delicious candy. What is the new optimal solution? What is the total gain? OBJECTIVE FUNCTION VALUE 1) 3200.000 VARIABLE X1 X2 VALUE 200 REDUCED COST 0.000000 0.000000 0.000000 X3 Constraints SLACK OR SURPLUS DUAL PRICES 0.0000 0.250000 0.0000 0.150000 4000.00 0.000000 1000.00 0.000000 4000.000 0.000000 0.0000 -0.050000 3000.000 0.000000