Loading...
C2 2001 Budget IS Department L!-d. City of Chanhassen 2001 Budget Commentary General Government - Management Information Systems (MIS) Mission and Current Services The MIS Department provides and maintains both computer and network resources to all City computer users. The department is also responsible for managing the training needs for all other departments. A second staff member will be hired in 2001 to serve in a desktop support role, and will also function as the backup network manager. Budget Highlights The MIS department budget shows a 12% increase over the previous year. The increase is due to the addition of another staff member, who will be brought on to support the City's desktop computers and applications and assist with internal training. . Software licenses and registrations, previously coded in accounts 4703 and 4440 are now incorporated into a new account,4220. All annual maintenance charges for multi- departmental software will be funded out of this account. Future Trends The MIS Coordinator will be focusing on efforts to integrate departmental databases, into a single central database, which will be linked to the City's mapping products. Other projects will include improvements in remote access, network security, and intranet / . extranet development. :¡ , 1 , ;í .j ! ! ;Ì ; "t i City of Chanhassen MIS Department - 2001 Budget Worksheet PRELIMINARY NUMBERS Personnel Services Account 2001 2000 2001 No. Account DesCrlDtIon Budget R_stlmate Total 4010 Salaries and Waaes $ 94,000.00 4030 Contributions - Retirement $ 12,481.00 4040 Contributions - Insurance $ 11,418.00 4050 Contributions - Workers Comp $ 200.00 TOTAlS $ 94,000.00 Materials and Supplies Account 2001 2000 2001 . No. Account Description Budget Re-estlmate Total 4110 Supplies, Office $ 3,340.00 . 4130 Supplies, Proaram $ - 4150 Maintenance Materials $ 1.050.00 4210 Books & Periodicals $ 710.00 . 4220 Software License & Rea $ 27.800.00 4260 Small Tools & Equipment $ 1,050.00 TOTALS $ 33,950.00 Contractual Services Account 2001 2000 2001 No. Account DescriDtlon Budget R_stlmate Total 4300 Fees, Service $ 71,945.00 4310 elephone $ 600.00 4370 ravel & Trainina $ 30.150.00 4440 Ucense & Reoistration $ - 4530 Repair & Maintenance $ 5,000.00 TOTALS $ 107,695.00 Capitol Outlay Account 2001 2000 2001 No. Account Description Budget R_stimate Total 4703 OIIice Eauipment $ 78,100.00 4705 other Equipment $ - . TOTALS $ 78,100.00 I I I $ 313,745.00 I Totall.S. Budget 2000 Percent of Total Chafl(Le $ 56,000.00 40' $ 7.100.00 43' $ 2,950.00 74' $ 100.00 50' $ 66.150.00 30' 2000 Percent of Totals Change $ 6,500.00 -49 $ - $ 400.00 163 $ 400.00 78 New Account New Accoun $ 600.00 75 $ 7,900.00 330 2000 Percent of Totals Chanøe $ 69,100.00 4 $ 600.00 Ð $ 36.900.00 -18 $ 20,800.00 -100 $ 6.000.00 -2G $ 133,400;00 -11 2000 Percent of Totals Change $ 72,600.00 I $ - $ 72,600.00 I I I $ 280,050.00 I 1: Information Systems Department Bi- Annual Report <Ii On the Negative Side Budget Preparation / Communication Efforts Each year I find myself coming down to the last day in preparation of the upcoming years budget. I have always managed to get it in on time however I find myself lacking the time to do the kind of product research I would like to do. Other departments seem to have little change from year to year and can probably get by just editing last years figures, My area is subject to change as technology changes and as the entire staff needs change. Some of my difficu1ties lye with a lack of communication to Scott and Todd and other department heads. I realize the fault is mine, I need to request that I be allowed to attend the staff meetings on Tuesday mornings, and to dedicate more time to better assessing the needs of the departments. Public Works Vehicle Maintenance I have been struggling in my efforts to automate the scheduling of vehicle maintenance for the shop staff. Last spring we purchased a database application for this purpose but I was unable to successfully deploy it due to hardware and network limitations. The shop now has its own server and the database has been migrated however I have run up against several other issues. There are three applications, which must be integrated to make this database function properly. I have been able to do this manually but this requires me to be onsite. This must be fully automated for it to be useful to the shop staff. I will be working with Mindsharp Learning, purchasing some consulting time to assist with the final automation scripts. On The Positive Side Training I Application Skills One of the goals, which will be forever on my list, is to improve the software skill levels of the City users. Offsite training for applications at Mindsharp has been very successful. Those that have attended have found the classes have helped them in their daily work. I now have some employees that have begun assisting others with application questions. The GIS applications, ArcExplorer and ArcView have been deployed and users are starting to work with the product. I believe it has become evident to them how GIS will make them more efficient in the tasks they perform. The Engineering department has taken advantage of the courses at Rowekamp and are starting to incorporate Arc View in their work. The Planning department will be sending staff soon. Fiber MAN / Network The KMC fiber project is proceeding and is in the final stages of the fiber build. This infrastructure will support the City's network needs for the next decade. My thanks to Todd Gerhardt in getting this project moved through to final Council approval. When the fiber is finaHy lit; management tasks for the other two facilities will drop dramatically. It , also opens the door to expanding existing and future applications to all users. The project includes rewiring the Public Works Rec Center facilities with updated CatSe wiring. On The Other Side Y2K No fuss, no muss, no bugs found. Server Room Wiring Neatness counts and it is getting neater all the time. Turtle PCs Have all crawled downstairs and will be soon migration to the scrap heap City of Chanhassen 2001 Budget Commentary General Government - Management Information Systems (MIS) Mission and Current Services The MIS Department provides and maintains both computer and network resources to all City computer users. The department is also responsible for managing the training needs for all other departments. A second staff member will be hired in 200 I to serve in a desktop support role, and will also function as the backup network manager. Budget Highlights The MIS department budget shows a 12% increase over the previous year. The increase is due to the addition of another staff member, who will be brought on to support the City's desktop computers and applications and assist with internal training. Software licenses and registrations, previously coded in accounts 4703 and 4440 are now incorporated into a new account, 4220. All annual maintenance charges for multi- departmental software will be funded out of this account. Future Trends The MIS Coordinator will be focusing on efforts to integrate departmental databases, into a single central database, which will be linked to the City's mapping products. Other projects will include improvements in remote access, network security, and intranet / extranet development. City of Chanhassen MIS Department - 2001 Budget Worksheet PRELIMINARY NUMBERS Personnel Services Materials and Supplies 1,050.00 710.00 27,800.00 1,050.00 *!Jj9 . Contractual Services $ 8,500.00 $ $ 400.00 $ 400.00 New Account $ 600.00 IB!$M!:.! ...mÇ! -49% 163% 78% New Account 75% Fees, Service T ele hone Travel & Trainin License & Re istration Repelr & Maintenance i&1%¡ø-'¡St >¡,:¡,,,,,,M,,.,,.)*,,~,.,,<..:,: Capi.tol Outlay 4010 - Salaries and Wages _.1"" u ·__j~;~~I_] %i .'. __ _ ___",-,.; ~_JN"", - _. Richard Rice - I.S. Coordinator Desklo En ineer, Future Hire 4030 - Contribution - Retirement -- '..' ..... ,)i!!W .... .. ,».,æ,~",··. """" Richard Rice - I.S. Coordinator Desklo En ineer, Future Hire IS $ IS $ 7,466.00 5,015.00 1 $ 7,466.00 1 $ 5,015.00 $ $- $ ¡$)jÙ¡l2ì4~'iOO; 4050 - Contribution - Insurance ~"1S;Ðm -,,,~eUm ::"Cwc<·_,'..';· Richard Rice - \.S. Coordinator Desklo En ineer, Future Hire 5,709.00 5,709.00 :?:i'thfC¡:{;;}=+}.k?knr \~lt'~~'Jtd{T-iJ:tS{~1ÆI;:}c\~ )J{;o.1l!1~<,.q IIJF 1 $ 5,709.00 1 $ 5,709,00 $ $ $ ~,$YÌ{i lj418;OO, Contribution - Workers Comp _~{.~'R1 @\i;"::,:;-',,,"__''''__'"A'; .-" <_~,:", ,:;",::~t;:", 11;::"'<:FI\t'~'M'A'" Richard Rice - I.S. Coordinator Desklo En ineer, Future Hire IS $ IS $ 100.00 100.00 1 $ 100.00 1 $ 100.00 $ $ $ 1UI&!ÞGQQIQI1 4110 - Supplies, Office 1~_1ñDI1 Backuo Taoes, DAT, 24Gb Caoacltv IS $ 20.00 Ea 20 $ 400.00 Disks, CD-R Media IS $ 120.00 Cese 100 1 $ 120.00 Toner Cartridoe, T Mierolaser IS $ 140.00 Ea 1 $ 140.00 LS1 20 Cartridaes IS $ 12.00 Ea 20 $ 240.00 Binders, Media Cases, Mise Office Supplies IS $ 300.00 General 1 $ 300.00 Chair, Pnuematic, Server Room IS $ 140.00 Ea 1 $ 140.00 $ - $ - $ - $ · $ · $ - $ - $ - . $ - $ - $ - . $ - . $. - $ · $ - $ - $ - $ - $ - $ - . $ - $ - $ - $ - . $ - $ - $ - $ - $ - $ · $ - $ - $ - $ - $ - $ - :*',' ¡¡'ó :i34(M!P' 4130 - Supplies, Program I~. .,.' .íi'J_1IIIIIIÎ'ól~¡w¡¡r...' iim. . !!..,..... ~ft%!ZiE1%ii .. ,...._~...',,' $ · $ · $ · $ - $ - $ · $ - $ - . $ - $ · . $ · $ · $ · $ - $ · $ · $ - $ - . $ - $ - $ · $ · $ · $ - $ · $ - '. $ · $ - $ · $ · $ - $ · $ · $ · $ - .. $ - $ · $ · $ · $ · $ - $ · $ · $ · " 4150;. Maintenance Materials lìllÎ_.I....:t.Ii'~11 Cable Ductino, Network Rack .IS $ 300.00 General 1 $ 300.00 Cable Tves, Markers, IS $ 150.00 General 1 $ 150.00 Patch Cables, Cat 5e IS $ 300.00 General 1 $ 300.00 Patch Panels, Cat 5e FD $ 150.00 Ea 2 $ 300,00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ . $ - . $ - -c $ - $ . $ - $ - $ - $ - $ - . $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - . $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - .-.-;.. " 4210 - Books & Periodicals . ~1f._ØiII···'JLÕ!'91i. ". .,' .'. _.' __ _, _._. flU.". ..,"" ,_ _ .' " .,<, ..' }Ii_·",~_.__.o. Subscriotion, PC World IS $ 20.00 Annual 1 $ 20.00 Subscription. PC Maaazlne IS $ 20.00 Annual 1 $ 20.00 Subscriotion, Microsoft Technet IS $ 350.00 Annual 1 $ 350.00 Window 2000 Server Documentation Set IS $ 300.00 Annual 1 $ 300.00 $ - $ - . $ · $ - . $ · $ · $ - $ - . $ - $ - $ · $ · $ - . $ · $ · $ · $ - . $ - $ · $ - $ - $ - $ · $ - $ - $ - $ - $ - $ - . . $ - $ - $ . $ - $ - $ - $ - $ - $ . . 4220 - Software License & Registrations -- Microsoft SOL Server En!, Ucense + 25 Clients All $ 8,000.00 Ea 1 $ 8,000.00 Microsoft SOL User License AIi $ . Ea 1 $ · Remote Administration Solution, NT Server Base IS $ 2,500.00 Ea 1 $ 2,500.00 Microsoft Windows 2000 + 100 CALS ICFS1 Uoarade ) IS $ 2,900.00 Ea 1 $ 2,900.00 Norton Antivirus UDdates AIi $ 10.00 Ea 80 $ 800.00 Defraarmentation Software, NT Server IS $ 350.00 Ea 3 $ 1,050.00 Microsoft Excha;;;;& 2000 Server, UMrade IS $ 800.00 Ea 1 $ 800.00 Microsoft Exchanae 2000 Client Access Uaarade All $ 30.00 Ea 80 $ 2,400.00 Ente.;;-rise Backun Software, Backun Exec IS $ 700.00 Ea 1 $ 700.00 Exchanoe-ÓDtlon, Backun-Exec IS $ 500.00 Ea 1 $ 500.00 Onen File Anen, Backun Exec IS $ 500.00 Ea 1 $ 500.00 SOL ADent, Backw> Exec IS $ 600.00 Ea 1 $ 600.00 Microsoft Window 2000 Server uoorade, Fire Deot 10 Cals FD $ 900.00 Ea 1 $ 900.00 Microsoft Windws 2000 Server, SQL Server w 25 CALs IS $ 2,000.00 Ea 1 $ 2,000,00 Red Hat Linux OS, A';D¡'che Web Server IS $ 200.00 Ea 1 $ 200.00 Adobe Paoemaker 6.5 Adm $ 500.00 Ea . 2 $ 1,000.00 Microsoft Access 2000 All $ 200.00 Ea 8 $ 1,600.00 Microsoft Proiecl2000 All $ 270.00 Ea 5 $ 1,350.00 $ · $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ · $ - $ - $ · $ · $ · $ - ww. 4260 - Small Tools & Equipment ~iIíØ~~".lIõl " ... !a ."' " .' .,.. Cal 5 Twisted Pair Cable IS $ 350.00 500' 50001 1 $ 350.00 DiQilal Multimeter IS $ 200.00 Ea 1 $ 200.00 Vaccuum. Toner IS $ 250.00 Ea 1 $ 250.00 T ele;;hone Butt Set IS $ 250.00 Ea 1 $ 250.00 $ - $ · $ - $ - $ · $ - $ · $ · . $ - $ - $ · $ · $ · $ · $ · $ - . $ · $ · $ - $ · . . $ · $ - $ - $ · $ - $ - $ - $ - $ - $ - $ · $ - $ · $ - $ · $ · $ - $ - $ · $ - :.:. ~1~¿'¿:Ü'it*wW&~U< 'it'·" '" '~'~W":¡r" (iJi;',1,P,¡¡P;,P 4300 -Fees, Service _J ESRI - Arclnfo Software SUDDDort Services - Eno $ 3,000.00 EA 1 $ 3,000.00 ESRI- Arc CO GO Software Sunnort Services Ena $ 500.00 EA 1 $ 500.00 ESRI . Arc Storm Software si.iDDort SeIVices Eno $ 500.00 . Ea 1 $ 500.00 ESRI - Arc Press Software Sunnort SeIVlces Eno $ 500.00 EA 2 $ 1,000.00 ESRI . Arc Tin Software Soonort SeIVices Eno $ 1.250.00 Annual 1 $ 1,250.00 ESRI - Arc GRID Software Sunnort SeIVlces Ena $ 1,250.00 Annual 1 $ 1,250.00 Sierra !:iIOiial . Software Sunoort . Leaoue Pk,AdrI $ 995.00 EA 1 $ 995.00 Sierra Dlnital . Software Sunnort . Facllitv Pk,Adn $ 995.00 EA 1 $ 995.00 Sierra Dlnltal - Software Su.;;;ort - R8@stratlon Pk,Adn $ 995.00 EA 1 $ 995.00 Ouest - Software SUDoOrt - Maint Menaoer Pk,Sh $ 400.00 EA ·1 $ 400.00 ISP Dialun Services Admin $ 240.00 Annual 3 $ 720.00 Network Suooort I Consultino IS $ 100,00 Hours eo $ 8,000.00 VisionalV Svstems - Software Suooort - Firehouse FD,PS $ 130.00 EA 3 $ 390.00 Network WiriririSeIVice, Data I Voice IS $ 2,000.00 Est 1 $ 2,000.00 Printer Maintenace SeIVlce IS $ 1,500.00 Est 1 $ 1,500.00 CMS - Software S;:¡;;;;Qrt - Util¡¡;;- Billiriri All $ 2,400.00 Annual 1 $ 2,400.00 TR Svstems . Soltware Suooort - Geobase I Plannino IS $ 1,000.00 Annual 1 $ 1,000,00 TR S;;-stems - Software S¡:¡;:;;:;c,rt - Permits IlnsDections IS $ 1,000.00 Annual 1 $ 1,000.00 TR SvStems . Software Suooort - Licenses FD $ 1,000.00 Annual 1 $ 1,000.00 TR Svstems - Visual Basic Uoorades for all modules IS $ 1,000.00 Annual 3 $ 3,000.00 Fundbalance - Software S¡:¡;:;;:;c,rt - UtiliiVBlllinn Fin $ 950.00 Annual 1 $ 950.00 Fundbalance - Software SUODOrt - Accounts Pavable Fin $ 650.00 Annual 1 $ 650.00 Fundbelance . Software S¡:¡;:;;:;c,rt - General Ledner Fin $ 1,000.00 Annual 1 $ 1,000,00 Fundbalance . Software Su.mort - Pavroll Fin $ 950.00 Annual 1 $ 950.00 Fundbalance - Software SUODOrt· Cash Recieotino Fin $ 500.00 Annual 1 $ 500.00 Fundbalance . Software S¡:¡;:;;:;c,rt - Accounts Recievable Fin $ 500.00 Annual 1 $ 500.00 ISP Access Ch8.mes, CiiV Hall, Rec Ctr, Pub Works 12 $ 1,000.00 Annual 12 $ 12,000.00 Consulti¡;;;- Services, SOL Database intenration IS $ 135.00 Hours 100 $ 13,500.00 DSL SeIVice, Fire DeDI, Main Station FD $ 100.00 Monthlv 12 $ 1,200.00 $ · $ - $ - $ - ..:. . $ - $ - $ · $ · $ - $ - $ - $ · $ - $ · . . Cellular Service IS $ 25.00 Monthlv 12 $ 300.00 $ - $ - $ - $ · . $ · $ - $ - $ - $ · $ - $ . - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ . $ - $ - $ - $ - $ - $ - $ - $ . $ - $ - $ - $ - $ - $ - $ - $ - $ . $ - $ - $ - $ - . -~íë}';~~kt*iÜèt;~Æ~-S'«;(· 'i;"'>'1··"'''''''t~ " ; XilJ1j,ßO,OJOO; 4310 - Telephone _..··.>;.·.·"'.'.····.·~IJIII!¡¡ìõ. _~.' .." ., .,. . JI!!", 4370 - Travel & Training -.... Aoolicetion Trainina Courses All $ 190.00 EA 25 $ 4,750.00 GIS Develoomenl & Uodate Trainino Courses I=no,Adn $ 1,500.00 Ea 3 $ 4,600.00 ArcView Trainino, . Advanced Courses I:,iQ,Adn $ 700.00 EA 12 $ 8,400.00 Seminar, GIS/LIS, St. Cloud Ena, PI, $ 300.00 Ea 2 $ 600.00 Seminar, ESRI Product Update, Rowekamp Enn,Pln $ 100.00 Ea 2 $ 200.00 Seminar, UolM Technoloov Uodate ,Adm,E $ 50.00 Ea 4 $ 200.00 Exchanae 2000 Server IS $ 2,126.00 Ea 1 $ 2,125.00 Exchanoe 2000 Server, Concepts and Administration IS $ 1,750.00 Ea 1 $ 1,760.00 Windows 2000 Network Essentials IS $ 1,250.00 Ea 1 $ 1,250.00 S.mnortino Win 2000 Server and Professional IS $ 2,125.00 Ea 1 $ 2,125.00 SYStem Admin for SOL 7.0 IS $ 2,125.00 Ea 1 $ 2,125.00 Imnlement DB Desian SOL 7.0 IS $ 2,125.00 Ea 1 $ 2,125,00 $ - $ - $ · $ - $ · $ - $ - $ - . $ - $ - - $ - $ · $ - $ - $ - $ - $ · . $ - $ - $ · $ - $ - $ - $ · $ - $ · $ - $ - $ - $ - $ - $ · " " 4440 - License & Registrations "1.'JÁ'Jtm!..__.AItII"~ ., .-"',,-, $ · $ - $ - $ - $ - $ - . $ · $ · $ - $ - $ · $ - $ - . . $ · $ · $ , $ · $ · $ , $ · $ · . . $ · $ · $ - $ - $ - $ - $ - $ - $ - $ · $ - $ - $ · $ - $ - $ · $ · $ · $ - $ - $ - $ - $ - {! " 4530 Repair & Maintenance 1..~_..:t1i' . . . z 4703 Office Equipment - Firewall, VPN Hardware platform, SOHO (FD) FD $ BOO.OO Ea 1 $ 800.00 Server, PIII,SQL Database IS $ 7,000.00 Ea . 1 $ 7,000.00 Replacement PC's IS $ 1,300.00 Ea 15 $ 19,500.00 Proiector, LCD, Portable All $ 6,000.00 Ea 1 $ 6,000.00 Tape Drive, DL T Autoloader IS $ 9,000.00 Ea 1 $ 9,000.00 Palm Pilot, IS $ - HP 8100DN ,Admin Reolacement Printer Adm $ 3,600.00 Ea 1 $ 3,600.00 Internal CD·RW I Fiopov Uoarede, Delllnsoiron IS $ 450.00 Ea 1 $ 450.00 HP 4050TN, Finance Replacement Printer Fin $ 2,000.00 Ea 1 $ 2,000.00 HP2100TN, Finance Check Writer minter, secured Fin $ 1,500,00 Ea 1 $ 1,500.00 Server, Dell 1300, FD Reolacement FD $ 4,000.00 Ea 1 $ 4,000.00 Laptop PC, Fire Dept. FD $ 3,000.00 Ea 2 $ 6,000.00 Switch, 3com 1100 Adm $ 1,000.00 Ea 2 $ 2,000.00 Workstation, Pili, SCADA Reolacement System IS $ 3,500.00 Ea 1 $ 3,500.00 Monitor, 17"TP, HB, IS $ 350.00 EA 5 $ 1,750.00 Laptoo PC, IS IS $ 4,000.00 EA 1 $ 4,000.00 IS $ - . IS $ - IS $ - IS $ - IS $ - IS $. - IS $ - IS $ - IS $ - IS $ - IS $ . IS $ - GIS $ , IS $ - IS $ , IS $ - . IS $ - IS $ - IS $ - $ - $ - $ , $ - $ , $ , $ - "'t%TI,'1""'"'' "-JÆ ""J:>i{;1'¥' ',:¡.;., "> O,i'·,"·..."~~· j!!itQQ.;PPi 4703 - Office Equipment ...œ;ímì~'WAIIIIU'.iI"'öÖ¡'Q~t ~B':>,;,",,:,.¥!"I_, .JY~l _ _ " ...",",. œ~Æf;1"*"-:"".",%,,, , " 4705 - Other Equipment ~- ~K ~, " " $ - $ - $ · $ · $ - $ · $ · $ - $ - $ - $ · $ - $ - $ - $ - $ - $ - $ · . $ - $ - $ · $ - $ - $ - $ - . $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -