Palm City Police Department - memo inss

Palm City Police Department - memo inss - violent crimes...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Palm City Police Department The Problem: The Palm City Police Department has eight defined precincts. The Police station in each precinct has primary responsibility for all activities in its precinct area. The table lists the current population of each precinct, the number of violent crimes committed in each precinct, and the number of officers assigned to each precinct. The department has established a goal of equalizing access to police officer and violent services. Ratios of population per police officer should be calculated for each precinct. Requirements: Build a spreadsheet to perform this analysis and print it out Currently, no funds are available to hire additional officers. Based on the citywide ratios, the department has decided to develop a plan to shift resources as needed to ensure that no precinct has more than 1100 residents per officer and no precinct has more than seven
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: violent crimes per officer. The department will transfer officer s from precincts that easily meet these goals to precincts that violate one of both ratios. Use goal seeking on you spreadsheet to move police officers between precincts until the goals are meet. You can use the goal seek tool to see how many officers would be required to bring each precinct into compliance and then judgmentally reduce officers into precincts that are substantially within the criteria. Print out a set results that allow the department to comply with these ratios and memorandum to your instructor summarizing your results and the process you used to develop them Deliverable: Spreadsheet Analysis Precinct 1 Precinct 2 Memorandum...
View Full Document

Ask a homework question - tutors are online