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.
Copyright © 2024 Q2A.MX - All rights reserved.
Answers & Comments
do a v-lookup (or h-lookup) and assign a number for every day that will represent the number of police officers