HomeMy WebLinkAboutResolutions - 2026.08.13 - 43076
AGENDA ITEM: 2026 Third Quarter Information Technology Development Report
DEPARTMENT: Information Technology
MEETING: Board of Commissioners
DATE: Thursday, August 13, 2026 9:30 AM - Click to View Agenda
ITEM SUMMARY SHEET
COMMITTEE REPORT TO BOARD
Resolution #2026-6827
Motion to receive and file the 2026 Third Quarter Information Technology Development Report and
approve the Fiscal Year 2026 Third Quarter appropriation transfer for General Fund/General
Purpose County departments in the amount of $1,989,300.22, as specified in the attached report;
further, the report identifies direct charges to Special Revenue and Proprietary fund departments in
the amount of $973,289.29 and non-county agency charges in the amount of $5,953.00 for the Third
Quarter of Fiscal Year 2026.
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 Third Quarter 2026 development charges to be $1,989,300.22 for the General
Fund/General Purpose County departments; and direct charges to Special Revenue and Proprietary
fund departments are $973,289.29 and non-county agencies are $5,953.00 for the Third Quarter
2026; and an appropriation transfer to General Fund/General Purpose County departments is
needed to fund these development charges.
POLICY ANALYSIS
The immediate fiscal impact is an appropriation transfer of $1,989,300.22 from the non-
departmental Information Technology Development appropriation to General Fund/General Purpose
user departments for third-quarter development charges. The report shows an equal offsetting
reduction to the non-departmental IT Development account, resulting in no net increase to total
governmental appropriations for the quarter if sufficient funding remains in the existing non-
departmental appropriation.
For year-to-date context, the report shows $5,473,220.53 in governmental development
appropriation charges through the third quarter. The report also shows $3,037,485.48 in year-to-
date direct county development charges and $14,523.25 in year-to-date non-county agency
charges.
The item has not yet received final approval from Fiscal Services. Once Fiscal Services has
completed its review, staff will follow up to confirm the Schedule A/budget amendment language for
the $1,989,300.22 in General Fund/General Purpose development charges, including whether the
transfer can be absorbed within the existing non-departmental IT Development appropriation and
whether any additional funding is needed at this time.
Staff will also request confirmation that the $973,289.29 in direct charges to Special Revenue and
Proprietary fund departments can be absorbed within the applicable fund budgets. If any fund
requires a separate budget amendment, transfer, reimbursement, or other corrective action, that
should be identified before final approval.
Given the ongoing CLEMIS transition, staff will also confirm whether there is anything unique about
the CLEMIS-related charges this quarter or any change in how those costs should be treated going
forward.
The key fiscal question is whether this item is budget-neutral within existing appropriations and
whether there are any year-end budget pressures or additional approvals the Committee should be
aware of before recommending approval.
FISCAL IMPACT: Budget Amendment Attached
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 - 8/13/2026
AGENDA DEADLINE: 07/30/2026 4:30 PM
ATTACHMENTS
1. IT Development Summary - 3rd Quarter 2026
COMMITTEE TRACKING
2026-08-16 Finance - Recommend to Board
2026-08-13 Full Board - Adopt
Motioned by: Commissioner Penny Luebs
Seconded by: Commissioner Robert Hoffman
Yes: Charles Cavell, Ann Erickson Gault, Marcia Gershenson, Robert Hoffman, Brendan
Johnson, Karen Joliat, Christine Long, Penny Luebs, Gwen Markham, William Miller III, Kristen
Nelson, Robert Smiley, Yolanda Smith Charles, Michael Spisz, Linnie Taylor, David Woodward
(16)
No: None (0)
Abstain: None (0)
Absent: Michael Gingell, Philip Weipert (2)
Passed
3rd Quarter
CUST FUND#ACCOUNT DIVISION Apr - Jun Y.T.D.
GOVERNMENTAL FUNDS
General Fund [101]
540 101 CCN3020201-PRG121020-FND10100-SC773630 52/1 - District Court $10,326.40 $29,307.76
550 101 CCN3020301-PRG121020-FND10100-SC773630 52/2 - District Court $10,326.40 $29,307.76
560 101 CCN3020401-PRG121020-FND10100-SC773630 52/3 - District Court $10,326.40 $29,307.76
530 101 CCN3020501-PRG121020-FND10100-SC773630 52/4 - District Court $10,326.05 $29,306.72
630 101 CCN1070801-PRG114000-FND10100-SC773630 Animal Control $32,071.39 $185,297.64
005 101 CCN5010101-PRG180010-FND10100-SC773630 Bd of Commissioners $945.75 $3,276.00
722 101 CCN2010210-PRG125000-FND10100-SC773630 Clerk/Reg - EDMS (Imaging)$32,246.68 $81,033.92
440 101 CCN2010301-PRG185010-FND10100-SC773630 Clerk/Reg - Elections $10,317.25 $18,529.50
724 101 CCN2010210-PRG125000-FND10100-SC773630 Clerk/Reg - Legal Records $106,832.50 $296,384.75
720 101 CCN2010401-PRG172190-FND10100-SC773630 Clerk/Reg - ROD $10,937.50 $26,095.52
723 101 CCN2010205-PRG132305-FND10100-SC773630 Clerk/Reg - Vital Statistics $37,986.64 $101,622.14
522 101 CCN1070401-PRG113000-FND10100-SC773630 Pretrial and Justices Services $26,153.37 $65,389.96
361 101 CCN1210101-PRG181000-FND10100-SC773630 Communications Department - Dev $87,212.50 $175,194.25
430 101 CCN1010501-PRG181020-FND10100-SC773630 Corporation Counsel $17,030.00 $18,957.71
483 101 CCN3010403-PRG121100-FND10100-SC773630 CTS-FD-Judicial Support-ADM $144.39 $285.89
015 101 CCN1010101-PRG181000-FND10100-SC773630 County Executive $11,428.25 $18,235.50
498 101 CCN3010301-PRG121130-FND10100-SC773630 Courts-GJ-Judicial Support $147,379.74 $473,117.04
502 101 CCN3010301-PRG121180-FND10100-SC773630 Courts-GJ-Jury Operations $3,231.48 $3,926.07
493 101 CCN3010101-PRG121100-FND10100-SC773630 Courts - Judical / Administration $30,604.69 $73,293.79
346 101 CCN1210101-PRG181000-FND10100-SC773630 Department of Public Communication $0.00 $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 $35,591.00 $49,857.50
011 101 CCN1110102-PRG145000-FND10100-SC773630 Emergency Management $0.00 $59,461.50
258 101 CCN1040101-PRG140015-FND10100-SC773630 Env Sustainability - Initiatives $543.75 $806.25
740 101 CCN1020501-PRG173010-FND10100-SC773630 Equalization Division $161,100.11 $647,503.08
062 101 CCN1011001-PRG181000-FND10100-SC773630 Exec Ofc - Performance Mgmt $53,215.50 $54,405.50
660 101 CCN1020601-PRG182020-FND10100-SC773630 Fiscal Services-Gen Fund $99,670.76 $287,243.79
900 101 CCN1110101-PRG115090-FND10100-SC773630 Emergency Mgmt/Homeland Security $20,748.75 $52,116.50
337 101 CCN1040901 PRG140499 FND10100 SC773630 FM Trimble PM $5,197.50 $38,875.48
735 101 CCN6010101-PRG155060-FND10100-SC773630 General Fund Map $825.00 $2,145.00
562 101 CCN1060101-PRG133300-FND10100-SC773630 Human Services - HS Admin Serv $16,376.25 $44,137.50
412 101 CCN1050101-PRG183010-FND10100-SC773630 Human Resources Admin $625.00 $5,484.95
680 101 CCN1050401-PRG183010-FND10100-SC773630 Human Resources $68,159.14 $190,734.61
690 101 CCN1020301-PRG182090-FND10100-SC773630 Management & Budget - Purchasing $19,241.25 $77,775.00
872 101 CCN1070601-PRG132030-FND10100-SC773630 Medical Examiner $4,826.89 $8,549.89
409 101 CCN1010702-PRG121170-FND10100-SC773630 MIDC OCIT Maint & Suppt $990.00 $4,843.00
349 101 CCN4030501-PRG112680-FND10100-SC773630 OCSD Admin Serv-Records Unit $1,120.75 $1,162.00
647 101 CCN4030601-PRG110000-FND10100-SC773630 OCSD Patrol Serv Admin $0.00 $65.55
INFORMATION TECHNOLOGY
DEVELOPMENT SUMMARY
THIRD QUARTER 2026
Prepared by: Information Technology; 07/14/2026 Page 1 of 14 3rd Quarter 2026.pdf
3rd Quarter
CUST FUND#ACCOUNT DIVISION Apr - Jun Y.T.D.
775 101 CCN1090201-PRG171000-FND10100-SC773630 Planning & Economic Development $20,212.25 $38,669.68
512 101 CCN3040403-PRG124010-FND10100-SC773630 Probate-Estates/Mental Health - EDMS (Imaging)$28,215.94 $70,905.04
510 101 CCN3040403-PRG124010-FND10100-SC773630 Probate-Estates/Mental Health Support $35,310.39 $122,552.89
509 101 CCN3040101-PRG121080-FND10100-SC773630 Probate-Judicial Admin $0.00 $41.25
145 101 CCN4010101-PRG122050-FND10100-SC773630 Prosecuting Attorney - General Prosecution $29,667.39 $82,099.75
717 101 CCN4010201-PRG122090-FND10100-SC773630 Prosecuting Attorney - Tranquility AI for the Prosecutor $1,048.25 $5,230.75
650 101 CCN1020650-PRG126020-FND10100-SC773630 Reimbursement Division $24,106.25 $42,243.00
195 101 CCN4030301-PRG112590-FND10100-SC773630 OCSD-Corrective Serv - Admin $164,185.24 $514,458.04
191 101 CCN4030601-PRG110000-FND10100-SC773630 Sheriff - CLEMIS $198,288.48 $206,821.07
348 101 CCN4030301-PRG112620-FND10100-SC773630 Sheriff - Corrective Serv Admin $2,186.25 $29,584.50
445 101 CCN1030803-PRG184025-FND10100-SC773630 Support Services $340.25 $927.82
600 101 CCN7010101-PRG186040-FND10100-SC773630 Treasurer - Admin $149,357.19 $437,739.17
978 101 CCN7010101-PRG186050-FND10100-SC773630 Treasurers - DelTax $10,993.00 $52,601.75
458 101 CCN7010101-PRG186090-FND10100-SC773630 Treasurer - Disbursing $5,425.00 $15,185.00
169 101 CCN7010101-PRG186080-FND10100-SC773630 Treasurer - General Acctg $13,117.50 $22,895.00
488 101 CCN7010101-PRG186100-FND10100-SC773630 Treasurer - Investments $0.00 $1,815.00
322 101 CCN7010101 PRG186070 FND10100 SC773630 Treasurer - S&D $6,682.00 $6,682.00
910 101 CCN1090401-PRG132050-FND10100-SC773630 Veterans Services $678.25 $857.00
730 101 CCN6010101-PRG155010-FND10100-SC773630 Water Resource Commissioner $49,014.14 $139,111.14
Sub-Total Fund 101 $1,822,886.80 $4,978,510.63
Health Fund [101]
840 101 CCN1060201-PRG133150-FND10100-SC773630 Health $59,359.25 $87,733.86
852 101 CCN1060211-PRG133150-FND10100-SC773630 Health Central Support $99.25 $1,298.50
843 101 CCN1060220-PRG134390-FND10100-SC773630 Health Environmental $91,491.42 $283,038.56
Sub-Total Fund 101 $150,949.92 $372,070.92
Juvenile Maintenance Fund [293]
665 293 CCN1070901-PRG112090-FND20293-SC773630 Children's Village $15,463.50 $122,638.98
Sub-Total Fund 293 $15,463.50 $122,638.98
CCN1080101-PRG152000-FND63600-SC631365 DEVELOPMENT FOR GOVERNMENTAL FUND $1,989,300.22 $5,473,220.53
APPROPRIATION
$1,989,300.22 $5,473,220.53
CCN9090101-PRG196030-FND10100-SC773630 Information Technology Development ($1,989,300.22)($5,473,220.53)
TOTAL GOVERNMENTAL:$0.00 $0.00
Prepared by: Information Technology; 07/14/2026 Page 2 of 14 3rd Quarter 2026.pdf
3rd Quarter
CUST FUND#ACCOUNT DIVISION Apr - Jun Y.T.D.
DIRECT CHARGES
911 CCN6010101-PRG149669-FND63900-SC773630 AIO Replacement Project $22,648.00 $57,941.00
672 CCN9016001-PRG152130-FND42060-SC773630 Assesment & Tax $65,426.00 $156,143.50
944 CCN6010101-PRG149669-FND63900-SC773630 CAMP CTA DR Equipment $8,650.25 $8,856.50
902 CCN1080305-PRG116020-FND53500-SC773630 CLEMIS DEVELOPMENT $42,580.59 $151,041.93
056 CCN1080305-PRG116020-FND53500-SC773630 CLEMIS FUND 63500 $71,024.75 $218,927.00
087 CCN6010101-PRG149030-FND57341-SC773630 Commerce Twp WWTP $0.00 $448.50
061 CCN6010101-PRG149999-FND57341-SC773630 Commerce Services Sewer $1,386.75 $1,515.75
036 CCN6010101-PRG149999-FND57241-SC773630 Commerce Services Water $1,307.75 $1,436.75
044 CCN9016011-PRG152130-FND42115-SC773630 Courts CMS Project $148,289.25 $294,231.00
507 CCN3010404-PRG126030-FND27100-SC773630 Courts-FOC Exp-CS Enforcement $76,981.19 $206,701.04
933 CCN6010101-PRG155060-FND63900-SC773630 Drain Equip Map $0.00 $660.00
210 CCN1080325-PRG115100-FND53100-SC773630 Fire Records Management System $14,940.39 $35,493.89
750 CCN1040701-PRG140101-FND63100-SC773630 FM&O $20,535.64 $79,030.91
053 CCN1040701-PRG140101-FND63100-SC773630 PRJ-18032 2026 FMO Asset Mgmt $38,616.25 $97,499.75
963 CCN3010404-PRG126030-FND27100-SC773630 FOC Security Audit $0.00 $644.14
880 CCN5060201-PRG160900-FND50800-SC773630 Glen Oak Capital Work $41.25 $1,320.00
038 CCN6010101-PRG149820-FND63900-SC773630 HACH WIMS Software Support $82.50 $948.75
227 CCN1060201-PRG133150-FND11007-SC773630 Health Social Care ($27,427.00)$0.00
120 CCN9016001-PRG152130-FND42100-SC773630 HR-Financial System Replacement $19,766.00 $42,689.00
338 CCN9016001-PRG152130-FND42080-SC773630 Imaging Project $3,510.50 $167,950.75
751 CCN1080601-PRG152070-FND67500-SC773630 IT Telephone Communications $20,206.00 $65,159.50
303 CCN9010101-PRG133095-FND21285-SC773630 GRN-1004256 IT ARP Funding $240,071.00 $673,724.50
548 CCN9016001-PRG152130-FND42105-SC773630 ITIM Program $98,581.50 $420,540.50
360 CCN1010702-PRG121170-FND20260-SC773630 GRN-1004647 MIDC Application Maint & Supp $1,858.50 $20,064.00
770 CCN5060101-PRG160000-FND50800-SC773630 Parks and Recreation - Administration $10,890.00 $33,000.00
733 CCN5080101-PRG160000-FND50800-SC773630 Parks & Rec - Time Tracking $1,998.75 $2,648.75
762 CCN5060172-PRG160010-FND50800-SC773630 P&R Glen Oaks Golf Course $206.25 $330.00
763 CCN5060174-PRG160010-FND50800-SC773630 P&R Lyon Oaks Golf Course $123.75 $247.50
316 CCN5060101-PRG160040-FND50800-SC773630 PR Administrative AW $1,072.50 $1,072.50
653 CCN1090501-PRG154010-FND56500-SC773630 O.C. International Airport $559.00 $559.00
790 CCN1080310-PRG115150-FND53600-SC776360 Radio Communications $7,158.25 $50,149.75
791 CCN1080310-PRG115060-FND53500-SC773630 Radio Communications - E911 $25,784.25 $85,524.25
695 CCN1010502-PRG182000-FND67700-SC773630 Risk Management $13,029.50 $18,767.50
656 CCN6010101-PRG149030-FND57010-SC773630 Water Resources Accounting $51.48 $1,098.57
930 CCN6010101-PRG149000-FND57010-SC773630 Water and Sewer-General Adm $3,296.50 $5,106.50
201 CCN6010101-PRG149540-FND57010-SC773630 Water & Sewer Gen Adm - XC2 $783.75 $783.75
Prepared by: Information Technology; 07/14/2026 Page 3 of 14 3rd Quarter 2026.pdf
3rd Quarter
CUST FUND#ACCOUNT DIVISION Apr - Jun Y.T.D.
212 CCN1090701-PRG170010-FND11004-SC776360 GRN-1004517 Workforce Dev - Clean Slate Proj $1,608.75 $1,897.50
344 CCN6010101-PRG149130-FND57010-SC773630 WRC Administration $5,335.75 $10,304.50
049 CCN6010101-PRG149999-FND57010-SC773630 WRC Cross Connection Control $2,272.50 $26,729.50
442 CCN6010101-PRG149130-FND82912-SC773630 WRC - OMID - Workday Reports $0.00 $2,100.00
501 CCN6010101-PRG149820-FND63900-SC773630 WRC Permitting Impl $1,443.75 $4,413.75
979 CCN6010101-PRG149820-FND63900-SC773630 WRC Permitting Impl $2,117.50 $2,943.50
122 CCN6010101-PRG149300-FND57010-SC773630 WRC Reserve Water $7,955.41 $27,601.28
358 CCN6010101-PRG149870-FND63900-SC773630 WRC - SCADA Maintenance $371.25 $783.75
293 CCN6010101-PRG149290-FND57010-SC773630 WRC - Water Fund $7,955.59 $27,601.72
067 CCN6010101-PRG149999-FND57010-SC773630 WRC Utility Billing Replacement $0.00 $2,253.50
701 CCN6010101-PRG149999-FND57010-SC773630 WRC Miss Dig Management Sys IM $9,702.75 $26,064.75
CCN1080101-PRG152000-FND63600-SC631302 SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $973,289.29 $3,037,485.48
TOTAL COUNTY DEVELOPMENT CHARGES $2,962,589.51 $8,510,706.01
NON-COUNTY AGENCIES
CCN1080101-PRG152000-FND63600-RC635017 Non-County Agencies $5,953.00 $14,523.25
Prepared by: Information Technology; 07/14/2026 Page 4 of 14 3rd Quarter 2026.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2026
Cust #GOVERNMENTAL FUNDS 3rd Qtr 2026
630 ANIMAL CONTROL 24017 SQL Server Supp - Animal Control $144.39
95682 Dog System $31,927.00
Animal Control-Total $32,071.39
005 BD OF COMMISSIONERS 91404 BOC - Customer Support $945.75
Bd of Commissioners - Total $945.75
665 CHILDRENS VILLAGE 95665 Childrens Village $15,463.50
Childrens Village - Total $15,463.50
440 CLERK/REG - ELECTIONS DIVISION 95443 Clerk/Reg - Elections Division $10,317.25
Clerk/Reg - Elections Division - Total $10,317.25
722 CLERK/REG - EDMS (IMAGING)95158 Clerk/Reg - EDMS Support/Maintenance/Upgrades $32,246.68
Clerk/Reg - EDMS (Imaging) - Total $32,246.68
724 CLERK/REG - LEGAL RECORDS 95189 Circuit Court System $106,832.50
Clerk/Reg - Legal Records - Total $106,832.50
720 CLERK / REGISTER OF DEEDS 95498 Clerk/Reg - ROD $10,937.50
Clerk/Reg of Deeds - Total $10,937.50
723 CLERK - VITAL STATISTICS 24015 SQL Server Supp - Vital Stats 3.5%$144.39
95161 Clerk.Reg - Vital Statistics $37,842.25
Clerk - Vital Statistics - Total $37,986.64
522 COMMUNITY CORRECTIONS-ADMIN (CO)23003 Oracle Support-Comm Corr - 5.2%$51.48
24012 SQL Server Supp - Community Corr 3.5%$144.39
52200 Comm Corr-Admin (County)$25,957.50
52201 Comm Corr - DW Support $0.00
Community Corrections - Total $26,153.37
361 COMMUNICATION DEPARTMENT DEV 95361 Communication Department Dev $87,212.50
Communication Department Dev - Total $87,212.50
COMPLIANCE OFFICE - PURCHASING
Prepared by: Information Technology; 07/14/2026 Page 5 of 14 3rd Quarter 2026.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2026
95663 Purchasing Internal $12,260.00
Compliance Office - Purchasing - Total $19,241.25
430 CORPORATION COUNSEL 95501 Corporation Counsel $17,030.00
Corporation Counsel - Total $17,030.00
015 COUNTY EXECUTIVE 95654 County Executive - Development $6,575.00
95656 County Executive Support $4,853.25
County Executive - Total $11,428.25
483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5%$144.39
CTS-FD-Judicial Support-Adm - Total $144.39
498 CTS-GEN JURIS-JUDICIAL SUPPT 23010 Oracle Supp-CCT $25.74
95179 CTS-Gen Juris-Judicial Suppt $147,354.00
CTS-Gen Juris-Judicial Suppt - Total $147,379.74
502 CTS-GJ-JURY OPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operations $51.48
95183 CTS-GJ-Jury Operations $3,180.00
CTS-GJ-Jury Operations - Total $3,231.48
493 CTS-JUDICIAL ADMIN 95174 CTS-Judicial Admin $30,604.69
CTS-Judicial Admin - Total $30,604.69
785 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS 36500 GIS Implementation Support C&E Dev $75.00
95785 Comm & Eco Developmt $35,516.00
Economic Development & Community Affairs - Total $35,591.00
258 ENV SUSTAINABILITY INITIATIVES 90258 ENV Sustainability Initiatives $543.75
ENV Sustainability Initiatives - Total $543.75
740 EQUALIZATION 23012 Oracle Support-Equalization - 5.2%$51.48
24005 SQL Server Supp-Equalization - 10.5%$433.13
36505 GIS Implementation Support Equalization $5,789.75
36506 Equal Application - H/W Support $13,629.00
36507 Equal LAMS Support $4,935.00
36601 Land System Enhancements - Equal (50%)$8,075.69
36801 Land System Support - Equal (50%)$30,366.89
50101 EQUAL (BS&A ANNUAL)$6,658.67
95699 BS&A Master Appraisal Sup/Maint $91,160.50
Equalization - Total $161,100.11
Prepared by: Information Technology; 07/14/2026 Page 6 of 14 3rd Quarter 2026.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2026
062 EXEC OFC - PERFORMANCE MGMT 95062 Exec Ofc - Performance Mgmt $53,215.50
Exec Ofc - Performance Mgmt - Total $53,215.50
660 FISCAL SERVICES ADMIN 23001 Oracle Support - Fiscal Serv - 15.6%$154.44
23013 Oracle Support - HR-Acctg/Budget - 5.2%$51.48
24006 SQL Serv Supp - HR-Acctg - 1.75%$72.19
44021 FS-System/Customer Support $31,046.25
96001 Fiscal Serv - Acctg 40%$48,436.35
96003 Fiscal Serv - Budget 20%$19,910.05
Fiscal Services Admin - Total $99,670.76
337 FM TRIMBLE PM 21337 FM Trimble PM $5,197.50
FM Trimble PM - Total $5,197.50
840 HEALTH DIVISION 95563 User Support-Health $13,454.50
96842 Health Admin $45,904.75
Health - Total $59,359.25
852 HEALTH CENTRAL SUPPORT 95852 Health Central Support $99.25
Health Central Support - Total $99.25
843 HEALTH - ENVIRONMENTAL 23005 Oracle Support - EH Projects - 5.2%$51.48
24014 SQL Server Suppt - Ehealth 14%$577.50
84200 EH - Projects $50,732.94
84300 Ehealth Program $40,129.50
Health-Environmental - Total $91,491.42
900 HOMELAND SECURITY 36545 GIS Implementation Support Homeland Security $330.00
36546 Homeland Security Application - H/W Support $20,418.75
Homeland Security - Total $20,748.75
412 HUMAN RESOURCES ADMINISTRATION 55001 Human Resources - 50%$625.00
HR Recruitment - Total $625.00
680 HUMAN RESOURCES 23014 Oracle Support-HR/Personnel - 5.2%$51.48
24007 SQL Server Suppport-HR/Personnel - 1.75%$72.19
96002 Human Res-Personnel 40%$68,035.47
Human Resources - Total $68,159.14
562 HUMAN SERVICES - HS ADMIN SERV 96561 Human Services-HS Admin Serv $16,376.25
Prepared by: Information Technology; 07/14/2026 Page 7 of 14 3rd Quarter 2026.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2026
Human Services-HS Admin Serv - Total $16,376.25
872 MEDICAL EXAMINER 24002 SQL Server Support - Medical Exam - 3.5%$144.39
87202 Medical Examiner - Customer Support $4,682.50
Medical Examiner - Total $4,826.89
409 MIDC OCIT MAIN/SUPPT 67409 MIDC OCIT Main/Suppt $990.00
MIDC OCIT Main/Suppt - Total $990.00
775 PLANNING & ECO DEVELOPMENT 95600 PEDS Cust/System Support $20,212.25
Planning & Eco Development - Total $20,212.25
512 PROB-ESTATES/MENTL HLTH EDMS (IMG)95207 PC-E/MH EDMS Support & Mtce $28,215.94
Prob-Est/Mntl Hlth EDMS (Img) - Total $28,215.94
510 PROB-ESTATES/MENTL HLTH SUPPORT 24010 SQL Serv Supp-PCT-Est/Mental - 3.5%$144.39
92198 Prob-Est/Mntl Hlth Support $35,166.00
Prob-Est/Mntl Hlth Support - Total $35,310.39
717 PROSECUTING ATTORNEY 97717 Prosecuting Attorney $1,048.25
Prosecuting Attorney - Total $1,048.25
145 PROSECUTOR - GENERAL PROSECUTION 24016 SQL Server Supp - Prosecutors 3.5%$144.39
95622 Prosecutor/Executive $29,523.00
Prosecutor - Total $29,667.39
650 REIMBURSEMENT 95470 Reimbursement System $330.00
95542 Reimburse User Support $23,776.25
Reimbursement - Total $24,106.25
195 SHERIFF 23009 Oracle Suppport - OCSD/CTS Crim Whse - 2.6%$25.74
97163 Sheriff $30,987.25
98164 CLEMIS-Sheriff $133,172.25
Sheriff - Total $164,185.24
191 SHERIFF - CLEMIS 23015 Oracle Suppport - Sheriff / CLEMIS - 5.2%$51.48
96163 Sheriff - CLEMIS $198,237.00
Sheriff - CLEMIS - Total $198,288.48
348 SHERIFF - CORRECTIVE SERV ADMIN 34800 Inmate Phone System $2,186.25
Sheriff - Corrective Serv Admin - Total $2,186.25
Prepared by: Information Technology; 07/14/2026 Page 8 of 14 3rd Quarter 2026.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2026
349 OCSD ADMIN SERV - RECORDS MGMT 97349 OCSD Admin Serv - Records Mgmt $1,120.75
OCSD Admin Serv - Records Mgmt - Total $1,120.75
445 SUPPORT SERVICES 23002 Oracle Support - Supp Serv - 5.2%$51.48
24011 SQL Server Supp - Suppt Services 7%$288.77
Support Services - Total $340.25
600 TREASURER - ADMIN 36602 Land System Enhancements - Treas (50%)$8,075.56
36802 Land System Support - Treas (50%)$30,366.86
44061 Tre-System/Customer Support $30,821.69
44062 Tre-System Maintenance $236.75
44063 Tre-System Enhancements $738.75
50102 TREAS (BS&A ANNUAL)$6,658.58
95008 Del Tax On Line $495.00
95615 BS&A Annual Tax Support $71,964.00
Treasurer - Total $149,357.19
169 TREASURER - GENERAL ACCOUNTING 96169 Treasurer - General Accounting $13,117.50
Treasurer - General Accounting - Total $13,117.50
458 TREASURERS - DISBURSING 95458 Treasurers - Disbursing $5,425.00
Treasurers - Disbursing - Total $5,425.00
978 TREASURERS OFFICE-DELTAX 95978 Treasurers-DelTax $10,993.00
Treasurers-DelTax - Total $10,993.00
322 TREASURERS - S&D 95322 Treasurers- S&D $6,682.00
Treasurers- S&D - Total $6,682.00
910 VETERANS SERVICES 95651 Veterans Customer Support $678.25
Veterans Services - Total $678.25
730 WATER RESOURCE COMMISSIONER 24008 SQL Server Supp - WRC 3.5%$144.39
28007 Water Resource Commission $23,460.75
28011 Water Resource Commissioner Application $19,457.75
36520 GIS Implementation Support WRC $5,951.25
Water Resource Commissioner - Total $49,014.14
735 WRC GEN FUND MAP 74735 WRC Gen Fund Map $825.00
Prepared by: Information Technology; 07/14/2026 Page 9 of 14 3rd Quarter 2026.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2026
WRC Gen Fund Map - Total $825.00
540 52/1 DISTRICT COURT - NOVI 95527 DC Suprt- 52/1 - 25%$10,326.40
52/1 District Court - Total $10,326.40
550 52/2 DISTRICT COURT - CLARKSTON 95528 DC Suprt- 52/2 - 25%$10,326.40
52/2 District Court - Total $10,326.40
560 52/3 DISTRICT COURT - ROCHESTER 95529 DC Suprt - 52/3 - 25%$10,326.40
52/3 District Court - Total $10,326.40
530 52/4 DISTRICT COURT - TROY 95530 DC Suprt- 52/4 - 25%$10,326.05
52/4 District Court - Total $10,326.05
Cust #DIRECT FUNDS
911 AIO REPLACEMENT PROJECT 74911 AIO Replacement Proj $22,648.00
$22,648.00
672 ASSESSMENT & TAX 67200 Assessment & Tax $65,426.00
Assessment & Tax - Total $65,426.00
944 CAMP CTA DR EQUIPMENT 37944 Camp CTA DR Equipment $8,650.25
Camp CTA DR Equipment - Total $8,650.25
902 CLEMIS DEVELOPMENT 23004 Oracle Support - OakVideo CLEMIS 5.2%$51.48
23018 Oracle Support - Sheriff CLEMIS 5.2%$51.48
24004 SQL Server Support - 24.5%$1,010.63
95430 CLEMIS Maintenance $20,102.50
98003 CLEMIS User Support $165.00
98005 CLEMIS - E911 Support $21,199.50
CLEMIS - Total $42,580.59
056 CLEMIS FUND 63500 63500 CLEMIS Fund $71,024.75
CLEMIS 63500 Fund - Total $71,024.75
061 COMMERCE SERVICES SEWER 33061 Commerce Services - $1,386.75
Commerce Services - Total $1,386.75
COMMERCE SERVICES WATER
Prepared by: Information Technology; 07/14/2026 Page 10 of 14 3rd Quarter 2026.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2026
Commerce Services - Total $1,307.75
044 COURTS CMS PROJECT 95044 Courts CMS Project $148,289.25
Courts CMS Project - Total $148,289.25
507 CTS-FOC EXP-CS ENFORCEMENT 92193 CTS-FOC Exp-CD Enforc-Dev $48,765.25
92194 CTS-FOC Enf-EDMS $28,215.94
CTS-FOC Exp-CD Enforc-Dev - Total $76,981.19
210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $14,796.00
24001 FRMS - Phase II Proj $144.39
Fire Records Management System - Total $14,940.39
750 FM&O 24013 SQL Server Supp - FM&O $144.39
75503 FM&O Development $20,391.25
FM&O - Total $20,535.64
053 2026 FM&O ASSET MGMT 75053 2026 FMO Asset Mgmt $38,616.25
2026 FMO Asset Mgmt - Total $38,616.25
880 GLEN OAKS CAPITAL WORK 76880 Glen Oaks Capital Work $41.25
Glen Oaks Capital Work - Total $41.25
038 HACH WIMS SOFTWARE SUPPORT 74038 HACH WIMS Software Support $82.50
HACH WIMS Software Support - Total $82.50
227 HEALTH SOCIAL CARE 96227 Health Social Care -$27,427.00
Health Social Care - Total -$27,427.00
120 HR-FINANCIAL SYSTEM REPLACEMENT 44120 HR-Financial Sys Rep $19,766.00
HR-Financial Sys Rep - Total $19,766.00
338 IMAGING PROJECT 33800 Imaging Project $3,510.50
Imaging Project - Total $3,510.50
303 IT ARP FUNDING 17303 IT ARP Funding $240,071.00
IT ARP Funding - Total $240,071.00
751 IT - TELEPHONE COMMUNICATIONS 75102 Telephone Communications - Customer Support $20,206.00
Prepared by: Information Technology; 07/14/2026 Page 11 of 14 3rd Quarter 2026.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2026
548 ITIM PROGRAM 97548 ITIM Program $98,581.50
ITIM Program - Total $98,581.50
360 MIDC APPLICATION SUPPORT & MAINT 67360 MIDC Application Support & Maintenance $1,858.50
MIDC Application Support & Maintenance - Total $1,858.50
653 O.C. INTNL AIRPORT 65301 Airport User Support $559.00
O.C. Intnl Airport - Total $559.00
770 PARKS AND RECREATION 95413 PRADM-Customer Support $10,890.00
Parks & Recreation - Total $10,890.00
762 P&R GLEN OAKS GOLF COURSE 76200 P&R Glen Oaks Golf Course $206.25
P&R Glen Oaks Golf Course - Total $206.25
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
316 PR ADMINISTRATIVE AW 76316 PR Administrative AW $1,072.50
PR Administrative AW - Total $1,072.50
790 RADIO COMMUNICATIONS 79001 Radio Communications $7,158.25
$7,158.25
791 RADIO COMMUNICATIONS - E911 79101 Radio Communications - E911 $25,784.25
Radio Communications - E911 - Total $25,784.25
695 RISK MANAGEMENT 44036 Rsk-System Customer Support $946.00
44038 RSK-System Enhancement $3,796.75
95695 Risk Management $8,286.75
Risk Management - Total $13,029.50
656 WATER RESOURCES ACCOUNTING 23011 Oracle Supp - Water & Sewer Acct'g - 5.2%$51.48
Water Resources Accounting - Total $51.48
736 WINCAN CENTRAL STORAGE SOLUTION 73601 WinCan Central Storage Solution $495.00
WinCan Central Storage Solution - Total $495.00
930 WATER AND SEWER-GENERAL ADMIN 37930 Water and Sewer-General Admin $3,296.50
Water and Sewer-General Admin - Total $3,296.50
Prepared by: Information Technology; 07/14/2026 Page 12 of 14 3rd Quarter 2026.pdf
INFORMATION TECHNOLOGY - RESERVE FUND
DEVELOPMENT / SUPPORT DETAIL - THIRD QUARTER 2026
201 WATER & SEWER - GEN ADM XC2 35201 Water & Sewer Gen Adm XC2 $783.75
Water & Sewer Gen Adm XC2 - Total $783.75
212 WORKFORCE DEV-CLEAN SLATE PROJ 95212 Workforce Dev - Clean Slate Proj $1,608.75
Workforce Dev - Clean Slate Proj - Total $1,608.75
344 WRC ADMINISTRATION 75344 WRC Administration $5,335.75
WRC Administration - Total $5,335.75
049 WRC CROSS CONNECTION CONTROL 37049 WRC Cross Connection Control $2,272.50
WRC Cross Connection Control - Total $2,272.50
122 WRC RESERVE SEWER 69002 WRC Reserve Sewer $7,955.41
WRC Reserve Sewer - Total $7,955.41
733 WRC-HYDRO DRAIN PROJECT 73301 WRC-Hydro Drain Project $1,998.75
WRC-Hydro Drain Project - Total $1,998.75
701 WRC MISS DIG MANAGEMENT SYS IM 33701 WRC - MISS DIG Management $9,702.75
$9,702.75
979 WRC PERMITTING IMPLEMENTATION 74979 WRC Permitting Implementation $2,117.50
WRC Permitting Implementation - Total $2,117.50
501 WRC PERMITTING IMPL 74502 WRC Permitting Impl $1,443.75
WRC Permitting Impl - Total $1,443.75
358 WRC - SCADA MAINTENANCE 33358 WRC - SCADA Maintenance $371.25
WRC - SCADA Maintenance - Total $371.25
293 WRC - WATER FUND 69001 WRC - Water Fund $7,955.59
Prepared by: Information Technology; 07/14/2026 Page 13 of 14 3rd Quarter 2026.pdf
INFORMATION TECHNOLOGY
.
3rd Quarter Y.T.D.
Application Services 19000 IT Application Services Planned Maint $496,439.75 $1,162,553.75
30001 IT Application Services Data Warehouse $6,512.75 $28,428.00
30003 IT Application Services GIS $110,875.75 $330,577.25
30004 IT Application Services eGovernment $347,426.00 $1,264,746.25
App Services - Sub Total: $961,254.25 $2,786,305.25
Internal Services 19020 Internal Services Planned Main $3,547.50 $17,902.50
Internal Services - Sub-Total: $3,547.50 $17,902.50
Technical Sys/Networking 19001 SQL Serv Support - IT $144.39 $196.37
19002 Oracle Support - T $154.44 $527.67
19030 Tech Sys/Net Planned Maint $126,961.25 $421,261.00
23007 Oracle Support - IT Tech Systems $51.48 $356.07
23017 Oracle Support - IT Tech Systems 1.2%$11.88 $82.17
24018 SQL Serv Support - IT Tech Systems 2%$82.30 $162.94
25400 Oracle Administration $0.00 $1,980.00
95750 I.T. - SEP $220,380.25 $503,047.75
Tech Sys/Net - Sub-Total: $347,785.99 $927,613.97
Prepared by: Information Technology; 07/14/2026 Page 14 of 14 3rd Quarter 2026.pdf