HomeMy WebLinkAboutResolutions - 2000.11.30 - 26199MISCELLANEOUS RESOLUTION #00296 November 30, 2000
BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FY 2000 FOURTH QUARTER DEVELOPMENT
APPROPRIATION
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 Fourth
Quarter FY 2000 data processing development charges to be $1,420,006 and the
imaging development charge to be $42,865 for the General Fund/General Purpose
County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund departments
are $217,092 and non-county agencies are $63,166 for the Fourth Quarter FY 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 Fourth Quarter FY 2000 Data Processing Development
Report and approves the fourth 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
,A2/6-1/te-
Ne-
EINANEE_EDEUITTEE_ILCITE_L
Motion carried unanimously on a roll call vote with Obrecht absent.
cc: Deb Henrickson
Dale Kukla
Joe Maletta
Joe Sullivan
Mike Wilk
Kevin Bertram
Chithra Chakrapani
Carol Howden
Lori Jansen
Janette McKenna
'Scott Oppmann
Gary Pawlowski
Ed Sager
tRoy Lake, Fiscal Services
Prentiss Malone, Fiscal Services
Lynn Sonkiss, Fiscal Services
To: John Mahoney
Director of Inform
From: Linda Munk
ion Technology
Subject
Date:
Supervisor of Administrative Services
Quarterly Development Report — Fourth Quarter, F.Y. 2000
October 26, 2000
Attached is the Data Processing Development Report for the Fourth Quarter, Fiscal Year 2000.
This item is scheduled for the November 16, 2000, Finance Committee for transfer of funds.
Attachment •
ACCOUNT*
General Fund 11011
2-32-201200-20001-8030
2-32401200-20001-8030
242-401200-200014030
242-501200-200014030
2-17-802200-100014030
2-11-220100-100004030
2-51-211000-10000-6030
231-101200-100014030
2-21-220100-010004030
2-21-230100-010004030
2-21-250100-01000-8030
2-21-221000-010004030
2-21-240100-01000-8030
2-21-220500-01000-6030
2-11-210100-01000-6030
2-61-211001-10000-8030
2-12-240000-44100-8030
2-12-801200-100014030
2-12421200-100014030
2-16-912000-15000-6030
2-17-501200-100014030
2-15-402200-10001-8030
2-19-221000-100004030
2-34-401200-40001-8030
2-34-101200-400014030
2-41-211000-10000-6030
2-12-401200-40010-8030
2-12-701200-10001-6030
2-43-023301-20000-6030
2-13-138201-00010-6030
2-22-221120-01000-8030
2-17-302200-30001-8030
Friend of the Court Fund 12151
2-31-201200-10004-8030
Health Fund
2-23-221112450014030
2-18-201200-33100-6030
2-16-234200-54600-6030
2-16-220200470004030
DIVISION
52/1 District Court
62/2 District Court
52/3 District Court
52/4 District Court
Animal Control
Auditing
Board of Commissioners - Adm.
Circuit Court -Administration
Clerk - Admin
Cie* - Elections
Clerk - Jury Commission
Clerk - Legal Records
Clerk - Register of Deeds
Clerk - Vital Statistics
County Executive
Drain Commissioner
Equalization Division
Fiscal Services Adrnin
Fiscal Services - General
Medical Examkier
M.S.U. Extension - Oakland
Personnel
Planning & Economic Development
Probate Court - Estates & Mental Health
Probate Court - Juvenile
Prosecuting Attorney
Purchasing
Reimbursement Division
Sheriff
Support Services
Treasurer
Veteran's Services
Sub-Total Fund 101
Friend of the Court
Sub-Total Fund 215
CLEMIS - EMS
Health
Health - Clinic
Health Environmental
Sub-Total Fund 221
• AILIPALMAIBINIEBILE510Blagl
2-16-501200-250014030 Children's Village
Sub-Total Fund 293
18-638111-10000-0735
2-21-221000-01000-8039
2-31-201200-10004-6039
2-34-101200-40001-6039
18-636111-10000-0573
90-290000-25000-6030
DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
Clerk
Friend of the Court
Probate
TOTAL IMAGING DEVELOPMENT
APPROPRIATION
Information Technology Development
TOTAL GOVERNMENT:
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
4TH QUARTER 2000
1st Qtr 2nd Qtr 3rd Qtr 41h Qtr
gsiUkc Jan - Mar &tam IgL..ulggt
$18,869.67 $4,999.50 $8,389.41 $8,522.87 $38,781.25
18,869.67 4,999.50 6,389.41 8,522.87 36,781.25
18,869.87 4,999.50 8,389.41 8,522.67 36,781.25
18,889.64 4,999.47 8,389.42 8,522.86 38,781.19
1,838.00 89.05 0.00 845.98 2,573.03
54.50 0.00 54.95 274.78 384.23
27.25 0.00 0.00 0.00 27.25
58,849.75 84,082.11 59,516.03 57,303.23 239,731.12
168.00 358.21 1,202.20 578.84 2,305.25
81,495.20 81,024.18 98,979.82 69,326.18 288,825.38
44,239.35 45,490.11 24,998.74 9,847.62 124,575.82
10,930.50 11,530.13 27,301.74 34,593.91 84,458.25
44,797.50 19,022.94 12,399.40 4,148.91 80,388.75
1,887.00 4,928.09 9,307.99 2,989.83 18,912.91
27.47 _ 0.00 0.00 27.47
571.00 54.95 10,302.38 12,492.00 23,420.31
77,778.00 81,075.93 110,714.92 148,806.45 418,174.30
123,018.05 123,581.89 328,823.63 217,259.33 792,882.90
20,020.90 12,707.23 108,312.07 63,858.24 202,898.44
27,718.50 19,899.04 33,215.83 87,214.73 147,848.10
54.50 445.25 89.05 0.00 588.80
38,888.30 25,511.03 204,898.49 138,452.93 407,545.75
981.00 1,016.88 0.00 0.00 1,997.68
13,472.00 12,757.08 12,180.89 13,580.81 51,970.78
21,772.00 14,012.17 9,193.03 ' 5,840.19 50,817.39
18,027.00 24,337.26 24,205.42 35,388.72 99,938.40
1,491.00 1,123.57 5,779.88 2,046.63 10,440.86
13,890.00 18,479.13 4,203.62 9,863.74 44,438.49
44,482.00 55,496.24 63,043.54 53,007.12 216,008.90
1,535.00 9,764.93 8,023.94 18,298.83 35,822.50
238,047.00 129,759.68 128,000.94 137,357.79 831,185.41
27.25 KlIgi LW Q g_11 212.1
931,117.20 754,330.32 1,302,105.91 1,137,12826 4,124,879.69
202,680.35 256.500.25 27&374.91 175.340.44 912.875.95
202,880.35 258,500.25 278,374.91 175,340.44 912,875.95
27.25 2.359.82 0.00 0.00 2,387.07
22,955.00 3,588.76 5,55826 5,097.07 37,199.09
356.20 4,545.35 29,324.28 34,225.83
22.092.00 38.935.85 Elgin 09.289.00 217.363.84
45,074.25 45,240.83 97,150.80 103,710.35 291,175.83
3.291.00 4.n0 3.113.96 Ilan 14293.55
3,291.00 4,059.42 3,113.96 3,829.17 . 14,283.56
1.182.142,50 1.060.130.62 1.680.745.38 1420.006= 5.343.025.02
38,598.40 36,026.58 23,079.86 20,405.81 118,110.45
61,545.84 45,297.89 21,402.64 20,338.58 148,582.95
7.877,78 7.643,29 3.426.66 2,122.40 21.070.10
106.022.00 85.987.75 4.7,90556 42.884.79 Minn
(1,288,184.80) (1,149,098.37) (1,728,854.34) (1,482,871.01) (5,628,788.52)
$0.00 )0.00 11.0 14.211 122
Prepared by: Linda Munk, Info Tech; 1012612000; 11:02 AM 4fy2000adw
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
4TH QUARTER 2000
ACCOUNT*
18-838111-10000-0715
1st Qtr 2nd Qtr 3rd Ott 4th QV
DIVISION Oct - Dec arJ_1-4A r Por - June JuN - Seot Y.T.D.
Community Corrections 1,343.65 5,933.12 7,637.20 14,913.97
Community & Home Improvement 1,008.25 651.81 714.42 1,483.78 4,058.28
Facilities Maintenance & Operations 5,015.75 1,543.38 0.00 0.00 8,559.13
FOC - Medical Support 118.00 0.00 0.00 - 0.00 118.00
Health Immunization 16,946.50 19,235.19 15,459.21 5,510.61 57,151.51
LT. - Telephone Communications 54.50 0.00 0.00 5,206.82 5,201.12
Materials Management 1,372.50 623.35 2,849.60 222.62 5,068.07
Medical Care Facility 3,017.00 12,818.18 12,529.90 5,299.22 33,882.30
PA189 Projects 15,987.00 43,589.69 68,043.10 184,781.92 292,341.71
Parks and Recreation - Administration 1,847.25 6,142.87 (3,598.92) 6,644.65 11,035.85
Print Shop 521.07 0.00 521.07
Risk Management 9,548.00 193.50 9,739.50
- Treasurer - 100% Tax Payment Fund 12,356.54 17,616.48 29,973.02
Water & Sewer Accounting 50201 9
........_,...._ 2.864.8Z 9.701.42 2.515.80 24.363.39
DIRECT CHARGES FOR DATA 854.548.25 988.99039 IMAM§ $217,092.20 41414412
PROCESSING DEVELOPMENT
TOTAL DEVELOPMENT CHARGES 11.342.711.05 51.238.089.16 81.862a9.10 91.879.983.21 6.123a53.22
18-636111-10000-0429 Sichvell 31,020.50 20,525.81 26,065.16 24,648.54 102,857.61
18-636111-10000-0759 Community Mental Health - Admin 4,057.00 445.26 0.00 38,252.34 42,754.80
16-636111-10000-0759 Traffic Improvement Association 2,71,122 27.47 gag azaq 4,272,12
TOTAL NON-COUNTY AGENCIES 38.855,50 20.9I834 =Ha 83.188.04 149,883.04
(Information Purposes Only) Information Technology 978,274.05 905,547.94 691,176.07 727,918.00 3,302,915.08
Prepared by: Linda Munk, Info Tech; 10/26/2000; 11:02 AM 4fy20d6Jdw
95493 Reg Deeds System Maintenance $2,335.39
95558 User Support/ROD 1.81 3.52
Clerk/Reg of Deeds - Total $4,148.91
95443 Elections S69.326.18
Elections - Total $69,326.18
65420 Clerk - Image Replace - 21% $20405.81
Clerk - Imaging - Total $20,405.81
•
95512 Jury Commission $9.847.62
Jury Commission - Total $9,847.62
95189 Circuit Court System $34.693.91
Clerk - Legal Records - Total $34,693.91
95161 Vital Stats Index $2.989.83
Clerk - Vital Statistics - Total $2,989.83
28009 Drain - Administration $12.492.00
Drain Commissioner - Total $12,492.00
31071 EMA - Development $7,473.82
31075 Equal - Development 67,327.29
95559 User Support/Equal 14,324.36
95690 Personal Property 24,078.69
95693 Equal-System Maintenance 35401.29
Equalization - Total $148,605.45
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2000
cust # GOVERNMENTAL FUNDS
630 ANIMAL CONTROL DIV 95682 Dog System $845.98
Animal Control Div - Total $845.98
620 AUDITING 95468 Auditing-Cust Supt $274.78
Auditing - Total $274.78
665 CHILDRENS VILLAGE 95665 Childrens Village $3.829.17
Childrens Village - Total $3,829.17
420 CIRCUIT COURT 95195 Cir Court Admin $56,823.23
95452 Assignment Clerk 480.00
Circuit Court - Total $57,303.23
725 CLERK - ADMIN 72500 Clerk - Admin MAI
Clerk - Admin - Total $578.84
720 CLERK! REGISTER OF DEEDS
440 CLERK ELECTIONS
722 CLERK - IMAGING
410 CLERK - JURY COMMISSION
724 CLERK - LEGAL RECORDS
723 CLERK - VITAL STATISTICS
730 DRAIN COMMISSIONER
740 EQUALIZATION
660 FISCAL SERVICES ADMIN
670 FISCAL SERVICES - GENERAL
44021 FS-System/Customer Support
44022 FS-System Maintenance
96001 Human Services - Acct'g
Fiscal Services Admin - Total
44076 Bud-SystemCustomer Support
96003 Human Resources - Budget
Fiscal Services - General - Total
$27,673.47
62,403.71
127.182.15
$217,259.33
$267.15
63.591.09
$63,858.24
Prepared by Linda Munk, Info Tech; 10/26/2000 011 4fy2000.xlw
680 PERSONNEL 95556 Personnel User Supt
96002 Human Res. - Personnel
Personnel - Total
$11,270.76
127.182.17
$138,452.93
480 PROBATE COURT 95200 Probate - Admin $668.89
95202 Probate - Estates 12,669.29
95203 Probate - Field Services 2220.1
Probate - Total $13,560.81
INFORMATION -TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2000
gitit GOVERNMENTAL FUNDS
470 FRIEND OF THE COURT 34041 Friend of the Court $175,120.62
34046 FCC - Professional Services 219.82
Friend of the Court - Total $175,340.44
471 FRIEND OF THE CT IMAGING 34044 FCC Image Operations $400.72
65410 FOC-Image Replace-74% 19.935.86
FOG Develop Image - Total $20,336.58
840 HEALTH DEPARTMENT 37025 CHAMPS - P.O.P. $2,582.46
96842 Health - Admin 2,514.61
Health-Total $5,097.07
845 HEALTH - CUNIC 37007 Clinic $29.324,28
Health - Clinic - Total $29,324.28
843 HEALTH - ENVIRONMENTAL 37002 Environmental $7,602.40
84200 EH - Projects 61.686.60
Health-Environmental - Total $69,289.00
872 MEDICAL EXAMINER
87202 Med Exam - Cust Support 017.214.73
Medical Examiner - Total $67,214.73
482 PROBATE- IMAGING 48200 Probate - Imaging 82.122,40
Probate.- Imaging - Total $2,122.40
481 PROBATE - JUVENILE 95191 Probate Crt Juv Div $5.640.19
Probate Juvenile - Total $5,640.19
145 PROSECUTOR 95619 PROMIS $2,560.19
95622 Prosecutor/Executive 32.808.53
Prosecutor - Total $35,368.72
690 PURCHASING 44026 Pur-SYstern/Customer Support $1,788.63
44028 Pur-System Enhancements 258.00
Purchasing - Total $2,048.63
650 FtEIMBURS MENT 95470 Reimbursement System $9.863,74
Reimbursement - Total $9,863.74
195 SHERIFF 97163 Sheriff $53.007.12
Sheriff-Total $53,007.12
445 SUPPORT SERVICES 44500 Support Services User Support $18.298.63
Support Services - Total $18,298.63
4fy2000.xlw Prepared by: Unda Munk, Info Tech; 10/26/2000
INFORMATION-TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2000
Gust I GOVERNMENTAL FUNDS
44012 Ire-Data Warehousing $23,084.12
44061 Ire-System/Customer Support 1,978.40
44062 Ire-System Maintenance 3,247.97
44063 Tre-System Enhancements 42,303.30
44064 Tre-New Development 384.69
95303 Del Tax System Maintenance 7,498.10
95313 DTX-Enhance/Development 10,716.70
95561 User Support/Del Tax 48.144.51
Treasurer - Total
540 52/1 DISTRICT COURT - NOVI 95527 DC Suprt-24%-52/1 $8.522.67
52/1 District Court - Total
550 52/2 DISTRICT COURT - CLARKSTON 95528 DC Suprt -25%-52/2 $8522.67
52/2 District Court - Total
560 5213 DISTRICT COURT - ROCHESTER 95529 DC Suprt -25%-52/3 $8.522.67
5213 District Court - Total
530 5214 DISTRICT COURT - TROY 95530 DC Suprt -25%-5214 $8.522.66
52/4 District Court - Total
600 EASURER
$137,357.79
$8,522.67
$8,522.67
$8,522.67
$8,522.66
• 4fy2000.xlw Prepared by: Unda Munk, Info Tech; 10/26/2000
85701 Community Corrections Grant
Community Corrections - Total
66103 Comm Dev User Support
Community Development - Total
GIS-Administration
IT DISC Data Warehouse
IT DISC Enhanced Access
IT DISC GIS
Open Systems Administration
Oracle Administration
CVT - New Development
Equipment inventory
LT. - Disaster Recovery
38000 Health - Immunization
38100 Health - Regional lmmun Registry
Health - Immunization - Total
$.7.83720
$7,637.20
$1.483.78
$1,483.78
$1,797.17
3.713.44
$5,510.81
$31,054.41
156,184.07
94,542.22
§2,31.1,2
$334,952.22
- $54.95
272,695.69
95,210.99
1,959.10
1111.9.1
25100
30001
30002
30003
25200
25400
91516
95456
95885
Wag
$222.62
15.219.22
S41,190.48
41,190.48
41,190.48
10,297.62
10,297.62
10,297.82
10,297.82
$6.644.65
$193.50
517.616.48
$2.515.60
$5,206.62
$222.62
$5,299.22
$164,761.92
$6,644.65
$193.50
$17,616.48
$2,515.60
$83,188.04
INFORMATION TECHNOLOGY- RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER, 2000
Qua DIRECT FUNDS
657 COMMUNITY CORRECTIONS
681 comma & HOME IMPROVEMENT
380 HEALTH IMMUNIZATION - GRANT
010 INFORMATION TECHNOLOGY
Digital Information Service Center
Systems Develop/Support
$370,030.84
Technical Sys/Networking 95689 Database Tech Support $22.935.14
$22,935.14
751
840 MATERIALS MANAGEMENT
870 MEDICAL. CARE FACILITY
004 PA189 P OJECTS
770 PARKS AND RECREATION
695 RISK MANAGEMENT
802 TREASURER- 100% TAX PYWIT FUND
656 WATER & SEWER ACCTG
NON-COUNTY AGENCIES
21012 LT. - Communications
I.T. - Communications - Total
95440 Materials Management
Materials Management - Total
98873 MCF - Support
MCF - Support - Total
PA189 JIMS Circ Ct - 25%
PA189 JIMS Probate 25%
PA189 JIMS Prosecutor - 25%
PA189 JIMS 52/1 DC - .0825%
PA189 JIMS 5212 DC - .0625%
PA189 JIMS 52/3 DC - .0625%
PA189 JIMS 5214 DC - .0625%
PA189 Projects - Total
95419 PRADM-AdminIstration
Parks & Recreation - Total
44039 Rsk-New Development
Risk Management - Total
95310 Delinquent Tax Oracle Fund
95669 Water & Sewer Accfg
Water & Sewer Accfg - Total
90603
90604
90605
90606
90607
90608
90609
Prepared by: Unda Munk, Info Tech; 10/26/2000 4fy2000.xlw
Resolution #00296 November 30, 2000
Moved by Douglas supported by Millard the resolutions on the Consent Agenda
be adopted (with accompanying reports being accepted).
AYES: Appel, Buckley, Causey-Mitchell, Coleman, Dingeldey, Douglas,
Galloway, Garfield, Gregory, Jensen, Law, McPherson, Melton, Millard, Moffitt,
Obrecht, Palmer, Patterson, Sever, Suarez, Taub, Amos. (22)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolutions on the Consent
Agenda were adopted (with accompanying reports accepted).
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 November 30, 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 314h daleof November, 2000.
a. William Caddell, County Clerk