Loading...
HomeMy WebLinkAboutResolutions - 2002.05.30 - 26924MISCELLANEOUS RESOLUTION #02 125 May 16, 2002 --- BY: General Government Committee, William R. Patterson, Chairperson IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - SECOND QUARTER 2002 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 2002 data processing development charges to be $1,450,840.85 and the imaging development charge to be $71,262 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $350,724.70 and non-county agencies are $0 for the Second Quarter 2002; 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 2002 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 GOVERNMENT COMMITTEE ititLI (9071t-u GENERAL GOVERNMENT COMMITTEE Motion carried unanimously on a roll call vote. ACCOUNT # DIVISION 1st Qtr Oct-Dec 2nd Qtr Jan - Mar 3rd Qtr Apr -June 4th Qtr July - Sept Y.T.D. INFORMATION TECHNOLOGY DATA PROCESSING DEVELOPMENT SUMMARY 2ND QUARTER 2002 GOVERNMENTAL FUNDS General Fund 11011 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-21-230100-01000-6030 2-21-250100-01000-6030 2-21-221000-01000-6030 2-21-240100-11000-6030 2-21-220500-01000-6030 2-19-210000-10000-6030 2-35-220000-12000-6030 2-35-242000-11000-6030 2-35-242000-44000-6030 2-35-242000-41000-6030 2-35-243000-11000-6030 2-35-230000-21200-6030 2-35-230000-22100-6030 2-35-230000-31200-6030 2-35-230000-22200-6030 2-35-210000-11000-6030 2-61-211001-10000-6030 2-11-101112-65001-6030 2-12-240000-44100-6030 2-12-601200-10001-6030 2-12-621200-10001-6030 2-13-138502-15100-6030 2-17-912000-15000-6030 2-15-402200-10001-6030 2-19-221000-10000-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-12-701200-10001-6030 2-43-023301-20000-6030 2-13-138201-00010-6030 2-22-221120-01000-6030 Health Fund 12211 2-16-201200-33100-6030 2-16-234200-54600-6030 2-16-220200-67000-6030 18-636111-10000-0735 IMAGING 2-21-221000-01000-6039 2-35-243000-33000-6039 2-34-403200-40005-6039 18-636111-10000-0573 52/1 - District Court 52/2 - District Court " 52/3 - District Court* 52/4 - District Court • Animal Control Clerk - Elections Clerk - Jury Commission Clerk - Legal Records Clerk - Register of Deeds Clerk - Vital Statistics Community & Economic Development Courts-Business Division - JIMS Courts-FD-Court Services-Admin Courts-FD-Court Services-Adoptions Courts-FD-Court Services-Casework Courts-FD-Judicial Support-Admin Courts-GJ-Judicial Support Courts-GJ-Assignment Courts-GJ-Family Support Courts-GJ-Mediation Courts-Judicial Administration * Drain Commissioner Emergency Response & Prep Unit Equalization Division * Fiscal Services - Admin * Fiscal Services - General * Materials Management - General Fund Medical Examiner Personnel * Planning and Economic Development * Probate-Estates/Mental Health Support Probate-FD-Judicial Probate-FD-Judicial Support Prosecuting Attorney Purchasing Reimbursement Division Sheriff " Support Services Treasurer Sub-Total Fund 101 Health Health - Clinic Health Environmental Sub-Total Fund 221 DATA PROCESSING DEVELOPMENT FOR GOVERNMENTAL FUND APPROPRIATION Clerk Image Courts-FD-Juv-Sup-Imaging Probate-Estates/Mental Health Image TOTAL IMAGING DEVELOPMENT $10,213.10 $11,954.25 10,213.10 11,954.25 10,213.10 11,954.25 10,213.10 11,954.25 1,080.00 205.20 3,816.00 9,805.00 7,572.50 3,269.00 7,180.00 7,015.50 8,588.00 35,927.00 6,213.00 13,272.00 1,134.00 7,896.50 183.00 4,534.00 1,028.00 4,611.00 6,545.00 9,904.00 108.00 184.00 1,202.00 1,742.00 13,661.40 22,263.00 2,831 .50 2,638.00 8,577.50 5,016.00 392.00 299.00 4,630.00 42,894.00 3,106.00 0.00 13,741.25 271,409.50 243,743.00 123,862.30 291,992.30 22,483.90 0.00 14,530.25 19,664.60 9,961.80 71,880.80 135,563.20 12,256.50 4,416.00 2,157.00 1,156.00 3,321.00 2,366.00 1,098.00 366.00 23,242.00 20,354.50 5,597.00 16,745.25 25,749.50 24,057.00 74,754.50 66,788.00 1,563.00 1,136.00 69 346.00 107 738.50 $847,085.90 $1,173,947.25 20,358.80 4,623.80 244.00 204 027.30 269 487.80 $224,386.10 $274,355.60 3,618.00 2,538.00 $3,618.00 $2,538.00 51.075.090.00 $1,450,840.86 50,495.00 51,111.00 108.00 108.00 *15.126.00 20.043.00 $65,729.00 $71,262.00 $22,167.35 22,167.35 22,167.35 22,167.35 1,285.20 13,621.00 10,841.50 14,195.50 44,515.00 19,485.00 9,030.50 4,717.00 5,639.00 16,449.00 292.00 2,944.00 35,924.40 5,469.50 13,593.50 691.00 47,524.00 3,106.00 13,741.25 515,152.50 415,854.60 22,483.90 14,530.25 29,626.40 207,444.00 16,672.50 3,313.00 5,687.00 1,464.00 43,596.50 22,342.25 49,806.50 141,542.50 2,699.00 177,084.50 $2,021,033.15 24,982.60 244.00 473 515.10 $498,741.70 6,156.00 6,156.00 $ 2,525,930.86 101,606.00 216.00 35 169.00 $136,991.00 Juvenile Maintenance Fund 2931 2-16-501200-25001-6030 Children's Village Sub-Total Fund 293 APPROPRIATION SUB-TOTAL GOVERNMENTAL! IMAGING DEVELOPMENT APPROPRIATION: $1,140,819.00 $1,522,102.85 Information Technology Development ($1.140,819.00) ($1,522,102.85) TOTAL GOVERNMENT: $0.00 $0.00 *1st Quarter invoiced in January 2002 Prepared by: Linda Munk, Info Tech; 3/26/2002; 11:15 AM 90-290000-25000-6030 $ 2,662,921.85 ($2,662,921.85) 0.00 2nd qtr 2002.xls INFORMATION TECHNOLOGY DATA PROCESSING DEVELOPMENT SUMMARY 2ND QUARTER 2002 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr ACCOUNT # DIVISION Oct-Dec Jan - Mar Apr- June July - Sept NON-GOVERNMENTAL DIRECT CHARGES CLEMIS * 91,466.25 2,590.00 94,056.25 Community Corrections 446.00 5,946.00 6,392.00 Courts-FOC-Exp-CS Enforcement 277.00 2,026.00 2,303.00 Courts-FOC Exp-CS Enforcement Image 6,154.00 12,085.00 18,239.00 Courts-FOC Exp-Family Counseling 4,220.00 0.00 4,220.00 Fire Records Management System "-* 54,460.00 54,460.00 F M & 0 366.00 366.00 Health Immunization 1,198.80 2,467.80 3,666.60 Materials Management 2,228.00 2,228.00 Medical Care Facility 2,322.80 8,813.60 11,136.40 PA189 Projects " 218,841.96 217,819.50 436,661.46 Parks and Recreation - Administration 244.00 34,788.80 35,032.80 , Risk Management 1,446.00 2,662.00 4,108.00 Treasurer - 100% Tax Payment Fund 12,778.00 2,125.00 14,903.00 Water & Sewer Accounting 5,643.00 4,575.00 10,218.00 18-636111-10000-0715 SUB-TOTAL DIRECT CHARGES FOR DATA $347,265.81 $350,724.70 $697,990.51 PROCESSING DEVELOPMENT TOTAL COUNTY DEVELOPMENT CHARGES $1,488.084.81 $1,872,827.55 $3.360,912.36 NON-COUNTY AGENCIES 18-636111-10000-0429 Non-County Agencies $0.00 $0.00 $0.00 TOTAL DEVELOPMENT CHARGES $1,488,084.81 $1,872,827.55 $3,360,912.36 " 1st Quarter invoiced in January 2002 ** 1st Qtr $26,676; 2nd Qtr $24,246 Y.T.D. Prepared by: Linda Munk, Info Tech; 3120/2002; 4:24 PM 2nd qtr 2002.xls INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2002 Cust # GOVERNMENTAL FUNDS 630 ANIMAL CONTROL DIVISION 95682 Dog System $205.20 Animal Control Division - Total $205.20 665 CHILDRENS VILLAGE . 95665 Childrens Village $2,538.00 Childrens Village - Total $2,538.00 440 CLERK - ELECTIONS 95443 Elections $9,805.00 Clerk -Elections - Total $9,805.00 720 CLERK! REGISTER OF DEEDS 95493 Reg Deeds System Maintenance $4,752.00 95498 Clerk Reg of Deeds 24,050.00 95558 User Support/ROD 7,125.00 * Clerk/Reg of Deeds - Total $35,927.00 722 CLERK - IMAGING 65420 Clerk - Image Replace - 21% $10,656.00 95158 Clerk - Imaging 40 455.00 Clerk - Imaging - Total $51,111.00 410 CLERK -JURY COMMISSION 95512 Jury Commission $3,269.00 Clerk -Jury Commission - Total $3,269.00 724 CLERK - LEGAL RECORDS 95189 Circuit Court System $7,015.50 Clerk - Legal Records - Total $7,015.50 723 CLERK -VITAL STATISTICS 95161 Vital Stats Index $13,272.00 Clerk - Vital Statistics - Total $13,272.00 785 COMMUNITY & ECO DEVELOPMENT 95785 Comm & Eco Developmt $7.896.50 Community & Eco Dev - Total $7,896.50 495 CTS-BUSINESS DIV - JIMS 95176 CTS-Business Div - JIMS $4,534.00 CTS-Business Div - JIMS - Total $4,534.00 487 CTS-FD-COURT SERVICES-ADMIN 95196 CTS-FD-Ct Serv-Admin $4,611.00 CTS-FD-Ct Serv-Admin - Total $4,611.00 492 CTS-FD-CT SERV-ADOPTIONS 95173 CTS-FD-Ct Serv-Adoptions $9,904.00 CTS-FD-Ct Serv-Adoptions - Total $9,904.00 489 CTS-FD-CT SERV-CASEWORK 95197 CTS-FD-Ct Serv-Casework $184.00 CTS-FD-Ct Serv-Casework - Total $184.00 483 CTS-FD-JUDICIAL SUPPORT-ADM 95193 CTS-FD-Judicial Suport-Adm $1,742.00 CTS-FD-Judicial Suport-Adm - Total $1,742.00 488 CTS-FD-JUV SUPP-IMAGING 48201 CTS-FD-Juv Supp-Imaging $108.00 CTS-FD-Juv Supp-Imaging - Total $108.00 499 CTS-GJ-ASSIGNMENT 95180 CTS-GJ-Assignment $2,638.00 ._._ CTS-GJ-Assignment - Total $2,838.00 420 CTS - GJ -FAMILY SUPPORT 95195 Cir Crt Admin $5,016.00 Courts - GJ - Family Support - Total $5,016.00 498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS -Gen Juris-Judicial Suppt $22,263.00 CTS -Gen Juris-Judicial Suppt - Total $22,263.00 500 CTS-GJ-MEDIATION 95181 CTS-GJ-Mediation $299.00 CTS-GJ-Mediation - Total $299.00 493 CTS-JUDICIAL ADMIN 95174 CTS-Judicial Admin $42,894.00 CTS-Judicial Admin - Total $42,894.00 900 EMERGENCY RESPONSE & PREP UNIT 98990 Emergency Response $13,741.25 Emer Resp & Prep Unit - Total $13,741.25 Prepared by Linda Munk; Information Technology; 3/2012002 1 2nd qtr 2002.xls Gust # GOVERNMENTAL FUNDS 740 EQUALIZATION 660 FISCAL SERVICES ADMIN INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER, 2002 31075 Equal - Development $3,726.00 31078 EPP-Development 32,049.00 95559 User Support/Equal 46,591.00 95693 Equal-System Maintenance 161 377.00 Equalization - Total 44021 FS-System/Customer Support $39,206.00 44022 FS-System Maintenance 51,315.50 44024 FS-New Development 48,904.50 95702 FS-PSMS-25% 14,314.25 95703 Budget-PSMS - 25% 14,314.25 96001 * Human Res-Acct 82,825.20 96003 Human Res.-Budget 41 312.60 Fiscal Services Admin - Total $243,743.00 $291,992.30 845 HEALTH - CLINIC 37007 Clinic $244.00 Health - Clinic - Total $244.00 840 HEALTH DEPARTMENT 37025 CHAMPS - P.O.P. $405.00 95563 User Support / Health 3,560.00, 96842 Health - Admin 658.80 Health - Total $4,623.80 843 HEALTH - ENVIRONMENTAL 37002 Environmental $1,112.40 84200 EH - Projects 73,816.40 84300 Ehealth Program 194 559.00 Health-Environmental - Total $269,487.80 641 MATERIALS MANAGEMENT-GEN FUND 95440 Materials Management $216.00 95704 Mat Mgmt - PSMS - 25% 14 314.25 Materials Mgmt-Gen Fund - Total $14,530.25 872 MEDICAL EXAMINER 87202 Med Exam - Cust Support $9,961.80 Medical Examiner - Total $9,961.80 680 PERSONNEL 44044 PER-New Development $27,785.50 , 95556 Personnel User Supt 13,781.00 96002 Human Res-Personnel 93,996.70 Personnel - Total $135,563.20 775 PLANNING & ECONOMIC DEVELOPMENT 95608 Plan'g & Econ Dev-Data Warehouse $4.416.00 Planning & Eco Development - Total $4,416.00 512 PROB-ESTATES/MENTL HLTH IMAGE 95207 Prob-Est/Mntl Hlth Image $20,043.00 Prob-Est/Mntl Hlth Image - Total $20,043.00 510 PROB-ESTATES/MENTL HLTH SUPPORT 92198 Prob-Est/Ment Hlth Support $1,156.00 Prob-Est/Ment Hlth Support - Total $1,156.00 479 PROB-FD JUDICIAL SUPPORT 95188 Prob-FD Judicial Sup $366.00 Prob-FD Judicial Sup - Total $368.00 481 PROBATE-FD JUDICIAL 95168 Prob-FD Judicial $2,366.00 Prob-FD Judicial - Total $2,386.00 145 PROSECUTOR 95622 Prosecutor/Executive $19,866.50 97001 Prosecutor Data Proc 488.00 Prosecutor - Total $20,354.50 690 PURCHASING 44026 PUR-System/Customer Support $432.00 44027 PUR-System Maintenance 108.00 44028 PUR-System Enhancements 1,891.00 95701 PUR-PSMS-25% 14,314.25 Purchasing - Total $16,745.25 Prepared by Linda Munk; Information Technology; /20/2002 2 2nd qtr 2002.xls Cust# GOVERNMENTAL FUNDS 650 REIMBURSEMENT - INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - SECOND QUARTER, 2002 95470 Reimbursement System $6,802.00 95542 Reimburse User Support 17 255.00 Reimbursement - Total $24,057.00 97163 Sheriff $ 65,690.00 195 SHERIFF 97164 Sheriff - Development 1,098.00 Sheriff - Total $66,788.00 445 SUPPORT SERVICES 44500 Support Services $1,136.00 Support Services - Total $1,136.00 600 TREASURER 44012 Ire-Data Warehousing $9,504.00 44061 Ire-System/Customer Support 3,296.50 44062 Ire-System Maintenance 1,580.00 44063 Tre-System Enhancements 648.00 95303 Del Tax System Maintenance 39,479.00 95483 Fund Management 864.00 95008 Del Tax On Line 9,333.00 95561 User Support/Del Tax 43 034.00 Treasurer - Total $107,738.50 540 52/1 DISTRICT COURT - NOVI 95527 DC Supd-25%-52/1 $11,954.25 52/1 District Court - Total $11,954.25 550 52/2 DISTRICT COURT - CLARKSTON 95528 DC Supd-25%-52/2 $11,954.25 52/2 District Court - Total $11,954.25 560 52/3 DISTRICT COURT - ROCHESTER 95529 DC Suprt-25%-52/3 $11,954.25 52/3 District Court - Total $11,954.25 530 52/4 DISTRICT COURT - TROY 95530 DC Supd-25%-52/4 $11,954.25 52/3 District Court - Total $11,954.25 Prepared by Linda Munk; Information Technology; 3/20/2002 3 2nd qtr 2002.xls INFORMATION TECHNOLOGY- RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - SECOND QUARTER, 2002 Cust # DIRECT FUNDS 055 CLEMIS 95432 CLMS Adhoc Reports $2,590.00 CLEMIS - Total 521 COMM CORR-ADM (GRANT) 65701 Community Corrections Grant $5,946.00 Community Corrections - Total 507 CTS-FOC EXP-CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforc-Dev $2,026.00 CTS-FOC Exp-CD Enforc-Dev - Total 471 CTS-FOC-EXP-CS ENFORC-IMAGE 92194 CTS-FOC-Exp-CS Enf-Image $12,085.00 CTS-FOC Exp-CS Enf-Image - Total $2,590.00 $5,946.00 $2,026.00 $12,085.00 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $27,784.00 21010 Fire Records Mgmt Fund 531 (1st Qtr) 26 676.00 Fire Records Mgmt - Total $54,460.00 750 FM&O 75003 FM&O Development $366.00 F M & 0 - Total $366.00 380 HEALTH IMMUNIZATION - GRANT 38000 Health - Immunization $2,467.80 Health - Immunization - Total $2,467.80 870 MEDICAL CARE FACILITY 98873 MCF - Support $8,813.60 MCF - Support - Total $8,813.60 004 PA189 PROJECTS 90603 Circ Ct - J1MS Project - 25% $54,454.88 90604 Probate - JIMS Project - 25% 54,454.88 ' 90605 Prosecutor - JIMS Project - 25% 54,454.88 90606 52/1 - JIMS Project - 6.25% 13,613.72 90607 52/2 - JIMS Project - 6.25% 13,613.72 90608 52/3 - JIMS Project - 6.25% 13,613.72 90609 52/4 - JIMS Project - 6.25% 13,613.70 $217,819.50 770 PARKS AND RECREATION 95419 PRADM-Administration $34,788.80 Parks & Recreation - Total $34,788.80 695 RISK MANAGEMENT 95695 Risk Management $2,662.00 Risk Management - Total $2,662.00 602 TREASURER-100% TAX PAYMENT FUND 95310 Del Tax Act 123 Project $2,125.00 Treasurer 100% Tax Pymt Fund - Total $2,125.00 656 WATER & SEWER ACCTG 44049 WS-New Development $3,355.00 95669 Water & Sewer Acct'g 1,220.00 Water & Sewer Acct'g - Total t $4,575.00 NON-COUNTY AGENCIES $0.00 Prepared by Linda Munk; Information Technology; 3/20/2002 4 2nd qtr 2002.xls Resolution #02125 May 16 2002 The Chairperson referred the resolution to the Finance Committee. There were no objections. FISCAL NOTE (M.R. #02125) May 30, 2002 BY: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - SECOND QUARTER 2002 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 2002 Development cost to benefiting departments. 2. The second quarter data processing development charges are $1,450,840.85; imaging development charges are $71,262 for General Fund/General Purpose County departments; direct charges to Special Revenue and Proprietary fund departments are $350,724.70 and Non-County agencies are $0. 3. The respective departmental Fiscal Year 2002 budgets are to be amended as specified on the attached detailed schedule. FINANCE COMMITTEE FINANCE COMMITTEE Motion carried unanimously on a roll call vote with Friedman Appel and Melton absent. G. William Caddell, County Clerk • Resolution #02125 May 30, 2002 Moved by Moss supported by Crawford the resolutions on the Consent Agenda be adopted (with accompanying reports being accepted). AYES: Appel, Brian, Buckley, Causey-Mitchell, Coleman, Crawford, Dingeldey, Douglas, Galloway, Garfield, Gregory, Law, McPherson, Melton, Middleton, Moffitt, Moss, Obrecht, Palmer, Patterson, Sever, Suarez, Taub, Webster, Amos. (25) NAYS: None. (0) A sufficient majority having voted therefore, the resolutions on the Consent Agenda, were adopted (with accompanying reports being accepted). HFREBY E FOREGOING RESOLUTV ooks Pat----—ourttv 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 May 30, 2002, with the original record thereof now remaining in my office. In Testimony Whereof, I have hereunto set my hand and affixed the seal of thfr County of Oakland at Pontiac, Michigan this 30th day of May, 2002.