Using the provided template, show the steps to get the solution. During each four-hour period, the Smalltown police force requires the following number of on-duty police officers: four from midnight to 4 a.m.; four from 4 a.m. to 8 a.m.; seven from 8 a.m. to noon; seven from noon to 4 p.m.; eight from 4 p.m. to 8 p.m.; and ten from 8 p.m. to midnight. Each police officer works two consecutive four-hour shifts. a. Determine how to minimize the number of police of- ficers needed to meet Smalltown’s daily requirements. b. Use SolverTable to see how the number of police officers changes as the number of officers needed from 8 a.m. to noon varies from 4 to 10.
Using the provided template, show the steps to get the solution. During each four-hour period, the Smalltown police force requires the following number of on-duty police officers: four from midnight to 4 a.m.; four from 4 a.m. to 8 a.m.; seven from 8 a.m. to noon; seven from noon to 4 p.m.; eight from 4 p.m. to 8 p.m.; and ten from 8 p.m. to midnight. Each police officer works two consecutive four-hour shifts. a. Determine how to minimize the number of police of- ficers needed to meet Smalltown’s daily requirements. b. Use SolverTable to see how the number of police officers changes as the number of officers needed from 8 a.m. to noon varies from 4 to 10.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Using the provided template, show the steps to get the solution.
During each four-hour period, the Smalltown police force requires the following number of on-duty police officers: four from midnight to 4 a.m.; four from 4 a.m. to 8 a.m.; seven from 8 a.m. to noon; seven from noon to 4 p.m.; eight from 4 p.m. to 8 p.m.; and ten from 8 p.m. to midnight. Each police officer works two consecutive four-hour shifts.
a. Determine how to minimize the number of police of- ficers needed to meet Smalltown’s daily requirements.
b. Use SolverTable to see how the number of police officers changes as the number of officers needed from 8 a.m. to noon varies from 4 to 10.
Transcribed Image Text:X ✓
A
1 Police force scheduling
2
3
4
5 Number starting
6
Number available
7 each 4-hour period
8
9 Number required
10
11 Total employed
12
13
LO
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
30*
34
35
36
37
38
Ready
P4-46
B
fx
M-4A
P4-48
*
JUN
21
C
D
E
Starting 4 hours of 8-hour shift
8A-N
N-4P
P4-50 part B
4A-8A
P4-50
F
4P-8P
P4-50 part C
G
8P-M
P4-50 part D
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 7 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.