Service Management 7th Edition by James Fitzsimmons, Mona Fitzsimmons

Exercise 2

Reconsider Example 11.2 (Hospital Emergency Room) to determine if additional nurses will be required to staff the revised daily shift requirements shown below:

Develop a weekly workshift schedule providing 2 consecutive days off per week for each nurse. Formulate the problem as an integer linear programming model to minimize the number of nurses needed, and solve using Excel Solver. If more nurses are required than the existing staff of eight, suggest an alternative to hiring
full-time nurses.