Non-linear programming problem find minimum profit using excel
Not what you're looking for?
The personel director of a company that recently absorebd another firm and is now downsizing and must relocate five information specialist from recently closed locations . Unfortunately, there are only three positiins available for five people. Salaries are fairly uniform among this group ( those with higher pay were already given the opportunites to begin anew). Moving expenses will be used as the means of determining who will be sent there. Estimated moving expenses are
MOVING COST TO
Analyst gary salt lake city Fresno
ARLENE $8500 $6000 $5000
BOBBY $5000 $8000 $12000
CHARLENE $4000 $14000 $ 17000
DOUGLAS $4000 $8000 $13000
EMORY $7000 $3500 $4500
Model this as an integer optimization model to minimize cost and determine which analysts to relocate to the three locations
Purchase this Solution
Solution Summary
The solution gives detailed steps on solving a non-linear programming problem to find minimum profit using excel solver.
Solution Preview
Please check attachment
Answer:
Let Xij be ith analyst assigened to jth location.
We want to minimize Z= such ...
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.
Probability Quiz
Some questions on probability
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
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.