The URL can be used to link to this page

99-576QRlGiNA1. Presented By: Referred To: Committee: Date Whereas, it is gene2lty recognaetl that fhere is risk assaeiated with wmputers, computer rystems, and automated devices related M the change in tlate from the year 7999 W the year 2000, antl Whereas, celehmtian within Ne City of SaiM Paul at yeaz eM wnnected to the new miilenium will likely 6e ezten5ive, antl Whereas, directors, managers, antl employees of the City of Sai�rt Paul Nave been planning antl prepadng for the onwming of the "Y2K" probiem ior many months, and have reatlied themseNes in the areas of wmmunicaEOns, pu6licsafety, intemal remediatian, and wnGngenty planning, and Whereas, the Director ofthe Office af Financial Services hu prepared and implemented a process for soli<iting antl reviewing requests from tlepartmenfs for 6utlget monies associated with elemen5 of the Gty's Y2K Contingency Plan and the UKemal Remetliation Plan, antl Whereas, the staB of the Budget Section of Financiai 5ervices have analyzed the requestr and made recommendations, and the Director of Financial Services has faken positians on risk antl financial stantling, and made decisions on funding these requesis, and Whereas, the Director of FinanGial Services, at year entl 1998, designated a portion of the Cily's General Fund balanee as a resource tor funding needs linked to Y2K concems, and Whereas, the Mayoq pursuant to Section t0.a7A antl t0.07.4 of the Ciry Charter, does certify there is $843,764 in excess funds available for appropriatioq antl therefore, reeommends the following changes to the 1999 Atlopted Butlget for the Ciry of Saint Paul: CURRENTBUDGET Authocityto'Rewg�izeRecommended�EZCessFundsandlncreaseaDeparlmgntApproprwGOp .�,y., FINANCING PLAN Funtl ealances 00�-099005830 Desigrcatetl Fund Balance Generol Fund Net Change Bewuse af Amentlment SPENDlNG PLAN General Government-Y2K Contingency Planning antl Intemal Remediation 007-09900-014 Overtime 001-09900-0279 generai �epairs 001-09900-0289 fentals 007-09900-0297 tlaW proeess�ng servicC 007-09900-0299 001-09900-0353 001-09900-0359 001-08900-0438 001-09900-0833 001-09900-0848 001-09900-0851 001-09900-0856 Generol Fund Net Cha�ge Because of Amentlment Then, therePore, be k resoived, that the City Councii approves these changes to the �999 budget. CNANGES AMENOEDBUDGET ..... ... . �s: , ....ndil ::i:P� 643,764 843,764 893,764 0 0 0 0 0 a 0 0 0 0 0 0 0 217,366 4,200 N,525 257.788 75,000 12,680 63,911 33,350 748,782 9,752 600 74,812 843,784 117,366 4,200 t1,525 157,788 75,000 72,fi80 63,911 33,350 148,782 9,752 600 14,8t2 Requested by �epartment of: Technology & Management Service - on behalf of seve epartments and ffices BY� �il /�%l/!/ —. , Approval Recommended by Director of Financial Services Adopted by Council: D Adoption Certifi by Council Bv� _ 7.r'�'�� Approved by Council File # � r � l� 0 Green sheet # �p\�fa RESOLUTION C{TY OF SAINT PAUL, MINNESOTA ,� ey: Form By: Apprc By: h M— L CityAtt ey: ✓ ` � � for Submission to Council: B�f; � /-Li .v��j SairM1Pau1F50BWB�SeCqn( K1me G�,SHA0.ED�BUDGETWPFKES\Y2f:�C/deWRE5NM6 &�S193) Budget Requests - Y2K CITY COUNCIL no requests CITIZEN SERVICE OFFICE CSO systems - EXL problems FIRE AND SAFETY SERVICES Three 20KW POrfable Generators @ $15,933 Two 40KW Portable Generators @ $74,357 ZOKVJ Gene�aror Transfer Swi[ches �53,648 X 10 Stations 40K4V Gene2tor Transfer Slvdches @$4,475 X 8 SYations C of O Year 2000 Remediation G2rM Total Fre HOUSINGINFORMATION OFFICE no requests XUMAN RIGHTS Remediate ComplainUContracts Progrdms LIIBOR RELpT10N5 no requests LIEP no reAuests TEGHNOLOGY AND MANAGEMENT SERVICES Real Esfate Systems (EXL computer) Risk Data Bases (addRional funds �o approved projec[) PG for user access to assessment infortnation Emergency Power for Ciry Hall Annex Grend Totaf TMS PARKS AND RECREATION St2ff overtimB (optimisbcview) Staff ovehime (motlera[e view) Staff overtime (pessimistic view) Purchase 400 gallons of R-V antifreeze Rental of 250 CFM air compressor Tune up of gene2tors and heaters Connect cistem pumps to genereWr @ conservatory Reimburse purchase of DGpowered gas pumping systm Reimburse purchase of security�re alarm control panel Reimburse purchase of securilyffre alarm control panel Reimb. purch. of sftwr/hdwrforzoo/cons voicemail system Reimb. purch. of soRware for forestry office phone system Grand Totai Parks POLICE Operations Overtime - swom personnel 12/37 - 7/03 Helicopter Lease & OperaAOns - 100 Flight hours 1 month Communications Continuity generators misc for generators wntingency e�ectnaan cb and family radios extra battery packs for officers redios electriral for generators at the renge Booking / MaSS Artest Supplies Shields (ez[end capaGty to mul6ple civil disruptions) Misc Log�shcs- F�ceptional Gonsumption of Suppiies for nortnal police business flares, batteries, gloves, flashlghts, etc CIR7 (e�ctend capacity to multiple hi risk incidents) �� AmouMS 19946uAgstAmendme�rt 2000BUdget Decision Detail SubToWl Totai �ncemai Con6npeMy imema� Connngency Sfatus 25,000.00 47,800 47,800 28.702 28.702 36,480 36,480 35,800 35,800 50,000 50,000 50,000.00 198,782 is,oao is,000 is,000 �s,000.00 68,000.00 68,000.00 23.500.00 3,000 00 30,000 00 '124.500.00 Avg. 3,200 Avg 11,096 Avg. 51,890 7,300 369 3,000 1,200 1,427 2.744 1.139 2.587 4�48 50,395 4,650.00 5,000.00 � 930.00 6,688.00 599.96 9,400.00 1,200 00 6,659.00 999 78 23,490.65 48,5t6.o5 29,467.96 369,7620� 33,777.00 7.658 78 72,006.70 12,680 00 11,03000 3,000.00 1,200 00 47,800.00 28,702.00 36.480.00 35,800.00 75,000 00 4,650.00 5,000 00 599 96 9,400,00 48,St6.05 '12,680.00 pending approved approvetl approved approved pending pending approved denied denietl denied denied approvetl denied denied denietl approvetl approvetl denied denied denietl denied denied 294,762.00 approvetl denied approved approved denied pendin9 approvetl approved pending denietl tlenied tlenied approvetl approved G.�SHAREO�eUDGE1'�WPFILES\Y21(�Y2K COSTS.WK4 06/75/99 07:53 PM Budget Requests - Y2K Transportation RelmbursemeMSOr Personal 4x4 vehides Re�mbursement for Personal snowmobiles Portable'KOjaK Lights Portable Magnetic Shields Mounted Patrol - Tempo2ry Quarters & Winter Conditions House the horses with�n the city Training Cosis of Training Overtime to Swom Personnel Westem District Mobile Feld Force Incitlent Commantl Tactipl Commantl Gas Mask Refresher Eastem �istrict Mobile Field Force Day 1 Mobile FieW Force Day 2 Inddent Command Tactical Command Gas Mask Refresher Centrel Distnct notspecfied Desk O�cers IncidentCommand Tactical Command Gas Mask Refresher Downtown Beat Incident Commantl Gas Mask Refresher Remrds Umt (Rewvery After V2K) Impound Lot Snow Emergency antl Loss of Power Store Front Gene2tors antl Lights 16 remote pofice sites Total, Police Contingency Intemal Remediation Non Compliant Y2K Embedded Systems ECC Lanier Recorder Drug QuantitaSrve Mayzer Energy Mgmt System (HVAC) Computer Diagnoshc Software Audiometry Equipment Systems OveRime for Intemal De�eloped Systems Personel Infortnation System Communications Services antl Maintenance Fieltl Intetligence(SIU) NarcoUCS Unit applicfltions Intemal Affairs Unit appications Neigh6orhootl Assisfance offcers applications Reserve Police Unit applicaflons Que and Response, Distrct Council, Burglary FORCE Unit applications ALERT System Criminal History antl Booking T2ining Unit applications Juvenile Unit applicaUons Heatth arW Weltruss unit applications 700 hours soflware contractor time @$50 PC SoRware upgrades 7otal, PoGCe Intemal G2nd Total Police PED Tetepho�e equiptment at 2'15 E 9N Rewnte cost accounting system to move from EXL Grend Total PED G�-S�(o Amount5 19996utlgefAmentlmeM 2000BUtlgM D¢Cision DeWil SubTafal Total Inmmai Contincenry intemai Conu'gefu.y Sfatus 36,720.00 70,800.00 5,100.00 2,720.00 7.870.00 18,528.90 44,850.00 2,560.00 2,56o.0a 7.430.00 57,400.00 30,950.00 9.400.00 2,560.00 2,120.0a 6,190.00 51,220.00 35,729 10 1,804.50 2,464.00 1,904.00 6,068.00 47,96960 a00.00 1,234.00 2,034.00 158,623.6a 5,500 00 s,ais.00 7,870.00 758,623 60 tlenied 10,800.00 approved denied denied approved denied approved ' denied denied zzzoo.sa ae��ea 798,571.62 0.00 322,339.61 0 00 305,562 00 3,000.00 9,751.90 9,751.90 71,000.00 11,000.00 6,939.18 360.00 x x x x x x 1,044 00 8,884.00 5,16Q.00 861.80 3,658.00 5,370.00 5,2A5.00 1,566.00 4,076 50 '13,050.00 5,220.00 �.oaa.00 1,044 00 522.00 56,745.3� tlenied approvetl appmved denied tlenied 35,000 00 approvetl '10,751.78 3,872.00 pending 98,547.56 59,56390 0.00 0.00 0.00 897,119'18 59,563.90 322,33961 0.00 305,562.00 t2.000 12,040 16,000 '16,000 76,000.00 12,000.00 Compteted pending G:\SHARED\BUDGE"f�WPFILES\Y21C�V2K COSTS.WK4 06/75/99 01.53PM Budget Requests - Y2K PUBLIC LIBRARIES Energy Managemerrt Sys[em ai Central 8 Sun Ray Sewrity Card reader system for facilities Survey of HVAC equipment for compliarxz Central Library Elevarors G2nd Total Lib2ries PUBLIC WORKS Lighting Management System Sewer Pumping sfation Generator leases GeoerawrforShops All olher PW systems cansideretl Y2K compliant Grand Tofal Public Works RIVERCENTRE Consuttant services fa Y2K comptiance Software upgredes Soflware anNOr Engineering upgrades Grand ToWI RiverCentre WATER CONTINGENCY G.\SHARED�BUDGET�WPFILES\Y21(�Y2K_COSTS. WK4 �c� 5`l co Amounts '1999 Budget Amendme�rt 2000 Butlget Oecision Detail SubTotal Total Imemat Con6npenry Imemai Crnti�genry Status 5,000.00 5,000.0o approvetl 3,788.00 3,788.00 approveA 1,208.00 0.00 denietl mst unknown pending 9.996,00 40,000 40,000 40,000.00 725,000 725,000 t0a,000 700,000 265,000.00 4.5�0 4.W0 1,200 1,200 25,000 25,000 30,700.00 75,000 75,000.00 1.633.492 297.647.90 546,721.61 0 305,562 1998 7ofa1 843.763.51 approvetl approved penied apProved approved pending O6/t5/99 07:53PM DEPARTMENT/OFFICE/COUNCIL DATE INITIAiED �� (J Fiaancialservices 6/I5/99 GFCEEN 511EET NO. 61767 CONTACTPERSONffiPNONE ODEPARTMENTDIRECTOR 4OCfiVCOUNCIL JoeReid(266-8543) � z�annrroarvEr � sOcrrvc�ewc MWI6GUN4UUNGILAGtNUAGY(UAIt) � OU�KtOIUK,YINiWGULLJtKV10tJ �b' tJUACWOlNIIg 6/23/99 Or.uvoa�oRnss�sraNn b � TOTAL # OF SI6NATURE PAGES (CLIP ALL LOCATIONS FOR SIGNATURE) ACTION REQUESTED - Approval of the auached council resolution establishing a central 1999 budget for departruent and office Y2K remediation and planning. RECOMMENDATIONS:Approve(/ywRejec[(R) PERSONALSERVIGECOMRACiSMUSTANSWERTHEFOLLOWINGQUE5T10N5: (Ezplain all y¢s answ¢rs on s¢para[e sh¢et and atlaeh tn gr¢en sheet) PLANNIN6COMMISSION _ CMLSFRVICECOMMISSIO t.HasMisper.,aNfirtneverworketluntleraconhactforihistlepartment? CIBCOMMfREE _ YES NO � SiAFF _ 2. Has ihis persoNfirm ever baen a tlty employee? _ DI5TRICTCOURT _ YES NO SUPPORTS wHiCN CAUNCIL O&IECTIVE? 3. Dces ihis persoNfirm possess a skill not nomaly possessed by any a�rent dty employee? YES NO INITIATNE PROBLEM, ISSUE, OPPORTUNITY (Who, What, When, Where, The existence of the "Y2K" problem is common lmo�iedge. The staff of the City have done extensive work investigating the impact of this problem on the City's computers, computer systems, and other automated devices. Acting on advice, a plan for "internal remediation" has been prepazed. Costs for the needed conections have been estimated, and the capability to fit these into existing budgets has been explored. The FSO Director crafted a submission and review process to allow for the consideration of items that cannot fit into existing budgets. The Ciry staff have also prepazed "contingency plans" so that crirical city services can be provided at yeaz end 1999 and into the beginning of the year 2000 even under the risk of some loss of typically available support service or supplies, or in the event of extraordinary demands for service. Again, there is cost associated with this plan that cannot fit into exis6ng budge[s. All requests for additional funds were scrurinized; only those approved by the FSO Director appeaz on this resoludon. AOVANTAGESIFAPPROVED: Funding for the City's Y2K plans will be set into place. . DISADVANTAGES IFAPPROVED: Over $843,000 of the Ciry's designated fund balance will no longer be available. r : ,•r� DISADVANTAGESIFNOTAPPROVED: Y2K plans will have to be revised to fit within existing budgeted resources. JU�d 16 �� TOTALAMOUNTOFTRANSACTION $543�7�} COSLREVENUEBUDGETED(CIRCLEONE) YES O� FUNDING SOURCE General Fund AGTNffY NUMBER 09900 �� FINANCIAL INFORMqTION: (EXPLAIN) All items approved for inclusion in this request aze "one time" expenditures in nature, and, therefore, meet the test for the appropriate use of fund balances. QRlGiNA1. Presented By: Referred To: Committee: Date Whereas, it is gene2lty recognaetl that fhere is risk assaeiated with wmputers, computer rystems, and automated devices related M the change in tlate from the year 7999 W the year 2000, antl Whereas, celehmtian within Ne City of SaiM Paul at yeaz eM wnnected to the new miilenium will likely 6e ezten5ive, antl Whereas, directors, managers, antl employees of the City of Sai�rt Paul Nave been planning antl prepadng for the onwming of the "Y2K" probiem ior many months, and have reatlied themseNes in the areas of wmmunicaEOns, pu6licsafety, intemal remediatian, and wnGngenty planning, and Whereas, the Director ofthe Office af Financial Services hu prepared and implemented a process for soli<iting antl reviewing requests from tlepartmenfs for 6utlget monies associated with elemen5 of the Gty's Y2K Contingency Plan and the UKemal Remetliation Plan, antl Whereas, the staB of the Budget Section of Financiai 5ervices have analyzed the requestr and made recommendations, and the Director of Financial Services has faken positians on risk antl financial stantling, and made decisions on funding these requesis, and Whereas, the Director of FinanGial Services, at year entl 1998, designated a portion of the Cily's General Fund balanee as a resource tor funding needs linked to Y2K concems, and Whereas, the Mayoq pursuant to Section t0.a7A antl t0.07.4 of the Ciry Charter, does certify there is $843,764 in excess funds available for appropriatioq antl therefore, reeommends the following changes to the 1999 Atlopted Butlget for the Ciry of Saint Paul: CURRENTBUDGET Authocityto'Rewg�izeRecommended�EZCessFundsandlncreaseaDeparlmgntApproprwGOp .�,y., FINANCING PLAN Funtl ealances 00�-099005830 Desigrcatetl Fund Balance Generol Fund Net Change Bewuse af Amentlment SPENDlNG PLAN General Government-Y2K Contingency Planning antl Intemal Remediation 007-09900-014 Overtime 001-09900-0279 generai �epairs 001-09900-0289 fentals 007-09900-0297 tlaW proeess�ng servicC 007-09900-0299 001-09900-0353 001-09900-0359 001-08900-0438 001-09900-0833 001-09900-0848 001-09900-0851 001-09900-0856 Generol Fund Net Cha�ge Because of Amentlment Then, therePore, be k resoived, that the City Councii approves these changes to the �999 budget. CNANGES AMENOEDBUDGET ..... ... . �s: , ....ndil ::i:P� 643,764 843,764 893,764 0 0 0 0 0 a 0 0 0 0 0 0 0 217,366 4,200 N,525 257.788 75,000 12,680 63,911 33,350 748,782 9,752 600 74,812 843,784 117,366 4,200 t1,525 157,788 75,000 72,fi80 63,911 33,350 148,782 9,752 600 14,8t2 Requested by �epartment of: Technology & Management Service - on behalf of seve epartments and ffices BY� �il /�%l/!/ —. , Approval Recommended by Director of Financial Services Adopted by Council: D Adoption Certifi by Council Bv� _ 7.r'�'�� Approved by Council File # � r � l� 0 Green sheet # �p\�fa RESOLUTION C{TY OF SAINT PAUL, MINNESOTA ,� ey: Form By: Apprc By: h M— L CityAtt ey: ✓ ` � � for Submission to Council: B�f; � /-Li .v��j SairM1Pau1F50BWB�SeCqn( K1me G�,SHA0.ED�BUDGETWPFKES\Y2f:�C/deWRE5NM6 &�S193) Budget Requests - Y2K CITY COUNCIL no requests CITIZEN SERVICE OFFICE CSO systems - EXL problems FIRE AND SAFETY SERVICES Three 20KW POrfable Generators @ $15,933 Two 40KW Portable Generators @ $74,357 ZOKVJ Gene�aror Transfer Swi[ches �53,648 X 10 Stations 40K4V Gene2tor Transfer Slvdches @$4,475 X 8 SYations C of O Year 2000 Remediation G2rM Total Fre HOUSINGINFORMATION OFFICE no requests XUMAN RIGHTS Remediate ComplainUContracts Progrdms LIIBOR RELpT10N5 no requests LIEP no reAuests TEGHNOLOGY AND MANAGEMENT SERVICES Real Esfate Systems (EXL computer) Risk Data Bases (addRional funds �o approved projec[) PG for user access to assessment infortnation Emergency Power for Ciry Hall Annex Grend Totaf TMS PARKS AND RECREATION St2ff overtimB (optimisbcview) Staff ovehime (motlera[e view) Staff overtime (pessimistic view) Purchase 400 gallons of R-V antifreeze Rental of 250 CFM air compressor Tune up of gene2tors and heaters Connect cistem pumps to genereWr @ conservatory Reimburse purchase of DGpowered gas pumping systm Reimburse purchase of security�re alarm control panel Reimburse purchase of securilyffre alarm control panel Reimb. purch. of sftwr/hdwrforzoo/cons voicemail system Reimb. purch. of soRware for forestry office phone system Grand Totai Parks POLICE Operations Overtime - swom personnel 12/37 - 7/03 Helicopter Lease & OperaAOns - 100 Flight hours 1 month Communications Continuity generators misc for generators wntingency e�ectnaan cb and family radios extra battery packs for officers redios electriral for generators at the renge Booking / MaSS Artest Supplies Shields (ez[end capaGty to mul6ple civil disruptions) Misc Log�shcs- F�ceptional Gonsumption of Suppiies for nortnal police business flares, batteries, gloves, flashlghts, etc CIR7 (e�ctend capacity to multiple hi risk incidents) �� AmouMS 19946uAgstAmendme�rt 2000BUdget Decision Detail SubToWl Totai �ncemai Con6npeMy imema� Connngency Sfatus 25,000.00 47,800 47,800 28.702 28.702 36,480 36,480 35,800 35,800 50,000 50,000 50,000.00 198,782 is,oao is,000 is,000 �s,000.00 68,000.00 68,000.00 23.500.00 3,000 00 30,000 00 '124.500.00 Avg. 3,200 Avg 11,096 Avg. 51,890 7,300 369 3,000 1,200 1,427 2.744 1.139 2.587 4�48 50,395 4,650.00 5,000.00 � 930.00 6,688.00 599.96 9,400.00 1,200 00 6,659.00 999 78 23,490.65 48,5t6.o5 29,467.96 369,7620� 33,777.00 7.658 78 72,006.70 12,680 00 11,03000 3,000.00 1,200 00 47,800.00 28,702.00 36.480.00 35,800.00 75,000 00 4,650.00 5,000 00 599 96 9,400,00 48,St6.05 '12,680.00 pending approved approvetl approved approved pending pending approved denied denietl denied denied approvetl denied denied denietl approvetl approvetl denied denied denietl denied denied 294,762.00 approvetl denied approved approved denied pendin9 approvetl approved pending denietl tlenied tlenied approvetl approved G.�SHAREO�eUDGE1'�WPFILES\Y21(�Y2K COSTS.WK4 06/75/99 07:53 PM Budget Requests - Y2K Transportation RelmbursemeMSOr Personal 4x4 vehides Re�mbursement for Personal snowmobiles Portable'KOjaK Lights Portable Magnetic Shields Mounted Patrol - Tempo2ry Quarters & Winter Conditions House the horses with�n the city Training Cosis of Training Overtime to Swom Personnel Westem District Mobile Feld Force Incitlent Commantl Tactipl Commantl Gas Mask Refresher Eastem �istrict Mobile Field Force Day 1 Mobile FieW Force Day 2 Inddent Command Tactical Command Gas Mask Refresher Centrel Distnct notspecfied Desk O�cers IncidentCommand Tactical Command Gas Mask Refresher Downtown Beat Incident Commantl Gas Mask Refresher Remrds Umt (Rewvery After V2K) Impound Lot Snow Emergency antl Loss of Power Store Front Gene2tors antl Lights 16 remote pofice sites Total, Police Contingency Intemal Remediation Non Compliant Y2K Embedded Systems ECC Lanier Recorder Drug QuantitaSrve Mayzer Energy Mgmt System (HVAC) Computer Diagnoshc Software Audiometry Equipment Systems OveRime for Intemal De�eloped Systems Personel Infortnation System Communications Services antl Maintenance Fieltl Intetligence(SIU) NarcoUCS Unit applicfltions Intemal Affairs Unit appications Neigh6orhootl Assisfance offcers applications Reserve Police Unit applicaflons Que and Response, Distrct Council, Burglary FORCE Unit applications ALERT System Criminal History antl Booking T2ining Unit applications Juvenile Unit applicaUons Heatth arW Weltruss unit applications 700 hours soflware contractor time @$50 PC SoRware upgrades 7otal, PoGCe Intemal G2nd Total Police PED Tetepho�e equiptment at 2'15 E 9N Rewnte cost accounting system to move from EXL Grend Total PED G�-S�(o Amount5 19996utlgefAmentlmeM 2000BUtlgM D¢Cision DeWil SubTafal Total Inmmai Contincenry intemai Conu'gefu.y Sfatus 36,720.00 70,800.00 5,100.00 2,720.00 7.870.00 18,528.90 44,850.00 2,560.00 2,56o.0a 7.430.00 57,400.00 30,950.00 9.400.00 2,560.00 2,120.0a 6,190.00 51,220.00 35,729 10 1,804.50 2,464.00 1,904.00 6,068.00 47,96960 a00.00 1,234.00 2,034.00 158,623.6a 5,500 00 s,ais.00 7,870.00 758,623 60 tlenied 10,800.00 approved denied denied approved denied approved ' denied denied zzzoo.sa ae��ea 798,571.62 0.00 322,339.61 0 00 305,562 00 3,000.00 9,751.90 9,751.90 71,000.00 11,000.00 6,939.18 360.00 x x x x x x 1,044 00 8,884.00 5,16Q.00 861.80 3,658.00 5,370.00 5,2A5.00 1,566.00 4,076 50 '13,050.00 5,220.00 �.oaa.00 1,044 00 522.00 56,745.3� tlenied approvetl appmved denied tlenied 35,000 00 approvetl '10,751.78 3,872.00 pending 98,547.56 59,56390 0.00 0.00 0.00 897,119'18 59,563.90 322,33961 0.00 305,562.00 t2.000 12,040 16,000 '16,000 76,000.00 12,000.00 Compteted pending G:\SHARED\BUDGE"f�WPFILES\Y21C�V2K COSTS.WK4 06/75/99 01.53PM Budget Requests - Y2K PUBLIC LIBRARIES Energy Managemerrt Sys[em ai Central 8 Sun Ray Sewrity Card reader system for facilities Survey of HVAC equipment for compliarxz Central Library Elevarors G2nd Total Lib2ries PUBLIC WORKS Lighting Management System Sewer Pumping sfation Generator leases GeoerawrforShops All olher PW systems cansideretl Y2K compliant Grand Tofal Public Works RIVERCENTRE Consuttant services fa Y2K comptiance Software upgredes Soflware anNOr Engineering upgrades Grand ToWI RiverCentre WATER CONTINGENCY G.\SHARED�BUDGET�WPFILES\Y21(�Y2K_COSTS. WK4 �c� 5`l co Amounts '1999 Budget Amendme�rt 2000 Butlget Oecision Detail SubTotal Total Imemat Con6npenry Imemai Crnti�genry Status 5,000.00 5,000.0o approvetl 3,788.00 3,788.00 approveA 1,208.00 0.00 denietl mst unknown pending 9.996,00 40,000 40,000 40,000.00 725,000 725,000 t0a,000 700,000 265,000.00 4.5�0 4.W0 1,200 1,200 25,000 25,000 30,700.00 75,000 75,000.00 1.633.492 297.647.90 546,721.61 0 305,562 1998 7ofa1 843.763.51 approvetl approved penied apProved approved pending O6/t5/99 07:53PM DEPARTMENT/OFFICE/COUNCIL DATE INITIAiED �� (J Fiaancialservices 6/I5/99 GFCEEN 511EET NO. 61767 CONTACTPERSONffiPNONE ODEPARTMENTDIRECTOR 4OCfiVCOUNCIL JoeReid(266-8543) � z�annrroarvEr � sOcrrvc�ewc MWI6GUN4UUNGILAGtNUAGY(UAIt) � OU�KtOIUK,YINiWGULLJtKV10tJ �b' tJUACWOlNIIg 6/23/99 Or.uvoa�oRnss�sraNn b � TOTAL # OF SI6NATURE PAGES (CLIP ALL LOCATIONS FOR SIGNATURE) ACTION REQUESTED - Approval of the auached council resolution establishing a central 1999 budget for departruent and office Y2K remediation and planning. RECOMMENDATIONS:Approve(/ywRejec[(R) PERSONALSERVIGECOMRACiSMUSTANSWERTHEFOLLOWINGQUE5T10N5: (Ezplain all y¢s answ¢rs on s¢para[e sh¢et and atlaeh tn gr¢en sheet) PLANNIN6COMMISSION _ CMLSFRVICECOMMISSIO t.HasMisper.,aNfirtneverworketluntleraconhactforihistlepartment? CIBCOMMfREE _ YES NO � SiAFF _ 2. Has ihis persoNfirm ever baen a tlty employee? _ DI5TRICTCOURT _ YES NO SUPPORTS wHiCN CAUNCIL O&IECTIVE? 3. Dces ihis persoNfirm possess a skill not nomaly possessed by any a�rent dty employee? YES NO INITIATNE PROBLEM, ISSUE, OPPORTUNITY (Who, What, When, Where, The existence of the "Y2K" problem is common lmo�iedge. The staff of the City have done extensive work investigating the impact of this problem on the City's computers, computer systems, and other automated devices. Acting on advice, a plan for "internal remediation" has been prepazed. Costs for the needed conections have been estimated, and the capability to fit these into existing budgets has been explored. The FSO Director crafted a submission and review process to allow for the consideration of items that cannot fit into existing budgets. The Ciry staff have also prepazed "contingency plans" so that crirical city services can be provided at yeaz end 1999 and into the beginning of the year 2000 even under the risk of some loss of typically available support service or supplies, or in the event of extraordinary demands for service. Again, there is cost associated with this plan that cannot fit into exis6ng budge[s. All requests for additional funds were scrurinized; only those approved by the FSO Director appeaz on this resoludon. AOVANTAGESIFAPPROVED: Funding for the City's Y2K plans will be set into place. . DISADVANTAGES IFAPPROVED: Over $843,000 of the Ciry's designated fund balance will no longer be available. r : ,•r� DISADVANTAGESIFNOTAPPROVED: Y2K plans will have to be revised to fit within existing budgeted resources. JU�d 16 �� TOTALAMOUNTOFTRANSACTION $543�7�} COSLREVENUEBUDGETED(CIRCLEONE) YES O� FUNDING SOURCE General Fund AGTNffY NUMBER 09900 �� FINANCIAL INFORMqTION: (EXPLAIN) All items approved for inclusion in this request aze "one time" expenditures in nature, and, therefore, meet the test for the appropriate use of fund balances. QRlGiNA1. Presented By: Referred To: Committee: Date Whereas, it is gene2lty recognaetl that fhere is risk assaeiated with wmputers, computer rystems, and automated devices related M the change in tlate from the year 7999 W the year 2000, antl Whereas, celehmtian within Ne City of SaiM Paul at yeaz eM wnnected to the new miilenium will likely 6e ezten5ive, antl Whereas, directors, managers, antl employees of the City of Sai�rt Paul Nave been planning antl prepadng for the onwming of the "Y2K" probiem ior many months, and have reatlied themseNes in the areas of wmmunicaEOns, pu6licsafety, intemal remediatian, and wnGngenty planning, and Whereas, the Director ofthe Office af Financial Services hu prepared and implemented a process for soli<iting antl reviewing requests from tlepartmenfs for 6utlget monies associated with elemen5 of the Gty's Y2K Contingency Plan and the UKemal Remetliation Plan, antl Whereas, the staB of the Budget Section of Financiai 5ervices have analyzed the requestr and made recommendations, and the Director of Financial Services has faken positians on risk antl financial stantling, and made decisions on funding these requesis, and Whereas, the Director of FinanGial Services, at year entl 1998, designated a portion of the Cily's General Fund balanee as a resource tor funding needs linked to Y2K concems, and Whereas, the Mayoq pursuant to Section t0.a7A antl t0.07.4 of the Ciry Charter, does certify there is $843,764 in excess funds available for appropriatioq antl therefore, reeommends the following changes to the 1999 Atlopted Butlget for the Ciry of Saint Paul: CURRENTBUDGET Authocityto'Rewg�izeRecommended�EZCessFundsandlncreaseaDeparlmgntApproprwGOp .�,y., FINANCING PLAN Funtl ealances 00�-099005830 Desigrcatetl Fund Balance Generol Fund Net Change Bewuse af Amentlment SPENDlNG PLAN General Government-Y2K Contingency Planning antl Intemal Remediation 007-09900-014 Overtime 001-09900-0279 generai �epairs 001-09900-0289 fentals 007-09900-0297 tlaW proeess�ng servicC 007-09900-0299 001-09900-0353 001-09900-0359 001-08900-0438 001-09900-0833 001-09900-0848 001-09900-0851 001-09900-0856 Generol Fund Net Cha�ge Because of Amentlment Then, therePore, be k resoived, that the City Councii approves these changes to the �999 budget. CNANGES AMENOEDBUDGET ..... ... . �s: , ....ndil ::i:P� 643,764 843,764 893,764 0 0 0 0 0 a 0 0 0 0 0 0 0 217,366 4,200 N,525 257.788 75,000 12,680 63,911 33,350 748,782 9,752 600 74,812 843,784 117,366 4,200 t1,525 157,788 75,000 72,fi80 63,911 33,350 148,782 9,752 600 14,8t2 Requested by �epartment of: Technology & Management Service - on behalf of seve epartments and ffices BY� �il /�%l/!/ —. , Approval Recommended by Director of Financial Services Adopted by Council: D Adoption Certifi by Council Bv� _ 7.r'�'�� Approved by Council File # � r � l� 0 Green sheet # �p\�fa RESOLUTION C{TY OF SAINT PAUL, MINNESOTA ,� ey: Form By: Apprc By: h M— L CityAtt ey: ✓ ` � � for Submission to Council: B�f; � /-Li .v��j SairM1Pau1F50BWB�SeCqn( K1me G�,SHA0.ED�BUDGETWPFKES\Y2f:�C/deWRE5NM6 &�S193) Budget Requests - Y2K CITY COUNCIL no requests CITIZEN SERVICE OFFICE CSO systems - EXL problems FIRE AND SAFETY SERVICES Three 20KW POrfable Generators @ $15,933 Two 40KW Portable Generators @ $74,357 ZOKVJ Gene�aror Transfer Swi[ches �53,648 X 10 Stations 40K4V Gene2tor Transfer Slvdches @$4,475 X 8 SYations C of O Year 2000 Remediation G2rM Total Fre HOUSINGINFORMATION OFFICE no requests XUMAN RIGHTS Remediate ComplainUContracts Progrdms LIIBOR RELpT10N5 no requests LIEP no reAuests TEGHNOLOGY AND MANAGEMENT SERVICES Real Esfate Systems (EXL computer) Risk Data Bases (addRional funds �o approved projec[) PG for user access to assessment infortnation Emergency Power for Ciry Hall Annex Grend Totaf TMS PARKS AND RECREATION St2ff overtimB (optimisbcview) Staff ovehime (motlera[e view) Staff overtime (pessimistic view) Purchase 400 gallons of R-V antifreeze Rental of 250 CFM air compressor Tune up of gene2tors and heaters Connect cistem pumps to genereWr @ conservatory Reimburse purchase of DGpowered gas pumping systm Reimburse purchase of security�re alarm control panel Reimburse purchase of securilyffre alarm control panel Reimb. purch. of sftwr/hdwrforzoo/cons voicemail system Reimb. purch. of soRware for forestry office phone system Grand Totai Parks POLICE Operations Overtime - swom personnel 12/37 - 7/03 Helicopter Lease & OperaAOns - 100 Flight hours 1 month Communications Continuity generators misc for generators wntingency e�ectnaan cb and family radios extra battery packs for officers redios electriral for generators at the renge Booking / MaSS Artest Supplies Shields (ez[end capaGty to mul6ple civil disruptions) Misc Log�shcs- F�ceptional Gonsumption of Suppiies for nortnal police business flares, batteries, gloves, flashlghts, etc CIR7 (e�ctend capacity to multiple hi risk incidents) �� AmouMS 19946uAgstAmendme�rt 2000BUdget Decision Detail SubToWl Totai �ncemai Con6npeMy imema� Connngency Sfatus 25,000.00 47,800 47,800 28.702 28.702 36,480 36,480 35,800 35,800 50,000 50,000 50,000.00 198,782 is,oao is,000 is,000 �s,000.00 68,000.00 68,000.00 23.500.00 3,000 00 30,000 00 '124.500.00 Avg. 3,200 Avg 11,096 Avg. 51,890 7,300 369 3,000 1,200 1,427 2.744 1.139 2.587 4�48 50,395 4,650.00 5,000.00 � 930.00 6,688.00 599.96 9,400.00 1,200 00 6,659.00 999 78 23,490.65 48,5t6.o5 29,467.96 369,7620� 33,777.00 7.658 78 72,006.70 12,680 00 11,03000 3,000.00 1,200 00 47,800.00 28,702.00 36.480.00 35,800.00 75,000 00 4,650.00 5,000 00 599 96 9,400,00 48,St6.05 '12,680.00 pending approved approvetl approved approved pending pending approved denied denietl denied denied approvetl denied denied denietl approvetl approvetl denied denied denietl denied denied 294,762.00 approvetl denied approved approved denied pendin9 approvetl approved pending denietl tlenied tlenied approvetl approved G.�SHAREO�eUDGE1'�WPFILES\Y21(�Y2K COSTS.WK4 06/75/99 07:53 PM Budget Requests - Y2K Transportation RelmbursemeMSOr Personal 4x4 vehides Re�mbursement for Personal snowmobiles Portable'KOjaK Lights Portable Magnetic Shields Mounted Patrol - Tempo2ry Quarters & Winter Conditions House the horses with�n the city Training Cosis of Training Overtime to Swom Personnel Westem District Mobile Feld Force Incitlent Commantl Tactipl Commantl Gas Mask Refresher Eastem �istrict Mobile Field Force Day 1 Mobile FieW Force Day 2 Inddent Command Tactical Command Gas Mask Refresher Centrel Distnct notspecfied Desk O�cers IncidentCommand Tactical Command Gas Mask Refresher Downtown Beat Incident Commantl Gas Mask Refresher Remrds Umt (Rewvery After V2K) Impound Lot Snow Emergency antl Loss of Power Store Front Gene2tors antl Lights 16 remote pofice sites Total, Police Contingency Intemal Remediation Non Compliant Y2K Embedded Systems ECC Lanier Recorder Drug QuantitaSrve Mayzer Energy Mgmt System (HVAC) Computer Diagnoshc Software Audiometry Equipment Systems OveRime for Intemal De�eloped Systems Personel Infortnation System Communications Services antl Maintenance Fieltl Intetligence(SIU) NarcoUCS Unit applicfltions Intemal Affairs Unit appications Neigh6orhootl Assisfance offcers applications Reserve Police Unit applicaflons Que and Response, Distrct Council, Burglary FORCE Unit applications ALERT System Criminal History antl Booking T2ining Unit applications Juvenile Unit applicaUons Heatth arW Weltruss unit applications 700 hours soflware contractor time @$50 PC SoRware upgrades 7otal, PoGCe Intemal G2nd Total Police PED Tetepho�e equiptment at 2'15 E 9N Rewnte cost accounting system to move from EXL Grend Total PED G�-S�(o Amount5 19996utlgefAmentlmeM 2000BUtlgM D¢Cision DeWil SubTafal Total Inmmai Contincenry intemai Conu'gefu.y Sfatus 36,720.00 70,800.00 5,100.00 2,720.00 7.870.00 18,528.90 44,850.00 2,560.00 2,56o.0a 7.430.00 57,400.00 30,950.00 9.400.00 2,560.00 2,120.0a 6,190.00 51,220.00 35,729 10 1,804.50 2,464.00 1,904.00 6,068.00 47,96960 a00.00 1,234.00 2,034.00 158,623.6a 5,500 00 s,ais.00 7,870.00 758,623 60 tlenied 10,800.00 approved denied denied approved denied approved ' denied denied zzzoo.sa ae��ea 798,571.62 0.00 322,339.61 0 00 305,562 00 3,000.00 9,751.90 9,751.90 71,000.00 11,000.00 6,939.18 360.00 x x x x x x 1,044 00 8,884.00 5,16Q.00 861.80 3,658.00 5,370.00 5,2A5.00 1,566.00 4,076 50 '13,050.00 5,220.00 �.oaa.00 1,044 00 522.00 56,745.3� tlenied approvetl appmved denied tlenied 35,000 00 approvetl '10,751.78 3,872.00 pending 98,547.56 59,56390 0.00 0.00 0.00 897,119'18 59,563.90 322,33961 0.00 305,562.00 t2.000 12,040 16,000 '16,000 76,000.00 12,000.00 Compteted pending G:\SHARED\BUDGE"f�WPFILES\Y21C�V2K COSTS.WK4 06/75/99 01.53PM Budget Requests - Y2K PUBLIC LIBRARIES Energy Managemerrt Sys[em ai Central 8 Sun Ray Sewrity Card reader system for facilities Survey of HVAC equipment for compliarxz Central Library Elevarors G2nd Total Lib2ries PUBLIC WORKS Lighting Management System Sewer Pumping sfation Generator leases GeoerawrforShops All olher PW systems cansideretl Y2K compliant Grand Tofal Public Works RIVERCENTRE Consuttant services fa Y2K comptiance Software upgredes Soflware anNOr Engineering upgrades Grand ToWI RiverCentre WATER CONTINGENCY G.\SHARED�BUDGET�WPFILES\Y21(�Y2K_COSTS. WK4 �c� 5`l co Amounts '1999 Budget Amendme�rt 2000 Butlget Oecision Detail SubTotal Total Imemat Con6npenry Imemai Crnti�genry Status 5,000.00 5,000.0o approvetl 3,788.00 3,788.00 approveA 1,208.00 0.00 denietl mst unknown pending 9.996,00 40,000 40,000 40,000.00 725,000 725,000 t0a,000 700,000 265,000.00 4.5�0 4.W0 1,200 1,200 25,000 25,000 30,700.00 75,000 75,000.00 1.633.492 297.647.90 546,721.61 0 305,562 1998 7ofa1 843.763.51 approvetl approved penied apProved approved pending O6/t5/99 07:53PM DEPARTMENT/OFFICE/COUNCIL DATE INITIAiED �� (J Fiaancialservices 6/I5/99 GFCEEN 511EET NO. 61767 CONTACTPERSONffiPNONE ODEPARTMENTDIRECTOR 4OCfiVCOUNCIL JoeReid(266-8543) � z�annrroarvEr � sOcrrvc�ewc MWI6GUN4UUNGILAGtNUAGY(UAIt) � OU�KtOIUK,YINiWGULLJtKV10tJ �b' tJUACWOlNIIg 6/23/99 Or.uvoa�oRnss�sraNn b � TOTAL # OF SI6NATURE PAGES (CLIP ALL LOCATIONS FOR SIGNATURE) ACTION REQUESTED - Approval of the auached council resolution establishing a central 1999 budget for departruent and office Y2K remediation and planning. RECOMMENDATIONS:Approve(/ywRejec[(R) PERSONALSERVIGECOMRACiSMUSTANSWERTHEFOLLOWINGQUE5T10N5: (Ezplain all y¢s answ¢rs on s¢para[e sh¢et and atlaeh tn gr¢en sheet) PLANNIN6COMMISSION _ CMLSFRVICECOMMISSIO t.HasMisper.,aNfirtneverworketluntleraconhactforihistlepartment? CIBCOMMfREE _ YES NO � SiAFF _ 2. Has ihis persoNfirm ever baen a tlty employee? _ DI5TRICTCOURT _ YES NO SUPPORTS wHiCN CAUNCIL O&IECTIVE? 3. Dces ihis persoNfirm possess a skill not nomaly possessed by any a�rent dty employee? YES NO INITIATNE PROBLEM, ISSUE, OPPORTUNITY (Who, What, When, Where, The existence of the "Y2K" problem is common lmo�iedge. The staff of the City have done extensive work investigating the impact of this problem on the City's computers, computer systems, and other automated devices. Acting on advice, a plan for "internal remediation" has been prepazed. Costs for the needed conections have been estimated, and the capability to fit these into existing budgets has been explored. The FSO Director crafted a submission and review process to allow for the consideration of items that cannot fit into existing budgets. The Ciry staff have also prepazed "contingency plans" so that crirical city services can be provided at yeaz end 1999 and into the beginning of the year 2000 even under the risk of some loss of typically available support service or supplies, or in the event of extraordinary demands for service. Again, there is cost associated with this plan that cannot fit into exis6ng budge[s. All requests for additional funds were scrurinized; only those approved by the FSO Director appeaz on this resoludon. AOVANTAGESIFAPPROVED: Funding for the City's Y2K plans will be set into place. . DISADVANTAGES IFAPPROVED: Over $843,000 of the Ciry's designated fund balance will no longer be available. r : ,•r� DISADVANTAGESIFNOTAPPROVED: Y2K plans will have to be revised to fit within existing budgeted resources. JU�d 16 �� TOTALAMOUNTOFTRANSACTION $543�7�} COSLREVENUEBUDGETED(CIRCLEONE) YES O� FUNDING SOURCE General Fund AGTNffY NUMBER 09900 �� FINANCIAL INFORMqTION: (EXPLAIN) All items approved for inclusion in this request aze "one time" expenditures in nature, and, therefore, meet the test for the appropriate use of fund balances.