This preview shows page 1. Sign up to view the full content.
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
- Spring '10