Question: 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

 Develop a weekly workshift schedule providing 2 consecutive days off per

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. The sheriff has been asked by the county commissioners to increase weekend patrols in the lake region during the summer months. The sheriff has proposed the following weekly schedule, shifting deputies from weekday assignments to weekends: Develop a weekly workshift schedule of duty tours, providing 2 consecutive days off per week for each officer. Formulate the problem as an integer linear programming model to minimize the number of officers needed, and solve using Excel Solver

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!