Operation Research

Problem #2.1 (Integer Linear Program): Formulate the following nurse-staffing problems as integer linear programs, i.e., linear programs with further integer constraints on the decision variables. Solve them using the Excel Solver

Part (a): Assume that the hospital hires only full-time nurses, and the nurses begin service at the start of a period and work for 8 consecutive hours.  The hospital wants to determine a work schedule for the typical day that requires the least number of nurses while satisfying the requirements.  Formulate this problem as an integer linear program.  First, ignore the integer requirements. Then, impose the integer requirements and compare the difference.

[pic 1]

2.1 SENSITIVITY REPORT[pic 2]

[pic 3]

ANSWER REPORT 2.1 PART B

[pic 4]

SENSITIVITY 2.1 PART B

): Now assume that the hospital also hires temporary nurses who work four-hour shifts, i.e., part-time, and begin service at the start of a period. Also assume that a full-time nurse costs $20 per hour while a temporary (part-time) nurse costs $14 per hour, and that the cost does not vary with shift.  Formulate an integer linear program to determine how the hospital can minimize the total cost of nurse staffing for the typical day while satisfying the requirements.   First, ignore the integer requirements. Then, impose the integer requirements and compare the difference.

[pic 5]

[pic 6]

SENSITIVITY 2.1 PART C

[pic 7]

ANSWER REPORT 2.1[pic 8]

[pic 9]

ANSWER REPORT 2.1 PART C

[pic 10]

[pic 11]

[pic 12]

 PROB 2.4

[pic 13]

PROB 2.5

[pic 14]

EQUATIONS:

PROB 2.5

...