C O L L I N C O U N T Y B U D G E T 2 0 1 7 Workshop Agenda - - PowerPoint PPT Presentation

C O L L I N C O U N T Y B U D G E T 2 0 1 7

Workshop Agenda - Monday • FY 2017 Recommended Budget Overview – General Fund – Road & Bridge Fund – Operating Funds – Healthcare Foundation Fund – Other Funds – Total Combined Budget

Workshop Agenda: Monday-Wednesday • Items for Court Consideration – Outside Agency Budgets – Elected Officials/Department Heads who wish to address the Court – Compensation/Benefits Presentations, Discussion and Action – Commissioners Court suggested changes to Recommended Budget – Final Review of the Add/Delete List

C O L L I N C O U N T Y B U D G E T 2 0 1 7

General Fund Budget : Five-Year Trend $200 $8.1 $180 $7.5 $185.2 $11.6 $175.5 $160 $166.6 $158.4 $152.0 $140 $120 Recommended Budget Millions $100 $80 $60 $40 $20 5.0 % 5.3 % 5.5 % 4.4% $0 FY 2013 Adopted FY 2014 Adopted FY 2015 Adopted FY 2016 Adopted FY 2017 Recommended Expenditures One‐time

General Fund Actual $250.0 $201.9 $200.0 $185.6 $8.1 $180.5 $169.6 $185.2 $168.7 $11.6 $150.0 $151.8 Millions $146.2 $140.4 $134.1 Recommended Budget $100.0 Revenue Estimate $50.0 $‐ FY 2013 Actual FY 2014 Actual FY 2015 Actual FY 2016 YTD FY 2017 As of 8/3/2016 Recommended Revenue Expenditures One‐Time Expenditures Recommended revenue does not include potential tax rate reduction

Road & Bridge Fund Budget : Five-Year Trend $23.3 $23.2 $24 $22.5 $22.4 $22 $20.5 $20 $18 $16 $14 Recommended Budget Millions $12 $10 $8 $6 $4 $2 9.1% 0.4 % 3.2 % ‐0.4 % $0 FY 2013 Adopted FY 2014 Adopted FY 2015 Adopted FY 2016 Adopted FY 2017 Recommended Adopted Budget

Road & Bridge Fund Actual $25.0 $23.2 $23.2 $22.7 $22.4 $20.7 $20.3 $19.6 $20.0 $18.8 $18.2 $17.5 $15.0 Millions Recommended Budget $10.0 Revenue Estimate $5.0 $0.0 2013 Actual 2014 Actual 2015 Actual 2016 YTD 2017 As of 8/3/2016 Recommended Revenues Expenditures

Operating Funds Budget : Five-Year Trend $240 $220 $8.1 $213.6 $7.5 $200 $1.0 $11.6 $201.7 $180 $190.8 $183.0 $173.8 $160 $140 Recommended Budget Millions $120 $100 $80 $60 $40 $20 4.2 % 5.9 % 5.4% 5.7 % $0 FY 2013 Adopted FY 2014 Adopted FY 2015 Adopted FY 2016 Adopted FY 2017 Recommended Expenditures One‐time

Operating Funds Actual $240.0 $230.3 $220.0 $8.1 $203.8 $213.6 $200.0 $185.7 $192.0 $182.5 $180.0 $11.6 $170.2 $160.0 $166.5 $163.4 $140.0 Millions $120.0 Recommended Budget $104.8 $100.0 Revenue Estimate $80.0 $60.0 $40.0 $20.0 $‐ FY 2013 Actual FY 2014 Actual FY 2015 Actual FY 2016 YTD FY 2017 As of 8/3/2016 Recommended Revenue Expenditures One‐Time Expenditures Recommended revenue does not include potential tax rate reduction

Operating Funds - Detail FY 2016 FY 2017 Revenue Revenue % $220.0 $8.1 $228.0 Fund Estimate Estimate Change $213.6 $200.0 General Fund $184.5 $201.9 9.4% $180.0 Road & Bridge Fund $21.9 $20.7 ‐5.5% $160.0 Permanent $12,000 $5.4 % $140.0 Improvement Fund $120.0 Millions Total Operating $206.4 $228.0 10.5% $100.0 Recommended Budget FY 2016 FY 2017 $80.0 Revenue Estimate Adopted Recommended % Fund Budget Budget Change $60.0 General Fund $183.0 $193.3 5.6% $40.0 Road & Bridge $23.3 $23.2 ‐0.4% $20.0 Fund $‐ Permanent $3.0 $5.3 76.9% Improvement FY 2017 Recommended Fund Total Operating $209.2 $221.8 6.0% Revenue Expenditures One‐Time Expenditures Recommended revenue does not include potential tax rate reduction

Healthcare Fund Budget : Five-Year Trend $4.3 $4.5 $4.2 $4.0 $3.9 $4.0 $3.7 $3.5 $3.0 Millions $2.5 $2.0 $1.5 $1.0 $0.5 ‐12.8% 6.4% 2.4% 7.4% $0.0 FY 2013 Adopted FY 2014 Adopted FY 2015 Adopted FY 2016 Adopted FY 2017 Recommended

Healthcare Actual $4.5 $4.3 $4.0 $3.5 $3.1 $2.9 $3.0 $2.7 $2.6 $2.4 $2.5 Millions $2.0 Recommended Budget $2.0 $1.8 $1.7 $1.5 $1.2 $1.0 Revenue Estimate $0.5 $0.0 2013 Actual 2014 Actual 2015 Actual 2016 YTD 2017 As of 8/3/2016 Recommended Revenues Expenditures

Other Funds FY 2017 Recommended $29.4 $29.8 $30.0 $25.0 $20.0 Millions $15.0 $9.9 $10.0 $6.6 $6.00 $5.8 $5.6 $5.0 $2.4 $2.4 $0.0 $0.0 Grants Special Revenue Internal Service CSCD CCTRA Revenues Expenditures

Combined Funds Budget : Five-Year Trend $350 $8.1 $327.0 $7.5 $300 $21.0 $303.0 $13.1 $280.5 $250 $259.1 $266.7 $200 Recommended Budget Millions $150 $100 $50 5.2 % 8.1 % 7.9 % 2.9% $0 FY 2013 Adopted FY 2014 Adopted FY 2015 Adopted FY 2016 Adopted FY 2017 Recommended Expenditures One‐time

Combined Funds Actual $350.0 $8.1 $341.7 $336.8 $327.0 $311.1 $313.0 $300.0 $315.8 $306.3 $11.6 $299.4 $280.0 $281.0 $250.0 $200.0 Millions Recommended Budget $150.0 Revenue Estimate $100.0 $50.0 $‐ FY 2013 Actual FY 2014 Actual FY 2015 Actual FY 2016 YTD FY 2017 As of 8/3/2016 Recommended Revenue Expenditures One‐Time Expenditures Recommended revenue does not include potential tax rate reduction

Combined Funds $350.0 $8.1 $300.0 $327.0 $336.8 $250.0 $200.0 Millions Recommended Budget $150.0 Revenue Estimate $100.0 $50.0 $‐ FY 2017 Recommended Revenue Expenditures One‐Time Expenditures Recommended revenue does not include potential tax rate reduction

Combined Budget Details • One‐time expenditures from FY 2016 were eliminated – Reduction of $31.4 Million • FY 2017 Department Improvements – Increase of $32.8 Million • FY 2017 New Positions – Increase of $1.6 Million • Debt Service – Increase of $6.3 Million • Salary & Benefits – Increase of $7.1 Million • One Time Expenditures – Increase of $18.1 Million

Combined Budget Details • FY 2017 Department Improvements – $7,546,214 – Phase 2 of Public Safety Radio Replacement Project – $6,000,000 – Outer Loop Right of Way Acquisition – $4,232,425 – Increase in Permanent Improvement Projects – $1,500,000 – Mental Health – $900,000 – Court Appointed Prosecutor – $404,800 – Increase in EOL Switch/Router Replacements – $362,976 – Juvenile Detention Supervision Officers – $328,167 – Increase in EOL/EOS Desk Phone Replacements – $300,000 – Peoplesoft Consulting Services – $256,870 – Increase in Hardware Refresh Year 2 of 5 Year Refresh – $250,000 – Oracle Managed Services Contract – $200,000 – Peoplesoft Functional Consultant – $200,000 – Increase in Medical Examiner M&O Expenses

Authorized Positions 1,932 2,000 1,879 1,858 1,815 1,855 1,802 1,799 1,815 1,791 1,787 1,800 1,600 1,400 Total Recommended Positions 1,200 Total Requested Positions 1,000 800 600 400 200 ‐ FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Adopted Authorized at Year‐End

New Positions & Position Changes • New Positions and Position Changes – Increase of $1.6 million – Information Technology • ‐1 Part‐time Web Developer • +1 System Analyst/Programmer – IT – Records • ‐1 Records Manager • +1 Records Management Officer – IT – GIS • ‐1 GIS Analyst • +1 GIS Supervisor – County Court at Law Clerk • +2 Deputy Clerk II (Quality Control)

New Positions & Position Changes (Continued) – County Court at Law Clerk – Indigent Defense • +1 Legal Clerk I – County Court at Law Clerk – Probate • ‐1 Lead Clerk • +1 Probate Administrator – Medical Examiner • ‐1 PT Assistant Medical Examiner • +1 FT Assistant Medical Examiner • +1 Autopsy Technician – District Clerk • +1 Deputy Clerk I

New Positions & Position Changes (Continued) Combined Budget Details Combined Budget Details – County Auditor • +1 Functional Analyst – Tax Assessor/Collector • +2 Vehicle Registration Clerks ‐ McKinney • +2 Vehicle Registration Clerks ‐ Plano • +2 Vehicle Registration Clerks – Frisco

New Positions & Position Changes (Continued) – District Attorney • +1 Victim Assistance Coordinator (Domestic Violence) • +1 Chief Felony Prosecutor (Domestic Violence) • ‐1 PT Chief Felony Prosecutor (Civil Division) • +1 FT Chief Felony Prosecutor (Civil Division) • ‐1 PT Felony Prosecutor (Grand Jury) • +1 FT Felony Prosecutor (Grand Jury) – Sheriff • +1 Criminal Investigator

New Positions & Position Changes (Continued) – SO – Fusion Center • +2 HLS Coordinator • +2 Research Specialist • +1 Research Analyst • +1 Intelligence Analyst • +1 Administrative Secretary • +1 Fusion Center Director – Fire Marshal • ‐1 Tech I

New Positions & Position Changes (Continued) – Homeland Security • ‐2 HLS Coordinator • ‐2 Research Specialist • ‐1 Research Analyst • ‐1 Intelligence Analyst • ‐1 Administrative Secretary • ‐1 Fusion Center Director • ‐1 Asst. Emergency Management Specialist • ‐1 Emergency Manager

New Positions & Position Changes (Continued) – Emergency Management • +1 Asst. Emergency Management Specialist • +1 Emergency Manager • +0.25 Administrative Assistant – Juvenile Detention • +6 Juvenile Detention Officers – Road & Bridge • ‐1 Truck Driver • +1 Fuel Transport Agent – Engineering • 1 Engineering Technician

New Positions & Position Changes (Continued) – County Clerk Records • ‐1 Deputy Clerk I • +1 Deputy Clerk II – Healthcare • ‐1 TB Outreach • +1 Nurse (RN) – Bioterrorism • ‐0.25 Administrative Assistant