HomeMy WebLinkAboutResolutions - 2024.06.13 - 41291
AGENDA ITEM: Fiscal Year 2024 Second Quarter Financial Forecast
DEPARTMENT: Fiscal Services
MEETING: Board of Commissioners
DATE: Thursday, June 13, 2024 9:30 AM - Click to View Agenda
ITEM SUMMARY SHEET
COMMITTEE REPORT TO BOARD
Resolution #2024-4205 _ 24-51
Motion to adopt the attached suggested resolution.
ITEM CATEGORY SPONSORED BY
Budget Amendment Gwen Markham
INTRODUCTION AND BACKGROUND
Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of Government,
provides for adjustments to the adopted budget. In accordance with Oakland County General
Appropriations Act Section 22, which authorizes budget amendments for variances between the
budgeted revenue and actual revenue, and Section 23, which authorizes budget amendments for
variances between estimated revenue and projected expenditures, amendments are required. The
Fiscal Year (FY) 2024 Second Quarter Financial Forecast Report has identified several variances
and budget amendments are recommended as detailed in the attached Schedule A and B budget
amendment.
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, Fiscal Services Officer
ITEM REVIEW TRACKING
Aaron Snover, Board of Commissioners Created/Initiated - 6/13/2024
David Woodward, Board of Commissioners Approved - 6/13/2024
Hilarie Chambers, Executive's Office Approved - 6/13/2024
Lisa Brown, Clerk/Register of Deeds Final Approval - 6/14/2024
AGENDA DEADLINE: 06/13/2024 9:30 AM
ATTACHMENTS
1. Memo from Fiscal Services
2. Budget Amendments - Schedule A
3. Budget Amendments - Schedule B
4. FY 2024 Second Quarter Financial Forecast Packet
COMMITTEE TRACKING
2024-06-05 Finance - Recommend to Board
2024-06-13 Full Board - Adopt
Motioned by: Commissioner Linnie Taylor
Seconded by: Commissioner Philip Weipert
Yes: David Woodward, Michael Spisz, Michael Gingell, Penny Luebs, Karen Joliat, Christine
Long, Robert Hoffman, Philip Weipert, Gwen Markham, Angela Powell, Marcia Gershenson,
William Miller III, Yolanda Smith Charles, Charles Cavell, Brendan Johnson, Ajay Raman, Ann
Erickson Gault, Linnie Taylor (18)
No: None (0)
Abstain: None (0)
Absent: Kristen Nelson (1)
Passed
June 13, 2024
RESOLUTION #2024-4205 _ 24-51
Sponsored By: Gwen Markham
Fiscal Services - Fiscal Year 2024 Second Quarter Financial Forecast
Chair and Members of the Board:
WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of
Government, provides for adjustments to the adopted budget; and
WHEREAS 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; and
WHEREAS the Fiscal Year (FY) 2024 Second Quarter Financial Forecast Report has identified
several variances and budget amendments are recommended as detailed in the attached Schedule A
and B budget amendment; and
WHEREAS the departments have expended much of their carry forward requests and the remaining
balance is expected to be utilized by the end of FY 2024;
and
WHEREAS Department of Public Services, Animal Shelter and Pet Adoption Center received
donations for the period of January 2024 through March 2024 totaling $17,320.42; and
WHEREAS the Sheriff’s Office received donations for the period of January 2024 through March
2024 totaling $16,600 of which $5,000 was a cash donation for K-9 equipment; and
WHEREAS Children’s Village Division received donations for the period of January 2024 through
March 2024 totaling $12,665.26 of which $100 was a cash donation; and
WHEREAS the Department of Health and Human Services received an allocation in the amount of
$10,000 to acquire reproductive contraceptives through the Michigan Department of Health and
Human Services; and
WHEREAS Health and Humans Services has requested write-offs totaling $36,711.42 for the period
of January 2024 through March 2024 for uncollectible transactions; and
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year
2024 Second Quarter Financial Report.
BE IT FURTHER RESOLVED to authorize the acceptance of the grant extensions.
BE IT FURTHER RESOLVED that the donations be recognized in the Animal Shelter and Pet
Adoption Center, Sheriff’s, Children’s Village Division and Department of Health and Human
Services.
BE IT FURTHER RESOLVED that the uncollectible debts, as recommended by the Department of
Management and Budget and detailed in the attached schedules are authorized to be written
off.
BE IT FURTHER RESOLVED that the FY 2024 – FY 2026 Budgets are amended pursuant to
Schedules A and B.
Chair, the following Commissioners are sponsoring the foregoing Resolution: Gwen Markham.
Date: June 13, 2024
David Woodward, Commissioner
Date: June 13, 2024
Hilarie Chambers, Deputy County Executive II
Date: June 14, 2024
Lisa Brown, County Clerk / Register of Deeds
COMMITTEE TRACKING
2024-06-05 Finance - Recommend to Board
2024-06-13 Full Board - Adopt
Motioned by Commissioner Linnie Taylor seconded by Commissioner Philip Weipert to adopt the
attached Budget Amendment: Fiscal Year 2024 Second Quarter Financial Forecast.
Yes: David Woodward, Michael Spisz, Michael Gingell, Penny Luebs, Karen Joliat, Christine Long,
Robert Hoffman, Philip Weipert, Gwen Markham, Angela Powell, Marcia Gershenson, William
Miller III, Yolanda Smith Charles, Charles Cavell, Brendan Johnson, Ajay Raman, Ann Erickson
Gault, Linnie Taylor (18)
No: None (0)
Abstain: None (0)
Absent: Kristen Nelson (1)
Passed
ATTACHMENTS
1. Memo from Fiscal Services
2. Budget Amendments - Schedule A
3. Budget Amendments - Schedule B
4. FY 2024 Second Quarter Financial Forecast Packet
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Lisa Brown, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true
and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on June
13, 2024, with the original record thereof now remaining in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the Circuit Court at
Pontiac, Michigan on Thursday, June 13, 2024.
Lisa Brown, Oakland County Clerk / Register of Deeds
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, Deputy CFO
Kymberly Coy, Chief, Fiscal Services
Ebru Adoglu-Jones, Supervisor, Fiscal Services
SUBJECT: Fiscal Year 2024 2nd Quarter Forecast
DATE: June 5, 2024
Attached please find the Fiscal Year 2024 2nd 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 2nd quarter of the fiscal year (ending March 31st). 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 $1.4 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.3 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 law changes.
•Lower forecasted Other Intergovernmental Revenues of $31,650.
•Approximately $1,931,650 in higher revenues across a number of other revenue categories including
Taxes, Federal Grants, Investments, and other revenue categories forecasted over by small
amounts.
Expenditure Forecast
Total General Fund Expenditures are forecasted to be $15.1 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 $15.1 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, two departments are forecasted to exceed appropriated levels at the department total level:
•The Sheriff’s Office is forecasted to exceed its budget by $3.3 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.
•Water Resources is forecasted to exceed its budget by $89,167 as a result of higher than anticipated
operating expenditures in contractual and professional services. This will be offset by a second
quarter amendment adjusting for increased soil erosion fee revenues.
1
~OAKIAND~
COUNTY MICHIGAN
MANAGEMENT & BUDGET
Page | 2
2100 Pontiac Lake Road | County Executive Building 41W | Waterford, MI 48328 | Fax (248) 452-9172 | OakGov.com
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.
Impact on Planned Use of Fund Balance
The current amended budget assumes $28.1 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 2023 budget.
In total, this forecast expects the net impact on Planned Use of Fund Balance to be $14.4 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 third quarter forecast and the FY 2024 year-end report.
Please call with any questions you may have prior to the Finance Committee meeting.
2
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
E General Fund Circuit Court Admin.FND10100 CCN3010101 SC731101 PRG121100 730000 Library Continuation 7,000.00$ 7,000.00$ 7,000.00$
E General Fund Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 730000 Contingency (7,000.00) (7,000.00) (7,000.00)
Total Expenditures -$ -$ -$
E General Fund Civil/Criminal Division FND10100 CCN3010301 RC631827 PRG121130 630000 Reimb General $ (125,000.00)-$ -$
E General Fund Civil/Criminal Division FND10100 CCN3010301 RC625250 PRG121130 625000 Attorney Fee - Appellate 125,000.00 - -
Total Expenditures $- -$ -$
WHEREAS a FY2024 Budget Amendment totaling $125,000 is recommended for Circuit Court's Civil/Criminal Division, reallocating the budget for reimbursement of attorney fees to match actual activity; and
District Court
E General Fund District Court AdministrationFND10100 CCN3020101 SC730373 PRG121130 730000 Contracted Services (330,000.00)$ -$ -$
E General Fund District Court AdministrationFND10100 CCN3020301 SC730373 PRG121020 730000 Professional Services 110,000.00 - -
E General Fund District Court AdministrationFND10100 CCN3020401 SC730373 PRG121020 730000 Professional Services 110,000.00 - -
E General Fund District Court AdministrationFND10100 CCN3020501 SC730373 PRG121020 730000 Professional Services 110,000.00 - -
E General Fund District Court AdministrationFND10100 CCN3020101 SC774636 PRG121130 770000 Info Tech Operations (19,491.00) - -
E General Fund District Court AdministrationFND10100 CCN3020301 SC774636 PRG121020 770000 Info Tech Operations 6,497.00 - -
E General Fund District Court AdministrationFND10100 CCN3020401 SC774636 PRG121020 770000 Info Tech Operations 6,497.00 - -
E General Fund District Court AdministrationFND10100 CCN3020501 SC774636 PRG121020 770000 Info Tech Operations 6,497.00 - -
E General Fund District Court AdministrationFND10100 CCN3020101 SC778675 PRG121130 770000 Telephone Communications (1,440.00) - -
E General Fund District Court AdministrationFND10100 CCN3020301 SC778675 PRG121020 770000 Telephone Communications 480.00 - -
E General Fund District Court AdministrationFND10100 CCN3020401 SC778675 PRG121020 770000 Telephone Communications 480.00 - -
E General Fund District Court AdministrationFND10100 CCN3020501 SC778675 PRG121020 770000 Telephone Communications 480.00 - -
Total Expenditures -$ -$ -$
R Information Technology IT Administration FND63600 CCN1080101 RC695500 PRG152000 BFA10100 695500 Transfer In - Gen Fund 19,491.00$ -$ -$
R Information Technology IT Administration FND63600 CCN1080101 RC631372 PRG152000 630000 OC Depts Development/Support (19,491.00)
R Information Technology IT Administration FND63600 CCN1080101 RC665882 PRG152000 665882 Planned Use of Balance 19,491.00
Total Revenue 19,491.00$ -$ -$
E Information Technology IT Application Services FND63600 CCN1080201 SC731780 PRG152000 730000 Software Support/Maintenance 19,491.00$ -$ -$
Total Expenditures 19,491.00$ -$ -$
R Telephone Communicat IT Technical Systems and NFND67500 CCN1080601 RC695500 PRG152000 BFA10100 695500 Transfer In - Gen Fund 1,440.00$ -$ -$
R Telephone Communicat IT Technical Systems and NFND67500 CCN1080601 RC632009 PRG152000 630000 Sale Phone Service Internal (1,440.00) - -
R Telephone Communicat IT Technical Systems and NFND67500 CCN1080601 RC665882 PRG152000 665882 Planned Use of Balance 1,440.00 - -
Total Revenue 1,440.00$ -$ -$
E Telephone Communicat IT Technical Systems and NFND67500 CCN1080601 SC730324 PRG152000 730000 Communications 1,440.00$ -$ -$
Total Expenditures 1,440.00$ -$ -$
E General Fund Pros. Admin FND10100 CCN4010101 SC712090 PRG122000 702000 On Call 7,000.00$ 7,000.00$ 7,000.00$
E General Fund Pros. Litigation FND10100 CCN4010201 SC712090 PRG122050 702000 On Call (12,000.00) (12,000.00) (12,000.00)
E General Fund Pros Warrants FND10100 CCN4010301 SC712090 PRG122050 702000 On Call 5,000.00 5,000.00 5,000.00
Total Expenditures -$ -$ -$
E General Fund Pros. Admin FND10100 CCN4010401 SC702010 PRG122050 702000 Salaries (9,600.00)$ -$ -$
E General Fund Pros. Admin FND10100 CCN4010101 SC731241 PRG122050 730000 Miscellaneous 9,600.00 - -
Total Expenditures -$ -$ -$
E General Fund Grants Pros. Litigation FND10101 CCN4010201 SC730373 PRG122090 GRN-1003633 730000 Contracted Services (46,798.00)$ -$ -$
E General Fund Grants Pros. Litigation FND10101 CCN4010201 SC731241 PRG122090 GRN-1003633 730000 Miscellaneous 2,339.00 - -
E General Fund Grants Pros. Litigation FND10101 CCN4010201 SC731458 PRG122090 GRN-1003633 730000 Professional Services 44,195.00 - -
E General Fund Grants Pros. Litigation FND10101 CCN4010201 SC732165 PRG122090 GRN-1003633 730000 Workshops and Meetings 264.00 - -
-$ -$ -$
WHEREAS a FY2024-FY2026 budget amendment is recommended for Circuit Court, correcting the Library Contination line-item to include the net neutral change of $7,000 which was inadvertently omitted during FY 2024-FY 2026 budget development; and
Prosecuting Attorney
WHEREAS a FY 2024 - FY 2026 budget amendment of $12,000 is recommended for the Prosecutor's Office to reallocate On Call budgets to more accurately reflect actual spending; and
Oakland County, Michigan
FY 2024 Second Quarter Financial Forecast and Budget Amendments
Schedule "A" DETAIL
WHEREAS a FY 2024 budget amendment of $9,600 is recommended for the Prosecutor's Office to move Law Clerk Intern P00015060 salary budget to Contracted Services as this intern position is contracted through the Prosecuting Attorney Association of Michigan (PAAM); and
WHEREAS a FY 2024 budget amendment of $46,798 is recommended for the Prosecutor's Office Oxford School Incident Grant GRN-1003633 to reallocate budgets between expenditure line items to accurately reflect actual spending; and
WHEREAS a FY2024 budget amendment totaling $371,862 is recommened for the 52nd District Court to correct Res. #2023-3298, splitting out the costs associated with the IT Liason positions between divisions, and recognizing the related transfers in budget for the respective IT funds that were inadvertently omitted
from the original amendment; and
2nd QTR Budget Amendments - Sched A and B Schedule A4
I I I I I I I I I I I I
I
I
I I
I
I
R/E Fund Name Division Name
Fund #
(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 Second Quarter Financial Forecast and Budget Amendments
Schedule "A" DETAIL
R General Fund Inv. & Forensic Svcs FND10100 CCN4030901 RC695500 PRG116240 BFA21340 695500 Transfers In - Law Enforcement Enhance Lab Fees 182,005.00$ -$ -$
R General Fund Emergency Comm Ops FND10100 CCN4030701 RC695500 PRG116230 BFA21396 695500 Transfers In - Sheriff Dispatch Training 2,309.00 - -
R General Fund Corrective Services FND10100 CCN4030301 RC695500 PRG112620 BFA21397 695500 Transfers In - Sheriff Booking Fee Training 6,715.00 - -
Total Revenue 191,029.00$ -$ -$
E General Fund Inv. & Forensic Svcs FND10100 CCN4030901 SC750203 PRG116240 750000 Forensic Lab Enhancement 182,005.00$ -$ -$
E General Fund Emergency Comm Ops FND10100 CCN4030701 SC731304 PRG116230 730000 Officers Training (Dispatch)2,309.00 - -
E General Fund Corrective Services FND10100 CCN4030301 SC731304 PRG112620 730000 Officers Training (Corrections)6,715.00 - -
Total Expenditures 191,029.00$ -$ -$
E General Fund Emergency Response & PreFND10100 CCN4030501 SC702010 PRG112680 702000 Salaries Regular (86,392.00)$ (96,976.00)$ (96,976.00)$
E General Fund Emergency Response & PreFND10100 CCN4030501 SC712020 PRG112680 702000 Overtime (25,600.00) (25,600.00) (25,600.00)
E General Fund Emergency Response & PreFND10100 CCN4030501 SC722750 PRG112680 722000 Workers Comp (893.00) (903.00) (903.00)
E General Fund Emergency Response & PreFND10100 CCN4030501 SC722770 PRG112680 722000 Retirement (2,581.00) (2,896.00) (2,896.00)
E General Fund Emergency Response & PreFND10100 CCN4030501 SC722790 PRG112680 722000 Social Security (1,253.00) (1,406.00) (1,406.00)
E General Fund Emergency Response & PreFND10100 CCN4030501 SC722820 PRG112680 722000 Unemployment (52.00) (58.00) (58.00)
E General Fund Technology Info & InnovatioFND10100 CCN4030801 SC702010 PRG112680 702000 Salaries Regular 86,392.00 96,976.00 96,976.00
E General Fund Technology Info & InnovatioFND10100 CCN4030801 SC712020 PRG112680 702000 Overtime 25,600.00 25,600.00 25,600.00
E General Fund Technology Info & InnovatioFND10100 CCN4030801 SC722750 PRG112680 722000 Workers Comp 893.00 903.00 903.00
E General Fund Technology Info & InnovatioFND10100 CCN4030801 SC722770 PRG112680 722000 Retirement 2,581.00 2,896.00 2,896.00
E General Fund Technology Info & InnovatioFND10100 CCN4030801 SC722790 PRG112680 722000 Social Security 1,253.00 1,406.00 1,406.00
E General Fund Technology Info & InnovatioFND10100 CCN4030801 SC722820 PRG112680 722000 Unemployment 52.00 58.00 58.00
Total Expenditures -$ -$ -$
R General Fund Patrol Services FND10100 CCN4030601 RC650301 PRG116210 650000 Donations $ 5,000 -$ -$
Total Revenues 5,000$ -$ -$
E General Fund Patrol Services FND10100 CCN4030601 SC731024 PRG116210 730000 K-9 Program 5,000$ -$ -$
Total Expenditures 5,000$ -$ -$
E General Fund Technology Info & InnovatioFND10100 CCN4030801 SC750399 PRG110085 750000 Office Supplies $ 10,000.00 $ 10,000.00 $ 10,000.00
E General Fund Corrective Services FND10100 CCN4030301 SC774636 PRG112590 770000 Info Tech Ops (10,000.00) (10,000.00) (10,000.00)
Total Expenditures -$ -$ -$
E General Fund Patrol Services FND10100 CCN4030601 SC731024 PRG110000 730000 K-9 Program 27,800.00$ 27,800.00$ 27,800.00$
E General Fund Patrol Services FND10100 CCN4030601 SC731024 PRG116210 730000 K-9 Program (27,800.00) (27,800.00) (27,800.00)
Total Expenditures -$ -$ -$
Human Resources
E General Fund HR Recruitment and
Workforce Planning
Administration
FND10100 CCN1050401 SC750399 PRG183010 75000 Office Supplies (7,500.00)$ (7,500.00)$ (7,500.00)$
E General Fund HR Recruitment FND10100 CCN1050403 SC731570 PRG183020 730000 Recruitment Expense 7,500.00 7,500.00 7,500.00
-$ -$ -$
Sheriff
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 $191,029 is being recognized for eligible forensic lab and training costs for
dispatchers and corrections officers; and
WHEREAS a FY 2024 budget amendment of $116,771 and FY 2025 - 2026 of $127,839 is recommended for the Sheriff's Office to correct the cost center of Records Management division personnel budget for three positions - P00000404, P00011208, P00011209; and
WHEREAS a FY24 Sheriff's Office budget amendment of $5,000 is recommended to accept a donation to the K9 Unit from Shannon and Bill Johns in memory of Bob Loken; and
WHEREAS a FY 2024 - FY2026 budget amendment of $10,000 is recommended for the Sheriff's Office to reallocate budgets between Info Tech Ops and Office Supplies expenditure line items per Information Technology bulletin 2/23/2024 indicating the method for ordering certain items will now be performed by the
department and charged to departmental Office Supplies; and
WHEREAS a FY 2024 - FY 2026 budget amendment is recommended for the HR Workforce Mgt Division reallocating Office Supplies ($7,500) to Recruitment Expense to reflect actual activity; and
WHEREAS a FY24-FY26 Sheriff's Office budget amendment of $27,800 is recommended to correct the program associated with the K9 budget; and
2nd QTR Budget Amendments - Sched A and B Schedule A5
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 Second Quarter Financial Forecast and Budget Amendments
Schedule "A" DETAIL
Economic Development
R General Fund Non-Departmental FND10100 CCN9010101 RC695500 PRG196030 BFA42110 695500 Transfers In 900,000.00$ -$ -$
R General Fund Non-Departmental FND10100 CCN9010101 RC665882 PRG196030 665882 Planned Use of Balance (900,000.00) - -
Total Revenues -$ -$ -$
E Pontiac Development FuFacilities Planning FND42110 CCN1040801 SC788001 PRG148020 BFA10100 788001 Transfers Out 900,000.00$ -$ -$
E Pontiac Development FuFacilities Planning FND42110 CCN1040801 SC760126 PRG148020 GRN-1004403 PRJ-17526 788001 Capital Outlay Miscellaneous (900,000.00) - - Total Expenditures -$ -$ -$
R General Fund Veteran's Services FND10100 CCN1090401 RC631827 PRG132050 630000 Reimburesement General 4,225.00$ -$ -$
4,225.00$ -$ -$
E General Fund Veteran's Services FND10100 CCN1090401 SC732018 PRG132050 730000 Travel and Conference 4,225.00$ - -
4,225.00$ -$ -$
Water Resources Commissioner
R General Fund Water Resources Commiss FND10100 CCN6010101 RC631827 PRG174250 630000 Reimbursement General 34,000.00$ -$ -$
R General Fund Water Resources Commiss FND10100 CCN6010101 RC632121 PRG174250 630000 Soil Erosion Fees 90,000.00 - -
Total Revenues 124,000.00$ -$ -$
E General Fund Water Resources Commiss FND10100 CCN6010101 SC730373 PRG174250 730000 Contracted Services 94,000.00$ -$ -$
E General Fund Water Resources Commiss FND10100 CCN6010101 SC731458 PRG174250 730000 Professional Services 30,000.00 - -
Total Expenses 124,000.00$ -$ -$
WHEREAS a FY 2024 budget amendment for the Water Resources Commissioner General Fund is recommended for $124,000 due to new Contracted Services and Professional Services contracts for reorganization issues, soil erosion sediment control issues and for legislation; and
pertaining to water and stormwater issues.
WHEREAS a FY 2024 budget amendment of $900,000 is recommended for the General Fund as M.R. #24010 authorizes the reimbursement subsequent to the acceptance of $50 million State of Michigan's Enhancement grant for the Pontiac Development. The funds will be returned to the General Fund Strategic
Investment Plan Assigned Fund Balance (GL #383554) from the Pontiac Development Fund (Fund 42110); and
WHEREAS a FY 2024 budget amendment of $4,225 is recommended for the Veterans' Service Division to accept funding for the 2024 Michigan Veterans Affairs Agency's County Traning Reimbursement program. The funding is to ensure County counselors receive the required Continued Education Units (CEU's) on
veteran benefits, laws, and procedures. M.R. #19006 authorizes Management and Budget to administratively process grant agreements and grant amendments of $10,000 or less, after review and approval by Management and Budget, Human Resources, Risk Management and Corporation Counsel when the grant
d t i i t d i t l l t th iti h d th t d t i t l ti d
2nd QTR Budget Amendments - Sched A and B 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
Circuit Court - FY 2024 Adult Treatment Court
R Judicial Grants Civil/Criminal Division FND11012 CCN3010301 RC615571 PRG121200 GRN-1004299 615000 State Operating Grants $ (31,500.00) $ (31,500.00) $ (31,500.00)
R Judicial Grants Civil/Criminal Division FND11012 CCN3010301 RC610313 PRG121200 GRN-1004299 610000 Federal Operating Grants 31,500.00 31,500.00 31,500.00 Total Revenues $- $- $-
WHEREAS a FY 2024 - FY 2026 budget amendment is recommended for Circuit Court to correct the revenue categories used to record the FY 2024 Adult Treatment Court Byrne Grant award from State to Federal operating grants; and
District Court - 52-1 Novi- Michigan Drug Court Grants
E Judicial Grants Division - I Novi FND11012 CCN3020205 SC730373 PRG121050 GRN-1004286 730000 Contracted Services $ (2,100.00) $- $-
E Judicial Grants Division - I Novi FND11012 CCN3020205 SC732018 PRG121050 GRN-1004286 730000 Travel and Conference 2,100.00 - - Total Expenditures $- $- $-
E Judicial Grants Division - I Novi FND11012 CCN3020205 SC722770 PRG121050 GRN-1004271 722000 Retirement (1,029.00)$ -$ -$
E Judicial Grants Division - I Novi FND11012 CCN3020205 SC730373 PRG121050 GRN-1004271 730000 Contractual Services 1,029.00 - -
-$ -$ -$
WHEREAS a FY2024 budget amendment of $1,029 is recommended for 52-1 District Court (Novi) to recognize Amendment #1 to the Drug Court Program for the 1st Division, reallocating funds between line items casuing no impact to the original award (MR 2023-3440); and
Prosecuting Attorney - FY 2024 Anti Terrorism Grant
E Law Enforcement GrantsProsecuting Litigation FND11005 CCN4010201 SC702010 PRG122090 GRN-1004262 702000 Salaries Regular 117,000.00$ 117,000.00$ 117,000.00$
E Law Enforcement GrantsProsecuting Litigation FND11005 CCN4010201 SC722740 PRG122090 GRN-1004262 722000 Fringe Benefits 68,000.00 68,000.00 68,000.00
E Law Enforcement GrantsProsecuting Litigation FND11005 CCN4010201 SC730359 PRG122090 GRN-1004262 730000 Contingency (167,333.00) (167,333.00) (167,333.00)
E Law Enforcement GrantsProsecuting Litigation FND11005 CCN4010201 SC750399 PRG122090 GRN-1004262 750000 Office Supplies (17,667.00) (17,667.00) (17,667.00)
Total Expenditures -$ -$ -$
Sheriff - Restricted Funds
R Enhance Lab Fees Inv. & Forensic Svcs FND21340 CCN4030901 RC665882 PRG116240 665882 Planned Use of Balance 182,005.00$ -$ -$
Total Revenue 182,005.00$ -$ -$
E
Law Enforcement
Enhance Lab Fees Inv. & Forensic Svcs FND21340 CCN4030901 SC788001 PRG116240 BFA10100 788001 Transfers Out - General Fund 182,005.00$ -$ -$
Total Expenditures 182,005.00$ -$ -$
R Dispatch Training Emergency Comm Ops FND21396 CCN4030701 RC665882 PRG112630 665882 Planned Use of Balance 2,309.00$ -$ -$
Total Revenue 2,309.00$ -$ -$
E Dispatch Training Emergency Comm Ops FND21396 CCN4030701 SC788001 PRG112630 BFA10100 788001 Transfers Out - General Fund 2,309.00$ -$ -$
Total Expenditures 2,309.00$ -$ -$
R
Sheriff Booking Fee
Training Corrective Services FND21397 CCN4030301 RC665882 PRG112620 665882 Planned Use of Balance 6,715.00$ -$ -$
Total Revenue 6,715.00$ -$ -$
E
Sheriff Booking Fee
Training Corrective Services FND21397 CCN4030301 SC788001 PRG112620 BFA10100 788001 Transfers Out - General Fund 6,715.00$ -$ -$
Total Expenditures 6,715.00$ -$ -$
Oakland County, Michigan
FY 2024 Second Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
WHEREAS a FY 2024 - FY 2026 budget amendment of $185,000 is recommended for the Prosecutor's Office Anti-Terrorism Grant by reallocating the budgets between expenditure line items to accurately reflect actual expenditure activity; and
WHEREAS a FY 2024 budget amendment is recommended for the Sheriff's to transfer a total of $191,029 to the General Fund to recognize eligible reimbursable expenditures related to forensic lab and training costs for dispatchers and corrections officers; and
WHEREAS a FY 2024 budget amendment is not required for 52-1 District Court to reflect Amendment #2 to the FY 2024 Michigan Mental Health Court Program, as the reallocation of $2,808 from Contractual/Tether Services, $1,000 to Contractual/Testing and $1,808 towards
Contractual/Assessment Tool falls within the same account string; and
WHEREAS a FY 2024 budget amendment is not required for 52-1 District Court-Novi as Amendment #2 to the Michigan Veteran's Treatment Court reallocates $1,029 from Electronic Monitoring to Assessment Services which falls within the same spend category; and
WHEREAS a FY 2024 budget amendment is not required to reflect Amendment #2 to the Drug Court Grant Program (Driving While Impaired), as the reallocation of $16 from Contractual/Electronic Monitoring, to Contractual/Assessment Tool falls within the same account string; and
WHEREAS a FY2024 budget amendment of $2,100 is recommended for District Court to recognize Amendment #1 to the Michigan Drug Court Grant Program (Driving While Impaired) for the 1st Division, reallocating funds between line items causing no impact to the original award; and
2nd QTR Budget Amendments - Sched A and B Schedule B7
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 Second Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
Sheriff's - Comprehensive Opioid, Stimulant and Substance Abuse Program Grant
R Law Enforcement GrantsEmergency Response and PFND11005 CCN4030501 RC610313 PRG110110 GRN-1004007 610000 Federal Operating Grant $ 72,595.00 $ 60,585.00 -$
Total Revenue $ 72,595.00 $ 60,585.00 -$
E Law Enforcement GrantsEmergency Response and PFND11005 CCN4030501 SC702010 PRG110110 GRN-1004007 702000 Salaries Regular 17,930.00$ 21,057.00$ -$
E Law Enforcement GrantsEmergency Response and PFND11005 CCN4030501 SC712020 PRG110110 GRN-1004007 702000 Overtime 26,936.00 9,804.00 -
E Law Enforcement GrantsEmergency Response and PFND11005 CCN4030501 SC722900 PRG110110 GRN-1004007 722000 Fringe Benefit Adjustments 18,775.00 15,654.00 -
E Law Enforcement GrantsEmergency Response and PFND11005 CCN4030501 SC731213 PRG110110 GRN-1004007 730000 Membership Dues 75.00 75.00 -
E Law Enforcement GrantsEmergency Response and PFND11005 CCN4030501 SC731304 PRG110110 GRN-1004007 730000 Officers Training 10,080.00 14,271.00 -
E Law Enforcement GrantsEmergency Response and PFND11005 CCN4030501 SC732018 PRG110110 GRN-1004007 730000 Travel and Conference (1,201.00) (276.00) -
Total Expenditures $ 72,595 $ 60,585 -$
Economic Development - County Veteran Service Fund
E Other Grants Veteran Services FND11011 CCN1090401 SC730072 PRG132050 GRN-1004247 730000 Advertising (20,000.00)$ -$ -$
E Other Grants Veteran Services FND11011 CCN1090401 SC732011 PRG132080 GRN-1004247 730000 Transportation (20,000.00) - -
E Other Grants Veteran Services FND11011 CCN1090401 SC750245 PRG132050 GRN-1004247 750000 Incentives 40,000.00 - - Total Expenditures -$ -$ -$
Health and Human Services - FY 2024 Emerging Threats Grant
R Human Services Grants Health FND11007 CCN1060201 RC610313 PRG133095 GRN-1004198 610000 Federal Operating Grants 1,414,692.00$ -$ -$
Total Revenues 1,414,692.00$ -$ -$
E Human Services Grants Health FND11007 CCN1060201 SC702010 PRG133095 GRN-1004198 702000 Salaries Regular 23,047.00$ -$ -$
E Human Services Grants Health FND11007 CCN1060201 SC722740 PRG133095 GRN-1004198 722000 Fringe Benefits 18,324.00 - -
E Human Services Grants Health FND11007 CCN1060201 SC730926 PRG133095 GRN-1004198 730000 Indirect Costs (3,554.00) - -
E Human Services Grants Health FND11007 CCN1060201 SC730373 PRG133095 GRN-1004198 730000 Contracted Services 1,000,000.00 - -
E Human Services Grants Health FND11007 CCN1060201 SC731346 PRG133095 GRN-1004198 730000 Personal Mileage 3,350.00 - -
E Human Services Grants Health FND11007 CCN1060201 SC732018 PRG133095 GRN-1004198 730000 Travel and Conferences 15,000.00 - -
E Human Services Grants Health FND11007 CCN1060201 SC731458 PRG133095 GRN-1004198 730000 Professional Services (600,000.00) - -
E Human Services Grants Health FND11007 CCN1060201 SC750294 PRG133095 GRN-1004198 750000 Material and Supplies 958,525.00 - -
Total Expenditures 1,414,692.00$ -$ -$
R Human Services Grants Health FND11007 CCN1060201 RC610313 PRG133095 GRN-1004197 610000 Federal Operating Grants 555,810.00$ -$ -$
Total Revenues 555,810.00$ -$ -$
E Human Services Grants Health FND11007 CCN1060201 SC702010 PRG133095 GRN-1004197 702000 Salaries Regular (67,978.00)$ -$ -$
E Human Services Grants Health FND11007 CCN1060201 SC722740 PRG133095 GRN-1004197 722000 Fringe Benefits (40,909.00) - -
E Human Services Grants Health FND11007 CCN1060201 SC730926 PRG133095 GRN-1004197 730000 Indirect Costs (9,388.00) - -
E Human Services Grants Health FND11007 CCN1060201 SC731458 PRG133095 GRN-1004197 730000 Professional Services 90,275.00 - -
E Human Services Grants Health FND11007 CCN1060201 SC732018 PRG133095 GRN-1004197 730000 Travel and Conference 3,000.00 - -
E Human Services Grants Health FND11007 CCN1060201 SC750294 PRG133095 GRN-1004197 750000 Material and Supplies 530,810.00 - -
E Human Services Grants Health FND11007 CCN1060201 SC760157 PRG133095 GRN-1004197 760000 Lab Equipment 50,000.00 - -
Total Expenditures 555,810.00$ -$ -$
R Human Services Grants Health FND11007 CCN1060201 RC615571 PRG133095 GRN-1004179 615000 State Operating Grants 110,000.00$ -$ -$
Total Revenues 110,000.00$ -$ -$
E Human Services Grants Health FND11007 CCN1060201 SC731346 PRG133095 GRN-1004179 730000 Personal Mileage 670.00$ -$ -$
E Human Services Grants Health FND11007 CCN1060201 SC731388 PRG133095 GRN-1004179 730000 Printing 1,000.00 - -
E Human Services Grants Health FND11007 CCN1060201 SC731458 PRG133095 GRN-1004179 730000 Professional Services 50,830.00 - -
E Human Services Grants Health FND11007 CCN1060201 SC731941 PRG133095 GRN-1004179 730000 Training 50,000.00 - -
E Human Services Grants Health FND11007 CCN1060201 SC732018 PRG133095 GRN-1004179 730000 Travel and Conference 7,500.00 - -
Total Expenditures 110,000.00$ -$ -$
WHEREAS a FY 2024 budget amendment of $40,000 is recommended for Economic Development, Veterans Services Division to recongnize Amendment #1 to the FY2024 County Veteran Service Fund (CVFS) to reallocate funding between line items which causes no impact to the original
award (MR 2023-3382); and
WHEREAS a FY2024 budget amendment of $72,595 and FY2025 of $60,585 is recommended for the Sheriff's Office to recognize three amendments to the Comprehensive Opioid, Stimulant and Substance Abuse Program. Amendment #1 and Amendment #2 revised the budget to reflect
actual expenses for FY2023 and update costs for FY2024 and FY2025 to increase overtime and add a training/travel budget for the National Forum (Overdose Fatality Review). Amendment #3 moved funding from overtime and associated fringe benefits to travel and other budget DOJ
categories so more employees could attend training. The amendments cause no impact to the orginal grant award amount (MR #2022-355); and
WHEREAS a FY 2024 budget amendment is recommended for Health and Human Services to recognize Amendment #2 to the FY 2024 Emerging Threats Local Health Department Agreement. Amendment #2 provides increased funding of $2,080,502 for regional lab, sewer network and
COVID workforce development programs. The amendment is within 15% of the original award (M.R. #2023-3306) and increases the total funding from $6,438,627 to $8,519,129; and
2nd QTR Budget Amendments - Sched A and B Schedule B8
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 Second Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
R Human Services Grants Health FND11007 CCN1060201 RC631827 PRG133150 GRN-1004390 630000 Reimbursement General 5,000.00$ -$ -$
Total Revenues 5,000.00$ -$ -$
E Human Services Grants Health FND11007 CCN1060201 SC731458 PRG133150 GRN-1004390 730000 Professional Services 5,000.00$ - -
Total Expenditures 5,000.00$ -$ -$
R Human Service Grants Health FND11007 CCN1060102 RC615571 PRG133150 GRN-1004336 615000 State Operating Grants $ 5,000,000.00 $ - $ -
Total Revenues 5,000,000.00$ -$ -$
E Human Service Grants Health FND11007 CCN1060102 SC730373 PRG133150 GRN-1004336 730000 Contracted Services 5,000,000.00$ -$ -$
Total Expenditures 5,000,000.00$ -$ -$
Economic Development - 2024 Michigan Veteran's Affairs Agency County Training Reimbursement Program
R General Fund Veteran's Services FND10101 CCN1090401 RC631827 PRG132050 GRN-1003798 630000 Reimburesement General 4,225.00$ -$ -$
4,225.00$ -$ -$
E General Fund Veteran's Services FND10101 CCN1090401 SC732018 PRG132050 GRN-1003798 730000 Travel and Conference 4,225.00$ - -
4,225.00$ -$ -$
Indigent Defense - MIDC
E MIDC Indigent Defense Services FND20260 CCN1010702 SC773530 PRG121170 GRN-1004145 770000 Info Tech Operations 43,943.00$ 43,943.00$ 43,943.00$
E MIDC Indigent Defense Services FND20260 CCN1010702 SC778675 PRG121170 GRN-1004145 770000 Telephone Communications (43,943.00) (43,943.00) (43,943.00)
Total Expenditures -$ -$ -$
Parks and Recreation - FND50800
E Parks and Recreation
PR Planned Use of
Balance FND50800 CCN5060666 SC796500 PRG160666 796500 Budgeted Equity Adjustments $ (84,898.00)-$ -$
E Parks and Recreation PR Holly Oaks FND50800 CCN5060154 SC730814 PRG160700 730000 Grounds Maintenance 84,898.00 - -
Total Expenditures -$ -$ -$
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC702010 PRG160070 702000 Salaries Regular $ (41,499.17)-$ -$
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC712020 PRG160070 702000 Overtime (5,600.00)- -
E Parks and Recreation
PR Planned Use of
Balance FND50800 CCN5060178 SC702010 PRG160700 702000 Salaries Regular 41,499.17 - -
E Parks and Recreation PR Holly Oaks FND50800 CCN5060178 SC712020 PRG160700 702000 Overtime 5,600.00 - -
E Parks and Recreation PR Lyon Oaks FND50800 CCN5060174 SC702010 PRG160700 702000 Salaries Regular 0.30 - -
E Parks and Recreation PR Lyon Oaks FND50800 CCN5060174 SC722750 PRG160700 722000 Workers Compensation 0.15 - -
E Parks and Recreation PR Lyon Oaks FND50800 CCN5060174 SC722770 PRG160700 722000 Retirement 0.28 - -
E Parks and Recreation PR Lyon Oaks FND50800 CCN5060174 SC722790 PRG160700 722000 Social Security 0.44 - -
E Parks and Recreation PR Lyon Oaks FND50800 CCN5060174 SC722820 PRG160700 722000 Unemployment Insurance 0.13 - -
E Parks and Recreation PR Waterford Oaks FND50800 CCN5060164 SC722770 PRG160700 722000 Retirement (616.02)- -
E Parks and Recreation PR Waterford Oaks FND50800 CCN5060164 SC722780 PRG160700 722000 Hospitalization 1,450.99 - -
E Parks and Recreation PR Waterford Oaks FND50800 CCN5060164 SC722790 PRG160700 722000 Social Security 7,540.13 - -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722750 PRG160700 722000 Workers Compensation 33.20 - -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722760 PRG160700 722000 Group Life 96.01 - -
WHEREAS a FY 2024 budget amendment is recommended for Health and Human Services Health Division to accept grant funding of $5,000 for the FY 2024 Michigan Association for Local Public Health (MALPH) grant. M.R. #19006 authorizes Management and Budget to administratively
process grant agreements and grant amendments of $10,000 or less after review and approval by Management and Budget, Human Resources, Risk Management and Corporation Counsel when the grant does not require an associated interlocal agreement, there are no position changes
and the grantor does not require a separate resolution; and
WHEREAS a FY 2024 budget amendment of $5,000,000 is recommended for Health and Human Services Health Division to recognize an amendment to the FY 2024 Pontiac Integrated Urgent Care for a new draft contract for FY2024 due to unused funds awarded in FY2023. The amendment
is within 15% of the original award (M.R. 2023-3300); and
WHEREAS a FY2024 - FY 2026 Budget Amendment of $43,943 is recommended to correct the FY2024 Mandated Indigent Defense Commission Grant, correcting the spend categories for Info Tech Operations and Telephone Communications; and
WHEREAS a FY 2024 budget amendment is recommended for Parks and Recreation for Holly ORV restroom project. The amount above of $84,898 was assigned to be used toward a Holly ORV project as part of FY2023 revenue overage per contract with DNR; and
WHEREAS a FY 2024 budget amendment of $4,225 is recommended for the Veterans' Service Division to accept funding for the 2024 Michigan Veterans Affairs Agency's County Traning Reimbursement program (GRN-1003798). The funding is to ensure County counselors receive the
required Continued Education Units (CEU's) on veteran benefits, laws, and procedures. M.R. #19006 authorizes Management and Budget to administratively process grant agreements and grant amendments of $10,000 or less, after review and approval by Management and Budget, Human
Resources, Risk Management and Corporation Counsel when the grant does not require an associated interlocal agreement, there are no position changes and the grantor does not require a separate resolution; and
2nd QTR Budget Amendments - Sched A and B Schedule B9
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 Second Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722770 PRG160700 722000 Retirement 11,862.01 - -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722780 PRG160700 722000 Hospitalization 5,828.18 - -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722790 PRG160700 722000 Social Security 3,174.69 - -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722800 PRG160700 722000 Dental 389.63 - -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722810 PRG160700 722000 Disability 670.05 - -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722820 PRG160700 722000 Unemployment Insurance 24.90 - -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722850 PRG160700 722000 Optical 14.02 - -
E Parks and Recreation PR Lyon Oaks FND50800 CCN5060174 SC702010 PRG160070 702000 Salaries Regular (0.30)- -
E Parks and Recreation PR Lyon Oaks FND50800 CCN5060174 SC722750 PRG160070 722000 Workers Compensation (0.15)- -
E Parks and Recreation PR Lyon Oaks FND50800 CCN5060174 SC722770 PRG160070 722000 Retirement (0.28)- -
E Parks and Recreation PR Lyon Oaks FND50800 CCN5060174 SC722790 PRG160070 722000 Social Security (0.44)- -
E Parks and Recreation PR Lyon Oaks FND50800 CCN5060174 SC722820 PRG160070 722000 Unemployment Insurance (0.13)- -
E Parks and Recreation PR Waterford Oaks FND50800 CCN5060164 SC722770 PRG160070 722000 Retirement 616.02 - -
E Parks and Recreation PR Waterford Oaks FND50800 CCN5060164 SC722780 PRG160070 722000 Hospitalization (1,450.99)- -
E Parks and Recreation PR Waterford Oaks FND50800 CCN5060164 SC722790 PRG160070 722000 Social Security (7,540.13)- -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722750 PRG160070 722000 Workers Compensation (33.20)- -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722760 PRG160070 722000 Group Life (96.01)- -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722770 PRG160070 722000 Retirement (11,862.01)- -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722780 PRG160070 722000 Hospitalization (5,828.18)- -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722790 PRG160070 722000 Social Security (3,174.69)- -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722800 PRG160070 722000 Dental (389.63)- -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722810 PRG160070 722000 Disability (670.05)- -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722820 PRG160070 722000 Unemployment Insurance (24.90)- -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC722850 PRG160070 722000 Optical (14.02)- -
Total Expenditures -$ -$ -$
E Parks and Recreation PR Administration FND50800 CCN5060101 SC730072 PRG160000 730000 Advertising (75,000.00)$ -$ -$
E Parks and Recreation PR Administration FND50800 CCN5060101 SC731500 PRG160000 730000 Public Information 75,000.00 - -
Total Expenditures -$ -$ -$
Transit Fund - FND58800
R Oakland Transit Transit Services FND58800 CCN1090802 RC665882 PRG172155 665882 Planned Use of Balance (1,517,652.00)$ -$ -$
Total Revenues (1,517,652.00)$ -$ -$
E Oakland Transit Transit Services FND58800 CCN1090802 SC730072 PRG172155 730000 Advertising (10,000.00)$ (10,000.00)$ (10,000.00)$
E Oakland Transit Transit Services FND58800 CCN1090802 SC730373 PRG172155 730000 Contracted Services (50,594,612.00) (50,594,612.00) (50,594,612.00)
E Oakland Transit Transit Services FND58800 CCN1090802 SC731213 PRG172155 730000 Membership Dues (5,000.00) (5,000.00) (5,000.00)
E Oakland Transit Transit Services FND58800 CCN1090802 SC731346 PRG172155 730000 Personal Mileage (2,500.00) (2,500.00) (2,500.00)
E Oakland Transit Transit Services FND58800 CCN1090802 SC731388 PRG172155 730000 Printing (10,000.00) (10,000.00) (10,000.00)
E Oakland Transit Transit Services FND58800 CCN1090802 SC731458 PRG172155 730000 Professional Services (100,000.00) (100,000.00) (100,000.00)
E Oakland Transit Transit Services FND58800 CCN1090802 SC732018 PRG172155 730000 Travel and Conference (10,000.00) (10,000.00) (10,000.00)
E Oakland Transit Transit Services FND58800 CCN1090802 SC750399 PRG172155 750000 Office Supplies (10,000.00) (10,000.00) (10,000.00)
E Oakland Transit Transit Services FND58800 CCN1090802 SC750511 PRG172155 750000 Special Event Supplies (2,500.00) (2,500.00) (2,500.00)
E Oakland Transit Transit Services FND58800 CCN1090802 SC796500 PRG172155 796500 Budgeted Equity Adjustments 49,226,960.00 50,744,612.00 50,744,612.00
Total Expenditures (1,517,652.00)$ -$ -$
WHEREAS a FY 2024 - FY 2026 budget amendment is recommened for the Oakland County Transit Fund as the entries were duplicated during the FY 2024 - FY 2026 budget development; and
WHEREAS a FY 2024 budget amendment is recommended for Parks and Recreation for to correct Salary and Fringe Benefit budget that were put in the wrong program number; and
WHEREAS a FY 2024 budget amendment is recommended for Parks and Recreation reallocating the budgets between line items within Administration Division for Millage and Media Training activity; and
2nd QTR Budget Amendments - Sched A and B Schedule B10
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 Second Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
Water Resources Commissioner - Drain Equipment Fund - FND63900
R Drain Equipment Water Resources Commissi FND63900 CCN6010101 RC665882 PRG149760 665882 Planned Use of Balance 160,988.00$ -$ -$
Total Revenues 160,988.00$ -$ -$
E Drain Equipment Water Resources Commissi FND63900 CCN6010101 SC788001 PRG149760 FND66100 788001 Transfers Out 160,988.00$ -$ -$
Total Expenses 160,988.00$ -$ -$
R Motor Pool Support Services Lease VehFND66100 CCN1040210 RC695500 PRG184010 FND63900 695500 Transfer In 160,988.00$ -$ -$
R Motor Pool Support Services Lease VehFND66100 CCN1040210 RC665882 PRG184010 665882 Planned Use of Balance (160,988.00) - -
Total Revenues -$ -$ -$
WHEREAS a FY 2024 budget amendment for the Water Resources Commissioner Drain Equipment Fund #63900 is recommended in the amount of $160,988 due to three (3) vehicles and two (2) snowplows scheduled to be purchased in FY 2023 were acquired in FY 2024; and
American Rescue Plan Corrections
WRC Hardship Assistance Program
Reversal of Orignial Amendment for FND57010
R Water and Sewer Gener Water Resources FND57010 CCN6010101 RC695500 PRG133095 GRN-1004364 PRJ-13423 BFA21285 695500 Transfers In $ (300,000.00)-$ -$
Total Revenue (300,000.00)$ -$ -$
E Water and Sewer Gener Water Resources FND57010 CCN6010101 SC730373 PRG149999 GRN-1004364 PRJ-13423 730000 Contractual Services $ (300,000.00)-$ -$
Total Expenditures (300,000.00)$ -$ -$
Correcting Entry
R Water and Sewer Gener Water Resources FND57010 CCN6010101 RC695500 PRG149030 PRJ-13423 BFA21285 695500 Transfers In $ 300,000.00 -$ -$
Total Revenue 300,000.00$ -$ -$
E Water and Sewer Gener Water Resources FND57010 CCN6010101 SC730373 PRG149999 PRJ-13423 730000 Contractual Services $ 300,000.00 -$ -$
Total Expenditures 300,000.00$ -$ -$
Pontiac Integrated Urgent Care
Reversal of Original Amendment
R ARP Local Fiscal Recov Non-Departmental FND21285 CCN9010101 RC610313 PRG133095 GRN-1004358 610000 Federal Operating Grants (1,000,000.00)$ -$ -$
Total Revenue (1,000,000.00)$ -$ -$
E ARP Local Fiscal Recov Non-Departmental FND21285 CCN9010101 SC788001 PRG133095 GRN-1004358 BFA10100 788001 Transfer Out (1,000,000.00)$ -$ -$
Total Expenditures (1,000,000.00)$ -$ -$
R General Fund - Grants Health FND10101 CCN1060201 RC695500 PRG133095 GRN-1004358 BFA21285 695500 Transfer In (1,000,000.00)$ -$ -$
Total Revenue (1,000,000.00)$ -$ -$
E General Fund - Grants Health FND10101 CCN1060201 SC730373 PRG133095 GRN-1004358 730000 Contracted Services (1,000,000.00)$ -$ -$
Total Expenditures (1,000,000.00)$ -$ -$
correcting Entry
R ARP Local Fiscal Recov Non-Departmental FND21285 CCN9010101 RC610313 PRG133095 GRN-1004358 610000 Federal Operating Grants 1,000,000.00$ -$ -$
Total Revenue 1,000,000.00$ -$ -$
E ARP Local Fiscal Recov Non-Departmental FND21285 CCN1060201 SC731885 PRG133095 GRN-1004358 730000 Supportive Services 1,000,000.00$ -$ -$
Total Expenditures 1,000,000.00$ -$ -$
WHEREAS a FY 2024 budget amendment of $300,000 is recommended for the Water Resources Sewer Admin Fund (FND57010) correcting the schedule A on resolution 2023-3582 ARPA Local Fiscal Recovery Funds for WRC Hardship Assistance Program by removing the grant id
worktags and correcting the program; and
WHEREAS a FY 2024 budget amendment of $1,000,000 is recommended correcting the Schedule A entry for MR 2023-3531- ARPA-Local Fiscal Recovery Funds for the Pontiac Integrated Urgent Care as it was budgeted in error as a Transfer Out/Transfers In; and
2nd QTR Budget Amendments - Sched A and B Schedule B11
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 Second Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
Oakland Together Housing - NHD Shelter Capacity and Home Repairs
E ARP Local Fiscal Recov Neighborhood Housing FND21285 CCN1060701 SC731885 PRG133095 GRN-1003687 730000 Supportive Services (5,000,000.00)$ -$ -$
E ARP Local Fiscal Recov Neighborhood Housing FND21285 CCN1060701 SC731885 PRG133095 GRN-1003688 730000 Supportive Services (2,000,000.00) - -
E ARP Local Fiscal Recov Non-Department FND21285 CCN9010101 SC788001 PRG133095 GRN-1003687 BFA21400 788001 Transfer Out 5,000,000.00 - -
E ARP Local Fiscal Recov Non-Department FND21285 CCN9010101 SC788001 PRG133095 GRN-1003688 BFA21400 788001 Transfer Out 2,000,000.00 - -
Total Expenditures -$ -$ -$
R ARP Local Fiscal Recov Neighborhood Housing FND21400 CCN1060701 RC695500 PRG133095 GRN1003687 BFA21285 695500 Transfer In 5,000,000.00$ -$ -$
R ARP Local Fiscal Recov Neighborhood Housing FND21400 CCN1060701 RC695500 PRG133095 GRN-1003688 BFA21285 695500 Transfer In 2,000,000.00 - -
Total Revenues 7,000,000.00$ -$ -$
R ARP Local Fiscal Recov Neighborhood Housing FND21400 CCN1060701 SC731885 PRG133095 GRN-1003687 730000 Supportive Services 5,000,000.00$ -$ -$
R ARP Local Fiscal Recov Neighborhood Housing FND21400 CCN1060701 SC731885 PRG133095 GRN-1003688 730000 Supportive Services 2,000,000.00 - -
Total Expenditures 7,000,000.00$ -$ -$
Assessment of the Children's Village and Juvenile Justice System Assessment
Reverasl of Original Amendment
R ARPA Local Fiscal Reco Non-Departmental FND21285 CCN9010101 RC610313 PRG133095 GRN-1004360 610000 Federal Oprerating Grants $ (1,000,000.00)-$ -$
Total Revenues (1,000,000.00)$ -$ -$
E ARPA Local Fiscal Reco Non-Departmental FND21285 CCN9010101 SC788001 PRG133095 GRN-1004360 BFA10100 788001 Transfer Out $ (1,000,000.00)-$ -$
Total Expenditures (1,000,000.00)$ -$ -$
R General Fund Childrens Village FND10101 CCN1070701 RC695500 PRG133095 GRN-1004360 BFA21285 695500 Transfers In $ (1,000,000.00)-$ -$
Total Revenues (1,000,000.00)$ -$ -$
E General Fund Childrens Village FND10101 CCN1070701 SC730373 PRG133095 GRN-1004360 730000 Contracted Services $ (1,000,000.00)-$ -$
Total Expenditures (1,000,000.00)$ -$ -$
Correcting Entry
R ARPA Local Fiscal Reco Non-Departmental FND21285 CCN9010101 RC610313 PRG133095 GRN-1004360 610000 Federal Oprerating Grants $ 1,000,000.00 -$ -$
Total Revenues 1,000,000.00$ -$ -$
E ARPA Local Fiscal Reco Non-Departmental FND21285 CCN1070701 SC730373 PRG133095 GRN-1004360 730000 Contracted Services $ 1,000,000.00 $ - -$
Total Expenditures 1,000,000.00$ -$ -$
WHEREAS a FY 2024 budget amendment of $7,000,000 is being requested correcting the entries reflected in the Schedule A of the First Quarter Report, correcting the carryforward budgets for GRN-1003687 Oakland Together Housing-NHD Shelter Capacity and GRN-1003688 Oakland
Together Housing-NHD Home Repairs as the funding will be transferred to the Neighborhood Trust Fund (FND 21400); and
WHEREAS a FY 2024 budget amendment of $1,000,000 is recommended as the budgeted appropriation on the Schedule A for MR 2023-3549- ARPA-Local Fiscal Recovery Funds for an Assessment of the Children's Village and Juvenile Justice System Assessment was budgeted in error
as a Transfer In/Out; and
2nd QTR Budget Amendments - Sched A and B 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 Second Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
Backflow Prevention Project
Reversal of Original Amendment on FND 58510
R SOCSDS Sewage Dispo Water Resources FND58510 CCN6010101 RC695500 PRG133095 GRN-1004365 PRJ-17120 BFA21285 695500 Transfers In $ (200,000.00)-$ -$
Total Revenue (200,000.00)$ -$ -$
E SOCSDS Sewage Dispo Water Resources FND58510 CCN6010101 SC730373 PRG149667 GRN-1004365 PRJ-17120 730000 Contractual Services $ (200,000.00)-$ -$
Total Expenditures (200,000.00)$ -$ -$
correcting Entry
R SOCSDS Sewage Dispo Water Resources FND58510 CCN6010101 RC695500 PRG149030 PRJ-17120 BFA21285 695500 Transfers In $ 200,000.00 -$ -$
Total Revenue 200,000.00$ -$ -$
E SOCSDS Sewage Dispo Water Resources FND58510 CCN6010101 SC730373 PRG149667 PRJ-17120 730000 Contractual Services $ 200,000.00 -$ -$
Total Expenditures 200,000.00$ -$ -$
Reversal of Original Amendment for FNDS 57491 and 57291
R Royal Oak Township SewWater Resources FND57491 CCN6010101 RC695500 PRG133095 GRN-1004367 PRJ-17473 BFA21285 695500 Transfers In $ (700,000.00)-$ -$
R Royal Oak Township Wa Water Resources FND57291 CCN6010101 RC695500 PRG133095 GRN-1004366 PRJ-17474 BFA21285 695500 Transfers In (600,000.00)- -
Total Revenue (1,300,000.00)$ -$ -$
E Royal Oak Township SewWater Resources FND57491 CCN6010101 SC730373 PRG149662 GRN-1004367 PRJ-17473 730000 Contractual Services $ (700,000.00)-$ -$
E Royal Oak Township Wa Water Resources FND57291 CCN6010101 SC730373 PRG149662 GRN-1004366 PRJ-17474 730000 Contractual Services (600,000.00)- -
Total Expenditures (1,300,000.00)$ -$ -$
correcting Entry
R Royal Oak Township SewWater Resources FND57491 CCN6010101 RC695500 PRG149030 PRJ-17473 BFA21285 695500 Transfers In $ 700,000.00 -$ -$
R Royal Oak Township Wa Water Resources FND57291 CCN6010101 RC695500 PRG149030 PRJ-17474 BFA21285 695500 Transfers In 600,000.00 - -
Total Revenue 1,300,000.00$ -$ -$
E Royal Oak Township SewWater Resources FND57491 CCN6010101 SC730373 PRG149662 PRJ-17473 730000 Contractual Services $ 700,000.00 -$ -$
E Royal Oak Township Wa Water Resources FND57291 CCN6010101 SC730373 PRG149662 PRJ-17474 730000 Contractual Services 600,000.00 - -
Total Expenditures 1,300,000.00$ -$ -$
Michigan Saves Energy Efficiency and Weatherization Program
Reversal of original entry
R ARP Local Fiscal Recov Non-Departmental FND21285 CCN9010101 RC610313 PRG133095 GRN-1004359 610000 Federal Operating Grants (5,000,000.00)$ -$ -$
Total Revenue (5,000,000.00)$ -$ -$
E ARP Local Fiscal Recov Non-Departmental FND21285 CCN9010101 SC788001 PRG133095 GRN-1004359 BFA10100 788001 Transfer Out (5,000,000.00)$ -$ -$
Total Expenditures (5,000,000.00)$ -$ -$
R General Fund - Grants Health FND10101 CCN1060201 RC695500 PRG133095 GRN-1004359 BFA21285 695500 Transfer In (5,000,000.00)$ -$ -$
Total Revenue (5,000,000.00)$ -$ -$
E General Fund - Grants Health FND10101 CCN1060201 SC730373 PRG133095 GRN-1004359 730000 Contracted Services (5,000,000.00)$ -$ -$
Total Expenditures (5,000,000.00)$ -$ -$
Royal Oak Township Drinking Water & Sewer System
WHEREAS a FY 2024 budget amendment totaling $1,300,000 is recommended for the Water Resources Commissioner Royal Oak Township Sewer (FND 57491) and Royal Oak Township Water (FND 57291) correcting the schedule A on resolution 2023-3580 ARPA Local Fiscla Recovery
Funds for Royal Oak Township Drinking Water & Sewer System Improvement Projects by removing the grant id worktags and correcting programs; and
WHEREAS a FY 2024 budget amendment of $200,000 is recommended for the Water Resources Commissioner SOCSDS Sewage Disposal (FND 58510) correcting the schedule A on resolution 2023-3570 ARPA Local Fiscal Recovery Funds for Backflow Prevention Project by removing the
grant id worktags and correcting the program numbers; and
2nd QTR Budget Amendments - Sched A and B Schedule B13
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 Second Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
Correcting Entry
R ARP Local Fiscal Recov Non-Departmental FND21285 CCN9010101 RC610313 PRG133095 GRN-1004359 610000 Federal Operating Grants 5,000,000.00$ -$ -$
Total Revenue 5,000,000.00$ -$ -$
E ARP Local Fiscal Recov Non-Departmental FND21285 CCN1040101 SC731598 PRG133095 GRN-1004359 730000 Regranting Program 5,000,000.00$ -$ -$
Total Expenditures 5,000,000.00$ -$ -$
Main Street Oakland County Placemaking and Public Spaces Program
R ARP Local Fiscal Recov Non-Departmental FND21285 CCN9010101 RC610313 PRG133095 GRN-1004139 610000 Federal Operating Grants $ (5,000,000.00)-$ -$
Total Revenues (5,000,000.00)$ -$ -$
E ARP Local Fiscal Recov Planning and Local Busines FND21285 CCN1090205 SC788001 PRG133095 GRN-1004139 BFA10100 788001 Transfer Out $ (5,000,000.00)-$ -$
Total Expenditures (5,000,000.00)$ -$ -$
R General Fund - Grants Planning and Local Busines FND10101 CCN1090205 RC695500 PRG133095 GRN-1004139 BFA21285 695500 Transfers In $ (5,000,000.00)-$ -$
Total Revenue (5,000,000.00)$ -$ -$
E General Fund - Grants Planning and Local Busines FND10101 CCN1090205 SC731598 PRG133095 GRN-1004139 730000 Regranting Program $ (5,000,000.00)-$ -$
Total Expenditures (5,000,000.00)$ -$ -$
R ARP Local Fiscal Recov Non-Departmental FND21285 CCN9010101 RC610313 PRG133095 GRN-1004139 610000 Federal Operating Grants $ 5,000,000.00 -$ -$
Total Revenues 5,000,000.00$ -$ -$
E ARP Local Fiscal Recov Planning and Local Busines FND21285 CCN1090205 SC731895 PRG133095 GRN-1004139 730000 Regranting Program $ 5,000,000.00 -$ -$
Total Expenditures 5,000,000.00$ -$ -$
Oakland County Housing Trust Project
Reversal of Original Amendment
R Housing Trust Fund NHD Administration FND21400 CCN1060701 RC695500 PRG133095 GRN-1003663 BFA21285 695500 Transfer In (5,000,000.00)$ -$ -$
Total Revenue (5,000,000.00)$ -$ -$
E Housing Trust Fund NHD Administration FND21400 CCN1060701 SC730373 PRG133095 GRN-1003663 730000 Contracted Services (5,000,000.00)$ -$ -$
Total Expenditures (5,000,000.00)$ -$ -$
Correcting Entry
R Housing Trust Fund NHD Administration FND21400 CCN1060701 RC695500 PRG133095 BFA21285 695500 Transfer In 5,000,000.00$ -$ -$
Total Revenue 5,000,000.00$ -$ -$
E Housing Trust Fund NHD Administration FND21400 CCN1060701 SC730373 PRG133095 730000 Contracted Services 5,000,000.00$ -$ -$
Total Expenditures 5,000,000.00$ -$ -$
WHEREAS a FY 2024 budget amendment of $5,000,000 is recommended for the Housing Trust Fund (FND 21400) correcting the schedule A on resolution 2023-3511 ARPA Local Fiscal Recovery Funds of the Oakland County Housing Trust Project by removing the grant id worktags as the
activity will be tracked by pandemics program; and
WHEREAS a FY 2024 budget amendment of $5,000,000 is recommended as the budgeted appropriation on the Schedule A for MR 2023-3533- ARPA-Local Fiscal Recovery Funds for Michigan Saves Energy Efficiency and Weatherizatiion Program was budgeteed in error as Transfers
In/Transfers Out; and
Reversal of orignal budget amendment
Correcting Entry
WHEREAS a FY 2024 budget amendment of $5,000,000 is being requested correcting the entries reflected in the Schedule A of resolution 2023-3615 ARPA - Main Street Oakland County Placemaking and Public Spaces Program as it was budgeted in error as a Transfers In/Out; and
2nd QTR Budget Amendments - Sched A and B Schedule B14
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 Second Quarter Financial Forecast and Budget Amendments
Schedule "B" DETAIL
Additonal Oakland Together Housing Security Initiatives
Reversal of Original Amendment on FND 21400
R Housing Trust Fund Neighborhood Housing Dev FND21400 CCN1060701 RC695500 PRG133095 GRN-1003687 BFA21285 695500 Transfers In $ (2,000,000.00)-$ -$
R Housing Trust Fund Neighborhood Housing Dev FND21400 CCN1060701 RC695500 PRG133095 GRN-1003663 BFA21285 695500 Transfers In (8,000,000.00)- -
Total Revenue (10,000,000.00)$ -$ -$
E Housing Trust Fund Neighborhood Housing Dev FND21400 CCN1060701 SC731885 PRG133095 GRN-1003687 730000 Support Services $ (2,000,000.00)-$ -$
E Housing Trust Fund Neighborhood Housing Dev FND21400 CCN1060701 SC731885 PRG133095 GRN-1003663 730000 Support Services (8,000,000.00)- -
Total Expenditures (10,000,000.00)$ -$ -$
Correcting Entry
R Housing Trust Fund Neighborhood Housing Dev FND21400 CCN1060701 RC695500 PRG133095 BFA21285 695500 Transfers In $ 2,000,000.00 -$ -$
R Housing Trust Fund Neighborhood Housing Dev FND21400 CCN1060701 RC695500 PRG133095 BFA21285 695500 Transfers In 8,000,000.00 - -
Total Revenue 10,000,000.00$ -$ -$
E Housing Trust Fund Neighborhood Housing Dev FND21400 CCN1060701 SC731885 PRG133095 730000 Support Services $ 2,000,000.00 -$ -$
E Housing Trust Fund Neighborhood Housing Dev FND21400 CCN1060701 SC731885 PRG133095 730000 Support Services 8,000,000.00 - -
Total Expenditures 10,000,000.00$ -$ -$
County Operations Related to the Response of the Public Health Emergency and Negative Economic Impacts
R General Fund Health FND10100 CCN9010101 RC665882 PRG196030 665882 Planned Use of Balance (17,000,000.00)$ -$ -$
Total Revenue (17,000,000.00)$ -$ -$
E General Fund Health FND10100 CCN1060201 SC702010 PRG133095 702000 Salaries Regular (11,334,555.00)$ -$ -$
E General Fund Health FND10100 CCN1060201 SC722900 PRG133095 722000 Fringe Benefit Adjustment (5,665,445.00) - -
Total Expenditures (17,000,000.00)$ -$ -$
WHEREAS a FY 2024 budget amendment of $10,000,000 is recommended for the Housing Trust Fund (FND 21400) correcting the schedule A on resolution 2023-3612 ARPA Local Fiscal Recovery for Additonal Oakland Together Housing Security Initiatives by removing the grant id worktags
as the activity will be tracked by pandemics program; and
WHEREAS a FY 2024 budget amendment is recommended correcting the entry from MR 23145-Fiscal Services - Appropriating American Rescue Plan Act – Local Fiscal Recovery Funds to Reimburse County Operations Related to the Response of the Public Health Emergency and Negative
Economic Impacts as the funding reimburses payroll costs for Department of Health and Human Services; and
2nd QTR Budget Amendments - Sched A and B Schedule B15
I I I
I
I
I
COUNTY OF OAKLAND
FY 2024 SECOND 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$ 308,764,107.11$ 1,118,200.00 0.36%
Federal Grants 2,339,451.00 2,540,899.00 2,696,405.00 155,506.00 6.12%
State Grants 22,861,073.00 24,609,742.00 24,668,371.00 58,629.00 0.24%
Other Intergovernmental Revenue 55,014,534.00 55,014,534.00 54,982,884.00 (31,650.00) -0.06%
Charges for Services 125,967,216.00 128,078,524.00 124,806,105.63 (3,272,418.37) -2.56%
Indirect Cost Recovery 9,150,000.00 9,150,000.00 9,150,000.00 - 0.00%
Contributions 0.00 0.00 11,757.00 11,757.00
Investment Income 3,304,700.00 3,304,700.00 3,504,700.00 200,000.00 6.05%
Other Revenues 16,500.00 16,500.00 52,561.00 36,061.00 218.55%
Transfers In 44,327,977.00 56,442,273.00 56,765,273.00 323,000.00 0.57%
SUB-TOTAL GENERAL FUND/GENERAL PURPOSE 570,627,358.42$ 586,803,079.42$ 585,402,163.74$ (1,400,915.37)$ -0.24%
TOTAL GF/GP FUNDS 570,627,358.42$ 586,803,079.42$ 585,402,163.74$ (1,400,915.37)$ -0.24%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court 53,445,806.77$ 55,436,730.82$ 47,475,730.82 7,961,000.00$ 14.36%
52nd District Court 20,306,782.89 20,409,762.37 20,405,962.37 3,800.00 0.02%
Probate Court 8,325,470.27 8,423,428.27 8,037,928.27 385,500.00 4.58%
TOTAL ADMIN. OF JUSTICE 82,078,059.93$ 84,269,921.46$ 75,919,621.46$ 8,350,300.00$ 9.91%
LAW ENFORCEMENT
Prosecuting Attorney 27,732,067.90 28,449,925.07 26,889,925.07 1,560,000.00 5.48%
Sheriff 198,697,219.56 205,339,366.21 208,631,866.21 (3,292,500.00) -1.60%
TOTAL LAW ENFORCEMENT 226,429,287.46$ 233,789,291.28$ 235,521,791.28$ (1,732,500.00)$ -0.74%
GENERAL GOVERNMENT
Clerk/Register of Deeds 11,550,021.83 12,104,967.03 11,245,889.04 859,077.99 7.10%
Treasurer 9,010,040.85 9,348,189.85 8,207,789.85 1,140,400.00 12.20%
Board of Commissioners 5,737,575.22 6,335,952.66 6,102,111.66 233,841.00 3.69%
Water Resources Commissioner 8,479,591.25 8,575,674.25 8,664,841.25 (89,167.00) -1.04%
TOTAL GENERAL GOVERNMENT 34,777,229.15$ 36,364,783.79$ 34,220,631.80$ 2,144,151.99$ 5.90%
COUNTY EXECUTIVE
County Executive Admn.11,105,276.79$ 11,745,124.79$ 11,005,524.79$ 739,600.00$ 6.30%
Management and Budget 24,954,180.43 25,593,566.57 24,291,566.57 1,302,000.00 5.09%
Facilities Management 5,378,088.63 5,613,208.33 5,328,208.33 285,000.00 5.08%
Human Resources 6,276,367.26 6,538,273.51 6,371,453.51 166,820.00 2.55%
Health and Human Services 63,651,702.56 73,193,173.46 65,735,382.50 7,457,790.96 10.19%
Public Services 46,056,237.79 48,324,024.94 46,208,030.94 2,115,994.00 4.38%
Economic Development 11,303,843.84 20,091,639.84 16,301,639.84 3,790,000.00 18.86%
Emergency Management & Homeland Security 3,253,620.90 3,316,203.90 2,573,203.90 743,000.00 22.41%
Public Communication 3,962,765.23 4,543,014.27 4,410,572.27 132,442.00 2.92%
TOTAL COUNTY EXECUTIVE 175,942,083.43$ 198,958,229.61$ 182,225,582.65$ 16,732,646.96$ 8.41%
TOTAL DEPARTMENTS 519,226,659.97$ 553,382,226.14$ 527,887,627.19$ 25,494,598.95$ 4.61%
Non-Departmental 56,669,458.45$ 61,592,729.45$ 71,967,229.45 (10,374,500.00)
TOTAL GOVERNMENTAL EXPENDITURES 575,896,118.42$ 614,974,955.59$ 599,854,856.64$ 15,120,098.95$ 2.46%
General Fund/General Purpose
Favorable/(Unfavorable) - Budget Perspective 13,719,183.58$ 13,719,183.58$
PLANNED USE OF FUND BALANCE 5,268,760.00$ 28,171,876.17$ 28,171,876.17$ -$
Impact on Fund Balance (Includes Encumbrances)(14,452,692.59)$
16
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 due to timing of collection.
Other Taxes - Delinquent Tax - Prior Years 125,000.00 125,000.00 125,000.00 - 0.00%
Marijuana Tax
1,100,000.00 1,100,000.00 2,186,200.00 1,086,200.00 98.75%Fav. Due to distribution of sales and excise taxes collected from
marihuana sales.
Treasurer Payment in Lieu of Taxes 600,000.00 600,000.00 632,000.00 32,000.00 5.33%Fav. due to tax payments from the state on DNR land.
Trailer Tax 95,000.00 95,000.00 95,000.00 - 0.00%At budget due to timing of collection.
Total Taxes 307,645,907.11$ 307,645,907.11$ 308,764,107.11$ 1,118,200.00$ 0.36%
FEDERAL GRANTS (610000-610999)
Sheriff - Sheriff's Office -$ -$ -$ -$ 0.00%
Sheriff - Emergency Response and Prep - - - - 0.00%
Sheriff - Patrol - 154,476.00 304,476.00 150,000.00 97.10%Fav. Marine Safety Grant that is budgeted in Other Inter-governmental
revenues.
Sheriff - Investigative/Forensic Services 132,300.00 132,300.00 132,300.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 630,004.00 630,004.00 - 0.00%At budget
Children's Village 300,000.00 300,000.00 305,506.00 5,506.00 1.84%Unfav. School Lunch program ($100,000) serving less due to decline in
population of residents. Partially offset by $105,506 due grant funding
on food accessibility and supply chain issues.
Non-Department - - - - 0.00%
Total Federal Grants 2,339,451.00$ 2,540,899.00$ 2,696,405.00$ 155,506.00$ 6.12%
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 -$ -$ 49,369.00$ 49,369.00$ 100.00%Fav. Marine Safety Grant that is budget in Other Inter-governmental
revenues.
State Match Foster Care - - -$ - 0.00%
Prosecuting Attorney - - - - 0.00%
Clerk - County Clerk - 23,000.00 25,531.00 2,531.00 11.00%Fav. due to SCAO (State Court Administrative Office) Grant funding
College Intern Positions.
Economic Development - - - - 0.00%
Health Division 7,081,450.00 8,807,119.00 8,807,119.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$ 24,609,742.00$ 24,668,371.00$ 58,629.00$ 0.24%
OTHER INTER-GOVERNMENTAL REVENUES (620000 - 626999)
Non-Departmental 52,750,000.00$ 52,750,000.00$ 52,850,000.00$ 100,000.00$ 0.19%Fav. Due to State Court Fund Disb PA 189 caseload distribution on
operational expenditures on trial courts.
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 96,900.00 92,400.00 2053.33%Favorability primarily attributed to $92,400 in Attorney Fee - Appellate
which is partially offset by unfavourability in the revenue category
reimbursement general.
District Court - - - - 0.00%
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2024 SECOND QUARTER REPORT
17
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 SECOND QUARTER REPORT
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.
Probate Court - - - - 0.00%
Sheriff 255,050.00 255,050.00 32,800.00 (222,250.00) -87.14%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 ($168,600) with Actuals
in Federal and State 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,982,884.00$ (31,650.00)$ -0.06%
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 615,900.00 (50,800.00) -7.62%Unfavorable primarily due to ($125,000) in Reimbursement General
due to budget allocation. Offset by favorable revenue category in
attorney fee appellate. Also unfavorable ($50,000) in Civil Mediation
Payments due to law changes resulting in less cases going to
mediation. Partially offset by favorability in Costs of $107,700 due in
part to policy change to no longer assign court costs; previously
assigned court costs are still being collected. Also favorable $31,400 in
Jury Fees due to increased activity.
Circuit Court - Family Division 187,500.00 187,500.00 236,300.00 48,800.00 26.03%Favorability primarily due to Govt Benefit Board and Care $12,700 and
Board and Care $17,100 due to Child Care Fund chargebacks. Also
favorable 11,500 in Adoptive Info Request Fee due to increased
activity. Also favorable $6,000 in Costs due to RMB continuing to
collect.
District Court - Division I (Novi)3,039,753.00 3,039,753.00 2,028,853.00 (1,010,900.00) -33.26%Unfavorability primarily due to Ordinance Fines and Costs ($474,000);
Probation Fees ($141,000); and State Law Costs ($136,000) attributed
to changes in legislation.
District Court - Division II (Clarkston)1,616,941.00 1,616,941.00 1,133,641.00 (483,300.00) -29.89%Unfavorability primarily due to State Law Costs ($277,000) and
Ordinance Fines and Costs ($102,500) attributed to changes in
legislation. Partially offset by favorability of $18,700 in Probation Fees
due to increased activity.
District Court - Division III (Rochester Hills)3,500,015.00 3,500,015.00 2,430,215.00 (1,069,800.00) -30.57%Unfavorability primarily from Ordinance Fines and Costs ($601,100),
Probation Fees ($223,300) and State Law Costs ($99,100) due to
changes in legislation.
District Court - Division IV (Troy)1,589,403.00 1,589,403.00 1,105,003.00 (484,400.00) -30.48%Unfavorability primarily due Ordinance Fines and Costs ($170,700)
attributed to the reduction in caseload from marijuana legalization and
other policy changes. Also unfav. Probation Fees ($38,900) as well as
State Law Costs ($62,000) attributed to changes in legislation. Also
unfavorable ($42,500 in Forfeiture of Bonds, ($35,000) in Drunk Driving
Caseflow DDCAF and ($26,000) in Garnishment Fees due to lower
activity.
Probate Court - Estates and Mental Health 532,650.00 532,650.00 738,850.00 206,200.00 38.71%Favorable primarily due to Gross Estate Fees $116,300 due to a
increase in fees paid. Also fav. Certified Copies $43,700 and
Photostats $21,200 due to an increase in activity.
Total Administration of Justice 11,132,962.00$ 11,132,962.00$ 8,289,762.00$ (2,843,200.00)$ -25.54%18
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 SECOND QUARTER REPORT
Law Enforcement
Prosecuting Attorney 833,621.00$ 833,621.00$ 778,621.00 (55,000.00) -6.60%Unfav. Crime Victim Rights ($40,000) due to vacant position offset in
Personnel, Reimb General ($6,500) from less activity at the 46th
District Court, Educational Training ($6,100) due to no reimbursement
from the Police Academy, Extradition Recovery Fee ($2,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 218,500.00 (25,000.00) -10.27%Unfav. Fingerprints ($50,000) and Registration Fees ($10,000) due to
reduced activity; partially offset by fav. FOIA Fees $25,000 and
Photostats $10,000 due to increased activity.
Sheriff - Corrective Services 2,381,342.00 2,381,342.00 2,401,342.00 20,000.00 0.84%Fav. Commissions Contracts $150,000 due to increased usage of the
Commissary; partially offset by unfav. Inmate Board and Care
($110,000) due to lower collection rates and Diverted Felon ($20,000)
due to the number of inmates that meet reimbursement criteria.
Sheriff - Corrective Services Satellites 961,099.00 961,099.00 931,099.00 (30,000.00) -3.12%Unfav. Civil Action Service Fees ($45,000) due 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
$20,000 due to higher than budgeted court security services.
Sheriff - Emergency Response and Prep - - 1,500.00 1,500.00 100.00%Fav. due to higher activity.
Sheriff - Patrol Services 65,992,466.00 67,473,128.00 67,673,128.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) and 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,056,416.00 491,416.00 (565,000.00) -53.48%Unfav. primarily due to Drug Testing ($600,000) as the Results testing
program has not returned to full capacity since the pandemic and is
experiencing a lower number of clients and partially offset by favorable
operating expenditures. Also fav. Reimb Salaries $45,000 due to task
force reimbursement.
Total Law Enforcement 74,302,806.00$ 75,824,884.00$ 75,371,684.00$ (453,200.00)$ -0.60%
General Government
Clerk - Administration -$ -$ - -$ 0.00%
Clerk - County Clerk 2,183,100.00$ 2,183,100.00$ 2,605,040.00 421,940.00$ 19.33%Fav. Photostats $150,000, Certified Copies $140,000, Forfeiture of
Surety Bonds $87,125 and Forfeiture of Bonds $40,000 due to
increased activity.
Clerk - Elections 196,900.00 196,900.00 277,870.00 80,970.00 41.12%Fav. due to Reimb General $100,0000 as charging CVT's for election
services. Partially offset by Unfav. Passport Fees ($39,000) due to less
activity.
Clerk - Register of Deeds & Micrographics 13,548,500.00 13,548,500.00 13,502,500.00 (46,000.00) -0.34%Unfav. Mortgages ($100,000) due to interest rate rising and low
housing inventory. Partially offset by Fav. due to Enhanced Access
Fees $50,000 and Photostats $5,000 due to increase in activity.
Treasurer 3,466,100.00 3,466,100.00 3,187,323.63 (278,776.37) -8.04%Unfav. Civil Action Service Fees ($142,300), Maintenance Contracts
($50,000), Foreclosure Notification Fee ($37,450) and Deeds
($39,500). Partially offset by Fav. Recording Fee Redemption Certi
$10,000 due to increased activity and collection of fee. Also Fav. FOIA
$7,090 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
decreased demand.
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 SECOND QUARTER REPORT
Water Resources Commissioner 3,854,519.00 3,854,519.00 3,978,819.00 124,300.00 3.22%Fav - Soil Erosion Fees $90,000 increase in building activity/permits
due to improvement in the housing market, working with contractors on
soil erosion sediment control standards for stormwater manual and
working with consultants on legislation pertaining to water affordability
and stormwater utility issues. Fav - Reimbursement General $34,000
due to working with contractor on policies pertaining to reorganization
issues.
Total General Government 23,252,819.00$ 23,252,819.00$ 23,553,952.63$ 301,133.63$ 1.30%
County Executive
County Exec - Corp Counsel - - - - 0.00%
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 320,000.00 (395,690.00) -55.29%Lower than expected purchasing/rebates
Facilities Management - Support Services 396,000.00 396,000.00 396,000.00 - 0.00%At budget
Human Resources - - - 0.00%
HHS - Administration - - 4,200.00 4,200.00 100.00%Favorable due to Psych Testing and Evaluation fees being more than
anticipated.
HHS - Health Division 4,177,916.00 4,181,246.00 4,181,246.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.
Board and Care ($110,000) related to fewer residents on campus. Also,
Unfav. Child Care State Aid ($85,774) due to in-county kids.
Public Services - Medical Examiner 469,850.00 1,055,750.00 843,915.00 (211,835.00) -20.06%Unfav. Autopsies (276735) 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,044,576.00 (677,438.00) -39.34%Unfav. Sale of Licenses ($687,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 402,816.00 86,108.00 27.19%Michigan Career Quest revenue received.
Economic Development - Veterans - - - - 0.00%
Total County Executive 16,360,629.00$ 16,949,859.00$ 16,590,707.00$ (359,152.00)$ -2.12%At budget
Non-Departmental
Non-Dept - Charges for Services 918,000.00$ 918,000.00$ 1,000,000.00 82,000.00 8.93%Fav. Primarily due to Commission Public Telephone $100,000 due to
increased use of telephone and electronic mail services used at the
county jail and Children's Village.
Total Non-Departmental 918,000.00$ 918,000.00$ 1,000,000.00$ 82,000.00$ 8.93%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 SECOND QUARTER REPORT
Total Charges for Services 125,967,216.00$ 128,078,524.00$ 124,806,105.63$ (3,272,418.37)$ -2.56%
INDIRECT COST RECOVERY (640100)9,150,000.00$ 9,150,000.00$ 9,150,000.00 -$ 0.00%At budget
CONTRIBUTIONS (650000)
Board of Commissioners-Contributions - - - - 0.00%
Sheriff Patrol Services Donations - - 5,000.00 5,000.00 100.00%Bill and Shannon Johns donation to K9 Unit in memory of Bill Loken
Health Division - - 0.00%
Department of Public Communications - Sponsorships - - - - 0.00%
Economic Development & Comm Affairs - Contributions - - 6,757.00 6,757.00 100.00%Donation received
Non-Departmental - - 0.00%
Economic Development - Contributions - - - - 0.00%
Water Resources Commissioner - - - - 0.00%
Total Contributions Revenues -$ -$ 11,757.00$ 11,757.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 500,000.00 200,000.00 66.67%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,504,700.00$ 200,000.00$ 6.05%
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 - - - - 0.00%
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 2,000.00 (10,000.00) -83.33%Unfav. due to less County Auction activity.
Sheriff - Emergency Communications Operations - - - - 0.00%
Sheriff - Investigative/Forensic Svc 3,000.00 3,000.00 11,500.00 8,500.00 283.33%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%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 SECOND QUARTER REPORT
Facilities Management - Support Services 1,500.00 1,500.00 1,500.00 - 0.00%
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 - - 37,161.00 37,161.00 100.00%Fav. Refund Prior Year Revenue $35,856.24 mainly attributed to Board
and Care revenue received after year-end for Q2 forecast. To correct
prior year accrual/reversal.
Economic Development - Veterans - - - - 0.00%
Non Departmental - Donations - - - - 0.00%
Non-Dept - Sundry - - - - 0.00%
Total Other Revenues 16,500.00$ 16,500.00$ 52,561.00 36,061.00$ 218.55%
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 - 38,929.00 361,929.00 323,000.00 829.72%Fav. due to ATPA Grant and offset in unfavorable Operating
Expenditure 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,603,344.00 24,603,344.00 - 0.00%At budget
Total Transfers In Revenues 44,327,977.00$ 56,442,273.00$ 56,765,273.00 323,000.00$ 0.57%
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$ 8,343,760.00$ 8,343,760.00 - 0.00%
Total Planned Use of Fund Balance 5,268,760.00$ 28,171,876.17$ 28,171,876.17$ -$ 0.00%
TOTAL GEN. FUND / GEN. PURPOSE REVENUE 575,896,118.42$ 614,974,955.59$ 613,574,039.91$ (1,400,915.37)$ -0.23%
22
Adopted Amended Forecast Favorability/UNF Percentage
$53,445,806.77 $55,436,730.82 $47,475,730.82 $7,961,000.00 14.36%
$29,596,104.34 $29,596,104.34 $27,710,004.34 $1,886,100.00 6.37%
$11,495,687.00 $12,921,704.05 $6,247,904.05 $6,673,800.00 51.65%
$5,548,033.43 $6,095,526.43 $6,694,426.43 ($598,900.00)-9.83%
$6,805,982.00 $6,823,396.00 $6,823,396.00 $0.00 0.00%
Circuit Court
2024 Q2 Forecast
Total
Summary of Projections
Transfers to be completed by year-end.
Court Business division unfavorability primarily driven by ($15,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.
Also favorable $4,100 in Computer Supplies and $2,600 in Software Support Maintenance due to less than
anticipated usage. 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 ($168,700) due to payments
at MIDC rates; offset by 50% reimbursement from State Appellate Defender Office/Michigan Appellate Assigned
Counsel System (SADO/MAACS). Also unfavorable ($70,200) in Computer Research Service due to pricing
structure change, with a one-year extention in place. This is currently under negotiation. Partially offset by
favorability in Attorney Fees Mediators $100,100 due to law change resulting in less cases going to mediation. Also
partially offset by favorability of $38,900 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 ($84,600) based on budget
allocation. Partially offset by favorability in Telephone Communications of $6,100 due to less than anticipated use.
Court Business division unfavorable primarily due to Info Tech Operations ($85,900) based on budget allocation.
Partially offset by favorability of $3,500 in Info Tech Managed Print Servcies due to increased usage of electronic
formats.
Civil/Criminal division unfavorable primarily due to Info Tech Operations ($157,800) and ($30,800) in Equipment
Rental due to budget allocation. Also unfavorable ($20,700) in Telephone Communications attributed to the rollout
of the VOIP system. In addition ($10,300) 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 $4,799,500 and $748,300 in Private Institutions
Residential due to policy changes to lower placement as costs have significantly increased. Also favorable Defense
Atty Fees due to timing, as actuals activity is delayed until case disposition.
Family division unfavorability due to ($118,200) in Info Tech Operations based on budget allocation. Also
unfavorable ($48,700) in Equipment Rental primarily for Justice VA Solutions (JAVS). Also unfavorable ($46,400) in
Telephone Communications attributed to increased costs incurred for compliance with the Extreme Risk Protection
Act. Partially offset by favorability of $6,600 in Info Tech Managed Print Svcs due to increased use of electronic
formats.
Personnel
Judicial Administration division primarily favorable $78,300 for Special Projects; these funds are used as needed
by the Court for technology improvements. Also favorable $35,700 in Travel and Conference, being used to offset
the other divisions. Also favorable in Office Supplies $29,000 based on need. Partially offset by unfavorability of
($52,500) in Library Continuations due to increased inflationary costs.
Judicial Administration and Business divisions are at budget.
Operating
Transfers
Civil/Criminal division favorable due to vacancy and new hires.
Family division favorable due to underfilled and vacant positions.
23
Adopted Amended Forecast Favorability/UNF Percentage
$20,306,782.89 $20,409,762.37 $20,405,962.37 $3,800.00 0.02%
$15,723,171.15 $15,910,359.15 $15,935,459.15 ($25,100.00) -0.16%
$2,544,416.00 $2,373,562.48 $2,307,862.48 $65,700.00 2.77%
$2,039,195.74 $2,125,840.74 $2,162,640.74 ($36,800.00)-1.73%
$0.00 $0.00 $0.00 $0.00 0.00%
District Court
2024 Q2 Forecast
Total
Summary of Projections
Personnel
Admin unfavorable ($25,100) 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 favorability primarily attributed to Contracted Services $330,000 for additional IT Support to transition to an
electronic filing system (M.R. 2023-3298), offsetting unfavorability in Professional Services for Clarkston, Rochester
Hills and Troy.
Novi unfavorable primarily due to ($93,700) in in Furniture and Fixtures due to timing of payment and budget
allocation.
Rochester Hills unfavorable primarily due to Professional Services ($31,100) for the IT liason contractor position
assigned to this court, which is offset in Admin division's Contracted Services favorability. Also unfavorable
Interpreter Fees for ($13,900) based on increased demand. Partially offset by favorability of $9,600 in Office
Supplies and $7,100 in Software Support Maintenance due to less than antcipated usage. Also partially offset by
favorability in Bank Charges of $5,600 due lower activity from increased cash usage.
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 ($35,000) due to budget allocation and usage.
Conversion to efiling and video courtrooms has required additional equipment to be purchased. Partially offset by
favorability in Telephone Communications of $15,800 due to less than anticipated usage.
Internal
Troy unfavorable primarily due to Info Tech Operations ($22,500) due to efiling, with new equipment having to be
purchased. Additionally unfavorable in Info Tech Managed Print Svcs ($4,300) due to landlord tenant mandated
changes resulting in entirely new packets being required. Partiall offset by favorability in Telephone Communications
20,600 due to decreased usage. Usage decrease attributed email addresses now being available to all staff, leading
to less phone usage.
Troy unfavorable primarily due to Info Tech Operations ($39,200) due to budgeted allocation and usage; eFiling
implementation has required the purchase of extra monitors, laptop and scanners for the public. Also unfavorable
($10,200) in Equipment Rental for mail machine maintenance and maintenance of the DCR system.
Novi, Clarkston, Rochester Hills and Troy are projected at budget.
Clarkston unfavorability primarily due to Professional Services ($70,700) due to budget allocation for IT Support;
offset in Admin division's Contractual Services favorability. Also unfavorable ($68,100) in Court Reporter Servcies
due to increased activity.
Rochester Hills unfavorable primarily due to Info Tech Operations ($22,500) due to efiling, with new equipment
having to be purchased. Additionally unfavorable in Info Tech Managed Print Svcs ($4,300) due to landlord tenant
mandated changes resulting in entirely new packets being required. Partiall offset by favorability in Telephone
Communications 20,600 due to decreased usage. Usage decrease attributed email addresses now being available
to all staff, leading to less phone usage.
24
Adopted Amended Forecast Favorability/UNF Percentage
$8,325,470.27 $8,423,428.27 $8,037,928.27 $385,500.00 4.58%
$5,909,363.19 $5,909,363.19 $5,577,663.19 $331,700.00 5.61%
$1,255,135.00 $1,288,268.00 $1,216,968.00 $71,300.00 5.53%
$1,160,972.08 $1,225,797.08 $1,243,297.08 ($17,500.00)-1.43%
$0.00 $0.00 $0.00 $0.00 0.00%
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 $6,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. Also favorable $52,800 in Expendible Equipment based on
anticipated usage. Partially offset by Fees Guardian Ad Litem ($73,400), a mandated expense; however usage is
increasing primarily due to an aging population and long-term health impacts from the COVID epidemic. Also
partially offset by unfavorability of ($11,600) in Visiting Judges, a mandated expenses which has risen exponentially
due to increase in PPO filing and bench warrants.
Admin is at budget.
Mental Health & Estates is unfavorable primarily due to Equipment Rental ($27,600) due to allocation of budget for
JAVS equipment. 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 $331,700 due vacancy and turnover.
Probate Court
2024 Q2 Forecast
Total
Summary of Projections
25
Adopted Amended Forecast Favorability/UNF Percentage
$27,732,067.90 $28,449,925.07 $26,889,925.07 $1,560,000.00 5.48%
$23,108,424.70 $23,081,181.70 $22,006,181.70 $1,075,000.00 4.66%
$661,808.00 $1,222,178.17 $995,178.17 $227,000.00 18.57%
$2,664,041.20 $2,877,955.20 $3,019,955.20 ($142,000.00)-4.93%
$1,297,794.00 $1,268,610.00 $868,610.00 $400,000.00 31.53%
Personnel
Overtime unfavorable ($210,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 Q2 Forecast
Total
Summary of Projections
Transfers
Transfers Out favorability is due to less Cooperative Reimbursement Program grant match obligation than
budgeted.
Favorability of $350,000 is due to variances in multiple spending categories such as Contracted Services, Expert
Witness Fee and Mileage, Filing Fees, Library Continuations, Personal Mileage, Professional Services and Printing
due to less usage and Direct Client Services for direct victim needs.
Forecasted unfavorability of ($230,000) is due to Info Tech Operations. This is offset by favorability
predominantly in Info Tech Managed Print Svcs and Motor Pool Fuel Charges due to less than anticipated use.
Favorability of $85,000 in Info Tech Managed Print Services is due to remote work and paper reduction efforts as
well as Motor Pool Fuel Charges and Telephone Communications due to less than anticipated use. This offsets a
portion of the unfavorability.
Internal
Projected favorability is partially offset by unfavorability of ($130,000) which includes variances in several spending
categories such as Travel and Conference, Extradition Expense and Court Transcripts due to usage.
26
Adopted Amended Forecast Favorability/UNF Percentage
$198,697,219.56 $205,339,366.21 $208,631,866.21 ($3,292,500.00) -1.60%
$156,314,247.97 $157,812,530.97 $162,352,530.97 ($4,540,000.00) -2.88%
$14,497,858.00 $18,402,880.65 $18,364,380.65 $38,500.00 0.21%
$26,897,585.59 $27,510,302.59 $27,001,302.59 $509,000.00 1.85%
$987,528.00 $1,613,652.00 $913,652.00 $700,000.00 43.38%
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. Holiday Overtime is also unfavorable with the addition of holidays and no offsetting increase to the budget.
Operating
Sheriff's Office
2024 Q2 Forecast
Total
Summary of Projections
Transfers
Transfers Out are projected to be favorable due to timing of Motor Pool Transfers for law enforcement contracts
based on vehicle availability as well as 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 Bedding and Linen, Communications, Custodial Supplies, Dry Goods and Clothing,
Expendable Equipment, Equipment Maintenance, Evidence Fund NET, Extradition Expense, Laundry and Cleaning,
Other Expendable Equipment, Office Supplies, Printing, Prisoner Housing-Outside, Professional Services, Software
Support Maintenance and Supportive Services.
Forecasted favorability totaling $855,000 in Motor Pool Fuel Charges, Motor Pool, Radio Communications and
Office Equipment Rental due to less than anticipated usage.
Projecting unfavorability totaling ($350,000) in Info Tech Operations 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 $75,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 jail healthcare services budget developed
based on monthly favorability. Increasing costs have reduced this favorability however the budget has not increased
to reflect the increasing costs.
Unfavorability of ($323,000) in Grant Match is offset by favorable Transfers In revenue.
27
Adopted Amended Forecast Favorability/UNF Percentage
$11,550,021.83 $12,104,967.03 $11,245,889.04 $859,077.99 7.10%
$8,587,375.25 $8,610,375.25 $7,673,190.26 $937,184.99 10.88%
$1,545,612.00 $1,827,813.20 $1,710,613.20 $117,200.00 6.41%
$1,417,034.58 $1,666,778.58 $1,862,085.58 ($195,307.00)-11.72%
$0.00 $0.00 $0.00 $0.00 0.00%
Personnel
Favorability in salaries and fringes due to turnover, underfilled positions and vacancies across all
divisions, with greater favorability of $527,700 for County Clerk, $331,300 for Register of Deeds(and
Micrographics), $59,500 for Administration and $18,601.99 for Jury Commission and budget at Q2 for
Elections.
Operating
Clerk/Register of Deeds
2024 Q2 Forecast
Total
Summary of Projections
Transfers
No activity for FY24 across all Divisions.
Fav. for County Clerk Division for Court Transcripts $41,000 due to prosecutors ordering less transcripts.
Also Fav. Professional Services $34,500, Metereed Postage $23,900, Office Supplies $20,000 and
Charge Card Fee $11,000 due to less than anticipated activity.
Internal
Fav. for Public Svcs Administration Division for Telephone Communications $18,000. Partially offset by
Unfav. Motor Pool ($1,400) and Info Tech Operations ($130) due to allocation and usage.
Unfav. Elections division for Metered postage ($125,000) due to high volume of mailngs. Also, Unfav.
Fees - Per Diems ($74,000) due to this year being election year.
Fav. for Register of Deeds (and Micrograhics) Division for Material Supplies $72,000, Maintenance
Contract $66,600 due to less than anticipated use and activity for Micrographics Division. Also, Fav.
Metered Postage Expense $14,500 due to less volume of mailings.
Operating Expenditures is at budget at Q2 for Public Svcs Administration and Jury Commission Division.
Unfav. Info Tech Operations ($62,400) due to budget allocation and usage for County Clerk Division.
Unfav. Info Tech Operations ($132,600) due to allocation of budget and usage for Elections Division.
Internal Services is at budget at Q2 for Register of Deeds (and Micrographics) and Jury Division.
28
Adopted Amended Forecast Favorability/UNF Percentage
$9,010,040.85 $9,348,189.85 $8,207,789.85 $1,140,400.00 12.20%
$3,947,191.52 $3,947,191.52 $3,786,591.52 $160,600.00 4.07%
$3,259,270.00 $3,259,270.00 $2,459,470.00 $799,800.00 24.54%
$1,683,579.33 $1,901,728.33 $1,721,728.33 $180,000.00 9.47%
$120,000.00 $240,000.00 $240,000.00 $0.00 0.00%
Personnel
Fav. due to vacancies, turnover and underfill positions.
Operating
Treasurer
2024 Q2 Forecast
Total
Summary of Projections
Transfers
At budget for Q2 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.
Partially offset by Unfav. Claims Paid ($352,000) due to Rafaeli Lawsuit on settlement on foreclosed
property.
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
29
Adopted Amended Forecast Favorability/UNF Percentage
$5,737,575.22 $6,335,952.66 $6,102,111.66 $233,841.00 3.69%
$3,748,919.05 $3,748,919.05 $3,594,068.05 $154,851.00 4.13%
$1,285,998.00 $1,878,099.44 $1,877,699.44 $400.00 0.02%
$702,658.17 $708,934.17 $630,344.17 $78,590.00 11.09%
$0.00 $0.00 $0.00 $0.00 0.00%
Personnel
Fav. due to vacancies and turnover.
Operating
Board of Commissioners
2024 Q2 Forecast
Total
Summary of Projections
Transfers
At Budget at Q2
Projected Fav. IT Operations $63,000 due to allocation of budget and usage.
Internal
30
Adopted Amended Forecast Favorability/UNF Percentage
$8,479,591.25 $8,575,674.25 $8,664,841.25 ($89,167.00) -1.04%
$240,267.51 $240,267.51 $240,267.51 $0.00 0.00%
$287,975.00 $289,272.00 $398,372.00 ($109,100.00) -37.72%
$7,895,183.74 $7,989,969.74 $7,970,036.74 $19,933.00 0.25%
$56,165.00 $56,165.00 $56,165.00 $0.00 0.00%
Favorable Office Supplies $15,000 and Metered Postage $11,000 the result of actual spending
being less than anticipated budget.
Transfers
Transfers Out for Drainage Districts will occur at Fiscal Year End.
Unfavorable Contracted Services ($100,000) the result of working with contractors on soil
erosion sediment control standards for stormwater manual and working with contractor on policies
Favorable Drain Equipment due to over estimated budget forecast for equipment used in
rework projects.
Internal
pertaining to reorganization, offset in Soil Erosion Fees and Reimbursement General. A second
Unfavorable Professional Services ($40,600) the result of working with consultants on legislation
pertaining to policy issues, water affordability and stormwater utility issues, offset in Soil Erosion Fees.
Unfavorable Membership Dues ($4,400) and Employee Footwear ($4,000) the result of actual
spending being more than anticipated budget.
Unfavorable Charge Card Fees ($3,000) due to credit card companies increasing the fee they
charge on credit card transactions.
Favorable Legal Services $16,600 a result of Soil Erosion spending less on legal issues to enforce
the laws of the soil erosion program.
Water Resources Commissioner
2024 Q2 Forecast
Total
Summary of Projections
Personnel
Salaries and Fringes overall projected to be on budget.
Operating
quarter budget amendment will be used to adjust for the increased expenses and revenues.
A second quarter budget amendment will be used to adjust for the increased expenses and revenues.
31
Adopted Amended Forecast Favorability/UNF Percentage
$11,105,276.79 $11,745,124.79 $11,005,524.79 $739,600.00 6.30%
$7,148,502.50 $7,148,502.50 $6,540,302.50 $608,200.00 8.51%
$1,056,545.00 $1,563,996.00 $1,522,696.00 $41,300.00 2.64%
$988,408.29 $1,096,005.29 $1,005,905.29 $90,100.00 8.22%
$1,911,821.00 $1,936,621.00 $1,936,621.00 $0.00 0.00%
County Executive
2024 Q2 Forecast
Total
Summary of Projections
Personnel
Favorability due to vacancy and turnover totaling $ $608,200 between Administration and Diversity, Equity and
Operating
Transfers totaling $53,000 between the Administration and Diversity, Equity & Inclusion divisions to occur by year-
end for executive office movement.
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 favorable primarily due to $61,600 from Info Tech Operations, impacted by vacancy and budget allocation.
Compliance Office favorable primarily due to $1,600 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 is at budget.
Admin favorable primarily due to $61,600 from Info Tech Operations, impacted by vacancy and budget allocation.
Compliance Office favorable primarily due to $70,500 in Info Tech Operations based on budget allocation.
DEI unfavorable ($5,600) Info Tech Operations and ($100) Telephone Communications due to budget allocation
and use.
Internal
Corporation Counsel is favorable Travel and Conference $7,000 due to less than anticipated usage for FY2024.
Also favorable Library continuations $3,300 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 ($48,200) due to budget allocation and
usage. Also unfavorable ($6,300) in Telephone Communications as allocation of budget does not reflect the timeing
of union agreement to include cellphones and tablets.
IDSO unfavorable Telephone Communications ($1,000) due to coding errors. Fiscal Services working on resolving
for Q3.
Compliance Office, Corporation Counsel and Indigent Defense Services Office (IDSO) are at budget.
32
Adopted Amended Forecast Favorability/UNF Percentage
$24,954,180.43 $25,593,566.57 $24,291,566.57 $1,302,000.00 5.09%
$20,283,703.05 $20,283,703.05 $19,033,703.05 $1,250,000.00 5.84%
$789,709.00 $890,610.14 $838,610.14 $52,000.00 5.84%
$3,880,768.38 $4,419,253.38 $4,419,253.38 $0.00 0.00%
$0.00 $0.00 $0.00 $0.00 0.00%
Personnel
Favorability in salaries and fringes $1,250,000 due to turnover and underfilled positions/vacancies across all
divisions, with greater favorability from Fiscal Services $350,000, Equalization $800,000, and Purchasing $100,000.
Operating
Transfers
No Transfers Out are budgeted in FY 2024.
Operating Expenditures are favorable at $52,000 for Equalization Professional Services $20,000, Training
$20,000, Employee Footwear $6,000, and Expendable Equipment $6,000 due to less than anticipated usage.
Internal Support Services are at budget.
Internal
Management & Budget
2024 Q2 Forecast
Total
Summary of Projections
33
Adopted Amended Forecast Favorability/UNF Percentage
$5,378,088.63 $5,613,208.33 $5,328,208.33 $285,000.00 5.08%
$3,200,625.50 $3,200,625.50 $3,075,625.50 $125,000.00 3.91%
$1,001,599.00 $1,215,927.70 $1,055,927.70 $160,000.00 13.16%
$1,175,864.13 $1,196,655.13 $1,196,665.13 $0.00 0.00%
$0.00 $0.00 $0.00 $0.00 0.00%
Facilities Management
2024 Q2 Forecast
Total
Summary of Projections
Personnel
Favorability due to vacancy and turnover totaling $125,000 between Administration $25,000 and Facilities
Engineering Division $100,000.
Operating
Transfers
No Transfers Out are budgeted for FY 2024.
Favorability in Administration mainly attributable to Professional Services $100,000 under Sustainability Initiatives
program due to a delay in hiring educational and implementation contractors as well as favorability in Special Event
Supplies $50,000 due to a delay in the start of special events. Fav. in Facilities Engineering for Professional
Services $10,000 due to less than anticipated usage.
Internal
Favorability Info Tech Operations $30,000 due to lower than anticipated costs in Facilities Support Services.
34
Adopted Amended Forecast Favorability/UNF Percentage
$6,276,367.26 $6,538,273.51 $6,371,453.51 $166,820.00 2.55%
$3,882,840.93 $3,882,840.93 $3,753,340.93 $129,500.00 3.34%
$935,845.00 $995,931.25 $954,131.25 $41,800.00 4.20%
$1,457,681.33 $1,659,501.33 $1,663,981.33 ($4,480.00)-0.27%
$0.00 $0.00 $0.00 $0.00 0.00%
Personnel
Fav. in salaries and fringes within Human Resources Department due to vacancies, turnover and
Underfilled positions.
Operating
Human Resources
2024 Q2 Forecast
Total
Summary of Projections
Transfers
No transfers in FY2024
Fav. for HR Administration Division for Printing $6,200 due to increased digital documentation and
communication, Travel and Conference $5,000 due to less travel and events.
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.
35
Adopted Amended Forecast Favorability/UNF Percentage
$63,651,702.56 $73,193,173.46 $65,735,382.50 $7,457,790.96 10.19%
$50,567,790.96 $50,567,790.96 $47,000,000.00 $3,567,790.96 7.06%
$8,413,941.00 $17,110,506.90 $13,220,506.90 $3,890,000.00 22.73%
$4,050,573.60 $4,290,897.60 $4,290,897.60 $0.00 0.00%
$619,397.00 $1,223,978.00 $1,223,978.00 $0.00 0.00%
Personnel
Favorability in salaries and fringes $3,567,790.96 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. An amount of $17,000,000 is being transferred out to the
ARPA fund with a 2nd quarter amendment.
Operating
Transfers
Transfers Out within Health Division and 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.
Professional Services $2,000,000 due to unspent Local Community Stabilization Authority (LCSA) funds part of
FY2023 Carryforward. In addition, Uniforms $100,000, Uniform Cleaning $70,000, Software Support Maintenance
$50,000, Equipment Maintenance $30,000, and Drugs $10,000 due to less than anticipated usage. Partially offset by
Laboratory Fees ($20,000), License and Permits ($15,000), Interpreter Fees ($15,000), Drugs ($10,000), Medical
Supplies ($10,000), and Material and Supplies ($10,000) due to more than anticipated demand. An amount of
$5,000,000 is being transferred from Contracted Services to ARPA fund for the Michigan Saves program
(GRN-1004359).
Internal Support Services are at budget.
Internal
Health
2024 Q2 Forecast
Total
Summary of Projections
36
Adopted Amended Forecast Favorability/UNF Percentage
$46,056,237.79 $48,324,024.94 $46,208,030.94 $2,115,994.00 4.38%
$33,169,648.41 $33,169,648.41 $31,822,567.41 $1,347,081.00 4.06%
$5,797,271.00 $7,852,621.15 $7,086,141.15 $766,480.00 9.76%
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, $222,395 for Medical Examiner,
$148,000 for Animal Control, $146,186 for Community Corrections and budget at Q2 for Public Services
Admin Division.
Operating
Public Services
2024 Q2 Forecast
Total
Summary of Projections
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,395 and Printing $5,995 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
Supplies ($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,300 due to inventory management and Metered Postage $7,000 due to less
mailingsfor Circuit court Probation Division.
Operating Expenditures forecast for Q2 is at budget for Public Services Admin Division.
37
Adopted Amended Forecast Favorability/UNF Percentage
Public Services
2024 Q2 Forecast
Summary of Projections
$7,089,318.38 $7,301,755.38 $7,299,322.38 $2,433.00 0.03%
$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 Q2 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 ($22,900) 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,140) due to allocation of
budget and usage.
38
Adopted Amended Forecast Favorability/UNF Percentage
$11,303,843.84 $20,091,639.84 $16,301,639.84 $3,790,000.00 18.86%
$7,717,130.93 $7,717,130.93 $7,522,130.93 $195,000.00 2.53%
$2,234,875.00 $9,609,875.00 $6,014,875.00 $3,595,000.00 37.41%
$1,351,837.91 $1,464,633.91 $1,464,633.91 $0.00 0.00%
$0.00 $1,300,000.00 $1,300,000.00 $0.00 0.00%
Economic Development & Community Affairs
2024 Q2 Forecast
Total
Summary of Projections
Personnel
Favorability due to vacancy and turnover totaling $195,000 among the various Divisions.
Operating
Transfers
Transfers Out are at budget.
Favorable in Local Business Development due to Placemaking Grant to revitalize unused/underused public
spaces$2,000,000, Automation Alley funding carried over from FY2023 and not allocated $1,000,000, Workshop
and Meetings, $200,000, Advertising $150,000, Travel and Conference $60,000, Personal Mileage $50,000,
Software Support Maintenance $30,000, and Printing $15,000 due to less than anticipated usage. .
Favorable Soldier Burial $80,000 and Soldier Relief $10,000 due to less than anticipated claims for veteran
benefits such as burial in National Cemetery, headstones, markers, burial flags, and other veteran benefits.
Internal Services are at budget.
Internal
39
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%
Personnel
Personnel expenditures are at budget
Operating
Transfers
No Transfers Out are budgeted in FY 2024.
Favorable in Professional Services due to Building Resilient Infrastructure and Community grant (BRIC) for
$435,000 and the Disaster Control Federal Subsidy $315,000 not being fully expended. Also, Equipment
Maintenance $10,000 and Maintenance Contract $10,000 due to less than anticipated usage. Partially offset by
Ajustment to Prior Years Expenditures ($15,000) and Travel and Conference ($12,000) due to less than anticipated
travel.
Internal Support Services are at budgert.
Internal
Emergency Management & Homeland Security
2024 Q2 Forecast
Total
Summary of Projections
40
Adopted Amended Forecast Favorability/UNF Percentage
$3,962,765.23 $4,543,014.27 $4,410,572.27 $132,442.00 2.92%
$2,673,899.22 $2,673,899.22 $2,604,299.22 $69,600.00 2.60%
$1,131,327.00 $1,607,095.04 $1,499,295.04 $107,800.00 6.71%
$157,539.01 $203,378.01 $306,978.01 ($103,600.00)-50.94%
$0.00 $58,642.00 $0.00 $58,642.00 100.00%Transfers
No transfers in FY24
Fav. Material and Supplies, $27,400, Expendable Equipment $19,000, Printing County Directory
$11,800, Metered Postage Expenses $10,000 and Periodicals Books Publ Sub $9,800 due to less than
anticipated use and activity.
Projected Unfav. Info Tech Operations ($92,500) and Telecommunication ($11,000) due to allocation of
budget and usage.
Internal
Personnel
Projected Favorability in Salaries and Fringes due to vacancies and turnover.
Operating
Dept. of Public Communications
2024 Q2 Forecast
Total
Summary of Projections
41
Account
FY 2024
Adopted Budget
FY 2024
Amended Budget
FY 2024
Actuals - MAR Variance Percentage
FY 2024
Projection
Amount
Fav./Unfav.Explanation
Expenditure 0.00%
702000 Salaries Regular (10,000,000.00) (10,000,000.00) 180.00 (10,000,180.00) 0.00%- (10,000,000.00) Unfav. due to net impact of salary and fringe turnover
that is offset in the individual department budgets.
722000:Fringe Benefits - - 10.26 (10.26) 0.00%- -
730000:Contractual Services 1,324,962.00 2,234,400.00 349,387.63 1,884,378.87 15.64%2,563,400.00 (329,000.00) Unfav. Primarily due to Prior Year Adjustment ($271,300)
to an accounting adjustment on reimbursements for Child
Care Fund activity and bank and Paypal transaction fees
($54,000) not budgeted.
740000:Non-Departmental 13,616,119.00 19,472,928.00 8,783,531.90 10,689,396.10 45.11%19,518,428.00 (45,500.00) Unfav. Due to actual drain assessments are higher than
budget.
760000:Capital Outlay 2,299,683.00 2,686,407.00 - 2,686,407.00 0.00%2,686,407.00 - At Budget
770000:Internal Support
Expenditures
12,070,535.45 8,766,709.45 834,667.06 7,932,042.39 9.52%8,766,709.45 - At Budget
788001:Transfers Out 37,359,059.00 38,433,185.00 17,874,229.24 20,558,955.76 46.51%38,433,185.00 - At Budget
796500:Budgeted Equity
Adjustments
(900.00) (900.00) - (900.00) 0.00%(900.00) -
At Budget
Total Expenditure 56,669,458.45 61,592,729.45 27,842,006.09 33,750,089.86 45.20%71,967,229.45 (10,374,500.00)
NON-DEPARTMENTAL
FY 2024 SECOND QUARTER - GENERAL FUND
SUMMARY OF EXPENDITURES
5/29/2024
5:38 PM 2nd Qtr Fcst - Exp. Collapsed
42
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 2,000,000.00 1,000,000.00 100.00%Fav. Investment from Investments $2,000,000 due to investment base
and market rate adjustments.
Transfers In - - - - 0.00%
Total Revenues $11,500,000.00 $11,500,000.00 $12,500,000.00 1,000,000.00$ 8.70%
OPERATING EXPENSES
Personnel Expenditures 248,137.58$ 248,137.58$ 248,137.58$ -$ 0.00%
Operating Expenditures 342,386.00 342,386.00 428,566.00 (86,180.00) -25.17%Unfav. Indirect costs($153,187) due to greater than anticipated
activities. Partially offset by Fav. Administrative Overhead $30,000,
Legal services $25,000 and Prof Svc-Financial Consultant $25,000
due to no borrowing from Treasurer's office.
Interest Expense 1,000,000.00 1,000,000.00 0.00 1,000,000.00 100.00%Fav. Interest Expense on Debt as it was decided not to borrow money
and utilize the available monies to fund CVTs.
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$ 12,152,828.58$ 913,820.00$ 6.99%
REVENUE OVER (UNDER)
EXPENDITURES*($1,566,648.58)($1,566,648.58)$347,171.42 $1,913,820.00
Total Net Position - Beginning $209,829,663.72
Total Net Position - Ending $210,176,835.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 $347,171.42
Total Net Position - Ending $210,176,835.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 SECOND QUARTER REPORT
ENTERPRISE FUND
43
COUNTY OF OAKLAND
FY 2024 SECOND 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 487,822.16 $66,495.00 12.00%Fav. Controllable Personnel $64,300 due to vacant and underfilled
positions. Also Fav. Professional Services $20,360 due to less than
anticipated use. Partially Offset by Unfav. Insurance Fund ($20,700)
due to budget allocation and use.
NET OPERATING INCOME (LOSS)($48,181.16)($48,181.16)$18,313.84 $0.00 0.00%
NON-OPERATING REVENUE
(EXPENSE)/INVESTMENT INCOME
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)23,313.84$ $0.00
TRANSFERS OUT - - - -
TOTAL NET INCOME (LOSS)*($43,181.16)($43,181.16)$23,313.84 $0.00
TOTAL NET POSITION - BEGINNING
1,351,295.45
TOTAL NET POSITION - ENDING $1,374,609.29
* Please note that in the Adopted Budget (line-item book) this is budgeted as 'Planned Use of Balance" in the revenue category.
44
COUNTY OF OAKLAND
FY 2024 SECOND 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%Unfavorable Transfer to Municipalites ($147,220) due to
Community Grant Program with CVT's. A budget
amendment will be included in Q3 forecast as more
invoices from the CVT's are invoiced and paid.
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$ 27,249,408.00$ 1,147,640.00$ 4.40%Fav. Investment Income $1,147,640. A budget
amendment is not recommended at this time due to
uncertain market conditions.
TOTAL INCOME BEFORE TRANSFERS 2,167,957.00$ 2,167,957.00$ 3,315,597.00$ 1,147,640.00$ -52.94%
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$ 3,065,597.00$ 1,147,640.00$
TOTAL NET POSITION - BEGINNING 96,563,167.85$
TOTAL NET POSTION - ENDING 99,628,764.85$
45
COUNTY OF OAKLAND
FY 2024 SECOND 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,486,000.00 $96,000.00 1.50%-Fav. T Hangar Rentals $70,000 due to increased rentals and Car Rental Concessions
$26,000 due to increased car rentals.
OPERATING EXPENSE 8,145,146.00 8,245,146.00 8,122,300.00 122,846.00 1.49%-Fav. Salaries $262,900 due to position turnovers and Professional Services $22,400 due
to reimbursements received from the State of Michigan. Partially, offset by Unfav.
Grounds Maintenance ($131,000) due to projects mandated by the Federal Aviation
Administration; Electrical Service ($29,500) due to increased costs; Motor Pool ($9,200)
due to leasing a vehicle before transferring to the Airport as a department owned vehicle.
NET OPERATING INCOME (LOSS)($1,755,146.00)($1,855,146.00)($1,636,300.00)218,846.00$ -11.80%
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 balance.
TOTAL INCOME BEFORE
CONTRIBUTIONS AND TRANSFERS (1,605,146.00) (1,705,146.00) ($1,086,300.00)618,846.00 -36.29%
TRANSFERS IN/(OUT)(25,000.00) (25,000.00) (28,800.00) (3,800.00) 15.20%-Unfav. Transfer Out ($3,800) due to Airport Vehicle Fleet Expansion.
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,730,146.00)($976,400.00)$753,746.00
TOTAL NET ASSETS - BEGINNING 76,090,785.21$
TOTAL NET ASSETS - ENDING 75,114,385.21$
46
COUNTY OF OAKLAND
FY 2024 SECOND QUARTER REPORT
INTERNAL SERVICE FUND
RISK MANAGEMENT
ADOPTED AMENDED FY 2024 VARIANCE
BUDGET BUDGET ACTUALS 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,904,689.00 261,900.00 3.65%-Fav. Salaries and Fringe Benefits $371,000 due to vacant
positions, and Professional Service $40,000 due to contract
expiration for AED maintenance. Partially offset by unfav
Indirect Costs ($97,515) due to actual charges determined
after budget finalization, Info Tech Operations ($25,900) and
Info Tech Development ($15,850) based on actual usage,
and Motor Pool ($9,800) due to actuals more than budget.
CLAIMS PAID 8,056,000.00 8,056,000.00 6,056,000.00 2,000,000.00 24.83%-Fav. due to claim amounts less than anticipated.
TOTAL OPERATING EXPENSES $ 15,222,589.00 $ 15,222,589.00 $ 12,960,689.00 2,261,900.00 14.86%
OPERATING INCOME (LOSS)(2,382,733.00)(2,382,733.00)(120,833.00)2,261,900.00 -94.93%
NON-OPERATING REVENUE (EXPENSE) 100,000.00 100,000.00 550,000.00 450,000.00 450.00%-Fav. due to higher than expected available cash balance.
NET REVENUES OVER/(UNDER)*
EXPENSES $ (2,282,733.00) $ (2,282,733.00) 429,167.00 $ 2,711,900.00
TOTAL NET ASSETS - BEGINNING 559,304.00
TOTAL NET ASSETS - ENDING $ 988,471.00
47
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,419,450.00$ 54,419,450.00$ (4,000,000.00)$ -6.85%Unfav - Reimbursement Salaries ($4,000,000) due to unallocated
payroll charges for turnover and vacant positions, offset in Salaries
and Fringes.
Outside 240,100.00 240,100.00 240,100.00 - 0.00%
Total Revenue 58,545,586.00 58,659,550.00 54,659,550.00 (4,000,000.00)-6.82%
OPERATING EXPENSES $58,791,546.00 $58,905,510.00 $55,016,317.00 $3,889,193.00 6.60%Fav - Salaries and Fringes $4,000,000 due to turnover and vacant
positions. Fav - Depreciation Computer Software $200,000 due to
the Supervisory Control and Data Acquisition (SCADA) system
common to all project not being booked in second quarter FY 2024.
Fav - Depreciation Vehicles $50,000 due to over estimated
depreciation schedule. Fav - Drain Equipment Labor $15,000 and
Drain Equipment $15,000 due to over estimated budget forecast on
rework projects. Fav - Employee Footwear $4,750 the result of
actual spending being less that anticipated budget. Unfav - Materials
and Supplies ($300,000) due to inflationary price increases and
usages of these water and sewer supplies. Unfav - Expendable
Equipment ($40,000) the result of actual spending being more than
anticipated budget.
WATER RESOURCES COMMISSIONER
FY 2024 SECOND QUARTER FORECAST
INTERNAL SERVICE FUND
COUNTY OF OAKLAND
48
ADOPTED AMENDED FY 2024 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
WATER RESOURCES COMMISSIONER
FY 2024 SECOND QUARTER FORECAST
INTERNAL SERVICE FUND
COUNTY OF OAKLAND
Unfav - Indirect Costs ($20,000) due to indirect cost rate finalized
after budget process. Unfav - Equipment Maintenance ($10,000) the
result of increasing maintenance in order to maintain aging
equipment. Unfav - Maintenance Contract ($10,000) due to increase
contractors work on SCADA software maintenance. Unfav - Drain
Equipment Materials ($6,000) due to under estimated budget
forecast for materials used in rework projects. Unfav - Equipment
Rental Expense ($4,200) the result of increased use in specialty
equipment needed for maintenance projects. Unfav - Legal Services
($3,500) due to legal services used to settle disputes on rebill repair
work issues.
NET INCOME (LOSS) BEFORE ($245,960.00)($245,960.00)($356,767.00)($110,807.00)45.05%
NON-OPERATING REVENUE/(EXPENSE)$216,600.00 $216,600.00 $330,600.00 114,000.00 52.63%Fav - Income from Investment $80,000 due to investment base and
market rate fluctuations. Fav - Sale of Equipment $32,000 due to
sale of user owned equipment at county auction or online bidding
services.
TRANSFER IN - - - - 0.00%
TRANSFERS (OUT)- - 160,988.00 (160,988.00) 0.00%Unfav - Transfer Out ($160,988) due to second quarter budget
amendment for three vehicles and two snowplows scheduled to be
purchased in FY 2023 were acquired in FY 2024.
NET REVENUES OVER (UNDER)
EXPENSES*
($29,360.00)($29,360.00)($187,155.00)($157,795.00)
TOTAL NET POSITION - BEGINNING 35,675,327.82$
TOTAL NET POSITION - ENDING 35,488,172.82$
*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.49
FY 2024 SECOND 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 29,670,675.00 29,670,675.00 29,670,675.00 - 0.00%
Total Revenue 30,220,286.00$ 30,221,088.00$ 30,221,088.00$ -$ 0.00%
OPERATING EXPENSES 31,588,087.08$ 31,870,342.00$ 31,443,342.00$ 427,000.00$ 1.34%Favorable Equipment $247,000, Professional Services $120,000, Material
and Supplie $100,000, Road Salt $100,000, and Software Support
Maintenance $30,000 due to less than anticipated use. Partially offset by
Rent ($20,000), Gasoline Charges ($20,000), Grounds Supplies ($20,000),
Maintenance Supplies ($20,000), Security Supplies ($20,000), Shop
Supplies ($10,000), and Small Tools ($10,000) due to more than anticipated
usage.
BUDGETED EQUITY ADJUSTMENTS -$ 802.00$ -$ -$ 0.00%
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (1,367,801.08)$ (1,650,056.00)$ (1,222,254.00)$ 427,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*(3,251,801.08)$ (3,534,056.00)$ (3,106,254.00)$ 427,000.00$
TOTAL NET POSITION - BEGINNING 8,635,092.51$
TOTAL NET POSITION - ENDING 5,528,838.51$
*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
50
COUNTY OF OAKLAND
FY2024 SECOND 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 26,458,895.00 2,633,259.00 11.05%-Fav. due to County payroll actuals being higher than budget projections, 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,083,100.00 247,120.00 5.11%-Fav. due to County payroll actuals being higher than budget projection, 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 36,166,798.00 (7,777,748.00) -17.70%-Unfav. due to actual revenue less than budget projections.
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 418,852.00 218,852.00 109.43%-Fav. due to actual revenue higher than budget projections.
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 566,794.00 316,794.00 126.72%-Fav. due to actual revenue higher than budget projections.
EXT - PRESCRIPTION DRUG REBATES 2,000,000 2,000,000 4,461,192.00 2,461,192.00 123.06%-Fav. due to actual revenue higher than budget projections.
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 182,264,096.00 (1,900,531.00) 0.00%
51
COUNTY OF OAKLAND
FY2024 SECOND 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 27,520,529.00 (3,694,893.00) -15.51%-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 61,938,486.00 (7,493,486.00) -13.76%-Unfav. due to County payroll actuals being higher than budget projections.
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 168,235,883.00 (11,434,849.00) -7.29%
NET REVENUE OVER/(UNDER) EXPENSES 27,363,593.00 27,363,593.00 14,028,213.00 9,534,318.00
TOTAL NET ASSETS - BEGINNING 422,589,176.52
TOTAL NET ASSETS - ENDING 436,617,389.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}
52
FY 2024 SECOND 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$ 2,325,653.00$ 240,900.00$ 11.56%-Favorable Enhanced Access Fees $412,300 and Sale of Equipment $9,300
due to higher than anticipated usage.. Offset by unfav.Managed Print
Services ($180,700) due to reduction in external customer requests.
Inside 35,567,012.00 35,582,540.00 35,117,040.00 (465,500.00) -1.31%-Unfav. OC Depts Operations & Non Governmental Operations ($1,073,600)
and OC Depts Development Support & Non Governmental Development
($279,600) due to rates remaining at prior year levels and limited resources
available to complete development due to vacancies. Also unfav. FOIA
Fees($16,900). Partially offset by fav. Prior Year Adjustments $833,000 and
Equipment Rental $71,500 due to rebills to departments for maintenance
charges on IT Office Equipment items.
TOTAL OPERATING REVENUE 37,651,765.00$ 37,667,293.00$ 37,442,693.00$ (224,600.00)$ -0.60%
OPERATING EXPENSES 58,174,688.00 59,020,316.00 62,095,316.00 (3,075,000.00) -5.21%-Unfav. Professional Services ($2,797,300) due to projects previously
approved in prior year; Charge Card Fees ($1,023,300); Equipment
Maintenance ($728,700) due to lower than anticipated hardware
maintenance costs due to increased activity; Indirect Costs ($310,700) due
to actual charges being developed after budget finalization; Communications
($165,500) due to rate reductions; Exp Equipment ($664,300) for equip
replacement; Parts and Accessories ($103,500) and Workshops & Meetings
($300) based on usage; Bank Charges ($31,000) for credit card activity and
Contracted Svcs ($1,200) due to higher than anticipated activity . Offset by
fav. Salaries and Fringes $2,465,600 due to vacanies; Internal Services
$284,300 is primarily due to fav. Insurance Fund and Membership Dues
$1,100 due to usage.
.NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (20,522,923.00)$ (21,353,023.00)$ (24,652,623.00)$ (3,299,600.00)$ 15.45%
NON-OPERATING REVENUE 70,500.00$ 70,500.00$ 530,800.00$ 460,300.00$ 652.91%Fav. primarily due to Interest Income; higher cash balance than anticipated.
TRANSFERS IN 7,934,876.00$ 8,615,516.00$ 8,615,516.00$ -$ 0.00%
TRANSFERS (OUT)-$ -$ -$ -$ 0.00%
CAPITAL CONTRIBUTION -$ -$ -$ -$ 0.00
NET REV OVER(UNDER) EXP*(12,517,547.00)$ (12,667,007.00)$ (15,506,307.00)$ (2,839,300.00)$
TOTAL NET POSITION - BEGINNING 41,994,439.75$
TOTAL NET POSITION - ENDING 26,488,132.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)
53
FY 2024 SECOND 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,173,280.00$ 509,500.00$ 13.91%Fav. Sale of Phone due to cell phone usage.
TOTAL OPERATING REVENUE 3,675,780.00$ 3,675,780.00$ 4,178,780.00$ 503,000.00$ 13.68%
OPERATING EXPENSES 4,015,123.00$ 4,015,123.00$ 4,770,123.00$ (755,000.00)$ -18.80%Unfav. Communications ($1,633,500), Internal Services ($65,000) primarily
due to Info Tech Operations ($14,900) and Telephone ($49,300) and
Equipment Repairs and Maintenance ($600) due to higher than anticipated
cost; Indirect Cost ($45,400) due to actual charges being developed after
budget finalization; Expendable Equipment ($28,600) for equipment
replacement and Membership Dues ($1,000) based on actual usage.
Partially offset by fav. Contracted Services $990,200 due to less than
anticipated activity; Software Maintenance $8,300 due to lower maintenance
rates; Salaries and Fringes $5,000 due to vacanies and Sublet Repairs
$15,600 due to lower than anticipated repair volume.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (339,343.00)$ (339,343.00)$ (591,343.00)$ (252,000.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)$ (506,643.00)$ (197,300.00)$
TOTAL NET POSITION - BEGINNING 2,119,432.74$
TOTAL NET POSITION - ENDING 1,612,789.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)
54
FY 2024 SECOND 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,496,353.00$ 5,373,653.00$ (122,700.00)$ -2.23%Unfav. CLEMIS Crash ($100,100) due to decreased activity; Access Fees
Oakland ($54,000) partially offset by fav. Access Fees Non Oakland $21,200
due to updated law enforcement Full Time Equivalent count used for billing.
Also fav. Parts and Accessories $10,200 due to increased usage by Oakland
and non-Oakland agencies.
Inside 1,799,384.00 1,801,299.00 1,630,099.00 (171,200.00)$ -9.50%Unfav. Service Fees ($102,600) and Reimb General ($17,600) based on
actuals for CLEMIS staff supporting Sheriff project; In-Car Terminal
($52,500) due to participation count higher than budget projection. Offet by
fav. FOIA Fees $1,500.
TOTAL OPERATING REVENUE 7,295,737.00$ 7,297,652.00$ 7,003,752.00$ (293,900.00)$ -4.03%
OPERATING EXPENSES 13,511,930.00$ 13,511,930.00$ 13,338,530.00$ 173,400.00$ 1.28%Fav. Salaries and Fringes $1,276,900 due to vacanies; Internal Services
$430,300 primarily due to IT Development; Indirect Cost $129,900; Parts and
Accessories $23,200 and Supplies $1,200 due to usage. Offset by unfav.
Professional Services ($1,661,300) due to higher than anticipated contractual
costs for staffing services; Charge Card Fees ($18,500) for credit card
activity and Rebillable Services ($8,400) based on actual connectivity costs
to Tier 2.5.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (6,216,193.00)$ (6,214,278.00)$ (6,334,778.00)$ (120,500.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)$ (4,583,892.00)(48,800.00)$
TOTAL NET POSITION - BEGINNING 9,486,107.78
TOTAL NET POSITION - ENDING 4,902,215.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.
55
FY 2024 SECOND 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 9,265,600.00$ 9,265,600.00$ 9,570,400.00$ 304,800.00$ 3.29%Fav. due to Antenna Site Mgmt. due to updates in rental contracts.
Inside 492,585.00$ 492,585.00$ 834,685.00$ 342,100.00$ 69.45%Fav. due to Prior Year Adjustment due to higher than anticpated
reimbursement by participating agencies for equipment replacement.
TOTAL OPERATING REVENUE 9,758,185.00$ 9,758,185.00$ 10,405,085.00$ 646,900.00$ 6.63%
OPERATING EXPENSES 10,991,693.00$ 11,126,193.00$ 13,730,293.00$ (2,604,100.00)$ -23.41%Unfav. Parts and Accessories ($390,300) due to usage; Interest Expense
($211,100); Equipment Maintenance ($497,200) due to maintenance costs;
and Other Exp Equipment ($2,027,300) for equipment replacement; Electrical
Service ($11,000) and Supplies ($1200) due to lower than anticipated usage.
Partially offset by fav. Salaries and Fringes $364,900 dued to vacanies;
Communications $77,300 for connectivity costs for cell tower sites used for
coverage enhancements of the Radio system; Tower Charges $70,900 and
Internal Services $20,800 primarily due to Info Tech CLEMIS.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (1,233,508.00)$ (1,368,008.00)$ (3,325,208.00)$ (1,957,200.00)$
NON-OPERATING REVENUE 100,000.00$ 100,000.00$ 692,300.00$ 592,300.00$ 592.30%Fav. primarily due to Interest Income; higher cash balance than anticipated.
TRANSFERS IN 85,174.00$ 219,674.00$ 219,674.00$ -$ 0.00%
TRANSFERS (OUT)(286,000.00)$ (286,000.00)$ (286,000.00)$ -$ 0.00%
NET REV OVER(UNDER) EXP*(1,334,334.00)$ (1,334,334.00)$ (2,699,234.00)$ (1,364,900.00)$
TOTAL NET POSITION - BEGINNING 47,951,134.06$
TOTAL NET POSITION - ENDING 45,251,900.06$
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.
Information Technology - Radio Communications (53600)
56
FY 2024 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2024 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES()
Fire Records Management ( 53100)
OPERATING REVENUES:
Outside 356,684.00$ 356,684.00$ 441,884.00$ 85,200.00$ 23.89%Fav. primarily due to Rebilled Charges Revenue.
.
TOTAL OPERATING REVENUES 356,684.00$ 356,684.00$ 441,884.00$ 85,200.00$ 23.89%
OPERATING EXPENSES 1,097,460.00$ 1,097,460.00$ 1,103,960.00$ (6,500.00)$ -0.59%Unfav. Internal Services ($39,000) primarily due to IT Development;
Professional Services ($5,500), Indirect Costs ($1,300) and Software
Maintenance ($300) due to increased activity. Partially offset by Fav.Salaries
and Fringes $39,600 due to vacanies.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (740,776.00)$ (740,776.00)$ (662,076.00)$ 78,700.00$
NON-OPERATING REVENUE 3,000.00$ 3,000.00$ 8,800.00$ 5,800.00$ 193.33%Fav. primarily due to Interest Income; higher cash balance than anticipated.
TRANSFERS IN 515,880.00$ 515,880.00$ 522,380.00$ 6,500.00$ 1.26%
TRANSFERS (OUT)-$ -$ -$ - 0.00%
CAPITAL CONTRIBUTION -$ -$ -$ - 0.00%
NET REV OVER(UNDER) EXP*(221,896.00)$ (221,896.00)$ (130,896.00)91,000.00
TOTAL NET POSITION - BEGINNING 1,399,590.62$
TOTAL NET POSITION - ENDING 1,268,694.62$
*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.
57
COUNTY OF OAKLAND
FY 2024 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
FACILITIES
ADOPTED AMENDED FY 2024 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
MOTOR POOL FUND 66100
OPERATING REVENUE:
Outside Revenue 128,000.00$ 128,000.00$ 128,000.00 -$ 0.00%
Inside Revenue 9,901,776.00 10,138,380.00 9,295,680.00 (842,700.00) -8.31%-Unfav. Leased Equipment ($491,400) due to actual activity trends to date and due
to the delay in new product delivery, Gasoline, Oil & Grease Charges ($291,500)
due to current fuel costs and improved miles per gallon (offset by favorable
Gasoline Charges expense) and Productive Labor ($134,800) due to less than
anticipated charges, partially offset by favorable Parts and Accessories $75,000 due
to higher number of repairs being performed.
Total Revenue 10,029,776.00 10,266,380.00 9,423,680.00 (842,700.00)
OPERATING EXPENSE 11,296,490.00 11,674,119.00 11,447,819.00 226,300.00 1.94%-Fav Gasoline Charges $306,300 due to market fluctuations, miles driven and
improved fuel economy (partially offset by favorable Gasoline Oil & Grease Charges
revenue); partially offset by unfavorable Sublet Repairs ($80,000) due to higher
individual repair costs for vehicles sent out for repairs.
OPERATING INCOME (LOSS)(1,266,714.00) (1,407,739.00) (2,024,139.00) (616,400.00)
NON-OPERATING REVENUE
(EXPENSE)
642,700.00 642,700.00 1,122,700.00 480,000.00 74.68%-Fav. Gain on Sale of Vehicles $480,000 due to higher than anticipated sale values
on used vehicles.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (624,014.00) (765,039.00) (901,439.00) (136,400.00)
TRANSFERS IN / (OUT)317,000.00 728,989.00 889,989.00 161,000.00 22.09%Fav. Transfer In $161,000 due to three WRC vehicles and two snowplows that were
not completed in FY 2023 that are now complete in FY 2024. A budget amendment
is recommended, to be completed by WRC.
CAPITAL CONTRIBUTIONS - - - -
NET REVENUE OVER/(UNDER)
EXPENSES (PLANNED USE OF
FUND BAL.) *
(307,014.00)$ (36,050.00)$ (11,450.00)$ 24,600.00$
TOTAL NET ASSETS - BEGINNING 11,305,398.76$
TOTAL NET ASSETS - ENDING 11,293,948.76$
5/29/2024
58
Receipt Number Amount Journal Number
$6,613.74
$5,322.57
$5,384.11
Q2 FY 2024 Total $17,320.42
January 2024 Total
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - FY 2024 2nd Quarter (January-March)
Date of Donation Person Donating
February 2024 Total
March 2024 Total
2024FY Restricted Fund Legacy-Totals by Month 2nd Q FY 202459
Date Donor Cash/Check Amount Purpose
2/5/2024 Ford Motor Company N/A 7,000.00$ “Body in White” Automotive “Ford Explorer” - Truck Frame
3/14/2024 Yesly Water N/A 3,000.00$ Qty 240, 12 Packs of various flavors of canned water
3/20/2024 Ashleigh Iserman Boating Safety Foundation N/A 1,600.00$ Portable Display Board - Boating Safety Classes
3/31/2024 William and Shannon Johns Check #1268 5,000.00$ Equipment for K9 Unit
Oakland County Sheriff's Office
FY2024 Second Quarter Report for Contributions (Donations)
OCSO FY24 Q2 Donations SUMMARY FY2024 Q260
2/5/2024
Brian
On 2/2/24 the Calhoun County ALURT Dive team which is part of the Southeast Mi Dive Group received
a donation of a “Body in White” Automotive “Ford Explorer” to be used to simulate real-world
situations but also ensures minimal environmental impact. This specialized tool will empower our
divers to practice and refine rescue and recovery techniques, directly applicable in time-sensitive
callouts, ultimately contributing to the possible preservation of lives.
The approximate value of this asset is $7,000.00
The Calhoun County ALURT dive team acting as a separate legal entity and operating as a 501( c )(3)
EIN # 38-2609921 wishes to pass this donation on to Oakland county the Governing agency for the
Southeast Mich Dive group so that it may be utilized by all agencies that are part of the Southeast Mi
Dive group
Andrew Erard
ALURT Dive team commander
Marine Deputy Calhoun County Sheriff’s office
Southeast Michigan Dive Group
269_612_8840
aerard@calhouncountymi.gov
61
Steve Hinkley, Sheriff
Timothy A. Hurtt, Undersheriff
David A. Tendziegloski , Chief Deputy
62
599
•, . . .
C!_jD , • -
/
1343 Main Street 3/14/2024
Unit 601
Sarasota, FL 34236
Dear Lt. Burwell-
On behalf of Yesly Water, I am happy to donate the following to your Marine Unit and Search and Rescue
Unit.
- Qty 240, 12 Packs of various flavors of canned water, approximate value $3,000.00.
The product has been delivered.
Should you have any questions, please do not hesitate to contact me.
Thank you for all that you and your team do.
Sincerely,
Mark Rall
Area Sales Manager
63
64
Burwell, Brian R
From:
Sent:
To:
Subject:
Janet Willhite-iserman <chipps3478@a ol.com >
Wednesday, March 20, 2024 1 :09 AM
Burwell, Brian R
Display Board Donation
CAUTION : This message is from a sender outside of the Oakland County organization . Do not click links or open
attachments unless you recognize the sender and know the content is safe.
March 20th, 2024
On behalf of the Ashleigh Iserman Boating Safety Foundation, we are pleased to be able to donate the Portable Display
Board to the OCSD Marine Division and the search and rescue teams. This display board will be a great tool that can be
used in Boating Safety Education Classes and other presentations that provide other additional information on Boating
and Water safety.
We were able to raise the $1600 for the Display Board through our fund raising efforts. Ashleigh Iserman Boating Safety
Foundation is a 503 (C) (3). Tax ID #45-3339189.
Sincerely,
Jan Willhite-Iserman
Founder, Ashleigh Iserman Boating Safety Foundation
Sent from my iPad
1
65
g
t1 • JI
66
Roddy, David M
From:
Sent:
To:
Subject:
Shannon <johnssable@comcast.net>
Tuesday, April 9, 2024 12:55 PM
Roddy, David M
K9 donation
CAUTION: This message is from a sender outside of the Oakland County organization. Do not click links or open
attachments unless you recognize the sender and know the content is safe.
To whom it may concern,
We are donating $5000.00 to the Oakland County Sheriffs Office K9 Unit.
The funds are to be used to buy equipment for the K-9 unit with no strings except to say it is in honor of Bob Loken.
Sincerely,
Shannon & Bill Johns
e,)ait -:z: ,S'"e,i_f y'cJ..-<A. c,IP\
~fZ<;fr ~t0 ct/zr) tfe/Vlwf-;¢1
//1,/e,;,~ h VJ-c-?./-M-.
1
Department of Public Services
Oakland County Children's Village
Date:Donor:Cash/Check:Items:Estimated Value:
12/1/2023 Lakes Vicariate Christmas Gifts 3000
12/13/2023 Oakland County Clothing Drive Clothing 5000
1/1/2024 Sweet Dreams for Kids Pillowcases $225.00
1/3/2024 St. Perpetua Church Pillowcases $325.00
1/3/2024 OCCVF Movie Tickets and snacks $320.00
1/5/2024 J. Adams Check $100.00
1/5/2024 M. McGinnis Clothing, Toiletries $225.00
1/10/2024 OCCVF Athletic Program for Resident $54.00
1/21/2024 OCCVF Personal Program for Resident $50.00
2/2/2024 Anonymous 2 Suitcases $78.76
2/2/2024 J. Greenfield Wii Game w/Games &Equipment $500.00
2/2/2024 St. Perpetua Church Pillowcases $310.00
2/6/2024 OCCVF Fitness Program for Resident $150.00
2/8/2024 Waterford Knitters Yarn $200.00
2/13/2024 OCCVF Identification Fee for Resident $45.00
2/20/2024 J.Frejat Disney Videos - 15 Used $75.00
2/20/2024 A Little Quilt Shop Quilts $200.00
2/21/2024 Sweet Dreams for Kids Pillowcases $225.00
2/22/2024 OCCVF Furniture Bank for Resident Family $140.00
3/1/2024 OCCVF 4 Library Carts, Artwork, Books $1,700.00
3/1/2024 Oakland County Senior Leadership Team County Wide Book Drive $5,000.00
3/1/2024 M. Giacdi Suitcase $50.00
3/1/2024 Sweet Dreams for Kids Pillowcases $300.00
3/4/2024 St. Perpetua Church Pillowcases $320.00
3/8/2024 S. Arnett Toiletries and Toys $600.00
3/19/2024 OCCVF Spiritual Motivational Program $500.00
3/21/2024 S. Hewitt Clothing, Shoes, Accessories $500.00
3/21/2024 OCCVF 250 Med. Size Plaid Bags $472.50
Total:$12,665.26
Donation Tracking : Donation Period January 2024 - March 2024
67
Dear Oakland County Partners,
The total Condom Allocation for Oakland County for Fiscal Year 24 is $10,000. This funding covers
both Prevention and STI and must be spent by September 1,2024.
Please find attached an order form for your convenience. Once you have completed the form,
please upload the request to SHOARS to place your order. To find the condoms, please go to the
Supply Order Request Form, STI & HIV Testing Supplies, Local Health Departments Only.
It's important to note that orders CAN NOT be placed directly with the distributor on behalf of
MDHHS, and any changes to the orders must be made by MDHHS.
After placing your order in SHOARS, please feel free to respond to the confirmation email if you
have any questions or concerns.
If you find that you need to purchase more condoms/lube after you have spent your
allotment, please contact me.
Kind Regards,
Malasha Duncan
Award Letter for OC Department of Health and Human Services
68
Supply Order Request Form
Rapid Kits HIV Self Testing
STI Requisiti on
Sticker Labels
Proficiencies
I ✓ I Local Health Departments Only
condoms -Limited Stock
Back lf§I
Instructions: Please complete gray shaded areas and upload form in SHOARS
Agency
Shipping Address
Item Number Description UOM Pieces Price/Unit QTY Total
Total #
Pieces
Condoms
ASRT1024C9 Assort 1024 Condom Assortment Sample, 1024 pieces/case case 1024 $118.00 0 $0.00 0
ASRT0512C6 Assort 512 Condom Assortment Sample, 512 pieces/case case 512 $63.00 0 $0.00 0
ASRT0128B5 Assort 128 Condom Assortment Sample, 129 pieces/box box 129 $19.00 0 $0.00 0
SOULCNLUC7 Soul Lubricated condoms-1000 pieces/case case 1000 $61.00 0 $0.00 0
SOULCNXTC7 Soul Ultra Thin condoms-1000 pieces/case case 1000 $64.00 0 $0.00 0
SOULCNXLC7 Soul Extra Large condoms-1000 pieces/case case 1000 $64.00 0 $0.00 0
SOULCNRSC7 Soul Ribbed and Studded-1000 pieces/case case 1000 $66.00 0 $0.00 0
LBLL1000C7 Lucky Boy Lubricated Condoms, 1008 pieces/case case 1008 $77.00 0 $0.00 0
IDDCSF01C7 ID Superior Feel Latex Condom- lubricated, 1000 pieces/case case 1000 $77.00 0 $0.00 0
IDDCXT01C7 ID Condom Extra Thin- lubricated-1000 pieces/case case 1000 $78.00 0 $0.00 0
IDDCXL01C7 ID Condom Extra Large- lubricated, 1000 pieces/case case 1000 $88.00 0 $0.00 0
IDDCST01C7 ID Condom Studded- lubricated, 1000 pieces/case case 1000 $78.00 0 $0.00 0
CRLL2100C8 Crown Skinless Lubricated Condoms, 1008 pieces/case case 1008 $134.00 0 $0.00 0
FAFL6818C7 Fantasy Assorted Flavors Lubricated Condoms. Lightly Flavored. 1000 pieces/case case 1000 $88.00 0 $0.00 0
FACL6828C7 Fantasy Assorted Colors Lubricated Condoms 1000 pieces/case case 1000 $88.00 0 $0.00 0
FALL6808C7 Fantasy Lubricated Condoms 1000 pieces/case case 1000 $88.00 0 $0.00 0
KIML2014C7 Kimono MAXX Large lubricated condoms-1000 pieces/case case 1008 $137.00 0 $0.00 0
KILL1100C7 Kimono Thin lubricated condoms-1000 pieces/case case 1000 $117.00 0 $0.00 0
OBDM6030B4 Latex Dental Dams- Mixed Assorted Flavors, 100 pieces/box box 100 $62.00 0 $0.00 0
LFXL5900C8 Lifestyles Extra Strength Lubricated condoms, 1008 pieces/case case 1008 $79.80 0 $0.00 0
LFCL5300C8 LifeStyles Assorted Colors 1000 pieces/case Case 1000 $79.80 0 $0.00 0
LFKY9800C8 LifeStyles Large Condoms, 1008 pieces/case case 1008 $79.80 0 $0.00 0
LFFF6800C8 LifeStyles Luscious Flavors Assorted Flavors, 1008 pieces/case case 1008 $79.80 0 $0.00 0
LFBL5600C8 LifeStyles Ribbed Pleasure Lubricated Condoms, 1008 pieces/case case 1008 $79.80 0 $0.00 0
LFRR4541C8 LifeStyles Rough Rider Lubricated Bulk Pack, 1008 pieces/case case 1008 $79.80 0 $0.00 0
LFTL6200C8 LifeStyles Tuxedo Lubricated Bulk Pack, 1008 pieces/case case 1008 $79.80 0 $0.00 0
LFNF6400C8 LifeStyles Ulta-Thin lubricated bulk pack, 1008 pieces/case case 1008 $79.80 0 $0.00 0
LFLL5800C8 LifeStyles Ultra Lubricated Bulk Pack, 1008 pieces/case case 1008 $79.80 0 $0.00 0
MDHHS HAPIS Condom Pricing 2024
69
Instructions: Please complete gray shaded areas and upload form in SHOARS
Agency
Shipping Address
Item Number Description UOM Pieces Price/Unit QTY Total
Total #
Pieces
MDHHS HAPIS Condom Pricing 2024
LFSK0147C8 LifeStyles SKYN Original Non-Latex Condoms, 1008 pieces/case case 1008 $386.00 0 $0.00 0
LFSK0147G5 LifeStyles SKYN Original Non-Latex Condoms, 144 per bag bag 144 $58.00 0 $0.00 0
LFSK0149C8 LifeStyles SKYN Large Elite Non-Latex Condoms, 1008 per case case 1008 $419.00 0 $0.00 0
LFSK0149G5 LifeStyles SKYN Large Elite Non-Latex Condoms, 144 per bag bag 144 $63.00 0 $0.00 0
LFSK0151C8 LifeStyles SKYN Thin Elite Non-Latex Condoms, 1008 per case case 1008 $419.00 0 $0.00 0
LFSK0151G5 LifeStyles SKYN Thin Elite Non-Latex Condoms, 144 per bag bag 144 $63.00 0 $0.00 0
TJM64714D2 Trojan Magnum XL 12's, bundle of 4 x 12ct = 48 condoms pack 48 $33.97 0 $0.00 0
TJM04209C7 Trojan Magnum Lubricated Condoms, 1000 pieces/case case 1000 $389.00 0 $0.00 0
TJE03709C7 Trojan ENZ Condoms, 1000 pieces/case case 1000 $279.00 0 $0.00 0
TRAS8050C7 Trustex Assorted Flavored Lubricated Condoms, 1000 pieces/case case 1000 $125.00 0 $0.00 0
TRXL8901C7 Trustex Extra Strength Lubricated, 1000 pieces/case case 1000 $93.00 0 $0.00 0
TRLL8826C7 Trustex lubricated condoms, 1000 pieces/case case 1000 $88.00 0 $0.00 0
TRML8905C7 Trustex Extra Large Lubricated Condoms 1000 pieces/case case 1000 $98.00 0 $0.00 0
TRPC8828C7 Trustex Paired Colored Latex Condom + Lube 1000 pieces/case case 1000 $143.00 0 $0.00 0
TRPL8823C7 Trustex Paired Latex Condom + Lube 1000 pieces/case case 1000 $138.00 0 $0.00 0
BC101001C7 B Condoms Classic Ultra Lubricated 1000 pieces/case case 1000 $96.00 0 $0.00 0
BC101009C7 B Condoms Ultra Thin 1000 pieces/case case 1000 $99.00 0 $0.00 0
BC101008C7 B Condoms Ultra Sensitive 1000 pieces/case case 1000 $99.00 0 $0.00 0
BC101006C7 B Condoms Studded 1000 pieces/case case 1000 $99.00 0 $0.00 0
BC101005C7 B Condoms Ribbed 1000 pieces/case case 1000 $99.00 0 $0.00 0
BC101002C7 B Condoms XL Platinum Large Sized lubricated condoms 1000 pieces/case case 1000 $102.00 0 $0.00 0
0 $0.00 0
70
Instructions: Please complete gray shaded areas and upload form in SHOARS
Agency
Shipping Address
Item Number Description UOM Pieces Price/Unit QTY Total
Total #
Pieces
MDHHS HAPIS Condom Pricing 2024
Lubricant
IDDFRF03C7 ID FREE Glycerin & Paraben Free Personal Lubricant 4ml Foils (1000/case)case 1000 $135.00 0 $0.00 0
IDDFRF03G5 ID FREE Glycerin & Paraben Free Personal Lubricant 4ml Foils (144/bag)bag 144 $23.33 0 $0.00 0
IDDFRT12C5 ID FREE Glycerin & Paraben Free Personal Lubricant 12ml Resealable Tubes (500/case)case 500 $298.70 0 $0.00 0
IDDGLF07C5 ID Glide Personal Lubricant 7.5ml Foils (500/case)case 500 $81.00 0 $0.00 0
IDDGLP03C7 ID Glide Personal Lubricant 3ml Pillows (1000/case)case 1000 $200.00 0 $0.00 0
IDDGLP10C7 ID Glide Personal Lubricant 10ml Pillows (1000/ Case)case 1000 $330.00 0 $0.00 0
IDDGLT12C5 ID Glide Personal Lubricant 12ml Resealable Tubes (500/case)case 500 $261.00 0 $0.00 0
IDDKRP10C5 ID Jelly Lubricant 10ml Pillows Case (500/case)case 500 $165.00 0 $0.00 0
IDDKRT12C5 ID Jelly Lubricant 12ml Resealable Tubes (500/case)case 500 $261.00 0 $0.00 0
IDDTXF03C7 ID Frutopia Assorted Flavors Lubricant 3ml Foils (1000/case)case 1000 $130.00 0 $0.00 0
IDDTXF03G5 ID Frutopia Assorted Flavors Lubricant 3ml Foils (144/bag)bag 144 $21.60 0 $0.00 0
IDDMLF02C5 ID Millennium 2ml Foil (case of 500)case 500 $75.00 0 $0.00 0
IDDMLT10C5 ID Millennium 12ml Tube (Case of 500)case 500 $295.00 0 $0.00 0
IDDBCTC1CE ID Backslide Lubricant 8ml Long Neck Tubes (144/box)box 144 $147.67 0 $0.00 0
SLPILSGPC5 Slippery Stuff Gel 3cc Pillows (500/bag)bag 500 $161.00 0 $0.00 0
RNLP5600C7 Rain unflavored .25 oz lubricant pillows (1000/case)case 1000 $426.98 0 $0.00 0
RNLP5000J2 Rain unflavored .25 oz lubricant pillows (jar of 144)jar 144 $73.00 0 $0.00 0
RNLF5800C7 Rain flavored Rain Drops .25oz Assorted Flavors Lubricant Pillows (1000/case)case 1000 $436.51 0 $0.00 0
RNLF5200J2 Rain flavored Rain Drops .25oz Assorted Flavors Lubricant Pillows (jar of 144)jar 144 $76.17 0 $0.00 0
0 $0.00 0
0 $0.00 0
71
MONTH
CONTRACT
ADJUST
WRITEOFF
BAD DEBT
WRITEOFF Totals
January 2024 (1,025.55)(21,520.76)(22,546.31)
February 2024 (1,618.47)(11,112.75)(12,731.22)
March 2024 (3,026.59)(13,049.26)(16,075.85)
Totals (5,670.61)(45,682.77)(51,353.38)
Department Health and Human Services
FY 2024 Second Quarter Write-Offs (Jan.- Mar. 2024)
Dept. HHS FY 2024 Write-Offs 2nd Qtr Write-Offs 2nd Qtr72