Q. 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,110 residents per police officer and no precinct has more 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 these ratios. Use "goal seeking" on your spreadsheet to move police officer 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 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.