HomeMy WebLinkAboutResolutions - 1996.11.21 - 24864November 7, 1996 . I
MISCELLANEOUS RESOLUTION 196258
BY: STRATEGIC PLANNING COMMITTEE, DENNIS POWERS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - 1996 BUDGET AMENDMENTS FOR
APPROVED OFFICE AUTOMATION PROJECTS
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) specifies 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; and
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners
approves amendments to the 1996, FY1997, FY1997/98 Biennial Budget as detailed
in the attached Information Technology Office Automation Schedule for projects
approved in the third quarter of 1996.
Chairperson, on behalf of the Strategic Planning Committee, I move the
adoption of the foregoing resolution.
STRATEGIC PLANNING COMMITTEE
Alilexd2 6F;k4)ertoo
7,752
7.752
1968,
1,91f1
INFORMATION TECHNOLOGY'S OFFICE AUTOMATION SCHEDULE - THIRD QUARTER 1998
FY1996 FY1997 FY1997/98
GOVERNMENTAL FUNDS
Ban=
Expenditures
General Fund (101001
909-01-00-9920
Total Revenue
Office Automation
a a
sa sa
($34,208) (74,709) (99,612)
323-01-00-6360
511-01-00-6360
212-10-00-6360
175-01-00-6360
111-05-00-6360
111-01-00-6360
19201-00-6360
19401-00-6360
126-01-00-6360
154-01-00-6360
174-02-00-6360
344-01-00-6360
-341-01-00-6360
411-01-00-6360
513-03-00-6360
433-10-00-6360
Information Technology Operations:
Department
District Court
Board of Commissioners
Clerk/Register of Deeds
Public Services
County Executive
County Executive
Community & Economic Development
Community & Economic Development
Management & Budget
Personnel
Public Services
Probate
Probate
Prosecutor
Board of Commissioners
Sheriff
Division
52/2 District Court - Clarkston
Board of Commissioners
County Clerk - Legal Records
MSU Ext.
Comm. & Minority/Cultural Affal
County Executive-Admin.
Development & Planning
Equalization
Fiscal Services-Admin.
Human Resources
Pre-Trial Services - County
Judicial Support-Admin.
Judicial Admin-Admin.
Admin.-Executive Staff
Library Board-Admin.
Corrective Serv-Detention Fac.
Subtotal General Fund
0 0 0
1,440 4,320 5,760
54 0 e
0 0 0
1,071 3,213 4,284
1,934 0 0
1,086 3,258 4,344
906 2,070 2,760
666 1,998 2,664
0 0 0
246 738 984
9,066 25,992 34,656
0 0 0
3,625 7,974 10,632
492 1,476 1,968
7,042 9,504 12,672
($6.580) ($14.166) (518.888)
Health Fund (22100)
178-01-00-6360 Public Services
162-01-00-6360 Human Services
F.O.C. (215001
312-01-00-6360 Circuit Court
Children's Village Fund (29230)
165-01-00-6360 Human Services
Animal Control
Health
Sub-Total Fund 22100
Friend of the Court
Sub-Total Fund 21500
Children's Village
Sub-Total Fund 29230
Total Governmental Expenditur
Total Governmental Funds
1,800 5,400
2,350 1,476
4.150 6.876
1,938 5,814
1,938 5.814
492 1,476
422 1.476
SQ.
sa sa
7,200
1,968
/168
sa
10/14/96 c: \123wks\jobacctg\oa-amend\2-96-oa.wk4
792 594 198
7.92 191
M.C.F. Fund (52100)
163-01-00-6360 Human Services Medical Care Facility
Sub-Total Fund 52100
984 2,952
184 2.952
3,936
3.936
0 0 0
0
INFORMATION TECHNOLOGY'S OFFICE AUTOMATION SCHEDULE - THIRD QUARTER 1998
FY1996 FY1997 FY1997/98
NON-GOVERNMENTAL FUNDS
Community Corrections (27308)
174-01-00-6360
174-02-00-6360
CMH Board Fund (22296)
550-01-00-6360
552-01-00-6360
551-66-00-6360
554-50-00-6360
551-52-00-6360
553-60-00-6360
553-10-00-6360
551-20-00-6360
Human Services (27530)
174-02-00-6360
Facilities Management Fund (63100)
147-01-00-6360
Parks & Recreation Fund (20800)
134-01-00-6360
Oakland International_Airport 10110)
137-1-0-6360
Community Corrections - Grant
Pre-Trial Services-Grant
Sub-Total Fund 27308
CMH - Administration
CMH - DO Services North
CMH - El Centro
CMH - Intake
CMH - Jail
CMH - Kids Expansion
CMH - NOFMHC
CMH - South Adult Services
Sub-Total Fund 22296
Immunization Grant-Health
Sub-Total Fund 27530
FM&O
Sub-Total Fund 63100
Oakland Intl. Airport-Admin
Sub-Total Fund 58110
0 0 0
246 738 984
24.6 zaa RBA
4,757 14,271 19,028
198 594 792
1,998 5,994 7,992
6,192 18,576 24,768
666 1,998 2,664
1,998 5,994 7,992
5,328 15,984 21,312
8,682 26,046 34,728
29.81 a 89.457 119.276
1,674 5,022 6,696
1-6/4 5.022 6.696
198 594 792
198 594 7.92
198 694 792
198 Sit 292
Parks & Recreation Tech Supp 11,129 14,760 19,680
Sub-Total Fund 20800 11.129 14.760 19.680
Water & Sewer Operations Fund (83200)
612-01-00-6360 Drain Commissioner
Risk Management (73530)
115-02-00-6360
Operations & Maint-Admin.
Sub-Total Fund 83200
Risk Management
Sub-Total Fund 73530
information Technology 1636001
Revenue
181-04-00-2037
181-01-00-2355
Expenses
186-01-00-3304
186-01-00-3342
186-01-00-3701
186-01-00-4905
182-01-00-3178
1-455-001
Governmental Operations
Non-governmental Operations
Subtotal
Depreciation
Equipment Repairs & Maint.
Software
Parts & Accessories
Professional Services
Subtotal
Revenue Over (Under) Expens
$34,208 $74,709
44.446 114.711
$18_6$4 $189.420
$19,077 $65,873
1,145 3,434
35,325
27,390
0
$82.936 $69.307
($42821 5120:111
$99,612
152.948
5252.560
$87,830
7,632
$95.462
$157.098
10/14/96 c:\123wks\jobacctg \oa-amend\2-96-oa.wk4
°softest
NOICGOVEROONTAL SPEcte4. FU
Community Correcgons
Board of Commissioners
Board of Commissioners
Board of Commissioners
Board of Commissioners
Board of Commissioners
Board Of Commissioners
Board of Commissioners
Board of Commissioners
Facilities Mgmt
Human Services
Central Services
Central Services
Public Services
Human Services
Drain Commissioner
Corporation Counsel
District Court
Public Services
Board of Commissioners
Human Services
Clerk/Register of Deeds
Public Services
County Executive
County Executive
Community & Economic Development
Community & Economic Development
Management & Budget
Circuit Court
Human Services
Personnel
Public Services
Probate
Probate
Prosecutor
Board of Commissioners
Sheriff
TOTAL OFFICE AUTOMATION
GRAND TOTAL ALL PROJECTS
Milan
IIGINO
Community Corrections - Grant
CMH - Administration
CMH - OD Services North
CMH - 8 Centro
CMH - Intake
CNN-Jail
CMH - Kids Expansion
CMH - NOFMHC
CMH - South Adult Services
FM&O
Immunization Grant - Health
Information Technology
Aviation-OC Intl. Airport-Admin
Parks & Rae - Admin
Pre-Trial Services - Grant
Medical Care Facility
Water & Sewer Operations
Risk Management
52/2 Dist Ct - Clarkston
Animal Control
Board of Commissioners
Children's Village
County Clerk - Legal Records
MSU Ext.
Comm. & Minority/Cultural Affair
County Executive-Admin.
Development & Planning
Equalization
Fiscal Services-Admin.
Friend of the Court
Health
Human Resources
Community Corr.-Pre Trial Servi
Judicial Support-Admin.
Judicial Admin-Admin.
Admin.-Executive Staff
Library Board-Admin.
Corrective Serv-Detention Fan.
TOTAL NON-GOVT. & SPECIAL FUNDING
OFFICE AUTOMATION RESERVE FUNDING
(3) Sys 2, (3) Laser Printer
(2) Notebook, (1) Laser Printer
(1) Sys 2
(1) Power Chute Software
(1) Phaser Printer
(2) Winbeep software
(1) Sys 2, (3) Laser Printer
(1) Sys 2, (1) Laser Printer, (4) Power Chute
(1) Notebook
(2) Sys 2, (1) Laser Printer, (1) Non-Add Ptr
(1) Sys 2, (1) Power Point, (1) SPSS Base Sft
(1/2) Sys 2
(16) Sys 2, (4) Laser Printer, (1) Paradox soft
(5) Sys 2, (1) Laser Printer, (1) Winbeep sotto
(1) Sys 2
(2) Sys 2, (2) Laser Printer. (5) Terminals, (1)
(1) Term for Windows, (1) Boss Software
INFORMATION TECHNOLOGrS OFFICE AUTOMATION SCHEDULE - THIRD QUARTER 1996
FY1996 fY1997
Capital initial
Required Emma
O 273 0 0 0
10,988 3,076 4,757 14.271 19,028
1,530 0 198 594 792
7,659 395 1,998 5,994 7,992
24,507 405 6,192 18,576 24,768
2,553 0 666 1,998 2,664
7,659 395 1,998 5,994 7.992
20,424 0 5,328 15,984 21,312
33,965 1,205 8.682 26,046 34,728
1,530 405 198 594 792
6,927 3,818 1,674 5,022 6,696
11,111 0 0 0 0
1,704 0 198 594 792
17,990 11,594 11,129 14,760 19,680
450 367 246 738 984
1,883 0 198 594 792
3,598 2,278 984 2,952 3,936
O 312 0 0 0
$154,478 $24,523 544,446 $114,711 $152,948
O 460 0 o 0
6,702 3,417 1,800 5,400 7,200
5.679 3,464 1,440 4,320 5,760
1,799 865 492 1,476 1,968
O 585 54 0 0
O 419 0 0 0
5,640 964 1,071 3,213 4.284
O 1,803 1,934 0 0
7,821 1,558 1,086 3,258 4,344
3,329 561 906 2,070 2,760
2075 677 666 1,998 2,664
10,826 1,768 1,938 5,814 7,752
1,799 3,368 2,350 1,476 1,968
O 274 0 0 0
900 367 246 738 984
34,904 7,859 9,066 25,992 34,656
O 186 0 0 0
10,249 4,783 3,625 7,974 10,632
1,799 274 492 1,476 1,968
15,491 4,520 7,042 9,504 12,672
$109,013 $38,192 $34,208 $74,709 $99,612
$263,490 $62,715 $78,654 $189,420 $252,580
FY1997/90
Operating Expense
lailitZ FYI 997/98
(3) Notebook, (1) Sys 2, (1) Laser Printer
(1) Laser Printer
(3) notebook
(9) Notebook, (1) Laser Printer
(1) Notebook
(3) Notebook
(8) Notebook
(12) Notebook, (1) Sys 2, (1) Laser Printer
(1) Laser Printer
(3) Sys 2, (1) Laser Printer
(1) Sys 2, (2) Sys 3(1) Laser Printer
(1) Stylus Printer
(10) Sys 2, (5) Winbeep Software
(1/2) Sys. 2 50% grant funded
(1) Laser Printer
(2) Sys 2
c:1123wks1jobacctgloa-arnend12-96-oa.wk4 10/15/96
Resolution *96258 November 7, 1996
The Chairperson referred the resolution to the Finance and Personnel
Committee. There were no objections.
FISCAL NOTE (Misc. 096258)
BY: FINANCE AND PERSONNEL COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON
IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - 1996 BUDGET AMENDMENTS FOR
APPROVED OFFICE AUTOMATION PROJECTS
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. The Strategic Planning Committee has approved various office
automation projects during the third quarter of 1996.
2. The cost, to the governmental funds, of implementing and operating
the new technology is $34,208 in 1996, $74,709 in FY 1997, and
is projected to be $99,612 in FY 1997/1998, as detailed on
the attached schedule.
3. Funds are available in the non-departmental Office Automation
account to cover the cost to the governmental funds. The 1996 and
1997 budget should be amended, as detailed on the attached
Schedule, to cover the cost of the approved office automation
projects; (FY 1997/1998 is provided for illustrative purposes
only).
FINANCE AND PERSONNEL COMMITTEE
Resolution #96258 November 21, 1996
Moved by Powers supported by Douglas the resolution be adopted.
AYES: Kingzett, McCulloch, McPherson, Moffitt, Obrecht, Palmer, Pernick,
Powers, Quarles, Schmid, Taub, Wolf, Amos, Crake, Devine, Dingeldey, Douglas,
Garfield, Holbert, Huntoon, Jacobs, Jensen, Johnson, Kaczmar. (24)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolution was adopted.
ry Executive Date
L. Brooks,triterson, County Executive Date
I HEREBY HE FOREGOING RESOLUTION
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 November 21, 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 21st day of November 1996.
ap
Lynn/D.-Allen, County Clerk %gum