The Clark County Sheriff's Department schedules police officers for 8-hour shifts. The beginning times for the shifts are 8:00 a.m., noon, 4:00 p.m., 8:00 p.m., midnight, and 4:00 a.m. An officer beginning a shift at one of these times works for the next 8 hours. During normal weekday operations, the number of officers needed varies depending on the time of day. The department staffing guidelines require the following minimum number of officers on duty: Time of Day Minimum No. of Officers on Duty 8:00 a.m.-noon 7 Noon-4:00 p.m. 4:00 p.m.-8:00 p.m. 7 8:00 p.m.-midnight 7 Midnight-4:00 a.m. 4 4:00 a.m.-8:00 a.m. 6 Determine the number of police officers that should be scheduled to begin the 8-hour shifts at each of the six times to minimize the total number of officers required. If your answer is zero, enter "0". Starting Time Officers Starting 8:00 a.m. 3 Noon 4:00 p.m. 7 8:00 p.m. Midnight 4:00 a.m.

The Clark County Sheriff's Department schedules police officers for 8-hour shifts. The beginning times for the shifts are 8:00 a.m., noon, 4:00 p.m., 8:00 p.m., midnight, and 4:00 a.m. An officer beginning a shift at one of these times works for the next 8 hours. During normal weekday operations, the number of officers needed varies depending on the time of day. The department staffing guidelines require the following minimum number of officers on duty: Time of Day Minimum No. of Officers on Duty 8:00 a.m.-noon 7 Noon-4:00 p.m. 4:00 p.m.-8:00 p.m. 7 8:00 p.m.-midnight 7 Midnight-4:00 a.m. 4 4:00 a.m.-8:00 a.m. 6 Determine the number of police officers that should be scheduled to begin the 8-hour shifts at each of the six times to minimize the total number of officers required. If your answer is zero, enter "0". Starting Time Officers Starting 8:00 a.m. 3 Noon 4:00 p.m. 7 8:00 p.m. Midnight 4:00 a.m.

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...

See similar textbooks

Similar questions

JOHNSON’S RULE Five specialty jobs at a La Crosse, Wisconsin, tool and die shop must be processed through two workcenters (drill press and lathe). The time for processing each job follows:Work (processing) Time for Jobs (hours)JOBWORK CENTER 1(DRILL PRESS) WORK CENTER 2(LATHE)A5 2B3 6C8 4D 10 7E 7 12
BE Spreadsheet Mike Reynolds has four assignments due in class tomorrow, and his class times are as follows: Time 9 a.m. 12 p.m. 2 p.m. 5:30 p.m. Each class lasts one hour, and Mike has no other classes. It is now midnight, and Mike estimates that the marketing, finance, psychology, and OM assignments will take him one, four, five, and seven hours, respectively. Assume that all time till the last class begins can be spent on completing assignments but each assignment should be done till the time of the class on the same subject. (Mike can prepare assignments for the next classes during previous classes.) Use the Excel Sequencing template to determine how he should schedule the work. Use minus sign to enter negative lateness values, if any. Enter the half an hour value as 0.5, e.g., 3:30 p.m. should be entered as 15.5. If your answer is zero, enter "0". Round your answers for the due date, lateness, and tardiness to one decimal place. Round your answers for the average values to two…
Five jobs are waiting for processing through two work centers. Their processing time (in minutes) at each work center is contained in the table below. Each job requires work center Sigma before work center Delta. According to Johnson's rule, what sequence of jobs will minimize the completion time for all jobs? Job Sigma Delta R 20 10 S 25 30 T 30 20 U 35 35 V 15 25 Part 2 A. V−S−U−T−R B. V−R−U−S−T C. R−V−T−S−U D. S−U−T−V−R E. R−S−T−U−V
A consulting company must hire 15 new associates per year to replace those who haveleft the company for other positions or have retired. The company employs 120 associates overall. How long is the average associate employed at the consulting company?
Lee Beedo, a hip bachelor in Edmond, has a date for Saturday night and finds himself without a thing to wear. Faced with the daunting task of doing enough laundry to fully accessorize during his night out, Lee has sorted his clothes into loads according to fabric and color. Based on his vast experience doing laundry, Lee knows how long each load will take in both the washer and the dryer. He glances at his watch; it is now 2:00 p.m. and he has to have the last load dry by 8:30 p.m. to be there in time. Help Lee develop a schedule that will enable him to make his date on time and depict that schedule using a Gantt chart. Can he make it and, if so, by how much?
Using the FCFS rule for scheduling, the sequence is 1-2-3 3-2-1 1-3-2 2-1-3 2-3-1 3-1-2 Sunny Park Tailors has been asked to make three different types of wedding suits for separate customers. The table below highlights the time taken in hours for cutting and sewing (process 1) and delivery (process 2) of each of the suits. Times Taken for Different Activities (hours) Suit Cut and Sew Deliver 2 2 3 4 7 6 7 5 Assume that orders for suits have been listed in the above table in the order in which they were received.
Joan has a small design and tailoring shop making custom outfits for women. She has two employees. Each employee only begins working on a dress when a customer order has been received and then she makes the dress from beginning to end. The average production time of a dress is 1.8 days, with a standard deviation of 2.1 days. Historically, Joan has been receiving orders with interarrival times of one day on average. The interarrival times of orders have a coefficient of variation of one. (Carry at least 4 decimal places in all intermediate calculations. Round your final answer to 2 decimal places.) What is the expected waiting time, in days, between when an order is received and when production begins on the dress? A. 9.12 days B. 6.50 days C. 1.23 days D.3.41 days
A manufacturing plant produces a product 'A' that requires one unit of 'B' and ½ unit of 'C'. Each unit of 'B' is comprised of one unit of 'D', two units of 'E', and one unit of 'F'. Each unit of 'C' requires ½ unit of 'G' and three units of 'H'. The manufacturing lead times for the components are as follows: 'A' - two weeks, 'B' - one week, 'C' - two weeks, 'D' - two weeks, 'E' - three weeks, 'F' - one week, 'G' - two weeks, 'H' - one week. There are 20 units in stock for each of these components. 100 units of 'A' are needed for delivery in seven weeks: a) Develop the product structure and indexed bill of materials for the product. b) Create a gross and net requirements plan for the manufacturer of the product.
The Cove is a midsized furniture store. Sales staff are assigned standard shifts (1st shift usually takes place between the hours of 9 a.m. and 5 p.m. 2nd shift is worked between 5 p.m. and 1 a.m. 3rd shift typically takes place between the hours of 12 a.m. and 8 a.m.), and the number of customers arriving per shift averages 40, Poisson distributed. A salesperson can deal with one customer in 5 minutes on average and costs the company $100 per shift in salaries and fringe benefits. Service times closely follow an exponential distribution. The manager is reviewing the number of salespersons to schedule for each shift. The cost of customers waiting before they receive service has been estimated at $2 per minute in terms of lost sales and loss of goodwill. a. If management wants to minimize the cost of both sales staff and customer wait times, how many salespersons should be working in each shift? b. What is the cost per shift to the company if they use the number of salespersons you…
Using the FCFS rule for scheduling, the sequence is Sunny Park Tailors has been asked to make three different types of wedding suits for separate customers. The table below highlights the time taken in hours for cutting and sewing (process 1) and delivery (process 2) of each of the suits Times Taken for Different Activities (hours) Cut and Sew Suit 1 2 3 7 4 5 Deliver 2 3 6 Assume that orders for suits have been listed in the above table in the order in which they were received. C
Lee Beedo, a hip bachelor in Edmond, has a date for Saturday night and finds himself without a thing to wear. Faced with the daunting task of doing enough laundry to fully accessorize during his night out, Lee has sorted his clothes into loads according to fabric and colour. Based on his vast experience doing laundry, Lee knows how long each load will take in both the washer and the dryer. He glances at his watch; it is now 2:00 p.m. and he has to have the last load dry by 8:30 p.m. to be there in time. Help Lee develop a schedule that will enable him to make his date on time and depict that schedule using a Gantt chart. Can he make it and, if so, by how much? Load Wash Time (hrs.) Dry Time (hrs.) Polyesters 0.50 0.75 Leathers 2.00 1.50 Whites 0.75 1.25 Unmentionables 1.00 1.25 Silks 0.50 0.25
An order for 200 units of a product is processed on work centers A and B. The set up time on A is 45 minutes and the run time is 5 minutes per piece. The set up time on B is 40 minutes and the run time is 8 minutes per piece. The wait time between the two operations is 2 hours. The move time between A and B is 15 minutes. Wait time after operation B is 1 hour and the move time into stores is 50 minutes. There is no queue at either work station. Calculate the total manufacturing lead time for the order.