Loading...
HomeMy WebLinkAboutResolutions - 2012.05.02 - 20194MISCELLANEOUS RESOLUTION #12110 May 2,2012 BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — SECOND QUARTER 2012 DEVELOPMENT APPROPRIATION TRANSFER TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS Chairperson, Ladies and Gentlemen: WHEREAS all 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 2012 development charges to be $873,737.66 and the imaging development charge to be $3,344.70 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $184,019.56, hon-governmental imaging development are $1,560.86, and non-county agencies are $8,667.00 for the Second Quarter 2012; 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 2012 Development Report and approves the Second Quarter appropriation transfer as specified on the attached schedule. BE IT FURTHER RESOLVED that the respective departmental Fiscal Year 2012 budgets are to be amended as specified in the attached detailed schedule. FINANCE COMMITTEE FINANCE COMMITTEE Motion carried unanimously on a roll call vote. GUST # FUND # ACCOUNT it INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 2ND QUARTER 2012 DIVISION 1st Qtr 2012 Oct - Dec 2nd Qtr 2012 Jan - Mar Y.T D. 540 101 550 101 560 101 530 101 630 101 005 101 725 101 440 101 410 101 724 101 720 101 723 101 522 101 430 101 495 101 483 101 474 101 498 101 502 101 493 101 785 101 004 101 740 101 660 101 900 101 680 101 907 101 872 101 710 101 206 101 775 101 510 101 145 101 650 101 195 101 191 101 GOVERNMENTAL FUNDS General Fund 11011 10100-3020201-121020-773630 10100-3020301-121020-773630 10100-3020401-121020-773630 10100-3020501-121020-773630 10100-1070801-114000-773630 10100-5010101-180010-773630 10100-2010201-180000-773630 10100-2010301-185010-773630 10100-2010501-125000-773630 10100-2010210-125000-773630 10100-2010401-172190-773630 10100-2010205-132300-773630 10100-1070401-113000-773630 10100-1010501-181020-773630 10100-3010201-121110-773630 10100-3010403-121100-773630 10100-3010401-121240-773630 10100-3010301-121130-773630 10100-3010301-121180-773630 10100-3010101-121100-773630 10100-1090101-171000-773630 10100-1010101-196030-773630 10100-1020501-173010-773630 10 100-1020601-1 82020-773630 10100-1010115-115090-773630 10100-1050401-183010-773630 101 00-5010303-1 65040-773630 10100-1070601-132030-773630 10100-1070501-174000-773630 10100-4030901-110040-773630 10100-1090201-171000-773630 10100-3040403-124010-773630 10100-4010101-122050-773630 10100-1020650-126020-773630 10100-4030301-112590-773630 10100-4030601-110000-773630 52/1 - District Court 52/2 - District Court 52/3 - District Court 52/4 - District Court Animal Control Bd of Commissioners Clerk - Admin Clerk - Elections Clerk - Jury Commission Clerk - Legal Records Clerk - Register of Deeds Clerk - Vital Statistics Community Corrections Adinin Corporation Counsel Courts-Business Division Courts-FD-Judicial Support-Admin Courts-FD-Juvenile Support Courts-GJ-Judicial Support Courts-GJ-Jury Operations Courts - Judical / Administration Economic Development & Community Affairs Election Redistricting Equalization Division Fiscal Services - Adrnin Homeland Security Human Resources Library - Library Admin Medical Examiner MSU Extension - Oakland OCSD - LE Support Serv Admin Planning & Economic Development Probate-Estates/Mental Healtli Support Prosecuting Attorney - General Prosecution Reimbursement Division Sheriff Sheriff - CLEMIS $4,572.65 $6,023.47 $10,596.12 $4,572.65 $6,023.47 $10,596.12 $4,572.65 $6,023.47 $10,596.12 $4,572.55 $6,023.34 $10,595.89 $21,980.72 $39,130.61 $61,111.33 $14,430.50 $61.00 $14,491.50 $1,626.00 $5,118.00 $6,74400 $2,297.00 $1,649.75 $3,946.75 $122.00 $0.00 $122.00 $14,588.00 $15,636.00 $30,224.00 $833.72 $1,358.11 $2,191.83 $3,409.47 $6,838.61 $10,248.08 $44,952,91 $37,078.71 $82,031.62 $0.00 $183.00 $183.00 $515.00 $668.44 $1,183.44 $681.22 $870.11 $1,551.33 $0.00 $1,856.00 $1,856.00 $31,996.00 $33,046.00 $65,042.00 $1,029.94 $1,214.85 $2,244.79 $2,561.30 $1,560.86 $4,122.16 $64,546.75 $75,144.50 $139,691.25 $152.50 $0.00 $152.50 $91,921.26 $71,686.19 $163,607.45 $50,090.61 $58,453.37 $103,543.98 $557.00 $529.75 $1,086.75 $25,237.30 $24,760.01 $49,997.31 $345.00 $244.00 $589.00 $6,655.72 $3,922.11 $10,578.83 $122.00 $122.00 $244.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11,898.47 $4,656.11 $16,554.58 $33,975.47 $34,972.86 $68,949.33 $4,781.25 $3,611.75 $8,393.00 $13189900 $98,925.94 $230,824.94 $6,885.94 $18,550.85 $25,436.79 Prepared by: Inforrnation Technology; 411712012 GUST # FUND # 445 101 600 101 910 101 730 101 ACCOUNT tt 10100-1030803-184025-773630 10100-7010101-186040-773630 10100-1070301-132050-773630 10100-6010101-155010-773630 669 652 055 056 659 507 $9,336.25 $0.00 $12,307.00 $8,601.00 $144,901.50 $11,748.25 NON-GOVERNMENTAL DIRECT CHARGES CAMS/CVT Data Conversion CAMS/FM° (IT Implementation) CLEMIS CLEMIS FUND 63500 Collaborative Asset Mgt Sys (CAMS) Courts-FOC Exp-CS Enforcement $7,952.50 $17,290.75 $0.00 $0.00 $20,171.24 $32,478.24 $4,331.00 $12,932.00 $78,291.00 $223,192.50 $24,862.25 $36,610.50 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 2ND QUARTER 2012 1st Oh 2012 2nd Oh r 2012 DIVISION Oct - Dec Jan - Mar Y.T D. $2,798.14 $4,332.39 $7,130.53 $154,772.50 $63,940.91 $218,713.41 $0.00 $183.00 $183.00 $43,302.72 $58,533.86 $101,836.58 $789,257.91 $692,933.40 $789,257.91 Support Services Treasurer Veterans Services Water Resource Commissioner Sub-Total Fund 101 Health Fund 12211 840 221 20221-1060201-133150-773630 843 221 20221-1060220-134390-773630 Juvenile Maintenance Fund [2931 665 293 20293-1060501-112090-773630 63600-1080101-152000-631365 GOVERNMENTAL IMAGING 722 101 10100-2010210-125000-773639 512 101 10100-3040403-124010-773639 63600-1080101-152000-630903 10100-9090101-196030-773630 Health Health Environmental Sub-Total Fund 221 Children's Village Sub-Total Fund 293 DEVELOPMENT FOR GOVERNMENTAL FUND APPROPRIATION Clerk Image Probate-Estates/Mental Health Image TOTAL GOVERNMENTAL IMAGING DEVELOPMENT APPROPRIATION SUB-TOTAL GOVERNMENTAL I IMAGING DEVELOPMENT APPROPRIATION: Information Technology Development TOTAL GOVERNMENTAL: $58,881.00 $41,571.75 $100,452.75 $112,396._89 $116,122.51 $228,519.40 $171,277.89 $157,694.26 $171,277.89 $14,640.75 $23,110.00 $37;750.75 $14,640,75 $23,110.00 $14,640.75 $975,176.55 $873,737.66 $1,848,914.21 $2,927.20 $1,783.84 $4,711.04 $2,561.30 $1,560.86 $4,122.16 $5,488.50 $3,344.70 8,833.20 $980,665,05 $877,082,36 $1,857,747.41 cr.(!.:n •5,[15) ($877j)82.361 357 7i7 11! $0.00 $0.00 $0.00 Piepared by: Informabon Technology: 1/17(2012 GUST # FUND # 210 760 750 841 653 770 791 656 736 734 670 745 737 738 ACCOUNT # 63600-1080101-152000-631302 NON-GOVERNMENTAL IMAGING 1st Qtr 2012 Oct - Dec $681.22 $0.00 $3,092.22 $0.00 $1,376.00 $30,169.50 $19,235.50 $7,697.94 $0.00 $1,092.00 $305.00 $0.00 $1,494.50 $1,311.50 $253,351.38 2nd Qtr 2012 Jan - Mar $870,11 $0.00 $4,265.11 $122.00 $2,809.00 $25,591.75 $0.00 $8,005.60 $0.00 $0.00 $510.00 $3,850.50 $183.00 $2,104.50 $184,019.56 Y.T.D. $1,551.33 $0.00 $7.357.33 $122.00 $41 185,00 $55.761.25 $19,235.50 $15,703.54 $0.00 $1,092.00 $915.00 $3,850.50 $1,677.50 $2416.00 $437.370.94 Courts-FOC Exp-CS Enforcement Image TOTAL NON-GOVERNMENTAL IMAGING EVELOPMENT APPROPRIATION $2,561.30 $2,561.30 $1,560.86 $1,560.86 $4,122.16 $4,122.16 471 63600-1080101-15200-630903 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 2ND QUARTER 2012 DIVISION Fire Records Management System FM - BOG VVebcasting FM&O Health - H1N 1 Grant O.C. Intnl Airport Parks and Recreation - Administration Radio Communications - E911 Water Resources Accountino VVinCan Central Storage Solution WRC - AMR Support WRC Acctg - Crowder Filet VVRC - COSDA Meter Replacement WRC Data Application Pilot F'oject VVRC - SCADA Engineering Assessment SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT TOTAL COUNTY DEVELOPMENT CHARGES $1,236,577.73 $1,062,662.78 $2,299,240.51 NON-COUNTY AGENCIES 63600-1080101-152000-635017 Non-County Agencies $9,792.50 $8,667.00 $18.459.50 TOTAL DEVELOPMENT CHARGES $1,246,370.23 $1,071,329.78 $2,317,700.01 Prepared by - Information Technology: 4/17/2012 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - SECOND QUARTER 2012 Gust # GOVERNMENTAL FUNDS 630 ANIMAL CONTROL 24017 SQL Server Supp - Animal Control $870.11 95628 Web License Registration 15,393.25 95682 Dog System 22,867.25 Animal Control-Total 005 BD OF COMMISSIONERS 91404 BOG - Customer Support $61.00 BOG - Customer Support - Total 665 CHILDRENS VILLAGE 95665 Childrens Village $23,110.00 Childiens Village - Total 725 CLERK- ADMIN 72500 Clerk - Admin $5,118.00 Clerk - Acimin - Total 440 CLERK - ELECTIONS 95443 Elections $1,649.75 Clerk - Elections - Total 720 CLERK / REGISTER OF DEEDS 24003 SQL Server Supp - ROD 3.5% $870.11 36510 GIS Implementation Support $122.00 36511 ROD Application -11/W Support $244.00 95493 ROD System Maintenance 122.00 Clerk/Reg of Deeds - Total 722 CLERK - IMAGING 95158 Clerk,- Imaging $1,783.84 Clerk - Imaging - Total 410 CLERK -JURY COMMISSION 95512 Clerk/Reg - Jury Commission $0.00 Clerk/Reg - Jury Commission - Total 724 CLERK - LEGAL RECORDS 95189 Circuit Court System $15,636.00 Clerk - Legal Records - Total 723 CLERK- VITAL STATISTICS 24015 SQL Server Supp - Vital Stats 3.5% $870.11 95161 Clerk.Rog - Vital Statistics 5,968.50 Clerk - Vital Statistics - Total 522 COMMUNITY CORRECTIONS-ADMIN (CO) 23003 Oracle Support-Comm Corr - 5.2% $1,214.85 24012 SQL Server Supp - Community Corr 3.5% 870.11 52200 Comm Corr-Admin (County) 34,993.75 Community Corrections - Total Prepared by. Information Technology; 4117/2012 $39,130.51 $61.00 $23,110.00 $5,118.00 $1,649.75 $1,358.11 $1,783.84 $0.00 $15,636.00 $6,838.61 $37,078.71 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - SECOND QUARTER 2012 430 CORPORATION COUNSEL 95501 Corporation Counsel $183.00 Corporation Counsel - Total $183.00 495 CTS-BUSINESS DIVISION 12002 CCT-CourtsiCriminal $61.00 23010 Oracle Support-CCTICTS Grim VVhse 2.6% 5_607.44 CTS-Business Division - Total $668.44 483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Stipp - CTS-Jud Sup Mm - 3.5% $870.11 CTS-FD-Juclicial Support-Adm - Total $870.11 474 CTS-FD-JUVENILE SUPPORT 95474 CTS-FD-Acimin-Juvenile $1,856.00 CTS-FD-Adrnin-Juvenile - Total $1,856.00 498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS-Gen Juris-Judicial Suppt $33,046.00 CTS-Gen Juris-Judicial Suppt - Total $3304600 493 CTS-JUDICIAL ADMIN 95174 CTS-Judicial Adrnin $1,560.86 CTS-Judicial Adrnin - Total $1,550.86 502 CTS-GJ-JURY OPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operations $1,214.85 CI S-GJ-Jury Operations - Total $1,214.85 785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GIS Implementation Support CE Dev $156.00 36501 CED Application. HAN Support 10,471.75 95785 Comm & Eco Developrnt 64,516.75 Economic Development & Community Affairs - Total S75,144,50 004 ELECTION REDISTRICTING 40000 Election Redistricting $0.00 Election Redistricting - Total $0.00 740 EQUALIZATION 23012 Oracle Support-Equalization - 5.2% $1,214.85 24005 SQL Server Supp-Equalization - 10.5% 2,610.13 31075 Equal - Development 856.00 36505 GIS Implementation Support Equalization 244.00 36506 Equal Application - I-INV Support 25,350.50 36601 Land System Enhancements - Equal (50%) - , 7,985.71 36701 Land System Maintenance - Equal (50%) 1,843.25 36801 Land System Support - Equal (50%) 3,224.50 95562 Equalization - ow Support 465.50 95699 BS&A Master Appraisal SupiMaint 25 891.75. Equalization - Total $71,686.19 Prepared by Information Technology; 4/17/2012 $24,760.01 $244.00 660 FISCAL SERVICES ADMIN 840 HEALTH DIVISION 843 HEALTH - ENVIRONMENTAL 900 HOMELAND SECURITY 680 HUMAN RESOURCES 907 LIBRARY - LIBRARY ADMIN 872 MEDICAL EXAMINER $3,922.11 $122.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - SECOND QUARTER 2012 23001 Oracle Support - Fiscal Serv - 15.6% $3,644.62 23013 Oracle Support - HR-Acctg/Budget - 5.2% 1,214.85 24006 SQL Serv Supp - HR-Acctg - 1.75% 435.10 44021 FS-System/Customer Support 17,724.00 44023 FS - System Enhancements 3,111.00 96001 Human Res - Acct 40% 21,549.20 96003 Human Res - Budget 20% 10,774.60 Fiscal Services Admin Total 36525 GIS Implementation Support Health $0.00 95563 User Support-Health 22,892.50 96842 Health Adrnin 18,679.25 Health - Total 23005 Oracle Support - EH Projects - 5.2% $1,214.85 24014 SQL Server Suppt - Ehealth 14% 3,480.05 84200 EH - Projects 94,400.36 84300 Ehealth Program 17 027.25 Health-Environmental - Total 36545 GIS Implementation Support Homeland Security $229.75 36546 Homeland Security Application - H/1N Support 300.00 Homeland Security - Total 23014 Oracle Support-HR/Personnel - 5.2% $1,214.85 24007 SQL Server Suppport-HR/Personnel - 1.75% 435.10 96002 Human Res-Personnel 40% 23,110.06 Human Resources - Total 91405 Libra' y Board $244.00 Library - Library Admin - Total 24002 SQL Server Support - Medical Exam - 3.5% $870.11 87202 Medical Examiner - Customer Support 3,052.00 Medical Examiner - Total $58,453.37 $41,571.75 $116,122.51 $529,75 710 MSU EXTENSION - OAKLAND 512 PROB-ESTATES/MENTL FILTH IMAGE Prepared by: Information Technology; 4/17/2012 95676 PVISU Ext Equipment Maintenance $122.00 MSU Extension - Oakland - Total 95207 Prob-Est/IVInti HIM Image $1,560.86 Prob-EstiMall Filth linage - Total $1,560.86 $870.11 3,786.00 $1,214.85 17,336.00 $18.550.85 $1,214.85 1,740.04 1,377.50 $4,332.39 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2012 510 PROB-ESTATES/MENTL HLTH SUPPORT 145 PROSECUTOR - GENERAL PROSECUTION 650 REIMBURSEMENT 195 SHERIFF 191 SHERIFF - CLEMIS 445 SUPPORT SERVICES 24010 SQL Serv Supp-PCT-EsUMental - 3.5% 92198 Prob-EstiMntl Hlth Support Prob-Est/Mntl Hlth Support - Total 95470 Reimbursement System 95542 Reimburse User Support Reimbursement - Total 23015 Oracle Suppport - Sheriff! CLEMIS - 5.2% 96163 Sheriff - CLEMIS Sheriff - CLEMIS - Total 23002 Oracle Support - Stipp Serv - 5.2% 24011 SQL Server Supp - Suppt Services 7% 44500 Support Services Support Services - Total $4,656.11 $34,972.86 $3.611.75 0.00 $3,611.75 $98,925.94 24016 SQL Server Supp Proescutors 3.5% $870.11 95622 Prosecutor/Executive 26,950.75 97001 Prosecutor Data Proc 7,152.00 Prosecutor - Total 12001 OCSD-Courts/Crirninal - 50% $61.00 23009 Oracle Suppport - OCSD/CTS Criml/Vhse - 2.6% $607.44 97163 Sheriff ,(5,621J.50) 97164 Sheriff. Development 366.00 97165 She riff-DVV Support 15,620.00 98164 CLEM1S-Sheriff 87,892.00 Sheriff - Total 600 TREASURER Prepared by; Information Technology; 411712012 ; 23006 Oracle Support - Del Tax - 5.2% $1,214.85 23016 Oracle Support - Treasurer - 10.4% 2,429.76 36516 Treasurer Application -1-1/VV Support 5,978.00 36602 Land System Enhancements - Treas (50%) 7,985.69 36702 Land System Maintenance - Trees (50 0/,,) 1,843.25 36802 Land System Support - Treas (50%) 3,224.50 44061 Tie-System/Customer Support 7,774.11 44062 Tre-System Maintenance 4,704.00 44063 Ire-System Enhancements 0.00 44080 Tre-DVV Support 0.00 95008 Del Tax On Line 0.00 95303 Del Tax System Maintenance 2,566.50 95561 User Support/Del Tax 14,823.00 95615 BS&A Annual Tax Support 11,397.25 Treasurer - Total $63,940.91 95651 Veterans Customer Support $183.00 Veterans Services - Total $183.00 910 VETERANS SERVICES 730 WATER RESOURCE COMMISSIONER 540 52/1 DISTRICT COURT- NOVI 550 52/2 DISTRICT COURT - CLARKSTON 560 52/3 DISTRICT COURT - ROCHESTER 530 5214 DISTRICT COURT - TROY Gust # DIRECT FUNDS 055 CLEMIS 056 CLEMIS FUND 63500 $870.11 33,528.75 4,578.50 5,847.00 13,709.50 $6,023.47 $6,023.47 $6,023A7 $6,023.34 $58.533.86 $6,023,47 $6,023.47 $6,023.47 $6,023.34 $1,214 85 1,215.21 6,090.18 10,370.00 244.00 1,037.00 $20,171.24 $4,331.00 $4 331.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2012 24008 SQL Server Supp - VVRC 3.5% 28010 WRC - Customer Support 28011 Water Resource Commissioner Application 36520 GIS Implementation Support VVRC 36521 WRC Application - HAN Support Water Resource Commissioner - Total 95527 DC Suprt- 52/1 - 25% 52/1 District Court - Total 95528 DC Supd- 52/2 - 25% 52/2 District Court - Total 95529 DC Stipa - 52/3 - 257,' 52/3 District Court - Total 95530 DC Suprt- 52/4 - 25% 52/4 District Court - Total 23004 Oracle Support - OakVicleo CLEMIS 5.2% 23018 Oracle Support - Sheriff CLEMIS 5.2% 24004 SQL Server Support - 24.5% 95430 CLEMIS Maintenance 95431 CLMS Enhancements 98003 CLFMIS User Support CLEMIS - Total 63500 CLEIvlIS Fund CLEMIS 63500 Fund - Iota! Prepared by: Information Technology; 411712012 $122.00 84100 Health - HINI Grant 841 HEALTH - H1N1 GRANT 653 0.5. IN TNL AIRPORT 770 PARKS AND RECREATION INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2012 669 CAMS/CVT DATA CONVERSION 66901 CAMSICVT Data Conversion $7.952.50 CAIV1S/CVT Data Conversion - Total 659 COLLABORATIVE ASSET MGT SYS 65901 CoDaher-live Asset Mgt Sys $78.291.00 Col!abortive Asset Mgt Sys - Total 471 CTS-FOC-EXP-CS ENFORC-IMAGE 92194 CTS-FOC-Exp-CS Ent-Image $1,560.136 CTS-FOC Exp-CS Enf-Image - Total 507 CTS-FOC EXP-CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforc-Dev 24,862.25 • CTS-FOC Exp-CD Enforc-Dev - Total 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgrnt Fund 531 $0.00 24001 SQL Server Support - FRMS 3.5% 870.11 Fire Records Management System - Total $7,952.50 $78,291.00 $1,560.86 $24,862.25 $870.11 750 FM&O $1,627.50 870.11 1,767.50 21001 Facilities Maintenance & Operations 24013 SQL Server Stipp - FM&O 75503 FM&O Development FM&O - Total $4,265.11 Health -111N1 Grant - Total $122.00 36540 GIS Implementation Support - Aviation $292.50 65301 Airport User Support - $2,516.50 0.5. tritril Airport - Total $2,509.00 $1,750.25 1,297.00 390.00 11,514.00 4,214.00 6,426.50 36530 GIS Implementation Support - Parks 44066 PRADM-System1Customer Support 44068 PRADM-System Enhancements 76100 P&R Administrative Services 95413 PRADM-Customer Support 95419 PRADM-Administration Parks & Recreation - Total $25,591.75 791 RADIO COMMUNICATIONS - E911 79101 Radio Communications - E911 $0.00 Radio Communications - E911 - Total $0.00 Plepared by: Information Technotogy: 4117/2012 $1,214.85 6 790.75 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - SECOND QUARTER 2012 656 WATER RESOURCES ACCOUNTING 734 WRC - AMR SUPPORT 670 WRC ACCTG - CROWDER PRJCT 745 WRC - COSDA METER REPLACEMENT 737 WRC - DATA APPLICATION PILOT PRJ 738 WRC - SCADA ENGINEERING ASSESSMT 23011 Oracle Supp - Water &Sewer Acct'g - 5.2% 95669 Water Resources Accounting Water Resources Accounting - Total 73401 WRC - AMR Support $0.00 VVRC - AMR Support - Total 67000 WRC - Crowder NetBase Project 5610.00 WRC Acctg - Crowder Prject - Total 74500 WRC - CODSA Meter Replacement $3,850.50 WRC - CODSA Meter Replacement - Total 73700 VVRC - Data Application Pilot Project $183.00 WRC - Data Application Pilot Prj - Total 73800 WRC - SCADA Engineering Assesrnnt 12,104.50 WRC - SCADA Engineering Assesmt - Total $8,005.60 $0.00 $610.00 $3,850.50 $183.00 $2,104.50 Prepored by: Information Technology: 4117/2012 Resolution #12110 May 2, 2012 Moved by Long supported by Woodward the resolutions (with fiscal notes attached) on the Consent Agenda be adopted (with acoompanying reports being accepted). AYES: Dwyer, Gershenson, Gingell, Gosselin, Hatchett, Hoffman, Jackson, Long, Matis, McGillivray, Middleton, Nash, Nuccio, Potts, Quarles, River, Runestad, Scott, Taub, Weipert, Woodward, Zack, Bosnic, Covey. (24) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent Agenda be adopted (with accompanying report accepted). I HEREBY APPROVE THE FOREGOING RESOLUTION ACTING PURSUANT TO 1973 PA 139 STATE OF MICHIGAN) COUNTY OF OAKLAND) I, Bill Bullard Jr., 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 2, 2012, 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 2nd day of May, 2012. Bill Bullard Jr., Oakland County