Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Pine Investment Group has a budget of $50,000 to invest in three different types of assets: real estate, stocks, and bonds. Each investment provides a

Pine Investment Group has a budget of $50,000 to invest in three different types of assets: real estate, stocks, and bonds. Each investment provides a fixed annual return, as shown in the table below:

Investment Investment Requirements Annual Return
Real Estate $38,500 $4800
Stocks $31,500 $3200
Bonds $15,000 $750

The group wants to determine the optimal selection of investments to maximize the total annual return, subject to the following constraints:

  • The total amount invested cannot exceed the available budget of $50,000.
  • At least two types of investments must be selected to minimize the risk.

Develop a binary linear program to determine the optimal selection of investments that maximizes the total annual return. Please include the decision variables, objective function, and all constraints, and solve the problem using a solver.

What to submit: Final submission must be an Excel file with answers to all of the above questions.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

General Aviation Marketing And Management

Authors: C. Daniel Prather

3rd Edition

9781575243016

More Books

Students also viewed these General Management questions

Question

Define Administration and Management

Answered: 1 week ago

Question

Define organisational structure

Answered: 1 week ago