Loading...
HomeMy WebLinkAboutResolutions - 2013.10.30 - 21084MISCELLANEOUS RESOLUTION#^,278 October 24, 2013 BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSONIN RE: DEPARTMENT OF INFORMATION TECHNOLOGY - FOURTH QUARTER 2013DEVELOPMENT 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 2013 development charges to be $974,516.69 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $334,663.63 and non-county agencies are $3,338.93 for the Fourth Quarter 2013; 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 2013 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 2013 budgets are to be amended as specified in the attached detail schedule. FINANCE COMMITTEE VOTE: Motion carried unanimously on a roll call vote with Zack absent. CUST# FUND# ACCOUNT# GOVERNMENTAL FUNDS General Fund noil 540 101 10100-3020201 -121020-773630 550 101 10100-3020301 -121020-773630 560 101 10100-3020401-121020-773630 530 101 10100-3020501-121020-773630 630 101 10100-1070801-114000-773630 005 101 10100-5010101-180010-77363072510110100-2010201-180000-773630 722 101 10100-2010210-125000-773630 440 101 10100-2010301-185010-773630 410 101 10100-2010501-125000-773630 724 101 10100-2010210-125000-773630 720 101 10100-2010401-172190-773630 723 101 10100-2010205-132300-773630 522 101 10100-1070401-113000-773630 620 101 10100-1010201-181010-773630 690 101 10100-1010210-182090-773630 430 101 10100-1010501-181020-773630 015 101 10100-1010101-181000-773630 495 101 10100-3010201-121110-773630 483 101 10100-3010403-121100-773630 498 101 10100-3010301-121130-773630 502 101 10100-3010301-121180-773630 493 101 10100-3010101-121100-773630 785 101 10100-1090101-171000-773630 740 101 10100-1020501-173010-773630 660 101 10100-1020601-182020-773630 900 101 10100-1010115-115090-773630 680 101 10100-1050401-183010-773630 907 101 10100-5010303-165040-773630 565 101 10100-1090108-171030-773630 872 101 10100-1070601-132030-773630 710 101 10100-1070501-174000-773630 163 101 10100-4030901-115140-773630 775 101 10100-1090201-171000-773630 512 101 10100-3040403-124010-773630 510 101 10100-3040403-124010-773630 145 101 10100-4010101-122050-773630 637 101 10100-1030803-184020-773630 650 101 10100-1020650-126020-773630 195 101 10100-4030301-112590-773630 191 101 10100-4030601-110000-773630 445 101 10100-1030803-184025-773630 600 101 10100-7010101-186040-773630 910 101 10100-1070301-132050-773630 730 101 10100-6010101-155010-773630 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 4TH QUARTER 2013 1st Qtr 2013 2nd Qtr2013 3rdQtr2013 4thQtr2013 DIVISION Oct - Dec Jan - Mar Apr - Jun Jul - Sep Y.T-D. 52/1 - District Court $12,414.04 ($4,606.63)$3,288.02 $3,469.67 $14,365.10 52/2 - District Court $12,414.04 ($4,805.63)$3,288.02 $3,469.67 $14,365.10 52/3 - District Court $12,414.04 ($4,806.63)$3,288.02 $3,469.67 $14,365.10 52/4 - District Court $12,413.88 (54,806.61 /$3,287.94 $3,469.49 $14,364.70 Animal Control $20,796.26 $63,858.99 $55,443.82 $24,866.01 $164,965.08 Bd of Commissioners $0.00 $54.00 $61.00 $664.00 $779.00 Clerk/Reg - Admin $1,860.50 $1,080.00 $2,538.00 $2,322.00 $7,800.50 Clerk.Reg - EDMS (Imaging)$2,637.60 $1,993.60 $2,382.40 $1,280.72 $8,294.32 Clerk/Reg - Elections $1,220.00 $5,424.00 $1,572.00 $2,593.00 $10,809.00 Clerk/Reg - Jury Commission $0.00 $122.00 $0.00 $183.00 $305.00 Clerk/Reg - Legal Records $23,249.00 $11,703.50 $11,209.50 $14,472.00 $60,634.00 Clerk/Reg - Register of Deeds $1,637.76 $2,124.74 $2,865.57 $2,247.26 $8,875.33 Clerk/Reg - Vital Statistics $2,858.76 $38,226.24 $11,383.57 $48,134.51 $100,603.08 Community Corrections Admin $33,185.65 $60,441.41 $66,950.41 $29,739.54 $190,317.01 Compliance Office - Auditing $183.00 $61.00 $1,321.00 $2,562.00 $4,127.00 Compliance Office - Purchasing $0.00 $0.00 $0.00 $2,431.00 $2,431.00 Corporation Counsel $176.00 $300.00 $54.00 $542.00 $1,072.00 County Executive $486.00 $378.00 $108.00 $270.00 $1,242.00 Courts-Business Division $940.26 $568.62 $756.52 $655.68 $2,921.08 Courts-FD-Judicial Support-Admin $1,062.26 $1,065.24 $1,457.57 $1,771.26 $5,356.33 Courts-GJ-Judicial Support $99,498.00 $97,274.25 $74,229.00 $91,384.75 $362,386.00 Courts-GJ-Jury Operations $1,270.39 $1,137.17 $1,390.84 $1,311.28 $5,109.68 Courts - Judical / Administration $2,307.90 $4,155.90 $17,880.10 $7,389.13 $31,733.03 Economic Development & Community Affairs $16,993.50 $22,833.00 $27,212.50 $9,893.00 $76,932.00 Equalization Division $85,366.46 $141,756.73 $140,205.60 $137,317.52 $504,646.31 Fiscal Services - Admin $48,366.01 $53,661.43 $49,653.39 $47,343.91 $199,024.74 Homeland Security $518.75 $1,796.00 $3,047.75 $1,362.00 $6,724.50 Human Resources $14,008.30 $17,156.30 $20,517.56 $16,903.34 $68,585.50 Library - Library Admin $122.00 $0.00 $1,996.50 $334.00 $2,452.50 Marketing 8 Communcations $6,167.00 $1,996.00 $5,351.00 $24,647.90 $38,161.90 Medical Examiner $8,969.26 $3,763.24 $4,621.07 $18,954.76 $36,308.33 MSU Extension - Oakland $0.00 $108.00 $162.00 $108.00 $378.00 OCSO - CLEMIS Forensic Lab IMS $0.00 $0.00 $0.00 $8,122.00 $8,122.00 Planning & Economic Development $4,554.50 $1,010.00 $12,344.00 $0.00 $17,908.50 Probate-Estates/Mentai Health - EDMS (Imaging)$2,307.90 $1,744.40 $2,084.60 $1,120.63 $7,257.53 Probate-Estates/Mental Health Support $7,225.26 $2,618.74 $2,372.57 $6,550.01 $18,766.58 Prosecuting Attorney - General Prosecution $16,911.76 $24,228.74 $18,267.57 $21,888.76 $81,296.83 Records Retention $9,828.00 $4,430.00 $0.00 $756.00 $15,014.00 Reimbursement Division $5,794.00 $7,499.50 $8,513.50 . :$6,323.50 $28,130.50 Sheriff $71,943.26 $57,548.12 $89,759.02 $96,168.18 $315,418.58 Sheriff - CLEMIS $9,038.39 $8,594.42 $15,911.84 $6,232.78 $39,777.43 Support Services $6,739.73 $6,967.51 $10,017.78 $7,719.54 $31,444.56 Treasurer $114,021.76 $108,864.10 $82,203.97 $89,989.31 $395,079.14 Veterans Services $0.00 $724.25 $398.00 $1,610.00 $2,732.25 Water Resource Commissioner $60,864.01 $57,185.74 $71,067.07 $55,254.51 $244,371.33 Prepared by; Information Technology; 10/15/2013 BOC Development Billing Report 4th Quarter 2013.xlsx INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 4TH QUARTER 2013 1st Qtr 2013 2nd Qtr 2013 3rd Qtr 2013 4th Qtr 2013 ST#FUND#ACCOUNT#DIVISION Oct - Dec Jan - Mar Anr-Jun Jul - Seo Y.T.D. Sub-Total Fund 101 $732,765.19 $795,228.38 $830,462.59 $807,297.29 $3,165,753.45 Health Fund [2211 840 221 20221-1060201-133150-773630 Health $72,060.50 $52,632.00 $41,490.75 $32,959.50 $199,142.75 843 221 20221-1060220-134390-773630 Health Environmental $90,976.69 $67,410.94 $103,642.25 $113,385.90 $375,415.78 Sub-Total Fund 221 $163,037.19 $120,042.94 $145,133.00 $146,345.40 $574,558.53 Juvenile Maintenance Fund 12931 665 293 20293-1060501-112090-773630 Children's Village $9,460.00 $6,590.50 $5,115.00 $20,874.00 $42,039.50 668 293 20293-1060501-112010-773630 Children's Village Admin $0.00 $30.50 $0.00 $0.00 $30.50 Sub-Total Fund 293 $9,460.00 $6,621.00 $5,115.00 $20,874.00 $42,070.00 63600-1080101-152000-631365 DEVELOPMENT FOR GOVERNMENTAL FUND $905,262.38 $921,892.32 $980,710.59 $974,516.69 $3,782,381.98 APPROPRIATION SUB-TOTAL GOVERNMENTAL DEVELOPMENT APPROPRIATION:$905,262.38 $921,892.32 $980,710.59 $974,516.69 $3,782,381.98 10100-9090101-196030-773630 Information Technology Development (S905.262.38i (SS21.892.321 ($980,710,591 fSS74.516.69i fS3.782.381.981 TOTAL GOVERNMENTAL:$0.00 $0.00 $0.00 $0.00 $0.00 NON-GOVERNMENTAL DIRECT CHARGES 672 Assessment & Tax $52,366.00 $112,300.50 $91,218.50 $100,954.00 $356,839.00 669 CAMS/CVT Data Conversion $0.00 $1,450.50 $52,573.25 $54,944.50 $108,968.25 055 CLEMIS $18,881.81 $12,959.33 $20,915.03 $18,162.41 $70,918.58 699 CLEMIS - CAD $488.00 $0.00 $0.00 $0.00 $488.00 056 CLEMIS FUND 63500 $14,866.00 $18,239.00 $14,884.00 $12,749.00 $60,738.00 659 Collaborative Asset Mgt Sys (CAMS)$37.50 $3,957.25 $1,804.00 $12,063.00 $17,861.75 521 Community Corrections - Admin (Grant)$0.00 $0.00 $0.00 $5,022.00 $5,022.00 471 Courts-FOC Exp-CS Enforcement - EDMS (Imaging)$2,307.90 $1,744.40 $2,084.60 $1,120.63 $7,257.53 507 Courts-FOC Exp-CS Enforcement $22,674.00 $23,171.50 $29,062.50 $52,816.75 $127,724.75 837 EDCA - MITradeSchool.org Grant $15,875.25 $14,330.75 $0.00 $0.00 $30,206.00 210 Fire Records Management System $1,428.26 $1,065.24 $2,555.57 $2,259.26 $7,308.33 750 FM&O $9,592.76 $8,824.49 $8,056.57 $21,296.76 $47,770.58 751 IT Teiepone Communications $0.00 $15.00 $0.00 $0.00 $15.00 634 Oak Video Upgrade (Building Authority)$0.00 $0.00 $0.00 $18,149.00 $18,149.00 653 O.C. International Airport $0.00 $650.50 $1,281.50 $1,669.00 $3,601.00 770 Parks and Recreation - Administration $23,083.00 $19,692.75 $14,862.50 $17,441.54 $75,079.79 747 Pontiac - Water $599.00 $378.00 $1,815.50 $1,145.25 $3,937.75 748 Pontiac - Sewer $599.00 $378.00 $1,815.50 $1,145.25 $3,937.75 791 Radio Communications - E911 $4,927.00 $4,252.50 $7,930.00 $2,135.00 $19,244.50 695 Risk Management $0.00 $385.00 $108.00 $216.00 $709.00 656 Water Resources Accounting $2,116.89 $1,743.67 $2,497.84 $2,601.78 $8,960.18 736 WinCan Central Storage Solution $0.00 $0.00 $0.00 $1,090.00 $1,090.00 670 WRC Acctg - Crowder Prjct $15,617.50 $0.00 $0.00 $0.00 $15,617.50 745 WRC - COSDA Meter Replacement $0.00 $0.00 $0.00 $0.00 $0.00 Prepared by; Information Technology; 10/15/2013 BOC Development Billing Report 4th Quarter 2013-xlsx CUST# FUND# 728 729 737 671 739 738 ACCOUNT# 63600-1080101-152000-631302 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 4TH QUARTER 2013 DIVISION WRC - CO SDS SewMet WRC - EF SDS SewMet WRC - Data Application Pilot Poject WRC - Infrastructure Op Ar WRC - SCADA Common WRC - SCADA Engineering Assessment 1st Qtr2013 Oct - Dec $1,066.20 $1,413.30 $798.00 $608.00 $920.00 $928.00 SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $191.193.37 2nd Qtr 2013 Jan - Mar $3,800.15 $5,037.35 $1,518.50 $4,273.50 $1,795.50 $0.00 $241.963.38 3rd Qtr 2013 Apr-Jun $0.00 $0.00 $0.00 $6,141.75 $2,991.50 $0.00 $262.598.11 4th Qtr 2013 Jul - Sep $0.00 $0.00 $0.00 $0.00 $7,682.50 $0.00 $334.663.63 TOTAL COUNTY DEVELOPMENT CHARGES $1.096.455.75 $1.163.855.70 $1.243.308.70 $1.309.180,32 Y-T-D. $4,866.35 $6,450.65 $2,316.50 $11,023.25 $13,389.50 $928.00 $1.030.418.49 $4,812,800.47 NON-COUNTY AGENCIES 63600-1080101-152000-635017 Non-County Agencies $39.063.00 $32.279.50 $39,265.40 $3.338.93 $113.946.83 Prepared by; Information Technology; 10/15/2013 BOC Development Billing Report 4th Quarter 2013.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2013 Gust# GOVERNMENTAL FUNDS 630 ANIMAL CONTROL 005 BP OF COMMISSIONERS 665 CHILDRENS VILLAGE 668 CHILDRENS VILLAGE ADMIN 725 CLERK/REG ¦ ADMIN 440 CLERK/REG - ELECTIONS DIVISION 720 CLERK I REGISTER OF DEEDS 722 CLERK/REG - EDMS (IMAGING) 410 CLERK/REG - JURY COMMISSION 724 CLERK/REG - LEGAL RECORDS 723 CLERK - VITAL STATISTICS 24017 SQL Server Supp - Animal Control 95628 Web License Registration 95682 Dog System Animal Control-Total 91404 BOC - Customer Support Bd of Commissioners - Total 95665 Childrens Village Childrens Village - Total 97668 Childrens Village Admin Childrens Village Admin - Total 72500 Clerk-Admin Clerk/Reg - Admin - Total 95443 Elections Cierk/Reg - Elections Division - Total 24003 SQL Server Supp - ROD 3.5% 36510 GIS Implementation Support 36511 ROD Application - HAW Support 95493 ROD System Maintenance 95498 Clerk/Reg - ROD Clerk/Reg of Deeds - Total 95158 Clerk/Reg - EDMS Support/Maintneance/Upgrades Clerk/Reg - EDMS (Imaging) - Total 95512 Clerk/Reg - Jury Commission Clerk/Reg - Jury Commission - Total 95189 Circuit Court System Clerk/Reg - Legal Records - Total 24015 SQL Server Supp - Vital Stats 3.5% 95161 Clerk.Reg - Vital Statistics Clerk - Vital Statistics - Total $1,771.26 8,436.00 14,658.75 $664.00 $20.874.00 $0.00 £2.322.00 £2.593.00 $1,771.26 0.00 232.00 0.00 244.00 £1.280.72 £183.00 £14.472.00 $1,771.26 46.363.25 $24,866.01 $664.00 $20,874.00 $0.00 $2,322.00 $2,593.00 $2,247.26 £1,280.72 £183.00 £14,472.00 $48,134.51 Prepared by: Information Technology; 10/15/2013 BOC Development Billing Report 4th Quarter 2013j<Isx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2013 522 COMMUNITY CORRECTIONS-ADMIN (CO) 620 COMPLIANCE OFFICE ¦ AUDITING 690 COMPLIANCE OFFICE - PURCHASING 430 CORPORATION COUNSEL 015 COUNTY EXECUTIVE 495 CTS-BUSINESS DIVISION 483 CTS-FD-JUDICIAL SUPPORT-APM 498 CTS-GEN JURIS-JUDICIAL SUPPT 502 CTS-GJ-JURY OPERATIONS 493 CTS-JUDICIAL ADMIN 23003 24012 52200 52201 44034 95468 44028 95501 95656 12002 23010 24009 95179 23008 95174 785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 36501 95785 Oracle Support-Comm Corr - 5.2% SQL Server Supp - Community Corr 3.5% Comm Corr-Admin (County) Comm Corr - DW Support Community Corrections - Total Auditing - New Development Auditing Interna! Srv - Cust Sup Compliance Office - Auditing - Total Purchasing System Enhancements Compliance Office - Purchasing - Total Corporation Counsel Corporation Counsel - Total County Executive Support County Executive - Total CCT-Courts/Criminal Oracle Support-CCT/CTS Crim Whse 2.6% CTS-Business Division - Total SQL Serv Supp - CTS-Jud Sup Adm - 3.5% CTS-FD-Judicial Support-Adm - Total CTS-Gen Juris-Judicial Suppt CTS-Gen Juris-Judicial Suppt-Total Oracle Support-CTS-GJ-Jury Operations CTS-GJ-Jury Operations - Total CTS-Judicial Admin CTS-Judicial Admin - Total GIS Implementation Support C&E Dev CED Application - H/W Support Comm & Eco Developmt Economic Development & Community Affairs - Total $1,311.28 1,771.26 11,809.50 14,847.50 $2,562.00 0.00 $2.431.00 £542.00 $270.00 $0.00 655.68 $1.771.26 $91.384.75 $1.311.28 $7.389.13 $170.50 9,293.50 429.00 $29,739.54 $2,562.00 $2,431.00 $542.00 $270.00 $655.68 $1,771.26 $91,384.75 $1,311.28 $7,389.13 $9,893.00 Prepared by: Information Technology; 10/15/2013 BOC Development Billing Report 4th Quarter 2013.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2013 740 EQUALIZATION 23012 Oracle Support-Equalization - 5.2% $1,311.28 24005 SQL Server Supp-Equalization -10.5% 5,313.49 31075 Equal - Development 62,941.50 36505 GIS Implementation Support Equalization 539.50 36506 Equal Application - H/W Support 33,854.50 36601 Land System Enhancements - Equal (50%) 2,370.25 36701 Land System Maintenance - Equal (50%) 3,013.25 36801 Land System Support- Equal (50%) 1,001.25 95562 Equalization - DW Support 73.50 95693 Equalization - System Maintenance 0.00 95699 BS&A Master Appraisal Sup/Maint 26.899.00 Equalization - Total 660 FISCAL SERVICES ADMIN 23001 Oracle 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 44023 FS - System Enhancements 96001 Human Res - Acct 40% 96003 Human Res - Budget 20% Fiscal Services Admin - Total $3,933.90 1,311.28 885.83 18,458.50 2,376.00 13,585.60 6,792.80 840 HEALTH DIVISION 36525 GIS Implementation Support Health $0.00 95563 User Support-Health 22,851.50 96842 Health Admin 10.108.00 Health - Total 843 HEALTH - ENVIRONMENTAL 23005 Oracle Support - EH Projects - 5.2% 24014 SQL Server Suppt - Ehealth 14% 84200 EH - Projects 84300 Ehealth Program Health-Environmental - Total $1,311.28 7,084.49 67,159.88 37.830.25 900 HOMELAND SECURITY 36545 GIS Implementation Support Homeland Security 36546 Homeland Security Application - H/W Support 98990 Homeland Security Homeland Security - Total $0.00 174.00 1,188.00 680 HUMAN RESOURCES 23014 Oracle Support-HR/Personnel - 5.2% 24007 SQL Server Suppport-HR/Personne! -1.75% 96002 Human Res-Personnel 40% Human Resources - Total $1,311.28 885.83 14,706.23 $137,317.52 $47,343.91 $32,959.50 $113,385.90 $1,362.00 $16,903.34 Prepared by: Information Technology: 10/15/2013 BOC Development Billing Report 4th Quarter 2013.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2013 907 LIBRARY - LIBRARY ADMIN 565 MARKETING & COMMUNICATIONS 872 MEDICAL EXAMINER 710 MSU EXTENSION - OAKLAND 163 OCSO-CLEMIS FORENSIC LAB IMS 775 PLANNING & ECO DEVELOPMENT 512 PROB-ESTATES/MENTL HLTH EDMS (IMG) 510 PROB-ESTATES/MENTL HLTH SUPPORT 145 PROSECUTOR - GENERAL PROSECUTION 637 RECORDS RETENTION 650 REIMBURSEMENT 91405 Library Board Library - Library Admin - Total 56500 Marketing & Communications Marketing & Communications - Total 24002 SQL Server Support - Medical Exam - 3.5% 87202 Medical Examiner - Customer Support Medical Examiner - Total 95676 MSU Ext Equipment Maintenance MSU Extension - Oakland - Total 16300 OCSO-CLEMIS Forensic Lab OCSO-CLEMIS Forensic Lab IMS - Total 95600 PEDS Cust/System Support Planning & Eco Development - Total 95207 PC-E/MH EDMS Support & Mtce Prob-Est/Mntl Hlth EDMS (Img) 24010 SQL Serv Supp-PCT-Est/Mental - 3.5% 92198 Prob-Est/Mntl Hlth Support Prob-Est/Mntl Hlth Support-Total 24016 SQL Server Supp - Proescutors 3.5% 95622 Prosecutor/Executive 97001 Prosecutor Data Proc Prosecutor-Total 44053 FEC - System Enhancements Records Retention - Total 95470 Reimbursement System 95542 Reimburse User Support Reimbursement - Total $334.00 $24.647.90 $1,771.26 17,183.50 $108.00 .122.00 $0.00 $1.120.63 $1,771.26 4778.75 $1,771.26 19,037.50 1,080.00 $756.00 $3,163.50 3.160.00 $334.00 $24,647.90 $18,954.76 $108.00 $8,122.00 $0.00 $1,120.63 $6,550.01 $21,888.76 $756.00 $6,323.50 Prepared by: Information Technology; 10/15/2013 BOC Development Billing Report 4th Quarter 2013.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2013 195 SHERIFF 12001 OCSD-Courts/Criminal - 50% 23009 Oracle Suppport - OCSD/CTS Crim Whse - 2.6% 97163 Sheriff 97164 Sheriff- Development 97165 Sheriff-DW Support 98164 CLEMIS-Sheriff Sheriff - Total $0.00 655.68 6,819.50 122.00 3,155.50 85,415.50 3,168.18 191 SHERIFF -CLEMIS 445 SUPPORT SERVICES 23015 Oracle Suppport - Sheriff / CLEMIS - 5.2% 96163 Sheriff-CLEMIS Sheriff-CLEMIS-Total 23002 Oracle Support - Supp Sen/ - 5.2% 24011 SQL Server Supp - Suppt Services 7% 44500 Support Services Support Services - Total $1,311.28 4,921.50 $1,311.28 3,542.26 2.866.00 5,232.78 $7,719.54 600 TREASURER 23006 Oracle Support - Del Tax - 5.2% 23016 Oracle Support - Treasurer -10.4% 36516 Treasurer Application - H/W Support 36602 Land System Enhancements - Treas (50%) 36702 Land System Maintenance - Treas (50%) 36802 Land System Support - Treas (50%) 44061 Tre-System/Customer Support 44062 Tre-System Maintenance 44063 Tre-System Enhancements 44080 Tre-DW Support 44082 Tre-DW Maintenance 95008 Del Tax On Line 95303 Del Tax System Maintenance 95561 User Support/Del Tax 95615 BS&A Annual Tax Support Treasurer-Total $1,311.28 2,622.65 6,102.00 2,370.25 3,013.25 1,001.25 12,453.13 582.00 2,474.00 52.00 54.00 573.50 1,149.50 29,818.50 26.412.00 $89,989.31 910 VETERANS SERVICES 95651 Veterans Customer Support Veterans Services - Total $1.610.00 $1,610.00 730 WATER RESOURCE COMMISSIONER 24008 SQL Server Supp - WRC 3.5% 28010 WRC - Customer Support 28011 Water Resource Commissioner Application 36520 CIS Implementation Support WRC 36521 WRC Application - H/W Support Water Rescurce Commissioner - Total $1,771.26 9,200.75 19,305.25 4,310.25 20.667.00 $55,254.51 Prepared by: Information Technology; 10/15/2013 BOC Development Billing Report 4th Quarter 2013.xls* INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2013 540 52/1 DISTRICT COURT - NOVI 95527 DC Suprt- 52/1 - 25% 52/1 District Court - Total $3.469.67 $3,469.67 550 52/2 DISTRICT COURT ¦ CLARKSTON 95528 DC Suprt- 52/2 - 25% 52/2 District Court - Total $3.469.67 $3,469.67 560 52/3 DISTRICT COURT - ROCHESTER 95288 52 Dist Ct Div 3 95529 DC Suprt - 52/3 - 25% 52/3 District Court - Total $0.00 3.469.67 $3,469.67 530 52/4 DISTRICT COURT - TROY 95530 DC Suprt- 52/4 - 25% 52/4 District Court - Total $3.469.49 $3,469.49 Prepared by: Information Technology; 10/15/2013 BOC Development Billing Report 4th Quarter 2013.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2013 Cust# DIRECT FUNDS 672 ASSESSMENT & TAX 055 CLEMIS 699 CLEMIS - CAD 056 CLEMIS FUND 63500 669 CAMS/CVT DATA CONVERSION 659 COLLABORATIVE ASSET MGT SYS 471 CTS-FOC-EXP-CS ENFORC-EDMS (IMG) 507 CTS-FOC EXP-CS ENFORCEMENT 521 COMM CORR - ADM (GRANT) 837 EDCA ¦ MITRADESCHOOL.ORG GRANT 210 FIRE RECORDS MANAGEMENT SYSTEM 67200 Assessmenet & Tax $100.954.00 Assessmenet & Tax - Total $100,954.00 23004 Oracle Support - OakVideo CLEMIS 5.2% $1,311.28 23018 Oracle Support - Sheriff CLEMIS 5.2% 1,311.65 24004 SQL Server Support - 24.5% 12,397.98 95430 CLEMIS Maintenance 1,403.00 95431 CLMS Enhancements 0.00 98003 CLEMIS User Support 1,738.50 98005 CLEMIS - E911 Support 000 CLEMIS-Total $18,162.41 98006 CLEMIS - CAD Development $0.00 CLEMIS-CAD Total $0.00 63500 CLEMIS Fund $12.749.00 CLEMIS 63500 Fund-Total $12,749.00 66901 CAMS/CVT Data Conversion $54.944.50 CAMS/CVT Data Conversion - Total $54,944.50 65901 Collabortive Asset Mgt Sys $12,063.00 Collabortive Asset Mgt Sys - Total $12,063.00 92194 CTS-FOC-CS ENF-EDMS Support/Maintenance/Upgrades $1.120.63 CTS-FOC Exp-CS Enforc-EDMS (Img) - Total $1,120.63 92193 CTS-FOC Exp-CD Enforc-Dev $52.816.75 CTS-FOC Exp-CD Enforc-Dev - Total $52,816.75 52102 Community Corrections - COMPAS App $5.022.00 Comm Corr - Adm (Grant) - Total $5,022.00 83700 EDCA - MITRADESCHOOL $0.00 EDCA-MITradeSchool.org Grant - Total $0.00 21010 Fire Records Mgmt Fund 531 $488.00 24001 SQL Server Support - FRMS 3.5% 1.771,26 Fire Records Management System - Total $2,259.26 Prepared by: Information Technology; 10/15/2013 BOC Development Billing Report 4th Quarter 201 S.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2013 750 FM&O 791 IT - TELEPHONE COMMUNICATIONS 634 OAK VIDEO UPGRADE (BA) 653 O.C. INTNL AIRPORT 770 PARKS AND RECREATION 747 PONTIAC WATER 748 PONTIAC SEWER 791 RADIO COMMUNICATIONS - E911 695 RISK MANAGEMENT 656 WATER RESOURCES ACCOUNTING 21001 Facilities Maintenance & Operations 24013 SQL Server Supp - FM&O 75503 FM&O Deveiopment FM&O - Total 75102 Telephone Communications - Customer Support IT - Telephone Communications - Total 63400 CLEMIS - Oak Video Upgrade 63401 IT - Oak Video Upgrade Oak Video Upgrade (BA) - Total 65301 Airport User Support O.C. Intnl Airport - Total 36530 GIS Implementation Support - Parks 44066 PRADM-System/Customer Support 44068 PRADM-System Enhancements 76100 P&R Administrative Services 95413 PRADM-Customer Support 95419 PRADM-Administration Parks & Recreation - Total 74701 Pontiac BSA to WRC - Water Pontiac Water - Total 74702 Pontiac BSA to WRC - Sewer Pontiac Sewer - Total 79101 Radio Communications - E911 Radio Communications - E911 - Total 44036 Rsk-System Customer Support Risk Management - Total 23011 Oracle Supp - Water & Sewer Acct'g - 5.2% 95669 Water Resources Accounting Water Resources Accounting - Total $990.00 1,771.26 18,535.50 $0.00 $18,088.00 61.00 £1.669.00 $1,322.50 86.50 535.54 5,239.00 838.50 9.419.50 $1.145.25 $1.145.25 $2.135.00 $216.00 $1,311.28 1.290.50 $21,296.76 $0.00 $18,149.00 $1,669.00 $17,441.54 $1,145.25 $1,145.25 $2,135.00 $216.00 $2,601.78 Prepared by: Information Technology; 10/15/2013 BOC Development Billing Report 4th Quarter 2013.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2013 736 WINCAN CENTRAL STORAGE SOLUTION 73601 WinCan Central Storage Solution S1.090.00 WinCan Central Storage Solution - Total $1,090.00 670 WRC ACCTG - CROWDER PRJCT 67000 WRC - Crowder NetBase Project $0,00 WRC Acctg - Crowder Prject - Total $0.00 745 WRC ¦ COSDA METER REPLACEMENT 74500 WRC - CODSA Meter Replacement £0.00 WRC - CODSA Meter Replacement - Total $0.00 728 WRC ¦ CO SDS SEWMET 72201 MARS Enhancements - WRC C-0 $0.00 WRC - CO SDS SewMet - Total $0.00 729 WRC-EF SDS SEWMET 72202 MARS Enhancements - WRC E-F $0.00 WRC - EF SDS SewMet - Total $0.00 737 WRC ¦ DATA APPLICATION PILOT PRJ 73700 WRC - Data Application Pilot Project $0.00 73710 WRC - Data Appl Prj 0.00 WRC - Data Application Pilot Prj - Total $0.00 671 WRC - INFRASTRUCTURE OP AR 67100 WRC-IOAR $0.00 WRC - infrastructure Op Ar - Total $0.00 739 WRC • SCADA COMMON 73900 WRC - SCADA Common $7.682.50 WRC - SCADA Common - Totai $7,682.50 738 WRC - SCADA ENGINEERING ASSESSMT 73800 WRC - SCADA Engineering Assesmnt $0.00 WRC - SCADA Engineering Assesmt - Total $0.00 Prepared by: Information Technology; 10/15/2013 BOC Development Billing Report 4th Quarter 2013.xlsx Resolution #13278 October 30, 2013 Moved by Crawford supported by Quarles the resolutions (with fiscal notes attached) on the amended Consent Agenda be adopted (with accompanying reports being accepted). AYES: Dwyer, Gershenson, Gingell, Gosselin, Hatchett, Hoffman, Jackson, Long, Matis, McGillivray, Middleton, Quarles, Runestad, Scott, Spisz, Taub, Weipert, Woodward, Bosnic, Crawford, (20) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the amended Consent Agenda were adopted (with accompanying reports being accepted). STATE OF MICHIGAN)COUNTY OF OAKLAND) I, Lisa Brown, 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 October 30, 2013, 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 30th day of October 2013. I HEREBY APPROVE THIS RESOLUTION CHIEF DEPUTY COUNT/ EXECUTIVE ACTING PURSUANT TO MCL 45.559A (7) Lisa Brown, Oakland County