Coase Specialty Paints has been quite successful and has $1,500,000 cash to be invested. Ronald and his management team have developed four potential investments in addition to leaving the cash in a low interest deposit. The four new opportunities are:

1. Purchase some shares of a major supplier (30% risk of total loss, 15% potential return)

2. Invest in the research and development of a new product (40% risk of total loss, 60% potential return)

3. Buy a selection of corporate bonds (10% risk of total loss, 5% potential return)

4. Buy a selection of government bonds (1% risk of total loss, 1.5% potential return)

Leaving the money in a low interest deposit is virtually riskless and has a 0.5% potential return.

Richelieus father had provided Ronald with some guidelines for investment, aimed at diversification and risk management. These are:

1. Invest a maximum of 40% of the total cash in any one of the four new opportunities to ensure some risk control.

2. Invest at least $100,000 in each of the four new opportunities to ensure some diversity.

3. Limit the total potential loss, on average, to $300,000, based on the risk factors indicated.

4. Ensure the highest return possible.

Recommend the appropriate mix of the four investments and note how much money, if any, should be left in the low interest deposit. Also, how would this mix change, and what would happen to potential return, if Ronald decided to take a more conservative approach and limit the total potential loss to $150,000.

(Please show the excel pictures thank you! Also state the 1) Decision Variables, 2) Objective Function Equation, 3) Constraints Equations.)