Refer to Example A.5.

1. Solve this personnel scheduling problem using Excel Solver. What are the optimum solution values?

2. Interpret the €œallowable increase€ and €œallowable decrease€ values for the objective function coefficients.

3. Interpret the values of the shadow prices and the €œallowable increase€ and €œallowable decrease€ values for the righthand- side values of the constraints.

Data form example 5

Maureen Nair, hospital administrator for Trinity Hospital, would like to set up a workforce schedule for its registered nurses. Maureen wants a work schedule that will use the minimum number of nurses without affecting the quality of patient care. Nurses are needed for patient care on a continuous, 24-hour basis. Each nurse will work for eight consecutive hours. The minimum number of nurses needed to provide adequate patient care in six four-hour time intervals are provided in the following table:

Transcribed Image Text:

TIME INTERVAL MINIMUM NUMBER OF NURSES REQUIRED 00-04 04-08 22 08-12 12-16 26 16-20 18 20-24 12