20201103 Regular City Council Meeting - Packet (3) November 3, 2020
Item 1
Staff Presentation
r �
-w
lntroduc' t 'ion o a
i e s em
ywi
,
. , %,e
November 3, 2020
O
What is an ERP?
• ERP — Enterprise Resource Planning
• Integrated suite of application modules
• Facilitates information flow to all business
functions
• Centralized, normalized database
• Common user look and feel across all modules
• Promotes information
access without IT resources
Y
Multiple S stems Versus an ERP
7Buclget7,
Budget,:xcel file ina......
and
Payroll
FR n z
Inventory Inventory Time
keeping
Payroll
Licensing Time
Permitting keeping Ilk LicensingPermitting
Asset Utility Asset Mgt
Mgt
Billing Work Utility
Billing
Work Orders
Orders
• Separate systems • Integrated system
• Paper driven • Workflow driven
• Manual processes Automation
• Duplication of staff time Single input
• Extended report timing Realtime reporting
ERP Impact on Processes
Current Future
• Non-integrated systems 0 Fully integrated ERP
• Limited online processes 0 Internet based customer
for customers portal
• Physical processes 0 Payment/account access
• Paper forms and mail 9 Permits and inspections
• Specialized spreadsheets 9 Automation of data input
• Duplication of work due 0 Advanced reporting
to disparate systems 0 Real-time integration
between modules
Paperless recordkeeping
ERP Impact on Information
• Dashboard and Key Performance Indicators (KPI) versus
specialized report writing
• No delay between data input and access
• Decentralized input to enable :
• Improved customer service to the business community
• Up to date information about transactions
• Budget data integrity, version control, and improved
review and revision
■� ■
, _
Current Year Permit Application by Type Staff Overdue Reviews Favorites /
0. R&e l Artmty ..
a-�Q(Mv.ftw
ConmwgaBrMoynwit
[e.sre+ueeoecw�:• �x...�rwt+w
6 x.,.r..,.. Tyw S11
BJ H ro iResglK•YI ■SHN�+l.wwaee. v
•0—F.
•�/y5 LELto
Vapwr[W 1�•�
Pap lRt�ptntW
Ekcaral�Rna}�afiq
or ma Application Volume
Application of an ERP to City Staff
• Familiar, user-friendly interface navigation
• Global search functions due to a single, integrated
database
• Use resources and technology to improve a collaborative
work product
• Simplify and streamline processes, reduce paper
• Collect and enter information once
• Integrate policy and business rules into system
ICE 1 0 it I
ERP to Advance CityStrategic Goals
• Leveraging technology to improve internal and external
customer service
• Delivering information needed to model and plan long-
term fiscal stability
• Promote transparent and open government and
communication with the business community
Uw a irrCnh a. ChwW 4n General Fww(.nn 6.Uw Het$wOn EDv cn) .
$3j.91 M $4.91 M 518.91 M S 141.05M
loop-
__I
Of
% % % I
� �� '�'� ,'� �L � � �a �i � � '� � � � � �a �1 �a � �1 � *s �1� '� � ■ i f [ 5 Y S S g I Y
w ".Wft WS/P,rM�nxs�rnq/.lwR�r/fW••• 4.f��M�y1�P l�r tl.�wweJw F�wrf1�. IYy�frwwr'+M� wwrliRM�AF Mwif�M nt�M`11sw KY WtlMhM/FM�bMrMN `�Ir
...xertiwwa '�.r srr wecwwrw�r�r.rrM�s./Arr ayt..b+.wwrMh rw�rl rlwM
'Ajrofl txpeftm n Pror"t{.pews COM txPHtln n.Rerenors Awraae HW"-V aryl Open
353.50M 527.95M $316,938.67 18
Y .•� fr
_w T
lot
., Quest 'ions
10
o Discussion
of
o"
'Tty-I