The URL can be used to link to this page

87-1326 WHITE - C�TV CLERK PINK - FINANCE G I TY OF SA I NT PA U L Council CANARV - OEPARTMENT BLUE - MAVOR File NO• � �� C uncil Resolution ,-- Presented By �//�� Referred To Committee: Date Out of Committee By Date W�.S, $8,000 was authorized in the 1987 Adc7pted Budget for Risk ar�d Employee Benefit Management Division's conversion of work�rs' compensation database computer 1ang uage to enable better identification of high loss so control/safety rograms can be desiqned ar�d for establishment of a cost allocation system for workers' co�ensa�ion aryd tort liability, ar�d WF�itFAS ��ing further justification those dollars were held i.n a General Government Pyccount called 'ln�ormation S�istems Develop�nent, ar�d Wf�REAS the activity managers of Information Systems & Develop�ent have reviewed and approved Risk ar�d �nployee Benefit Nianagement Division's objec�ives and expenditures, ar�d Wf�REAS, The Mayor, pursuant to Section 10.07.4 of the Ci� Charter dces rec�rmend follawing amerydments to sper�ding plans for the 1987 Gener Furxi B�get: Current Amerr7ed General Government Accounts Budget Changes Budget � �ecutive Administration General Government --_� ______ 09115 Information S�istems�Development 09115-0219 Fees-Other Professional Services 78,000 ' -8,000 70,000 09115 All ather S�eryding 61,550 0 61,550 139,550 �N-8,000 ~ 131,550 Finance & Management Services Department - Risk Management Services 01370 Risk Management Services 01370-0219 Fees-Other Professional Services 99,156 +3,218 102,374 01370-0275 Office Equip Maintenance Contract 0 +200 200 01370-0299 Other-Misc 8ervices 150 +10 160 01370-0361 Office Accessories 150 +60 210 01370-0369 Other-Office Supplies 150 +20 170 01370-0818 Other Furniture 0 +628 628 01370-0856 Data P�ocessing Software 0 +764 764 01370-0857 Data Processing Hardware 1,500 +3,100 4,60U 01370 Al1 Other Spending 47,128 +0 47,128 148,234 ��+8,000 156,234 I�T CHANGE 0 RESQLVID, That the City Council approves these changes to the 1987 budget. Approval R+ecomnended: � !:�'�� Budget ir tor COUNCILMEN Requested by Department of: Yeas DfeW Nays Nicosia � (n Favor F' � ' s De tment Rettman � � Scheibel Q' �e� __ Against BY �.�..��A wi�son Adopted by Council: Date SEP I � �957 Form Appro by Atto Certified Y�s- d� y ncil Se e BY By �` � 4 p7 Approved by Mayor for Submission ouncil A►pprov y Mavor. Da e — By _ s Plr'�°_�S?�� -�, � ,� �� _ _ � a° � ��'3�b � . N.° 010955 � Finance & Manaqement Sexv. DEPARTMENT : � - - - - - Ron Guilfoile CONTACT NA14E < 298-6240 PHONE � 8-11-87 DATE . ,� ASSIGN NIIMBER FOR ROIITING ORDEB: (See reverse side.) � Department Director 4 Mayor (or Assistant) _ Finance and Management SeYwices Director �,_ City Clerk � � Budget DiYector City Attorneq _ TOTAL NUM'BER OF SIGN�TURE PA,GES: �,_ (Clig all locations for signature.) W�iAT WILL BE ACHIEVED BY TAKING ACTION ON THE ATTACHED MATERIALS? (Purpose/Rationale) , A total qf $8,000 adopted 1987 budgeted spending which was placed in 09115-Snformat�:on Systems Development pending further project justification will be transferrPd tQ��& Managsaaent Service Dept's Itisk Management Serviaes Divisio��y, "'" - AUG i 81981 ��1 u� 2 0�g�� Q�� OF THE DIRECTOR �� ` ' REPARTMENT QF F71Vq�jCE �OSTIBENEFIT. BUDGETARY. AND PERSONNEL IMPA�f��XTED: �� M��MENT SERV��g The Activity Managers of Information Systems Denelopment(G. Blees, J. Connelly) have reviewed and appro'ved Risk Management Services project and budget to: convert the woxkers compensation database computer language to enable better identification of high loss so control/safety pros�rams can be designed to prevent injuries and clai.ms and to establish a cost al].ocation • system for worker� compensation ansi tort liability. FINANCI}�TG SOURCE AND BUDGET ACTIVITY NUMBER CHARGED OR CREDITFD: (Mayor's signature not raquired if under $10,000.) Total Amount of Transhction: $g,000.00 Activity Nwnber: 09115 to 013'�0 Funding Souras: Inter-department transfer General Fund appropriation RECEIV�D ATTACHMENTS: (List and number ali attachments.) l. Resolution AU G 1 J 1987 2. Murphy/Jeanetta memo: request for budget transfer 3. Blees-Connelly/Guilfoile memo: project ;ugt�f��at�on CITY ATT�I�NEY 4. Haltiner/GLiilfoile and Murphy/Guilfoile memos: projeet justif�cation and costs ADI�IINISTRATIVE PROCEDURES �es _No Rules, Regulations, Procedures, or Budget Amendment required? i'es _No If yes, are they or timetable attached? DEPARTMENT REVIEW CITY ATTORNEY REVIEW 1/Yes _i�► Council resolution required? Resolution required? ____Yes _No _Yes ti!�I� Insurance required? Insurance sufficient? _Yes No _Yes ��No Insurance attached? ' t :.J�!" ;l . r"°, � ,,,,` � . ;�0� ��-/�� 6 CITY OF SAINT PAUL INTERDEPARTMENTAL MEMORANDUM T0: Barb Jeanetta FROM: Leda Murphy�� DATE: August 5, 1987 RE: Budget Transfer Barb, per our conversation today I have attached memos pertaining to the transfer of $8,000 from 09115 to 01370. Please transfer the money to the following accounts: GL 001-01370-0275 - $ 200 0299 - 10 0361 - 60 0369 - 20 0818 - 628 0856 - 764 0857 - 3,100 0219 - 3,218 Total 8,000 Both Greg Blees and John Connelly have approved the transfer of funds. Thank you for your assistance. If you have any questions, please call me at X6240. :lm cc: Ron Guilfoile RECEIVED AUG 6 1987 BUDGET OFFICE - � � , � � �-��-�,�� . .0-� CITY OF SAINT PAUL INTERDEPARTMENTAL MEMORANDUM T0: Greg Blees John Connelly FROM: Ron J. Guilfoile DATE: June 17, 1987 ' RE: 09115 Budget . The 1987 budget includes $8,000 in 09115 for the Risk and Employee Benefit Management Division. The original purpose for these dollars was to purchase software programs and risk management information system consulting services. The objectives we wish to accomplish are: - Convert the workers' compensation information now in COBAL to Info so we can use available software programs and a personal computer to analyze the data so as to identify areas of high loss in order to design loss control/safety programs to reduce these losses. - To establish a cost allocation system for workers' compensation. - To establish a cost allocation system for tort liability. The cost allocation systems will provide the cost data by departments in these areas so we can hold departments more accountable for expenditures. This should be done for unemployment expenditures also, but I don' t know who is responsible for this item. We would be glad to do it. - To establish reserves which meet risk management standards for our self- funded programs in workers' compensation and tort liability in order to insure proper funding at a time of diminishing reserves and to display sound risk management financing mechanisms to our bond rating agencies. This was an important item to both Moody's and Standard and Poor's. - To update the needed reserves id�ntified in the consultants report on funding our retiree health benefits. The attached Haltiner to Guilfoile memorandum explains the need for the hardware, software, and personal service request. The attached Murphy to Guilfoile memorandum completely explains the system request and itemizes the cost. The total funds needed are $8,998.00. I am requesting use of the entire $8,000.00 in 09115 for the above purpose. The additional funds will be provided through the 1987 Risk Management budget (01370) . Some funds appropriated in the 01370 1987 budget for computer hardware, software, and furniture have been expended with the remaining funds to be used for the cost over $8,000 in the above mentioned area. • � . . . . . • - ' � . � ��y-/.�� • Greg Blees John Connelly , � Page Two _ June 17, 1987 The use of this money for the purposes outlined is essential if the Risk Management Division is to meet our 1987 and 1988 objectives as listed in our � budgets on Form A-1, Activity Performance Plan. Thank you for your consideration in this matter. RJG:lm Attachments cc: Greg Haupt Eugene Schiller . . � . . . . . . � ,� • . . � ��7-i.��k . ,��: CITY OF SAINT PAUL ` INTERDEPARTMENTAI MEMORANDUM T0: Ron J. Guilfoile FROM: Terry Haltiner "rN• DATE: June 4, 1987 RE: Request for a Personal Computer and Software My position as a Risk Analyst entails a great deal of computational work. To perform this work I need a personal computer (PC) , various software packages and a printer. I have worked with Leda to develop a list of things I need and the cost of obtaining them (see attached) . The PC I would like is the IBM Personal System II, Model S0. It is one of the new line of IBM micros and the software I want will be compatible with it. Also, in the future, if we decide to purchase any further software, it will most assuredly be IBM compatible. The Lotus 1-2-3 software will allow me to generate and manage reserves for our self-insurance programs, to allocate the cost of these programs back to the appropriate departments, and to forecast the effectiveness of various programs under a wide variety of scenarios. The Primelink software will allow me to download files from the mainframe to the PC. The Harvard Presentation graphics software will allow me to use graphs and charts when making presentations to the various decision-makers throughout the City. A new printer will not be necessary since I can move the Okidata from Leda's desk into my office. The total cost of this is $6,238. This is quite reasonable considering that an industry publication stated, "The cost of a PC will range fr.om $4,000 to $12,000. " I also intend to use an intern to assist in compiling all the data I will need to determine reserve levels. An intern costs approximately $5.75/hour and over a 12 week period would cost approximately $2,760. TH:lm Attachment . � , � , . . . _ � .. �. . � . � °c,,��i.�� , •y . Oj CITY OF SAINT PAUL INTERDEPARTMENTAI MEMORANDUM T0: Ron J. Guilfoile FROM: Leda Murphy� DATE: June 3, 1987 RE: Computer Equipment Costs The following page shows a list of all necessary computer equipment and prices. I have explained the items in greater detail below. The IBM PC XT (like I have) has become obsolete and is no longer available. The IBM Personal System II Model 50 is one of the new line of IBM micro computers, It has 20 meg of disk space, 1 meg of inemory and greater capability than the PC XT. The only drawback to the Personal System II is that it uses 3 1/2" disks, the software we use only comes on 5 1/4" disks, which will require us to purchase an external disk drive. The price of the PS II is fairly close to what an PC XT would have cost if it were available. The Lotus software will allow Terry to produce spreadsheets. The Primelink software will allow Terry access to the prime and give him the capability of downloading files, thus freeing up the Wyse terminal for another user. The Wyse terminal can moved to an intern's desk to allow an intern access to the prime and allow him/her to do word processing. The Harvard Presentation software is a graphics package that is compatible with Lotus. It is fairly simple to learn and will allow greater graphics capabilities than what is presently available with Lotus. The print spooler will allow users to share and select printers easily. The buffering system allows high-speed input from all computers, thus freeing the computer for other tasks. Any user can send information off to be printed through the spooler and continue working on his computer without waiting for printing to be completed. The spooler listed on the next page will allow any combination of printers and terminals; up to ten, to be connected. There is a smaller spooler available� with six ports, but I suggest we purchase the one with ten ports (only $200 difference) in case this Division acquires more staff and computers or printers in the future. Your Wyse terminal and the other Wyse terminal (to be located at an intern's desk) probably can also be connected to the spooler to allow easy printing of your E-Mail messages or any word processing material. Extra memory is available to raise the memory to 1 meg in the print spooler (only $249) . It probably isn't necessary to purchase it at this time if funds are limited, but it would be a nice feature to have if we find ourselves printing several large files or .if more staff are added to the Division. . I . . . . . � . _ , v ' . ' 0��7 /,��(� • Ron J. Guilfoile Page Two June 3, 1987 The Okidata printer can be moved into Terry's office to allow him better access, as well as free up some of my desk space. The printer will need a cover that reduces the noise, as well as a stand to set it on. The printer cover and stand listed below are from Inmac Computer Accessories catalog. It reduces noise up to 85X and comes with a built-in fan to allow the printer continuous operation without heat build-up. It also has plastic-lined paper slots to prevent paper �ams. The only other item listed below is a glare filter. This filter will reduce glare, eliminate static electricity, enhances data contrast and attenuates VLF emissions. . Computer, Etc. (Ameridata) IBM Personal System II Computer (Model SO) 2,373 Dual Async Adaptor 156 12" Color Monitor 480 External S 1/4" drive 24g Adaptor (drive) 45 Public Sector Software N/C Smart Care (Installation and 1 year on-site warranty) 200 Software DOS 3.3 (Ameridata) gp Lotus (Software First • contract) 314 Primelink (Prime) 60 Harvard Presentation Graphics (Software First - contract) 238 Print Spooler (Office Products of Minnesota) Baytech Print Master Spooler Model 710C 995 Extra memory 249 Surge Outlet 20 Printer Cover and Stand (Inmac) Printer stand for Okidata 179 Printer cover for Okidata • 429 Shipping (approximate) 92 Miscellaneous Items Glare Filter (Mark Mullin Sales) 70 The total cost of the above items is $6,238 :lm . I , . . . . • . . �r- �� _______________________________ AGENDA ITEMS =___—______--___________—________ IL1#: C245 ] DATE REC.: C08/21/87] AGEMDA DATE: C00/00/00] ITEM #: C ] SUBJECT: CTRANSFEa OF f8,000 TO RISK MANAGEMENT SERVICES LIVISIOM/ACTIVITY ] STAFF ASSIGNEL�: C �'`jJ� �°�•Z� ] SIG:C ]OUT—C ] TO CLERK:.L.A9�Oo-f4@] �,9�o L �l'� ORIGINATOR:CFINANCE & MAMAGEMENT SEF�VICES ] CONTACT:CRUM GUILFOILE ] ACTION:C 7 C ] ORD/RES #:C '7 FILELi:C00/00/00 ] LOC.:C ] * * � � � a� � � � � � � � � FILE IMFO: CRESOLUTION /MEMOS 7 C ] C ] ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ � �� j ...�t.,. ' �� _. . '' � 1';,�� LC1v�,'CfLi�9q�N ` M�s SCHErt�4L .�