Loading...
HomeMy WebLinkAboutResolutions - 2011.11.30 - 18796MISCELLANEOUS RESOLUTION #11282 November 30, 2011 BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — FOURTH 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 Fourth Quarter 2011 development charges to be $1,218,267.19 and the imaging development charge to be $13,171.00 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $462,514,71, non-governmental imaging development are $10,536.00, and non-county agencies are $28,865.75 for the Fourth 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 Fourth Quarter 2011 Development Report and approves the Fourth Quarter appropriation transfer as specified on the attached schedule. BE IT FURTHER RESOLVED that the respective departmental Fiscal Year 2011 budgets are to be amended as specified in the attached detail schedule. FINANCE COMMITTEE FINANCE COMMITTEE Motion carried unanimously on a roll call vote with Long and Runestad absent, INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY ** 4TH QUARTER 2011 - NOTE - THIS QUARTER INCLUDES FOUR MONTHS ** lst 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 550 52/2 - District Court 560 52/3 - District Court 530 52/4 - District Court 630 Animal Control 005 Bd of Commissioners 725 Clerk - Admin 440 Clerk - Elections 410 Clerk - Jury Commission 724 Clerk - Legal Records 720 Clerk - Register of Deeds 723 Clerk - Vital Statistics 522 Community Corrections Admin 430 Corporation Counsel 015 County Executive 495 Courts-Business Division 483 Courts-FD-Judicial Support-Admin 498 Courts-GJ-Judicial Support 502 Courts-GJ-Jury Operations 493 Courts - Judical / Administration 785 Economic Development & Community Affairs 004 Election Redistricting 740 Equalization Division 660 Fiscal Services - Admin 900 Homeland Security 680 Human Resources 907 Library - Library Admin 872 Medical Examiner 710 MSU Extension - Oakland 206 OCSD - LE Support Serv Admin 163 OCSO - CLEMIS Forensic Lab IMS 775 Planning & Economic Development $8,802.20 $9,060.99 $5,893.88 $4,112.13 $27,869.20 $8,802.20 $9,060.99 $5,893.88 $4,112.13 $27,869.20 $8,802.20 $9,060.99 $5,893.88 $4,112.13 $27,869.20 $8,802.20 $9,060.93 $5,893.86 $4,112.11 $27,869.10 $8,180.33 $13,409.86 $37,334.88 $24,856.86 $83,781.93 $488.00 $427.00 $183.00 $3,402.50 $4,500.50 $5,154.00 $0.00 $0.00 $10,638.00 $15,792.00 $3,611.50 $9,962.00 $3,958.00 $1,387.00 $18,918.50 $0.00 $122.00 $671.00 $0.00 $793.00 $18,995.00 $13,944.00 $12,471.00 $9,456.50 $54,866.50 $2,855.13 $2,664.86 $2,459.08 $2,743.61 $10,722.68 $5,805.33 $4,020.36 $4,925.88 $9,520.11 $24,271.68 $16,420.61 $19,632.62 $10,040.73 $23,067.17 $69,161.13 $1,891.00 $915.00 $61.00 $61.00 $2,928.00 $0.00 $0.00 $0.00 $648.00 $648.00 $270.63 $408.12 $589,68 $605.04 $1,873.47 $667.33 $438.36 $359.88 $996.11 $2,461.68 $44,141.50 $50,040.00 $42,929.90 $48,424.00 $185,535.40 $541.28 $572.26 $569.35 $1,210.06 $2,892.95 $2,441.75 $2,580.05 $2,148.00 $2,634.20 $9,804.00 $3,479.00 $4,753.00 $4,010.00 $58,113.00 $70,355.00 $0.00 $0.00 $18,615.75 $2,238.00 $20,853.75 $78,453,57 $88,956.69 $73,715.86 $167,804.16 $408,930.28 $44,811.32 $50,462.63 $71,756.66 $94,572.61 $261,603.22 $305.00 $5,076.50 $1,819.00 $3,145.50 $10,346.00 $21,769.02 $28,375.06 $39,255.46 $47,907.59 $137,307.13 $0.00 $0.00 $0.00 $2,379.00 $2,379.00 $9,143.33 $5,380.36 $2,155.88 $5,409.11 $22,088.68 $0.00 $0.00 $122.00 $427.00 $549.00 $0.00 $0.00 $678.00 $9,519.60 $10,197.60 $0.00 $457.50 $0.00 $0.00 $457.50 $4,830.00 $5,192.00 $2,336.50 $6,502.50 $18,861.00 Page 1 of 14 Prepared by; Information Technology; 10/28/2011 BOC Development Billing Report 4th Quarter 2011.xlsx INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY ** 4TH QUARTER 2011 - NOTE - THIS QUARTER INCLUDES FOUR MONTHS ** CUST # DIVISION 481 Probate-FD Judicial 510 Probate-Estates/Mental Health Support 145 Prosecuting Attorney - General Prosecution 690 Purchasing 637 Records Retention 650 Reimbursement Division 195 Sheriff 191 Sheriff - CLEMIS 445 Support Services 600 Treasurer 910 Veterans Services 730 Water Resource Commissioner Sub-Total Fund 101 840 Health 843 Health Environmental Sub-Total Fund 221 665 Children's Village Sub-Total Fund 293 DEVELOPMENT FOR GOVERNMENTAL FUND APPROPRIATION 722 Clerk Image 512 Probate-Estates/Mental Health Image TOTAL GOVERNMENTAL IMAGING DEVELOPMENT APPROPRIATION SUB-TOTAL GOVERNMENTAL / IMAGING DEVELOPMENT APPROPRIATION: 1st Qtr 2011 Oct-Dec $196.00 $1.643.33 $21,529.33 $7,332.00 $1,620.00 $6,148.80 $65.004.13 $2,872.28 $3,713.26 $116.511.94 $0.00 $34.322.33 $570,356.83 $80,063.30 $174,923.74 $254,987.04 $4,622.00 $4,622.00 $829,965.87 $7,935.25 $4,883.50 $12,818.75 $842,784.62 2nd Qtr 2011 Jan - Mar $0.00 $2,329.36 $46,602.66 $7,474.00 $0.00 $549.00 $84,075.12 $2,671.26 $2,232.81 $79,192.96 $0.00 $41,196.86 $610,358.16 $48,780.50 $97,123.34 $145,903.84 $10,201.00 $10,201.00 $766,463.00 $11,905.15 $5.160.10 $17,065.25 $783,528.25 3rd Qtr 2011 Apr - June $0.00 $6,910.88 $39,406.88 $0.00 $0.00 $4,591.00 $78,700.93 $1,789.35 $14,403.86 $80,201.87 $0.00 $48,592.63 $631,339.39 $27,425.20 $84,895.84 $112,321.04 $8,725.50 $8,725.50 $752,385.93 $6,444.00 $4,296.00 $10,740.00 $763,125.93 4th Qtr 2011 July - Sept $0.00 $5,648.11 $65,888.11 $0.00 $0.00 $24,076.00 $120,737.79 $16,338.06 $6,953.53 $175,728.28 $305.00 $41,110.86 $1,010,902.47 $49,610.25 $147,541.47 $197,151.72 $10,213.00 $10,213.00 $1,218,267.19 $7,902.60 $5,268.40 $13,171.00 Y.T.D. $196.00 $16,531.68 $173,426.98 $14,806.00 $1,620.00 $35,364.80 $348,517.97 $23,670.95 $27,303.46 $451,635.05 $305.00 $165,222.68 $2,822,956.85 $205,879.25 $504,484.39 $710,363.64 $33,761.50 $33,761.50 $3,567,081.99 $34,187.00 $19,608.00 $53,795.00 $1,231,438.19 $3,620,876.99 Page 2 of 14 Prepared by; Information Technology; 10/28/2011 BOC Development Billing Report 4th Quarter 2011.xlsx DIVISION Information Technology Development TOTAL GOVERNMENTAL: CUST # $930.00 $59,973.00 $96,964.53 $0.00 $109,472.25 $97.50 $5,581.50 $682.36 $0.00 $935.86 ($12,092.00) $0.00 $105,758.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 $915.00 $5,010.76 $962.00 $17,859.25 $42,890.00 $75,510.60 $0.00 $115,971.00 $0.00 $16,188.00 $359.88 $0.00 $5,697.38 $7,631.50 $994.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 $8,953.35 $8,138.75 $10,024.50 $30,331.75 $50,953.75 $195,758.25 $22,833.43 $267,721.53 $13,922.00 $13,922.00 $203,026.60 $541,114.35 $0.00 $776.50 $9,744.50 $37,255.50 $1,057.11 $2,766.68 $14,735.00 $14,735.00 $5,387.61 $28,563.68 $66,827.25 $74,458.75 $183.00 $1,177.50 $49,490.40 $320,189.15 $0.00 $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 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $122.00 $1,037.00 $10,851.81 $28,965.20 $2,161.75 $15,310.50 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY ** 4TH QUARTER 2011 - NOTE - THIS QUARTER INCLUDES FOUR MONTHS ** 1st Qtr 2011 Oct - Dec ($S'12.784 621 $0.00 2nd Qtr 2011 Jan - Mar LS783 523 25j $0.00 3rd Qtr 2011 4th Qtr 2011 Apr-June July-Sept Y.T.D. L*763,125,93), ($1.231.438.1 ,,,li. ($3,620,876.99) $0.00 $0.00 $0.00 $1,518.00 $41,941.50 $72,412,97 $0.00 $112,644.50 $679.00 $5,741.50 $667.33 $0.00 $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 Page 3 of 14 Prepared by; Information Technology; 10/28/2011 BOC Development Billing Report 4th Quarter 2011.xlsx 669 CAMS/CVT Data Conversion 652 CAMS/FMO (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 760 FM - BOG Webcasting 750 FM&O 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 Waterpark 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 WinCan Central Storage Solution $355,511.91 $375,412.26 $391,047.21 $462,514.71 $1,584,486.09 $539.50 $0.00 $0.00 $221.00 $0.00 $0.00 $292.50 $0.00 $0.00 $370.50 $579.50 $244.00 $1,423.50 $579.50 $244.00 $10,320.20 $8,592.00 $10,320.20 $8,592.00 $10,536.00 $39,215.20 $10,536.00 $39,215.20 $28,865.75 $88,165.75 $14,092.50 $23,289.00 Non-County Agencies $21,918.50 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY ** 4TH QUARTER 2011 - NOTE - THIS QUARTER INCLUDES FOUR MONTHS ** 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. 734 WRC - AMR Support 737 WRC - Data Application Pilot Poject 738 WRC - SCADA Engineering Assessment SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT 471 Courts-FOC Exp-CS Enforcement Image $9,767.00 TOTAL NON-GOVERNMENTAL IMAGING $9,767.00 DEVELOPMENT APPROPRIATION TOTAL COUNTY DEVELOPMENT CHARGES $1,208,063.53 $1,169,260.71 $1,162,765.14 $1,704,488.90 $5,244,578.28 TOTAL DEVELOPMENT CHARGES $1,229,982.03 $1,183,353.21 $1,186,054.14 $1,733,354.65 $5,332,744.03 Page 4 of 14 Prepared by; Information Technology; 10/28/2011 BOO Development Billing Report 4th Quarter 2011.xlsx oust # GOVERNMENTAL FUNDS 630 ANIMAL CONTROL 24017 SQL Server Supp - Animal Control $996.11 95628 Web License Registration 10,936.75 95682 Dog System 12,924.00 Animal Control-Total 005 BD OF COMMISSIONERS 91404 BOC - Customer Support $3,402.50 BOC - Customer Support - Total 665 CHILDRENS VILLAGE 95665 Childrens Village $10,213.00 Childrens Village - Total 725 CLERK - ADMIN 72500 Clerk - Admin $10,638.00 Clerk - Admin - Total 440 CLERK - ELECTIONS 95443 Elections $1,387.00 Clerk - Elections - Total 720 CLERK! REGISTER OF DEEDS 20004 IDMS Support - Register of Deeds 20% $0.00 24003 SQL Server Supp - ROD 3.5% 996.11 36510 GIS Implementation Support-ROD 61.00 36511 ROD Application - H/VV Support 640.50 95493 Reg Deeds System Maintenance 0.00 95498 Clerk/Reg - ROD 1,046.00 Clerk/Reg of Deeds - Total $24,856.86 $3,402.50 $10,213.00 $10,638.00 $1.387.00 $2,743.61 $0.00 7,902,60 $7,902.60 $0.00 $9,456.50 $9,520.11 $0.00 $9,456.50 $996.11 8.524.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2011 722 CLERK IMAGING 13001 Clerk - eFiling - 50% 95158 Clerk - Imaging Clerk - Imaging - Total 410 CLERK - JURY COMMISSION 95512 Clerk/Reg - Jury Commission Clerk/Reg - Jury Commission - Total 724 CLERK - LEGAL RECORDS 95189 Circuit Court System Clerk - Legal Records - Total 723 CLERK - VITAL STATISTICS 24015 SQL Server Supp - Vital Stats 3.5% 95161 Clerk.Reg - Vital Statistics Clerk - Vital Statistics - Total Page 5 of 14 Prepared by: Information Technology; 10/28/2011 (WC Development Billing Report 4th Quarter 2011 .xIsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2011 522 COMMUNITY CORRECTIONS-ADMIN (CO) 23003 Oracle Support-Comm Corr - 5.2% $1,210.06 24012 SQL Server Supp - Community Corr 3.5% 996.11 52200 Comm Corr-Admin (County) 20,861.00 52201 Comm Corr-DW Supp 0.00 Community Corrections - Total 430 CORPORATION COUNSEL 95501 Corporation Counsel $61.00 Corporation Counsel - Total 015 COUNTY EXECUTIVE 95656 County Executive Support $648.00 County Executive - Total 495 CTS-BUSINESS DIVISION 12002 Circuit Ct-Courts/Criminal Warehouse 50% $0.00 14001 CTS-DW Support/Circuit Ct - 75% 0.00 15001 CTS-DW Maint/Circuit Ct - 75% 0.00 23010 Oracle Support-CCT/CTS Crim Whse 2.6% 605.04 CTS-Business Division - Total 483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5% $996.11 95193 CTS-FD-Judicial Support-Adm 0.00 CTS-FD-Judicial Support-Adm - Total 498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS-Gen Juris-Judicial Suppt $48,424.00 CTS-Gen Juris-Judicial Suppt - Total 493 CTS-JUDICIAL ADMIN 13002 CTS-eFiling - 50% $0.00 95174 CTS-Judicial Admin 2,634.20 CTS-Judicial Admin - Total 502 CTS-GJ-JURY OPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operations $1,210.06 CTS-GJ-Jury Operations - Total 785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GIS Implementation Support C&E Dev $175.50 36501 CED Application - HM/ Support 1,849.50 95785 Comm & Eco Developmt 56,088.00 Economic Development & Community Affairs - Total 004 ELECTION REDISTRICTING 40000 Election Redistricting $2,238.00 Election Redistricting - Total $23,067.17 $61.00 $648.00 $605.04 $996.11 $48,424.00 $2,634.20 $1,210.06 $58,113.00 $2,238.00 Page 6 of 14 Prepared by information Technology 10/28/2011 BOC Development Billing Report 418 Quarter 2011 xlsx 20001 IDMS Support-Equalization - 40% $0.00 23012 Oracle Support-Equalization - 5.2% 1,210.06 24005 SQL Server Supp-Equalization - 10.5% 2,988.05 31075 Equal - Development 0.00 36505 GIS Implementation Support Equalization 915.00 36506 Equal Application - HAN Support 41,969.75 36507 Equal LAMS Support/Mtce 0.00 36601 Land System Enhancements - Equal (50%) 87,965.30 36701 Land System Maintenance - Equal (50%) 1,053.50 36801 Land System Support - Equal (50%) 3,985.50 36902 BS&A Orion .Twp - Equal (50%) 0.00 36912 BS&A Madison Heights - Equal (50%) 0.00 95559 User Support/Equal 0.00 95562 Equalization - DVV Support 4,341.00 95570 Equalization - DW Maintenance 196.00 95693 Equal-System Maintenance 0.00 95699 BS&A Master Appraisal Sup/Maint 23,180.00 Equalization - Total 740 EQUALIZATION $167,804.16 660 FISCAL SERVICES ADMIN 840 HEALTH DIVISION $3,630.32 1,210.06 498.13 16,836.00 0.00 3,099.00 0.00 0.00 0.00 0.00 0.00 46,199.40 23,099.70 $94,572.61 $0.00 539.00 0.00 25,963.00 23,108.25 $49,610.25 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2011 23001 Oracle Support - Fiscal Serv - 15.6% 23013 Oracle Support - HR-Acctg/Budget - 5.2% 24006 SQL Serv Supp - HR-Acctg - 1.75% 44021 ES-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 - DW 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 Page 7 of 14 Prepared by: Information Technology: 10/28/2011 ROC Development Billing Report 4th Quarter 2011.xlsx $147,541.47 $3,145.50 $47,907.59 $2,379.00 $5,409.11 $427.00 $9,519.60 $0.00 $6,502.50 0.00 0.00 $6,502.50 $0.00 000 Development Billing Report 4th Quarter 2011,x1sx $0.00 $0.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2011 843 HEALTH - ENVIRONMENTAL 900 HOMELAND SECURITY 680 HUMAN RESOURCES 907 LIBRARY - LIBRARY ADMIN 872 MEDICAL EXAMINER 710 MSU EXTENSION - OAKLAND 206 OCSD - LE SUPPORT SERV ADMIN 163 OCSO-CLEMIS FORENSIC LAB IMS 775 PLANNING & ECONOMIC DEVELOPMENT 481 PROB-FD JUDICIAL Prepared by Information Technology, 10/28/2011 23005 Oracle Support - EH Projects - 5.2% $1,210.06 24014 SQL Server Suppt - Ehealth 14% 3,983.91 37002 Environmental 0.00 84200 EH - Projects 136,338.75 84300 Ehealth Program 6,008.75 Health-Environmental - Total 36545 GIS Implementation Support Homeland Security $2,513.00 36546 Homeland Security Application - H/VV Support 632.50 95479 Homeland Security Customer Support 0.00 98990 Homeland Security 0.00 Homeland Security - Total 23014 Oracle Support-HR/Personnel - 5.2% $1,210.06 24007 SQL Server Suppport-HR/Personnel - 1.75% 498.13 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% 46,199.40 Human Resources - Total 91405 Library Board $2,379.00 Library - Library Admin - Total 24002 SQL Server Support - Medical Exam - 3.5% $996.11 87202 Medical Examiner - Customer Support 4,413.00 Medical Examiner - Total 95676 MSU Ext Equipment Maintenance $427.00 MSU Extension - Oakland - Total 20600 RESULTS Application Reporting $9,519.60 OCSD - LE Support Serv Admin - Total 16300 OCSO CLEMIS Forensic Lab $0.00 OCSO CLEMIS Forensic Lab IMS - Total 95600 PEDS-Customer/System Support 95786 PEDS - OW Support 95787 PEDS - DA/ Maintenance PEDS - Total 95168 PC - Judicial Admin - Family PC - Judicial Admin - Family - Total Page 8 of 14 $0.00 0.00 $0.00 95663 Purchasing 44028 Purchasing System Enhancements Purchasing - Total 690 PURCHASING 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 95469 Reimbursement Division $0.00 95470 Reimbursement System 22,856.00 95542 Reimburse User Support 1,220.00 Reimbursement - Total 12001 OCSD-Courts/Criminal Warehouse 23009 Oracle Suppport - OCSD/CTS Crim Whse - 2.6% 97163 Sheriff 97165 Sheriff-DW Support 97166 Sheriff-DVV Maintenance Sheriff - Total 23015 Oracle Suppport - Sheriff / CLEMIS - 5.2% 96163 Sheriff - CLEMIS Sheriff - CLEMIS - Total 23002 Oracle Support - Supp Serv - 5.2% 24011 SQL Server Supp - Suppt Services 7% 44500 Support Services Support Services - Total $0.00 $24,076.00 $120.737.79 $16,338.06 $6,953.53 637 RECORDS RETENTION 650 REIMBURSEMENT 195 SHERIFF 191 SHERIFF- CLEMIS 445 SUPPORT SERVICES $0.00 605.04 109,879.25 10,253.50 $1,210.06 15,128.00 $1,210.06 1,991.97 3,751.50 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER 2011 512 PROB-ESTATES/MENTL HLTH IMAGE 95207 Prob-Est/Mntl Huth Image $5268.40 Prob-Est/Mntl Hlth Image - Total 510 PROB-ESTATES/MENTL HLTH SUPPORT 24010 SQL Serv Supp-PCT-Est/Mental - 3.5% $996.11 92198 Prob-Est/Mntl Hlth Support 4 652 00 Prob-Est/Mntl Hlth Support - Total 145 PROSECUTOR - GENERAL PROSECUTION 24016 SQL Server Supp - Proescutors 3.5% $996.11 95622 Prosecutor/Executive 28,031.00 97001 Prosecutor Data Proc 36,861.00 Prosecutor - Total $5,268.40 $5,648.11 $65,888.11 Page 9 of 14 Prepared by: Information Technology: 10/28/2011 BOC Development Billing Report 4th Quarter 2011.xlsx 730 WATER RESOURCE COMMISSIONER 540 52/1 DISTRICT COURT - NOVI 550 52/2 DISTRICT COURT - CLARKSTON INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER 2011 600 TREASURER 910 VETERANS SERVICES 23006 Oracle Support - Del Tax - 5.2% $1,210.06 23016 Oracle Support - Treasurer - 10.4% 2,420.27 36515 GIS Implementation Support-Treasurer 0.00 36516 Treasurer Application - HAN Support 9,546.50 36602 Land System Enhancements - Treas (50%) 87,965.20 36702 Land System Maintenance - Treas (50%) 1,053.50 36802 Land System Support - Treas (50%) 3,985.50 44061 Tre-System/Customer Support 23,204.50 44062 Tre-System Maintenance 1,699.00 44063 Tre-System Enhancements 0.00 44064 Tre-New Development (4,433.00) 44080 Tre-DW Support 13,533.00 44082 Tre-DW Maintenance 1,519.00 95008 Del Tax On Line 0.00 95303 Del Tax System Maintenance 4,500.75 95561 User Support/Del Tax 12,291.50 95615 BS&A Annual Tax Support 17,232.50 Treasurer - Total $175,728.28 95651 Veterans Customer Support $305.00 Veterans Services - Total $305.00 24008 SQL Server Supp - WRC 3.5% $996.11 28007 Water Resource Commissioner 0.00 28010 WRC - Customer Support 4,534.50 28011 Water Resource Commissioner Application 6,114.00 36520 GIS Implementation Support VVRC 16,290.25 36521 WRC Application - H/VV Support 13,176.00 Water Resource Commissioner - Total 14002 CTS-DW Support-52/1 - 6.25% $0.00 15002 CTS-DVV Maint 52/1 - 6.25% 0.00 95527 DC Suprt- 52/1 -25% 4,112.13 52/1 District Court - Total 14003 CTS-DW Support-52/2 - 6.25% $0.00 15003 CTS-DVV Maint 52/2 - 6.25% 0.00 95528 DC Suprt- 52/2 - 25% 4,112.13 52/2 District Court - Total $41,110.86 $4,112.13 $4,112.13 Page 10 of 14 Prepared by: Information Technology; 10/28/2011 BOO Development Billing Report 4th Quarter 2011.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER 2011 560 52/3 DISTRICT COURT - ROCHESTER 530 52/4 DISTRICT COURT - TROY 14004 CTS-DW Support-52/3 - 6.25% 15004 CTS-DW Maint 52/3 - 6.25% 95529 DC Suprt - 52/3 - 25% 52/3 District Court - Total 14005 CTS-DW Support-52/4 - 6.25% 15005 CTS-DW Maint 52/4 - 6.25% 95530 DC Supit- 52/4 - 25% 52/4 District Court - Total $0.00 0.00 4,112.13 $0.00 0.00 4,112.11 $4,112.13 $4,112.11 Page 11 of 14 Prepared by: Information Technology; 10/28/2011 BOO Development Billing Report 4th Quarter 2011.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER 2011 cust # DIRECT FUNDS 055 CLEMIS 20003 IDMS Support - 20% $0.00 23004 Oracle Support OakVideo CLEMIS 5.2% 1,210.06 23018 Oracle Support - Sheriff CLEMIS 5.2% 1,210.91 24004 SQL Server Support - 24.5% 6,971.96 90507 CAD Customer Support 0.00 90510 CLEMIS - OakVideo Support 0.00 95409 CRISNET/CLEMIS LRM 0.00 95410 CRISNET/CLEMIS LRMS 4,758.00 95411 CLEMIS LRMS UASI (NR) 0.00 95430 CLEMIS Maintenance 7,680.50 95431 CLEMIS Enhancements 0.00 95432 CLEMIS Adhoc Reports 0.00 98003 CLEMIS User Support 1002.00 CLEMIS - Total 056 CLEMIS FUND 63500 63500 CLEMIS Fund $13,922,00 CLEMIS 63500 Fund - Total 1-- 669 CAMS/CVT DATA CONVERSION 66901 CAMS/CVT Data Conversion $10,024.50 CAMS/CVT Data Conversion - Total $22,833.43 $13,922.00 $10,024.50 652 CAMS/FM0 (IT IMPLEMENTATION) 65200 CAMS/FM° (IT Implementation) $50,953.75 CAMS/FM0 (IT Implementation) - Total $50,953.75 $203,026.60 661 COMMUN & HOME IMPROVEMENT 66103 Comm Dev User Support $0.00 Commun & Home Improvement - Total $0.00 $10,536.00 507 CTS-FOC EXP-CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforc-Dev $9,744.50 CTS-FOC Exp-CD Enforc-Dev - Total $9,744.50 659 COLLABORATIVE ASSET MGT SYS 65901 Collabortive Asset Mgt Sys $203,026.60 Collabortive Asset Mgt Sys - Total 471 CTS-FOC-EXP-CS ENFORC-IMAGE 92194 CTS-FOC-Exp-CS Enf-Image $10,536.00 CTS-FOC Exp-CS Enf-Image - Total 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $61.00 24001 SQL Server Support - FRMS 3.5% 996.11 Fire Records Management System - Total 760 FM - BOC WEBCASTING 76000 FM - BOC VVebcasting $14,735.00 FM - BOC VVebcasting - Total $1,057.11 $14,735.00 Page 12 of 14 Prepared by: Information Technology; 10/28/2011 BOC Development Billing Report 4th Quarter 2011.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER 2011 750 FM&O 21001 FM&O $0.00 24013 SQL Server Supp - FM&O 996.11 75503 FM&O Development 4391.50 FM&O - Total $5,387.61 841 HEALTH - H1N1 GRANT 84100 Health - H1N1 Grant S66,827.25 Health - H1N1 Grant - Total $66,827.25 653 O.C. INTNL AIRPORT 65301 Airport User Support $183.00 O.C. IntnlAirport - Total $183.00 770 PARKS AND RECREATION 36530 GIS Implementation Support - Parks $4,381.50 44066 PRADM-System/Customer Support 3,588.00 44068 PRADM-System Enhancements 2,521.00 76100 P&R Administrative Services 10,383.15 77010 PRADM-Technology Assessment 0.00 77100 Yr 1 - Program Management 0.00 77110 Yr 1 - Asset Theme Development 0.00 77120 Yr 1 - Network Connectivity 2,579.75 77130 Yr 1 - Hardware Refresh 0.00 77140 Yr 1 - Point of Sale System 0.00 77200 Yr 2 - Program Management 0.00 77220 Yr 2 - Asset Mgmt Implementation 1,656.50 77230 Yr 2 - Customer Info Mgmt Implementation 0.00 95413 PRADM-Customer Support 13,469.50 95419 PRADM-Ad ministration 10,911.00 Parks & Recreation - Total $49,490.40 761 P&R ADMINISTRATIVE SERVICES 76100 P&R Administrative Services $0.00 P&R Administrative Services - Total $0.00 695 RISK MANAGEMENT 44036 Rsk-System Customer Support $122.00 Risk Management - Total $122.00 656 WATER RESOURCES ACCOUNTING 23011 Oracle Supp - Water & Sewer Acct'g - 5.2% $1,210.06 95669 Water Resources Accounting 9,641.75 Water Resources Accounting - Total $10,851.81 736 WINCAN CENTRAL STORAGE SOLUTION 73601 WinCan Central Storage Solution $2.161.75 WinCan Central Storage Solution - Total $2,161.75 734 WRC - AMR SUPPORT 73401 WRC - AMR Support $370.50 WRC - AMR Support - Total $370.50 737 WRC - DATA APPLICATION PILOT PRJ 73700 VVRC - Data Application Pilot Project $579.50 WRC - Data Application Pilot Prj - Total $579.50 Page 13 of 14 Prepared by Information Technology; 10/28/2011 BOC Development Billing Report 4th Quarter 2011.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER 2011 $244.00 738 WRC SCADA ENGINEERING ASSESSMT 73800 VVRC - SCADA Engineering Assesmnt VVRC - SCADA Engineering Assesmt - Total $244.00 Page 14 of 14 Prepared by: Information Technology: 10/28/2011 BOG Development Billing Report 4th Quarter 2011.xlsx Resolution #11282 November 30, 2011 Moved by Weipert supported by Quarles 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, Hoffman, Jackson, Long, Matis, McGillivray, Middleton, Nash, Nuccio, Potts, Quarles, Runestad, Scott, Taub, Weipert, Zack, Bosnic. (23) 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 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 November 30, 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 30 th day of November, 2011. 094. Bill Bullard Jr., Oakland County