Palm city police department goal seeking

Assignment Help Management Theories

Reference no: EM131053063

Palm City Police Department Goal Seeking

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 services. Ratios of population per police officer and violent crimes per police officer should be calculated for each precinct. These ratios for the city as a whole are shown at right.

a. Build a spreadsheet to perform this analysis and print it out.

b. Currently, no funds are available to hire additional officers. On the basis of the citywide ratios, the department has decided to develop a plan to shift resources as needed to ensure that no precinct has more than 1,100 residents per police officer and no precinct has more than seven violent crimes per police officer. The department will transfer officers from precincts that easily meet these goals to precincts that violate one or both of these ratios. Use "goal seeking" on your spreadsheet to move police officers between precincts until the goals are met. 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 in precincts that are substantially within the criteria. Print out a set of results that allow the departments to comply with these ratios and a memorandum to your instructor summarizing your results and the process you used to develop them.

Reference no: EM131053063

Questions Cloud

Processes of reading and writing : The processes of reading and writing are obviously connected, but for writers this may be particularly true. Do you think there are things you can do as a reader that will make you a more effective writer? If so, what are they, and how will they h..

What is the irr of the set of cash flows : What is the IRR of the following set of cash flows?

Discuss the growth of the various types of modern music : Discuss the growth of the various types of modern music in films from the late 1940s through the early 1970s. Please mention specific films, styles, and composers when you can.

What is typically considered to be the return : What is typically considered to be the return on U.S. government bonds and bills and equals the real interest and the expected inflation premium?

Palm city police department goal seeking : 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.

Basic ethical and legal principles underlie : According to the APA 6 Publication Manual, basic ethical and legal principles underlie all scholarly research and writing. Long-standing principles are designed to achieve these goal(s):

Project under consideration has the cash flows : A firm evaluates all of its projects by applying the NPV decision rule. A project under consideration has the following cash flows: Year Cash Flow 0 –$ 28,300 1 12,300 2 15,300 3 11,300 What is the NPV for the project if the required return is 11 per..

Rewards students unevenly and encourages : Some people believe that this is more effective for learning than the grading system, which they believe rewards students unevenly and encourages a competitiveness that is counterproductive to learning.

Consultant for a new international development agency : You have been hired as historical consultant for a new international development agency known as the Klein Fund that has been formed to rectify what its founders perceive to be the past mistakes of the "shock doctrine" era from the 1970s to the ea..

User Account

All Pages