Loading...
HomeMy WebLinkAboutResolutions - 2011.08.18 - 18675MISCELLANEOUS RESOLUTION #11176 August 18, 2011 BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — THIRD QUARTER 2011 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 Third Quarter 2011 development charges to be $752,385.93 , and the imaging development charge to be $10,740.00 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $391,047.21, non-governmental imaging development are $8,592.00, and non-county agencies are $23,289.00 for the Third Quarter 2011; 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 Third Quarter 2011 Development Report and approves the Third Quarter appropriation transfer as specified on the attached schedule. BE IT FURTHER RESOLVED that the respective departmental Fiscal Year 2011 budgets are amended as specified in the attached detail schedule. FINANCE COMMITTEE Motion carried unanimously on a roll call vote with Crawford absent. INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 3RD QUARTER 2011 1 st Qtr 2011 2nd Qtr 2011 3rd Qtr 2011 4th Qtr 2011 CUST # DIVISION Oct - Dec Jan - Mar Apr - June July - Sept Y.T.D. 540 52/1 - District Court $8,802.20 $9,060.99 $5,893.88 $23,757.07 550 52/2 - District Court $8,802.20 $9,060.99 $5,893.88 $23,757.07 560 52/3 - District Court $8,802,20 $9,060.99 $5,893,88 $23,757.07 530 52/4 - District Court $8,802.20 $9,060.93 $5,893.86 $23,756.99 630 Animal Control $8,180.33 $13,409.86 $37,334.88 $58,925,07 005 Bd of Commissioners $488.00 $427.00 $183.00 $1,098.00 725 Clerk - Admin $5,154.00 $0.00 $0.00 $5,154.00 440 Clerk - Elections $3,611.50 $9,962.00 $3,958.00 $17,531.50 410 Clerk - Jury Commission $0.00 $122.00 $671.00 $793.00 724 Clerk - Legal Records $18,995.00 $13,944.00 $12,471.00 $45,410.00 720 Clerk - Register of Deeds $2,855.13 $2,664.86 $2,459.08 $7,979.07 723 Clerk - Vital Statistics $5,805.33 $4,020.36 $4,925.88 $14,751.57 522 Community Corrections Admin $16,420.61 $19,632.62 $10,040.73 $46,093.96 430 Corporation Counsel $1,891.00 $915.00 $61.00 $2,867.00 " 495 Courts-Business Division $270.63 $408.12 $589.68 $1,268.43 483 Courts-FD-Judicial Support-Admin $667,33 $438.36 $359.88 $1,465.57 498 Courts-GJ-Judicial Support $44,141.50 $50,040.00 $42,929.90 $137,111.40 502 Courts-GJ-Jury Operations $541.28 $572.26 $569.35 $1,682.89 493 Courts - Judical / Administration $2,441.75 $2,580,05 $2,148.00 $7,169.80 785 Economic Development & Community Affairs $3,479,00 $4,753.00 $4,010.00 $12,242.00 004 Election Redistricting $0.00 $0.00 $18,615.75 $18,615.75 740 Equalization Division $78,453.57 $88,956.69 $73,715.86 $241,126.12 660 Fiscal Services - Admin $44,811.32 $50,462.63 $71,756.66 $167,030.61 900 Homeland Security $305.00 $5,076.50 $1,819.00 $7,200.50 680 Human Resources $21,769.02 $28,375.06 $39,255.46 $89,399.54 872 Medical Examiner $9,143.33 $5,380.36 $2,155.88 $16,679.57 710 MSU Extension - Oakland $0.00 $0.00 $122.00 $122.00 206 OCSD - LE Support Serv Admin $0.00 $0.00 $678.00 $678.00 163 OCSO - CLEMIS Forensic Lab IMS $0.00 $457.50 $0.00 $457.50 775 Planning & Economic Development $4,830.00 $5,192.00 $2,336.50 $12,358.50 481 Probate-FD Judicial $196.00 $0.00 $0.00 $196.00 510 Probate-Estates/Mental Health Support $1,643.33 $2,329.36 $6,910.88 $10,883.57 Prepared by; Information Technology; 7/2812011 Page 1 of 13 3rd Qtr 2011 .xis 1st Qtr 2011 Oct - Dec CUST # DIVISION 665 Children's Village Sub-Total Fund 293 $4,622.00 $10,201.00 $4,622.00 $10,201.00 $8.725.50 $8,725.50 $23,548.50 $23,548.50 $0.00 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 3RD QUARTER 2011 145 Prosecuting Attorney - General Prosecution 690 Purchasing 637 Records Retention 650 Reimbursement Division 195 Sheriff 191 Sheriff - CLEMIS 445 Support Services 600 Treasurer 730 Water Resource Commissioner Sub-Total Fund 101 $21,529.33 $7,332.00 $1,620.00 $6,148.80 $65,004.13 $2,872.28 $3,713.26 $116,511.94 $34,322.33 $570,356.83 2nd Qtr 2011 Jan - Mar $46,602.66 $7,474.00 $0.00 $549.00 $84,075.12 $2,671.26 $2,232.81 $79,192,96 $41 j96.86 $610,358.16 3rd Qtr 2011 Apr - June $39,406.88 $0.00 $0.00 $4,591.00 $78,700.93 $1,789.35 $14,403.86 $80,201.87 $48,592.63 $631,339.39 4th Qtr 2011 July - Sept (30.00 Y.T.D. $107,538.87 $14,806.00 $1,620.00 $11,288.80 $227,780.18 $7,332.89 $20,349,93 $275,906.77 $124,111.82 $1,812,054.38 $0.00 840 Health 843 Health Environmental Sub-Total Fund 221 $80,063.30 $174.923.74 $254,987.04 $48,780.50 $97,123.34 $145,903.84 $27,425.20 $84,895.84 $112,321.04 $156,269 00 $356,942.92 $513,211,92 DEVELOPMENT FOR GOVERNMENTAL FUND APPROPRIATION $829,965.87 $766,463.00 $752,385.93 0.00 $2,348,814.80 722 Clerk Image 512 Probate-Estates/Mental Health Image $7,935.25 $4,883.50 $11,905.15 $5,160.10 $6,444.00 $4,296.00 $26,284.40 $14 339 60 i10,740.00 $763,125.93 93) $0.00 TOTAL GOVERNMENTAL IMAGING DEVELOPMENT APPROPRIATION SUB-TOTAL GOVERNMENTAL / IMAGING DEVELOPMENT APPROPRIATION: Information Technology Development TOTAL GOVERNMENTAL: Prepared by; Information Technology; 7128/2011 $12,818.75 $17,065.25 $842,784.62 $783,528.25 • 7P. 4 _CS -7F? )1 $0A)13 Page 2 of 13 $0.00 $40,624.00 $0.00 $2,389,438.80 $0.00. $0.00 3rd Qtr 2011 xis $0.00 $0.00 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 3RD QUARTER 2011 CUST # DIVISION 1st Qtr 2011 Oct - Dec 2nd Qtr 2011 Jan Mar 3rd Qtr 2011 Apr - June 4th Qtr 2011 July - Sept Y.T.D. 669 CAMS/CVT Data Conversion 652 CAMS/FM0 (IT Implementation) 055 CLEMIS 056 CLEMIS FUND 63500 659 Collaborative Asset Mgt Sys (CAMS) 661 Commun & Home Improvement 507 Courts-FOC Exp-CS Enforcement 210 Fire Records Management System 750 F M & 0 841 Health - H1N1 Grant 653 0.0. IntnlAirport 770 Parks and Recreation - Administration 761 P&R Administrative Services 768 P&R Addison Oaks 787 P&R Catalpa Oaks 762 P&R Glen Oaks Golf Course 773 P&R Highland Oaks 779 P&R Independence Oaks 767 P&R Independence Oaks Nature Center 781 P&R Orion Oaks 764 P&R Red Oaks Golf Course 789 P&R Red Oaks VVaterpark 782 P&R Rose Oaks 783 P&R Springfield Oaks Activity Center/Park 765 P&R Springfield Oaks Golf Course 695 Risk Management 656 Water Resources Accounting 736 VVinCan Central Storage Solution 734 WRC - AMR Support SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $1,518.00 $41,941,50 $72,412.97 $0.00 $112,644.50 $679.00 $5,741.50 $667.33 $16,542.83 $12,092.00 $0.00 $74,379.75 $8,155.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0,00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,149.28 $4,048.00 15_39.50 $355,511.91, $930.00 $17,859.25 $59,973.00 $42,890.00 $96,964.53 $75,510.60 $0,00 $0.00 $109,472.25 $115,971.00 $97,50 $0.00 $5,581.50 $16,188.00 $682.36 $359.88 $935.86 $5,697.38 ($12,092.00 $7,631.50 $0.00 $994.50 $105,758.50 $90,560.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0,00 $0,00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $915.00 $0.00 $5,010.76 $8,953.35 $962.00 $8,138.75 5221.00 5292.50 $375,412.26 $391,047.21 $20,307.25 $144,804.50 $244,888.10 $0.00 $338,087.75 $776.50 $27,511.00 $1,709.57 $23,176.07 $7,63150 $994.50 $270,698.75 $8,155.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0,00 $915.00 $18,113.39 $13,148.75 $1,053.00 $0.00 $1,121,971.38 Prepared by; Information Technology; 7/28/2011 Page 3 of 13 3rd Qtr 2011.xls INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 3RD QUARTER 2011 1st Qtr 2011 2nd Qtr 2011 3rd Qtr 2011 4th Qtr 2011 CUST # DIVISION Oct - Dec Jan - Mar Apr - June July - Sept Y.T.D. 471 Courts-FOC Exp-CS Enforcement Image TOTAL NON-GOVERNMENTAL IMAGING DEVELOPMENT APPROPRIATION $9,767.00 $10,320.20 $8,592.00 $28,679,20 $9,767.00 $10,320.20 $8,592.00 1)0.00 $28,679.20 TOTAL COUNTY DEVELOPMENT CHARGES $1,208,063.53 $1,169„260.71 $1,162,765.14 10.00 $3,540,089.38 Non-County Agencies $21,918,50 $14,092.50 $23,289.00 $59,300,00 TOTAL DEVELOPMENT CHARGES $1,229,982.03 $1,183,353.21 $1,186,054.14 $0.00 $3,599,389.38 Prepared by: Information Technology - 7/28/2011 Page 4 of 13 3rd Ohl- 2011 .xls cust# GOVERNMENTAL FUNDS 630 ANIMAL CONTROL 005 BD OF COMMISSIONERS 665 CHILDRENS VILLAGE 725 CLERK - ADMIN 440 CLERK - ELECTIONS 720 CLERK / REGISTER OF DEEDS 722 CLERK-IMAGING 410 CLERK-JURY COMMISSION 724 CLERK - LEGAL RECORDS 723 CLERK - VITAL STATISTICS $12.20 359.88 549.00 916.00 0.00 622.00 $0.00 6,444 00 $671.00 $12.471,00 $359.88 4,566.00 $2,459,08 S6,444 00 $671.00 $12.471,00 $4,925.88 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2011 24017 SQL Server Supp - Animal Control $359.88 95628 Web License Registration 27,396.00 95682 Dog System 9,579.00 Animal Control-Total 91404 BOC - Customer Support $183.00 BOC - Customer Support - Total 95665 Childrens Village $8.725.50 Childrens Village - Total 72500 Clerk - Admin $0.00 Clerk - Admin - Total 95443 Elections $3,958,00 Clerk - Elections - Total 20004 IDMS Support - Register of Deeds 20% 24003 SQL Server Supp - ROD 3.5% 36510 GIS Implementation Support-ROD 36511 ROD Application - H/W Support 95493 Rey Deeds System Maintenance 95498 Clerk/Rey - ROD Clerk/Rey of Deeds - Total 13001 Clerk - eFiling - 50% 95158 Clerk - Imaging Clerk - Imaging - Total 95512 Clerk/Rey - Jury Commission Clerk/Reg - Jury Commission - Total 95189 Circuit Court System Clerk - Legal Records - Total 24015 SQL Server Supp Vital Stals 3,5% 95161 Clerk.Reg - Vital Statistics Clerk - Vital Statistics - Total $37,334.88 $183.00 68,725.50 $0.00 $3,958.00 Pie:Fated by: b,fb•rnabon I hno!ogy 7728/2011 Page 5 of 13 d O 21111 oP INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2011 522 COMMUNITY CORRECTIONS-ADMIN (CO) 23003 Orade Support-Comm Corr - 5.2% $569.35 24012 SQL Server Supp - Community Corr 3.5% 359.88 52200 Comm Corr-Admin (County) 9,111.50 52201 Comm Corr-OW Supp 0.00 Community Corrections - Total $10,040.73 430 CORPORATION COUNSEL 05501 Corporation Counsel $61.00 Corporation Counsel - Total $61.00 495 CTS-BUSINESS DIVISION 12002 Circuit Ct-Courts/Criminal Warehouse 50% $305.00 14001 CTS-DW Support/Circuit Cl - 75% 0.00 15001 CTS-DVV Maint/Circuit Ct - 75% 0.00 23010 Oracle Support-CCT/CTS Grim Whse 2.6% 284.68 CTS-Business Division - Total $589.68 483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5% $359.88 95193 CTS-FD-Judicial Support-Adm 0.00 CTS-FD-Judicial Support-Adm - Total $359.88 498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS-Gen Juris-Judicial Suppt $42,929.90 CTS-Gen Juris-Judicial Suppl - Total $42,929.90 493 CTS-JUDICIAL ADMIN 502 CTS-GJ-JURY OPERATIONS 13002 CTS-eFiling - 50% $0.00 95174 CTS-Judicial Admin 2,148.00 CTS-Judicial Admin - Total $2,148.00 23008 Oracle Support-CTS-GJ-Jury Operations $569.35 CTS-GJ-Jury Operations - Total $569.35 785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GIS Implementation Support C&E Dev $136.50 36501 CEO Application - HAAT Support 2,897.50 95785 Comm & Eco Developmt 976.00 Economic Development & Community Affairs - Total $4,010.00 004 ELECTION REDISTRICTING 40000 Election Redistricting $18,615.75 Election Redistricting - Total $18,615.75 Prepared by. Information Technology, 7128/2011 Page 6 or 13 3rd Ulr 2011 740 EQUALIZATION 660 FISCAL SERVICES ADMIN 840 HEALTH DIVISION $24.40 569.35 1,079.36 0.00 942.00 19,559.75 0.00 8,087.50 2,628.50 5,402.00 0.00 0.00 0.00 7,330.00 196.00 305.00 27,042.00 573,715.86 $1.708.10 569.35 179.91 10,216.00 0.00 1,324.00 0.00 0 00 0.00 0.00 0.00 38,506 20 19,253.10 $71,756.66 $12.20 0,00 0.00 11,252.50 16,150.50 $27,425.20 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2011 20001 IDMS Support-Equalization - 40% 23012 Oracle Support-Equalization - 5.2% 24005 SQL Server Supp-Equalization - 10.5% 31075 Equal - Development 36505 GIS Implementation Support Equalization 36506 Equal Application - HNV Support 36507 Equal LAMS Support/Mtce 36601 Land System Enhancements - Equal (50%) 36701 Land System Maintenance - Equal (50%) 36801 Land System Support - Equal (50%) 36902 BS&A Orion Twp - Equal (50`Y) 36912 BS&A Madison Heights - Equal (50%) 95559 User Support/Equal 95562 Equalization - DVV Support 95570 Equalization - DVV Maintenance 95693 Equal-System Maintenance 95699 BS&A Master Appraisal Sup/Maint Equalization - Total 23001 Orade Support - Fiscal Serv - 15.6% 23013 Oracle Support - HR-Acctg/Budget - 5.2% 24006 SQL Serv Supp - HR-Acctg - 1 75% 44021 FS-System/Customer Support 44022 FS-System Maintenance 44023 FS-System Enhancements 44024 FS-New Development 44076 BUD-System/Customer Support 44077 BUD-System Maintenance 44079 FS - DVV Support 44081 FS - DVV Maintenance 96001 Human Res - Acct 40% 96003 Human Res - Budget 20% Fiscal Services Admin - Total 20002 IDMS Support - CHAMPS - 20% 36525 GIS Implementation Support Health 37025 CHAMPS - P.O.P. 95563 User Support-Health 96842 Health Admin Health - Total Prepared by: Informatjon Tecenology; 712812011 Page 7 of 13 3rd DIr 2011 xls INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER 2011 843 HEALTH - ENVIRONMENTAL 23005 Oracle Support - EH Projects - 5,2% $569,35 24014 SQL Server Suppt - Ehealth 14% 1,438.99 37002 Environmental 000 84200 EH - Projects 75,893.50 84300 Ehealth Program 6,994.00 Health-Environmental - Total $84,895.84 900 HOMELAND SECURITY 36545 GIS Implementation Support Homeland Security $896.00 36546 Homeland Security Application - H/W Support 923.00 95479 Homeland Security Customer Support 0.00 98990 Homeland Security 0.00 Homeland Security - Total $1,819.00 680 HUMAN RESOURCES 23014 Oracle Support-HR/Personnel - 5.2% $569.35 24007 SQL Server Suppport-HR/Personnel - 1.75% 179,91 44041 PER-System/Customer Support 0.00 44042 HR-Systems Maintenance 0.00 44044 HR-New Development 0.00 95556 HR User Supt 0.00 96002 Human Res-Personnel 40% 38,506.20 Human Resources - Total 5:39,255.46 872 MEDICAL EXAMINER 24002 SQL Server Support - Medical Exam - 3.5% $359.88 87202 Medical Examiner - Customer Support 1 796.00 Medical Examiner - Total $2,155.88 710 MSU EXTENSION - OAKLAND 95676 MSU Ext Equipment Maintenance $122.00 MSU Extension - Oakland - Total $122,00 206 OCSD - LE SUPPORT SERV ADMIN 20600 RESULTS Application Reporting $678,00 OCSD - LE Support Serv Admin - Total S678.00 163 OCSO-CLEMIS FORENSIC LAB IMS 16300 0050 CLEMIS Forensic Lab $0.00 OCSO CLEMIS Forensic Lab IMS - Total $0.00 775 PLANNING & ECONOMIC DEVELOPMENT 95600 REDS-Customer/System Support $2.336.50 95786 REDS - DW Support 0.00 95787 PEDS - DVV Maintenance 0,00 PEDS - Total $2,336,50 481 PROB-FD JUDICIAL 95168 PC - Judicial Admin - Family $0.00 PC - Judicial Admin - Family - Total $0,00 Prepared by: Information Tecnnology: 712812011 Page Sot 13 3rd Qtr 231 I xls 512 PROB-ESTATES/MENTL HLTH IMAGE 510 PROB-ESTATES/MENTL HLTH SUPPORT 145 PROSECUTOR - GENERAL PROSECUTION 690 PURCHASING 637 RECORDS RETENTION Sheriff - Total 578,700.93 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2011 95207 Prob-Est/Mritl Hlth Imace $4 296.00 Prob-Est/Mnt11-11lh Image - Total 24010 SQL Serv Supp-PCT-Est/Mental - 3.5% $359.88 92198 Prob-Est/Mntl Hlth Support 6.551.00 Prob-EstiMntl Hlth Support - Total 24016 SQL Server Supp - Proescutors 3.5% $359.88 95622 Prosecutor/Executive 7,991.00 97001 Prosecutor Data Frac 31,056.00 Prosecutor - Total 95663 Purchasing $0.00 44028 Purchasing System Enhancements 0.00 Purchasing - Total 44052 Rec-System Maintenance $0.00 44053 Rec-System Enhancements 0.00 44054 Rec-New Development 0.00 95636 Mail Room 0.00 Records Retention - Total $4,296.00 $6,910.88 $39,406.88 $0.00 $0.00 • 650 REIMBURSEMENT 95469 Reimbursement Division $0.00 C) 95470 Reimbursement System 4.530.00 195 SHERIFF 95542 Reimburse User Support 61.00 Reimbursement - Total 12001 OCSD-Courls/Criminal Warehouse $305.00 23009 Oracle Suppport OCSD/CTS Crim VVhse - 2.6% 284.68 97163 Sheriff 69,065.75 97165 Sheriff-OW Support 9.045.50 97166 Sheriff-DVV Maintenance 0.00 $4,591.00 191 SHERIFF - CLEMIS 23015 Oracle Suppport - Sheriff / CLEMIS - 5.2% $569.35 96153 Sheriff - CLEMIS 1,220.00 Sheriff - CLEMIS - Total $1,789.35 445 SUPPORT SERVICES 23002 Oracle Support - Supp Serv - 5.2% $569.35 24011 SQL Server Supp - Suppt Services 7% 719.51 44500 Support Services 13.115.00 Support Services - Total $14403.86 Page 9 of 33 3rd Olr 2011 x1, Prepared by: tniormation Technology: 7128/2011 540 52/1 DISTRICT COURT,- NOVI 550 52/2 DISTRICT COURT - CLARKSTON $569.35 1,138.77 0.00 6,649.00 8,087.50 2,628.50 5,402.00 8,519.00 2.489.00 0.00 4,079.00 15,591.00 0.00 488.00 1,661.75 7,476.50 15.422.50 $80,201.87 $0.00 0.00 5,893.88 $5.893.88 $0.00 0.00 5,893.88 $5,893.88 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2011 600 TREASURER 23006 Oracle Support - Del Tax - 5.2% 23016 Oracle Support - Treasurer - 10,4% 36515 GIS Implementation Support-Treasurer 36516 Treasurer Application - HNV Support 36602 Land System Enhancements - Treas (50%) 36702 Land System Maintenance - Treas (50%) 36802 Land System Support - Trees (50%) 44061 Tie-System/Customer Support 44062 Tre-System Maintenance 44063 Tre-System Enhancements 44064 Ire-New Development 44080 Tre-DVV Support 44082 Tre-OW Maintenance 95008 Del Tax On Line 95303 Del Tax System Maintenance 95561 User Support/Del Tax 95615 BS&A Annual Tax Support Treasurer - Total 14002 CTS-DW Support-52/1 - 6,25% 15002 CTS-DVV Maint 52/1 - 6.25% 95527 DC Suprt- 52/1 - 25% 52/1 District Court - Total 14003 CTS-DVV Support-52/2 - 6.25% 15003 CTS-DVV Maint 52/2 - 6.25% 95528 DC Suprt- 52/2 - 25% 52/2 District Court - Total $48,592.63 730 WATER RESOURCE COMMISSIONER 24008 SQL Server Supp - WRC 3.5% $359.88 28007 Water Resource Commissioner 0,00 28010 VVRC - Customer Support 12,849.50 28011 Water Resource Commissioner Application 8,873.00 —a 36520 GIS Implementation Support VVRC 11.604,25 36521 WRC Application - H/VV Support 14 906,00 Water Resource Commissioner - Total Fwared by: Information Technology; 7728/2011 Page 10 of 11 3rd Oh r 2011 Is INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER 2011 560 52/3 DISTRICT COURT - ROCHESTER 530 5214 DISTRICT COURT - TROY 14004 CTS-DVV Support-52/3 - 6.25% 15004 CTS-DVV Maint 52/3 - 6.25% 95529 DC Suprt - 52/3 - 25% 52/3 District Court - Total 14005 CTS-DVV Support-52/4 - 6.25% 15005 CTS-DVV Maint 52/4 - 6.25% 95530 DC Soprt- 52/4 - 25% 5214 District Court - Total $0.00 0.00 5,893.88 $0.00 0.00 5.893.86 $5,893.88 $5.893.86 Prepared by: Information Technology', 7728/2 Page 11 of 13 3rd Cl, 2011 xls INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2011 Cust # DIRECT FUNDS 055 CLEMIS 056 CLEMIS FUND 63500 669 CAMS/CVT DATA CONVERSION 652 CAMS/FM0 (IT IMPLEMENTATION1 659 COLLABORATIVE ASSET MGT SYS 661 COMMUN & HOME IMPROVEMENT 471 CTS-FOC-EXP-CS ENFORC-IMAGE 507 CTS-FOC EXP-CS ENFORCEMENT 210 FIRE RECORDS MANAGEMENT SYSTEM 20003 IDMS Support - 20% 23004 Oracle Suppoil - C.)akVideo CLEMIS 5.2% 23018 Oracle Support - Sheriff CLEMIS 5.2% 24004 SQL Server Support - 24.5% 90507 CAD Customer Support 90510 CLEMIS OakVideo Support 95409 CRISNET/CLEMIS LRM 95410 CRISNET/C,LEMIS LRIVIS 95411 CLEMIS LRMS LJASI (NR) 95430 CLEMIS Maintenance 95431 CLEMIS Enhancements 95432 CLEMIS Adhoc Reports 98003 CLEMIS User Support CLEMIS - Total 63500 CLEMIS Fund CLEMIS 63500 Fund - Total 66901 CAMS/CVT Data Conversion CAMS/CVT Data Conversion 65200 CAMS/FM0 (IT Implementation) CAMS/FMO (IT Implementation) - Total 65901 Collabortive Asset Mgt Sys Collabortive Asset Mgt Sys - Total 66103 Comm Dev User Support Cornmun & Home Improvement - Total 92194 CTS-FOC-Exp-CS Enf-Image CTS-FOC Exp-CS Ent-Image - Total 92193 CTS-FOC Exp-CD Enforc-Dev CTS-FOC Exp-CD Enforc-Dev - Total 21010 Fire Records Mgmt Fund 531 24001 SQL Server Support - FRMS 3,5% Fire Records Management System - Total $12.20 569.35 569.70 2.518.35 0.00 22,032.00 0.00 51,728.00 i:9.543.0m 0.00 1,830.00 0.00 6.194.00 $0.00 $17.859.25 $42,890.00 1115,971.00 $0.00 $8,592.00 116,185.00 $0.00 359.88 Total $75 510 60 $0.00 817,859.25 $42,890.00 $115,971.00 $0.00 $8,592.00 $16,188.00 $359.88 Prepared by Information Technology; 712812011 Page 12 of 13 3rd Qtr 2011.xls 750 FM&O 841 HEALTH -1-11N1 GRANT 653 D.C. INTNL AIRPORT 770 PARKS AND RECREATION 761 P&R ADMINISTRATIVE SERVICES 695 RISK MANAGEMENT 656 WATER RESOURCES ACCOUNTING 736 WINCAN CENTRAL STORAGE SOLUTION 734 VVRC - AMR SUPPORT $0.00 359.88 5,337.50 $7 631 50 $4,587.50 3,624.00 0.00 27 398.50 0.00 0.00 0.00 364.00 52.00 0.00 0.00 40,870.50 0.00 1,771.00 11,893.00 $0.00 $569.35 8,384.00 $8,138.75 $5,697.38 $7.631.50 $994.50 $90,560.50 $0.00 $0.00 $8.953.35 $8,138.75 $292.50 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2011 21001 FM&O 24013 SQL Server Supp - FM&O 75503 FM&O Development FM&O - Total 84100 Health - H1N1 Grant Health - H1N1 Grant - Total 36540 GIS Implementation Support - Aviation $994.50 0.C. IntnlAir port - Total 36530 GIS Implementation Support - Parks 44066 PRADM-SystemiCustomer Support 44068 PRADM-System Enhancements 76100 P&R Administrative Services 77010 PRADM-Technology Assessment 77100 Yr 1 - Program Management 77110 Yr 1 - Asset Theme Development 77120 Yr 1 - Network Connectivity 77130 Yr 1 - Hardware Refresh 77140 Yr 1 - Point of Sale System 77200 Yr 2 - Program Management 77220 Yr 2 - Asset Mgmt Implementation 77230 Yr 2 - Customer Info Mgmt Implementation 95413 PRADM-Customer Support 95419 PRADM-Administration Parks & Recreation - Total 76100 P&R Administrative Services P&R Administrative Services - Total 44036 Rsk-Systern Customer Support $0,00 Risk Management - Total 23011 Oracle Stipp - Water & Sewer Acct'g - 5.2% 95669 Water Resources Accounting Water Resources Accounting - Total 73601 WinCan Central Storage Solution WinCan Central Storage Solution - Total 73401 VVRC - AMR Support $292.50 WRC - AMR Support - Total Page 13 of 13 3rd OU 2011.xis Prepared by Information 'Technology: 7/28/2011 1/1 Resolution #11176 August 18, 2011 Moved by Crawford supported by McGillivray the resolutions (with fiscal notes attached) on the Consent Agenda be adopted (with accompanying reports being accepted). AYES: Covey, Crawford, Dwyer, Gershenson, Gingell, Gosselin, Greimel, Hatchett, Hoffman, Jackson, Long, Matis, McGillivray, Middleton, Nash, Nuccio, Potts, Quarles, Runestad, Scott, Taub, Weipert, Woodward, Zack, Bosnic. (25) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent Agenda were adopted (with accompanying reports being accepted). I HEREBY APPROVE THE,FOREGOINGAOLUTION STATE OF MICHIGAN) COUNTY OF OAKLAND) 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 August 18, 2011, 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 18th day of August, 2011. FLU_ e 091 Bill Bullard Jr., Oakland County