The URL can be used to link to this page

Police Fiscal Year 2023 Budget Presentation Copyrighted March 22, 2022 City of Dubuque Public Hearings # 3. Special Meeting ITEM TITLE: Police Fiscal Year2023 Budget Presentation SUMMARY: SUGGESTED DISPOSITION: ATTACHMENTS: Description Type Police Policy Budget Book Supporting Documentation Presentation_Uploaded 3.22.22 Supporting Documentation Police -31- This page intentionally left blank. -32- POLICE DEPARTMENT FY 2021 FY 2022 FY 2023 %Change From Budget Highlights Actual Budget Requested FY 2022 Budget Expenses Employee Expense 12,769,859 14,421,028 14,701,142 1.9 % Supplies and Services 1,279,632 1,883,124 1,601,604 (14.9)% Machinery and Equipment 694,071 491,267 875,683 78.2 % Debt Service 306,477 59,609 56,456 (5.3)% Total Expenses 15,050,039 16,855,028 17,234,885 2.3 % Resources Operating Revenue 1,331,797 1,550,869 1,710,396 10.3 % DRA Gaming for Debt Abatement 296,477 59,609 56,456 (5.3)% Canine & 1948 Stylemaster Trust 0 5,000 5,000 — % Total Resources 1,628,274 1,615,478 1,771,852 9.7 % PropertyTaxSupport 13,421,765 15,239,550 15,463,033 223,483 Percent Increase (Decrease) 1.5 % Personnel -Authorized FTE 121.56 122.56 124.75 Improvement Package SummarX 1 of 4 This improvement request is to outfit all sworn officers with tasers. As a result of the May 2020 Black Lives Matter City Council work sessions, the department began looking at less-lethal options. Currently the department has two less lethal options carried by officers on their person; pepper spray and baton. Both options require the officer to be close to the offender, thus increasing the likelihood of injury to both the officer and offender. Also, due to differing physical reactions/attributes, neither option may work resulting in the officer potentially using a deadly force option. Taser is a widely used Conducted Electrical Weapon/Conducted Energy Device. The device uses electricity to stun and temporarily disable resistive suspects by causing involuntary muscle contractions. Studies have shown that a suspect injury is reduced by 65 to 90 percent. A taser allows officers a less lethal option, not currently available to officers, which falls on the use of force continuum between hands on, pepper spray, and firearms. By providing this option, officers may not need to use deadly force with another option. The proposal is to outfit all sworn officers with tasers. This would be a five year contract with option to upgrade equipment with total cost $378,800. The first year is $77,960. Next 4 years the recurring cost would be $75,210. Taser is the only company currently making this type of device. This request supports the City Council goal of Vibrant Community: Re-imagining Police. Related Cost: $ 77,960 Tax Funds Recurring Recommend -Yes Net Cost: $ 77,960 Property Tax Impact: $ 0.0307 0.32% Activity: Police Patrol -33- 2 of 4 This improvement request is for an integrated body and car camera system with web-based storage. In FY23, the Department has budgeted for body camera and in-car camera replacement. Cameras have proved instrumental in providing evidence in criminal cases, and in allegations of officer misconduct. The departments' in-car cameras were purchased a few years before the body cameras. Technology has changed immensely since the purchase of both systems to include data storage and retrieval. Currently the systems are from the same company but are stand alone and do not integrate. The technology is outdated, unsupported, and labor intensive. The Department is looking at systems that integrate both body camera and car cameras. Additionally, we are looking at a web-based storage system that will allow for less staff time, reduce the physical storage space (we currently must burn CD's for each case), and allow for access to attorney's without having to spend staff time burning CD's. This is a joint project with the Dubuque County Sheriff's Office, who share the current equipment that includes server's and CD burners. This will be 5 year contract with the company replacing the BWC's in 3 years as part of the contract. BWC and car cameras are critical to law enforcement transparency with the public, officer accountability, and accurate reporting. This request supports the City Council goal of Vibrant Community: Re-imagine Policing. Related Cost: $ 131,400 Tax Funds Recurring Recommend -Yes Net Cost: $ 131,400 Property Tax Impact: $ 0.0517 0.53% Activity: Police Patrol 3 of 4 This improvement request is to improve the negotiating throw phone to a smartphone and app that will go directly to the negotiator and other officers at the scene. The cost will be for one smartphone (throw phone) that will be compatible with the officers' smartphones. This is a valuable tool, when attempting to deescalate situations as communication is key to deescalation. This request supports the City Council goal of Vibrant Community: Re-imagining Policing. Related Cost: $ 3,000 Tax Funds Recurring Recommend -Yes Net Cost: $ 3,000 Property Tax Impact: $ 0.0012 0.01% Activity: Police Patrol 4 of 4 This improvement request is for hard drive storage. The current hard drive is at the end of it's life expectancy, due to being outdated technology and running out of storage. This is to match current Citywide storage. This request supports the City Council goal of High Performance City Organization. Related Cost: $ 150,000 Tax Funds Non-Recurring Recommend -Yes Net Cost: $ 150,000 PropertyTax Impact: $ 0.059 0.61% Activity: Administration -34- Significant Line Items Employee Expense 1. FY 2023 employee expense reflects a 3.25% wage package increase. 2. The lowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2022 The employee contribution of 6.29% is unchanged from FY 2022. 3. Fire and Police Retirement rates in FY 2023 decreased from 26.18% to 23.90°/o or a decrease of(8.71)%; a savings of$142,354. The history of the change in rates is as follows: Previous Fiscal Year Rate New Rate % Change $ Change 2013 24.76 % 26.12 % 5.49% $ 99,325 2014 26.12 % 30.12 % +15.31% $ 299,175 2015 30.12 % 30.41 % +0.96% $ 180,505 2016 30.41 % 27.77 % -8.68% $ -191,341 2017 27.77 % 25.92 % -6.66% $ -148,288 2018 25.92 % 25.68 % -0.93% $ -19,457 2019 25.68 % 26.02 % 1.32% $ 160,410 2020 � 26.02 % 24.41 % -6.19% $ 69,279 2021 24.41 % 25.31 % 3.69% $ 148,555 2022 25.31 % 26.18 % +3.44% $ 150,262 2023 26.18 % 23.90 % -8.71% $ -142,354 4. The City portion of health insurance expense is increased from $1,086 in FY 2022 to $1,119 in FY 2023 per month per contract which results in an annual cost increase of$66,288 or 3.00°/o. 5. Police Injuries decreased from $81,438 in FY 2022 to $26,457 in FY 2023 based on a five year average of actual expenditures. 6. Overtime decreased from $165,914 in FY 2022 to $148,355 in FY 2023. FY 2021 actual was $190,381. The decrease is due to the reduction of grants for alcohol compliance and alcohol OT, and the resulting less overtime performed for those activities. 7. Reimbursable Overtime decreased from $249,101 in FY 2022 to $155,646 in FY 2023. FY 2021 actual was $211,499. This line item is the reimbursed overtime for privately sponsored events covered by the police department that are directly reimbursed by private entities. It is decreasing due to the closing of the Greyhound Park. 8. Holiday Pay increased from $455,615 in FY 2022 to $500,559 in FY 2023. FY 2021 actual was $368,307. This line item fluctuates depending on what weekday the holidays fall on. 9. Five-Year Retiree Sick leave payout increased from $61,303 in FY 2022 to $86,197 in FY 2023. -35- 10. 50% Sick leave payout increased from $19,119 in FY 2022 to $42,736 in FY 2023 based on FY 2021 actual. Effective July 1, 2019, employees over the sick leave cap can convert 50% of the sick leave to be paid out. 11. Insurance Premiums increased from $54,125 in FY 2022 to $72,430 in FY 2023. This line item is the Police stop loss insurance premium which is an ineligible expense under the worker's compensation reserve. Insurance rates have risen for both Police and Fire due to instability in the social climate across the country. Insurance providers have determined that there is additional risk in insuring these positions. 12. The Fiscal Year 2020 budget approved an improvement level decision package to provide funding for the expansion of the Dubuque Police Department School Resource Officer (SRO) Program. To spread the expenses over time, three SRO's were to have been added over three consecutive years: Fiscal Year 2020, Fiscal Year 2021, and Fiscal Year 2022 budget. However, the expansion was frozen in FY21 due to the pandemic causing the final position to be added in FY23 instead of FY22 as originally planned. Even with the frozen position, the Dubuque Community School District (DCSD) will still gradually pay 50% of the salary of the existing SRO Lieutenant, and the DARE Officer. This DCSD payment will be implemented in increments of 45% of 50% reimbursement in year 1, or Fiscal Year 20, 75% of 50% reimbursement in year 2, or Fiscal Year 21, and 100% of 50% reimbursement in year 3, or Fiscal Year 22. Supplies & Services 13. Education and Training is increased from $225,422 in FY 2022 to $277,422 in FY 2023.This line item includes mandatory and required training which fluctuates annually and is dependent on certifications, promotions, and retirements. In FY 2023, the number of new police officers estimated to be sent to the law enforcement academy is twelve at a total cost of$154,800; drone operator testing and certification which occurs every two years is due again in FY24 at an estimated cost of$3,000 based on FY2019 costs of$500 per person with six operators; additional instructors certifications needed for Glock Armorer, Field Sobriety, and Shotgun Armorer, $5,207 and adding PoliceOne virtual training, $6,313 which was previously funded through a JAG grant. 14. Data Processing Equipment Maintenance Contracts decreased from $66,875 in FY 2022 to $60,912 in FY 2023 based on software and the number of licenses allocated to the Police Department. 15. Police Liability Insurance increased from $54,437 in FY 2022 to $74,427 in FY 2023 based on FY 2022 actual plus 37%. 16. Property Maintenance decreased from $457,664 in FY 2022 to $230,174 in FY 2023. This amount is based on historical actual amounts less one-time repairs. FY 2022 amount included a boiler replacement for$37,153, DLEC lighting replacement for$103,127, three office remodels for$7,940, and a roof replacement for$51,275. FY 2023 includes a computer room for $2,977. -36- 17. Motor Vehicle Fuel is increased from $108,019 in FY 2022 to $118,821 in FY 2023. FY 2021 actual was $103,858. 18. Motor Vehicle Maintenance decreased from $126,973 in FY 2022 to $126,256 in FY 2023. FY 2021 actual was $123,780. 19. Software License Expense decreased from $202,932 in FY 2022 to $189,372 in FY 2023. This line item represents Public Safety Software $139,157, Smart 911 software $8,150, Criminal Investigation software $4,983, and Patrol software $37,082. 20. Programming increased from $117,742 in FY 2022 to $135,625 in FY 2023, based on FY 2021 budget plus 4%. This line item represents the recharge of Information Services staff time related to the maintenance of software. 21. Ammunition is unchanged from $47,344 in FY 2022 to $47,344 in FY 2023 based on FY 2021 actual. This line item represents the cost of all ammunition for training and on duty use. 22. Pay to Other Agency is increased from $61,328 in FY 2022 to $63,357 in FY 2023. This line item represents one-third share of the Drug Task Force office expense, fifty percent share of the Dubuque Drug Task Force Coordinator position, and annual continuation fees for accreditation. This is based on a 3.25°/o increase in employee expense wage package. 23. General Liability Insurance decreased from $84,149 in FY 2022 to $44,288 in FY 2023. The decrease was due to an error in budgeting in FY2022 where the amount for police liability was included twice as part of the general liability. 24. Telephone increased from $40,236 in FY 2022 to $41,463 in FY 2023, based on FY 2022 budget plus 3°/a Machinery & Equipment 25. Equipment replacement items include ($875,683): Police Equipment Replacements Administration Smartphone (2) and Cellphones (2) $ 361 Staff Services Office Furniture $ 5,483 Automatic External Defibrillator $ 4,613 Police Barricades $ 120,000 Police Traininq File Cabinets (2) $ 872 Video Equipment $ 1,025 Criminal Investigation Vehicle Accessories $ 1,854 Bicycles and Equipment $ 1,977 -37- Police Equipment Replacements � Community Oriented Police Community Oriented Police Vehicle (2) - $ 31,576 Bicycle/Bag/Carrier/Lighting (1) $ 1,691 Vehicle Accessories (2) $ 8,500 Patrol Patrol Vehicles $ 178,060 Vehicle Accessories $ 43,560 Aux Emergency Lights $ 2,387 Red Light Visibar $ 11,785 Handheld/Moving Radar $ 4,224 Body Armor and Tac Vests $ 11,550 Alcosensor $ 1,026 Weapon Replacements $ 103,943 Bar Code Scanners $ 4,389 Police Canine $ 15,300 Gas Masks $ 1,795 K9 - Equipment $ 5,697 Riot Helmets and Shields $ 459 Shooting Ears and Glass $ 1,025 GPS $ 615 Traffic Monitor Batteries Equipment $ 1,795 ASP/Carrier $ 3,060 Handheld Radio & Batteries $ 14,355 Automatic External Defibrillator $ 9,834 Vehicle Camera Systems & Body Worn Cameras $ 131,400 Cell Phones/Accessories $ 1,472 Recommended Improvement Packages $ 150,000 Total Equipment $ 875,683 Debt Service 26. In FY 2023 annual debt service payments on GO Bonds issued for Police software replacement is $56,456. Final Call Amount Debt Series Payment Source Purpose Payment Date $ 38,556 2021A G.O. General Fund Software 2022 2028 $ 17,900 2021A G.O. General Fund Software 2030 2028 $ 56,456 Total Police Annual Debt Service -38- Revenue 27. Reimbursements from Dubuque Community Schools unchanged from $486,413 in FY 2022 to $486,413 in FY 2023. Reimbursements normally include shared cost for five School Resource Officers (SRO) and the Drug Abuse Resistance Education (DARE) program.Additionally, reimbursements include support costs for the expansion of the School Resource Officer program which is being implemented over a three year period. The decrease is due to being short a couple of SROs, so budget is based on FY21 actual. 28. Dubuque County Sheriff's Department reimbursement decreased from $289,502 in FY 2022 to $254,463 in FY 2023. Reimbursements include sharing the cost of six employees, computer system maintenance, and the DARE program, and is based on the county's FY 2023 budget. 29. Racing Association Revenue decreased from $96,884 in FY 2022 to $0 in FY 2023 based on FY 2021 . lowa Greyhound Association will stop related operations in May 2022. 30. State and Federal Pass-Through to the State grants decreased from $100,130 in FY 2022 to $76,887 in FY 2023. FY 2023 grant revenue will support Narcotics Investigation $31,650, Drug Task Force Grant $30,813, Domestic Abuse Grant $938,Alcohol/Tobacco compliance programs $75, Meth Hots Spots program $1,598, and $3,360 to support the Jail Diversion Program. It also includes a Police Traffic Service Grant of$8,453, which decreased from the prior year since the funds did not all get used. 31. lowa District Court Fines decreased from $280,045 in FY 2022 to $240,771 in FY 2023. FY 2021 actual was $240,771. -39- DUBUQUE POLICE DEPARTMENT The Mission of the Dubuque Police Department is to provide a safe and secure environment for citizens, visitors and guests so they can experience a stable, thriving community free of danger, injury or threat of harm. Organizational Chart Chief of Police Assistant Con£dential Chief of Account Poliee Clerk � � = - Captain's& Captain Captain Captain Captain [aptain Lieutenants Corporals PIOICrime CI� Training Corporal &Oificers prevention LT Lieutenant Lieutenant &Officers SRO LT DDTF Corporals Lieutenant &Dfficers Corporals Corporals Civilian 80fficers &Officers Staff SUCCESS IS ABOUT PEOPLE, PLANNING, AND PARTNERSHIPS LEADING TO OUTCOMES People The Dubuque Police Department offers seven opportunities for the community to become involved in policing: Auxiliary Police, Citizen's Police Academy, Youth Academy, School Resource Officers, Social Media Outreach, Dubuque Police Ride Along Program, and Police Explorer Program. � : � . � .��. � �� .; , -= ��'P Partnerships Planning The Dubuque Police Department The Dubuque Police Department utilizes partnerships with other supports the City Council Goal of federal, local, and state entities, Vibrant Community: Healthy and Safe private organizations and individuals by working with all City Departments to support the City Council Goal of and community partners to ensure Livable Neighborhoods. professional police service. -40- DUBUQUE POLICE DEPARTMENT FY 2021 FY 2022 FY 2023 Full-Time Equivalent 121.56 122.56 124.75 Revenue and Property Tax Support $20,000,000 $15,239,550 $15,000,000 $15,463,033 $13,421,765 $10,000,000 $5,000,000 $1,550,869 �� 1 710 396 Operating Revenue Property Tax Support � FY 2021 FY 2022 FY 2023 The Police Department is supported by 124.75 full-time equivalent employees, which accounts for 85.30% of the department expense as seen below. Overall, the department's expenses are expected to increase by 2.25% in FY 2023 compared to FY 2022. Expenditures by Category by Fiscal Year $12,769,859 Employee Expense $14,421,0 $14,701,1 T $1,279,632 Supplies and Services $1,883,124 $1,601,604 $694,071 Machinery and Equipment $491,267 $875,683 $306,477 Debt Service $59,609 $56,456 �� O� O� O� O� O� O� ��0 O��O h��O O��O h��O O��O ��,, �4j, �.�, ��p, ��,, ��t,�, FY 2021 FY 2022 � FY 2023 -41- DUBUQUE POLICE DEPARTMENT �m�nistration Overview The Police Department is responsible for providing community service and protection, creating a safe and secure environment for the citizens we serve. It also provides for maintenance, equipment, materials, supplies and repairs necessary for the operation of the department at the Dubuque Law Enforcement Center; as well as completing all requirements to maintain our status as an accredited law enforcement agency. Service is provided 24/7. Police Administration oversees the following divisions within the department: Community Oriented Policing, Criminal Investigation, Patrol, Staff Services, Special Units and Professional Standards. Staff Services encompasses Records and Identification and Training activities. Administration Funding Summary FY 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $750,235 $1,218,717 $968,983 Resources $8,969 $1,850 $8,969 Administration Position Summary FY 2023 Police Chief 1.00 Assistant Police Chief 1.00 Account Clerk Confident 1.00 Total FT Equivalent Employees 3.00 Performance Measures City Council Goal: Financially Responsible, High-Performance Organization Performance Measure(KPI) Target FY 2020 FY 2021 FY 2022 Performance Actual Actual Estimated Indicator � Activity Objective: Encourage all to feel safe in the community by providing expedient and efficient customer service and staffing and training quality, diverse applicants. #of calls for service handled per fiscal 55,000 55,695 53,445 55,000 � year #of officer applicants received & hired per 100 (5) 105 (5) 120 (8) 130 (8) � calendar year -42- DUBUQUE POLICE DEPARTMENT Community Oriented Policing Mission & Services Community Oriented Policing promotes positive relationships between police and community, establishing a problem solving philosophy by addressing the causes of crime and encourages long-term innovative problem solving, and improving law enforcement-community partnerships with better quality communication. This activity enhances police services by shifting the focus of police work from responding to individual incidents to addressing problems identified by the community and emphasizing the use of problem-solving approaches to supplement traditional law enforcement. This is demonstrated by involvement with the City of Dubuque Housing Department, School Resource Officers, Public Information, and involvement with landlords and neighborhood associations. Community Oriented Policing Funding Summary FY 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $ 1,488,422 $ 1,794,339 $ 1,779,754 Resources $ 311,203 $ 512,833 $ 528,933 Community Oriented Policing Position Summary FY 2023 Police Ca tain 1.00 Police Lieutenant 2.00 Police Corporal 3.00 DARE Police Officer 1.00 School Resource Officer 5.00 Police Officer 2.00 Total FT E uivalent Em lo ees 14.00 Performance Measures City Council Goal: Partnership for a Better Dubuque Performance Measure(KPI) Target FY 2020 FY 2021 FY 2022 Performance Actual Actual Estimated Indicator � Activity Objective: Public—Police engagement through neighborhood associations, landlord associations, and other community-based groups. #of background checks performed for 6,000 6,348 5,956 6,000 � landlords* #of Facebook followers 15,000 11,646 13,823 14,000 �� *The diminished number of checks can be attributed to COVID � �� . . . � '.. �) . Y-�� '�. � � .� ;• �� ,ti} F k .��' - � � -43- DUBUQUE POLICE DEPARTMENT Mission & Services The Criminal Investigation Division (CID) conducts in-depth investigations into major crimes that occur, including death investigations, sexual abuse, robbery, arson, child abuse, dependent adult abuse, kidnapping, serious assault, major financial crime and computer related crimes. CID is also assigned staff who work primarily in narcotics enforcement and are assigned to the Dubuque Drug Task Force (DDTF). Criminal Investigation Funding Summary FY 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $1,635,973 $1,776,582 $1,808,572 Resources $40,338 $73,577 $71,151 Criminal Investigation Position Summary FY 2023 Police Captain 1.00 Police Lieutenant 2.00 Police Corporal 4.00 Patrol Officer 6.00 Total FT Equivalent Employees 13.00 Performance Measures City Council Goal: Financially Responsible, High-Performance Organization Performance Measure(KPI) Target CY18 CY19 CY20 Performance Actual Actual Estimate Indicator � Activity Objective: Provide a safer community by deterring crime, providing advice on criminal investigations, and supporting the Drug Task Force and local Opioid responses. Total pounds of prescription drugs 1,400 1,301 1,200 800 � � received through drug take-back events Total pounds of prescription sharps 300 219 200 350 � received through drug take-back events CY20 Estimate reflects actual numbers. Normally two events are held,one in Spring,and one in Fall. Due to COVID,the Spring event was not held. One event was held October 24,2020 and the numbers reflect that single event. No others are planned for the remainder of the year. -44- DUBUQUE POLICE DEPARTMENT Patrol Mission & Services Prevent and control conduct threatening to life, property and public order by responding to reports of crimes, accidents and other emergencies, identifying criminal activity and hazardous conditions, and taking appropriate action. Patrol Funding Summary FY 2021 FY 2022 FY 2023 Actual Budget Requested Expenditures $9,066,551 $9,758,028 $10,133,874 Resources $658,000 $579,682 $764,928 Patrol Position Summary FY 2023 Police Captain 3.00 Police Lieutenant 8.00 Police Corporal 5.00 Patrol Officer 60.00 Total FT Equivalent Employees 76.00 Performance Measures City Council Goal: Vibrant Community, Healthy and Safe Performance Measure(KPI) Target CY 2018 CY 2019 CY 2020 Performance Estimate Indicator 1 Activity Objective: Ensure a safe and secure community environment. Community Conditions:Dubuque is a Safe 75% 64% N/A 68% �� Place to Live* #of Part I Crimes Against Persons <200 190 190 200 � #of Part I Property Crimes <2,000 1,543 1,319 1,600 �� *Based on bi-annual GDDC survey -45- DUBUQUE POLICE DEPARTMENT Staff Services Mission & Services Staff Services encompasses several activities. One supervisor with the rank of Captain oversees Staff Services, Training, and Records and Identification. Daily operations include providing clerical support to all divisions, training, Traffic Unit,Accreditation and maintaining official records of the police department. Staff Services Funding Summary FY 2021 FY 2023 Actual FY 2022 Budget Requested Expenditures $1,779,832 $2,182,423 $2,458,780 Resources $280,224 $322,957 $303,351 Staff Services Position Summary FY 2023 Police Captain 2.00 Police Corporal -Staff Services 1.00 Police Corporal -Records 1.00 Police Lieutenant-Training 1.00 Patrol Officer 3.00 Law Enforcement Support Specialist 1.00 Records Supervisor 1.00 Records Clerk- FT 2.00 Records Clerk- PT 1.24 Secretary 1.00 Clerical Assistant 0.75 Community Resource Officer 2.76 Clerk Typist 1.00 Total FT Equivalent Employees 18.75 Performance Measures City Council Goal: Vibrant Community, Healthy and Safe Performance Measure(KPI) Target CY18 CY19 CY20 Performance Actual Actual Actual Indicator 1 Activity Objective: Maintain the appropriate level of policy, personnel, and fleet to perform duties. Maintain accreditation (compliance with all 100% �/ �/ �/ � 484 standards) Traffic Contacts 8,500 8,479 7,925 6,800 � � TrafficAccident Investigations < 3,000 2,590 2,861 1,330 � � *Due to frozen positions, the Traffic Unit is currently disbanded. -46- This page intentionally left blank. -47- Recommended Operating Revenue Budget - Department Total 11-POLICE DEPARTMENT FY20 Actual FY21 Actual FY22 Adopted FY23 Recomm'd Fund Account Account Title Revenue Revenue Budget Budget 100 42260 PFRMIT,MISC 0 0 50 0 42 LICENSES AND PERMITS -Total 0 0 50 0 100 43ll0 INVESTMENT EARNINGS 62 15 62 15 297 43ll0 INVESTMENT EARNINUS 147 65 147 65 100 43261 RACING ASSOCIATION 88,807 105,072 96,884 0 43 USE OF MONEY AND PROPERTY-Total 89,016 105,152 97,093 80 100 44125 FED AID-LAW ENFORCEMENT 21,316 27,583 20,000 27,583 100 44175 FEDERAL STIMULUS GRANTS 0 0 0 212,000 100 44177 FF,DF,RAL-CARES ACT 68,679 0 0 0 44 INTERGOVERMENTAL -Total � 89,995 27,583 20,000 239,583 100 45701 STATEGRANTS 4,950 75 4,138 75 100 45771 FED PASS THRU STATE GRANT G9,825 45,998 95,992 76,812 45 STATE GRANTS -Total 74,775 46,073 100,130 76,887 100 46205 COUNTY SHARE 229,516 215,336 289,502 254,463 : 46 LOCAL GRANT AND REIMBURSE-Total 229,516 215,336 289,502 254,463 100 51215 LATE PAYMENT PENALTY 3,155 11,584 4,500 11,584 100 51901 POLICF.ACCIDF,NT RF,PORTS 31,980 33,720 33,289 33,720 100 51902 CRIMINAL BACKGROUND CHECK 320 20 320 20 51 CHARGES FOR SERVICES -Total 35,455 45,324 38,109 45,324 100 53102 PRIVATE PARTICIPANT 350,467 381,709 557,585 583,439 297 53102 PRIVATE PARTICIPANT 3,655 605 8,320 605 100 53201 REFLTNDS 637 2,544 0 2,544 100 53402 PARKING TICKET FINES 20,000 20,000 20,000 20,000 100 53403 IA DISTRICT COURT FINES 249,586 240,771 280,045 240,771 100 53404 ADMIN.PENALTY 8,340 5,040 9,845 5,040 100 53405 CIGARETTE PENALTIES 1,250 0 1,250 0 100 53605 MISCELLANEOUS REVENUE 1,965 1,991 4,000 1,992 100 53610 INSURANCE CLAIMS 19,422 87,209 0 87,209 100 53615 DAMAGE CLAIMS 6,498 990 1,500 990 100 53620 REIMBURSEMENTS-GENERAL 161,211 103,935 7A,606 103,935 100 53646 LTNCLAiMED PROPERTY 3,301 2,962 3,301 2,962 53 MISCELLANEOUS -Total 826,332 847,756 964,452 1,049,487 100 54107 V6HICL6 SALF,S 38,707 45,242 50,000 45,242 400 54210 GO BOND PROCEEDS 0 235,600 0 0 54 OTHER FINANCING SOURCES -Total 38,707 280,842 50,000 45,242 400 59100 FR GENERAL 62,021 60,877 59,609 56,456 59 TRANSFER IN AND INTERNAL -Total � 62,021 60,877 59,609 56,456 POLICE DEPARTMENT -Total 1,445,818 1,628,945 1,618,945 1,767,522 -48- Recommended Operating Expenditure Budget - Department Total 11-POLICE DEPARTMENT FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 100 61010 FULL-TIME EMPLOYEES 8,246,161 7,841,250 9,064,014 9,252,365 100 61020 PART-TIME EMPLOYEES 37,488 39,949 46,586 70,806 100 61030 SEASONAL EMPLOYEES 7,600 6,900 12,769 74,920 100 61050 OVERTIME PAY 149,255 190,381 165,914 148,355 100 61051 OVERTIME-REIMBURSABLE 290,213 211,499 249,101 155,646 100 61070 HOLIDAY PAY 388,517 368,307 455,615 500,559 100 61080 COVIDI9 EMP QUARANT/TREAT 2,383 0 0 0 100 61081 COVIDI9 SCHOOUDAYCARE CL 976 0 0 0 100 61083 COVIDI9 EMP NON-WORK 15,325 0 0 0 100 61085 SELF QUARANTINE HEALTH 2,440 0 0 0 100 61086 SYMPTOMS SEEK DIAGNOSIS 11,790 29,333 0 0 100 61087 CARETAKER FOR 1 OR 2 0 1,023 0 0 100 61090 WITNESS&JURY EXPENSES 20,814 17,677 21,438 18,252 100 61091 SICK LEAVE PAYOFF 70,918 84,989 61,303 86,197 100 61092 VACATION PAYOFF 19,544 28,405 0 0 100 61095 PARENTAL LEAVE 21,399 ll8,137 0 0 100 61096 50%SICK LEAVE PAYOUT 19,120 42,736 19,ll9 42,736 100 61310 IPERS 36,929 37,382 45,215 42,281 100 61320 SOCIAL SECURITY 150,835 147,076 166,535 172,888 100 61370 POLICE&FIRE RETIREMENT 2,074,707 2,019,542 2,347,180 2,348,268 100 61410 HEALTH INSURANCE 1,300,252 1,450,088 1,537,776 1,604,064 100 614ll INSURANCE PREMNM 18,514 49,418 54,125 72,430 100 61415 WORKMENS'COMPENSATION 1,003 1,028 795 736 100 61416 LIFE INSURANCE 5,024 4,844 5,036 5,520 100 61417 LTNEMPLOYMENT INSURANCE 0 (2,405) 0 0 100 61620 LTNIFORM ALLOWANCE 53,238 51,723 65,450 63,250 100 61651 MEALS NO OVERNIGHT 351 315 0 213 100 61660 EMPLOYEE PHYSICALS 893 0 0 0 100 61665 OTHER MEDICAL COSTS 2,305 16 7,559 4,018 100 61670 CIVIL SERVICE PHYSICALS 12,079 11,181 14,060 ll,181 100 61675 POLICE/FIRE INNRIES 95,500 19,064 81,438 26,457 61-WAGES AND BENEFITS 13,055,572 12,769,859 14,421,028 14,701,142 100 62010 OFFICE SUPPLIES 13,180 15,708 14,642 15,708 100 62011 LTNIFORM PURCHASES 16,397 20,138 19,250 20,138 100 62030 POSTAGE AND SHIPPING 4,573 5,787 4,219 5,903 100 62060 O/E MAINT CONTRACTS 32,508 3,825 42,169 6,166 100 62061 DP EQUIP.MAINT CONTRACTS 50,216 66,875 66,875 60,912 100 62090 PRINTING&BINDING 6,395 5,270 6,523 6,523 100 62110 COPYING/REPRODUCTION 8,415 6,489 7,790 6,489 100 62130 LEGAL NOTICES&ADS 6,165 1,254 6,165 1,254 100 62140 PROMOTION 432 275 299 299 100 62170 SUBSCRIPTIONS-BOOKS-MAPS 2,056 2,904 2,097 2,962 100 62190 DUES&MEMBERSHIPS 1,925 2,010 2,478 2,055 100 62203 POLICE LIABILITY INS 48,649 49,488 54,437 74,427 100 62206 PROPERTY INSURANCE 2,995 0 1,015 1,053 100 62208 GENERAL LIABILITY INSURAN 25,888 28,297 84,149 44,288 100 62230 COURT COSTS&RECORD FEES 5,886 4,312 8,923 4,312 100 62310 TRAVEL-CONFERENCES 4,513 4ll 8,240 8,240 100 62320 TRAVEL-CiTY BUSINESS 226 921 972 862 -49- Recommended Operating Expenditure Budget - Department Total 11-POLICE DEPARTMENT FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 100 62341 MEETiNG/WTTNESS/JURY EXP 562 275 500 406 100 62360 EDUCATION&TRAINING 144,185 102,832 225,422 277,422 100 62421 TELEPHONE 40,235 41,463 40,236 41,463 100 62424 RADIO/PAGER FEE 0 646 12,001 684 100 62431 PROPERTY MAINTENANCE 445,520 181,992 457,664 230,174 100 62436 RENTAL OF SPACE 20,295 18,821 25,488 18,821 100 625ll FUEL,MOTOR VEHICLE ll7,802 103,858 108,019 118,821 100 62521 MOTOR VEHICLE MAINT. 125,029 123,780 126,973 126,256 100 62522 VEHICLE MAINT.,ACCIDENT 16,039 0 14,297 6,318 100 62528 MOTOR VEH.MAINT.OUTSOUR 8,207 22,245 8,253 8,253 297 62528 MOTOR VEH.MAINT.OUTSOUR 3,034 0 5,000 5,000 100 62611 MACH/EQUIP MAINTENANCE 13,636 10,830 13,636 10,830 100 62647 AMMUNITION 47,344 40,422 47,344 47,344 100 62663 SOFTWARE LICENSE EXP 189,924 189,372 202,932 189,372 100 62666 CREDIT CARD CHARGE 461 84 1,694 84 100 62667 DATA SERVICES 2,699 2,780 2,610 2,781 100 62669 PROGRAMMING 115,409 117,742 117,742 135,625 100 62671 MISC.OPERATING SUPPLIES 0 0 900 0 100 62672 INVESTIGATION SUPPLIES 23,902 19,001 21,654 19,002 100 62678 EDUCATIONAL MATERIALS 7,006 5,827 13,419 5,827 100 62696 OUTSIDE COLLECTOR EXPENSE 13 0 13 0 100 62699 CASH SHORT AND OVER (10) 0 0 0 100 62717 CRIMINAL BACKGROiJND CHECK 38,830 32,173 45,756 32,173 400 62721 FINANCIAL CONSULTANT 0 425 0 0 100 62731 MISCELLANEOUS SERVICES 20 0 0 0 100 62761 PAY TO OTHER AGENCY 59,122 51,100 61,328 63,357 62-SUPPLIES AND SERVICES 1,649,683 1,279,632 1,883,124 1,601,604 100 71120 PERIPHERALS,COMPUTER (150) 556 0 0 100 71122 PRINTER 926 1,913 2,960 0 100 7ll26 HARDWARE 0 0 0 150,000 100 712ll DESKS/CHAIRS 6,020 1,126 5,000 5,483 100 71214 FILES 0 0 0 872 100 71310 AUTO/JEEP REPLACEMENT 139,425 476,499 252,608 209,636 100 71329 VEHICLE ACCESSORIES 10,404 61,777 68,000 53,914 100 71517 LIGHTING EQUIPMENT 0 0 2,330 2,387 100 72210 VISIBARLIGHTS 2,161 2,167 I1,500 11,785 100 72212 RADAR SPEED DETECTOR 0 3,556 4,120 4,224 100 72213 BODY ARMOR 20,805 12,880 18,515 11,550 100 72215 BREATH ANALYZER 500 1,693 1,000 1,026 100 72216 9 MM PISTOLS 13,041 35,336 13,350 103,943 100 72217 CARD READERS 987 1,316 4,284 4,389 100 72218 OTHER POLICE EQUIPMENT 44,395 22,294 33,200 153,414 297 72218 OTHER POLICE EQUIPMENT 68 0 0 0 100 72410 PAGER/RADIO EQUIPMENT 8,902 53,411 14,250 14,355 100 72416 VIDEO EQUIPMENT 114,368 4,079 24,800 132,425 100 72417 CAMERA RELATED EQUIPMENT 1,092 1,418 2,500 0 100 72418 TELEPHONE RELATED 2,863 420 18,750 1,833 100 72610 DEFIBRILLATOR 17,345 13,630 14,100 14,447 71-EQUIPMENT 383,151 694,071 491,267 875,683 400 741ll PRINCIPAL PAYMF.NT 52,800 298,400 52,800 52,800 400 74112 INTEREST PAYMENT 9,221 8,077 6,809 3,656 -50- Recommended Operating Expenditure Budget - Department Total 11-POLICE DEPARTMENT FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 74-DEBT SERVICE 62,021 306,477 59,609 56,456 ll-POLICE DEPARTMENT TOTAL 15,150,428 15,050,040 16,855,028 17,234,885 -51- Recommended Expenditure Budget Report by Activity & Funding Source l l -POLiCE DEPARTMENT ADMINISTRATION - 11100 FUNDING SOURCE:RESPIRATORY DISEASE TRUST Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIF,S AND SF,RVICFS 5,000 5,000 1948 STYLEMASTER TRUST - 5,000 5,000 F.QU I PM ENT 900 150,361 SUPPLIF.S AND SFRVICF,S 228,722 516,475 288,623 WAGF,S AND BF,NF.FITS 521,513 701,342 529,999 ADMINISTRATION 750,235 1,218,717 968,983 DARE PROGRAM -11180 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT - 350 - SUPPLIES AND SERVICES 6,661 11,462 6,860 WAGES AND BENEFITS 12,296 I 16,077 I 14,990 DARE PROGRAM 18,957 127,889 121,850 STAFF SERVICES - ll190 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 1,682 6,050 130,096 SUPPLIES AND SERVICES 188,477 200,594 205,191 WAGES AND BENF.FiTS 743,236 1,018,631 1,096,771 STAFF SERVICES 933,395 1,225,275 1,432,058 RECORDS AND ID -11220 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES L92,078 213,842 L92,135 WAGES AND BENEFITS 368,328 400,221 434,505 RECORDS AND ID 560,406 614,063 626,640 POLICE TRAINING - ll250 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUiPMENT 1,897 SUPPLIF.S AND SERVICF.S 134,248 199,031 251,884 WAGFS AND BENEFITS 151,783 144,054 146,301 POLICE TRAINING 286,031 343,085 400,082 CRIMINAL INVESTIGATION -11300 FUNDING SOURCE: GENERAL -52- Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 21,835 7,050 3,831 SUPPLIES AND SERVICES 56,834 62,128 68,338 WAGES AND BENEFITS 1,509,647 1,647,521 1,677,491 CRIMINAL INVESTIGATION 1,588,315 1,716,699 1,749,660 2009 METH HOT SPOTS GRANT-11319 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget WAGES AND BENEFITS 1,598 3,000 2009 METH HOT SPOTS GRANT 1,598 3,000 - NARCOTICS GRANT INV. - 11320 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 46,059 56,883 58,912 NARCOTICS GRANT INV. 46,059 56,883 58,912 JAIL DIVERSION PROGRAM -11323 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget WAGES AND BENEFITS 3,660 4,462 JAIL DIVERSION PROGRAM 3,660 - 4,462 COMM ORIENTATED POLICE -ll500 FUNDING SOURCE:RESPIRATORY DISEASE TRUST Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 79,350 86,002 41,767 SUPPLIES AND SERVICES 15,223 25,679 23,607 WAGES AND BENEFITS 1,374,892 1,554,769 1,592,530 COMM ORIENTATED POLICE 1,469,465 1,666,450 1,657,904 POLICE PATROL -11700 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 516,743 369,415 547,731 SUPPLIES AND SERVICES 406,732 590,130 500,054 WAGES AND BENEFITS 7,887,009 8,644,965 9,012,994 POLICE PATROL 8,810,484 9,604,510 10,060,779 FY 07 BULLET PROOF VEST -11703 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 3,220 FY 10 BULLET PROOF VEST 3,220 - - -53- GREYHOUND SECURITY - 11710 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budgct WAGES AND BENEFITS 113,487 92,270 GREYHOUND SECURITY ll3,487 92,270 — MERCY ER SECURITY -11715 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget WAGES AND BENEFITS 69,906 57,859 69,906 MERCY ER SECURITY 69,906 57,859 69,906 ALCOHOL COMPLIANCE CFIK -11718 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget WAGES AND BENEFITS 9,500 ALCOHOL COMPLIANCE CHK — 9,500 — DOJ STIMULUS GRANT -11740 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 1,768 DOJ STIMULUS GRANT 1,768 — — DOJ STIMULUS SEASONAL - 11741 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budgct WAGES AND BENEFITS 2 DOJ STIMULUS SEASONAL 2 — — 2011 JAG GRANT - 11752 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 352 2011 JAG GRANT 352 — FY12 JAG GRANT -11753 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 20,000 SUPPLIES AND SERVICES 4,173 WAGES AND BENEFITS 4,467 FY12 JAG GRANT 8,640 20,000 — DOMESTIC ABUSE GRANT -11754 -54- FUNDING SOURCE: GENERAL Account FY21 Actual Expensc FY22 Adopted Budget FY23 Recomm'd Budgct WAGES AND BENEFITS 3,182 3,389 3,189 DOMESTIC ABUSE GRANT 3,182 3,389 3,189 ALCOHOL/TOBACCO COMPLIANC- 11764 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget WAGF,S AND BF.NF,FITS 6 5 4 ALCOHOL/TOBACCO COMPLIANC 6 5 4 2003 ALCOHOL OT GRANT -11767 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLfES AND SERVICES 900 WAGES AND BENEFITS 7,425 2003 ALCOHOL OT GRANT — 8,325 — POLICE TRAFFIC SERV GRANT- ll771 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 2,850 WAGES AND BENEFITS 4,847 18,000 POLICE TRAFFIC SERV GRANT 7,697 — 18,000 FY08 TRAFFIC SVC GRANT - ll772 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 1,500 SUPPLiES AND SERVICES 1,000 1,000 WAGES AND BENEFITS 20,000 FY08 TRAFFIC SVC GRANT — 22,500 1,000 DEBT SERVICE - 11800 FUNDING SOURCE: DEBT SERVICE Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget DEBT SERVICE 66,271 DEBT SERVICE $66,271 — PCARD CLEARING -99999 FUNDING SOURCE: GENERAL Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget DEBT SERVICE 306,477 59,609 56,456 SUPPLIES AND SERVICES 425 — DEBT SERVICE 306,902 59,609 56,456 POLICE DEPARTMENT TOTAL $15,050,040 $16,855,028 $17,234,885 -55- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL-PERSONNEL COMPLEMENT 11 POLICE DEPARTMENT FY 2021 FY 2022 FY 2023 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 61010 Full Time Employee Expense 100 7100 GE-44 POLICE CHIEF 1.00 $ 142,440 1.00 $ 144,545 1.00 $ 114,652 100 7075 GE-40 ASSISTANT POLICE CHIEF 1.00 $ 117,070 1.00 $ 124,365 1.00 $ 128,411 100 6950 GE-38 POLICE CAPTAIN 7.00 $ 765,601 7.00 $ 779,808 7.00 $ 805,092 100 6850 GE-36 POLICE LIEUTENANT 12.00 $1,145,757 13.00 $1,207,811 13.00 $1,278,204 COMM DIVERSION/PREVENT 100 GE-33 COORD - $ - 1.00 $ 63,621 - $ - CONFIDENTIALACCOUNT 100 1000 GE-25 CLERK 1.00 $ 50,028 1.00 $ 50,752 1.00 $ 50,986 100 825 P-01 SCHOOL RESOURCE OFFICER 5.00 $ 348,429 5.00 $ 351,641 5.00 $ 350,493 100 6700 P-02 POLICE CORPORAL 16.00 $1,244,634 16.00 $1,242,722 14.00 $1,115,099 100 6400 P-01 POLICE PATROL OFFICER 70.00 $4,769,547 69.00 $4,782,224 72.00 $5,084,801 100 1940 NA-48 CLERK TYPIST 1.00 $ 44,427 1.00 $ 45,320 1.00 $ 46,796 100 4218 NA-48 RECORDS CLERK 2.00 $ 86,828 2.00 $ 88,972 2.00 $ 89,968 100 4220 GE-30 RECORDS ROOM SUPERVISOR 1.00 $ 66,601 1.00 $ 67,599 1.00 $ 69,121 100 225 GE-25 SECRETARY 1.00 $ 51,499 1.00 $ 52,245 1.00 $ 53,933 LAW ENF. USER SUPPORT 100 225 GE-29 SPECIAL 1.00 $ 61,719 1.00 $ 62,764 1.00 $ 64,809 TOTAL FULL TIME EMPLOYEES 119.00 $8,894,580 120.00 $9,064,389 120.00 $9,252,365 61020 Part Time Employee Expense 100 4218 NA-48 RECORDS CLERK 1.24 $ 42,798 1.24 $ 50,889 1.24 $ 49,712 100 1920 NA-28 CLERICALASST 0.75 $ 20,139 0.75 $ 20,436 0.75 $ 21,094 TOTAL PART TIME EMPLOYEES 1.99 $ 62,937 1.99 $ 71,325 1.99 $ 70,806 61030 Seasonal Employee Expense COMMUNITY RESOURCE 100 NA-31 OFFICER 0.57 $ 11,869 0.57 $ 11,869 2.76 $ 74,920 TOTAL SEASONAL EMPLOYEES 0.57 $ 11,869 0.57 $ 11,869 2.76 $ 74,920 TOTAL POLICE DEPT. 121.56 $ 8,969,386 122.56 $9,147,583 124.75 $9,398,091 -56- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Police Administration-FT 10011100 61010 100 7075 GE-40 ASSISTANT POLICE CHIEF 1.00 $ 117,070 1.00 $ 124,365 1.00 $ 128,411 CONFIDENTIALACCOUNT 10011100 61010 100 1000 GE-25 CLERK 1.00 $ 50,028 1.00 $ 50,752 1.00 $ 50,986 COMM DIVERSION/ 10011100 61010 100 GE-33 PREVENT COORD - $ - 1.00 $ 63,621 - $ - 10011100 61010 100 7100 GE-44 POLICE CHIEF 1.00 $ 142,440 1.00 $ 144,545 1.00 $ 114,652 Total 3.00 $ 309,538 4.00 $ 383,283 3.00 $ 294,049 DARE Program-FT 10011180 61010 100 6400 P-01 POLICE PATROL OFFICER 1.00 $ 68,522 1.00 $ 71,428 1.00 $ 73,748 Total 1.00 $ 68,522 1.00 $ 71,428 1.00 $ 73,748 Staff Services-FT 10011190 61010 100 325 NA-48 CLERK TYPIST 1.00 $ 44,427 1.00 $ 45,320 1.00 $ 46,796 LAW ENF. USER SUPPORT 10011190 61010 100 325 GE-29 SPECIAL 1.00 $ 61,719 1.00 $ 62,764 1.00 $ 64,809 10011190 61010 100 6400 P-01 POLICE PATROL OFFICER 3.00 $ 205,845 3.00 $ 210,591 3.00 $ 197,314 10011190 61010 100 6950 GE-38 POLICE CAPTAIN 1.00 $ 110,215 2.00 $ 220,663 2.00 $ 227,817 10011190 61010 100 6700 P-02 POLICE CORPORAL 1.00 $ 80,938 1.00 $ 82,131 1.00 $ 81,200 10011190 61010 100 6850 GE-36 POLICE LIEUTENANT 1.00 $ 98,991 - $ - - $ - 10011190 61010 100 225 GE-25 SECRETARY 1.00 $ 51,499 1.00 $ 52,245 1.00 $ 53,933 Total 9.00 $ 653,634 9.00 $ 673,714 9.00 $ 671,869 Staff Services-Seasonal COMMUNITY RESOURCE 10011190 61030 100 NA-31 OFFICER 0.57 $ 11,869 0.57 $ 11,869 2.76 $ 74,920 Total 0.57 $ 11,869 0.57 $ 11,869 2.76 $ 74,920 Records andlD-FT 10011220 61010 100 6780 P-02 POLICE CORPORAL 1.00 $ 78,770 1.00 $ 79,931 1.00 $ 82,525 10011220 61010 100 4218 NA-48 RECORDS CLERK 2.00 $ 86,828 2.00 $ 88,972 2.00 $ 89,968 RECORDS ROOM 10011220 61010 100 4220 GE-30 SUPERVISOR 1.00 $ 66,601 1.00 $ 67,599 1.00 $ 69,121 Total 4.00 $ 232,199 4.00 $ 236,502 4.00 $ 241,614 Records and ID-PT 10011220 61020 100 4218 NA-48 RECORDS CLERK 1.24 $ 42,798 1.24 $ 50,889 1.24 $ 49,712 10011220 61020 100 1920 NA-28 CLERICALASST 0.75 $ 20,139 0.75 $ 20,436 0.75 $ 21,094 Total 1.99 $ 62,937 1.99 $ 71,325 1.99 $ 70,806 Police Training-FT 10011250 61010 100 6850 GE-36 POLICE LIEUTENANT 1.00 $ 96,339 1.00 $ 97,751 1.00 $ 100,937 Total 1.00 $ 96,339 1.00 $ 97,751 1.00 $ 100,937 Criminal Investigation-FT 10011300 61010 100 6950 GE-38 POLICE CAPTAIN 1.00 $ 110,215 1.00 $ 111,829 1.00 $ 115,455 10011300 61010 100 6700 P-02 POLICE CORPORAL 4.00 $ 312,189 4.00 $ 317,150 4.00 $ 327,829 10011300 61010 100 6850 GE-36 POLICE LIEUTENANT 2.00 $ 197,982 2.00 $ 198,193 2.00 $ 204,652 10011300 61010 100 6400 P-01 POLICE PATROL OFFICER 6.00 $ 418,578 6.00 $ 425,774 6.00 $ 438,402 Total 13.00 $1,038,964 13.00 $ 1,052,946 13.00 $1,086,338 COP Program-FT 10011500 61010 100 6950 GE-38 POLICE CAPTAIN 1.00 $ 110,215 1.00 $ 111,829 1.00 $ 115,455 10011500 61010 100 6700 P-02 POLICE CORPORAL 4.00 $ 308,575 3.00 $ 234,293 3.00 $ 243,672 10011500 61010 100 6850 GE-36 POLICE LIEUTENANT 1.00 $ 95,456 2.00 $ 194,189 2.00 $ 201,747 10011500 61010 100 6400 P-01 POLICE PATROL OFFICER 2.00 $ 139,904 2.00 $ 136,607 2.00 $ 143,132 SCHOOLRESOURCE 10011500 61010 100 825 P-01 OFFICER 5.00 $ 348,429 5.00 $ 351,641 5.00 $ 350,493 -57- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Total 13.00 $1,002,579 13.00 $ 1,028,559 13.00 $1,054,499 Police Patrol-FT 10011700 61010 100 6950 GE-38 POLICE CAPTAIN 4.00 $ 434,956 3.00 $ 335,487 3.00 $ 346,365 10011700 61010 100 6700 P-02 POLICE CORPORAL 6.00 $ 464,162 7.00 $ 529,217 5.00 $ 379,873 10011700 61010 100 6850 GE-36 POLICE LIEUTENANT 7.00 $ 656,989 8.00 $ 717,678 8.00 $ 770,868 10011700 61010 100 6400 P-01 POLICE PATROL OFFICER 58.00 $3,936,698 57.00 $3,937,824 60.00 $4,232,205 Total 75.00 $5,492,805 75.00 $5,520,206 76.00 $5,729,311 TOTAL POLICE DEPARTMENT 721.56 $8,969,386 722.56 $ 9,147,583 724.75 $ 9,398,097 -58- �� FISCAL YEAR 2023 BUDGET PRESENTATION � �_�+�� - .:�.... . . ..� ,� ,..,��s+� � . ++.r� • ti / � � • � M � � ' � � �� . �� , � . �� . + � �e �� Police Department One team enhancin communit � 9► Y livabilit b rovidin e uitable y ya g a communit service and rotection Y p throu h inte rit com assion and 9► 9► y, p , com e ten ce p � o � r � D r � ■ � � � � � � � � � � n�rssr�nr sra r�n�t�vr: , : , Or�e team,enhanerng � � carr�m��zity�i�abil�ty by INTEGItITM providing equitaFa�e �Ethi�al , ., �a. -�,: �Hnnarable ., �r�`� ��m��t�S��e •.�oxon��,�_, �mo[` Qrrd protection ' •,�F`�'•-�• -_ thraugh i�tegr�ty, C�mpas5ion and 4NE TFAM FAIR cam�etence. •Farnily �Empathy �Pride •Compassion �Loyalty �Dignity&Respect •One Gaal{Mission •CansistentActions , � ` PROFE551dNAl C�LLABDRATION CQMMUNIT1f �Competent �Flexibility �Agoodplace •Accountable •Innavation to]ive&work. •5�ong Work Ethic �Effective Communicabon •Stewardship of the •5ustainahle F.nvirnnment d�partmcnt$�cammunity. � � � � �� 'I Retirements Chief Mark Dalsing - 32 Years Captain Scott Engleman - 28 Years Corporal Steve Eastvedt - 32 Years Officer Karen Sm ith - 22 Years Off i ce r Sta n Rya n - 22 Yea rs Police Department (124.75 Full -Time Equivalents) � r � r-� i�� 1 �I� � r� � ��,�� PQute �,�bisl� C�A��il �hl�+�t A�c�un� R411t�8 �� . _ � i - � - ��pt�in s R ��pSa+n �apRain +:�apRain ��p1� �a�rlai n Ll�n� ��r or�l� RI��I`�'rk! �la T�� 8rp�ro1 �� FY��r+81i1181i LT LI�uL�li�it L�411�*�lnl 8Q'fFit�r� �� LT 0�1`F ��4r�1� L�u1�n� c'�� _rp�a eh� �_rp�arats ��+III� 4� 4�A��+ 31�'R 1 Additional Sworn Police Officers 120 1 '13 109 109 149 109 149 149 109 149 110 1 '11 112 � 103 � �5 � 100 95 � O � so _ 0 a � so 0 3 � 0 4� � � � zo � z o � � � � � � � � � � zoos �009 Zo�o Zo� � 20� 2 Zo� 3 Zo�4 20� 5 zo�s Zo�7 Zo�s zo� 9 Zo2o zo�� Zoz2 � Total Sworn Officers Police Department Authorized Strength - 113 Sworn Staff , � � �� ■ �ffice r� ■ 1fac�r�ci e� ■ �c�der-r��r Fiel d Tr�i r�i r�g �� '� IVev�► C�ffi��rs , ;.��. �_ �� .s��,,� � �I � �-�-�� \��. { , ---- , d;.'�.. � .�� ----- - - ; " � \ - - - :f��j� i . ``� .''' ..: - - �- .� ii� '��• ^`� f �� ,��: f f� , . �,� _ �-� . � . ,�� -� =�r �. �+ �y.5 � . � �� • � • � � � e...... I E� .— C w � \ _�� k �Mii� 4"� � � �� -�� _ �' / �� o '" 1� -- ' —�� -- Y� �� '�` - -'' _.. �_��~ �°� \ ' F F�'=�4--_� ___� =-� _ a,� �=�� - .. ¢ —�_�_� —_ , � � ' — — — — — — — — — — — �`" �; " �7 �� 3� ,—. . �::4�p:" � � � �� — June 2021 - Officers December 2021 - Officers Breitbach, Conley,and Cole, Hingtgen and Pilarinos Klawitter Police Department Recruitment Efforts DPD Testing & Hiring Process 35� 3D0 289 250 �19 214 �a� �� 1�� 17� 1f4 15Q �44 1�� 121 112 1D5 1D0 94 �� 85 69 62 45 �� 68 50 38 37 4� 4� 40 �� 4p _ 29 4� x 34 �� 32 �� 14 p 10 �01Q �aii 2012 2{313 2�1� 2015 2016 �017 2�18 2{319 2�2fl 2�21 �PPlied —Passed —Certified List 2012 2013 2014 � - � � �' n � 4 � . � ,� :-� . �', � � ,��.:�� , �'�y� � � i - �'; �` �, , ? — ��, �� , � 6 ' �. i; • � ,� i ' \ '� � � . l �`� � �� ..l � � � l � � !i`.il U' � 1 ■ ■ ■ ��:' . . � � '. . ' �Y .;�.. 2015 2016 2017 ' . • • { � � � f�ln � � n � � . • • . . � • ��.� � ��^ , t -_ . � _ �. , � , � , � �� , ' ; E.. r • ' � . • �....--," 1 �``, ., �. � � ' ' � '' ' � �� r . , i a F t r � �— _ � -- � • � • �w � � �� , � i� � � � ;� � � � • �' , _ ��1'�� .�.� + �� • � . • • � � -� -� - , • - • - 2018 2019 2021 • � � • - T � -� - fm�8rn�.om.rt Gmer NeYer Re mtlo"ReY Bxmn � �9ape9cmowei � + � � � � � ^ 4� '�'�,, J �� ' /"c� �� :-„� �1 ...,.,,d,�y ■ • ■ -� e (`�'� :�� ✓�`.�_ �� y I - r �'a, ., ��_�` •� . • . • � ' y�'�� f — � �!'��,�_ .� ' �; a�1t. � . � � . � � r `� r � b , �� — - — �i� 'i ➢ � _ ,�.. � �1 ' u ; � � � t � �s , _� # �� f�" � ', . ,x��:... � ' , � ,� ..: �. ; �'� � � 2018 CRO's SCHOOL RESOURCE OFFICERS (SRO) , � � � Herr�tead High Scha� " '�� ..y... � �:. * ;��.h�id�,Schoa� � �� #� "�'� � S�fllOr�4.�. ..�a� �.°. � � -�.,� � � �� 'ty -:��s� � �. � '� y ��.�, �,� _�#, ,�i, '7'.�� ,, i , .�. � +��11.�U� . ... _ n � �� ., . � �_ ' ��i -_ � �t �1,. �'' � ."..�` �- �� *� . �'N• -,:� _ �� i %� �� ;, � �?; .. .- � �- ` - -. �� ' �taEy.:�cha�s � ,�`+� � � � y�[� y � �s�o-s��t�i��y ° - � o _.. .. '( �- �c� '°'� , ,.._ � _ . ..,�, �-�_ ,� , - - " :� _ '� ' _„� � _ �. _. _�.t � �� . _ ;;�;;- ��.; � sFto(DA�E}&As�eee a��e�de� _ �i� ,,t : R _.....� ,,. . . - - : . - ,,;, _ .._. Y__. ., :,. ,. ..; �. � . _.�: :�4 VOLUNTEERS . .. ._Yk � � ,�.t- .,•r. �. "��y'r ,.� yjL..,N � �4__ i:wy�..-s -K � 1 - Qf�'`�e,� � �S" Ft � -..- Iw.-r� R•!�. � . .. ��. 4 � y�y ti�� .� ]'�� y9� '%'� e..� - .�, � ,� � r ��- ' YI're_dµx � .. `` �� ,•. + �., � 1 � �� .. ��-�� i"'�;� �� •�� .�� V ��' . .�� w _�L � � � _ , �* - �--a"".�� rL ` � , - , � :�� .a. � � � � � ' , �`f `': ,'. - � _ °"� �"'r �� , -�... a ' `e'�`'�' � �� .,� _ _ �� . -- �R''� , �. ,-�.r-_ _ .� _ �.s�p,;� _. � . � ��. . . .. � _ � . - . --' � �""F r� . 3� ` �.-� s�� 5�rt��'� r�� _ � ��: �� o� �k� �� /' � � , r 1 y� y� ►�J � ��. -... �� !s. � 4�_ �_ �!` � _ _ " �� . � S 'i �r � '�_ �I �.-� �1 � � J y � � +w�'i'S• ' � ��.. � "^�. �`.` � �' ,�-� . .. 'F�, t'"'�` �. . �:l. is G� r; ,� _ -�� ^ i �r F. . ,��, .;� -�.�� `4'i'' y , � � � ..,� .-,�� ¢�� k:''� , � �-.. .} � ` '� ;'..-+�g� '� i� i sS �1. ; i _� : � , e - — /' `��r4 . , �_ . r � s , ti w�/ /'� �� " �. - f .�' '+ti � � , _ � �', _ � � - - ' ' a � _ ' �w �- � � � � - � . _ :.� . . __ �.; - _ .f �� ;Y � : r �� ' � -.i �, �� ' � '.°�� a� —�: f"'�: - ,:.�; ,-: ,�;,f� . A�� ' ...: ;,r�g'' ,�,' �` ' � �--- 7r,.. � ��`�_ 'k'Na `.�:"�' - _ ,�i'f` � � • � � � � � � � 70,000 6'I,158 58,573 58,817 6�,000 56�Q97 54�274 �5,986 56,184 56,153 55,695 53,445 55,791 �o,000 40,000 3�,000 20,000 10,000 FY11 FY'12 FY'13 FY14 FY15 FY'16 FY17 FY18 FY19 FY20 FY2'I 2011 -2021 average : 56 , 561 PART I CRIMES (Calendar Year 2014 - 2021 ) Compiled by the Dubuque Police Department �� t� CY19 �V21 CY21 N at'I °lo Clear Clear Differ ance ance PerFormance Measu res+A �Y�4 CY�� Y�G CY�� Y�8 CY�9 �Y20 �Y21 �4vg. ence 10 % No. of �rime� Again�t Pe 220 2B� 243 �0� 190 190 267 22� 22G -1�.4 s4.s 45.5 Nlurder 0 5 1 2 1 � 1 5 � 500.D so �e�u a I �ssa u I t 61 8� 98 9D �5 91 105 95 S� -11 .6 SS Robber�r �0 2� �6 1� �9 14 26 22 2� -15.4 77 �ggra�rated ��sault 1�9 15� 11 S 95 85 85 1�5 104 114 -�3.0 94 No. of �rimes Agai nst Pr 1 ,�� 1 ,953 1 ,87� 1 ,GG� � ,543 1 ,319 � ,24� � ,244 � ,5�4 O.D s9.9 �7.2 Burglar�r 4�6 548 420 331 299 �D5 219 �4D 335 9.6 s3.s Burgla�r�r to �lotor llehicl� 168 �D6 14� 1�� 145 �8 148 96 1�� -�5.2 �o Theft 1 ,D�� 1 ,��5 1 ,2�5 1 ,116 1 ,D�6 9�5 808 8�3 1 ,D�0 1 .8 59.7 Theft of Nlotar 1lehicle 43 �4 �6 �� 63 81 �0 8� 6� �1 .4 96 Total 1 ,882 2,218 2,11 S 1 ,8�0 1 ,��3 1 ,�09 1 ,512 1 ,470 1 ,�89 -2.8 � � � � � � � � � **yellaw denotes high number SHOTS FIRED (calendar year) ■ ■ 35 33 34 2S 25 26 25 24 2D 19 16 15 1Q 5 5 4 2014 2015 2016 2017 2018 2019 2�20 2021 Shots Fired & Homicides Comparison (CY 2021 ) �H �T� F I F�E� �f�l� H�1�1 I �I�E� �� Il� �� a� � f�1� ir�� 11 a ��r� ��r-t ��1 1� �� r� ��i �� 1�� t�r�l� � r��t ��t r��l� �� i �� it� 1.�� I �� it� �� a �k� �� r�i� � IL r��t r�� r�� 1 �� I�f� r�� IL r��t r�� r-t� � �� 1 �� TRAFFICACCIDENTS (CY21 ) ■ ■ 3,000 2,602 2,500 2,429 2,328 2,296 2,24'I 2,292 2,302 2,440 1 ,894 1,508 1,500 � 1,0�0 500 258 178 325 270 298 � 259 27fi 276 ■ � � ■ � ■ ■ _ ■ 2014 2015 2016 2017 2018 2�19 2020 2�21 AVG � Personal Injury � Property Damage � ��TI � � �� Hi I�-P�r��r�n�n�� r ar��a�i�n ��nd ��r��nu�ri � �ha� �s � � �Y E�IJ I T�� LE Da��-Dri�r�� ut��n�-F��u�� bu��t �n �Ir� ��ur pil��rs ��: ��IIII �I lJ I� IT1� + � � F � �I �I� E . . . � • • . . • � � f � � A 1�� r� !� .. - _��. �, . . 3� . 'k F �_ �� _ '�� . ' � �� ,.� � � �_ . � * � � - rf � - - - r, � � � ' �� '� , �� +„_ � #w FISCAL YEAR 2022 HIGHLIGHTS • Police Department COVID Response • Communit Diversion and Prevention y Coord i nator � � ' ' FY2022 I n itiatives ■ ■ • Recruitment and Hiring - Fi I I al I vacancies by the end of 2022 . - Antici pati ng vacancies by hiring ahead - Fluid and flexible training prog ram . � � � � ■ ■ ■ ■ ■ FY2022 I n it�atives • Getti n cau ht u p on mandato J g rY and needed trainings that were frozen during COVID . • Emotional I ntel I igence Trai n i ng • Succession Planning and Training ACCREDITATION . . � � ` � � � � • Originally accredited in 1993 �` � �. � • Longest accredited agency in lowa. S � + � . . . . �� '� • Re-accredited for eighth time in July � � �� 2020. � �/ , � �� • 484 Standards to be met for ��.�� . ,�,�' � � ti..,�� ,� ��,,�� _.�, accreditation - � � �,� � _ � � - " • Vi u I r - redi ti n in ec i n in � �� - rt a e acc ta o sp t o � �,� . summer 2021 (150 standards . reviewed . �� * ` � �� ) � � I . � �all� f�r ��r�ri�� ■ ■ �oo �� 0 �o�.� �o�� o�� o�� o�� o�o �o�� 2021 : 743 brain health calls 2015-2020: avg . 447 brain health calls � � � � �� _ � . . � THE ENI�TION�4L INTELLI�E�1�E NETU��IC � � EQ is the basis for de-escalation tactics. Every officer is taught de-escalation tactics, coupled with Brain Health response. Additionally, de-escalation has been taught to the City Council, the Fire Department, the Transit Department, and at the Cedar Rapids Police Academy. ��` C�Q ��`y �'�i� � � � � . • All new hire hires are given an emotional intelligence assessment which is then � � used in conjunction with their pre-employment psychological exam. Additionally, each officer as part of their field training program is given one-on-one coaching in mindfulness. In 2021 , Chief Jensen and Lt. Fullmer completed EQ coaching. Both have provided over 100 hours of EQ coaching to City employees. �xk�Yours�� J I I f • • _ � � � � � � � � � � � �7 � � �� J �I�� J � �� ■ � I��.l�� 15 463 033 229 . 35 � � Net Property Average homeowner's* Tax Support property tax cost for Police (*Avg. home value of $159,503) 1 . 1 . Tasers • � � . . Recu rri n $77 , 960 • gl . � • Less Lethal option for officers. • Less injury to suspects and officers. 1 . 2 . Body Worn Camera/Car Cameras • � � . . Recu rri n $ 131 ,400 • gl . � • Technology that is rapidly changing . • Transparency and accountability • Evidence 1 . 3 . Negotiating Throw Phone • � � . . Recu rri n $3 , 000 • gl . � • Allows officers to communicate with a person in crisis without being in close physical proximity. • Technology has changed . 1 . 4. Hard Drive Storage • � � . . N on-Recu rri n $ 150 , 000 • gl . � • Upgrade server storage for all the DLEC operating systems. • Generally needs to be done every 7 years. POLICE DEPARTMENT PERFORMANCE MEASURES ■ � Goals On Track: Goals Improving : Goals That Needs Work: • Police Re-Accreditation • School Resource • Data Analysis, • Kids Camp Officer: Direction and Evaluation, and Best Funding Practices www.cityofd u buq ue.org/pol ice