HomeMy WebLinkAboutReports - 2024.03.14 - 41098
AGENDA ITEM: Fiscal Year 2024 First Quarter Financial Forecast
DEPARTMENT: Fiscal Services
MEETING: Board of Commissioners
DATE: Thursday, March 14, 2024 9:30 AM - Click to View Agenda
ITEM SUMMARY SHEET
COMMITTEE REPORT TO BOARD
Resolution #2024-3918
Motion to accept the Fiscal Year 2024 First Quarter Financial Report, including authorizing the
acceptance of grant extensions and acknowledging the donations to the Animal Shelter - Pet
Adoption Center totaling $49,385.90 and Children’s Village Division totaling $31,394.15. Further,
authorize the write-off of uncollected debts detailed in the attached Schedules A and B, totaling
$36,711.42, and amend the Fiscal Year 2024 Budget as detailed in the attached Schedules A and
B.
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 and 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) 2024 First Quarter Financial Forecast Report has identified several variances
and budget amendments are recommended as detailed in the attached Schedule A and B budget
amendment.
Miscellaneous Resolution 2023-2772 approved a sub-recipient agreement between Oakland County
and Honor Community Health for referral services, participant recruitment assistance, and collection
of participant-level core metrics during the period October 1, 2022, through October 31, 2023.
Amendment #1 to the sub-recipient agreement extends the sub-recipient agreement for Honor
Community Health period from October 31, 2023, to September 15th, 2024; a budget amendment is
not required.
Miscellaneous Resolution authorized the acceptance of the Sheriff's Office 2022 Community
Policing Innovations Initiative Grant. Amendment #2 to the grant extends the original agreement
from December 31, 2023, to December 31, 2024. A budget amendment is not required.
The Department of Public Services, Animal Shelter and Pet Adoption Center received donations for
the period of October 2023 through December 2023, totaling $49,385.90.
Children’s Village Division received donations for the period of October 2023 through December
2023 totaling $31,394.15 of which $210 was cash donations.
Health and Humans Services has requested write-offs totaling $36,711.42 for the period of October
2023 through December 2023 for uncollectible transactions.
BUDGET AMENDMENT REQUIRED: Yes
Committee members can contact Michael Andrews, Policy and Fiscal Analysis Supervisor at
248.425.5572 or andrewsmb@oakgov.com or the department contact persons listed for additional
information.
CONTACT
Sheryl Johnson
Deputy CFO
ITEM REVIEW TRACKING
Aaron Snover, Board of Commissioners Created/Initiated - 3/14/2024
AGENDA DEADLINE: 03/14/2024 9:30 AM
ATTACHMENTS
1. Transmittal Letter FY 2024 1st Quarter Final
2. Fiscal Year 2024 First Quarter Financial Forecast
COMMITTEE TRACKING
2024-03-06 Finance - Recommend to Board
2024-03-14 Full Board - Adopt
Motioned by: Commissioner Philip Weipert
Seconded by: Commissioner Linnie Taylor
Yes: David Woodward, Penny Luebs, Karen Joliat, Kristen Nelson, Christine Long, Robert
Hoffman, Philip Weipert, Gwen Markham, Angela Powell, William Miller III, Yolanda Smith
Charles, Charles Cavell, Ajay Raman, Ann Erickson Gault, Linnie Taylor (15)
No: None (0)
Abstain: None (0)
Absent: Michael Spisz, Marcia Gershenson, Brendan Johnson, Michael Gingell (4)
Passed
OAKLAND COUNTY EXECUTIVE DAVID COULTER
2100 Pontiac Lake Road | Executive Office Building 41W | Waterford, MI 48328 | Fax (248) 452-9172 | OakGov.com
TO: Members of the Finance Committee
FROM: Sheryl H. Johnson, Interim Deputy CFO
Kymberly Coy, Chief, Fiscal Services
Ebru Adoglu-Jones, Supervisor, Fiscal Services
SUBJECT: Fiscal Year 2024 First Quarter Forecast
DATE: March 6, 2024
Attached please find the Fiscal Year 2024 First Quarter Forecast. Pursuant to Section 8 of Public Act
139 of 1973, this forecast provides updated financial projections for the current fiscal year based on revenue
and expenditure activity through the first quarter of the fiscal year (ending December 31). The quarterly
forecasting process seeks to ensure that no individual department overspends its appropriated budget at
year end and provides countywide information on forecasted revenues and expenditure for use by the Board
of Commissioners, Department of Management and Budget, and the public.
Revenue Forecast
Total General Fund revenues are forecasted to be $3.6 million lower than the revenue amounts included in
the Amended FY 2024-2026 County Budget. This is the net result of:
• Lower forecasted revenues of $3.7 million in Charges for Services, primarily concentrated in the
District Court due to lower fees, fines, and costs. The court indicates this is the result of lower
numbers of cases where financial charges are assessed, in part due to state policy changes.
• Lower forecasted Other Intergovernmental Revenues of $139,000 .
• Approximately $305,000 in higher revenues across a number of other revenue categories forecasted
over by small amounts.
Expenditure Forecast
Total General Fund Expenditures are forecasted to be $25 .8 million lower than the expenditure amounts
included in the Amended FY 2024-2026 County Budget. This is the net result of:
• Lower forecasted expenditures in departmental budgets totaling $25.8 million. Lower expenditures
are forecasted across the majority of departments due to a combination of personnel
vacancies/turnover and lower-than-budgeted operating costs.
At this time, one department is forecasted to exceed appropriated levels at the department total level:
• The Sheriff’s Office is forecasted to exceed its budget by $3.6 million. This is the result of Personnel
Costs being forecasted to exceed the budgeted level by $4.5 million due to higher overtime costs,
hospital watch, officers in the academy/training, and other factors. If current trends continue, a
budget amendment will be required in the year -end report to cover the final spending amounts for FY
2024.
Budget amendments are included with the attached resolution for net-neutral adjustments within department
budgets, resolutions adopted by the Board of Commissioners for which a budget amendment was not
available at the time, recognition of available revenue amounts, and other technical adjustments.
2100 Pontiac Lake Road | County Executive Building 41W | Waterford, MI 48328 | Fax (248) 452-9172 | OakGov.com
Impact on Planned Use of Fund Balance
The current amended budget assumes $27.5 million in Planned Use of Fund Balance. Major contributors to
this amount are as follows:
• $7.7 million for road programs and other one-time purposes included in the original Adopted FY
2024 budget.
• $19.8 million for carryforwards and encumbrances approved with the FY 2023 year-end report,
funded from unexpended funds in the FY 202 3 budget.
In total, this forecast expects the net impact on Planned Use of Fund Balance to be $5.3 million less than the
level assumed in the amended budget.
Other factors -- including any other resolutions adopted by the Board of Commissioners during this
fiscal year that use or increase fund balance, further updates in revenue and expenditure forecasts as
the year progresses, and other technical factors -- will affect the final FY 2024 fund balance. Those
factors will be accounted for in the second and third quarter forecasts and the FY 2024 year -end report.
Please call with any questions you may have prior to the Finance Committee meeting.
R/E Fund Name Division Name
Fund #
(FND)Cost Center (CCN) #
Account #
(RC/SC)Program # (PRG)Grant ID (GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2024
Amendment
FY 2025
Amendment
FY 2026
Amendment
Circuit Court - Family Division
E General Fund Family Division FND10100 CCN3010404 SC702010 PRG126030 702000 Salaries Regular (10,300.00)$ (10,300.00)$ (10,300.00)$
E General Fund Family Division FND10100 CCN3010404 SC722790 PRG126030 722000 FICA (788.00) (788.00) (788.00)
E General Fund Family Division FND10100 CCN3010404 SC722770 PRG126030 722000 Retirement (2,497.00) (2,497.00) (2,497.00)
E General Fund Family Division FND10100 CCN3010404 SC722810 PRG126030 722000 Disability (154.00) (154.00) (154.00)
E General Fund Family Division FND10100 CCN3010404 SC722820 PRG126030 722000 Unemployment (6.00) (6.00) (6.00)
E General Fund Family Division FND10100 CCN3010404 SC722760 PRG126030 722000 Group Life (27.00) (27.00) (27.00)
E General Fund Family Division FND10100 CCN3010404 SC722750 PRG126030 722000 Workers Comp.(91.00) (91.00) (91.00)
E General Fund Family Division FND10100 CCN3010404 SC722780 PRG126030 722000 Medical (3,384.00) (3,384.00) (3,384.00)
E General Fund Family Division FND10100 CCN3010404 SC722800 PRG126030 722000 Dental (159.00) (159.00) (159.00)
E General Fund Family Division FND10100 CCN3010404 SC722850 PRG126030 722000 Optical (8.00) (8.00) (8.00)
E General Fund Family Division FND10100 CCN3010404 SC788001 PRG126030 BFA27100 788001 Transfers Out 17,414.00 17,414.00 17,414.00
Subtotal Expenditure -$ -$ -$
E General Fund 52-4 Troy FND10100 CCN3020501 SC731101 PRG121020 730000 Library Continuations (1,556.00)$ (1,556.00)$ (1,556.00)$
E General Fund 52-4 Troy FND10100 CCN3020501 SC732018 PRG121020 730000 Travel and Conference 1,556.00 1,556.00 1,556.00
-$ -$ -$
WHEREAS a FY 2024 - FY 2026 budget amendment is recommended for the 52nd District Court- Troy to reallocate the budgets between line-items within the Operating Expenses controllable category; and
Sheriff
R General Fund Sheriff Corrective Svcs SateFND10100 CCN4030401 RC631806 PRG121280 630000 Reimb. Court Services -$ -$ 23,278.00$
Total Revenues -$ -$ 23,278.00$
E General Fund Sheriff Emergency ResponsFND10100 CCN4030501 SC731458 PRG110005 730000 Professional Services -$ -$ 3,971.00$
E General Fund Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 730000 Contingency - - 19,307.00
Total Expenditures -$ -$ 23,278.00$
R General Fund Inv. & Forensic Svcs FND10100 CCN4030901 RC695500 PRG116240 BFA21340 695500 Transfers In - Law Enforcement Enhance Lab Fees 14,026.00$ -$ -$
R General Fund Emergency Comm Ops FND10100 CCN4030701 RC695500 PRG116230 BFA21396 695500 Transfers In - Sheriff Dispatch Training 2,218.00 - -
R General Fund Corrective Services FND10100 CCN4030301 RC695500 PRG112620 BFA21397 695500 Transfers In - Sheriff Booking Fee Training 22,685.00 - -
Total Revenue 38,929.00$ -$ -$
E General Fund Inv. & Forensic Svcs FND10100 CCN4030901 SC750203 PRG116240 750000 Forensic Lab Enhancement 14,026.00$ -$ -$
E General Fund Emergency Comm Ops FND10100 CCN4030701 SC731304 PRG116230 730000 Officers Training (Dispatch)2,218.00 - -
E General Fund Corrective Services FND10100 CCN4030301 SC731304 PRG112620 730000 Officers Training (Corrections)22,685.00 - -
Total Expenditures 38,929.00$ -$ -$
R
Law Enforcement
Enhance Lab Fees
Inv. & Forensic Svcs FND21340 CCN4030901 RC665882 PRG116240 665882 Planned Use of Balance 14,026.00$ -$ -$
Total Revenue 14,026.00$ -$ -$
E
Law Enforcement
Enhance Lab Fees
Inv. & Forensic Svcs FND21340 CCN4030901 SC788001 PRG116240 BFA10100 788001 Transfers Out - General Fund 14,026.00$ -$ -$
Total Expenditures 14,026.00$ -$ -$
R Dispatch Training Emergency Comm Ops FND21396 CCN4030701 RC665882 PRG112630 665882 Planned Use of Balance 2,218.00$ -$ -$
Total Revenue 2,218.00$ -$ -$
E Dispatch Training Emergency Comm Ops FND21396 CCN4030701 SC788001 PRG112630 BFA10100 788001 Transfers Out - General Fund 2,218.00$ -$ -$
Total Expenditures 2,218.00$ -$ -$
R Sheriff Booking Fee
Training
Corrective Services FND21397 CCN4030301 RC665882 PRG112620 665882 Planned Use of Balance 22,685.00$ -$ -$
Total Revenue 22,685.00$ -$ -$
E
Sheriff Booking Fee
Training Corrective Services FND21397 CCN4030301 SC788001 PRG112620 BFA10100 788001 Transfers Out - General Fund
22,685.00$ -$ -$
Total Expenditures 22,685.00$ -$ -$
Oakland County, Michigan
FY 2024 First Quarter Financial Forecast and Budget Amendments
Schedule "A" DETAIL
WHEREAS a FY 2024 - FY 2026 budget amendment totaling $17,414 is recommended for Circuit Court-Family Division to correct the amendment within Report #2023-3683 as the positions were costed to the General Fund in error; the entries should have been made to Friend of the Court Fund
(FND 27100). Refer to related entry in Schedule B for FND 27100; and
District Court
WHEREAS a FY 2026 budget amendment of $23,278 is recommended for the Sheriff's Office to update the budget to include FY 2026 for September 2023 budget amendments that were entered for FY 2023 - FY 2025. The financial system is not able to load four (4) years of budget amendments. It is limited to
three (3) years. This amendment includes budget for the FY24 - FY26 Interlocal Agreements to Provide Security for District Courts (MR #2023-3280/3281/3282/3283/3284/3285 and FY24 - FY26 Interlocal Agreement with OCHN for Co-Responder Team (MR #2023-3294) ; and
Schedule A2
I I I I
R/E Fund Name Division Name
Fund #
(FND)Cost Center (CCN) #
Account #
(RC/SC)Program # (PRG)Grant ID (GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2024
Amendment
FY 2025
Amendment
FY 2026
Amendment
Oakland County, Michigan
FY 2024 First Quarter Financial Forecast and Budget Amendments
Schedule "A" DETAIL
E General Fund Corrective Services SatelliteFND10100 CCN4030401 SC730716 PRG110045 730000 Fees Civil Service 100,000.00$ 100,000.00$ 100,000.00$
E General Fund Patrol Services FND10100 CCN4030601 SC730716 PRG110045 730000 Fees Civil Service (100,000.00) (100,000.00) (100,000.00)
Total Expenditures -$ -$ -$
E General Fund Investigative & Forensic Sv FND10100 CCN4030901 SC730324 PRG110050 730000 Communications (10,600.00)$ -$ -$
E General Fund Emergency Response & PreFND10100 CCN4030501 SC730611 PRG110110 730000 Employees Medical exams (20,000.00) - -
E General Fund Corrective Services FND10100 CCN4030301 SC730982 PRG112620 730000 Interpreter Fees (7,000.00) - -
E General Fund Patrol Services FND10100 CCN4030601 SC730982 PRG110000 730000 Interpreter Fees (2,000.00) - -
E General Fund Sheriff's Office FND10100 CCN4030101 SC731101 PRG112580 730000 Library Continuations (10,000.00) - -
E General Fund Sheriff Admin FND10100 CCN4030201 SC731101 PRG112650 730000 Library Continuations (20,000.00) - -
E General Fund Investigative & Forensic Sv FND10100 CCN4030901 SC731122 PRG110060 730000 Liquor and Gambling Evidence (5,000.00) - -
E General Fund Sheriff Admin FND10100 CCN4030201 SC731388 PRG112580 730000 Printing (20,400.00) - -
E General Fund Corrective Services FND10100 CCN4030301 SC731402 PRG112620 730000 Prisoner Housing - Outside Cty (15,500.00) - -
E General Fund Emergency Communication FND10100 CCN4030701 SC731780 PRG116230 730000 Software Support Maintenance (57,600.00) - -
E General Fund Corrective Services FND10100 CCN4030301 SC750049 PRG112620 750000 Computer Supplies (10,000.00) - -
E General Fund Corrective Services FND10100 CCN4030301 SC750056 PRG112650 750000 Culinary Supplies (5,000.00) - -
E General Fund Corrective Services FND10100 CCN4030301 SC750063 PRG112620 750000 Custodial Supplies (20,000.00)
E General Fund Corrective Services SatelliteFND10100 CCN4030401 SC750063 PRG113381 750000 Custodial Supplies (3,700.00) - -
E General Fund Patrol Services FND10100 CCN4030601 SC750170 PRG110000 750000 Other Expendable equipment (50,000.00) - -
E General Fund Patrol Services FND10100 CCN4030601 SC750210 PRG116200 750000 Gasoline Charges (5,800.00) - -
E General Fund Corrective Services FND10100 CCN4030301 SC750252 PRG112650 750000 Indigent Orders (10,000.00) - -
E General Fund Corrective Services FND10100 CCN4030301 SC750266 PRG112650 750000 Inmate Recreational Supplies (5,000.00) - -
E General Fund Sheriff's Office FND10100 CCN4030101 SC750399 PRG112580 750000 Office Supplies (5,000.00) - -
E General Fund Sheriff Admin FND10100 CCN4030201 SC750399 PRG112580 750000 Office Supplies (8,000.00) - -
E General Fund Patrol Services FND10100 CCN4030601 SC750399 PRG110000 750000 Office Supplies (9,400.00) - -
E General Fund Sheriff Admin FND10100 CCN4030201 SC750581 PRG112580 750000 Uniforms 300,000.00 - -
Total Expenditures -$ -$ -$
County Executive Administration
E General Fund Administration FND10100 CCN1010101 SC731822 PRG181000 730000 Special Projects (25,000.00)$ -$ -$
E General Fund Administration FND10100 CCN1010101 SC731818 PRG181000 730000 Special Event Programs (3,000.00) - -
E General Fund Diversity, Equity and Inclusi FND10100 CCN1010301 SC731818 PRG181002 730000 Special Events Program (25,000.00) - -
E General Fund Department of Public CommFND10100 CCN1210101 SC731822 PRG181000 730000 Special Projects (58,642.00) - -
E General Fund Administration FND10100 CCN1010101 SC788001 PRG181000 PRJ-17529 BFA40400 788001 Transfers Out 28,000.00 - -
E General Fund Diversity, Equity and Inclusi FND10100 CCN1010301 SC788001 PRG181002 PRJ-17529 BFA40400 788001 Transfers Out 25,000.00 - -
E General Fund Department of Public CommFND10100 CCN1210101 SC788001 PRG181000 PRJ-17529 BFA40400 788001 Transfers Out 58,642.00 - -
Total Expenditures -$ -$ -$
Project Work Order Fund
R Work Order Fund Facilities FND40400 CCN1040801 RC695500 PRG148020 PRJ-17529 BFA10100 695500 Transfer In - Move 51,787.00$ -$ -$
R Work Order Fund Facilities FND40400 CCN1040801 RC695500 PRG148020 PRJ-17529 BFA10100 695500 Transfers In - Reconfigure 59,855.00$ -$ -$
Total Revenues 111,642.00$ -$ -$
E Work Order Fund Facilities FND40400 CCN1040801 SC796500 PRG148020 796500 Budgeted Equity 111,642.00$ -$ -$
Total Expenditures 111,642.00$ -$ -$
E General Fund Diversity, Equity and Inclusi FND10100 CCN1010301 SC731458 PRG181002 730000 Professional Services - - (5,250.00)$
E General Fund Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 730000 Contingency - - 5,250.00
Total Expenditure -$ -$ -$
WHEREAS a FY 2026 budget amendment is recommended for County Executive Administration -Diversity Equity & Inclusion division in the amount of $5,250 to correct the Professional Services line-item as it was inadvertently omitted during budget development; and
E General Fund Corporation Counsel FND10100 CCN1010501 SC788001 PRG181020 BFA63600 788001 Transfers Out (28,200.00)$ (28,200.00)$ (28,200.00)$
E General Fund Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 730000 Contingency 28,200.00$ 28,200.00$ 28,200.00$
Total Expenditures -$ -$ -$
WHEREAS a FY 2024 budget amendment of $300,000 is recommended for the Sheriff's Office to reallocate the line-item expenditure budget accounts between cost centers to accommodate the purchase of uniforms; and
WHEREAS the Sheriff's Office receipt of forfeiture/enhancement funds are recorded in separate restricted funds that require a transfer to the General Fund for use of the monies. Transfers In from the various restricted funds in the amount of $38,929 is being recognized for eligible forensic lab and training costs for
dispatchers and corrections officers; and
WHEREAS a FY 2024 - FY 2026 budget amendment of $100,000 is recommended for the Sheriff's Department reallocating budget between cost centers that was omitted during the Civil Service Division cost center transfer of responsibility; and
WHEREAS a FY 2024 budget amendment of $111,642 is recommended to transfer funds from County Executive Administration Divisions - General Fund (#10100) to the Facilities Project Work Order Fund (#40400) for the moving of Department of Public Communications (DPC) and Purchasing Division between
floors at the Executive Office Building. Purchasing is moving to fourth floor and DPC is moving to Purchasing's old space; and
WHEREAS a FY 2024 -FY 2026 budget amendment is recommended for Corporation Counsel and Information Technology Fund (FND63600) to remove the Transfer Out built into the FY2024-FY2026 Adopted Budget, as this was a one-time expense. Refer to corresponding entry in Schedule B for IT Fund
(FND63600); and
Schedule A3
I I
R/E Fund Name Division Name
Fund #
(FND)Cost Center (CCN) #
Account #
(RC/SC)Program # (PRG)Grant ID (GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2024
Amendment
FY 2025
Amendment
FY 2026
Amendment
Oakland County, Michigan
FY 2024 First Quarter Financial Forecast and Budget Amendments
Schedule "A" DETAIL
E General Fund Health FND10100 CCN1060201 SC702010 PRG133020 702000 Salaries Regular (106,316)$ -$ -$
E General Fund Health FND10100 CCN1060201 SC722790 PRG133020 722000 Social Security (8,133) - -
E General Fund Health FND10100 CCN1060201 SC722770 PRG133020 722000 Retirement (27,562) - -
E General Fund Health FND10100 CCN1060201 SC722810 PRG133020 722000 Disability (1,717) - -
E General Fund Health FND10100 CCN1060201 SC722820 PRG133020 722000 Unemployment (64) - -
E General Fund Health FND10100 CCN1060201 SC722760 PRG133020 722000 Group Life (244) - -
E General Fund Health FND10100 CCN1060201 SC722750 PRG133020 722000 Workers Compensation (85) - -
E General Fund Health FND10100 CCN1060201 SC722780 PRG133020 722000 Hospitalization (17,614) - -
E General Fund Health FND10100 CCN1060201 SC722800 PRG133020 722000 Dental (1,290) - -
E General Fund Health FND10100 CCN1060201 SC722850 PRG133020 722000 Optical (43) - -
Total Expenditures (163,068)$ -$ -$
E General Fund Health FND10100 CCN1060214 SC702010 PRG133150 702000 Salaries Regular (68,532)$ -$ -$
E General Fund Health FND10100 CCN1060214 SC722790 PRG133150 722000 Social Security (5,243) - -
E General Fund Health FND10100 CCN1060214 SC722770 PRG133150 722000 Retirement (18,993) - -
E General Fund Health FND10100 CCN1060214 SC722810 PRG133150 722000 Disability (1,107) - -
E General Fund Health FND10100 CCN1060214 SC722820 PRG133150 722000 Unemployment (41) - -
E General Fund Health FND10100 CCN1060214 SC722760 PRG133150 722000 Group Life (157) - -
E General Fund Health FND10100 CCN1060214 SC722750 PRG133150 722000 Workers Compensation (55) - -
E General Fund Health FND10100 CCN1060214 SC722780 PRG133150 722000 Hospitalization (15,223) - -
E General Fund Health FND10100 CCN1060214 SC722800 PRG133150 722000 Dental (755) - -
E General Fund Health FND10100 CCN1060214 SC722850 PRG133150 722000 Optical (26) - -
Total Expenditures (110,132)$ -$ -$
E General Fund Health FND10100 CCN1060201 SC702010 PRG133150 702000 Salaries Regular (269,129)$ -$ -$
E General Fund Health FND10100 CCN1060201 SC722790 PRG133150 722000 Social Security (20,588) - -
E General Fund Health FND10100 CCN1060201 SC722770 PRG133150 722000 Retirement (69,445) - -
E General Fund Health FND10100 CCN1060201 SC722810 PRG133150 722000 Disability (4,345) - -
E General Fund Health FND10100 CCN1060201 SC722820 PRG133150 722000 Unemployment (161) - -
E General Fund Health FND10100 CCN1060201 SC722760 PRG133150 722000 Group Life (617) - -
E General Fund Health FND10100 CCN1060201 SC722750 PRG133150 722000 Workers Compensation (215) - -
E General Fund Health FND10100 CCN1060201 SC722780 PRG133150 722000 Hospitalization (41,817) - -
E General Fund Health FND10100 CCN1060201 SC722800 PRG133150 722000 Dental (2,386) - -
E General Fund Health FND10100 CCN1060201 SC722850 PRG133150 722000 Optical (91) - -
Total Expenditures (408,794)$ -$ -$
E General Fund Health FND10100 CCN1060230 SC702010 PRG133370 702000 Salaries Regular (330,798)$ -$ -$
E General Fund Health FND10100 CCN1060230 SC722790 PRG133370 722000 Social Security (25,306) - -
E General Fund Health FND10100 CCN1060230 SC722770 PRG133370 722000 Retirement (88,825) - -
E General Fund Health FND10100 CCN1060230 SC722810 PRG133370 722000 Disability (5,341) - -
E General Fund Health FND10100 CCN1060230 SC722820 PRG133370 722000 Unemployment (198) - -
E General Fund Health FND10100 CCN1060230 SC722760 PRG133370 722000 Group Life (758) - -
E General Fund Health FND10100 CCN1060230 SC722750 PRG133370 722000 Workers Compensation (265) - -
E General Fund Health FND10100 CCN1060230 SC722780 PRG133370 722000 Hospitalization (60,611) - -
E General Fund Health FND10100 CCN1060230 SC722800 PRG133370 722000 Dental (3,981) - -
E General Fund Health FND10100 CCN1060230 SC722850 PRG133370 722000 Optical (158) - -
Total Expenditures (516,241)$ -$ -$
E General Fund Health FND10100 CCN1060241 SC702010 PRG133390 702000 Salaries Regular (289,814)$ -$ -$
E General Fund Health FND10100 CCN1060241 SC722790 PRG133390 722000 Social Security (20,829) - -
E General Fund Health FND10100 CCN1060241 SC722770 PRG133390 722000 Retirement (69,868) - -
E General Fund Health FND10100 CCN1060241 SC722810 PRG133390 722000 Disability (4,330) - -
E General Fund Health FND10100 CCN1060241 SC722820 PRG133390 722000 Unemployment (174) - -
E General Fund Health FND10100 CCN1060241 SC722760 PRG133390 722000 Group Life (616) - -
E General Fund Health FND10100 CCN1060241 SC722750 PRG133390 722000 Workers Compensation (232) - -
E General Fund Health FND10100 CCN1060241 SC722780 PRG133390 722000 Hospitalization (32,223) - -
E General Fund Health FND10100 CCN1060241 SC722800 PRG133390 722000 Dental (2,103) - -
E General Fund Health FND10100 CCN1060241 SC722850 PRG133390 722000 Optical (49) - -
Total Expenditures (420,238)$ -$ -$
E General Fund Health FND10100 CCN1060240 SC702010 PRG133390 702000 Salaries Regular (70,476)$ -$ -$
E General Fund Health FND10100 CCN1060240 SC722790 PRG133390 722000 Social Security (5,391) - -
E General Fund Health FND10100 CCN1060240 SC722770 PRG133390 722000 Retirement (19,434) - -
E General Fund Health FND10100 CCN1060240 SC722810 PRG133390 722000 Disability (1,138) - -
E General Fund Health FND10100 CCN1060240 SC722820 PRG133390 722000 Unemployment (42) - -
E General Fund Health FND10100 CCN1060240 SC722760 PRG133390 722000 Group Life (162) - -
E General Fund Health FND10100 CCN1060240 SC722750 PRG133390 722000 Workers Compensation (973) - -
Health Division
Schedule A4
I I
R/E Fund Name Division Name
Fund #
(FND)Cost Center (CCN) #
Account #
(RC/SC)Program # (PRG)Grant ID (GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2024
Amendment
FY 2025
Amendment
FY 2026
Amendment
Oakland County, Michigan
FY 2024 First Quarter Financial Forecast and Budget Amendments
Schedule "A" DETAIL
E General Fund Health FND10100 CCN1060240 SC722780 PRG133390 722000 Hospitalization (19,962) - -
E General Fund Health FND10100 CCN1060240 SC722800 PRG133390 722000 Dental (1,283) - -
E General Fund Health FND10100 CCN1060240 SC722850 PRG133390 722000 Optical (43) - -
Total Expenditures (118,904)$ -$ -$
E General Fund Health FND10100 CCN1060104 SC702010 PRG133020 702000 Salaries Regular 106,316$ -$ -$
E General Fund Health FND10100 CCN1060104 SC722790 PRG133020 722000 Social Security 8,133 - -
E General Fund Health FND10100 CCN1060104 SC722770 PRG133020 722000 Retirement 27,562 - -
E General Fund Health FND10100 CCN1060104 SC722810 PRG133020 722000 Disability 1,717 - -
E General Fund Health FND10100 CCN1060104 SC722820 PRG133020 722000 Unemployment 64 - -
E General Fund Health FND10100 CCN1060104 SC722760 PRG133020 722000 Group Life 244 - -
E General Fund Health FND10100 CCN1060104 SC722750 PRG133020 722000 Workers Compensation 85 - -
E General Fund Health FND10100 CCN1060104 SC722780 PRG133020 722000 Hospitalization 17,614 - -
E General Fund Health FND10100 CCN1060104 SC722800 PRG133020 722000 Dental 1,290 - -
E General Fund Health FND10100 CCN1060104 SC722850 PRG133020 722000 Optical 43 - -
Total Expenditures 163,068$ -$ -$
E General Fund Health FND10100 CCN1060104 SC702010 PRG133150 702000 Salaries Regular 68,532$ -$ -$
E General Fund Health FND10100 CCN1060104 SC722790 PRG133150 722000 Social Security 5,243 - -
E General Fund Health FND10100 CCN1060104 SC722770 PRG133150 722000 Retirement 18,993 - -
E General Fund Health FND10100 CCN1060104 SC722810 PRG133150 722000 Disability 1,107 - -
E General Fund Health FND10100 CCN1060104 SC722820 PRG133150 722000 Unemployment 41 - -
E General Fund Health FND10100 CCN1060104 SC722760 PRG133150 722000 Group Life 157 - -
E General Fund Health FND10100 CCN1060104 SC722750 PRG133150 722000 Workers Compensation 55 - -
E General Fund Health FND10100 CCN1060104 SC722780 PRG133150 722000 Hospitalization 15,223 - -
E General Fund Health FND10100 CCN1060104 SC722800 PRG133150 722000 Dental 755 - -
E General Fund Health FND10100 CCN1060104 SC722850 PRG133150 722000 Optical 26 - -
Total Expenditures 110,132$ -$ -$
E General Fund Health FND10100 CCN1060104 SC702010 PRG133150 702000 Salaries Regular 269,129$ -$ -$
E General Fund Health FND10100 CCN1060104 SC722790 PRG133150 722000 Social Security 20,588 - -
E General Fund Health FND10100 CCN1060104 SC722770 PRG133150 722000 Retirement 69,445 - -
E General Fund Health FND10100 CCN1060104 SC722810 PRG133150 722000 Disability 4,345 - -
E General Fund Health FND10100 CCN1060104 SC722820 PRG133150 722000 Unemployment 161 - -
E General Fund Health FND10100 CCN1060104 SC722760 PRG133150 722000 Group Life 617 - -
E General Fund Health FND10100 CCN1060104 SC722750 PRG133150 722000 Workers Compensation 215 - -
E General Fund Health FND10100 CCN1060104 SC722780 PRG133150 722000 Hospitalization 41,817 - -
E General Fund Health FND10100 CCN1060104 SC722800 PRG133150 722000 Dental 2,386 - -
E General Fund Health FND10100 CCN1060104 SC722850 PRG133150 722000 Optical 91 - -
Total Expenditures 408,794$ -$ -$
E General Fund Health FND10100 CCN1060104 SC702010 PRG133370 702000 Salaries Regular 330,798$ -$ -$
E General Fund Health FND10100 CCN1060104 SC722790 PRG133370 722000 Social Security 25,306 - -
E General Fund Health FND10100 CCN1060104 SC722770 PRG133370 722000 Retirement 88,825 - -
E General Fund Health FND10100 CCN1060104 SC722810 PRG133370 722000 Disability 5,341 - -
E General Fund Health FND10100 CCN1060104 SC722820 PRG133370 722000 Unemployment 198 - -
E General Fund Health FND10100 CCN1060104 SC722760 PRG133370 722000 Group Life 758 - -
E General Fund Health FND10100 CCN1060104 SC722750 PRG133370 722000 Workers Compensation 265 - -
E General Fund Health FND10100 CCN1060104 SC722780 PRG133370 722000 Hospitalization 60,611 - -
E General Fund Health FND10100 CCN1060104 SC722800 PRG133370 722000 Dental 3,981 - -
E General Fund Health FND10100 CCN1060104 SC722850 PRG133370 722000 Optical 158 - -
Total Expenditures 516,241$ -$ -$
E General Fund Health FND10100 CCN1060104 SC702010 PRG133390 702000 Salaries Regular 289,814$ -$ -$
E General Fund Health FND10100 CCN1060104 SC722790 PRG133390 722000 Social Security 20,829 - -
E General Fund Health FND10100 CCN1060104 SC722770 PRG133390 722000 Retirement 69,868 - -
E General Fund Health FND10100 CCN1060104 SC722810 PRG133390 722000 Disability 4,330 - -
E General Fund Health FND10100 CCN1060104 SC722820 PRG133390 722000 Unemployment 174 - -
E General Fund Health FND10100 CCN1060104 SC722760 PRG133390 722000 Group Life 616 - -
E General Fund Health FND10100 CCN1060104 SC722750 PRG133390 722000 Workers Compensation 232 - -
E General Fund Health FND10100 CCN1060104 SC722780 PRG133390 722000 Hospitalization 32,223 - -
E General Fund Health FND10100 CCN1060104 SC722800 PRG133390 722000 Dental 2,103 - -
E General Fund Health FND10100 CCN1060104 SC722850 PRG133390 722000 Optical 49 - -
Total Expenditures 420,238$ -$ -$
E General Fund Health FND10100 CCN1060104 SC702010 PRG133390 702000 Salaries Regular 70,476$ -$ -$
E General Fund Health FND10100 CCN1060104 SC722790 PRG133390 722000 Social Security 5,391 - -
E General Fund Health FND10100 CCN1060104 SC722770 PRG133390 722000 Retirement 19,434 - -
E General Fund Health FND10100 CCN1060104 SC722810 PRG133390 722000 Disability 1,138 - -
E General Fund Health FND10100 CCN1060104 SC722820 PRG133390 722000 Unemployment 42 - -
E General Fund Health FND10100 CCN1060104 SC722760 PRG133390 722000 Group Life 162 - -
E General Fund Health FND10100 CCN1060104 SC722750 PRG133390 722000 Workers Compensation 973 - -
Schedule A5
I I I I I I I I I I I I I
R/E Fund Name Division Name
Fund #
(FND)Cost Center (CCN) #
Account #
(RC/SC)Program # (PRG)Grant ID (GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2024
Amendment
FY 2025
Amendment
FY 2026
Amendment
Oakland County, Michigan
FY 2024 First Quarter Financial Forecast and Budget Amendments
Schedule "A" DETAIL
E General Fund Health FND10100 CCN1060104 SC722780 PRG133390 722000 Hospitalization 19,962 - -
E General Fund Health FND10100 CCN1060104 SC722800 PRG133390 722000 Dental 1,283 - -
E General Fund Health FND10100 CCN1060104 SC722850 PRG133390 722000 Optical 43 - -
Total Expenditures 118,904$ -$ -$
R General Fund Health FND10100 CCN1060220 RC615571 PRG140010 GRN-1004194 665882 State Operating Grants (3,000)$ - -
R General Fund Health FND10100 CCN1060220 RC615571 PRG140010 GRN-1004250 665882 State Operating Grants (183,885) - -
R General Fund Health FND10100 CCN1060220 RC615571 PRG140010 GRN-1004199 665882 State Operating Grants (396,284) - -
R General Fund Health FND10100 CCN1060220 RC615571 PRG140010 GRN-1004191 665882 State Operating Grants (96,390) - -
R General Fund Health FND10100 CCN1060220 RC615571 PRG140010 GRN-1004189 665882 State Operating Grants (65,700) - -
R General Fund Health FND10100 CCN1060220 RC615571 PRG140010 GRN-1004189 665882 State Operating Grants (2,000) - -
R General Fund _Grants Health FND10101 CCN1060220 RC615571 PRG140010 GRN-1004194 665882 State Operating Grants 3,000$ - -
R General Fund _Grants Health FND10101 CCN1060220 RC615571 PRG140010 GRN-1004250 665882 State Operating Grants 183,885 - -
R General Fund _Grants Health FND10101 CCN1060220 RC615571 PRG140010 GRN-1004199 665882 State Operating Grants 396,284 - -
R General Fund _Grants Health FND10101 CCN1060220 RC615571 PRG140010 GRN-1004191 665882 State Operating Grants 96,390 - -
R General Fund _Grants Health FND10101 CCN1060220 RC615571 PRG140010 GRN-1004189 665882 State Operating Grants 65,700 - -
R General Fund _Grants Health FND10101 CCN1060220 RC615571 PRG140010 GRN-1004189 665882 State Operating Grants 2,000 - -
Total Revenues -$ -$ -$
R General Fund Health FND10100 CCN1060201 RC615675 PRG133150 615000 State Operating Grants (1,045,070) - -
R General Fund _Grants Human Services Grants FND10101 CCN1060201 RC615571 PRG133150 GRN-1004217 615000 State Operating Grants 1,045,070$ - -
Total Revenues -$ -$ -$
E General MSU Administration
Services
FND10100 CCN1060801 SC776661 PRG174000 770000 Motor Pool (206.00)$ (206.00)$ (206.00)$
E General Health Administration FND10100 CCN1060101 SC776661 PRG133150 770000 Motor Pool 206.00$ 206.00$ 206.00$
Total Expenses -$ -$ -$
E General Fund Health FND10100 CCN1060237 SC730646 PRG133310 Equipment Maintenance 1,700$ 1,700$ 1,700$
E General Fund Health FND10100 CCN1060241 SC731388 PRG133350 Printing 1,000 1,000 1,000
E General Fund Health FND10100 CCN1060232 SC731213 PRG134850 Membership Dues 400 400 400
E General Fund Health FND10100 CCN1060234 SC750301 PRG133300 Medical Supplies (850) (850) (850)
E General Fund Health FND10100 CCN1060234 SC750301 PRG133310 Medical Supplies (850) (850) (850)
E General Fund Health FND10100 CCN1060230 SC731213 PRG133150 Membership Dues 350 350 350
E General Fund Health FND10100 CCN1060230 SC732018 PRG133150 Travel and Conference 250 250 250
E General Fund Health FND10100 CCN1060241 SC731388 PRG133370 Printing (2,000) (2,000) (2,000)
Total Expenditures -$ -$ -$
E General Fund Health FND10100 CCN1060201 SC760160 PRG133150 PRJ-17311 760000 Furniture and Fixtures (6,837.00)$ -$ -$
E General Fund Health FND10100 CCN1060201 SC788001 PRG133150 PRJ-17311 BFA40400 788001 Transfers Out 6,837.00
Total Expenditures -$ -$ -$
Project Work Order Fund
R Project Work Orders Facilities Plan & Engineerin FND40400 CCN1040801 RC695500 PRG148020 PRJ-17311 BFA10100 695500 Transfers In 6,837.00$
Total Revenue 6,837.00$ -$ -$
E Project Work Orders Facilities Plan & Engineerin FND40400 CCN1040801 SC796500 PRG148020 796500 Budget Equity 6,837.00$ -$ -$
Total Expenditures 6,837.00$ -$ -$
Public Services - Administration
E General Fund
Public Services
Administration
FND10100 CCN1070101 SC731818 PRG132020 730000 Special Event Program (2,500.00)$ -$ -$
E General Fund
Public Services
Administration
FND10100 CCN1070101 SC732018 PRG132020 730000 Travel and Conference 2,500.00 - -
-$ -$ -$
WHEREAS a FY 2024 budget amendment is recommended for the Community Corrections Division reallocating the budgets between line-items; and
WHEREAS a FY 2024 budget amendment totaling $1,737,3778 is recommended for Health and Human Services, Health Division to reorganize the General Fund/General Purpose positions from the Health Division to Health and Human Services Administration Division as the budgets were inadvertently missed
during budget development; and
WHEREAS a FY 2024 budget amendment of $747,259 is recommended to move ELGE Grant from General Fund (#10100) to General Fund Grants (#10101) to properly track funding for the program (MR# 2032-3330); and
WHEREAS a FY 2024 budget amendment of $6,837 is recommended to transfer funds from Health and Human Services Department - General Fund (#10100) to the Facilities Project Work Order Fund (#40400) for the reconfiguration of the NOHC waiting room project; and
WHEREAS a FY 2024 - FY 2026 budget amendment totaling $3,700 is recommended for the Health Division to reallocate budgets between expenditure accounts to more accurately reflect the intended activity; and
WHEREAS a FY 2024 budget amendment of $1,045,070 is recommended to move Local Community Stabilization Authoritiy Grand funding from General Fund (#10100) to General Fund Grants (#10101) to properly track funding for the program; and
WHEREAS a FY 2024 - FY 2026 Budget Amendment is recommended for the Health Department to correct $206 in Motor Pool expenses which is attributed to the prior year reorganization; and
Schedule A6
I I I I
I I I I
I I I I
R/E Fund Name Division Name
Fund #
(FND)Cost Center (CCN) #
Account #
(RC/SC)Program # (PRG)Grant ID (GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2024
Amendment
FY 2025
Amendment
FY 2026
Amendment
Oakland County, Michigan
FY 2024 First Quarter Financial Forecast and Budget Amendments
Schedule "A" DETAIL
Public Services - Medical Examiner
E General Fund Medical Examiner FND10100 CCN1070601 SC732458 PRG132030 730000 Professional Services (10,000.00)$ -$ -$
E General Fund Medical Examiner FND10100 CCN1070601 SC730646 PRG132030 730000 Equipment Maintenance 10,000.00 - -
E General Fund Medical Examiner FND10100 CCN1070601 SC731339 PRG132030 730000 Periodicals Books Publ Sub (2,000.00)$ (2,000.00)$ (2,000.00)$
E General Fund Medical Examiner FND10100 CCN1070601 SC731346 PRG132030 730000 Personal Mileage (1,500.00) (1,500.00) (1,500.00)
E General Fund Medical Examiner FND10100 CCN1070601 SC731941 PRG132030 730000 Training 3,500.00 3,500.00 3,500.00
-$ -$ -$
R General Fund Non Departmental FND10100 CCN9010101 RC665882 PRG196030 665882 Planned use of Balance $ 345,900.00 $ - $ -
R General Fund Medical Examiner Administ FND10100 CCN1070601 RC630126 PRG132030 630000 Autopsies $ (585,900.00) - -
Total Revenues $ (240,000.00) $ - $ -
E General Fund Medical Examiner Administ FND10100 CCN1070601 SC731458 PRG132030 730000 Professional Services $ (240,000.00) $ - $ -
Total Expenditures $ (240,000.00) $ - $ -
R General Fund Medical Examiner Administ FND10100 CCN1070601 RC630126 PRG132030 630000 Autopsies $ 585,900.00 $ - $ -
Total Revenues $ 585,900.00 $ - $ -
E General Fund Medical Examiner Administ FND10100 CCN1070601 SC731458 PRG132030 730000 Professional Services $ 240,000.00 $ - $ -
E General Fund Non Departmental FND10100 CCN9010101 SC730359 PRG196030 730000 Contingency $ 345,900.00 - -
Total Expenditures $ 585,900.00 $ - $ -
WHEREAS a FY 2024 budget amendment is recommended to correct Miscellaneous Resolution #RPT 2023-3415 Public Services - Medical Examiner - Joint Operating Agreement Between Oakland County and Macomb County for Medical Examiner Services; and
Economic Development
E General Fund Veterans Service FND10100 CCN1090702 SC722750 PRG132050 722000 Workers Compensation (112.00)$ (117.03)$ (121.89)$
E General Fund Veterans Service FND10100 CCN1090702 SC702010 PRG132050 702000 Salaries Regular (140,329.00) (146,283.77) (152,362.63)
E General Fund Veterans Service FND10100 CCN1090702 SC722760 PRG132050 722000 Group Life (322.00) (335.34) (350.46)
E General Fund Veterans Service FND10100 CCN1090702 SC722770 PRG132050 722000 Retirement (36,553.00) (37,981.53) (40,219.29)
E General Fund Veterans Service FND10100 CCN1090702 SC722780 PRG132050 722000 Hospitalization (35,185.00) (40,076.09) (44,564.62)
E General Fund Veterans Service FND10100 CCN1090702 SC722790 PRG132050 722000 Social Security (10,735.00) (11,190.71) (11,655.74)
E General Fund Veterans Service FND10100 CCN1090702 SC722800 PRG132050 722000 Dental (2,038.00) (2,047.99) (2,109.43)
E General Fund Veterans Service FND10100 CCN1090702 SC722810 PRG132050 722000 Disability (2,266.00) (2,361.92) (2,460.07)
E General Fund Veterans Service FND10100 CCN1090702 SC722820 PRG132050 722000 Unemployment Insurance (84.00) (87.77) (91.42)
E General Fund Veterans Service FND10100 CCN1090702 SC722850 PRG132050 722000 Optical (56.00) (59.75) (62.74)
E General Fund Veterans Service FND10100 CCN1090401 SC722750 PRG132050 722000 Workers Compensation 112.00 117.03 121.89
E General Fund Veterans Service FND10100 CCN1090401 SC702010 PRG132050 702000 Salaries Regular 140,329.00 146,283.77 152,362.63
E General Fund Veterans Service FND10100 CCN1090401 SC722760 PRG132050 722000 Group Life 322.00 335.34 350.46
E General Fund Veterans Service FND10100 CCN1090401 SC722770 PRG132050 722000 Retirement 36,553.00 37,981.53 40,219.29
E General Fund Veterans Service FND10100 CCN1090401 SC722780 PRG132050 722000 Hospitalization 35,185.00 40,076.09 44,564.62
E General Fund Veterans Service FND10100 CCN1090401 SC722790 PRG132050 722000 Social Security 10,735.00 11,190.71 11,655.74
E General Fund Veterans Service FND10100 CCN1090401 SC722800 PRG132050 722000 Dental 2,038.00 2,047.99 2,109.43
E General Fund Veterans Service FND10100 CCN1090401 SC722810 PRG132050 722000 Disability 2,266.00 2,361.92 2,460.07
E General Fund Veterans Service FND10100 CCN1090401 SC722820 PRG132050 722000 Unemployment Insurance 84.00 87.77 91.42
E General Fund Veterans Service FND10100 CCN1090401 SC722850 PRG132050 722000 Optical 56.00 59.75 62.74
Total Expenditures -$ 0.00$ 0.00$
Non-Department
E General Fund Non-Dept. Transfers FND10100 CCN9090101 SC731822 PRG196030 730000 Special Projects (629,556.00)$
E General Fund Non-Dept. Transfers FND10100 CCN9090101 SC760180 PRG196030 750000 Technology Projects-One Time 629,556.00$
-$ -$ -$
E General Fund Non-Departmental FND10100 CCN9090101 SC730800 PRG196030 GRN-1004152 730000 Grant Match 305,724.00$ 305,724.00$ 305,724.00$
E General Fund Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 GRN-1004152 730000 Contingency (305,724.00) (305,724.00) (305,724.00)
Total Expenditures -$ -$ -$
E General Fund Non-Departmental FND10100 CCN9090101 SC730800 PRG196030 GRN-1004005 730000 Grant Match (326,276.00)$ (326,276.00)$ (326,276.00)$
E General Fund Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 GRN-1004005 730000 Contingency 326,276.00 326,276.00 326,276.00
Total Expenditures -$ -$ -$
WHEREAS a FY 2024- FY 2026 budget amendment is recommended for Non-Department correcting the account used for the local required match on the acceptance from the Michigan State Police for the Fiscal Year 2024 Oakland County Narcotics Enforcement Team (NET) Byrne Grant (Report 2023-3418); and
WHEREAS a FY 2024 $227,680, FY 2025 $240,542, and FY 2026 $253,998, respectively, is recommended for Economic Development, Veterans Services Division to reallocate the budget between cost centers as CCN1090702 is no longer an active cost center due the reorganization in FY 2022 (MR #21280); and
WHEREAS a FY 2024 budget amendment is recommended for the Medical Examiners Division reallocating Professional Services ($10,000) to Equipment Maintenance for replacing the faucets in the autopsy suite. In addition, $3,500 will be reallocated from Peridodicals Books Publ ($2,000-SC731339) and
Personal Mileage ($1,500-SC731346) to the Training expense line-item to reflect actual activity; and
WHEREAS a FY 2024 budget amendment in the amount of $629,556 is recommended for Non-Departmental Transfers division reallocating the budget between line items as the amount of the Carryforward from the FY 2023 Year End Report was budgeted into the incorrect spend category; and
Schedule A7
I I
R/E Fund Name Division Name
Fund #
(FND)Cost Center (CCN) #
Account #
(RC/SC)Program # (PRG)Grant ID (GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2024
Amendment
FY 2025
Amendment
FY 2026
Amendment
Oakland County, Michigan
FY 2024 First Quarter Financial Forecast and Budget Amendments
Schedule "A" DETAIL
E General Fund Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 730000 Contingency 4,253$ 4,253$ 4,253$
E General Fund Sheriff Patrol Services FND10100 CCN4030601 SC788001 PRG110010 BFA11005 788001 Transfers Out (4,253) (4,253) (4,253)
Total GF Expenditures -$ -$ -$
E General Fund Grants Non-Departmental FND10100 CCN9090101 SC730800 PRG196030 730000 Grant Match 597,744 597,744 597,744
E General Fund Grants Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 GRN-1004314 730000 Contingency (597,744) (597,744) (597,744)
Total Expenditures -$ -$ -$
E General Fund Grants Prosecuor Litigation FND10101 CCN4010201 SC730303 PRG122090 GRN-1003633 730000 Clothing Allowance 500.00$ -$ -$
E General Fund Grants Prosecuor Litigation FND10101 CCN4010201 SC730388 PRG122090 GRN-1003633 730000 Computer Research Service 1,854.00 - -
E General Fund Grants Prosecuor Litigation FND10101 CCN4010201 SC730373 PRG122090 GRN-1003633 730000 Contracted Services (130,651.00) - -
E General Fund Grants Prosecuor Litigation FND10101 CCN4010201 SC730422 PRG122090 GRN-1003633 730000 Court Transcripts 502.00 - -
E General Fund Grants Prosecuor Litigation FND10101 CCN4010201 SC730982 PRG122090 GRN-1003633 730000 Interpreter Fees 126.00 - -
E General Fund Grants Prosecuor Litigation FND10101 CCN4010201 SC731458 PRG122090 GRN-1003633 730000 Professional Services 110,589.00 - -
E General Fund Grants Prosecuor Litigation FND10101 CCN4010201 SC732018 PRG122090 GRN-1003633 730000 Travel snd Conference 2,827.00 - -
E General Fund Grants Prosecuor Litigation FND10101 CCN4010201 SC750170 PRG122090 GRN-1003633 750000 Other Expendable Equipment 12,934.00 - -
E General Fund Grants Prosecuor Litigation FND10101 CCN4010201 SC750399 PRG122090 GRN-1003633 750000 Office Supplies 1,119.00 - -
E General Fund Grants Prosecuor Litigation FND10101 CCN4010201 SC750413 PRG122090 GRN-1003633 750000 Parts and Accessories 200.00 - -
-$ -$ -$
E General Fund Grants Investigative & Forensic Sv FND10101 CCN4030901 SC712020 PRG110090 GRN-1004071 702000 Overtime (293.00)$ (293.00)$ (293.00)$
E General Fund Grants Investigative & Forensic Sv FND10101 CCN4030901 SC72277O PRG110090 GRN-1004071 722000 Retirement 212.00 212.00 212.00
E General Fund Grants Investigative & Forensic Sv FND10101 CCN4030901 SC722790 PRG110090 GRN-1004071 722000 Social Security 67.00 67.00 67.00
E General Fund Grants Investigative & Forensic Sv FND10101 CCN4030901 SC730324 PRG110090 GRN-1004071 730000 Communications 10,564.00 10,564.00 10,564.00
E General Fund Grants Investigative & Forensic Sv FND10101 CCN4030901 SC731465 PRG110090 GRN-1004071 730000 Program (10,550.00) (10,550.00) (10,550.00)
Total Expenditures -$ -$ -$
R General Fund Grants Patrol Services FND10101 CCN4030601 RC610313 PRG110000 GRN-1004332 610000 Federal Operating Grants $ - 8,313.00$ $ -
Total Revenues -$ 8,313.00$ -$
E General Fund Grants Patrol Services FND10101 CCN4030601 SC750070 PRG110000 GRN-1004332 750000 Deputy Supplies -$ 8,313.00$
Total Expenditures -$ 8,313.00$ -$
R General Fund Grants Investigative & Forensic Sv FND10101 CCN4030901 RC610313 PRG110060 GRN-1004264 610000 Federal Operating Grant $ (20,708.00) $ (20,708.00) $ (20,708.00)
R General Fund Grants Investigative & Forensic Sv FND10101 CCN4030901 RC610313 PRG110060 GRN-1004265 610000 Federal Operating Grant (20,708.00) (20,708.00) (20,708.00)
R General Fund Grants Investigative & Forensic Sv FND10101 CCN4030901 RC631869 PRG110060 GRN-1004264 630000 Reimb Salaries 20,708.00 20,708.00 20,708.00
R General Fund Grants Investigative & Forensic Sv FND10101 CCN4030901 RC631869 PRG110060 GRN-1004265 630000 Reimb Salaries 20,708.00 20,708.00 20,708.00
Total Revenues -$ -$ -$
WHEREAS a FY 2024 - FY 2026 budget amendment of $4,253 is recommended for the Sheriff's Office to remove Transfers Out and Transfers In budgets from the FY2023 Pedestrian and Bicycle OT Enforcement grant (FND11005 GRN-1004008) that is not anticipated to be awarded. The Transfer Out budget is
WHEREAS a FY 2024 - FY2026 budget amendment of $41,416 is recommended for the Sheriff's Office to reallocate grant budgets for Joint Terrorism Task Force (JTTF) and Safe Streets Task Force (SSTF) between revenue line items to accurately reflect the correct revenue category; and
WHEREAS a FY24 Sheriff's Office budget amendment of $8,313 is recommended to accept the Bulletproof Vest Program grant award. Miscellaneous Resolution #19006 authorizes Management and Budget to administratively process grant agreements and grant amendments of $10,000 or les; after review and
approval by Management and Budget, Human Resources, Risk Management and Corporation Counsel the grant does not require an associated interlocal agreement, there are no position changes, and the grantor does not require a separate resolution; and
WHEREAS as FY 2024 - FY 2026 budget amendment of $10,843 is recommended for the Sheriff's Office to recognize 2023 HIDTA NET grant Amendment #3 which is within 15% of the 2023 HIDTA NET grant acceptance (MR # 2023-3074). The amendment reallocates the budgets between expenditure line items
WHEREAS a FY 2024 budget amendment of $130,651 is recommended for the Prosecutor's Office Oxford School Incident Grant GRN-1003633 to reallocate budgets between line items to accurately reflect actual spending; and
General Fund - Grants FND 10101
WHEREAS a FY 2024-FY 2026 budget amendment of $597,744 is recommended to reclass funding from Grant Match account to Contingency account for General Fund, Non-Departmental Division as the account is no longer a budgeted line item; and
Schedule A8
I I I I I
I I I I
R/E Fund Name Division Name
Fund #
(FND)Cost Center (CCN) #
Account #
(RC/SC)
Program #
(PRG)Grant ID (GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2024
Amendment
FY 2025
Amendment
FY 2026
Amendment
R Friend of the Court Family Division FND27100 CCN3010404 RC695500 PRG126030 BFA27100 695500 Transfers In 17,414.00$ 17,414.00$ 17,414.00$ Subtotal Revenues 17,414.00$ 17,414.00$ 17,414.00$
E Friend of the Court Family Division FND27100 CCN3010404 SC702010 PRG126030 GRN-1004147 702000 Salaries Regular 10,300.00$ 10,300.00$ 10,300.00$
E Friend of the Court Family Division FND27100 CCN3010404 SC722790 PRG126030 GRN-1004147 722000 FICA 788.00 788.00 788.00
E Friend of the Court Family Division FND27100 CCN3010404 SC722770 PRG126030 GRN-1004147 722000 Retirement 2,497.00 2,497.00 2,497.00
E Friend of the Court Family Division FND27100 CCN3010404 SC722810 PRG126030 GRN-1004147 722000 Disability 154.00 154.00 154.00
E Friend of the Court Family Division FND27100 CCN3010404 SC722820 PRG126030 GRN-1004147 722000 Unemployment 6.00 6.00 6.00
E Friend of the Court Family Division FND27100 CCN3010404 SC722760 PRG126030 GRN-1004147 722000 Group Life 27.00 27.00 27.00
E Friend of the Court Family Division FND27100 CCN3010404 SC722750 PRG126030 GRN-1004147 722000 Workers Comp.91.00 91.00 91.00
E Friend of the Court Family Division FND27100 CCN3010404 SC722780 PRG126030 GRN-1004147 722000 Medical 3,384.00 3,384.00 3,384.00
E Friend of the Court Family Division FND27100 CCN3010404 SC722800 PRG126030 GRN-1004147 722000 Dental 159.00 159.00 159.00
E Friend of the Court Family Division FND27100 CCN3010404 SC722850 PRG126030 GRN-1004147 722000 Optical 8.00 8.00 8.00 Total Expenditure 17,414.00$ 17,414.00$ 17,414.00$
Judicial Grants (FND 11012)
E Judicial Grants Division I - Novi FND11012 CCN3020205 SC732018 PRG121050 GRN-1004290 730000 Travel and Conference (790.00)$ -$ -$
E Judicial Grants Division III - Rochester Hills FND11012 CCN3020405 SC732018 PRG121050 GRN-1004290 730000 Travel and Conference 790.00 - -
-$ -$ -$
E Judicial Grants Division I - Novi FND11012 CCN3020205 SC730373 PRG121050 GRN-1004290 730000 Contracted Services (700.00)$ -$ -$
E Judicial Grants Division II - Clarkston FND11012 CCN3020305 SC730373 PRG121050 GRN-1004290 730000 Contracted Services 100.00 - -
E Judicial Grants Division III - Rochester Hills FND11012 CCN3020405 SC730373 PRG121050 GRN-1004290 730000 Contracted Services 300.00 - -
E Judicial Grants Division IV - Troy FND11012 CCN3020505 SC730373 PRG121050 GRN-1004290 730000 Contracted Services 300.00 - -
-$ -$ -$
E Judicial Grants Division - I Novi FND11012 CCN3020205 SC730373 PRG121050 GRN-1004289 730000 Contractual Services (2,100.00)$ -$ -$
E Judicial Grants Division - I Novi FND11012 CCN3020205 SC732018 PRG121050 GRN-1004289 730000 Travel and Conference 2,100.00 - -
Total Expenditures -$ -$ -$
R Judicial Grants Division I - Novi FND11012 CCN3020205 SC730373 PRG121050 GRN-1004290 730000 Contracted Services (1,000.00)$ -$ -$
R Judicial Grants Division I - Novi FND11012 CCN3020205 SC750245 PRG121050 GRN-1004290 750000 Incentives 1,000.00 - -
-$ -$ -$
E Judicial Grants Division II - Clarkston FND11012 CCN3020305 SC732018 PRG121050 GRN-1004285 730000 Travel and Conference (120.00)$ -$ -$
E Judicial Grants Division II - Clarkston FND11012 CCN3020305 SC750245 PRG121050 GRN-1004285 750000 Incentives 120.00 - -
Total Expenditures -$ -$ -$
E Human Services Grants Health FND11007 CCN1060241 SC702010 PRG133390 G GRN-1004038 702000 Salaries Regular (27,760)$ -$ -$
E Human Services Grants Health FND11007 CCN1060241 SC722790 PRG133390 G GRN-1004038 722000 Social Security (403) - -
E Human Services Grants Health FND11007 CCN1060241 SC722770 PRG133390 G GRN-1004038 722000 Retirement (829) - -
E Human Services Grants Health FND11007 CCN1060241 SC722810 PRG133390 G GRN-1004038 722000 Disability - - -
E Human Services Grants Health FND11007 CCN1060241 SC722820 PRG133390 G GRN-1004038 722000 Unemployment (17) - -
E Human Services Grants Health FND11007 CCN1060241 SC722760 PRG133390 G GRN-1004038 722000 Group Life - - -
E Human Services Grants Health FND11007 CCN1060241 SC722750 PRG133390 G GRN-1004038 722000 Workers Compensation (22) - -
E Human Services Grants Health FND11007 CCN1060241 SC722780 PRG133390 G GRN-1004038 722000 Hospitalization - - -
E Human Services Grants Health FND11007 CCN1060241 SC722800 PRG133390 G GRN-1004038 722000 Dental - - -
E Human Services Grants Health FND11007 CCN1060241 SC722850 PRG133390 G GRN-1004038 722000 Optical - - -
E Human Services Grants Health FND11007 CCN1060104 SC702010 PRG133390 G GRN-1004038 702000 Salaries Regular 27,760 - -
WHEREAS a FY 2024 budget amendment in the amount of $1,000 is recommended for the 52nd District Court to recognize Amendment #1 to the FY2024 Michigan Mental Health Court Program grant, reallocating funding from Contracted Services to Incentives which causes no impact to the
original award (MR 2023-3480); and
Oakland County, Michigan
FY 2024 First Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
WHEREAS a FY 2024 budget amendment in the amount of $2,100 is recommended for the 52-1 District Court, recognizing Amendment #1 to the FY 2024 Combat Veteran's Court Program grant by reallocating budgets between line-items causing no impact to the original award (Report 2023-
3478) ; and
WHEREAS a FY2024 Budget Amendment is recommended for District Court reallocating $1,490 worth of funding between cost centers for the FY 2024 Mental Health Court grant; and
Friend of the Court (FND 27100)
WHEREAS a FY 2024 - FY 2026 budget amendment is recommended for Circuit Court' s Friend of the Court Fund (FND27100) correcting the budget within Report 2023-3683 as the positions were costed to the General Fund in error. Refer to related entry in Schedule A for Circuit Court's
Family division (FND 10100-General Fund/General Purpose); and
Human Services Grants (FND 11007)
WHEREAS a FY 2024 budget amendment in the amount of $120 is recommended for 52-2 District Court to recognize Amendment #1 to the FY2024 Drug Court Drug Program by reallocating budgets between line-items, causing no impact to the original award (Report 2023-3466); and
Schedule B9
R/E Fund Name Division Name
Fund #
(FND)Cost Center (CCN) #
Account #
(RC/SC)
Program #
(PRG)Grant ID (GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2024
Amendment
FY 2025
Amendment
FY 2026
Amendment
Oakland County, Michigan
FY 2024 First Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
E Human Services Grants Health FND11007 CCN1060104 SC722790 PRG133390 G GRN-1004038 722000 Social Security 403 - -
E Human Services Grants Health FND11007 CCN1060104 SC722770 PRG133390 G GRN-1004038 722000 Retirement 829 - -
E Human Services Grants Health FND11007 CCN1060104 SC722810 PRG133390 G GRN-1004038 722000 Disability - - -
E Human Services Grants Health FND11007 CCN1060104 SC722820 PRG133390 G GRN-1004038 722000 Unemployment 17 - -
E Human Services Grants Health FND11007 CCN1060104 SC722760 PRG133390 G GRN-1004038 722000 Group Life - - -
E Human Services Grants Health FND11007 CCN1060104 SC722750 PRG133390 G GRN-1004038 722000 Workers Compensation 22 - -
E Human Services Grants Health FND11007 CCN1060104 SC722780 PRG133390 G GRN-1004038 722000 Hospitalization - - -
E Human Services Grants Health FND11007 CCN1060104 SC722800 PRG133390 G GRN-1004038 722000 Dental - - -
E Human Services Grants Health FND11007 CCN1060104 SC722850 PRG133390 G GRN-1004038 722000 Optical - - -
Total Expenditures -$ -$ -$
R Human Services Grants Health FND11007 CCN1060290 RC615571 PRG115140 GRN-1004342 615000 State Operating Grants 175,000.00$ -$ -$
Total Revenues 175,000.00$ -$ -$
E Human Services Grants Health FND11007 CCN1060290 SC702010 PRG115140 GRN-1004342 702000 Salaries 107,899.00$ -$ -$
E Human Services Grants Health FND11007 CCN1060290 SC722790 PRG115140 GRN-1004342 722000 Social Security 8,254.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC722770 PRG115140 GRN-1004342 722000 Retirement 18,849.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC722810 PRG115140 GRN-1004342 722000 Disability 1,619.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC722820 PRG115140 GRN-1004342 722000 Unemployment 65.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC722760 PRG115140 GRN-1004342 722000 Group Life 281.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC722750 PRG115140 GRN-1004342 722000 Workers Compensation 950.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC722780 PRG115140 GRN-1004342 722000 Hospitalization 15,224.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC722800 PRG115140 GRN-1004342 722000 Dental 14.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC722850 PRG115140 GRN-1004342 722000 Optical 35.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC730585 PRG115140 GRN-1004342 730000 Employee License-Certification 500.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC730926 PRG115140 GRN-1004342 730000 Indirect Costs 14,901.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC774636 PRG115140 GRN-1004342 770000 Info Tech Operations 6,300.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC774677 PRG115140 GRN-1004342 770000 Insurance Fund 109.00 - -
Total Expenditures 175,000.00$ -$ -$
Law Enforcement Grants (FND11005)
R Law Enforcement Grants PA Litigation FND11005 CCN4010201 RC625210 PRG126070 GRN-1004287 625000 CRP 2,368,731.00$ $ 2,487,167.00 $ 2,487,167.00
R Law Enforcement Grants PA Litigation FND11005 CCN4010201 RC695500 PRG126070 GRN-1004354 BFA10100 695500 Transfer In- Gen Fund 1,220,255.00 1,281,268.00 1,469,682.00
Total Revenues 3,588,986.00$ 3,768,435.00$ 3,956,849.00$
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC702010 PRG126070 GRN-1004287 702000 Salaries 1,698,698.00$ 1,749,659.00$ 1,802,149.00$
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722750 PRG126070 GRN-1004287 722000 Workers Compensation 14,949.00 15,397.00 15,859.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722760 PRG126070 GRN-1004287 722000 Group Life 4,417.00 4,549.00 4,686.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722770 PRG126070 GRN-1004287 722000 Retirement 424,619.00 438,848.00 461,619.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722780 PRG126070 GRN-1004287 722000 Hospitalization 335,009.00 339,009.00 358,123.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722790 PRG126070 GRN-1004287 722000 Social Security 129,950.00 133,849.00 137,864.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722800 PRG126070 GRN-1004287 722000 Dental 15,708.00 15,708.00 15,708.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722810 PRG126070 GRN-1004287 722000 Disability 25,889.00 26,989.00 29,169.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722820 PRG126070 GRN-1004287 722000 Unemployment Insurance 1,019.00 1,050.00 1,081.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722850 PRG126070 GRN-1004287 722000 Optical 770.00 770.00 770.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730303 PRG126070 GRN-1004287 730000 Clothing Allowance 15,000.00 15,000.00 15,000.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730338 PRG126070 GRN-1004287 730000 Computer Research Services 20,500.00 30,500.00 30,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730646 PRG126070 GRN-1004287 730000 Equipment Maintenance 15,500.00 15,500.00 15,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730982 PRG126070 GRN-1004287 730000 Interpreter Fees 20,500.00 30,500.00 30,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730926 PRG126070 GRN-1004287 730000 Indirect Costs 214,093.00 224,798.00 236,037.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731213 PRG126070 GRN-1004287 730000 Memberships Dues 20,500.00 30,500.00 30,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731339 PRG126070 GRN-1004287 730000 Periodicals Books Publ Sub 30,500.00 30,500.00 37,475.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731346 PRG126070 GRN-1004287 730000 Personal Mileage 30,500.00 30,500.00 30,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731388 PRG126070 GRN-1004287 730000 Printing 30,500.00 30,500.00 30,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731458 PRG126070 GRN-1004287 730000 Professional Services 12,000.00 12,000.00 12,000.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731941 PRG126070 GRN-1004287 730000 Training 30,500.00 30,500.00 30,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC732018 PRG126070 GRN-1004287 730000 Travel and Conference 30,500.00 30,500.00 30,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC750170 PRG126070 GRN-1004287 750000 Other Expendable Equipment 20,000.00 20,000.00 30,000.00
WHEREAS a FY 2024 budget amendment of $175,000 is recommended for Health and Human Services Health Division to recognize the FY 2024 Emerging Threats Local Health Department Amendment #1 for the Regional Lab Workforce program that is within 15% of the FY 2024 Emerging
Threats grant acceptance (M.R. #2023-3306). Amendment #1 increases total funding from $6,263,627 to $6,438,627; and
WHEREAS a FY 2024 budget amendment totaling $29,031 is recommended for Health and Human Services, Health Division to reorganize the Special Revenues positions from the Health Division to Health and Human Services Administration Division as the budgets were inadvertently
missed during budget development; and
Schedule B10
I I I I I I I I I I I I I
R/E Fund Name Division Name
Fund #
(FND)Cost Center (CCN) #
Account #
(RC/SC)
Program #
(PRG)Grant ID (GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2024
Amendment
FY 2025
Amendment
FY 2026
Amendment
Oakland County, Michigan
FY 2024 First Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC750392 PRG126070 GRN-1004287 750000 Metered Postage 30,500.00 30,500.00 30,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC750399 PRG126070 GRN-1004287 750000 Office Supplies 21,865.00 21,865.00 21,865.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC770631 PRG126070 GRN-1004287 770000 Bldg Space Allocation 165,000.00 165,000.00 165,000.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC774636 PRG126070 GRN-1004287 770000 Info Tech Operations 140,000.00 195,000.00 230,000.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC774637 PRG126070 GRN-1004287 770000 Info Tech Managed Print Service 25,000.00 25,000.00 30,000.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC776659 PRG126070 GRN-1004287 770000 Motor Pool Fuel 16,000.00 16,000.00 25,000.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC776661 PRG126070 GRN-1004287 770000 Motor Pool 24,000.00 32,944.00 32,944.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC778675 PRG126070 GRN-1004287 770000 Telephone Communications 25,000.00 25,000.00 35,000.00
Total Expenditures 3,588,986.00$ 3,768,435.00$ 3,956,849.00$
R Law Enforcement Grants PA Litigation FND11005 CCN4010201 RC625210 PRG126070 GRN-0000143 625000 CRP $ (2,368,735.00) $ (2,368,735.00) $ (2,368,735.00)
R Law Enforcement Grants PA Litigation FND11005 CCN4010201 RC695500 PRG126070 GRN-1003741 BFA10100 695500 Transfer In- Gen Fund (1,220,257.00) (1,220,257.00) (1,220,257.00)
Total Revenues (3,588,992.00)$ (3,588,992.00)$ (3,588,992.00)$
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC702010 PRG126070 GRN-0000143 702000 Salaries (1,581,891.00)$ (1,581,891.00)$ (1,581,891.00)$
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC712020 PRG126070 GRN-0000143 702000 Overtime (42,000.00) (42,000.00) (42,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722750 PRG126070 GRN-0000143 722000 Workers Compensation (5,052.00) (5,052.00) (5,052.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722760 PRG126070 GRN-0000143 722000 Group Life (3,400.00) (3,400.00) (3,400.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722770 PRG126070 GRN-0000143 722000 Retirement (421,874.00) (421,874.00) (421,874.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722780 PRG126070 GRN-0000143 722000 Hospitalization (188,310.00) (188,310.00) (188,310.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722790 PRG126070 GRN-0000143 722000 Social Security (119,971.00) (119,971.00) (119,971.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722800 PRG126070 GRN-0000143 722000 Dental (18,634.00) (18,634.00) (18,634.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722810 PRG126070 GRN-0000143 722000 Disability (24,690.00) (24,690.00) (24,690.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722820 PRG126070 GRN-0000143 722000 Unemployment Insurance (1,583.00) (1,583.00) (1,583.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722850 PRG126070 GRN-0000143 722000 Optical (1,969.00) (1,969.00) (1,969.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722900 PRG126070 GRN-0000143 722000 Fringe Benefit Adjustment 49,608.00 49,608.00 49,608.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730163 PRG126070 GRN-0000143 730000 Blood Tests (5,000.00) (5,000.00) (5,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730303 PRG126070 GRN-0000143 730000 Clothing Allowance (5,000.00) (5,000.00) (5,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730338 PRG126070 GRN-0000143 730000 Computer Research Service (25,000.00) (25,000.00) (25,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730688 PRG126070 GRN-0000143 730000 Expert Witness Fee and Mileage (296,290.00) (296,290.00) (296,290.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730695 PRG126070 GRN-0000143 730000 Extradition Expense (40,000.00) (40,000.00) (40,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730926 PRG126070 GRN-0000143 730000 Indirect Costs (181,726.00) (181,726.00) (181,726.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730982 PRG126070 GRN-0000143 730000 Interpreter Fees (15,000.00) (15,000.00) (15,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731213 PRG126070 GRN-0000143 730000 Membership Dues (42,000.00) (42,000.00) (42,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731339 PRG126070 GRN-0000143 730000 Periodicals Books Publ Sub (30,000.00) (30,000.00) (30,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731346 PRG126070 GRN-0000143 730000 Personal Mileage (30,000.00) (30,000.00) (30,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731388 PRG126070 GRN-0000143 730000 Printing (30,000.00) (30,000.00) (30,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731458 PRG126070 GRN-0000143 730000 Professional Services (37,100.00) (37,100.00) (37,100.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731941 PRG126070 GRN-0000143 730000 Training (30,000.00) (30,000.00) (30,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC732018 PRG126070 GRN-0000143 730000 Travel and Conference (30,000.00) (30,000.00) (30,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC732020 PRG126070 GRN-0000143 730000 Travel Employee Taxable Meals (29,000.00) (29,000.00) (29,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC750154 PRG126070 GRN-0000143 750000 Expendable Equipment (5,000.00) (5,000.00) (5,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC750392 PRG126070 GRN-0000143 750000 Metered Postage (40,000.00) (40,000.00) (40,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC750399 PRG126070 GRN-0000143 770000 Office Supplies (40,000.00) (40,000.00) (40,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC770631 PRG126070 GRN-0000143 770000 Bldg Space Cost Allocation (118,000.00) (118,000.00) (118,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC774636 PRG126070 GRN-0000143 770000 Info Tech Operations (100,000.00) (100,000.00) (100,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC776659 PRG126070 GRN-0000143 770000 Motor Pool Fuel Charges (35,000.00) (35,000.00) (35,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC776661 PRG126070 GRN-0000143 770000 Motor Pool (25,000.00) (25,000.00) (25,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC777560 PRG126070 GRN-0000143 770000 Radio Communications (10,110.00) (10,110.00) (10,110.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC778675 PRG126070 GRN-0000143 770000 Telephone Communications (30,000.00) (30,000.00) (30,000.00)
Total Expenditures (3,588,992.00)$ (3,588,992.00)$ (3,588,992.00)$
E General Fund Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 GRN-1004354 730000 Contingency (1,220,255.00)$ (1,281,268.00)$ (1,345,329.00)$
E General Fund PA Litigation FND10100 CCN4010201 sc788001 PRG126070 GRN-1004354 BFA11005 788001 Transfer Out 1,220,255.00 1,281,268.00 1,345,329.00
E General Fund Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 730000 Contingency 1,297,794.00 1,297,794.00 1,297,794.00
E General Fund PA Litigation FND10100 CCN4010201 sc788001 PRG126070 BFA11005 788001 Transfer Out (1,297,794.00) (1,297,794.00) (1,297,794.00)
-$ 0.00 -$
WHEREAS a FY 2024 - FY 2026 budget amendment is recommended for the Prosecuting Attorney correcting the budget amendment reflected in MR 2023-3521 as the funds did not balance; and
Schedule B11
R/E Fund Name Division Name
Fund #
(FND)Cost Center (CCN) #
Account #
(RC/SC)
Program #
(PRG)Grant ID (GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2024
Amendment
FY 2025
Amendment
FY 2026
Amendment
Oakland County, Michigan
FY 2024 First Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
R Law Enforcement Grants PA Litigation FND11005 CCN4010201 RC625210 PRG126070 GRN-1004287 625000 CRP (2,368,731.00)$ (2,487,167.00)$ (2,487,167.00)$
R Law Enforcement Grants PA Litigation FND11005 CCN4010201 RC625210 PRG126070 GRN-1004295 625000 CRP 2,368,731.00 2,487,167.00 2,487,167.00
R Law Enforcement Grants PA Litigation FND11005 CCN4010201 RC695500 PRG126070 GRN-1004354 BFA10100 695500 Transfer In- Gen Fund (1,220,255.00) (1,281,268.00) (1,469,682.00)
R Law Enforcement Grants PA Litigation FND11005 CCN4010201 RC695500 PRG126070 GRN-1004296 BFA10100 695500 Transfer In- Gen Fund 1,220,255.00$ 1,281,268.00$ 1,469,682.00$
Total Revenues - - -
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC702010 PRG126070 GRN-1004295 702000 Salaries 1,698,698.00$ 1,749,659.00$ 1,802,149.00$
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722750 PRG126070 GRN-1004295 722000 Workers Compensation 14,949.00 15,397.00 15,859.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722760 PRG126070 GRN-1004295 722000 Group Life 4,417.00 4,549.00 4,686.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722770 PRG126070 GRN-1004295 722000 Retirement 424,619.00 438,848.00 461,619.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722780 PRG126070 GRN-1004295 722000 Hospitalization 335,009.00 339,009.00 358,123.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722790 PRG126070 GRN-1004295 722000 Social Security 129,950.00 133,849.00 137,864.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722800 PRG126070 GRN-1004295 722000 Dental 15,708.00 15,708.00 15,708.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722810 PRG126070 GRN-1004295 722000 Disability 25,889.00 26,989.00 29,169.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722820 PRG126070 GRN-1004295 722000 Unemployment Insurance 1,019.00 1,050.00 1,081.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722850 PRG126070 GRN-1004295 722000 Optical 770.00 770.00 770.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730303 PRG126070 GRN-1004295 730000 Clothing Allowance 15,000.00 15,000.00 15,000.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730338 PRG126070 GRN-1004295 730000 Computer Research Services 20,500.00 30,500.00 30,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730646 PRG126070 GRN-1004295 730000 Equipment Maintenance 15,500.00 15,500.00 15,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730982 PRG126070 GRN-1004295 730000 Interpreter Fees 20,500.00 30,500.00 30,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730926 PRG126070 GRN-1004295 730000 Indirect Costs 214,093.00 224,798.00 236,037.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731213 PRG126070 GRN-1004295 730000 Memberships Dues 20,500.00 30,500.00 30,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731339 PRG126070 GRN-1004295 730000 Periodicals Books Publ Sub 30,500.00 30,500.00 37,475.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731346 PRG126070 GRN-1004295 730000 Personal Mileage 30,500.00 30,500.00 30,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731388 PRG126070 GRN-1004295 730000 Printing 30,500.00 30,500.00 30,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731458 PRG126070 GRN-1004295 730000 Professional Services 12,000.00 12,000.00 12,000.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731941 PRG126070 GRN-1004295 730000 Training 30,500.00 30,500.00 30,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC732018 PRG126070 GRN-1004295 730000 Travel and Conference 30,500.00 30,500.00 30,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC750170 PRG126070 GRN-1004295 750000 Other Expendable Equipment 20,000.00 20,000.00 30,000.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC750392 PRG126070 GRN-1004295 750000 Metered Postage 30,500.00 30,500.00 30,500.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC750399 PRG126070 GRN-1004295 750000 Office Supplies 21,865.00 21,865.00 21,865.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC770631 PRG126070 GRN-1004295 770000 Bldg Space Allocation 165,000.00 165,000.00 165,000.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC774636 PRG126070 GRN-1004295 770000 Info Tech Operations 140,000.00 195,000.00 230,000.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC774637 PRG126070 GRN-1004295 770000 Info Tech Managed Print Service 25,000.00 25,000.00 30,000.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC776659 PRG126070 GRN-1004295 770000 Motor Pool Fuel 16,000.00 16,000.00 25,000.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC776661 PRG126070 GRN-1004295 770000 Motor Pool 24,000.00 32,944.00 32,944.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC778675 PRG126070 GRN-1004295 770000 Telephone Communications 25,000.00 25,000.00 35,000.00
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC702010 PRG126070 GRN-1004287 702000 Salaries (1,698,698.00) (1,749,659.00) (1,802,149.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722750 PRG126070 GRN-1004287 722000 Workers Compensation (14,949.00) (15,397.00) (15,859.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722760 PRG126070 GRN-1004287 722000 Group Life (4,417.00) (4,549.00) (4,686.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722770 PRG126070 GRN-1004287 722000 Retirement (424,619.00) (438,848.00) (461,619.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722780 PRG126070 GRN-1004287 722000 Hospitalization (335,009.00) (339,009.00) (358,123.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722790 PRG126070 GRN-1004287 722000 Social Security (129,950.00) (133,849.00) (137,864.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722800 PRG126070 GRN-1004287 722000 Dental (15,708.00) (15,708.00) (15,708.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722810 PRG126070 GRN-1004287 722000 Disability (25,889.00) (26,989.00) (29,169.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722820 PRG126070 GRN-1004287 722000 Unemployment Insurance (1,019.00) (1,050.00) (1,081.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC722850 PRG126070 GRN-1004287 722000 Optical (770.00) (770.00) (770.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730303 PRG126070 GRN-1004287 730000 Clothing Allowance (15,000.00) (15,000.00) (15,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730338 PRG126070 GRN-1004287 730000 Computer Research Services (20,500.00) (30,500.00) (30,500.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730646 PRG126070 GRN-1004287 730000 Equipment Maintenance (15,500.00) (15,500.00) (15,500.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730982 PRG126070 GRN-1004287 730000 Interpreter Fees (20,500.00) (30,500.00) (30,500.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC730926 PRG126070 GRN-1004287 730000 Indirect Costs (214,093.00) (224,798.00) (236,037.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731213 PRG126070 GRN-1004287 730000 Memberships Dues (20,500.00) (30,500.00) (30,500.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731339 PRG126070 GRN-1004287 730000 Periodicals Books Publ Sub (30,500.00) (30,500.00) (37,475.00)
Schedule B12
R/E Fund Name Division Name
Fund #
(FND)Cost Center (CCN) #
Account #
(RC/SC)
Program #
(PRG)Grant ID (GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2024
Amendment
FY 2025
Amendment
FY 2026
Amendment
Oakland County, Michigan
FY 2024 First Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731346 PRG126070 GRN-1004287 730000 Personal Mileage (30,500.00) (30,500.00) (30,500.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731388 PRG126070 GRN-1004287 730000 Printing (30,500.00) (30,500.00) (30,500.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731458 PRG126070 GRN-1004287 730000 Professional Services (12,000.00) (12,000.00) (12,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC731941 PRG126070 GRN-1004287 730000 Training (30,500.00) (30,500.00) (30,500.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC732018 PRG126070 GRN-1004287 730000 Travel and Conference (30,500.00) (30,500.00) (30,500.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC750170 PRG126070 GRN-1004287 750000 Other Expendable Equipment (20,000.00) (20,000.00) (30,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC750392 PRG126070 GRN-1004287 750000 Metered Postage (30,500.00) (30,500.00) (30,500.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC750399 PRG126070 GRN-1004287 750000 Office Supplies (21,865.00) (21,865.00) (21,865.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC770631 PRG126070 GRN-1004287 770000 Bldg Space Allocation (165,000.00) (165,000.00) (165,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC774636 PRG126070 GRN-1004287 770000 Info Tech Operations (140,000.00) (195,000.00) (230,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC774637 PRG126070 GRN-1004287 770000 Info Tech Managed Print Service (25,000.00) (25,000.00) (30,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC776659 PRG126070 GRN-1004287 770000 Motor Pool Fuel (16,000.00) (16,000.00) (25,000.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC776661 PRG126070 GRN-1004287 770000 Motor Pool (24,000.00) (32,944.00) (32,944.00)
E Law Enforcement Grants PA Litigation FND11005 CCN4010201 SC778675 PRG126070 GRN-1004287 770000 Telephone Communications (25,000.00) (25,000.00) (35,000.00)
Total Expenditures -$ -$ -$
E General Fund Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 GRN-1004354 730000 Contingency 1,220,255.00$ 1,281,268.00$ 1,345,329.00$
E General Fund PA Litigation FND10100 CCN4010201 sc788001 PRG126070 GRN-1004354 BFA11005 788001 Transfer Out (1,220,255.00) (1,281,268.00) (1,345,329.00)
E General Fund Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 GRN-1004296 730000 Contingency (1,220,255.00) (1,281,268.00) (1,345,329.00)
E General Fund PA Litigation FND10100 CCN4010201 sc788001 PRG126070 GRN-1004296 BFA11005 788001 Transfer Out 1,220,255.00 1,281,268.00 1,345,329.00
Total Expneditures -$ -$ -$
R Law Enforcement Grants Sheriff Patrol Services FND11005 CCN4030601 RC695500 PRG110010 GRN-1004008 BFA10100 695500 Transfers In (4,253.00)$ (4,253.00)$ (4,253.00)$
Total Revenue (4,253.00)$ (4,253.00)$ (4,253.00)$
E Law Enforcement Grants Sheriff Patrol Services FND11005 CCN4030601 SC712020 PRG110010 GRN-1004008 702000 Overtime (4,253.00)$ (4,253.00)$ (4,253.00)$
Total Expenditures (4,253.00)$ (4,253.00)$ (4,253.00)$
E Law Enforcement GrantsSheriff's Office - Inv. & Forensic FND11005 CCN4030901 SC731780 PRG116270 GRN-1004248 730000 Software Support Maintenance 59,800.00$ 59,800.00$ 59,800.00$
E Law Enforcement GrantsSheriff's Office - Inv. & Forensic FND11005 CCN4030901 SC760157 PRG116270 GRN-1004248 760000 Equipment 41,115.00 41,115.00 41,115.00
E Law Enforcement GrantsSheriff's Office - Inv. & Forensic FND11005 CCN4030901 SC774636 PRG116270 GRN-1004248 770000 Info Tech Ops (100,915.00) (100,915.00) (100,915.00)
Total Expenditures $ - $ - $ -
E Law Enforcement Grants Investigative & Forensic SvcFND11005 CCN4030901 SC730646 PRG116240 GRN-1004033 730000 Equipment Maintenance 2,850.00$ -$ -$
E Law Enforcement Grants Investigative & Forensic SvcFND11005 CCN4030901 SC732018 PRG116240 GRN-1004033 730000 Travel and Conference 3,200.00 - -
E Law Enforcement Grants Investigative & Forensic SvcFND11005 CCN4030901 SC774636 PRG116240 GRN-1004033 770000 Info Tech Ops (6,050.00) - -
Total Expenditures -$ -$ -$
E Law Enforcement Grants Technology Info. & InnovatioFND11005 CCN4030801 SC702010 PRG110085 GRN-1004009 702000 Salaries (160,000.00)$ $ - $ -
E Law Enforcement Grants Technology Info. & InnovatioFND11005 CCN4030801 SC722900 PRG110085 GRN-1004009 722000 Fringe Benefit Adjustments (91,000.00) - -
E Law Enforcement Grants Prosecutor Litigation FND11005 CCN4010201 SC702010 PRG122090 GRN-1004009 702000 Salaries (53,331.00) - -
E Law Enforcement Grants Prosecutor Litigation FND11005 CCN4010201 SC722900 PRG122090 GRN-1004009 722000 Fringe Benefit Adjustments (30,853.00) - -
E Law Enforcement Grants Technology Info. & InnovatioFND11005 CCN4030801 SC750070 PRG110085 GRN-1004009 750000 Deputy Supplies 339,630.00 - -
E Law Enforcement Grants Technology Info. & InnovatioFND11005 CCN4030801 SC760157 PRG110085 GRN-1004009 760000 Equipment 29,325.00 - -
E Law Enforcement Grants Technology Info. & InnovatioFND11005 CCN4030801 SC774636 PRG110085 GRN-1004009 770000 Info Tech Ops (33,771.00) - -
Total Expenditures -$ -$ -$
WHEREAS a FY2024 - FY2026 budget amendment of $100,915 is recommended for the Sheriff's Office to reallocate budget in the FY 2024 ATPA Grant (MR #2023-3355) to reflect actual spending. There is no change to the original award; and
WHEREAS a FY 2024-FY 2026 budget amendment is recommended for the Prosecutor's Office correcting grant identification number (worktags) used for the FY 2024 - FY 2026 CRP Title IV-D grant and the required local match; and
WHEREAS a FY 2024 budget amendment of $6,050 is recommended for the Sheriff's Office to recognize the 2022 DNA Capacity Enhancement Backlog Reduction (CEBR) Program Amendment #1 to move cost savings in equipment to Travel and Conference for additional training and
WHEREAS a FY 2024 - FY 2026 budget amendment of $4,253 is recommended for the Sheriff's Office to remove Transfers Out and Transfers In budgets for the FY2023 Pedestrian and Bicycle OT Enforcement grant that is not anticipated to be awarded. See related correcting entry in
Schedule B13
I I I I
R/E Fund Name Division Name
Fund #
(FND)Cost Center (CCN) #
Account #
(RC/SC)
Program #
(PRG)Grant ID (GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2024
Amendment
FY 2025
Amendment
FY 2026
Amendment
Oakland County, Michigan
FY 2024 First Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
E Law Enforcement Grants Technology Info. & InnovatioFND11005 CCN4030801 SC731780 PRG110085 GRN-1004009 730000 Software Support Maintenance 60,368.00$ -$ -$
E Law Enforcement Grants Technology Info. & InnovatioFND11005 CCN4030801 SC750070 PRG110085 GRN-1004009 750000 Deputy Supplies (7,411.00) - -
E Law Enforcement Grants Technology Info. & InnovatioFND11005 CCN4030801 SC760157 PRG110085 GRN-1004009 760000 Equipment (52,957.00) - -
Total Expenditures -$ -$ -$
R Other Grants Veterans Service FND11011 CCN1090401 RC615571 PRG132050 GRN-0001024 615000 State Operating Grants (127,352)$ (127,352)$ (127,352)$
Total Revenues (127,352)$ (127,352)$ (127,352)$
E Other Grants Veterans Service FND11011 CCN1090401 SC730072 PRG132050 GRN-0001024 730000 Advertising (27,352)$ (27,352)$ (27,352)$
E Other Grants Veterans Service FND11011 CCN1090401 SC731633 PRG132050 GRN-0001024 730000 Rental Property Maintenance (25,000) (25,000) (25,000)
E Other Grants Veterans Service FND11011 CCN1090401 SC732011 PRG132080 GRN-0001024 730000 Transportation Service (75,000) (75,000) (75,000)
Total Expenditures (127,352)$ (127,352)$ (127,352)$
Motorpool (FND 66100)
R Motor Pool Support Services Lease
Vehicles
FND66100 CCN1040210 RC665882 PRG184010 665882 Planned Use Fund Balance 201,332.00$ 201,332.00$ 201,332.00$
Total Revenues 201,332.00$ 201,332.00$ 201,332.00$
E Motor Pool
Support Services Lease
Vehicles FND66100 CCN1040210 SC730926 PRG184010 730000 Indirect Costs 201,332.00$ 201,332.00$ 201,332.00$
Total Expenses 201,332.00$ 201,332.00$ 201,332.00$
Park and Recreation (FND 50800)
E Parks and Recreation PR Addison Oaks FND50800 CCN5060150 SC702010 PRG160710 702000 Salaries Regular $ (27,600.00)(29,600.00)$ (31,400.00)$
E Parks and Recreation PR Addison Oaks FND50800 CCN5060150 SC722900 PRG160710 722000 Fringe Benefit Expense (10,623.00)(10,845.00)(11,350.00)
E Parks and Recreation PR Addison Oaks FND50800 CCN5060150 SC702010 PRG160720 702000 Salaries Regular 27,600.00 29,600.00 31,400.00
E Parks and Recreation PR Addison Oaks FND50800 CCN5060150 SC722900 PRG160720 722000 Fringe Benefit Expense 10,623.00 10,845.00 11,350.00
Total Expenditures -$ -$ -$
E Parks and Recreation PR Administration FND50800 CCN5060101 SC750154 PRG160000 750000 Expendable Equipment $ (50,000.00)-$ -$
E Parks and Recreation PR Administration FND50800 CCN5060101 SC730198 PRG160000 730000 Building Maint Charges 50,000.00 - -
Total Expenditures -$ -$ -$
E Parks and Recreation
PR White Lake Oaks Golf
Course FND50800 CCN5060180 SC712020 PRG160010 702000 Overtime
$ (15,600.00)-$ -$
E Parks and Recreation
PR White Lake Oaks Golf
Course FND50800 CCN5060180 SC712040 PRG160010 702000 Holiday Overtime
(1,100.00)- -
E Parks and Recreation PR White Lake Oaks FND50800 CCN5060180 SC712020 PRG160760 702000 Overtime 15,600.00 -$ -$
E Parks and Recreation PR White Lake Oaks FND50800 CCN5060180 SC712040 PRG160760 702000 Holiday Overtime 1,100.00 - -
Total Expenditures -$ -$ -$
WHEREAS a FY 2024 budget amendment of $368,955 is recommended for the Sheriff's Office to recognize Amendment #1 to the FY 2022 COPS Technology and Equipment Program Grant to utilize favorability from Salaries and Fringe Benefits for additional body-worn camera equipment
WHEREAS a FY 2024 budget amendment of $60,368 is recommended for the Sheriff's Office to recognize Amendment #2 to the FY 2022 COPS Technology and Equipment Program Grant to provide ongoing Software Support and Maintenance for the additional body-worn cameras
WHEREAS a FY 2024 - FY 2026 budget amendment of $127,352 is recommended for Economic Development, Veterans Services Division GRN-0001024 (County Veterans Service) correcting the budgets as the grant is inactive; and
Other Grants (FND11011)
WHEREAS a FY 2024 - FY 2026 Budget Amendment is recommended for the Motor Pool Fund(#66100) to correct Indirect Costs as the budget is determined after the finalizaion of the budget; and
WHEREAS a FY 2024 - FY 2026 budget amendment is recommended for Parks and Recreation to correct the program number used for the Addison Oaks Conference Center Salary and Fringes budget; and
WHEREAS a FY 2024 budget amendment is recommended for Parks and Recreation for a 1st quarter reallocation within Administration Division for flooring replacement activity; and
WHEREAS a FY 2024 budget amendment totaling $16,700 is recommended for Parks and Recreation correcting the program used within White Lake Oaks golf cost center; and
Schedule B14
I I I I I I I
I I I I
R/E Fund Name Division Name
Fund #
(FND)Cost Center (CCN) #
Account #
(RC/SC)
Program #
(PRG)Grant ID (GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2024
Amendment
FY 2025
Amendment
FY 2026
Amendment
Oakland County, Michigan
FY 2024 First Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
R Facilities M&O Facilities M&O FND63100 CCN1040701 RC665882 PRG140010 665882 Planned Use 281,453.00$ -$ -$
Total Revenues 281,453.00$ -$ -$
E Facilities M&O Facilities M&O FND63100 CCN1040701 SC760157 PRG140500 760000 Equipment 281,453.00$ -$ -$
Total Expenditures 281,453.00$ -$ -$
R Information Technology IT Administration FND63600 CCN1080101 RC665882 PRG152000 665882 Planned Use of Fund Balance 231,700.00$ 231,700.00$ 315,275.00$
Total Revenue 231,700.00$ 231,700.00$ 315,275.00$
E Information Technology IT Administration FND63600 CCN1080601 SC730646 PRG152000 730000 Equip Repairs & Maint 231,700.00$ 231,700.00$ 315,275.00$
Total Expenses 231,700.00$ 231,700.00$ 315,275.00$
R Information Technology IT Administration FND63600 CCN1080101 RC695500 PRG152000 BFA10100 695500 Transfers In (28,200.00)$ (28,200.00)$ (28,200.00)$
R Information Technology IT Administration FND63600 CCN1080101 RC665882 PRG152000 665882 Planned Use of Balance 28,200.00$ 28,200.00$ 28,200.00$
Total Revenues -$ -$ -$
R County Airports Economic Decelopment
Aviation and
Transportation
FND56500 CCN1090501 RC665882 PRG154010 665882 Planned Use of Fund Balance (100,000.00)$ -$ -$
Total Revenue (100,000.00)$ -$ -$
E County Airports Economic Development
Aviation and
Transportation
FND56500 CCN1090501 SC730814 PRG154010 730000 Grounds Maintenance 100,000.00$ -$ -$
Total Expenses 100,000.00$ -$ -$
E Fringe Fund
Non Departmental Little
Oaks
FND67800 CCN9011503 SC730283 PRG183180 730000 Child Care Services 350,000.00$ 350,000.00$ 350,000.00$
E Fringe Fund
Non Departmental Little
Oaks
FND67800 CCN9011503 SC731458 PRG183180 730000 Professional Services (350,000.00) (350,000.00) (350,000.00)
-$ -$ -$
E Delinquent Tax
Revolving
Treasurer Tax
Administration
FND51600 CCN7010101 SC788001 PRG186050 BFA10100 788001 Transfer Out (10,200,000.00)$ (10,200,000.00)$ (10,200,000.00)$
E Delinquent Tax
Revolving
Treasurer Tax
Administration
FND51600 CCN7010101 SC788001 PRG186050 BFA10100 788001 General Fund- Annual Subsidy 5,000,000.00 5,000,000.00 5,000,000.00
E Delinquent Tax
Revolving
Treasurer Tax
Administration
FND51600 CCN7010101 SC788001 PRG186050 BFA10100 788001 Collection Fees 2,700,000.00 2,700,000.00 2,700,000.00
E Delinquent Tax
Revolving
Treasurer Tax
Administration
FND51600 CCN7010101 SC788001 PRG186050 BFA31551 788001 Office Buildings Renovations Deb 2,500,000.00 2,500,000.00 2,500,000.00
-$ -$ -$
WHEREAS a FY 2024 -FY 2026 budget amendment is recommended for Corporation Counsel and Information Technology Fund (FND63600) to remove the Transfer Out built into the FY2024-FY2026 Adopted Budget, as this was a one-time expense. Refer to corresponding entry in Schedule
A for County Executive Administration; and
Facilities Maintenance & Operations (FND 63100)
Information Technology (FND 63600)
WHEREAS a FY 2024 - FY 2026 Budget Amendment is recommended for the Information Technology Fund (#63600) to correct line item budget for Equipmment Repair & Maintance as the budget needed to be adjusted during budget development and it was inadvertently missed; and
WHEREAS a FY 2024 budget amendment of $281,453 is recommended for the purchase of recycling bins and custodial equipment that were initially planned and budgeted to be purchased in FY 2023; and
WHEREAS a FY2024 budget amendment of $100,000, is recommended for Economic Development - Oakland County International Airport, Gounds Maintenance, due to special projects; and
County Airport (FND 56500)
WHEREAS a FY 2024 - FY 2026 Budget Amendment is recommended for the Fringe Benefit Fund ( FND 67800) to realloacate $350,000 from Professional Services to Child Care Services; and
Fringe Benefit Fund (FND 67800)
WHEREAS a FY 2024-FY 2026 budget amendment is recommended for the Treasurer's Delinquent Tax Revolving Fund (FND 51600) reallocating the Transfers Out Budget to its respective budget fund affiliates ; and
Delinquent Tax Revolving (FND 51600)
Schedule B15
I I I I I
R/E Fund Name Division Name
Fund #
(FND)Cost Center (CCN) #
Account #
(RC/SC)
Program #
(PRG)Grant ID (GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2024
Amendment
FY 2025
Amendment
FY 2026
Amendment
Oakland County, Michigan
FY 2024 First Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
R American Rescue Plan Non-Department FND21285 CCN9010101 RC610313 PRG133095 610000 Federal Operating Grants 17,000,000.00$ -$ -$
R American Rescue Plan Non-Department FND21285 CCN9010101 RC610313 PRG133095 GRN-1004343 610000 Federal Operating Grants (17,000,000.00)$
Total Revenue -$ -$ -$
R American Rescue Plan Non-Department FND21285 CCN9010101 RC610313 PRG133095 610000 Federal Operating Grants 64,003,821.00$ -$ -$
Total Revenue 64,003,821.00$ -$ -$
E American Rescue Plan Non Departmental
Operations
FND21285 CCN9010101 SC731885 PRG133095 GRN-1003457 730000 Supportive Services 2,975,266.00$ -$ -$
E American Rescue Plan Neighborhood & Housing
Development
FND21285 CCN1060701 SC731598 PRG133095 GRN-1003459 730000 Regranting Program 349,300.00 - -
E American Rescue Plan Economic Development
Administration
FND21285 CCN1090101 SC731598 PRG133095 GRN-1003461 730000 Regranting Program 5,262,255.00 - -
E American Rescue Plan Planning and Local
Business Develop
FND21285 CCN1090201 SC731836 PRG133095 GRN-1003503 730000 Sponsorship 45,000.00
E American Rescue Plan Neighborhood & Housing
Development
FND21285 CCN1060701 SC731885 PRG133095 GRN-1003512 730000 Supportive Services 309,500.00 - -
E American Rescue Plan Non Departmental
Operations
FND21285 CCN9010101 SC731598 PRG133095 GRN-1003596 730000 Regranting Program 2,566,900.00 - -
E American Rescue Plan Health Administration FND21285 CCN1060201 SC731598 PRG133095 GRN-1003599 730000 Regranting Program 92,800.00
E American Rescue Plan Health Administration FND21285 CCN1060201 SC731598 PRG133095 GRN-1003607 730000 Regranting Program 994,800.00
E American Rescue Plan Neighborhood & Housing
Development
FND21285 CCN1060701 SC731885 PRG133095 GRN-1003663 730000 Supportive Services 5,000,000.00 - -
E American Rescue Plan Neighborhood & Housing
Development
FND21285 CCN1060701 SC731885 PRG133095 GRN-1003687 730000 Supportive Services 5,000,000.00 - -
E American Rescue Plan Neighborhood & Housing
Development
FND21285 CCN1060701 SC731885 PRG133095 GRN-1003688 730000 Supportive Services 2,000,000.00 - -
E American Rescue Plan County Executive
Administration
FND21285 CCN1010101 SC731458 PRG133095 GRN-1003696 730000 Professional Servic 1,000,000.00 - -
E American Rescue Plan Health Administration FND21285 CCN1060201 SC730373 PRG133095 GRN-1003867 730000 Contracted Services 227,300.00 - -
E American Rescue Plan Health Administration FND21285 CCN1060201 SC730373 PRG133095 GRN-1003868 730000 Contracted Services 250,000.00 - -
E American Rescue Plan Neighborhood & Housing
Development
FND21285 CCN1060701 SC730373 PRG133095 GRN-1003869 730000 Contracted Services 300,000.00 - -
E American Rescue Plan Health Administration FND21285 CCN1060201 SC730373 PRG133095 GRN-1003870 730000 Contracted Services 2,000,000.00 - -
E American Rescue Plan Health Administration FND21285 CCN1060201 SC730373 PRG133095 GRN-1003871 730000 Contracted Services 1,000,000.00 - -
E American Rescue Plan Board of Commissioners
Administrati
FND21285 CCN5010101 SC731598 PRG133095 GRN-1003874 730000 Regranting Program 1,345,000.00 - -
E American Rescue Plan Health Administration FND21285 CCN1060201 SC731598 PRG133095 GRN-1003881 730000 Regranting Program 2,500,000.00 - -
E American Rescue Plan Planning and Local
Business Develop
FND21285 CCN1090201 SC731598 PRG133095 GRN-1004015 730000 Regranting Program 13,500,000.00 - -
E American Rescue Plan Board of Commissioners
Administrati
FND21285 CCN5010101 SC731465 PRG133095 GRN-1004016 730000 Program 980,700.00 - -
E American Rescue Plan Board of Commissioners
Administrati
FND21285 CCN5010101 SC731500 PRG133095 GRN-1004017 730000 Public Information 250,000.00
E American Rescue Plan PR - Catalpa Oaks FND21285 CCN5060201 SC730789 PRG133095 GRN-1004020 730000 Genl Program Administration 750,000.00 - -
E American Rescue Plan PR - Lyon Oaks FND21285 CCN5060201 SC730789 PRG133095 GRN-1004021 730000 Genl Program Administration 200,000.00
E American Rescue Plan PR - Red Oaks FND21285 CCN5060201 SC730789 PRG133095 GRN-1004022 730000 Genl Program Administration 3,750,000.00 - -
E American Rescue Plan PR - Waterford Oaks FND21285 CCN5060201 SC730789 PRG133095 GRN-1004023 730000 Genl Program Administration 3,500,000.00
E American Rescue Plan Board of Commissioners
Administrati
FND21285 CCN5010101 SC731500 PRG133095 GRN-1004158 730000 Public Information 500,000.00 - -
E American Rescue Plan Board of Commissioners
Administrati
FND21285 CCN5010101 SC731598 PRG133095 GRN-1004159 730000 Regranting Program 55,000.00
E American Rescue Plan Non Departmental
Operations
FND21285 CCN9010101 SC731598 PRG133095 GRN-1004171 730000 Regranting Program 500,000.00 - -
E American Rescue Plan PR-Pontiac Oaks FND21285 CCN5060201 SC730789 PRG133095 GRN-1004323 730000 Genl Program Administration 1,300,000.00
E American Rescue Plan PR-Oak Park Woods FND21285 CCN5060201 SC730789 PRG133095 GRN-1004324 730000 Genl Program Administration 1,500,000.00 - -
E American Rescue Plan PR-Southfield Oaks FND21285 CCN5060201 SC730789 PRG133095 GRN-1004325 730000 Genl Program Administration 1,500,000.00
WHEREAS a FY 2024 budget amendment of $17,000,000 is recommended for the American Rescue Plan Fund (21285) reversing the correction made with the FY 2023 Year End Report as the entry was correctly reflected in FY 2024-FY 2026 Adopted Budget load; and
American Rescue Plan (FND 21285)
Schedule B16
I I
R/E Fund Name Division Name
Fund #
(FND)Cost Center (CCN) #
Account #
(RC/SC)
Program #
(PRG)Grant ID (GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2024
Amendment
FY 2025
Amendment
FY 2026
Amendment
Oakland County, Michigan
FY 2024 First Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
E American Rescue Plan Hazel Park-Green Acres
Park
FND21285 ccn5060101 sc731598 PRG133095 GRN-1004326 730000 Regranting 400,000.00 - -
E American Rescue Plan Hazel Park Community
Center
FND21285 ccn5060101 sc731598 PRG133095 GRN-1004327 730000 Regranting 300,000.00
E American Rescue Plan PR-Oak Park Shepherd
Park Mkt
FND21285 ccn5060101 sc731598 PRG133095 GRN-1004328 730000 Regranting 500,000.00 - -
E American Rescue Plan Pontiac PR Crystal Lake FND21285 ccn5060101 sc731598 PRG133095 GRN-1004329 730000 Regranting 500,000.00
E American Rescue Plan RO Twp Mack Rowe Park FND21285 ccn5060101 sc731598 PRG133095 GRN-1004330 730000 Regranting 300,000.00 - -
E American Rescue Plan Southfield-Beech Woods
Park
FND21285 ccn5060101 sc731598 PRG133095 GRN-1004331 730000 Regranting 500,000.00
Total Expenditure 64,003,821.00$ -$ -$
WHEREAS a FY 2024 budget amendment totaling $64,003,821 is recommended for the American Rescue Plan Fund (21285) to carryforward the remaining balances from the FY 2023 appropriations; and
Schedule B17
COUNTY OF OAKLAND
FY 2024 FIRST QUARTER REPORT - GENERAL FUND
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2024 BUDGET AMOUNT
ADOPTED AS FY 2024 FAVORABLE/
BUDGET AMENDED FORECAST (UNFAVORABLE)PERCENT
REVENUES
GENERAL FUND
Taxes 307,645,907.11$ 307,645,907.11$ 307,645,907.11$ - 0.00%
Federal Grants 2,339,451.00 2,419,570.00 2,493,070.00 73,500.00 3.04%
State Grants 22,861,073.00 22,861,073.00 22,870,333.00 9,260.00 0.04%
Other Intergovernmental Revenue 55,014,534.00 55,014,534.00 54,875,534.00 (139,000.00) -0.25%
Charges for Services 125,967,216.00 127,320,955.00 123,569,090.00 (3,751,865.00) -2.95%
Indirect Cost Recovery 9,150,000.00 9,150,000.00 9,150,000.00 - 0.00%
Contributions 0.00 0.00 1,000.00 1,000.00
Investment Income 3,304,700.00 3,304,700.00 3,343,500.00 38,800.00 1.17%
Other Revenues 16,500.00 16,500.00 176,780.00 160,280.00 971.39%
Transfers In 44,327,977.00 56,355,443.00 56,377,243.00 21,800.00 0.04%
SUB-TOTAL GENERAL FUND/GENERAL PURPOSE 570,627,358.42$ 584,088,682.42$ 580,502,457.11$ (3,586,225.00)$ -0.61%
TOTAL GF/GP FUNDS 570,627,358.42$ 584,088,682.42$ 580,502,457.11$ (3,586,225.00)$ -0.61%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court 53,445,806.77$ 55,127,542.82$ 47,818,842.82 7,308,700.00$ 13.26%
52nd District Court 20,306,782.89 20,353,635.37 20,204,135.37 149,500.00 0.73%
Probate Court 8,325,470.27 8,392,233.27 8,043,033.27 349,200.00 4.16%
TOTAL ADMIN. OF JUSTICE 82,078,059.93$ 83,873,411.46$ 76,066,011.46$ 7,807,400.00$ 9.31%
LAW ENFORCEMENT
Prosecuting Attorney 27,732,067.90 28,304,009.07 26,559,009.07 1,745,000.00 6.17%
Sheriff 198,697,219.56 203,810,465.21 207,384,465.21 (3,574,000.00) -1.75%
TOTAL LAW ENFORCEMENT 226,429,287.46$ 232,114,474.28$ 233,943,474.28$ (1,829,000.00)$ -0.79%
GENERAL GOVERNMENT
Clerk/Register of Deeds 11,550,021.83 11,930,556.03 10,929,154.04 1,001,401.99 8.39%
Treasurer 9,010,040.85 9,213,351.85 7,667,651.85 1,545,700.00 16.78%
Board of Commissioners 5,737,575.22 6,332,478.66 6,035,478.66 297,000.00 4.69%
Water Resources Commissioner 8,479,591.25 8,517,686.25 8,514,886.25 2,800.00 0.03%
TOTAL GENERAL GOVERNMENT 34,777,229.15$ 35,994,072.79$ 33,147,170.80$ 2,846,901.99$ 7.91%
COUNTY EXECUTIVE
County Executive Admn.11,105,276.79$ 11,709,436.79$ 11,192,586.79$ 516,850.00$ 4.41%
Management and Budget 24,954,180.43 25,282,854.57 24,082,854.57 1,200,000.00 4.75%
Facilities Management 5,378,088.63 5,608,841.33 5,265,841.33 343,000.00 6.12%
Human Resources 6,276,367.26 6,436,622.51 6,269,322.51 167,300.00 2.60%
Health and Human Services 63,651,702.56 73,062,573.46 60,887,573.46 12,175,000.00 16.66%
Public Services 46,056,237.79 48,223,475.94 46,071,535.94 2,151,940.00 4.46%
Economic Development 11,303,843.84 20,046,608.84 19,624,108.84 422,500.00 2.11%
Emergency Management & Homeland Security 3,253,620.90 3,282,240.90 3,282,240.90 - 0.00%
Public Communication 3,962,765.23 4,517,395.27 4,509,295.27 8,100.00 0.18%
TOTAL COUNTY EXECUTIVE 175,942,083.43$ 198,170,049.61$ 181,185,359.61$ 16,984,690.00$ 8.57%
TOTAL DEPARTMENTS 519,226,659.97$ 550,152,008.14$ 524,342,016.15$ 25,809,991.99$ 4.69%
Non-Departmental 56,669,458.45$ 61,462,650.45$ 61,462,650.45 -
TOTAL GOVERNMENTAL EXPENDITURES 575,896,118.42$ 611,614,658.59$ 585,804,666.60$ 25,809,991.99$ 4.22%
General Fund/General Purpose
Favorable/(Unfavorable) - Budget Perspective 22,223,766.99$ 22,223,766.99$
PLANNED USE OF FUND BALANCE 5,268,760.00$ 27,525,976.17$ 27,525,976.17$ -$
Impact on Fund Balance (Includes Encumbrances)(5,302,209.18)$
18
AMOUNT
ADOPTED AMENDED FY 2024 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
TAXES (601000-601999)
Property Taxes - July Tax Levy 305,725,907.11$ 305,725,907.11$ 305,725,907.11 -$ 0.00%At budget
Other Taxes - Delinquent Tax - Prior Years 125,000.00 125,000.00 125,000.00 - 0.00%At budget
Marijuana Tax 1,100,000.00 1,100,000.00 1,100,000.00 - 0.00%At budget
Treasurer Payment in Lieu of Taxes 600,000.00 600,000.00 600,000.00 - 0.00%At budget
Trailer Tax 95,000.00 95,000.00 95,000.00 - 0.00%At budget
Total Taxes 307,645,907.11$ 307,645,907.11$ 307,645,907.11$ -$ 0.00%
FEDERAL GRANTS (610000-610999)
Sheriff - Sheriff's Office -$ -$ -$ -$ 0.00%
Sheriff - Emergency Response and Prep - - - - 0.00%
Sheriff - Patrol - 8,313.00 126,313.00 118,000.00 1419.46%Fav. Marine Safety Grant that is budgeted in Other Inter-governmental
Revenues.
Sheriff - Investigative/Forensic Services 132,300.00 173,716.00 173,716.00 - 0.00%At budget
Prosecuting Attorney 300,000.00 300,000.00 300,000.00 - 0.00%At budget
Homeland Security - Disaster Control - - - - 0.00%
Emergency Management and Homeland Security 993,729.00 1,024,119.00 1,024,119.00 - 0.00%At budget
Health Division 613,422.00 613,422.00 613,422.00 - 0.00%At budget
Children's Village 300,000.00 300,000.00 255,500.00 (44,500.00) -14.83%Unfav. School Lunch program ($100,000) serving less due to decline in
population of residents. Partially offset by $55,000 due grant funding on
food accessibility and supply chain issues.
Non-Department - - - - 0.00%
Total Federal Grants 2,339,451.00$ 2,419,570.00$ 2,493,070.00$ 73,500.00$ 3.04%
STATE GRANTS (615000-615999)
Sheriff - Emergency Response and Prep -$ -$ 6,729.00$ 6,729.00$ 100.00%Fav. due to timing of grant payment for Public Safety Academy
Assistance Program
Sheriff - Patrol Services -$ -$ -$ -$ 0.00%
State Match Foster Care - - -$ - 0.00%
Prosecuting Attorney - - - - 0.00%Crime Victim Rights Grant actuals moving to Charges for Services FY24
Q2.
Clerk - County Clerk - - 2,531.00 2,531.00 100.00%Fav. due to SCAO (State Court Administrative Office) Grant funding
College Intern Positions.
Economic Development - - - - 0.00%
Health Division 7,081,450.00 7,081,450.00 7,081,450.00 - 0.00%At budget
Facilities Management - - - -
Water Resources Commissioner - - - - 0.00%
Economic Development - Veteran's Services - - - - 0.00%
Non-Departmental - Child Care Subsidy 15,779,623.00 15,779,623.00 15,779,623.00 - 0.00%At budget
Total State Grants 22,861,073.00$ 22,861,073.00$ 22,870,333.00$ 9,260.00$ 0.04%
OTHER INTER-GOVERNMENTAL REVENUES (620000 - 626999)
Non-Departmental 52,750,000.00$ 52,750,000.00$ 52,750,000.00$ -$ 0.00%At budget
HHS - Homeland Security - - - - 0.00%
Emergency Management - Homeland Security 9,000.00 9,000.00 9,000.00 - 0.00%At budget
Circuit Court-Judicial Admin - - - - 0.00%
Circuit Court- Civil Criminal 4,500.00 4,500.00 4,500.00 - 0.00%At budget.
District Court - - - - 0.00%
District Court 1,800.00 1,800.00 - (1,800.00) -100.00%Unfavorable Drug Case Management ($1,800) due to actuals activity
being lower than budgeted.
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2024 FIRST QUARTER REPORT
19
AMOUNT
ADOPTED AMENDED FY 2024 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2024 FIRST QUARTER REPORT
Probate Court - - - - 0.00%
Sheriff 255,050.00 255,050.00 117,850.00 (137,200.00) -53.79%Unfav. Social Security Incentive Payments ($19,200) as a result of a
reduction in the number of inmates receiving social security. Funds are
collected from jail inmates who receive SSI to offset the cost of
incarceration. Also unfav. Marine Safety Grant ($118,000) with Actuals
in Federal Operating Grants.
Non-Departmental - Reimb Judges Salaries 1,994,184.00 1,994,184.00 1,994,184.00 - 0.00%At budget
Total Other Intergovernmental Revenue 55,014,534.00$ 55,014,534.00$ 54,875,534.00$ (139,000.00)$ -0.25%
CHARGES FOR SERVICES (630000-635999)
Administration of Justice
Circuit Court - Judicial/Administration -$ -$ 1,000.00$ 1,000.00$ 100.00%Favorable $1,000 in Judge On Line Services due to adjustment for
CRE.
Circuit Court - Civil/Criminal 666,700.00 666,700.00 1,108,500.00 441,800.00 66.27%Favorability primarily due to $262,700 in Jury Fees due to increased
activity. Also favorable $264,000 in Reimb General from Michigan State
Appellate Defender Office/Michigan Appellate Assigned Counsel
System (SADO/MAACS) for the 50% reimbursement on Defense Atty
Fees Appellate paid at Michigan Indigent Defense Commission (MIDC)
rates. Also favorable $87,800 in Costs due in part to policy change to no
longer assign court costs; previously assigned court costs are still being
collected. Partially offset by unfavorability of ($50,000) in Civil Mediation
Payments due to law changes resulting in less activity.
Circuit Court - Family Division 187,500.00 187,500.00 219,300.00 31,800.00 16.96%Favorability primarily attributed to Adoptive Info Request Fee $14,000
due to increased activity. Also favorable Costs $9,600 as
reimbursements continue to come in.
District Court - Division I (Novi)3,039,753.00 3,039,753.00 1,720,153.00 (1,319,600.00) -43.41%Unfavorability primarily due to Ordinance Fines and Costs ($601,400);
Probation Fees ($209,200); and State Law Costs ($146,900) attributed
to changes in legislation.
District Court - Division II (Clarkston)1,616,941.00 1,616,941.00 959,641.00 (657,300.00) -40.65%Unfavorability primarily due to Ordinance Fines and Costs ($161,900);
State Law Costs ($328,600); and Probation Fees ($10,700) attributed to
changes in legislation.
District Court - Division III (Rochester Hills)3,500,015.00 3,500,015.00 2,199,915.00 (1,300,100.00) -37.15%Unfavorability primarily from Ordinance Fines and Costs ($776,600) as
well as Probation Fees ($265,500) due to changes in legislation.
District Court - Division IV (Troy)1,589,403.00 1,589,403.00 1,048,703.00 (540,700.00) -34.02%Unfavorability primarily due Ordinance Fines and Costs ($218,900)
attributed to the reduction in caseload from marijuana legalization and
other policy changes. Unfav. Probation Fees ($84,800) as well as State
Law Costs ($49,200) attributed to changes in legislation.
Probate Court - Estates and Mental Health 532,650.00 532,650.00 717,250.00 184,600.00 34.66%Favorable primarily due to Gross Estate Fees $103,100 due to a
increase in fees paid. Fav. Certified Copies $39,600 and Photostats
$18,000 due to an increase in activity.
Total Administration of Justice 11,132,962.00$ 11,132,962.00$ 7,974,462.00$ (3,158,500.00)$ -28.37%
20
AMOUNT
ADOPTED AMENDED FY 2024 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2024 FIRST QUARTER REPORT
Law Enforcement
Prosecuting Attorney 833,621.00$ 833,621.00$ 813,621.00 (20,000.00) -2.40%Unfav. Reimb General ($8,000) from the 46th District Court, Educational
Training ($6,100), Extradition Recovery Fee ($4,000)and Microfilming
($1,500) due to less activity.
Sheriff's Office 2,900.00 2,900.00 3,200.00 300.00 10.34%Fav. DNA Testing Fees due to increased activity.
Sheriff - Administrative Services 243,500.00 243,500.00 203,500.00 (40,000.00) -16.43%Unfav. Fingerprints ($60,000), and Registration Fees ($10,000) due to
reduced activity; partially offset by fav. FOIA Fees $22,000 and
Photostats $8,000 due to increased activity.
Sheriff - Corrective Services 2,381,342.00 2,381,342.00 2,481,342.00 100,000.00 4.20%Fav. Commissions Contracts $150,000 due to increased usage of the
Commissary and Diverted Felon $65,000 due to the number of inmates
that meet reimbursement criteria; partially offset by unfav. Inmate Board
and Care ($100,000) due to lower collection rates.
Sheriff - Corrective Services Satellites 961,099.00 961,099.00 921,099.00 (40,000.00) -4.16%Unfav. Civil Action Service Fees ($45,000) duel to less activity and
Board and Care ($5,000) due to less than anticipated judge referrals to
the tether program; partially offset by fav. Reimb Court Services
$10,000 due to higher than budgeted court security services.
Sheriff - Emergency Response and Prep - - - - 0.00%
Sheriff - Patrol Services 65,992,466.00 66,760,305.00 66,960,305.00 200,000.00 0.30%Fav. Reimbursement Salaries $550,000 due to contracts with venues
such as Pine Knob and Meadowbrook; partially offset by unfav. Reimb
Contracts ($340,000) Impound Fees ($10,000) due to reduced activity.
Sheriff - Emergency Communications Operations 2,872,878.00 2,872,878.00 2,872,878.00 - 0.00%
Sheriff - Investigative Forensic Services 1,015,000.00 1,015,000.00 505,000.00 (510,000.00) -50.25%Unfav. primarily due to Drug Testing ($550,000) as the Results testing
program has not returned to full capacity since the pandemic and is
experiencing a lower number of clients. Partially offset by favorable
operating expenditures. Also fav. Reimb Contracts $25,000 and Reimb
Salaries $10,000 due to task force reimbursement.
Total Law Enforcement 74,302,806.00$ 75,070,645.00$ 74,760,945.00$ (309,700.00)$ -0.41%
General Government
Clerk - Administration -$ -$ - -$ 0.00%
Clerk - County Clerk 2,183,100.00$ 2,183,100.00$ 2,183,100.00 -$ 0.00%At budget
Clerk - Elections 196,900.00 196,900.00 196,900.00 - 0.00%At budget
Clerk - Register of Deeds & Micrographics 13,548,500.00 13,548,500.00 13,548,500.00 - 0.00%At budget
Treasurer 3,466,100.00 3,466,100.00 3,164,590.00 (301,510.00) -8.70%Unfav. Civil Action Service Fees ($198,000), Maintenance Contracts
($50,000), Foreclosure Notification Fee ($37,449) and Deeds ($34,000).
Partially offset by Fav. Recording Fee Redemption Certi $10,000 due to
increased activity and collection of fee. Also Fav. FOIA $16,535 due to
requests. Overarching cause is due to land sales activity.
Board of Commissioners 3,700.00 3,700.00 2,400.00 (1,300.00) -35.14%Unfav. Fee Income ($1,300) due to less prescription royalties due to
decrease demand.
Water Resources Commissioner 3,854,519.00 3,854,519.00 3,864,519.00 10,000.00 0.26%Fav - Soil Erosion Fees $10,000 increase in building activity/permits due
to improvement in the housing market.
Total General Government 23,252,819.00$ 23,252,819.00$ 22,960,009.00$ (292,810.00)$ -1.26%
21
AMOUNT
ADOPTED AMENDED FY 2024 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2024 FIRST QUARTER REPORT
County Executive
County Exec - Corp Counsel - - 240.00 240.00 100.00%Fav. Due to FOIA requests totaling $240 for Q1 of FY2024.
County Exec - Admin - - - - 0.00%
M&B - Equalization Division 3,655,054.00 3,655,054.00 3,655,054.00 - 0.00%At budget
M&B - Fiscal Services Division 134,660.00 134,660.00 134,660.00 - 0.00%At budget
M&B - Purchasing Division 715,690.00 715,690.00 715,690.00 - 0.00%At budget
Facilities Management - Support Services 396,000.00 396,000.00 396,000.00 - 0.00%At budget
Human Resources - - - 0.00%
HHS - Administration - - - - 0.00%Favorable due to Psych Testing and Evaluation fees being more than
anticipated.
HHS - Health Division 4,177,916.00 4,177,916.00 4,177,916.00 - 0.00%At budget
HHS - Neighborhood & Housing Development - - - - 0.00%
Public Services - Community Corrections 8,750.00 8,750.00 11,700.00 2,950.00 33.71%Fav. Fee Income due to intake and higher than anticipated referrals
from Judges.
Public Services - Children's Village 4,763,987.00 4,763,987.00 5,596,540.00 832,553.00 17.48%Fav. Out County Board and Care $1,000,000 and Guaranteed Beds-
Shelter Care $29,027 due to out-county kids. Partially offset by Unfav
Child Care State Aid ($85,774) due to in-county kids.
Public Services - Medical Examiner 469,850.00 1,055,750.00 713,000.00 (342,750.00) -32.47%Unfav. Autopsies (400,650) due to joint operating agreement with
macomb county (MR 2023-3415) and the number of autopsies
performed. Also Unfav. Medical Services ($7,875) due to less number of
cases. Partially Offset by Fav. Cremation Approval Fees $65,875 due to
increase in Cremation permit activity and Lapper County contract.
Public Services - Animal Control 1,722,014.00 1,722,014.00 1,138,166.00 (583,848.00) -33.90%Unfav. Sale of Licenses ($587,814) due to smaller census team and
lower activity ever since the COVID-19 pandemic. Partially Offset by
Fav. Services Fees $12,050 due to higher sales of License by CVT (city,
villages and township).
Public Services - Circuit Court Probation - - - - 0.00%
Economic Development - Planning & Local Bus Dev. (FKA PEDS) 316,708.00 316,708.00 316,708.00 - 0.00%At bidget
Economic Development - Veterans - - - - 0.00%
Total County Executive 16,360,629.00$ 16,946,529.00$ 16,855,674.00$ (90,855.00)$ -0.54%At budget
Non-Departmental
Non-Dept - Charges for Services 918,000.00$ 918,000.00$ 1,018,000.00 100,000.00 10.89%Fav. due to Commission Public Telephone due to increased activity.
Total Non-Departmental 918,000.00$ 918,000.00$ 1,018,000.00$ 100,000.00$ 10.89%
Total Charges for Services 125,967,216.00$ 127,320,955.00$ 123,569,090.00$ (3,751,865.00)$ -2.95%
INDIRECT COST RECOVERY (640100)9,150,000.00$ 9,150,000.00$ 9,150,000.00 -$ 0.00%At budget
22
AMOUNT
ADOPTED AMENDED FY 2024 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2024 FIRST QUARTER REPORT
CONTRIBUTIONS (650000)
Board of Commissioners-Contributions - - - - 0.00%
Sheriff Patrol Services Donations
Health Division - - 0.00%
Department of Public Communications - Sponsorships - - - - 0.00%
Economic Development & Comm Affairs - Contributions - - - - 0.00%
Non-Departmental - - 0.00%
Economic Development - Contributions - - - - 0.00%
Water Resources Commissioner - - 1,000.00 1,000.00 100.00%Fav. $1,000 in Sponsorships due to higher than anticipated use.
Total Contributions Revenues -$ -$ 1,000.00$ 1,000.00$ 100.00%
INVESTMENT INCOME (655000)
District Courts (Div. I - IV)2,200.00 2,200.00 2,200.00 - 0.00%At budget.
Sheriff Corrective Services - - - - 0.00%
Sheriff Investigative/Forensic Services - - - - 0.00%
Treasurer 300,000.00 300,000.00 338,800.00 38,800.00 12.93%Fav. due to investment base and market rate adjustments.
Clerk/Register of Deeds 2,500.00 2,500.00 2,500.00 - 0.00%At budget
Fiscal Services - - - - 0.00%
Economic Development - - - - 0.00%
Health Division - - - - 0.00%
Non-Departmental 3,000,000.00 3,000,000.00 3,000,000.00 - 0.00%At budget
Total Investment Income 3,304,700.00$ 3,304,700.00$ 3,343,500.00$ 38,800.00$ 1.17%
OTHER REVENUES (670000)
Circuit Court - Donations -$ -$ -$ -$ 0.00%
Circuit Court - - - - 0.00%
District Courts (Div. I - IV)- - - - 0.00%
District Courts (Div. I - IV)- - - - 0.00%
Probate Court - - 450.00 450.00 100.00%Fav. Primarily from Sale of Equipment $450 for sale of a duty pistol.
Sheriff Office - - - - 0.00%
Sheriff - Administrative Services - - - - 0.00%
Sheriff - Corrective Services - - - - 0.00%
Sheriff - Corrective Services-Satellites - - - - 0.00%
Sheriff - Emergency Resp and Prepare - - - - 0.00%
Sheriff - Patrol Services 12,000.00 12,000.00 7,000.00 (5,000.00) -41.67%Unfav. due to less County Auction activity.
Sheriff - Emergency Communications Operations - - - - 0.00%
Sheriff - Investigative/Forensic Svc 3,000.00 3,000.00 10,500.00 7,500.00 250.00%Fav. Refund Prior Years Expenditures from reimbursement worked in
previous fiscal year from DEA task force members; partially offset by
unfav. County Auction due to less activity.
Clerk - County Clerk - - - - 0.00%
Clerk - Elections - - - - 0.00%
Clerk - Register of Deeds & Micrographics - - - - 0.00%
Treasurer - - - - 0.00%
Board of Commissioners - - - - 0.00%
Water Resources Commissioner - - - - 0.00%
County Exec - Compliance Office - - - - 0.00%
Management and Budget - Fiscal Services - - - - 0.00%
Facilities Management - Support Services 1,500.00 1,500.00 137,600.00 136,100.00 9073.33%Fav. due to sale of equipment at the County auctions.
23
AMOUNT
ADOPTED AMENDED FY 2024 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2024 FIRST QUARTER REPORT
Human Resources - - - - 0.00%
Facilities Management Engineering - - - - 0.00%
Health Administration - - - - 0.00%
Health Division - - 400.00 400.00 100.00%Fav. Due to County Auction and Adjustment to Prior Years entry.
Homeland Security - - - - 0.00%
EMG - Homeland Security - - - - 0.00%
Public Services - Community Corrections - - - - 0.00%
Public Services - Medical Examiner - - - - 0.00%
Public Services - Animal Control-Other Revenues - - - - 0.00%
Public Services - Children's Village - Other Revenues - - 20,830.00 20,830.00 100.00%Fav. Refund Prior Year Revenue $19,636 mainly attributed to Board and
Care revenue received after year-end for Q1 forecast.
Economic Development - Veterans - - - - 0.00%
Non Departmental - Donations - - - - 0.00%
Non-Dept - Sundry - - - - 0.00%
Total Other Revenues 16,500.00$ 16,500.00$ 176,780.00 160,280.00$ 971.39%
TRANSFERS IN (695500)
Circuit Court - Transfers In - - - - 0.00%
Prosecuting Attorney Transfers In - - - - 0.00%
Board of Commissioners 100,000.00 100,000.00 100,000.00 0.00%
Health Division - Transfers In 17,000,000.00 23,000,000.00 23,000,000.00 - 0.00%
Public Services - Animal Control-Transfers In - - - - 0.00%
Public Services - Children's Village - Transfers In - 1,000,000.00 1,000,000.00 - 0.00%
Economic Development Transfers In - 5,000,000.00 5,000,000.00 - 0.00%
Medical Examiners Transfer In - - - - 0.00%
Sheriffs' Transfers In - - 21,800.00 21,800.00 100.00%Fav. due to ATPA Grant Match
Treasurers' Transfers In 2,700,000.00 2,700,000.00 2,700,000.00 - 0.00%
Non-Departmental - Transfers In 24,527,977.00 24,555,443.00 24,555,443.00 - 0.00%At budget for Q1 Forecast
Total Transfers In Revenues 44,327,977.00$ 56,355,443.00$ 56,377,243.00 21,800.00$ 0.04%
PLANNED USE OF FUND BALANCE (665882)
Encumbrances and Carry forwards - 19,828,116.17 19,828,116.17 - 0.00%
Use of Prior Yrs Fund Balance 5,268,760.00$ 7,697,860.00$ 7,697,860.00 - 0.00%
Total Planned Use of Fund Balance 5,268,760.00$ 27,525,976.17$ 27,525,976.17$ -$ 0.00%
TOTAL GEN. FUND / GEN. PURPOSE REVENUE 575,896,118.42$ 611,614,658.59$ 608,028,433.28$ (3,586,225.00)$ -0.59%
24
Adopted Amended Forecast Favorability/UNF Percentage
$53,445,806.77 $55,127,542.82 $47,818,842.82 $7,308,700.00 13.26%
$29,596,104.34 $29,596,104.34 $28,099,004.34 $1,497,100.00 5.06%
$11,495,687.00 $12,921,704.05 $6,516,604.05 $6,405,100.00 49.57%
$5,548,033.43 $5,803,752.43 $6,397,252.43 ($593,500.00)-10.23%
Personnel
Judicial Administration division favorabile primarily due to $29,300 in Travel and Conference as well as $29,600 in
Office Supplies due to less than anticipated usage.
Judicial Administration division projected at budget.
Operating
Court Business division favorable due to timing of step increases and favorability from new employees.
Civil/Criminal and Family divisions favorable due to underfilled and vacant positions.
Court Business division unfavorability primarily driven by ($13,100) in Visiting Judges. Bench warrants have
doubled from half to full day and judges are more often at the court, also assisting with working through the backlog.
Partially offset by favorability in Metered Postage Expense $8,300 as email communication has increased.
Civil/Criminal division unfavorable primarily due to Defense Attorney Fees Appellate ($188,100) due to payments
at MIDC rates; offset by 50% reimbursement from State Appellate Defender Office/Michigan Appellate Assigned
Counsel System (SADO/MAACS). Also unfavorable Defense Attorney Fees ($20,800) as this line item budget was
moved to MIDC at its creation; however expenses not covered by the MIDC grant are incurred by the Circuit Court.
Also unfavorable ($16,200) in Postgage - Standard Mailing due to increased usage as a result of more juries being
used. Partially offset by favorability in Attorney Fees Mediators $163,400 due to law change resulting in less cases
going to mediation. Also partially offset by favorability of $20,700 in Office Supplies used as needed. As well as
partially offset by favorable Court Transcripts $11,300 which is based on activity.
Judicial Administration division unfavorable primarily due to Info Tech Operations ($90,800). Further review is
required by the court. Partially offset by favorability in Telephone Communications of $6,400 due to less than
anticipated use.
Court Business division unfavorable primarily due to Info Tech Operations ($90,900). Further review is required by
the court. Partially offset by favorability of $3,700 in Info Tech Managed Print Servcies due to increased usage of
electronic formats.
Civil/Criminal division unfavorable primarily due to Info Tech Operations ($149,900) and ($31,700) in Equipment
Rental due to budget allocation. Also unfavorable ($21,900) in Telephone Communications attributed to the rollout
of the VOIP system. In addition ($10,400) unfavorable in Info Tech Managed Print Svcs. This is the result of both
the new Judgement of Sentence application causing printing errors as well as Settlement Week increasing activity
by printing and providing documentation.
Internal
Family division favorability primarily attributed to State Institutions $5,010,000 and $1,316,500 in Private
Institutions Residential due to policy changes to lower placement as costs have significantly increased.
Family division unfavorability primarily due to ($126,900) in Info Tech Operations. Further review is required by the
court. Also unfavorable ($43,700) in Telephone Communications due to additional devices. Also unfavorable
($36,500) in Equipment Rental primarily for JAVS. Also unfavorable ($2,000) in Motor Pool as more out of state
placements are occuring. Partially offset by favorability of $8,900 in Info Tech Managed Print Svcs due to increased
use of electronic formats.
Circuit Court
2024 Q1 Forecast
Total
Summary of Projections
25
$6,805,982.00 $6,805,982.00 $6,805,982.00 $0.00 0.00%Transfers
Transfers to be completed by year-end.
26
Adopted Amended Forecast Favorability/UNF Percentage
$20,306,782.89 $20,353,635.37 $20,204,135.37 $149,500.00 0.73%
$15,723,171.15 $15,723,171.15 $15,763,171.15 ($40,000.00) -0.25%
$2,544,416.00 $2,560,750.48 $2,342,150.48 $218,600.00 8.54%
$2,039,195.74 $2,069,713.74 $2,098,813.74 ($29,100.00)-1.41%
$0.00 $0.00 $0.00 $0.00 0.00%
Novi is projected at budget.
Clarkston is projected at budget.
Rochester Hills is projected at budget.
Rochester Hills is projected at budget.
Personnel
Troy is projected at budget.
Admin unfavorable ($40,000) primarily attributed to the Weekend Arraignments program paid through overtime
and has been challenging to staff.
Operating
Transfers
No transfers out occuring for FY2024.
Admin favorable primarily due to $19,500 in Info Tech Operations to account for any technology usage that occurs
as part of the Weekend Arraignment program.
Novi is projected at budget.
Clarkston unfavorable primarily due to Info Tech Operations ($38,700) due to budget allocation and usage.
Partially offset by favorability in Telephone Communications of $16,900 due to less than anticipated usage.
Internal
Admin favorability primarily attributed to Contracted Services $330,000 for additional IT Support to transition to an
electronic filing system (M.R. 2023-3298).
Novi is projected at budget.
Clarkston unfavorable primarily due to ($13,100) in Court Reporter Services, a mandated requirement of the courts
which occurs on an as-needed basis. Partially offset by favorability of $5,600 in Jury Fees and Mileage based on
use.
Rochester Hills unfavorability primarily due to Printing ($21,600) due to revamp of civil forms, of which the Court is
required to have physical copies available. Nearly all forms were impacted and needed to be re-printed. Also
unfavorable ($19,100) in Interpreter Fees, which is a mandated expense which occurs as needed.
Troy unfavorable primarily due to ($86,300) in Professional Services line item due to additional IT support to
transition to electronic filing; offset in District Court Administration favorability.
Troy unfavorable primarily due to Info Tech Operations ($37,300) due to budgeted allocation and usage. Also
unfavorable ($9,800) in Equipment Rental for mail machine maintenance and maintenance of the DCR system.
District Court
2024 Q1 Forecast
Total
Summary of Projections
27
Adopted Amended Forecast Favorability/UNF Percentage
$8,325,470.27 $8,392,233.27 $8,043,033.27 $349,200.00 4.16%
$5,909,363.19 $5,909,363.19 $5,599,663.19 $309,700.00 5.24%
$1,255,135.00 $1,288,268.00 $1,229,768.00 $58,500.00 4.54%
$1,160,972.08 $1,194,602.08 $1,213,602.08 ($19,000.00)-1.59%
$0.00 $0.00 $0.00 $0.00 0.00%
Probate Court
2024 Q1 Forecast
Total
Summary of Projections
Personnel
Admin is at budget.
Operating
Transfers
No transfers occuring in FY2024.
Admin favorability primarily due to Library continuations $15,000 which charges being made to Estates/Mental
Health instead of Admin; net result is favorability of $10,000. Also favorable Membership dues net $3,600 for the
same reason.
Mental Health & Estates favorable primarily due to $80,500 in Software Support Maintenance, which was used for
the Case Management System implemented last year. Partially offset by Fees Guardian Ad Litem ($43,700), a
mandated expense; however usage is increasing primarily due to an aging population and long-term health impacts
from the COVID epidemic.
Admin is at budget.
Mental Health & Estates is unfavorable primarily due to Equipment Rental ($27,900) due to allocation of budget.
Partially offset by $9,400 in favorability in Telephone Communications due to budget allocation. Email has been
pushed as an alternative and processes updated, driving down usage.
Internal
Estates/Mental health favorable $309,700 due vacancy and turnover.
28
Adopted Amended Forecast Favorability/UNF Percentage
$27,732,067.90 $28,304,009.07 $26,559,009.07 $1,745,000.00 6.17%
$23,108,424.70 $23,081,181.70 $21,766,181.70 $1,315,000.00 5.70%
$661,808.00 $1,122,178.17 $1,082,178.17 $40,000.00 3.56%
$2,664,041.20 $2,754,500.20 $2,864,500.20 ($110,000.00)-3.99%
$1,297,794.00 $1,346,149.00 $846,149.00 $500,000.00 37.14%Transfers
Transfers Out favorability is due to less Cooperative Reimbursement Program grant match obligation than
budgeted.
Favorability of $220,000 is due to variances in multiple spending categories such as Expert Witness Fee and
Mileage, Library Continuations and Printing due to less usage and Direct Client Services for direct victim needs.
Forecasted unfavorability of ($225,000) is due to Info Tech Operations. This is offset by favorability in Info Tech
Managed Print Svcs, Motor Pool and Motor Pool Fuel Charges due to less than anticipated use.
Favorability of $115,000 in Info Tech Managed Print Services is due to remote work and paper reduction efforts
as well as Motor Pool and Motor Pool Fuel Charges due to less than anticipated use. This offsets a portion of the
unfavorability.
Internal
Projected favorability is partially offset by unfavorability of ($180,000) which includes variances in several spending
categories such as Travel and Conference, Membership Dues, Extradition Expense and Court Transcripts due to
usage.
Personnel
Overtime unfavorable ($110,000) and offset by favorability in salaries and fringe benefits.
Favorability in salaries and fringe benefits due to turnover and vacancies.
Operating
Prosecuting Attorney
2024 Q1 Forecast
Total
Summary of Projections
29
Adopted Amended Forecast Favorability/UNF Percentage
$198,697,219.56 $203,810,465.21 $207,384,465.21 ($3,574,000.00) -1.75%
$156,314,247.97 $157,058,691.97 $161,558,691.97 ($4,500,000.00) -2.87%
$14,497,858.00 $18,354,812.65 $18,044,812.65 $310,000.00 1.69%
$26,897,585.59 $27,183,445.59 $26,967,445.59 $216,000.00 0.79%
$987,528.00 $1,213,515.00 $813,515.00 $400,000.00 32.96%
Personnel
Personnel Category is unfavorable in Overtime and associated Fringe Benefits due to turnover, parental leave,
vacant positions, hospital watch, officers in the academy and officers in training and partially offset by favorability in
Salaries due to vacancies and turnover. In addition, events at venues such as Pine Knob drives overtime, however
it is reimbursed through Reimbursement Salaries revenue via interlocal agreements to provide law enforcement
services.
Operating
Sheriff's Office
2024 Q1 Forecast
Total
Summary of Projections
Transfers
Transfers Out are projected to be favorable due to Automotive Theft Prevention Association (ATPA) and Narcotics
Enforcement Team (NET) grant match obligation being lower than budgeted.
Favorability is driven by a few large items, with multiple smaller accounts across divisions favorable due to usage.
These accounts include Clothing Allowance, Communications, Custodial Supplies, Expendable Equipment,
Evidence Fund NET, Laundry and Cleaning, Library Continuations, Office Supplies, Printing, Prisoner Housing-
Outside, Professional Services, Software Support Maintenance and Supportive Services.
Forecasted favorability totaling $540,000 in Motor Pool Fuel Charges, Radio Communications and Office
Equipment Rental due to less than anticipated usage and InfoTech Print Managed Services due to paper reduction
efforts.
Projecting unfavorability totaling ($350,000) in Info Tech Operations, Motor Pool and Telephone Communications
due to higher usage.
Internal
Favorability of $105,000 in Laboratory Supplies is due to reduced usage of the RESULTS drug testing program
and offset by unfavorable Drug Testing revenue.
Favorability of $115,000 in Fees Civil Service which is offset by unfavorable Civil Action Service Fees revenue
due to less activity in process serving.
Projected unfavorability of ($400,000) in Contracted Services due to wellness clinic budget developed based on
monthly favorability. Increasing costs have reduced this favorability however the budget has not increased to reflect
the increasing costs.
30
Adopted Amended Forecast Favorability/UNF Percentage
$11,550,021.83 $11,930,556.03 $10,929,154.04 $1,001,401.99 8.39%
$8,587,375.25 $8,587,375.25 $7,585,973.26 $1,001,401.99 11.66%
$1,545,612.00 $1,827,813.20 $1,827,813.20 $0.00 0.00%
$1,417,034.58 $1,515,367.58 $1,515,367.58 $0.00 0.00%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
No activity for FY24 across all Divisions.
Forecasted Operating Expenditure for Clerk/Register of Deeds Department is at budget for Q1 as
utilizations is at 25%.
Internal
Forecasted Internal Services to be at budget for Q1 across all Divisions.
Personnel
Favorability in salaries and fringes due to turnover, underfilled positions and vacancies across all
divisions, with greater favorability of $605,000 for County Clerk, $332,000 for Register of Deeds(and
Micrographics), $45,800 for Administration and $18,601.99 for Jury Commission.
Operating
Clerk/Register of Deeds
2024 Q1 Forecast
Total
Summary of Projections
31
Adopted Amended Forecast Favorability/UNF Percentage
$9,010,040.85 $9,213,351.85 $7,667,651.85 $1,545,700.00 16.78%
$3,947,191.52 $3,947,191.52 $3,786,491.52 $160,700.00 4.07%
$3,259,270.00 $3,259,270.00 $2,054,270.00 $1,205,000.00 36.97%
$1,683,579.33 $1,766,890.33 $1,586,890.33 $180,000.00 10.19%
$120,000.00 $240,000.00 $240,000.00 $0.00 0.00%Transfers
At budget for Q1 forecast.
Projected favorability is due to the following: Title Search $500,000 due to less fee payments, Fees Civil
Service $459,000 due to less property visits, Contracted Services $100,000 due to foreclosing on fewer
properties, Recording Fee-Forfeiture Cert $46,000 due to less parcels entering second year of
delinquency, Advertising $32,000 due to online auction, and not producing and paying for lawn signs.
Foreclosure Notification $25,000 due to less certified mailings, Printing $15,400 due to fewer statements
being printed, and Recording Fees Expense $15,000 due to fewer certificate for foreclosure filings.
Projecting favorability in Info Tech Operations $148,000, Telephone Communications $14,500 and
Insurance Fund $12,000 due to allocation of budget and usage.
Internal
Personnel
Fav. due to vacancies, turnover and underfill positions.
Operating
Treasurer
2024 Q1 Forecast
Total
Summary of Projections
32
Adopted Amended Forecast Favorability/UNF Percentage
$5,737,575.22 $6,332,478.66 $6,035,478.66 $297,000.00 4.69%
$3,748,919.05 $3,748,919.05 $3,583,919.05 $165,000.00 4.40%
$1,285,998.00 $1,878,099.44 $1,822,099.44 $56,000.00 2.98%
$702,658.17 $705,460.17 $629,460.17 $76,000.00 10.77%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
Projected Fav. Sponsorship $50,000 is due to decrease in the number of events related to economic
development and community engagements, Workshops and Meetings $26,000 due to fewer events,
resulting in cost saving for the team. Computer Supplies $21,000 due to less usage than initially
anticipated and Personal Mileage $11,500 as travel have decreased. Partially offset by Unfav. Metered
Postage Expenses ($67,000) due to a higher volume of mailings.
Projected Fav. IT Operations $63,000 due to allocation of budget and usage.
Internal
Personnel
Fav. due to vacancies and turnover.
Operating
Board of Commissioners
2024 Q1 Forecast
Total
Summary of Projections
33
Adopted Amended Forecast Favorability/UNF Percentage
$8,479,591.25 $8,517,686.25 $8,514,886.25 $2,800.00 0.03%
$240,267.51 $240,267.51 $240,267.51 $0.00 0.00%
$287,975.00 $289,272.00 $286,472.00 $2,800.00 0.97%
$7,895,183.74 $7,931,981.74 $7,931,981.74 $0.00 0.00%
$56,165.00 $56,165.00 $56,165.00 $0.00 0.00%Transfers
Transfers Out for Drainage Districts will occur at Fiscal Year End.
Favorable Legal Services a result of Soil Erosion spending less on legal issues to enforce the laws
of the soil erosion program and favorable Office Supplies due to remote work.
Forecasted Internal Services for Water Resources Commissioner is at budget for Q1 as utilization
is at 25%.
Internal
Unfavorable operating cost for Uniforms, Membership Dues and Charge Card Fees the result of
actual spending being more than anticipated budget.
Water Resources Commissioner
2024 Q1 Forecast
Total
Summary of Projections
Personnel
Salaries and Fringes overall projected to be on budget.
Operating
34
Adopted Amended Forecast Favorability/UNF Percentage
$11,105,276.79 $11,709,436.79 $11,192,586.79 $516,850.00 4.41%
$7,148,502.50 $7,148,502.50 $6,741,202.50 $407,300.00 5.70%
$1,056,545.00 $1,601,545.00 $1,544,295.00 $57,250.00 3.57%
$988,408.29 $1,047,568.29 $1,023,468.29 $24,100.00 2.30%
$1,911,821.00 $1,911,821.00 $1,883,621.00 $28,200.00 1.48%
Compliance Office, Corporation Counsel and Indigent Defense Services Office (IDSO) are at budget.
Personnel
Favorability due to vacancy and turnover totaling $407,300 between Administration and Diversity, Equity and
Operating
A budget amendment has been added to the 1st Quarter Forecast to remove the $28,200 Transfer Out built into
Corporation Counsel's budget during development. This was a one-time transfer for software related expenese.
Transfers
Transfers Out within Indigent Defense Service Office is at budget as it is the grant match for the FY 2024
Mandated Indigent Defense Commission award. Transfer to occur by end of the fiscal year.
Admin primarily due to Contracted Services $12,800, Software Support Maintenance $10,000 and $9,500 in
Training due to less than anticipated use. Also favorable $5,000 in Office Supplies based on need.
Compliance Office favorable primarily due to $1,700 in Software Rental Lease Purchase. New test environment
plus install are less than budgeted. Also favorable $1,000 in Travel and Confernece. Only one major event is
planned for May, with travel expenses anticipated to come in around $3,000. No other travel is anticipated.
DEI favorable $3,000 in Membership Dues due to lack of use.
Admin and IDSO are at budget.
Compliance Office favorable primarily due to $66,600 in Info Tech Operations based on budget allocation.
DEI favorable $3,400 Info Tech Operations and $500 Telephone Communications due to budget allocation and
use.
Internal
Corporation Counsel is favorable in Library continuations $5,000 due reduced print materials and online access.
Also favorable Personal Mileage $2,000 due to available hybrid meeting options.
Corporation Counsel unfavorable primarily due to Info Tech Operations ($42,500) due to budget allocation and
usage. Also unfavorable ($6,000) in Telephone Communications as allocation of budget does not reflect the timeing
of union agreement to include cellphones and tablets.
County Executive
2024 Q1 Forecast
Total
Summary of Projections
35
Adopted Amended Forecast Favorability/UNF Percentage
$24,954,180.43 $25,282,854.57 $24,082,854.57 $1,200,000.00 4.75%
$20,283,703.05 $20,283,703.05 $19,083,703.05 $1,200,000.00 5.92%
$789,709.00 $890,610.14 $890,610.14 $0.00 0.00%
$3,880,768.38 $4,108,541.38 $4,108,541.38 $0.00 0.00%
$0.00 $0.00 $0.00 $0.00 0.00%
Personnel
Favorability in salaries and fringes $1,200,000 due to turnover and underfilled positions/vacancies across all
divisions, with greater favorability from Fiscal Services, Equalization, and Purchasing.
Operating
Transfers
No Transfers Out are budgeted in FY 2024.
Operating Expenditures are at budget.
Internal Support Services are at budget.
Internal
Management & Budget
2024 Q1 Forecast
Total
Summary of Projections
36
Adopted Amended Forecast Favorability/UNF Percentage
$5,378,088.63 $5,608,841.33 $5,265,841.33 $343,000.00 6.12%
$3,200,625.50 $3,200,625.50 $2,980,625.50 $220,000.00 6.87%
$1,001,599.00 $1,215,927.70 $1,122,927.70 $93,000.00 7.65%
$1,175,864.13 $1,192,288.13 $1,162,288.13 $30,000.00 2.52%
$0.00 $0.00 $0.00 $0.00 0.00%
Personnel
Favorability due to vacancy and turnover totaling $220,000 between Administration and Facilities Engineering
Divisions.
Operating
Transfers
No Transfers Out are budgeted for FY 2024.
Favorability in Administration mainly attributable to Professional Services $50,000 under Sustainability Iniitiatives
program due to a delay in hiring educational and implementation contractors as well as favorability in Special Event
Supplies $30,000 due to a delay in the start of special events. Fav. Training $8,000 and Office Supplies $5,000 due
to less than anticipated usage.
Internal
Favorability Info Tech Operations $30,000 due to lower than anticipated costs in Facilities Support Services.
Facilities Management
2024 Q1 Forecast
Total
Summary of Projections
37
Adopted Amended Forecast Favorability/UNF Percentage
$6,276,367.26 $6,436,622.51 $6,269,322.51 $167,300.00 2.60%
$3,882,840.93 $3,882,840.93 $3,752,340.93 $130,500.00 3.36%
$935,845.00 $995,931.25 $954,731.25 $41,200.00 4.14%
$1,457,681.33 $1,557,850.33 $1,562,250.33 ($4,400.00)-0.28%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
No transfers in FY2024
Fav. for HR Administration Division for Printing $6,000 due to increased digital documentation and
communication, Travel and Conference $5,000 due to less travel and events. Also, Fav. Employee
License-Certification $4,500 due to employee's completing certifications at a lower cost.
Unfav. for Workforce Management Division for Telephone Communications ($22,300) due to allocation
of budget and usage.
Internal
Fav. Office Supplies $9,500 inventory management practice, Printing $8,500 and Periodicals Books
Publ Sub $4,200 due to less than anticipated use and activity for Workforce Management Division.
Fav. for HR Administration Division for Info Tech Operations $18,200 due to allocation of budget and
usage.
Personnel
Fav. in salaries and fringes within Human Resources Department due to vacancies, turnover and
Underfilled positions.
Operating
Human Resources
2024 Q1 Forecast
Total
Summary of Projections
38
Adopted Amended Forecast Favorability/UNF Percentage
$63,651,702.56 $73,062,573.46 $60,887,573.46 $12,175,000.00 16.66%
$50,567,790.96 $50,567,790.96 $40,567,790.96 $10,000,000.00 19.78%
$8,413,941.00 $17,117,343.90 $14,942,343.90 $2,175,000.00 12.71%
$4,050,573.60 $4,160,297.60 $4,160,297.60 $0.00 0.00%
$619,397.00 $1,217,141.00 $1,217,141.00 $0.00 0.00%
Health
2024 Q1 Forecast
Total
Summary of Projections
Personnel
Favorability in salaries and fringes $10,000,000 due to turnover and underfilled positions/vacancies in the Health
Division. In addition, eligible personnel costs have been covered by COVID-related grants and Local Community
Stabilization Authority funding.
Operating
Transfers
Transfers Out within Neighborhood Housing Development are at budget.
Favorability in HHS Administration for Private Institution Residence $900,000, Private Institution $300,000, Private
Institution Foster $200,000, Independent Living $100,000, and Foster Board Home $100,000 related to the Child
Care Fund. These expenditures are based on caseload, difficulty of care, and treatment services ordered by the
Courts. Some caseloads are referred to the County by Michigan Department of Health & Human Services. The costs
are difficult to estimate and have been lower since COVID‐19. Also, favorability Support Services $100,000 due to
request for funding for Oxford School incident being less than anticipated.
Favorability in Health Division for Professional Services $250,000, Contracted Services $156,000, Drugs $30,000,
Software Support $22,000, Equipment Maintenance $13,000, and Expendable Equipment $4,000 due to less than
anticipated demand.
Internal Support Services are at budget.
Internal
39
Adopted Amended Forecast Favorability/UNF Percentage
$46,056,237.79 $48,223,475.94 $46,071,535.94 $2,151,940.00 4.46%
$33,169,648.41 $33,169,648.41 $31,798,648.41 $1,371,000.00 4.13%
$5,797,271.00 $7,852,621.15 $7,060,281.15 $792,340.00 10.09%
Fav. for Community Corrections Division for Contracted Services $69,700 due to a decrease in case
loads and number of court orders to suspend sentences as well as transitioning individuals from jail to a
sober living house. Additionally, Fav. Office Supplies $9,500 and Printing $6,000 due to less than
anitcipated use and activity.
Fav. for Medical Examiner Division for Medical Supplies $297,000 and Equipment $19,600 due to less
cases, drug testing and lab activities to control diseases.
Unfav. Uniforms ($24,000) due to hiring of new staff members, Medical Supplies ($20,000) and Animal
Suppies ($20,000) due to population of animals and inflationary costs. Also Fav. Charge Card Fees
($8,500) due to shelter paying more in fees for using credit card machines to process payments for
services/adoptions. Partially offset by Fav. Contracted Services $30,000 due to tethers monitoring system
is no longer being used as the jail trustees are no longer cleaning the shelter for Animal Control Division.
Fav. Medical Services Physicians $66,500, Expendable Equipment $56,000, Laundry and Cleaning
$55,000, Drugs $32,000, Custodial Supplies $28,000, Security Supplies $8,000 and Training-Educational
Supplies $7,200 due to lower population. Also Fav. Professional Services $20,000 due to reduced need
for private nurses. Hospitalization $19,800 due to most of the children that visit the hospital have insurance
or Medicaid. Additional Fav. includes Personal Mileage $13,100, Uniforms $11,000 and Employees
Medical Exams $7,500 due to vacant positions. In general, the overarching cause is due to vacant
positions and reduced population for Children's Village Division.
Fav. Office Supplies $20,000 due to inventory management and Metered Postage $7,000 due to less
mailingsfor Circuit court Probation Division.
Operating Expenditures forecast for Q1 is at budget for Public Services Admin Division.
Personnel
Favorability in salaries and fringes due to turnover and underfilled positions/vacancies across all
divisions, with greater favorability of $830,500 for Children's Village, $234,000 for Medical Examiner,
$158,000 for Animal Control, $148,500 for Community Corrections and budget at Q1 for Public Services
Admin Division.
Operating
Public Services
2024 Q1 Forecast
Total
Summary of Projections
40
Adopted Amended Forecast Favorability/UNF Percentage
Public Services
2024 Q1 Forecast
Summary of Projections
$7,089,318.38 $7,201,206.38 $7,212,606.38 ($11,400.00)-0.16%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
No Transfers Out are budgeted in FY 2024
For Children Village and Public Services Admin Division Internal Services forecast for Q1 is at budget.
Fav. Insurance Fund $21,500 and Radio Communications $14,500 due to allocation of budget and
usage. Partially offset by Unfav. Equipment Rental ($14,000) and Info Tech Managed Print Svcs ($4,000)
due to greater than anticipated costs for Animal Control Division .
Fav. for Medical Examiner Division for Info Tech Operations $16,500 due to allocation of budget and
usage. Partially Offset by Unfav. Info Tech Managed Print Svcs ($1,200) due to increased use of
electronical formats.
Internal
Unfav. Info Tech Operations ($38,400) due to computer license costs and additional devices for remote
work for Community Corrections Division.
Unfav. for Circuit Court Probation Division for Telephone Communications ($7,000) due to allocation of
budget and usage.
41
Adopted Amended Forecast Favorability/UNF Percentage
$11,303,843.84 $20,046,608.84 $19,624,108.84 $422,500.00 2.11%
$7,717,130.93 $7,717,130.93 $7,267,130.93 $450,000.00 5.83%
$2,234,875.00 $9,609,875.00 $9,577,375.00 $32,500.00 0.34%
$1,351,837.91 $1,419,602.91 $1,479,602.91 ($60,000.00)-4.23%
$0.00 $1,300,000.00 $1,300,000.00 $0.00 0.00%
Economic Development & Community Affairs
2024 Q1 Forecast
Total
Summary of Projections
Personnel
Favorability due to vacancy and turnover totaling $450,000 among the various Divisions.
Operating
Transfers
Transfers Out are at budget.
Favorable In Veteran Services for Soldier Burial $70,000 and Soldier Relief $10,000 due to less than antcipated
claims for veteran benefits such as burial in National Cemetary, headstones, markers, burial flags, and other veteran
benefits.
Unfavorable Local Business Development for Licenses and Permits ($3,500) and Expendable Equipment ($1,000)
due to more than anticipated usage.
Unfavorable in Workforce Development for Training ($34,000) and Printing ($9,000) and due to more than
anticipated usage.
Unfavorable in Local Business Development for Info Tech Operations ($50,000) and Equipment Rental ($4,000)
due to more than anticipated usage.
Unfavorable in Veteran Services for Telephone Communications ($3,000), Motor Pool Fuel Charges ($2,000), and
Motor Pool ($1,000) due to more than anticipated use.
Internal
42
Adopted Amended Forecast Favorability/UNF Percentage
$3,253,620.90 $3,282,240.90 $3,282,240.90 $0.00 0.00%
$1,215,736.95 $1,215,736.95 $1,215,736.95 $0.00 0.00%
$1,404,337.00 $1,404,337.00 $1,404,337.00 $0.00 0.00%
$633,546.95 $662,166.95 $662,166.95 $0.00 0.00%
$0.00 $0.00 $0.00 $0.00 0.00%
Emergency Management & Homeland Security
2024 Q1 Forecast
Total
Summary of Projections
Personnel
Personnel expenditures are at budget
Operating
Transfers
No Transfers Out are budgeted in FY 2024.
Operating Expenditures are at budget.
Internal Support Services are at budget.
Internal
43
Adopted Amended Forecast Favorability/UNF Percentage
$3,962,765.23 $4,517,395.27 $4,509,295.27 $8,100.00 0.18%
$2,673,899.22 $2,673,899.22 $2,562,199.22 $111,700.00 4.18%
$1,131,327.00 $1,665,737.04 $1,665,737.04 $0.00 0.00%
$157,539.01 $177,759.01 $281,359.01 ($103,600.00)-58.28%
$0.00 $0.00 $0.00 $0.00 0.00%
Personnel
Projected Favorability in Salaries and Fringes due to vacancies and turnover.
Operating
Dept. of Public Communications
2024 Q1 Forecast
Total
Summary of Projections
Transfers
No transfers in FY24
Operating Expenditures for DPC Forecast for Q1 is at Budget
Projected Unfav. Info Tech Operations ($92,500) and Telecommunication ($11,000) due to allocation of
budget and usage.
Internal
44
NON-DEPARTMENTAL
2024 Q1 Forecast
Summary of Projections
Account
FY 2024
Adopted Budget
FY 2024
Amended Budget
FY 2024
Projection
Amount
Fav./Unfav.
Percentage
Explanation
Expenditure
702000 Salaries Regular (10,000,000.00) (10,000,000.00) (10,000,000.00) - 0.00%
722000:Fringe Benefits - - - -
730000:Contractual Services 1,324,962.00 1,161,122.00 1,432,422.00 - 0.00%
740000:Non-Departmental 13,616,119.00 19,472,928.00 19,472,928.00 - 0.00%
760000:Capital Outlay 2,299,683.00 2,172,302.00 2,172,302.00 - 0.00%
770000:Internal Support
Expenditures
12,070,535.45 10,571,914.45 10,571,914.45 - 0.00%
788001:Transfers Out 37,359,059.00 38,085,284.00 38,085,284.00 - 0.00%
796500:Budgeted Equity
Adjustments
(900.00) (900.00) (900.00) - 0.00%
Total Expenditures 56,669,458.45 61,462,650.45 61,733,950.45 - 0.00%
45
I
I
I
I
I
I
I
I
I
TREASURER'S OFFICE
ADOPTED AMENDED FY 2024 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 1,000,000.00 1,000,000.00 1,000,000.00 - 0.00%
Transfers In - - - - 0.00%
Total Revenues $11,500,000.00 $11,500,000.00 $11,500,000.00 -$ 0.00%
OPERATING EXPENSES
Personnel Expenditures 248,137.58$ 248,137.58$ 248,137.58$ -$ 0.00%
Operating Expenditures 342,386.00 342,386.00 342,386.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 1,276,125.00 1,276,125.00 1,276,125.00 - 0.00%
52-3 District Court Refunding Debt Svc(Dc re 0.00 0.00 0.00 - #DIV/0!
Total Transfer Out to Other Funds 11,476,125.00$ 11,476,125.00$ 11,476,125.00$ -$ 0.00%
Total Operating Expenses 13,066,648.58$ 13,066,648.58$ 13,066,648.58$ -$ 0.00%
REVENUE OVER (UNDER)
EXPENDITURES*($1,566,648.58)($1,566,648.58)($1,566,648.58)$0.00
Total Net Position - Beginning $209,829,663.72
Total Net Position - Ending $208,263,015.14
Ending FY 2023 Designated Net Position**:
NP-UnRes - Designated - Debt Service $46,997,742.00
NP-UnRes - Designated - Delinq Taxes Receivable 156,919,440.04
NP-UnRes - Designated - Collection Fees 5,912,481.68
Undesignated - Net Position ($1,566,648.58)
Total Net Position - Ending $208,263,015.14
*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
COUNTY OF OAKLAND
FY 2024 FIRST QUARTER REPORT
ENTERPRISE FUND
46
COUNTY OF OAKLAND
FY 2024 FIRST QUARTER REPORT
ENTERPRISE FUNDS
TREASURER
ADOPTED AMENDED FY 2024 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%
OPERATING EXPENSE 554,317.16 554,317.16 471,117.16 $83,200.00 15.01%Fav. Controllable Personnel $64,300 due to vacant and underfilled
positions. Also Fav. Professional Services $15,500 and Metered
Postage $3,000 due to less than anticipated use.
NET OPERATING INCOME (LOSS)($48,181.16)($48,181.16)$35,018.84 $0.00 0.00%
NON-OPERATING REVENUE (EXPENSE)/5,000.00 5,000.00 $5,000.00 $0.00 0.00%
TOTAL INCOME BEFORE
CONTRIBUTIONS AND TRANSFERS ($43,181.16)($43,181.16)40,018.84$ $0.00
TRANSFERS OUT - - - -
TOTAL NET INCOME (LOSS)*($43,181.16)($43,181.16)$40,018.84 $0.00
TOTAL NET POSITION - BEGINNING 1,351,295.45
TOTAL NET POSITION - ENDING $1,391,314.29
* Please note that in the Adopted Budget (line-item book) this is budgeted as 'Planned Use of Balance" in the revenue category.
47
COUNTY OF OAKLAND
FY 2024 FIRST QUARTER REPORT
ENTERPRISE FUND
PARKS & RECREATION
ADOPTED AMENDED FY 2024 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
OAKLAND COUNTY PARKS & RECREATION COMMISSION
(50800)
OPERATING REVENUE 12,160,164.00$ 12,160,164.00$ 12,160,164.00$ -$ 0.00%
OPERATING EXPENSE 36,093,975.00$ 36,093,975.00$ 36,093,975.00$ -$ 0.00%
NET OPERATING INCOME (LOSS)(23,933,811.00)$ (23,933,811.00)$ (23,933,811.00)$ -$ 0.00%
NON-OPERATING REVENUE (EXPENSE)26,101,768.00$ 26,101,768.00$ 26,101,768.00$ -$ 0.00%
TOTAL INCOME BEFORE TRANSFERS 2,167,957.00$ 2,167,957.00$ 2,167,957.00$ -$ 0.00%
TRANSFERS IN (OUT)(250,000.00)$ (250,000.00)$ (250,000.00)$ -$ 0.00%
TOTAL NET INCOME/BUDGETED EQUITY ADJ 1,917,957.00$ 1,917,957.00$ 1,917,957.00$ -$
TOTAL NET POSITION - BEGINNING 96,563,167.85$
TOTAL NET POSTION - ENDING 98,481,124.85$
48
COUNTY OF OAKLAND
FY 2024 FIRST QUARTER REPORT
ENTERPRISE FUNDS
ECONOMIC DEVELOPMENT
ADOPTED AMENDED FY 2024 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
OAKLAND COUNTY INTERNATIONAL
AIRPORT (56500)
OPERATING REVENUE $6,390,000.00 $6,390,000.00 $6,390,000.00 -$ 0.00%
OPERATING EXPENSE 8,145,146.00 8,145,146.00 8,254,246.00 (109,100.00) -1.34%-Unfav. Grounds Maintenance ($100,000) due to special projects. A budget amendment
is recommended. Motor Pool ($9,200) due to development of actual charges after
budget finalization for 2 vehicles. Partially offset with Professional Services $15,841 for
funds received before charges expensed.
NET OPERATING INCOME (LOSS)($1,755,146.00)($1,755,146.00)($1,864,246.00)(109,100.00)$ 6.22%
NON-OPERATING REVENUE (EXPENSE)150,000.00 150,000.00 550,000.00 400,000.00 266.67%-Fav. due to higher than expected available cash balalnce.
TOTAL INCOME BEFORE
CONTRIBUTIONS AND TRANSFERS (1,605,146.00) (1,605,146.00) ($1,314,246.00)290,900.00 -18.12%
TRANSFERS IN/(OUT)(25,000.00) (25,000.00) (28,800.00) (3,800.00) 15.20%-Unfav. Transfer Out ($7,000) for Airport Vehicle Fleet Expansion. Partially offset by
favorable $3,195 for development of actual charges after budget finalization.
CAPITAL CONTRIBUTION - - 138,700.00 138,700.00 0.00%-Fav. Capital Contributions - State Grants - ($138,674) for ARPA and PFAS Grants FY
2023 received in FY 2024.
TOTAL NET INCOME (LOSS)($1,630,146.00)($1,630,146.00)($1,204,346.00)$425,800.00
TOTAL NET ASSETS - BEGINNING 76,090,785.21$
TOTAL NET ASSETS - ENDING 74,886,439.21$
49
COUNTY OF OAKLAND
FY 2024 FIRST QUARTER REPORT
INTERNAL SERVICE FUND
RISK MANAGEMENT
ADOPTED AMENDED FY 2024 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
LIABILITY INSURANCE FUND 67700
OPERATING REVENUES:
Outside Revenue $ 14,766.00 $ 14,766.00 $ 14,766.00 0.00 0.00%
Inside Revenue 12,825,090.00 12,825,090.00 12,825,090.00 0.00 0.00%
Total Operating Revenue $ 12,839,856.00 $ 12,839,856.00 $ 12,839,856.00 0.00 0.00%
OPERATING EXPENSE $ 7,166,589.00 $ 7,166,589.00 $ 6,890,089.00 276,500.00 3.86%-Fav. Salaries and Fringe Benefits $371,000 due to two
vacant positions, offset by unfav Indirect Costs ($97,515)
due to actual charges determined after budget finalization.
CLAIMS PAID 8,056,000.00 8,056,000.00 8,056,000.00 0.00 0.00%
TOTAL OPERATING EXPENSES $ 15,222,589.00 $ 15,222,589.00 $ 14,946,089.00 276,500.00 1.82%
OPERATING INCOME (LOSS)(2,382,733.00)(2,382,733.00)(2,106,233.00)276,500.00 -11.60%
NON-OPERATING REVENUE (EXPENSE) 100,000.00 100,000.00 500,000.00 400,000.00 400.00%-Fav. due to higher than expected available cash balance.
NET REVENUES OVER/(UNDER)*
EXPENSES $ (2,282,733.00) $ (2,282,733.00) (1,606,233.00) $ 676,500.00
TOTAL NET ASSETS - BEGINNING 559,304.00
TOTAL NET ASSETS - ENDING $ (1,046,929.00)
50
ADOPTED AMENDED FY 2024 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DRAIN EQUIPMENT FUND ( 63900)
OPERATING REVENUES:
Inside 58,305,486.00$ 58,305,486.00$ 56,705,486.00$ (1,600,000.00)$ -2.74%Unfav - Reimbursement Salaries ($2,000,000) due to unallocated
payroll charges for turnover and vacant positions, offset in Salaries
and Fringes. Fav - Reimbursement General $400,000 a result of
charging more time and supplies than anticipated to special revenue
and proprietary funds that can be allocated to benefiting systems.
Outside 240,100.00 240,100.00 240,100.00 - 0.00%
Total Revenue 58,545,586.00 58,545,586.00 56,945,586.00 (1,600,000.00)-2.73%
OPERATING EXPENSES $58,791,546.00 $58,791,546.00 $57,044,446.00 $1,747,100.00 2.97%Fav - Salaries and Fringes $2,000,000 due to turnover and vacant
positions. Fav - Depreciation Computer Software $75,000 due to the
Supervisory Control and Data Acquisition (SCADA) system common
to all project not being booked in first quarter FY 2024. Unfav -
Materials and Supplies ($300,000) due to inflationary price increases
and usages of these water and sewer supplies. Unfav - Indirect
Costs ($20,000) due to indirect cost rate finalized after budget
process. Unfav - Equipment Rental Expense ($4,200) the result of
increased use in specialty equipment needed for maintenance
projects.
NET INCOME (LOSS) BEFORE ($245,960.00)($245,960.00)($98,860.00)$147,100.00 -59.81%
WATER RESOURCES COMMISSIONER
FY 2024 FIRST QUARTER FORECAST
INTERNAL SERVICE FUND
COUNTY OF OAKLAND
51
ADOPTED AMENDED FY 2024 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
WATER RESOURCES COMMISSIONER
FY 2024 FIRST QUARTER FORECAST
INTERNAL SERVICE FUND
COUNTY OF OAKLAND
NON-OPERATING REVENUE/(EXPENSE)$216,600.00 $216,600.00 $228,600.00 12,000.00 5.54%Fav - Sale of Equipment $12,000 due to sale of user owned
equipment at county auction.
TRANSFER IN - - - - 0.00%
TRANSFERS (OUT) - - 124,400.00 (124,400.00) 0.00%Unfav - Transfers Out ($124,400) due to the FY 2023 budget
schedule purchase of a truck and two snow plows not occurring until
FY 2024.
NET REVENUES OVER (UNDER)
EXPENSES*
($29,360.00)($29,360.00)$5,340.00 $34,700.00
TOTAL NET POSITION - BEGINNING 34,139,228.83$
TOTAL NET POSITION - ENDING 34,144,568.83$
*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.
52
FY 2024 FIRST QUARTER REPORT
INTERNAL SERVICE FUND
FACILITIES MANAGEMENT
ADOPTED AMENDED FY 2024 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
FACILITIES MAINTENANCE & OPERATIONS (#63100)
OPERATING REVENUES:
Outside Revenue 549,611.00$ 550,413.00$ 550,413.00$ -$ 0.00%
Inside Revenue 33,038,476.00 33,038,476.00 33,038,476.00 - 0.00%
Total Revenue 33,588,087.00$ 33,588,889.00$ 33,588,889.00$ -$ 0.00%
OPERATING EXPENSES 33,588,087.08$ 33,588,889.08$ 33,388,889.08$ 200,000.00$ 0.60%Favorable Sublet Repairs Expense $200,000 due to lower than anticipated
use and Road Salt $80,000 due to decreased use of salt on roadways.
Partially offset by Laundry ($80,000) due to more than anticipated usage.
BUDGETED EQUITY ADJUSTMENTS -$ 802.00$ -$ -$ 0.00%
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (0.08)$ (802.08)$ 199,999.92$ 200,000.00$
NON-OPERATING REVENUE 116,000.00$ 116,000.00$ 116,000.00$ -$ 0.00%
TRANSFERS IN -$ -$ -$ -$ 0.00%
TRANSFERS OUT 2,000,000.00$ 2,000,000.00$ 2,000,000.00$ -$ 0.00%
NET REVENUES OVER(UNDER)
EXPENSES*2,115,999.92$ 2,115,197.92$ 2,315,999.92$ 200,000.00$
TOTAL NET POSITION - BEGINNING 8,635,092.51$
TOTAL NET POSITION - ENDING 10,951,092.43$
*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
53
COUNTY OF OAKLAND
FY2024 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
ADOPTED AMENDED FY 2024 VARIANCE
FRINGE BENEFITS FUND 67800 BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
OPERATING REVENUE
RETIREES MEDICAL - VEBA DEBT 34,001,533 34,001,533 34,001,533.00 - 0.00%
RETIREMENT ADMINISTRATION 4,695,624 4,695,624 4,695,624.00 - 0.00%
RETIREMENT ADMINISTRATION - PTNE 350,000 350,000 350,000.00 - 0.00%
DEFERRED COMPENSATION-MATCH 4,330,548 4,330,548 4,330,548.00 - 0.00%
PENSION EXPENSE CONTRIBUTION 1,193,986 1,193,986 1,193,986.00 - 0.00%
SALARY CONTINUATION 4,952,674 4,952,674 4,952,674.00 - 0.00%
DEFINED CONTRIBUTION PLAN 23,825,636 23,825,636 27,170,501.00 3,344,865.00 14.04%-Fav. due to County payroll actuals being higher than budget projections, partially
offset by Defined Contribution Plan expense.
DEFINED CONTRIBUTION PLAN - PTNE 327,888 327,888 327,888.00 - 0.00%
EMPLOYEE IN-SERVICE TRAINING 2,482,358 2,482,358 2,482,358.00 - 0.00%
EMPLOYEE ENGAGEMENT 996,662 996,662 996,662.00 - 0.00%
EMPLOYEE BENEFITS UNIT 1,617,589 1,617,589 1,617,589.00 - 0.00%
FLEX BENEFIT PLAN 85,000 85,000 85,000.00 - 0.00%
FRINGE BENEFITS REVENUE 125,028 125,028 125,028.00 - 0.00%
TUITION REIMBURSEMENT 400,000 400,000 400,000.00 - 0.00%
RETIREMENT HEALTH SAVINGS 4,835,980 4,835,980 5,109,465.00 273,485.00 5.66%-Fav. due to County payroll actuals being higher than budget projection, partially offset
by Retirement Health Savings expense.
HEALTH SAVINGS ACCOUNT - - - - 0.00%
GROUP LIFE INSURANCE 740,000 740,000 740,000.00 - 0.00%
SOCIAL SECURITY 23,779,000 23,779,000 23,779,000.00 - 0.00%
HOSPITAL INSURANCE 43,944,546 43,944,546 43,944,546.00 - 0.00%
PRESCRIPTION COVERAGE INSURANCE 11,950,000 11,950,000 11,950,000.00 - 0.00%
DENTAL INSURANCE 3,420,000 3,420,000 3,420,000.00 - 0.00%
OPTICAL INSURANCE 111,000 111,000 111,000.00 - 0.00%
WORKERS COMPENSATION 2,783,075 2,783,075 2,783,075.00 - 0.00%
UNEMPLOYMENT COMPENSATION 200,000 200,000 200,000.00 - 0.00%
INVESTMENT INCOME 3,090,000 3,090,000 3,090,000.00 - 0.00%
EXT - DENTAL INSURANCE 20,000 20,000 20,000.00 - 0.00%
EXT - FLEX BEN ARREARAGES - - - - 0.00%
EXT - FLEX BEN DENTAL INSURANCE 165,000 165,000 165,000.00 - 0.00%
EXT - FLEX BEN DEDUCTIONS 520,000 520,000 520,000.00 - 0.00%
EXT - FLEX BEN HOSPITALIZATION - EMPLOYEE 5,750,000 5,750,000 5,750,000.00 - 0.00%
EXT - FLEX BEN VISION INSURANCE 145,000 145,000 145,000.00 - 0.00%
EXT - HOSPITAL INSURANCE 250,000 250,000 250,000.00 - 0.00%
EXT - PRESCRIPTION DRUG REBATES 2,000,000 2,000,000 2,000,000.00 - 0.00%
EXT - RETIREE PRESCRIPTION DRUG REBATES 1,050,000 1,050,000 1,050,000.00 - 0.00%
EXT - TRAINING & WELLNESS REVENUE 25,000 25,000 25,000.00 - 0.00%
EXT - VISION INSURANCE 1,500 1,500 1,500.00 - 0.00%
PRIOR YEARS ADJUSTMENTS - - - - 0.00%
REFUND PRIOR YEARS EXPENDITURE - - - - 0.00%
TOTAL REVENUE 184,164,627 184,164,627 187,782,977.00 3,618,350.00 0.00%
54
COUNTY OF OAKLAND
FY2024 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
ADOPTED AMENDED FY 2024 VARIANCE
FRINGE BENEFITS FUND 67800 BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
OPERATING EXPENSE
RETIREES MEDICAL - VEBA DEBT INT/AGING 4,341,533 4,341,533 4,341,533.00 - 0.00%
RETIREMENT ADMINISTRATION 1,011,101 1,011,101 1,011,101.00 - 0.00%
DEFERRED COMP-COUNTY PMTS (MATCH)4,343,548 4,343,548 4,343,548.00 - 0.00%
DEFINED CONTRIBUTION PLAN 23,825,636 23,825,636 26,892,377.00 (3,066,741.00) -12.87%-Unfav. due to County payroll actuals being higher than budget projections, offset by
Defined Contribution Plan revenue.
DEFINED CONTRIBUTION PLAN - PTNE 327,888 327,888 327,888.00 - 0.00%
PENSION CONTRIBUTION EXPENSE 1,193,986 1,193,986 1,193,986.00 - 0.00%
EMPLOYEE IN-SERVICE TRAINING 1,809,358 1,809,358 1,809,358.00 - 0.00%
IN-SERVICE TRAINING - INFO TECH 300,000 300,000 300,000.00 - 0.00%
IN-SERVICE TRAINING - DEI 300,000 300,000 300,000.00 - 0.00%
PROFESSIONAL SERVICES 73,000 73,000 73,000.00 - 0.00%
BENEFITS ADMINISTRATION 529,447 529,447 529,447.00 - 0.00%
EMPLOYEE BENEFITS UNIT 1,352,866 1,352,866 1,352,866.00 - 0.00%
FLEXIBLE BENEFIT PAYMENTS 85,000 85,000 85,000.00 - 0.00%
EMPLOYEE ENGAGEMENT 996,662 996,662 996,662.00 - 0.00%
WELLNESS PROGRAM 650 650 - 650.00 100.00%-Cost Center no longer used, Internal Revenue Service Fund correcting next quarter
ACCOUNTING SERVICES 125,028 125,028 125,028.00 - 0.00%
TUITION REIMBURSEMENT 400,000 400,000 400,000.00 - 0.00%
RETIREMENT HEALTH SAVINGS 4,835,980 4,835,980 5,083,100.00 (247,120.00) -5.11%-Unfav. Due to County payroll actuals being higher than budget projections, offset by
Retirement Health Savings revenue.
GROUP LIFE INSURANCE 1,260,000 1,260,000 1,260,000.00 - 0.00%
SICK AND ANNUAL LEAVE CASH-OUT 3,769,800 3,769,800 3,769,800.00 - 0.00%
SOCIAL SECURITY 23,779,000 23,779,000 23,779,000.00 - 0.00%
MEDICAL INSURANCE 54,445,000 54,445,000 54,445,000.00 - 0.00%
PRESCRIPTION COVERAGE 15,000,000 15,000,000 15,000,000.00 - 0.00%
DENTAL INSURANCE 3,605,000 3,605,000 3,605,000.00 - 0.00%
VISION INSURANCE 257,500 257,500 257,500.00 - 0.00%
DISABILITY INSURANCE 4,952,674 4,952,674 4,952,674.00 - 0.00%
WORKERS COMPENSATION 2,783,075 2,783,075 2,783,075.00 - 0.00%
UNEMPLOYMENT COMPENSATION 200,000 200,000 200,000.00 - 0.00%
CHILD CARE FACILITY 629,802 629,802 629,802.00 - 0.00%
HEALTH INSURANCE PREMIUM TAX - - - - 0.00%
MICHIGAN IPAA TAX 15,000 15,000 15,000.00 - 0.00%
PATIENT CENTERED OUTCOME RESEARCH 30,000 30,000 30,000.00 - 0.00%
INDIRECT COSTS 222,500 222,500 222,500.00 - 0.00%
PENALTIES - - - - 0.00%
TOTAL EXPENSE 156,801,034 156,801,034 160,114,245.00 (3,313,211.00) -2.11%
NET REVENUE OVER/(UNDER) EXPENSES 27,363,593.00 27,363,593.00 27,668,732.00 6,931,561.00
TOTAL NET ASSETS - BEGINNING 421,051,858.52
TOTAL NET ASSETS - ENDING 448,720,590.52
Note: Does not reflect FY 2024 GASB #68 and GASB #75 impact yet; actuary reports are excepted in mid December 2024 and impact will be reflected in the FY 2024 ACFR.
{print "selection";1;9999;1;1}
55
FY 2024 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2024 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES()
OPERATING REVENUES:
Outside 2,084,753.00$ 2,084,753.00$ 1,932,153.00$ (152,600.00)$ -7.32%-Unfavorable Managed Print Services ($203,900) and Enhanced Access Fees
($57,900) due to reduction in external customer requests. Offset by
Fav.Outside Agencies $105,400 and Sale of Equipment $3,800 due to higher
than anticipated usage.
Inside 35,567,012.00 35,569,858.00 37,286,458.00 1,716,600.00 4.83%-Fav. OC Depts Operations & Non Governmental Operations $1,272,500
offset by unfav. OC Depts Development Support & Non Governmental
Development ($433,400) due to rates remaining at prior year levels and
limited resources available to complete development due to vacancies. Also
fav. Prior Year Adjustments $833,000 and Equipment Rental $47,400 due to
rebills to departments for maintenance charges on IT Office Equipment items.
Partially offset by unfav.FOIA Fees($2,900).
TOTAL OPERATING REVENUE 37,651,765.00$ 37,654,611.00$ 39,218,611.00$ 1,564,000.00$ 4.15%
OPERATING EXPENSES 58,174,688.00 58,775,934.00 63,615,234.00 (4,839,300.00) -8.23%-Unfav. Software Maintenance ($2,363,300) due to timing of software support;
Equipment Maintenance ($2,064,200) due to lower than anticipated hardware
maintenance costs due to increased activity; Professional Services
($1,390,400) due to projects previously approved in prior year; Charge Card
Fees ($1,019,200) and Bank Charges ($25,000) for credit card activity;
Indirect Costs ($310,700); Exp Equipment ($65,600) for equip replacement.
Offset by fav. Salaries and Fringes $2,013,400 due to vacanies; Internal
Services $369,000 is primarily due to fav. Insurance Fund; Printing $12,000,
Membership Dues $5,100 and Workshops & Meetings $600 due to usage.
.NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (20,522,923.00)$ (21,121,323.00)$ (24,396,623.00)$ (3,275,300.00)$ 15.51%
NON-OPERATING REVENUE 70,500.00$ 70,500.00$ 501,900.00$ 431,400.00$ 611.91%Fav. primarily due to Interest Income; higher cash balance than anticipated.
TRANSFERS IN 7,934,876.00$ 8,571,226.00$ 8,552,251.00$ (18,975.00)$ -0.22%
TRANSFERS (OUT)-$ -$ -$ -$ 0.00%
CAPITAL CONTRIBUTION -$ -$ -$ -$ 0.00
NET REV OVER(UNDER) EXP*(12,517,547.00)$ (12,479,597.00)$ (15,342,472.00)$ (2,862,875.00)$
TOTAL NET POSITION - BEGINNING 41,994,439.75$
TOTAL NET POSITION - ENDING 26,651,967.75$
*Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category.
Information Technology - Operations (63600)
56
FY 2024 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2024 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES()
OPERATING REVENUES:
Outside 12,000.00$ 12,000.00$ 5,500.00$ (6,500.00)$ -54.17%Unfav. Sale of Phone External due to decreased usage of land lines.
Inside 3,663,780.00 3,663,780.00 4,137,380.00$ 473,600.00$ 12.93%Fav. Sale of Phone due to cell phone usage.
TOTAL OPERATING REVENUE 3,675,780.00$ 3,675,780.00$ 4,142,880.00$ 467,100.00$ 12.71%
OPERATING EXPENSES 4,015,123.00$ 4,015,123.00$ 4,631,023.00$ (615,900.00)$ -15.34%Unfav. Communications ($1,497,700), Internal Services ($65,000) primarily
due to Info Tech Operations ($14,900) and Telephone ($49,500) and
Equipment Repairs and Maintenance ($5,400) due to higher than anticipated
cost; Indirect Cost ($45,400) due to actual charges being developed after
budget finalization; Expendable Equipment ($6,200) for equipment
replacement and Membership Dues ($1,100) based on actual usage.
Partially offset by fav. Contracted Services $990,200 due to less than
anticipated activity; Software Maintenance $9,200 due to lower maintenance
rates and Sublet Repairs $4,600 due to lower than anticipated repair volume.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (339,343.00)$ (339,343.00)$ (488,143.00)$ (148,800.00)$
NON-OPERATING REVENUE 30,000.00$ 30,000.00$ 84,700.00$ 54,700.00$ 182.33%Fav. primarily due to Interest Income; higher cash balance than anticipated.
TRANSFERS IN -$ -$ -$ -$ 0.00%
CAPITAL CONTRIBUTION -$ -$ -$ -$ 0.00%
TRANSFERS (OUT)-$ -$ -$ -$ 0.00%
NET REV OVER(UNDER) EXP*(309,343.00)$ (309,343.00)$ (403,443.00)$ (94,100.00)$
TOTAL NET POSITION - BEGINNING 2,119,432.74$
TOTAL NET POSITION - ENDING 1,715,989.74$
*Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category.
Information Technology - Telephone Communications (67500)
57
FY 2024 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2024 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES()
Information Technology - CLEMIS (53500)
OPERATING REVENUES:
Outside 5,496,353.00$ 5,498,268.00$ 5,426,953.00$ (71,315.00)$ -1.30%Unfav. CLEMIS Crash ($54,600) due to decreased activity; Access Fees
Oakland ($53,600) partially offset by fav. Access Fees Non Oakland $30,200
due to updated law enforcement Full Time Equivalent count used for billing.
Also fav. Parts and Accessories $8,600 due to increased usage by Oakland
and non-Oakland agencies.
Inside 1,799,384.00 1,799,384.00 1,528,684.00 (270,700.00)$ -15.04%Unfav. Service Fees ($172,000) and Reimb General ($75,700) based on
actuals for CLEMIS staff supporting Sheriff project; In-Car Terminal
($24,900) due to participation count higher than budget projection. Offet by
fav. FOIA Fees $1,900.
TOTAL OPERATING REVENUE 7,295,737.00$ 7,297,652.00$ 6,955,637.00$ (342,015.00)$ -4.69%
OPERATING EXPENSES 13,511,930.00$ 13,511,930.00$ 11,444,930.00$ 2,067,000.00$ 15.30%Fav. Salaries and Fringes $1,176,100 due to vacanies; Internal Services
$351,200 primarily due to IT Development; Rebillable Services $318,600
based on actual connectivity costs to Tier 2.5; Indirect Cost $129,900;
Professional Services $44,800 due to lower than anticipated contractual
costs for staffing services; Parts and Accessories $22,400 and Supplies
$1,100 due to usage. Also fav. Charge Card Fees $22,900 for credit card
activity.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (6,216,193.00)$ (6,214,278.00)$ (4,489,293.00)$ 1,724,985.00$
NON-OPERATING REVENUE 35,000.00$ 35,000.00$ 106,700.00$ 71,700.00$ 204.86%Fav. primarily due to Interest Income; higher cash balance than anticipated.
TRANSFERS IN 1,644,186.00$ 1,644,186.00$ 1,644,186.00$ -$ 0.00%
TRANSFERS (OUT)-$ -$ -$ -$ 0.00%
CAPITAL CONTRIBUTION -$ -$ -$ -$ 0.00%
NET REV OVER(UNDER) EXP*(4,537,007.00)$ (4,535,092.00)$ (2,738,407.00)1,796,685.00$
TOTAL NET POSITION - BEGINNING 9,486,107.78
TOTAL NET POSITION - ENDING 6,747,700.78
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.
58