03-1138Council File #
Presented By
Referred To
RESOLUTION
CITY OF SAINT PAUL, MINNESOTA
Green Sheet #
��
3�0� 3
Z3
Committee: Date
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
WHEREAS , The Mayor pursuant to Section 10.07.1 of the Charter of the
City of Saint Paul, does certify that there are available for
appropriation $1,271,038 in funds in excess of those estimated in the
2003 budget; and
WHEREAS , Council File 277510, dated October 1, 1981, did establish
certain Special Fund Policies; and
WHEREAS, The City's Public Works Department ("Public Works") and The
Board of Water Commissioners, Saint Paul Regional Water Services
("SPRWS") are each currently maintaining infrastructure records in a
variety of disparate automated and manual systems with little interface
to graphical mapping information; and
WHEREAS, Public Works and SPRWS are partnering to implement a
Computerized Maintenance Management System ("CMMS"); and
WHEREAS, a CMMS provides organizations with basic maintenance management
of their physical infrastructure such as work order and preventive
maintenance management, parts inventory, problem tracking and a complete
record of all activities completed on all assets; and �
WHEREAS, Public Works and SPRWS will achieve substantial cost savings by
jointly planning, purchasing and operating the CMMS in a manner agreeable
to both parties; and
WHEREAS, The Board of Water Commissioners, by it's resolution No. 4802,
dated November 13,2001, approved funding for a CMMS; and
WHEREAS, Public Works budgeted 2003 funding for CMMS implementation in
Council Contingency which was previously released by Council File 03-525;
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
03-��3�
and
WHEREAS
the implementation of the CMMS is currently underway; and
WHEREAS, the operation of a requires a data base of assets to be
created and maintained; and
WHEREAS, Public Works has a large number of existing records and data
bases, both paper and electronic which it plans to use as the source for
the CMMS asset data base; and
WHEREAS, Public Works has planned to fund the creation of the ChIMS asset
data base from fund balances; and
WHEREAS, Public Works has created and executed a Internal Cash Flow Loan
Agreement between the 225 "Street Repair and Cleaning Fund", the 230
"Parking Meter Collection & Fines fund", and the 240 "Traffic Signal
Lighting Maintenance" fund; and
WHEREAS, the terms of the loan agreement specify that the Street Fund
will loan the Traffic and Meter funds cash for their data conversion
needs, to be recovered over a 10 year payback term; and
WHEREAS, Public Works is ready to proceed with the creation of the asset
data base; and
WHEREAS, The Mayor recommends that the following changes be made to the
2003 budget
Financing Plan
225 Street Repair and Cleaning Fund
42310-9830 Fund Salance
All Other Financing the Same
Total Financing Plan
Spending Plan
225 Street Repair and Cleaning Fund
42310-0219 Other Professional Services
42310-0567 Transfer to Internal Service Fund
All Other Spending the Same
Total Spending Plan
Adopted Budget Change Revised Budget
$2,329,549$462,476 $2,792,025
$19,615,073 $0 $19,615,073
$21,944,622$462,476 $22,407,098
Adopted Budget Change Revised Budget
$10,500 $68,476 $78,976
$0$394,000 $393,177
$21,934,122 $0 $21,934,122
$21,944,622$462,476 $22,406,275
76
77
78
79
80
81
82
83
84
85
86
87
SS
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
ill
112
113
114
115
116
117
118
119
o�- ��3�
Financing Plan
260 Sewer Utility Fund
22207-9925 Retained Earnings
All Other Financing the Same
Total Financing Plan
Adopted Budget Change Revised Budget
$445,500$808,562 $1,254,062
$51,303,495 $0 $51,303,495
$51,748,995$808,562 $52,557,557
Spending Plan
260 Sewer Utility Fund
22207-0219 Other Professional Services
Al1 Other Spending the Same
Total Spending Plan
Adopted Budget Change Revised Budget
$0$808,562 $808,562
$51,748,995 $0 $51,748,995
$51,748,995$808,562 $52,557,557
Financing Plan
240 Traffic Signal Lighting Maintenance Adopted Buc
12005-7305 Transfer From Special Revenue Fund
12006-7305 Transfer From Special Revenue Fund
12007-7305 Transfer From Special Revenue Fund
12009-7305 Transfer From Special Revenue Fund
All Other Financing the Same $8,580,
Total Financing Plan $8,580,
Spending Plan
240 Traffic Signal Ligkting Maintenance
12005-0219 Other Professional Services
12006-0219 Other Professional Services
12007-0219 Other Professional Services
12009-0219 Other Professional Services
All Other Spending the Same
Total Spending Plan
Adopted
$8,580,
$8,580,
Change
308,21
$21,06
$36,22
$15,80
81,
Change
308,210
$21,060
$36,228
$15,807
$0
381,304
sed Budget
$308,210
$21,059
$36,228
$15,807
$8,580,716
$8,962,020
ised Budget
$308,210
$21,059
$36,228
$15,807
$8,580,716
$8,962,020
Financing Plan
230 Parking Meter Collection & Fines Adopted Budget Change Revised Budget
32212-7305 Transfer From Special Revenue Fund $0 $12,695 $12,695_
All Other Financing the Same $2,698,459 $0 $2,698,459
Total Financing Plan $2,698,459 $12,695 $2,711,154
Spending Plan
230 Parking MeteY Collection & Fines
32212-0219 Other Professional Services
All Other Spending the Same
Total Spending Plan
Adopted Budget Change Revised Budget
$0 $12,695 $12,695
$2,698,459 $0 $2,698,459
$2,698,459 $12,695 $2,711,154
.
��o
121 Now, therefore, be it RESOLVED, That the City Council adopts the above
122 changes to the 2003 budget.
03-1 l3`6
e
Yeas Nays Absent Requested by Department of:
Benanav ,/ P ks
Blakey ;/ �
Bostrom ,/
Coleman ✓ By:
Harris �
Lantry ✓ Approval Recommended by Office of
Rc�ter Llet e � Financial erv"ces Direc or:
-7 c c�
Adopted by Council: Date ��n"�`��3 �y:
Adoption Certified by Council Secretary Form Ap ro �ed by City Attorney:
� � - 9
By: By: . Lt i
Approved ayor: Date: � r ed by May for S ss' � ou
Ey:
� ��
�- � Green Sheet Green Sheet
�
�3' 3�
Green Sheet Green Sheet Green Sheet Green Sheet �
�>�
— �
Depar6nenUofficdcouncil: Date Initiated:
Pw -�bti�w�� 04-NOV-03 Green Sheet NO: 3007399
Confaet Person & Phone: ���t Sent To Person itiaVDate
Dan Barittolic � 0 blic Works � ��
266"6243 Assign 1 blicworks De tD'uector 7
Must Be on Council qq�da by (Date): Number 2 ,ro Att rnev
�'^� .23 0 a .
/ 3 Routing 3 or•s Office Ma or/Assistant
Order 4 0 �
5 i Clerk i Clerk
Total # of Signature Pages _(Ciip NI Lxations for Signature)
Action Requested:
Amend the 2003 budget to provide funding for the data conversion portion of the Public Works CMMS project.
Recommendations: Approve (A) or Reject (R): Personal Service Contracts Must Mswer the Following Questions:
Planning Commission 1. Has this person/firm ever worked under a contract for this departmenY?
CIB Committee Yes No
Civii Service Commission 2. Has this person/firm ever been a city employee?
Yes No
3. Does this persoNfirm possess a skill not norrnally possessed by any
current city employee?
Yes No
Explain all yes answers on separate sheet and attach to green sheet
Initiating Problem, Issues, Opportunity (Who, What, When, Where, Why):
Public Works, Parks & Recreauon - Forestry, and, St. Paul Regional Water ue currently implementing a Computerized Maintenance
Management System (CMMS) to better manage their respec6ve physical infrastructures. An integral part of CMMS is a database
containing records of all the physical asseu to be managed. This amendment arranges funding for the creafion of such a database.
Ativantages If Aparoved: � �� � � � � �
The CMMS project will have a database of assets to operate against.
Disadvantages If Approved: °�°°� g � }�
None ���� ¢� 1 5 �6"!�� T
Disadvantages If Not Approved:
The City is obligated by agreement with the Boazd of Water Commissioners to implement the CMMS system. If this amendment is not
approved, the Public Works portions of the CNIMS system will be useless as there wont be any data about the City's physical assets
for the system to use.
ToWI Amount of CosURevenue BudgMed:
Trensaction:
Fundin9souree: See Resolution ����riNumber. See Resolution��� ��'��'�?°� �y�'�
Financiallnformation: SeeResolution
(Explain) �C-� "� � �g��?�
d aJ