HomeMy WebLinkAboutResolutions - 2023.03.23 - 38080
AGENDA ITEM: Fiscal Year 2023 First Quarter Forecast
DEPARTMENT: Management and Budget
MEETING: Board of Commissioners
DATE: Thursday, March 23, 2023 9:30 AM - Click to View Agenda
ITEM SUMMARY SHEET
COMMITTEE REPORT TO BOARD
Resolution #2023-2721 _ 23-50
Motion to adopt the attached suggested resolution.
ITEM CATEGORY SPONSORED BY
Budget Amendment Gwen Markham
INTRODUCTION AND BACKGROUND
Attached please find the Fiscal Year 2023 First Quarter Forecast. Pursuant to Section 8 of Public
Act 139 of 1973, this forecast provides updated financial projections for the current fiscal year based
on revenue and expenditure activity through the first quarter of the fiscal year (ending December
31). The quarterly forecasting process seeks to ensure that no individual department overspends its
appropriated budget at year end and provides countywide information on forecasted revenues and
expenditure for use by the Board of Commissioners, Department of Management and Budget, and
the public.
BUDGET AMENDMENT REQUIRED: No
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
Kyle Jen, Director Management & Budget-APP
Kymberly Coy, Chief Fiscal Services
ITEM REVIEW TRACKING
Gwen Markham, Board of Commissioners Created/Initiated - 3/23/2023
David Woodward, Board of Commissioners Approved - 3/23/2023
Hilarie Chambers, Executive's Office Approved - 3/24/2023
Lisa Brown, Clerk/Register of Deeds Final Approval - 3/24/2023
AGENDA DEADLINE: 03/23/2023 9:30 AM
ATTACHMENTS
1. Fiscal Year 2023 First Quarter Forecast
2. ARP Carryforward FY 2022
COMMITTEE TRACKING
2023-03-15 Finance - Recommend to Board
2023-03-23 Full Board - Adopt
Motioned by: Commissioner Michael Gingell
Seconded by: Commissioner Janet Jackson
Yes: David Woodward, Michael Gingell, Penny Luebs, Karen Joliat, Kristen Nelson, Christine
Long, Philip Weipert, Gwen Markham, Angela Powell, Marcia Gershenson, Janet Jackson,
Yolanda Smith Charles, Charles Cavell, Brendan Johnson (14)
No: None (0)
Abstain: None (0)
Absent: William Miller III, Michael Spisz, Gary McGillivray, Ajay Raman (4)
Passed
March 23, 2023
RESOLUTION #2023-2721 _ 23-50
Sponsored By: Gwen Markham
Management and Budget - Fiscal Year 2023 First Quarter 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) 2023 First Quarter Financial Forecast Report has identified several
variances and budget amendments are recommended as detailed in the attached Schedule A and B
budget amendment; and
WHEREAS Department of Public Services, Animal Shelter and Pet Adoption Center received
donations for the period of October 2022 through December 2022 totaling $20,016.32; and
WHEREAS Children’s Village Division received donations for the period of October 2022 through
December 2022 totaling $18,326 of which $180 were cash donations; and
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year
2023 First Quarter Financial Report.
BE IT FURTHER RESOLVED that the donations be recognized in the Children’s Village Division and
Animal Shelter and Pet Adoption Center.
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 Fiscal Year 2023 – FY 2025 Budgets are amended pursuant
to Schedules A and B.
Chair, the following Commissioners are sponsoring the foregoing Resolution: Gwen Markham.
Date: March 23, 2023
David Woodward, Commissioner
Date: March 24, 2023
Hilarie Chambers, Deputy County Executive II
Date: March 24, 2023
Lisa Brown, County Clerk / Register of Deeds
COMMITTEE TRACKING
2023-03-15 Finance - Recommend to Board
2023-03-23 Full Board - Adopt
Motioned by Commissioner Michael Gingell seconded by Commissioner Janet Jackson to adopt the
attached Budget Amendment: Fiscal Year 2023 First Quarter Forecast.
Yes: David Woodward, Michael Gingell, Penny Luebs, Karen Joliat, Kristen Nelson, Christine
Long, Philip Weipert, Gwen Markham, Angela Powell, Marcia Gershenson, Janet Jackson,
Yolanda Smith Charles, Charles Cavell, Brendan Johnson (14)
No: None (0)
Abstain: None (0)
Absent: William Miller III, Michael Spisz, Gary McGillivray, Ajay Raman (4)
Passed
ATTACHMENTS
1. Fiscal Year 2023 First Quarter Forecast
2. ARP Carryforward FY 2022
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 March
23, 2023, 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, March 23, 2023.
Lisa Brown, Oakland County Clerk / Register of Deeds
OAKLAND COUNTY EXECUTIVE DAVID COULTER
2100 Pontiac Lake Road | County Executive Building 41W | Waterford, MI 48328 | Fax (248) 452-9172 | OakGov.com
TO: Members of the Finance Committee
FROM: Kyle I. Jen, Chief Financial Officer and Director of Management and Budget
Sheryl Johnson, Manager, Fiscal Services
Kymberly Coy, Chief, Fiscal Services
Ebru Adoglu-Jones, Supervisor, Fiscal Services
SUBJECT: Fiscal Year 2023 First Quarter Forecast
DATE: March 9, 2023
Attached please find the Fiscal Year 2023 First Quarter Forecast. Pursuant to Section 8 of Public Act
139 of 1973, this forecast provides updated financial projections for the current fiscal year based on revenue
and expenditure activity through the first quarter of the fiscal year (ending December 31). The quarterly
forecasting process seeks to ensure that no individual department overspends its appropriated budget at
year end and provides countywide information on forecasted revenues and expenditure for use by the Board
of Commissioners, Department of Management and Budget, and the public.
Beginning with this forecast, we are implementing improvements to the quarterly forecast process to (1)
provide more consistency in how financial information is forecasted across all departments, (2) make the
overall results of each forecast more understandable and useful for financial planning, and (3) enhance
communication and collaboration with departments regarding their financial activities. We welcome your
feedback on the changes to the format of the report, which provides a condensed one-page summary for
each General Fund department. Additional detail for each department is available upon request.
Revenue Forecast
Total General Fund revenues are forecasted to be $1.6 million higher than the revenue amounts included in
the Amended FY 2023-2025 County Budget. This is the net result of:
•Higher forecasted property tax revenues of $5.2 million due to 2023 taxable values exceeding
previous estimates.
•Approximately $776,000 in higher revenue from Federal Grants and Investment Income
•Lower forecasted Charges for Services of $4.3 million due to lower-than-budgeted service activity in
several departments
•Approximately $52,000 in lower revenue from Other Intergovernmental Revenues and Other
Revenues
Expenditure Forecast
Total General Fund Expenditures are forecasted to be $1.2 million lower than the expenditure amounts
included in the Amended FY 2023-2025 County Budget. This is the net result of:
•Lower forecasted expenditures in departmental budgets totaling $19.5 million. Lower expenditures
are forecasted across all departments due to a combination of personnel vacancies/turnover and
lower-than-budgeted operating and internal service costs.
•Higher non-departmental expenditures of $18.3 million. This is primarily the result of zeroing out the
$10 million personnel turnover factor and $8 million operating favorability factor included in the
1
2100 Pontiac Lake Road | County Executive Building 41W | Waterford, MI 48328 | Fax (248) 452-9172 | OakGov.com
Adopted Budget, as those projected savings are now reflected in individual departmental budgets as
described above.
Where expenditures are projected to exceed appropriated amounts at the controllable category level
(personnel/operating/internal services), we are working with those departments to make adjustments to their
spending and/or make appropriate budget adjustments where appropriate. In most cases the projected over-
expenditure amounts are a result of internal service budgets needing to be adjusted to reflect actual service
usage. No expenditure projections in this forecast are a critical cause for concern at this point in the fiscal
year.
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 $67.6 million in Planned Use of Fund Balance:
•The largest portion of this is $39.8 million appropriated by the Board of Commissioners to fund a
settlement of the Rafaeli-related legal cases, from the fund balance assignment that had been
reserved by the Board and Administration for such an action.
•An additional $19.9 million is for carryforwards and encumbrances approved with the FY 2022 year-
end report, funded from unexpended funds in the FY 2022 budget.
•The remaining $7.9 million is attributable to one-time spending items included in the FY 2022
Adopted Budget for road programs, IT development, and other purposes.
In total, this forecast expects Planned Use of Fund Balance to be $2.8 million lower than assumed in the
amended budget, at $64.7 million. This would result in an FY 2023 ending General Fund balance of $205.7
million, which equates to 41.0% of the County’s ongoing FY 2023 General Fund budget of $501.7 million.
This is well above the minimum 25% and target 30% levels established in the County’s Fund Balance
Policy.
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 2023 fund balance. Those
factors will be accounted for in the second and third quarter forecasts and the FY 2023 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 2023
Amendment
FY 2024
Amendment
FY 2025
Amendment
E General Fund Pros. Admin FND10100 CCN4010101 SC712090 PRG122000 702000 On Call 1,000.00$ 1,000.00$ 1,000.00$
E General Fund Pros. Litigation FND10100 CCN4010201 SC712090 PRG122050 702000 On Call 4,000.00 4,000.00 4,000.00
E General Fund Pros Warrants FND10100 CCN4010301 SC712090 PRG122050 702000 On Call (5,000.00) (5,000.00) (5,000.00)
-$ -$ -$
E General Fund Pros. Admin FND10100 CCN4010101 SC702010 PRG122050 702000 Salaries (7,500.00)$ -$ -$
E General Fund Pros. Admin FND10100 CCN4010101 SC730373 PRG122050 730000 Contracted Services 7,500.00 - -
-$ -$ -$
R General Fund Inv. & Forensic Svcs FND10100 CCN4030901 RC695500 PRG110090 FND21341 695500 Transfers In - Law Enforcement Enhance State 6,821.00$ -$ -$
R General Fund Emergency Comm Ops FND10100 CCN4030701 RC695500 PRG116230 FND21396 695500 Transfers In - Sheriff Dispatch Training 11,759.00 - -
R General Fund Corrective Services FND10100 CCN4030301 RC695500 PRG112620 FND21397 695500 Transfers In - Sheriff Booking Fee Training 7,184.00 - -
R General Fund Non Departmental FND10100 CCN9010101 RC665882 PRG196030 665882 Planned Use of Balance (6,821.00) - -
18,943.00$ -$ -$
E General Fund Emergency Comm Ops FND10100 CCN4030701 SC731304 PRG116230 730000 Officers Training (Dispatch)11,759.00 - -
E General Fund Corrective Services FND10100 CCN4030301 SC731304 PRG112620 730000 Officers Training (Corrections)7,184.00 - -
18,943.00$ -$ -$
R Law Enforcement
Enhance State
Inv. & Forensic Svcs FND21341 CCN4030901 RC665882 PRG110090 665882 Planned Use of Balance 6,821.00$ -$ -$
Total Revenue 6,821.00$ -$ -$
E Law Enforcement
Enhance State
Inv. & Forensic Svcs FND21341 CCN4030901 SC788001 PRG110090 FND10100 788001 Transfers Out - General Fund 6,821.00$ -$ -$
Total Expenditures 6,821.00$ -$ -$
R Dispatch Training Emergency Comm Ops FND21396 CCN4030701 RC665882 PRG112630 665882 Planned Use of Balance 11,759.00$ -$ -$
Total Revenue 11,759.00$ -$ -$
E Dispatch Training Emergency Comm Ops FND21396 CCN4030701 SC788001 PRG112630 FND10100 788001 Transfers Out - General Fund 11,759.00$ -$ -$
Total Expenditures 11,759.00$ -$ -$
R Sheriff Booking
Fee Training
Corrective Services FND21397 CCN4030301 RC665882 PRG112620 665882 Planned Use of Balance 7,184.00$ -$ -$
Total Revenue 7,184.00$ -$ -$
E
Sheriff Booking
Fee Training Corrective Services FND21397 CCN4030301 SC788001 PRG112620 FND10100 788001 Transfers Out - General Fund 7,184.00$ -$ -$
Total Expenditures 7,184.00$ -$ -$
E General Fund Emergency Comm Ops FND10100 CCN4030701 SC730646 PRG116230 730000 Equipment Maintenance (5,000.00)$ (5,000.00)$ (5,000.00)$
E General Fund Technology Info & Innov.FND10100 CCN4030801 SC731213 PRG110085 730000 Membership Dues 500.00 500.00 500.00
Oakland County, Michigan
Schedule "A" DETAIL - General Fund/General Purpose
WHEREAS a FY 2023 budget amendment is recommended for the Prosecuting Attorney reallocating $7,500 from Salaries (SC702010) to Contracted Services (SC730373) as this intern position is contracted through the Prosecuting Attorney Association of Michigan (PAAM); and
SHERIFF'S OFFICE
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 $25,764 are being recognized for eligible
personnel, forensic lab and training costs for dispatchers and corrections officers; and
Sheriff's Office - Law Enforcement Restricted Funds
PROSECUTING ATTORNEY
WHEREAS a FY 2023 - FY 2025 budget amendment of $5,000 is recommended for the Prosecuting Attorney's reallocating the On Call expenditure line item budget by program to more accurately reflect actual spending; and
4
E General Fund Technology Info & Innov.FND10100 CCN4030801 SC731213 PRG112680 730000 Membership Dues 500.00 500.00 500.00
E General Fund Technology Info & Innov.FND10100 CCN4030801 SC731458 PRG110085 730000 Professional Services (75,000.00) (75,000.00) (75,000.00)
E General Fund Technology Info & Innov.FND10100 CCN4030801 SC731458 PRG112680 730000 Professional Services 75,000.00 75,000.00 75,000.00
E General Fund Technology Info & Innov.FND10100 CCN4030801 SC750294 PRG112680 750000 Material and Supplies 1,000.00 1,000.00 1,000.00
E General Fund Technology Info & Innov.FND10100 CCN4030801 SC750399 PRG112680 750000 Office Supplies 2,000.00 2,000.00 2,000.00
E General Fund Technology Info & Innov.FND10100 CCN4030801 SC750581 PRG112680 750000 Uniforms 500.00 500.00 500.00
E General Fund Technology Info & Innov.FND10100 CCN4030801 SC750581 PRG110085 750000 Uniforms 500.00 500.00 500.00
-$ -$ -$
E General Fund Non-Department FND10100 CCN9090101 SC731822 PRG196010 730000 Non-Dept. Special Projects (25,000.00)$ -$ -$
E General Fund Board Of Commissioners FND10100 CCN5010101 SC731822 PRG180010 730000 BOC - Special Projects 25,000.00 - -
Total Expenditures -$ -$ -$
E General Fund Non-Department FND10100 CCN9090101 SC731822 PRG196010 730000 Non-Dept. Special Projects (100,000.00)$ -$ -$
E General Fund Board Of Commissioners FND10100 CCN5010101 SC731822 PRG180010 730000 BOC - Special Projects 100,000.00$ -$ -$
Total Expenditures -$ -$ -$
E General Fund Corporation Counsel FND10100 CCN1010501 SC774636 PRG181020 770000 IT Operations 28,200.00 - -
E General Fund Board Of Commissioners FND10100 CCN1010501 SC788001 PRG181020 BFA63600 730000 Transfers Out 28,200.00 28,200.00 28,200.00
Total Expenditures 56,400.00$ 28,200.00$ 28,200.00$
R IT Fund IT Administration FND63600 CCN1080101 RC695500 PRG152000 695500 Transfers In 28,200.00$ 28,200.00$ 28,200.00$
Total Revenue 28,200.00$ 28,200.00$ 28,200.00$
E IT Fund IT Application Services FND63600 CCN1080201 SC730373 PRG152010 730000 Contracted Services 28,200.00$ 28,200.00$ 28,200.00$
Total Expenses 28,200.00$ 28,200.00$ 28,200.00$
E General Fund Medical Examiner FND10100 CCN1070601 SC702010 PRG132030 702000 Salaries Regular (55,500.00)$ -$ -$
E General Fund Medical Examiner FND10100 CCN1070601 SC722900 PRG132030 722000 Fringe Benefit Adjustment (27,750.00) - -
E General Fund Medical Examiner FND10100 CCN1070601 SC731458 PRG132030 730000 Professional Services 83,250.00 - -
-$ -$ -$
R General Fund Animal Control FND10100 CCN1070601 SC630028 PRG132130 630000 Adoptions 51.00$ -$ -$
R General Fund Animal Control FND10100 CCN1070601 SC630070 PRG114050 630000 Animal Shots/Dog 544.00 - -
R General Fund Animal Control FND10100 CCN1070801 RC630074 PRG114115 630000 Animal Serlization Fees 3,905.00 - -
R General Fund Animal Control FND10100 CCN1070801 RC631988 PRG114090 630000 Sale of Licenses 540.00 - -
R General Fund Animal Control FND10100 CCN9010101 RC665882 PRG196030 665882 Planned Use of Balance (5,040.00) - -
-$ -$ -$
E General Fund Childrens Village FND10100 CCN1070701 SC774677 PRG112090 770000 Insurance Fund (24,106.00)$ -$ -$
COUNTY EXECUTIVE
WHEREAS a FY 2023 budget amendment is recommended for the Medical Examiners Division reallocating Salaries and Fringe Benefits favorability to Professional Services due to the Professional Services contracted pathologist actual cost; and
Medical Examiner
WHEREAS a FY 2023 budget amendment is recommended for the Animal Control Division to accept reimbursement funding totaling $5,040 of which $1,955 is from the July 11th - 31st Bissel Pet Foundation's Empty the Shelter event amd $3,100 is from the May 2nd - May 8th Event.
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
Animal Control
Public Services
Children's Village
WHEREAS a FY 2023 - FY 2025 budget amendment totaling $80,000 is recommended for the Sheriff's Office budget reallocating the expenditure line item budgets to more accurately reflect actual spending; and
WHEREAS a FY 2023 budget amendment is recommended for the Board of Commissioners for a one-time apppropiation of $25,000 from Non-Departmental Transfers - Special Projects for the sponsorship of Noble Odyssey Foundation's 2023 Youth Maritime Underwater Interest
Development Program; and
BOARD OF COMMISSIONERS
WHEREAS a FY 2023 - FY 2025 budget amendment is recommended for Corporation Counsel transferring funds to Information Technology (#63600) for the ongoing application services and maintenance of the county's public request Management software; and
WHEREAS a FY 2023 budget amendment is recommended for the Board of Commissioners for a one-time apppropiation of $100,000 from Non-Departmental Transfers - Special Projects for the sponsorship of the City of Pontiac's 2023 Arts Commission Program; and
Corporation Counsel
5
E Child Care Fund Childrens Village FND20293 CCN1070701 SC774677 PRG112090 770000 Insurance Fund 24,106.00 - -
Total Expenditures -$ -$ -$
R Child Care Fund Children's Village FND20293 CCN1070701 RC631869 PRG112200 630000 Reimb Salaries 479,332$ -$ -$
Total Revenues 479,332$ -$ -$
E Child Care Fund Children's Village FND20293 CCN1070701 SC702010 PRG112200 702000 Salaries Regular 479,332$
Total Expenditures 479,332$ -$ -$
E
General Fund-
Grants Veteran's Services FND10101 CCN1090401 SC732011 PRG132080 GRN-1003984 730000 Transportation (80,000.00)$ -$ -$
E
General Fund-
Grants Veteran's Services FND10101 CCN1090401 SC750245 PRG132050 GRN-1003984 750000 Incentives 82,750.00 - -
E
General Fund-
Grants Veteran's Services FND10101 CCN1090401 SC732165 PRG132050 GRN-1003984 730000 Workshop and Meetings (2,750.00) - -
-$ -$ -$
R General Fund Veteran's Services FND10100 CCN1090401 RC631827 PRG132050 630000 Reimburesement General 4,782.00$ -$ -$
4,782.00$ -$ -$
E General Fund Veteran's Services FND10100 CCN1090401 SC732018 PRG132050 730000 Travel and Conference 4,782.00$ -$ -$
4,782.00$ -$ -$
E General Fund Economic Development FND10100 CCN1090101 SC731822 PRG171000 730000 Special Projects (25,000.00)$ -$ -$
E General Fund Public Communications FND10100 CCN1210101 SC731822 PRG172072 730000 Special Projects 25,000.00 - -
-$ -$ -$
R
General Fund-
Grants Homeland Security FND10101 CCN1110101 RC610313 PRG115180 GRN-1003863 610000 Federal Operating Grant 7,821.00$ -$ -$
7,821.00$ -$ -$
E
General Fund-
Grants Homeland Security FND10101 CCN1110101 SC702010 PRG115180 GRN-1003863 702000 Salaries Regular 5,084.00$ - -
E
General Fund-
Grants Homeland Security FND10101 CCN1110101 SC722900 PRG115180 GRN-1003863 722000 Fringe Benefit Adjustment 2,737.00 - -
7,821.00$ -$ -$
R General Fund Non-Department FND10100 CCN9010101 RC665882 PRG196010 665882 Planned Use of Balance 746,127.00$ -$ -$
Total Revenue 746,127.00$ -$ -$
E General Fund Non-Department FND10100 CCN9090101 SC760126 PRG196030 760000 Miscellaneous Capital Outlay 746,127.00$ -$ -$
ECONOMIC DEVELOPMENT DEPARTMENT
Veteran's Services
WHEREAS a FY 2023 budget amendment of $25,000 is recommended to reallocate the budget for the Fire and Ice Festival from Economic Development Administration Division to the Department of Public Communications; and
Economic Development /Department of Public Communications
Children's Village
WHEREAS a FY 2023 Budget Amendment is recommended for the Children's Village Division due to avaialable funding from Michigan Department Health and Human Services (MDHHS) Child Caring Institution Direct Care Worker Wage Pass Through State Reimbursement for one-
time bonuses paid to direct care employees. A direct care worker is a frontline worker who provides direct care and supervision of children in an institution; and
NON-DEPARTMENT
WHEREAS a FY 2023 budget amendment of $82,275 is recommended for the Veterans' Service Division to reallocate funds by reducing Transportation ($80,000), Workshop and Meetings (2,750) and increasing Incentives $82,750 to recognize the 2023 County Veteran Service Fund
Grant Amendment #1 which is within fifteen percent of the FY 2023 County Veteran Service Fund Acceptance (M.R. #22345); and
WHEREAS a FY 2023 budget amendment of $4,782 is recommended for the Veterans' Service Division to accept funding for the 2022 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 does not require an associated interlocal agreement, there are no position changes and the grantor does not require a separate resolution; and
Veteran's Services
WHEREAS a FY 2023 budget amendment of $7,821 is recommended for the Emergency Management and Homeland Security to recognize 2022 Hazardous Materials Emergency Preparedness Planning Program (HMEP) Amendment #1 which is within 15% of the original 2022
Hazardous Materials Emergency Preparedness Planning Program (HMEP) acceptance (M.R. #22233). The additional funding increases the original award from $11,500 to $19,321 along with the County's in-kind match increasing from $2,888 to $4,830 which is met with staff salary to
support Oakland County's Local Emergency Planning Committee; and
WHEREAS a FY 2023 Budget Amendment is recommended for the Children's Village Division correcting a data entry error for the Insurance Fund account allocation as it was budgeted in error to the General Fund rather than the Child Care Fund during the FY 2023 - FY 2025 budget
development phase; and
EMERGENCY MANAGEMENT & HOMELAND SECURITY
6
Total Expenditure 746,127.00$ -$ -$
E General Fund Non-Department FND10100 CCN9090101 SC731822 PRG196010 730000 Non-Dept. Special Projects (100,000.00)$ -$ -$
E General Fund Board Of Commissioners FND10100 CCN5010101 SC731822 PRG180010 730000 BOC - Special Projects 100,000.00$ -$ -$
Total Expenditures -$ -$ -$
E General Fund Non-Department FND10100 CCN9090101 SC731822 PRG196010 730000 Non-Dept. Special Projects (25,000.00)$ -$ -$
E General Fund Board Of Commissioners FND10100 CCN5010101 SC731822 PRG180010 730000 BOC - Special Projects 25,000.00 - -
Total Expenditures -$ -$ -$
R General Fund Non-Department FND10100 CCN9010101 RC601637 PRG196000 601000 Property Tax Levy 5,185,296$ - -
R General Fund Non-Department FND10100 CCN9010101 RC665882 PRG196030 665882 Planned Use of Balance (1,939,096) - -
3,246,200$ - -
E General Fund Non-Department FND10100 CCN9090101 SC730800 PRG196030 730000 Grant Match 746,200$ - -
E General Fund Non-Department FND10100 CCN9090101 SC730359 PRG196030 7300000 Contingency 2,500,000 - -
Total Expenditures 3,246,200$ - -
WHEREAS a FY 2023 budget amendment is recommended for Non-Departmental General Fund/General Purpose (10100) to recognize increased property tax revenue, reduce planned use of fund balance, and adjust non-departmental expenditure amounts.
WHEREAS a FY 2023 budget amendment is recommended for the Board of Commissioners for a one-time apppropiation of $100,000 from Non-Departmental Transfers - Special Projects for the sponsorship of the City of Pontiac's 2023 Arts Commission Program; and
WHEREAS a FY 2023 budget amendment is recommended for the Board of Commissioners for a one-time apppropiation of $25,000 from Non-Departmental Transfers - Special Projects for the sponsorship of Noble Odyssey Foundation's 2023 Youth Maritime Underwater I
nterest Development Program; and
WHEREAS a FY 2023 budget amendment is recommended for Non-Departmental General Fund/General Purpose (10100) to appropriate to $747,127 from unassigned fund balance to Miscellaneous Captial Outlay as it was inadvertently omitted from the FY 2022 Year End Report.
7
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 2023
Amendment
FY 2024
Amendment
FY 2025
Amendment
R Law Enforcement Grants Patrol Services FND11005 CCN4030601 RC631253 PRG116200 GRN-1004059 630000 Miscellaneous Revenue 7,460.00$ -$ -$
7,460.00$ -$ -$
E Law Enforcement Grants Patrol Services FND11005 CCN4030601 SC750294 PRG116200 GRN-1004059 750000 Material and Supplies 7,460.00$ -$ -$
7,460.00$ -$ -$
E Law Enforcement Grants Inv. & Forensic Svcs FND11005 CCN4030901 SC702010 PRG116240 GRN-0001148 702000 Salaries (5,617.00)$
E Law Enforcement Grants Inv. & Forensic Svcs FND11005 CCN4030901 SC722900 PRG116240 GRN-0001148 722000 Fringe Benefits (2,898.00)$ -$ -$
E Law Enforcement Grants Inv. & Forensic Svcs FND11005 CCN4030901 SC750280 PRG116240 GRN-0001148 750000 Laboratory Supplies 8,515.00$
-$ -$ -$
R Human Service Grants Health FND11007 CCN1060201 RC610313 PRG133150 GRN-1004024 610000 Federal Operating Grants 50,000.00$ - -
50,000.00$ -$ -$
E Human Service Grants Health FND11007 CCN1060201 SC702010 PRG133150 GRN-1004024 702000 Salaries 19,724.00$ - -
E Human Service Grants Health FND11007 CCN1060201 SC722740 PRG133150 GRN-1004024 722000 Fringe Benefits 10,100.00 - -
E Human Service Grants Health FND11007 CCN1060201 SC730926 PRG133150 GRN-1004024 730000 Indirect Costs 2,726.00 - -
E Human Service Grants Health FND11007 CCN1060201 SC731458 PRG133150 GRN-1004024 730000 Professional Services 13,000.00 - -
E Human Service Grants Health FND11007 CCN1060201 SC732018 PRG133150 GRN-1004024 730000 Travel and Conference 375.00 - -
E Human Service Grants Health FND11007 CCN1060201 SC750294 PRG133150 GRN-1004024 750000 Materials and Supplies 3,575.00 - -
E Human Service Grants Health FND11007 CCN1060201 SC730982 PRG133150 GRN-1004024 730000 Interpreter Fees 500.00 - -
50,000.00$ -$ -$
R Human Service Grants Health FND11007 CCN1060201 RC631827 PRG133150 GRN-1004072 630000 Reimb General 5,000$ - -
5,000$ -$ -$
E Human Service Grants Health FND11007 CCN1060201 SC730373 PRG133150 GRN-1004072 730000 Contracted Services 5,000$ - -
5,000$ -$ -$
R Motor Pool
Support Services Lease
Vehicles FND66100 CCN1030811 RC695500 PRG184010 BFA21285 695500 Transfers In $ (38,732.00)-$ -$
R Motor Pool
Support Services Lease
Vehicles FND66100 CCN1030811 RC631071 PRG184010 630000 Leased Equipment (16,207.00)- -
R Motor Pool
Support Services Lease
Vehicles FND66100 CCN1030811 RC631610 PRG184010 630000 Productive Labor (5,183.00)- -
R Motor Pool
Support Services Lease
Vehicles FND66100 CCN1030811 RC631463 PRG184010 630000 Parts and Accessories (12,000.00)- -
R Motor Pool
Support Services Lease
Vehicles FND66100 CCN1030811 RC630833 PRG184010 630000 Gas Oil Grease Charges (4,895.00) - -
R Motor Pool
Support Services Lease
Vehicles FND66100 CCN1040210 RC695500 PRG184010 BFA21285 695500 Transfers In 38,732.00 - -
Oakland County, Michigan
Schedule "B" DETAIL - Special Revenue Grants / Proprietary Funds
WHEREAS a FY 2023 budget amendment is recommended for the Sheriff's Office to accept an award in the amoun of $7,460 for Safe Community First Responder grant to purchase oil/fuel spill equipment that would be available for the Region 2 Area (the City of Detroit, Macomb County,
Monroe County, Oakland County, St. Clair County, Washtenaw County and Wayne County). 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
SHERIFF GRANTS
HEALTH DEPARTMENT GRANTS
WHEREAS a FY 2023 budget amendment of $5,000 is recommended for the Health and Human Services Health Division to accept the Michigan Association for Local Public Health Grant (MALPH) award. The funding will be used to provide supportive services to local health department staff
affected by the COVID-19 pandemic and to bolster their sense of socail and emotional wellbeing. M.R. #19006 authorizes Management and Budget to administratively process grant agreements and grant amendments of $10,000 or less (or less than 15% variance from current award), 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
MOTOR POOL (#66100)
WHEREAS a FY 2023 budget amendment of $50,000 is recommended for Health and Human Services Health Division to recognize the FY 2023 Emerging Threats Local Health Department Amendment #2 for the Monkeypox Virus Response Program which is within 15% of the FY 2023
Emerging Threats Local Health Department acceptance (M.R. #22328). Amendment #2 increases total funding from $6,629,816 to $6,379,816; and
WHEREAS a FY 2023 budget amendment of $8,515 is recommended for the Sheriff's Office to revise the 2021 Capacity Enhancement Backlog Reduction (CEBR) Grant budget to utilize cost savings from a vacant analyst position to add a thermomixer, mini vortex mixer, mini centrifuge,
pipettes and scanners to Year 2 of the award budget; and
8
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 2023
Amendment
FY 2024
Amendment
FY 2025
Amendment
Oakland County, Michigan
Schedule "B" DETAIL - Special Revenue Grants / Proprietary Funds
R Motor Pool
Support Services Lease
Vehicles FND66100 CCN1040210 RC631071 PRG184010 630000 Leased Equipment 16,207.00 - -
R Motor Pool
Support Services Lease
Vehicles FND66100 CCN1040210 RC631610 PRG184010 630000 Productive Labor 5,183.00 - -
R Motor Pool
Support Services Lease
Vehicles FND66100 CCN1040210 RC631463 PRG184010 630000 Parts and Accessories 12,000.00 - -
R Motor Pool
Support Services Lease
Vehicles FND66100 CCN1040210 RC630833 PRG184010 630000 Gas Oil Grease Charges 4,895.00 - -
Total Revenues -$ -$ -$
E Motor Pool
Support Services Lease
Vehicles FND66100 CCN1030811 SC750210 PRG184010 750000 Gasoline Charges $ (4,895.00)-$ -$
E Motor Pool
Support Services Lease
Vehicles FND66100 CCN1030811 SC750413 PRG184010 750000 Parts and Accessories (12,000.00)- -
E Motor Pool
Support Services Lease
Vehicles FND66100 CCN1030811 SC761156 PRG184010 761000 Depreciation Vehicles (11,835.00)- -
E Motor Pool
Support Services Lease
Vehicles FND66100 CCN1030811 SC796500 PRG184010 796500 Budgeted Equity Adjustment (48,287.00) - -
E Motor Pool
Support Services Lease
Vehicles FND66100 CCN1040210 SC750210 PRG184010 750000 Gasoline Charges 4,895.00 - -
E Motor Pool
Support Services Lease
Vehicles FND66100 CCN1040210 SC750413 PRG184010 750000 Parts and Accessories 12,000.00 - -
E Motor Pool
Support Services Lease
Vehicles FND66100 CCN1040210 SC761156 PRG184010 761000 Depreciation Vehicles 11,835.00 - -
E Motor Pool
Support Services Lease
Vehicles FND66100 CCN1040210 SC796500 PRG184010 796500 Budgeted Equity Adjustment 48,287.00 - -
Total Expenses -$ -$ -$
R Motor Pool
Support Services Lease
Vehicles FND66100 CCN1040210 RC695500 PRG184010 695500 Transfers In (52,000.00)$ -$ -$
Total Revenues (52,000.00)$ -$ -$
E Motor Pool
Support Services Lease
Vehicles FND66100 CCN1040210 SC796500 PRG184010 796500 Budgeted Equity Fund 52,000.00$ -$ -$
Total Expenses 52,000.00$ -$ -$
R Motor Pool
Support Services Lease
Vehicles FND66100 CCN1040210 RC665882 PRG184010 665882 Planned Use Fund Balance (4,711.00)$ -$ -$
Total Revenues (4,711.00)$ -$ -$
E Motor Pool
Support Services Lease
Vehicles FND66100 CCN1040210 SC796500 PRG184010 796500 Budgeted Equity Fund 4,711.00$ -$ -$
Total Expenses 4,711.00$ -$ -$
E Motor Pool Support Services Lease
Vehicles
FND66100 CCN1040210 SC760188 PRG184010 760000 Capital Outlay-Vehicles (35,556.00)$ -$ -$
E Motor Pool Support Services Lease
Vehicles
FND66100 CCN1040210 SC760188 PRG184010 761000 Depreciation Expense-Vehicles 35,556.00$ -$ -$
Total Expenses -$ -$ -$
WHEREAS a FY 2023 Budget Amendment is recommended for the Motor Pool Fund (#66100) correcting the data entry error used for the Vehicles line item budget (SC760188) from ledger account summary (760000) to ledger account summary Depreciation Expense (761000); and
Oakland County Transit Fund (58800)
WHEREAS a FY 2023 Budget Amendment is recommended for the Motor Pool Fund (#66100) correcting the cost center number (CCN) used in creating the budget for the School Resource Officer (M.R. #22268) to address the safety concerns in the school district of the City of Pontiac.
M.R. #22048 transferred the positions to Facilities Management (Dept. 104) and deleted the Central Services Department (Dept. 103) and subordinate division numbers (CCN1030XXX); and
WHEREAS a FY 2023 Budget Amendment is recommended for the Motor Pool Fund (#66100) correcting the Transfers In Budget as it was a duplicate budget entry error during the development of FY 2023 - FY 2025 Adopted Budget; and
WHEREAS a FY 2023 Budget Amendment is recommended for the Motor Pool Fund (#66100) correcting the Planned Use Fund Budget as it is a data entry error for FY 2023 from the FY 2022 Year End Report; and
9
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 2023
Amendment
FY 2024
Amendment
FY 2025
Amendment
Oakland County, Michigan
Schedule "B" DETAIL - Special Revenue Grants / Proprietary Funds
R Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 RC60163 PRG112670 601000 Property Tax Levy (553,008.00)$ -$ -$
R Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 RC60163 PRG172155 601000 Property Tax Levy 553,008.00 - -
Total Revenues -$ -$ -$
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC702010 PRG112670 702000 Salaries (82,977.00)$ -$ -$
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC722740 PRG112670 722000 Fringe Benefits (39,881.00)- -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC750399 PRG112670 750000 Office Supplies (10,000.00)- -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC731388 PRG112670 730000 Printing (10,000.00)- -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC730072 PRG112670 730000 Advertising (10,000.00)- -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC732018 PRG112670 730000 Travel and Conference (10,000.00)- -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC731213 PRG112670 730000 Membership Dues (5,000.00)- -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC731346 PRG112670 730000 Personal Mileage (2,500.00)- -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC750511 PRG112670 750000 Special Event Supplies (2,500.00)- -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC731458 PRG112670 770000 Professional Services (100,000.00)- -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC774636 PRG112670 770000 Info Tech Operations (3,647.00)- -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC778675 PRG112670 770000 Telephone (248.00)- -
E Oakland Transit Fund OC Transit Services FND58800 CCN1090802 SC702010 PRG112670 702000 Salaries (107,355.00)- -
E Oakland Transit Fund OC Transit Services FND58800 CCN1090802 SC722740 PRG112670 722000 Fringe Benefits (58,972.00)- -
E Oakland Transit Fund OC Transit Services FND58800 CCN1090802 SC774636 PRG112670 770000 Info Tech Operations (9,432.00)- -
E Oakland Transit Fund OC Transit Services FND58800 CCN1090802 SC778675 PRG112670 770000 Telephone (496.00)- -
E Oakland Transit Fund OC Transit Services FND58800 CCN1090802 SC788001 PRG112670 BFA10100 788001 Transfers Out (100,000.00)- -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC702010 PRG172155 702000 Salaries 82,977.00 - -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC722740 PRG172155 722000 Fringe Benefits 39,881.00 - -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC750399 PRG172155 750000 Office Supplies 10,000.00 - -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC731388 PRG172155 730000 Printing 10,000.00 - -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC730072 PRG172155 730000 Advertising 10,000.00 - -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC732018 PRG172155 730000 Travel and Conference 10,000.00 - -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC731213 PRG172155 730000 Membership Dues 5,000.00 - -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC731346 PRG172155 730000 Personal Mileage 2,500.00 - -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC750511 PRG172155 750000 Special Event Supplies 2,500.00 - -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC731458 PRG172155 730000 Professional Services 100,000.00 - -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC774636 PRG172155 770000 Info Tech Operations 3,647.00 - -
E Oakland Transit Fund OC Transit Admin FND58800 CCN1090801 SC778675 PRG172155 770000 Telephone 248.00 - -
E Oakland Transit Fund OC Transit Services FND58800 CCN1090802 SC702010 PRG172155 702000 Salaries 107,355.00 - -
E Oakland Transit Fund OC Transit Services FND58800 CCN1090802 SC722740 PRG172155 722000 Fringe Benefits 58,972.00 - -
E Oakland Transit Fund OC Transit Services FND58800 CCN1090802 SC774636 PRG172155 770000 Info Tech Operations 9,432.00 - -
E Oakland Transit Fund OC Transit Services FND58800 CCN1090802 SC778675 PRG172155 770000 Telephone 496.00 - -
E Oakland Transit Fund OC Transit Services FND58800 CCN1090802 SC788001 PRG172155 BFA10100 788001 Transfers Out 100,000.00 - -
Total Expenses $ - $ - $ -
E CLEMIS IT CLEMIS FND53500 CCN1080301 SC702010 PRG116020 702000 Salaries (43,101.00)$ (43,963.00)$ (44,842.00)$
E CLEMIS IT CLEMIS FND53500 CCN1080301 SC722900 PRG116020 722000 Fringe Benefit Adjustments (32,909.00) (33,211.00) (33,518.00)
E CLEMIS IT CLEMIS FND53500 CCN1080301 SC788001 PRG116020 BFA53600 788001 Transfer Out – Radio 76,010.00 77,174.00 78,360.00
Total Expenditures -$ -$ -$
R Radio Communications IT Public Safety and Radio
Communications
FND53600 CCN1080310 RC695500 PRG115150 BFA53500 695500 Transfer In - CLEMIS 76,010.00$ 77,174.00$ 78,360.00$
Total Revenue 76,010.00$ 77,174.00$ 78,360.00$
INFORMATION TECHONOLOGY
WHEREAS a FY 2023 budget amendment is recommened for the Oakland County Transit fund (58800) to reallocate the budgeted line items between programs. A new program was established to track transit activities; and
10
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 2023
Amendment
FY 2024
Amendment
FY 2025
Amendment
Oakland County, Michigan
Schedule "B" DETAIL - Special Revenue Grants / Proprietary Funds
E Radio Communications IT Public Safety and Radio
Communications
FND53600 CCN1080310 SC702010 PRG115150 702000 Salaries 43,101.00$ 43,963.00$ 44,842.00$
E Radio Communications IT Public Safety and Radio
Communications
FND53600 CCN1080310 SC722900 PRG115150 722000 Fringe Benefit Adjustments 32,909.00 33,211.00 33,518.00
Total Expenses 76,010.00$ 77,174.00$ 78,360.00$
E Information Technology IT Administration FND63600 CCN1080101 SC731458 PRG152000 730000 Professional Services 306,575.00$ 306,575.00$ -$
E Information Technology IT Application Services FND63600 CCN1080201 SC731458 PRG152010 730000 Professional Services (649,471.00) (649,471.00) -
E Information Technology IT Technical Systems and NetworkingFND63600 CCN1080601 SC731458 PRG152100 730000 Professional Services 342,896.00 342,896.00 -
Total Expenses -$ -$ -$
WHEREAS a FY 2023 - FY2024 budget amendment is recommended for the Information Technology fund (#63600) to reallocate funds based on the FY 2023-2024 Master Plan priorities established by the Leadership Groups; and
R Airport Aviation and Transport
Admin
FND56500 CCN1090501 RC631897 PRG154090 630000 Reimb US Custome Services 150,000.00$ 150,000.00$ 150,000.00$
R Airport Aviation and Transport
Admin
FND56500 CCN1090501 RC668882 PRG154090 665882 Plannned Use of Balance 30,000.00 30,000.00 30,000.00
Total Revenue 180,000.00 180,000.00 180,000.00
E Airport Aviation and Transport
Admin
FND56500 CCN1090501 SC732067 PRG154090 730000 US Customs Service 180,000.00 180,000.00 180,000.00
Total Expense 180,000.00$ 180,000.00$ 180,000.00$
WHEREAS a FY 2023 - FY 2025 budget amendment totaling $180,000, is recommended for Economic Development/Aviation - Oakland County International Airport, to cover increased costs from CBP and expanded hours. The CBP 100% of their costs on to the airport; and
WHEREAS a budget amendment is recommended to move position P00010483 from the CLEMIS fund to the Radio fund
AIRPORT FUND (#56500)
11
COUNTY OF OAKLAND
FY 2023 FIRST QUARTER REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2022 BUDGET AMOUNT
ADOPTED AS FY 2023 FAVORABLE/
BUDGET AMENDED FORECAST (UNFAVORABLE)PERCENT
REVENUES
GENERAL FUND
Taxes 285,734,704.00$ 285,734,704.00$ 290,920,000.00$ 5,185,296.00 1.81%
Federal Grants 1,208,790.00 1,946,930.00 2,048,294.00 101,364.00 5.21%
State Grants 19,891,928.00 19,928,971.00 19,928,971.00 - 0.00%
Other Intergovernmental Revenue 49,848,663.00 49,848,663.00 49,798,663.00 (50,000.00) -0.10%
Charges for Services 127,682,464.00 128,825,189.00 124,557,473.00 (4,268,882.00) -3.31%
Indirect Cost Recovery 9,150,000.00 9,150,000.00 9,150,000.00 - 0.00%
Contributions 0.00 0.00 0.00 -
Investment Income 1,804,700.00 1,804,700.00 2,421,236.00 674,609.00 37.38%
Other Revenues 434,000.00 434,000.00 431,758.03 (2,241.97) -0.52%
Transfers In 26,053,877.00 26,180,944.00 26,180,944.00 - 0.00%
SUB-TOTAL GENERAL FUND/GENERAL PURPOSE 521,809,126.00$ 523,854,101.00$ 525,437,339.03$ 1,640,145.03$ 0.31%
TOTAL GF/GP FUNDS 521,809,126.00$ 523,854,101.00$ 525,437,339.03$ 1,640,145.03$ 0.31%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court 51,476,232.00$ 52,508,596.66$ 44,923,596.66 7,585,000.00$ 14.45%
52nd District Court 18,811,240.00 18,938,185.52 17,786,185.52 1,152,000.00 6.08%
Probate Court 7,760,407.00 7,842,531.90 7,443,031.90 399,500.00 5.09%
TOTAL ADMIN. OF JUSTICE 78,047,879.00$ 79,289,314.08$ 70,152,814.08$ 9,136,500.00$ 11.52%
LAW ENFORCEMENT
Prosecuting Attorney 26,205,522.00 26,926,919.60 25,181,919.60 1,745,000.00 6.48%
Sheriff 183,280,522.00 190,146,477.04 188,900,477.04 1,246,000.00 0.66%
TOTAL LAW ENFORCEMENT 209,486,044.00$ 217,073,396.64$ 214,082,396.64$ 2,991,000.00$ 1.38%
GENERAL GOVERNMENT
Clerk/Register of Deeds 10,767,003.00 10,915,610.04 10,067,110.04 848,500.00 7.77%
Treasurer 8,588,966.00 47,956,758.90 47,336,758.90 620,000.00 1.29%
Board of Commissioners 5,323,418.00 6,325,956.00 6,225,956.00 100,000.00 1.58%
Water Resources Commissioner 8,274,453.00 8,339,591.00 8,329,591.00 10,000.00 0.12%
TOTAL GENERAL GOVERNMENT 32,953,840.00$ 73,537,915.94$ 71,959,415.94$ 1,578,500.00$ 2.15%
COUNTY EXECUTIVE
County Executive Admn.9,986,336.00$ 10,974,081.00$ 10,401,681.00$ 572,400.00$ 5.22%
Management and Budget 25,144,692.00 25,517,151.00 25,097,151.00 420,000.00 1.65%
Facilities Management 4,723,654.00 4,855,053.72 4,260,053.72 595,000.00 12.26%
Human Resources 5,456,482.00 5,802,495.75 5,487,495.75 315,000.00 5.43%
Health and Human Services 44,810,566.00 48,265,994.18 46,050,994.18 2,215,000.00 4.59%
Public Services 43,399,767.00 43,837,863.64 43,063,863.64 774,000.00 1.77%
Economic Development 11,228,989.00 15,965,379.00 15,275,379.00 690,000.00 4.32%
Emergency Management & Homeland Security 2,150,270.00 3,301,780.38 3,271,780.38 30,000.00 0.91%
Public Communication 3,713,099.00 4,493,510.00 4,293,510.00 200,000.00 4.45%
TOTAL COUNTY EXECUTIVE 150,613,855.00$ 163,013,308.67$ 157,201,908.67$ 5,811,400.00$ 3.56%
TOTAL DEPARTMENTS 471,101,618.00$ 532,913,935.33$ 513,396,535.33$ 19,517,400.00$ 3.66%
Non-Departmental $58,981,384.00 $58,521,716.00 76,793,861.00 (18,272,145.00)
TOTAL GOVERNMENTAL EXPENDITURES 530,083,002.00$ 591,435,651.33$ 590,190,396.33$ 1,245,255.00$ 0.21%
General Fund/General Purpose
Favorable/(Unfavorable) - Budget Perspective 2,885,400.03$ 2,885,400.03$
PLANNED USE OF FUND BALANCE 8,273,876.00$ 67,581,550.37$ 64,696,150.34$
12
AMOUNT
ADOPTED AMENDED FY 2023 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
TAXES (601000-601999)
Property Taxes - July Tax Levy 284,914,704.00$ 284,914,704.00$ 290,100,000.00 5,185,296.00$ 1.82%Fav. Due to timing of collection
Other Taxes - Delinquent Tax - Prior Years 125,000.00 125,000.00 125,000.00 - 0.00%
Marijuana Tax 50,000.00 50,000.00 50,000.00 - 0.00%
Treasurer Payment in Lieu of Taxes 550,000.00 550,000.00 550,000.00 - 0.00%
Trailer Tax 95,000.00 95,000.00 95,000.00 - 0.00%
Total Taxes 285,734,704.00$ 285,734,704.00$ 290,920,000.00$ 5,185,296.00$ 1.81%
FEDERAL GRANTS (610000-610999)
Sheriff - Sheriff's Office -$ -$ -$ -$ 0.00%
Sheriff - Patrol - 69,789.00 177,200.00 107,411.00 153.91%Fav. Due to Marine Safety Grant; partially offset by unfav TIA Traffic
Enforcement grant reimbursement due to timing.
Sheriff - Emergency Response and Prep - - - - 0.00%
Sheriff - Investigative/Forensic Services - 59,054.00 153,007.00 93,953.00 159.10%Fav. due to timing of grant payment for High Intensity Drug Trafficking
Areas (HIDTA) Grants and calendar year grants being budgeted in one
fiscal year.
Prosecuting Attorney 205,000.00 380,000.00 380,000.00 - 0.00%Even - contract with Michigan Department of Health and Human
Services Title IV-E.
Homeland Security - Disaster Control - - - - 0.00%
Emergency Management and Homeland Security 55,000.00 490,000.00 490,000.00 - 0.00%
Health Division 648,790.00 648,087.00 648,087.00 - 0.00%
Children's Village 300,000.00 300,000.00 200,000.00 (100,000.00) -33.33%Unfav. School Lunch program serving less due to decline in population
of residents.
Total Federal Grants 1,208,790.00$ 1,946,930.00$ 2,048,294.00$ 101,364.00$ 5.21%
STATE GRANTS (615000-615999)
Sheriff - Patrol -$ -$ -$ -$
State Match Foster Care 1,000.00 1,000.00 1,000.00 - 0.00%
Prosecuting Attorney - - - - 0.00%
Economic Development - - - - 0.00%
Health Division 5,541,240.00 5,578,283.00 5,578,283.00 - 0.00%
Water Resources Commissioner - - - - 0.00%
Economic Development - Veteran's Services - - - - 0.00%
Non-Departmental - Child Care Subsidy 14,349,688.00 14,349,688.00 14,349,688.00 - 0.00%
Total State Grants 19,891,928.00$ 19,928,971.00$ 19,928,971.00$ -$ 0.00%
OTHER INTER-GOVERNMENTAL REVENUES (620000 - 626999)
Non-Departmental 47,584,129.00$ 47,584,129.00$ 47,584,129.00$ -$ 0.00%
HHS - Homeland Security - - - - 0.00%
Emergency Management - Homeland Security 9,000.00 9,000.00 9,000.00 - 0.00%
Circuit Court-Judicial Admin - - - - 0.00%
Circuit Court- Civil Criminal 4,500.00 4,500.00 4,500.00 - 0.00%
District Court - - - - 0.00%
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2023 FIRST QUARTER REPORT
13
AMOUNT
ADOPTED AMENDED FY 2023 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2023 FIRST QUARTER REPORT
District Court 1,800.00 1,800.00 1,800.00 - 0.00%
Probate Court - - - - 0.00%
Sheriff 255,050.00 255,050.00 205,050.00 (50,000.00) -19.60%Unfav. Social Security Incentive Payments ($50,000) as a result of a
reduction in the number of inmates receiving social security. Funds are
collected from jail inmates who receive SSI for cost of incarceration.
Non-Departmental - Reimb Judges Salaries 1,994,184.00 1,994,184.00 1,994,184.00 - 0.00%
Total Other Intergovernmental Revenue 49,848,663.00$ 49,848,663.00$ 49,798,663.00$ (50,000.00)$ -0.10%
CHARGES FOR SERVICES (630000-635999)
Administration of Justice
Circuit Court - Judicial/Administration -$ -$ -$ -$ 0.00%
Circuit Court - Civil/Criminal 1,134,000.00 1,134,000.00 1,155,000.00 21,000.00 1.85%Fav. Refund Fees PD Def Attorney $96,000 due to a delay in payments
from FY 2022 for restitution and other statutory fees. Partially offset by
unfav. Court Costs ($75,000) due to changes in legislation.
Circuit Court - Family Division 1,421,500.00 1,421,500.00 326,500.00 (1,095,000.00) -77.03%Unfav. Board and Care ($875,000); Govt Benefit Board and Care
($125,000); Court Service Fees Probation ($75,000); Reimb Clinical
Evaluations ($20,000) due to County Executive Administration policy
changes regarding collections for these services.
District Court - Division I (Novi)3,839,753.00 3,839,753.00 2,839,753.00 (1,000,000.00) -26.04%Unfav. Ordinance Fines and Costs ($650,000); Probation Fees
($200,000); and State Law Costs ($150,000) partially due to the
reduction in caseload from marijuana legalization and partially due to
change in legislation. The overarching cause of the variances is also
due to COVID-19 pandemic.
District Court - Division II (Clarkston)1,822,663.00 1,822,663.00 1,672,663.00 (150,000.00) -8.23%Unfav. Ordinance Fines and Costs ($100,000); Probation Fees
($50,000) partially due to the reduction in caseload from marijuana
legalization, partially due to change in legislation and partially due to
the pandemic. The overarching cause of the variances is also due to
COVID-19 pandemic.
District Court - Division III (Rochester Hills)3,886,015.00 3,886,015.00 3,136,015.00 (750,000.00) -19.30%Unfav. Ordinance Fines and Costs ($500,000) as well as Probation
Fees ($250,000) partially due to change in the marijuana statute
(making it a civil infraction), partially due to change in legislation and
partially due to the COVID-19 pandemic.
District Court - Division IV (Troy)2,120,590.00 2,120,590.00 1,470,590.00 (650,000.00) -30.65%Unfav. Ordinance Fines and Costs ($400,000) partially due to the
reduction in caseload from marijuana legalization and partially due to
COVID-19 pandemic. Unfav. Probation Fees ($200,000) as well as
State Law Costs ($50,000) partially due to change in legislation and
partially due to the pandemic.
Probate Court - Estates and Mental Health 518,600.00 518,600.00 738,600.00 220,000.00 42.42%Fav. Gross Estate Fees $150,000 due to a increase in fees paid. Fav.
Certified Copies $50,000 and Photostats $20,000 due to an increase in
activity.
Total Administration of Justice 14,743,121.00$ 14,743,121.00$ 11,339,121.00$ (3,404,000.00)$ -23.09%
14
AMOUNT
ADOPTED AMENDED FY 2023 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2023 FIRST QUARTER REPORT
Law Enforcement
Prosecuting Attorney 820,349.00$ 853,621.00$ 813,621.00 (40,000.00) -4.69%Unfav. Reimb General ($26,000) at 46th District Court, Extradition
Recovery Fee ($10,00) and Educational Training ($2,000) due to less
activity.
Sheriff's Office 2,900.00 2,900.00 10,900.00 8,000.00 275.86%Fav. Reimb General due to higher abandoned auto auction activity.
Sheriff - Administrative Services 343,500.00 343,500.00 198,500.00 (145,000.00) -42.21%Unfav. Fingerprints ($160,000), and Registration Fees ($10,000) due to
reduced activity; partially offset by fav. FOIA Fees $15,000 and
Photostats $9,500 due to increased activity.
Sheriff - Corrective Services 2,116,000.00 2,419,335.00 2,184,335.00 (235,000.00) -9.71% Unfav. Commissions Contracts ($300,000) due to limited commissary
availability during pandemic, Inmate Board and Care ($25,000) due to
lower collection rates; partially offset by fav. Diverted Felon $100,000
due to the number of inmates that meet reimbursement criteria.
Sheriff - Corrective Services Satellites 787,059.00 787,059.00 742,059.00 (45,000.00) -5.72%Unfav. Board and Care ($45,000) due to less than anticipated judge
referrals to the tether program.
Sheriff - Emergency Response and Prep - - 10,000.00 10,000.00 100.00%Fav. Reimb General $10,000 due to increased activity.
Sheriff - Patrol Services 61,791,616.00 62,448,484.00 62,448,484.00 - 0.00%
Sheriff - Emergency Communications Operations 2,872,878.00 2,872,878.00 2,872,878.00 - 0.00%
Sheriff - Investigative Forensic Services 1,215,000.00 1,215,000.00 465,000.00 (750,000.00) -61.73%Unfav. primarily due to Drug Testing ($770,000) as the Results testing
program was shut down due to the COVID-19 pandemic. It has
reopened and is experiencing a lower number of clients. Partially offset
by favorable operating expenditures. Also fav. Reimb Salaries $20,000
due to task force reimbursement.
Total Law Enforcement 69,949,302.00$ 70,942,777.00$ 69,745,777.00$ (1,197,000.00)$ -1.69%
General Government
Clerk - Administration -$ -$ - -$ 0.00%
Clerk - County Clerk 2,399,100.00$ 2,399,100.00$ 2,549,100.00 150,000.00$ 6.25%Fav. Photostats $50,000, Jury Fees 50,000 and Civil Action Entry Fees
$50,000 due to increased activity.
Clerk - Elections 196,900.00 196,900.00 196,900.00 - 0.00%
Clerk - Register of Deeds & Micrographics 15,449,500.00 15,447,500.00 15,447,500.00 - 0.00%
Treasurer 3,345,100.00 3,347,100.00 3,347,100.00 - 0.00%
Board of Commissioners 3,700.00 3,700.00 3,700.00 - 0.00%
Water Resources Commissioner 3,858,755.00 3,858,755.00 3,858,755.00 - 0.00%No change for Fiscal Year 2023 first quarter.
Total General Government 25,253,055.00$ 25,253,055.00$ 25,403,055.00$ 150,000.00$ 0.59%
15
AMOUNT
ADOPTED AMENDED FY 2023 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2023 FIRST QUARTER REPORT
County Executive
County Exec - Corp Counsel - - - -
County Exec - Admin - - - -
M&B - Equalization Division 3,514,475.00 3,589,475.00 3,589,475.00 - 0.00%
M&B - Fiscal Services Division 505,600.00 505,600.00 505,600.00 - 0.00%
M&B - Purchasing Division 565,690.00 565,690.00 565,690.00 - 0.00%
Facilities Management - Support Services 326,000.00 326,000.00 423,500.00 97,500.00 29.91%Fav. Standard Mail $112,500 due to higher than anticipated rebills to
other departments. Unfav. Commission Vending Machines ($15,000)
due to reduced staffing at County buildings during remote work
options.
Human Resources - - - 0.00%
HHS - Administration - - - - 0.00%
HHS - Health Division 4,678,847.00 4,678,847.00 4,678,847.00 - 0.00%
HHS - MSU Extension - - - - 0.00%
Public Services - Community Corrections 155,000.00 155,000.00 11,166.00 (145,000.00) -93.55%Unfav. Fee Income ($145,000) due to less than anticipated referrals
from judges to the Weekend and Weekday Alternative for
Misdemeanants (WWAM) Program. In addition, the program was
suspended due to the COVID-19 pandemic and has not resumed.
Public Services - Children's Village 4,763,987.00 4,763,987.00 4,893,605.00 129,618.00 2.72%Fav. Reimburse General $286,921 and Reimburse Salaries $479,332
due to wage reimbursement of salary expenditure from State for Direct
Care Workers. Partially offset by unfav. Board and Care ($250,000)
due to lower population.
Public Services - Medical Examiner 445,100.00 519,350.00 519,350.00 - 0.00%
Public Services - Animal Control 1,447,014.00 1,447,014.00 1,447,014.00 - 0.00%
Public Services - Circuit Court Probation - - - - 0.00%
Economic Development - Planning & Local Bus Dev. (FKA
PEDS)
416,708.00 416,708.00 416,708.00 - 0.00%
Economic Development - Veterans - - - - 0.00%
Total County Executive 16,818,421.00$ 16,967,671.00$ 17,050,955.00$ 82,118.00$ 0.48%
Non-Departmental
Non-Dept - Charges for Services 918,565.00$ 918,565.00$ 1,018,565.00 100,000.00 10.89%Fav. Due to Commission Public Telephone
Total Non-Departmental 918,565.00$ 918,565.00$ 1,018,565.00$ 100,000.00$ 10.89%
Total Charges for Services 127,682,464.00$ 128,825,189.00$ 124,557,473.00$ (4,268,882.00)$ -3.31%
INDIRECT COST RECOVERY (640100)9,150,000.00$ 9,150,000.00$ 9,150,000.00 -$ 0.00%
16
AMOUNT
ADOPTED AMENDED FY 2023 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2023 FIRST QUARTER REPORT
CONTRIBUTIONS (650000)
Board of Commissioners-Contributions - - - - 0.00%
Economic Development & Comm Affairs - Contributions - - - - 0.00%
Economic Development - Contributions - - - - 0.00%
Total Contributions Revenues -$ -$ -$ -$ 0.00%
INVESTMENT INCOME (655000)
District Courts (Div. I - IV)2,200.00 2,200.00 2,200.00 - 0.00%
Sheriff Corrective Services - - - - 0.00%
Sheriff Investigative/Technical Services - - - - 0.00%
Treasurer 300,000.00 300,000.00 241,927.00 - 0.00%
Clerk/Register of Deeds 2,500.00 2,500.00 2,500.00 - 0.00%
Fiscal Services - - 674,609.00 674,609.00 100.00%Interest Income allocated to Fiscal Services from Oakland County
Treasurer Department. Prior allocations were made to Non-
Departmental.
Economic Development - - - - 0.00%
Health Division - - - - 0.00%Interest income from Immunization program.
Non-Departmental 1,500,000.00 1,500,000.00 1,500,000.00 - 0.00%
Total Investment Income 1,804,700.00$ 1,804,700.00$ 2,421,236.00$ 674,609.00$ 37.38%
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 - - 733.40 733.40 100.00%Fav. Enhancement Funds for unbudgeted cash recovery from
evidence.
Sheriff - Administrative Services - - - - 0.00%
Sheriff - Corrective Services - - 24.63 24.63 100.00%Fav. Income from Investment.
Sheriff - Corrective Services-Satellites - - - - 0.00%
Sheriff - Emergency Resp and Prepare - - - - 0.00%
Sheriff - Patrol Services 12,000.00 12,000.00 12,000.00 - 0.00%
Sheriff - Patrol Services - Donations - - - - 0.00%
Sheriff - Emergency Communications Operations - - - - 0.00%
Sheriff - Investigative/Forensic Svc 3,000.00 3,000.00 - (3,000.00) -100.00%Unfav. County Auction ($3,000) 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%
17
AMOUNT
ADOPTED AMENDED FY 2023 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2023 FIRST QUARTER REPORT
Management and Budget - Fiscal Services - - - - 0.00%
18
AMOUNT
ADOPTED AMENDED FY 2023 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2023 FIRST 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 - Donations - - - - 0.00%
Health Division - - - - 0.00%
Homeland Security - - - - 0.00%
EMG - Homeland Security - - - - 0.00%
Public Services - Community Corrections - - - - 0.00%
Public Services - Animal Control-Other Revenues - - - - 0.00%
Public Services - Children's Village - Other Revenues - - - - 0.00%
Economic Development - Veterans - - - - 0.00%
Non Departmental - Donations - - - 0.00%
Non-Dept - Sundry 417,500.00 417,500.00 417,500.00 - 0.00%
Total Other Revenues 434,000.00$ 434,000.00$ 431,758.03 (2,241.97)$ -0.52%
TRANSFERS IN (695500)
Circuit Court - Transfers In - - - - 0.00%
Prosecuting Attorney Transfers In - - - - 0.00%
Board of Commissioners - 100,000.00 100,000.00 -
Health Division - Transfers In - - - - 0.00%
Public Services - Animal Control-Transfers In - - - - 0.00%
Public Services - Children's Village - Transfers In - - - - 0.00%
Economic Development Transfers In - - 0.00%
Medical Examiners Transfer In - - - - 0.00%
Sheriffs' Transfers In - - - - 0.00%
Treasurers' Transfers In 2,300,000.00 2,300,000.00 2,300,000.00 - 0.00%
Non-Departmental - Transfers In 23,753,877.00 23,780,944.00 23,780,944.00 - 0.00%
Total Transfers In Revenues 26,053,877.00$ 26,180,944.00$ 26,180,944.00 -$ 0.00%
PLANNED USE OF FUND BALANCE (665882)
Encumbrances and Carry forwards - 19,934,269.37 19,934,269.37 - 0.00%
Use of Prior Yrs Fund Balance 8,273,876.00$ 47,647,281.00$ 47,647,281.00 - 0.00%
Total Planned Use of Fund Balance 8,273,876.00$ 67,581,550.37$ 67,581,550.37$ -$ 0.00%
TOTAL GEN. FUND / GEN. PURPOSE REVENUE 530,083,002.00$ 591,435,651.37$ 593,018,889.40$ 1,640,145.03$ 0.28%
19
Adopted Amended Forecast Favorability/UNF Percentage
$51,476,232.00 $52,508,596.66 $44,923,596.66 $7,585,000.00 14.45%
$28,064,168.00 $28,064,168.00 $25,839,168.00 $2,225,000.00 7.93%
$11,378,901.00 $12,151,150.66 $6,356,150.66 $5,795,000.00 47.69%
$5,227,181.00 $5,487,296.00 $5,922,296.00 ($435,000.00)-7.93%
$6,805,982.00 $6,805,982.00 $6,805,982.00 $0.00 0.00%Transfers
Projected in line with budget for Transfers Out
Projected favorability due to decrease in placements to State Institutions $2,750,000 and Priv Institutions
Residential $1,500,000 under the Family Division based on caseload, difficulty of care, and treatment of services
ordered by the Court
Projected favorability in Defense Atty Fees $350,000; Fees Guardian Ad Litem $200,000; and Professional
Services $200,000 under the Family Division due to less demand for these services
Projected unfavorability in InfoTech Operations ($400,000) across all divisions due to a higher than antcipated
computer hardware and software utilization, with greater unfavorability of ($225,000) in Family Division and
($75,000) in Civil Criminal Division
Internal
The overall Operating Expenditure category is offset by unfavorable Non-Dept Child Care Subsidy Revenue
(50%Reimbursement. The overarching cause of the variances identified above is due to the decreased number of
juvenile placements associated with the COVID-19 pandemic under the Family Division, which are beginning to
trend upward. A recent increase in private placement rates could also impact future forecasts.
Personnel
Projected favorability in Salaries and Fringes due to underfilled and vacant positions across all divisions, with
greater favorability of $1,000,000 in Family Division and $775,000 in Judicial Administration
Operating
Circuit Court
2023 Q1 Forecast
Total
Summary of Projections
20
Adopted Amended Forecast Favorability/UNF Percentage
$18,811,240.00 $18,938,185.52 $17,786,185.52 $1,152,000.00 6.08%
$14,702,269.00 $14,795,658.00 $13,730,658.00 $1,065,000.00 7.20%
$2,196,016.00 $2,203,444.52 $2,145,944.52 $57,500.00 2.61%
$1,912,955.00 $1,939,083.00 $1,909,583.00 $29,500.00 1.52%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
No Transfers Out are budgeted in FY 2023
Projected favorability in Software Support Maintenance $10,000 under Novi due to caseload. The District Court is charged a
base fee plus a per case fee.
Projected favorability in Telephone Communications $57,000 due to lower than anticipated use, with greater favorability of
$20,000 in Novi and $15,000 in Rochester
The overall Internal Services category is partially offset by projected unfavorability in InfoTech Operations ($27,500) due to
higher than anticipated use, with greater unfavorability of ($12,500) in Troy and ($10,000) in Clarkston
Internal
District Court
2023 Q1 Forecast
Total
Summary of Projections
Personnel
Projected favorability in Salaries and Fringes due to turnover and underfilled positions/vacancies across all divisions, with
greater favorability of $400,000 in Rochester, $300,000 in Novi and $200,000 in Clarkston
Operating
Projected favorability in Postage-Standard Mailing $15,000 under Rochester due to caseload. Costs are largely incurred from
mailing notices to appear, court orders and juror summons. Additionally, changes in legislation impact the number of hearings
held for certain charges.
Projected favorability in Interpreter Fees $15,000 under Troy due to caseload and reduced demand for the use of foreign
language and/or hearing impairment services of court visitors. It is difficult to predict the need for these services.
21
Adopted Amended Forecast Favorability/UNF Percentage
$7,760,407.00 $7,842,531.90 $7,443,031.90 $399,500.00 5.09%
$5,543,249.00 $5,543,249.00 $5,093,249.00 $450,000.00 8.12%
$1,113,424.00 $1,159,304.90 $1,187,804.90 ($28,500.00) -2.46%
$1,103,734.00 $1,139,978.00 $1,161,978.00 ($22,000.00)-1.93%
$0.00 $0.00 $0.00 $0.00 0.00%
Personnel
Projected favorability in Salaries and Fringes due to underfilled positions/vacancies across all divisions, with
greater favorability of $300,000 in Estates and Mental Health
Operating
Probate Court
2023 Q1 Forecast
Total
Summary of Projections
Transfers
No Transfers Out are budgeted in FY 2023
Projected unfavorability in Fees Guardian Ad item ($35,000) as well as Medical Services Probate Exam
($35,000) under Estates and Mental Health based on a high demand for these services, as well as an increase in
the cost of evaluation fees paid to providers.
The overall Operating Expenditure category is partially offset by projected favorability in Defense Attorney Fees
$40,000 under Estates and Mental Health due to lower demand for this service
Projected unfavorability in InfoTech Operations ($27,000) and Equipment Rental ($15,000) under Estates and
Mental Health due to higher than anticipated equipment utilization and software maintenance contracts which may
impact future forecasts
The overall Internal Services category is partially offset by projected favorability in Info Tech Operations $20,000
under Judicial Administration due to lower than anticipated use
Internal
22
Adopted Amended Forecast Favorability/UNF Percentage
$26,205,522.00 $26,926,919.60 $25,181,919.60 $1,745,000.00 6.48%
$21,971,765.00 $22,180,065.00 $20,280,065.00 $1,900,000.00 8.57%
$661,836.00 $1,132,016.60 $1,087,016.60 $45,000.00 3.98%
$2,351,664.00 $2,394,581.00 $2,594,581.00 ($200,000.00)-8.35%
$1,220,257.00 $1,220,257.00 $1,220,257.00 $0.00 0.00%
Personnel
Overtime unfavorable ($130,000) and offset by favorability in salaries and fringe benefits.
Favorability in salaries and fringe benefits due to turnover and vacancies.
Operating
Prosecuting Attorney
2023 Q1 Forecast
Total
Summary of Projections
Transfers
Transfers Out are projected to be even in FY 2023.
Favorability of $100,000 is driven by multiple small variances in spending categories such as Computer Research
Service, Contracted Services, Library Continuations, Membership Dues and Professional Services.
Projected favorability is partially offset by projected unfavorability of ($50,000) in Extradition Expense and Witness
Fees and Mileage which has increased in response to the Oxford High School shooting.
Forecasted unfavorability of ($250,000) predominantly due to Info Tech Operations and a smaller amount due to
Telephone Communications
Favorability of $50,000 is anticipated in Info Tech Managed Print Services due to remote work and paper reduction
efforts.
Internal
23
Adopted Amended Forecast Favorability/UNF Percentage
$183,280,522.00 $190,146,477.04 $188,900,477.04 $1,246,000.00 0.66%
$145,712,711.00 $146,245,690.00 $146,224,690.00 $21,000.00 0.01%
$13,494,198.00 $18,186,846.04 $17,251,846.04 $935,000.00 5.14%
$23,358,310.00 $23,660,677.00 $23,370,677.00 $290,000.00 1.23%
$715,303.00 $2,053,264.00 $2,053,264.00 $0.00 0.00%
Personnel
Operating
Overall personnel is favorable $21,000 mainly due to being partially offset by unfavorable Overtime due to
turnover, vacant positions, officers in the academy, and officers in training. In addition, events at venues such as
Pine Knob drives overtime, however it is reimbursed through Reimbursed Salaries revenues via interlocal
agreements to provide law enforcement services.
Sheriff's Office
2023 Q1 Forecast
Total
Summary of Projections
Transfers
Transfers Out are projected to be even.
Favorability is driven by a few large items, with multiple smaller accounts across divisions favorable due to usage.
These accounts include Communications, Employee Medical Exams, Laundry and Cleaning, Library Continuations,
Office Supplies, Printing, Professional Services, Software Support Maintenance and Supportive Services and reflect
projected favorability of $425,000.
Favorability of $300,000 in Corrective Services - Contracted Services includes the health clinic and food services.
This is favorable due to fewer inmates and additional cost per meal above the contracted rate being charged to
ARPA.
Projected unfavorability of ($50,000) in Emergency Response and Prep - Electrical Service and Natural Gas due to
the increasing cost of utilities.
Forecasted favorability of $675,000 in Motor Pool, Radio Communications and Office Equipment Rental due to
less than anticipated usage and InfoTech Print Managed Services due to remote work and paper reduction efforts.
Projecting unfavorability of ($370,000) in Motor Pool Fuel Charges due to increased fuel costs and Telephone
Communications and Info Tech Operations due to higher usage.
Internal
Favorability of $110,000 in Fees Civil Service which is offset by unfavorable Civil Action Service Fees revenue due
to less activity in process serving.
Projected favorability of $100,000 in Laboratory Supplies which is offset by unfavorable Drug Testing revenue due
to reduced usage of the RESULTS drug testing program.
24
Adopted Amended Forecast Favorability/UNF Percentage
$10,767,003.00 $10,915,610.04 $10,067,110.04 $848,500.00 7.77%
$8,098,002.00 $8,098,002.00 $7,523,002.00 $575,000.00 7.10%
$1,332,412.00 $1,363,724.04 $1,115,224.04 $248,500.00 18.22%
$1,336,589.00 $1,453,884.00 $1,428,884.00 $25,000.00 1.72%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
•No Transfers Out are budgeted in FY 2023
• Favorability of $248,500 in Operating Expenditures is mainly attributed to $159,000 within Register of Deeds and
Micrographics Divisons due to Material and Supplies, Maintenance Contract, Office Supplies as savings are
reflected from no longer using microfilm and scanning digital copies.
• Forecasted Internal Services for Clerk's Department is favorable $25,000 due to Telephone Communications and
Info Tech Operations due to less than anticipated use.
Internal
• County Clerk Division anticipated favorability of $85,000 due to Metered Postage, Professional Services and Office
supplies due to less than anticipated use.
Personnel
• Favorability in salaries and fringes within The County Clerk's department within Administration, County Clerk and Register of
Deed divisions is due to fringe benefits, vacancies, turnover and underfilled positions.
Operating
Clerk/Register of Deeds
2023 Q1 Forecast
Total
Summary of Projections
25
Adopted Amended Forecast Favorability/UNF Percentage
$8,588,966.00 $47,956,758.90 $47,336,758.90 $620,000.00 1.29%
$3,771,884.00 $3,771,884.00 $3,651,884.00 $120,000.00 3.18%
$3,408,770.00 $42,703,243.90 $42,203,243.90 $500,000.00 1.17%
$1,288,312.00 $1,361,631.00 $1,361,631.00 $0.00 0.00%
$120,000.00 $120,000.00 $120,000.00 $0.00 0.00%
Personnel
• Favorability in salaries and fringes within The County Treasurer department is due to vacancies, turnover and underfilled
positions.
Operating
Treasurer
2023 Q1 Forecast
Total
Summary of Projections
Transfers
• Transfers favorability is projected at budget for property demolition at a future date.
• Favorability of $500,000 in Operating Expenditures within Contracted Services $200,000, Fees Civil Service
$200,000 and Foreclosure Notification $100,00 due to fewer land parcels being turned over to the county in
foreclosure.
• Forecasted Internal Services for Treasurer's Department is at budget for Q1 as utilization is at 25%.
Internal
26
Adopted Amended Forecast Favorability/UNF Percentage
$5,323,418.00 $6,325,956.00 $6,225,956.00 $100,000.00 1.58%
$3,443,428.00 $3,443,428.00 $3,343,428.00 $100,000.00 2.90%
$1,184,048.00 $2,173,145.00 $2,173,145.00 $0.00 0.00%
$695,942.00 $709,383.00 $709,383.00 $0.00 0.00%
$0.00 $0.00 $0.00 $0.00 0%
Personnel
• Favorability in salaries and fringes within The Board of Commissioners department is due to vacancies, turnover and
underfilled positions.
Operating
Board of Commissioners
2023 Q1 Forecast
Total
Summary of Projections
Transfers
• No Transfers Out are budget in FY 2023.
• Forecasting Expenditures anticipated to be at budget for FY 2023. Special Projects and Professional Services have
been favorable historically over the last couple years due to CARES and ARP funding being available.
• Forecasted Internal Services for Board of Commissioners Department is at budget as utilization is at 25%.
Internal
• Newly elected Commissioners terms started 1/1/2023 and have upcoming projects which will utilize majority of
budget.
27
Adopted Amended Forecast Favorability/UNF Percentage
$8,274,453.00 $8,339,591.00 $8,329,591.00 $10,000.00 0.12%
$234,624.00 $234,624.00 $234,624.00 $0.00 0.00%
$287,975.00 $288,094.00 $278,094.00 $10,000.00 3.47%
$7,695,689.00 $7,760,708.00 $7,760,708.00 $0.00 0.00%
$56,165.00 $56,165.00 $56,165.00 $0.00 0.00%Transfers
Transfers Out for Drainage Districts will occur at Fiscal Year End.
Favorable Meter Postage and Office Supplies due to remote work.
Forecasted Internal Services for Water Resources Commissioner is at budget for Q1 as utilization
is at 25%.
Internal
Water Resources Commissioner
2023 Q1 Forecast
Total
Summary of Projections
Personnel
Salaries and Fringes overall projected to be on budget.
Operating
28
Adopted Amended Forecast Favorability/UNF Percentage
$9,986,336.00 $10,974,081.00 $10,401,681.00 $572,400.00 5.22%
$6,189,140.00 $6,199,706.00 $6,018,906.00 $180,800.00 2.92%
$990,835.00 $1,922,116.00 $1,521,216.00 $400,900.00 20.86%
$922,740.00 $968,638.00 $977,938.00 ($9,300.00)-0.96%
$1,883,621.00 $1,883,621.00 $1,883,621.00 $0.00 0.00%Transfers
Transfers Out within Indigent Defense Service Office is projected to be at budget as it is grant match for the FY
2023 Mandated Indigent Defense Commission award.
Favorability in Special Event Program of $147,600 and Special Event Supplies of $49,600 due to less than
anticipated use. Also favorable, Professional Services $86,200 as projected activity will be lower than budget.
Projected favorability within Corporate Counsel of $21,200. Travel and Conference $9,200 due to less than
anticipated travel. Also favorable, Library Continuations $5,700 due to less than anticipated use.
Projected favorability of $57,700 in County Executive Administration, of which $25,000 is from Special Events line
item being below budgeted usage.
Forecasted unfavorability in Corporate Counsel of ($14,500) due to Info Tech Operations ($15,300) due to
greater utilization, partially offset by favorablity in Info Tech Managed Print Services.
Favorability of $1,400 in Compliance Office, of which $1,100 is due to Info Tech Managed Print Services due to
paper reduction efforts and working from home. Also favorable in DEI by $3,800 due to vacancy.
Internal
County Executive
2023 Q1 Forecast
Total
Summary of Projections
Personnel
Compliance Office, Corporate Counsel and Indigent Defense Services Office divisions are all at budget for FY23-
Q1.
Favorability of $180,800 is mainly attributable to vacant position in Diversity, Equity and Inclusion (DEI) divisions.
Operating
29
Adopted Amended Forecast Favorability/UNF Percentage
$25,144,692.00 $25,517,151.00 $25,097,151.00 $420,000.00 1.65%
$20,479,043.00 $20,479,043.00 $20,279,043.00 $200,000.00 0.98%
$1,120,330.00 $1,329,210.00 $1,129,210.00 $200,000.00 15.04%
$3,545,319.00 $3,708,898.00 $3,688,898.00 $20,000.00 0.54%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
No Transfers Out are budgeted in FY 2023.
Favorability projected for Fiscal Services Professional Services $150,000, Metered Postage $40,000,
and Training $10,000 due to operational trends and less than anticipated usage.
Forecasted favorability of $20,000 in InfoTech Print Managed Services across Divisions due to remote
work leading to less than normal usage.
Internal
Management & Budget
2023 Q1 Forecast
Total
Summary of Projections
Personnel
Favorability in salaries and fringes due to turnover and underfilled positions/vacancies across all
divisions, with greater favorability of $100,000 in Fiscal Services and $100,000 in Equalization Division.
Operating
30
Adopted Amended Forecast Favorability/UNF Percentage
$4,723,654.00 $4,855,053.72 $4,260,053.72 $595,000.00 12.26%
$2,882,560.00 $2,882,560.00 $2,307,560.00 $575,000.00 19.95%
$767,229.00 $888,601.72 $888,601.72 $0.00 0.00%
$1,073,865.00 $1,083,892.00 $1,063,892.00 $20,000.00 1.85%
$0.00 $0.00 $0.00 $0.00 0.00%
Personnel
Projected favorability in Salaries and Fringes due to turnover and vacant positions, with greater favorability of
$300,000 in Facilities Planning and Engineering along with $275,000 in Facilities Administration
Operating
Facilities Management
2023 Q1 Forecast
Total
Summary of Projections
Transfers
No Transfers Out are budgeted in FY 2023
Projected favorability in Professional Services $50,000 under the Sustainability Initiatives program due to a delay
in hiring educational and implementation contractors
Projected favorability in Printing $25,000 under the Sustainability Initiatives program due to a delay in the start of
event and educational initiatives
Projected favorability in InfoTech Operations of $20,000 due to lower than anticipated use, with greater favorability
of $15,000 within Facilities Planning and Engineering
Internal
Projected favorability in Special Event Supplies $25,000 under the Sustainability Initiatives program due to a delay
in the start of special events
31
Adopted Amended Forecast Favorability/UNF Percentage
$5,456,482.00 $5,802,495.75 $5,487,495.75 $315,000.00 8.73%
$3,607,735.00 $3,607,735.00 $3,292,735.00 $315,000.00 8.73%
$565,601.00 $882,468.75 $882,468.75 $0.00 0.00%
$1,283,146.00 $1,312,292.00 $1,312,292.00 $0.00 0.00%
$0.00 $0.00 $0.00 $0.00 0.00%
Personnel
• Favorability in salaries and fringes within Human Resources Department is due to vacancies, turnover and underfilled
positions.
Operating
Human Resources
2023 Q1 Forecast
Total
Summary of Projections
Transfers
•No Transfers Out are budgeted in FY 2023
• Human Resources favorability is even for Q1 as the department has upcoming expenditures as indentified in FY
2022 carry-forward request.
• Internal Services for Human Resources forecast for Q1 is at budget.
Internal
32
Adopted Amended Forecast Favorability/UNF Percentage
$44,808,566.00 $48,263,994.18 $46,048,994.18 $2,215,000.00 4.59%
$31,938,944.00 $31,938,944.00 $31,438,944.00 $500,000.00 1.57%
$8,401,941.00 $11,132,903.18 $9,432,903.18 $1,700,000.00 15.27%
$3,858,143.00 $3,963,212.00 $3,948,212.00 $15,000.00 0.38%
$609,538.00 $1,228,935.00 $1,228,935.00 $0.00 0.00%Transfers
Neighborhood Housing Development forecast for Q1 is at budget.
Favorability for Private Institution Residence $800,000, Private Institution $400,000, Private Institution Foster
$250,000, Foster Board Home $120,000, and Independent Living $50,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 as a result of COVID‐19.
Favorability projected for Vaccines $50,000 and Druges $10,000 for less than anticipated and the impact of COVID‐
19. Also favorability in Expendable Equipment $20,000 due to work from home.
Forecasted favorability of $15,000 in InfoTech Print Managed Services due to remote work.
Internal
Health
2023 Q1 Forecast
Total
Summary of Projections
Personnel
Favorability in salaries and fringes due to turnover and underfilled positions/vacancies in the Health Division. In addition,
eligible personnel costs have been covered by COVID‐related grants and Local Community Stabilization Authority funding.
Operating
33
Adopted Amended Forecast Favorability/UNF Percentage
$43,399,767.00 $43,837,863.64 $43,063,863.64 $774,000.00 8.19%
$31,303,511.00 $31,303,459.00 $30,943,459.00 $360,000.00 1.15%
$5,502,271.00 $5,878,394.64 $5,464,394.64 $414,000.00 7.04%
$6,593,985.00 $6,656,010.00 $6,656,010.00 $0.00 0.00%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
•No Transfers Out are budgeted in FY 2023
• Favorability of $488,000 projected with Children's Village Division through multiple line items but mainly
attributed in Provisions, Contracted Services and Medical Services Physicians accounts due to lower population and
less than anticipated use.
• Contracted Services favorable $45,000 within Community Corrections due to less than anticipated use.
• Projected unfavorability of ($65,000) within Medical Examiner's Division due to Transportation Services ($45,000)
and Laboratory Supplies ($20,000) due to greater than anticipated costs as well as the Lapeer County interlocal
agreement with Oakland County M.R. #22416. Revenues were increased to reflect charges from Lapeer County for
the services provided.
• Forecasted Internal Services for Public Services Department is at budget for Q1 as utilization is at 25%.
Internal
• Projected unfavorability of ($41,000) within Animal Control Divison due to Medical Supplies ($65,000) and Animal
Supplies ($10,000) due to higher costs of goods and services. Partially offset by favorability in various line item
accounts.
Public Services
2023 Q1 Forecast
Total
Summary of Projections
Personnel
• Personnel favorability within Children's Village Division will be impacted due to one-time payments to direct care workers.
Partial reimbursment was received from the State and will be recorded as a Q1 Amendment.
• Favorability in salaries and fringes due to turnover and underfilled positions/vacancies mostly attributed to Community
Corrections and Medical Examiner divisions.
Operating
34
Adopted Amended Forecast Favorability/UNF Percentage
$11,228,989.00 $15,965,379.00 $15,275,379.00 $690,000.00 4.32%
$7,844,494.00 $7,844,494.00 $7,544,494.00 $300,000.00 3.82%
$2,034,875.00 $5,420,169.00 $5,090,169.00 $330,000.00 6.09%
$1,349,620.00 $1,400,716.00 $1,340,716.00 $60,000.00 4.28%
$0.00 $1,300,000.00 $1,300,000.00 $0.00 0.00%
Personnel
Favorability in salaries and fringes due to turnover and underfilled positions/vacancies across all
divisions.
Operating
Economic Development & Community Affairs
2023 Q1 Forecast
Total
Summary of Projections
Transfers
Transfers Out for Neighborhood Housing Development forecast Q1 is at budget.
Favorability projected for Economic Development Administration Division for Membership Dues $20,000,
Professional Services $20,000, and Personal Mileage $10,000 due to less than anticipated usage and
reduction in travel as a result of virtual conferences/meetings.
Favorability projected for Planning and Local Business Development Division for Workshop and
Meetings $80,000 and Personal Mileage $20,000, due to increase in virtual meetings/trainings,
Membership Dues $40,000, Software Support $40,000, Drafting Supplies and Maps $10,000, and Metered
Postage $10,000 due to less than anticipated usage.
Favorability projected for Veteran Services Division for Soldier Burial $70,000 and Soldier Relief $10,000
due to less than anticipated claims for veteran benefits such as burial in National Cemetary, headstones,
markers, burial flags, and other veteran benefits.
Favorability projected for Info Tech Operations for Economic Development Administration Division
$20,000 and Planning And Local Business Development Division $40,000 due to less than anticipated
usage.
Internal
35
Account Adopted Budget Amended Budget
FY 2023
FORECAST
Amount
Favorable
(Unfavorable)
Explanation of Variance
Expenditure
SC702145 -
Separation
Incentive
1,041,385.00 1,041,385.00 1,041,385.00 -
SC702995 - Salary
Turnover Factor
(10,272,145.00)(10,272,145.00)- (10,272,145.00) Unfav due to net impact of salary and fringe
turnover that is offset in the iindividual
department budgets.
702000:Salaries
Regular
(9,230,760.00)(9,230,760.00)1,041,385.00 (10,272,145.00)
SC722790 - Social
Security
0.00 0.00 - -
722000:Fringe
Benefits
0.00 0.00 - -
SC730044 - Adj
Prior Years
Revenue
0.00 0.00 - -
SC730121 - Bank
Charges
0.00 0.00 - -
SC730240 - Cash
Shortage
0.00 0.00 - -
SC730359 -
Contingency
815,541.00 442,307.00 442,307.00 -
SC730611 -
Employees
Medical Exams
0.00 0.00 - -
SC730800 - Grant
Match
350,000.00 (746,127.00)(746,127.00) -
SC730954 -
Insurance Surety
Bonds
33,305.00 33,305.00 33,305.00 -
SC731136 - Logos
Trademarks
Intellect Prp
20,000.00 20,000.00 20,000.00 -
SC731241 -
Miscellaneous
300,000.00 300,000.00 300,000.00 -
SC731346 -
Personal Mileage
0.00 0.00 - -
SC731822 -
Special Projects
650,000.00 625,000.00 625,000.00 -
SC731885 -
Supportive
Services
0.00 0.00 - -
730000:Contractual
Services
2,168,846.00 674,485.00 674,485.00 -
SC740037 -
Classification and
Rate Change
193,451.00 88,068.00 88,068.00 -
SC740044 - Drain
Assessments
Current
2,025,000.00 2,025,000.00 2,025,000.00 -
SC740058 -
Emergency
Salaries Reserve
72,674.00 72,674.00 72,674.00 -
SC740072 -
General Fund
Contingency
(8,000,000.00)(8,000,000.00)- (8,000,000.00) Unfav. As this amount is the general
favorability factor that reflects historical
favorability trends whie the county continues to
review departmental operations.
SC740085 - Local
Road Funding
Program
2,000,000.00 2,000,000.00 2,000,000.00 -
SC740086 - Mental
Health Authority
9,620,616.00 9,620,616.00 9,620,616.00 -
NON-DEPARTMENT EXPENDITURES FY 2023 FIRST QUARTER REPORT
36
Account Adopted Budget Amended Budget
FY 2023
FORECAST
Amount
Favorable
(Unfavorable)
Explanation of Variance
NON-DEPARTMENT EXPENDITURES FY 2023 FIRST QUARTER REPORT
SC740093 - Mich
Association of
Counties
73,000.00 73,000.00 73,000.00 -
SC740100 -
National Assoc of
Counties
24,100.00 24,100.00 24,100.00 -
SC740114 -
Overtime Reserve
300,000.00 300,000.00 300,000.00 -
SC740135 - Road
Comm Tri Party
2,000,000.00 4,374,048.00 4,374,048.00 -
SC740149 -
SEMCOG
550,000.00 550,000.00 550,000.00 -
SC740160 -
Substance Abuse
Coord Agency
4,943,138.00 4,943,138.00 4,943,138.00 -
SC740177 - Traffic
Improvement
Assoc
30,000.00 30,000.00 30,000.00 -
740000:Non-
Departmental
13,831,979.00 16,100,644.00 24,100,644.00 (8,000,000.00)
SC760126 -
Capital Outlay
Miscellaneous
300,000.00 300,000.00 300,000.00 -
SC760180 -
Technology
Projects-One Time
2,000,000.00 1,257,796.00 1,257,796.00 -
760000:Capital
Outlay
2,300,000.00 1,557,796.00 1,557,796.00 -
SC770631 - Bldg
Space Cost
Allocation
1,104,752.00 1,104,752.00 1,104,752.00 -
SC773630 - Info
Tech Development
9,212,320.00 8,106,307.00 8,106,307.00 -
SC774677 -
Insurance Fund
460,272.00 460,272.00 460,272.00 -
SC775754 -
Maintenance
Department
Charges
702,500.00 547,474.00 547,474.00 -
SC777599 -
Service Center
Grounds
500,000.00 500,000.00 500,000.00 -
770000:Internal
Support
Expenditures
11,979,844.00 10,718,805.00 10,718,805.00 -
SC788001 -
Transfers Out
37,931,475.00 38,700,746.00 38,700,746.00 -
788001:Transfers
Out
37,931,475.00 38,700,746.00 38,700,746.00 -
Total Expenditure 58,981,384.00 58,521,716.00 76,793,861.00 (18,272,145.00)
37
Adopted Amended Forecast Favorability/UNF Percentage
$2,150,270.00 $3,301,780.38 $3,271,780.38 $30,000.00 0.91%
$1,081,520.00 $1,081,520.00 $1,081,520.00 $0.00 0.00%
$469,337.00 $1,604,927.38 $1,574,927.38 $30,000.00 1.87%
$599,413.00 $615,333.00 $615,333.00 $0.00 0.00%
$0.00 $0.00 $0.00 $0.00 0.00%
Personnel
Personnel for Emergency Management & Homeland Security forecast for Q1 is at budget.
Operating
Emergency Management & Homeland Security
2023 Q1 Forecast
Total
Summary of Projections
Transfers
No Transfers Out are budgeted in FY 2023.
Favorability Law Enforcement Equipment $20,000 due to lower usage and Printing $10,000 due to
remote work.
Internal Services for Emergency Management & Homeland Security forecast Q1 is at budget.
Internal
38
Adopted Amended Forecast Favorability/UNF Percentage
$3,713,099.00 $4,493,510.00 $4,293,510.00 $200,000.00 4.45%
$2,178,262.00 $2,178,262.00 $1,803,262.00 $375,000.00 17.22%
$1,494,000.00 $2,194,000.00 $2,294,000.00 ($100,000.00) -4.56%
$40,837.00 $121,248.00 $196,248.00 ($75,000.00)-61.86%
$0.00 $0.00 $0.00 $0.00 0.00%
Personnel
Projected favorability in Salaries and Fringes due to turnover
Operating
Dept. of Public Communications
2023 Q1 Forecast
Total
Summary of Projections
Transfers
No Transfers Out are budgeted in FY 2023
Projected unfavorability in Metered Postage ($100,000) due to the education/awareness of the Oakland County
Transit millage
Projected unfavorability in InfoTech Operations ($75,000) due to higher than anticipated use
Internal
39
COUNTY OF OAKLAND
FY 2023 FIRST QUARTER REPORT
ENTERPRISE FUNDS
ECONOMIC DEVELOPMENT
ADOPTED AMENDED FY 2023 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
OAKLAND COUNTY INTERNATIONAL
AIRPORT (56500)
OPERATING REVENUE $5,652,375.00 $5,652,375.00 $5,802,375.00 $150,000.00 2.65%-Fav. Reimb US Customs Services $150,000 due to rate increase. A budget amendment
is recommended.
OPERATING EXPENSE 7,073,309.00 7,073,309.00 7,253,309.00 (180,000.00) -2.54%-UnFav. US Customs Services ($180,000) due to expanded hours and CBP passing
100% of their costs on to the airport. A budget amendment is recommended.
NET OPERATING INCOME (LOSS)($1,420,934.00)($1,420,934.00)($1,450,934.00)($30,000.00)2.11%
NON-OPERATING REVENUE (EXPENSE)150,000.00 150,000.00 150,000.00 - 0.00%-
TOTAL INCOME BEFORE
CONTRIBUTIONS AND TRANSFERS (1,270,934.00) (1,270,934.00) ($1,300,934.00)(30,000.00) 2.36%
TRANSFERS IN
TRANSFERS OUT - - - -
CAPITAL CONTRIBUTION - - 70,000.00 70,000.00 0.00%-Fav. Capital Contributions - Federal Grant- ($70,000) for capital grants FY 2022 received
in FY 2023.
TOTAL NET INCOME (LOSS)($1,270,934.00)($1,270,934.00)($1,230,934.00)$40,000.00
TOTAL NET ASSETS - BEGINNING 77,506,069.73$
TOTAL NET ASSETS - ENDING 76,275,135.73$
40
COUNTY OF OAKLAND
FY 2023 FIRST QUARTER REPORT
INTERNAL SERVICE FUND
RISK MANAGEMENT
ADOPTED AMENDED FY 2023 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
LIABILITY INSURANCE FUND 67700
OPERATING REVENUES:
Outside Revenue $ 14,333.00 $ 14,333.00 $ 14,333.00 0.00 0.00%
Inside Revenue 9,214,000.00 9,214,000.00 9,214,000.00 0.00 0.00%
Total Operating Revenue $ 9,228,333.00 $ 9,228,333.00 $ 9,228,333.00 0.00 0.00%
OPERATING EXPENSE $ 5,948,061.00 $ 5,948,061.00 $ 5,837,797.00 110,264.00 1.85%Fav. Salaries and Fringe Benefits $165,000 due to two vacant
positions, partially offset by unfav. Indirect Costs ($41,336)
due to actual charges determined after budget finalization and
Prior year adjustments ($13,400) due to invoices submitted
after year-end.
CLAIMS PAID 3,360,000.00 3,360,000.00 3,360,000.00 0.00 0.00%
TOTAL OPERATING EXPENSES $ 9,308,061.00 $ 9,308,061.00 $ 9,197,797.00 110,264.00 1.18%
OPERATING INCOME (LOSS)(79,728.00)(79,728.00)30,536.00 110,264.00 -138.30%
NON-OPERATING REVENUE (EXPENSE) 150,000.00 150,000.00 150,000.00 - 0.00%-
NET REVENUES OVER/(UNDER)*
EXPENSES $ 70,272.00 $ 70,272.00 180,536.00 $ 110,264.00
TOTAL NET ASSETS - BEGINNING 334,946.59
TOTAL NET ASSETS - ENDING $ 515,482.59
41
COUNTY OF OAKLAND
FY2023 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
ADOPTED AMENDED FY 2023 VARIANCE
FRINGE BENEFITS FUND 67800 BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
OPERATING REVENUE
RETIREES MEDICAL - VEBA DEBT 34,001,130 34,001,130 34,001,130.00 - 0.00%
RETIREMENT ADMINISTRATION 4,437,337 4,437,337 4,100,037.00 (337,300.00) -7.60%-Unfav. due to actual revenues less than budget projections.
RETIREMENT ADMINISTRATION - PTNE 350,000 350,000 230,000.00 (120,000.00) -34.29%-Unfav. due to actual revenues less than budget projections.
DEFERRED COMPENSATION-MATCH 4,500,000 4,500,000 4,500,000.00 - 0.00%
DEFINED CONTRIBUTION PLAN 24,000,000 24,000,000 24,000,000.00 - 0.00%
DEFINED CONTRIBUTION PLAN - PTNE 200,000 200,000 200,000.00 - 0.00%
EMPLOYEE IN-SERVICE TRAINING 1,872,722 1,872,722 1,872,722.00 - 0.00%
EMPLOYEE BENEFITS UNIT 1,328,644 1,328,644 1,328,644.00 - 0.00%
EMPLOYEE RECOGNITION 275,028 275,028 275,028.00 - 0.00%
FLEX BENEFIT PLAN 85,000 85,000 85,000.00 - 0.00%
WELLNESS UNIT 521,800 521,800 521,800.00 - 0.00%
FRINGE BENEFITS 132,702 132,702 132,702.00 - 0.00%
TUITION REIMBURSEMENT 400,000 400,000 400,000.00 - 0.00%
RETIREMENT HEALTH SAVINGS 3,800,000 3,800,000 4,600,000.00 800,000.00 21.05%-Fav. due to actual revenue higher than budget projections.
GROUP LIFE INSURANCE 680,000 680,000 680,000.00 - 0.00%
SOCIAL SECURITY 21,168,500 21,168,500 21,168,500.00 - 0.00%
MEDICAL INSURANCE 39,946,197 39,946,197 39,946,197.00 - 0.00%
PRESCRIPTION COVERAGE INSURANCE 13,000,000 13,000,000 9,050,000.00 (3,950,000.00) -30.38%-Unfav. due to actual revenue less than budget projections.
DENTAL INSURANCE 3,305,000 3,305,000 3,426,000.00 121,000.00 3.66%-Fav. due to actual revenue higher than budget projections.
VISION INSURANCE 98,500 98,500 345,000.00 246,500.00 250.25%-Fav. due to actual revenue more than budget projections.
DISABILITY INSURANCE 4,200,000 4,200,000 3,600,000.00 (600,000.00) -14.29%-Unfav. due to actual revenue less than budget projections, partially offset by favorable
Disability Insurance expense.
WORKERS COMPENSATION 3,342,722 3,342,722 3,342,722.00 - 0.00%
UNEMPLOYMENT COMPENSATION 300,000 300,000 300,000.00 - 0.00%
INVESTMENT INCOME 1,500,000 1,500,000 1,500,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 175,000 175,000 175,000.00 - 0.00%
EXT - FLEX BEN LIFE INSURANCE 520,000 520,000 520,000.00 - 0.00%
EXT - FLEX BEN MEDICAL - EMPLOYEE 5,333,000 5,333,000 5,333,000.00 - 0.00%
EXT - FLEX BEN VISION INSURANCE 150,000 150,000 150,000.00 - 0.00%
EXT - FORFEITURE OF DEPOSITS & DC PLAN - - - - 0.00%
EXT - MEDICAL INSURANCE 180,000 180,000 180,000.00 - 0.00%
EXT - PRESCRIPTION DRUG REBATES 2,000,000 2,000,000 2,000,000.00 - 0.00%
EXT - TRAINING & WELLNESS 20,000 20,000 20,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 171,844,782 171,844,782 168,004,982.00 (3,839,800.00) -2.23%
42
COUNTY OF OAKLAND
FY2023 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
ADOPTED AMENDED FY 2023 VARIANCE
FRINGE BENEFITS FUND 67800 BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
OPERATING EXPENSE
RETIREES MEDICAL - VEBA DEBT INT/AGING 5,396,130 5,396,130 5,396,130.00 - 0.00%
RETIREMENT ADMINISTRATION 1,013,049 1,013,049 916,449.00 96,600.00 9.54%-Fav. Salaries and Fringe Benefits $96,600 due to vacant position within Retirement Unit.
DEFERRED COMP-COUNTY PMTS (MATCH)4,524,000 4,591,000 4,591,000.00 - 0.00%
DEFINED CONTRIBUTION PLAN 24,000,000 24,000,000 24,000,000.00 - 0.00%
DEFINED CONTRIBUTION PLAN - PTNE 200,000 200,000 200,000.00 - 0.00%
EMPLOYEE IN-SERVICE TRAINING 1,500,503 1,500,503 1,250,503.00 250,000.00 83.33%-Fav. due to lower than expected training costs.
IN-SERVICE TRAINING - INFO TECH 300,000 300,000 200,000.00 100,000.00 160.00%-Fav. due to lower than expected IT training costs.
PROFESSIONAL SERVICES 62,500 62,500 62,500.00 - 0.00%
BENEFITS ADMINISTRATION 208,741 208,741 208,741.00 - 0.00%
EMPLOYEE BENEFITS UNIT 1,216,587 1,216,587 938,987.00 277,600.00 22.82%-Fav. Salaries and Fringes $277,600 due to vacant positions.
FLEXIBLE BENEFIT PAYMENTS 85,000 85,000 85,000.00 - 0.00%
WELLNESS PROGRAM 521,744 525,094 525,094.00 - 0.00%
EMPLOYEE RECOGNITION 269,694 269,694 269,694.00 - 0.00%
ACCOUNTING SERVICES 132,937 132,937 132,937.00 - 0.00%
TUITION REIMBURSEMENT 400,000 400,000 400,000.00 - 0.00%
RETIREMENT HEALTH SAVINGS 3,800,000 3,800,000 3,800,000.00 - 0.00%
GROUP LIFE INSURANCE 1,200,000 1,200,000 1,200,000.00 - 0.00%
SICK AND ANNUAL LEAVE CASH-OUT 3,660,000 3,660,000 3,660,000.00 - 0.00%
SOCIAL SECURITY 21,168,500 21,168,500 21,168,500.00 - 0.00%
MEDICAL INSURANCE 51,050,000 51,050,000 51,050,000.00 - 0.00%
PRESCRIPTION COVERAGE 15,000,000 15,000,000 15,000,000.00 - 0.00%
DENTAL INSURANCE 3,500,000 3,500,000 3,500,000.00 - 0.00%
VISION INSURANCE 250,000 250,000 250,000.00 - 0.00%
DISABILITY INSURANCE 4,200,000 4,200,000 3,875,000.00 325,000.00 7.74%-Fav. due to actual expenses lower than budget projections, offset by unfavorable
Disability Insurance revenue.
WORKERS COMPENSATION 3,347,241 3,347,241 3,170,841.00 176,400.00 5.27%-Fav. Salaries and Fringe Benefits $176,400 due to a vacant position and one underfilled
position with a part-time employee.
UNEMPLOYMENT COMPENSATION 300,000 300,000 300,000.00 - 0.00%
CHILD CARE FACILITY 301,838 301,838 301,838.00 - 0.00%
HEALTH INSURANCE PREMIUM TAX - - - -
MICHIGAN IPAA TAX 15,000 15,000 15,000.00 -
PATIENT CENTERED OUTCOME RESEARCH 28,000 28,000 28,000.00 - 0.00%
INDIRECT COSTS 260,000 260,000 131,300.00 128,700.00 49.50%-Fav. due to projected charges developed after budget finalization.
PENALTIES - - - -
TOTAL EXPENSE 147,911,464 147,981,814 146,627,514.00 1,354,300.00 0.92%
NET REVENUE OVER/(UNDER) EXPENSES 23,933,318.00 23,862,968.00 21,377,468.00 (5,194,100.00)
TOTAL NET ASSETS - BEGINNING 386,553,154.51
TOTAL NET ASSETS - ENDING 407,930,622.51
Note: Does not reflect FY 2023 GASB #68 and GASB #75 impact yet; actuary reports are excepted in mid December 2023 and impact will be reflected in the FY 2023 CAFR.
{print "selection";1;9999;1;1}
43
FY 2023 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2022 VARIANCE
BUDGET BUDGET Actual FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCESBUDGETBUDGETFORECASTFAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING REVENUES:
Outside 2,585,225.00$ 2,585,225.00$ 2,363,225.00$ (222,000.00)$ -8.59%-Unfav. Outside Agencies ($215,500) and Sale of Equipment ($6,500) due to
higher than anticipated usage
Inside 34,561,125.00 34,572,375.00 35,094,375.00 522,000.00 1.51%-Fav. OC Depts Operations & Non Governmental Operations $1,686,700
offset by unfav. OC Depts Development Support & Non Governmental
Development ($1,153,700) due to increased rates. Unfav. FOIA Fees
($11,000) due to higher than anticipated costs.
TOTAL OPERATING REVENUE 37,146,350.00$ 37,157,600.00$ 37,457,600.00$ 300,000.00$ 0.81%
OPERATING EXPENSES 54,609,499.00 54,932,039.00 56,175,339.00 (1,243,300.00) -2.26%-Unfav. Professional Services ($2,250,800) due to projects previously
approved in prior year; Charge Card Fees ($547,500) and Bank Charges
($22,600) for credit card activity; Parts and Accessories ($420,700) and
Communications ($55,900) due to higher than anticipated costs; Contracted
Services ($278,000),Indirect Costs ($215,200), Equipment Maintenance
($144,600) and Maintenance Contracts ($177,000) due to increased activity.
Offset by fav. Salaries and Fringes $2,184.700 due to vacanies; Exp
Equipment $383,500 for equip replacement; Internal Services $290,300 is
primarily due to fav. Insurance Fund; Supplies $4,900, Membership Dues
$3,300 and Postage $600 due to usage and Auction $1,700.
.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (17,463,149.00)$ (17,774,439.00)$ (18,717,739.00)$ (943,300.00)$ 5.31%
NON-OPERATING REVENUE 70,500.00$ 70,500.00$ 70,500.00$ -$ 0.00%
TRANSFERS IN 7,921,944.00$ 8,305,059.00$ 8,305,059.00$ -$ 0.00%
TRANSFERS (OUT)-$ -$ -$ -$ 0.00%
CAPITAL CONTRIBUTION -$ -$ -$ -$ 0.00
NET REV OVER(UNDER) EXP*(9,470,705.00)$ (9,398,880.00)$ (10,342,180.00)$ (943,300.00)$
TOTAL NET POSITION - BEGINNING 43,884,644.55$
TOTAL NET POSITION - ENDING 33,542,464.55$
*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)
44
FY 2023 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2022 VARIANCE
BUDGET BUDGET Actual FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCESBUDGETBUDGETFORECASTFAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING REVENUES:
Outside 12,000.00$ 12,000.00$ 7,300.00$ (4,700.00)$ -39.17%Unfav. Sale of Phone External due to decreased usage of land lines.
Inside 3,595,361.00 3,595,361.00 3,945,861.00$ 350,500.00$ 9.75%Fav. Sale of Phone due to cell phone usage.
TOTAL OPERATING REVENUE 3,607,361.00$ 3,607,361.00$ 3,953,161.00$ 345,800.00$ 9.59%
OPERATING EXPENSES 3,601,223.00$ 3,601,223.00$ 3,845,423.00$ (244,200.00)$ -6.78%Unfav. Communications ($971,800) and Maintenance Equipment (244,100)
due to higher than anticipated cost; Equipment Repairs and Maintenance
($9,900); Internal Services ($58,900) primarily due to Info Tech Operations
($14,900) and Telephone ($44,200) based on actual usage; Indirect Cost
($60,800) due to actual charges being developed after budget finalization.
Partially offset by fav. Contracted Services $987,200 due to less than
anticipated activity; Expendable Equipment $90,200 for equipment
replacement; Sublet Repairs $22,200 due to lower than anticipated repair
volume; Fav. Salaries & Fringes $1,700 due to less than anticipated
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS 6,138.00$ 6,138.00$ 107,738.00$ 101,600.00$
NON-OPERATING REVENUE 30,000.00$ 30,000.00$ 29,100.00$ (900.00)$ -3.00%Unfav. Interest Income due to less than anticipated level of cash available for
investments.
TRANSFERS IN -$ -$ -$ -$ 0.00%
CAPITAL CONTRIBUTION -$ -$ -$ -$ 0.00%
TRANSFERS (OUT)-$ -$ -$ -$ 0.00%
NET REV OVER(UNDER) EXP*36,138.00$ 36,138.00$ 136,838.00$ 100,700.00$
TOTAL NET POSITION - BEGINNING 2,119,432.74$
TOTAL NET POSITION - ENDING 2,256,270.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)
45
FY 2023 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2022 VARIANCE
BUDGET BUDGET Actual FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCESBUDGETBUDGETFORECASTFAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Information Technology - CLEMIS (53500)
OPERATING REVENUES:
Outside 5,250,130.00$ 5,250,130.00$ 5,277,430.00$ 27,300.00$ 0.52%Fav. In-Car Terminals (External) $28,800 for fleet of CLEMIS agencies;
Access Fees Non Oakland $24,900 offset by unfav. Access Fees Oakland
($50,400) due to updated law enforcement Full Time Equivalent count used
for billing. Also fav. CLEMIS Crash $55,000 due to increased usage by
Oakland and non-Oakland agencies. Partially offset by unfav. CLEMIS
Citation ($27,600),Crime Mapping ($1200), Parts and Accessories ($1,600)
and CLEMIS Parking ($500) due to decreased activity.
Inside 1,776,737.00 1,776,737.00 1,696,437.00 (80,300.00)$ -4.52%Unfav. Reimb General ($72,900) based on actuals for CLEMIS staff
supporting Sheriff project; In-Car Terminal ($4,400) due to participation
count higher than budget projection and OC Depts Operations ($3,000)
based on anticipated CLEMIS staff resources supporting Sheriff projects.
TOTAL OPERATING REVENUE 7,026,867.00$ 7,026,867.00$ 6,973,867.00$ (53,000.00)$ -0.75%
OPERATING EXPENSES 12,538,963.00$ 12,538,963.00$ 11,254,663.00$ 1,284,300.00$ 10.24%Fav. Depreciation $1,166,800 based on depreciation schedule; Salaries and
Fringes $694,000 due to vacanies; Indirect Cost $17,500. Offset by unfav.
Internal Services ($121,900) primarily due to IT Development due to usage;
Software Rental ($68,000), due to decreased costs; Professional Services
($390,500) due to higher than anticipated contractual costs for staffing
services. Also, unfav. Rebillable Services ($13,700) based on actual
connectivity costs to Tier 2.5.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (5,512,096.00)$ (5,512,096.00)$ (4,280,796.00)$ 1,231,300.00$
NON-OPERATING REVENUE 35,000.00$ 35,000.00$ 32,200.00$ (2,800.00)$ -8.00%Unfav. Interest Income due to less than anticipated level of cash available for
investments.
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*(3,832,910.00)$ (3,832,910.00)$ (2,604,410.00)1,228,500.00$
TOTAL NET POSITION - BEGINNING 7,596,587.24
TOTAL NET POSITION - ENDING 4,992,177.24
46
FY 2023 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2022 VARIANCE
BUDGET BUDGET Actual FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCESBUDGETBUDGETFORECASTFAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
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.
OPERATING REVENUES:
Outside 9,265,600.00$ 9,265,600.00$ 9,396,700.00$ 131,100.00$ 1.41%Fav. Antenna Site Mgmt. $125,000 due to updates in rental contracts and
Outside Agency Revenue $6,100 due to lower non-emergency agencies than
anticipated.
Inside 491,829.00$ 491,829.00$ 362,129.00$ (129,700.00)$ -26.37%Unfav. Parts and Accessories ($118,100) and Productive Labor ($11,600)
due to lower than anticpated reimbursement by participating agencies for
equipment replacement.
TOTAL OPERATING REVENUE 9,757,429.00$ 9,757,429.00$ 9,758,829.00$ 1,400.00$ 0.01%
OPERATING EXPENSES 10,911,243.00$ 11,334,157.00$ 6,463,757.00$ 4,870,400.00$ 42.97%Fav. Depreciation $4,831,200 based on depreciation schedule; Exp
Equipment $93,600 for equipment replacement; Tower Charges $41,800 and
Parts and Accessories $13,100 due to lower than anticipated usage; Internal
Services $72,000 primarily due to Info Tech CLEMIS based on usage;
Training $75,000, Travel and Conference $22,600 and Mileage $3,500 due to
less travel to conferences; Salaries and Fringes $20,500 due to fringes.
Partially offset unfav. Software Support Maintenance ($257,000) due to
timing of Emergency Services lP Network Project; Electrical Service
($13,800) due to usage; Indirect Costs ($12,500), Special Projects ($11,200),
Supplies ($2,700) and Freight Express ($5,700) due to usage.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (1,153,814.00)$ (1,576,728.00)$ 3,295,072.00$ 4,871,800.00$
NON-OPERATING REVENUE 100,000.00$ 100,000.00$ 87,300.00$ (12,700.00)$ -12.70%Unfav. Interest Income due to less than anticipated level of cash available for
investments.
TRANSFERS IN 24,000.00$ 494,914.00$ 494,914.00$ -$ 0.00%
TRANSFERS (OUT)(286,000.00)$ (286,000.00)$ (286,000.00)$ -$ 0.00%
NET REV OVER(UNDER) EXP*(1,315,814.00)$ (1,267,814.00)$ 3,591,286.00$ 4,859,100.00$
TOTAL NET POSITION - BEGINNING 46,911,499.18$
Information Technology - Radio Communications (53600)
47
FY 2023 FIRST QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2022 VARIANCE
BUDGET BUDGET Actual FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCESBUDGETBUDGETFORECASTFAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
TOTAL NET POSITION - ENDING 50,502,785.18$
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.
Fire Records Management ( 53100)
OPERATING REVENUES:
Outside 346,295.00$ 346,295.00$ 346,295.00$ -$ 0.00%
.
TOTAL OPERATING REVENUES 346,295.00$ 346,295.00$ 346,295.00$ -$ 0.00%
OPERATING EXPENSES 1,107,597.00$ 1,107,597.00$ 972,197.00$ 135,400.00$ 12.22%Fav. Salaries and Fringes $194,300 due to vacanies and Internal Services
$7,800 primarily due to Insurance Fund. Partially offset by unfav.
Professional Services ($64,600) due to increased activity and IIndirect Costs
($1,800) and Software Maintenance ($300).
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (761,302.00)$ (761,302.00)$ (625,902.00)$ 135,400.00$
NON-OPERATING REVENUE 3,000.00$ 3,000.00$ 2,700.00$ (300.00)$ -10.00%
TRANSFERS IN 504,611.00$ 504,611.00$ 504,611.00$ -$ 0.00%
TRANSFERS (OUT)-$ -$ -$ - 0.00%
CAPITAL CONTRIBUTION -$ -$ -$ - 0.00%
NET REV OVER(UNDER) EXP*(253,691.00)$ (253,691.00)$ (118,591.00)135,100.00
TOTAL NET POSITION - BEGINNING 1,399,590.62$
TOTAL NET POSITION - ENDING 1,280,999.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.
48
COUNTY OF OAKLAND
FY 2023 First Quarter Report
INTERNAL SERVICE FUNDS
CENTRAL SERVICES
ADOPTED AMENDED FY 2023 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
MOTOR POOL FUND 66100
OPERATING REVENUE:
Outside Revenue 130,000.00$ 130,000.00$ 130,000.00 -$ 0.00%
Inside Revenue 8,993,108.00 9,172,361.00 9,202,761.00 30,400.00 0.33%-Fav. Gasoline, Oil & Grease Charges $342,400 due to current fuel costs (partially
offset by unfavorable Gasoline expense), partially offset by unfavorable Leased
Equipment ($312,000) due to actual activity trends to date and also attributed to the
delay in new product delivery.
Total Revenue 9,123,108.00 9,302,361.00 9,332,761.00 30,400.00
OPERATING EXPENSE 10,010,769.00 10,143,225.00 10,492,625.00 (349,400.00) -3.44%-Unfav. Gasoline Charges ($284,400) due to market fluctuations and miles driven
(offset by favorable Gasoline, Oil Grease Charges revenue) and Indirect Costs
($65,000) due to the development of actual charges after budget finalization.
OPERATING INCOME (LOSS)(887,661.00) (840,864.00) (1,159,864.00) (319,000.00)
NON-OPERATING REVENUE
(EXPENSE)
542,700.00 542,700.00 942,700.00 400,000.00 73.71%Fav. Income $400,000 due to higher that anticipated Gain on Sale of Vehicles due
to abnormally high used vehicle values.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (344,961.00) (298,164.00) (217,164.00) 81,000.00
TRANSFERS IN / (OUT)421,151.00 659,883.00 659,883.00 - 0.00%
CAPITAL CONTRIBUTIONS - - - -
NET REVENUE OVER/(UNDER)
EXPENSES (PLANNED USE OF
FUND BAL.) *
76,190.00$ 361,719.00$ 442,719.00$ 81,000.00$
TOTAL NET ASSETS - BEGINNING 12,061,250.24$
TOTAL NET ASSETS - ENDING 12,503,969.24$
3/9/2023
49
COUNTY OF OAKLAND
FY 2023 FIRST QUARTER REPORT
ENTERPRISE FUND
PARKS & RECREATION
ADOPTED AMENDED FY 2023 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
OAKLAND COUNTY PARKS & RECREATION COMMISSION
(50800)
OPERATING REVENUE 11,953,357.00$ 11,953,357.00$ 11,953,357.00$ -$ 0.00%
OPERATING EXPENSE 34,293,299.00$ 34,297,828.00$ 34,297,828.00$ -$ 0.00%
NET OPERATING INCOME (LOSS)(22,339,942.00)$ (22,344,471.00)$ (22,344,471.00)$ -$ 0.00%
NON-OPERATING REVENUE (EXPENSE)24,928,577.00$ 25,073,077.00$ 25,073,077.00$ -$ 0.00%
TOTAL INCOME BEFORE TRANSFERS 2,588,635.00$ 2,728,606.00$ 2,728,606.00$ -$ 0.00%
TRANSFERS IN (OUT)(75,000.00)$ (75,000.00)$ (75,000.00)$ -$ 0.00%
TOTAL NET INCOME/BUDGETED EQUITY ADJ 2,513,635.00$ 2,653,606.00$ 2,653,606.00$ -$
TOTAL NET POSITION - BEGINNING 96,337,860.96$
TOTAL NET POSTION - ENDING 98,991,466.96$
50
COUNTY OF OAKLAND
FY 2023 FIRST QUARTER REPORT
ENTERPRISE FUND
PARKS & RECREATION
EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
51
ADOPTED AMENDED FY 2023 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DRAIN EQUIPMENT FUND ( 63900)
OPERATING REVENUES:
Inside 53,380,714.00$ 53,380,714.00$ 52,380,714.00$ (1,000,000.00)$ -1.87%Unfav - Reimbursement Salaries ($1,000,000) due to unallocated
payroll charges for turnover and vacant positions, offset in Salaries
and Fringes.
Outside 310,100.00 310,100.00 310,100.00 - 0.00%
Total Revenue 53,690,814.00 53,690,814.00 52,690,814.00 (1,000,000.00)-1.86%
OPERATING EXPENSES $56,450,645.00 $56,450,645.00 $55,348,445.00 $1,102,200.00 1.95%Fav - Salaries and Fringes $1,000,000 due to turnover and vacant
positions. Fav - Depreciation Computer Software $120,000 due to
the Supervisory Control and Data Acquisition (SCADA) system
common to all project not being booked in first quarter FY 2023.
NET INCOME (LOSS) BEFORE ($2,759,831.00)($2,759,831.00)($2,657,631.00)$102,200.00 -3.70%
NON-OPERATING REVENUE/(EXPENSE)$212,600.00 $212,600.00 $212,600.00 - 0.00%
TRANSFER IN - 215,000.00 215,000.00 - 0.00%
TRANSFERS (OUT) 278,419.00 278,419.00 278,419.00 - 0.00%
NET REVENUES OVER (UNDER)
EXPENSES*
($2,825,650.00)($2,610,650.00)($2,508,450.00)$102,200.00
WATER RESOURCES COMMISSIONER
FY 2023 FIRST QUARTER REPORT
INTERNAL SERVICE FUND
COUNTY OF OAKLAND
52
ADOPTED AMENDED FY 2023 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
WATER RESOURCES COMMISSIONER
FY 2023 FIRST QUARTER REPORT
INTERNAL SERVICE FUND
COUNTY OF OAKLAND
TOTAL NET POSITION - BEGINNING 34,139,228.83$
TOTAL NET POSITION - ENDING 31,630,778.83$
*Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses.
53
TREASURER'S OFFICE
ADOPTED AMENDED FY 2023 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 2,000,000.00 2,000,000.00 2,000,000.00 - 0.00%
Transfers In - - - - 0.00%
Total Revenues $12,500,000.00 $12,500,000.00 $12,500,000.00 -$ 0.00%
OPERATING EXPENSES
Personnel Expenditures 267,612.00$ 267,612.00$ 267,612.00$ -$ 0.00%
Operating Expenditures 419,655.00 419,655.00 419,655.00 - 0.00%
Interest Expense 1,000,000.00 1,000,000.00 1,000,000.00 - 0.00%
Transfer Out to Other Funds:
General Fund - Collection Fees 2,300,000.00 2,300,000.00 2,300,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 1,508,000.00 1,508,000.00 1,508,000.00 - 0.00%
Office Bldg Renovation Refunding Debt Svc 1,860,850.00 1,860,850.00 1,860,850.00 - 0.00%
52-3 District Court Refunding Debt Svc 1,291,500.00 1,291,500.00 1,291,500.00 - 0.00%
Total Transfer Out to Other Funds 11,960,350.00$ 11,960,350.00$ 11,960,350.00$ -$ 0.00%
Total Operating Expenses 13,647,617.00$ 13,647,617.00$ 13,647,617.00$ -$ 0.00%
REVENUE OVER (UNDER)
EXPENDITURES*($1,147,617.00)($1,147,617.00)($1,147,617.00)$0.00
Total Net Position - Beginning $208,089,434.68
Total Net Position - Ending $206,941,817.68
Ending FY 2021 Designated Net Position**:
NP-UnRes - Designated - Debt Service $53,276,854.00
NP-UnRes - Designated - Delinq Taxes Receivable 148,733,472.22
NP-UnRes - Designated - Collection Fees 6,079,108.46
Undesignated - Net Position ($1,147,617.00)
Total Net Position - Ending $206,941,817.68
* 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 2023 FIRST QUARTER REPORT
ENTERPRISE FUND
54
FY 2023 FIRST QUARTER REPORT
INTERNAL SERVICE FUND
FACILITIES MANAGEMENT
ADOPTED AMENDED FY 2023 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
FACILITIES MAINTENANCE & OPERATIONS (#63100)
OPERATING REVENUES:
Outside Revenue 538,363.00$ 538,363.00$ 563,363.00$ 25,000.00$ 4.64%Fav. Ext- Other Revenue $50,000 primarily due to more than anticipated
Outside Agencies Maintenance Charges for Oakland Community Health
Network (OCHN) - Resource Crisis Center. Partially offset by unfav. Ext-
Other Revenue ($25,000) due to delays in materials and staffing for
implementation of the paper and cardboard recycling programs.
Inside Revenue 27,515,728.00 27,515,728.00 27,515,728.00 - 0.00%
Total Revenue 28,054,091.00$ 28,054,091.00$ 28,079,091.00$ 25,000.00$ 0.09%
OPERATING EXPENSES 30,924,598.00$ 30,924,598.00$ 29,424,598.00$ 1,500,000.00$ 4.85%Fav. Salaries and Fringe Benefits $1,750,000 due to turnover, underfilled
and vacant positions; Electrical Service $375,000 due to lower-cost third-
party contracts and savings from FM&O energy conservation initiatives;
Water & Sewage Charges $275,000 based on actual usage; Material and
Supplies $150,000 due to a delayed lead time for materials impacting
delivery of goods; Professional Services $125,000 due to timing of design
engineering services for current projects; Info Tech Development $50,000
due to delay in upgrading software; Fuel Oil $25,000 due to lack of supply in
low sulfur fuel.
Partially offset by unfav. Sublet Repairs ($775,000) due to an increase in
demand for critical repair work needs and contractor costs; Maintenance
Supplies ($300,000) as well as Grounds Supplies ($25,000) based on
increased use of materials for services performed internally, aging
equipment, and product price increases; Natural Gas ($150,000) due to
current market conditions.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (2,870,507.00)$ (2,870,507.00)$ (1,345,507.00)$ 1,525,000.00$
NON-OPERATING REVENUE 140,000.00$ 140,000.00$ 115,000.00$ (25,000.00)$ -17.86%Unfav. Income from Investments due to investment base and market rate
adjustments.
TRANSFERS IN -$ -$ -$ -$ 0.00%
TRANSFERS OUT -$ -$ -$ -$ 0.00%
NET REVENUES OVER(UNDER)
EXPENSES*(2,730,507.00)$ (2,730,507.00)$ (1,230,507.00)$ 1,500,000.00$
TOTAL NET POSITION - BEGINNING 8,635,092.51$
TOTAL NET POSITION - ENDING 7,404,585.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
55
COUNTY OF OAKLAND
FY 2023 FIRST QUARTER REPORT
ENTERPRISE FUNDS
TREASURER
ADOPTED AMENDED FY 2023 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 536,288.00 536,288.00 498,288.00 $38,000.00 7.09%Fav. Controllable Personnel $20,000 due to vacant and underfilled
positions. Also fav. Professional Services $15,000 and Metered
Postage $3,000 due to less than anticipated use.
NET OPERATING INCOME (LOSS)($30,152.00)($30,152.00)$7,848.00 $0.00 0.00%
NON-OPERATING REVENUE (EXPENSE)5,000.00 5,000.00 $5,000.00 $0.00 0.00%
TOTAL INCOME BEFORE
CONTRIBUTIONS AND TRANSFERS ($25,152.00)($25,152.00)12,848.00$ $0.00
TRANSFERS OUT - - - -
TOTAL NET INCOME (LOSS)*($25,152.00)($25,152.00)$12,848.00 $0.00
TOTAL NET POSITION - BEGINNING 1,133,473.33
TOTAL NET POSITION - ENDING $1,146,321.33
* Please note that in the Adopted Budget (line-item book) this is budgeted as 'Planned Use of Balance" in the revenue category.
56
Receipt Number Amount Journal Number
10/3/2022 Mark Mudd 85902 $5.00 JE005554
10/3/2022 Carel Dunshee 85903 $120.00 JE005554
10/3/2022 Elissa Staeuble 85905 $25.00 JE005554
10/3/2022 Diane Frushour 85910 $20.00 JE005554
10/3/2022 Dennis Firestone 85942 $5.00 CS005725
10/3/2022 Sarah Reilly 85949 $0.80 CS005725
10/3/2022 Parag Mishra 85966 $5.00 CS005725
10/4/2022 Donation Box 85958 $28.00 JE005629
10/4/2022 Stacey Rose-Zubal 85988 $5.00 CS005725
10/4/2022 Samantha Griffith 86006 $0.80 CS005725
10/5/2022 Molly Bylsma 86008 $0.35 CS005725
10/5/2022 Scott Cochrane 86047 $10.00 CS005725
10/6/2022 Kathleen Gingras 86044 $200.00 CS005725
10/6/2022 Jailan Elayoubi 86055 $0.80 CS005725
10/6/2022 Dave Cushing 86100 $5.00 CS005725
10/6/2022 Nick Haugen 86113 $0.70 CS005725
10/7/2022 Jennifer Harris 86068 $75.00 JE005707
10/7/2022 Katherine Leung 86075 $781.00 JE005706
10/7/2022 Marissa Miller 86087 $17.00 JE005706
10/7/2022 Jill DrennonBrady 86099 $5.00 CS005922
10/8/2022 Jorge Vergara 86103 $0.45 CS005922
10/8/2022 James Wright 86200 $0.80 CS005922
10/10/2022 Alfred Demailo 86109 $100.00 JE005775
10/10/2022 Independent Bank 86116 $1500.00 JE005776
10/10/2022 Thomas Borowiak 86117 $10.00 CS005922
10/10/2022 Cheryl Herrick 86138 $5.00 CS005922
10/11/2022 Angela Ziegler 86136 $5.00 CS005922
10/11/2022 Kyle Lagrois 86144 $5.00 CS005922
10/11/2022 Kyle Lagrois 86145 $5.00 CS005922
10/11/2022 Cheryl Herrick 86147 $5.00 CS005922
10/11/2022 Misty Crawford 86153 $0.80 CS005922
10/11/2022 Beth Beyer 86162 $0.80 CS005922
10/11/2022 Jen Piche 86163 $10.00 CS005922
10/11/2022 Theary Ryder 86170 $5.00 CS005922
10/11/2022 Theary Ryder 86171 $5.00 CS005922
10/13/2022 Salah Alghurbani 86238 $0.35 CS006217
10/14/2022 Ana Suarez-Cortez 86239 $0.90 CS006217
10/15/2022 Terri Steele 86254 $150.00 JE006172
10/17/2022 Amanda Greenwood 86278 $5.00 CS006217
10/17/2022 Gary Ankers 86297 $5.00 CS006217
10/18/2022 Matt Allison 86318 $0.80 CS006217
10/19/2022 Donation Box 86332 $29.00 JE006446
10/19/2022 Margret Knauf 86351 $0.35 CS006217
10/19/2022 Treva Fairman 86352 $5.00 CS006217
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - FY 2023 - First Quarter
Date of Donation Person Donating
57
Receipt Number Amount Journal Number
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - FY 2023 - First Quarter
Date of Donation Person Donating
10/19/2022 Nancy Robinson 86473 $10.00 CS006217
10/21/2022 Zoom Room 86382 $267.50 JE006687
10/21/2022 Dean And Nina
Googasian
86386 $150.00 JE006687
10/21/2022 John Little 86391 $5.00 JE006687
10/21/2022 Kristin Harpster 86393 $5.00 CS006464
10/21/2022 Sheldon Adelson 86394 $20.00 JE006688
10/22/2022 Lynne Vossler 86423 $50.00 CS006464
10/22/2022 Wendy Champoux 86424 $0.80 CS006464
10/23/2022 Valerie Garcia 86420 $10.00 CS006464
10/23/2022 Valerie Garcia 86421 $10.00 CS006464
10/24/2022 Ann Marie Young 86439 $0.80 CS006464
10/25/2022 Ann Marie Young 86472 $5.00 CS006464
10/26/2022 Stacie Duff 86483 $5.00 CS006464
10/27/2022 Talia Abedon 86509 $25.00 CS006464
10/28/2022 Joel Hack 86554 $17.60 CS006725
10/28/2022 John Gielow 86564 $5.00 CS006725
10/29/2022 Melissa Hall 86560 $0.45 CS006725
10/29/2022 Kelsey Epperson 86561 $0.80 CS006725
10/30/2022 Amy Kiebler Werner 86556 $0.35 CS006725
10/30/2022 Christopher Lovejoy 86558 $0.80 CS006725
10/30/2022 Anthony Theodore 86662 $1.00 CS006725
10/31/2022 Bernadette Tomko 86572 $100.00 JE007288
10/31/2022 Erin Hubble 86584 $5.00 CS006725
10/31/2022 Erin Hubble 86585 $5.00 CS006725
$3,863.80
11/2/2022 Elissa Staeuble 86618 $25.00 JE007476
11/2/2022 Mark Mudd 86619 $5.00 JE007476
11/2/2022 Keith Langham 86620 $50.00 JE007476
11/2/2022 Bradley Dicks 86624 $5.00 CS006725
11/3/2022 Lori Stack 86653 $75.00 JE007476
11/6/2022 Adriana Hockenberry 86693 $20.00 CS006876
11/7/2022 Rub-A-Dub Dogs 86729 $25.00 JE007567
11/7/2022 Moira Hagan 86733 $0.45 CS006876
11/7/2022 Larry Spilkin 86734 $150.00 CS006876
11/7/2022 Paula Heisler 86737 $50.00 JE007717
11/7/2022 Nick Xydas 86739 $50.00 JE007717
11/8/2022 Kourtney Howes 86753 $0.35 CS006876
11/9/2022 Alfred Demailo 86764 $100.00 CS006876
11/9/2022 Barbara Allison 86765 $25.00 JE007717
11/9/2022 Tammy Crown 86772 $100.00 JE007717
11/10/2022 Donation Box 86803 $101.00 JE007718
11/10/2022 Melissa Tomkins 86805 $75.00 JE007717
October 2022 Total
58
Receipt Number Amount Journal Number
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - FY 2023 - First Quarter
Date of Donation Person Donating
11/10/2022 Jeffrey Helgendorf 86806 $50.00 JE007717
11/11/2022 Kimberly Luepke 86822 $0.88 JE007883
11/14/2022 Janet Buckingham 86839 $20.00 JE007882
11/14/2022 Joe Klavitter 86849 $7.00 JE007883
11/16/2022 Jun Wang 86886 $ 1,000.00 JE008055
11/16/2022 Alexander Salley 86918 $0.80 CS007362
11/17/2022 Satoshi Yoshida 86932 $0.80
11/18/2022 Gretchen Bailey 86939 $50.00 JE008175
11/21/2022 Jennifer Ristovski 86979 $100.00 JE008176
11/21/2022 Jason Pirvu 86990 $20.00 CS007362
11/22/2022 GXO Logistics 87000 $150.00 JE008259
11/23/2022 James Reynolds 87014 $100.00 JE008259
11/23/2022 Kyle Kijorski 87015 $5.00 CS007604
11/27/2022 Cheryl Ohlert 87126 $0.35 CS007604
11/28/2022 Jill Nussel 87039 $50.00 JE008327
11/28/2022 Fred Nuttall 87040 $180.00 JE008327
11/28/2022 John Little 87047 $5.00 JE008327
11/28/2022 Debra Conquest 87048 $50.00 JE008327
11/28/2022 Timothy Stallcup 87049 $75.00 JE008327
11/29/2022 Donation Box 87072 $41.50 JE008440
11/29/2022 Amy Anderson 87088 $27.00 JE008440
11/29/2022 Phyllis Goodman 87092 $20.00 CS007604
11/29/2022 Linda Maar 87099 $25.00 CS007604
11/29/2022 Caleb Montgomery 87127 $5.00 CS007604
$2,840.13
12/1/2022 Nora Towne 87131 $20.00 CS007604
12/1/2022 Richard Staton 87132 $5.00 CS007604
12/1/2022 Emily Davey 87136 $0.80 CS007604
12/1/2022 monica Duran 87137 $5.00 CS007604
12/1/2022 James Kilgore 87141 $2.00 JE008567
12/1/2022 Merceds Ward 87147 $50.00 JE008567
12/1/2022 Emily Sunderlik 87149 $0.25 CS007604
12/1/2022 Kathryn Ellis 87150 $5.00 CS007604
12/1/2022 David Poole 87156 $0.25 CS007604
12/1/2022 Mark Trapp 87159 $10.00 CS007604
12/1/2022 Rebecca Ridley 87166 $100.00 JE008566
12/1/2022 Mary Shea 87167 $10.00 CS007604
12/1/2022 Pamela Woodruff 87172 $150.00 JE008566
12/1/2022 Greg Fitzpatrick 87173 $5.00 CS007604
12/1/2022 Pauline Yousif 87190 $5.00 CS007751
12/1/2022 Satoshi Yoshida 87196 $0.25 CS007604
12/2/2022 Evanne Dietz 87201 $50.00 CS007751
12/2/2022 Brian Anderson 87210 $150.00 JE008566
November 2022 Total
59
Receipt Number Amount Journal Number
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - FY 2023 - First Quarter
Date of Donation Person Donating
12/2/2022 Kristy Martin 87213 $10.00 CS007751
12/2/2022 Judith Moses 87216 $100.00 JE008567
12/2/2022 Tammy Moery 87221 $ 25.00 JE008567
12/2/2022 Christopher Cortes 87227 $ 0.80 CS007751
12/2/2022 Marcus Wallace 87229 $ 0.80 CS007751
12/2/2022 Myndi Weinraub 87232 $ 0.55 CS007751
12/2/2022 Linnea Holycross 87233 $ 0.80 CS007751
12/2/2022 Patricia Ko 87237 $ 4.55 CS007751
12/2/2022 Joseph Yudasz 87242 $0.80 CS007751
12/2/2022 Alyssa Davis 87271 $5.00 CS007751
12/2/2022 Charlotte Lyons 87324 $5.00 CS007751
12/3/2022 Janel King 87259 $150.00 JE008653
12/3/2022 Kevin Lane 87274 $5.00 CS007751
12/3/2022 Jill Rodriguez 87284 $8.80 CS007751
12/3/2022 Alec Cahaney 87291 $5.00 CS007751
12/3/2022 Michael Kosnik 87292 $0.80 CS007751
12/3/2022 Julia Gilbert 87293 $10.00 CS007751
12/3/2022 Bryan Krieger 87312 $ 5.00 CS007751
12/3/2022 Michelle Utsler 87317 $4.25 CS007751
12/4/2022 Katherine Glover 87269 $0.55 CS007751
12/4/2022 Sev Tringali 87294 $20.00 CS007751
12/4/2022 Edwin George 87295 $7.00 CS007751
12/4/2022 Carol Rotrock 87301 $10.00 CS007751
12/4/2022 Jane Graham 87303 $10.00 CS007751
12/4/2022 Cassondra Barron 87306 $10.00 CS007751
12/4/2022 Nicole Shellnut 87311 $ 0.55 CS007751
12/4/2022 Jenny Dibble 87314 $ 5.00 CS007751
12/4/2022 Isabel Homan 87330 $ 5.00 CS007751
12/5/2022 Judi Morrissey 87331 $ 0.55 CS007751
12/5/2022 Marina Freeburg 87333 $ 2.25 CS007751
12/5/2022 Leslie Gonway 87340 $50.00 CS007751
12/5/2022 Jimmy Tillman 87352 $100.00 JE008652
12/5/2022 Carolyn Currie 87355 $300.00 JE008652
12/5/2022 Sharon McLain 87360 $10.00 CS007751
12/5/2022 Kendra Shuck 87378 $10.00 JE008653
12/5/2022 M. Carmen Meerschaert 87385 $20.00 CS007751
12/5/2022 Andrew Lewis 87390 $5.00 CS007751
12/5/2022 Liz Comerford 87391 $5.00 CS007751
12/5/2022 Patrick Farrell 87392 $5.00 CS007751
12/5/2022 Heidi Schachinger 87398 $5.00 CS007751
12/6/2022 Micheal May 87402 $0.80 CS007751
12/6/2022 Zachary Martin 87411 $ 20.00 JE008652
12/6/2022 Kristen Jamison 87412 $10.00 CS007751
60
Receipt Number Amount Journal Number
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - FY 2023 - First Quarter
Date of Donation Person Donating
12/6/2022 Annelise Huber 87420 $5.00 CS007751
12/6/2022 April Boehm 87430 $0.25 CS007751
12/6/2022 Margaret Elias 87433 $0.80 CS007751
12/6/2022 Kelly Garnett 87434 $10.00 CS007751
12/6/2022 Rob Warner 87436 $10.00 CS007751
12/6/2022 Lorinda Kingins 87454 $4.55 CS007751
12/7/2022 David Schang 87466 $100.00 JE008741
12/7/2022 John Little 87467 $5.00 JE008740
12/7/2022 Mark Mudd 87468 $5.00 JE008740
12/7/2022 Katherine Vanhoy 87470 $222.00 JE008740
12/7/2022 Alfred Demailo 87471 $125.00 JE008740
12/7/2022 Paula Quasarano 87472 $50.00 JE008740
12/7/2022 Elissa Staeuble 87473 $25.00 JE008740
12/7/2022 Meredith Allan 87478 $20.00 CS007751
12/7/2022 Kim Burke 87484 $0.55 CS007751
12/7/2022 Gina Chan 87506 $0.80 CS007751
12/7/2022 Emily Veillette 87510 $30.00 JE008740
12/7/2022 Dale Telgenhoff 87513 $100.00 JE008740
12/7/2022 Karen Hendricks 87516 $5.00 CS007751
12/7/2022 Victor Amaducci 87520 $10.00 CS007751
12/7/2022 Prerana Rajhans 87524 $5.00 CS007751
12/7/2022 Lauren Anderson 87962 $0.60 CS007751
12/7/2022 Kinship Partners Wire Transfer $50.00 JES-0260116
12/8/2022 Ramona Nave 87527 $2000.00 JE008740
12/8/2022 Cara Duffy-Martin 87532 $0.55 CS007751
12/8/2022 Michael Greifenberg 87542 $0.80 CS007751
12/8/2022 Michael Greifenberg 87543 $0.80 CS007751
12/8/2022 Michael Berry 87545 $5.00 CS007751
12/8/2022 Vivian Heinrich 87557 $50.00 JE008740
12/8/2022 Vivian Heinrich 87558 $50.00 JE008740
12/8/2022 Shawn Miller 87568 $5.00 CS007751
12/8/2022 Kenneth Thomas 87570 $10.00 CS007751
12/8/2022 Amanda Pascoe 87572 $0.55 CS007751
12/9/2022 Debra Saylor 87573 $0.80 CS007987
12/9/2022 Donna McAninch 87577 $0.80 CS007987
12/9/2022 Aimee Ergas 87595 $25.00 CS007987
12/9/2022 Hamid Alvayat 87608 $30.00 JE008813
12/9/2022 Raquel Baker 87635 $25.00 CS007987
12/9/2022 Susan Croskey 87642 $5.00 CS007987
12/9/2022 Wei Wang 87649 $10.00 CS007987
12/10/2022 Adam Sampson 87653 $5.00 CS007987
12/10/2022 Jessica Orrell 87659 $10.00 CS007987
12/10/2022 Edgar Vela 87677 $20.00 CS007987
12/11/2022 Moira Cronin 87631 $0.55 CS007987
61
Receipt Number Amount Journal Number
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - FY 2023 - First Quarter
Date of Donation Person Donating
12/11/2022 Joseph John 87648 $0.25 CS007987
12/11/2022 Sanjay Agarwal 87660 $0.80 CS007987
12/11/2022 Diane Allen 87664 $10.00 CS007987
12/12/2022 Meegan Horenstein 87662 $0.55 CS007987
12/12/2022 Meegan Horenstein 87663 $0.55 CS007987
12/12/2022 Joseph Glaub 87684 $4.00 JE008814
12/12/2022 Bryan Cohen 87686 $500.00 CS007987
12/12/2022 Amy Ellias 87690 $5.00 CS007987
12/12/2022 Cheryl Bachleda 87691 $ 10.00 CS007987
12/12/2022 Nelson Phan 87692 $0.80 CS007987
12/12/2022 Kara Dean 87701 $5.00 CS007987
12/12/2022 Brian DiMeo 87703 $10.80 CS007987
12/12/2022 Kim Wisniewski 87709 $260.00 JE008813
12/12/2022 jeff Emery 87716 $0.10 CS007987
12/12/2022 Samantha Bratkowski 87717 $0.55 CS007987
12/12/2022 Taylor Semma 87720 $0.25 CS007987
12/12/2022 Taylor Semma 87721 $0.25 CS007987
12/12/2022 Balaji Ramani 87723 $10.00 CS007987
12/12/2022 Bryan Boac 87725 $5.00 CS007987
12/13/2022 Danielle Dirksen 87733 $0.80 CS007987
12/13/2022 Donation Box 87740 $164.00 JE008868
12/13/2022 Dawn Lang 87742 $0.80 CS007987
12/13/2022 Jacqueline Kelly 87753 $5.80 CS007987
12/13/2022 Fallon Skelding 87764 $0.25 CS007987
12/13/2022 Lindsey Evans 87766 $5.00 CS007987
12/13/2022 Craig Marshalek 87768 $5.00 CS007987
12/13/2022 Meagan Thomas 87775 $50.00 CS007987
12/13/2022 Ginger Rodriguez 87964 $0.80 CS007987
12/14/2022 Linda Sterritt 87761 $210.00 JE008964
12/14/2022 Alexandra Peindl 87780 $30.00 CS007987
12/14/2022 Lucas Gaze 87796 $0.25 CS007987
12/14/2022 Ilze Bush 87802 $5.00 CS007987
12/14/2022 Sandy Ulman 87811 $15.00 JE008964
12/14/2022 Brandon McKenney 87820 $5.00 CS007987
12/14/2022 Takami Skarakis 87825 $0.55 CS007987
12/15/2022 Timothy Schreck 87843 $50.00 JE008963
12/15/2022 Paula Heisler 87844 $200.00 JE008963
12/15/2022 Emily Humpert 87848 $5.00 CS007987
12/15/2022 Karin Hopcroft 87849 $10.00 CS007987
12/15/2022 Angela Gehringer 87850 $0.80 CS007987
12/15/2022 Lakeisha Berry 87852 $25.00 JE008963
12/15/2022 Janelle Woodruff 87860 $5.00 CS007987
12/15/2022 Adriana Soares 87869 $10.00 CS007987
12/16/2022 Dan Lipman 87873 $5.00 CS008198
62
Receipt Number Amount Journal Number
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - FY 2023 - First Quarter
Date of Donation Person Donating
12/16/2022 Alice Bakara 87877 $5.00 CS008198
12/16/2022 Dba Epoch Events
Catering/Epoch
Hospitality
87885 $500.00 JE009008
12/16/2022 Tom Weng 87889 $0.80 CS008198
12/16/2022 Claudia Cerda 87913 $5.00 CS008198
12/16/2022 Heather Mangum 87915 $0.25 CS008198
12/16/2022 Caroline Kerfoot 87917 $10.00 CS008198
12/17/2022 Luis Riestr Pagola 87922 $0.55 CS008198
12/17/2022 Melanie Hogan 87938 $5.00 CS008198
12/17/2022 Amy Frankovich 87942 $0.80 CS008198
12/18/2022 Ashley Malewski 87905 $0.80 CS008198
12/18/2022 Ashley Malewski 87906 $0.80 CS008198
12/18/2022 Leo Vosger 87925 $50.00 CS008198
12/18/2022 Carol DeVore 87926 $36.00 CS008198
12/18/2022 Maryann Charara 87927 $8.80 CS008198
12/18/2022 Christine Werner 87931 $0.25 CS008198
12/18/2022 Karen Priskorn 87936 $20.00 CS008198
12/19/2022 Thomas Stuart 87944 $0.55 CS008198
12/19/2022 Linda Barrett 87954 $50.00 CS008198
12/19/2022 Douglas Brown 87955 $100.00 JE009137
12/19/2022 Stacia Skoog 87957 $100.00 JE009136
12/19/2022 Joyce Russell 87965 $32.00 JE009136
12/19/2022 Gabriel Idalgo 87967 $0.55 CS008198
12/19/2022 Susan Goldie 87974 $20.00 CS008198
12/19/2022 Sam Ciske 87977 $0.80 CS008198
12/19/2022 Alexandra DaCosta 87990 $0.25 CS008198
12/20/2022 Rachael Marnoch 87994 $5.00 CS008198
12/20/2022 Sarah Bradford 87997 $0.10 CS008198
12/20/2022 Holly Francis 88019 $0.55 CS008198
12/20/2022 Julianne Smith 88020 $10.00 CS008198
12/20/2022 Mary Perezgord 88022 $0.50 JE009136
12/20/2022 Sarah Ykema 88027 $10.00 CS008198
12/20/2022 Katelynn Herbert 88031 $5.00 CS008198
12/21/2022 Andrew Wingrove 88034 $100.00 CS008198
12/21/2022 Holly Giangrande 88040 $0.80 CS008198
12/21/2022 Andrew Brown 88043 $60.00 JE009136
12/21/2022 Ralph Reid 88055 $ 5.00 CS008198
12/21/2022 Eden Hartley 88056 $5.00 CS008198
12/21/2022 Ralph Reid 88057 $5.00 CS008198
12/21/2022 Irvin Products 88064 $70.00 JE009224
12/21/2022 Leeladhar Kommalapati 88123 $10.00 CS008198
12/21/2022 Thomas Shipton 88201 $0.80 CS008198
12/22/2022 Melissa Zimmerman 88097 $10.00 CS008345
63
Receipt Number Amount Journal Number
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - FY 2023 - First Quarter
Date of Donation Person Donating
12/22/2022 Shelley Rose 88098 $25.00 CS008345
12/22/2022 Dustin Howes 88099 $155.00 CS008345
12/22/2022 Jaimie Barrett 88133 $10.00 CS008345
12/22/2022 Kathryn Goodes 88137 $0.55 CS008345
12/22/2022 Allyce Wilmot 88166 $0.25 CS008345
12/22/2022 William Barrett 88168 $5.00 CS008345
12/22/2022 Rosemarie Watt 88170 $5.00 CS008345
12/22/2022 Kimberly White 88209 $5.00 CS008345
12/22/2022 Damodar Konda 88210 $5.00 CS008345
12/23/2022 Athan papatheodore 88100 $50.00 CS008345
12/23/2022 Clare Cox 88101 $25.00 CS008345
12/23/2022 Gwen Rosenthal 88102 $50.00 CS008345
12/23/2022 Lidia Junger 88140 $5.00 CS008345
12/23/2022 Stephanie Burchell 88144 $20.00 CS008345
12/23/2022 Maria Matijevic 88146 $0.80 CS008345
12/23/2022 Kathryn McMullen 88173 $10.00 CS008345
12/23/2022 Alex Boewe 88180 $0.25 CS008345
12/24/2022 cathy Klein 88150 $5.00 CS008345
12/24/2022 Kari Clawson 88213 $0.55 CS008345
12/24/2022 RUBEN Harutyunyan 88214 $0.55 CS008345
12/24/2022 Vinothan Selvaraj 88215 $10.00 CS008345
12/26/2022 Rebekah Harris 88103 $30.00 CS008345
12/26/2022 Brad Caruso 88153 $5.00 CS008345
12/26/2022 Jean Stieber-Anderson 88160 $5.00 CS008345
12/26/2022 Emily Barber 88161 $10.00 CS008345
12/26/2022 Patricia Watnick 88163 $10.00 CS008345
12/27/2022 Merrill Lynch 88105 $4000.00 JE009225
12/27/2022 Mark Mudd 88107 $5.00 JE009225
12/27/2022 Northville High School 88110 $309.76 JE009225
12/27/2022 Elissa Staeuble 88112 $25.00 JE009225
12/27/2022 Sarah Annas 88114 $200.00 JE009225
12/27/2022 K.A. Carie 88115 $60.00 JE009225
12/27/2022 Leslie Hoskyns 88116 $100.00 JE009225
12/27/2022 Douglas MacPherson 88117 $100.00 JE009225
12/27/2022 Marilyn Russell 88119 $10.00 JE009225
12/27/2022 Donation Box 88121 $2.70 JE009225
12/27/2022 Amy Kruppe 88184 $20.00 CS008345
12/27/2022 Amy Kruppe 88185 $20.00 CS008345
12/27/2022 Amy Kruppe 88186 $20.00 CS008345
12/27/2022 Brandon West 88221 $5.00 CS008345
12/27/2022 Giulio Ornella 88226 $0.25 CS008345
12/27/2022 Zachary Mladenoski 88231 $0.55 CS008345
12/27/2022 Kathleen Jenkins 88242 $4.25 CS008345
12/27/2022 Nicole Decook 88243 $10.00 CS008345
64
Receipt Number Amount Journal Number
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - FY 2023 - First Quarter
Date of Donation Person Donating
12/27/2022 Kevin Morgan 88244 $5.00 CS008345
12/27/2022 Joseph Wierenga 88246 $4.55 CS008345
12/28/2022 Arlene Limchoa 88251 $0.50 JE009344
12/28/2022 Patrick Harrington 88252 $100.00 CS008345
12/28/2022 Satoria Hardin 88254 $0.50 JE009344
12/28/2022 Lyewon Kim 88265 $0.80 CS008345
12/28/2022 Lyewon Kim 88266 $0.55 CS008345
12/28/2022 Gordon Rettie 88272 $5.00 CS008345
12/28/2022 Shane Smith 88275 $0.80 CS008345
12/28/2022 Jennifer Buccellato 88288 $0.25 CS008345
12/28/2022 Daniel Dutko 88289 $0.80 CS008345
12/28/2022 AnneMarie Malysz 88291 $0.55 CS008345
12/28/2022 Breton Blair 88292 $5.00 CS008345
12/29/2022 HarukaShiraishi 88301 $0.80 CS008545
12/29/2022 Astrid Hatch 88306 $10.00 CS008545
12/29/2022 John Langford 88313 $4.55 CS008545
12/29/2022 Jody Stanley 88314 $0.55 CS008545
12/29/2022 Dawn Marvin 88323 $30.00 JE09343
12/29/2022 Miranda Rothfuss 88351 $0.80 CS008545
12/29/2022 Shan Sundaram 88419 $5.00 CS008545
12/30/2022 Deena Rachar 88341 $20.00 CS008545
12/30/2022 Jason Belt 88359 $5.00 CS008545
12/30/2022 Stephanie Delboy 88360 $10.00 CS008545
12/30/2022 Kristen Greve 88363 $0.80 CS008545
12/30/2022 Denise Kasza 88364 $0.89 CS008545
12/30/2022 Anne Wilkinson 88366 $10.00 CS008545
12/30/2022 Linda Plotkin 88420 $50.00 CS008545
12/30/2022 Kathryn Kwasny 88423 $0.55 CS008545
12/30/2022 Doug Dascenzo 88424 $50.00 CS008545
12/30/2022 James Coleman 88488 $5.00 CS008545
12/31/2022 Roe Green 88342 $150.00 CS008545
12/31/2022 Barbara Compton 88343 $50.00 CS008545
12/31/2022 Xiaobao Geng 88433 $0.55 CS008545
12/31/2022 Lydia Long 88437 $1.55 CS008545
12/31/2022 Lisa Grassi 88498 $0.89 CS008545
$13,312.39
$20,016.32Q1 FY2023 Total
December 2022 Total
65
10/24/2022 L. Pangeri Pants $45.00
10/25/2022 OCCVF Walmart Gift Card for Resident $200.00
11/1/2022 St. Perpetua Pillowcases $300.00
11/1/2022 N. Hawn Halloween Candy $15.00
11/14/2022 C. Rasegan Clothing $10.00
11/16/2022 G. Smith Board and Card Games $50.00
11/16/2022 Sweet Dreams for Kids 15 Pillowcases $225.00
11/16/2022 Caruso Caruso Jeans $2,890.00
11/17/2022 St. Mary of Hills Check $150.00
11/25/2022 OCCVF Jeans for MP Residents $706.00
11/30/2022 Welcome Baptist Church Toiletries $300.00
12/3/2022 Chirst The Redeemer Pajamas, Toiletires, Craft Kits $2,000.00
12/5/2022 A little Quilt Shop Quilts, Tote bags $200.00
12/5/2022 M. Yee Games and Craft Supplies $150.00
12/7/2022 Sweet Dreams for Kids 15 Pillowcases $225.00
12/7/2022 Bloomfield Hills CC Check 20 Christmas Gifts $350.00
12/7/2022 Amerisure Hoodies, Cards, Books, Gift Bags $2,000.00
12/7/2022 St. Perpetua Pillowcases $375.00
12/9/2022 Our Lady of Refuge Church Pajamas, Socks, Gift Cards $500.00
12/14/2022 P. Lahar Individual Packets of Cookies $25.00
12/15/2022 Vibe Credit Union Clothes, Toiletries, Cards, Books $500.00
12/16/2022 St. Perpetua Games, Puzzles, Toiletries, Clothing $800.00
12/202022 OCCVF Ski School Gift Card for ReEntry $200.00
12/20/2022 L. Tobias & J. Przeslawski Playing Cards $100.00
12/20/2022 Lakes Vicarities Games, Blankets, Pizza for MP $600.00
12/20/2022 Kick 4 Kids Nikes & Vans for MP residents $1,000.00
12/20/2022 C & J Cortez Toiletries $350.00
12/20/2022 Toys for Tots/Sharks Club Toys for MP $750.00
12/20/2022 OC Sheriff's Office Toys and Card Games for MP $200.00
12/20/2022 A. Woodfolk Candy & Toiletries for MP $300.00
12/20/2022 OC Sheriff's Office Large Gift Bags For Each MP Resident $2,500.00
12/20/2022 St. Patrick Checks $310.00
Total Q1 18,326.00$
Department of Public Services Oakland County Children's Village
Donation Tracking : Donation Period October 2022 ‐ December 2022
Date: Donor: Cash/Check: Items: Estimated Value:
66
Oakland County, Michigan
ARP CARRYFORWARDS FROM FY 2022
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 2023
Amendment
FY 2024
Amendment
FY 2025
Amendment
R American
Rescue Plan
Non-Department FND21285 CCN9010101 RC610313 PRG133095 610000 Federal Operating Grants $88,709,615.00 $-$-
Total Revenue $88,709,615.00 $-$-
E American
Rescue Plan
Non Departmental
Operations
FND21285 CCN9010101 SC731885 PRG133095 GRN-1003457 730000 Supportive Services $5,493,600.00 $-$-
E American
Rescue Plan
Neighborhood & Housing
Development
FND21285 CCN1060701 SC731598 PRG133095 GRN-1003459 730000 Regranting Program 2,000,000.00 --
E American
Rescue Plan
Economic Development
Administration
FND21285 CCN1090101 SC731598 PRG133095 GRN-1003461 730000 Regranting Program 17,170,950.00 --
E American
Rescue Plan
Neighborhood & Housing
Development
FND21285 CCN1060701 SC731885 PRG133095 GRN-1003512 730000 Supportive Services 315,000.00 --
e American
Rescue Plan
Non Departmental
Operations
FND21285 CCN9010101 SC731598 PRG133095 GRN-1003568 730000 Regranting Program 190,700.00
E American
Rescue Plan
Non Departmental
Operations
FND21285 CCN9010101 SC731598 PRG133095 GRN-1003596 730000 Regranting Program 3,900,000.00 --
E American
Rescue Plan
Health Administration FND21285 CCN1060201 SC731598 PRG133095 GRN-1003599 730000 Regranting Program 249,050.00
E American
Rescue Plan
Health Administration FND21285 CCN1060201 SC731598 PRG133095 GRN-1003607 730000 Regranting Program 1,001,615.00
E American
Rescue Plan
Health Administration FND21285 CCN1060201 SC731598 PRG133095 GRN-1003607 730000 Regranting Program 448,400.00
E American
Rescue Plan
Non Departmental
Operations
FND21285 CCN9010101 SC730373 PRG133095 GRN-1003617 730000 Contracted Services 575,400.00 --
E American
Rescue Plan
Non Departmental
Operations
FND21285 CCN9010101 SC773630 PRG133095 GRN-1003617 770000 IT Development 1,119,900.00
E American
Rescue Plan
Medical Examiner FND21285 CCN1070601 SC760159 PRG133095 GRN-1003617 760000 Medical Equipment 600,000.00 --
E American
Rescue Plan
Neighborhood & Housing
Development
FND21285 CCN1060701 SC731885 PRG133095 GRN-1003663 730000 Supportive Services 5,000,000.00 --
E American
Rescue Plan
Neighborhood & Housing
Development
FND21285 CCN1060701 SC731885 PRG133095 GRN-1003687 730000 Supportive Services 5,000,000.00 --
E American
Rescue Plan
Neighborhood & Housing
Development
FND21285 CCN1060701 SC731885 PRG133095 GRN-1003688 730000 Supportive Services 2,000,000.00 --
E American
Rescue Plan
County Executive
Administration
FND21285 CCN1010101 SC731458 PRG133095 GRN-1003696 730000 Professional Servic 1,000,000.00 --
E American
Rescue Plan
Health Administration FND21285 CCN1060201 SC730373 PRG133095 GRN-1003867 730000 Contracted Services 1,700,000.00 --
E American
Rescue Plan
Health Administration FND21285 CCN1060201 SC730373 PRG133095 GRN-1003868 730000 Contracted Services 250,000.00 --
E American
Rescue Plan
Neighborhood & Housing
Development
FND21285 CCN1060701 SC730373 PRG133095 GRN-1003869 730000 Contracted Services 300,000.00 --
E American
Rescue Plan
Health Administration FND21285 CCN1060201 SC730373 PRG133095 GRN-1003870 730000 Contracted Services 2,500,000.00 --
E American
Rescue Plan
Health Administration FND21285 CCN1060201 SC730373 PRG133095 GRN-1003871 730000 Contracted Services 1,000,000.00 --
E American
Rescue Plan
Planning and Local
Business Develop
FND21285 CCN1090201 SC730373 PRG133095 GRN-1003873 730000 Contracted Services 450,000.00 --
E American
Rescue Plan
Board of Commissioners
Administrati
FND21285 CCN5010101 SC731598 PRG133095 GRN-1003874 730000 Regranting Program 10,150,000.00 --
E American
Rescue Plan
WRC Administration FND21285 CCN6010101 SC771639 PRG133095 GRN-1003875 770000 Drain Equipment 240,000.00 --
E American
Rescue Plan
Health Administration FND21285 CCN1060201 SC731598 PRG133095 GRN-1003881 730000 Regranting Program 5,000,000.00 --
E American
Rescue Plan
Planning and Local
Business Develop
FND21285 CCN1090201 SC731598 PRG133095 GRN-1004015 730000 Regranting Program 15,000,000.00 --
E American
Rescue Plan
Board of Commissioners
Administrati
FND21285 CCN5010101 SC731465 PRG133095 GRN-1004016 730000 Program 5,555,000.00 --
E American
Rescue Plan
Board of Commissioners
Administrati
FND21285 CCN5010101 SC731500 PRG133095 GRN-1004017 730000 Public Information 500,000.00 --
Total Expenditure $88,709,615.00 $-$-
WHEREAS a FY 2023 budget amendment totaling $88,709,615 is recommended for the American Rescue Plan Fund (21285) to carryforward the remaining balances from the FY 2022 appropriations; and