Loading...
HomeMy WebLinkAbout3.B. IT (Wilson) ~.€:>. CITY OF SHAKO PEE 2007 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 administration of the City and its services. 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 "general use" applications. To do this, the City currently employs a full-time MIS Coordinator and IT Specialist. Other support is provided by Local Government Information Services (LOGIS) . OBJECT DESCRIPTION: Description of line items: Wages & Benefits: Salaries: 1 MIS Coordinator, 1 IT Specialist, 1 Summer Intern ($6,500) Supplies & Services: License & Service Agreement Renewals $35,000, Server Replacement $14,000, Fiber Connection to LOGIS$5,OOO, Fire Dept. VOIP $15,000. Dues/Training/Travel: $9,000 Capital: Server Replacement $16,000 R5509BUD lOGIS005 CITY OF SHAKO PEE 8/10/200611:53:19 Fiscal Period: 6 / 06 Budget Report Page - 1 Level Of Rollup 7 2003 2004 2005 6/30/2006 2006 2007 2007 2007 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 01000 GENERAL FUND 20 INFORMATION TECHNOLOGY 6000 EXPENDITURES 6001 WAGES & BENEFITS 6002 WAGES 65,346 85,945 91,756 28,666 111,410 102,880 102,880 102,880 6005 OVERTIME-FT 1,229 3,321 2,000 6015 WAGES - PART TIMElTEMP 11,690 12,505 5,520 5,520 5,520 6002 WAGES 65,346 87,174 106,767 41,171 113,410 108,400 108,400 108,400 6100 BENEFITS 6122 PERA 3,614 4,821 5,904 2,459 6,810 6,430 6,430 6,430 6124 FICA 4,837 6,579 7,850 3,104 8,670 7,870 7,870 7,870 6135 HEALTH 415 2,222 5,365 2,470 4,820 9,990 9,990 9,990 6139 POST EMPLOYMENT HEALTH PLAN 313 423 581 143 600 600 600 600 6140 lIFEllTD 295 395 475 122 530 540 540 540 6145 DENTAL 353 498 632 175 960 1,080 1,080 1,080 6170 WORKERS COMPENSATION 774 850 1,300 1,000 1,000 1,000 6180 COMPENSATED ABSENCES 3,788 2,136- 3,000 4,000 4,000 4,000 6100 BENEFITS 9,826 18,725 19,447 9,323 26,690 31,510 31,510 31,510 6001 WAGES & BENEFITS 75,172 105,899 126,214 50,494 140,100 139,910 139,910 139,910 6200 SUPPLIES AND SERVICES 6201 SUPPLIES & SERVICES 6202 OPERATING SUPPLIES 36,588 22,382 19,940 56,518 70,000 91,100 91,100 91,100 6210 OFFICE SUPPLIES 7,597 34,744 15,937 28 6240 EQUIPMENT MAINTENANCE 118 111 6201 SUPPLIES & SERVICES 44,184 57,126 35,995 56,657 70,000 91,100 91,100 91,100 6300 PROFESSIONAL SERVICES 6314 COMPUTER SERVICES 20,243 6,931 8,058 20,000 15,000 15,000 15,000 6316 EQUIPMENT MAINTENANCE 941 489 6,277 2,313 3,000 11,000 11,000 11,000 6327 OTHER PROF SERVICES 217 3,914 4,053 3,670 1,000 6300 PROFESSIONAL SERVICES 21,401 11,334 18,388 5,983 24,000 26,000 26,000 26,000 6330 COMMUNICATIONS 6334 TELEPHONE 706 811 913 339 800 1,000 1,000 1,000 6338 ADVERTISING 1,352 6330 COMMUNICATIONS 706 2,163 913 339 800 1,000 1,000 1,000 R5509BUD LOGIS005 CITY OF SHAKO PEE 8/10/200611:53:19 Fiscal Period: 6 / 06 Budget Report Page - 2 level Of Rollup 7 2003 2004 2005 6/30/2006 2006 2007 2007 2007 Actual Actual Actual YTD Final Requested Approved Final Object Code / Description Amount Amount Amount Actual Budget Budget Budget Budget 6350 INSURANCE 6352 LIABILITY 1,448 1,600 1,600 1,600 6356 AUTO 20 20 20 20 6350 INSURANCE 1,468 1,620 1,620 1,620 6400 RENTALS 6410 lOGIS 8,172 9,851 13,844 11,174 25,140 13,580 13,580 13,580 6400 RENTALS 8,172 9,851 13,844 11,174 25,140 13,580 13,580 13,580 6470 DUESITRAININGITRAVEL 6472 CONFERENCElSCHOOUTRAINING 5,545 6,399 1,095- 6,000 7,000 7,000 7,000 6475 TRAVEUSUBSISTENCE 743 515 153 1,000 1,000 1,000 1,000 6490 SUBSCRIPTIONS/PUBlICA TrONS 356 77 478 1,500 1,000 1,000 1,000 6470 DUESITRAININGITRAVEl 5,901 820 7,393 942- 8,500 9,000 9,000 9,000 6200 SUPPLIES AND SERVICES 80,363 81,294 76,533 74,680 128,440 142,300 142,300 142,300 6500 DEPRECIATION 6600 MISCELLANEOUS 6700 CAPITAL OUTLAY 6740 EQUIPMENT 5,107 6,912 16,000 16,000 16,000 6700 CAPITAL OUTLAY 5,107 6,912 16,000 16,000 16,000 6800 DEBT SERVICE 6000 EXPENDITURES 155,536 187,193 207,854 132,086 268,540 298,210 298,210 298,210 20 INFORMATION TECHNOLOGY 155,536 187,193 207,854 132,086 268,540 298,210 298,210 298,210 01000 GENERAL FUND 155,536 187,193 207,854 132,086 268,540 298,210 298,210 298,210 Info Tech 2007 Budget 0172 Object # Description IT Total 6002 Wages FT - Reg. 102,880 102,880 6005 Wages OT - Reg. - 6015 Wages PT - Temp 5,520 5,520 6122 PERA 6,430 6,430 6124 FICA 7,870 7,870 6135 Health 9,990 9,990 6139 PEHP 600 600 6140 Life/L TD 540 540 6145 Dental 1,080 1,080 6170 Workers Comp 1,000 1,000 6180 Compensated Absences 4,000 4,000 6190 Retirement Benefit - Total Personnel 139,910 139,910 6202 Operating Supplies 91,100 91,100 6210 Office Supplies - 6222 Motor Fuels & Lubricants - 6230 Building Maintenance - 6240 Equipment Maintenance - 6310 Attorney - 6314 Computer Services 15,000 15,000 6315 Building Maintenance - 6316 Equipment Maintenance 11,000 11,000 6327 Other Prof Services - 6332 Postage - 6334 Telephone 1,000 1,000 6336 Printing/Publishing - 6352 Liability Insurance 1,600 1,600 6356 Auto Insurance 20 20 6360 Utility Service - 6365 Gas - 6367 Refuse - 6400 Rentals - 6410 LOGIS 13,580 13,580 6420 Equipment Rent - 6425 Equipment Rent (IS FUND) - 6430 Building Rent (IS FUND) - 6435 Other Rent - 6472 Conf / School/Training 7,000 7,000 6475 Travel/Subsistence 1,000 1,000 6480 Dues - 6490 Subscriptions/Publications 1,000 1,000 Total Supplies & Services 142,300 142,300 6740 Capital Expenditures 16,000 16,000 6498 Expenses Charged Back - Total $ 298,210 $ 298,210 2007 BUDGET Est. 2007 Pay 2007 With COL Inc Title/Description Step 3.0% FICA PERA IT Coordinator C $ 61,028 $ 4,669 $ 3,814 IT Technician E 46,848 3,584 2,928 Charge out Telecomm. N/A (5,000) (383) (313) Total Info Tech $ 102,876 $ 7,870 $ 6,429