View the step-by-step solution to:

Question

This question was created from LP Practice - Scheduling - Game Wardens https://www.coursehero.com/file/12195603/LP-Practice-Scheduling-Game-Wardens/

12195603-351897.jpeg

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

12195603-351897.jpeg

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?

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes