The URL can be used to link to this page

97-278. � �., a � � � " \� �� — 3 � � q l �{ � Council File # '� `� �` GreenSheet# __:� RESOLUTION C1TY OF S T PAUL, MI NESOTA � C� .J Preserked By: _ Referred To: Committee: Date i WHEREAS, the City's present HR, payroll and benefit systems are outdated and do not sufficiently z suppodthe City's presentaad future operations; and 3 a WHEREAS, the City has made a caretul review of aIl system replacement options and recommend s implementation of a packaged soRware applicafion with the assistance of a consultanUsystem integrator, and 6 7 e G�'��vY} 9 � GY�' J ia , , , � [f�l�mP�i� A��. V v ,i WHEREAS, the Mayor, pursuant to section 10.07.04 of the city charter, recommends the following changes to the �z 1997 budget: 13 ia Current Amended is Sudget Change Budget �s FINANCING PLAN: n ia GL 001-00000-9830 Use of Fund Balance 1,713,312 1,700,000 3,413,312 �s All Other Fund Financing 150,136,915 0 150,136,915 zo 151,850,227 1.700,000 153.550 227 zi SPENDING PLAN: zz Department of Technology and Management Services za Integrated Payroll/HR Information System za GL 001-01125-0219 Fees-ProfessionalServ+ces 0 1,2�Q��0 1,2��,0�� zs GL 001-01125 - 0856 Computer Software 0 500,000 500,000 zs Ali Other Fund Spending 151,850,227 0 151,850,227 2B �� ,� � �� 151.850,227 1.700,000 153,550 227 zs RESOLVED, that the City Councii approves this amendment to the 1997 budget in the amount of so $1.7 million to fund the acquisition and design of the software application and implementation plan, The advance from 3 � the general fund balance will be repaid beginning in 1998 over a ten(10) �ear period by 3z adding the necessary cost to the annual fringe rate applied to department budgets 33 FURTHER RESOLVED, that s ecific warrant � p y provisions and service �uarantees be included. Requested by Department of: Adoption Certified by Council Secretary: �� ApK L•� Technology and Manag ent r Se oices � i , g; i Approval Recommended by Budget Directcr: �.��t��- - Form A{��'dved by City to Council: � Adopted by Council: Date `��\q, \95� � — � �r' .�---�-"_ _. ._---.-- — - ` '^`" Q'l.—'1� Ci EPAPTrA M/OFFICElCAUNCiL DATE MIilA7ED p F � Techn�logy & Management Services �ibi9� GREEN SHEE N_ 30208 COMACTPE dPHONE �DEPAflTMEN�DIqE �CT'COUNCII INITIALTATE Mastha Larson 266-8797 nse�c� �cmnrroa'sEV �crzvc�,Eax NUMBERFOR M(IST BE ON COUNCIL AGENDA BY (DATE) p��Np O BUOGEf DIRECTOR O FlN. 8 MGT. SERVICES DIR. . ��P �MAVOP(ORASSISTAtlt) � drrniinty TOTAL # OP SIGNATURE PAGES (CLIP ALL LOCATIONS FOR SIGNATUREJ ACTION fiEQUESTED: Revision of budget for the initial design and purchase of software for Phase I o£ the human resources, payroll, benefits system. aECWAMENOn7roNS: Mproxe (A! � Reiect (R) pERSONAL SERVICE CONTRACTS MUST ANSW ER TXE FOLLOWING DUESTIONS: _ PLANNINCa CAMMfS$ION _ CIVIL SERVICE COMMISSION i. Has this per5on/firtn evar woAcetl under a contract for this department? � � _CIBGOMMITfEE _ YES NO � — �� F _ 2. Has ihis personfirm ever been a ciry empl0y¢e? YES NO _ Oi57RiCi cOURi _ 3. Oces this person/firm possess a skill nat nortnaUy possessetl by any current city empbyee? SUPPOFiTS WHICH CDUNCIL OBJEGTIVE? YES NO Explain al1 yes answero on seperote sheet antl ettech to green sheet MRIATM6 PqOBLEM. ISSUE, OPPORTUNiTY iWho. What• When. Where. Why): . Replacement of payroll sysCem which is old software running on an obsolete computer. ADVAMAGESIFAPPFlOVED: ' � Ineegrated payroll, human resources and benefits administration system. System will operate on current hardware and share a common database between these systems. The current request is for phase I of the project. Total cost estimate not to exceed $7 million. DISADVANTAGES IFAPPROVED: DISADVANTAGES IF NOTAPPROVED: Continue to operate' obsolete system - no shared database between systems. TOTAL AMOUNT OF TRANSACTION S 1� 7OO e OOO. OO COST/REVENUE BUDGETEp (CIHCLE ONE) YES � NO � FUNDI[iGSOURCE General Fund Balance pCTIVITYNUMBER 01125 FINANCIAL INFOFMATION: (EXPLAIN) q�-z�� INSERT A WHEREAS the Citv wishec to minimize the total cost of re�lacing its HR �ayroll and benefits administrafion systems and based on its best cunendy-available information esrimates that this total cost could range from �4 to $7 million• WHEREAS the City understande that he total co t of this new s��stem is greatly affecte-� by the City's willin�ness and abiliry to minimize modificarions to the softw re and accordin�ly make changes in its o�erarin�rulee and �rocesses• INSERT B RESOLVED the Citv Council directs staff to identify�ps ecific chan�es in Cit}� onerarin� rules and �rocesses that will allow the City to minimize significant software modifications and the total cost of this system implementarion: RESOLVED the City Council d'arects staff to design the new svstem �o that its total cost Qf implementation remains within the $4 million low-end esrimate and present any addifional o�tions to the Council which would reflect hi�her implementation costs for �dditional svstem modifications and functions; --. -.�� -- - --- 3'! �G..� �c�� \�.�`��2 - },� � <. �� Lc��c� ;;� - Y ._._ - - -.. _---� � q� -Z�18 �.-�--��s " _' ' _ _" '_ " _" _' _ __"_ '_" _ " � /J �_� � - _ _'__ _ _ '_ _ ' _ _ !/y'" _ _-"_-_' __ -- _��I��_�� _ _ L�� - ---- r ----- - - - -� - -- ---- - - - - - - ----- - � - � - ..� � : Ctie!��1-aw.-�e-� �e, �r.�.� - ------- ` - - U ' ;i�--- - - � - - ,. � .e-�-uQ b�. a, ------, �-- --- ,' �-n�.C-� a��.� �-e. , �, �t,�, -- --=�}---_. ' _ �'�-_ . . Ga� ,��u, mv�-<-.-e. Q �-a�e.� - - - - ''� -� d ,,�,._-� �`�`� ;:� _-- -- �-p-e a _ ,; �� _ ��. �, ��, --- ---�,� - - - - -�� c�cc.�g� � . _ ::� �� .c �`�Sc��S ��.�c�.�� . ��`�� Q�c\ _ �� _��►� ------ _�- _a,d�v��_ �� •a. .. ca-�� y _ � � � �: a �1 l. , ; I .. . � � �/ '� ,, t .. i �� t.. ► s � Q i, � y G��;�� '�CcS�'�S � � ��3�� STRIICE Tf� 3RD WE3EREAS IN EXISTING RESOLUTION AND INSERT TI� FOLLOWING: Whereas, the City wishes to minimize the total cost of replacing its HR, payroll and benefits administration systems, and based on its best currently-available information, estimates that this totai cost could range from $4 to $7 million; Whereas, the City understands that the total cost of this new system is geatiy aft'ected by the City's willingness and ability to muumize modifications to the software and, accordingly, make changes in its operating rules and processes; INSBRT Tf� FOLLOWING BEFORE TI-IE RESOLVED: Reso]ved, the City Council directs staff to identify specific changes in City operating rules and processes that will allow the City to minimize significant software modifications and the total cost of this system implementation; Resolved, the City Council directs staff to design the new system so that its total cost of implementation remains within the $4 million ]ow-end estimate, and present any additional opiions to the Council which would reflect higher implementation costs for additional system modifications and functions . � �., a � � � " \� �� — 3 � � q l �{ � Council File # '� `� �` GreenSheet# __:� RESOLUTION C1TY OF S T PAUL, MI NESOTA � C� .J Preserked By: _ Referred To: Committee: Date i WHEREAS, the City's present HR, payroll and benefit systems are outdated and do not sufficiently z suppodthe City's presentaad future operations; and 3 a WHEREAS, the City has made a caretul review of aIl system replacement options and recommend s implementation of a packaged soRware applicafion with the assistance of a consultanUsystem integrator, and 6 7 e G�'��vY} 9 � GY�' J ia , , , � [f�l�mP�i� A��. V v ,i WHEREAS, the Mayor, pursuant to section 10.07.04 of the city charter, recommends the following changes to the �z 1997 budget: 13 ia Current Amended is Sudget Change Budget �s FINANCING PLAN: n ia GL 001-00000-9830 Use of Fund Balance 1,713,312 1,700,000 3,413,312 �s All Other Fund Financing 150,136,915 0 150,136,915 zo 151,850,227 1.700,000 153.550 227 zi SPENDING PLAN: zz Department of Technology and Management Services za Integrated Payroll/HR Information System za GL 001-01125-0219 Fees-ProfessionalServ+ces 0 1,2�Q��0 1,2��,0�� zs GL 001-01125 - 0856 Computer Software 0 500,000 500,000 zs Ali Other Fund Spending 151,850,227 0 151,850,227 2B �� ,� � �� 151.850,227 1.700,000 153,550 227 zs RESOLVED, that the City Councii approves this amendment to the 1997 budget in the amount of so $1.7 million to fund the acquisition and design of the software application and implementation plan, The advance from 3 � the general fund balance will be repaid beginning in 1998 over a ten(10) �ear period by 3z adding the necessary cost to the annual fringe rate applied to department budgets 33 FURTHER RESOLVED, that s ecific warrant � p y provisions and service �uarantees be included. Requested by Department of: Adoption Certified by Council Secretary: �� ApK L•� Technology and Manag ent r Se oices � i , g; i Approval Recommended by Budget Directcr: �.��t��- - Form A{��'dved by City to Council: � Adopted by Council: Date `��\q, \95� � — � �r' .�---�-"_ _. ._---.-- — - ` '^`" Q'l.—'1� Ci EPAPTrA M/OFFICElCAUNCiL DATE MIilA7ED p F � Techn�logy & Management Services �ibi9� GREEN SHEE N_ 30208 COMACTPE dPHONE �DEPAflTMEN�DIqE �CT'COUNCII INITIALTATE Mastha Larson 266-8797 nse�c� �cmnrroa'sEV �crzvc�,Eax NUMBERFOR M(IST BE ON COUNCIL AGENDA BY (DATE) p��Np O BUOGEf DIRECTOR O FlN. 8 MGT. SERVICES DIR. . ��P �MAVOP(ORASSISTAtlt) � drrniinty TOTAL # OP SIGNATURE PAGES (CLIP ALL LOCATIONS FOR SIGNATUREJ ACTION fiEQUESTED: Revision of budget for the initial design and purchase of software for Phase I o£ the human resources, payroll, benefits system. aECWAMENOn7roNS: Mproxe (A! � Reiect (R) pERSONAL SERVICE CONTRACTS MUST ANSW ER TXE FOLLOWING DUESTIONS: _ PLANNINCa CAMMfS$ION _ CIVIL SERVICE COMMISSION i. Has this per5on/firtn evar woAcetl under a contract for this department? � � _CIBGOMMITfEE _ YES NO � — �� F _ 2. Has ihis personfirm ever been a ciry empl0y¢e? YES NO _ Oi57RiCi cOURi _ 3. Oces this person/firm possess a skill nat nortnaUy possessetl by any current city empbyee? SUPPOFiTS WHICH CDUNCIL OBJEGTIVE? YES NO Explain al1 yes answero on seperote sheet antl ettech to green sheet MRIATM6 PqOBLEM. ISSUE, OPPORTUNiTY iWho. What• When. Where. Why): . Replacement of payroll sysCem which is old software running on an obsolete computer. ADVAMAGESIFAPPFlOVED: ' � Ineegrated payroll, human resources and benefits administration system. System will operate on current hardware and share a common database between these systems. The current request is for phase I of the project. Total cost estimate not to exceed $7 million. DISADVANTAGES IFAPPROVED: DISADVANTAGES IF NOTAPPROVED: Continue to operate' obsolete system - no shared database between systems. TOTAL AMOUNT OF TRANSACTION S 1� 7OO e OOO. OO COST/REVENUE BUDGETEp (CIHCLE ONE) YES � NO � FUNDI[iGSOURCE General Fund Balance pCTIVITYNUMBER 01125 FINANCIAL INFOFMATION: (EXPLAIN) q�-z�� INSERT A WHEREAS the Citv wishec to minimize the total cost of re�lacing its HR �ayroll and benefits administrafion systems and based on its best cunendy-available information esrimates that this total cost could range from �4 to $7 million• WHEREAS the City understande that he total co t of this new s��stem is greatly affecte-� by the City's willin�ness and abiliry to minimize modificarions to the softw re and accordin�ly make changes in its o�erarin�rulee and �rocesses• INSERT B RESOLVED the Citv Council directs staff to identify�ps ecific chan�es in Cit}� onerarin� rules and �rocesses that will allow the City to minimize significant software modifications and the total cost of this system implementarion: RESOLVED the City Council d'arects staff to design the new svstem �o that its total cost Qf implementation remains within the $4 million low-end esrimate and present any addifional o�tions to the Council which would reflect hi�her implementation costs for �dditional svstem modifications and functions; --. -.�� -- - --- 3'! �G..� �c�� \�.�`��2 - },� � <. �� Lc��c� ;;� - Y ._._ - - -.. _---� � q� -Z�18 �.-�--��s " _' ' _ _" '_ " _" _' _ __"_ '_" _ " � /J �_� � - _ _'__ _ _ '_ _ ' _ _ !/y'" _ _-"_-_' __ -- _��I��_�� _ _ L�� - ---- r ----- - - - -� - -- ---- - - - - - - ----- - � - � - ..� � : Ctie!��1-aw.-�e-� �e, �r.�.� - ------- ` - - U ' ;i�--- - - � - - ,. � .e-�-uQ b�. a, ------, �-- --- ,' �-n�.C-� a��.� �-e. , �, �t,�, -- --=�}---_. ' _ �'�-_ . . Ga� ,��u, mv�-<-.-e. Q �-a�e.� - - - - ''� -� d ,,�,._-� �`�`� ;:� _-- -- �-p-e a _ ,; �� _ ��. �, ��, --- ---�,� - - - - -�� c�cc.�g� � . _ ::� �� .c �`�Sc��S ��.�c�.�� . ��`�� Q�c\ _ �� _��►� ------ _�- _a,d�v��_ �� •a. .. ca-�� y _ � � � �: a �1 l. , ; I .. . � � �/ '� ,, t .. i �� t.. ► s � Q i, � y G��;�� '�CcS�'�S � � ��3�� STRIICE Tf� 3RD WE3EREAS IN EXISTING RESOLUTION AND INSERT TI� FOLLOWING: Whereas, the City wishes to minimize the total cost of replacing its HR, payroll and benefits administration systems, and based on its best currently-available information, estimates that this totai cost could range from $4 to $7 million; Whereas, the City understands that the total cost of this new system is geatiy aft'ected by the City's willingness and ability to muumize modifications to the software and, accordingly, make changes in its operating rules and processes; INSBRT Tf� FOLLOWING BEFORE TI-IE RESOLVED: Reso]ved, the City Council directs staff to identify specific changes in City operating rules and processes that will allow the City to minimize significant software modifications and the total cost of this system implementation; Resolved, the City Council directs staff to design the new system so that its total cost of implementation remains within the $4 million ]ow-end estimate, and present any additional opiions to the Council which would reflect higher implementation costs for additional system modifications and functions . � �., a � � � " \� �� — 3 � � q l �{ � Council File # '� `� �` GreenSheet# __:� RESOLUTION C1TY OF S T PAUL, MI NESOTA � C� .J Preserked By: _ Referred To: Committee: Date i WHEREAS, the City's present HR, payroll and benefit systems are outdated and do not sufficiently z suppodthe City's presentaad future operations; and 3 a WHEREAS, the City has made a caretul review of aIl system replacement options and recommend s implementation of a packaged soRware applicafion with the assistance of a consultanUsystem integrator, and 6 7 e G�'��vY} 9 � GY�' J ia , , , � [f�l�mP�i� A��. V v ,i WHEREAS, the Mayor, pursuant to section 10.07.04 of the city charter, recommends the following changes to the �z 1997 budget: 13 ia Current Amended is Sudget Change Budget �s FINANCING PLAN: n ia GL 001-00000-9830 Use of Fund Balance 1,713,312 1,700,000 3,413,312 �s All Other Fund Financing 150,136,915 0 150,136,915 zo 151,850,227 1.700,000 153.550 227 zi SPENDING PLAN: zz Department of Technology and Management Services za Integrated Payroll/HR Information System za GL 001-01125-0219 Fees-ProfessionalServ+ces 0 1,2�Q��0 1,2��,0�� zs GL 001-01125 - 0856 Computer Software 0 500,000 500,000 zs Ali Other Fund Spending 151,850,227 0 151,850,227 2B �� ,� � �� 151.850,227 1.700,000 153,550 227 zs RESOLVED, that the City Councii approves this amendment to the 1997 budget in the amount of so $1.7 million to fund the acquisition and design of the software application and implementation plan, The advance from 3 � the general fund balance will be repaid beginning in 1998 over a ten(10) �ear period by 3z adding the necessary cost to the annual fringe rate applied to department budgets 33 FURTHER RESOLVED, that s ecific warrant � p y provisions and service �uarantees be included. Requested by Department of: Adoption Certified by Council Secretary: �� ApK L•� Technology and Manag ent r Se oices � i , g; i Approval Recommended by Budget Directcr: �.��t��- - Form A{��'dved by City to Council: � Adopted by Council: Date `��\q, \95� � — � �r' .�---�-"_ _. ._---.-- — - ` '^`" Q'l.—'1� Ci EPAPTrA M/OFFICElCAUNCiL DATE MIilA7ED p F � Techn�logy & Management Services �ibi9� GREEN SHEE N_ 30208 COMACTPE dPHONE �DEPAflTMEN�DIqE �CT'COUNCII INITIALTATE Mastha Larson 266-8797 nse�c� �cmnrroa'sEV �crzvc�,Eax NUMBERFOR M(IST BE ON COUNCIL AGENDA BY (DATE) p��Np O BUOGEf DIRECTOR O FlN. 8 MGT. SERVICES DIR. . ��P �MAVOP(ORASSISTAtlt) � drrniinty TOTAL # OP SIGNATURE PAGES (CLIP ALL LOCATIONS FOR SIGNATUREJ ACTION fiEQUESTED: Revision of budget for the initial design and purchase of software for Phase I o£ the human resources, payroll, benefits system. aECWAMENOn7roNS: Mproxe (A! � Reiect (R) pERSONAL SERVICE CONTRACTS MUST ANSW ER TXE FOLLOWING DUESTIONS: _ PLANNINCa CAMMfS$ION _ CIVIL SERVICE COMMISSION i. Has this per5on/firtn evar woAcetl under a contract for this department? � � _CIBGOMMITfEE _ YES NO � — �� F _ 2. Has ihis personfirm ever been a ciry empl0y¢e? YES NO _ Oi57RiCi cOURi _ 3. Oces this person/firm possess a skill nat nortnaUy possessetl by any current city empbyee? SUPPOFiTS WHICH CDUNCIL OBJEGTIVE? YES NO Explain al1 yes answero on seperote sheet antl ettech to green sheet MRIATM6 PqOBLEM. ISSUE, OPPORTUNiTY iWho. What• When. Where. Why): . Replacement of payroll sysCem which is old software running on an obsolete computer. ADVAMAGESIFAPPFlOVED: ' � Ineegrated payroll, human resources and benefits administration system. System will operate on current hardware and share a common database between these systems. The current request is for phase I of the project. Total cost estimate not to exceed $7 million. DISADVANTAGES IFAPPROVED: DISADVANTAGES IF NOTAPPROVED: Continue to operate' obsolete system - no shared database between systems. TOTAL AMOUNT OF TRANSACTION S 1� 7OO e OOO. OO COST/REVENUE BUDGETEp (CIHCLE ONE) YES � NO � FUNDI[iGSOURCE General Fund Balance pCTIVITYNUMBER 01125 FINANCIAL INFOFMATION: (EXPLAIN) q�-z�� INSERT A WHEREAS the Citv wishec to minimize the total cost of re�lacing its HR �ayroll and benefits administrafion systems and based on its best cunendy-available information esrimates that this total cost could range from �4 to $7 million• WHEREAS the City understande that he total co t of this new s��stem is greatly affecte-� by the City's willin�ness and abiliry to minimize modificarions to the softw re and accordin�ly make changes in its o�erarin�rulee and �rocesses• INSERT B RESOLVED the Citv Council directs staff to identify�ps ecific chan�es in Cit}� onerarin� rules and �rocesses that will allow the City to minimize significant software modifications and the total cost of this system implementarion: RESOLVED the City Council d'arects staff to design the new svstem �o that its total cost Qf implementation remains within the $4 million low-end esrimate and present any addifional o�tions to the Council which would reflect hi�her implementation costs for �dditional svstem modifications and functions; --. -.�� -- - --- 3'! �G..� �c�� \�.�`��2 - },� � <. �� Lc��c� ;;� - Y ._._ - - -.. _---� � q� -Z�18 �.-�--��s " _' ' _ _" '_ " _" _' _ __"_ '_" _ " � /J �_� � - _ _'__ _ _ '_ _ ' _ _ !/y'" _ _-"_-_' __ -- _��I��_�� _ _ L�� - ---- r ----- - - - -� - -- ---- - - - - - - ----- - � - � - ..� � : Ctie!��1-aw.-�e-� �e, �r.�.� - ------- ` - - U ' ;i�--- - - � - - ,. � .e-�-uQ b�. a, ------, �-- --- ,' �-n�.C-� a��.� �-e. , �, �t,�, -- --=�}---_. ' _ �'�-_ . . Ga� ,��u, mv�-<-.-e. Q �-a�e.� - - - - ''� -� d ,,�,._-� �`�`� ;:� _-- -- �-p-e a _ ,; �� _ ��. �, ��, --- ---�,� - - - - -�� c�cc.�g� � . _ ::� �� .c �`�Sc��S ��.�c�.�� . ��`�� Q�c\ _ �� _��►� ------ _�- _a,d�v��_ �� •a. .. ca-�� y _ � � � �: a �1 l. , ; I .. . � � �/ '� ,, t .. i �� t.. ► s � Q i, � y G��;�� '�CcS�'�S � � ��3�� STRIICE Tf� 3RD WE3EREAS IN EXISTING RESOLUTION AND INSERT TI� FOLLOWING: Whereas, the City wishes to minimize the total cost of replacing its HR, payroll and benefits administration systems, and based on its best currently-available information, estimates that this totai cost could range from $4 to $7 million; Whereas, the City understands that the total cost of this new system is geatiy aft'ected by the City's willingness and ability to muumize modifications to the software and, accordingly, make changes in its operating rules and processes; INSBRT Tf� FOLLOWING BEFORE TI-IE RESOLVED: Reso]ved, the City Council directs staff to identify specific changes in City operating rules and processes that will allow the City to minimize significant software modifications and the total cost of this system implementation; Resolved, the City Council directs staff to design the new system so that its total cost of implementation remains within the $4 million ]ow-end estimate, and present any additional opiions to the Council which would reflect higher implementation costs for additional system modifications and functions