Loading...
HomeMy WebLinkAboutResolutions - 1999.03.17 - 25783MISCELLANEOUS RESOLUTION #99053 March 18, 1999 BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - 1999 BUDGET AMENDMENTS FOR APPROVED OFFICE AUTOMATION PROJECTS To the Oakland County Board of Commissioners Chairperson, Ladies and Gentlemen: WHEREAS Miscellaneous Resolution #94009 (Department of Information Technology - 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. NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners approves amendments to the FY 1999, FY 2000 Biennial Budget as detailed in the attached Information Technology Office Automation Schedule for projects approved in the first quarter of 1999. BE IT FURTHER RESOLVED that the FY 1999 and FY 2000 Biennial Budget be amended as follows: 1. The cost, to the governmental funds, of implementing and operating the new technology is $887,571 in FY 1999, $878,280 in FY 2000, as detailed on the attached schedule. 2. Funds are available in the non-departmental Office Automation account to cover the cost to the governmental funds. The 1999 and 2000 budget should be amended, as detailed on the attached Schedule, to cover the cost of the approved office automation projects. Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution. FINANCE COMMITTEE FINANCE COMMITTEE VOTE: Motion carried unanimously on a roll call vote. EY1999 et200Q 878,280 sua 887,571 $887,571 $878,280 Total Governmental Funds SLIM SUSI INFORMATION TECHNOLOGY'S OFFICE AUTOMATION SCHEDULE - FIRST QUARTER, F.Y. 1999 GOYERNMENIALEUNQS Revenue Espendautes General Fund (101j 90-290000-25000-9066 51-231000-53000-6636 31-101200-10001-6636 21-221000-01000-6636 19-221000-10000-6636 11-210100-01000-6636 11-210500-01000-6636 11-250100-20000-6636 61-211001-10000-6636 16-912000-15000-6636 19-240000-40016-6636 15-402200-10001-6636 34-401200-40001-6636 41-211000-10000-6636 17-501200-10001-6636 43-023310-20021-6636 Health Fund [221] 16-201200-10000-6636 1st Quarter Transfer Information Technology Operations: Departrnent Board of Commissioners Circuit Court Clerk/Register of Deeds Community & Economic Development County Executive County Executive County Executive Drain Commissioner Human Services Management & Budget Personnel Probate Court Prosecutor Public Services Sheriff Human Services Total Revenue Office Automation Division Research Library Circuit Court Clerk - Legal Development & Planning County Executive Community/Minority Affairs Corporation Counsel Drain Commissioner Medical Examiner Equalization Personnel Probate Prosecutor Cooperative Extension Sheriff Sub-Total General Fund Friend of the Court Sub-Total Fund 215 Health Sub-Total Fund 221 Friend of the Court Fund [215] 31-201200-10004-6636 Circuit Court 82,176 82,176 16,812 16,812 10,272 10,272 10,392 10,392 188 0 5,292 5,292 10,584 10,584 5,136 5,136 5,250 5,136 336,348 336,348 5,292 5,292 15,408 15,408 12,768 12,768 5,136 5,136 5136 526,190 525,888 58.992 58-992 58,992 58,992 90-424 82.964 90,494 69,964 Juvenile Maintenance Fund [293] 16-501200-25000-6636 Childrens Village Childrens Village Sub-Total Fund 293 211.895 203.436 211,895 203,436 c:1123wIcagobacctgba-amenc1-FY990A.WK4 Prepared by Unda Swartz. Info Tech; 01/26/99 $887,571 $878280 10.329 10272 $897,900 $888,552 $140,618 $140,618 5,754 5,754 914 78,314 0 $225.600 3146.372 5872 3(10 CALM Chki Fund 97-98 L2221 earks_LRecreation Fund 1208] CMH - Administration Sub-Total Fund 222 Parks & Recreation - Admin Sub-Total Fund 208 Boma 18-636111-10000-0737 18-636111-10000-071Z Governmental Operations Non-governmental Operations Sub-Total Expanses 18-636162-15000-3900 18-636162-15000-2776 18-636162-15000-3596 18436162-15000-4260 18-636122-15000-3348 Depreciation Equipment Repairs & Maint Software Parts & Accessories Professional Services Sub-Total 18-636113-10000-8005 Revenue Over (Under) Expense 5.136 5136 5,136 5,136 5.136 5.123 5,136 5,193 INFORMATION TECHNOLOGY'S OFFICE AUTOMATION SCHEDULE • FIRST QUARTER, F.Y. 1999 E11999 PRINAMERNMENIALEIHN Ef2.0120 cA123wicsyobacctgioa-amend11-FY990AMK Prepared by Linda Swart:. Info Tedr. 01128199 5,193 CMH - Administration 3,210 211 CMH Central Services 5,136 5,136 (1) System 3, (1) Winbeep 5,136 (1) System 3 2,721 290 Parks & Recreation Admin INFORMATION TECHNOLOGY'S OFFICE AUTOMATION SCHEDULE - FIRST QUARTER, F.Y. 1999 FY1999 FY2000 Operating Expense Capital Initial FY1999 FY 2000 Department Division Required Expense NON-GOVERNMENTAL & SPECIAL FUNDING Equipment Type TOTAL NON-GOVT. & SPECIAL FUNDING $5,931 $501 $10,329 $10,272 OFFICE AUTOMATION RESERVE FUNDING Board of Commissioners Research Library 45,872 5,810 82,176 82,176 (16) System 3 Circuit Court Circuit Court 11,108 0 16,812 16,812 (1) Notebook 3; (2) System 3; (1) Laserprinter 1 Clerk/Register of Deeds Clerk - Legal 5,024 1,798 10,272 10,272 (2) System 3 Community & Economic Development Development & Planning 8,817 1,895 10,392 10,392 (1) System 4 , County Executive County Executive 0 291 188 0 (1) Procomm Software) County Executive Community/Minority Affairs 4,899 0 5,292 5,292 (1) Notebook 3 County Executive Corporation Counsel 8,318 0 10,584 10,584 (2) Notebook 3 Drain Commissioner Drain Commissioner 2,721 0 5,136 5,136 (1) System 3 Human Services Medical Examiner 2,721 741 5,250 5,136 (1) System 3; (2) VVinbeep Management & Budget Equalization 264,949 6,946 336,348 336,348 (41) Notebook 3; (23) System 3; (1) Laserprinter 1 Personnel Personnel 3,625 0 5,292 5,292 (1) Notebook 3 Probate Court Probate 8,163 870 15,408 15,408 (3) System 3 Prosecutor Prosecutor 8,456 580 12,768 12,768 (2) System 3; (2) Laserprinter 1 Public Services Cooperative Extension 2,721 290 5,136 5,136 (1) System 3 Sheriff Sheriff 2,867 405 5,136 5,136 (1) System 3 • Circuit Court Friend of the Court 30,646 19,778 • 58,992 58,992 (11) System 3; (2) Laserprinter 1 Human Services Health 51,449 5,859 90,494 89,964 (1) Notebook 3; (16) System 3; (2) Laserprinter 1; (7) Winbeep; (1) SPSS Childrens Village Childrens Village 94,185 33,464 211,895 203,436 (64) System 1; (1) Laserprinter 2, (31) Printer < $500 TOTAL OFFICE AUTOMATION GRAND TOTAL ALL PROJECTS 556,541 78,727 562,472 79,228 887,571 878,280 897,900 888,552 C 23wks1jobacctgba-amend 1-FY990A VVK4 1r GIJOIGIJ Department Description Non-Governmental & Special Funding Community Mental Health G6-200 PC Anbeep PCMCIA Card Total Community Mental Health: PU14 & Recreation GP6-333 PC 17" EV700 Monitor Total Perlis & Recreation: Office Automation Reserve Funding Children& Village Powemiate PC CLR LSJet 5 Printer Deskjet 670C Printer Astra 1220 P Comweb HUD Total Children& Village: Circuit Court Versa 6260 GP6-333 PC LSJET 4000TN Printer Total Circuit Court: Clerk - Legal Clam-Legal GP6-333 PC Cfnst 501101 Monitor Total Clerk - Legal: Community & Minority Affairs Versa LX otal Community & Minority Affairs: Cooperative Extension GP6-333 PC 17" EV700 Monitor Total Cooperative Extenaion: Corporation Counsel Versa 6260 Total Corporation Counsel: County Executive ProComm Modem (288) Total County Executive: 1Revenue Ti One-me Quarterly FY '99 Billing , _ _Billing ,.. Billing _ O 1,284 57 0 57 O 1,284 0 0 0 0 System 1 0 50,112 200,448 terprinter 2 0 747 2,988 inter < 5500 7,071 0 7,071 nter 4 $500 1,388 0 1,388 O 0 0 8,459 211,895 O 1,323 5,292 O 2,568 10,272 O 312 1,248 O 18,812 O 2,568 0 0 O 1,3231 5,292 0 10,272 0 10,272 0 5,292 O 1,2841 5,136 O 0 0 O 5,135 O 2,6461 10,584 0 10,584 188 0 188 188 0 188 vice rtpll on ystem 3 ihnbeep ystem 3 otebook 3 System 3 serprinter 1 ystem 3 otebook 3 ystem 3 otebook 3 m Software Total Maint 180 0 180 208-2-53-201000-10001-2564 45 0 1 45 222-2-55-000105-10120-6636 0 Account 011 0 II 01 01 01 293-2-16-501200-10000-6636 101-2-21-221000-01000-6636 101-2-11-210500-01000-6636 101-2-31-101200-10001-6636 180:1 0 1801 101-2-17-501200-10001-6636 0 101-2-11-250100-20000-6636 0 01 101-2-11-210100-01000-6636 5,136 57 0 5,193 5,136 0 6,136 Maintenance Per Device 45 180 0 180 32 180 0 0 01 3601 32 3921 360 0 360 0 0 180 0 0 1ST QUARTER, 1999 OA AMENDMENTS - SUMMARY Operating Expenses Dirty. Units Total Initial Expensesi Total Rate C _C Software_ Parte/Ace initial Esp. Per nit _ 1 1 3,210 0 0 1,284 iW 1 0 41 0 (1) ' 1 0 0 170 3,210 41 170 211 2,721 0 0 1,284 (1)1 1 0 0 290 2,721 0 290 1 64 90,688 0 0 783 (64) 1 3,497 0 0 747 (1) La 26 0 0 5,069 0 (26) Pr 5 0 0 995 0 (5) Pri 2 0 0 27,400 I 94,185 0 33,464 33,4841 1 4,159 0 0 1,323 (1) N 2 5,442 0 0 1,284 (2) 1 1,507 0 0 312 (1) La 11,108 0 0 2 5,024 0 0 I , 1,284 (2)1 1 0 0 1,798 1 5,024 0 1,798 1,7981 I 1 4,899 0 0 1,323 (1) N 4,899 0 0 1 2,721 0 0 1,284 (1)! 1 0 0 290 2,721 0 290 2 0,318 0 0 1,323 (2) N 8,318 0 0 1 1 0 135 0 (1) ProCi 1 0 0 156 136 168 291 c:1123wks4obacctgba-amenc81 -FY99WS VVK4 1 Depwtment Development and Planning 21 Total Development and Planning: Dram Commotion Total Drain Commission: Total Health: Medical Examiner CF 17 Tote! Medical Examiner: Personnel Vs Total Personnel: Probate Prosecutor Total Prosecutor: Total Equalization: Friend of the Court CF LS Cn Total Friend of the Court: CF 17 Total Probate: CF LS 17 Ve CF IS 1.1; 17' Equalization Health Vs CF LS SF 17 Vii Total I Account I Nlaint _ 0 0 011 101-2-19-221000-10000-6636 1801 180 1;i 101-2-61-211001-10000-6636 101-2-19-240000-40016-6636 215-2-31-201200-10004-6636 221-2-16-201200-10000-6636 101-2-16-912000-15000-6636 101-2-15-402200-10001-6636 101-2-31401200-40001-6636 101-2-41-211000-10000-6636 112 94 0 206 0 1,288 47 0 0 1,335 616 94 0 710 0 896 94 0 0 0 0 0 990 56 0 56 0 0 168 0 168 1ST QUARTER, 1999 OA AMENDMENTS - SUMMARY Operating Elpinsoo Qtrly. Revenue Maintenance ' Description Units ER Initial Expenses I Total Rate Device One-Time Quarterly FY '99 Per Software Parts/Acc Initial Exp. Per Unit Description _ Bitting Billing Billing _ Device 325 PC 1 8,817 0 0 2,598 (1) System 4 0 2,598 10.392 0 ' Clr Mntr 1 0 0 1,895 0 0 0 0 8,817 0 1,895 1,895 0 10,392 '8-333 PC 1 2,721 0 0 1,284 (1) System 3 0 0 5,136 180 2.721 0 0 0 0 5,136 rsa LX 41 200,859 0 0 1,323 (41) Notebook 3 0 54,243 216,972 0 '6-333 PC 23 62,583 0 0 1,284 (23) System 3 0 29,532 118,128 56 Jet 4000TN Printer 1 1,507 0 0 312 (1) Laserprinter 1 0 312 1,248 47 i Access 1 0 276 0 0 0 0 0 " EV700 Monitor 23 0 0 6870 0 0 0 0 264,949 276 6,670 6,946 0 336,148 '6-333 PC 11 27,632 0 0 1,284 (11) System 3 0 14,124 56,496 56 Jet 4000TN Printer 2 3,014 0 0 312 (2) Laserprinter 1 0 624 2,496 47 1st 50 / 101 Cob( Mon. 11 0 0 19,778 0 0 0 0 30,646 0 19,778 19,778 0 58,992 rsa LX 1 4,899 0 0 1,323 (1) Notebook 3 0 1,323 5,292 0 '6-333 PC 16 43,536 0 0 1,284 (16) System 3 0 20,544 82,176 56 1 JET 4000TN Printer 2 3,014 0 0 312 (2) Laserprinter 1 o 624 2,496 47 nbeep 7 0 287 0 (7)1Mnbeep 400 0 400 'SS 1 0 93 0 (1) SPSS Software 130 0 130 1 " EV700 Monitor 13 0 0 2,320 0 0 -, 0 o ritron 500 Monitor 8 o 0 2,760 0 0 0 0 i" Crystal Monitor 1 o 0 399 0 0 0 0 51,449 380 5,479 5,8591 530 90,494 '6-333 PC 1 2,721 o 0 1,264 (1) System 3 o 1,284 5,136 56 nbeep 2 0 82 0 (2) Winbeep 114 0 114 " Vivitron Monitor 1 0 0 659 0 0 0 0 2,721 82 659 741 114 5,250 as 6030H 1 3,625 0 0 1,323 (1) Notebook 3 0 1,323 5,292 0 3,625 0 0 0 0 5,292 '6-333 PC 3 8,163 0 0 1,284 (3) System 3 0 3,852 15,408 56 " EV700 Monitor 3 0 0 870 0 0 0 0 $113 0 870 570 0 15,408 ,6-333 PC 2 5,442 0 0 1,284 (2) System 3 0 2,568 10,272 56 ;JET 4000TN Printer 2 3,014 0 0 1 312 (2) Laserprinter 1 0 624 2,496 47 " EV700 Monitor 2 0 0 580 0 0 0 0 8,456 0 680 580 0 12,768 AM 2 c:1123wks4obacctiNa-amenth1 -FY99VVS.VVK4 Department Rasearch Library Total Research Library: Sheriff Total Sheriff: 1ST QUARTER, 1999 OA AMENDMENTS - SUMMARY — Operatiripktrinsis Qtly. RI Description Units -Total Initial Expanses 1 Total Rate Device One-Time Quarterly F C s tal $oftware Parts/Ace Initial E Par Unit Descdplion 1301ing__ Billing _ GP6-333 PC 16 45,872 0 0 1,284 (16) System 3 0 20,544 Vivitron 500 Monitor 16 0 0 5,520 0 0 '17" EV700 Monitor 1 0 0 290 0 45,872 0 5,810 5,810 0 6P6-333 PC 1 2,867 0 0 1,284 (1) System 3 1 0 1,284 Vsvitron 500 Monitor 1 0 0 405 0 0 2,887 0 405 405 0 venue Il Maintonance i Y '991 Per IL Total 1., Account a litIng _ Device ___I Maint _ I.__ _ _ .__ _ . _ _ 1 82,176 —561— 896 R 0 0 0 Li 0 0 0 q 82,1781 896(1 101-2-51-231000-53000-6636 5,136 0 5,138 560 58 101-2-43-023310-20021-6636 01/07/99; 10:27 AM 3 c:‘123wks4obacctgba-amench1-FY99WS1NK4 L. Eimoks yCount Executive K'le(9...46Aft G.'William Caddell, County Clerk Resolution #99053 March 18, 1999 Moved by Douglas supported by Patterson the resolution be adopted. AYES: Coleman, Devine, Dingeldey, Douglas, Galloway, Garfield, Gregory, Jensen, Law, McCulloch, McPherson, Melton, Moffitt, Obrecht, Palmer, Patterson, Schmid, Sever, Suarez, Amos, Appel, Causey-Mitchell, Colasanti. (23) NAYS: None. (0) A sufficient majority having voted therefor, the resolution was adopted. I HERERY,OPRultr---ri-IE FOREGOING RESOLUTION k1 Y4 Date STATE OF MICHIGAN) COUNTY OF OAKLAND) I, G. William Caddell, 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 March 18, 1999 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 18t1). day,ef March, 1999.