HomeMy WebLinkAboutResolutions - 2005.05.26 - 27933MISCELLANEOUS RESOLUTION #05094 May 12, 2005
BY: GENERAL GOVERNMENT COMMITTEE, WILLIAM PATTERSON, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - SECOND QUARTER 2005
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 2005 data processing development charges to be
$964,063.17 and the imaging development charge to be $37,451.19 for the
General Fund/General Purpose County departments; and
WHEREAS direct charges to Special Revenue and Proprietary fund
departments are $283,258.39, and non-county agencies are $0 for the
Second Quarter 2005; 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 2005 Data Processing
Development Report and approves the Second 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
f
G VERNMENT COMMITTEE
i kipitill k 0
General Government Committee Vote:
Motion carried on a roll call vote with Gregory absent.
ACCOUNT Si DIVISION
1st Qtr
Oct-Dec
2nd Qtr
Jan - Mar
3rd Qtr
Apr-June
4th Qtr
July - Sept Y.T. p
18-636111-10000-0735
IMAGING
722 2-21-221000-01000-6039
512 2-34-403200-40005-6039
18-636111-10000-0573
GOVERNMENTAL FUNDS
General Fund 11011
2-32-201200-20001-6030
2-32-205200-20006-6030
2-32-301200-20001-6030
2-32-305200-20006-6030
2-32-401200-20001-6030
2-32-405200-20006-6030
2-32-501200-20001-6030
2-32-505200-20006-6030
2-17-802200-80001-6030
2-11-220100-10000-6030
2-21-220100-10000-6030
2-21-230100-3100045030
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-33000-6030
2-35-243000-32000-6030
2-35-242000-11000-6030
2-35-242000-44000-6030
2-35-243000-11000-6030
2-35-230000-22100-6030
2-35-230000-12000-6030
2-35-230000-21200-6030
2-35-230000-22290-6030
2-35-210000-11000-6030
2-11-210100-01000-6030
2-61-211001-10000-6030
2-11-101112-65001-6030
2-12-240000-41000-6030
2-14-210000-10000-6030
2-12-601200-25000-6030
2-15-402200-10001-6030
2-13-138502-15100-6030
2-17-912000-15000-6030
2-17-501200-50000-6030
2-19-221000-10000-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-023501-30000-6030
2-13-138203-16100-6030
2-22-221120-01000-6030
Health Fund 12211
2-16-201200-33100-5030
2-16-220200-67000-5030
$16,520.28
$2,296.75
$16.520.28
$2,296.75
$16.520.28
$2,296.75
$16,520.20
$2,296.75
$24,418.00
$244.00
$6,028.50
$27,976.00
$9,148.06
$71,609.20
59,454.20
$10,254.00
$4,664.50
$60,033.56
$2,074.00
$5,880.97
$0.00
$13.513.25
$0.00
$12.715.00
$10,012.80
$38876.25
$7336.50
571.243.50
$29.606 50
$134.20
$000
579.350 50
$8,178.00
$321,606.06
$3.648 00
$312,914.97
$120,858 11
$1,464.00
$52,842.85
$000
$15,242.00
$9,896.45
$13,817.32
$29,041.00
$0.00
$19,604.95
$4,428.00
$11,154.00
$27,549.80
$165,951.52
$13,509.08
$9,327.66
$61,963.06
$1,773,849.36 $000 $0.00
$62,488.70
$104,672.66
$0.00 $0.00 $167,181.36
$5.874.00
$0.00 $0 00 $5,874 00
;0.00 ;0.00 $1.046,854.72
$82,137.66
$5,803.40
;0.00 $0.00 $87,941.06
Juvenile Maintenance Fund f2931 12931
2-16-501200-25001-6030 Children's Village
Sub-Total Fund 293
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
2ND QUARTER 2005
540 101
541 101
550 101
551 101
560 101
581 101
530 101
531 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
474 101
484 101
487 101
492 101
483 101
499 101
496 101
498 101
500 101
493 101
015 101
730 101
900 101
740 101
755 101
660 101
680 101
641 101
872 101
710 101
775 101
509 101
510 101
481 101
479 101
145 101
890 101
637 101
650 101
195 101
191 101
445 101
600 101
840 221
643 221
665 293
5211 - District Court
52/1 - District Court - Probation
5212 - District Court
5212 - District Court - Probation
52/3 - District Court
52/3 - District Court - Probation
52/4 - District Court
52/4 - District Court - Probation
Animal Control
Auditing
Clerk - Admin
Clerk - 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 Juvenile Support
Courts-FD Juvenile Referees
Courts-FD-Court Services-Admn
Courts-FD-Court Services-Adoptions
Courts-FD-Judicial Support-Admin
Courts-GJ-Assignment
Courts-GJ-JIMS
Courts-GJ-Judicial Support
Courts-GJ-Mediation
Courts - Judical /Administration
County Executive
Drain Commissioner
Emergency Response & Prep Unit
Equalization Division
Facilities Management
Fiscal Services - Admin
Human Resources
Matenals Management - Gen Fund
Medical Examiner
MSU Extension - Oakland
Planning & Economic Development
Probate - Judicial Admin
Probate-Estates/Mental Health Support
Probate-FD-Judicial
Probate-FD-Judicial Support
Prosecuting Attorney - General Prosecution
Purchasing
Records Retention
Reimbursement Division
Sheriff
Sheriff - CLEMIS
Support Services
Treasurer
Sub-Total Fund 101
Health
Health Environmental
Sub-Total Fund 221
DATA PROCESSING DEVELOPMENT FOR
GOVERNMENTAL FUND APPROPRIATION
Clerk Image
Probate-Estates/Mental Health Image
TOTAL IMAGING DEVELOPMENT
$8,754.63 $7,765.65
$30.50 $2,266.25
$8,764.63 $7,765.65
$3050 $2,266.25
$8,754 63 $7,765.65
$30.50 $2,266.25
$8.754.55 $7,765.65
$3050 $2,266.25
$11,400.00 $13,018.00
$244.00 $0.00
$4.275.00 $1,753.50
$3,538.00 $24,438.00
$4,906.87 $4,241.19
$30,300.00 $41,309.20
$4,855.60 $4,608.60
$6,455.00 $3,799.00
$4,725.50 ($61.00)
$35,302.87 $24,730.59
$1,098,00 $976.00
$5,664.88 $1,216.09
$000 $0.00
$13,513 25 $0.00
$0.00 $0.00
$5.174.00 $7.542.00
$7,184 85 $2,827.95
$21,354,25 $17,522.00
$3,834.50 $3,502.00
$33,836.50 $37,40700
$26,073.50 $3,533.00
$36.60 $97.60
$0.00 $0.00
$36,977.00 $42,373.50
$7,427.00 $751.00
$189,425.26 $132,180.78
3108.00 $3,540.00
$166,479.43 5146,435.54
$49,428.77 $71.429.34
$244.00 $1.220.00
$13,990.71 $35852.14
$732.00 ($732.00)
$1,830.00 $13.412.00
$9,896.45 $0.00
$7,628.35 55 185.97
$23,588.00 $5453.00
$0.00 $0.00
$10,947,45 $8.657.50
$3,132.00 $1,296.00
$5,290.00 $5,864.00
$14,968.40 $12,591,40
$92.718.43 $73.233 09
$8,803.86 $4,705,22
$4,322.47 $5.005.19
$33.778.87 $28.184.19
$ 940 620.08 $833,229.28
$34.382.60 $28.106.10
$5,004.87 $99,067.79
$39,987.47 $127,173.89
$2,214.00 $3,860.00
$2,214.00 $3.660.00
082,821.55 ;964,063.17
$47,554.67 $34,582.99
$2,935.20 $2,868.20
$00,489.87 $37,451.19
APPROPRIATION
SUB-TOTAL GOVERNMENTAL / IMAGING DEVELOPMENT APPROPRIATION: $1,033,311.42 $1,001,614.36
90-290000-25000-6030 Information Technology Development ($1,033,311.42) ($1,001,514.36)
TOTAL GOVERNMENT: ;0.00 50.0Q
$0.00 $0.00 0,034,826.78
g_o_o $0.00 (52.034,825.78)
$0.00 $0.00 0,00
Prepared by Intommtion Technology; 513/05 05may02devapptransattach.xls
INFORMATION TECHNOLOGY
DATA PROCESSING DEVELOPMENT SUMMARY
2ND QUARTER 2005
^
St Qtr 2nd 01r 3rd Qtr 4th Qtr
ACCOUNT # DIVISION Oct-Dec Jan-Mar Apr-June
NON-GOVERNMENTAL
DIRECT CHARGES
055 CLEMIS $36,179 35 $38,362.23 $74,541 58
056 CLEMIS FL/ND 63500 $146400 $13,044.00 $14.508.00
103 COPSMORE Grant - Excess Match $39,894 00 ($39,894.00) 50.00
471 Courts-FOC Exp-CS Enforcement Image $7,386.40 $9,122.40 $16,508.80
470 Courts-FOG Exp-Family Counsel.ng $0.00 $0.00 50.00
507 Courts-FOG Exp-CS Enforcement Image $1,220.00 $1,342.00 $2,562.00
210 Fire Records Management System $2,413.71 $3,421.89 $5,835.60
757 FM-Wk Rel/Ja.1MgtNideo Conf $57.993.37 553,241.19 5111.234.56
758 FM-Jail Mgmt Replacement $0.00 $6.078.00 $6.075.00
750 FM &O $0.00 $1,741.00 $1,741.00
759 F M & 0-Safety Overhead $0.00 $648.00 $648.00
380 Health - Immunization Grant $1.782.00 $1,566.00 $3348.00
751 1' - Telephone Communications $0.00 $122.00 $122.00
662 Major Department Support Project Fund $364.031.20 $185,175.60 5549,206.80
870 Medical Care Facility $6,936.71 53,895.89 $10,832.60
248 Medical Care Facility - Pharmacy $3,294.00 $1,134.00 $4.428.00
651 0.C. International Airport-GRE Grant $0.00 $0.00 $0.00
653 ac. International Airport $1,857.00 $413.00 $2.270.00
770 Parks and Recreation - Administration $108.00 $108.00 $216.00
790 Radio Communications $9.730.00 $207.00 $9,937 00
695 Risk Management $0.00 50.00 30 00
656 Water & Sewer Accounting $4,550.87 $3,530.19 $8,081.06
850 Workforce Development $122.00 $0.00 $122.00
18-636111-10000-0715 SUB-TOTAL DIRECT CHARGES FOR DATA 5538.962.61 $283,258.39 $0.00 $0.00 $822,221.00
PROCESSING DEVELOPMENT
'TOTAL COUNTY DEVELOPMENT CHARGES $1,572,214.03 $1 .284,772.75 p_.n39 $0.00 52.557,046.78
NON-COUNTY AGENCIES
18-636111-10000-0429 Non-County Agencies $0.00 $0.00 $0.00 $000 50.00
TOTAL DEVELOPMENT CHARGES $1,572,274.03 $1,284,772.75 $0.00 $0.00 $2,867,046.78
Y.T.D.
Prepared by Information Technology; 513105 05may02devapptransattach.xls
Resolution #05094 May 12, 2005
The Chairperson referred the resolution to the Finance Committee. There were no objections.
FISCAL NOTE (MISC. #05094) May 26, 2005
BY: FINANCE COMMITTEE, CHUCK MOSS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - SECOND QUARTER 2005
DEVELOPMENT APPROPRIATION TRANSFER
TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS
Chairperson, Ladies and Gentlemen:
Pursuant to Rule XII-C of this Board, the Finance Committee has
reviewed the above-referenced resolution and finds:
1. The resolution appropriates and charges the Information
Technology Second Quarter 2005 Development cost to benefiting
departments.
2. The second quarter data processing development charges are
$964,063.17; imaging development charges are $37,451.19 for
General Fund/General Purpose departments; direct charges to
Special Revenue and Proprietary fund departments are
$283,258.39 and charges to non-county agencies are $0.
3. The respective departmental Fiscal Year 2005 budgets are to be
amended as specified in the attached detail schedule.
FINANCE COMMITTEE
FINANCE COMMITTEE:
Motion carried unanimously on a roll call vote with Melton, Crawford
and Woodward absent.
Resolution #05094 May 26, 2005
Moved by Long supported by Suarez the resolutions on the Consent Agenda be adopted (with
accompanying reports being accepted).
AYES: Coulter, Crawford, Douglas, Gershenson, KowaII, Long, Melton, Middleton, Molnar, Moss,
Nash, Palmer, Patterson, Scott, Suarez, Wilson, Woodward, Zack, Bullard. (19)
NAYS: None. (0)
A sufficient majority having voted therefore, the resolutions on the Consent Agenda were adopted (with
accompanying reports being accepted).
I all AMEN THE MON feCtUTION
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Ruth Johnson, 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 26, 2005 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 26th day of May, 2005.
U
Rutlitfteron, County-Clerk