HomeMy WebLinkAboutResolutions - 2004.08.05 - 27429MISCELLANEOUS RESOLUTION 104186 August 5, 2004
BY: GENERAL GOVERNMENT COMMITTEE, WILLIAM PATTERSON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - THIRD QUARTER 2004
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 2004 data processing development charges to be
$1,313,373.45 and the imaging development charge to be $56,209.00 for
the General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund
departments are $461,664.79 and non-county agencies are $0 for the
Third Quarter 2004; and
WHEREAS an appropriation transfer to General Fund/General Purpose
County departments is needed to fund these development charges; and
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of
Commissioners has reviewed the Third Quarter 2004 Data Processing
Development Report and approves the Third Quarter appropriation
transfer as specified on the attached schedule.
Chairperson, on behalf of the General Government Committee, I move the
adoption of the foregoing resolution.
GENERAL GOWERNMENT
Mi
CO ITTEE
4 fr
General Government Committee Vote:
Motion carried on a roll call vote with Coulter and Hatchett absent.
ACCOUNT 0 DIVISION
1st Ott
Oct - Dec
2nd Qtr
Jan - Mar
3rd Qtr
Apr - JUne
41h Ott
July - Sept
GOVERNMENTAL FUNDS
General Fund [101)
2-32-201200-20001-6030
2-32-301200-20001-6030
2-32-401200-20001-6030
2-32-501200-20001-6030
2-17-802200-80001-6030
2-11-220100-10000-6030
2-21-220100-10000-6030
2-21-230100-31000-6030
2-21-250100-01000-6030
2-21-221000-01000-6030
2-21-240100-11000-6030
2-21-220500-40000-6030
2-19-210000-10000-6030
2-17-402200-70001-6030
2-11-250100-20000-6030
2-35-220000-12000-6030
2-35-244000-31100-6030
2-35-244000-33000-6030
2-35-24300-32000-6030
2-35-242000-11000-6030
2-35-242000-44000-6030
2-35-242000-43000-6030
2-35-243000-11000-6030
2-35-230000-22100-6030
2-35-230000-31200-6030
2-35-230000-21100-6030
2-35-230000-21200-6030
2-35-230040-22200-6030
2-35-210000-11000-6030
2-61-211001-10000-6030
2-11-101112-65001-6030
2-12-240000-41000-6030
2-12-601200-10001-6030
2.15-402200-10001-6030
2-13-138502-15100-6030
2-17-912000-15000-6030
2-17-501200-50001-6030
2-34-101200-40001-6030
2-34-403200-40005.6030
2-34-101200-31100-6030
2-34-101200-31200-6030
2-41-211000-41700-6030
2-12-401200-40010-6030
2-13-138203.12000-6030
2-12-701200-34000-6030
2-43-023301-20000-6030
2-43-023601-30000-6030
2-13-138203-15100-6030
2-22-221120-01000-6030
540 101
550 101
560 101
530 101
630 101
620 101
725 101
440 101
410 101
724 101
720 101
723 101
785 101
522 101
430 101
495 101
505 101
474 101
484 101
487 101
492 101
491 101
483 101
499 101
420 101
497 101
498 101
500 101
493 101
730 101
900 101
740 101
660 101
680 101
641 101
872 101
710 101
509 101
510 101
481 101
479 101
145 101
690 101
837 101
650 101
195 101
191 101
445 101
600 101
Health Fund 12211
840 221 2-16-201200-33100-6030
843 221 2-16-220200-67000-6030
$99.00 $462.00 $0.00
$99.00 $462.00 10.40
$1,099,261.22 11.214,034.53 $1,313,373.45
$561.00
$0.00 1561.00
$0.00 $3,526.729.20
Juvenile Maintenance fund [2931
665 293 2-16-501200-25001-6030
12931
Children's Village
Sub-Total Fund 293
18-636111-10000-0735 DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
3RD QUARTER 2004
52/1 - District Court
5212 • District Court
52/3 - District Court
52/4 - District Court
Animal Control
Auditing
Clerk - Admin
Cleric - Elections
Clerk - Jury Commission
Clerk - Legal Records
Clerk - Register of Deeds
Clerk - Vital Statistics
Community & Economic Development
Community Corrections Admin
Corporation Counsel
Courts-Business Division
Courts-FD - Judicial
Courts-FD Juvenile Support
Courts-FD Juvenile Referees
Courts-FD-Court Services-Admin
Courts-FD-Court Services-Adoptions
Courts-FD-Court Services-Youth Assistance
Courts-FD-Judicial Support-Admin
Courts-GJ-Assignment
Courts-GJ-Family Support
Courts-GJ-Judicial
Courts-GJ-Judicial Support
Courts-GJ-Mediation
Courts-Judicial Administration
Drain Commissioner
Emergency Response & Prep Unit
Equalization Division
Fiscal Services - Admin
Human Resources
Materials Management - Gen Fund
Medical Examiner
MSU Extension - Oakland
Probate - Judicial Admin
Probate-Estates/Mental Health Support
Probate-FD-Judicial
Probate-ED-Judicial Support
Prosecuting Attorney - General Prosecution
Purchasing
Records Retention
Reimbursement Division
Sheriff
Sheriff - CLEWS
Support Services
Treasurer
Sub-Total Fund 101
Health
Health Environmental
Sub-Total Fund 221
$10,732.70 $12,080.19 $8,971.24
510.732.70 $12,080.19 $8,971.24
$10,732.70 $12,080.19 $8,971.24
$10.732.64 $12,080.14 $8,971.16
$3,348.00 $2,014.00 $5,912.00
$0.00 10.00 $0.00
$1,597.50 10.00 $1,537.50
$4,270.00 $21,262.00 $35,151.60
$17,505.00 $2.148.00 $15,478.40
$22.031.50 $17,320.00 $15,864.25
$10,600.00 $10,342.00 $3,355.00
$13,822.00 310,260.00 $13,150.50
$1,920.00 $7,296.00 $4,134.50
$25,108.00 $25,828.00 $54,130.00
$2,318.00 $2,379.00 $2,226.50
$3,309.76 $24,240.49 $24,812.64
$0.00 $0.03 $0.00
5671.00 $0.00 50.00
$0.00 $15,961.20 $165,067.35
$568.00 $183.00 $0.00
$6,962.00 15.274.60 $5,928.50
10.00 $0.00 $0.00
$589.00 33.116,00 $3,416.00
$17,104.00 35,108.00 $10,923.50
$0.00 $0.00 $0.00
$0.00 $19625.00 10.00
$40,610.50 $19.894.00 $33,672.50
$6,632.50 $3,047.50 $5,089.10
$1,121.50 50 00 $0.00
$40,770.00 $28,911.00 $36,483.00
$20,461.50 $20600 $5,477.00
1191,278.00 $20718490 $222,797.50
$203,948.10 $233,233.10 $223.119.96
$47,381.30 $103,115.00 $95.063.24
$4,167.00 $1,220.00 $610.00
$9,013.00 110,170.00 $14,413.50
$0.00 $0.00 30.00
$3,309.76 $21,402.74 $7,472.39
$1262.00 $1,220.00 $5,612.00
$23.170.00 $11,227,20 $5,276,50
$75600 $427.00 $0.00
$31,967,76 $27,523.74 $12,315.39
$4,050.00 $8,566.00 $5,726.00
$8,699.50 $24,136.40 $10,020.40
$16,847.20 $36,250.20 $17,114.60
$79,683.50 $88,072.25 $83,086,25
$34,526,03 $28,609.00 130,445.50
$5,255,60 $4,937.00 $2,521.00
147,513.50 $79,785.50 $33,117.00
$997,078.72 $1,159.816.53 11,246,405.95
$67.284.00 $56,186.00 $63,207.50
$34.799„50 112.370.001 13.76000
$102,083.54 353,816.00 566,967.50
$31,784.13
$31,784.13
$31,784.13
$31,783.94
$11,274.00
$0.00
13,135.00
$60,683.60
$35,131.40
$55,215.75
$24,297.00
$37,232.50
$13.350.50
$105,066.00
$6,923.50
$52,362.89
$0.00
167/.00
$181,028.55
$751.00
118.185.10
$0.00
$7.121 00
$33,135.50
10,00
$19,625.00
$94.177.00
$14,789.10
$1,121,50
$106,164.00
$26,144.50
1621,240.40
$660,301.16
1245,659.54
$5,997.00
$33,596.50
$0.00
$32,184.89
$8.094.00
$39,673.70
$1,183.00
$71,806.89
$18.362.00
$42.1356.30
$70,212.00
$250.642.00
$93.580.50
$12,713.60
$160.416.00
$0.00 $3,403,301.20
1186,677.50
136.169 50
$0.00 $222,867.00
IMAGING
722 2-21-221009-01000-6039
2-35-243000-33000-6039
512 2-34-403200-40005-6039
18-636111-10000-0573
Cleric Image
Courts-FD-Juv-Sup-Imaging
Probate-Estates/Mental Health Image
TOTAL IMAGING DEVELOPMENT
APPROPRIATION
$86.953,00
$0.00
$3.342.00
190,295.00
$65,867.00
$0.00
$2,181.00
$68,048.00
552.244.00
10.00
$3,965 00
$56,209.00
$205,064.00
$0.00
19,488.00
$0,00 $214,552.00
SUB-TOTAL GOVERNMENTAL / IMAGING DEVELOPMENT APPROPRIATION: 11,189,556.22 11,252,142.53 $1,369,552.45
90-290000-25000-6030 Information Technology Development 111,189.556 221 j$1.282,142 63J [$1,369,582.45)
TOTAL GOVERNMENT: $0.00 10.00 $0.00
$0,00 $3,841,251.20
10,00 113.841.281 20)
$0.00 0.00
Prepared by: Information Technology: 7/29/04 04]uly2B3rd Ott 2004.xls
1st Qtr 2nd Ov 3rd Qtr 4th Qtr
DIVISION Oct - Dec APT - June July - Sept ACCOUNT # Y.T,D.
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
3RD QUARTER 2004
NON-GOVERNMENTAL
DIRECT CHARGES
055 CLEMIS 54,545.00 $6,233.00 $1,037.00 $11,815.00 -
103 COPSMORE Grant - Excess Match £0.00 $0.00 $6,039.00 $6,039.00
471 Courts-FOG Exp-CS Enforcement Image 56,929.00 $6,557.00 $9,978 00 $23,464.00
470 Courts-FOG Exp-Family Counseling $432.00 $0.00 $0.00 $432.00
507 Courts-FOG Exp-CS Enforcement Image $1,281.00 $1.386.00 $549.00 $3,216.00
210 Fire Records Management System $1.890.00 $8,312.00 $11,321.00 $21,523.00
757 FM-Wit Rel/Jail Mgt/Video Cont $71.794.00 $60,418.00 $64,833.00 $197,045.00
750 FM & 0 S3.754.00 $2,573.00 $6,789.00 913,116.00
380 Health - Immunization Grant $1,134.00 $324.00 $1,350,00 $2.808.00
751 IT - Telephone Communications 50.00 $216.00 $122.00 $338.00
662 Major Department Support Project Fund $0.00 £29,151.00 $352,924.79 $382,075.79
870 Medical Care Facility $6932.00 $3,793.00 $3.733.00 $14.458.00
651 0G. International Airport-GRE Grant $0.00 $6,547.50 $366.00 $7,213.50
653 0.C. International Airport $5684.50 ($5,318.50) $366.00 $732.00
770 Parks and Recreation - Administration $488.00 £1,182.00 $0.00 $1,680.00
695 Risk Management $549.00 9183.00 $61.00 $793.00
656 Water & Sewer Accounting $4.899,00 $3,538.00 $2,196.00 $10.633.00
18-636111-10000-0715 SUB-TOTAL DIRECT CHARGES FOR DATA $110,311.50 $125.405.00 $451,684,79 $0.00 9597.351.29
PROCESSING DEVELOPMENT
TOTAL COUNTY DEVELOPMENT CHARGES $1,299,887.72 $1,407,547.53 S1.831.247.24 $0,00 $4.538.682.49
NON-COUNTY AGENCIES
18-636111-10000-0429 Non-County Agencies $000 $0.00 $0.00 $0.00 $0.00
TOTAL DEVELOPMENT CHARGES $1,299,867.72 $1,407,547.53 $1,831,24714 $0.00 $4,538,862.49
.repared Oy. Information Technology. 7/29/04 04july283rd Qtr 2004 xls
Resolution #04186 August 5, 2004
The Chairperson referred the resolution to the Finance Committee. There were no objections.