HomeMy WebLinkAboutResolutions - 2000.01.27 - 26005MISCELLANEOUS RESOLUTION #00003 January 27, 2000
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FIRST QUARTER 2000 DEVELOPMENT
APPROPRIATION TRANSFER
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
WHEREAS all data processing development cost is incorporated as a single
appropriation within the Department of Information Technology budget and then an
amount equal to the actual expense is transferred to the user department with a
summary report to the Finance Committee; and
WHEREAS the Department of Information Technology has determined the First
Quarter 2000 data processing development charges to be $1,182,143 and the imaging
development charge to be $106,022 for the governmental fund County departments;
and
WHEREAS direct charges to non-governmental fund departments are $54,546
and non-county agencies are $38,856 for the First Quarter 2000; and
WHEREAS an appropriation transfer to governmental fund county departments
is needed to fund these development charges.
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of
Commissioners has reviewed the First Quarter 2000 Data Processing Development and
approves the first quarter appropriation transfer.
Chairperson, on behalf of the Finance Committee, I move the adoption of
the foregoing resolution.
FINANCE COMMITTEE
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote with Millard absent.
'INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
1ST QUARTER 2000
1st aff 2nd Qtr 3rd Qtr 4th Qtr
ACCOUNT 0 DIVISION Oct - Dec Jan - Mar ,.or - June July - Sept Y T D
General Fund [1011
2-32-201200-20001-6030 52/1 District Court 16,869.67 0.00 0.00 0.00 16,869.67
2-32-301200-20001-6030 52/2 District Court 16,869.67 0.00 0.00 0.00 16,869.67
2-32-401200-20001-6030 52/3 District Court 16,869.67 0.00 0.00 0.00 16,869.67
2-32-501200-20001-6030 52/4 District Court 16,869.64 0.00 0.00 0.00 16,869.64
2-11-220100-10000-6030 Auditing 54.50 0.00 0.00 0.00 54.50
2-51-211000-10000-6030 Board of Commissioners - Adm. 27.25 0.00 0.00 0.00 27.25
2-31-101200-10001-6030 Circuit Court - Administration 58,849.75 0.00 0.00 0.00 58,849.75
2-21-220100-01000-6030 Clerk - Admin 168.00 0.00 0.00 0.00 168.00
2-21-230100-01000-6030 Clerk - Elections 61,495.20 0.00 0.00 0.00 61,495.20
2-21-250100-01000-6030 Clerk - Jury Commission 44,239.35 0.00 0.00 0.00 44,239.35
2-21-221000-01000-6030 Clerk - Legal Records 10,930.50 0.00 0.00 0.00 10,930.50
2-21-240100-01000-6030 Clerk - Register of Deeds 44,797.50 0.00 0.00 0.00 44,797.50
2-21-220500-01000-6030 Clerk - Vital Statistics 1,687.00 0.00 0.00 0.00 1,687.00
2-61-211001-10000-6030 Drain Commissioner 571.00 0.00 0.00 0.00 571.00
2-12-240000-44100-6030 Equalization Division 77,778.00 0.00 0.00 0.00 77,778.00
2-12-601200-10001-6030 Fiscal Services - Admin 123,018.05 0.00 0.00 0.00 123,018.05
2-12-621200-10001-6030 Fiscal Services - General 20,020.90 0.00 0.00 0.00 20,020.90
2-16-912000-15000-6030 Medical Examiner 27,718.50 0.00 0.00 0.00 27,718.50
2-17-501200-10001-6030 M.S.U. Extension-Oakland 54.50 0.00 0.00 0.00 54.50
2-1 5-402200-1 0001-6030 Personnel 38,886.30 0.00 0.00 0.00 38,886.30
2-19-221000-10000-6030 Planning & Economic Development 981.00 0.00 0.00 0.00 981.00
2-34-401200-40001-6030 Probate Court - Estates & Mental Health 13,472.00 0.00 0.00 0.00 13,472.00
2-34-101200-40001-6030 Probate Court - Juvenile 21,772.00 0.00 0.00 0.00 21,772.00
2-41-211000-10000-6030 Prosecuting Attorney 16,027.00 0.00 0.00 0.00 16,027.00
2-12-401200-40010-6030 Purchasing 1,491.00 0.00 0.00 0.00 1,491.00
2-12-701200-10001-6030 Reimbursement Division 13,890.00 0.00 0.00 0.00 13,890.00
2-43-023310-20021-6030 Sheriff 44,462.00 0.00 0.00 0.00 44,462.00
2-13-138201-00010-6030 Support Services 1,535.00 0.00 0.00 1,535.00
2-22-221120-01000-6030 Treasurer 238,047.00 0.00 0.00 0.00 238,047.00
2-17-302200-30001-6030 Veteran's Services 27.25 0.00 0.00 0.00 27.25
Sub-Total Fund 101 929,479.20 0.00 0.00 0.00 929,479.20
Friend of the Court Fund [2151
2-31-201200-10004-6030 Friend of the Court
Sub-Total Fund 215
202.660.35 0.00 0.00 0.00 202.660.35
202,660.35 0.00 0.00 0.00 202,660.35
Health Fund [22 11
2-17-802200-10001-6030 Animal Control 1,638.00 0.00 0.00 0.00 1,638.00
2-18-221112-60000-6030 CLEMIS - EMS 27.25 0.00 0.00 0.00 27.25
2-16-201200-10000-6030 Health 22,955.00 0.00 0.00 0.00 22,955.00
2-16-220200-65000-6030 Health Environmental 22.092.00 11.12.Q SLOSI 0.0Q 22.092.00
Sub-Total Fund 221 46,712.25 0.00 0.00 0.00 46,712.25
Juvenile Maintenance Fund [2931
2-16-501200-25001-6030 Children's Village 3.291.00 9...Q.Q 0.0Q 0.00 3.291.00
Sub-Total Fund 293 3,291.00 0.00 0.00 0.00 3,291.00
18-636111-10000-0735 DATA PROCESSING DEVELOPMENT FOR 1.182.142.80 12.01 IL_QO 9.00 1.182.142.80
GOVERNMENTAL FUND APPROPRIATION
2-21 -22 1000-01 000-6039 Clerk
2-31 -201 200-1 0004-6039 Friend of the Court
2-34-101200-40001-6039 Probate
15-636111-10000-0573 TOTAL IMAGING DEVELOPMENT
APPROPRIATION
36,598.40 0.00 0.00 0.00 36,598.40
61,545.84 0.00 0.00 0.00 61,545.84
7.87736 OM 0,00 0,00 7.877.76
106.022.00 9.00 106.022.00
2-18-101112-10000-6030
2-18-101112-10000-6039
Information Technology
Imaging Development
TOTAL GOVERNMENT:
(1,182,142.80) 0.00 0.00 0.00 (1,182,142.80)
(106.022,001 0.00 0.00 0.00 (106.022.001
19,91 SIN 10-02 SILO 11.9.11
Prepared by: Linda Munk, Info Tech; 01/12/2000; 8:47 AM 1fy2000d.xlw
" INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
1ST QUARTER 2000
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
ACCOUNT* DIVISION Oct - Dec Jan - Mar Apr - June July - Sept Y.T.D,
Community Development Grant 1,008.25 0.00 0.00 0.00 1,008.25
Facilities Maintenance & Operations 5,015.75 0.00 0.00 0.00 5,015.75
FOC - Medical Support 116.00 0.00 0.00 0.00 116.00
Health Immunization 16,946.50 0.00 0.00 0.00 16,946.50
I.T. - Telephone Communications 54.50 0.00 0.00 0.00 54.50
Materials Management 1,372.50 0.00 0.00 0.00 1,372.50
Medical Care Facility 3,017.00 0.00 0.00 0.00 3,017.00
PA189 Projects 15,967.00 0.00 0.00 0.00 15,967.00
Parks and Recreation - Administration 1,847.25 0.00 0.00 0.00 1,847.25
Water & Sewer Accounting 9.201.50 4.124 O.SLQ ILQ.(1 9.201.5Q
18-636111-10000-0715 DIRECT CHARGES FOR DATA $54.546.25 %Lila $Q.QQ $0.00 54.546.25
PROCESSING DEVELOPMENT
TOTAL DEVELOPMENT CHARGES $1.342.711.05 ELM 11.011 SIM 1.342.711.05
18-636111-10000-0429 Sidwell 31,020.50 0.00 0.00 0.00 31,020.50
18-636111-10000-0759 Community Mental Health - Admin 4,057.00 0.00 0.00 4,057.00
18-636111-10000-0759 Traffic Improvement Association 3.778.00 (L.Q.4 119.2 =2 3.778.0Q
TOTAL NON-COUNTY AGENCIES 38.855.5Q (19.4 0...QQ 0.00 38.855.50
(Information Purposes Only) Information Technology 978,274.05 0.00 0.00 0.00 978,274.05
Prepared by: Linda Munk, Info Tech; 01/12/2000; 8:48 AM 1fy2000d.xlw
$1 638 OQ
$54.50
$27.25
$1,638.00
$54.50
$27.25
$3291 00
$3,291.00
$24,184.75
34.665.0Q
12725
$168.00
$44 797.50
$61 495.2Q
$36 598.4Q
$44239.35
$3,676.50
7.254.0Q
11.687.0Q
$571 00
$22,317.50
29,232.00
26 228.5Q
$58,849.75
$27.25
$168.00
$44,797.50
$61,495.20
$36,598.40
$44,239.35
$10,930.50
$1,687.00
$571.00
$77,778.00
660 FISCAL SERVICES ADMIN FS-System/Customer Support
FS-System Maintenance
Human Services - Acct'g
Fiscal Services Admin - Total
$31,902.50
55,519.75
35.59580
44021
44022
96001
$123,018.05
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT I SUPPORT DETAIL - FIRST QUARTER, F.Y. 2000
Cust* GOVERNMENTAL FUNDS
630 ANIMAL CONTROL
620 AUDITING
005 BOARD OF COMMISSIONERS
665 CHILDRENS VILLAGE
420 CIRCUIT COURT
900 CLEMIS - EMS
725 CLERK - ADMIN
720 CLERK / REGISTER OF DEEDS
aao CLERK ELECTIONS
722 CLERK- IMAGING
410 CLERK - JURY COMMISSION
724 CLERK - LEGAL RECORDS
723 CLERK-VITAL STATISTICS
730 DRAIN
740 EQUALIZATION
95682 Dog System
Animal Control - Total
95468 Auditing - Cust Support
Auditing - Total
91404 BOC - Customer Support
BOC - Total
95665 Childrens Village
Childrens Village - Total
Or Court Admin
Assignment Clerk
Circuit Court - Total
95479 CLEMIS - EMS Customer Support
CLEMIS - EMS - Total
72500 Clerk - Admin
Clerk - Admin - Total
95558 User Support/ROD
Clerk/Reg of Deeds - Total
95443 Elections
Elections - Total
Clerk - Image Replace - 21%
Clerk - Imaging
Clerk - Imaging - Total
95512 Jury Commission
Jury Commission - Total
95170 Legal Division
95189 Circuit Ct System
Clerk - Legal records - Total
95161 Vital Stats Index
Clerk - Vital Statistics - Total
28009 Drain - Administration
Drain - Total
Equal - Development
User Support/Equal
Equal-System Maintenance
Equalization - Total
95195
95452
65420
95158
31075
95559
95693
Prepared by: Linda Munk, Info Tech; 01/12/2000; 8:52 AM 1 1fy2000d.xlw
37025
96841
96842
37002
84200
$751.50
1,471.50
17 797.9Q
$169,342.10
33 318 25
$6,426.00
55.119 84
$9,367.50
708.50
12.879 0Q
$126.00
21 966.0Q
127.718 5Q
$54.5Q
$3,290.50
35 595.80
$981 00
$4,778.00
5,628.00
3.066.00
$7 877.76
$21.772.0Q
115.9.2.7-0.4
$1,239.00
252 00
$1,491.00
$20,020.90
$202,660.35
$61,545.84
$22,955.00
$22.092.00
$27 ,718.50
$54.50
$38,886.30
$981.00
$13,472.00
$7,877.76
$21,772.00
$16,027.00
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, F.Y. 2000
calif GOVERNMENTAL FUNDS
670 FISCAL SERVICES - GENERAL
470 FRIEND OF THE COURT
471 FRIEND OF THE CT IMAGING
840 HEALTH DEPARTMENT
843 HEALTH - ENVIRONMENTAL
872 MEDICAL EXAMINER
710 M.S.U. EXTENSION
680 PERSONNEL
775 PLANNING & ECO DEVELOPMENT
480 PROBATE COURT
482 PROBATE - IMAGING
481 PROBATE - JUVENILE
145 PROSECUTOR
690 PURCHASING
Bud-System/Customer Support
Bud-System Maintenance
Human Resources - Budget
Fiscal Services - General - Total
34041 Friend of the Court
34046 FOC - Professional Services
Friend of the Court - Total
34044 FOC Image Operations
65410 FOC-Image Replace-74%
FOC Develop Image - Total
CHAMPS - P.O.P.
Health South PC NET
Health - Admin
Health - Total
Environmental
EH - Projects
Health-Environmental - Total
87202 Med Exam - Cust Support
Medical Examiner - Total
95676 Coop Ext Equipment Maintenance
M.S.U. Extension - Total
Personnel User Support
Human Res. - Personnel
Personnel - Total
95608 Pln'g & Eco Dev - Data Warehousing
Planning & Eco Development. Total
Probate - Admin
Probate - Estates
Probate-Field Services
Probate - Total
48200 Probate - Imaging
Probate - Imaging - Total
95191 Probate Crt Juv Div
Probate Juvenile - Total
95622 ProsExecutive
Prosecutor - Total
44026 Pur-System /Customer Support
44027 Pur-System Maintenance
Purchasing - Total
44076
44077
96003
95556
96002
95200
95202
95203
2 lfy2000d.xlw Prepared by Linda Munk, Info Tech; 01/12/2000; 8:52 AM
$13.890.00
$25,919.00
18 543 OQ
$1 535 00
$110,084.00
54.50
1,090.00
52,348.50
3,780.00
70 690 OQ
$2.7-Z
$16 869 67
$16 869.67
$16_869 67
$16.869.64
$13,890.00
$44,462.00
$1,535.00
$238,047.00
$27.25
$16,869.67
$16,869.67
$16,869.67
$16,869.64
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, F.Y. 2000
Cust # GOVERNMENTAL FUNDS
650 REIMBURSEMENT 95470 Reimbursement System
Reimbursement - Total
195 SHERIFF 97163 Sheriff
97164
Sheriff. Development
Sheriff - Total
445 SUPPORT SERVICES 44500 Support Services User Support
Support Services - Total
600 TREASURER 44012 Tre-Data Warehousing
44061 Tre-System/Customer Support
44062 Tre-System Maintenance
95303 Del Tax System Maintenance
95313 DTX-Enhance/Development
95561 User Support/Del Tax
Treasurer. Total
910 VETERANS SERVICES 95651 Veterans Cust Support
Veterans Sen/icse - Total
540 5211 DISTRICT COURT. NOV( 95527 DC Suprt -25%-5211
52/1 District Court - Total
550 $2/2 DISTRICT COURT - CLARKSTON 95528 DC Suprt -25%-52/2
52/2 District Court - Total
560 52/3 DISTRICT COURT - ROCHESTER 95529 DC Suprt -25%-52/3
52/3 District Court - Total
530 52/4 DISTRICT COURT - TROY 95530 DC Suprt -25%-5214
52/4 District Court - Total
Prepared by: Linda Munk, Info Tech: 01/12/2000; 8:52 AM 3 1fy2000d.xlw
Cust* DIRECT FUNDS
661 COMMUNITY DEVELOPMENT
750 FAC MAINT & OPERATIONS
473 FOC - MEDICAL SUPPORT
380 HEALTH IMMUNIZATION - GRANT
Technical Sys/Networking
640 MATERIALS MANAGEMENT
751 J.T. - TELEPHONE COMMUN1QATION$
870 MEDICAL CARE FACILITY
004 PA189 PROJECTS
770 PARKS & RC ADMINISTRATION
656 WATER & SEWER ACCOUNTING
$1008 25
$5 015 75
$1160Q
$4,640.50
12.306.0Q
$252,167.95
218.00
14,616.00
9,101.50
252,234.50
147,686.00
38,484.00
210,907.10
436.00
4,964.00
272.50
$47 186.5Q
$1 372 50
$54 5Q
$3.017_0Q
$1,280.50
320.13
320.13
320.13
320.11
3,351.50
3,351.50
3,351.50
837.88
837.88
837.88
837.86
$626.75
1 220.5Q
$9.201.5Q
$1,008.25
$5,015.75
$116.00
$16,946.50
$931,087.55
$47,186.50
$1,372.50
$54.50
$3,017.00
15,967.00
$1,847.25
$9,201.50
NON-COUNTY AGENCIES $38,855.50
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER, F.Y. 2000
010 INFORMATION TECHNOLOGY
Systems Develop/Support
66103 Comm Dev User Support
Community Development - Total
75503 FM0 Development
FM&O - Total
47300 FOC - Medical Support Grant
FOC - Medical Support Total
38000 Health - Immunization
38100 Health - Regional Immunization
Health - Immunization - Total
Year 2000 Project
Enhanced Access Project
GIS - Administration
Open Systems Administration
Oracle Administration
IT Disc Data Warehouse
IT Disc GIS
CVT - New Development
IT - New Operating System
Equipment Inventory
IT - Disaster Recovery
95689 Database Tech Support
95440 Materials Management
98873 Materials Management - Total
21012 I.T. - Communications
I.T. - Communications - Total
98873 MCF - Support
Medical Care Facility - Total
PA189 LIDS Circ Ct - 50%
PA189 IJDS 5211 DC - 12.5%
PA189 IJDS 5212 DC - 12.5%
PA189 LIDS 52/3 DC - 12.5%
PA189 IJDS 52/4 DC - 12.5%
PA189 JIMS Circ Ct - 25%
PA189 JIMS Probate - 25%
PA189 JIMS Prosecutor - 25%
PA189 JIMS 5211 DC- .0625%
PA189 JIMS 52/2 DC - .0625%
PA189 JIMS 52/3 DC - .0625%
PA189 JIMS 52/4 DC - .0625%
PA189 Projects - Total
95169 PRADM - Admin Services
95419 PRADM-Administration
Parks & Rec Admin - Total
95669 Water & Sewer Acctg
Water & Sewer Acctg - Total
02000
22000
25100
25200
25400
30001
30003
91516
95150
95456
95685
90402
90403
90404
90405
90406
90603
90604
90605
90606
90607
90608
90609
Prepared by: Linda Munk, Info Tech; 01/12/2000; 8:55 AM 4 1fy2000d.xlw
Resolution 400003 January 27, 2000
Moved by Patterson supported by Palmer the resolutions on the
Consent Agenda be adopted and reports be accepted.
AYES: Causey-Mitchell, Colasanti, Coleman, Buckley, Dingeldey, Douglas,
Galloway, Garfield, Gregory, Jensen, Law, McCulloch, McPherson, Melton, Millard,
Moffitt, Obrecht, Palmer, Patterson, Schmid, Sever, Taub, Amos, Appel. (24)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolutions on the Consent
Agenda were adopted and reports accepted.
HEREB AP VE THE FOREGOING RESOLur^
/ -vo Brooke P eraok County ExecutNo
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 January 27, 2000 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 2)0. day'of January, 2000.
G. William Caddell, County Clerk