The sheriff has been asked by the county commissioners to increase weekend patrols in the lake...

Transcribed Image Text:

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: Day Sun. Mon. Tues. Wed. Thurs. Fri. Sat. Assignments 6 4 4 4 5 5 6 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. 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: Day Sun. Mon. Tues. Wed. Thurs. Fri. Sat. Assignments 6 4 4 4 5 5 6 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.