In: Operations Management
The daily requirements for patrol officers are: Monday:4 officers Tuesday:5 officers Wednesday:6 officers Thursday:7 Officer Friday:10 Officers Saturday:9 officers Sunday:9 officers Question: Each officer works 5 days a week and must have 2 consecutive days off. You are scheduling officers to work the appropriate days of the week. The second officer you schedule is to work which days of the week?
We will excel solver to find the schedule of work -
Below is the screenshot of the LP table -
Below is the screenshot of the formula applied -
Below is the screenshot of the solver -
Below is the screenshot of the result -
First 2 employees will start work on Tuesday.
Next 4 employees will start work on Wednesday
Next 2 employees will start work on Thursday
Next 2 employees will start work on Friday
Next 1 employees will start work on Sunday