Blair & Rosen, Inc. (B&R) is a brokerage firm that specializes in investment portfolios designed to meet the specific risk tolerances of its clients. A client who contacted B&R this past week has a maximum of $55,000 to invest. B&R's investment advisor decides to recommend a portfolio consisting of two investment funds: an Internet fund and a Blue Chip fund. The Internet fund has a projected annual return of 12%, while the Blue Chip fund has a projected annual return of 9%. The investment advisor requires that at most $25,000 of the client's funds should be invested in the Internet fund. B&R services include a risk rating for each investment alternative. The Internet fund, which is the more risky of the two investment alternatives, has a risk rating of 5 per thousand dollars invested. The Blue Chip fund has a risk rating of 5 per thousand dollars invested. For example, if $10,000 is invested in each of the two investment funds, B&R's risk rating for the portfolio would be 5(10) + 5(10) = 100. Finally, B&R developed a questionnaire to measure each client's risk tolerance. Based on the responses, each client is classified as a conservative, moderate, or aggressive investor. Suppose that the questionnaire results classified the current client as a moderate investor. B&R recommends that a client who is a moderate investor limit his or her portfolio to a maximum risk rating of 250.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
(c) Suppose that a second client with $55,000 to invest has been classified as an aggressive investor. B&R recommends that the maximum portfolio risk rating for an aggressive
investor is 310. What is the recommended investment portfolio for this aggressive investor?
Internet Fund
= $
55000
Blue Chip Fund = $
Annual Return
= $
6600
(d) Suppose that a third client with $55,000 to invest has been classified as a conservative investor. B&R recommends that the maximum portfolio risk rating for a conservative investor
is 150. Develop the recommended investment portfolio for the conservative investor. If an amount is zero, enter "0".
Internet Fund
= $
Blue Chip Fund = $
55000
Annual Return =
$
4950
Transcribed Image Text:(c) Suppose that a second client with $55,000 to invest has been classified as an aggressive investor. B&R recommends that the maximum portfolio risk rating for an aggressive investor is 310. What is the recommended investment portfolio for this aggressive investor? Internet Fund = $ 55000 Blue Chip Fund = $ Annual Return = $ 6600 (d) Suppose that a third client with $55,000 to invest has been classified as a conservative investor. B&R recommends that the maximum portfolio risk rating for a conservative investor is 150. Develop the recommended investment portfolio for the conservative investor. If an amount is zero, enter "0". Internet Fund = $ Blue Chip Fund = $ 55000 Annual Return = $ 4950
Blair & Rosen, Inc. (B&R) is a brokerage firm that specializes in investment portfolios designed to meet the specific risk tolerances of its clients. A client who contacted B&R this past week
has a maximum of $55,000 to invest. B&R's investment advisor decides to recommend a portfolio consisting of two investment funds: an Internet fund and a Blue Chip fund. The Internet
fund has a projected annual return of 12%, while the Blue Chip fund has a projected annual return of 9%. The investment advisor requires that at most $25,000 of the client's funds
should be invested in the Internet fund. B&R services include a risk rating for each investment alternative. The Internet fund, which is the more risky of the two investment alternatives,
has a risk rating of 5 per thousand dollars invested. The Blue Chip fund has a risk rating of 5 per thousand dollars invested. For example, if $10,000 is invested in each of the two
investment funds, B&R's risk rating for the portfolio would be 5(10) + 5(10) = 100. Finally, B&R developed a questionnaire to measure each client's risk tolerance. Based on the
responses, each client is classified as a conservative, moderate, or aggressive investor. Suppose that the questionnaire results classified the current client as a moderate investor. B&R
recommends that a client who is a moderate investor limit his or her portfolio to a maximum risk rating of 250.
(a) Formulate a linear programming model to find the best investment strategy for this client.
Let I = Internet fund investment in thousands
B = Blue Chip fund investment in thousands
If required, round your answers to two decimal places. If an amount is zero, enter "0". If the constant is "1" it must be entered in the box.
Маx
0.12 I +
0.09 B
s.t.
1 I +
1 B
55
Available investment funds
1 I +
O B
25
Maximum investment in the internet fund
5 I +
5 В
250
Maximum risk for a moderate investor
I, В
(b) Build a spreadsheet model and solve the problem using Solver. What is the recommended investment portfolio for this client?
Internet Fund
= $
27500
Blue Chip Fund = $
27500
What is the annual return for the portfolio?
$
5775
>
VI
Transcribed Image Text:Blair & Rosen, Inc. (B&R) is a brokerage firm that specializes in investment portfolios designed to meet the specific risk tolerances of its clients. A client who contacted B&R this past week has a maximum of $55,000 to invest. B&R's investment advisor decides to recommend a portfolio consisting of two investment funds: an Internet fund and a Blue Chip fund. The Internet fund has a projected annual return of 12%, while the Blue Chip fund has a projected annual return of 9%. The investment advisor requires that at most $25,000 of the client's funds should be invested in the Internet fund. B&R services include a risk rating for each investment alternative. The Internet fund, which is the more risky of the two investment alternatives, has a risk rating of 5 per thousand dollars invested. The Blue Chip fund has a risk rating of 5 per thousand dollars invested. For example, if $10,000 is invested in each of the two investment funds, B&R's risk rating for the portfolio would be 5(10) + 5(10) = 100. Finally, B&R developed a questionnaire to measure each client's risk tolerance. Based on the responses, each client is classified as a conservative, moderate, or aggressive investor. Suppose that the questionnaire results classified the current client as a moderate investor. B&R recommends that a client who is a moderate investor limit his or her portfolio to a maximum risk rating of 250. (a) Formulate a linear programming model to find the best investment strategy for this client. Let I = Internet fund investment in thousands B = Blue Chip fund investment in thousands If required, round your answers to two decimal places. If an amount is zero, enter "0". If the constant is "1" it must be entered in the box. Маx 0.12 I + 0.09 B s.t. 1 I + 1 B 55 Available investment funds 1 I + O B 25 Maximum investment in the internet fund 5 I + 5 В 250 Maximum risk for a moderate investor I, В (b) Build a spreadsheet model and solve the problem using Solver. What is the recommended investment portfolio for this client? Internet Fund = $ 27500 Blue Chip Fund = $ 27500 What is the annual return for the portfolio? $ 5775 > VI
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 7 steps with 9 images

Blurred answer
Knowledge Booster
Optimization models
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.