Question

12195603-351897.jpeg

How would I set this problem up in Excel using the solver

Image transcriptions

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

Subject: Business, Finance
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...
Get unstuck

372,107 students got unstuck by Course
Hero in the last week

step by step solutions

Our Expert Tutors provide step by step solutions to help you excel in your courses