9.1. SR 07-07-2008Item # 9.1.
~,~•~'
. ~.-,
aver
MEMORANDUM
TO: Mayor and City Council
FROM: Lori Johnson, City Administrator
DATE: July 7, 2008
SUBJECT: Information Technology Budget
Since Bob Pearson, IT Manager, will be at Monday's Council meeting for the Fire Relief
Association presentation, we have added the IT budget to worksession agenda so he can
answer any questions you may have about his budget. The IT budget includes not only the
City's many data systems, but also the voice communication systems. Obviously technology
is constantly changing and the one thing we want to ensure is that funds are available to
replace our equipment before it becomes too outdated.
Attachments
^ Goals
^ Budget worksheet
^ 2009 budget detail
Finance Department
Information Technology Division
2009 Goals
^ Virtualize the servers in the main data center by moving hardware servers into software.
Virtualize the storage environment in the main data center. This calls for decoupling servers
from typically built in storage. This is accomplished by using storage area network technology.
^ Create a hot standby site for all critical IT systems in the EOC.
BUDGET WORKSHEET
CITY OF ELK RIVER
Page: 1
6/3012008
9:42 am
Prior ----Current Year - (6) (7) (8)
Year Original Amended Actual Thru Estimated
Month:6l3012008 Actual Budget Budget June Total Requested Proposed Adopted
Fund: 101 -GENERAL FUND
Expenditures
Dept: 130.135 INFORMATION TECHNOLOGY
Acct Class: 4100 Personal services
4101 Regular Pay 113,728 121,950 121,950 52,325 0 129,300
4102 Overtime Pay 301 0 0 16 0
4103 Part-time Pay 6,670 12,500 12,500 1,305 0 12,850
4104 PERA 7,078 8,750 8,750 3,565 0 9,600
4105 FICA 7,038 8,350 8,350 3,299 0 8,800
4107 Medicare 1,646 1,950 1,950 771 0 2,050
41081nsurance 13,287 15,200 15,200 7,516 0 15,350
4109 Workers Comp 358 500 500 247 0 550
Personal services 150,106 169,200 169,200 69,044 0 178,500 0 0
Acct Class: 4200 Supplies
4219 Operating Supplies 15,296 27,500 27,500 7,769 0 23,300
Supplies 15,296 27,500 27,500 7,769 0 23,300 0 0
Acct Class: 4300 Other services & charges
4319 Other Professional Services 5,550 5,000 5,000 3,064 0 8,000
4321 Telephone 568 800 800 232 0 800
4331 Travel, Conferences & Schools 3,425 4,000 4,000 591 0 4,500
4404 Equip RepaidMaint Services 21,692 19,750 19,750 5,384 0 19,950
Other services & charges 31,235 29,550 29,550 9,271 0 33,250 0 0
Acct Class: 4500 Capital outlay
4560 Equipment 5,488 30,000 30,000 0 0 53,000
Capital outlay 5,488 30,000 30,000 0 0 53,000 0 0
INFORMATION TECHNOLOGY 202,125 256,250 256,250 86,084 0 288,050 0 0
Total Expenditures 202,125 256,250 256,250 86,084 0 288,050 0 0
2009 BUDGET DETAIL SHEET
Dept: Information Technology
Acct. Ex
lanation/Detail of Su
lies or Services 2006 2007 2008 BUDGET 2009 BUDGET 2009
No. p
pp Actual Actual Detail Total Detail Total Pro osed
4101 PERSONAL SERVICES
Re ular Pa
105,803
113,728
121,950
129,300
129,300
4102 Overtime Pa 63 301
4103 Part-time Pa 4,498 6,670 12,500 12,850 12,850
4104 PERA 6,326 7,078 8,750 9,600 9,600
4105 FICA 6,616 7,038 8,350 8,800 8,800
4107 Medicare 1,547 1,646 1,950 2,050 2,050
4108 Insurance 11,562 13,287 15,200 15,350 15,350
4109 Workers Com 337 358 500 550 550
4219 TOTAL PERSONAL SERVICES
SUPPLIES
Operating Supplies 136,753
28,885 150,106
15,296 169,200
27,500 178,500
23,300 178,500
Com uter/ rinter su lies - cartrid es, to es, software, etc 4,000 4,500
Com uter s ayes 4,000 4,000
Misc. hones ares 2,500 2,500
New HP UPS 2008 2,000
Additional Software Licensin ie. Adobe 5,000 5,000
Microsoft SQL 2000 to 2005 U rade 4,000
Microsoft Exchan a 2003 to 2007 U rade 1,500
Re lacement server for Recreation 3,000
Phone for Rob Dreissi 1,500
New PC for IT Su ort -Tristan 1,500
T1 Card for Phone S stem at Lions Park for D.R. 2,000
Whats U Gold network monitorin software 1,800
Video camera troubleshootin monitor 2008
Misc. cablin ro~ects 2,000
4319 TOTAL SUPPLIES
OTHER SERVICES & CHARGES
Other Professional Services 28,885
700 15,296
5,550 27,500
5,000 23,300
8.On0
Professional Services i. .Phone, router 5,000 8,000
4321 Telephone 1,027 568 800 800
Cell hones 800 800
4331 Conferences/Schools 2,743 3,425 4,000 4,500
E-mail server, misc. 4,000 4,500
4404 Equipment Repair & Maint 11,050 21,692 19,750 19.950
__.
Com uter a ui re air & maint. 3,000 3,000
PD Cisco 4503 Annual Maintenance 2,650 2,650
Cit Hall Cisco 4503 Annual Maintenance 2,650 2,650
Cisco Firewall Annual Maintenance 1,450 1,450
Phone s stem maintenance 3,500 3,500
Securi s stem maintenance 3,500 3,500
Printer Maintenance 1,000 1,000
S mantec U rades 1,000 1,200
Accessdata ForensicToolkit Maintenance 1,000 1,000
4560 TOTAL OTHER SERVICES & CHARGES
CAPITAL OUTLAY
Equipment 15,520
44,089 31,235
5,488 29,550
30,000 33,250
53.000
Microsoft Licensin -reallocate to disaster recove 2008 30,000
Blackber Enter rise Server Hardware 3,000
New Firewall 2010
Virtualization Pro'ect Disaster Recove 30,000
6cchan e U rade 20,000
TOTAL INFORMATION TECHNOLOGY 225,247 202,125 256,250 288,050 178,500
6/30/2008