HomeMy WebLinkAboutReports - 2023.06.15 - 38255
AGENDA ITEM: Fiscal Year 2023 Second Quarter Financial Forecast and Budget Amendments
DEPARTMENT: Fiscal Services
MEETING: Board of Commissioners
DATE: Thursday, June 15, 2023 7:00 PM - Click to View Agenda
ITEM SUMMARY SHEET
COMMITTEE REPORT TO BOARD
Resolution #2023-3045 _ 23-104
Motion to adopt the attached suggested resolution.
ITEM CATEGORY SPONSORED BY
Quarterly Report Gwen Markham
INTRODUCTION AND BACKGROUND
Attached please find the Fiscal Year 2023 Second 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 second quarter of the fiscal year (ending March 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: Yes
Committee members can contact Michael Andrews, Policy and Fiscal Analysis Supervisor at
248.425.5572 or andrewsmb@oakgov.com, or the department contact persons listed for additional
information.
CONTACT
Kyle Jen, Director Management & Budget-APP
ITEM REVIEW TRACKING
Gwen Markham, Board of Commissioners Created/Initiated - 6/15/2023
David Woodward, Board of Commissioners Approved - 6/15/2023
Hilarie Chambers, Executive's Office Approved - 6/20/2023
Lisa Brown, Clerk/Register of Deeds New -
AGENDA DEADLINE: 06/25/2023 7:00 PM
ATTACHMENTS
1. Fiscal Year 2023 2nd Quarter Forecast
COMMITTEE TRACKING
2023-06-15 Finance - Recommend to Board
2023-06-15 Full Board - Adopt
Motioned by: Commissioner Robert Hoffman
Seconded by: Commissioner Angela Powell
Yes: David Woodward, Michael Spisz, Michael Gingell, Penny Luebs, Karen Joliat, Kristen
Nelson, Christine Long, Robert Hoffman, Philip Weipert, Gwen Markham, Angela Powell, Marcia
Gershenson, Janet Jackson, William Miller III, Yolanda Smith Charles, Charles Cavell, Brendan
Johnson (17)
No: None (0)
Abstain: None (0)
Absent: Ajay Raman, Gary McGillivray (2)
Passed
June 15, 2023
RESOLUTION #2023-3045 _ 23-104
Sponsored By: Gwen Markham
Fiscal Services - Fiscal Year 2023 Second Quarter Financial Forecast and Budget
Amendments
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 Second Quarter Financial Forecast Report has identified
several variances and budget amendments are recommended as detailed in the attached Schedule A
and B budget amendment; and
WHEREAS per the General Appropriations Act and Miscellaneous Resolution #93156, a review of
the carry forward appropriation has been conducted to determine if the appropriation shall continue
for the remainder of the fiscal year; and
WHEREAS the departments have expended much of their carry forward requests and the remaining
balance is expected to be utilized by the end of FY 2023; and
WHEREAS Department of Public Services, Animal Shelter and Pet Adoption Center received donatio
ns for the period of January 2023 through March 2023 totaling $32,342.99; and
WHEREAS the Sheriff’s Office received donations for the period of January 2023 through March
2023 totaling $18,815.27; and
WHEREAS Children’s Village Division received donations for the period of January 2023 through
March 2023 totaling $8,962 of which $100 were cash donations; and
WHEREAS the Oakland County Department Health and Human Services has attempted to collect
funds from loan recipients for the Community Development Block Grant totaling $28,575 and
recommends the amount to be written off in uncollectible loans; and
WHEREAS Oakland County Department of Health and Human has recommended to write-off
$32,375.67 as the amount is uncollectable for the period of October 2022 through February 2023;
and
WHEREAS based on the FY 2022 Annual Comprehensive Financial Report, the General Fund ended
FY 2022 with a fund balance of $220.8 million. The FY 2022 General Fund/General Purpose Fund
Balance is updated to include market value adjustments on investments and to recognize the
expenditures for the Rafaeli claims in FY 2022 as determined by the County's independent auditors.
NOW THEREFORE BE IT RESOLVED that the Board
of Commissioners accepts the Fiscal Year 2023 Second Quarter Financial Report.
BE IT FURTHER RESOLVED that the donations be recognized in the Animal Shelter and Pet
Adoption Center, Sheriff’s Office and Children’s Village Division.
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 General Fund fund balance assignments assignments are amended
as described in the attached report.
BE IT FURTHER RESOLVED that the FY 2023 – FY 2025 Budgets are amended pursuant to
Schedules A and B.
Chair, the following Commissioners are sponsoring the foregoing Resolution: Gwen Markham.
Date: June 15, 2023
David Woodward, Commissioner
Date: June 20, 2023
Hilarie Chambers, Deputy County Executive II
Date:
Lisa Brown, County Clerk / Register of Deeds
COMMITTEE TRACKING
2023-06-15 Finance - Recommend to Board
2023-06-15 Full Board - Adopt
Motioned by Commissioner Robert Hoffman seconded by Commissioner Angela Powell to adopt the
attached Quarterly Report: Fiscal Year 2023 Second Quarter Financial Forecast and Budget
Amendments.
Yes: David Woodward, Michael Spisz, Michael Gingell, Penny Luebs, Karen Joliat, Kristen Nelson,
Christine Long, Robert Hoffman, Philip Weipert, Gwen Markham, Angela Powell, Marcia
Gershenson, Janet Jackson, William Miller III, Yolanda Smith Charles, Charles Cavell, Brendan
Johnson (17)
No: None (0)
Abstain: None (0)
Absent: Ajay Raman, Gary McGillivray (2)
Passed
ATTACHMENTS
1. Fiscal Year 2023 2nd Quarter Forecast
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Lisa Brown, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true
and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on June
15, 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, June 15, 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 Second Quarter Forecast
DATE: June 12, 2023
Attached please find the Fiscal Year 2023 Second 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 second quarter of the fiscal year (ending March 31). The quarterly
forecasting process seeks to ensure that no individual department overspends its appropriated budget at
year end and provides countywide information on forecasted revenues and expenditure for use by the Board
of Commissioners, Department of Management and Budget, and the public.
Revenue Forecast
Total General Fund revenues are forecasted to be $4.2 million lower than the revenue amounts included in
the Amended FY 2023-2025 County Budget. This is the result of lower forecasted Charges for Services
totaling $5.5 million across several departments. The majority of the lower forecasted charges are
comprised of $3.4 million for the District Court due to lower fees, fines, and costs. The court indicates this is
the result of lower numbers of cases where those financial charges are assessed, in part due to state policy
changes.
Expenditure Forecast
Total General Fund Expenditures are forecasted to be $4.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 $22.4 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.2 million. This is the result of zeroing out the $10
million personnel turnover factor and $8 million operating favorability factor included in the 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.
2100 Pontiac Lake Road | County Executive Building 41W | Waterford, MI 48328 | Fax (248) 452-9172 | OakGov.com
Two departments are forecasted to exceed appropriated levels at the department total level:
• The Sheriff’s Office is forecasted to exceed its budget by $749,000. This is the result of Overtime
and associated Fringe Benefits due to turnover, vacant positions, hospital watch, officers in the
academy, and officers in training. We will continue to monitor these trends with the Sheriff’s Office
and recommend budget adjustments as appropriate.
• The Emergency Management and Homeland Security Department is forecasted to exceed its budget
by $207,000. This is the result of a timing issue with reimbursement from FEMA for County
expenditures.
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 $65.9 million in Planned Use of Fund Balance. Major contributors to
this amount are as follows:
• 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. (Note that, based on guidance from the
County’s independent auditors, these expenditures have now been booked back to FY 2022, with
the same ultimate impact on the FY 2023 ending fund balance.)
• 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.
In total, this forecast expects Planned Use of Fund Balance to be in line with the level assumed in the
amended budget. This would result in an FY 2023 ending General Fund balance of $194.7 million, which
equates to 38.8% 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 third quarter forecast and the FY 2023 year-end report.
Please call with any questions you may have prior to the Finance Committee meeting.
R/E Fund Name Division Name
Fund #
(FND)
Cost Center
(CCN) #
Account #
(RC/SC)
Program #
(PRG)
Grant ID
(GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2023
Amendment
FY 2024
Amendment
FY 2025
Amendment
R General Fund Animal Control FND1010
0
CCN1070801 RC630074 PRG114115 GRN-1004081 630000 Animal Serlization Fees 470.00$ -$ -$
R General Fund Animal Control FND1010
0
CCN9010101 RC665882 PRG196030 GRN-1004081 665882 Planned Use of Balance (470.00) - -
Total Revenue -$ -$ -$
E General Fund Non-Department Transfers FND1010
0
CCN9090101 SC731822 PRG196030 730000 Special Projects (50,000.00)$ -$ -$
E General Fund Board of Commissioners FND1010
0
CCN5010101 SC731822 PRG180010 730000 Special Projects 50,000.00 - -
Total Expenses -$ -$ -$
E General Fund Non-Department Transfers FND10100 CCN9090101 SC731822 PRG196030 730000 Special Projects (100,000.00)$ -$ -$
E General Fund Board of Commissioners FND10100 CCN5010101 SC731822 PRG180010 730000 Special Projects 100,000.00 - -
Total Expenses -$ -$ -$
E Community Corrections
Comprehensive Grant
Community Corrections FND1100
3
CCN1070401 SC732018 PRG113000 GRN1003947 730000 Travel, Conference 1,898.00$ -$ -$
E Community Corrections
Comprehensive Grant
Community Corrections FND1100
3
CCN1070401 SC731941 PRG113000 GRN1003947 730000 Training (1,898.00) - -
Total Expenses -$ -$ -$
R General Fund Inv. & Forensic Svcs FND1010 CCN4030901 RC695500 PRG116240 BFA21340 695500 Transfers In - Law Enforcement Enhance Lab Fees 24,607.00$ -$ -$
R General Fund Emergency Comm Ops FND1010 CCN4030701 RC695500 PRG116230 BFA21396 695500 Transfers In - Sheriff Dispatch Training 17,019.00 - -
R General Fund Corrective Services FND1010 CCN4030301 RC695500 PRG112620 BFA21397 695500 Transfers In - Sheriff Booking Fee Training 12,447.00 - -
Total Revenue 54,073.00$ -$ -$
E General Fund Inv. & Forensic Svcs 0 CCN4030901 SC750203 PRG116240 750000 Forensic Lab Enhancement 24,607.00
E General Fund Emergency Comm Ops 0 CCN4030701 SC731304 PRG116230 730000 Officers Training (Dispatch)17,019.00 - -
E General Fund Corrective Services 0 CCN4030301 SC731304 PRG112620 730000 Officers Training (Corrections)12,447.00 - -
Total Expenses 54,073.00 - -
R Law Enforcement
Enhance Lab Fees
Inv. & Forensic Svcs FND21340 CCN4030901 RC665882 PRG116240 665882 Planned Use of Balance 24,607.00$ -$ -$
Total Revenue 78,680.00$ -$ -$
E Law Enforcement
Enhance Lab Fees
Inv. & Forensic Svcs FND21340 CCN4030901 SC788001 PRG116240 BFA10100 788001 Transfers Out - General Fund 24,607.00$ -$ -$
Total Expenditures 24,607.00$ -$ -$
R Dispatch Training Emergency Comm Ops FND21396 CCN4030701 RC665882 PRG112630 665882 Planned Use of Balance 17,019.00$ -$ -$
Total Revenue 17,019.00$ -$ -$
E Dispatch Training Emergency Comm Ops FND21396 CCN4030701 SC788001 PRG112630 BFA10100 788001 Transfers Out - General Fund 17,019.00$ -$ -$
Total Expenditures 17,019.00$ -$ -$
Oakland County, Michigan
Schedule "A" DETAIL
WHEREAS a FY 2023 budget amendment of $50,000 is recommended for the appropriation of funds from Non-Department Transfer's Special Projects line item to the Board of Commissioners General Fund/General Purpose budget for the sponsorhsip of the Fair Housing Center's Tenant's Rights
and Responsibilities Coucil (MR #2022-2334); and
Animal Control
WHEREAS a FY 2023 budget amendment is recommended for the Animal Control Division to accept reimbursement funding of $470 from the October 1st - 8th Bissel Pet Foundation's Empty the Shelter 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
Board of Commisioners
WHEREAS a FY 2023 budget amendment of $100,000 is recommended for the appropriation of funds from Non-Department Transfer's Special Projects line item to the Board of Commissioners General Fund/General Purpose budget for the Elimination of Financial Burden of Reduced Price Meal
for Students in Oakland County l (MR #2023-2603); and
Sheriff's Office
Public Services - Community Corrections
WHEREAS a FY 2023 budget amendment of $1,878 is recommended for Community Corrections to recognize Amendment #1 to the FY 2023 Michigan Department of Corrections Comprehensive Corrections Plan reallocating the budget between line items causing no impact to the total amount of
funding. Amendment #1 is within 15% of Original Agreement authorized by M.R. #18366; and
3
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 "A" DETAIL
R Sheriff Booking Fee
Training
Corrective Services FND21397 CCN4030301 RC665882 PRG112620 665882 Planned Use of Balance 12,447.00$ -$ -$
Total Revenue 12,447.00$ -$ -$
E Sheriff Booking Fee
Training
Corrective Services FND21397 CCN4030301 SC788001 PRG112620 BFA10100 788001 Transfers Out - General Fund 12,447.00$ -$ -$
Total Expenditures 12,447.00$ -$ -$
E General Fund Patrol Services FND10100 CCN4030601 SC750210 PRG116200 750000 Gasoline (14,000.00)$ -$ -$
E General Fund Patrol Services FND10100 CCN4030601 SC731304 PRG116200 730000 Officers Training 7,000.00 - -
E General Fund Patrol Services FND10100 CCN4030601 SC750084 PRG116200 750000 Diving Supplies 7,000.00 - -
Total Expenses -$ -$ -$
R General Fund Investigative & Forensic Svcs FND10101 CCN4030901 RC610313 PRG110060 GRN-1003898 610000 Federal Operating Grant (19,372.00)$ -$ -$
R General Fund Patrol Services FND10101 CCN4030601 RC610313 PRG110060 GRN-1003898 610000 Federal Operating Grant 19,372.00
Total Revenue -$ -$ -$
E General Fund Investigative & Forensic Svcs FND10101 CCN4030901 SC712020 PRG110060 GRN-1003898 702000 Overtime (19,372.00)$ -$ -$
E General Fund Patrol Services FND10101 CCN4030601 SC712020 PRG110060 GRN-1003898 702000 Overtime 19,372.00 - -
Total Expenses -$ -$ -$
E General Fund Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 730000 General Fund Contingency (132,600.00)$ -$ -$
E General Fund Non-Departmental FND10100 CCN9090101 SC788001 PRG196030 BFA53600 788001 Transfer Out - Radio 132,600.00 - -
Total Expenses -$
R Radio Communications IT Public Safety and Radio Communications FND53600 CCN1080310 RC695500 PRG115150 BFA10100 695500 Transfer In - Gen Fund 132,600.00$ -$ -$
Total Revenue 132,600.00$ -$ -$
E Radio Communications IT Public Safety and Radio Communications FND53600 CCN1080310 SC796500 PRG115150 796500 Budgeted Equity Adj 132,600.00$ -$ -$
Total Expenses 132,600.00$ -$ -$
R General Fund Patrol Services FND10100 CCN4030601 RC626619 PRG116200 625000 Marine Safety 75,250.00$ -$ -$
R General Fund Grant Patrol Services FND10101 CCN4030601 RC626619 PRG116200 GRN-1002214 625000 Marine Safety (83,550.00) - -
R General Fund Grant Patrol Services FND10101 CCN4030601 RC626619 PRG116200 GRN-1003430 625000 Marine Safety (13,500.00) - -
R General Fund Patrol Services FND10100 CCN4030601 RC626619 PRG116200 625000 Marine Safety (153,250.00) - -
Total Revenue (175,050.00)$ -$ -$
E General Fund Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 730000 Contingency $ (175,050.00) $- $-
Total Expenditures (175,050.00)$ -$ -$
E General Fund Veteran Services FND10100 CCN1090401 SC731794 PRG132090 730000 Soldier Burial (10,000.00)$ -$ -$
E General Fund Veteran Services FND10100 CCN1090401 SC750049 PRG132050 750000 Computer Supplies 10,000.00 - -
Total Expenses -$ -$ -$
WHEREAS a Sheriff's Office budget amendment of $14,000 is recommended to more accurately reflect actual spending; and
WHEREAS the Sheriff's Office receipt of forfeiture/enhancement funds are recorded in separate restricted funds that require a transfer to the General Fund for use of the monies. Transfers In from the various restricted funds in the amount of $54,073 is being recognized for eligible forensic lab
and training costs for dispatchers and corrections officers; and
WHEREAS a Sheriff's Office budget amendment of $175,050 is recommended to clear out old grants; and
Economic Development
WHEREAS a FY 2023 budget amendment of $10,000 is recommended for the Veteran's Services to reallocate budgets between expenditure line items for the purchase of Software Solutions. The amendment reduces the budget from Soldiers Burial and reallocates it to Computer Supplies; and
WHEREAS a Sheriff's Office budget amendment of $19,372 is recommended to move the Alcohol Tobacco Firearms and Explosives Grant budget to the correct Cost Center; and
WHEREAS a Radio Fund budget amendment of $132,600 is recommended to transfer Contingency to Radio Fund for the increased cost of new radios; and
4
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 "A" DETAIL
E General Fund Emergency Management FND10100 CCN1110101 SC760174 PRG115090 760000 Law Enforcement Equipment (172,000.00)$ -$ -$
E General Fund Emergency Management FND10100 CCN1110101 SC760182 PRG115090 760000 Tornado Siren Equipment 172,000.00 - -
Total Expenses -$ -$ -$
E General Fund Health FND10100 CCN1060220 SC730585 PRG133150 730000 Employee License-Certification 10,000.00$ -$ -$
E General Fund Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 730000 Contingency (10,000.00) - -
Total Expenses -$ -$ -$
E General Fund Health FND10100 CCN1060201 SC750150 PRG133150 750000 Expendable Equipment (35,000.00)$ -$ -$
E General Fund Health FND10100 CCN1060237 SC750150 PRG133310 750000 Expendable Equipment (8,233.00)
E General Fund Health FND10100 CCN1060201 SC760160 PRG133150 760000 Furniture and Fixtures 43,233.00 - -
Total Expenses -$ -$ -$
E General Fund Health FND10100 CCN1060240 SC730585 PRG133390 730000 Employee License-Certification 2,120.00$ -$ -$
E General Fund Health FND10100 CCN1060234 SC730585 PRG133990 730000 Expendable Equipment (2,120.00) - -
E General Fund Health FND10100 CCN1060234 SC750301 PRG133300 750000 Medical Supplies (850.00) - -
E General Fund Health FND10100 CCN1060234 SC750301 PRG133310 750000 Medical Supplies (850.00) - -
E General Fund Health FND10100 CCN1060237 SC750301 PRG133300 750000 Medical Supplies 850.00 - -
E General Fund Health FND10100 CCN1060237 SC750301 PRG133310 750000 Medical Supplies 850.00 - -
Total Expenses - - -
E General Fund Health Administration FND10100 CCN1060201 SC760160 PRG133150 760000 Furniture and Fixtures (23,044.00)$ -$ -$
E General Fund Health Administration FND10100 CCN1060201 SC788001 PRG133150 PRJ-17311 BFA40400 788001 Transfers Out - Project Work Order Fund 23,044.00 - -
Total Expenditures -$ -$ -$
R Project Work Order Facilities Management FND40400 CCN1040101 RC695500 PRG148020 PRJ-17311 BFA10100 695500 Transfers In - General Fund 23,044.00$ -$ -$
Total Revenue 23,044.00$ -$ -$
E Project Work Order Facilities Management FND40400 CCN1040101 SC796500 PRG148020 796500 Budget Equity Adjustment 23,044.00$ -$ -$
Total Expenditures 23,044.00$ -$ -$
E General Fund - Grants Health FND10101 CCN1060201 SC731458 PRG133150 GRN-1003969 730000 Professional Services 1,045,070$ -$ -$
Total Expenditures 1,045,070$ -$ -$
R General Fund - Grants Health FND10101 CCN1060201 RC615675 PRG133150 GRN-1003969 615000 Health State Subsidy 1,045,070$ -$ -$
Total Revenue 1,045,070$ -$ -$
E Parks and Recreation Planning FND50800 CCN5060104 SC730373 PRG160000 730000 Contracted Services (50,000.00)$ -$ -$
E Parks and Recreation Planning FND50800 CCN5060104 SC731213 PRG160000 730000 Membership Dues (280.00) - -
E Parks and Recreation Planning FND50800 CCN5060104 SC731339 PRG160000 730000 Periodicals Books Publ Sub (250.00) - -
E Parks and Recreation Planning FND50800 CCN5060104 SC731346 PRG160000 730000 Personal Mileage (500.00) - -
E Parks and Recreation Planning FND50800 CCN5060104 SC731388 PRG160000 730000 Printing (2,000.00) - -
E Parks and Recreation Planning FND50800 CCN5060104 SC731500 PRG160000 730000 Public Information (2,000.00) - -
E Parks and Recreation Planning FND50800 CCN5060104 SC731941 PRG160000 730000 Training (500.00) - -
E Parks and Recreation Planning FND50800 CCN5060104 SC732018 PRG160000 730000 Travel and Conference (2,500.00) - -
Parks and Recreation
Emergency Management & Homeland Security
WHEREAS a FY 2023 budget amendment of $23,044 is recommended for the Health Dvision transferring funds to the Project Work Order fund for the OLHSA renovations; and
WHEREAS a FY 2023 budget amendment of $172,000 is recommended for Emergency Management and Homeland Security reallocating the budget from Law Enforcement Euipment to Tornado Siren equipment for the repair of tornado sirens; and
Health & Human Services
WHEREAS a FY 2023 - FY2025 budget amendment of $10,000 is recommended to increase Health & Human Services, Health Division budget for Environmental Health Sanitarians' registration for license renewal per UAW contract; and
WHEREAS a FY 2023 budget amendment totaling $43,233 is recommended for the Health Division reallocating the line item expenditure accounts between cost centers to accomodate the purchase of replacement furniture for the Health Division Administration; and
WHEREAS a FY 2023 budget amendment totaling $3,820 is recommended for the Health Division reallocating the budgets between cost centers to reflect actual activity; and
WHEREAS a FY 2023 budget amendment totaling $1,045,070 is recommended for Health and Human Services to recognize the receipt of funding for the FY 2023 LCSA Health Distribution (GRN-1003969); and
5
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 "A" DETAIL
E Parks and Recreation Planning FND50800 CCN5060104 SC732165 PRG160000 730000 Workshops and Meeting (1,500.00) - -
E Parks and Recreation Planning FND50800 CCN5060104 SC750399 PRG160000 750000 Office Supplies (500.00) - -
E Parks and Recreation Planning FND50800 CCN5060104 SC750504 PRG160000 750000 Small Tools (5,000.00) - -
E Parks and Recreation Planning FND50800 CCN5060104 SC750581 PRG160000 750000 Uniforms (200.00) - -
E Parks and Recreation Planning FND50800 CCN5060104 SC774636 PRG160000 770000 Info Tech Operations (16,700.00) - -
E Parks and Recreation Planning FND50800 CCN5060104 SC774677 PRG160000 770000 Insurance Fund (2,000.00) - -
E Parks and Recreation Planning FND50800 CCN5060104 SC778675 PRG160000 770000 Telephone Communications (3,000.00) - -
E Parks and Recreation Adminstrative Services FND50800 CCN5060101 SC730373 PRG160000 730000 Contracted Services 50,000.00 - -
E Parks and Recreation Adminstrative Services FND50800 CCN5060101 SC731213 PRG160000 730000 Membership Dues 280.00 - -
E Parks and Recreation Adminstrative Services FND50800 CCN5060101 SC731339 PRG160000 730000 Periodicals Books Publ Sub 250.00 - -
E Parks and Recreation Adminstrative Services FND50800 CCN5060101 SC731346 PRG160000 730000 Personal Mileage 500.00 - -
E Parks and Recreation Adminstrative Services FND50800 CCN5060101 SC731388 PRG160000 730000 Printing 2,000.00 - -
E Parks and Recreation Adminstrative Services FND50800 CCN5060101 SC731500 PRG160000 730000 Public Information 2,000.00 - -
E Parks and Recreation Adminstrative Services FND50800 CCN5060101 SC731941 PRG160000 730000 Training 500.00 - -
E Parks and Recreation Adminstrative Services FND50800 CCN5060101 SC732018 PRG160000 730000 Travel and Conference 2,500.00 - -
E Parks and Recreation Adminstrative Services FND50800 CCN5060101 SC732165 PRG160000 730000 Workshops and Meeting 1,500.00 - -
E Parks and Recreation Adminstrative Services FND50800 CCN5060101 SC750399 PRG160000 750000 Office Supplies 500.00 - -
E Parks and Recreation Adminstrative Services FND50800 CCN5060101 SC750504 PRG160000 750000 Small Tools 5,000.00 - -
E Parks and Recreation Adminstrative Services FND50800 CCN5060101 SC750581 PRG160000 750000 Uniforms 200.00 - -
E Parks and Recreation Adminstrative Services FND50800 CCN5060101 SC774636 PRG160000 770000 Info Tech Operations 16,700.00 - -
E Parks and Recreation Adminstrative Services FND50800 CCN5060101 SC774677 PRG160000 770000 Insurance Fund 2,000.00 - -
E Parks and Recreation Adminstrative Services FND50800 CCN5060101 SC778675 PRG160000 770000 Telephone Communications 3,000.00 - -
Total Expenditures -$ -$ -$
E Parks and Recreation Marketing & Communications FND50800 CCN5060120 SC702010 PRG160000 730000 Salaries (325,758.00)$ -$ -$
E Parks and Recreation Marketing & Communications FND50800 CCN5060120 SC722740 PRG160000 730000 Fringe Benefits (156,328.00) - -
E Parks and Recreation Marketing & Communications FND50800 CCN5060120 SC730072 PRG160000 730000 Advertising (243,000.00) - -
E Parks and Recreation Marketing & Communications FND50800 CCN5060120 SC730373 PRG160000 730000 Contracted Services (133,000.00) - -
E Parks and Recreation Marketing & Communications FND50800 CCN5060120 SC731213 PRG160000 730000 Membership Dues (100.00) - -
E Parks and Recreation Marketing & Communications FND50800 CCN5060120 SC731339 PRG160000 730000 Periodicals Books Publ Sub (100.00) - -
E Parks and Recreation Marketing & Communications FND50800 CCN5060120 SC731346 PRG160000 730000 Personal Mileage (1,000.00) - -
E Parks and Recreation Marketing & Communications FND50800 CCN5060120 SC731388 PRG160000 730000 Printing (15,000.00) - -
E Parks and Recreation Marketing & Communications FND50800 CCN5060120 SC731500 PRG160000 730000 Public Information (56,000.00) - -
E Parks and Recreation Marketing & Communications FND50800 CCN5060120 SC731836 PRG160000 750000 Sponsorship (8,700.00) - -
E Parks and Recreation Marketing & Communications FND50800 CCN5060120 SC732018 PRG160000 750000 Travel and Conference (1,000.00) - -
E Parks and Recreation Marketing & Communications FND50800 CCN5060120 SC750399 PRG160000 750000 Office Supplies (500.00) - -
E Parks and Recreation Marketing & Communications FND50800 CCN5060120 SC750581 PRG160000 770000 Uniforms (200.00) - -
E Parks and Recreation Marketing & Communications FND50800 CCN5060120 SC774636 PRG160000 770000 Info Tech Operations (27,000.00) - -
E Parks and Recreation Marketing & Communications FND50800 CCN5060120 SC774677 PRG160000 770000 Insurance Fund (2,000.00) - -
E Parks and Recreation Marketing & Communications FND50800 CCN5060120 SC778675 PRG160000 730000 Telephone Communications (3,700.00) - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC702010 PRG160000 730000 Salaries 325,758.00 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC722740 PRG160000 730000 Fringe Benefits 156,328.00 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC730072 PRG160000 730000 Advertising 243,000.00 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC730373 PRG160000 730000 Contracted Services 133,000.00 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC731213 PRG160000 730000 Membership Dues 100.00 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC731339 PRG160000 730000 Periodicals Books Publ Sub 100.00 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC731346 PRG160000 730000 Personal Mileage 1,000.00 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC731388 PRG160000 730000 Printing 15,000.00 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC731500 PRG160000 730000 Public Information 56,000.00 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC731836 PRG160000 750000 Sponsorship 8,700.00 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC732018 PRG160000 750000 Travel and Conference 1,000.00 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC750399 PRG160000 750000 Office Supplies 500.00 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC750581 PRG160000 770000 Uniforms 200.00 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC774636 PRG160000 770000 Info Tech Operations 27,000.00 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC774677 PRG160000 770000 Insurance Fund 2,000.00 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC778675 PRG160000 730000 Telephone Communications 3,700.00 - -
Total Expenditures -$ -$ -$
WHEREAS a FY 2023 budget amendment is recommended for the Parks and Recreation to reallocate the line item budgets from CCN5060104 Planning to CCN5060101 Administrative Services. Fiscal Years 2024-2026 will be moved during the budget process.; and
WHEREAS a FY 2023 budget amendment is recommended for Parks and Recreation to reallocate the line item budgets from CCN5060120 Marketing & Communications to CCN5060101 Administrative Services. Fiscal Years 2024-2026 will be moved during the budget process; and
6
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 "A" DETAIL
R Parks and Recreation Administrative Services FND50800 CCN5060101 RC695500 PRG160000 695000 Transfers In 58,000.00$ -$ -$
R Parks and Recreation Administrative Services FND50800 CCN5060101 RC610313 PRG160000 610000 Federal Operating Grants 10,364.00 - -
R Parks and Recreation Administrative Services FND50800 CCN5060101 RD690189 PRG160000 690000 Capital Asset Contributions 80,260.00 - -
Total Revenues 148,624.00$ -$ -$
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC730037 PRG160000 730000 Adj Prior Years Exp 13,210.00$ -$ -$
E Parks and Recreation Natural Resources FND50800 CCN5060103 SC730037 PRG160431 730000 Adj Prior Years Exp 67.00 - -
E Parks and Recreation Recreation Programs & Community Services FND50800 CCN5060110 SC730037 PRG160700 730000 Adj Prior Years Exp 4,758.00 - -
E Parks and Recreation Marketing & Communications FND50800 CCN5060120 SC730037 PRG160000 730000 Adj Prior Years Exp 2,695.00 - -
E Parks and Recreation Facilities Maintenance FND50800 CCN5060146 SC730037 PRG160700 730000 Adj Prior Years Exp 69.00 - -
E Parks and Recreation Addison Oaks FND50800 CCN5060150 SC730037 PRG160710 730000 Adj Prior Years Exp 2,060.00 - -
E Parks and Recreation Groveland Oaks FND50800 CCN5060152 SC730037 PRG160710 730000 Adj Prior Years Exp 9,690.00 - -
E Parks and Recreation Holly Oaks FND50800 CCN5060154 SC730037 PRG160700 730000 Adj Prior Years Exp 3,004.00 - -
E Parks and Recreation Independence Oaks FND50800 CCN5060160 SC730037 PRG160700 730000 Adj Prior Years Exp 363.00 - -
E Parks and Recreation Orion Oaks FND50800 CCN5060162 SC730037 PRG160700 730000 Adj Prior Years Exp 537.00 - -
E Parks and Recreation Waterford Oaks FND50800 CCN5060164 SC730037 PRG160500 730000 Adj Prior Years Exp 83.00 - -
E Parks and Recreation Waterford Oaks FND50800 CCN5060164 SC730037 PRG160700 730000 Adj Prior Years Exp 1,630.00 - -
E Parks and Recreation Waterford Oaks FND50800 CCN5060164 SC730037 PRG160740 730000 Adj Prior Years Exp 363.00 - -
E Parks and Recreation Glen Oaks FND50800 CCN5060172 SC730037 PRG160010 730000 Adj Prior Years Exp 1,956.00 - -
E Parks and Recreation Glen Oaks FND50800 CCN5060172 SC730037 PRG160720 730000 Adj Prior Years Exp 530.00 - -
E Parks and Recreation Lyon Oaks FND50800 CCN5060174 SC730037 PRG160010 730000 Adj Prior Years Exp (650.00) - -
E Parks and Recreation Lyon Oaks FND50800 CCN5060174 SC730037 PRG160720 730000 Adj Prior Years Exp 2,998.00 - -
E Parks and Recreation Red Oaks FND50800 CCN5060176 SC730037 PRG160010 730000 Adj Prior Years Exp 21,306.00 - -
E Parks and Recreation Red Oaks FND50800 CCN5060176 SC730037 PRG160740 730000 Adj Prior Years Exp 2,087.00 - -
E Parks and Recreation Springfield Oaks FND50800 CCN5060178 SC730037 PRG160010 730000 Adj Prior Years Exp (1,101.00) - -
E Parks and Recreation Springfield Oaks FND50800 CCN5060178 SC730037 PRG160700 730000 Adj Prior Years Exp 569.00 - -
E Parks and Recreation White Lake Oaks FND50800 CCN5060180 SC730037 PRG160010 730000 Adj Prior Years Exp (505.00) - -
E Parks and Recreation Waterford Oaks FND50800 CCN5060164 SC731633 PRG160700 730000 Rental Property Maintenance 13,400.00 - -
E Parks and Recreation Addison Oaks FND50800 CCN5060150 SC730198 PRG160710 730000 Building Maintenance Charges 13,357.00 - -
E Parks and Recreation Addison Oaks Park FND50800 CCN5060150 SC730814 PRG160720 730000 Grounds Maintenance 6,505.00 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC730198 PRG160000 730000 Building Maintenance Charges 15,550.00 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC730789 PRG160000 730000 General Program Administration 13,600.00 - -
E Parks and Recreation Glen Oaks Golf FND50800 CCN5060172 SC730198 PRG160010 730000 Building Maintenance Charges 2,765.00 - -
E Parks and Recreation Glen Oaks Golf FND50800 CCN5060172 SC730814 PRG160010 730000 Grounds Maintenance 18,405.00 - -
E Parks and Recreation Groveland Oaks Park FND50800 CCN5060152 SC730814 PRG160710 730000 Grounds Maintenance 5,261.00 - -
E Parks and Recreation Independence Oaks Park FND50800 CCN5060160 SC730198 PRG160700 730000 Building Maintenance Charges 2,300.00 - -
E Parks and Recreation Lyon Oaks FND50800 CCN5060174 SC730198 PRG160700 730000 Building Maintenance Charges 10,515.00 - -
E Parks and Recreation Red Oaks Park FND50800 CCN5060176 SC730198 PRG160700 730000 Building Maintenance Charges 17,325.00 - -
E Parks and Recreation White Lake Oaks Conf Cent FND50800 CCN5060180 SC730198 PRG160720 730000 Building Maintenance Charges 375.00 - -
E Parks and Recreation Waterford Oaks FND50800 CCN5060164 SC730814 PRG160500 730000 Grounds Maintenance 30,285.00 - -
E Parks and Recreation Facilities Maintenance FND50800 CCN5060910 SC730789 PRG106430 730000 General Program Administration (136,244.00) - -
E Parks and Recreation Addison Oaks Park FND50800 CCN5060150 SC730814 PRG160720 730000 Grounds Maintenance 10,681.00 - -
E Parks and Recreation Catalpa Oaks Park FND50800 CCN5060170 SC730814 PRG160700 730000 Grounds Maintenance 2,095.00 - -
E Parks and Recreation Glen Oaks Golf FND50800 CCN5060172 SC730198 PRG160010 730000 Building Maintenance Charges 891.00 - -
E Parks and Recreation Glen Oaks Golf FND50800 CCN5060172 SC730814 PRG160010 730000 Grounds Maintenance 1,550.00 - -
E Parks and Recreation Groveland Oaks Park FND50800 CCN5060152 SC730198 PRG160710 730000 Building Maintenance Charges 183.00 - -
E Parks and Recreation Groveland Oaks Park FND50800 CCN5060152 SC730814 PRG160710 730000 Grounds Maintenance 37,000.00 - -
E Parks and Recreation Independence Oaks Park FND50800 CCN5060160 SC730198 PRG160700 730000 Building Maintenance Charges 2,686.00 - -
E Parks and Recreation Independence Oaks Park FND50800 CCN5060160 SC730814 PRG160700 730000 Grounds Maintenance 3,122.00 - -
E Parks and Recreation Red Oaks Park FND50800 CCN5060176 SC730814 PRG160700 730000 Grounds Maintenance 6,809.00 - -
E Parks and Recreation PR Springfield Oaks FND50800 CCN5060178 SC730814 PRG160010 730000 Grounds Maintenance 7,800.00 - -
E Parks and Recreation White Lake Oaks Golf FND50800 CCN5060180 SC730814 PRG160010 730000 Grounds Maintenance 1,027.00 - -
E Parks and Recreation Waterford Oaks Park FND50800 CCN5060164 SC730814 PRG160700 730000 Grounds Maintenance 3,148.00 - -
E Parks and Recreation Facilities Maintenance FND50800 CCN5060910 SC730789 PRG106430 730000 General Program Administration (76,991.00) - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC778675 PRG160000 796500 Budgeted Equity Adjustments 69,505.00 - -
Total Expenditures 148,624.00$ -$ -$
WHEREAS a FY 2023 budget amendment is recommended for Parks and Recreation reflecting operating transfer-in related to Trailways Development Agreement; unbudgeted capital contribution from the DNR for parking lot pavement at the ORV; funds received for the Restoring Riparian Habitat
and Connectivity to the Shiawassee River by Removing Mill Pond Damn project; prior year payments; Rental Property Maintenance; Waterford Oaks rental home water restoration; and allocate funds from General Program Administration account to various parks incurring maintenance project
costs during the first and second quarter of FY2023; and
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
Oakland County, Michigan
Schedule "A" DETAIL
R Pontiac Water Water Resources FND57234 CCN6010101 RC665882 PRG149030 665882 Planned Use of Balance $ 40,000 $- $-
Total Revenues 40,000$ -$ -$
E Pontiac Water Water Resources FND57234 CCN6010101 SC796500 PRG149030 796500 Budgeted Equity Adjustment $ (40,000) $- $-
Total Expenditures (40,000)$ -$ -$
Non-Department
R General Fund Non-Department FND10100 CCN9010101 RC665882 PRG196030 665882 Planned Use of Balance (39,840,000)$ -$ -$
Total Revenues (39,840,000)$ -$ -$
E General Fund Treasurers FND10100 CCN7010110 SC730289 PRG186130 730000 Claims (38,940,000)$ -$ -$
E General Fund Corporation Counsel FND10100 CCN1010101 SC731458 PRG181000 Professional Services (900,000)$
Total Expenditures (39,840,000)$ -$ -$
WHEREAS a FY 2023 budget amendment is recommended reversing resolution 2022-2323 on the settlement of the Bowles versus Oakland County and Dover Glen Condominium Association versus Oakland County as the expenditure was recognized in FY 2022; and
WHEREAS a FY2023 Budget Amendment is recommended for the Water Resources Commission correcting MR#23038 for using $40,000 of SC796500 Budgeted Equity Adjustment instead of RC665882 Planned Use of Balance; and
Water Resource Commisioner Pontiac Water (#57234)
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
Law Enforcement Grants (#11005)
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$ -$ -$
R Human Services Grants Health FND11007 CCN1060235 RC610313 PRG133970 GRN-1003913 610000 Federal Operating Grants 2,365$ -$ -$
Total Revenues 2,365$ -$ -$
E Human Services Grants Health FND11007 CCN1060235 SC732018 PRG133970 GRN-1003913 730000 Travel and Conference 2,365$ -$ -$
Total Expenditures 2,365$ -$ -$
R Human Services Grants Health FND11007 CCN1060290 RC610313 PRG115010 GRN-1003926 610000 Federal Operating Grants 31,200$ -$ -$
Total Revenues 31,200$ -$ -$
E Human Services Grants Health FND11007 CCN1060290 SC702010 PRG115010 GRN-1003926 702000 Salaries Regular (5,904)$ -$ -$
E Human Services Grants Health FND11007 CCN1060290 SC722740 PRG115010 GRN-1003926 722000 Fringe Benefits (6,960.00) - -
E Human Services Grants Health FND11007 CCN1060290 SC730926 PRG115010 GRN-1003926 730000 Indirect Costs (830.00) - -
E Human Services Grants Health FND11007 CCN1060290 SC730982 PRG115010 GRN-1003926 730000 Interpreter Fees 600.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC731346 PRG115010 GRN-1003926 730000 Personal Mileage 6.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC731388 PRG115010 GRN-1003926 730000 Printing 500.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC732018 PRG115010 GRN-1003926 730000 Travel and Conference 7,000.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC750077 PRG115010 GRN-1003926 750000 Disaster Supplies 4,588.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC750399 PRG115010 GRN-1003926 750000 Office Supplies 1,000.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC774636 PRG115010 GRN-1003926 770000 Info Tech Operations 31,200.00 - -
Total Expenditures 31,200$ -$ -$
R Human Services Grants Health FND11007 CCN1060290 RC610313 PRG115035 GRN-1003927 610000 Federal Operating Grants 65,552$ -$ -$
Total Revenues 65,552$ -$ -$
E Human Services Grants Health FND11007 CCN1060290 SC702010 PRG115035 GRN-1003927 702000 Salaries Regular (31,034)$ -$ -$
E Human Services Grants Health FND11007 CCN1060290 SC722740 PRG115035 GRN-1003927 722000 Fringe Benefits (14,725.00) - -
E Human Services Grants Health FND11007 CCN1060290 SC730926 PRG115035 GRN-1003927 730000 Indirect Costs (4,289.00) - -
E Human Services Grants Health FND11007 CCN1060290 SC731346 PRG115035 GRN-1003927 730000 Personal Mileage 23.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC750049 PRG115035 GRN-1003927 750000 Computer Supplies 1,000.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC750077 PRG115035 GRN-1003927 750000 Disaster Supplies 39,158.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC774636 PRG115035 GRN-1003927 770000 Info Tech Operations 75,413.00 - -
E Human Services Grants Health FND11007 CCN1060290 SC778675 PRG115035 GRN-1003927 770000 Telephone Communications 6.00 - -
Total Expenditures 65,552$ -$ -$
R Human Services Grants Health FND11007 CCN1060230 RC615571 PRG133215 GRN-1003919 615000 State Operating Grants 11,329$ -$ -$
Total Revenues 11,329$ -$ -$
WHEREAS a FY 2023 budget amendment of $99,117 is recommended for Health and Human Services Health Division to recognize the FY 2023 Local Health Department (Comprehensive) Amendment #2 for the Public Health Emergency Preparedness programs
and the Tuberculosis (TB) program is within 15% of the FY 2023 LHD acceptance (M.R. #22327). Amendment #2 increases total funding from $12,315,198 to $12,414,315; and
Oakland County, Michigan
Schedule "B" DETAIL
Human Services Grants (#11007)
WHEREAS a Sheriff's Office budget amendment of $7,460 is recommended to accept Safe Community First Responder grant funding 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); 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
E Human Services Grants Health FND11007 CCN1060230 SC730926 PRG133215 GRN-1003919 730000 Indirect Costs (10,388) - -
E Human Services Grants Health FND11007 CCN1060230 SC730982 PRG133215 GRN-1003919 730000 Interpreter Fees 4,500 - -
E Human Services Grants Health FND11007 CCN1060230 SC732018 PRG133215 GRN-1003919 730000 Travel and Conference 13,312 - -
E Human Services Grants Health FND11007 CCN1060230 SC731346 PRG133215 GRN-1003919 730000 Personal Mileage 2,500 - -
E Human Services Grants Health FND11007 CCN1060230 SC731941 PRG133215 GRN-1003919 730000 Training 750 - -
E Human Services Grants Health FND11007 CCN1060230 SC731388 PRG133215 GRN-1003919 730000 Printing 355 - -
E Human Services Grants Health FND11007 CCN1060230 SC750245 PRG133215 GRN-1003919 750000 Incentives 750 - -
E Human Services Grants Health FND11007 CCN1060230 SC750399 PRG133215 GRN-1003919 750000 Office Supplies (1,450) - -
E Human Services Grants Health FND11007 CCN1060230 SC750567 PRG133215 GRN-1003919 750000 Training-Educational Supplies 1,000 - -
Total Expenditures 11,329$ -$ -$
R Human Services Grants Health FND11007 CCN1060290 RC610313 PRG115010 GRN-1003926 610000 Federal Operating Grants 27,483$ -$ -$
Total Revenues 27,483$ -$ -$
E Human Services Grants Health FND11007 CCN1060290 SC702010 PRG115010 GRN-1003926 702000 Salaries Regular (2,748)$ -$ -$
E Human Services Grants Health FND11007 CCN1060290 SC732018 PRG115010 GRN-1003926 730000 Travel and Conference (3,400) - -
E Human Services Grants Health FND11007 CCN1060290 SC750077 PRG115010 GRN-1003926 750000 Disaster Supplies 19,833 - -
E Human Services Grants Health FND11007 CCN1060290 SC774636 PRG115010 GRN-1003926 770000 Info Tech Operations 10,200 - -
E Human Services Grants Health FND11007 CCN1060290 SC774677 PRG115010 GRN-1003926 770000 Insurance Fund 598 - -
E Human Services Grants Health FND11007 CCN1060290 SC774677 PRG115010 GRN-1003926 770000 Insurance Fund 3,000 - -
Total Expenditures 27,483$ -$ -$
R Human Services Grants Health FND11007 CCN1060290 RC610313 PRG115035 GRN-1003927 610000 Federal Operating Grants 9,407$ -$ -$
Total Revenues 9,407$ -$ -$
E Human Services Grants Health FND11007 CCN1060290 SC750077 PRG115035 GRN-1003927 750000 Disaster Supplies 6,437$ -$ -$
E Human Services Grants Health FND11007 CCN1060290 SC774636 PRG115035 GRN-1003927 770000 Info Tech Operations 2,626 - -
E Human Services Grants Health FND11007 CCN1060290 SC774677 PRG115035 GRN-1003927 770000 Insurance Fund 344 - -
Total Expenditures 9,407$ -$ -$
R Human Services Grants Health FND11007 CCN1060234 RC615571 PRG133405 GRN-1003923 615000 State Operating Grants 16,000$ -$ -$
Total Revenues 16,000$ -$ -$
E Human Services Grants Health FND11007 CCN1060234 SC702010 PRG133405 GRN-1003923 702000 Salaries Regular (8,939)$ -$ -$
E Human Services Grants Health FND11007 CCN1060234 SC722740 PRG133405 GRN-1003923 722000 Fringe Benefits (5,498) - -
E Human Services Grants Health FND11007 CCN1060234 SC730072 PRG133405 GRN-1003923 730000 Advertising 16,000 - -
E Human Services Grants Health FND11007 CCN1060234 SC730926 PRG133405 GRN-1003923 730000 Indirect Costs (1,242) - -
E Human Services Grants Health FND11007 CCN1060234 SC731346 PRG133405 GRN-1003923 730000 Personal Mileage 2,017 - -
E Human Services Grants Health FND11007 CCN1060234 SC731388 PRG133405 GRN-1003923 730000 Printing 100 - -
E Human Services Grants Health FND11007 CCN1060234 SC731458 PRG133405 GRN-1003923 730000 Professional Services 13,912 - -
E Human Services Grants Health FND11007 CCN1060234 SC732018 PRG133405 GRN-1003923 730000 Travel and Conference (250) - -
E Human Services Grants Health FND11007 CCN1060234 SC750049 PRG133405 GRN-1003923 750000 Computer Supplies (564) - -
E Human Services Grants Health FND11007 CCN1060234 SC750301 PRG133405 GRN-1003923 750000 Medical Supplies 214 - -
E Human Services Grants Health FND11007 CCN1060234 SC750399 PRG133405 GRN-1003923 750000 Office Supplies 150 - -
E Human Services Grants Health FND11007 CCN1060234 SC750392 PRG133405 GRN-1003923 750000 Metered Postage 100 - -
Total Expenditures 16,000$ -$ -$
R Human Services Grants Health FND11007 CCN1060294 RC610313 PRG133990 GRN-1003918 610000 Federal Operating Grants 50,000$ -$ -$
Total Revenues 50,000$ -$ -$
E Human Services Grants Health FND11007 CCN1060294 SC731997 PRG133990 GRN-1003918 730000 Client Transportation 3,500$ -$ -$
E Human Services Grants Health FND11007 CCN1060294 SC731346 PRG133990 GRN-1003918 730000 Personal Mileage 328 - -
E Human Services Grants Health FND11007 CCN1060294 SC732018 PRG133990 GRN-1003918 730000 Travel and Conference 2,000 - -
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
E Human Services Grants Health FND11007 CCN1060294 SC750112 PRG133990 GRN-1003918 750000 Drugs 1,000 - -
E Human Services Grants Health FND11007 CCN1060294 SC750245 PRG133990 GRN-1003918 750000 Incentives 5,000 - -
E Human Services Grants Health FND11007 CCN1060294 SC730324 PRG133990 GRN-1003918 730000 Communications 2,741 - -
E Human Services Grants Health FND11007 CCN1060294 SC770631 PRG133990 GRN-1003918 770000 Building Space Cost Allocation 2,400 - -
E Human Services Grants Health FND11007 CCN1060294 SC730072 PRG133990 GRN-1003918 730000 Advertising 4,671 - -
E Human Services Grants Health FND11007 CCN1060294 SC750049 PRG133990 GRN-1003918 750000 Computer Supplies 500 - -
E Human Services Grants Health FND11007 CCN1060294 SC750399 PRG133990 GRN-1003918 750000 Office Supplies 5,000 - -
E Human Services Grants Health FND11007 CCN1060294 SC750294 PRG133990 GRN-1003918 750000 Material and Supplies (22,698) - -
E Human Services Grants Health FND11007 CCN1060294 SC731388 PRG133990 GRN-1003918 730000 Printing (3,171) - -
E Human Services Grants Health FND11007 CCN1060294 SC750301 PRG133990 GRN-1003918 750000 Medical Supplies 40,000 - -
E Human Services Grants Health FND11007 CCN1060294 SC750567 PRG133990 GRN-1003918 750000 Training-Educational Supplies 500 - -
E Human Services Grants Health FND11007 CCN1060294 SC731458 PRG133990 GRN-1003918 730000 Professional Services 10,000 - -
E Human Services Grants Health FND11007 CCN1060294 SC731626 PRG133990 GRN-1003918 730000 Rent 100 - -
E Human Services Grants Health FND11007 CCN1060294 SC778675 PRG133990 GRN-1003918 770000 Telephone Communications (1,871) - -
Total Expenditures 50,000$ -$ -$
R Human Services Grants Health FND11007 CCN1060232 RC615571 PRG134850 GRN-1003937 615000 State Operating Grants 44,896$ -$ -$
Total Revenues 44,896$ -$ -$
E Human Services Grants Health FND11007 CCN1060232 SC702010 PRG134850 GRN-1003937 702000 Salaries Regular (622)$ -$ -$
E Human Services Grants Health FND11007 CCN1060232 SC722740 PRG134850 GRN-1003937 722000 Fringe Benefits 9,324 - -
E Human Services Grants Health FND11007 CCN1060232 SC730926 PRG134850 GRN-1003937 730000 Indirect Costs (91) - -
E Human Services Grants Health FND11007 CCN1060232 SC731346 PRG134850 GRN-1003937 730000 Personal Mileage 711 - -
E Human Services Grants Health FND11007 CCN1060232 SC731458 PRG134850 GRN-1003937 730000 Professional Services 20,000 - -
E Human Services Grants Health FND11007 CCN1060232 SC732018 PRG134850 GRN-1003937 730000 Travel and Conference 3,574 - -
E Human Services Grants Health FND11007 CCN1060232 SC731388 PRG134850 GRN-1003937 730000 Printing 5,000 - -
E Human Services Grants Health FND11007 CCN1060232 SC750567 PRG134850 GRN-1003937 750000 Educational Supplies 2,000 - -
E Human Services Grants Health FND11007 CCN1060232 SC750294 PRG134850 GRN-1003937 750000 Materials and Supplies 5,000 - -
Total Expenditures 44,896$ -$ -$
R Human Services Grants Health FND11007 CCN1060291 RC615571 PRG133200 GRN-1003936 615000 State Operating Grants (101)$ -$ -$
Total Revenues (101)$ -$ -$
E Human Services Grants Health FND11007 CCN1060291 SC730982 PRG133200 GRN-1003936 730000 Interpreter Fees 1,500$ -$ -$
E Human Services Grants Health FND11007 CCN1060291 SC731346 PRG133200 GRN-1003936 730000 Personal Mileage (836) - -
E Human Services Grants Health FND11007 CCN1060291 SC731388 PRG133200 GRN-1003936 730000 Printing (300) - -
E Human Services Grants Health FND11007 CCN1060291 SC750294 PRG133200 GRN-1003936 750000 Material and Supplies (465) - -
Total Expenditures (101)$ -$ -$
R Human Services Grants Health FND11007 CCN1060241 RC610313 PRG133390 GRN-1003948 610000 Federal Operating Grants (32,500)$ -$ -$
Total Revenues (32,500)$ -$ -$
E Human Services Grants Health FND11007 CCN1060241 SC702010 PRG133390 GRN-1003948 702000 Salaries Regular (22,147)$ -$ -$
E Human Services Grants Health FND11007 CCN1060241 SC722740 PRG133390 GRN-1003948 722000 Fringe Benefits (1,215) - -
E Human Services Grants Health FND11007 CCN1060241 SC730926 PRG133390 GRN-1003948 730000 Indirect Costs (3,061) - -
E Human Services Grants Health FND11007 CCN1060241 SC731346 PRG133390 GRN-1003948 730000 Personal Mileage (90) - -
E Human Services Grants Health FND11007 CCN1060241 SC732018 PRG133390 GRN-1003948 730000 Travel and Conference (350) - -
E Human Services Grants Health FND11007 CCN1060241 SC750399 PRG133390 GRN-1003948 750000 Office Supplies (10) - -
E Human Services Grants Health FND11007 CCN1060241 SC750245 PRG133390 GRN-1003948 750000 Incentives (400) - -
E Human Services Grants Health FND11007 CCN1060241 SC731388 PRG133390 GRN-1003948 730000 Printing (1,250) - -
E Human Services Grants Health FND11007 CCN1060241 SC750294 PRG133390 GRN-1003948 750000 Material and Supplies (1,550) - -
E Human Services Grants Health FND11007 CCN1060241 SC750567 PRG133390 GRN-1003948 750000 Training-Educational Supplies (372) - -
E Human Services Grants Health FND11007 CCN1060241 SC774636 PRG133390 GRN-1003948 770000 Info Tech Operations (1,676) - -
E Human Services Grants Health FND11007 CCN1060241 SC730072 PRG133390 GRN-1003948 730000 Advertising (1,733) - -
11
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
E Human Services Grants Health FND11007 CCN1060241 SC732165 PRG133390 GRN-1003948 730000 Workshops and Meeting 10 - -
E Human Services Grants Health FND11007 CCN1060241 SC731941 PRG133390 GRN-1003948 730000 Training 1,764 - -
E Human Services Grants Health FND11007 CCN1060241 SC778675 PRG133390 GRN-1003948 770000 Telephone Communications (420) - -
Total Expenditures (32,500)$ -$ -$
R Human Services Grants Health FND11007 CCN1060220 RC615571 PRG134870 GRN-1004108 615000 State Operating Grants 15,000$ -$ -$
Total Revenues 15,000$ -$ -$
E Human Services Grants Health FND11007 CCN1060220 SC702010 PRG134870 GRN-1004108 702000 Salaries Regular 7,379$ -$ -$
E Human Services Grants Health FND11007 CCN1060220 SC722740 PRG134870 GRN-1004108 722000 Fringe Benefits 4,088 - -
E Human Services Grants Health FND11007 CCN1060220 SC730926 PRG134870 GRN-1004108 730000 Indirect Costs 1,019 - -
E Human Services Grants Health FND11007 CCN1060220 SC774677 PRG134870 GRN-1004108 770000 Insurance Fund 14 - -
E Human Services Grants Health FND11007 CCN1060220 SC750168 PRG134870 GRN-1004108 750000 Equipment 800 - -
E Human Services Grants Health FND11007 CCN1060220 SC750539 PRG134870 GRN-1004108 750000 Testing Materials 100 - -
E Human Services Grants Health FND11007 CCN1060220 SC776661 PRG134870 GRN-1004108 770000 Motor Pool Charges 1,600 - -
Total Expenditures 15,000$ -$ -$
R Human Services Grants Health FND11007 CCN1060290 RC615571 PRG115010 GRN-1004109 615000 State Operating Grants 74,150$ -$ -$
Total Revenues 74,150$ -$ -$
E Human Services Grants Health FND11007 CCN1060290 SC702010 PRG115010 GRN-1004109 702000 Salaries Regular 36,143$ -$ -$
E Human Services Grants Health FND11007 CCN1060290 SC722740 PRG115010 GRN-1004109 722000 Fringe Benefits 19,879 - -
E Human Services Grants Health FND11007 CCN1060290 SC730926 PRG115010 GRN-1004109 730000 Indirect Costs 4,995 - -
E Human Services Grants Health FND11007 CCN1060290 SC750399 PRG115010 GRN-1004109 750000 Office Supplies 780 - -
E Human Services Grants Health FND11007 CCN1060290 SC774677 PRG115010 GRN-1004109 770000 Insurance Fund 291 - -
E Human Services Grants Health FND11007 CCN1060290 SC774637 PRG115010 GRN-1004109 770000 Info Tech Managed Print Svc 750 - -
E Human Services Grants Health FND11007 CCN1060290 SC774636 PRG115010 GRN-1004109 770000 Info Tech Operations 3,700 - -
E Human Services Grants Health FND11007 CCN1060290 SC750072 PRG115010 GRN-1004109 750000 Disaster Supplies 6,952 - -
E Human Services Grants Health FND11007 CCN1060290 SC778675 PRG115010 GRN-1004109 770000 Telephone Communications 660 - -
Total Expenditures 74,150$ -$ -$
R Human Services Grants Health FND11007 CCN1060290 RC615571 PRG115035 GRN-1004110 615000 State Operating Grants 62,209$ -$ -$
Total Revenues 62,209$ -$ -$
E Human Services Grants Health FND11007 CCN1060290 SC702010 PRG115035 GRN-1004110 702000 Salaries Regular 24,044$ -$ -$
E Human Services Grants Health FND11007 CCN1060290 SC722740 PRG115035 GRN-1004110 722000 Fringe Benefits 13,413 - -
E Human Services Grants Health FND11007 CCN1060290 SC730926 PRG115035 GRN-1004110 730000 Indirect Costs 3,323 - -
E Human Services Grants Health FND11007 CCN1060290 SC731346 PRG115035 GRN-1004110 730000 Personal Mileage 514 - -
E Human Services Grants Health FND11007 CCN1060290 SC750399 PRG115035 GRN-1004110 750000 Office Supplies 1,000 - -
E Human Services Grants Health FND11007 CCN1060290 SC730646 PRG115035 GRN-1004110 730000 Equipment Maintenance 838 - -
E Human Services Grants Health FND11007 CCN1060290 SC774677 PRG115035 GRN-1004110 770000 Insurance Fund 184 - -
E Human Services Grants Health FND11007 CCN1060290 SC750072 PRG115035 GRN-1004110 750000 Disaster Supplies 18,335 - -
E Human Services Grants Health FND11007 CCN1060290 SC778675 PRG115035 GRN-1004110 770000 Telephone Communications 558 - -
Total Expenditures 62,209$ -$ -$
WHEREAS a FY 2023 budget amendment of $277,873 is recommended for Health and Human Services Health Division to recognize the FY 2023 Local Health Department (Comprehensive) Amendment #3 for the Public Health Emergency Preparedness
programs, Eatern Equine Encephalitis Virus Surveillance, Emerging Threats Hep C, Harm Reduction Support Services, Nurse Family Partnership Services, Oral Health Kindergarten Assessment, Southeast Michigan Infant Vitality, and Transforming Youth Suicide
Prevention programs. Amendment #3 is within 15% of the FY 2023 LHD acceptance (M.R. #22327) which increases total funding from $12,414,315 to $12,692,188; and
12
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
R American Rescue Plan Non-
Department
FND21285 CCN9010101 RC610313 PRG133095 GRN-1003617 BFA40400 610000 Federal Operating Grants (500,000)$ -$ -$
Total Revenue (500,000)$ -$ -$
E American Rescue Plan Non-
Department
FND21285 CCN9010101 SC788001 PRG114000 GRN-1003617 BFA40400 788001 Transfers Out (500,000)$ -$ -$
E American Rescue Plan Non-
Department
FND21285 CCN9010101 SC788001 PRG133095 GRN-1004054 BFA40400 788001 Transfers Out 500,000
E American Rescue Plan Non-
Department
FND21285 CCN9010101 SC770000 PRG133095 GRN-1004054 7700000 Internal Support Expenditures (500,000) -$ -$
Total Expenditures (500,000)$ -$ -$
E American Rescue Plan Non-
Department
FND21285 CCN1070801 SC731150 PRG133095 GRN-1004054 730000 Maintenance Contract 213,930$ -$ -$
E American Rescue Plan Non-
Department
FND21285 CCN9010101 SC770000 PRG133095 GRN-1004054 770000 Internal Support Expenditures (213,930) -$ -$
Total Expenditures -$ -$ -$
R American Rescue Plan Non-
Department
FND21285 CCN9010101 RC610313 PRG133095 GRN-1004138 610000 Federal Operating Grants 2,000,000$ -$ -$
Total Revenue 2,000,000$ -$ -$
E American Rescue Plan Non-
Department
FND21285 CCN5010101 SC731598 PRG133095 GRN-1004138 730000 Regranting Program 2,000,000$ -$ -$
Total Expenditures 2,000,000$ -$ -$
WHEREAS a FY 2023 budget amendment of $213,930 is recommended to correct Miscellaneous Resolution #23032 as the incorrect account number was used as the offset for creating the positions within Animal Control; and
WHEREAS a FY 2023 budget amendment is recommended to appropriate $2,000,000 of American Rescue Plan Funds for the Webster School Center Revitalization (MR #2022-2395) to the Board of Commissioners General Fund/General Purpose budget; and
American Rescue Plan (21285)
WHEREAS a FY 20223 budget amendment of $500,000 is recommended to correct Miscellaneous Resolution #23071 budget amendment as the incorrect account was used as the offset for the expansion of Animal Control's outdoor kennles, landscaping and
masony wall project. This amendment also corrects the program number and grant identification number as this project should be charged to GRN-1004054 FY 2023 County Operations using the Pandemics program 133095; and
13
General Fund Equity
General Fund
Balance as of
9/30/2022
(Presented in the
YE Report
Unaudited)
Year End Adjustments
Final General Fund
Equity FY 2022
(Audited)
Non-Spendable
Prepaids 247,751.78$ -$ 247,751.78$
Inventories 172,928.79 -$ 172,928.79
Total Non-Spendable 420,680.57$ -$ 420,680.57$
Restricted
Property Tax Forfeiture -$ -$ -$
Total Restricted -$ -$ -$
Assigned
Budget Stablization Reserve 125,500,000.00$ -$ 125,500,000.00$
Strategic Investment Plan 44,000,000.00 (12,000,000.00) 32,000,000.00
Property Tax Forfeiture Activities 42,391,831.00 (39,840,000.00) 2,551,831.00
Reserve for Non Econ Budget Risks 25,100,000.00 - 25,100,000.00
Carry Forwards 17,971,071.00 - 17,971,071.00
Committed to FY 2023 8,575,000.00 - 8,575,000.00
Unused Local Road Commitments - 2,600,000.00 2,600,000.00
Secondary Township Road Repair Parternship 2,000,000.00 - 2,000,000.00
Encumbrances 1,963,199.00 - 1,963,199.00
Oxford Response 1,082,299.00 - 1,082,299.00
Marine Safety Patrol 100,000.00 - 100,000.00
Total Assigned 268,683,400.00$ (49,240,000.00)$ 219,443,400.00$
Total Unassigned 1,293,597.00 (333,935.00) 959,662.00
Total General Fund Equity 270,397,677.57$ (49,573,935.00)$ 220,823,742.57$
14
FY 2022 General Fund Balance Assignments (Post-Audit)
COUNTY OF OAKLAND
FY 2023 SECOND QUARTER REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2023 BUDGET AMOUNT
ADOPTED AS FY 2023 FAVORABLE/
BUDGET AMENDED FORECAST (UNFAVORABLE)PERCENT
REVENUES
GENERAL FUND
Taxes 285,734,704.00$ 290,920,000.00$ 290,920,000.00$ - 0.00%
Federal Grants 1,208,790.00 1,938,154.00 2,064,839.00 126,685.00 6.54%
State Grants 19,891,928.00 20,475,455.00 21,685,455.00 1,210,000.00 5.91%
Other Intergovernmental Revenue 49,848,663.00 49,848,663.00 49,653,613.00 (195,050.00) -0.39%
Charges for Services 127,682,464.00 129,808,591.00 124,313,635.00 (5,494,956.00) -4.23%
Indirect Cost Recovery 9,150,000.00 9,150,000.00 9,150,000.00 - 0.00%
Contributions 0.00 0.00 7,500.00 7,500.00
Investment Income 1,804,700.00 1,804,700.00 1,746,627.00 - 0.00%
Other Revenues 434,000.00 434,000.00 466,768.63 32,768.63 7.55%
Transfers In 26,053,877.00 26,251,086.00 26,351,086.00 100,000.00 0.38%
SUB-TOTAL GENERAL FUND/GENERAL PURPOSE 521,809,126.00$ 530,630,649.00$ 526,359,523.63$ (4,213,052.37)$ -0.79%
TOTAL GF/GP FUNDS 521,809,126.00$ 530,630,649.00$ 526,359,523.63$ (4,213,052.37)$ -0.79%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court 51,476,232.00$ 52,899,434.66$ 45,112,434.66 7,787,000.00$ 14.72%
52nd District Court 18,811,240.00 18,969,334.52 17,971,834.52 997,500.00 5.26%
Probate Court 7,760,407.00 7,886,786.90 7,601,786.90 285,000.00 3.61%
TOTAL ADMIN. OF JUSTICE 78,047,879.00$ 79,755,556.08$ 70,686,056.08$ 9,069,500.00$ 11.37%
LAW ENFORCEMENT
Prosecuting Attorney 26,205,522.00 27,130,406.60 25,552,406.60 1,578,000.00 5.82%
Sheriff 183,280,522.00 191,379,173.04 192,128,173.04 (749,000.00) -0.39%
TOTAL LAW ENFORCEMENT 209,486,044.00$ 218,509,579.64$ 217,680,579.64$ 829,000.00$ 0.38%
GENERAL GOVERNMENT
Clerk/Register of Deeds 10,767,003.00 10,994,936.04 9,885,436.04 1,109,500.00 10.09%
Treasurer 8,588,966.00 48,054,747.90 47,434,747.90 620,000.00 1.29%
Board of Commissioners 5,323,418.00 6,512,856.00 6,412,856.00 100,000.00 1.54%
Water Resources Commissioner 8,274,453.00 8,381,981.00 8,223,081.00 158,900.00 1.90%
TOTAL GENERAL GOVERNMENT 32,953,840.00$ 73,944,520.94$ 71,956,120.94$ 1,988,400.00$ 2.69%
COUNTY EXECUTIVE
County Executive Admn.9,986,336.00$ 11,007,437.00$ 10,154,108.00$ 853,329.00$ 7.75%
Management and Budget 25,144,692.00 25,722,793.00 24,234,793.00 1,488,000.00 5.78%
Facilities Management 4,723,654.00 5,010,979.72 4,298,814.72 712,165.00 14.21%
Human Resources 5,456,482.00 5,860,852.75 5,239,852.75 621,000.00 10.60%
Health and Human Services 44,810,566.00 48,359,659.18 43,914,659.18 4,445,000.00 9.19%
Public Services 43,399,767.00 44,406,992.64 43,608,992.64 798,000.00 1.80%
Economic Development 11,228,989.00 16,007,581.00 14,467,581.00 1,540,000.00 9.62%
Emergency Management & Homeland Security 2,150,270.00 3,325,312.38 3,532,312.38 (207,000.00) -6.22%
Public Communication 3,713,099.00 4,709,803.00 4,434,803.00 275,000.00 5.84%
TOTAL COUNTY EXECUTIVE 150,613,855.00$ 164,411,410.67$ 153,885,916.67$ 10,525,494.00$ 6.40%
TOTAL DEPARTMENTS 471,101,618.00$ 536,621,067.33$ 514,208,673.33$ 22,412,394.00$ 4.18%
Non-Departmental $58,981,384.00 $59,871,034.00 78,092,694.00 (18,221,660.00)
TOTAL GOVERNMENTAL EXPENDITURES 530,083,002.00$ 596,492,101.33$ 592,301,367.33$ 4,190,734.00$ 0.70%
General Fund/General Purpose
Favorable/(Unfavorable) - Budget Perspective (22,318.37)$ (22,318.37)$
PLANNED USE OF FUND BALANCE 8,273,876.00$ $ 65,861,452.37 $ 65,883,770.74
15
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$ 290,100,000.00$ 290,100,000.00 -$ 0.00%
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$ 290,920,000.00$ 290,920,000.00$ -$ 0.00%
FEDERAL GRANTS (610000-610999)
Sheriff - Sheriff's Office -$ -$ -$ -$ 0.00%
Sheriff - Patrol - 69,789.00 180,401.00 110,612.00 158.49%Fav. Due to Marine Safety Grant actuals moved from Other Inter-
Governmental Revenues; 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 175,127.00 116,073.00 196.55%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 497,821.00 497,821.00 - 0.00%
Health Division 648,790.00 631,490.00 631,490.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,938,154.00$ 2,064,839.00$ 126,685.00$ 6.54%
STATE GRANTS (615000-615999)
Sheriff - Emergency Response and Prep -$ 26,150.00$ 191,150.00$ 165,000.00$ 630.98%Fav. Michigan Commission on Law Enforcement Standards (MCOLES)
Public Safety Academy Assistance Grant due to reimbursement of
salaries for officers attending training at the Police Academy.
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 6,076,821.00 7,121,821.00 1,045,000.00 17.20%LCSA (Local Community Stabilization Authority) funding of $1,045,070
has been received; budget for this funding will be amended with 2nd
quarter.
Facilities Management - 15,000.00 15,000.00 -
Water Resources Commissioner - - - - 0.00%
Economic Development - Veteran's Services - - - - 0.00%
Non-Departmental - Child Care Subsidy 14,349,688.00 14,356,484.00 14,356,484.00 - 0.00%
Total State Grants 19,891,928.00$ 20,475,455.00$ 21,685,455.00$ 1,210,000.00$ 5.91%
OTHER INTER-GOVERNMENTAL REVENUES (620000 - 626999)
Non-Departmental 47,584,129.00$ 47,584,129.00$ 47,584,129.00$ -$ 0.00%
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2023 SECOND QUARTER REPORT
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 SECOND QUARTER REPORT
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%
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 SECOND 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 60,000.00 (195,050.00) -76.48%Unfav. Social Security Incentive Payments ($20,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
and Marine Safety Grant actuals ($175,050) moved to Federal
Operating Grants.
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,653,613.00$ (195,050.00)$ -0.39%
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,109,000.00 (25,000.00) -2.20%Unfav. Court Costs ($125,000) due to changes in legislation. Partially
offset by fav. Refund Fees PD Def Attorney $100,000 due to a delay in
payments from FY 2022 for restitution and other statutory fees.
Circuit Court - Family Division 1,421,500.00 1,421,500.00 596,500.00 (825,000.00) -58.04%Unfav. Board and Care ($650,000) along with Govt Benefit Board and
Care ($125,000) due to a decrease in reimbursement. Unfav. Court
Service Fees Probation ($50,000) due to a reduction in probation
caseload. The overarching cause of the variances identified above is
also due to the COVID-19 pandemic.
District Court - Division I (Novi)3,839,753.00 3,839,753.00 2,814,753.00 (1,025,000.00) -26.69%Unfav. Ordinance Fines and Costs ($625,000); Probation Fees
($225,000); and State Law Costs ($175,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,647,663.00 (175,000.00) -9.60%Unfav. Ordinance Fines and Costs ($100,000); Probation Fees
($50,000); and State Law Costs ($25,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,181,015.00 (705,000.00) -18.14%Unfav. Ordinance Fines and Costs ($450,000) as well as Probation
Fees ($255,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,440,590.00 (680,000.00) -32.07%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 ($225,000) as well as
State Law Costs ($55,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 758,600.00 240,000.00 46.28%Fav. Gross Estate Fees $165,000 due to a increase in fees paid. Fav.
Certified Copies $50,000 and Photostats $25,000 due to an increase in
activity.
Total Administration of Justice 14,743,121.00$ 14,743,121.00$ 11,548,121.00$ (3,195,000.00)$ -21.67%
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 SECOND QUARTER REPORT
Law Enforcement
Prosecuting Attorney 820,349.00$ 853,621.00$ 773,621.00 (80,000.00) -9.37%Unfav. State Appropriaton Victim Witness ($37,000), Reimb General
($27,000) at 46th District Court, Extradition Recovery Fee ($10,000)
and Educational Training ($6,000) due to less activity.
Sheriff's Office 2,900.00 2,900.00 12,900.00 10,000.00 344.83%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 $10,000 due to increased activity.
Sheriff - Corrective Services 2,116,000.00 2,419,335.00 2,319,335.00 (100,000.00) -4.13% Unfav. Commissions Contracts ($160,000) due to limited commissary
availability during pandemic, Inmate Board and Care ($25,000) due to
lower collection rates and Miscellaneous ($8,000); 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 717,059.00 (70,000.00) -8.89%Unfav. Board and Care ($45,000) due to less than anticipated judge
referrals to the tether program and Civil Action Service Fees ($25,000)
due to less activity.
Sheriff - Emergency Response and Prep - - 36,500.00 36,500.00 100.00%Fav. Reimb General $36,500 due to increased activity.
Sheriff - Patrol Services 61,791,616.00 62,942,732.00 62,942,732.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 545,000.00 (670,000.00) -55.14%Unfav. primarily due to Drug Testing ($740,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 and Miscellaneous due to restitution
payments
Total Law Enforcement 69,949,302.00$ 71,437,025.00$ 70,418,525.00$ (1,018,500.00)$ -1.43%
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 Motion Fees $50,000
due to increased activity.
Clerk - Elections 196,900.00 196,900.00 246,900.00 50,000.00 25.39%Fav. Due to Reimb General $50,000 as charging CVT's for election
services.
Clerk - Register of Deeds & Micrographics 15,447,500.00 15,447,500.00 13,747,500.00 (1,700,000.00) -11.01%Unfav. Due Record Fees Revenue ($1,000,000), Mortages ($400,000)
and Land Transfer Tax ($300,000) due to interest rates rising and low
housing inventory.
Treasurer 3,347,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,898,915.00 40,160.00 1.04%Fav - Soil Erosion Fees $40,000 increase in building activity/permits
due to improvement in the housing market.
Total General Government 25,253,055.00$ 25,253,055.00$ 23,793,215.00$ (1,459,840.00)$ -5.78%
19
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 SECOND 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 (143,834.00) -92.80%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 5,243,319.00 5,372,937.00 129,618.00 2.47%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,945.00 519,945.00 - 0.00%
Public Services - Animal Control 1,447,014.00 1,451,459.00 1,451,459.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 - 4,782.00 4,782.00 - 0.00%
Total County Executive 16,818,421.00$ 17,456,825.00$ 17,540,109.00$ 83,284.00$ 0.48%
Non-Departmental
Non-Dept - Charges for Services 918,565.00$ 918,565.00$ 1,013,665.00 95,100.00 10.35%Fav. Primarily due to Commission Public Telephone
Total Non-Departmental 918,565.00$ 918,565.00$ 1,013,665.00$ 95,100.00$ 10.35%
Total Charges for Services 127,682,464.00$ 129,808,591.00$ 124,313,635.00$ (5,494,956.00)$ -4.23%
INDIRECT COST RECOVERY (640100)9,150,000.00$ 9,150,000.00$ 9,150,000.00 -$ 0.00%
20
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 SECOND QUARTER REPORT
CONTRIBUTIONS (650000)
Board of Commissioners-Contributions - - - - 0.00%
Department of Public Communications - Sponsorships - - 7,500.00 7,500.00 100.00%Fav. due to Fire & Ice Sponsorship.
Economic Development & Comm Affairs - Contributions - - - - 0.00%
Economic Development - Contributions - - - - 0.00%
Total Contributions Revenues -$ -$ 7,500.00$ 7,500.00$ 100.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 - - - - 0.00%
Economic Development - - - - 0.00%
Health Division - - - - 0.00%
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$ 1,746,627.00$ -$ 0.00%
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 - - 3,600.00 3,600.00 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 - - 72,644.00 72,644.00 100.00%Fav. Prior Years Revenue
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%
Management and Budget - Fiscal Services - - - - 0.00%
21
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 SECOND QUARTER REPORT
Facilities Management - Support Services 1,500.00 1,500.00 1,500.00 - 0.00%
Human Resources - - - - 0.00%
Facilities Management Engineering - - - - 0.00%
Health Administration - - - - 0.00%
Health Division - Donations - - - - 0.00%
Health Division - - 377,000.00 377,000.00 100.00%Fav Refund Prior Year for correction of FY2022 duplicate accrual of
Honor Community Health invoice.
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) -100.00%Unfav. Due to less anticipated use.
Total Other Revenues 434,000.00$ 434,000.00$ 466,768.63 32,768.63$ 7.55%
TRANSFERS IN (695500)
Circuit Court - Transfers In - - - - 0.00%
Prosecuting Attorney Transfers In - - 100,000.00 100,000.00 100.00%Fav. due to timing of budget for Forfeiture Funds MR2023-2696
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 - 25,794.00 25,794.00 - 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,825,292.00 23,825,292.00 - 0.00%
Total Transfers In Revenues 26,053,877.00$ 26,251,086.00$ 26,351,086.00 100,000.00$ 0.38%
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$ 45,927,183.00$ 45,927,183.00 - 0.00%
Total Planned Use of Fund Balance 8,273,876.00$ 65,861,452.37$ 65,861,452.37$ -$ 0.00%
TOTAL GEN. FUND / GEN. PURPOSE REVENUE 530,083,002.00$ 596,492,101.37$ 592,220,976.00$ (4,213,052.37)$ -0.71%
22
Adopted Amended Forecast Favorability/UNF Percentage
$51,476,232.00 $52,899,434.66 $45,112,434.66 $7,787,000.00 14.72%
$28,064,168.00 $28,077,760.00 $25,727,760.00 $2,350,000.00 8.37%
$11,378,901.00 $12,151,150.66 $6,081,650.66 $6,069,500.00 49.95%
$5,227,181.00 $5,864,542.00 $6,497,042.00 ($632,500.00)-10.79%
$6,805,982.00 $6,805,982.00 $6,805,982.00 $0.00 0.00%
Personnel
Projected favorability in Salaries and Fringes due to underfilled and vacant positions across all divisions, with
greater favorability of $1,250,000 in Family Division and $600,000 in Judicial Administration
Operating
Circuit Court
2023 Q2 Forecast
Total
Summary of Projections
Transfers
Projected in line with budget for Transfers Out
Projected favorability due to decrease in placements to State Institutions $3,000,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 $355,000; Fees Guardian Ad Litem $225,000; and Professional
Services $200,000 under the Family Division due to less demand for these services
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
Projected unfavorability in InfoTech Operations ($500,000) across all divisions due to higher than anticipated
computer hardware and software utilization, with greater unfavorability of ($255,000) in Family Division and
($125,000) in Civil Criminal Division. A portion of the unfavorable variance for Info Tech Operations is offset by a
reimbursement from the State of Michigan for implementing a new mandate and will be reported under Revenues .
Internal
23
Adopted Amended Forecast Favorability/UNF Percentage
$18,811,240.00 $18,969,334.52 $17,971,834.52 $997,500.00 5.26%
$14,702,269.00 $14,795,658.00 $13,920,658.00 $875,000.00 5.91%
$2,196,016.00 $2,203,444.52 $2,115,944.52 $87,500.00 3.97%
$1,912,955.00 $1,970,232.00 $1,935,232.00 $35,000.00 1.78%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
No Transfers Out are budgeted in FY 2023
Projected favorability in Postage-Standard Mailing $10,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
Projected favorability in Software Support Maintenance $12,500 under Novi due to caseload. The District Court is
charged a base fee plus a per case fee
Projected favorability in Telephone Communications $70,000 mainly attributed to efforts to reduce landlines
to improve cost efficiency, with greater favorability of $25,000 in Novi and $17,500 in Rochester
The overall Internal Services category is partially offset by projected unfavorability in InfoTech Operations
($35,000) due to higher than anticipated use, with greater unfavorability of ($15,000) in Troy and ($12,500) in
Clarkston
Internal
Personnel
Projected favorability in Salaries and Fringes due to turnover across all divisions, with greater favorability
of $350,000 in Rochester, $200,000 in Novi and $200,000 in Clarkston
Operating
District Court
2023 Q2 Forecast
Total
Summary of Projections
24
Adopted Amended Forecast Favorability/UNF Percentage
$7,760,407.00 $7,886,786.90 $7,601,786.90 $285,000.00 3.61%
$5,543,249.00 $5,543,249.00 $5,218,249.00 $325,000.00 5.86%
$1,113,424.00 $1,159,304.90 $1,174,304.90 ($15,000.00) -1.29%
$1,103,734.00 $1,184,233.00 $1,209,233.00 ($25,000.00)-2.11%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
No Transfers Out are budgeted in FY 2023
Projected unfavorability in Fees Guardian Ad item ($37,500) as well as Medical Services Probate Exam
($30,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
$50,000 under Estates and Mental Health due to lower demand for this service
Projected unfavorability in InfoTech Operations ($30,000) and Equipment Rental ($17,500) 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 $22,500
under Judicial Administration due to lower than anticipated use
Internal
Personnel
Projected favorability in Salaries and Fringes due to underfilled positions/vacancies across all divisions, with
greater favorability of $250,000 in Estates and Mental Health
Operating
Probate Court
2023 Q2 Forecast
Total
Summary of Projections
25
Adopted Amended Forecast Favorability/UNF Percentage
$26,205,522.00 $27,130,406.60 $25,552,406.60 $1,578,000.00 5.82%
$21,971,765.00 $22,172,565.00 $20,557,565.00 $1,615,000.00 7.28%
$661,836.00 $1,261,863.60 $1,312,863.60 ($51,000.00) -4.04%
$2,351,664.00 $2,475,721.00 $2,681,721.00 ($206,000.00)-8.32%
$1,220,257.00 $1,220,257.00 $1,000,257.00 $220,000.00 18.03%Transfers
Transfers Out favorability is due to less Cooperative Reimbursement Program grant match obligation than budgeted
Unfavorability of ($155,000) is driven by variances in multiple spending categories such as Membership Dues, Travel and
Conference and Witness Fees and Mileage.
Forecasted unfavorability of ($206,000) is predominantly due to Info Tech Operations and a smaller amount due
to Telephone Communications.
Favorability of $60,000 is anticipated in Info Tech Managed Print Services due to remote work and paper
reduction efforts and offsets a portion of the unfavorability.
Internal
Prosecuting Attorney
2023 Q2 Forecast
Total
Summary of Projections
Projected unfavorability is partially offset by favorability of $105,000 which includes variances in several spending categories
such as Contracted Services, Expert Witness Fee and Mileage, Filing Fees, Library Continuations and Printing.
Personnel
Overtime unfavorable ($140,000) and offset by favorability in salaries and fringe benefits.
Favorability in salaries and fringe benefits due to turnover and vacancies.
Operating
26
Adopted Amended Forecast Favorability/UNF Percentage
$183,280,522.00 $191,379,173.04 $192,128,173.04 ($749,000.00) -0.39%
$145,712,711.00 $146,610,819.00 $148,625,819.00 ($2,015,000.00) -1.37%
$13,494,198.00 $18,529,024.04 $17,641,024.04 $888,000.00 4.79%
$23,358,310.00 $23,910,396.00 $23,602,396.00 $308,000.00 1.29%
$715,303.00 $2,328,934.00 $2,258,934.00 $70,000.00 3.01%Transfers
•Transfers Out are projected to be slightly favorable due to actual Motor Pool transfers to vehicles being lower than
estimated and Automotive Theft Prevention Association (ATPA) and Narcotics Enforcement Team (NET) grant match
obligation being lower than budgeted.
Favorability is driven by a few large items, with multiple smaller accounts across divisions favorable due to usage.
These accounts include Employee Medical Exams, Equipment Maintenance, Laundry and Cleaning, Library
Continuations, Office Supplies, Printing, Prisoner Housing‐Outside, Professional Services, Software Support
Maintenance and Supportive Services and reflect projected favorability of $360,000.
Favorability of $230,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.
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.
Forecasted favorability of $790,000 in Motor Pool, Radio Communications and Office Equipment Rental due to
less than anticipated usage and InfoTech Print Managed Services due to paper reduction efforts.
Projecting unfavorability of ($485,000) in Motor Pool Fuel Charges due to increased fuel costs and Info Tech
Operations and Telephone Communications due to higher usage.
Internal
Projected favorability of $200,000 in Laboratory Supplies which is offset by unfavorable Drug Testing revenue due
to reduced usage of the RESULTS drug testing program.
Projected unfavorability of ($40,000) in Emergency Response and Prep ‐ Electrical Service and Natural Gas due to
the increasing cost of utilities.
Personnel
•Overall personnel is unfavorable ($2,000,000) primarily in Overtime and associated Fringe Benefits due to turnover, vacant
positions, hospital watch, officers in the academy, and officers in training.
Operating
Sheriff's Office
2023 Q2 Forecast
Total
Summary of Projections
27
Adopted Amended Forecast Favorability/UNF Percentage
$10,767,003.00 $10,994,936.04 $9,885,436.04 $1,109,500.00 10.09%
$8,098,002.00 $8,098,002.00 $7,249,002.00 $849,000.00 10.48%
$1,332,412.00 $1,363,724.04 $1,068,224.04 $295,500.00 21.67%
$1,336,589.00 $1,533,210.00 $1,568,210.00 ($35,000.00)-2.28%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
•Projected in line with budget for Transfers Out
Favorability of $295,500 in Operating Expenditures is mainly attributed to $159,500 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.
County Clerk Division anticipated favorability of $85,000 due to Metered Postage, Professional Services and Office
Supplies due to less than anticipated use.
Forecasted Internal Services for Clerk's Department is unfavorable ($35,000) due to Telephone
Communications and Info Tech Operations due to greater than anticipated use.
Internal
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 Q2 Forecast
Total
Summary of Projections
•
•
•
•
28
Adopted Amended Forecast Favorability/UNF Percentage
$8,588,966.00 $48,054,747.90 $47,434,747.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,459,620.00 $1,459,620.00 $0.00 0.00%
$120,000.00 $120,000.00 $120,000.00 $0.00 0.00%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, Fee Civil Serivce
$200,000 and Foreclosure Notification $100,000 due to fewer land parcels being turned over to the county as
Delinquent.
Forecasted Internal Services for Treasurer's Department is at budget for Q2 as utilization is at 25%.
Internal
Personnel
Favorability in salaries and fringes within The Treasurer department is due to fringe benefits, vacancies, turnover and
underfilled positions.
Operating
Treasurer
2023 Q2 Forecast
Total
Summary of Projections
•
•
•
29
Adopted Amended Forecast Favorability/UNF Percentage
$5,323,418.00 $6,512,856.00 $6,412,856.00 $100,000.00 1.54%
$3,443,428.00 $3,443,428.00 $3,343,428.00 $100,000.00 2.90%
$1,184,048.00 $2,348,145.00 $2,348,145.00 $0.00 0.00%
$695,942.00 $721,283.00 $721,283.00 $0.00 0.00%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
•No Transfers Out are budgeted 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.
Newly elected Commisioners terms started 1/1/2023 and have upcoming projects will utilize majority of budget.
Forecasted Internal Services is at budget for Q2.
Internal
Personnel
Favorability in salaries and fringes within The Board of Commissioners department is due to fringe benefits, vacancies,
turnover and underfilled positions.
Operating
Board of Commissioners
2023 Q2 Forecast
Total
Summary of Projections
•
•
•
•
30
Adopted Amended Forecast Favorability/UNF Percentage
$8,274,453.00 $8,381,981.00 $8,223,081.00 $158,900.00 1.90%
$234,624.00 $234,624.00 $234,624.00 $0.00 0.00%
$287,975.00 $288,094.00 $226,694.00 $61,400.00 21.31%
$7,695,689.00 $7,803,098.00 $7,705,598.00 $97,500.00 1.25%
$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.
•Favorable Legal Services and Professional Services due to less spending on these services
related to the Soil Erosion and Environmental Unit programs.
•Forecasted Internal Services for Water Resources Commissioner is at budget for Q2 as utilization
is at 50%.
•Favorable Drain Equipment due to less equipment being used in rework projects.
Internal
Water Resources Commissioner
2023 Q2 Forecast
Total
Summary of Projections
Personnel
•Salaries and Fringes overall projected to be on budget.
Operating
31
Adopted Amended Forecast Favorability/UNF Percentage
$9,986,336.00 $11,007,437.00 $10,154,108.00 $853,329.00 7.75%
$6,189,140.00 $6,199,706.00 $5,906,444.00 $293,262.00 4.73%
$990,835.00 $1,876,068.00 $1,438,968.00 $437,100.00 23.30%
$922,740.00 $1,019,842.00 $925,075.00 $94,767.00 9.29%
$1,883,621.00 $1,911,821.00 $1,883,621.00 $28,200.00 1.48%
County Executive
2023 Q2 Forecast
Total
Summary of Projections
Personnel
Operating
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.
Forecasted favorability of $87,100 in Admin, primarily due to $78,200 for Info Tech Operations. Audit being
conducted as some of this budget may need to be moved to DPC. Also favorable, Info Tech Managed Print Svcs of
$8,100 due to increased electronic usage.
Compliance Office projected $19,900 in favorability primarily due to Info Tech Operations favorability of $17,800.
Audit being completed to confirm charges being assigned correctly, as these are licenses.
DEI is favorable $3,767 due to vacancy.
Internal
Projected unfavorability of ($55,500) in Admin. Professional Services line item is projected unfavorable by
($90,000) of which ($30,000) is due to an invoice from 2022 paid in 2023. Partially offset by $22,400 in favorability
from Special Events and $12,800 from Contracted Services line items due to lack of anticipated use.
Projected favorability in Compliance Office of $176,000 due to lower utilization for nearly all spend categories. Most
notable expense is Professional Services, projected to be $95,500 for the year.
Projected favorability in DEI of $299,900 due to lower budget utilization. Primary sources are $148,800 projected
favorable for Special Event Program and $49,800 in Special Event Supplies.
Projected favorability of $16,700 for Corporation Counsel. Favorability in Library Continuations $5,800 due to
electronic copies being available. Also favorable are Travel and Conference $4,300 and Computer Supplies $2,000
due less than anticipated use. Partially offset by unfavorable Training and Employee In-Service Training ($1,200)
due to lack of budgets.
Projected unfavorability for Corporation Counsel of ($16,000) primarily due to Info Tech Operations ($13,300).
Also unfavorable in Telephone by ($4,100) due to ongoing maintence charges for replaced equipment. Partially
offset by favorability of $1,400 in Info Tech Managed Print Svcs due to increased electrnic usage.
Favorability of $212,500 in Admin due to vacancy, turnover and step increases.
Favorability of $80,762 due to vacancy within DEI division.
Compliance Office, Corporate Counsel, and Indigent Defense Services Office divisions are all at budget for
FY23-Q2.
32
Adopted Amended Forecast Favorability/UNF Percentage
$25,144,692.00 $25,722,793.00 $24,234,793.00 $1,488,000.00 5.78%
$20,479,043.00 $20,479,043.00 $19,279,043.00 $1,200,000.00 5.86%
$1,120,330.00 $1,337,514.00 $1,069,514.00 $268,000.00 20.04%
$3,545,319.00 $3,906,236.00 $3,886,236.00 $20,000.00 0.51%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
No Transfers Out are budgeted in FY 2023
Favorability projected for Equalization Divison Printing $30,000, Personal Mileage $20,000, Training $20,000, Professional
Services $15,000, Employee Footwear $7,000, and Expendable Equipment $7,000 due to less than anticipated usage. Partially
offset by Uniforms ($20,000) and Office Supplies ($15,000) Office Supplies due to increase usage.
Forecasted favorable for Fiscal Services for Info Tech Print Managed Services $20,000 due to remote work leading to less
than normal usage.
Internal
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.
Favorability projected for Purchasing Travel and Conference $4,000 due increase in virtual and remote meetings.
Personnel
Favorability in salaries and fringes $1,200,000 due to turnover and underfilled positions/vacancies across all
divisions, with greater favorability from Fiscal Services and Equalization Division.
Operating
Management & Budget
2023 Q2 Forecast
Total
Summary of Projections
33
Adopted Amended Forecast Favorability/UNF Percentage
$4,723,654.00 $4,995,979.72 $4,283,814.72 $712,165.00 14.25%
$2,882,560.00 $2,882,560.00 $2,210,795.00 $671,765.00 23.30%
$767,229.00 $1,015,170.72 $1,002,270.72 $12,900.00 1.27%
$1,073,865.00 $1,098,249.00 $1,070,749.00 $27,500.00 2.50%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
No Transfers Out are budgeted in FY 2023
Projected favorability in Professional Services $75,000 under the Sustainability Initiatives program due to a delay
in hiring educational and implementation contractors
Projected favorability in Printing $35,000 under the Sustainability Initiatives program due to a delay in the start of
event and educational initiatives
Projected favorability in Special Event Supplies $35,000 under the Sustainability Initiatives program due to a delay
in the start of special events
Projected favorability in InfoTech Operations of $27,500 due to lower than anticipated use, with greater
favorability of $20,000 within Facilities Planning and Engineering
Internal
The overall Operating category is partially offset by projected unfavorability in Mail Handling-Postage Svc
($100,000) under Support Services due to higher than anticipated rebills to other departments
Personnel
Projected favorability in Salaries and Fringes due to turnover and vacant positions, with greater favorability of
$400,000 in Facilities Planning and Engineering along with $275,000 in Facilities Administration
Operating
Facilities Management
2023 Q2 Forecast
Total
Summary of Projections
34
Adopted Amended Forecast Favorability/UNF Percentage
$5,456,482.00 $5,860,852.75 $5,239,852.75 $621,000.00 10.60%
$3,607,735.00 $3,607,735.00 $3,272,735.00 $335,000.00 9.29%
$565,601.00 $882,468.75 $757,468.75 $125,000.00 14.16%
$1,283,146.00 $1,370,649.00 $1,209,649.00 $161,000.00 11.75%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
•No Transfers Out are budgeted in FY 2023.
Forecasting Expenditures favorability of $125,000 mostly attributed to Administration Divison Professional
Services $220,000 and Legal Serivces $40,000 due to less than anticipated use.
Favorability will be offset by unfavorability within Workforce Division's Recruitment Expense ($100,000),
Pscychological Testing ($20,000) and Contracted Services ($15,000) due to increased hiring costs.
Forecasted Internal Services for Treasurer's Department is at budget for Q2 as utilization is at 25%.
Internal
Personnel
Favorability in salaries and fringes within Human Resources department is due to vacancies, turnover and underfilled
positions.
Operating
Human Resources
2023 Q2 Forecast
Total
Summary of Projections
•
•
•
•
35
Adopted Amended Forecast Favorability/UNF Percentage
$44,810,566.00 $48,359,659.18 $43,914,659.18 $4,445,000.00 9.19%
$31,938,944.00 $31,938,944.00 $30,938,944.00 $1,000,000.00 3.13%
$8,403,941.00 $11,134,903.18 $7,854,903.18 $3,280,000.00 29.46%
$3,858,143.00 $4,056,877.00 $3,891,877.00 $165,000.00 4.07%
$609,538.00 $1,228,935.00 $1,228,935.00 $0.00 0.00%
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
Health
2023 Q2 Forecast
Total
Summary of Projections
Transfers
Neighborhood Housing Development forecast for Q2 is at budget.
Favorability for Private Institution Residence $1,000,000, Private Institution $400,000, Private Institution Foster
$250,000, Independent Living $150,000, and Foster Board Home $120,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. Also, $50,000 for Area Agency on Aging due to less than anticipated
demand.
Favorability projected for Professional Services $1,000,000 for LCSA funding received in November 2022 and not anticipated
to be completely spent in FY2023, West Nile Virus $100,000, Uniform Cleaning $60,000, Contracted Services $60,000,
Vaccines $50,000, and Equipment Maintenance $10,000 for less than anticipated demant and the impact of COVID‐19; Drugs
$10,000 due to grant funding for refugees. 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
36
Adopted Amended Forecast Favorability/UNF Percentage
$43,399,767.00 $44,406,992.64 $43,608,992.64 $798,000.00 1.80%
$31,303,511.00 $31,739,984.00 $31,379,984.00 $360,000.00 1.13%
$5,502,271.00 $5,932,726.64 $5,418,726.64 $514,000.00 8.66%
$6,593,985.00 $6,734,282.00 $6,810,282.00 ($76,000.00)-1.13%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
•Projected in line with budget for Transfers Out
Favorability of $463,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 $125,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.
•Projected unfavorability in InfoTech Operations ($76,000) across all divisions due to a higher than antcipated
computer hardware and software utilization.
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.
Personnel
•Personnel favorability within Children's Village Division will be impacted due to one-tme payments to direct care
workers. Partial reimbursment was received from the State and was recorded as a Q1 amendement.
•Favorability in salaries and fringes due to turnover and underfilled positions/vacancies mostly attributed to
Community Corrections and Medical Examiner divisions.
Operating
Public Services
2023 Q2 Forecast
Total
Summary of Projections
•
•
•
•
37
Adopted Amended Forecast Favorability/UNF Percentage
$11,228,989.00 $16,007,581.00 $14,467,581.00 $1,540,000.00 9.62%
$7,844,494.00 $7,844,494.00 $7,144,494.00 $700,000.00 8.92%
$2,034,875.00 $5,399,951.00 $4,459,951.00 $940,000.00 17.41%
$1,349,620.00 $1,463,136.00 $1,563,136.00 ($100,000.00)-6.83%
$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 Q2 Forecast
Total
Summary of Projections
Transfers
Transfers Out for Neighborhood Housing Development forecast Q2 is at budget.
Favorability projected for Economic Development Administration Division for Advertising $70,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.
Unfavorability in Local Business Development Division for Info Tech Operations ($100,000) due to more than anticipated
usage.
Internal
Favorability of $760,000 projected for Planning and Local Business Development Division for Professional Services $200,000,
Special Event Program $150,000, Workshop and Meetings $150,000, Advertising $100,000, Business Recruitment $70,000,
Software Support $60,000, Drafting Supplies and Maps $15,000, Office Supplies $10,000, and Metered Postage $5,000 due to
less than antcipated usage and reorganization within Department.
Favorability of $80,000 projected for Veteran Service Division for Soldier Burial $70,000 and Soldier Relief $10,000 due to
less than antcipated claims for veteran benefits such as burial in National Cemetary, headstones, markers, burial flags, and
other veteran benefits.
38
Adopted Amended Forecast Favorability/UNF Percentage
$2,150,270.00 $3,325,312.38 $3,532,312.38 ($207,000.00) -6.22%
$1,081,520.00 $1,089,341.00 $1,089,341.00 $0.00 0.00%
$469,337.00 $1,604,927.38 $1,811,927.38 ($207,000.00)-12.90%
$599,413.00 $631,044.00 $631,044.00 $0.00 0.00%
$0.00 $0.00 $0.00 $0.00 0.00%
Personnel
Personnel For Emergency Management & Homeland Security forecast for 2nd Qtr is at budget.
Operating
Emergency Management & Homeland Security
2023 Q2 Forecast
Total
Summary of Projections
Transfers
No Transfers Out are budgeted in FY 2023
Unfavorability in Rent ($100,000), Medical Supplies ($82,000), and Disaster Supplies ($25,000) for expenditures that are
anticipated to be reimbursed by FEMA (Federal Emergency Management Agency) through May 11, 2023. Funding for these
line items will be covered by ARPA through the cut‐off date in 2024 afterwards.
Internal Services for Emergency Management & Homeland Security forecast Q2 is at budget.
Internal
39
Adopted Amended Forecast Favorability/UNF Percentage
$3,713,099.00 $4,709,803.00 $4,434,803.00 $275,000.00 5.84%
$2,178,262.00 $2,362,278.00 $1,887,278.00 $475,000.00 20.11%
$1,494,000.00 $2,034,984.00 $2,134,984.00 ($100,000.00) -4.91%
$40,837.00 $312,541.00 $412,541.00 ($100,000.00)-32.00%
$0.00 $0.00 $0.00 $0.00 0.00%
Personnel
Projected favorability in Salaries and Fringes due to turnover and vacancies
Operating
Dept. of Public Communications
2023 Q2 Forecast
Total
Summary of Projections
Transfers
No Transfers Out are budgeted in FY 2023
Projected unfavorability in Metered Postage ($100,000)
Projected unfavorability in Info Tech Operations due to higher than anticipated use
Internal
40
Account Adopted Budget Amended Budget Actuals- 3/31/23 Variance Percentage 2nd Qtr Fcst 2nd Qtr Variance Explanation
Expenditure
SC702145 -
Separation Incentive
1,041,385.00 1,041,385.00 323,023.91 718,361.09 31.02% 900,000.00 141,385.00 Fav. Due to Voluntary Employee Seperation
Incentive Program (VESIP) and VESIP Schedule C
incentive pay less than budgeted projection.
SC702995 - Salary
Turnover Factor
(10,272,145.00)(10,272,145.00)0.00 (10,272,145.00) 0.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)323,023.91 (9,553,783.91)(3.50%)900,000.00 (10,130,760.00)
SC722760 - Group 0.00 0.00 1.80 (1.80)0.00%- -
SC722790 - Social
Security
0.00 0.00 19,983.94 (19,983.94) 0.00% 40,000.00 (40,000.00) Unfav. Due to the fringe component of the Voluntary
Employee Seperation Incentive Program
SC722810 - Disability 0.00 0.00 6.65 (6.65)0.00%- -
722000:Fringe Benefits 0.00 0.00 19,992.39 (19,992.39)0.00%40,000.00 (40,000.00)
RC730240 - Cash
Shortage
0.00 0.00 1.00 (1.00) 0.00%- -
SC730044 - Adj Prior
Years Revenue
0.00 0.00 0.00 0.00 0.00%- -
SC730121 - Bank
Charges
0.00 0.00 46,394.43 (46,394.43) 0.00% 46,400.00 (46,400.00) Unfav. Due to bank charges are not budgeted.
SC730240 - Cash
Shortage
0.00 0.00 45.79 (45.79) 0.00%- -
SC730359 -
Contingency
815,541.00 2,332,199.00 0.00 2,332,199.00 0.00% 2,332,199.00 -
SC730611 -
Employees Medical
Exams
0.00 0.00 0.00 0.00 0.00%- -
SC730800 - Grant
Match
350,000.00 73.00 0.00 73.00 0.00%73.00 -
SC730954 -
Insurance Surety
33,305.00 33,305.00 715.00 32,535.00 2.31% 33,305.00 -
SC731136 - Logos
Trademarks Intellect
Prp
20,000.00 20,000.00 24,466.36 (4,466.36) 122.33% 24,500.00 (4,500.00) Unfav. Due to increased costs.
SC731241 -
Miscellaneous
300,000.00 300,000.00 0.00 300,000.00 0.00% 300,000.00 -
SC731346 - Personal
Mileage
0.00 0.00 31.42 (31.42) 0.00%- -
SC731577 - Refund
Prior Years Revenue
0.00 0.00 296.97 (296.97) 0.00%- -
SC731822 - Special
Projects
650,000.00 450,000.00 0.00 450,000.00 0.00% 450,000.00 -
SC731885 -
Supportive Services
0.00 0.00 675.00 (675.00) 0.00%- -
730000:Contractual
Services
2,168,846.00 3,135,577.00 72,625.97 3,062,896.03 2.32% 3,186,477.00 (50,900.00)
SC740037 -
Classification and
Rate Change
193,451.00 66,641.00 0.00 66,641.00 0.00% 66,641.00 -
SC740044 - Drain
Assessments Current
2,025,000.00 2,025,000.00 914,212.09 1,110,787.91 45.15% 2,025,000.00 -
SC740058 -
Emergency Salaries
Reserve
72,674.00 72,674.00 0.00 72,674.00 0.00% 72,674.00 -
SC740072 - General
Fund Contingency
(8,000,000.00)(8,000,000.00)0.00 (8,000,000.00) 0.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.
NON-DEPARTMENT EXPENDITURES FY 2023 SECOND QUARTER REPORT
41
Account Adopted Budget Amended Budget Actuals- 3/31/23 Variance Percentage 2nd Qtr Fcst 2nd Qtr Variance Explanation
NON-DEPARTMENT EXPENDITURES FY 2023 SECOND QUARTER REPORT
SC740085 - Local
Road Funding
Program
2,000,000.00 2,000,000.00 4,394,357.00 (2,394,357.00) 219.72% 2,000,000.00 -
SC740086 - Mental
Health Authority
9,620,616.00 9,620,616.00 4,810,308.00 4,810,308.00 50.00% 9,620,616.00 -
SC740093 - Mich
Association of
Counties
73,000.00 73,000.00 0.00 73,000.00 0.00% 73,000.00 -
SC740100 - National
Assoc of Counties
24,100.00 24,100.00 24,047.00 53.00 99.78% 24,100.00 -
SC740114 - Overtime
Reserve
300,000.00 300,000.00 0.00 300,000.00 0.00% 300,000.00 -
SC740135 - Road
Comm Tri Party
2,000,000.00 4,374,048.00 1,387,185.99 2,986,862.01 31.71% 4,374,048.00 -
SC740149 - 550,000.00 550,000.00 288,851.00 261,149.00 52.52%550,000.00 -
SC740160 -
Substance Abuse
Coord Agency
4,943,138.00 4,943,138.00 759,564.50 4,183,573.50 15.37% 4,943,138.00 -
SC740177 - Traffic
Improvement Assoc
30,000.00 30,000.00 0.00 30,000.00 0.00% 30,000.00 -
740000:Non-
Departmental
13,831,979.00 16,079,217.00 12,578,525.58 3,500,691.42 78.23% 24,079,217.00 (8,000,000.00)
SC760126 - Capital
Outlay Miscellaneous
300,000.00 754,699.00 0.00 754,699.00 0.00% 754,699.00 -
SC760180 -
Technology Projects-
One Time
2,000,000.00 1,188,556.00 0.00 1,188,556.00 0.00% 1,188,556.00 -
760000:Capital Outlay 2,300,000.00 1,943,255.00 0.00 1,943,255.00 0.00%1,943,255.00 -
SC770631 - Bldg
Space Cost
1,104,752.00 1,104,752.00 552,376.02 552,375.98 50.00% 1,104,752.00 -
SC773630 - Info
Tech Development
9,212,320.00 6,620,633.00 7,902.50 6,612,730.50 0.12% 6,620,633.00 -
SC774677 -
Insurance Fund
460,272.00 460,272.00 41,075.00 419,197.00 8.92% 460,272.00 -
SC775754 -
Maintenance
Department Charges
702,500.00 436,230.00 0.00 436,230.00 0.00% 436,230.00 -
SC777599 - Service
Center Grounds
500,000.00 500,000.00 249,999.96 250,000.04 50.00% 500,000.00 -
770000:Internal Support
Expenditures
11,979,844.00 9,121,887.00 851,353.48 8,270,533.52 9.33% 9,121,887.00 -
SC788001 -
Transfers Out
37,931,475.00 38,821,858.00 11,207,232.00 27,614,626.00 28.87% 38,821,858.00 -
788001:Transfers Out 37,931,475.00 38,821,858.00 11,207,232.00 27,614,626.00 28.87%38,821,858.00 -
SC796500 -
Budgeted Equity
0.00 0.00 0.00 0.00 0.00%- -
796500:Budgeted Equity
Adjustments
0.00 0.00 0.00 0.00 0.00%- -
Total Expenditure 58,981,384.00 59,871,034.00 25,052,753.33 34,818,225.67 41.84%78,092,694.00 (18,221,660.00)
42
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
43
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.
44
COUNTY OF OAKLAND
FY 2023 SECOND QUARTER REPORT
ENTERPRISE FUND
PARKS & RECREATION
ADOPTED AMENDED FY 2023 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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,368,299.00$ 34,398,976.00$ 34,398,976.00$ 0.00% Unfavorable Adj Prior Years Expense ($65,715) for parkwide payment of
prior years expenses and Rental Property Maintenance ($13,400) related to
a water restoration expense at Waterford Oaks. A budget amendment is
recommended.
NET OPERATING INCOME (LOSS)(22,414,942.00)$ (22,445,619.00)$ (22,445,619.00)$ -$ 0.00%
NON-OPERATING REVENUE (EXPENSE)24,928,577.00$ 25,073,077.00$ 26,376,701.00$ 1,303,624.00$ 5.20% Fav. Increase Market Value Investment adjustment reversal from FY2022
$1,213,000. A budget amendment is not recommended at this time due to
uncertain market conditions. Fav. Capital Asset Contributions $80,260
related to DNR grant for ORV parking lot project and fav. Federal Operating
Grants $10,364 for restoring riparian habitat and connectivity to the
Shiawassee River by removing Mill Pond Dam. A budget amendment is
recommended.
TOTAL INCOME BEFORE TRANSFERS 2,513,635.00$ 2,627,458.00$ 3,931,082.00$ 1,303,624.00$ -49.62%
TRANSFERS IN -$ -$ -$ 58,000.00$ Fav. Operating transfers in $58,000 related to Trailways Development
Agreement. A budget amendment is recommended.
TOTAL NET INCOME/BUDGETED EQUITY ADJ 2,513,635.00$ 2,627,458.00$ 3,931,082.00$ 1,361,624.00$
Fav. Budgeted Equity Adjustments $3,931,082 is the amount projected to be
added to fund balance at the end of the fiscal year for use in capital
improvement projects and parks partnerships.
TOTAL NET POSITION - BEGINNING 96,563,170.00$
TOTAL NET POSTION - ENDING 100,494,252.00$
45
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,163,934.00$ 49,863,934.00$ (3,300,000.00)$ -6.21%Unfav - Reimbursement Salaries ($3,000,000) due to unallocated
payroll charges for turnover and vacant positions, offset in Salaries
and Fringes. Unfav - Reimbursement General ($500,000) a result of
charging less time than anticipated to special revenue and
proprietary funds that can be allocated to benefiting systems. Fav -
Rebilled Charges $100,000 revenue is determined by a increase in
rebillable repair jobs, offset by unfavorable expenses pertaining to
the repair jobs. Fav - Equipment Rental $100,000 due to under
estimate of billable hours.
Outside 310,100.00 310,100.00 310,100.00 - 0.00%
Total Revenue 53,690,814.00 53,474,034.00 50,174,034.00 (3,300,000.00) -6.17%
WATER RESOURCES COMMISSIONER
FY 2023 SECOND QUARTER REPORT
INTERNAL SERVICE FUND
COUNTY OF OAKLAND
46
ADOPTED AMENDED FY 2023 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~ ~~~~~~~~~~~~ ~~~~~~~~~~~~ ~~~~~~~~~~~~~ ~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
WATER RESOURCES COMMISSIONER
FY 2023 SECOND QUARTER REPORT
INTERNAL SERVICE FUND
COUNTY OF OAKLAND
OPERATING EXPENSES $56,450,645.00 $56,233,865.00 $52,986,515.00 $3,247,350.00 5.77%Fav - Salaries and Fringes $3,000,000 due to turnover and vacant
positions. Fav - Depreciation Computer Software $220,000 due to
the Supervisory Control and Data Acquisition (SCADA) system
common to all project not being booked in second quarter FY 2023.
Fav - Indirect Costs $20,000 due to indirect cost rate finalized after
budget process. Fav - Computer Supplies $7,000 the result of actual
spending being less than anticipated budget. Fav - Rent $6,050
terminated the rental agreement and removed the (SCADA)
equipment from the radio tower. Unfav - Adjustment Prior Years
Expense ($37,000) due to invoicing that should have been accrued
in FY 2022. Unfav - Equipment Rental Expense ($19,200) the result
of increased use in specialty equipment needed for maintenance
projects. Unfav - Natural Gas ($3,500) the result of actual spending
being more than anticipated budget. Unfav - Charge Card Fee
($3,000) due to fees for processing on-line permit payments.
NET INCOME (LOSS) BEFORE ($2,759,831.00) ($2,759,831.00) ($2,812,481.00) ($52,650.00) 1.91%
NON-OPERATING REVENUE/(EXPENSE) $212,600.00 $212,600.00 $279,397.00 66,797.00 31.42%Fav - Prior Years Adjustment $37,197 due to an adjustment for
assets purchased and placed in service in FY 2023. Fav - Income
from Investment $21,800 due to investment base and market rate
fluctuations. Fav - Sale Of Equipment $7,000 due to equipment
being sold at the Oakland County auction.
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,596,503.00) $14,147.00
47
ADOPTED AMENDED FY 2023 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~ ~~~~~~~~~~~~ ~~~~~~~~~~~~ ~~~~~~~~~~~~~ ~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
WATER RESOURCES COMMISSIONER
FY 2023 SECOND QUARTER REPORT
INTERNAL SERVICE FUND
COUNTY OF OAKLAND
TOTAL NET POSITION - BEGINNING 34,139,228.83$
TOTAL NET POSITION - ENDING 31,542,725.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.
48
COUNTY OF OAKLAND
FY 2023 SECOND 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,869,561.00 78,500.00 1.32% - Fav. Salaries and Fringe Benefits $137,217 due to two vacant
positions, partially offset by unfav. Indirect Costs ($41,336)
due to actual charges determined after budget finalization,
Prior year adjustments ($13,400) due to invoices submitted
after year-end and ($4,000) Employee Medical Exams due to
increased testing.
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,229,561.00 78,500.00 0.84%
OPERATING INCOME (LOSS)(79,728.00) (79,728.00)(1,228.00)78,500.00 -98.46%
NON-OPERATING REVENUE (EXPENSE) 150,000.00 150,000.00 75,000.00 (75,000.00) -50.00% - Unfav. due to lower than expected available cash balance.
NET REVENUES OVER/(UNDER)*
EXPENSES $ 70,272.00 $ 70,272.00 73,772.00 $ 3,500.00
TOTAL NET ASSETS - BEGINNING 334,946.59
TOTAL NET ASSETS - ENDING $ 408,718.59
49
COUNTY OF OAKLAND
FY2023 SECOND 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 - 0.00%
RETIREMENT ADMINISTRATION 4,437,337 4,437,337 4,361,860 (75,477) -1.70% -Unfav. due to actual revenues less than budget projections.
RETIREMENT ADMINISTRATION - PTNE 350,000 350,000 172,500 (177,500) -50.71% -Unfav. due to actual revenues less than budget projections.
DEFERRED COMPENSATION-MATCH 4,500,000 4,500,000 4,500,000 - 0.00%
DEFINED CONTRIBUTION PLAN 24,000,000 24,000,000 24,000,000 - 0.00%
DEFINED CONTRIBUTION PLAN - PTNE 200,000 200,000 200,000 - 0.00%
EMPLOYEE IN-SERVICE TRAINING 1,872,722 1,872,722 1,872,722 - 0.00%
EMPLOYEE BENEFITS UNIT 1,328,644 1,328,644 1,328,644 - 0.00%
EMPLOYEE RECOGNITION 275,028 275,028 275,028 - 0.00%
FLEX BENEFIT PLAN 85,000 85,000 85,000 - 0.00%
WELLNESS UNIT 521,800 521,800 521,800 - 0.00%
FRINGE BENEFITS 132,702 132,702 132,702 - 0.00%
TUITION REIMBURSEMENT 400,000 400,000 400,000 - 0.00%
RETIREMENT HEALTH SAVINGS 3,800,000 3,800,000 4,929,200 1,129,200 29.72% -Fav. due to actual revenue higher than budget projections.
GROUP LIFE INSURANCE 680,000 680,000 590,000 (90,000) -13.24% -Unfav. due to actual revenue less than budget projections.
SOCIAL SECURITY 21,168,500 21,168,500 21,168,500 - 0.00%
MEDICAL INSURANCE 39,946,197 39,946,197 35,000,000 (4,946,197) -12.38% -Unfav. due to actual revenue less than budget projections.
PRESCRIPTION COVERAGE INSURANCE 13,000,000 13,000,000 9,640,200 (3,359,800) -25.84% -Unfav. due to actual revenue less than budget projections.
DENTAL INSURANCE 3,305,000 3,305,000 3,644,100 339,100 10.26% - Fav. due to actual revenue higher than budget projections.
VISION INSURANCE 98,500 98,500 328,700 230,200 233.71% -Fav. due to actual revenue more than budget projections.
DISABILITY INSURANCE 4,200,000 4,200,000 3,924,400 (275,600) -6.56% - Unfav. due to actual revenue less than budget projections, partially offset by favorable
Disability Insurance expense.
WORKERS COMPENSATION 3,342,722 3,342,722 2,585,000 (757,722) -22.67% -Unfav. due to lower costs associated with Workers Compensation claims.
UNEMPLOYMENT COMPENSATION 300,000 300,000 300,000 - 0.00%
INVESTMENT INCOME 1,500,000 1,500,000 1,500,000 - 0.00%
EXT - DENTAL INSURANCE 20,000 20,000 20,000 - 0.00%
EXT - FLEX BEN ARREARAGES - - - - 0.00%
EXT - FLEX BEN DENTAL INSURANCE 175,000 175,000 175,000 - 0.00%
EXT - FLEX BEN LIFE INSURANCE 520,000 520,000 520,000 - 0.00%
EXT - FLEX BEN MEDICAL - EMPLOYEE 5,333,000 5,333,000 5,591,000 258,000 4.84% -Fav. due to actual revenue more than budget projections.
EXT - FLEX BEN VISION INSURANCE 150,000 150,000 150,000 - 0.00%
EXT - FORFEITURE OF DEPOSITS & DC PLAN - - - - 0.00%
EXT - MEDICAL INSURANCE 180,000 180,000 456,300 276,300 153.50% -Fav. due to projected revenues more than budget projections.
EXT - PRESCRIPTION DRUG REBATES 2,000,000 2,000,000 3,800,000 1,800,000 90.00% -Fav. due to projected revenues more than budget projections.
EXT - TRAINING & WELLNESS 20,000 20,000 20,000 - 0.00%
EXT - VISION INSURANCE 1,500 1,500 1,500 - 0.00%
PRIOR YEARS ADJUSTMENTS - - - - 0.00%
REFUND PRIOR YEARS EXPENDITURE - - - - 0.00%
TOTAL REVENUE 171,844,782 171,844,782 166,195,286 (5,649,496) -3.29%
50
COUNTY OF OAKLAND
FY2023 SECOND 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 - 0.00%
RETIREMENT ADMINISTRATION 1,013,049 1,013,049 916,400 96,649 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 - 0.00%
DEFINED CONTRIBUTION PLAN 24,000,000 24,000,000 24,000,000 - 0.00%
DEFINED CONTRIBUTION PLAN - PTNE 200,000 200,000 200,000 - 0.00%
EMPLOYEE IN-SERVICE TRAINING 1,500,503 1,500,503 1,100,000 400,503 133.50% -Fav. due to lower than expected training costs.
IN-SERVICE TRAINING - INFO TECH 300,000 300,000 150,000 150,000 240.00% -Fav. due to lower than expected IT training costs.
PROFESSIONAL SERVICES 62,500 62,500 62,500 - 0.00%
BENEFITS ADMINISTRATION 208,741 208,741 208,741 - 0.00%
EMPLOYEE BENEFITS UNIT 1,216,587 1,216,587 842,600 373,987 30.74% -Fav. Salaries and Fringes $373,987 due to vacant positions.
FLEXIBLE BENEFIT PAYMENTS 85,000 85,000 85,000 - 0.00%
WELLNESS PROGRAM 521,744 525,094 525,094 - 0.00%
EMPLOYEE RECOGNITION 269,694 269,694 269,694 - 0.00%
ACCOUNTING SERVICES 132,937 132,937 132,937 - 0.00%
TUITION REIMBURSEMENT 400,000 400,000 400,000 - 0.00%
RETIREMENT HEALTH SAVINGS 3,800,000 3,800,000 3,800,000 - 0.00%
GROUP LIFE INSURANCE 1,200,000 1,200,000 1,200,000 - 0.00%
SICK AND ANNUAL LEAVE CASH-OUT 3,660,000 3,660,000 3,660,000 - 0.00%
SOCIAL SECURITY 21,168,500 21,168,500 21,168,500 - 0.00%
MEDICAL INSURANCE 51,050,000 51,050,000 51,050,000 - 0.00%
PRESCRIPTION COVERAGE 15,000,000 15,000,000 15,000,000 - 0.00%
DENTAL INSURANCE 3,500,000 3,500,000 3,500,000 - 0.00%
VISION INSURANCE 250,000 250,000 250,000 - 0.00%
DISABILITY INSURANCE 4,200,000 4,200,000 4,000,000 200,000 4.76% - 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,800 176,441 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 - 0.00%
CHILD CARE FACILITY 301,838 301,838 301,838 - 0.00%
HEALTH INSURANCE PREMIUM TAX - - - -
MICHIGAN IPAA TAX 15,000 15,000 15,000 -
PATIENT CENTERED OUTCOME RESEARCH 28,000 28,000 28,000 - 0.00%
INDIRECT COSTS 260,000 260,000 131,300 128,700 49.50% -Fav. due to projected charges developed after budget finalization.
PENALTIES - - - -
TOTAL EXPENSE 147,911,464 147,981,814 146,455,534 1,526,280 1.03%
NET REVENUE OVER/(UNDER) EXPENSES 23,933,318.00 23,862,968.00 19,739,752 (7,175,776)
TOTAL NET ASSETS - BEGINNING 386,553,155
TOTAL NET ASSETS - ENDING 406,292,907
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}
51
COUNTY OF OAKLAND
FY 2023 SECOND 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,802,375.00 $6,086,600.00 $284,225.00 4.90% -Fav. Land Lease $100,000 due to higher than anticipated tenants. Reimb US Customs
Service $100,000 due to higher than anticipated international travel and changes in
Custom fee processing. T Hangar Rental $45,625 due to higher than anticipated rentals.
Aviation Gas $20,000 due to higher than anticipated usage.
OPERATING EXPENSE 7,073,309.00 7,253,309.00 7,405,839.00 (152,530.00) -2.10% -Unfav. Ground Maintenance $60,000 due to higher than anticipated mulching and
vegatation treatments. Water and Sewage Charges $20,000 due to higher than
anticipated charges. Info Tech Development $25,400 due to higher than anticipated
hours on system software upgrade. Electrical Service $14,900 due to higher than
anticipated electrical repairs. Electrical Supplies $11,400 due to higher than anticipated
supply needs.
NET OPERATING INCOME (LOSS) ($1,420,934.00) ($1,450,934.00) ($1,319,239.00)$131,695.00 -9.08%
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,300,934.00) ($1,169,239.00)131,695.00 -10.12%
TRANSFERS IN
TRANSFERS OUT - - - -
CAPITAL CONTRIBUTION - - 70,000.00 70,000.00 0.00% -Fav. Capital Contributions - Federal Grant $70,000 for capital grants shoud have been
received in FY 2022 but received in FY 2023.
TOTAL NET INCOME (LOSS)($1,270,934.00)($1,300,934.00)($1,099,239.00)$201,695.00
TOTAL NET ASSETS - BEGINNING 77,506,069.73$
TOTAL NET ASSETS - ENDING 76,406,830.73$
52
COUNTY OF OAKLAND
FY 2023 SECOND QUARTER FORECAST
INTERNAL SERVICE FUNDS
FACILITIES
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,295,073.00 8,923,873.00 (371,200.00) -3.99% -Unfav. Leased Equipment ($475,000) due to actual activity trends to date and also
attributed to the delay in new product delivery, Parts and Accessories ($35,000) due
to delayed delivery of FY 2023 vehicles, Productive Labor ($34,000) due to less than
anticipated charges and Sublet Repairs ($30,000) due to decreased repairs to
department owned vehicles, partially offset by favorable Gasoline, Oil & Grease
Charges $202,800 due to current fuel costs (partially offset by unfavorable Gasoline
expense).
Total Revenue 9,123,108.00 9,425,073.00 9,053,873.00 (371,200.00)
OPERATING EXPENSE 10,010,769.00 10,239,253.00 10,578,353.00 (339,100.00) -3.31% -Unfav. Gasoline Charges ($200,000) due to market fluctuations and miles driven
(offset by favorable Gasoline, Oil Grease Charges revenue), Parts and Accessories
($74,000) due to the cost of parts increasing and Indirect Costs ($65,100) due to the
development of actual charges after budget finalization.
OPERATING INCOME (LOSS) (887,661.00) (814,180.00) (1,524,480.00) (710,300.00)
NON-OPERATING REVENUE
(EXPENSE)
542,700.00 542,700.00 842,700.00 300,000.00 55.28% -Fav. Income $300,000 due to higher than anticipated Gain on Sale of Vehicles due
to abnormally high used vehicle values.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (344,961.00) (271,480.00) (681,780.00) (410,300.00)
TRANSFERS IN / (OUT)421,151.00 785,407.00 785,407.00 - 0.00%
CAPITAL CONTRIBUTIONS - - - -
NET REVENUE OVER/(UNDER)
EXPENSES (PLANNED USE OF
FUND BAL.) *
76,190.00$ 513,927.00$ 103,627.00$ (410,300.00)$
TOTAL NET ASSETS - BEGINNING 12,061,250.24$
TOTAL NET ASSETS - ENDING 12,164,877.24$
6/7/2023
53
FY 2023 SECOND 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$ 548,363.00$ 10,000.00$ 1.86%Fav. Ext- Other Revenue $35,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,490,728.00 (25,000.00) -0.09%Unfav. $25,000 primarily due to Maintenance Dept Charges based on
Department requests.
Total Revenue 28,054,091.00$ 28,054,091.00$ 28,039,091.00$ (15,000.00)$ -0.05%
OPERATING EXPENSES 30,924,598.00$ 30,780,343.00$ 29,470,343.00$ 1,310,000.00$ 4.26%Fav. Salaries and Fringe Benefits $1,850,000 due to turnover, underfilled
and vacant positions; Electrical Service $325,000 due to lower-cost third-
party contracts and savings from FM&O energy conservation initiatives;
Water & Sewage Charges $275,000 as well as Garbage and Rubbish
Disposal $50,000 based on actual usage; Material and Supplies $150,000
as well as Security Supplies $50,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 $60,000 due to delay in upgrading software; Fuel Oil $50,000
due to lack of supply in low sulfur fuel; Road Salt $50,000 based on
operation efficiencies using brine solution.
Partially offset by unfav. Sublet Repairs ($1,000,000) due to increase in
demand for critical repair work needs, contractor price increases, and aging
infrastructure; Maintenance Supplies ($350,000) as well as Grounds
Supplies ($50,000) based on increased use of materials for services
performed internally, aging equipment, and product price increases; Natural
Gas ($275,000) due to current market conditions.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (2,870,507.00)$ (2,726,252.00)$ (1,431,252.00)$ 1,295,000.00$
NON-OPERATING REVENUE 140,000.00$ 140,000.00$ 110,000.00$ (30,000.00)$ -21.43%Unfav. Income from Investments due to investment base and market rate
adjustments.
TRANSFERS IN -$ -$ -$ -$ 0.00%
TRANSFERS OUT -$ -$ (17,393.00)$ (17,393.00)$ 0.00%Unfav. due to vehicle equipment upgrade.
NET REVENUES OVER(UNDER)
EXPENSES*(2,730,507.00)$ (2,586,252.00)$ (1,338,645.00)$ 1,247,607.00$
TOTAL NET POSITION - BEGINNING 8,635,092.51$
TOTAL NET POSITION - ENDING 7,296,447.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
54
FY 2023 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2023 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,591,925.00$ 6,700.00$ 0.26% -Fav. Outside Agencies due to higher than anticipated usage
Inside 34,561,125.00 34,580,871.00 36,132,971.00 1,552,100.00 4.49% - Fav. OC Depts Operations & Non Governmental Operations $902,200 and
OC Depts Development Support & Non Governmental Development
$643,200 due to increased rates and FOIA Fees $6,700 due to lower than
anticipated costs.
TOTAL OPERATING REVENUE 37,146,350.00$ 37,166,096.00$ 38,724,896.00$ 1,558,800.00$ 4.19%
OPERATING EXPENSES 54,609,499.00 55,037,975.00 54,447,575.00 590,400.00 1.07% - Fav. Salaries and Fringes $2,799.700 due to vacanies; Exp Equipment
$1,184,100 for equip replacement; Internal Services $297,000 is primarily
due to fav. Insurance Fund; Garbage & Rubbish Disposal $5,900,
Membership Dues $3,500 and Auction $1,400 due to usage. Offset by unfav.
Professional Services ($2,065,500) due to projects previously approved in
prior year; Charge Card Fees ($563,300) and Bank Charges ($20,800) for
credit card activity; Parts and Accessories ($327,800) and Communications
($78,600) due to higher than anticipated costs; Contracted Services
($180,600),Indirect Costs ($215,200), Equipment Maintenance ($173,500),
Maintenance Contracts ($63,000) and Supplies ($2,200) due to increased
activity; Depreciation ($11,300) based on depreciation schedule.
.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (17,463,149.00)$ (17,871,879.00)$ (15,722,679.00)$ 2,149,200.00$ -12.03%
NON-OPERATING REVENUE 70,500.00$ 70,500.00$ 70,500.00$ -$ 0.00%
TRANSFERS IN 7,921,944.00$ 8,468,169.00$ 8,468,169.00$ -$ 0.00%
TRANSFERS (OUT)-$ -$ -$ -$ 0.00%
CAPITAL CONTRIBUTION -$ -$ -$ -$ 0.00
NET REV OVER(UNDER) EXP*(9,470,705.00)$ (9,333,210.00)$ (7,184,010.00)$ 2,149,200.00$
TOTAL NET POSITION - BEGINNING 43,884,644.55$
TOTAL NET POSITION - ENDING 36,700,634.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)
55
FY 2023 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2023 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$ 6,400.00$ (5,600.00)$ -46.67%Unfav. Sale of Phone External due to decreased usage of land lines.
Inside 3,595,361.00 3,595,361.00 4,043,861.00$ 448,500.00$ 12.47% Fav. Sale of Phone due to cell phone usage.
TOTAL OPERATING REVENUE 3,607,361.00$ 3,607,361.00$ 4,050,261.00$ 442,900.00$ 12.28%
OPERATING EXPENSES 3,601,223.00$ 3,601,223.00$ 4,553,623.00$ (952,400.00)$ -26.45%Unfav. Communications ($1,674,600) and Maintenance Equipment (244,100)
due to higher than anticipated cost; Internal Services ($60,600) primarily due
to Info Tech Operations ($14,900) and Telephone ($45,900) based on actual
usage; Indirect Cost ($60,800) due to actual charges being developed after
budget finalization. Partially offset by fav. Contracted Services $988,700 and
Equipment Repairs and Maintenance $1,900; due to less than anticipated
activity; Expendable Equipment $55,600 for equipment replacement; Sublet
Repairs $34,100 due to lower than anticipated repair volume; Fav. Salaries &
Fringes $7,400 due to less than anticipated overtime.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS 6,138.00$ 6,138.00$ (503,362.00)$ (509,500.00)$
NON-OPERATING REVENUE 30,000.00$ 30,000.00$ 30,000.00$ -$ 0.00%
TRANSFERS IN -$ -$ -$ -$ 0.00%
CAPITAL CONTRIBUTION -$ -$ -$ -$ 0.00%
TRANSFERS (OUT)-$ -$ -$ -$ 0.00%
NET REV OVER(UNDER) EXP*36,138.00$ 36,138.00$ (473,362.00)$ (509,500.00)$
TOTAL NET POSITION - BEGINNING 2,119,432.74$
TOTAL NET POSITION - ENDING 1,646,070.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)
56
FY 2023 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2023 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,331,430.00$ 81,300.00$ 1.55% Fav. In-Car Terminals (External) $26,000 for fleet of CLEMIS agencies;
Access Fees Non Oakland $24,900 due to updated law enforcement Full
Time Equivalent count used for billing. Also fav. CLEMIS Crash $45,400 due
to increased usage by Oakland and non-Oakland agencies. Partially offset by
unfav. CLEMIS Citation ($10,600),Crime Mapping ($1200), Parts and
Accessories ($2,500) and CLEMIS Parking ($700) due to decreased activity.
Inside 1,776,737.00 1,782,936.00 1,705,436.00 (77,500.00)$ -4.35% Unfav. Reimb General ($60,100) based on actuals for CLEMIS staff
supporting Sheriff project; In-Car Terminal ($14,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,033,066.00$ 7,036,866.00$ 3,800.00$ 0.05%
OPERATING EXPENSES 12,538,963.00$ 12,538,963.00$ 11,360,463.00$ 1,178,500.00$ 9.40% Fav. Depreciation $1,493,600 based on depreciation schedule; Salaries and
Fringes $765,800 due to vacanies and Indirect Cost $17,500. Offset by
unfav. Internal Services ($117,900) primarily due to IT Development and
Small Tools $1,000 due to usage; Software Rental ($168,000) due to
decreased costs; Professional Services ($390,500) and Contracted Services
$167,500 due to higher than anticipated contractual costs for staffing
services. Also, unfav. Rebillable Services ($253,500) based on actual
connectivity costs to Tier 2.5.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (5,512,096.00)$ (5,505,897.00)$ (4,323,597.00)$ 1,182,300.00$
NON-OPERATING REVENUE 35,000.00$ 35,000.00$ 35,000.00$ -$ 0.00%
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,826,711.00)$ (2,644,411.00) 1,182,300.00$
TOTAL NET POSITION - BEGINNING 7,596,587.24
TOTAL NET POSITION - ENDING 4,952,176.24
57
FY 2023 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2023 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,398,200.00$ 132,600.00$ 1.43% Fav. Antenna Site Mgmt. $125,000 due to updates in rental contracts and
Outside Agency Revenue $7,600 due to lower non-emergency agencies than
anticipated.
Inside 491,829.00$ 491,829.00$ 365,329.00$ (126,500.00)$ -25.72% Unfav. Parts and Accessories ($115,500) and Productive Labor ($10,900)
due to lower than anticpated reimbursement by participating agencies for
equipment replacement.
TOTAL OPERATING REVENUE 9,757,429.00$ 9,757,429.00$ 9,763,529.00$ 6,100.00$ 0.06%
OPERATING EXPENSES 10,911,243.00$ 11,410,167.00$ 11,728,567.00$ (318,400.00)$ -2.79% Unfav. Exp Equipment ($599,200) for equipment replacement; Tower
Charges ($97,100); Software Support Maintenance ($257,000) due to timing
of Emergency Services lP Network Project; Indirect Costs ($12,500), Special
Projects ($5,600), Supplies ($2,900) and Freight Express ($3,500) due to
usage. Partially offset fav. Salaries and Fringes $314,200 dued to vacanies;
Professional Services $227,200 due to decreased costs; Travel and
Conference $22,200 due to less travel to conferences; Internal Services
$73,800 primarily due to Info Tech CLEMIS, Parts and Accessories $15,500
and Electrical Service $6,200 lower than anticipated usage.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (1,153,814.00)$ (1,652,738.00)$ (1,965,038.00)$ (312,300.00)$
NON-OPERATING REVENUE 100,000.00$ 100,000.00$ 100,000.00$ -$ 0.00%
TRANSFERS IN 24,000.00$ 610,924.00$ 610,924.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,227,814.00)$ (1,540,114.00)$ (312,300.00)$
TOTAL NET POSITION - BEGINNING 46,911,499.18$
Information Technology - Radio Communications (53600)
58
FY 2023 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2023 VARIANCE
BUDGET BUDGET Actual FAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCESBUDGETBUDGETFORECASTFAV/(UNFAV)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
TOTAL NET POSITION - ENDING 45,371,385.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$ 928,097.00$ 179,500.00$ 16.21% Fav. Deprec $263,700 due to timing; Salaries and Fringes $142,100 due to
vacanies and Professional Services $21,900 due to decreased activity.
Partially offset by unfav. Internal Services ($246,100) primarily due to IT
Development; Indirect Costs ($1,800) and Software Maintenance ($300).
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (761,302.00)$ (761,302.00)$ (581,802.00)$ 179,500.00$
NON-OPERATING REVENUE 3,000.00$ 3,000.00$ 3,000.00$ -$ 0.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)$ (74,191.00)179,500.00
TOTAL NET POSITION - BEGINNING 1,399,590.62$
TOTAL NET POSITION - ENDING 1,325,399.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.
59
Receipt Number Amount Journal Number
1/1/2023 Traci Garnett 88368 $5.00 CS008545
1/1/2023 Jennifer Orfgen 88440 $10.00 CS008545
1/1/2023 Robin Lewis 88507 $5.00 CS008545
1/1/2023 Marcio Chiarlitti 88531 $5.00 CS008545
1/2/2023 Danny Blevins 88344 $100.00 CS008545
1/2/2023 Burch 88395 $10.00 CS008545
1/2/2023 Robert Wiegmann 88404 $0.55 CS008545
1/2/2023 Kelsey Martin 88431 $0.80 CS008545
1/2/2023 Chris Turner 88432 $5.00 CS008545
1/2/2023 Kim Latuszek 88449 $0.55 CS008545
1/2/2023 Jennifer Blankenship 88451 $0.25 CS008545
1/2/2023 Eric Wessels 88459 $5.00 CS008545
1/2/2023 Charlotte Becker 88463 $5.00 CS008545
1/2/2023 Devan Liss 88472 $0.25 CS008545
1/2/2023 Lisa Pawlik 88520 $10.00 CS008545
1/2/2023 Sierra Grodsinsky 88522 $0.55 CS008545
1/2/2023 Alexis VanWormer 88526 $0.80 CS008545
1/2/2023 Dan Beaudoin 88539 $5.00 CS008545
1/3/2023 Carrie Wilkins 88412 $0.80 CS008545
1/3/2023 Diane Cornwall 88485 $5.00 CS008545
1/3/2023 Rick Lewis 88486 $5.00 CS008545
1/3/2023 Aimee Meaux 88514 $0.55 CS008545
1/3/2023 William Warden 88530 $5.00 JE009425
1/3/2023 Badiaa Hammada 88534 $1.00 JE009416
1/3/2023 Nancy Hanson 88536 $50.00 JE009425
1/3/2023 Matthew Emmenecker 88548 $0.80 CS008545
1/3/2023 Lisa Stevens 88556 $0.55 CS008545
1/3/2023 Nicole Glosser 88560 $5.00 CS008545
1/3/2023 Erika Forsyth 88564 $5.00 CS008545
1/3/2023 Eberly Brighi 88569 $10.00 CS008545
1/3/2023 Geoff McNabb 88586 $5.00 CS008545
1/3/2023 Carrie Alsheskie 88592 $20.00 CS008545
1/3/2023 Seth Schmitz 88600 $0.55 CS008545
1/4/2023 Adam Solomon 88551 $5.00 CS008545
1/4/2023 Nicole Kastanos 88579 $0.25 CS008545
1/4/2023 Jennifer Elmore 88580 $5.00 CS008545
1/4/2023 Andrew Rossier 88595 $0.25 CS008545
1/4/2023 Karen Blanchard 88601 $20.00 CS008545
1/4/2023 Tori Roney 88624 $0.80 CS008545
1/4/2023 Shenek Carrothers 88641 $0.80 CS008545
1/4/2023 Suzan Smith 88663 $10.00 CS008545
1/4/2023 Hideya Nishijima 88664 $10.00 CS008545
1/4/2023 Sharon Myatt 88665 $25.00 CS008545
1/4/2023 Van Wagner 88669 $20.00 CS008545
1/5/2023 Michael Catalano 88680 $0.80 CS008545
1/5/2023 Andrea Zimmer 88690 $5.00 CS008545
1/5/2023 Donation Box 88699 $60.00 JE009518
1/5/2023 Susan Ruma 88702 $5.00 CS008545
1/5/2023 Karpagam Raghunathan 88704 $0.80 CS008545
1/5/2023 Katherine Ross 88715 $5.00 CS008545
1/5/2023 Reina Foster 88725 $5.00 CS008545
1/5/2023 Wyatt Beyer 88739 $5.00 CS008545
1/5/2023 Morgan Bass 88740 $0.80 CS008782
1/5/2023 Jeffrey Seippel 88742 $20.00 CS008545
1/5/2023 Matthew Sherrad 88743 $5.00 CS008545
1/5/2023 Erin Faszczewski 88750 $0.55 CS008545
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
Date of Donation Person Donating
60
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
1/5/2023 Connor Weir 89081 $5.00 CS008545
1/6/2023 Andrea Carter 88727 $4,037.07 JE009519
1/6/2023 Alfred Demailo 88728 $100.00 JE009519
1/6/2023 Deborah Teasdle 88729 $200.00 JE009519
1/6/2023 Laurie Blume 88730 $25.00 JE009519
1/6/2023 Pamela Roby 88732 $20.00 JE009519
1/6/2023 North American Lighting 88736 $231.00 JE009519
1/6/2023 Jennifer Denny 88755 $0.55 CS008782
1/6/2023 Kenneth 88759 $382.00 JE009518
1/6/2023 Charitable Foundation Michigan Masonic 88760 $1,206.80 JE009518
1/6/2023 Debbie Zwolinski 88766 $10.00 CS008782
1/6/2023 Sandra Richard 88777 $0.55 CS008782
1/6/2023 Juan Arevalo 88778 $0.25 CS008782
1/6/2023 Jose Suzrez-Lopez 88780 $4.25 CS008782
1/6/2023 Kris Bussell 88784 $50.00 CS008782
1/6/2023 Nathan Kaiser 88790 $0.80 CS008782
1/6/2023 Coralyn Bailey 88818 $0.25 CS008782
1/6/2023 Nicole Fortino 88819 $10.00 CS008782
1/6/2023 Ivana Vaughn 88820 $10.00 CS008782
1/6/2023 Pamela Brubaker 88902 $0.89 CS008782
1/6/2023 Richelle Szantner 88913 $50.00 CS008782
1/6/2023 Lisa Yaldo 88917 $0.55 CS008782
1/7/2023 Amber Parker 88821 $5.00 CS008782
1/7/2023 Karen Barbash 88827 $0.80 CS008782
1/7/2023 Naomi Ishiwata 88828 $0.80 CS008782
1/7/2023 Marianne LaDuke 88877 $5.00 CS008782
1/8/2023 Robin Krugler 88811 $5.00 CS008782
1/8/2023 jason McNeilly 88841 $5.00 CS008782
1/8/2023 Steven Reid 88851 $0.55 CS008782
1/8/2023 Heather Ferow 88858 $0.80 CS008782
1/8/2023 Elizabeth Hutchinson 88859 $10.00 CS008782
1/8/2023 Rick & Yolonda Roose 88884 $5.00 CS008782
1/8/2023 Michael Gillis 88891 $10.00 CS008782
1/8/2023 Jenifer Elinski 88892 $5.00 CS008782
1/8/2023 Paul Schultz 88943 $5.00 CS008782
1/8/2023 Brandyn Hoag 88946 $5.00 CS008782
1/8/2023 Elizabeth Bourchard 88947 $0.25 CS008782
1/8/2023 Meggan M Johnson 88948 $0.80 CS008782
1/8/2023 Agustina Barry 88958 $10.00 CS008782
1/9/2023 Evan DeTone 88905 $0.25 CS008782
1/9/2023 Alexander Breuning 88906 $0.55 CS008782
1/9/2023 Ann Mathieson 88908 $10.00 CS008782
1/9/2023 Daveena Taylor 88934 $5.00 CS008782
1/9/2023 Kim Morgan 88961 $5.00 CS008782
1/9/2023 Kristen Kittell 88972 $14.25 CS008782
1/10/2023 Stephen Penny 88966 $5.00 CS008782
1/10/2023 Sophia Cordone 88983 $0.55 CS008782
1/10/2023 Kimberly Young 88994 $5.00 CS008782
1/10/2023 Todd Gilleland 88995 $5.00 CS008782
1/10/2023 Teresa Frinkle 88996 $0.80 CS008782
1/10/2023 Verne Vackaro 89010 $500.00 JE009604
1/10/2023 Michael Rutt 89013 $5.00 CS008782
1/10/2023 Monika Hall-Camilletti 89016 $5.00 CS008782
1/10/2023 John Courte 89021 $10.00 CS008782
1/10/2023 Lucky Booth 89025 $50.00 CS008782
1/10/2023 Stacey Frankovich 89037 $10.00 CS008782
1/10/2023 Caressa Armstrong 89038 $0.25 CS008782
61
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
1/10/2023 Tony D'Agostino 89245 $5.00 CS008782
1/11/2023 Briita Wanhala 89034 $10.00 CS008782
1/11/2023 Ashley Vorhes 89035 $0.80 CS008782
1/11/2023 Staci Tranter 89043 $0.25 CS008782
1/11/2023 John Scott 89052 $150.00 JE009605
1/11/2023 Debbie Palella 89064 $0.55 CS008782
1/11/2023 Howard Moore 89069 $50.00 CS008782
1/11/2023 Judy Hoste 89082 $5.00 CS008782
1/11/2023 Victoria Morton 89084 $0.47 CS008782
1/11/2023 John Battaglio 89091 $10.00 CS008782
1/11/2023 Jared Smendik 89099 $5.00 CS008782
1/11/2023 Debbie Palella 89101 $0.55 CS008782
1/11/2023 Susan Herring 89107 $10.00 CS008782
1/11/2023 Bethany Miller 89111 $0.55 CS008782
1/11/2023 Adela Adela 89117 $0.55 CS008782
1/11/2023 Braden Hayes 89127 $0.80 CS008782
1/11/2023 Barbara Stewart 89134 $10.00 CS008782
1/11/2023 Harahan Harahan 89135 $20.00 CS008782
1/12/2023 Susan Audet 89142 $10.00 CS008782
1/12/2023 Nicole Kibat 89143 $50.00 CS008782
1/12/2023 Liz Taliaferro 89161 $5.00 CS008782
1/12/2023 Haley Oliver 89163 $5.00 CS008782
1/12/2023 Joseph Jacob 89164 $10.00 CS008782
1/12/2023 Nancy Savinski 89175 $10.00 CS008782
1/12/2023 Diane Areddy 89189 $10.00 CS008782
1/12/2023 Jason Stachura 89192 $0.80 CS008782
1/12/2023 Kenneth Wilson 89197 $5.00 CS008782
1/12/2023 Megan Haase 89209 $0.55 CS008782
1/12/2023 Megan Haase 89210 $0.55 CS008782
1/12/2023 Barbara Johnston 89213 $0.80 CS008782
1/12/2023 David Swoish 89367 $0.35 CS008782
1/12/2023 Niru Sreenivasan 89373 $5.00 CS008782
1/12/2023 Tori McNaughton 89412 $5.00 CS008782
1/12/2023 Cynthia Tousignant 90001 $5.00 CS008782
1/12/2023 Cynthia Tousignant 90002 $5.00 CS008782
1/12/2023 Annette Figley 90059 $10.00 CS008782
1/13/2023 Erica Clute-Cubbin 89253 $10.00 CS008991
1/13/2023 Mary Smith 89259 $10.00 CS008991
1/13/2023 Leah Maynard 89261 $0.55 CS008991
1/13/2023 Ashley Kennard 89430 $0.55 CS008991
1/13/2023 Anita Mitton 89433 $5.00 CS008991
1/13/2023 Anita Mitton 89434 $5.00 CS008991
1/13/2023 Kelly Edelstein 89451 $0.80 CS008991
1/13/2023 Carol Kieling 89453 $10.00 CS008991
1/13/2023 Andrew Parrish 89459 $0.25 CS008991
1/13/2023 Jessica Hamilton 89461 $0.25 CS008991
1/13/2023 Jacqueline Webb 89464 $0.05 CS008991
1/13/2023 Yoshikazu Kishi 89472 $5.00 CS008991
1/13/2023 Kimberly George 89473 $20.00 CS008991
1/13/2023 Jordan Onopa 89474 $5.00 CS008991
1/13/2023 Brian Eggers 89476 $5.00 CS008991
1/14/2023 Filipe Venzon Varela 89278 $0.55 CS008991
1/14/2023 Robert McNeill 89502 $20.00 CS008991
1/14/2023 Jonathon Nichols 89504 $5.00 CS008991
1/14/2023 Marguerite DeMaria 89513 $0.55 CS008991
1/14/2023 Cynthia Ostrander 89515 $10.00 CS008991
1/14/2023 Archana Sriram 89516 $5.00 CS008991
62
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
1/15/2023 Scott Margarita 89293 $0.55 CS008991
1/15/2023 Alicia Babicz 89299 $0.10 CS008991
1/15/2023 Eric Kerr 89302 $10.00 CS008991
1/15/2023 Lisa Reid 89305 $20.00 CS008991
1/15/2023 Paul beaney 89306 $10.00 CS008991
1/15/2023 Jameson Irabon 89308 $5.00 CS008991
1/15/2023 Lena Buglak 89518 $0.80 CS008991
1/15/2023 Patricia Kaczmarek 89519 $5.00 CS008991
1/15/2023 Ted Harper 89522 $20.00 CS008991
1/15/2023 James Godden 89527 $5.00 CS008991
1/15/2023 Ashley Egan 89534 $0.80 CS008991
1/15/2023 Daniel Green 89538 $0.55 CS008991
1/15/2023 Michael Edwards 89540 $0.80 CS008991
1/16/2023 Barbara Davis 89315 $10.00 CS008991
1/16/2023 Brian Guilbault 89316 $0.55 CS008991
1/16/2023 Jian Wang 89326 $5.00 CS008991
1/16/2023 Karolyn Karl 89327 $0.55 CS008991
1/16/2023 Elizabeth DeJesus 89352 $10.00 CS008991
1/16/2023 Michael Zabel 89548 $10.00 CS008991
1/16/2023 David Dalton 89549 $0.10 CS008991
1/16/2023 Joshua Banka 89565 $5.00 CS008991
1/16/2023 Alejandra Ramirez Legorreta 89572 $1.25 CS008991
1/16/2023 Nicole Schwartzenberger 89574 $0.80 CS008991
1/16/2023 Kimberly Thompson 89581 $0.80 CS008991
1/16/2023 Leo LaBond 89586 $5.00 CS008991
1/17/2023 Marlaina Dixson 89343 $10.00 CS008991
1/17/2023 Shelby shelby 89347 $5.00 CS008991
1/17/2023 Donna Singles 89378 $25.00 JE009822
1/17/2023 Emily Fricks 89404 $0.55 CS008991
1/17/2023 Yuko Ueno 89550 $0.80 CS008991
1/17/2023 Yuko Ueno 89551 $0.55 CS008991
1/17/2023 Yuko Ueno 89552 $0.55 CS008991
1/17/2023 Danielle Zuska 89641 $0.55 CS008991
1/17/2023 Kimberly Young 89645 $20.00 CS008991
1/17/2023 Kristen Martin 89647 $0.55 CS008991
1/17/2023 Luke Brownfield 89650 $10.00 CS008991
1/18/2023 Kristi Virta 89389 $25.00 JE009797
1/18/2023 John Little 89395 $5.00 JE009797
1/18/2023 Wines For Humanity Lic 89398 $112.94 JE009797
1/18/2023 Donation Box 89401 $1.11 JE009797
1/18/2023 Steven Hanbury 89411 $5.00 CS008991
1/18/2023 Dina Graham 89416 $17.60 CS008991
1/18/2023 Eduardo Rios Ascencio 89440 $0.55 CS008991
1/18/2023 James Pitcher 89441 $1.00 CS008991
1/18/2023 Joan Floyd 89477 $5.00 CS008991
1/18/2023 Tanya Hewitt 89479 $0.55 CS008991
1/18/2023 Christen Ciaravino 89628 $8.80 CS008991
1/18/2023 Mohamed Amayem 89662 $0.31 CS008991
1/18/2023 Bruce Roth 89667 $20.00 CS008991
1/18/2023 Maria Ivezaj 89671 $0.25 CS008991
1/18/2023 Andrea Stanley 89681 $0.80 CS008991
1/18/2023 Paul Dober 89684 $5.00 CS008991
1/18/2023 Krystal Warren 89688 $0.80 CS008991
1/19/2023 Jeremy Knight 89499 $0.25 CS008991
1/19/2023 Teresa Johnston 89625 $5.00 CS008991
1/19/2023 Maical Pitts 89630 $0.55 CS008991
1/19/2023 Ashley Falls 89632 $5.00 CS008991
63
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
1/19/2023 Jason Barrett 89649 $10.00 CS008991
1/19/2023 Samantha Ingerson 89659 $0.80 CS009179
1/19/2023 Alexis Singleton 89669 $5.00 CS008991
1/19/2023 Tayler Carpenter 89704 $5.00 CS008991
1/19/2023 Angela Stillings 89713 $0.55 CS008991
1/19/2023 Francine Nesheim 89716 $0.25 CS008991
1/19/2023 Donald McClellan III 89723 $0.80 CS008991
1/19/2023 Amy Hallochak 89800 $0.55 CS008991
1/20/2023 Samantha Cabanaugh 89677 $50.00 CS009179
1/20/2023 Samantha Cabanaugh 89678 $20.00 CS009179
1/20/2023 Samantha Cabanaugh 89679 $20.00 CS009179
1/20/2023 Club Treasurers Coffee 89687 $250.00 JE009992
1/20/2023 Li Dang 89710 $200.00 JE009992
1/20/2023 Laura Walters 89722 $0.80 CS009179
1/20/2023 Mike Bauman 89724 $10.00 CS009179
1/20/2023 Sara Kauten 89727 $0.80 CS009179
1/20/2023 Mary Schuster 89771 $5.00 CS009179
1/20/2023 John Highberg 89784 $10.00 CS009179
1/20/2023 Tammy Anton 89785 $10.00 CS009179
1/20/2023 Meghan Hough 89807 $1.00 CS009179
1/20/2023 Karen Burmann 89810 $5.00 CS009179
1/20/2023 Kayla Howerton 89812 $10.00 CS009179
1/20/2023 Shaughn Murphy 89826 $0.80 CS009179
1/20/2023 Nicholas Thiel 89827 $0.55 CS009179
1/21/2023 Elizabeth Harris 89792 $20.00 CS009179
1/21/2023 Mary Staffhorst 89838 $20.00 CS009179
1/21/2023 Joseph Maniaci 89843 $50.00 CS009179
1/21/2023 Ann Rosenberger 89848 $20.00 CS009179
1/21/2023 Lindsay TerHaar 89852 $0.80 CS009179
1/21/2023 Lara Davis 89853 $0.80 CS009179
1/21/2023 Wendy Hough 89857 $5.00 CS009179
1/21/2023 Amy Walsh 89926 $10.00 CS009179
1/22/2023 Christine Smith 89796 $20.00 CS009179
1/22/2023 Robin Mackie 89799 $20.00 CS009179
1/22/2023 Jennifer Lozar 89835 $0.80 CS009179
1/22/2023 Leslie Wilson 89865 $0.80 CS009179
1/22/2023 Rashmi Rajeshwar 89874 $0.80 CS009179
1/22/2023 Naoko Araya 89885 $3.80 CS009179
1/22/2023 Minerva McParland 89887 $20.00 CS009179
1/22/2023 Jamie Van Tiem 89891 $0.55 CS009179
1/23/2023 Donation Box 89816 $78.00 JE009993
1/23/2023 Emily Kelley 89846 $5.00 CS009179
1/23/2023 Nelson Hersh 89859 $40.00 JE009992
1/23/2023 Michelle Daigle 89893 $0.80 CS009179
1/23/2023 Cassidy Gordon 89897 $0.55 CS009179
1/23/2023 Michael Robertson 89901 $10.00 CS009179
1/23/2023 Lat Diop 89909 $20.00 CS009179
1/23/2023 Emma Sanchez 89914 $0.80 CS009179
1/23/2023 Tiffany Sherwood 89917 $5.00 CS009179
1/23/2023 Lindsay TerHaar 89918 $0.55 CS009179
1/23/2023 Kristina Dunne 89932 $20.00 CS009179
1/23/2023 Deanne Brown 89940 $5.00 CS009179
1/23/2023 Nancy Burdick 89943 $10.00 CS009179
1/24/2023 Ester Lacy 89980 $50.00 JE010123
1/24/2023 Mary Bochenek 89981 $70.00 JE010123
1/24/2023 Anna Brunsch 89982 $200.00 JE010123
1/24/2023 Thomas Collier 89983 $100.00 JE010123
64
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
1/24/2023 Blake Cawley 89984 $225.00 JE010123
1/24/2023 Elissa Staeuble 89985 $25.00 JE010123
1/24/2023 Donation Box 89992 $3.27 JE010123
1/24/2023 Breanna Howey 89994 $0.25 CS009179
1/24/2023 Hugo Anaya 90009 $5.00 CS009179
1/24/2023 Karen Gietzen-Stewart 90060 $5.00 CS009179
1/24/2023 Erica Jagotka 90069 $5.00 CS009179
1/25/2023 Janet Korth 90076 $5.00 CS009179
1/25/2023 Rhonda Mohlman 90093 $100.00 CS009179
1/25/2023 Alexis MacDonald 90098 $0.55 CS009179
1/25/2023 Jovanni Gutierrez 90099 $0.25 CS009179
1/25/2023 Jovanni Gutierrez 90100 $0.25 CS009179
1/25/2023 Kendall Wochoski 90118 $5.00 CS009179
1/25/2023 Jennifer Varas 90478 $0.80 CS009179
1/26/2023 Debra Horning 90046 $100.00 JE010279
1/26/2023 Holly Manshum 90082 $5.00 CS009370
1/26/2023 Jamal Khaffaf 90120 $5.00 CS009370
1/26/2023 Anthony Grievo 90134 $5.00 CS009370
1/27/2023 April Myzienski 90139 $9.55 CS009370
1/27/2023 Stephanie Howe 90145 $35.00 JE010279
1/27/2023 Jacob Brzezinski 90168 $350.00 JE010280
1/27/2023 Jonathan Balsavich 90186 $0.80 CS009370
1/27/2023 Carlos Aleman Bonilla 90202 $0.55 CS009370
1/27/2023 Ellen Theisen 90210 $0.55 CS009370
1/27/2023 Lisa Cormier 90214 $5.00 CS009370
1/28/2023 Tricia McKinnon 90206 $0.10 CS009370
1/28/2023 Doreen Myers 90207 $10.00 CS009370
1/28/2023 Gary Rogensues 90208 $5.00 CS009370
1/28/2023 Sydni Euclide 90219 $0.55 CS009370
1/28/2023 Yvette Thrush 90228 $100.00 CS009370
1/28/2023 Jaimie Ward 90229 $0.80 CS009370
1/28/2023 Jaimie Ward 90230 $0.80 CS009370
1/28/2023 Melissa Agosta 90233 $20.00 CS009370
1/28/2023 Doug Smith 90778 $20.00 CS009370
1/29/2023 Marcia Larson 90187 $0.89 CS009370
1/29/2023 Ty Bowman 90199 $5.00 CS009370
1/29/2023 Linda Barnett 90209 $5.00 CS009370
1/29/2023 Steven Abitheira 90237 $0.25 CS009370
1/29/2023 Christopher Lata 90244 $10.00 CS009370
1/29/2023 Athan Papatheodore 90252 $10.00 CS009370
1/30/2023 Nick Oosting 90220 $0.55 CS009370
1/30/2023 Zena Makled 90236 $0.25 CS009370
1/30/2023 William Cataldo 90265 $20.00 CS009370
1/30/2023 Jackie Kochanski 90267 $0.55 CS009370
1/30/2023 Ruth Fluegge 90272 $20.00 CS009370
1/30/2023 Deb Hobson 90273 $0.80 CS009370
1/30/2023 Valerie Benjmin 90279 $30.00 JE010279
1/30/2023 Andrew Brucki 90302 $0.80 CS009370
1/30/2023 Traci Baert 90305 $5.00 CS009370
1/30/2023 Catherine Louchart 90308 $25.00 CS009370
1/30/2023 Brian Kott 90310 $5.00 CS009370
1/30/2023 Tara Vatcher 90316 $0.55 CS009370
1/31/2023 Jennifer jones 90315 $5.00 CS009370
1/31/2023 Jill Heppler 90329 $0.70 CS009370
1/31/2023 Donation Box 90330 $17.00 JE010392
1/31/2023 Mark Mudd 90338 $5.00 JE010392
1/31/2023 Yan Yu 90344 $2.00 CS009370
65
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
1/31/2023 Yan Yu 90347 $2.00 CS009370
1/31/2023 jay Erickson 90348 $0.55 CS009370
1/31/2023 Danielle Kurajian 90353 $0.80 CS009370
1/31/2023 Phillip Bockhorn 90362 $5.00 CS009370
1/31/2023 Phillip Bockhorn 90363 $5.00 CS009370
1/31/2023 Julie Ferus 90365 $8.80 CS009370
1/31/2023 Kathy Bashawaty 90366 $100.00 CS009370
1/31/2023 Marvin Ford 90369 $4.00 JE010393
1/31/2023 Robert Tomassi 90370 $0.80 CS009370
1/31/2023 Kayleigh Trudnak 90385 $0.80 CS009370
1/31/2023 Martha Skoglund 90387 $10.00 CS009370
1/31/2023 Chakravarthi Chigurupati 90392 $4.55 CS009370
1/31/2023 Keisha Nelson 90393 $100.00 CS009370
1/31/2023 Michael Downes 90411 $0.80 CS009370
1/31/2023 Lindsay Gunther 90412 $0.80 CS009370
1/31/2023 Nathan Hamood 90434 $5.00 CS009370
1/31/2023 Juliette Yanalunas 90435 $5.00 CS009370
1/31/2023 Karen Wilson 90436 $5.00 CS009370
1/31/2023 Mary Barley 90440 $0.55 CS009370
1/31/2023 Raymond Kort 90442 $0.80 CS009370
1/31/2023 Jonathan Hyde 90446 $3.80 CS009370
1/31/2023 Jolie Budd 90466 $0.55 CS009370
$11,415.45
Receipt Number Amount Journal Number
2/1/2023 Megan Pfohl 90423 $0.55 CS009725
2/1/2023 Timothy Pawlik 90448 $5.00 CS009725
2/1/2023 Samantha Hunt 90473 $5.00 CS009725
2/1/2023 Oleksandr Chaban 90475 $10.00 CS009725
2/1/2023 Andrea Drukas 90476 $10.00 CS009725
2/1/2023 Katherine Weiss 90486 $0.55 CS009725
2/1/2023 Nolan Arbour 90488 $0.80 CS009725
2/1/2023 Krystyna Frask 90491 $5.00 CS009725
2/1/2023 Edward Jones 90499 $9,656.53 JE010392
2/1/2023 Stephen Bernstein 90504 $5.00 CS009725
2/1/2023 Suzanne Rondeau 90506 $10.00 CS009725
2/1/2023 Catherine Diegel 90514 $5.00 CS009725
2/1/2023 Sherri Bolton 90523 $0.55 CS009725
2/1/2023 Lindsay Carls 90532 $0.80 CS009725
2/1/2023 Chad Posey 90533 $0.55 CS009725
2/1/2023 Chris Gumz 90544 $0.80 CS009725
2/1/2023 Vadim Glik 90546 $5.00 CS009725
2/1/2023 Eric Ward 90548 $0.25 CS009725
2/1/2023 Andrea Harding 90549 $5.00 CS009725
2/1/2023 Paula Bailey 90552 $0.55 CS009725
2/1/2023 Cindy Korycinski 90559 $5.00 CS009725
2/1/2023 Alysha Vincent 90561 $0.55 CS009725
2/1/2023 Ethel Poehlman 90563 $5.00 CS009725
2/1/2023 Barbara Woods 90565 $10.00 CS009725
2/1/2023 Michelle Blaszczak 90570 $20.00 CS009725
2/1/2023 Paul Bonfiglio 90577 $0.58 CS009725
2/1/2023 Laurie Kissoondial 90579 $5.00 CS009725
2/1/2023 Laurie Kissoondial 90580 $5.00 CS009725
2/1/2023 Susan Hayes 90581 $10.00 CS009725
2/1/2023 Michelle Fillemon 90582 $0.10 CS009725
2/1/2023 Jacqueline Bulic 90586 $1.00 CS009725
2/1/2023 Deana Derocha 90589 $5.00 CS009725
January 2023 Total
Date of Donation Person Donating
66
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
2/1/2023 Katie McGuffie 90597 $0.55 CS009725
2/1/2023 Caitlin Wing 90632 $0.55 CS009725
2/1/2023 Mark Schumm 90657 $4.55 CS009725
2/1/2023 Matt Hawkins 90666 $0.80 CS009725
2/1/2023 Rene Strzelecki 90668 $5.00 CS009725
2/1/2023 Lori Marshick 90699 $0.55 CS009725
2/1/2023 Paige Root 90709 $0.80 CS009725
2/1/2023 William Spruit 90790 $5.00 CS009725
2/1/2023 Robert Burdick 90801 $5.00 CS009725
2/2/2023 Alessia Hoey 90602 $0.55 CS009725
2/2/2023 Cheryl Mack 90649 $5.00 CS009725
2/2/2023 Bradford Wade 90651 $5.00 CS009725
2/2/2023 Michael Youga 90653 $5.00 CS009725
2/2/2023 Laura Zanini Lima 90675 $50.00 CS009725
2/2/2023 April Wagoner 90677 $0.80 CS009725
2/2/2023 Vance McCormick 90678 $50.00 CS009725
2/2/2023 Jessica Klein 90679 $10.00 CS009725
2/2/2023 Krystal George 90683 $0.80 CS009725
2/2/2023 Myrna Abundis Alge 90689 $5.00 CS009725
2/2/2023 Don Stockton 90693 $0.55 CS009725
2/2/2023 George Campbell 90695 $5.00 CS009725
2/2/2023 Charles Goodrich 90698 $0.89 CS009725
2/2/2023 Nadia Juzych 90721 $5.00 CS009725
2/2/2023 Diana Chapman 90725 $5.00 CS009725
2/2/2023 Rebecca Whittle 90726 $0.55 CS009725
2/2/2023 Jane Merritt 90727 $50.00 CS009725
2/2/2023 Adina Lesperance 90740 $5.00 CS009725
2/2/2023 James Winiarski 90745 $0.55 CS009725
2/2/2023 Cynthia Jones 90750 $20.00 CS009725
2/2/2023 Lenora M Plott 90752 $5.00 CS009725
2/2/2023 Shane Melnick 90755 $10.00 CS009725
2/2/2023 Cassandra Barclay 90760 $5.00 CS009725
2/2/2023 Mahendra Kenkre 90771 $10.00 CS009725
2/2/2023 Jennifer Karlson 90851 $50.00 CS009725
2/2/2023 Susan Kamin 90861 $5.00 CS009725
2/2/2023 Brittany Valk 90862 $0.55 CS009725
2/2/2023 Lisa Schwartz 90863 $0.25 CS009725
2/2/2023 Lori Bean 90870 $5.00 CS009725
2/2/2023 Judith Arthofer 90873 $5.00 CS009725
2/2/2023 Khristie Miller 90879 $5.00 CS009725
2/2/2023 Bevertly Maurer 90880 $10.00 CS009725
2/2/2023 Shoshana Gruber 90881 $15.45 CS009725
2/2/2023 Nigel Adkins 91159 $8.80 CS009725
2/2/2023 Sharon Altman 91167 $0.80 CS009725
2/2/2023 Ramon Lee 91239 $5.00 CS009725
2/2/2023 Karen Zanotti 91274 $0.55 CS009725
2/2/2023 Kathryn E Schulte 91278 $10.00 CS009725
2/2/2023 YUANXIN Fan 91286 $0.10 CS009725
2/2/2023 Cheryl Billery 91288 $5.00 CS009725
2/2/2023 Jeffrey Renno 91294 $20.00 CS009725
2/2/2023 Ginger Giannetti 91744 $20.00 CS009725
2/3/2023 Diane Brandt 90764 $15.00 CS009725
2/3/2023 Ian Bonner 90765 $20.00 CS009725
2/3/2023 Brandy Miller 90773 $5.00 CS009725
2/3/2023 Wanda Norris 90780 $20.00 CS009725
2/3/2023 Hollie Hodge 90787 $10.00 CS009725
2/3/2023 Susan Kozora 90788 $0.55 CS009725
67
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
2/3/2023 Mary Whitta-VanDagens 90796 $5.00 CS009725
2/3/2023 Doug Roeser 90797 $10.00 CS009725
2/3/2023 Jacqueline Stephenson 90799 $5.00 CS009725
2/3/2023 Courtney Burkett 90810 $0.55 CS009725
2/3/2023 Margaret Samberg 90832 $20.00 CS009725
2/3/2023 Matthew polzin 90842 $5.00 CS009725
2/3/2023 Oliver Gross 90848 $5.00 CS009725
2/3/2023 Jovica Bozinovski 90918 $5.00 CS009725
2/3/2023 Darren Smith 90922 $0.80 CS009725
2/3/2023 Abigale Lennox 90931 $20.00 CS009725
2/3/2023 Karen Guiboux 90938 $20.00 CS009725
2/3/2023 Karen Papacharalambous 90941 $5.00 CS009725
2/3/2023 Karen Papacharalambous 90942 $5.00 CS009725
2/3/2023 Bonnie McGraw 90956 $10.00 CS009725
2/3/2023 Andrew Seurynck 90958 $0.80 CS009725
2/3/2023 Michael McBryar 91168 $5.00 CS009725
2/3/2023 Rachel Kotila 91222 $5.00 CS009725
2/3/2023 Jennifer Anderson 91248 $0.80 CS009725
2/3/2023 Andrew Williams 91290 $0.80 CS009725
2/3/2023 Chelsea Arlington 91334 $5.00 CS009725
2/3/2023 Brendon Hash 91337 $20.00 CS009725
2/3/2023 Jason Schlaff 91338 $0.25 CS009725
2/3/2023 Lisa Pasquinelli 91353 $0.55 CS009725
2/3/2023 Lisa Pasquinelli 91354 $0.55 CS009725
2/3/2023 Keith Brotherton 91360 $10.00 CS009725
2/3/2023 Cathy Appleton 91369 $4.10 CS009725
2/3/2023 Deborah Frazee 91513 $20.00 CS009725
2/3/2023 Deborah Frazee 91514 $20.00 CS009725
2/3/2023 Rob Warner 91662 $10.00 CS009725
2/4/2023 Kari Corrington 90902 $0.55 CS009725
2/4/2023 Kelly Stakkard 90924 $10.00 CS009725
2/4/2023 Eric Austin 90954 $5.00 CS009725
2/4/2023 Elayne Peters 90959 $0.55 CS009725
2/4/2023 Sanford Mall 90962 $0.58 CS009725
2/4/2023 Mark Stevens 90964 $5.00 CS009725
2/4/2023 Elizabeth Polmear 90967 $5.00 CS009725
2/4/2023 Olivia Olsztyn-budry 90968 $5.00 CS009725
2/4/2023 Fred paredes 90987 $5.00 CS009725
2/4/2023 Paul Eland 90991 $10.00 CS009725
2/4/2023 Cory Wormmeester 90997 $5.80 CS009725
2/4/2023 Linda Rogers 91017 $20.00 CS009725
2/4/2023 MaryBeth MacDonald 91019 $5.00 CS009725
2/4/2023 Val MacFarlane 91393 $50.00 CS009725
2/4/2023 Sandra Crociata 91394 $0.55 CS009725
2/4/2023 Ryan Lindley 91402 $0.55 CS009725
2/4/2023 Kristina Doerfling 91407 $20.00 CS009725
2/4/2023 Hailey Hewitt 91410 $0.25 CS009725
2/4/2023 Erika Lafnear 91443 $0.55 CS009725
2/4/2023 Takako Taki 91444 $1.00 CS009725
2/4/2023 Sierrah Maskill 91462 $0.80 CS009725
2/5/2023 William McGrane 90912 $10.00 CS009725
2/5/2023 Lindsay Ruwart 90969 $1.00 CS009725
2/5/2023 Kathlyn Blanchard 91031 $0.80 CS009725
2/5/2023 Anna Dew 91032 $0.55 CS009725
2/5/2023 John Goch 91033 $5.00 CS009725
2/5/2023 Andrea McFarland 91034 $5.00 CS009725
2/5/2023 Bruce Sakach 91062 $10.00 CS009725
68
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
2/5/2023 David Call 91063 $20.00 CS009725
2/5/2023 Benjamin Philpot 91388 $5.00 CS009725
2/5/2023 Chris Gropp 91415 $50.00 CS009725
2/5/2023 Carol Smith 91446 $10.00 CS009725
2/5/2023 Brittany Rogers 91460 $20.00 CS009725
2/5/2023 Daniel Seikaly 91485 $5.00 CS009725
2/5/2023 Alison Nicol 91488 $0.80 CS009725
2/5/2023 Melissa Cartwright 91511 $5.00 CS009725
2/5/2023 Kimberly Thomas 91522 $3.80 CS009725
2/6/2023 Lauren Groskaufmanis 90944 $10.00 CS009725
2/6/2023 Jeff Spurr 90971 $50.00 JE010496
2/6/2023 Donation Box 90973 $70.00 JE010496
2/6/2023 Cindy Crosby 90985 $25.00 JE010496
2/6/2023 Anna Hergott 91086 $0.55 CS009725
2/6/2023 Kyle Johns 91091 $5.00 CS009725
2/6/2023 Jennifer Hughes 91096 $5.00 CS009725
2/6/2023 Jessica Johnson 91097 $0.80 CS009725
2/6/2023 Kimberly Strader 91099 $0.55 CS009725
2/6/2023 Kathy Neirynck 91106 $10.00 CS009725
2/6/2023 James Haggerty 91109 $0.55 CS009725
2/6/2023 Christina Senopole 91115 $0.55 CS009725
2/6/2023 Zesheng Zhang 91116 $0.55 CS009725
2/6/2023 Todd Moss 91131 $0.80 CS009725
2/6/2023 Jorge Paredes 91133 $20.00 CS009725
2/6/2023 Renee Colletti 91135 $10.10 CS009725
2/6/2023 Jill Smith 91138 $10.00 CS009725
2/6/2023 Vignesh Balachandran 91143 $2.00 CS009725
2/6/2023 Rhonda Shaw 91145 $5.00 CS009725
2/6/2023 Terri Krasicky 91146 $50.00 CS009725
2/6/2023 Courtney Showalter 91148 $5.00 CS009725
2/6/2023 Megan Hall 91149 $10.00 CS009725
2/6/2023 RAJA Puli 91179 $0.80 CS009725
2/6/2023 Paola Lozano 91185 $0.55 CS009725
2/6/2023 Douglas Babics 91467 $0.60 CS009725
2/6/2023 Beth McDonald 91482 $20.00 CS009725
2/6/2023 Alexandra Brinkman 91521 $0.55 CS009725
2/6/2023 Traci Daniels 91529 $50.00 CS009725
2/6/2023 Marc Miles 91531 $0.80 CS009725
2/6/2023 Alexander Saikalis 91679 $10.00 CS009725
2/6/2023 Carole DeFrancesco 91687 $0.78 CS009725
2/6/2023 Leah Marszalec 91696 $0.80 CS009725
2/6/2023 WaiShum Tse 91768 $0.89 CS009725
2/6/2023 Michael Calice 92272 $0.80 CS009725
2/6/2023 Michael Calice 92273 $0.80 CS009725
2/7/2023 Donation Box 91007 $3.71 JE010591
2/7/2023 Alfred Demailo 91009 $100.00 JE010591
2/7/2023 Rebecca Lowe 91010 $200.00 JE010591
2/7/2023 Shirley Beam 91013 $40.00 JE010591
2/7/2023 Donation Box 91014 $0.45 JE010591
2/7/2023 Joseph Niemiec 91160 $0.80 CS009725
2/7/2023 Claudia Eisenberg 91208 $10.00 CS009725
2/7/2023 Pamela Colon 91210 $10.00 CS009725
2/7/2023 Amber Saunders 91212 $0.55 CS009725
2/7/2023 Robin Odgers 91214 $10.00 CS009725
2/7/2023 Lindsay Gunther 91708 $0.55 CS009725
2/7/2023 Amy Downs 91776 $10.00 CS009725
2/7/2023 Taylor DeRousse 91777 $5.00 CS009725
69
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
2/7/2023 Alex Skelly 91781 $5.00 CS009725
2/7/2023 Itzhak Elrom 91804 $0.58 CS009725
2/8/2023 Shannon Huhta 91220 $0.55 CS009725
2/8/2023 Barb Rogers 91228 $0.80 CS009725
2/8/2023 Carole Clark 91233 $30.00 JE010591
2/8/2023 Jeremy Wilson 91238 $5.00 CS009725
2/8/2023 Susie Corpuz 91255 $0.55 CS009725
2/8/2023 Jennifer Brown 91260 $5.00 CS009725
2/8/2023 Heather Perry 91295 $7.00 JE010591
2/8/2023 Mary Harrelson 91298 $25.00 JE020614
2/8/2023 Autumn Cook 91310 $0.80 CS009725
2/8/2023 Debbie Woodfield 91311 $20.00 CS009725
2/8/2023 Caitlin Conklin 91314 $0.55 CS009725
2/8/2023 Kyle Garringer 91318 $0.80 CS009725
2/8/2023 Veronica Brueck 91319 $0.55 CS009725
2/8/2023 Sharon Walden 91321 $150.00 CS009725
2/8/2023 Angela Snider 91322 $5.00 CS009725
2/8/2023 Laura Markle 91329 $0.80 CS009725
2/8/2023 Swapna Chada 91692 $20.00 CS009725
2/8/2023 Julia Prusak 91805 $0.80 CS009725
2/8/2023 Kenji Kitano 91810 $10.00 CS009725
2/8/2023 Stephanie Moshier 91812 $0.80 CS009725
2/8/2023 Adam Hurst 91813 $0.55 CS009725
2/8/2023 Marianne Baker 91817 $0.80 CS009725
2/9/2023 Kathleen Alayan 91328 $5.00 CS009975
2/9/2023 Anthony Franceschina 91341 $0.55 CS009975
2/9/2023 Dustin Hagfors 91350 $0.80 CS009975
2/9/2023 Roseann Telling 91362 $5.00 CS009975
2/9/2023 Shane Costello 91430 $10.00 CS009975
2/9/2023 Brian McElroy 91440 $10.00 CS009975
2/9/2023 Rodrigo Andrade 91846 $0.80 CS009975
2/9/2023 Brooke Bergslien 91868 $0.80 CS009975
2/9/2023 Melissa Feldman 91910 $0.80 CS009975
2/9/2023 Melissa Feldman 91911 $0.80 CS009975
2/10/2023 Leslie McGill-Mayotte 91447 $10.00 CS009975
2/10/2023 Meghan Gezo 91453 $0.10 CS009975
2/10/2023 Ronda Pype 91456 $5.00 CS009975
2/10/2023 Rumi Kokubo 91458 $0.55 CS009975
2/10/2023 Victor Rebella 91478 $0.55 CS009975
2/10/2023 Tracy Whitman 91493 $0.80 CS009975
2/10/2023 Clairissa Scheiderer 91508 $0.10 CS009975
2/10/2023 Deborah Woodman 91593 $10.00 CS009975
2/10/2023 Mary Huffmaster 91942 $0.80 CS009975
2/10/2023 Ilyssa Cimmino 91954 $10.00 CS009975
2/10/2023 Erika Cuellar 91960 $10.00 CS009975
2/10/2023 Erika Cuellar 91961 $5.00 CS009975
2/10/2023 Allyson Edwards 92235 $5.00 CS009975
2/10/2023 Kimberly Eisenmann 92598 $0.80 CS009975
2/11/2023 Paola Meza 91581 $0.25 CS009975
2/11/2023 Marco Ruggeri 91604 $0.10 CS009975
2/11/2023 Edward Reamer 91620 $5.00 CS009975
2/11/2023 Tanya Murphy 91622 $5.00 CS009975
2/11/2023 Hamed Sadrnia 91626 $0.55 CS009975
2/11/2023 Scott Mirkes 91633 $0.10 CS009975
2/11/2023 Kendra Blocker 91635 $5.00 CS009975
2/11/2023 Daniel Gambrel 91873 $0.80 CS009975
2/11/2023 Valerie McCalvin 92244 $0.55 CS009975
70
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
2/11/2023 Gerald Wheeler 92250 $10.00 CS009975
2/12/2023 Donna Hanson 91583 $10.00 CS009975
2/12/2023 Jessica Black 91646 $0.80 CS009975
2/12/2023 Anthony Gorsick 91647 $0.80 CS009975
2/12/2023 Janet Hollandsworth 91648 $10.00 CS009975
2/12/2023 Thomas Borowiak 91680 $5.00 CS009975
2/12/2023 Sev Tringali 92319 $50.00 CS009975
2/12/2023 Alexis Hull 92344 $0.55 CS009975
2/12/2023 Aimee Butler 92470 $10.00 CS009975
2/13/2023 Carrie Brown 91681 $0.80 CS009975
2/13/2023 Carrie pardon 91750 $5.00 CS009975
2/13/2023 Patrick Whyte 91752 $5.00 CS009975
2/13/2023 Amy Diiacovo 91758 $0.80 CS009975
2/13/2023 Theira Hyttinen 91946 $0.89 CS009975
2/13/2023 Frank Carmona 92320 $3.80 CS009975
2/13/2023 Hany Nessiem 92347 $0.25 CS009975
2/13/2023 Daniel Sperling 92354 $0.55 CS009975
2/13/2023 Matthew aubert 92366 $0.80 CS009975
2/13/2023 Anamika Lasser 92368 $10.00 CS009975
2/13/2023 Sara Emmanuel 92380 $0.55 CS009975
2/13/2023 Sara Emmanuel 92381 $0.55 CS009975
2/13/2023 Iris Markham 92468 $5.00 CS009975
2/14/2023 Taylor Kearly 91770 $0.80 CS009975
2/14/2023 Paige person 91861 $0.55 CS009975
2/14/2023 Jeffrey Aleman 91874 $25.00 JE010937
2/14/2023 Zachary Hampton 91903 $10.00 CS009975
2/14/2023 Melissa Harwood 91908 $5.00 CS009975
2/14/2023 Victoria Vinogradov 92343 $8.80 CS009975
2/14/2023 Dawn Alford 92356 $0.55 CS009975
2/14/2023 Vonny Husain 92394 $0.80 CS009975
2/14/2023 Alisha Harvey-Pompa 92395 $5.00 CS009975
2/14/2023 Jenna Bartow 92399 $8.80 CS009975
2/14/2023 Martha Wale 92401 $3.80 CS009975
2/15/2023 John Little 91888 $5.00 JE010937
2/15/2023 Deeksha Agarwala 91889 $25.00 JE010937
2/15/2023 Deeksha Agarwala 91890 $25.00 JE010937
2/15/2023 Donation Box 91898 $2.84 JE010937
2/15/2023 Jason Shomo 91917 $10.00 CS009975
2/15/2023 Zak Gertlar 91923 $0.80 CS009975
2/15/2023 Shaun Toupin 91925 $5.00 CS009975
2/15/2023 Kateri McCleery 91969 $50.00 JE010937
2/15/2023 Kim Wisniewski 91976 $200.00 JE010938
2/15/2023 Nicole Oliver 92055 $1.00 CS009975
2/15/2023 Lawrence Sesi 92058 $0.80 CS009975
2/15/2023 Emily Douglas 92061 $20.00 CS009975
2/15/2023 Rejane Sawada Guiguer 92065 $10.00 CS009975
2/15/2023 Katie DeCarolis 92419 $0.55 CS009975
2/15/2023 Matt Wu 92428 $0.55 CS009975
2/15/2023 Matt Wu 92429 $0.55 CS009975
2/15/2023 Deborah Mast 92435 $20.00 CS009975
2/15/2023 Lisa Stohrer 92579 $3.80 CS009975
2/15/2023 Carol Bertrand 92584 $5.00 CS009975
2/16/2023 Anthony Sinagra 92091 $0.10 CS009975
2/16/2023 Corey Greenfield 92094 $50.00 CS009975
2/16/2023 Lisa Betman 92098 $0.55 CS009975
2/16/2023 Alicia Hubbard 92432 $0.55 CS009975
2/16/2023 Emily Roland 92559 $0.80 CS009975
71
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
2/16/2023 Michele Sylvester 92602 $0.80 CS009975
2/16/2023 Rachel Hockey 92604 $0.80 CS009975
2/16/2023 Devan Papke 92622 $5.00 CS009975
2/16/2023 Tracy Corrigan 92625 $0.90 CS009975
2/16/2023 Justin Bojan 92626 $10.00 CS009975
2/16/2023 Sai Ramprasad Rajagopalan 92627 $0.25 CS009975
2/16/2023 Heather Meloche 92629 $0.80 CS009975
2/17/2023 Kylee Gallero 92048 $0.80 CS010405
2/17/2023 Tina Emiry 92056 $0.60 CS010405
2/17/2023 Lou Dauzy 92177 $5.00 CS010405
2/17/2023 Stacie Kaiser 92227 $5.00 CS010405
2/17/2023 Katheryn Hansen 92635 $5.00 CS010405
2/17/2023 Ryan Horrocks 92641 $0.55 CS010405
2/17/2023 Todd Miller 92648 $5.00 CS010405
2/17/2023 Virginia LeGwen 92650 $20.00 CS010405
2/17/2023 Nathan Sheffer 92652 $0.80 CS010405
2/17/2023 Tetsuya Yamaguchi 92654 $5.00 CS010405
2/18/2023 Brian Hill 92206 $0.55 CS010405
2/18/2023 Breanne Rrumbullaku 92210 $5.00 CS010405
2/18/2023 Joan Hoffman 92211 $10.00 CS010405
2/18/2023 Tammara Sand 92659 $10.00 CS010405
2/18/2023 Tonya Taylor 92660 $20.00 CS010405
2/18/2023 John Yehle 92661 $0.60 CS010405
2/18/2023 Melody Norman 92667 $0.55 CS010405
2/19/2023 Amy Sabo 92049 $0.55 CS010405
2/19/2023 John Stowe 92220 $5.00 CS010405
2/19/2023 Laura Kyriakopoulos 92651 $0.35 CS010405
2/19/2023 Nicole Cox 92689 $0.80 CS010405
2/19/2023 Rachelle Hoover 93390 $0.55 CS010405
2/20/2023 Robert Neely 92080 $0.55 CS010405
2/20/2023 Angela Watene 92157 $20.00 CS010405
2/20/2023 Laura Saneholtz 92164 $0.25 CS010405
2/20/2023 Jessica Buck 92167 $5.00 CS010405
2/20/2023 Patrick Johns 92178 $5.00 CS010405
2/20/2023 Marla Otterbacher 92190 $5.00 CS010405
2/20/2023 Katie Hubbell 92197 $8.80 CS010405
2/20/2023 Curt Beyerlein 92199 $0.80 CS010405
2/20/2023 Kaitlyn Lambregtse 92225 $0.80 CS010405
2/20/2023 David Miller 92321 $20.00 CS010405
2/20/2023 Elizabeth Jenuwine 92681 $0.80 CS010405
2/20/2023 Vanesa Muratovic 92741 $10.00 CS010405
2/20/2023 Robert Gutsche 92743 $0.55 CS010405
2/20/2023 Sarah Cubr 92753 $0.55 CS010405
2/20/2023 Sarah Cubr 92754 $0.55 CS010405
2/20/2023 Leslie Smith 92755 $10.00 CS010405
2/20/2023 Steven Grindling 92761 $10.00 CS010405
2/20/2023 Mary Mitchelle 92762 $5.00 CS010405
2/21/2023 Tracy Phillips 92081 $20.00 CS010405
2/21/2023 Peter Shillingford 92113 $20.00 CS010405
2/21/2023 Alex DeFrenza 92139 $5.00 CS010405
2/21/2023 Susan Stevens 92145 $5.00 CS010405
2/21/2023 Wendi James 92180 $20.00 CS010405
2/21/2023 Evan Meriwether 92185 $5.00 CS010405
2/21/2023 Lisa Barnett 92187 $5.00 CS010405
2/21/2023 Patti Harpenau 92188 $20.00 CS010405
2/21/2023 Linda Golding 92714 $5.00 CS010405
2/21/2023 Samuel Bookmyer 92806 $5.00 CS010405
72
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
2/21/2023 David Grant 92808 $5.00 CS010405
2/21/2023 Sharon Ulmer 92820 $10.00 CS010405
2/21/2023 Lizbeth Coleman 92824 $20.00 CS010405
2/21/2023 Tyler Moore 93237 $0.90 CS010405
2/22/2023 David Dickmann 92232 $10.00 CS010405
2/22/2023 Judy Siegle 92291 $5.00 CS010405
2/22/2023 Gail Hanson 92295 $0.89 CS010405
2/22/2023 Raghuram Medum 92296 $0.55 CS010405
2/22/2023 Alexa Harris 92301 $0.55 CS010405
2/22/2023 Diana Milski 92783 $0.55 CS010405
2/22/2023 Diana Milski 92784 $0.55 CS010405
2/22/2023 Andrea Fickert 92829 $5.00 CS010405
2/22/2023 Diane McAlear 92838 $0.80 CS010405
2/23/2023 Holly Hadac 92277 $30.00 CS010405
2/23/2023 Ken Peszko 92279 $5.00 CS010405
2/23/2023 Allie Selden 92286 $0.55 CS010405
2/23/2023 Abigail Kring 92821 $5.00 CS010405
2/23/2023 Sarah Bazinet 92854 $30.00 CS010405
2/23/2023 Valerie Belay 92855 $10.00 CS010405
2/23/2023 Michael Renner 92862 $0.25 CS010405
2/24/2023 Madeleine Krick 92309 $0.55 CS010405
2/24/2023 Gerardo Sierra Juarez 92341 $0.60 CS010405
2/24/2023 Greg Stewart 92880 $10.00 CS010405
2/24/2023 Lyndsie Blair 92882 $0.60 CS010405
2/24/2023 Jeffrey Pfaus 92895 $5.00 CS010405
2/24/2023 Grace Lee 92898 $5.00 CS010405
2/24/2023 Jennifer Lozar 92905 $0.80 CS010405
2/25/2023 Jennifer welch 92482 $10.00 CS010405
2/25/2023 stacy Burrows 92484 $5.00 CS010405
2/25/2023 Edwina McKenzie-Madison 92486 $5.00 CS010405
2/25/2023 Jeanne Weaver 92491 $50.00 CS010405
2/25/2023 Kelly Kamman 92494 $5.00 CS010405
2/25/2023 Susan Amory 92495 $0.55 CS010405
2/25/2023 Hillary Rademacher 92500 $0.80 CS010405
2/26/2023 Lawrence Starzyk 92502 $50.00 CS010405
2/26/2023 Darren Green 92503 $5.00 CS010405
2/26/2023 Jay Kim 92504 $5.00 CS010405
2/26/2023 Yadira Gutierrez 92514 $5.00 CS010405
2/26/2023 Ashley Franke 92890 $0.50 CS010405
2/26/2023 April Cohoon 92894 $5.00 CS010405
2/26/2023 Ana DeCarvalho 92913 $5.00 CS010405
2/26/2023 Shannon Prout 92988 $5.00 CS010405
2/26/2023 Shana Palmer 93058 $0.55 CS010405
2/26/2023 Cheryl Plautz 93059 $0.80 CS010405
2/26/2023 Wanda Roberts 93083 $10.00 CS010405
2/26/2023 Dayna Gonzales 93090 $10.00 CS010405
2/26/2023 Madison Koon 93092 $0.55 CS010405
2/27/2023 Dennis Perry 92449 $6.00 JE011129
2/27/2023 Dave Dork 92475 $0.55 CS010405
2/27/2023 Lindsay Lagios 92522 $0.10 CS010405
2/27/2023 beth Beyer 92524 $0.55 CS010405
2/27/2023 Abigail Abernathy 92526 $0.55 CS010405
2/27/2023 Rebecca Bieri 92560 $10.00 CS010405
2/27/2023 Susan Vanderstelt 92562 $5.00 CS010405
2/27/2023 Maura Thomson 92605 $0.50 CS010405
2/27/2023 Susan Green 93099 $10.00 CS010405
2/27/2023 Craig Howard 93101 $0.55 CS010405
73
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
2/27/2023 Michael Woodson Jr 93109 $0.80 CS010405
2/27/2023 Amity Tack 93368 $5.00 CS010405
2/28/2023 Donation Box 92517 $90.00 JE011264
2/28/2023 Kelly Green 92533 $50.00 JE011284
2/28/2023 Valerie Benjamin 92538 $25.00 JE011284
2/28/2023 Mark Mudd 92543 $5.00 JE011284
2/28/2023 Ely Nazar 92570 $5.00 CS010405
2/28/2023 Angela Reed 92571 $10.00 CS010405
2/28/2023 Pritesh Kamble 93116 $0.25 CS010405
2/28/2023 Mark Francese 93122 $5.00 CS010405
2/28/2023 Chrystal Fischer 93123 $5.00 CS010405
2/28/2023 Devin Spence 93142 $1.00 CS010405
2/28/2023 Brett Gladding 93144 $5.00 CS010405
2/28/2023 Judy Derek 93148 $5.00 CS010405
2/28/2023 Joseph Borgesen 93161 $5.00 CS010405
$13,567.21
Receipt Number Amount Journal Number
3/1/2023 Kevin Andre 92664 $0.55 CS010661
3/1/2023 James Bourn 92776 $5.00 CS010661
3/1/2023 Timothy Zervos 92779 $0.55 CS010661
3/1/2023 Joyce Karagounis 92781 $10.00 CS010661
3/1/2023 Rocio Murguia 92782 $5.00 CS010661
3/1/2023 Meghan Rompa 93157 $10.00 CS010661
3/1/2023 Austin Matusik 93160 $5.00 CS010661
3/1/2023 Jonathan Wolford 93172 $0.80 CS010661
3/1/2023 Michelle Johnson 93174 $0.55 CS010661
3/1/2023 Courtney Abela 93197 $0.80 CS010661
3/1/2023 Kavita Aggrwal 93385 $5.00 CS010661
3/2/2023 Laura Gizicki 92844 $5.00 CS010661
3/2/2023 Anne Holman 92960 $5.00 CS010661
3/2/2023 Meghan Smith 92961 $10.00 CS010661
3/2/2023 Amy Geisler 93208 $0.80 CS010661
3/2/2023 Mary Cottrell 93211 $20.00 CS010661
3/2/2023 Andrew Bos 93212 $0.80 CS010661
3/3/2023 Kimberly Lasko 92964 $0.55 CS010661
3/3/2023 Tonya Hooper 92966 $5.00 CS010661
3/3/2023 Christopher Holt 92975 $10.00 CS010661
3/3/2023 Brian Shureb 93151 $4.55 CS010661
3/3/2023 Michelle Hesse 93213 $0.55 CS010661
3/3/2023 Christopher Collins 93214 $10.00 CS010661
3/3/2023 Megan Favio 93216 $0.35 CS010661
3/3/2023 Stephen Krupitzer 93218 $5.00 CS010661
3/3/2023 Aubrey Hajek 93222 $0.55 CS010661
3/4/2023 Patti Mitrovich 92953 $50.00 CS010661
3/4/2023 Derek Korzym 92979 $5.00 CS010661
3/4/2023 Jagmohan Sharma 92987 $5.00 CS010661
3/4/2023 Sarah Rivord 92989 $5.00 CS010661
3/4/2023 Marissa Hernandez-Ibanez 92992 $5.00 CS010661
3/4/2023 Samantha Fearn 93065 $0.60 CS010661
3/4/2023 Sheila McClure 93241 $5.00 CS010661
3/4/2023 Todd Gurzik 93247 $7.90 CS010661
3/5/2023 Samantha Casas 92954 $50.00 CS010661
3/5/2023 Rachel Solwold 92957 $0.55 CS010661
3/5/2023 Michelle Wood 92995 $0.10 CS010661
3/5/2023 Ravi Adibhatla 93007 $0.80 CS010661
3/5/2023 Jodi Arndt 93009 $0.80 CS010661
February 2023 Total
Date of Donation Person Donating
74
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
3/5/2023 Furat Altawil 93279 $5.00 CS010661
3/6/2023 Andrew Wood 92991 $485.00 JE011430
3/6/2023 Susan Wieczorek 93019 $5.00 CS010661
3/6/2023 Susan Wieczorek 93020 $5.00 CS010661
3/6/2023 Gabriele Sandhaus 93034 $0.55 CS010661
3/6/2023 Heather Swanson 93067 $10.00 CS010661
3/6/2023 Anne Gahagan 93072 $5.00 CS010661
3/6/2023 Catherine Porritt 93281 $5.00 CS010661
3/6/2023 Jamie Zinser 93283 $5.00 CS010661
3/6/2023 Jennifer Russell 93289 $0.55 CS010661
3/6/2023 Dan Scharf 93318 $5.00 CS010661
3/6/2023 Toni Meni 93319 $0.25 CS010661
3/6/2023 Megan Soule 93320 $0.50 CS010661
3/6/2023 Lynn Wdowiak 93322 $0.55 CS010661
3/6/2023 Neal Feldman 93324 $10.00 CS010661
3/6/2023 Gilvan DaSilva 93331 $10.00 CS010661
3/7/2023 Leslie Brow 93110 $5.00 CS010661
3/7/2023 Russell Whitman 93196 $10.00 CS010661
3/7/2023 Susan Lane 93205 $50.00 CS010661
3/7/2023 Cora Hanson 93280 $5.00 CS010661
3/7/2023 Dennis Firestone 93300 $5.00 CS010661
3/7/2023 Judith Ferris 93333 $5.00 CS010661
3/7/2023 Stefanie Kunzelman 93339 $5.00 CS010661
3/7/2023 Michael Maher 93343 $10.00 CS010661
3/7/2023 Michelle Pereny 93349 $5.00 CS010661
3/7/2023 Monique Herzig 93351 $5.00 CS010661
3/7/2023 Victoria Marques 93353 $0.55 CS010661
3/7/2023 Nichole Kammeraad Trahey 93363 $0.55 CS010661
3/8/2023 David MacFadyen 93198 $0.80 CS010661
3/8/2023 Sherry DeBolt 93239 $5.00 CS010661
3/8/2023 Maria Rocha 93256 $5.00 CS010661
3/8/2023 Christopher Douglas 93315 $0.55 CS010661
3/8/2023 Annie Maynard 93372 $0.80 CS010661
3/8/2023 Huijuan Wang 93374 $0.55 CS010661
3/8/2023 Mieszko Osiewicz 93378 $5.00 CS010661
3/8/2023 Madelyn Barchichat 93384 $0.10 CS010661
3/8/2023 Mary Kovach 93386 $10.00 CS010661
3/8/2023 Cassidy Miller 93398 $0.25 CS010661
3/8/2023 Ryan Metzger 93400 $10.00 CS010661
3/8/2023 Jessica Bauer 93539 $5.00 CS010661
3/8/2023 Sue Ellen Eisenberg 93540 $0.90 CS010661
3/8/2023 Nicholas Stanon 93659 $5.80 CS010661
3/8/2023 Nicholas Stanon 93660 $5.80 CS010661
3/9/2023 Donation Box 93302 $1.11 JE011611
3/9/2023 Carole Carroll 93306 $25.00 JE011611
3/9/2023 Alfred Demailo 93309 $100.00 JE011611
3/9/2023 Northville High School 93311 $185.71 JE011611
3/9/2023 Donation Box 93358 $57.00 JE011611
3/9/2023 Sarah Davis 93361 $7.00 CS010999
3/9/2023 Diane Hoffner 93376 $3.80 CS010999
3/9/2023 Santina Macka 93490 $20.00 CS010999
3/9/2023 Ross Otten 93493 $5.00 CS010999
3/9/2023 Madhusudan Suryanaryanan 93501 $3.80 CS010999
3/9/2023 Valerie Bird 93550 $5.00 CS010999
3/9/2023 Valerie Bird 93551 $0.55 CS010999
3/9/2023 Angela Thompson 93588 $5.00 CS010999
3/9/2023 Mark Kwilos 93589 $10.00 CS010999
75
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
3/9/2023 Lisa Fraser 93590 $20.00 CS010999
3/9/2023 Renee Clearman 93610 $5.00 CS010999
3/9/2023 Michael Rogers 93612 $5.00 CS010999
3/9/2023 Douglas Smith 93613 $0.55 CS010999
3/10/2023 Elise Slater 93449 $100.00 CS010999
3/10/2023 Karen Goeringer 93450 $10.00 CS010999
3/10/2023 Leslie Schaefer 93457 $0.80 CS010999
3/10/2023 Leslie Schaefer 93458 $0.80 CS010999
3/10/2023 Heather Brown 93498 $20.00 CS010999
3/10/2023 Savannah Grieve 93500 $0.55 CS010999
3/10/2023 Kayla Weed 93502 $10.00 CS010999
3/11/2023 Susan Sevek 93448 $5.00 CS010999
3/11/2023 Melinda Parkes 93479 $0.80 CS010999
3/11/2023 Taylor Shipp 93481 $0.60 CS010999
3/11/2023 Clinton Hubbell 93485 $0.80 CS010999
3/11/2023 Judith Loeser 93630 $0.80 CS010999
3/12/2023 Perry Shaw 93469 $0.55 CS010999
3/12/2023 SOWJANYA Kolli 93482 $0.80 CS010999
3/12/2023 Steven Wilks 93508 $10.00 CS010999
3/12/2023 Kimberly Brown 93584 $0.55 CS010999
3/12/2023 Kimberly Brown 93585 $0.55 CS010999
3/12/2023 Jacqueline Stephenson 93653 $5.00 CS010999
3/12/2023 Jaclyn Gaule 93768 $5.00 CS010999
3/13/2023 Kathleen Sims-Young 93654 $0.80 CS010999
3/13/2023 Lynn Rydzik 93667 $5.00 CS010999
3/13/2023 Diana Quevedo Martinez 93670 $0.55 CS010999
3/13/2023 William Gossman 93703 $0.25 CS010999
3/13/2023 Katie Hayes 93708 $10.00 CS010999
3/14/2023 Rolf Sievers 93606 $5.00 CS010999
3/14/2023 Dennis Prestel 93616 $10.00 CS010999
3/14/2023 Chelsea Spriggs 93636 $0.80 CS010999
3/14/2023 Kim Lafond 93694 $25.00 JE011758
3/14/2023 Raymond Nowicki 93724 $5.00 CS010999
3/14/2023 Samantha Hanser Maynard 93726 $5.00 CS010999
3/14/2023 David Mungle 93727 $0.55 CS010999
3/14/2023 Jessica Korynski 93729 $0.80 CS010999
3/14/2023 Dereck Wonnacott 93843 $20.00 CS010999
3/14/2023 Michelle Butkovich 93868 $0.80 CS010999
3/15/2023 Kathy Hall 93746 $0.80 CS010999
3/15/2023 Janet Koss 93751 $0.89 CS010999
3/15/2023 Traci Moss 93757 $20.00 CS010999
3/15/2023 Nichole Borowski 93762 $0.80 CS010999
3/15/2023 Valerie Valentine 93788 $5.00 CS010999
3/15/2023 Edward Schofield 93789 $0.58 CS010999
3/15/2023 Kirthi Pantangi 94319 $5.00 CS010999
3/16/2023 Danielle Nelson 93798 $5.00 CS010999
3/16/2023 Megan Mitchell 93816 $5.00 CS010999
3/16/2023 Caitlin Bearman 93817 $0.80 CS010999
3/16/2023 Phil Janness 93821 $0.89 CS010999
3/16/2023 Stefanie Kunzelman 93826 $5.00 CS010999
3/16/2023 Karen Brooks 93836 $5.00 CS010999
3/16/2023 Krista Flagg 93845 $5.00 CS010999
3/16/2023 Julie Camarata 93847 $0.25 CS010999
3/16/2023 Robin Harant 93849 $0.80 CS010999
3/16/2023 James Deng 93850 $5.00 CS010999
3/16/2023 Derek Parsons 93851 $0.25 CS010999
3/16/2023 Mel Zentera 93856 $0.80 CS010999
76
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
3/16/2023 Chad O'Brien 93892 $0.45 CS010999
3/16/2023 Amy Firek 93927 $5.00 CS010999
3/17/2023 Mary Proper 93863 $0.80 CS011294
3/17/2023 Breanne Patton 93864 $5.00 CS011294
3/17/2023 Elizabeth Sippola 93865 $1,000.00 CS011294
3/17/2023 Cheryl Prieskorn 93866 $5.00 CS011294
3/17/2023 Ronald Harris 93867 $5.00 CS011294
3/17/2023 Jessica Kellogg 93890 $0.55 CS011294
3/17/2023 Craig Gillikin 93893 $5.00 CS011294
3/17/2023 Shelly Lock 93894 $5.00 CS011294
3/17/2023 Laura McLaughlin 93914 $5.00 CS011294
3/17/2023 Barbara Biess 93915 $50.00 CS011294
3/17/2023 Sabrina Loza 93916 $5.00 CS011294
3/17/2023 Cheryl Prieskorn 93947 $0.55 CS011294
3/17/2023 Jennifer Adcock 93953 $5.00 CS011294
3/18/2023 Loretta Whiting 93920 $0.80 CS011294
3/18/2023 Melissa Bruce 93955 $0.80 CS011294
3/18/2023 Lara Davis 93956 $10.00 CS011294
3/18/2023 Teri Naugle 93959 $5.00 CS011294
3/18/2023 Cheryl Mevis 93963 $0.55 CS011294
3/18/2023 Rod Morrison 93964 $0.80 CS011294
3/18/2023 Khushboo Aulakh 93970 $5.00 CS011294
3/19/2023 Arthur Yeman 93913 $0.55 CS011294
3/19/2023 Jose Avila 93930 $0.70 CS011294
3/19/2023 Rebecca Pratt 93934 $0.80 CS011294
3/19/2023 jodie Hicks 93935 $0.25 CS011294
3/19/2023 Dave Weise 93987 $20.00 CS011294
3/19/2023 Kennet Mangus 93989 $0.55 CS011294
3/19/2023 Judy Byrne 94039 $5.00 CS011294
3/20/2023 Uaw Lake Orion Gm Plant 93925 $1,039.00
Above * RANG INTO CASH REGISTER AS ADMIN LICENSES
3/20/2023 Michael Bohanon 93985 $25.00 JE0118822
3/20/2023 Anna Bluj 94007 $0.55 CS011294
3/20/2023 Ashley McGee 94008 $5.00 CS011294
3/20/2023 Carmine Perrotta 94010 $5.00 CS011294
3/20/2023 Donation Box 94017 $76.00 JE011883
3/20/2023 Christine Shantry 94034 $0.60 CS011294
3/20/2023 Julianna Blankenship 94042 $0.80 CS011294
3/20/2023 Kate Boyle 94045 $0.55 CS011294
3/20/2023 Shirley Tipper 94048 $5.00 CS011294
3/20/2023 Jessica Botha 94051 $0.25 CS011294
3/20/2023 Ron Dancel 94052 $0.80 CS011294
3/20/2023 Charles Kase 94054 $0.80 CS011294
3/20/2023 Arielle Flores 94094 $0.80 CS011294
3/21/2023 Keegan Walsh 94073 $5.00 CS011294
3/21/2023 Nancy Silverman 94096 $50.00 CS011294
3/21/2023 Natalie Tschudin 94097 $20.00 CS011294
3/21/2023 Kristen McGrath 94099 $5.00 CS011294
3/21/2023 Todd Ingraham 94107 $5.00 CS011294
3/21/2023 Richard Sears 94109 $0.80 CS011294
3/21/2023 Kimberly Bucchi 94116 $10.00 CS011294
3/21/2023 Lee Bissonnette 94140 $20.00 CS011294
3/21/2023 Laura Gluhanich 94142 $5.00 CS011294
3/21/2023 Brianne Steele 94145 $0.55 CS011294
3/21/2023 Ann Randall 94146 $10.00 CS011294
3/21/2023 Marci Bloom-Vettese 94149 $5.00 CS011294
3/21/2023 Sydney Macker 94155 $0.25 CS011294
77
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
3/22/2023 John Little 94127 $5.00 JE012009
3/22/2023 Michelle Banks 94129 $25.00 JE012009
3/22/2023 Dennis Anderson 94134 $40.00 JE012009
3/22/2023 North American Lighting 94135 $231.00 JE012009
3/22/2023 Donation Box 94138 $1.11 JE012009
3/22/2023 Martin Grennier 94139 $0.80 CS011294
3/22/2023 Bridget Garrity 94164 $0.55 CS011294
3/22/2023 Susan Ward 94167 $160.00 JE012010
3/22/2023 Jenna Lopatin 94169 $0.55 CS011294
3/22/2023 Bonnie McEldowney 94173 $40.00 JE012010
3/22/2023 Peggy Sefanski 94183 $50.00 JE012009
3/22/2023 Stefanie Kunzelman 94206 $5.00 CS011294
3/22/2023 Maegan Eller 94207 $0.55 CS011294
3/22/2023 Steve Ostrowski 94208 $0.80 CS011294
3/22/2023 Patricia VanPoppelen 94214 $20.00 CS011294
3/22/2023 Lisa Bennett 94225 $5.00 CS011294
3/23/2023 Stephanie Carpenter 94212 $0.15 CS011294
3/23/2023 Marianne Palmieeeri 94219 $0.80 CS011294
3/23/2023 Nicky Wrigley 94222 $0.80 CS011294
3/23/2023 Kim Bartindale 94231 $0.80 CS011294
3/23/2023 Tyler Bailey 94254 $5.00 CS011294
3/23/2023 Lisa Dorian 94258 $20.00 CS011294
3/23/2023 Henrietta Holefca 94261 $20.00 CS011518
3/24/2023 Christine Logan 94285 $10.00 CS011518
3/24/2023 Beverly Onder 94287 $0.80 CS011518
3/24/2023 Gwendolyn Foster 94297 $10.00 CS011518
3/24/2023 Denay Loftin 94300 $0.55 CS011518
3/24/2023 Tracy Weston 94306 $800.00 JE012081
3/24/2023 Melissa Hallman 94326 $5.10 CS011518
3/24/2023 David Hein 94349 $5.00 CS011518
3/24/2023 Raghu Chovvath 94351 $10.00 CS011518
3/25/2023 Melissa Piligian-DeSchutter 94331 $5.00 CS011518
3/25/2023 Sarah Messana 94334 $0.55 CS011518
3/25/2023 Rachel Frank 94337 $5.00 CS011518
3/25/2023 Andrew Bedard 94361 $5.00 CS011518
3/25/2023 Alessandra Hale-Lopez 94362 $3.80 CS011518
3/25/2023 Erick Herrera 94363 $20.00 CS011518
3/25/2023 Paul Meaders 94369 $5.00 CS011518
3/25/2023 Anthony Gasparotto 94371 $0.80 CS011518
78
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - Q2 - 2023FY
3/25/2023 Cheri Smith 94375 $5.00 CS011518
3/25/2023 Randall Whitehead 94380 $5.00 CS011518
3/26/2023 Joe Stirparo 94340 $10.00 CS011518
3/26/2023 Chelsea Love 94344 $5.00 CS011518
3/26/2023 Scott Boyer 94346 $5.00 CS011518
3/26/2023 Gabriele Zoroya 94386 $10.55 CS011518
3/26/2023 Omega Hang 94387 $20.00 CS011518
3/27/2023 Ellen Deangelo 94398 $22.00 JE012081
3/27/2023 Michael Plotzke 94408 $0.55 CS011518
3/27/2023 Ramona Nave 94409 $1,200.00 JE012082
3/27/2023 Elizabeth Saarela 94419 $5.00 CS011518
3/27/2023 Arthur Schnittman 94423 $0.55 CS011518
3/27/2023 Tradnaha Turner 94438 $50.00 CS011518
3/27/2023 Ashley Piechorowski 94439 $0.80 CS011518
3/27/2023 Hugo De La Fuente 94443 $5.00 CS011518
3/27/2023 Sharon Douglas 94444 $5.00 CS011518
3/27/2023 Vanessa Polis 94447 $5.00 CS011518
3/28/2023 Gwyn Reece 94457 $10.00 CS011518
3/28/2023 Theresa Metzmaker 94459 $10.00 CS011518
3/28/2023 Claudia Blasco 94471 $5.00 CS011518
3/28/2023 Shane Wilson 94477 $5.00 CS011518
3/28/2023 Raymond Kelly Jr 94484 $10.00 JE012212
3/28/2023 Tina Wood 94500 $0.80 CS011518
3/28/2023 James Purdy 94520 $48.00 JE01211
3/28/2023 James Ferrari 94527 $10.00 CS011518
3/28/2023 Emily Muller 94530 $5.00 CS011518
3/28/2023 Robin Cole 94533 $10.55 CS011518
3/28/2023 Taylor McDaniel 94535 $5.00 CS011518
3/28/2023 Jodi Fultz 94538 $0.80 CS011518
3/28/2023 Blake Silverman 94539 $5.00 CS011518
3/29/2023 David Doerr 94542 $10.00 CS011518
3/29/2023 Margaret DeRoousse 94547 $20.00 CS011518
3/29/2023 Mark Hibbard 94549 $10.00 CS011518
3/29/2023 Charles Blaker 94577 $10.00 CS011518
3/29/2023 Theresa Amatore 94593 $10.00 CS011518
3/29/2023 Jennifer Belanger 94598 $5.00 CS011518
3/29/2023 Joe Spurlin 94601 $5.00 CS011518
3/29/2023 Valentina Aliyeva 94603 $5.00 CS011518
3/30/2023 Victoria Ceder 94590 $0.80 CS011518
3/30/2023 Victoria Ceder 94591 $0.80 CS011518
3/30/2023 Derek Parsons 94606 $0.90 CS011518
3/30/2023 Jake Korthals 94611 $0.25 CS011518
3/30/2023 Angela Warr 94628 $5.00 CS011518
3/30/2023 Jamie Boden 94637 $5.00 CS011518
3/30/2023 Joseph Kiefer 94653 $5.00 CS011518
3/30/2023 Christina McGraw 94654 $0.80 CS011518
3/30/2023 Kaitlin McNeil 94658 $0.80 CS011518
3/31/2023 Stephen Weidenhamer 94660 $5.00 CS011518
3/31/2023 Christina Schrems 94662 $10.00 CS011518
3/31/2023 Susan Giroux 94670 $20.00 CS011518
3/31/2023 John Sperry 94692 $0.89 CS011518
3/31/2023 Leigh Peterson 94747 $20.00 CS011518
3/31/2023 Cynthia Sherman 94749 $0.80 CS011518
3/31/2023 Janice Zink 94752 $0.55 CS011518
3/31/2023 Alina Thomas 94784 $5.00 CS011518
$7,360.33
$32,342.99
March 2023 Total
Q2 FY2022 Total
79
Date Donor Cash/Check Amount Purpose
3/7/2023 Hyundai Motor America N/A 7,665.28$ 224 steering wheel locks
4/25/2023 Home Depot 8,250.00$ materials to construct training room
3/23/2023 Hummingbird N/A 2,899.99$ Humminbird Helix 9 Portable Sonar (serial # 210923340029)
18,815.27$ Total Contribution
Oakland County Sheriff's Office
FY2023 Second Quarter Report for Contributions (Donations)
80
Department of Public Services
Oakland County Children's Village
Date:Donor:Cash/Check:Items:Estimated Value:
1/5/2023 St. Pepetua Church Pillow Cases $300.00
1/6/2023 Jaia Ogg Toys $30.00
1/17/2023 Cynthia Harper 15 Skeins of Yarn $50.00
1/19/2023 Sweet Dreams for Kids 15 Child Friendly Pillow Cases $225.00
1/25/2023 Brightmoor Christian Church 20 Food Baskets for Resident Families $2,000.00
1/30/223 Big Beaver United Methodist Church Check $100.00
2/1/2023 OCCVF Driver's Education for Resident $300.00
2/1/2023 Brightmoor Christian Church Candy & Toiletries $300.00
2/1/2023 St. Patirck Catholic Church Games, Blankets, Pop, Pizza $600.00
2/2/2023 St. Pepetua Church Pillow Cases $300.00
2/10/2023 A Little Quilt Shop Quilts $200.00
2/15/2023 Sweet Dreams for Kids 15 Child Friendly Pillow Cases $225.00
3/1/2023 OCCVF Driver's Education for Resident $250.00
3/7/2023 St. Pepetua Church Pillow Cases $375.00
3/7/2023 OCCVF Driver's Education for Resident $300.00
3/8/2023 OCCVF Drawing Class for Resident $175.00
3/8/2023 OCCVF Bags for Residents Leaving Mandy's $507.00
3/15/2023 Sweet Dreams for Kids 15 Child Friendly Pillow Cases $225.00
3/16/2023 Bombas Socks Socks $2,500.00
Total:$8,962.00
Donation Tracking : Donation Period January 2023 to March 2023
C:\Users\strongl\Documents\Donations\FY2023 2nd Quarter Cv Donations 81
MONTH
CONTRACT
ADJUST
WRITEOFF
BAD DEBT
WRITEOFF Total
October 2022 (2,384.52)(10,072.80)(12,457.32)
November 2022 (2,419.54)(6,090.95)(8,510.49)
December 2022 (900.29)(2,833.80)(3,734.09)
January 2023 (1,652.61)(2,304.90)(3,957.51)
February 2023 (631.64)(3,084.62)(3,716.26)
March 2023
April 2023
May 2023
June 2023
July 2023
August 2023
September 2023
(7,988.60)(24,387.07)(32,375.67)
Department of Health and Human Services Write-Offs
82
OAKLAND COUNTY COMMUNITY & HOME IMPROVEME
REQUEST FOR AUTHORIZATION TO RECOGNIZE UNCOLLECTIBLE HOM
2nd QUARTER FY 2023
REHAB
GRANT CONTRACT LOAI\
NAME ADDRESS COMMUNITY ZIP CODE CASE NO. CDBG/HOME DATE AMOUr
Kaying Chang & Pa Yang 761 Palmer Dr Pontiac Ml 48342 7649 CDBG 11/17/2017 $19,25(
Roberto G. Riddle 23115 Tawas Ave Hazel Park Ml 48030 17039 CDBG 6/21/2021 $9,32~
/'1 r
*Chapter 13 Bankruptcy complete~ v,J;ich strimied oyr loan /"""",,,, "
PREPARED BY: !~/ I \;fa, ~'r71 r,£0'vf9)); Shameka Davenport ,a✓1 ?)/ Loan Closing Officer /lri
APPROVED BY: rl I f
A~
I I' Tashawna Burton
j \ \ Supervisor v---\ \
83