Hatch Financial, which recently absorbed another firm, is now downsizing and must relocate five information systems analysts from recently closed locations. Unfortunately, there are only three positions available for five people. Salaries are fairly uniform among this group (those with higher pay were already given the opportunity to begin anew). Moving expenses will be used as the means of determining who will be sent where. Estimated moving expenses are in the accompanying table. Model this as an integer optimization model to minimize cost and determine which analysts to relocate to the three locations.

To minimize the costs,

Douglas

Arlene

Bobby

Charlene

Emory

should relocate to Gary,

Emory

Douglas

Charlene

Bobby

Arlene

should relocate to Salt Lake City, and

Charlene

Douglas

Arlene

Bobby

Emory

should relocate to Fresno.

AutoSave OFF ... Home Insert Draw Page Layout Formulas Data Review X Calibri 11 V ' Paste BIU a. Av A1 E F G . 1 Analyst 2 Arlene 3 Bobby 4 Charlene 5 Douglas 6 Emory X Vfx Analyst B C D Gary Salt Lake City Fresno 3000 6000 7000 16000 7500 8000 5000 6000 11000 10000 7500 5500 6500 4500 5000 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31