Mick garcia, a certified financial planner (cfp), has been asked by a client to invest $250,000. this money may be placed in stocks, bonds, or a mutual fund in real estate. the expected return on investment is 13% for stocks, 8% for bonds, and 10% for real estate. while the client would like a very high expected return, she would be satisfied with a 10% expected return on her money. due to risk considerations, several goals have been established to keep the risk at an acceptable level. one goal is to put at least 30% of the money in bonds. another goal is that the amount of money in real estate should not exceed 50% of the money invested in stocks and bonds combined. in addition to these goals, there is one absolute restriction. under no circumstances should more than $150,000 be invested in any one area.
formulate this as a goal programming problem. assume that all of the goals are equally important.
use any available software to solve this problem. how much money should be put in each of the investment options? what is the total return? which of the goals are not met?