Numbers File Edit Insert Table Organize Format Arrange View Share Window Help Assignment 2 S02 F20 View 125% Zoom Add Category + Insert Cover page Table Chart Text Question 1 Shape Media Question 2 Comment Oo Collaborate Sheet1 Investment Municipal bonds Real estate stocks Pharmaceutical stocks Energy stocks Domestic automobile stocks Projected Rate of Return (%) 5.5 11 8.2 4.8 8.4 Risk Low High Moderate Low Moderate QUESTION 1 Topic: an LP application in Portfolio selection (14 marks) A brokerage firm has been tasked with investing $500,000 for a new client with the following guidelines: At least 22% of the total amount invested should be in municipal bonds The return from moderate-risk investments must be at least 35% of the return from high-risk investment. At least 15% in energy stocks At least 16% in domestic automobile stocks No more than 60% of the total amount invested should be in real estate stock and domestic automobile stock. The client's goal is to maximize the return on investments. The broker has prepared a list of high-quality stocks and bonds and their corresponding rates of return as shown in the table above. 1) Formulate a linear programming model for this problem. Clearly define the variables, objective function, and constraints. [5]