How would I set this problem up in Excel using the solver
You are the district manager for the NCDNR aka the Game Wardens. You staff your law enforcement officers such that they have a 10 hour work day in a single shift. This means that they work 4 days in a row and have 3 consecutive days off. For your district, you need to make sure that you have at least: 10 working on Saturday, 0 on Sunday, 3 on Monday, 3 on Tuesday, 5 on Wednesday, 4 on Thursday, and 8 on Friday. Your current compensation plan approved by the state is: Days off M,T,W T,W, Th W, Th, F Th,F, Sa F,Sa,Su Sa, Su,M Su, M, T Wage 3000 2900 2820 2750 2600 2700 2720 Questions: What is the objective function value? How many employees do you have? How many people show up for work on Sunday, despite this not being necessary according to the scheduling requirements?
This question was created from LP Practice - Scheduling - Game Wardens
372,107 students got unstuck by Course
Hero in the last week
Our Expert Tutors provide step by step solutions to help you excel in your courses