Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Resolutions - 2018.11.14 - 23860
MISCELLANEOUS RESOLUTION #18374 November 14, 2018 BY: Commissioner Thomas Middleton, Chairperson, Finance committee IN RE: DEPARTMENT OF INFORMATION TECHNOLOGY — FOURTH QUARTER 2018 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 2018 development charges to be $1,028,416.73 for the General Fund/General Purpose County departments; and WHEREAS direct charges to Special Revenue and Proprietary fund departments are $749,708.27 and non-county agencies are $7,395.25 for the Fourth Quarter 2018; 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 2018 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 2018 budgets are to be amended as specified in the attached detail schedule. Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution. Commissioner Thomas Middleton, District #4 Chairperson, Finance Committee FINANCE COMMITTEE VOTE: Motion carried unanimously on a roll call vote with Zack absent. 540 550 560 530 630 005 450 184 718 725 291 722 440 410 724 723 522 620 690 430 506 483 482 015 495 498 502 493 785 740 660 900 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 101 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2018 GUST FUND# ACCOUNT GOVERNMENTAL FUNDS General Fund moil 10100-3020201-121020-773630 10100-3020301-121020-773630 10100-3020401-121020-773630 10100-3020501-121020-773630 10100-1070801-114000-773630 10100-5010101-180010-773630 10100-1070901-113270-773630 10100-2010210-132300-773630 10100-2010210-125000-773630 10100-2010201-180000-773630 10100-2010401-172190-773630 10100-2010210-125000-773630 10100-2010301-185010-773630 10100-2010501-125000-773630 10100-2010210-125000-773630 10100-2010205-132305-773630 10100-1070401-113000-773630 10100-1010201-181010-773630 10100-1010210-182090-773630 10100-1010501-181020-773630 10100-3010401-121220-773630 10100-3010403-121100-773630 10100-3010403-121240-773630 10100-1010101-181000-773630 10100-3010201-121110-773630 10100-3010301-121130-773630 10100-3010301-121180-773630 10100-3010101-121100-773630 10100-1090101-171000-773630 10100-1020501-173010-773630 10100-1020601-182020-773630 10100-1060601-115090-773630 DIVISION 52/1 - District Court 52/2 - District Court 52/3 - District Court 52/4 - District Court Animal Control Bd of Commissioners Circuit Court Probation North Clerk's - County Clerk Clerk E-Services Clerk/Reg - Admin Clerk Register Admin Clerk. Reg - EDMS (Imaging) Clerk/Reg - Elections Clerk/Reg - Jury Commission Clerk/Reg - Legal Records Clerk/Reg - Vital Statistics Community Corrections Admin Compliance Office - Auditing Compliance Office - Purchasing Corporation Counsel CTS-Fam Div-Judicial Support CTS-FD-Judicial Support-ADM CTS-FD-Juvenile Support County Executive Courts-Business Division Courts-GJ-Judicial Support Courts-GJ-Jury Operations Courts - Judical /Administration Economic Development & Community Affairs Equalization Division Fiscal Services -Admin Homeland Security 4th Quarter Jul - Sep $3,069.70 $3,069.70 $3,069.70 $3,068.90 $14,349.41 $6,030.75 $0.00 $5,720.53 $190.00 $0.00 $0.00 $4,202.79 $12,094.78 $0.00 $57,425.75 $12,097.91 $13,579.61 $486.25 $14,246.00 $20,978.00 $0.00 $23.16 $0.00 $73.50 $0.00 $114,538.47 $129.95 $37,992.62 $1,323.00 $69,633.20 $79,908.66 $13,628.75 Y.T.D. $15,636.60 $15,636.60 $15,636.60 $15,633.45 $110,529.49 $46,009.50 $62.00 $6,896.80 $2,635.00 $0.00 $6,281,81 $76,198.71 $24,087.70 $0,00 $180,134.25 $59,885.98 $97,662.04 $1,697.25 $33,566.75 $35,259.00 $0,00 $285.99 $0.00 $551.25 $0.00 $535,624.53 $867.55 $131,265.22 $4,233.50 $289,316.63 $424,536,60 $64,005.00 Page 1 of 19 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2018 4th Quarter CUST FUND# ACCOUNT DIVISION Jul-Sep Y.T.D. 680 101 10100-1050401-183010-773630 907 101 10100-5010303-165040-773630 824 101 10100-5010302-165020-773630 565 101 10100-1090108-171030-773630 872 101 10100-1070601-132030-773630 296 101 10100-1070501-174000-773630 710 101 10100-1070501-174000-773630 163 101 101 00-4030901-1 15140-773630 775 101 10100-1090201-171000-773630 4'79 101 10100-3040101-121090-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 348 101 10100-4030301-112620-773630 988 101 10100-4030901-116240-773630 647 101 10100-4030601-110000-773630 206 101 10100-4030901-110040-773630 445 101 10100-1030803-184025-773630 600 101 10100-7010101-186040-773630 627 101 10100-7010110-186130-773630 910 101 10100-1070301-132050-773630 730 101 101 00-60101 01-155010-773630 742 101 101 00-601 0101-149920-773630 301 101 101 00-601 0101-174250-773630 Health Fund [2211 840 221 20221-1060201-133150-773630 843 221 20221-1060220-134390-773630 Human Resources Library - Library Admin Library Services Marketing & Communcations Medical Examiner MSU - Digital Media Services MSU Extension - Oakland OCSO - CLEMIS Forensic Lab IMS Planning & Economic Development Probate FD Judicial Support 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 Sheriff - Corrective Serv Admin Sheriff - IFS Div Lab Sheriff - Patrol Serv - LE Admin Sheriff - LE Support- Serv Admin Support Services Treasurer Treasurers - Landsale Veterans Services Water Resource Commissioner WRC - CAMS Software Support & Maintenance WRC - Soil Erosion Software Sol Sub-Total Fund 101 Health Health Environmental Page 2 of 19 $30,908.80 $1,989.75 $0.00 $3,538.25 $7,332.16 $0.00 $73.50 $0.00 $27,041.50 $4,349.75 $3,221.13 $11,009.41 $220.50 $11,350.68 $0.00 $4,346.75 $80,323.72 $6,462.45 $0.00 $977.00 $1,428.00 $0.00 $10,252.26 $91,475.21 $0.00 $927,75 $71,614.66 $4,065.50 §4,388.50 $868,228.32 $46,090.00 $77,094.41 $175,270.57 $3,487.75 $13,977.50 $12,337.25 $37,624.99 $2,742.75 $110.25 $3,139.90 $96,601.50 $5,988.50 $8,150.46 $32,895.99 $220.50 $53,368.88 $2,793.00 $18,995.00 $276,025.71 $38,678.05 $0.00 $8,178.75 $13,390.75 $294.00 $26,803.85 $322,377.43 $3,198.50 $4,886.25 $277,711.99 $5,724.50 $10,275.31 $3,649,385.68 $178,175.12 $236,720.04 $0.00 $16,270.25 $400.00 $783.50 $0.00 $26,265.96 $0.00 $40,645.50 $130,449.75 $0.00 $2,465.10 $2,036.25 $927.00 $1,060.00 $0.00 $0.00 $120,166.50 $560.00 $21,732.25 $0.00 $92,862.35 $0.00 $101,189.83 $404,375.50 $0.00 $6,254.43 $5,032.75 $6,705.00 $1,180.00 $0.00 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2018 4th Quarter CUST FUND# ACCOUNT DIVISION Jul - Sep 183 221 20221-1060201-133150-773630 Health Website Redesign $845.25 $1,617.00 Sub-Total Fund 221 $124,029.66 $416,512.16 Juvenile Maintenance Fund 1.2931 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: $36,158.75 $161,533.75 $0.00 $0.00 $36,158.75 $161,533.75 $1,028,416.73 $4,227,431.59 $1,028,416.73 $4,227,431.59 ($1,028.416.73) (S4.227.431.59) $0.00 $0,00 274 672 935 944 669 055 699 448 056 749 720 659 521 937 471 NON-GOVERNMENTAL DIRECT CHARGES ASAP Passport System Assessment & Tax Augusta SAW Grant CAMP CTA DR Equipment CAMS/CVT Data Conversion CLEMIS CLEMIS - CAD CLEMIS/FRMS NON-BILLABLE CLEMIS FUND 63500 Clerk/Reg - CPL Clerk/Reg - Register Of Deeds Collaborative Asset Mgt Sys (CAMS) Community Corrections - Admin (Grant) COSDS SAW Grant Courts-FCC Exp-CS Enforcement - EDMS (Imaging) Page 3 of 19 4th Quarter Jul-Sep $14,482.38 $0.00 $120.00 $0.00 $0.00 $29,425.41 $41,068.91 $0.00 $12,245.00 $7,137.48 $0.00 $0.00 $142,192.00 $46,499.75 $68,253.25 $71.25 $0.00 $0.00 $16,193.75 $250.25 $0.00 $20,204.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5,819.25 $0.00 $0.00 $0.00 $0.00 Y.T.D. $42,022.21 $0.00 $360.00 $0.00 $0.00 $31,391.24 $224,344.74 $0.00 $12,245.00 $18,154.11 $0.00 $0.00 $548,474.25 $46,499.75 $350,898.00 $401.25 $1,926,75 $0.00 $50,491.00 $3,858.00 $0.00 $69,289.25 $0.00 $260.00 $0.00 $0.00 $0.00 $0.00 $0.00 $41,767.25 $0.00 $0.00 $0.00 $0.00 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2018 DIVISION Courts-FOC Exp-CS Enforcement Cyber Security Fund Drain Equipment Fund Drain Equip Map EDCA - MITradeSchool.org Grant Fire Records Management System FM&O FM8,0 Building Maintenance FM&O Building Maintenance System FOC Security Audit Franklin SAW Grant Health Immunization Grant HIPAA Enhancements II HR-Financial System Replacement Imaging Project IT Telephone Communications Leasetrack OakVideo Upgrade (Building Authority) OAKWIN Radio System Enhancement O.C. International Airport OLV SDS SAW Grant Parks and Recreation - Administration P&R Capital Improvement P&R EMS Upgrade P&R Lyon Oaks Conf Ctr CIP#2469 P&R Lyon Oaks Conf Ctr CIP#2468 P&R Springfield Oaks CIP#2471 P&R Springfield Oaks CIP#2470 P&R Red Oaks Clubhouse CIP#2467 Pontiac - Meter Pontiac - Water Pontiac - Sewer Pontiac Water Asset Mgmt Pontiac VVVVTP Transaction Page 4 of 19 CUST FUND# ACCOUNT 507 673 931 933 837 210 750 756 133 963 942 380 947 120 338 751 185 634 938 653 934 770 867 925 442 443 454 456 457 268 747 748 936 329 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2018 DIVISION Public Health Grant 795 Radio Communications - E911 Risk Management Tax Management System UCC Program II Water Resources Accounting VVinCan Central Storage Solution Water and Sewer-General Adm Water and Sewer General Administration Water and Sewer Gen Adnnin-WMU Workforce Dev Division VVRC Acctg - Crowder Prjct VVRC Aeration Tank Rehab WRC - CAMP WRC CLINTON-OAKLAND SCADA WRC CLINTON-OAK SDS SCADA Main WRC WRC - SAW ACACIA VVRC - SAW Birmingham VVRC - SAW Commerce Township WRC - SAW Evergreen Farmington VVRC - SAW Lake Orion WRC - SAW Novi WRC - SAW Orchard Lake WRC - SAW Grant Labor WRC SAW GWK WRC AGO WRC AMR Support WRC Bingham Farms SAW WRC - COSDA Meter Replacement WRC - CO SDS SewMet WRC - EF SDS SewMet WRC - Data Application Pilot Poject WRC - GIS Allocation by Labor 4th Quarter Jul-Sep $0.00 $4,105.00 $110,25 $30,838.25 $25,515.25 $307.70 $0.00 $467.50 $2,646.00 $0.00 $294.00 $0.00 $7,345.00 $1,485.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 $36.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Y.T.D. $13,260,00 $39,100.75 $183.75 $85,305.00 $97,439.50 $6,583.55 $0.00 $5,781.00 $5,242.75 $112.00 $294.00 $0.00 $13,830.50 $3,578.25 $800.00 $0.00 $0.00 $3,107.00 $360.00 $0.00 $3,948.75 $2,676.25 $4,565.50 $148.75 $0.00 $0.00 $2,020.00 $701.00 $2,461.00 $0.00 $0.00 $0.00 $0.00 $0.00 CUST FUND# ACCOUNT 906 791 695 638 973 656 736 930 939 974 850 670 929 940 926 932 281 377 382 379 387 389 388 386 674 381 895 734 980 745 728 729 737 300 Page 5 of 19 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2018 63600-1080101-152000-631302 DIVISION WRC - GWK PCF-WRC SCADA WRC - HACH VVIMS Implementation VVRC - HACH WIMS Implementation Phase II WRC - Hydro Drain Project WRC - Infrastructure Op Ar VVRC - MISS DIG Ticket Mgmt Sys WRC Oxford Twp SAW WRC Permitting Implementation WRC Royal Oak Twp SAW WRC - SAW Grant Labor - Common to All WRC SAW Huron Rouge WRC SAW Bloomfield Village WRC - SCADA Common WRC - SCADA Engineering Assessment WRC - SCADA Maintenance 4th Quarter Jul - Sep $0.00 $0.00 $17,526.00 $0.00 $0,00 $0.00 $0.00 $29,940.08 $0.00 $640.00 $0.00 $3,080.00 $0.00 $0.00 $55.00 Y.T.D. $0.00 $0.00 $35,709.25 $0.00 $0.00 $0.00 $2,520.25 $45,192.34 $160.00 $12,049.50 $2,383.75 $3,720.00 $0.00 $0.00 $4,037.25 CUST FUND# 277 295 894 733 671 299 981 979 986 686 402 403 739 738 358 ACCOUNT SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $749,708.27 $2,599,713.05 TOTAL COUNTY DEVELOPMENT CHARGES $1,778,125.00 $6,827,144.64 NON-COUNTY AGENCIES 63600-1080101-152000-635017 Non-County Agencies $7,395.25 $23,918.00 Page 6 of 19 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2018 24017 SQL Server Supp -Animal Control 95628 Animal Control 95682 Dog System Animal Control-Total 91404 BOC - Customer Support Ed of Commissioners - Total 95655 Childrens Village Childrens Village - Total 97658 Childrens Village Admin Childrens Village Admin - Total 72500 Clerk -Admin Clerk/Reg - Admin - Total 71800 E-Services E-Services - Total 95443 Cleric/Reg - Elections Division Clerk/Reg - Elections Division - Total 95158 Clerk/Reg - EDMS Spt/Maintenance/Upgrades 13001 Clerk's - Efiling Clerk/Reg - EDMS (Imaging) - Total 95512 Clerk/Reg -Jury Commission Clerk! Rag -Jury Commission - Total 95189 Clerk Legal Records Clerk! Reg - Legal Records - Total 95291 Clerk Register of Deeds Clerk Register of Deeds - Total 24015 SQL Server Supp - Vital Stets 3.5% 95161 Clerk/Reg - Vital Statistics Clerk - Vital Statistics - Total 95184 Clerk's - County Clerk Clerk's - County Cleric - Total 23003 Oracle Support-Comm Corr - 5.2% 24012 SQL Server Supp - Community Corr 3.5% 52200 Comm Corr-Adrnin (County) 52201 Comm Corr - DVV Support 4th Qtr 2018 $23.16 $960.00 $13,366.25 $6,030.75 $36.158.75 $0.00 $0.00 $190.00 $12,094,78 $0.00 $57,425.75 $0.00 $23.16 $12,074.75 $5,720.53 $129.95 $23.16 $13,426,50 $0.00 Cust t/ GOVERNMENTAL FUNDS 530 ANIMAL CONTROL DIV 005 BD OF COMMISSIONERS 665 CHILDRENS VILLAGE 668 CHILDREN'S VILLAGE ADMIN 725 CLERFUREG ADMIN 718 CLERFUREG - E-SERVICES 440 CLERK/REG -ELECTIONS DIVISION 722 CLERK/REG - EDMS (IMAGING) 410 CLERK/REG -JURY COMMISSION 724 CLERIUREG - LEGAL RECORDS 291 CLERK REGISTER OF DEEDS ADMIN 723 CLERK/REG - VITAL STATISTICS 184 CLERK'S -COUNTY CLERK 522 COMM CORR-ADMIN (COUNTY} $3,681.28 $521.51 $14,349.41 $6,030.75 $36,158.75 $0.00 $0.00 $190.00 $12,094.78 $4,202.79 $0.00 $57,425.75 $0.00 $12,097.91 $5,720.53 Page 7 of 19 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2018 Gust # GOVERNMENTAL FUNDS 4th Qtr 2018 Community Corrections - Total $13.579,61 620 COMPLIANCE OFFICE - AUDITING 44034 Auditing - New Development 95468 Auditing Intmal Svc Compliance Office - Auditing - Total $0.00 $486.25 $486.25 690 COMPLIANCE OFFICE - PURCHASING 44028 Pur-System Enhancements 44029 Pur-New Development Compliance Office - Purchasing - Total $14,024.00 $222.00 $14,246.00 $20,978.00 $73.50 $0.00 434 CORPORATION COUNSEL 95501 Corporation Counsel Corporation Counsel - Total 95656 County Executive Support County Executive - Total 80204 Circuit Court Probation - North Circuit Court Probation - North - Total $20,978.00 015 COUNTY EXECUTIVE $73.50 450 CRC CT PROBATION - NORTH $0.00 495 CTS-BUSINESS DIVISION 12002 CCT-Courts1Criminal 23010 Oracle Support-CCT/CTS Crim Whse 2.6% CTS-Business Division - Total $0.00 $0.00 $0.00 506 CTS-FAM DIV-JUDICIAL SUPPT 95187 CTS-Fam Div-Judicial Support CTS-Fam Div-Judicial Support- Total $0.00 $0.00 483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5% CTS-FD-Judicial So pport-Adm - Total $23.16 $23.16 482 CTS-FD JUVENILE SUPPORT 48200 CTS-Jud Support - Juv Support CTS-Jud Support - Juv Support- Total $0.00 $0.00 498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS-Gen Juris-Judicial Suppt 23010 Oracle Supp-CCT/CTS CTS-Gen Juris-Judicial Suppt - Total $114,473.50 $64.97 $114,538.47 502 CTS-GJ-JURY OPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operations CTS-GJ-Jury Operations - Total $129.95 $129.95 493 CTS-JUDICIAL ADMIN 13002 49300 95174 Court's - Et-Fling Courts Web Redesign CTS-Judicial Admin CTS-Judicial Adrnin - Total $521.49 $33,569.25 $3,901.88 $37,992.62 785 ECON DEV & COMM AFFAIRS 36540 GIS Implementation Support C&E Dev 36501 CED Application - H/W Support 95785 Comm & Eco Developmt Econ Dev & Comm Affairs - Total $1,323.00 $0.00 $0.00 $1,323.00 Page 8 of 19 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2018 23012 Oracle Support-Equalization - 5.2% 24005 SQL Serv Supp-Equalization - 10.5% 31075 Equal - Development 36506 GIS Implementation Support Equalization 36506 Equal Application/HW Support 36507 Equal Lams Su pport/M 36601 Land System Enhancements - Equal (50%) 36701 Land System Maintenance - Equal (50%) 36801 Land System Support - Equal (50%) 36902 BS&A Orion Twp 50101 EQUAL (BS&A ANNUAL) 95562 Equalization - DW Support 95693 Equalization - System Maintenance 95699 BS&A Master Appraisal Sup/Maint Equalization - Total 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 44022 FS - System Maintenance 44023 FS - System Enhancements 44024 FS - New Development 44602 Bond Disclosure - Fiscal (50%) 96001 Fiscal Serv -Acctg 40% 96003 Fiscal Serv - Budget 20% Fiscal Services Admin - Total 36525 GIS Implementation Support Health 95563 User Support/Health 95842 Health -Admin Health - Total 23005 Oracle Support - EH Projects - 5.2% 24014 SQL Server Suppt - Ehealth 14% 84200 PH-Projects 84300 Ehealth Program Health-Environmental - Total 96183 Health Website Redesign Health Website Redesign - Total 36545 GIS Implementation Support Homeland Security 36546 Homeland Security Application - H/VV Support 98990 Homeland Security Homeland Security - Total Cust# GOVERNMENTAL FUNDS 740 EQUALIZATION 660 FISCAL SERVICES - GEN FUND 840 HEALTH DIVISION 843 HEALTH - ENVIRONMENTAL 183 HEALTH WEBSITE REDESIGN 900 HOMELAND SECURITY (HSD) 4th Qtr 2018 $129.95 $69.47 $21,009,50 $257.25 $13,997.25 $4,971.75 $7,044.24 $1,081.38 $2,853.50 $0.00 $349.16 $0.00 $0.00 $17.869,75 $69,633.20 $389.83 $129.95 $11.58 $31,094.75 $6,907.75 $0.00 $55.50 $0.00 $27,546.20 $13,773.10 679,908.66 $0,00 $33,720.25 $12369.75 $46,090.00 6129.96 $92.61 $56,675.88 $20 195.97 $77,094.41 $845.25 $845.25 6330.75 $5,526,75 $7 771 25 $13,628.75 Page 9 of 19 4th Qtr 2018 $129.95 $11.58 $0.00 $30 767 27 $1,989.75 $0.00 $3.538.25 $73.50 $977.00 $0.00 $27,041.50 $3,221.13 $23.16 $10,986.25 $220.50 $4.349.75 $23.16 $7,372.25 $3,955.27 $0.00 $30,908.80 $1,989.75 $0.00 $3,538.25 $7,332.16 $73.50 $977.00 $0.00 $27,041.50 $3,221.13 $11,009.41 $220.50 $4,349.75 $23.16 $7 309 00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2018 oust # GOVERNMENTAL FUNDS 680 HUMAN RESOURCES 907 LIBRARY - LIBRARY AMIN 824 LIBRARY SERVICES 565 MARKETING & COMMUNICATIONS 872 MEDICAL EXAMINER 710 MSU EXTENSION -OAKLAND 988 OC SHERIFF'S - IFS DIV - LAB 163 OCSO-CLEMIS FORENSIC LAB IMS 776 PLANNING & EGO DEVELOPMENT 512 PROB-ESTATES/MENTL HLTH EDMS (IMG) 510 PROB-ESTATES/MENTL HLTH SUPPORT 481 PROB-FD JUDICIAL 479 PROB-FD JUDICIAL SUPPORT 145 PROSECUTOR - GENERAL PROSECUTION 23014 Oracle Support-HR-Personnel - 5.2% 24007 SQL Server Supp-HR-Personnel - 1.75% 44044 HR- New Development 96002 Human Res-Personnel 40% Human Resources - Total 91405 Library Board Library - Library Admin - Total 61001 Library Services Library Services - Total 58500 Marketing & Communications Marketing & Communications - Total 24002 SQL Server Support - Medical Exam - 3.5% 87202 Med Exam - Oust Supt Medical Examiner - Total 95676 MSU Ext Equipment Maintenance MSU Extension - Oakland - Total 16300 OCSO CLEMIS Forensic OCSO CLEMIS Forensic - Total 16300 OCSO-CLEMIS Forensic Lab OGSO-CLEMIS Forensic Lab IMS - Total 95600 PEDS Gust/System Support Planning & Eco Development - Total 95207 PC-E/MH EDMS Support & Mice Prob-EsVMntl Hlth EDMS (img) - Total 24010 SQL Serv Supp-PCT-Est/Mental - 3.5% 92198 PC-E/MH Support-Dev Prob-Est/Mnt11-1Ith Support- Total 95168 PC-Judicial Family Admin-Family Judges Prob - FD Judicial - Total 95188 PC-Judicial Adm-Fam PC-Judicial Adrn-Fam - Total 24015 SQL Server Supp - Proescutors 3.5% 95622 Prosecutor/Executive 95664 Prosecutor Warrants 97001 Prosecutor Data Proc Page 10 of 19 $4,346.75 $0.00 $0.00 $64.97 $3,438.50 $0.00 $0.00 $77.220.25 $129.95 $6,332.50 $0.00 1,428.00 $129.95 $446.31 510.076.00 $129.95 $259.91 $4.00 $7,044.01 $1,081.37 $2,853.50 $55,382.88 $483.75 $5,758.00 $0.00 $0.00 $0.00 $0.00 $349.09 $1,476.00 $4,346.75 $80,323.72 $6,462.45 $0.00 $1,428,00 $10,252.26 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2018 cust# GOVERNMENTAL FUNDS 4th Qtr 2018 Prosecutor - Total $11,350.68 637 RECORDS RETENTION 44453 REC - System Enhancements $0.00 Records Retention - Total $0.00 95470 Reim System 95542 Reimburse User Support Reimbursement Total 12001 OCSD-Courts/Criminal - 50% 23009 Oracle Suppport - OCSD/CTS Crim VVhse - 2.6% 97163 OCSD-Corrective Serv 97164 Sheriff - Development 97165 Sheriff-DVV Support 98164 CLEMIS-Sheriff Sheriff - Total 23015 Oracle Suppport - Sheriff! CLEMIS - 5.2% 96163 Sheriff - CLEMIS Sheriff - CLEMIS - Total 34800 Inmate Phone System Sheriff - Corrective Serv Adrnin - Total 97647 Sheriff - Patrol Serv Admin Sheriff - Patrol Serv Admin - Total 23002 Oracle Support - Supp Serv - 5.2% 24011 SQL Server Su pp - Suppt Services 7% 44500 Support Services Use Support Services - Total 23006 Oracle Support - Del Tax - 5.2% 23016 Oracle Support - Treasurer -10.4% 36516 Treasurer ApplIcation HNV Support 36602 Land System Enhancements - Trees (50%) 36702 Land System Maintenance - Trees (50%) 36802 Land System Support - Treas (50%) 44061 Tre-System/Costomer Support 44062 Tre-System Maintenance 44063 Tre-System Enhancements 44064 Tre-New Development 44084 Tre-DVV Support 44082 Tre-DVV Maintenance 44601 Bond Disclosure-Tress (50%) 50102 Trees (BS&A Annual 95008 Del Tax On Line 654 REIMBURSEMENT DIV 195 SHERIFF 191 SHERIFF - CLEWS 348 SHERIFF - CORRECTIVE SERV ADMIN 647 OCSD PATROL SERV AMIN 445 SUPPORT SERVICES ADMIN 600 TREASURERS OFFICE Page 11 of 19 97274 ASAP Passport System ASAP Passport System - Total 67200 Assessment & Tax Assessment & Tax Total 60.00 $16,270.25 $0.00 $16,270.25 37935 Augusta SAW Grant $400.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER 2018 cust# GOVERNMENTAL FUNDS 4th Qtr 2018 95303 Del Tax System Maintenance $367.50 95561 User Support/Del Tax $16,2139.25 95615 I3S&A Annual Tax Support $0.00 Treasurer - Total $91,475.21 627 TREASURER - LANE/SALE 44083 Treasurer-Landsale $0.00 Treasurer -Landsale - Total 60.00 910 VETERANS SERVICES 95651 Veterans Customer Support $672.25 95650 Veterans Services-Eq $55.50 Veterans Services - Total $927.75 730 WATER RESOURCE COMMISSION 742 WRC CAMS SOFTWARE SUPP & MAINT 301 WRC - SOIL EROSION SOFTWARE SOL 540 5211 - NOVI 550 52/2 CLARKSTON 560 5213 ROCHESTER 530 52/4 TROY cust # DIRECT FUNDS 274 ASAP PASSPORT SYSTEM 672 ASSESSMENT & TAX 935 AUGUSTA SAW GRANT 24008 SQL Server Supp - WRC 3.5% 28010 WRC-Customer Suppt 26011 VVRC Custom Applicaton 36520 GIS Implementation Support VVRC 36521 WRC Program Support Water Resource Commissioner - Total 74200 VVRC CAMS SOFTWARE Support WRC CAMS SOFTWARE Supp & Maint - Total 74301 VVRC - Soil Erosion Software Sol VVRC - Soil Erosion Software $ol - Total 95527 Dist Ct Supp - 25% 52/1 District Court - Total 95528 Dist Ct Supp - 25% 52/2 District Court - Total 95266 52 Dist Ct Div 3 95529 Dist Ct Supp - 25% 5213 District Court - Total 95530 Dist Ct Supp - 25% 52/4 District Court Total $23.16 $14,050.00 $24,041.00 $1,272,00 $32,228.50 $71,614.66 4 065.50 $4,065.50 4 388 50 $3,069/0 $4,388.50 $3,069.70 $3,069.70 61,828,416.73 63,069.70 $0,00 $3.069.70 $3,069.70 $3,068.90 $3,068.90 Page 12 of 19 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2018 Gust # GOVERNMENTAL FUNDS 944 CAMP CTA DR EQUIPMENT 055 CLEMIS 699 CLEM - CAD 056 CLEMIS FUND 63500 448 GLEmis/FRms NON-BILLABLE 669 CAmS/CvT DATA CONVERSION 749 CLERK/REG - CPL 720 cLERK/REG - ROD 669 COLLABORATIVE ASSET MGT SYS 937 COSDS SAW GRANT 471 CTS-F0C-EXP-CS ENFORC-Eoms (imG) 507 CTS-FOC EXP-CS ENFORCEMENT 4th Car 2018 Augusta SAW Grant - Total 37944 Camp CTA DR Equipment $783.50 Camp CTA DR Equipment - Total 23004 Oracle Support - QakVideo CLEmiS 5.2% $129,95 23018 Oracle Support - Sheriff CLEMIS 5.2% $129.93 24004 SQL Server Support - 24.5% $162.08 95430 CLEMIS Maintenance $17787.00 95431 CLMS Enhancements $73.50 98003 CLEMIS User Support 51,809.50 98005 CLEMIS E911 Support $0.00 98000 Poject Team $6.174.00 CLEM'S - Total 98006 CLEMIS - CAD Development $0.00 CLEMIS - CAD - Total 63500 CLEWS Fund $130.449.75 GLEAMS 63500 Fund - Total 44800 CLEMB/FRMS NON-BILL $40.645.50 CLEMIS/FRMS NON-BILL - Total 66901 CAMS/CVT Data Conversion $0.00 CAMS/CVT Data Conversion - Total 74900 Clerk/Reg - CPL $0.00 ClerkJReg - CPL - Total 24003 SQL Server Supp - ROD 3.5% $23.16 36510 GIS Implementation Support $0,00 36511 ROD Apprcation/HW Support $1,580.25 95493 ROD System Maintenance $0.00 95496 Clerk/Reg - ROD $661.69 Clerk/Reg - ROD - Total 65901 Collabortive Asset Mgt Sys $2.086.25 Collabortive Asset Mgt Sys - Total 37937 COSDS SAW Grant $1.060.00 COSDS SAW Grant Total 92194 CTS-FOC-CS ENF-EDMS Support/Maintenance/Upgrades $0.00 CTS-FOC Exp-CS Enforc-EDMS (Wig) - Total 92193 CTS-FOC-CS Enforc-Dev $11,261.25 Page 13 of 19 $400.00 $783.50 $26,265.96 $0.00 $130,449.75 $40,645.50 $0.00 $0.00 $2,465.10 $2,086.25 $1,060.00 $0.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2018 Cust # GOVERNMENTAL FUNDS 521 COMM CORR - ADM (GRANT) 673 CYBER SECURITY FUND 931 DRAIN EQUIPMENT FUND 933 DRAIN EQUIP MAP 837 EDCA - MITRADESCHOOL.ORG GRANT 210 FIRE RECORDS MANAGEMENT SYSTEM 750 FM&O 756 FM&O BUILDING MAINTENANCE 133 FM&O BUILDING MAINTENANCE SYSTEM 963 FOC SECURITY AUDIT 942 FRANKLIN SAW GRANT 380 HEALTH-IMMUNIZATION GRANT 947 H1PAA ENHANCEMENTS 11 120 HR-FINANCIAL SYSTEM REPLACEMENT 92194 CTS-FOC-CS Enf-EDMS CTS-FOC Exp-CD Enforc-Dev - Total 52100 Comm Corr Admin - GR Comm Corr - Ad m (Grant) - Total 67300 Cyber Security Fund Cyber Security Fund - Total 37931 Drain Equipment Fund Drain Equipment Fund - Total 37933 Drain Equip Map Drain Equip Map - Total 83700 EDCA - MITRADESCHOOL EDCA - MITradeSchool.org Grant - Total 21010 Fire Records Mgmt Fund 531 95404 FIRMS - Phase 11 Proj 24001 SQL Serv Supp-Fire R Fire Records Management System - Total 21001 Fac Maint & Oper 24013 SQL Server Supp FM&O 75503 FM0 Development FM8.0 - Total 75600 FM&O Building Maintenance FM&D Building Maintenance - Total 21133 FM&O Building Maintenance System FM&O Building Maintenance System-Total 34963 FOG Security Audit FOE Security Audit - Total 37942 Franklin SAW Grant Franklin SAW Grant - Total 38000 Health-Immunization Grant Health-Immunization Grant - Total 96947 HIPAA Enhancements II - Total HIPAA Enhancements 11- Total 44120 HR-Financial System Replacement HR-Financial System Replacement - Total 4th Qtr 2018 $3.221.13 $927.00 $0.00 $120.00 $0.00 $0.00 $0.00 $29,402.25 $23.16 $2,351.25 $23.16 $38,694.50 $0.00 $12,245.00 $7 137 48 $0.00 $0.00 $142,192.00 $46.499.75 $14,482.38 $927.00 $0.00 $120.00 $0.00 $0.00 $29,425.41 $41,068.91 $0.00 $12,245.00 $7,137.48 $0.00 $0.00 $142,192.00 $46,499.75 Page 14 of 19 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2018 cust* GOVERNMENTAL FUNDS 338 IMAGING PROGRAM 751 IT - TELEPHONE COMM 634 OAKVIDEO UPGRADE (13A1 33800 Imaging Project Imaging Project Total 75102 Tel Comm - Customer ET- Telephone Comm - Total 63400 CLEMFS - OakVideo Upgrade 63401 IT - OakVideo Upgrade OakVideo Upgrade (BA) - Total 4th Qtr 2018 $68,253.25 $71.25 $0,00 $0.00 $68,253.25 $71.25 $0.00 938 OAKWIN RADIO SYSTEM ENH 98938 OAKVVIN Radio System Enh OAKVV1N Radio System Enh - Total $16,193.75 $16,193.75 653 O.C. INTN'L AIRPORT 36540 GIS Implementation Support 65301 Airport User Support O.C. EntnE Airport - Total $0,00 $260.25 $250.25 934 OLV SOS SAW GRANT 37934 OLV SDS SAW Grant $0.00 OLV SDS SAW Grant - Total $0.00 770 PARKS AND RECREATION 867 P&R CAPITAL IMPROVEMENT 925 P&R EMS UPGRADE 442 P&R LYON OAKS CONF CTR CIP#2469 443 P&R LYON OAKS CONF CTR CIP#2468 454 P&R SPRINGFIELD OAKS CIP#2471 456 P&R SPRINGFIELD OAKS CIP#2470 36530 GIS Implementation Support - Parks 44066 PRADM-Systern/Customer Support 440613 PRADM-System Enhancements 76100 P&R Administrative Services 95413 PRADM-Customer Support 95416 PRRA - Reo Admin 95419 PRADM-Admintstration Parks & Recreation - Total 86700 P&R Capital Improvement P&R Capital Improvement- Total 37925 P&R EMS Upgrade P&R EMS Upgrade Total 44200 P&R Lyon Oaks Conf Ctr CIP #2469 P&R Lyon Oaks Conf Ctr CIP #2469 - Total 44300 P&R Lyon Oaks Conf CTR CIP#2468 P&R Lyon Oaks Conf CTR CIP#2468 - Total 45400 P&R Springfield Oaks CIP#2471 P&R Springfield Oaks CIP#2471 - Total $36.75 $4,384.50 $2,656.75 $0.00 $11,876.50 $1,249.50 $0,00 $20,204.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0,00 45600 P&R Springfield Oaks CIP#2470 $0.00 P&R Springfield Oaks CIP#2470 - Total $0.00 Page 15 of 19 4th Qtr 2018 80.00 $5,819.25 $0.00 $0.00 $0.00 $0.00 $4,105.00 $110.25 $30,838.25 $25,515.25 $129.95 $177.75 $0.00 $0.00 $5,819.25 $0.00 $0.00 $0.00 $0.00 $4,105.00 $110.25 $30,838.25 $25,515,25 $307.70 $467.50 $2 646.00 $294.00 $0.00 $467.50 $2,646.00 $294.00 INFORMATION TECHNOLOGY RESERVE FUND DEVELOPMENT I SUPPORT DETAIL - FOURTH QUARTER 2018 45700 P&R Red Oaks Clubhouse CIP#2467 P&R Red Oaks Clubhouse CIP#2467 - Total 74268 Pontiac Meter Pontiac Meter-Total 74701 Pontiac BSA to WRC - Water Pontiac Water - Total 74702 Pontiac BSA to WRC - Sewer Pontiac Sewer Total 37936 Pontiac Water Asset Mgmt Pontiac Water Asset Mgmt - Total 67329 Pontiac VVVVTP Transaction Pontiac VVVVTP Transaction - Total 79101 Radio Communications - E911 Radio Communications - E911 - Total 44036 Rsk-System/Customer Support Risk Management - Total 63800 Tax Management System Tax Management System - Total 92973 UCC Program II UCC Program II - Total 23011 Oracle Supp - Water & Sewer Acct'g - 5.2% 95669 Water Resources Acct 95671 Drain Water/Sewer BI Water Resources Accounting - Total cust# GOVERNMENTAL FUNDS 457 P&R RED OAKS CLUBHOUSE CIP#2497 268 PONTIAC METER 747 PONTIAC WATER 748 PONTIAC SEWER 936 PONTIAC WATER ASSET MGMT 329 PONTIAC WWTP TRANSACTION 791 RADIO COMMUNICATIONS E911 695 RISK MANAGEMENT 638 TAX MANAGEMENT SYSTEM 973 UCC PROGRAM II 656 WATER RESOURCES ACCTG 736 VVINCAN CENTRAL STORAGE SOLUTION 73601 VVinCan Central Storage Solution WinCan Central Storage Solution - Total $0.00, $0.00 930 WATER AND SEWER-GENERAL ADMIN 939 WATER AND SEWER GENERAL ADMINISTRATION 37930 Water and Sewer-General Admin Water and Sewer-General Admin Total 37939 Water and Sewer General Administration Water and Sewer General Administration - Total 850 WORKFORCE DEV DIVISION 95670 Workforce Development Workforce Development- Total 670 WRC ACCTG - CROWDER PRJCT 60001 VVRC - Crowder NetBase Project Page 16 of 19 4th Qtr 2018 $0.00 $7,345.00 $29,940.08 $3.080.00 $55.00 $1.485.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7,345.00 $29,940.08 $3,080.00 $55.00 $1,485.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.04 $0,00 $0.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER 2018 67000 WRC - Crowder NetBase Project VVRC Acotg - Crowder Prject - Total 35700 VVRC Aeration Tank Rehab WRC Aeration Tank Rehab - Total 74979 VVRC Permitting Implementation VVRC Permitting Implementation - Total 33403 VVRC - SAW Bloomfield Village WRC - SAW Bloomfield Village - Total 33358 WRC - SCADA Maintenance VVRC - SCADA Maintenance - Total 37940 WRC - Camp WRC - Camp - Total 33926 VVRC Clinton-Oakland SCADA WRC Clinton-Oakland SCADA - Total 37932 WRC Clinton-Oak SDS SCADA Main WRC Clinton-Oak SDS SCADA Main - Total 74281 VVRC VvRC - Total 28674 WRC - SAW Acacia WRC - SAW ACaCia Total 33382 VVRC SAW Birmingham VVRC SAW Birmingham - Total 33379 WRC - SAW Commerce Township VVRC - SAW Commerce Township - Total 33386 WRC - SAW Orchard Lake WRC - SAW Orchard Lake - Total 28674 WRC - SAW Grant Labor WRC - SAW Grant Labor - Total 33381 vvRC SAW GVVK WRC SAW GVVK - Total Cust# GOVERNMENTAL FUNDS 929 WRC AERATION TANK REHAB 979 WRC PERMIN111NG IMPLEMENTATION 403 WRC - SAW BLOOMFIELD VILLAGE 358 WRC - SCADA MAINTENANCE 940 WRC - CAMP 926 WRC CLINTON-OAKLAND SCADA 932 WRC CLINTON-OAK SDS SCADA MAIN 281 WRC 377 WRC - SAW ACACIA 382 WRC SAW BIRMINGHAM 379 WRC - SAW COMMERCE TOWNSHIP 386 WRC - SAW ORCHARD LAKE 674 WRC - SAW GRANT LABOR 381 WRC SAW GWK 586 WRC - SAW GRANT LABOR - COMMON TO ALL 60002 WRC - SAW Grant Labor - Common to All 12686 VVRC - SAW Grant Common to All WIC - SAW Grant Labor Common to All- Total Moo $640.00 $640.00 Page 17 of 19 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT! SUPPORT DETAIL - FOURTH QUARTER 2018 Oust # GOVERNMENTAL FUNDS 4th Qtr 2018 734 WRC - AMR SUPPORT 73401 WRC - AMR Support $36.75 WRC - AMR Support - Total $36.75 745 WRC - COSDA METER REPLACEMENT 74500 VVRC - CODSA Meter Replacement WRC - CODSA Meter Replacement - Total $0.00 $0.00 728 WRC - CO SOS SEWMET 72201 MARS Enhancements - WRC C-0 VVRC - CO SDS SewMet - Total $0.00 $0.00 729 VVRC EF SOS SEWMET 72202 MARS Enhancements - VVRC E-F WIRC EF SDS SewMet - Total $0.00 $0.00 737 VVRC - DATA APPLICATION PILOT PRJ 73700 WRC - Data Application Pilot Project $0.00 73710 WRC - Data Appl Prj $0.00 VVRC - Data Application Pilot Prj - Total $0.00 300 WRC-GIS ALLOCATION BY LABOR 73300 VVRC-GIS Allocation by Labor VVRC-GIS Allocation by Labor - Total 0.00 $0.00 277 WRC-GWK PCF-WRC SCADA 74277 VVRC GVVK PCF-WRC SCADA WRC - GVVK PC F-WRC SCADA - Total $0.00 295 VVRC MACH WIMS IMPLEMENTATION 894 WRC - HACH WIMS IMPLEMENTATION 733 WRC-HYDRO DRAIN PROJECT 671 WRC - INFRASTRUCTURE OP AR 299 WRC-MISS DIG TICKET MGIVIT SYS 739 WRC - SCADA COMMON 738 WRC - SCADA ENGINEERING ASSESSMT 67295 WRC-HACH WIMS Implementation VVRC-HACH WIMS Implementation - Total 37894 VVRC-HACH VVIMS Implementation VVRC-HACI-f NMS Implementation - Total 73301 VVRC-Hydro Drain Project WRC-Hydra Drain Project-Total 87100 VVRC -10 AR VVIRC - Infrastructure Op Ar - Total 74299 VVRC-MISS Dig Ticket Mgmt Sys WRC-MISS Dig Ticket Mg mt Sys - Total 73900 WRC - SCADA Common WRC - SCADA Common - Total 73800 WRC - SCADA Engineering Assesmnt VVRC - SCADA Engineering Assesmt - Total 0.00 17 526 00 0.00 $0.40 $0.00 $0.00 $0.00 $0.00 $0,00 $17,526.00 $0.00 $0.00 $0.00 $0.00 $0.00 $749,708.27 Page 18 of 10 INFORMATION TECHNOLOGY DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2018 4th Quarter Y.T.D. $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $350,735.25 $1,191,664.05 $19,117.00 $73,304.50 $1,746.75 $46,821.50 $53,518.50 $277,906.75 $633,832.00 $2,360,286.10 $0.00 $0.00 $0.00 $0.00 $1,058,948.50 $3,949,982.90 $56,210.00 $258.597.75 $56,210.00 $258,597.76 $173,233.25 $460,650.75 129.95 $867.55 $29.99 $200.17 $13.11 $161.99 $2,976.75 $15,189.75 $0.00 $49,667.00 $51,796.75 $234,771.25 $0.00 $0.00 $228,179.80 $761,508.46 $1,343,338.30 $4,970,089.11 Radio 18020 IT Radio CUST FUND ACCOUN Application Services 17040 IT - TOS Fund 18000 IMACS Data Warehouse (Funded) 19000 IT Application Services Planned Maint 30001 IT Application Services Data Warehouse 30002 IT Application Services Enhanced 30003 IT Application Services GIS 30004 IT Application Services eGovernment 25108 Courts - Oakland Schools 36901 BS&A Orion Twp - IT App Services - Sub Total: Internal Services 19020 Internal Services Planned Main Internal Services - Sub-Total: Technical Sys/Networking 19030 Tech Sys/Net Planned Maint 23007 Oracle Support - IT Tech Systems 23017 Oracle Support - IT Tech Systems 1.2% 24018 SQL Serv Support - IT Tech Systems 2% 25400 Oracle Administration 95685 I.T. - Disaster Recovery 95750 I.T. - SEP 95755 I.T. - PeopleSoft Upgrade Tech Sys/Net - Sub-Total: Information Technology - Total: Page 19 of 19 Resolution #18374 November 14, 2018 Moved by Crawford supported by Quarles the resolutions (with fiscal notes attached) on the Consent Agenda be adopted (with accompanying reports being accepted). AYES: Crawford, Fleming, Gershenson, Gingell, Hoffman, Jackson, Kochenderfer, KowaII, Long, McGillivray, Middleton, Quarles, Taub, Tietz, Weipert, Woodward, Zack, Berman, Bowman. (19) 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). 1 HEREBY APPROVE THIS RESOLUTUA CHIEF DEPUTY COUNTY EXECul ACTING PURSUANT TO MCI 45.559A (7,1 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 November 14, 2018, with the original record thereof now remaining in my office. In Testimony Whereof, l have hereunto set my hand and affixed the seal of the County of Oakland at Pontiac, Michigan this 14th day of November, 2018. Lisa Brown, Oakland County