Explore BrainMass
Share

Explore BrainMass

    Non-linear programming problem find minimum profit using excel

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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 October 10, 2019, 8:24 am ad1c9bdddf
    https://brainmass.com/math/optimization/non-linear-programming-problem-minimum-profit-excel-624193

    Solution Preview

    Please check attachment

    Answer:

    Let Xij be ith analyst assigened to jth location.

    We want to minimize Z= such ...

    Solution Summary

    The solution gives detailed steps on solving a non-linear programming problem to find minimum profit using excel solver.

    $2.19