May 2021 1 72 Report
Schedule optimization in excel?

I'm wondering if anyone could help me solve this excel model question.

Each officer works five days per week. The crime rate fluctuates with the day of the week, so the number of police officers required each day depends on the day of the week, as follows: Saturday, 28; Sunday, 18; Monday, 18; Tuesday, 24; Wednesday, 25; Thursday, 16; Friday, 21. The police department wants to schedule police officers to minimize the number whose days off are not consecutive. Determine how to accomplish this goal.

Basically I'm looking to set up a model in excel and work out how many optimal solutions there are for this. Any help would be appreciated.


Please enter comments
Please enter your name.
Please enter the correct email address.
You must agree before submitting.

Answers & Comments




Helpful Social

Copyright © 2024 Q2A.MX - All rights reserved.