HomeMy WebLinkAboutResolutions - 2020.06.04 - 33296MISCELLANEOUS RESOLUTION #20185 June 4, 2020
BY: Commissioner Helaine Zack, Chairperson, Finance and Infrastructure Committee
IN RE: MANAGEMENT AND BUDGET - FISCAL YEAR 2020 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) 2020 Second Quarter Financial Forecast Report has identified several
variances and budget amendments are recommended; and
WHEREAS the Sheriffs 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 $93,452 is being recognized for eligible personnel, forensic lab and
training costs for corrections officers and dispatchers; and
WHEREAS a FY 2020 budget amendment of ($106,088) is recommended for the Sheriff's Office to
accurately reflect the effective date of February 1, 2020 for the Law Enforcement Service Contract
amendments approved by the Board of Commissioners on January 22, 2020 for the following townships
and cities: Addison Township (M.R. #20021), Commerce Township (M.R. #20022), Highland Township
(M.R. #20023) and City of Pontiac (M.R. #20024); and
WHEREAS a FY 2020 — FY 2022 budget amendment of $5,000 is recommended for the Sheriff's Office
reversing the amendment of $2,500 for the Transfers -In revenue line item (Account 695500) and the
Motor Pool Fuel line item (Account 776659) referenced in M.R. #20086, Fiscal Year 2020 First Quarter
Financial Forecast and Budget Amendments, as the amendment was incorrectly reflected in Schedule A.
It is also correcting the budget amendment referenced in Miscellaneous Resolution (M.R.) #19342
Department of Management and Budget - FY 2019 Third Quarter Financial Forecast and Budget
Amendments, as a budget amendment was not necessary; and
WHEREAS a correction to a program number reflected in Miscellaneous Resolution (M.R.) #20086, Fiscal
Year 2020 First Quarter Financial Forecast and Budget Amendments, is needed as the budget
amendment for the Sheriff's Office in the amount of $10,000 inadvertently referenced Contract
Enforcement program (116180) rather than Law Enforcement Admin program (110000). A budget
amendment is required to reallocate the budget to the correct program number; and
WHEREAS a FY 2020 budget amendment in the amount of $5,180 is recommended for the
Clerk/Register of Deeds Elections division to reallocate funding from the Election Supplies expenditure
line item (Account 750126) to the Maintenance Department Charges expenditure line item (Account
775754) for electrical work to upgrade the lighting to accommodate new video equipment within the
Elections Office; and
WHEREAS a FY 2020 budget amendment is recommended to reallocate $32,145 from Facilities
Administration Information Technology Operations expenditure line item budget (Account 774636) to
Facilities Planning and Engineering Information Technology Operations expenditure line item budget
(Account 774636); and
WHEREAS a FY 2020 budget amendment is recommended for the Medical Examiner's Division to
reallocate $9,000 from the Transportation Service expenditure line item (Account 732011) that was
included in the FY 2019 Year End report resolution (M.R. #19411) carry forward request into Info Tech
Operations expenditure line item (Account 774636) to reflect the actual line item to be charged to
complete the forensic case management system replacement. Miscellaneous Resolution #19098
approved the replacement project on April 18, 2019; and
WHEREAS a FY 2020 budget amendment in the amount of $161 is recommended for the Children's
Village General Fund/General Purpose (#10100) and Child Care Fund (#20293) to correct the department
and program number referenced in M.R. #20086, Fiscal Year 2020 First Quarter Financial Forecast and
Budget Amendment; and
FINANCE AND INFRASTRUCTURE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote.
WHEREAS a FY 2020 budget amendment is recommended for the Circuit Court to add funding for
Professional Services in the amount of $12,000 to reflect Amendment #1, within fifteen percent of the FY
2020 Michigan Drug Court Grant Program Fund #27130 (Adult Treatment Court) agreement (M.R.
#19406); and
WHEREAS the FY 2020 Auto Theft Prevention Authority (ATPA) original agreement (M.R. #19305) was
modified to reflect amendments #2 through #4 in which personnel changes were made between position
#06147 and position #10898. There is no fiscal impact; therefore, a budget amendment is not required;
and
WHEREAS a FY 2020 budget amendment is recommended for the Sheriff's Office FY 2020 Auto Theft
Prevention Authority (ATPA) Grant Fund #27310 to reallocate $1,500 from the Communications line item
expenditure budget (Account 730324) to the Telephone Communications internal service expenditure line
item (Account 778675) to reflect actual activity; and
WHEREAS the Sheriff's Office will receive funding from the Office of Highway Safety Planning (OHSP) for
the period of October 1, 2019 through September 30, 2020. 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 2020 budget amendment is recommended for the County Executive's Community
Census Support Fund (#29301) to reallocate the Michigan Municipal League Foundation's grant award of
$250,000 (M.R. #20100) from the revenue line item budget State Operating Grant (Account 615571) to
Contributions Operating revenue line item (Account 650104); and
WHEREAS a FY 2020 budget amendment totaling $32,923 is recommended for Community Corrections
to reallocate expenditure line items to recognize adjustments, with no net impact to the total award, to the
FY 2020 Community Corrections Comprehensive Plan Grant Fund (#27370) to reflect Amendment #1,
which is less than fifteen percent of the original agreement (M.R. #20017); and
WHEREAS a FY 2020 budget amendment is recommended for the Community Corrections Division to
recognize additional funding in the amount of $20,000 from the Michigan Department of Corrections FY
2020 Community Corrections Comprehensive Plan Grant Fund (#27370) to reflect Amendment #2, in
which the funding will be used to support pretrial defendants who have been ordered to electronic
monitoring but are no longer able to afford it due to the COVID-19 pandemic. The additional funding is
less than fifteen percent of the original agreement (M.R. #20017); and
WHEREAS a FY 2020 budget amendment of ($55,926) is recommended for the Health Division to
recognize adjustments to the FY 2020 Comprehensive Planning, Budgeting, and Contracting (CPBC)
agreement to reflect Amendment #2, which is less than fifteen percent of the original agreement (M.R.
#19285); and
WHEREAS a correction to a program number reflected in M.R. #20096, Economic and Community Affairs
— Resolution Approving the Michigan Economic Development Corporation Grant and Creation of the
Oakland County Small Business Stabilization Fund (#29245), is needed as the budget amendment
inadvertently referenced Emergency Preparedness program (115090) rather than Pandemic program
(133095). A budget amendment is required to correct the program number; and
WHEREAS a FY 2020 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 Oakland County International Airport. A budget amendment is not required. 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 2020 budget amendment is recommended for the Parks and Recreation Fund (#50800)
to transfer General Program Administration funds in the amount of $127,015 from the Facilities
Maintenance cost center to various cost centers incurring expenses during the second quarter of FY
2020. Also, per approval by the Parks and Recreation Commission at their April 22, 2020, meeting to
appropriate $12,000 from unrestricted net position for soffit painting of the administration building; and
WHEREAS a budget amendment is recommended in the amount of $200,000 to accelerate the transfer
of funding from the Non -Departmental General Fund (#10100) Radio Communications line item budget to
the Radio Communications Fund (#53600) for the planned Children's Village radio replacements
(accelerating from FY 2021 to FY 2020 to accommodate the overall Radio Replacement project); 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 2020; and
WHEREAS the Oakland County Department of Economic Development and Community Affairs has
attempted to collect funds from loan recipients for the Community Development Block Grants totaling
$55,648.39 and Home Investment Partnership Act totaling $13,550.00 and recommends $69,198.39 be
written off in uncollectible loans; and
WHEREAS the Department of Public Services, Animal Shelter and Pet Adoption Center, received
donations for the period of January 2020 through March 2020 totaling $6,573.68; and
WHEREAS the Department of Health and Human Services, Children's Village Division, received
donations for the period of January 2020 through March 2020 totaling $5,646.00 of which $1,750.00 were
cash donations; and
WHEREAS a donation is recognized in the Treasurer's Office of $2,429.12 for check #2657 dated
5/12/2020 from Treasurer Andrew Meisner for a voluntary pay cut during the COVID-19 pandemic; and
WHEREAS the Parks and Recreation Commission received donations for the period of January 2020
through March 2020 totaling $19.69.
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners accepts the
Fiscal Year 2020 Second Quarter Financial Report.
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, Treasurer's Office and Parks and Recreation Commission.
BE IT FURTHER RESOLVED that the FY 2020 — FY 2022 Budgets are amended pursuant to Schedules
A and B.
Chairperson, on behalf of the Finance and Infrastructure Committee, I move the adoption of the foregoing
resolution.
Commissioner Helaine Zack,, District #18
Chairperson, Finance and Infrastructure
Committee
lro,AKLANDF�-
COUNTYMICHIGAN
MANAGEMENT & BUDGET
TO: Members of the Finance Committee
OAKLAND COUNTY EXECUTIVE DAVID COULTER
FROM: Sean Carlson, Deputy County Executive
Lynn Sonkiss, Manager, Fiscal Services
Holly Conforti, Chief, Fiscal Services
Ebru Adoglu-Jones, Supervisor of Fiscal Services
SUBJECT: Letter of Transmittal - Fiscal Year 2020 Second Quarter Forecast
DATE: June 3, 2020
FY 2020 SECOND QUARTER REPORT
Attached please find the Fiscal Year (FY) 2020 Second Quarter Forecast Report. In total, Fiscal
Services forecasts that the County will complete FY 2020 with an overall favorable variance of
$16,176,879 in 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 split between receiving ($2,686,500) less revenue than anticipated and projected
favorability in expenditures of $18,863,379.
REVENUES
GF/GP revenues are .54% less than budget or ($2,686,500). Major variances are the result of the
following events:
A. TAXES— Favorable: $1,220,000
Favorable Taxes due to taxable value which was budgeted at 4.25% and 2020 Equalization
Report resulted in an overall value increase of 4.46%.
B. OTHER INTERGOVERNMENTAL REVENUE — Favorable: $640,000
Favorable primarily due to updated Revenue Sharing projections from the State as of October
14, 2019 and no indication from the State that the FY 2020 distribution will be reduced.
C. CHARGES FOR SERVICES — Unfavorable: ($5,005,300)
Unfavorable Ordinance Fines and Costs ($1,250,000), Probation Fees ($510,000) and State
Law Costs ($275,000) across the District Courts for the reduction in caseloads due to COVID-19
pandemic; ($885,000) Reimbursement Salaries, ($350,000) Diverted Felon, ($300,000) Drug
Testing, and ($125,000) Fingerprints and Photostats within Sheriff's Office due to reduced
activity as a result of COVID-19. Further reductions in activity due to COVID-19 include
($950,000) Payments other than Anticipated land sale activity, ($300,000) Title Search, and
($270,000) Civil Action Service Fees within the Treasurer's Office; ($225,000) Court Costs and
Mediation Fees within the Circuit Court; and ($100,000) Sale of Licenses projected for Animal
Control.
D. INVESTMENT INCOME—Favorable: $300,000
Investment income is favorable based on the actual investment income distributed to date.
Does not reflect market value adjustments which will occur at the end of the fiscal year.
2100 Pontiac Lake Road i County Executive Building 41W i Waterford, MI 48328 1 Fax (248) 452-9172 1 OakGov.conn I
E. OTHER REVENUES - Favorable: $144,000
Favorable primarily due to Health Division $108,000 for an adjustment to administrative
overhead costs and $39,500 Economic Development for contributions to the Fire and Ice
Festival.
EXPENDITURES
In total, expenditures are projected to be 3.79% under budget or $18,863,379 favorable. Many
departments have experienced personnel savings as the result of turnover and under -filling of
positions. As the year progresses this overall net favorability may increase as departments continue to
work to reduce their costs and reorganize.
There is one department projected to be unfavorable at the end of the fiscal year (barring any
amendments); Sheriff's Office.
Sheriff — Unfavorable: ($4,400,000)
• The department is forecasted to be unfavorable due to increased use of overtime, disaster
hazard pay and related fringe benefits; primarily in the Corrective Services area which is
attributable to COVID-19 pandemic. The unfavorable overtime is partially offset by favorable
salaries and fringe benefits for vacancies and turnovers.
Note that while 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.
Required 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
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 — Budoetary Perspective
The presentation reflects the true fiscal activity of the County for FY 2020:
Revenues - over/ (under) budget
Expenditures — (over)/under budget
Total Officially Reported Favorability
$ (2,686,500)
18.863,379
$ 16.176.879
GAAP Reauired Reoortina Method
Under GAAP, the Planned Use of Fund Balance is removed as a "revenue" source. The amended
revenue budget assumed the use of $49,209,753 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. Thus, when
2100 Pontiac Lake Road i County Executive Building 41W i Waterford, MI 48328 1 Fax (248) 452-9172 1 OakGov.conn 2
Use of Fund Balance is removed from the revenue calculation, the impact on the County's official
financial statements is:
Revenue
Variance
$
(2,686,500)
Reduce —
Planned use of Fund Balance
(49.209.753)
Revenue
Variance
$
(51,896,253)
Expenditure Variance (Comparing Actual to Approved Plan) 18.863.379
GAAP Reported Effect on Fund Balance 133 032 8741
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 2020 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, such as budgeting for full employment of all authorized positions and the
stringent scrutiny applied to all requested expenditures. The Budget perspective shows that the County
is projected to be favorable by $16.2 million when comparing budget to actuals.
The GAAP perspective provides information as to the effect on Fund Balance. This forecast projects
that the General Fund balance will decrease by $33.0 million by the end of Fiscal Year 2020. It is
important to note that expenditures associated with COVID-19 pandemic response are expected
to be offset by the Coronavirus Aid Relief and Economic Security Act funding allocated to
Oakland County as well as other grant/reimbursement opportunities such as FEMA
reimbursement. The County is in the process of analyzing all costs for reimbursement eligibility. Also,
the use of Fund Balance is consistent with information provided to the Finance Committee and the
Board of Commissioners, as well as what is reflected in the FY 2020-2022 Triennial Budget. The
County PLANNED to use fund balance, which has built up over the years through accelerated budget
reductions, to support operations in FY 2020. It should be noted while the amended budget reflects the
utilization of $49.2 million of Fund Balance, this forecast projects the use of Fund Balance needed to
support FY 2020 activities of $33.0 million, $16.2 million less than planned.
2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 1 Fax (248) 452-9172 1 OakGov.com 3
SCHEDULE A
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2020 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
4
FY 2020 FY 2021 FY 2022
AMENDMENTS AMENDMENTS AMENDMENTS
JGF/GP OPERATIONS - SELF
BALANCING
AMENDMENTS
GENERAL FUND (#10100)
Dept
Program
Acct
Fund Aff.
Op Unit
Account Name
SHERIFF'S OFFICE
Revenue
4030901
116240
695500
21340
Transfers In - Law Enforcement Enhance Lab Fees
$
67,009.00
4030901
110090
695500
21341
Transfers In - Law Enforcement Enhance State
7,080.00
4030701
116230
695500
21396
Transfers In - Sheriff Dispatch Training
8.944.00
4030301
112620
695500
21397
Transfers In - Sheriff Booking Fee Training
10.419.00
9010101
196030
665882
Planned Use of Balance
(7.080.00)
Total Revenue
$
86,372.00
Expenditures
4030901
116240
750203
Forensic Lab Enhancement
$
67,009.00
4030701
116230
731304
Officers Training (Dispatch)
8,944.00
4030301
112620
731304
Officers Training (Corrections)
10,419.00
Total Expenditures
$
86,372.00
Revenue
4030601
110000
632093
Sheriff Special Deputies
$
(109,709.00)
Planned Use of Balance
3,621 00
Total Revenues
$
(106,088.00)
Expenditures
4030601
116180
702010
40010
Salaries
$
(6,910.00)
4030601
116180
702010
40040
Salaries
(17,733.00)
4030601
116180
702010
40060
Salaries
(315.00)
4030601
116180
702010
40420
Salaries
(42,068.00)
4030601
116180
722900
40010
Fringe Benefit Adjustment
(4,306.00)
4030601
116180
722900
40040
Fringe Benefit Adjustment
(8,079.00)
4030601
116180
722900
40420
Fringe Benefit Adjustment
(21,523.00)
4030601
116180
731304
40010
Officers Training
(54.00)
4030601
116180
731304
40040
Officers Training
(324.00)
4030601
116180
731304
40420
Officers Training
(216.00)
4
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2020 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
JGF/GP OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL FUND (#101001
Dept
Program
Acct
Fund Aff. Op Uni[
Account Name
4030601
116180
750070
40010
Deputy Supplies
4030601
116180
750070
40040
Deputy Supplies
4030601
116180
750070
40420
Deputy Supplies
4030601
116180
750581
40010
Uniforms
4030601
116180
750581
40040
Uniforms
4030601
116180
750581
40420
Uniforms
4030601
116180
772618
40010
Equipment Rental
4030601
116180
772618
40420
Equipment Rental
4030601
116180
773535
40010
Info Tech CLEMIS
4030601
116180
773535
40040
Info Tech CLEMIS
4030601
116180
773535
40420
Info Tech CLEMIS
4030601
116180
773637
40010
Info Tech Equipment Rental
4030601
116180
773637
40420
Info Tech Equipment Rental
4030601
116180
774677
40010
Insurance Fund
4030601
116180
774677
40040
Insurance Fund
4030601
116180
774677
40420
Insurance Fund
4030701
116180
778675
40010
Telephone Communications
Total Expenditures
Revenue
4030901
110090
695500
21341
Transfersln
Expenditures
4030901 110090 779959
Expenditures
4030601 116180 750070
4030601 110000 750070
Total Revenue
Motor Pool Fuel
Total Expenditures
Deputy Supplies
Deputy Supplies
Total Expenditures
6144:1:1111
FY 2020 FY 2021 FY 2022
AMENDMENTS AMENDMENTS AMENDMENTS
p
9
(119.00)
(720.00)
(479.00)
(61.00)
(366 00)
(244.00)
(257.00)
(257.00)
(25.00)
(150.00)
(100.00)
(127.00)
(126.00)
(133.00)
(796.00)
(530.00)
(70.00)
$ (106,088.00)
$
5,000.00
$ 5,000.00
$ 5,000.00
$
5,000.00
$ 5,000.00
$ 5,000.00
$
5,000.00
$ 5,000.00
$ 5,000.00
$
5,000.00
$ 5,000.00
$ 5,000.00
$
10,000.00
$ 10,000.00
$ 10,000.00
(10,000.00)
(10,000.00)
(10,000.00)
5
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2020 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
jGF/GP OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL FUND I#101001
Dept Program Acct Fund Aff. Oa Unit
CLERK/REGISTER OF DEEDS - ELECTIONS DIVISION
Expenditures
2010301 185010 750126
9010101 148050 775754
FACILITIES ADMINISTRATION
Expenditures
1040101 140000 774636
1040801 148020 774636
PUBLIC SERVICES - MEDICAL EXAMINERS DIVISION
Expenditures
1070601 132030 732011
1070601 132030 774636
NON -DEPARTMENT
Expenditures
9010101 112700 788001 20293
1060501 112090 788001 20293
Account Name
Election Supplies
Non -Dept. Maintenance Dept Charges
Total Expenditures
Info Tech Operations
Info Tech Operations
Total Expenditures
Transportation Service
Info Tech Operations
Total Expenditures
Transfers -Out Child Care Fund
Transfers -Out Child Care Fund
Total Expenditures
SCHEDULE A
FY 2020 FY 2021 FY 2022
AMENDMENTS AMENDMENTS AMENDMENTS
$ (5,180.00)
5,180.00
$ (32,145.00)
32,145.00
$ (9,000.00)
9,000.00
$ 161.00
(161.00)
77
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2020 SECOND QUARTER BUDGET AMENDMENTS
GENERAL FUND/GENERAL PURPOSE (GF/GP)
IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS
GENERAL FUND (#101001,
Dept Program Acct Fund Aff. On Unit
CHILD CARE FUND (#202931
Revenues
1060501 112090 695500 10100
9090101 112700 695500 10100
NON -DEPARTMENT
Revenue
9010101 196030 665882
9010101 196030 665882
Expenditures
9010101 152130 777560 53600
9090101 196030 777560
Account Name
Transfers -In General Fund
Transfers -In General Fund
Total Revenues
Planned Use of Balance
Planned Use of Balance
Total Revenues
Transfer Out - Radio Fund
Radio Communications
Total Expenditures
6.183:1:4oil] I W-11
FY 2020 FY 2021 FY 2022
AMENDMENTS AMENDMENTS AMENDMENTS
I
$ (161.00)
161.00
$ 200,000.00 $ -
- (200,000.00)
$ 200,000.00 $ (200,000.00)
$ 200,000.00 $ -
- (200,000.00)
$ 200,000.00 $ (200,000.00)
7
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2020 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
FY 2020 FY 2021 FY 2022
AMENDMENTS AMENDMENTS AMENDMENTS
1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aff Oper Unit
Account Name
Sheriff - LAW ENFORCEMENT ENHANCE LAB FEES 1#213401
Revenue
4030901 116240 665882
Planned Use of Balance
$
67,009.00
Total Revenue
$
67,009.00
Expenditures
4030901 116240 788001 10100
Transfers Out- General Fund
$
67,009.00
Total Expenditures
$
67,009.00
Sheriff - LAW ENFORCEMENT ENHANCE STATE 1#213411
Revenue
4030901 110090 665882
Planned Use of Balance
$
7,080.00
Total Revenue
$
7,080.00
Expenditures
4030901 110090 788001 10100
Transfers Out- General Fund
$
7,080.00
Total Expenditures
$
7,080.00
Sheriff - SHERIFF DISPATCH TRAINING !#213961
Revenue
4030701 112630 665882
Planned Use of Balance
$
8,944.00
Total Revenue
$
8,944.00
Expenditures
4030701 112630 788001 10100
Transfers Out- General Fund
$
8,944.00
Total Expenditures
$
8,944.00
Sheriff -SHERIFF BOOKING FEE TRAINING 4213971
Revenue
4030301 112620 665882
Planned Use of Balance
$
10,419.00
Total Revenue
$
10,419.00
8
SCHEDULE B
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2020 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
FY 2020 FY 2021 FY 2022
AMENDMENTS AMENDMENTS AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aff Oper Unit Account Name
Expenditures
4030301 112620 788001 10100 Transfers Out - General Fund $ 10,419.00
Total Expenditures $ 10,419 00
CIRCUIT COURT - DRUG COURT ADULT SCAO (#271301
GR00D0000233 Activity: GLB, Analysis Type: GLB, Budget Reference: 2020
Revenue
3010301 121200 615571 State Operating Grants $ 12,000 00
Total Revenue $ 12,000 00
Expenditure
3010301 121200 731458 Professional Services S 12,000.00
Total Expenditure $ 12,000.00
SHERIFF - AUTO THEFT PREVENTION AUTHORITY (ATPAI (#273101
Grant # GR0000000377 Activity: GLB Analysis: GLB Budget Reference 2020
Expenditures
4030901 116270 730324
Communications
$
(1,500.00)
4030901 116270 778675
Telephone Communication
1,500.00
Total Expenditures
$
-
COUNTY EXECUTIVE - CENSUS SUPPORT PLAN (#29301)
GR0000000924 Activity: GLB, Analysis Type: GLB Budget Reference 2020
Revenue
1010101 181000 615571
State Operating Grants
$
(250,000 00)
1010101 181000 650104
Contributions Operating
250,000.00
Total Revenue
$
-
9
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2020 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY/ SPECIAL REVENUE FUNDS
FY 2020
AMENDMENTS
1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID Program Acct Fund Aff Oper Unit Account Name
COMMUNITY CORRECTIONS COMPREHENSIVE GRANT (#2737011
GR0000000772 Activity. GLB Analysis Type: GLB Budget Reference 2020
Expenditures
1070401
113130
730373
Contracted Services
$
(5,200.00)
1070401
113020
702010
Salary
(11,209
00)
1070401
113020
722740
Fringe Benefits
(6,035.00)
1070401
113120
702010
Salary
(6,811.00)
1070401
113120
722740
Fringe Benefits
(3,668.00)
1070401
123010
702010
Salary
5.581.00
1070401
123010
722740
Fringe Benefits
3,00500
1070401
113130
702010
Salary
15,819.00
1070401
113130
722740
Fringe Benefits
8,518.00
Total Expenditures
$
-
COMMUNITY CORRECTIONS
COMPREHENSIVE
GRANT (#27370)
GR0000D00772
Activity: GLB
Analysis Type: GLB Budget
Reference: 2020
Revenue
1070401
113180
615571
State Operating Grants
$
20,000.00
Total Revenue
$
20,000.00
Expenditures
1070401
113130
730373
Contracted Services
$
20,000
00
Total Expenditures
$
20,000
00
HIV Prevention
(#285571
GR00o000O194
Activity: GLB AnalysisGLB Bud
Reference 2020
Revenues
1060294
133940
610313
Federal Operating Grants
$
(34,704.00)
1060294
133940
615571
State Operating Grants
(85,296.00)
Total Revenues
$
(120,000.00)
SCHEDULE IS
FY 2021 FY 2022
AMENDMENTS AMENDMENTS
10
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2020 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
SCHEDULE B
FY 2021 FY 2022
AMENDMENTS AMENDMENTS
11
FY 2020
AMENDMENTS
PROPRIETARY
/ SPECIAL
REVENUE FUNDS
- SELF BALANCING AMENDMENTS
Dept ID
Program
Acct Fund
Aff Oper Unit Account Name
Expenditures
1060294
133940
702010
Salaries Regular
$
(76,933
00)
1060294
133940
722740
Fringe Benefits
(31,752.00)
1060294
133940
730072
Advertising
(10,500.00)
1060294
133940
730926
Indirect Costs
(10,375.00)
1060294
133940
730982
Interpreter Fees
60000
1060294
133940
731031
Laboratory Fees
(2,000.00)
1060294
133940
731997
Transportation of Clients
(5,102
00)
1060294
133940
732165
Workshops & Meetings
50000
1060294
133940
750245
Incentives
1,200.00
1060294
133940
750301
Medical Supplies
10,000
00
1060294
133940
750567
Training -Educational Supplies
1,101.00
1060294
133940
774636
Info Tech Operations
1,77500
1060294
133940
774637
Info Tech Managed Print Svcs
68200
1060294
133940
774677
Insurance Fund
4200
1060294
133940
778675
Telephone Communications
762.00
Total Expenditures
$
(120,000.00)
PHEP 1#286101
GR0000000796
Activity. GLB
Analysis: GLB
Budget Reference: 2020
Revenues
1060290
115010
610313
Federal Operating Grants
$
1,133.00
Total Revenues
$
1,133.00
Expenditures
1060290
115010
702010
Salaries Regular
$
5,883.00
1060290
115010
722740
Fringe Benefits
3,980.00
1060290
115010
730926
Indirect Costs
265.00
1060290
115010
731388
Printing
(278.00)
1060290
115010
750077
Disaster Supplies
(8,000.00)
SCHEDULE B
FY 2021 FY 2022
AMENDMENTS AMENDMENTS
11
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2020 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS
FY 2020
AMENDMENTS
PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID
Program
Acct
Fund Aff Oper Unit Account Name
1060290
115010
750399
Office Supplies
(2,000
00)
1060290
115010
770631
Bldg Space Cost Allocation
630.00
1060290
115010
778675
Telephone Communications
653.00
Total Expenditures
$
1,13300
CRI (#286101
GR0000000796
Activity:
GLB Analysis:
GLB Budget Reference: 2020
Revenues
1060290
115035
610313
Federal Operating Grants
$
263.00
Total Revenues
$
263.00
Expenditures
1060290
115035
702010
Salaries Regular
$
2,52600
1060290
115035
722740
Fringe Benefits
1,35300
1060290
115035
730926
Indirect Costs
15.00
1060290
115035
750077
Disaster Supplies
(2,291.00)
1060290
115035
770631
Bldg Space Cost Allocation
605.00
1060290
115035
774636
Info Tech Operations
(2,448.00)
1060290
115035
774677
Insurance Fund
108.00
1060290
115035
778675
Telephone Communications
395.00
Total Expenditures
$
263.00
TB Control (#2855611
GR0000000192
Acatvity:
GLB Analysis
GLB Budget Reference: 2020
Revenue
1060235
133970
610313
Federal Operating Grants
$
(10,406.00)
Total Revenues
$
(10,406.00)
Expenditures
1060235
133970
702010
Salaries Regular
$
(3,440
00)
1060235
133970
722740
Fringe Benefits
(199.00)
1060235
133970
730926
Indirect Costs
(471.00)
1060235
133970
731031
Laboratory Fees
(3,015.00)
SCHEDULE B
FY 2021 FY 2022
AMENDMENTS AMENDMENTS
12
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2020 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY/ SPECIAL REVENUE FUNDS
MI Health & Wellness 4X4 Plan 1#283201
GR0000000696 Activity: GLB Analysis: GLB Budget Reference: 2020
Revenues
1060241 133390 615571 State Operating Grants $ 73,084.00
Total Revenues $ 73,084.00
Expenditures
FY 2020
1060241
133390
702010
Salaries Regular
AMENDMENTS
00
I PROPRIETARY! SPECIAL
REVENUE
FUNDS - SELF BALANCING AMENDMENTS
Fringe Benefits
1,29700
Dept ID
Program
Acct
Fund Aff Oper Unit Account Name
Advertising
7,50000
1060235
133970
731346
Personal Mileage
(1,51300)
7,00000
1060235
133970
731997
Transportation of Clients
(100
00)
1060235
133970
732018
Travel and Conference
(2,000
00)
1060235
133970
750245
Incentives
(700.00)
464.00
1060235
133970
750301
Medical Supplies
20000
7,500.00
1060235
133970
750399
Office Supplies
44.00
500.00
1060235
133970
750448
Postage -Standard Mailing
802.00
100.00
1060235
133970
774677
Insurance Fund
(14.00)
2,500.00
1060241
133390
Total Expenditures
$ (10,406.00)
4,000.00
MI Health & Wellness 4X4 Plan 1#283201
GR0000000696 Activity: GLB Analysis: GLB Budget Reference: 2020
Revenues
1060241 133390 615571 State Operating Grants $ 73,084.00
Total Revenues $ 73,084.00
Expenditures
1060241
133390
702010
Salaries Regular
$ 22.478
00
1060241
133390
722740
Fringe Benefits
1,29700
1060241
133390
730072
Advertising
7,50000
1060241
133390
730373
Contracted Services
7,00000
1060241
133390
730926
Indirect Costs
2,666.00
1060241
133390
730982
Interpreter Fees
20000
1060241
133390
731346
Personal Mileage
464.00
1060241
133390
731388
Printing
7,500.00
1060241
133390
731941
Training
500.00
1060241
133390
732018
Travel and Conference
100.00
1060241
133390
732165
Workshops and Meeting
2,500.00
1060241
133390
750245
Incentives
4,000.00
1060241
133390
750294
Material and Supplies
5,83200
1060241
133390
750392
Metered Postage
9,000.00
SCHEDULE B
FY 2021 FY 2022
AMENDMENTS AMENDMENTS
13
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2020 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY/ SPECIAL REVENUE FUNDS
Expenditures
1090101 133095 731598
1090101 115090 731598
PARKS AND RECREATION FUND (#508001
Revenues
5060666 160666 665882
Regranting Program
Total Expenditures
Planned Use of Balance
Total Revenues
Expenses
FY 2020
160430
730789
General Program Administration
5060715
AMENDMENTS
PROPRIETARY / SPECIAL
REVENUE FUNDS - SELF BALANCING
AMENDMENTS
160010
Dept ID
Program
Acct Fund AH Oper Unit
Account Name
730198
1060241
133390
750399
Office Supplies
500.00
1060241
133390
750567
Training -Educational Supplies
1,447.00
1060241
133390
774677
Insurance Fund
100.00
730814
Grounds Maintenance
Total Expenditures
$ 73,084.00
MICHIGAN ECONOMIC
DEVELOPMENT (#2924511
GR0000000923 Activity: GLB Analysis. GLB Budge[ Reference: 2020
Revenue
1090101
133095
615571
State Operarting Grants
1,150,000.00
1090101
115090
615571
State Operarting Grants
(1,150,000.00)
1090101
133095
695500 10100
Transfers - In
1,850,000.00
1090101
115090
695500 10100
Transfers - In
(1,850,000.00)
Total Revenue
-
Expenditures
1090101 133095 731598
1090101 115090 731598
PARKS AND RECREATION FUND (#508001
Revenues
5060666 160666 665882
Regranting Program
Total Expenditures
Planned Use of Balance
Total Revenues
Expenses
5060910
160430
730789
General Program Administration
5060715
160070
730198
Building Maintenance Charges
5060327
160010
730198
Building Maintenance Charges
5060720
160070
730198
Building Maintenance Charges
5060732
160070
730373
Contracted Services
5060735
160070
730373
Contracted Services
5060910
160430
730653
Equipment Rental
5060715
160070
730814
Grounds Maintenance
3,000,000.00
(3,000,000.00)
$ 12,000.00
$ 12,000.00
$ 12,000.00
2,874.00
1,227.00
70.00
3,85600
936.00
11,447 00
28,026.00
SCHEDULE B
FY 2021 FY 2022
AMENDMENTS AMENDMENTS
14
OAKLAND COUNTY, MICHIGAN
FISCAL YEAR 2020 SECOND QUARTER BUDGET AMENDMENTS
PROPRIETARY/ SPECIAL REVENUE FUNDS
FY 2020
AMENDMENTS
PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS
Dept ID
Program
Acct
Fund Aff Oper Unit Account Name
$
200,000.00
5060870
160210
730814
Grounds Maintenance
5,700.00
$
5060327
160010
730814
Grounds Maintenance
6,483.00
5060720
160070
730814
Grounds Maintenance
17,104.00
731780
5060765
160070
730814
Grounds Maintenance
1,782.00
115150
5060725
160070
730814
Grounds Maintenance
3,071
00
5060724
160070
730814
Grounds Maintenance
40000
5060760
160070
730814
Grounds Maintenance
5,468.00
200,000.00
5060330
160010
730814
Grounds Maintenance
9,633.00
5060326
160010
730814
Grounds Maintenance
17,563.00
5060735
160070
730814
Grounds Maintenance
4,67500
5060910
160430
731388
Printing
1,100.00
5060715
160070
731633
Rental Property Maintenance
1,331.00
5060910
160430
750154
Expendable Eqjuipment
4,269.00
5060910
160430
730789
General Program Administration
(127,015.00)
Total Expenses
$ 12,000.00
RADIO FUND (#53600)
Revenue
1080310
115150
695500 10100
Operating Transfers In - General Fund
$
200,000.00
Total Revenue
$
200,000.00
Expenses
1080310
115150
731780
Software Support Maintenance
$
1,175.00
1080310
115150
773630
Info Tech Development
61,940.00
1080310
115150
750170
Other Expendable Equipment
136,885.00
Total Expenses
$
200,000.00
SCHEDULE B
FY 2021 FY 2022
AMENDMENTS AMENDMENTS
i &I
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
16
FY 2020
BUDGET
AMOUNT
ADOPTED
AS
FY 2020
FAVORABLE/
BUDGET
AMENDED
FORECAST
(UNFAVORABLE)
PERCENT
REVENUES
GENERALFUND
Taxes
$ 246,169,33700
$
246,169,33700
$
247,389,33700
$
1,220,00000
050%
Federal Grants
1,030,571 00
1,134,349 00
1,149,149.00
14,800.00
1 30 %
State Grants
19,383,42800
19,503,30400
19,503,304.00
-
000%
Other Intergovernmental Revenue
45,322,88000
45,348,38000
45,988,38000
640,00000
141%
Charges for Services
116,168,01500
119,169,69900
114,164,39900
(5,005,30000)
-420%
Indirect Cost Recovery
9,050,00000
9,050,00000
9,050,00000
-
000%
Investment Income
1,954,70000
1,954,70000
2,254,700.00
300,00000
1535%
Other Revenues
5,934,00000
5,970,43600
6,114,43600
144,00000
241%
SUB -TOTAL GENERAL FUND/GENERAL PURPOSE
$ 445,012,93100
$
448,300,205.110
$
445,613,70500
$
(2,686,50000)
-060%
PLANNED USE OF FUND BALANCE
$ 30,606,43800
$
49,209,75314
$
49,209,75314
$
-
000%
TOTAL GF/GP FUNDS
$ 475,619,369.00
$
497,509,958.14
$
494,823,458.14
$
(2,686,500.00)
-0.54%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Cecua Court
$ 49,011,35900
$
51,620,89107
48,442,89107
$
3,178,00000
616%
52nd District Court
17,673,76500
17,744,90300
17,376,203 00
368,70000
208%
Probate Court
6,994,93700
7,074,61002
6,950,610.02
124,00000
175%
TOTAL ADMIN. OF JUSTICE
$ 73,680,061.00
$
76,440,404.09
$
72,769,704.09
$
3,670,700.00
4.80%
LAW ENFORCEMENT
Prosecuting Attorney
21,650,43000
21,755,15900
20,980,95900
774,20000
356%
Sheriff
163,323,69600
166,546,35047
170,946,35047
(4,400,000.00)
-264%
TOTAL LAW ENFORCEMENT
$ 184,974,026.00
$
188,301,509.47
$
191,927,309.47
$
(3,626,800.00)
-1.93%
GENERAL GOVERNMENT
Clerk/Register of Deeds
11,111,93500
11,260,59324
9,728,09324
1,532,50000
1361%
Treasurer
8,680,73000
9,018,16200
7,334,01200
1,684,15000
1868%
Board of Commissioners
4,780,00700
5,693,13000
5,578,13000
115,00000
2.02%
Water Resources Commissioner
7,901,02000
8,039,299.00
8,024,39900
14,90000
0.19%
TOTAL GENERAL GOVERNMENT
$ 32,473,692.00
$
34,011,111
$
30,664,634.24
$
3,346,550.00
9.84%
COUNTY EXECUTIVE
County Executive Adam
$ 8,413,63600
$
9,084,883.55
$
8,80108355
$
283,80000
312%
Management and Budget
20,680,59700
20,900,434.23
19,690,97823
1,209,45600
5.79%
Central Services
2,710,00700
2,718,1323 OD
2,710,62300
8,20000
030%
Facilities Management
1,627,45800
1,656,54500
1,554,49500
102,05000
616%
Human Resources
4,392,17900
4,838,36300
4,413,36300
425,00000
878%
Health and Human Services
67,386,22600
72,070,565.63
69,964,36563
2,106,200 00
292%
Public Services
19,242,84900
19,501,16400
18,828,66400
672,50000
345%
Economic Dior and Comm Affairs
9,026,52400
9,738,671.93
9,216,67193
522,00000
536%
TOTAL COUNTY EXECUTIVE
$ 133,479,476.00
$
140,509,450.34
$
135,180,244.34
$
5,329,206.00
3.79%
TOTALDEPARTMENTS
$ 424,607,25500
$
439,262,548.14
$
430,541,89214
$
8,720,65600
199%
NON -DEPARTMENTAL APPROPRIATIONS
TOTAL NON -DEPARTMENTAL
$ 51,012,114.00
$
68,247,41000
$
48,104,68700
$
10,142,72300
1741%
TOTAL GOVERNMENTAL EXPENDITURES
$ 475,619,369.00
$
497,509,958.14
$
478,646,579.14
$
18,863,379.00
3.79%
General Fund/General Purpose
Favorable/(Unfavorable)- Budget Perspective
$ -
$
-
$
16,176,879.00
$
16,176,879.00
GAAP Required Adjustment (eliminating use of fund balance
"revenue")
$
(49,209,753 14)
GAAP - BASED REPORT (forecasted impact on Fund Balance)
($33,032,874.14)
16
TAXES 1601000-6019991
Property Taxes - July Tax Levy
Other Taxes - Delinquent Tax - Prior Years
Treasurer Payment in Lieu of Taxes
Other Taxes - Trailer Tax
Total Taxes
FEDERAL GRANTS (610000-610999)
Sheriff - Patrol
Shenff - Corrective Services
COUNTY OF OAKLAND
GENERAL FUND/ GENERAL PURPOSE REVENUES
FY 2020 SECOND QUARTER REPORT
Sheriff - Investigative/Forensic Services
-
35,00000
AMOUNT
20,00000
ADOPTED
AMENDED
FY 2020
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE]_
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 245,640,837 00
$ 245 640 837 00
$ 246,760,83700
$ 1 120,000 00
0 46 % Fax due to taxable value which was budgeted at 4 25%
predominantly due to COVID-19 pandemic
and 2020 Equalization Report resulted in an overall value
58,50000
70,718.00
79,518.00
8,80000
increase of 4 46%.
98,500 00
98,500.00
98,500 00
-
0 00 %
350,000 00
350,000 00
450,000 00
100,000 00
28 57 % Fav Due to payments from the State on DNR land
80,000 00
80,000.00
8000000
-
0 00 %
$ 246,169,337.00
$ 246,169,337.00
$ 247,389,337.00
$ 1,220,000.00
0.50%
$ -
$ 31,82400
$ 31,82400
S -
000%
-
23,953 00
23,953 00
-
0 00 %
Sheriff - Investigative/Forensic Services
-
35,00000
55,00000
20,00000
5714% Fay. Due to timing of funding for the High l ntensity, Drug
Trafficking Areas (HIDTA) Grant
Prosecuting Attomey
205,00000
205,00000
191,00000
(14,00000)
-683%Unfay. due to lower than anticipated revenue
predominantly due to COVID-19 pandemic
Homeland Security- Disaster Control
58,50000
70,718.00
79,518.00
8,80000
1244% Fav due to timing of funding for the FY 2019 Emergency
Management Performance Grant $5 000 and from
Hazardous Matenals Emergency Preparedness Grant
$3800
Health Division
467,07100
467,85400
467,85400
-
000%
Children's Village
300,000.00
300,00000
300,00000
-
000%
Total Federal Grants
$ 1,030,571.00 $
1,134,349.00
$ 1,149,149.00
$ 14,800.00
1.30%
STATE GRANTS (615000-615999)
Sheriff -Patrol
$ - $
-
$ -
$ -
000%
State Match Foster Care
1 000 00
1,00000
1,00000
-
000%
Prosecuting Attorney
-
-
-
-
0 00 %
Economic Development
-
-
-
-
0 00 %
Health Division
5,323,35500
5,335,94500
5,335,94500
-
000%
Water Resources Commissioner
-
-
-
-
0.00%
Public Services- Veteran's Services
-
-
-
-
000%
Non -Departmental- Child Care Subsidy
14,059,073.00
14,166 359 00
14,166 359 00
-
000%
Total State Grants
$ 19,383,428.00 $
19,503,304.00
$ 19,503,304.00
$ -
0.00%
OTHER INTER -GOVERNMENTAL REVENUES(620000-626999)
Non -Departmental
$ 43036,846.00 $
43,036,846.00
$ 43,706,846.00
S 670,00000
156%Fav based on the Stales updated Revenue Sharing
protections as of 10/14/19 and no indication from the state
that the FY 2020 distribution well be reduced
HHS- Homeland Security
9,00000
34,50000
34,50000
-
000%
Circuit Court
4,50000
4,50000
4,50000
-
0 00 %
District Court
1,800.00
1,800.00
1,80000
-
000%
Sheriff
276,550 00
276,550 00
246,550.00
(30,000 00)
-10 85% Unfav Social Security Incentive Payments as a result of
less inmates in tail due to COVID-19 Funds are collected
from tail inmates receiving SSI for cost of incarceration
17
Non -Departmental - Remb Judges Salaries
Total Other Intergovernmental Revenue
CHARGES FOR SERVICES (630000-635999)
Administration of Justice
Circuit Court - Judicial/Admmistratlon
Circuit Court - Civil/Criminal
Circuit Court- Family Division
District Court - Division I (Novi)
District Court - Division II (Clarkston)
District Court - Division III (Rochester Hills)
District Court- Division IV (Troy)
Probate Court- Estates and Mental Health
Total Administration of Justice
COUNTY OF OAKLAND
GENERAL FUND/ GENERAL PURPOSE REVENUES
FY 2020 SECOND QUARTER REPORT
AMOUNT
ADOPTED AMENDED 12020 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLEI PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
1,994,18400 1,994,18400 1,994,184.00 - 000%
$ 45,322,880.00 $ 45,348,380.00 $ 45,988,380.00 $ 640,000.00 1.41%
$ - $ - $ - $ - 000%
1,526 000 00 2,641,200 00 2,416,200 00 (225,000 00) -852% Unfay. Court Costs ($200,000) and Mediation Fines
($25,000) due to lower than anticipated revenue The
overarching cause of the variances identified above is also
due to the COVID-19 pandemic
1,771,500 00 1,771,500.00 1,606,500 00 (165 000 00) -931% Unfav Govt Benefit Board and Care ($85,000) along with
Board and Care ($80,000) due to a decrease in activity
The overarching cause of the variances identified above is
also due to the COVI D-19 pandemic
3 665,117 00 3,845,11200 2,985,117 00 (860,000 00) -2237% Unfav Ordinance Fines and Costs ($400.000); Probation
Fees ($175,000), State Law Costs (5150,000), Community
Service Oversight ($50,000), Refund Fees PD Def Attorney
($45,000), as well as Assessments and PSI ($40,000)
partially due to the reduction in caseload from marijuana
legalization The overarching cause of the variances is also
due to COVID-19 pandemic
1 681,200 00 1,756,200.00 1.611 200 00 (145,000 00) -8.26% Unfav Ordinance Fines and Costs ($100,000) partially due
to the reduction in caseload from marijuana legalization
and partially due to the pandemic Unfav State Law Costs
($25,000) along with Probation Fees ($20,000) due to the
COVID-19 pandemic
3 561,537 00 3,643,537 00 3,318 537 00 (325,000.00) -892% Unfay. Probation Fees ($170,000) along with Ordinance
Fines and Costs ($150,000) partially due to change in the
marijuana statute (making it a civil infraction) and partially
duetothe COVVD-19pandemic Unfav State Law Costs
($50,000) due to the pandemic. Partially offset by fav Late
Penalty $45 000 due to continued collection efforts
2207,30000 2,347,30000 1,742,30000 (605,00000) -2577% Unfav Ordinance Fines and Costs($350,000) partially due
to the reduction in caseload from marijuana legalization
and partially due to COVID-19 pandemic Unfav Probation
Fees ($145,000), Refund Fees PD Def Attorney ($60,000);
as well as State Law Costs ($50,000) due to the pandemic
561,60000 561,60000 401,60000 (160,00000)
$ 14,974,25400 $ 16,566,45400 $ 14,081454.00 $ (2,485,00000)
-2849% Unfay. Gross Estate Fees ($100,000) due to a decrease in
fees paid Unfav Certified Copies ($45,000) due to a
decrease inactivity Unfav Refund Fees PD Def Attorney
($15,000) due to a decrease In fees collected The
overarching cause of the variances identified above is also
due to the COVID-19 pandemic
-1500%
18
Law Enforcement
Prosecutmg Attorney
Shenfrs Office
Sheriff - Administrative Services
Sheriff - Corrective Services
Sheriff - Corrective Services Satellites
Sheriff - Emergency Response and Prep
Sheriff - Patrol Services
Sheriff - Emergency Communications Operations
Shenff - Investigative Forensic Services
Total Law Enforcement
COUNTY OF OAKLAND
GENERAL FUND/ GENERAL PURPOSE REVENUES
FY 2020 SECOND QUARTER REPORT
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
-1655% Unfav State Approp Victim Witness ($115,000) due to
unreimbumable salaries forfurloughed employees and
Reimb General ($16,000) from 46th District Court due
COVID-19 pandemic
103 45 % Fav Reimb General $2,000 from abandoned vehicle
auction and DNA Testing Fees $1,000 due to increased
activity
-3259% Unfav Fingerprints ($100,000), Photostats ($25,000) and
Registration Fees ($10 000) due to reduced activity as a
result of COVID-19, partially offset by fav_ Freedom of
Information Act (FOIA) Fees $10,000 due to increased
requests
-1704% Unfav Diverted Felon ($350 000) due to a reduction in the
number of inmates that meet reimbursement omens,
Inmate Board and Care ($125,000) due to inmates inability
to pay, OUIL Third Offense ($30,000) due to a reduction in
court driven assessments and Clinic Charges ($28,000)
from inmates inability to reimburse for clinic services The
reduction in the numberof inmates in responseto COVID-
19 is the major contributing factor
-1410% Unfav Board and Care ($44,000) due to a reduction in the
number of eligible inmates housed at the jail in response to
COVID-19 and Reimb Court Services ($35000) for court
security to non 52nd District Courts which are realizing
lower court activity due to COVID-19
2222% Unfav Civil Action Service Fees ($90,000) due to a
reduction in services due to COVID-19 pandemic; partially
offset by Reimbursement General $20,000 due to
unbudgeled training fees
-161% Unfav Reimbursement Salaries ($885,000) as it is
unknown at this time if OTE Energy Music Theatre and
Meadow Brook Amphitheatre vnll continue events this year
due to COVID-19 pandemic and this will be offset by less
overtime for cancelled events Also unfav Impound Fees
due to lower activity
000%
-2396% Unfav Drug Testing ($300,000) as the Results testing
program was shut down due to COVID-19 pandemic and it
is not known when it will reopen Partially offset by
favorable expenditures
-331%
19
AMOUNT
ADOPTED
AMENDED
FY 2020
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE)
$ 815,54900 $
815,54900
680,54900
$ (135,00000)
2 900 00
2,90000
5 900 00
3,000 00
383,500 00
383,500 00
258,500 00
(125,000 00)
3031,26600
3,139,680.00
2,604,68000
(535,00000)
567,34100
56734100
487,34100
(80,00000)
315,000.00
315,000 00
245,000 00
(70,000 00)
54,718 948 00
55 992,422 00
55,092,42200
(900,00000)
2,32520800
2,311,80600
2,311,80600
-
1,215 00000
1 252,298 00
952,298 00
(300,000 00)
$ 63,374,71200 $
64,780,49600 $
62,638,49600
$ (2,142,00000)
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
-1655% Unfav State Approp Victim Witness ($115,000) due to
unreimbumable salaries forfurloughed employees and
Reimb General ($16,000) from 46th District Court due
COVID-19 pandemic
103 45 % Fav Reimb General $2,000 from abandoned vehicle
auction and DNA Testing Fees $1,000 due to increased
activity
-3259% Unfav Fingerprints ($100,000), Photostats ($25,000) and
Registration Fees ($10 000) due to reduced activity as a
result of COVID-19, partially offset by fav_ Freedom of
Information Act (FOIA) Fees $10,000 due to increased
requests
-1704% Unfav Diverted Felon ($350 000) due to a reduction in the
number of inmates that meet reimbursement omens,
Inmate Board and Care ($125,000) due to inmates inability
to pay, OUIL Third Offense ($30,000) due to a reduction in
court driven assessments and Clinic Charges ($28,000)
from inmates inability to reimburse for clinic services The
reduction in the numberof inmates in responseto COVID-
19 is the major contributing factor
-1410% Unfav Board and Care ($44,000) due to a reduction in the
number of eligible inmates housed at the jail in response to
COVID-19 and Reimb Court Services ($35000) for court
security to non 52nd District Courts which are realizing
lower court activity due to COVID-19
2222% Unfav Civil Action Service Fees ($90,000) due to a
reduction in services due to COVID-19 pandemic; partially
offset by Reimbursement General $20,000 due to
unbudgeled training fees
-161% Unfav Reimbursement Salaries ($885,000) as it is
unknown at this time if OTE Energy Music Theatre and
Meadow Brook Amphitheatre vnll continue events this year
due to COVID-19 pandemic and this will be offset by less
overtime for cancelled events Also unfav Impound Fees
due to lower activity
000%
-2396% Unfav Drug Testing ($300,000) as the Results testing
program was shut down due to COVID-19 pandemic and it
is not known when it will reopen Partially offset by
favorable expenditures
-331%
19
COUNTY OF OAKLAND
GENERAL FUND/ GENERAL PURPOSE REVENUES
FY 2020 SECOND QUARTER REPORT
Water Resources Commissioner
Total General Government
County Executive
County Exec - Compliance Office
County Exec -Corp Counsel
County Exec - Admin
M&B - Equalization Division
M&B - Fiscal Services Division
Central Services - Support Services
3,305,86100 3,305,86100 330586100
$ 22,095,26100 $ 22,095,26100 $ 21,139,66100 $
5 265,690 00 $
3,315,827 00
505.600 00
322,000.00
265,690.00 $ 265,69000
(955,600.00) -432%
000%
3,315,82700 3,315,82700 - 000%
505,600 00 505,600 00 - 000%
322,000 00 307,000 00 (15 000 00) -4 66% Unfav Commission Vending Machines due to county
buildings being closed as It relates to the COVID-19
pandemic
20
AMOUNT
ADOPTED
AMENDED
FY 2020
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLEI
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
General Government
Clerk - County Clerk
$ 2,179,10000 $
2,179 100 00 $
2,179,10000
$ -
000%
Clerk - Elections
93,700.00
93,700.00
138 700 00
45,000 00
4803% Fav Reimburse General $45 000 due to increased activity.
Clerk- Register of Deeds & Micrographics
11717,500.00
11717,501
12,11750000
400,000.00
341% Fav Recording Fees $300,000 and Mortgages $100,000
due to Increased activity
Treasurer
4,776,60000
4,776,60000
3,386,60000
(1,390,00000)
-29.10%Unfav Payments other than Anticipated($950,000), Title
Search ($300,000), Ctvl Action Service Fees ($270,000),
Deeds ($70,000), Maintenance Contracts ($65,000),
Recording Fee Certification ($50,000) Recording Fee
Redemption ($50,000), Foreclosure Notification ($45,000)
due to decreased activity from the COVID-19 pandemic
Partially offset by favorable Administration Fees $300,000,
Tax Reverted Land County Portion $70,000 and Tax
Statement $40,000 due to increased activity
Board of Commissioners
22 500 00
22,500 00
11,900 00
(10,600 00)
-4711% Unfavorable Copier Machine Charges ($5 000) due to
increased functionalities of downloading and e -mailing
documents and downsizing of the Legal Resources Center
Also unfavorable Fee Income ($5,000) due to less than
anticipated royalties as a result of ongoing problems with
vendor website In addition, unfavorable Per Diem ($600)
due to change In payment method of Per Diem fees for
Oakland County Departments
Library Board
-
-
-
-
000%
Water Resources Commissioner
Total General Government
County Executive
County Exec - Compliance Office
County Exec -Corp Counsel
County Exec - Admin
M&B - Equalization Division
M&B - Fiscal Services Division
Central Services - Support Services
3,305,86100 3,305,86100 330586100
$ 22,095,26100 $ 22,095,26100 $ 21,139,66100 $
5 265,690 00 $
3,315,827 00
505.600 00
322,000.00
265,690.00 $ 265,69000
(955,600.00) -432%
000%
3,315,82700 3,315,82700 - 000%
505,600 00 505,600 00 - 000%
322,000 00 307,000 00 (15 000 00) -4 66% Unfav Commission Vending Machines due to county
buildings being closed as It relates to the COVID-19
pandemic
20
Human Resources
HHS - Administration
HHS - Health Division
HHS - Children's Village
Public Services - Community Corrections
Public Services - Veterans
Public Services - MSU Extension
Public Services - Medical Examiner
Public Services - Animal Control
Public Services - Circuit Court Probation
Economic Dev &Comm Affairs -PEDS
Total County Executive
Non -Departmental
Non -Dept - Charges for Services
Total Non -Departmental
Total Charges for Services
INDIRECT COST RECOVERY (640100)
INVESTMENT INCOME 1655000-6559991
District Courts (Div I -IV)
Sheriff Corrective Services
Sheriff InveshgahveTFechnical Services
Treasurer
COUNTY OF OAKLAND
GENERAL FUND/ GENERAL PURPOSE REVENUES
FY 2020 SECOND QUARTER REPORT
ADOPTED
AMENDED
FY 2020
BUDGET
BUDGET
FORECAST
4,776,449 00
4,776,449 00
4,423,849 00
3,316 097 00
3,316,097 00
4,445,997 00
190,000 00
190,000 00
105,000.00
333,550.00
333,55000
333,55000
AMOUNT
FAVORABLE
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
000%
000%
(352,60000) -T38% Unfav due to Immunizations($210,000), Inspecton Fees
($100,300), Permits ($69,600), TB Tests ($24,000),
Licenses ($10,000), and Sanitary Code Appeals Fee
($10,000) being less than anticipated Partially offset by
favorable Flu 3rd Party $31,600, Water Sample Tests
$25,000, Radon Testing $11,700, and Remib Contracts
$3,000 being more than anticipated
1,129,900.00 34 07 % Fav Board and Care $200,000 and Out County Board and
Care $929,900 due to increase in Department of Health
and Human Services placement
(85,000 00) -44 74% Unfav Fee Income (85,000) due to less than anticipated
referrals from judges to the Weekend and Weekday
Alternative for Misdemeanants (WWAM) Program. In
addition, the program is suspended due to the COVID-19
pandemic
000%
000%
000%
1,138,514.00
1,142,21400
1,042,21400
(100,00000)
-875%Unfav pnmarily Sale of Licenses due to COMD-19
pandemic
-
-
-
-
000%
392,037 00
392,037 00
392.037 00
-
0 00 %
$ 14,555,76400
$ 14,559,46400
$ 15,136,764.00
$ 57730000
397%
$ 1,168,024.00
$ 1,168,02400
1,16802400
-
000%
$ 1,168,02400
$ 1,168,02400
3 1,16802400
$ -
000%
$ 116,168,015.00
$ 119,169,699.00
$ 114,164,399.00
$ (5,005,300.00)
-4.20%
$ 9,050,000.00
$ 9,050,000.00
$ 9,050,000.00
$ -
0.00%
$ 2,200 00
$ 2,200 00
$ 2,200 00
$ -
000%
-
-
-
000%
-
-
-
-
000%
150,000 00
150,000 00
450,000 00
300,000 00
200 00 % Fav Income from Investments based on the actual
investment Income distributed to date but does not reflect
market value adjustments which vnll occur at the end of the
fiscal year
21
Clerk/Register of Deeds
Economic Development
Non -Departmental
Total Investment Income
OTHER REVENUES 1670000-6955001
Circuit Court - Donations
Circuit Court
Circuit Court - Transfers In
District Courts (Div I - IV)
Probate Court
Prosecuting Attorney
Sheriff Office
Sheriff - Administrative Services
Sheriff - Corrective Services
Sheriff - Corrective Seryices-Satellites
Sheriff - Emergency Resp and Prepare
Sheriff - Patrol Services
Sheriff - Patrol Services - Donations
Sheriff - Emergency Communications Operations
Sheriff - Investigative/Forensic Svc
Clerk/Rel of Deeds
Treasurer
Board of Commissioners
Library Board
Water Resources Commissioner
County Exec - Compliance Office
Management and Budget- Fiscal Services
Central Services - Support Services
Human Resources
Facilities Management Engineenng
Health Division - Donations
Health Division
COUNTY OF OAKLAND
GENERAL FUND/ GENERAL PURPOSE REVENUES
FY 2020 SECOND QUARTER REPORT
22
AMOUNT
ADOPTED
AMENDED
FY 2020
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE)
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
2,500 00
250000
2,50000
-
0 00 %
-
-
000%
1,800,00000
1,800,000.00
180000000
-
000%
$ 1,954,700.00 $
1,954,700.00
$ 2,254,700.00
$ 300,000.00
15.35%
$ - $
-
$ -
$ -
000%
-
000%
-
000%
-
0.00%
-
000%
-
000%
-
-
900000
9,000.00
100.00% Fav Enhancement Funds due to unbudgeted cash
recovery from evidence
-
-
000%
-
3 000 00
3,00000
-
000%
-
-
000%
-
-
-
-
000%
12 000 00
12,000 00
-
(12,000 00)
-10000% County Auction postponed until October 2020 due to
COVID-19.
-
-
-
000%
-
-
-
-
000%
3,00000
3,00000
-
(3,000 00)
-10000% County Auction postponed until October 2020 due to
COVID-19
-
-
-
000%
000%
-
0.00%
-
-
000%
-
-
000%
-
-
000%
-
-
-
-
000%
150000
1,500.00
2,80000
1,30000
8667% Fav, Prior Years Adjustments$1,500 due to Vending
Machine Commission payment for FY 2019 received in FY
2020.
-
-
-
-
000%
-
000%
-
000%
-
-
108,000 00
108,000 00
100 00% Fav to correct FY 2019 estimated admin overhead costs
distributions for FY 2019 Comprehensive Planning,
Budgeting and Contracting (CPBC) Agreement
22
Health Division - Transfers In
Children's Village
Children's Village - Transfers In
Homeland Security
Public Services - Medical Examiner
Public Services - Animal Control -Other Revenues
Public Services - Animal Control -Transfers In
Economic Development & Comm Affairs - Contributions
Economic Development - Contributions
Non Departmental - Donations
Non -Dept - Sundry
Sheriffs' Transfers In
Treasurers' Transfers In
Non -Departmental - Transfers In
Total Other Revenues
PLANNED USE OF FUND BALANCE (665000-665999)
Encumbrances and Carry forwards
Use of Prior Yrs Fund Balance
Total Planned Use of Fund Balance
TOTAL GEN. FUND/GEN. PURPOSE REVENUE
COUNTY OF OAKLAND
GENERAL FUND/ GENERAL PURPOSE REVENUES
FY 2020 SECOND QUARTER REPORT
ADOPTED AMENDED FY 2020
BUDGET BUDGET FORECAST
1,200 00
- 1,03100 1,03100
AMOUNT
-
FAVORABLE
39,500.00
tUNFAVORABLEI
PERCENT
-
000%
1,200 00
10000%
000%
000%
000%
000%
000%
EXPLANATION OF SIGNIFICANT VARIANCES
-
-
39,500.00
39,500.00
10000% Fav due to contributions for Fire &Ice Festival to offset
expenditures
-
000%
-
-
-
000%
417,500.00
417,500 00
417,500 00
-
000%
-
32,405 00
32,405 00
-
000%
2,500,000.00
250000000
2,500,00000
-
000%
3,000,00000
3,00000000
3,000,00000
-
000%
$ 5,934,000.00
$ 5,970,436.00
6,114,436.00
$ 144,000.00
2.41%
-
9,866,49814
9,866,49814
-
000%
$ 30,606,43800
$ 39,343,25500
39,343 255 00
-
000%
$ 30,606,438.00
$ 49,209,753.14 $
49,209,753.14
$ -
0.00%
$ 475.619.369.00
$ 497.509.958.14 $
494,823,468.14
$ (2,686,500.00)
-0.54%
23
Judicial Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfer Out
Business Division
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
$ 10,508,85300 $ 11,047,191.35 $ 10,239,191.35 $
$ 1.804,768 00 $ 1,809,190 00 $ 1,584,190.00 $
182,58900 182,589.00 87,589.00
240,490 00 240 490.00 240,490.00
808.000.00 7 31 %
225.000.00 12 44% - Fav due to underfilled and vacant positions Partially offset by
an increase in hazard pay as it relates to the COVID-19
pandemic.
95,00000 52 03% - Fav Visiting Judges $75,000 and Professional Services
$20,000 due to lower than anticipated use The overarching
cause of the variance identified above is due to the pandemic
- 0.00% -
$ Z227,847 00 $ 2,232,26900 $ 1,912,269.00 $ 320,00000 14.34%
Civil / Criminal Division
Personnel Expenditures $ 1,922,686 00 $ 1,922,686 00 $ 1,937 686.00 $ (15,000 00) -0.78% - Unfay. due to an increase in hazard pay as it relates to the
COVID-19 pandemic.
Operating Expenditures 2,271,589.00 1,991,589 00 1,576.589 00 415,000 00 20.84% - Fay. Juror Fees and Mileage $200,000; Defense Atty Fees
Appellate $125.000, Transcript on Appeals $50,000; and Office
Supplies $40,000 due to lower than anticipated use The
overarching cause of the variance identified above is due to the
pandemic
24
AMOUNT
ADOPTED AMENDED FY 2020
FAVORABLE
BUDGET BUDGET FORECAST
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 9,921,145 00 $ 9,921,145 00 $ 9,471.145.00
$ 450 000.00 4 54% - Fav due to underfilled and vacant positions. Partially offset by
an increase in hazard pay as it relates to the COVID-19
pandemic
224,828 00 721,088.35 363,088.35
358,000.00 4966% Fay. Expendable Equipment $225.000, Training $35,000, and
Office Supplies $25,000 due to lowerthan anticipated use Fav
Special Projects $93,000 due to the unused distribution of
Judicial Technology funds from the State and Judge On -Line
project (MR #09017) for courtroom technology improvements.
Partially offset by unfav Library Continuations ($20,000) due to
higher than anticipated use The overarching cause of the
variances identified above is due to the pandemic
362,880 00 404,958.00 404,958.00
- 000% -
$ 10,508,85300 $ 11,047,191.35 $ 10,239,191.35 $
$ 1.804,768 00 $ 1,809,190 00 $ 1,584,190.00 $
182,58900 182,589.00 87,589.00
240,490 00 240 490.00 240,490.00
808.000.00 7 31 %
225.000.00 12 44% - Fav due to underfilled and vacant positions Partially offset by
an increase in hazard pay as it relates to the COVID-19
pandemic.
95,00000 52 03% - Fav Visiting Judges $75,000 and Professional Services
$20,000 due to lower than anticipated use The overarching
cause of the variance identified above is due to the pandemic
- 0.00% -
$ Z227,847 00 $ 2,232,26900 $ 1,912,269.00 $ 320,00000 14.34%
Civil / Criminal Division
Personnel Expenditures $ 1,922,686 00 $ 1,922,686 00 $ 1,937 686.00 $ (15,000 00) -0.78% - Unfay. due to an increase in hazard pay as it relates to the
COVID-19 pandemic.
Operating Expenditures 2,271,589.00 1,991,589 00 1,576.589 00 415,000 00 20.84% - Fay. Juror Fees and Mileage $200,000; Defense Atty Fees
Appellate $125.000, Transcript on Appeals $50,000; and Office
Supplies $40,000 due to lower than anticipated use The
overarching cause of the variance identified above is due to the
pandemic
24
Internal Support Expenditures
Transfers Out
Family Division/Juvenile Maint.
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfer Out
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
$ 12,187,799.00 $ 12,317,731.00 $ 11,992,731.00 $
9,480,03000 9.482.01872 8,182,018.72
2,108,888.00 2,108,969.00 2,103,96900
6,073,660 00 6,073,660 00 6,073,660.00
----------------------
$ 29,850,377 00 $ 29,982,378 72 $ 28,352,378 72 $
325,000 00
1,300,000.00
5,00000
1 630,000 00
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
^FT0.78°/ - Fay. Info Tech Operations $20,000 and Telephone
Communications $10,000 due to lowerthan anticipated use
Partially offset by unfav Equipment Rental ($10,000) based on
actual usage The overarching cause of the variances identified
above is due to the pandemic
5.02%
2.64°/ - Unfay. due to an increase in hazard pay as it relates to the
COVID-19 pandemic
13.71 % - Fay. due to decrease in placements to State Institutions
$1,000.000. Fay. Defense Any Fees $125.000, Fees Guardian
Ad Litem $100.000, Professional Services $100,000 due to
lower than anticipated use. Partially offset by Unfav Priv
Institutions Residential ($25,000) based on caseload, difficulty
of care, and treatment of services ordered by the Court
Additional offset by fav Non -Dept Child Care Subsidy Revenue
(50% Reimbursement) due to reimbursement for Administrative
costs was more than anticipated. The overarching cause of the
variances identified above is due to the pandemic.
0.24% - Fay. Info Tech Managed Print Svcs $10,000 and Telephone
Communications $10,000 due to lower than anticipated use
Partially offset by unfay. Info Tech Operations ($15,000) due to
more than anticipated use The overarching cause of the
variances identified above is due to the pandemic.
000%-
5.44%
25
AMOUNT
ADOPTED
AMENDED
FY 2020
FAVORABLE
BUDGET
BUDGET
FORECAST
^
(UNFAVORABLE)
2,230,007.00
2,575,786 00
2,555,786.00
20,000 00
-
1,868,991.00
1,868,99100
-
$ 6,424 282 00
-------------------
$ 8,359,052.00
$ 7,939,052 00
$ 420,000 00
$ 12,187,799.00 $ 12,317,731.00 $ 11,992,731.00 $
9,480,03000 9.482.01872 8,182,018.72
2,108,888.00 2,108,969.00 2,103,96900
6,073,660 00 6,073,660 00 6,073,660.00
----------------------
$ 29,850,377 00 $ 29,982,378 72 $ 28,352,378 72 $
325,000 00
1,300,000.00
5,00000
1 630,000 00
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
^FT0.78°/ - Fay. Info Tech Operations $20,000 and Telephone
Communications $10,000 due to lowerthan anticipated use
Partially offset by unfav Equipment Rental ($10,000) based on
actual usage The overarching cause of the variances identified
above is due to the pandemic
5.02%
2.64°/ - Unfay. due to an increase in hazard pay as it relates to the
COVID-19 pandemic
13.71 % - Fay. due to decrease in placements to State Institutions
$1,000.000. Fay. Defense Any Fees $125.000, Fees Guardian
Ad Litem $100.000, Professional Services $100,000 due to
lower than anticipated use. Partially offset by Unfav Priv
Institutions Residential ($25,000) based on caseload, difficulty
of care, and treatment of services ordered by the Court
Additional offset by fav Non -Dept Child Care Subsidy Revenue
(50% Reimbursement) due to reimbursement for Administrative
costs was more than anticipated. The overarching cause of the
variances identified above is due to the pandemic.
0.24% - Fay. Info Tech Managed Print Svcs $10,000 and Telephone
Communications $10,000 due to lower than anticipated use
Partially offset by unfay. Info Tech Operations ($15,000) due to
more than anticipated use The overarching cause of the
variances identified above is due to the pandemic.
000%-
5.44%
25
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
CIRCUIT COURT
$ 49,011,35900 $ 51.620,89107 $ 48,442,891.07 $ 3,178,00000 6.16%
EXPLANATION OF SIGNIFICANT VARIANCES
26
AMOUNT
ADOPTED
AMENDED
FY 2020
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE)
PERCENT
Department Total
Personnel Expenditures
$ 25,836,398 00
$ 25,970.752.00
$ 24.985,752 00
$ 985,000 00
179%
Operating Expenditures
12,159,036.00
12,377,285.07
10,209,28507
2,168,000.00
17.52%
Internal Support Expenditures
4 942,265 00
5,330,203.00
5,305,203 00
25,000 00
0.47%
Transfers Out
6,073,66000
7,942,651.00
7,942,651.00
-
0.00%
$ 49,011,35900 $ 51.620,89107 $ 48,442,891.07 $ 3,178,00000 6.16%
EXPLANATION OF SIGNIFICANT VARIANCES
26
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
$ 4,558260.00 S 4,558,260.00 $ 4,488,260.00 70,000.00
917,925 00 928,413 00 883,413.00 45,000 00
382,71400 397,034.00 397,03400
5 5,858,899 00 $ 5,883,707 00 $ 5,768,707.00 $ 115,000 DO
$ 2,268.013.00 $ 2,268,013.00 $ 2,275,513.00
544 787.00 544,787 00 522,287.00
216,882.00 237,59000 247,590.00
$ 3,029,682.00 $ 3,050,390.00 $ 3.045,390 00 $
1 54% - Fay. due to turnover and underfilled positions/vacancies.
Partially offset by an increase in hazard pay as it relates to
the COVID-19 pandemic
485% - Fay. Software Support Maintenance $20,000, Electrical
Service $15,000, as well as Medical Exam $10,000 due to
lower than anticipated use The overarching cause of the
variance identified above is due to the pandemic
000% -
0.00 % -
1.95%
(7,500 00) -0.33% - Unfay. due to an increase in hazard pay as it relates to the
CO VID-19 pandemic. Partially offset by staff furloughs.
22,500 00 4.13% - Fav Interpreter Fees $7,500: Juror Fees and Mileage
$5,000, Electrical Services $5,000; as well as Software
Support Maintenance $5,000 due to lower than anticipated
use. The overarching cause of the variance identified above
is due to the pandemic
(10,000.00) -4.21% - Unfay. Info Tech Operations($10,000) due to higher than
anticipated use. The overarching cause of the variance
identified above is due to the pandemic.
0.00% -
5,000.00 016%
27
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
DISTRICT COURT
AMOUNT
ADOPTED
AMENDED
FY 2020 FAVORABLE
BUDGET
BUDGET
FORECAST (UNFAVORABLE) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
S 241,188 00
$ 241,188.00
S 228,688 00 $ 12,500 00
518%
- Fav due to turnover and underfilled positions/vacancies
10,300 00
10,300.00
1,60000 8,70000
84.47%
Fav Visiting Judges $8,400 due to lower than anticipated
use. The overarching cause of the variance identified above
is due to the pandemic
1,61300
1,61300
1,613.00 -
0.00%
-
-
- -
000%
$ 253,101.00
S 253,10100
$ 231,901.00 $ 21,200.00
838%
$ 4,558260.00 S 4,558,260.00 $ 4,488,260.00 70,000.00
917,925 00 928,413 00 883,413.00 45,000 00
382,71400 397,034.00 397,03400
5 5,858,899 00 $ 5,883,707 00 $ 5,768,707.00 $ 115,000 DO
$ 2,268.013.00 $ 2,268,013.00 $ 2,275,513.00
544 787.00 544,787 00 522,287.00
216,882.00 237,59000 247,590.00
$ 3,029,682.00 $ 3,050,390.00 $ 3.045,390 00 $
1 54% - Fay. due to turnover and underfilled positions/vacancies.
Partially offset by an increase in hazard pay as it relates to
the COVID-19 pandemic
485% - Fay. Software Support Maintenance $20,000, Electrical
Service $15,000, as well as Medical Exam $10,000 due to
lower than anticipated use The overarching cause of the
variance identified above is due to the pandemic
000% -
0.00 % -
1.95%
(7,500 00) -0.33% - Unfay. due to an increase in hazard pay as it relates to the
CO VID-19 pandemic. Partially offset by staff furloughs.
22,500 00 4.13% - Fav Interpreter Fees $7,500: Juror Fees and Mileage
$5,000, Electrical Services $5,000; as well as Software
Support Maintenance $5,000 due to lower than anticipated
use. The overarching cause of the variance identified above
is due to the pandemic
(10,000.00) -4.21% - Unfay. Info Tech Operations($10,000) due to higher than
anticipated use. The overarching cause of the variance
identified above is due to the pandemic.
0.00% -
5,000.00 016%
27
28
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
DISTRICT
COURT
AMOUNT
ADOPTED
AMENDED
FY 2020
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Division 3 - Rochester Hills
Personnel Expenditures
$
4,136,83400
$ 4,136,834.00
$
3,961,834.00
175,000.00
423%
- Fay.duetotumoverand underfilled pos@ions/vacancies
Partially offset by an increase in hazard pay as it relates to
the COVID-19 pandemic
Operating Expenditures
316,009.00
317,204 00
252,204.00
65,000.00
20 49 %
- Fay. Juror Fees and Mileage $20,000; Interpreter Fees
$15,000; Office Supplies $20,000; as well as Postage -
Standard Mailing $10,000 dueto lowerthan anticipated use
The overarching cause of the variances identified above is
due to the pandemic.
Internal Support Expenditures
867,540.00
884,122 00
869,122.00
15.000.00
1 70%
- Fay. Telephone Communications $10,000 and Info Tech
Managed Prmt Svcs $5,000 due to lower than anticipated
use The overarching cause ofthe variance identified above
is due to the pandemic.
Transfers Out
-
-
-
-
0 00 %
$
5,320,38300
$ 5,338,16000
S
5,083,16000
$ 255,000.00
478%
Division 4 - Troy
Personnel Expenditures
$
2,491,410.00
$ 2,491,410 00
$
2,546,410 00
(55,000.00)
-221%
- Unfav due to an increase in hazard pay as it relates to the
COVID-19 pandemic Partially offset by staff furloughs -
Opemting Expenditures
457,07200
457,072.00
424.57200
32,500.00
711%
- Fay. Postage -Standard Mailing $10,000, Office Supplies
$10,000; Interpreter Fees $7,500: as well as Software
Support Maintenance $5,000 due to less than anticipated
use The overarching cause of the vanance identified above
is due to the pandemic
Internal Support Expenditures
263,218 00
271,063 00
276,063 00
(5,000.00)
-1 84%
- Unfav Info Tech Operations ($5,000) and Equipment Rental
($5,000) due to higher than anticipated use. Fav Telephone
Communications $2,500 and 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
$
3,211,700.00
$ 3,219,545 00
$
3,247,045 00
$ (27,500.00)
-085%
Department Total
Personnel Expenditures
$
13,695,70500
$ 13,695,705.00
S
13,500,70500
$ 195,000.00
1.42%
Operating Expenditures
2,246,09300
2,257,77600
2,084,07600
173,700.00
7.69%
Internal Support Expenditures
1,731,967 00
1,791,422 00
1,791,422.00
-
0.00%
Transfers Out
-
-
-
-
$
_______________
17,673,76500
$ 17,744,903.00
______________
S
_______________
17,376,203 00
$ 368,700.00
2.08%
28
Judicial/Administration
Personnel Expenditures
Operating Expenditures
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
PROBATE COURT
Internal Support Expenditures
451,738
00 453,510 00
AMOUNT
ADOPTED
AMENDED
FY 2020
FAVORABLE
-
BUDGET
BUDGET
FORECAST
(UNFAVORABLE) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
S 2.522,695.00
$ 2,522,695.00 S
2,497,695.00
$ 25,000 00 0.99%
Fav due to turnover and underfilled positions/vacancies Partially offset by an
Personnel Expenditures
$ 2.3913,501 .00
$ 2,398,501 00
$ 2,378,501.00 $
increase in hazard pay as it relates to the COVID-19 pandemic
22,481 00
22,481.00
15,981.00
6,50000 28 91 %
Fav Court Reporter Services $2,500, Membership Dues $2,000; Travel and
$ 6,994,93700 $
7,074,610.02
$ 6,950,61002 $
Conference $2,000 due to lower than anticipated use as it relates to the
1.75%
pandemic.
Internal Support Expenditures
451,738
00 453,510 00
453,510 00
Transfer Out
-
-
-
-
45,000.00
$ 2,996914.00
$ 2,998.68600
$ 2,967,186.00 $
31,500.00
Estates/Mental Health
71,500.00
6.67%
Internal Support Expenditures
1,043,317.00
Personnel Expenditures
$ 2.3913,501 .00
$ 2,398,501 00
$ 2,378,501.00 $
20,000.00
Operating Expenditures
1.007,943.00
1,049,743.02
984,74302
65,000.00
000%
1 05%
0.83%
6.19%
Internal Support Expenditures 591 579.00 627,680 00 620,180.00 7,50000 1 19%
$ 3,998,023.00 $ 4,075,92402 $ 3,983424.02 $ 92,500.00 227%
Department Total
Personnel Expenditures
5 4,921,196.00 $
4,921,196 00
$ 4,876,196.00 $
45,000.00
0.91%
Operating Expenditures
1,030,424.00
1,072,22402
1,000,724.02
71,500.00
6.67%
Internal Support Expenditures
1,043,317.00
1,081,190.00
1,073,690.00
7,500.00
0.69%
Transfer Out
-
-
-
-
$ 6,994,93700 $
7,074,610.02
$ 6,950,61002 $
124,00000
1.75%
Fay. due to turnover, underfilled positions/vacancies and furloughs Partially
offset by an increase in hazard pay as it relates to the COVID-19 pandemic
Fay. Fees Guardian Ad Litem $55.000 and Defense Attorney Fees $35,000 due
to a decreased number of case filings and lower demand for these services Fav
Expendable Equipment $15.000 due to lower than anticipated use. The
overarching cause of the variances identified above is also due to the pandemic.
Partially offset by unfav Medical Services Probate Exam ($25,000) due to
continued high demand for these services Unfav Software Support
Maintenance ($15.000) due to variable rate increases for the use of services
from the State of Michigan.
Fav Equipment Rental $5,000 and Telephone Communications $2,500 due to
less use as it relates to the pandemic
29
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
PROSECUTING ATTORNEY
30
AMOUNT
ADOPTED
AMENDED
FY 2020
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
$
2,682,143 00 $
2,685,943 00
$ 2,675,943 00
$ 10,000 00
0 37 %
Fav due to furloughed employees, partially offset by unfav Hazard Pay
($34,000) as a result of COVID-19 and Overtime
Operating Expenditures
520,666 00
524,666 00
474,666 00
50,000 00
9 53%
Fav Witness Fees and Mileage $25,000, Printing $20,000, Filing Fees
$12 000, Training $7,000, Computer Research Service $5,000, Metered
Postage $4,000 Expendable Equipment $3,000, Microfilming and
Reproductions $3,000, Travel and Conference $2,000 and Workshops
and Meetings $2,000 due to less than anticipated use; partially offset by
unfav Library Continuations ($35,000) due to increased usage
Internal Support Expenditures
2,020,84700
2058,57600
2041,57600
17,00000
083%
Fav Telephone Communications $13,000, Info Tech Operations $11 000,
Equipment Rental $4,000 and Radio Communications $4,000 due to less
than anticipated use; partially offset by unfav Info Tech Managed Print
Services ($15.000) due to usage
Transfers Out
-
67,00000
67,00000
-
000%
$
5,223656.00 $
5,336,18500
$ 5,259,18500
$ 77,00000
144%
Litigation
Personnel Expenditures
$
11,040,66000 $
11,045,06000
$ 10445,06000
$ 600,00000
543%
Fav$635000 due to underfilled positions and turnover, partially offset by
unfav Hazard Pay ($35,000) due to COVID-19.
Operating Expenditures
28.301 00
28,301 00
24,101 00
4,200 00
1484%
Fav Personal Mileage $5,000 due to less than anticipated Use, partially
offset by unfay. Clothing Allowance ($800) due to increased use
Internal Support Expenditures
122,736 00
122,736 00
122,736 00
-
0 00%
Transfers Out
975,027 00
975,027.00
975,027 00
-
000%
$
12 166 724 00 $
12,171,12400
$ 11 566,924 00
$ 604,20000
496%
Warrants
Personnel Expenditures
$
2271786.00 $
2,263,58600
$ 2,153,58600
$ 110,00000
486%
Fav $122,000 due to undefined positions and turnover, partially offset by
unfay. Hazard Pay ($12 000) due to COVIDG 9
Operating Expenditures
3,19900
3,19900
2,199.00
1,00000
31.26%
Fay. Personal Mileage due to less than anticipated use
30
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
PROSECUTING ATTORNEY
31
AMOUNT
ADOPTED
AMENDED
FY 2020
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Intemal Support Expenditures
_
25,251 DO
`
25251 DO
25,25100
-
__
000%
"'^'
$
2,300,236 DO
$ 2,29203600
$ 2,181,03600
$ 111,00000
484%
Appellate
Personnel Expenditures
$
1,932,77300
$ 1,932,77300
$ 1,952,77300
$ (20,00000)
-103%
Unfav Overtime ($15 000) and Hazard Pay ($5,000) due to COVID-19
Operating Expenditures
8,00000
4000.00
2,00000
2,00000
50 00 %
Fav Personal Mileage due to less than annoipated use
Intemal Support Expenditures
19,041 00
19 041 00
19,041 00
-
000%
$
1,959,81400
$ 1,95581400
$ 1,973,81400
$ (18,00000)
-092%
Department
Personnel Expenditures
$
17,927,36200
$ 17,92736200
$ 17,227,36200
$ 700,00000
390%
Operating Expenditures
560,166 00
560,16600
502,966 00
57,200 00
10.21%
ntemal Support Expenditures
2,187,87500
2,225,60400
2,208,60400
17,00000
0.76%
Transfers Out
975,02700
1,04202700
1,042,02700
-
000%
$
21,650,43000
$ 21755,15900
$ 20,980,95900
$ 774,20000
3.56%
31
Sheriffs Office
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Administrative Services
Personnel Expenditures
Operating Expenditures
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
AMOUNT
ADOPTED AMENDED FY 2020 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
$ 1,828,515 00 $ 1,828,515 00 $ 1,809,515.00 $ 19.000 00 104% Fay. due to turnover, vacant position and overtime; partially offset by unfay.
Hazard Pay ($5,300) as it relates to the COVID-19 pandemic
102,236 00 99,836 00 74,836 00 25.000 00 25.04% Fay. Contracted Services $10,000, Office Supplies $9,000 and Library
Continuations $5,000 due to less usage
469,067 00 469,067 00 487,067 00 (18,000 00) -3.84% Unfav Info Tech Operations ($35,000) due to a billing issue (see
corresponding favorability in Corrective Services division); partially offset by fav
Motor Pool $17,000 due to less than anticipated use
- 0.00
$ 2,399,818 00 $ 2,397,418 00 $ 2,371,418 00 $ 26,000 00 1.08%
$ 1,242,538 00 $ 1,265,533 00 $ 1,318,533.00
479,86400 683,27286 643,272.86
Internal Support Expenditures 158,489 00 158,927 00 161,92200
(53,000.00) -4.19% Unfav due to Overtime and Hazard Pay ($37,000) as it relates to the COVID-
19 pandemic
40,000.00 585% Fav Printing $50,000, Library Continuations $20,000, Deputy Supplies
$15,000, Metered Postage $6,000 and Postsge-Standard Mailing $6,000 due
to less than anticipated use; partially offset by unfay. Equipment ($55,000) for
purchase of a UV sanfizer machine due to COVID-19 pandemic
(3,000.00) -1 89% Unfay. Info Tech Operations (9,000) due to usage, partially offset by fay.
Telephone Communications $6,000 due to less than anticipated use.
Transfers Out - - - - 000%
$ 1,880,891.00 $ 2,107,732.86 S 2,123,732.86 $ (16,000.00) -076%
Corrective Services
Personnel Expenditures 34,052,270 00 34,076,893 00 $ 35,376,893.00 (1,300,000.00) -&81% Unfav Overtime ($2,250,000) of which a portion is attributable to COVID-19
pandemic Also unfav Hazard Pay ($1,050,000) as it relates to the pandemic,
partially offset by fav Salaries and Fringe Benefits $2,000,000 as a result of a
large number of vacancies, turnover, officers in the academy and officers in
training Generally, hiring, training and filling-in for deputies is a major factor
contributing to the use of overtime Currently the majority of training has been
suspended indefinitely and the COVID-19 pandemic has contributed to
additional leave time
32
Operating Expenditures
Internal Support Expenditures
Transfers Out
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
000%
$ 49,088,026.00 $ 49,059,984.69 $ 50,344,984.69 $ (1,285,000.00) -262%
Corrective Services -Satellites
Personnel Expenditures $ 16,078,146.00 $ 16,104,772.00 $ 18,864,772.00 $ (2,760,000.00) -17.14%
Operating Expenditures
Internal Support Expenditures
Transfers Out
397,297 00 227,976.00 252,976.00
1,334,32&00 1,337,781.00 1,302,781 00
3,50000 3,500.00 3,50000
(25,000 00) -1097%
35,000.00 262%
000%
$ 17,813,266.00 $ 17,674,029.00 $ 20,424,029.00 $ (2,750,000.00) -15.56%
EXPLANATION OF SIGNIFICANT VARIANCES
Unfav Equipment ($110,000) for purchase of two UV sanitizing machines,
Contracted Services ($100,000) due to prepackaged inmate meals and
Custodial Supplies ($60,000) due to higher usage all as a result of COVID-19
pandemic, partially offset by fay. Other Expendable Equipment $50,000,
Supportive Services $25,100, Office Supplies $15,000, Transportation of
Prisoners $12,000, Computer Supplies $10,000, Culinary Supplies $10,000,
Indigent Orders $10,000, Interpreter Fees $10,000, Laundry and Cleaning
$10,000, Groceries $7,000, Prisoner Housing -Outside County $5,000 and
Provisions $5,000 due to less than anticipated use
Fay. Radio Communications $40,000, Info Tech Managed Print Services
$25,000 and Motor Pool $10,000 due to less than anticipated use Also fav Info
Tech Operations $35,000 due to a billing issue (see corresponding
unfavorability in Sheriffs Office division).
Unfav due to Overtime and related Fringe Benefits ($2,350,000) at the
Corrective Services Satellite facilities caused by Circuit Court security, vacant
positions, prisoner transport, employee disability and other leaves. Also unfay.
Hazard Pay ($480,000) as it relates to the COVID-19 pandemic, partially offset
by fav Salaries $70,000 due to vacant positions Hiring, training and retaining
Corrections Deputies and filling-in for deputies on disability has been a primary
reason contributing to the high use of overtime
Unfav Equipment ($55,000) for purchase of a UV sanitizer machine for COVID-
19, Dry Goods and Clothing ($25,000) which includes the purchase of masks
for all inmates and Office Supplies ($5,000) due to higher usage partially due to
COVID-19 pandemic Also unfav Other Expendable Equipment ($6,500) for
furniture replacement which is budgeted in other divisions, partially offset by
fav Uniforms $50,000 and Laundry and Cleaning $20,000 due to less than
anticipated use.
Fay. Motor Pool $25,000 and Motor Pool Fuel Charges $10,000 due to less
than anticipated use.
33
AMOUNT
ADOPTED
AMENDED
FY 2020
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE) PERCENT
8,073,59300
7,812,322.69
7,912,322.69
(100,00000) -1.28%
6,962,16300
7,170,76900
7,055,76900
115,000.00 1.60%
000%
$ 49,088,026.00 $ 49,059,984.69 $ 50,344,984.69 $ (1,285,000.00) -262%
Corrective Services -Satellites
Personnel Expenditures $ 16,078,146.00 $ 16,104,772.00 $ 18,864,772.00 $ (2,760,000.00) -17.14%
Operating Expenditures
Internal Support Expenditures
Transfers Out
397,297 00 227,976.00 252,976.00
1,334,32&00 1,337,781.00 1,302,781 00
3,50000 3,500.00 3,50000
(25,000 00) -1097%
35,000.00 262%
000%
$ 17,813,266.00 $ 17,674,029.00 $ 20,424,029.00 $ (2,750,000.00) -15.56%
EXPLANATION OF SIGNIFICANT VARIANCES
Unfav Equipment ($110,000) for purchase of two UV sanitizing machines,
Contracted Services ($100,000) due to prepackaged inmate meals and
Custodial Supplies ($60,000) due to higher usage all as a result of COVID-19
pandemic, partially offset by fay. Other Expendable Equipment $50,000,
Supportive Services $25,100, Office Supplies $15,000, Transportation of
Prisoners $12,000, Computer Supplies $10,000, Culinary Supplies $10,000,
Indigent Orders $10,000, Interpreter Fees $10,000, Laundry and Cleaning
$10,000, Groceries $7,000, Prisoner Housing -Outside County $5,000 and
Provisions $5,000 due to less than anticipated use
Fay. Radio Communications $40,000, Info Tech Managed Print Services
$25,000 and Motor Pool $10,000 due to less than anticipated use Also fav Info
Tech Operations $35,000 due to a billing issue (see corresponding
unfavorability in Sheriffs Office division).
Unfav due to Overtime and related Fringe Benefits ($2,350,000) at the
Corrective Services Satellite facilities caused by Circuit Court security, vacant
positions, prisoner transport, employee disability and other leaves. Also unfay.
Hazard Pay ($480,000) as it relates to the COVID-19 pandemic, partially offset
by fav Salaries $70,000 due to vacant positions Hiring, training and retaining
Corrections Deputies and filling-in for deputies on disability has been a primary
reason contributing to the high use of overtime
Unfav Equipment ($55,000) for purchase of a UV sanitizer machine for COVID-
19, Dry Goods and Clothing ($25,000) which includes the purchase of masks
for all inmates and Office Supplies ($5,000) due to higher usage partially due to
COVID-19 pandemic Also unfav Other Expendable Equipment ($6,500) for
furniture replacement which is budgeted in other divisions, partially offset by
fav Uniforms $50,000 and Laundry and Cleaning $20,000 due to less than
anticipated use.
Fay. Motor Pool $25,000 and Motor Pool Fuel Charges $10,000 due to less
than anticipated use.
33
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
SHERIFF'S OFFICE
AMOUNT
ADOPTED AMENDED FY 2020 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Emergency Response and Preparedness
Personnel Expenditures $ 3,389,446 00 $ 3,441,610.00 $ 3,596,610.00 $ (155,000 00) 4.50% Unfay. dueto Overtime and related Fringe Benefits ($275,000) and Hazard Pay
($95,000) as tt relates to the COVID-19 Pandemic, partially offset by fav
Salaries $215,000 due to vacant and underfilled positions
Operating Expenditures 539,657.00 1,256,92627 1,256,92627 - 0.00%
Internal Support Expenditures 420,633.00 423,290 00 423,290 00 - 0.00%
Transfers Out - - - - 0 00 %
$ 4,349,736.00 $ 5,121,826.27 $ 5,276,82627 $ (155,00000) -303%
Patrol Services
Personnel Expenditures $56,079,669 $ 57,341,062 00 $ 57,491,062.00 $ (150,000.00) -026%
Operating Expenditures 1,509,762 00 2,035,379 34 2,235,379.34 (200,000.00) -983%
Internal Support Expenditures 6,452,944 00 6,614,034 00 6,214,034.00 400,000.00 605%
Transfers Out 788.00 220,088 00 220,088 00 - 0.00%
$ 64,043,163.00 $ 66,210,563.34 $ 661160,563.34 $ 50,00000 008%
Emergency Communications Operations
Personnel Expenditures $ 9,536,282.00 $ 9,529,316 00 $ 9,799,316.00 $ (270,000 00) -2.83%
Operating Expenditures 187,295.00 229,68680 179,68680 50,000.00 2177%
Unfav Hazard Pay ($2,050,000) as it relates to the COVID-19 pandemic and
Overtime ($900,000) of which a portion is attributable to the pandemic and may
be further impacted by event cancelations due to the pandemic; partially offset
by fav Salaries and Fringe Benefits $2,800,000 as a result of vacancies and
turnover
Unfav Deputy Supplies ($320,000) primarily for Personal Protective Equipment
(PPE) due to COVID-19 pandemic; partially offset by fav Uniforms $70,000,
Equipment Rental $20,000, Communications $7,000, Office Supplies $6,000
and North Oakland Substation $5,000 due to less than anticipated use.
Fav Motor Pool $255,000, Motor Pool Fuel $130,000, Equipment Rental
$49,000, and Telephone Communications $25,000 due to less than anticipated
use, partially offset by unfay. Info Tech Operations ($65,000) due to usage
Unfay. Overtime and related Fringe Benefits ($600,000) caused by vacant
positions and Hazard Pay ($270,000) due to the COVID-19 pandemic; partially
offset by fav Salaries $600,000 due to vacant positions
Fav Equipment Maintenance $50,000 due to less than anticipated use
34
Internal Support Expenditures
Transfers Out
Investigative/Forensic Svcs
Personnel Expenditures
Operating Expenditures
$ 9,999,48500 $ 10,034,91080 $ 10,214,910.80 $ (180,000.00) -179%
$ 9,377,931.00 $ 9,421,466 00 $ 9,821,466 00 $ (400,000.00) -425% Unfav Hazard Pay ($350,000) due to COVID-19 pandemic and Overtime
($100,000); partially offset by fay. Salaries $50,000 due to turnover and vacant
positions
963,382.00 1,018,835.51 768,835.51 250,000.00 2454% Fav Laboratory Supplies $150,000 and Drug Testing $12,000 from closure of
the Results drug testing program due to COVID-19 pandemic, offset by
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
unfavorable revenue Also fay. Contracted Services $50,000, Softvrare Support
SHERIFF'S OFFICE
AMOUNT
ADOPTED
AMENDED
FY 2020 FAVORABLE
BUDGET
BUDGET
FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
275,908.00
275,908.00
235,908.00 40,000.00 1450% Fav Radio Communications $45,000 due to less than anticipated use, partially
offset by unfav Info Tech Operations ($5 000) due to usage
-
- - 000%
$ 9,999,48500 $ 10,034,91080 $ 10,214,910.80 $ (180,000.00) -179%
$ 9,377,931.00 $ 9,421,466 00 $ 9,821,466 00 $ (400,000.00) -425% Unfav Hazard Pay ($350,000) due to COVID-19 pandemic and Overtime
($100,000); partially offset by fay. Salaries $50,000 due to turnover and vacant
positions
963,382.00 1,018,835.51 768,835.51 250,000.00 2454% Fav Laboratory Supplies $150,000 and Drug Testing $12,000 from closure of
the Results drug testing program due to COVID-19 pandemic, offset by
$163,323,596.00 $ 166,546,350.47 $ 170,946,35047 $ (4,400,000.00) -264%
35
unfavorable revenue Also fay. Contracted Services $50,000, Softvrare Support
Maintenance $15,000 and Extradition Expense $10,000 due to less than
anticipated use and Travel and Conference $5,000 due to travel restrictions as
it relates the COVID-19 pandemic.
Internal Support Expenditures
2,946,107 00
2,946,665 00
2,886,665 00
60,000 00
2.04%
Fav Telephone Communications $47,000, Motor Pool Fuel Charges $27,000
and Info Tech Managed Print Services $17,000,due to less than anticipated
use; partially offset by unfav Info Tech Operations ($21,000) and Motor Pool
($11,000) due to usage
Transfers Out
461,791.00
552,919 00
552,919 00
-
000%
$
13,749,211.00
$
13,939,885.51
$
14,029,885.51
$ (90,000.00)
-065%
Department Total
Personnel Expenditures
$131,584,797.00
$
133,009,167.00
$
138,078,167.00
$ (5,069,000.00)
-381%
Operating Expenditures
$
12,253,086.00
$
13,364,23547
$
13,324,23547
$ 40,00000
030%
Internal Support Expenditures
$
19,019,634.00
$
19,396,441 00
$
18,767,44100
$ 629,000.00
324%
Transfers Out
$
466,079.00
$
776,507.00
$
776,507.00
$ -
000%
$163,323,596.00 $ 166,546,350.47 $ 170,946,35047 $ (4,400,000.00) -264%
35
Internal Support Expenditures 67.959 00 68,569 00 68,569 00 - 0.00%
Transfers Out - - - - 0.00%
$ 922.409 00 $ 923, 019 00 $ 778,019 00 $ 145,000.00 15 71 %
County Clerk (Vital Stats & Legal Rec's)
Personnel Expenditures $ 31727,083 00 $ 3,727,083 00 $ 3,1271083.00 $ 800,000.00 1610% Fay. due to vacancies, turnover and underfilled positions.
Operating Expenditures 295.160 00 295,160 00 210,160.00 85,000.00 2880% Fay. Court Transcripts $25,000, Office Supplies $25,000,
Professional Services $20,000 and Printing $15,000 due to
less than anticipated use
Internal Support Expenditures 880,258 00 817,112.00 817,112.00 - 000%
Transfers Out - - - - 0 00 %
$ 4,702.50100 $ 4,839,355.00 $ 4.154,355.00 $ 685,00000 14.15%
36
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
CLERIVREGISTER OF DEEDS
AMOUNT
ADOPTED
AMENDED
FY 2020 FAVORABLE
BUDGET
BUDGET
FORECAST (UNFAVORABLE)
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
$ 820,050.00
$ 820,050.00
$ 675,050.00 $ 145.000 00
17.68°% Fav due to vacant position
Operating Expenditures
34,400 00
34,400 00
34,400 00 -
0.00%
Internal Support Expenditures 67.959 00 68,569 00 68,569 00 - 0.00%
Transfers Out - - - - 0.00%
$ 922.409 00 $ 923, 019 00 $ 778,019 00 $ 145,000.00 15 71 %
County Clerk (Vital Stats & Legal Rec's)
Personnel Expenditures $ 31727,083 00 $ 3,727,083 00 $ 3,1271083.00 $ 800,000.00 1610% Fay. due to vacancies, turnover and underfilled positions.
Operating Expenditures 295.160 00 295,160 00 210,160.00 85,000.00 2880% Fay. Court Transcripts $25,000, Office Supplies $25,000,
Professional Services $20,000 and Printing $15,000 due to
less than anticipated use
Internal Support Expenditures 880,258 00 817,112.00 817,112.00 - 000%
Transfers Out - - - - 0 00 %
$ 4,702.50100 $ 4,839,355.00 $ 4.154,355.00 $ 685,00000 14.15%
36
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
CLERK/REGISTER OF DEEDS
AMOUNT
ADOPTED AMENDED FY 2020 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Elections
Personnel Expenditures $ 924,555.00 $ 924,555.00 $ 744,555.00 $ 180,000.00
Operating Expenditures 960,05300 960,05300 960,053.00 -
Internal Support Expenditures 287,57500 297,73300 297,733.00 -
Transfers Out - - - -
$ 2.172,183 00 $ 2182,34100 $ 2,002,341.00 $ 180,00000
Register of Deeds (and Micrographics)
Personnel Expenditures $ 2.67874700 $ 2,678,74700 $ 2,328,747.00 $ 350,00000
Operating Expenditures 274,49400 275,173.24 $ 159,17324 116,00000
Internal Support Expenditures
Transfers Out
275 020 00 275,212 00 $ 275.212 00 -
$ 3,228,261.00 $ 3,229,132.24 $ 2;763,13224 $ 466,000.00
1947% Fav due to turnover and underfilled positions
000%
0.00%
0.00°%
8.25%
13.07% Fav due to turnover and underfilled positions.
4216% Fay. Material and Supplies $35,000. Metered Postage
$35.000, Professional Services $20,500, Office Supplies
$20,000, Expendable Equipment $5,500 due to less than
anticipated use.
000%
0 00%
14.43%
37
Department Total
Personnel Expenditures $ 8,168,131.00 $ 8,168,131.00 $ 6.886,631.00 $ 1,281,500.00 1569%
Operating Expenditures 1,632,883.00 1,633,562.24 1,382,562.24 $ 251,00000 1537%
Internal Support Expenditures 1,310,921.00 1,458,900.00 1458,90000 $ - 000%
Transfers Out - - - 000%
$ 11,111,93500 $ 11,260,593.24 $ 9,728,093.24 $ 1,532,50000 13.61%
38
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
CLERKIREGISTER OF DEEDS
AMOUNT
ADOPTED
AMENDED
FY 2020 FAVORABLE
BUDGET
BUDGET
FORECAST (UNFAVORABLE)
PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Jury Commission
Personnel Expenditures
$ 17,696.00
$ 17,696.00 $
11,196.00 $ 6,500.00
3673%
Fay. due to COVID-19 Juror questionnaires not being sent
out.
Operating Expenditures
68,776.00
68,776.00
18,776.00 50,000.00
7270%
Fay. Metered Postage $45.000 and Printing $5,000 due to
less than anticipated use.
Internal Support Expenditures
109.00
274.00
274.00 -
000%
$ 86,581.00
$ 86,746.00 $
30,246.00 $ 56,500.00
6513%
Department Total
Personnel Expenditures $ 8,168,131.00 $ 8,168,131.00 $ 6.886,631.00 $ 1,281,500.00 1569%
Operating Expenditures 1,632,883.00 1,633,562.24 1,382,562.24 $ 251,00000 1537%
Internal Support Expenditures 1,310,921.00 1,458,900.00 1458,90000 $ - 000%
Transfers Out - - - 000%
$ 11,111,93500 $ 11,260,593.24 $ 9,728,093.24 $ 1,532,50000 13.61%
38
Administration
Personnel Expenditures
Operating Expenditures
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
COUNTYTREASURER
Internal Support Expenditures 925,577.00 1,153,85900 1.153,85900 - 0.00%
Transfers Out 120,000.00 229,150.00 65,000.00 164,150.00 71.63% Fav due to pausing non -emergency demolitions in response to
COVI D-19 pandemic
Division Total $8,680,73000 $ 9,018,162.00 $ 7,334,012.00 $ 1,684,15000 18.68%
Department Total $8,680,73000 $ 9,018,162.00 $ 7,334.012.00 $ 1,684,15000 18.68%
____________ ______________ _____________ ----------------
39
AMOUNT
ADOPTED
AMENDED
FY 2020
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE)
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
$ 3,576,383 00 $
3,576,383.00
$ 3,256,383.00
$ 320.000 00
8.95% - Fav due to turnover. underfills and vacant positions
4,058,770 00
4,058,770 00
2 858,770.00
1,200,000 00
29.57% - Fav Title Search $400,000, Contracted Services $345,000, Fees
Civil Service $210,000. Recording Fee Redemption Certification
$150.000 and Foreclosure Notification $70,000 due to lessthan
anticipated use
Internal Support Expenditures 925,577.00 1,153,85900 1.153,85900 - 0.00%
Transfers Out 120,000.00 229,150.00 65,000.00 164,150.00 71.63% Fav due to pausing non -emergency demolitions in response to
COVI D-19 pandemic
Division Total $8,680,73000 $ 9,018,162.00 $ 7,334,012.00 $ 1,684,15000 18.68%
Department Total $8,680,73000 $ 9,018,162.00 $ 7,334.012.00 $ 1,684,15000 18.68%
____________ ______________ _____________ ----------------
39
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
BOARD OF COMMISSIONERS
$4,780,007.00 $5,693,13000 $5,578.13000 $ 115,00000 2.02%
Department Total
Personnel Expenditures
$3,27215500
$3,272.155.00
$3,172,155.00 $ 100,00000
AMOUNT
Operating Expenditures
972,722.00
ADOPTED
AMENDED
FY 2020
FAVORABLE
535,13000
637,823.00
BUDGET
BUDGET
FORECAST
(UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
- -
$4,780,00700
________________________
$5,693.13000
Personnel Expenditures
$3,272,155.00
$3,272,15500
$3,172,15500
$ 100,000.00
3.06% - Fay. due to vacancy, turnover, and undefilled positions.
Operating Expenditures
972,722.00
1,783,152 00
$1,768,152 00
15,000.00
0.84% - Fay. Personal Mileage $10,000 and Periodicals. Books, Publ Sub $5,000 due to
decreased activity
Internal Support Expenditures
535,130.00
637,82300
$ 637,82300
-
0.00%
Transfers Out
-
-
-
$4,780,007.00 $5,693,13000 $5,578.13000 $ 115,00000 2.02%
Department Total
Personnel Expenditures
$3,27215500
$3,272.155.00
$3,172,155.00 $ 100,00000
306%
Operating Expenditures
972,722.00
1783,152.00
1.768,152.00 15,00000
084%
Internal Support Expenditures
535,13000
637,823.00
637,823.00 -
000%
Transfers Out
-
-
- -
$4,780,00700
________________________
$5,693.13000
$5,578,130.00 $ 115.000.00
____________
_
202%
40
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
WATER RESOURCES COMMISSIONER
Internal Support Expenditures
7,127,379.00
7,265,034.00
7.266,134 00
AMOUNT
Transfers
56,16500
ADOPTED
AMENDED
FY 2020
FAVORABLE
$ 7,901,02000
$ 8,039,299.00 $
BUDGET
BUDGET
FORECAST
(UNFAVORABLE; PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Water Resource Commissioner
14,900.00
Personnel Expenditures $
229,501.00
$ 229,501.00
$ 229,501.00
$ - 000%
Operating Expenditures
487,975.00
488,599.00
472,599.00
16.000.00 3 27 %
Fav - Office Supplies $8,000 the result of people working from home less
demand for the office supplies Fav -Travel and Conference $8,000 due to the
travel restrictions as a result of the COVID-19 pandemic.
Internal Support Expenditures
7,127,379.00
7,265,034.00
7.266,134 00
(1,100.00)
Transfers
56,16500
56,16500
56,165.00
-
Division Total
$ 7,901,02000
$ 8,039,299.00 $
8024,399.00 $
14,900.00
Department Total
$ 7,901,02000
$ 8,039,29900 $
8,024,39900 $
14,900.00
-002% Unfav - Insurance Fund ($1,000) due to an increase in the number of random
drug tests
019%
41
Compliance Office
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 1,710,520.00 $ 1,710,520.00 $ 1,630,520.00 $ 80,000.00 4.68% Fay. Salaries and Fringe Benefits primarily due to
vacancies.
36,507.00 38,610.25 22,610.25 16,000.00 4144% Fay. Professional Services $8,000 and Travel and
Conference $8,000 due to less than anticipated
use.
204,703.00 250,215.00 250,215.00
uxrvvn
$ 1,951,73000 $ 1,999,345.25 $ 1,903,345.25 $ 96,000.00 4.80%
42
COUNTY OF OAKLAND
FY
2020 SECOND QUARTER REPORT
EXPENDITURES
COUNTY EXECUTIVE
AMOUNT
ADOPTED
AMENDED
FY 2020 FAVORABLE
BUDGET
BUDGET
FORECAST (UNFAVORABLE)
PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
$ 2,434,160 00
$ 2,660,047.00
2,410,047 00 $ 250,000.00
9.40%
Fav Salaries and Fringe Benefits primarily due to
turnovers and underfilled positions.
Operating Expenditures
474,129.00
702,120.30
748,820 30 (46,700.00)
-665%
Unfav Special Projects ($40,000), Advertising
($5,500), Periodicals Books Publ ($5,000),Tmvel
and Conference ($5,000), Library Continuations
($2,600), and Special Event Program ($2,600) due
to increased activity Partially offset by favorable
Personal Mlleage $6,000, Metered Postage $6,000
and Membership Dues $2,000 due to less than
anticipated use.
Internal Support Expenditures
439,572.00
560,461.00
599,461.00 (39,000.00)
-6.96%
Unfay. Info Tech Operations ($50,000) due to
greater than anticipated usage; partially offset by
Motor Pool $6,000 and IT Managed Print Services
$5,000 based on decreased activity.
Transfer Out
-
-
- -
$ 3,347,861.00
$ 3,922,628.30
$ 3,758,328.30 $ 164,300.00
4.19%
Compliance Office
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$ 1,710,520.00 $ 1,710,520.00 $ 1,630,520.00 $ 80,000.00 4.68% Fay. Salaries and Fringe Benefits primarily due to
vacancies.
36,507.00 38,610.25 22,610.25 16,000.00 4144% Fay. Professional Services $8,000 and Travel and
Conference $8,000 due to less than anticipated
use.
204,703.00 250,215.00 250,215.00
uxrvvn
$ 1,951,73000 $ 1,999,345.25 $ 1,903,345.25 $ 96,000.00 4.80%
42
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
COUNTY EXECUTIVE
43
AMOUNT
ADOPTED
AMENDED
FY 2020
FAVORABLE
___________________________
_______________
BUDGET
______________
BUDGET
_______________
FORECAST
(UNFAVORABLE)
_________________
PERCENT
_________
EXPLANATION OF SIGNIFICANT VARIANCES
_______________________________________
Corporation Counsel
Personnel Expenditures
$
2,738,641.00
$
2,738,641.00
$
2,723,641.00
$ 15,000.00
0.55%
Fay. Salaries and Fringe Benefits primarily due
to turnovers.
Operating Expenditures
87,333.00
96,488 00
87,988.00
8,500.00
8.81%
Fay. Travel and Conference $6,000, Office Supplies
$2,000, Personal Mileage $1,500 and Computer
Supplies $1,500 due to less than anticipated use,
partially offset by Computer Research Service
($2.500) due to increased cost.
Internal Support Expenditures
288,071.00
327,781.00
327,781.00
-
0.00%
$
3,114,045.00
$
3,162,91000
$
3,139,410.00
$ 23,50000
0.74%
Department Total
Personnel Expenditures
$
6,883,321.00
$
7,109,208.00
$
6,764,208.00
$ 345,000 00
485%
Operating Expenditures
597,969 00
$
837,218.55
859,418 55
(22,200.00)
-2.65%
Internal Support Expenditures
932,346.00
1,138,457.00
1,177,457.00
(39,000.00)
-3.43%
Transfers Out
-
-
-
-
$
_______________
8,413,636.00
____
$
______________
______________
9,084,883.55
$
_______________
______
8,801,083.55
$ 283,80000
_________________
312%
43
$10,105,584.00 $ 10,200,602.23 $ 9,695,102.23 $ 505,500.00 496%
44
COUNTY OF OAKLAND
FY 2020 SECOND
QUARTER REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
AMOUNT
ADOPTED
AMENDED
FY 2020
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE)
PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Personnel Expenditures
$ 235,956.00
$ 35,956.00
$ -
$ 35,95600
10000%
Fav due to vacant position
Operating Expenditures
4,017.00
204,017 00
202,01200
2,000 00
098%
Fav Training $2,000 due to vacant Management and
Budget Director position
Internal Support Expenditures
13,064 00
13,064.00
13,064.00
-
000%
$ 253,03700
$ 253,03700
$ 215,08100
$ 37,956.00
1500%
Equalization
Personnel Expenditures
$ 8,899,064 00
$ 8,899,064 00
$ 8,369,064 00
$ 530,000 00
596%
Fav Balance $300,000 and $300,000 Fringe Benefits due
to underfills, turnover and vacant positions. Offset by
unfav Hazard Pay ($60,000) and Overtime ($10,000)
resulting from COVID-19 response.
Operating Expenditures
431,404 00
431,404 00
295,404 00
136,000.00
31.52%
Fay. Printing $40,000, Personal Mileage $38,000,
Professional Services $25,000, Office Supplies $20,000,
Membership Dues $10,000, and Training $3,000 due to
less than anticipated use
Internal Support Expenditures
991,50800
1,116,32200
1,116,3220D
-
0.00%
$10,321,97600
$10,446,79500
$ 9,780,79500
$ 666,000.00
6.38%
Fiscal Services
Personnel Expenditures
$ 8,474,744.00
$ 8,474,744A0
$ 8,024,744.00
$ 450,000.00
531°/%
Fav due to turnover pettily offset by COVID-19 impact
Operating Expenditures
383,600 00
418,550 23
363,050.23
$ 55.500 00
1326%
Fav due to Metered Postage $20,000, Professional
Services $12,000, Training $8,500, Office Supplies $7,500,
Printing $4,000, Personal Mileage 52,000, and Publishing
Legal Notices $1,500 being less than anticipated
Internal Support Expenditures
1,247,24000
1,307,308.00
1,307,308.00
$ -
000%
$10,105,584.00 $ 10,200,602.23 $ 9,695,102.23 $ 505,500.00 496%
44
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
MANAGEMENT AND BUDGET
AMOUNT
ADOPTED AMENDED FY 2020 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Department Total
Personnel Expenditures
$17,609,764.00
$
17,409,76400
S 16,393,808.00
$ 1,015,95600
5.84%
Operating Expenditures
819,02100
1,053,97123
860,471.23
193,50000
1836%
Internal Support Expenditures
2,251,81200
2,436,69900
2,436,69900
-
000%
Transfers Out
-
-
- -
0.00%
$ 20,680,597
00 $
20,900 434.23
$ 19,690,978.23
S 1,209,456 00
579%
45
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
- - 000%
$ 2,457,640.00 $ 2,466,45600 $ 2.461,356.00 $ 5,10000 021%
$ 1,522,133.00 $ 1,522.13300 $ 1,522,133.00 $ - 000%
386,898.00 386.898.00 379,298.00 7,600.00 1.96%
800,97600 809,79200 809,19200 600.00 0.07%
- - - 000%
$ 2,710,007 00 $ 2,718,823.00 $ 2,710,623 00 $ 8.200 00 0.30%
46
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
CENTRAL SERVICES
AMOUNT
ADOPTED
AMENDED
FY 2020 FAVORABLE
BUDGET
-------------
BUDGET
FORECAST (UNFAVORABLE)
PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
$ 235, 873 00
$ 235,873 00 $
235.873.00 $ -
0 00 %
-
3.298 00
3,298 00
798.00 2,500.00
75 805'.
- Fay. Travel and Conference due to restrictions as it relates to
the COVID-19 pandemic.
13,196 00
13,196 00
12,596.00 600.00
4.55%
- Fav Motor Pool Charges $600 due to less than anticipated
mileage costs because of travel restrictions.
$ 252,367.00
$ 252.367.00 $
249,267.00 $ 3,100.00
1.23%
$ 1,286,26000
$ 1,286,260.00 $
1,286,260.00
0.00%
-
383,600 00
383,600 00
378,500 00 5,10000
1.33%
- Fay. License and Permits $14,700 due to less than anticipated
fees from vendors; partially offset by unfavorable Software
Rental Lease Purchase ( $7,900) for due to higherthan
anticipated cast of software
787.780 00
796,596 00
796,596 00 -
0 00 %
- - 000%
$ 2,457,640.00 $ 2,466,45600 $ 2.461,356.00 $ 5,10000 021%
$ 1,522,133.00 $ 1,522.13300 $ 1,522,133.00 $ - 000%
386,898.00 386.898.00 379,298.00 7,600.00 1.96%
800,97600 809,79200 809,19200 600.00 0.07%
- - - 000%
$ 2,710,007 00 $ 2,718,823.00 $ 2,710,623 00 $ 8.200 00 0.30%
46
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Facilities Engineering
Personnel Expenditures
Operating Expenditures
Intemal Support Expenditures
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
$1,098,31500
$1,09&31500 $
1,090 815.00
COUNTY OF OAKLAND
7,50000
0.68%
341,714
00
FY 2020 SECOND QUARTER REPORT
279,829.00
89,550 00
24.24%
187,42900
EXPENDITURES
188.851 00
183,851.00
5,00000
265%
FACILITIES MANAGEMENT
$1656,54500 $
11554.495.00
$
102,05000
AMOUNT
ADOPTED
AMENDED
FY 2020
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
$ 222,124 00
$ 222,124 00
$
222,124 00
$ - 000%
5,76400
5,76400
3,21400
2,550 00 44.24%
Fay. Travel and Conference $1,750 due to imposed travel
restnctions. Fay. Printing $800 due to less than anticipated usage
as a result of COVID-19.
95,584 00
95,584 00
95,584 00
- 0.00%
A Second Quarter budget amendment is recommended to
reallocate funding from Facilities Administration to Facilities
Planning and Engineering within Info Tech Operations for the
purchase and use of associated software.
$ 323,472 00
$ 323 472.00
$
320,922 00
$ 2,55000 &79%
$ 876 191.00
$ 876,191.00
$
868,691.00
$ 7,50000 O.86%
Fay. due to less than anticipated use of overtime and
tumover/undertllled positions.
335,950.00
363,615.00
276,615.00
87,000 00 23 93 %
Fay. Professional Services $75,000 as COVID-19 has put a hold
on regular activities normally requiring the use of Professional
Services Fay. Training $8.000 due to imposed travel restrictions
Fay. Software Rental Lease Purchase $4,000 due to document
exchange software no longer needed
91,845.00
93,267.00
88,267.00
5,00000 536%
Fay. Info Tech Operations $5,000 due to less than anticipated
usage as a result of COVID-19
$1303,986.00
$1,333,073.00
$
1,233,573.00
$ 99,50000 7.46%
$1,098,31500
$1,09&31500 $
1,090 815.00
$
7,50000
0.68%
341,714
00
369 379 00
279,829.00
89,550 00
24.24%
187,42900
188.851 00
183,851.00
5,00000
265%
$1,627,45800
$1656,54500 $
11554.495.00
$
102,05000
616%
47
ADOPTED
BUDGET
Administration
Personnel Expenditures $ 835,32700 $
Operating Expenditures 342,243.00
Internal Support Expenditures 101,506 00
Transfers Out -
$ 1279,076.00 $
Workforce Management
Personnel Expenditures $ 2,231,24300 $
Operating Expenditures 366,664.00
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
HUMAN RESOURCES
AMOUNT
AMENDED FY 2020 FAVORABLE
BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
758.824 00 $ 658,824 00 $ 100,000.00 13.18% Fav due to vacancies and turnover
742,243.00 603,243 00 139,000 00
111,041.00 81,041.00 30,00000
1,612,10800 $ 1,343,108.00 $ 269,00000
2.231.243 00 $ 2.231,243 00 $ -
445.874.00 289.874.00 156,000 00
Internal Support Expenditures
515,19600
549,138.00
549,138.00
-
$
3.113,103.00 $
3,226,25500
$
3,070,255.00 $
156,000.00
Department Total
Personnel Expenditures $
3,066,57000 $
2,990,06700
$
2,890,067.00 $
100,000.00
Operating Expenditures
708,907.00
1,188.117
00
893,117 00
295,000 00
Internal Support Expenditures
616,702.00
660,179
00
630,179 00
30,000.00
Transfers Out
-
-
-
-
$
4,392,179.00$
____________ _________________
4,838,363.00 $
_________________
4,413,363 00 $
---------------
425,000 00
1873% Fay. Professional Services $100,000 and Travel and
Conference $19.000 due travel restrictions relating to
the COVID-19 pandemic Also favorable Legal Services
$20.000 due to less than anticipated activity
27.02% Fay. Info Tech Operations $30,000 due to less than
anticipated use
16.69%
0.00%
34.99% Fay. Recruitment Expense $50.000, Examination
Material $40,000 and Employes Medical Exams
$35,000 due to hiring freeze Also, favorable
Professional Services $25,000 due to less than
anticipated use
0.00%
4.84%
334%
24.83%
454%
878%
48
ADOPTED AMENDED
BUDGET BUDGET
Administration
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
AMOUNT
FY 2020 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Personnel Expenditures $
220,614.00 $
220,614.00 $
220,614.00 $
- 0.00%
Operating Expenditures
4,986,668.00
4,990,668 00
4,519.668.00
471,000 00 9.44%
Fav due to Private Institutions $419,000, Professional
Services $43,000, and Travel & Conference $9,000 being
less than anticipated
Internal Support Expenditures
9,397.00
9,397.00
9,397.00
- 0.00%
Transfers Out
-
-
-
$
5,216,679.00 $
5,220,679.00 $
4,749,679.00 $
471,000.00 902%
Health
Personnel Expenditures $ 28,170,09700 $ 28,394,838.00 $ 27,619,138.00 $
Operating Expenditures 3,615,149 00 7,164,960.90 6,694,760.90
Internal Support Expenditures 3,132,669.00 3,513,922.00 3,682,222.00
775,700.00 2.73% Fay. due to vacancies and underhlls $1,169,900 Partially
offset by unfay. Hazard Pay (394,400) as it relates to the
COVID-19 pandemic.
470,200 00 6.56% Fay. due to Professional Services $274,000, Drugs
$50,000, Personal Mileage $97,900, Travel & Conferences
$20,900, Equipment Maintenance $12,600, Metered
Postage $10,000, Training -Educational Supplies $10,000,
and TS Cases Outside $7,000 being less than anticipated.
Partially offset by unfay. Laboratory Fees ($11,200) and
Workshops & Meetings ($1,000) being more than
anticipated.
(168,300.00) -4.79% Unfay. due to Info Tech Operations ($175,400), and Info
Tech Managed Print Svcs ($5,000) being more than
anticipated. Offset by fav Motor Pool $6,000 and Radio
Communication $6,100 being less than anticipated
Transfers Out - 40,161.00 40,161.00 -
$ 34,917,915.00 $39,113,881.90 $ 38,036,281.90 $ 1,077,60000 2.76%
49
Children's Village
Personnel Expenditures
Operating Expenditures
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
AMOUNT
ADOPTED AMENDED FY 2020 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
$ 18,841,601.00 $ 19,038,887.00 $ 18,847,08700 $
3,945,872.00 4,077,805.58 3,627,005 58
Internal Support Expenditures 21725,281.00 2,775,641.00 2,823,141.00
Transfers Out - - -
$ 25,512,754.00 $ 25,892,333.58 $ 25,297,233.58 $
Homeland Security
Personnel Expenditures $ 914,483.00 S 914,483.00 $ 951,983.00 $
Operating Expenditures 294,267.00 347,371.15 347,371.15
Internal Support Expenditures 530,128.00 581,817.00 581,817.00
Transfers Out - - -
$ 1,738,878.00 $ 1,843,67115 $ 1,881,17115 $
EXPLANATION OF SIGNIFICANT VARIANCES
191,800.00 1.01% Fay. due to Fringe Benefits $581,800 being less than
anticipated. Offset by unfay. Hazard Pay ($390,000) as it
relates to the COVID-19 pandemic.
450,800.00 11 05% Fay. due to Contracted Services $150,000, Provisions
$121,800, Training -Educational Supplies $50,000, Drugs
$45,000, Hospitalization $19,000, Professional Services
$18,000, Security Supplies $16,000, Bedding and Linen
$9,000, Office Supplies $8,000, Equipment Maintenance
$8,000, and Metered Postage $6,000 being less than
anticipated
(47,500.00) -1.71% Unfay. due to Info Tech Operations ($81,700) being more
than anticipated. Offset by Radio Communication $27,000
and Motor Pool $7,200 being less than anticipated.
595,100.00 2.30%
(37,500.00) -410% Unfav Hazard Pay ($15,000) and Overtime ($22,500) due
to COVID-19 response.
0.00%
��nr�vn
(37,500 00) -2.03%
50
Department Total
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
HEALTH AND HUMAN SERVICES
AMOUNT
ADOPTED AMENDED FY 2020 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT
$ 48,146,79500 $ 48,568,822.00 $ 47,638,822.00 $ 930,000.00 1.91%
12,841,95600 16,580,805.63 15,188,805.63 1,392,00000 8.40%
6,397,475.00 6,880,777.00 7,096,577.00 (215,800 00) -3.14%
- 40,161.00 40,161.00 - 0.00%
$ 67,386.226.00 S 72,070,565.63 $ 69,964,365.63 $ 2,106,200 00 2.92%
EXPLANATION OF SIGNIFICANT VARIANCES
51
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
52
AMOUNT
ADOPTED
AMENDED
FY 2020
FAVORABLE
BUDGET
BUDGET
FORECAST
(UNFAVORABLE)
PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
--------------
Public Services -Admin.
Personnel Expenditures
$ 235,956.00
$
235.95600
235,956.00
$
-
0.00%
Operating Expenditures
4,800.00
4.80000
4,800.00
-
0.00%
Internal Support Expenditures
5 909.00
5,90900
5.909.00
-
000%
$ 246.665 00
$
246,665.00
$
246.665 00
$
-
0.00%
Veterans' Services
Personnel Expenditures
$ 1,670,971 00
$
1,670,971.00
1,595,971 00
$
75,000 00
4A9%
Fav due to vacant and underfilled positions
Operating Expenditures
189,62400
189,624.00
114,62400
75,00000
3955°%
Fav Soldier Burial $60,000 and Soldier Relief $10,000 and
Travel and Conference $5,000 due to less than anticipated
activity.
Internal Support Expenditures
221,439.00
244,13300
244,133.00
-
000%
Transfers Out
-
-
-
-
0 00 %
$ 2,082.034.00
$
2,104,72800
$
1,954 72&00
$
150.00000
713%
Community Corrections
Personnel Expenditures
$ 4,194 705 00
$
4,194,705 00
4,149 705.00
$
45,000 00
107%
Fay. due to vacant and underfilled positions
Operating Expenditures
502,025 00
502,025.00
399,525 00
102,500 00
20.42%
Fay. Contracted Services $90,000 Office Supplies $7,500
and Printing $5 000 due to less than anticipated use Also,
favorable Travel and Conference $6,000 due to travel
restrictions as a result of COVID-19.
Internal Support Expenditures
523,707.00
564,465 00
564,465.00
-
000%
Transfers Out
-
-
-
-
0.00% -
$ 5,220.43700
$
5.261,195 00
$
5,113.695.00
$
147.500.00
280%
52
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
AMOUNT
ADOPTED AMENDED FY 2020 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
------------------------
MSU Ext. - Oakland County
Personnel Expenditures $ 583,230 00 $ 583,230 00 $ 518.230 00 $ 65,000 00 11 14% Fay. due to vacant and undeflled positions
Operating Expenditures 310,779 00 310,779 00 185,779 00 125,000.00 4022% Fay. Primarily due to Professional Services $115.000, and
Workshop and Meeting $6,000 due to cancellation of
programs and moving services to online platform in response
to COVID-19 pandemic. Also, favorable Personal Mileage
$4.000 due to less activity relating to the pandemic
Internal Support Expenditures
314,361 00
318,489 00
318.489 00 -
000%
$
1.208,370 00 $
1,212,498.00 $
1,022.498.00 $ 190,00000
15.67%
Medical Examiner
Personnel Expenditures $
3,526,62600 $
3,526,626.00 $
3,526,62600 $ -
000%
Operating Expenditures
710,98000
733,162.00
628,16200 105,00000
1432%
Fav Laboratory Fees $40,000, Laboratory Supplies $40,000
and Transportation Service $35,000 due to less than
anticipated activity.
Internal Support Expenditures 783,367.00 833,747.00 833,747 00
Transfers Out - - -
000%
$ 5,020,973.00 $ 5,093,535.00 $ 4,988,53500 $ 105,000.00 206%
53
Animal Control
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers Out
Circuit Court Probation
Personnel Expenditures
Operating Expenditures
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
PUBLIC SERVICES
AMOUNT
ADOPTED AMENDED FY 2020 FAVORABLE
BUDGET BUDGET FORECAST (UNFAVORABLE)PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
$ 2.549.187 00 $ 2,612,847.00 $ 2,547,847 00 $ 65,000.00 2 49 % Fav due to on-call pay and overtime due to less than
anticipated use, as well as vacant and underflled positions.
Partially offset by an increase in hazard pay as it relates to the
COVI D-19 pandemic.
390,43600 394,286.00 394,28600 -
1,841,974 00 1,885,622 00 1.885,622 00 -
$ 4,781,59700 $ 4,892,75500 $ 4827,75500 $ 65,000.00
54,326 00 54 326 00 39.326 00 15,000.00
000%
000%
1.33%
0.00%
2261 % Fav Office Supplies $9,000, Metered Postage $3,000 and
Printing $3,000 due to less than anticipated use
internal Support Expenditures 628,44T00 635,462 00 635,462.00 - 000%
$ 662,773.00 $ 689,78800 $ 674,788.00 $ 15,00000 217%
Department Total
Personnel Expenditures
$ 12,760,675 00
$ 12.824,335.00 $
12.574,335.00 $ 250,000.00
195%
Operating Expenditures
2,162,970.00
2,189,002.00
1,766,502.00 422,500.00
19.30%
Internal Support Expenditures
4,319,204.00
4,487,827 00
4,487,827.00 -
000%
Transfers Out
-
-
- -
$ 19,242,84900
$ 19,501,164.00 $
18,828,66400 $ 672500.00
345°
54
Administration
Personnel Expenditures
Operating Expenditures
Internal Support Expenditures
Transfers
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS
AMOUNT
ADOPTED AMENDED FY 2020 FAVORABLE
BUDGET BUDGET FORECAST UNFAVORABLE PERCENT
$ 1,459.40200 $ 1,459,402.00 $ 1,479,40200 $ (20,00000)
442.22200 442,222.00 322,222.00 120,000.00
72.524 00 89,497.00 99,497 00 (10,000.00)
$ 6,531,738.00 $ 7,132,76993 $ 13.700,76B 93 $ 432,000.00
Community and Home Improvement
Personnel Expenditures $ - $ - $ - $ -
Operating Expenditures - - - -
Internal Support Expenditures - - - -
Transfers 495,01800 589.16100 589,161.00 -
$ 495,01800 $ 589,161.00 $ 589,161.00 $ -
EXPLANATION OF SIGNIFICANT VARIANCES
-137% Unfav due to Fringe Benefits ($20,000) being more than
anticipated
27 14% Fav due to Advertising $75,000. Printing $17,000, Personal
Mileage $10,000, Travel & Conference $7,000, Periodicals Books
Pub] Sub., $6.000, and Workshops & Meetings $5,000 being less
than anticipated
-11 17% Unfav due to Info Tech Operations ($10,000) being more than
anticipated
4.52%
4.70% Fav Salaries $200,000 due vacant positions and turnovers.
1043% Fav due to Workshop and Meetings $65,000. Printing $62,000
Business Recruiting $50,000, Travel & Conference $34,000,
Membership Dues $30,000, Advertising $20,000, Personal Mileage
$10,000 Drafting Supplies and Maps $10,000, and Metered
Postage $5,000 being less than anticipated. Offset by Professional
Services ($80,000) due to being more than anticipated.
2 89 % Fav Due to Info Tech Operations $20,000 and Insurance Fund
$6,000 being less than anticipated
606%
0.00%
0.00%
55
$ 1 974,148.00
$ 1,991,121 00
$ 1,901.121.00 $
90,000.00
Planning and Economic Development Services
Personnel Expenditures
$ 4,256,328.00
$ 4,256,328.00
$ 4,056.328 00 $
200,000.00
Operating Expenditures
1.383,998.00
1,975,241.93
1,769,241 93
206,000.00
Internal Support Expenditures
891 412.00
901,200.00
875,200 00
26,000.00
Transfers
-
-
-
-
$ 6,531,738.00 $ 7,132,76993 $ 13.700,76B 93 $ 432,000.00
Community and Home Improvement
Personnel Expenditures $ - $ - $ - $ -
Operating Expenditures - - - -
Internal Support Expenditures - - - -
Transfers 495,01800 589.16100 589,161.00 -
$ 495,01800 $ 589,161.00 $ 589,161.00 $ -
EXPLANATION OF SIGNIFICANT VARIANCES
-137% Unfav due to Fringe Benefits ($20,000) being more than
anticipated
27 14% Fav due to Advertising $75,000. Printing $17,000, Personal
Mileage $10,000, Travel & Conference $7,000, Periodicals Books
Pub] Sub., $6.000, and Workshops & Meetings $5,000 being less
than anticipated
-11 17% Unfav due to Info Tech Operations ($10,000) being more than
anticipated
4.52%
4.70% Fav Salaries $200,000 due vacant positions and turnovers.
1043% Fav due to Workshop and Meetings $65,000. Printing $62,000
Business Recruiting $50,000, Travel & Conference $34,000,
Membership Dues $30,000, Advertising $20,000, Personal Mileage
$10,000 Drafting Supplies and Maps $10,000, and Metered
Postage $5,000 being less than anticipated. Offset by Professional
Services ($80,000) due to being more than anticipated.
2 89 % Fav Due to Info Tech Operations $20,000 and Insurance Fund
$6,000 being less than anticipated
606%
0.00%
0.00%
55
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
EXPENDITURES
ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS
AMOUNT
ADOPTED AMENDED FY 2020 FAVORABLE
BUDGET BUDGET FORECAST UNFAVORABLE PERCENT
Workforce Development
Personnel Expenditures $
25,620.00
$ 25,620.00
$ 25,620.00
$ -
000%
Operating Expenditures
-
-
-
$ -
Internal Support Expenditures
-
-
-
-
$
25,620.00
$ 25,620.00
$ 25,620.00
$ -
0.00%
Department Total
Personnel Expenditures $
5,741,35000
$ 5,741,350.00
$ 5,561,350.00
$ 180.000.00
314%
Operating Expenditures
1,826,220.00
2,417.463.93
2,091,463.93
326.00000
1349%
Internal Support Expenditures
963,936.00
990,697 00
974,697.00
16.000.00
1 62%
Transfers
495,018.00
589 161 .00
589,161.00
-
0.00%
$ 9,026,524 00 $ 9,738 671 93 $ 9,216,671.93 $ 522,000 00 5.36%
EXPLANATION OF SIGNIFICANT VARIANCES
Fii
Juvenile Resentencing
1,131,00000 231,000.00 900,00000
PERCENT
EXPLANATION
000%
6005% Fav based on projected payments by Risk Management
-777% Unfav due to patent and trademark applications for use of
mark for the County's EHealth, Healthy Pont ad, and
Bicentennial declarations
000%
000%
0.00 %
000%
000%
009%
000%
000%
000%
000%
000%
000%
000%
000%
000%
000%
000%
000%
000%
10000% Fav due to timing of bond issuance for Faalities building
improvements for American Disabilities Act (ADA) and Lde
Safety needs across the County campus Debt payment is not
expected to occur in FY 2020
7958% Fav not expected to be used in FY 2020. Its anticipated to
carry fonxard to FY 2021
Legislative Expense
8,60000
8,60000
8,60000 -
COUNTY OF OAKLAND
Local Road Funding Program
1 00
1.00
BY
2020 SECOND QUARTER
REPORT
341,17000
592,86200
592,86200 -
NON -DEPARTMENTAL EXPENDITURES
Overtime Reserve
300,00000
220,00000
226,00000 -
000%
AMOUNT
365,144 00
-
ADOPTED
AMENDED
BY 2020
FAVORABLE
-
- -
BUDGET
BUDGET
FORECAST
(UNFAVORABLE)
NON -DEPARTMENT APPROPRIATIONS
10000% Fav not expected to be used in BY 2020
Salary Adjustment Reserve
3,156,70800
4,996,02400
496,02400 4,500,00000
COUNTY OPERATIONS
Secunty, Reserve
-
-
- -
000%
Insurance Fund
$
507,391.00 $
507,391.00
$ 50739100
$ -
InsuranceSuretyBonds
33,30500
33,30500
13,305.00
20,00000
Logos Trademarks Intellect Property
20,00000
20,000.00
21,55400
(1,55400)
Road CommissiornCument Drain Assessment
1,450,00000
1,881,000.00
1,881,000.00
-
RoadCommissioniPartyAgreement
100.00
1474,95500
1,474,95500
-
Interest Expense
-
-
-
-
Provisions
30,00000
6,030,00000
6,030,00000
-
TransfertoCommunityMental Health Authority
9,620,61600
9,620,616.00
9,620,61600
-
Total
$
11,661,412.00 $
19,567,267.00
111 19,54$821.00
$ 18,446.00
COUNTY BUILDINGS
$
2,630,034.00 $
2,312,275.00
$ 2,312,275.00
$ -
STATE AND FEDERAL - COUNTY ASSOCIATIONS
Michigan Assoc of Counties
$
73,00000 $
73,00000
$ 73,00000
$
Natural Assoc of Counties
24,100.00
24,100.00
24,10000
-
S E M C D.G
530,000.00
530,000 00
530,000 00
-
TraffclmprovemenlAssociation
30,000.00
30,00000
30,00000
-
Total
$
657,100.00 $
657,100.00
$ 657,100 00
$ -
SUNDRY EXPENSE
$
300,000.00 $
300,000.00
$ 300,000.00
$ -
RESERVED FOR TRANSFERS
Expenditures
Classification and Rate Change
$
113,371 00 $
113,371 00
$ 113,371 00
$ -
Ccntingency
283,78800
36,200.00
36,20000
Disaster Recovery
300,00000
300,00000
300,00000
Emergency Salaries
252,97600
252,97600
252,976.00
Grant Match
2,74128600
219,14900
219,149A0
-
InfoTechDevelopment
7,413,77700
5,32399100
5,323,99100
-
InlernalSupportExpenditures
1,05000000
1,050,00000
-
1,050,00000
Juvenile Resentencing
1,131,00000 231,000.00 900,00000
PERCENT
EXPLANATION
000%
6005% Fav based on projected payments by Risk Management
-777% Unfav due to patent and trademark applications for use of
mark for the County's EHealth, Healthy Pont ad, and
Bicentennial declarations
000%
000%
0.00 %
000%
000%
009%
000%
000%
000%
000%
000%
000%
000%
000%
000%
000%
000%
000%
000%
10000% Fav due to timing of bond issuance for Faalities building
improvements for American Disabilities Act (ADA) and Lde
Safety needs across the County campus Debt payment is not
expected to occur in FY 2020
7958% Fav not expected to be used in FY 2020. Its anticipated to
carry fonxard to FY 2021
Legislative Expense
8,60000
8,60000
8,60000 -
000%
Local Road Funding Program
1 00
1.00
1 00 -
000%
Mises Capital Ou0ay
341,17000
592,86200
592,86200 -
0.00%
Overtime Reserve
300,00000
220,00000
226,00000 -
000%
Private Institutions Foster Care
365,144 00
-
- -
000%
Private Institutions Residential
105,356 00
-
- -
0.00%
State Institutions
582,443 00
474,277 00
- 474,277.00
10000% Fav not expected to be used in BY 2020
Salary Adjustment Reserve
3,156,70800
4,996,02400
496,02400 4,500,00000
9007% Fav not anticipated due to compensation study on hold.
Secunty, Reserve
-
-
- -
000%
Substance Abuse Coord Agency
4,800,00000
4,800,000.00
4,800,000.00 -
000%
Summer Employees Salary Appropriation 250,00000 250,000.00 50,00000 200,000.00 8000% Fav based on anticipated use for FY 2020 57
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
NON -DEPARTMENTAL EXPENDITURES
TOTAL NON -DEPT. APPROPRIATIONS
$ 51,012,114.00
$ 58,247,41000
$ 48,164,687.00 $
AMOUNT
17.41%
TRANSFER TO GENERAL PURPOSE FUNDS
ADOPTED
AMENDED
FY 2020
FAVORABLE
Child Care Fund
$ 20 768 388 00
$ 20,393,36800
BUDGET
BUDGET
FORECAST
(UNFAVORABLE)
PERCENT
EXPLANATION
Telephone Communications
(335,29700)
(335,29700)
(335,29700)
-
000%
$ 17,394,368.00 $
Total
$ 21,729,323.00 $
19,433,154.00 $
12,308,877.00
$ 7,124,277.00
3666%
13,142,723.00
Transfers to Other Funds
Fire Records Management
$ 507,69900 $
507,699.00 $
507,69900
-
000%
CLEMIS
1,644,18600
1,644,186.00
1644,18600
-
0.00%
Information Technology
3,620,67600
3,714,04500
3,714,04500
-
000%
Bldg Aum Fac Infra. IT Debt
2,220,50000
2,220,50000
2,M,50000
-
000%
Project Work Order Fund
500,00000
500,00000
500,00000
-
000%
Michigan Economic Development
-
1,850,00000
1,850,00000
-
0.00%
Building Fund
5,500,00000
5,50000000
2,500,00000
3,000.00000
54.55%
Favorable due to postponement of CIP projects Abudget
amendment will be included oath the 3rd Qtr Forecast
HR- Financial System Replacement Project
41,18400
41,18400
41,18400
-
0.00%
$ 14,034,245.00 $
15,977,614.00 $
12,977,614.00
$ 3,000,00000
18.78%
TOTAL NON -DEPT. APPROPRIATIONS
$ 51,012,114.00
$ 58,247,41000
$ 48,164,687.00 $
10,142,723.00
17.41%
TRANSFER TO GENERAL PURPOSE FUNDS
Child Care Fund
$ 20 768 388 00
$ 20,393,36800
$ 17,39336800 $
3,000,00000
1471% Fav Due to anticipated usage
Social Welfare Fund Foster Care
1,00000
1,000.00
1,000.00
-
0.00%
$ 20,769,38800
$ 20,394,36800
$ 17,394,368.00 $
3,000,000.00
14.71%
TOTAL EXPENDITURES
$ 71,781,502.00
$ 78,641,778.00
$ 65,499,055.00 $
13,142,723.00
1671%
58
FY 2020 BUDGET AMENDMENTS
FY 2020 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS $ 475,619,369.00
BUDGET AMENDMENTS
M.R.#19333 10/2312019
Board of Commissioners - Technology Hardware Replacement Implementation - Phase One $ 93,369.00
M.R.#19335 10/23/2019
Board of Commissioners - Human Resources Wages of the Labor Agreement for the Employees Represented by
the Government Employees Council (GELC)
$ 98,643.00
M.R.#19337 10/23/2019
Board of Commissioners - Human Resources Wages of the Labor Agreement for the Employees Represented by
the Michigan American Federation of State, County and municipal Employees, Council 25, Local 2437 (AFSCME) $ 8,643.00
M.R.#19338 10/2312019
Sheriff's Office - Contract Amendment #1 for Law Enforcement Services In The Charter Township of Oxford 2019-
2021 $ 269,922 00
M.R. #19342 - 10/23/2019
Management & Budget FY 2019 Third Quarter Report
Adjustments to Circuit Court $ (280,000.00)
Adjustments to Sheriff's Office $ (2,500.00)
$ (282,500.00)
M.R. #19358 -1110712019
Economic Development and Community Affairs -Community and Home Improvement Division -
2019 Annual Action Plan Acceptance for Community Development Block Grant (CDBG), Home
Investment Partnerships Act Program (HOME) and Emergency Solutions Grant (ESG) $ (495,018.00)
M.R. #19362 -11/0712019
Sheriff's Office - FY 2020 Traffic Safety Enforcement - Grant Acceptance $ 31,824.00
M.R. #19381 -12/12/2019
Board of Commissioners - Tri -Party Road Improvement Program Fiscal Year 2019
Appropriation - Township of Novi - Crack Sealing on Various Local Roads - Project No.55352 $ 318.00
M.R. #19384 -12/12/2019
Board of Commissioners - Tri -Party Road Improvement Program Fiscal Year 2019
Appropriation - City of Royal Oak - Traffic Signal Upgrade and Street Lighting on 12 Mile Road -
Project No. 54651 $ 35,056.00
M.R. #19403 - 12112/2019
Sheriff's Office - Contract Amendment #1 for Law Enforcement Services in the Charter
Township of Independence 2019-2021 $ 213,465 00
M.R. #19411 - 12112119
Management & Budget Fiscal Year 2019 Year -End Report and Budget Amendments
Encumbrances $ 642,380.14
Carry Forwards $ 9,224,118 00 $ 9,866,498.14
M.R. #19412 - 12/1212019
Board of Commissioners - Establishment of a Bicentennial Oak Tree Program Policy $ 75,000.00
59
FY 2020 BUDGET AMENDMENTS
M.R. #20020 - 01/22/2020
Health and Human Services - Homeland Security Division - Outdoor Warning System
Expansion - The City of Farmington Hills
M.R. #20021 - 01/22/2020
Sheriff's Office - Contract Amendment #1 for Law Enforcement Services in the Township of
Addison 2019-2021
M.R. #20022 - 01/2212020
Sheriff's Office - Contract Amendment #2 for Law Enforcement Services in the Charter
Township of Commerce 2019-2021
M.R. #20023 - 01/2212020
Sheriff's Office - Contract Amendment #1 for Law Enforcement Services in the Charter
Township of Highland 2019-2021
M.R. #20024 - 0112212020
Sheriff's Office - Contract Amendment #1 for Law Enforcement Services in the City of Pontiac
2019-2021
M.R. #20025 - 01122/2020
Sheriff's Office - FY 2020 Oakland County Gang and Violent Crime Safe Streets Task Force
(SSTF) - Grant Acceptance
M.R. #20026 - 01/22/2020
Sheriff's Office - FY 2020 Joint Terrorism Task Force (JTTF) - Grant Acceptance
M.R. #20061 - 03/05/2020
Board of Commissioners -Sponsorship of the 2020 International Bocce Tournament at the
Palazzo Di Bocce
M.R. #20062 - 03/05/2020
Board of Commissioners -Oakland County Supports Local Response to the Coronavirus
Outbreak
M.R. #20054 - 03/18/2020
Board of Commissioners - Tri -Party Road Improvement Program Fiscal Year 2020
Appropriation - City of Huntington Woods - Sidewalk Replacement & ADA Ramp Upgrades on
10 Mile Road -project No. 55611
M.R. #20076 - 0311812020
Health and Human Services/Health Division - Agreement between the County of Oakland
Honor Community Health for Integrated Healthcare
M.R. #20081 - 0311812020
Board of Commissioners - Tri -Party Road Improvement Program Fiscal Year 2020
Appropriation - Charter Township of White Lake -Spreading of Gravel and Chloride on Various
Roads - Project No. 55652
M.R. #20085 - 03/18/2020
Board of Commissioners -Emergency Funding for Coronavirus Pandemic Response Measures
M.R. #20086 - 03/31/2020
Management & Budget FY 2020 First Quarter Report
Adjustments to Circuit Court
235,200.00
25,500.00
108,190.00
263,953 00
2,987.00
437,702.00
18,649.00
18,649.00
15,000.00
500,000.00
2,535.00
2,374,772.00
59,189.00
1,000,000.00
60
FY 2020 BUDGET AMENDMENTS
Adjustments to Sheriff's Office
Adjustments to Children's Village Child Care Fund
Adjustments to Non -Departmental
M.R.#20096-03/31/2020
Economic Development and community Affairs - Resolution Approving the Michigan Economic
Development Corporation Grant and Creation of the Oakland County Small Business
Stabilization Fund
M.R. #20097 - 03/31/2020
County Executive - Additional Emergency Fund for Coronavirus Pandemic Response Measures
TOTAL AMENDED BUDGET AS OF 03/3112020
18,764.00
47,031.00
(2,752.00) $ 298,243 00
1,850,000.00
5,000,000.00
$ 497,509,958.14
61
mendment IQuart�er—ded QTwPY
App UNDER QzrFv 2D2D
CEPTED
$'01000" R #190061 "pwardlA 9 000 00 Q2lFY 2020
GRO"S AC er . g
loved adminisirahvelY. pUnknown O21FY 2020
(apo Grant' 2 OOD 00
�ranbrook ent Agreement $
cil
GrantTitte hrise� (pRE) Oatl Out Reimbursem
{ _ e Year of Ponti'�cIC htin9 Training st and Bu dg
et
et
2019Th ninon ExP and Flre Fig '� Quarter Forecast
,vision 2020 Drug Recognition Rescue a Budget F'
IpepartmO" e D Gontractfor Aircraft ent and
Sheriff s OtFtce County 8 Depahment and Mana9em
2020 Oakland
Sheriff`s Office included vAb
erviceslAv,ation S statement for this 9ran1 was
Central S ment.
and WµERFi
ADOPTED AMENDED
BUDGET BUDGET
DELINQUENT TAX REVOLVING FUND 51600
REVENUES
Charges for Services $10,800,00000 $10,800,00000
Other Revenues
Total Revenues
OPERATING EXPENSES
Personnel Expenditures
Operating Expenditures
2,000 00000
$12 800,000.00
2,000,000 00
$12,800,000 00
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
ENTERPRISE FUND
TREASURER'S OFFICE
FY 2020 VARIANCE
FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
6,02000000 S (4,780,000.00) 4426% Unfav Intereston Delinquent Taxes S2,800, 000) and Collection
Fees ($1 900,000) due to lover number of delinquent parcels
turned over to the County Treasurer
2,460 000 00 460,000.00 23 00 % Fav Income from Investments based on the actual investment
income distributed to date but does not reflect market value
adjustments which vnll occur at the end of the fiscal year
$8480,000.00 $ (4,320,00000) -3375%
$ 224,502.00 $ 22450200 $ 194,50200 30,000.00
666,863 00 666,863.00 326,363 00 340,500 00
Interest Expense
793,750 00
793,750 00
000 793 750 00
Transfer Out to Other Funds.
000
General Fund - Collection Fees
2,500 00000
2,500,000 00
2,500 000.00 -
GF - Non -Departmental
3,000 00000
3,000,000 00
3,000 000.00 -
WorkReleaseFacilityRefundingDebtSvc
1,54630000
1,546,30000
1,546,300.00 -
Offce Bldg Renovation Refunding Debt Svc
1,891,50000
1,891,50000
1,891,50000 -
52-3 District Court Refunding Debt Svc
1.297.300 00
1,297.300 00
1 297.300-00 -
Total Transfer Out to Other Funds
$ 10.235.100.00
S 10,235 100 00
S 10 235 100.00 $
Total Operating Expenses
$ 11.920,215 00
$ 11,920 215 00
$ 10,755,965 00 $ 1,164,250 00
REVENUE OVER (UNDER)
EXPENDITURES*
$879,785 00
$879,785.00
($2,275,965 00) (S3 155,750 00)
Total Net Position - Beginning
$201,537,595 70
Total Net Position - Ending
$199,261,630.70
Ending FY 2019 Designated Net Position**
NP-UnRes - Designated - Debt Service
$63,054 573 00
NP-UnRes - Designated - Dehnq Taxes Receivable
133,886.974 11
NP-UnRes - Designated - Collection Fees
4,596 048 59
Undesignated - Net Position
($2.275,965 00)
Total Net Position - Ending
$199 261 630 70
* 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
1336% Fav Salaries and Fringe Benefits based on actual activity
51 06% Fav Info Tech Development $280,000 due to lower than
anticipated cost of Tax Management System Also, favorable
Administrative Overhead $30,000, Legal Services $25,000,
Professional Services - Financial Consultant $25 000 due to less
than anticipated use due to COVID-19. Unfav Indirect Casts
($19 500) due to actual charges determined after budget
100 00% Fav Interest Expense as no borrovnng will occur in FY 2020 due to
CDVID-19
0 00%
000%
000%
000%
000%
000%
977%
63
DELINQUENT PERSONAL PROPERTY
TAX (51800)
OPERATING REVENUE
OPERATING EXPENSE
NET OPERATING INCOME (LOSS)
NON-OPERATING REVENUE (EXPENSE)
TOTAL INCOME BEFORE
CONTRIBUTIONS AND TRANSFERS
TRANSFERS OUT
TOTAL NET INCOME (LOSS)` $000 $000 S75,000 00) ($75,000 00)
TOTAL NET POSITION - BEGINNING 872,314 60
TOTAL NET POSITION - ENDING $797,31460
Please note that in the Adopted Budget (line -dem book) this is budgeted as 'Planned Use of Balance" in the revenue category.
64
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
ENTERPRISE FUNDS
TREASURER
ADOPTED
AMENDED
FY 2020 VARIANCE
BUDGET
BUDGET
FORECAST FAV/(UNFAV)
PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
$506,136.00
$506,13600
$331,136.00 ($175,000 00)
-3458%
Unfay. Administration Fees ($175,000) due to decreased collection
fees
511,136.00
511,13600
411,136.00 $100,00000
1956%
Fav Controllable Personnel$90,000 due to vacant and underfilled
positions
($5,0(0 00)
(S5,00000)
($80,000.00) ($75,000.00)
0.00%
5,000.00
5,000.00
$5,000.00 $000
0.00%
$000
$0.00
$ (75,000.00) ($75,00000)
TOTAL NET INCOME (LOSS)` $000 $000 S75,000 00) ($75,000 00)
TOTAL NET POSITION - BEGINNING 872,314 60
TOTAL NET POSITION - ENDING $797,31460
Please note that in the Adopted Budget (line -dem book) this is budgeted as 'Planned Use of Balance" in the revenue category.
64
OAKLAND COUNTY PARKS & RECREATION COMMISSION
(50800)
OPERATING REVENUE
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
ENTERPRISE FUND
PARKS & RECREATION
ADOPTED AMENDED FY 2020 VARIANCE
BUDGET BUDGET FORECAST FAVI(UNFAV) PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
$ 10,948,749 00 $ 10,948,749 00 $ 10,837,449 00 $ (111,300 00) -102% Unfav Greens Fees S46,000), Rental Facilhes ($27,000), Reimb Contracts
($20,000), Rental Golf Carts ($10,000), Special Contracts ($4,000), Rental
Units or Events ($3,300) and Sales Retail ($1,000) the result of park
closures due to the COVID19 pandemic, as compared to previous years'
activity. A budget amendment will be recommended in the 3rd quarter of FY
2020 once the full impact of the pandemic is determined Expense offsets
from park closings are yet to be determined.
OPERATING EXPENSE
$
28,170,37800
$
28,695,760.00
$
28,695,76000
$ -
000%
NET OPERATING INCOME (LOSS)
$
(17,221,62900)
$
(17,747,011.00)
$
(17858,31100)
IS (111,30000)
-063%
NON-OPERATING REVENUE (EXPENSE)
$
14,357,077 00
$
14,427,077 00
$
14,437,477 00
$ 10,400 00
007% Fav Local Comm Stab,zabon Share $10,400 (Personal Property tax loss
reimbursement distnbuhon)
TOTAL INCOME BEFORE TRANSFERS
$
(2,864,552 00)
$
(3,319,934 00)
$
(3,420,834 00)
S (100,900 00)
-304%
TRANSFERSIN
$
-
$
-
$
-
$ -
TOTAL NET INCOME/PLANNED USE OF BALANCE (LOSS)-
$
(2,864,55200)
$
(3,319 934 00)
$
(3,420,834.001
$ (100,90000)
TOTAL NET POSITION - BEGINNING
$
87.084.58305
TOTAL NET POSTION- ENDING
$
83,663,749.05
"Please note that in the Adopted Budget Line -item book) this is budgeted as'Planned Use of Balance" in the revenue category
65
I
DRAIN EQUIPMENT FUND 163900)
OPERATING REVENUES
Inside
Outside
Total Revenue
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
INTERNAL SERVICE FUND
WATER RESOURCES COMMISSIONER
ADOPTED AMENDED
BUDGET FY 2020 VARIANCE
BUDGET FORECAST
----- - - --------
L VARIANCE
PERCENT
—� _------- EXPLANATION OF SIGNIFICANT VARIANCES
46,161 88500 46,196 856 00 46,140,444 00
250,30D 00 250,30000
250,300 00
46,432,185 00
$47,032,935 00
46,447,15600 46 390,744 00
$48,471,64400 $47596,154,00
($69075009) ($2,(12446800) ($1,2D5,41000)
(56 412 00) -D 12% Unfav-
rate all" ah"nbmethodo ogy f'r the poss bl st novati400) s result of the
Works Band'ng Protect has not been fina Zeds Fav hon cost oithe Public
incrSalaease
and abfish Reimbursement General $723,000 the result of h � salary
ent
increase and estahlisheo fifteen dollar minimum wage (M. R. the 2%,
hoursoffset by Fav- Vehicle Rental $100,000 due to under estimate of tillable
hours
000%
(56,412 00) -012%
$875,49000 '8'%
81%
Fav- Salaries and Fnnges $900,000 due to turnover, vacant pos�bons, 2%
Mary increase and established fifteen dollar minimum wage (M.R
#19334). Hazard Pay is not being exposed due to the vacant positions
Computer
the estimated ,000$78due
cost as of ApM 30. Fav - Depreciation
Computer Software $200,000 due to over estimated depredation
schedule Fav- Expandable actual
Equipment Expense $13. 800, Computer
supplies $5,000 due to by ual spending being less than anticipated
budget. Partially offset by unfav - Engmeenng Services- Other ($200,0001
the result of design cost for the possible renovation of the Public Works
Building. Unfav - Equipment Repair ($25,000) the result of unanbdpated
repairs for upkeep on aging equipment Unfav - Refund Prior Years
Revenue direct 0) due to a correction for mileage being charged twice
Unfav - Indirect Costs ($6,300) due to indirect cost rate finalized after
budget Process. Unfav _ AdJ Prior Years Revenue ($2,600) due to a
duplicate FY 2019 allocation corrected in FY 2020
$619,078.00 AD 46%
66
GOUNM OF OAK\- RREPORj
2020 SEGONOSvv,VtGE FUNO NER
1N1vRo, ES GOMNdsstO
StON1PGPN'! V PRtPNGES
,NXT µESOURG _,M ANpitON OP�.Y-..""....-�'" \nvesiment
E�^" on trye a� °e\ad1°'1m p00
VPR\PNGEV'1 PEROE=^ .."' J estment2565 rott�5ze O1E�°^d Govnon ne
OEO f GAM yAr,,,,,,/ Ear.\e°d°,s ebu;edte ed oe
68010 n9 �dat`he Oak
ppt,EN FO 19 tnCom °cur ePurP
AOOPTEO BUOOEt „`.r^'� 5112615p0 due to m\sOry\taneous
B,UDO� 538931500 3udO-
-"" '" 521610D OD
�1g;i0
too 000"ta
NON-OPER1't\NO REVENUE` 11500oo 524 �3000
300
0 oo 59g1 6
115 pp0� 2�5�
001010-565
-500)
197 136 sg85,
EN tN l51 9i1 318 O0) s.
lvtpNSF T 18fi 001 aF3�°nse
55
�� REVENUER OVER `UNDER) 14g0� $ 2z a5y 082 55
„ in the reaeMe gte9°ry �dgud0eted EqudY �)
N�PENSES' d ance
G .,Punned use of Fan
bat
O\NN\N
jOSt O
OTFt-N PPppd Pep 80d9ei 4�nem 000k)trnsrs bad9eted °s
ethat m
.Please
0
6l
PLIABILITY INSURANCE FUND 67700
OPERATING REVENUES
Outside Revenue
Inside Revenue
COUNTY OF OAKLAND
FV 2020 SECOND QUARTER REPORT
INTERNAL SERVICE FUND
RISK MANAGEMENT
ADOPTED AMENDED FY 2020 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT
$ 10,573.00 $ 10,57300 $
4,347,75000 4.347,75000
10,57300 $ - 000%
4,347,75000 - 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
Total Operating Revenue
$ 4,358,323.00
$
4,358,32300
$
4,358,32300
S
-
0.00%
OPERATING EXPENSE
$ 3,740,067 00
$
3,740,067 00
$
3,737 967 00
$
2,10000
006%
- Fay. Expendable Equipment $33,100 and Medical Supplies $6,415 due
to Automated External Defibrillators (AEDs) useful Ile extended due to
supportfrom manufacturer. Unfav Indirect Cost ($22,100)dueto
actual charges determined after budget finilizahon IT Development
($11,100) due to more than anticipated usage and Motor Pool S4200)
due to addition of second vehicle
CLAIMS PAID
1,532.52800
1,53252800
1,53252800
-
0.00%
TOTAL OPERATING EXPENSES
$ 5,272,59500
$
5,272,59500
$
5,270,49500
$
2,10000
0.04%
OPERATING INCOME (LOSS)
(91427200)
(914,272.00)
(912,17200)
2,10000
-0.23%
NON-OPERATING REVENUE (EXPENSE)
150,00000
150,00000
150,00000
-
0.00%
NET REVENUES OVER/(UNDER)
EXPENSES
$ (764,272 00)
3
(764,272 00)
(762,17200)
$
210000
TOTAL NET ASSETS - BEGINNING
1.811.063 00
TOTAL NET ASSETS - ENDING
$
1 048 891 .00
Please note that in the Adopted Budget (line -item book) this is budgeted as 'Planned Use of Balance" in the revenue category
5/25/2020
68
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
69
ADOPTED
AMENDED
FY 2020
VARIANCE
FRINGE BENEFITS FUND 67800
BUDGET
BUDGET
FORECAST
FAV/(UNFAV)
_-__-__
PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
__-_-__
OPERATING REVENUE
RETIREES MEDICAL -VEBA DEBT
29,774,648
29,774,648
31,328,448
1,553,80000
522%- Fav due to protected revenues more than budget protections
RETIREMENT ADMINISTRATION
4,046,218
4,046,218
4,343,518
297,30000
735%- Fav due to protected revenues more than budget protections
RETIREMENT ADMINISTRATION -PTNE
350,000
350,000
243,600
(106,40000)
-3040%- Unfav, due to protected revenues less than budget projections
DEFERRED COMPENSATION -MATCH
2,000,000
2,000,000
2,277,000
277,000 00
1385% - Fay. due to higher than expected employee participation in the Deferred Compensation -
Match program
DEFINED CONTRIBUTION PLAN
20,651 600
20,651,600
21,839,200
1,187,600 00
575% - Fav, due to protected revenues more than budget projections
DEFINED CONTRIBUTION PLAN -PTNE
221 000
221,000
180,800
(40,200 00)
-1819% - Unfav due to a lower number of PTNE's who participated in the Defined Contribution
Plan - PTNE program Offset by favorable Defined Contribution Plan - PTNE expense
EMPLOYEE IN-SERVICE TRAINING
1,574,692
1,574,692
1,689,892
115,200.00
732%- Fav, due to projected revenues more than budget projections
EMPLOYEE BENEFITS UNIT
1,194,947
1,194,947
1,292,247
97,300 00
814% - Fav, due to protected revenues more than budget projections
EMPLOYEE RECOGNITION
368,125
368,125
368,125
-
000%
FLEX BENEFIT PLAN
100,000
100,000
100,000
-
000%
WELLNESS UNIT
615,225
615,225
672,725
57,500 00
935% - Fai due to projected revenues more than budget projections
FRINGE BENEFITS
119,004
119,004
119004
-
000%
TUITION REIMBURSEMENT
460,000
460 000
492 200
32,200 00
7.00% - Fav_ due to protected revenues more than budget protections.
RETIREMENT HEALTH SAVINGS
4,250,000
4250,000
4,317,700
67,700 00
1 59% - Fay. due to an increase in newemployees participating in the Retirement Health
Savings program
GROUP LIFE INSURANCE
525,000
525,000
525,000
-
0 00%
SOCIAL SECURITY
18,900,000
18 900,000
19,640,600
740 600 00
3.92% - Fav due to protected revenue more than budget protections - an increase in new hires
Offset by unfavorable Social Security expense.
MEDICAL INSURANCE
38 615,000
38,615,000
38,046,200
(568,800.00)
-147% - Unfav due to protected revenues less than budget projections
PRESCRIPTION COVERAGE INSURANCE
10 912,000
10,912,000
10,731,000
(181,000 00)
-1.66% - Unfav due to projected revenues less than budget projections
DENTAL INSURANCE
2951,500
2,951,500
3,881,000
929 50000
3149% - Fav due to protected revenues more than budget projections
VISION INSURANCE
162,500
162,500
355,600
193 10000
118.83% - Fav due to protected revenues more than budget projections.
DISABILITY INSURANCE
3700,000
3,700,000
3,566,600
(133,400 00)
-361% - Unfav due to projected revenues less than budget projections
WORKERS COMPENSATION
3 143,205
3,143.205
2,914,605
(228,600 00)
-727% - Unfav due to projected revenues less than budget projections
UNEMPLOYMENT COMPENSATION
400,000
400,000
400,000
-
000%
INVESTMENT INCOME
800,000
800000
800,000
-
000%
EXT- DENTAL INSURANCE
13,500
13500
13,500
-
0.00%
EXT - FLEX BEN ARREARAGES
-
-
-
-
000%
EXT- FLEX BEN DENTAL INSURANCE
135000
135,000
135,000
-
000%
EXT- FLEX BEN LIFE INSURANCE
455 000
455,000
492,900
37,900 00
833% - Fav due to protected revenues more than budget projections.
EXT - FLEX BEN MEDICAL - EMPLOYEE
5,333 000
5,333,000
5,433,000
100,000.00
1 88% - Fav due to protected revenues more than budget projections.
EXT- FLEX BEN VISION INSURANCE
136,000
136,000
136,000
-
000%
EXT- MEDICAL INSURANCE
180,000
180,000
180,000
-
000%
EXT -OTHER REVENUE
10,000
10,000
10,000
-
000%
EXT -PRESCRIPTION DRUG REBATES
1,500,000
1,500,000
1,500,000
-
000%
EXT -TRAINING
10,000
10,000
10000
-
000%
EXT -VISION INSURANCE
1,500
1,500
1500
-
000%
EXT- WELLNESS REVENUE
10,000
10,000
10000
-
000%
TOTAL REVENUE
153,618,664
153,618,664
158046964
4428,30000
288%
69
70
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
FRINGE BENEFITS FUND
ADOPTED
AMENDED
FY 2020
VARIANCE
FRINGE BENEFITS FUND 67800 1
BUDGET
BUDGET
FORECAST
FAV/(UNFAV)
PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
OPERATING EXPENSE
RETIREES MEDICAL -VEBA DEBT INT/AGING
8,340,000
8,340,000
8,340,000
-
000%
RETIREMENT ADMINISTRATION
1,241,919
1,241,919
1,201,719
40,20000
3.24%
-Fay. Personnel due to vacant and underfilled positions within Retirement Unit
DEFERRED COMP -COUNTY PMTS (MATCH)
2,000,000
2,000,000
2,000,000
-
000%
DEFINED CONTRIBUTION PLAN
20651,600
20,651,600
19,300,000
1,35160000
654%
-Fay. due to use offorteRure funds to offset employercontnbutions and participation
less than budgeted
DEFINED CONTRIBUTION PLAN - PTNE
221,000
221,000
180,000
41 00000
1855%
- Fay. due to a lover number of projected PTNE's who participate in the Defined
Contribution - PTNE program Partially offset by unfavorable Defined Contribution Plan -
PTNE revenue
EMPLOYEE IN-SERVICE TRAINING
1,201,748
1,201,748
1,223,748
(2200000)
-183%-
Unfav due to higherthan anticipated Employee In Service Training costs
IN-SERVICE TRAINING - INFO TECH
325,000
325,000
325,000
-
000%
PROFESSIONAL SERVICES
57000
57,000
57,000
-
000%
BENEFITS ADMINISTRATION
236013
236,013
236,013
-
000%
EMPLOYEE BENEFITS UNIT
1,068 955
1,088 955
1 035,455
53,500 00
491%
- Fav Personnel due to vacant and underfilled positions within Employee Benefits Unit
FLEXIBLE BENEFIT PAYMENTS
100 000
100.000
100,000
-
000%
WELLNESS PROGRAM
617,071
617,071
617,071
-
000%
EMPLOYEE RECOGNITION
373,041
373,041
259,341
113,700 00
3048%
- Fav Personnel due to vacant position within Employee Recognition Unit
ACCOUNTING SERVICES
120,590
120,590
120,590
-
000%
TUITION REIMBURSEMENT
460,000
460,000
460,000
-
0.00%
RETIREMENT HEALTH SAVINGS
4,250,000
4,250,000
830,000
3,420,000 00
80.47%
- Fav due to the use of Retiree Health Saving forfeitures held by Prudential used to
offset current expenses
GROUP LIFE INSURANCE
980,000
980,000
1 027,700
(47,700 00)
-4.87%
- Unfav due to an increase in participants through The Hartford Insurance program
SICK AND ANNUAL LEAVE CASH -OUT
3,050,000
3,050,000
3050,000
-
0.00%
SOCIAL SECURITY
18,900,000
18,900,000
19,655,000
(755,000 00)
-3.99%
- Unfav due to projected Social Security expense more than budget projections -
increase in new hires Partially offset by favorable Social Security revenue
MEDICAL INSURANCE
44,090,000
44,090,000
44090,000
-
000%
PRESCRIPTION COVERAGE
12,412,000
12,412,000
12412,000
-
000%
DENTAL INSURANCE
3,211,900
3,211,900
3 002,200
209,700.00
6.53%
- Fay. due to projected dental insurance expense less than budget projections.
VISION INSURANCE
300,000
300,000
244,000
56,000.00
1867%
- Fav due to projected vision insurance expense less than budget projections.
DISABILITY INSURANCE
3,700,000
3,700,000
3,820,400
(120,400 00)
-325%
- Unfav due to projected Disability expense more than budget projections
WORKERS COMPENSATION
3,148,029
3,148,029
3,096,029
52,000 00
1.65%
- Fav Personnel due to vacant position wthm Risk Management
UNEMPLOYMENT COMPENSATION
400,000
400,000
300,000
100,00000
2500%-
Fav due to lower than anticipated unemployment insurance charges from the State of
Michigan
CHILD CARE FACILITY
268,649
268,649
268 649
-
0.00%
HEALTH INSURANCE PREMIUM TAX
-
-
20 200
(20,200 00)
- Unfav due to Michigan Health Insurance Premium Tax being enacted as of January 1,
2020
MICHIGAN IPAATAX
18,000
18,000
18000
-
000%
PATIENT CENTERED OUTCOME RESEARCH
20,000
20,000
20000
-
0.00%
I NDI RECT COSTS
240000
240,000
240,000
-
000%
TOTALEXPENSE
132,022515
132,022,515
127,550,115
4,472,40000
339%
NET REVENUE OVER/(UNDER) EXPENSES
21,596 149 00
21,596,149 00
30 496,849
6,900.700 00
TOTAL NET ASSETS - BEGINNING
90,885,782 14
TOTAL NET ASSETS - ENDING
121,382,631.14
'Please note that m the Adopted Budget (line -item book) tins
is budgeted as "Budgeted
Equity Adjustment"
In the expense
category
Note The Fringe Benefit Fund is responsible for the Retiree
Healthcare Debt The
principal and interest
payments are included
in the finge benefit
rate but the
principal portion is required to be accounted for through a liability
account versus an expense account The FY 2020 principal amount is $25,660,000.
70
OAKLAND COUNTY INTERNATIONAL
AIRPORT (56500)
OPERATING REVENUE
OPERATING EXPENSE
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
ENTERPRISE FUNDS
CENTRAL SERVICES
ADOPTED AMENDED FY 2020 VARIANCE
BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT
$4,972,10000 $5,033,53200 $4,466,03200 ($567,50000)
$6,827,57100 $6827,571.00 $7,363,87100 ($536,30000)
NET OPERATING INCOME (LOSS)
($1,855,47100)
($1,794,03900)
($2,897,83900)
($1,10380000)
NON-OPERATING REVENUE (EXPENSE) 30760000
307,60000
30760000
-
TOTAL INCOME BEFORE
CONTRIBUTIONS AND TRANSFERS
($1,547,87100)
($1,486,43900)
$ (2,590,23900)
($1,103,80000)
TRANSFERSIN
-
-
-
-
CAPITAL CONTRIBUTION
-
-
-
-
TOTAL NET INCOME (LOSS)
($7,547,87100)
($1,486,439.00)
$ (2,590 239 00)
($1,103,80000)
TOTAL NET ASSETS - BEGINNING
$ 75,638 229 00
TOTAL NET ASSETS - ENDING
$ 73,047 990 00
Please note that in the Adopted Budget (line -item book) this is budgeted as 'Planned Use of Balance" in the revenue category
EXPLANATION OF SIGNIFICANT VARIANCES
-1127% - Unfav Aviation Gas ($380 000), US Customs Reimbursement ($140,000),
Car Rental Concessions ($42,000) due to less than anticipated activity as a
result of the COVID-19 pandemic
-785% - Unfav Depreciation Land Improvement ($544,800) due to closing capital
projects at the end of Fiscal Year 2019, Building Maintenance costs
($16 000) due to unexpected repairs, Ad) Prior Yr Expense ($8,300) from
2019 invoices not paid Partially offset by fav Grounds Maintenance costs
of $30,000 due to less snow and ice maintenance, Gasoline Charges
$15,000 due to lower gas costs
6153%
0.00
000%
5/25/2020
71
IMOTOR POOL FUND 66100
OPERATING REVENUE
Outside Revenue
Inside Revenue
Total Revenue
OPERATING EXPENSE
COUNTY OF OAKLAND
FY 2020 SECOND QUARTER REPORT
INTERNAL SERVICE FUNDS
CENTRAL -SERVICES
ADOPTED AMENDED BY 2020 VARIANCE
BUDGET BUDGET FORECAST FAVI(UNFAV) PERCENT
$ 145,000 00 $ 145,000 00 145,000 00 $ - 0.00 %
EXPLANATION OF SIGNIFICANT VARIANCES
9,114,12100 9238,65800 8,536,05800 (]02,60000) -761% - Unfav Leased Equipment ($310,600) due to actual aohmtytrends to date, Gasoline
Oil Grease Charges ($199,900) due to current fuel costs (offset by favorable
e% enditure for Gasoline Charges), Productive Labor ($132,500) and Parts and
Accessories ($59,600) due to department owned vehicles repaired by tried party
9,259,12100 9,383,65800 8,681,05800 (]02,60000)
9,241,910 00 9,328,750 00 8,986.550 00 342,200 00 3.67% - Fav Gasoline Charges $309,000 due to market fluctuations and miles driven
tpartially offset by unfavorable Gasoline Oil Grease revenue), Parts and Accessories
$82,000 due to newer vehicles having fewer repairs, Personnel $31,300 due to two
underfilled positions one full-time eligible position off on disability and hospitalization
costs less than anticipated, Sublet Repairs $18,000 due to lowerIndividual repair
costs for vehicles sent out for repair (partially offset by E# -Warranty
Reimbursements). Unfavorable Indirect Costs ($63,100) due to the development of
actual charges after budget finalization and Insurance 1$35,000) due to higher than
anticipated insurance costs
OPERATING INCOME (LOSS) 17211 00 54,90800 (305r492 00) (360400.00)
NON-OPERATING REVENUE
462,70000
462,]0000
482,70000
20,00000
432% - Fav Income from Investments $20,000 based on the actual investment income
(EXPENSE)
distributed to date but does not reflect market value adjustments which vsll occur at
the end of the 051 year.
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
479,91100
517,60800
1]],208.00
(340,40000)
TRANSFERS IN/(OUT)
232,43500
430,05700
430,05700
-
000%
CAPITAL CONTRIBUTIONS
NET REVENUE OVER/(UNDER)
EXPENSES (PLANNED USE OF
FUND BAL)-
$ 712,346 00
$ 94166_5_00_
_ $ 607,26500 $
(340,400 00)
TOTAL NET ASSETS - BEGINNING
$ 11 122 029 94
TOTAL NET ASSETS - ENDING
$ 11]29,29494
'Please note that in the Adopted Budget (line -item book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adl in Expenses
72
P�PTeo
eUOG+
GOUGO O QX) fO D OpT
2020 SE ESEµa -G 0ENT
P tNTE -s IA
Pp -\U VPRtPpF � PERS .^.
PT 2p20 T
p ev'DET
euG
�^ $ 65 pp0 DO
552 g39� 021°k
ad Outs do
'y eto rno<e [h?nusnty Heath Ne
r mar ior80,00,,d G°�n dmenueaoests.
Other ... euGnar9� on OePa
FAgenoesMaixden Pk ta5ed fromtrcdP*ee
tOGHN Mamte"ance OeP n9 natura & Sayyale G pp 0to
00
axe
Itts
UntaY. Gas g500 000 ds a toe o � OLssur,d R Pa," $350 't"Vo°
F i5 O pas d or duettd\d o° 9 °on ds,
�tma^t rt p p t°�° ion°at kt,r he
urce uod
$ ore 'enk W as 6 1 °� 5 ryC&O v conned due t°°de <,P tt
PanY0a�ny tse"Cee to, aoso,n s pv � , egUIP etre z`�me`anrazn
9,016 9 Ps°d� 1'C W.ls,Ot eAerd� o{ �mema$50.088 dyad m�u F`�ot �e
G�,e is as ed'es
t�nceayee oess MOt�ePne GO ood �cost oe,oftsenY adsv
yz$tcesihaa9 rct2 al Pt'`� Priori use 'es, steto
ed
�tAea naPat aue o � and 1oWe�p}peed °Uri Oce �c�creNso ten°'u u
°COV P-19 PE SuPPttes ^� � ane P sP sat °andemnaea5e �nWd�P`'a ¢ 8
eN`cXbn°� 5 0001 due toi of the GONQ 0) aue t docs o$54,e �0,J\O
SuPdeP me e Grounds Se90"'es Njas5lt o fey s a "S'A
Pn°a`nC1e landSCae fern°
Y�+Fm9
{eWsgs t° emP�oYees
s
n
m
.,nom d mac astment\ncoch W.\1
ua a\lnY "ds
__ TtON3
Oc5100)
$
q6i 33908 $
(10000001
11400
GE $OPERA
$
N
_33900
ho
19400
2628A 500008 620%
$$18t00p000
os
FPG�ytTE R
TA 00
2E 35A
113 00
$26 g3i,1t3000
�83.tit
OP OFPS pe Revenuz
26 g5A
211300
$25 822
1931st O0
$2i
25821 $29,
$ 28071 432 DO
\nsdeR ore RSYenue $
OFERPT\NGSENSE`'
sad onthe a swa adNstm
"to ba
ed
Pav\nc°meorda etJ e��aflmad�et
00 ked dMantenan
$18 t50p8°t° d�smtuend of th
work Order Fund for cios
1 $ 15460580 a� $ t5�p00 oo�r artha o1
�1 5t23� $ 15000 Transfers NltOm Pr
\ 9 394 00 p8o p8 0 00°0 9,00e s
6EFORE $ 09 $ 619200 pow
�NGOMEZR SSSIXP-s $ 1p0 6V1200 $ - e
OP �T\NG NUE $ 001
NON'pPERPS 1NG R _ $ t001 / $ t g8t 19200
299
$ 29y pot
$ t $ 2 t 357,00 $ 0301
325 cata9°rY
TR SPERS \N v $i005i, nine revenue
0,3110 e
TKPNF �NUSS OVERtUNOERNN\NG ys,.P�anned Ute°\Fund Set
an°
NET`Cy`PE N� Po �tpON g p\N em
ono 0,11515 tud9eWd
.pteasano< iPt-tea pdoPteo eudg\\,n
°te.�
13
TOTAL OPERATING REVENUE
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE
TRANSFERSIN
TRANSFERS(OUT)
CAPITAL CONTRIBUTION
$ 33,487,395 00 3 33 637,495 00 $ 33,410,995 00 3 (226,500 00)
$ 43,080,214 00 $ 43 245,347 00 $ 42,361,647 00 $ 883,700 00
EXPLANATION OF SIGNIFICANT VARIANCES
Unfav Enhanced Fees ($150,000) forwaiver of fees forthree months and Deferred Land
File Tax ($9,100) due to less than anticipated use Offset by fav Outside Agencies
$27,700, Managed Pnnt Services $13 200 and Reimb Equalization Services $1,600 due
to increase in external customer requests. Also, fav Sale of Equipment $14,700 due to
the sale of assets at the county auction
Unfav OC Depts Development Support & Non Governmental Development ($629,100)
due to limited resources to complete development due to vacancies, partiality offset by
Fav OC Depts Operations & Non Governmental Operations $543,600 due to increased
rates. Also unfav, Equipment Rental ($39,100) due to decreased rebills to departments
for maintenance charges on IT Office Equipment items
-067%
2 04% - Fav Depreciation $1,079,400 for IT capital projects in progress not fully operational;
Salaries & Fringes $1,058,100 due to vacant positionsTravel $65 900 due to travel
restrictions as a result of the COVID-19 pandemic, Equipment Maintenance $64,200
tlue to higher than anticipated hardware maintenance, Printing $61 000, Supplies
$23,400, Membership Dues $6,500, Mileage $5,100 due to usage Partially offset by
unfav Professional Services ($1,088,900) due to projects previously approved in prior
year Software Maintenance ($121,300) and Parts and Accessories (S60 000) due to
higher than anticipated costs, Contracted Services ($179,900) and Communications
($3,800) due to decreased activity, Indirect Cost ($17,600) due to actual charges being
developed after budget finalization, Internal Services overall unfav ($8,700) pnman ly
due to Insurance Fund ($35,700), Telephone Communications $21,900, Motorpool
$2 400 and Motorpool Charges $1,900, Maintenance Dept Charges $800 based on
usaqe
$ (9,592,819
00)
$
COUNTY OF OAKLAND
$
(8 950,652 00)
$
FY 2020 SECOND QUARTER REPORT
00
-684%
$ 70,500
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
$
70,500 00
$
INFORMATION TECHNOLOGY
$
ADOPTED
AMENDED
FY 2020 VARIANCE
$ 3 906,676
BUDGET
BUDGET
FORECAST FAV/UNFAV) PERCENT
Information Technology - Operations (63600)
4,066,785.00
$
OPERATING REVENUES
00
083%
$ -
Outside
$ 3,347,24100
$ 3,347,24100
$ 3,245,34100 $ (101,90000) -304% -
Inside
30,140,15400
30,290,25400
$ 30,165,65400 $ (124,60000) -041% -
TOTAL OPERATING REVENUE
OPERATING EXPENSES
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE
TRANSFERSIN
TRANSFERS(OUT)
CAPITAL CONTRIBUTION
$ 33,487,395 00 3 33 637,495 00 $ 33,410,995 00 3 (226,500 00)
$ 43,080,214 00 $ 43 245,347 00 $ 42,361,647 00 $ 883,700 00
EXPLANATION OF SIGNIFICANT VARIANCES
Unfav Enhanced Fees ($150,000) forwaiver of fees forthree months and Deferred Land
File Tax ($9,100) due to less than anticipated use Offset by fav Outside Agencies
$27,700, Managed Pnnt Services $13 200 and Reimb Equalization Services $1,600 due
to increase in external customer requests. Also, fav Sale of Equipment $14,700 due to
the sale of assets at the county auction
Unfav OC Depts Development Support & Non Governmental Development ($629,100)
due to limited resources to complete development due to vacancies, partiality offset by
Fav OC Depts Operations & Non Governmental Operations $543,600 due to increased
rates. Also unfav, Equipment Rental ($39,100) due to decreased rebills to departments
for maintenance charges on IT Office Equipment items
-067%
2 04% - Fav Depreciation $1,079,400 for IT capital projects in progress not fully operational;
Salaries & Fringes $1,058,100 due to vacant positionsTravel $65 900 due to travel
restrictions as a result of the COVID-19 pandemic, Equipment Maintenance $64,200
tlue to higher than anticipated hardware maintenance, Printing $61 000, Supplies
$23,400, Membership Dues $6,500, Mileage $5,100 due to usage Partially offset by
unfav Professional Services ($1,088,900) due to projects previously approved in prior
year Software Maintenance ($121,300) and Parts and Accessories (S60 000) due to
higher than anticipated costs, Contracted Services ($179,900) and Communications
($3,800) due to decreased activity, Indirect Cost ($17,600) due to actual charges being
developed after budget finalization, Internal Services overall unfav ($8,700) pnman ly
due to Insurance Fund ($35,700), Telephone Communications $21,900, Motorpool
$2 400 and Motorpool Charges $1,900, Maintenance Dept Charges $800 based on
usaqe
$ (9,592,819
00)
$
(9,607,852 00)
$
(8 950,652 00)
$
657 200
00
-684%
$ 70,500
00
$
70,500 00
$
(12,200 00)
$
(82.700
00)
-11730%
$ 3 906,676
00
$
4,033,405 00
$
4,066,785.00
$
33,380
00
083%
$ -
$
-
$
-
$
-
000%
$ -
$
-
$
8,580,263 00
$
8,580,263
00
0.00
Unfav Interest Income ($82 700) due to less than anticipated level of cash available for
investments
Fay. Contributed Capital due to non-cash revenue recognized for Major Departmental
Support for capital projects which include Cyber Security, Universal Communication and
Collaboration Program Project and Department of Management and Budget/Human
Resources/County Executive -Compliance Office Financial and Human Capital
Management Replacement Project
NET REV OVER(UNDER) EXP- $ (5,615,64300) $ (5,503,94700) $ 3,684,196 00 $ 9,188,14300
TOTAL NET POSITION - BEGINNING $ 16,953,22883
TOTAL NET POSITION - ENDING $ 20,637 424 83
`Please note that in the Adopted Budget (line -item book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses
74
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS $ (226 438 00) $ (226,438.00) $ (12,138 00) $ 214,300 00
NON-OPERATING REVENUE S 30 000 00 $ 30,000.00 $ 25,899 00 $ (4,101 00) -1367% Unfav primarily related to Interest Income due to less than anticipated level of cash
available for investments
TRANSFERSIN
$ - $
- $
-
COUNTY OF OAKLAND
000%
CAPITAL CONTRIBUTION
$ - $
- $
-
FY 2020 SECOND QUARTER REPORT
000%
TRANSFERS(OUT)
$ - $
- $
-
INTERNAL SERVICE FUNDS/ ENTERPRISE FUND
000%
NET REV OVER(UNDER) EXP"
$ (196,438.00) $
(19Q438 00) $
13,761 00
INFORMATION TECHNOLOGY
TOTAL NET POSITION - BEGINNING
ADOPTED
AMENDED
2,469,678.27
FY 2020 VARIANCE
TOTAL NET POSITION - ENDING
BUDGET
BUDGET
2,483,43927
FORECAST FAV/IUNFAVI PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Information Technology -Telephone
Communications
(67500)
and Budgeted Equity Act in Expenses
OPERATING REVENUES
Outside
$ 12 000 00
$ 12,000 00
$
8,200 00 $ (3,800 00) -3167%
Unfay. Sale of Phone External due to decreased usage of land lines
Inside
2,852,512 00
2,852,512 00
S
3,050,71200 $ 198,200 00 6.95%
Fav Sale of Phone Internal due to increased cell phone usage
TOTAL OPERATING REVENUE
$ 2,864,512.00
$ 2,864,51200
$
3,058,91200 S 194,40000 679%
OPERATING EXPENSES
$ 3 090,950 00
$ 3,090,950 00
$
3,071,050 00 S 19,900 00 064%
Fav Depreciation $100 000 based on depreciation schedule; Indirect Cost $93 700 due
to actual charges being developed after budget finalization, Internal Services $41,300
primarily due to Info Tech Operations $38,900 and Mileage $5,000 based on actual
usage Software Support Maintenance $16,400 due to decrease in maintenance costs
Tower Charges $14,000 due to decreased pager usage Partially offset by unfav
Communications ($202,000) Maintenance Equipment ($29,200) and Professional
Services ($17,000) due to higher than anticipated cost Equipment Repairs and
Maintenance ($2,300) due to maintenance costs being higher than the budget
projection
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS $ (226 438 00) $ (226,438.00) $ (12,138 00) $ 214,300 00
NON-OPERATING REVENUE S 30 000 00 $ 30,000.00 $ 25,899 00 $ (4,101 00) -1367% Unfav primarily related to Interest Income due to less than anticipated level of cash
available for investments
TRANSFERSIN
$ - $
- $
-
$ -
000%
CAPITAL CONTRIBUTION
$ - $
- $
-
$ -
000%
TRANSFERS(OUT)
$ - $
- $
-
$ -
000%
NET REV OVER(UNDER) EXP"
$ (196,438.00) $
(19Q438 00) $
13,761 00
$ 210,199 00
TOTAL NET POSITION - BEGINNING
$
2,469,678.27
TOTAL NET POSITION - ENDING
$
2,483,43927
"Please nate that in the Adopted Budget
(Ime-item book) this is budgeted
as "Planned use of Fund Balance' in the revenue category
and Budgeted Equity Act in Expenses
75
ADOPTED
BUDGET
Information if"hnolmv-CLEMIS (53500)
ENUES
AMENDED
BUDGET
OPERATING REV 00 $ A,667 113 00 $
$ 4,667,113
Outside
Inside
TOTAL OPERATING REVENUE
OPERATING EXPENSES
NET INCOME(LOSS) BEFORE
OPERATING TRANSFERS
NON-OPERATING REVENUE
TRANSFERS IN
TRANSFERS(OUT)
CAPITAL CONTRIBUTION
COUNTv OF OAKLAND
FV "I''ECOND QUARTER REPORT
INTERNA INSER
FVICE ORMATION TDECHNOLOGYS 1 �SE FUND
FY 2020 VARIANCE PEROENT
FORECAST FAVI NFAV
. 6
5,070,41300 $ 401300 00
1,522,45100 $ 1,09485100 $ (431,60000) -2835%
q 604,673 00
$ 6171.766.00 $ ,56400 $ 6,161,264 00 $ (26,30000) -046%
6,1891433%
$10,384,32400 $ 10,697,73100 $ 9164,231.00 $ 1,533,50000
$ (4 212 538 00) 5 (4,508,167 00) $
$ 35600 00 $ 35 000 00 1
$ 1 644 186 00 $ 1 783 676 00 $
3 362 00) $ (2 689 491-00) - $
EXPLANATION OF SIGNIFICANT VARIANCES
Fav CLEMIS Crash $100,700, CLEMIS Qtation $90.500 and Crime Map Feeping $1,500
Oakland and non -Oakland agencies Access Fees Non
Updated law enforcement Full Time Equivalent count used for
due to Increased usage by Access Fees
Oakland $113,800 due to up
billing, In-CarTerminals tEXternap $92Con.100 for fleet of CLEMIS agence500 due to ,, than
Oakland $7,500
and et Maintenance
unfav CLEMIS Parkracts 69 (($9 300) due to decreased actively
activlry
00 based on actual billing for Computer Reemb General
Unfav d Dispatch
Service Fees ($531' ) support ng Sheriff pro(ects, In -Car Temrmal
(CAD) axpense charged dvectly to Radio Fund Partially offset b o ecbon and Ta Dents
$41,300 based on actual;art GPal on countfhigherthan budget I 1
Internal $35,000 due to p
Operations $23,800 based on anncipatetl CLEMIS staff resources supporting She
projects
00 due to vacancies and turnover, irdemat
Fay. Salaries 2, Fnnge Bene tltJe o8T D velopment due to us gee Reoar
M $142.,000
Services $333,300 A y of expenses Also, Softwa
Maintenance $305,200 due tob TrOnng ions 700 due to less than anticipated
Bank Charges $150 000 and GO' I o dap,, $108,
aohvity. Depreciation $74,200 based on depreciation schedule; Travel $16,300 due to
Milea a $1,500 and Panting $1 500 due to usage,
usage and travel restrictions related to the GOVID-19 pandemic Pads and Accessories
$14,900 based on actual usage, 9
lndrtect Cost $9,500
due to actual charges deter mmetl atterbutlI ji o set tion an
Expert Cos Equipment $7 000 for egmpment replacement PaRially offset by unAS for
tay.
257,800) duo ra
to higher tnbased on actuainti at�connectvity costs to
Professional Services ($
staffing se+vices, Rep and
Services ($130 900)
Tier 2 5 and 3 0 agencies, Charge Card Fee ($100000) due to less than anticipated
i eat Maintenance
costs for PWal services for E -Comma ce�rm
and Tran ng ($4 000) due to usage
($20.100) tlus to reductIon of wst of rep
to
(3,002.967.00) S 1,505.20000
116 899 00 $ a1,899 00 234 00 % Fay. Income from trrvesiments based on the actual investment c c r at the
o he
date but does not reFlect market value adjustments which well occur at the end of the
fiscalyear
1 783 676 00 $
$ 0 001
$ 0W%
(1102,39200)_ $$ 158
709900
$ (2 53
NET REV OVERNNOER) EXP' -- $ 13656,48396
$_ 12554 equity Ad in Expenses
TOTAL NET POSITION - BEGINNING _ _
TOTAL NET POSITION - ENDING
Please nate that m the Adopted Budget (brie -item 000k)ths is budgeted as "Planned use of Fund Balance' in the revenue category
and Budgeted q Y
76
TOTAL OPERATING REVENUE $ 9,747,42800 $ 9,747,42800 $ 9,737,928.00 $ (9,50000)
OPERATING EXPENSES $ 9,725,21400 $ 9725,21400 $ 8,706,31400 $ 1,018,90000
NET INCOME (LOSS) BEFORE
(286,000 00) $
(286 000 00)
COUNTY OF OAKLAND
CAPITAL CONTRIBUTION $ - $
- $
-
FY 2020 SECOND QUARTER REPORT
$
22,21400 S
22,21400
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
1,031,61400
$ 1 009 400 00
NON-OPERATING REVENUE
INFORMATION TECHNOLOGY
250,00000 $
ADOPTED
AMENDED
FY 2020 VARIANCE
$ 52,70000
BUDGET
BUDGET
FORECAST FAV/(UNFAV) PERCENT
Information Technology - Radio Communications (53600)
S
4000000
OPERATING REVENUES
Outside
$ 9 255 600 00 $
9,255,600 00
$ 9,293,000 00 $ 37,400 00 0A0%
Inside
491,828
491,828
$ 444,92800 $ (46,90000) -9.54%
TOTAL OPERATING REVENUE $ 9,747,42800 $ 9,747,42800 $ 9,737,928.00 $ (9,50000)
OPERATING EXPENSES $ 9,725,21400 $ 9725,21400 $ 8,706,31400 $ 1,018,90000
NET INCOME (LOSS) BEFORE
(286,000 00) $
(286 000 00)
$ - 000%
CAPITAL CONTRIBUTION $ - $
- $
-
OPERATING TRANSFERS
$
22,21400 S
22,21400
$
1,031,61400
$ 1 009 400 00
NON-OPERATING REVENUE
$
250,00000 $
250,00000
$
302,70000
$ 52,70000
TRANSFERSIN
$
3,50000 $
40,00000
S
4000000
$ -
-010%
EXPLANATION OF SIGNIFICANT VARIANCES
Fav Antennna Site Management $247,900 due to updates in rental contracts, Outside
Agencies Revenue $15,400 due to higher non -emergency agencies than anticipated
Partially offset by unfav_ E911 Surcharge ($225,900) due to decreased volume of
users/receipt of 911 surcharge
Unfay. pnmanly due to Leased Equipment ($43,000) due to lowerthan anticipated non-
public users and Producive Labor ($4,000) due to Mobile Data Computer repairs for
Oakland County Agencies.
1048% Fav Software Support Maintenance $760,100 due to timing of Emergency Services IF
Network Project, Internal Services $547,600 primarily due to Info Tech CLEMIS based
on usage, Balance and Fringe benefits $30,100 due to less than anticipated overtime,
Software Rental $30,000 due to less than anticipated activity, Freight and Express
$6,000 due to usage Partially offset by unfav Depreciation ($60,100) based on
depreciation schedule; Indirect Cost ($25,700) charges determined after budget
finalization Training ($241,500), Supplies ($23,700) and Small Tools ($4,000) due to
usage
2108% Fav Income from Investments based on the actual investment income distributed to
date but does not reflect market value adjustments which will occur at the end of the
fiscal year
000%
TRANSFERS (OUT) $ (286,000.00) $
(286,000 00) $
(286 000 00)
$ - 000%
CAPITAL CONTRIBUTION $ - $
- $
-
$ - 000%
NET REV OVER(UNDER) EXP' $ (10,286.00) $
26,21400 S
1,08831400
$ 1,062,100.00
TOTAL NET POSITION - BEGINNING
S
37.424.221.35
TOTAL NET POSITION - ENDING
$
38,512,535 35
Please note that in the Adopted Budget (line -item book) this is budgeted
as "Planned use
of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses.
77
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
$ (770,500.00)
$
(770,50000)
$ (492,00000)
COUNTY OF OAKLAND
278,50000
$ 3,000.00
$
FY 2020 SECOND QUARTER REPORT
$ 4,200 00
$
1 200 00
4000%
Fay. Income from Investments based on the actual investment income distributed to
INTERNAL SERVICE FUNDS / ENTERPRISE FUND
INFORMATION TECHNOLOGY
NON-OPERATING REVENUE
ADOPTED
AMENDED
FY 2020 VARIANCE
fiscal year
BUDGET
S 507,699 00
BUDGET
507,699.00
FORECAST FAV/(UNFAVI PERCENT
EXPLANATION OF SIGNIFICANT VARIANCES
Fire Records Management f 53100)
1 73%
Fav due to budget less than anticipated need
TRANSFERS(OUT)
$ -
$
-
OPERATING REVENUES
$
-
000%
CAPITAL CONTRIBUTION
$ -
Outside
$ 252,52200
$
252,522.00
$
285,52200 $ 3300000 1307%
Fav primarily due to Participation Fees $41,900 for Oakland and Non -Oakland
NET REV OVER(UNDER) EXP-
S (259,801 00)
$
(259,801.00)
$ 28,700 00
$
Agencies
TOTAL OPERATING REVENUES
$ 252,52200
$
252,522.00
$
285,52200 $ 3300000 1307%
$ 1,631,07722
OPERATING EXPENSES
$ 1,023,02200
$
1023,02200
$
777,52200 $ 245,50000 2400%
Fay. Indirect Cost $85,500 due to a roll forward credit; Depreciation $59,200 based on
$ 1,659,77722
depreciation schedule, Software Maintenance $44,900 due to reduction in maintenance
costs, Communications $29,000 due to decrease in connectivity rates; Salaries &
Fringes $10 200 due to less than anticipated on call and Travel $4,000 due travel
restnctions related to the COVID-19 pandemic Favorable Internal Services $3,800
primarily due to IT Development $4,000 for the Fire Records Management Software
Rewrite project
NET INCOME (LOSS) BEFORE
OPERATING TRANSFERS
$ (770,500.00)
$
(770,50000)
$ (492,00000)
$
278,50000
$ 3,000.00
$
3,00000
$ 4,200 00
$
1 200 00
4000%
Fay. Income from Investments based on the actual investment income distributed to
date but does not reflect market value adjustments which will occur atthe end of the
NON-OPERATING REVENUE
fiscal year
TRANSFERS IN
S 507,699 00
$
507,699.00
$ 516,500 00
$
8,801 00
1 73%
Fav due to budget less than anticipated need
TRANSFERS(OUT)
$ -
$
-
$ -
$
-
000%
CAPITAL CONTRIBUTION
$ -
$
-
$ -
$
-
000%
NET REV OVER(UNDER) EXP-
S (259,801 00)
$
(259,801.00)
$ 28,700 00
$
288,501 00
TOTAL NET POSITION - BEGINNING
$ 1,631,07722
TOTAL NET POSITION - ENDING
$ 1,659,77722
`Please note that in the Adopted Budget (line -item book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses
78
OI,KLAN D COEEN Y COMMUNrTY & HOME IMPROVEMENT DIVISION
79
REQUEST FOR AUTHORIZATION TO RECOGNIZE UNCOLLECTIBLE HOME IMPROVEMENT LOANS
-_— -
2cd QUAR-E., Be
2020
_
P'^5`_CLC5URE
REHAE
TVPETAF!
TCT,,L WPITE
GRANT
COWTRACT
LOAN
DATEDEEMEC
MORTGAGE,,
OFF
NAME
ADDRES'_ COMMUIR—, JP CODE CASENO. CDBG/HOME
DATE
AfOOUNT UNCOLLECTIRLE
OTHER
'vv RITE OF' AASGUN7
AMOUNT
Audrey =_. Rieger
1505 E Guthrie Ave ''� Madison He,ghts 48071 3308 CDBG
7/15/1988
$7,370.00
3/18/2020
Mortgage
$7,370.00
$7,370.00
Lawrence& Corinne Da.+ney
2720 Gehers Dr '',Highland 43356 5750 CODE
12/79/20001
$19,25755 i
7/29/2016
Omer'
$79,297.55 ��
$15,29.55
Richard & Deborah Rema
3930 Queensbury Si Lake Orion _ 48359 6408 1 CDBG
3/10/2005
$19,_85.84 !
10/2/2009
Other'
1 $19,285.84
519,285.84
Audrey ERieger
605EGJDrie Ave Madison Heights 45071 8'_87 HOME
4/19,'1994
_
$9,695.00
--
3/18/2020
Mortgage
_ -�
$9,695-001
59,695.00
- -�
I Mortgage Total I
$55,648.39
Joan 1 Boatman
145 W Garfield Ove Faze! Park _ 48030 8476 HOME
11/8/1995
$13,550.00
7/15/2019
Tax
$13,SS000
Ia.. lot
$13,550.00
Other Total
50-00
!
TOTAL
I UNCOLLECTIBLES
$69,198.39
"Chapter 13 Banla-uptcy completed
which supped our loan
-
PREPARED BY:
Shameka Davenport
_
�+, J�;IV ' v ��
,DATE: April 15,
2010
Loan Closing Officer
Z'4 vDb7C�..1"�'i_ ,p -a
APPROVED BY:
Karry Rteth
DATE: April 15,
2020
Manager�-
79
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - FY 2020 Second Quarter (January 2020- March 2020)
1/2/2020
Helga Frey
41961
$57.50
3282171
1/2/2020
Stephanie Kilburn
41964
$57.50
3282171
1/2/2020
Patti Chaplin
41971
$25.00
3282171
1/3/2020
Midwest Boston Terrier Rescue
41994
$10.00
3283251
1/4/2020
Provident Dentistry
42012
$35.00
3283231
1/7/2020
Jerrold Walton
42092
$250.00
3285191
1/7/2020
Mark Mudd
42095
$5.00
3285191
1/7/2020
Sleek Salon & Tanning
42098
$315.00
3285191
1/7/2020
Debra Kurpleskl
42123
$2.50
328519
1/7/2020
Tammy Moery
42102
$25.00
328521
1/8/2020
Ismini Ball
42137
$50.00
328597
1/8/2020
Christopher Paulos
42138
$4.00
3285971
1/8/2020
Marisa Zandi
42141
$17.00
328597
1/10/2020
Faisal Siddiqi
42191
$50.00
328751
1/10/2020
Philip Grundlehner
42198
$75.00
3287511
1/10/2020
Keith & Mary Conklin
42199
$20.00
3287511
1/10/2020
Libby Jones
42210
$10.00
3287541
1/11/2020
Donation Box
42230
$33.25
3287521
1/11/2020
Kim Berry
42245
$45.00
3287521
1/11/2020
Jacob Brzezlnskl
42249
$411.00
3287521
1/14/2020
Vet Select Commerce
42296
$7.50
3290061
1/14/2020
John Little
42300
$5.00
3290061
1/14/2020
Howard Witt
42317
$20.00
3290081
1/15/2020
Connie Salata
42331
$17.00
3291411
1/15/2020
Jennifer Jasgur
42362
$20.00
3291391
1/16/2020
Patricia Ehnis
42378
$10.00
3292491
1/16/2020
Bonnie Mattas
42380
$20.00
329249
1/16/2020
Harold & Becky Day
42381
$100.00
3292491
1/17/2020
Donation Box
42418
$97.50
3292721
1/17/2020
Lynn Hinton
42429
$208.00
3292701
1/18/2020
Polma Bemis
42449
$40.00
3293071
1/22/2020
Ellssa Staeuble
42505
$20.00
3294661
1/23/2020
Donation Box
42506
$121.00
3295371
1/23/2020
Donation Box
42527
$30.00
3295371
1/25/2020
Lynn Strong
42576
$2.50
3296111
1/25/2020
Suzanne Vermeulen
42605
$50.00
3296111
1/27/2020
Irene Brooks
42613
$100.00
3296911
1/27/2020
Lawrence Walsh
42614
$25.00
3296911
1/27/2020
Detroit Country Day School
42615
$40.00
3296911
1/27/2020
Gloria List
42641
$20.00
3296911
1/27/2020
Nicole Beauchamp
42634
$23.00
3296931
1/28/2020
Mark Mudd
42648
$5.00
3297681
1/28/2020
Frank McNabb
42649
$20.00
3297681
1/30/2020
Donation Box
42715
$54.50
3299211
1/31/2020
Stevens Middle School
42728
$25.00
3300051
1/31/2020
Richard Borucki
42753
$100.00
3300051
1/31/2020
Celia Domalewski
42755
$50.00
3300051
January 2020 Total
$2,128.751
80
OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER
Restricted Fund (Legacy) Donations - FY 2020 Second Quarter (January 2020 - March 2020)
2/3/2020 Katherine Northrop
42805
$0.75
3300861
2/6/2020 Donation Box
42897
$29.75
3303421
2/10/2020 Kaitlin Davis
42948
$9.50
3304811
2/10/2020 Tammy Dickinson
42992
$22.00
3304811
2/10/2020 Donation Box
42998
$130.00
3304831
2/11/2020 Kurt Blodgett
43010
$100.00
3305811
2/11/2020 John Post
43011
$50.00
3305811
2/11/2020 Joanne Gaines
43019
$50.00
3305811
2/12/2020 John Little
43047
$5.00
3306701
2/12/2020 Donation Box
43059
$36.50
3306701
2/12/2020 Geralding Schinzel
43062
$217.00
3306721
2/13/2020 Donation Box
43080
$35.32
3307631
2/13/2020 Cynthia Lawrence
43091
$77.00
3307631
2/14/2020 Kelly Nestell
43110
$100.00
3307821
2/18/2020 Courtney Liebich
43143
$17.00
3309431
2/19/2020 Denise Day
43167
$50.00
3310201
2/19/2020 Paul & Louise Borucki
43168
$25.00
3310201
2/20/2020 Bailey Lake Elementary
43204
$300.00
3310911
2/21/2020 Sheilia Weithman
43223
$100.00
3311641
2/22/2020 Donation Box
43260
$21.25
3311651
2/24/2020 Elissa Staeuble
43310
$20.00
3312391
2/27/2020 Sandy Liman
43389
$0.36
3314821
2/28/2020 Justin Latimer
43415
$2.00
3315701
2/29/2020 Donation Box
43443
$17.50
3315681
1
_
February 2020 Total
$1,415.93
3/2/2020 Mark Mudd
43477
$5.00
331653
3/2/2020 Cindy Woodhall
43495
$139.50
3316531
3/3/2020 Jessie Buttry
43525
$9.00
3317481
3/3/2020 Nikki Keller
43535
$40.00
3317501
3/5/2020 Bocovina Countryside Condo Assoc
43582
$100.00
3319191
3/5/2020 Aaron Allen
43584
$0.50
3319211
3/9/2020 Nicole Heyboer
43669
$20.00
332060
3/10/2020 John Little
43709
$5.00
332142
3/11/2020 David Braden
43730
$0.25
332205
3/11/2020 GM Lake Orion Assembly Plant
43735
$1,750.00
332203
3/13/2020 Donation Box
43771
$44.00
332347
3/14/2020 Donation Box
43829
$61.75
332345
3/20/2020 Donation Box
43959
$2.75
3327391
3/20/2020 James Bell
43968
$50.00
3327361
3/20/2020 Dena Dennis
43972
$100.00
3327361
3/20/2020 Ewa & Andrzej Osika
43978
$50.00
3327361
3/23/2020 Victoria Mayer
44044
$30.00
3330051
3/25/2020 Elissa Staeuble
44047
$20.00
3330051
3/25/2020 Donation Box
44050
$1.25
3330051
March 2020 Total $2,429.001
Q2 FY2020 Total $6,573.681
81
Date: Donor:
Department of Health and Human Services
Oakland County Children's Village
Donation Tracking : Donation Period January 2020 to March 2020
Cash/Check: Items:
Check
Frozen Birthday Cakes (3) Months
Slippers, Clothes, Gloves
Suitcases
Pillow Cases
Blankets
Pillow Cases
Repair of Gaming Systems
Toiletries, Socks, Activity Books
Bags
Magazines
Magazines & Cakes
Yarn & Supplies
Books, Toys, Art Supplies, Toiletries
Stuffed Animals
Cookies
Clothing
Pillow Cases
2 Bags Yarn
Clothing
Pillow Cases, Hampers, Socks & Sweatshirts
Clothing
Yarn
Diapers
Toiletries, Games, Craft Supplies, Puzzles
Clothing
Cakes
Pillow Cases
Pillow Cases
Total:
Estimated Value:
$495.00
$100.00
$35.00
$1,750.00
$100.00
$400.00
$225.00
$50.00
$200.00
$15.00
$6.00
$6.00
$45.00
$50.00
$100.00
$15.00
$100.00
$225.00
$30.00
$100.00
$300.00
$15.00
$65.00
$10.00
$650.00
$100.00
$4.00
$225.00
$230.00
$5,646.00
82
University Presbyterian Church
1/6/2020
Waterford Fitness
1/10/2020
Claudia Goldenthal
1/10/2020
John Meldrum
1/13/2020
St. Perpetua Catholic Church
1/14/2020
Amerisure
1/15/2020
Sweet Dreams for Kids
1/17/2020
Toy Box
1/22/2020
Adat Shalom Synagogue
1/23/2020
Terry McKay
1/24/2020
Datsun Doctor
1/25/2020
L. Simon
1/30/2020
Clarkston Sr. Center
2/3/2020
Rachelle Cristoford
2/5/2020
Rainbow Connection
2/10/2020
L. Simon
2/11/2020
Marcia Rathgeb
2/14/2020
Sweet Dreams for Kids
2/14/2020
Central Methodist Church
2/14/2020
James & Ruma Honer
2/18/2020
St. Perpetua Catholic Church
2/20/2020
Alice Ward
2/20/2020
Judith Johnson
2/24/2020
Cathy Dusegan
2/28/2020
Wass Elementary
3/5/2020
Kathy Tosoiam
3/6/2020
L. Simon
3/10/2020
Sweet Dreams for Kids
3/11/2020
St. Perpetua Catholic Church
Check
Frozen Birthday Cakes (3) Months
Slippers, Clothes, Gloves
Suitcases
Pillow Cases
Blankets
Pillow Cases
Repair of Gaming Systems
Toiletries, Socks, Activity Books
Bags
Magazines
Magazines & Cakes
Yarn & Supplies
Books, Toys, Art Supplies, Toiletries
Stuffed Animals
Cookies
Clothing
Pillow Cases
2 Bags Yarn
Clothing
Pillow Cases, Hampers, Socks & Sweatshirts
Clothing
Yarn
Diapers
Toiletries, Games, Craft Supplies, Puzzles
Clothing
Cakes
Pillow Cases
Pillow Cases
Total:
Estimated Value:
$495.00
$100.00
$35.00
$1,750.00
$100.00
$400.00
$225.00
$50.00
$200.00
$15.00
$6.00
$6.00
$45.00
$50.00
$100.00
$15.00
$100.00
$225.00
$30.00
$100.00
$300.00
$15.00
$65.00
$10.00
$650.00
$100.00
$4.00
$225.00
$230.00
$5,646.00
82
A,jEo Puff ISMER
D-, E I,,U FEF.
)AKLAND GUUNT�! �'R DAS U R E R,
W I ut-fFc)@,'Nj kl-,- LIKt'[ -179
h4l -ld::M 1 -0471a
Jl--D', WLISSLER DEFOE
�FIIEFDEFIM
V
Y/
I I I
Jlc
P- 2,1 -1 -> 'i f 4-
zz,
OFFICE £,I5E3 CIL, I
ISSIoN
g� RECREATION Co 1 2 �IVarcb 31, 2020
CpUNTY PARS` 2020 " i N . .
ponations) - JanuarY
_ _ pAKLANp 51.00
Ott for Contributions l $1s.e9 $,,19.69
2020 2Q Rep
FV .
Ices Total -
TuninKYour'foi -
eation Programs and Sed...
pon - - Mparks Virtual SKCr - — - $19
,F" • _Nature Center - - - . _ _ , Total - .6
Contnbu - operatingf - - - -- - Grand - -
[tEC - - --- Contributions_ - - - - -
m
Resolution #20185 June 4, 2020
Moved by Zack seconded by Long the resolution be adopted.
Moved by Gershenson seconded by Markham the resolution be amended as follows:
Insert the following WHEREAS language:
WHEREAS a FY 2020 budget amendment is recommended to reallocate $500,000 from the
Coronavirus Aid, Relief, and Economic Security (CARES) Act, Non -Departmental Federal
Operating Grants revenue line item (Account 610313) to Board of Commissioners Public
Information expenditure line item budget (Account 731500); and
Amend Schedule A page 7 as follows:
BOARD OF COMMISSIONERS
Revenues
9010101-133095-610313
Expenditures
5010101-133095-731500
Discussion followed.
FY 2020
AMENDMENTS
Federal Operating Grants $500.000
Total Revenues $50 0
Public Information $500.000
Total Expenditures $5DQ QO
Vote on amendment:
AYES: Kowall, Long, Luebs, Markham McGillivray, Middleton, Miller, Nelson, Powell, Quarles,
Spisz, Taub, Weipert, Woodward, Zack, Gershenson, Hoffman, Jackson, Kochenderfer. (19)
NAYS: Kuhn. (1)
A sufficient majority having voted in favor, the amendment carried.
Discussion followed.
Vote on resolution, as amended:
AYES: Long, Luebs, Markham, McGillivray, Middleton, Miller, Nelson, Powell, Quarles, Spisz,
Taub, Weipert, Woodward, Zack, Gershenson, Hoffman, Jackson, Kochenderfer, Kowall. (19)
NAYS: Kuhn. (1)
A sufficient majority having voted in favor, the resolution, as amended;w�sar
gel An
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 4, 2020,
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 411 day of June, 2020.
Lisa Brown, Oakland County