need help solving on excel

McKinney Q=927 The hospital administrator at St. Charles General m4th appoint head nurses to four newly established depary. ments: urology, cardiology, orthopedics, and obstetrics, In anticipation of this stafring problem, Condriac, Bardot, and Hoolihan, four nurses: Hawkins, Conditie 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 Bardot 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 ahnuld be assigned to which unit? Solution (Written statement of what the decision maker should do)