Problem 1: Assignment Problem (20 points) The hospital administrator at Riverside 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: Hopkins, Berry, Clooney, and Estephan. Believing in the decision modeling approach to problem solving (i.e., prescriptive analytics), the administrator has interviewed each nurse, considered his or her background, personality, and talents, and developed a cost scale ranging from 0 to 100 points rating to be used in the assignment. A 0 for Nurse Berry being assigned to the cardiology unit implies that she/he would be perfectly suited for that task. A value close to 100, on the other hand, would imply that she/he is not at all suited to head that unit. The table below gives the complete set of cost (i.e., rating) figures that the hospital administrator felt represented all possible assignments. Which nurse should be assigned to which unit? Nurse Hopkins Berry Clooney Estephan Urology 28 32 31 25 Department Cardiology Orthopedics 18 15 48 23 36 24 38 55 Obstetrics 75 38 36 12 . a. Define the decision variables of this problem. (3 points) b. Provide the algebraic formulation of the objective function. (2 points) c. Formulate this problem as an Assignment Model" on a spreadsheet and use Excel's Solver to determine which nurse should be assigned to which unit and the optimal rating. (Provide the corresponding Excel Spreadsheet" and the "Answer Report"). Include "managerial statements that communicate the results of the analyses (i.e. describe verbally the results). (15 points)