Loading...
HomeMy WebLinkAbout14.B. Information Technology J I.{. 6. CITY OF SHAKO PEE 2009 GENERAL FUND BUDGET DIVISION: INFORMATION TECHNOLOGY (IT) MISSION STATEMENT: The mission of the IT Division is as follows: Provide effective IT support services for the City's seven departments. ACTIVITIES: IT funds all of the operations/maintenance/replacement of the City's computer systems in City Hall, the Police department, Public Works building, and Fire stations (Recreation Department computers are funded in the Recreation budget) . IT funds system resources, operating systems, equipment replacement, word processing, spreadsheet, database, and other Ugeneral use" applications. To do this, the City currently employs a full-time IT Coordinator and IT Specialist. Additional consulting services and the City'S internet service are provided by Local Government Information Services (LOGIS) . OBJECT DESCRIPTION: Description of line items: Wages & Benefits: Salaries: 1 IT Coordinator, 1 IT Specialist. Supplies & Services: Software License & Service Agreement renewals $62rOOO, Disaster Recovery Software $40,000, Server purchases (1 replacement, 1 additional) $13,000, PC replacement $8,000. Rentals: Payment to LOGIS for Internet, Network Wellness and general R & D charge ($15,000) . Dues/Training/Travel: $6,000 Capital: 48 Port Switch $8,000. 1 R5509BUD LOGIS005 CITY OF SHAKOPEE 7/30/200811:50:59 Fiscal Period: 6 / 8 Budget Report Page - 1 Level Of Rollup 7 2005 2006 2007 6/30/2008 2008 2009 2009 2009 Actual Actual Actual YTD Final Requested Approved Final Object Code I Description Amount Amount Amount Actual Budget Budget Budget Budget 01000 GENERAL FUND 20 INFORMATION TECHNOLOGY 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 91,756 79,587 108,523 56,103 113,090 130,690 130,690 130,690 6005 OVERTIME-FT 3,321 6015 WAGES - PART TIME/TEMP 11,690 12,505 4,000 6002 WAGES 106,767 92,092 112,523 56,103 113,090 130,690 130,690 130,690 6100 BENEFITS 6122 PERA 5,904 5,514 6,815 3,604 7,350 8,820 8,820 8,820 6124 FICA 7,850 6,857 8,253 3,984 8,650 10,000 10,000 10,000 6135 HEALTH 5,365 8,323 14,147 6,679 9,610 17,700 17,700 17,700 6139 POST EMPLOYMENT HEALTH PLAN 581 443 605 270 600 600 600 600 6140 L1FEIL TD 475 344 507 238 550 570 570 570 6145 DENTAL 632 513 774 364 770 960 960 960 I\) 6170 WORKERS COMPENSATION 774 850 489 188 1,030 500 500 500 6180 COMPENSATED ABSENCES 2,136- 1,227 678 4,160 4,100 4,100 4,100 6100 BENEFITS 19,447 24,071 32,268 15,326 32,720 43,250 43,250 43,250 6001 WAGES & BENEFITS 126,214 116,163 144,790 71,429 145,810 173,940 173,940 173,940 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 6202 OPERATING SUPPLIES 19,940 61,852 88,105 36,677 117,460 128,000 128,000 128,000 6210 OFFICE SUPPLIES 15,937 940 205..... 1,000 1,000 1,000 6240 EQUIPMENT MAINTENANCE 118 111 1,779 6201 SUPPLIES & SERVICES 35,995 62,903 88,310 38,456 117,460 129,000 129,000 129,000 6300 PROFESSIONAL SERVICES 6310 ATTORNEY 205 6314 COMPUTER SERVICES 8,058 1,714 8,538 1,128 10,000 10,000 10,000 10,000 6316 EQUIPMENT MAINTENANCE 6,277 10,369 6,326 1,813 7,500 5,000 5,000 5,000 6327 OTHER PROF SERVICES 4,053 3,809 24 6300 PROFESSIONAL SERVICES 18,388 16,098 14,888 2,941 17,500 15,000 15,000 15,000 6330 COMMUNICATIONS 6332 POSTAGE 6 10 6334 TELEPHONE 913 1,299 1,493 413 1,000 1,000 1,000 1,000 6336 PRINTING/PUBLISHING 301 R5509BUD LOGIS005 CITY OF SHAKOPEE 7/30/200811:50:59 Fiscal Period: 6 I 8 Budget Report Page - 2 Level Of Rollup 7 2005 2006 2007 6/30/2008 2008 2009 2009 2009 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6338 ADVERTISING 1,057 6339 COMPUTER ACCESS 241 354 750 750 750 6330 COMMUNICATIONS 913 2,356 2,041 777 1,000 1,750 1,750 1,750 6350 INSURANCE 6352 LIABILITY 1,448 1,748 1,650 2,500 2,500 2,500 6356 AUTO 20 20 20 20 20 20 6350 INSURANCE 1,468 1,768 1,670 2,520 2,520 2,520 6400 RENTALS 6410 LOGIS/SOFTWARE 13,844 19,055 14,290 10,773 13,580 15,000 15,000 15,000 6430 BUILDING RENT (IS FUND) 5,724 2,918 6,000 6,960 6,960 6,960 6400 RENTALS 13,844 19,055 20,014 13,691 19,580 21,960 21,960 21,960 6470 DUESITRAININGITRAVEL 6472 CONFERENCE/SCHOOUTRAINING 6,399 3,280 5,244 4,679 7,000 5,000 5,000 5,000 6475 TRAVEL/SUBSISTENCE 515 395 74 1,000 1,000 1,000 1,000 W 6490 SUBSCRIPTIONS/PUBLICATIONS 478 864 191 100 1,000 1,000 1,000 1,000 6470 DUESITRAININGITRAVEL 7,393 4,539 5,435 4,853 9,000 7,000 7,000 7,000 6200 SUPPLIES AND SERVICES 76,533 106,419 132,456 60,717 166,210 177 ,230 177,230 177,230 6500 DEPRECIATION 6600 MISCELLANEOUS 6700 CAPITAL OUTLAY 6740 EQUIPMENT 5,107 76,023 12,968 8,000 8,000 8,000 6700 CAPITAL OUTLAY 5,107 76,023 12,968 8,000 8,000 8,000 6800 DEBT SERVICE 6000 EXPENDITURES 207,854 298,604 290,214 132,147 312,020 359,170 359,170 359,170 20 INFORMATION TECHNOLOGY 207,854 298,604 290,214 132,147 312,020 359,170 359,170 359,170 01000 GENERAL FUND 207,854 298,604 290,214 132,147 312,020 359,170 359,170 359,170 Info Tech 2009 Budget 0172 Object # Description IT Total 6002 Wages FT - Reg. 130,690 130,690 6005 Wages OT - Reg. - 6015 Wages PT - Temp - 6122 PERA 8,820 8,820 6124 FICA 10,000 10,000 6135 Health 17,700 17,700 6139 PEHP 600 600 6140 Life/L TO 570 570 6145 Dental 960 960 6170 Workers Comp 500 500 6180 Compensated Absences 4,100 4,100 Total Personnel 173,940 173,940 6202 Operating Supplies 128,000 128,000 6210 Office Supplies 1,000 1,000 6222 Motor Fuels & Lubricants - 6230 Building Maintenance - 6240 Equipment Maintenance - 6310 Attorney - 6314 Computer Services 10,000 10,000 6315 Building Maintenance - 6316 Equipment Maintenance 5,000 5,000 6327 Other Prof Services - 6332 Postage - 6334 Telephone 1,000 1,000 6336 Printing/Publishing - 6339 Computer Access 750 750 6352 Liability Insurance 2,500 2,500 6356 Auto Insurance 20 20 6360 Utility Service - 6365 Gas - 6367 Refuse - 6400 Rentals - 6410 LOGIS 15,000 15,000 6420 Equipment Rent - 6425 Equipment Rent (IS FUND) - 6430 Building Rent (IS FUND) 6,960 6,960 6435 Other Rent - 6472 Conf / School/Training 5,000 5,000 6475 Travel/Subsistence 1,000 1,000 6480 Dues - 6490 Subscriptions/Publications 1,000 1,000 Total Supplies & Services 177 ,230 177 ,230 6740 Capital Expenditures 8,000 8,000 Total $ 359,170 $ 359,170 4 2009 BUDGET Est. 2009 Pay Info Tech 2009 With COl Inc Title/Description Step 3.0% FICA PERA IT Coordinator A $ 70,619 $ 5,402 $ 4,767 IT Specialist C 56,455 4,319 3,811 Charge In Admin N/A 3,620 277 244 Total Info Tech $ 130,694 $ 9,998 $ 8,822 5