**The Clark County Sheriff’s Department Staffing Schedule**The Clark County Sheriff’s Department schedules police officers for 8-hour shifts. The shifts start at 8:00 a.m., noon, 4:00 p.m., 8:00 p.m., midnight, and 4:00 a.m. Each officer works for 8 consecutive hours. The number of officers needed varies depending on the time of day. **Staffing Requirements:**- **8:00 a.m.–noon:** Minimum of 5 officers- **Noon–4:00 p.m.:** Minimum of 6 officers- **4:00 p.m.–8:00 p.m.:** Minimum of 7 officers- **8:00 p.m.–midnight:** Minimum of 7 officers- **Midnight–4:00 a.m.:** Minimum of 4 officers- **4:00 a.m.–8:00 a.m.:** Minimum of 6 officers**Objective:**Determine the number of police officers that should be scheduled to start their 8-hour shifts at each listed time to minimize the total required number of officers. If a time slot requires no new officers, enter “0” in the field.**Scheduling Template:**- **Starting Time**: - 8:00 a.m. - Noon - 4:00 p.m. - 8:00 p.m. - Midnight - 4:00 a.m.- **Officers Starting**: [Blank fields for input]This exercise involves calculating the optimal distribution of officers across the shift start times to meet the minimum requirements while also ensuring efficiency.

Excel setup: (a) Starting time Number of officers starting 8 AM 6 Noon 0 4PM 7 8PM 0 Midnight 6 4AM 0

Answered: The Clark County Sheriff's Department…

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

The first station can process a unit in 10 minutes First Station capacity = 60/10 = 6 units per hour As the second station has 2 identical machines in parallel, each of which can process a unit in 12 minutes. Each unit needs to be processed on one of the two machines. Second Station Capacity = 60 x 2/12 = 10 units per hour The third station can process a unit in 8 minutes Third Station capacity = 60/8 = 7.5 units per hour What is the hourly capacity of this production line?
Zucchero Sugar, Inc. has six processing departments for refining sugar—Affination, Carbonation, Decolorization, Boiling, Recovery, and Packaging. Conversion costs are added evenly throughout each process. Data from the month of August for the Recovery Department are as follows: Metric Tons Beginning Work−in−Process Inventory 0 Transferred in 22,000 Ending Work−in−Process Inventory 6,000 Costs Beginning Work−in−Process Inventory $0 Costs added during August : Direct materials 530,000 Direct labor 250,000 Manufacturing overhead 105,000 Total costs added during August $885,000 The ending Work−in−Process Inventory is 100% and 95% complete with respect to direct materials and conversion costs, respectively. The weighted−average method is used. How many metric tons of sugar were refined and transferred to the Packaging Department in August? A. 6,000 metric tons B.…
Federal Rent-a-Car is putting together a new fleet. It is considering package offers from three car manufacturers. Fred Motors is offering 5 small cars, 5 medium cars, and 10 large cars for $500,000. Admiral Motors is offering 5 small, 10 medium, and 5 large cars for $400,000. Chrysalis is offering 10 small, 5 medium, and 5 large cars for $300,000. Federal would like to buy at least 650 small cars, at least 500 medium cars, and at least 650 large cars. How many packages should it buy from each car maker to keep the total cost as small as possible? Fred Motors packages Admiral Motors packages Chrysalis packages What will be the total cost?$
Federal Rent-a-Car is putting together a new fleet. It is considering package offers from three car manufacturers. Fred Motors is offering 5 small cars, 5 medium cars, and 10 large cars for $500,000. Admiral Motors is offering 5 small, 10 medium, and 5 large cars for $400,000. Chrysalis is offering 10 small, 5 medium, and 5 large cars for $300,000. Federal would like to buy at least 550 small cars, at least 500 medium cars, and at least 550 large cars. How many packages should it buy from each car maker to keep the total cost as small as possible? |packages | packages |packages Fred Motors Admiral Motors Chrysalis What will be the total cost? 2$
Sunseel Industries produces two types of raw materials, A and B, with a production cost of $4 and $8 per unit, respectively. The combined production of A and B must be at least 700 units per month. The factory is expected to produce at least 400 units of B and not more than 1200 units of A each month. The processing times for A and B are observed to be 5 hours and 4 hours, respectively. A total of 3000 production hours are available per month. Develop a linear program that Sunseel Industries can use to determine the number of units of each raw material to produce that will meet the demand and minimize the total cost.
A custom motor cycle shop is experiencing high demand from its customers for its services. The owner performs all tasks relating to customization. Assume each customer brings one motor cycle for customization. The owner needs to determine if he needs to add more help to meet customer demand. A week has 40 hours (maximum amount of time available for the owner to work) . The maximum number of customizations that can be done per week is 8 bikes ( if there is no wasted time ). The following is the data collected from observations for a typical week: Every Friday the shop is cleaned by the owner. This takes 5 hours 15 % of the customization needs rework which takes 75 % more time than regular customization 15 % of the customers will be called by the owner to reschedule completion by the owner. This takes 2 hours per customer. Determine OEE. How should the owner handle the business ? Show all formulas, calculations and results.
A paper-making company has five machines that can produce four different types of papers. The company wants to assign each paper type to separate machines to minimize the total time required. The manufacturing times in minutes per unit of paper produced is listed below: Paper Type Machine Type A B C D M1 2.40 1.60 3.20 3.20 M2 2.10 2.40 3.20 4.50 M3 1.90 1.70 2.60 5.10 M4 2.50 2.50 3.20 6.50 M5 3.25 2.40 3.10 3.60 What is the optimal minimum time?
The maintenance department of an Oil and Gas Company has 6 large drilling equipment waiting for repairs. These are labelled A, B, C, D, E and F. The respective repair times (in days) and the remaining days before the due date are given in the table below.
Ensemble Theatre of Cincinnati D. Lynn Meyers has been Producing Artistic Director of the nationally renowned Ensemble Theatre of Cincinnati (ETC) since 1995. The nonprofit ETC, recently celebrating its 25th anniversary, is dedicated to the production and development of new plays and of works new to the region. Lynn values the opinions of each member of her small staff when hiring. She usually interviews four or five people for a staff position and conducts two interviews. After the preliminary interview determines that an applicant is suitable, she says, “We invite the person back to meet the staff they would have contact with on a daily basis.” She has passed on qualified candidates who did not interact well with their prospective coworkers or who did not convince her that they had a strong desire for the job. Lynn researches job applicants online and on social media sites. “Frankly, if we find unprofessional behavior, we take that into consideration,” she says. “We always check…

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

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

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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.

SEE MORE TEXTBOOKS