HomeMy WebLinkAboutResolutions - 2018.09.27 - 23894MISCELLANEOUS RESOLUTION #18322 September 27, 2018
BY: Commissioner Thomas Middleton, Chairperson, Finance Committee
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2018 THIRD
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) 2018 Third Quarter Financial Forecast Report has identified several
variances and budget amendments are recommended; and
WHEREAS a budget amendment is recommended to return $1,745 from the Sheriff's Office General Fund
to the Sheriff's Law Enforcement Restricted Fund (#21341) due to unspent funds in equipment from FY
2017 carry-forward funds; and
WHEREAS the Sheriff's Office receipt of forfeiture/enhancement funds are recorded in separate restricted
funds that require a transfer to the General Fund for use of the monies. Transfers-In from the various
restricted funds in the amount of $93,252 is being recognized for eligible personnel, forensic lab and
training costs for corrections officers and dispatchers; and
WHEREAS a budget amendment of $11,560 is recommended for the Human Resources Department to
reallocate funds from the Recruitment Expense line item to the Information Technology Operations line
item for the upgrade of electronics in the Beverly Hills Conference Room; and
WHEREAS a budget amendment of $7,300 is recommended for Homeland Security to accept grant
funding from the Michigan State Police, Emergency Management and Homeland Security Division
(MSP/EMHSD) Hazardous Materials Emergency Preparedness (HEMP) Planning Program Grant in the
amount of $3,500. Miscellaneous Resolution (M.R.) #17194 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 budget amendment of $3,315 is recommended for Animal Control to correct the Department
ID and program number for the Planned Use of Balance that was referenced in M.R. #18236 Fiscal Year
2018 Second Quarter Financial Forecast and Budget Amendments; and
WHEREAS a budget amendment is recommended for the Animal Control Division to accept additional
reimbursement funding of $583 from the Bissell Pet Foundation's Empty the Shelter event. The division
recognized $3,315 in M.R. #18236 Fiscal Year 2018 Second Quarter Financial Forecast and Budget
Amendments. Total reimbursement funding of $3,898 was received from the Bissell Pet Foundation's
Empty the Shelter program; and
WHEREAS a budget amendment in the amount of $20,000 is recommended for Economic Development &
Community Affairs to reflect operating revenues and expenditures related to Partner Convening Activities
and Site Selector Engagement; and
WHEREAS a budget amendment in the amount of $50,000 is recommended for Economic Development &
Community Affairs to reflect operating revenues and expenditures related to MiCareerQuest Southeast;
and
WHEREAS a budget amendment totaling $20,240 is recommended for Economic Development &
Community Affairs to more accurately account for actual activity for the various revenue line items; and
WHEREAS a budget amendment of $256 is recommended within the Children's Village Division to transfer
funding from the Children's Village Donations Fund (#21330) to the Child Care Fund (#20293) which
properly accounts for expenditures eligible for Children's Village Donation funding; and
WHEREAS a budget amendment is recommended to transfer $11,676 from Non-Department General
Fund/General Purpose (#10100) to the Fire Records Management Fund (#53100) to include the addition of
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote with KowaII absent.
Madison Heights and Southfield Fire Departments that wasn't anticipated with the FY 2018 — FY 2020
adopted budget; and
WHEREAS a budget amendment is recommended for the Circuit Court's Michigan Mental Health Drug
Court Grant (#27175) to reallocate $2,000 from the Transportation Service line item to the Private
Institutions Residential line item to reflect Amendment #3 which is within fifteen percent of the FY 2018
Michigan Mental Health Court Grant Program agreement (M.R. #17304); and
WHEREAS a budget amendment is recommended to reallocate funding in the amount of $1,759 from
Indirect Costs to Salaries under the Cooperative Reimbursement Program (CRP) Grant (#27100) which
more accurately reflects actual activity; and
WHEREAS a budget amendment is recommended for the Friend of the Court Fund (#27100) reallocating
$10,300 from the Office Supplies line item to the Smile Program line item to cover the remaining cost of
the new Friend of the Court (FOC) Smile Video; and
WHEREAS a grant acceptance increase in the amount of $5,000 is recommended for the Sheriff's Office
2018 Violent Offender Task Force (VOTE) Grant to reflect Amendment #1 which is less than fifteen
percent of the original agreement (MR. #18219); no budget amendment is required as the funding will be
used for reimbursement of overtime hours; and
WHEREAS a budget amendment is recommended for the Sheriff's Office FY 2018 Automobile Theft
Prevention Authority (ATPA) Grant (#27310) to reflect Amendment #3 accepting additional funding in the
amount of $5,744 for the purchase of video cameras and document scanners. The amendment is within
fifteen percent of the original agreement (M.R. 17316); and
WHEREAS a budget amendment of $220 is recommended for the Sheriff's Office FY 2018 Automobile
Theft Prevention Authority (ATPA) Grant (#27310) to reflect Amendment #4 in additional funding which is
within fifteen percent of the original agreement (M.R. #17316); and
WHEREAS a budget amendment is recommended for the Sheriff's Office 2018 Michigan Medical
Marihuana Operation and Oversight Grant (#27323) to reallocate $84,000 from the Overtime line item to
the Program line item to reflect Amendment #1 which is within fifteen percent of the original agreement
(M.R. #18098); and
WHEREAS a budget amendment totaling $21,191 is recommended for the Health Division's Suicide
Prevention Grant (#28615) to reallocate funds between expenditure line items to reflect Amendment #5
which is within fifteen percent of the original agreement (M.R. #17330); and
WHEREAS a budget amendment of $125,668 is recommended for the Health Division to recognize
adjustments to the FY 2018 Comprehensive Planning, Budgeting, and Contracting (CPBC) Agreement to
reflect Amendment #4 which is less than fifteen percent of the original agreement (M.R. #17237) and;
WHEREAS a budget amendment is recommended for Economic Development & Community
Affairs/Community Home Improvement division's PY 2017/2018 Michigan State Housing Development
Authority (MSHDA) Housing Education Grant (#29722) to reflect Amendment #2 accepting additional
funding in the amount of $3,859; bringing the total grant award to $33,359. The amendment is within
fifteen percent of the original agreement (KR, 17200); and
WHEREAS a budget amendment of $1,733 for FY 2018, $15,317 for FY 2019 and $16,851 for FY 2020 is
recommended for Economic and Community Affairs/Workforce Development to account for the additional
funding needed to offset the upward reclassification of the Workforce Development Technician II Position
(1090701-07813) to Workforce Development Technician III Position; and
WHEREAS grant acceptance is recommended for Parks and Recreation Commission to accept a scholar
ship valued at $750 from the Spirit of Alexandria Foundation for Birds of Prey program at Groveland Oaks
Air Fair Event. A budget amendment is not required as the scholarship will cover the estimated costs of the
program. M.R. #17194 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 Parks and Recreation Commission budget amendment in the amount of $292,984 to transfer
General Program Administration funds from the Facilities Maintenance cost center to various cost centers
incurring expenses during the third quarter of FY 2018, to amend General Program Administration
operating budget $48,000 to fund approved capital improvement projects at Addison Oaks Conference
Center for a garden trellis, entry doors at Glen Oaks Conference Center, Adjust Prior Years Expense in the
amount of $24,170 for FY 2017 projects that were expensed in prior year that should have been
capitalized, Adjust Prior Years Revenue in the amount of $4,050 for an overpayment by Oak Management
and adjust Prior Years Adjustments $29,834 for CIP#1971 GLG Parking Lot Imp $14,917 and CIP#1962
GLC Parking Lot Imp $14,917 due to project closures and expensing of costs; and
WHEREAS a budget amendment is recommended to transfer funds totaling $12,574 from the various
benefiting water systems to the Water Resources Commissioner Evergreen Farmington Fund (#58410) for
the purchase of a security gate at the Eight Mile Road facility; and
WHEREAS a budget amendment totaling $125,000 is recommended for the Motor Pool Fund (#66100) to
reallocate funds to more accurately account for actual activity for the various expense line items; and
WHEREAS a budget amendment of $1,000,000 is recommended for the Information Technology Fund
(#63600) to reallocate funds for various IT Masterplan projects such as Medical Examiner's, E-health, IT
Print Management Services, Cyber Security and Collaborative Asset Management System (CAMS),
funding is available in the IT Fund Net Position Designated for Projects; 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 Grant totaling
$46,720.60 and the Home Investment Partnership Act Accounts totaling $73,198.00 and recommends
$119,918.60 be written off in uncollectible loans; and
WHEREAS the Human Resources Department has requested a write-off in the amount of $343.65 for
uncollectible healthcare contributions due to benefit contribution arrearages-post separation; and
WHEREAS the Department of Information Technology has requested write-offs totaling $254 for
uncollectible credit card transactions; and
WHEREAS Department of Health and Human Services, Children's Village division received donations for
the period of April 2018 through June 2018 totaling $11,220.69 of which $750 were cash donations; and
WHEREAS Department of Public Services, Animal Shelter and Pet Adoption Center received donations for
the period of April 2018 through June 2018 totaling $6,648.44 and
WHEREAS Oakland County International Airport (OCIA) received a donation in the amount of $400 for air
show at OCIA; and
WHEREAS Parks and Recreation Commission received donations for the period of April 2018 through
June 2018 totaling $120.
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2018
Third 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 Children's Village division, Animal
Control and Pet Adoption Center, Airport and Parks and Recreation Commission.
BE IT FURTHER RESOLVED that the FY 2018 — FY 2020 Budgets are amended pursuant to Schedules A
and B.
Chairperson, on behalf of the Finance Committee, I move the adoption of the forgoing resoltAjo
Commissioner Thomas Middleton, Distridt-#4
Chairperson, Finance Committee
COUNTY MICHIGAN
MANAGEMENT 8b BUDGET
OAKLAND COUNTY EXECUTIVE L. BROOKS PATTERSON
Laurie Van Pelt, Director
(248) 858-2163 I vanpalti@oakgov.com
TO: Members of the Finance Committee
FROM: Laurie Van Pelt, Director, Management and Budget
Lynn Sonkiss, Manager, Fiscal Services
Holly Conforti, Chief, Fiscal Services
Ebru Adoglu-Jones, Supervisor of Fiscal Services
SUBJECT; Letter of Transmittal - Fiscal Year 2018 Third Quarter Forecast
DATE: September 20, 2018
FY 2018 THIRD QUARTER REPORT
Attached please find the Fiscal Year (FY) 2018 Third Quarter Forecast Report. In total, Fiscal Services
forecasts that the County will complete FY 2018 with an overall favorable variance of $25,505,630 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 $7,508,766 more revenue than anticipated and projected
favorability in expenditures of $17,996,865.
REVENUES
GF/GP revenues are 1.57% more than budget or $7,508,765. Major variances are the result of the
following events:
A. FEDERAL GRANTS — Favorable: $130,462
Favorable Sheriff's Office $70,462 due to timing of the High Intensity Drug Trafficking Areas
(HIDTA) Grant and $60,000 in the Prosecuting Attorney's Office for the Michigan Department of
Health and Human Services Title IV-E Contract.
B. STATE GRANTS — Unfavorable: ($1,000,000)
Reduced state funding is primarily the result of reduced Child Care fund costs. The revenue
loss is more than offset by projected reduced expenditures. Expenditures are favorable for
Foster Boarding Homes and Private Institutions - Residential and Foster Care.
C. OTHER INTERGOVERNMENTAL REVENUE — Unfavorable: ($110,000)
Unfavorable primarily due to State Court Fund Disb PA 189 revenue ($350,000) based on
caseload distribution, unfavorable Sheriff's Office ($15,000) due to social security incentive
payments from lower jail population and unfavorable Local Match ($9,000) due to fewer siren
installations. This is partially offset by favorable Revenue Sharing of $264,000.
D. CHARGES FOR SERVICES — Favorable: $8,350,713
Favorable primarily in the Treasurer's Office $4.45 million for Payments Other than Anticipated,
$140,000 Recording Fees, $123,500 for Deeds and $190,000 Administration Fees; County
Clerk's Office $1.5 million for Recording Fees, $297,000 for Filing Fees and $230,200 for
Deeds; Children's Village Out County Board and Care $1,276,000 and County Board and Care
$140,000 due to an increase in reimbursement rate from the State; also favorable $815,000
2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48325 I Fax (248) 452-9172 I OakGov.com 1
across the District Courts primarily in Ordinance Fines and Costs and State Law Costs due to
collection efforts. This is partially offset by unfavorable Mortgages ($500,000) and Enhanced
Access Fees ($240,800) in the County Clerk's Office due to less than anticipated activity.
EXPENDITURES
In total, expenditures are projected to be 3.77% under budget or $17,996,865 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: ($390,400)
• The department is forecasted to be unfavorable due to increased use of overtime and related
fringe benefits; primarily in the Corrective Services area which has a large number of vacant
positions and employees on leave. The unfavorable overtime is partially offset by favorable
salaries and fringe benefits for the vacant positions. A budget amendment will be made by year
end if the trend continues.
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 Reporting Adjustments '
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 — Budgetary Perspective
The presentation reflects the true fiscal activity of the County for FY 2018:
Revenues - over/ (under) budget $ 7,508,765
Expenditures — (over)/under budget 17,996,865
Total Officially Reported Favorability M=
GAAP Required Reporting Method
Under GAAP, the Planned Use of Fund Balance is removed as a "revenue" source. The amended
revenue budget assumed the use of $52,568,600 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 Use of Fund
2100 Pontiac Lake Road I County Executive Building 41W } Waterford, MI 48328 I Fax (248) 452-9172 I OakGov.com 2
Balance is removed from the revenue calculation, the impact on the County's official financial
statements is:
Revenue Variance
Reduce — Planned use of Fund Balance
Revenue Variance
$ 7,508,765
(52,568,600)
$ (45,059,835)
Expenditure Variance (Comparing Actual to Approved Plan)
GAAP Reported Effect on Fund Balance
17,996,865
$ (27,062,970)
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 2018 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 $25.5 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 $27.0 million by the end of Fiscal Year 2018. 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 2018-2020 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 2018. However, it should be noted while the amended budget
reflects the utilization of $52.5 million of Fund Balance, this forecast projects the use of Fund Balance
needed to support FY 2018 activities of $27.0 million, $25.5 million less than planned.
2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 I Fax (248) 452-9172 I OakGov.com 3
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2018 FY 2019 FY 2020 AMENDMENTS AMENDMENTS AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) DEPT PROGRAM ACCT FUND AFF. OP UNIT SHERIFF'S OFFICE Expenditures 4030901 110090 760157 4030901 110090 788001 21341 ACCOUNT NAME Equipment Transfers Out Total Expenditures $ (1,745.00) 1,745.00 Revenue 4030901 116240 695500 21340 Transfers In - Law Enforcement Enhance Lab Fees $ 34,050.00 4030901 110090 695500 21341 Transfers In - Law Enforcement Lab Fees 841.00 4030701 116230 695500 21396 Transfers In - Sheriff Dispatch Training 21,326.00 4030301 112620 695500 21397 Transfers In - Sheriff Booking Fee Training 37,035.00 9010101 196030 665882 Planned Use of Balance (841.00) Total Revenue $ 92,411.00 Expenditures 4030901 116240 750203 Forensic Lab Enhancement $ 34,050.00 4030701 116230 731304 Officers Training 21,326.00 4030301 112620 731304 Officers Training 37,035.00 Total Expenditures 92,411.00 HUMAN RESOURCES Revenues 1050403 183020 731570 Recruitment Expense $ (11,560.00) 1050403 183020 774636 IT Operations 11,560.00 Total Expenditures 7
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2018 FY 2019 FY 2020 AMENDMENTS AMENDMENTS AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) DEPT PROGRAM ACCT FUND AFF. OP UNIT HOMELAND SECURITY Project ID 100000002372 Bud Ref: 2018 Analysis: GLB Activity: GLB ACCOUNT NAME Revenues 9010101 196030 665882 1060601 115180 610313 Expenditures 1090205 171030 730205 1090205 171030 732165 ANIMAL CONTROL Expenditures 1070805 114000 665882 Animal Control Planned Use of Balance 9010101 196030 665882 Non-Dept - Planned Use of Balance Total Expenditures Planned Use of Balance Federal Operating Grants Total Revenues Animal Shots Sale of License Non-Dept-Planned Use of Balance Total Expenditures Business Recruitment Workshops and Meetings Total Expenditures 7,300 (7,300) 3,315.00 (3,315.00) 426.00 157.00 (583.00) 20,000 20,000 10,000 10,000 20,000 Expenditures 1070805 114050 630070 1070801 114000 630074 9010101 196030 665882 ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS Revenues 1090205 171030 631827 Reimb General Total Revenues 8
Revenues 1090201 1090201 1090201 1090201 1090205 1090205 1090204 1090204 171000 171050 172080 172100 171030 171050 172080 172100 650301 650301 650301 650301 631827 632065 631757 631757 SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) Expenditures 1090201 171047 731388 1090201 171047 732165 Printing Workshops and Meetings Total Expenditures Donations Donations Donations Donations Reimb General Seminars/Conferences Registration Fees Registration Fees Total Revenues 21330 Transfer In - Children's Village Donations Fund Total Revenues Incentives Total Expenditures FY 2018 FY 2019 FY 2020 AMENDMENTS AMENDMENTS AMENDMENTS 50,000 50,000 854 49,146 50,000 $ (10,000.00) (3,040.00) (1,200.00) (6,000.00) 10,000.00 3,040.00 1,200.00 6,000.00 256.00 256.00 256.00 256.00 rGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) DEPT PROGRAM ACCT FUND AFF. OP UNIT ACCOUNT NAME Revenues 1090201 171047 632065 Seminars/Conferences Total Revenues CHILD CARE FUND (#20293) Revenues 1060501 112255 695500 Expenditures 1060501 112255 750245 9
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2018 FY 2019 FY 2020 AMENDMENTS AMENDMENTS AMENDMENTS IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) DEPT PROGRAM ACCT FUND AFF. OP UNIT ACCOUNT NAME NON-DEPARTMENTAL Revenues 9010101 196030 665882 Planned Use of Balance $ 11,676.00 Total Revenues $ 11,676.00 Expenditures 9010101 112710 788001 53100 Transfers Out-Fire Records Management Total Expenditures $ 11,676.00 $ 11,676.00 10
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS 'PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name SHERIFF - LAW ENFORCEMENT ENHANCE STATE (#21341) Revenue 4030901 110090 695500 10100 Transfers In-General Fund 4030901 110090 665882 Planned Use of Balance Total Revenue SHERIFF - LAW ENFORCEMENT ENHANCE LAB FEES (#21340) Revenue 1,745.00 (1,745.00) 4030901 116240 665882 Expenditures 4030901 116240 788001 10100 Planned Use of Balance Total Revenue Transfers Out - General Fund Total Expenditures 34,050.00 34,050.00 34,050.00 34,050.00 SHERIFF - LAW ENFORCEMENT ENHANCE STATE (#21341) Revenue 4030901 110090 665382 Expenditures 4030901 110090 788001 10100 SHERIFF - SHERIFF TRAINING (#21396) Revenue 4030701 112630 665882 Planned Use of Balance Total Revenue Transfers Out - General Fund Total Expenditures 841.00 841.00 841.00 841.00 Planned Use of Balance 21,326.00 Total Revenue 21,326.00 11
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS ACCOUNT NUMBER FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS [PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Expenditures 4030701 112630 788001 10100 Transfers Out - General Fund Total Expenditures SHERIFF - SHERIFF BOOKING FEE TRAINING (#21397) Revenue 4030301 112620 665882 Planned Use of Balance Total Revenue Expenditures 4030301 112620 788001 10100 Transfers Out - General Fund Total Expenditures CHILDREN'S VILLAGE DONATIONS FUND (#21330) Revenues 9010101 112255 665882 Planned Use of Balance Total Revenues 21,326.00 21,326.00 37,035.00 37,035.00 37,035.00 37,035.00 256.00 256.00 Expenditures 9010101 112255 788001 20293 Transfer Out - Child Care Fund Total Expenditures 256.00 256.00 FIRE RECORDS MANAGEMENT FUND (#53100) Revenues 1080325 115100 695500 10100 1080325 115100 665882 Operating Transfers In Planned Use of Balance Total Revenues 11,676.00 (11,676.00) 12
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2018 AMENDMENTS ACCOUNT NUMBER PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name CIRCUIT COURT - MICH MENTAL HEALTH SCAO - #27175 GR0000000423 Activity: GLB, Analysis Type: GLB, Budget Ref: 2018 Expenditures 3010301 121200 732011 3010301 121200 731416 CIRCUIT COURT - FRIEND OF THE COURT (#27100) Expenditures 3010404 126030 702010 3010404 126030 730926 3010404 135140 730926 4030925 110070 730926 Expenditures 3010404 126030 731759 3010404 126030 750399 Transportation Service Priv Institutions Residential Total Expenditures Salaries Regular Indirect Costs Indirect Costs Indirect Costs Total Expenditures Smile Program Office Supplies Total Expenditures $ 1,759.00 (1,260.00) (335.00) (164.00) $ $ 10,300.00 (10,300.00) $ $ (2,000,00) 2,000.00 $ SHERIFFS OFFICE - ATPA GRANT (#27310) GR #0000000377 Activity: GLB Analysis: GLB Budget Ref: 2018 Revenue 4030901 116270 615571 State Operating Grants $ 5,744.00 Total Revenue $ 5,744.00 Expenditures 4030901 116270 750070 Deputy Supplies $ 5,744.00 Total Expenditures $ 5,744.00 13
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS ACCOUNT NUMBER FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS Ir'ROPRIETARY I SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Revenue 4030901 116270 615571 State Operating Grants $ 220.00 Total Revenue $ 220.00 Expenditures 4030901 116270 750070 Deputy Supplies $ 220.00 Total Expenditures $ 220.00 $ SHERIFFS OFFICE - MICHIGAN MEDICAL MARIHUANA OPERATION AND OVERSIGHT GRANT (#27323) GR #0000000784 Activity: GLB Analysis: GLB Budget Ref: 2018 Expenditures 4030901 110090 712020 Overtime 4030901 110090 731465 Program Total Expenditures HEALTH DIVISION - SUICIDE PREVENTION (#286151 GR0000000725 Bud Ref: 2018 Activity: GLB Analysis: GLB Expenditures $ (64,000.00) 84,000.00 - $ 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 133390 133390 133390 133390 133390 133390 133390 133390 133390 702010 702030 730072 730555 730926 730982 731388 731941 732166 Salaries Regular Holiday Advertising Education Programs Indirect Costs Interpreter Fees Printing Training Workshops and Meeting (2,559.00) 569.00 (1,000,00) 309.00 (327.00) (555.00) (6,000,00) 5,563.00 250.00 14
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY I SPECIAL REVENUE FUNDS FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 1060233 133390 750294 Materials and Supplies 1060233 133390 750399 Office Supplies 1060233 133390 750448 Postage-Standard Mailing 1060233 133390 750567 Training-Educational Supplies Total Expenditures HEALTH DIVISION - BIORTERROISM COORDINATOR (#28610) GR0000000825 Bud Ref: 2019 Activity: GLB Analysis: GLB $ 14,500.00 (250.00) (250.00) (10,250.00) Revenues 1060290 115010 610313 Federal Operating Grants $ 73,034 Total Revenues $ 73,034 Expenditures 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 115010 115010 115010 115010 115010 115010 115010 115010 115010 115010 115010 702010 722740 730926 731346 731388 750077 750392 750399 774637 774677 778675 Salaries Regular Fringe Benefits Indirect Costs Personal Mileage Printing Disaster Supplies Metered Postage Office Supplies Info Tech Managed Print Svcs Insurance Fund Telephone Communications Totai Expenditures $ $ 33,811 26,251 4,324 818 3,500 2,125 150 600 465 90 900 73,034 15
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS ACCOUNT NUMBER FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dent ID Program Acct Fund Aff Over Unit Account Name HEALTH DIVISION - CITIES READINESS (#28610) GR0000000825 Bud Ref: 2019 Activity: GLB Analysis: GLB Revenues 1060290 115035 610313 Federal Operating Grants Total Revenues Salaries Regular Fringe Benefits Indirect Costs Personal Mileage Printing Workshops and Meeting Disaster Supplies Office Supplies Bldg Space Cost Allocation Info Tech Operations Info Tech Managed Print Svcs Insurance Fund Telephone Communications Total Expenditures Federal Operating Grants Total Revenues Expenditures 1060290 115035 702010 1060290 115035 722740 1060290 115035 730926 1060290 115035 731346 1060290 115035 731388 1060290 115035 732165 1060290 115035 750077 1060290 115035 750399 1060290 115035 770631 1060290 115035 774636 1060290 115035 774637 1060290 115035 774677 1060290 115035 778675 HEALTH DIVISION - TB OUTREACH (#28556) GR0000000192 Bud Ref: 2018 Activity: GLB Analysis: GLB Revenues 1060235 133970 610313 50,202 50,202 19,342 14,097 2,474 545 1,000 2,000 3,060 500 3,810 2,382 465 60 467 50,202 2,432 2,432 16
SCHEDULE 13 ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Expenditures 1060235 133970 732018 MSHDA - HOUSING EDUCATION GRANT (#29722) GR0000000806 Bud Ref: 2017 Activity: GLB Analysis: GLB Revenues 1090680 132210 615571 Travel and Conference 2,432 Total Expenditures 2,432 State Operating Grants 3,859 Total Revenues 3,859 Expenditures 1090680 132210 702010 1090680 132210 722740 Salaries Fringe Benefits Total Expenditures 2,316 1,544 3,859 WORKFORCE DEVELOPMENT (#29801) GR0000000294 Bud Ref: 2006 Activity: GLB Analysis: GLB Expenditures 1090701 1090701 1090701 170010 170010 170020 702010 722740 731465 Salaries Fringe Benefits Programs Total Expenditures 1,253 $ 480 (1,733) - $ 11,075 $ 4,242 (15,317) - $ 12,185 4,666 (16,851) 17
160000 160666 160666 160666 160666 670456 665882 665882 665882 665882 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept icn Program Acct Fund Aft Doer Unit Account Name PARKS AND RECREATION FUND (#50800) Revenues 160001 730198 160010 730814 160010 730814 160070 730198 160070 730814 160070 730198 160070 730814 160070 730814 160070 731115 160070 730814 160070 730814 160070 730814 160070 730314 160070 730814 160070 730814 160070 730814 160210 730814 160210 730814 160210 730198 160430 731115 160430 750154 160430 731388 5060101 5060666 5060666 5060666 5060666 Expenses 5060101 5060327 5060330 5060715 5060715 5060720 5060720 5060724 5060725 5060725 5060729 5060732 5060735 5060755 5060760 5060765 5060831 5060837 5060837 5060910 5060910 5060910 Prior Years Adjustments Planned Use of Balance Planned Use of Balance Planned Use of Balance Planned Use of Balance Total Revenues Building Maintenance Charges Grounds Maintenance Grounds Maintenance Building Maintenance Charges Grounds Maintenance Building Maintenance Charges Grounds Maintenance Grounds Maintenance Licenses and Permits Grounds Maintenance Grounds Maintenance Grounds Maintenance Grounds Maintenance Grounds Maintenance Grounds Maintenance Grounds Maintenance Grounds Maintenance Grounds Maintenance Building Maintenance Charges Licenses and Permits Expendable Equipment Printing 29,834.00 (48,000) 4,050 (29,834) 24,170 (19,780) 165 11,285 2,023 2,286 16,828 315 19,098 18,967 102 1,402 1,287 5,634 13,006 6,985 9,659 4,550 151,960 700 19,931 77 624 1,100 18
(48,000) (292,984) 2,249 1,801 70 390 26 1,778 17 577 1,749 66 650 1,190 2,043 116 1,563 4,517 250 1,963 3,202 744 2,910 349 (19,780) SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID I:v- _am Acct Fund Aff Oper Unit Account Name 5060910 160430 730789 General Program Administration 5060910 160430 730789 General Program Administration 5060417 160044 730044 Adj Prior Years Revenue 5060427 160044 730044 Adj Prior Years Revenue 5060101 160001 730037 Adj Prior Years Expense 5060101 160000 730037 Adj Prior Years Expense 5060326 160010 730037 Adj Prior Years Expense 5060327 160010 730037 Adj Prior Years Expense 5060328 160010 730037 Adj Prior Years Expense 5060330 160010 730037 Adj Prior Years Expense 5060417 160044 730037 Adj Prior Years Expense 5060420 160044 730037 Adj Prior Years Expense 5060426 160044 730037 Adj Prior Years Expense 5060430 160044 730037 Adj Prior Years Expense 5060456 160044 730037 Adj Prior Years Expense 5060540 160500 730037 Adj Prior Years Expense 5060715 160070 730037 Adj Prior Years Expense 5060720 160070 730037 Adj Prior Years Expense 5060724 160070 730037 Adj Prior Years Expense 5060725 160070 730037 Adj Prior Years Expense 5060732 160070 730037 Adj Prior Years Expense 5060735 160070 730037 Adj Prior Years Expense 5060837 160210 730037 Adj Prior Years Expense 5060845 160210 730037 Adj Prior Years Expense Total Expenses 19
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID program Acct Fund Aff Oper Unit Account Name EVERGREEN FARMINGTON FUND (#58410) Revenue 6010101 149152 695500 57282 Transfer In - Bingham Farms Fund 6010101 149152 695500 57241 Transfer In-Commerce Township Fund 6010101 149152 695500 57273 Transfer In - Farmington Hills Fund 6010101 149152 695500 57107 Transfer In - Highland Township Fund 6010101 149152 695500 57291 Transfer In - Royal Oak Township Fund 6010101 149145 665882 Planned Use of Balance Total Revenue 250.00 2,339.00 9,132.00 570.00 283.00 (12,574.00) BINGHAM FARMS FUND (#57282) Revenue 6010101 149152 665882 COMMERCE TOWNSHIP FUND (#57241) Revenue 6010101 149152 665882 Planned Use of Balance 250.00 Total Revenue 250.00 Planned Use of Balance 2,339.00 Total Revenue 2,339.00 Expense 6010101 149152 788001 58410 Transfer Out - Evergreen Farrnington Fund 250.00 Total Expense 250.00 Expense 6010101 149152 788001 58410 Transfer Out Evergreen Fan-nington Fund 2,339.00 Total Expense 2,339.00 20
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS ACCOUNT NUMBER FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS [PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit FARMINGTON HILLS FUND (#57273) Revenue 6010101 149152 665882 HIGHLAND TOWNSHIP FUND (#57107) Revenue 6010101 149152 665882 Account Name Planned Use of Balance Total Revenue Planned Use of Balance Total Revenue $ 9,132.00 $ 9,132.00 $ 570.00 $ 570.00 Expense 6010101 149152 788001 58410 Transfer Out-Evergreen Farmington Fund $ 9132.00 Total Expense $ 9,132.00 Expense 6010101 149152 788001 58410 Transfer Out - Evergreen Farmington Fund $ 570.00 Total Expense $ 570.00 ROYAL OAK TOWNSHIP FUND (#57291) Revenue 6010101 149152 665882 Planned Use of Balance Total Revenue $ 283.00 $ 283.00 Expense 6010101 149152 788001 58410 Transfer Out - Evergreen Farmington Fund $ 283.00 Total Expense $ 283.00 21
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund All (Doer Unit Account Name MOTOR POOL FUND (#66100) Expenses 1030811 184010 730233 1030811 184010 731878 1030811 184010 750413 1030811 184010 796500 INFORMATION TECHNOLOGY FUND (#63600) Revenues 1080101 152000 665882 Car Wash Sublet Repairs Parts and Accessories Budgeted Equity Adjustment Total Expenses 20,000.00 75,000,00 30,000.00 (125,000.00) Planned Use of Fund Balance Total Revenues 1,000,000.00 1,000,000.00 Expenses 1080201 152010 731458 1080601 152010 731458 Professional Svcs 800,000.00 Professional Svcs 200,000,00 Total Expenses 1,000,000.00 22
COUNTY OF OAKLAND
FY 2018 THIRD QUARTER REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2018
ADOPTED
BUDGET
BUDGET
AS
AMENDED
FY 2018
FORECAST
AMOUNT
FAVORABLE/
(UNFAVORABLE) PERCENT
REVENUES
GENERAL FUND
Taxes $ 226,626,698.00 $ 226,626,698.00 $ 226,655,698.00 $ 29,000.00
Federal Grants 693,892.00 1,052,068.00 1,182,530.00 130,462.00
State Grants 20,565,842.00 20,575,006.00 19,575,005.00 (1,000,000.00)
Other Intergovernmental Revenue 44,760,644.00 46,466,690,00 46,356,690.00 (110,000.00)
Charges for Services 110,083,318.00 111,268,020.00 119,618,733.00 8,350,713.00
Indirect Cost Recovery 8,114,737.00 8,134,737.00 8,134,737.00
Investment Income 1,904,700,00 1,904,700.00 1,938,700.00 34,000.00
Other Revenues 9,090,297,00 9,349,828,00 9,424,417.67 74,589.67
SUB-TOTAL GENERAL FUND/GENERAL PURPOSE $ 421,860,128.00 $ 425,377,747,00 $ 432,886,511.67 $ 7,505,764.67
PLANNED USE OF FUND BALANCE
$ 33,122,397.00 $ 52,568,600.21 $ 52,568,600.21 0.00%
TOTAL GF/GP FUNDS 454,982,525.00 $ 477,946,347.21 485,455,111.88 7 508 764.67 1.57%
0,01%
12.40%
-4.86%
-0,24%
7.51%
0.00%
1.79%
0.80%
1.77%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
52nd District Court
Probate Court
TOTAL ADMIN. OF JUSTICE
$ 52,897,286.00
17,468,272.00
6,422,263.00
$ 76,787,821.00
$ 54,858,899,00
17,592,688.21
6,460,033.00
$ 78,911,620.21
46,786,499,00
16,942,388.21
6,057,533.00
$ 8,072,400.00
650,300,00
402,500.00
14.71%
3.70%
6,23%
$ 69,786,420.21 $ 9,126,200.00 11.56%
LAW ENFORCEMENT
Prosecuting Attorney 20,714,070.00 20,841,198.00 19,455,198.00 1,386,000.00 6,65%
Sheriff 151,190,737,00 154,043,688.26 154,434,088.26 (390,400.00) -0.25%
TOTAL LAW ENFORCEMENT $ 171,904,807.00 $ 174,884,886.26 $ 173,889,286.26 995,600.00 0.57%
GENERAL GOVERNMENT
Clerk/Register of Deeds
Treasurer
Board of Commissioners
Library Board
Water Resources Commissioner
10,750,706.00 11,023,060.00 9,351,160.00 1,671,900.00
8,553,534.00 9,088,384.00 8,017,284.00 1,071,100.00
3,093,086.00 3,738,436.00 3,678,436.00 60,000.00
1,368,601.00 1,395,635.00 1,389,635.00 6,000.00
6,738,890.00 7,027,983.00 6,953,818.00 74,165.00
15.17%
11.79%
1.60%
0.43%
1.06%
TOTAL GENERAL GOVERNMENT $ 30,804,817.00 $ 32,273,498.00 $ 29,390,333.00 $ 2,883,166.00 8.93%
COUNTY EXECUTIVE
County Executive Adinn.
Management and Budget
Central Services
Facilities Management
Human Resources
Health and Human Services
Public Services
Economic Dev. and Comm Affairs
TOTAL COUNTY EXECUTIVE
$ 7,896,852 00 $ 7,964,476.00 $ 7,931,276.00 $ 33,200.00
20,299,401.00 20,905,864.46 19,612,364.46 1,293,500.00
2,665,437.00 2,925,935.00 2,870,935.00 55,000,00
1,374,924.00 1,403,860,00 1,386,860,00 17,000,00
4,090,723.00 4,487,361.00 4,135,861.00 351,500,00
67,324,551.00 68,660,986.28 66,669,286.28 1,991,700.00
18,036,978.00 18,501,207.00 18,018,407.00 482,800.00
8,356,708.00 9,321,767.00 8,743,567.00 578,200.00
$ 130,075,574.00 134,171,456.74 $ 129,368,556.74 $ 4,802,900.00
0.42%
6.19%
1.88%
1.21%
7.83%
2.90%
2.61%
6.20%
3.68%
TOTAL DEPARTMENTS $ 409,573,019.00 $ 420,241,461.21 .$ 402,434,596.21 $ 17,806,865.00 4.24%
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTAL 45,409,506.00 57,704,886.00 57,514,886.00 190,000.00 0.33%
TOTAL GOVERNMENTAL EXPENDITURES 454 982 525 00 $ 477,946,347.21 469,949,482.21 17,996,865.00 3.77%
General Fund/General Purpose
Favorable/(Unfavorable) - Budget Perspective 25 606 629 67 $ 26,506,629.67
GAAP Required Adjustment (eliminating use of fund balance 'revenue') $ (52,568,600.21) $ (52,568,600.21)
GAAP - BASED REPORT (forecasted impact on Fund Balance) ($27 062 970 54) ($27,062,970.54)
23
COUNTY OF OAKLAND GENERAL FUND GENERAL PURPOSE REVENUES FY 2018 THIRD QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES TAXES (601000-601999) Property Taxes - July Tax Levy Other Taxes - Delinquent Tax - Prior Years Treasurer Payment in Lieu of Taxes Other Taxes - Trailer Tax Total Taxes $ 226,148,198.00 $ 226,148,198.00 $ 226,148,198.00 $ 98,500.00 98,500.00 98,500.00 300,000.00 300,000.00 329,000.00 29,000.00 80,000.00 50,000.00 80,000.00 $ 226,626,698.00 $ 226,626,698.00 $ 226,655,698.00 $ 29,000.00 0.00% 0.00% 9.67% Fav. due to tax payments from the state on DNR land. 0.00% 0.01% FEDERAL GRANTS (610000-610999) Sheriff - Patrol 138.477.00 $ 135,477.00 $ 0.00% Sheriff - Corrective Services 27,220.00 0.00% Sheriff - Investigative/Forensic Services 70,462.00 70,462.00 100.00% Fay. Due to timing of funding for the High Intensity Drug Trafficking Areas (HIDTA) Grant Prosecuting Attorney 205,000.00 205,000.00 265,000.00 60,000.00 29.27% Fav. due to contract with Michigan Department of Health and Human Services Title IV-E. Homeland Security - Disaster Control Health Division Children's Village Total Federal Grants 60,800.00 68,257.00 100,872_00 340,334,00 300,000.00 300,000.00 593,892.00 $ 1,052,068.00 $ 68,257.00 340,334.00 300,000.00 1,182,530.00 $ 130,462.00 0.00% 0.00% 0.00% 12.40% STATE GRANTS (615000-615999) Sheriff - Patrol State Match Foster Care Prosecuting Attorney Economic Development Health Division Water Resources Commissioner Public Services - Veteran's Services Non-Departmental - Child Care Subsidy - $ 1,000.00 4,812,160.00 15,752,652,00 1,000.00 10,000.00 4,811,324.00 15,752,682.00 - $ 1,000.00 10,000.00 4,811,324.00 14,752,682.00 (1,000,000.00) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -6.35% Built into the Circuit Court Family Division, Human Services Administration and Children's Village budgets are Child Care Fund expenditures. A favorable variance within these expense areas reduces the 50% reimbursement the county receives. Unfav revenue variance is offset by Child Care Fund expenditure favorability. Total State Grants $ 20,565,842.00 $ 20,575,006.00 $ 19,575,006.00 $ (1,000,000.00) -4.86% OTHER INTER-GOVERNMENTAL REVENUES (620000- 626999) Non-Departmental HHS - Homeland Security Circuit Court District Court Sheriff 42,519,178.00 5 44,227,224.00 8 44,141,224.00 $ (86,000.00) 18,000.00 15,000.00 9,000.00 (9,000.00) 4,500.00 4,500,00 4,500,00 1,800.00 1,800.00 1,800.00 268,706.00 266,706.00 251,706.00 (15.000.00) -0.19% Unfavorable State Court Fund Dist PA 189 ($350,000) based on caseload distribution. Partially offset by favorable Revenue Sharing $264,000. -50.00% Unfav. Local Match due to the installation of fewer than anticipated sirens. 0.00% 0.00% -5.62% Unfav, Social Security Incentive Payments due to lower jail population. Funds are collected from jail inmates receiving SSI for cost of incarceration. 24
COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2018 THIRD QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Non-Departmental - Reimb Judges Salaries 1,948,460.00 1,948,460.00 1,948,460,40 0.00% Total Other Intergovernmental Revenue $ 44,760,644.00 $ 46,466,690.00 $ 46,356,690.00 $ (110,000.00) -0.24% Circuit Court - Family Division District Court - Division I (Novi) District Court - Division 11 (Clarkston) - $ - $ 0.00% 2,586,500.00 2,487,500.00 (99,000.00) -3.83% Unfav. Civil Mediation Payments ($100,000) due to a reduction in use of mediation. Unfav. Refund Fees PD Def Attorney ($70,000) due to a decrease in activity. Unfav. Jury Fees ($25,000) due to reduction in jury trials. Partially offset by fay. Court Costs $75,000 due to more than anticipated revenue. Fay. E-Filing Fees $21,000 due to unanticipated E-Filing revenue. Effective 12-31-17 E-Filing Fees is no longer be collected by the Circuit Court. (10,000.00) -0.56% Unfav. Refund Fees PD Def Attorney ($30,000) due to a decrease in activity. Unfav. Court Service Fees Probation ($20,000) and Reimb Clinical Evaluations ($10,000) due to a reduction in family caseload. Partially offset by an increase in Board and Care $50,000. 230,000.00 6.08% Fay. Ordinance Fines and Costs $175,000; State Law Costs $100,000: as well as Late Penalty $50,000 due to continued collection efforts. Partially offset by unfav. Probation Fees ($70,000) along with Garnishment Fees ($25,000) due to a reduction in caseload. 60,000,00 3.47% Fav. Ordinance Fines and Costs $30,000 as well as State Law Costs $30,000 due to an increase in Criminal/Traffic caseload and continued collection efforts. 525,000.00 14.73% Fav. Ordinance Fines and Costs $450,000 as well as State Law Costs $75,000 based on continued collection efforts. Fay. Forfeiture of Bonds $25,000 due to an increased number of defendants failing to appear before the court. Partially offset by unfav. Probation Fees ($25,000) due to probationer's inability to pay monthly Probationary Oversight Expense. (45,000.00) -1.99% Unfav. Probation Fees ($30,000) due to probationer's inability to pay monthly Probationary Oversight Expense. Unfav. Miscellaneous ($25,000) due to decrease in filings. Unfav. Garnishment Fees ($15,000) due to a decrease in the number of civil cases filed. Partially offset by fay. Forfeiture of Bonds $25,000 due to an increased number of defendants failing to appear before the court. CHARGES FOR SERVICES (630000-635999) Administration of Justice Circuit Court - Judicial/Administration - $ Circuit Court - Civil/Criminal 2,456,000.00 1,799,500.00 1,799,500.00 1,789,500.00 3,784,200.00 1,731,200.00 3,784,200.00 1,731,200.00 4,014,200.00 1,791,200.00 District Court - Division Ill (Rochester Hills) 3,563,900.00 3,563,900.00 4,088,900.00 District Court - Division IV (Troy) 2,263,350.00 2,263,350.00 2,218,350.00 25
COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2018 THIRD QUARTER REPORT Probate Court - Estates and Mental Health ADOPTED BUDGET 516,600.00 AMENDED BUDGET 515,504.00 FY 2018 FORECAST 561,600.00 AMOUNT FAVORABLE fUNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 45,000.00 8.71% Fay. Gross Estate Fees $50,000 due to an increase in fees paid. Fay. Certified Copies $15,000 due to an increase in activity. Partially offset by unfav. Refund Fees PD Def Attorney ($20,000) due to a decrease in fees collected. Total Administration of Justice $ 16,114,750.00 $ 16,245,250.00 $ 16,951,250.00 $ 706,000.00 4.35% Law Enforcement Prosecuting Attorney 295,053.00 $ 295,053.00 284,928.00 $ (10,125.00) -3.43% Unfav. Extradition Recovery Fee ($5,500) and Reimbursement General ($5,500) due to a decrease in activity and Welfare Fraud Case Review ($1,850) due to the State performing the review in-house; partially offset by fay. Microfilming $2,300 due to higher use. 1052.63% Fay. Reimb General $18,000 and DNA Testing Fees $2,000 doe to higher usage. -13.51% Unfav. Fingerprints ($56,000) due to less usage and Photographs ($9,000) due to transition to digital images; partially offset by FOIA Fees $12,000 due to increased requests. -6.84% Unfav. Reimb Salaries ($170,000) due to declining reimbursements, Inmate Board and Care ($150,000) due to inmates inabilrly to pay, FeO Income ($22,000) from bond fees and indigent jail commissary collections, Clinic Charges ($20,000) from inmates inability to reimburse for clinic services and OUIL Third Offense ($10,000) reduction in court driven assessments; partially offset by Commission Contracts $150,000 from increased jail commissary collections. 3.10% Fay. Reimb Court Services $60,000 for court security to non 52nd District Courts who contract with the Sheriffs Office for security; partially offset by Board and Care ($40,000) from inmates inability to pay. -40.00% Unfav. Civil Action Service Fees ($200,000) due to the decline in number of foreclosures and civil service requests (see corresponding favorability in Fees Civil Service expenditures). -1.86% Unfav. Sheriff Special Deputies ($630,000) and Reimb Salaries ($320,000) based on billable activity for law enforcement services. Sheriffs Office 1,900.00 1,900.00 21.900.00 20,000.00 Sheriff - Administrative Services 392,400.00 392,400.00 339,400.00 (53,000.00) Sheriff - Corrective Services 3,233,298.00 3,362,584.00 3,132,584.00 (230,000.00) Sheriff - Corrective Services Satellites 645,386.00 645,386.00 665,385.00 20,000.00 Sheriff - Emergency Response and Prep 832,220.00 500,000.00 300,000.00 (200,000.00) Sheriff - Patrol Services 60,452,186.00 51,175,585.00 50,225,588.00 (950,000.00) 26
COUNTY OF OAKLAND GENERAL FUND I GENERAL PURPOSE REVENUES FY 2018 THIRD QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLEt PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Sheriff - Emergency Communications Operations 1,598,337.00 2,080,276.00 2,050,276.00 0.00% Sheriff - Investigative Forensic Services 1,015,000.00 1,033,042,00 1,253,042.00 220,000.00 21.30% Fay. Drug Testing $150,000 collected from Results Program and probation clients. Also fav. Reimb Salaries $70,000 from unbudgeted billable activity. Total Law Enforcement $ 58,465,780.00 $ 59,486,227.00 $ 58,303,102.00 $ (1,183,125.00) -1.99% 13.42% Fav. Photostats $111,700, Certified Copies $100,000, Jury Fees $44,400, Forfeiture of Bonds $39,400, Forfeiture of Surety Bonds $39,300, E-Filing Fees $21,400 due to Increased activity. Partially offset by unfavorable Motion Fees ($16,100), Civil Action Entry Fees ($15,500), Assumed Names ($10,800), Marriage Waivers ($3,900) and Miscellaneous ($3,600) and Garnishment Fees ($3,200) due to less activity. Also unfavorable, Costs ($3,500) due to revenue associated with court ordered fees. 61.09% Fay, Election Filing Fees Late $28,600 due to Corporation Counsel efforts to collect on late filers. Nominating Filing Forfeit $14,000, Passport Fees $6,700 due to increased activity. 11.87% Fay, due to Recording Fees $1,500,000 and Deeds $230,200 partially offset by unfavorable Mortgages ($500,000) due to change in legislation in FY 2017 for recording documents (PA 224 of 2016). Also, favorable Land Transfer Tax $400,000 due to increased activity. Partially Offset by unfavorable Enhanced Access Fees ($240,500), Reimb. General ($15,000) and Photostats ($12,200) due to less than anticipated use. 102.11% Fay. Payment Other Than Anticipated $4,455,000, Deeds $123,500, Recording Fee Forfeiture Certificate $70,000 and Recording Fee Redemption Certificate $70,000 due to the sale of foreclosed properties (land sale activity). Also, favorable Admin Fees $190,000 and Civil Action Service Fees $50,000 due to increased activity. Partially offset by unfavorable Tax Statements ($44,000) and Tax Reverted Land ($6,200) due to reduced activity. -48.00% Unfav. due to change in vendors and anticipated reduction in prescription program royalty fee income. -0.71% Unfavorable Copier Machine Charges ($2,300) due to increased functionalities of downloading and e-mailing documents and Miscellaneous ($500); partially offset by favorable Reimb. Salaries $2,700 due to State aid to public libraries. General Government Clerk - County Clerk $ 2,212,100.00 $ 2,212,100.00 $ 2,509,000.00 $ 296,900.00 Clerk - Elections 80,700.00 80,700.00 130,000.00 49.300,00 Clerk - Register of Deeds & Micrographics 11,449,500.00 11,449,500.00 12,809,000.00 1,359,500.00 Treasurer 4,802,300,00 4,802,300.00 9,705,970.00 4,903,670.00 Board of Commissioners 12,500.00 12,500.00 6,500.00 (6,000.00) Library Board 14,000.00 14,000.00 13,900.00 (100.00) 27
COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2018 THIRD QUARTER REPORT Water Resources Commissioner ADOPTED BUDGET Z497,177.00 AMENDED BUDGET 2,497,177.00 FY 2018 FORECAST 2,632,177.00 AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 135,000.00 5.41% Fay - Soil Erosion Fees $75,000 increase in building activity/permits due to improvement in the housing market. hay - Reimbursement General $60,000 a result of Drain Administration able to charge more time than anticipated to special revenue and proprietary funds. Total General Government $ 21,068,277.00 $ 21,068,277.00 $ 27,806,547.00 $ 6,738,270.00 31.95°A 285,690.00 20,000.00 7.53% Fay. Refunds Miscellaneous due to increased members in vendor incentive program. Central Services - Support Services 133,968.00 4.11% Fay. Reimbursement Equalization Services due to actual contract billing. 8,400.00 1.66% Fay. Reimbursement Filing Fees $3,400; Reimbursement Contracts $2,000; and Reimbursement Postage $1,000 due to collection efforts by Reimbursement staff. Fay. Late Penalty $2,000 due to higher than anticipated assessment and collection. 321,950.00 321,950.00 310,850.00 (11,100.00) -3.45% Unfav. Commission Vending Machines ($12,500) due to Less than anticipated use; Unfav. Commission Food Services ($3,000) due to amendment to contract for FYI 8; Fav. Prior Years Revenue $4,300 due to FY17 Vending Machine Commission received in FY15. 0,00% 0.00% 66,300.00 1.65% Fay. Rabies Vaccines $78,000 due to improved reimbursement from insurance and increased animal bite exposures. Fay. Flu 3rd Party $45,500 due to increased reimbursement from 3rd party payers. Fav. Hepatitis Vaccine $20,000 and Plan Review Fees $17,000 due to increase in demand. Fay. Licenses $11,000 and Food Service Licenses $10,000 due to increase in demand and service fees. Fav. Inspection Fees $10,000 due to increase in enforcement activity for fixed foods and swimming pool inspections. Partially offset by Unfav. Immunizations ($100,000) due to decrease in demand for certain vaccines and timing of claims billing as a result of 3rd Party Clearing House vendor canceling contract without notice. Also; Untav. Pneumo Vax 3rd Party ($40,000) due to timing of claims billing. County Executive County Exec - Compliance Office 255,690.00 $ 265,690.00 $ County Exec - Compliance Office County Exec - Corp Counsel County Exec - Admin M&B - Equalization Division M&B - Fiscal Services Division 3,260,000.00 505,500.00 3260,000.00 505,500.00 3,393,968.00 514,000.00 Human Resources HHS - Administration HHS - Health Division 4,267,834.00 4,027,834.00 4,094,134.00 28
COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2018 THIRD QUARTER REPORT Public Services - Veterans AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 1,416,000.00 43.37% Fait. Out County Board and Care $1,276,000 as well as Board and Care $140,000 due to increase in Department of Health and Human Services placement and increased per diem rate for shelter care services. 0.00% ADOPTED AMENDED FY 2018 BUDGET BUDGET FORECAST HHS - Children's Village 3,189,200.00 3,264,600.00 4,680,600.00 HHS - Homeland Security Public Services - Community Corrections 4.565.00 4,565.00 0.00% 190,000.00 190,000.00 170,000.00 (20,000.00) -10.53% Unfav. Fee Income due to less than anticipated referrals from judges to the Weekend and Weekday Alternative for Misdemeanants (WWAM) Program. 1,800,000.00 1,800,000.00 1,800,000.00 $ 1,904,700.00 $ 1,904,700.00 $ 1,938,700.00 $ Public Services - Medical Examiner Public Services - Animal Control Public Services - Circuit Court Probation Economic Dev. & Comm. Affairs - Admin 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 (655000-655999) District Courts (Div. I - IV) Sheriff Corrective Services Sheriff Investigative/Technical Services Treasurer Clerk/Register of Deeds Economic Development Non-Departmental Total Investment Income 30,000.00 8.65% Fay. Cremation Approval Fee $20,000 due to greater than anticipated requests and Autopsies $10,000 due to an increased amount of autoposies performed due to agreement with the County of Jackson (MR18293), 20,000.00 1.63% Fay. Animal Sterlization Fees $12,500 due to initiatives to place animals in forever homes and Sale of Licenses $7,500 due to higher amount of dog license sales. 0.00% (24,000.00) -100.00% Unfav. Seminar's/Conferences revenue for Business Roundtable which will not occur in FY2018. 0.00% 1,639,568.00 11.92% 450,000.00 62.72% Favorable due to Commission Public Telephone revenue greater than anticipated. 62.72% 7.51% 0.00% 0,00% 0.00% 34,000.00 1.79% 339,000.00 339,000.00 369,000.00 913,200.00 1,093,834.00 1,113,834.00 24,000.00 24,000.00 441,225.00 453,725.00 453,725.00 $ 13,717,699.00 $ 13,750,798.00 $ 15,390,366.00 $ 716,812.00 717,468.00 1,167,468.00 716,812.00 $ 717,468.00 $ 1,167,468.00 $ 450,000.00 $ 110,083,318.00 $ 111,268,020.00 $ 119,618,733.00 $ 8,350,713.00 $ 8,134,737.00 $ 8,134,737.00 $ 8,134,737.00 $ 2,200.00 $ 2,200.00 $ 2,200.00 $ 0.00% 0.00% 0.00% 100,000.00 100,000.00 100,000.00 0.00% 2,500.00 2,500.00 36,500.00 34,000.00 1360.00% Fay. due to investment base and market rate adjustment. 29
COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2018 THIRD QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST SUNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OTHER REVENUES (670000-695500) Circuit Court-Donations Circuit Court-County Auction Circuit Court District Courts (Div, I - IV) Probate Court Prosecuting Attorney Sheriff Office Sheriff - Administrative Services Sheriff - Corrective Services 5,000.00 5,000.00 2,666.00 7,800.00 2,666.00 2,800.00 0.00% 0.00% 100.00% Fay. Refund Prior Years Expenditure due to reclassification of refund for prior year permit postage. 0.00% 0.00% 0.00% 56.00% Fay. Enhancement Funds $7,800 transferred from Restricted Fund for training; partially offset by unfav. County Auction ($5,000) offset in Investigative/Forensic Services division. 0.00% 0.00% Sheriff - Corrective Services-Satellites 0.00% Sheriff - Emergency Rasp and Prepare 0.00% Sheriff - Patrol Services 6,000.00 6,000.00 6,000.00 0.00% Sheriff - Emergency Communications Operations 0.00% Sheriff - Investigative/Forensic Svc 27,809.00 27,809.00 100.00% Fay. Refund of Prior Years Expenditures $16,480 for reimbursement of Sheriff's overtime, County Auction $10,325 partially offset in Sheriff's Office division and Adjustment Prior Years Revenue $1,004 High Intensity Drug Trafficking Area (HIDTA) prior year reimbursement Clerk/Register of Deeds 1,400.00 1,400.00 100.00% Fay, due to cash overages. Treasurer 1,200.00 1,200.00 100.00% Fay. due to cash overages. Board of Commissioners 0.00% Library Board 0.00% Water Resources Commissioner 0.00% County Exec - Compliance Office 0.00% Management and Budget - Fiscal Services 0.00% Central Services - Support Services 600.00 600.00 3,100.00 2,500.00 415.57% Fay. Prior Years Revenue due to receipt of FY 2017 Vending Machine Commission payment higher than anticipated. Human Resources 0.00% 30
Facilities Management Engineering Health Division - Contributions Health Division ADOPTED BUDGET AMENDED BUDGET FY 2018 FORECAST 4,280.00 320,156.00 Health Division - Transfers In COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2018 THIRD QUARTER REPORT Children's Village AMOUNT FAVORABLE (UNFAVORABLE...I PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 4,280.00 100.00% Fay. Refund Prior Years Expenditure due to reimbursement from vendor for overpayment. 0.00% 320,158.00 100.00% Fay. Prior Years Revenue $319,726 due to correction of FY 2017 estimated administrative overhead cost distribution. 0.00% 25,105.57 25,106.67 100.00% Fay. Refund Prior Years Expenditure due to food rebate assoicated with the National School Lunch Program. Children's Village - Transfers In Homeland Security Public Services - Medical Examiner Public Services - Animal Control-Other Revenues Public Services - Animal Control-Transfers In 813.00 19,524.00 813.00 19,524.00 0.00% 0.00% 0.00% 0.00% 0.00% Public Services -Animal Control-Planned Use of Balance (3,315.00) (3,315.00) Amendment error on 2nd Qtr forecast-Dept 1070805 was used rather than Non Dept. (9010101). Economic Development & Comm Affairs - Other 0.00% Economic Development - Contributions 29,240.00 72,512.00 72,612.00 0.00% Non Departmental - Donations Non-Dept - Sundry Sheriffs Transfers In Treasurers' Transfers 417,500.00 31,957.00 2,600,000.00 417,500.00 231,094.00 2,600,000.00 117,500.00 217,764.00 2,600,000.00 (300,000.00) (13,330.00) 0.00% -71.86% Unfavorable due to less than anticipated prior year adjustment activity. -5.77% Unfav. due to Transfer In budget occurring beyond life of budget amendments for MR #13315 ($9,430) and MR #14177 (83,900). 0.00% Non-Departmental - Transfers In 6,000,000.00 6,000,000.00 6,000,000.00 0,00% Total Other Revenues $ 9,090,297.00 $ 9,349,828.00 9,424,417.67 $ 74,589.67 0.80% PLANNED USE OF FUND BALANCE (665000-665999) Encumbrances and Carry forwards 5,039,686.21 5,039,686.21 0.00% Use of Prior Yrs Fund Balance $ 33,122,397.00 $ 47,528,914.00 47,528,914.00 0.00% Total Planned Use of Fund Balance $ 33,122,397.00 $ 52,568,600.21 $ 52,568,600.21 $ 0.00% TOTAL GEN. FUND GEN. PURPOSE REVENUE $ 454,982,525.00 $ 477,946,347.21 $ 485.455.111.88 $ 7,508,764.67 1.57% 31
$ 9,342,100.00 $ 9,342,100.00 $ 8,842,100.00 $ 110,876,00 449,900.00 239,000.00 77,500.00 481,724.00 559,224.00 500,000.00 210,900.00 401,464.00 Judicial Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out 5.35% Fay. due to underlined and vacant positions. 46.88% Fay. Expendable Equipment $150,000 due to lower than anticipated use. Fav. Special Projects $93,900 due to the distribution of Judicial Technology funds from the State and Judge On-Line project (MR #09017) used for courtroom technology improvements. Fay. Office Supplies $20,000 and Printing $17,000 due to continued efforts to minimize expenses and contain costs. Partially offset by unfav. Library Continuations ($70,000) due to higher than anticipated use. 13.86% - Fay. Info Tech Operations $65,000 due to the timing of Imaging Project implementation, Info Tech CLEMIS $12,500 due to lower than anticipated use. 0.00% Business Division Personnel Expenditures Operating Expenditures Internal Support Expenditures Civil I Criminal Division Personnel Expenditures Operating Expenditures 5,968,094.00 4,038,094.00 200,000.00 38,000.00 (25,000.00) 1,930,000.00 $ 1,783,372.00 $ 1,783,372.00 $ 1,583,372.00 $ 131,834.00 131,834.00 93,834.00 $ 1,883,613.00 $ 1,883,613.00 $ 1,908,613.00 $ 5,187,688.00 164,842.00 164,842.00 239,842.00 (75,000.00) $ 2,080,048.00 $ 2,080,048.00 $ 1,917,048.00 $ 163,000.00 COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 9,854,440.00 $ 10,351,224.00 $ 9,562,824.00 $ 788,400.00 7.62% 11.21% - Fav. due to underfilled and vacant positions. 28.82% - Fay. Visiting Judges $25,000; Computer Supplies $8,000; and Metered Postage $5,000 due to lower than anticipated use. -45.50% - Unfav. Info Tech Operations due to higher than anticipated use. 7.84% -1.33% Unfav. due to overfilled positions as well as an Emergency Salary position that is being charged to this division but not budgeted. 32.34% - Fav. Defense Atty Fees $725,000 and Defense Atty Fees Trials $575,000 due to increased budget allocation as a result of prior year carryforward for Juveniles to Life Without Parole (JLWOP). Fay. Juror Fees and Mileage $375,000 along with Attorney Fees Mediators $85,000 due to lower than anticipated use. Fay. Defense Atty Fees Appellate $170,000 due to decline in requests for appointed counsel. 9.74% - Fay. Info Tech Operations $300,000 due to lower than anticipated use. Partially offset by unfav, Info Tech CLEMIS ($19,000) and Equipment Rental ($10,000) due to higher than anticipated use. Internal Support Expenditures 2,359,256.00 2,781,081.00 2,510,081.00 271,000.00 32
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Transfers Out 2,176,000.00 20.46% Family Division/Juvenile Maint. Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out 1,225,000.00 6,728,900.00 118,500.00 $ 9,430,557.00 $ 10,632,788.00 $ 8,456,788.00 $ $ 11,746,860.00 $ 11,746,860.00 $ 11,196,860.00 $ 12,743,184,00 12,743,184.00 8,193,184.00 1,795,544.00 1,795,807,00 1,950,807,00 5,246,653.00 5,508,988.00 5,508,988.00 $ 31,532,241.00 $ 31,794,839.00 $ 26,849,839.00 $ $ 24,755,945.00 $ 24,755,945.00 $ 23,530,945.00 $ 18,173,582.00 19,293,012.00 12,564,112.00 4,721,106.00 5.300,954.00 5,182,454.00 5,246,653.00 5,508,988.00 5,508,988.00 4.68% - Fav. due to underfilled and vacant positions. 35.71% - Fay. due to decrease in placements to State Institutions $3,725,000 and Priv Institutions Residential $700,000. Fay. Professional Services $125,000 due to lower than anticipated use. Offset by unfavorable Non-Dept Child Care Subsidy Revenue (50% Reimbursement). -8.63% - Unfav. Info Tech Operations due to higher than anticipated use. 0,00% - 4.95% 34.88% 2.24% 0.00% 550,000.00 4,550,000.00 (155,000.00) 4,945,000.00 15.55% $ 52,897,286.00 $ 54,858,899.00 $ 46,786,499.00 $ 8,072,400.00 14.71% 33
ADOPTED AMENDED BUDGET BUDGET COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT FY 2018 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES District Court Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 236,703.00 $ 235,703.00 $ 221,703.00 $ 10.300.00 10,300.00 1,935.00 1,935.00 1,935.00 15,000.00 6.34% - Fay. due to turnover and underfilled positions/vacancies. 10,300.00 100.00% Fay. Visiting Judges due to lower than anticipated use. 0.00% 0.00% $ 248,938.00 $ 248,938.00 $ 223,638.00 $ 25,300.00 10.16% 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 Division 3 - Rochester Hills Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out 2.90% - Fay. due to turnover and underfilled positions/vacancies. 2.94% - Fay. Defense Attorney Fees $15,000 due to restructured scheduling improvements and efforts to contain costs. Fay. Medical Exam $7,500 due to lower than anticipated use. Fav. Office Supplies $7,500 due to continued efforts to minimize expenses and contain costs. 4.51% - Fay. Info Tech Operations $10,000 and Telephone Communications $7,500 due to lower than anticipated use. 0.00% - 6.37% - Fay. due to turnover and underfilled positions. 12.60% - Fay. Office Supplies $20,000 along with Juror Fees and Mileage $12,500 due to continued efforts to minimize expenses and contain costs. Fay. Defense Attorney Fees $20,000 due to a decrease in requests for appointed counsel. 1.17% - Fay. Info Tech Operations due to lower than anticipated use. 0.00% $ 4,314,794.00 $ 4,314,794.00 $ 4,189,794.00 125,000.00 1,021,191.00 1,021,191.00 991,191.00 30.000.00 355,641.00 388,340.00 370,840.00 17,500.00 3 4,079,798.00 $ 4,079,798.00 $ 3,819,798.00 260,000.00 416,733.00 416,733.00 364,233.00 52,500.00 814.425.00 851,101.00 841,101.00 10,000.00 $ 5,691,626.00 $ 5,724,325.00 $ 5,551,825.00 $ 172,500.00 3.01% $ 2,202,500.00 $ 2.202,500.00 $ 2,112,600.00 90,000.00 4.09% - Fav. due to turnover and underfilled positions/vacancies. 648,811.00 648,811.00 618,811.00 30,000.00 4.62% - Fay. Defense Attorney Fees $25,000 due to restructured schedule for defense attorneys. Fay. Software Support Maintenance $5,000 due to lower than anticipated use. 199,833.00 232,983.00 225,483.00 7,500.00 3.22% - Fay. Info Tech Operations due to lower than anticipated use. 0.00% - $ 3,051,144.00 $ 3,084,294.00 $ 2,956,794.00 $ 127,500.00 4.13% $ 5,310,956.00 $ 5,347,632.00 $ 5,025,132.00 3 322,500.00 6.03% 34
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT ------------ ----------- --------- --------_ ------ EXPLANATION OF SIGNIFICANT VARIANCES $ 2,384,376.00 $ 2,384,376.00 $ 2,344.376.00 526,386.00 530,307.21 585,307.21 254,844.00 272,816.00 255,316.00 $ 3,165,608.00 $ 3,187,499.21 $ 3,184,999.21 $ 40.000,00 1.68% - Fav. due to turnover and underfilled positions/vacancies. (55,000.00) -10.37% - Unfav. Defense Attorney Fees ($70,000) due to an increase in requests for appointed counsel as well as judges having specialty court for which a Public Defender is required to attend the team meetings twice monthly. Partially offset by fav. Electrical Service $15,000 due to lower than anticipated use. 17,500.00 6.41% - Fay. Info Tech Operations $12,500 and Equipment Rental $5,000 due to lower than anticipated use. 2,500.00 0.08% Division 4 - Troy Personnel Expenditures Operating Expenditures Internal Support Expenditures Department Total Personnel Expenditures $ 13,218,171.00 $ 13,218,171.00 $ 12,688,171.00 $ Operating Expenditures 2,623,423.00 2,627,342.21 2,559,542.21 Internal Support Expenditures 1,626,578.00 1,747,175.00 1,694,675.00 Transfers Out - 530,000.00 67,800.00 52,500.00 4.01% 2.58% 3.00% $ 17,468,272.00 $ 17,592,688.21 $ 16,942,388.21 $ 650.300.00 3.70% 35
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES PROBATE COURT AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Judicial/Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out *AO $ 2,399,017.00 $ 2,399,017.00 $ 2,249,017.00 $ 150,000.00 29,481.00 29,481.00 26,981.00 2,500.00 284,930.00 291,285.00 286,285.00 5,000.00 6.25% Fay. due to turnover and undernlied positions/vacancies. 8.48% Fay. Library Continuations $7,000; Court Reporter Services $3,000; Membership Dues $2,500 due to lower than anticipated use. Partially offset by unfav. Visiting Judges ($10,000) due to an extended leave of absence by current sitting judge, 1.72% Fav. Info Tech Operations due to less than anticipated use. Estates/Mental Health Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 2,713,428.00 $ 2,719,783.00 $ 2,562,283.00 $ 157,500.00 5.79% $ 2,293,622.00 $ 2,293,622.00 $ 2,093,622.00 $ 200,000.00 8.72% Fav. due to turnover and uncierfilled positions/vacancies. 781,943.00 781,943,00 826,943.00 (45,000.00) -5.75% Unfav. Fees Guardian Ad Litem ($20,000); Medical Services Probate Exam ($20,000); Medical Services Guardianship ($15,000); and Defense Attorney Fees ($10,000) due to an increased number of case filings and continued high demand for these services. Partially offset by fay. Printing $10,000 and Expendable Equipment $10,000 due to lower than anticipated use. 633,270.00 664,685.00 574,685.00 90,000.00 13.54% Fay. Equipment Rental $50,000 based on actual usage, Fav. Info Tech Operations $40,000 due to less than anticipated use. $ 3,708,835.00 $ 3,740,250.00 $ 3,495,250.00 $ 245,000.00 6.55% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out $ 4,692,639.00 $ 4,692,639.00 $ 4,342,639.00 $ 811,424.00 811,424.00 853,924.00 918,200.00 955,970.00 860,970.00 350,000.00 (42,500.00) 95,000.00 7.46% -5.24% 9.94% $ 6,422,263.00 $ 6,460,033.00 $ 6.057,533.00 $ 402,500.00 6.23% 36
33,296.00 112,538.00 975,027.00 33,296.00 112,538.00 975,027.00 COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 2,354,441.00 $ 2,354,441.00 $ 2,324,441,00 $ 30,000.00 1.27% Fay, due to vacant and underfilled positions. 515,213.00 55,000.00 1,927,857.00 105,000.00 Operating Expenditures Internal Support Expenditures Transfers 515,213.00 460,213.00 1,987,985.00 1,882,985.00 67,000.00 67,000.00 10.68% Fay. Printing $30,000, Witness Fees and Mileage $25,000, Training $14,200, Filing Fees $14,000, Travel & Conference $12,000, Professional Services $9,000, Security Supplies $5,000 and Metered Postage $5,000 due to less than anticipated use; partially offset by unfav. Library Continuations ($60,000) due to usage. 5.28% Fay. Info Tech Operations $77,000 and Motor Pool $17,000 due to less than anticipated use. Also, fay. insurance Fund $11,000 due to less expected costs. 0.00% Litigation Personnel Expenditures $ 4.797,511.00 $ 4,924,639.00 $ 4,734,639.00 $ 190,000.00 $ 10,603,067.00 $ 10,603,067.00 $ 9,893,067.00 $ 710,000.00 3.86% 6.70% Fay. due to uncles-filled and vacant positions as well as positions assigned to this division but working across divisional disciplines. Operating Expenditures Internal Support Expenditures Transfers Out 27,296.00 6,000.00 18.02% Fay. Personal Mileage $7,000 due to less than anticipated use; partially offset by unfav. Clothing Allowance ($1,000) due to increased use. 109,538.00 3,000.00 2.67% Pay. primarily Insurance Fund due to less expected costs. 775,027.00 200,000.00 20.51% Fay. due to lower Cooperative Reimbursement Prosecutor grant match. Warrants Personnel Expenditures $ 11,723,928.00 $ 11,723,928.00 $ 10,804,928.00 $ 919,000.00 7.84% $ 2,248,109.00 $ 2,248,109.00 $ 2,103,109.00 $ 145,000.00 6.45% Fay. due to turnover, underfilled positions and positions assigned to this division but actually working across divisional disciplines. Operating Expenditures 3,199.00 3,199.00 3,199.00 0.00% 37
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 7,000.00 152,000.00 115,000.00 5,000.00 5,000.00 Internal Support Expenditures Appellate Personnel Expenditures Operating Expenditures Internal Support Expenditures 24,081.00 24,081.00 17,081.00 $ 2,275,389.00 $ 2,275,389.00 $ 2,123,389.00 $ $ 1,891,047.00 $ 1,891.047.00 $ 1,776,047.00 $ 8,458.00 8,458.00 3,458.00 17,737.00 17,737.00 12,737,00 29.07% Fay. primarily Insurance Fund due to less expected costs. 6.68% 6.08% Fay. due to turnover, underfilled positions and positions assigned to this division but actually working across divisional disciplines. 59.12% Fay. Primarily Personal Mileage due to less than anticipated use. 28.19% Fay. primarily Insurance Fund due to less expected costs. $ 1,917,242.00 $ 1,917,242.00 $ 1,792,242.00 $ 125,000.00 6.52% Department Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 17,096.664.00 $ 17,096.664.00 560,166.00 560,166.00 2,082,213.00 2,142,341.00 975,027.00 1,042,027.00 $ 16,096,664.00 $ 1,000,000,00 494,166.00 66,000.00 2,022,341.00 120,000.00 842,027.00 200,000.00 5.85% 11.78% 5.60% 19.19% $ 20,714,070.00 $ 20,841,198.00 $ 19,455,198.00 $ 1,386,000.00 6.65% 38
75,736.00 75,236.00 73,236.00 2,000.00 2.66% Fay. Office Supplies $17,000, Contracted Services $11,000, Personal Mileage $2,000 and Workshops and Meetings $1,500 due to less than anticipated use. Partially offset by unfav. Communications ($30,000) due to usage. (54,700.00) -8.49% 699,029.00 844,329.00 644,019.00 Unfav. Info Tech Ops ($39,100) offset in Corrective Services division. Also unfav. Motor Pool ($14,700) and Info Tech Managed Print Svcs ($3,400) due to usage; partially offset by Fay. Telephone Communications $2,300 due to less than anticipated use. (73,800.00) -93.91% 78,585.00 152,385.00 78,585.00 0.00% 185.00 185.00 $ 4,095,881.00 $ 4,119,738.86 $ 3,933,538.86 $ 186,200.00 4.52% $ 2,324,558.00 $ 2,324,558.00 $ 2,124,558.00 200,000.00 8,60% Fay, due to vacancies, turnover and underfills; offset in other divisions. 1,692,738.00 1,716,410.86 1,656,410.85 60,000.00 3.50% Fay. Office Supplies $30,000 Uniform Cleaning $20,000, Printing $20,000 and Indigent Orders $10,000 due to less than anticipated use; partially offset by unfav. Travel and Conference ($16,000) and Membership Dues ($5,000) due to usage. Unfav. Info Tech Ops ($73,600) offset in Corrective Services division. Also unfav. Info Tech Managed Print Svcs ($7,400) due to usage; partially offset by fay. Telephone Communications $5,500 and Radio Communications $1,600 due to less than anticipated use. $ 1,858,505.00 $ 1,858,505.00 $ 1,758,505.00 $ 100,000.00 5.38% Fay. due to vacancies and turnover; offset in other divisions. 0.00% 8 2,578,260.00 $ 2,578,070.00 $ 2,530,770.00 $ 47,300.00 1.83% 31,674,994.00 $ 31,674,994.00 $ 30,574,994.00 1,100,000.00 3.47% Fay. Salaries and Fringe Benefits $3,330,000 as a result of a large number of vacancies, officers in the academy and officers in training; partially offset by unfav. Overtime ($2,215,000). Hiring, training and filling-in for deputies is the major factor contributing to the use of overtime; offset in other divisions. Sheriffs Office Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Administrative Services Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Corrective Services Personnel Expenditures COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES SHERIFFS OFFICE ADOPTED BUDGET AMENDED BUDGET FY 2018 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 7.50% Fay. Contracted Services $400,000 due to food and clinic contracts, Prisoner Housing Outside of County $85,000, Laundry and Cleaning $24,000, Other Expendable Equipment $15,000, Transportation of Prisoners $14,000, Drug Testing $12,000, Bedding and Linen $10,000,Computer Supplies $10,000, Culinary Supplies $10,000, Equipment Maintenance $10,000 and Provisions $10,000 due to less than anticipated use. Operating Expenditures 7,741,746.00 8,000,059.34 7,400,059.34 600,000.00 39
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE ADOPTED BUDGET AMENDED BUDGET AMOUNT FY 2018 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES nn 4.1 1...............,......nn•nn•••••n•••nn••••n•• ,•nn•nn,.n •••nn • .0 ry.1•n••••nn•••nnnnn•••n••••••.77,71....... Internal Support Expenditures 7,968,097.00 8,304,371.00 7,515,371.00 789,000.00 9.50% Fav. info Tech Ops $836,000 partially offset in other divisions; favorability partially offset by unfav. Motor Pool ($26,100) and Radio Communications ($20,600) due to usage. Transfers Out 0.00% Corrective Services-Satellites Personnel Expenditures $ 47,384,837.00 $ 47,979,424.34 $ 45,490,424.34 $ 2,489,000.00 5.19% $ 13,734,940.00 $ 13,769,081.00 $ 17,269,081.00 $ (3,500,000.00) -25.42% Unfav. primarily due to Overtime ($2,000,000) at the Corrective Services Satellite facilities caused by circuit court security, vacant positions, prisoner transport, employee disability and other leaves. Also unfav. Salaries ($650,000) due to multifilled Part-Time Non-Eligible positions and unfav. Fringe Benefits ($900,000) related to overtime. Hiring, training and retaining Corrections Deputies and filling-in for deputies on disability has been a major factor contributing to the high use of overtime. Operating Expenditures Internal Support Expenditures Transfers Out 126,494.00 1,275,010.00 128,778.00 1,282,069.00 12,800.00 86,778.00 1,344,569.00 12,800.00 42,000.00 32.61% Fav. Uniforms $17,000, Laundry and Cleaning $15,000 due to less than anticipated use and Equipment Maintenance $10,000 due to recent equipment replacement (62,500.00) -4.87% Unfav. Info Tech Ops ($75,600) offset in Corrective Services division; unfavorability partially offset by fay. Motor Pool Fuel Charges $8,000 and Motor Pool $4,700 due to less than anticipated use. 0.00% $ 15,136,444.00 $ 15,192,728.00 $ 18,713,228.00 $ (3,520,500.00) -23.17% Emergency Response and Preparedness Personnel Expenditures $ 2,373,876.00 $ 2,412,860.00 $ 2,367,860.00 $ 45,000.00 1.87% Fay. Due to vacancy and underfills; offset in other divisions. Operating Expenditures 623,457.00 623,457.00 393,457.00 230,000.00 36.89% Fay. Fees Civil Service $200,000 due to continuing decline in the number of home foreclosures and civil service requests (see corresponding unfavorability in Civil Action Service Fee revenues) and Employees Medical Exams $30,000 due to less than anticipated use. 40
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Internal Support Expenditures Transfers Out Patrol Services Personnel Expenditures •••••.•nn••••, •••••,•n•nn•n•••n•••n••n•••n 158,657.00 (44,500.00) -38.98% 0.00% $ 3,087,711.00 $ 3,150,474.00 $ 2,919,974.00 $ 230,500.00 7.32% Unfav. Info Tech Ops ($17,000) offset in Corrective Services division. Also unfav. Info Tech Managed Print Svcs ($15,500) and Telephone Communications ($14,000) due to usage: partially offset by fay. Radio Communications $2,000 due to less than anticipated use. 90,378.00 114,157.00 $51,496,688 $ 52,294,667.00 $ 50,994,667.00 $ 1,300,000.00 2.49% Fav. due to Salaries and Fringe Benefits as a result of vacancies and turnover; offset in other divisions. Operating Expenditures 979,054.00 1,024,019.00 814,019.00 210,000.00 20.51% Fav. Uniforms $60,000, Equipment Maintenance $60,000, Equipment Rental $43,000, Officers Training $15,000, North Oakland Sub-Station $10,000, Gasoline Charges $9,000, Electrical Service $7,000 and Office Supplies $6,000 due to less than anticipated use. Internal Support Expenditures 5,284,973.00 5,524,425.00 5,926,025.00 (401,600.00) -7.27% Unfav. Info Tech Ops ($270,200) offset in Corrective Services division. Also unfav. Motor Pool ($136,100), Equipment Rental ($18,500) Motor Pool Fuel Charges ($17,900) and Telephone Communications ($8,100) due to usage: partially offset by fay. Info Tech CLEM1S $29,000, Radio Communications $19,800 due to less than anticipated use. Transfers Out 788.00 340,620.00 340,620.00 0.00% $ 57,761,503.00 $ 59,183,731.00 $ 58,075,331.00 $ 1,108,400.00 1.87% Emergency Communications Operations Personnel Expenditures $ 7,995,971.00 $ 8,187,274.00 $ 9,187,274.00 $ (1,000,000.00) -12.21% Unfav. due to Overtime and associated Fringe Benefits from vacant positions and turnover. Operating Expenditures 160,215.00 243,469.00 123,469.00 120,000.00 49.29% Fav. Equipment Maintenance $50,000 due to recent equipment replacement Also fav. Professional Services $50,000, Contracted Services $20,000 and Uniforms $6,000 due to less than anticipated use. Partially offset by Unfav. Office Supplies ($3,000) due to usage. Internal Support Expenditures 148,159.00 148,159.00 182,259.00 (34,100.00) -23.02% Unfav. Info Tech Ops ($48,000) offset in Corrective Services division. Also unfav. Radio Communications ($2,600) due to usage; partially offset by fay. Telephone Communications $8,600 and Info Tech Managed Print Services $8,000 due to less than anticipated use. Transfers Out 0.00% $ 8,304,345.00 $ 8,578,902.00 $ 9,493,002.00 $ (914,100.00) -10.66% 41
$ 12,841,756,00 $ 13,260,620.06 $ 13,277,820.06 $ (17,200.00) -0.13% $ 120,559,056.00 $ 121,621,463,00 $ 123,321,463.00 $ (1,700,000.00) -1.40% $ 12,164,322.00 $ 12,715,90326 $ 11,351,903.26 $ 1,364,000.00 10.73% $ 18,132,485.00 $ 18,750,693.00 $ 18,805,093.00 $ (54,400.00) -0.29% $ 334,874.00 955,629.00 $ 955,629.00 $ 0.00% $ 151,190,737.00 $ 154,043,68826 $ 154,434,088.26 $ (390,400.00) -0,25% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT ADOPTED AMENDED FY MS FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Investigative/Forensic Svcs Personnel Expenditures $ 9,099,524.00 $ 9,099,524.00 $ 9,044,524.00 $ 55,000.00 0.60% Fav. Salaries and Fringe Benefits $205,000 due to unfilled positions. Partially offset by unfav. Overtime ($150,000) due to workload and vacant positions. Operating Expenditures 764,882.00 904,474.06 804,474.06 100,000.00 11.06% Fav. Contracted Services $70,000, Evidence Fund NET $60,000, Software Support Maintenance $20,000, Equipment Rental $12,000, Extradition Expense $10,000, Fingerprint Supplies $10,000 and Drug Testing $6,000 due to less than anticipated use; partially offset by unfav. Material and Supplies ($45,000) used in RESULTS testing and offset in Drug Testing revenue, and Laboratory Supplies ($40,000) due to usage. Internal Support Expenditures 2,643,264.00 2,654,598.00 2,826,798.00 (172,200.00) -6.49% Unfav. info Tech Operations ($263,800) offset in Corrective Services division; unfavorability partially offset by Fav. Motor Pool $63,500, Motor Pool Fuel charges $19,100, and Info Tech Managed Print Services $9,800 due to less than anticipated use. Transfers Out 334,086.00 602,024.00 602,024.00 0.00%
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES CLERIC/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 800,086.00 $ 800,086.00 $ 596,686.00 $ 203,400.00 25.42% Fay, due to vacant position. 34,900.00 34,900.00 24,200.00 10,700.00 30.66% Fay. Printing $4,900, Office Supplies $4,000, Expendable Equipment $1,000 and Printing County Directory $1,000 due to less than anticipated use. 60,359.00 60,359.00 63,259.00 (2,900.00) -4.80% Unfav. Insurance Fund ($3,800) due to actual use; partially offset by favorable Info Tech Operations $1,400 due less expected costs. 0.00% $ 895,345.00 $ 895,345.00 $ 684,145.00 $ 211,200.00 23.59% Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out County Clerk (Vital Stets & Legal Rec's) Personnel Expenditures $ 3,652,076.00 $ 3,652,076.00 $ 3,137,776.00 $ 514,300.00 14.08% Fay. due to vacancies, turnover and underfilled positions. Operating Expenditures 279,160.00 279,160.00 181,660.00 97,500.00 34.93% Fav. Professional Services $34,500 and Office Supplies $20,600 due to less than anticipated use. Also favorable Court Transcripts $30,700 due to prosecutors ordering fewer transcripts; Printing $4,700, Personal Mileage $4,700, Membership Dues $3,100, Expendable Equipment $3,600 and Equipment Maintenance $2,300 due to less than anticipated use. Partially offset by unfavorable Metered Postage ($10,600) due to increased rates and activity. Internal Support Expenditures 698,799.00 947,068.00 887,468.00 59,600.00 6.29% Fav. Info Tech Operations $56,200 due to actual use and Insurance Fund $3,300 due to less expected costs. Transfers Out 0.00% $ 4,630,035.00 $ 4,878,304.00 $ 4,206,904.00 $ 671,400.00 13.76% 43
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Elections Personnel Expenditures Operating Expenditures Transfers Out $ 871,829.00 $ 871,829.00 $ 748,729.00 $ 123,100.00 779,078.00 779,078.00 689,178.00 89,900.00 310,250.00 282,150,00 28,100.00 14.12% Fay, due to turnover and underfilled positions. 11.54% Fay. Professional Services $44,500, Fees - Per Diem $35,400, Materials and Supplies $4,500, Travel and Conference $3,100 due to less than anticipated use. 9.06% Fay. Telephone Communications $23,200 and Info Tech Operations $5,300 due to usage. 15.31% Fay. due to vacancies, turnover and unclerfilled positions. 42.80% Fay. Metered Postage $34,800, Materials and Supplies $27,300, Office Supplies $25,500, Professional Services $24,000, Expendable Equipment $6,000, Equipment Maintenance $4,000, and Printing $2,800 due to less than anticipated use. Partially offset by Maintenance Contract ($9,700) due to increased activity. Internal Support Expenditures 294,662.00 Register of Deeds (and Micrographics) Personnel Expenditures $ 2,664,429.00 $ 2,664,429.00 $ 2,256,429.00 $ 408,000.00 Operating Expenditures 271,494.00 271,494.00 $ 155,294.00 116,200.00 0.00% $ 1,945,569.00 $ 1,961,157.00 $ 1,720,057.00 $ 241,100.00 12.29% Internal Support Expenditures 259,611.00 268,001.00 $ 272,301.00 (4,300.00) -1.60% Unfav. Primarily due to Info Tech Operations ($4,000) due to usage. Transfers Out 0.00% $ 3,195,534.00 $ 3,203,924.00 $ 2,684,024.00 $ 519,900.00 16.23% 44
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Jury Commission Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 15,383.00 $ 68,776.00 64.00 15,383.00 $ 6,783.00 $ 8,600.00 68,776.00 49,076.00 19,700.00 171.00 171.00 55.91% Fay, due to underfilled position. 28.64% Fay. Metered Postage $16,700 and Printing $2,000 and due to less than anticipated use. 0.00% $ 84,223.00 $ 84,330.00 $ 56,030.00 $ 28,300.00 33.56% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 8,003,803.00 $ 1,433,408.00 1,313,495.00 8,003,803.00 $ 6,746,403.00 1,433,408.00 1,099,408.00 1,585,849.00 1,505,349.00 $ 1,257,400.00 $ 334,000.00 $ 80,500.00 15.71% 23.30% 5.08% 0.00% $ 10,750,706.00 $ 11,023,060.00 $ 9,351,160.00 $ 1,671,900.00 15.17% 45
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES COUNTY TREASURER AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 3,443,735.00 $ 3,443,735.00 $ 3,231,635.00 $ 212,100.00 6,16% - Fay. due to turnover. undertills and vacant positions. Operating Expenditures 4,512,105.00 4,512,105.00 3,719,205.00 792,900.00 17.57% - Fav. Title Search $913,850, Foreclosure Notification $56,600, Fees Civil Service $32,000, Printing $13,000, Office Supplies $10,000, Twp & City Treas Bonds $7,300, Computer Supplies $7,400 and Metered Postage $5,600, due to less than anticipated use. Partially offset by unfavorable Recording Fee Redemption Certificate ($120,000) due to properties withdrawing from foreclosure and Recording Fee-Forfeiture Cert ($110,000) due to properties entering second year of delinquency. Also, unfavorable Recording Fees ($14,000) and Register of Deeds ($9,400) due to an increase in statutory fees for recording deeds (PA 224 of 2016). Internal Support Expenditures 777,694.00 1,012,544.00 951,444.00 61,100.00 6.03% - Fay. due to Info Tech Operations $48,900 and Info Tech Managed Print Services $2,000 due to less than anticipated use. Also, favorable Insurance Fund $8,500 due to less expected costs. Transfers Out 120,000.00 120,000.00 115,000.00 5,000.00 4.17% Fav. Due to lower demolition costs on foreclosed properties. Division Total $ 8,853,534.00 $ 9,088,384.00 $ 8,017,284.00 $ 1,071,100.00 11.79% Department Total $ 8,853,534.00 $ 9,088,384.00 $ 8,017,284.00 $ 1,071,100.00 11.79% 46
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES BOARD OF COMMISSIONERS AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 2,264,759.00 $2,264,759.00 $ 2,249,759.00 $ 15,000.00 0.66% - Favorable due to vacancy, turnover, and undertilled positions. Operating Expenditures 614,190.00 1,190,806.00 $ 1,142,306.00 Internal Support Expenditures 214,137.00 282,871.00 $ 286,371.00 48,500.00 4.07% - Favorable Workshops and Meeting $15,000, Personal Mileage $10,000, Legal Services $7,000, Legislative Expense $6,000, Professional Services-Annual Audit $6,000, Printing $3,000 and Membership Dues $1,500 due to less than anticipated use. (3,500.00) -1.24% - Unfavorable Telephone Communications due to increased use. $ 3,093,086.00 $ 3,738,436.00 $ 3,678,436.00 $ 60,000.00 1.60% Department Total Personnel Expenditures $ 2,264,759.00 $ 2,264,759.00 $ 2,249,759.00 $ 15,000.00 0.66% Operating Expenditures 614,190.00 1,190,806.00 1,142,306.00 48,500.00 4.07% Internal Support Expenditures 214,137.00 282,871.00 286,371.00 (3,500.00) -1.24% $ 3,093,086.00 $ 3,738,436.00 $ 3,678,436.00 $ 60,000.00 1.60% 47
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES LIBRARY BOARD AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES •••••,....nn•n Library Board Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 510,599.00 $ 510,599.00 5 504,599.00 $ 6,000.00 383,333.00 383,333.00 383,333.00 474,669.00 501,703.00 501,703.00 1.18% 0.00% 0.00% Favorable due to employee on leave. Transfers $ 1,368,601.00 $ 1,395,635.00 $ 1,389,635,00 $ 6,000.00 0.43% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 510,599.00 $ 510,599.00 5 504,599.00 $ 383,333.00 383,333.00 383,333.00 474,669.00 501,703.00 501,703.00 6,000.00 1.18% 0.00% 0.00% $ 1,368,601.00 $ 1,395,635.00 $ 1,389,635.00 $ 6,000,00 0.43% 48
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES WATER RESOURCES COMMISSIONER AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Water Resource Commissioner Personnel Expenditures $ 224,606.00 $ 224,606.00 $ 224,606.00 $ 0,00% Operating Expenditures 487,975.00 457,975.00 409,410.00 78,565.00 16.10% Fay - Contracted Services $30,000 due to decreased spending on Soil Erosion corrective action issues. Fay - Legal Services $20,000 due to spending less on legal issues to enforce the laws of the soil erosion program. Fay - Professional Services $10,000 due to less spending on these services related to soil erosion and environmental issues. Fay - Education Programs $10,000 due to reduced spending for Soil Erosion education programs to inform the public on the usage of soil erosion products. Fay - Materials and Supplies $5,000 and Printing $2,000 the result of less demand for these items. Fay - Training $3,000 based on less spending for hazardous material training. Fay - Workshops and Meeting $3,000 based on required needs to maintain knowledge of drain and water issues. Fay - Publishing Legal Notices $1,000 due to a decrease in work that requires public notice. Fay - Laboratory Fees $1,000 Environmental Unit was able to charge water samples directly to various systems. Fay - Equipment Rental $1,000 due to a decrease in specialty equipment needed for projects that doesn't pertain to any assignable drain, lake, water or sewer system. Unfav - Uniforms ($5,000) Soil Erosion spending for need of jackets, overalls and logo patches. Unfav - Travel and Conference ($2,000) the result of seminars to keep employees current on Michigan's Department of Environmental Quality regulations. Internal Support Expenditures 5,970,144.00 6,227,717.00 6,232,117.00 (4,400.00) -0.07% Unfav - Info Tech Operations ($60,000) and Telephone Communications ($3,000) the result of actual spending being more than anticipated budget Unfav - Drain Equipment ($40,000) due to employee's associated equipment that can not be charged to other funds; offset by favorable charges for Service Revenue. Unfav - Insurance Fund ($1,200) due to an increase in the number of random drug tests. Pay - Drain Equipment Labor $100,000based on less than anticipated Drain Equipment labor charged to the General Fund; offset by less charges for Services Revenue. Transfers 56,165.00 87,685.00 87,685.00 0.00% 49
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES WATER RESOURCES COMMISSIONER AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Division Total $ 6,738,890.00 $ 7,027,983.00 $ 6,953,818.00 $ 74,165.00 1.06% Department Total $ 6,738,890.00 $ 7,027,983.00 $ 6,953,818.00 $ 74,165.00 1.06% 50
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES COUNTY EXECUTIVE AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 25,000.00 1.10% Fay. due to vacancies and underfilled positions. 3,200.00 1.15% Fay. Printing $17,000, Metered Postage $7,000 and Personal Mileage $3,000 due to less than anticipated use; partially offset by unfavorable Professional Services ($12,000), Special Projects ($8,000), Library Continuations ($2,000) and Periodicals Books Publ Sub ($1,800) due to increased activity. 0.00% 28,200.00 0.94% 15,000.00 0.88% Fav. Salaries and Fringe Benefits due to vacancies, turnover, and underfilled positions. Administration Personnel Expenditures $ 2,278,720.00 $ 2,278,720.00 2,253,720.00 $ Operating Expenditures 277,991.00 277,991.00 274,791.00 Internal Support Expenditures 431,227.00 458,720.00 458,720.00 ••n••• $ 2,987,938.00 $ 3,015,431.00 $ 2,987,231.00 $ Compliance Office Personnel Expenditures $ 1,700,887.00 $ 1,700,887.00 $ 1,685,887.00 $ Operating Expenditures 49,252.00 49,252.00 41,252.00 8,000.00 16.24% Fay. Professional Services $10,000 due to less than anticipated use; partially offset by Software Rental Lease Purchase ($2,000) due to increased activity. Internal Support Expenditures 185,071.00 210,243.00 210,243.00 0.00% 23,000.00 1.17% (20,000.00) $ 1,935,210.00 $ 1,960,382.00 $ 1,937,382.00 $ $ 2,532,551.00 $ 2,532,551.00 $ 2,552,551.00 $ -0.79% Unfav. Due to Overfills and Position #4739 Summer Position that is being charged to the division, but not budgeted. This is offset in Personnel Expenditures in other County Exec Divisions. Corporation Counsel Personnel Expenditures 51
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES COUNTY EXECUTIVE AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Operating Expenditures 87,333.00 87,333.00 85,333.00 2,000.00 2.29% Fay, Computer Supplies due to less than anticipated use. Internal Support Expenditures 353,820,00 368,779.00 368,779.00 0.00% $ 2,973,704.00 $ 2,988,663.00 $ 3,006,663.00 $ Department Total Personnel Expenditures $ 6,512,158.00 $ 6,512,158.00 $ 6,492,158.00 $ Operating Expenditures 414,576.00 $ 414,576.00 401,376.00 Internal Support Expenditures 970,118.00 1,037,742.00 1,037,742.00 Transfers Out - - - $ 7,896,852.00 $ 7,964,476.00 $ 7,931,276.00 $ (18,000.00) -0.60% 20,000.00 0.31% 13,200.00 3.18% 0.00% 33,200.00 0.42% 52
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 231,432.00 $ 231,432.00 $ 231,432.00 $ 0.00% Operating Expenditures 4,017.00 4,017.00 4,017.00 0.00% Internal Support Expenditures 14,704.00 14,704.00 14,704.00 0.00% $ 250,153.00 $ 250,153.00 5 250,153_00 $ 0.00% Equalization Personnel Expenditures $ 8,714,164.00 $ 8,714,164.00 $ 8,264,164.00 $ 450,000.00 5.16% Fay. due to vacancies and underfilled positions. Operating Expenditures 431,404.00 453,125,46 361,125.46 92,000.00 20.30% Fay. Personal Mileage $30,000; Professional Services $29,000; Printing $20,000; Office Supplies $15,000; and Membership Dues $9,000 due to less than anticipated activity. Partially offset by unfav. Expendable Equipment ($11,000) due to greater than anticipated activity. Internal Support Expenditures 939,266.00 1,160,731.00 1,130,731.00 30,000.00 2.58% Fay. primarily Info Tech Operations due to usage. $10,084,834.00 $10,328,020.46 $ 9,756,020.46 $ 572,000.00 5.54% Fiscal Services Personnel Expenditures $ 8,265,954.00 $ 8,265,954_00 $ 7,615,954.00 $ 650,000.00 7.86% Fav. due to vacancies and underfilled positions. Operating Expenditures 383,600.00 383,600.00 342,100.00 $ 41,500.00 10.82% Fay. Metered Postage $25,000; Professional Services $20,000; and Office Supplies $7,500 due to less than anticipated use. Partially offset by unfav. Expendable Equipment ($11,000) due to greater than anticipated use. Internal Support Expenditures 1,314,860.00 1,678,137.00 1,648,137.00 $ 30,000.00 1.79% Fav. primarily Info Tech Operations due to usage. $ 9,964,414.00 $ 10,327,691.00 $ 9,606,191.00 $ 721,500.00 6.99% 53
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Department Total Personnel Expenditures $ 17,211,550.00 $ 17,211,550.00 $ 16,111,550.00 $ Operating Expenditures 819,021.00 840,742.46 707,242.46 Internal Support Expenditures 2,268,830.00 2,853,572.00 2,793,572.00 Transfers Out 1,100,000.00 6.39% 133,500.00 15.88% 60,000.00 2.10% 0.00% $ 20,299,401.00 $ 20,905,864.46 $ 19,612,364.46 $ 1,293,500.00 6.19% 54
Administrative Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 231,349.00 $ 3,298.00 13,941.00 231,349,00 $ 3,298.00 14,375.00 231,349.00 $ 3,298.00 14,375.00 $ 248,588.00 $ 249,022.00 $ 249,022.00 5 COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES CENTRAL SERVICES AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ------- ------ •n••n•••n•nn•••n - --- ----- ------ Support Services Personnel Expenditures $ 1,250,374.00 $ 1,250,374.00 $ 1,197,974.00 $ 52,400.00 4.19% Fay. Due to turnovers and vacancies 2,600.00 0.41% Fay. Equipment $12,600 due to less than anticipated cost of new mail sorter. Partially offset by unfavorable Office Supplies ($7,200) due to need for additional supplies, Other Expendable Equipment ($5,000) due to compressor for mail sorter not part of initial quote. 0.00% 0.00% 0.00% 0.00% Operating Expenditures 396,895.00 636,495.00 633,895.00 Internal Support Expenditures 769,580.00 790,044.00 $ 790,044.00 0.00% Transfers Out 0.00% $ 2,416,849.00 5 2,676,913.00 $ 2,621,913.00 $ 55,000.00 2.05% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out 5 1,481,723.00 5 1,481,723.00 $ 1,429,323.00 $ 400,193.00 639,793.00 637,193.00 783,521.00 804,419.00 804,419.00 52,400.00 2.600.00 3.54% 0.41% 0,00% 0.00% $ 2,665,437.00 $ 2,925,935.00 $ 2,870,935.00 $ 55,000.00 1.88% 55
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES FACILITIES MANAGEMENT AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 213,673.00 $ 213,673.00 $ 213,673.00 $ 0.00% Operating Expenditures Internal Support Expenditures Facilities Engineering Personnel Expenditures 5,754.00 5,764.00 3,764.00 2,000.00 34.70% Fay. Printing $800; Personal Mileage $600; Periodicals Books Publ Sub $500; Travel and Conference $500 and Office Supplies $400 due to continued efforts to minimize expenses and contain costs. Partially offset by unfav. Membership Dues ($800) as a result of more than anticipated usage. 11,271.00 11,271.00 11,271.00 0.00% $ 230,708.00 $ 230,708.00 $ 228,708.00 $ 2,000.00 0.87% $ 865,777.00 $ 865,777.00 $ 860,777.00 $ 5,000.00 0.58% Fay. due to turnover. Operating Expenditures 225,182.00 232,149,00 222,149.00 10,000.00 4.31% Fav. Professional Services due to less than anticipated preliminary costs for future projects. Internal Support Expenditures 53,257.00 75,226.00 75,226.00 0.00% $1,144,216.00 $1,173,152.00 $ 1,158,152.00 $ 15,000,00 1.28% Department Total Personnel Expenditures $1,079,450.00 $ 1,079,450.00 $ 1,074,450.00 $ 5,000.00 0.46% Operating Expenditures 230,946.00 237,913.00 225,913.00 12,000.00 5.04% Internal Support Expenditures 64,528.00 86,497.00 86,497.00 0.00% $1,374,924,00 $1,403,860.00 $ 1,386,860,00 $ 17,000.00 1.21% 56
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES HUMAN RESOURCES AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures 918,095.00 $ 337,622.00 918,095.00 $ 407,622.00 758,095.00 $ 160,000.00 17.43% Fay. due to vacancy, turnover and Position #1928 Budgeted in Human Resources-Administration but actuals charged to Human Resources Workforce Management (offset in Human Resources Workforce Management). 346,022.00 61,600.00 15.11% Fay. Professional Services $50,000, Fees- Per Diems $7,000, Printing $4,000, Metered Postage $1,500, and Workshops and Meetings $1,000 due to less activity. Partially offset by Travel and Conference ($1,200) and Office Supplies ($700) due to increased usage. Workforce Management Personnel Expenditures 2,758,495.00 $ 3,075,107.00 $ 2,950,207.00 $ 5,000.00 5.78% Fay. Info Tech Operations due to reduced activity. 226,600.00 16.05% -8.90% Unfav. due to turnover and Position #1928 Budgeted in Human Resources-Administration but actuals charged to Human Resources Workforce Management (offset in Human Resources Administration). 203,500.00 37.00% Fay. Professional Services $70,000, Recruitment Expense $60,000, Examination Material $30,000, Psychological Testing $15,000, Employees Medical Examination $14,000, Travel and Conference $8,000, Computer Supplies $2,000, Expendable Equipment $2,000, Periodicals Books Publ Sub $1,500, and Membership Dues $1,000 due to less than anticipated use. 81,400.00 11.19% Fay. Info Tech Operations $70,000, info Tech Managed Print Services $10,000, and Equipment Rental $1,400 due to reduced activity. 124,900.00 4.06% Internal Support Expenditures 76,511.00 86,537.00 81,537.00 Transfers Out 1,332,228.00 $ 1,412,254.00 $ 1,185,654.00 $ Operating Expenditures 377,785.00 550,035.00 346,535.00 Internal Support Expenditures 583,023.00 727,385.00 645,985.00 1,797,587.00 $ 1,797,687.00 $ 1,957,687.00 $ (160,000.00) Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out 2,715,782.00 $ 715,407.00 659,534.00 2,715,782.00 $ 957,657.00 813,922.00 2,715,782.00 $ 692,557.00 727,522.00 265,100.00 86,400.00 0.00% 27.68% 10.62% 4,090,723.00 $ 4,487,361.00 $ 4,135,861.00 $ 351,500.00 7.83% 57
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 190,507.00 $ 190,507.00 $ 190,507.00 $ 0.00% Operating Expenditures 7,491,479.00 7,251,479,00 6,043,479.00 1,208,000.00 16.66% Fay. primarily due to Private Institutions Foster Care $600,000 and Fay. Private Institutions $520,000. Costs are based on caseload, difficulty of care, and treatment of services ordered by the Court. Favorability is partially offset by unfav. Non-Dept. Child Care Subsidy Revenue (50% reimbursement). Internal Support Expenditures 13,091.00 13,091.00 13,091.00 0.00% Transfers Out $ 7,695,077.00 $ 7,455,077.00 $ 6,247,077.00 $ 1,208,000.00 16.20% Health Personnel Expenditures 5 26,730,529.00 $ 26,745,933.00 5 26,095,933,00 $ 650,000.00 2.43% Fay. due to turnover and underfilled positions. 422,700.00 10.65% Fay. Contracted Services $530,000 due to timing of Community Living Program services and delay in Eider Abuse Prevention program as a result of HIPAA regulations. Fay, Professional Services $80,000 due to an increase in individuals enrolled in Medicaid which makes them ineligible for the County's Dental program; and Fay. Software Support Maintenance $52,500 due to less than anticipated use. Favorability partially offset by Unfav. Adjusted Prior Years Revenue ($148,400) due to correction of FY 2017 estimated administrative overhead cost distribution. Unfav. Vaccines ($57,700) due to increased demand for vaccines; Unfav. Drugs ($15,000) due to high costs for TB testing and treatment drugs; and Unfav. Metered Postage ($10,000) and Laboratory Fees ($9,000) due to greater than anticipated activity. 30,000.00 0.89% Fav. Primarily Info Tech Operations due to usage. Operating Expenditures 3,308,063.00 3,967,963.28 3,545,263.28 Internal Support Expenditures 3,023,452.00 3,374,785.00 3,344,785.00 Transfers Out 15,870.00 15,870.00 $ 33,062,044.00 $34,104,551.28 $ 33,001,851.28 $ 1,102,700.00 3.23% 58
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ----------- ------- NM ----- M NM ----------- --------- ----- ---------- ---------------- -- — Children's Village Personnel Expenditures $ 18,134,919.00 $ 18,134,919.00 $ 18,684,919.00 $ (550,000.00) -3.03% Unfav. primarily due to overtime, Operating Expenditures 3,798,761.00 4,121,974.00 3,960,974.00 161,000.00 3.91% Fay. Provisions $62,000 due to lower food costs and fluctuations in resident population. Fav. Medical Services Physicians $42,000 due to services provided by Oakland Integrated Healthcare Network (OIHN). Fay. Drugs $20,000 and Hospitalization $20,000 due to fewer medical needs along with cost saving initiatives. Also, Fay. Security Supplies $16,000 and Fav. Printing $14,500 due to lower than anticipated use. Favorability partially offset by Unfav. Laundry and Cleaning ($9,000) and Personal Mileage ($5,000) due to higher than anticipated activity. Internal Support Expenditures 2,940,888.00 3,098,950.00 3,058,950.00 40,000.00 1.29% Fay. Primarily Info Tech Operations due to usage. Transfers Out Homeland Security Personnel Expenditures $ 24,874,568.00 $ 25,355,843.00 $ 25,704,843.00 $ $ 903,537.00 $ 903,537.00 $ 893,037.00 $ (349,000.00) -1.38% 10,500.00 1.16% Fay. Salaries $8,000 and Fringes $7,500 due to positon vacancy. Partially offset by Unfav. Overtime ($5,000) due to increased emergency response and training needs. Operating Expenditures 304,866.00 301,095.00 281,595.00 19,500.00 6.48% Fay. Tornado Siren Equipment $12,000 due to the installation of fewer than anticipated sirens and Fay. Equipment Maintenance $10,000 due to limited repair costs incurred on specialtyfhazmat vehicles. Favorability partially offset by Unfav. Maintenance Contracts ($4,000) due to unexpected repairs to a tornado siren damaged in car crash. Internal Support Expenditures 484,459.00 536,452.00 536,452.00 0.00% Transfers Out 4,431.00 4,431.00 -------- ----------- -------------- ------------ $ 1,692,862.00 $ 1,745,515.00 $ 1,715,515.00 $ 30,000.00 59
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES ADOPTED BUDGET AMENDED BUDGET FY 2018 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Department Total Personnel Expenditures $ 45,959,492,00 $ 45,974,896.00 Operating Expenditures 14,903,169.00 15,642,511.28 Internal Support Expenditures 6,461,890.00 7,023,278.00 Transfers Out 20,301.00 ---------- ----- $ 67,324,551.00 $ 68,660,986.28 $ 45,864,396.00 $ 110,500.00 0.24% 13,831,311.28 1,811,200.00 11.58% 5,953,278.00 70,000.00 1.00% 20,301.00 0.00% -------- 66,669,286.28 $ 1,991,700.00 2.90% 60
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ------- --- Public Services Admin. Personnel Expenditures $ 231,432.00 $ 231,432.00 231,432.00 $ 0.00% Operating Expenditures 4,800.00 4,800.00 4,800.00 0,00% Internal Support Expenditures 6,636.00 6,536.00 6,636.00 0.00% $ 242,868.00 $ 242,868.00 $ 242,868.00 $ 0.00% Veterans Services Personnel Expenditures $ 1,705,218.00 $ 1,705,218.00 1,605,218.00 $ 100,000.00 5.86% Fay. Due to vacant and underfilled positions. Operating Expenditures Internal Support Expenditures Transfers Out Community Corrections 31,500.00 16.11% Fay. Soldier Burial $20,000, Soldier Relief $10,000. and Metered Postage $1,500 due to less than anticipated activity, 0.00% 3,886,292.00 $ 180,000.00 4.43% Fav. Due to vacant and underfilled positions. 50,000.00 9.96% Fay. Contracted Services $50,000 due to less than anticipated use. 20,000.00 3.08% Fay. Info Tech Operations $10,000 and Motor Pool $10,000 due to decreased activity. Personnel Expenditures $ 4,066,292.00 $ 4,066,292.00 Operating Expenditures 502,025.00 502,025.00 Internal Support Expenditures 559,672.00 648,609.00 190,912.00 195,477.00 163,977.00 205,840,00 216,081..00 216,081.00 0.00% $ 2,101,970.00 $ 2,116,776.00 $ 1,985,276.00 $ 131,500.00 6,21% 452,025.00 628,609.00 Transfers Out 18 606.00 18,606.00 0.00% - $ 5,127,989.00 $ 5,235,532.00 $ 4,985,532.00 $ 250,000.00 4.78% 61
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES MSU Ext. - Oakland County Personnel Expenditures Operating Expenditures Internal Support Expenditures Medical Examiner Personnel Expenditures 666,420.00 $ 666,420.00 $ 636,420.00 $ 30,000.00 4.50% Fay. Due to underlined positions. 227,239.00 227,239.00 227,239.00 0.00% 290,122.00 294,044.00 289,044.00 5,000.00 1.70% Fay. Info Tech Operations due to decreased activity. $ 1,183,781.00 $ 1,187,703.00 $ 1,152,703.00 $ 35,000.00 2.95% $ 3,521,198.00 $ 3,521,198.00 $ 3,501,198.00 $ 20,000.00 0.57% Fay. Due to undernilecl positions. Operating Expenditures 657,005.00 699,042.00 690,242.00 8,800.00 1.26% Fay. Training $8,300, Freight and Express $2,000, Equipment Rental $1,000, Printing $1,000 and Metered Postage $1,000 due to less than anticipated activity. Partially offset by unfavorable Miscellaneous ($3,200) and Travel and Conference ($1,300) due to increased use. Internal Support Expenditures Transfers Out Animal Control Personnel Expenditures 815,459.00 856,778.00 816,778,00 40,000.00 4.67% Fay. Equipment Rental $30,000 and Information Tech Ops $10,000 due to decreased activity. $ 4,993,663.00 $ 5,077,018.00 $ 5,008,218.00 $ 68,800.00 1.36% $ 2,463,584.00 $ 2,510,334.00 $ 2,500,334.00 $ 10,000.00 0.40% Fay. Due to vacant and underillled positions. Operating Expenditures 280,097.00 379,171.00 379,171.00 0.00% 62
ADOPTED BUDGET — Internal Support Expenditures 1,004,615.00 AMENDED BUDGET 1,105,197.00 FY 2018 FORECAST 1,130,197.00 COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES (25,000,00) -2.26% Unfav. Information Tech Ops ($30,000), Info Tech Equipment Rental ($15,000), and Telephone Communications ($15,000) due to increased activity. Partially offset by Motor Pool/Motor Pool Fuel Charges $35,000 due to decreased activity. Transfers Out $ 3,748,296.00 $ 3,994,702.00 $ 4,009,702.00 $ (15,000.00) -0.38% Circuit Court Probation Personnel Expenditures Operating Expenditures 0.00% 54,328.00 54,326.00 45,826.00 8,500.00 15.65% Fay. Office Supplies $4,500, Metered Postage $2,000, Equipment Maintenance $1,000 and Printing $1,000 due to less than anticipated acivity. InternaI Support Expenditures 584,085.00 592,282.00 588,282.00 4,000.00 0.68% Fay. Info Tech Operations $3,000 and Info Tech Managed Print Services $1,000 due to less than anticipated activity. $ 638,411.00 $ 646,608.00 $ 634,108.00 $ 12,500.00 1.93% Department Total PersonneI Expenditures $ 12,654,144.00 $ 12,700,894.00 Operating Expenditures 1,916,405.00 2,062,080.00 Internal Support Expenditures 3,456,429.00 3,719,627.00 Transfers Out 18,606.00 $ 12,360,894.00 $ 340,000.00 2.68% 1,963,280.00 98,800.00 4.79% 3,675,627.00 44,000.00 1.18% 18,606.00 $ 18,036,978.00 $ 18,501,207.00 $ 18,018,407.00 $ 482,800.00 2.61% 63
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST :UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures $ 1,428,170.00 $ 1,447,238.00 $ 1,447,238.00 $ 0.00% 442,222.00 485,594.00 449,694.00 35,900.00 7.39% Fay. Special Event Supplies $42,000; Professional Services $10,500; Printing $9,000; Travel and Conferences $9,000; Personal Mileage $7,900; and Periodicals Books Publ Sub $3,800 due to less than anticipated activity. Partially offset by Unfav. Advertising ($43,300) and Business Recruitment ($4,000) due to higher than anticipated activity. Internal Support Expenditures 53,333.00 74,425.00 74,425.00 0.00% Transfers $ 1,923,725.00 $ 2,007,257.00 $ 1,971,357.00 $ 35,900.00 1.79% Planning and Economic Development Services Personnel Expenditures $ 4,186,824.00 $ 4,167,756.00 $ 3,945.456.00 $ 222,300.00 5.33% Operating Expenditures 1,395,509.00 1,623,069.00 1,303,069.00 320,000.00 19.72% Fay. due to vacancies and underfilled positions. Fay. Professional Services $228,500 due to timing of the NO HAZ and Connected Vehicle Task Force Programs. Fay. Business Recruitment $58,000 due to lower than anticipated costs subsequent to budget Fav. Printing $50,000; Drafting Supplies and Maps $12,000; and Travel and Conferences $8,000 and due to less than anticipated activity. Partially offset by Unfav. Advertising ($36,500) due to higher than anticipated activity. Internal Support Expenditures Transfers 855,030.00 928,047.00 75,000.00 928,047.00 75,000.00 0.00% $ 6,437,363.00 $ 6,793,872.00 $ 6,251,572.00 $ 542,300.00 7.98% 64
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST :UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Community and Home Improvement Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers 495,018,00 495,018.00 $ 495,018.00 $ 495,018.00 $ Workforce Development Personnel Expenditures $ 25,620.00 $ 25,620.00 $ 25,620.00 $ 0.00% Operating Expenditures Internal Support Expenditures $ 25,620.00 $ 25,620.00 $ 25,620.00 $ 0.00% $ 5,640,614.00 1,837,731.00 908,363.00 Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 5,640,614.00 2,108,663.00 1,002,472.00 570,018.00 $ 5,418,314,00 $ 222,300.00 1,752,763.00 355,900.00 1,002,472.00 570,018.00 3.94% 16.88% 0.00% 0.00% $ 8,386,708.00 $ 9,321,767.00 $ 8,743,567.00 $ 578,200.00 6.20% 65
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT NON-DEPARTMENTAL EXPENDITURES AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION NON-DEPARTMENT APPROPRIATIONS COUNTY OPERATIONS Insurance Fund Insurance Surety Bonds Logos Trademarks Intellect Property Road Commission\ Current Drain Assessment Road ComrnissionlTri Party Agreement Interest Expense Provisions Transfer to Community Mental Health Authority Total $ 361,309.00 $ 361,309.00 $ 361,309.00 $ 33,305.00 33,305.00 8,305.00 20,000.00 20,000.00 20,000.00 1,450,000.00 1,450,000.00 1,450,000.00 100.00 2,329,066.00 2,329,066.00 30,000.00 30.000.00 30,000.00 9,620,616.00 9,620,616.00 9,620,616.00 $ 11,515,330.00 $ 13,844,296.00 $ 13,819,296.00 $ 0.00% 25,000.00 75.06% Fav. projection based on actual payments approved by Risk Management to date. 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 25,000.00 0.18% COUNTY BUILDINGS $ 2,652,589.00 $ 2,105,531.00 $ 2,175,531.00 5 (70,000.00) -3.32% Unfavorable Maintenance Department Charges based on usage trends. Offset by favorable Grant Match and IT Development A budget amendment will be made by year end if the trend continues. STATE AND FEDERAL - COUNTY ASSOCIATIONS Michigan Assoc. of Counties $ 73,000.00 $ 73,000.00 $ 73,000.00 $ National Assoc. of Counties 24,100.00 24,100.00 24,100.00 S.E.M.C.O.G. 500,000.00 500,000.00 465,000.00 Traffic Improvement Association 30,000.00 30,000.00 30,000.00 35,000.00 0.00% 0.00% 7.00% 0.00% Fay. due to membership rate less than budget. Total $ 627,100.00 $ 627,100.00 $ 592,100.00 $ 35,000.00 5.58% SUNDRY EXPENSE $ 300,000.00 $ 300,000.00 $ 300,000.00 $ 0.00% RESERVED FOR TRANSFERS Expenditures Classification and Rate Change Contingency Disaster Recovery Emergency Salaries Grant Match Info Tech Development Juvenile Resentencing Legislative Expense Local Road Funding Program Misc. Capital Outlay $ 298,179.00 $ 282,775.00 $ 300,000.00 50,294.00 300,000.00 300,000.00 500,000.00 461,016.00 1,470,937.00 855,058.00 5,698,874.00 2480,013,00 1,186,866.00 8,600.00 8,600.00 1.813,890.00 791,950.00 400,556.00 282,775.00 $ 50,294.00 300,000.00 461,016.00 730,058.00 2,405,013.00 1,186,865.00 8,600.00 1,813,890.00 400,556.00 125,000.00 75,000.00 0.00% 0.00% 0.00% 0.00% 14.62% 3.02% 0.00% 0.00% 0.00% 0.00% Favorable based on timing of grant agreements. Favorable based on IT Development projections to date. 66
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT NON-DEPARTMENTAL EXPENDITURES Overtime Reserve Security Reserve Substance Abuse Coord Agency Summer Employees Salary Appropriation Total ADOPTED BUDGET 256,000.00 1,141,166.00 4,550,000.00 250,000.00 AMENDED BUDGET 256,000.00 91,941.00 4,550,000.00 250,000.00 FY 2018 FORECAST 256,000.00 91,941.00 4,550,000.00 250,000.00 AMOUNT FAVORABLE (UNFAVORABLE) PERCENT 0.00% 0.00% 0.00% 0.00% $ 15,565,706.00 $ 12,987,009.00 $ 12,787,009.00 $ 200,000.00 1.54% EXPLANATION $ 477,919.00 $ 477,919.00 $ 477,919.00 1,644,186.00 1,644,186.00 1,644,186.00 3,620,676.00 3,822,712.00 3,822,712.00 2,238,000.00 2,238,000.00 2,238,000.00 1,268,000.00 7,124,902.00 7,124,902.00 5,500,000.00 5,500,000.00 5,500,000.00 1,708,046.00 1,708,046.00 1,113,861.00 1,113,881.00 4,211,324,00 4,211,324.00 $ 14,745,781.00 $ 27,840,950.00 $ 27,840,950.00 $ 0.00% $ 45,409,506.00 $ 57,704,886.00 $ 57,514,886.00 $ 190,000.00 0.33% $ 23,323,944,00 $ 23,482,005.00 $ 23,482,006.00 $ 0.00% 1,000.00 1,000.00 1,000.00 0.00% $ 23,324,944.00 $ 23,483,006.00 $ 23,483,006.00 $ 0.00% Transfers to Other Funds Fire Records Management CLEMIS Information Technology Bldg Auth Fac Infras IT Debt Facilities Maintenance and Operations Fringe Benefit Fund Project Work Order Fund Long Term Revolving Fund Building Fund Economic Development Corp BA Animal Ctrl Pet Adopt Debt Imaging System Project HIPAA Compliance Project UCC Network Equipment Replacement Project Domestic Equipment Preparedness TOTAL NON-DEPT. APPROPRIATIONS TRANSFER TO GENERAL PURPOSE FUNDS Child Care Fund Social Welfare Fund Foster Care 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0,00% 0.00% 0.00% 0.00% 0.00% 0.00% TOTAL EXPENDITURES $ 68,734,450.00 $ 81,187,892.00 $ 80,997,892.00 $ 190,000.00 0.23% 67
FY 2018 BUDGET AMENDMENTS
FY 2018 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS
BUDGET AMENDMENTS
M.R. #17285 - 10/11/2017
Department of Health and Human Services/Health Division - Funding for the Area Agency on
Aging 1-B - Community Living Program Services
M.R. #17310 - 1110912017
Department of Information Technology - Universal Communications and Collaboration Program,
Network Equipment Replacement Project
M.R. #17318 - 11109/2017
Risk Management and Information Technology - Policy for the Health Insurance Portability and
Accountability Act of 1996 (HIPAA) as Amended by the HITECH Act of the American Recovery
and Reinvestment Act of 2009 and HIPAA Compliance Project
$ 454,982,525.00
$ 600,000.00
$ 4,211,324.00
$ 1,113,861.00
M.R. #17325 - 12/0712017
Management & Budget Fiscal Year 2017 Year-End Report and Budget Amendments
Encumbrances
Carry Forwards
Adjustments to Circuit Court
Adjustments to Children's Village Child Care Fund
Adjustments to Water Resource Commissioner
$ 192,145.21
$ 4,847,541.00
$ 130,500.00
400.00
$ 31,520.00 $ 5,202,106.21
M.R. #17336 - 12107/2017
Department of Facilities Management and Sheriff's Office - Amendment to the Lease Agreement
with 2470 Elizabeth Lake Road, LLC
M.R. #17337 = 12/07/2017
Public Services/Animal Control - Modifications of Rates and Positions
M.R. #17340 - 12/07/2017
Sheriffs Office - Contract Amendment #1 for Law Enforcement Services in the Charter
Township of Commerce 2017-2018
M.R. #17341 - 12/07/2017
Sheriffs Office - Contract Amendment #1 for Law Enforcement Services in the Charter
Township of Highland 2017-2018
M.R. #17342 - 12/07/2017
Sheriffs Office - Contract Amendment #2 for Law Enforcement Services in the Charter
Township of Orion 2017-2018
M.R. #17343 - 12/07/2017
Sheriffs Office - Contract Amendment #1 for Law Enforcement Services in the Charter
Township of Oxford 2017-2018
M.R. #17344 - 12/0712017
Sheriffs Office - Contract Amendment #1 for Law Enforcement Services in the City of
Rochester Hills 2017-2018
M.R. #18002 - 01/17/2018
Department of Health and Human Services/Children's Village Division — Oakland County interlace!
Agreement Between Oakland County and the Oakland Community Health Network for Psychiatric
Services for Oakland County Children's Village
4,990.00
$ 173,111.00
$ 320,416.00
$ 130,924.00
$ 150,437.00
$ 130,924.00
$ 237,811.00
75,000.00
M.R. - 02/01/2018
Board of Commissioners - Tr-Party Road improvement Program (Planned Use of Fund Balance)
M.R. #18010 - City of Troy $ 249,266.00
MR. #18011 - City of Rochester Hills $ 160,578.00
$ 409,844.00
68
FY 2018 BUDGET AMENDMENTS
MR. #18048 - 02/21/2018
Board of Commissioners - Sponsorship of the 2018 International Bocce Tournament at the Palazzo
Di Bocce
M.R. 0212112018
Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance)
M.R. #18049 - Charter Township of Springfield
M.R. #18050 - 02/2112018
Board of Commissioners - Funding Support for Haven's Conference for Domestic Abuse Professionals
MR. #18053 - 02/21/2018
Board of Commissioners - Tr-Party Program — Additional Appropriation #2 for Charter Township
of Oxford — Project No. 53331
MR. #18021 - 02/21/2018
Sheriff's Office-Establishment of Dispatch Services Contract Rates April 1, 2018 through March 31, 2021
M.R. #18059 - 03/08/2018
Facilities Management/Facilities Planning & Engineering / Sheriffs Office — Additional Priority 2 Building
Security Enhancement and Priority 3 Building Security Enhancement Projects
12,000.00
37,000.00
4,000.00
36,606.00
$ 153,707.00
$ 4,692,766.00
M.R. #18081 - 03/21/2018
Corporation Counsel/Risk Management Matter Management System and Access Database Replacement Project $ 100,000.00
M.R. #18082 - 03/21/2018
Facilities Management/Facilities Planning & Engineering/Probate Courtroom Ingress/Egress Flow Enhancements $ 164,136.00
Project
M.R. #18083 - 03/2112018
Management & Budget FY 2018 First Quarter Report
Adjustments to Sheriffs Office
Adjustments to Children's Village Child Care Fund
Adjustments to Economic Development and Community Affairs
Adjustments to Non-Departmental
59,015.00
813.00
41,000.00
1,708,046.00 $ 1,808,874.00
M.R. #18088 - 04/19/2018
Health and Human Services — Homeland Security Division — Emergency Operations Center and Incident
Management Software
M.R. #18098 - 04/19/2018
Sheriff's Office —2018 Michigan Medical Marihuana Operation and Oversight — Grant Acceptance
M.R. - 05/02/2018
Board of Commissioners - Pilot Local Road Improvement Program (Planned Use of Fund Balance)
M.R. #18108- City of South Lyon $ 25,349.00
M.R. #18110 - City of Farmington Hills $ 158,350.00
M.R. #18111 - Village of Bingham Farms $ 7,202.00
M.R. #18115 - City of Madison Heights $ 59,328.00
MR. #18116 - City of Huntington Woods $ 11,468.00
M.R. #18117 - City of Ferndale $ 83,040.00
M.R. #18119 - City of Keego Harbor $ 5,939.00
M.R. #18121 - City of Orchard Lake Village $ 6,604.00
M.R. #18122 - City of Sylvan Lake $ 5,157.00
M.R. #18123 - City of Troy $ 169,928.00
M.R. #18125 - City of Rochester Hills $ 136,625.00
M.R. #18128 - City of the Village of Clarkston $ 2,881.00
M.R. #18130 - Village of Ortonville $ 4,699.00
M.R. #18131 - Village of Leonard $ 2,215.00
M.R. #18134 - City of Bloomfield Hills $ 16,569.00
65,000.00
65,805.00
$ 695,354.00
69
FY 2018 BUDGET AMENDMENTS
M.R. - 05/02/2018
Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance)
M.R. #18109 - Charter Township of Milford
M.R. #18112- Village of Beverly Hills
M.R. #18114- Township of Holly
M.R. #18118 - City of Orchard Lake Village
MR. #18120 - Charter Township of West Bloomfield
MR. #18126 - Charter Township of White Lake
KR. #18129 - City of Royal Oak
MR. #18132 - Township of Addison
M.R. #18135 - Charter Township of Bloomfield
M.R. #18136 - Charter Township of Bloomfield
M.R. #18137 - Charter Township of Bloomfield
M.R. #18139 - 05/0212018
Board of Commissioners - School Drinking Water Station Program 2018 Appropriation
M.R. #18101 - 05/02/2018
Sheriffs Office — Use of Forfeited Funds
M.R. - 05/17/2018
Board of Commissioners - Pilot Local Road Improvement Program (Planned Use of Fund Balance)
M.R. #18151 - City of Auburn Hills $
M.R. #18152 - City of Berkley $
MR. #18153 - City of Clawson $
M.R. #18154 - City of Farmington $
M.R. #18155 - City of Hazel Park $
M.R. #18156 - City of Lathrup Village $
M.R. #18157 - City of Novi $
M.R. #18158 - City of Oak Park $
M.R. #18159 - City of Pleasant Ridge $
M.R. #18160 - City of Rochester $
M.R. #18162 - City of Walled Lake $
M.R. #18163 - City of Wixom $
M.R. #18164 - Village of Beverly Hills $
M.R. #18165 - Village of Holly $
M.R. #18167 - Village of Milford $
MR, #18168 - Village of Wolverine Lake $
M.R. - 05/17/2018
Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance)
M.R. #18203 - City of Lake Angelus
M.R. #18204 - Charter Township of Highland
M.R. #18205 - City of Troy
M.R. #18217 - 05/17/2018
Sheriff's Office — Revised Fire Dispatch Service Agreement with the Township of Groveland,
April 1, 2018 - March 31, 2021
M.R. - 06/13/2018
Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance)
M.R. #18222 - Charter Township of Commerce
M.R. #18223 - Charter Township of Commerce
M.R. #18224. Charter Township of West Bloomfield
M.R. #18225 - City of Pontiac
M.R. #18228 - Charter Township of Oakland
50,000.00
30,762.00
25,000.00
68,354.00
20,000.00
58,847.00
40,000.00
19,657.00
73,334.00
83,334.00
37,333.00
$ 506,621.00
$ 509,316.00
77,500.00
46,934.00
24,110.00
19,646.00
18,325.00
30,209.00
14,035.00
244,897.00
96,863,00
8,865,00
22,681.00
13,556.00
29,566.00
16,801.00
12,106.00
13,163.00
7,509.00
$ 619,266.00
22,000.00
39,613.00
155,922.00
$ 217,535.00
(3,988.00)
45,833.00
37,500.00
30,000.00
133,215.00
42,124.00
$ 288,672.00
70
FY 2018 BUDGET AMENDMENTS
M.R. #16235 - 0611312018
Corporation Counsel/Risk Management - Matter Management System and Access Database
Replacement Project - Project Amendment
$ 37,036.00
M.R. #18236 - 03121/2018
Management & Budget FY 2018 Second Quarter Report
Adjustments to Sheriffs Office
Adjustments to Facilities Managmement
Adjustments to Public Services - Veterans Services
Adjustments to Public Services - Animal Control
Adjustments to Economic Development and Community Affairs
$ 49,907.00
$ 17,000.00
$ 4,565,00
$ 19,524,00
$ 24,872,00
$ 115,868.00
TOTAL AMENDED BUDGET AS OF 06/30/2018 $ 477,946,347.21
71
GRANTS ACCEPTED $10,000 AND UNDER (approved administratively, per M. R. #17194) Department or Division 1Grant Title Homeland Security 2018 HMEP Grant Acceptance <$10,000 Parks and Rec Alexandria's Nature Bus <$10,000 1 AwardlAmendment IQuarter included (QTR/FY) i $ 3,500.00 3QTR/FY18 estimated value $750 3QTR/FY18 72
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT ENTERPRISE FUND TREASURER'S OFFICE ADOPTED AMENDED FY 2018 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES -- DEUNQUENT TAX REVOLVING FUND 51600 REVENUES Charges for Services Other Revenues $13,312,900.00 1,470,000.00 $13,312,900.00 1,470,000.00 $13,312,900.00 1,789,000.00 $0.00 $319,000.00 0.00% 21.70% Pay. Income from Investments $288,500 due to investment base and market rate adjustments. Also, favorable Prior Years Adjustments $30,500 due to interest charges on older delinquencies. Total Revenues $14,782,900.00 $14,782,900.00 $15,101,900.00 $319,000.00 2.16% Ending FY 2017 Designated Net Positions'', NP-UnRes - Designated - Debt Service NP-UnRes - Designated - Deling Taxes Receivable NP-UnRes - Designated - Collection Fees Undesignated - Net Position Total Net Position - Ending OPERATING EXPENSES Personnel Expenditures Operating Expenditures Interest Expense Transfer Out to Other Funds: General Fund - Collection Fees GE - Non-Departmental Work Release Facility Refunding Debt Svc Office Bldg Renovation Refunding Debt Svc 52-3 District Court Refunding Debt Svc Total Transfer Out to Other Funds Total Operating Expenses REVENUE OVER (UNDER) EXPENDITURES* Total Net Position - Beginning Total Net Position - Ending $ 211,894.00 699,303.00 230,625.00 2,600,000.00 6,000,000.00 1,587,500.00 1,866,700.00 1,301,800.00 $ 13,356,000.00 $ 14,497,822.00 $285,078.00 2,600,000.00 6,000,000.00 1,587,500.00 1,866,700.00 1,301,800.00 $ 13,355,000.00 $ 14,203,000.00 $898,900.00 $197,362,617.65 $198,261,517.65 $40,479,591.00 150,599,953.87 5,283,072.78 $0.00 §19126_1rn5 17,594.00 463,303.00 (186,075.00) $ 294,822.0-0 $613,822.00 $ 211,894.00 $ 194,300.00 699,303.00 236,000.00 230,625.00 416,700.00 2,600,000.00 6,000,000.00 1,587,500.00 1,866,700.00 1,301,800.00 $ 13,356,000.00 $ 14,497,822.00 $285,078.00 8.30% Fay. Salaries and Fringe Benefits based on actual activity. 66,25% Fay. Info Tech Development $400,000 due timing of the Tax Management system. Also, favorable Indirect Costs $27,000 due to actual charges determined after budget finalization; Professional Services $25,000, Legal Services $7,500 and Professional Services-Financial Consultant $5,000 due to less than anticipated activity. -80.68% Unfav. due to higher than anticipated short term interest rates on borrowing. 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2.03% * 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 73
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT ENTERPRISE FUNDS TREASURER ADOPTED BUDGET AMENDED BUDGET FY 2018 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DELINQUENT PERSONAL PROPERTY TAX (51800) .1•n•n•••10 •,n•.n••••/..1.•••••••n•••nn~M.-...-.., OPERATING REVENUE OPERATING EXPENSE NET OPERATING INCOME (LOSS) NON-OPERAT1NG REVENUE (EXPENSE) TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS TRANSFERS OUT TOTAL NET INCOME (LOSS)* $402,300.00 $402,300.00 $515,000.00 $112,700.00 28.01% - Fay. Administration Fee $115,000 due to increased collection activity; partially offset by unfavorable Reimbursement Salaries ($2,300) due to less than anticipated activity. 485,365.00 485,365.00 404,200.00 $81,165.00 16.72% - Fay. Controllable Personnel $114,600 due to vacant and underfilled positons. Favorable Metered Postage $2,300, Motor Pool Fuel Charges $2,700 and Motor Pool Leased Vehicles $2,100 due to less use. Partially offset by unfavorable Indirect Cost ($29,000) due to actual charges developed after budget finalization. Also, unfavorable Professional Services ($14,700) due to increased activity. ($83,065.00) ($83,065.00) $110,800.00 $193,865.00 -233.39% 500.00 500.00 4,100.00 $3,600.00 720.00% Fay. Income from Investments due to investment base and market rate adjustments. ($82,565.00) ($82,565.00) $ 114,900.00 $197,465.00 ($82,565,00) ($82,565.00) $114,900.00 $197,465.00 TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING 403,915.82 $518,815.82 * Please note that in the Adopted Budget (line-item book) this is budgeted as 'Planned Use of Balance" in the revenue category. 74
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT ENTERPRISE FUND PARKS & RECREATION ADOPTED BUDGET AMENDED BUDGET FY 2018 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANAllON OF SIGNIFICANT VARIANCES OAKLAND COUNTY PARKS & RECREATION COMMISSION (50800) OPERATING REVENUE OPERATING EXPENSE NET OPERATING INCOME (LOSS) NON-OPERATING REVENUE (EXPENSE) TOTAL INCOME BEFORE TRANSFERS TRANSFERS IN $ 10,596.390.00 $ 10,778,876.00 $ 10,914,876.00 $ 136,000.00 $ 26,455,766.00 $ 27,390,928.00 $ 27,190,928.00 $ 200,000.00 1.28% Fay. Overall Charges for Services revenues are fav. compared to activity through the third-quarter of FY2017 due to weather fluctuations and demand, including Entrance Fees Gen Admission $77,000, Sales Retail $70,000, Fees Camping $57,000, and Rental Facilities $54,000, partially offset by unfav. Greens Fees ($64,000), Rental Equipment ($18,000), Rental Golf Carts ($17,000), Fees Day Use ($15,000) and Water Feature Ride ($8,000). 0.73% Fay. variances are based on historical use which usage may change due to seasonal conditions: Contracted Services $50,000, General Program Administration $100,000, Insurance Fund $50,000. A budget amendment is recommended for Ad) Prior Years Revenue for an overpayment by Oak Management, $4,050 and Adj Prior Years Exp due to timing of invoices received for FY 2017 activity, $24,168. $ (15,859,376.00) $ (16,612,052.00) $ (16,276,052.00) $ 336,000.00 2.02% $ 14,294,200.00 $ 14,682,201.00 $ 14,505,201.00 $ (177,000.00) -1.21% Unfav. Properly Tax Levy based on actual collections, ($636,300). Partially offset by Local Comm Stabalization Share, $323,212, Income from Investments $81,000, and Gain on Sale of Equip $20,500. A budget amendment is recommended for Prior Years Adjustment $29,834 due to projects that were expensed in the prior year should have been capitalized and Capital Contribution of $4,859 from Oaks Management due interior renovations at Glen Oaks Golf Course. $ (1,565,176.00) $ (1,929,851,00) $ (1,770,851,00) $ 159,000.00 8.24% TOTAL NET INCOME/PLANNED USE OF BALANCE (LOSS)* $ (1,555,176.00) $ (1.929,851,00) $ (1,770,851.00) $ 159,000.00 TOTAL NET ASSETS - BEGINNING 94,216,006.08 TOTAL NET ASSETS - ENDING 92,445,155.08 75
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT INTERNAL SERVICE FUND WATER RESOURCES COMMISSIONER ADOPTED AMENDED FY 2018 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DRAIN EQUIPMENT FUND ( 63900) OPERATING REVENUES: Inside $43,948,708.00 $44,232,283.00 $41,414,658.00 ($2,817,625.00) -6.37% Unfav - Reimbursement Salaries ($3,000,000) due to unallocated payroll charges for turnover and vacant positions offset in Salaries and Fringes. Unfav - Maintenance Contracts ($91,000) due to an adjustment in the Supervisory Control and Data Acquisition (SCADA) maintenance allocation rate to be more in line with actual expenses. Unfav - Vehicle Rental ($20,000) due to over estimate of billable vehicles hours. Unfav - Rebilled Charges ($15,000) revenue is determined by a decrease in rebillable repair jobs, offset by favorable expenses pertaining to the repair jobs. Fay - Reimbursement General $250,000 a result of increased allocation base allocated to special revenue and proprietary funds. Fav - Reimbursement Building Space Cost $58,375 due to a rate adjustment for the maintenance and operations of the Dixie Highway Building. Outside 181,000.00 181,000.00 301,000.00 $120,000.00 66.30% Fay - External Rebilled Charges Revenue $120,000 revenue is determined by a increase in rebillable repair jobs, offset by unfavorable expenses pertaining to the repair jobs. Total Revenue -6.07% 44,129,708.00 44,413,283.00 41,715,658.00 (2,697.625.00) OPERATING EXPENSES $44,224,020.00 $44,398,236.00 $41,075,811.00 $3,322,425.00 7.48% Fav - Salaries $1,800,000 and Fringes $1,200,000 due to turnover and vacant positions. Fay - Depreciation Equipment $400,000 due to a change in the implementation date from FY 2018 to FY 2020 for the Supervisory Control and Data Acquisition (SCADA) system common to all project. Fay - Contracted Services $200,000 due to a decrease in repair work for Supervisory Control and Data Acquisition (SCADA) system, Fay - Indirect Cost $70,000 due to a roll forward credit reducing the expense. Fay - Small Tools $20,000, Expendable Equipment Expense $ 10,000, Shop Supplies $4,000, Drain Equipment Materials $3,000 and Computer Supplies $2,000 due to actual spending being less than anticipated budget. 76
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT INTERNAL SERVICE FUND WATER RESOURCES COMMISSIONER ADOPTED AMENDED FY 2018 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Unfav - Info Tech Development ($190,000) and Info Tech Operations ($122,255) due to continued implementation costs for Supervisory Control and Data Acquisition (SCADA) system common to all project, offset by favorable Charges for Services revenue. Unfav - Drain Equipment ($40,000) due to a increase in the amount of rebill projects. Unfav - Travel and Conference ($20,000) due to conferences on Capital Asset Management Plan (CAMP) for development of an asset water management program. Unfav - Maintenance Department Charges ($5,000) a result of labor charges from Facilities Maintenance and Operations for repair work at the Dixie Highway Building. Unfav - Equipment Maintenance ($4,500) the result of actual spending being more than anticipated budget. $624,800.00 4152.32% $88,867.00 116.62% Fay - Income from Investment $67,000 the result of fund earning a return due to a positive cash balance. Fav - Gain on Sale of Vehicles $21,000 the result of sale proceeds at county auction being more than anticipated budget. NET INCOME (LOSS) BEFORE ($94,312.00) $15,047.00 $639,847.00 NON-OPERATING REVENUE(EXPENSE) $251,427.00 $76,200.00 $165,067.00 TRANSFER IN 318,236.00 318,236.00 0.00% TRANSFERS (OUT) 167,115.00 409,483.00 409,483.00 0.00% NET REVENUES OVER (UNDER) $0.00 $0.00 $713,667.00 $713,667.00 EXPENSES TOTAL NET POSITION - BEGINNING 18,375,650.10 TOTAL NET POSITION - ENDING $19,089,317.10 77
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT INTERNAL SERVICE FUND RISK MANAGEMENT ADOPTED AMENDED FY 2018 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES LIABILITY INSURANCE FUND 67700 OPERATING REVENUES: Outside Revenue $ 10,211.00 $ 10,211.00 $ 32,711.00 $ 22,500.00 220.35% - Fav. due to litigation settlements. Inside Revenue 3,629,579.00 3,629,579.00 3,248,679.00 (380,900,00) -10.49% - Unfav. due to rebilis to department lower based on actual premiums paid, partially offset by favorable expense. Total Operating Revenue $ 3,639,790.00 $ 3,639,790.00 $ 3,281,390.00 $ (358,400,00) -9,55% OPERATING EXPENSE $ 3,641,668.00 3 3,641,668.00 $ 3,543,968.00 $ 97,700.00 2.68% - Fav. Insurance $169,300 due to actual premiums less than expected due to insurance market fluctuations, partially offset by unfavorable revenue. Personal Mileage $2,300, Office Supplies $2,000, Metered Postage $556, Membership Dues $500,and Printing $500 due to lower than anticipated use. Unfav. Indirect Cost ($42,622) due to actual charges determined after budget finalization, Medical Supplies ($35,000) for additional Stop the Bleed kits purchased and placed in all Automated External Defibrillator (AED) cabinets as well as supplies purchased to extend the useful life of current Automated External Defibrillators (AEDs) that are being discontinued. CLAIMS PAID 1,253,279.03 1,253,279.00 1,937,779.00 (684,500.00) -54.62% - Unfav. due to timing and claims amounts more than anticipated with budget TOTAL OPERATING EXPENSES 3 4,594,947.00 $ 4,594,947.00 $ 5,481,747.00 $ (566,800.03) -11.99% OPERATING INCOME (LOSS) (1,255,157.00) (1,255,157.00) (2,200,357.00) (945,200.00) 7531% NON-OPERATING REVENUE (EXPENSE) 150,000.00 150,000,00 139,400.00 (10,600.00) -7.07% - Unfav. due to lower than expected available cash balance. NET REVENUES OVERAUNDER) EXPENSES $ (1,105,157.00) $ (1,105,157.00) (2,060,957.00) $ (945,200.00) TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 6,644,395.00 4,583,435.00 78
230,000.00 1,400,000.00 1,200,300.00 1,836,300 00 316,800.00 230,000.00 1,400,000.00 1,200,300.00 1,836,300.00 316,800.00 230,000.00 1,694,000.00 1,236,000.00 1,893,000.00 328,500.00 COUNTY OF OAKLAND FY2018 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND ADOPTED AMENDED FY 2018 VARIANCE FRINGE BENEFITS FUND 67800 BUDGET BUDGET FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES — OPERATING REVENUE RETIREES MEDICAL - VEBA DEBT RETIREMENT ADMINISTRATION RETIREMENT ADMINISTRATION - PINE DEFINED CONTRIBUTION PLAN 34,002,500.00 3,324,900.00 240,000.00 18,900,000.00 34,002,500.00 35,030,000.00 1,027,500.00 3.02% - Fay. due to projected revenue more than budget projection. 3,324,900.00 3,423,000.00 98,100.00 2.95% - Fav. due to projected revenue more than budget projection. 240,000.00 274,000.00 34,000.00 14.17% Fay. due to projected revenue more than budget projection. 18,900,000.00 19,077,000.00 177,000.00 0.94% Fav. due to projected revenue more than budget projection - increase in new hires who participate in the Defined Contribution Plan. 0.00% 294,000.00 21.00% - Fav. due to projected revenue more than budget projection. Offset by unfavorable Deferred Compensation-County Payments expense. 35,700.00 2.97% - Fay, due to projected revenue more than budget projection. 56,700.00 3.09% - Fay, due to projected revenue more than budget projection. 11,700.00 3.69% - Fav. due to projected revenue more than budget projection. 0.00% 17,000.00 2.79% - Fay, due to projected revenue more than budget projection. DEFINED CONTRIBUTION PLAN - PTNE DEFERRED COMPENSATION-MATCH EMPLOYEE IN-SERVICE TRAINING EMPLOYEE BENEFITS UNIT EMPLOYEE RECOGNITION FLEX BENEFIT PLAN WELLNESS UNIT 90.000.00 90,000.00 90,000.00 610,000.00 610,000.00 627,000.00 114,600.00 114,600.00 114,600.00 460,000.00 460,000.00 475,500.00 0.00% 15,500.00 3.37% - Fay, due to projected revenue more than budget projection. 3,570,000.00 3,570,000.00 3,400,000.00 (170,000.00) -4.76% - Unfav. due to projected revenue less than budget projection, offset by favorable Retirement Health Savings expense. 457,000.00 457,000.00 457,000.00 0.00% 16,300,000.00 16,300,000.40 17,620,000.00 1,320,000.00 8.10% - Fay, due to projected revenue more than budget projection - an increase in new hires. Offset by unfavorable Social Security expense. 37,015,000.00 37,015,000.00 36,514,800.00 (500,200.00) -1.35% Unfav. due to projected revenue less than budget projection, offset by favorable Medical Insurance expense. 10,171,000.00 10,171,000.00 10,298,000.00 127,000.00 1.25% - Fay, due to projected revenue more than budget projection. 3,145,000.00 3,145,000.00 3,729,000.00 584,000.00 18.57% Fav. due to projected revenue more than budget projection. 188,500.00 188,500.00 345,000.00 156,500.00 83.02% Fast. due to projected revenue more than budget projection. 3,203,000.00 3.203,000.00 3,242,000.00 39,000.00 1.22% - Fay. due to projected revenue more than budget projection. Offset by unfavorable Disability Insurance expense. 3,122,700.00 3,122,700.00 3,684,700.00 562,000.00 18.00% Fay, due to projected revenue more than budget projection. FRINGE BENEFITS TUITION REIMBURSEMENT RETIREMENT HEALTH SAVINGS GROUP LIFE INSURANCE SOCIAL SECURITY MEDICAL INSURANCE PRESCRIPTION COVERAGE INSURANCE DENTAL INSURANCE VISION INSURANCE DISABILITY INSURANCE WORKERS COMPENSATION 79
15,000.00 1,500.00 435,000.00 120,000.00 120,000.00 15,000.00 1,500.00 435,000.00 120,000.00 120,000.00 COUNTY OF OAKLAND FY2018 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND FY 2018 VARIANCE FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 400,000.00 0.00% 1,000,000.00 720,100.00 257.27% - Fav. due to projected revenue more than budget projection. 5,246,500.00 46,500.00 0.89% - Fay, due to projected revenue more than budget projection. [FRINGE BENEFITS FUND 67500 UNEMPLOYMENT COMPENSATION INVESTMENT INCOME EXT - FLEX BEN MEDICAL - EMPLOYEE ADOPTED AMENDED BUDGET BUDGET 400,000.00 400,000.00 279,900.00 279,900.00 5,200,000.00 5,200,000.00 EXT - MEDICAL INSURANCE EXT - PRESCRIPTION DRUG REBATES EXT - RETIREE PRESCRIPTION DRUG REBAT 160,000.00 0.00% 1,500,000.00 550,000.00 57.89% - Fay, due to projected revenue more than budget projection. 500,000.00 500,000.00 0.00% - Fay, due to projected revenue more than budget projection. 180,000.00 180,000.00 950,000.00 950,000.00 EXT - DENTAL INSURANCE EXT - VISION INSURANCE EXT - FLEX BEN LIFE INSURANCE EXT - FLEX BEN DENTAL INSURANCE EXT - FLEX BEN VISION INSURANCE EXT - FORFEITURE OF DEPOSIT 6, DC PLAN EXT - TRAINING EXT - OTHER REVENUE - ICMA REBATES EXT - WELLNESS REVENUE EXT - FLEX BEN ARREARAGES REFUND PRIOR YEARS EXPENDITURE TOTAL REVENUE OPERATING EXPENSE RETIREES MEDICAL - VEBA DEBT PR] NC. RETIREES MEDICAL- VEBA DEBT INT/AGING RETIREMENT ADMINISTRATION DEFINED CONTRIBUTION PLAN 0.00% 0.00% 2.60% - Fay, due to projected revenue more than budget projection. 9.00% - Fav. due to projected revenue more than budget projection. 0.00% 0.00% - Fay. due to forfeiture of non-vested International City Management Association (ICMA) accounts. 0.00% - Fay. due to training provided to outside agencies. 0.00% 0.00% - Fay. due to sponsorship of wellness fair. 0.00% - Fav, due to post tax benefit arrearages due from County employees for 2017 benefits. 0.00% - Fay. due to payment from vendor for missed performance guarantee, training refund, and office supplies refund for prior year expenditures. Unfav. Legal Services ($200,000) due to legal issues regarding DB plan, 401(a) plan and 457(b) plan, partially offset by favorable Retirement Administration revenue, Monitoring Services 6118,500 due to new vendor with lower contract rate, and Personnel $26,000 due to vacant position. 10,000.00 10,000.00 15,000.00 1,500.00 446,300.00 11,300.00 130,800.00 10,800.00 120,000.00 800,000.00 800,000.00 9,200.00 9,200.00 10,000.00 8,000.00 8,000.00 10,900.00 10,900.00 3,700,00 3,700.00 147,609,000.00 147,609,000.00 154,165,000.00 6,556,000.00 4.44% 23,870,000.00 0.00% 10, 132,500.00 10,132,500.00 10,132,500.00 0.00% 3,381,500.00 3,381,600.00 3.437,100,00 (55,500.00) -1.64% 18,900,000.00 18,900,000.00 18,200,000.00 700,000.00 3.70% - Fay. due to projected costs less than budget projection - increase in new hires who participate in the Defined Contribution Plan. DEFINED CONTRIBUTION PLAN - PTNE 230,000.00 230,000.00 230,000.00 0.00% DEFERRED COMP-COUNTY PMTS (MATCH) 1,400.000.00 1,400,000.00 1,662,000.00 (262,000.00) -18.71% - Unfav. due to projected expense more than budget projection. Offset by favorable Deferred Compensation-Match revenue. 80
COUNTY OF OAKLAND FY2018 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND FY 2018 VARIANCE FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 879,200.00 (28,900.00) -3.40% - Unfav. Office Supplies ($12,500) due to the need for additional office supplies for training classes, and Information Technology Development ($16,400) due to higher than expected usage. 350,000.00 356,400.00 10,200.00 1,603,500.00 49,500.00 ADOPTED AMENDED [FRINGE BENEFITS FUND 67800 BUDGET BUDGET n••nn••n•/~~~ -------- EMPLOYEE EN-SERVICE TRAINING 850,300.00 850,300.00 IN-SERVICE TRAINING - INFO TECH 350,000.00 350,000.00 BENEFITS ADMINISTRATION 366,600.00 366,600.00 EMPLOYEE BENEFITS UNIT 1,653„000.00 1,653,000.00 0.00% 2.78% Fav. Travel and Conference $5,200 due to less than expected travel costs and Telephone Communications $5,000 due to phone charges being distributed to various Fringe Benefit departments. 2.99% - Fay. Professional Services $35,000 due to lower than expected professional service charges and Printing $14,500 due to lower than expected print costs. EMPLOYEE RECOGNITION FLEXIBLE BENEFIT PAYMENTS WELLNESS PROGRAM ACCOUNTING SERVICES TUITION REIMBURSEMENT RETIREMENT HEALTH SAVINGS 316,800.00 90,000.00 610,000.00 114,600.00 460,000.00 3,570,000.00 316,800.00 90,000.00 610,000.00 114,600.00 460,000.00 3,570,000.00 301,800.00 90,000.00 572,700.00 114,600.00 460,000.00 3,250,000.00 15,000.00 37,300.00 320,300.00 4.73% 0.00% 6.11% 0.00% 0.00% 8.96% - Fay. due to projected expense less than budget projection, offset by unfavorable Retirement Health Savings revenue. 892,000.00 892,000.00 892,000.00 0.00% 16,300,000.00 16.300,000.00 16,815,000.00 (515,000.00) -3.16% - Unfav. due to projected expense more than budget projection - increase in new hires. Offset by favorable Social Security revenue. 42,090,000.00 42,090,000.00 41,090,000.00 1,000,000.00 2.38% - Fay. due to projected expense less than budget projections, offset by unfavorable Medical Insurance revenue. 11,026,000.00 11,026,000.00 11,000,000.00 26,000.00 0.24% - Fav. due to projected expense less than budget projection. 3,250,000.00 3,250,000.00 3,000,000.00 250,000.00 7.69% Fay. due to projected expense less than budget projection. 310,000.00 310,000.00 215,500.00 94,500.00 30.483/4 Fav. due to projected expense less than budget projection. 3,203,000.00 3,203,000.00 3,333,000.00 (130,000.00) -4.06% Unfav, due to higher number of filled full time eligible positions, with less vacancies. Partially offset by favorable Disability Insurance revenue. GROUP LIFE INSURANCE SOCIAL SECURITY MEDICAL INSURANCE PRESCRIPTION COVERAGE DENTAL INSURANCE VISION INSURANCE DISABILITY INSURANCE MICHIGAN HICAA TAX 411,000.00 411,000.00 468,000.00 (77,000.00) -18.73% - Unfav. due to higher projected HICAA Tax due to increase of rate from .75% to 13/4 in 2017. 81
COUNTY OF OAKLAND FY2018 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND FY 2018 VARIANCE FORECAST FAV1(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 3,742,500.00 (619,800.00) -19.85% Unfav. Worker Compensation claims ($750,000) due to higher workers compensation costs associated with empIoyee injuries. Fay. Personnel $79,300 due to vacant position, State of Michigan Fees $35,700 due to lower than expected fees, and Insurance Fund $15.200 due to insurance market rate fluctuations ADOPTED AMENDED FRINGE BENEFITS FUND 67600 BUDGET BUDGET ..... -- ---- WORKERS COMPENSATION 3,122.700.00 3,122700.00 UNEMPLOYMENT COMPENSATION 400,000.00 400,000.00 400,000.00 0.00% CHILD CARE FACILITY 204,900.00 HEALTH INSURANCE PREMIUM TAX 204,900.00 213,000.00 (8,100.00) -3.95% - Unfav. Malntenance Department Charges ($11,100) due to higher than expected usage. Offset by Fay. Metered Postage $3,000 due to less than expected mailings. 56,500.00 (56,500.00) 0.00% - Unfav. due to the reinstatement of Health Insurance Premium Tax in January 2018. PATIENT CENTERED OUTCOME RESEARCH 19,000.00 19,000.00 19,000.00 0.00% INDIRECT COSTS 85,000.00 85,000.00 230,100.00 (145,100.00) -170.71% - Unfav. due to actual charges developed after budget finalization. TOTAL EXPENSE NET REVENUE OVER/(UNDER) EXPENSES TOTAL NET POSITION - BEGINNING* TOTAL NET POSITION - ENDING 147,609,000.00 123,739,000.00 123,134,400.00 604,600.00 0.49% 23,870.000.00 31,030,600,00 7,160,600.00 (7,670,877.00) 23.359.723.00 82
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT ENTERPRISE FUNDS CENTRAL SERVICES ADOPTED BUDGET AMENDED BUDGET FY 2018 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OAKLAND COUNTY INTERNATIONAL AIRPORT (56500) • • n• • • n••n••• ...n••n•nnn•n••n••n••n••n••n•n••••n••n OPERATING REVENUE $4,627,500.00 $4,729,339.00 $4,711,439.00 ($17,900,00) -0.36% - Unfav. Reimb U.S. Customs Service ($50,000) due to the timing of reimbursments received for Customs and fewer international flights needing inspections by Customs (partially offset by U.S. Customs Service Expense), Aviation Gas ($14,600) due to lower than anticipated gas concessions. Partially offset by fay. T-Hangar Rentals $28,000 due to increased T-Hangar rentals, and Land Lease $15,700 due to higher than anticipated land leases. OPERATING EXPENSE $6,351,354.00 $6,393,754.00 $6,265,054.00 5105.700.00 1.70% Fay. Equipment Maintenance $57,300 due to less than expected maintenance costs, Professional Services $52,700 due to lower than expected professional service expenses, Personnel $44,200 due to three underfilled positions, Electrical Service $23,300 due to lower energy costs, Grounds Maintenance $22,500 due to less than anticipated snow removal, Maintenance Supplies $19,200 due to fewer maintenance supply costs, Insurance Fund $17,300 due to insurance market rate fluctuations, Runway and Taxiway Repairs $11,800 due to fewer costs for runway and taxiway repairs, Indirect Costs $10,000 due to actual charges being developed after budget finalization. Unfav. Depreciation Land Improvements ($76,400) due to closing of capital projects at the end of Fiscal Year 2017, Building Maintenance Charges ($28,400) due to higher than anticipated building repairs and maintenance, Water and Sewage Charges ($18,000) due to higher than anticipated water and sewer charges, Electrical Supplies ($14,700) due to the need for additional electrical supplies. and Gasoline Charges ($13,000) due to higher gas costs. NET OPERATING INCOME (LOSS) ($1,753,554.00) NON-OPERATING REVENUE (EXPENSE) 145,000.00 TOTAL INCOME BEFORE ($1,664,415.00) ($1,573,615.00) 145,000,00 252,600.00 -5.46% 74.21% - Fay. Income from Investments due to higher than expected interest income. $90,800.00 107,600.00 CONTRIBUTIONS AND TRANSFERS TRANSFERS IN CAPITAL CONTRIBUTION ($1,608,854,00) 0.00 94,200.00 ($1,519,415.00) 0.00 94,200.00 $ (1,321,015.00) 0.00 94,200.00 $198,400.00 0.00 $0.00 0.00% TOTAL NET INCOME (LOSS) TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING ($1,514,654,00) ($1,425,215.00) $ (1,226,815.00) $ 76,899,520.16 $ 75,672705.16 $198 4130.00 83
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS CENTRAL SERVICES ADOPTED AMENDED FY2018 VARIANCE BUDGET BUDGET FORECAST FAVi(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES MOTOR POOL FUND 66100 OPERATING REVENUE: Outside Revenue 130,000.00 $ 130,000.00 $ 132,000.00 $ 2,000.00 1.54% - Fav. External-Parts and Accessories revenue $2,000 due to higher than expected service levels associated with City, Village, and Township vehicle repairs. Inside Revenue 8,763,023.00 8,920.371.00 8,719,747.00 $ (200,624.00) -2.25% - Unfav. Leased Equipment ($205,700) due to actual activity trends to date; Gasoline, Oil & Grease Charges ($172,500) due to current fuel costs (partially offset by a favorable expenditure for Gasoline Charges); partially offset by fay. Sublet Repairs $68,900 due to fleet expansion within various departments, Productive Labor $56,000 due to new vehicle builds and vehicle repairs handled in-house, Parts and Accessories $36,300 due to fleet expansion within various departments. Total Revenue OPERATING EXPENSE $ 8,893,023.00 $ 9,050,371.00 $ 8,851,747.00 $ (198,624.00) 8,941,968.00 9,047,907.00 9,464,925.00 $ (417,018.00) -4.61% - Unfav. Depreciation Vehicles ($285,900) due to the replacement of older vehicles with new vehicles and fleet expansion, Expendable Equipment ($75,900) due to the purchase of additional used vehicles, Sublet Repairs ($70,000) due to fleet expansion within various departments, Indirect Costs ($39,200) due to the development of actual charges after budget finalization, Parts and Accessories ($25,700) due to vehicle expansion within various departments and repairs being completed in-house, Insurance Reserve Expense ($20,000) due to higher costs associated with garage owned vehicles involved in accidents, Car Wash ($16,000) increased number of car washes and increased car wash rates, Shop Supplies ($10,500) due to the need for additional shop supplies; partially offset by fay. Gasoline Charges $36,000 due to market fluctuations and miles driven (offset by unfav. Gasoline, Oil Grease Charges revenue), Insurance Fund $31,600 due to less than anticipated insurance costs, Tires and Tubes $31,000 due to lower than expected tire replacement costs, Information Technology Development $18,300 due to less than anticipated charges, Insurance $16,200 due to less than expected insurance costs, and Personnel $9,200 due to underfilled positions, turnover, emergency salary position and lower than expected Retirement costs. OPERATING INCOME (LOSS) $ (48,945.00) $ 2,464.00 $ (613,178.00) $ (615,642.00) NON-OPERATING REVENUE 437,500.00 437,500.00 446,400.00 $ 3,900.00 2.03% - Fay. Prior Year Adjustment $8,900 due to asset adjustment from previous (EXPENSE) NET INCOME (LOSS) BEFORE OPERATING TRANSFERS fiscal year. $ 388,555.00 $ 439,964.00 $ (166,778.00) $ (606,742.00) 84
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS CENTRAL SERVICES ADOPTED AMENDED FY2018 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES TRANSFERS IN I (OUT) 288,070.00 527,824.00 554,773.00 $ 26,949.00 5.11% NET REVENUE OVERAUNDER) EXPENSES (BUDGETED EQUITY ADJUSTMENT)* $ 676,625.00 $ 967,788.00 $ 387,995.00 $ (579,793.00) TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING $ 9,832,252.15 $ 10,220,247.15 85
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT INTERNAL SERVICE FUND FACILITIES MANAGEMENT ADOPTED AMENDED FY 2018 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES •••0 • FACILITIES MAINTENANCE & OPERATIONS (#63100) NET INCOME (LOSS) BEFORE OPERATING TRANSFERS 450,908.00 $ 450,908.00 $ 450,908.00 $ 0.00% - 26,015,442.00 26,021,192.00 26,031,192.00 10,000.00 0.04% Fay. Maintenance Dept Charges based on Department requests. $ 26,466,350.00 $26,472,100.00 $ 26,482,100.00 $ 10,000.00 0.04% $ 28,267,576.00 $28,107,382.00 $ 27,607,382.00 $ 500,000.00 1.78% - Fay. Natural Gas $525,000 due to purchasing natural gas from third party sources and lower market prices; Salaries and Fringe Benefits $400,000 due to underfitlecl/vacant positions; Water & Sewage Charges $150,000 based on actual usage; Sublet Repairs $100,000 due to more efficient management of grounds maintenance; Electrical Service $50,000 due to lower-cost third-party contracts and savings from FM&O energy conservation initiatives; Security Supplies $50,000 due to the use of alternative sources of funding (security enhancement); Fuel Oil $50,000 due to the lack of availability of specialized fuel grade; Equipment Maintenance $50,000 based on increased use of internal staff to repair/maintain equipment and specialty vehicles. Partially offset by unfav. Material and Supplies ($300,000) based on actual usage; Info Tech Development ($175,000) due to infrastructure and custodial software study; Custodial Supplies ($100,000) due to increase in cleaning services requested by department; Info Tech Operations ($75,000) due to AutoCAD and Kronos software maintenance along with one-time IT equipment purchase; Grounds Supplies ($75,000) and Maintenance Supplies ($75,000) based on increase of services performed internally; Professional Services ($75,000) due to third party security report. $ (1,801,226.00) $ (1,635,282.00) $ (1,125,282.00) $ 510,000.00 OPERATING REVENUES: Outside Revenue Inside Revenue Total Revenue OPERATING EXPENSES NON-OPERATING REVENUE 100,000.00 $ 100,000.00 $ 200,547.00 $ 100,547.00 100.55% Fay. Investment Income $50,000 due to higher than anticipated rate of return on investments. Fay. Sale of Scrap $4,700 primarily from residual copper cable lines along with higher than anticipated Gain on Sale of Equip and Vehicles $45,900. TRANSFERS IN TRANSFERS OUT NET REVENUES OVER(UNDER) EXPENSES" TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING - $ - $ 12,160.00 $ 12,160.00 (64,018.00) 8 (64,018.00) $ (64,018.00) 8 $ (1,765,244.00) $ (1,599,300.00) $ (976,593.00) $ 622,707.00 $ 10,996,803.11 $ 10,020,210.11 0.00% Transfers In from Project Work Order Fund for closed Maintenance Projects. 0.00% "Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category. 86
26,165,289.00 26,173,629.00 24,1376,729.00 (1,294,900.00) Inside COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS! ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET Information Technology - Operations (63600) AMENDED BUDGET FY 2018 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 5.04% Fay. Enhanced Access Fees $129,600, Managed Print Services $46,300 and Deferred Land File Tax $23,000 due to higher than anticipated usage; Sale of Equipment $6,200 due to higher than anticipated usage. Offset by unfavorable Outside Agencies ($84,400) and Reimb Equalization Services ($4,500) due to reduction in external customer requests. -4.95% - Unfav. DC Depts Development Support & Non Governmental Development ($839,600) and DC Depts Operations & Non Governmental Operations ($455,300) due to rates remaining at prior year levels and limited resources available to complete development due to vacancies. OPERATING REVENUES: Outside $2,308,103,00 $2,308,103.00 $2,424,403.00 $116,300.00 - Fay. Salaries & Fringes $1,125,900 due to vacant positions; Equipment Maintenance $201,500 due to lower than anticipated hardware maintenance costs; Depreciation $204,100 for IT capital projects in progress not fully operational; Expendable Equipment $149,900 due to timing of equipment replacements; Indirect Cost $119,500 due to actual charges being developed after budget finalization; Internal Services overall favorability of $27,400 primarily due to: Insurance Fund $35,200, Motor Pool Fuel Charges $4,000 and Leased Vehicles $1,400 due to lower than anticipated use offset by Maintenance Dept Charges ($10,900) and Telephone Communications ($2,400). Also fay. Printing $63,000 due to less than anticipated use; Communications $16,500 due to less expected costs. Partially offset by unfav. Professional Services ($1,000,000) a budget amendment is recommended to adjust the account for projects approved in prior year Bank Charges ($197,200) and Charge Card Fees ($92,100) for increased credit card activity; Software Maintenance ($135,700) due to timing of software support; Contracted Services ($65,000) and Supplies ($57,700) based on anticipated usage. TOTAL OPERATING REVENUE $28,473,392.00 $28,481,732.00 $27,303,132.00 ($1,178,600.00) -4.14% OPERATING EXPENSES $38,297,175.00 $40,140,434.00 $39,784,034.00 $356,400.00 0.89% NET INCOME (LOSS) BEFORE OPERATING TRANSFERS ($9,823,784.00) ($11,658,702.00) ($12,480.902.00) ($822,200.00) NON-OPERATING REVENUE 105,500.00 105,500.00 109,500.00 4,000.00 3.79% Fay. Interest Income due to anticipated investment income. TRANSFERS IN 3,906,576.00 4,490,595,00 4,490,595.00 0.00% TRANSFERS (OUT) (37,036.00) (37,036.00) 0.00% CAPITAL CONTRIBUTION 2,748,882.00 2,748,882.00 0.00% Fay Capital Contributions revenue recognized for Building Authority capital projects for IT. NET REV OVER(UNDER) EXP* TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING ($5,811,608.00) ($7,099,643.00) ($5,168,961,00) 24,679,819.10 $19,510,858,10 $1,930.682.00 *Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category. 87
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2018 VARIANCE BUDGET BUDGET FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - Telephone Communications (67500) OPERATING REVENUES: Outside $12,000.00 $12,000.00 $8,400.00 $ (3,600.00) -30.00% Unfav. Sale of Phone External due to reduction in landiine charges. Inside 2,842,228.00 2,842,228.00 $2,837,128.00 (5,100.00) -0.18% Unfav. Sale of Phone internal due to decreased usage. TOTAL OPERATING REVENUE OPERATING EXPENSES 82,854,228.00 $3,062,131.00 $2,854,228.00 $2,845,528,00 83,082,131.00 $3,231,031.00 (B.700.00) ($146,900.00) -4.83% Unfav. Communications ($163,900) due to increased activity; Expendable Equipment ($112,100) for equipment replacement: Internal Services ($42,000) primarily due to Info Tech Operations based on actual usage and costs; Indirect Cost ($19,900) and Equipment Maintenance ($9,500) due to actual charges determined after budget finalization. Partially offset by fav. Depreciation $194,300 based on depreciation schedule and Salaries & Fringes $4,100 due to less than anticipated overtime. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN CAPITAL CONTRIBUTION TRANSFERS (OUT) NET REV OVER(UNDER) EXP* TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING ($385,503.00) ($157,600.00) 34,000.00 4,000.00 13.33% Fay. Interest Income due to anticipated investment income. 0.00% 0.00% 0.00% ($351,503.00) (153,600.00) 4,469,626.89 84,118,123.89 ($227,903,00) ($227,903.00) 30,000.00 30,000.00 097,903.00) ($197,903.00) "Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance' in the revenue category. 88
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2018 VARIANCE BUDGET BUDGET FORECAST FAV/IUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - CLEMIS (53500) OPERATING REVENUES: Outside $4,664,7513.00 $4,664,758.00 $4,775,558,00 $110,800.00 2.38% Fay. Access Fees Non Oakland, $35,500 due to updated law enforcement Full Time Equivalent count used for billing partially offset by unfav. Access Fees Oakland ($69,900) due to lower than anticipated activity; CLEMIS Crash $123,800, CLEM'S Citation $59,800, Crime Mapping $7,300 and CLEWS Parking $4,900 due to increased usage by Oakland and non-Oakland agencies. Also fay. Maintenance Contracts $47,800 due to Livescan maintenance after warranty. Offset by unfav. In-Car Terminal External ($63,000) for fleet of CLEWS agencies; Rebilled Charges ($33,900) and Parts and Accessories ($1,500) billed to Tier 2.5 and 3.0 agencies for connectivity costs. Inside 1,963,525.00 1,987,629.00 1,411,429.00 (576,200.00) -28,99% Unfav. Service Fees ($405,400) based on actual billing for Computer Aided Dispatch (CAD) expense charge directly to Radio Fund; Reimb General ($94,700) and OC Depts Operations ($78,500) based on anticipated CLEMIS staff resources supporting Sheriff projects. Fay. In-Car Terminal Internal $2,500 due to participation count higher than budget projection. TOTAL OPERATING REVENUE $6,648,283.00 $6,652,387.00 $6,186,987.00 ($465,400.00) -7.00% OPERATING EXPENSES $11,175,791.00 $11,175,791,00 $9,394,591.00 $1,791,200,00 15.94% Fay. Depreciation $1,266,400 based on depreciation schedules; Salaries & Fringe Benefits $693,200 due to vacancies; Software Rental $240,500 due to timing of expenses; Internal Services $53,600 primarily due to IT Development based on actual usage; Communications $53,600 due to actual costs less than anticipated; Bank Charges $84,700 due to less than anticipated costs for PayPal services for E-Commerce transactions; Equipment Maintenance $187,000 for cost of repairs; Rebillable Services $7,800 based on actual connectivity costs to Tier 2.5 and 3.0 agencies; Supplies $4,000 and Printing $2,000 based on actual usage. Offset by unfav. Professional Services ($708,900) due to higher than anticipated contractual costs for staffing services; Expendable Equipment ($91,000) for equipment replacement and Travel ($11,700) due to usage. ($4,523,404.00) 35;000.00 1,644,186.00 NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN TRANSFERS (OUT) CAPITAL CONTRIBUTION NET REV OVER(UNDER) EXP* TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING ($3,207,604.00) $1,315,600.00 120,800.00 85,800.00 245.14% Fay. Interest Income due to anticipated investment income. 1,644,186.00 0.00% 0.00% 0.00% 16,943,114.71 $15 500.496 71 ($4,527,508.00) 35,000.00 1,644,186.00 0.00 ($2.848,322.00) 0.00 0.00 ($2,844,218.00) ($1,442,618,00) $1,401.600.00 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. 89
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET Information Technology - Radio Communications (53600) AMENDED BUDGET FY 2018 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUES: Outside $7,645,000.00 $7,807,000.00 $7,602,700.00 ($204,300,00) -2,62% Unfav. E-911 Surcharge ($216,000) due to decreased volume of users/receipt of 911 surcharge. Offset by fay. Outside Agency Revenue $8,800 due to higher non-emergency agencies than anticipated and Antenna Site Management $2,900 due to updates in rental contracts. Inside 490,000.00 490,000.00512,200.00 22.200.00 4.53% Fav. primarily due to Parts Access reimbursement by participating agencies for equipment replacement. TOTAL OPERATING REVENUE $8,135,000.00 $8,297,000.00 $8,114,900.00 ($182,100.00) -2.19% OPERATING EXPENSES $14,109,201.00 $14,109,201,00 $10,118,101.00 $3,991,100.00 28.29% Fay. Software Maintenance $1,672,900 due to the timing of the Emergency Services IP Network project; Depreciation $1,170,800 based on depreciation schedule; Professional Services $450,000 due to less than anticipated use; Internal Services $348,900 primarily due to Info Tech CLEM1S based on usage; Equipment Maintenance $105,000 due to less than anticipated maintenance costs; Training Related $75,000 due to timing of Radio Upgrade project; Utilities $24,600 and Supplies $4,800 due to usage and Salaries and Fringe Benefits $8,200 due to vacancies. Offset by unfav. Communications ($66,100) and Indirect Cost ($3,000) due to charges determined after finalization of budget, NET INCOME (LOSS) BEFORE OPERATING TRANSFERS ($5,974,201.00) ($5,812,201.00) ($2,003,201,00) $3,809,000.00 NON-OPERATING REVENUE 210,000.00 210,000.00 239,100.00 29,100.00 13.86% Fav. Interest Income due to anticipated investment income. TRANSFERS IN 52,800.00 52,800.00 0.00% TRANSFERS (OUT) (334,000.00) (334,000.00) 0.00% CAPITAL CONTRIBUTION NET REV OVER(UNDER) EXP* ($5,764,201.00) ($5,883,401.00) ($2,045,301.00) $3.638,100,00 TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING 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. 0.00% 35,934.002.39 $33,885.701.39 90
COUNTY OF OAKLAND FY 2018 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2018 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Fire Records Management ( 53100) OPERATING REVENUES: Outside $231,566.00 $231,566.00 $255,666.00 $24,100.00 10.41% Fay. primarily due to Participation Fees for Non-Oakland Agencies; the following agencies have been added: Eastpointe, Roseville and St. Clair Shores. TOTAL OPERATING REVENUES OPERATING EXPENSES $231,566.00 $826,870.00 $231,566.00 $826,870.00 $255,666.00 $542,570.00 $24,100.00 10.41% $284,300.00 34.38% Fay. Salaries & Fringes $292,300 due to vacancies; Depreciation $42,400 based on depreciation schedule; Communications $20,000 due to decrease in connectivity rates; Software Maintenance $7,500 due to decrease in maintenance costs; Travel $5,000 due to less than anticipated use; Expendable Equipment $3,500 due to the timing of equipment purchases made by tech support for maintaining the system and Equipment Maintenance $1,000 due to lower than anticipated maintenance costs. Offset by unfav. overall Internal Services ($66,800) primarily due to IT Development based on actual usage; Professional Services ($15,000) due to higher than anticipated contractual costs and Indirect Costs ($5,300) due to actual charges determined after budget finalization. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS ($695,304,00) ($595,304,00) ($266,904.00) $308,400.00 NON-OPERATING REVENUE 3,000.00 3,000.00 6,400.00 3,400.00 113.33% Fav. Interest Income due to anticipated investment income. TRANSFERS IN 477,919.00 477,919.00 477,919.00 0.00% TRANSFERS (OUT) 0.00% CAPITAL CONTRIBUTION 0.00% NET REV OVER(UNDER) EXP* TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING ($114,385.00) ($114,385.00) $197,415.00 $311,800.00 1,437,818.71 $1 635 233.71 *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, 91
OAKLAND COUNTY COMMUNITY & HOME IMPROVEIVIENT DIVISION REQUEST FOR AUTHORIZATION — TO RECOGNIZE UNCOLLECTIBLE HOME IMPROVEMENT LOANS . ADDRESS FOR 3rd QUARTER FY 2018 — : 1 REHAB CONTRACT DATE LOAN AMOUNT NAME COMMUNITY I ( , GRANT ( 1 ZIP CODE . CASE NO. CORD/HOME ' DATE DEEMED UNCOLLECTIBLE FORECLOSURE TYPE:TAX/ MORTGAGE/OTHER WRITE OFF AMOUNT Rita Brecht ;416 West Coy Ave Hazel Park 1 486301 1351 1 CDBG ( 2/18/19821 S3,475.00 I 6/30/2018 OTHER $3,475.00 IEugene Poteat 26561 Dartmouth I Madison Heights , 481711 6395 ( COED 11/8/20041 526,725.00 12/22/2017 MORTGAGE $9,150.60 Mary Lynn Robinson 23736 Couzens Hazel Park • 480361 5196 1 COED , 10/21/1997 59,795.00 2/8/2018 TAX $9,795.00 Bobby Thorne Jr 4800 Ormond white Lake _ 483831 6856 i CDBG 6/9/20094 I $24,300.60 5/1/2018 MORTGAGE $24,300.00 SUBTOTAL CDBG $45,720.60 Randy R Antoine 87 Barrett W Shaion Cox 2864 Saint Clair Robert Hochstadt 26221 Harding Madison Heights Rochester Hilts Oak Park 48071 9116 HOME ( 48326: 10060 . HOME 48237: 10085 ( HOME I • -- 1/15/2001 1/31/2007 2/27/2007 518,000.00 520,785_00 519,175.00 2/872017 2/3/2016 I_ 2/10/2017 02/29/2018 TAX $18,000.00 MORTGAGE _ S20,785.00_ I MORTGAGE 519,175.00 Dianne C Troup 21900 Sunset Blvd Oak Park . 482371 8822 1 HOME I i 1 ' 3/10/1999 . , $15,268.0D MORTGAGE $15,238.00 1 ] SUBTOTAL HOME $73,198.00 — , 1 TOTAL UNCOLLECTIBLES . 5119,918.60 "OTHER: MCI 565.3.82 (LOAN OVER 80 YEARS OLD - DISCHARGED BY •W) ' I I PREPARED BY LOAN CLOSING OFFICER .7 . lir / . DATE: June 30, 2018 APPROVED BY MANAGER be 7A,,,,i DATE: June 30, 2018 I 92
FRINGE BENEFIT HEALTHCARE CONTRIBUTIONS FY 2018 Uncollectible Debt Write-offs April 1, 2018- June 31, 2018 rOdUCtlitemISONice:Type 2018 Healthcare Contributions. Uncollectible due to HR's Benefit Contribution Arrearages - Post Separation Policy Name Last, First) OR first 2 digits of Eniployee ID 26XXX ep Human Resources/Benefits Administration Bpp.:740:004 nia • $ 343,65 May-18 TOTAL $ 343.65 Oakland County Fiscal Services Policy: If it is determined that a receivable is uncollectible, then amounts up to $1,000 may be written off by approval of the manager of Fiscal Services. All write-offs shall be reported to the Board of Commissioners with the quarterly forecast report. Write-offs in excess of $1,000 require Board of Commissioners' mprova Authorized 93
INFORMATION TECHNOLOGY FY 2018 Uncollectible Debt Write-offs April 1,2018 - June 30, 2018 • Name (Last First) OR • _ lastfourdigitsofcredftcard # 6825 0646 7163 2984 7912 0073 Product/Item/Service:1We Birth Certificate Enhanced Access Fee Enhanced Access Fee Enhanced Access Fee SO Clinic OTC Health & Human Services OTC Case Nurnber:: 1026211666 1026341305 1026704623 1026817863 1026481747 1026588078 :"Orderif 1438564 1451658 1426115 1507381 1449775 1441639 'Dept. Oakland County Register of Deeds 18th District Court Westland 31ST DISTRICT COURT PAYMENT 18th District Court OTC Health & Human Services Health & Human Services 1:1060.6ttop, ..0c:PPPAPPro.i/al: Date Date Of$1000.1.: 1/17/2017 n/a 2/27/2017 n/a 3/27/2017 nIa 2/8/2017 n/a 1/30/2017 n/a 3/9/2017 n/a • Month. Written-off 6/30/18 6/30/18 G/30/18 6/30/18 6/30/18 6/30/18 Amount (47.50} (11.00) (27.50) 14.00) (136.50) (27.50) 1.254.00) TOTAL Uncollectible NSF checks of $100 or more are referred to Oakland County Corporation Counsel. Oakland County Fiscal Services Policy: If it is determined that a receivable is uncollectible, then amounts up to $1,000 may be written off by approval of the manager of Fiscal Services. All write-offs shall be reported to the Board of Commissioners with the quarterly forecast report. Write-offs in excess of $1,000 Authorized by: r 6 ) JZ C 94
Department of Health and Human Services Oakland County Children's Village Donation Tracking : Donation Period April 2018 to June 2018 Date: Donor: Cash/Check: Items: Estimated Value: University Presbyterian Church Frozen Birthday Cakes (3) Months 495.00 4/10/2018 Rebecca Lopez Toys and Candy for Easter $10.00 4/11/2018 Waterford Library Yarn $75.00 4/12/2018 Children's Village Foundation Sponsor (20) MP Resident in March of Dimes Walk $500.00 4/12/2018 Children's Village Foundation Grace Center of Hope Mattress Set-Resident $174.80 4/12/2018 Children's Village Foundation Furniture Bank Mattress Set-Resident $75.00 4/13/2018 Anonymous Games & Toys for Mandy's $75.00 4/17/2018 Marie Carriere (2) Bags of Girls Clothes $25.00 4/18/2018 Sweet Dreams for Kids (15) Pillow Cases $225.00 4/20/2018 Clarkston High School NHS Clothing, Games, Hygiene Products, Gift Cards $420.00 4/20/2018 Robert Duschinske Winter Coats, Mittens & Hats $25.00 4/21/2018 Grace Christian Church Food and Playing Cards for Party $135.00 4/21/2018 Grace Christian Church Food and Craft Items for Party $170.00 4/30/2018 Waterford Senior Center (6) Pillows $50.00 5/7/2018 Waterford Senior Center (1) Pillow, (2) Blankets $50.00 5/9/2018 Marie Carriere Clothes $10.00 5/9/2018 Waterford Montessori Academy Toiletries $120.00 5/10/2018 Waterford Senior Center Pillows $50.00 5/10/2018 Datsun Doctor Magazines for Lobby $9.50 5/14/2018 Children's Village Foundation Azteca Youth Boxing Club-Resident $95.00 5/14/2018 Children's Village Foundation Grace Center of Hope Mattress Set-Resident $227.89 5/25/2018 Waterford Senior Center Medical Walker $10.00 5/31/2018 Diane Malik Yarn $40.00 6/8/2018 Jennifer Wilson Clothes $160.00 6/11/2018 Sue Ross Toys, Clothes, & Gym Equipment $10.00 6/11/2018 St. Mary of The Hills Birthday Drive-Clothes,Games,&Gift Bags $301.00 6/13/2018 Isaac & Donna Sheppard Check $100.00 6/13/2018 Travis & Margaret Parr Check $50.00 6/13/2018 Oakland County Credit Union Check $300.00 6/14/2018 Welcome Missionary Baptist Church Girls Pamper Party for Mandy's Place $500.00 95
Department of Health and Human Services Oakland County Children's Village Donation Tracking : Donation Period April 2018 to June 2018 Date: Donor: Cash/Check: Items: Estimated Value: 6/15/2018 Sweet Dreams for Kids (15) Pillow Cases $225.00 6/15/2018 Big Beaver United Methodist Church Toys, Puzzles, Lotions, & Books $100.00 6/15/2018 Mr. & Mrs. Halsey Check $25.00 6/18/2018 Children's Village Foundation Camp Bloom - G & Tag Girls $1,000.00 6/18/2018 The Well Camp Bloom - G & Tag Girls $1,400.00 6/18/2018 Waterford Senior Center Pillow, Blanket, Puzzles, Yarn, Toiletries $50.00 6/19/2018 St. Mary of The Hills Birthday Dr.-Clothes,Games, Toiletries &Gift Cards $1,447.50 6/20/2018 Children's Village Foundation Gym Membership - Resident $100.00 6/20/2018 Children's Village Foundation Grace Center of Hope Furniture-Resident & Family $227.00 6/20/2018 Children's Village Foundation Volleyball Camp - Resident $90.00 6/20/2018 Children's Village Foundation Grace Center of Hope Furniture-Resident & Family $125.00 6/20/2018 Children's Village Foundation Limited Guardianship Application - Resident $175.00 6/20/2018 Children's Village Foundation SMART Bus Passes $200.00 6/21/2018 St. Perpetua Catholic Church (20) Pillow Cases $300.00 6/22/2018 St. Mary of The Hills Birthday Dr,-Clothes,Games, Toiletries &Gift Cards $943.00 6/27/2018 Waterford Senior Center (10) Pillows $50.00 6/28/2018 Douglas & Nancy Fortier Check $50.00 6/28/2018 Randy &Judy Merrill Cash $50.00 6/28/2018 Jerry & Mary Ann Bell Check $100.00 6/28/2018 Jeffrey & Lori Bowes Check $25.00 6/28/2018 Lauren & Dwight Smith Check $50.00 Total: $11,220.69 96
Donations to Animal Shelter
2018 FY-Third Quarter
tiOn
4/4/2018
ting
North Oakland Visiting Vet
er
22559
Amount
$0.50
nal Num
283146
4/4/2018 Carl Kuck 22560 $1.50 283146
4/4/2018 Bailey Lake Elementary 22563 $20.00 283146
4/5/2018 MacKenzie Stinson 22600 $40.00 283200
4/6/2018 Maria Bengtson 22625 $8.00 283303
4/9/2018 Donation Box 22692 $12.50 283373
4/10/2018 Donation Box 22711 $5.00 283460
4/10/2018 Nancy Martinez 22717 $20.00 283460
4/10/2018 Kathy Sibley 22720 $50.00 283460
4/11/2018 Camilla & William Liebold 22747 $35.00 283529
4/12/2018 Jules Sipes 22758 $120.00 283605
4/13/2018 Karim Touarni 22795 $3.00 283670
4/13/2018 David Ford 22801 $40.00 283673
4/14/2018 Donation Box 22832 $61.75 283674
4/14/2018 Donna Jagiela 22837 $28.00 283674
4/14/2018 GSSEM Troop#71558 22838 $400.00 283674
4/17/2018 Elissa Staeuble 22882 $15.00 283896
4/18/2018 Pet Supplies Farmington Hills 22928 $59.00 283986
4/19/2018 Margaret Alberts 22944 $25.00 284056
4/20/2018 Janet McKervey 22974 $10.00 284167
4/21/2018 William Putnam 23039 $13.00 284171
4/24/2018 Donation Box 23085 $8.00 284360
4/24/2018 Cheryl Kozel! 23090 $100.00 284360
4/24/2018 IGIVE 23091 $27.56 284360
4/25/2018 Steven Lawson 23126 $50.00 284462
4/26/2018 Pet Supplies Plus Waterford 23147 $228.00 284506
4/26/2018 Lori Walby 23152 $28.00 284506
4/26/2018 Alecia Bushey 23151 $6.00 284506
4/30/2018 Pet Supplies Farmington Hills 23275 $60.00 284673
5/1/2018 Curtis Brown 23331
April 2018 Total
$10.50
$1,474.81
284767
5/2/2018 Mark Mudd 23379 $5.00 284893
5/4/2018 Renee Henderson 23443 $200.00 285041
5/4/2018 Porferia Mellado 23458 $2.50 285041
5/4/2018 Donation Box 23468 $19.75 285041
5/5/2018 Donation Box 23555 $132.00 281500
5/5/2018 OCACPAC 23564 $120.00 281500
5/7/2018 Donation Box 23652 $25.00 281500
5/7/2018 Roy & Marilyn Hart 23653 $50.00 281500
5/7/2018 Kristine Fougner 23656 $2.50 281500
5/8/2018 Lake Orion Community Schools 23717 $685.54 285150
5/9/2018 Cheryl Kozell 23750 $50.00 285278
5/9/2018 Raymond Wise 23758 $25.00 285276
97
Donations to Animal Shelter
2018 FY - Third Quarter
Date of n Oars
5/9/2018
Donating
John Killinger
eipt Number
23760
Amount
$50.00
Jou Number
285276
5/10/2018 Donation Box 23806 $6.76 285352
5/11/2018 Bill Barbou8r 23759 $25.00 285462
5/11/2018 Helen Gray 23831 $25.00 285462
5/11/2018 William White 23833 $25.00 285462
5/11/2018 Donation Box 23834 $0.75 285462
5/11/2018 Donation Box 23837 $11.00 285465
5/14/2018 Maureen & Scott Gardiner 23930 $60.00 285620
5/15/2018 Natie Reinstein 24032 $36.00 285752
5/17/2018 Joseph Spinale 24092 $50.00 285969
5/18/2018 Elissa Staeuble 24116 $15.00 286039
5/18/2018 John Little 24121 $5.00 286039
5/18/2018 Donation Box 24142 $22.83 286039
5/18/2018 James Mero 24164 $25.00 286039
5/19/2018 Laura Neumann 24210 $262.00 286040
5/22/2018 Donation Box 24378 $10.00 286243
5/22/2018 Michael Ramsey 24379 $50.00 286243
5/22/2018 Sebastian Szamiel 24380 $25.00 286243
5/23/2018 Margo McCuen 24433 $25.00 286412
5/23/2018 Sharon Pampalona 24434 $25.00 286412
5/23/2018 Jodi Zabawski 24435 $50.00 286412
5/23/2018 Amy Cassel 24436 $50.00 286412
5/25/2018 Donna Kammerer 24530 $100.00 286529
5/25/2018 Sarah Eyerman 24553 $18.00 285531
5/26/2018 Terese Piontek 24583 $28.00 286612
5/30/2018 Sandra Fosmoen 24686 $3.50 286857
5/30/2018 Barbara Murphy 24728 $28.00 286857
5/30/2018 Angela Goudeau 24689 $50.00 286855
5/30/2018 Debbie Baselle 24690 $200.00 286855
5/30/2018 Janet McKervey 24691 %Dm 2868551
5/30/2018 Kenneth Duff 24692 $25.00 286855
5/30/2018 Ammon Murray 24700 $25.00 286855
5/30/2018 Donation Box 24724 $4.50 286855
5/31/2018 Donation Box 24787 $21.00 286946
6/1/2018 Sandra Eggleston 24881
May 2018 Total
$30.00
$2,695,13
287060
6/1/2018 Donation Box 24898 $3.75 287057
6/4/2018 Esther Stillman 24992 $50.00 287219
6/4/2018 Paul and Mary Schruba 24995 $100.00 287219
6/4/2018 Lori and Raymond Hall 24999 $50.00 287219
6/5/2018 Gary and Susan Patera 25032 $25.00 287403
6/5/2018 Cheryl Kozel 25057 $50.00 287405
6/6/2018 Donation Box 25064 $18.13 287544
98
Donations to Animal Shelter
2018 FY - Third Quarter
, • - A— ri - t , .1- ,- - eauLLAO , Number
6/6/2018 Mark Mudd 25075 $5.00 287542
6/7/2018 Linda Santo 25117 $50.00 287631
6/8/2018 Brian Covert 25143 $50.00 287720
6/8/2018 Marianne Romsek 25151 $1.00 287720
6/8/2018 Toni Johnstone 25152 $13.50 287720
6/11/2018 Aucado Rescue 25206 $29.50 287818
6/11/2018 Debbie Tedrick 25255 $40.00 287818
6/12/2018 Cristina Nunez-Aguilar 25264 $104.06 287902
6/12/2018 Michael Tiley 25265 $57.50 287902
6/12/2018 Donation Box 25298 $45.09 287902
6/13/2018 Reilly Richardson 25305 $45.00 288039
6/13/2018 Everett Gard 25322 $50.00 288039
6/13/2018 Susan MacKenzie 25323 $50.00 288039
6/13/2018 Dana and Cindy Woodburn 25325 $25.00 288039
6/13/2018 Dana Byrd 25327 $12.00 288041
6/15/2018 Donation Box 25410 $8.22 288247
6/15/2018 Sudha Narang 25416 $100.00 288250
6/16/2018 Ramona Nave 25463 $1,000.00 288251
6/18/2018 Elissa Staeuble 25519 $15.00 288351
6/18/2018 Donation Box 25535 $11.61 288353
6/19/2018 Betty Weinert 25542 $50.00 288411
6/19/2018 Wayne Carpenter 25566 $100.00 288413
6/22/2018 Donation Box 25675 $15.00 288730
6/22/2018 Sallie Garcia 25727 $100.00 288727
6/25/2018 Janet McKervey 25798 $10.00 288804
6/25/2018 Donna Wilder 25808 $100.00 288804
6/25/2018 Donation Box 25831 $9.14 288864
6/28/2018 Rebecca Osborne 25927 $50.00 289098
6/29/2018 Joseph Leahy 25987 $5.00 289175
June 2018 Total $2,478.50
FY 2018 3rd quarter Total $6,648A4
99
Oakland County International Airport
FY 2018 3rd Quarter Report For Contributions (Donations)
April 1, 2018 -June 30, 2018
Date Description Amount
6/29/2018 T-Mobile for OCIA Air Show $ 400.00
Grand Total $ 400.00
100
Source Amount Totals Tuning Your Tot Contribution Park Patron Tuning Your Tot Contribution Teacher at Simonds Our Lady of the Lakes Park Patron $1.00 $1.00 $5.00 1-0-.00 $2.00 $1.00 REC Nature Center Program REC General Contribution REC Nature Center Program REC Animal Care REC Animal Care REC Animal Care Buhl Estate Tours - Educational Presentation ADM OAKLAND COUNTY PARKS & RECREATION COMMISSION FY 2018 3rd Quarter Report for Contributions (Donations) - April 1, 2018 - June 30, 2018 Budget Center Project / Program Recreation Programs & Services Sub-Total Ladies of Charity, St Vincent DePaul $1-60.66 Administration Sub-Total $100.00 FY2018 3rd Quarter Contributions (Donations) Revenue Grand Total $120.00 $20.00 101
Resolution #18322 September 27, 2018
Moved by Fleming supported by McGillivray the resolutions (with fiscal notes attached) on the Consent
Agenda be adopted (with accompanying reports being accepted).
AYES: Crawford, Fleming, Gershenson, Gingell, Hoffman, Jackson, Kochenderfer, KowaII, Long,
McGillivray, Middleton, Quarles, Spisz, Taub, Tietz, Weipert, Woodward, Zack, Berman,
Bowman. (20)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent
Agenda were adopted (with accompanying reports being accepted).
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 September 27,
2018, 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 County of Oakland at
Pontiac, Michigan this 27th day of September, 2018.
Lisa Brown, Oakland County