HomeMy WebLinkAboutResolutions - 1997.11.20 - 25147* November 6, 1997
MISCELLANEOUS RESOLUTION #97241
BY: STRATEGIC PLANNING COMMITTEE, DENNIS POWERS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - THIRD QUARTER 1997 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 Strategic Planning Committee; and
WHEREAS the Department of Information Technology has determined the
Third Quarter 1997 data processing development charges to be $588,205 and the
imaging development charge to be $1,897 for the governmental fund County
departments; and
WHEREAS direct charges to non-governmental fund departments and non-
County agencies are $529,873 for the Third Quarter 1997; 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 Third Quarter 1997 Data Processing Development
and approves the third quarter appropriation transfer.
Chairperson, on behalf of the Strategic Planning Committee, I move the
adoption of the foregoing resolution.
RATEGIC PLANNING COMMITTEE
V
Resolution #97241 November 6, 1997
The Chairperson referred the resolution to the Finance and Personnel
Committee. There were no objections.
• FISCAL NOTE (M.R. #97241) November 20, 1997
BY: FINANCE AND PERSONNEL COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - THIRD QUARTER 1997 DEVELOPMENT
APPROPRIATION TRANSFER
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
Pursuant to Rule XII-F of this Board, the Finance and Personnel Committee
has reviewed the above referenced Resolution and finds:
1. Information Technology has completed third quarter Data Processing
Development for governmental fund County departments and requests an
appropriation transfer to the user departments.
2. The transfer has been reviewed by the Strategic Planning Committee.
3. The FY 1997 Budget should be amended, per the attached document
entitled Information Technology Data Processing Development Summary.
4. 1997 Third Quarter Development for the 100% Tax Payment Fund equals
$189,867. This amount reflects a direct reduction of the
Information Technology Professional Services line-item which was not
budgeted. The following budget amendment is required to restore the
line-item.
Revenue
3-63600-181-01-00-2349 Non-Govt. Develop. S 189,867
Expense
4-63600-182-01-00-3128 Professional Serv. 5 189.867
5 -0-
5. The following budget amendment is required to restore the
Information Technology General Fund Budget.
4-10100-901-01-00-9916 Future Space
Requirements $(400,000)
4-10100-181-01-00-6361 Info. Tech.-Development 400,000
5 -0-
FINANCE AND PERSONNEL COMMITTEE
1st Qtr 2nd Qtr 3rd Mr Y.T.D.
(Jan Mar) (ApL=Juns) (JulySept.) TOTAL
a.,
FUND/DIVISION/ACCOUNT DIVISION
DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
4-10100-212-10-00-6367 Clerk
4-21500-312-01-00-6367 Friend of the Court
TOTAL IMAGING DEVELOPMENT
APPROPRIATION
4-10100-181-01-00-6361
4-10100-181-01-00-6367
information Technology
Imaging Development
TOTAL GOVERNMENT:
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
3RD QUARTER 1997
4-22100-178-01-00-6361
4-10100-112-01-00-6361
4-10100-511-01-00-6361
4-29230-165-01-00-6361
4-21500-127-05-00-6361
4-10100-311-01-00-6361
4-10100-214-01-00-6361
4-10100-213-01-00-6361
4-10100-215-01-00-6361
4-10100-191-01-00-6361
4-10100-115-01-00-6361
4-10100-111-01-00-6361
4-10100-192-01-00-6361
4-10100-611-01-00-6361
4-10100-194-01-00-6361
4-10100-148-01-00-6361
4-10100-141-15-00-6361
4-22100-141-30-00-6361
4-10100-126-01-00-6361
4-10100-126-21-00-6361
4-21500-312-01-00-6361
4-22100-162-01-00-6361
4-22100-162-20-00-6361
4-10100-169-01-00-6361
4-10100-154-01-00-6361
4-10100-344-01-00-6361
4-10100-341-01-00-6361
4-10100-411-01-00-6361
4-10100-124-01-00-6361
4-10100-138-03-00-6381
4-10100-127-01-00-8361
4-10100-513-03-00-6361
4-10100-433-10-00-6361
4-10100-138-01-00-6361
4-10100-221-01-00-6361
4-10100-173-01-00-6361
4-10100-322-01-00-6361
4-10100-323-01-00-6361
4-10100-324-01-00-6361
4-10100-325-01-00-6361
Animal Control
Auditing
Board of Commissioners - Adm.
Children's Village
Child Support/FOC/Reimbursement
Circuit Court - Administration
Clerk Register of Deeds
Clerk - Elections
Clerk - Jury Commission
Community & Economic Development
Corporation Counsel
County Executive
Development & Planning Division
Drain Commissioner
Equalization Division
Facility Engineering
Facilities Management - Administration
Facilities Management - EMS
Fiscal Services - Admin
Fiscal Services - General
Friend of the Court
Health - CHAMPS
Health Environmental
Medical Examiner
Personnel
Probate Court - Estates & Mental Health
Probate Court - Juvenile
Prosecuting Attorney
Purchasing Division
Records Retention
Reimbursement Division
Research Library
Sheriff
Support Services
Treasurer
Veteran's Services
52/1 (Nand Court
52/2,District Court
52/3 District Cowl
52/4 District Court
$0.00
1,384.00
102.30
3,053.00
1,348.50
31,632.00
19,726.00
7,490.50
6,781.40
18.60
142.00
46.50
321.40
585.90
90,437.80
27.90
9.30
344.10
99,142.10
9,828.30
74,079.00
13,013.00
2,079.00
2,130.00
29,341.60
21,168.00
14,822.50
7,052.00
8,162.00
365.10
17,085.50
24140
77,583.00
1,126.00
37,328.50
130.20
7,280.14
7,280.14
7,280.14
7,280.08
$1,463.00
232.50
27.90
461.50
0.00
40,874.00
14,147.00
8,555.50
3,468.00
0.00
0.00
0.00
176.70
313.40
96,197.50
0.00
0.00
0.00
94,013.20
25,671.60
(4.653.40)
11,821.50
308.00
5,502.50
50,468.70
52,981.00
2,772.00
7,544.50
2,271.50
1,155.00
33,816.50
. 176.70
33,330.00
462.00
27,228.50
0.00
5,905.51
5,905.51
5,905.51
5,905.47
$0.00
370.50
0.00
2,236.50
0.00
55,092.50
26,824.50
4,872.00
7,270.60
0.00
0.00
0.00
0.00
232.50
126,015.00
0.00
0.00
0.00
71,663.30
26,038.40
42,725.10
20,596.10
1,001.00
14,163.00
58,314.30
29,356.50
2,541.00
7,858.50
1,155.00
346.50
14,746.00
0.00
33,310.00
0.00
20,848.00
0.00
5,157.15
5,157.15
5,157.15
5,157.08
1,463.00
1,987.00
130.20
5,751.00
1,348.50
127,598.50
60,697.50
20,918.00
17,520.00
18.60
142.00
46.50
498.10
1,131.80
312,650.30
27.90
9.30
344.10
264,818.60
61,538.30
111,950.70
47,430.60
3,388.00
21,795.50
138,124.60
103,505.50
20,135.50
22,455.00
11,588.50
1,866.60
65,648.00
418.50
144,223.00
1,588.00
85,405.00
130.20
18,342.80
18,342.80
18,342.80
18.342.80
107.249.20 33t20= • MUSA 1.731.863.40
372.00 46.50 279.00 697.50
325.50 651.00 1.818.20 2-594-70
697.,10 OHIO 1,1197-20/ 3.292.20
(607,249.30) (536,208.80) (588,205.30) (1,731,663.40)
(697.50) (697-50) (1.897 28) (3.292.20)
SILOO MOD MOMS MOO
09/30/97:11:28 AM 3-97DEV.WK4
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
3RD QUARTER 1997
FUND/DIVISION/ACCOUNT
lit Qtr 2nd Qtr 3rd Qtr Y.T.D.
DIVISION (Jan -Mar) (Apr - June) (JUIY-SligJ TOTAL
Community Development Grant 130.20 0.00 0.00 130.20
Community Mental Health - Admin 18,552.20 10,379.60 18,044.90 46,976.70
Facilities Maintenance & Operations 884.60 344.10 1,168.80 2,397.50
Garage 2,695.00 2,271.50 500.50 5,467.00
Health Immunization 14,399.00 7,854.00 5,659.50 27,912.50
Information Technology 220,034.30 132,409.70 283,585:10 636,029.10
NCSC Integrated Project 1,999.50 0.00 • 0.00 1,999.50
Oakland County International Airport 186.00 0.00 65.10 251.10
Pants and Recreation - Addison Oaks 1,540.00 0.00 0.00 1,540.00
Parks and Recreation - Administration 232.50 2,464.00 1,841.50 4,538.00
Parks and Recreation - Recreation Admin 1,347.50 0.00 0.00 1,347.50
Probate - PA 189 Fund 6,160.00 0.00 0.00 6,160.00
Risk Management 93.00 0.00 0.00 93.00
Water & Sewer Accounting 9,894.50 , 9,779.00 1,418.00 21,091.50
Non-County Agencies 9,219.10 17,487.00 27,632.50 54,338.60
100% Tax Payment Fund 256,505.50 272,893.50 1119.887.00 DIM=
DIRECT CHARGES FOR DATA 1141172.80 $455,182.40 $529752.10 1.521.535.20
PROCESSING DEVELOPMENT
11.151.8191Q $11112.7112.70 s1,tiLasS49 1214.413.10 TOTAL DEVELOPMENT CHARGES
3-97DEV.&“ 09/30/97; 09:10 AM
31075
31077
95559
95692
95693
44001
44002
95554
96001
$370.50
$2,236.50
$55,092.50
$26,824.50
$4,872.00
$279.00
$7,270.60
$232.50
$126,015.00
$71,663.30
$26,038.40
$42,725.10
$1,618.20
$20,596.10
$1,001.00
$14,163.013
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER, 1997
Cot./ GOVERNMENTAL FUNDS
620 AUDITING
665 CHILDRENS VILLAGE
420 CIRCUIT COURT
720 CLERK / REGISTER OF DEED$
440 CLERK ELECTIONS,
722 CLERK -IMAGING
410 CLERK -JURY COMMISSION
730 DRAIN
740 EQUALIZATION
660 FISCALIEBILICESAMIN
570 FISCALSERVICESz_OENERAL
470 FRIEND OF THE COURT
471 FRIEND OF THE CT IMAGING
640 HEALTH DEPARTMENT
843 NEMMEENZEIGNMENIAI.
872 MEDICAL EXAMINER
95468 Auditing - Cust Support
Auditing - Total
95665 Childrens Village
Childrens Village - Total
95195 Cir Court Admin
95452 Assignment Clark
Circuit Court - Total
95161 Vital Stats Index
95169 Circuit Court System
95493 Reg Deeds System Maintenance
95558 User Support/ROD
Clerk/Reg of Deeds - Total
95443 Elections
Elections - Total
95158 Clerk - Imaging
Clerk - Imaging - Total
95512 Jury Commission
Jury Commission - Total
28009 Drain - Administration
Drain - Total
Equal - Development
EAC-C/I Upgrade
User Support/Equal
Equal-GIS Development
Equal-System Maintenance
Equalization - Total
Oakland Co. Payroll
FIMIS Accounting
Accounting - User Support
Human Services - Accrg
Fiscal Services Admin - Total
44076 Bud-System/Customer
96003 Human Resources - Budget
Fiscal Services - General - Total
34041 Friend of the Court
Friend of the Court - Total
34042 FOC Develop Image
FOC Develop Image - Total
37025 CHAMPS - P.O.P.
Health - Total
37002 Environmental
Health-Environmental - Total
87202 Med Exam - Cust Support
Medical Examiner - Total
$370.5Q
$2.236.50
$42,461.00
12.631.5Q
2,789.00
20,248.50
2,810.50
97650
$4.872.00
8279.00
szania
S232.50
44,234.50
38,365.00
33,633.00
731.50
9.15.1.011
$14,987.50
3,927.00
980.00
$1.788.8Q
154.00
S25.084.40
$42.72510
51618.20
$20,596.10
stoats&
114163.00
1 3-97DEV.VVIC4 09/30/97; 09:15 AM
INFORMATION TECHNOLOGY • RESERVE FUND
DEVELOPMENT ,/ SUPPORT DETAIL -THIRD QUARTER, 1997
Qat' GOVERNMENTAL FUNDS
680 PERSONNEL 44041 Per-System/Customer Support $2,378.50
44042 Per-System Maintenance $2,425.50
95560 Personnel - Employee 1,741.50
96002 Human Res. - Personnel 5.1.7111110
Personnel - Total ' $58,314.30
480 PROBATE COURT 95200 Probate - Admin $1,071.00
95202 Probate - Estates 11,858.00
95203 Probate - Field Services 15,824.00
95206 Probate - Psych Clinic 603.50
Probate - Total $29,356.50
481 PROBATE-JUVENILE 95191 Probate Crt Juv Div $2.54100
Probate Juvenile - Total $2,541.00
145 PROSECUTOR i 95619 PROMIS $325.50
95622 Prosecutor/Executive 7.533.00
Prosecutor - Total $7,858.50
690 PURCHASING 95663 Purchasing , ., 11155.00
• Purchasing - Total $1,155.00
637 RECORDS RETENTION 95637 Records Retention $340.50
Records Retention - Total $346.50
650 REISIRUBSENIEta 95469 Reimbursement Div 1,116.00
95470 Reimbursement System S13.53010
Reimbursement - Total $14,746.00
195 SHERIFF 95476 Jail Management System. $32,501.50
97163 Sheriff . ,
Sheriff - Total $33,310.00
600 TREASURER 44060 Ire-Customer/issue Mgmt $1,116.50
44061 Ire-System/Customer Support 940.00
95303 Del Tax System Maintenance 577.50
95307 Del Tax Rewrite 848.00
95313 DIX-Enhance/Development 1,387.00
95483 Fund Management • 325.50
95523 User Support - Treasurer 6,935.00
95561 User Support/Del Tax 11.9.18.50
Treasurer - Total $20,848.00
540 5211 DISTRICT COURT- NOVI 95527 DC Suprt -25%-52/1 S515Z.15
52/1 District Court - Total $5,157.15
550 52/2 DISTRICT COURT. CLARKSTON 95528 DC Suprt -25%-5212 $5 157.15
52/2 District Court - Total $5,157.15
560 52/3 DISTRICT COURT. ROCHESTER 95529 DC Suprt -25%-52/3 $5,157.15
52/3 District Court - Total $5,157.15
530 5214 DISTRICT COURT. TROY 95530 DC Suprt -25%-52/4 $5157.05
52/4 District Court-Total $5,157.05
09/30/97; 09:15 AM 2 3-97DEV.WK4
1.18.044.90
;1,168.80
$500.50
15.659.50
$11,299.50
151,205.80
3,736.50
81,890.00
46.50
5,005.00
1,488.00
20,692.50
885.50
461.50
3.388.99
$2.11931:10
65.10
192.50
346.50
1,116.50
11.4111119
1119.997.114
$18,044.90
$1,168.80
$500.50
$5,659.50
$11,903.00
$268,799.10
$2,883.00
$65.10
$1,841.50
$1,418.00
$189,867.00
$27,632.50
INFORMATION'TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER, 1997
Cusij DIRECT FUNDS
663 GMEEADMIN
750 FAC MAINT & OPERATIONS
655 GARAGE
380 HEALTH IMMUNIZATION - GRANT
010 INFORMATION TECHNOLOGY
Administrative Services
Systems Develop/Support
Technical Sys/Networking
653 0.C. INTERNATIONAL AIRPORT
770 PARKS & REC ADMINISTRATION
656 WATER & SEWERACCoUNTINQ
802 100•A TAX PAYMENT FUND
NON-COUNTY AGENCIES
66306 CMH System Development
CMH Admin - Total
75503 FMO Development
FM&O - Total
65498 Garage Support
Garage - Total
38000 Health - Immunization
Health - Immunization - Total
91514 System Support -Admit'
95485 Job Acct System Int
02000 Year 2000 Project
25200 Open Systems Administration
25400 Oracle Administration
31008 Dev Billed to Private Sector
84200 Health Grant Overhead
91501 System Support - Finance/Admin
91503 System Support - Office Automation
91512 System Support - Health Plus
95456 Equipment Inventory
95472 FDC Wheel Count Development
95689 Database Tech Support
65301 Airport User Support
O.C. Intri'l Airport - Total
95415 PRTS - Tech Support
95416 PRFtA - Rec Admin
95418 PRAO - Addison Oaks
95419 PRADM-AdmInIstration
Parks & Roc Admin - Total
95669 Water & Sewer Acctg
Water & Sewer Acctg - Total
95310 Delinquent Tax Oracle Fund
100% Tax Payment Fund - Total
3 3-970EV.VVK4 09/30/97; 09:18 AM
HE FOREGOING RESOLUTION
001,tih
Date
'ers .CtY Executive
Y7REB
ooKe P
PPR
Resolution #97241 November 20, 1997
Moved by Powers supported by Millard the resolution be adopted.
AYES: Moffitt, Obrecht, Palmer, Powers, Schmid, Taub, Wolf, Amos, Coleman,
Dingeldey, Douglas, Garfield, Holbert, Huntoon, Jacobs, Jensen, Johnson,
Kingzett, Law, McCulloch, Millard. (21)
NAYS: None. (0)
A sufficient majorit y having voted therefor, the resolution was adopted.
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Lynn D. Allen, Clerk of the County of Oakland, do hereby certify that the
foregoing resolution is a true and accurate cop y of a resolution adopted by the
Oakland County Board of Commissioners on November 20, 1997 with the ori g inal
record thereof now remainin g in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the
County of Oakland at Pontiac, Michi gan this 20th day of November 1997.
LY17.1n167Allen, Count y Clerk