HomeMy WebLinkAboutResolutions - 2000.09.21 - 26234MISCELLANEOUS RESOLUTION #00234 September 21, 2000
BY: Finance Committee, Sue Ann Douglas, Chairperson
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FY 2000 THIRD QUARTER 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 Third
Quarter FY 2000 data processing development charges to be $1,680,745 and the
imaging development charge to be $47,909 for the General Fund/General Purpose
County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund departments
are $134,135 and non-county agencies are $26,665 for the Third 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 Third Quarter FY 2000 Data Processing Development
Report and approves the Third 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 and
Millard absent.
ACCOUNT*
General Fund moil
242-201200-20001-6030
2-32401200-20001-6030
242-401200-20001-6030
2-32-501200-20001-6030
2-17402200-10001-6030
2-11-220100-10000-6030
2-51-211000-10000-6030
241-101200-10001-6030
2-21-220100-01000-6030
2-21-230100-01000-6030
2-21-250100-01000-8030
2-21-221000-01000-6030
2-21-240100-01000-8030
2-21-220500-01000-6030
2-11-210100-01000-8030
2-81-211001-10000-6030
2-12-240000-44100-8030
2-12-601200-10001-6030
2-12-821200-10001-6030
2-16-912000-15000-6030
2-17-501200-10001-6030
2-15-40k00-10001-8030
2-19-221000-10000-8030
2-34-401200-40001-6030
2-34-101200-40001-8030
2-41-211000-10000-6030
2-12-401200-40010-6030
2-12-701200-10001-6030
2-43-023301-20000-6030
• 2-13-138201-00010-6030
2-22-221120-01000-6030
2-17-302200-30001-6030
Friend Of the Court Fund 12151
2-31-201200-10004-8030
Health Fund 12211 .
2-23-221112-65001-6030
2-16-201200-33100-8030
2-16-234200-54600-6030
2-18-220200-67000-6030
DIVISION
52/1 District Court
52/2 District Court
52/3 District Court
52/4 District Court
Animal Control
Auditing
Board of Commissioners - Adm.
Circuit Court -Administration
Clerk - Admin
Clerk - Bedlam
Clerk - Jury Commission
Clerk - Legal Records
Clerk - Register of Deeds
Clerk - Vital Statistics
County Executive
Drain Commissioner
Equalization Division
Fiscal Services - Admit
Fiscal Services - General
Medical Examiner
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
CLEWS - EMS
Health
Health - Clinic
Health Environmental
Sub-Total Fund 221
Juvenile Maintenance Fund 12931
2-16-501200-25001-8030 Children's Village
Sub-Total Fund 293
18-838111-10000-0735
2-21-221000-01000-6039
2-31-201200-10004-6039
2-34-101200-40001-8039
18438111-10000-0573
90-290000-25000-8030
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
3RD QUARTER 2000
ist Qtr 2nd Qtr 3rd Qtr 4th Qtr
Oct - Dec Jan - Mar Am - June 41I. '_-...Itiat yap,
•
18,869.67 4,999.50 6,389.41 0.00 28,258.58
18,869.67 4,999.50 6,389.41 0.00 28,258.58
16,869.67 4,999.50 8,389.41 0.00 28,258.58
16,869.64 4,999.47 6,389.42 0.00 28,258.53
1,638.00 89.05 0.00 0.00 1,727.05
54.50 0.00 54.95 0.00 109.45
27.25 0.00 0.00 0.00 27.25
58,849.75 64,062.11 59,516.03 0.00 182,427.89
168.00 358.21 1,202.20 0.00 1,728.41
61,495.20 61,024.18 96,979.82 0.00 219,499.20
44,239.35 45,490.11 24,998.74 0.00 114,728.20
10,930.50 11,530.13 27,301.74 0.00 49,782.37
44,797.50 19,022.94 12,399.40 0.00 78,219.84
1,687.00 4,928.09 9,307.99 0.00 15,923.08
27.47 0.00 0.00 27.47
571.00 54.95 10,302.38 0.00 10,928.31
77,778.00 81,075.93 110,714.92 0.00 269,588.85
123,018.05 123,561.89 328,823.83 0.00 575,403.57
20,020.90 12,707.23 106,312.07 0.00 139,040.20
27,718.50 19,699.04 33,215.83 0.00 80,633.37
54.50 445.25 89.05 0.00 588.80
38,888.30 25,511.03 204,898.49 0.00 269,095.82
981.00 1,016.68 0.00 0.00 1,997.68
13,472.00 12,757.08 12,180.89 0.00 38,409.97
21,772.00 14,012.17 9,193.03 0.00 44,977.20
18,027.00 24,337.28 24,205.42 0.00 64,569.68
1,491.00 1,123.57 5,779.68 0.00 8,394.23
13,890.00 18,479.13 4,203.82 0.00 34,572.75
44,462.00 55,496.24 63,043.54 0.00 163,001.78
1,535.00 9,764.93 6,023.94 0.00 17,323.87
238,047.00 129,759.68 128,000.94 0.00 493,807.82
27.25 0.00 1),N 0A 27.25
931,117.20 754,330.32 1,302,105.91 0.00 2,987,553.43
202.680.35 256 500 25 278.374.91 0 00 737,535.51
202,860.35 256,500.25 278,374.91 0.00 737,535.51
27.25 2,359.82 0.00 0.00 2,387.07
22,955.00 3,588.76 5,558.26 0.00 32,102.02
356.20 '4,545.35 0.00 4,901.55
22.092.00 38.935.85 87.048.99 0 00 148,074.84
48,712.25 45,240.63 97,150.60 0.00 189,103.48
3.291.00 4,059.42 3,113.96 0.00 10,464.38
3,291.00 4,059.42 3,113.96 0.00 10,484.38
1.182.142.80 1 060 130.62 1.650.745.311 2,Qg 3,923,018.80
38,598.40 36,026.58 23,079.86 0.00 95,704.84
81,545.84 45,297.89 21,402.84 0.00 128,246.37
7.877.76 7.643.20 3.426.86 pal 18.947.70
108.022.00 88.967.74 47.908.911 UR 242,1198.71
(1,288,184.80) (1,149,098.37) (1,728,654.34) 0.00 (4165.917.51)
$0.00 $0.00 o.00
Prepared by: Linda Munk, Info Tech; 7/18/2000; 9:19 AM
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
3RD QUARTER 2000
let Qtr 2nd Qtr 3rd Qtr 4th Qtr
ACCOUNT* DIVISION Oct - Dec Jan - Mar Aor - June JUIv - Seot Y.T.D,
Community Corrections
Community & Home Improvement
Facilities Makitenance & Operations
FOC - Medical Support
Health Immunization
I.T. - Telephone Communications
Materials Management
Medical Care Facility
PA189 Projects
Parks and Recreation - Administration
Print Shop
Risk Management
Treasurer - 100% Tax Payment Fund
Water & Sewer Accounting
1,343.85 5,933.12 0.00 7,276.77
1,008.25 851.81 714.42 0.00 2,574.48
5,015.75 1,543.38 0.00 0.00 8,559.13
116.00 omo 0.00 0.00 116.00
18,946.50 19,235.19 15,459.21 0.00 51,640.90
54.50 0.00 0.00 0.00 54.50
1,372.50 623.35 2,849.80 0.00 4,845.45
3,017.00 12,816.18 12,529.90 0.00 28,383:08
15,967.00 43,589.89 88,043.10 0.00 127,579.79
1,847.25 8,142.67 (3,598.92) 0.00 4,391.00
521.07 0.00 621.07
9,646.00 0.00 9,546.00
12,358.54 0.00 12,358.54
9 201 50 2864.87 9.781.4Z LW 1.847.79
18-838111-10000-0715 DIRECT CHARGES FOR DATA 654.546.25 688.990.79 $134.135.48
PROCESSING DEVELOPMENT
$0.00 MEIN
TOTAL DEVELOPMENT CHARGES 51.342.711.05 $1.238.089.15 )1.862.789.80 SILAS 4.1443A0.E
18-838111-10000-0429 Sidwell 31,020.50 20,525.61 28,865,18 0.00 78,211.27
18-636111-10000-0759 Community Mental Health - Admin 4,057.00 445.28 0.00 0.00 4,502.28
18-63Er111-10000-0759 Traffic Improvement Association &778.00 27.47 0.00 9,2o 3.805.47
TOTAL NON-COUNTY AGENCIES
(Information Purposes Only) Information Technology
2181_5.50 20.998.34 26.865.18 QQQ 88,519.00
078,274.05 905,547.94 891,176.07 0.00 2,574,998.06
Prepared by: Linda Munk, Info Tech; 7/18/2000; 9:19 AM 3f
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2000
Cust # GOVERNMENTAL FUNDS
620 AUDITING 95468 Auditing-Cust Supt $54.95
Auditing - Total $54.95
665 CHILDRENS VILLAGE 95665 Childrens Village $3 113 96
Childrens Village - Total $3,113.96
420 CIRCUIT COURT 95195 Cir Court Admin $34,828.40
95452 Assignment Clerk 24 687.63
Circuit Court - Total $59,516.03
725 CLERK - ADMIN 72500 Clerk - Admin $1.202.20
Clerk - Admin - Total $1,202.20
720 CLERK / REGISTER OF DEEDS 95493 Reg Deeds System Maintenance $9,452.67
95558 User Support/ROD 2.946,73
Clerk/Reg of Deeds - Total $12,399.40
440 CLERK ELECTIONS 95443 Elections $96.979.82
Elections - Total $96,979.82
722 CLERK - IMAGING 65420 Clerk- Image Replace - 21% $20,163.26
95158 Clerk - Imaging L916.40
Clerk - Imaging - Total $23,079.66
410 CLERK - JURY COMMESION 95512 Jury Commission $24.998.74
Jury Commission - Total $24,998.74
724 CLERK - LEGAL RECORDS 95189 Circuit Court System $27.301.74
Clerk - Legal Records - Total $27,301.74
723 CLERK - VITAL STATISTICS 95161 Vital Stats Index $9.307,99
Clerk - Vital Statistics - Total $9,307.99
730 DRAIN COMMISSIONER 28009 Drain - Administration $10.302.36
Drain Commissioner - Total $10,302.36
740 EQUALIZATION 31071 EMA - Development $15,327.49
31075 Equal - Development 22,898.28
95559 User Support/Equal 24,692.59
95690 Personal Property 4,478.83
95693 Equal-System Maintenance 43 317.73
Equalization - Total $110,714.92
660 FISCAL SERVICES ADMIN 44021 FS-System/Customer Support $8,297.35
44022 FS-System Maintenance 124,486.50
96001 Human Services - Accfg 196 039.78
Fiscal Services Admin - Total $328,823.63
670 FISCAL SERVICES - GENERAL 44076 Bud-SystemCustomer Support $1,513.85
44077 Bud-System Maintenance 6,778.33
96003 Human Resources - Budget 98.019.89
Fiscal Services - General - Total $106,312.07
Prepared by: Unda Munk, Info Tech; 7/1812000; 9:33 AM 1 3fy21
843 HEALTH - ENVIRONMENTAL
872 MEDICAL EXAMINER
710 MSU EXTENSION - OAKLAND
680 PERSONNEL $8,658.71
196.039.78
$204,698.49
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2000
Cust# GOVERNMENTAL FUNDS
470 FRIEND OF THE COURT
471 FRIEND OF THE CT IMAGING
840 HEALTH DEPARTMENT
34041 Friend of the Court
34046 FOC - Professional Services
Friend of the Court - Total
34044 FOC Image Operations
65410 FOG-Image Replace-74%
FOC Develop Image - Total
37025 CHAMPS - P.O.P.
96841 Health South PC Net
96842 Health - Admin
Health-Total
$277,687.96
686.95
$278,374.91
$21,402.64
$5,558.26
$1,536.12
19 866.52
$249.35
54.95
5.253.96
845 HEALTH - CLINIC 37007 Clinic $4.545.35
Health - Clinic - Total $4,545.35
37002 Environmental $42,308.01
84200 EH - Projects 44 738.98
Health-Environmental - Total $87,046.99
87202 Med Exam - Gust Support $33.215.83
Medical Examiner - Total $33,215.83
95676 MSU Ext Equipment Maintenance $89.05
MSU Extension - Oakland - Total $89.05
95556 Personnel User Supt
96002 Human Res. - Personnel
Personnel - Total
480 PROBATE COURT 95200 Probate - Admin $412.17
95202 Probate - Estates 7,791.28
95203 Probate - Field Services 3.977,44
Probate - Total $12,180.89
482 PROBATE - IMAGING 48200 Probate - Imaging $3,426.66
Probate - Imaging - Total $3,426.66
481 PROBATE - JUVENILE 95191 Probate Crt Juv Div $9.193.03
Probate Juvenile - Total $9,193.03
145 PROSECUTOR 95619 PROMIS $2,983.53
95622 Prosecutor/Executive 21 221.89
Prosecutor - Total $24,205.42
690 PURCHASING 44026 Pur-System/Customer Support $445.25
44027 Pur-System Maintenance 109.91
44029 Pur-New Development 5,224.50
Purchasing - Total $5,779.66
Prepared by: Unda Munk, Info Tech; 7/18/2000; 9:33 AM 2 3fy
$4203.62
$63.043.54
$6.023.94
$9,471.63
1,813.53
1,083.85
24,480.95
2,445.49
4,463.49
82,242.00
$6,389.41
$6.389.41
$6,389.41
$6.389.42
$4,203.62
$63,043.54
$6,023.94
$126,000.94
$6,389.41
$6,389.41
$6,389.41
$6,389.42
INFORMATION 'TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER, 2000
Cust # GOVERNMENTAL FUNDS
650 REIMBURSEMENT
195 SHERIFF
445 SUPPORT SERVICES
600 TREASURER
540 52/1 DISTRICT COURT - NOVI
550 5212 DISTRICT COURT - CLARKSTON
560 5213 DISTRICT COURT - ROCHESTER
530 5214 DISTRICT COURT- TROY
95470 Reimbursement System
Reimbursement - Total
97163 Sheriff
Sheriff - Total
44500 Support Services User Support
Support Services - Total
44012 Tre-Data Warehousing
44061 Tre-System/Customer Support
44062 Tre-System Maintenance
44063 Tre-System Enhancements
44064 Tre-New Development
95303 Del Tax System Maintenance
95561 User Support/Del Tax
Treasurer - Total
95527 DC Suprt-24%-52/1
52/1 District Court - Total
95528 DC Suprt -25%-52/2
52/2 District Court - Total
95529 DC Suprt -25%-5213
52/3 District Court - Total
95530 DC Suprt -25%-5214
52/4 District Court - Total
Prepared by: Unda Munk, Info Tech; 7/18/2000; 9:33 AM 3 3fy2000actw
Systems Develop/Support
Technical Sys/Networking
640 MATERIALS MANAGEMENT
870 MEDICAL CARE FACILITY
004 PA189 PROJECTS
$32,141.59
$2,849.60
$12.529.90
$431,929.94
$32,141.59
$2,849.60
$12,529.90
770 PARKS AND RECREATION
843 PRINT SHOP
695 RISK MANAGEMENT
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2000
cust# DIRECT FUNDS
657 COMMUNITY CORRECTIONS 65701 Community Corrections Grant $5.933.12
Community Corrections - Total
661 COMMUN & HOME IMPROVEMENT 66103 Comm Dev User Support $714.42
- Community Development - Total
380 HEALTH IMMUNIZATION - GRANT 38000 Health - Immunization $2,475.61
38100 Health - Regional Immun Registry 12 983.60
Health - Immunization - Total
$5,933.12
$714.42
$15,459.21
010 INFORMATION TECHNOLOGY
Digital Information Service Center 25100 GIS-Administration 22,856.24
30001 IT DISC Data Warehouse 120,947.98
30002 IT DISC Enhanced Access 44,254.18
30003 IT DISC GIS 39,046.14
$227,104.54
02000 Year 2000 Project $23,135.71
25200 Open Systems Administration 3,681.99
25400 Oracle Administration 259,714.19
91516 CVT - New Development 134,426.87
95456 Equipment Inventory 10,641.45
95685 I.T. - Disaster Recovery 329.73
95689 Database Tech Support
95440 Materials Management
Materials Management - Total
98873 MCF - Support
MCF - Support - Total
90603 PA189 JIMS Ciro Ct - 25% $17,010.78
90604 PA189 JIMS Probate - 25% 17,010.78
90605 PA189 JIMS Prosecutor - 25% 17,010.78
90606 PA189 JIMS 52/1 DC - .0625% 4,252.69
90607 PA189 JIMS 52/2 DC - .0625% 4,252.69
90608 PA189 JIMS 52/3 DC - .0625% 4,252.89
90609 PA189 JIMS 52/4 DC - .0625% 4,252.69
PA189 Projects - Total $68,043.10
44068 PRADMIN-Sys Enhancements ($3,918.21)
95169 PRADMIN-Admin Services $274.77
95419 PFtADM-Administration $44.52
($3,598.92)
64301 Printing Support $521.07
Print Shop - Total $521.07
44039 Rsk-New Development $9,546.00
Risk Management - Total $9,546.00
Prepared by: Linda Munk, Info Tech; 7/18/2000; 9:35 AM 4 3fy2000.xlw
$9,781.42
$12,356.54
$9,781.42
$12,356.54
$26,665.16
INFORMATION tECHNOLOdY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 2000
Cust# DIRECT FUNDS
656 WATER & SEWER ACCTG 95669 Water & Sewer Accfg
Water & Sewer Acct'g - Total
602 TREASURER-100% TAX PAYMT FUND 95310 Delinquent Tax Oracel Fund
NON-COUNTY AGENCIES
Prepared by: Uncle Munk, Info Tech; 7/18/2000; 9:46 AM 5 3fy2000.x
Resolution #00234 September 21, 2000
Moved by Palmer supported by Coleman the resolutions on the Consent Agenda
be adopted (with accompanying reports being accepted).
AYES: Appel, Causey-Mitchell, Colasanti, Coleman, Dingeldey, Douglas,
Galloway, Garfield, Gregory, Law, McCulloch, 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 September 21, 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 21s day idf September, 2000.
Gr William Caddell, County Clerk