Question: Please help! please use excel for the problem The hospital administrator at St. Charles General must appoint head nurses to four newly established departments: urology,

Please help! please use excel for the problem

Please help! please use excel for the problem The

The hospital administrator at St. Charles General must appoint head nurses to four newly established departments: 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 problem 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 in the assignment. For instance, 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 administrator felt represented all possible assignments. Which nurse should be assigned to which unit? Build and solve a model in excel to find the assignment plan that minimizes the total cost

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!