The following questions down below are partially answered the ones that are circled are correct and the ones that aren't I am having trouble with. The answers that are crossed without a circle are wrong.

1. According to the Police Commissioner, how many Detectives does the Police Department employ in 2016? a. 2,500 b. 150 275 300 . 443 2. According to the Budget Director, which Expense Item is only incurred by Uniformed Police Officers, and not by any other FTE Type? a. Uniform b. Patrol Car C. Firearm Training d. Mileage Reimbursement e. Firearm(s) 3. According to the Police Commissioner, what impact does a detective have on the violent crime rate in this city? a. -0.02% b. -0.03% -0.04% -0.05% -0.06% 4. According to the Budget Director, in order to meet budget targets for 2017, by what percent does the 2016 police operating budget need to be cut? a. 0% b. 1% 3% 5% e. 7% 5. Under the scenario of a 7% budget cut to Police Personnel expenses for 2017, what would the 2017 budget for salaries be? a. $130,390,650 b. $49,071,750 c. $140,205,000 d. $32,775,000 e. $176,027,378 6. Using Microsoft Excel Solver to minimize the total impact on the violent crime rate in this city, what is the optimum combination of FTE Types for this police department? a. 2500 Uniformed, 150 Special Ops, 300 Detectives, 443 Civilians 1 2375 Uniformed, 135 Special Ops, 315 Detectives, 289 Civilians C . 2200 Uniformed, 130 Special Ops, 300 Detectives, 420 Civilians 2600 Uniformed, 140 Special Ops, 350 Detectives, 150 Civilians e. 2550 Uniformed, 125 Special Ops, 250 Detectives, 500 Civilians 7. With the optimum FTE combination from the previous question, how much will the city end up spending/using from its 2017 Budget Target? a. $305,053,003 b. $275,063,851 C. $281,372,019 $281,718,298 e. $300,530,3508. With the optimum FTE combination from question #6, which FTE type experienced the largest percent change from the 2016 FTE count? a. Uniformed Officers b. Special Operations c. Detectives d. Civilians e. N/A, all FTE counts changed by the same percentage 9. With the optimum FTE combination from question #6, which FTE type experienced an increase in staffing, instead of a decrease? a. Uniformed Officers b. Special Operations c. Detectives d. Civilians e. N/A, all FTE types experienced a decrease 10. Based on your understanding of how this optimization problem is set up, which of the following variables is NOT contributing to the optimization results you found for question #6? a. Population Density b. Impact on Violent Crime Rate c. Salary Costs d. Patrol Car Costs e. Training Costs (firearm or other) Data Source: Data for this assignment must be obtained through engagement with the budget and police departments. However, your instructors are providing an Excel template to conduct the analysis.C12 fx 500 A B C D E F G H J K Uniformed Special Operations Detective Civilian Decision Variables FTE Type 2500 150 300 443 Total Impact on Violent Crime Rate Impact on Violent Crime Rate 0.05% 0.04% -0.06% 0.02% 0.179 Work with the Police Commissioner to get information about Objective police FTEs and impacts on violent crime. 10 11 Expense Type Expense Item Uniformed Special Operations Detective Civilian Used 2016 Budget 2017 Budget Target 12 Operating Uniform $500 $1,000 $0 $0 $1,500 13 Operating Protective Equipment $5,000 $15,000 So sol $20,000 14 Operating Firearm Training $5,000 $10,000 $2,000 Sol $17,000 15 Operating Other Training $500 $500 $15,000 $5,000 $21,000 16 Operating Patrol Car $15,000 $0 SO $15,000 17 Operating Mileage Reimbursement $500 $1,000 $200 $1,700 18 Operating Firearm $12,000 $20,000 $5,000 So $37,000 19 Personnel Salary $38,000 $52,000 $73,000 $35,000 $198,000 20 Personnel Benefits $13,300 $18,200 $25,550 $12,250 $69,300 21 22 23 FTE Type 2016 FTEs 24 Uniformed 2,500 25 Special Operations 150 26 Detective 300 Constraint 27 Civilian 443 28 29 30 Operating Cut 5% 31 Personnel Cut 7% 32 33 Work with the Budget Director to get information about 34 35 expenses and targets for Operating and Personnel Cuts. 36 37 38 39 40