Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Resolutions - 2024.11.21 - 41719
AGENDA ITEM: 2024 Fourth Quarter Information Technology Development Report DEPARTMENT: Information Technology MEETING: Board of Commissioners DATE: Thursday, November 21, 2024 1:46 PM - Click to View Agenda ITEM SUMMARY SHEET COMMITTEE REPORT TO BOARD Resolution #2024-4652 Motion to receive and file the attached Fourth Quarter 2024 Development Report and approve the Second Quarter appropriation transfer as specified on the attached Schedule; further, the respective departmental Fiscal Year 2024 budgets are to be amended as specified in the attached detailed 2024 Fourth Quarter Information Technology Development Report. 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. The Department of Information Technology has determined the Fourth Quarter 2024 development charges to be $1,648,804.87 for the General Fund/General Purpose County departments; and direct charges to Special Revenue and Proprietary fund departments are $659,108.30 and non-county agencies are $10,536.50 for the Fourth Quarter 2024. An appropriation transfer to General Fund/General Purpose County departments is needed to fund these development charges. 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. The Department of Information Technology has determined the Fourth Quarter 2024 development charges to be $1,648,804.87 for the General Fund/General Purpose County departments. Direct charges to Special Revenue and Proprietary fund departments are $659,108.30 and non-county agencies are $10,536.50 for the Fourth Quarter 2024. An appropriation transfer to General Fund/General Purpose County departments is needed to fund these development charges. BUDGET AMENDMENT REQUIRED: Yes 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 ITEM REVIEW TRACKING Aaron Snover, Board of Commissioners Created/Initiated - 11/21/2024 AGENDA DEADLINE: 11/21/2024 9:30 AM ATTACHMENTS 1. IT Development Summary - 4th Quarter 2024 COMMITTEE TRACKING 2024-11-13 Finance - Recommend to Board 2024-11-21 Full Board - Adopt Motioned by: None Seconded by: None Yes: None (0) No: None (0) Abstain: None (0) Absent: (0) 4th Quarter CUST FUND#ACCOUNT DIVISION Jul - Sep Y.T.D. GOVERNMENTAL FUNDS General Fund [101] 540 101 CCN3020201-PRG121020-FND10100-SC773630 52/1 - District Court $4,360.84 $21,756.23 550 101 CCN3020301-PRG121020-FND10100-SC773630 52/2 - District Court $4,360.84 $21,756.23 560 101 CCN3020401-PRG121020-FND10100-SC773630 52/3 - District Court $4,360.84 $21,756.23 530 101 CCN3020501-PRG121020-FND10100-SC773630 52/4 - District Court $4,360.48 $21,754.81 630 101 CCN1070801-PRG114000-FND10100-SC773630 Animal Control $38,851.40 $88,942.51 005 101 CCN5010101-PRG180010-FND10100-SC773630 Bd of Commissioners $1,037.00 $5,329.75 718 101 CCN2010210-PRG125000-FND10100-SC773630 Clerk E-Services $0.00 $0.00 722 101 CCN2010210-PRG125000-FND10100-SC773630 Clerk/Reg - EDMS (Imaging)$22,325.96 $68,310.70 440 101 CCN2010301-PRG185010-FND10100-SC773630 Clerk/Reg - Elections $10,977.00 $28,094.50 410 101 CCN2010501-PRG125000-FND10100-SC773630 Clerk/Reg - Jury Commission $0.00 $247.50 724 101 CCN2010210-PRG125000-FND10100-SC773630 Clerk/Reg - Legal Records $85,531.16 $353,004.64 720 101 CCN2010401-PRG172190-FND10100-SC773630 Clerk/Reg - Register Of Deeds $12,346.40 $39,421.01 723 101 CCN2010205-PRG132305-FND10100-SC773630 Clerk/Reg - Vital Statistics $16,448.15 $70,946.01 522 101 CCN1070401-PRG113000-FND10100-SC773630 Community Corrections Admin $18,932.41 $64,813.49 361 101 CCN1210101-PRG181000-FND10100-SC773630 Communications Department - Dev $23,380.50 $75,742.00 640 101 CCN1010201-PRG181005-FND10100-SC773630 Compliance Office $0.00 $6,586.25 430 101 CCN1010501-PRG181020-FND10100-SC773630 Corporation Counsel $21,419.63 $77,999.16 222 101 CCN3010403-PRG121250-FND10100-SC773630 CTS - Extreme Risk $5,796.61 $44,086.30 506 101 CCN3010401-PRG121220-FND10100-SC773630 CTS-FAM DIV JUD Support $372.00 $14,538.00 483 101 CCN3010403-PRG121100-FND10100-SC773630 CTS-FD-Judicial Support-ADM $118.40 $508.26 482 101 CCN3010403-PRG121240-FND10100-SC773630 CTS-FD-Juvenile Support $0.00 $0.00 015 101 CCN1010101-PRG181000-FND10100-SC773630 County Executive $25,550.75 $89,705.75 498 101 CCN3010301-PRG121130-FND10100-SC773630 Courts-GJ-Judicial Support $190,948.74 $827,481.11 502 101 CCN3010301-PRG121180-FND10100-SC773630 Courts-GJ-Jury Operations $70.51 $326.48 493 101 CCN3010101-PRG121100-FND10100-SC773630 Courts - Judical / Administration $29,463.60 $91,430.58 346 101 CCN1210101-PRG181000-FND10100-SC773630 Department of Public Communication $4,549.70 $19,770.49 515 101 CCN1010301-PRG181002-FND10100-SC773630 Diversity, Equity & Inclusion $1,189.00 $2,193.50 188 101 CCN1090206-PRG171000-FND10100-SC773630 Economic Dev & Comm Affairs $0.00 $535.50 785 101 CCN1090101-PRG171000-FND10100-SC773630 Economic Development & Community Affairs $12,969.75 $62,236.75 292 101 CCN1060201-PRG133095-FND11007-SC773630 ELC Contract Tracing & Investigation $0.00 $0.00 011 101 CCN1110102-PRG145000-FND10100-SC773630 Emergency Management $24,378.75 $50,985.00 740 101 CCN1020501-PRG173010-FND10100-SC773630 Equalization Division $298,550.17 $910,807.38 258 101 CCN1040101-PRG140015-FND10100-SC773630 ENV Sustainability-Initiatives $462.00 $1,528.00 181 101 CCN1040801-PRG140020-FND10100-SC773630 FM&O Admin Support $41.25 $948.75 660 101 CCN1020601-PRG182020-FND10100-SC773630 Fiscal Services-Gen Fund $76,183.75 $352,857.59 900 101 CCN1110101-PRG115090-FND10100-SC773630 Emergency Mgmt/Homeland Security $17,097.75 $82,258.75 735 101 CCN6010101-PRG155060-FND10100-SC773630 General Fund Map $0.00 $2,310.00 562 101 CCN1060101-PRG133300-FND10100-SC773630 Human Services - HS Admin Serv $13,777.50 $32,084.25 680 101 CCN1050401-PRG183010-FND10100-SC773630 Human Resources $82,849.54 $347,187.42 INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2024 Prepared By: Information Technology; 11/13/2024 Page 1 of 24 4th Quarter 2024.pdf 4th Quarter CUST FUND#ACCOUNT DIVISION Jul - Sep Y.T.D. INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2024 565 101 CCN1090108-PRG171030-FND10100-SC773630 Marketing & Communcations $0.00 $0.00 690 101 CCN1020301-PRG182090-FND10100-SC773630 Management & Budget - Purchasing $82.50 $4,381.25 872 101 CCN1070601-PRG132030-FND10100-SC773630 Medical Examiner $11,037.65 $43,222.51 409 101 CCN1010702-PRG121170-FND10100-SC773630 MIDC OCIT Maint & Suppt $5,315.25 $19,619.25 710 101 CCN1060801-PRG174000-FND10100-SC773630 MSU Extension - Oakland $0.00 $0.00 349 101 CCN4030501-PRG112680-FND10100-SC773630 OCSD Admin Serv-Records Unit $165.00 $401.25 647 101 CCN4030601-PRG110000-FND10100-SC773630 OCSD Patrol Serv Admin $55.70 $191.84 919 101 CCN9090101-PRG196030-FND10100-SC773630 OCSO Body Camera IT Dev $0.00 $0.00 775 101 CCN1090201-PRG171000-FND10100-SC773630 Planning & Economic Development $11,015.34 $59,841.10 093 101 CCN3040101-PRG121090-FND10100-SC773630 Probate Court Admin $1,007.25 $8,864.75 512 101 CCN3040403-PRG124010-FND10100-SC773630 Probate-Estates/Mental Health - EDMS (Imaging)$19,535.35 $59,772.33 510 101 CCN3040403-PRG124010-FND10100-SC773630 Probate-Estates/Mental Health Support $18,935.40 $68,428.51 145 101 CCN4010101-PRG122050-FND10100-SC773630 Prosecuting Attorney - General Prosecution $47,482.15 $312,656.51 637 101 CCN1030803-PRG184020-FND10100-SC773630 Records Retention $0.00 $0.00 650 101 CCN1020650-PRG126020-FND10100-SC773630 Reimbursement Division $2,829.25 $13,683.00 195 101 CCN4030301-PRG112590-FND10100-SC773630 OCSD-Corrective Serv - Admin $57,615.87 $194,323.41 191 101 CCN4030601-PRG110000-FND10100-SC773630 Sheriff - CLEMIS $14,394.76 $111,655.98 348 101 CCN4030301-PRG112620-FND10100-SC773630 Sheriff - Corrective Serv Admin $0.00 $4,991.25 988 101 CCN4030901-PRG116240-FND10100-SC773630 Sheriff - IFS Div Lab $4,413.75 $11,813.00 118 101 CCN4030801-PRG110085-FND10100-SC773630 Sheriff Technology - Info & Innovation $0.00 $0.00 445 101 CCN1030803-PRG184025-FND10100-SC773630 Support Services $431.04 $20,500.39 600 101 CCN7010101-PRG186040-FND10100-SC773630 Treasurer - Admin $90,722.90 $385,101.29 978 101 CCN7010101-PRG186050-FND10100-SC773630 Treasurers - DelTax $15,339.00 $50,513.50 458 101 CCN7010101-PRG186090-FND10100-SC773630 Treasurer - Disbursing $0.00 $1,488.25 169 101 CCN7010101-PRG186080-FND10100-SC773630 Treasurer - General Acctg $62,925.50 $111,706.50 488 101 CCN7010101-PRG186100-FND10100-SC773630 Treasurer - Investments $0.00 $577.50 910 101 CCN1090702-PRG132050-FND10100-SC773630 Veterans Services $17,826.00 $67,904.75 730 101 CCN6010101-PRG155010-FND10100-SC773630 Water Resource Commissioner $59,248.40 $187,748.51 742 101 CCN6010101-PRG149920-FND10100-SC773630 WRC - CAMS Software Support & Maintenance $0.00 $0.00 Sub-Total Fund 101 $1,493,440.44 $5,639,627.51 Health Fund [101] 840 101 CCN1060201-PRG133150-FND10100-SC773630 Health $38,982.63 $168,716.16 852 101 CCN1060211-PRG133150-FND10100-SC773630 Health Central Support $123.75 $1,185.00 843 101 CCN1060220-PRG134390-FND10100-SC773630 Health Environmental $91,239.16 $298,562.11 Sub-Total Fund 101 $130,345.54 $468,463.27 Juvenile Maintenance Fund [293] 665 293 CCN1070901-PRG112090-FND20293-SC773630 Children's Village $25,018.89 $76,268.04 Sub-Total Fund 293 $25,018.89 $76,268.04 Prepared By: Information Technology; 11/13/2024 Page 2 of 24 4th Quarter 2024.pdf 4th Quarter CUST FUND#ACCOUNT DIVISION Jul - Sep Y.T.D. INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2024 CCN1080101-PRG152000-FND63600-SC631365 DEVELOPMENT FOR GOVERNMENTAL FUND $1,648,804.87 $6,184,358.82 APPROPRIATION SUB-TOTAL GOVERNMENTAL DEVELOPMENT APPROPRIATION: $1,648,804.87 $6,184,358.82 CCN9090101-PRG196030-FND10100-SC773630 Information Technology Development ($1,648,804.87)($6,184,358.82) TOTAL GOVERNMENTAL:$0.00 $0.00 NON-GOVERNMENTAL DIRECT CHARGES 911 CCN6010101-PRG149669-FND63900-SC773630 PRJ-17302 AIO Replacement Project $7,777.50 $7,777.50 687 CCN1110101-PRG133095-FND21285-SC773630 GRN-1004054 ARP HSD INV mgmt $0.00 $3,011.25 672 CCN9016001-PRG152130-FND42060-SC773630 Assesment & Tax $33,740.50 $77,969.25 944 CCN6010101-PRG149669-FND63900-SC773630 CAMP CTA DR Equipment $479.00 $9,029.75 902 CCN1080305-PRG116020-FND53500-SC773630 CLEMIS DEVELOPMENT $7,780.52 $23,827.19 056 CCN1080305-PRG116020-FND53500-SC773630 CLEMIS FUND 63500 $46,410.50 $150,276.75 952 CCN2010210-PRG125000-FND10100-SC773630 GRN-1004131 Clerk/Reg - E-Services/MLH Grant $6,565.00 $13,651.25 065 CCN2010210-PRG125000-FND10100-SC773630 GRN-1004391 Clerk/Reg - E-Services/MLH GRN2 $9,171.00 $12,159.75 251 CCN1070401-PRG113000-FND11003-SC773630 GRN-1004141 Community Corrections AD Hoc Report $1,340.25 $1,340.25 070 CCN1070401-PRG113000-FND11003-SC773630 GRN-1004141 Comm Corr - Madison Hts 43rd DC $453.75 $453.75 507 CCN3010404-PRG126030-FND27100-SC773630 Courts-FOC Exp-CS Enforcement $79,093.85 $229,175.58 933 CCN6010101-PRG155060-FND63900-SC773630 Drain Equip Map $0.00 $4,785.00 210 CCN1080325-PRG115100-FND53100-SC773630 Fire Records Management System $1,397.90 $45,847.51 750 CCN1040701-PRG140101-FND63100-SC773630 FM&O $22,850.77 $82,156.03 835 CCN1040719-PRG148020-FND40400-SC773630 FMO BMS PH 5 $0.00 $0.00 946 CCN1040719-PRG148020-FND40400-SC773630 FMO BMS PH 6 $4,541.75 $12,968.75 330 CCN1040725-PRG140599-FND63100-SC773630 FM&O Grounds Maintenance $165.00 $3,341.25 963 CCN3010404-PRG126030-FND27100-SC773630 FOC Security Audit $0.00 $0.00 655 CCN1040210-PRG184010-FND66100-SC773630 Garage $0.00 $6,570.00 038 CCN6010101-PRG149820-FND63900-SC773630 HACH WIMS Software Support $0.00 $0.00 947 CCN9016001-PRG152130-FND42085-SC773630 HIPAA Enhancements II $0.00 $0.00 120 CCN9016001-PRG152130-FND42100-SC773630 HR-Financial System Replacement $67,686.25 $316,304.25 214 CCN9016001-PRG152130-FND42210-SC773630 IAM Program $0.00 $0.00 338 CCN9016001-PRG152130-FND42080-SC773630 Imaging Project $138,330.50 $523,756.25 250 CCN1010702-PRG121170-FND20260-SC773630 GRN-1003954 Indigent Defense Serv Grant $0.00 $0.00 751 CCN1080601-PRG152070-FND67500-SC773630 IT Telephone Communications $0.00 $1,140.00 303 CCN9010101-PRG133095-FND21285-SC773630 GRN-1004256 IT ARP Funding $10,972.50 $22,046.75 415 CCN9010101-PRG133095-FND21285-SC773630 GRN-1004054 IT/ARP Projects $18,597.50 $36,133.50 548 CCN9016001-PRG152130-FND42105-SC773630 ITIM Program $56,418.00 $286,188.50 Prepared By: Information Technology; 11/13/2024 Page 3 of 24 4th Quarter 2024.pdf 4th Quarter CUST FUND#ACCOUNT DIVISION Jul - Sep Y.T.D. INFORMATION TECHNOLOGY DEVELOPMENT SUMMARY FOURTH QUARTER 2024 202 CCN1080305-PRG116075-FND53500-SC773630 Jail Management System (JMS)$0.00 $146,185.50 185 CCN1030701-PRG154070-FND56500-SC773630 Leasetrack $0.00 $0.00 698 CCN9016001-PRG152130-FND42095-SC773630 MFD Repl $0.00 $0.00 360 CCN1010702-PRG121170-FND20260-SC773630 MIDC Application Maint & Support $7,620.00 $25,432.00 265 CCN9010101-PRG121170-FND20260-SC773630 Oakvideo MIDC Support & Maintenance $0.00 $0.00 653 CCN1090501-PRG154010-FND56500-SC773630 O.C. International Airport $1,443.75 $5,729.25 298 CCN1040105-PRG148020-FND40400-SC773630 OCSO CCTV East Annex Storage $0.00 $12,989.00 255 CCN1080305-PRG116020-FND53500-SC773630 Oracle Upgrade to 19C $0.00 $0.00 770 CCN5060101-PRG160000-FND50800-SC773630 Parks and Recreation - Administration $5,403.75 $23,182.50 790 CCN1080310-PRG115150-FND53600-SC773630 Radio Communications $492.00 $1,722.00 791 CCN1080310-PRG115060-FND53500-SC773630 Radio Communications - E911 $32,278.75 $184,031.50 695 CCN1010502-PRG182000-FND67700-SC773630 Risk Management $7,606.25 $21,967.50 601 CCN7010110-PRG186050-FND51600-SC773630 Treasurers - DTRF ($2,983.00)$67.00 115 CCN9016001-PRG152130-FND42090-SC773630 UCC Program III - VOIP $16,698.75 $89,968.00 231 CCN9016001-PRG152130-FND42090-SC773630 UCC Program IV - Wireless $0.00 $0.00 656 CCN6010101-PRG149030-FND57010-SC773630 Water Resources Accounting $318.01 $1,976.48 930 CCN6010101-PRG149000-FND57010-SC773630 Water and Sewer-General Adm $530.00 $102,527.00 974 CCN6010101-PRG149140-FND57010-SC773630 Water and Sewer Gen Admin-WMU $0.00 $1,485.00 212 CCN1090701-PRG170010-FND11004-SC773630 GRN-0001159 Workforce Dev-Clean Slate Proj $2,310.00 $5,321.25 897 CCN1090701-PRG170010-FND11004-SC773630 GRN-0001159 Workforce Dev-clean Slate Emai $0.00 $0.00 344 CCN6010101-PRG149130-FND57010-SC773630 WRC Administration $3,413.00 $4,459.50 940 CCN6010101-PRG149669-FND63900-SC773630 WRC - CAMP $674.00 $2,489.00 867 CCN6010101-PRG149999-FND57010-SC773630 WRC Cross Connection $8,589.00 $38,996.50 025 CCN6010101-PRG149870-FND63900-SC773630 WRC OCIT SCADA $0.00 $2,865.50 006 CCN6010101-PRG149820-FND63900-SC773630 GRN-1003339 WRC Digital Content Mgmt $0.00 $0.00 501 CCN6010101-PRG149820-FND63900-SC773630 WRC Permitting Impl $93.00 $1,596.00 059 CCN6010101-PRG149669-FND63900-SC773630 WRC-Powerplan Intergration $0.00 $0.00 358 CCN6010101-PRG149870-FND63900-SC773630 WRC - SCADA Maintenance $1,021.50 $2,919.50 294 CCN6010101-PRG149030-FND57010-SC773630 WRC - Sewer Fund $0.00 $0.00 067 CCN6010101-PRG149999-FND57010-SC773630 WRC Utility Billing Replacement $59,827.50 $200,017.25 801 CCN6010101-PRG149662-FND57331-SC773630 WRC Walled Lake Novi WWTP $0.00 $0.00 CCN1080101-PRG152000-FND63600-SC631302 SUB-TOTAL DIRECT CHARGES FOR DEVELOPMENT $659,108.30 $2,745,837.29 TOTAL COUNTY DEVELOPMENT CHARGES $2,307,913.17 $8,930,196.11 NON-COUNTY AGENCIES CCN1080101-PRG152000-FND63600-RC635017 Non-County Agencies $10,536.50 $64,516.00 Prepared By: Information Technology; 11/13/2024 Page 4 of 24 4th Quarter 2024.pdf 4th Qtr 2024 Cust #GOVERNMENTAL FUNDS 630 ANIMAL CONTROL DIV 24017 SQL Server Supp - Animal Control $118.40 95628 Animal Control $0.00 95682 Dog System $38,733.00 Animal Control-Total $38,851.40 005 BD OF COMMISSIONERS 91404 BOC - Customer Support $1,037.00 Bd of Commissioners - Total $1,037.00 508 BOC-LEGAL RESOURCE CENTER 91405 BOC-Legal Resource Center $0.00 BOC-Legal Resource Center - Total $0.00 665 CHILDRENS VILLAGE 53001 Childrens Village $1,287.01 95665 Childrens Village $23,731.88 Childrens Village - Total $25,018.89 668 CHILDREN'S VILLAGE ADMIN 97668 Childrens Village Admin $0.00 Childrens Village Admin - Total $0.00 725 CLERK/REG - ADMIN 72500 Clerk - Admin $0.00 Clerk/Reg - Admin - Total $0.00 718 CLERK/REG - E-SERVICES 71800 E-Services $0.00 E-Services - Total $0.00 440 CLERK/REG - ELECTIONS DIVISION 95443 Clerk/Reg - Elections Division $10,977.00 Clerk/Reg - Elections Division - Total $10,977.00 722 CLERK/REG - EDMS (IMAGING)95158 Clerk/Reg - EDMS Spt/Maintenance/Upgrades $22,325.96 13001 Clerk's - Efiling $0.00 Clerk/Reg - EDMS (Imaging) - Total $22,325.96 410 CLERK/REG - JURY COMMISSION 95512 Clerk/Reg - Jury Commission $0.00 Clerk/Reg - Jury Commission - Total $0.00 724 CLERK/REG - LEGAL RECORDS 95170 Clerk/Reg - Legal Records $0.00 21013 Legal Division - 50%$0.00 31001 Clerk Legal Div - 50 $1,062.77 32001 Extreme Risk PO $5,796.64 95189 Clerk Legal Records $78,671.75 Clerk/Reg - Legal Records - Total $85,531.16 726 CLERK/REG - MICROGRAPHICS 91002 Clerk/Reg - Micrographics $0.00 Clerk/Reg - Micrographics - Total $0.00 291 CLERK REGISTER OF DEEDS ADMIN 95291 Clerk Register of Deeds $0.00 Clerk Register of Deeds - Total $0.00 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 Prepared By: Information Technology; 11/13/2024 Page 5 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 720 CLERK/REG - ROD 24003 SQL Server Supp - ROD 3.5%$118.40 36510 GIS Implementation Support $0.00 36511 ROD Application/HW Support $11,492.00 95493 ROD System Maintenance $0.00 95498 Clerk/Reg - ROD $736.00 Clerk/Reg - ROD - Total $12,346.40 723 CLERK/REG - VITAL STATISTICS 24015 SQL Server Supp - Vital Stats 3.5%$118.40 95161 Clerk/Reg - Vital Statistics $16,329.75 Clerk - Vital Statistics - Total $16,448.15 184 CLERK'S - COUNTY CLERK 96184 Clerk's - County Clerk $0.00 Clerk's - County Clerk - Total $0.00 361 COMMUNICATIONS DEPARTMENT-DEV 95361 Communications Department-Dev $23,380.50 Communications Department-Dev - Total $23,380.50 522 COMM CORR-ADMIN (COUNTY)23003 Oracle Support-Comm Corr - 5.2%$70.51 24012 SQL Server Supp - Community Corr 3.5%$118.40 52200 Comm Corr-Admin (County)$18,743.50 52201 Comm Corr - DW Support $0.00 Community Corrections - Total $18,932.41 640 COMPLIANCE OFFICE - ADMIN 44034 Auditing - New Development $0.00 95468 Auditing Intrnal Svc $0.00 Compliance Office - Auditing - Total $0.00 430 CORPORATION COUNSEL 10003 Corporation Counsel - 25%$0.00 42001 Corporation Counsel $37.13 95501 Corporation Counsel $21,382.50 Corporation Counsel - Total $21,419.63 015 COUNTY EXECUTIVE 95654 County Exec-Development $17,342.25 95656 County Executive Support $8,208.50 County Executive - Total $25,550.75 450 CIRC CT PROBATION - NORTH 80204 Circuit Court Probation - North $0.00 Circuit Court Probation - North - Total $0.00 495 CTS-BUSINESS DIVISION 12002 CCT-Courts/Criminal $0.00 23010 Oracle Support-CCT/CTS Crim Whse 2.6%$0.00 CTS-Business Division - Total $0.00 222 CTS-EXTREME RISK 32002 CTS-Extreme Risk $5,796.61 CTS-Extreme Risk - Total $5,796.61 490 CTS-FD-CT SERVICES-CLINIC 95171 CTS-FD-CT Services-Clinic $0.00 Prepared By: Information Technology; 11/13/2024 Page 6 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 CTS-FD-CT Services-Clinic - Total $0.00 506 CTS-FAM DIV-JUDICIAL SUPPT 95195 Circuit Court Admin $372.00 Circuit Court Admin - Total $372.00 483 CTS-FD-JUDICIAL SUPPORT-ADM 24009 SQL Serv Supp - CTS-Jud Sup Adm - 3.5%$118.40 CTS-FD-Judicial Support-Adm - Total $118.40 482 CTS-FD JUVENILE SUPPORT 48200 CTS-Jud Support - Juv Support $0.00 CTS-Jud Support - Juv Support - Total $0.00 498 CTS-GEN JURIS-JUDICIAL SUPPT 95179 CTS-Gen Juris-Judicial Suppt $189,642.25 23010 Oracle Supp-CCT/CTS $35.26 12002 CCT-Courts/Criminal $0.00 31002 CTS-GJ-General Support $1,062.73 95184 CTS-GJ-Legal $208.50 CTS-Gen Juris-Judicial Suppt - Total $190,948.74 502 CTS-GJ-JURY OPERATIONS 23008 Oracle Support-CTS-GJ-Jury Operations $70.51 CTS-GJ-Jury Operations - Total $70.51 493 CTS-JUDICIAL ADMIN 13002 Court's - Efiling $0.00 49300 Courts Web Redesign $0.00 95174 CTS-Judicial Admin $29,463.60 CTS-Judicial Admin - Total $29,463.60 346 DEPARTMENT OF PUBLIC COMMUNICATION 10001 DPC - 25%$129.95 51001 DPC - 50%$4,419.75 Department of Public Communication - Total $4,549.70 515 DIVERSITY, EQUITY & INCLUSION 51500 Diversity, Equity & Inclusion $1,189.00 Diversity, Equity & Inclusion - Total $1,189.00 188 ECONONIC DEV & COMM AFFAIRS 98180 Economic Dev & Comm Affairs $0.00 Economic Dev & Comm Affairs - Total $0.00 785 ECON DEV & COMM AFFAIRS 36500 GIS Implementation Support C&E Dev $371.25 36501 CED Application - H/W Support $0.00 95785 Comm & Eco Developmt $7,937.25 96785 EDCA Administration $4,661.25 Econ Dev & Comm Affairs - Total $12,969.75 046 ELECTIONS-PANDEMIC/COVID19 95046 Elections-Pandemic/COVID19 $0.00 Elections-Pandemic/COVID19 - Total $0.00 740 EQUALIZATION 23012 Oracle Support-Equalization - 5.2%$70.51 24005 SQL Serv Supp-Equalization - 10.5%$355.18 31075 Equal - Development $56,274.75 Prepared By: Information Technology; 11/13/2024 Page 7 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 36505 GIS Implementation Support Equalization $11,434.00 36506 Equal Application/HW Support $64,146.00 36507 Equal Lams Support/M $3,695.75 36601 Land System Enhancements - Equal (50%)$3,375.09 36701 Land System Maintenance - Equal (50%)$522.75 36801 Land System Support - Equal (50%)$45,364.13 36902 BS&A Orion Twp $0.00 50101 EQUAL (BS&A ANNUAL)$102.76 95562 Equalization - DW Support $0.00 95693 Equalization - System Maintenance $0.00 95699 BS&A Master Appraisal Sup/Maint $113,209.25 Equalization - Total $298,550.17 011 EMERGENCY MANAGEMENT 95011 Emergency Management $24,378.75 Emergency Management - Totsl $24,378.75 258 ENV SUSTAINABILITY-INITIATIVES 90258 Env Sustainability-Initiatives $462.00 Env Sustainability-Initiatives - Total $462.00 752 FACILITY ENGINEERING 75201 Facility Engineering $0.00 75504 DPW-FE Development $0.00 Facility Engineering - Total $0.00 660 FISCAL SERVICES - GEN FUND 23001 Oracle Support - Fiscal Serv - 15.6%$211.54 23013 Oracle Support - HR-Acctg/Budget - 5.2%$70.51 24006 SQL Serv Supp - HR-Acctg - 1.75%$59.22 44021 FS-System/Customer Support $22,933.25 44022 FS - System Maintenance $1,050.00 44023 FS - System Enhancements $0.00 44024 FS - New Development $0.00 44602 Bond Disclosure - Fiscal (50%)$0.00 96001 Fiscal Serv - Acctg 40%$33,348.90 96003 Fiscal Serv - Budget 20%$16,674.45 96005 Fiscal Serv - Acctg $1,835.88 Fiscal Services Admin - Total $76,183.75 181 FM&O ADMIN SUPPORT 21181 FM&O Admin Support 41.25 FM&O Admin Support - Total $41.25 852 HEALTH CENTRAL SUPPORT 95852 Health Central Support 123.75 Health Central Support - Total $123.75 840 HEALTH DIVISION 10004 Health - 25%$0.00 36525 GIS Implementation Support Health $0.00 42003 User Support/Health $111.38 95563 User Support/Health $17,842.50 96842 Health - Admin $21,028.75 Health - Total $38,982.63 Prepared By: Information Technology; 11/13/2024 Page 8 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 843 HEALTH - ENVIRONMENTAL 23005 Oracle Support - EH Projects - 5.2%$70.51 24014 SQL Server Suppt - Ehealth 14%$473.55 84200 EH - Projects $67,533.85 84300 Ehealth Program $23,161.25 Health-Environmental - Total $91,239.16 183 HEALTH WEBSITE REDESIGN 96183 Health Website Redesign $0.00 Health Website Redesign - Total $0.00 900 HOMELAND SECURITY (HSD)36545 GIS Implementation Support Homeland Security $82.50 36546 Homeland Security Application - H/W Support $17,015.25 95479 Homeland Security Customer $0.00 98990 Homeland Security $0.00 Homeland Security - Total $17,097.75 562 HUMAN SERVICES - HS ADMIN SERVICES 96561 HumanServices - HS Admin Services $13,777.50 HumanServices - HS Admin Services - Total $13,777.50 680 HUMAN RESOURCES 23014 Oracle Support-HR-Personnel - 5.2%$70.51 24007 SQL Server Supp-HR-Personnel - 1.75%$59.22 44044 HR- New Development $19,341.25 96002 Human Res-Personnel 40%$61,542.69 96006 Human Res - Personnel $1,835.87 Human Resources - Total $82,849.54 907 LIBRARY - LIBRARY ADMIN 91405 Library Board $0.00 Library - Library Admin - Total $0.00 824 LIBRARY SERVICES 61001 Library Services $0.00 Library Services - Total $0.00 565 MARKETING & COMMUNICATIONS 56500 Marketing & Communications $0.00 Marketing & Communications - Total $0.00 872 MEDICAL EXAMINER 24002 SQL Server Support - Medical Exam - 3.5%$118.40 87202 Med Exam - Cust Supt $10,919.25 Medical Examiner - Total $11,037.65 409 MIDC OCIT MAINT & SUPPORT 67409 MIDC OCIT Maint & Support $5,315.25 MIDC OCIT Maint & Support - Total $5,315.25 710 MSU EXTENSION - OAKLAND 95676 MSU Ext Equipment Maintenance $0.00 MSU Extension - Oakland - Total $0.00 349 OCSD ADMIN SERV - RECORDS UNIT 97349 OCSD Admin Serv - Records Unit $165.00 OCSD Admin Serv - Records Unit - Total $165.00 Prepared By: Information Technology; 11/13/2024 Page 9 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 648 OCSD ADMIN SERV-SHERIFF ADMIN 97648 OCSD Admin Serv-Sheriff Admin $0.00 OCSD Admin Serv-Sheriff Admin - Total $0.00 988 OC SHERIFF"S - IFS DIV - LAB 16300 OCSO CLEMIS Forensic $4,413.75 OCSO CLEMIS Forensic - Total $4,413.75 163 OCSO-CLEMIS FORENSIC LAB IMS 16300 OCSO-CLEMIS Forensic Lab $0.00 OCSO-CLEMIS Forensic Lab IMS - Total $0.00 775 PLANNING & ECO DEVELOPMENT 42005 Planning & Econ Dev $37.09 51002 Econ Dev - 50%$4,419.50 95600 PEDS Cust/System Support $6,558.75 Planning & Eco Development - Total $11,015.34 093 PROBATE COURT ADMIN 95093 Probate Court Admin $1,007.25 Probate Court Admin - Total $1,007.25 512 PROB-ESTATES/MENTL HLTH EDMS (IMG)95207 PC-E/MH EDMS Support & Mtce $19,535.35 Prob-Est/Mntl Hlth EDMS (Img) - Total $19,535.35 510 PROB-ESTATES/MENTL HLTH SUPPORT 24010 SQL Serv Supp-PCT-Est/Mental - 3.5%$118.40 92198 PC-E/MH Support-Dev $18,817.00 Prob-Est/Mntl Hlth Support - Total $18,935.40 481 PROB-FD JUDICIAL 95168 PC-Judicial Family Admin-Family Judges $0.00 Prob - FD Judicial - Total $0.00 479 PROB-FD JUDICIAL SUPPORT 95188 PC-Judicial Adm-Fam $0.00 PC-Judicial Adm-Fam - Total $0.00 145 PROSECUTOR - GENERAL PROSECUTION 24016 SQL Server Supp - Proescutors 3.5%$118.40 95622 Prosecutor/Executive $21,156.75 95623 Pros/Corcuit Ct $26,207.00 95664 Prosecutor Warrants $0.00 97001 Prosecutor Data Proc $0.00 Prosecutor - Total $47,482.15 690 PURCHASING 44028 Pur-System Enhancements $82.50 44026 Pur-System/Customer Support $0.00 44029 Pur-New Development $0.00 Compliance Office - Purchasing - Total $82.50 637 RECORDS RETENTION 44053 REC - System Enhancements $0.00 Records Retention - Total $0.00 650 REIMBURSEMENT DIV 95470 Reim System $2,829.25 95542 Reimburse User Support $0.00 Reimbursement - Total $2,829.25 Prepared By: Information Technology; 11/13/2024 Page 10 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 195 SHERIFF 12001 OCSD-Courts/Criminal - 50%$0.00 23009 Oracle Suppport - OCSD/CTS Crim Whse - 2.6%$35.26 97163 OCSD-Corrective Serv $7,079.11 97164 Sheriff - Development $50,501.50 97165 Sheriff-DW Support $0.00 98164 CLEMIS-Sheriff $0.00 Sheriff - Total $57,615.87 191 SHERIFF - CLEMIS 23015 Oracle Suppport - Sheriff / CLEMIS - 5.2%$70.51 96163 Sheriff - CLEMIS $14,324.25 Sheriff - CLEMIS - Total $14,394.76 348 SHERIFF - CORRECTIVE SERV ADMIN 34800 Inmate Phone System $0.00 Sheriff - Corrective Serv Admin - Total $0.00 118 SHERIFF TECHNOLOGY - INFO & INNOV 10002 Sheriff - 25%$0.00 Sheriff Technology - Info & Innov - Total $0.00 919 OCSO BODY CAMEREA IT DEV 91900 OCSO Body Camera IT Dev $0.00 OCSO Body Camera IT Dev - Total $0.00 55.70 647 OCSD PATROL SERV ADMIN 97647 Sheriff - Patrol Serv Admin $0.00 Sheriff - Patrol Serv Admin - Total $55.70 445 SUPPORT SERVICES ADMIN 23002 Oracle Support - Supp Serv - 5.2%$70.51 24011 SQL Server Supp - Suppt Services 7%$236.78 44500 Support Services Use $123.75 Support Services - Total $431.04 600 TREASURERS - ADMIN 23006 Oracle Support - Del Tax - 5.2%$70.51 23016 Oracle Support - Treasurer - 10.4%$141.02 36516 Treasurer Application - H/W Support $0.00 36602 Land System Enhancements - Treas (50%)$3,374.91 36702 Land System Maintenance - Treas (50%)$522.75 36802 Land System Support - Treas (50%)$45,364.12 44061 Tre-System/Customer Support $40,607.35 44062 Tre-System Maintenance $330.00 44063 Tre-System Enhancements $209.50 44064 Tre-New Development $0.00 44080 Tre-DW Support $0.00 44082 Tre-DW Maintenance $0.00 44601 Bond Disclosure - Treas (50%)$0.00 50102 Treas (BS&A Annual $102.74 91001 Treasurer's-25%$0.00 95008 Del Tax On Line $0.00 95303 Del Tax System Maintenance $0.00 Prepared By: Information Technology; 11/13/2024 Page 11 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 95561 User Support/Del Tax $0.00 95615 BS&A Annual Tax Support $0.00 Treasurer - Total $90,722.90 169 TREASURERS - GENERAL ACCOUNTING 96169 Treasurers - General Accounting 62,925.50 Treasurers - General Accounting - Total $62,925.50 488 TREASURER - INVESTMENTS 96488 Treasurer - Investments 0.00 Treasurer - Investments - Total $0.00 627 TREASURER - LANDSALE 44083 Treasurer-Landsale $0.00 Treasurer -Landsale - Total $0.00 458 TREASURERS - DISBURSING 95458 Treasurer - Disbursing 0.00 Treasurers - Disbursing - Total $0.00 978 TREASURERS OFFICE-DELTAX 95978 Treasurers-DelTax 15,339.00 Treasurers-DelTax - Total $15,339.00 910 VETERANS SERVICES 95651 Veterans Customer Support $41.25 95650 Veterans Services-Eq $17,784.75 Veterans Services - Total $17,826.00 730 WATER RESOURCE COMMISSION 24008 SQL Server Supp - WRC 3.5%$118.40 28007 Water Resource Commissioner $25,716.25 28009 WRC - Administration $0.00 28010 WRC-Customer Suppt $18,961.25 28011 WRC Custom Application $9,648.50 36520 GIS Implementation Support WRC $4,804.00 36521 WRC Program Support $0.00 Water Resource Commissioner - Total $59,248.40 742 WRC CAMS SOFTWARE SUPP & MAINT 74200 WRC CAMS SOFTWARE Support $0.00 WRC CAMS SOFTWARE Supp & Maint - Total $0.00 203 WRC EU PUB ED ADM PROGRAMS 74203 WRC EU Pub Adm Programs $0.00 WRC EU Pub Adm Programs - Total $0.00 735 WRC GEN FUND MAP 74735 WRC Gen Fund Map $0.00 WRC Gen Fund Map - Total $0.00 301 WRC - SOIL EROSION SOFTWARE SOL 74301 WRC - Soil Erosion Software Sol $0.00 WRC - Soil Erosion Software Sol - Total $0.00 540 52/1 - NOVI 95527 Dist Ct Supp - 25%$4,360.84 52/1 District Court - Total $4,360.84 550 52/2 CLARKSTON 95528 Dist Ct Supp - 25%$4,360.84 Prepared By: Information Technology; 11/13/2024 Page 12 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 52/2 District Court - Total $4,360.84 560 52/3 ROCHESTER 95288 52 Dist Ct Div 3 $0.00 95529 Dist Ct Supp - 25%$4,360.84 52/3 District Court - Total $4,360.84 530 52/4 TROY 95530 Dist Ct Supp - 25%$4,360.48 52/4 District Court - Total $4,360.48 $1,648,804.87 Cust #DIRECT FUNDS (NON-GOVERNMENTAL FUNDS) 911 AIO REPLACEMENT PROJECT 74911 AIO Replacement Project 7,777.50 AIO Replacement Project - Total $7,777.50 053 AIRPORT SPECIAL EVENTS 65350 Airport Special Events 0.00 Airport Special Events - Total $0.00 687 ARP HSD INV MGMT 68701 ARP HSD INV Mgmt 0.00 ARP HSD INV Mgmt - Total $0.00 274 ASAP PASSPORT SYSTEM 97274 ASAP Passport System $0.00 ASAP Passport System - Total $0.00 672 ASSESSMENT & TAX 67200 Assessment & Tax $33,740.50 Assessment & Tax - Total $33,740.50 935 AUGUSTA SAW GRANT 37935 Augusta SAW Grant $0.00 Augusta SAW Grant - Total $0.00 944 CAMP CTA DR EQUIPMENT 37944 Camp CTA DR Equipment $479.00 Camp CTA DR Equipment - Total $479.00 347 CHILDRENS VILLAGE CAMEERA - FMO 21347 Childrens Village Camera - FMO $0.00 Childrens Village Camera - FMO - Total $0.00 902 CLEMIS 23004 Oracle Support - OakVideo CLEMIS 5.2%$70.51 23018 Oracle Support - Sheriff CLEMIS 5.2%$70.53 24004 SQL Server Support - 24.5%$828.73 90510 CLEMIS - Oakvideo Support $0.00 95430 CLEMIS Maintenance $3,640.00 95431 CLMS Enhancements $0.00 98003 CLEMIS User Support $3,170.75 98005 CLEMIS - E911 Support $0.00 98000 Poject Team $0.00 CLEMIS - Total $7,780.52 026 CLEMIS MIDC BRIDGE 91026 CLEMIS MIDC Bridge $0.00 Prepared By: Information Technology; 11/13/2024 Page 13 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 CLEMIS MIDC Bridge - Total $0.00 699 CLEMIS - CAD 98006 CLEMIS - CAD Development $0.00 CLEMIS - CAD - Total $0.00 056 CLEMIS FUND 63500 63500 CLEMIS Fund $46,410.50 CLEMIS 63500 Fund - Total $46,410.50 448 CLEMIS/FRMS NON-BILLABLE 44800 CLEMIS/FRMS NON-BILL $0.00 CLEMIS/FRMS NON-BILL - Total $0.00 069 CLEMIS - TRAINING 91069 CLEMIS - Training $0.00 CLEMIS - Training - Total $0.00 669 CAMS/CVT DATA CONVERSION 66901 CAMS/CVT Data Conversion $0.00 CAMS/CVT Data Conversion - Total $0.00 749 CLERK/REG - CPL 74900 Clerk/Reg - CPL $0.00 Clerk/Reg - CPL - Total $0.00 952 CLERK/REG E-SERVICES/MLH GRN 95952 Clerk/Reg E-Services/MLH GRN $6,565.00 Clerk/Reg E-Services/MLH GRN - Total $6,565.00 065 CLERK/REG E-SERVICES/MLH GRN2 95065 Clerk/Reg E-Services/MLH GRN2 $9,171.00 Clerk/Reg E-Services/MLH GRN2 - Total $9,171.00 719 CLERK/ROD AUTOMATION FUND 95719 Register of Deeds Automation 0.00 Register of Deeds Automation - Total $0.00 659 COLLABORATIVE ASSET MGT SYS 65901 Collabortive Asset Mgt Sys $0.00 Collabortive Asset Mgt Sys - Total $0.00 937 COSDS SAW GRANT 37937 COSDS SAW Grant $0.00 COSDS SAW Grant - Total $0.00 471 CTS-FOC-EXP-CS ENFORC-EDMS (IMG)92194 CTS-FOC-CS ENF-EDMS Support/Maintenance/Upgrades $0.00 CTS-FOC Exp-CS Enforc-EDMS (Img) - Total $0.00 507 CTS-FOC EXP-CS ENFORCEMENT 34044 CTS-FOC-CS-Enforce $0.00 65410 FOC-Image Replace $0.00 92193 CTS-FOC-CS Enforc-Dev $59,558.50 92194 CTS-FOC-CS Enf-EDMS $19,535.35 CTS-FOC Exp-CD Enforc-Dev - Total $79,093.85 470 CTS-FOC EXP-FAM COUNSELING 34041 CTS-FOC EXP-FAM Counseling $0.00 92195 CTS-FOC EXP-FAM Coun $0.00 CTS-FOC EXP-FAM Counseling - Total $0.00 Prepared By: Information Technology; 11/13/2024 Page 14 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 251 COMM CORRECTIONS AD HOC REPORT 51251 Comm Corrections Ad Hoc Report $1,340.25 Comm Corrections Ad Hoc Report - Total $1,340.25 521 COMM CORR - ADM (GRANT)52100 Comm Corr Admin - GR $0.00 Comm Corr - Adm (Grant) - Total $0.00 070 COMM CORR - MADISON HTS 43RD DC 90184 Comm Corr - Madison Hts 43rd DC $453.75 Comm Corr - Madison Hts 43rd DC - Total $453.75 435 COMM DEV - HOUSING COUNSELOR 66104 Housing Counselor 0.00 Housing Counselor - Total $0.00 045 CV RADIO SYSTEM REPLACEMENT 95045 CV Radio System Replacement $0.00 CV Radio System Replacement Total $0.00 673 CYBER SECURITY FUND 67300 Cyber Security Fund $0.00 Cyber Security Fund - Total $0.00 931 DRAIN EQUIPMENT FUND 37931 Drain Equipment Fund $0.00 Drain Equipment Fund - Total $0.00 189 DRAIN EQUIPMENT FUND - POWERPLAN CONTRACT 35189 Drain Equipment Fund - Powerplan Contract 0.00 Drain Equipment Fund - Powerplan Contract - Total $0.00 933 DRAIN EQUIP MAP 37933 Drain Equip Map $0.00 Drain Equip Map - Total $0.00 837 EDCA - MITRADESCHOOL.ORG GRANT 83700 EDCA - MITRADESCHOOL $0.00 EDCA - MITradeSchool.org Grant - Total $0.00 210 FIRE RECORDS MANAGEMENT SYSTEM 21010 Fire Records Mgmt Fund 531 $1,279.50 95404 FRMS - Phase II Proj $0.00 24001 SQL Serv Supp-Fire R $118.40 Fire Records Management System - Total $1,397.90 750 FM&O 21001 Fac Maint & Oper $2,083.13 24013 SQL Server Supp - FM&O $118.40 53002 Facilities - 35%$692.99 75503 FMO Development $19,956.25 FM&O - Total $22,850.77 835 FMO BMS PH 5 21835 FMO BMS PH 5 $0.00 FMO BMS PH 5 - Total $0.00 946 FMO BMS PH 6 41946 FMO BMS PH 6 $4,541.75 FMO BMS PH 6 - Total $4,541.75 Prepared By: Information Technology; 11/13/2024 Page 15 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 756 FM&O BUILDING MAINTENANCE 75600 FM&O Building Maintenance $0.00 FM&O Building Maintenance - Total $0.00 133 FM&O BUILDING MAINTENANCE SYSTEM 21133 FM&O Building Maintenance System $0.00 FM&O Building Maintenance System - Total $0.00 330 FM&O GROUNDS MAINTENANCE 21330 FM&O Grounds Maintenance $165.00 FM&O Grounds Maintenance - Total $165.00 080 FMO BLDG MGMT SYSTEMS REPLACEMENT PH 2 21080 FMO Bldg Mgmt Systems Replacement Ph 2 $0.00 FMO Bldg Mgmt Systems Replacement Ph 2 - Total $0.00 342 FMO BLDG MGMT SYSTEMS REPLACEMENT PH 4 74342 FM&O Bldg Mgmt Systems Replacement Ph 4 $0.00 FM&O Bldg Mgmt Systems Replacement Ph 4 - Total $0.00 963 FOC SECURITY AUDIT 34963 FOC Security Audit $0.00 FOC Security Audit - Total $0.00 942 FRANKLIN SAW GRANT 37942 Franklin SAW Grant $0.00 Franklin SAW Grant - Total $0.00 655 GARAGE 65498 Garage Support $0.00 Garage Support - Total $0.00 038 HACH WIMS SOFTWARE SUPPORT 74038 HACH WIMS Software Support $0.00 HACH WIMS Software Support - Total $0.00 117 HEALTH - HEPATITIS A PREVENTION 96117 Health-HEP A Prevention 0.00 Health-HEP A Prevention - Total $0.00 380 HEALTH-IMMUNIZATION GRANT 38000 Health-Immunization Grant $0.00 Health-Immunization Grant - Total $0.00 319 HEALTH MEDICAL MARIJUANA 96319 Health Medical Marijuana $0.00 Health Medical Marijuana - Total $0.00 947 HIPAA ENHANCEMENTS II 96947 HIPAA Enhancements II $0.00 HIPAA Enhancements II - Total $0.00 120 HR-FINANCIAL SYSTEM REPLACEMENT 44120 HR-Financial System Replacement $67,686.25 HR-Financial System Replacement - Total $67,686.25 214 IAM PROGRAM 21400 IAM Program $0.00 IAM Program - Total $0.00 338 IMAGING PROGRAM 33800 Imaging Project $138,330.50 Imaging Project - Total .$138,330.50 Prepared By: Information Technology; 11/13/2024 Page 16 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 303 IT ARP FUNDING 17303 IT ARP Funding $10,972.50 IT ARP Funding - Total $10,972.50 415 IT/ARP PROJECTS 97415 IT/ARP Projects $18,597.50 IT/ARP Projects Total $18,597.50 889 ITIM 17889 ITIM $0.00 ITIM - Total $0.00 548 ITIM PROGRAM 97548 ITIM Program $56,418.00 ITIM Program - Total $56,418.00 751 IT - TELEPHONE COMM 75102 Tel Comm - Customer $0.00 IT - Telephone Comm - Total $0.00 202 JAIL MANAGEMENT SYSTEM (JMS)63202 Jail Management System (JMS)$0.00 Jail Management System (JMS) - Total $0.00 185 LEASETRACK RELPLACEMENT 18500 Leasetrack Replacement $0.00 Leasetrack Replacement - Total $0.00 112 MEDICAL MARIJUANA PSA 96112 Medical Marijuana PSA 0.00 Medical Marijuana PSA - Total $0.00 101 MEDICAL MARIJUANA MYSIDEWALK 96101 Medical Marijuana Mysidewalk 0.00 Medical Marijuana Mysidewalk - Total $0.00 698 MFD REPL 90698 MFD Repl 0.00 MFD Repl - Total $0.00 113 MIDC CLEMIS DEV 91113 MIDC CLEMIS Dev 0.00 MIDC CLEMIS Dev - Total $0.00 360 MIDC APPLICATION MAINT & SUPPORT 67360 MIDC Application Maint & Support 7,620.00 MIDC Application Maint & Support - Total $7,620.00 661 NEIGHBORHOOD HOUSING DEV 66103 Neighborhood Housing Development 0.00 Neighborhood Housing Development $0.00 164 NEIGHBORHOOD HOUSING DEV 95164 Neighborhood Housing Development 0.00 Neighborhood Housing Development $0.00 265 OAKVIDEO MIDC SUPPORT & MAINTENANCE 91265 Oakvideo MIDC Support & Maintenance 0.00 Oakvideo MIDC Support & Maintenance - Total $0.00 634 OAKVIDEO UPGRADE (BA)63400 CLEMIS - OakVideo Upgrade $0.00 63401 IT - OakVideo Upgrade $0.00 OakVideo Upgrade (BA) - Total $0.00 Prepared By: Information Technology; 11/13/2024 Page 17 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 938 OAKWIN RADIO SYSTEM ENH 98938 OAKWIN Radio System Enh $0.00 OAKWIN Radio System Enh - Total $0.00 653 O.C. INTN'L AIRPORT 36540 GIS Implementation Support $0.00 65301 Airport User Support $1,443.75 65310 O.C. Airport - New Dev $0.00 O.C. Intnl Airport - Total $1,443.75 298 OCSO CCTV EAST ANNEX STORAGE 97298 OCSO CCTV Annex Storage $0.00 OCSO CCTV Annex Storage - Total $0.00 934 OLV SDS SAW GRANT 37934 OLV SDS SAW Grant $0.00 OLV SDS SAW Grant - Total $0.00 255 ORACLE UPGRADE TO 19C 63255 Oracle Upgrade to 19C $0.00 Oracle Upgrade to 19C - Total $0.00 770 PARKS AND RECREATION 36530 GIS Implementation Support - Parks $41.25 44066 PRADM-System/Customer Support $82.50 44068 PRADM-System Enhancements $0.00 76100 P&R Administrative Services $0.00 95413 PRADM-Customer Support $5,280.00 95416 PRRA - Rec Admin $0.00 95419 PRADM-Administration $0.00 Parks & Recreation - Total $0.00 $5,403.75 867 P&R CAPITAL IMPROVEMENT 86700 P&R Capital Improvement $0.00 P&R Capital Improvement - Total $0.00 925 P&R EMS UPGRADE 37925 P&R EMS Upgrade $0.00 P&R EMS Upgrade - Total $0.00 796 P&R FACILITIES & MAINTENANCE 79600 P&R Facilities & Maintenance $0.00 P&R Facilities & Maintenance - Total $0.00 442 P&R LYON OAKS CONF CTR CIP#2469 44200 P&R Lyon Oaks Conf Ctr CIP #2469 $0.00 P&R Lyon Oaks Conf Ctr CIP #2469 - Total $0.00 443 P&R LYON OAKS CONF CTR CIP#2468 44300 P&R Lyon Oaks Conf CTR CIP#2468 $0.00 P&R Lyon Oaks Conf CTR CIP#2468 - Total $0.00 454 P&R SPRINGFIELD OAKS CIP#2471 45400 P&R Springfield Oaks CIP#2471 $0.00 P&R Springfield Oaks CIP#2471 - Total $0.00 456 P&R SPRINGFIELD OAKS CIP#2470 45600 P&R Springfield Oaks CIP#2470 $0.00 P&R Springfield Oaks CIP#2470 - Total $0.00 Prepared By: Information Technology; 11/13/2024 Page 18 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 457 P&R RED OAKS CLUBHOUSE CIP#2467 45700 P&R Red Oaks Clubhouse CIP#2467 $0.00 P&R Red Oaks Clubhouse CIP#2467 - Total $0.00 268 PONTIAC METER 74268 Pontiac Meter $0.00 Pontiac Meter - Total $0.00 747 PONTIAC WATER 74701 Pontiac BSA to WRC - Water $0.00 Pontiac Water - Total $0.00 095 PONTIAC SEWER 74095 Pontiac Sewer $0.00 Pontiac Sewer - Total $0.00 748 PONTIAC SEWER 74702 Pontiac BSA to WRC - Sewer $0.00 Pontiac Sewer - Total $0.00 936 PONTIAC WATER ASSET MGMT 37936 Pontiac Water Asset Mgmt $0.00 Pontiac Water Asset Mgmt - Total $0.00 329 PONTIAC WWTP TRANSACTION 67329 Pontiac WWTP Transaction $0.00 Pontiac WWTP Transaction - Total $0.00 237 PUBLIC SAFETY DASHBOARD 65237 Public Safety Dashboard $0.00 Public Safety Dashboard - Total $0.00 790 RADIO COMMUNICATIONS 79001 Radio Communications $492.00 Radio Communications - Total $492.00 791 RADIO COMMUNICATIONS - E911 79101 Radio Communications - E911 $32,278.75 Radio Communications - E911 - Total $32,278.75 695 RISK MANAGEMENT 44036 Rsk-System/Customer Support $7,606.25 44038 Risk System Enhancement $0.00 Risk Management - Total $7,606.25 638 TAX MANAGEMENT SYSTEM 63800 Tax Management System $0.00 Tax Management System - Total $0.00 601 TREASURERS - DTRF 18010 Treasurers Office System ($2,983.00) Treasurers - DTRF - Total ($2,983.00) 973 UCC PROGRAM II 92973 UCC Program II $0.00 UCC Program II - Total $0.00 115 UCC PROGRAM III - VOIP 92115 UCC Program III - VOIP 16,698.75 UCC Program III - VOIP - Total $16,698.75 Prepared By: Information Technology; 11/13/2024 Page 19 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 231 UCC PROGRAM IV - WIRELESS 23100 UCC Program IV - Wireless 0.00 UCC Program IV - Wireless - Total $0.00 408 VETERANS SERVICES GRANT FUND 96408 Veterans Services Grant Fund 0.00 Veterans Services Grant Fund - Total $0.00 656 WATER RESOURCES ACCTG 23011 Oracle Supp - Water & Sewer Acct'g - 5.2%$70.51 95669 Water Resources Acct $247.50 95671 Drain Water/Sewer BI $0.00 Water Resources Accounting - Total $318.01 731 WATER RESOURCE - EQUIPMENT 74501 Water Resouce - Equipment $0.00 Water Resouce - Equipment - Total $0.00 201 WATER AND SEWER GEN ADM - XC2 35201 Water and Sewer Gen Adm - XC2 $0.00 Water and Sewer Gen Adm - XC2 - Total $0.00 736 WINCAN CENTRAL STORAGE SOLUTION 73601 WinCan Central Storage Solution $0.00 WinCan Central Storage Solution - Total $0.00 930 WATER AND SEWER-GENERAL ADMIN 37930 Water and Sewer-General Admin $530.00 Water and Sewer-General Admin - Total $530.00 939 WATER AND SEWER GENERAL ADMINISTRATION 37939 Water and Sewer General Administration $0.00 Water and Sewer General Administration - Total $0.00 897 WORKFORCE DEV-CLEAN SLATE EMAIL 87897 Workforce Dev-Clean $0.00 Workforce Dev-Clean - Total $0.00 212 WORKFORCE DEV-CLEAN SLATE PROJ 95212 Workforce Dev-Clean Slate Proj $2,310.00 Workforce Dev-Clean Slate Proj - Total $2,310.00 850 WORKFORCE DEV DIVISION 95670 Workforce Development $0.00 Workforce Development - Total $0.00 670 WRC ACCTG - CROWDER PRJCT 60001 WRC - Crowder NetBase Project $0.00 67000 WRC - Crowder NetBase Project $0.00 WRC Acctg - Crowder Prject - Total $0.00 344 WRC ADMINISTRATION 75344 WRC Administration $3,413.00 WRC Administration - Total $3,413.00 929 WRC AERATION TANK REHAB 35700 WRC Aeration Tank Rehab $0.00 WRC Aeration Tank Rehab - Total $0.00 867 WRC CROSS CONNECTION 86701 WRC Cross Connection $8,589.00 WRC Cross Connection - Total $8,589.00 Prepared By: Information Technology; 11/13/2024 Page 20 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 168 WRC CRWRRF ADMIN BLDG REHAB 33168 WRC CRWRRF Admin Bldg $0.00 WRC CRWRRF Admin Bldg - Total $0.00 820 WRC MANHOLE INSPECTION CAMERA 74820 WRC Manhole Inspection Camera $0.00 WRC Manhole Inspection Camera $0.00 236 WRC OAKLAND MACOMB INTERCEPTOR 33236 WRC Oakland Macomb Interceptor $0.00 WRC Oakland Macomb Interceptor - Total $0.00 501 WRC PERMITTING IMPL 74502 WRC Permitting Impl $93.00 WRC Permitting Impl - Total $93.00 979 WRC PERMITTING IMPLEMENTATION 74979 WRC Permitting Implementation $0.00 WRC Permitting Implementation - Total $0.00 403 WRC - SAW BLOOMFIELD VILLAGE 33403 WRC - SAW Bloomfield Village $0.00 WRC - SAW Bloomfield Village - Total $0.00 358 WRC - SCADA MAINTENANCE 33358 WRC - SCADA Maintenance $1,021.50 WRC - SCADA Maintenance - Total $1,021.50 940 WRC - CAMP 37940 WRC - Camp $674.00 WRC - Camp - Total $674.00 926 WRC CLINTON-OAKLAND SCADA 33926 WRC Clinton-Oakland SCADA $0.00 WRC Clinton-Oakland SCADA - Total $0.00 932 WRC CLINTON-OAK SDS SCADA MAIN 37932 WRC Clinton-Oak SDS SCADA Main $0.00 WRC Clinton-Oak SDS SCADA Main - Total $0.00 281 WRC 74281 WRC $0.00 WRC - Total $0.00 377 WRC - SAW ACACIA 28674 WRC - SAW Acacia $0.00 WRC - SAW Acacia - Total $0.00 382 WRC SAW BIRMINGHAM 33382 WRC SAW Birmingham $0.00 WRC SAW Birmingham - Total $0.00 379 WRC - SAW COMMERCE TOWNSHIP 33379 WRC - SAW Commerce Township $0.00 WRC - SAW Commerce Township - Total $0.00 386 WRC - SAW ORCHARD LAKE 33386 WRC - SAW Orchard Lake $0.00 WRC - SAW Orchard Lake - Total $0.00 674 WRC - SAW GRANT LABOR 28674 WRC - SAW Grant Labor $0.00 WRC - SAW Grant Labor - Total $0.00 Prepared By: Information Technology; 11/13/2024 Page 21 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 381 WRC SAW GWK 33381 WRC SAW GWK $0.00 WRC SAW GWK - Total $0.00 686 WRC - SAW GRANT LABOR - COMMON TO ALL 60002 WRC - SAW Grant Labor - Common to All $0.00 12686 WRC - SAW Grant - Common to All $0.00 WRC - SAW Grant Labor Common to All- Total $0.00 734 WRC - AMR SUPPORT 73401 WRC - AMR Support $0.00 WRC - AMR Support - Total $0.00 745 WRC - COSDA METER REPLACEMENT 74500 WRC - CODSA Meter Replacement $0.00 WRC - CODSA Meter Replacement - Total $0.00 728 WRC - CO SDS SEWMET 72201 MARS Enhancements - WRC C-O $0.00 WRC - CO SDS SewMet - Total $0.00 729 WRC - EF SDS SEWMET 72202 MARS Enhancements - WRC E-F $0.00 WRC - EF SDS SewMet - Total $0.00 737 WRC - DATA APPLICATION PILOT PRJ 73700 WRC - Data Application Pilot Project $0.00 73710 WRC - Data Appl Prj $0.00 WRC - Data Application Pilot Prj - Total $0.00 300 WRC-GIS ALLOCATION BY LABOR 73300 WRC-GIS Allocation by Labor $0.00 WRC-GIS Allocation by Labor - Total $0.00 277 WRC-GWK PCF-WRC SCADA 74277 WRC - GWK PCF-WRC SCADA $0.00 WRC - GWK PCF-WRC SCADA - Total $0.00 295 WRC HACH WIMS IMPLEMENTATION 67295 WRC-HACH WIMS Implementation $0.00 WRC-HACH WIMS Implementation - Total $0.00 894 WRC - HACH WIMS IMPLEMENTATION 37894 WRC-HACH WIMS Implementation $0.00 WRC-HACH WIMS Implementation - Total $0.00 733 WRC-HYDRO DRAIN PROJECT 73301 WRC-Hydro Drain Project $0.00 WRC-Hydro Drain Project - Total $0.00 671 WRC - INFRASTRUCTURE OP AR 67100 WRC - IO AR $0.00 WRC - Infrastructure Op Ar - Total $0.00 299 WRC-MISS DIG TICKET MGMT SYS 74299 WRC-MISS Dig Ticket Mgmt Sys $0.00 WRC-MISS Dig Ticket Mgmt Sys - Total $0.00 025 WRC OCIT SCADA 74025 WRC OCIT SCADA $0.00 WRC OCIT SCADA - Total $0.00 739 WRC - SCADA COMMON 73900 WRC - SCADA Common $0.00 Prepared By: Information Technology; 11/13/2024 Page 22 of 24 4th Quarter 2024.pdf 4th Qtr 2024 INFORMATION TECHNOLOGY - RESERVE FUND DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 WRC - SCADA Common - Total $0.00 738 WRC - SCADA ENGINEERING ASSESSMT 73800 WRC - SCADA Engineering Assesmnt $0.00 WRC - SCADA Engineering Assesmt - Total $0.00 294 WRC - SEWER FUND 74294 WRC - Sewer Fund $0.00 WRC - Sewer Fund - Total $0.00 067 WRC UTILITY BILLING REPLACEMENT 33067 WRC Utility Billing Replacement 59,827.50 WRC Utility Billing Replacement $59,827.50 801 WRC WALLED LAKE NOVI WWTP 33801 WRC Walled Lake Novi WWTP 0.00 WRC Walled Lake Novi WWTP - Total $0.00 023 WRC WALLED LAKE WATER 35023 WRC Walled Lake Water 0.00 WRC Walled Lake Water - Total $0.00 024 WRC WALLED LAKE SDS 35024 WRC Walled Lake SDS 0.00 WRC Walled Lake SDS - Total $0.00 121 WRC WEBSITE STANDARDIZATION 33121 WRC Website Standardization 0.00 WRC Website Standardization - Total $0.00 $659,108.30 Prepared By: Information Technology; 11/13/2024 Page 23 of 24 4th Quarter 2024.pdf INFORMATION TECHNOLOGY 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Y.T.D. Radio 18020 IT Radio $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Application Services 17040 IT - TOS Fund $0.00 $0.00 $0.00 $0.00 $0.00 17062 Pandemic Program - COVID-19 $0.00 $0.00 $0.00 $0.00 $0.00 17888 IAM Expansion $5,973.25 $26,175.50 $29,119.25 $20,184.50 $81,452.50 17889 ITIM $0.00 $0.00 $0.00 $0.00 $0.00 18000 IMACS Data Warehouse (Funded)$0.00 $0.00 $0.00 $0.00 $0.00 19000 IT Application Services Planned Maint $350,207.25 $414,024.75 431,329.75 $369,805.50 $1,565,367.25 30001 IT Application Services Data Warehouse $11,083.75 $10,087.25 14,896.75 $11,577.50 $47,645.25 30002 IT Application Services Enhanced $56.50 $56.75 155.75 $28.00 $297.00 30003 IT Application Services GIS $111,875.25 $161,249.75 135,961.50 $115,869.00 $524,955.50 30004 IT Application Services eGovernment $275,387.25 $379,494.75 407,293.75 $369,636.00 $1,431,811.75 25108 Courts - Oakland Schools $0.00 $0.00 $0.00 $0.00 $0.00 36901 BS&A Orion Twp - IT $0.00 $0.00 $0.00 $0.00 $0.00 96302 OCSO CCTV Main Jail $0.00 $0.00 $0.00 $0.00 $0.00 App Services - Sub Total: $754,583.25 $991,088.75 $1,018,756.75 $887,100.50 $3,651,529.25 Internal Services 19020 Internal Services Planned Main $14,224.50 $2,038.00 $1,773.75 $3,093.75 $21,130.00 Internal Services - Sub-Total: $14,224.50 $2,038.00 $1,773.75 $3,093.75 $21,130.00 $0.00 Technical Sys/Networking 19030 Tech Sys/Net Planned Maint $115,377.00 $104,974.75 $255,117.75 $282,197.75 $757,667.25 23007 Oracle Support - IT Tech Systems $17.16 $65.78 173.03 $70.51 $326.48 23017 Oracle Support - IT Tech Systems 1.2% 3.96 $15.18 39.93 $16.27 $75.34 24018 SQL Serv Support - IT Tech Systems 2% 39.45 $118.39 64.23 $67.42 $289.49 25400 Oracle Administration 990.00 $165.00 0.00 $0.00 $1,155.00 95685 I.T. - Disaster Recovery 0.00 $0.00 0.00 $0.00 $0.00 95750 I.T. - SEP 146,895.75 $137,258.00 139,052.25 $116,501.50 $539,707.50 95755 I.T. - PeopleSoft Upgrade 0.00 $0.00 0.00 $0.00 $0.00 Tech Sys/Net - Sub-Total: $263,323.32 $242,597.10 $394,447.19 $398,853.45 $1,299,221.06 Information Technology - Total: $1,032,131.07 $1,235,723.85 1,414,977.69 $1,289,047.70 $4,971,880.31 DEVELOPMENT / SUPPORT DETAIL - FOURTH QUARTER 2024 Prepared By: Information Technology; 11/13/2024 Page 24 of 24 4th Quarter 2024.pdf