Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started