How to calculate step by step optimal allocation for this task? I know results (they are given below) but I don't know how to create this in excel. Create really simple and exact answer. You can also put screenshots from Excel how to solve it.

2.4. Selecting a Portiolo A portiolo manager has developed a ist of six investment alternatives for a multiyear horizon. These are: Treasury bills, Common stock, Corporate bonds, Real estate, Growth funds, and Savings and Loans. These investments and their various financial factors are described below. In the table, the length represents the estimated number of years required for the annual rate of return to be realized. The annual rate of return is the expected rate over the multiyear horizon. The risk coefficient is a subjective estimate representing the manager's appraisal of the relative safety of each alternative, on a scale of 10 . The growth potential is also a subjective estimate of the potential increase in value over the horizon. The manager wishes to maximize the annual rate of return on a $3 million portfolio, subject to the following restrictions. The weighted average length should not exceed 7 years. The weighted average risk coefficient should not exceed five. The weighted average growth potential should be at least 10 percent. The investment in real estate should be no more than twice the investment in stocks and bonds (i.e. in CS, CB, and GF) combined. (a) What is the optimal return (as a percentage) and the optimal allocation of investment funds? (b) What is the marginal rate of return? In other words, what would be the return on the next dollar invested, if there were one more dollar in the portfolio? (c) For additional investment beyond the original $3 million, how will the optimal allocation change