HomeMy WebLinkAboutReports - 2023.09.21 - 40592
AGENDA ITEM: 2023 Third Quarter Financial Forecast and Budget Amendments
DEPARTMENT: Fiscal Services
MEETING: Board of Commissioners
DATE: Thursday, September 21, 2023 9:30 AM - Click to View Agenda
ITEM SUMMARY SHEET
COMMITTEE REPORT TO BOARD
Resolution #2023-3388
Motion to accept the Fiscal Year 2023 Third Quarter Financial Report, recognize the donations in
the Animal Shelter and Pet Adoption Center, Children’s Village and Sheriff’s Office, and 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. Furthermore, amend the FY 2023 – FY
2025 Budgets pursuant to Schedules A and B.
ITEM CATEGORY SPONSORED BY
Quarterly Report Gwen Markham
INTRODUCTION AND BACKGROUND
Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of Government,
provides for adjustments to the adopted budget. In accordance with Oakland County General
Appropriations Act Section 22, which authorizes budget amendments for variances between the
budgeted revenue and actual revenue, and Section 23, which authorizes budget amendments for
variances between estimated revenue and projected expenditures, amendments are required.
The Fiscal Year (FY) 2023 Quarter Financial Forecast Report has identified several variances and
budget amendments are recommended as detailed in the attached Schedule A and B budget
amendment.
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.
The Department of Public Services, Animal Shelter and Pet Adoption Center received donations for
the period of April 2023 through June 2023 totaling $21,621.68. Children’s Village Division received
donations for the period of April 2023 through June 2023 totaling $12,552 of which $100 was a cash
donation. The Sheriff’s Office received donations for the period of April 2023 through June 2023
valued at $2,799.
Children’s Village Division has recommended we write-off $26,364 as uncollectible receivables from
2021. Oakland County Department of Health and Human has recommended to write-off $15,505.76
as the amount is uncollectable for the period of March 2023 through June 2023.
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
Aaron Snover, Board of Commissioners Created/Initiated - 9/21/2023
AGENDA DEADLINE: 09/21/2023 9:30 AM
ATTACHMENTS
1. Fiscal Year 2023 3rd Quarter Forecast
2. Schedule "A" Detail
3. Schedule "B" Detail
COMMITTEE TRACKING
2023-09-20 Finance - Recommend to Board
2023-09-21 Full Board - Adopt
Motioned by: Commissioner Charles Cavell
Seconded by: Commissioner Yolanda Smith Charles
Yes: David Woodward, Michael Spisz, Karen Joliat, Kristen Nelson, Christine Long, Robert
Hoffman, Philip Weipert, Gwen Markham, Angela Powell, Marcia Gershenson, Janet Jackson,
Yolanda Smith Charles, Charles Cavell, Brendan Johnson, Ajay Raman (15)
No: None (0)
Abstain: None (0)
Absent: William Miller III, Gary McGillivray, Michael Gingell, Penny Luebs (4)
Passed
OAKLAND COUNTY EXECUTIVE DAVID COULTER
2100 Pontiac Lake Road | Executive Office Building 41W | Waterford, MI 48328 | Fax (248) 452-9172 | OakGov.com
TO: Members of the Finance Committee
FROM: 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 Third Quarter Forecast
DATE: September 15, 2023
Attached please find the Fiscal Year 2023 Third 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 third quarter of the fiscal year (ending June 30). The quarterly
forecasting process seeks to ensure that no individual department overspends its appropriated budget at
year end and provides countywide information on forecasted revenues and expenditure for use by the Board
of Commissioners, Department of Management and Budget, and the public.
Revenue Forecast
Total General Fund revenues are forecasted to be $1.3 million higher than the revenue amounts included in
the Amended FY 2023-2025 County Budget. This is the net result of higher forecasted revenues of $5.8
million for Investment Income and a number of other revenue categories and lower forecasted Charges for
Services totaling $4.5 million across several departments.
The majority of the lower forecasted charges are comprised of $2.8 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. Revenue estimates for the District Court have
been lowered in the FY 2024-2026 County Executive Recommended Budget.
Expenditure Forecast
Total General Fund Expenditures are forecasted to be $6.4 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 $24.0 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 $17.6 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.
Two departments are forecasted to exceed appropriated levels at the department total level:
• The Sheriff’s Office is forecasted to exceed its budget by $2.1 million. This is the result of Personnel
Costs being forecasted to exceed the budgeted level by $3.6 million due to higher holiday and other
overtime costs, hospital watch, officers in the academy/training, and other factors. The Sheriff’s
Office will be prepared to answer questions about these spending trends and measures to be taken
1
~OAKIAND~
COUNTY MICHIGAN
MANAGEMENT & BUDGET
2100 Pontiac Lake Road | County Executive Building 41W | Waterford, MI 48328 | Fax (248) 452-9172 | OakGov.com
to address spending levels in future years. For FY 2023, a budget amendment will be required in the
year-end report to cover the final spending amounts.
• The Water Resources Commissioner is forecasted to exceed its budget by about $15,000. This is
the result of higher than anticipated internal service charges.
Budget amendments are included with the attached resolution for net-neutral adjustments within department
budgets, resolutions adopted by the Board of Commissioners for which a budget amendment was not
available at the time, recognition of available revenue amounts, and other technical adjustments.
Impact on Planned Use of Fund Balance
The current amended budget assumes $28.0 million in Planned Use of Fund Balance. Major contributors to
this amount are as follows:
• $8.3 million for road programs and other one-time purposes included in the original Adopted FY
2023 budget.
• $19.9 million 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 $7.7 million less than the level assumed in
the amended budget. This would result in an FY 2023 ending General Fund balance of $200.5 million, which
equates to 40.0% of the County’s ongoing FY 2023 General Fund budget of $500.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, revenue and expenditure trends in the fourth quarter of
the fiscal year, and other technical factors -- will affect the final FY 2023 fund balance. Those factors
will be accounted for in the FY 2023 year-end report that will be delivered to the committee in
November.
Please call with any questions you may have prior to the Finance Committee meeting.
2
COUNTY OF OAKLAND
FY 2023 THIRD 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$ 292,119,600.00$ 1,199,600.00 0.41%
Federal Grants 1,208,790.00 2,306,754.00 2,467,393.00 160,639.00 6.96%
State Grants 19,891,928.00 22,060,025.00 22,088,525.00 28,500.00 0.13%
Other Intergovernmental Revenue 49,848,663.00 49,923,613.00 51,376,713.00 1,453,100.00 2.91%
Charges for Services 127,682,464.00 128,573,561.00 124,053,553.00 (4,520,008.00) -3.52%
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 4,546,500.00 2,741,800.00 151.93%
Other Revenues 434,000.00 434,000.00 677,613.00 243,613.00 56.13%
Transfers In 26,053,877.00 26,516,041.00 26,516,041.00 - 0.00%
SUB-TOTAL GENERAL FUND/GENERAL PURPOSE 521,809,126.00$ 531,688,694.00$ 533,003,438.00$ 1,314,744.00$ 0.25%
TOTAL GF/GP FUNDS 521,809,126.00$ 531,688,694.00$ 533,003,438.00$ 1,314,744.00$ 0.25%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court 51,476,232.00$ 53,327,281.66$ 46,226,781.66 7,100,500.00$ 13.31%
52nd District Court 18,811,240.00 19,003,765.52 18,456,265.52 547,500.00 2.88%
Probate Court 7,760,407.00 7,919,118.90 7,865,406.90 53,712.00 0.68%
TOTAL ADMIN. OF JUSTICE 78,047,879.00$ 80,250,166.08$ 72,548,454.08$ 7,701,712.00$ 9.60%
LAW ENFORCEMENT
Prosecuting Attorney 26,205,522.00 27,354,600.60 25,526,300.60 1,828,300.00 6.68%
Sheriff 183,280,522.00 191,841,317.04 193,974,646.04 (2,133,329.00) -1.11%
TOTAL LAW ENFORCEMENT 209,486,044.00$ 219,195,917.64$ 219,500,946.64$ (305,029.00)$ -0.14%
GENERAL GOVERNMENT
Clerk/Register of Deeds 10,767,003.00 11,096,510.04 10,014,510.04 1,082,000.00 9.75%
Treasurer 8,588,966.00 9,199,823.90 8,379,823.90 820,000.00 8.91%
Board of Commissioners 5,323,418.00 6,824,798.00 6,434,798.00 390,000.00 5.71%
Water Resources Commissioner 8,274,453.00 8,436,699.04 8,451,669.04 (14,970.00) -0.18%
TOTAL GENERAL GOVERNMENT 32,953,840.00$ 35,557,830.98$ 33,280,800.98$ 2,277,030.00$ 6.40%
COUNTY EXECUTIVE
County Executive Admn.9,986,336.00$ 10,407,839.00$ 9,583,960.00$ 823,879.00$ 7.92%
Management and Budget 25,144,692.00 25,739,311.00 23,880,311.00 1,859,000.00 7.22%
Facilities Management 4,723,654.00 5,026,353.72 4,540,938.72 485,415.00 9.66%
Human Resources 5,456,482.00 6,090,652.75 5,489,652.75 601,000.00 9.87%
Health and Human Services 44,810,566.00 49,506,357.18 44,051,357.18 5,455,000.00 11.02%
Public Services 43,399,767.00 44,528,052.64 42,857,052.64 1,671,000.00 3.75%
Economic Development 11,228,989.00 16,082,600.00 12,764,600.00 3,318,000.00 20.63%
Emergency Management & Homeland Security 2,150,270.00 3,517,233.38 3,314,233.38 203,000.00 5.77%
Public Communication 3,713,099.00 4,824,356.00 4,599,356.00 225,000.00 4.66%
TOTAL COUNTY EXECUTIVE 150,613,855.00$ 165,722,755.67$ 151,081,461.67$ 14,641,294.00$ 8.83%
TOTAL DEPARTMENTS 471,101,618.00$ 500,726,670.37$ 476,411,663.37$ 24,315,007.00$ 4.86%
Non-Departmental $58,981,384.00 $58,983,006.00 76,596,561.00 (17,613,555.00)
TOTAL GOVERNMENTAL EXPENDITURES 530,083,002.00$ 559,709,676.37$ 553,008,224.37$ 6,701,452.00$ 1.20%
General Fund/General Purpose
Favorable/(Unfavorable) - Budget Perspective 8,016,196.00$ 8,016,196.00$
PLANNED USE OF FUND BALANCE 8,273,876.00$ 28,020,982.37$ 20,004,786.37$
14
AMOUNT
ADOPTED AMENDED FY 2023 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2023 THIRD QUARTER REPORT
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 150,000.00 25,000.00 20.00%Fav. Due to collection of prior years taxes.
Marijuana Tax 50,000.00 50,000.00 1,149,600.00 1,099,600.00 2199.20%Fav. Due to increased recorded sales.
Treasurer Payment in Lieu of Taxes 550,000.00 550,000.00 625,000.00 75,000.00 13.64%Fav. due to tax payments from the state on DNR land.
Trailer Tax 95,000.00 95,000.00 95,000.00 - 0.00%
Total Taxes 285,734,704.00$ 290,920,000.00$ 292,119,600.00$ 1,199,600.00$ 0.41%
FEDERAL GRANTS (610000-610999)
Sheriff - Sheriff's Office -$ -$ -$ -$ 0.00%
Sheriff - Emergency Response and Prep - - - - 0.00%
Sheriff - Patrol - 208,261.00 200,000.00 (8,261.00) -3.97%Unfav. TIA Traffic Enforcement grant reimbursement due to timing.
Sheriff - Investigative/Forensic Services - 39,682.00 179,682.00 140,000.00 352.80%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 467,500.00 467,500.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 659,821.00 659,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 240,000.00 (60,000.00) -20.00%Unfav. School Lunch program serving less due to decline in population
of residents.
Non-Department - - 88,900.00 88,900.00 100.00%Fav. Due reimbursement of FEMA related costs.
Total Federal Grants 1,208,790.00$ 2,306,754.00$ 2,467,393.00$ 160,639.00$ 6.96%
STATE GRANTS (615000-615999)
Sheriff - Emergency Response and Prep -$ 26,150.00$ 26,150.00$ -$ 0.00%
Sheriff - Patrol Services -$ 49,500.00$ 78,000.00$ 28,500.00$ 57.58%Marine Safety Grant - State of Michigan allocation due to timing.
State Match Foster Care 1,000.00 1,000.00 1,000.00 - 0.00%
Prosecuting Attorney - - - - 0.00%
Clerk - County Clerk - 40,000.00 40,000.00 - 0.00%SCAO (State Court Administrative Office) Grant funding College Intern
Positions.
Economic Development - - - - 0.00%
Health Division 5,541,240.00 7,121,891.00 7,121,891.00 - 0.00%
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,806,484.00 14,806,484.00 - 0.00%
Total State Grants 19,891,928.00$ 22,060,025.00$ 22,088,525.00$ 28,500.00$ 0.13%
OTHER INTER-GOVERNMENTAL REVENUES (620000 - 626999)
Non-Departmental 47,584,129.00$ 47,834,129.00$ 49,317,229.00$ 1,483,100.00$ 3.10%Fav. Convention Facility Tax due to timing of receiving reimbursement
from the state for FY 2022.
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%
15
AMOUNT
ADOPTED AMENDED FY 2023 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2023 THIRD QUARTER REPORT
District Court 1,800.00 1,800.00 1,800.00 - 0.00%
Probate Court - - - - 0.00%
Sheriff 255,050.00 80,000.00 50,000.00 (30,000.00) -37.50%Unfav. Social Security Incentive Payments ($30,000) as a result of a
reduction in the number of inmates receiving social security. Funds are
collected from jail inmates who receive SSI for cost of incarceration.
Non-Departmental - Reimb Judges Salaries 1,994,184.00 1,994,184.00 1,994,184.00 - 0.00%
Total Other Intergovernmental Revenue 49,848,663.00$ 49,923,613.00$ 51,376,713.00$ 1,453,100.00$ 2.91%
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,171,448.00 37,448.00 3.30%Fav. Refund Fees PD Def Attorney $112,448 due to a delay in
payments from FY 2022 for restitution and other statutory fees. Partially
offset by unfav. Court Costs ($75,000) due to changes in legislation.
Circuit Court - Family Division 1,421,500.00 451,500.00 331,500.00 (120,000.00) -26.58%Unfav. Court Service Fees Probation ($75,000) due to a reduction in
probation caseload. Unfav. Reimb Clinical Evaluations ($25,000) due
to a decrease in reimbursement. Unfav. Miscellaneous ($20,000) due
to a decrease in activity. 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,789,753.00 (1,050,000.00) -27.35%Unfav. Ordinance Fines and Costs ($625,000); Probation Fees
($250,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,595,163.00 (227,500.00) -12.48%Unfav. Ordinance Fines and Costs ($120,000); State Law Costs
($55,000); and Probation Fees ($52,500) 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,141,015.00 (745,000.00) -19.17%Unfav. Ordinance Fines and Costs ($475,000) as well as Probation
Fees ($270,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,380,590.00 (740,000.00) -34.90%Unfav. Ordinance Fines and Costs ($420,000) partially due to the
reduction in caseload from marijuana legalization and partially due to
COVID-19 pandemic. Unfav. Probation Fees ($245,000) as well as
State Law Costs ($75,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 756,100.00 237,500.00 45.80%Fav. Gross Estate Fees $167,500 due to a increase in fees paid. Fav.
Certified Copies $55,000 and Photostats $15,000 due to an increase in
activity.
Total Administration of Justice 14,743,121.00$ 13,773,121.00$ 11,165,569.00$ (2,607,552.00)$ -18.93%
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 THIRD QUARTER REPORT
Law Enforcement
Prosecuting Attorney 820,349.00$ 853,621.00$ 788,621.00 (65,000.00) -7.61%Unfav. Reimb General ($26,000) at 46th District Court, State
Appropriaton Victim Witness ($22,000), Extradition Recovery Fee
($11,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 218,500.00 (125,000.00) -36.39%Unfav. Fingerprints ($140,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,519,335.00 100,000.00 4.13%Fav. Diverted Felon $200,000 due to the number of inmates that meet
reimbursement criteria; offset by unfav. Inmate Board and Care
($55,000) due to lower collection rates, Reimb Contracts with Oakland
Community Health Network from an unreimbursable vacant position
and Miscellaneous ($8,000).
Sheriff - Corrective Services Satellites 787,059.00 787,059.00 712,059.00 (75,000.00) -9.53%Unfav. Board and Care ($50,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 - - 100.00 100.00 100.00%Fav. Miscellaneous revenue.
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 ($750,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. Miscellaneous $63,750
due to restitution payments and Reimb Salaries $13,800 due to task
force reimbursement.
Total Law Enforcement 69,949,302.00$ 71,437,025.00$ 70,612,125.00$ (824,900.00)$ -1.15%
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 281,900.00 85,000.00 43.17%Fav. Due to Reimb General $85,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 Recording Fees Revenue ($1,000,000), Mortgages
($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,980,915.00 122,160.00 3.17%Fav - Soil Erosion Fees $120,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,910,215.00$ (1,342,840.00)$ -5.32%
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 THIRD 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 240,100.00 240,100.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 464,500.00 138,500.00 42.48%Fav. Standard Mail $165,000 due to increase in rebills to other
departments and rate increases. Unfav. Commission Vending
Machines ($26,500) due to terms of current vendor contract and
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 599,945.00 80,000.00 15.39%Fav. Cremation Approval Fees $50,000 due to greater than anticipated
activity and Lapper County contract.
Public Services - Animal Control 1,447,014.00 1,451,929.00 1,201,929.00 (250,000.00) -17.22%Unfav. Sale of Licenses ($250,000) due to smaller census team and
lower activity ever since the COVID-19 pandemic.
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,191,795.00$ 17,146,079.00$ (45,716.00)$ -0.27%
Non-Departmental
Non-Dept - Charges for Services 918,565.00$ 918,565.00$ 1,219,565.00 301,000.00 32.77%Fav. due to Commission Public Telephone $100,000 due to increased
activity. Also fav., Reimb General $176,400 due to reimbursement from
state for Circuit Courts IT development costs and Miscellaneous
Revenue $23,700 due to refund from state for unclaimed property.
Total Non-Departmental 918,565.00$ 918,565.00$ 1,219,565.00$ 301,000.00$ 32.77%
Total Charges for Services 127,682,464.00$ 128,573,561.00$ 124,053,553.00$ (4,520,008.00)$ -3.52%
INDIRECT COST RECOVERY (640100)9,150,000.00$ 9,150,000.00$ 9,150,000.00 -$ 0.00%
18
AMOUNT
ADOPTED AMENDED FY 2023 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
GENERAL FUND / GENERAL PURPOSE REVENUES
FISCAL YEAR 2023 THIRD 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/Forensic Services - - - - 0.00%
Treasurer 300,000.00 300,000.00 520,000.00 220,000.00 73.33%Fav. due to investment base and market rate adjustments.
Clerk/Register of Deeds 2,500.00 2,500.00 252,500.00 250,000.00 10000.00%Fav. due to investment base and market rate adjustments.
Fiscal Services - - - - 0.00%
Economic Development - - - - 0.00%
Health Division - - - - 0.00%
Non-Departmental 1,500,000.00 1,500,000.00 3,771,800.00 2,271,800.00 151.45%Fav. due to investment base and market rate adjustments.
Total Investment Income 1,804,700.00$ 1,804,700.00$ 4,546,500.00$ 2,741,800.00$ 151.93%
OTHER REVENUES (670000)
Circuit Court - Donations -$ -$ -$ -$ 0.00%
Circuit Court - - - - 0.00%
District Courts (Div. I - IV)- - 25.00 25.00 100.00%Fav. due to Cash Overages.
District Courts (Div. I - IV)- - - - 0.00%
Probate Court - - 472.00 472.00 100.00%Fav. primarily due to Sale of Equipment $450.
Sheriff Office - - 3,700.00 3,700.00 100.00%Fav. Enhancement Funds for unbudgeted cash recovery from
evidence.
Sheriff - Administrative Services - - - - 0.00%
Sheriff - Corrective Services - - 25.00 25.00 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 - - 75.00 75.00 100.00%Fav. Cash Overages
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%
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 THIRD 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 - - 40.00 40.00 100.00%Fav. Due to Cash Overages.
Public Services - Children's Village - Other Revenues - - 54,932.00 54,932.00 100.00%Fav. Refund Prior Year Revenue and County Auction.
Economic Development - Veterans - - - - 0.00%
Non Departmental - Donations - - - - 0.00%
Non-Dept - Sundry 417,500.00 417,500.00 155,200.00 (262,300.00) -62.83%Unfav. Prior Years Adjustment ($417,500) due to less anticipated use.
Partially offset by Fav. Prior Years Expenditure $155,200 due to
reimbursement from State of Michigan for FY 2022 IT Master Plan
project cost for Circuit Court as it relates to the states criminal justice
reform.
Total Other Revenues 434,000.00$ 434,000.00$ 677,613.00 243,613.00$ 56.13%
TRANSFERS IN (695500)
Circuit Court - Transfers In - - - - 0.00%
Prosecuting Attorney Transfers In - 100,000.00 100,000.00 - 0.00%
Board of Commissioners - 100,000.00 100,000.00 -
Health Division - Transfers In - - - - 0.00%
Public Services - Animal Control-Transfers In - - - - 0.00%
Public Services - Children's Village - Transfers In - 27,551.00 27,551.00 - 0.00%
Economic Development Transfers In - - 0.00%
Medical Examiners Transfer In - - - - 0.00%
Sheriffs' Transfers In - 132,667.00 132,667.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,855,823.00 23,855,823.00 - 0.00%
Total Transfers In Revenues 26,053,877.00$ 26,516,041.00$ 26,516,041.00 -$ 0.00%
PLANNED USE OF FUND BALANCE (665882)
Encumbrances and Carry forwards - 19,934,269.37 19,934,269.37 - 0.00%
Use of Prior Yrs Fund Balance 8,273,876.00$ 8,086,713.00$ 8,086,713.00 - 0.00%
Total Planned Use of Fund Balance 8,273,876.00$ 28,020,982.37$ 28,020,982.37$ -$ 0.00%
TOTAL GEN. FUND / GEN. PURPOSE REVENUE 530,083,002.00$ 559,709,676.37$ 561,024,420.37$ 1,314,744.00$ 0.23%
20
Adopted Amended Forecast Favorability/UNF Percentage
$51,476,232.00 $53,327,281.66 $46,226,781.66 $7,100,500.00 13.31%
$28,064,168.00 $28,185,592.00 $26,860,592.00 $1,325,000.00 4.70%
$11,378,901.00 $12,151,150.66 $5,645,650.66 $6,505,500.00 53.54%
$5,227,181.00 $6,184,557.00 $6,914,557.00 ($730,000.00)-11.80%
$6,805,982.00 $6,805,982.00 $6,805,982.00 $0.00 0.00%Transfers
Projected in line with budget for Transfers Out
Projected favorability due to decrease in placements to State Institutions $3,500,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 $370,000; Fees Guardian Ad Litem $250,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 ($590,000) across all divisions due to higher than anticipated
computer hardware and software utilization, with greater unfavorability of ($275,000) in Family Division and
($165,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
Placements are down in part due to a shortage of placement options state-wide
Personnel
Projected favorability in Salaries and Fringes due to underfilled and vacant positions across all divisions, with
greater favorability of $750,000 in Family Division and $200,000 in Judicial Administration
Operating
Circuit Court
2023 Q3 Forecast
Total
Summary of Projections
21
Adopted Amended Forecast Favorability/UNF Percentage
$18,811,240.00 $19,003,765.52 $18,456,265.52 $547,500.00 2.88%
$14,702,269.00 $14,795,658.00 $14,365,658.00 $430,000.00 2.91%
$2,196,016.00 $2,203,444.52 $2,113,944.52 $89,500.00 4.06%
$1,912,955.00 $2,004,663.00 $1,976,663.00 $28,000.00 1.40%
$0.00 $0.00 $0.00 $0.00 0.00%
Personnel
Projected favorability in Salaries and Fringes due to turnover across all divisions, with greater favorability
of $125,000 in Rochester, $100,000 in Novi and $100,000 in Clarkston
Operating
District Court
2023 Q3 Forecast
Total
Summary of Projections
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 $10,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 $15,000 under Novi due to caseload. The District Court is
charged a base fee plus a per case fee
Projected favorability in Telephone Communications $78,500 mainly attributed to efforts to reduce landlines to
improve cost efficiency, with greater favorability of $27,500 in Novi and $20,000 in Rochester
The overall Internal Services category is partially offset by projected unfavorability in InfoTech Operations
($45,000) due to higher than anticipated use, with greater unfavorability of ($17,500) in Clarkston and ($15,000) in
Troy
Internal
22
Adopted Amended Forecast Favorability/UNF Percentage
$7,760,407.00 $7,919,118.90 $7,865,406.90 $53,712.00 0.68%
$5,543,249.00 $5,559,878.00 $5,459,878.00 $100,000.00 1.80%
$1,113,424.00 $1,159,304.90 $1,170,592.90 ($11,288.00) -0.97%
$1,103,734.00 $1,199,936.00 $1,234,936.00 ($35,000.00)-2.92%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
No Transfers Out are budgeted in FY 2023
Projected unfavorability in Medical Services Probate Exam ($25,000); Fees Guardian Ad item ($20,000); as well as
Medical Services Guardianship ($20,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
$57,500 under Estates and Mental Health due to lower demand for this service
Projected unfavorability in InfoTech Operations ($35,000) and Equipment Rental ($25,000) under Estates and
Mental Health due to higher than anticipated equipment utilization and software maintenance contracts which
may impact future forecasts
The overall Internal Services category is partially offset by projected favorability in Info Tech Operations $25,000
under Judicial Administration due to lower than anticipated use
Internal
Personnel
Projected favorability in Salaries and Fringes due to underfilled positions/vacancies within the Estates and Mental
Health division
Operating
Probate Court
2023 Q3 Forecast
Total
Summary of Projections
23
Adopted Amended Forecast Favorability/UNF Percentage
$26,205,522.00 $27,354,600.60 $25,526,300.60 $1,828,300.00 6.68%
$21,971,765.00 $22,260,065.00 $20,625,065.00 $1,635,000.00 7.34%
$661,836.00 $1,361,863.60 $1,188,563.60 $173,300.00 12.73%
$2,351,664.00 $2,512,415.00 $2,712,415.00 ($200,000.00)-7.96%
$1,220,257.00 $1,220,257.00 $1,000,257.00 $220,000.00 18.03%
Personnel
Overtime unfavorable ($145,000) and offset by favorability in salaries and fringe benefits.
Favorability in salaries and fringe benefits due to turnover and vacancies.
Operating
Prosecuting Attorney
2023 Q3 Forecast
Total
Summary of Projections
Transfers
Transfers Out favorability is due to less Cooperative Reimbursement Program grant match obligation than budgeted
Favorability of $170,000 is predominantly driven by less spending for the Oxford High School shooting response than
originally estimated. Favorability is also due to variances in multiple spending categories such as Library Continuations,
Computer Research Service, Personal Mileage and Expert Witness Fee and Mileage.
Forecasted unfavorability of ($200,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
Projected favorability is partially offset by unfavorability of ($215,000) which includes variances in several spending
categories such as Membership Dues, Extradition Expense, Printing, Travel and Conference, Witness Fees and Mileage and
Court Transcripts.
24
Adopted Amended Forecast Favorability/UNF Percentage
$183,280,522.00 $191,841,317.04 $193,974,646.04 ($2,133,329.00) -1.11%
$145,712,711.00 $146,793,938.00 $150,411,767.00 ($3,617,829.00) -2.46%
$13,494,198.00 $18,642,730.04 $17,418,730.04 $1,224,000.00 6.57%
$23,358,310.00 $24,075,715.00 $23,885,215.00 $190,500.00 0.79%
$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 for 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 Communications, Custodial Supplies, 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 $650,000.
Favorability of $181,000 in Patrol Services - Equipment for the pending upgrade to the helicopter mapping system
which is a carry-forward from FY 2022. This upgrade is dependent on the condition of the helicopter as it awaits
determination of repair.
Favorability of $90,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 $740,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 ($465,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 ($130,000) in Emergency Response and Prep - Equipment Maintenance is unfavorable
($96,650) due to helicopter repair expenditures which will be offset by insurance payment (less any deductible) in
Revenue. Also unfavorable is Electrical Service and Natural Gas due to the increasing cost of utilities.
Favorability of $200,000 in Misc Capital Outlay for planned lab equipment purchase which will not be completed
due to technology not meeting requirements.
Personnel
Overall personnel is unfavorable ($3,600,000) primarily in Overtime and associated Fringe Benefits due to turnover,
parental leave, hospital watch, officers in the academy and officers in training.
Operating
Sheriff's Office
2023 Q3 Forecast
Total
Summary of Projections
25
Adopted Amended Forecast Favorability/UNF Percentage
$10,767,003.00 $11,096,510.04 $10,014,510.04 $1,082,000.00 9.75%
$8,098,002.00 $8,098,002.00 $7,249,002.00 $849,000.00 10.48%
$1,332,412.00 $1,403,724.04 $1,105,724.04 $298,000.00 21.23%
$1,336,589.00 $1,594,784.00 $1,659,784.00 ($65,000.00)-4.08%
$0.00 $0.00 $0.00 $0.00 0.00%
Personnel
Favorability in salaries and fringes within The County Clerk's department within Administration, County Clerk and Register of
Deed divisions is due to vacancies, turnover and underfilled positions.
Operating
Clerk/Register of Deeds
2023 Q3 Forecast
Total
Summary of Projections
Transfers
Projected in line with budget for Transfers Out
Favorability of $298,00 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 $125,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 ($65,000) due to Telephone Communications
and Info Tech Operations due to greater than anticipated use.
Internal
26
Adopted Amended Forecast Favorability/UNF Percentage
$8,588,966.00 $9,199,823.00 $8,379,823.00 $820,000.00 8.91%
$3,771,884.00 $3,771,884.00 $3,651,884.00 $120,000.00 3.18%
$3,408,770.00 $3,763,243.00 $3,063,243.00 $700,000.00 18.60%
$1,288,312.00 $1,544,696.00 $1,544,696.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 Service
$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 Q3 as utilization is at 75%.
Internal
Personnel
Favorability in salaries and fringes within The Treasurer department is due to vacancies, turnover and underfilled
positions.
Operating
Treasurer
2023 Q3 Forecast
Total
Summary of Projections
27
•
•
•
Adopted Amended Forecast Favorability/UNF Percentage
$5,323,418.00 $6,824,798.00 $6,734,798.00 $90,000.00 1.32%
$3,443,428.00 $3,443,428.00 $3,383,428.00 $60,000.00 1.74%
$1,184,048.00 $2,648,145.00 $2,648,145.00 $0.00 0.00%
$695,942.00 $733,225.00 $703,225.00 $30,000.00 4.09%
$0.00 $0.00 $0.00 $0.00 0.00%
Personnel
Favorability in salaries and fringes within The Board of Commissioners department is due to vacancies, turnover and
underfilled positions.
Operating
Board of Commissioners
2023 Q3 Forecast
Total
Summary of Projections
Transfers
•No Transfers Out are budgeted in FY 2023.
Operating category is estimated to come in at budget for contractual services based on initiatives in plan
Newly elected Commissioners terms started 1/1/2023 and have upcoming projects which will utilize majority of
budget.
Forecasted Internal Services is slightly below budget for Q3 as utilization is at 75%.
Internal
28
•
•
•
•
Adopted Amended Forecast Favorability/UNF Percentage
$8,274,453.00 $8,436,699.00 $8,451,669.00 ($14,970.00) -0.18%
$234,624.00 $234,624.00 $221,624.00 $13,000.00 5.54%
$287,975.00 $288,094.00 $236,064.00 $52,030.00 18.06%
$7,695,689.00 $7,857,816.00 $7,937,816.00 ($80,000.00)-1.02%
$56,165.00 $56,165.00 $56,165.00 $0.00 0.00%
Personnel
Favorable Salaries and Fringes $13,000 based on current fringe trends.
Operating
Water Resources Commissioner
2023 Q3 Forecast
Total
Summary of Projections
Transfers
Transfers Out for Drainage Districts will occur at Fiscal Year End.
Favorable Meter Postage and Office Supplies $28,000 due to remote work.
Favorable Legal Services $24,850 due to less spending on these services related to the Soil
Erosion and Environmental Unit programs.
Unfavorable Drain Equipment Labor ($200,000) due to a increase in the amount of rework
projects. Offset by favorable Drain Equipment and Info Tech Managed Print Services $120,000
the result of actual spending being less than anticipated budget. Also, offset by favorable
Internal
revenue from Soil Erosion Fees.
29
Adopted Amended Forecast Favorability/UNF Percentage
$9,986,336.00 $10,407,839.00 $9,583,960.00 $823,879.00 7.92%
$6,189,140.00 $6,199,706.00 $5,842,244.00 $357,462.00 5.77%
$990,835.00 $1,226,068.00 $849,468.00 $376,600.00 30.72%
$922,740.00 $1,070,244.00 $980,427.00 $89,817.00 8.39%
$1,883,621.00 $1,911,821.00 $1,911,821.00 $0.00 0.00%
County Executive
2023 Q3 Forecast
Total
Summary of Projections
Personnel
Compliance Office, Corporate Counsel, and Indigent Defense Services Office divisions are all at budget for FY23-
Q3.
Favorability of $276,700 in Admin due to vacancy, turnover and step increases.
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.
Projected unfavorability of ($47,000) in Admin. This is primarily due to Professional Services line item being
unfavorable by ($90,000). Partially offset by $22,400 in favorability from Special Events and $12,800 from
Contracted Services line items due to lack of anticipated use. Unfavorability is offset by favorability in other divisions
below.
Projected favorability in Compliance Office of $103,600 primarily due to Professional Services favorability of
$90,200 for less than anticipated use.
DEI favorability of $301,500 primarily due to Special Event Program of $147,100 and Special Event Supplies of
$45,900 due to less than anticipated use for FY2023. Also favorable, Professional Services $82,300 as projected
activity will be lower than budget.
Admin forecast $86,900 favorable primarily due to Info Tech Operation of $76,400 due to needed reallocation from
Admin to DPC. Audit in progress to realign. Also favorable, Info Tech Managed Print Services $8,900 due to paper
reduction efforts.
Compliance Office projected $15,600 in favorability primarily due to Info Tech Operations of $13,400 due to less
than anticipated usage.
DEI is favorable $5,417 due to vacancy.
Internal
Corporation Counsel forecast favorable by $18,500. Favorability primarily attributed to Legal Services $5,900 due
to decreased usage for servicers bundled in subscription services. Also favorable: Expendible Equipment $3,100,
Travel and Conference $2,700, Computer Supplies $1,500 and Office Supplies $1,500 due to less than anticipated
use.
Projected unfavorability for Corporation Counsel of ($18,100) primarily due to increased license usage in the Info
Tech Operations ($15,300) line-item. Also unfavorable in Telephone by ($4,400) due to ongoing maintence charges
for replaced equipment.
Favorability of $80,762 due to vacancy within DEI division.
30
Adopted Amended Forecast Favorability/UNF Percentage
$25,144,692.00 $25,739,311.00 $23,880,311.00 $1,859,000.00 7.22%
$20,479,043.00 $20,123,095.00 $18,373,095.00 $1,750,000.00 8.70%
$1,120,330.00 $1,274,514.00 $1,167,514.00 $107,000.00 8.40%
$3,545,319.00 $4,341,702.00 $4,339,702.00 $2,000.00 0.05%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
No Transfers Out are budgeted in FY 2023
Forecasted favorability for Fiscal Services for Info Tech Print Managed Services $15,000 due to remote work leading to
less than normal usage. Partially offset by Telephone Communications ($13,000) due to higher than anticipated usage.
Internal
Favorability projected for Equalization Divison Professional Services $30,000, Training $30,000, Personal Mileage $20,000,
and Printing $15,000 due to less than anticipated usage. Partially offset by Metered Postage ($51,000) and Travel and
Conference ($7,000) due to increased usage.
Favorability projected for Fiscal Services Professional Services $70,000, Metered Postage $30,000, Training $20,000, and
Expendable Equipment $20,000 due to less than anticipated usage.
Personnel
Favorability in salaries and fringes $1,750,000 due to turnover and underfilled positions/vacancies across all
divisions, with greater favorability from Fiscal Services, Equalization Division, and Purchasing.
Operating
Management & Budget
2023 Q3 Forecast
Total
Summary of Projections
31
Adopted Amended Forecast Favorability/UNF Percentage
$4,723,654.00 $5,026,353.72 $4,540,938.72 $485,415.00 9.66%
$2,882,560.00 $2,882,560.00 $2,480,095.00 $402,465.00 13.96%
$767,229.00 $1,015,170.72 $964,720.72 $50,450.00 4.97%
$1,073,865.00 $1,113,623.00 $1,081,123.00 $32,500.00 2.92%
$0.00 $15,000.00 $15,000.00 $0.00 0.00%Transfers
No Transfers Out are budgeted in FY 2023
Projected favorability in Professional Services $125,000 under the Sustainability Initiatives program due to a delay
in hiring educational and implementation contractors
Projected favorability in Printing $45,000 under the Sustainability Initiatives program due to a delay in the start of
event and educational initiatives
Projected favorability in Special Event Supplies $45,000 under the Sustainability Initiatives program due to a delay
in the start of special events
Projected favorability in InfoTech Operations of $32,500 due to lower than anticipated use, with greater
favorability of $22,500 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 along with
Professional Services ($100,000) under Facilities Planning and Engineering due more than anticipated preliminary
costs for future projects
Personnel
Projected favorability in Salaries and Fringes due to turnover and vacant positions, with greater favorability of
$175,000 in Facilities Planning and Engineering along with $175,000 in Facilities Administration
Operating
Facilities Management
2023 Q3 Forecast
Total
Summary of Projections
32
Adopted Amended Forecast Favorability/UNF Percentage
$5,456,482.00 $6,090,652.75 $5,489,652.75 $601,000.00 9.87%
$3,607,735.00 $3,607,735.00 $3,272,735.00 $335,000.00 9.29%
$565,601.00 $882,468.75 $777,468.75 $105,000.00 11.90%
$1,283,146.00 $1,600,449.00 $1,439,449.00 $161,000.00 10.06%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
No Transfers Out are budgeted in FY 2023.
Forecasting Expenditures favorability of $105,000 mostly attributed to Administration Divison Professional
Services $200,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 Human Resources Department is favorable due to Info Tech Operations less than
anticipated use.
Internal
Personnel
Favorability in salaries and fringes within Human Resources department is due to vacancies, turnover and underfilled
positions.
Operating
Human Resources
2023 Q3 Forecast
Total
Summary of Projections
33
Adopted Amended Forecast Favorability/UNF Percentage
$44,810,566.00 $49,506,357.18 $44,051,357.18 $5,455,000.00 11.02%
$31,938,944.00 $31,938,944.00 $29,638,944.00 $2,300,000.00 7.20%
$8,403,941.00 $12,166,929.18 $8,991,929.18 $3,175,000.00 26.10%
$3,858,143.00 $4,148,505.00 $4,168,505.00 ($20,000.00)-0.48%
$609,538.00 $1,251,979.00 $1,251,979.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 Q3 Forecast
Total
Summary of Projections
Transfers
Neighborhood Housing Development forecast for Q3 is at budget.
Favorability for Private Institution Residence $1,000,000, Private Institution $500,000, Private Institution Foster $300,000,
Independent Living $200,000, Foster Board Home $100,000 related to the Child Care Fund. These expenditures are based on
caseload, difficulty of care, and treatment services ordered by the Courts. Some caseloads are referred to the County by
Michigan Department of Health & Human Services. The costs are difficult to estimate and have been lower as a result of
COVID‐19. Also, favorability Support Services $250,000 due to request for funding for Oxford School incident being less than
anticipated. Partially offset by Child Abuse Neglect Council ($45,000) due to increased anticipated Court appointments.
Favorability Vaccines $400,000, Professional Services $200,000, Uniforms $160,000, Contracted Services $90,000, Uniform
Cleaning $72,000, Equipment Maintenance $25,000, West Nile Virus $20,000, Drugs $20,000, and Employee Footwear
$15,000 due to less than anticipated demant and the impact of COVID‐19. Partially offset by Personal Mileage ($50,000) due
to new mileage reimbursement calculation in union agreement and increased mileage post‐COVID. Also, Adjustment Prior
Year Expenditure ($37,000), Indirect Costs ($30,000), and Medical Supplies ($15,000) due to more than anticipated usage and
charges.
Forecasted unfavorability overall of (20,000) due to Info Tech Operations ($300,000) being more than anticipated in the
Health Division. Partially offset by favorability Building Space Cost Allocation $220,000 and Info Tech Operations $60,000 due
to less than anticipated use in the Health & Human Services Administration Division.
Internal
34
Adopted Amended Forecast Favorability/UNF Percentage
$43,399,767.00 $44,528,052.64 $42,857,052.64 $1,671,000.00 3.75%
$31,303,511.00 $31,656,734.00 $30,421,734.00 $1,235,000.00 3.90%
$5,502,271.00 $6,015,976.64 $5,485,976.64 $530,000.00 8.81%
$6,593,985.00 $6,855,342.00 $6,949,342.00 ($94,000.00)-1.37%
$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 $155,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 ($94,000) across all divisions due to a higher than antcipated
computer hardware and software utilization.
Internal
Projected unfavorability of ($55,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 Q3 Forecast
Total
Summary of Projections
35
•
•
•
•
Adopted Amended Forecast Favorability/UNF Percentage
$11,228,989.00 $16,082,600.00 $12,764,600.00 $3,318,000.00 20.63%
$7,844,494.00 $7,844,494.00 $7,234,494.00 $610,000.00 7.78%
$2,034,875.00 $5,399,951.00 $2,483,951.00 $2,916,000.00 54.00%
$1,349,620.00 $1,538,155.00 $1,746,155.00 ($208,000.00)-13.52%
$0.00 $1,300,000.00 $1,300,000.00 $0.00 0.00%Transfers
Transfers Out for Business Development Division forecast Q3 is at budget.
Favorability projected for Economic Development Administration Division for Special Projects $50,000, Membership Dues
$30,000, Professional Services $20,000, Personal Mileage $10,000, and Printing $10,000 due to less than anticipated usage.
Unfavorability in Info Tech Operations ($88,000) primarily from Local Business Development Division ($158,000) due to
more than anticipated usage. Partially offset by favorability in Economic Development Division $60,000 and Business
Development Division $10,000 due to less than anticipated usage.
Internal
Favorability of $521,000 projected for Planning and Local Business Development Division for Advertising $200,000,
Workshops and Meetings $200,000, Business Recruitment $75,000, Software Support Maintenance $60,000, Personal Mileage
$27,000, Drafting Supplies and Maps $20,000, Metered Postage $10,000, and Office Supplies $10,000 due to less than
antcipated usage and reorganization within Department. Partially offset by Special Event Program ($50,000), Travel and
Conference ($17,000), and Software Rental Lease Purchase ($14,000) due to more than anticipated usage.
Favorability of $115,000 projected for Veteran Service Division for Soldier Burial $100,000 and Soldier Relief $15,000 due to
less than antcipated claims for veteran benefits such as burial in National Cemetary, headstones, markers, burial flags, and
other veteran benefits.
Favorability of $2,160,000 projected for Business Development Division for Professional Services $2,300,000 due to unspent
FY2022 Carryforward funding for U.S. Center for Advanced Manufacturing Hub Designation to Automation Alley (M.R.# 21-
184). This funding is anticipated to be spent over the next two years for Automation Alley. Also, favorability in Workshop and
Meetings $20,000 due to less than antcipated usage. Partially offset by Business Recruitment ($132,000), Membership Dues
($16,000), and Advertising ($12,000) due to more than antcipated usage.
Favorability Telephone Communications $10,000 due to less than anticipated use.
Unfavorability in Workforce Development Division for Building Space Cost Allocation ($110,000) due to unbudgeted charges
and Telphone Communications ($15,000) due to more than antcipated usage.
Personnel
Favorability in salaries and fringes due to turnover and underfilled positions/vacancies across all divisions.
Operating
Economic Development & Community Affairs
2023 Q3 Forecast
Total
Summary of Projections
36
Adopted Amended Forecast Favorability/UNF Percentage
$2,150,270.00 $3,517,233.38 $3,314,233.38 $203,000.00 5.77%
$1,081,520.00 $1,089,341.00 $1,089,341.00 $0.00 0.00%
$469,337.00 $1,766,927.38 $1,405,927.38 $361,000.00 20.43%
$599,413.00 $660,965.00 $818,965.00 ($158,000.00)-23.90%
$0.00 $0.00 $0.00 $0.00 0.00%Transfers
No Transfers Out are budgeted in FY 2023
Favorable Professional Services $500,000, Contracted Services $145,000, and Equipment Maintenance $35,000 due to less
than anticipated use and FEMA (Federal Emergency Management Agency)/ARPA funded expenditures. Partially offset by Rent
($140,0000), Medical Supplies ($100,000), Disaster Supplies ($37,000), Electrical Service (25,000), and Laboratory Fees
($17,000) for expenditures that are anticipated to be reimbursed by FEMA through May 11, 2023. Funding for these line
items will be covered by ARPA through the cut-off date in 2024 afterwards.
Unfavorable Info Tech Operations ($124,000), Motor Pool ($25,000), and Telephone Communications ($9,000) due to more
than anticipated use.
Internal
Personnel
Personnel For Emergency Management & Homeland Security forecast for 3rd Qtr is at budget.
Operating
Emergency Management & Homeland Security
2023 Q3 Forecast
Total
Summary of Projections
37
Adopted Amended Forecast Favorability/UNF Percentage
$3,713,099.00 $4,824,356.00 $4,599,356.00 $225,000.00 4.66%
$2,178,262.00 $2,362,278.00 $2,012,278.00 $350,000.00 14.82%
$1,494,000.00 $2,034,984.00 $2,034,984.00 $0.00 0.00%
$40,837.00 $427,094.00 $552,094.00 ($125,000.00)-29.27%
$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 Q3 Forecast
Total
Summary of Projections
Transfers
•No Transfers Out are budgeted in FY 2023
•Operating category is projected to be on budget.
•Projected unfavorability in Info Tech Operations due to higher than anticipated use
Internal
38
AccountAdopted Budget Amended Budget 3rd Qtr Fcst 3rd Qtr Var % Narrative Explanation ExpenditureSC702145 - Separation Incentive1,041,385.00 1,041,385.00 896,000 145,385 13.96% Fav. Due to Voluntary Employee Seperation Incentive Program (VESIP) and VESIP Schedule C incentive pay less than budgeted projectionSC702995 - Salary Turnover Factor(10,272,145.00) (10,272,145.00)- (10,272,145) 100.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)896,000 (10,126,760)109.71%SC722760 - Group Life0.000.000 0.00%SC722790 - Social Security0.000.00 61,100 (61,100) 0.00% Unfav. Due to the fringe component of the Voluntary Employee Seperation Incentive Program SC722810 - Disability0.000.0000.00%722000:Fringe Benefits0.000.0061,100 (61,100) 0.00%RC730240 - Cash Shortage0.000.0000.00%SC730044 - Adj Prior Years Revenue0.000.0000.00%SC730121 - Bank Charges0.000.00 83,300 (83,300)0.00% Unfav. Due to bank charges are not budgeted.SC730240 - Cash Shortage0.000.0000.00%SC730359 - Contingency815,541.00 1,223,760.00 1,223,760 00.00%SC730611 - Employees Medical Exams0.000.0000.00%SC730800 - Grant Match350,000.0073.0073 00.00%SC730954 - Insurance Surety Bonds33,305.00 33,305.00 1,200 32,105 96.40% Fav. Based on actual payments approved by Risk ManagementSC731136 - Logos Trademarks Intellect Prp20,000.00 20,000.00 24,500 (4,500) -22.50% Unfav. Due to increased costs.SC731241 - Miscellaneous300,000.00 300,000.00- 300,000100.00%Fav. Due to less than anticipated use.SC731346 - Personal Mileage0.000.00- 00.00%SC731577 - Refund Prior Years Revenue0.000.00- 00.00%SC731822 - Special Projects650,000.00 150,000.00 150,000 00.00%SC731885 - Supportive Services0.000.00- 00.00%730000:Contractual Services2,168,846.00 1,727,138.001,482,833 244,305 14.15%SC740037 - Classification and Rate Change193,451.00(1.00)(1) 00.00%SC740044 - Drain Assessments Current2,025,000.00 1,775,000.00 1,775,000 00.00%SC740058 - Emergency Salaries Reserve72,674.00 72,674.00 72,674 00.00%SC740072 - General Fund Contingency(8,000,000.00) (8,000,000.00)- (8,000,000) 100.00%Unfav. As this amount is a general operating favorability factor that reflects historical favorability trends while the county continues to review departmental operations.SC740085 - Local Road Funding Program2,000,000.00 2,000,000.00 2,000,000 0 0.00%SC740086 - Mental Health Authority9,620,616.00 9,620,616.00 9,620,616 00.00%SC740090 - Township Road Repair Program0.00 2,000,000.00 2,000,000 0 0.00%SC740093 - Mich Association of Counties73,000.00 73,000.00 73,000 00.00%SC740100 - National Assoc of Counties24,100.00 24,100.00 24,100 00.00%SC740114 - Overtime Reserve300,000.00 300,000.00- 300,000 100.00%Fav. As this contingency amount was not required for departemental operations.SC740135 - Road Comm Tri Party2,000,000.00 4,374,048.00 4,374,048 00.00%SC740149 - SEMCOG550,000.00 550,000.00 550,000 00.00%SC740160 - Substance Abuse Coord Agency 4,943,138.00 4,943,138.00 4,943,138 00.00%SC740177 - Traffic Improvement Assoc30,000.00 30,000.00- 30,000100.00%740000:Non-Departmental13,831,979.00 17,762,575.0025,432,575 (7,670,000) -43.18%SC760126 - Capital Outlay Miscellaneous300,000.00 746,393.00 746,393 00.00%SC760180 - Technology Projects-One Time2,000,000.00 1,188,556.00 1,188,556 00.00%760000:Capital Outlay2,300,000.00 1,934,949.001,934,949 - 0.00%COUNTY OF OAKLANDFY 2023 THIRD QUARTER REPORTEXPENDITURESNON-DEPARTMENTAL 39
AccountAdopted Budget Amended Budget 3rd Qtr Fcst 3rd Qtr Var % Narrative Explanation COUNTY OF OAKLANDFY 2023 THIRD QUARTER REPORTEXPENDITURESNON-DEPARTMENTAL SC770631 - Bldg Space Cost Allocation1,104,752.00 1,104,752.00 1,104,752 00.00%SC773630 - Info Tech Development9,212,320.00 5,203,947.005,203,947 00.00%SC774677 - Insurance Fund460,272.00 460,272.00460,272 00.00%SC775754 - Maintenance Department Charges 702,500.00 244,878.00244,878 00.00%SC777599 - Service Center Grounds500,000.00 500,000.00 500,000 00.00%770000:Internal Support Expenditures11,979,844.00 7,513,849.007,513,849 - 0.00%SC788001 - Transfers Out37,931,475.00 39,275,255.00 39,275,255 00.00%788001:Transfers Out37,931,475.00 39,275,255.0039,275,255 - 0.00%SC796500 - Budgeted Equity Adjustments0.000.00- 00.00%796500:Budgeted Equity Adjustments0.000.00- - 0.00%Total Expenditure58,981,384.00 58,983,006.0076,596,561 (17,613,555) -29.86%40
TREASURER'S OFFICEADOPTED AMENDED FY 2023 VARIANCEBUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~DELINQUENT TAX REVOLVING FUND 51600REVENUES 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 7,550,000.00 5,550,000.00 277.50% Fav. Investment from Investments $5,550,000 due to investment base and market rate adjustments. Transfers In - - - - 0.00% Total Revenues $12,500,000.00 $12,500,000.00 $18,050,000.00 5,550,000.00$ 44.40%OPERATING EXPENSES Personnel Expenditures 267,612.00$ 267,612.00$ 247,612.00$ 20,000.00$ 7.47% Fav. Salaries and Fringe Benefits based on actual activity. Operating Expenditures 419,655.00 419,655.00 369,655.00 50,000.00 11.91% Fav. Administrative Overhead $30,000 and Legal Services $20,000 due to less than anticipated activity. 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.001,291,500.001,291,500.00- 0.00% Total Transfer Out to Other Funds11,960,350.00$ 11,960,350.00$ 11,960,350.00$ -$ 0.00%Total Operating Expenses13,647,617.00$ 13,647,617.00$ 13,577,617.00$ 70,000.00$ 0.51%REVENUE OVER (UNDER) EXPENDITURES*($1,147,617.00) ($1,147,617.00) $4,472,383.00 $5,620,000.00Total Net Position - Beginning$208,089,434.68Total Net Position - Ending $212,561,817.68Ending FY 2021 Designated Net Position**:NP-UnRes - Designated - Debt Service$53,276,854.00NP-UnRes - Designated - Delinq Taxes Receivable148,733,472.22 NP-UnRes - Designated - Collection Fees6,079,108.46 Undesignated - Net Position$4,472,383.00Total Net Position - Ending$212,561,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 onlyCOUNTY OF OAKLANDFY 2023 THIRD QUARTER REPORTENTERPRISE FUND41
COUNTY OF OAKLANDFY 2023 THIRD QUARTER REPORTENTERPRISE FUNDSTREASURERADOPTED AMENDED FY 2023 VARIANCEBUDGET 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.000.00%OPERATING EXPENSE536,288.00 536,288.00 498,288.00$38,000.007.09% Fav. Controllable Personnel $20,000 due to vacant and underfilledpositions. Also fav. Professional Services $15,000 and MeteredPostage $3,000 due to less than anticipated use.NET OPERATING INCOME (LOSS) ($30,152.00) ($30,152.00)$7,848.00$0.000.00%NON-OPERATING REVENUE (EXPENSE) 5,000.005,000.00 $14,000.00$9,000.00180.00%TOTAL INCOME BEFORECONTRIBUTIONS AND TRANSFERS ($25,152.00) ($25,152.00)21,848.00$ $9,000.00TRANSFERS OUT- - - - TOTAL NET INCOME (LOSS)*($25,152.00) ($25,152.00) $21,848.00$9,000.00TOTAL NET POSITION - BEGINNING1,133,473.33 TOTAL NET POSITION - ENDING$1,155,321.33* Please note that in the Adopted Budget (line-item book) this is budgeted as 'Planned Use of Balance" in the revenue category. 42
COUNTY OF OAKLANDFY 2023 SECOND QUARTER REPORTENTERPRISE FUNDPARKS & RECREATIONADOPTED AMENDEDFY 2022VARIANCEBUDGETBUDGETFORECASTFAV/(UNFAV) PERCENTEXPLANATION OF SIGNIFICANT VARIANCES~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~OAKLAND COUNTY PARKS & RECREATION COMMISSION (50800)OPERATING REVENUE11,953,357.00$ 11,953,357.00$ 11,953,357.00$ 0.00%OPERATING EXPENSE34,368,299.00$ 34,547,600.00$ 34,547,600.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,594,243.00)$ (22,594,243.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 TRANSFERS2,513,635.00$ 2,478,834.00$ 3,782,458.00$ 1,303,624.00$ -52.59%TRANSFERS IN-$ -$ -$ 58,000.00$ Fav. Operating transfers in $58,000 related to Trailways Development Agreement. A budget amendment is recom.mended is included in 3rd Quarter packet.TOTAL NET INCOME/BUDGETED EQUITY ADJ2,513,635.00$ 2,478,834.00$ 3,782,458.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 - BEGINNING96,563,170.00$ TOTAL NET POSTION - ENDING100,345,628.00$ 43
ADOPTED AMENDED FY 2023VARIANCEBUDGETBUDGET FORECAST FAV/(UNFAV) PERCENTEXPLANATION OF SIGNIFICANT VARIANCES~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~ ~~~~~~~~~~~~ ~~~~~~~~~~~~ ~~~~~~~~~~~~~ ~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~DRAIN EQUIPMENT FUND ( 63900)OPERATING REVENUES: Inside53,380,714.00$ 53,163,934.00$ 49,963,934.00$ (3,200,000.00)$ -6.02%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 - Equipment Rental $200,000 due to under estimate of billable hours. Fav - Rebilled Charges $100,000 revenue is determined by a increase in rebillable repair jobs, offset by unfavorable expenses pertaining to the repair jobs. Outside310,100.00 310,100.00 210,100.00 (100,000.00) -32.25%Unfav - External Rebilled Charges Revenue ($100,000) revenue is determined by a decrease in rebillable repair jobs, offset by favorable expenses pertaining to the repair jobs. Total Revenue53,690,814.00 53,474,034.00 50,174,034.00 (3,300,000.00) -6.17%OPERATING EXPENSES$56,450,645.00 $56,233,865.00 $52,759,615.00 $3,474,250.00 6.18%Fav - Salaries and Fringes $3,000,000 due to turnover and vacant positions. Fav - Depreciation Computer Software $378,000 due to the Supervisory Control and Data Acquisition (SCADA) system common to all project not being booked in third quarter FY 2023. Fav - Drain Equipment Materials, Drain Equipment Labor and Drain Equipment $146,000 due to a decrease in the amount of reworked projects. Fav - Indirect Costs $25,000 due to indirect cost rate finalized after budget process. Fav - Travel and Conference $10,000 and Computer Supplies $7,000 the result of actual spending being less than anticipated budget. Fav - Rent $7,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. WATER RESOURCES COMMISSIONERFY 2023 THIRD QUARTER REPORTINTERNAL SERVICE FUNDCOUNTY OF OAKLAND44
ADOPTED AMENDED FY 2023VARIANCEBUDGETBUDGET FORECAST FAV/(UNFAV) PERCENTEXPLANATION OF SIGNIFICANT VARIANCES~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~ ~~~~~~~~~~~~ ~~~~~~~~~~~~ ~~~~~~~~~~~~~ ~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~WATER RESOURCES COMMISSIONERFY 2023 THIRD QUARTER REPORTINTERNAL SERVICE FUNDCOUNTY OF OAKLANDUnfav - Equipment Rental Expense ($19,200) the result of increased use in specialty equipment needed for maintenance projects. Unfav - Contracted Services ($45,000) and Natural Gas ($3,500) the result of actual spending being more than anticipated budget. Unfav - Charge Card Fee ($4,000) due to fees for processing on-line permit payments.NET INCOME (LOSS) BEFORE($2,759,831.00) ($2,759,831.00) ($2,585,581.00) $174,250.00 -6.31%NON-OPERATING REVENUE/(EXPENSE)$212,600.00 $212,600.00 $340,400.00 127,800.00 60.11%Fav - Income from Investment $66,500 due to investment base and market rate fluctuations. Fav - Prior Years Adjustment $37,200 due to an adjustment for assets purchased and placed in service in FY 2023. Fav - Sale Of Equipment $23,000 due to equipment being sold at the Oakland County auction. TRANSFER IN - 215,000.00 222,200.00 7,200.00 3.35%Fav - Transfer In $7,200 due to the Water and Sewer fund transferring more funds to cover the increased cost for the Front-End loader.TRANSFERS (OUT) 278,419.00 451,562.00 451,562.00 - 0.00%NET REVENUES OVER (UNDER) EXPENSES*($2,825,650.00) ($2,783,793.00) ($2,474,543.00) $309,250.00 TOTAL NET POSITION - BEGINNING34,139,228.83$ TOTAL NET POSITION - ENDING31,664,685.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.45
COUNTY OF OAKLANDFY 2023 THIRD QUARTER REPORTINTERNAL SERVICE FUNDRISK MANAGEMENTADOPTED AMENDED FY 2023 VARIANCEBUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~ ~~~~~~~~~~~ ~~~~~~~~~~ ~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~LIABILITY INSURANCE FUND 67700OPERATING 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 $ 6,008,643.00 $ 5,763,192.00 245,451.00 4.08% - Fav. Salaries and Fringe Benefits $256,132 due to two vacant positions, Expendable Equipment $80,000 due to lower than anticipated use, Motor Pool $3,000 due to vehicle being fully depreciated, and Metered Postage $1,000 due to less than anticipated usage. Partially offset by unfav. Indirect Costs ($41,336) due to actual charges determined after budget finalization, Info Tech Development ($23,000) based on actual usage, Prior Year Adjustments ($13,400) due to invoices submitted after year-end, Info Tech Operations ($12,000) based on actual usage, Employee Medical Exams ($3,500)due to increased testing and Membership Dues ($1,045) and Motor Pool Fuel ($400) due to higher than anticipated usage.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,368,643.00 $ 9,123,192.00 245,451.00 2.62%OPERATING INCOME (LOSS)(79,728.00) (140,310.00)105,141.00 245,451.00 -174.93%NON-OPERATING REVENUE (EXPENSE) 150,000.00 150,000.00 50,000.00 (100,000.00) -66.67% - Unfav. due to lower than expected available cash balance.NET REVENUES OVER/(UNDER)*EXPENSES $ 70,272.00 $ 9,690.00 155,141.00 $ 145,451.00 TOTAL NET ASSETS - BEGINNING 334,946.59 TOTAL NET ASSETS - ENDING $ 490,087.59 46
COUNTY OF OAKLANDFY2023 THIRD QUARTER REPORTINTERNAL SERVICE FUNDS FRINGE BENEFITS FUNDADOPTED AMENDED FY 2023 VARIANCEFRINGE 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,437,337 - 0.00% RETIREMENT ADMINISTRATION - PTNE 350,000 350,000 230,000 (120,000) -34.29% - Unfav. due to actual revenues less than budget projections. DEFERRED COMPENSATION-MATCH 4,500,000 4,500,000 3,800,000 (700,000) -15.56% - Unfav. due to actual revenues less than budget projections. DEFINED CONTRIBUTION PLAN 24,000,000 24,000,000 25,000,000 1,000,000 4.17% - Fav. due to actual revenue higher than budget projections. DEFINED CONTRIBUTION PLAN - PTNE 200,000 200,000 220,000 20,000 10.00% - Fav. due to actual revenue higher than budget projections. EMPLOYEE IN-SERVICE TRAINING 1,872,722 1,872,722 1,900,000 27,278 1.46% - Fav. due to actual revenue higher than budget projections. EMPLOYEE BENEFITS UNIT 1,328,644 1,328,644 1,370,000 41,356 3.11% - Fav. due to actual revenue higher than budget projections. 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 5,000,000 1,200,000 31.58% - Fav. due to actual revenue higher than budget projections. GROUP LIFE INSURANCE 680,000 680,000 610,000 (70,000) -10.29% - 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 30,200,000 (9,746,197) -24.40% - Unfav. due to actual revenue less than budget projections. PRESCRIPTION COVERAGE INSURANCE 13,000,000 13,000,000 10,000,000 (3,000,000) -23.08% - Unfav. due to actual revenue less than budget projections. DENTAL INSURANCE 3,305,000 3,305,000 3,700,000 395,000 11.95% - Fav. due to actual revenue higher than budget projections. VISION INSURANCE98,500 98,500 342,000 243,500 247.21% - Fav. due to actual revenue more than budget projections. DISABILITY INSURANCE4,200,000 4,200,000 4,000,000 (200,000) -4.76% - Unfav. due to actual revenue less than budget projections, offset by favorable Disability Insurance expense. WORKERS COMPENSATION3,342,722 3,342,722 2,800,000 (542,722) -16.24% - Unfav. due to lower costs associated with Workers Compensation claims. UNEMPLOYMENT COMPENSATION300,000 300,000 300,000 - 0.00% INVESTMENT INCOME1,500,000 1,500,000 1,500,000 - 0.00% EXT - DENTAL INSURANCE20,000 20,000 10,000 (10,000) -50.00% - Unfav. due to actual revenue less than budget projections. EXT - FLEX BEN ARREARAGES- - - - 0.00% EXT - FLEX BEN DENTAL INSURANCE175,000 175,000 175,000 - 0.00% EXT - FLEX BEN LIFE INSURANCE520,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 INSURANCE150,000 150,000 150,000 - 0.00% EXT - FORFEITURE OF DEPOSITS & DC PLAN- - - - 0.00% EXT - MEDICAL INSURANCE 180,000 180,000 456,000 276,000 153.33% - 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 2,000 (18,000) -90.00% - Unfav. due to actual revenue less than budget projections. 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 162,698,997 (9,145,785) -5.32%47
COUNTY OF OAKLANDFY2023 THIRD QUARTER REPORTINTERNAL SERVICE FUNDS FRINGE BENEFITS FUNDADOPTED AMENDED FY 2023 VARIANCEFRINGE 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 DEFERRED COMP-COUNTY PMTS (MATCH) 4,524,000 4,591,000 4,000,000 591,000 12.87% - Fav. due to lower than expected employee participation in the Deferred Comp - CountyPayments (Match) program. 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,136,000 364,503 121.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 154,400 54,341 26.03% - Fav. Salaries and Fringes $47,000 due to part-time position and Travel and Conference $7,000 due to less than expected costs associated with travel and EMPLOYEE BENEFITS UNIT 1,216,587 1,216,587 831,200 385,387 31.68% - 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 INSURANCE4,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 COMPENSATION3,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 COMPENSATION300,000 300,000 300,000 - 0.00% CHILD CARE FACILITY301,838 301,838 301,838 - 0.00% HEALTH INSURANCE PREMIUM TAX- - - - MICHIGAN IPAA TAX15,000 15,000 15,000 - PATIENT CENTERED OUTCOME RESEARCH28,000 28,000 28,000 - 0.00% INDIRECT COSTS260,000 260,000 200,000 60,000 23.08% - Fav. due to projected charges developed after budget finalization. PENALTIES- - - - TOTAL EXPENSE147,911,464 147,981,814 145,903,493 2,078,321 1.40%NET REVENUE OVER/(UNDER) EXPENSES 23,933,318.00 23,862,968.00 16,795,504 (11,224,106) TOTAL NET ASSETS - BEGINNING386,553,155 TOTAL NET ASSETS - ENDING403,348,659 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 ACFR. {print "selection";1;9999;1;1}48
COUNTY OF OAKLANDFY 2023 THIRD QUARTER REPORTENTERPRISE FUNDSECONOMIC DEVELOPMENTADOPTED AMENDED FY 2023 VARIANCEBUDGET 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,152,775.00$350,400.006.04% - Fav. Land Lease $157,000 due to an increase in tenant leases. Reimb US Customs Service $100,000 due to higher than anticipated international travel and changes in Custom fee processing. T Hangar Rental $45,600 due to an increase in T-hangar rentals. Aviation Gas $19,000 due to current fuel costs and increased usage.OPERATING EXPENSE7,073,309.00 7,253,309.00 7,530,609.00 (277,300.00) -3.82% - Unfav. US Customs Services $150,000 due to increased rates. Ground Maintenance $108,400 due to costs for mulching and vegetation treatments. Professional Services $61,800 due to pending reimbursement for projects. Info Tech Development $23,000 due to actual IT hours charged for software upgrade. Partially offset by favorable Salary and Fringe Benefits $66,000 due to vacant position. Building Maintenance Charges $29,000 due to less than anticipated repairs.NET OPERATING INCOME (LOSS) ($1,420,934.00) ($1,450,934.00) ($1,377,834.00)$73,100.00-5.04%NON-OPERATING REVENUE (EXPENSE)150,000.00 150,000.00 150,000.00 - 0.00% -TOTAL INCOME BEFORECONTRIBUTIONS AND TRANSFERS (1,270,934.00) (1,300,934.00) ($1,227,834.00) 73,100.00 -5.62%TRANSFERS INTRANSFERS OUT - - - - CAPITAL CONTRIBUTION - - 70,000.00 70,000.00 0.00% - Fav. Capital Contributions - Federal Grant $70,000 for capital grants received in FY 2023.TOTAL NET INCOME (LOSS) ($1,270,934.00) ($1,300,934.00) ($1,157,834.00) $143,100.00TOTAL NET ASSETS - BEGINNING 77,506,069.73$ TOTAL NET ASSETS - ENDING 76,348,235.73$ 49
COUNTY OF OAKLANDFY 2023 THIRD QUARTER FORECASTINTERNAL SERVICE FUNDSFACILITIESADOPTED AMENDED FY 2023VARIANCEBUDGET 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,384,834.00 8,926,834.00 (458,000.00) -4.88% - Unfav. Leased Equipment ($538,000) due to actual activity trends to date and also attributed to the delay in new product delivery, Productive Labor ($64,000) due to less than anticipated charges and Sublet Repairs ($32,000) due to decreased repairs to department owned vehicles; Fav. Gasoline, Oil & Grease Charges $176,000 due to current fuel costs (partially offset by unfavorable Gasoline expense). Total Revenue 9,123,108.00 9,514,834.00 9,056,834.00 (458,000.00) OPERATING EXPENSE 10,010,769.00 10,327,564.00 10,939,464.00 (611,900.00) -5.92% - Unfav. Parts and Accessories ($203,000) due to the cost of parts increasing, Gasoline Charges ($168,300) due to market fluctuations and miles driven (offset by favorable Gasoline, Oil Grease Charges revenue), Insurance Reserve Expense ($110,000) due to higher costs associated with garage owned vehicles involved in accidents, Indirect Costs ($65,100) due to the development of actual charges after budget finalization, Sublet Repairs ($40,000) due to higher individual repair costs for vehicles sent out for repair (partially offset by Ext-Warranty Reimbursements) and Insurance ($25,500) due to more than anticipated insurance costs.OPERATING INCOME (LOSS) (887,661.00) (812,730.00) (1,882,630.00) (1,069,900.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) BEFOREOPERATING TRANSFERS (344,961.00) (270,030.00) (1,039,930.00) (769,900.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$ 515,377.00$ (254,523.00)$ (769,900.00)$ TOTAL NET ASSETS - BEGINNING12,061,250.24$ TOTAL NET ASSETS - ENDING 11,806,727.24$ 9/15/202350
FY 2023 THIRD QUARTER REPORTINTERNAL SERVICE FUND FACILITIES MANAGEMENTADOPTED AMENDED FY 2023VARIANCEBUDGET BUDGET FORECAST FAV/(UNFAV) PERCENTEXPLANATION OF SIGNIFICANT VARIANCES~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~ ~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~FACILITIES MAINTENANCE & OPERATIONS (#63100)OPERATING REVENUES: Outside Revenue 538,363.00$ 538,363.00$ 568,363.00$ 30,000.00$ 5.57% 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 ($5,000) primarily 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,440,728.00 (75,000.00) -0.27% Unfav. $75,000 primarily due to Maintenance Dept Charges based on Department requests. Total Revenue 28,054,091.00$ 28,054,091.00$ 28,009,091.00$ (45,000.00)$ -0.16%OPERATING EXPENSES 30,924,598.00$ 30,780,343.00$ 30,165,343.00$ 615,000.00$ 2.00% Fav. Salaries and Fringe Benefits $925,000 due to turnover, underfilled and vacant positions; Electrical Service $350,000 due to lower-cost third-party contracts and savings from FM&O energy conservation initiatives; Water & Sewage Charges $225,000 as well as Garbage and Rubbish Disposal $50,000 based on actual usage; Material and Supplies $150,000 due to a delayed lead time for materials impacting delivery of goods; Professional Services $150,000 due to timing of design engineering services for current projects; Info Tech Operations $125,000 due to less than anticipated usage; Info Tech Development $75,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 ($975,000) due to increase in demand for critical repair work needs, contractor price increases, and aging infrastructure; Maintenance Supplies ($425,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 ($85,000) due to current market conditions.BUDGETED EQUITY ADJUSTMENTS-$ 8,306.00$ -$ -$ 0.00% Fav. due to funding to purchase furniture for use within the FM&O Grounds Maintenance Division.NET INCOME (LOSS) BEFOREOPERATING TRANSFERS (2,870,507.00)$ (2,734,558.00)$ (2,156,252.00)$ 570,000.00$ NON-OPERATING REVENUE 140,000.00$ 140,000.00$ 90,000.00$ (50,000.00)$ -35.71% Unfav. Gain on Sale of Equipment ($40,000) due to delay in the sale of equipment. Unfav. Income from Investments ($10,000) due to investment base and market rate adjustments.COUNTY OF OAKLAND51
FY 2023 THIRD QUARTER REPORTINTERNAL SERVICE FUND FACILITIES MANAGEMENTADOPTED AMENDED FY 2023VARIANCEBUDGET BUDGET FORECAST FAV/(UNFAV) PERCENTEXPLANATION OF SIGNIFICANT VARIANCES~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~ ~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~COUNTY OF OAKLANDTRANSFERS IN -$ 8,306.00$ 8,306.00$ -$ 0.00%TRANSFERS OUT -$ -$ (52,843.00)$ (52,843.00)$ 0.00% Unfav. due to vehicle equipment upgrades.NET REVENUES OVER(UNDER) EXPENSES* (2,730,507.00)$ (2,586,252.00)$ (2,110,789.00)$ 467,157.00$ TOTAL NET POSITION - BEGINNING 8,635,092.51$ TOTAL NET POSITION - ENDING 6,524,303.51$ *Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category.52
FY 2023 THIRD QUARTER REPORTINTERNAL SERVICE FUNDS / ENTERPRISE FUNDINFORMATION TECHNOLOGYADOPTEDAMENDEDFY 2023VARIANCEBUDGETBUDGETActualFAV/(UNFAV)PERCENTEXPLANATION OF SIGNIFICANT VARIANCES()OPERATING REVENUES: Outside2,585,225.00$ 2,585,225.00$ 4,891,925.00$ 2,306,700.00$ 89.23% - Fav. Enhanced Access Fees $2,262,200, Outside Agencies $16,600 and Sale of Equipment $27,900 due to higher than anticipated usage. Inside34,561,125.00 34,952,015.00 35,781,115.00 829,100.00 2.37% - Fav. OC Depts Operations & Non Governmental Operations $418,400 and OC Depts Development Support & Non Governmental Development $406,300 due to increased rates and FOIA Fees $4,400 due to lower than anticipated costs.TOTAL OPERATING REVENUE37,146,350.00$ 37,537,240.00$ 40,673,040.00$ 3,135,800.00$ 8.35%OPERATING EXPENSES54,609,499.00 55,409,119.00 57,113,319.00 (1,704,200.00) -3.08% - Unfav. Professional Services ($2,842,600) due to projects previously approved in prior year; Software Maintenance ($1,016,400) due to; Charge Card Fees ($521,800) and Bank Charges ($15,300) for credit card activity; Parts and Accessories ($298,400) and Communications ($96,800) due to higher than anticipated costs; Indirect Costs ($215,200), Equipment Maintenance ($489,400), Maintenance Contracts ($94,300) and Supplies ($1,100) due to increased activity; Depreciation ($10,000) based on depreciation schedule. Offset by fav. Salaries and Fringes $2,088,800 due to vacanies; Exp Equipment $1,491,900 for equip replacement; Internal Services $291,400 is primarily due to fav. Insurance Fund; Travel $15,000, Garbage & Rubbish Disposal $5,900, Membership Dues $2,900 and Auction $1,200 due to usage..NET INCOME (LOSS) BEFOREOPERATING TRANSFERS(17,463,149.00)$ (17,871,879.00)$ (16,440,279.00)$ 1,431,600.00$ -8.01%NON-OPERATING REVENUE70,500.00$ 70,500.00$ 73,300.00$ 2,800.00$ 3.97%TRANSFERS IN7,921,944.00$ 8,468,169.00$ 8,468,169.00$ -$ 0.00%TRANSFERS (OUT)-$ -$ -$ -$ 0.00%CAPITAL CONTRIBUTION-$ -$ -$ -$ 0.00NET REV OVER(UNDER) EXP*(9,470,705.00)$ (9,333,210.00)$ (7,898,810.00)$ 1,434,400.00$ TOTAL NET POSITION - BEGINNING 43,884,644.55$ TOTAL NET POSITION - ENDING 35,985,834.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)53
FY 2023 THIRD QUARTER REPORTINTERNAL SERVICE FUNDS / ENTERPRISE FUNDINFORMATION TECHNOLOGYADOPTEDAMENDEDFY 2023VARIANCEBUDGETBUDGETActualFAV/(UNFAV)PERCENTEXPLANATION OF SIGNIFICANT VARIANCES()OPERATING REVENUES: Outside12,000.00$ 12,000.00$ 5,500.00$ (6,500.00)$ -54.17% Unfav. Sale of Phone External due to decreased usage of land lines. Inside3,595,361.003,595,361.004,098,761.00$ 503,400.00$ 14.00% Fav. Sale of Phone due to cell phone usage. TOTAL OPERATING REVENUE3,607,361.00$ 3,607,361.00$ 4,104,261.00$ 496,900.00$ 13.77%OPERATING EXPENSES3,601,223.00$ 3,601,223.00$ 4,518,023.00$ (916,800.00)$ -25.46% Unfav. Communications ($1,609,500) and Maintenance Equipment (249,800) due to higher than anticipated cost; Internal Services ($61,400) primarily due to Info Tech Operations ($14,900) and Telephone ($46,700) and Membership Dues ($700) based on actual usage; Indirect Cost ($60,800) due to actual charges being developed after budget finalization. Partially offset by fav. Contracted Services $989,200 and Equipment Repairs and Maintenance $2,500; due to less than anticipated activity; Expendable Equipment $47,100 for equipment replacement; Sublet Repairs $24,700 due to lower than anticipated repair volume; Fav. Salaries & Fringes $2,000 due to less than anticipated overtime.NET INCOME (LOSS) BEFOREOPERATING TRANSFERS6,138.00$ 6,138.00$ (413,762.00)$ (419,900.00)$ NON-OPERATING REVENUE30,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$ (383,762.00)$ (419,900.00)$ TOTAL NET POSITION - BEGINNING 2,119,432.74$ TOTAL NET POSITION - ENDING 1,735,670.74$ *Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category.Information Technology - Telephone Communications (67500)54
FY 2023 THIRD QUARTER REPORTINTERNAL SERVICE FUNDS / ENTERPRISE FUNDINFORMATION TECHNOLOGYADOPTEDAMENDEDFY 2023VARIANCEBUDGETBUDGETActualFAV/(UNFAV)PERCENTEXPLANATION OF SIGNIFICANT VARIANCES()Information Technology - CLEMIS (53500)OPERATING REVENUES: Outside 5,250,130.00$ 5,250,130.00$ 5,466,930.00$ 216,800.00$ 4.13% Fav. In-Car Terminals (External) $43,400 for fleet of CLEMIS agencies; Access Fees Non Oakland $36,600 and Rebilled harges $103,600 due to updated law enforcement Full Time Equivalent count used for billing. Also fav. CLEMIS Crash $37,700 due to increased usage by Oakland and non-Oakland agencies and CLEMIS Citation $200. Partially offset by unfav. Crime Mapping ($1200), Parts and Accessories ($2,800) and CLEMIS Parking ($700) due to decreased activity. Inside 1,776,737.00 1,782,936.00 1,728,936.00 (54,000.00)$ -3.03% Unfav. Reimb General ($40,000) based on actuals for CLEMIS staff supporting Sheriff project; In-Car Terminal ($12,400) due to participation count higher than budget projection and OC Depts Operations ($2,200) based on anticipated CLEMIS staff resources supporting Sheriff projects. Offset by fav, FOIA Fees $600. TOTAL OPERATING REVENUE 7,026,867.00$ 7,033,066.00$ 7,195,866.00$ 162,800.00$ 2.31%OPERATING EXPENSES 12,538,963.00$ 12,538,963.00$ 11,592,163.00$ 946,800.00$ 7.55% Fav. Depreciation $1,491,400 based on depreciation schedule; Salaries and Fringes $630,800 due to vacanies; Equipment Maintenance $268,800 due to lower than anticipated hardware maintenance costs; Software Maintenance $159,200 due to timing of software support; Parts and Accessories $22,200 due to usage and Indirect Cost $17,500. Offset by unfav. Internal Services ($615,600) primarily due to IT Development; Software Rental ($155,900)and Small Tools ($500)due to decreased costs; Professional Services ($722,900) and Contracted Services ($83,800) due to higher than anticipated contractual costs for staffing services. Also, unfav. Rebillable Services ($50,400) based on actual connectivity costs to Tier 2.5 and Charge Card Fees ($14,000) for increased credit card activity. NET INCOME (LOSS) BEFOREOPERATING TRANSFERS (5,512,096.00)$ (5,505,897.00)$ (4,396,297.00)$ 1,109,600.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,717,111.00) 1,109,600.00$ TOTAL NET POSITION - BEGINNING 7,596,587.24TOTAL NET POSITION - ENDING 4,879,476.24Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses.55
FY 2023 THIRD QUARTER REPORTINTERNAL SERVICE FUNDS / ENTERPRISE FUNDINFORMATION TECHNOLOGYADOPTEDAMENDEDFY 2023VARIANCEBUDGETBUDGETActualFAV/(UNFAV)PERCENTEXPLANATION OF SIGNIFICANT VARIANCES()OPERATING REVENUES: Outside 9,265,600.00$ 9,265,937.00$ 10,235,837.00$ 969,900.00$ 10.47% Fav. E911 Surcharge $838,200 due to increased volume of users/receipt of 911 surcharge.; Antenna Site Mgmt. $125,000 due to updates in rental contracts and Outside Agency Revenue $6,700 due to lower non-emergency agencies than anticipated. Inside 491,829.00$ 491,829.00$ 363,629.00$ (128,200.00)$ -26.07% Unfav. Parts and Accessories ($120,500) and Productive Labor ($7,700) due to lower than anticpated reimbursement by participating agencies for equipment replacement.TOTAL OPERATING REVENUE 9,757,429.00$ 9,757,766.00$ 10,599,466.00$ 841,700.00$ 8.63%OPERATING EXPENSES 10,911,243.00$ 11,410,167.00$ 12,521,467.00$ (1,111,300.00)$ -9.74% Unfav. Exp Equipment ($788,500) for equipment replacement; Interest Expense ($442,300;Tower Charges ($310,000); Software Support Maintenance ($251,300) due to timing of Emergency Services lP Network Project; Indirect Costs ($12,500), Parts and Accessories ($24,800), Special Projects ($3,700) and Freight Express ($1,800) due to usage. Partially offset fav. Salaries and Fringes $294,600 dued to vacanies; Professional Services $322,000 due to decreased costs; Travel and Conference $22,400 due to less travel to conferences; Internal Services $73,000 primarily due to Info Tech CLEMIS and Electrical Service $7,700 and Supplies $3,900 due to lower than anticipated usage. NET INCOME (LOSS) BEFOREOPERATING TRANSFERS (1,153,814.00)$ (1,652,401.00)$ (1,922,001.00)$ (269,600.00)$ NON-OPERATING REVENUE 100,000.00$ 100,000.00$ 193,800.00$ 93,800.00$ 93.80%TRANSFERS IN 24,000.00$ 743,524.00$ 743,524.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,094,877.00)$ (1,270,677.00)$ (175,800.00)$ TOTAL NET POSITION - BEGINNING 46,911,499.18$ TOTAL NET POSITION - ENDING 45,640,822.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.Information Technology - Radio Communications (53600)56
FY 2023 THIRD QUARTER REPORTINTERNAL SERVICE FUNDS / ENTERPRISE FUNDINFORMATION TECHNOLOGYADOPTEDAMENDEDFY 2023VARIANCEBUDGETBUDGETActualFAV/(UNFAV)PERCENTEXPLANATION OF SIGNIFICANT VARIANCES()Fire Records Management ( 53100)OPERATING REVENUES: Outside346,295.00$ 346,295.00$ 346,895.00$ 600.00$ 0.17% Fav. primarily due to Participation Fee Revenue..TOTAL OPERATING REVENUES346,295.00$ 346,295.00$ 346,895.00$ 600.00$ 0.17%OPERATING EXPENSES1,107,597.00$ 1,107,597.00$ 1,287,497.00$ (179,900.00)$ -16.24% Unfav. Internal Services ($270,900) primarily due to IT Development; Professional Services ($8,800) due to increased activity; Indirect Costs ($1,800) and Software Maintenance ($300). Partially offset by fav. Salaries and Fringes $100,900 due to vacanies and Equipment Maintenance $1,000 due to less than anticipated use.NET INCOME (LOSS) BEFOREOPERATING TRANSFERS(761,302.00)$ (761,302.00)$ (940,602.00)$ (179,300.00)$ NON-OPERATING REVENUE3,000.00$ 3,000.00$ 7,100.00$ 4,100.00$ 136.67% Fav. primarily due to Interest Income; higher cash balance than anticipated.TRANSFERS IN504,611.00$ 504,611.00$ 506,311.00$ 1,700.00$ 0.34%TRANSFERS (OUT)-$ -$ -$ - 0.00%CAPITAL CONTRIBUTION-$ -$ -$ - 0.00%NET REV OVER(UNDER) EXP*(253,691.00)$ (253,691.00)$ (427,191.00)(173,500.00)TOTAL NET POSITION - BEGINNING1,399,590.62$ TOTAL NET POSITION - ENDING972,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.57
Receipt Number Amount Journal Number
4/1/2023 Carlisha Harbert 94734 $0.55 CS011728
4/1/2023 Aeriel Brenner 94737 $0.55 CS011728
4/1/2023 Thomas Baltrusaitis 94756 $4.25 CS011728
4/1/2023 Mackenzie Fisher 94757 $0.25 CS011728
4/1/2023 Lisa Vanophem 94758 $0.80 CS011728
4/2/2023 Drew Kimmel 94769 $0.55 CS011728
4/2/2023 Drew Kimmel 94770 $0.55 CS011728
4/2/2023 John Paul Jones 94774 $10.00 CS011728
4/2/2023 Tarissa O'Malley 94776 $0.80 CS011728
4/3/2023 Monica Labib 94793 $0.25 CS011728
4/3/2023 Jeremy Scherer 94801 $58.80 CS011728
4/3/2023 Miwa Ainsworth 94806 $0.80 CS011728
4/3/2023 Rebecca Buffa 94816 $500.00 CS011728
4/3/2023 Jeffrey Wilcox 94836 $24.00 JE012378
4/3/2023 Tom Zabawa 94843 $5.00 CS011728
4/3/2023 David Keller 94846 $5.00 CS011728
4/4/2023 Jack Putnam 94854 $100.00 JE012348
4/4/2023 Mercedes Marshall 94855 $100.00 JE012348
4/4/2023 Mark Mudd 94860 $5.00 JE012348
4/4/2023 Mark Sepanski 94869 $130.00 JE012348
4/4/2023 Heidi Stamper 94871 $0.80 CS011728
4/4/2023 Bridget Staruch 94872 $5.00 CS011728
4/4/2023 David Pasko 94894 $0.25 CS011728
4/4/2023 Donation Box 94908 $56.00 JE012432
4/4/2023 Lisa Owens 94912 $5.00 CS011728
4/4/2023 Arun DeSouza 94917 $10.00 CS011728
4/4/2023 Karly Kimble 94919 $0.55 CS011728
4/5/2023 Amy Niwa 94915 $0.16 CS011728
4/5/2023 Aaron Jefferson 94924 $2.90 CS011728
4/5/2023 Kris Harroun 94927 $0.80 CS011728
4/5/2023 Bernadette Tomko 94944 $150.00 JE012431
4/5/2023 Claudia Duran 94949 $9.55 CS011728
4/5/2023 elaine Hoffman 94964 $0.55 CS011728
4/5/2023 elaine Hoffman 94965 $0.25 CS011728
4/5/2023 Candice Gish 94974 $5.00 CS011728
4/5/2023 Brittanie Menger 94978 $10.00 CS011728
4/5/2023 Emily Kelly 94983 $5.00 CS011728
4/6/2023 Angie Dickey 95007 $5.00 CS011728
4/6/2023 Dustin Barber 95012 $160.00 JE01232
4/6/2023 Scott Tolonen 95032 $5.00 CS011728
4/7/2023 Meredith Buckley 95056 $50.00 CS011728
4/7/2023 Zenia Elsharrak 95062 $5.00 CS011728
4/7/2023 Marcos Shimakura 95065 $5.00 CS011728
4/7/2023 Janice VandenHeuvel 95068 $0.80 CS011728
4/7/2023 Drew Galasso 95071 $5.00 CS011728
4/7/2023 Morgan McDonald 95075 $0.10 CS011728
4/7/2023 Susan Eichorst 95085 $5.00 CS011728
4/7/2023 Kelly Crake 95088 $0.80 CS011728
4/7/2023 Kelly Weidemann 95101 $100.00 JE012594
Date of Donation Person Donating
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - 3rd Quarter Donations FY 2023
58
4/7/2023 Jennifer Jackson 95102 $0.55 CS011728
4/7/2023 Sara gonsler 95104 $0.80 CS011728
4/7/2023 Barbara Strnad 95140 $5.00 CS011728
4/7/2023 Sandeep Hukku 95166 $5.00 CS011728
4/8/2023 Caroline Watros 95125 $10.00 CS011728
4/8/2023 Ciara Harvey 95143 $0.25 CS011728
4/8/2023 Jayne Lanigan 95148 $23.80 CS011728
4/8/2023 Monet Potter 95153 $10.00 CS011728
4/8/2023 Taylor Orebaugh 95154 $0.55 CS011728
4/8/2023 Heather Schomberg 95157 $0.80 CS011728
4/9/2023 Jeremy Thurston 95133 $5.00 CS011728
4/9/2023 Craig Pavlock 95134 $0.25 CS011728
4/9/2023 Jennifer Elmore 95161 $5.00 CS011728
4/9/2023 Eric Wessels 95162 $5.00 CS011728
4/10/2023 Todd Jonckheere 95187 $0.25 CS011728
4/10/2023 Katherine Lorts 95190 $5.00 CS011728
4/10/2023 Jayson Graves 95191 $5.00 CS011728
4/10/2023 Kyle Tremberth 95195 $5.00 CS011728
4/10/2023 Anne Burns 95197 $6.00 JE012594
4/10/2023 Christina Brunke 95209 $0.25 CS011728
4/10/2023 Marisa Reyes 95218 $40.00 CS011728
4/10/2023 Marcia Orlet 95227 $10.00 CS011728
4/10/2023 Tzvi Tanenbaum 95229 $5.00 CS011728
4/10/2023 Martin Miller 95233 $0.80 CS011728
4/10/2023 Kay Fracassa 95241 $20.00 CS011728
4/10/2023 Ning An 95307 $0.80 CS012077
4/11/2023 Lynnette Laure 95246 $10.00 CS012077
4/11/2023 Chris Johnston 95256 $5.00 CS012077
4/11/2023 Elizabeth Burns 95259 $0.10 CS012077
4/11/2023 Mel Foster 95260 $10.00 CS012077
4/11/2023 Edward Jones 95274 $1.83 CS012077
4/11/2023 Timothy Ginster 95283 $0.55 CS012077
4/11/2023 Mary Jocque 95292 $0.80 CS012077
4/11/2023 Michelle Hucal 95296 $0.80 CS012077
4/11/2023 Michelle Hucal 95297 $0.80 CS012077
4/11/2023 Stephanie Brown 95303 $0.55 CS012077
4/11/2023 Tammy Strock 95304 $0.10 CS012077
4/11/2023 Don Pace 95320 $5.00 CS012077
4/11/2023 Dale Rife 95327 $10.00 CS012077
4/11/2023 Lisa Willcock 95335 $0.55 CS012077
4/11/2023 Skye Calo 95337 $10.00 CS012077
4/12/2023 Donna Mazzenga 95336 $5.00 CS012077
4/12/2023 Donna Mondell 95339 $25.00 CS012077
4/12/2023 Alfred Demailo 95346 $100.00 CS012077
4/12/2023 John Little 95350 $5.00 CS012077
4/12/2023 Donation Box 95352 $3.60 CS012077
4/12/2023 Audrey Kalasky 95355 $120.00 CS012077
4/12/2023 Catherine Stephan 95361 $0.55 CS012077
4/12/2023 Jill Hartwig 95390 $10.00 CS012077
4/12/2023 Pamela Good 95394 $20.00 CS012077
4/12/2023 Michelle Strube 95411 $5.00 CS012077
4/12/2023 Danielle Alexander 95420 $0.60 CS012077
59
4/12/2023 Shannon Wichar 95426 $5.00 CS012077
4/13/2023 Melissa Catwright 95431 $0.55 CS012077
4/13/2023 Heather Harris 95440 $5.00 CS012077
4/13/2023 Matt Alward 95443 $20.00 CS012077
4/13/2023 Joel Cartwright 95447 $5.00 CS012077
4/13/2023 Tom Siwek 95450 $5.00 CS012077
4/13/2023 Destiny Crawford 95459 $3.00 CS012077
4/13/2023 Natalie Simons 95493 $0.55 CS012077
4/13/2023 Andrea Almanza 95494 $5.00 CS012077
4/13/2023 Kathy Campau 95496 $10.00 CS012077
4/14/2023 Nishanth Varanasi 95505 $0.55 CS012077
4/14/2023 Mark Pompetzki 95507 $10.00 CS012077
4/14/2023 Mica Lorenz 95508 $0.10 CS012077
4/14/2023 Blake Labaere 95520 $285.00 CS011985
4/14/2023 Denise Shuttie 95525 $50.00 CS012077
4/14/2023 Amy Barry 95535 $10.00 CS012077
4/14/2023 Batyr Karayev 95573 $100.00 CS011986
4/15/2023 Amber Mahan-Dissmore 95595 $0.80 CS012077
4/15/2023 Raymond Chan 95623 $0.55 CS012077
4/15/2023 Raymond Chan 95624 $0.55 CS012077
4/15/2023 Joshua Long 95626 $0.25 CS012077
4/15/2023 Domenico Luongo 95629 $10.00 CS012077
4/15/2023 Eric Driscoll 95637 $0.25 CS012077
4/16/2023 Alicia Kwasneski 95602 $5.00 CS012077
4/16/2023 Heidi Petit 95603 $5.00 CS012077
4/16/2023 Steven Sparks 95640 $10.00 CS012077
4/16/2023 Kacie Farrell 95642 $0.25 CS012077
4/16/2023 Samantha Brown 95644 $0.80 CS012077
4/16/2023 Karen Zelony 95645 $20.00 CS012077
4/16/2023 Charlie Coburn 95647 $5.00 CS012077
4/16/2023 Sue Beresford 95652 $10.00 CS012077
4/16/2023 Ally Brozik 95661 $0.80 CS012077
4/17/2023 Tracy Campell 95639 $5.00 CS012077
4/17/2023 Corentin LeBris 95677 $0.55 CS012077
4/17/2023 Brenda Reyes-Mezza 95694 $5.00 CS012077
4/17/2023 Teresa Brumley 95698 $0.50 CS012077
4/17/2023 Catherine Lukes 95722 $5.00 CS012077
4/17/2023 Diane Rizzo 95724 $5.00 CS012077
4/17/2023 Bethany Heike 95741 $0.80 CS012077
4/18/2023 Shaun Brautigan 95739 $10.00 CS012077
4/18/2023 Tina Banbard 95754 $0.35 CS012077
4/18/2023 Denis Kansier 95765 $10.00 CS012077
4/18/2023 Stacy Ayers 95768 $10.00 CS012077
4/18/2023 Michelle Keydel 95784 $5.00 CS012077
4/18/2023 Craig Confer 95785 $20.00 CS012077
4/18/2023 Janelle Ruth 95788 $0.80 CS012077
4/18/2023 Jason Barnes 95790 $5.00 CS012077
4/19/2023 Joe Kosik 95795 $10.00 CS012077
4/19/2023 Laurie Welsh 95798 $100.00 CS012083
4/19/2023 Melissa Moore 95800 $5.00 CS012077
4/19/2023 Mikayla Viel 95812 $5.00 CS012077
4/19/2023 Megan Rasaiah 95818 $0.55 CS012077
60
4/19/2023 Matthew McKiernan 95822 $20.00 CS012077
4/19/2023 Martin King 95828 $20.00 CS012077
4/19/2023 Karen Miller 95830 $0.80 CS012077
4/19/2023 Albert Wellein 95833 $10.00 CS012077
4/21/2023 Barry Gross 95883 $25.00 CS012219
4/21/2023 Mary Ann Bendure 95885 $25.00 CS012119
4/20/2023 Nikki Follis 95839 $0.55 CS012659
4/20/2023 Toni Spencer 95842 $0.25 CS012659
4/20/2023 Taylor Cooper 95843 $0.55 CS012659
4/20/2023 Dan Ziots 95850 $5.00 CS012659
4/20/2023 Naoko Hong 95854 $0.90 CS012659
4/20/2023 Jennifer Gandolfo 95863 $10.00 CS012659
4/20/2023 Patricia Toma 95859 $0.80 CS012659
4/20/2023 Heather Coleman-Voss 95861 $5.00 CS012659
4/20/2023 William Cho 95865 $4.55 CS012659
4/20/2023 Stacy Farris 95903 $10.00 CS012659
4/20/2023 Pricilla Mouat 95891 $5.00 CS012659
4/21/2023 Sheila Crow 95913 $5.00 CS012659
4/21/2023 Matthew Dwyer 95926 $0.90 CS012659
4/21/2023 James Kurger 95930 $5.00 CS012659
4/21/2023 William Adolph 95971 $3.80 CS012659
4/21/2023 Kelly Sermo 95974 $5.00 CS012659
4/21/2023 Jillian Lippert 95952 $0.55 CS012659
4/22/2023 Steven Beylerian 95975 $10.00 CS012659
4/22/2023 Karl Steckling 95984 $10.00 CS012659
4/22/2023 Connie Awdish 95985 $0.50 CS012659
4/22/2023 Pauli Chhina 95987 $0.55 CS012659
4/23/2023 Sandra Siegel 95959 $0.55 CS012659
4/23/2023 Blake Meadows 95948 $0.55 CS012659
4/24/2023 Valerie Piontek 96001 $5.00 CS012659
4/24/2023 Amy Prahin 96004 $20.00 CS012659
4/24/2023 Angel Smiley 96040 $5.00 CS012659
4/24/2023 Joane Bageris 96037 $5.00 CS012659
4/24/2023 Pamela Stiles 96042 $5.00 CS012659
4/25/2023 Scott Rice 96050 $0.80 CS012659
4/25/2023 Lora Hogan 96055 $8,000.00 CS012659
4/25/2023 Jocie Ballmann 96079 $4.55 CS012659
4/25/2023 Debra Brandell 96116 $5.00 CS012659
4/25/2023 Patrick McCormick 96123 $5.00 CS012659
4/25/2023 OPAC - Donation Jar 96109 $82.00 CS012318
4/26/2023 Marci Frick 96135 $5.00 CS012659
4/26/2023 Ricardo Pinto 96156 $0.80 CS012659
4/26/2023 Karen Monette 96173 $0.10 CS012659
4/26/2023 Margaret Mary Lanivich 96171 $35.20 CS012659
4/27/2023 Abigail Beard 96189 $0.55 CS012659
4/27/2023 Kellee Duggan 96204 $45.50 CS012659
4/27/2023 LeAnn Capron 96215 $5.00 CS012659
4/27/2023 Candice Sanders 96221 $0.25 CS012659
4/27/2023 Melissa McCann 96247 $0.55 CS012659
4/27/2023 Daniel Sullivan 96222 $50.00 CS012318
4/28/2023 Sabrina Sutherland 96257 $0.55 CS012659
4/28/2023 Lisa Goldmann 96268 $5.80 CS012659
61
4/28/2023 Molly Degraff 96280 $0.80 CS012659
4/28/2023 Tracy Vibbart 96309 $0.80 CS012659
4/28/2023 Suresh Dareddy 96345 $0.80 CS012659
4/28/2023 James Kellner 96294 $60.00 CS012467
4/29/2023 David Yaklin 96346 $0.55 CS012659
4/29/2023 David Yaklin 96347 $0.55 CS012659
4/29/2023 David Yaklin 96348 $0.55 CS012659
4/29/2023 Patty Smiles 96312 $5.00 CS012659
4/29/2023 Jeffrey Hulderman 96350 $5.00 CS012659
4/29/2023 Michelle Pike 96355 $0.80 CS012659
4/29/2023 Melissa Chambers 96356 $1.20 CS012659
4/30/2023 Nathaniel Mynsberge 96363 $20.00 CS012659
4/30/2023 Mary Elizabeth Johnson 96326 $5.00 CS012659
4/30/2023 Cindie Sassons 96331 $20.00 CS012659
$11,452.64
Receipt Number Amount Journal Number
5/1/2023 Shawn Grant 96342 $0.80 CS012815
5/1/2023 Amy Darnell 96371 $0.55 CS012815
5/1/2023 Emily Starnes 96382 $0.80 CS012815
5/1/2023 Karen Zelony 96384 $100.00 CS012815
5/1/2023 Stacie Maruszewski 96402 $5.00 CS012815
5/1/2023 Richard Schiff 96405 $5.00 CS012815
5/1/2023 Cassidy Pumper 96407 $5.00 CS012815
5/1/2023 Allison Potter 96408 $2.00 CS012815
5/1/2023 Eva Januszewska 96414 $5.00 JE 013388
5/1/2023 Amanda Paava 96417 $20.00 CS012815
5/1/2023 Kirk Reed 96421 $75.00 JE 013388
5/1/2023 Kristina Mienaltowski 96435 $5.00 CS012815
5/1/2023 Jennifer Chambers 96441 $20.00 CS012815
5/1/2023 Jennifer Lambert 96443 $50.00 CS012815
5/1/2023 Ashley Piechorowski 96448 $1.00 CS012815
5/2/2023 VictoriaCarpenter 96476 $0.25 CS012815
5/2/2023 Catherine Grochowski 96486 $5.00 CS012815
5/2/2023 Kathy Zack 96489 $5.00 CS012815
5/2/2023 Jacquelyn Valente 96490 $20.00 CS012815
5/2/2023 Joyce Karagounis 96501 $5.00 CS012815
5/2/2023 Dawn Kwiecien 96514 $0.89 CS012815
5/2/2023 Gayla Bonner 96515 $0.10 CS012815
5/2/2023 Alan Aubuchon 96517 $5.00 CS012815
5/2/2023 Daniela Rivero 96518 $0.55 CS012815
5/3/2023 Kimberly Saks 96509 $22.00 JE013489
5/3/2023 Ashley Barno 96526 $0.25 CS012815
5/3/2023 Constance Litwin 96527 $10.10 CS012815
5/3/2023 Supreet Sandhu 96535 $0.25 CS012815
5/3/2023 Catherine Ollesheimer 96543 $8.80 CS012815
5/3/2023 Charles Nebus 96556 $5.00 JE013488
5/3/2023 Andrew Partyka 96557 $15.00 JE013488
5/3/2023 Jeri Hermanson 96576 $0.90 CS012815
5/3/2023 Heather Lifton 96578 $10.00 CS012815
5/3/2023 Jeanne Weaver 96581 $50.00 CS012815
5/3/2023 Justin Blankenship 96584 $5.00 CS012815
5/3/2023 Michele Jarvis 96586 $25.00 CS012815
April 2023 Total
Date of Donation Person Donating
62
5/4/2023 Rachel Preblich 96589 $0.80 CS012815
5/4/2023 Katherine Ashton 96606 $5.00 JE013614
5/4/2023 Pamela Mathews 96637 $1.89 CS012815
5/4/2023 Terri Burke 96639 $3.05 CS012815
5/4/2023 Nadine Dooley 96642 $0.55 CS012815
5/4/2023 Alfredo Mendoza 96649 $5.00 CS012815
5/5/2023 Matt McCleese 96656 $0.80 CS012815
5/5/2023 Barbara Young 96668 $20.00 JE013614
5/5/2023 Sharon Fine 96681 $5.00 CS012815
5/5/2023 Patricia Yanez 96734 $5.00 CS012815
5/6/2023 Amie King 96717 $0.55 CS012815
5/6/2023 Holly Marcone 96718 $20.00 CS012815
5/6/2023 Lawrence Marino 96735 $0.55 CS012815
5/7/2023 Brett Phillips 96712 $0.80 CS012815
5/7/2023 Gerald Boreland 96728 $0.55 CS012815
5/7/2023 Melinda Spada 96748 $0.80 CS012815
5/7/2023 Wendy Taube 96753 $5.00 CS012815
5/7/2023 Heather Groeger 96758 $10.00
5/8/2023 Donation Box 96704 $2.56 JE013614
5/8/2023 Alfred Demailo 96706 $100.00 JE013614
5/8/2023 Dean Atchison 96708 $150.00 JE013614
5/8/2023 Andrea Singer 96709 $50.00 JE013614
5/8/2023 Justin Bennett 96762 $0.55 CS012815
5/8/2023 Stacey Peterson 96763 $5.00 CS012815
5/8/2023 Peggy Prestol 96804 $0.55 CS012815
5/8/2023 Cecil Raitt 96815 $20.00 CS012815
5/8/2023 Renee Altwies 96879 $0.80 CS012815
5/8/2023 Cristina Aquino 96880 $10.00
5/8/2023 sherrie Westfall 96881 $5.00 CS012815
5/8/2023 Tommy Lam 96882 $5.00 CS013103
5/8/2023 Areej Alnaraie 96887 $0.80 CS012815
5/9/2023 Donation Box 96914 $20.00 JE013614
5/9/2023 James Falls 96915 $5.00 CS013103
5/9/2023 Samantha Zupancic 96930 $5.00 CS013103
5/9/2023 Peter Doyle 96932 $5.00 CS013103
5/9/2023 Lisa Jones 96934 $0.80 CS013103
5/9/2023 Melissa Feldman 96940 $5.00 CS013103
5/9/2023 Francis O'Donnell 96947 $10.00 CS013103
5/9/2023 Vivek Wali 96957 $0.35 CS013103
5/9/2023 Walled Lake Consolidated Schools 96966 $1,560.00 JE013614
5/9/2023 Michael Zdanio 96970 $5.00 CS013103
5/9/2023 Conne Terova 96973 $10.00 CS013103
5/9/2023 Michele Viviano 96975 $5.00 CS013103
5/9/2023 Kathy McLennan 96976 $5.00 CS013103
5/9/2023 Patricia Frazier 96980 $5.00 CS013103
5/9/2023 Patricia Frazier 96981 $5.00 CS013103
5/9/2023 Melissa Lipinski 96982 $2.00 CS013103
5/9/2023 Gabrielle DeConinck 96987 $0.25 CS013103
5/10/2023 Russell Pollock 96988 $0.80 CS013103
5/10/2023 Christianna Groves 96992 $0.55 CS013103
5/10/2023 Christianna Groves 96993 $10.00 CS013103
5/10/2023 Amber McKee 96997 $0.55 CS013103
63
5/10/2023 Kelley Halberstadt 97001 $0.55 CS013103
5/10/2023 Nancy Whitt 97011 $275.00 CS013103
5/10/2023 Melissa Briones-Carlson 97017 $10.00 CS013103
5/10/2023 Donation Box 97022 $69.00 JE013714
5/10/2023 Edward Mahl 97023 $50.00 JE013714
5/11/2023 Victoria Taylor 97058 $0.80 CS013103
5/11/2023 James Bicknell 97086 $40.00 CS013103
5/11/2023 Andrea Colville 97089 $0.25
5/11/2023 Comerica Accounts Payable 97099 $75.00 JE013829
5/11/2023 Emma Renusch 97110 $0.25 CS013103
5/11/2023 Ashley Hall 97112 $0.90 CS013103
5/11/2023 Harold Brock 97113 $5.00 CS013103
5/11/2023 Angela Ambuhl 97115 $0.25 CS013103
5/11/2023 Suzette Knapp 97222 $20.00 CS013103
5/12/2023 Jeff Farrell 97118 $0.80 CS013103
5/12/2023 Linnea Murray 97120 $10.00 CS013103
5/12/2023 Linnea Murray 97121 $10.00 CS013103
5/12/2023 Victoria Reifel 97127 $0.55 CS013103
5/12/2023 Paula Gelman 97130 $5.00 CS013103
5/12/2023 stephaie Isenarg 97146 $0.25 CS013103
5/12/2023 Rosana Burnette 97147 $23.00 JE013829
5/12/2023 Nick Waugh 97149 $0.55 CS013103
5/12/2023 Robert Fries 97154 $5.00 CS013103
5/12/2023 Michelle Harm 97163 $0.80 CS013103
5/12/2023 Justin Howard 97178 $0.25 CS013103
5/12/2023 Falyn Kowalski 97181 $5.00 CS013103
5/12/2023 Shawn Vidlund 97233 $0.55 CS013103
5/12/2023 Nicole Ettinger 97237 $5.00 CS013103
5/12/2023 John Walton 97238 $0.55 CS013103
5/12/2023 Dorimar Mercado 97252 $0.80 CS013103
5/12/2023 Michael Wilson 97323 $0.58 CS013103
5/12/2023 Michael Wilson 97324 $0.58 CS013103
5/12/2023 Melissa Bowman 97368 $0.80 CS013103
5/12/2023 Jamie Rogala 97370 $0.25 CS013103
5/12/2023 Chris Tait 97376 $0.80 CS013103
5/12/2023 Megan Spicer 97378 $0.55 CS013103
5/12/2023 Ana Garcia 97395 $5.00 CS013103
5/12/2023 Brian Wilson 100282 $5.00 CS013103
5/13/2023 Alison Payne 97246 $5.00 CS013103
5/13/2023 Ratna Mullapudi 97255 $5.00 CS013103
5/13/2023 Michele Green 97264 $70.00 CS013103
5/13/2023 Lauren Hermann 97285 $0.60 CS013103
5/13/2023 Torianna Catir 97458 $0.80 CS013103
5/13/2023 Aaron Lake 97463 $0.80 CS013103
5/13/2023 Stacey Whelan 97466 $5.00 CS013103
5/13/2023 Ray Clay 97476 $0.80 CS013103
5/13/2023 Ray Clay 97477 $0.55 CS013103
5/13/2023 Jaime Waterfield 97482 $5.00 CS013103
5/13/2023 Sharon Kupski 97486 $0.80 CS013103
5/13/2023 Sharon Kupski 97487 $0.80 CS013103
5/14/2023 James Bicknell 97235 $25.00 CS013103
5/14/2023 Chris Mounts 97236 $0.60 CS013103
64
5/14/2023 Jim Beattie 97275 $5.00 CS013103
5/14/2023 Lindsey Larivee 97277 $5.00 CS013103
5/14/2023 Jill Gentner 97279 $5.00 CS013103
5/14/2023 Neil Sever 97282 $10.00 CS013103
5/14/2023 Alexander Costa 97286 $0.10 CS013103
5/14/2023 Meg Heatley 97288 $0.10 CS013103
5/14/2023 Amir Chator 97296 $0.55 CS013103
5/14/2023 Athena Akram 97298 $0.55 CS013103
5/14/2023 Zac Bardsley 97301 $5.00 CS013103
5/14/2023 Nataliya Havrylyshyn 97320 $5.00 CS013103
5/14/2023 Virginia Fitzgerald 97404 $1.00 CS013103
5/14/2023 Cynthia Leist 97501 $0.89 CS013103
5/14/2023 Joel Smiler 97528 $10.00 CS013103
5/14/2023 Joel Smiler 97529 $10.00 CS013103
5/14/2023 Joel Smiler 97530 $10.00 CS013103
5/14/2023 Fe Quicho 97564 $5.00 CS013103
5/14/2023 Keiko Hansen 97569 $0.80 CS013103
5/14/2023 Patricia Dowhan 97574 $0.60 CS013103
5/14/2023 Patrick Carraher 97621 $10.00 CS013103
5/14/2023 Patrick Carraher 97622 $5.00 CS013103
5/15/2023 Silke Goudos 97330 $5.00 CS013103
5/15/2023 Silke Goudos 97331 $5.00 CS013103
5/15/2023 Kristen Kosciolek 97333 $0.55 CS013103
5/15/2023 Shamani Huruulle 97342 $5.00 CS013103
5/15/2023 Erica Harding 97345 $20.00 CS013103
5/15/2023 Renata Olivari Tumonis 97352 $5.00 CS013103
5/15/2023 Melissa Tompkins 97357 $5.00 CS013103
5/15/2023 Laura Bennett 97440 $10.00 CS013103
5/15/2023 Calvin Patel 97444 $0.25 CS013103
5/15/2023 Roberto Bernal Dominguez 97531 $5.00 CS013103
5/15/2023 Tyler Burns 97576 $0.60 CS013103
5/15/2023 Alex Molnar 97598 $0.90 CS013103
5/15/2023 Courtney Rose 97627 $5.00 CS013103
5/15/2023 Francine Chatlin 97656 $0.89 CS013103
5/15/2023 Barbara Ferrett 97709 $0.55 CS013103
5/15/2023 Alma Niza Segura Renaud 97729 $3.00 CS013103
5/15/2023 Howard Niskar 97732 $0.65 CS013103
5/15/2023 Brandie Walton 97748 $0.55 CS013103
5/15/2023 Kelly Powers 97754 $0.80 CS013103
5/15/2023 Steven Blazo 97760 $5.00 CS013103
5/16/2023 Rochelle Rosenberg 97421 $100.00 JE013829
5/16/2023 Mark Mudd 97427 $5.00 JE013829
5/16/2023 John Cackowski 97429 $25.00 JE013829
5/16/2023 Patricia Newbauer 97430 $100.00 JE013829
5/16/2023 Sharon Backstrom 97431 $500.00 JE013829
5/16/2023 Golling Chrysler Dodge Jeep 97436 $420.60 JE013829
5/16/2023 Bridget McRell 97459 $5.00 CS013103
5/16/2023 Donna Schoch 97543 $5.00 CS013103
5/16/2023 Cathy Squicciarini 97602 $5.00 CS013103
5/16/2023 Kimberly Spiris 97606 $5.00 CS013103
5/16/2023 Steven Schneider 97607 $10.00 CS013103
5/16/2023 Michael Mills 97633 $0.80 CS013103
65
5/16/2023 Rhonda Schupbach 97776 $55.00 CS013103
5/16/2023 Maureen Jenkinson 97802 $0.80 CS013103
5/16/2023 Cindy Tobin 97807 $0.55 CS013103
5/16/2023 Rochelle Freeman 97817 $0.80 CS013103
5/16/2023 Andy Brenz 97826 $10.00 CS013103
5/16/2023 Heather Schultz 97884 $0.55 CS013103
5/16/2023 Debbi Hinson 97888 $0.80 CS013103
5/16/2023 Susan Ciesielski 97891 $0.55 CS013103
5/16/2023 Carolyn Janosky 97892 $0.10 CS013103
5/16/2023 Genevieve Brewster 97893 $10.00 CS013103
5/16/2023 Debra Nolen 97898 $10.00 CS013103
5/16/2023 Tina Wade 97900 $0.80 CS013103
5/16/2023 David Call 97902 $5.00 CS013103
5/16/2023 Mary Woigdka 97903 $5.00 CS013103
5/16/2023 Mark Kuhn 97904 $5.00 CS013103
5/16/2023 Michelle Gray 98779 $20.00 CS013103
5/17/2023 Amy Murray 97623 $10.00 CS013103
5/17/2023 Jocelyn Reynoso 97624 $0.25 CS013103
5/17/2023 Debra Driscoll 97647 $5.00 JE013906
5/17/2023 Marilyn Perry 97650 $25.00 JE013905
5/17/2023 Barbara Torres 97662 $10.00 JE013905
5/17/2023 Anthony Brooklier 97667 $0.55 CS013103
5/17/2023 Roger Larson 97680 $5.00 CS013103
5/17/2023 Neal Gaberdiel 97684 $0.80 CS013103
5/17/2023 Brenda Ohryn 97687 $28.00 CS013103
5/17/2023 Jordan Garza 97692 $5.35 CS013103
5/17/2023 Chase Berzins 97696 $5.00 CS013103
5/17/2023 James Bicknell 97775 $40.00 CS013103
5/17/2023 Jeff Naumann 97906 $5.00 CS013103
5/17/2023 Brenda Mose 97911 $0.55 CS013103
5/17/2023 Greg Fraser 97931 $5.00 CS013103
5/17/2023 Jennifer Burnett 97932 $0.25 CS013103
5/17/2023 Richelle Szantner 97940 $50.00 CS013103
5/17/2023 Bobbi Jeffrey 97946 $0.55 CS013103
5/17/2023 Mona Cole 97958 $0.58 CS013103
5/17/2023 Dennis Yee 97980 $5.00 CS013103
5/17/2023 Robert Humphries 99652 $5.00 CS013103
5/17/2023 Rachel Walton 100351 $5.00 CS013103
5/17/2023 Celeste Marchand 97669 $0.45 CS013103
5/18/2023 Jordi Solano Sala 97720 $5.00 CS013103
5/18/2023 Tracy Sullivan 97779 $0.55 CS013103
5/18/2023 Susan Craig 97782 $5.00 CS013103
5/18/2023 Allison Basner 97784 $0.80 CS013103
5/18/2023 Amy Matelic 97823 $10.00 CS013103
5/18/2023 Benjamin Gray 97841 $5.00 CS013103
5/18/2023 Mary Stahl 97861 $5.00 CS013103
5/18/2023 Mary Stahl 97862 $5.00 CS013103
5/18/2023 Chelsea Pizzo 97864 $0.25 CS013103
5/18/2023 Xianjie Zhou 97869 $1.00 CS013103
5/18/2023 Danielle Diffin 97956 $5.00 CS013103
5/18/2023 Tracy Glass 97957 $5.00 CS013103
5/18/2023 Brian Penney 97983 $5.00 CS013103
66
5/18/2023 Kim Harlep 97987 $8.80 CS013103
5/18/2023 Crystal Sigler 97989 $5.00 CS013103
5/18/2023 Jennifer Howell 97990 $5.00 CS013103
5/18/2023 Marvin Bleiberg 97996 $5.00 CS013103
5/18/2023 David Tallman 98002 $20.00 CS013103
5/18/2023 Kate Kreider 98036 $5.00 CS013103
5/18/2023 Casey Littlejohn 98150 $0.80 CS013103
5/18/2023 Kristen Froehlich 98157 $0.60 CS013103
5/19/2023 Tiffany Willis 97882 $0.10 CS013385
5/19/2023 Jillian Mullins 97939 $0.80 CS013385
5/19/2023 Michele Cote 97949 $10.00 CS013385
5/19/2023 Amarji Ghuman 97970 $50.00 CS013385
5/19/2023 Deepa Vedapudi 97976 $5.00 CS013385
5/19/2023 Samantha Kapoor 98052 $5.00 CS013385
5/19/2023 Julie Miller 98060 $4.55 CS013385
5/19/2023 Anju Khurana 98216 $5.00 CS013385
5/19/2023 Jacob Kern 98217 $10.00 CS013385
5/19/2023 Joanne DeSana 98232 $0.80 CS013385
5/19/2023 Rodney Kiedrowski 98234 $5.00 CS013385
5/19/2023 Christina Wren-Keyandwy 98238 $5.10 CS013385
5/19/2023 Carrie Eldridge 98241 $0.90 CS013385
5/20/2023 Juliann Gallagher 98048 $5.00 CS013385
5/20/2023 Nicolas Lelievre 98063 $5.00 CS013385
5/20/2023 Linda Gale 98073 $5.00 CS013385
5/20/2023 Stephen Kehres 98077 $5.00 CS013385
5/20/2023 Jodell Wittenberg 98161 $5.00 CS013385
5/20/2023 Anna Guozzo 98260 $0.89 CS013385
5/21/2023 Joseph Maino 98100 $10.00 CS013385
5/21/2023 Madeline Andrews 98101 $0.55 CS013385
5/21/2023 Marcel Gard 98104 $5.00 CS013385
5/21/2023 Lai Ha Carrico 98278 $10.00 CS013385
5/21/2023 Lai Ha Carrico 98279 $10.00 CS013385
5/21/2023 Victor Rebella 98354 $5.00 CS013385
5/21/2023 Brianna Desa 98431 $5.00 CS013385
5/21/2023 Lea Wellette 98434 $8.80 CS013385
5/21/2023 Mark Gillim 98436 $5.00 CS013385
5/21/2023 Mark Gillim 98437 $5.00 CS013385
5/21/2023 Mark Gillim 98438 $5.00 CS013385
5/21/2023 Alicea Kew 98439 $0.80 CS013385
5/21/2023 Steven Luepke 98440 $0.80 CS013385
5/21/2023 Julie Rule 98441 $0.80 CS013385
5/21/2023 Chris Giotlitti 98442 $0.55 CS013385
5/21/2023 Angela Schaefer 98443 $5.00 CS013385
5/22/2023 Donation Box 98038 $6.85 JE014036
5/22/2023 North American Lighting 98046 $98.00 JE014036
5/22/2023 Linda Fonger 98047 $75.00 JE014036
5/22/2023 Kelly Baier 98110 $0.80 CS013385
5/22/2023 Tyrone Beltramo 98113 $0.89 CS013385
5/22/2023 Jeanne Jantzen 98131 $4.55 CS013385
5/22/2023 Scott Worth 98138 $0.55 CS013385
5/22/2023 Janette Jones 98194 $5.00 CS013385
5/22/2023 Laura Ryan 98208 $10.00 CS013385
67
5/22/2023 Tami Brinkel 98362 $0.55 CS013385
5/22/2023 Nick Herdean 98457 $20.00 CS013385
5/22/2023 Lisa Haddock 98459 $5.00 CS013385
5/22/2023 Denise Devroy 98464 $10.00 CS013385
5/22/2023 Lisa King 98468 $0.25 CS013385
5/22/2023 Darren Gussin 98480 $0.80 CS013385
5/22/2023 Jill Miller 98481 $20.00 CS013385
5/22/2023 Kimberly Ollila 98503 $5.00 CS013385
5/22/2023 Anthony Leik 98515 $5.00 CS013385
5/22/2023 Nancy Kolar 100553 $10.00 CS013385
5/23/2023 Monica Moons 98300 $10.00 CS013385
5/23/2023 Richard Hevelhorst 98411 $10.00 CS013385
5/23/2023 Andrew Bronstein 98414 $5.00 CS013385
5/23/2023 Andrea Holdge 98415 $0.55 CS013385
5/23/2023 Brittany DiMercurio 98419 $0.80 CS013385
5/23/2023 Bruce Corrigan-Salter 98530 $0.80 CS013385
5/23/2023 Joaquin Rodriguez Alvarez 98531 $0.55 CS013385
5/23/2023 Bridget McCabe 98535 $0.80 CS013385
5/23/2023 Angelya higginbotham 98537 $0.55 CS013385
5/23/2023 Jennifer Fritsch 98599 $10.00 CS013385
5/23/2023 Jennifer Fritsch 98600 $10.00 CS013385
5/23/2023 Mary Martin 98601 $10.00 CS013385
5/23/2023 Hana Bojaj 98604 $0.80 CS013385
5/23/2023 Steven Franklin 98615 $0.89 CS013385
5/23/2023 Jeffrey Clawson 98616 $5.00 CS013385
5/23/2023 Heather Dickson 98617 $5.00 CS013385
5/23/2023 Katelynn Cummins 98620 $0.55 CS013385
5/23/2023 David Velker 98780 $0.80 CS013385
5/24/2023 Tammy Gerard 98433 $5.00 CS013385
5/24/2023 Tracy Berry 98475 $0.55 CS013385
5/24/2023 Devin Mann 98477 $0.55 CS013385
5/24/2023 Brandy Geisler 98479 $0.80 CS013385
5/24/2023 Marcella Robinette 98520 $0.80 CS013385
5/24/2023 Victoria Neuciler 98574 $0.80 CS013385
5/24/2023 Erin McMackin 98579 $100.00 CS013385
5/24/2023 Karen Sumner 98586 $5.00 CS013385
5/24/2023 Tina Spence 98590 $0.55 CS013385
5/24/2023 Catherine Smith 98634 $0.90 CS013385
5/24/2023 Marilou Ordinario 98641 $3.80 CS013385
5/24/2023 Ashley Scholes 98642 $0.55 CS013385
5/24/2023 Aimy Aboubakare 98690 $0.80 CS013385
5/24/2023 Scott Wiks 98745 $5.00 CS013385
5/24/2023 Priyanka Sah 98760 $10.00 CS013385
5/24/2023 Brad Walvort 98917 $5.00 CS013385
5/25/2023 Donation Box 98646 $67.00 JE014125
5/25/2023 Brian Pikielek 98649 $10.00 CS013385
5/25/2023 Alexandra Webb 98685 $0.80 CS013385
5/25/2023 Laura Beldin 98721 $20.00 CS013385
5/25/2023 Tyler Block 98722 $10.00 CS013385
5/25/2023 Annalena Seils 98730 $10.00 CS013385
5/25/2023 Birgit Villeminey 98749 $5.00 CS013385
5/25/2023 Jeanette Jarzab 98924 $0.80 CS013385
68
5/25/2023 Thomas Kocik 98947 $0.25 CS013385
5/25/2023 Thomas Kocik 98948 $0.55 CS013385
5/25/2023 Christine Chambers 98955 $0.55 CS013385
5/25/2023 John Roberts 98988 $0.55 CS013385
5/25/2023 Gary Galunas 99012 $10.00 CS013385
5/25/2023 Joan Crampton 99025 $5.00 CS013385
5/25/2023 Lisa Weber 99027 $50.00 CS013385
5/25/2023 Abbey Dickey 99087 $0.80 CS013385
5/25/2023 Abbey Dickey 99088 $0.55 CS013385
5/26/2023 Katie Washko 98759 $5.00 CS013574
5/26/2023 Marc Coleman 98766 $0.55 CS013574
5/26/2023 Kevin Trail 98772 $0.55 CS013574
5/26/2023 Linda DeBoer 98784 $0.80 CS013574
5/26/2023 Linda DeBoer 98785 $0.55 CS013574
5/26/2023 Mary Potthoff 98792 $5.00 CS013574
5/26/2023 Randall Spaulding 98806 $2.00
5/26/2023 Lindsay Bastian 98810 $0.55 CS013574
5/26/2023 Heidi Grissom 98846 $5.00 CS013574
5/26/2023 Sue Dodd 98848 $0.89 CS013574
5/26/2023 Amy Manosky 98850 $0.55 CS013574
5/26/2023 Rich Mroczka 99331 $0.25 CS013574
5/26/2023 Jenness Wilson 99517 $5.00 CS013574
5/27/2023 Darsi Bell 98839 $20.00 CS013574
5/27/2023 Krystyna Ozog 98852 $5.00 CS013574
5/27/2023 Julie Brundirks 98860 $10.00 CS013574
5/27/2023 Marie Laurent 98862 $20.00 CS013574
5/27/2023 Karen Cafeo 99216 $10.00 CS013574
5/27/2023 Jennifer Geisler 99319 $0.80 CS013574
5/27/2023 Melissa McGowan 99526 $1.00 CS013574
5/27/2023 Andrea Page 99536 $5.00 CS013574
5/27/2023 Sheleena Totharam 99622 $10.00 CS013574
5/27/2023 Jennifer Smith 100271 $0.90 CS013574
5/28/2023 James Pugh 98867 $5.00 CS013574
5/28/2023 Hannah Huehn 98871 $0.55 CS013574
5/28/2023 Hannah Huehn 98872 $0.80 CS013574
5/28/2023 Carolyn Everett 98876 $0.55 CS013574
5/28/2023 Gina Nagy 99188 $0.80 CS013574
5/28/2023 Kym Croucher 99579 $0.55 CS013574
5/28/2023 Tera Schwartz 99651 $0.35 CS013574
5/29/2023 D Bomarito 99577 $0.80 CS013574
5/29/2023 Kiley Atkinson 99594 $0.80 CS013574
5/29/2023 Kerry Atkinson 99595 $0.80 CS013574
5/29/2023 Deborah Honnila 99599 $5.00 CS013574
5/29/2023 Sarah Cantu 99640 $0.55 CS013574
5/29/2023 Lisa Lloyd-Jones 99659 $0.25 CS013574
5/29/2023 Janine Gallant 99680 $4.55 CS013574
5/30/2023 Abigail Lovell 98898 $0.80 CS013574
5/30/2023 Brittney Herbst 98941 $0.80 CS013574
5/30/2023 Mary Width 98965 $18.80 CS013574
5/30/2023 Matthew Rottweiler 98980 $10.00 CS013574
5/30/2023 Kimberly Lewellen 99016 $20.00 CS013574
5/30/2023 steven Mosier 99034 $5.00 CS013574
69
5/30/2023 Terri Blovet 99043 $5.00 CS013574
5/30/2023 Kathleen Fish 99053 $10.00 CS013574
5/30/2023 Victoria Cauley 99060 $0.55 CS013574
5/30/2023 Kimberly Granger 99080 $400.00 JE014280
5/30/2023 Linda Herald 99084 $0.58 CS013574
5/30/2023 Linda Herald 99085 $0.58 CS013574
5/30/2023 Amy Wulke 99089 $0.65 CS013574
5/30/2023 Carol Rife 99098 $5.58 CS013574
5/30/2023 Samantha Shaner 99199 $0.80 CS013574
5/30/2023 Lisa Tope-Claspell 99200 $5.00 CS013574
5/30/2023 Michelle Ward 99243 $5.00 CS013574
5/30/2023 Jonathan Lynch 99604 $0.80
5/30/2023 Daniel Jorge 99653 $5.55 CS013574
5/30/2023 Charles parrott 99672 $5.00 CS013574
5/30/2023 Amy Weber 99674 $20.00 CS013574
5/30/2023 Kimberly and William Bogan 99676 $5.00 CS013574
5/30/2023 Katherine Hill 99703 $5.00 CS013574
5/30/2023 Christine Tudrick 99708 $0.80 CS013574
5/30/2023 Sara Wunsche 99710 $20.00 CS013574
5/30/2023 Kristen Elliott 99713 $10.00 CS013574
5/30/2023 Tiffany Streett 99718 $5.00 CS013574
5/30/2023 Kelsey Baker 99728 $5.00 CS013574
5/30/2023 Paul Phelps 99730 $0.80 CS013574
5/30/2023 Shantel LoFiego 99741 $0.10 CS013574
5/30/2023 Sylvia Raleigh 99744 $4.55 CS013574
5/30/2023 Sarah Kratz 99751 $4.55 CS013574
5/30/2023 Colleen Lampert 99753 $3.80 CS013574
5/30/2023 Justin Leach 99760 $0.80 CS013574
5/31/2023 Keith Jones 99109 $5.00 CS013574
5/31/2023 Alexandria Stanjones 99117 $0.55 CS013574
5/31/2023 Alexandria Stanjones 99118 $0.25 CS013574
5/31/2023 Bethany Beyer 99134 $0.55 CS013574
5/31/2023 Ashley Mikolaczik 99136 $5.00 CS013574
5/31/2023 Chris Becker 99150 $20.00 CS013574
5/31/2023 Cindy Angiulo 99173 $10.35 CS013574
5/31/2023 Jennifer Rihtarchik 99178 $0.55 CS013574
5/31/2023 Teri Hockstad 99214 $25.00 CS013574
5/31/2023 Patricia Paternel 99233 $10.00 CS013574
5/31/2023 John Houlihan 99234 $5.00 CS013574
5/31/2023 Emad Khalil 99236 $5.00 CS013574
5/31/2023 Julie Fargo 99238 $5.00 CS014036
5/31/2023 Sara Schmuker-Billings 99241 $0.55 CS013574
5/31/2023 Robert Kibler 99242 $5.00 CS013574
5/31/2023 Stuart Dowall 99248 $5.00 CS013574
5/31/2023 Kelly Houghteling 99250 $0.55 CS013574
5/31/2023 Kristy Rubin 99260 $0.10 CS013574
5/31/2023 Stephanie Brandt 99273 $10.00 CS014036
5/31/2023 Renee Mackie 99284 $0.80 CS013574
5/31/2023 Christins Parker 99289 $0.55 CS013574
5/31/2023 Faye Zuhairy 99307 $5.00 CS013574
5/31/2023 Renee Kirkpatrick 99340 $5.00 CS013574
5/31/2023 Melissa Reyes 99358 $5.00 CS014036
70
5/31/2023 Becky Horne 99361 $0.55 CS013574
5/31/2023 Shawnee Morningsstar 99764 $5.00 CS013574
5/31/2023 Nicola Izzi 99774 $0.90 CS014036
5/31/2023 Jocelyn Willis 99775 $0.80 CS014036
5/31/2023 Andrea Weinman 99780 $5.00 CS013574
5/31/2023 Cathleen Collins 99783 $0.10 CS013574
5/31/2023 Jonquil Bertschi 99784 $10.00 CS013574
5/31/2023 LisaBrosnan 99797 $0.80 CS013574
5/31/2023 Donald David 99805 $5.00 CS013574
5/31/2023 David Hochstein 99809 $10.00 CS013574
5/31/2023 Andrea Kendrick 99815 $0.60 CS013574
5/31/2023 Beth Malinoski 99820 $5.00 CS013574
5/31/2023 Jacob Kazyak 99823 $5.00 CS013574
5/31/2023 Alan Wall 99828 $0.25 CS014036
5/31/2023 Andrea Slabinski 99834 $10.00 CS013574
5/31/2023 Juliegha Barsenas 99855 $5.00 CS013574
5/31/2023 Alicia Kitson 99857 $5.00 CS013574
5/31/2023 Karen DeLorge 99860 $10.00 CS013574
5/31/2023 Deedra Chhampagne 99868 $0.80 CS013574
5/31/2023 Susan Graham 99870 $4.00 CS013574
5/31/2023 Eric Smith 99872 $10.00 CS013574
5/31/2023 Doenie Nylen 99879 $5.00 CS013574
5/31/2023 Ted Sells 99895 $5.00 CS013574
5/31/2023 Allison Streets 99900 $0.55 CS013574
5/31/2023 Julie Rutt 99902 $0.80 CS013574
5/31/2023 Melissa Morrison 99904 $5.00 CS013574
5/31/2023 Annette Christensen 99909 $5.00 CS013574
5/31/2023 Corinne Wilson 99913 $8.80 CS013574
5/31/2023 Ibrahim Zohrob 99915 $5.00 CS014036
5/31/2023 Dorne McKinnon-Rybicki 99929 $5.00 CS013574
5/31/2023 Jill Wessel 99941 $0.55 CS014036
5/31/2023 Josh Fritch 99943 $5.00 CS013574
5/31/2023 Marianne Claffey 99947 $3.00 CS013574
5/31/2023 Stephen AuBuchon 99959 $0.55 CS013574
5/31/2023 Stephen AuBuchon 99960 $0.55 CS013574
5/31/2023 Paula Maurer 99979 $10.00 CS013574
5/31/2023 Paula Maurer 99980 $10.00 CS013574
$7,022.11
Receipt Number Amount Journal Number
6/1/2023 Haley Kras 99295 $5.00 CS014036
6/1/2023 Jane Patino 99297 $0.55 CS014036
6/1/2023 Nicole Cox 99316 $5.00 CS014036
6/1/2023 Johnathan Muenk 99336 $0.55 CS014036
6/1/2023 Joanna Stemmer 99356 $50.00 JE014280
6/1/2023 Kevin Snyder 99372 $10.00 CS014036
6/1/2023 Marisa Nichols 99378 $0.60 CS014036
6/1/2023 Morgan Cerny 99437 $10.00 CS014036
6/1/2023 Michele Romanowski 99449 $5.00 CS014036
6/1/2023 David Rabens 99457 $5.00 CS014036
6/1/2023 Dean Giachino 99478 $5.00 CS014036
6/1/2023 Dawn Schultz 99795 $5.00 CS014036
6/1/2023 Eric Noll 99898 $0.90 CS014036
Date of Donation Person Donating
May 2023 Total
71
6/1/2023 Colette Spaccarotella 99962 $0.55 CS014036
6/1/2023 Jackie Kopera 99976 $0.90 CS014036
6/1/2023 Jill Seward 99987 $0.55 CS014036
6/1/2023 Michael Strom 99988 $5.00 CS014036
6/1/2023 Edgar Romero-Valentin 100004 $5.00 CS014036
6/1/2023 Peggy Dawe 100009 $0.58 CS014036
6/1/2023 Tracy Aceron 100014 $5.00 CS014036
6/1/2023 Nicole Farrell 100015 $0.55 CS014036
6/1/2023 Madison Stauffer 100019 $10.00 CS014036
6/1/2023 Melissa Kandah 100046 $0.80 CS014036
6/1/2023 Mike Terenzi 100048 $4.55 CS014036
6/1/2023 Amber Fox 100056 $10.00 CS014036
6/1/2023 Darrell Ulrich 100058 $0.80 CS014036
6/1/2023 Erica Grochowski 100062 $0.55 CS014036
6/1/2023 Kyungjun Han 100065 $0.55 CS014036
6/1/2023 Elizabeth Gusick 100067 $5.00 CS014036
6/1/2023 Kristi Thompson 100070 $0.80 CS014036
6/1/2023 Steven Young 100083 $5.00 CS014036
6/2/2023 Zoe Payne 99469 $0.80 CS014036
6/2/2023 Samantha Schalter 100106 $0.35 CS014036
6/2/2023 Michele Little 100112 $12.00 CS014036
6/2/2023 Leonardo Viviani 100117 $5.00 CS014036
6/2/2023 Crystal Hagan 100118 $0.80 CS014036
6/2/2023 Nancy Butala 100124 $0.80 CS014036
6/2/2023 Brian Moody 100129 $20.00 CS014036
6/2/2023 Adam Brown 100130 $2.45 CS014036
6/3/2023 Jorge Acevedo-Torres 99484 $0.80 CS014036
6/3/2023 Ronda Pickett 100134 $5.00 CS014036
6/3/2023 Jennifer Petrie 100142 $0.80 CS014036
6/5/2023 Kate Blizinski 99499 $5.00 CS014036
6/5/2023 Rebecca Nakamoto 99500 $0.35 CS014036
6/5/2023 JoAnn McKeogh 99501 $10.00 CS014036
6/5/2023 Nicole Spiess 99539 $0.80 CS014036
6/5/2023 Melissa Pope 100140 $50.00 CS014036
6/5/2023 Melissa Pope 100141 $50.00 CS014036
6/5/2023 Rodrigo Rivas 100156 $0.80 CS014036
6/5/2023 Patricia McGrath 100157 $0.80 CS014036
6/5/2023 Nicole Greenwood 100171 $0.80 CS014036
6/6/2023 Kellie Seman 99555 $50.00 JE014457
6/6/2023 Alfred Demailo 99556 $100.00 JE014457
6/6/2023 Brad Malone 99557 $100.00 JE014457
6/6/2023 Dennis Anderson 99558 $35.00 JE014457
6/6/2023 Marina Castro-Neves 99561 $60.00 JE014457
6/6/2023 Mark Mudd 99562 $5.00 JE014457
6/6/2023 John Little 99567 $5.00 JE014457
6/6/2023 Donation Box 99569 $25.56 JE014457
6/6/2023 Donation Box 99570 $2.07 JE014457
6/6/2023 Carly Davis 99673 $0.35 CS014036
6/6/2023 Robert Zemko 99793 $5.00 CS014036
6/6/2023 Robert Zemko 99794 $5.00 CS014036
6/6/2023 Christina Adam 100189 $5.00 CS014036
6/6/2023 Christina Adam 100190 $5.00 CS014036
72
6/6/2023 Jennifer Krueger 100196 $5.00 CS014036
6/6/2023 Joanne Lewis 100209 $5.00 CS014036
6/7/2023 Katherine Holsworth 99893 $24.00 JE014457
6/7/2023 Sarah Rollins 99981 $5.00 CS014036
6/7/2023 Kaitlin Nowacki 99983 $5.00 CS014036
6/7/2023 Lori Lesperance 100221 $50.00 CS014036
6/7/2023 Melissa Minton 100225 $0.35 CS014036
6/7/2023 Ryoji Kato 100229 $0.80 CS014036
6/7/2023 Donald Kolesar 100268 $0.35 CS014036
6/8/2023 Lauren Ainslie 100178 $0.35 CS014036
6/8/2023 Thomas Chicoine 100235 $5.00 CS014036
6/8/2023 Faith Pilger 100240 $5.00 CS014036
6/8/2023 Kristin Johnson 100243 $5.00 CS014036
6/8/2023 Donna Buchan 100244 $0.35 CS014036
6/8/2023 Donna Buchan 100245 $0.35 CS014036
6/8/2023 Britt Huey 100248 $0.35 CS014036
6/8/2023 Britta Gerdes 100249 $20.00 CS014036
6/8/2023 Theresa Gallivan 100251 $0.80 CS014036
6/8/2023 Liz Smith 100252 $0.80 CS014036
6/8/2023 Katie Mejeur 100256 $20.00 CS014036
6/8/2023 Denise Grabmiller 100257 $0.80 CS014036
6/8/2023 Hannah Halcomb 100451 $0.70 CS014036
6/9/2023 Katie Mejeur 100275 $75.00 JE014355
6/9/2023 Krysten Baligian 100300 $0.80 CS014036
6/9/2023 Jennifer Young 100311 $20.00 CS014036
6/9/2023 Kelly Cornett 100350 $0.35 CS014036
6/9/2023 Michael Trevino 100352 $5.00 CS014036
6/9/2023 Nicholas Johnson 100354 $5.00 CS014036
6/9/2023 Samantha Bennett 100355 $0.80 CS014036
6/9/2023 Stephanie Ming 100360 $20.00 CS014036
6/10/2023 Fay DeVriese 100422 $20.00 CS014036
6/11/2023 Kathleen Gawronski 100367 $5.00 CS014036
6/11/2023 Avani Ratanpara 100370 $0.35 CS014036
6/11/2023 David Broden 100386 $0.45 CS014036
6/12/2023 AmyFrederick 100391 $0.35 CS014036
6/12/2023 Rosemary Ribner 100405 $10.00 CS014036
6/12/2023 Lori Huisman 100429 $0.35 CS014036
6/12/2023 Cody Lange 100436 $5.00 CS014036
6/12/2023 See Graul 100438 $10.00 CS014036
6/12/2023 Marco Kotonski 100441 $0.35 CS014036
6/12/2023 Christine Ferguson 100443 $5.00 CS014036
6/13/2023 Gary Rochon 100460 $5.00 CS014036
6/13/2023 Anthony Bingham 100502 $5.00 CS014036
6/13/2023 Freida Morrison 100506 $0.80 CS014036
6/13/2023 Kathy Halberg 100517 $5.00 CS014036
6/13/2023 Kathy Halberg 100518 $5.00 CS014036
6/13/2023 Ryan Brown 100523 $5.00 CS014036
6/14/2023 Bethany Schmalenberg 100535 $0.35 CS014036
6/14/2023 Camme Isbell 100558 $0.45 CS014036
6/14/2023 Justin Walsh 100561 $5.00 CS014036
6/14/2023 Lakshmi Narayanan Chandramohan 100563 $5.00 CS014036
6/14/2023 Wendy Kitzman 100571 $10.00 CS014036
73
6/14/2023 Ryan Orkwis 100572 $5.00 CS014036
6/14/2023 Ted Lindeberg 100578 $10.00 CS014036
6/14/2023 Andrew Eckhous 100615 $100.00 CS014036
6/15/2023 Haley Roden 100585 $0.80 CS014036
6/15/2023 Erendira Salcedo 100624 $10.00 CS014036
6/15/2023 Diane Shreve 100626 $0.32 JE014801
6/15/2023 Jessica Brown 100656 $10.00 CS014036
6/16/2023 Nancy Bayagich 100662 $0.80 CS014396
6/16/2023 Nancy Bayagich 100663 $0.80 CS014396
6/16/2023 Michael Venos 100672 $5.00 CS014396
6/16/2023 Jared Shroyer 100684 $10.00 CS014396
6/16/2023 Rebecca Myers 100692 $0.35 CS014396
6/16/2023 Kei Sato 100731 $5.00 CS014396
6/17/2023 Alyssa Goraj 100727 $0.80 CS014396
6/17/2023 Eline Esparza 100740 $5.00 CS014396
6/17/2023 Eric Manjarrez 100744 $0.80 CS014396
6/18/2023 Daniel Tamez 100746 $5.00 CS014396
6/19/2023 Christopher Smith 100730 $5.00 CS014396
6/19/2023 Michael Wojciechowski 100749 $5.00 CS014396
6/19/2023 Michael Wojciechowski 100750 $5.00 CS014396
6/19/2023 Julie Grembi 100759 $0.45 CS014396
6/19/2023 Jack Korth 100766 $0.45 CS014396
6/20/2023 Ashis Goswami 100808 $0.80 CS014396
6/20/2023 Maralyn Wilchynski 100818 $10.00 CS014396
6/20/2023 Kevin Kurkowski 100819 $0.35 CS014396
6/20/2023 Enrique Cardenas 100832 $0.01 CS014396
6/20/2023 Maria Velazquez 100838 $5.00 CS014396
6/21/2023 Pradeep Kaminoulu 100852 $5.00 CS014396
6/21/2023 Angela Damato 100855 $0.35 CS014396
6/21/2023 Mark Scoles 100858 $10.00 CS014396
6/21/2023 Conan Stoehr 100867 $10.00 CS014396
6/21/2023 Joe Smith 100871 $0.80 CS014396
6/22/2023 Stephen Ceccarini 100896 $8.80 CS014396
6/22/2023 Dennis Anderson 100898 $35.00 JE014944
6/22/2023 John Little 100904 $5.00 JE014944
6/22/2023 Donation Box 100907 $3.60 JE014944
6/22/2023 Jennifer Horvath 100915 $5.00 CS014396
6/22/2023 Wendy Marshick 100922 $0.60 CS014396
6/22/2023 Viviana Weekes-Shackelford 100924 $0.35 CS014396
6/22/2023 Diane Garner 100927 $5.00 CS014396
6/22/2023 James Tanner 100932 $0.80 CS014396
6/22/2023 Michael Bushey 100961 $0.80 CS014396
6/23/2023 Valinda Rocheleau 100971 $2.00 JE014944
6/23/2023 Kyle Smith 100986 $0.80 CS014396
6/23/2023 Candance Bacall 100998 $50.00 JE014945
6/23/2023 Donation Box 101008 $56.00 JE015027
6/23/2023 Stephanie Ciranna 101014 $0.80 CS014396
6/23/2023 Gina Czech 101021 $5.00 CS014396
6/24/2023 Margaret Johnson 101027 $5.00 CS014396
6/24/2023 Melissa Krass 101028 $0.80 CS014396
6/24/2023 Cheryl L Webster Miller 101031 $20.00 CS014396
6/25/2023 Tim Shea 101040 $5.00 CS014396
74
6/25/2023 Kayte Nickel 101042 $0.80 CS014396
6/25/2023 Kayte Nickel 101043 $0.45 CS014396
6/25/2023 Kayte Nickel 101044 $0.35 CS014396
6/25/2023 Abby Makris 101045 $0.35 CS014396
6/26/2023 Maria Capers 101072 $1.00 CS014396
6/26/2023 Leroy Burgess 101079 $23.00 JE015028
6/26/2023 Alexandra Jacobson 101080 $5.00 CS014396
6/26/2023 Brittany Payne 101082 $10.00 CS014396
6/26/2023 Jessica Hall 101096 $5.00 CS014396
6/26/2023 Suzette Smith 101100 $0.60 CS014396
6/27/2023 Michelle Saunders 101111 $50.00 CS014396
6/27/2023 Angela Martinez 101136 $5.00 JE015028
6/27/2023 Dominique Luuk 101162 $0.45 CS014396
6/27/2023 Toby Klein 101185 $0.45 CS014396
6/28/2023 Sherry Griesinger 101191 $10.00 CS014693
6/28/2023 Laura Taylor 101192 $5.00 CS014693
6/28/2023 Katie Shureb 101197 $5.00 CS014693
6/28/2023 Daniel Hunter 101207 $2.00 CS014693
6/28/2023 Valdevir Leal De Paula 101219 $10.00 CS014693
6/28/2023 Jeff Stern 101227 $0.45 CS014693
6/28/2023 Ericka Cloutier 101264 $1,404.04 CS014693
6/28/2023 Joanna Strzalkowski 101262 $10.00 CS014693
6/29/2023 Michael VanDoornik 101308 $5.00 CS014693
6/29/2023 Leonard Beigler 101278 $10.00 CS014693
6/29/2023 MaryAnn Sultana 101288 $0.80 CS014693
6/29/2023 Hoai Anh Nguyen 101298 $0.45 CS014693
6/29/2023 Jason Stokes 101313 $0.80 CS014693
6/29/2023 Bill Tull 101316 $0.80 CS014693
6/30/2023 Jonathan Kosky 101317 $0.80 CS014693
6/30/2023 Luis Nava Cardenas 101331 $0.80 CS014693
6/30/2023 Thomas Adamowski 101335 $5.00 CS014693
6/30/2023 Thomas Adamowski 101336 $5.00 CS014693
6/30/2023 Christopher Adams 101352 $5.00 CS014693
6/30/2023 Janet Jacobsen 101353 $10.00 CS014693
6/30/2023 Vicki Dice 101354 $0.80 CS014693
$3,146.93
$21,621.68
June 2023 Total
Q3 Total
75
Department of Public Services
Oakland County Children's Village
Date:Donor:Cash/Check:Items:Estimated Value:
4/3/2023 Daughter of Isabella Pillow Cases 300.00
4/8/2023 St. William Parish 10 Easter Baskets $150.00
4/10/2023 Maria Mendola Books $150.00
4/12/2023 Sweet Dreams for Kids Pillow Cases $225.00
4/14/2023 St. Mary's Church Easter Baskets $750.00
4/25/2023 Kathryn Chapman Yarn $225.00
4/25/2023 H. Cusatis Yarn $225.00
4/28/2023 Howarth United Methodist Church Toiletries $20.00
5/1/2023 Sweet Dreams for Kids Pillow Cases $225.00
5/2/2023 St. Perpetua Pillow Cases $300.00
5/3/2023 Big Beaver United Methodist Check $100.00
5/9/2023 Omega Epsilon Omega Toiletries $1,250.00
5/16/2023 Christine Arakelian Games, Drawing Supplies $200.00
5/22/2023 Samatha DeMont Books, Puzzles $100.00
5/22/2023 Dee McBroom 2 XL Furry Pillows $75.00
6/2/2023 Alpha Kapa Alpha Puzzles, Toys, Toiletries $1,000.00
6/2/2023 Daughter of Isabella Pillow Cases $315.00
6/7/2023 OCCVF Workshop Attendance - GNS $1,200.00
6/9/2023 Ashley Bishop Clothes $50.00
6/12/2023 Oakland County Employees Toiletries, Toys, Games, Books $3,000.00
6/15/2023 A Little Quilt Shop Clothing, Totes $100.00
6/15/2023 Stevenson Elementary School Toiletries $800.00
6/21/2023 Sweet Dreams for Kids Pillow Cases $225.00
6/22/2023 OCCVF Rochester School of Music $477.00
6/26/2023 Larson Middle School Books, Clothes $1,000.00
6/27/2023 OC Board of Commissioners Toiletries, Towels $50.00
6/28/2023 St. Anne Church Clothing $40.00
Total:$12,552.00
Donation Tracking : Donation Period April 2023 to June 2023
76
Date Donor Cash/Check Amount Purpose
6/5/2023 Milford PD N/A 2,799.00$ Volcon ePowersports Brat e-bike
Oakland County Sheriff's Office
FY2023 Third Quarter Report for Contributions (Donations)
77
Fund Customer Customer No Amount Date Inv No Comments
Fund 20293 CHILDREN'S VILLAGE AGING AR - WRITE OFFS
COUNTY OF SAGINAW OCV00000006 507.00 2/18/2021 OCV0001696 APPROVED FOR WRITE OFF H. CALCATERRA
COUNTY OF SAGINAW OCV00000006 2,704.00 2/28/2021 OCV0001708 APPROVED FOR WRITE OFF H. CALCATERRA
COUNTY OF SAGINAW OCV00000006 2,704.00 2/28/2021 OCV0001709 APPROVED FOR WRITE OFF H. CALCATERRA
COUNTY OF SAGINAW OCV00000006 507.00 2/18/2021 OCV0001695 APPROVED FOR WRITE OFF H. CALCATERRA
COUNTY OF WAYNE DHS OCV00000011 4,901.00 8/31/2021 OCV0002031 APPROVED FOR WRITE OFF H. CALCATERRA
COUNTY OF WAYNE CIRCUIT COURT OCV00000030 3,887.00 7/9/2020 OCV0001628 APPROVED FOR WRITE OFF H. CALCATERRA
COUNTY OF WAYNE CIRCUIT COURT OCV00000030 3,549.00 7/9/2020 OCV0001627 APPROVED FOR WRITE OFF H. CALCATERRA
COUNTY OF WAYNE CIRCUIT COURT OCV00000030 1,352.00 2/18/2021 OCV0001685 APPROVED FOR WRITE OFF H. CALCATERRA
COUNTY OF WAYNE DHS OCV00000011 3,042.00 2/18/2021 OCV0001694 APPROVED FOR WRITE OFF H. CALCATERRA
COUNTY OF WAYNE DHS OCV00000011 1,352.00 2/18/2021 OCV0001686 APPROVED FOR WRITE OFF H. CALCATERRA
COUNTY OF WAYNE DHS OCV00000011 1,859.00 5/20/2021 OCV0001822 APPROVED FOR WRITE OFF H. CALCATERRA
Total 26,364.00
Children's Village Department
FY23 Bad Debt Write Offs
78
MONTHCONTRACT ADJUST WRITEOFFBAD DEBT WRITEOFFTOTAL ARMarch 2023(780.57) (2,494.27) (3,274.84)April 2023(982.50) 0.00 (982.50)May 2023(2,106.37) (3,390.20) (5,496.57)June 2023(2,475.95) (3,275.90) (5,751.85)Totals (6,345.39) (9,160.37) (15,505.76)Department of Health and Human Services Write‐OffsFY 2023 Third Quarter Writeoffs79
.
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
Animal Control
R General Fund Animal Control FND10100 CCN1070801 RC630074 PRG114115 GRN-1004081 630000 Animal Serlization Fees 1,050$ -$ -$
R General Fund Animal Control FND10100 CCN9010101 RC665882 PRG196030 GRN-1004081 665882 Planned Use of Balance (1,050)$ -$ -$
-$ -$ -$
District Court
E General Non Departmental Transfers FND10100 CCN9090101 SC760126 PRG196030 760000 Capital Outlay Miscellaneous (90,482)$ -$ -$
E General District Court I Admin FND10100 CCN3020201 SC750154 PRG121020 750000 Expendable Equipment 90,482$ -$ -$
-$ -$ -$
Facilities
E General Non Departmental Transfers FND10100 CCN9090101 SC760126 PRG196030 760000 Capital Outlay Miscellaneous -$ (78,455)$ -$
E General Facilities Engineering Admin FND10100 CCN1040801 SC760160 PRG148020 760000 Furniture and Fixtures -$ 78,455$ -$
-$ -$ -$
Parks & Recreation
E General Fund Economic Development FND10100 CCN1090101 SC731822 PRG171000 730000 Special Projects (25,000)$ -$ -$
E General Fund Economic Development FND10100 CCN1090101 SC788001 PRG171000 BFA50800 788001 Transfers Out 25,000$
Total Expendiures -$ -$ -$
E Parks and Recreation Recreation Programs & Community Services FND50800 CCN5060110 RC695500 PRG160700 BFA10100 695500 Transfers In 25,000$ -$ -$
Total Revenues 25,000$ -$ -$
E Parks and Recreation Recreation Programs & Community Services FND50800 CCN5060110 SC750154 PRG160700 750000 Expendable Equipment 25,000$ -$ -$
Total Expenditures 25,000$ -$ -$
Board of Commissioners
E General Fund Board of Commissioners FND10100 CCN5010101 SC731822 PRG180010 730000 Special Projects (58,000)$ -$ -$
E General Fund Board of Commissioners FND10100 CCN5010101 SC788001 PRG180010 BFA50800 780000 Transfers Out 58,000$ -$ -$
Total Expenditures -$ -$ -$
Health & Human Services
R General Fund Non Departmental FND10100 CCN9010101 RC665882 PRG196030 665882 Planned Use of Balance 75$ -$ -$
Total Revenues 75$ -$ -$
E General Fund Health and Human Services FND10100 CCN1060201 SC702010 PRG134390 702000 Salaries Regular 60$ 720$ 720$
E General Fund Health and Human Services FND10100 CCN1060201 SC722740 PRG134390 722000 Fringe Benefits 15$ 180$ 180$
E General Fund Non Departmental FND10100 CCN9090101 SC796500 PRG196030 796500 Budgeted Equity Adjustments (900)$ (900)$
Total Expenditures 75$ -$ -$
Sheriff
R General Fund Inv. & Forensic Svcs FND10100 CCN4030901 RC695500 PRG116240 BFA21340 695500 Transfers In - Law Enforcement Enhance Lab Fees 51,688$ -$ -$
R General Fund Emergency Comm Ops FND10100 CCN4030701 RC695500 PRG116230 BFA21396 695500 Transfers In - Sheriff Dispatch Training 49,047$ -$ -$
R General Fund Corrective Services FND10100 CCN4030301 RC695500 PRG112620 BFA21397 695500 Transfers In - Sheriff Booking Fee Training 25,698$ -$ -$
Total Revenue 126,433$ -$ -$
E General Fund Inv. & Forensic Svcs FND10100 CCN4030901 SC750203 PRG116240 750000 Forensic Lab Enhancement 51,688$
E General Fund Emergency Comm Ops FND10100 CCN4030701 SC731304 PRG116230 730000 Officers Training (Dispatch)49,047$ -$ -$
E General Fund Corrective Services FND10100 CCN4030301 SC731304 PRG112620 730000 Officers Training (Corrections)25,698$ -$ -$
Oakland County, Michigan
Schedule "A" DETAIL
WHEREAS a FY 2023 budget amendment is recommended for the Animal Control Division to accept reimbursement funding of $1,050 from the May 1st - 15th 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
WHEREAS a FY 2023 budget amendment is recommended for the 52/1 (Novi) District Court transferring $90,482 from Capital Outlay Miscellaneous to Expendable Equipment to purchase furniture for use within the District Court I Division (Novi); and
WHEREAS a FY 2024 budget amendment is recommended for Facilities Engineering transferring $78,455 from Capital Outlay Miscellaneous to Furniture and Fixtures to address building code compliance and OSHA requirements within the stairway and mezzanine of Materials Management; and
WHEREAS a budget amendment is recommended for the Neighbor Housing Development (NHD) grant funded employee of $75 for FY2023 and $900 for FY2024-2025 to participate in the Health and Human Service's Equity Committee to ensure that NHD is represented in all equity initiatives that HHS explores
and implements on behalf of employees and clients served.; and
WHEREAS a FY 2023 budget amendment is recommended for Parks & Recreation reallocating $25,000 from Economic Development for the Fire & Ice Festival is to help increase interest and commerce to local businesses and restaurants at a time of year that is traditionally slower and to provide opportunities for
winter recreation and social activities transfer from Economic Development to Parks and Recreation; and
WHEREAS a FY 2023 budget amendment of $58,000 is recommended for the Board of Commissioners to correct actuals from a Transfer In from Special Projects to partially fund Waterford Trailways; and
4
I I I I
I I I
I I I
I I I
I I I I
.
R/E Fund Name Division Name
Fund #
(FND)
Cost Center
(CCN) #
Account #
(RC/SC)
Program #
(PRG)
Grant ID
(GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2023
Amendment
FY 2024
Amendment
FY 2025
Amendment
Oakland County, Michigan
Schedule "A" DETAIL
Total Expenditures 126,433$ -$ -$
R
Law Enforcement
Enhance Lab Fees Inv. & Forensic Svcs FND21340 CCN4030901 RC665882 PRG116240 665882 Planned Use of Balance 51,688$ -$ -$
Total Revenue 51,688$ -$ -$
E
Law Enforcement
Enhance Lab Fees Inv. & Forensic Svcs FND21340 CCN4030901 SC788001 PRG116240 BFA10100 788001 Transfers Out - General Fund 51,688$ -$ -$
Total Expenditures 51,688$ -$ -$
R Dispatch Training Emergency Comm Ops FND21396 CCN4030701 RC665882 PRG112630 665882 Planned Use of Balance 49,047$ -$ -$
Total Revenue 49,047$ -$ -$
E Dispatch Training Emergency Comm Ops FND21396 CCN4030701 SC788001 PRG112630 BFA10100 788001 Transfers Out - General Fund 49,047$ -$ -$
Total Expenditures 49,047$ -$ -$
R
Sheriff Booking Fee
Training Corrective Services FND21397 CCN4030301 RC665882 PRG112620 665882 Planned Use of Balance 25,698$ -$ -$
Total Revenue 25,698$ -$ -$
E
Sheriff Booking Fee
Training Corrective Services FND21397 CCN4030301 SC788001 PRG112620 BFA10100 788001 Transfers Out - General Fund 25,698$ -$ -$
Total Expenditures 25,698$ -$ -$
E General Fund Patrol Services FND10100 CCN4030601 SC731024 PRG110000 730000 K-9 Program (27,800)$ (27,800)$ (27,800)$
E General Fund Patrol Services FND10100 CCN4030601 SC731024 PRG116210 730000 K-9 Program 27,800$ 27,800$ 27,800$
E General Fund Patrol Services FND10100 CCN4030601 SC731304 PRG116210 730000 Officers Training (25,000)$ (25,000)$ (25,000)$
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC731304 PRG110005 730000 Officers Training 25,000$ 25,000$ 25,000$
E General Fund Inv. & Forensic Svcs FND10100 CCN4030901 SC750427 PRG116240 750000 Photographic Supplies (500)$ (500)$ (500)$
E General Fund Corrective Services FND10100 CCN4030301 SC750049 PRG112620 750000 Computer Supplies (3,000)$ (3,000)$ (3,000)$
E General Fund Sheriff Admin FND10100 CCN4030201 SC731941 PRG112580 730000 Training 3,500$ 3,500$ 3,500$
-$ -$ -$
R General Fund Corrective Services Satellite FND10100 CCN4030401 RC631806 PRG121280 630000 Reimb Court Services 10,603$ 10,603$ 10,603$
R General Fund Corrective Services Satellite FND10100 CCN4030401 RC631806 PRG121280 REG62205 630000 Reimb Court Services (10,603)$ (10,603)$ (10,603)$
-$ -$ -$
E Law Enforcement Grants Inv. & Forensic Svcs FND11005 CCN4030901 SC712020 PRG116270 GRN-1003971 702000 Overtime (38,215)$
E Law Enforcement Grants Inv. & Forensic Svcs FND11005 CCN4030901 SC722900 PRG116270 GRN-1003971 722000 Fringe Benefit Adjustments 38,215$ -$ -$
E Law Enforcement Grants Inv. & Forensic Svcs FND11005 CCN4030901 SC712020 PRG116270 GRN-1003973 702000 Overtime (5,064)$
E Law Enforcement Grants Inv. & Forensic Svcs FND11005 CCN4030901 SC722900 PRG116270 GRN-1003973 722000 Fringe Benefit Adjustments 5,064$ -$ -$
-$ -$ -$
E Law Enforcement Grants Inv. & Forensic Svcs FND11005 CCN4030901 SC702010 PRG116240 GRN-0001148 702000 Salaries (58,754)$
E Law Enforcement Grants Inv. & Forensic Svcs FND11005 CCN4030901 SC722900 PRG116240 GRN-0001148 722000 Fringe Benefits (43,486)$ -$ -$
Law Enforcement Grants Inv. & Forensic Svcs FND11005 CCN4030901 SC731780 PRG116240 GRN-0001148 730000 Software Support Maintenance 54,500$
E Law Enforcement Grants Inv. & Forensic Svcs FND11005 CCN4030901 SC731941 PRG116240 GRN-0001148 730000 Training 6,500$
E Law Enforcement Grants Inv. & Forensic Svcs FND11005 CCN4030901 SC732018 PRG116240 GRN-0001148 730000 Travel and Conference 10,379$
E Law Enforcement Grants Inv. & Forensic Svcs FND11005 CCN4030901 SC750280 PRG116240 GRN-0001148 750000 Lab Supplies 10,580$
Law Enforcement Grants Inv. & Forensic Svcs FND11005 CCN4030901 SC760126 PRG116240 GRN-0001148 760000 Misc Capital Outlay 20,281$
-$ -$ -$
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 in FY 2023. Transfers In from the various restricted funds in the amount of $126,433 is being recognized for eligible forensic lab and
training costs for dispatchers and corrections officers; and
WHEREAS a FY2023 budget amendment of $56,300 is recommended for the Sheriff's Office reallocating budgets between programs to more accurately reflext actual activity; and
WHEREAS a FY2023 budget amendment of $10,603 is recommended for the Sheriff's Office correcting the budget by removing the region code as it is a data entry error; and
WHEREAS a FY 2023 budget amendment totaling $48,279 is recommended for the Sheriff's Office realocating the budgets from Overtime to Fringe Benefit Adjustment as it was budgeted incorrectly at the time of acceptance for the Auto Theft Prevention Authority (ATPA) grant; and
WHEREAS a FY2023 budget amendment totaling $102,240 is recommended for the Sheriff's Office to recognize Amendment #3 of the FY2021 DNA Capacity Enhancement and Backlog Reduction (CEBR) Grant program by reallocating salaries and fringes from a vacant position to operating expense line-item
budgets. The amendment is within 15% of the FY 2021 CEBR award (M.R. #22009). ; and
5
I I I I I I I I
I I I
I I I I
I I I
.
R/E Fund Name Division Name
Fund #
(FND)
Cost Center
(CCN) #
Account #
(RC/SC)
Program #
(PRG)
Grant ID
(GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2023
Amendment
FY 2024
Amendment
FY 2025
Amendment
Oakland County, Michigan
Schedule "A" DETAIL
E Law Enforcement Grants Patrol Services FND11005 CCN4030601 SC731304 PRG110010 GRN-1003989 730000 Officers Training (3,000)$
E Law Enforcement Grants Patrol Services FND11005 CCN4030601 SC750070 PRG110010 GRN-1003989 750000 Deputy Supplies 3,604$
E Law Enforcement Grants Patrol Services FND11005 CCN4030601 SC760188 PRG110010 GRN-1003989 760000 Vehicles 1,086$
E Law Enforcement Grants Patrol Services FND11005 CCN4030601 SC776659 PRG110010 GRN-1003989 770000 Motor Pool Fuel (604)$
E Law Enforcement Grants Patrol Services FND11005 CCN4030601 SC776661 PRG110010 GRN-1003989 770000 Motor Pool (1,086)$ -$ -$
-$ -$ -$
E Law Enforcement Grants Patrol Services FND11005 CCN4030601 SC730646 PRG110010 GRN-1003989 730000 Equipment Maintenance 1,080$
E Law Enforcement Grants Patrol Services FND11005 CCN4030601 SC750070 PRG110010 GRN-1003989 750000 Deputy Supplies 474$
E Law Enforcement Grants Patrol Services FND11005 CCN4030601 SC760157 PRG110010 GRN-1003989 760000 Equipment (1,554)$ -$ -$
-$ -$ -$
E Law Enforcement Grants Patrol Services FND11005 CCN4030601 SC722740 PRG110010 GRN-1003989 722000 Fringe Benefits Expense (5,720)$
E Law Enforcement Grants Patrol Services FND11005 CCN4030601 SC750070 PRG110010 GRN-1003989 750000 Deputy Supplies 5,720$ -$ -$
-$ -$ -$
E General Fund Non Departmental FND10100 CCN9090101 SC730800 PRG196030 Grant Match $ 2,500 $ - $ -
E General Fund Sheriff's Office - Inv. & Forensic Svcs FND10100 CCN4030901 SC788001 PRG116270 Transfer Out (2,500) - -
Total Expenditures $ - $ - $ -
R Law Enforcement Grants Sheriff's Office - Inv. & Forensic Svcs FND11005 CCN4030901 RC695500 PRG116270 GRN-1003972 695500 Transfer In - OC $ (2,500) $ - -$
Total Expenditures $ (2,500) $ - $ -
E Law Enforcement Grants Sheriff's Office - Inv. & Forensic Svcs FND11005 CCN4030901 SC730373 PRG116270 GRN-1003971 730000 Contracted Services 2,500 - -$
E Law Enforcement Grants Sheriff's Office - Inv. & Forensic Svcs FND11005 CCN4030901 SC731304 PRG116270 GRN-1003971 730000 Officers Training (5,000) - -
Total Expenditures $ (2,500) $ - $ -
R Law Enforcement Grants Patrol Services FND11005 CCN4030601 RC610313 PRG110010 GRN-1004164 610000 Federal Operating Grants $ 2,000 $ - $ -
Total Revenues 2,000$ -$ -$
E Law Enforcement Grants Patrol Services FND11005 CCN4030601 SC712020 PRG110010 GRN-1004160 702000 Overtime $ 2,000 - -
Total Expenditures 2,000$ -$ -$
WHEREAS a FY 2023 budget amendment totaling $5,720 is recommended for the Sheriff's Office to recognize amendment #4 to the FY2023 Secondary Road Patrol (SRP) grant to reduce Personnel and increase Deputy Supplies to purchase powerflares. There is no impact to the overall grant. The amendment is
within 15% of the original award (M.R. 22375); and
WHEREAS a FY 2023 budget amendment of $2,500 is recommended for the Sheriff's Office to recognize amendment #2 to the FY2023 Automobile Theft Prevention (ATPA) grant as to maximize reimbursement for an allowable expenditure. The grant is within 15% of the original award (M.R. 22342); and
WHEREAS a FY 2023 budget amendment totaling $2,000 is recommended for the Sheriff's Office for the FY2023 Drug Recognition Expert (DRE) reimbursement grant to recognize actual reimbursable DRE callout hours worked. M.R. #19006 authorizes Management and Budget to administratively process grant
agreements and grant amendments of $10,000 or less, after review and approval by Management and Budget, Human Resources, Risk Management and Corporation Counsel when the grant does not require an associated interlocal agreement, there are no position changes and the grantor does not require a
separate resolution; and
WHEREAS a FY 2023 budget amendment totaling $4,690 is recommended for the Sheriff's Office to recognize amendment #2 to the FY2023 Secondary Road Patrol (SRP) grant by reallocating budgets between line-items causing no impact to the total award. The amendment is within 15% of the original award
(M.R.# 22375).; and
WHEREAS a FY 2023 budget amendment totaling $1,554 is recommended for the Sheriff's Office to recognize amendment #3 to the FY2023 Secondary Road Patrol (SRP) grant by reallocating budgets between line-items causing no impact to the total award. The amendment is within 15% of the original award
(M.R. #22375).; and
6
I I I I I I
I I I
.
R/E Fund Name Division Name
Fund #
(FND)
Cost Center
(CCN) #
Account #
(RC/SC)
Program #
(PRG)
Grant ID
(GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2023
Amendment
FY 2024
Amendment
FY 2025
Amendment
Oakland County, Michigan
Schedule "A" DETAIL
E General Fund Grants Investigative & Forensic Svcs FND10101 CCN4030901 SC712020 PRG110090 GRN-1004071 702000 Overtime (1,404.00)$ -$ -$
E General Fund Grants Investigative & Forensic Svcs FND10101 CCN4030901 SC722770 PRG110090 GRN-1004071 722000 Retirement (339.00)
E General Fund Grants Investigative & Forensic Svcs FND10101 CCN4030901 SC722790 PRG110090 GRN-1004071 722000 Social Security (107.00)
E General Fund Grants Investigative & Forensic Svcs FND10101 CCN4030901 SC730324 PRG110090 GRN-1004071 730000 Communications 4,700.00
E General Fund Grants Investigative & Forensic Svcs FND10101 CCN4030901 SC731465 PRG110090 GRN-1004071 730000 Program (2,850.00)
Total Expenditures -$ -$ -$
R General Fund Patrol Services FND10100 CCN4030601 RC632093 PRG110000 630000 Sheriff Special Deputies $ 83,691 $ 342,745 342,745$
$ 83,691 $ 342,745 $ 342,745
E General Fund Patrol Services FND10100 CCN4030601 SC702010 PRG116180 REG40420 702000 Salaries 34,895$ 152,889$ 152,889$
E General Fund Patrol Services FND10100 CCN4030601 SC712010 PRG116180 REG40420 702000 Overtime - 31,233 31,233
E General Fund Patrol Services FND10100 CCN4030601 SC722900 PRG116180 REG40420 722000 Fringe Benefit Adjustments 19,168 84,830 84,830
E General Fund Patrol Services FND10100 CCN4030601 SC731304 PRG116180 REG40420 730000 Officers Training 308 1,256 1,256
E General Fund Patrol Services FND10100 CCN4030601 SC750070 PRG116180 REG40420 750000 Deputy Supplies 467 1,960 1,960
E General Fund Patrol Services FND10100 CCN4030601 SC750581 PRG116180 REG40420 750000 Uniforms 218 916 916
E General Fund Patrol Services FND10100 CCN4030601 SC772618 PRG116180 REG40420 770000 Equipment Rental 341 1,364 1,364
E General Fund Patrol Services FND10100 CCN4030601 SC773535 PRG116180 REG40420 770000 Info Tech CLEMIS 115 458 458
E General Fund Patrol Services FND10100 CCN4030601 SC773637 PRG116180 REG40420 770000 Info Tech Equipment Rental - - -
E General Fund Patrol Services FND10100 CCN4030601 SC774677 PRG116180 REG40420 770000 Insurance Fund 2,408 10,114 10,114
E General Fund Patrol Services FND10100 CCN4030601 SC776659 PRG116180 REG40420 770000 Motor Pool Fuel Charges 1,211 4,842 4,842
E General Fund Patrol Services FND10100 CCN4030601 SC776661 PRG116180 REG40420 770000 Motor Pool 24,885 51,539 51,539
E General Fund Patrol Services FND10100 CCN4030601 SC778675 PRG116180 REG40420 770000 Telephone Communications 536 1,344 1,344
E General Fund Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 730000 Contingency (860) - -
Total Expenditures 83,691$ 342,745$ 342,745$
E General Fund Patrol Services FND10100 CCN4030601 SC788001 PRG116180 REG40420 BFA53600 788001 Transfer Out - Radio 30,200$ -$ -$
E General Fund Patrol Services FND10100 CCN4030601 SC788001 PRG116180 REG40420 BFA66100 788001 Transfer Out - Motor Pool 50,000 - -
E General Fund Patrol Services FND10100 CCN4030601 SC788001 PRG116180 REG40420 BFA63600 788001 Transfer Out - Info Tech 6,820 - -
E General Fund Non-Departmental FND10100 CCN9090101 SC730359 PRG196030 730000 Contingency (87,020) - -
Total Capital Costs -$ -$ -$
R Radio Communications IT Public Safety and Radio Communications FND53600 CCN1080310 RC695500 PRG115150 BFA10100 695500 Transfer In - Gen Fund $ 30,200 $ - -$
Total Revenue $ 30,200 $ - $ -
E Radio Communications IT Public Safety and Radio Communications FND53600 CCN1080310 SC796500 PRG115150 796500 Budgeted Equity Adj $ 30,200 $ - -$
Total Expenses $ 30,200 $ - $ -
R Information Technology IT Technical Systems and Network FND63600 CCN1080601 RC695500 PRG152096 BFA10100 695500 Transfer In - Gen Fund $ 6,820 $ - -$
R Information Technology IT Technical Systems and Network FND63600 CCN1080601 RC665882 PRG152096 665882 Planned Use of Balance (6,820) - -
R Information Technology IT Technical Systems and Network FND63600 CCN1080601 RC630658 PRG152096 630000 Equipment Rental 341 1,364 1,364
Total Revenue $ 341 $ 1,364 $ 1,364
E Information Technology IT Technical Systems and Network FND63600 CCN1080601 SC760188 PRG152096 761000 Depreciation Equipment $ 341 $ 1,364 1,364$
Total Expenses $ 341 $ 1,364 $ 1,364
R Motor Pool Fund Support Services Lease Vehicles FND66100 CCN1040210 RC695500 PRG184010 BFA10100 695500 Transfer In - Gen Fund $ 50,000 $ - -$
R Motor Pool Fund Support Services Lease Vehicles FND66100 CCN1040210 RC631071 PRG184010 630000 Leased Equipment 12,885 51,539 51,539
R Motor Pool Fund Support Services Lease Vehicles FND66100 CCN1040210 RC631610 PRG184010 630000 Productive Labor 4,000 - -
R Motor Pool Fund Support Services Lease Vehicles FND66100 CCN1040210 RC631463 PRG184010 630000 Parts and Accessories 8,000 - -
R Motor Pool Fund Support Services Lease Vehicles FND66100 CCN1040210 RC630833 PRG184010 630000 Gas Oil Grease Changes 1,211 4,842 4,842
R Motor Pool Fund Support Services Lease Vehicles FND66100 CCN1040210 RC665882 PRG184010 665882 Planned Use of Balance (64,385) (41,539) (41,539)
Total Revenue $ 11,711 $ 14,842 $ 14,842
E Motor Pool Fund Support Services Lease Vehicles FND66100 CCN1040210 SC750210 PRG184010 750000 Gasoline Charges $ 1,211 $ 4,842 4,842$
E Motor Pool Fund Support Services Lease Vehicles FND66100 CCN1040210 SC750413 PRG184010 750000 Parts and Accessories 8,000 - -
E Motor Pool Fund Support Services Lease Vehicles FND66100 CCN1040210 SC760188 PRG184010 761000 Depreciation Vehicles 2,500 10,000 10,000
E Motor Pool Fund Support Services Lease Vehicles FND66100 CCN1040210 SC796500 PRG184010 796500 Budgeted Equity Adjustment - - -
Total Expenses 11,711$ 14,842$ 14,842$
WHEREAS a FY2023-25 budget amendment is recommended for the Sheriff's Office to recognize amendment #1 to the FY2022-24 Law Enforcement Services Agreement with the City of Pontiac (Res. 2023-2816). The amended agreement upgrades one captian position to a major division/substation commender
position and adds two patrol investigator positions along with adding two unmarked patrol vehicles with related equipment. The amended contract took effect July 20,2023; and
WHEREAS a FY 2023 budget amendment totaling $4,700 is recommended for the Sheriff's Office to recognize amendment #2 to the FY2023 High Intensity Drug Trafficking Areas (HIDTA) grant as one of the CVTs will not be participating this year. Overtime funding assigned to this CVT is being reassigned to
other detectives. There is no impact to the overall grant award. The amendment is within 15% of the original award (Res. 2023-3074); and
7
I I I I I I I I I I I I
I I I
I I I
I I I
.
R/E Fund Name Division Name
Fund #
(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 Response & Prep FND10100 CCN4030501 SC731780 PRG116220 730000 Software Support Maintenance $ (26,201)(11,799) -
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC774636 PRG116220 770000 Info Tech Ops 26,201 11,799
Total Expenditures -$ -$ -$
R General Fund Non-Departmental FND10100 CCN9010101 RC665882 PRG196030 665882 Planned Use of Balance $ 1,967,574 $ - $ -
Total Revenue 1,967,574$ -$ -$
E General Fund Non-Departmental FND10100 CCN9090101 SC740142 PRG196030 740000 Salary Adjust. Reserve - (2,496,360) (3,017,793)
E General Fund Corrective Services FND10100 CCN4030301 SC702010 PRG112590 702000 Salaries Regular 25,395 32,326 39,465
E General Fund Corrective Services FND10100 CCN4030301 SC702142 PRG112590 702000 Education Incentives 12,000 12,000 12,000
E General Fund Corrective Services FND10100 CCN4030301 SC712040 PRG112590 702000 Holiday OT 12,000 12,100 12,500
E General Fund Corrective Services FND10100 CCN4030301 SC722750 PRG112590 722000 Workers Comp 269 342 418
E General Fund Corrective Services FND10100 CCN4030301 SC722760 PRG112590 722000 Group Life 66 150 169
E General Fund Corrective Services FND10100 CCN4030301 SC722770 PRG112590 722000 Retirement 6,301 8,021 9,792
E General Fund Corrective Services FND10100 CCN4030301 SC722790 PRG112590 722000 Social Security 1,943 2,473 3,019
E General Fund Corrective Services FND10100 CCN4030301 SC722810 PRG112590 722000 Disability 406 517 631
E General Fund Corrective Services FND10100 CCN4030301 SC722820 PRG112590 722000 Unemployment 25 32 39
E General Fund Corrective Services FND10100 CCN4030301 SC730303 PRG112590 730000 Clothing allowance 1,000 17,550 17,550
E General Fund Corrective Services FND10100 CCN4030301 SC702010 PRG112620 702000 Salaries Regular 209,448 266,609 325,485
E General Fund Corrective Services FND10100 CCN4030301 SC722750 PRG112620 722000 Workers Comp 2,220 2,826 3,450
E General Fund Corrective Services FND10100 CCN4030301 SC722760 PRG112620 722000 Group Life 545 694 847
E General Fund Corrective Services FND10100 CCN4030301 SC722770 PRG112620 722000 Retirement 51,964 66,146 80,753
E General Fund Corrective Services FND10100 CCN4030301 SC722790 PRG112620 722000 Social Security 16,023 20,396 24,900
E General Fund Corrective Services FND10100 CCN4030301 SC722810 PRG112620 722000 Disability 3,351 4,266 5,208
E General Fund Corrective Services FND10100 CCN4030301 SC722820 PRG112620 722000 Unemployment 209 266 325
E General Fund Corrective Services FND10100 CCN4030301 SC702010 PRG112650 702000 Salaries Regular 54,521 69,401 84,727
E General Fund Corrective Services FND10100 CCN4030301 SC722750 PRG112650 722000 Workers Comp 578 736 898
E General Fund Corrective Services FND10100 CCN4030301 SC722760 PRG112650 722000 Group Life 142 181 221
E General Fund Corrective Services FND10100 CCN4030301 SC722770 PRG112650 722000 Retirement 13,527 17,219 21,021
E General Fund Corrective Services FND10100 CCN4030301 SC722790 PRG112650 722000 Social Security 4,171 5,309 6,481
E General Fund Corrective Services FND10100 CCN4030301 SC722810 PRG112650 722000 Disability 872 1,110 1,355
E General Fund Corrective Services FND10100 CCN4030301 SC722820 PRG112650 722000 Unemployment 55 70 85
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC702010 PRG112590 702000 Salaries Regular 25,395 32,326 39,465
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC702142 PRG112590 702000 Education Incentives 4,000 4,000 4,000
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722750 PRG112590 722000 Workers Comp 269 342 418
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722760 PRG112590 722000 Group Life 66 84 103
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722770 PRG112590 722000 Retirement 6,301 8,021 9,792
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722790 PRG112590 722000 Social Security 1,943 2,473 3,019
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722810 PRG112590 722000 Disability 406 517 631
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722820 PRG112590 722000 Unemployment 25 32 39
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC730303 PRG112590 730000 Clothing allowance 500 5,400 5,400
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC702010 PRG112670 702000 Salaries Regular 10,994 13,994 17,084
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722750 PRG112670 722000 Workers Comp 117 149 182
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722760 PRG112670 722000 Group Life 29 37 45
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722770 PRG112670 722000 Retirement 2,728 3,472 4,239
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722790 PRG112670 722000 Social Security 841 1,071 1,307
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722810 PRG112670 722000 Disability 176 224 273
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722820 PRG112670 722000 Unemployment 11 14 17
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC702010 PRG113381 702000 Salaries Regular 32,534 41,413 50,558
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722750 PRG113381 722000 Workers Comp 345 439 536
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722760 PRG113381 722000 Group Life 85 108 132
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722770 PRG113381 722000 Retirement 8,072 10,275 12,544
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722790 PRG113381 722000 Social Security 2,489 3,168 3,868
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722810 PRG113381 722000 Disability 521 663 809
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722820 PRG113381 722000 Unemployment 33 42 51
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC702010 PRG121280 702000 Salaries Regular 21,987 27,988 34,169
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722750 PRG121280 722000 Workers Comp 233 297 363
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722760 PRG121280 722000 Group Life 57 73 89
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722770 PRG121280 722000 Retirement 5,455 6,944 8,477
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722790 PRG121280 722000 Social Security 1,682 2,141 2,614
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722810 PRG121280 722000 Disability 352 448 547
E General Fund Corrective Services Satellite FND10100 CCN4030401 SC722820 PRG121280 722000 Unemployment 22 28 34
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC702010 PRG110005 702000 Salaries Regular 36,389 46,320 56,549
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC702142 PRG110005 702000 Education Incentives 3,000 3,000 3,000
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC722750 PRG110005 722000 Workers Comp 386 491 599
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC722760 PRG110005 722000 Group Life 95 121 148
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC722770 PRG110005 722000 Retirement 9,028 11,492 14,030
WHEREAS a FY2023 budget amendment of $26,201 and FY2024 budget amendment of $11,799 is recommended for the Sheriff's Office reallocating the budget for a software purchase which is rebilled through Info tech Ops
f ft h th t i b i bill d th h I f T h O d
8
I I I I I I I I
I I I
.
R/E Fund Name Division Name
Fund #
(FND)
Cost Center
(CCN) #
Account #
(RC/SC)
Program #
(PRG)
Grant ID
(GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2023
Amendment
FY 2024
Amendment
FY 2025
Amendment
Oakland County, Michigan
Schedule "A" DETAIL
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC722790 PRG110005 722000 Social Security 2,784 3,544 4,327
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC722810 PRG110005 722000 Disability 582 741 905
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC722820 PRG110005 722000 Unemployment 36 46 56
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC730303 PRG110005 730000 Clothing allowance 500 4,050 4,050
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC702010 PRG110110 702000 Salaries Regular 21,987 27,988 34,169
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC722750 PRG110110 722000 Workers Comp 233 297 363
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC722760 PRG110110 722000 Group Life 57 73 89
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC722770 PRG110110 722000 Retirement 5,455 6,944 8,477
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC722790 PRG110110 722000 Social Security 1,682 2,141 2,614
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC722810 PRG110110 722000 Disability 352 448 547
E General Fund Emergency Response & Prep FND10100 CCN4030501 SC722820 PRG110110 722000 Unemployment 22 28 34
E General Fund Patrol Services FND10100 CCN4030601 SC702010 PRG110000 702000 Salaries Regular 25,395 32,326 39,465
E General Fund Patrol Services FND10100 CCN4030601 SC702142 PRG110000 702000 Education Incentives 31,000 31,000 31,000
E General Fund Patrol Services FND10100 CCN4030601 SC712040 PRG110000 702000 Holiday OT 30,000 30,900 32,000
E General Fund Patrol Services FND10100 CCN4030601 SC722750 PRG110000 722000 Workers Comp 269 342 418
E General Fund Patrol Services FND10100 CCN4030601 SC722760 PRG110000 722000 Group Life 66 84 103
E General Fund Patrol Services FND10100 CCN4030601 SC722770 PRG110000 722000 Retirement 6,301 8,021 9,792
E General Fund Patrol Services FND10100 CCN4030601 SC722790 PRG110000 722000 Social Security 1,943 2,473 3,019
E General Fund Patrol Services FND10100 CCN4030601 SC722810 PRG110000 722000 Disability 406 517 631
E General Fund Patrol Services FND10100 CCN4030601 SC722820 PRG110000 722000 Unemployment 25 32 39
E General Fund Patrol Services FND10100 CCN4030601 SC730303 PRG110000 730000 Clothing allowance 9,850 9,850 9,850
E General Fund Patrol Services FND10100 CCN4030601 SC702010 PRG110010 702000 Salaries Regular 10,994 13,994 17,084
E General Fund Patrol Services FND10100 CCN4030601 SC722750 PRG110010 722000 Workers Comp 117 149 182
E General Fund Patrol Services FND10100 CCN4030601 SC722760 PRG110010 722000 Group Life 29 37 45
E General Fund Patrol Services FND10100 CCN4030601 SC722770 PRG110010 722000 Retirement 2,728 3,472 4,239
E General Fund Patrol Services FND10100 CCN4030601 SC722790 PRG110010 722000 Social Security 841 1,071 1,307
E General Fund Patrol Services FND10100 CCN4030601 SC722810 PRG110010 722000 Disability 176 224 273
E General Fund Patrol Services FND10100 CCN4030601 SC722820 PRG110010 722000 Unemployment 11 14 17
E General Fund Patrol Services FND10100 CCN4030601 SC702010 PRG110020 702000 Salaries Regular 10,994 13,994 17,084
E General Fund Patrol Services FND10100 CCN4030601 SC722750 PRG110020 722000 Workers Comp 117 149 182
E General Fund Patrol Services FND10100 CCN4030601 SC722760 PRG110020 722000 Group Life 29 37 45
E General Fund Patrol Services FND10100 CCN4030601 SC722770 PRG110020 722000 Retirement 2,728 3,472 4,239
E General Fund Patrol Services FND10100 CCN4030601 SC722790 PRG110020 722000 Social Security 841 1,071 1,307
E General Fund Patrol Services FND10100 CCN4030601 SC722810 PRG110020 722000 Disability 176 224 273
E General Fund Patrol Services FND10100 CCN4030601 SC722820 PRG110020 722000 Unemployment 11 14 17
E General Fund Patrol Services FND10100 CCN4030601 SC702010 PRG110000 702000 Salaries Regular 612,423 779,562 951,716
E General Fund Patrol Services FND10100 CCN4030601 SC722750 PRG110000 722000 Workers Comp 6,492 8,264 10,089
E General Fund Patrol Services FND10100 CCN4030601 SC722760 PRG110000 722000 Group Life 1,592 2,027 2,475
E General Fund Patrol Services FND10100 CCN4030601 SC722770 PRG110000 722000 Retirement 151,942 193,409 236,120
E General Fund Patrol Services FND10100 CCN4030601 SC722790 PRG110000 722000 Social Security 46,850 59,636 72,806
E General Fund Patrol Services FND10100 CCN4030601 SC722810 PRG110000 722000 Disability 9,799 12,473 15,227
E General Fund Patrol Services FND10100 CCN4030601 SC722820 PRG110000 722000 Unemployment 612 779 951
E General Fund Patrol Services FND10100 CCN4030601 SC702010 PRG116181 702000 Salaries Regular 23,087 29,388 35,878
E General Fund Patrol Services FND10100 CCN4030601 SC722750 PRG116181 722000 Workers Comp 245 312 381
E General Fund Patrol Services FND10100 CCN4030601 SC722760 PRG116181 722000 Group Life 60 76 93
E General Fund Patrol Services FND10100 CCN4030601 SC722770 PRG116181 722000 Retirement 5,728 7,291 8,901
E General Fund Patrol Services FND10100 CCN4030601 SC722790 PRG116181 722000 Social Security 1,766 2,248 2,744
E General Fund Patrol Services FND10100 CCN4030601 SC722810 PRG116181 722000 Disability 369 470 574
E General Fund Patrol Services FND10100 CCN4030601 SC722820 PRG116181 722000 Unemployment 23 29 35
E General Fund Patrol Services FND10100 CCN4030601 SC702010 PRG116200 702000 Salaries Regular 10,994 13,994 17,084
E General Fund Patrol Services FND10100 CCN4030601 SC722750 PRG116200 722000 Workers Comp 117 149 182
E General Fund Patrol Services FND10100 CCN4030601 SC722760 PRG116200 722000 Group Life 29 37 45
E General Fund Patrol Services FND10100 CCN4030601 SC722770 PRG116200 722000 Retirement 2,728 3,472 4,239
E General Fund Patrol Services FND10100 CCN4030601 SC722790 PRG116200 722000 Social Security 841 1,071 1,307
E General Fund Patrol Services FND10100 CCN4030601 SC722810 PRG116200 722000 Disability 176 224 273
E General Fund Patrol Services FND10100 CCN4030601 SC722820 PRG116200 722000 Unemployment 11 14 17
E General Fund Emergency Communications FND10100 CCN4030701 SC702010 PRG112630 702000 Salaries Regular 25,395 32,326 39,465
E General Fund Emergency Communications FND10100 CCN4030701 SC702142 PRG112630 702000 Education Incentives 2,000 2,000 2,000
E General Fund Emergency Communications FND10100 CCN4030701 SC722750 PRG112630 722000 Workers Comp 269 342 418
E General Fund Emergency Communications FND10100 CCN4030701 SC722760 PRG112630 722000 Group Life 66 84 103
E General Fund Emergency Communications FND10100 CCN4030701 SC722770 PRG112630 722000 Retirement 6,301 8,021 9,792
E General Fund Emergency Communications FND10100 CCN4030701 SC722790 PRG112630 722000 Social Security 1,943 2,473 3,019
E General Fund Emergency Communications FND10100 CCN4030701 SC722810 PRG112630 722000 Disability 406 517 631
E General Fund Emergency Communications FND10100 CCN4030701 SC722820 PRG112630 722000 Unemployment 25 32 39
E General Fund Emergency Communications FND10100 CCN4030701 SC730303 PRG112630 730000 Clothing allowance 500 1,350 1,350
E General Fund Technology Info. & Innovation FND10100 CCN4030801 SC702010 PRG110085 702000 Salaries Regular 13,302 16,932 20,671
E General Fund Technology Info. & Innovation FND10100 CCN4030801 SC702142 PRG110085 702000 Education Incentives 800 800 800
E General Fund Technology Info. & Innovation FND10100 CCN4030801 SC722750 PRG110085 722000 Workers Comp 141 179 219
E General Fund Technology Info. & Innovation FND10100 CCN4030801 SC722760 PRG110085 722000 Group Life 35 44 54
E General Fund Technology Info. & Innovation FND10100 CCN4030801 SC722770 PRG110085 722000 Retirement 3,300 4,201 5,129
9
I I I I I I I I I I I I I
.
R/E Fund Name Division Name
Fund #
(FND)
Cost Center
(CCN) #
Account #
(RC/SC)
Program #
(PRG)
Grant ID
(GRN) #
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2023
Amendment
FY 2024
Amendment
FY 2025
Amendment
Oakland County, Michigan
Schedule "A" DETAIL
E General Fund Technology Info. & Innovation FND10100 CCN4030801 SC722790 PRG110085 722000 Social Security 1,018 1,296 1,582
E General Fund Technology Info. & Innovation FND10100 CCN4030801 SC722810 PRG110085 722000 Disability 213 271 331
E General Fund Technology Info. & Innovation FND10100 CCN4030801 SC722820 PRG110085 722000 Unemployment 13 17 21
E General Fund Technology Info. & Innovation FND10100 CCN4030801 SC730303 PRG110085 730000 Clothing allowance 100 675 675
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC702010 PRG110040 702000 Salaries Regular 25,395 32,326 39,465
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC702142 PRG110040 702000 Education Incentives 10,200 10,200 10,200
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722750 PRG110040 722000 Workers Comp 269 342 418
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722760 PRG110040 722000 Group Life 66 84 103
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722770 PRG110040 722000 Retirement 6,301 8,021 9,792
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722790 PRG110040 722000 Social Security 1,943 2,473 3,019
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722810 PRG110040 722000 Disability 406 517 631
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722820 PRG110040 722000 Unemployment 25 32 39
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC730303 PRG110040 730000 Clothing allowance 500 (3,000) (3,000)
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC702010 PRG110050 702000 Salaries Regular 21,987 27,988 34,169
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722750 PRG110050 722000 Workers Comp 233 297 363
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722760 PRG110050 722000 Group Life 57 73 89
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722770 PRG110050 722000 Retirement 5,455 6,944 8,477
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722790 PRG110050 722000 Social Security 1,682 2,141 2,614
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722810 PRG110050 722000 Disability 352 448 547
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722820 PRG110050 722000 Unemployment 22 28 34
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC702010 PRG110060 702000 Salaries Regular 78,055 99,357 121,298
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722750 PRG110060 722000 Workers Comp 827 1,053 1,286
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722760 PRG110060 722000 Group Life 203 258 315
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722770 PRG110060 722000 Retirement 19,365 24,650 30,094
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722790 PRG110060 722000 Social Security 5,971 7,601 9,280
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722810 PRG110060 722000 Disability 1,249 1,590 1,941
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722820 PRG110060 722000 Unemployment 78 99 121
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC702010 PRG110090 702000 Salaries Regular 34,080 43,381 52,961
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722750 PRG110090 722000 Workers Comp 361 460 562
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722760 PRG110090 722000 Group Life 89 113 138
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722770 PRG110090 722000 Retirement 8,455 10,763 13,140
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722790 PRG110090 722000 Social Security 2,607 3,319 4,052
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722810 PRG110090 722000 Disability 545 694 847
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722820 PRG110090 722000 Unemployment 34 43 53
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC702010 PRG116240 702000 Salaries Regular 23,488 29,898 36,500
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722750 PRG116240 722000 Workers Comp 249 317 387
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722760 PRG116240 722000 Group Life 61 78 95
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722770 PRG116240 722000 Retirement 5,827 7,417 9,055
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722790 PRG116240 722000 Social Security 1,797 2,287 2,792
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722810 PRG116240 722000 Disability 376 479 585
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722820 PRG116240 722000 Unemployment 23 29 36
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC702010 PRG116270 702000 Salaries Regular 10,994 13,994 17,084
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722750 PRG116270 722000 Workers Comp 117 149 182
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722760 PRG116270 722000 Group Life 29 37 45
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722770 PRG116270 722000 Retirement 2,728 3,472 4,239
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722790 PRG116270 722000 Social Security 841 1,071 1,307
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722810 PRG116270 722000 Disability 176 224 273
E General Fund Investigative & Forensic Svcs FND10100 CCN4030901 SC722820 PRG116270 722000 Unemployment 11 14 17
Total Expenditures 1,967,574$ -$ -$
WHEREAS a FY2023 budget amendment totaling $1,967,569 and FY2024 totaling $ 2,496,360 and FY2025 totaling $3,017,793 is recommended for the Sheriff's Office to reflect the Command Officers Association Bargaining Unit 15 arbitration agreement; and
10
I I I I I I I I I I I I I
R/E Fund Name Division Name
Fund #
(FND)
Cost Center
(CCN) #
Account #
(RC/SC)
Program #
(PRG)
Grant ID (GRN)
#
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2023
Amendment
FY 2024
Amendment
FY 2025
Amendment
Judicial Grants #11012
R Judicial Grants Circuit Court Civil Criminal FND11012 CCN3010301 RC615571 PRG121200 GRN-1003999 615000 State Operating Grants 8,000.00$ -$ -$
Total Revenues 8,000.00$ -$ -$
E Judicial Grants Circuit Court Civil Criminal FND11012 CCN3010301 SC702010 PRG121200 GRN-1003999 702000 Salaries Regular 7,600.00$ -$ -$
E Judicial Grants Circuit Court Civil Criminal FND11012 CCN3010301 SC722000 PRG121200 GRN-1003999 722000 Fringe Benefits 400.00 - -
Total Expenses 8,000.00$ -$ -$
R Judicial Grants Circuit Court Family Court Srv FND11012 CCN3010402 RC615571 PRG121200 GRN-1004039 615000 State Operating Grants (3,000.00)$ -$ -$
Total Revenues (3,000.00)$ -$ -$
E Judicial Grants Circuit Court Family Court Srv FND11012 CCN3010402 SC731458 PRG121200 GRN-1004039 730000 Professional Services (3,000.00)$ -$ -$
Total Expenses (3,000.00)$ -$ -$
R Judicial Grants District Court I Probation FND11012 CCN3020205 RC615571 PRG121050 GRN-1004001 615000 State Operating Grants 3,000.00$ -$ -$
Total Revenues 3,000.00$ -$ -$
E Judicial Grants District Court I Probation FND11012 CCN3020205 SC730548 PRG121050 GRN-1004001 730000 Drug Testing 3,000.00$ -$ -$
Total Expenses 3,000.00$ -$ -$
E Judicial Grants District Court I Probation FND11012 CCN3020205 SC730373 PRG121050 GRN-1004012 730000 Contracted Services (109.00)$ -$ -$
E Judicial Grants District Court I Probation FND11012 CCN3020205 SC732018 PRG121050 GRN-1004012 730000 Travel and Conference 109.00 - -
Total Expenses -$ -$ -$
Access and Visitation Grant
R Other Grants CC Family Friend of the Court FND11011 CCN3010404 RC610313 PRG126030 GRN-0003985 610000 Federal Operating Grants 9,000.00$ -$ -$
Total Revenues 9,000.00$ -$ -$
E Other Grants CC Family Friend of the Court FND11011 CCN3010404 SC731458 PRG126030 GRN-0003985 730000 Professional Services 9,000.00$ -$ -$
Total Expenses 9,000.00$ -$ -$
Oakland County, Michigan
Schedule "B" DETAIL
WHEREAS a FY2023 budget amendment totaling $8,000 is recommended for Circuit Court to recognize amendment #1 for the FY 2023 Michigan Veteran’s Drug Treatment Court Grant providing additional funding for Personnel. The amendment is within 15% of the original award
(M.R.# 22397); and
WHEREAS a FY 2023 budget amendment of ($3,000) is recommended for Circuit Court's Friend of the Court recognizing amendment #1 for a funding reduction to the FY 2023 Michigan Juvenile Mental Health Court Grant, due to third-party hiring constraints. The amendment is
within 15% of the original award (M.R.# 22409).; and
WHEREAS a FY 2023 budget amendment of $3,000 is recommended for 52/1 District Court recognizing amendment #1 of the FY 2023 Michigan Drug Court Grant, in which additional funding was awarded for the Drug Testing program. The amendment is within 15% of the original
award (M.R.# 22386); and
WHEREAS a FY2023 budget amendment of $109 is reocmmended for 52/1 (Novi) District Court to recognize amendment #1 to the FY 2023 Michigan Mental Health Court Grant,reallocate $109 from Contracted Services to Travel and Conference. There is no impact to the original
award and the amendment is within 15% (M.R.# 22387).; and
WHEREAS a FY2023 budget amendment of $9,000 is recommended for Circuit Court's Friend of the Court recognizing amendment #1 for additional funding to the FY 2023 Access and Visitation grant program. The amendment is within 15% of the original award (M.R.# 22411).;
and
11
I I I I I I I I I I
R/E Fund Name Division Name
Fund #
(FND)
Cost Center
(CCN) #
Account #
(RC/SC)
Program #
(PRG)
Grant ID (GRN)
#
Project ID #
(PROJ)
Region
(REG)
Budget
Fund
Affiliate
(BFA)
Ledger
Account
Summary Account Title
FY 2023
Amendment
FY 2024
Amendment
FY 2025
Amendment
Oakland County, Michigan
Schedule "B" DETAIL
Radio #53600
R RADIO
IT Public Safety and Radio
Communications FND53600 CCN1080310 RC665882 PRG115150 665882 Planned Use of Fund Balance $ (228,500) $ - $ -
Total Revenues (228,500)$ -$ -$
E RADIO
IT Public Safety and Radio
Communications FND53600 CCN1080310 SC796500 PRG115150 796500 Budgeted Equity Adjustments $ (228,500) $ - $ -
Total Expenses (228,500)$ -$ -$
Motor Pool #66100
E Motor Pool Support Services Lease Vehicles FND66100 CCN1040210 SC760188 PRG184010 760000 Capital Outlay-Vehicles (64,445.00)$ -$ -$
E Motor Pool Support Services Lease Vehicles FND66100 CCN1040210 SC760188 PRG184010 761000 Depreciation Expense-Vehicles 64,445.00$ -$ -$
Total Expenses -$ -$ -$
Parks & Recreation #50800
E Parks and Recreation Addison Oaks Park FND50800 CCN5060150 SC730198 PRG160720 730000 Building Maint Charges 919$ - -
E Parks and Recreation Addison Oaks FND50800 CCN5060150 SC730814 PRG160710 730000 Grounds Maint $ 12,629 - -
E Parks and Recreation Administrative Services FND50800 CCN5060101 SC730814 PRG160000 730000 Grounds Maint $ 13,050 - -
E Parks and Recreation Glen Oaks FND50800 CCN5060172 SC730198 PRG160010 730000 Building Maint Charges $ 9,985 - -
E Parks and Recreation Glen Oaks FND50800 CCN5060172 SC730814 PRG160010 730000 Grounds Maint $ 13,410 - -
E Parks and Recreation Groveland Oaks Park FND50800 CCN5060152 SC730198 PRG160710 730000 Building Maint Charges $ 1,388 - -
E Parks and Recreation Groveland Oaks FND50800 CCN5060152 SC730814 PRG160710 730000 Grounds Maint $ 63,267 - -
E Parks and Recreation Independence Oaks FND50800 CCN5060160 SC730198 PRG160700 730000 Building Maint Charges $ 16,535 - -
E Parks and Recreation Independence Oaks FND50800 CCN5060160 SC730814 PRG160700 730000 Grounds Maint $ 3,400 - -
E Parks and Recreation Orion Oaks FND50800 CCN5060162 SC730198 PRG160700 730000 Building Maint Charges $ 2,307 - -
E Parks and Recreation Red Oaks Park FND50800 CCN5060176 SC730198 PRG160700 730000 Building Maint Charges $ 36,380 - -
E Parks and Recreation Red Oaks Park FND50800 CCN5060176 SC730814 PRG160700 730000 Grounds Maint $ 4,603 - -
E Parks and Recreation Waterford Oaks FND50800 CCN5060164 SC730198 PRG160700 730000 Building Maint Charges $ 59 - -
E Parks and Recreation Waterford Oaks FND50800 CCN5060164 SC730814 PRG160700 730000 Grounds Maint $ 33,257 - -
E Parks and Recreation Facilities Maintenance FND50800 CCN5060910 SC730789 PRG106430 730000 General Program Admin $ (211,189)- -
Total Expenditures -$ -$ -$
Human Service Grants #11007
R Human Service Grants Health FND11007 CCN1060201 RC610313 PRG133095 GRN-1003907 610000 Federal Operating Grants 100,000.00$ - -
100,000.00$ -$ -$
E Human Service Grants Health FND11007 CCN1060201 SC750294 PRG133095 GRN-1003907 750000 Materials and Supplies 100,000.00 - -
100,000.00$ -$ -$
Drain Equipment #63900
R Drain Equipment Drain Commissioner Admin FND63900 CCN6010101 RC631869 PRG149760 630000 Reimbursement Salaries (222,830.00)$ -$ -$
R Drain Equipment Drain Commissioner Admin FND63900 CCN6010101 RC631876 PRG149760 630000 Reimbursement Salaries Constr A 222,830.00$ -$ -$
Total Revenues -$ -$ -$
WHEREAS a FY 2023 budget amendment of ($228,500) is recommended for the Radio Communications Fund (#53600) to correct the budget through a reallocation from Budgeted Equity to Planned Use of Fund Balance; and
WHEREAS a FY 2023 budget amendment of $100,000 is recommended for Health and Human Services Health Division to recognize Amendment #4 to the FY 2023 Emerging Threats Local Health Department for the Monkeypox Virus Response Program. The amendment is within
15% of the original award (M.R. #22328); and
WHEREAS a FY 2023 budget amendment of $222,830 is recommended for the Water Resources Commissioner (Drain Equipment Fund #63900) correcting M.R.#2023-2611 as the budget referenced the incorrect revenue account.; and
WHEREAS a FY 2023 Budget Amendment of $64,445 is recommended for Motor Pool fund (#66100) correcting the data entry error used for the Vehicles line item budget (SC760188) from ledger account summary (760000) to ledger account summary Depreciation Expense
(761000); and
WHEREAS a FY 2023 budget amendment totaling $211,189 is recommended for Parks and Recreation fund (#50800) for 3rd Quarter transfers; and
12
I I I I I I I I I I I I I I
I I I I
I I I I
R/E Fund Name Division Name
Fund #
(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
Housing & Comm Deveopment #11006
R Housing & Comm Dev NHD FND11006 CCN1060702 RC610313 PRG132210 GRN-1004055 610000 Federal Operating Grants 7,632$ -$ -$
Total Revenues 7,632$ -$ -$
E Housing & Comm Dev NHD FND11006 CCN1060702 SC702010 PRG132210 GRN-1004055 702000 Salaries 5,654$ -$ -$
E Housing & Comm Dev NHD FND11006 CCN1060702 SC722740 PRG132210 GRN-1004055 722000 Fringe Benefits 1,978 - -
Total Expenditures 7,632$ -$ -$
Law Enforcement Grants
R Sheriff LE Enhancement Investigative & Forensic Svcs FND21340 CCN4030901 RC665882 PRG116240 GRN-1004116 665882 Planned Use of Balance $ (20,555) $ - $ -
Total Revenues (20,555)$ -$ -$
E Sheriff LE Enhancement Investigative & Forensic Svcs FND21340 CCN4030901 SC788001 PRG116240 GRN-1004116 FND11005 788001 Transfers Out (20,555)$ -$ -$
Total Expenditures (20,555)$ -$ -$
R Law Enforcement Grants Investigative & Forensic Svcs FND11005 CCN4030901 RC610313 PRG116240 GRN-1004117 610000 Federal Operating Grants $ - $ - $ -
R Law Enforcement Grants Investigative & Forensic Svcs FND11005 CCN4030901 RC695500 PRG116240 GRN-1004116 FND21340 695500 Transfers In - Sheriff LE Enhance (20,555) - -
Total Revenues (20,555)$ -$ -$
E Law Enforcement Grants Investigative & Forensic Svcs FND11005 CCN4030901 SC702010 PRG116240 GRN-1004117 702000 Salaries (16,896)$ -$ -$
E Law Enforcement Grants Investigative & Forensic Svcs FND11005 CCN4030901 SC722900 PRG116240 GRN-1004117 722000 Fringe Benefit Adjustments (3,938)
E Law Enforcement Grants Investigative & Forensic Svcs FND11005 CCN4030901 SC750280 PRG116240 GRN-1004117 750000 Laboratory Supplies 279
Total Expenditures (20,555)$ -$ -$
WHEREAS a FY2023 budget amendment totaling ($20,555) is recommended for the Sheriff's Office to recognize amendment #1 to the FY2023 Paul Coverdell Forensic Sciences Improvement Program Grant, decreasing the local match amount due personnel re-assignments. The
amendment is within 15% of the original award (Res. 2023-2823); and
WHEREAS a FY 2023 budget amendment of $7,632 is recommended for Health and Human Services Neighborhood Housing and Development to recognize amendment #1 for the FY 2022 Comprehensive Housing Counseling Grant Program. The amendment is within 15% of the
original grant award (M.R. #22423).; and
13
I I I I I I I I I I I I I I I
I I I I
I I I I