Purchase Solution

Linear Programming Problem Using Excel Solver

Not what you're looking for?

Ask Custom Question

I need the attached problem done in excel using the built in solver. For this problem we need to come up with our own constraints. If someone could solve it using excel solver I would appreciate it.

In the Middle East water is a critical need. According to a population expert, there are 500 families of tribe A living in a small 300 square mile valley. This number is assumed to be the maximum number the water in the valley can support. A new tribe B invades the valley. According to studies each family fiercely defends a certain amount of territory and will not allow families of the other tribe to intrude. Suppose that a family of tribe A defends 1 square miles and a family of tribe B defends 3 square miles. Suppose further that tribe B uses twice as much water as tribe A. What is the maximum number of families of each tribe that can coexist in the valley.

Attachments
Purchase this Solution

Solution Summary

Linear programming problems using Excel Solvers are determined.

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
Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Probability Quiz

Some questions on probability

Exponential Expressions

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

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts