HomeMy WebLinkAboutSession 9 - 2019 Budget - IT-Innovation-311 Call Center2019 Budget Presentation
Innovation & Technology
Department
September 17, 2018
TABLE OF CONTENTS
POWERPOINT PRESENTATION .................................................................................. 2-17
FUND 279 IT/INNOVATION/311 CALL CENTER ...................................................... 18-33
1
2019 Budget
Department of Innovation & Technology
Vision and Goals
We empower an innovative workforce and a thriving community through technology, data, and strategic partnerships.
•Gain efficiencies and transparency by continuing to centralize and allocate expenditures
•Plan and invest for future success
•Develop partnerships that continue to make South Bend competitive in a 21st century inclusive economy
2
Engaged Residents
Economy of the Future
Technology that Empowers
ExternalInternal
Services
311
Applications
Infrastructure
Business
Analytics
Civic
Innovation
Innovation and Technology
6 Divisions connecting
Residents and Employees
3
Technology needs are rapidly changing: data, wireless, tablets
0
10
20
30
40
50
60
70
Qtr3 Qtr4 Qtr1 Qtr2 Qtr3
2017 2018
Tablets Added Each Quarter To
Mobile Device Management
Android
Apple iOS
$57,000
53%
2018-2019
Increase in
Data
Storage
Increase in
Cell
Data
$92,376*
25x
2018-2019
$26,433**
2018-2019
Increase
From
New
Tablets
* From $3,000 to $95,000 due to transfer to centralized accounting, and
growth.
** Tablets for all department are now leased on 3 year cycles, this is the
yearly payment only for new iPads. As we replace iPads this number will
grow faster
Street department crews and Mayor Pete using iPads and GIS
to track leaf collection during fall 2017
4
Staff Changes: Supporting a Growing Need
•Deputy Chief Technology Officer – Transfer of Director of Assets & Information Systems from Engineering. With an accelerating pace of the adoption of new technologies including GIS, mobile devices, and a larger number of systems to track assets, Innovation & Technology will centralize the work previously performed by the Director of Assets & Inventory this past year in public works in order to build technical capacity that benefits all departments. Transfer
•GIS Specialist – With the large increase on the emphasis of data and GIS capabilities, this resource will help in the analysis of data, configuration and maintenance of GIS systems and will develop additional reporting and analytical tools. New Position
Amount Department Usage Recurrent
$112,450 Key Initiative Free Wifi - 5 New Sites in 2019 No
$ 25,000 Key Initiative Digital Access Site Hardware No
$ 40,000 Key Initiative SB Academy Yes
$150,000 PD Body and dash cameras .Yes
$24,089 All Depts Tablets (iPads)Yes
$ 25,000 Internal IT HardDrive Imaging Solution No
$286,000 All Depts Asset and Permitting Mgmt. –CityWorks ~$42k
$ 29,400 All Depts Enhanced Printing Solutions Yes
$ 30,000 PD and FD Lexipol –Policy Management System Yes
$ 52,116 All Depts New GIS Specialist Yes
$ 9,340 PD and FD New Public Safety Inventory Mgmt Yes
$ 19,912 All Depts Other new expenditures No
$803,307 for New Expenditures
Red denotes staff changes
5
Amount Dept Information
$ 16,810 Fire
Upgrades to Record Management System /
Investigation
$ 91,995 Police AFIS FingerPrint System Maintenance
$ 21,600 All Departments GIS Environment - vCloud resources
$ 76,311 All Departments Laserfiche Rio
$ 13,000 All Departments Sophos Server Anti-Virus
$ 25,000 VPA Recreation System Rectrac
$244,716 for upgraded software
Amount Dept Information
$ 164,952 All Depts.Consolidated Computer Leases
$ 83,692 All Depts.Consolidated Print Services
$ 84,660 All Depts.Deputy CTO
$ 80,700 Code Code Case Management - Accela
$ 61,703 Century Center Infrastructure Specialist
$ 54,100 DCI Business Analyst
$ 45,000 All Departments HP 2019 Computer Replacements
$ 43,000 PD and FD NetMotion
$ 10,000 Water and Waste Water SCADA Lease
$ 15,120 Century Center Century Center Software
$ 28,347 All Depts Other Transfers
$671,274 for transferred expenses
Red denotes staff changes
6
Innovation & Technology
Orange denotes new position
Green denotes transfer
Santiago Garces
Chief
Innovation
Officer
Brian Donoghue
Director of
Innovation
Cynthia Simmons
Director of
311 Center
Cathleen Sutherland
311
Supervisor
Billi Jo Mayfield
311
Customer
Service
Liason
Jennifer Sabin
311
Customer
Service
Liaison
Karina Carmona
311
Customer
Service
Liaison
Kyle Shuppert
311
Customer
Service
Liaison II
Maria Gonzalez
311
Customer
Service
Liaison
Tamina Ewing
311
Customer
Service
Liason
Dan O'Connor
Chief
Technology
Officer
Michael Sniadecki
Director of
Infrastructu
re
Jim Schrader
Infrastructu
re Specialist
Sal Parisi
Infrastructu
re Manager
Todd Dutoi
Infrastructu
re Specialist
Rene Casiano
Director of
Applications
John Lankowicz
GIS/Data
Manager
Kheran Joseph
Applications
Developer
Matt Coats
Applications
Developer
Michael Kennel
Applications
Developer
Shawn Delahanty
Director of
Services
Ann Orr
Services
Specialist
Sue Gerlach
Service
Manager
Danielle Fulmer
Director of
Business
Analytics
Anna Kennedy
Business
Analyst
Lucy Macfarlane
Business
Analyst
Transfer
Deputy CTO
Vacancy
GIS Senior Specialist
Vacancies
Business Analyst
Vacancies
Business Analyst
Vacancy
Manager of
Applications
Services
Applications
Infrastructure
311
Business Analytics
Highlighting Success: CRM 2.0
311, Business Analytics, Applications
7
Residents
Constituent
Resource
Management
Work order &
Financial Systems
Lines of code written for 311 portal
3,710
Lines of code written for CRM
5,384
8
Results
•CRM 2.0 lists actively used articles for the caller
•Mapping is great
•Prevents multiple service requests to department for same issue reported by multiple callers
•Ability to touch multiple articles has been a real time saver (90% time reduction)
•Easier to track
•Much more user friendly
•Can see call and pull up notes simultaneously
•Great project management
•Love the escalations and supervisor queue
Highlighting Success:Digital Inclusion
Services, Civic Innovation, Infrastructure
9
$200,000 per year
Div. of Services identified in
savings by centralizing telephone
and internet bills in 2017 ternet bills in
Savings enable Div. of
Infrastructure to connect 22 City
facilities and expand free Wi-Fi
Map:
Phase I of MetroNet Expansion to date
Div. of Civic Innovation partnered
with MetroNet and SJCP Libraries
identifying $90,000 in
philanthropic funding for digital
access centers
We have a digital access gap that prevents residents from connecting to lifelong learning and prosperity
Residents lacking access to any
high-speed Internet at home
Residents lacking access to
computers
10
CLICK.SB Bringing Technology and Connectivity Where People Live
Map of areas within 15 minutes of a proposed Click.SB sites
Color scale denotes percentage of households that are Low and Moderate Income, and the labels contain total LMI households
Free Public Wi-Fi Hotspots: Investment Across the City
City of South Bend’s Free Public Wi-Fi
deployments began in 2015 through a
partnership with the St. Joseph County
Community Foundation, Enfocus,
Metronet and a number of other
contributing sponsors.
In 2018, the Department of Innovation
and Technology took over management
of this Wi-Fi network and began
expanding to fill gaps in coverage based
on need, high foot traffic, and proximity
to existing Metronet
This investment and expansion will
continue in 2019
11
Spotlight: SouthEastNeighborhood Park
Based on resident feedback, interns from the Bowman Creek Educational Ecosystem worked this summer alongside the Metronet, DoIT’s Infrastructure Team, and community volunteers to bring solar-powered free Wi-Fi to the neighborhood park
Highlighting Success:Bloomberg Grant
I&T: Civic Innovation, Business Analytics
DCI: Empowerment and Engagement
12
$100,000
from Bloomberg
Philanthropies
12
pilots with
Uber
4
employers
500+
shift workers
1
co-creation
session
The problem
Reliable transportation is the primary barrier
to stable employment for shift workers
The solution
Integrated on-demand transportation services
as an employer-funded benefit for shift workers
Pilot Program Results
•All participants reported that the program made it easier to get to work
•83% were able to work more hours
•All were interested in participating again, and 83% would participate even if they paid $2 per ride
•Participants were eight percentage points less likely to be absent and worked one additional hour per shift on average
•Employers reported increased scheduling flexibility, decreased overtime costs and increased client satisfaction
•Our four employer partners have committed to providing financial and operational support moving forward
13
Appendix A: Divisional Accomplishments and Project Status
Recent Accomplishments
•New Remote Management and patching tool implementation (N-Able)
•Laserfiche –SBFD Inspection and Code Enforcement onboarded and scanning
•2018 Deployment –180 PC/Laptops
•Implemented new IVR monitoring tools
Future Projects
•Active Directory and File Rights review
•Service Management Catalog and ITSM
•Succession and Business Continuity Planning
Current Projects
•Print centralization -including print management, fax management, and rules-based routing
•Workstation imaging tool
•Microsoft 3 year Enterprise License Agreement
•Century Center On-Boarding
•Police reporting –Re-create all reports for public access requests
Services Division
14
Recent Accomplishments
Maintained and connected employees across 50+
facilities. Uptime continue to improve during this
timeframe between this year and last year:
Servers from 99.96 to 99.99
Network from 99.93 to 99.96
Optimized and invested in our fiber infrastructure.
Phase One & more completed. Added:
Central Fire, Fire Station #5, New Fire
Station #4, Park Maint, Street Dept, Colfax
Street Garage, Wayne Street Garage, Bldg
Dept, MLK Center, & CBC Center
MLK Center –Spark site & Wi-Fi Expansion.
Connect new Fire Station 4
Continuing to improve security and reliability.
Added:
Cisco AMP
Cisco Umbrella
SOPHOS EndPoint
New Wireless Infrastructures for Morris & SBPD (
Utility: In-Car/Body Cam Video).
COSB/WWTP Migration to Cloud environment
including Maximo.
Future Projects
Upgrade operating system of 22 critical servers from 2008R2 to 2016.
Including Active Directory and ADFS servers
Increase free wireless throughout the city for all residents and employees. Taking control of DTSB Wi-Fi.
AFIS (Crime Lab) upgrade at SBPD.
Continuing to improve & invest in security and reliability.
Connect new and remodeled facilities:
Fire Station #9
Howard Park Rec
Erskine Golf Pro
Data Migration: Prepare for exponential growth of data and storage needs. Ex. Police Migration, Century Center and Sewer’s videos.
UPS upgrades: replace current aging device over next three years.
Internal COSB Wireless refresh project.
Technical Resource Center at Ignition Park.
Current Projects
Continuing to optimize and invest in our fiber infrastructure. Phase Two:
Fire Station #10
Fire Station #8
Fire Station #7
Fire Station #3
Erskine Pro & Maint.
Studebaker Pro & Maint.
Working on solutions to increase Wireless Coverage throughout COSB including digital access sites.
Charles Black Center - Spark site & Wi-Fi
Expansion
Parking Garages & Century Center Parking w/ MetroNet (Amano).
Implementing COSB’s Enterprise Camera & Door Controller solutions to locations where needed:
Central Fire
Charles Black Center
Century Center onboarding.
Working with other depaetments including IT implementing their solutions.
Infrastructure Division
Recent Accomplishments
Website launch
CRM 2.0 launch
CRM –Utility account
integration
CRM –311 portal article integration
Software RFP, selection, and negotiations
Finances and procurement
Utility billing
Solid Waste system integration
Re-did utility account integration to
keep processes running
PSAP data clean-up
Helping St. Joseph County with data
clean- up and mapping
Future Projects
CRM service requests creationGathering prioritized City processes andcreating 311 service requests so 311 can use them to enter structure service requests
Reworking portal to accept newly created service requests
Identifying a security vendor to help 311 portal authentication process and issues before we launch
Build data analytics ETL processes and machine learning models
Solid Waste routing –computationally rerouting all master routes to realize savings
Utility billing implementationData conversion and ETL processesIntegration 3rd party systems
Finance and procurement implementationData conversion and ETL processesIntegration 3rd party systems
Cityworks implementationsData conversion and ETL processesProcess configuration and creationIntegration 3rd party systems
Current Projects
Solid Waste system full uprade
System will be upgraded to
newest version, put on a faster
server, and integration changed to
latest version
Kronos
HRIS and payroll software data
queries to do initial data load and
testing
Enterprise data analytics platform
Finding a vendor to help
build a data analytics
environment to
CRM knowledge management
Changing the whole process and
technology that manages the 311
portal articles and the approval
process for it.
Applications Division
15
Recent Accomplishments
•Served four departments (Police, Fire, VPA, and Utility) in Stat meetings each quarter of 2018
•Project management for the launch of the new website
•First annual Community Survey regarding resident perceptions and satisfaction with services
•SB Academy classes on Excel and Process Improvement
•Supported City Works pilot in Sewers
•Supported VPA Facilities and Grounds division in process improvements
•Randomized control trial of billing late notice in collaboration with the Utility
Future Projects
•Develop second tier of SB Stat services for departments not served by current program
•Lead enterprise data management and data governance efforts
•Work with Waze data to understand traffic patterns in South Bend
•Support departments in creating Service Request intakes for website
•Adobe Sign pilot with Council and Clerk’s’ Office
•Assist VPA in measuring and tracking health of the park system
•Offer additional SB Academy classes, such as Project Management, Power BI, and Human-Centered Design
Current Projects
•Introduction of new inter-departmental Neighborhood SB Stat meetings
•Improvements to the Knowledge Management process and system
•Comprehensive 311 dashboards
•Annual report on Police recruiting
•Helping VPA Recreation division develop goals and KPI(s) for the new Mobile Recreation Unit
•Identify improvements to process for new address creation
•Pilot of online work order repository for VPA Facilities and Grounds to enable a digital solution and better access to data
•Build platform and dashboard for DCI to track investment incentives
•Collaborations on data science and analytics projects with Notre Dame classes and professors
Business Analytics
Recent Accomplishments
•1 to 5 ratio of external
partnership contributions ($1,2
Million)
•Launch of first CLICK SB site at
Martin Luther Junior Community
Center
•Bloomberg Mayor’s Challenge
Pilot Program
•Secured funding for Drucker
LifeLongLearning Initiative from
Google.org and Wal-Mart
Foundation Stage 1
•Secured SkillUpState ofIndiana
Workforce Grant forLocal
Innovation Network
•Secured Cities of Service Grant
for housing remediation
•GCN's 2018 Government
Innovation Award
Future Plans
•Development of
programming for theTechnology Resource Center
and Click SB sites
•Working with St. Joseph
Public Library to expand
Downtown Free Wireless
network to bridge digital
divide
•Working with local
universities to provide
mutually beneficial civic-
applied projects
•Working to coordinate
engagements with national
networks including MetroLab
and Civic Analytics Network
•Working closely with CoSB
Business Development and
Economic Empowerment to
connect Workforce
Development, Technology
and Opportunity
Current Projects & Grants
•NSF PAWR: Advanced
Wireless Testbed
•CLICK SB second site at
Charles Black Recreation
Center
•Bloomberg What Works Cities
•Technology Resource Center
•Kauffman Foundation Grant
•Organization for Economic Co-
operation and Development
Grant
•Large Regional Economic
Development Grant
•Working to secure funding for
City of Lifelong Learning
Initiative Stage 2
•IdeaWeek 2019
Civic Innovation Division
16
Recent Accomplishments
Partnered with Neighborhood Code Enforcement
Fielded over 755,000 calls since implementation
88,972 YTD (125,000 calls projected)
Average handle time 74 seconds
Handle ratio 97.8%
Average hold time 10 seconds
Entered 1750 service requests in new CRM since
7/30/18
Partnered with 13 City departments to date
Assisted with extensive testing and implementation of
CRM 2.0
Trained in Acella for Code Enforcement
Trained in Elemos for Solid Waste
Trained in NaviLine for Utilities
Assisted Solid Waste during transition with 1648
online requests from 5/23-8/24 for:
Extra Pick-up’s
Yard Waste Extra Pick-up’s
Yard Waste Container Requests
Trash Container Requests
All Container repairs
Missed Trash Collection
General Concerns
Complaints
Crew Reminders
Liaisons certified in Customer Service, “Say This,
Not That”, endorsed by the Association of
Governmental Call Center Professionals
Future Projects
Will partner with Building Department
Engage in Community Outreach
Current Projects
Preparing for Chat implementation
for alternative communication
channel
Training with Animal Care and
Control for Pet Point implementation
which will provide direct dispatch
from 311 to officers in the field to
eliminate delayed reporting
Assisting with 311 rebranding
efforts
311 Customer Service Center
17
City of South Bend, Indiana 2019 Budget
Fund 279 - IT / Innovation / 311 Call Center
Fund Type Internal Service Funds Control City Funds
2018 2019 Budget
2016 2017 Amended 06/30/18 Proposed Forecast Variance %
Actual Actual Budget Actual Budget 2020 2021 2022 2023 2018-2019 Change
Revenue
Interest Earnings - - 7,645 7,645 10,000 10,000 10,000 10,000 10,000 2,355 31%
Donations - - 100,000 100,000 - - - - - (100,000) -100%
Other Income - - 30,000 24,979 45,062 - - - - 15,062 50%
Interfund Allocation Reimb 487,896 5,167,452 6,850,931 3,394,476 7,991,331 7,465,929 7,626,325 7,539,768 7,569,938 1,140,400 17%
Transfers In - - - - - - - - - - -
Total Revenue 487,896 5,167,452 6,988,576 3,527,100 8,046,393 7,475,929 7,636,325 7,549,768 7,579,938 1,057,817 15%
Expenditures by Dept
311 Call Center 487,896 504,388 595,066 264,381 557,310 617,240 626,417 635,781 645,329 (37,756) -6%
Innovation & Technology - 3,073,982 6,560,046 2,537,665 7,794,658 6,848,689 6,999,908 6,903,987 6,924,609 1,234,612 19%
Total Expenditures 487,896 3,578,369 7,155,112 2,802,046 8,351,968 7,465,929 7,626,325 7,539,768 7,569,938 1,196,856 17%
Expenditures by Type
Personnel
Salaries & Wages 319,674 1,358,197 1,629,235 754,126 1,942,598 1,981,343 2,020,864 2,061,176 2,102,293 313,363 19%
Fringe Benefits 137,668 544,115 744,584 302,599 692,708 910,995 918,608 926,376 934,298 (51,876) -7%
Total Personnel 457,342 1,902,312 2,373,819 1,056,725 2,635,306 2,892,338 2,939,472 2,987,552 3,036,591 261,487 11%
Supplies 2,656 78,073 107,877 40,347 71,850 88,850 71,850 88,850 88,850 (36,027) -33%
Services & Charges
Professional Services - 302,765 1,462,278 445,190 1,067,434 722,750 722,750 752,750 722,750 (394,844) -27%
Printing & Advertising - - 298 298 5,150 5,150 5,150 5,150 5,150 4,852 1628%
Education & Training 2,033 12,788 75,939 11,720 77,900 77,900 77,900 77,900 77,900 1,961 3%
Travel 6,836 30,823 58,692 7,339 27,110 29,110 29,110 29,110 29,110 (31,582) -54%
Repairs & Maintenance 3,336 1,080,648 2,455,571 1,084,959 3,055,487 2,863,987 3,005,579 2,867,083 2,937,799 599,916 24%
Other Interfund Allocations 11,352 24 144 72 352 352 352 352 352 208 144%
Debt Service
Principal - 136,360 189,900 55,199 350,403 329,988 323,684 284,956 228,679 160,503 85%
Interest & Fees - 15,429 40,403 4,460 63,219 57,747 52,721 48,308 45,000 22,816 56%
Grants & Subsidies - - - - - - - - - - -
Insurance 1,896 4,560 5,067 2,532 6,433 6,433 6,433 6,433 6,433 1,366 27%
Other Services & Charges 2,445 14,586 385,124 93,204 391,324 391,324 391,324 391,324 391,324 6,200 2%
Transfers Out - - - - 600,000 - - - - 600,000 -
Total Services & Charges 27,898 1,597,985 4,673,416 1,704,974 5,644,812 4,484,741 4,615,003 4,463,366 4,444,497 971,396 21%
Capital - - - - - - - - - - -
Total Expenditures 487,896 3,578,369 7,155,112 2,802,046 8,351,968 7,465,929 7,626,325 7,539,768 7,569,938 1,196,856 17%
Net Surplus / (Deficit) - 1,589,083 (166,536) 725,054 (305,575) 10,000 10,000 10,000 10,000
Beginning Cash Balance - - 1,589,083 1,422,547 1,116,972 1,126,972 1,136,972 1,146,972 Cash Reserve
Cash Adjustments - - - - - - - -
Ending Cash Balance - 1,589,083 1,422,547 1,116,972 1,126,972 1,136,972 1,146,972 1,156,972
Cash Reserves Target - - - - - - - -
Fund Purpose:
Explanation of Revenue Sources:
Explanation of Expenditures, Staffing, and Significant Changes/Variances:
No reserve requirement
This internal service fund tracks the revenues and expenditures of the Department of Innovation & Technology, which includes the 311 Call Center, Services, Infrastructure, Business Analytics,
Applications, and Civic Innovation. The 311 Call Center was established to handle resident telephone calls in an efficient and effective manner. It provides residents with a "one-stop" shop to contact city
departments with inquiries and service requests. Starting in 2017, IT Dept costs were moved to this fund. The IT Dept provides technical services to the various departments within the City. The
Department of Innovation & Technology's goal is to empower an innovative workforce and a thriving community through technology, data, and strategic partnerships.
Centralized IT: In 2019, the City continues to centralize IT expenditures from other departments. In the past, these consolidations have led to annual savings of over $300k as we gained visibility into
underutilized services and assets. In 2019, an additional $671,000 of departmental costs are being charged to Fund 279 and allocated back to the respective departments.
ERP Implementation: In 2019, $600,000 (from prior year reserves) will be transferred to COIT Fund 404 to cover the cost of the new enterprise resource planning (ERP) software implementation. The
ERP implementation is estimated to cost $2.4 million over 5 years.
Mayoral Initiatives: SBAcademy, the City’s training program, has trained employees in novel techniques that enable process improvements and other innovations that will continue to make government
more efficient ($40k). IT is requesting funding to maintain and expand the quality of digital inclusion initiatives ($137k).
CityWorks: In 2019, IT will continue to grow the enterprise work order, permits and licensing, and asset management system. In 2018, CityWorks was selected as the enterprise platform because it
integrated well with GIS and had substantial adoption from similarly sized cities. Based on departmental demand, IT is requesting funding to onboard the Department of Community Investment (DCI),
Parks Maintenance, Forestry, Traffic & Lighting, and the Street Dept.
This fund receives revenue in the form of an interfund allocation. The cost of the 311 Call Center and the Department of Innovation & Technology is allocated between the City departments based on
various criteria including number of devices, number of user licenses, departmental specific software renewal, and more.
18
City of South Bend, Indiana 2019 Budget
Fund 279 - IT / Innovation / 311 Call Center
Accomplishments, Goals, KPI's
2018 Accomplishments & Outcomes
-
-
-
-
-
-
-
-
2019 Department Goals & Objectives and Linkage to City Results
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Key Performance Indicators (KPI's)
Measure Type
2017
Actual
2018
Estimated
2019
Target
Long Term
Goal
- Infrastructure - server uptime Effectiveness 99.96% 99.99% 99.99% 100%
- 311 Call Center - number of calls Output 125,057 125,000 130,000 150,000
- 311 Call Center - average hold time Efficiency 10 sec 10 sec 9 sec 7 sec
Types: output, efficiency, effectiveness, quality, outcome, technology
2019 Significant Changes/Challenges/Opportunities
-
-
Services Division: Saved money by participating in Quantity Purchase Agreements (QPAs): 2018 Deployment QPA Price = $199,153 vs. MSRP =
$276,824
Infrastructure Division: Network is available and reliable
Server Uptime: 99.989744% (39 Servers) (includes a SQL Test Server) Majority of downtime were planned outages from Microsoft patching).
311 Customer Service Center
Users have software that supports their operation
Business Analytics: Number of major projects currently active = 16 / Year-to-date number of projects completed = 25
Applications Division
Infrastructure Division: The city is able to continue operations despite adverse events: Storage backed up – 72.5TB
Applications Division: Number of enterprise applications =12 / number of stand-alone applications = 33
Attract talent to our department (internship and fellowship programs)
Switch Uptime: 01/01/18 to 07/27/18 - Uptime for all of South Bend was 99.87293 which included both planned and unplanned outages which also
included both the Great Flood and the Downtown Power Outage (Mi & LaSalle).
Support all city locations with network (indoors and outdoors): continue MetroNet expansion project
Develop and maintain strategic partnerships: Percentage of active partners <50% with an active project or joint proposal pending
Problems are addressed on a first attempt
311 Call Center: Provide accurate and timely information to residents using Knowledge Based Articles
Proactively plans with other departments for changing demand, adapting to seasonal and cyclical patterns in call volume
The call center operates reliably and is available to residents
Infrastructure Division: Percent completion of MetroNet expansion project: At end of 2017, 47% of the City locations were on Metronet. As of
today, 63% of City’s locations are on the Metronet. These numbers are locations by BLDGs not Departments within.
Residents and Departments are satisfied with the quality of the service
Users are productive and safe as soon as they start work; Currently, all devices are patched within 60 days of a patch being available
Business Analytics: Number of employees participating in SB Academy = 105
Civic Innovation
Activate philanthropic and private investment in the City
Services Division
Account for resources in a timely manner when an employee leaves; Current average amount of time to collect devices after a separation = 2 wks
There is a fast-growing demand for additional devices and software packages in support of the needs of the city departments. For instance, in July of
2018 the Police Body cameras and new in-car video system was implemented and has generated over 5 Tb of data with over 150 net new devices from
body cameras alone. We see similar patterns in other departments with exponential adoption of iPads for field work, and sewer video being captured
with the GraniteNet inspection software, see figure below to observe this exponential growth. This growth also translates to an increase in the amount
of data, number of software packages, demands on IT resources, etc. We have accommodated the growth in demand for IT services without any
significant increases to the IT staff by leveraging our vendors more, and gaining efficiencies in the management of IT. This growth strategy is at its
limit. Sometime in the next few years, we recommend adding a Mobile Device Manager for the Services Group, adding a second Infrastructure
Manager to increase capacity for security projects, an Applications Developer to maintain a growing number of enterprise systems, and potentially
others.
Technology increases productivity of the workforce and makes them more efficient. When we do a projection of benefits of new technology solutions,
we assume the organization is going to maintain the same level of operation, so the new efficiencies translate into cost savings. However, what we
continue to find is that departments adjust their operations to increase the service levels or add new offerings.
Changes in configuration are communicated to users in a timely fashion
Infrastructure Division
Business Analytics
Ensure City employees know how to use data and innovative skills
Continue process mapping and improving processes
Continue to give departments clear and effective access to projects and complete those projects on time
Work on building enterprise data dashboards
All residents empowered with technologies: Free Wi-Fi, access centers, LRNG, City website
Number of partners – 90 (30 New)
Departments play an active role and ownership of the applications
Appropriate applications provide solutions in a cost effective manner
Integrations facilitate work in departments by making data available across departments and applications
Data is available, searchable, and usable by internal and external customers
Network is safe and secure: Continue to track Information Security GPA/ Risk Assessment
19
City of South Bend, Indiana 2019 Budget
Fund 279 - IT / Innovation / 311 Call Center
Staffing (Full-Time Employees only)
2018 2019
2017 Amended 06/30/18 Proposed Forecast
Position (* New title or additional position)Actual Budget Actual Budget 2020 2021 2022 2023
Non-Bargaining
311 Call Center (0104)
Director of 311 Customer Service 11111111
Supervisor - 311 Customer Service 11111111
311 Customer Service Liaison 34444444
311 Customer Service Liaison II 11111111
Information Technology /Innovation (0672)
Chief Technology Officer 11111111
Chief Innovation Officer 11111111
Deputy Chief Technology Officer *00011111
Director of Infrastructure 11111111
Director of Applications 11111111
Director of Services 11111111
Director of Business Analytics 11111111
Director of Civic Innovation 01111111
Manager - Infrastructure 11111222
Manager - Applications 11011111
GIS Manager 11111111
Manager - Services 11111111
Manager - Mobile Devices 00000111
System Specialist III 01111111
Applications Developer 33333444
Specialist of Infrastructure 11111111
Specialist of Services 11111111
Business Analyst ** 33444444
GIS Specialist *** 00011111
Total Non-Bargaining 24 27 27 30 30 33 33 33
Total Full-Time Employees 24 27 27 30 30 33 33 33
Explain Significant Staffing Changes Below:
* New position
** Correct the FTE's for Business Analysts, should have been 4 in 2018
*** Addition of GIS Technician position - GIS is critical for an increasing number of applications including the 911 CAD system, Code Enforcement, and
Public Works Asset management. IT is requesting an FTE to support the increase on the emphasis of data and GIS capabilities. This resource will help in
the analysis of data, configuration and maintenance of GIS systems and will develop additional reporting and analytical tools.
20
CITY OF SOUTH BENDEXPENDITURES2019 BUDGET201820182018 6/30/18 201920162017 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresIT-INNOVATION-311 CENTER279-0104-413.10-01 SALARIED WAGES279,121 309,341 355,293 355,293 249,804 179,121 356,326LEVEL TEXTTEXT AMTBUDG TOTAL FTE - 71 DIRECTOR 311 CUSTOMER SERVICE76,4071 SUPERVISOR - 311 CUSTOMER SERVICE50,0814 311 CUSTOMER SERVICE LIASON @ $45,610182,4401 311 CUSTOMER SERVICE LIASON II47,398356,326279-0104-413.10-03 SEASONAL & INTERNS000000 5,300LEVEL TEXTTEXT AMTBUDG 311 INTERN - $11/HR FOR 12 WEEKS5,3005,300279-0104-413.10-04 EXTRA AND OVERTIME00005500279-0104-413.10-09 PERMANENT PART-TIME40,553 24,391 22,358 22,358 1,770 1,770 22,805LEVEL TEXTTEXT AMTBUDG 1 PART-TIME 311 CUSTOMER SERVICE LIASON22,80522,805279-0104-413.10-10 HIRING BONUS0 2,00000000279-0104-413.11-01 FICA - REGULAR24,297 24,955 28,891 28,891 18,347 13,261 29,510LEVEL TEXTTEXT AMTBUDG TOTAL WAGES X 7.65%29,510.10-01 SALARIED WAGES $356,326.10-03 SEASONAL/INTERNS $5,300.10-09 PERMANENT PART-TIME WAGES $22,805.11-24 CELL PHONE ALLOWANCE $1,32029,510279-0104-413.11-04 PERF - REGULAR31,892 33,826 39,793 39,793 25,972 18,651 40,056LEVEL TEXTTEXT AMTBUDG BENEFITED WAGES X 11.2%40,056.10-01 SALARIED WAGES $356,326.11-24 CELL PHONE ALLOWANCE $1,32040,056279-0104-413.11-07 UNEMPLOYMENT COMP456000000279-0104-413.11-08 HEALTH INSURANCE74,688 80,016 115,702 115,702 63,842 44,325 70,392LEVEL TEXTTEXT AMTBUDG HEALTH INSURANCE:
21
CITY OF SOUTH BENDEXPENDITURES2019 BUDGET201820182018 6/30/18 201920162017 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures$704.17 X 24 PAY PERIOD = $16,900 X 7 FTE118,3002019 HEALTH INSURANCE DEDUCTION - ONE TIME48,580-LONG TERM DISABILITY:$4.00 X 24 PAY PERIODS = $96 X 7 FTE67270,392279-0104-413.11-09 LIFE INSURANCE765750852852400300840LEVEL TEXTTEXT AMTBUDG $5 X 24 PAY PERIODS = $120 X 7 FTE840840279-0104-413.11-12 AUTO ALLOWANCE4,800000000279-0104-413.11-24 CELL PHONE ALLOWANCE770660660660440330 1,320LEVEL TEXTTEXT AMTBUDG $55PERMOX12MONTHSX2EMPLOYEES1,3201,320279-0104-413.11-29 PARENTAL LEAVE00945945627463891LEVEL TEXTTEXT AMTBUDG BENEFITED WAGES X 0.25%891.10-01 SALARIED WAGES $356,326891------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES457,342 475,939 564,494 564,494 361,257 258,221 527,440279-0104-413.21-02 PRINT SHOP3110010022100LEVEL TEXTTEXT AMTBUDG MAILING100100279-0104-413.21-03 C.S. OFFICE SUPPLIES22412225025055250LEVEL TEXTTEXT AMTBUDG OFFICE SUPPLIES FROM CENTRAL SERVICES250250279-0104-413.21-04 OFFICE SUPPLIES2,241 2,486 1,800 1,500 1,338906 1,500LEVEL TEXTTEXT AMTBUDG MISC OFFICE SUPPLIES1,5001,500279-0104-413.21-05 SMALL OFFICE EQUIPMENT188 3,228500 2,300 2,029 2,029022
CITY OF SOUTH BENDEXPENDITURES2019 BUDGET201820182018 6/30/18 201920162017 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures279-0104-413.22-61 PROMOTIONAL SUPPLIES0 1,996 2,000 2,460 1,319 1,2640------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES2,656 7,833 4,650 6,610 4,693 4,207 1,850279-0104-413.31-71 CENTRAL STORES ALLOCATION024221449672352LEVEL TEXTTEXT AMTBUDG 2019 FIXED COST ALLOCATION - CENTRAL STORES352352279-0104-413.31-72 GIS ALLOCATION11,352000000279-0104-413.32-03 TRAVEL000000 8,550LEVEL TEXTTEXT AMTBUDG MEALS, MILEAGE, LODGING, ETC FOR CONFERENCES AND8,550TRAINING8,550279-0104-413.32-04 TELEPHONE2,160000000279-0104-413.32-21 TRAVEL - MILEAGE0146600600000279-0104-413.32-22 TRAVEL - AIRFARE1,365 5,113600 2,8005145140279-0104-413.32-23 TRAVEL - HOTEL4,591 6,033 5,400 5,4005445440279-0104-413.32-24 TRAVEL - MEALS7336827507501001000279-0104-413.32-25 TRAVEL - OTHER14763980067873730279-0104-413.33-03 PROMOTIONAL000000 5,150LEVEL TEXTTEXT AMTBUDG PROMOTION OF THE 311 CALL CENTER5,1505,150279-0104-413.34-02 LIABILITY INSURANCE1,896 1,428 1,251 1,251832624 1,668LEVEL TEXTTEXT AMTBUDG 2019 FIXED COST ALLOCATION - LIABILITY INSURANCE1,668DEPOSIT IN 226-0000-340.31-001,668279-0104-413.36-04 COMPUTER EQUIP R&M3,336000000279-0104-413.37-03 OFFICE SPACE0 2,400 2,000 2,000000279-0104-413.39-11 DUES & MEMBERSHIPS285030030000300LEVEL TEXTTEXT AMTBUDG 311 SYNERGY200AGCCP100300279-0104-413.39-70 EDUCATION & TRAINING2,033 4,150 12,000 10,0392727 12,000LEVEL TEXTTEXT AMT
23
CITY OF SOUTH BENDEXPENDITURES2019 BUDGET201820182018 6/30/18 201920162017 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresBUDG 6 CLASSES AT $350 EACH12,00012,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES27,898 20,615 23,723 23,962 2,186 1,954 28,020------------ ------------ ------------ ------------ ------------ ------------ ------------** 311 CALL CENTER487,896 504,387 592,867 595,066 368,136 264,381 557,310
24
CITY OF SOUTH BENDEXPENDITURES2019 BUDGET201820182018 6/30/18 201920162017 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures279-0672-415.10-01 SALARIED WAGES0 732,649 1,251,584 1,251,584 806,431 573,235 1,558,167LEVELTEXT AMTBUDG106,423106,42384,66076,40776,40776,40776,40776,40768,93268,93164,36161,70361,703170,68856,89656,896216,400TEXTTOTAL FTE - 231 CHIEF TECHNOLOGY OFFICER1 CHIEF INNOVATION OFFICER1 DEPUTY CHIEF TECHNOLOGY OFFICER 1 DIRECTOR OF INFRASTRUCTURE1 DIRECTOR OF APPLICATIONS1 DIRECTOR OF SERVICES1 DIRECTOR OF BUSINESS ANALYTICS1 DIRECTOR OF CIVIC INNOVATION1 MANAGER - INFRASTRUCTURE1 MANAGER - APPLICATIONS1 GIS MANAGER1 MANAGER-SERVICES1 SYSTEM SPECIALIST III3 APPLICATIONS DEVELOPERS @ $56,8961 SPECIALIST OF INFRASTRUCTURE1 SPECIALIST OF SERVICES4 BUSINESS ANALYSTS @ $54,1001 GIS SPECIALIST52,1161,558,167279-0672-415.10-09 PERMANENT PART-TIME0 2,54200000279-0672-415.11-01 FICA - REGULAR0 57,741 95,778 95,778 60,284 42,953 120,361LEVEL TEXTTEXT AMTBUDG TOTAL WAGES X 7.65%120,361.10-01 SALARIED WAGES $1,558,167.11-24 CELL PHONE ALLOWANCE $15,180120,361279-0672-415.11-04 PERF - REGULAR0 85,257 140,224 140,224 90,805 64,572 176,215LEVEL TEXTTEXT AMTBUDG BENEFITED WAGES X 11.2%176,215.10-01 SALARIED WAGES $1,558,167.11-24 CELL PHONE ALLOWANCE $15,180176,215279-0672-415.11-08 HEALTH INSURANCE0 176,359 307,995 307,995 161,637 112,340 231,288LEVEL TEXTTEXT AMTBUDG HEALTH INSURANCE:$704.17 X 24 PAY PERIOD = $16,900 X 23 FTE388,7002019 HEALTH INSURANCE DEDUCTION - ONE TIME159,620-LONG TERM DISABILITY:
25
CITY OF SOUTH BENDEXPENDITURES2019 BUDGET201820182018 6/30/18 201920162017 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures$4.00 X 24 PAY PERIODS = $96 X 23 FTE2,208231,288279-0672-415.11-09 LIFE INSURANCE0 1,465 1,374 2,205 1,535 1,065 2,760LEVEL TEXTTEXT AMTBUDG $5 X 24 PAY PERIODS = $120 X 23 FTE2,7602,760279-0672-415.11-24 CELL PHONE ALLOWANCE0 4,700 9,240 8,409 3,805 2,785 15,180LEVEL TEXTTEXT AMTBUDG $55 PER MO X 12 MONTHS X 23 EMPLOYEES15,18015,180279-0672-415.11-29 PARENTAL LEAVE00 3,130 3,130 2,103 1,555 3,895LEVEL TEXTTEXT AMTBUDG BENEFITED WAGES X 0.25%3,895.10-01 SALARIED WAGES $1,558,1673,895------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES0 1,060,713 1,809,325 1,809,325 1,126,600 798,505 2,107,866279-0672-415.21-04 OFFICE SUPPLIES0658003853850279-0672-415.21-05 SMALL OFFICE EQUIPMENT0 62,967 97,843 97,171 67,419 31,6600279-0672-415.22-60 COMPUTER SUPPLIES000000 70,000LEVEL TEXTTEXT AMTBUDG MISC PERIPHERALS20,000SOFTWARE PURCHASES25,000ETHERNET CABLING25,00070,000------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES0 63,625 97,843 97,171 67,804 32,044 70,000279-0672-415.31-06 OTHER PROFESSIONAL SVCS0 264,961 1,209,300 1,336,645 510,495 362,347 1,067,434LEVEL TEXTTEXT AMTBUDG CITY SURVEY21,000SB ACADEMY40,000ENFOCUS INTERNS (INCLUDES 2 IT SUMMER INTERNS)45,500FREE WIFI100,000GIS PROFESSIONAL SERVICES50,000HR SCANNING11,800LEGACY VIDEO MAINTENANCE (PANASONIC, DIGITAL ALLY)5,00026
CITY OF SOUTH BENDEXPENDITURES2019 BUDGET201820182018 6/30/18 201920162017 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresMETRONET BUILD OUT350,000MISC CONSULTANTS50,000MISC PROJECTS PRIORITIZED BY GOVERNANCE187,884NATIONAL NETWORK FOR SAFE COMMUNITIES25,000TESTING & IMPLEMENTATION SERVICES20,000RECTRAC CHANGES25,000NETWORK INFRASTRUCTURE & SECURITY UPGRADES80,000SUPPORT FOR MICROSOFT DYNAMICS CRM30,000WEBSITE HOSTING SUPPORT HOURS - CENTURY CENTER1,250WEBSITE MANAGEMENT (PATHFINDERS)25,0001,067,434279-0672-415.32-03 TRAVEL000000 18,560LEVEL TEXTTEXT AMTBUDG MILEAGE, MEALS, LODGING, ETC FOR CONFERENCES AND18,560TRAINING18,560279-0672-415.32-04 TELEPHONE0 11,987 382,824 382,824 150,847 93,204 391,024LEVEL TEXTTEXT AMTBUDG INTERNET BANDWIDTH25,800MORRIS DEDICATED BANDWIDTH2,450POLICE DEDICATED BANDWIDTH1,550CENTURY CENTER DEDICATED BANDWIDTH4,200LEGACY PHONE SERVICE & CIRCUITS240,000VOIP SERVICES117,024391,024279-0672-415.32-05 OTHER COMM/TRANS000 30,000 3,4921900279-0672-415.32-21 TRAVEL - MILEAGE0 2,349 1,000 1,0002531890279-0672-415.32-22 TRAVEL - AIRFARE0 3,620 5,900 5,804 2,947 2,9470279-0672-415.32-23 TRAVEL - HOTEL0 9,350 8,400 8,400 5,028 1,8020279-0672-415.32-24 TRAVEL - MEALS0 1,805 2,435 2,035 1,0131540279-0672-415.32-25 TRAVEL - OTHER0 1,010825 1,225 1,1638260279-0672-415.33-02 PUBLICATION LEGAL NOTICE0002982982980279-0672-415.34-02 LIABILITY INSURANCE0 3,132 3,816 3,816 2,544 1,908 4,765LEVEL TEXTTEXT AMTBUDG 2019 FIXED COST ALLOCATION - LIABILITY INSURANCE4,765DEPOSIT IN 226-0000-340.31-004,765279-0672-415.36-04 COMPUTER EQUIP R&M0 1,080,648 2,449,381 2,455,571 1,344,351 1,084,959 3,055,487LEVEL TEXTTEXT AMTBUDG Accela Licensing80,70027
CITY OF SOUTH BENDEXPENDITURES2019 BUDGET201820182018 6/30/18 201920162017 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresAdobe33,202ADSI91,058AFIS91,995CityWorks286,000Cloud Data Storage and VM hosting164,000Data Plans Mifi/iPad95,976Dynamics 365 (CRM)60,000ELEMOS32,380GIS Enterprise Software51,000GIS Environment - vCloud resources21,600HelpDesk Support126,727Kronos286,678Laserfiche76,311Managed Print Services41,224Maximo47,941Microsoft 365 Licenses208,954Sungard (NaviLine)204,397Other services1,055,3443,055,487279-0672-415.37-11 CAPITAL LEASE PRINCIPAL0 136,360 181,339 114,888 75,653 55,1990279-0672-415.37-12 CAPITAL LEASE INTEREST0 15,429 39,776 29,392 7,235 4,4600279-0672-415.38-01 PRINCIPAL000 75,012 2,1170 350,403LEVEL TEXTTEXT AMTBUDG DS-136 2015 HP LEASE #82,144DS-138 2015 HP LEASE #920,986DS-143 2015 HP LEASE #11736DS-150 2016 HP LEASE #122,343DS-154 2016 VEHICLE/EQUIP LEASE #348,815DS-160 2017 HP LEASE #141,552DS-164 2017 HP LEASE #1617,732DS-167 2017 HP LEASE #152,169DS-170 2018 HP LEASE #172,013DS-171 2018 VEHICLE/EQUIP LEASE #1 - SCHED 1100,692DS-174 2018 HP LEASE #1846,344ANTICIPATED LEASES IN 2019104,877350,403279-0672-415.38-02 INTEREST000 11,0113060 63,219LEVEL TEXTTEXT AMTBUDG DS-136 2015 HP LEASE #823DS-138 2015 HP LEASE #9476DS-143 2015 HP LEASE #1117DS-150 2016 HP LEASE #12104DS-154 2016 VEHICLE/EQUIP LEASE #32,051DS-160 2017 HP LEASE #1414728
CITY OF SOUTH BENDEXPENDITURES2019 BUDGET201820182018 6/30/18 201920162017 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual ExpendituresDS-164 2017 HP LEASE #162,259DS-167 2017 HP LEASE #15270DS-170 2018 HP LEASE #17309DS-171 2018 VEHICLE/EQUIP LEASE #1 - SCHED 113,395DS-174 2018 HP LEASE #189,215ANTICIPATED LEASES IN 201934,95363,219279-0672-415.39-30 GRANTS AND SUBSIDIES0000 25,00000279-0672-415.39-70 EDUCATION & TRAINING0 8,638 65,900 65,900 13,856 11,693 65,900LEVEL TEXTTEXT AMTBUDG MEETING/CONFERENCE FEES65,90065,900------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES0 1,539,289 4,350,896 4,523,821 2,146,598 1,620,177 5,016,792279-0672-415.50-02 INTERFUND TRANSFER OUT000000 600,000LEVEL TEXTTEXT AMTBUDG 2019 TRANSFER TO 404-0000-392.00-00600,000TO COVER COST OF ERP SOFTWARE IMPLEMENTATION600,000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER USES000000 600,000------------ ------------ ------------ ------------ ------------ ------------ ------------** INFORMATION TECHNOLOGY0 2,663,627 6,258,064 6,430,317 3,341,002 2,450,726 7,794,658
29
CITY OF SOUTH BENDEXPENDITURES2019 BUDGET201820182018 6/30/18 201920162017 Original Amended YTD YTD ProposedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Expenditures279-0673-415.10-01 SALARIED WAGES0 268,77300000279-0673-415.10-10 HIRING BONUS0 18,50000000279-0673-415.11-01 FICA - REGULAR0 18,51800000279-0673-415.11-04 PERF - REGULAR0 27,12800000279-0673-415.11-08 HEALTH INSURANCE0 32,32000000279-0673-415.11-09 LIFE INSURANCE042000000------------ ------------ ------------ ------------ ------------ ------------ ------------* PERSONNEL SERVICES0 365,65900000279-0673-415.21-05 SMALL OFFICE EQUIPMENT0 6,6160 4,096 4,096 4,0960------------ ------------ ------------ ------------ ------------ ------------ ------------* SUPPLIES0 6,6160 4,096 4,096 4,0960279-0673-415.31-06 OTHER PROFESSIONAL SVCS0 37,8040 125,633 100,637 82,8430279-0673-415.32-21 TRAVEL - MILEAGE0600000279-0673-415.32-24 TRAVEL - MEALS03300000279-0673-415.32-25 TRAVEL - OTHER03700000279-0673-415.39-89 MISC CHARGES & SVCS019900000------------ ------------ ------------ ------------ ------------ ------------ ------------* OTHER SERVICES & CHARGES0 38,0790 125,633 100,637 82,8430------------ ------------ ------------ ------------ ------------ ------------ ------------** PERFORMANCE/INNOVATION0 410,3540 129,729 104,733 86,9390------------ ------------ ------------ ------------ ------------ ------------ ------------*** IT-INNOVATION-311 CENTER487,896 3,578,368 6,850,931 7,155,112 3,813,871 2,802,046 8,351,968
30
CITY OF SOUTH BENDREVENUE2019 BUDGET201820182018 6/30/18 201920162017 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual RevenueIT-INNOVATION-311 CENTER279-0000-361.00-00 INTEREST EARNINGS000 7,645 13,887 7,645 10,000LEVEL TEXTTEXT AMTBUDG 2019 ESTIMATE10,00010,000------------ ------------ ------------ ------------ ------------ ------------ ------------*000 7,645 13,887 7,645 10,000279-0000-367.60-00 MAYORS CHALLANGE AWARD000 100,000 100,000 100,0000------------ ------------ ------------ ------------ ------------ ------------ ------------*000 100,000 100,000 100,0000279-0000-380.10-13 TELEPHONE000 13,560 22,180 8,540 45,062LEVEL TEXTTEXT AMTBUDG ART MUSEUM $3,236.963,237STUDEBAKER MUSEUM $6,681.856,682ZOO $7,238.297,238SMG (CENTURY CENTER) $27,905.0627,905- Fax Services- Informacast Maintenance- Legacy Phone Service & Circuits/Long Distance- VoIP serviceBASED ON NUMBER OF DEVICES45,062279-0000-380.10-80 IT ALLOCATION FEE0 5,167,452 6,850,931 6,850,931 4,525,968 3,394,476 7,991,331LEVEL TEXTTEXT AMTBUDG 2019 FIXED COST ALLOCATION - IT AND 311 CALL CTR 7,991,331THE ALLOCATION COVERS THE COST OF THE IT DEPT AND311 CALL CENTER. THE ALLOCATIONS ARE CHARGED TODEPTS BASED MANY FACTORS INCLUDING # OF DEVICES,SOFTWARE LICENSES, 311 CALL CENTER RESPONSES,# OF USER LICENSES, ETC.7,991,331------------ ------------ ------------ ------------ ------------ ------------ ------------*0 5,167,452 6,850,931 6,864,491 4,548,148 3,403,016 8,036,393------------ ------------ ------------ ------------ ------------ ------------ ------------** IT-INNOVATION-311 CENTER0 5,167,452 6,850,931 6,972,136 4,662,035 3,510,661 8,046,393
31
CITY OF SOUTH BENDREVENUE2019 BUDGET201820182018 6/30/18 201920162017 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue279-0104-392.04-00 ADMINISTRATIVE COST487,897000000------------ ------------ ------------ ------------ ------------ ------------ ------------*487,897000000------------ ------------ ------------ ------------ ------------ ------------ ------------** 311 CALL CENTER487,89700000032
CITY OF SOUTH BENDREVENUE2019 BUDGET201820182018 6/30/18 201920162017 Original Amended YTD YTD EstimatedACCOUNT NUMBER ACCOUNT DESCRIPTIONActual Actual Budget Budget Actual Actual Revenue279-0672-380.10-99 MISC. REIMBURSEMENTS000 16,440 16,439 16,4390------------ ------------ ------------ ------------ ------------ ------------ ------------*000 16,440 16,439 16,4390------------ ------------ ------------ ------------ ------------ ------------ ------------** INFORMATION TECHNOLOGY000 16,440 16,439 16,4390------------ ------------ ------------ ------------ ------------ ------------ ------------*** IT-INNOVATION-311 CENTER487,897 5,167,452 6,850,931 6,988,576 4,678,474 3,527,100 8,046,393
33