HomeMy WebLinkAboutResolutions - 2000.05.18 - 26137„fthar,
FINANCE COMMITTEE
MISCELLANEOUS RESOLUTION #00107
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY -SECOND 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 non-departmental 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 Second Quarter 2000 data processing development charges to be
$1,060,131 and the imaging development charge to be $88,968 for the
General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund
departments are $88,991 and non-county agencies are $20,998 for the
Second Quarter 2000; and
WHEREAS an appropriation transfer to General Fund/General Purpose
County departments is needed to fund these development charges.
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of
Commissioners has reviewed the Second Quarter 2000 Data Processing
Development and approves the second quarter appropriation transfer and
budget amendments as specified on the attached schedule.
Chairperson, on behalf of the Finance Committee, I move the
adoption of the foregoing resolution.
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote with Jensen absent.
INFORMATION' TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
2ND QUARTER 2000
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
ACCOUNT # DIVISION Oct - Dec Jan - Mar Apr - June July - Sept Y.T.D.
General Fund [1011
2-32-201200-20001-6030 52/1 District Court 16,869.67 4,999.50 0.00 0.00 21,869.17
2-32-301200-20001-8030 52/2 District Court 16,869.67 4,999.50 0.00 0.00 21,869.17
2-32-401200-20001-6030 52/3 District Court 16,869.67 4,999.50 0.00 0.00 21,869.17
2-32-501200-20001-6030 52/4 District Court 16,869.64 4,999.47 0.00 0.00 21,869.11
2-17-802200-10001-6030 Animal Control 1,638.00 89.05 0.00 0.00 1,727.05
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 64,062.11 0.00 0.00 122,911.86
2-21-220100-01000-6030 Clerk - Admin 168.00 - 356.21 0.00 0.00 524.21
2-21-230100-01000-6030 Clerk - Elections 61,495.20 61,024.18 0.00 0.00 122,519.38
2-21-250100-010004030 Clerk - Jury Commission 44,239.35 45,490.11 0.00 0.00 89,729.46
2-21-221000-01000-6030 Clerk - Legal Records 10,930.50 11,530.13 0.00 0.00 22,460.63
2-21-240100-01000-6030 Clerk - Register of Deeds 44,797.50 19,022.94 0.00 0.00 63,820.44
2-21-220500-01000-6030 Clerk - Vital Statistics 1,687.00 4,928.09 0.00 0.00 6,615.09
2-11-210100-01000-6030 County Executive 27.47 0.00 0.00 27.47
2-61-211001-10000-6030 Drain Commissioner 571.00 54.95 0.00 0.00 625.95
2-12-240000-44100-6030 Equalization Division 77,778.00 81,075.93 0.00 0.00 158,853.93
2-12-601200-10001-6030 Fiscal Services - Admin 123,018.05 123,561.89 0.00 0.00 246,579.94
2-12-621200-10001-6030 Fiscal Services - General 20,020.90 12,707.23 0.00 0.00 32,728.13
2-16-912000-15000-6030 Medical Examiner 27,718.50 19,699.04 0.00 0.00 47,417.54
2-17-501200-10001-6030 M.S.U. Extension - Oakland 54.50 445.25 0.00 0.00 499.75
2-15-402200-100014030 Personnel 38,888.30 25,511.03 0.00 0.00 64,397.33
2-19-221000-10000-6030 Planning & Economic Development 981.00 1,016.68 . 0.00 0.00 1,997.68
2-34-401200-40001-6030 Probate Court - Estates & Mental Health 13,472.00 12,757.08 0.00 0.00 26,229.08
2-34-101200-40001-6030 Probate Court-Juvenile 21,772.00 14,012.17 0.00 0.00 35,784.17
2-41-211000-10000-6030 Prosecuting Attorney 16,027.00 24,337.26 0.00 0.00 40,364.26
2-12-401200-40010-6030 Purchasing 1,491.00 1,123.57 0.00 0.00 2,614.57
2-12-701200-10001-6030 Reimbursement Division 13,890.00 16,479.13 0.00 0.00 30,369.13
2-43-023310-20021-6030 Sheriff 44462.00 55,496.24 0.00 0.00 99,958.24
2-13-138201-00010-6030 Support Services 1,535.00 9,764.93 0.00 0.00 11,299.93
2-22-221120-01000-6030 Treasurer 238,047.00 129,759.68 0.00 0.00 367,806.68
2-17-302200-30001-6030 Veteran's Services 27.25 0.00 0.00 0.00 27.25
Sub-Total Fund 101 931,117.20 754,330.32 _ 0.00 0.00 1,685,447.52
Friend of the Court Fund [2151:
2-31-201200-10004-6030 Friend of the Court
Sub-Total Fund 215
202 660.35 256 500.25 0.00 0.00 459 160.60
202,660.35 256,500.25 0.00 0.00 459,160.60
Health Fund [2211
2-23-221112-65001-6030 CLEMIS - EMS 27.25 2,359.82 0.00 0.00 2,387.07
2-16-201200-10000-6030 Health 22955.00 3,588.76 0.00 0.00 26,543.76
2-16-234200-54600-6030 Health - Clinic 356.20 0.00 0.00 356.20
2-16-220200-67000-6030 Health Environmental 22,092.00 00 __... 38 935.85 0.00 0.00 61 027.85
Sub-Total Fund 221 46,712.25 45,240.63 0.00 0.00 91,952.88
Juvenile Maintenance Fund [2931
2-16-501200-25001-6030 Children's Village
Sub-Total Fund 293
18-636111-10000-0735 DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
3291.00 4,059.42 0.00 0.00 7,350.42
3,291.00 4,059.42 0.00 0.00 7,350.42
1,182,142.80 1.060,130.62 0.00 0.00 2,242.273.42
2-21-221000-01000-6039 Clerk 36,598.40 36,026.58 0.00 0.00 72,624.98
2-31-201200-10004-6039 Friend of the Court 61,545.84 45,297.89 0.00 0.00 106,843.73
2-34-101200-40001-6039 Probate 7. 877 76 ._____... 7,643.28 0.00 0.00 15 521.04
18-636111-10000-0573 TOTAL IMAGING DEVELOPMENT 106.022.00 88,967.75 0.00 0.00 194 989.75
APPROPRIATION
90-290000-25000-6030 Information Technology Development (1,288,164.80) (1,149,098.37) 0.00 0.00 (2,437,263.17)
TOTAL GOVERNMENT: $0.00 $0.00 $0.00 $0.00 0.00
Prepared by: Linda Munk, Info Tech; 4/6/2000; 6:37 PM 2fy2000.xlw
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
2ND QUARTER 2000
1st Qtr 2nd Qtr 3rd Qtr 4th Qtr
ACCOUNT # DIVISION Oct - Dec Jan - Mar Apr - June July - Sept Y.T.D.
Community Corrections
Community & Home Improvement
Facilities Maintenance & Operations
FOC - Medical Support
Health Immunization
I.T. - Telephone Communications
Materials Management
Medical Care Facility
PA189 Projects
Parks and Recreation - Administration
Water & Sewer Accounting
18-636111-10000-0715 DIRECT CHARGES FOR DATA
PROCESSING DEVELOPMENT
1,343.65
1,008.25 851.81
5,015.75 1,543.38
116.00 0.00
16,946.50 19,235.19
54.50 0.00
1,372.50 623.35
3,017.00 12,816.18
15,967.00 43,569.69
1,847.25 6,142.67
9,201.50 2.864.87
$54,546.25 $88.990.79
0.00 0.00 1,343.65
0.00 0.00 1,860.06
0.00 0.00 6,559.13
0.00 0.00 116.00
0.00 0.00 36,181.69
0.00 0.00 54.50
0.00 0.00 1,995.85
0.00 0.00 15,833.18
0.00 0.00 59,536.69
0.00 0.00 7,989.92
0.00 0.00 12 066.37
$0.00 $0.00 143 537.04
TOTAL DEVELOPMENT CHARGES S1.342.711.05 $1.238.089.16 $0.00 $0.00 2 580 800.21
18-636111-10000-0429 Sidwell 31,020.50 20,525.61 0.00 0.00 51,546.11
18-636111-10000-0759 Community Mental Health - Admin 4,057.00 445.26 0.00 0.00 4,502.26
18-636111-10000-0759 Traffic Improvement Association 3,778.00 27.47 0.00 0.00 3,805.47
TOTAL NON-COUNTY AGENCIES 38 855.50 20 998.34 0.00 0.00 59.853.84
(Information Purposes Only) Information Technology 978,274.05 905,547.94 0.00 0.00 1,883,821.99
Prepared by: Linda Munk, Info Tech; 4/6/2000; 6:38 PM 2fy2000.xlw
• INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2000
Cust # GOVERNMENTAL FUNDS
630 ANIMAL CONTROL 95682 Dog System $89.05
Animal Control - Total $89.05
665 CHILDRENS VILLAGE 95665 Childrens Village $4,059.42
Childrens Village - Total $4,059.42
420 CIRCUIT COURT 95195 Cir Court Admin $41,847.30
95452 Assignment Clerk 22 214.81
Circuit Court - Total $64,062.11
900 CLEMIS - EMS 95479 CLEMIS - EMS Cust Support $2,359.82
CLEMIS - EMS - Total $2,359.82
725 CLERK - ADMIN 72500 Clerk - Admin $356.21
Clerk - Admin - Total $356.21
720 CLERK! REGISTER OF DEEDS 95493 Reg Deeds System Maintenance $1,099.10
95558 User Support/ROD 17 923.84
Clerk/Reg of Deeds - Total $19,022.94
440 CLERK ELECTIONS 95443 Elections $61.024.18
Elections - Total $61,024.18
722 CLERK - IMAGING 65420 Clerk-Image Replace-21% $35,604.99
95158 Clerk - Imaging 421.59
Clerk - Imaging - Total $36,026.58
410 CLERK -JURY COMMISSION 95512 Jury Commission $45,490.11
Jury Commission - Total $45,490.11
724 CLERK - LEGAL 95170 Legal Division $2,671.06
95189 Circuit Ct System 8,859.07
Clerk - Legal-Total $11,530.13
723 CLERK - VITAL STATISTICS 95161 Vital Stats Index $4,928.09
Clerk -Vital Statistics - Total $4,928.09
015 COUNTY EXECUTIVE 95656 County Executive Support $27.47
County Executive - Total $27.47
730 DRAIN COMMISSIONER 28009 Drain - Administration $54.95
Drain Commissioner - Total $54.95
740 EQUALIZATION 31075 Equal - Development $22,331.77
95559 User Support/Equal 28,128.36
95693 Equal-System Maintenance 30 615.80
Equalization - Total $81,075.93
Prepared by: Linda Munk, Info Tech; 4/6/2000 1 2fy2000.xlw
660 FISCAL SERVICES ADMIN 44021
44022
44023
96001
$18,469.34
56,162.98
23,693.33
25.236.24
$123,561.89
95200
95202
95203
Probate - Admin
Probate - Estates
Probate - Field Services
Probate - Total
$45,297.89
$3,588.76
$356.20
$38,935.85
$19,699.04
$445.25
$25,511.03
$1,016.68
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2000
Cust # GOVERNMENTAL FUNDS
FS-System/Customer Support
FS-System Maintenance
FS-System Enhancements
Human Res - Acct
Fiscal Services Admin - Total
670 FISCAL SERVICES - GENERAL
470 FRIEND OF THE COURT
471 FRIEND OF THE CT IMAGING
840 HEALTH DEPARTMENT
845 HEALTH - CLINIC
843 HEALTH - ENVIRONMENTAL
872 MEDICAL EXAMINER
710 MSU EXTENSION - OAKLAND
680 PERSONNEL
775 PLANNING & ECO DEVELOPMENT
480 PROBATE COURT
44076 Bud-System/Customer Support
96003 Human Resources - Budget
Fiscal Services - General - Total
34041 Friend of the Court
34046 FOC - Professional Services
Friend of the Court - Total
34042 FOC Develop Image
65410 FOC-Image Replace-74%
FOC Develop Image - Total
37025 CHAMPS - P.O.P.
96842 Health - Admin
Health - Total
37007 Clinic
Health - Clinic - Total
37002 Environmental
84200 EH - Projects
Health-Environmental - Total
87202 Med Exam - Cust Support
Medical Examiner - Total
95676 MSU Ext Equipment Maintenance
MSU Extension -Total
95556 Personnel User Supt
96002 Human Res. - Personnel
Personnel - Total
95600 Cust/System Support
95608 Pln'g & Eco Dev - Data Warehouse
Development & Planning
$89.05
12.618.18
$12,707.23
$256,417.82
$82.43
$256,50025
$3,192.57
42 105.32
$739.12
2,849.64
$356.20
$9,019.02
$29,916.83
$19,699.04
$445.25
$274.78
25 236.25
$357.22
$659.46
$298.44
10,410.47
2.048.17
$12,757.08
Prepared by: Linda Munk, Info Tech; 4/6/2000 2 2fy2000.xlw
Tre-Data Warehousing
Tre-System/Customer Support
Tre-System Maintenance
Del Tax System Maintenance
User Support/Del Tax
Treasurer - Total
44012
44061
44062
95303
95561
550 52/2 DISTRICT COURT - CLARKSTON 95528
560 5213 DISTRICT COURT - ROCHESTER 95529
DC Suprt -25%-5212
52/2 District Court - Total
DC Suprt -25%-52/3
52/3 District Court - Total
$14,012.17
$7,643.28
$24,337.26
$1,123.57
$16,479.13
$55,496.24
$9,764.93
$129,759.68
$4,999.50
$4,999.50
$4,999.50
$4,999.47
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2000
Cust# GOVERNMENTAL FUNDS
481 PROBATE - JUVENILE
482 PROBATE-IMAGE
145 PROSECUTOR
690 PURCHASING
650 REIMBURSEMENT
195 SHERIFF
445 SUPPORT SERVICES
600 TREASURER
540 52/1 DISTRICT COURT - NOVI
530 52/4 DISTRICT COURT - TROY
95191 Probate Crt Juv Div
Probate Juvenile - Total
48200 Probate - Imaging
Probate - Imaging Total
95622 Prosecutor/Executive
Prosecutor - Total
44026 Pur-System/Customer Support
44027 Pur-System Maintenance
Purchasing - Total
95470 Reimbursement System
Reimbursement - Total
97163 Sheriff
Sheriff- Total
44500 Support Services
Support Services - Total
95527 DC Suprt -25%-52/1
52/1 District Court - Total
$14,012.17
$7,643.28
$24,337.26
$1,068.62
54.95
$16,479.13
$55,496.24
$9,764.93
$43,208.43
$795.84
3,609.01
33,706.48
48 439.92
$4,999.50
$4,999.50
$4,999.50
$4,999.47 95530 DC Suprt -25%-5214
52/4 District Court - Total
Prepared by: Linda Munk, Info Tech; 4/6/2000 3 2fy2000.xlw
Cust# DIRECT FUNDS
657 COMMUNITY CORRECTIONS 65701 Community Corrections Grant
Community Corrections - Total
661 COMMUNITY & HOME IMPROVEMENT 66103 Comm Dev User Supt
Comm & Home Improv - Total
750 FAC MAINT & OPERATIONS
380 HEALTH IMMUNIZATION - GRANT
75503 FM0 Development
FM&O - Total
--
38000 Health - Immunization
38100 Health-Regional lmmun Registry
Health - Immunization - Total
95440 Materials Management
Materials Management - Total
98873 MCF - Support
MCF - Support - Total
95419 PRADM - Administration
Parks and Recreation - Total
95669 Water & Sewer Acctg
Water & Sewer Acctg - Total
$905,547.94
$623.35
$12,816.18
43,569.69
$6,142.67
$2,864.87
$20,998.34
4 2fy2000.xlw
INFORMATION TECHNOLOtY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2000
$1,343.65
$851.81
$1,543.38
$1,950.41
17,284.78
$1,343.65
$851.81
$1,543.38
$19,235.19
02000
25100
25200
25400
30001
30002
30003
91512
91516
95689
90603
90604
90605
90606
90607
90608
90609
010 INFORMATION TECHNOLOGY
Systems Develop/Support
640 MATERIALS MANAGEMENT
870 MEDICAL CARE FACILITY
004 PA189 PROJECTS
770 PARKS AND RECREATION
656 WATER & SEWER ACCTG
NON-COUNTY AGENCIES
Prepared by: Linda Munk, Info Tech; 4/6/2000
Year 2000 Project
GIS - Administration
Open Systems Administration
Oracle Administration
IT DISC Data Warehouse
IT DISC Enhanced Access
IT DISC GIS
System Support - Health Plus
CVT - New Development
Database Tech Support
Information Technology - Total
PA189 JIMS Circ Ct - 25%
PA189 JIMS Probate - 25%
PA189 JIMS Prosecutor - 25%
PA189 JIMS 52/1 DC - .0625%
PA189 JIMS 5212 DC - .0625%
PA189 J1MS 52/3 DC - .0625%
PA189 JIMS 52/4 DC - .0625%
PA189 Projects - Total
$190,179.15
$5,269.15
1,263.98
254,461.85
141,827.72
11,151.88
42,881.00
1,335.76
236,220.60
20.956.85
$623.35
$12.816.18
10,892.43
10,892.43
10,892.43
2,723.11
2,723.11
2,723.11
2,723.07
$6,142.67
$2.864.87
Resolution #00107 May 18, 2000
Moved by Suarez supported by Law the resolutions on the Consent Agenda
be adopted and reports be accepted.
AYES: Appel, Causey-Mitchell, Colasanti, Coleman, Dingeldey, Douglas,
Galloway, Garfield, Gregory, Jensen, Law, McCulloch, McPherson, Melton,
Millard, Palmer, Sever, Suarez, Taub, Amos. (20)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolutions on the
Consent Agenda were adopted and the reports were accepted.
'BY _APPIF V E FOREGr' —"" 1TION
3/3/4P IL Brooks Patter on. County Executive 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 18, 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 181 day/6f May, 2000.
4/P '
G. William Caddell, County Clerk