HomeMy WebLinkAboutResolutions - 2002.05.30 - 26923REPORT (MSC. 102115) May 30, 2002
BY: General Government Committee, William Patterson, Chairperson
IN RE: MR #02115 - DRAIN COMMISSIONER - UTILITY BILLING
INFORMATION SYSTEM IMPLEMENTATION - TRANSFER TO INFORMATION
TECHNOLOGY
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
The General Government Committee, having reviewed the above-
titled resolution on May 20, 2002, recommends that the resolution
be adopted.
Chairperson, on behalf of the General Government Committee, I
move acceptance of the foregoing report.
GENERAL GOVERNMENT COMMITTEE
GENERAL GOVERNMENT COMMITTEE VOTE:
Motion carried unanimously on a roll call vote with Taub and
McPherson absent.
•
May 2, 2002
MISCELLANEOUS RESOLUTION 102115
BY: PLANNING AND BUILDING COMMITTEE, CHARLES E. PALMER, CHAIRPERSON
IN RE: DRAIN COMMISSIONER - UTILITY BILLING INFORMATION SYSTEM
IMPLEMETATION - TRANSFER TO INFORMATION TECHNOLOGY
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
WHEREAS the Drain Commissioner's office provides water supply and
sewage disposal services for approximately 37,000 accounts in 17
communities within Oakland County; and
WHEREAS each of the communities in which the Drain Commissioner's
office provides service has an individualized approach to determining
water and sewer rates and level of service to residents; and
WHEREAS the Drain Commissioner's office has entered into a
contract with Harris Computer Systems for a new Utility Billing
Information System following the Oakland County Purchasing procedures;
and
WHEREAS the new Utility Billing Information System will provide a
substantial increase in functionality and reporting capabilities as
requested by the communities; and
WHEREAS the cost of the new system is approximately $808,633;
and
WHEREAS the $808,633 includes $557,263 to be paid directly from
the Water and Sewer Fund for the utility billing software and project
management services and $251,370 to be transferred to the Department of
Information Technology to cover server hardware, database and operating
system software, and implementation services; and
WHEREAS funds are available for transfer in the amount of
$251,370 from the Water and Sewer Fund to the Information Technology
Fund to cover the additional hardware, software, and implementation
services; and
WHEREAS annual maintenance and support costs will be incorporated
into the Water and Sewer Fund beginning in Fiscal Year 2002.
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of
Commissioners approves the purchase of additional hardware, software,
and implementation services for the Utility Billing Information System
implementation.
Chairperson, on behalf of the Planning and Building Committee, I
move the adoption of the foregoing resolution.
AND BULI,:a141G COMMITTEE
Planning & Building Committee Vote:
Motion carried on unanimous roll call vote with Webster absent
COUNTY MICHIGAN
DEPARTMENT OF INFORMATION TECHNOLOGY
L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE
Phillip R. Bertolini
Director
TO: Commissioner William Patterson, Chairperson
General Government Committee Members
FROM: Phillip R. Bertolini, Director
Department of Information Technology@
RE: Drain Commission Utility Billing System
DATE: May 15, 2002
CC: Kevin Larsen, Chief Deputy
Drain Commission
This memorandum has been prepared to express the Department of Information
Technology's support for the Drain Commission Utility Billing System. Information
Technology will provide the necessary technological support and resources for the
project if approved by the Board of Commissioners.
This system will provide increased functionality for the following communities:
Village of Bingham Farms,
City of Bloomfield Hills
Commerce Township
City of Farmington Hills
Village of Franklin
City of Keego Harbor
City of Orchard Lake
City of Royal Oak
Lyon Township
Oakland Township
White Lake Township
The Department of Information Technology is committed to providing quality service to
all County departments/divisions and is ready to assist the Drain Commission in the
successful implementation of the Utility Billing System. Thank you.
www.co.oakland.mi.us
BUILDING 49W • 1200 N TELEGRAPH RD DEPT 421 • PONTIAC MI 48341-0421 • (248) 858-0810 • FAX (248) 858-5130
Information
Revenues
3-18-636113-
1-18-636111-
Technology
10000-1701
10000-0717
Total
(636)
Transfer In 170,130
Non-Depart Oper 0
170,130
0
39,488
39,488
NANCE COMMITTEE
FINANCE COMMITTEE
Motion carried unanimously on a roll call vote with Friedman Appel and Melton sent.
FISCAL NOTE (MR #02115) May 30, 2002
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DRAIN COMMISSIONER - UTILITY BILLING INFORMATION SYSTEM IMPLEMENTATION -
TRANSFER TO INFORMATION TECHNOLOGY
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
Pursuant to Rule XII-C of this Board, the Finance Committee has reviewed the
above referenced resolution and finds:
1. The Drain Commissioner's Office provides water supply and sewage
disposal services for approximately 37,000 accounts in 17 communities
within Oakland County.
2. The Drain Commissioner has entered into a contract with Harris Computer
Systems for a new Utility Billing Information System.
3. The new billing system will provide a substantial increase in
functionality and reporting capabilities as requested by the user
communities.
4. Estimated total project cost of $867,745 includes $557,263 to be paid
directly from the Water and Sewer Fund and $170,130 to be transferred
to the Department of Information Technology to cover server hardware,
database and operating system software and implementation services.
5. The remaining project cost of $140,352 for development will be billed
through the quarterly billing process and is already included in
current budget.
6. Estimated operating costs for the Water and Sewer Fund and Information
Technology Fund (software and hardware maintenance) are incorporated in
the FY 2003 budget.
7. The following budget amendment is recommended for FY 2002 and FY 2003.
(701)
Water Sales
Water and Sewer Trust
Revenues
1-61-121318-21100-1119
Expenditures
2-61-227318-21100-3348
2-61-227318-21100-3597
2-61-227318-21100-3900
2-61-327318-21100-6636
3-61-311001-21100-8001
Total
FY 2002 FY 2003
251,830 159,908
Prof Services 81,700 0
Software Maint 57,650
Depreciation 0 62,770
IT Operations 0 39,488
Transfer Out 170,130 0
251,830 159,908
Expenditures
2-18-636142-15000-2776
2-18-636162-15000-3596
2-18-636162-15000-3597
2-18-636142-15000-3900
2-18-636142-15000-4101
2-18-636111-10000-8005
Total
Equip Repair & Maint 0 2,400
Software Purchase 50,601 0
Software Maint 0 12,496
Depreciation Exp 6,148 24,592
Expendable Equipment 2,530 0
Est Changes in Fund
Equity 110,851 0
170,130 39,488
Resolution #02115 May 2, 2002
The Chairperson referred the resolution to the Finance and General Government Committees. There
were no objections.
G. William Caddell, County Clerk
Resolution #02115 May 30, 2002
Moved by Palmer supported by Gregory the resolution be adopted.
Moved by Palmer supported by Gregory the General Government Committee Report be accepted.
A sufficient majority having voted therefore, the report was accepted.
Vote on resolution:
AYES: Garfield, Gregory, Law, McPherson, Melton, Middleton, Moffitt, Moss, Palmer, Patterson,
Sever, Suarez, Taub, Webster, Amos, Appel, Brian, Causey-Mitchell, Coleman, Crawford,
Dingeldey, Douglas, Galloway. (23)
NAYS: None. (0)
A sufficient majority having voted therefore, the resolution was adopted.
roQkttor IVecutive
THE FOREGOING RESOL VT'
Date
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, G. William Caddell, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true
and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on May 30, 2002,
with the original record thereof now remaining in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the County of Oakland at Pontiac,
Michigan this 30th day of May, 2002.