Transcription
2006 – 2007 Proposed Budget --- Budget SummaryInformation Systems & Services Fund – Internal IS2006 – 2007 Internal - Information SystemsBudget HighlightsFull-Time Equivalents2005 - 2006Change2006 - 20071.001.010.020.013.00No proposed changes in personnel.New Programs, Projects, or Equipment: 20,000 --- New computer training lab hardware. Needed tosupport new programs; such as, Visionair for Police and Fire,new ERP financial system, GeoComm mapping for Police andFire. 4,850 --- Wireless access points for computer connections inCommunity Center, Fire Station, City Hall, and Police Station. 11,702 --- IS Personnel Computer Equipment: Desktop computer replacements – 2 Data projector unit - 1 Miscellaneous equipment, software, referencemanuals, surge protectors, PDAs, etc. Replacement of 36 desktop computers comprisingapproximately 21% of total. Several machines beingredeployed to less demanding environments. Computer network is very stable and secure. It is showing theresults of investment in infrastructure. The Department is wellpositioned to support current City services.FTE Adopted BudgetIS Analyst IIIIS Analyst IIIS Analyst IFTE Proposed Budget2.99 Short- and Long-Term IssuesShort-Term Issues --- addressed by 2006 – 2007 ProposedBudgetLong-Term Issues Complete installation of MDT software for police and fire.Mobile applications running now. Mapping software indevelopment and anticipated for install in 2006 - 2007.Partner with Finance Department in the replacement of theFinancial and Accounting system.Design and develop phase II of City website development.Ensure that the information is consistently updated, and thatall training requirements are completed.
2006 – 2007 Proposed Budget --- Budget SummaryInformation Systems & Services Fund – Internal ISCore Services Provide business partnerships with City departments as theydefine processes to fulfill their individual missions.Provide reasonable network, hardware, and softwareresources to City departments for the accomplishment of theirbusiness tasks.Provide network support, security, maintenance and capacitynecessary for the City to conduct its business tasks.Provide software acquisition, support, and maintenancenecessary for the City to conduct its business.Provide hardware resources and support – both servers anddesktop – for the City to conduct its business tasks.Regularly conduct research and consult with departments inthose areas where technology can provide better service tocitizens.The network servers on theCity network have total storagecapacity of 1,583 gigabytes.On an average day, there areover 16,000 internettransactions on the Citynetwork.There are 182 desktop computersand laptops throughout Citydepartments.There are 18applicationservers onthe Citynetwork.On average,there are over200 attemptedvirus and/orspyware attackson the Citynetwork per day.
Information Systems & Services Fund – Internal IS --Historical Highlights1993City’s first Information SystemsManager hired – Lloyd Lowry.1995Fiber Optic Cable Projectimplemented resulting in fiberloop connecting City facilities.19951996System AdministrativeSpecialist hired to help withexpanding City IS needs.City transitions to MicrosoftOffice Suite – Outlook, WORD,EXCEL, & Powerpoint. Emailbegins!1998City hires Wide-Area NetworkAdministrator and shares cost50-50 with McMinnville SchoolDistrict #40.1998YCOM’s Information Specialistbecomes a City employeemanaged by the City’s ISManager. Also, City’s ISpersonnel cover for YCOM’sInformation Specialist when heis on leave.2001City Manager Taylor appointsJohnny Vinson IS Director onLloyd Lowry’s resignation.20012001McMinnville SchoolDistrict #40 eliminatescost sharing of WideArea NetworkAdministrator position.Position assimilated intoCity budget.Network Administratorposition added tosupport expanding Citynetwork - total file servercount 52002IS DepartmentCompleted migration ofCity network from acombined Novell andWindows NT system toWindows 2000,standardizing operatingsystems City-wide.2003Partnership formed withYamhill County formanagement of ISservices; City directorposition eliminated.2003Restructure of ISDepartment begins tobetter serve Citynetwork and Citydepartment softwareapplication needs.2004Software application supportposition filled. IS Departmentpersonnel restructure complete– 3 FTE plus YCOM ISTechnician.2004Plan and move physicallocation of IS Department tothe Community Center.2005Completed move of all Citytelephones back onto CityCounty telephone system.2006Implemented mobile dataterminals in fire and policevehicles. First agencies touse new 700 mhz publicsafety frequencies in thestate.2006Completion of new computerequipment room with backupgenerator in CommunityCenter.There are, on average, over 400 spame-mail messages blocked per day thatare destined to City e-mail addresses.
INTERNAL INFORMATION T2005-0602-Aug-06NUMBER 06-07REQUIREMENTSPERSONAL 310 80273-00IS ANALYST IIIMatthew Hoffman109,591 80353-00IS ANALYST IIMike Hostetler46,668 80373-00IS ANALYST IScott Neubig0 80385-00EXTRA HELP - 52,66352,66352,6630.007,000 80386-00OVERTIME0.00For required maintenance scheduled after working hours and occasional extra work required during peakactivity periods.008,0008,000000 80388-000.000009,26510,67912,488 92 80390-00PERS - OPSRP - IAP0.0044,20244,20244,20217,05818,76229,456 80391-00MEDICAL INSURANCE0.0029,50829,50829,508206206204 80392-00LIFE INSURANCE0.00207207207339426429 80393-00WORKERS' COMPENSATION INS0.005105104928,66001,000 80394-00UNEMPLOYMENT0.001,0001,0001,000645860890 80395-00DISABILITY 0247,218FRINGE BENEFITS:08,000TOTAL PERSONAL SERVICESMATERIALS & SERVICES400 80420-00EMPLOYEE DEVELOPMENT0.00"In-house" presentations, seminars, and workshops providing continuing development for City6,000 80421-00TRAVEL & EDUCATION0.00Technical training, network training, desktop training, and application development training, includestravel and meal expenses to seminars and conferences.City of McMinnville Budget Supplement - AdoptedPage 189
INTERNAL INFORMATION 005-0602-Aug-06NUMBER OFEMPLOYEESPROPOSED2006-07600 80431-00VEHICLE EXPENSE0.00Gasoline and vehicle maintenance.*PB --- Includes 1% of Floyd Whitworth's compensation, 755. Street will bill IS fortime spent maintaining/repairing IS van instead of setting up a transfer.KS & CB --- Likely will need to follow-up with Streets !!!RG --- Record JE in 2006-2007 !!!5,000 80451-00TELECOMMUNICATIONS:Internal IS Department telephones, pagers, cell phones, and modem lines.0 80451-01TELECOM - CITY ,0000002,500 80451-11DATA COMMUNICATIONS0.00Data communication cost for the City-wide internet connection.2,000 80461-00MATERIALS & SUPPLIES:0.00General office supplies, postage, shipping, professional subscriptions and dues, expendable computersupplies, and training materials including purchased training videos and miscellaneous training2,5002,5002,5002,1202,1202,1200 80461-02M&S - ERPMaterials and supplies for Financial System - ERP Project.2,000 80471-00REPAIRS & MAINTENANCE:Equipment repairs and software upgrades not covered by maintenance contracts.0 80471-07R&M - 01,900 80511-00INSURANCE-PROPERTY & LIABILITY0.002,4002,4002,400JANITORIAL 0025,00025,00070070070010,00010,00010,000500 80609-006,660 80611-00PROFESSIONAL SERVICES:2,000 Network support assistance2,000 Other professional services700 Audit fee100 Section 125 employee accounts administration fee0.00APPROVED2006-07*RB --- Includes Hinman Agency !!!25,000 80611-02PS - ERP CONSULTANT0.00Professional services consultant for Financial System - Enterprise Resource Planning (ERP) Project toassist City with implementation services and contract assurance issues.600 80611-05PS - HUMAN RESOURCES0.0010,000 80611-11PS - CONTRACT PROG & ANLYSIS0.00Maintenance of current financial software that augments the City's COBOL Group 4 financial softwareproviding network cabable functionality. These Windows based programs are the Online FinancialReporting System (OFRS), Budget Preparation System (BPS), and Purchase Order and CommitmentTracking System (POCIT) and are available for all operating department use.City of McMinnville Budget Supplement - AdoptedPage 190
INTERNAL INFORMATION 3-04ACTUAL2004-0522,41715,52220,000 80611-21PS - GROUP 4 SOFTWARE SUPPRT0.00Ongoing programming maintenance and support with no system enhancements for Group 4, the City'sCOBOL- based financial system software as the system is being replaced.10,00010,00010,00043,32047,69049,000 80615-00CONTRACT SERVICES - IS MGMT0.00Yamhill County service contract for management of the City's Information Services Department andadditional IS support staff, includes 3% increase. Also includes 5% prior allocation to ExternalInformation Systems.53,15053,15053,1500 80631-00NUMBER OFEMPLOYEESMAINT & RENTAL 6-07000.0000014,65710,89117,569 80631-01M&R CONTRACT - HDWRE MAINT2,900 Maintenance contract - finance system printer2,200 Maintenance contract - financial server hardware1,000 DLT tape backup drive support4,000 Various server maintenance agreements - 53,400 Maintenance contract - Smartnet Cisco routers395 WYCOM check signer maintenance agreement774 HP Plotter maintenance600 HP Backbone maintenance renewal250 Verisign renewal700 Novell Update support0.0016,21916,21916,21920,61250,72137,960 80631-11M&R CONTRACT - SFTWR MAINT6,200 Accela Permits Plus program support2,000 ESRI Arcview maintenance and support4,350 Amazon ambulance billing maintenance and support4,400 Amazon Field Data5,100 Hansen software maintenance and support500 GFI Mailessentials maintenance and support300 GFI Mailsecurity software subscription1,300 Symantec anti-virus city-wide maintenance renewal2,500 Veritas Backup software maintenance50 Symantec anti-virus for RMS server maintenance renewal300 Veritas Backup software maintenance for RMS server1,100 Caselle software maintenance7,300 Websense annual maintenance1,600 Diskeeper Pro maintenance3,000 Resilience Firewall/Checkpoint software600 Scriptlogic Desktop authority maintenance2,666 Visionfire, Papervision, Paperflow 02,00000000000001,700 80637-00FACILITY SERVICES0.00Electrical wiring expansion for IS offices.0 80680-00M&S ASSETS:0.00Materials & Supplies Asset purchases, with values under 4,999 and more than one-year useful life.0 80681-00M&S EQUIPMENT:0.00City of McMinnville Budget Supplement - AdoptedPage 191
INTERNAL INFORMATION ,875BUDGET2005-060 80681-0102-Aug-06NUMBER OFEMPLOYEESM&S EQUIP - 06-070.000000.0032,45232,45232,4523,200 80681-05M&S EQUIP - INVENTORYSpare inventory computer equipment for emergency replacements.0 80681-07M&S EQUIP - MOVING0.000000.000008,500 80681-30M&S EQUIP - NETWORK SOFTWARE1,590 Terminal server CALs10,000 Network server monitoring software500 Desktop hardware/software monitoring tools3,250 Diskeeper Defrag for standard and entterprise 60007,7007,7007,70013,350 80681-03M&S EQUIP - IS5,900 Replacement computers - 2, Scott and Matt2,500 Second loaner/training data projector20,000 Mobile training lab, laptops stored in Fire Station conf. area.3,302 Miscellaneous IS equipment - software, reference materials, surge protectors,cabling, PDAs, monitors, external drives, memory upgrades750 Office chair, anti-static mat, and cargo floor mat for van50,446 80681-50M&S EQUIP - NETWORK HARDWARE1,500 Server room environment monitoring4,000 New server domain controller13,646 UPS power sources for network backbone3,850 Additional batteries for server room UPS4,850 WiFi wireless access points with wiring for City Hall, Community Center,Police Department, and Public Works4,000 Replacement server for SPAM-X0 80683-00M&S COMPUTERS - DEPT HW/SW:0.00Materials & supplies - computer hardware and software purchases, values under 4,999 and more thanone-year useful life.6,650 80683-01M&S COMP - ADMIN/FINANCE7,700 Department Computer Equipment5,100 Replacement computers, Finance - 32,000 Color laser printer (if necessary)600 Comprehensive Annual Financial Report (audit) softwareCity of McMinnville Budget Supplement - AdoptedPage 1920.00
INTERNAL INFORMATION 2-Aug-06NUMBER OFEMPLOYEES15,380 80683-03M&S COMP - POLICE31,380 Department Computer Equipment7,500 Replacement computers - 52,800 Replacement laser printers - 210,000 Electronic ticketing system, test equipment and initial phase280 Printer warranty extension3,600 Replacements for LEDS printers - 22,400 Dell Axium handlhelds - 6800 Memory upgrades - 84,000 Laptops for detectives - 1,38031,38031,3805,720 80683-04M&S COMP - MUNICIPAL COURT2,100 Department Computer Equipment1,700 Replacement workstation - 1300 Memory upgrades - 3100 Wireless mouse0.002,1002,1002,1001,400 80683-05M&S COMP - ENGINEERING12,220 Department Computer Equipment3,600 Replacement workstations - 21,450 Laser printer - 1200 Memory upgrades - 24,000 GIS Software upgrades1,370 Plotter warranty extension1,600 Monitor replacement upgrades - 20.0012,22012,22012,22018,870 80683-07M&S COMP - LIBRARY16,800 Department Computer Equipment12,000 Replacement computers - 84,000 Inkjet printers - 3800 Memory upgrades - 80.0016,80016,80016,8005,100 80683-09M&S COMP - BUILDING3,400 Department Computer Equipment3, 400 Replacement computers - 20.003,4003,4003,4001,800 80683-11M&S COMP - PLANNING5,900 Department Computer Equipment1,800 Replacement computers - 11,800 New computer - 1300 Printer warranty extension2,000 Laptop computer - 10.005,9005,9005,900City of McMinnville Budget Supplement - AdoptedPage 193
INTERNAL INFORMATION 00001,6960BUDGET2005-0602-Aug-06NUMBER OFEMPLOYEES6,560 80683-13M&S COMP - FIRE26,615 Department Computer Equipment5,600 Replacement computers - 1, laptops - 2 --- 100% Fire20,000 Additional MDT units for fire vehicles --- 100% Fire560 Replacement computers - 1 --- 35% Fire/ 65% EMS105 Printer warranty extension - 1 --- 35% Fire/ 65% EMS350 Wireless access points - 2 --- 35% Fire/ 65% 026,61526,61526,6150.001,7001,7001,7001,850 80683-17M&S COMP - AQUATIC CTR750 Department Computer Equipment500 Flat panel monitor - 1250 KVM keyboard extender0.007507507501,5501,900 80683-19M&S COMP - COMMUNITY CTR4,550 Department Computer Equipment1,600 Replacement computers - 11,450 Replacement laser printer - 11,500 WiFi base units - 30.004,5504,5504,55001,5501,600 10.001,6001,6001,6000 80683-15M&S COMP - PARKS ADM1,700 Department Computer Equipment1,700 Replacement computer - 1M&S COMP - REC SPORTS300 80683-21M&S COMP - SENIOR CENTER3,000 Department Computer Equipment3,000 Replacement computers - 21,600 80683-23M&S COMP - PARKS MAINT10,050 Department Hardware and Software3,750 Hansen Plant/Fleet module --- 50% Park Maintenance/50% Street6,300 Hansen Parks module --- 50% Park Maintenance/50% Street0 80683-25M&S COMP - STREETS13,650 Department Computer Equipment3,400 Replacement computers - 2200 Memory upgrades - 23,750 Hansen Plant/Fleet module --- 50% Park Maintenance/50% Street6,300 Hansen Parks module --- 50% Park Maintenance/50% Street6,029 80683-27M&S COMP - WRF1,600 Department Computer Equipment1,600 Replacement computers - 1City of McMinnville Budget Supplement - AdoptedPage 194
INTERNAL INFORMATION T2005-0606,747031,126170,642422,624000 80701-00000 80701-01000000000002-Aug-06NUMBER 06-075,300 80683-29M&S COMP - SEWER MAINT5,300 Department Computer Equipment1,600 Replacement computers - 13,200 Additional connections for Hansen - 4500 DVD storage for TV van0.005,3005,3005,3009,890 80683-31M&S COMP - EMS4,585 Department Computer Equipment1,885 EMS 65% of shared equipment with fire - 35%1,700 Replacement laptop - 11,000 Sweet Field Data software 3EQUIPMENT - MISCELLANEOUS:0.00000EQUIPMENT - IS COMPUTER0.000000 80704-00EQUIPMENT - NETWORK SOFTWARE0.0000050,300 80705-00EQUIPMENT - NETWORK HARDWARE0.000000 80707-00EQUIPMENT - DEPT HARD/SOFT:0.000000 5,000225,000225,000354,834TOTAL MATERIALS & SERVICESCAPITAL OUTLAY10,000 80707-02EQUIP-HARD/SOFT-ERPAcquisition of new Enterprise Resource Planning (ERP) Financial Software.225,000 Software system and server hardwareBudget Note: Financial System - Enterprise Resource Planning (ERP) Project consultant to assist Citywith implementation services and contract assurance issues budgeted in ERP Consultant, Account#62-16-80611-02.000 80707-03EQUIP-HARD/SOFT-POLICE0.0000014,09200 80707-04EQUIP-HARD/SOFT-MUNICIPAL CT0.00000000 80707-05EQUIP-HARD/SOFT-ENGINEERING0.00000000 80707-07EQUIP-HARD/SOFT-LIBRARY0.00000000 80707-09EQUIP-HARD/SOFT-BUILDING0.00000000 80707-11EQUIP-HARD/SOFT-PLANNING0.00000000 80707-13EQUIP-HARD/SOFT-FIRE0.00000000 80707-15EQUIP-HARD/SOFT-PARKS ADMIN0.00000000 80707-17EQUIP-HARD/SOFT-AQUATIC CTR0.00000City of McMinnville Budget Supplement - AdoptedPage 195
INTERNAL INFORMATION 3-04ACTUAL2004-05000 80707-19EQUIP-HARD/SOFT-COMMUNITY CTR0.00000000 80707-23EQUIP-HARD/SOFT-PARK MAINT0.00000000 80707-25EQUIP-HARD/SOFT-STREETS0.00000000 80707-27EQUIP-HARD/SOFT-WRF0.00000000 80707-29EQUIP-HARD/SOFT-SEWER MAINT0.00000000 ,825924,825924,807City of McMinnville Budget Supplement - AdoptedNUMBER OFEMPLOYEESTOTAL CAPITAL OUTLAYTOTAL REQUIREMENTSPage 196PROPOSED2006-07APPROVED2006-07ADOPTED2006-07
600 Scriptlogic Desktop authority maintenance 2,666 Visionfire, Papervision, Paperflow maintenance 1,010 909 1,700 80637-00 FACILITY SERVICES 0.00 2,000 2,000 2,000 Electrical wiring expansion for IS offices. 0 0 0 80680-00 M&S ASSETS: 0.00 0 0 0 Materials & Supplies Asset purchases, with va
