Question
Business Analytics: Optimization, Prediction, and Description * Sergeant Sherwood Roustem is the scheduler for the Campus Police Department. The requirements for on-duty officers for the
Business Analytics: Optimization, Prediction, and Description
- * Sergeant Sherwood Roustem is the scheduler for the Campus Police Department. The requirements for on-duty officers for the next several days is as follows:
|
Time | Minimum Officers Required |
| 2:00 AM 6:00 AM | 22 |
| 6:00 AM 10:00 AM | 55 |
| 10:00 AM 2:00 PM | 88 |
| 2:00 PM 6:00 PM | 110 |
| 6:00 PM 10:00 PM | 44 |
| 10:00 PM 2:00 AM | 33 |
Officers can report for duty at any of the above six time periods and will then remain on duty for 8 consecutive hours.
- Formulate to minimize the number of officers needed to staff each day.
Suppose the officers could be assigned 4 hours of overtime at the end of their normal shift for a 50% increase in wage.
- Add this option to your original formulation.
Not to be done on Excel, work problem by hand.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Auditing For Managers The Ultimate Risk Management Tool
Authors: K. H. Spencer Pickett, Jennifer M. Pickett
1st Edition
0470090987, 978-0470090985
