I will use Excel Solver for this question, but I am totally lost on how to formulate the Objective Function Z. I provided an example below of the fields needed to enter in Excel Solver. (Decision Variables, Trial Values, Objective Function Z, Constraints). This question involves Linear Programming.

Qu 2. On formulation only: (15 points) (BUT PLEASE NOTE: Extra credit for solution with 10 points) Investment Portfolio Selection Consider the case of 20th Century Funds, Inc. located in Washington D.C. Century decided to invest in a portfolio for a client. Based on prior experience and other information, the financial manager recommended a portfolio of six assets including cash. In coordination with the client, the broker decided on the following list of financial assets. Number Investment type Investment holding period Annual Return (%) Risk measure Growth potential (%) 3 moth treasury bill 1.7 2 Russel 3000 Index 28 290 10 US 10 year Bond 2 19 w UAWN Russel 1000 growth index 34 285 12 One year Saving 1.8 15 ON Cash 0 Source: Bloomberg, January 2020; Investment holding period and Growth potential are approximate estimates. The coefficient of variation of an asset is used as its proxy for its risk measure. The financial manager at Century would like to maximize the return on the portfolio investments for his client with the following restrictions. 1. The average length of the investment for the portfolio should not exceed 10 years. 2. The average risk for the portfolio is at most 200 3. The overall growth potential for the portfolio must be at least 10 percent 4. The client requires the broker to maintain at least 8 percent of the total funds as cash. 5. The total proportions of funds in the portfolio of all assets must add up to 1.0 Use the information given in the question to formulate the Linear Programming problem. Make sure you show the objective function and the constraints defining all the relevant variables