Loading...
HomeMy WebLinkAboutResolutions - 2014.02.06 - 21178MISCELLANEOUS RESOLUTION #14018 February 6, 2014 BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — FIRST QUARTER 2014 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 First Quarter 2014 development charges to be $872,327.34 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $581,416.26 and non-county agencies are $526.50 for the First Quarter 2014; 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 First Quarter 2014 Development Report and approves the First Quarter appropriation transfer as specified on the attached schedule. BE IT FURTHER RESOLVED that the respective departmental Fiscal Year 2014 budgets are to be amended as specified in the attached detail schedule. FINANCE COMMITTEE VOTE: Motion carried unanimously on a roll call vote. INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 1ST QUARTER 2014 1st Qtr 2014 CUST # FUND # ACCOUNT # DIVISION Oct - Dec Y.T.D. GOVERNMENTAL FUNDS General Fund 11011 540 101 10100-3020201-121020-773630 52/1 - District Court $1,737.38 $1,737.38 550 101 10100-3020301-121020-773630 52/2- District Court $1,737.38 $1,737.38 560 101 10100-3020401-121020-773630 52/3- District Court $1,737.38 $1,737.38 530 101 10100-3020501-121020-773630 5214- District Court $1,737.36 $1,737.36 630 101 10100-1070801-114000-773630 Animal Control $10,353.06 $10,353.06 005 101 10100-501 0101-1 8001 0-773630 Bd of Commissioners $244.00 $244.00 725 101 10100-2010201-180000-773630 Clerk/Reg - Admin $35.75 $35.75 722 101 10100-2010210-125000-773630 Clerk.Reg - EDMS (Imaging) $1,703.28 $1,703.28 440 101 10100-2010301-185010-773630 Clerk/Reg - Elections $758.00 $758.00 410 101 10100-2010501-125000-773630 Clerk/Reg - Jury Commission $0.00 $0.00 724 101 10100-2010210-125000-773630 Clerk/Reg - Legal Records $16,944.75 $16,944.75 720 101 10100-2010401-172190-773630 Clerk/Reg - Register of Deeds $2,091.06 $2,091.06 723 101 10100-2010205-132300-773630 Clerk/Reg - Vital Statistics $10,704.56 $10,704.56 522 101 10100-1070401-113000-773630 Community Corrections Admin $17,841.97 $17,841.97 620 101 10100-1010201-181010-773630 Compliance Office - Auditing $2,480.00 $2,480.00 690 101 10100-1010210-182090-773630 Compliance Office - Purchasing $1,859.00 $1,859.00 430 101 10100-1010501-181020-773630 Corporation Counsel $845.00 $845.00 015 101 10100-1010101-181000-773630 County Executive $338.00 $338.00 495 101 10100-3010201-121110-773630 Courts-Business Division $608.28 $608.28 483 101 10100-3010403-121100-773630 Courts-FD-Judicial Support-Admin $1,051.56 $1,051.56 498 101 10100-3010301-121130-773630 Courts-GJ-Judicial Support $74,781.50 $74,781.50 502 101 10100-3010301-121180-773630 Courts-GJ-Jury Operations $1,216.41 $1,216.41 493 101 10100-3010101-121100-773630 Courts - Juclical / Administration $3,220.37 $3,220.37 785 101 10100-1090101-171000-773630 Economic Development & Community Affairs $10,923.50 $10,923.50 740 101 10100-1020501-173010-773630 Equalization Division $206,405.07 $206,405.07 660 101 10100-1020601-182020-773630 Fiscal Services - Admin $44,275.38 $44,275.38 900 101 10100-1010115-115090-773630 Homeland Security $1,352.00 $1,352.00 680 101 10100-1 050401-1 8301 0-773630 Human Resources $14,504.03 $14,504.03 907 101 10100-5010303-165040-773630 Library - Library Admin $3,144.00 $3,144.00 565 101 10100-1090108-171030-773630 Marketing & Communcations $17,910.34 $17,910.34 872 101 10100-1070601-132030-773630 Medical Examiner $4,251.56 $4,251.56 710 101 10100-1070501-174000-773630 MSU Extension - Oakland $547.00 $547.00 Page 1 of 13 Prepared by; Information Technology; 1/21/2014 BOG Development Billing Report 1st Quarter 2014.xlsx 1st Qtr 2014 Oct - Dec $0.00 $2,654.00 $1,490.37 $4,820.06 $934.00 $15,695.06 $108.00 $10,665.50 $96,098.78 $2,131.41 $5,372.33 $81,264.57 $549.00 $59,040.06 $738,162.07 Y.T.D. $0.00 $2,654.00 $1,490.37 $4,820.06 $934.00 $15,695.06 $108.00 $10,665.50 $96,098.78 $2,131.41 $5,372.33 $81,264.57 $549.00 $59,040.06 $738,162.07 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 1ST QUARTER 2014 DIVISION OCSO - CLEMIS Forensic Lab IMS Planning & Economic Development Probate-Estates/Mental Health - EDMS (Imaging) Probate-Estates/Mental Health Support Probate-Family Division Judicial Prosecuting Attorney - General Prosecution Records Retention Reimbursement Division Sheriff Sheriff - CLEMIS Support Services Treasurer Veterans Services Water Resource Commissioner Sub-Total Fund 101 CUST # FUND # ACCOUNT # 163 101 10100-4030901-115140-773630 775 101 10100-1090201-171000-773630 512 101 10100-3040403-124010-773630 510 101 10100-3040403-124010-773630 481 101 10100-3040101-121060-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 Health Fund [221] 840 221 20221-1060201-133150-773630 Health $16,289.50 $16,289.50 843 221 20221-1060220-134390-773630 Health Environmental $85,161.27 $85,161.27 Sub-Total Fund 221 $101,450.77 $101,450,77 Juvenile Maintenance Fund 12931 665 293 20293-1060501-112090-773630 668 293 20293-1060501-112010-773630 63600-1080101-152000-631365 10100-9090101-196030-773630 Children's Village Children's Village Admin Sub-Total Fund 293 DEVELOPMENT FOR GOVERNMENTAL FUND APPROPRIATION SUB-TOTAL GOVERNMENTAL DEVELOPMENT APPROPRIATION: Information Technology Development TOTAL GOVERNMENTAL: $32,714.50 $32,714.50 $0.00 $0.00 $32,714.50 $32,714.50 $872,327.34 $872,327.34 $872,327.34 $872,327.34 ($872,327.34) ($872,327.34) $0.00 $0.00 Page 2 of 13 Prepared by; Information Technology; 1121/2014 BOC Development Biliing Report 1st Quarter 2014.xlsx INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 1ST QUARTER 2014 1st Qtr 2014 CUST # FUND # ACCOUNT # DIVISION Oct-Dec Y.T.D. NON-GOVERNMENTAL DIRECT CHARGES 672 Assessment St Tax $78,134.50 $78,134.50 669 CAMS/CVT Data Conversion $34,114.75 $34,114.75 055 CLEMIS $21,261.60 $21,261.60 699 CLEMIS - CAD $0.00 $0.00 056 CLEMIS FUND 63500 $15,494.00 $15,494.00 659 Collaborative Asset Mgt Sys (CAMS) $21,263.00 $21,263.00 521 Community Corrections - Admin (Grant) $0.00 $0.00 471 Courts-FOC Exp-CS Enforcement - EDMS (Imaging) $1,490.37 $1,490.37 507 Courts-FOC Exp-CS Enforcement $119,612.50 $119,612.50 673 Cyber Security Fund $177,034.65 $177,034.65 837 EDCA - MITradeSchool.org Grant $0.00 $0.00 210 Fire Records Management System $1,051.56 $1,051.56 750 FM&O $29,046.06 $29,046.06 751 IT Telepone Communications $0.00 $0.00 634 Oak Video Upgrade (Building Authority) $41,818.50 $41,818.50 653 O.C. International Airport $642.00 $642.00 770 Parks and Recreation-Administration $14,991.36 $14,991.36 747 Pontiac - Water $348.75 $348.75 748 Pontiac - Sewer $348.75 $348.75 791 Radio Communications - E911 $7,259.00 $7,259.00 695 Risk Management $0.00 $0.00 656 Water Resources Accounting $2,744.91 $2,744.91 736 WinCan Central Storage Solution $0.00 $0.00 670 WRC Acctg - Crowder Prjct $0.00 $0.00 745 WRC - COSDA Meter Replacement $0.00 $0.00 728 WRC - CO SDS SewMet $0.00 $0.00 729 WRC - EF SDS SewMet $0.00 $0.00 737 WRC - Data Application Pilot Poject $1,221.00 $1,221.00 671 WRC - Infrastructure Op Ar $0.00 $0.00 739 WRC - SCADA Common $13,539.00 $13,539.00 738 WRC - SCADA Engineering Assessment $0.00 $0.00 Page 3 of 13 Prepared by; Information Technology; 1/21/2014 BOC Development Billing Report 1st Quarter 2014.xlsx INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY 1ST QUARTER 2014 DIVISION SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT CUST # FUND # ACCOUNT # 63600-1080101-152000-631302 1st Qtr 2014 Oct - Dec Y.T.D. $581,416.26 $581,416.26 TOTAL COUNTY DEVELOPMENT CHARGES $1,453,743.60 $1,453,743.60 NON-COUNTY AGENCIES 63600-1080101-152000-635017 Non-County Agencies $526.50 $526.50 Page 4 of 13 Prepared by; Information Technology; 1121/2014 BOC Development Billing Report 1st Quarter 2014.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER 2014 cust # GOVERNMENTAL FUNDS 630 ANIMAL CONTROL 24017 $1,051.56 95628 3,445.00 95682 5,856.50 91404 95158 95512 95189 24015 95161 005 BE) OF COMMISSIONERS 665 CHILDRENS VILLAGE 668 CHILDRENS VILLAGE ADMIN 725 CLERK/REG - ADMIN 440 CLERK/REG - ELECTIONS DIVISION 720 CLERK / REGISTER OF DEEDS 722 CLER1C/REG EDMS (IMAGING) 410 CLERK/REG -JURY COMMISSION 724 CLERKJR.EG - LEGAL RECORDS 723 CLERK - VITAL STATISTICS $244.00 $32,714.50 $0.00 $35.75 $758.00 $1,051.56 $579.50 $213.50 $0.00 246.50 $1,703.28 $0.00 $16 944 75 $1,051.56 9,653.00 $10,353.06 $244.00 $32,714.50 $0.00 $35.75 $758.00 $2,091.06 $1,703.28 $0.00 $16,944.75 $10,704.56 95665 97668 72500 95443 24003 36510 36511 95493 95498 Page 5 of 13 Prepared by: Information Technology; 1/2112014 BOG Development Billing Report 1st Quarter 2014.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2014 522 COMMUNITY CORRECTIONS-ADMIN (CO) 23003 $1,216.41 24012 1,051.56 52200 15,574.00 52201 0.00 $17,841.97 $2,480.00 $1,859.00 $845.00 $338.00 $608.28 $1,051.56 $74,781.50 $1,216.41 $3,220.37 44034 95468 44028 95501 95656 12002 23010 24009 95179 23008 95174 36500 36501 95785 620 COMPLIANCE OFFICE -AUDITING 690 COMPLIANCE OFFICE - PURCHASING 430 CORPORATION COUNSEL 015 COUNTY EXECUTIVE 495 CTS-BUSINESS DIVISION 483 CTS-FD-JUDICIAL SUPPORT-ADM 498 CTS-GEN JURIS-JUDICIAL SUP PT 502 CTS-GJ-JURY OPERATIONS 493 CTS-JUDICIAL ADMIN 785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS $2,257.00 223.00 $1,859.00 $845.00 $338.00 $0.00 608.28 $1,051.56 $74,781.50 $1216.41 $3,220.37 $323.00 10,600.50 0.00 $10,923.50 Page 6 of 13 Prepared by: Information Technology; 1/21/2014 ROD Development Billing Report at Quarter 2014.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER 2014 740 EQUALIZATION 23012 24005 31075 36505 36506 36601 36701 36801 95562 95693 95699 $1,216.41 3,154.41 137,645.25 12,220.50 25,619.75 6,259.00 727.75 416.50 73.50 0.00 19,072.00 $206,405.07 660 FISCAL SERVICES AMIN 23001 $3,649.40 23013 1,216.41 24006 525.85 44021 16,502.50 44023 1,586.00 44024 1,386.00 44602 2,502.12 96001 11,271.40 96003 5,635.70 $44,275.38 840 HEALTH DIVISION 36525 $300.76 95563 9,568.75 96842 6,420.00 $16,289.50 843 HEALTH - ENVIRONMENTAL 23005 $1,216.41 24014 4,205.74 84200 55,961.62 84300 23 777.50 $85,161.27 900 HOMELAND SECURITY 36545 $0.00 36546 146.50 98990 1.205.50 $1,352,00 Page 7 of 13 Prepared by: Information Technology; 1/2112014 BQC Development Billing Report 1st Quarter 2014.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2014 680 HUMAN RESOURCES 23014 $1,216.41 24007 525.85 96002 12 761 77 907 LIBRARY - LIBRARY ADMIN 91405 $3.144,00 $14,504.03 $3,144.00 $17,910.34 565 MARKETING & COMMUNICATIONS 56500 $17,910.34 872 MEDICAL EXAMINER 24002 $1,051.56 710 MSU EXTENSION - OAKLAND 87202 95676 3,200.00 $547.00 $4,251.56 $547.00 $0.00 $2,654.00 $1,490.37 163 OCSO-CLEMIS FORENSIC LAB IMS 775 PLANNING & ECO DEVELOPMENT 512 PROB-ESTATES/MENTL HLTH EDMS (IMGI 510 PROB-ESTATES/MENTL HLTH SUPPORT 16300 95600 95207 $0.00 $2,654.00 $1490.37 24010 $1,051.56 92198 3,768.50 $4,820.06 481 PROB-FD JUDICIAL 95168 $934,00 $934.00 145 PROSECUTOR - GENERAL PROSECUTION 24016 $1,051.56 95622 14,643.50 97001 0.00 $15,695.06 637 RECORDS RETENTION 44053 .$108.00 $108.00 Page 8 of 13 Prepared by Information Technology; 1/2112014 BOC Development Ell I llng Report lst Quarter 2014.xtsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FIRST QUARTER 2014 650 REIMBURSEMENT 95470 $10,665.50 95542 0.00 $10,665.50 195 SHERIFF 12001 23009 97163 97164 97165 98164 $0.00 608.28 14,681.00 0_00 4,544.50 76,265.00 $96,098.78 191 SHERIFF - CLEMIS 23015 $1,216.41 96163 915.00 $2,131.41 445 SUPPORT SERVICES 23002 $1,216.41 24011 2,102.92 44500 2.053.00 $5,372.33 600 TREASURER 23006 23016 36516 36602 36702 36802 44061 44062 44063 44080 44082 44601 95008 95303 95561 95615 $1,216.41 2,432.91 13,216.00 6,259.00 727.75 416.50 9,552.87 1,406.00 6,277.50 0.00 0.00 2,502.13 0.00 793.00 24,274.00 12 190 50 $81,264.57 910 VETERANS SERVICES 95651 $549.00 $549.00 Page 9 of 13 Prepared by: Information Technology; 1/2112014 BOC Development Biiling Report 1st Quarter 2014.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FIRST QUARTER 2014 730 WATER RESOURCE COMMISSIONER 24008 $1,051.56 28010 14,377.50 28011 10,768.00 36520 2,969.00 36521 29 874.00 540 52/1 DISTRICT COURT - NOVI 95527 $1.737.38 $59,040.06 $1,737.38 $1,737.38 550 62/2 DISTRICT COURT - CLARKSTON 95528 $1,737.38 560 52/3 DISTRICT COURT ROCHESTER 95288 $0.00 95529 1.737.38 $1,737.38 530 52/4 DISTRICT COURT- TROY 95530 $1,737.36 $1,737.36 Page 10 of 13 Prepared by: Information Technology; 1/2112014 BOG Development Billing Report lot Quarter 2014.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2014 Cust # DIRECT FUNDS 672 ASSESSMENT & TAX 67200 $78,134.50 $78,134.50 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) 673 CYBER SECURITY FUND 837 EDCA - MITRADESCHOOL.ORG GRANT 23004 $1,216.41 23018 1,217.04 24004 7,360.15 95430 10,248.00 95431 0.00 98003 1,220.00 98005 0.00 98006 $0.00 63500 $15,494.00 66901 $34,114.75 65901 $21,263.00 92194 $1,490.37 92193 $119,612.50 52102 67300 $177,034,65 83700 $0.00 $21,261.60 $0.00 $15,494.00 $34,114.75 $21,263.00 $1,490.37 $119,612.50 $0.00 $177,034.65 $0.00 Page 11 of 13 Prepared by: Information Technology; 1/21/2014 BOG Development Billing Report let Quarter 2014.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2014 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 $0.00 24001 1,051.56 $1,051.56 750 FM&O 21001 24013 75503 $55.00 1,051.56 27 939.50 $29,046.06 751 IT - TELEPHONE COMMUNICATIONS 75102 $0.00 $0,00 634 OAK VIDEO UPGRADE (BA) 63400 63401 $41,696.50 122.00 $41,818.50 653 0.C. INTNL AIRPORT 65301 $642.00 $642.00 770 PARKS AND RECREATION 36530 $183.00 44066 114.50 44068 705.36 76100 2,847.00 95413 28.00 95419 11 113.50 74701 74702 79101 44036 23011 95669 747 PONTIAC WATER 748 PONTIAC SEWER 791 RADIO COMMUNICATIONS • E911 695 RISK MANAGEMENT 656 WATER RESOURCES ACCOUNTING $348.75 $348.75 $7,259.00 $0.00 $1,216.41 1,528.50 $14,991.36 $348.75 $348.75 $7,259.00 $0,00 $2,744.91 Page 12 of 13 Prepared by: Information Technology; 1/21/2014 BOC Development Billing Report let Quarter 2014.xlsx INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FIRST QUARTER 2014 736 WINCAN CENTRAL STORAGE SOLUTION 670 WRC ACCTG - CROWDER PRJCT 745 WRC - COSDA METER REPLACEMENT 728 WRC - CO SDS SEWMET 729 WRC - EF SDS SEWMET 737 WRC - DATA APPLICATION PILOT PRJ 73601 $0.00 $0.00 67000 $0.00 74500 $0.00 $0.00 $0.00 72201 $0,00 $0.00 72202 $0.D1) $0.00 73700 $0.00 73710 1.22t00 $1,221.00 671 WRC - INFRASTRUCTURE OP AR 67100 $0.00 $0.00 739 WRC - SCADA COMMON 73900 $13,539.00 $13,539.00 738 WRC - SCADA ENGINEERING ASSESSMT 73800 $0.00 $0.00 Page 13 of 13 Prepared by: Information Technology; 112112014 BOC Development Billing Report let Quarter 2014.xlsx Resolution #14018 February 6, 2014 Moved by Spisz supported by McGillivray the resolutions (with fiscal notes attached) on the amended Consent Agenda be adopted (with accompanying reports being accepted and appointments being confirmed). AYES: Dwyer, Gingell, Gosselin, Hoffman, Jackson, Long, Matis, McGillivray, Middleton, Quarles, Runestad, Scott, Spisz, Taub, Weipert, Woodward, Zack, Bosnic, Crawford. (19) 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 and appointments being confirmed). ? I HEREBY APPROVE THIS RESOLUTION CHIEF DEPUTY COUNTY EXECUTIVE ACTING PURSUANT TO IVICL 45.559A (7) 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 February 6, 2014, 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 6th day of February 2014. Lisa Brown, Oakland County