Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Resolutions - 2026.05.21 - 42941
AGENDA ITEM: 2026 Second Quarter Information Technology Development Report DEPARTMENT: Information Technology MEETING: Board of Commissioners DATE: Thursday, May 21, 2026 9:30 AM - Click to View Agenda ITEM SUMMARY SHEET COMMITTEE REPORT TO BOARD Resolution #2026-6509 Motion to approve the 2026 Second Quarter appropriation transfer as specified on the attached schedule and that the respective departmental Fiscal Year 2026 budgets are to be amended as specified in the attached detailed schedule. ITEM CATEGORY SPONSORED BY Budget Amendment Gwen Markham INTRODUCTION AND BACKGROUND 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 the Department of Information Technology has determined the Second Quarter 2026 development charges to be $1,714,626.52 for the General Fund/General Purpose County departments; and direct charges to Special Revenue and Proprietary fund departments are $1,052,471.04 and non-county agencies are $5,120.00 for the Second Quarter 2026; and an appropriation transfer to General Fund/General Purpose County departments is needed to fund these development charges. FISCAL IMPACT: Committee members can contact Barbara Winter, Policy and Fiscal Analysis Supervisor at 248.821.3065 or winterb@oakgov.com or the department contact persons listed for additional information. CONTACT Rod Davenport, Chief Information Officer Kimberly Arango, Application & Client Services Director ITEM REVIEW TRACKING Aaron Snover, Board of Commissioners Created/Initiated - 5/21/2026 AGENDA DEADLINE: 05/07/2026 4:30 PM ATTACHMENTS 1. IT Development Summary - 2nd Quarter 2026 COMMITTEE TRACKING 2026-05-13 Finance - Recommend to Board 2026-05-21 Full Board - Adopt Motioned by: Commissioner Michael Gingell Seconded by: Commissioner Penny Luebs Yes: Ann Erickson Gault, Michael Gingell, Marcia Gershenson, Robert Hoffman, Karen Joliat, Christine Long, Penny Luebs, Gwen Markham, William Miller III, Kristen Nelson, Angela Powell, Robert Smiley, Yolanda Smith Charles, Michael Spisz, Linnie Taylor, Philip Weipert, David Woodward (17) No: Charles Cavell (1) Abstain: None (0) Absent: Brendan Johnson (1) Passed 2nd Quarter CUST FUND#ACCOUNT DIVISION Jan - Mar Y.T.D. GOVERNMENTAL FUNDS General Fund [101] 540 101 CCN3020201-PRG121020-FND10100-SC773630 52/1 - District Court $7,474.57 $18,981.36 550 101 CCN3020301-PRG121020-FND10100-SC773630 52/2 - District Court $7,474.57 $18,981.36 560 101 CCN3020401-PRG121020-FND10100-SC773630 52/3 - District Court $7,474.57 $18,981.36 530 101 CCN3020501-PRG121020-FND10100-SC773630 52/4 - District Court $7,474.29 $18,980.67 630 101 CCN1070801-PRG114000-FND10100-SC773630 Animal Control $69,248.48 $153,226.25 005 101 CCN5010101-PRG180010-FND10100-SC773630 Bd of Commissioners $141.25 $2,330.25 722 101 CCN2010210-PRG125000-FND10100-SC773630 Clerk/Reg - EDMS (Imaging)$29,366.92 $48,787.24 440 101 CCN2010301-PRG185010-FND10100-SC773630 Clerk/Reg - Elections $2,442.00 $8,212.25 724 101 CCN2010210-PRG125000-FND10100-SC773630 Clerk/Reg - Legal Records $87,692.00 $189,552.25 720 101 CCN2010401-PRG172190-FND10100-SC773630 Clerk/Reg - ROD $4,562.00 $15,158.02 723 101 CCN2010205-PRG132305-FND10100-SC773630 Clerk/Reg - Vital Statistics $34,485.48 $63,635.50 522 101 CCN1070401-PRG113000-FND10100-SC773630 Pretrial and Justices Services $26,875.39 $39,236.59 361 101 CCN1210101-PRG181000-FND10100-SC773630 Communications Department - Dev $58,479.50 $87,981.75 430 101 CCN1010501-PRG181020-FND10100-SC773630 Corporation Counsel $1,126.88 $1,927.71 483 101 CCN3010403-PRG121100-FND10100-SC773630 CTS-FD-Judicial Support-ADM $51.98 $141.50 015 101 CCN1010101-PRG181000-FND10100-SC773630 County Executive $6,422.25 $6,807.25 498 101 CCN3010301-PRG121130-FND10100-SC773630 Courts-GJ-Judicial Support $166,593.96 $325,737.30 502 101 CCN3010301-PRG121180-FND10100-SC773630 Courts-GJ-Jury Operations $473.16 $694.59 493 101 CCN3010101-PRG121100-FND10100-SC773630 Courts - Judical / Administration $25,696.17 $42,689.10 346 101 CCN1210101-PRG181000-FND10100-SC773630 Department of Public Communication $14.44 $5,012.75 778 101 CCN1090206-PRG171000-FND10100-SC773630 Economic Dev & Comm Affairs $0.00 $41.25 785 101 CCN1090101-PRG171000-FND10100-SC773630 Economic Development & Community Affairs $10,595.25 $14,266.50 011 101 CCN1110102-PRG145000-FND10100-SC773630 Emergency Management $13,194.25 $59,461.50 258 101 CCN1040101-PRG140015-FND10100-SC773630 Env Sustainability - Initiatives $262.50 $262.50 740 101 CCN1020501-PRG173010-FND10100-SC773630 Equalization Division $218,299.65 $486,402.97 062 101 CCN1011001-PRG181000-FND10100-SC773630 Exec Ofc - Performance Mgmt $1,190.00 $1,190.00 660 101 CCN1020601-PRG182020-FND10100-SC773630 Fiscal Services-Gen Fund $85,322.79 $187,573.03 900 101 CCN1110101-PRG115090-FND10100-SC773630 Emergency Mgmt/Homeland Security $17,036.25 $31,367.75 735 101 CCN6010101-PRG155060-FND10100-SC773630 General Fund Map $660.00 $1,320.00 562 101 CCN1060101-PRG133300-FND10100-SC773630 Human Services - HS Admin Serv $16,541.25 $27,761.25 412 101 CCN1050101-PRG183010-FND10100-SC773630 Human Resources Admin $0.00 $4,859.95 680 101 CCN1050401-PRG183010-FND10100-SC773630 Human Resources $60,434.49 $122,575.47 690 101 CCN1020301-PRG182090-FND10100-SC773630 Management & Budget - Purchasing $38,715.00 $58,533.75 872 101 CCN1070601-PRG132030-FND10100-SC773630 Medical Examiner $2,890.98 $3,723.00 409 101 CCN1010702-PRG121170-FND10100-SC773630 MIDC OCIT Maint & Suppt ($8,328.50)$3,853.00 349 101 CCN4030501-PRG112680-FND10100-SC773630 OCSD Admin Serv-Records Unit $0.00 $41.25 647 101 CCN4030601-PRG110000-FND10100-SC773630 OCSD Patrol Serv Admin $6.19 $65.55 775 101 CCN1090201-PRG171000-FND10100-SC773630 Planning & Economic Development $13,695.11 $18,457.43 INFORMATION TECHNOLOG DEVELOPMENT SUMMARY SECOND QUARTER 2026 Prepared by: Information Technology; 05/05/2026 Page 1 of 13 2nd Quarter 2026.pdf 2nd Quarter CUST FUND# ACCOUNT DIVISION Jan - Mar Y.T.D. INFORMATION TECHNOLOG DEVELOPMENT SUMMARY SECOND QUARTER 2026 512 101 CCN3040403-PRG124010-FND10100-SC773630 Probate-Estates/Mental Health - EDMS (Imaging)$25,696.17 $42,689.10 510 101 CCN3040403-PRG124010-FND10100-SC773630 Probate-Estates/Mental Health Support $39,989.48 $87,242.50 509 101 CCN3040101-PRG121080-FND10100-SC773630 Probate-Judicial Admin $0.00 $41.25 145 101 CCN4010101-PRG122050-FND10100-SC773630 Prosecuting Attorney - General Prosecution $28,669.48 $52,432.36 717 101 CCN4010201-PRG122090-FND10100-SC773630 Prosecuting Attorney - Tranquility AI for the Prosecutor $3,275.00 $4,182.50 650 101 CCN1020650-PRG126020-FND10100-SC773630 Reimbursement Division $15,241.50 $18,136.75 195 101 CCN4030301-PRG112590-FND10100-SC773630 OCSD-Corrective Serv - Admin $183,140.71 $350,272.80 191 101 CCN4030601-PRG110000-FND10100-SC773630 Sheriff - CLEMIS $1,515.91 $8,532.59 348 101 CCN4030301-PRG112620-FND10100-SC773630 Sheriff - Corrective Serv Admin $10,292.75 $27,398.25 445 101 CCN1030803-PRG184025-FND10100-SC773630 Support Services $228.36 $587.57 600 101 CCN7010101-PRG186040-FND10100-SC773630 Treasurer - Admin $145,548.11 $288,381.98 978 101 CCN7010101-PRG186050-FND10100-SC773630 Treasurers - DelTax $23,782.75 $41,608.75 458 101 CCN7010101-PRG186090-FND10100-SC773630 Treasurer - Disbursing $3,330.00 $9,760.00 169 101 CCN7010101-PRG186080-FND10100-SC773630 Treasurer - General Acctg $5,488.75 $9,777.50 488 101 CCN7010101-PRG186100-FND10100-SC773630 Treasurer - Investments $0.00 $1,815.00 910 101 CCN1090401-PRG132050-FND10100-SC773630 Veterans Services $178.75 $178.75 730 101 CCN6010101-PRG155010-FND10100-SC773630 Water Resource Commissioner $33,677.98 $90,097.00 Sub-Total Fund 101 $1,534,140.77 $3,121,945.85 Health Fund [101] 840 101 CCN1060201-PRG133150-FND10100-SC773630 Health $14,629.38 $28,374.61 852 101 CCN1060211-PRG133150-FND10100-SC773630 Health Central Support $715.00 $1,199.25 843 101 CCN1060220-PRG134390-FND10100-SC773630 Health Environmental $117,890.48 $191,547.14 Sub-Total Fund 101 $133,234.86 $221,121.00 Juvenile Maintenance Fund [293] 665 293 CCN1070901-PRG112090-FND20293-SC773630 Children's Village $47,250.89 $107,175.48 Sub-Total Fund 293 $47,250.89 $107,175.48 CCN1080101-PRG152000-FND63600-SC631365 DEVELOPMENT FOR GOVERNMENTAL FUND $1,714,626.52 $3,450,242.33 APPROPRIATION SUB-TOTAL GOVERNMENTAL DEVELOPMENT APPROPRIATION: $1,714,626.52 $3,450,242.33 CCN9090101-PRG196030-FND10100-SC773630 Information Technology Development ($1,714,626.52)($3,450,242.33) TOTAL GOVERNMENTAL:$0.00 $0.00 NON-GOVERNMENTAL DIRECT CHARGESPrepared by: Information Technology; 05/05/2026 Page 2 of 13 2nd Quarter 2026.pdf 2nd Quarter CUST FUND# ACCOUNT DIVISION Jan - Mar Y.T.D. INFORMATION TECHNOLOG DEVELOPMENT SUMMARY SECOND QUARTER 2026 911 CCN6010101-PRG149669-FND63900-SC773630 AIO Replacement Project $21,797.75 $35,293.00 672 CCN9016001-PRG152130-FND42060-SC773630 Assesment & Tax $45,734.00 $90,717.50 944 CCN6010101-PRG149669-FND63900-SC773630 CAMP CTA DR Equipment $0.00 $206.25 902 CCN1080305-PRG116020-FND53500-SC773630 CLEMIS DEVELOPMENT $48,330.89 $108,461.34 056 CCN1080305-PRG116020-FND53500-SC773630 CLEMIS FUND 63500 $57,121.00 $147,902.25 087 CCN6010101-PRG149030-FND57341-SC773630 Commerce Twp WWTP $0.00 $448.50 061 CCN6010101-PRG149999-FND57341-SC773630 Commerce Services Sewer $129.00 $0.00 036 CCN6010101-PRG149999-FND57241-SC773630 Commerce Services Water $129.00 $129.00 044 CCN9016011-PRG152130-FND42115-SC773630 Courts CMS Project $88,190.50 $145,941.75 507 CCN3010404-PRG126030-FND27100-SC773630 Courts-FOC Exp-CS Enforcement $83,556.42 $129,719.85 933 CCN6010101-PRG155060-FND63900-SC773630 Drain Equip Map $0.00 $660.00 210 CCN1080325-PRG115100-FND53100-SC773630 Fire Records Management System $5,239.98 $20,553.50 750 CCN1040701-PRG140101-FND63100-SC773630 FM&O $22,009.34 $58,495.27 053 CCN1040701-PRG140101-FND63100-SC773630 PRJ-18032 2026 FMO Asset Mgmt $36,464.50 $58,883.50 963 CCN3010404-PRG126030-FND27100-SC773630 FOC Security Audit $0.00 $644.14 880 CCN5060201-PRG160900-FND50800-SC773630 Glen Oak Capital Work $1,278.75 $1,278.75 038 CCN6010101-PRG149820-FND63900-SC773630 HACH WIMS Software Support $41.25 $866.25 227 CCN1060201-PRG133150-FND11007-SC773630 Health Social Care $10,158.25 $27,427.00 120 CCN9016001-PRG152130-FND42100-SC773630 HR-Financial System Replacement $14,163.00 $22,923.00 338 CCN9016001-PRG152130-FND42080-SC773630 Imaging Project $33,518.00 $164,440.25 751 CCN1080601-PRG152070-FND67500-SC773630 IT Telephone Communications $22,282.75 $44,953.50 303 CCN9010101-PRG133095-FND21285-SC773630 GRN-1004256 IT ARP Funding $259,873.25 $433,653.50 548 CCN9016001-PRG152130-FND42105-SC773630 ITIM Program $162,007.25 $321,959.00 360 CCN1010702-PRG121170-FND20260-SC773630 GRN-1004647 MIDC Application Maint & Supp $18,205.50 $18,205.50 443 CCN6010101-PRG115020-FND25211-SC773630 Paint Creek Drain CH $0.00 $705.00 770 CCN5060101-PRG160000-FND50800-SC773630 Parks and Recreation - Administration $11,261.25 $22,110.00 733 CCN5080101-PRG160000-FND50800-SC773630 Parks & Rec - Time Tracking $650.00 $650.00 762 CCN5060172-PRG160010-FND50800-SC773630 P&R Glen Oaks Golf Course $123.75 $123.75 763 CCN5060174-PRG160010-FND50800-SC773630 P&R Lyon Oaks Golf Course $123.75 $123.75 790 CCN1080310-PRG115150-FND53600-SC776360 Radio Communications $20,344.50 $42,991.50 791 CCN1080310-PRG115060-FND53500-SC773630 Radio Communications - E911 $28,144.75 $59,740.00 695 CCN1010502-PRG182000-FND67700-SC773630 Risk Management $5,010.50 $5,738.00 656 CCN6010101-PRG149030-FND57010-SC773630 Water Resources Accounting $289.41 $1,047.09 930 CCN6010101-PRG149000-FND57010-SC773630 Water and Sewer-General Adm $776.00 $1,810.00 736 CCN6010101-PRG149130-FND57010-SC773630 Wincan Central Storage Solution $495.00 $1,335.00 212 CCN1090701-PRG170010-FND11004-SC776360 GRN-1004517 Workforce Dev - Clean Slate Proj $288.75 $288.75 344 CCN6010101-PRG149130-FND57010-SC773630 WRC Administration $2,123.25 $4,968.75 049 CCN6010101-PRG149999-FND57010-SC773630 WRC Cross Connection Control $12,024.00 $24,457.00 442 CCN6010101-PRG149130-FND82912-SC773630 WRC - OMID - Workday Reports $2,100.00 $2,100.00 501 CCN6010101-PRG149820-FND63900-SC773630 WRC Permitting Impl $1,443.75 $2,970.00Prepared by: Information Technology; 05/05/2026 Page 3 of 13 2nd Quarter 2026.pdf 2nd Quarter CUST FUND# ACCOUNT DIVISION Jan - Mar Y.T.D. INFORMATION TECHNOLOG DEVELOPMENT SUMMARY SECOND QUARTER 2026 979 CCN6010101-PRG149820-FND63900-SC773630 WRC Permitting Impl $826.00 $826.00 122 CCN6010101-PRG149300-FND57010-SC773630 WRC Reserve Water $11,934.92 $19,645.87 358 CCN6010101-PRG149870-FND63900-SC773630 WRC - SCADA Maintenance $288.75 $412.50 293 CCN6010101-PRG149290-FND57010-SC773630 WRC - Water Fund $11,935.08 $19,646.13 067 CCN6010101-PRG149999-FND57010-SC773630 WRC Utility Billing Replacement $1,853.50 $2,253.50 701 CCN6010101-PRG149999-FND57010-SC773630 WRC Miss Dig Management Sys IM $10,203.75 $16,362.00 CCN1080101-PRG152000-FND63600-SC631302 SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $1,052,471.04 $2,064,196.19 TOTAL COUNTY DEVELOPMENT CHARGES $2,767,097.56 $5,514,438.52 NON-COUNTY AGENCIES CCN1080101-PRG152000-FND63600-RC635017 Non-County Agencies $5,120.00 $8,570.25 Prepared by: Information Technology; 05/05/2026 Page 4 of 13 2nd Quarter 2026.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2026 Cust #GOVERNMENTAL FUNDS 2nd Qtr 2026 630 ANIMAL CONTROL 24017 SQL Server Supp - Animal Control $51.98 95628 Animal Control $243.75 95682 Dog System $68,952.75 Animal Control - Total $69,248.48 005 BD OF COMMISSIONERS 91404 BOC - Customer Support $141.25 Bd of Commissioners - Total $141.25 665 CHILDRENS VILLAGE 53001 Childrens Village - 65%$7,096.39 95665 Childrens Village $40,154.50 Childrens Village - Total $47,250.89 440 CLERK/REG - ELECTIONS DIVISION 95443 Clerk/Reg - Elections Division $2,442.00 Clerk/Reg - Elections Division - Total $2,442.00 722 CLERK/REG - EDMS (IMAGING)95158 Clerk/Reg - EDMS Support/Maintenance/Upgrades $29,366.92 Clerk/Reg - EDMS (Imaging) - Total $29,366.92 724 CLERK/REG - LEGAL RECORDS 95189 Circuit Court System $87,692.00 Clerk/Reg - Legal Records - Total $87,692.00 720 CLERK / REGISTER OF DEEDS 36511 ROD Application - H/W Support $288.75 95493 ROD System Maintenance $1,301.25 95498 Clerk/Reg - ROD $2,972.00 Clerk/Reg of Deeds - Total $4,562.00 723 CLERK - VITAL STATISTICS 24015 SQL Server Supp - Vital Stats 3.5%$51.98 95161 Clerk.Reg - Vital Statistics $34,433.50 Clerk - Vital Statistics - Total $34,485.48 361 COMMUNICATIONS DEPARTMENT - DEV 95361 Communications Department - Dev $58,479.50 Communications Department - Dev - Total $58,479.50 522 COMMUNITY CORRECTIONS-ADMIN (CO)23003 Oracle Support-Comm Corr - 5.2%$124.41 24012 SQL Server Supp - Community Corr 3.5%$51.98 52200 Comm Corr-Admin (County)$26,699.00 Community Corrections - Total $26,875.39 430 CORPORATION COUNSEL 95501 Corporation Counsel $1,122.75 42001 Corporation Counsel $4.13 Corporation Counsel - Total $1,126.88 015 COUNTY EXECUTIVE 95656 County Executive Support $6,422.25 County Executive - Total $6,422.25 483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5%$51.98 Prepared by: Information Technology; 05/05/2026 Page 5 of 13 2nd Quarter 2026.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2026 CTS-FD-Judicial Support-Adm - Total .$51.98 498 CTS-GEN JURIS-JUDICIAL SUPPT 23010 Oracle Supp-CCT/CTS $62.21 95179 CTS-Gen Juris-Judicial Suppt $166,531.75 CTS-Gen Juris-Judicial Suppt - Total $166,593.96 502 CTS-GJ-JURY OPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operations $124.41 95183 CTS-GJ-Jury Operations $348.75 CTS-GJ-Jury Operations - Total $473.16 493 CTS-JUDICIAL ADMIN 95174 CTS-Judicial Admin $25,696.17 CTS-Judicial Admin - Total $25,696.17 346 DEPARTMENT OF PUBLIC COMMUNICATIONS 42002 DPC - 35%$14.44 Department of Public Communication - Total $14.44 785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 95785 Comm & Eco Developmt $10,595.25 Economic Development & Community Affairs - Total $10,595.25 740 EQUALIZATION 23012 Oracle Support-Equalization - 5.2%$124.41 24005 SQL Server Supp-Equalization - 10.5%$155.93 31075 Equal - Development $40,048.25 36505 GIS Implementation Support Equalization $4,758.75 36506 Equal Application - H/W Support $19,282.25 36507 Equal LAMS Support $33,821.50 36601 Land System Enhancements - Equal (50%)$13,588.53 36801 Land System Support - Equal (50%)$25,899.63 50101 EQUAL (BS&A ANNUAL)$1,180.65 95699 BS&A Master Appraisal Sup/Maint $79,439.75 Equalization - Total $218,299.65 011 EMERGENCY MANAGEMENT 95011 Emergency Management $13,194.25 Emergency Management - Total $13,194.25 258 ENV SUSTAINABILITY-INITIATIVES 90258 ENV Sustainability-Initiatives $262.50 ENV Sustainability-Initiatives - Total $262.50 062 EXEC OFC-PERFORMANCE MGMT 95062 EXEC - OFC Performance $1,190.00 EXEC - OFC Performance - Total $1,190.00 660 FISCAL SERVICES ADMIN 23001 Oracle Support - Fiscal Serv - 15.6%$373.23 23013 Oracle Support - HR-Acctg/Budget - 5.2%$124.41 24006 SQL Serv Supp - HR-Acctg - 1.75%$26.00 44021 FS-System/Customer Support $31,716.25 96001 Fiscal Serv - Acctg 40%$35,788.60 96003 Fiscal Serv - Budget 20%$17,294.30 Fiscal Services Admin - Total $85,322.79 Prepared by: Information Technology; 05/05/2026 Page 6 of 13 2nd Quarter 2026.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2026 735 GENERAL FUND MAP 74735 General Fund Map $660.00 General Fund Map - Total $660.00 840 HEALTH DIVISION 42003 Health - 30%$12.38 95563 User Support-Health $8,813.00 96842 Health Admin $5,804.00 Health - Total $14,629.38 852 HEALTH CENTRAL SUPPORT 95856 Health Central Support $715.00 Health Central Support - Total $715.00 843 HEALTH - ENVIRONMENTAL 23005 Oracle Support - EH Projects - 5.2%$124.41 24014 SQL Server Suppt - Ehealth 14%$207.90 84200 EH - Projects $59,028.17 84300 Ehealth Program $58,530.00 Health-Environmental - Total $117,890.48 900 EMERGENCY MGMT/HOMELAND SECURITY 36545 GIS Implementation Support Homeland Security $371.25 36546 Homeland Security Application - H/W Support $16,665.00 Homeland Security - Total $17,036.25 680 HUMAN RESOURCES 23014 Oracle Support-HR/Personnel - 5.2%$124.41 24007 SQL Server Suppport-HR/Personnel - 1.75%$26.00 96002 Human Res-Personnel 40%$60,284.08 Human Resources - Total $60,434.49 562 HUMAN SERVICES - HS ADMIN SERV 96561 Human Services - HS Admin Serv $16,541.25 Human Services - HS Admin Serv - Total $16,541.25 690 MANAGEMENT & BUDGET - PURCHASING 44028 PUR-System Enhancement $5,935.00 95663 Purchasing Internal $32,780.00 PUR-System Enhancement - Total $38,715.00 872 MEDICAL EXAMINER 24002 SQL Server Support - Medical Exam - 3.5%$51.98 87202 Medical Examiner - Customer Support $2,839.00 Medical Examiner - Total $2,890.98 409 MIDC OCIT MAINT/SUPP 67409 MIDC OCIT Maint/Supp -$8,328.50 MIDC OCIT Maint/Supp - Total -$8,328.50 349 OCSO ADMIN SERV - RECORDS MGMT 97349 OCSO Admin Serv - Records Mgmt $0.00 OCSO Admin Serv - Records Mgmt - Total $0.00 647 OCSD PATROL SERV ADMIN 42004 Sheriff - 15%$6.19 OCSO Patrol Serv Admin - Total $6.19 775 PLANNING & ECO DEVELOPMENT 95600 PEDS Cust/System Support $13,691.00 42005 Planning & Eco Development $4.11 Prepared by: Information Technology; 05/05/2026 Page 7 of 13 2nd Quarter 2026.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2026 Planning & Eco Development - Total $13,695.11 512 PROB-ESTATES/MENTL HLTH EDMS (IMG)95207 PC-E/MH EDMS Support & Mtce $25,696.17 Prob-Est/Mntl Hlth EDMS (Img) - Total $25,696.17 510 PROB-ESTATES/MENTL HLTH SUPPORT 24010 SQL Serv Supp-PCT-Est/Mental - 3.5%$51.98 92198 Prob-Est/Mntl Hlth Support $39,937.50 Prob-Est/Mntl Hlth Support - Total $39,989.48 145 PROSECUTOR - GENERAL PROSECUTION 24016 SQL Server Supp - Proescutors 3.5%$51.98 95622 Prosecutor/Executive $28,617.50 Prosecutor - Total $28,669.48 717 PROSECUTING ATTORNEY - TRANQUILITY AI FOR THE PROSECUTOR 97717 Prosecuting Attorney $3,275.00 Prosecuting Attorney - Total $3,275.00 650 REIMBURSEMENT 95470 Reimbursement System $476.50 95542 Reimburse User Support $14,765.00 Reimbursement - Total $15,241.50 195 SHERIFF 23009 Oracle Suppport - OCSD/CTS Crim Whse - 2.6%$62.21 97163 Sheriff $12,270.75 98164 CLEMIS-Sheriff $170,807.75 Sheriff - Total $183,140.71 191 SHERIFF - CLEMIS 23015 Oracle Suppport - Sheriff / CLEMIS - 5.2%$124.41 96163 Sheriff - CLEMIS $1,391.50 Sheriff - CLEMIS - Total $1,515.91 348 SHERIFF - CORRECTIVE SERV ADMIN 34800 Inmate Phone System $10,292.75 Sheriff - Corrective Serv Admin - Total $10,292.75 445 SUPPORT SERVICES 23002 Oracle Support - Supp Serv - 5.2%$124.41 24011 SQL Server Supp - Suppt Services 7%$103.95 Support Services - Total $228.36 600 TREASURER - ADMIN 36602 Land System Enhancements - Treas (50%)$13,588.47 36802 Land System Support - Treas (50%)$25,899.62 44062 Tre-System Maintenance $2,280.75 44063 Tre-System Enhancements $246.25 44601 Bond Disclosure - Treas (50%)$27,164.17 50102 TREAS (BS&A) ANNUAL $1,180.60 95615 BS&A Annual Tax Support $75,188.25 Treasurer - Total $145,548.11 978 TREASURERS - DELTAX 95978 Treasurers - DELTAX $23,782.75 Treasurers - DELTAX - Total $23,782.75 Prepared by: Information Technology; 05/05/2026 Page 8 of 13 2nd Quarter 2026.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2026 458 TREASURER - DISBURSING 95458 Treasurer - Disbursing $3,330.00 Treasurer - Disbursing - Total $3,330.00 169 TREASURERS - GENERAL ACCTG 96169 Treasurer - General ACCTG $5,488.75 Treasurer - General ACCTG - Total $5,488.75 910 VETERANS SERVICES 95651 Veterans Customer Support $178.75 Veterans Services - Total $178.75 730 WATER RESOURCE COMMISSIONER 24008 SQL Server Supp - WRC 3.5%$51.98 28007 Water Resource Commission $16,887.00 28010 WRC - Customer Support $13,357.50 36520 GIS Implementation Support WRC $3,381.50 Water Resource Commissioner - Total $33,677.98 540 52/1 DISTRICT COURT - NOVI 95527 DC Suprt- 52/1 - 25%$7,474.57 52/1 District Court - Total $7,474.57 550 52/2 DISTRICT COURT - CLARKSTON 95528 DC Suprt- 52/2 - 25%$7,474.57 52/2 District Court - Total $7,474.57 560 52/3 DISTRICT COURT - ROCHESTER 95288 52 Dist Ct Div 3 95529 DC Suprt - 52/3 - 25% $7,474.57 52/3 District Court - Total $7,474.57 530 52/4 DISTRICT COURT - TROY 95530 DC Suprt- 52/4 - 25%$7,474.29 52/4 District Court - Total $7,474.29 Cust #DIRECT FUNDS 911 AIO REPLACEMENT PROJECT 74911 AIO Replacement Project $21,797.75 AIO Replacement Project - Total $21,797.75 672 ASSESSMENT & TAX 67200 Assessment & Tax $45,734.00 Assessment & Tax - Total $45,734.00 902 CLEMIS 23004 Oracle Support - OakVideo CLEMIS 5.2%$124.41 23018 Oracle Support - Sheriff CLEMIS 5.2%$124.40 24004 SQL Server Support - 24.5%$363.83 95430 CLEMIS Maintenance $18,760.50 98003 CLEMIS User Support $147.25 98005 CLEMIS - E911 Support $28,810.50 CLEMIS - Total $48,330.89 056 CLEMIS FUND 63500 63500 CLEMIS Fund $57,121.00 CLEMIS 63500 Fund - Total $57,121.00 061 COMMERCE SERVICES SEWER 33061 Commerce Services Sewer $129.00 Prepared by: Information Technology; 05/05/2026 Page 9 of 13 2nd Quarter 2026.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2026 Commerce Services Sewer - Total $129.00 036 COMMERCE SERVICES WATER 33036 Commerce Services Water $129.00 Commerce Services Water - Total $129.00 044 COURTS CMS PROJECT 95044 Courts CMS Project $88,190.50 Courts CMS Project - Total $88,190.50 507 CTS-FOC EXP-CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforc-Dev $57,860.25 92194 CTS-FOC-CS ENF-EDMS $25,696.17 CTS-FOC Exp-CD Enforc-Dev - Total $83,556.42 933 DRAIN EQUIP MAP 37933 Drain Equip Map $0.00 Drain Equip Map - Total $0.00 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $5,188.00 95404 SQL Server Support - FRMS 3.5%$0.00 24001 FRMS - Phase II Proj $51.98 Fire Records Management System - Total $5,239.98 750 FM&O 21001 Facilities Maintenance & Operations $0.00 24013 SQL Server Supp - FM&O $51.98 75503 FM&O Development $18,136.25 53002 Facilities - 35%$3,821.11 FM&O - Total $22,009.34 946 FMO BMS PH 6 41946 FMO BMS PH 6 $0.00 FMO BMS PH 6 - Total $0.00 053 2026 FMO ASSET MGMT 75053 2026 FMO Asset Mgmt $36,464.50 2026 FMO Asset Mgmt - Total $36,464.50 963 FOC SECURITY AUDIT 34963 FOC Security Audit $0.00 FOC Security Audit - Total $0.00 880 GLEN OAKS CAPITAL WORK 76880 Glen Oaks Capital Work $1,278.75 Glen Oaks Capital Work - Total $1,278.75 038 HACH WIMS SOFTWARE SUPPORT 74038 HACH WIMS Software Support $41.25 HACH WIMS Software Support - Total $41.25 227 HEALTH SOCIAL CARE 96227 Health Social Care $10,158.25 Health Social Care - Total $10,158.25 120 HR-FINANCIAL SYS REP 44120 HR-Financial System Replacement $14,163.00 HR-Financial System Replacement - Total $14,163.00 338 IMAGING PROJECT 33800 Imaging Project $33,518.00 Prepared by: Information Technology; 05/05/2026 Page 10 of 13 2nd Quarter 2026.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2026 Imaging Project - Total $33,518.00 303 IT ARP FUNDING 17303 IT ARP Funding $259,873.25 IT ARP Funding - Total $259,873.25 548 ITIM PROGRAM 97548 ITIM Program $162,007.25 ITIM Program - Total $162,007.25 751 IT - TELEPHONE COMMUNICATIONS 75102 Telephone Communications - Customer Support $22,282.75 IT - Telephone Communications - Total $22,282.75 360 MIDC APPLICATION MAINT & SUPPORT 67360 MIDC Application Maint & Support $18,205.50 MIDC Application Maint & Support - Total $18,205.50 770 PARKS AND RECREATION 76100 P&R Administrative Services $371.25 95413 PRADM-Customer Support $10,890.00 Parks & Recreation - Total $11,261.25 762 P&R GLEN OAKS GOLF COURSE 76200 P&R Glen Oaks Golf Course $123.75 P&R Glen Oaks Golf Course - Total $123.75 763 P&R LYON OAKS GOLF COURSE 76300 P&R Lyon Oaks Golf Course $123.75 P&R Lyon Oaks Golf Course - Total $123.75 733 PARKS & REC - TIME TRACKING 76733 Parks & Rec - Time Tracking $650.00 Parks & Rec - Time Tracking - TOTAL $650.00 790 RADIO COMMUNICATIONS 79001 Radio Communications $20,344.50 Radio Communications - Total $20,344.50 791 RADIO COMMUNICATIONS - E911 79101 Radio Communications - E911 $28,144.75 Radio Communications - E911 - Total $28,144.75 695 RISK MANAGEMENT 44036 Rsk-System Customer Support $618.75 95695 Risk Management $4,391.75 Risk Management - Total $5,010.50 656 WATER RESOURCES ACCOUNTING 23011 Oracle Supp - Water & Sewer Acct'g - 5.2%$124.41 95669 Water Resources Accounting $165.00 Water Resources Accounting - Total $289.41 930 WATER AND SEWER-GENERAL ADMIN 37930 Water and Sewer-General Admin $776.00 Water and Sewer-General Admin - Total $776.00 736 WINCAN CENTRAL STORAGE SOLUTION 73601 Wincan Central Storage $495.00 Wincan Central Storage - Total $495.00 212 WORKFORCE DEV-CLEAN SLATE PROJ 95212 Workforce Dev-Clean Slate Proj $288.75 Prepared by: Information Technology; 05/05/2026 Page 11 of 13 2nd Quarter 2026.pdf INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2026 Workforce Dev-Clean Slate Proj - Total $288.75 344 WRC ADMINISTRATION 75344 WRC Administration $2,123.25 WRC Administration - Total $2,123.25 049 WRC CROSS CONNECTION CONTROL 37049 WRC Cross Connections $12,024.00 WRC Cross Connections - Total $12,024.00 442 WRC - OMID - WORKDAY REPORTS 43442 WRC - OMID - Workday Reports $2,100.00 WRC - OMID - Workday Reports $2,100.00 501 WRC PERMITTING IMPL 74502 WRC Permitting Impl $1,443.75 WRC Permitting Impl -Total $1,443.75 979 WRC PERMITTING IMPL 74979 WRC Permitting Impl $826.00 WRC Permitting Impl -Total $826.00 122 WRC RESERVE SEWER 69002 WRC Reserve Sewer $11,934.92 WRC Reserve Sewer - Total $11,934.92 358 WRC - SCADA MAINTENANCE 33358 WRC - SCADA Maintenance $288.75 WRC - SCADA Maintenance - Total $288.75 067 WRC UTILITY BILLING REPLACEMENT 33067 WRC Utility Billing Replacement $1,853.50 WRC Utility Billing Replacement - Total $1,853.50 293 WRC - WATER FUND 69001 WRC - Water Fund $11,935.08 WRC - Water Fund - Total $11,935.08 Prepared by: Information Technology; 05/05/2026 Page 12 of 13 2nd Quarter 2026.pdf INFORMATION TECHNOLOGY 2nd Quarter Y.T.D. Application Services 19000 IT Application Services Planned Maint $377,250.25 $666,114.00 30001 IT Application Services Data Warehouse $16,960.75 $21,915.25 30003 IT Application Services GIS $108,590.50 $219,701.50 30004 IT Application Services eGovernment $409,390.50 $917,320.25 App Services - Sub Total: $912,192.00 $1,825,051.00 Internal Services 19020 Internal Services Planned Main $14,025.00 $14,355.00 Internal Services - Sub-Total: $14,025.00 $14,355.00 Technical Sys/Networking 19001 SQL Serv Support - IT $51.98 $51.98 19002 Oracle Support - T $373.23 $373.23 19030 Tech Sys/Net Planned Maint $81,324.25 $294,299.75 23007 Oracle Support - IT Tech Systems $124.41 $304.59 23017 Oracle Support - IT Tech Systems 1.2% $28.71 $70.29 24018 SQL Serv Support - IT Tech Systems 2% $29.61 $80.64 25400 Oracle Administration $0.00 $0.00 95750 I.T. - SEP $178,080.50 $282,667.50 Tech Sys/Net - Sub-Total: $260,012.69 $579,827.98 Information Technology - Total: $1,186,229.69 $2,419,233.98 DEVELOPMENT / SUPPORT DETAIL - SECOND QUARTER 2026 Prepared by: Information Technology; 05/05/2026 Page 13 of 13 2nd Quarter 2026.pdf