97-895Presented By:
Referred To:
��e-,��� I (�7
� l�
�
Council Fiie # �� — g
Green Sheet # �
��
Committee: Date
1 WHEREAS, Council File 97-278 approved an appropriation for the acquisition and design of the software application
2 and implementation plan for an integrated Human Resource, Payroli and Benefit Administration system; and
3
4 WHEREAS, accounting for such a project which requires tracking of related costs and alloca6ng these costs to
5 other Ci1y funds would be facilitated by recording these transactions in an Intemal Service Fund; and
6
7 WHEREAS, the Mayor pursuaM to Section 10.07.4 of the City Charter recommends the following changes to
8 the 1997 Budget;
9 Current Amended
10 TRANSFER FROM: Budget Change Budget
11 General Fund
12 Integrated HR/PR/BA Information System
13
14 GL - 001-01125-0219 Fees Other Professional Services 1,200,000 (1,200,000) 0
15 GL - 001-01125-0856 Computer Softwase 500,000 (500,000) 0
16
17 TRANSFER TO:
18 GL - 001-01125-0567 Advance to Internal Service Fund 0 1,700,000 1,700,000
19 1,700,000 0 1,700,000
20
21
22 FINANCING PLAN:
23 Integrated HR/PRlBA System
24 GL - 164-11100-6928 Advance from Generai Fund 0 1,700,000 1,700,000
25 0 0 0
26 0 1,700,000 1,700,000
27 SPENDING PLAN:
28 Integrated HRiPR/BA System
29 GL - 164-11100-0111 Full time Permanent 0 161,873 161,873
30 GL - 164-11100-0439 Fringe Benefits 0 45,436 45,436
31 GL - 164-11100-0219 Fees Other Professionai Svc 0 700,000 700,000
32 GL - 164-11100-0222 Telephone Service 0 1,584 1,584
33 GL - 164-11100-0282 Rental - Office Space 0 14,700 14,700
34 GL -164-11100-0286 Rental - Furniture 0 10,560 10,560
35 GL - 164-11100-0284 Rental - Computers 0 25,449 25,449
36 GL -164-11100-0251 Training 0 20,200 20,200
37 GL - 164-11100-0299 Other Misc Services 0 21,273 21,273
38 GL-164-11100-0814 TelephoneEquipment 0 1,800 1,800
39 GL - 164-11100-0818 Other Office Furniture 0 1,500 1,500
40 GL -164-11100-0856 Computer Software 0 612,375 612,375
41 GL - 164-11100-0$56 Computer Software 0 53,250 53,250
42 GL -164-11100-0857 Computer Hardware 0 30,000 30,000
43 0 1,700,000 1,700,000
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
�l`l - S95
66 RESOLVED, that the City Council approves these changes to the 1997 budget, transferring the budgeted
67 appropriation from the General Fund to an Internal Service Fund and the creation of a new Internal Service Fund
68
69
70
71
72
budget of $ 1.7 million to fund the acquisition and design of the software application and implementation plan.
The advance from the General Fund will be repaid beginning in 1998 over a ten (10) year period by allocating
the necessary costs to department budgets.
BY� � �____ � � �_�
—�
Approved by Mayor: Date 'a 1286t�'
BY� � D
Requested by Department of:
Technology and Management� ces
Br � �9 V �- U✓�A-�t'�
Approval Recommended by
Director of Financiai Services
�p�� " �'"` �Le�
Form App�ed by City
p�ed by Mayor for Submission Council:
By: `
Adopted by Council: Date �_
\
Adoption Certified by Council Secretary:
DEPAR'[MEKC/UFFICElCOUNCIL DA'[E AI[MTFD ` 1'� U� S
DepartrnentTechnologyandManagementServices 06-12-97 GREEN SHEEl' NO. 30213
COMACtPER50N&PHONE OI DFPAR'1'MENiDDtEGTOR �5 CfIYCOUNCII,
Kathy Stack 266-8818 �„ [� rnvnrrow+EV '� rnvc�wc �
MUSfBEONCOUNCll.AGtNDABY(DA'IE) � a2 BUDGEfDQtECTOR � FIN.&MGT.SERVICESDIX.
� MAYOR(ORASSLSTAN'n � FmmaslSavias-Amm�y {
TOTAL # OF SIGNATURE PAGES (CLIP ALL LOCATIONS FOR SIGNAT[JRE) �
wrnoNx�oESreo
Transfer the approved spending authority for the Integrated HR/PR/BA system from the General Fund to
an Tnternal Service Fund.
nFCOam�ownaus. n�mre<A)«e.yac� PERSONALSERVIC£ CON'LStACLS MUSf ANSWEB THE FOIdAWING QUESLIONS:
_PL4NNPlGCOhA9SS10N _CIVaSERVICECOhA45S10N 1.Hasthispeesodfum
cmco�ang _ YES NO
A_SGVP _ 2. Ha5 ttis person/fvm ever bee� a city employee?
olmucrCOUrtt YFS NO
scmeoa'rs WfnCeicuuc+cuoa�F,ctrve? 3. Does4tis peFOCJfum posuss a sl�R �tm�ally possssed by any curzeni rity employee?
YES NO
(Explain 911 ya enswers on separate sheet aod attach M green she¢t)
WIIIAi1NGPROHLEM, ISSUE, OPPORTUMN(tVho, Whar, Whea, Where, Why):
Council File 97-278 approved the acquisition and design of a Human Resource/PayrolUBenefits Administration system and
established that the General Fund will be repaid from internal city departments over a ten yeaz period. Establishing
an internal service fund will facilitate the collection of this repayment from other city funds which will utilize the system
and segregate the assets, liabilities, revenues and expenditures related to the acquisition of the system.
ADVANTe1GE$ R'APPAOVED.
Accounfing for the acquisition, design and repayment of the Integrated FIIt/PR/BA system will be in accordance
with govemmental accounting principals. , , -- � ,
���'�. �� „ , , �: ,7
5�;a'��'r_s d �y�
JUN 1 � 1997
� � � k:. : � �,.
DISADVANTAGBSIPAPPHOVED . I�' � � �� p +.� ���'C� �
None
DISADVAN7AGESOFNOTAPPROVED
An inefficient procedure will be used to account and repay the General Fund for the system.
. ��
�v�� �� � ��J��
rorw�.ni.�ou�ronrxnNSArnon_S 170000� cosrlxever�ueauncereo�cmaEO� �� �o
+�u�NCSOUace General Fund Acr��rrN�mmen GL -164-1 1 1 00
Fnwwcu� wE'ow.unox: �aiam�
Presented By:
Referred To:
��e-,��� I (�7
� l�
�
Council Fiie # �� — g
Green Sheet # �
��
Committee: Date
1 WHEREAS, Council File 97-278 approved an appropriation for the acquisition and design of the software application
2 and implementation plan for an integrated Human Resource, Payroli and Benefit Administration system; and
3
4 WHEREAS, accounting for such a project which requires tracking of related costs and alloca6ng these costs to
5 other Ci1y funds would be facilitated by recording these transactions in an Intemal Service Fund; and
6
7 WHEREAS, the Mayor pursuaM to Section 10.07.4 of the City Charter recommends the following changes to
8 the 1997 Budget;
9 Current Amended
10 TRANSFER FROM: Budget Change Budget
11 General Fund
12 Integrated HR/PR/BA Information System
13
14 GL - 001-01125-0219 Fees Other Professional Services 1,200,000 (1,200,000) 0
15 GL - 001-01125-0856 Computer Softwase 500,000 (500,000) 0
16
17 TRANSFER TO:
18 GL - 001-01125-0567 Advance to Internal Service Fund 0 1,700,000 1,700,000
19 1,700,000 0 1,700,000
20
21
22 FINANCING PLAN:
23 Integrated HR/PRlBA System
24 GL - 164-11100-6928 Advance from Generai Fund 0 1,700,000 1,700,000
25 0 0 0
26 0 1,700,000 1,700,000
27 SPENDING PLAN:
28 Integrated HRiPR/BA System
29 GL - 164-11100-0111 Full time Permanent 0 161,873 161,873
30 GL - 164-11100-0439 Fringe Benefits 0 45,436 45,436
31 GL - 164-11100-0219 Fees Other Professionai Svc 0 700,000 700,000
32 GL - 164-11100-0222 Telephone Service 0 1,584 1,584
33 GL - 164-11100-0282 Rental - Office Space 0 14,700 14,700
34 GL -164-11100-0286 Rental - Furniture 0 10,560 10,560
35 GL - 164-11100-0284 Rental - Computers 0 25,449 25,449
36 GL -164-11100-0251 Training 0 20,200 20,200
37 GL - 164-11100-0299 Other Misc Services 0 21,273 21,273
38 GL-164-11100-0814 TelephoneEquipment 0 1,800 1,800
39 GL - 164-11100-0818 Other Office Furniture 0 1,500 1,500
40 GL -164-11100-0856 Computer Software 0 612,375 612,375
41 GL - 164-11100-0$56 Computer Software 0 53,250 53,250
42 GL -164-11100-0857 Computer Hardware 0 30,000 30,000
43 0 1,700,000 1,700,000
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
�l`l - S95
66 RESOLVED, that the City Council approves these changes to the 1997 budget, transferring the budgeted
67 appropriation from the General Fund to an Internal Service Fund and the creation of a new Internal Service Fund
68
69
70
71
72
budget of $ 1.7 million to fund the acquisition and design of the software application and implementation plan.
The advance from the General Fund will be repaid beginning in 1998 over a ten (10) year period by allocating
the necessary costs to department budgets.
BY� � �____ � � �_�
—�
Approved by Mayor: Date 'a 1286t�'
BY� � D
Requested by Department of:
Technology and Management� ces
Br � �9 V �- U✓�A-�t'�
Approval Recommended by
Director of Financiai Services
�p�� " �'"` �Le�
Form App�ed by City
p�ed by Mayor for Submission Council:
By: `
Adopted by Council: Date �_
\
Adoption Certified by Council Secretary:
DEPAR'[MEKC/UFFICElCOUNCIL DA'[E AI[MTFD ` 1'� U� S
DepartrnentTechnologyandManagementServices 06-12-97 GREEN SHEEl' NO. 30213
COMACtPER50N&PHONE OI DFPAR'1'MENiDDtEGTOR �5 CfIYCOUNCII,
Kathy Stack 266-8818 �„ [� rnvnrrow+EV '� rnvc�wc �
MUSfBEONCOUNCll.AGtNDABY(DA'IE) � a2 BUDGEfDQtECTOR � FIN.&MGT.SERVICESDIX.
� MAYOR(ORASSLSTAN'n � FmmaslSavias-Amm�y {
TOTAL # OF SIGNATURE PAGES (CLIP ALL LOCATIONS FOR SIGNAT[JRE) �
wrnoNx�oESreo
Transfer the approved spending authority for the Integrated HR/PR/BA system from the General Fund to
an Tnternal Service Fund.
nFCOam�ownaus. n�mre<A)«e.yac� PERSONALSERVIC£ CON'LStACLS MUSf ANSWEB THE FOIdAWING QUESLIONS:
_PL4NNPlGCOhA9SS10N _CIVaSERVICECOhA45S10N 1.Hasthispeesodfum
cmco�ang _ YES NO
A_SGVP _ 2. Ha5 ttis person/fvm ever bee� a city employee?
olmucrCOUrtt YFS NO
scmeoa'rs WfnCeicuuc+cuoa�F,ctrve? 3. Does4tis peFOCJfum posuss a sl�R �tm�ally possssed by any curzeni rity employee?
YES NO
(Explain 911 ya enswers on separate sheet aod attach M green she¢t)
WIIIAi1NGPROHLEM, ISSUE, OPPORTUMN(tVho, Whar, Whea, Where, Why):
Council File 97-278 approved the acquisition and design of a Human Resource/PayrolUBenefits Administration system and
established that the General Fund will be repaid from internal city departments over a ten yeaz period. Establishing
an internal service fund will facilitate the collection of this repayment from other city funds which will utilize the system
and segregate the assets, liabilities, revenues and expenditures related to the acquisition of the system.
ADVANTe1GE$ R'APPAOVED.
Accounfing for the acquisition, design and repayment of the Integrated FIIt/PR/BA system will be in accordance
with govemmental accounting principals. , , -- � ,
���'�. �� „ , , �: ,7
5�;a'��'r_s d �y�
JUN 1 � 1997
� � � k:. : � �,.
DISADVANTAGBSIPAPPHOVED . I�' � � �� p +.� ���'C� �
None
DISADVAN7AGESOFNOTAPPROVED
An inefficient procedure will be used to account and repay the General Fund for the system.
. ��
�v�� �� � ��J��
rorw�.ni.�ou�ronrxnNSArnon_S 170000� cosrlxever�ueauncereo�cmaEO� �� �o
+�u�NCSOUace General Fund Acr��rrN�mmen GL -164-1 1 1 00
Fnwwcu� wE'ow.unox: �aiam�
Presented By:
Referred To:
��e-,��� I (�7
� l�
�
Council Fiie # �� — g
Green Sheet # �
��
Committee: Date
1 WHEREAS, Council File 97-278 approved an appropriation for the acquisition and design of the software application
2 and implementation plan for an integrated Human Resource, Payroli and Benefit Administration system; and
3
4 WHEREAS, accounting for such a project which requires tracking of related costs and alloca6ng these costs to
5 other Ci1y funds would be facilitated by recording these transactions in an Intemal Service Fund; and
6
7 WHEREAS, the Mayor pursuaM to Section 10.07.4 of the City Charter recommends the following changes to
8 the 1997 Budget;
9 Current Amended
10 TRANSFER FROM: Budget Change Budget
11 General Fund
12 Integrated HR/PR/BA Information System
13
14 GL - 001-01125-0219 Fees Other Professional Services 1,200,000 (1,200,000) 0
15 GL - 001-01125-0856 Computer Softwase 500,000 (500,000) 0
16
17 TRANSFER TO:
18 GL - 001-01125-0567 Advance to Internal Service Fund 0 1,700,000 1,700,000
19 1,700,000 0 1,700,000
20
21
22 FINANCING PLAN:
23 Integrated HR/PRlBA System
24 GL - 164-11100-6928 Advance from Generai Fund 0 1,700,000 1,700,000
25 0 0 0
26 0 1,700,000 1,700,000
27 SPENDING PLAN:
28 Integrated HRiPR/BA System
29 GL - 164-11100-0111 Full time Permanent 0 161,873 161,873
30 GL - 164-11100-0439 Fringe Benefits 0 45,436 45,436
31 GL - 164-11100-0219 Fees Other Professionai Svc 0 700,000 700,000
32 GL - 164-11100-0222 Telephone Service 0 1,584 1,584
33 GL - 164-11100-0282 Rental - Office Space 0 14,700 14,700
34 GL -164-11100-0286 Rental - Furniture 0 10,560 10,560
35 GL - 164-11100-0284 Rental - Computers 0 25,449 25,449
36 GL -164-11100-0251 Training 0 20,200 20,200
37 GL - 164-11100-0299 Other Misc Services 0 21,273 21,273
38 GL-164-11100-0814 TelephoneEquipment 0 1,800 1,800
39 GL - 164-11100-0818 Other Office Furniture 0 1,500 1,500
40 GL -164-11100-0856 Computer Software 0 612,375 612,375
41 GL - 164-11100-0$56 Computer Software 0 53,250 53,250
42 GL -164-11100-0857 Computer Hardware 0 30,000 30,000
43 0 1,700,000 1,700,000
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
�l`l - S95
66 RESOLVED, that the City Council approves these changes to the 1997 budget, transferring the budgeted
67 appropriation from the General Fund to an Internal Service Fund and the creation of a new Internal Service Fund
68
69
70
71
72
budget of $ 1.7 million to fund the acquisition and design of the software application and implementation plan.
The advance from the General Fund will be repaid beginning in 1998 over a ten (10) year period by allocating
the necessary costs to department budgets.
BY� � �____ � � �_�
—�
Approved by Mayor: Date 'a 1286t�'
BY� � D
Requested by Department of:
Technology and Management� ces
Br � �9 V �- U✓�A-�t'�
Approval Recommended by
Director of Financiai Services
�p�� " �'"` �Le�
Form App�ed by City
p�ed by Mayor for Submission Council:
By: `
Adopted by Council: Date �_
\
Adoption Certified by Council Secretary:
DEPAR'[MEKC/UFFICElCOUNCIL DA'[E AI[MTFD ` 1'� U� S
DepartrnentTechnologyandManagementServices 06-12-97 GREEN SHEEl' NO. 30213
COMACtPER50N&PHONE OI DFPAR'1'MENiDDtEGTOR �5 CfIYCOUNCII,
Kathy Stack 266-8818 �„ [� rnvnrrow+EV '� rnvc�wc �
MUSfBEONCOUNCll.AGtNDABY(DA'IE) � a2 BUDGEfDQtECTOR � FIN.&MGT.SERVICESDIX.
� MAYOR(ORASSLSTAN'n � FmmaslSavias-Amm�y {
TOTAL # OF SIGNATURE PAGES (CLIP ALL LOCATIONS FOR SIGNAT[JRE) �
wrnoNx�oESreo
Transfer the approved spending authority for the Integrated HR/PR/BA system from the General Fund to
an Tnternal Service Fund.
nFCOam�ownaus. n�mre<A)«e.yac� PERSONALSERVIC£ CON'LStACLS MUSf ANSWEB THE FOIdAWING QUESLIONS:
_PL4NNPlGCOhA9SS10N _CIVaSERVICECOhA45S10N 1.Hasthispeesodfum
cmco�ang _ YES NO
A_SGVP _ 2. Ha5 ttis person/fvm ever bee� a city employee?
olmucrCOUrtt YFS NO
scmeoa'rs WfnCeicuuc+cuoa�F,ctrve? 3. Does4tis peFOCJfum posuss a sl�R �tm�ally possssed by any curzeni rity employee?
YES NO
(Explain 911 ya enswers on separate sheet aod attach M green she¢t)
WIIIAi1NGPROHLEM, ISSUE, OPPORTUMN(tVho, Whar, Whea, Where, Why):
Council File 97-278 approved the acquisition and design of a Human Resource/PayrolUBenefits Administration system and
established that the General Fund will be repaid from internal city departments over a ten yeaz period. Establishing
an internal service fund will facilitate the collection of this repayment from other city funds which will utilize the system
and segregate the assets, liabilities, revenues and expenditures related to the acquisition of the system.
ADVANTe1GE$ R'APPAOVED.
Accounfing for the acquisition, design and repayment of the Integrated FIIt/PR/BA system will be in accordance
with govemmental accounting principals. , , -- � ,
���'�. �� „ , , �: ,7
5�;a'��'r_s d �y�
JUN 1 � 1997
� � � k:. : � �,.
DISADVANTAGBSIPAPPHOVED . I�' � � �� p +.� ���'C� �
None
DISADVAN7AGESOFNOTAPPROVED
An inefficient procedure will be used to account and repay the General Fund for the system.
. ��
�v�� �� � ��J��
rorw�.ni.�ou�ronrxnNSArnon_S 170000� cosrlxever�ueauncereo�cmaEO� �� �o
+�u�NCSOUace General Fund Acr��rrN�mmen GL -164-1 1 1 00
Fnwwcu� wE'ow.unox: �aiam�