Loading...
HomeMy WebLinkAboutResolutions - 2010.09.01 - 10315September 1, 2010 MISCELLANEOUS RESOLUTION #10208 BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — THIRD QUARTER 2010 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 w .th a summary report to the Finance Committee; and WHEREAS the Department of Information Technology nas determined the Third Quarter 2010 development charges to be $1,298,681.07 and the imaging development charge to be S16,864.25 for the General Fund/General Purpose County departments - and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $523.832.84, non-governmental imaging development are $13,491.40, and non-county agencies are $931.50 for the Third Quarter 2010: 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 2010 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 2010 budgets are totse.-amended -as specified in the attached detail schedule „prazrzmkrra Finance Comm:..ttee Vote: Mot:.on carried unanimously on a rolL call vote ACCOUNT # CUST # FUND # INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 3RD QUARTER 2010 DIVISION 1st Qtr Qgt - Dec 2nd Qtr Jan Mar 3rd Qtr Apr - June Y.T, Q GOVERNMENTAL FUNDS Ge er..l Fun 101 540 0- '0 00-302020 - -"21020-773630 550 '0' 0 0C-302030' -' 21020-773630 560 ' 0 ' ' 0 00-302040 ' - 21020-773630 530 0" 0 00-302050'-' 21020-773630 630 ' 0 " 0 00-107080'-' 14000-773630 725 '0' " 0 00-201020' -' 80000-773630 440 '0' 0 00-201030'- 85010-773630 410 ' 0' ' 0 00-201050' -' 25000-773630 724 0 00-2010210-' 2500(1-773630 720 'O ' 0 00-2010401 0 72190-773630 723 ' 0" 0 00-2010205-' 32300-773630 522 '0' ' 0 00-1070401-' 13000-773630 430 '0' 0 00-1010$01-' 81020-773630 495 '0' ' 0 00-3010201-21110-773630 483 0" ' 0 00-30104030 21100-773630 498 • 0" 0 00-3010301-'21130-773630 502 • 0' 0 00-3010301 0 21180-773630 493 0" 0 00-3010101-' 21100-773630 785 • 0 0 00-1090101- 71000-773630 740 0 0 00-1020501- 73010-773630 660 ' 0 • 0 00-1020601- 82020-773630 900 '0' 0 00-1010115- 15090-773630 680 ' 0- 0 00-1050401 0 83010-773630 907 ' 0 • 0 00-5010303-' 65040-773630 872 0' 0 00-1070601 0 32030-773630 710 0 0 00-10705010 74000-773630 206 ' 0' 0 00-40309010 10040-773630 163 ' 0 0 00-4030901- 15140-773630 775 • 0- '0 00-1090201- 71000-773630 510 0- • 0 00-30404030 24010-773630 145 '0 0 00-4010101 0 22050-773630 690 • 0" 0 00-1020401- 82090-773630 637 0 • 0 00-1030803- 84020-773630 650 0 '0 00-1020701 26020-773630 195 0 '(3 00-4030301- 12590-773630 191 0 0 00-4030601-' 10000-773630 445 • 0 0 00-1030803-'84025-773630 600 0 0 00-7010101- 86040-773630 910 • 0' 0 00-1O70301-320S0-773630 52/1 - District Court 52/2 - District Court 5213 - District Court 52/4 - District Court Anima' Control Clerk - Admin Clerk - Elections Clerk - Jury Commission Clerk - Legal Records Clerk - Register of Deeds Clerk - Vital Statistics Community Correctmns Admin Corporation Counsel Courts-Business Division Courts-FD-Judicial Support-Admin Courts-W-Judidat Support Courts-GJ-Jury Operations Courts - Judical1 Administration Economic Development & Community Affairs Equalization Division Fiscal Services - Admin Homeland Security Human Resources Library Admin Medical Examiner MSU Extension - Oakland OCSD LE Support Serv Admin OCSO CLEMIS Forensx Lab IMS Planning & Economic Development Probate-Estates/Mental Health Support Prosecuting Attorney - General Prosecution Purchasing Records Retention Reimbursement Division Sheriff Sheriff - CLEMIS Support Services Treasurer Veterans Services $11,337.92 $12,550.42 $12,022.79 $35,911.13 $11,337.92 $12,550.42 $12,022.75 535,911.13 $11,337.92 $12,550.42 $12,022.79 $35,911.13 $11,337.74 $12,550.24 $12,022.63 $35,910.61 $37,971.09 $42,463.81 $44,502.73 $124937.63 $23,758.00 $2,402.00 $5,696.00 $31,856.00 $378.00 $230.00 $2,738.00 $3,346.00 $2,087.06 $0.00 $6100 $2,148.06 $29,639.84 $29,706.50 $27,297.00 $86,643.34 $26,219.54 $22,273.51 $5,656.33 $54,149.38 $0.00 $3,381.31 $25,078.23 $28,459.54 $31,098.40 $19,542.15 $21,340.92 $71,981.47 $399,00 $881.00 $54.00 $1,334.00 $1,226.57 $424.42 $462.25 52,113.27 $1,438.34 $1,011.31 $1,182.23 $3,631.88 $71,958.00 $86,378 00 $87,671.00 $246,007.00 $0.00 $848.84 $924.69 $1,773.53 $6,770.27 $5,286.05 54,104.85 $16,161.17 $4,304.50 $5,806.50 $40,404.00 $50,515.00 $179,187.36 $176,959.93 $143,859.78 $500,007.07 $144,800.39 $92,015,32 $85,691.20 $322,506.91 $5,186.00 $427.00 $8,877.25 $14,490.25 $47.328.91 $43,126.76 $43,087.46 $133,543.13 $579.50 $610.00 $0.00 81,189.50 $6,205.34 $4,959.31 $6,207.23 $17,372.38 $0.00 $0.00 $540.00 $540.00 $0.00 $0.00 $610.00 $610.00 $2,028.00 $1,014.00 ($3,042.001 $0.00 $108.00 $0.00 $568.00 $676.00 $9,785.24 $27,355.31 $18,359.23 $55,509.78 $6,664.34 $20,800.31 $25,110.23 $52,574.88 $0.00 $6,021.00 $1957200 $25,593.00 $1,220.00 $4,752.00 $22,522.50 $28,494.50 $10,577.00 $6,004.00 $24,446.00 541,027.00 $122,725.07 $103,215.92 $100,911.78 $326.852.77 $3,671.56 $1,166.84 52,511.69 $7,350.09 $16,624.03 $11,677,22 $17,851.34 $46,152.59 $162,837,11 $144608.99 $161,295.56 $468,741.66 $162.00 $0.00 $0.00 $162.00 Prepared by Pnformation Technology, 8/1812010 Page i ot 14 Book I ACCOUNT # GUST # FUND # $1,466.50 $1,466.50 $5,822.00 $5,822.00 51 , 430.00 $1,430.00 56,71 q.50 $8,715.50 $1,276,894.04 $1.218,816.40 51,298,681.07 53.794.390.51 $13,430.87 510.734,15 $10,118.55 $34,283.57 $7,562.54 $7,156.10 $6,745,70 $21.4034.34 $20,993.41 $17,890.25 $16,864.25 $55,747.91 $1,297,887.45 $1,236,705.65 51,315445.32 53,850,138.42 ($1 297._587,45j. $1.236,705 651 41,315,545.321 •$.2t,F350,138.421 _ $0.00 $0.00 Woo $em, INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 3RD QUARTER 2010 DIVISION lst Otr Oct - Dec 2nd Qtr Jan - Mar 3rd Qtr Psia_m_j_une Y.T.D. $55,876.34 $59,1392.31 $54,932.23 $1707D0.88 $1,058,176,80 $975,443.12 $1.049,175.74 $3,082,795.66 730 101 10100-6010101-155010-773630 Health Fund 12211 840 221 20221-1060201-133150-773630 843 221 20221-1060220-134390-773630 Juvenile Maintenance Fund 12931 665 293 20293-1060501-112090-773830 63600-1080101-152000-631365 GOVERNMENTAL IMAGING 722 101 10100-2010210-125000-773639 512 101 10100-3040403-124010-773639 63600-1090101-152000-630903 10190-9090101-196030-773630 Water Resource Commissioner Sub-Total Fund 101 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 / IMAGING DEVELOPMENT APPROPRIATION: Information Technology Development TOTAL GOVERNMENTAL: 848,241.20 $47,579.20 $48,369.60 5144,190.00 $169,009.54 8189,971.08 $199705.73 $558,686.35 - $217,250.74 $237,550.25 $248,075.33 $702,876.35 669 652 055 056 719 659 661 507 210 750 758 757 NON-GOVERNMENTAL DIRECT CHARGES CAMSJCVT Data Conversion CAMS/FM0 (IT Implementation) CI EMIS CLEIvIIS FUND 83500 Clerk/ROD Automaton Fund Collaborative Asset Mgt Sys (CAMS) Commun & Home Improvement Courts-FCC Exp-CS Enforcement Fire Records Management System F M & 0 FM-J ail fv1gmt Replacement FM-Wk ReliJail MgtA/ideo Cont $13,693.50 $12,574.50 $11,482.50 $37,750,50 $0.00 $6,695.50 $30,107.50 $36,803.00 $17,949.01 $16,814.20 $16,680.20 $51,443 41 $122.00 $244.00 $0.00 $366.00 $71,778.70 $47,607.013 $0.00 5119,385.70 $84,213.25 $141,045.00 $145,537.05 $370,795.30 $0.00 $0.00 $30.50 $30.50 $10,109.25 $8,152.00 $6,964,00 $25,225.25 $1,438.34 $1,011.31 $1,426.23 $3,876.88 $20,349.84 $42,701.31 $26,747.48 589,798.63 $1,220.00 $62.50 $0.00 $1,282.50 $99,908.06 $50,505.84 $62,544.69 5212,958.59 Prepared by Information Technology, 8/16/2010 Page 2 of 14 nook I ACCOUNT # CUST # FUND # 841 751 653 770 768 772 773 763 782 733 765 784 766 663 656 736 734 728 729 63600-1 08010 1-1 52000-631 302 NON-GOVERNMENTAL IMAGING $470,300.76 ;489.319.75 $523 332.84 $1.453.453.35 Courts-F.00 Exp-CS Enforcement Image $15,125.08 $14,312.20 $13,491.40 $42,928.68 471 $274.50 ;2.681 00 $931.50 $3.887.00 $1,783,587.79 $1,743,018.60 $1,853,801.06 $5,380,407.45 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 3RD QUARTER 2010 DIVISION 1st Qtr Oct- Dec 2nd Qtr Jan - Mar 3rd Qtr Apr - June Y T.D. Health - III NI Gran/ IT - 'Telephone Comm O.C. International Airport Parks and Recreation - Administration P&R Addison Oaks P&R Groveland Oaks P&R Highland Oaks P&R Lyon Oaks Golf Course P&R Rose Oaks P&R Springfield Oaks Activity Center/Park P&R Springfield Oaks Golf Course P&R VVaterford Oaks Activity Center/Park P&R White Lake Oaks Golf Course Security Camera Project (Radio Fund) Water & Sewer Accounting WinCan Central Storage Solution 1NRC - AMR Support WRC - C-0 SDS SewMet WRC - E-F DSD SewMet SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $35,853.25 $14,991.25 52,197.00 572,637.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.00 $0.00 $0.00 $1,566.50 $13,019.56 $0.00 $1,225.00 $3,452.48 $4.576.52 $3,751.00 $1,260.00 $4,422.50 $124,023.75 $0.00 $0.00 $0.00 $86.00 $0.00 $0.00 $0.00 $0.00 $0.00 $494.00 $16,038.34 $9,354.50 $1,735.50 $318.63 $422.37 $47,146.50 $1,525.00 $10,605.00 $112,031.75 $76.00 $5,156.00 $591.00 $2,107.00 $75.00 $2,394.00 $451.00 $4,444.50 52,214.00 $0.00 $22,443.94 $3,453.50 $1,371.50 $2,678.04 $3,549.96 $86,750.75 $17,776.25 $17,224.50 $308,692.75 $75.00 $5,156.00 $591.00 $2,193.00 $75.00 $2,394.00 $451.00 $4,444.50 $2,214.00 $2,060.50 $51,501.84 $12,808.00 $4,332.00 $8,449.15 $8.548.85 63600-1080101-15200-630903 TOTAL NON-GOVERNMENTAL IMAGING DEVELOPMENT APPROPRIATION TOTAL COUNTY DEVELOPMENT CHARGES $15.125.04 $14.314.20 513,491.40 $42,928.68 $1.783,313.29 $1,740437.60 11,852,569,56 0476,520.45 NON-COUNTY AGENCIES 63600-1080101-152000-635017 Non-County Agencies TOTAL DEVELOPMENT CHARGES Prepared by; Information Technology; 8/16/2010 Page 3 of 14 Booki .tts,t* GOVERNMENTAL FUNDS 530 ANIMAL CONTRI4 665 CIIILDRENS VILLAGE 725 CLERK - ADMIN 440 CLERK - ELECTIONS 720 CLERK I REGISTER OF DEEDS 722 CLERK - IMAGING 410 CLERK JURY Commissiori $1,182.23 15 533.00 2_,L787.5C 41 .41Q.,0 55,696.00 52.7.38.00 $707.60 1,182.23 1.525,00 213.50 366.00 1,662.00 $0.00 0.00 0.00 10,116.55 $0.00 61.00 527,297.00 $1,182.23 23, 89t3A0 $44,502.73 $1,430.00 $5,696.00 $2,738.00 55,656.33 $10,118.55 $61.00 527,297.00 $25,078 23 Bookl Prepared IN' inionnation Technoevy. 6/16,2010 Paige nf 14 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - THIRD QUARTER 2010 723 CLERK - VITAL STATISTIC 724 c_LERK - LEGAL RECORDS 24017 SQL Server Supp - Animal Control 95628 Web License Registration 95682 Dog System Animal Controt:total 95665 Childrens Village Childrens Village - Total 72500 Clerk - Admin Clerk - Admin - Total 95443 Elections Clerk - Elections - rotal 20004 PDMS Support.- Register of Deeds 24003 SQL Server Supp - ROD 3.5% 36510 GIS Implementation Support-ROD 36511 ROD Application - HAN Support 95493 Reg Deeds System Maintenance 95498 Clerk/Reg - ROD Clerk/Reg of Deeds - Tctat 13001 Clerk - eFfling - 50% 23007 Oracle Support - Clerk Image 5.2% 65420 Clerk - Image Replace 95156 Clerk - Imaging Clerk - imaging • Total 23008 Oracle Support - Jury Comm - 5.2% 95512 Jury Commission Clerk - Jury Commission - Total Circuit Court System Clerk - Legal Records - Total 24015 SQL Server Sup - Vital Slats 3.5% 95161 Clerk.Reg - Vital Statistics Clerk - Vital Statistics - Total 95189 - INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - THIRD QUARTER 2010 522 comMUNgy coFkREellohs•ADMIN MO) 23003 Oracle Support-Comm Corr - b.2% 8924.59 24012 SQL Server Supp - Community Corr 15% 1.182.2.3 52200 Comm Corr-Admin (County) 19,234.00 52201 Comm Corr-OW Supp 0.0Q Community Corrections - Total $21,340.92 430 coRpORATION COUNSEL 95501 Corporation Counsel $54.90 Corporation Counsel - Total $54.00 495 cis-BusINEss DIVISION 12002 Circuit Ct-Courts/Criminel Warehouse 50% $0.00 14001 CTS-DW Support/Circuit Ct - 75% 0.00 15001 CTS-DW Maint/Circuq et - 75% 0.00 23010 Oracle Support-CCT/C TS Grim Whso 2.6% 462.28 CTS-Susiness Division - Total $482.28 463 CTS-IFD-JUDIcIAL SUPPORT-ADM 24009 SQL Seri/ Supp - CTS-Jud Sup Adm - 3.5% 81,182.23 95193 CTS-FO-Judicol Support-Adm 0.00 CTS-FO-Judicial Support-Adm - Total $1,182.23 498 us-GEN JURIS-JuDICIALaUppT 95179 CTS-Gen Juris-Judicial .Suppt 587 .671.00 CTS-Gen Juris-Judiclal Suppt - Total $87,071.110 493 CTS-JUDICIALLADMIN 13002 CTS-eriling - 50% $0.00 95174 CTS-Judicial Admin 4 104.85 CTS-Judicial Admin - Total $4.104.85 502 CTS-DJ-JURY oPERATIONs 23008 Oracle Support-CTS-GJ-Jury Operations $924.69 CTS-GJ-Jury Operations - Total $924.69 735 EgoN owe DEvELppmENT & COMMUNITY AfFAIn 36500 GI.S Implementation Support C&E Dev 8548.00 36501 CEO Application - HNV Support 1,147.00 95785 Comm & Eco Develop-sit 38.703.a Economic Development & Community Affairs - Total $40,404.00 Prepared by Infeareation fet-J-innlogy 8116,20 I 0 Page 2 of 14 BoOkl Ce, $1,415.20 924.69 3,546.38 7,855.90 1,352.50 14,733.50 0 00 3,283.50 14,344.50 33,839.26 2,739.50 2,851.75 9.00 4,498.00 702 00 0.00 51,774,00 S143,859.78 $707.60 0.00 54.00 21,570.50 26.028. 50 548,369.60 23001 Oracle Support - Fiscal Serv - 15.6% $2,773.94 23013 Oracle Support - HR-Accig /Budget - 5.2% 924.69 24006 SQL Serv Supp - HR-Acctg - 1.75% 59t17 44021 FS-System/Customer Support 19,044.00 44022 FS-System Maintenance 0.00 44023 FS-System Enhancements 0.00 44024 FS-New Development 0.00 44076 BUD-System/Customer Support 0.00 44077 BUD-System Maintenance 0.00 44079 FS - OW Support 0.00 44081 FS - DW Maintenance 0.00 96001 Human Res - Acct 40% 41 571.60 96003 Human Res - Budget 20% 20,785,60 Fiscal Services Admin - I otal 660 FISCAL SERVICES AMIN $85.691.20 INFORMATION TECHNOLOGY- RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - THIRD QUARTER 2010 740 EUUAL1ZAT1ON 840 HEALTI-1,0IVI5LQN 20001 IDMS Support-Equalization - 40% 23012 Oracle Support-Equalization - 5.2% 24005 SQL Server Stipp-Equalization - 10.5% 31075 Equal Development 36505 GIS Implementation Support Equalization 36506 Equal Application - HNV Support 36507 Equal tAms Supporl/Mtce 36601 Land System Enhancements - Equal (50%) 36701 Land System Maintenance - Equal (50%) 36801 Land System Support - Equal (50%) 38902 BS&A Orion Nun - Fqual (50%) 36912 BS&A Madison HeIghts - Equal (50%) 95559 Uses Sup port/Fqual 95562 Equalization - OW Support 95570 Equalization - OW Maintenance 95893 Equal-System Maintenance 95899 BS&A Master Appraisal Sup/Maint Equalization - Total 20002 IDMS Support - CHAMPS - 20% 36525 GIS Implementation Support Health 37025 CHAMPS - P.O.P. 95563 User Support4lealth 96842 Health Admin Health - total Prepared by: Informatzon Techno1ogy:81M20W F'age 3 of 14 Ronk I 843 HEALTH - ENVIRONMENTAL, 900 HOMELAND SEM/FIFTY 680 HUMAN KESOURCES 907 PERARY - LIBRARY ADIIIIN 872 MEDICAL EXAMINER 775 PLANNIIG & ECONOMIC DEVELOPMENT 710 MSLI EXtENSION - OAKLAND 206 OCSV - LE Slit:TORT SERV AMR 163 OCSO - CLEMLE_FORENSIII.AB IMS $924.59 4,728.29 0.00 171,210.25 22 842.50 $1,716,50 6,563.00 597.75 0.00 $924.69 591.17 0.00 0.00 0.00 0.00 41,571,60 $0.00 $1,182.23 5Q25.00 $568.00 0.00 0.00 $540.00 $610.00 13,042.00 $199,705.73 55,877.25 $43,087.46 $0.00 $6,207.23 $568.00 $540.00 1610.00 $3i)47 Ct.ij Book1 Prepared tor ta,urrnalain Toefinraogy; *3/15,2010 Page 4 of 14 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT ! SUPPORT DETAIL - THIRD QUARTER 2010 231305 Oracle Support - EH Proiects - 5.2% 24014 SQL Server Suppl - Ehealth 14% 37002 Environmental 84200 El t - Prolects 84300 Fhealth Program Health-Environmental - Total 36545 GIS Implementation Support Homeland Security 36546 Homeland 'Security Application - ILNI Support 95479 Homeland Serially Customer Support 98990 Homeland Security Homeland Security - Total 23014 Oracle Support-tiRIPersonnel 5.2% 24007 SQL. Server Suppport-KR/Personnel - 1.75% 44041 PER-SysterniCustomer Supped 44042 HR-Systems Maintenance 44044 HR-New Development 95555 KR User Supt 96002 Human Res-Personnel 40% Human Resources -Total 91405 Library Puard Library - Library Admin - Total 24002 SQL Server Support - Medical Exam - 3.5% 87202 Medical Examiner - Customer Support Medical Examiner - Total 95600 PEDS-Customer(System Support 95786 PEDS - DW Support 95787 PEDS - tWV Mairtenante PEDS - Total 95676 MSU Ext Equipment Maintenance NISU Extension - Oakland - rota, 20600 RESULTS Application Reporting OCSD - LE Support Serv Admin - Total 16300 OCSO CL EMIS Forensic Lab 1MS OCSO CLEIVIIS Forensic Lab IMS - Total 00 $924.69 1,587.00 $2,511.69 23015 Oracle Suppport - Sheriff / CI EM1S - 5.2% 96163 Sheriff - CLEMIS Sheriff- CLEMIS - Total 191 SHERIFF - CLEMI Prepared ty. Informal Ion Technology: 5,r16)2010 Page 5 of 14 ecok'4 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - THIRD QUARTER 2010 512 PROB-ESTATES/MENTL HLTHIMAG 95207 Prob-Est/Mntl Filth Image $6,74520 Prob,Est/Mnil 1-11th image - Total 610 PROB-E$TATES/W1ENTL HUH SUPPORT 24010 SOL Serv Supp-PCT-Fst/Menlal - 3.6% $1.182.23 92198 Prob-EstilVIritt Hith Support 17 177.00 Prob-Est/Mntl Huth Support - Total 145 PROSECUTOR - GENERAL PROUCUTION 24016 SQL Server Supp - Rroesoutors 3.5% $1,182 95622 Prosecutor/Executive 14,650.00 97001 Prosecutor Data Proc Prosecutor - Total 690 PURCHASING 55663 Purchasing $19,572.00 Purchasing - Total 637 RECORDS RETENTION 44052 Rec-System Maintenance $0.00 44053 Rec-System Enhancements 22,622.50 44054 Rae-New Devektament 0.00 95636 Mai, Room Q.00 Records Retention - Total 650 lightagBILKILT 96489 Reimbursement Division $0.00 95470 Reimbursement System 24,446.00 95542 Reimburse User Support 0.00 Reimbursement - Total 195 SHQRIFF 12001 OC SD-Courts/C rimi nal Warehouse 23009 Oracle Suppport - OCSDICTS aim VVhse - 2.6% 462.28 97163 Sheriff 89,520.50 97165 Snerff-DW Support 10,929,00 97166 Sheriff-DVV Maintenance 0.00 Sheriff - Total 86.745.70 $18.359.23 $25,110.23 $19,572.00 $22,522 50 $24,446.00 6100,911.76 445 SUPPORT SERVICES 600 TREASURER 730 WATER RESOURCE COMMISSIONER 540 5211 DISTRICT COURT - NOVI 550 5212 Ofa_TRICT COURT - CLARKSIDN Prepated by' information Tectmulugy, 8/1612010 Page 6t 14 Fbrisi INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT SUPPORT DETAIL - THIRD QUARTER 2010 23002 Oracle Support - Supp Serv - 5.2% 924.69 24011 SQL Server SLipp - Suppt Services 7% 2,164.15 44500 Support Services 14,562.50, Support Services - Total 23006 Oracle Support • Del lax - 5.2% $924.59 23016 Oracle Support - Treasurer - 10.4% 1,849.38 36515 GIS Implementation Suppc rl-Treasuter 0.00 36516 Treasurer Application - KW Support 8,113.00 36602 Land System Enhancements - Treas (50%) 3,283,50 36702 Land System Maintenance - Treas (50%) 14,344.50 36802 Land System Support Treas (50%) 33,839.24 44061 Tre-System/Customer Support 16,245.75 44062 Tre-System Maintenance 9.076,00 44083 Tre-System Enhancements 2,903.50 44064 Tre-New Development 4.026.00 44080 Tre-DVV Support 5,427.00 44082 Tre -DW Ma intenance 351.00 95008 Del Tax On Line 366.00 95301 Del Tex System Maintenance 2 .105 .50 96561 User Support/Del Tax 24,767,00 95615 BS&A Annual Tax Support 33.673:50 Treasurer - Total 24008 SQL Server Supp - WRC 1.5% $1,182.23 28007 Water Resource Commissioner 0.00 28010 VVRC - Customer Support 13279.50 28011 Water Resource Commissioner Application 10,072.25 36520 GIS Implementation Support WRC 16,737.75 36521 VVRC Application - HNV Support 13 660.50 Water Resource Commissioner - Total 14002 CTS-DW Support-5211 - 6.25% $0.00 15002 CTS-DVV IVIaint 52/1 - 6.25% 0.00 95527 DC Surd- 5211 - 25% 12022,,79 52/1 District Court - Total 14003 C-I-S-DVV Support-5212 - 6.25% 50.00 15003 CTS-DW :via int 5212 - 6.25% 0.00 95528 DC Suprt- 52.12 - 25% 12.Q22.79 5212 District Court - Total $17,851,34 $161,295.56 $54,932.23 312,022.79 512,022.79 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - THIRD QUARTER 2010 550 5 2r3 DISTRICT COURT - ROCHESTE9 530 52/4 DISTRICT COURT - TROY 14004 CTS-DW Support-52/3 - 6.25% 15004 CTS-DW Main1 52/3 - 6.25% 95529 DC Suprt - 52/3 - 25% 5213 District Court - Total 14005 CT S-OW Support 52/4 - 6.25c/1 15006 CTS-D1A/ Maint 52/4 - 6.25% 95530 DC', Suprt- 52/4- 25% 52/4 District Court - Total $0.00 0.00 12.022.79 $0.00 0.00 1Z022.63 $12,022.79 512,022,55 Prepared py. Information Techrology, 8i1et2010 Pap 7 al 14 Budd 055 cLEM1S 055 CLEM'S FUND 63500 719 Mali Attacli ngttalligil 669 CAMSiCVT DATA CONVERSION 662 CAMS/FMO fir IMPLEMENTATION) 659 COLLABORATIVE ASSET MOT_SYS 661 COMMUN & HOME IMPROVEMENT 471 CTS-FOC-EXP-CS ENFORC4MAGE 507 CTS-FOC EXP-C3 ENFORCEMENT $707,60 924,43 8.274,67 0,00 0,00 3,294.00 0,00 1,20150 0.00 0.00 2.276,00 'WOO. $0.00 $11.482 50 $30.107 60 5145_537.05 $30 50 $13,491.40 $6.064 OQ 516680.20 $0.00 $0.00 $11,482.50 $30,107.50 $145.537.05 $30.50 $13,491.40 $6,064.00 Book Propmed by Informabon Tochnology; Ef1Sr2010 Page 8 of 14 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER 2010 Cu st at DIRECT FUNDS tOMS Support - 5.6% Oracle Support Sheriff CLEMIS 5.2% SOL Server Support - 24.5% CAD Customer Support ET/CLEM1S 1.RM ET/CLEIvIIS LRMS S LRMS UASI (NR) S Maintenance S Enhancements S Adhoc Reports S User Support S - Total 63500 CLEMIS Fund CLEMIS 63500 Fund - total 95719 Register of Deeds Automation Clerk/ROD Automation Fund - Total 66901 CAMS/CVT Data Conversion CAIV1S/DVT Data Conversion - Total 65200 CAMS/FM0 (IT Implementation) CAMS/FIVIO (IT Implementation) - Total 65901 Coliabortive Asset Mgt Sys Collabortive Asset Mgt Sys - Total 66103 Comm Dev User Support Commun & Home Improvement Total 92194 CTS-FOC-Exp-CS Enf-lmage CTS-FOC Exp-05 Ent-Image - Total 92193 CTS-FOC Exo-CD Enforc-Dev CTS-1 DC Exp-CD Entocc-Dev - Total 20003 23018 24004 90507 95409 96410 95411 95430 95431 95432 96003 CRISI\ CRISI\ CLEM CLEM CLEM CLEM CLEM CLEM INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT f SUPPORT DETAIL - THIRD QUARTER 2010 210 FIRE RECORDS MANAGEMEtft SYSTEM 750 FM&O 758 FM-.JAIL MGMT REPLACEMEWF 757 FM-INK RELEASEIJAII, MGMTNIDEO CQ_NF 841 HEALTH - Iii NI GRANT 751 LI - TELEPHONE COMM 653 Q.C.INTIERNATI9NAL AIRPQRT 770 PARKS AND RECREATION 21010 Fire Records Mgmt Fund 531 24001 SQL Server Support- FRS 3.5% Fire Records Management System - Total FM&O SQL Server •Supp - FM80 FM&O Development FM&O - Total 75800 Mgmt Replacement FM-Jail Mgmt Replacement - Total 23004 Oracle Support - Oak Video - 5.2% 75703 Fac Mgmt - Video Arraignments FM-Wit Rel/Jail MgrarVideo Con f - Total 84100 Health - H INI Grant Health - 111N 1 Grant - Total 75102 Tel Comm - Customer Support - Telephone Comm - Total 36540 GIS Implementation Suppott-Avlation 65301 Airport User Support 65310 O.C. Airport - New Development 0,0. International Airport - Total 36530 GIS implementation Support - Parks 44056 PRADIVI-Systern/Custorner Support 44068 PRADM -System Enhancements 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 I - Point of Sale Systern 77200 Yr 2 •- Program Management 77220 Yt 2 - Asset Mgmt Implementation 77230 Yr 2 - Customer Into Mgmt Implementation 95419 PF7ADM-Administrallon Parks & Retiree lion - Total $244.00 1,182.23 $9.737.25 1,182.23 15 528.0 $0.00 $924 69 1 ,5ZQd.Q $47.146.5Q $1 50Q $0-DO 732.00 9.573.00 $7,323.00 2,365.50 0.00 0.00 122.00 12,742.00 8,306,00 208.00 21,329.00 14,592.50 33,103.76 0,00 11 ,s40.00 21001 24013 75503 $1,426.23 $26,747.48 50.00 $62,544.69 547,145.50 $1,626.00 $10,605.00 $112,031.75 Itpared by Information Technology. f1 2010 13ave1 Page 9 al 14 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT SUPPORT DETAIL - THIRD QUARTER 2010 768 P&R ADOISON OAKS 76800 P&R Addison Oaks $75.00 P&R Addison Oaks - Total 772 E&R GROVELAND OAKS 77772 P&R Groveland Oaks $5,156.00 P&R Groveland Oaks - Total 773 P&R HIGHLAND Will* 1/3110 P&R Highland Oaks 591.00 PR Highland Oaks - Total 763 P&R LYON OAKS GOLF CIZIURSk 73800 P&R Lyon Oaks G.C. $2,107.00 P&R Lyon Oaks Golf Course - Total 782 P&R ROSE OAKS 78782 P&R Rose Oaks $75,00 P&R Rose Oaks - Total 783 IF&R SPRINGFIELD OAKS ACTVTY CTR1PK 78300 P&R Springfield Oaks Activity Center/Pafk $2,394,00 P&R Springfield Oaks Activity Center/Park - Total 765 f&R SPRINGFIELD OAKS QOLF COURSE 76500 P&R Springlield Oaks G.C. 5401.00 P&R Springfield Oaks Golf Course Total 784 P&R WATERFORD OAKS AC TVTY CIPJFK 78400 P&R Waterford Oaks Activity Center/Park $4,444.50 P&R Waterford Oaks Activity Center. Park - Total 766 P&R WHITE LAKE OAKS GOLF GOURSt 76600 P&R White Lake Oaks G.C. 12.214.00 P&R White Lake Oaks Golf Course - Total 663 SECURITY CAMERA PROJECT IRADIO FUND) 66300 Security Camera Project (Radio ' urd) SILO, Security Camera Project (Radio Fund) - Total 656 WATER& SEWER ACCT c 23011 Oracle Supp - Water & Sewer Acct'g - 5.2% $924.69 95669 Water & Sewer Aocfg 21.5194.1 Water & Sewer Acct g - Total 736 WINCAN CENTRAL STORAGE SOLUTION 73601 V‘linCan Central Storage Solution $3,453.50 VViriCan Central Storage Solution - total 734 INEIg - AMR SUPPQRT 73401 VVRC - AMR Support 51,371 .50 WHO - AMR Support - Total $5,156.00 $591.00 $2,107,00 $75.00 $2,394.00 $451.00 $4,444.50 $2,214.00 ¶0.00 $22,443.94 13,453.50 $1,371.50 Prepared by. Inkrrinalion Tedvoiagv: 8116,2010 Page 10 of 14 EloOkl 17: INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - THIRD QUARTER MC 728 WRC - C-0 SOS SEWMET 7220 MARS Enhancements - 43% S2,676.04 WRC - C-0 SDS SewMet - Total $2,678.04 725 WRC E-F SOS SEWMST 72202 MARS Enhancemeots - 57% $3.545.96 WRC - E-F DSD SewMet - Total $34996 Page i of 14 Book* Prepared by- Inlarrrualion Technology; 11/ dap io I HEREBY APifiOVEGOINS RESOLUTION Kvi Resolution #10208 September 1, 2010 Moved by Nash supported by Gosselin the resolutions (with fiscal notes attached) on the Consent Agenda be adopted. AYES: Burns, Coulter, Douglas, Gershenson, Gingell, Gosselin, Greimel, 1-latchett, Jackson, Jacobsen, Long, McGillivray, Middleton. Nash, Potts. Runestad, Schwartz, Scott, Taub. Woodward, Zack, Bullard. (22) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent Agenda were adopted. STATE OF MICHIGAN) COUNTY OF OAKLAND) I, Ruth Johnson, 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 September 1, 2010, 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 1st day of September, 2010. G.4 Ruth Johnson, County Clerk