Purchase Solution

Linear programming model for a work schedule.

Not what you're looking for?

Ask Custom Question

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 top weekends:

Day Sun. Mon. Tue. Wed. Thurs. Fri. Sat.
Assignments 6 4 4 4 5 5 6

Develop a weekly work shift schedule of duty hours 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.

Purchase this Solution

Solution Summary

This solution develops a weekly work shift schedule.

Solution Preview

Assume x1 officers take Sunday, Monday off, x2 officers take Monday Tuesday off, x3 officers takeTuesday Wednesday off, x4 officers take Wednesday ...

Purchase this Solution


Free BrainMass Quizzes
Probability Quiz

Some questions on probability

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts