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© BrainMass Inc. brainmass.com December 24, 2021, 11:57 pm ad1c9bdddf
Please check attachment
Let Xij be ith analyst assigened to jth location.
We want to minimize Z= such ...
The solution gives detailed steps on solving a non-linear programming problem to find minimum profit using excel solver.