The URL can be used to link to this page

Home My WebLink About03. 2017 Budget Presentation Hearing Session I - Innovation & Technology2017 Budget Presentation Innovation & Technology Department August 15, 2016 TABLE OF CONTENTS POWERPOINT PRESENTATION ........................................................................ 2-11 FUND 279 311/INNOVATION/IT ...................................................................... 12-29 1 8/15/2016 INNOVATION &TECHNOLOGY Empowering and Connecting our Workforce and our Community 2017 Budget Presentation CONTEXT REALIZING THE IT STRATEGIC PLAN •Reorganization‐building capacity through centralization and specialization •Addressing decades of deferred maintenance, refreshing infrastructure & platforms •Empowering departments & residents •Inclusive access A strategic tool that enables fiscal sustainability while maintaining and improving services Goals Accomplishments •Capacity •Reporting •Transparent and open data •Investing in current systems •Centralization of information technology resources •Data management •Build organizational aptitude •Access to systems •Leverage technology •External partnerships & community engagement 2 8/15/2016 PREVIOUS STRUCTURE Admin and Finance CTO 3 System Specialist IV System Specialist III 2 System Sp ecialist II CIO Business Analyst Business Analyst Director 311 311 Liaison II 311 Liaisons (3X ) 311 Part Time Liaison (2X) Supervisor 311 Performance Improvemen t Manager PD Systems Analyst III Systems Analyst III Systems Analyst I Parks Systems Specialist PC Support PC Support Public Works Water Works System Specialist III Utility System Sp ecialist Engineering GIS Manager GIS Senior Specialist CIO Services Direc tor Services Manager Se rvices Sp ecialist Infrastru cture Dire ctor In fr astructu re Ma nager In fr astructu re Specialist Applic atio ns Direc tor D ata Manager Ap plications Ma nager Ap plications Developer Ap plications Developer Ap plications Developer Perform ance Man ager B us iness Analyst – Public Safety B us iness Analyst – Parks, Code, DC I B us iness Analyst – Pu blic Works Director 311 311 Liaison II 311 L i aison I (x3) 311 Liaison Pa rt Time (x2) Supe rvisor 31 1 C TO PROPOSED STRUCTURE 3 8/15/2016 BUILDING ORGANIZATIONAL STRENGTH Department I&T FTE 2016 2017 I&T FTE COIT 4 4 Admin &Fin 7 7 Police 3 3 Parks 1+ 2 (PTE)2 Water Works 1+1.5(IT FTE)1 Waste Water 1 0 Engineering(GIS)1 1 311 6 FTE +2 PTE 6 FTE +2 PTE Total 25.5 FTE & 4 PTE 24 FTE + 2 PTE BUILDING ORGANIZATIONAL STRENGTH 4 8/15/2016 Position Level 2016 Salary Cap Level 2017 Salary Cap Level C‐Level$100,284.00 $102,289.68 Director$73,440.00 Manager$64,955.00 $66,254.10 Specialist/Developers$53,613.00 $54,685.26 Business Analysts$50,980.00 $51,999.60 Supervisor$47,192.00 $48,135.84 Liaison II$44,664.00 $44,664.00 Liaison I$42,979.00 $42,979.00 Part Time Liaisons$26,858.00 $26,858.00 BUILDING ORGANIZATIONAL STRENGTH Attracting and retaining excellent talent in an inclusive environment. In‐sourcing high value positions. (over $2 million dollars of value) ORGANIZATIONAL HIGHLIGHTS Increased capacity with lower overall expenditures and no increase of FTEs •Established Functions with Directors •Reduced largest salary disparities with market rates •Outsourcing low‐value activities, insourcing high‐value activities Accomplished •GIS Administration from (2 FTE 1 FTE) •Departmental application support (4 FTE 2 FTE) •Infrastructure and security (1 FTE 3 FTE) •Services: Tier 1 (7 FTE 1.5 FTE) from $377,000 to $86,400 Planned •311 accommodate ~ 200 additional calls per day (Code and Building) without increasing FTEs 5 8/15/2016 ACCOMPLISHMENTS AND PROJECTS Kronos Digitizing Overtime and Time and Attendance in PD and modernizing rest of the City (in progress) Wireless in Downtown, Charles Black, and MLK Providing access that empowers our residents to connect with jobs, knowledge, and entertainment Improved Open Data Portal New data portal enhances how much data can be shared while saving the City $45,000 every year Connecting Employees and ResidentsReducing 40% of erroneous call transfers to automated pay systems Opportunities for All Engaging in technology and environmental education with new FALCAM and internship opportunities for graduates of the South Bend Code School 2017 PROJECTS Website Update our website to improve communications with residents and make it more mobile friendly Document Management Improve efficiencies while making government more transparent Departmental PrioritiesSupport Police and Fire through PSAP implementation, help with Forestry management in Parks, and assist utility as it modernizes billing to improve quality and reduce costs More Open Data Collaborate with departments to share our performance with residents to improve relationships Support our Employees and Residents Reducing waste and improving accountability Prepare for ERP Upgrade The Enterprise Resource Planning (Naviline) software is the heart of the City, but its core technology is reaching end of life, replacing it is imperative to streamline operations, avoid increases in cost, and empower our workforce (only item deferred from IT Strategic Plan) 6 8/15/2016 Type of Expenditure 2016 Amended Budget 2017 Proposed Budget Capital$39,000$0.00 Education & Training$2,416.00$2,416.00 Fringe Benefits$140,410.00$144,548.00 Other Interfund Allocations$13,253.00$1,451.65 Other Services & Charges $4,460.00$2,300.00 Repairs & Maintenance$3,336.00$0.00 Salaries & Wages$319,165.00$354,008.00 Supplies$5,300.00$10,300.00 Travel$11,017.00$11,500.00 Total$533,897.00$526,523.65 PROPOSED BUDGET 311 0.14% of Total City Budget Type of Expenditure 2016 Amended Budget 2017 Proposed Budget Capital$0.00$0.00 Education & Training$84,900.00$65,500.00 Fringe Benefits$436,030.51$498,265.00 Interest & Fees$14,259.00$10,207.00 Other Inter Fund Allocations$1,086.00$3,132.00 Other Services & Charges$6,460.00$0.00 Principal$406,572.00$153,113.00 Professional Services $1,844,435.00$765,153.00 Repairs & Maintenance$926,815.00$1,027,629.00 Salaries & Wages$994,379.00$1,159,138.00 Supplies$293,352.00$968,400.00 Travel$20,210.00$20,370.00 Grand Total$5,028,498.51$4,670,907.00 PROPOSED BUDGET INNOVATION AND TECHNOLOGY 1.27% of Total City Budget 7 8/15/2016 Type of Expenditure 2016 Amended Budget 2017 Proposed Budget Capital$39,000.00$0.00 Education & Training$87,316.00$67,916.00 Fringe Benefits$576,440.51$642,813.00 Interest & Fees$14,259.00$10,207.00 Other Interfund Allocations$14,339.00$4,583.65 Other Services & Charges $6,460.00$2,300.00 Principal$406,572.00$153,113.00 Professional Services $1,844,435.00$765,153.00 Repairs & Maintenance$930,151.00$1,027,629.00 Salaries & Wages$1,313,544.00$1,513,146.00 Supplies$298,652.00$978,700.00 Travel$31,227.00$31,870.00 Grand Total$5,562,395.51$5,197,430.65 PROPOSED BUDGET COMBINED 1.41% of Total City Budget $1,079,282.00 less in Professional services Only $265,974.49 more in Salaries and Fringe A 4X multiplier 2016 Project Name Cost Projected Return Kronos Implementation$ 189,786.00 $ 985,095.00 311 Online$ 231,767.00 $ 407,750.00 Security Assessments$ 52,000.00 Wireless in DT, and Youth Centers$ 62,000.00 2 Way Radio Connectivity Bills$ 625,400.00 GIS Improvements$ 142,000.00 $ 1,058,000.00 Total$1,302,953.00 $ 2,450,845.00 A STRATEGIC INVESTMENT THAT BUILDS FINANCIAL SUSTAINABILITY 8 8/15/2016 INNOVATION & TECHNOLOGY SERVICES DIVISION Recent Accomplishments •2017 Technology Refresh Deployment •Migration of Tier 1 HelpDesk to Partner Vendor •Active Directory Assessment •Upgrade of Gasboy System Future Projects •AD/Risk Assessment Remediation •Content Management Licensing Consolidation •Service Management Catalog for IT Services •Assist in Kronos Time & Attendance implementation •Software Licensing Review, Management, and Consolidation Current Projects •Sungard Hosted Solution •Selectron IVR Virtualization •Microsoft Licensing True‐ Up and conversion of Police licensing •311 Remote Site Plan & Testing •Tier 2 HelpDesk Support INNOVATION & TECHNOLOGY INFRASTRUCTURE DIVISION Recent Accomplishments •Migration of 40+ servers to Cloud hosted solutions(Azure,A WS, Micro) •Free wireless access to our Youth centers(Ch arles Black and MLK) •Assisted Application group moving City website to faster cloud environment •Setup/Repaired original FalCam live camera feeds •Risk and RISC Assessmen t for our entire computer infrastructure and security protocols •Creation and upgrade to file stor age and backups •Consolidation of our Database to a 2012 high performance SQL se rver •Use of consultation and outsourcing has decreased while infrastructure down time has also decreased •Move the switch at the Elbel golf course to consolidate locations an d free up space Future Projects •Refresh of end of life (EOL) network equipment(ASA,IPS,AMP,switches and routers)throughout the city’s network infrastructure •Begin implementing 10GB Network backbone •Increase AV/malware protection of servers by imp lementing a high end AV/malware protection software •Increase free wireless throughout the city for all residents and employees •Continue to assist in Kronos Time & Attendance imp lementation •Risk/RISC assessment remediation Current Projects •Creation of upgraded servers (from 2003 to 2012)for LaserFiche, Document Management System (DMS),and Web Link •Implementation of software to monitor all servers,network devices and websites to keep us ahead of any issues that may arise with the network infrastructure •Transfer of Core Switch and ASA (along wit h various other equipment)from CCB to Data Realty for better performance and utilization of space •Consolidation and organization of our MetroNet fiber among locati ons(from 46 pairs to roughly 26 pairs)to prepare for future growth of our network infrastructure •Implementation of Web Filtering groups(Depa rtments)to mitigate vir us/malware threats •Implementation of CRM infrastructure in Azure 9 8/15/2016 INNOVATION & TECHNOLOGY APPLICATIONS DIVISION Recent Accomplishments •Enabled single sign‐on for all ArcGIS products •Properly secured data feeds to the outside world •Migrated open data website with Innovation Division •Deployed City website to faster cloud environment •Setup FalCam and SmartStreets websites and live camera feeds •Automated live mapping of Cit y data •Migrated map data to faster cloud environment •Cleaned up and organized South Bend reference data •Built private cloud code repository to store all City code Future Projects •CRM department onboarding •CRM interfaces with other City software •Automated vehicle location live community mapping •Solid Waste live software update •Solid Waste special item pickup ad‐hoc routing •GIS data clean‐up •Automated reporting dashboards Current Projects •Customer resource management (CRM) deployment •Kronos data integration with SunGard •Computational routing for Solid Waste truck routes •Landlord registry deployment with Innovation Division •Daily automated reference data refresh •GIS training and SOP generation •Software contract negotiations INNOVATION & TECHNOLOGY 311 Recent Accomplishments •Received 110,000 YTD calls, 190,000 projected •Reduced automated payment transfers by over 40% Future Projects •On‐board Code Enforcement and Building Department •311 Strategic Plan Current Projects •Customer resource management (CRM) deployment 10 8/15/2016 INNOVATION & TECHNOLOGY PERFORMANCE AND INNOVATION Recent Accomplishments •Landlord Registration •Process mapping in the Utility •Smart Streets Website •Burglary Unit Database •KPI and Metrics Guide •Automated Enterprise Dashboards for all Departments •Food Truck App Future Projects •Police Open Data •Performance Management •Supporting Departmental Priorities •Utility Billing •Asset Management •Transportation •Facilitating PD analytics •Fire analytics •Diversity and Inclusion •Building permitting Current Projects •Automating PD Overtime, revising procedures across the City •Police website •Improved algorithms for water leak detection •PSAP systems review •Forestry management systems overview •Online payment of Code Violations •Standardized process mapping with SLA (Municipal Service Catalog) •Intranet 11 City of South Bend, Indiana 2017 Budget IT - Innovation - 311 Call Center - 279 Fund Summary - Operating and Capital Budget 2016 2017 Budget 2014 2015 Amended 30-Jun Proposed Forecast Variance% Description Actual Actual Budget Actual Budget 2018 2019 2020 2021 2016-2017 Change REVENUES Property Taxes- - - - - - - - - - - Local Income Taxes- - - - - - - - - - - Other Taxes- - - - - - - - - - - Grants/Intergovernmental- - - - - - - - - - - Charges for Services- - - - - - - - - - - Interfund Allocations- - 499,358 236,969 5,197,431 5,420,605 5,133,998 5,108,763 5,107,188 4,698,073 940.8% Fines & Forfeitures- - - - - - - - - - - Donations- - - - - - - - - - - Other Income- - - - - - - - - - - Transfers In- - - - - - - - - - - Total Revenue- - 499,358 236,969 5,197,431 5,420,605 5,133,998 5,108,763 5,107,188 4,698,073 940.8% EXPENDITURES BY PROGRAM 1 311 523,876 537,549 551,892 566,951 582,773 523,876 - 2 Compliance Management 228,474 238,472 224,635 222,975 222,389 228,474 - 3 Financial Services 345,732 360,949 339,711 337,095 336,121 345,732 - 4 Department Specific Applications 678,053 709,157 663,120 656,458 653,244 678,053 - 5 Enterprise Applications -ERP 529,334 553,333 518,429 513,598 511,405 529,334 - 6 Enterprise Applications -GIS 1,050,960 1,098,483 1,029,608 1,020,162 1,015,933 1,050,960 - 7 Help Desk & Training 160,497 167,354 157,382 156,002 155,377 160,497 - 8 Strategy 736,894 769,833 722,842 716,671 714,088 736,894 - 9 Network & Wireless 683,915 714,517 670,798 665,033 662,605 683,915 - 10 Performance 259,696 270,958 255,581 253,816 253,254 259,696 - 5,197,431 5,420,605 5,133,998 5,108,763 5,107,188 EXPENDITURES BY TYPE Personnel Salaries & Wages- - 319,165 150,319 1,480,202 1,509,800 1,539,990 1,570,784 1,602,194 1,161,037 363.8% Fringe Benefits- - 140,410 67,310 639,751 667,119 696,677 728,599 763,074 499,341 355.6% Total Personnel- - 459,575 217,629 2,119,953 2,176,919 2,236,667 2,299,383 2,365,268 1,660,378 361.3% Supplies- - 5,300 1,612 978,700 956,700 956,700 973,700 956,700 973,400 18366.0% Services & Charges Professional Services - - - - 801,159 447,300 447,300 447,300 447,300 801,159 - Printing & Advertising - - - - - - - - - - - Utilities- - - - - - - - - - - Education & Training- - 2,416 1,543 67,916 67,964 68,014 68,064 68,115 65,500 2711.1% Travel- - 11,017 6,813 31,870 31,690 31,925 32,164 32,408 20,853 189.3% Repairs & Maintenance- - 3,336 1,668 1,027,629 1,532,602 1,142,444 1,048,700 1,053,538 1,024,293 30704.2% Payment In Lieu of Taxes- - - - - - - - - - - Other Interfund Allocations- - 13,253 6,624 4,584 4,675 4,768 4,863 4,960 (8,669) -65.4% Debt Service:- Principal- - - - 153,113 192,422 191,731 180,736 130,000 153,113 - Interest & Fees- - - - 10,207 7,577 51,646 51,003 46,000 10,207 - Grants & Subsidies- - - - - - - - - - - Transfers Out- - - - - - - - - - - Other Services & Charges - - 4,461 1,080 2,300 2,756 2,803 2,851 2,900 (2,161) -48.4% Total Services & Charges- - 34,483 17,728 2,098,778 2,286,986 1,940,631 1,835,680 1,785,220 2,064,295 5986.4% Capital- - - - - - - - - - - Total Expenditures by Type- - 499,358 236,969 5,197,431 5,420,605 5,133,998 5,108,763 5,107,188 4,698,073 940.8% Net Surplus / (Deficit)- - - 0 0 - - - - Beginning Cash Balance- - - - - 0 0 0 0 Cash Adjustments- - - - - - - - - Ending Cash Balance- - - 0 0 0 0 0 0 Cash Reserves Target- - - - - - - - - 0.00% Explain Significant Revenue and Expenditure Changes Below: Innovation and Information Technology were previously funded from the General Fund and COIT. However, due to departmental consolidation in 2015, this fund now encompasses all expenditures relating to IT, Innovation, GIS, and 311. Expenditures were deducted from various funds and will be allocated back to user departments for 2017. Note: There is no cash reserve requirement for this fund. 12 City of South Bend, Indiana 2017 Budget IT - Innovation - 311 Call Center - 279 Fund Summary - Description, Accomplishments, Goals, KPI's Fund Description & Purpose 2016 Accomplishments & Outcomes - - - - - - - - - - 2017 Department Goals & Objectives & Linkage to City Goals Basics are Easy (BE) - - - - Good Government (GG) - - - - People/Places (PP) - - - Key Performance Indicators (KPI's) 2018 City Long Term 2015 2016 2017 Measure Goal Type Goal Actual Estimated Target -Downtime of business critical external services Basics Are Easy Quality 60 mins NA 100 mins -Information Security GPA Good Government Effectiveness 4/5 NA 2.7/5 3.5/5 -Strategic priority projects completed Good Government Effectiveness 6 NA 10 7 -Cost per Service Request - 311 Basics Are Easy Efficiency$2.00 $3.65$3.00 -311 Complaints per 1000 calls Basics Are Easy Quality -IT costs per user per year Good Government Effectiveness - - - - - - Types: output, efficiency, effectiveness, quality, outcome, technology 2017 Significant Changes/Challenges/Opportunities (with a focus on solutions) - - - - This fund was established in 2015 (for 2016 activity) to report on the operations of the City's 311 Call Center. A reorganization in late 2015 combined the 311 Call Center, IT, Innovation and GIS activities into one department for management purposes; however, funding remained as it was budgeted for 2016. Beginning in 2017, these activities will be combined into Fund 279. Established Governance Group with representatives of every department including Council IT committee representative to determine priorities and account for expenses (IT Strategic Plan goal) Developed route map for investment in infrastructure, security, applications, services, performance, management, and 311. These should evolve into strategic plans for each function (IT Strategic Plan goal) Leveraged external partnership with local vendor for Tier 1 support, improving data and facilitating resources (~$290,000) value enabled (IT Strategic Plan goal) Enhanced departmental participation in policy, data management, and platform configuration improving accuracy and improving performance (IT Strategic Plan goal) Enabled public Wi-Fi in downtown and digital access pilot in Monroe Circle by partnering with local philanthropies, the St. Joseph Co. Public Library, and enFocus Enabled public Wi-Fi at Charles Black and Martin Luther King Jr. Recreation Centers Migrated our Virtual environment to the Cloud Implemented a Cloud based backup solution Revamped Open Data Portal with mobile friendly interface and more live data sets (IT Strategic Plan goal) Continue leadership in the innovation and performance management space, presenting in national conferences, especially leveraging partnerships with local universities Reduce downtime of critical public facing systems - online payments, open data Improve access to city services to every resident while reducing the cost per request Further develop city wide project management methodologies Implement more rigorous contract management & negotiations. Increase access to transactional and business intelligence data, enhancing transparency and accountability Continue to improve access to digital resources to residents through partnerships and programs Provide more visibility to city processes through Performance management Create new partnerships and foster existing partnerships for a more open and connected City Further the competitiveness of South Bend in the technology sector Make South Bend more attractive as a place to research, develop, and deploy Smart Applications Enhance use of data to drive conversations and decisions both internally and externally - Develop solutions that Competitive market for technology and analytics talent - Improve long term success by consolidating organizational strength through reorganization and compensation structure. Changes in revenue from COIT to full allocations bring pressure on accountability and transparency - Create framework that allows departments to invest strategically while reducing costs Under investment in infrastructure and security - Ensure long term sustainability by creating infrastructure plan and funding it with a refresh schedule. 13 City of South Bend, Indiana 2017 Budget IT - Innovation - 311 Call Center - 279 Fund Summary - Full-Time Employees Report ONLY Full-Time positions 2016 2017 2015 Amended 6/30/2016 Proposed Forecast Position Actual Budget Actual Budget 2018 2019 2020 2021 Staffing (Full-Time Employees) Non-Bargaining Chief Innovation Officer 1.0 1.0 1.0 1.0 1.0 Chief Technology Officer 1.0 1.0 1.0 1.0 1.0 System Specialist IV/Infrastructure Manager 1.0 1.0 1.0 1.0 1.0 System Specialist IV/Data Manager 1.0 1.0 1.0 1.0 1.0 System Specialist IV/Director of Applications 1.0 1.0 1.0 1.0 1.0 System Specialist IV/Director of Services 1.0 1.0 1.0 1.0 1.0 System Specialist IV/Director of Infrastructure 1.0 1.0 1.0 1.0 1.0 System Specialist III/Services Manager 1.0 1.0 1.0 1.0 1.0 System Specialist II/Applications Developer I 3.0 3.0 3.0 3.0 3.0 System Specialist II/Service Specialist 1.0 1.0 1.0 1.0 1.0 System Specialist II/Infrastructure Specialist 1.0 1.0 1.0 1.0 1.0 GIS Manager 1.0 1.0 1.0 1.0 1.0 Business Analyst 3.0 3.0 3.0 3.0 3.0 Performance Improvement Manager 1.0 1.0 1.0 1.0 1.0 Director of 311 Customer Service 1.0 1.0 1.0 1.0 1.0 Supervisor - 311 Customer Service 1.0 1.0 1.0 1.0 1.0 311 Customer Service Liaison II 1.0 1.0 1.0 1.0 1.0 311 Customer Service Liaison I 3.0 3.0 3.0 3.0 3.0 Total Non-Bargaining - - - 24.0 24.0 24.0 24.0 24.0 Bargaining - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Total Bargaining- - - - - - - - Total Full-Time Employees- - - 24.0 24.0 24.0 24.0 24.0 Explain Significant Staffing Changes Below: Two Application Developer I positions were added for 2017. Titles of several other positions were changed. 14 2016 2016 20166/30/162017 20142015OriginalAmendedYTDYTDEstimated ACCOUNTNUMBERACCOUNTDESCRIPTION ActualActualBudgetBudgetActualActualRevenue IT-INNOVATION-311CENTER279-0000-380.10-80ITALLOCATIONFEE 0 0 00005,197,431 LEVELTEXT TEXTAMT 02ITALLOCATION 5,197,4315,197,431 ------------------------------------------------------------------------------------ * 0000005,197,431------------------------------------------------------------------------------------ **IT-INNOVATION-311CENTER 0 0 00005,197,431 15 2016 2016 20166/30/162017 20142015OriginalAmendedYTDYTDEstimated ACCOUNTNUMBERACCOUNTDESCRIPTION ActualActualBudgetBudgetActualActualRevenue 279-0104-392.04-00ADMINISTRATIVECOST 0 0499,358499,358288,648236,969 0------------------------------------------------------------------------------------ * 0 0499,358499,358288,648236,969 0------------------------------------------------------------------------------------ **311CALLCENTER 0 0499,358499,358288,648236,969 0------------------------------------------------------------------------------------ ***IT-INNOVATION-311CENTER 0 0499,358499,358288,648236,9695,197,431 0 0499,358499,358288,648236,9695,197,431 16 2016 2016 20166/30/162017 2014 2015OriginalAmendedYTDYTDProposed ACCOUNTNUMBERACCOUNTDESCRIPTION ActualActualBudgetBudgetActualActualExpenditures IT-INNOVATION-311CENTER279-0104-413.10-01REGULAR 0 0278,682274,950158,133126,515302,022 LEVELTEXT TEXTAMT 021DIRECTOR311CALLCENTER@$73,440 73,440 3311CUSTOMERSERVICELIASONS@$42,979 128,937 1311CUSTOMERSERVICELIASONII@$45,557 45,557 1311CUSTOMERSERVICESUPERVISOR@$48,136 48,136 PARTIALSANTI 10,229 ADJUSTMENTFORSALARYCAP 4,277-302,022 279-0104-413.10-04EXTRAANDOVERTIME 0 0 300 300 0 0 300 LEVELTEXT TEXTAMT 02STORMSEASON 300300 279-0104-413.10-09PERMANENTPART-TIME 0 043,91543,91528,66123,80452,780 LEVELTEXT TEXTAMT 02PARTTIME311CUSTOMERSERVICELIASONS29HRS/WKAT$18/HR 27,144 29HRS/WKAT$17/HR 25,63652,780 279-0104-413.11-01FICA-REGULAR 0 024,70224,70214,20011,42027,165 LEVELTEXT TEXTAMT 02ALLWAGES*7.65% 27,16527,165 279-0104-413.11-04PERF-REGULAR 0 031,21231,86218,33414,78833,860 LEVELTEXT TEXTAMT 02FULLTIMESALARIES*11.2% 33,86033,860 279-0104-413.11-07UNEMPLOYMENTCOMP 0 0 808 808 299 206 888 LEVELTEXT TEXTAMT 02ALLWAGES*.25% 888888 279-0104-413.11-08HEALTHINSURANCE 0 074,13676,72843,82237,63681,451 LEVELTEXT TEXTAMT 02HEALTH*$15,550 79,305 17 2016 2016 20166/30/162017 2014 2015OriginalAmendedYTDYTDProposed ACCOUNTNUMBERACCOUNTDESCRIPTION ActualActualBudgetBudgetActualActualExpenditures LTD*$96 586 HEALTHREBATE1*$1,560 1,560 81,451 279-0104-413.11-09LIFEINSURANCE 0 0 720 740 490 420 732 LEVELTEXT TEXTAMT 02LIFE*$120 732732 279-0104-413.11-12AUTOALLOWANCE 0 04,8004,8002,8002,400 0 LEVELTEXT TEXTAMT 02DELETED279-0104-413.11-24CELLPHONEALLOWANCE 0 0 300 770 495 440 660 LEVELTEXT TEXTAMT 02$55/MO*12 660660 ------------------------------------------------------------------------------------ *PERSONNELSERVICES 0 0459,575459,575267,234217,629499,858 279-0104-413.21-02PRINTSHOP 0 0 500 150 0 0 500 LEVELTEXT TEXTAMT 02MAILING 500500 279-0104-413.21-03C.S.-OFFICESUPPLIES 0 0 500 500 205 116 500 LEVELTEXT TEXTAMT 02ESTIMATE 500500 279-0104-413.21-04OTHER-OFFICESUPPLIES 0 01,8002,3501,6651,3081,800 LEVELTEXT TEXTAMT 02HEADSETS,BATTERIES,MAINTENANCE 1,500 2CHAIRS 300 1,800 279-0104-413.21-05SMALLOFFICEEQUIPMENT 0 0 500 300 188 1885,500 LEVELTEXT TEXTAMT 02ESTIMATE 500 7STANDUPWORKSTATIONS@$400-DELETEDVOICEANALYTICSSOFTWARE-DELETED 18 2016 2016 20166/30/162017 2014 2015OriginalAmendedYTDYTDProposed ACCOUNTNUMBERACCOUNTDESCRIPTION ActualActualBudgetBudgetActualActualExpenditures ADJFORSALARYCAP-DIDN'TWANTTOCHANGEALLOC 5,0005,500 279-0104-413.22-61PROMOTIONALSUPPLIES 0 02,0002,000 0 02,000 LEVELTEXT TEXTAMT 02311DAY,CUSTOMERSERVICEWEEK,BILLBOARDS,STREETBANNERS 2,0002,000 ------------------------------------------------------------------------------------ *SUPPLIES 0 05,3005,3002,0581,61210,300 279-0104-413.31-71CENTRALSTORESALLOCATION 0 0 0 0 0 0 22 LEVELTEXT TEXTAMT 02ALLOCATION 22 22 279-0104-413.31-72GISALLOCATION 0 011,35211,3526,6225,676 0 LEVELTEXT TEXTAMT 02PERALLOCATION279-0104-413.32-04TELEPHONE&TELEGRAPH 0 01,6802,1601,2601,080 0 LEVELTEXT TEXTAMT 02PERALLOCATION279-0104-413.32-21TRAVEL-MILEAGE 0 0 600 360 0 0 600 LEVELTEXT TEXTAMT 02ESTIMATE 600600 279-0104-413.32-22TRAVEL-AIRFARE 0 02,5002,3001,3651,3652,500 LEVELTEXT TEXTAMT 02ESTIMATEFORANNUALCONFERENCE 2,5002,500 279-0104-413.32-23TRAVEL-HOTEL 0 06,8506,8504,5914,5916,850 LEVELTEXT TEXTAMT 02311SYNERGY-DIR&2LIAISONSAGCCP-DIR&1LIAISONSOCIALMEDIASUMMIT-DIR&1LIAISONHTESUGACONF-DIR&1LIAISONTOTAL 6,8506,850 19 2016 2016 20166/30/162017 2014 2015OriginalAmendedYTDYTDProposed ACCOUNTNUMBERACCOUNTDESCRIPTION ActualActualBudgetBudgetActualActualExpenditures 279-0104-413.32-24TRAVEL-MEALS 0 0 750 750 733 733 750 LEVELTEXT TEXTAMT 02ESTIMATEFORCONFERENCES 750750 279-0104-413.32-25TRAVEL-OTHER 0 0 800 357 147 124 800 LEVELTEXT TEXTAMT 02ESTIMATE 800800 279-0104-413.34-02LIABILITYINSURANCE 0 01,9011,9011,106 9481,430 LEVELTEXT TEXTAMT 02PERALLOCATION 1,4301,430 279-0104-413.36-04COMPUTEREQUIPMENT 0 03,3333,3361,9461,668 0 LEVELTEXT TEXTAMT 02ALLOCATION279-0104-413.37-03OFFICESPACE 0 02,0002,000 0 02,000 LEVELTEXT TEXTAMT 02ESTIMATE-MORESPACE 2,0002,000 279-0104-413.39-11DUES&MEMBERSHIPS 0 0 300 300 0 0 300 LEVELTEXT TEXTAMT 02311SYNERGY 200 AGCCP 100300 279-0104-413.39-70EDUCATION&TRAINING 0 02,4162,8161,9431,5432,416 LEVELTEXT TEXTAMT 02311SYNERGY$200*3 600 AGCCP$150*2 300 SOCIALMEDIASUMMIT(TECHMEDIA)$350*2 700 PFEILINNOVATION$150*2 300 HTESUGA$125*2 250 COMPUTERBASEDTRAINING 266 2,416 ------------------------------------------------------------------------------------ 20 2016 2016 20166/30/162017 2014 2015OriginalAmendedYTDYTDProposed ACCOUNTNUMBERACCOUNTDESCRIPTION ActualActualBudgetBudgetActualActualExpenditures *OTHERSERVICES&CHARGES 0 034,48234,48219,71317,72817,668------------------------------------------------------------------------------------ **311CALLCENTER 0 0499,357499,357289,005236,969527,826 21 2016 2016 20166/30/162017 2014 2015OriginalAmendedYTDYTDProposed ACCOUNTNUMBERACCOUNTDESCRIPTION ActualActualBudgetBudgetActualActualExpenditures 279-0672-415.10-01REGULARSALARIES 0 0 0 0 0 0708,903 LEVELTEXT TEXTAMT 02VARIOUS 752,492 ADJUSTMENTFORSALARYCAP 43,589-708,903 279-0672-415.11-01FICATAXES 0 0 0 0 0 054,231 LEVELTEXT TEXTAMT 02ALLWAGES@7.65% 54,231 TOBALANCE 54,231 279-0672-415.11-04PERFRETIREMENT 0 0 0 0 0 079,397 LEVELTEXT TEXTAMT 02FULLTIMEWAGES@11.2% 79,39779,397 279-0672-415.11-07UNEMPLOYMENTCOMP 0 0 0 0 0 01,772 LEVELTEXT TEXTAMT 02ALLWAGES@0.25% 1,7721,772 279-0672-415.11-08HEALTHINSURANCE 0 0 0 0 0 0165,157 LEVELTEXT TEXTAMT 02@$15,550 162,498 @$96 1,099 REBATE@$1,560 1,560 165,157 279-0672-415.11-09LIFEINSURANCE 0 0 0 0 0 01,374 LEVELTEXT TEXTAMT 02@$120 1,3741,374 279-0672-415.11-24CELLPHONEALLOWANCE 0 0 0 0 0 011,880 LEVELTEXT TEXTAMT 0218EMPLOYEES@$55 11,88011,880 ------------------------------------------------------------------------------------ *PERSONNELSERVICES 0 0 0 0 0 01,022,714 22 2016 2016 20166/30/162017 2014 2015OriginalAmendedYTDYTDProposed ACCOUNTNUMBERACCOUNTDESCRIPTION ActualActualBudgetBudgetActualActualExpenditures 279-0672-415.21-04OTHEROFFICESUPPLIES 0 0 0 0 0 0625,400 LEVELTEXT TEXTAMT 02AT&T 482,576 MICROINTEGRATIONINTERNETBANDWIDTH 25,800 MICROINTEGRATIONVOIPSERVICE 117,024625,400 279-0672-415.21-05SMALLOFFICEEQUIPMENT 0 0 0 0 0 0103,000 LEVELTEXT TEXTAMT 02CDW-G-UPSBATTERYREFRESH 17,000 TIMECLOCKREPLACEMENTS 12,000 MISCFIBERREDUNDANCIES 13,000 MISCPERIPHERALS 15,000 MISCSOFTWARE 20,000 NETWORKCABLING 6,000 NETWORKPRINTERS 10,000 NEWDOCUMENTMANAGEMENT 10,000 103,000 ------------------------------------------------------------------------------------ *SUPPLIES 0 0 0 0 0 0728,400 279-0672-415.31-06OTHERPROFESSIONALSVCS 0 0 0 0 0 0579,193 LEVELTEXT TEXTAMT 02ADOXIO-SUPPORTFORCRM 10,000 ERP(NAVILINE)REPLACEMENT 100,000 GISMASTERPLANIMPLEMENTATION 259,200 RISK&ADMITIGATION/REMEDIATION 80,000 WEBSITEMANAGEMENT 50,000 NETWORKINFRASTRUCTION&SECURITYREVIEW 15,000 EXPANDMERAKI 6,800 ADJFORSALARYCAPS-DIDN'TWANTTOCHANGEALLOC 58,193 579,193 279-0672-415.32-21TRAVEL-MILEAGE 0 0 0 0 0 0 700 LEVELTEXT TEXTAMT 02MISCMILEAGE 700700 279-0672-415.32-22TRAVEL-AIRFARE 0 0 0 0 0 05,900 LEVELTEXT TEXTAMT 02TRAINING/CONFERENCE 5,900 23 2016 2016 20166/30/162017 2014 2015OriginalAmendedYTDYTDProposed ACCOUNTNUMBERACCOUNTDESCRIPTION ActualActualBudgetBudgetActualActualExpenditures5,900 279-0672-415.32-23TRAVEL-HOTEL 0 0 0 0 0 08,400 LEVELTEXT TEXTAMT 02TRAINING/CONFERENCE 8,4008,400 279-0672-415.32-24TRAVEL-MEALS 0 0 0 0 0 02,435 LEVELTEXT TEXTAMT 02TRAINING/CONFERENCE 2,4352,435 279-0672-415.32-25TRAVEL-OTHER 0 0 0 0 0 0 825 LEVELTEXT TEXTAMT 02TRAINING/CONFERENCE 825825 279-0672-415.34-02LIABILITYINSURANCE 0 0 0 0 0 03,132 LEVELTEXT TEXTAMT 02PERALLOCATION 3,1323,132 279-0672-415.36-04COMPUTEREQUIPMENT 0 0 0 0 0 01,027,629 LEVELTEXT TEXTAMT 02ACOM-ANNUALMAINT-HARDWARE 605 ACOM-ANNUALMAINT-SOFTWARE 3,038 AT&T-DATAPLANFORITIPADS 1,000 AT&T-AIRWATCHLICENSESFORNONITDEVICES 1,530 AWSMONTHLYUSAGE 24,000 BOLT-LASERFICHE/LINCDOC-LICENSE/MAINT 11,000 CALLREXRENEWAL 1,700 CDWG-AZURECOMMITMENT 24,000 CDWG-ITSUBSCRIPTIONS(VISIO) 3,000 CDWG-MICROSOFTENTERPRISEAGREEMENT 196,658 CONSTANTCONTACT 357 DROPBOXFORCOUNCILANDDCI 99 ESRI-GISENTERPRISESOFTWARE 51,000 ESRI-GISSUPPORTESRI-SOCRATAREPLACEMENTGEOJOBE-ADMINTOOLSFORARCGISONLINE 500 GODADDY-DOMAINNAMERENEWAL 75 GODADDY-WILDCARDSSLRENEWAL 299 KRONOS-HARDWAREMAINTCONTRACT 10,935 24 2016 2016 20166/30/162017 2014 2015OriginalAmendedYTDYTDProposed ACCOUNTNUMBERACCOUNTDESCRIPTION ActualActualBudgetBudgetActualActualExpenditures KRONOS-TIMEKEEPER 98,580 MICROINTEGRATION-CLOUDSTORAGE&VMHOSTING 80,000 MICROINTEGRATION-TASKFIREUSERLICENSES 2,340 MICROINTEGRATION-TIER1HELPDESKSUPPORT 86,400 MICROINTEGRATION-ACRONISBACKUP 20,000 DIGITALDEFENSEEVAANDIVASECURITYTOOL 8,000 MICROSOFT-CRMPORTALACCESS 5,000 MYSTAFFINGPRORENEWAL 10,000 NSI-CISCOWEBSECURITYNSI-MERAKILICENSING 1,200 NSI-SMARTNET 64,765 POHP-ONHOLDCOMMERCIAL 1,800 SINGLEWIRE-INFORMACASTMAINT 5,000 SMARTSHEETS 700 SUGAMEMBERSHIP 195 SUNGARD-HORIZONSAASCLOUDSERVICE 194,984 SUNGARDTRANSACTIONMANAGER 3,960 SURVEYGIZMO 810 TREK10MONTHLYHOSTING 1,800 CRMSERVICECATALOG 60,000 EXTERNALRACKSPACE 12,000 POSSIBLEERPREPLACEMENTSSLFORADFS.SOUTHBENDIN.GOVSSLFORGOVNOW 299 MONITORINGSYSTEM 15,000 GENERIALWEBSITEMAINTENANCEANDUPGRADES 25,000 1,027,629 279-0672-415.37-11CAPITALLEASEPRINCIPAL 0 0 0 0 0 0153,113 LEVELTEXT TEXTAMT 02#1 24,344 #4 1,413 #8 3,826 #9 20,701 #11 696 #12 2,133 #13&14ESTIMATE 34,000 2017COMPUTERREPLACEMENTSESTIMATE 21,000 SWITCHINGGEARREFRESHPROJECT 45,000 153,113 279-0672-415.37-12CAPITALLEASEINTEREST 0 0 0 0 0 010,207 LEVELTEXT TEXTAMT 02#1 1,635 #4 83 #8 416 25 2016 2016 20166/30/162017 2014 2015OriginalAmendedYTDYTDProposed ACCOUNTNUMBERACCOUNTDESCRIPTION ActualActualBudgetBudgetActualActualExpenditures #9 2,674 #11 86 #12 313 #13&14ESTIMATE 5,000 10,207 279-0672-415.39-70EDUCATION&TRAINING 0 0 0 0 0 063,400 LEVELTEXT TEXTAMT 02MEETING/CONFERENCEFEES 63,40063,400 ------------------------------------------------------------------------------------ *OTHERSERVICES&CHARGES 0 0 0 0 0 01,854,934------------------------------------------------------------------------------------ **INFORMATIONTECHNOLOGY 0 0 0 0 0 03,606,048 26 2016 2016 20166/30/162017 2014 2015OriginalAmendedYTDYTDProposed ACCOUNTNUMBERACCOUNTDESCRIPTION ActualActualBudgetBudgetActualActualExpenditures 279-0673-415.10-01REGULARSALARIES 0 0 0 0 0 0416,197 LEVELTEXT TEXTAMT 02VARIOUS 418,491 ADJUSTMENTFORSALARYCAP 2,294-416,197 279-0673-415.11-01FICATAXES 0 0 0 0 0 031,839 LEVELTEXT TEXTAMT 02ALLWAGES@7.65% 31,83931,839 279-0673-415.11-04PERFRETIREMENT 0 0 0 0 0 046,614 LEVELTEXT TEXTAMT 02FULLTIMEWAGES@11.2% 46,61446,614 279-0673-415.11-07UNEMPLOYMENTCOMP 0 0 0 0 0 01,040 LEVELTEXT TEXTAMT 02ALLWAGES@0.25% 1,0401,040 279-0673-415.11-08HEALTHINSURANCE 0 0 0 0 0 0100,917 LEVELTEXT TEXTAMT 02@$15,550 100,298 @$96 619100,917 279-0673-415.11-09LIFEINSURANCE 0 0 0 0 0 0 774 LEVELTEXT TEXTAMT 02@$120 774774 ------------------------------------------------------------------------------------ *PERSONNELSERVICES 0 0 0 0 0 0597,381 279-0673-415.21-05SMALLOFFICEEQUIPMENT 0 0 0 0 0 0240,000 LEVELTEXT TEXTAMT 02MISCPRIORITIZEDPROJECTS 240,000240,000 ------------------------------------------------------------------------------------ 27 2016 2016 20166/30/162017 2014 2015OriginalAmendedYTDYTDProposed ACCOUNTNUMBERACCOUNTDESCRIPTION ActualActualBudgetBudgetActualActualExpenditures *SUPPLIES 0 0 0 0 0 0240,000 279-0673-415.31-06OTHERPROFESSIONALSVCS 0 0 0 0 0 0221,966 LEVELTEXT TEXTAMT 02ENFOCUSFELLOWS 40,000 ENFOCUSINTERNS(INCLUDES2SUMMERITINTERNS) 45,500 ENFOCUSMISCCONSULTANTS-KRISPRIEMER 50,000 ENFOCUSCONSULTANT(BRIANDONOGHUE) 80,000 ADJFORSALARYCAPS-DIDN'TWANTTOCHANGEALLOC 6,466 221,966 279-0673-415.32-21TRAVEL-MILEAGE 0 0 0 0 0 0 700 LEVELTEXT TEXTAMT 02PENNYPRICECONTINUINGEDUCATION 700700 279-0673-415.32-23TRAVEL-HOTEL 0 0 0 0 0 0 700 LEVELTEXT TEXTAMT 02PENNYPRICECONTINUINGEDUCATION 700700 279-0673-415.32-24TRAVEL-MEALS 0 0 0 0 0 0 300 LEVELTEXT TEXTAMT 02PENNYPRICECONTINUINGEDUCATION 300300 279-0673-415.39-11DUES&MEMBERSHIPS 0 0 0 0 0 0 410 LEVELTEXT TEXTAMT 02PENNYPRICEINCPASDUES 300 PENNYPRICECPALICENSE 110410 279-0673-415.39-70EDUCATION&TRAINING 0 0 0 0 0 02,100 LEVELTEXT TEXTAMT 02PENNYPRICECPECLASSES 2,1002,100 ------------------------------------------------------------------------------------ *OTHERSERVICES&CHARGES 0 0 0 0 0 0226,176------------------------------------------------------------------------------------ **PERFORMANCE/INNOVATION 0 0 0 0 0 01,063,557 28 2016 2016 20166/30/162017 2014 2015OriginalAmendedYTDYTDProposed ACCOUNTNUMBERACCOUNTDESCRIPTION ActualActualBudgetBudgetActualActualExpenditures------------------------------------------------------------------------------------ ***IT-INNOVATION-311CENTER 0 0499,357499,357289,005236,9695,197,431 0 0499,357499,357289,005236,9695,197,431 29