Loading...
HomeMy WebLinkAboutResolutions - 2026.03.11 - 42796 AGENDA ITEM: FY 2026 First Quarter Forecast and Budget Amendments DEPARTMENT: Fiscal Services MEETING: Board of Commissioners DATE: Wednesday, March 11, 2026 6:00 PM - Click to View Agenda ITEM SUMMARY SHEET COMMITTEE REPORT TO BOARD Resolution #2026-6324 Motion to accept the Fiscal Year 2026 First Quarter Financial Report; to appropriate $14,263,752 of previously budgeted but unspent funds assigned for carryforwards in the General Fund to departments for use; to recognize donations in the Children’s Village Division and the Sheriff’s Office; to authorize the write-off of uncollectible debts, as recommended by the Department of Management and Budget and detailed in the attached schedules; and to amend the FY 2026 – FY 2028 Budgets pursuant to the attached Schedule A budget amendments. ITEM CATEGORY SPONSORED BY Budget Amendment Gwen Markham INTRODUCTION AND BACKGROUND Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of Government, provides for adjustments to the adopted budget. In accordance with Oakland County General Appropriations Act Section 22, which authorizes budget amendments for variances between the budgeted revenue and actual revenue, and Section 23, which authorizes budget amendments for variances between estimated revenue and projected expenditures, amendments are required. The Fiscal Year (FY) 2026 First Quarter Financial Forecast Report has identified several variances and budget amendments are recommended as detailed in the attached Schedule A budget amendment. $14,263,752 of previously budgeted but unspent funds, assigned for carry forwards in the General Fund is requested to be appropriated to departments for use, as reviewed and recommended by the Department of Management and Budget. Children’s Village Division received donations for the period of October 2025 through December 2025 totaling $22,541.01 of which $840 were cash donations. The Sheriff’s Office received a donation in the amount of $500 for the period of October 2025 through December 2025. The Health and Humans Services has requested write-offs totaling $291,592.91 for the period of October 2025 through December 2025 for uncollectible transactions. 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 Ebru Adoglu-Jones, Fiscal Services Supervisor Senior ITEM REVIEW TRACKING Aaron Snover, Board of Commissioners Created/Initiated - 3/11/2026 AGENDA DEADLINE: 02/25/2026 4:30 PM ATTACHMENTS 1. FY 2026 1st Quarter Forecast Report COMMITTEE TRACKING 2026-03-04 Finance - Recommend to Board 2026-03-11 Full Board - Adopt Motioned by: Commissioner Christine Long Seconded by: Commissioner Linnie Taylor Yes: Charles Cavell, Ann Erickson Gault, Marcia Gershenson, Robert Hoffman, Karen Joliat, Christine Long, Penny Luebs, Gwen Markham, Kristen Nelson, Angela Powell, Robert Smiley, Yolanda Smith Charles, Michael Spisz, Linnie Taylor, Philip Weipert, David Woodward (16) No: None (0) Abstain: None (0) Absent: Michael Gingell, Brendan Johnson, William Miller III (3) Passed Power BI Desktop Figure 1 - Amended Budget Revenue 335M (52.95%) 141M (22.32%) 60M (9.41%) 30M (4.67%) 29M (4.56%) 16M (2.47%)(0.27%) 2M Ledger Account TAXES (601000-601999) CHARGES FOR SERVICES (63… OTHER INTER-GOVERNMENT… TRANSFERS IN (695500) STATE GRANTS (615000-6159… INVESTMENT INCOME (655000) INDIRECT COST RECOVERY (… PLANNED USE OF FUND BAL… FEDERAL GRANTS (610000-6… OTHER REVENUES (670000) CONTRIBUTIONS (650000) FY2026-Q1 Financial Forecast Report Table 1 - Revenue Variance by Ledger Ledger Account Amended  Forecast Variance VAR% TAXES (601000-601999)334,956,662 334,956,662 0 0.00% CHARGES FOR SERVICES (630000-635999)141,152,670 144,143,271 2,990,601 2.12% OTHER INTER-GOVERNMENTAL REVENUES (620000 - 626999)59,526,520 59,690,820 164,300 0.28% TRANSFERS IN (695500)29,519,599 29,519,599 0 0.00% STATE GRANTS (615000-615999)28,865,489 28,865,489 0 0.00% INVESTMENT INCOME (655000)15,603,800 15,603,800 0 0.00% INDIRECT COST RECOVERY (640100)11,365,000 11,365,000 0 0.00% PLANNED USE OF FUND BALANCE (665882)9,798,031 9,798,031 0 0.00% FEDERAL GRANTS (610000-610999)1,722,618 1,774,218 51,600 3.00% OTHER REVENUES (670000)33,501 1,105,057 1,071,556 3198.58% CONTRIBUTIONS (650000)0 0 0 Total 632,543,890 636,821,947 4,278,056 0.68% Figure 1 displays the different revenue sources for the General Fund / General Purpose budget. Taxes make up 52.95% of county revenue for Q1, followed by Charges for Services at 22.32% and Other Intergovernmental Revenues at 9.41%. Federal and State grant funding makes up approximately 15% of total revenue. Table 1 displays the forecast and variance for each revenue ledger account. Charges for Services has the highest variance, with $2,990,601 in favorability. This is primarily attributed to 2025 Land Sales proceeds in Treasurer as well as an increase in immunizations in the Health department. The District Court's unfavorability from their fines and fees does substantially offset these favorable lines. Additionally, Other Revenues is favorable $1,071,556 across multiple departments due to Prior Year Revenue adjustments. 001 'OAKIAND~ COUNTY MICHIGAN • • • • • • • • • • • Power BI Desktop Figure 2 - Amended Budget Expenditures 228M (35.99%) 60M (9.5%) 56M (8.92%) 52M (8.21%) 52M (8.2%) 32M (5.06%) 30M (4.71%) 23M (3.58%) 14M (2.18%) 14M (2.16%) 13M (2.1%) 10M (1.56%)(1.11%) 7MDepartment, Court, Commission, … Sheriff Circuit Court Health & Human Services Non Departmental Public Services Prosecuting Attorney Management & Budget District Court County Executive Clerk / Register of Deeds Economic Development FY2026-Q1 Financial Forecast Report Table 2 - Expenditures Variance by Department, Court, Commission, and Office Department, Court, Commission, or Office  Amended Forecast Variance Var% Board of Commissioners7,029,966 6,924,866 105,100 1.52% Circuit Court60,052,984 60,075,384 -22,400 -0.04% Clerk / Register of Deeds13,684,356 13,524,356 160,000 1.18% County Executive13,794,855 11,771,355 2,023,500 17.19% District Court22,651,531 22,712,831 -61,300 -0.27% Economic Development13,275,014 12,788,215 486,800 3.81% Emergency Managagement & Homeland Security3,148,936 3,330,036 -181,100 -5.44% Facilities Management7,680,449 7,505,249 175,200 2.33% Health & Human Services56,366,824 48,778,224 7,588,600 15.56% Human Resources7,005,831 6,758,731 247,100 3.66% Management & Budget29,762,973 28,947,973 815,000 2.82% Non Departmental51,915,235 52,150,466 -235,231 -0.45% Probate Court9,892,299 9,873,299 19,000 0.19% Prosecuting Attorney32,019,689 31,753,689 266,000 0.84% Public Communications5,335,131 5,235,131 100,000 1.91% Public Services51,854,755 51,764,755 90,000 0.17% Sheriff227,572,543 227,321,943 250,600 0.11% Treasurer9,988,733 9,973,733 15,000 0.15% Water Resources Commissioner9,229,282 9,229,282 0 0.00% Total 632,261,386 620,419,517 11,841,869 1.91% Figure 1 displays total budgeted expenditures by Department, Court, Commission, or Office within the General Fund / General Purpose budget. Sheriff makes up 35.99% of all budgeted county expenditures, followed by Circuit Court at 9.5%, Health & Human Services at 8.92%, Non Departmental at 8.21% and Public Services at 8.2%. These five areas account for 70.82% of total budgeted expenditures in General Fund / General Purpose. Table 2 displays the amended budget, forecast, and variance as of Q1 by Department, Court, Commission, or Office. Overall favorability is attributed to Health and Human Resources, driven by $3.6M in Personnel and $3.9M in Operating due to less usage; these costs are based on caseload, difficulty of care, and treatment services order by the courts as appropriate. The County Executive Department is also favorable $2M due primarily to vacancies and timing of operating expenses. 002 'OAKIAND~ COUNTY MICHIGAN • 7 \ • ~ ~ • ---........ • • • • • • • • L R/E Fund Name Division Name Fund # Cost Center (CCN) # Account # Program # Region Fund Affiliate Ledger Account Account Title FY 2026 FY 2027 FY 2028 E Law Enforcement Grants Sheriff's Office - Inv. & Forensic Svcs FND11005 CCN4030901 SC774636 PRG116270 GRN-1004694 770000 Info Tech Ops (149,215) (149,215) (149,215) E Law Enforcement Grants Sheriff's Office - Inv. & Forensic Svcs FND11005 CCN4030901 SC774636 PRG116270 GRN-1004694 770000 Info Tech Ops 149,215 149,215 149,215 Total Expenses -$ -$ -$ R General Fund Grants Investigative & Forensic Services FND10101 CCN4030901 RC610313 PRG110060 GRN-1004513 610000 Reimb Salaries R General Fund Grants Investigative & Forensic Services FND10101 CCN4030901 RC631869 PRG110060 GRN-1004513 630000 Reimb Salaries Total Revenues -$ -$ -$ R General Fund Grants Sheriff's Office Corrective Svcs FND10101 CCN4030301 RC670280 PRG112650 GRN-1004244 670000 Budget Use Only (2,726) (5,168) (628) R General Fund Grants Sheriff's Office Corrective Svcs FND10101 CCN4030301 RC670100 PRG112650 GRN-1004244 670000 Budget Use Only 2,726 5,168 628 Total Revenues -$ -$ -$ R General Fund Sheriff's Office Corrective Svcs FND10101 CCN4030301 RC670100 PRG132320 GRN-1004245 670000 Budget Use Only 2,914 4,811 3,613 R General Fund Sheriff's Office Corrective Svcs FND10101 CCN4030301 RC670100 PRG112650 GRN-1004245 670000 Budget Use Only (2,914) (4,811) (3,613) Total Revenues -$ -$ -$ R Multi Organizational Grants FND11003 CCN1110101 RC610313 PRG115120 GRN-1004581 610000 Federal Operating Grants 62,618 - - R Multi Organizational Grants FND11003 CCN4030501 RC610313 PRG110040 GRN-1004581 610000 Federal Operating Grants (62,618) - - R Multi Organizational Grants FND11003 CCN4030501 RC610313 PRG110005 GRN-1004581 610000 Federal Operating Grants (320,755) - - R Multi Organizational Grants FND11003 CCN4030501 RC670100 PRG110005 GRN-1004581 670000 (4,341) (6,546) (8,747) Total Revenues (325,096.00)$ (6,545.00)$ (8,747.00)$ E Multi Organizational Grants FND11003 CCN4030901 SC702010 PRG110040 GRN-1004581 702000 Salaries Regular (118,179) (4,191) (5,623) E Multi Organizational Grants FND11003 CCN4030901 SC722790 PRG110040 GRN-1004581 722000 Social Security (9,859) (321) (430) E Multi Organizational Grants FND11003 CCN4030901 SC722770 PRG110040 GRN-1004581 722000 Retirement (27,012) (1,142) (1,532) E Multi Organizational Grants FND11003 CCN4030901 SC722810 PRG110040 GRN-1004581 722000 Disability (1,363) (67) (90) E Multi Organizational Grants FND11003 CCN4030901 SC722820 PRG110040 GRN-1004581 722000 Unemployment Insurance (Personnel)(308) (2) (3) E Multi Organizational Grants FND11003 CCN4030901 SC722760 PRG110040 GRN-1004581 722000 Group Life (16,780) (11) (14) E Multi Organizational Grants FND11003 CCN4030901 SC722750 PRG110040 GRN-1004581 722000 Workers Compesation (2,453) (50) (67) E Multi Organizational Grants FND11003 CCN4030901 SC722780 PRG110040 GRN-1004581 722000 Hospitalization (Personnel)(18,991) - - E Multi Organizational Grants FND11003 CCN4030901 SC722800 PRG110040 GRN-1004581 722000 Dental (3,275) - - E Multi Organizational Grants FND11003 CCN4030901 SC722850 PRG110040 GRN-1004581 722000 Optical (2,568) - - E Multi Organizational Grants FND11003 CCN4030501 SC731346 PRG110005 GRN-1004581 730000 Personal Mileage (12,060) - - E Multi Organizational Grants FND11003 CCN4030501 SC732018 PRG110005 GRN-1004581 730000 Travel and Conference (6,000) - - E Multi Organizational Grants FND11003 CCN4030501 SC750399 PRG110005 GRN-1004581 750000 Office Supplies (5,000) - - E Multi Organizational Grants FND11003 CCN4030501 SC731941 PRG110005 GRN-1004581 730000 Training (5,000) - - E Multi Organizational Grants FND11003 CCN1110101 SC702010 PRG115120 GRN-1004581 702000 Salaries Regular 1,569 (729) (945) E Multi Organizational Grants FND11003 CCN1110101 SC722790 PRG115120 GRN-1004581 722000 Social Security 23 (11) (14) E Multi Organizational Grants FND11003 CCN1110101 SC722770 PRG115120 GRN-1004581 722000 Retirement (59) (22) (28) E Multi Organizational Grants FND11003 CCN1110101 SC722820 PRG115120 GRN-1004581 722000 Unemployment Insurance (Personnel)3 - - E Multi Organizational Grants FND11003 CCN1110101 SC722750 PRG115120 GRN-1004581 722000 Workers Compesation 143 - (1) E Multi Organizational Grants FND11003 CCN1110101 SC722750 PRG115120 GRN-1004581 722000 Workers Compesation 59 - - E Multi Organizational Grants FND11003 CCN1110101 SC730373 PRG115120 GRN-1004581 730000 Contracted Services (88,311) - - E Multi Organizational Grants FND11003 CCN1110101 SC731346 PRG115120 GRN-1004581 730000 Personal Mileage (1,675) - - E Multi Organizational Grants FND11003 CCN1110101 SC732018 PRG115120 GRN-1004581 730000 Travel and Conference (3,000) - - E Multi Organizational Grants FND11003 CCN1110101 SC750294 PRG115120 GRN-1004581 750000 Material Supplies (2,500) - - E Multi Organizational Grants FND11003 CCN1110101 SC731941 PRG115120 GRN-1004581 730000 Training (2,500) - - Total Expenditures (325,096.00)$ (6,546.00)$ (8,747.00)$ R General Fund Non Departmental Operations FND10100 CCN9010101 RC665882 PRG196030 665882 Planned Use of Balance 33,055 - - Total Revenues 33,055.00$ -$ -$ E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC731304 PRG180011 730000 Officers Training 482 643 643 E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC750070 PRG180011 750000 Deputy Supplies 1,032 1,376 1,376 E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC750581 PRG180011 750000 Uniforms 525 700 700 E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC730303 PRG180011 730000 Clothing Allowance 506 675 675 E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC772618 PRG180011 770000 Equipment Rental 2,477 3,303 3,303 E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC773535 PRG180011 770000 Info Tech CLEMIS 192 256 256 E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC773637 PRG180011 770000 Info Tech Equipment Rental 821 1,094 1,094 E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC774677 PRG180011 770000 Insurance Fund 3,820 5,093 5,093 E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC778675 PRG180011 770000 Telephone Communications 488 650 650 E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC776661 PRG180011 770000 Motor Pool- Leased Equip 20,808 19,744 19,744 Reimbursement for the Joint Terrorism Task Force Grant -#2024-4497 and #2025-5010; and. Oakland County, Michigan FY 2026 First Quarter Financial Forecast and Budget Amendments Budget Corrections 4747; and. 004 I I R/E Fund Name Division Name Fund # Account # Program # Region Fund Affiliate Ledger Account FY 2026 FY 2027 FY 2028 E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC788001 PRG180011 BFA66100 788001 Transfer Out -Motor Pool 45,000 - - E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC788001 PRG180011 BFA53600 788001 Transfer Out- Radio 15,582 - - E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC788001 PRG180011 BFA63600 788001 Transfer Out -Info Tech 16,515 - - E General Fund Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 730000 Contingency (77,097) (36,073) (36,073) 33,055.00$ -$ -$ R Radio Communications IT Technical Systems and Networking FND53600 CCN1080310 RC695500 PRG115150 BFA10100 695500 Transfer In - Gen Fund 15,582 - - Total Revenue 15,582.00$ -$ -$ E Radio Communications IT Technical Systems and Networking FND53600 CCN1080310 SC796500 PRG115150 796500 Budgeted Equity Adj 15,582 - - Total Expenses 15,582.00$ -$ -$ R CLEMIS Fund IT CLEMIS Operations FND53500 CCN1080305 RC630931 PRG116080 630000 In-Car Terminals 821 1,094 1,094 R CLEMIS Fund IT CLEMIS Operations FND53500 CCN1080305 RC665882 PRG116080 665882 Planned Use of Balance (821) (1,094) (1,094) Total Revenue -$ -$ -$ R Information Technology IT Technical Systems and Networking FND63600 CCN1080601 RC630658 PRG152096 630000 Equipment Rental 2,477 3,303 3,303 R Information Technology IT Technical Systems and Networking FND63600 CCN1080601 RC695500 PRG152096 BFA10100 695500 Transfer In - Gen Fund 16,515 - - R Information Technology IT Technical Systems and Networking FND63600 CCN1080601 RC665882 PRG152096 665882 Planned Use of Balance (16,515) - - Total Revenue 2,477.00$ 3,303.00$ 3,303.00$ E Information Technology IT Technical Systems and Networking FND63600 CCN1080601 SC760188 PRG152096 761000 Depreciation Equipment 2,477 3,303 3,303 Total Expenses 2,477.00$ 3,303.00$ 3,303.00$ R Motor Pool Fund Support Services Leased Vehicles FND66100 CCN1040210 RC695500 PRG184010 BFA10100 695500 Transfer In - Gen Fund 45,000 - - R Motor Pool Fund Support Services Leased Vehicles FND66100 CCN1040210 RC631071 PRG184010 630000 Leased Equipment 14,808 19,744 19,744 R Motor Pool Fund Support Services Leased Vehicles FND66100 CCN1040210 RC631610 PRG184010 630000 Productive Labor 3,000 - - R Motor Pool Fund Support Services Leased Vehicles FND66100 CCN1040210 RC631463 PRG184010 630000 Parts and Accessories 3,000 - - R Motor Pool Fund Support Services Leased Vehicles FND66100 CCN1040210 RC630833 PRG184010 630000 Gas Oil Grease Changes 1,904 2,539 2,539 R Motor Pool Fund Support Services Leased Vehicles FND66100 CCN1040210 RC665882 PRG184010 665882 Planned Use of Balance (51,558) (4,744) (4,744) Total Revenue 16,154.00$ 17,539.00$ 17,539.00$ E Motor Pool Fund Support Services Leased Vehicles FND66100 CCN1040210 SC750210 PRG184010 750000 Gasoline Charges 1,904 2,539 2,539 E Motor Pool Fund Support Services Leased Vehicles FND66100 CCN1040210 SC750413 PRG184010 750000 Parts and Accessories 3,000 - - E Motor Pool Fund Support Services Leased Vehicles FND66100 CCN1040210 SC760188 PRG184010 761000 Depreciation Vehicles 11,250 15,000 15,000 Total Expenses 16,154.00$ 17,539.00$ 17,539.00$ E General Fund Board of Commissioners Administration FND10100 CCN5010101 SC731458 PRG165020 730000 Professional Services 300,000.00$ 300,000.00$ 300,000.00$ E General Fund Board of Commissioners Administration FND10100 CCN5010101 SC731458 PRG180010 730000 Professional Services (300,000.00) (300,000.00) (300,000.00) Total Expenditures -$ -$ -$ R General Fund Grants Family Division FND10101 CCN3010403 RC610313 PRG121240 GRN-1004546 610000 Federal Operating Grants Total Revenues E General Fund Grants Family Division FND10101 CCN3010403 SC730450 PRG121240 GRN-1004546 730000 Defense Atty Fees E General Fund Grants Family Division FND10101 CCN3010403 SC730723 PRG121240 GRN-1004546 730000 Fees Guardian Ad Litem Total Expenditures R General Fund Grants Family Division FND10101 CCN3010403 RC610313 PRG121240 GRN-1004800 610000 Federal Operating Grants Total Revenues E General Fund Grants Family Division FND10101 CCN3010403 SC730450 PRG121240 GRN-1004800 730000 Defense Atty Fees E General Fund Grants Family Division FND10101 CCN3010403 SC730723 PRG121240 GRN-1004800 730000 Fees Guardian Ad Litem Total Expenditures R R Total Revenue -$ -$ -$ E E E E E E E E -$ -$ -$ 005 I I I I I I I I I I I I I I I I I I I I I I R/E Fund Name Division Name Fund # Account # Program # Region Fund Affiliate Ledger Account FY 2026 FY 2027 FY 2028 R Judicial Grants Family Division FND11012 CCN3010402 RC615571 PRG135075 GRN-1004538 615000 State Operating Grants 54,245.00$ 54,245.00$ 54,245.00$ Total Revenue -$ -$ -$ E E E E E E E E -$ -$ -$ R General Fund Grants Emergency Management Division FND10101 CCN1110101 Total Revenues E General Fund Grants Emergency Management Division FND10101 CCN1110101 SC702010 PRG115090 GRN-1004520 702000 Salaries Regular E General Fund Grants Emergency Management Division FND10101 CCN1110101 SC722750 PRG115090 GRN-1004520 722000 Workers Compensation E General Fund Grants Emergency Management Division FND10101 CCN1110101 SC722770 PRG115090 GRN-1004520 722000 Retirement E General Fund Grants Emergency Management Division FND10101 CCN1110101 SC722790 PRG115090 GRN-1004520 722000 Social Security E General Fund Grants Emergency Management Division FND10101 CCN1110101 Total Expenditures E General Fund Non Departmental Transfers FND10100 CCN9090101 E General Fund Emergency Management Division FND10100 CCN1110101 SC702010 PRG115090 702000 Salaries Regular E General Fund Emergency Management Division FND10100 CCN1110101 SC722750 PRG115090 722000 Workers Compensation E General Fund Emergency Management Division FND10100 CCN1110101 SC722770 PRG115090 722000 Retirement E General Fund Emergency Management Division FND10100 CCN1110101 SC722790 PRG115090 722000 Social Security E General Fund Emergency Management Division FND10100 CCN1110101 Total Expenditures E General Fund Emergency Management Division FND10100 CCN1110101 SC731458 PRG115050 730000 Professional Services E General Fund Emergency Management Division FND10100 CCN1110101 SC731458 PRG115090 730000 Professional Services E General Fund Emergency Management Division FND10100 CCN1110101 SC731626 PRG115180 730000 Rent E General Fund Emergency Management Division FND10100 CCN1110101 SC731626 PRG115090 730000 Rent Total Expenditures -$ -$ -$ R Building Safety Division FND63100 CCN1110102 RC665882 PRG145100 665882 Planned Use of Fund Balance Total Reveneus E Building Safety Division FND63100 CCN1110102 SC773535 PRG145100 770000 Info Tech CLEMIS Total Expenditures E Friend of the Court Building Safety Division FND27100 CCN1110102 SC773535 PRG145100 GRN-1004147 770000 Info Tech CLEMIS E Sheriff Friend of the Court FND27100 CCN4030925 SC773535 PRG110070 GRN-1004147 770000 Info Tech CLEMIS E Friend of the Court FND27100 CCN3010404 SC702240 PRG126035 GRN-1004147 702000 Salary Adjustments Total Expenditures E FM&O Fund Building Safety Division FND63100 CCN1110102 SC702010 PRG115090 GRN-1004079 702000 Salaries Regular E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722750 PRG115090 GRN-1004079 722000 Workers Compensation E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722760 PRG115090 GRN-1004079 722000 Group Life E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722770 PRG115090 GRN-1004079 722000 Retirement E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722780 PRG115090 GRN-1004079 722000 Hospitalization E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722790 PRG115090 GRN-1004079 722000 Social Security E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722800 PRG115090 GRN-1004079 722000 Dental E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722810 PRG115090 GRN-1004079 722000 Disability E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722820 PRG115090 GRN-1004079 722000 Unemployment Insurance E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722850 PRG115090 GRN-1004079 722000 Optical E FM&O Fund Building Safety Division FND63100 CCN1110102 SC702010 PRG145100 702000 Salaries Regular E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722750 PRG145100 722000 Workers Compensation E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722760 PRG145100 722000 Group Life E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722770 PRG145100 722000 Retirement E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722780 PRG145100 722000 Hospitalization E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722790 PRG145100 722000 Social Security E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722800 PRG145100 722000 Dental E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722810 PRG145100 722000 Disability E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722820 PRG145100 722000 Unemployment Insurance E FM&O Fund Building Safety Division FND63100 CCN1110102 SC722850 PRG145100 722000 Optical Total Expenditures -$ -$ -$ 006 R/E Fund Name Division Name Fund # Account # Program # Region Fund Affiliate Ledger Account FY 2026 FY 2027 FY 2028 R FMO Fund FMO Administration FND63100 CCN1040701 RC665882 PRG140010 665882 Planned Use of Fund Balance 8,900.00$ 8,900.00$ 8,900.00$ Total Revenues 8,900.00$ 8,900.00$ 8,900.00$ E FMO Fund FMO Administration FND63100 CCN1040701 SC796500 PRG140010 796500 Budgeted Equity Adjustments E FMO Fund Building Safety Division FND63100 CCN1110102 SC796500 PRG145100 796500 Budgeted Equity Adjustments 5,000.00 5,000.00 5,000.00 Total Expenditures 8,900.00$ 8,900.00$ 8,900.00$ E General Fund Health FND10100 CCN1060101 SC730373 PRG135010 730000 Contracted Services (274,794.00)$ -$ -$ E General Fund Health FND10100 CCN1060101 SC730373 PRG133000 730000 Contracted Services 174,794.00$ -$ -$ E General Fund Emergency Management FND10100 CCN1110101 SC731626 PRG115090 730000 Rent 100,000.00$ -$ -$ Total Expenditures -$ R R (66,500.00)$ -$ -$ Total Expenditures -$ -$ -$ E General Fund Non Departmental Transfers FND10100 CCN9090101 SC730359 PRG196030 730000 Contingency E General Fund FND10100 CCN4030501 SC776659 PRG110110 770000 Motor Pool Fuel Charges 3,048.00 4,572.00 4,572.00 E General Fund FND10100 CCN4030501 SC776661 PRG110110 770000 Motor Pool 37,988.00 32,233.00 32,233.00 E General Fund FND10100 CCN4030501 SC788001 PRG110110 BFA53600 788001 Transfer Out - Radio 7,900.00 - - E General Fund FND10100 CCN4030501 SC788001 PRG110110 BFA66100 788001 Transfer Out - Motor Pool 90,000.00 - - Total Capital Costs - - - R Radio Communications IT Technical Systems and Networking FND53600 CCN1080310 RC695500 PRG115150 BFA10100 695500 Transfer In - Gen Fund Total Revenue E Radio Communications IT Technical Systems and Networking FND53600 CCN1080310 SC796500 PRG115150 796500 Budgeted Equity Adj Total Expenses R Motor Pool Fund Facilities Mgmt/Support Svcs FND66100 CCN1040210 RC695500 PRG184010 BFA10100 695500 Transfer In - Gen Fund R Motor Pool Fund Facilities Mgmt/Support Svcs FND66100 CCN1040210 RC631071 PRG184010 630000 Leased Equipment 21,488.00 32,233.00 32,233.00 R Motor Pool Fund Facilities Mgmt/Support Svcs FND66100 CCN1040210 RC631610 PRG184010 630000 Productive Labor 7,500.00 - - R Motor Pool Fund Facilities Mgmt/Support Svcs FND66100 CCN1040210 RC631463 PRG184010 630000 Parts and Accessories 9,000.00 - - R Motor Pool Fund Facilities Mgmt/Support Svcs FND66100 CCN1040210 RC630833 PRG184010 630000 Gas Oil Grease Changes 3,048.00 4,572.00 4,572.00 R Motor Pool Fund Facilities Mgmt/Support Svcs FND66100 CCN1040210 RC665882 PRG184010 665882 Planned Use of Balance (106,988.00) (14,233.00) (14,233.00) Total Revenue E Motor Pool Fund Facilities Mgmt/Support Svcs FND66100 CCN1040210 SC750210 PRG184010 750000 Gasoline Charges E Motor Pool Fund Facilities Mgmt/Support Svcs FND66100 CCN1040210 SC750413 PRG184010 750000 Parts and Accessories 9,000.00$ -$ -$ E Motor Pool Fund Facilities Mgmt/Support Svcs FND66100 CCN1040210 SC760188 PRG184010 761000 Depreciation Vehicles 12,000.00$ 18,000.00$ 18,000.00$ E Motor Pool Fund Facilities Mgmt/Support Svcs FND66100 CCN1040210 SC796500 PRG184010 796500 Budgeted Equity Adjustment -$ -$ -$ Total Expenses 24,048.00$ 22,572.00$ 22,572.00$ R Safer Communities Board of Commissioners FND21275 CCN5010101 RC631970 PRG180012 630000 Safer Community Program 30,000.00$ 30,000.00$ 30,000.00$ Total Revenues 30,000.00$ 30,000.00$ 30,000.00$ E Safer Communities Board of Commissioners FND21275 CCN5010101 SC731598 PRG180012 730000 Regranting Program 30,000.00$ 30,000.00$ 30,000.00$ Total Expenditures 30,000.00$ 30,000.00$ 30,000.00$ 007 I I I I I I I I I I I I I I I I R/E Fund Name Division Name Fund # Cost Center (CCN) # Account # Program # Region Fund Affiliate Ledger Account Account Title FY 2026 FY 2027 FY 2028 R Total Revenue 5,000$ -$ -$ E Total Expenditures 5,000$ -$ -$ R Judicial Grants District Court I Div (Novi)FND11012 CCN3020201 RC615571 PRG121050 GRN-1004823 615000 State Operating Grants 5,478.00$ 5,478.00$ 5,478.00$ Total Revenues 5,478.00$ 5,478.00$ 5,478.00$ E Judicial Grants District Court I Div (Novi)FND11012 CCN3020201 SC730646 PRG121050 GRN-1004823 730000 Equipment Maintenance 4,873.00 4,873.00 4,873.00 E Judicial Grants District Court I Div (Novi)FND11012 CCN3020201 SC750399 PRG121050 GRN-1004823 750000 Office Supplies 605.00 605.00 605.00 Total Expenditures 5,478.00$ 5,478.00$ 5,478.00$ R Judicial Grants District Court IV Div (Troy)FND11012 CCN3020501 RC615571 PRG121050 GRN-1004822 615000 State Operating Grants 9,979.00$ 9,979.00$ 9,979.00$ Total Revenues 9,979.00$ 9,979.00$ 9,979.00$ E Judicial Grants District Court IV Div (Troy)FND11012 CCN3020501 SC750154 PRG121050 GRN-1004822 750000 Expendable Equipment 4,855.00$ 4,855.00$ 4,855.00$ E Judicial Grants District Court IV Div (Troy)FND11012 CCN3020501 SC730646 PRG121050 GRN-1004822 730000 Equipment Maintenance 4,872.00 4,872.00 4,872.00 E Judicial Grants District Court IV Div (Troy)FND11012 CCN3020501 SC750399 PRG121050 GRN-1004822 750000 Office Supplies 252.00 252.00 252.00 Total Expenditures 9,979.00$ 9,979.00$ 9,979.00$ E E E E E -$ -$ -$ grantor does not require a seperate resolution, and interlocal agreement and/or a staffing level change, the budget amendment will be included in the subsequent Management and Budget Quarterly Forecast Report once the grant review process has been completed ; and Oakland County, Michigan FY 2026 First Quarter Financial Forecast and Budget Amendments Grants and grant amendments of $10,000 or less, after review and approval by Management and Budget, Human Resources, Risk Management and Corporation Counsel when the grant does not require an associated interlocal agreement, there are no position changes and the grantor does not require a separate resolution; and less, where the grantor does not require a seperate resolution, and interlocal agreement and/or a staffing level change, the budget amendment will be included in the subsequent Management and Budget Quarterly Forecast Report once the grant review process has been completed ; and 008 I I I I I I I I I I I I I I I I I I R/E Fund Name Division Name Fund # Cost Center (CCN) # Account # Program # Region Fund Affiliate Ledger Account Account Title FY 2026 FY 2027 FY 2028 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 E General Fund Board of Commissioners Administration FND10100 CCN5010101 Total Expenditures -$ -$ -$ E FMO Gas FND63100 CCN1040745 SC731269 PRG148100 730000 Natural Gas E FMO Administration FND63100 CCN1040701 SC731626 PRG140399 730000 Rent Total Expenditures E FMO Building Custodial FND63100 CCN1040718 SC730786 PRG140200 730000 Garbage and Rubbish Disposal (72,000.00)$ (72,000.00)$ (72,000.00)$ E FMO Building Maintenance FND63100 CCN1040719 SC730786 PRG140730 730000 Garbage and Rubbish Disposal 61,000.00 61,000.00 61,000.00 E FMO Grounds Maintenance FND63100 CCN1040725 SC730786 PRG140540 730000 Garbage and Rubbish Disposal 11,000.00 11,000.00 11,000.00 Total Expenditures -$ -$ -$ E FMO Water FND63100 CCN1040760 SC732102 E FMO Grounds Maintenance FND63100 CCN1040725 SC731780 E FMO Grounds Maintenance FND63100 CCN1040725 SC750581 PRG140599 750000 Uniforms (4,049.00) (4,049.00) (4,049.00) E FMO Grounds Maintenance FND63100 CCN1040725 SC750399 E FMO Grounds Maintenance FND63100 CCN1040725 SC750485 PRG140500 750000 Road Salt (5,000.00) (5,000.00) (5,000.00) E FMO Grounds Maintenance FND63100 CCN1040725 SC750224 Total Expenditures -$ -$ -$ E General Fund Support Services Mail Operations FND10100 CCN1040204 SC731115 PRG184020 730000 Licenses and Permits (3,000.00)$ (3,000.00)$ (3,000.00)$ E General Fund Support Services Food Service FND10100 CCN1040203 SC731339 PRG184005 730000 Periodicals Books Publ Sub 1,000.00 1,000.00 1,000.00 E General Fund Support Services Administration FND10100 CCN1040201 SC732018 PRG184030 730000 Travel and Conference 2,000.00 2,000.00 2,000.00 Total Expenditures -$ -$ -$ E E E E E E E E E E E E E E E E E E E Oakland County, Michigan FY 2026 First Quarter Financial Forecast and Budget Amendments Net Neutral Maintenance and adding $11,000 to FMO Grounds Maintenance, which aligns with historical actuals and anticipated expenditures. Additional adjustments include adding $134,500 to Grounds Supplies in FMO Grounds Maintenance by reallocating $116,301 from the Water and Sewer Charges spend category in FMO Water and 009 I I R/E Fund Name Division Name Fund # Account # Program # Region Fund Affiliate Ledger Account FY 2026 FY 2027 FY 2028 -$ -$ -$ E General Fund Workforce Management FND10100 CCN1050401 SC750049 PRG183010 750000 Computer Supplies E General Fund Workforce Management FND10100 CCN1050401 SC750154 PRG183010 750000 Expendable Equipment E General Fund Workforce Management FND10100 CCN1050401 SC750399 PRG183010 750000 Office Supplies E General Fund HR Administration FND10100 CCN1050103 SC750399 PRG183130 750000 Office Supplies E General Fund HR Administration FND10100 CCN1050101 SC750399 PRG183010 750000 Office Supplies E General Fund Workforce Management FND10100 CCN1050401 SC731346 PRG183010 730000 Personal Mileage E General Fund HR Administration FND10100 CCN1050103 SC731346 PRG183130 730000 Personal Mileage E General Fund HR Administration FND10100 CCN1050101 SC731346 PRG183010 730000 Personal Mileage E General Fund Workforce Management FND10100 CCN1050401 SC731388 PRG183010 730000 Printing E General Fund HR Administration FND10100 CCN1050103 SC731388 PRG183130 730000 Printing E General Fund HR Administration FND10100 CCN1050101 SC731388 PRG183010 730000 Printing E General Fund HR Administration FND10100 CCN1050103 SC732018 PRG183130 730000 Travel and Conference E General Fund HR Administration FND10100 CCN1050101 SC732018 PRG183010 730000 Travel and Conference Total Expenditures -$ -$ -$ E Fringe Benefits Benefits Administration FND67800 CCN1050521 SC770631 PRG183190 770000 Bldg Space Cost Allocation E Fringe Benefits Benefits Administration FND67800 CCN1050510 SC770631 PRG183200 770000 Bldg Space Cost Allocation 3,933$ 3,933$ 3,933$ Total Expenditures -$ -$ -$ E General Fund FND10100 CCN4030501 SC702010 PRG110010 702000 Salaries (111,407)$ (115,386)$ (119,365)$ E General Fund FND10100 CCN4030501 SC722790 PRG110010 722000 FICA (8,523) (8,827) (9,131) E General Fund FND10100 CCN4030501 SC722820 PRG110010 722000 Unemployment (59) (59) (58) E General Fund FND10100 CCN4030501 SC722780 PRG110010 722000 Medical (15,340) (16,299) (17,366) E General Fund FND10100 CCN4030501 SC722800 PRG110010 722000 Dental (844) (914) (1,003) E General Fund FND10100 CCN4030501 SC722850 PRG110010 722000 Optical (36) (36) (36) E General Fund FND10100 CCN4030501 SC722810 PRG110010 722000 Disability (1,777) (1,840) (1,903) E General Fund FND10100 CCN4030501 SC722760 PRG110010 722000 Group Life (256) (265) (274) E General Fund FND10100 CCN4030501 SC722770 PRG110010 722000 Retirement (32,858) (33,943) (35,027) E General Fund FND10100 CCN4030501 SC722750 PRG110010 722000 Workers Comp.(1,326) (1,373) (1,420) Total Expenditures (172,426)$ (178,942)$ (185,583)$ E General Fund Sheriff Patrol Services FND10100 CCN4030601 SC702010 PRG110010 702000 Salaries 111,407$ 115,386$ 119,365$ E General Fund Sheriff Patrol Services FND10100 CCN4030601 SC722790 PRG110010 722000 FICA 8,523 8,827 9,131 E General Fund Sheriff Patrol Services FND10100 CCN4030601 SC722820 PRG110010 722000 Unemployment 59 59 58 E General Fund Sheriff Patrol Services FND10100 CCN4030601 SC722780 PRG110010 722000 Medical 15,340 16,299 17,366 E General Fund Sheriff Patrol Services FND10100 CCN4030601 SC722800 PRG110010 722000 Dental 844 914 1,003 E General Fund Sheriff Patrol Services FND10100 CCN4030601 SC722850 PRG110010 722000 Optical 36 36 36 E General Fund Sheriff Patrol Services FND10100 CCN4030601 SC722810 PRG110010 722000 Disability 1,777 1,840 1,903 E General Fund Sheriff Patrol Services FND10100 CCN4030601 SC722760 PRG110010 722000 Group Life 256 265 274 E General Fund Sheriff Patrol Services FND10100 CCN4030601 SC722770 PRG110010 722000 Retirement 32,858 33,943 35,027 E General Fund Sheriff Patrol Services FND10100 CCN4030601 SC722750 PRG110010 722000 Workers Comp.1,326 1,373 1,420 Total Expenditures 172,426$ 178,942$ 185,583$ 010 I I R/E Fund Name Division Name Fund # Cost Center (CCN) # Account # Program # Region Fund Affiliate Ledger Account Account Title FY 2026 FY 2027 FY 2028 E General Fund Non Departmental FND10100 CCN9090101 E General Fund District Court FND10100 CCN3020501 E General Fund District Court FND10100 CCN3020501 E General Fund Health and Human Services FND10100 CCN1060234 E General Fund Health and Human Services FND10100 CCN1060234 E General Fund Health and Human Services FND10100 CCN1060234 Total Expenditures -$ -$ -$ Oakland County, Michigan FY 2026 First Quarter Financial Forecast and Budget Amendments Temporary Business Continuity Positions (TBCP) 011 I I I I I I I I I I I I R/E Fund Name Division Name Fund # Cost Center (CCN) # Account # Program # Region Fund Affiliate Ledger Account Account Title FY 2026 FY 2027 FY 2028 R General Fund Non Departmental FND10100 CCN9010101 Total Revenues 14,263,752 - - E General Fund Circuit Court FND10100 CCN3010101 E General Fund District Court FND10100 CCN3020101 E General Fund Probate Court FND10100 CCN3040403 E General Fund Board of Commissioners FND10100 CCN5010101 E General Fund Human Resources FND10100 CCN1050103 E General Fund Health and Human Services FND10100 CCN1060101 E General Fund Economic Development FND10100 CCN1090201 E General Fund Economic Development FND10100 CCN1090401 E General Fund Economic Development FND10100 CCN1090101 E General Fund Non Departmental FND10100 CCN9090101 E General Fund Non Departmental FND10100 CCN9090101 E General Fund Non Departmental FND10100 CCN9090101 E General Fund Non Departmental FND10100 CCN9010101 E General Fund Non Departmental FND10100 CCN9010101 E General Fund Non Departmental FND10100 CCN9010101 Total Expenditures 14,263,752 - - E General Fund - Grants Health and Human Services FND10101 CCN1060201 Total Expenditures 2,116,675 - - E General Fund - Grants Health and Human Services FND10101 CCN1060201 Total Expenditures 2,116,675 - - Oakland County, Michigan FY 2026 First Quarter Financial Forecast and Budget Amendments FY 2025 Carryforwards 012 I I I I I I I I I I I I I COUNTY OF OAKLAND FY 2026 FIRST QUARTER REPORT - GENERAL FUND GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES SUMMARY BY DEPARTMENT FY 2026 BUDGET AMOUNT ADOPTED AS FY2026 FAVORABLE/ BUDGET AMENDED FORECAST (UNFAVORABLE)PERCENT REVENUES GENERAL FUND Taxes 334,956,662.18$ 334,956,662.18$ 334,956,662.18$ - 0.00% Federal Grants 1,642,656.00 1,722,618.00 1,774,218.00 51,600.00 3.00% State Grants 27,861,800.00 28,865,489.00 28,865,489.00 - 0.00% Other Intergovernmental Revenue 59,526,520.00 59,526,520.00 59,690,820.00 164,300.00 0.28% Charges for Services 141,217,901.00 141,152,670.00 144,143,270.64 2,990,600.64 2.12% Indirect Cost Recovery 11,365,000.00 11,365,000.00 11,365,000.00 - 0.00% Contributions 0.00 0.00 0.00 - Investment Income 15,603,800.00 15,603,800.00 15,603,800.00 - 0.00% Other Revenues 39,751.00 33,501.00 1,105,056.80 1,071,555.80 3198.58% Transfers In 29,148,219.00 29,519,599.00 29,519,599.00 - 0.00% SUB-TOTAL GENERAL FUND/GENERAL PURPOSE 621,362,309.18$ 622,745,859.18$ 627,023,915.62$ 4,278,056.44$ 0.69% PLANNED USE OF FUND BALANCE 6,121,869.00$ 9,798,031.00$ 9,798,031.00$ - TOTAL GF/GP FUNDS 627,484,178.18$ 632,543,890.18$ 627,023,915.62$ 4,278,056.44$ 0.68% EXPENDITURES ADMINISTRATION OF JUSTICE Circuit Court 58,982,580.81$ 60,052,983.81$ 60,075,383.81 (22,400.00)$ -0.04% 52nd District Court 22,504,080.08 22,651,531.08 22,712,831.08 (61,300.00) -0.27% Probate Court 9,824,374.29 9,892,299.29 9,873,299.29 19,000.00 0.19% TOTAL ADMIN. OF JUSTICE 91,311,035.18$ 92,596,814.18$ 92,661,514.18$ (64,700.00)$ -0.07% LAW ENFORCEMENT Prosecuting Attorney 31,577,061.53 32,019,688.53 31,753,688.53 266,000.00 0.83% Sheriff 224,861,882.29 227,572,543.29 227,321,943.29 250,600.00 0.11% TOTAL LAW ENFORCEMENT 256,438,943.82$ 259,592,231.82$ 259,075,631.82$ 516,600.00$ 0.20% GENERAL GOVERNMENT Clerk/Register of Deeds 13,496,029.05 13,684,356.05 13,524,356.05 160,000.00 1.17% Treasurer 9,806,144.48 9,988,733.48 9,973,733.48 15,000.00 0.15% Board of Commissioners 6,748,366.99 7,029,965.99 6,924,865.99 105,100.00 1.50% Water Resources Commissioner 9,011,597.09 9,229,282.09 9,229,282.09 - 0.00% TOTAL GENERAL GOVERNMENT 39,062,137.61$ 39,932,337.61$ 39,652,237.61$ 280,100.00$ 0.70% COUNTY EXECUTIVE County Executive Admn.$13,787,067.63 $13,794,854.63 $11,771,354.63 2,023,500.00 14.67% Management and Budget 29,169,898.63 29,762,972.63 28,947,972.63 815,000.00 2.74% Facilities Management 7,629,123.23 7,680,449.23 7,505,249.23 175,200.00 2.28% Human Resources 6,927,275.58 7,005,830.58 6,758,730.58 247,100.00 3.53% Health and Human Services 55,959,411.54 56,366,823.78 48,778,223.78 7,588,600.00 13.46% Public Services 50,992,092.32 51,854,755.32 51,764,755.32 90,000.00 0.17% Economic Development 13,115,046.20 13,275,014.20 12,788,214.20 486,800.00 3.67% Emergency Management & Homeland Security 3,123,128.23 3,148,936.23 3,330,036.23 (181,100.00) -5.75% Public Communication 5,300,629.80 5,335,130.80 5,235,130.80 100,000.00 1.87% TOTAL COUNTY EXECUTIVE 186,003,673.16$ 188,224,767.40$ 176,879,667.40$ 11,345,100.00$ 6.03% TOTAL DEPARTMENTS 572,815,789.77$ 580,346,151.01$ 568,269,051.01$ 12,077,100.00$ 2.08% Non-Departmental 54,168,388.61$ 51,915,234.61$ 52,150,465.61 (235,231.00) TOTAL GOVERNMENTAL EXPENDITURES 626,984,178.38$ 632,261,385.62$ 620,419,516.62$ 11,841,869.00$ 1.87% General Fund/General Purpose Favorable/(Unfavorable) - Budget Perspective 16,119,925.44$ 16,119,925.44$ 100,000.00$ (9,698,031.00)$ Impact on Fund Balance (Includes Encumbrances)6,321,894.44$ 013 AMOUNT ADOPTED AMENDED FY 2026 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES TAXES (601000-601999) Property Taxes - July Tax Levy 332,036,662.18$ 332,036,662.18$ 332,036,662.18 -$ 0.00% Other Taxes - Delinquent Tax - Prior Years 125,000.00 125,000.00 125,000.00 - 0.00%At budget Marijuana Tax 2,100,000.00 2,100,000.00 2,100,000.00 - 0.00% Treasurer Payment in Lieu of Taxes 600,000.00 600,000.00 600,000.00 - 0.00% Trailer Tax 95,000.00 95,000.00 95,000.00 - 0.00%At budget Total Taxes 334,956,662.18$ 334,956,662.18$ 334,956,662.18$ -$ 0.00% FEDERAL GRANTS (610000-610999) Sheriff - Patrol - 201,070.00 201,070.00 - 0.00% Sheriff - Investigative/Forensic Services 111,592.00 111,592.00 111,592.00 - 0.00% Prosecuting Attorney 300,000.00 300,000.00 300,000.00 - 0.00% Treasurer - - 68,300.00 68,300.00 100.00% Emergency Management and Homeland Security 29,168.00 37,795.00 21,095.00 (16,700.00) -44.19% Health Division 651,896.00 722,161.00 722,161.00 - 0.00% Children's Village 250,000.00 250,000.00 250,000.00 - 0.00% Circuit Court - Family Division 300,000.00 100,000.00 100,000.00 - 0.00% Total Federal Grants 1,642,656.00$ 1,722,618.00$ 1,774,218.00$ 51,600.00$ 3.00% STATE GRANTS (615000-615999) Sheriff - Emergency Response and Prep 308,500.00$ 308,500.00$ 308,500.00$ -$ 0.00% Prosecuting Attorney - 87,542.00 87,542.00 - 0.00% Clerk - County Clerk 23,000.00 23,000.00 23,000.00 - 0.00% Health Division 8,054,999.00 8,729,417.00 8,729,417.00 - 0.00%At budget Economic Development - Veteran's Services - 149,000.00 149,000.00 - 0.00% Non-Departmental - Child Care Subsidy 19,475,301.00 19,568,030.00 19,568,030.00 - 0.00% Total State Grants 27,861,800.00$ 28,865,489.00$ 28,865,489.00$ -$ 0.00% OTHER INTER-GOVERNMENTAL REVENUES (620000 - 626999) Non-Departmental 57,163,500.00$ 57,163,500.00$ 57,163,500.00$ -$ 0.00% Emergency Management - Homeland Security 9,000.00 9,000.00 9,000.00 - 0.00% Circuit Court- Civil Criminal 200,500.00 200,500.00 406,600.00 206,100.00 102.79% District Court 1,800.00 1,800.00 - (1,800.00) -100.00% for each District Court. To review to see if budget is required to support periodic activity. Sheriff 50,000.00 50,000.00 10,000.00 (40,000.00) -80.00% of inmates receiving social security. Funds are collected from jail inmates who receive SSI to Non-Departmental - Reimb Judges Salaries 2,101,720.00 2,101,720.00 2,101,720.00 - 0.00% Total Other Intergovernmental Revenue 59,526,520.00$ 59,526,520.00$ 59,690,820.00$ 164,300.00$ 0.28% CHARGES FOR SERVICES (630000-635999) Administration of Justice Circuit Court - Civil/Criminal 719,100.00$ 719,100.00$ 746,300.00$ 27,200.00$ 3.78% COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FISCAL YEAR 2026 FIRST QUARTER REPORT 014 AMOUNT ADOPTED AMENDED FY 2026 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FISCAL YEAR 2026 FIRST QUARTER REPORT Circuit Court - Family Division 205,033.00 205,033.00 212,733.00 7,700.00 3.76%Fav. primarily due to $7,700 in Board and Care based on child care fund chargeback activity. District Court - Division I (Novi)2,724,700.00 2,724,700.00 1,908,400.00 (816,300.00) -29.96% Service Oversight ($84,700), Probation Fees ($246,900), Filing Fees DCU ($20,200), Show Cause Fee ($30,400), and State Law Costs ($105,200) due to caseload decreases. District Court - Division II (Clarkston)1,380,800.00 1,380,800.00 1,015,500.00 (365,300.00) -26.46% District Court - Division III (Rochester Hills)2,991,500.00 2,991,500.00 1,995,000.00 (996,500.00) -33.31% ($104,500), and Drunk Driving Caseflow DDCAF ($25,000) due to caseload decreases. District Court - Division IV (Troy)1,233,250.00 1,233,250.00 1,102,050.00 (131,200.00) -10.64% ($75,500), Refund Fees PD Def Attorney ($9.800), Reimb Interpreter Fees ($6,900), Show Cause Fees ($6,500) and Warrant Recall Fees ($6,800) due to caseload decreases. Probate Court - Estates and Mental Health 687,675.00 687,675.00 481,675.00 (206,000.00) -29.96% ($77,500), Miscellaneous Petitions ($20,100) and Statement and Proof of Claim ($15,000) Total Administration of Justice 9,942,058.00$ 9,942,058.00$ 7,461,658.00$ (2,480,400.00)$ -24.95% Law Enforcement Prosecuting Attorney 956,218.00$ 830,137.00$ 830,137.00 - 0.00% Sheriff's Office 2,900.00 2,900.00 2,900.00 - 0.00% Sheriff - Administrative Services 3,500.00 3,500.00 3,500.00 - 0.00% Sheriff - Corrective Services 3,315,375.00 3,173,482.00 3,274,282.00 100,800.00 3.18% by Unfav. Diverted Felon ($179,000), Inmate Board and Care ($191,600), and Reimb Sheriff - Corrective Services Satellites 1,001,854.00 893,534.00 893,534.00 - 0.00% Sheriff - Patrol Services 81,095,632.00 81,431,191.00 81,431,191.00 - 0.00% Sheriff - Emergency Communications Operations 3,825,133.00 3,825,133.00 3,825,133.00 - 0.00% Sheriff - Technology Information and Innovation Division 210,000.00 210,000.00 295,100.00 85,100.00 40.52% Sheriff - Investigative Forensic Services 631,670.00 602,174.00 602,174.00 - 0.00% Total Law Enforcement 91,042,282.00$ 90,972,051.00$ 91,157,951.00$ 185,900.00$ 0.20% General Government Clerk - County Clerk 2,398,100.00 2,398,100.00 2,398,100.00 - 0.00% Clerk - Elections 223,500.00 223,500.00 283,500.00 60,000.00 26.85% Clerk - Register of Deeds & Micrographics 12,998,500.00 12,998,500.00 12,998,500.00 - 0.00% Treasurer 3,411,100.00 3,411,100.00 6,474,800.00 3,063,700.00 89.82% Board of Commissioners 3,700.00 3,700.00 3,700.00 - 0.00% Water Resources Commissioner 4,109,394.00 4,109,394.00 4,109,394.00 - 0.00% Total General Government 23,144,294.00$ 23,144,294.00$ 26,267,994.00$ 3,123,700.00$ 13.50% County Executive Emergency Management and Homeland Security -$ -$ 900.64$ 900.64$ 100.00% M&B - Equalization Division 3,953,306.00 3,953,306.00 3,953,306.00 - 0.00% M&B - Fiscal Services Division 192,660.00 192,660.00 192,660.00 - 0.00% M&B - Purchasing Division 469,528.00 469,528.00 469,528.00 - 0.00% Facilities Management - Support Services 386,000.00 386,000.00 389,700.00 3,700.00 0.96% 015 AMOUNT ADOPTED AMENDED FY 2026 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FISCAL YEAR 2026 FIRST QUARTER REPORT HHS - Health Division 5,087,603.00 5,087,603.00 6,994,403.00 1,906,800.00 37.48%Fav. Due to increase in fees for Immunizations $760,000, Rabies Vaccines $886,200, Laboratory Charges 3rd Party $127,900; partially offset by unfav. Vaccine expenditure due to Public Services - Community Corrections 10,000.00 10,000.00 10,000.00 - 0.00% Public Services - Medical Examiner 620,225.00 620,225.00 620,225.00 - 0.00% Public Services - Children's Village 4,588,987.00 4,588,987.00 4,588,987.00 - 0.00% Public Services - Animal Control 1,164,250.00 1,169,250.00 1,169,250.00 - 0.00% Total County Executive 16,789,267.00$ 16,794,267.00$ 18,955,667.64$ 2,161,400.64$ 12.87% Non-Departmental Non-Dept - Charges for Services 300,000.00$ 300,000.00$ 300,000.00 - 0.00% Total Non-Departmental 300,000.00$ 300,000.00$ 300,000.00$ -$ 0.00% Total Charges for Services 141,217,901.00$ 141,152,670.00$ 144,143,270.64$ 2,990,600.64$ 2.12% INDIRECT COST RECOVERY (640100)11,365,000.00$ 11,365,000.00$ 11,365,000.00 -$ 0.00%At budget. CONTRIBUTIONS (650000) Total Contributions Revenues -$ -$ -$ -$ 0.00% INVESTMENT INCOME (655000) District Courts (Div. I - IV)1,300.00$ 1,300.00$ 1,300.00$ -$ 0.00% Treasurer 600,000.00 600,000.00 600,000.00 - 0.00% Clerk/Register of Deeds 2,500.00 2,500.00 2,500.00 - 0.00% Non-Departmental 15,000,000.00 15,000,000.00 15,000,000.00 - 0.00% Total Investment Income 15,603,800.00$ 15,603,800.00$ 15,603,800.00$ -$ 0.00% OTHER REVENUES (670000) Circuit Court - - 73,400.00 73,400.00 100.00% District Courts (Div. I - IV)- - 92,445.80 92,445.80 100.00% due to the reclassification of invoices from Court Reporter Services to the Crime Victim Sheriff Office - - 1,800.00 1,800.00 100.00% Sheriff - Corrective Services (1,562.00) 4,078.00 4,078.00 - 0.00% Sheriff - Patrol Services 12,000.00 12,000.00 177,700.00 165,700.00 1380.83% Sheriff - Investigative/Forensic Svc 3,000.00 3,000.00 16,000.00 13,000.00 433.33% Prosecuting Attorney Administration 11,890.00 - 36,500.00 36,500.00 100.00% Treasurer - - 206,800.00 206,800.00 100.00% 1004166 ) Facilities Management - Support Services 1,500.00 1,500.00 1,500.00 - 0.00% Emergency Management and Homeland Security 12,923.00 12,923.00 23.00 (12,900.00) -99.82% 016 AMOUNT ADOPTED AMENDED FY 2026 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FISCAL YEAR 2026 FIRST QUARTER REPORT Public Services - Children's Village - Other Revenues - - 235,910.00 235,910.00 100.00%Revenue for prior year's income. Non-Dept - Sundry - - 256,700.00 256,700.00 100.00% Total Other Revenues 39,751.00$ 33,501.00$ 1,105,056.80 1,071,555.80$ 3198.58% TRANSFERS IN (695500) Circuit Court - Transfers In 17,487.00$ 17,487.00$ 17,487.00$ -$ 0.00% Prosecuting Attorney- Admin- Transfers In - 149,059.00 149,059.00 - 0.00%GRN-1004795 FY2026 Prosecutor Auto Theft Prevention Authority (ATPA) Board of Commissioners 100,000.00 100,000.00 100,000.00 - 0.00% Health and Human Services Administration - Transfers In 117,545.00 117,545.00 117,545.00 - 0.00% Health Division - Transfers In - - 0.00% Neighborhood & Housing Development Administration 500,000.00 500,000.00 500,000.00 0.00% Treasurers' Transfers In 2,700,000.00 2,700,000.00 2,700,000.00 - 0.00% Non-Departmental - Transfers In 25,713,187.00 25,935,508.00 25,935,508.00 - 0.00% Total Transfers In Revenues 29,148,219.00$ 29,519,599.00$ 29,519,599.00 -$ 0.00% PLANNED USE OF FUND BALANCE (665882) Encumbrances and Carry forwards -$ 3,174,769.00$ 3,174,769.00$ -$ 0.00% Use of Prior Yrs Fund Balance 6,121,869.00 6,623,262.00 6,623,262.00 - 0.00% Total Planned Use of Fund Balance 6,121,869.00$ 9,798,031.00$ 9,798,031.00$ -$ 0.00% TOTAL GEN. FUND / GEN. PURPOSE REVENUE 627,484,178.18$ 632,543,890.18$ 636,821,946.62$ 4,278,056.44$ 0.68% 017 Adopted Amended Actuals Favorability/UNF Percentage $58,862,580.81 $60,052,983.87 $60,075,383.87 ($22,400.00)-0.04% $33,251,924.00 $34,079,865.00 $34,097,765.00 ($17,900.00)-0.05% $12,155,184.00 $12,195,553.00 $12,200,053.00 ($4,500.00)-0.04% $6,602,120.81 $6,804,213.81 $6,804,213.81 $0.00 0.00% $6,853,352.00 $6,973,352.00 $6,973,352.00 $0.00 0.00% Circuit Court FY 2026 Q1 Forecast Total Summary • At budget. • Court Business division unfavorability primarily driven by ($136,900) due to Defense Atty Fees ($127,300) and Fees Guardian Ad Litem ($6,900) due to the Circuit Court tracking the contract for one vendor in the Business Division while slowly eliminating multiple vendors in the Family Division. This will eventually return to the Family Division. • Civil/Criminal division at budget. • Judicial Administration division at budget. • Court Business division at budget. • Civil/Criminal division at budget. Internal • Family division favorability primarily attributed to Defense Atty Fees $127,300 and Fees Guardian Ad Litem $6,900 due to the Circuit Court tracking the contract for one vendor in the Business Division while slowly eliminating multiple vendors in the Family Division. This will eventually return to the Family Division. Also favorability driven by $2,200 of Membership Dues being paid in the Administration Division. • Family division at budget. Personnel • Judicial Administration division unfavorablility primarily driven by ($1,400) in Tuition Reimbursement and ($2,200) in Membership Dues, which was offset as favorability in the Family division. • Unfavorability primarily driven by Other Miscellaneous Salaries ($8,200) for Merit Max and Signing Bonuses. Also, unfavorability due to Overtime ($9,700). Operating Transfers 018 Adopted Amended Actuals Favorability/UNF Percentage $22,504,080.08 $22,651,531.00 $22,712,831.00 ($61,300.00)-0.27% $17,582,570.56 $17,601,283.56 $17,609,683.56 ($8,400.00)-0.05% $2,443,371.00 $2,500,991.00 $2,553,891.00 ($52,900.00)-2.12% $2,478,138.52 $2,549,256.52 $2,549,256.52 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 0.00% • Clarkston Division: at budget. • Troy Division: at budget. • Clarkston Division: at budget. • Rochester Hills Division: at budget. • Rochester Hills Division: at budget. • Clarkston Division:at budget. Personnel • Admin Division: unfavorable partially attributed to the Weekend Arraignment Program ($8,400). Operating Transfers • No transfers out occuring for FY2026. • Admin Division: at budget. • Novi Division: unfavorable ($30,900) due to increase costs in Interpreter Fees based on increase demand. • Rochester Hills Division: unfavorable due to increased costs in Interpreter Fees based on increased demand; this is a mandated, uncontrollable expense. • Admin. Division: at budget • Novi Division: at budget Internal • Troy Division: at budget. • Troy Division: at budget. • Novi Division: at budget. District Court FY2026 Q1 Forecast Total Summary 019 Adopted Amended Forecast Favorability/UNF Percentage $9,824,374.29 $9,892,299.71 $9,873,299.71 $19,000.00 0.19% $6,486,085.35 $6,486,085.35 $6,486,085.35 $0.00 0.00% $1,701,052.00 $1,704,092.00 $1,704,092.00 $0.00 0.00% $1,637,236.94 $1,702,121.94 $1,683,121.94 $19,000.00 1.12% $0.00 $0.00 $0.00 $0.00 0.00%Transfers • No transfers out occuring for FY2026. • At Budget. • Probate Administration at budget. •  Estates & Mental Health favorability of $19,900 for Info Tech CLEMIS; based on budget allocation and use. Internal Personnel •  At Budget Operating Probate Court FY 2026 Q1 Forecast Total Summary of Projections 020 Adopted Amended Forecast Favorability/UNF Percentage $31,577,061.53 $32,019,688.53 $31,753,688.53 $266,000.00 0.83% $25,487,693.45 $25,741,275.45 $25,491,275.45 $250,000.00 0.97%Personnel  Fav. Due to vacanies. Overtime Usage is $4,747 out of an allocated budget of $7,840 for PA Appellate division. Operating Prosecuting Attorney FY 2026 Q1 Forecast Total Summary of Projections  At Budget. Overtime Usage is $3,386 out of an allocated budget of $4,679. On Call Usage is $2,920 out of an allocated budget of $10,800 for PA Administration division.  At budget. Overtime Usage is $1,302 out of an allocated budget of $28,000. Holiday Overtime usage is $566 with no associated budget allocation. On Call Usage is $2,800 out of an allocated budget of $25,400 for PA Warrant division.  At budget. Overtime Usage is $34,832 out of an allocated budget of $17,000. Holiday Overtime usage is $1,757 with no associated budget allocation. On Call Usage is $18,520 out of an allocated budget of $36,600 for PA Litigation division. Transfers  At budget.  Administration: Fav. Computer Research Service $17,200, Expert Witness Fee and Mileage $25,000, Witness Fees and Mileage $30,500, and Office Supplies $35,000 offset by Unfav. Court Transcripts ($4,000), Direct Client Services ($9,000), Membership Dues ($192,600), Professional Services ($47,700), and Travel and Conference ($16,600). Forecast consistent with historic usage. Warrants: Fav. Personal Mileage $2,000 due to less than anticipated use.  Litigation: Unfav. Due to an allocation issue with Motor Pool Fuel Charges and Motor Pool. Offset by Administration budget. Subsequent budget amendment will be required. Internal 021 Adopted Amended Forecast Favorability/UNF Percentage $224,861,882.29 $227,572,543.29 $227,321,943.29 $250,600.00 0.11% $172,871,400.32 $172,896,084.32 $172,896,084.32 $0.00 0.00%Personnel Operating Sheriff's Office FY 2026 Q1 Forecast Total Summary of Projections  At Q1 Salaries and Fringe Benefits is at budget across divisions.  Sheriff's Office: • Fav. Communications $3,000, Membership Dues $2,500 and Office Supplies $8,000. Less than expected but consistent wiith historical usage. Administrative Services: • Fav. Printing $47,100, Uniform Cleaning $31,100, Deputy Supplies $38,400. Less than anticipated usage.  Corrective Services - Satellites: Fav. Printing $47,100, Uniform Cleaning $31,100, and Deputy Supplies $38,400. Less than anticipated usage.  Emergency Response and Preparedness: • Fav. K-9 Program $15,000, Officers Training $178,500, and Professional Services $85,900. Less than expected usage but consistent with historical usage.  Patrol Services: Unfav. Equipment Maintenance ($328,100) due to emergent maintenance needs and increased costs. Slightly offset by Fav. Other Expendable Equipment $124,200 due to less need.  Emergency Communications Operations: Fav. Equipment Maintenance $68,000, and Software Support Maintenance $57,600. Less than anticipated usage.  Investigative/Forensic Services: • Fav. Software Support Maintenance $25,000, Travel and Conference $10,000, Laboratory Supplies $81,800, Office Supplies $11,000. Offset by Unfav. Expendable Equipment ($23,000) and Forensic Lab Enhancment ($81,000).  Sheriff's Office: Fav. Info Tech Operations $338,500 due to budget allocation and usage.  Emergency Response and Preparedness: Fav. Info Tech Operations $171,500. Less than expected usage.  Patrol Services: Fav. Motor Pool Fuel Charges $181,600, and Motor Pool $174,300. Less than anticipated usage.  Technology Information & Innovation: • Fav. Equipment Rental $9,100, Info Tech CLEMIS $4,500, and Motor Pool $12,400.  Investigative/Forensic Services: Unfav. Info Tech Operations ($590,000), and Motor Pool ($93,000) due to budget allocation and usage. Internal 022 $1,023,874.00 $1,565,231.00 $1,702,231.00 ($137,000.00)-8.75%Transfers  Emergency Response and Preparedness: Unfav. Transfer of 3 vehicles from GF to motor pool. ($90,200). Subsequent budget amendment will be required.  Patrol Services: Unfav. Due to transferring $46,800 from GF to motor pool for 2nd of two vehicles (Res. #2025- 5270). Subsequent budget amendment will be required.  Investigative/Forensic Services: At budget. ATPA and Byrne NET Assistance Grants. 023 Adopted Amended Forecast Favorability/UNF Percentage $13,496,029.05 $13,684,356.05 $13,524,356.05 $160,000.00 1.17% $9,683,493.16 $9,688,958.16 $9,528,958.00 $160,000.00 1.65% Transfers  No transfers made in FY 2026.  Operating Expenditures are at budget for Q1.  Internal Support Expenditures are at budget for Q1. Internal Personnel  Fav. Salaries and Fringe Benefits due to vacancies and turnover.  Administration Division $20,000,  Countt Clerk Division $200,000, and Register of Deeds $80,000.  This is partially offset by Elections at  ($140,000) due to election activities, to be offset by General Reimbursement from the State (Per Diem  budgeted at $122,000 and current spending at $191,000). Operating Clerk/Register of Deeds 2026 Q1 Forecast Total Summary of Projections  Department wide Overtime budgeted at $41,500 with current 1st quarter spending at $12,300 (Elections  overtime budget $28,500 and 1st quarter actauals at $11,900).  024 Adopted Amended Forecast Favorability/UNF Percentage $9,806,144.48 $9,988,733.48 $9,796,609.48 $15,000.00 0.15% $4,384,434.40 $4,389,899.40 $4,374,899.40 $15,000.00 0.34% Transfers  Transfers are at budget for Q1.  Operating Expenditures are at budget for Q1.  Internal Support Services are at budget for Q1. Internal Personnel  Fav. Salaries and Fringe Benefits due to vacancies and turnover.  Operating Treasurer 2026 Q1 Forecast Total Summary of Projections  Department Overtime budgeted at $10,000 current 1st quarter spending is $3,200. 025 Adopted Amended Forecast Favorability/UNF Percentage $6,748,366.99 $7,029,965.99 $6,924,865.99 $105,100.00 1.50% $4,282,172.23 $4,282,172.23 $4,209,672.23 $72,500.00 1.69% $1,948,841.00 $2,227,566.00 $2,208,966.00 $18,600.00 0.83% $517,353.76 $520,227.76 $506,227.76 $14,000.00 2.69% $0.00 $0.00 $0.00 $0.00 Transfers • No Transfers Out for FY 2026 Q1. • Favorable Computer Supplies $10,500 and Office Supplies $4,000 as these budgets are used periodically as needed and vary each year with department activities. • Favorable Info Tech Operations $15,000 partially offset by unfavorable Info Tech Managegd Print Services ($1,000) due to usage and allocation. Internal Personnel • Favorable Salaries and Fringe Benefits due to turnover. There are no charges in their $3,500 Overtime budget in Q1. Operating Board of Commissioners 2026 Q1 Forecast Total Summary of Projections 026 Adopted Amended Unaudited Actuals Favorability/UNF Percentage $9,011,597.09 $9,229,282.09 $9,229,282.09 $0.00 0.00% $269,940.72 $275,405.72 $275,405.72 $0.00 0.00% $584,657.00 $734,657.00 $734,657.00 $0.00 0.00% $8,100,834.37 $8,163,054.37 $8,163,054.37 $0.00 0.00% $56,165.00 $56,165.00 $56,165.00 $0.00 0.00% •  Forecast for Operating Expenditures projected to be at budget. Water Resources Commissioner 2026 Q1 Forecast Total Summary Personnel •  Forecast for Personnel Expenditures projected to be at budget . Operating Transfers • Transfers Out for Drainage Districts will occur at Fiscal Year End. Internal •  Forecast for Internal Support Expenditures projected to be at budget. 027 Adopted Amended Forecast Favorability/UNF Percentage $13,787,067.63 $13,794,854.63 $11,031,154.53 $2,023,500.00 20.03% $8,882,152.13 $8,889,133.13 $8,326,733.13 $562,400.00 6.33% $1,325,105.00 $1,325,712.00 $424,912.00 $900,800.00 67.95% $1,696,189.50 $1,701,875.50 $1,141,575.50 $560,300.00 32.92% $1,883,621.00 $1,878,134.00 $1,878,134.00 $0.00 0.00% Personnel  Favorability in salaries and fringes due to turnover and vacancies in the Office of Sustainability, County Executive Administration, Corporation Counsel and Compliance divisions. Operating County Executive FY 2026 Q1 Forecast Total Summary of Projections  Transfer Out of $1,883,621 grant match for Mandated Indigent Defense Commisssion.  Admin Favorability primarily attributed to $73,800 in Professional Services, $100,000 in Regranting Program, $31,200 in Travel and Conference, and $25,000 in Special Projects due to timing of expenses.  Compliance Office Favorability primarily attributed to Professional Services $162,900 and Software Rental Lease Purchase $9,600 due to less than anticipated use.  Corporation Counsel Favorability primarily attibuted to $17,800 Computer Research Service and $6,300 Expendable Equipment due to less utilization of budget.  Forecasted favorability of $446,300 in Strategic Partnerships & Initiatives, $150,700 in County Executive Administration and $62,500 in Compliance Office due to budget allocation. Partially offset by unfavorability within Performance Management ($114,000) due to Invizio payment budget allocation. Internal  Diversity, Equity, & Inclusion Favorability primarily due to $108,600 in Professional Services, $86,400 in Workshops and Meetings, $38,000 in Special Event Program due to less than anticipated use.  Indigent Defense Services Office unfavorable due to ($5,600) Tuition Reimbursement Expense that cannot be charged to MIDC grant  Office of Sustainability Favorability primarily attributed to $50,000 in Professional Services due to lack of usage. Also favorable $39,600 Speacial Event Supplies, $17,500 Training, and $13,200 in Travel and Conference due to less utilization of budget.  Strategic Partnertships & Initiatives Favorable Travel and Conference $4,000 due less utilization of budget. 028 Adopted Amended Forecast Favorability/UNF Percentage $29,169,898.63 $29,762,972.63 $26,648,178.91 $815,000.00 2.74% $23,566,585.16 $23,618,871.16 $22,803,871.16 $815,000.00 3.45%Personnel  Favorability Salaries and Fringe Benefits due to vacancies and turnover in Fiscal Services,Purchasing, and Equalization divisions. Operating Management & Budget 2026 Q1 Forecast Total Summary of Projections  Department Overtime budgeted at $98,100 with 1st quarter spending at $24,000. perating Expenditures are at budget for Q1. Transfers Transfers are at budget for Q1. Internal Support Expenditures are at budget for Q1. Internal 029 Adopted Amended Forecast Favorability/UNF Percentage $7,629,123.23 $7,680,449.23 $7,505,249.23 $175,200.00 2.28% $4,069,391.90 $4,069,391.90 $3,919,891.90 $149,500.00 3.67% $2,117,074.00 $2,166,098.00 $2,149,898.00 $16,200.00 0.75% $1,442,657.33 $1,444,959.33 $1,435,459.33 $9,500.00 0.66% $0.00 $0.00 $0.00 $0.00 0.00% Personnel Operating Facilities Management 2026 Q1 Forecast Total Summary of Projections • Facilities Management Administration: At budget. • Support Services: Favorable Salaries and Fringe Benefits due to a vacancy. They have used $1,400 out of a $13,500 Overtime budget. • Facilities Engineering: Favorable Salaries and Fringe Benefits due to a vacancy. They have used $600 out of a $25,000 Overtime budget and $0 out of a $500 Holiday Overtime budget. • Capital Planning and Design: Favorable Salaries and Fringe Benefits due to a vacant position that was recently filled. Transfers • No Transfers Out in FY2026 Q1. • Facilities Management Administration: At budget. • Facilities Management Administration: At budget. Internal • Support Services: Favorable Maintenance Contract $7,000 due to current contract rates for mail sorter and postage machine maintenance. Also favorable Contracted Services $4,400, as this budget serves a contigent need in the event there is a sorter issue and contract service is needed for repair. • Facilities Engineering: Favorable Software Rental Lease Purchsae $3,500, as the division does not anticipate new software purchases for this year. • Capital Planning and Design: At budget. • Support Services: Favorable Info Tech Operations $8,000 due to budget allocation and usage. • Facilities Engineering: Favorable Motor Pool $1,800 due to budget allocation. • Capital Planning and Deisgn: At budget. 030 Adopted Amended Forecast Favorability/UNF Percentage $6,927,275.58 $7,005,830.58 $6,758,730.58 $247,100.00 3.53% $4,281,251.46 $4,281,251.46 $3,930,351.46 $350,900.00 8.20% $861,845.00 $867,721.00 $972,221.00 ($104,500.00)-12.04% $1,784,179.12 $1,856,858.12 $1,856,158.12 $700.00 0.04% $0.00 $0.00 $0.00 $0.00 0.00% Personnel • HR Administration Division: Favorable Salaries and Fringe Benefits due to turnover. Operating Human Resources 2026 Q1 Forecast Total Summary of Projections • Workforce Management Division: Favorable Salaries and Fringe Benefits due to vacancies and turnover. They have used $6,100 out of a $17,000 Overtime budget. Transfers • No Transfers Out in FY 2026 Q1. • HR Administration Division: Unfavorable Legal Services ($30,000) due to a matter requiring use of a third party. • HR Administration Division: Favorable Info Tech Operations $99,000, which is offset in the Workforce Division due to costing of invoices between divisions; a quarterly amendment may be needed to reallocate budget from the HR Admin Division to the Workforce Management Division to align with acutals. Internal • Workforce Management Division: Unfavorable Software Rental Lease Purchase ($89,900) primarily due to their job description software JDx and for the recruiting software transition from ICIMS to Workday. Partially offset by favorable Office Supplies $9,000, which will be adjusted with a Q1 amendment reallocating the budget in this line to the Administration Division to align with their anticpiated actuals. • Workforce Management Division: Unfavorable Info Tech Operations ($99,000), which is offset from the favorability of the HR Administration Division due to costing of invoices bewteen divisions; a quarterly amendment may be needed to reallocate budget from their Admin division to their Workforce Management Division to align with the actuals. 031 Adopted Amended Forecast Favorability/UNF Percentage $56,459,411.54 $56,649,328.54 $48,778,223.78 $7,588,600.00 13.40% $41,213,923.68 $41,261,121.68 $37,649,821.68 $3,611,300.00 8.75% $9,732,841.00 $9,760,540.00 $5,538,635.24 $3,939,400.00 40.36% $4,873,002.86 $4,988,022.86 $4,950,122.86 $37,900.00 0.76% $639,644.00 $639,644.00 $639,644.00 $0.00 0.00%Transfers • Transfers on budget • Administration: Favorable Child Abuse Neglect Council $110,000, Human Services Agency $894,200, PVT INST Foster CY PD $225,500, Pvt Inst Resid Cy Pd $1,478,300, Private Institutions $565,200, and Supportive Services $275,800 due to these expenditures are based on caseload, difficulty of care, and treatment services ordered by the Courts and there is less than anticipated use at this time . Also favorable Professional Services $591,200 due to timing of expenses. Partially offset by unfavorable Foster Board Home CY PD ($293,200) due to timing of receipt of reimbursement of expenses • Overall due to budget allocation and useage • Health & Human Services Administration favorable Info Tech Operations $56,600 and Info Tech Managed Print Svcs $3,100 • Health Division favorable Equipment Rental $27,500, Motor Pool $6,300 and Insurance Fund $5,300 Internal • Health Division: Favorable Contracted Services $109,200, Professional Services $329,900, Laboratory Fees $51,200, and Software Support Maintenance $60,000 due to timing of expenses. Travel & Conference $33,700 due to lower travel, Personal Mileage $50,000 and Uniform Cleaning $70,200 due to less than anticipated employee usage. Partially offset by unfavorability in Vaccines ($639,900) due to increased fees; offset by revenue favorability of Immunizations $760,800 Personnel • Favorable Salaries and Fringe Benefits due to vacancies and turnover. • Health & Human Services Administration allocated $0 in Overtime and has actuals of $0. • Health Division allocated $119,960 in Overtime and has actuals of $44,113. • Children's Village allocated $0 in overtime and has actuals of $14,873. Operating Health FY 2026 Q1 Forecast Total Summary of Projections 032 Adopted Amended Forecast Favorability/UNF Percentage $50,992,092.32 $51,854,755.32 $51,764,755.32 $90,000.00 0.17% $37,090,200.53 $37,231,349.53 $37,141,349.53 $90,000.00 0.24% $5,698,671.00 $6,231,571.00 $6,231,571.00 $0.00 0.00% Personnel Fav. Salaries and Fringe Benefits due to vacancies and turnover within Divisions. Administration Division $10,000, Pretrial and Justice Services Division $60,000, and Medical Examiner Division $70,000, This is offset by an unfavorable amount of ($50,000) from Animal Control due to Overtime/Holiday Overtime pay. Operating Public Services 2026 Q1 Forecast Total Summary of Projections Department Overtime/Holidiay Overtime budgeted at $619,275 with 1st quarter spending at $616,173. Transfers No transfers anticipated in FY 2025. Operating Expenditures are at budget at Q1. Internal Services are at budget. Internal 033 Adopted Amended Forecast Favorability/UNF Percentage $13,115,046.20 $13,275,014.20 $12,689,470.63 $486,800.00 3.67% $9,022,065.34 $9,022,065.34 $9,022,065.34 $0.00 0.00% $2,395,875.00 $2,544,875.00 $2,203,275.00 $341,600.00 13.42% $1,598,361.86 $1,609,329.86 $1,464,130.29 $145,200.00 9.02% $98,744.00 $98,744.00 $0.00 $0.00 Personnel • At budget. • Veteran's Services Overtime usage is $643 of an allocated budget of $0. • All other divisions' Overtime usage is $0 of an allocated budget of $0. Operating Economic Development & Community Affairs FY 2026 Q1 Forecast Total Summary of Projections • At budget. • Administration: Unfav. Advertising ($91,200), Communications ($18,000) and Contracted Services ($83,800). Slightly offset by fav. Membership Dues $35,000, Personal Mileage $8,000, and Printing $8,600 due to less than expected usage. • Planning and Local Business Development: Fav. Advertising $130,400, Business Recruitment $141,700, Membership Dues $59,500, Special Event Program $99,000, and Travel and Conference $59,500. • Business Development Division: Unfav. Advertising ($14,000), Business Recruitment ($94,800), Membership Dues ($10,800), Personal Mileage ($9,900), Workshops and Meetings ($13,000). Offset by fav. Operating Expenditures in Planning and Local Business Development. • Workforce Development: Fav. Professional Services $50,000. Less than anticipated use. • Veteran's Services: • Fav. Soldier burial $88,600 and Soldier Relief $10,300.offset by Unfav. Advertising ($49,000). Soldier Burial and Soldier Relief consitent with historic usage. • Administration: Fav. Info Tech Operations $48,500 consitent with historical usage. • Planning and Local Business Development: Fav. Info Tech Operatons $95,000 consistent with historical usage. Internal 034 Adopted Amended Forecast Favorability/UNF Percentage $3,123,128.23 $3,148,936.23 $3,330,036.23 ($181,100.00)-5.75% $1,598,008.08 $1,586,458.08 $1,660,858.08 ($74,400.00)-4.69% $681,062.00 $701,239.00 $813,939.00 ($112,700.00)-16.07% $844,058.15 $861,239.15 $855,239.15 $6,000.00 0.70% $0.00 $0.00 $0.00 $0.00 0.00%Transfers •No Transfers Out for FY 2026 Q1. •Unfavorable Rent ($100,000) for Q1 only, as there is a Q1 amendment that will reallocate $100,000 from the Health Division to the Emergency Management Division for the warehouse, which will align the Rent spend category with expenses. Also unfavorable Equipment Rental Expense ($9,100) due to forklift rental for the warehouse; this line does not currently have a budget. Additional unfavorable Advertising ($6,000) due to increased activity related to Oak Alerts through Facebook and other online platforms, as well as promotional events. •Favorable Radio Communications $6,000 due to no radio repair work in Q1. Internal Personnel  Unfavorable Salaries and Fringe Benefits attributed to Overtime and On Call activity that pertain to emergency responses to natural and man-made disasters. They have used $7,126 out of a $10,500 Overtime budget, $8,645 out of a $21,000 On Call budget, and $635 in Holiday Overtime with no associated budget for this line. Operating Emergency Management & Homeland Security 2026 Q1 Forecast Total Summary of Projections 035 • Adopted Amended Forecast Favorability/UNF Percentage $5,300,629.80 $5,335,130.80 $5,200,629.80 $100,000.00 1.87% $3,594,397.27 $3,594,397.27 $3,594,397.27 $0.00 0.00% $1,131,327.00 $1,131,327.00 $1,031,327.00 $100,000.00 8.84% $574,905.53 $609,406.53 $574,905.53 $0.00 0.00% $0.00 $0.00 $0.00 $0.00 Transfers •No Transfers Out for FY 2026 Q1. •Fav. Contracted Services $10,000, Professional Services $46,600, Software Rental Lease Purchase $7,600, Software Support Maintenance $5,000, Special Projects $21,800. Less than anticipated use. •At budget. Internal Personnel •At budget. Overtime usage is $2,350 out of an allocated budget of $0. Operating Dept. of Public Communications FY 2026 Q1 Forecast Total Summary of Projections 036 NON-DEPARTMENTAL - FY 2026 FIRST QUARTER REPORT Account FY 2026 Adopted Budget FY 2026 Amended Budget FY 2026 Forecast Variance Percentage Explanation SC702110 Per Diem Expense - - - - 0.00% SC702145 Separation Incentive - - - - 0.00% SC702180 - Temporary Positions 250,000.00 250,000.00 250,000.00 - 100.00%At budget SC702995 - Salary Turnover Factor (9,500,000.00) (9,500,000.00) (9,500,000.00) - 100.00%At Budget SC702400 COVID Vaccine Incentive - - - - 0.00% (9,250,000.00) - 100.00% SC722750 Workers Comp - - - - 0.00% - - - - 0.00% - - - - 0.00% SC722780 Hospitalization - - - - 0.00% - - - - 0.00% - - - - 0.00% - - - - 0.00% - - - - 0.00% SC722995 Fringe Benefit Turn Over - - - - 0.00% 722000:Fringe Benefits - - - - 0.00% - - - - 0.00% 0.00% 0.00% 0.00%Unfav. Due to unbudgeted bank charges. 0.00% 100.00%At budget - - - - 0.00% SC730926 Indirect Cost - - - - 0.00% SC730954 - Insurance Surety Bonds 2,500.00 2,500.00 2,500.00 - 100.00%At budget SC731136 - Logos Trademarks Intellect Prp 25,000.00 25,000.00 25,000.00 - 100.00%At budget 037 NON-DEPARTMENTAL - FY 2026 FIRST QUARTER REPORT Account FY 2026 Adopted Budget FY 2026 Amended Budget FY 2026 Forecast Variance Percentage Explanation SC731241 - Miscellaneous - - - - 0.00% SC731213 Membership Dues - - - - 0.00% SC731346 - Personal Mileage - - - - 0.00% SC731458 Professional Services - - - - 0.00% SC731577 Refund Prior Years Revenue - - - - 0.00% SC731626 Rent - - - - 0.00% SC731885 Supportive Services - - - - 0.00% SC731941 Training - - - - 0.00% SC732018 Travel - - - - 0.00% SC732165 Workshops and Meeting - - - - 0.00% SC740044 - Drain Assessments Current 850,000.00 850,000.00 850,000.00 - 100.00%At budget SC740085 - Local Road Funding Program 2,000,000.00 2,000,000.00 2,000,000.00 - 100.00% SC740086 - Mental Health Authority 9,620,616.00 9,620,616.00 9,620,616.00 - 100.00%At budget SC740090 - Township Road Repair Program - - - - 0.00% SC740093 - Mich Association of Counties 73,000.00 73,000.00 73,000.00 - 100.00%At budget 25,500.00 25,500.00 25,500.00 - 100.00%At budget 100.00%At budget 100.00%At budget Agency 5,600,000.00 5,600,000.00 5,600,000.00 - 100.00%At budget SC740177 - Traffic Improvement Assoc 30,000.00 30,000.00 30,000.00 - 100.00%At budget Change 439,630.00 420,917.00 420,917.00 - 100.00%At Budget 038 NON-DEPARTMENTAL - FY 2026 FIRST QUARTER REPORT Account FY 2026 Adopted Budget FY 2026 Amended Budget FY 2026 Forecast Variance Percentage Explanation SC740072 - General Fund Contingency (6,000,000.00) (6,000,000.00) (6,000,000.00) - 100.00%At Budget SC740142 - Salary Adjustment Reserve (5,166,218.00) (5,808,701.00) (5,808,701.00) - 100.00%At Budget 740000:Non-Departmental 10,132,528.00 9,471,332.00 9,471,332.00 - 100.00% - - - - 0.00% - - - - 0.00% 750000 - Commodities - - - - 0.00% 300,000.00 300,000.00 300,000.00 - 100.00% At Budget 2,000,000.00 2,000,000.00 2,000,000.00 - 100.00% At Budget 760000:Capital Outlay 2,300,000.00 2,300,000.00 2,300,000.00 - 0.00% 2,190,828.61 2,190,828.61 2,190,828.61 - 100.00%At budget. 100.00%At Budget 0.00% 0.00%Fav. Due budget allocation and usage. 100.00%At budget Department Charges 702,500.00 517,347.00 517,347.00 - 100.00% SC777599 - Service Center Grounds 500,000.00 500,000.00 500,000.00 - 100.00%At budget. 13,153,577.61 11,291,297.61 11,216,628.61 74,669.00 99.34% SC788001 - Transfers Out 37,467,091.00 37,689,412.00 37,689,412.00 - 100.00% At budget SC790959 - Contributions to Other Government Units - - 250,000.00 (250,000.00) 0.00%Unfav. Due to initial transfer to CLEMIS Authority. A budget amendment will be required in a subsequent quarterly 790959: Contributions to Other Government Units - - 250,000.00 (250,000.00) 0.00% 039 TREASURER'S OFFICE ADOPTED AMENDED FY2026 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DELINQUENT TAX REVOLVING FUND 51600 REVENUES Charges for Services $10,500,000.00 $10,500,000.00 10,500,000.00$ -$ 0.00% Other Revenues 4,287,069.00 4,287,069.00 4,287,069.00 - 0.00% Transfers In - - - - 0.00% Total Revenues $14,787,069.00 $14,787,069.00 $14,787,069.00 -$ 0.00% OPERATING EXPENSES Personnel Expenditures 245,282.48$ 245,282.48$ 245,282.48$ -$ 0.00% Operating Expenditures 231,431.00 231,431.00 231,431.00 - 0.00% Interest Expense 1,000,000.00 1,000,000.00 1,000,000.00 - 0.00% Transfer Out to Other Funds: General Fund - Collection Fees 2,700,000.00 2,700,000.00 2,700,000.00 0.00% GF - Non-Departmental 5,000,000.00 5,000,000.00 5,000,000.00 - 0.00% Work Release Facility Refunding Debt Svc 2,500,000.00 2,500,000.00 2,500,000.00 - 0.00% Office Bldg Renovation Refunding Debt Svc 0.00 0.00 0.00 - #DIV/0! Animal Control Pet Adoption Debt 529,156.00 529,156.00 529,156.00 - 0.00% Total Operating Expenses 12,205,869.48$ 12,205,869.48$ 12,205,869.48$ -$ 0.00% REVENUE OVER (UNDER) EXPENDITURES*$2,581,199.52 $2,581,199.52 $2,581,199.52 $0.00 Total Net Position - Beginning $218,017,539.00 $220,598,738.52 Ending FY 2023 Designated Net Position**: NP-UnRes - Designated - Debt Service $43,221,617.00 NP-UnRes - Designated - Delinq Taxes Receivable 168,705,812.65 NP-UnRes - Designated - Collection Fees 6,090,110.36 Undesignated - Net Position $2,581,199.52 Total Net Position - Ending $220,598,739.53 Please note that in the Adopted Budget (line-item book) this is budgeted as 'Planned Use of Balance" in the revenue category. Please note the designated equity amounts are adjusted at year-end only 040 COUNTY OF OAKLAND FY 2026 FIRST QUARTER REPORT ENTERPRISE FUNDS TREASURER ADOPTED AMENDED FY2026 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DELINQUENT PERSONAL PROPERTY TAX (51800) OPERATING REVENUE $506,136.00 $506,136.00 $506,136.00 $0.00 0.00%At budget. OPERATING EXPENSE 615,001.08 615,001.08 615,001.08 $0.00 0.00%At budget. NET OPERATING INCOME (LOSS) ($108,865.08) ($108,865.08) ($108,865.08)$0.00 0.00% 5,000.00 5,000.00 $5,000.00 $0.00 0.00%At budget. TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS ($103,865.08) ($103,865.08) ($103,865.08)$0.00 TRANSFERS OUT - - - - At budget. TOTAL NET POSITION - BEGINNING 1,821,390.00 * Please note that in the Adopted Budget (line-item book) this is budgeted as 'Planned Use of Balance" in the revenue category. 041 COUNTY OF OAKLAND FY 2026 FIRST QUARTER REPORT ENTERPRISE FUND PARKS & RECREATION ADOPTED AMENDED FY 2025 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ OAKLAND COUNTY PARKS & RECREATION COMMISSION (50800) OPERATING REVENUE 12,100,715.00$ 12,100,715.00$ 12,100,715.00$ -$ 0.00% OPERATING EXPENSE 47,524,195.26$ 48,388,756.26$ 48,388,756.26$ -$ 0.00% NET OPERATING INCOME (LOSS)(35,423,480.26)$ (36,288,041.26)$ (36,288,041.26)$ -$ 0.00% TOTAL INCOME BEFORE TRANSFERS 21,072,631.84$ 20,208,070.84$ 20,208,070.84$ -$ 0.00% TRANSFERS IN (OUT)-$ -$ -$ -$ TOTAL NET INCOME/BUDGETED EQUITY ADJ 21,072,631.84$ 20,208,070.84$ 20,208,070.84$ -$ TOTAL NET POSITION - BEGINNING 136,547,790.69$ 042 ADOPTED AMENDED FY 2026 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DRAIN EQUIPMENT FUND ( 63900) OPERATING REVENUES: Inside $68,668,570.00 $68,668,570.00 $65,708,570.00 ($2,960,000.00)-4.31%Unfav - Reimbursement Salaries ($3,000,000) due to unallocated payroll charges for turnover and vacant positions, offset in Salaries and Fringes. Fav - Maintenance Contracts $40,000 the result of increased Supervisory Control Data Acquisition (SCADA) charges to the systems for drain equipment, materials & supplies and CAMS labor charges. Outside $340,100.00 $340,100.00 $340,100.00 $0.00 0.00% Total Revenue 69,008,670.00 69,008,670.00 66,048,670.00 (2,960,000.00)-4.29% OPERATING EXPENSES $69,509,670.27 $72,365,031.27 $69,458,101.00 $2,906,930.27 4.02%Fav - Salaries and Fringes $3,000,000 due to turnover and vacant positions. Unfav - Indirect Costs ($70,000) due to indirect cost rate finalized after budget process. Unfav - Membership Dues ($14,100) due to memberships being established for employees can get exam prep course material cheaper with memberships. NET INCOME (LOSS) BEFORE ($501,000.27)($3,356,361.27)($3,409,431.00)($53,069.73)1.58% NON-OPERATING REVENUE/(EXPENSE)$429,000.00 $429,000.00 $559,000.00 $130,000.00 30.30%Fav - Income from Investment $100,000 due to investment base and market rate fluctuations. Fav - Sale of Equipment and Vehicles $30,000 due to sale of owned items at county auction or online bidding services. TRANSFER IN - - - - 0.00% TRANSFERS (OUT)40,000.00 40,000.00 40,000.00 - 0.00% NET REVENUES OVER (UNDER) EXPENSES*($112,000.27)($2,967,361.27)($2,890,431.00)$76,930.27 TOTAL NET POSITION - BEGINNING 40,198,951.00$ TOTAL NET POSITION - ENDING 37,308,520.00$ *Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses. WATER RESOURCES COMMISSIONER FISCAL YEAR 2026 FIRST QUARTER FORECAST INTERNAL SERVICE FUND COUNTY OF OAKLAND 043 COUNTY OF OAKLAND FY 2026 FIRST QUARTER REPORT INTERNAL SERVICE FUND RISK MANAGEMENT ADOPTED AMENDED FY 2026 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~ ~~~~~~~~~~~ ~~~~~~~~~~ ~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ LIABILITY INSURANCE FUND 67700 OPERATING REVENUES: Outside Revenue $ 14,603.00 $ 14,603.00 $ 14,603.00 0.00 0.00% Inside Revenue 13,167,500.00 13,167,500.00 13,167,500.00 0.00 0.00% Total Operating Revenue $ 13,182,103.00 $ 13,182,103.00 $ 13,182,103.00 0.00 0.00% OPERATING EXPENSE $ 7,645,796.00 $ 7,645,796.00 $ 7,573,796.00 72,000.00 0.94% - Fav. Salaries and Fringe Benefits due to vacant positions filled late in first quarter. CLAIMS PAID 7,966,000.00 7,966,000.00 6,966,000.00 1,000,000.00 12.55%- Fav. due to lower than anticipated claims. TOTAL OPERATING EXPENSES $ 15,611,796.00 $ 15,611,796.00 $ 14,539,796.00 1,072,000.00 6.87% OPERATING INCOME (LOSS)(2,429,693.00)(2,429,693.00) (1,357,693.00) 1,072,000.00 -44.12% NON-OPERATING REVENUE (EXPENSE) 500,000.00 500,000.00 500,000.00 -0.00% TRANSFER IN (OUT) $- $- $- $ - NET REVENUES OVER/(UNDER)* EXPENSES $ (1,929,693.00) $ (1,929,693.00) (857,693.00) $ 1,072,000.00 TOTAL NET ASSETS - BEGINNING 5,764,590.67 TOTAL NET ASSETS - ENDING $ 4,906,897.67 044 COUNTY OF OAKLAND FY 2026 FIRST QUARTER REPORT ENTERPRISE FUNDS ECONOMIC DEVELOPMENT ADOPTED AMENDED FY 2026 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ OPERATING REVENUE $6,733,500.00 $6,733,500.00 $6,716,700.00 (16,800.00)$ -0.25%- OPERATING EXPENSE 8,591,187.00 8,591,187.00 8,748,787.00 (157,600.00) -1.83%- to advance for Oakland County International Airport Safety Management System Consulting and Southwest Airport Easement Acquisition (both to be reimbursed by the state and reclassed to CIP), and Adj Prior Years Exp ($24,500) due to reclassification of project charges, and to recognize prior year expenses paid in FY2026. Partially offset by fav. Salaries $273,100 due to vacant positions and Land Improvements $52,700 due to fully depreciated assets. NET OPERATING INCOME (LOSS)($1,857,687.00)($1,857,687.00)($2,032,087.00)(174,400.00)$ 9.39% NON-OPERATING REVENUE (EXPENSE)58,875.00 58,875.00 558,875.00 500,000.00 849.26%- TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS ($1,798,812.00)(1,798,812.00) ($1,473,212.00)325,600.00 -18.10% TRANSFERS IN/(OUT)- - - - CAPITAL CONTRIBUTION - - 2,363,000.00 2,363,000.00 - PRJ13033/AWD00084 & AWD00085, PRJ-13348/AWD00089, PRJ-13349/AWD00091, PRJ-17399/AWD00251, PRJ- TOTAL NET ASSETS - BEGINNING $94,617,790.33 045 COUNTY OF OAKLAND FY 2026 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS FACILITIES ADOPTED AMENDED FY 2026 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ MOTOR POOL FUND 66100 OPERATING REVENUE: Outside Revenue 138,000.00$ 138,000.00$ 138,000.00 -$ 0.00% Inside Revenue 10,849,930.00 10,877,981.00 10,125,981.00 (752,000.00) -6.91%- vehicles and activity trends to date, Gasoline Oil Grease Charges ($100,000) due to current fuel costs and fuel efficient vehicles (offset by fav. Gasoline Charges expenses $446,000) and Parts and Accessories ($97,000) due to rebilled material Total Revenue 10,987,930.00 11,015,981.00 10,263,981.00 (752,000.00) OPERATING EXPENSE 13,172,330.00 13,195,636.00 13,111,536.00 84,100.00 0.64%- (offset by unfav. Gasoline Oil Grease Charges $100,000). Partially offset by unfav. Indirect Costs ($330,700) due to the development of actual charges after budget finalization (a second quarter budget amendment will be done to correct large OPERATING INCOME (LOSS)(2,184,400.00) (2,179,655.00) (2,847,555.00) (667,900.00) 940,000.00 940,000.00 940,000.00 - 0.00% NET INCOME (LOSS) BEFORE OPERATING TRANSFERS (1,244,400.00) (1,239,655.00) (1,907,555.00) (667,900.00) TRANSFERS IN / (OUT)15,000.00 15,000.00 236,172.00 221,172.00 1474.48%- CAPITAL CONTRIBUTIONS - - - - FUND BAL.) * (1,229,400.00)$ (1,224,655.00)$ (1,671,383.00)$ (446,728.00)$ TOTAL NET ASSETS - BEGINNING 9,910,375.43$ TOTAL NET ASSETS - ENDING 8,238,992.43$ 2/17/2026046 FY 2026 FIRST QUARTER REPORT INTERNAL SERVICE FUND FACILITIES MANAGEMENT ADOPTED AMENDED FY 2026 ARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~ ~~~~~~~~~~~~~ ~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ FACILITIES MAINTENANCE & OPERATIONS (#63100) OPERATING REVENUES: Outside Revenue 561,174.00$ 582,473.00$ 582,473.00$ -$0.00% At budget. Inside Revenue 36,627,564.00 36,627,564.00 36,657,364.00 29,800.00$ 0.08% Favorable Maintenance Contracts $20,900 for Q1 only due to 3 projects for Vibe Credit Union, Easter Seals, and the Road Commission, which will be reclassified to Ext - Other Revenue in Q2. Also favorable Refunds Miscellaneous $8,800 attributed to utility rebates from the Green Space Initiative Project. TOTAL OPERATING REVENUE 37,188,738.00$ 37,210,037.00$ 37,239,837.00$ 29,800.00$ 0.08% OPERATING EXPENSES 36,399,331.15$ 36,399,331.15$ 36,303,831.15$ 95,500.00$ 0.26% PERSONNEL: Favorable Salary and Fringe Benefits $97,200 due to vacancies and turnover. They have used $166,800 out of a $488,525 Overtime budget, $36,305 out of a $96,500 Holiday Overtime budget, and $105,023 out of a $322,000 On call budget. OPERATING EXPENDITURES: Favorable Water and Sewage Charges $150,000 and Natural Gas $148,000 due to rates and usage. Also favorable Material Supplies $63,000 due to work order demand, as this budget serves as tool crib stock that is issued as needed for work orders. Partially offset by unfavorable Grounds Supplies ($133,500) due to increased costs; a Q1 budget amendment will reallocate budget to this line to support these expenditures. Also unfavorable Maintenance Supplies ($81,000) due to rising supply costs, such as air filters, that are needed to maintain aging infrastructure. INTERNAL SERVICES: Unfavorable Info Tech Development ($125,000) due to a FY2025 IT Asset Management project that was delayed where the majority of project work and expenses will occur in FY2026. Partially offset by favorable Radio Communications $26,000 as there was no radio repair work in the first quarter. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS 789,406.85$ 810,705.85$ 936,005.85$ 125,300.00$ NON-OPERATING REVENUE 100,000.00$ 100,000.00$ 100,000.00$ -$0.00% At budget. TRANSFERS IN -$-$-$ -$0.00% No Transfers In for FY2026 Q1. TRANSFERS OUT (2,215,000.00)$ (2,215,000.00)$ (2,215,000.00)$ -$0.00% At budget. Transfers Out pertains to a $2,200,000 transfer into the Project Work Order Fund for M-Projects and a $15,000 transfer to Motor Pool for a vehicle upgrade. NET REVENUES OVER(UNDER) EXPENSES*(1,325,593.15)$ (1,304,294.15)$ (1,178,994.15)$ 125,300.00$ TOTAL NET POSITION - BEGINNING 6,298,571.23$ TOTAL NET POSITION - ENDING 5,119,577.08$ *Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category. COUNTY OF OAKLAND 047 COUNTY OF OAKLAND FY2026 FIRST QUARTER FORECAST INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND ADOPTED AMENDED FY 2026 VARIANCE FRINGE BENEFITS FUND 67800 BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ OPERATING REVENUE RETIREES MEDICAL - VEBA DEBT 33,999,419 33,999,419 33,999,419 - 0.00% DEFERRED COMPENSATION-MATCH 4,933,000 4,933,000 4,510,225 (422,775) -8.57%- DEFINED CONTRIBUTION PLAN 27,238,200 27,238,200 36,600,200 9,362,000 34.37%- DEFINED CONTRIBUTION PLAN - PTNE 295,100 295,100 295,100 - 0.00% RETIREMENT HEALTH SAVINGS 6,565,000 6,565,000 5,973,000 (592,000) -9.02%- HEALTH SAVINGS ACCOUNT 375,000 375,000 1,529,000 1,154,000 307.73%- FLEX BENEFIT PLAN PAYMENTS 1,275,000 1,275,000 1,538,000 263,000 20.63%- PROP-FRINGE BENEFITS UNIT 137,119 137,119 137,119 - 0.00% PENSION EXPENSE CONTRIBUTION 3,356,382 3,356,382 3,356,382 - 0.00% RETIREMENT ADMINISTRATION 668,601 668,601 668,601 - 0.00% RETIREMENT ADMINISTRATION - PTNE 350,000 350,000 350,000 - 0.00% FRINGE BENEFIT ISF REVENUE 8,367,938 8,367,938 8,367,938 - 0.00% TUITION REIMBURSEMENT 400,000 400,000 400,000 - 0.00% COMPENSATION INSURANCE 2,306,961 2,306,961 2,306,961 - 0.00% HOSPITAL INSURANCE 48,210,000 48,210,000 48,210,000 - 0.00% EXT - FLEX BEN HOSPITALIZATION - EMPLOYEE 8,250,000 8,250,000 8,250,000 - 0.00% EXT - HOSPITAL INSURANCE 600,000 600,000 600,000 - 0.00% PRESCRIPTION COVERAGE INSURANCE 10,740,400 10,740,400 10,740,400 - 0.00% EXT - PRESCRIPTION DRUG REBATES 5,000,000 5,000,000 5,000,000 - 0.00% EXT - RETIREE PRESCRIPTION DRUG REBATES 8,000,000 8,000,000 8,000,000 - 0.00% DENTAL INSURANCE 3,815,000 3,815,000 3,815,000 - 0.00% EXT - DENTAL INSURANCE (COBRA)20,000 20,000 20,000 - 0.00% EXT - FLEX BEN DENTAL INSURANCE 565,000 565,000 565,000 - 0.00% OPTICAL INSURANCE 298,500 298,500 298,500 - 0.00% EXT - OPTICAL INSURANCE 1,500 1,500 1,500 - 0.00% EXT - FLEX BEN VISION INSURANCE 200,000 200,000 200,000 - 0.00% GROUP LIFE INSURANCE 718,700 718,700 718,700 - 0.00% EXT - FLEX BEN DEDUCTIONS 618,000 618,000 618,000 - 0.00% SALARY CONTINUATION 5,283,900 5,283,900 5,283,900 - 0.00% SOCIAL SECURITY 26,522,603 26,522,603 26,522,603 - 0.00% UNEMPLOYMENT COMPENSATION 200,000 200,000 200,000 - 0.00% EXT - TRAINING 5,000 5,000 5,000 - 0.00% INVESTMENT INCOME 2,000,000 2,000,000 2,000,000 - 0.00% TOTAL REVENUE 211,316,323 211,316,323 221,080,548 9,764,225 4.62% 048 COUNTY OF OAKLAND FY2026 FIRST QUARTER FORECAST INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND ADOPTED AMENDED FY 2026 VARIANCE FRINGE BENEFITS FUND 67800 BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING EXPENSE RETIREES MEDICAL - VEBA DEBT PRNCPL/INT/FEE 33,999,419 33,999,419 33,999,419 - 0.00% DEFERRED COMP-COUNTY PMTS (MATCH)4,933,000 4,933,000 2,010,000 2,923,000 59.25%- DEFINED CONTRIBUTION COUNTY RETIREMENT 27,238,200 27,238,200 32,731,200 (5,493,000) -20.17%- DEFINED CONTRIBUTION PLAN - PTNE 295,100 295,100 295,100 - 0.00% RETIREMENT HEALTH SAVINGS 6,565,000 6,565,000 3,825,000 2,740,000 41.74%- FLEXIBLE BENEFIT PLAN PAYMENTS 1,275,000 1,275,000 400,000 875,000 68.63%- ACCOUNTING SERVICES 137,119 137,119 137,119 - 0.00% PENSION CONTRIBUTION EXPENSE 3,356,382 3,356,382 3,356,382 - 0.00% HEALTH SAVINGS ACCOUNT 375,000 375,000 2,768,300 (2,393,300) -638.21%- NON DEPT EMPLOYEE RETIREMENT 270,500 270,500 270,500 - 0.00% HR RETIREMENT ADMINISTRATION 616,755 616,755 616,755 - 0.00% HR EMPLOYEE & LABOR RELATIONS EEO 297,038 297,038 297,038 - 0.00% HR TRAINING AND DEV UNIT 798,923 798,923 798,923 - 0.00% HR EMPLOYEE RECORDS AND HRIS 276,448 276,448 276,448 - 0.00% HR BENEFITS ADMINISTRATION 897,376 897,376 897,376 - 0.00% HR EMPLOYEE ENGAGEMENT 600,264 600,264 600,264 - 0.00% HR EMPLOYEE BENEFITS UNIT 1,204,801 1,204,801 1,204,801 - 0.00% EMPLOYEE IN-SERVICE TRAINING 200,000 200,000 200,000 - 0.00% IN-SERVICE TRAINING - DEI 100,000 100,000 100,000 - 0.00% IN-SERVICE TRAINING - INFO TECH 300,000 300,000 300,000 - 0.00% PROFESSIONAL SERVICES 440,000 440,000 440,000 - 0.00% SICK AND ANNUAL LEAVE CASH-OUT 3,400,000 3,400,000 3,400,000 - 0.00% TUITION REIMBURSEMENT 400,000 400,000 400,000 - 0.00% WORKERS COMPENSATION 1,500,000 1,500,000 1,500,000 - 0.00% RISK MANAGEMENT 807,229 807,229 807,229 - 0.00% PATIENT CENTERED OUTCOME RESEARCH 30,000 30,000 30,000 - 0.00% HOSPITALIZATION (CONTRACTUAL)57,030,000 57,030,000 56,536,521 493,479 0.87%-Fav. due to anticipating claims lower than budget projections. PRESCRIPTION COVERAGE 23,740,400 23,740,400 20,645,400 3,095,000 13.04%-Fav. due to anticipating claims lower than budget projections. DENTAL INSURANCE 4,400,000 4,400,000 4,400,000 - 0.00% OPTICAL INSURANCE 500,000 500,000 500,000 - 0.00% GROUP LIFE INSURANCE 1,336,700 1,336,700 1,336,700 - 0.00% DISABILITY INSURANCE 5,283,900 5,283,900 5,283,900 - 0.00% SOCIAL SECURITY 26,522,603 26,522,603 26,522,603 - 0.00% UNEMPLOYMENT COMPENSATION 200,000 200,000 200,000 - 0.00% CHILD CARE FACILITY 568,472 568,472 568,472 - 0.00% INDIRECT COSTS 500,000 500,000 500,000 - 0.00% TOTAL EXPENSE 210,395,632 210,395,632 208,155,453 2,240,179 1.06% NET REVENUE OVER/(UNDER) EXPENSES 920,691 920,691 12,925,095 7,524,046 TOTAL NET ASSETS - BEGINNING 506,119,899 TOTAL NET ASSETS - ENDING 519,044,994 Note: Does not reflect FY 2026 GASB #68 and GASB #75 impact yet; actuary reports are excepted in mid December 2026 and impact will be reflected in the FY 2026 CAFR. {print "selection";1;9999;1;1} 049 FY 2026 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2025 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES( ) OPERATING REVENUES: Outside 3,830,485 3,830,485 5,547,285 1,716,800 44.82%- increased customer usage. Offset by unfav. Enhanced Access Fees ($216,200) and Managed Print Services ($125,400) due to reduction of Inside 44,116,643 44,119,946 44,225,746 105,800 0.24%- maintenance charges on IT Office Equipment items. Unfav. OC Depts Operations & Non Governmental Operations ($2,036,300) and OC Depts Development Support & Non Governmental Development $2,054,200 due to rates remaining at prior year levels and limited resources available to TOTAL OPERATING REVENUE 47,947,128 47,950,431 49,773,031 1,822,600 3.80% OPERATING EXPENSES 80,254,761 80,531,521 76,510,821 4,020,700 4.99%- Software Support/Maintenance $2,565,000 due to lower maintenance rates; Contracted Services $1,698,300 due to reduction of contractual costs for staffing services; Communications $866,800 due to higher than anticipated costs; Charge Card Fee $671,900 for reduction in credit card activity; Adj Prior Years $319,000 due to FY 2025 expenditure accruals; Internal Services $30,900 is primarily due to fav. Insurance Fund; Sublet Repairs $44,000; Travel $21,900 due to reduction of staff traveling to conferences; Membership Dues $6,700 due to memberships being established for employees; Garbage & Rubbish $6,100 for disposal costs Unfav. Professional Services ($2,815,100) a budget amendment is recommended Accessories ($146,900) due to usage Indirect Cost ($878,700) due to actual charges determined after budget finalization; Equipment Maintenance ($556,700) for hardware maintenance costs; Maintenance Contracts ($158,800) and Software Rental/Lease ($20,300) due to increased activity; Amended Budget for Overtime $103,770; Actuals as of 12/1/2025 was $38,155 due to coverage of staff for IT projects. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS (32,307,633)(32,581,090)(26,737,790)5,843,300 -17.93% NON-OPERATING REVENUE 100,500 100,500 100,500 0 0.00% TRANSFERS IN 7,906,676 8,196,648 8,196,648 0 0.00% TRANSFERS (OUT)0 0 0 0 0.00% CAPITAL CONTRIBUTION 0 0 0 0 0.00 NET REV OVER(UNDER) EXP*(24,300,457)(24,283,942)(18,440,642)5,843,300 TOTAL NET POSITION - BEGINNING 43,711,114 TOTAL NET POSITION - ENDING 25,270,472 Information Technology - Operations (63600) 050 FY 2026 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2025 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES( ) Information Technology - CLEMIS (53500) OPERATING REVENUES: Outside 5,440,317.00 5,440,317.00 6,057,317.00 617,000.00 11.34% fleet of CLEMIS agencies. Also fav. Access Fees Oakland $86,700 due to updated law enforcement Full Time Equivalent count used for billing and CLEMIS Crash $25,800 due to decreased usage by Oakland and non- Inside 1,785,664.00 1,785,664.00 2,096,764.00 311,100.00 17.42% staff supporting Sheriff project and FOIA Fees $1,200. Offset by unfav. In- TOTAL OPERATING REVENUE 7,225,981.00 7,225,981.00 8,154,081.00 928,100.00 12.84% OPERATING EXPENSES 12,672,118.00 12,672,118.00 12,377,918.00 294,200.00 2.32% $396,300 primarily due to Info. Tech Operations; Exp Equipment $68,400 for equipment replacement; Software Rental $33,700 due to decreased costs and Charge Card Fees $25,300 for credit card activity . Offset by unfav. costs for staffing services; Indirect Costs ($237,000) due to actual charges determined after budget finalization and Membership Dues ($2,900) due to usage. Amended Budget for Overtime $40,000; Actuals as of 12/1/2025 was $26,881 due to coverage of staff for projects. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS (5,446,137.00)(5,446,137.00)(4,223,837.00)1,222,300.00 NON-OPERATING REVENUE 35,000.00 35,000.00 35,000.00 0.00 0.00% TRANSFERS IN 1,644,186.00 1,644,186.00 1,644,186.00 0.00 0.00% TRANSFERS (OUT)78,360.00 78,360.00 78,360.00 0.00 0.00% CAPITAL CONTRIBUTION 0.00 0.00 0.00 0.00 0.00% NET REV OVER(UNDER) EXP*(3,688,591.00)(3,688,591.00)(2,466,291.00)1,222,300.00 TOTAL NET POSITION - BEGINNING 4,758,351.00 TOTAL NET POSITION - ENDING 2,292,060.00 051 FY 2026 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2025 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES( ) OPERATING REVENUES: Outside 9,265,600 9,265,600 10,551,300 1,285,700 13.88% 911 surcharge and Antenna Site Management $737,500 due to updates in rental contracts. Inside 491,828 491,828 306,228 (185,600)-37.74% equipment replacement and Leased Equipment ($53,800) due to lower than anticpated reimbursement by participating agencies for equipment TOTAL OPERATING REVENUE 9,757,428 9,757,428 10,857,528 1,100,100 11.27% OPERATING EXPENSES 13,121,325 13,136,907 11,785,507 1,351,400 10.29% Communications $433,500 for connectivity costs for cell tower sites used for coverage enhancements of the Radio system; Salaries and Fringes $242,700 dued to vacanies; Tower Charges $237,400 for tower rental agreements;Contracted Services $165,800 for staffing services; Internal Services $139,500 primarily due to Info. Tech Development; Indirect Cost $110,500. Also fav. Parts and Accessories $151,800 for equipment replacement, Supplies $10,000; Electrical Service $17,600 , Travel and Conference $12,500, Personal Mileage $2,500 based on usage. Partially offset by unfav. Equipment Maintenance ($771,400) due to maintenance costs; Interest Expense ($575,900) due Bond Issuing Costs and Professional Services ($149,400) due to higher than anticipated contractual costs for Amended Budget for Overtime $150,000; Actuals as of 12/1/2025 was $1,872 due to coverage of staff for projects. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS (3,363,897)(3,379,479)(927,979)2,451,500 NON-OPERATING REVENUE 100,000 100,000 48,600 (51,400)-51.40% TRANSFERS IN 86,360 101,942 101,942 0 0.00% TRANSFERS (OUT)(286,000)(286,000)(286,000)0 0.00% NET REV OVER(UNDER) EXP*(3,463,537)(3,463,537)(1,063,437)2,400,100 TOTAL NET POSITION - BEGINNING 63,159,851 TOTAL NET POSITION - ENDING 62,096,414 Information Technology - Radio Communications (53600) 052 FY 2026 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2025 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES( ) Fire Records Management ( 53100) OPERATING REVENUES: Outside 385,755 385,755 406,855 21,100 5.47% . TOTAL OPERATING REVENUES 385,755 385,755 406,855 21,100 5.47% OPERATING EXPENSES 950,868 950,868 669,468 281,400 29.59% turnover; Internal Services $38,700 primarily due to IT Development; Professional Services $35,200 due to decreased activity; Indirect Costs Amended Budget for Overtime $7,000; Actuals as of 12/1/2025 was $1,566 due to coverage of staff for projects. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS (565,113)(565,113)(262,613)302,500 NON-OPERATING REVENUE 3,000 3,000 5,000 2,000 66.68% TRANSFERS IN 562,113 562,113 562,113 0 0.00% TRANSFERS (OUT)0 0 0 0 0.00% CAPITAL CONTRIBUTION 0 0 0 0 0.00% NET REV OVER(UNDER) EXP*(0)(0)304,500 304,500 TOTAL NET POSITION - BEGINNING 862,109 TOTAL NET POSITION - ENDING 1,166,609 053 Department of Public Services Oakland County Children's Village Date:Donor:Cash/Check:Items:Estimated Value: 10/1/2025 D. Malik Pillowcases $300.00 10/1/2025 St. Perpetua Lululemon Bags, Card Games, Pillow Cases $331.00 10/6/2025 Waterford Parks & Rec Yarn $50.00 10/6/2025 J. Floyd Journals for Residents $400.00 10/9/2025 OCCVF 100 Gas Cards for Parents/Guardians $1,000.00 10/14/2025 A. Tungate 12 Bibles $156.00 11/4/2025 St. Perpetua 5 Lululemon Bags, 20 Pillowcases $325.00 11/7/2025 Williams Lake Bunco Cash $190+14 Sets Hats/Gloves & Socks $245.00 11/7/2025 OCCVF Plaid Bags $671.25 11/7/2025 OCCVF Tennis Shoes $902.00 11/14/2025 Waterford Senior Center 9 Fleece Blankets $300.00 11/17/2025 L. Cheepne Socks $20.00 11/17/2025 Allied Manufacturing Tech Balls,Crafts, Hoodies,$200 Gift Cards $350.00 11/19/2025 S. Voyles Check $100.00 11/21/2025 D. Malik Pillowcases $300.00 12/1/2025 B Larsen Toys, Fleece Tops $300.00 12/2/2025 St. Perpetua Lululemon Bags, Pillowcases $325.00 12/2/2025 Waterford Senior Center Yarn, Carft Kits $200.00 12/3/2025 OC Corp Counsel Amazon Wish List Items $272.76 12/4/2025 T. Ratoha Christmas Cookie Donation $100.00 12/8/2025 St. Mary of The HIlls Crafts, Cards,Legos,Balls,Puzzles, Make Up $750.00 12/8/2025 Christ The Redeemer Crafts, Cards,Legos,Balls,Puzzles, Make Up $1,750.00 12/8/2025 First Presbyterian Church Legos, Hats, Gloves $300.00 12/8/2025 S. Hariri Costco Cake $28.00 12/8/2025 Season of Giving Hygiene Products, Toys $800.00 12/11/2025 J. Frejat Hats, Gloves $600.00 12/12/2025 Welcome Baptist Church Body Wash, Shampoo, Lotion, Toys $300.00 12/12/2025 St. Mary of The Snows Balls,Crafts,Toys,Games $750.00 12/12/2025 Boomers Annual Toy Drive Legos,Remote Cars,Toys,Puzzles $750.00 12/15/2025 OCCVF Coats,Hats,Gloves $1,375.00 12/16/2025 Daughters of Isabella Hoodies,PJ's,Clothes,Toiletries $800.00 12/17/2025 OC Corp Counsel RC Cars,Toys,Books,Gift Cards $600.00 Donation Tracking : Donation Period October 2025 - December 2025 054 Department of Public Services Oakland County Children's Village Date:Donor:Cash/Check:Items:Estimated Value: Donation Tracking : Donation Period October 2025 - December 2025 12/17/2025 OC Circuit Court Coats,Hats,Gloves,Socks,Toiletries $500.00 12/17/2025 Christ Cranbrook Church Legos,Crafts,Games,Toys,Puzzles,Toiletries,Clothing $1,750.00 12/18/2025 OCCVF Paid All About Driving School For Resident $300.00 12/18/2025 A. Sasalla Deodorant,Underware,$80.00 in Gift Cards $115.00 12/19/2025 K. Arnone Books $300.00 12/19/2025 Orotex Balls,Legos,Books,Hoodies,Switch,Toiletries $500.00 12/19/2025 C. Brown Check $200.00 12/19/2025 Holly YA Check $20.00 12/22/2025 J. Frejat Gloves, Hats $700.00 12/22/2025 L. Lengel Stuffed Animals $100.00 12/22/2025 Preserving Family 47 Care Packages $2,000.00 12/22/2025 M. Gnozde Check Lego Set, $100 Check $130.00 12/22/2025 OC Executive Office Books $300.00 12/29/2025 Ecto HR Check $175.00 Total:$22,541.01 055 Date Donor Cash/Check Amount Purpose 10/1/2025 Easy Rodders Check 500.00$ SSRT Supplies Oakland County Sheriff's Office FY2026 First Quarter Report for Contributions (Donations) 056 MONTH ADJUST BAD DEBT WRITEOFF Total Write-Off (4,557.98)(125,191.52)(129,749.50) (4,264.07)(86,119.15)(90,383.22) (1,955.29)(69,504.90)(71,460.19) Total Deparment of Health and Human Services FY 2026 First Quarter Write-Offs (October 2025 - December 2025) 057