3) A brokerage firm has been tasked with investing $500,000 for a new client. The client has asked that the broker select promising stocks and bonds for investment, subject to the following guidelines: at least 20% in municipal bonds, at least 10% each in real estate and pharmaceutical stock, and at least 40% in a combination of energy and domestic automobile stocks with each accounting for at least 15%. The returns are as follows: Municipal = 5.3%, Domestic Automobile = 8.8%, Energy = 4.9%, Pharmaceuticals = 8.4% and Real Estate = 10.4%. a) Write a linear program complete with objective function and all constraints to Maximize the return. (5 points)   b) What is the optimal solution? Give values for all variables rounded to the nearest cent.(2 points)   c) How much annual income does the optimal solution generate? (2 points)   d) Submit your excel workbook. (2 points)

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 35P
icon
Related questions
icon
Concept explainers
Topic Video
Question

3) A brokerage firm has been tasked with investing $500,000 for a new client. The client has asked that the broker select promising stocks and bonds for investment, subject to the following guidelines: at least 20% in municipal bonds, at least 10% each in real estate and pharmaceutical stock, and at least 40% in a combination of energy and domestic automobile stocks with each accounting for at least 15%. The returns are as follows: Municipal = 5.3%, Domestic Automobile = 8.8%, Energy = 4.9%, Pharmaceuticals = 8.4% and Real Estate = 10.4%.

  1. a) Write a linear program complete with objective function and all constraints to Maximize the return. (5 points)

 

  1. b) What is the optimal solution? Give values for all variables rounded to the nearest cent.(2 points)

 

  1. c) How much annual income does the optimal solution generate? (2 points)

 

  1. d) Submit your excel workbook. (2 points)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 3 images

Blurred answer
Knowledge Booster
Inventory management
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.
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
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