Solve this problem using Excel Solver or Excel QM, please include your personal insights or conclusions.

$: 9-27 The hospital administrator at St. Charles General must appoint head nurses to four newly established depart- ments: urology, cardiology, orthopedics, and obstetrics In anticipation of this staffing problem, she had hired four nurses: Hawkins, Condriac, Bardot, and Hoolihan Believing in the quantitative analysis approach to prob- lem solving, the administrator has interviewed each nurse; considered his or her background, personality, and talents; and developed a cost scale ranging from 0 to 100 to be used in the assignment. A 0 for Nurse Bar- dot being assigned to the cardiology unit implies that she would be perfectly suited to that task. A value close to 100, on the other hand, would imply that she is not at all suited to head that unit. The table below gives the complete set of cost figures that the hospital adminis- trator felt represented all possible assignments. Which nurse should be assigned to which unit? DEPARTMENT NURSE UROLOGY CARDIOLOGY ORTHOPEDICS OBSTETRICS Hawkins 28 18 15 75 Condriac 32 4 8 23 Bardot 51 36 24 36 Hoolihan 25