HomeMy WebLinkAboutResolutions - 1996.02.15 - 24748February 15, 1996'
MISCELLANEOUS RESOLUTION 196030
BY: STRATEGIC PLANNING COMMITTEE, DENNIS POWERS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FOURTH QUARTER AMENDMENTS
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
WHEREAS Miscellaneous Resolution #94009 (Department of Computer Services
- Approval of Inventory Pool for Automation Equipment)indicates that, on a
quarterly basis, budget amendments will be presented in resolution form
summarizing the impact on Information Technology and user departments' budgets
for office automation projects previously approved by the Finance and Personnel
Committee; and
WHEREAS the office automation projects approved by the Finance and
Personnel Committee on November 30, 1995 require $175,963 to be expended for
the acquisition of capital equipment; and
WHEREAS the remaining balance from previous Delinquent Tax Revolving .Fund
loans is insufficient in the amount of $(22,500) to cover the capital
acquisitions; and
WHEREAS funding for capital equipment is no longer available through the
Delinquent Tax Revolving Fund and funds are available in the Office Automation
Equipment Fund (#4-10100-909-01-00-9920); and
WHEREAS the County Library Fund (#4-26800-513-03-00-8617) has designated
a portion of their funds for Office Automation Projects; and
WHEREAS Children's Village previously obtained office automation
equipment through the Equipment Fund and consequently the funds for replacement
equipment are available in the Equipment Fund; and
WHEREAS the Finance and Personnel Committee approved office automation
projects for the Library in the amount of $1,530 and Children's Village in the
amount of $32,151 at the November 30, 1995 meeting requiring a transfer of
money from their respective funds to Information Technology to complete the
projects; and
WHEREAS the Department of Information Technology has determined the
Fourth Quarter 1995 data processing development charges to be $494,700.82 and
the imaging development charge to be $6,548.50 for the governmental fund County
departments; and
WHEREAS the direct charges to non-governmental fund departments and no-
county agencies are $542,563.70 for development for the Fourth Quarter 1995;
and
WHEREAS an appropriation transfer to governmental fund County departments
is needed to fund these development charges; and
WHEREAS an appropriation transfer is needed from Information Technology
operations to governmental fund county departments for fourth quarter CLEMIS
expenses.
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of
Commissioners approves amendments related to office automation projects
approved by the Finance and Personnel Committee in the fourth quarter of 1995.
BE IT FURTHER RESOLVED that Oakland County Board of Commissioners
approves the transfer of funds from the Office Automation Fund, the County
Library Fund and the Equipment Fund for the purpose of completing office
automation projects previously approved.
BE IT FURTHER RESOLVED that the Oakland County Board of Commissioners has
reviewed the Fourth Quarter 1995 Data Processing Development and finds
$494,700-52 in the 1995 Data Processing Development budget (account #4-10100-
181-01-00-6361) for transfer to the appropriate user departments.
BE IT FURTHER RESOLVED that $6,548.50 be transferred from the Imaging
Development budget (account #4-10100-181-01-00-6367) to the Friend of the Court
and Clerk's budget for fourth quarter development charges.
BE IT FURTHER RESOLVED that $49,541 is transferred to governmental fund
county departments from Information Technology for CLEM'S expenses.
BE IT FURTHER RESOLVED that the 1995 budget be amended as detailed on the
attached schedules.
Chairperson. on behalf of the Strategic Planning Committee, I move
adoption of the foregoing resolution.
STRATEGIC PLANNING COMMITTEE
a443124:0 G-tlir.A.A
Expenditures
GenciaLfuncLIACLID.RI
909-01-00-9920
Computer Services Operations;
Department
175-01-00-6360 Pubhc Services
311-01-00-6360 Circuit Court
221-01-00-6360 Treasurer
433-10-00-6360 Sheriff
194-01-00-6360 Community & Economic Dev.
138-03-00-6360 Central Services
213-01-00-6360 Clerk/Register of Deeds
511-01-00-6360 Board of Commissioners
212-10-00-6360 Clerk/Register of Deeds
344-01-00-6360 Probate Court
192-01-00-6360 Community & Economic Development
115-01-00-6360 County Executive
123-01-00-6360 Management & Budget
127-01-00-6360 Management & Budget
411-01-00-6360 Prosecuting Attorney
173-01-00-6360 Public services
154-01-00-6360 Personnel
513-03-00-6360 Board of Commissioners
433-01-00-6641 Sheriff
Insitutional & Human Services Fund 1221001
162-01-00-6360
Subtotal Fund 22100
101 3.057 4.247
$4,881 $3,057 $4.247
Health
135
a a
$0o MAE
11.781
COMPUTER.SERVIC'ES OFFICE AUTOMATION scHEpuLE .FOURTH QUARTER 1996
gOVERNMENTAL FUNDS
Revenue
Total Revenue
19111
a a
La sa sa
Office Automation
Division
Cooperative Extension
Assignment Clerk
Tax Administration
Corrective Service
Equalization
Support Services
Elections
Administration
Admnistration
Court Service & Judicial Support
Development & Planning
Corporation Counsel
Accounting
Reimbursement
Administration
Administration
Human Services
Library Board
Other Line items:
Corrective Service
Subtotal General Fund
($145,330) ($76,521) ($105.067)
11,117 5,669 8,774
6,309 7,353 10,226
1.942 583 810
73,326 35,621 47,411
10,265 2,772 3,707
13,805 6,409 8,729
221 0 0
135 0 0
816 0
4,174 2,156 3,300
10,612 8,093 10.845
1206, 0
170 0
544 0 0
189 0 0
2,390 2,310 3,061
1,909 0 0
541 401 594
(43) (516) (516)
($5.7021 ($5.650) ($9.1_561.
Insibtonal. & Human Services Fund (29230i
165-01-00-6360 Children's Village
Subtotal Fund 73510
521 2 593 4.9aa
$821 $2,593 $4.909
Total Governmental Expenditures
Total Governmental Funds
so SQ SQ
sa la sa
NON-GOVERNMENTAL FUNDS
Central Services Fund (208001
Facilities_Management Fund (63100k
information Technology Fundf536001.
848 a a
sue so so
Facilities Maintenance & Operations 19.5.95 7_,,548 9ola
Subtotal Fund 63100 $19.595 $7,54.8. $9.010
Technical Support
Systems Development
Subtotal Fund 63600
Parks & Recreation
Subtotal Fund 20600
Institutional & Human_Services Fund (22200)
Community Mental Health
Subtotal Fund 22200
12-601 4.40 Et116fi
$12.601 54.465 NAN
c21332111CtLailealltfuE11463=1
Bevenue
181-01-00-2037
181-01-00-2355
Governmental Operations
Non-governmental Operations
Subtotal
$145,540 $79,039 $108,615
34.025 12.013. al%
5180365 391.052 5124.511
COMPUTER 'SERVICES OFFICE AUTOMATON SCHEDULE • FOURTH QUARTER 1998
1/21
EX9310111a
184-01-00-3304 Depteciat(on $8,694 $76,257 $76,257
184-01-00-3342 Equipment Repairs & Maint. 0 4,253 37,712
184-01-00-3701 Software 118,642 0 0
184-01-00-4905 Parts & Accessories 34,967 0 0
182-01-00-3178 Professional Services 17,193 0 0
182-01-00-3278 Communications faa j0.542 10.542
Subtotal $180.365 $91,052 $124.511
1-455-001 Revenue Over (Under) Expense Sa 112 IQ
1,530
287
ADDITIONAL OFFICE AUTOMATION AMENDMENTS
Information_Technology/Office Automation - Funds for capital expenditure
General Fund cloalai
Expenditures
4-10100-909-01-00-9920 Office Automation
4-10100-901-01-00-8615 Operating Transfer Out - Info Tech
($22,500)
22.500
a
Informatipp Technology (63600)
Revenue
3-63600-181-01-00-8101 Operating Transfer In
Expenditures
4-63600-184-01-00-3304 Depreciation
1-455-001 Estimated Profit (Loss)
$22,500
4,219
18,283.
Information Technology/LilDrary - Operations Transfer
Library Fund (26800)
4-26800-513-03-00-8615 Operating Transfer Out - Info Tech
1-455-001 Estimated Profit (Loss)
Information Technology (63600)
Revenue
3-63600-181-01-00-8670 Operating Transfer In
Expenditures
4-63600-184-01-00-3304 Depreciation
1-455-001 Estimated Profit (Loss)
$ 1,530
(1.5301
11
Information Technology/Children's
Equipment Fund (6640)
4-66400-123-25-00-8615 Operating
4-66400-123-25-00-8212 Operating
1-455-001 Estimated
Village - Operations Transfer
Transfer Out - Info Tech
Transfer Out
Profit (Loss)
Information Technology (5§00)
levenue
3-63600-181-01-00-8670 Operating Transfer In
Expenditures
4-63600-184-01-00-3304 Depreciation
1-455-001 Estimated Profit (Loss)
$ 15,386
16,765
(32.1511.
$ 15,386
2,885
12.50Z
Children's Village (29230)
Revenue
3-29230-165-01-00-8670 Operating Transfer In
Expenditures
4-29230-165-01-00-6360 Computer Operations
$ 16,765
S 16.765
31,939,959.96
$0.00
19.926.00
$2.019.50
370,606.50
332,030.50
$2,059,715.35
3250.00
11007.00
$0.00
311 031.00
$196.80
$0.00
315,874,34
$0.00
11.403.50
30.00
$20,157.06
10.00
64.559.00
3)35.910.$0
$54,836.10
136,556.50
32.420.653.07
31,296.00
$38.482.50
5.4.300371 5a
$4494,700.62
2.201.00
568.00
12.241.50
6,422.00
400,599.30
632.50
155.00
1,327.50
4,872.50
62.00
4.612.50
60,611.40
400,00
38,5511,50
$542,563,70
8,546.50
$1043 alura
DEV95.1NK4 01/17i96
attanDLI=113threallail
4-10100-123-01-004361
422100-175-01-0043e1
4-10100-112•01-00-6361
4-10100-511-01-00-6301
400100-511-02-00-6361
4-10100-122-01 -00-6361
4-29230- 165-01- 00-6361
421500-l27-06-00-8361
4-10100-31141-00-6361
4-101000 79-01-004361
4-10100-214-01-00-6361
4-10100-213-01-00-6361
400100-215-01-0134361
410100-175-01-004361
419100-115-01-004361
4-10100-111-01-004361
4-10100-192-01-00-63411
4-1010047441-00-8361
4-10100411-(11-004361
4-10100-19441-00-6301
4-10100-148-01-00-5361
4-10100041-01-004361
4-22100-141-30-00-6361
4-21500-312-01-00-6361
4-10100-121-01-4204361
4-22100-162-01404361
4-22100-162-01-00-6361
400100-161-01-004361
4-52100-163-01-00-6361
4-10100-169-01-004361
4-10100-151-01-00-5361
410100-344-01434361
410100-341-01-00-6361
4-10100-411-01-60.8361
400100-146-01-004361
4-10100-124431-00-8361
410100-136433-1304361
410103027-01-00-6381
4- 101 00413-03-00-5361
4-10100-433-10-004361
4-10100-141-15-004361
410100-221-01-00-6361
4-10100.173.01-00-6361
4-10103-322-01-00-6361
4-10100-322-05-00-6361
410100-323-0 I -00-6361
4.10100-323-05-00-6361
4.10100-324-014:44361
410100-324-05-0134361
410100-325-0140-6361
4-10100-325-05-00-6361
INFOR 14A T1Off TECHNOLOGY
DATA PROCESSING DEVeLOPINENT
1915 COST ALLOCATION
CM= Accounting - Adrneustraticti
Animal Controi
At411.Ang
&WO a Commissioners - Adm.
Soisrd of Commissioners • Adm.
Budget Division
Childrer's Village
Child SuPport/FOCtReimbursernent
Circuit Cl. - Administration
Circuit Cl. - Probation
Clerk Register a Deeds
Clerk - Elections
Clerk - Jury Commission
Cooperative Extension Senrios
Corporation Counsel
County Exec:J1Na
Developmenl & Ptanniag Division
District Court Probation
Drain Comma:seiner
Equalizatkin Division
Facilities Engineering
Facilities Managrdnent - Admiestration
Facilities Management EMS
Friend or the Court
GIS - Management & Budget
Health - CRAMPS
Health Dtvision
mutt. & KAMM SIM - AdM.
Medical Care Pac44y
Medical Exmreser
Personnel
Probate Cl. - Estates & Mental
Probate Cl. - Juvenile
Prosecuting Attorney
Putiao Works • Engineering
Purchasing Minion
Peron:is Retentron
Reimbursement DrAli011
Research Library
victim
Solid Waste
Treasurer
Veterans' Services
52)1 Dletrict Court
52)1 District Cool Probation
52/2 DIsInct Coon
52/2 District Court Probation
5213 District Court
5213 Distnct Court Probation
52)4 District Court
52/4 District Court Probation
FOURTH QUARTER YTO
ar.611ZEILSECaga- TOTAl
$76,592.50 7214,125.73
382.50 $4069.50
5,6841.00 117,741.50
$2.472.20
34,382.20 334,362.20
17,857.79 135.951.99
3,555.00 *16,64010
9.145.00 113,0411.00
5,736.50 345,134.16
195.00 3185.00
8,451 oa $45,761.90
$2,544.00
5,41000 311,296.35
1.825.00 13.321.00
248.00 33,264.00
466.50 $466.450
4,546.50 316,976.45
$0.00
$7,769.00
39,373.50 $137,027.00
3690.10
95.00 31,533.00
71.00 *2,138.51
33,719.50 $133,513.71
4,79050 325,091.00
$0.00
16,276.50 581,256.30
*CC
4.37150 511,404.00
502.60 $2,211.50
29,921.58 399,312.85
3.26750 115,734.10
19,081.00 597,547.31
25,573.50 169.459.50
30.00
2,985.00 115,955.50
4,854.50 311,544.73
19.345.00 $76,257.89
1.19e.60 310,745.00
64249.19 1255.231.69
$3.00
19,154.00 $132,042.50
195.50 *1,947.10
6,322.24 322.777.11
30.00
6,322.24 117,255.81
$0.00
6.32224 317,199.61
$0.00
6,322.24 $19,554.51
30.00
4-10100-212-10-00-6387
4-21500-312-01.' ".-6367
Prepared by Budget Division - KM
DATA PROCESSING DEVELOPMENT FOR
GOVT. FUND APPROPRIATION
Circuit COtift Drug Grant
Community Correcticits
Communty Development Grant
Community Mental Health
Delinquent Tax - Pe(143081 Property
information Technology
Empioyment and Training
Facilities Maint. & Operations
Facilities Mak% & Operations - Telephone COMM.
Garage
in-Car Termilals
materials Management
Oakland Pontiac Airport
Perks and Recreation
erri shop
Risk Management
sod Waste
Water & Sewer Accounting
Water & Sewer Operations
Drug Enforcement Grant
Grants - NI)scsalansaus
'Non-County Agencies
100% Tax Payment Fund
DIRECT CHARGES FOR DATA
PROCESSING DEVELOPMENT
IIAAGING DEVELOPMENT APPROPRIATION
Clerk
Friend of the Court
DEVELOPMENT CHARGES
CLEXIS AMENDMHNTS
LIS-QT.1112.L13:21] auology Ralustmensa
General Fund 120100)
4-10100-181-01-00-6360 Info Tech Operations
4-10100-322-05-00-6360 Dist Ct. Walled Lk - Probation
4-10100-323-05-00-6360 Dist Ct. Clarkston - Probation
4-10100-324-05-00-6360 Dist Ct. Roch Hills - Probation
4-10100-325-05-00-6360 Dist Ct. Troy - Probation
4-10100-322-01-00-6360 Dist Ct. Walled Lk
4-10100-323-01-00-6360 Dist Ct. Clarkston
4-10100-324-01-00-6360 Dist Ct. Roch Hills
4-10100-325-01-00-6360 Dist Ct. Troy
4-10100-311-01-00-6360 Circuit Court
4-10100-179-01-00-6360 Circuit Court Probation
4-10100-411-01-00-6360 Prosecuting Attorney
4-10100-433-10-00-6360 Sheriff
$49,541)
67
67
67
67
245
264
276
144
220
398
375
47.351
FISCAL NOTE (MSC. #96030)
BY: FINANCE AND PERSONNEL COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FOURTH QUARTER AMENDMENTS -
1996
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 recommends the
budget be amended as specified in the resolution, with the exception of the
$34,362.20 for the Board of Commissioners' development.
FINANCE AND PERSONNEL COMMITTEE
D. Allen, County Clerk
Resolution #96030 February 15, 1996
Moved by Powers supported by Quarles the resolution be adopted.
AYES: Moffitt, Palmer, Powers, Quarles, Schmid, Taub, Wolf, Amos, Crake,
Douglas, Garfield, Holbert, Huntoon, Jacobs, Jensen, Johnson, Kaczmar, Kingzett,
Law, McCulloch, McPherson. (21)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolution was adopted.
LIERE: 401° E FORFOrIN( RESOLUTION
L. Brooks P- erson. County Executive
"3-//5 M
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 copy of a resolution adopted by the
Oakland County Board of Commissioners on February 15, 1996 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 15th day gf February 1996.
Dato L. Brooks eattirson. County Executive Dato