Information Technology Fund Description

(1)

Description

Information Technology Fund

The Information Technology Department, in coordination with City strategic objectives and goals

in consultation with the charter officials and city departments of the City:

-Coordinates citywide voice and data services

-Coordinates inter-governmental technology collaboration

-Aligns technology resources to meet departmental technology needs

-Facilitates record requirements in coordination with the City Auditor and Clerk's office to

meet Florida Public Record Law and other requirements

-Facilitates technology project management

-Facilitates, coordinates, and manages citywide technology procurement

-Provides comprehensive information

technology services, aligning departmental

governance with organizational goals, strategies, and objectives

-Provides database management services

-Provides departmental application platform management services

-Provides desktop and remote application and hardware support for City users

-Provides email and calendaring services

-Provides geographical information services (GIS) to internal and external customers

-Manages city business continuity and disaster recovery technology requirements

-Manages internet connectivity, internal infrastructure networking, perimeter security,

firewall, IPS and wireless services

-Manages server hardware, storage area network, and virtual platform frameworks

-Manages Windows server and active directory platforms

The Information Technology Department provides service through traditional help desk

operations. The primary function of the Help Desk is to provide a single point of contact for

technical support and equipment rollout to end users. The secondary function is to provide

specialized application administration such as email, database, and geographical information

services as well as end-user training.

The Information Technology Department is responsible for planning, maintaining and

implementing the City's technology infrastructure for voice and data services - cabling, fiber

optics, network and communication hubs, storage, routing, switching, and firewall services;

day-to-day operations of the City's physical and virtual servers including enterprise-wide solutions

such as e-mail, network printing, file sharing, database services, and data backup; telephone

operations within the City; as well as data storage management and overall information security.

The Information Technology Department is responsible for implementing IT governance to

facilitate business goals and objectives through the use of technology and automation of

processes in furtherance of the City's strategic plan and business operations, as well as meeting

department non-technical administrative needs.

(2)

Amended

Actual

Budget

Estimated

Budget

2013-14

2014-15

2015-16

Available Fund Balance

$

804,248

$

438,040

$

742,391

$

742,391

$

387,333

Revenues

Department billings

1,900,000

1,850,000

2,100,000

Investment income

5,165

2,000

5,000

2,000

Miscellaneous

840 -

-

Total

1,906,005

1,852,000

1,855,000

2,102,000

Estimated Funds Available

2,710,253

2,290,040

2,594,391

2,597,391

2,489,333

Expenditures

Personnel

1,117,517

1,201,507

1,261,547

1,236,316

1,497,853

Operating

630,730

671,077

726,044

737,726

Capital

219,615

313,000

397,698

247,698

80,549

Total

1,967,862

2,185,584

2,385,289

2,210,058

2,316,128

Projected Ending Balance

742,391

$

104,456

$

209,102

$

387,333

$

173,205

Fund Balance Adjustment

Ending Fund Balance

$

742,391

CITY OF SARASOTA, FLORIDA

INFORMATION TECHNOLOGY

Fund 504

(3)

Revenue By Fund - Summary

City of Sarasota

13-14 Actual 14-15 Budget 15-16 Request Issues Total Request V ariance Account T itle Estimate INFORM A TION TECHNOLOGY TECHNOLOG Y CHARGES $2,100,000 $0 $2,100,000 $1,850,000 $1,900,000 393000 %13.51 $1,850,000 $2,100,000 $1,900,000 $1,850,000 13.51% INTRAGOVERNMEN TA L SE R VICES $2,100,000 $0 $1,850,000 ALLOC A TED INVESTMEN T EARNING $2,000 $0 $2,000 $2,000 $5,165 361820 %0 $5,000 $2,000 $5,165 $2,000 0.0 % INTEREST $2,000 $0 $5,000 SURPLUS FURNITURE $0 $0 $0 $0 $840 364410 %0 $0

CONTRIBUTIONS & SPONSORSHIPS

$0 $0 $0 $0 $0 366000 %0 $0 $0 $840 $0 0.0 %

OTHER MISCELLANEOUS REVENUES

$0 $0 $0 $2,102,000 $1,906,005 $1,852,000 13.50% $2,102,000 $0 INFORM A TION TECHNOLOGY $1,855,000 1 T uesda y, May 26, 2015 Page 1:46 pm

(4)

Expenditures By Fund - Summary

City of Sarasota

13-14 Actual 14-15 Budget 15-16 Request Issues Total Request V ariance Account T itle Estimate A TION TECHNOLOGY SALARIES AND W AGES $689,187 $754,107 $941,393 $36,704 $978,097 000101 29.70% 787,454 P A R T TIME SALARIES $0 $0 $0 $0 $0 000108 0 % 0 OVE R TIME - GENERA L EMPLOYEES $3,041 $5,000 $10,000 $0 $10,000 000 11 1 100.00% 6,835 SOCIA L SECURITY $51,661 $58,073 $72,782 $2,808 $75,590 000204 30.16% 57,901 MEDICA L AND DEN TAL $75,166 $98,280 $106,470 $8,190 $1 14,660 000205 16.67% 94,091 LIFE INSURANCE $654 $712 $826 $59 $885 000206 24.30% 743 RETIREMEN T-CIT Y PO R TION $124,243 $173,884 $134,262 $0 $134,262 000207 (22.79%) 98,180 WORKERS' COMPENS A TION $1,755 $1,921 $2,508 $92 $2,600 000208 35.35% 1,959 DEFERRED COMPENS A TION $5,436 $0 $0 $0 $0 000215 0 % 8,872 OPEB EXPENSE $92,209 $70,764 $70,764 $0 $70,764 000220 0 % 70,764 401(a) CONTRIBUTION $35,398 $0 $67,270 $3,670 $70,940 000222 100.00% 69,990 OTHER SALA R Y ADJUSTMENTS $0 $0 $1,289 $0 $1,289 000281 100.00% 761 MEDICAL/DEN TA L - RETIREES $38,766 $38,766 $38,766 $0 $38,766 001205 0 % 38,766 $1,497,853 $1, 117,516 $1,201,507 24.66% PERSONNEL $1,446,330 $51,523 $1,236,316 OFFICE SUPPLIES $566 $1,750 $0 $0 $0 000313 (100.00%) 500 MO T OR VEHICLE SUPPLIES AND P A R TS $360 $1,000 $2,500 $0 $2,500 000316 150.00% 700 GENERA L SUPPLIES $1,180 $1,000 $0 $0 $0 000320 (100.00%) 1,552 COMPUTER SUPPLIES $2,228 $2,250 $4,000 $0 $4,000 000328 77.78% 6,147 COMPUTER RE P AIR P A R TS $175 $0 $1,000 $0 $1,000 000331 100.00% 590 PC SOFT W ARE LESS THAN $500 $462 $1,000 $3,000 $0 $3,000 000332 200.00% 17,460 COMPUTER EQUI P LESS THAN $500 $5,690 $2,000 $6,000 $0 $6,000 000380 200.00% 5,950 FURNITURE LESS THAN $500 $0 $0 $1,000 $0 $1,000 000381 100.00% 0 EQUIPMEN T LESS THAN $500 $0 $0 $1,000 $0 $1,000 000382 100.00% 29,035 CAR ALLO W ANCE $1,573 $1,716 $1,716 $0 $1,716 000424 0 % 1,716 EDUC A TION REIMBURSEMENTS $0 $0 $0 $0 $0 000425 0 % 1,000 TRAINING, TR A VE L & CONFERENCES $10,310 $9,000 $28,000 $0 $28,000 000426 2 11. 11% 15,208 TELECOMMUNIC A TIONS $1 12,294 $126,600 $180,855 $0 $180,855 000427 42.86% 125,241 ADVE R TISING $109 $460 $1,500 $0 $1,500 000428 226.09% 960 DUES AND MEMBERSHIPS $630 $850 $0 $0 $0 000430 (100.00%) 850 SPECIA L SE R VICES $29,920 $29,200 $30,000 $0 $30,000 000437 2.74% 51,061 UTILIT Y SE R VICES $274 $450 $0 $0 $0 000438 (100.00%) 450 DUPLIC A TING AND PRINTING $0 $600 $0 $0 $0 000439 (100.00%) 600 EQUIPMEN T AND PROPE R T Y REN TAL $1,922 $2,000 $0 $0 $0 000440 (100.00%) 3,660 1 T uesda y, May 26, 2015 Page 1:42 pm

(5)

Expenditures By Fund - Summary

City of Sarasota

13-14 Actual 14-15 Budget 15-16 Request Issues Total Request V ariance Account T itle Estimate INFORM A TION TECHNOLOGY LEGA L AND JUDICIAL $0 $0 $0 $0 $0 000442 0 % 4,000 RELOC A TION/MOVING COSTS $0 $0 $0 $0 $0 000453 0 % 15,000 BUILDING MAINTENANCE $300 $0 $10,000 $0 $10,000 000547 100.00% 802 OFFICE EQUIPMENT $0 $250 $0 $0 $0 000556 (100.00%) 250 MACHINE R Y AND T OOLS $0 $0 $0 $0 $0 000557 0 % 0 MO T OR VEHICLE $483 $900 $1,000 $0 $1,000 000559 1 1. 11% 900 PC HARD W ARE AND SOFT W ARE-MAINT $457,174 $485,250 $454,285 $0 $454,285 000571 (6.38%) 437,6 11 POS TAGE $0 $150 $0 $0 $0 001313 (100.00%) 150

CELLULAR PHONE CHARGES

$4,869 $4,441 $6,300 $0 $6,300 001427 41.86% 4,441 AU T O LIABILITY $210 $210 $210 $0 $210 003432 0 % 210 CEL L PHONE ALLO W ANCE $0 $0 $360 $0 $360 005427 100.00% 0 CONSU LT ANT/ TEMPS/ OTHER $0 $0 $5,000 $0 $5,000 012437 100.00% 0 $737,726 $630,729 $671,077 9.93% OPER A TING EXPENDITURES $737,726 $0 $726,044 CAPI TA L OUTL A Y -MISC SUPPLIES $0 $0 $0 $0 $0 000620 0 % 0 CAPI TA L OUTL A Y -ENG & ARCH FEES $0 $0 $0 $0 $0 000636 0 % 0 CAPI TA L OUTL A Y -SPECIA L SE R VICES $0 $0 $0 $0 $0 000637 0 % 0

BUILDING & STRUCTURES

$0 $0 $0 $0 $0 000672 0 % 0 PC & REL A TED HARD W ARE $140,235 $310,000 $60,069 $0 $60,069 000680 (80.62%) 247,698 MACHINE R Y & T OOLS $0 $0 $0 $0 $0 000682 0 % 0 INSTRUMENTS & AP P AR A TUS $0 $0 $5,000 $0 $5,000 000683 100.00% 0

OTHER & UNCLASSIFIED PROPE

R TY $35,757 $0 $0 $0 $0 000690 0 % 0 PC SOFT W ARE $43,623 $3,000 $15,480 $0 $15,480 000695 416.00% 0 $80,549 $219,615 $313,000 (74.27%) CAPI TA L EXPENDITURES $80,549 $0 $247,698 Loss on Fixed Assets $284 $0 $0 $0 $0 000909 0 % 0 $0 $284 $0 0.0 % TRANSFER EXPENDITURES $0 $0 $0 $2,316,128 $1,968,144 $2,185,584 5.97% $2,264,605 $51,523 INFORM A TION TECHNOLOGY $2,210,058 2 T uesda y, May 26, 2015 Page 1:42 pm

(6)

City of Sarasota

Budget Issues - Detail

045061 INFORMATION TECHNOLOGY OPERATIONS

Project Fund

Issue Title

1 000000 504 Addition of Administrative Assistant

The primary focus of the Information Technology Department is to provide high quality customer service to all Departments throughout the City of Sarasota. The IT Department’s current staff consists of IT professionals with their main focus on supporting applications and infrastructure to maintain and enhance the level of service to their customers. The IT Department is tasked with reviewing, approving, and procuring all computer related equipment. This task takes research and a great amount of time to ensure the computer equipment is compatible with current systems and applications. Additionally, the IT Department is working to implement policies and procedures to standardize and use best practices in information technology which will require the need for administrative support. Currently, the IT Department does not have an administrative support position and relies on other Departments to assist. The addition of an Administrative Assistant will provide the support to draft policies and procedure to implement best practices and to provide support for other Departments in the procurement of needed computer equipment.

PERSONNEL FY 15 - 16

SALARIES AND WAGES $36,704

000000 000101

Admin Asst,Issue

MEDICAL AND DENTAL $8,190

000000 000205

Open Access for Admin Asst,Issue

401(a) CONTRIBUTION $3,670

000000 000222

General Employee Deferred Compensation for Admin Asst,Issue

LIFE INSURANCE $59

000000 000206

Life for Admin Asst,Issue

SOCIAL SECURITY $2,808

000000 000204

Medicare for Admin Asst,Issue Social Security for Admin Asst,Issue

WORKERS' COMPENSATION $92

000000 000208

Clerical/Prof. Office Emps-No Other Class for Admin Asst,Issue

PERSONNEL Total $51,523

Issue Total $51,523

Center Total _$51,523