HomeMy WebLinkAboutResolutions - 2021.06.17 - 34672MISCELLANEOUS RESOLUTION, 921259 June 17, 2021
BY: Commissioner Gwen Markham, Chairperson, Finance Committee
IN RE: MANAGEMENT AND BUDGET - FISCAL YEAR 2021 SECOND QUARTER FINANCIAL
FORECAST AND BUDGET AMENDMENTS
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of
Government, provides for adjustments to the adopted budget; and
WHEREAS in accordance with Oakland County General Appropriations Act Section 22, which authorizes
budget amendments for variances between the budgeted revenue and actual revenue, and Section 23,
which authorizes budget amendments for variance between estimated revenue and projected
expenditures, amendments are required; and
WHEREAS the Fiscal Year (FY) 2021 Second Quarter Financial Forecast Report has identified several
variances and budget amendments are recommended; and
WHEREAS a FY 2021 budget amendment is recommended for Circuit Court correcting an entry reflected
in M.R. #20644 Circuit Court — FY 2021 Michigan Drug Court Grant Program (Adult Treatment Court) -
Acceptance in which the one-time request for the use of Grant Match in the amount of $14,000 was not
needed; the funds will be transferred from Circuit Court's Adult Treatment Court grant fund (#27130) to
Non -Department Grant Match General Fund/General Purpose budget (#10100); and
WHEREAS a FY 2021 budget amendment totaling $235,200 is recommended to reallocate funding from
the Circuit Court General Jurisdiction Civil Mediation Payments account (10100-3010301-121150-
240201), with $225,200 to the Judicial Administration's Expendable Equipment expenditure account to
purchase replacement furniture for various courtrooms, judicial chambers, and judicial staff office areas
and $10,000 to the Judicial Administration's Professional Services expenditure account for payment to the
Oakland County Bar Association related to their assistance for case evaluation and Bench/Bar programs;
and
WHEREAS a FY 2021 budget amendment of $5,500 is recommended for the Prosecutor's Office to
relocate a portion of the salaries budget for the summer Law Clerk position (P000015060 has been
frozen) to Contracted Services. The summer law clerk was provided by the Prosecuting Attorneys
Association of Michigan (PAAM); and
WHEREAS a FY 2021 budget amendment is recommended for the Prosecuting Attorney in the amount of
$150,000 to fund a special prosecutor to conduct an independent investigation of a 2006 case. Funding
will be provided by the favorable Juvenile Resentencing expenditure line item (Account 740084) in the
Non -Departmental General Fund; and
WHEREAS the Sheriff's Office receipt of forfeiture/enhancement funds are recorded in separate restricted
funds that require a transfer to the General Fund for use of the monies. Transfers In from the various
restricted funds in the amount of $179,810 is being recognized for eligible personnel, forensic lab and
training costs for dispatchers and corrections officers; and
WHEREAS a FY 2021 budget amendment is recommended for the Sheriff's Office to recognize a
donation in the amount of $150 from Paula E. Stewart -Williams to be used for Deputy Supplies; and
WHEREAS a FY 2021 budget amendment of ($300,000) is recommended for the Board of
Commissioners correcting the entry referenced within Schedule C of the FY 2020 Year End Report (M.R.
#20635) as funds had already been re -appropriated per M.R. #20452 Board of Commissioners — School
Drinking Water Station Program — FY 2021 Appropriation and Reallocation of County CARES Act
Coronavirus Relief Funds; and
WHEREAS a FY 2021 budget amendment of $16,918 is recommended for the Board of Commissioners
to reallocate funds from expenditure line item Library Continuations (Account 731101) to Internal Services
expenditure line item IT Operations (Account 774636) for the purchase of 22 larger Apple Fact Pros (11
inch) and accessories for the implementation of the Civic Clerk system. The devices will be kept on -site
for in -person Board of Commissioners meetings dedicated to both the Board Auditorium and Committee
Room; and
WHEREAS a FY 2021 budget amendment of $44,000 is recommended for Health and Human Services,
Health Division to correct budget for the Public Health Nurse reimbursement agreement with Oakland
Intermediate School District (M.R. #21014); and
WHEREAS a FY 2021 budget amendment in the amount of $1,000,000 is recommended for Economic
Development, Planning & Local Business Development Division as the funding was inadvertently not
included in the FY 2020 Year End Report (M.R. #20635) as a Carryforward The funding will be used to
implement Oakland County's manufacturing diversification strategies in FY 2021; and
WHEREAS a FY 2021 budget amendment is recommended for Non -Department General Fund General
Purpose (GF/GP) budget to correct M.R. #20447 Board of Commissioners — Tri-Party Road Improvement
Program Fiscal Year 2021 Appropriation — Charter Township of Bloomfield — Resurfacing of Maple Road
from Inkster Road to Franklin Road — Project No. 55341 to include the FY 2022 amount of $52,627 as it
was inadvertently omitted. The funding is available in the General Fund Assigned Fund Balance for Tri-
Party 2021 and prior funding (account #383510) for Project No. 55341. The total amount of the project is
$144,445; and
WHEREAS a FY 2021 budget amendment totaling $1,690,849 is recommended for the Sheriff's Office FY
2021 Auto Theft Prevention Authority grant (#27310) correcting the grant project identification number by
reallocating the budgets from grant project number GR0000000377 to grant project number
GR0000000974. There is no impact on the total FY 2021 grant award (M.R. #20424); and
WHEREAS the Sheriff's Office will receive reimbursement funding from the Office of Highway Safety
Planning (OHSP) for the period of October 1, 2020, through September 30, 2021. The funding will be
used to reimburse up to four hours of overtime per callout to Michigan certified Drug Recognition Experts
(DRE) in good standing who respond to a request for service related to drugged driving cases; the
reimbursement amount will be less than $10,000. There is no required County match. A budget
amendment is not required as the amount of funding is unknown at this time. Miscellaneous Resolution
#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 2021 - FY 2023 budget amendment in the amount of $5,550 is recommended for the
Health Division to reallocate the budget between expenditure line items correcting the budget entry
referenced in M.R. 20459 FY 2021 Local Health Department (Comprehensive) Agreement for the HIV
Prep Clinic Grant (#28629); and
WHEREAS a FY 2021 budget amendment totaling $2,592,860 is recommended for Health Divisions'
Special Revenue fund COVID-19 Fund (#28630) to reallocate the expenditure line -item budgets
referenced in M.R. #21128 Amendment #2 Supplemental to the FY 2021 Local Health Department
(Comprehensive) Agreement to support COVID-19 vaccination events; and
WHEREAS the Health Division's FY 2021 Michigan Department of Environment, Great Lakes, and
Energy (EGLE) Water Resources Division's Grant Agreement (M.R. #20560; EGLE COVID-19 Fund
#28632) with the Michigan Department of Environmental, Great Lakes, and Energy (EGLE), Water
Resources Division (WRD) was modified to reflect Amendment #1 which extends the reimbursement
agreement end date from December 30, 2020, to February 15, 2021; a budget amendment is not
required; and
WHEREAS a FY 2021 - FY 2022 budget amendment totaling $3,166,997 is recommended for the Health
and Human Services, Neighborhood and Housing Development division's Emergency Solutions Grant
Fund (#29701) correcting the Budget Reference reflected in M.R. #20235 Economic Development &
Community Affairs - Community & Home Improvement Division Substantial Amendment to PY 2019
Annual Action Plan for Grant Allocation Acceptance of Coronavirus Aid, Relief, and Economic Security
Act (CARES Act) (P.L. 116-136) Community Development Block Grant (CDBG-CV) and Emergency
Solutions Grant (ESG-CV) U.S. Department of Housing and Urban Development (HUD) as the budget
reference reflected in the resolution was 2020 and should be 2019; and
WHEREAS a FY 2021 - FY 2022 budget amendment totaling $1,155,293 is recommended for the Health
and Human Services, Neighborhood and Housing Development division's Emergency Solutions Grant
Fund (#29705) correcting the Budget Reference reflected in M.R. #20235 Economic Development &
Community Affairs - Community & Home Improvement Division Substantial Amendment to PY 2019
Annual Action Plan for Grant Allocation Acceptance of Coronavirus Aid, Relief, and Economic Security
Act (CARES Act) (P.L. 116-136) Community Development Block Grant (CDBG-CV) and Emergency
Solutions Grant (ESG-CV) U.S. Department of Housing and Urban Development (HUD) as the budget
reference reflected in the resolution was 2020 and should be 2019; and
WHEREAS a FY 2021 budget amendment totaling $2,033,828 is recommended for the Health and
Human Services, Neighborhood and Housing Development division's Emergency Solutions Grant Fund
(#29705), correcting the Budget Reference reflected in M.R. #21129 Health and Human Services —
Neighborhood and Housing Development Division — Amendment Over 15% to PY 2019 Annual Action
Plan and Special Grant Allocation Acceptance for Coronavirus Aid, Relief, and Economic Security
(CARES) Act (P L. 116-136) Emergency Solutions Grant (ESG-CV2) Round 2 as the budget reference
reflected in the resolution was 2020 and should be 2019; and
WHEREAS a MIDC approved FY 2021 Budget Adjustment (Budget Adjustment #2) is recommended for
the Michigan Indigent Defense Commission (MIDC) fund (#20260) to reallocate $13,500 from Defense
Attorney Fees expenditure line item (Account 730450) to Training expenditure line item (Account 731941)
for a one-year subscription to State Defender Office (SADO) Criminal Law Resource Center for up to 350
attorneys on the public defender attorney lists for the Oakland County Courts; and
WHEREAS a MIDC approved FY2021 Budget Adjustment (Budget Adjustment #3) is recommended for
the MIDC fund (#20260) to reallocate $122,699 from Defense Attorney Fees expenditure line item
(Account 730450) to various expenditure line items to accelerate the hiring of the Chief Attorney for its
managed assigned counsel system (who will head the County's Office of Indigent Defense Services for
the last 1/2 of FY 2021) and provide necessary office set-up including furniture, computer, copier, and
phone; and
WHEREAS a MIDC approved FY 2021 budget amendment (Budget Adjustment #4) is recommended for
the Michigan Indigent Defense Commission (MIDC) fund (#20260) to reallocate $720 from Defense
Attorney Fees expenditure line item (Account 730450) to Telephone Communications expenditure line
item (Account 778675) for an additional iPad for confidential meetings for critical stage and arraignment
proceedings; and
WHEREAS a FY 2021 budget amendment of $20,000 is recommended for Community Corrections to
recognize adjustments to the FY 2021 Michigan Department of Corrections - Community Corrections
Comprehensive Plan to reflect Amendment #1, which is less than fifteen percent of the original
agreement (M.R. #21022) and does not impact the total amount of grant funding; and
WHEREAS a FY 2021 budget amendment totaling $100,000 is recommended for the Economic
Development Workforce Development Department's Fiscal Year 2021 County Veteran Service Fund
(CVSF) Fund (#29252), which reallocates the budgets between line item expenditure accounts to reflect
Amendment #1, which is less than fifteen percent of the original agreement (M.R. 20525), and
WHEREAS the FY 2020 County Veterans Service Fund Grant agreement (M.R. #20119) was modified to
reflect Amendment #2, which extends the funding period from September 30, 2020, to April 30, 2021 and
extends the reporting due date to May 7, 2021; a budget amendment is not required; and
WHEREAS a FY 2021 grant acceptance is recommended from the Michigan Department of
Transportation to accept $2,000 in reimbursement funding for Aircraft Rescue and Fire Fighting (ARFF)
training at the Oakland County International Airport. Miscellaneous Resolution #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 the grant does not require an associated interlocal agreement,
there are no position changes, and the grantor does not require a separate resolution. A budget
amendment is not required; and
WHEREAS a FY 2021 — FY 2023 budget amendment is recommended for the Fringe Benefit fund
(#67800) correcting a budget entry in the amount of $29,708 from the Overtime expenditure line item
(Account 712020) to Workers Compensation expenditure line item (Account 722750); and
WHEREAS a FY 2021 budget amendment is recommended for Parks and Recreation Fund (#50800) to
adjust the Delinquent Tax Prior Years and Property Tax Levy revenue line items budgets reflecting
current trend of delinquent tax payments; Income from Investments related to investment loss, ($82,000)
and amend Capital Asset Contributions $46,675 reflecting classification changes to capital improvement
projects at Springfield Oaks and Independence Oaks. In addition, to adjust various expense line item
budgets, which include the transfer of funds from General Program Administration funds in the amount of
$245,522 to various parks incurring maintenance project costs during the first and second quarter of FY
2021. Adj. Prior Years revenue due to repair of severed wires, $4,671. In addition, the Parks and
Recreation Commission approved a request at their May meeting of $39,896 for a contracted county -wide
invasive species treatment to be funded from unrestricted net position. Also, three amendments were
approved to move funds totaling $137,081 from the operating budget to unrestricted net position natural
resources prescribed burn, $70,000, pavement maintenance program, $43,758, and ADA maintenance,
$23,323; and
WHEREAS per the General Appropriations Act and Miscellaneous Resolution #93156, a review of the
carry forward appropriation has been conducted to determine if the appropriation shall continue for the
remainder of the fiscal year; and
WHEREAS the departments have expended much of their carry forward requests and the remaining
balance is expected to be utilized by the end of FY 2021; and
WHEREAS the Parks and Recreation Commission has requested write-off in the amount of $5.00 for the
period of January 2021 through March 2021 for uncollectible transactions; and
WHEREAS a donation is recognized in the Department of Public Services, Animal Shelter and Pet
Adoption Center in the amount of $5,000 from the Trust of Linda Holtzman to be used for the care of
animals; and
WHEREAS the Department of Public Services, Animal Shelter and Pet Adoption Center received
donations for the period of January 2021 through March 2021 totaling $28,363.36; and
WHEREAS the Department of Health and Human Services, Children's Village Division, received
donations for the period of January 2021 through March 2021 totaling $12,068.81, of which $3,150.00
were cash donations; and
WHEREAS the Parks and Recreation Commission received donations for the period of January 2021
through March 2021 totaling $180.00.
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2021
Second Quarter Financial Report.
BE IT FURTHER RESOLVED that $235,200 be transferred in FY 2021 from the Circuit Court General
Jurisdiction's Civil Mediation Payments account (10100-3010301-121150-240201) to the following:
$225,200 to Judicial Administrations Expendable Equipment expense account to partially offset the
expenditures for the replacement of furniture for various courtrooms, judicial staff office, judicial chambers
and $10,000 to Judicial Administration's Professional Services expenditure account for the payment to
the Oakland County Bar Association related to their assistance for case evaluation and Bench/Bar
programs.
GENERAL FUND (#10100)
Revenue FY 2021
3010301-121150-630245 Circuit Court Gen Jury — Civil Mediation Payments $235,200
Total Revenue
Expenditures
3010101-121100-750154 Circuit Court Jud Admin — Expendable Equip. $225,200
3010101-121100-731458 Professional Services 10000
Total Expenditures $20
BE IT FURTHER RESOLVED that the uncollectible debts, as recommended by the Department of
Management and Budget and detailed in the attached schedules, are authorized to be written off.
BE IT FURTHER RESOLVED that the donations be recognized in the Animal Shelter and Pet Adoption
Center, Children's Village Division, Parks and Recreation Commission and Sheriff's Office.
BE IT FURTHER RESOLVED that the FY 2021 — FY 2023 Budgets are amended pursuant to Schedules
A and B.
Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution.
Commissioner Gwen Markham, District #9
Chairperson, Finance Committee
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote.
COUNTY MICHIGAN
MANAGEMENT & BUDGET
TO: Members of the Finance Committee
OAKLAND COUNTY EXECUTIVE DAVID COULTER
FROM: Kyle Jen, Director, Management and Budget
Lynn Sonkiss, Manager, Fiscal Services
Holly Conforti, Chief, Fiscal Services
Ebru Adoglu-Jones, Supervisor of Fiscal Services
SUBJECT: Letter of Transmittal - Fiscal Year 2021 Second Quarter Forecast
DATE: June 9, 2021
FY 2021 SECOND QUARTER REPORT
Attached please find the Fiscal Year (FY) 2021 Second Quarter Forecast Report. In total, Fiscal
Services forecasts that the County will complete FY 2021 with an overall favorable variance of
$27,964,148 General Fund/General Purpose (GF/GP) operations, compared to the amended budget.
GF/GP includes all operations except grants, enterprise funds, and internal service funds. This overall
favorability is the net result of receiving ($4,965,970) less revenue than anticipated and projected
favorability in expenditures of $32,920,11B.
REVENUES
GF/GP revenues are 0.79% less than budget or ($4,965,970). Major variances are the result of the
following events:
A. TAXES — Favorable: $4,900,000
Favorable Property Taxes due to the overall 2021 taxable value increase of 3,84% when
comparing to the FY 2021 budget that estimated a 1.80% taxable value increase due to the
unknown pandemic impact at the time. Miscellaneous Resolution #21163 adopted April 29,
2021 amended the budget and the updated budget will be reflected with the third quarter report.
B. STATE GRANTS — Unfavorable: ($2,000,000)
Unfavorable primarily due to less than anticipated reimbursement from the State on eligible
childcare costs; offset by Child Care Fund expenditure favorability.
C. CHARGES FOR SERVICES — Unfavorable: ($7,989,881)
Unfavorable Ordinance Fines and Costs ($2,750,000), Probation Fees ($750,000) and State
Law Costs ($200,000) across the District Courts for the reduction in caseloads due to COVID-19
pandemic; Sheriffs Office ($950,000) Diverted Felon, ($900,000) Drug Testing, ($800,000)
Reimbursement Salaries, ($285,000) Commissions Contracts, ($200,000) Civil Action Service
Fees, ($140,000) Fingerprints due to reduced activity; which is primarily due to the pandemic.
Further reductions in activity due to the COVID-19 pandemic include Payments Other Than
Anticipated ($1,000,000) due to no land sale activity for Treasurer's Office; Court Costs
($350,000), Mediation Fees ($105,000), and ($80,000) Jury Fees due to less than anticipated
revenue within Circuit Court; ($400,000) Immunizations, ($200,000) Inspection Fees, ($100,000)
Clinic Charges within Health and Human Services; ($293,000) Sale of Licenses projected for
Animal Control; and ($140,000) Community Corrections Fee Income due to suspension of the
Weekend and Weekday Alternative for Misdemeanants (WWAM) program.
2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 1 Fax (248) 452-9172 1 OakGov.conn
This is partially offset by favorable Clerk's Office $1,000,000 Land Transfer Tax and $500,000
Recording Fees due to increased activity.
D. OTHER REVENUES — Favorable: $173,286
Favorable primarily due to $121,400 in Health Division for an adjustment to the administrative
overhead cost distribution for the Comprehensive Planning, Budgeting and Contracting (CPBC)
grant and approximately $39,700 reimbursement revenue received for Michigan Department of
Corrections inmates housed in the jail as a result of the pandemic.
EXPENDITURES
In total, expenditures are projected to be 5.21% under budget or $32,920,118 favorable. Many
departments have experienced personnel savings as the result of turnover and under -filling of
positions. There is a $10.0 million personnel favorability factor and a $6.0 million operating expenditure
favorability factor already included in the budget under non -departmental General Fund. As the year
progresses this overall net favorability may increase as departments continue to work to reduce their
costs and streamline operations.
The Budget perspective shows that the County is projected to be favorable by $28.0 million when
comparing budget to actuals. This significant variance is attributed to the timing and recognition of
CARES Act grant revenues and expenditures. The County had $128,624,402 CARES Act funds
remaining from the original $219,438,710 that was provided to Oakland County such that the remaining
balance would be utilized through December 30, 2020. Part of the CARES Act funding was eligible
toward departmental public safety and public health personnel costs.
There is one department projected to be unfavorable at the end of the fiscal year (barring any
amendments); Water Resources Commissioner.
Water Resources Commissioner — Unfavorable: ($23,500)
• The department is forecasted to be unfavorable primarily due to an increase in contracted
services due to spending on the Northwest Interceptor Comprehensive Study project. The
unfavorable expenditure forecast is offset by favorable Charges for Services revenue for WRC
of approximately $25,000. No budget amendment is required at this time.
Note that while some individual divisions may be over budget, the budget is controlled at the
department level. The General Appropriations Act requires that appropriations accumulate at the
following three summary levels of expenditures within each County Department and are deemed
maximum authorization for expenditures: Personnel Expenditures, Operating Expenditures, and
Internal Support Expenditures.
Reauired Reportina Adiustments
The Quarterly Forecast presents the County's financial position in relation to the amended budget
(Budget perspective). This form of presentation is used so that users of this forecast can assess the
2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 1 Fax (248) 452-9172 1 OakGov.com 2
true financial impact of County operations in comparison to the budget for the current fiscal year.
However, it is important to note that this presentation style does not fully coincide with the accounting
requirements of audited financial statements produced by the County. The County's financial
statements are required to follow Generally Accepted Accounting Principles or GAAP.
Forecast Presentation — Budgetary Perspective
The presentation reflects the current best assessment of fiscal activity for FY 2021:
Revenues - over/ (under) budget
Expenditures — (over)/under budget
Total Officially Reported Favorability
$(4,965,970)
32, 920,118
$27.954.148
GAAP Reauired Reporting Method
Under GAAP, the Planned Use of Fund Balance is removed as a "revenue" source. The amended
revenue budget assumes the use of $44,665,166 in fund balance. Fund balance is budgeted, and if
available can be used as a funding source; however, GAAP does not allow fund balance to be
"recorded as revenue". This is because Fund Balance is the residual of revenue and expenditures
accumulated over the years, revenue cannot be recognized as income more than once. The FY 2021
adopted budget for the Planned Use of Fund Balance started out at $609,338 and there have been
resolutions authorized during FY 2021 to bring it to the $44,665,166 level as of March 31, 2021. This
includes approximately $14.1 million of carry forward requests that were approved with the FY 2020
Year End Report resolution (M.R. #20635). Also included in the use of fund balance are adopted
resolutions containing one-time expenditures amounts for pandemic related funding, Radio System
project investments, Financial and Human Capital Management system implementation project,
Community Policing Innovations project, Strategic Planning and Equity Audit project, Restaurant Relief
program funding, and Tri-Party road projects. The equity section of the contingency packet contains a
comprehensive summary of all the authorized resolutions. Thus, when Use of Fund Balance is
removed from the revenue calculation, the impact on the County's official financial statements is:
Revenue Variance $ (4,965,970)
Reduce— Planned use of Fund Balance (44,665,166)
Revenue Variance $(49,631,136)
Expenditure Variance (Comparing Actual to Approved Plan) 32.920.118
GAAP Reported Effect on Fund Balance $(16.711.018)
It is important to analyze the forecast using both the Budget perspective and the GAAP perspective to
accurately reflect the impact of fiscal activity generated from FY 2021 operations.
The Budget perspective recognizes the overall favorable operating budget variance and confirms the
County's continuing efforts to maintain long-term fiscal stability particularly through continuation of
prudent fiscal policies and the stringent scrutiny applied to all requested expenditures.
The GAAP perspective provides information as to the effect on Fund Balance. This forecast projects
that the General Fund balance will decrease by $16.7 million by the end of Fiscal Year 2021. It should
be noted while the amended budget reflects the utilization of $44.7 million of Fund Balance, this
2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 1 Fax (248) 452-9172 1 OakGov corn 3
forecast projects the use of Fund Balance ultimately needed to support FY 2021 activities will be $16.7
million, $28.0 million less than planned. It is also important to note that on -going expenditures
associated with the COVID-19 pandemic continue to be monitored and subsequent funding
opportunities provided by the federal or state resources will be leveraged to address the impact.
2100 Pontiac Lake Road I County Executive Building 41 W I Waterford, Ml 48328 1 Fax (248) 452-9172 1 OakGov.corn 4,
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2021 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
jGF/GP OPERATIONS -SELF BALANCING AMENDMENTS
GENERAL FUND (#1010011
Dept Program Acct Fund Aff. Oa Unit
CIRCUIT COURT
Expenditures
9090101 196030 730800
3010301 121200 788001 27165
PROSECUTOR'S OFFICE
Expenditures
4010401 122050 702010
4010101 122050 730373
Expenditures
4010101 122050
9090101 196030
SHERIFF'S
OFFICE
Revenue
4030901
116240
4030901
110090
4030701
116230
4030301
112620
9010101
196030
FY 2021 FY 2022 FY 2023
AMENDMENTS AMENDMENTS AMENDMENTS
Account Name
Grant Match $ 14,000.00
Transfer Out (14,000.00)
Total Expenditures $ 14,000 00
Salaries $ (5,500.00)
Contracted Services 5,500.00
Total Expenditures $ -
731458
Professional Services
$
150,000 00
740084
Juvenile Resentencing
(150,000.00)
Total Expenditures
$
695500
21340
Transfers In - Law Enforcement Enhance Lab Fees
121,635.00
695500
21341
Transfers In - Law Enforcement Enhance State
6,831.00
695500
21396
Transfers In - Sheriff Dispatch Training
26,085.00
695500
21397
Transfers In - Sheriff Booking Fee Training
25,259.00
665882
Planned Use of Balance
(6,831 00)
Total Revenue
$
172,97900
61
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2021 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
JGF/GP OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL FUND (#10100)
Dept Program Acct Fund Aff. Op Unit
Expenditures
4030901 116240 750203
4030701 116230 731304
4030301 112620 731304
Revenue
4030501 110110 650301
Expenditures
4030501 110110 750070
Account Name
Forensic Lab Enhancement
Officers Training (Dispatch)
Officers Training (Corrections)
Total Expenditures
Donations
Total Expenditures
Deputy Supplies
Total Expenditures
BOARD OF COMMISSIONERS
PCBU GRANT 100000003287 Budget Referenece 2020 Activity: GLB Anlaysis: GLB
Revenue
9010101 133095 610313 Federal Operating Grants
Total Revenue
Expenditure
5010101 133095 731822
Expenditures
5010101 165015 774636
5010101 165015 731101
Special Protects
Total Expenditure
Info Tech Operations
Library Continuations
Total Expenditures
SCHEDULE A
FY 2021 FY 2022 FY 2023
AMENDMENTS AMENDMENTS AMENDMENTS
121,635.00
26,085 00
25,259.00
$ 172,979.00
$ 150.00
$ 15000
$ 150.00
$ 150.00
$ (300,000.00)
$ (300,000.00)
$ (300,000 00)
$ (300,000 00)
$ 16,918 00
(16,918.00)
2
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2021 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
FY 2021 FY 2022 FY 2023
AMENDMENTS AMENDMENTS AMENDMENTS
JGF/GP OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL FUND W101001
Dept Program Acct Fund Aff. Op Unit Account Name
HEALTH DIVISION
Revenue
1060240 133390 631869 Reimbursement $ (44,000.00)
9010101 196030 665882 Planned Used of Balance 44,000.00
Total Revenue $ -
ECONOMIC DEVELOPMENT
Revenue
9010101
196030
665882
Planned Used of Balance
$
1,000,000.00
Total Revenue
$
1,000,000.00
1090201
171000
731458
Professional Services
$
1,000,000 00
Total Expenditure
$
1,000,000.00
NON -DEPARTMENT
Revenue
9010101
196030
665882
Planned Use of Balance
$
52,627 00
Total Revenue
$
52,627.00
Expenditure
9010101
153010
740135
Road Commission Tri-Party
$
52,627.00
Total Expenditure
$
52,627.00
7
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2021 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
PROPRIETARY/ SPECIAL REVENUE FUNDS -SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aff Oper Unit Account Name
CIRCUIT COURT - DRUG COURT ADULT SCAO (#27130)
PCBU: GRANT GR0000o001018 Activity GLB, Analysis Type GLB, Budget Ref 2021
Revenue
3010301 121200 695500 10100 Transfers In
Total Revenue
Expenditure
3010301 121200 731458 Professional Services
Total Expenditures
Sheriff - LAW ENFORCEMENT ENHANCE LAB FEES (#21340)
Revenue
4030901 116240 665882 Planned Use of Balance
Total Revenue
Expenditures
4030901 116240 788001 10100
Sheriff - LAW ENFORCEMENT ENHANCE STATE (#213411
Revenue
4030901 110090 665882
Expenditures
4030901 110090 788001 10100
Transfers Out- General Fund
Total Expenditures
Planned Use of Balance
Total Revenue
Transfers Out- General Fund
Total Expenditures
FY 2021
AMENDMENTS
$ (14,000.00)
$ (14,000.00)
$ (14,000.00)
$ (14,000.00)
$ 121,635.00
$ 121,635.00
$ 121,635.00
$ 121,63500
$ 6,831.00
$ 6,831.00
$ 6,831.00
$ 6,831.00
SCHEDULE B
FY 2022 FY 2023
AMENDMENTS AMENDMENTS
11
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2021 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY I SPECIAL REVENUE FUNDS
FY 2021 FY 2022
AMENDMENTS AMENDMENTS
(PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aff Oper Unit Account Name
Sheriff - SHERIFF DISPATCH TRAINING (#213961
Revenue
4030701 112630 665882 Planned Use of Balance $ 26,085.00
Total Revenue $ 26,085.00
Expenditures
4030701 112630 788001 10100 Transfers Out- General Fund $ 26,085.00
Total Expenditures $ 26,085.00
Sheriff - SHERIFF BOOKING FEE TRAINING (#213971
Revenue
4030301 112620 665882 Planned Use of Balance $ 25,259 00
Total Revenue $ 25,259.00
Expenditures
4030301
112620
788001 10100
Transfers Out- General Fund
$
25,259
00
Total Expenditures
$
25,259
00
Sheriffs
Office 2021 ATPA
Grant Fund (#27310)
Grant # GR0000000974
Activity: GLB Analysis. GLB
Budget Reference 2021
Revenue
4030901
116270
615571
Federal Operating Grants
$
1,229,058.00
4030901
116270
695500 10100
Transfers In
461,791.00
Total Revenues
$
1,690,849.00
Expenditures
4030901
116270
702010
Salaries
$ 558,500
00
4030901
116270
712020
Overtime
107,136.00
4030901
116270
722750
Workers Compensation
14,279.00
4030901
116270
722760
Group Life
1,14000
4030901
116270
722770
Retirement
144,538.00
FY 2023
AMENDMENTS
P]
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2021 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
FY 2021
AMENDMENTS
IPROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
SCHEDULE B
Dept ID
Program
Acct
Fund Aff Oper Unit Account Name
4030901
116270
722780
Hospitalization
119,10400
4030901
116270
722790
Social Security
40,506.00
4030901
116270
722800
Dental
9,753.00
4030901
116270
722810
Disability
87286.00
4030901
116270
722820
Unemploymentlnsurane
87600
4030901
116270
722850
Optical
90800
4030901
116270
722900
Fringe Benefit Adjustments
16,876.00
4030901
116270
730324
Communications
1,500.00
4030901
116270
730373
Contracted Services
536,371.00
4030901
116270
731213
Membership Dues
790.00
4030901
116270
731304
Officers Training
26,000.00
4030901
116270
750070
Deputy Supplies
7,200.00
4030901
116270
750154
Expendable Equipment
4,286.00
4030901
116270
750399
Office Supplies
4,800.00
4030901
116270
776661
Motor Pool
82,000.00
4030901
116270
778675
Telephone Communications
6,00000
Total Expenditures
$ 1,690,849.00
Sheriffs Office 2020 ATPA Grant Fund (#27310)
Grant # GR0000000377 Activity: GLB Analysis: GLB Budget Reference 2020
Revenue
4030901 116270 615571 Federal Operating Grants $ (1,229,058.00)
4030901 116270 695500 10100 Transfers In (461,791.00)
Total Revenues $ (1,690,849.00)
Expenditures
4030901
116270
702010
Salaries
$ (558,500,00)
4030901
116270
712020
Overtime
(107,136.00)
4030901
116270
722750
Workers Compensation
(14,279.00)
4030901
116270
722760
Group Life
(1.140.00)
4030901
116270
722770
Retirement
(144,538.00)
FY 2022 FY 2023
AMENDMENTS AMENDMENTS
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2021 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
FY 2021
AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
SCHEDULE B
Dept ID
Program
Acct
Fund Aff Oper Unit Account Name
4030901
116270
722780
Hospitalization
(119,104.00)
4030901
116270
722790
Social Security
(40,506.00)
4030901
116270
722800
Dental
(9,753.00)
4030901
116270
722810
Disability
(8,286.00)
4030901
116270
722820
Unemploymentlnsurane
(876.00)
4030901
116270
722850
Optical
(908.00)
4030901
116270
722900
Fringe Benefit Adjustments
(16,876.00)
4030901
116270
730324
Communications
(1,500.00)
4030901
116270
730373
Contracted Services
(536,371.00)
4030901
116270
731213
Membership Dues
(790 00)
4030901
116270
731304
Officers Training
(26,000 00)
4030901
116270
750070
Deputy Supplies
(7,200.00)
4030901
116270
750154
Expendable Equipment
(4,286.00)
4030901
116270
750399
Office Supplies
(4,800.00)
4030901
116270
776661
Motor Pool
(82,000.00)
4030901
116270
778675
Telephone Communications
(6,000.00)
Total Expenditures
$ (1,690,84.9.00)
HIV PREP (#28629)
PCBU: GRANT GR0000001007 Budget Referenece 2021 Activity: GLB Anlaysis: GLB
Expenditures
1060294 133990 750294 Materials and Supplies $ (5,550.00) $
1060294 133990 750245 Incentives 5,550.00
Total Expenditures $ - $
COVID-19 FUND (#286301
PCBU: GRANT GR0000001049 Budget Referenece 2021 Activity: GLB Anlaysis: GLB
Expenditures
1060201 133095 702010 Salaries Regular $ 1,680,230.00
1060201 133095 722740 Fringe Benefits 746,119.00
1060201 133095 730072 Advertising (250,000 00)
FY 2022 FY 2023
AMENDMENTS AMENDMENTS
(5,550.00) $
5,550.00
(5,550 00)
5,550.00
W
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2021 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
FY 2021
AMENDMENTS
IPROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID
Program
Acct Fund Aff Older Unit
Account Name
1060201
133095
730373
Contracted Services
(50,000.00)
1060201
133095
730926
Indirect Costs
166,511.00
1060201
133095
731458
Professional Services
(1,700,000.00)
1060201
133095
750294
Material and Supplies
(515,740.00)
1060201
133095
774636
IT Operations
(77,120.00)
Total Expenditures
$
-
COMMUNITY DEVELOPMENT
BLOCK GRANT (#29701)
PCBU COMHI
GR0000000925 Budget Referenece 2019 Activity: GLB Anlaysis: GLB
Revenue
1060703
133095
610313
Federal Operating Grants
$
3,166,997.00
Total Revenue
$
3,166,997.00
Expenditure
1060703
133095
730373
Contracted Services
$
3,166,997 00
Total Expenditure
$
3,166,99700
COMMUNITY DEVELOPMENT
BLOCK GRANT (#29701)
PCBU COMHI
GR0000000925 Budget Referenece 2020 Activity: GLB Anlaysis: GLB
Revenue
1060703
133095
610313
Federal Operating Grants
$
(3,166,997.00)
Total Revenue
$
(3,166,997.00)
Expenditure
1060703
133095
730373
Contracted Services
$
(3,166,997 00)
Total Expenditure
$
(3,166,997.00)
EMERGENCY SOLUTIONS GRANT (#29705)
PCBU COMM GR0000000926 Budget Referenece 2019 Activity: GLB Anlaysis: GLB
SCHEDULE B
FY 2022 FY 2023
AMENDMENTS AMENDMENTS
12
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2021 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
FY 2021
AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aff Oper Unit Account Name
Revenue
1060703 133095 610313 Federal Operating Grants $ 1,155,293.00
Total Revenue $ 1,155,29300
Expenditures
1060703 133095 702010 Salaries $ 15,000.00
1060703 133095 722740 Fringe Benefits 10,000.00
1060703 133095 730373 Contracted Services 1,130,293 00
Total Expenditures $ 1,155,29300
EMERGENCY SOLUTIONS GRANT (#29705)
PCBU COMHI GR0000000926 Budget Referenece 2020 Activity GLB Anlaysis GLB
Revenue
1060703 133095 610313 Federal Operating Grants $ (1,155,293 00)
Total Revenue $ (1,155,293.00)
Expenditures
1060703 133095 702010 Salaries $ (15,000 00)
1060703 133095 722740 Fringe Benefits (10,000 00)
1060703 133095 730373 Contracted Services (1,130,293.00)
Total Expenditures $ (1,155,293.00)
EMERGENCY SOLUTIONS GRANT (#297051i
PCBU COMHI GROOOOOD0926 Budget Referenece 2020 Activity GLB Anlaysis: GLB
Revenue
1060703 133095 610313 Federal Operating Grants $ (2,033,828.00)
Total Revenue $ (2,033,828.00)
SCHEDULE B
FY 2022 FY 2023
AMENDMENTS AMENDMENTS
13
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2021 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
FY 2021
AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aff Oper Unit Account Name
Expenditures
SCHEDULE B
1060703
133095
702010
Salaries
$
(45,000.00)
1060703
133095
722740
Fringe Benefits
(30,000.00)
1060703
133095
730373
Contracted Services
(1,958,823
00)
Total Expenditures
$
(2,033,828
00)
EMERGENCY SOLUTIONS
GRANT (#29706)
PCBU COMHI
GR0000000926 Budget Referenece 2019
Activity GLB Anlaysis: GLB
Revenue
1060703
133095
610313
Federal Operating Grants
$
2,033,828
00
Total Revenue
$
2,033,828.00
Expenditures
1060703
133095
702010
Salaries
$
45,000.00
1060703
133095
722740
Fringe Benefits
30,000.00
1060703
133095
730373
Contracted Services
1,958,828.00
Total Expenditures
$
2,033,828
00
MIDC FUND
#20260
Expenditures
3010301
121170
730450
Defense Attorney Fees
$
(13,500.00)
3010301
121170
731941
Training
13,500.00
Total Expenditures
$
-
MIDC FUND
#20260
Expenditures
3010301
121170
730450
Defense Attorney Fees
$
(122,699.00)
3010301
121170
702010
Salaries
73,351.00
3010301
121170
722900
Fringe Benefit Adjustments
33,054.00
3010301
121170
750154
Expendable Equipment
14,490.00
FY 2022 FY 2023
AMENDMENTS AMENDMENTS
kv
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2021 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY I SPECIAL REVENUE FUNDS
FY 2021
AMENDMENTS
PROPRIETARY/ SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID
Program
Acct
Fund Aff Oper Unit Account Name
3010301
121170
774637
Info Tech Managed Print Services 5000
3010301
121170
774636
Info Tech Operations 1,586.00
3010301
121170
778675
Telephone Communications 168.00
Total Expenditures $ -
MIDC FUND #20260
Expenditures
3010301
121170
730450
Defense Attorney Fees
$
(720.00)
3010301
121170
778675
Telephone Communications
720.00
Total Expenditures
$
-
COMMUNITY
CORRECTIONS COMPREHENSIVE
GRANT (#27370)
PCBU: GRANT
GR0000000986 Activity: GLB Analysis Type GLB Budget Reference: 2021
Expenditures
4030301
112620
731885
Support Services
$
(20,000,00)
1070401
113035
730373
Contracted Services
20,000.00
Total Expenditures
$
-
VETERAN SERVICE FUND (#29252)
PCBU: GRANT GR0000001024
Budget Referenece
2021 Activity. GLB Anlaysis: GLB
Expenditure
1090702
132050
730072
Advertising
$
6,000.00
1090702
132050
730571
Emergency Services
90,000
00
1090702
132050
731941
Training
4,00000
1090702
132050
732011
Transportation
(75,000.00)
1090702
132050
732633
Rental Property Maintenance
(25,000.00)
Total Expenditure
$
-
FY 2022 FY 2023
AMENDMENTS AMENDMENTS
15
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2021 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
FY 2021
FY 2022 FY 2023
AMENDMENTS
AMENDMENTS AMENDMENTS
PROPRIETARY / SPECIAL
REVENUE FUNDS
- SELF BALANCING AMENDMENTS
Dept ID
Program
Acct Fund Aff Oper Unit Account Name
FRINGE BENEFITS
FUND
(#67800)
Expenses
1050521
183192
712020
Overtime
$
(29,708.00)
$ (29,708 00) $ (29,708 00)
1050521
183192
722750
Workers Compensation
29,708.00
29,708.00 29,708.00
Total Expenses
$
-
$ - $ -
PARKS AND
RECREATION FUND (#50800)
Revenues
5060101
160000
690189
Capital Asset Contribution
$
14,675.00
5060101
160000
690189
Capital Asset Contribution
32,000.00
5060101
160000
601208
Delinquent Tax Prior Years
265,250.00
5060101
160000
601637
Property Tax Levy
(265,250.00)
5060101
160000
655077
Accrued Interest Adjustments
(20,000
00)
5060101
160000
655385
Income from Investments
(62,000.00)
Total Revenue
$
(35,325.00)
Expenses
5060715
160070
730044
Adj Prior Years Revenue
$
4,671.00
5060417
160044
730198
Building Maintenance
2,296.00
5060715
160070
730814
Grounds Maintenance
3,200.00
5060720
160070
730814
Grounds Maintenance
5,757.00
5060725
106070
730814
Grounds Maintenance
2,795.00
5060456
160044
730198
Building Maintenance
423.00
5060831
160210
730814
Grounds Maintenance
3.50000
5060732
160070
730198
Building Maintenance
32,566
00
5060330
160010
730814
Grounds Maintenance
1,400.00
5060540
160500
730814
Grounds Maintenance
3,200.00
5060735
160070
730373
Contracted Services
10.050.00
5060735
160070
730814
Grounds Maintenance
2,500.00
iE
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2021 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
PROPRIETARY / SPECIAL
REVENUE
FUNDS - SELF BALANCING AMENDMENTS
Dept ID
Program
Acct
Fund Aff Oper Unit Account Name
5060837
160210
730814
Grounds Maintenance
5060910
160430
730789
General Program Administration
5060715
160070
730814
Grounds Maintenance
5060720
160070
730814
Grounds Maintenance
5060765
160070
730814
Grounds Maintenance
5060725
160070
730814
Grounds Maintenance
5060755
160070
730814
Grounds Maintenance
5060910
160431
730653
Rental Equipment
5060910
160431
731241
Miscellaneous
5060910
160431
750511
Special Events
5060724
160070
730814
Grounds Maintenance
5060751
160070
730814
Grounds Maintenance
5060760
160070
730814
Grounds Maintenance
5060732
160070
730814
Grounds Maintenance
5060330
160010
730814
Grounds Maintenance
5060326
160010
730814
Grounds Maintenance
5060910
160431
730789
General Program Administration
5060911
160431
730789
General Program Administration
5060326
160430
730814
Grounds Maintenance
5060910
160430
730789
General Program Administration
5060720
160070
730814
Grounds Maintenance
5060356
160010
750154
Expendable Equipmet
5060910
160430
730789
General Program Administration
5060910
160430
730789
General Program Administration
5060910
160431
730789
General Program Administration
5060101
160000
796500
Budgeted Equity Adjustments
Total Expenses
FY 2021
AMENDMENTS
3,100.00
(70,787.00)
48,3%00
25,722.00
14,490 00
7,178.00
24,359.00
340.00
125.00
274.00
14,332 00
3,704.00
27,753.00
2,081.00
3,150.00
2,91700
(174,735.00)
70, 000.00
17,928.00
(20,000.00)
(2,000.00)
(1,323 00)
(43,758 00)
(17,928.00)
39, 896.00
(82,811.00)
(35,325.00)
SCHEDULE B
FY 2022 FY 2023
AMENDMENTS AMENDMENTS
m
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2021
BUDGET
AMOUNT
ADOPTED
AS
FY 2021
FAVORABLE/
BUDGET
AMENDED
FORECAST
(UNFAVORABLE)
PERCENT
REVENUES
GENERALFUND
Taxes
$
261,108,72900
$
251.108,72900
$
256,008,72900
$
4,900,00000
1.95%
Federal Grants
2,249,55000
130,643,43600
130,588,43600
(55,00000)
-004%
State Grants
20,836,99100
21,306,34400
19,305,34400
(2,000,00000)
-939%
Other Intergovernmental Revenue
45,977,607.00
46,027,60700
45,991,15700
(36,45000)
-008%
Charges for Services
120,392,67700
121,654,20200
113,664,32100
(7,989,88100)
-657%
Indirect Cost Recovery
9,100,000 Go
9,100,000.00
9,100,00000
-
000%
Investment Income
1,500,000 Go
1,500,00000
1,542.07500
42,07500
281%
Other Revenues
5,734,00000
6,032,60200
6,205,88781
173,28581
287%
SUB -TOTAL GENERAL FUNDIGENERAL PURPOSE
$
456,899,554.00
$
587.372,92000
$
582,406,94981
$
(4,965,97019)
-085%
PLANNED USE OF FUND BALANCE
$
609,33800
$
44,665,16621
$
44,665,16621
$
-
000%
TOTAL GFIGP FUNDS
$
457,508,892.00
$
632,038,086.21
$
627,072,116.02
$
(4,965,970.19)
-0.79%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
$
50,72B,37600
$
51,935,13044
45,097.63044
$
6,837,50000
1317%
52nd District Court
17,813,04500
17,952,07487
17,226,07487
726,00000
404%
Probate Court
7,027,76500
7,062,02000
6,610,52000
441,50000
6.26%
TOTAL ADMIN. OF JUSTICE
$
75,569,186.00
$
76,939,225.31
$
68,934,225.31
$
8,006,000.00
10.40%
LAW ENFORCEMENT
Prosecuting Attorney
21,782.30100
21,869,96300
21,475,96300
394,00000
I80%
Sheriff
166,768,499 00
169,116,50386
168,703,42486
413,07900
024%
TOTAL LAW ENFORCEMENT
$
188,560,800.00
$
190,986,466.86
$
190,179,387.86
$
807,079.00
0.42%
GENERAL GOVERNMENT
Clerk/Register of Deeds
10,401,27300
11,520,19100
10,563,19100
957,00000
831%
Treasurer
8,236.13900
8,419,17500
6,849,17500
1,570,00000
1865%
Board of Commissioners
4,729,24400
7,982,55060
7,850,15060
132,40000
166%
Water Resources Commissioner
7,798,886.00
7,933,51700
7,957,017.00
(23,500.00)
-030%
TOTAL GENERAL GOVERNMENT
$
31,225,542.00
$
35,855,433.60
$
33,219,533.60
$
2,635,900.00
7.35%
COUNTY EXECUTIVE
County Executive Admn
$
7,099,68400
$
9,914.80367
$
9.749,00367
$
165,800.00
167%
Management and Budget
22,891,222.00
23,270,615A3
22,046,616A3
1.224.000.00
5 26%
Central Services
2,576,32T00
2,585,09800
2,576,998.00
8,10000
031%
Facilities Management
1,499,208.00
1,841,40570
1,754,905.70
86,50000
470%
Human Resources
4,795,06200
6,369,34500
4,786,34500
583,00000
1086%
Health and Human Services
45,356,951 00
49,986,86325
48,515,66325
1,471,20000
294%
Public Services
40,326,56200
41,198,76294
39,683,76284
1,515,000.00
368%
Economic Dev and Comm Affairs
10.567,792 00
27,724,838.65
27.378,038 65
346.800.00
1.25%
Emergency Management & Homeland Security
-
1,818,711.00
1,818,711.00
-
0.00%
TOTAL COUNTY EXECUTIVE
$
135,112,798.00
$
163,710,443.44
$
158,310,043.44
$
5,400,400.00
3.30%
TOTAL DEPARTMENTS
$
430,458,32600
$
467,491,56921
$
450,643,19021
$
16,848,379.00
360%
NON -DEPARTMENTAL APPROPRIATIONS
TOTAL NON -DEPARTMENTAL
$
27,050,566.00
$
164,546,517.00
$
148,474,778.00
$
16,071,73900
9.77%
TOTAL GOVERNMENTAL EXPENDITURES
$
457,508,892.00
$
632,038,086.21
$
599,117,968.21
$
32,920,118.00
5.21%
General Fund/General Purpose
Favorable/(Unfavorable)- Budget Perspective
$
-
$
$
27,954,147.81
$
27,954,147.81
GAAP Required Adjustment (eliminating use of fund balance "revenue")
GAAP - BASED REPORT (Impact on Fund Balance includes Encumbrances)
$ (44,665,16621)
($16,711,018.40)
18
TAXES (601000-6019991
Property Taxes - July Tax Levy
Cther Texas- Delinquent Tax - Prior Years
Treasurer Payment in Lieu of Taxes
Char Taxes - Trader Tax
Total Taxes
FEDERAL GRANTS (610000-610999)
Sheriff- Sheriffs Office
Sheriff - Patrol
Sheriff - Corrective Services
Sheriff- Investlgative/Forensic Services
Prosecuting Attorney
Homeland Security - Disaster Control
Emeqency Management and Homeland Security
Health Division
Children's Village
Non -Departmental
Total Federal Grants
STATE GRANTS (615000-615999)
Sheriff- Patrol
State Match Foster Care
Prosecuting Attorney
Economic Development
Health Division
Water Resources Commissioner
Economic Development- Veteran's Services
Non -Departmental- Child Care Subsidy
ADOPTED
BUDGET
$ 250,498,729.00 $
Total State Grants $
OTHER INTER -GOVERNMENTAL REVENUES (620000 - 626999)
Non -Departmental $
HHS - Homeland Security
Emergency Management- Homeland Security
125,000 00
400,000.00
85 000 00
251,108,72900 $
205,000 00
70,718 00
654,727 00
300,000 00
1,019,105 00
2,249,550.00 $
1,00000
6,233,963 00
14,602,028 00
20,836,991.00 $
43,681, 57300 $
9,00000
COUNTY OF OAKLAND
GENERAL FUND GENERAL PURPOSE REVENUES
FY 2021 SECOND QUARTER REPORT
AMOUNT
AMENDED
FY 2021
FAVORABLE
BUDGET
FORECAST
(UNFAVORABLE)
PERCENT FXPLANATION OF SIGNIFICANT VARIANCES
250,498,72900
$ 255,398,72900 $
4,900,00000
196% Property Tax favorable due to the overall 2021 taxable
value increase of 3.84% when comparing to the FY 2021
budget that estimated a 1 80 % taxable value increase due
to the unknown pandemic impact at the time. MR# 21163
adopted April 29, 2021 amended the budget and the
updated budget wil be reflected in the third quarter report
125,00000
125,000.00
-
0.00%
400,000 00
400,000 00
-
000%
85 000 00
85,000 00
-
0 00 %
251,108,729.00
$ 256,008,729.00 $
4,900,000.00
1.95%
-
$ - $
-
Cron%
357,293 00
357 293 00
-
0 00 %
_
-
000%
5,00000
5,00000
-
0 00 %
206,000 00
205,000 00
-
0 00 %
_
-
000%
70,718.00
70,71800
-
000%
649,49300
649,493.00
-
0.00%
300,000 00
245,000 00
(56,000 00)
-18.33% Unfay. School Lunch program serving less due to decline
in population of residents
129,055,93200
129,055,93200
-
000%
130,643,436.00
$ 130,588,436.00 $
(55,000.00)
-0.04%
_
$ - $
000%
1,00000
1,00000
-
000%
000%
000%
5,561,588.00
6,561,58800
-
Cron%
000%
000%
14,743,75600
12,743,756.00
(2,000,00000)
-1357% Unfav due to less than anticipated reimbursement from
the State on eligible child care costs offset by Child Care
Fund expenditure favorability
21,306,34400
$ 19,306,344.00 $
(2,000,000.00)
-939%
43,731,573 00
$ 43,681,573 00 $
(50,000 00)
-011% Unfav primarily due to States updated Revenue Sharing
projection
_
-
000%
9,00000
9,00000
-
000%
19
COUNTY OF OAKLAND
GENERAL FUND GENERAL PURPOSE REVENUES
12021 SECOND QUARTER REPORT
AMOUNT
ADOPTED
AMENDED
FY 2021
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE)
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Circuit Court
4,50000
4,50000
4,50000
-
000%
District Court
1,80000
180000
1,800.00
-
000%
Shenff
286,550 00
286,550 00
300 100.00
13,550 00
4 73% Fav Marine Safety $83,550 due to timing of FY 2020 grant
payment; partially offset by untav Social Seventy Incentme
Payments ($70,000) as a result of a reduction in the
number of inmates In response to COVID-19 pandemic
Funds are collected from )ail inmates receiving SSI for cost
of incarceration
Non -Departmental- Reimb Judges Salaries
1,994,18400
1,994,18400
1994,18400
-
000%
Total Other Intergovernmental Revenue
$ 45,977,607.00 $
46,027,607.00 $
45,991,157.00 $
(36,450.00)
-0.08%
CHARGES FOR SERVICES (630000-6359991
Administration of Justice
Circuit Court-Judicial/Administration
$ - $
- $
- $
-
000%
Circuit Court- CrvNCriminal
2,406,000 00
2,414,000 00
2,079,000 00
(335,000 00)
-13 88% Unfay. Court Costs ($350,000) due to changes in
legislation Unfav Mediation Fines S105 000) due to loner
than anticipated revenue Unfav Jury Fees ($80 000) due
to timing of payment from State. Partially offset by fat.
Refund Fees PC Def Attom ey $200, 000 due to an
increase in activity and fees The overarching cause of the
variances identified above is also due to the COVID-19
pandemic
Circuit Court- Family Division
1,771,500 00
1,771,500 00
1,596,500 00
(175,000 00)
-9 88% Unfav Gov! Benefit Board and Care ($100,000) along win
Board and Care (350,000) due to a decrease in
reimbursement. Unfav Court Service Fees Probation
($25,000) due to a reduction in probation caseload
District Court -Division I(Novi)
4214,753.00
4,214,753.00
3,089,75300
(1,125 000 00)
-2669% Unfav Ordinance Fines and Cost.(3875,000); State Law
Costs ($125,000), and Probation Fees ($125,000), partially
due to the reduction in caseload from manjuana
legalization The overarching cause of the variances is
also due to COVID-19 pandemic
District Court- Division ll (Clarkston)
1,912,66300
1,912,66300
159766300
(315,00000)
-1647% Unfav Ordinance Fines and Costs($250,000), Probation
Fees ($25,000), as well as Assessments and PSI
($20,000) partially due to the reduction in caseload from
marijuana legalization and partially due to the pandemic
Unfav Forfeiture of Bonds ($20, 000) due to an decreased
number cf defendants failing to appear before the court
The overarching cause of the variances is also due to
COVID-19 pandemic
1J
D � Cou^ _ DNts�on w� Vg neate° N'\sl
roYl
sion 0 C(
D smd Goud ONt
yenta\ Neana
f$taias and
Ptobote Good.
°( JU50�
'Sotal Adm`n sbanon
001
pdn, orRioI
geN
goo
�d¢cbve 5eN`G¢s
gnena-
OF 0AW0,i - t'Oss1 NOES
OOf040VGENER?}ART REPOR
OENEMY 202 SECOND Q
NA04so
p1500
?ISO
,li'voOq 0i500
ljg
2 5g0 \m
FY 2021
fOREO 18 p15 p9
28
P ofx" I, c
VAA R�9p�001
t13
V PR\AN IS as
,OON F d Goss l�dnan9e ,n a9Y
EXP ice F;nes and Paf„s0Y doeeto and Pa
p2°/ P�itwn Fe�,atu�te (ma p tntc d \n du¢
�e�Ne GOVtD-19 Pan dGoss l$6'��e9a Ptp on
11 0,50�001
3e5 593 03
�5�e01
g86.600 00
591g0 VD
o g00 00
1:
2t 00 $
1i ?°j'
100 $
1148512 gi6.'yg900
218 �0000 $
200000
2,900"00 "R3 5W.Vo
n00 00
383,-
3 er, ve 0
296\ OG000
4405`k Ua po
ia Y'°�°DY gtatpm
Feesof "FD D� m
PaindeR('c �\ due tom®Y \520 0001
Eav Gro aRe(u es cD acts ty ase ndod
s n e
.1335"+c too, 90 gad de as; due t°$pG00 oue¢oa antes4
due $150� mstas use of en
Goset )tay.o °cat�','P99 �V\D-19 Pa
e G
�V,tY '(asp tlU¢ 10 m
above'a
scuo
efj
so'a Wnfa$3R8 mad on R�NO.9
t40�001°r°fa'� Ro6elt�e'PayOa"NGtH as a.esd°fG
012� Ou $ 000'� 2 \l$20. � 0001 d e t0 ess adandpned �C\a
11 Fea len,c. Odoe\o of M,cn,9
033459 p0 $ 2g2159`y�Fp oo re`tc'W` ��gO 1dsiue to 2d°�baysY
0 F,09 `ntsws 2iso$2Gen',F, Pad`a`oo do16
0
6^<.0 .g539«'Ug 2•��`t oa p0`p 2ndPfee �ncod`e $4 e
g690000 OOO �Y aso\ e't01 vl 0iy0. reduction mtb
5.
i 8 FnGtOa;ed act $9500001 dpocsemanta
00 .
198 `�0� sv Orvses iPatmS� 5Ad0 �R„c.Oeni OS to
-0399Y° p� �d's�yysa ada° naoaM'\an9ua9e o'o1 d9m Pay.
1 A00000 ppmn,�ss $55 pp01 Cl bpniract tp 1�,ate^ab\Ut3 to
l Gttense t s 1pnDO 0031 due mates aC,on of
82?3'-0 Gonecia°nd Gate l$O�p�eorn ^d.i�ansp6 rnbei ofe ,ng}oc
\,1 SData zrgasl SeN,ca cionmM ems°`s to
Gbn\c Gb 5ur c\,opt ,ibe \edu 19 Pand
,,Mt`-'5¢ l$1 � to G00�4
Fnsates m resPa"5e
1
pon0ibuun9ta tot
n
Sheriff - Conschve Services Satellites
Sheriff- Emergency Response and Prep
Sheriff - Patrol Services
Sheriff- Emergency Communications Operations
Shenff- Investigative Forensic Services
Total Law Enforcement
General Government
Clerk- County Clerk
Clerk - Elections
Clerk - Register of Deeds & Micrographics
Treasurer
COUNTY OF OAKLAND
GENERAL FUND GENERAL PURPOSE REVENUES
FY 2021 SECOND QUARTER REPORT
ADOPTED AMENDED FY 2021
BUDGET BUDGET FORECAST
584,85500 586,09800 386,09800
322,501 300,000 00 120,000 00
57,826,89100 57,952,48400 57,137,484.00
2,318,40800 2,530,81900 2530,819.00
1,215,00000 1253,36000 373,36000
$ 65,873, 05400 3 66,987,88600 $ 63,446,88600 $
$ 2,179,10000 $
93,700 00
11,492,50000
4,646 600 00
2,179,100 00 $
93,700.00
11,492, 500.00
4,646 600 00
2,449,100 00 $
93,700 00
13,342,500 00
4,046,600 00
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION nF SIGNIFICANT VARIANCES
(200,000 00) -34 12% Unfav Reimb Court Services ($150 000) for court seventy
to non 52nd Disinct Courts which are realizing lower court
activity due to COVI D-19 pandemic. Forecast reflects
anticipated court reopening in second half of fiscal year,
partially offset by favorable personnel costs relating to part-
time non -eligible court seventy, personnel and vacant
positions. Also unfav Board and Care ($50,000) due less
than anticipated referrals from judges to the tether
program
(180,000 00) -60 00% Unfav Civil Action Service Fees ($200,000) due to a
reduction in services due to the COVID-19 pandemic
partially offset by reduced operating expenditures and Pav
Reimbursement General $19,000 due to unbudgeted
training fees
(815,00000) -141%Unfav_ primarily due to Reimbursement Salaries
($800,000) from uncertainty of events at venues such as
DTE Energy Music Theatre and Meadow6rook
Amphitheatre as a result of GOVID-19 pandemic This wIl
be offset by less overtime for cancelled events. Also
unbar. Impound Fees ($15,000) due to lower activity
000%
(880,000 00) -70.21 % Unfay. primarily due to Drug Testing ($900,000) as the
Results testing program was shut doom due to COVID-19
pandemic It has reopened and is experiencing a lower
number of clients Partially offset by favorable operating
expenditures
(3,541000.00) -529%
270,000 00 1239% Fav Carl Copies $110,000, Photostats $100,000, Jury
Fees 540O00 and Forfeiture of Bonds $20,000 due to
increased activity.
- 000%
1850,00000 1610%Fav Land Transfer Tax$1,000,000, Recording Fees
$500,000 and Mortgages $350,000 due to increased
activity
(600,00000) -1291%Unfav Payments other than Anticipated ($1,000,000)due
to no land sale activity taking place due COVID-19
pandemic Partially offset by favorable Administration Fees
$250,000 and Title Search Fees $150,000 due to
increased activity
22
Board of Commissioners
Water Resources Commissioner
Total General Government
County Executive
County Exec- Corp Counsel
County Exec - Admit
M&B - Equalization Division
M&B - Fiscal Services Division
M&B - Purchasing Division
Central Services - Support Services
Human Resources
HHS - Administration
HHS - Health Division
HHS - MSU Extension
Public Services - Community Corrections
ADOPTED
BUDGET
14,200 00
3,346,261 00
COUNTY OF OAKLAND
GENERAL FUND I GENERAL PURPOSE REVENUES
FY 2021 SECOND QUARTER REPORT
AMENDED
BUDGET
14,20000
3,396,208 00
$ 21,772,361M $ 21,822,30800 3
AMOUNT
FY 2021 FAVORABLE
FORECAST (UNFAVORABLE)
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
6,20000 (8 000 00)
-56 34% Unfav_ Fee Income ($3,000) due to less than anticipated
royaldies due to temporary problems vnth vendor webslte
Miscellaneous Revenue (33,000) due to lower book sales
revenue and lower computer printout revenue due to public
computers not being available during COVID-19 pandemic
Also, unfavorable Copier Machine Charges ($2,000) due to
increased fundionahtles of downloading and e-mailing
documents and downsizing of the Legal Resources Center
3,421,327 00 25 119 00
Fav Refund Prior Years Expenditure $25,043 due to
Cares Ad money Water Resources Commission received
for labor costs regmnng an allocation to various systems
for reimbursement, money should have been received in
FY 2020
23,359,42700 S 1,537,119M
704%
3,348,985M
3,348,98500
3,348,98500
-
000%
505,60000
505,60000
465,60000
(40,00000)
-791%Unfav
Court Ordered Board and Care due to timing of
court activity_
265,690 00
265,690 00
265,690 00
-
000%
316,00000
316,00000
301,00000
(15,00000)
-475%Unfav
Commission Vending Machines due to limited staff
at County buildings due to the COVID-19 pandemic
-
-
000%
-
-
000%
4,720,51900
4,798,11500
3,85811500
(940,00000)
-1959%Unfav
Immunizations (3400,000), Inspection Fees
($200,000), Administration Fees ($100,000), Clinic
Charges ($100,000), Laboratory Charges 3rd Party
($100 000). and Hepatitis Vaccine ($40,000) due to
pandemic
-
-
000%
155,00000
155,00000
15,00000
(140,000M)
-9032%Unfav
Fee Income ($140,000) due to less than anticipated
referrals from fudges to the Weekend and Weekday
Aftemative for Misdemeanants(WWAM)Program In
addition, the program is suspended due to the COVID-19
pandemic
23
COUNTY OF OAKLAND
GENERAL FUND/ GENERAL PURPOSE REVENUES
FY 2021 SECOND QUARTER REPORT
AMOUNT
ADOPTED
AMENDED
FY 2021
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE)
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Public Services- Children's Village
3,164,09700
3,164,09700
3164,09700
-
000%
Public Services- Medical Examiner
325,10000
325,10000
325,10000
-
000%
Public Services -Animal Control
1,138,514C0
1,149,66400
856,66400
(293,00000)
-2549%Urfa, primarily due to the Sale of Licenses($293,000)
due to less than anticipated activity
Public Services- Circuit Court Probation
-
-
-
-
000%
Economic Dev 8 Comm Affairs - PECS
404,071 00
404, 071,00
246,071 00
(158,000 00)
-39 10% Unfay. Reimbursement General ($B0,000), Sale of Maps
($20,000), Registration Fees( $8,000) due to the COVID-
19 pandemic Unfav Semmars/Conferences ($50,000)
due to MiCareer Quest cancellation due to the COVID-19
pandemic
Total County Executive
$
14,3<1,57600
$ 14,432,32200
$ 12,846 322 00
$ 0,586,000.00)
-1099%
Non -Departmental
Non -Dept - Charges for Services
$
918 565 00
$ 918 565 00
918 565 00
- _
000%
Total Non -Departmental
$
918,56500
$ 918,56500
$ 918,56500
$ -
000%
Total Charges for Services
$
120,392,677.00
$ 121,654,202.00
$ 113,664,321.00
$ (7,989,881.00)
.6.57%
INDIRECT COST RECOVERY (640100)
$
9,100,000.00
$ 9,100,000.00
$ 9,100,000.00
$ -
0.00%
INVESTMENT INCOME f655000-6559991
District Courts(Div. I - IV)
2,20000
2,20000
2201
-
0.00%
Sheriff Correotrve Services
-
-
-
-
000%
Sheriff lnvestiga ive/1-echmcal Services
-
-
-
-
000%
Treasurer
150,00000
150,00000
150,00000
-
000%
Clerk/Registerof Deeds
2,50000
2,50000
44,57500
42,07500
168300%Fay Interest on Investments$42,075 due to investment
base and market rate FluOuahons_
Economic Development
-
-
-
-
0.00%
Non -Departmental
134530000
134530000
1 345. 300 00
-
000%
Total investment Income
$
1,600,000.00
$ 1,506,000.00
$ 1,542,075.00
$ 42,075.00
2.81%
OTHER REVENUES f670000-6955001
Circuit Court-Donatons
$
-
$ -
$ -
$ -
000%
Qroud Court
-
-
-
-
000%
Circuit Court -Transfers In
-
-
-
-
000%
District Courts (Div I - IV)
-
-
-
-
0.00%
Probate Court
-
-
-
-
0.00%
Prosecuting Attorney
-
-
-
-
000%
Sheriff Office
-
-
3,299.66
3,29966
100 00% Fay. Enhancement Funds due to unbudgeted cash
recovery from evidence
M
COUNTY OF OAKLAND
GENERAL FUND I GENERAL PURPOSE REVENUES
FY 2021 SECOND QUARTER REPORT
AMOUNT
ADOPTED
AMENDED
FY 2021
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLEI
PERCENT EXPLANATI ON OF SIG NIFICANT VARIANC ES
7015
7015
10000%Fav Refund Prior Years Expenditures for reimbursement
Sheriff- Ad minum alive Services
-
-
of a duplicate payment
Sheriff- Correchve Services
-
-
39.792.00
39,792.0D
100 00 %Fay. Prior Years Revenue $39,715 Leased Beds and
Alternatives (LEA) reimbursement of MDOC inmates due
to COVID-19 pantlemic and $77 Jail Alliance With Support
(JAWS) I Medication Assisted Treatment (MAT)
reimbursements for FY 2020
Sheriff- Corrective Services -Satellites
-
-
-
-
000%
Sheriff- Emergency Rasp and Prepare
-
-
-
-
ODO%
Sheriff - Patrol Services
12,00000
12,00000
12,000W
-
000%
Sheriff - Patrol Services - Donations
-
2,500.00
2,50000
-
000%
Sheriff- Emergency Communications Operations
-
-
-
-
0.00%
Shang- I nvestigarvelForensic Svc
3,00000
3,00000
11724W
8,72400
29030%Fav Refund Prior Years Expenditures$11,724 for
reimbursement of FY 2020 Sheriffs overtime for the
Organized Crime Drug Enforcement Task Force
(OCDETF), partially offset by unfav County Auction
($3,000) due to auction postponement
ClerWRegister of Deeds
-
-
-
-
000%
Treasurer
-
-
-
-
000%
Treasurer - Donations
-
-
000%
Board of Commissioners
-
-
-
-
000%
Board of Commissioners -Contributions
-
157,90700
157,90700
-
0.00%
Water Resources Commissioner
-
-
-
-
000%
County Exec -Compliance Office
-
-
-
-
000%
Management and Budget - Fiscal Services
-
-
-
-
000%
Central Services - Support Services
1,50000
1 501
1,50000
0.00 %
Human Resources
-
-
-
-
0.00%
Facilities Management Engineering
-
-
-
-
000%
Health Division - Donations
-
-
-
12140000
12140000
000%
10000%Fav Prior Years Revenue$121400 for correction of FY
Health Division
-
2020 estimated administration overhead cost distrbution
for Comprehensive Planning, Budgeting, and Contracting
(CPBC) grant
Health Division - Transfers In
-
-
-
-
000%
Children's Village
-
-
-
-
0.00%
Children's Village - Transfers In
-
2500
2500
-
000%
Homeland Security
-
-
-
-
000%
EMIG- Homeland Security
-
-
-
-
000%
Public Services -Medical Examiner
-
-
-
-
000%
Public Services- Animal ControkCmer Revenues
-
-
-
-
000%
25
COUNTY OF OAKLAND
GENERAL FUND I GENERAL PURPOSE REVENUES
FY 2021 SECOND QUARTER REPORT
AMOUNT
ADOPTED
AMENDED
FY 2021
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE)
PERCENT
Public Services - Animal Control -Transfers in
-
-
-
-
000%
Economic Development & Comm Affairs- Contributions
-
-
-
-
000%
Economic Development - Contributors
-
-
-
-
000%
Non Departmental - Donations
-
Non -Dept - Sundry
417 500 00
417 500 00
417,500 00
-
000%
Shenffs' Transfers In
-
24,785 00
24,785 00
-
000%
Treasurers'Transfers in
2,300,00000
2,300,00000
2,300,00000
-
000%
Non -Departmental - Transfers In
3000,00000
3,113,38500
3,113385.00
-
000%
Total Other Revenues
$ 5,734,000.00 $
6,032,602.00
6,206,88781 $
173,285.81
2.87%
PLANNED USE OF FUND BALANCE (665000-665999)
Encumbrances and Carry forvlards
-
14,651,86221
14,651,85221
- 000%
Use of Prior Yrs Fund Balance
$
60933800
S 3001331400
3001331400
- 000%
Total Planned Use of Fund Balance
$
609,338.00
$ 44,665,166.21 $
44,665,166.21 $
- 0.00%
TOTAL GEN FUND I GEN. PURPOSE REVENUE
S
45750889200
S 632.03il21 S
627 072,116 02 S
(4.965970.19) S (0.081_
EXPLANATION OF
M.
Ju rs
P 1FxPe ddu es
ovine
OPetafln9 ExPendwes
CpUNT"t Of 0
TERRBpORT
FY 202� SEEXP ISDICOUgR
CIRCUIT
XTA NvfD
BOP'SO
'ET
9 613 33D 00 $ $ es 911.52
22q 826 00
Internal guPPortSQendrtufes
T�ansfiet Out
BUP n� Dli EXPend�tu�es
OPecat�n9 �xPePditu�es
376 429 00
AopUwBIE ERCEHT ..
FAIJOp g� P,�-^^'"��
450
$ 9 363,33p 00 $ 442 500.00 64 51°/°
435 301 DO
243 411 52
450,301 00
10 q14 5g7 00 $ {0 934,b54
$52
1'(18$50 00
00 $ 2,065,
850 p0 $ 6g g30 p0
2 p67 610. 0 p0
$ 172 q3 .
172.430 p0
EY3LAr,,....-„ ibons.
Fa 'du toundefiDed and vac0 0,1raanticlPa �oand
Fay.
o{
Ea'319 t to yomev tha ed d%stnbut On i:me
an
em
pftie 9 lacts $$5 p0 ds {rnm ttha S annQ o9Y u$ZZO00) a tid
P oed
SudcaaiR.p90114a� tbary due to highs d ntfied above �s
P�olect ( {{set DI �n s (g10 0001 e valance
Pu$eaiThe pale a`n9 cause of tr'
use s l$20 p00} due wongoing emoteiY a$ a
due to Pandemcera m toW. Info ateduce'
tion ees Tech
On{av iefO co sOhtcc?a6e%0kaWIN oJoV had{ed above 15 due
I15 0p0 00i -g 45 eas pY oed P Vanden,
Svc u e op0 euJai'ances Ilan
h
Mheao etas m9ca
to the Pan
t osibons.
5 .OD g p31° undefi�lled and vacan P ai Ices �n
871. v due to d ptoiessio�he o eratc aemic,
16.92% "Fa $tea 0anadc�Pateede s due to the Pan
v Visitin9 3udges owes fled aD
350,0�p0 ° $20,p00 due to nce \denb
vada
102,`'p0 �0
cause of the
a'l
Internal Support Expenditures
Transfers Out
Civil / Criminal Division
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
AMOUNT
ADOPTED
AMENDED
FY 2021
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE)
PERCENT _EXPLANATION OF SIGNIFICANT VARIANCES
`+__
243,687.00
243,687.00
251,187.00
(7,500 00)
-3.08% - Unfay. Info Tech Operations ($10,000) due to ongoing
equipment costs which allow employees to work remotely as a
result of the pandemic. Partially offset by fay. Info Tech
Managed Print Svcs $2,500 due to lower than anticipated use.
The overarching cause of the variances identified above is due
to the pandemic.
$ 2,483,727.00
$ 2,484,967.00
$ 2,039,967.00
$ 445,000.00
17.91%
$ 1,777,891.00
$ 1,777,891.00
$ 1,652,891.00
$ 125,000.00
7.03% - Fay. due to underfilled and vacant positions.
1,821,589 00
1.821589.00
1,066,589.00
755,000.00
41.45% - Fay. Juror Fees and Mileage $450,000, Defense Atty Fees
Appellate $155,000; Transcript on Appeals $75,000; Office
Supplies $50,000; and Interpreter Fees $25,000 due to lower
than anticipated use. The overarching cause of the variance
identified above is due to the pandemic.
2,323 443 00
2,828,820.00
2,776,320.00
52,500.00
1.86% - Fay. Info Tech Operations $52,500 due to lower than
anticipated use. The overarching cause of the variance
identified above is due to the pandemic.
1,868,991.00
1,881,162.00
11881162.00
-
$ 7,791,914.00
$ 8,309,462.00
$ 7,376,962.00
$ 932,500.00
11.22%
28
Family Division/Juvenile Maim.
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfer Out
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
AMOUNT
ADOPTED
AMENDED
FY 2021
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE)
$ 12,172,216.00
$ 12,330,419.00
$ 11,280,419.00
$ 1,050,00000
9,305,257 00
9,307,734.92
5,752,734.92
3,555,000.00
2,183,332.00
2,188,065.00
2,210,565.00
(22,500.00)
6,377,343.00
6,379,928.00
6,379,928.00
-
$ 30,038,148.00
$ 30,206,146.92
$ 25,623,646.92
$ 4,582,500.00
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
8.52 % - Fay. due to underfilled and vacant positions.
38 19 % - Fay. due to decrease in placements to Priv Institutions
Residential $1,550,000 and State Institutions $1,250.000 based
on caseload, difficulty of care, and treatment of services
ordered by the Court Fay. Defense Atty Fees $375,000: Fees
Guardian Ad Litem $255,000, Professional Services $125,000
due to lower than anticipated use Offset by unfavorable Non -
Dept Child Care Subsidy Revenue (50% Reimbursement). The
overarching cause of the variance identified above is due to the
pandemic.
-1 03 % - Unfay. Info Tech Operations ($50,000) due to ongoing
equipment costs which allow employees to work remotely as a
result of the pandemic. Partially offset by fay. Info Tech
Managed Print Svcs $27,500 due to lower than anticipated use
The overarching cause of the variance identified above is due to
the pandemic.
0.00% -
15.17%
$ 25,831,047,00
$25,990,490.00
$ 24,015,490.00 $
1,975,000.00
760%
11,524,104.00
11,987,671.44
7,132:571.44
4,855,000.00
40.50%
5,126,89100
5,695,879.00
5,688,379.00
7,500.00
0.13%
8,246,334.00
8,261,090.00
8,261,090.00
-
0.00%
$ 50,728,376.00
$ 51,935,130.44
$ 45,097,630.44 $
6,837,500.00
13.17%
29
District Court Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Division 1 -Novi
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Total Division 1 - Novi
Division 2 - Clarkston
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Total Division 2 - Clarkston
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
DISTRICT COURT
AMOUNT
ADOPTED AMENDED FY 2021 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 238,267 DO $ 238,267.00 $ 238,267.00 $
10,300.00 10,3DD.00 1,800.00
2,318.00 2,318.00 2,318.00
$ 250,885.00 $ 250,885.00 $ 242,385.00 $
$ 4,600,355.00 S 4,615,055.00 $ 4,465,055.00
905,590.00 890,89D.00 821.890.00
428,311.00 440,740.00 410,740.00
- 0.00 % -
8,500.00 82.52 % Fay. Visiting Judges $8,500 due to lower than anticipated
use. The overarching cause of the variance identified above
is due to the pandemic.
0.00 %
- 0.00%
8,500.00 3.39%
150,OOD.00 325% - Fay. due to turnover and underflled positions/vacancies.
69,000.00 7.75% - Fay. Software Support Maintenance $17.000, Interpreter
Fees $12,500; Electrical Service $10,000: Office Supplies
$10,000, Juror Fees and Mileage $7,000, as well as Postage
Standard Mailing $5,000 due to lower than anticipated use.
Fay. Travel and Conference $7,5DO due to imposed travel
restrictions. The overarching cause of the variance identified
above is due to the pandemic.
30,000.00 6.81% - Fay. Telephone Communications $30,000 due to lower than
anticipated use. The overarching cause of the variance
identified above is due to the pandemic.
- O.DD% -
$ 5,934,256.DO $ 5,946,685.00 $ 5,697,685.00 $ 249,000.00 4.19%
$ 2,286,220.00 $ 2,286,220.00 $ 2,256,220.00
548,083.00 548,083.00 524,583.00
252,023.00 281,00700 266,007.00
$ 3,086,326 00 $ 3,115,310.00 $ 3,046,810.00 $
30,OOD.00 1.31 % - Fay. due to turnover and underflled positions/vacancies.
23,500.00 4.29% - Fay. Juror Fees and Mileage $7,500, Electrical Service
$5,500, and Interpreter Fees $5,000 due to lower than
anticipated use. Fav Travel and Conference $5,500 due to
imposed travel restrictions. The overarching cause of the
variance identified above is due to the pandemic.
15,OOD.00 5.34% - Fay. Telephone Communications $15,000 due to lower than
anticipated use. The overarching cause of the variance
identified above is due to the pandemic.
- 0.00% -
68,500.00 2.20%
30
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
DISTRICT
COURT
AMOUNT
ADOPTED
AMENDED
FY 2021
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Division 3 - Rochester Hills
Personnel Expenditures
$
4,090,212 DO
$ 4,090,212.00
$
3,865,212.00
225,000.00
5.50 %
- Fay. due to turnover and underflled posdions/vacancies.
Operating Expenditures
278,427.00
327,369 87
272,369.87
55,000.00
15.80 %
- Fay. Juror Fees and Mileage $15,000; Office Supplies
$20,000; Interpreter Fees $10,000, as well as Postage
Standard Mailing $10,000 due to lower than anticipated use.
The overarching cause of the variances identified above is
due to the pandemic
Internal Support Expenditures
857,122.00
870,356.00
840,356.00
30,000.00
3.45 %
- Fay. Telephone Communications $30,000 due to lower than
anticipated use. The overarching cause of the variance
identified above is due to the pandemic
Transfers Out
-
-
-
-
0.00%
$
5,225,761.00
$ 5,287,937.87
$
4.977,93787
$ 310,000.00
5.86%
Division 4 - Troy
Personnel Expenditures
$
2,568,798.DO
$ 2,568,798.00
$
2,533798.00
35,O0D.00
1.36%
- Fay. due to turnover and underfilled posdions/vacancies.
Operating Expenditures
447,072.00
469,396 DO
434,396.00
35,000 00
7.46%
- Fay. Interpreter Fees $20,000, Office Supplies $7.500, as
well as Juror Fees and Mileage $7,500 due to less than
anticipated use. The overarching cause of the variance
identified above is due to the pandemic.
Internal Support Expenditures
299,947.00
313,0630D
293,063.00
20,000.00
6.39%
- Fay. Telephone Communications$20,000 due to lower than
anticipated use. The overarching cause of the variance
identified above is due to the pandemic.
$
3,315,817.00
S 3,351,257.00
$
3,261,257.00
$ 90.00D.00
2.69%
Department Total
Personnel Expenditures
$
13,783,852.00
$ 13,798,552.00
$
13,358,552.00
$ 440,000.00
3.19%
Operating Expenditures
2,189,472.00
2,246,038.87
2,055,038.87
191,000.00
8.50%
Internal Support Expenditures
1,839,721.00
1,907,484.00
1,812,484.00
95,000.00
4.98%
Transfers Out
-
-
$ 17,813,045-DD $ 17,952,074.87 $ 17,226,07487 $ 726,000.00 4.04%
31
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
PROBATE COURT
AMOUNT
ADOPTED
AMENDED
FY 2021
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE)PERCENT
Judicial/Administration
Personnel Expenditures
$ 2,562,648.00
$ 2,562,648.00
$ 2,522,64800
$ 40,000.00
1.56%
Operating Expenditures
22,481.DO
22,481.00
13,981.00
8,500.00
37.81%
Internal Support Expenditures
479,627.00
479,902.00
474,402.00
5,50000
1.15%
Transfer Out
-
-
-
-
5 3,064,756.00
$ 3,065,031.00
$ 3,011,031.00
$ 54,000.00
1,76%
Estates/Mental Health
Personnel Expenditures
$ 2,346,708.00
$ 2,346,708.00
$ 2,046,708.00
$ 300,000 00
12.78%
Operating Expenditures
1,007,943.00
1,007,943 DO
902,943.00
105,000.00
10,42%
Internal Support Expenditures 608,358.00 632,338.00 649,838.00 (17,500.00) -2.77%
$ 3,963,009.00 $ 3,986,989.00 $ 3,599,489.00 $ 387,50000 9.72%
Department Total
Personnel Expenditures
$ 41909,356.DO
$ 4,909,355
00
$ 4,569,356.00 $
340,000.00
6 93%
Operating Expenditures
1,030,424.00
1,030,424.00
916,924.00
113,500.00
11.01%
Internal Support Expenditures
1,087,985.00
1,112,240.00
1,124,740.00
(12,000.00)
-1.08%
Transfer Out
-
-
-
-
$ 7,027,765.00
$ 7,052,020.00
$ 6,610,520.00 $
441,500.00
6.26%
EXPLANATION OF SIGNIFICANT VARIANCES
Fay, due to under -filled positions/vacancies
Fay. Library Continuations $3,000, Court Reporter Services $2,50D; as well as
Membership Dues $2,000 due to lower than anticipated use as it relates to the
pandemic Fay. Travel and Conference $1,000 due to travel restrictions as a
result of COVID-19.
Fav Info Tech Operations $3,ODO and Telephone Communications $2,500 due
to less than anticipated use.
Fay. due to underfilled positions/vacancies
Fay. Fees Guardian Ad Litem $75,000 and Defense Attorney Fees $55,000 due
to a decreased number of case filings and lower demand for these services. Fav
Expendable Equipment $t O,ODO due to lower than anticipated use. The
overarching cause of the variances identified above is also due to the pandemic.
Partially offset by unfay. Medical Services Probate Exam ($20,000) due to
continued high demand for these services Unfay. Software Support
Maintenance ($15,000) due to variable rate increases for the use of services
from the State of Michigan
Unfay. Info Tech Operations ($25,000) due to ongoing equipment costs which
allow employees to work remotely as a result of the pandemic. Partially offset by
fay. Telephone Communications $7,500 due to less than anticipated use.
32
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Litigation
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
PROSECUTING ATTORNEY
AMOUNT
ADOPTED AMENDED FY 2021 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
$ 2,724,325.00 $ 2,684,826 DO $ 2,674,826.00 $ 10,DO0 00 0.37%
Fav Salaries and Fringe Benefits due to turnover, partially offset by
unfay. Overtime
524,666.00 595,611.00 545,611 00 50,000 DD 8.39 %
Fay. Transition Expense $30,000 which is offset in other expenditure
accounts. Also fay. Witness Fees and Mileage $20,000, Extradition
Expense $15,000, Expert Witness Fee and Mileage $10,000, Filing
Fees $8,000, Expendable Equipment $2,500, Metered Postage $2,000
and Postage Standard Mailing $1,500 due to less than anticipated use,
partially offset by unfay. Printing ($30.000) and Membership Dues
($11,000) due to increased use for new employees
2,1 D7, 108.00 2,164,32400 2,214,324 DD (50.0DO.00) -2.31%
Unfay. Info Tech Operations$115,OOD) due to initial cost and quarterly
operating charges for 33 new laptop computers allowing employees to
work from home during COVID-19 pandemic, partially offset by Fay. Info
Tech Managed Print Services $46,000, Motor Pool $7,500, Equipment
Rental $5,500, Motor Pool Fuel Charges $4,000 and Telephone
Communications $2,500 due to less than anticipated use.
$ 5,356,099.00 $ 5,444,761 00 $ 5,434,761.00 $
$ 1D,969,418-00 $ 10,969,418.00 $ 10,619,418-00 $
28,301.00 27,801 DD 12,801.00
161,075-00 161,D75 00 161,075 00
975,027.00 975,027.00 975,02T00
$ 12,133,821.00 $ 12,133,321.00 $ 11,768,32100 $
- 000%
10,000 00 0.18%
350,000 00 3.19% Fav Salaries and Fringe Benefits due to turnover
15,DDO.00 53.95% Fay. Personal Mileage due to less than anticipated use.
000%
0.00%
365,000.DD 3.01%
33
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
PROSECUTING ATTORNEY
AMOUNT
ADOPTED
AMENDED
FY 2021
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Warrants
Personnel Expenditures
$
? 274,794.00
$ 2,274,794.00
$
2,249,794.00
$ 25,000 DO
1.10%
Fay. Salaries and Fringe Benefits due to turnover.
Operating Expenditures
3,199 00
3,199 OD
699.00
2,500.00
78.15%
Fay. Personal Mileage due to less than anticipated use.
Internal Support Expenditures
32213.00
32,213.00
32,213.DD
-
0.00%
$
2,310,206 00
$ 2,310,206 00
$
2,282,706.00
$ 27,500.00
1.19%
Appellate
Personnel Expenditures
$
1,951,093.00
$ 1,951,093.00
$
1,961,093.DO
$ (10,000.DD)
-051%
Unfav due to Overtime partially offset by fay. Salaries and Fringe
Benefits due to turnover.
Operating Expenditures
4,000.00
3,500.OD
2,000.00
1,50000
42.86%
Fav_ Personal Mileage due to less than anticipated use.
Internal Support Expenditures
27,082.00
27.D8200
27,062.00
-
0.00%
$
1,982,175.00
$ 1,981,67500
$
1,990,17500
$ (8,50000)
-0.43%
Department
Personnel Expenditures
$
17,919,530.00
$ 17,880,131.00
$
17,505,131.00
$ 375,000.00
210%
Operating Expenditures
560,166.00
630,111.00
561,111.00
69,000.00
1095%
Internal Support Expenditures
2,327,478.00
2,384,694.00
2,434,694.00
(50,000 DO)
-2.10%
Transfers Out
975,02700
975,02700
975,027.00
-
0.00%
$
21,782,301.00
$ 21,869,96300
$
21,475,96300
$ 394,DOO 00
1BD%
34
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
AMOUNT
ADOPTED AMENDED FY 2021 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Sheriffs Office
Personnel Expenditures
$ 1,842,596.00 $ 1,842,596.00 $ 1,642,596.00 $ 200TOOD.00 1185%
Fay. $200,000 due to vacant positions, turnover and Overtime which is offset in
other divisions
Operating Expenditures
93 020.OD 95,545.00 65,545 00 30,000.00 31 40 %
Fav Contracted Services 510,000. Material and Supplies $10,000, Office
Supplies $4,000, Communications $2,000 and Workshops and Meetings $2,000
due to less usage
Internal Support Expenditures
549,462 00 549,462.00 469,462 DO 80,000 00 14 56 %
Fay. Info Tech Operations $60,000, Motor Pool $12,000, Telephone
Communications $4,000 and Motor Pool Fuel Charges $2,000 due to less than
anticipated use.
Transfers Out
- - - - 0.00%
$ 2,485,078.00 $ 2,487,603.00 $ 2,177,60300 $ 310,000.00 1246%
Administrative Services
Personnel Expenditures
$ 1,296,145.00 $ 1,296,145 DO $ 1,496,145.00 (200,000.00) -15A3 %
Unfay. Salaries and Fringe Benefits due to emergency salary positions and
Overtime.
Operating Expenditures
515,668.00 618,152.58 499,152.68 19,000.00 367%
Fay. Printing 540,000, Uniform Cleaning $3D.000, Library Continuations
$15,000, Travel and Conference $10 OOD and Office Supplies $10,000 due to
less than anticipated use; partially offset by unfay. Equipment ($47,063) due to
upgrade to media room remote services and Uniforms ($38,000) both as a
result of COVID-19 pandemic.
Internal Support Expenditures
153,188.00 153.188.00 155,188.00 (2,000 00) -1 31%
Unfay. Info Tech Operations ($9,000) due to usage, partially offset by fay. Info
Tech Managed Print Services $S O00 and Telephone Communications $2,OD0
due to less than anticipated use.
Transfers Out
- - - - 0.00%
$ 1,965,001.00 $ 1,967,485.58 5 2,15D,4B5.58 $ (183,000.00) -930%
Corrective Services
Personnel Expenditures
34,659,086.00 34,659,086.00 $ 36,659,086.00 (2,000,000.00) -5.77%
Unfav Ovetme of which a portion is attributable to COVID-19 pandemic,
partially offset by fay. Salaries and Fringe Benefits as a result of vacant
positions, turnover, officers in the academy and officers in training. Also, COVID-
19 pandemic has contributed to additional leave time.
Operating Expenditures
7,615,253.00 7,647,642.80 8,062,642 80 (415 000.00) -5 43%
Unfay. Contracted Services ($430,OOD) for additional cost per inmate meal
above contracted rate due to COVID-19 pandemic, Equipment ($59,570) for
purchase of Jail CCTV as a result of COVID-19 pandemic and Adjustment Prior
Year's Revenue ($36,400) due to delayed Oakland County Health Network
(OCHN) report required to request reimbursement and reimbursement of
duplicate payment for Diverted Felon; partially offset by fay. Bedding and Linen
$30,000, Computer Supplies $20,000, Culinary Supplies $15.000, Inmate
Recreational Supplies $10,000, Interpreter Fees $10,D00, Transportation of
Prisoners $9.000, Pnsoner Housing -Outside County $8,OD0 and Indigent Orders
$8,000 due to less than anticipated use
35
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
AMOUNT
ADOPTED
AMENDED FY 2021
FAVORABLE
BUDGET
BUDGET FORECAST
(UNFAVORABLE) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Internal Support Expenditures
6,960,445.00
7,115,04D DO 7,170,040 OD
(55,OD0.00)
-0 77%
Unfav Info Tech Operations ($78,000) and Radio Communications ($53,ODO)
due to usage: partially offset by fay. Info Tech Managed Print Services $31,000,
Motor Pool $31,000 and Motor Pool Fuel Charges $15,000 due to less than
anticipated use.
Transfers Out
-
- -
-
0.00%
$ 49,234,784.00
$ 49,421,768.80 $ 51,891,76880
$ (2,470,ODO.DO)
-500%
Corrective Services -Satellites
Personnel Expenditures
$ 17,141A52.00
$ 17,141,45200 $ 15,141,452.00
$ 2,000,000.00
11S7%
Fay. Salaries and Fringe Benefits of which a portion is due to the pandemic and
related court closures (offset by unfavorable revenue for Reimbursement Court
Services). Favorat ity also due to vacant positions and Overtime.
Operating Expenditures
135,79T00
139,797.00 1D5797 00
34,000.00
24 32%
Fay. Laundry and Cleaning $25,000, Equipment Maintenance $5,D00, Travel
Employee Taxable Meals $3,500 and Printing $3,000 due to less than
anticipated use, partially offset by unfav Office Supplies ($3,000) due to usage
Internal Support Expenditures
1,313,248.00
1,314,895.D0 1.283,895 00
31.D00-00
2.36%
Fay. Motor Pool $22.000 and Motor Pool Fuel Charges $10,000 due to less than
anticipated use
Transfers Out
-
- -
-
0 00%
$ 18,590,49700
$ 18,596,144.00 $ 16,531,144.00
$ 2,065,00000
1110%
Emergency Response and Preparedness
Personnel Expenditures
$ 3,482,163.00
$ 3,462,163.DO $ 5,482,163 DO
$ (2,000,000.00)
-57.44%
Unfay. Salaries and Fringe Benefits due to emergency salary positions and
Overtime caused primarily by training classes required to be smaller (due to
COVID-19) and offering additional classes
Operating Expenditures
1,D58,056 DO
1,592,943.56 1,392,94155
200,000.00
12 56%
Fay. Fees Civil Service $130,000 which is offset in corresponding unfavorable
revenue. Also fay. Professional Services $60,000, Employees Medical Exams
$20,000 and Auction Expense $10,000 due to less than anticipated use,
partially offset by unfav_ Other Expendable Equipment ($22,600) due to
purchase of au cleaning respirators as a result of COVID-19 pandemic.
Internal Support Expenditures
452,038.00
452,231.00 451,231 00
1,000.00
0.22%
Fay. Info Tech Managed Print Services $11,000 due to less than anticipated
use, partially offset by unfav Info Tech Operations ($6,000) and Telephone
Communications ($4.000) due to increased usage.
Transfers Out
-
- -
-
0 00%
$ 4,992,25700
$ 5,527,337S6 $ 7,326,337.56
$ (1,799,000,00)
-3255%
36
Patrol Services
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Emergency Communications Operations
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
AMOUNT
ADOPTED AMENDED FY 2021 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
$57,564,505 $ 57,746,625.00 $ 55,746,625.00 $ 2,000,000.00
1,373,27700 2,161,03300 2A 15,03300 46,000.00
6,477,499.00 6,537453.00 5,937,453.00 600,000.00
- 21,750.00 21,750.00 -
EXPLANATION OF SIGNIFICANT VARIANCES
3AF/ Fay Salaries and Fringe Benefits of which a portion is due to the pandemic and
related event cancellation (offset by unfavorable revenue for Reimbursement
Salaries). Also, the favorabdity includes vacant positions and turnover; partially
offset by unfay. Overtime of which a portion is attributable to COVID-19
pandemic and political candidate security detail (Fall 2020)
2 13 % Fay. Equipment Rental $15,OOD. Office Supplies $9,500, Communications
$TD00, North Oakland Substation $5.000, Tovnng and Storage Fee $5,00D and
Material and Supplies $5.DDO due to less than anticipated use.
9 18% Fay. Motor Pool $3D6,000, Motor Pool Fuel Charges $255,ODO, Telephone
Communications $48,000 and Radio Communications $18,ODO due to less than
anticipated use; partially offset by unfay. Info Tech CLEMIS ($20,ODO) due to
usage.
000%
$ 65,415,281.00 $ 66,466,861.00 $ 63,820,86100 $ 2,646,000.00 3-98%
$ 9,673,179.00 $ 9,885,590.00 $ 10,535,590.00 $ (650,000.00) E.58%
204,100.00 288,815.00 280,815 DO 8,00000 277%
286,17800 286,178.00 242,17800 44,000.00 15.38%
- - - - 0.00%
$ 10,163,457.00 $ 10,460,583.00 $ 11,058,58300 $ (598,000.00) -572%
Unfay. Overtime of which a portion is attributable to COVID-19 pandemic and
emergency salary positions, partially offset by fay Salaries and related Fringe
Benefits due to vacant positions.
Fav Equipment Maintenance $27,000 due to less than anticipated use, partially
offset by unfav Other Expendable Equipment ($19,000) due to furniture
replacement
Fay, Radio Communications $45,000 and Telephone Communications $2,000
due to less than antcipated use; partially offset by unfay. Info Tech Operations
($3,000) due to usage
37
Investigative/Forensic Svcs
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
AMOUNT
ADOPTED AMENDED FY 2021 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
$ 9,419,275.00 $ 9,461,829.00 $ 9,111,82900 $ 350,000.00 3.70%
985,512.00 947,444.92 792.365.92 155,079.00 16 37%
3,046,076.00 3,046,076.00 3,109,076.00 (63,000.00) -2 07%
471,281-00 733,371.OD 733,37t00
D Do%
5 13,922,144.00 $ 14,188,720.92 $ 13,746,641.92 $ 442,079.00 312%
$ 135,078,401.00 $ 135,515,486.00 $ 135,815,486.00 $ (300,000.00) -0.22%
$ 11,980,683.00 $ 13,391,373.86 $ 13.314,29486 $ 77,079-00 0.58%
$ 19,235,134.00 $ 19,454,523 00 $ 18.818,52300 $ 636,000.00 327%
$ 471281.00 $ 755,121.00 $ 755,121.00 $ - 000%
$ 166768,499.00 $ 169,116,503.86 S 168,7D3,424.86 $ 413,079.00 D24%
EXPLANATION OF SIGNIFICANT VARIANCES
Fay. Salaries and Fringe Benefits due to turnover; partially offset by unfay.
Overtime and related Fringe Benefits.
Fay. Laboratory Supplies 5175,000 which is offset in corresponding unfavorable
Drug Testing revenue from reduced hours of the RESULTS drug testing
program due to COVID-19 Also fay. Software Support Maintenance $15,ODO,
Evidence Fund NET $10,000, Office Supplies $10,0D0, Drug Testing $7,000,
Extradition Expense $5,00D, Liquor and Gambling Evidence $5,000, Printing
$3,000 and Photographic Supplies $2,D00 due to less than anticipated use,
partially offset by unfav Uniforms ($63,500) for ballistic vest replacement and
Adl Prior Years Exp. ($15,035) for lab supplies and Fugitive Apprehension
Team (FAT) cell phones.
Unfav Info Tech Operations (S95,D00) and Motor Pool S42,D00) due to usage;
partially offset by fav Motor Pool Fuel Charges $39,000. Info Tech CLEMIS
$17 000 and Telephone Communications $16,000 due to less than anticipated
use
38
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
CLERKIREGISTER OF DEEDS
AMOUNT
ADOPTED
AMENDED
FY 2021 FAVORABLE
BUDGET
BUDGET
FORECAST (UNFAVORABLE)
PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
$ 624,618 00
$ 654,752.00
$ 619,752.00 $ 35,000.00
5.35 %
Fay. Salaries and Fringe Benefits; Primarily Retirement
Account
29,100.00
29,100.00
16,100.00 13,000.00
44.67%
Fav Travel and Conference $5,000, Office Supplies $4,000
and Printing $4,000 due to less than anticipated use.
91,893.00
91,893 00
71,893.00 20,000 00
21.76°%
Fav Telephone Communications $16,000 and Info Tech
Operations $4.000 due to less than anticipated used.
-
-
000%
$ 745,611.00
$ 775,745.00
$ 707,745 00 $ 68,000.00
8.77%
County Clerk (Vital Stats & Legal Rec's)
Personnel Expenditures
$
3,702,187 00
$
3,734,640 00
$ 3,734,640.00
$
-
0.00%
Operating Expenditures
274,660.00
324,660.00
274,660.00
50,00D.00
15.40%
Fay. Court Transcripts $25,000 and Professional Services
$25,000 due to less than anticipated use.
Internal Support Expenditures
672,992.00
856,708.00
856,70800
-
0.00%
Transfers Out
-
-
-
-
D.00%
$
4,649,839.00
$
4,916,008.00
$ 4,866,008.00
$
50,000.00
1,02%
Elections
Personnel Expenditures
$
957,965.00
$
1,176A01 00
$ 966,401.00
$
210,000.00
17.85%
Fay. due to turnover and undeflled positions
Operating Expenditures
791,723.00
1,263,786.00
1,263,786.00
-
0.00%
Intemal Support Expenditures
289,583.00
327,435.D0
327,435.00
-
0.00%
Transfers Out
-
-
-
-
0.00%
$
2,039,27100
$
2,767,622.00
$ 2,557,622.00
$
210,00100
7.59%
39
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
CLERK/REGISTER OF DEEDS
AMOUNT
ADOPTED
AMENDED
FY 2021 FAVORABLE
BUDGET
BUDGET
FORECAST (UNFAVORABLE)
PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Register of Deeds (and Micrographics)
Personnel Expenditures
$ 2,498,095 OD
$ 2,530,881.00
$ 1,980,881 00 $ 550,00000
21.73%
Fay. due to turnover, vacant and underfilled positions.
Operating Expenditures
212,494.00
212,494.00
$ 154,494.00 58,000.00
27.29%
Fay. Professional Services $20,500, Metered Postage
$17,000, Office Supplies $10,000, Expendable Equipment
$5,500 and Charge Card Fee $5,000 due to less than
anticipated use.
Internal Support Expenditures
280,565.00
281.960.00
$ 281,960.00 -
0 00%
Transfers Out
-
-
- -
0.00%
$ 2,991,154 00
$ 3,025,335.00
$ 2,417,335.00 $ 608,000.00
20.10%
Jury Commission
Personnel Expenditures $ 17,277.00 $ 17,277.00 $ 12,277.00 $ 5,000.00
Operating Expenditures 17,935.00
17,935.00
1,935.00 16,000.00
Internal Support Expenditures 18600
269.00
269.00 -
$ 35,398.00
$
35,481.00
$
14,481.00 $ 21,OOO.DO
28.94 % Fay. due to part-time position workload as the courts are not
able to have jury trials due to the COVID-19 pandemic;
Juror questionnaires are not being sent out.
89.21% Fay. Metered Postage $15,000 and Printing $1,000 as
courts are not able to have jury trials due to the COVID-19
pandemic, juror questionnaire are not being mailed out.
0 OD%
59.19%
Department Total
Personnel Expenditures $ 7,BDO,14200 $ 8,113,951.00 $ 7,313,95100 $ 800,DOD.00 9,86%
Operating Expenditures 1,325,91200 1,847,975.00 1.710,97500 $ 137,000.00 7.41%
Internal Support Expenditures 1,335,219.00 1,558,265.00 1,538,265.00 $ 20,000.00 128%
Transfers Out - - - 0.00%
$ 10,461,273.00 $ 11,520,191.00 $ 10,563,191 DO $ 957,000.00 6.31%
40
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
COUNTYTREASURER
AMOUNT
ADOPTED
AMENDED
FY 2021
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE)
PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
^'—
Administration
Personnel Expenditures
$ 3,550,959 00
$ 3,550,959.00
$ 3,200,959.00
$ 350,000.00
9.86 % -
Fay. due to turnover, underfills and vacant positions.
Operating Expenditures
3,433,770.00
3,433,770.00
2,333,770.00
1,100,000.00
32.03% -
Fav Title Search $700,000 and Contracted Services $400,000
due to less than anticipated use
Internal Support Expenditures
1,131,410.00
1,314,446.00
1,314,446.00
-
0.00%
Transfers Out
120,000.00
120,000.00
-
120,000.00
100 00 %
Fav due to pausing non -emergency demolitions in response to
COVID-19 pandemic
Division Total
$ 8,236,139.00
$ 8,419,175.00
$ 6,849,175.00
$ 1,570,000.00
18.65%
Department Total
$8,236,13900
$ 8,419,175.00
$ 6,849,175.00
$ 1,570,000.00
18.65%
41
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
BOARD OF COMMISSIONERS
AMOUNT
ADOPTED AMENDED FY 2021 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Administration
Personnel Expenditures $3,229,714.00 $3,194,654.00 $3,044,654.00 $ 150,000.00
Operating Expenditures 872,150.00 4,070,315.60 $4,018,915.60 51,400.00
Internal Support Expenditures 627,380.00 691,623.00 $ 760,623.00 (69,000.00)
Transfers Out 25,958.00 25,958 00
Department Total
EXPLANATION OF SIGNIFICANT VARIANCES
4.70% - Fay. primarily due to vacancy.
1 26 % - Fay. Legal Services $15,000, Personal Mileage $15,000. Workshops and Meetings
$10,000 Periodicals Books Pub Sub $5,000, Travel and Conference $5,000, Equipment
Maintenance $1,800 and Binding $1,600 due to decreased activity, partially offset by
Contracted Services (52,000).
-9.98% Unfay. IT Operations ($76,000) due to increased demand of IT related
equipment/services; partially offset by Info Tech Managed Print Services $7,000 due to
lower than anticipated use.
$4,729,244.00 $7,982,550.60 $7,850,150.60 $ 132,400.00 1.66%
Personnel Expenditures $3,229,714.00 $3,194,654.00 $3,044,654.00 $ 150,000.00 4.70%
Operating Expenditures 872,150.00 4,070,315.60 4,018,915.60 51,400.00 1.26%
Internal Support Expenditures 627,380.00 691,623.00 760,623.00 (69,000.00) -9.98%
Transfers Out - 25,958.00 25,958.00 -
$4,729.244.00 $7,982,550.60 $7,850,150.60 $ 132,400.00 166%
42
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
WATER RESOURCES COMMISSIONER
AMOUNT
ADOPTED AMENDED FY 2021 FAVORABLE
BUDGET BUDGET FORECAST [UNFAVORABLE)PERCENT
Water Resource Commissioner
Personnel Expenditures $ 228.118.00 $ 228,118.00 $ 228,118.00 $ - 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
Operating Expenditures 287,975 00 287,975.00 311,475 00 (23,500.00) -8.16 % Unfav - Contracted Services ($15.200) due to the spending on the Northwest
Interceptor Comprehensive study project. Unfav- Adjustment Prior Years
Expense ($4,800) due to a FY 2018 legal invoice being paid in FY 2021 on
Chapter 20 drain matters. Unfav - Public Notices ($2.000) the result to display
legal advertising for lake improvement boards.
Internal Support Expenditures 7,226,628.00 7,361,259.00 7,361,259.00 - 0.00%
Transfers
Division Total
Department Total
56,16500 56,165.00 56,165.00 - 0.00%
$ 7,798,886.00 $ 7,933,517.00 $ 7,957,017.00 $ (23,500,00) -0.30%
$ 7,798,886.()0 $ 7,933,51Z00 $ 7,957,017.00 $ (23.500.00) -0.30%
43
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfer Out
Compliance Office
Personnel Expenditures
Operating Expenditures
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
COUNTY EXECUTIVE
AMOUNT
ADOPTED
AMENDED
FY 2021 FAVORABLE
BUDGET
BUDGET
FORECAST (UNFAVORABLE) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
$ 2,637,279.00 $
2,183,412-00
2,083,4120D $ 100,000.00 4 58 %
Fay. Salaries and Fringe Benefits primarily due to
vacancies
258,357.DD
2,398,357.00
2,452,557 00 (54,200.00) -2.26%
Unfav Contracted Services ($40,DOO), Office
Supplies ($10.00D), Training ($4,500), Advertising
($3,700) due to increased activity, partially offset by
Personal Mileage $2,OOD and Metered Postage
$2,000 due to reduced travel.
414,629.00 513,261.00 535,261.OD (22,000.00) 4 29% Unfay. Info Tech Operations ($30,000) due to
greater than anticipated usage, partially offset by IT
Managed Print Services $5,000 and Motor Pool
$3,000 based on decreased activity
$ 3,320,265.00 $ 5,095,03D.00 $ 5,071 230 DO $
$ 454,292 DO
$ 454,292.00 $
454,292.00 $
21,65300
25,060.57
20,060.57
Internal Support Expenditures 76,958.00 76,958.00 71,958 00
Transfer Out - - -
$ 552,903 DO $ 556,310.57 $ 546,310.57 $
23,800.00 047%
0.00 %
5 ODD.00
19 95%
Fay. Travel and Conference $S,ODD due to less
travel in FY 2021
5,000.00
6 50%
Fay. Info Tech Operations $5,000 due to less than
anticipated usage.
10,000.00
1 80%
44
Corporation Counsel
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfer Out
Office of Public Communications
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
COUNTY EXECUTIVE
AMOUNT
ADOPTED AMENDED FY 2021 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 2,831,546.00 $ 2,831,546.00 $ 2,716,546.00 $
81,045.00 87,045.00 74,045.00
313,925.00 353,589.00 349,589.00
115,000 00 4.06% Fay. Salanes and Fringe Benefits primarily due to
vacancies
13,000.00 14 93% Pay. Travel and Conference $4,500, Library
Continuations $3,000, Office Supplies $2,000,
Personal Mileage $1,500, Periodicals Book Pub[
1,000, and Computer Supplies $1,000 due to less
than anticipated use.
4,0D0,00 1.13 % Fay. Info Tech Managed Print Services $3,DDD and
Telephone Communications $1,0D0 due to
decreased activity.
$ 3,226,51600 S 3,272,180.OD $ 3,140,18000 $ 132,000.00 4.03%
$ -
$
991,263.O0
$ 991,283
00
S
-
$
$
$
$
$ -
$
991,28300
$ 991,28300
5
-
$ 5923,117.00
$
6,460,533.00
$ 6,245,533.00
$ 215,000,00
333%
371,055.00
$
2,510,462.57
2,546,662.57
(36.200.00)
-144%
805,512.DD
943.808.00
956,808
00
(13,000.00)
-1.38%
$ 7,099,684.00
$
9,914,803.57
$ 9,749,003.57
$ 165,80000
167%
45
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Equalization
Personnel Expenditures
Operating Expenditures
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
AMOUNT
ADOPTED
AMENDED
FY 2021 FAVORABLE
BUDGET
BUDGET
FORECAST (UNFAVORABLE)
PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
$ 194,170.00
$
194,170.00
$ 194,17000 $ -
0.00%
4,017.00
4,017.00
4,017.00 -
0.00%
65,970.00
65,970.00
65,970.00 -
0.00%
$ 264157,00
$
264,157.00
$ 264,157.00 $ -
0.00%
$ 8,883,574.00
$
8,883,57400
$ 8,283,57400 $ 600,000.00
6.75%
Fay. Salaries$300,000 and Fringe Benefits$300,000 due
to vacancies and underfills.
421,404.00
421,404.00
321,404.00 100,000.00
23.73%
Fay. Personal Mileage $50.000, Printing $20,000,
Professional Services $20,000, and Training $10,000 due
to less than anticipated use.
Internal Support Expenditures 994,099.00 1,165,168.00 1.165,16800 - 0.00%
Transfers Out - - - - 0.00%
$10,299,077.00 $10,470,146.00 $ 9,770,146.00 $ 700,000.00 6.69%
Fiscal Services
Personnel Expenditures $ 8,290,188.00 $ 8,290,18800 $ 7,740,188.00 $ 550,000.00 6 63% Fay. Salaries $350,000 and Fringe Benefits $200,000 due
to turnover and timing of replacements.
Operating Expenditures 354,300.00 378,579.00 412,579.00 $ (34,000.00) -8 98% Unfay. Contracted Services ($65,000) partially offset due
to vacancy in position #3557 (Controllable Personnel)
Partially offset by fay. Metered Postage $15,000,
Professional Service $7,000, Office Supplies $3,500,
Software Rental Lease Purchase $1,500, Membership
Dues $1,DD0, Periodicals Books Publ Sub $1,000,
Personal Mileage $1,000, and Provisions $1,000 being
less than anticipated.
46
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
AMOUNT
ADOPTED
AMENDED
FY 2021 FAVORABLE
BUDGET
BUDGET
FORECAST (UNFAVORABLE)
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Internal Support Expenditures
1,790,192.00
1,965,248.00
1,957,248 00 $ 8,000.00
0.41 % Fay. Info Tech Managed Print Services due to less use.
Transfers Out
-
-
- -
0.00%
$10,434,68000
$ 10,634,015.00
$ 10,11D,015.00 $ 524,DD0.00
4.93%
Purchasing
Personnel Expenditures
$ 1,173,34500
$ 1,173,345.00
$ 1,173,34500 $ -
0.00%
Operating Expenditures
12,225.00
20,654A3
$ 20,654A3 $ -
000%
Internal Support Expenditures
707,738.00
708,298.00
$ 7D8,298.DD $ -
D.00%
Transfers Out
-
-
- -
0.00%
$ 1,893,308.00
$ L902,297.43
$ 1,902,297.43 $ -
O,OD%
Department Total
Personnel Expenditures
$18,541,277-00
$ 1B,541,277.OD
$ 17,391,277.00 $ 1.150,00000
6.20%
Operating Expenditures
791,946.00
824,654.43
758,654A3 66,000.D0
80D%
Internal Support Expenditures
3,557,9990D
3,904,684.00
3,896,684,00 8,000.00
0.20%
Transfers Out
-
-
- -
0.00%
$22,891,222.00
$ 23270,61543
$ 22,048,61543 $ 1,224,DO0.00
5.26%
47
Administrative
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Support Services
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
CENTRAL SERVICES
AMOUNT
ADOPTED
AMENDED
FY 2021 FAVORABLE
BUDGET
BUDGET
FORECAST (UNFAVORABLE)
PERCENT
$ 236,503.00
$ 236,503,00
$ 236,503.00 $ -
0.00%
3,298.00
3,298.00
3,298.00 -
0.00%
11,743.00 11,743.00 8,643.00
$ 251,544.00 $ 251,544.00 $ 248,444.00 $
EXPLANATION OF SIGNIFICANT VARIANCES
3,100.00 26.40 % - Fay. primarily due to Motor Pool due to less than anticipated
use
3,100.00 1.23 %
$
1250,533.00
$
1,250,533.00
$
1,250,533.00
$
-
0.00%
330,825.00
330,825.00
325,825.00
5,000.00
1.51 % - Fay. Software Rental Lease Purchase due to less than
anticipated cost of software.
743,425.00
762,196.00
752,196.00
-
0.00%
-
-
-
-
0.00%
$
2,324,783.00
$
2,333,554.00
$
2,328,554.00
$
5,000.00
0.21 %
$
1,487,036.00
$
1,467,036.00
$
1,487,036.00
$
-
0.00%
334,123.00
334,123.00
329,123.00
5,000.00
150%
755,16800
763,939.00
760,839.00
3,100.00
0.41%
0.00%
$
2,576,327.00
$
2,585,098.00
$
2,576,998.00
$
8,100,00
0,31 %
48
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
FACILITIES MANAGEMENT
AMOUNT
ADOPTED
AMENDED
FY 2021
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
$ 221,949.00
$ 221,949.00
$
221,949.00
$ -
0 00%
Operating Expenditures
2,687.00
2,687.00
1,687.00
1,00D.00
37.22%
Fay. Membership Dues $1.000 due to less than anticipated usage
as a result of COVID-19.
Internal Support Expenditures
11,197.00
11,197.00
13,197.00
(2,000.00)
-17 86%
Unfav Info Tech Operations ($2,000) due to more than anticipated
usage as a result of COVID-19.
$ 235,833.00
$ 235,833.00
$
236,83300
$ (1,000.00)
-0.42%
Facilities Engineering
Personnel Expenditures
$ 867,043.00
$ 867,043.00
$
797,043.00
$ 70,D00.00
8.07%
Fay. due to tumover/vacant positions.
Operating Expenditures
276,027.00
617,996 70
600,496 70
17,500.00
2.83%
Fay. Travel and Conference $10,000 as well as Training $7,500
due to travel restrictions as a result of COVID-19
Internal Support Expenditures
120,305.00
120,533.00
120,533.00
-
0.00%
$ 1,263,375.00
$1,605,572.70
$
1,518,072.70
$ 87,500.00
5.45%
Department Total
Personnel Expenditures
$1,088,992.00
$1,088,992.00
$
1,018,992.00
$ 70,000.00
6.43%
Operating Expenditures
278,714.00
620,683.70
602,183.70
18,500 00
2.98%
Internal Support Expenditures
131,502.00
131,730.00
133,730.00
(2,000.00)
-1.52%
$1,499,208.00 $1,841,405.70 $ 1,754,905.70 $ 86,50000 470%
49
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Workforce Management
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
ADOPTED
BUDGET
749,996.00 $
251,243.00
79,616.00
1,080,85500 $
2,290,793.00 $
314,358 00
1,109,056.00
3,714,207.00 $
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
HUMAN RESOURCES
AMOUNT
AMENDED
FY 2021 FAVORABLE
BUDGET
FORECAST (UNFAVORABLE)
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
749.996.00 $
604,996.00 $ 145,000.00
19.33 % Fay. due to vacancies turnover and employees taking
VESIP.
701,243.00
586,243.00 115,000.00
16.40 % Fay. Professional Services $100,000 and Travel and
Conference $15,000 due to less than anticipated
activity.
80,290.00
80,29D.00 -
0.00°%
1,531,529.00 $ 1,271,529.00 $ 260,000.00
2,290,793.00 $ 2,290,793.00 $ -
356,116.00 273,116.00 83,000.00
1,190,907.00
950,907.00
240,000.00
3,837,816.00
$
3,514,816.00
$
323,000.00
16.98 %
0.00 %
23.31% Fay. Employee Medical Exams $40,000, Recruitment
Expense $15,000 and Travel and Conference $15,000,
and Examination Material $13,000 due to less than
anticipated activity and hiring freeze.
20.15% Fay. Info Tech Operations $240,000 due to less than
anticipated use.
8.42 %
$ 3,040,789.00
$
3,040,789.00 $
2,895,78900 $
145,000.00
4.77°%
565,60L00
1,057,359.00
859,359.00
198,000.00
18.73%
1,188,67200
1,271,197.00
1,031,197.00
240,000.00
18.88%
$ 4,795,06200
$
5,369,345.00 $
4,786,345.00 $
583,000.00
10.86%
50
Adminrstt el Ex endiWres
persons
9 Expenditures
OPera5n
p 09TF-D
--' y2117q p0
$
4 336 �g 00
Me N°EO
BUOGE_.
YypN° T
COUNTY OOUARTERREPOR
120 21 SEEpN° KUMAN SERVICES
KEp�TK T
FP`1ORABBLEI PERCENT
FY 202t `UNFpVORt` �- `
FORECP`a- 0
221.174g0 $
4 343,2g3 g0
221.174 p0 $
36742g3go
12,373 00
12,3700
4107.
SuPP°n Expenditures - ` $
/_._ a6g6640 D0
internal _-4 566, 73A.00 $ 31343,314p0
s{ers Out $ 3 31q o0 $
Tian
$ 7 19g,904.2
32 �
$ 29 711 122 00 7 165 00425
Keatth endAures 4362 g3500
personnel ExP
OPeratrng Expenditures
3 263 260 00
Internal SuPPod Expenditures
3 576 662 g0
10 SO%
469,000 00
EXPUpNPT��N o. S1GNlF1GANT ,
ARIPNCES
ate
lns00
fltu6
OOO.Pnva 00pD0.
0,
s °a5p0, ervices $60, Foyer
pay.Privfiat$6D�o 200p0'nryscellil lnsteu6onsFosterCathan
Rd PendeanjPg emes $ o 000Ca'40 anon5erence $9600 less
$�0 Q00, adndue to Para rn b.
antmiPate
0 g0of0
469,000 00
3 576662p0
`33 90D g0i
3 09%
-0 47°(0
Benefits due to va°aoo1es.
POD) due to cOVtO d w hg
Fav- Sewl and Fnnge
Fees l$1 i731t be PartiaiN Dover
� ent
Unfay.LaboratoN jes (vuh�cbisbudgetelraswegnuertm
and\IeW es tF'ndi 9�ithatose PnogYearsR Partia Y
pure ve tl onset
Pa
Cs b5eg Fund GAd,uPT Yearsc s $�$?pp 000,are SuPP l rl
Gen uent grant
nd
0
l$27 SOO)' contraal M ea0e $2p0,0 Suppiies $g1 p0
$60 p0 Matnte"a Per$100 ��Ga1 on l PRlavel an Parini mrc Des
de
Ewe
Tr i), ment$30ated due
$40,00 Equip Crci4
$10 Ap0 bem91ess tha
Si
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
AMOUNT
ADOPTED AMENDED FY 2021 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
.-_-___.,__-_________.,___ --------------- -------------- -------------- ---------------- --------
Transfers Out
EXPLANATION OF SIGNIFICANT VARIANCES
$ 37,337,317.00 $43,084,980.25 $ 42,118,880.25 $ 966,100.00 2.24%
Homeland Security'
Personnel Expenditures $ 899,627.00 $ - $ - $ - #DIV10! " Per M.R. #20461County Executive - Transfer of
Homeland Security and Building Safety department budgets
moved to Emergency Department division (1110101).
Operating Expenditures 294,66700
Internal Support Expenditures 559,468.00
Transfers Out
$ 1,753,762.00 $ - $ - $
MSU Extension - Oakland County
Personnel Expenditures $ 520,795.00 $ 520,795.00 $ 502,695.00 $
Operating Expenditures 303,035.00 303,035.00 290,535.00
Internal Support Expenditures 286,147.00 286,230.D0 280,730.00
- #DIV/0!
- #DIVl0!
#DIV/0!
18,100.00 3A8% Fay. Due to vacant positions.
12,500.00 4.12% Fay. Workshop and Meetings $3,000, Personal Mileage
$2,500, Office Supplies $2,400, Metered Postage $2,100,
Special Event Planning $1,000, Travel and Conference
$1,000, and Printing $500 due to COVID-19 pandemic and
all programs being offered online.
5,500.00 1.92% Fay. Info Tech Managed Print Services $3,500 and Motor
Pool $2,000 due to less use as it relates to the COVID-19
pandemic.
52
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
AMOUNT
ADOPTED
AMENDED
FY 2021 FAVORABLE
BUDGET
BUDGET
FORECAST (UNFAVORABLE)
PERCENT
Transfers Out
-
-
_ _
$
1,109,977.00 $
1,110,060.00
$
1,073,960.00 $ 36,10000
3.25%
Neighborhood & Housing Dev.
Personnel Expenditures $
- $
-
$
- $ -
#DIV/01
Operating Expenditures
-
-
$
- -
#DIV/01
Internal Support Expenditures
-
-
$
- -
#DIV/O!
Transfers Out
589,161.00
1,214,983.00
$
1,214,983.00 -
$
589,161.00 $
1,214,983.00
$
1,214,983.00 $ -
0.00°%
Department Total
Personnel Expenditures
$
31,352,718.00
$
33,085,283.00
$
32,067,183.00
$
1,018,100.00 3.08°%
Operating Expenditures
$
9,297,305.00
$
11,811,332.25
$
11,363,732.25
$
447,600.00 3.79%
Internal Support Expenditures
$
4,117,767.00
$
3,875,265.00
$
3,869,765.00
$
5,500.00 0.14°%
Transfers Out
$
589,161.00
$
1,214,983.00
$
1,214,983.00
$
- O.00%
$ 45,356,951.00 $ 49,986,363.25 $ 48,515,663.25 $ 1,471,200.00 2.94%
EXPLANATION OF SIGNIFICANT VARIANCES
53
ADOPTED AMENDED
BUDGET BUDGET
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
AMOUNT
FY 2021 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Public Services - Admin.
Personnel Expenditures $
236,586.00
5
236.586.00
208,586.00 $
28,000.00
11,84% Fay. due to vacancies and turnover
Operating Expenditures
4,800.00
4,800.00
1,800.00
3,000.00
62 50% Fay. due to Special Event Program and Travel and
Conference due to less than anticipated use.
Internal Support Expenditures
6,144.00
6,144.00
6,14400
-
0.00%
$
247,530-DO
$
247,530.00 $
216.530.00 $
31,OOD 00
12.52%
Community Corrections
Personnel Expenditures $ 4,046,942-00 5 4,046 942.00
Operating Expenditures 472,025 00 472025.00
Internal Support Expenditures 531 711.00 586,912.00
Transfers Out
Medical Examiner
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Animal Control
Personnel Expenditures
3757,942.00 $ 289,000.00 7.14% Fav due to vacancies and turnover
326,025.00 146,000.00 30.93% Fay. Contracted Services $125,000, Office Supplies $7,500
and Printing $5, DOD due to less than anticipated use. Also,
favorable Travel and Conference $9, DOD due to travel
restrictions as a result of COVID-19.
636,912.00 (50,004DD) -8.52% Unfay. Info Tech Operations ($48,000) and Telephone
Communications ($2,000) due to increased use relating to
COVID 19 purchases
$ 5,D5D,678.00 $ 5,105,87900 $ 4,720,87900 $ 385.00D.00
$ 3,571,748.00 $ 3,571748.00 $ 3,446,74800 $ 125,000.00
645,219 00 545.219.00 645,219.00 -
828,661.00 846 456.00 846 456.00 -
$ 5,045,628 00 $ 5,D63.423.00 $ 4,938,423 00 $ 125,000 DO
$ 2,580,003 00 $ 2,587,726.00 $ 2,502,726.00 $ 85,OOO.00
Operating Expenditures 394,286 00 837,80&00 837,806 DO Internal Support Expenditures 1,093,573 00 1,119,789.00 1,119,789 00 -
Transfers Out - - -
$ 4,067,862.00 $ 4,545,32L00 $ 4,460,321 00 $ 85,OOD 00
0.00% -
7.54%
3.50% Fav due to vacancies and turnover
0 00%
0.00%
2 47%
3 28% Fay. due to on -call pay and overtime less than anticipated
use, as well as vacant and underfilled positions.
0 00%
0 00%
1.B7%
54
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
AMOUNT
ADOPTED AMENDED FY 2021 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Circuit Court Probation
Personnel Expenditures $ - $ - $ - $ - 000%
Operating Expenditures 54,326.D0 54,326.00 15,326.00 39,000.00 71.79% Fay. Office Supplies $28,000, Metered Postage $6,000 and
Printing $5,000 due to less than anticipated use.
Internal Support Expenditures 569,149.00 569,531.00 569,531 OD - O.DO%
$ 623,475.00 $ 623,85T00 $ 584,85700 S 39,OOD 00 6.25%
Children's Village
Personnel Expenditures $ 18,702,310 DD S 18,970,028.00 $ 18,120,028.00 S 850,000 00 0 DD% Fav due to vacant and under -filled positions as well as staff
being redeployed to Health Department to assist with contact
tracing.
Operating Expenditures 3,945,872 DD 3,962,470 84 3,962,470 84 - 0.00%
Internal Support Expenditures 2,643,19700 2,680,25400 2,680,25400 - 0.00%
$ 25,291,379.00
S 25,612,75284
$
24 762,752 84
$ 850,000.00
3,32%
Department Total
Personnel Expenditures
$ 29,137,589.00
S 29,413,030.00
$
28,036,03000
$ 1,377,000.00
4.68%
Operating Expenditures
S 5,516,528 00
S 5,976,646 84
S
5,788,646 84
$ 188,000.00
3 15%
Internal Support Expenditures
$ 5,672,435 00
S 5,809,086 00
$
5,859,086 00
$ (50,000.00)
-086%
Transfers Out
$ -
S -
$
-
$ -
$ 40,326,55200 S 41,198,76284 $ 39 683,762 84 $ 1,515,000.00 368%
55
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS
AMOUNT
ADOPTED
AMENDED
FY 2021 FAVORABLE
BUDGET
BUDGET
FORECAST (UNFAVORABLE) PERCENT
$ 1,683,096.00
$ 1,326,092.00
$ 1,326,092.00 $ - 0.00%
442,222.00
454,588.65
454,588.65 - 0.00%
109,490.00
113,497.00
113,497.00 - 0.00%
$ 2,234,808.00 $ 1,894,177.65 $ 1,894,177.65 $ -
Local Business Development Division (FKA PEDS)
Personnel Expenditures $ 4,182,544.00 $ 1,844,058.00 $ 1,844,058.00 $ -
Operatmg Expenditures 1,196,032.00 15,777,732.00 15,365,532.00 412,200 00
Internal Support Expenditures 879,746 00 910,973.00 910,973.00
Transfers Out - - - -
$ 6,258,322.00 $ 18,532,763.00 $ 18,120563.00 $ 412,200.00
Business Development
Personnel Expenditures $ - $ 1,972,369 00 $ 1,972,369.00 $ -
Operating Expenditures - - -
internal Support Expenditures - - (15,000.00) 15,000.00
Transfers Out - 1.300,000 00 1,300,000.00 -
$ - $ 3,272,369.00 $ 3,257,369.00 $ 15,000.00
0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
0.00%
2.51 % Fay. Workshop and Meetings $200,000, Business Recruitment
$100,000, Software Support Maintenance $75,000, Advertising
$30,000, Personal Mileage $20,000, Travel and Conference
$19,000, Metered Postage $10,000, Office Supplies $10,000,
Printing $7,000, Freight and Express $7,000, and Legal Services
$4,000 due to lower than anticipated used The overarching cause
of the variances identified above is due to the COVID-19 pandemic.
Partially offset by unfavorable Contracted Services ($60,000),
Software Rental Lease Purchase ($5,900), and Periodicals Books
Publ Sub ($3,900) being more than anticipated.
0.00%
222%
0.00%
0.46%
Unfay. Info Tech Operations ($12.300), Telephone
Communications ($2,700) due to Economic Development
reorganization (M.R. #20462).
56
COUNTYOFOAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS
AMOUNT
ADOPTED AMENDED FY 2021 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
Workforce Development (Includes Veteran's Services)
Personnel Expenditures
$ 1,676,895.00
$ 1,840,912.00
$ 1,840,912.OD $ -
Operating Expenditures
189,624.00
1,965,460 00
2,045,860.00 $ (80,400.0D)
Internal Support Expenditures
2D8,143.D0
219,157.DD
219,157.DD -
Transfers Out
$ 2,074,662.00
$ 4,025,529.00
$ 4,105,929.OD $ (80,400.00)
Department Total
Personnel Expenditures
$
7,542,535.00
$ 6,983,431.00
$ 6,983,431.00
$ -
Operating Expenditures
$
1,827,578.00
18,197,780.65
17,865,980.65
$ 331,800.00
Internal Support Expenditures
$
1,197,379.00
1,243,627.OD
1,228,627.00
$ 15,000.00
Transfers
$
-
1,3DO,000
OD
1,300,000.00
$ -
$
10,567,792.00
$ 27,724,838.65
$ 27,378,038.65
$ 346,800.00
EXPLANATION OF SIGNIFICANT VARIANCES
0.00%
Unfay. Due to Special Projects ($45,600) and Veterans Emergency
Services ($34,800) being more than anticipated.
-2.00 %
0.00%
1.82%
1.21%
0.00%
1.25%
57
Emergency Management
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Building Safety*
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
EXPENDITURES
EMERGENCY MANAGEMENT AND HOMELAND SECURITY
AMOUNT
ADOPTED AMENDED FY 2021 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
$ - $ 930,653 00 $ 930,653.00 $ - 0.00%
- 297,943.00 297,943.00 - 0.00%
- 590,115.00 590,115.00 - 0.00%
$ - $ 1,818,711.00 $ 1,818,711.00 $ - 0.00%
Department Total
Personnel Expenditures $
Operating Expenditures $
Internal Support Expenditures $
Transfers Out $
- $
930,653.00
$
930,653.00
$
- 0.00%
- $
297,943.00
$
297,943.00
$
- 0.00%
- $
590,115.00
$
590,115.00
$
- 0.00°%
- $
-
$
-
$
- #DIV101
- $
---- ---------------
1,818,711.00
$
------'---'---
1,818,711.00
$
----'-----------
- 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
* Building Safety is part of the Facilities Management &
Operations fund #(63100)
58
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
NON -DEPARTMENTAL EXPENDITURES
AMOUNT
ADOPTED
AMENDED
FY 2021
FAVORABLE
BUDGET
BUDGET
FORECAST (UNFAVORABLE)
PERCENT
EXPLANATION
NON-DEPARTM ENT APPROPRIATIONS
COUNTY OPERATIONS
Salary Turnover Factor
$
(6,000,000.00) S
(6,000,000.00)
(6,000,000.00) $
-
0.00%
Fringe Benefd Turnover Factor
(4,000,000,00)
(4,000.DOD.00)
(4,000,000.00)
-
000%
Insurance Fund
401,413.00
41)1,413.00
401,413 DO
-
ODD%
Insurance Surety Bonds
33,305.OD
33,30500
33,305.00
-
OOD%
Logos Trademarks Intellect Property
2D,ODC00
20,00D.O0
20,OD0.00
-
OLD%
Road Commission\Current Drain Assessment
1,450,000.00
1,450,DO0.00
1,450,000.DO
-
000%
Road Commission\Tn Party Agreement
10D.00
2,015,743.00
2,015,743.00
-
0.00%
Professional Services
-
175,000 DO
1,383,567.00
(1,208,567.DO)
-69061%
Unfay. tlue to external vendor resources working on COVID-19
Provisions
activihes. De. COVID-19 Help Hotline)
3D,O00.00
223,53D.O0
1,213, 724.D0
(990,194.OD)
-442.98%
Unl due to county departmental Costs for COVID-19
Transfer to Community Mental Health Authority
9.620,616.O0
9,620,616.00
9,620,61600
-
000%
activities
Transfer to Municipalities
-
31,945,953.00
31,945,983.00
-
0OD°6
Total
3
1,555,434.00 $
35,885,590.00 $
38,084,351,00 $
(2,198,761.00)
-1133.59%
COUNTY BUILDINGS
$
2,492,736.00 $
2,205,886.00 $
2,205,886.00 $
000%
STATE AND FEDERAL - COUNTY ASSOCIATIONS
Michigan Assoc of Counties
$
73,OD0.00 $
73,000.OD $
73,000.00 $
-
0.00%
National Assoc. of Counties
24,10000
24,100.00
24,100.00
-
0,00%
S.E.M C.O.G.
540,000.00
54DAD0.D0
W.00D.OD
-
000%
Traffic Improvement Association
30,000.00
30,000,00
30,000.00
-
000%
Total
$
667,100.00 $
667,100.00 $
667,100.00 $
-
000%
SUNDRY EXPENSE
$
300,000.00 $
300,000.00 $
300,00D.00 $
000%
RESERVED FOR TRANSFERS
Expenditures
Classificeaon and Rate Change
Contingency
Disaster Recovery
Emergency Salaries
General Fund Contingency
Grant Match
Info Tech Development
Juvenile Resenlenong
$ 11,871.00 $ 59,454.00 $ 59A54OO $ -
273,262.00 221,512.00 221,512.00 -
300,OOD.00 300,000.00 300,000.00 -
252,976.00 252,97600 252,976.00 -
(6,OOD,000.00) (6000,00D.OD) (6.D000DO.00) -
273,644.00 37,930.00 37S30.00 -
7,454,96100 5,160,047.00 5.160,04700 -
- 1,127,000.00 627,00000 500,000.00
D.00%
000%
0,00%
0.00%
0.00%
0.00%
000%
4437% Fay. Expected due to Prosecutor's Office recent filing of
resentencing notices for 22 individuals
Legislative Expense
8,00.00
8,600.00
8SDO.DO -
0.00%
Locel Road Funding Program
1 00
1.00
1.00 -
0.00%
Mis, Capital Outlay
315,034.00
816,369.00
816,369.00 -
000%
Overfime Reserve
575,00000
575.00.00
575,000.00 -
0.00%
Pnvate Institutions Foster Care
365,14400
385,144.00
- 365,14400
10000%
Fav due to budgeted amount not expected to be used.
Private Institutions Residential
105,356.00
105,356.00
- 105,356.00
100.00%
Fay. due to budgeted amount not expected to be used.
Radio Communications
975,000.00
(200,000.00)
(200,000.00) -
Reg2ntingProgram
49,245,389.00
41,945,38900 7,300,000.00
1482%
Fav due to use of CARES Act funds otil'¢ation for eligible
Salary Adjustment Reserve
500,000.OD
4,858,658.00
4,858,658.00 -
000%
Public Health and Public Safety personnel costs.
Speclal Projects
-
10,000,000.00
10,000,000.00 -
0.00%
State Institutions
604,971.00
604,971.00
604,971.DO -
0.0096
Substance Abuse Could Agency
4,787,165 DO
4,787,165.00
4,787,165.00 -
000%
59
Summer Employees Salary Appropriation
Supportive Services
Total
Transfers to Other Funds
Fire Records Management
CLEMIS
Redo Communications
Information Technology
Bldg Auth Fac Infras IT Debt
Project Work Order Fund
Building Fund
5211 District Court Probation Drug Court Grant
HR- Financial System Replacement Project
5213 District Court Probation Drug Court Grant
TOTAL NON-DEPT. APPROPRIATIONS
TRANSFER TO GENERAL PURPOSE FUNDS
Child Care Fund
Social Welfare Fund Faster Care
TOTAL EXPENDITURES
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
NON -DEPARTMENTAL EXPENDITURES
AMOUNT
ADOPTED
AMENDED FY 2021 FAVORABLE
BUDGET
BUDGET FORECAST (UNFAVORABLE)
250,00000
231,29600 231,296.OD -
29,849,847.00 19,849,847.00 10,000,000.00
$ 11,052,995.00
$ 102,406,715.00 $ 84,136,215.00 $ 18,270,500.00
$ 507,699.00 S 507.699.D0 507,699.00 -
1,644,18600 1,894,686.00 1,894,686.00 -
- 3, 061,480.D0 3,061,480.00 -
3,62D,676.00 4,954,17600 4,954,17600 -
2,209,750.00 2,209,75000 2,209,760.00 -
- 1,243,500.00 1,243,500.00 -
3,D00,00000 3,993,05200 3,993,052.00 -
9,405.00 9,405.00 -
- 5,200,000.00 5,200,000.00 -
- 7,478.OD 7.478.00 -
$ 10,982,311.00 $ 23,081,226.00 $ 23,081,226.00 $ -
$ 27,050,566.00 $ 164,546,517.00 $ 1",474,778.00 $ 16,071,739.00
$ 19,633,991.00 S 19,712,776.00 S 15,712,776.00 $ 4,OOD,000.00
1,000.00 1.000.D0 - 1,000.00
$ 19,534,991.00 $ 19,713,776.00 $ 15,712,776.00 $ 4,001,000.00
$ 46,585,557.00 $ 184,260,293.00 $ 164,187,554.00 $ 20,072,739.00
PERCENT EXPLANATION
0.00%
Fav due to use of CARES Act funds utilization for eligible
Public Health and Pubis Safety personnel costs.
17.84%
0.00%
0.00%
0.00%
000%
0.00%
0.00%
0.00%
0.00%
000%
o.DO%
0 DO%
9.77%
2029% Fay. due to less than anticipated amount needed forthe Child
Care Fund based on lower overall Child Care expenditures for
FY 2021
100 00%
20.30%
10.89 %
60
FY 2021 BUDGET AMENDMENTS
FY 2021 BUDGET AS ADOPTED - GENERAL FUNDIGENERAL PURPOSE FUNDS $ 457,508,892.00
BUDGETAMENDMENTS
M.R.#20447 10/2112020
BOC Tri-Party Road Improvement Program Fiscal Year 2021 Appropriation - Charter Township of Bloomfield -
Resurfacing of Maple Road from Inkster Road to Franklin Road - Protect No. 55341 $ 91,818.00
M.R.#20452 10/21/2020
BOC School Drinking Water Station Program - Fiscal Year 2021 Appropriation and Reallocation of County CARES Act
Coronavirus Relief Funds $ 600,000.00
M.R.#20457 10/21/2020
Sheriffs Office Contract Amendment #2 for Law Enforcement Services in the Charter Township of Lyon 2019-2021 $ (268,127.00)
M.R.#20458 10/2112020
Clerk/Register of Deeds- Delete and Create Positions $ 209,136.00
M.R.#20461 10121/2020
County Executive - Transfer and Create the Emergency Management and Homeland Security Department Under the
County Executive's Administration $ 31,026.00
M.R.#20462 10/2112020
Economic Development and Community Affairs - Reorganization of Divisions and Positions $ (42,809.00)
M.R.#20463 10/21/2020
County Executive - Acceptance of the County Executive Plan to Partner with the Community Foundation for Southeast
Michigan on a Community Policing Innovations Fund for Oakland County Communities $ 1,000,000.00
M.R.#20470 10121/2020
Board of Commissioners - Expedited Acceptance of Grant Award from the Center of Civic Tech and Civic Life (CTCL)
to Support County Preparation and Promotion of a Safe and Secure Election $ 157,907.00
M.R: 11/1912020
Board of Commissioners - Tri-Party Road Improvement Program (Planned Use of Fund Balance)
M.R. #20515 Charter Township of Bloomfield $ 70,424.00
M.R. #20516 Township of Groveland $ 57,924.00
M.R. #20517 Township of Waterford $ 121,424.00
M.R. #20518 Township of Lyon $ 140,167.00
M.R.#20523 11119/2020
Central Services Fleet Expansion of (1) Vehicle for Emergency Management and Homeland Security $ 3,276.00
M.R.#20526 11119/2020
Board of Commissioners Approval of Additional Appropriation for the 2020/2021 School Drinking Water Station
Program $ 60,000.00
M.R.#20557 11119/2020
HR - Water Resources Commissioner's Classifications Salary Adjustments $ 49,947.00
M.R.#20559 11/1912020
County Executive/Information Technology Public Safely Transparency Dashboard Project (CLEMIS) $ 250,500.00
M.R.#20564 11/19/2020
Prosecuting Attorney FY 2021 Crime Victim Rights Grant Acceptance $ (25,070.00)
M.R.#20567 11/19/2020
61
FY 2021 BUDGET AMENDMENTS
Sheriffs Office FY 2021 Joint Terrorism Task Force (JTTF) - Grant Acceptance $ 19,180.00
M.R.#20568 11/19/2020
Sheriffs Office- FY 2021 Oakland County Gang and Violent Crime Safe Streets Task Force (SSTF) - Grant
Acceptance $ 19,180.00
M.R.#20570 11/19/2020
Sheriffs Office - FY 2020 Bulletproof Vest Partnership (BVP) Program - Grant Acceptance $ 11,704.00
M.R.#20575 11/19/2020
Animal Shelter and Pet Adoption On-line Dog License Fee Schedule $ 8,500.00
M.R.#20577 11/19/2020
Economic Development and Community Affairs - United States Economic Development Administration (U.S. EDA)
CARES Act Recovery Assistance Acceptance $ 1,300,000 00
M.R.#20625 12/712020
County Executive Capital Improvement Program Study $ 325,000.00
M.R.#20632 1217/2020
Management & Budget/Human Resources Department /County Executive - Compliance Office - Financial and Human
Capital Management System Replacement Project Implementation Extension $ 5,200,000.00
M.R.#20635 121712020
Management & Budget FY 2020 Year End Report and Budget Amendments
Encumbrances $ 571,910.21
Carry Forwards $ 14,074,942.00
Adjustments to Circuit Court $ 8,000.00
Adjustments to Children's Village $ 45,662.00
Adjustments to Health Division $ 31,143.00
Adjustments to Non -Departmental $ 127,533,618.00
$ 142,265,275.21
M.R.#20638 12/7/2020
Board of Commissioners - Reorganization of Units and Positions
$ (35,060.00)
M.R.#20369 12/7/2020
Health and Human Services/Health Division - Continuations of the Oakland Together School Nurse Program in
Partnership with Oakland Schools
$ 1,495,117.00
M.R.#20647 12/7/2020
Sheriffs Office - Contract Amendment #2 for Law Enforcement Services in the Charter Township of Highland 2019 -20, $ 104,902.00
M.R.#20648 12/712020
Sheriffs Office - Contract Amendment #3 for Law Enforcement Services in the Charter Township of Lyon 2019 -2021
$ 109,418.00
M.R.#20649 1217/2020
Sheriffs Office - Contract Amendment #2 for Law Enforcement Services in the Charter Township of Orion 2019 -2021 $ 99,522.00
M.R.#20653 121712020
Sheriffs Office - 2020 Law Enforcement Services Agreement with the Somerset Collection LP $ 2,862.00
M.R.#20582 12/7/2020
Board of Commissioners - Authorization of a Forensic Audit of Management of County Property Tax Foreclosures $ 937,500.00
M.R.#20661 12/712020
62
FY 2021 BUDGET AMENDMENTS
County Executive - Approval of a Request for Proposal to Enter Into Professional Services Contracts for Strategic
Planning and an Equity Audit to Improve County Government Services $ 1,330,000.00
M.R.#20664 12/712020
Board of Commissioners — Reallocation of Coronavirus Relief Funds to Create Oakland Together Restaurant Rescue
Program $ 3,000,000.00
M.R.#21016 121712020
Sheriffs Office - Contract Amendment #2 for Law Enforcement Services in the Charter Township of Oxford 2019 -
2021 $ 94,143.00
M.R.-2/0412021
Board of Commissioners - Tri-Party Road Improvement Program (Planned Use of Fund Balance)
M.R. #21025 Charter Township of West Bloomfield $ 82,548.00
M.R. #21026 Charter Township of Oxford $ 27,062.00
M.R.#21033 214/2021
County Executive Acceptance of the Michigan Department of Treasury Public Safety and Public Health Payroll
Reimbursement Program Additional Grant Acceptance $ 307,589.00
M.R. #21036 21412021 $ 10,000,000.00
Health and Human Services/Emergency Management and Homeland Security - 2021 Oakland Together Pandemic
Response Initiative and Ad Hoc Committee
M.R.#21040 2/1812021
Board of Commissioners - Tri-Party Road Improvement Program Fiscal Year 2021 Appropriation - City of Auburn Hills -
Traffic Signal Upgrade Work and Installation of a Pedestrian Crossing on Baldwim Road Adjacent to Great Lakes $ 31,161.00
M.R. #21049 2/1812021
Sheriffs Office - FY 2021 Traffic Safety Enforcement - Grant Acceptance $ 38,000.00
M.R.#21052 2/1812021
Facilities Management - Facilities Maintenance and Operatons/Prosecutor's Office - Various Prosecutor's Office
Upgrades Project $ 250,000.00
M.R.#21057 3/11/2021
Board of Commissioners - Partial Funding for Demolition of the Former Electro-plating Services Company Buildings
Located at 901-959 East 10 Mile road in the City of Madison Heights $ 150,000.00
M.R.#21058 3/11/2021
Board of Commissioners - Tri-Party Road Improvement Program (Planned Use of Fund Balance)
M.R. #21058 Charter Township of Bloomfield $ 103,645.00
M.R.#21060 3/11/2021
Facilities Management - Facilities Planning and Engineering/Sheriffs Office - Approval of Lease Agreement for
Expanded Use of Training Center Building $ 90,000.00
M.R.#21068 3/11/2021
Human Resources — Fiscal Year 2020 Wage Reopener for Employees Represented by the Governmental Employees
Labor Councel (GELC) $ 95,885.00
M.R.#21081 3/11/2021
Information Technology - Approval of Public Safety Communications First Responder GPS Safety Channel and
Governmental (Non -First Responder) Radios $ 1,886,480.00
63
FY 2021 BUDGET AMENDMENTS
M.R.#21082 3111/2021
Information Technology - Approval of Public Safety Communications System Countywide Public Safety Answering
Point Voice -Data -Audio Recording/Archive System
$ 1,333,500.00
M.R.#21056 3/11/2021
Board of Commissioners - Improve Access and Provide Express Delivery of Death Certificates Issued by the Oakland
County Clerk's Office to Funeral Homes
$ 50,DDD.00
M.R: 3/25/2021
Board of Commissioners - Tri-Party Road Improvement Program (Planned Use of Fund Balance)
M.R. #21085 Charter Township of Milford
$ 6,219.00
M.R. #21086 Charter Township of White Lake
$ 59,326.00
M.R.#21091.0312512021
Management & Budget FY 2021 First Quarter Report
Adjustments to Health $ (83,283.00)
Adjustments to Child Care Fund $ 25.00
Adjustments to Sheriffs Office $ 28,139.00
Adjustments to Public Services - Animal Control $ 385,020.00
Adjustments to Non -Departmental $ 50,000.00
$ 379,901.00
M.R.#21096 3/26/2021
Human Resources - Fiscal Year 2020 Wage Reopener for Employees Represented by the Michigan American
Federation of State, County, Municipal Employees, Council 25, Local 2437 (AFSCME)
$ 5,181.00
M.R.#21101 3/2512021
Sheriffs Office - Establishment of Dispatch Services Agreement Rates - April 1, 2021 through March 31, 2024 $ 212.411.0D
M.R.#21131 3/2612021
Facilities Management/Facilities Planning and Engineering - County Executive - Campus Sustainability Planning
Project $ 625,500.00
TOTAL AMENDED BUDGET AS OF 3/31/2021 $ 632,038,086.21
64
GRANTS ACCEPTED $10,000 AND UNDER
(approved administratively, per M.R. #19006)
(Department or Division (Grant Title i Award/Amendment (Quarter included (QTR/FY;
Sheriffs Office 2021 Drug Recognition Expert (DRE) Call Out Reimbusement Agreement less than $10,000 Q2/FY21
Central Services / Aviation 2021 Oakland County Contract for Aircraft Rescue and Fire Fighting (ARFF) Training $ 2,000.00 Q2/FY21
65
ADOPTED AMENDED
BUDGET BUDGET
DELINQUENT TAX REVOLVING FUND 51600
REVENUES
Charges for Services $10,600,OOD.00 $10,600,O0O.DO
Other Revenues
Total Revenues
OPERATING EXPENSES
Personnel Expenditures
Operating Expenditures
2,000,00000 2,000,OOO.DO
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
ENTERPRISE FUND
TREASURER'S OFFICE
FY 2021
FORECAST
1D,600,000.00 $
2,000,000.00
$12,600,OOD 00 $12,600,000.DO $12,600,00000 $
$ 221,263.00 $ 221,263.00 $ 200,263.00
394,55500 394,555,00 264,555.00
VARIANCE
FAV/(UNFAV)
21,000.00
130,000,00
Interest Expense
943,750.00
943,750.00
D-DO 943,750 OD
Transfer Out to Other Funds.
General Fund -Collection Fees
2,300,000.00
2,300,00000
2,300,000.00 -
GF- Non -Departmental
3,000,000.00
3,000,000.00
3,OOD,OD0.00 -
Work Release Facility Refunding Debt Svc
1,566,300.00
1,566,300.00
1,566,300.00 -
Office Bldg Renovation Refunding Debt Svc
11866,400 00
1,866,400.00
1,866,400.00
52-3 District Court Refunding Debt Svc
1,311,300.00
1 311.300 00
1,311,300.00
Total Transfer Out to Other Funds
8 10.D44 ODO.OD
$ 7 D. D44.00D DO
$ 10 044 D00.00 5
Total Operating Expenses
$ 11,603,568.00
$ 11,603,568.OD
$ 10,50S818.00 $ 1,094,750.00
REVENUE OVER (UNDER)
EXPENDITURES*
$996,432.00
$996,43200
$2,091,182.00 $1,094,750.00
Total Net Position - Beginning
$205,648, 448.12
Total Net Position - Ending
$207,739,230.12
Ending FY 2020 Designated Net Position`":
NP-UnRes - Designated - Debt Service
$57.877,280.00
NP-UnRes - Designated - Delinq Taxes Receivable
141,885,395.57
NP-UnRes - Designated - Collection Fees
5,882,372.56
Undesignated - Net Position
$2 091 162.00
Total Net Position - Ending
$207.739.230.12
Please note that in the Adopted Budget (line -item book) this is budgeted as 'Planned Use of Balance" in the revenue category
'* Please note the designated equity amounts are adjusted at year-end only
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
000%
0.00 %
000%
9.49% Fay. Salaries and Fringe Benefits based on actual activity
32 95% Fay. Professional Services $50,000, Adminstrative Overhead
$30,000, Legal Services S25,OOO.Professional Services - Financial
Consultant $25,000 due to less than anticipated use due to COVID-
19.
100 DO% Fay. Interest Expense as no borrowing will occur in FY 2021 due to
COVID-19
0.00%
000%
0 DO%
000%
000%
D.OD%
9A3%
66
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
ENTERPRISE FUNDS
TREASURER
ADOPTED AMENDED FY 2021 VARIANCE
BUDGET BUDGET FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
DELINQUENT PERSONAL PROPERTY
TAX (51800)
OPERATING REVENUE $508,689.00 $508,689 00 $408,689.00 ($100,000.00) -19.66 % Unfay. Administration Fees ($100,000) due to decreased collection
fees due to COVID-19 pandemic resulting in unopened businesses
OPERATING EXPENSE 513,689.00 513,689 00 399,689.00 $114,ODO.00 22A 9% Fay. Controllable Personnel $110,O00 due to vacant and underflled
positions. Also fay. Metered Postage $4,000 due to less than
anticipated use.
NET OPERATING INCOME (LOSS)
($5,00000)
($5,000.00)
$9,000.00
$000 0,00%
NON -OPERATING REVENUE (EXPENSE)
5.000.00
5,00.00
$5,OOD.00
$0.00 0.00%
TOTAL INCOME BEFORE
CONTRIBUTIONS AND TRANSFERS
$0.O0
$0.00
$ 14,000.00
$0.00
TRANSFERS OUT
-
-
-
-
TOTAL NET INCOME (LOSS)-
$0.00
$0.00
$14,000.00
$0.00
TOTAL NET POSITION - BEGINNING
900,560.96
TOTAL NET POSITION - ENDING
$914.560.96
`Please note that in the Adopted Budget (line -item
book) this is budgeted
as "Planned use of Fund Balance" in the revenue category or Budgeted Equity Adjustment in Expenses.
67
COUNTY OF OAKLAND
FY2021 SECOND QUARTER REPORT
ENTERPRISE FUND
PARKS & RECREATION
ADOPTED AMENDED FY 2021 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT
OAKIAND COUNTY PARKS & RECREATION COMMISSION
(50800)
OPERATING REVENUE $ 10,903,416.00 $ 1D,9D3,416.00 $ 10,903,416.00 $ - D.DD%
EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING EXPENSE
$ 28,082.762-00 $ 33,490.604.OD
$
29A75.574.1)D
$ 4,315,03D.00
12.88% Fay. Budgeted Equity Adjustments $4 315 DOD 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. Untav, Adj Prior Years
Revenue ($4,671) for repair of a tracer wire and duct cut by a vendor while
digging up a leafy tree at Addison Oaks. A budget amendment is
recommended.
NET OPERATING INCOME (LOSS)
$ (17,179,346.DD) $ (22,587,188,00)
$
(18,272,1$8.00)
$ 4,315,03000
19.10%
NON -OPERATING REVENUE (EXPENSE)
$ 14,568,300.00 $ 22,587,188.00
S
22,4B3,988.00
$ (103,200 00)
-0 46 % Unta, Accrued Interest Adjustments ($20,000) and Unfay. Income from
Investments ($62,000) due to decreased interest rates and assoOated
investment losses. Partially offset by fay. Capital Asset Contributions
$46,675 (capital improvement project #2915 to record $32,000 land donation
per MR#20180, and capital improvement project#2532 Springfield Oaks
water quality improvments to recognize capital donation, $14,675). A budget
amendment is recommended.
TOTAL INCOME BEFORE TRANSFERS
$ (2,611,046.00) $ -
$
4,211,830.00
$ 4,211,830.00
0.00%
TRANSFERSIN
$ _ $ -
$
_
$ _
TOTAL NET INCOME/PLANNED USE OF BALANCE (LOSS)-
$ (2,611,04600) $ -
$
4,211,830.00
$ 4211,830.00
TOTAL NET POSITION - BEGINNING
$
85.206.32382
TOTAL NET POSTION- ENDING
$
89.418.153.82
'Please note that in the Adopted Budget (Imritem book) this is budgeted as "Planned use of Fund Balance" in the revenue category or Budgeted Equity Adjustment in Expenses
68
1��f FUND 1639001
DRaN EQUIPMENT
�NUE5.
OPERATING RF
inside
Outsde
Total Revenue
OPERATING EXPENSES
COUNTY OF OAI(L'N REPO
RT
Fy 202t SEOOND O Rt+ICE FUND
INTER ��ftCES O�MiS51ONER
WpTERRES
AMENDED
ADOPTED BUDGET
4624"24000
45 935 050 00
VPRIPT1�E PEROENI
2021 FAVI(UNPAVI --�-"`
1880600.001
45.384240
25010000
250 i00.00
(esa o00 00l
25010o p0
45 614 340 00 $1 009 543.00
46 $q7 g59,6g0p0
46 448 569.223 r)0
$48,561?42.00
4S 340 �0)
152:<
($237488300)
ISZ 376 383 001
NEf INCOWE LOSSI 600RF
� V pwppGES
�PDpNpT1ON Of slGM�i�-,,.,---r
ll
OOD,000leu�5es
aa Qse amy Ftn9out
nt Salares (S sitions otfs estrmekI f billet, louts
R(,,,d 00 000 due to under med Y a mcr o maso n
Untav . Raimbu(se and vacant P° is det "es, Parfa'n,n9
cnao9 E 1Pmend?' to $20,OD0 fevvorebl, S%ps
Fa - Retirlle yC boos, ote,905tso u^�
reb9leble rep
rePat(1°bs
and as ent
�0 000 due ro turnover toonto
e
Fav - Salaries a D� ecratwn C qu S on kSGPt) sC �g°m4 P roue 10
SD 13, t
2 p1°7°one s, Fav - d Data t Fav . tndu Ut tav . Refu^ 5ement
ent
Pr ec�ory being
n l,Is
.d 9"0' Oom dueatimgeting 0 CeinS TTes°acn,�aMawa9 mem
Sups tnotbern9
4.
09
Yea ft 2020 but e(sAoleTel on elation 9es jet
SIN' Revenue n c ar ost
i(om 000) a result etbV {avorable tna result of des trnent poor
Pg40, (CPN1pl, oifs Sery ces -'No vs Su'Wm9O,o✓.vd 5wcatrl Y 702,13 to d
En9inee(tn the Public .ractin9 slate ticipsla
Ilnfav - n v,%l li, g001 due to °coo a ineof un 30001
to rrect mo P res of un2 $
fYaaEYhe o?"Itin9 umentReParr 1��t �nfav - le9Vt gt,oP suppliesdio,,d9at.
iuniav eD °n aglN fo�repa mvorces. Uofa nc+patedbu
invoice Untav EQ0�o oeel sPand n9
in9 S. fna^ an
reParrs of a colic
result ofa
g129 54' 00
-5A5°1°
69
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
INTERNAL SERVICE FUND -
WATER RESOURCES COMMISSIONER
ADOPTED AMENDED FY 2021 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV)
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
NON -OPERATING REVENUE/(EXPENSE; $314,600.00 $314,600.00 $341,600.00 $27,000.00
8.58% Fav - Refund Prior Years Expenditure $52,000 due to timing of Cares Act
reimbursement funding received for labor costs requiring an allocation to
various systems. Also, a correction for purchases charged as expenses
that should have been booked as inventory. Fav - Gain On Sale Of
Equipment $10,000 due to equipment being sold at the Oakland County
auction. Unfav - Income from Investment ($35,000) due to investment
base and market rate Fluctuations.
TRANSFER IN 15,000.00 190,000.00 $190,000.00 - 000%
TRANSFERS (OUT) 160,34200 278,3850D 278,385.00 - 000%
NET REVENUES OVER (UNDER) ($2,207,125.00) ($2,148,668.00) ($1,992,125.00) $156,54300
EXPENSES' _
TOTAL NET POSITION -BEGINNING $ 29,418,21829
TOTAL NET POSITION - ENDING $ 27,426,09329
'Please note that in the Adopted Budget (Ime-item book) this is budgeted as "Planned use of Fund Balance' in the revenue category or Budgeted Equity Adjustment in Expenses
70
PLIABILITY INSURANCE FUND 67700
OPERATING REVENUES:
Outside Revenue
Inside Revenue
Total Operating Revenue
OPERATING EXPENSE
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
INTERNAL SERVICE FUND
RISK MANAGEMENT
ADOPTED AMENDED FY 2021 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 11846.00 $ 11.846.00 $ 11,846.OD $
5,105,824.00 5,105,82400 5,151,124.00
- 0.00%
45,30000 0.89% - Fav Prior Years Revenue due to reimbursement
from Water Resources Commissioner for claims
$5,117,670.00 55,117,670.00 $ 5,162,97D 00 $ 45.300.OD 0-89%
$ 4,6B9,019.00 $ 4,589,019.00 $ 4,761 019 00 $ (72,DOO OD) -1 54% - Unfay. Info Tech Development due to higher than
anticipated actuals after completion of budget
CLAIMS PAID
1,775,500 00
1,775,500 00
2,601,981.00
(826,481.00)-46.55% - Unfay. due to average estimated year-end actuary
adjustment partially offset by favorable claims.
TOTAL OPERATING EXPENSES
$ 6,464,519 DO
S 6,464,519 00
$ 7,363,000 00
$ (898,481.00)-13,90%
OPERATING INCOME (LOSS)
(1,346,84900)
(1,346,84900)
(2,200,030.00)
(853,181.00) 63.35%
NON -OPERATING REVENUE (EXPENSE)
150,ODO.DO
150,000.D0
100,000.00
(50,000.00)-33.33%
- Unfav due to lower than expected available cash
balance
TRANSFER IWOUT
0 00
(113,385.00)
(113,386.00)
- 0 Di
NET REVENUES OVER/(UNDER)*
EXPENSES $0,196,849.00) $(1,310.234.00) (2,213,415.00) $ (903,181.00)
TOTAL NETASSETS- BEGINNING 55.419.74
TOTAL NET ASSETS - ENDING $ (2157,995.26)
'Please note that In the Muffed Butl9et (Ime-,tai book) this is budgeted as "Planned use of Fund Balance" in this revenue category et BUJgdetl Equity Atlryshnent in Evpanees
71
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
ADOPTED
AMENDED
FY 2021
VARIANCE
I FRINGE BENEFITS FUND 67800
BUDGET
^- ` F
BUDGET
'
FORECAST
FAV/(UNFAV)
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING REVENUE
RETIREES MEDICAL -VEBA DEBT
33,999,000
33,999,000
33,999,OOD
-
0.00%
RETIREMENT ADMINISTRATION
3,122,532
3,122,532
3,091.600
(30,93200)
-099%- Unfav due to projected revenues less than budget projections.
RETIREMENT ADMINISTRATION -PTNE
350.D00
350,000
168,800
(181,200.00)
-5177%-Unfav due to projected revenues less than budget projections.
DEFERRED COMPENSATION -MATCH
2,500,000
2,500,000
2,500,000
-
D.00%
DEFINED CONTRIBUTION PLAN
19,500,000
19.500,OOD
21,465,600
1,965,600.00
10 08% - Fay. due to projected revenues more than budget projections.
DEFINED CONTRIBUTION PLAN - PTNE
220,500
220,500
168,90D
(51,6DO.00)
-23.40% - Unfav due to projected revenues less than budget projections.
EMPLOYEE IN-SERVICE TRAINING
1,523,416
1,523,416
1,523,416
-
0.00%
EMPLOYEE BENEFITS UNIT
1,188,941
1,186,941
1,188,941
-
a00%
EMPLOYEE RECOGNITION
354,289
354,289
354,289
-
0 00%
FLEX BENEFIT PLAN
85,5D0
85,500
85,5DO
-
000%
WELLNESS UNIT
595,783
595,783
595,783
-
0.00%
FRINGE BENEFITS
120,903
120.903
120T903
-
0.00%
TUITION REIMBURSEMENT
350,000
350,000
350,D00
-
0.00%
RETIREMENT HEALTH SAVINGS
4,500,000
4,500,ODO
4,306,000
(194,OOO.1)(3)
-4.31 % - Unfav due to projected revenues less than budget projections Partially offset by
favorable Retirement Health Savings expense
GROUP LIFE INSURANCE
545,000
545,000
499,800
(45200.00)
-8 29 % - Unfay. due to projected revenues less than budget projections.
SOCIAL SECURITY
19,833,000
19,833,000
19,582,400
(250,600.00)
-1 26 % - Unfay. due to projected revenues less than budget projections.
MEDICAL INSURANCE
34,677,000
34,677,000
31,006,000
(3,671,000.00)
-10.59% - Unfay. due to projected revenues less than budget projections, partially offset by
Medical Insurance expense.
PRESCRIPTION COVERAGE INSURANCE
12,ODO,000
12,000,000
11,OD0,000
(1.D00,000.00)
-8.33% - Unfav due to projected revenues less than budget projections.
DENTAL INSURANCE
3,276,500
3,278,500
3,672,600
394,100.00
12.02 % - Fay. due to projected revenues more than budget projections
VISION INSURANCE
252,500
252,500
333,400
80,900.00
32 D4 % - Fav due to projected revenues more than budget projections, partially offset by Vision
Insurance expense.
DISABILITY INSURANCE
3,750,ODO
3,750,000
3,537,000
(213,000.00)
-568% - Unfay. due to projected revenues less than budget projections.
WORKERS COMPENSATION
3,283,921
3,283,921
2,385,900
(898,021.00)
-27 35% - Unfay. due to projected revenues less than budget projections.
UNEMPLOYMENT COMPENSATION
300,000
300,D00
262,200
(37,13D(3.00)
-12.60% - Unfav due to projected revenues less than budget projections. Partially offset by
favorable Unemployment Compensation expense
INVESTMENT INCOME
1,500,000
1,500,000
1,000.000
(500,000.DO)
-33.33% - Unfav, due to projected revenues less than budget projections
EXT- DENTAL INSURANCE
15,D00
15,000
15,000
-
000%
EXT - FLEX BEN ARREARAGES
-
-
-
-
EXT- FLEX BEN DENTAL INSURANCE
6,5D0
6,500
151,ODO
144,500.00
2223 08 % - Fav due to projected revenues more than budget projections.
EXT- FLEX BEN LIFE INSURANCE
455,OD0
455,000
455,000
-
000%
EXT- FLEX BEN MEDICAL - EMPLOYEE
5333,000
5,333,000
5,333,000
-
0.00%
EXT- FLEX BEN VISION INSURANCE
6,000
6,000
143,000
137,ODO.00
2283.33% - Fay. due to projected revenues more than budget projections.
EXT- MEDICAL INSURANCE
180,00D
180,000
180,000
-
0.00%
EXT-OTHER REVENUE
-
-
'
EXT -PRESCRIPTION DRUG REBATES
1,500,000
1,500,000
2,550.D00
1,050,000.00
70 00% - Fav due to projected revenues more than budget projections.
EXT-TRAINING
10,000
10,000
10,000
-
000%
EXT- VISION INSURANCE
1,500
1,500
1,500
-
000%
EXT- WELLNESS REVENUE
10,000
10,000
10.ODO
-
0.00%
PRIOR YEAR ADJUSTMENT
-
-
377,200
377,200.00
000% - Fay. due to projected revenues more than budget projections
TOTAL REVENUE
155,347,785
155,347,785
152,423,732
(2,924,053.00)
-1.88%
OPERATING EXPENSE
RETIREES MEDICAL-VEBA DEBT INT/AGING
7,394,D00
7,394,000
7,394,000
-
000%
RETIREMENT ADMINISTRATION
1,189,295
1,196,495
1,151,495
45,000.00
376%- Fav due to Legal Services$75,000 less than projected budget and Ovetme($30,000)
due to Workday project
72
FRINGE BENEFITS FUND 67800
DEFERRED COMP -COUNTY EMITS (MATCH)
DEFINED CONTRIBUTION PLAN
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
ADOPTED AMENDED FY 2021 VARIANCE
I BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
2,500,000 2,500,000 2,500,000 - 0.00%
19,500.D00 19,500,000 22,300,000 (2,800,OD(0.00)-14.36% - Unfay. due to projected costs more than budget projection - increase In new hires who
participate In the Defned Contribution Plan, partially offset by favorable Defined
Contribution Plan revenue
DEFINED CONTRIBUTION PLAN - PTNE
220,500
220,500
220,500
EMPLOYEE IN-SERVICE TRAINING
1,212,196
1,193,253
1,013,165 180.D88.00
IN-SERVICE TRAINING - INFO TECH
275,000
275,000
275,000 -
PROFESSIONAL SERVICES
40,500
40,500
40,500
BENEFITS ADMINISTRATION
226,599
226,599
226,599 -
EMPLOYEE BENEFITS UNIT
1,079,941
1,079,941
1,029,941 50,000.00
FLEXIBLE BENEFIT PAYMENTS
85,5D0
85,500
85,500 -
WELLNESS PROGRAM
596,552
596,552
441,977 154,575.00
EMPLOYEE RECOGNITION
355,790
355,790
243,418
112,372.OD
31,58%
ACCOUNTING SERVICES
121,714
121,714
121,714
-
0.00%
TUITION REIMBURSEMENT
350,000
350,OD0
260,000
90,000.00
2571%
RETIREMENT HEALTH SAVINGS
4,5DO,D00
4,500,OD0
4,276,OOD
224,000.00
498%
GROUP LIFE INSURANCE
1,000,OD0
1.000,000
1,000,000
-
0.00%
SICK AND ANNUAL LEAVE CASH -OUT
21175,OD0
2,175,000
3,300,000
(1,125,000.00)
-5172%
SOCIAL SECURITY
19,833,000
19,833,000
20,645,ODO
(812,DOO.OD)
-409%
MEDICAL INSURANCE
47,625,000
47,625,D00
47.600,OD0
25,000.00
D 05%
PRESCRIPTION COVERAGE
13,500,OOD
13,500,000
13,700,000
(200,000.00)
-1.48%
DENTAL INSURANCE
3,300,DOD
3,300,000
3,3DO,000
-
000%
VISION INSURANCE
260,000
260,000
302,000
(42,0(30.00)
-16.15%
DISABILITY INSURANCE
3,750,000
3,750,000
3,75D.D00
-
WORKERS COMPENSATION
3,285,928
3,285,928
3,503,286
(217,358.DD)
UNEMPLOYMENT COMPENSATION
300,000
300,000
150,000
150,000.00
CHILD CARE FACILITY
229,991
229,991
309,043
(79,052.00)
HEALTH INSURANCE PREMIUM TAX
25,000
25,000
25,000
-
MICHIGANIPAATAX
18,D00
18,000
18-000
-
PATIENT CENTERED OUTCOME RESEARCH
22,OD0
22,000
22.D00
-
INDIRECTCOSTS
240,DD0
240,000
336,000
(96,000.00)
TOTAL EXPENSE
135,211,5D6
135,199,763
139,54D,138
14,340,375 DD)
NET REVENUE OVER/(UNDER) EXPENSES 20,136,279.00 20,148,022.00 12,883,594 (7,264,428.00)
TOTAL NET ASSETS -BEGINNING
TOTAL NET ASSETS - ENDING
210 488,589
223,372,183
0 00%
15,09 % - Fay. due to lower than projected training costs.
0.00%
0.00%
0.00%
4.63 % - Fav due to lower than projected Professional Services.
0.00%
25 91% - Fay. due to lower than projected Professional Services $129,500 and Special Event
Program $25,000
Fay. Personnel due to vacant position within Employee Recognition Unit
Fay. due to lower than projected tuition costs.
Fav due to the use of Rebree Health Saving forfeitures held by Pmdenbal used to
offset current expenses, partially offset by Retirement Health Savings revenue.
Unfay. due to projected Sick and Annual Leave Cash -Out more than budget
projections. Also, attributable to VESIP and vacation rash outs.
Unfav due to projected Social Security expense more than budget projections.
Fay. due to projected medical expenses less than budget projections.
Unfav due to projected expenses more than budget projections.
Unfav due to projected expenses more than budget projections. Partially offset by
favorable Vision Insurance revenue.
0.00% -
-661% - Unfay.due to Professional Services for Workers Compensation Service Fees
($317,600) higher than budget projections and ($41,945) for expenses received after
fiscal year end close. Partially offset by Insurance $83,500 for policy lower than
budgeted and Personnel and Fringe $58,737 due to vacant position within Risk
Management
50.00% - Fay. due to credits given by the Michigan Umemployment Insurance Agency ILIA) due
to COVID-19, partially offset by Unemployment Compensation revenue.
-34.37% - Unfav due to pandemic response to COVID-19
0.00%
0.00%
0.0090
-40.DO % - Unfay. due to actual charges developed after budget finalization
-3.21%
'Please note that in the Adopted Budget (line -item book) this is budgeted as "Budgeted Equity Adjustmenf m the expense category
Note: The Fringe Benefit Fund is responsible for the Rates Healthcare Debt The Principal and interest payments are included in the fringe benefit rate but the pnnapal portion is required to be accounted for through a liability
account versus an expense account The FY 2021 principal amount is $26,605, 000
73
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
ENTERPRISE FUNDS
CENTRAL SERVICES
ADOPTED AMENDED FY 2021 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT
(OAKLAND COUNTY INTERNATIONAL
AIRPORT (56500)
OPERATING REVENUE $4,772,155 00 $4,772,155.00 $4,768,355,D0 ($3,8D0.00)
OPERATING EXPENSE
7,319,400.00
7,319.400.D0
7,069,40000 250,000.00
NET OPERATING INCOME (LOSS)
(2,547.245.00)
(2,547,245.00)
($2,301,045.00) 246,200.00
NON -OPERATING REVENUE (EXPENSE)
302,400.00
302,400.00
302,400 00 -
TOTAL INCOME BEFORE
CONTRIBUTIONS AND TRANSFERS
($2,244,845.00)
($2,244.545.DD)
S (1,998,64500) $246,2D000
TRANSFERSIN
-
-
-
TRANSFERS OUT
-
(75,000.00)
(75,D00.00)
CAPITAL CONTRIBUTION
-
-
- -
EXPLANATION OF SIGNIFICANT VARIANCES
-0.08% - Unfay. U.S Customs Reimbursement ($88,000) due to restricted
international travel due to COVID, along with an increase in inspector rates
offset by a reduction in one Customs agent in July Partially offset by an
favorable increase in Car Rentals $45,800 and Landing Fees $3B,400
-10.97%
TOTAL NET INCOME (LOSS) ($2,244,845.00) ($2319845.00) $ (2,073,645.00) $246,2D0.00
TOTAL NET ASSETS -BEGINNING $ B0,387,344.61
TOTAL NET ASSETS -ENDING $ 78,313,699.61
'Please note that in the Adopted Budget (line-dem book) this is budgeted as "Planned use of Fund Balance" in the revenue category or Budgeted Equity Adjustment in Expenses
74
)MOTOR POOL FUND 66100
OPERATING REVENUE:
Outside Revenue
Inside Revenue
Total Revenue
OPERATING EXPENSE
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER FORECAST
INTERNAL SERVICE FUNDS
CENTRAL SERVICES
ADOPTED AMENDED FY 2021 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT
$ 145,000,00 $ 145,000,00 145,000,00 $ - 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
8,543,432.00 8,542,632.00 7,517,432.00 (1,025,200.00)-12.00% - Unfay. Gasoline, Oil & Grease Charges ($468,300) due to current fuel costs
(partia)ly offset by favorable Gasoline expense), Leased Equipment ($434,000) due
to actual activity trends to date, Productive Labor ($75,900) and Parts and
Accessories ($47,000) due to department owned vehicles repaired by third party.
8,688,432.00 8,687,632.00 7,662,432.00 (1.025,200.00)
9,283,224.00 9,282,024.00 8,721,724.00 560,300.00 6.04 % - Fay. Gasoline Charges $395,000 due to market fluctuations and miles driven (offset
by unfavorable Gasoline, Oil Grease Charges revenue), Indirect Costs $107,500
due to the development of actual charges after budget finalization, Sublet Repairs
$40,000 due to lower individual repair costs for vehicles sent out for the repair
(partially offset by Ext-Warranty Reimbursements), Insurance $25,800 due to less
than anticipated insurance costs and Insurance Fund $11,800 due to less than
anticipated insurance costs, partially offset by unfavorable Personnel ($19,800) due
to the timing of the Compensation Study, partially offset by less than anticipated
Hospitalization costs.
OPERATING INCOME (LOSS) (594,792.00) (594,392.00) (1,059,292 00) (464,900.00)
NON -OPERATING REVENUE 467,700.00 467,700.00 542,700.00 75,000.00 16.04°% - Fay. Income $75,000 due to higher than anticipated Gain on Sale of Vehicles
(EXPENSE)
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS (127,092.00) (126,692.00) (516,592.00) (389,900.00)
TRANSFERS IN / (OUT) 160,342.00 265,885 00 265,885.00 - 0.00%
CAPITAL CONTRIBUTIONS - - - -
NET REVENUE
OVER/(UNDER)EXPENSES
(PLANNED USE OF FUND
BAL.) - $ 33,250.00 $ 139,193.00 $ (250,707.00) $ (389,900,00)
TOTAL NET ASSETS - BEGINNING $ 11AB8.403.62
TOTAL NET ASSETS - ENDING $ 11,237,696.62
'Please note that in the Adopted Budget (line -item book) this is budgeted as "Planned use of Fund Balance" in the revenue category or Budgeted Equity Adjustment in Expenses
75
OAKLANO PORE Vwok
NOE
Ov of
FY 202N ERN SMRVIp Eta NT EXPEpNAStON OF StGN1F1GAN?,s_,..'` Oude
Ctt.RtES Y,,,.... ~•_.,,.- nbcrPated dside
FA V ARtUNF PER 'N...^^'�r.-'" due to m°" d sn itY µealth Ne
OE A Wp� FPV����..- ' Omet g""nue n s� rO,Ikand e "tMent sts.
p G reque
on arty
OP'�O ABUDGET� ^^ p0 41b°fo " P9e� e� Maintenan OePt Ghar9as baste O as °°m trod Pr9es
BVOGE�.r ZD 00D `OOHN1 nar1Ce to purcnasin9 nW yter & $ew due to \ower-
5D1 187 00 $ Nnfay. Marnte c, n
-,""".. 31001 Asp/° OO due wrote g5000 cvatro
3pD 0 ndld $2 nse
C $
~J 0,14
NA81,1g70p 12500000
p q1°!°
$ $ 11p5,pp0001 g,I 'Fay. NaiuSob eam
gg1187� 25031,6D50p p2° sources.
_ arlcet paces an
d On actual usa9e� 1e
m ewft
$ 7g200 550Dp 00 p 'se and Ben #
om FMSO e
s $125 �$025 p
FAOlOt2tES VENNES. 6p5 p0 $25532. co Fringe SuPPlies EaulPmed
move
e to fewer
pAaitrtena tam
T1NG RE e 00 251�37.792 00 51 2649p cost \httd-P 5 axles an Mateiral and 10 pandemra staff t° repot p due to a
OP Off'. e Revenu 5156 60 $25. $ 28'S 'mrirauves' .lC%Ons'. GOVID- Ialt $ al nt $a0 p0 l usage
tsrd $ 25 637 ? a OD $28 fi16,264 OD undertt\\ed aPs°a result of th esad use °f �vewP b d on actua
2861026 purcba0 is ase ecfaliy vehicle
d on mcre s: tntO S 5
inside R°venue enon
ue g $55 �Op mandfor seNrc°s•ROad
35 OOD a
T offal pENS -5
eGu'pment-n demand SuPP\%as l$5 � ma0b e �d Product
G tena %Oes PedOrmI 19 pan c department
OpERp,T1N and W `atoffset by una{edas{or 5eN°of the GOVue 1n°rease u 0¢s
Pncteasaa u5° °e atlons as aairsul$450 OOOa G Groundi tn9 stes ass
OountY u+rdes�; due to
SubletRePOO�10'1O P erat vwes tO set ups l$50 0001
Pncreiests as a r d °fna the ecdr°, Info TsCa nenance a\o o cfeas icCO1t
em
,hcrea �1D
c $ y p00we GOAD K�o�osid SuaPGe l�`errt a ua resu\t °f the
tg°in9 Putou c4 ses: Cust�uested by c
onm ease.
"'." ec"ning SeNwr product Price
'gve In" along
Pan
$ (40 0,001
t/ i8'200)
NET 14T\NG�R NS ER ORE $
OpE�
76
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
INTERNAL SERVICE FUND
FACILITIES MANAGEMENT
ADOPTED AMENDED
FY 2021 VARIANCE
BUDGET BUDGET
ACTUAL FAVI(UNFAV) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
NON -OPERATING REVENUE $ 100,000.00 $ 100,000.00
$
105,300.00 $ 5,300.00 5.30%
Fay. Income from Investments $15,000 based on the actual investment
income distributed to due to higher than anticipated rate of return on
investments. Partially offset by unfay. Accrued Interest Adjustments
($9.700) due to SymPro Investment Activity Accrued Interest based on each
funds average daily cash balance.
TRANSFERS IN $ - $ -
$
3.819.27 $ 3,819.27 0.00 %
Transfers In from Project Work Order Fund for closed Maintenance
Projects.
TRANSFERS OUT $ - $ (118,750.00)
$
(118,750.00) $ - 0.00%
NET REVENUES OVER(UNDER)
EXPENSES` $ (2,878,472.00) $ (2,997,222.00) $ (3,0211 $ (30 880.73)
TOTAL NET POSITION - BEGINNING $ 10,187,408.20
TOTAL NET POSITION - ENDING S 7159.30547
'Please note that in the Adopted Budget (line -Rem book) this is budgeted as "Planned use of Fund Balance" in the revenue category or Budgeted Egwry Adjustment in Expenses
77
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS I ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED
AMENDED
FY 2021 VARIANCE
BUDGET
BUDGET
FORECAST FAVAUNFAV) PERCENT
Information Technology - Operations (63600)
OPERATING REVENUES:
Outside $ 3,757,30600
$ 3,757306.00
$ 3,755,806-00 $ (1,500.00) -0.04%
nsitle 33,074,40200
33,093,236.00
$ 32,964,036.00 $ (129,200.00) -0.39%
TOTAL OPERATING REVENUE
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON -OPERATING REVENUE
TRANSFERSIN
TRANSFERS(OUT)
CAPITAL CONTRIBUTION
NET REV OVER(UNDER) EXP-
TOTAL NET POSITION - BEGINNING
TOTAL NET POSITION - ENDING
3 36,93170800 $ 36,850,542.00 $ 36,719,842.00 $ (130,700.00) -035%
48,443,043 $ 48,691,BT700 $ 46,438,77700 $ 2,253,100.00 4B3%
$ (11,611335.00) S (11,B41,33500) $
$ 70,50000 $ 70,500.00 $
$ 3,906,676.00 $ 3,906,676.00 5
S (7,634,15900) g (7,864,159.00) $
$
$
(9,718,935.00) $ 2,122,400.00
20,400.00 $ (50,100.00)
3,906,676.00 $ -
(517914859.00) $ 2,072,300.00
34,704,876.64
28,913 017.64
EXPLANATION OF SIGNIFICANT VARIANCES
Unfay. Outside Agencies ($14,200) due to reduction of customer activity and Fall
General ($200). Partially offset fay. by Sale of Equipment $12,900 due to the sale of
assets at the county auction
Unfay. OC Depts Operahons & Non Governmental Operations ($211,300) due to
increased rates and OC Depts Development Support & Non Governmental
Development $95,200 due to limited resources to complete development due to
vacancies. Unfay. Equipment Rental ($29,200) due to decreased rebills to departments
for maintenance charges on IT Office Equipment items and Freedom of Information Act
(FOIA) Fees ($2,400). Offset by fay Commission Contracts $18,600 for G2G
Marketplace.
Fay. Depreciation $4,097200 for IT capital projects in progress not fully operational;
Travel 556,100 due to travel restrictions as a result of the COVID-19 pandemic;
Contracted Services $30,000 due to decreased airwiily„ Printing $1,400, Freight $700
and Postage $600 due to usage. Also, Internal Services overall unfav of ($298,200) Is
primarily due to unfay. Maintenance Dept. Charges ($396.500) offset by fay. Insurance
Fund $60,600 and Telephone Communications $30,400 based on usage. The overall
favorabitity is pantally offset by unfav, Professional Services ($703,700) due to projects
previously approved in prior year; Parts and Accessories ($287 400). Software Rental
($340,700) due to higher than anticipated costs, Exp. Equipment ($243,900) for
equipment replacement: Overtime ($31.500) due to staff reduction, Employee Training
IT ($20,100) and Uncollectable Receivable ($7,200) due to uncolkctible charges for
Access Oakland
-17.92%
-71.06 % Unfay. Interest Income due to less than anticipated level of cash available for
0.00%
0.00%
).OD
'Pease note train the Adopted Budget (line -item book) this is budgeted as "Planned use of Fund Ralal in the revenue category or Budgeted Equity Adjustment in Expenses.
78
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS I ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2021 VARIANCE
BUDGET BUDGET FORECAST FAVIIUNFAVI PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Information Technology - Telephone Communications (67600)
OPERATING REVENUES:
Outside $ 12,000 00 $ 12,000.00 $ 7,800.00 $ (4,200.00)-35.00% Unfay. Sale of Phone External due to decreased usage of land lines
Inside 3,525,876 3,525,876 $ 3,450,376.00 $ (75,500.00) -214% Unfay. Sale of Phone Internal due to increased cell phone usage.
TOTAL OPERATING REVENUE $ 3,537,876.00 $ 3,537,876.00 $ 3,458,17600 S (79,70000) -2.25%
OPERATING EXPENSES $ 3,753,648 00 $ 3753.648.00 $ 5,379,048.00 S (1,625,400.00) 43.30% Unfay. Communications ($1,069,100) and Maintenance Equipment ($321,400) due to
higher than anticipated cost; Other Expendable Equipment ($88,700) for equipment
replacement, Indirect Cost ($44.900) due to actual charges being developed after
budget fnahzation; Internal Services ($52,20D) primarily due to Info Tech Operations
($21,200) and Telephone ($34,700) based on actual usage, Equipment Repairs and
Maintenance ($52,600) and Membership Dues ($1,300) due to costs being higher than
the budget projection. Fay.Travel $500 due to travel restrictions related to the COVID
19 Pandemic
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS $ (215,77200) $ (215,772.00) $ (1,920,872.00) S (1,705,100.00)
NON -OPERATING REVENUE $ 30,000 00 $ 30,000.00 $ 27,700.00 $ (2,300.00) -Z67% Unfay. Interest Income due to less than anticipated level of cash available for
investments
TRANSFERSIN
$ - $
- $
- $ - 0.00%
CAPITAL CONTRIBUTION
$ - $
- $
- $ - 0.00%
TRANSFERS(OUT)
$ - $
- S
- $ - 0.00%
NET REV OVER(UNDER) EXP-
$ (185,772.00) $
(185,77200) $
(1,893,172.00) 3 (1,707.400.00)
TOTAL NET POSITION - BEGINNING
3
2,463,351.31
TOTAL NET POSITION - ENDING
$
570,179.31
'Please note that m the Adopted Budget ([me -item book) this is budgeted as "Planned use of Fund Balance' in the revenue category or Budgeted Equity Adjustment in Expenses
79
PMENOEo
PtED �,
gU� $
EpptS 53`'p8 $ g15q?0100
Tab EN SG4 a7511p100
�aoon REV UE S
1p4ERp,T\NG
puts`de
\ns�de
TOP RPT N�EXPEN5E5 NUE
Oir
mikike
GOUOONDQ AREwf-l*, 15EFUN0
FY aOsr"..- POON�PEGNNOUOY
1N�R'NP1.tNFORNPr GE ERGENt
FpR\UNFP /
Ft 2021 1
R E� 820J°
$ 3� Epp fl0
5 t521o1 00
A 86�
\7a 20p 001
1 a5$'155Ao
$
R/PNGES
\pG
OF sGN cess Foes
EXPt P� ', W
FjtemaP$1,Oe-S5405
ees� kand�? 9 rrM1e �ar9as dt o�0o
AS�
Fay. \nOa ti
\ ytOn ; Y9 Egdii� U-pied act $1 9p eCI.eEM\� Q y $o ceased
t'1°n roan`ent FuN,9hc" than Gnme �9PPOak\and a9 �C$5,0 sand
2p0 Gdabon$1a9aktano anP9 sand Aaessor n9S t\ff PrO''ant.
G\.EMll Ss se$l7570o1 and resrn`r sup suPP° � n`9nec
m
mG`EM\S Grashl � due to statEs fa Gl�M\S nrc`�c'Patyd GlE
Mtg sta
actMt'!. a Fees l`a96 ed on ecru 0� to Pa
av80 don
Utryav SeNrC \l$F1CaT�°adons$30\PF$600-
R,mattY obort OG fleets F ema\ SeN` 100 S°r
bua e\Proles POttIn She resauon sah 9duFxP lg,,n duet° `n c$o�dectea�`'ed
resoai°a- deP to usa9 a5ed on srde,ruc.
1521955p0 � 509`b
1 r,2T g55A0 $ 320200.00 129 /o
66p56�0o 1�p0000
5 $
8 y 85 656 00 11189 ,1 p2 p 0
$ $
6285856 00 11943702 00
S¢. N 69320200 $ -
MGOMETRN'15FERS RE
N P�p,TtNO ENUE
l5 a01.`-✓kb �0� 35 pp0 00
35,
1,89a 0' 00
/ 47420000
C51838a6.W) $ 11 A00 DOl
33600.00
18�g686.00 r
$
$ SOD oe
a72.
aVonSd e'�b9a�y\oPn`�es 4104��s\atedtoOh�Ohe�nanP e
Fay.�00 Pnma`l ernerrt=Reb`naes,SottWar StR"G1'$1T54p01 duacos9$81?001 du to
$e9� PmeTrer 25 and25100 ddue � 1 SSN� N cas and lndIv
�sto�Trove U�yv. Prole � saN+n9 �a\¢au°n
astoa\Y o5$°cbYasual casta+tec bud9s
Pa area con tenni�d
a��1al Gnerg°s as � aver\ab\e
for
lntecest \ncome due to \esstnan anncosed\svel of `�
Untav ass.
Apo°!o rnvestm
O T\NO
NON-OPERP $ t 64a, $ $ y5 y69 001 s en<� F�P�s
�n n
l32 u`t�` No
no,
TRANSFERS\N $ f , $ Cql g 1a02 1516 r� uery� ted�
/ g.. G711. 6ud9e
$ 0 0 e en
NSF ERS \�RBUTtON $ C372
T A 1TP` GON RlP. ',lot
FUnd 8a\and
OVER\UNDE
EG \NO � �..Pianned
E �09°1
NE ?c)sTtoN" ENOttINO
j 0'(p4 NET OSR edBudpet Ume.dern
•P\ease npte tnN m the P
go
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS I ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2021 VARIANCE
BUDGET BUDGET FORECAST FAVIWNFAVI PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Information Technology - Radio Communications (536001
OPERATING REVENUES
Outside
$ 9255,600.00 $ 9,265,600.00 S
9,274, 300.00 $ 8,70000
0.09%
Fay. Antenna Site Mgmt. $274,000 due to updates in rental contracts Partially offset
by uniav, E911 Surcharge ($265,300) due to volume of users/receipt of 911 surcharge.
Inside
$ 491,626.00 $ 491,828 00 S
570,62E 00 $ 78,800 00
16.02%
Fay. Leased Equipment $134,000 due to lower than anticipated non-public users,
Producive Labor $9,900 due to Mobile Data Computer repairs for Oakland County
Agencies. Offset by unfay. Parts and Accessories ($65,100) due to lower than
anticpated reimbursement by participating agencies for equipment replacement
TOTAL OPERATING REVENUE
$ 9,757,42800 $ 9,757,428.00 $
9,844,928.00 $ 87,500.00
0.90%
OPERATING EXPENSES
$ 6,426,025 00 3 6,701,025.00 $
7,031,525.00 $ (330,500.00)
-4.93%
Unfay. Other Expendable Equipment ($434,900) for equipment replacement, Interest
Expense 1$316,600), Utilities ($95,00D), Tower Charges ($45,200) and Supplies
($9,000) due to usage, Depreciation ($40,200) based on depreciation schedule and
Contracted Services ($1,800) due to higher than anticipated costs. Partially offset by
fay. Parts and Accessories $241,300, Professional Services $142,000 due to lower
than anticipated contractual costs for staffing services, Intemal Services $156,400
primarily due to Info Tech CLEMIS based on usage and Software Support Maintenance
$60,000 due to 4mmg of Emergency Services IP Network Project and Travel $12,500
due to travel restrictions related to the COVID-19 pandemic.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
$ 3,331,40300 $ 3,056,403.00 $
2,813,403.00 $ (243,000.00)
NON -OPERATING REVENUE
$ 300,000 00 $ 300,000.00 $
263,300.00 $ (36,700 00)
-12.23%
Unfav Interest Income due to less than anticipated level of cash available for
investments.
TRANSFERS IN
$ - $ 4,622,980 00 S
4,622,98D 00 $ -
0.00%
TRANSFERS(OUT) $ (2%,000.00) $ (2860DD.D0) $ (286,000.00) $
0.00%
NET REV OVER(UNDER) EXP- $ 3,345,40300 $ 7,671,633.00 $ 7,413,6B3.00 $ (279,700.00)
TOTAL NET POSITION - BEGINNING $ 39,691,044.99
TOTAL NET POSITION - ENDING $ 47.10472T99
"Please note that in the Adopted Budget (line-dem book) this is budgeted as "Planned use of Fund Balance" in the revenue category or Budgeted Equity Adjustment in Expenses
81
COUNTY OF OAKLAND
FY 2021 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS I ENTERPRISE FUND
INFORMATION TECHNOLOGY
ADOPTED AMENDED FY 2021 VARIANCE
BUDGET BUDGET FORECAST FAVAUNFAVI PERCENT
Fire Records Manaqement 1 53100)
OPERATING REVENUES:
Outside $ 283,233 00 $ 283,233.00 $
TOTAL OPERATING REVENUES $ 283,233.00 $ 283,233.00 $
OPERATING EXPENSES $ 1038,66600 $ 1,038,666.00 $
EXPLANATION OF SIGNIFICANT VARIANCES
306,933.00 $ 23,700.00 8.37 o Fay. primarily due to Participation Fees for Oakland and Non -Oakland Agencies
306,933.00 $ 23,70000 8370
980,4WM $ 58,200.00 5.60% Fay. Software Maintenance $44.000 due to reduction in maintenance costs; Internal
Services $27,100 primarily due to IT Development and Depreciaton $20100 based on
depreciation schedule. Partially offset by unfay. Professional Services ($35,000) due to
increased activity.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
$ (755,43300)
$
(755,433.00)
(673,53300) $
81,900.00
NON -OPERATING REVENUE
$ 3,000.00
$
3,ODD.00
2,500.00
(500 OD)
-16.67%
Unfay. Interest Income due to less than anticipated level of cash available for
investments.
TRANSFERS IN
$ 507,699.00
$
507699.00
571,999.00
64,300.00
12.66%
Fay. due to less than budget anticipated need.
TRANSFERS(OUT)
$ -
$
-
$ - $
-
0.00%
CAPITAL CONTRIBUTION
$ -
$
-
$ - $
-
0.00%
NET REV OVER(UNDER) EXP`
$ (244,734.00)
$
(244,734.00)
(99,034.00)
145,700.00
TOTAL NET POSITION - BEGINNING
$ 1,670,802.89
TOTAL NET POSITION - ENDING
$ I571.768.B9
'Please note that in the Adopted Budget (line -item book) this is budgeted as "Planned use of Fund Balancein the revenue category or Budgeted Equity Adjustment in Expenses
82
OAKLAND COUNTY PARKS & RECREATION COMMISSION
FY 2021 Uncollectible Debt Write-offs
January 1 2021 - March 31 2021
Name (Last, First) OR Type of,.'.Gase Number' Descrip#1on Of Budgeffz
t tiinn, I' OC t3oC,ApRr9Val jFortasr tour algm creamcars# Debt ({eyed#card) Revenue Owed Center
9780 Credit Card 710673452001 Daily Entry ADD 01/08/21 n/a
Amount Wri ten=off
5.00 03/21
Total $ 5.00
Oakland County Fiscal Services Policy: If it is determined that a receivable is uncollectible, then amounts up to $1,000 may be
written off by approval of the manager of Fiscal Services. All write-offs shall be reported to the Board of Commissioners with the
quarterly forecast report. Write-offs in excess of $1,000 require Board of Commissioners' approval.
Authorized by:
4/14/2021 3.55 PM
OCPR Uncollecbble Debt W me f Asx 5'M21-Q2 83
rIMASKO LAW
o
319 Northbound Gn7liot AVe;-rUe. Ids:, Clemens, 1;V 48043
b86-468-679,i . Fca 586-E68-6798 simcsholaw._.om
NOTICE TO BENEFICIARY OF INTEREST IN THE
LINDA L. HOLTZMAN TRUST
Date: February 1, 2021
To: Beneficiaries of the Linda L. Holtzman Trust
Re: Trust:
Trust Date:
Trust Amendment:
Linda L. Holtzman
Trust December 5, 2008
May 16, 2012
First and foremost, let me take this opportunity to extend my condolences to you on the death of
Linda Holtzman.
(D) On the death of the Settler, after giving effect to the above provisions of this Trust,
the Trustee shall distribute five Thousand Dollars ($5,000.00) to the OAKLAND COUNTY
HUMANE SOCIETY, to be used for whatever purposes the governing body thereof may determine.
Smcereiy,
Sima'eko Law, P.C.
I —ie%M. Simaslco (P42760)
319 Northbound Gratiot Avenue
Mount Clemens, MI 48043
(586)468-6793;fax (586)468-6798
PatSimasko®simaskolaw.com
84
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - January - March 2021 - 2nd Quarter
1/1/2021 Shan Sundaram
50137
$5.00
3495441
1/1/2021 Lori Kitchen
50204
$5.00
3495441
1/1/2021 Richard Davis
50207
$10.00
349544
1/1/2021 Cathi Castellana Barry
50210
$0.46
349544
1/1/2021 Ariel Stollman
50211
$0.18
349544
1/1/2021 Amanda Wilson
50212
$0.18
3495441
1/2/2021 Allen Schwartz
50215
$40.00
3492951
1/2/2021 Sarah Campbell
50231
$5.00
349544
1/2/2021 Michael McBryar
50232
$0.64
34954411
1/2/2021 Ajay Murgod
50233
$0.46
3495441
1/2/2021 Jennifer Newman
50235
$5.00
3495441
1/2/2021 Caroline Kerfoot
50243
$5.00
34954411
1/3/2021 Julie Trimmer
50265
$5.00
3495441
1/3/2021 Valerie Raiss
50266
$0.46
3495441
1/3/2021 Amy Barry
50269
$5.00
3495441
1/3/2021 Amy Barry
50270
$5.00
349544
1/3/2021 Amy Rydleski
50277
$5.64
349544
1/4/2021 Randea Crowell
50286
$0.64
3495441
1/4/2021 Tricia Teller
I 50288
$4.64
3495441
1/4/2021 Justin Walch
50292
$0.18
34954411
1/4/2021 Caron Harvey
50300
$0.18
3495441
1/4/2021 Anthony Phillips
50303
$0.18
3495441
1/4/2021 Linda Moir
50305
$10.00
3495441
1/4/2021 Perry DeCuir
50326
$0.96
3495441
1/4/2021 Tammy Drinnon
50327
$0.18
3495441
1/4/2021 Tammy Drinnon
50328
$0.18
3495441
1/4/2021 Michael Zdanio
50330
$5.00
3495441
1/4/2021 Stacey Kahle
50332
$10.00
3495441
1/4/2021 Chad Seigle
50336
$5.64
3495441
1/4/2021 Nancy lsken
50343
$5.18
3495441
1/4/2021 Marguerite McGrath
50344
$5.00
3495441
1/4/2021 Danielle Nelson
50348
$30.00
3495441
1/5/2021 Karen Melssnest
50349
$10.00
34954411
1/5/2021 Constance Salloum
50353
$25.00
3494671
1/5/2021 Bradley Dokter
50354
$40.00
3494671
1/5/2021 Mark Mudd
50356
$5.00
3494671
1/5/2021 Nancy Ross
50357
$5.00
3494671
1/5/2021 Patrick Whyte
50362
$5.00
3495441
1/5/2021 Amy Lyczak
50365
$0.64
3495441
1/5/2021 Mary Rychlewski
50381
$0.64
3495441
1/5/2021 Adam Gott
50387
$5.00
3495441
1/5/2021 Alison Hadley
50392
$30.00
3495441
1/5/2021 Rebecca Weber
50400
$0.64
349544
1/5/2021 Rebecca Lowe
50413
$200.00
3494671
1/5/2021 Robert Levy
50427
$0.96
3495441
1/5/2021 Leah Garofali
50429
$0.18
349544
1/5/2021 Michael Catalano
50431
$0.46
3495441
1/6/2021 Kimberly Monette-Garnier
50428
$5.00
3495441
1/6/2021 lames & Arlynn Griffin
50437
$100.00
3494671
E-7
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy)
Donations -January - March 2021 - 2nd Quarter
1/6/2021 Elissa Staeuble
50438
$25.00
1/6/2021 Dawn Lacks
50455
$5.00
1/6/2021 Linda & David Londo
50465
$20.00
1/6/2021 Robert Seeley
50468
$60.50
1/6/2021 Patricia Hintz
50468
$50.00
1/6/2021 Donation Box
50473
$40.00
1/6/2021 Kurt Geiger
50488
$10.00
1/6/2021 Jennifer Naami
50489
$0.18
1/6/2021 Manoj Rawat
50492
$0.64
1/7/2021 Allyson easey
50497
$4.18
1/7/2021 Jody Brinker
50500
$5.00
1/7/2021 Maria Rodriguez
50504
$0.46
1/7/2021 Joseph Marinack
50505
$20.00
1/7/2021 Janet Servis
50514
$0.64
1/7/2021 William Kevelin
50521
$20.00
1/7/2021 Steven Fisher
50534
$0.46
1/7/2021 Madalyn Gareau
50538
$0.64
1/7/2021 Michele Lee
50539
$0.64
1/7/2021 Sarah Moore
50540
$5.00
1/7/2021 Yelena Kozyreva
50542
$5.00
1/7/2021 Deana Petros
50552
$0.64
1/8/2021 Erika Roberts
50558
$0.28
1/8/2021 Warren Boyne
50559
$0.18
1/8/2021 Jennifer Wilcox
50561
$30.00
1/8/2021 Kara Rucinski
50578
$0.46
1/8/2021 Kathleen Yoannides Young
50579
$0.64
1/8/2021 Barbara Brown
50581
$50.00
1/8/2021 Shannon Fagan
50586
$0.64
1/8/2021 Kurt Berry
50592
$0.18
1/8/2021 Adam Vandecar
50611
$0.18
1/8/2021 Eyad Khadr
50615
$0.64
1/8/2021 Stephanie Baldassarre
50617
$0.18
1/8/2021 Susan Stevens
50620
$2.50
1/8/2021 Susan Stevens
50621
$2.50
1/9/2021 Lindsay DeGrand
50629
$0.46
1/9/2021 Rhona MacKinnon
50631
$1.46
1/9/2021 Sara Naranjo
50632
$0.64
1/9/2021 Alysia Hogan Kinning
50638
$0.64
1/9/2021 Hilary Henderson
50647
$5.00
1/9/2021 Julie Carpenter
50652
$0.64
1/9/2021 Michele Tinsey
50653
$5.00
1/9/2021 Krystal Warner
50662
$5.00
1/9/2021 Mary Parise
50663
$10.00
1/10/2021 Sherri Williams
50672
$10.00
1/10/2021 Sherri Williams
50673
$10.00
1/10/2021 Cathy Cantor
50677
$5.00
1/10/2021 Lisa Rice
50679
$0.64
1/10/2021 Breton Blair
50682
$5.00
1/10/2021 Prasanna Swaminathan
50683
$5.00
1/10/2021 Adrienne Green
50684
$0.64
3494671
3495441
3494671
3494671
3496611
3496611
3495441
3495441
3495441
3495441
3495441
349544
3495441
3495441
3495441
3495441
3495441
3496711
3495441
3495441
3495441
3496711
3496711
3496711
3496711
3496711
3496611
3496711
3496711
3496711
349671
3496711
3496711
3496711
3496711
3496711
3496711
3496711
3496711
3496711
3496711
3496711
3496711
3496711
3496711
349671
3496711
3496711
3496711
3496711
86
OAKLAND COUNTY ANIMAL CONTROL AND
PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - January -
March 2021 - 2nd Quarter
1/10/2021 Megan Gaines
50692
$10.00
1/11/2021 Marguerite DeMaria
50697
$30.00
1/11/2021 Paul Schultz
50708
$0.18
1/11/2021 Connie Campisi
50715
$10.00
1/11/2021 Sue Mitchell
50719
$50.00
1/11/2021 Sarah Fahy
50721
$5.00
1/11/2021 Richard Holmes
50722
$5.00
1/11/2021 Catherine Thomson
50725
$0.64
1/11/2021 Sarah Cuda
50729
$0.18
1/11/2021 Belinda Marcordes-Wilson
50734
$0.64
1/11/2021 Belinda Marcordes-Wilson
50740
$0.18
1/11/2021 Valerie Tucker
50745
$301.00
1/1112021 Kathryn McMullen
50746
$10.00
1/11/2021 Judy Knudtson
50748
$100.00
1/11/2021 Adrienne Youchnik
50755
$5.00
1/11/2021 Stephanie Blast
50768
$0.64
1/11/2021 Kellle Das
50769
$5.00
1/11/2021 Michael Peterson
50773
$20.00
1/12/2021 Claudia Com
50775
$0.64
1/12/2021 Judith Tarsney
50780
$50.00
1/12/2021 John Little
50782
$5.00
1/12/2021 Sherman Henderson
50791
$100.00
1/12/2021 Ricardo Gutierrez
50800
$0.46
1/12/2021 Kyle Smith
50803
$22.00
1/12/2021 Mary Pothoff
50809
$5.00
1/12/2021 Jessica Naert
50810
$20.00
1/12/2021 Joseph Maniaci
50811
$50.00
1/12/2021 Dorothy Boone
50831
$55.00
1/12/2021 Barbara Hart
50841
$50.00
1/12/2021 Krlstina Dunne
50844
$5.00
1/13/2021 Emma Khoury
50846
$5.00
1/13/2021 Kyle Garringer
50853
$0.18
1/13/2021 Andrew Capelli
50861
$5.00
1/13/2021 Michelle Russell
50862
$0.46
1/13/2021 John Crawford
50863
$0.18
1/13/2021 Johnathan Muenk
50868
$0.18
r
I 1/13/2021 Karly Schafer
50876
$5.00
1/13/2621 Cathy Brush
50879
$5.00
1/13/2021 Cathy Brush
50880
$5.00
1/13/2021 Eric Davis
50890
$20.00
1/13/2021 Jose Campos
50895
$10.00
1/13/2021 Dawn Kelly
50898
$5.00
1/13/2021 Helen Phillips
50900
$10.00
1/14/2021 Yoonsun Kim
50911
$5.00
1/14/2021 Karen Winkler
50915
$0.64
1/14/2021 Ashley Branoff-Lamberti
50918
$0.18
1/14/2021 Joseph Wierenga
50921
$4.18
1/14/2021 Jessica Ross
50925
$5.00
1/14/2021 Maureen Mons
50933
$0.47
1/14/2021 Deshawn Bacon
50934
$5.00
1
3496711
3497201
3497201
3497201
3498391
3497201
3497201
3497201
349720{I 349720
3497201
3498391
3497201
3498391
3497201
3497201
349720
3497201
3497861
3498391
3498391
3498391
3497861
3498391
3497861
3497861
3497861
3498391
3497861
3497861
3498811
3498811
3498811
3498811
3498811
3498811
3498811
3498811
3498811
3498811
3498811
3498811
3498811
3500971
3500971
3500971
3500971
3500971
3500971
3500971
87
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy)
Donations - January - March 2021 - 2nd Quarter
1/14/2021
Donation Box
50941
$40.00
350068
1/14/2021
Heather Martin
51002
$5.00
350097
1/14/2021
Ryan Gavin
51023
$0.18
350097I
1/15/2021
Richard Murphy
50968
$50.00
350334I
1/15/2021
Daniel Phillips
50976
$2.50
350334
1/15/2021
Barbara Butler
51039
$0.96
350193
1/16/2021
Wanda Roberts
51015
$10.00
350193I
1/16/2021
Jill Wuolewu
51017
$10.00
350193I
1/16/2021
JoAnn Feldt
51055
$0.64
350193I
1/16/2021
Joy Camp
51059
$20.00
350193I
1/16/2021
Linda Bodzin
51063
$0.96
350193I
1/16/2021
Deborah Frazee
51066
$20.00
350193I
1/16/2021
Marc Upshaw
51079
$10.00
3501931
2/16/2021
Luke Milushevski
51080
$5.00
350193I
1/16/2021
Stacy Yerby
51081
$0.18
350193I
1/16/2021
Bonnie Vautaw
51082
$0.18
350193I
1/17/2021
Stuart Huntley
51071
$5.00
350193I
1/17/2021
Chuck Gemayel
51072
$1.46
3501931
1/17/2021
Pablo Calzada
51076
$0.64
350193
1/17/2021
Beverly Rocha
51077
$10.00
350193
1/17/2021
Amber Robbins
51086
$5.64
350193I
1/17/2021
Kristina Bradley
51089
$0.46
350193I
1/18/2021
Blanca Galda
51097
$10.00
350193I
1/18/2021
Amy Walsh
51100
$20.00
350193I
1/18/2021
Debi Coughlin
51101
$10.00
3501931
1/18/2021
Lindsey Wise
51109
$0.64
350193I
1/18/2021
Ian MCCain
51110
$5.00
3501931
1/18/2021
Christina Quail
51112
$0.64
350193I
1/18/2021
Holly Fuchs
51119
$5.00
350193I
1/18/2021
Richard Marrero
51122
$0.46
350193I
1/18/2021
Richard Marrero
51123
$5.00
3504731
1/18/2021
Laura Madison
51125
$20.00
350473I
1/18/2021
Laura Madison
51126
$20.00
350473I
1/19/2021
Denise Donaldson
51044
$10.00
350193I
1/19/2021
Emilie Conllleau Charron
51127
$0.46
350473I
1/19/2021
Lisa Wisdom
51130
$5.00
350473I
1/19/2021
Magali Jimenez
51131
$5.00
350473I
1/19/2021
Deepak Kanneganti
51135
$0.46
350473I
1/19/2021
Elwell Elwell
51139
$0.64
350473
1/19/2021
Julian Kern -Smith
51142
$10.00
350473
1/19/2021
Trystyn McCarthy
51149
$0.64
3504731
1/19/2021
Cliff Frieler
51176
$30.00
350554I
1/19/2021
Regina Sandri
51187
$0.64
350473I
1/19/2021
Jonathan Clements
51190
$0.18
350473I
1/19/2021
Jonathan Clements
51191
$0.18
350473I
1/19/2021
Elizabeth Messina
51196
$0.64
350473I
1/20/2021
Jennifer Albert
51153
$4.00
350596I
1/20/2021
Kathy Petz
51170
$25.00
350596I
1/20/2021
Elizabeth Sopko
51202
$5.00
3505541
1/20/2021
Tiffany Piro
51225
$5.00
350554I
88
OAKLAND COUNTY ANIMAL CONTROL AND
PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - January -
March 2021 - 2nd Quarter
1/20/2021 Kimberly Denison
51233
$0.64
350751
REJECTEDI
1/20/2021 Jeremy Setser
51369
-64
1/20/2021 Jeremy Setser
51371
.64 REJECTED1
1/21/2021 Arvind Awasthi
51245
$0.18
35D7511
1/21/2021 Michelle Jonna
51249
$30.00
3507511
1/21/2021 Karen Heidacker
51252
$50.00'
350598
1/21/2021 Mary Markell
51258
$22.50
3505981
1/21/2021 Lindsay Stefanko
51276
$5.00
3507511
1/22/2021 L.G. Smith
51264
$50.00
3508121
1/22/2021 Michele Camp
51281
$5.00
3508191
1/22/2021 Jessica Lueer
51283
$0.46
3508191
1/22/2021 Rhonda Rouse
51285
$5.00
3508191
1/22/2021 Brett Ray
51286
$0.64
3508191
1/22/2021 Sharon Stevens
51289
$100.00
3508141
1/22/2021 Kyle Marshall
51290
$10.00
3508191
1/22/2021 Brian Greig
51293
$0.64
3508191
1/22/2021 Hilary Rademacher
51308
$1.18
3508191
1/22/2021 Amrita ehanJa
51311
$2.00
3508191
1/22/2021 MSU Federal Credit Union
51313
$4,041.24
3508121
1/22/2021 Petfinder Foundation
51321
$405.00
3508121
1/22/2021 Ginger Giannetti
51330
$15.00
3508191
1/23/2021 Brent Charton
51344
$0.18
3508401
1/23/2021 Deana Derocha
51345
$5.00
35OB401
1/23/2021 Jessica Hoffmann
51359
$5.00
3508401
1/24/2021 Julia Cawvey
51363
$5.00
3509391
1/24/2021 Jeremy Setser
51370
$0.36
3509391
1/24/2021 Monica Reesman
51372
$5.00
3509391
1/24/2021 Paige Kondek
51375
$0.18
3509391
1/24/2021 Laura Barlow
51380
$0.64
3509391
1/24/2021 Alessandra Bomerenke
51382
$10.00
3510451
1/24/2021 Karolyn Karl
51383
$5.00
3510451
1/25/2021 David Holmes
51384
$5.00
3510451
1/25/2021 Alyvia Valkanos
51387
$5.00
3510451
1/25/2021 Elissa Staeuble
51391
$25.00
3508121
1/25/2021 J.M. Wilkening
51392
$100.00
3508121
1/25/2021 Sara Taler
51393
$300.00
3508121
1/2512021 Nelson Hersh
51394
$50.00
3508121
1/25/2021 Suzanne Foster
51393
$120.00
3508121
1/25/2021 Lucy Kelly
51397
$60.00
3508121
1/25/2021 Heather Brzezinski
51400
$125.00
3508121
1/25/2021 Katherine Witt
51402
$5.00
3510451
1/25/2021 Dylan Hart
51403
$0.46
3510451
1/25/2021 Sydney Senger Thompson
51404
$0.64
3510451
1/25/2021 Amanda Wahl
51422
$0.64
3510451
1/25/2021 Michelle Hutter
51477
$10.00
3510451
1/25/2021 Megan Stolp
51478
$0.18
3510451
1/25/2021 Denise Stout
51427
$10.00
3510451
1/26/2021 Donation Box
51445
$22.80
3509611
1/26/2021 Donation Box
51447
$18.50
3509611
1/26/2021 Sue Raupt
51452
$50.00
3509591
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy)
Donations -January - March 2021 - Znd Quarter
1/26/2021 Cindy Ross
51487
$10.00
1/26/2021 Charles Verbeke
51492
$0.18
1/26/2021 Lunalones
51493
$10.00
1/26/2021 Sangkyom Kim
51494
$5.00
1/27/2021 Michele Stone
51507
$5.64
1/27/2021 Eleanor Sheppard
51525
$0.18
1/27/2021 Eleanor Sheppard
51527
$0.18
1/27/2021 Phillippe Brigade
51528
$10.00
1/27/2021 Christopher Furlong
51535
$0.64
1/27/2021 Mark Matthews
51547
$5.00
1/27/2021 Skylar Steingold
51553
$50.00
1/28/2021 Sarah Gold
51557
$5.00
1/29/2021 Kimberly Noble
51560
$10.00
1/28/2021 Kimberly Noble
51561
$0.64
1/28/2021 Jennifer Routen
51563
$5.00
1/28/2021 Brian Hill
51564
$0.46
1/28/2021 George Zambiasi
51572
$50.00
1/28/2021 Mark Mudd
51575
$5.00
1/28/2021 Kristin Ansel
51597
$5.00
1/28/2021 Kayla Conner
51601
$10.00
1/28/2021 Stacie Pawlowski
51603
$0.18
1/28/2021 Kristen Ansel
51605
$5.00
1/28/2021 Collie Brower
51607
$0.28
1/28/2021 Beth Powers
51608
$0.64
1/29/2021 Natalie Willis
51613
$5.00
1/29/2021 Jennifer Barber
51623
$0.18
1/29/2021 Crystal Plante
51628
$0.64
1/29/2021 Danielle Gratopp
51631
$0.46
1/29/2021 Melissa St Louis
51670
$0.64
1/30/2021 Jamie Fenner
51652
$25.00
1/30/2021 Lynda Foust
51654
$30.00
1/30/2021 Joseph Folk
51674
$0.64
1/30/2021 Joseph Niemiec
51676
$50.00
1/30/2021 Mathias Wildermuth
51677
$5.00
1/30/2021 Deborah Kiefer
51680
$5.00
1/30/2021 Scott Tolonen
51683
$5.00
1/30/2021 Emily Roland
51684
$5.00
1/30/2021 Andy Femminineo
51686
$5.00
1/30/2021 Peggy Thompson
51690
$30.00
1/30/2021 Peggy Thompson
51691
$10.00
1/30/2021 Matthew Wood
51692
$0.64
1/31/2021 Thomas Smith
51694
$5.00
1/31/2021 Ning An
51700
$0.18
January 2021 Total
2/1/2021 Christine Brooks
2/1/2021 Janice McConchie
2/1/2021 Melanie Pieknik
2/1/2021 Argjir Caushal
1
3511421
35114211
3511421
3511421
3512261
3512261
3512261
3512261
3SI2261
3512261
3512261
3513021
3513021
3513021
3513021
3513021
3511261
3511261
3513021
3513021
3513021
3513021
3513021
3513021
3513981
3513981
3513981
3513981
3513981
3513791
3513791
3514271
3514271
3514271
3514271
3514271
3514271
3514271
3514271
3514271
3514271
3514271
3514271
1
3515611
3515611
3515611
90
OAKLAND COUNTY ANIMAL CONTROL AND
PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - January -
March 2021 - 2nd Quarter
2/1/2021 Amy Bryson
51757
$5.00
2/2/2021 Melissa Szasz
51772
$30.00
2/2/2021 Beth Organ
51780
$0.64
2/2/2021 Jennifer Witt
51783
$5.00
2/2/2021 Dale Warford
51788
$5.00
2/2/2021 Ashley McKae
51793
$5.00
2/2/2021 Michael Girolami
51800
$5.00
2/2/2021 Katelyn King
51802
$0.46
2/2/2021 Victor Mituta
51804
$5.00
2/2/2021 Jorge Paredes
51806
$10.00
2/2/2021 Christopher Douglas
51809
$5.00
2/3/2021 Pamela Nichols
51813
$50.00
2/3/2021 North American Lighting, Inc
51814
$288.50
2/3/2021 Deborah Roy
51830
$0.32
2/3/2021 Pet Supplies Plus Bloomfield
51839
$177.00
2/3/2021 Pet Supplies Plus Bloomfield
51843
$41.48
2/3/2021 Charles Marracco
51846
$10.00
2/3/2021 Amanda Lindquist
51847
$5.00
2/3/2021 Adam King
51870
$5.00
2/3/2021 Trevor Martin
51875
$0.64
2/3/2021 Alan Goodwin
51881
$0.18
2/3/2021 Megan Breedlove
51882
$0.46
2/4/2021 Allsha Burke
51884
$100.00
2/4/2021 Belkis Morata
51893
$5.00
2/4/2021 Clint Andrews
51902
$0.64
2/4/2021 Keith Vansen
51916
$5.00
2/4/2021 Barbara Johnston
51970
$5.64
2/4/2021 Lawrence Tripp
51975
$5.00
2/4/2021 Kaylin Braekevelt
51978
$0.46
2/5/2021 Donation Box
51941
$27.50
2/5/2021 Margaret Ferguson
51946
$42.50
2/5/2021 MSUFCU & OUCU
51959
$8,701.50
2/5/2021 Lynn Lorenzetti
51981
$10.00
2/5/2021 Michelle Piazza
51983
$5.64
2/5/2021 Allan Mindell
51990
$5.00
2/5/2021 Jeanette Sul
51991
$25.00
2/5/2021 Karen Nicol
51992
$0.18
2/5/2021 Dan Zetu
51993
$5.00
2/5/2021 Deborah McNamara
51995
$50.00
2/5/2021 Janice Richardson
52002
$0.64
2/5/2021 Modathir Bougrme
52003
$10.00
2/5/2021 Albert Nielsen
52005
$5.00
2/5/2021 Emma Kusnier
52006
$5.00
2/5/2021 Jason Gonzalez
52008
$0.64
2/5/2021 Peter Cirenese
52013
$0.18
2/5/2021 Carey Osmundson
52015
$10.00
2/5/2021 Kathryn Zielinski
52017
$5.00
2/6/2021 Jeffrey Skebo
52025
$5.00
2/6/2021 Takako Funaki
I
52030
$5.00
2/6/2021 Richelle Szantner
52031
$20.00
1
35156111
3515611
3515611
351561
3515611
3515611
3515611
3515611
3515611
3515611
3515611
3513791
3513791
3513791
3513791
3513791
3515611
3515611
3515611
3515611
3516481
3516481
3516481
3516481
3516481
3516481
3516481
3516481
3516481
3515271
3515251
3516111
3516481
3516481
3516481
3516481
3516481
3516481
3516481
3516481
3516481
3516481
3516491
3516481
3516481
3516481
3516481
3516481
3516481
3516481
91
OAKLAND COUNTY ANIMAL CONTROL AND
PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - January -
March 2021 - 2nd Quarter
2/6/2021 Mork Cozart
52032
$5.00
351648
2/6/2021 Chris Bogojevlch
52034
$0.64
3516481
2/6/2021 Mackenzie Wilder
52038
$0.18
3516481
2/6/2021 Amy Walsh
52042
$9.18
3516481
2/6/2021 William Grubbs
52045
$5.00
3516481
2/7/2021 Sylvia Swirtz
52057
$5.18
3518001
2/7/2021 Emma Dawda
52061
$5.00
3518001
2/7/2021 Claire Townsend
52064
$0.64
3518001
2/8/2021 Kelsey Biswanger
52068
$5.00
3518001
2/8/2021 Kelsey Biswanger
52069
$5.00
3518001
2/8/2021 Karen Walkowiak
52078
$0.74
35180011
2/8/2021 Jill Ghormley
52102
$0.96
3518001
2/8/2021 Julian Rebel
52321
$5.00
3518001
2/9/2021 Donna Czarnik
52117
$50.00
3518001
2/9/2021 Marianne Reid
52134
$0.64
3518001
2/9/2021 Annette Figley
52143
$10.00
3518001
2/9/2021 Kirk Lindahl
52144
$25.00
351800I
2/9/2021 David Brown
52152
$10.00
3518331
2/9/2021 Indeah Media
52154
$0.18
3518001
2/9/2021 Charles VanHusan
52158
$0.46
351800
2/10/2021 Athena Zapor
52164
$0.47
352051
2/10/2021 Althena Zapor
52165
$0.46
3520511
2/10/2021 Devon Schwalm
52175
$20.00
3520511
2/10/2021 Lisa Thibodeau
52178
$5.00
3520511
2/10/2021 Riley Flory
52185
$5.00
3520511
2/10/2021 Lisa Birchett
52192
$100.00
3518311
2/10/2021 lames Blankenship
52195
$5.00
3520511
2/10/2021 Ron Stewart
52198
$0.18
3520511
2/10/2021 Daniel Overholt
52200
$0.46
3520511
2/10/2021 Rohan Repale
52203
$0.46
3520511
2/11/2021 Lisa Armstrong
52212
$5.00
3520511
2/11/2021 Kiersten DeKorne
52219
$200.00
3518311
2/11/2021 Philip Grundlehner
52220
$75.00
3518311
2/11/2021 Alfred Demailo
52223
$100.00
3518311
2/11/2021 John Little
52227
$5.00
351831
2/11/2021 Susan kemper
52229
$50.00
3518311
2/11/2021 Olivia Maynard
52230
$100.00
3518311
2/11/2021 Andrew Scallen
52234
$10.00
3520511
2/11/2021 Stacey Doyle
52240
$0.46
3520511
2/11/2021 Susan Ryntz
52247
$0.47
3520511
2/11/2021 Maryann Borghl
52251
$0.38
3520511
2/11/2021 Judy Kendall
52254
$50.00
3518311
2/11/2021 Ann Shepherd
52262
$0.64
3520511
2/12/2021 Dooley Tashijan
52282
$5.00
3520511
2/12/2021 Michael Ginsburg
52297
$5.00
3520511
2/12/2021 Girkikrishna Talla
52299
$25.00
3520511
2/12/2021 Wilfredo Romero
52302
$8.00
352031I
2/13/2021 Amanda Taylor
52339
$5.00
3521711
2/13/2021 Raghuram Medum
52340
$0.46
3521711
2/13/2021 Deborah Ledel
52342
$5.00
3521711
92
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - January - March 2021 - 2nd Quarter
2/13/2021 Deborah Rubyan
52348
$5.00
3521711
2/13/2021 Michele Eschtruth
52365
$20.64
3521711
2/14/2021 Chad Kretschmar
52367
$5.00
3521711
2/14/2021 Martha Brooks
52368
$20.00
3521711
2/14/2021 Karen Barbash
52369
$0.18
3521711
2/14/2021 Eric Ward
52370
$0.46
3521711
2/14/2021 Rhonda Ceruti
52371
$50.00
3521711
2/14/2021 Richard Los
52379
$5.00
3521711
2/15/2021 Linda Ban
52391
$30.00
3521711
2/15/2021 Shannon Morehouse
52392
$0.18
3521711
2/15/2021 Adam Solomon
52393
$5.00
3521711
2/15/2021 leanaiah McIntire
52396
$5.00
3521711
2/15/2021 Rebecca Campbell
52397
$10.00
3521711
2/15/2021 James Mix
52400
$0.96
3521711
2/15/2021 Venkateswara Kodali
52405
$5.00
3521711
2/15/2021 Elisa Palizzi
52406
$10.00
3521711
2/16/2021 Donation Box
52319
$7.40
3521571
2/16/2021 Eileen McGill
52420
$0.18
3522561
2/16/2021 Elizabeth Lopez
52423
$0.18
3522561
2/16/2021 Paige Camillo
52425
$0.64
3522561
2/16/2021 Jessica Enot
52430
$10.00
3522561
2/16/2021 Evan Foulsham
52432
$0.64
3522561
2/17/2021 Val Tellez Nunez
52441
$0.64
3522561
2/17/2021 Robert Cole
52442
$250.00
352157�
2/17/2021 Bernard Graul
52451
$5.00
352256
2/17/2021 Adrianna Kriger
52452
$0.18
352256
2/17/2021 Noha Mordovanaki
52470
$10.00
3522561
2/18/2021 Wendy Marshick
52491
$5.00
3522561
2/18/2021 Nancy Krempa
52501
$5.00
3522561
2/19/2021 Lisa Peters
52504
$200.00
3524241
2/19/2021 Laura Lowry
52511
$0.64
3524241
2/19/2021 Amy Slosar
52512
$5.00
3524241
2/19/2021 Kristi Thompson
52527
$1.00
3524241
2/19/2021 Pamela Ford -Morgan
52537
$1,000.00
3523991
2/20/2021 Gregory Betts
52569
$0.28
3524241
2/19/2020 Kristi Gattinger
52573
$0.18
352424
2/20/2021 Breanna Warner
52574
$0.18
3524241
2/20/2021 Steve Poulos
52578
$0.36
3524241
2/20/2021 Julie Ferus
52580
$5.00
3524241
2/20/2021 Julie Ferus
52581
$5.00
3524241
2/20/2021 Meghan Kemp -Watkins
52583
$5.00
3524241
2/20/2021 Michael Rooney
52585
$5.00
3524241
2/20/2021 Dawn Foulke
52586
$20.00
3524241
2/20/2021 AmyTanner
52588
$0.46
3524241
2/20/2021 Sue Mulvaney
52593
$5.00
3524241
2/21/2021 Jennifer Murphy
52615
$5.18
3524241
2/22/2021 St. Hugo of the Hills
52559
$1,003.00
3524011
2/22/2021 Matthew Matusiczky,
52579
$0.64
3524411
2/22/2021 Astrid Harrod
52625
$0.64
3524411
2/22/2021 Astrid Harrod
52626
$0.64
3524411
93
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted
Fund (Legacy) Donations - January - March 2021 - 2nd Quarter
2/22/2021
Lindsay Pollina
52633
$0.64
357441
2/22/2021
Christopher Bodzick
52634
$10.00
3524411
2/22/2021
Melissa Kohler
52639
$50.00
3524411
2/22/2021
Ther! M<Neary
52642
$0.46
3524411
2/22/2021
Margareta Obreja
52646
$10.64
3524411
2/22/2021
Erica Cerneka
52649
$5.00
3524411
2/22/2021
Carlie Thueme
52669
$1.28
3524411
2/23/2021
Hideya Nishijima
52672
$10.00
3524411
2/23/2021
Roxanne Jeffers
52678
$0.25
3525971
2/23/2021
Lilly Arobour
52686
$0.18
3524411
2/24/2021
Mary Rice
52694
$25.00
3525971
2/24/2021
Heather Munro
52695
$40.00
3525971
2/24/2021
Gay Cramer
52699
$300.00
352597
2/24/2021
Robert Nestor
52701
$50.00
352597
2/24/2021
Shaman! Hurulle
52707
$5.00
3525361
2/24/2021
Dennis Atkinson
52710
$0.46
3525361
2/24/2021
Thomas DeMaria
52732
$0.64
3525361
2/24/2021
Nakia Mills
52743
$0.36
3526501
2/25/2021
Matthew Johnson
52745
$10.00
3526501
2/25/2021
Nancy Conn
52769
$27.00
3526851
2/25/2021
Leah Garofali
52770
$0.18
3526501
2/25/2021
lames Gagel
52780
$10.00
3526501
2/25/2021
Barbara Wods
52784
$5.00
3526501
2/25/2021
Rachel Hoffmann
52789
$5.36
3526501
2/25/2021
Nancy Morrow
52791
$10.00
3526501
2/26/2021
erittney Herbst
52804
$0.18
3527801
2/26/2021
Rebecca Noeske
52812
$5.00
3527801
2/26/2021
Nicole Shelinut
52816
$0.46
3527801
2/26/2021
Jonathon Nichols
52819
$5.00
3527801
2/26/2021
Kelly Kellerman
52833
$20.00
3527801
2/26/2021
Carmelite Martinez
52847
$40.00
3527801
2/26/2021
Lisa Czyz
52848
$50.00
3527801
2/26/2021
Eileen McGill
52849
$0.18
3527801
2/26/2021
Eileen McGill
52850
$0.64
3527801
2/26/2021
Jill Prestel
52851
$0.64
3527801
2/26/2021
Norma Staley
52860
$5.00
3527801
2/26/2021
James Schmitke
52862
$0.18
3527801
2/27/2021
Nicole Tabin
52871
$0.18
3527801
2/27/2021
Teresa Meyers
52878
$0.28
3527801
2/27/2021
Emily Mitchell
52879
$0.64
3527801
2/27/2021
Megan Ohirich
52886
$5.00
3527801
2/27/2021
Cindy Collon
52904
$30.00
3527801
2/27/2021
Cindy Collon
52905
$10.00
3527801
2/28/2021
Rosalba Boville
52888
$0.64
3527801
2/28/2021
Markle Szymanski
52891
$10.00
352780
2/28/2021
Cassandra Mosley
52896
$5.00
3527801
February 2021 Total $14,051.651
94
OAKLAND COUNTY ANIMAL
CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations
- January - March 2021 - 2nd Quarter
3/1/2021 Patti Harpenau
52911
$20.00
352814
3/1/2021 Jeff Quinn
52927
$5.00
352814
3/1/2021 Melody Goodacre
52943
$0.47
3528141
3/1/2021 Christopher Burlingame
52952
$0.64
3528141
3/1/2021 Donation Box
52959
$60.50
3529641
3/1/2021 Michael Greifenberg
52965
$0.46
3528141
3/1/2021 Dora Turkmani
52968
$4.18
3528141
3/1/2021 Marco Losavio
52970
$0.46
352814
3/2/2021 Brandon Hansen
52974
$0.64
352891
3/2/2021 Heidi Barckholtz
52987
$5.00
352891
3/2/2021 Mark Birkholz
52990
$5.00
352891
3/2/2021 Cree Wyatt
52991
$5.00
352891
3/2/2021 Kimm Blue
53002
$0.25
3529621
3/2/2021 Laura Bronsart
53003
$5.00
3528911
3/2/2021 Mard Waldrop
53011
$10.00
3528911
3/2/2021 Edward Schofield
53013
$5.00
3528911
3/2/2021 Jan Prosek
53028
$10.00
3528911
3/2/2021 Richard Birmingham
53031
$5.00
3530051
3/3/2021 Michele Perry
53034
$25.00
3530751
3/3/2021 Jeanette Ragsdale
53035
$50.00
3530751
3/3/2021 Linda Darling
53036
$25.00
353075I
3/3/2021 Elissa Staeuble
53039
$25.00
3530751
3/3/2021 Mark Mudd
53043
$5.00
3530751
3/3/2021 Susanne McVinnie
53045
$50.00
3530751
3/3/2021 Lupe Salinas
53059
$20.00
353077I
3/3/2021 Israel Gutierrez Lopez
53068
$0.64
3530051
3/3/2021 Carmyn Subba
53069
$0.64
3530051
3/3/2021 Karen Hobbs
53070
$5.00
353005�
3/3/2021 Jackie Kochanski
53073
$5.00
353005
3/3/2021 Sarah Burgess
53091
$0.82
353005
3/4/2021 Julia Anderson
53095
$4.18
3531511
3/4/2021 Cathy McNamara
53108
$25.00
3531511
3/4/2021 Kellie MacAloon
53114
$50.00
3531511
3/4/2021 Tim Werth
53116
$0.64
3531511
3/4/2021 Constance Logan
53118
$5.00
353111
3/4/2021 Maddle Barry
53124
$0.46
353151
3/4/2021 Hill Elementary School 3rd Graders
53127
$170.00
3532001
3/4/2021 Tara Cain
53136
$0.64
3531511
3/4/2021 Marlisa Wolf
53137
$0.64
3531511
3/5/2021 Marci Frick
53142
$5.00
3534121
3/5/2021 David Grieco
53144
$5.00
3534121
3/5/2021 Danielle Croclata
53150
$5.00
3534121
3/5/2021 Albert Lipusch
53153
$5.00
3534121
3/5/2021 Melanie Hanaway
53159
$0.64
3534121
3/5/2021 Kurt Hutchison
53163
$0.46
3534121
3/5/2021 Pamela Marsh
53166
$5.00
3534121
3/5/2021 Takami Skarakis
53169
$5.00
3534121
3/6/2021 Dale Milford
53189
$10.00
3534121
3/6/2021 Dale Milford
53190
$10.00
3534121
3/6/2021 Jessica Laflamme
53220
$0.36
3534121
95
OAKLAND COUNTY ANIMAL CONTROL AND
PET ADOPTION CENTER
Restricted Fund (Legacy) Donations -January -
March 2021 - 2nd Quarter
3/6/2021 Paul Borkosh
53224
$0.64
353412
3/6/2021 Paula Stevenson
53227
$0.18
353412�
3/6/2021 Kate Keydel
53228
$0.18
3534121
3/6/2021 Andrew Egmore
53231
$10.00
3534121
3/6/2021 Drew Galasso
53233
$3.00
3534121
3/7/2021 Amy Turner
53238
$5.00
3534121
3/7/2021 Lydia Wileden
53241
$0.64
3534121
3/7/2021 Todd Gilleland
53258
$0.46
3534121
3/7/2021 Momoko Lida
53259
$0.64
3534121
3/7/2021 Juergen Viereck
53265
$10.00
3534121
3/7/2021 Starr Brown
53268
$0.64
353412�
3/7/2021 Olivia Hawkins
53270
$5.00
353412
3/7/2021 Abdel Rahman Emesiri
53375
$0.64
353412
3/8/2021 Kristine Milicia
53276
$20.00
3535441
3/8/2021 Kristine Milicia
53277
$20.00
3535441
3/8/2021 Maria lancar
53307
$20.00
3535441
3/8/2021 Laura Carter
53309
$30.00
3535441
3/8/2021 Deborah Orlando
53315
$0.64
3535441
3/8/2021 Cody Hoover
53316
$5.00
3535441
3/8/2021 Melissa Pena
53318
$0.90
3533691
3/8/2021 Debbie Dolenga
53319
$0.47
3535441
3/8/2021 Nicole Wolf
53328
$0.18
3535441
3/8/2021 Julia Goldman
53342
$0.46
3535441
3/8/2021 Antonio Ribelro
53344
$5.00
3535441
3/9/2021 Sarah Biller
53355
$0.64
3535441
3/9/2021 Geoff Zimmermann
53361
$0.18
3535441
3/9/2021 Kathleen Pitcher
53363
$0.96
353544
3/9/2021 Marcel Duarte
53366
$10.00
3535441
3/9/2021 Marcel Duarte
53367
$10.00
3535441
3/9/2021 Lynda Billotto
53374
$25.00
3534411
3/9/2021 Rose Ketcham
53398
$5.00
3535441
3/9/2021 T Galloway
53403
$0.18
3535441
3/9/2021 Maureen Rietz
53413
$20.00
3535441
3/9/2021 Jessica RICO
53414
$10.00
3535441
3/9/2021 Brittany Basela
53419
$5.00
3535441
3/10/2021 Carol Ulman
53423
$0.64
3535441
3/10/2021 Nancy Pietz
53432
$75.00
3535281
3/10/2021 Stephanie Chupack
53442
$0.18
3535441
3/10/2021 Lauren Davey
53464
$0.36
3535441
3/10/2021 Joleen Floreno
53466
$5.00
3535441
3/10/2021 Eden Hartley
53468
$5.00
3535441
3/10/2021 Tricia Stover
53475
$5.00
3535441
3/11/2021 Abby Stager
53501
$5.00
3537321
3/11/2021 Lavia Yousif
53565
$5.00
3537321
3/11/2021 Rachel Simms
53602
$200.00
3537321
3/11/2021 Sandra Stankov
53809
$0.47
3537321
3/12/2021 Amy Bongiovanni
53578
$0.64
3537321
3/12/2021 Jessica Pederson
53580
$0.18
353732
3/12/2021 Craig Cilikin
53581
$5.00
353732
3/12/2021 Katalin Miklos
53582
$20.00
3537321
PI
OAKLAND COUNTY ANIMAL CONTROL AND
PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - January -
March 2021 - 2nd Quarter
3/12/2021 Alison Schick
53583
$5.00
3/12/2021 Kiley Kallenberger
53588
$0.36
3/12/2021 Erin Thompson
53597
$0.54
3/12/2021 Marie Waung
53601
$10.00
3/13/2021 Annette Smith
53612
$0.46
3/13/2021 Rebecca Atkinson
53616
$5.00
3/13/2021 Katie Bowers
53620
$5.00
3/13/2021 Brand! Gostlin
53631
$0.46
3/13/2021 Paige Mason
53680
$0.64
3/14/2021 Jennifer Matthews
53632
$0.18
3/1412021 Jam! Gayheart
53633
$1.72
3/14/2021 Mahala Clayton
53635
$5.00
3/14/2021 Danielle Joyce
53638
$5.00
3/14/2021 Amanda LaVoie
53640
$0.64
3/14/2021 Christine Adams
53641
$10.00
3/14/2021 Cassle Shelley
53642
$20.00
3/14/2021 Abigale Lennox
53643
$5.00
3/14/2021 Alison Morphew
53644
$30.00
3/14/2021 Patrick McKay Family
53648
$0.18
3/14/2021 Patrick McKay Family
53649
$0.18
3/14/2021 Kathy Booker
53663
$5.00
3/14/2021 Deborah Woodman
53664
$0.18
3/14/2021 Luis Carbini
53664
$5.00
3/14/2021 Suzanne Wolgast
53670
$0.18
3/14/2021 Suzanne Wolgast
53671
$0.18
3/14/2021 Rachel Nance
53673
$0.18
3/15/2021 Eric Kramer
53682
$20.00
3/15/2021 Carrie Pardon
53685
$5.00
3/15/2021 Carrie Pardon
53687
$5.00
3/15/2021 Maria Hess
53688
$0.18
3/15/2021 Stephanie D'Anna
53692
$10.00
3/15/2021 Jazmine Davis
53700
$0.46
3/15/2021 Francisco Javler Argueta
53707
$5.64
3/15/2021 Ed Miller
53712
$0.46
3/15/2021 Erendira Salcedo
53725
$0.46
3/15/2021 Dalsylnnis
53727
$20.00
3/15/2021 Anna Montefusco
53728
$0.18
3/16/2021 John Little
53733
$5.00
3/16/2021 Madison Heights Plumbing & Heating Supply
53737
$1,000.00
3/16/2021 Alfred Demallo
53741
$100.00
3/16/2021 Thomas Lining
53742
$5.00
3/16/2021 Hannah Dennis
53750
$0.64
3/16/2021 Donation Box
53751
$110.00
3/16/2021 Brett Walker
53759
$5.00
3/16/2021 Christine Fontichiaro
53772
$20.00
3/16/2021 Holly Weaver
53791
$0.64
3/16/2021 Diane Kossak
53799
$0.18
3/16/2021 Kathleen Gravino
53800
$10.00
3/16/2021 Greg ohlemacher
53801
$0.46
3/16/2021 Sarah Ykema
53802
$0.18
353732
3537321
3537321
3537321
3537321
353732
353732
353732
353732
3537321
3537321
3537321
3537321
3537321
3537321
3537321
3537321
3537321
3537321
3537321
3537321
3537321
353732
3537321
3537321
3537321
3537971
3537971
3537971
3537971
3537971
3537971
3537971
3137971
353797
3539241
3537971
3539041
3539041
3539041
3539241
3539241
3539021
3539241
3539241
3539241
3539241
3539241
3539241
3539241
97
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION
CENTER
Restricted Fund (Legacy) Donations -January - March
2021 - 2nd Quarter
3/16/2021 Spud Phillips
53807
$5.00
353952
3/16/2021 Bentley lehle
53856
$20.00
3539241
3/17/2021 Kaylelgh Smith
53782
$2.50
3540671
3/17/2021 Darlene Benson
53812
$5.00
3539521
3/17/2021 Steven Cagigas
53813
$5.00
3539521
3/17/2021 Gregory Raiss
53827
$5.00
3539521
3/17/2021 Kimberly Stephens
53828
$5.00
3539521
3/17/2021 Kimberly Stephens
53830
$5.00
3539521
3/17/2021 Edward Matteson
53836
$0.18
3539521
3/17/2021 Jacob May
53844
$5.64
3539521
3/17/2021 Harold Mierop
53863
$5.00
3539521
3/17/2021 Eduardo Rio Ascencio
53865
$5.00
3539521
3/17/2021 Emily Douglas
53870
$10.00
3539521
3/18/2021 Lisa Reid
53872
$20.00
354080
3/18/2021 Margaret Mallon
53892
$75.00
3540671
3/18/2021 Lisa Osiecki
53906
$0.64
3540801
3/18/2021 Kristen Krol
53907
$5.00
3540801
3/18/2021 Shon McCoy
53911
$0.46
3540801
3/18/2021 David Santoro
53919
$1.50
3540671
3/18/2021 Nicole Cade
53925
$0.64
3540801
3/18/2021 Iveta Tobiczyk
53929
$30.00
3540801
3/18/2021 Megan Snith
53931
$0.47
3540801
3/18/2021 Nate Blumerich
53936
$5.00
3540801
3/19/2021 Sarah Grinnell
53922
$58.00
3541391
3/19/2021 Kim Bowyer
53954
$0.64
3542911
3/19/2021 Amanda Stefansson
53955
$0.18
3542911
3/19/2021 Kim Bowyer
53957
$0.18
3542911
3/19/2021 Jennifer Ortwine
53959
$0.46
3542911
3/19/2021 Chao Yang
53960
$0.46
3542911
3/19/2021 Elizabeth Currey
53962
$0.18
3542911
3/19/2021 Kathryn Marvin
53965
$30.00
3542911
3/19/2021 Kimberly Oderkirk
53967
$5.00
3542911
3/19/2021 Rosemary Barnett
53979
$17.00
3541371
3/19/2021 Tyler Cunningham
53998
$5.00
3542911
3/19/2021 Heather Ferow
54000
$10.00
3542911
3/19/2021 Michael Coetzee
54029
$10.00
3542911
3/20/2021 Catherine Coutts
54002
$5.00
354291
3/20/2021 Andreas Keuper
54008
$5.00
354291
3/20/2021 Elizabeth Mclsaac
54010
$0.64
3542911
3/20/2021 Kenneth Uy
54013
$0.64
3542911
3/20/2021 Michelle Banks
54019
$25.00
3542911
3/20/2021 Amy Sabo
54028
$0.18
3542911
3/20/2021 Ashley Diehl
54032
$0.46
3542911
3/20/2021 Michele Connolly
54035
$5.00
354291
3/20/2021 Mike McGee
54058
$5.00
3542911
3/21/2021 Keith Yanachik
54042
$10.00
3542911
3/21/2021 Dawn Clasen
54050
$10.00
3542911
3/21/2021 Keyonla Walker
54064
$1.00
3542911
3/21/2021 Therese Plnazzo
54069
$10.00
3542911
3/21/2021 Stacey Aron
54073
$5.00
3542911
98
OAKLAND COUNTY ANIMAL CONTROL AND
PET ADOPTION CENTER
Restricted Fund (Legacy( Donations -January -
March 2021 - 2nd Quarter
3/21/2021 Mark Case
54076
$30.00
354291
3/21/2021 Scott Hulverson
54079
$10.00
3542911
3/21/2022 Kathleen Oshea
54117
$0.64
3542911
3/22/2021 Raman Koneru
54040
$500.00
354208{II
3/22/2021 Allison Barnhart
54083
$5.00
354390
3/22/2021 Allison Barnhart
54084
$5.00
3543901
3/22/2021 William Jensen
54085
$10.00
3543901
3/22/2021 Brian Sleeman
54101
$50.00
3543901
3/22/2021 DaWanna Williams
54126
$0.46
3543901
3/22/2021 Margaret Phyle
54129
$0.18
3543901
3/22/2021 Valerie Griffen
54352
$5.00
3543901
3/23/2021 Daryl Jamison
54142
$5.00
3543901
3/23/2021 Sandra Hutchinson
54150
$30.00
3542821
3/23/2021 James Kennedy
54151
$1.25
3542841
3/23/2021 Donation Box
54154
$0.32
354282
3/23/2021 Miranda Buchowski
54166
$0.46
3543901
3/23/2021 Robbin Werth
54168
$10.00
3543901
3/23/2021 Susan Lockard
54174
$10.00
3543901
3/23/2021 Laura Boyle
54181
$0.64
3543901
3/23/2021 Akemi Conner
54183
$5.00
3543901
3/23/2021 Katrina Wright
54200
$0.64
3543901
3/23/2021 Renee Youngs
54201
$20.00
3543901
3/23/2021 Amy Guitar
54208
$5.00
3543901
3/23/2021 Jordyn Masuch
54209
$5.00
3543901
3/23/2021 Robert Sharp
54210
$0.64
3543901
3/24/2021 Donation Box
54216
$58.00
3543631
3/24/2021 Drew Miller
54218
$5.00
3543901
3/2412021 Leah Samman
54223
$5.00
3543901
3/24/2021 Marcus Steckler
54230
$5.00
3543901
3/24/2021 Arthur Kohn
54231
$5.00
3543631
3/24/2021 Katherine Soboleski
54238
$5.00
354390I
3/24/2021 Marcela Nava
54241
$5.00
354390
3/24/2021 Tammy Martin
54242
$0.18
3543901
3/24/2021 Joanne Crandall
54255
$5.00
3543901
3/24/2021 Joshua Lushnat
54260
$0.47
3543901
3/24/2021 Aubrey Cornish
54262
$0.64
3543901
3/24/2021 Colleen Lien
54265
$0.18
3547151
3/24/2021 Maureen Apap
54399
$10.00
3543901
3/25/2021 Samantha Curnett
54266
$5.00
3547151
3/25/2021 Anjana Solanki
54270
$0.18
3547151
3/25/2021 Chelle Mackey
54271
$20.00
3547151
3/25/2021 Jenniffer Major
54279
$10.00
3547151
3/25/2021 Gene Smith
54294
$5.00
3547151
3/25/2021 David Harmon
54301
$30.00
3547151
3/25/2021 Crystal Sigler
54307
$10.00
3547151
3/25/2021 Nick Junco
54311
$5.00
3547151
3/25/2021 Todd Stabenow
54318
$5.00
3547151
3/25/2021 Robert Williams
54320
$5.00
3547151
3/25/2021 Jay Kafarski
54324
$30.00
354715
3/25/2021 lay Kafarski
54325
$10.00
3547151
�R,
OAKLAND COUNTY ANIMAL CONTROL AND
PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - January -
March 2021 - 2nd Quarter
3/26/2021 Garrett Lovas
54358
$0.46
354718
3/26/2021 Hannah Sheridan
54359
$10.00
3547181
3/26/2021 Julie Hubbard
54363
$20.00
3547181
3/26/2021 Mindy Orozco
54369
$0.18
3547181
3/26/2021 Emanuela Serwach
54389
$0.18
3547181
3/26/2021 Alexa James
54390
$5.00
3547181
3/26/2021 Melissa Day
54441
$0.64
3547181
3/26/2021 Robert Anderson
54444
$5.00
3547181
3/27/2021 Kaitlyn williams
54384
$5.00
354719
3/27/2021 Mitra Chetankumar Shah
54396
$0.92
354719
3/27/2021 Matthew Albo
54400
$0.46
3547191
3/27/2021 Rich Gabbel
54407
$10.00
3547191
3/27/2021 Emily Shinohara
54411
$0.64
3547211
3/27/2021 Kaitlyn williams
54456
$5.00
3547211
3/27/2021 Amle King
54458
$0.18
3547211
3/27/2021 Dean Bennett
54460
$5.00
3547211
3/27/2021 Marc Albo
54466
$5.00
3547211
3/27/2021 Susan Kumrey
54469
$0.46
3547211
3/28/2021 Joe Stirparo
54415
$10.00
354721
3/28/2021 Joel Hack
54432
$5.00
354721
3/28/2021 Shaylee Marinch
54437
$10.18
3548101
3/28/2021 Kerr! Johns -Littleton
54438
$20.00
3548101
3/28/2021 Jennifer Hayes
54485
$0.64
3547211
3/28/2021 Christine Walker
54488
$0.64
3547211
3/29/2021 Louis Nick
54499
$0.64
3548101
3/29/2021 Autumn Trumble
54501
$5.00
3548101
3/29/2021 Heather Maurice
54502
$0.18
3548101
3/29/2021 Tamera Santavicca
54505
$10.00
3548101
3/29/2021 Caroline Kinney
54506
$0.64
3548101
3/29/2021 Beth Dempsey
54518
$20.00
3548101
3/29/2021 Catina Richter
54521
$0.46
3548101
3/29/2021 Michael Reckling
54534
$5.00
3548101
3/29/2021 Cody Dalga
54535
$5.00
3548101
3/29/2021 Kerri Bewick
54536
$5.00
3548101
3/30/2021 Nicole Rankin
54525
$4.00
3547031
3/30/2021 Ann Marie Sauls
54551
$0.36
3548101
3/30/2021 Mark Mudd
54553
$5.00
3547011
3/30/2021 Clarkston Community Schools
54555
$1,200.00
3547011
3/30/2021 Val Meyers
54558
$100.00
3547011
3/30/2021 Elissa Staeuble
54560
$25.00
3547011
3/30/2021 Shirley Robertson
54562
$50.00
3547011
3/30/2021 St. Andrews Episcopal Church
54564
$418.75
314701
3/30/2021 Stephen Draper
54565
$25.00
354701
3/30/2021 Paige Girbach
54575
$0.64
3548101
3/30/2021 Amber Ponke
54583
$0.18
3548101
3/30/2021 Karen Ostin
54584
$100.00
3547011
3/30/2021 Terry Phelps
54589
$5.00
3548101
3/30/2021 Cynthia Garey
54593
$0.18
3548101
3/30/2021 Erik Lessien
54595
$50.00
3548101
3/30/2021 Madison Lane
54653
$0.18
3548101
100
OAKLAND COUNTY ANIMAL CONTROL AND
PET ADOPTION CENTER
Restricted Fund (Legacy) Donations -January -
March 2021 - 2nd Quarter
3/30/2021
Denise Mason
54656
$5.00
3/30/2021
Barbara Douglas
54657
$10.00
3/30/2021
Fand Opal
54660
$0.18
3/30/2021
Jennifer Naylor
54661
$0.47
3/30/2021
Ashley Asmar
54664
$5.00
3/31/2021
Tyler Saidla
54639
$39.00
3/31/2021
Sharol Berney
54648
$0.47
3/31/2021
Megan Gerad
54669
$0.64
March 2021 Total
Q2 2021 Total
1
3548101
3548101
35481017
354810
354810
354788
3548101
3549731
$6,121.86
$28,363.36
101
Date:
9/30/2020
10/1/2020
10/9/2020
11/24/2020
12/24/2020
12/24/2020
12/29/2020
12/29/2020
12/29/2020
1/12/2021
1/14/2021
1/21/2021
1/22/2021
1/25/2021
1/27/2021
2/10/2021
2/19/2021
2/22/2021
3/1/2021
3/1/2021
3/2/2021
3/4/2021
3/12/2021
3/18/2021
3/30/2021
3/24/2021
Department of Public Services
Oakland County Children's Village
Donation Tracking : Donation Period January 2021 to March 2021
Donor: Cash/Check: Items:
M. Carriere
Middleton Farms
A. Ray
P. Richards
Senior Men's Club Birmingham
Mubea Helps Foundation
Christ Church Cranbrook
0-Meara
J. Murray
M. O'Brien
Sweet Dreams for Kids
St. Mary of The Hills
CV Foundation
The Rainbow Connection
C.Rasegon
Sweet Dreams for Kids
E. Bolster
B. Robinson
CV Foundation
Brightmoor Church
S. Piotrowicz
OC Bar Association
L. Makuch
Sweet Dreams for Kids
American Legion
St. Mary's Our Lady of the Snow's
Clothing and Toys
Pumpkins
Clothing
Check
Check
Check
Check
Check
Check
Quilts, Yarn, Books
15 Pillowcases
Check Holiday Giving Tree
Nintendo Switches, Blenders, iV's w/DVD Players
Toys
Basketball & Shoes
15 Pillowcases
50 bags of Art Supplies
Children's Shoes
Staff Incentives - Gift Cards, Coffee Mugs
MP - Rebuild Fire Pit Benches, Playgorund Cleanup
Books
Check
Craft Supplies, Radios, Toiletries
15 Pillowcases
Easter Candy Bags
Easter Donation to Fill Resident Baskets
Total:
Estimated Value:
$50.00
$260.00
$1,000.00
$100.00
$30.00
$1,850.00
$100.00
$100.00
$25.00
$360.00
$225.00
$745.00
$1,863.81
$400.00
$35.00
$225.00
$500.00
$50.00
$500.00
$500.00
$500.00
$200.00
$400.00
$225.00
$75.00
$1,750.00
$12,068.81
102
OAKLAND COUNTY PARKS & RECREATION
C nmx4TvcTnN A(7FNinA
JUNE 21 2021 AGENDA ITEM NO. FOR ADMIN'S USE
PLANNING CXRESOURCE DEVELOPMENT
To: Chairman McGillivray and Commission Members
From: Sue Wells, Interim Executive Officer
Melissa Prowse, Supervisor of Planning & Resource Development
Submitted: May 26, 2021
Subject: FY 2021 2nd Quarter Contributions Report
INTRODUCTION AND HISTORY
Attached is the FY 2021 2nd Quarter report for contributions received from January 1, 2021 through March 31,
2021.
ATTACHMENTS
FY 2021 2nd Quarter Contributions Report
STAFF RECOMMENDATION
Staff recommends the Commission receive and file the FY2021 20d Quarter Contributions Report.
MOTION
Move to receive and file the FY 2021 2nd Quarter Contributions Report.
103
Mt55t®N arch 31r 2aZ1
��REptiO� ao 1, 2011 M
RKStams150 00 .
D c�uNTV P ns l oatiorsl ' S1.0
o,i$�
ON Nc Conto'O do D
KPu
- ' {O W
12QRePo Rosaflotuxa �rpro t�jOtat
2p2 take - SF�tO Gran
fN \ectio%5-die _ --
nt�b�twn" Prima\care - - ---''�
Nt�R CC
RT.#
p{jvice nationsl
yak\and Repo 5{ rcCOntribut'O�s lD° Q°Cnse
at
Fy QUarte
T It
nd �ashl�heck $ m 5p pp TVI Genera\ D°
2021 Sec°n
D°nOr
Date _, oau\aSteWa�w�\\\ams
M
i
q®5
Resolution #21259
June 17, 2021
Moved by Gingell seconded by Hoffman the resolutions on the amended Consent Agenda be adopted.
AYES: Charles, Gershenson, Gingell, Hoffman, Jackson, Joliat, Kochenderfer, Kowall, Kuhn,
Long, Luebs, Markham, McGillivray, Miller, Moss, Nelson, Spisz, Weipert, Woodward,
Cavell. (20)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions on the amended Consent Agenda were
adopted.
ou, QLe,
I HEREBY APPROVE THIS RESOLUTION
CHIEF DEPUTY COUNTY EXECUTIVE
ACTING PURSUANT TO MCL 45.559A (7)
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Lisa Brown, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and
accurate copy of a resolution adopted by the Oakland County Board of Commissioners on June 17, 2021,
with the original record thereof now remaining in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the Circuit Court at Pontiac,
Michigan this 171h day of June, 2021. _
Lisa Brown, Oakland County