Purchase Solution

Formulate an integer program model using SOLVER to determine which investments to select in order to maximize return.

Not what you're looking for?

Ask Custom Question

Investment Cost Expected Return Condition
1 $200,000.00 $25,000.00 only if 3
2 $1,000,000.00 $100,000.00 not if 1
3 $750,000.00 $150,000.00 none
4 $1,000,000.00 $270,000.00 only if 1 and 3
5 $500,000.00 $300,000.00 not if 3
6 $500,000.00 $100,000.00 none

Formulate an integer program model using SOLVER to determine which investments to select in order to maximize return.

Purchase this Solution

Solution Summary

This solution is comprised of a detailed explanation to determine which investments to select in order to maximize return.

Solution provided by:
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution


Free BrainMass Quizzes
Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Probability Quiz

Some questions on probability

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.