HomeMy WebLinkAboutResolutions - 2017.06.15 - 22976MISCELLANEOUS RESOLUTION #17170 June 15, 2017 BY: Commissioner Thomas Middleton, Chairperson, Finance Committee
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2017 SECOND QUARTER
FINANCIAL FORECAST AND BUDGET AMENDMENTS
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of
Government, provides for adjustments to the adopted budget; and
WHEREAS in accordance with Oakland County General Appropriations Act Section 22, which authorizes
budget amendments for variances between the budgeted revenue and actual revenue, and Section 23,
which authorizes budget amendments for variance between estimated revenue and projected
expenditures, amendments are required; and
WHEREAS the Fiscal Year (FY) 2017 Second Quarter Financial Forecast Report has identified several
variances and budget amendments are recommended; and
WHEREAS a budget amendment is recommended to return $16,585 from the Sheriff's Office General
Fund to the Sheriffs Law Enforcement Restricted Fund (#21341) due to unspent funds in officer training
(M. R. #15207) ; and
WHEREAS the Sheriffs Office receipt of forfeiture/enhancement funds are recorded in separate restricted
funds that require a transfer to the General Fund for use of the monies. Transfers In from the various
restricted funds in the amount of $31,067 is being recognized for eligible forensic lab and training costs;
and
WHEREAS a FY 2017 budget amendment totaling $5,800 is recommended to reallocate funds from
various Clerk/Register of Deeds line items to more accurately reflect the budget with actual expenditures;
and
WHEREAS a budget amendment is recommended for the Treasurer's Office to reallocate $15,000 from
Title Search to Capital Outlay Miscellaneous for the replacement of office furniture; and
WHEREAS an amendment of $16,994 is recommended in the Health Division to offset the balance
needed for the FY 2010 - 2014 grant cost settlement with Oakland County Community Mental Health
Authority (OCCMHA) for the Medicaid, Healthy Michigan and Adult Benefit Waiver grants; and
WHEREAS a budget amendment is recommended for Veteran's Services to correct the department
number for Planned Use of Balance (M.R. #17016 2017 County Veterans Incentive Grant); and
WHEREAS a budget amendment in the amount of $75,000 is recommended to transfer funds from
Economic Development & Community Affairs (EDCA) to Information Technology fund (#63600) for the
2017 EDCA Digital Marketing Program; and
WHEREAS a budget amendment in the amount of $22,028 is recommended to transfer funds from
Economic Development & Community Affairs to Information Technology fund for the 2017 Oakland Next
Program; and
WHEREAS a budget amendment in the amount of $31,507 is recommended in Economic Development &
Community Affairs for operating revenues and expenditures related to the Fire and Ice Festival, and
WHEREAS a budget amendment is recommended within the Children's Village Division in the amount of
$233 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 funding in the amount of $28,000 from the
General Fund Security Reserve line item to the Project Work Order Fund (#40400 Project
#100000002601) in order to install a six foot fence around the Courthouse Judge's well area; per
Miscellaneous Resolution #15231 which allows for administrative approval of capital improvement
program projects under $30,000; and
WHEREAS $34,936 will be appropriated from the General Fund Assigned Fund Balance for Tr-Party
funding (GL Account #383510) to the General Fund (#10100) for the county's additional Tr-Party project
cost; City of Farmington Hills - Project 50261; additional project costs not greater than fifteen percent from
the original agreement (M.R. #14203) allows for the appropriation of funds in a quarterly forecast
resolution; and
WHEREAS a budget amendment is recommended for 52/1 District Court to reallocate $3,010 from
Contractual Services to $1,500 Drug Testing, $1,260 Special Event Program (Participant Incentives) and
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote with Fleming and Bowman absent.
$250 Office Supplies (Participant Supplies) to reflect Amendment #1 within fifteen percent of the FY 2017
Michigan Drug Court Grant Program (MDCGP) grant agreement (M.R. #16287); and
WHEREAS a budget amendment of $104,356 is recommended for the Sheriff's Office to reallocate
funding from the Overtime account to the Program account in the Sheriff's Michigan Medical Marihuana
Grant for the portion of the overtime funding reimbursed to the local participating police departments; and
WHEREAS a budget amendment is recommended to recognize that the Health Division has received
additional funding from the Michigan Department of Health and Human Services through the
Comprehensive Planning, Budgeting, and Contracting (CPBC) Agreement Amendment #3 in the amount
of $98,250 which is less than fifteen percent of the original agreement required to accept each of the
amendments via separate resolution; and
WHEREAS a budget amendment is recommended to recognize that the Health Division has received
additional funding from MDCH through the Comprehensive Planning, Budgeting, and Contracting (CPBC)
Agreement Amendment #2 in the amount of $127,982 which is less than fifteen percent of the original
agreement required to accept each of the amendments via separate resolution; and
WHEREAS a FY 2017 budget amendment totaling $61,991 is recommended for Community Corrections
to reallocate line items to reflect Amendment #2 within fifteen percent of the FY 2017 Michigan
Department of Corrections Comprehensive Corrections Plan (MR. #16350); and
WHEREAS a Parks and Recreation budget amendment totaling $406,075 is recommended which
includes a $27,854 transfer of Building Maintenance Charges funds from the Facilities Maintenance cost
center to various cost centers incurring expenses during the second quarter of FY2017. Also, Oakland
County Parks and Recreation Commission approved the replacement of golf carts in the amount of
$272,425 and increased the funding for building maintenance of $133,650; and
WHEREAS a budget amendment in the amount of $172,507 is recommended in the Insurance Fund
(#67700) to reallocate funds from Planned Use of Balance to Professional Services, Expendable
Equipment, and Medical Supplies to more accurately reflect the budget with actual expenditures; and
WHEREAS a budget amendment is recommended for the Motor Pool fund (#66100) to reverse the
duplicate first quarter amendment in the amount of $400 per M.R. #17043; the original amendment was
made in the Fiscal 2016 Year End Report (M.R. #16324) correcting the transfer of purchase for one new
2 Wheel Drive Tahoe (M.R. #16181); and
WHEREAS a budget amendment is recommended to transfer funding totaling $39,540 from Information
Technology Fund (#63600) to the Project Work Order Fund (#40400) Project 100000002609 to convert
room 131 from one office to two offices for a total cost of $33,200 and order fourteen sit-to-stand desk
platforms for IT staff on the first floor for a total cost of $6,340; and
WHEREAS the FY 2016 Year End Report included a carry forward amount of $3,672,683 for various
department expenditures to be included in FY 2017; and
WHEREAS per the General Appropriations Act and Miscellaneous Resolution #93156, a review of the
carry forward appropriation has been conducted to determine if the appropriation shall continue for the
remainder of the fiscal year; and
WHEREAS the departments have expended the majority of their carry forward requests and the
remaining balance is expected to be utilized by the end of FY 2017; and
WHEREAS the Oakland County Department of Economic Development and Community Affairs has
attempted to coilect funds from loan recipients for the Community Development Block Grant totaling
$291,984.13 and the Home Investment Partnership Act Accounts totaling $471,167.00 and recommends
$763,151.13 be written off in uncollectible loans; and
WHEREAS the Department of Public Services, Animal Control division has requested a write-off in the
amount of $168 for an uncollectible invoice; and
WHEREAS Department of Health and Human Services, Children's Village division received donations for
the period of January 2017 through March 2017 totaling $4,013; and
WHEREAS Department of Health and Human Services, Health division received a donation in the
amount of $549.52 from Michigan Public Health Institute to be used for health education; and
WHEREAS Sheriff's Office received a donation of six (6) lifesaving body armor vests for their K-9s (Clay,
Bolt, Mordus, Jax, Diago and Odin) from Vested Interest in K-9s, each vest is estimated to be worth
$1,050, total estimated value $6,300; and
WHEREAS Parks & Recreation Commission received donations totaling $645.15 for various programs.
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2017
Second Quarter Financial Report.
BE IT FURTHER RESOLVED that $34,936 be transferred in FY 2017 from the General Fund Assigned
Fund Balance for Tr-Party funding (GL #383510) to Non-Departmental to cover the additional costs for
City of Farmington Hills — Project No. 50261; additional project costs not greater than 15% from the
original agreement (MR. #14203) allows for the appropriation of funds in a quarterly forecast resolution.
GENERAL FUND (#10100) FY 2017
Revenues
9010101-196030-665882 Planned Use of Balance $34,936
Total Revenues $34,936
Expenditures
9010101-153010-740135 Road Commission Tr-Party
Total Expenditures
$34,936
$34,936
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, Health
Division, Sheriff's Office and Parks and Recreation Commission.
BE IT FURTHER RESOLVED that the FY 2017 — FY 2019 Budgets are amended pursuant to Schedules
A and B.
Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution.
ommissioneeThobnas Middleton, District #4
Chairperson, Finance Committee
opoi,Acamousgapwa
1...115.115n,,,=.11- 1
6t.
COUNTY MICHIGAN
MANAGEMENT 84. BUDGET
OAKLAND COUNTY EXECUTIVE L. BROOKS PATTERSON
Laurie Van Pelt, Director
(248) 858-2163 I vanpeltl@oakgov.com
TO: Members of the Finance Committee
FROM: Laurie Van Pelt, Director, Management and Budget
Lynn Sonkiss, Manager, Fiscal Services
Gaia Piir, Chief, Fiscal Services
Ebru Adoglu-Jones, Supervisor of Fiscal Services
SUBJECT: Letter of Transmittal - Fiscal Year 2017 Second Quarter Forecast
DATE: June 8, 2017
de/--
FY 2017 SECOND QUARTER REPORT
Attached please find the Fiscal Year (FY) 2017 Second Quarter Forecast Report. In total, Fiscal
Services forecasts that the County will complete FY 2017 with an overall favorable variance of
$15,498,163 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 $1,848,363 more revenue than anticipated and projected
favorability in expenditures of $13,649,800.
REVENUES
GF/GP revenues are .42% more than budget or $1,848,363. Major variances are the result of the
following events:
A. TAXES — Unfavorable ($192,300)
Unfavorable Property Taxes ($340,000) due to the net change in real property taxable value
which is .33% less than the adopted budget amount. This is partially offset by favorable
Payment in Lieu of Taxes $147,700 in the Treasurer's Office to reflect actual revenue activity for
payments from the State on Department of Natural Resources (DNR) land.
B. STATE GRANTS — Unfavorable: ($695,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. CHARGES FOR SERVICES — Favorable: $2,642,725
Favorable primarily in the County Clerk's Office $700,000 for Recording Fees and $150,000 for
Deeds; Non-Departmental Commission Public Telephone of $500,000 for revenue greater than
anticipated, Children's Village Board and Care $300,000 and Out County Board and Care
$200,000 due to an increase in reimbursement rate from the State; also favorable $215,000
across all Courts primarily reflecting increases in caseload and continued collection efforts;
Reimbursement General $200,000 and $30,000 Soil Erosion Fees in the Water Resources
Commissioners Office; Treasurer's Office $170,000 for Administration Fees, $84,000 for the
County portion of tax reverted land and $72,000 for Deeds.
2100 Pontiac Lake Road County Executive Building 41W I Waterford, MI 48328 I Fax (248) 452-9172 I OakGov.cein
EXPENDITURES
In total, expenditures are projected to be 3.07% under budget or $13,649,800 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 are three departments projected to be unfavorable at the end of the fiscal year (barring any
amendments); Sheriff's Office, Water Resources Commissioner and Facilities Management.
Sheriff — Unfavorable: ($698,300)
• 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.
Water Resources Commissioner — Unfavorable: ($100,000)
• The department is forecasted to be unfavorable primarily due to Drain Equipment Labor
expenditures ($100,000) for employee labor that cannot be charged to other funds. The overall
unfavorability is offset by favorable revenues of $230,000 for Reimbursement General and Soil
Erosion Fees. A budget amendment will be made by year end if the trend continues.
Facilities Management — Unfavorable: ($8,000)
• The department is forecasted to be unfavorable in personnel expenditures primarily due to
employees placed at higher merit step than budgeted positions; partially offset by favorable prior
year revenue of $6,112. 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.
2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 I Fax (248) 452-9172 I OakGov.c2n
Forecast Presentation — Budgetary Perspective
The presentation reflects the true fiscal activity of the County for FY 2017:
Revenues - over/ (under) budget $ 1,848,363
Expenditures — (over)tunder budget 13,649,800
Total Officially Reported Favorability $ 15,498,163
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 $30,730,999 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
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
$ 1,848,363
(30,730,999)
$ (28,882,636)
Expenditure Variance (Comparing Actual to Approved Plan)
GAAP Reported Effect on Fund Balance
13,649,800
$ (15,232,836)
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 2017 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 $15.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 $15.2 million by the end of Fiscal Year 2017. 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 2017-2019 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 2017. However, it should be noted while the amended budget
reflects the utilization of $30.7 million of Fund Balance, this forecast projects the use of Fund Balance
needed to support FY 2017 activities of $15.2 million, $15.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.can
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 SECOND QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2017 FY 2018 FY2019 AMENDMENTS AMENDMENTS AMENDMENTS IOF/OP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aff. Op Unit SHERIFF'S OFFICE Expenditures 4030601 110000 750170 4030601 110000 788001 21341 Account Name Other Expendable Equipment Transfers Out $ (16,585.00) 16,585.00 Total Expenditures Revenues 4030901 4030301 9010101 116240 695500 21340 Transfers In 112580 695500 21397 Transfers In 196030 665882 Planned Use of Balance Total Revenue $ 28,069.00 2,998.00 (31,067.00) CLERK/REGISTER OF DEEDS Expenditures 2010101 180000 730772 Freight and Express (600.00) 2010101 180000 731346 Personal Mileage 600.00 2010101 180000 731395 Printing County Directory (200.00) 2010101 180000 731213 Membership Dues 200.00 2010210 125000 730422 Court Transcripts (3,000.00) 2010201 132300 730247 Charge Card Fees 3,000.00 2010401 172190 750399 Office Supplies (2,000.00) 2010401 172190 730247 Charge Card Fees 2,000.00 Total Expenditures 7
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 SECOND QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) Account Name Title Search Capital Outlay Miscellaneous Total Expenditures Planned Use of Balance Planned Use of Balance Total Revenue Professional Services Transfers Out-Information Technology Fund Total Expenditures HEALTH DIVISION Expenditures 1060201 133150 730373 Contracted Services 1060201 133150 788001 28227 Transfers Out Total Expenditures IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aff. Op Unit TREASURER'S OFFICE Expenditures 7010110 186130 731913 7010101 186040 760126 VETERAN'S SERVICES Revenue 1070301 132050 665882 9010101 196030 665882 ECONOMIC DEVELOPMENT & COMMUNITY AFFAIRS Expenditures 1090201 171000 731458 1090201 171000 788001 63600 FY 2017 FY 2018 FY 2019 AMENDMENTS AMENDMENTS AMENDMENTS $ (15,000.00) 15,000.00 $ (16,994.00) $ 16,994.00 $ 20,000.00 (20,000.00) $ (75,000.00) 75,000.00 1090101 171046 731458 Professional Services 1090101 171046 788001 63600 Transfers Out-Information Technology Fund Total Expenditures $ (22,028.00) $ 22,028.00 8
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 SECOND QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aft. Op Unit Revenues 1090108 172072 650104 FY 2017 FY 2018 FY 2019 AMENDMENTS AMENDMENTS AMENDMENTS Contributions Account Name Total Revenues $ 31,507.00 $ 31,507.00 Expenditures 1090108 172072 750511 CHILD CARE FUND (#20293) Revenues 1060501 112255 695500 Special Event Supplies Total Expenditures 21330 Transfer In - Children's Village Donations Fund Total Revenues 31,507.00 31,507.00 233.00 233.00 Expenditures 1060501 112255 750245 Incentives 233.00 Total Expenditures 233.00 NON-DEPARTMENTAL Expenditures 9090101 196030 9090101 196030 740145 Security Reserve 788001 40400 Transfer Out-Project Work Order Total Expenditures $ (28,000.00) 28,000.00 9
$ $ 2,998.00 2,998.00 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS Dept IQ Program Acct Fund Aff ODer Unit Account Name SHERIFF'S OFFICE - LAW ENFORCEMENT ENHANCE SHERIFF (#21341) Revenue 4030101 116270 695500 10100 Transfers In 4030101 116270 665882 Planned Use of Balance Total Revenue SHERIFFS OFFICE - LAW ENFORCEMENT ENHANCE LAB FEES (#21340) Revenue 4030901 116240 665882 21340 Planned Use of Balance Total Revenue $ 16,585.00 $ (16,585.CA $ $ 28,069.00 $ 28,069.00 Expenditures 4030101 112580 788001 10100 Transfer Out - to Sheriff $ 28,069.00 Total Expenditures $ 28,069.00 SHERIFFS OFFICE - SHERIFF BOOKING FEE TRAINING (#21397) Revenue 4030301 112580 665882 Planned Use of Balance Total Revenue Expenditures 4030301 112580 788001 10100 Transfer Out - to Sheriff $ 2,998.00 Total Expenditures $ 2,998.00 HEALTH FUND #28227 OSAS ADULT BENEFIT WAIVER GRANT Revenue 1060261 134790 695500 10100 Transfers In $ 16,994.00 $ 16,994 00 10
Expenditures 9010101 112255 788001 20293 Transfer Out - Child Care Fund Total Expenditures $ 233.00 $ 233,00 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Expenditures 1060261 134790 730044 Adj Prior Years Revenue $ 16,994.00 Total Revenue $ 16,994.00 INFORMATION TECHNOLOGY FUND (#63600) Revenue 1080101 152000 695500 10100 Expenses 1080201 152000 731458 Revenue 1080101 152000 695500 10100 Expenses 1080201 152000 731458 CHILDREN'S VILLAGE DONATIONS FUND (#21330) Revenues 9010101 112255 665882 Transfer In - General Fund $ 75,000.00 Total Revenue $ 75,000.00 Professional Services $ 75,000.00 Total Expenses $ 75,000.00 Transfer In - General Fund $ 22,028.00 Total Revenue $ 22,028.00 Professional Services $ 22,028.00 Total Expenses $ 22,028.00 Planned Use of Balance $ 233.00 Total Revenues 233.00 11
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Project Work Order Fund (#4Q400 PCBU: FACMG, Project: 100000002601 Activity: Proj Revenue 1040101 148020 695500 10100 Expenditures 1040101 148020 796500 Transfer In - General Fund Total Revenues Budgeted Equity Adjustments Total Expenditures 28,000.00 28,000.00 28,000 00 28,000.00 DRUG COURT DISTRICT 52 1 SCAO (FUND #27151) GR0000000661 Activity GLB, Analysis Type GLB, Budget Ref 2017 Expenditures 3020205 121050 730548 3020205 121050 731818 3020205 121050 750399 3020205 121050 730373 Drug Testing Special Event Program Office Supplies Contracted Services Total Expenditures 1,500.00 1,260.00 250.00 (3,010.00) SHERIFFS OFFICE - MICHIGAN MEDICAL MARIHUANA (#27323) Expenditures 4030901 110090 712020 Overtime 4030901 110090 731465 Program (104,366.00) 104,356.00 12
1060235 1060235 1060235 1060235 1060235 1060235 1060235 1060235 1060235 1060235 1060235 1060235 1060235 133970 133970 133970 133970 133970 133970 133970 133970 133970 133970 133970 133970 133970 702010 722740 730926 730982 731339 731346 731458 732018 750168 750245 750301 750399 750567 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name HEALTH - Nurse Family Partnership GR0000000279 Bud Ref: 2017 Activity: GLB Analysis: GLB Federal Operating Grants State Operating Grants Total Revenues Training Salaries Regular Fringe Benefits Indirect Costs Interpreter Fees Publications Personal Mileage Professional Services Travel and Conference Equipment Incentives Medical Supplies Office Supplies Training-Educational Supplies 300.00 5,700.00 6,000.00 6,000.00 6,000.00 78,333.00 78,333.00 18,299.00 11,537.00 (345.00) (2.00) 1,000.00 300.00 6,000.00 6,690.00 20,000.00 3,000.00 200.00 1,000.00 1,250.00 Revenues 1060230 133215 610313 1060230 133215 615571 Expenditures 1060230 133215 731941 Total Expenditures HEALTH - TB Outreach (#28556) GR0000000192 Bud Ref: 2017 Activity: GLB Analysis: GLB Revenues 1060235 133970 610313 Federal Operating Grants Total Revenues Expenditures 13
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID, Program Acct Fund Aff Oper Unit Account Name 1060235 133970 770631 Bldg Space Cost Allocation 1060235 133970 774636 Info Tech Operations 1060235 133970 778675 Telephone Communications Total Expenditures HEALTH - WIC (#28553) GR0000000205 Bud Ref: 2017 Activity: GLB Analysis: GLB Revenues 1060284 133271 610313 Federal Operating Grants Total Revenues Expenditures 3,000.00 4,760.00 1,644.00 78,333.00 13,917.00 13,917.00 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 133271 133271 133271 133271 133271 133271 133271 133271 133271 133271 133271 133271 702010 722740 730072 730926 731346 731388 731941 750294 750301 750399 774677 778675 Salaries Regular Fringe Benefits Advertising Indirect Costs Personal Mileage Printing Training Materials & Supplies Medical Supplies Office Supplies Insurance Fund Telephone Communications • Total Expenditures 20,418.00 (13,583.00) 93.00 1,880.00 320.00 1,000.00 300.00 1,486.00 (316.00) 300.00 (231.00) 2.250.00 13,917.00 14
OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY1SPECIAL REVENUE FUNDS FY 2017 SCHEDULE B FY 2018 FY 2019 AMENDMENTS AMENDMENTS AMENDMENTS 1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aft Oper Unit HEALTH - Adolescent Screening CPBC (#283101 GR0000000689 Bud Ref: 2017 Activity: GLB Analysis: GLB Revenues 1060234 133120 610313 Account Name $ 29,000.00 Federal Operating Grants Expenditures 1060234 133120 750280 Total Revenues $ 29,000.00 Laboratory Supplies Total Expenditures $ 29,000.00 $ 29,000.00 HEALTH - PHEP (#28610) GR0000000750 Bud Ref: 2017 Activity: GLB Analysis: GLB Revenues 1060290 115010 610313 Expenditures Federal Operating Grants $ 33,776.00 Total Revenues $ 33,776.00 1060290 1060290 1060290 1060290 1060290 1060290 1060290 115010 115010 115010 115010 115010 115010 115010 731346 731780 750077 750448 774636 774637 778675 Personal Mileage Software Support Maintenance Disaster Supplies Postage-Standard Mailing Info Tech Operations Info Tech Managed Print Svcs Telephone Communications Total Expenditures $ (852.00) $ (565.00) $ 34,000.00 $ (4.00) $ 700.00 $ (1,879.00) $ 2,376.00 $ 33,776.00 HEALTH - PHEP (#28610) GR0000000750 Bud Ref: 2017 Activity: GLB Analysis: GLB Revenues 1060290 115035 610313 Federal Operating Grants $ 24,196.00 Total Revenues $ 24,196.00 15
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Expenditures 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 115035 115035 115035 115035 115035 115035 115035 115035 115035 115035 115035 115035 115035 722740 730646 731388 731458 731780 731941 732165 750077 750399 750448 770631 777560 778675 Fringe Benefits Equipment Maintenance Printing Professional Services Software Support Maintenance Training Workshops and Meetings Disaster Supplies Office Supplies Postage-Standard Mailing Bldg Space Cost Allocation Radio Communications Telephone Communications Total Expenditures (7,087.00) 1,000.00 5,742.00 12,480.00 (5,000.00) 1,603.00 (105.00) 520.00 7,458.00 350.00 3,051.00 4,040.00 144.00 24,196.00 HEALTH - EVD Phase II (#28614) GR0000000724 Bud Ref: 2017 Activity: GLB Analysis: GLB Revenues 1060290 133021 610313 Federal Operating Grants (1,990.00) (1,990.00) Total Revenues Expenditures 1060290 133021 1060290 133021 1060290 133021 1060290 133021 702010 722740 730926 731388 Salaries Regular Fringe Benefits Indirect Costs Printing (27,983.00) (22,338.00) (4,209.00) 1,704.00 16
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 1060290 133021 731941 Training $ 15,000.00 1060290 133021 750077 Disaster Supplies $ 35,836.00 Total Expenditures $ (1,990.00) HEALTH - MCH Block (#28563) GR0000000207 Bud Ref: 2017 Activity: GLB Analysis: GLB Revenues 1060291 133190 610313 Federal Operating Grants $ 15,000.00 Total Revenues $ 15,000.00 Expenditures 1060291 133190 1060291 133190 1060291 133190 1060291 133190 702010 722740 730926 731458 Salaries Regular Fringe Benefits Indirect Costs Professional Services Total Expenditures 6,277.00 3,785.00 (945.00) 5,883.00 $ 15,000.00 HEALTH - West Nile Virus (#28690) GR0000000722 Bud Ref: 2017 Activity: GLB Analysis: GLB Revenues 1060220 134870 610313 Federal Operating Grants Total Revenues Expenditures $ 8,000.00 $ 8,000.00 1060220 134870 702010 Salaries Regular $ 3,078.00 1060220 134870 722740 Fringe Benefits $ 2,573.00 1060220 134870 730926 Indirect Costs $ 367.00 17
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS Expenditures 1060220 134865 702010 1060220 134865 722740 Advertising Printing Postage-Standard Mailing Training-Educational Supplies Total Expenditures Salaries Regular Fringe Benefits 1,083.00 228.00 671.00 8,000.00 10,000.00 10,000.00 3,000.00 1,700.00 300.00 5,000.00 10,000.00 10,000.00 10,000.00 3,843.00 2,840.00 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff °ger Unit Account Name .1060220 134870 731346 Personal Mileage 1060220 134870 732018 Travel and Conference 1060220 134870 750399 Office Supplies Total Expenditures HEALTH - Zika Virus (#28618) GR0000000785 Bud Ref: 2017 Activity: GLB Analysis: GLB Revenues 1060233 134865 610313 Federal Operating Grants Total Revenues Expenditures 1060233 134865 730072 1060233 134865 731388 1060233 134865 750448 1060233 134865 750567 HEALTH - Zika Virus (#28618) GR0000000786 Bud Ref: 2017 Activity: GLB Analysis: GLB Revenues 1060220 134865 610313 Federal Operating Grants Total Revenues 18
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS- SELF BALANCING AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS Dept ID Program Acct Fund Aft Oper Unit Account Name 1060220 134865 730926 Indirect Costs 1060220 134865 731346 Personal Mileage 1060220 134865 750399 Office Supplies Total Expenditures COMMUNITY CORRECTIONS (#27370) GR0000000772 Bud Ref: 2017 Activity: GLB Analysis: GLB Expenditures 458.00 1,874.00 985.00 10,000.00 PARKS AND RECREATION FUND (#50800) Revenues 5060666 160666 665882 5060666 160666 665882 1070401 1070401 1070401 1070401 1070401 4030301 4030301 1070401 Expenses 5060356 5060328 5060330 5060910 123010 123010 113130 113120 113120 113000 113000 113000 160010 160010 160010 160430 702010 722740 731458 702010 722740 702010 722740 773630 750154 750154 750154 730198 Salaries Fringe Benefits Professional Services Salaries Fringe Benefits Salaries Fringe Benefits Contracted Services Total Expenditures Planned Use of Balance Planned Use of Balance Total Revenues Expendable Equipment Expendable Equipment Expendable Equipment Building Maintenance Charges (15,500,00) (9,500.00) (20,000.00) (6,200.00) (3,800.00) (4,464.00) (2,527.00) 61,991.00 133,650.00 27Z 425.00 406,075.00 136,213.00 21,794.00 114,418.00 133,650.00 19
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060720 160070 730198 Building Maintenance Charges 5060715 160070 730814 Grounds Maintenance 5060724 160070 730814 Grounds Maintenance 5060725 160070 730814 Grounds Maintenance 5060735 160070 730814 Grounds Maintenance 5060755 160070 730814 Grounds Maintenance 5060760 160070 730814 Grounds Maintenance 5060831 160210 730814 Grounds Maintenance 5060910 160430 730198 Building Maintenance Charges Total Expenses 374.00 7,203.00 800.00 8,937.00 2,950.00 800.00 800.00 5,990.00 (27,854.00) 406,075.00 INSURANCE FUND (#67700) Revenue 9015501 182210 665882 Planned Use of Balance 172,507.00 Total Revenue 172,507.00 Expenses 1010502 182000 731458 Professional Services 33,882.00 1010502 182000 750154 Expendable Equipment 63,585.00 1010502 182000 750301 Medical Supplies 75,040.00 Total Expenses 172,507.00 MOTOR POOL FUND (#66100) Revenues 1030811 184010 695500 10100 Transfer In-Gen. Fund (400.00) Total Revenue (400.00) Expenses 1030811 184010 796500 Budgeted Equity Adjustment Total Expenses (400.00) (400.00) 20
OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2017 SCHEDULE B FY 2018 FY 2019 AMENDMENTS AMENDMENTS AMENDMENTS 'PROPRIETARY/ SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name INFORMATION TECHNOLOGY FUND (#636001 Revenue 1080101 152000 665882 Planned Use of Balance Total Revenue 39,540.00 39,540,00 Expenses 1080101 152000 788001 40400 Transfers Out - Project Work Order Fund $ 39,540.00 Total Expenses $ 39,540.00 PROJECT WORK ORDER FUND (#40400) PCBU: FACMG, Project: #100000002609, Activity: PROJ Revenue 1040101 148020 695500 63600 Transfers In - Information Technology Total Revenue 39,540.00 39,540.00 Expenditures 1040101 148020 796500 Budgeted Equity Adjustments Total Expenditures 39,540.00 39,540.00 21
COUNTY OF OAKLAND
FY 2017 SECOND QUARTER REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2017
ADOPTED
BUDGET
BUDGET
AS
AMENDED
FY 2017
FORECAST
AMOUNT
FAVORABLE/
(UNFAVORABLE) PERCENT
REVENUES
GENERAL FUND
Taxes
Federal Grants
State Grants
Other Intergovernmental Revenue
Charges for Services
Indirect Cost Recovery
Investment income
Other Revenues
$ 216,275,088.00
702,685,00
20,328,603.00
44,205,554,00
107,492,920.00
8,000,000.00
1,904,900.00
12,621,827.00
$ 216,275,088.00 $ 216,082,788.00 $ (192,300.00)
708,785.00 733,785.00 25,000.00
20,181,679.00 19,486,679.00 (695,000.00)
44,205,554.00 44,205,554.00
108,955,635.00 111,598,360.00 2,642,725,00
8,000,000.00 8,000,000.00
1,904,900.00 1,904,900.00
13,081,975.00 13,149,913.00 67,938.00
-0.09%
3.53%
-3.44%
0.00%
2.43%
0.00%
0,00%
0.52%
SUB-TOTAL GENERAL FUND/GENERAL PURPOSE $ 411,531,577.00 $ 413,313,616.00 $ 415,161,979.00 $ 1,848,363.00 0,45%
PLANNED USE OF FUND BALANCE $ 32,532,802,00 $ 30,730,999.15 $ 30,730,999.15 0.00%
TOTAL GF/GP FUNDS $ 444,064,379.00 444,044,615.16 $ 446,892,978.15 1 848 363 00 0.42%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
62nd District Court
Probate Court
$ 52,615,792.00
17,094,806,00
6,381,257.00
$ 53,400,510.87
16,933,876.00
6,318,617.00
47,095,310.87
16,588,876,00
6,173,617.00
$ 6,305,200.00
345,000.00
145,000.00
11,81%
2.04%
2,29%
TOTAL ADMIN. OF JUSTICE $ 76,091,855.00 $ 76,653,003.87 $ 69,857,803.87 $ 6,795,200.00 8.86%
LAW ENFORCEMENT
Prosecuting Attorney
Sheriff
TOTAL LAW ENFORCEMENT
GENERAL GOVERNMENT
Clerk/Register of Deeds
Treasurer
Board of Commissioners
Library Board
Water Resources Commissioner
20,021,946.00
146,495,179.00
10,613,623.00
8,784,820.00
2,896,745.00
1,343,140.00
5,688,932.00
19,757,525.00
146,424,944.00
10,788,528.00
8,942,298.00
2,999,185.00
1,340,471.87
5,861,425.00
19,363,825.00
147,123,244,00
9,672,328.00
8,738,498.00
2,958,185.00
1,338,871.87
5,961,425,00
393,700.00
(698,300.00)
1,116,200,00
203,800.00
41,000.00
1,600.00
(100,000 ,00)
1.99%
-0.48%
10.36%
2.28%
1.37%
0.12%
-1.71%
$ 166,517,125.00 $ 166,182,469.00 8 166,487,069.00 $ (304,600.00) -0.18%
TOTAL GENERAL GOVERNMENT
$ 29,327,260.00 $ 29,931,907.87 $ 28,669,307.87 8 1,262,600.00 4.22%
COUNTY EXECUTIVE
County Executive Admn.
Management and Budget
Central Services
Facilities Management
Human Resources
Health and Human Services
Public Services
Economic Dev. and Comm Affairs
$ 7,592,192.00 3 7,532,534,00
19,823,114.00 19,948,894.34
2,594,626.00 2,611,372.00
1,282,266.00 1,260,568.00
4,402,468.00 4,626,915,00
65,294,635.00 65,128,507.07
17,504,029.00 17,437,742.00
8,141,811.00 8,288,376.00
$ 7,532,534,00 $
18,506,894.34
2,611,372,00
1,268,568.00
4,385,815.00
62,066,907.07
17,209,142.00
7,662,076.00
1,442,000.00
-
(8,000.00)
241,100.00
3,061,600.00
228,600.00
626,300.00
0.00%
7,23%
0.00%
-0,63%
5.21%
4,70%
1.31%
7,56%
TOTAL COUNTY EXECUTIVE $ 128,635,141.00 $ 126,834,908.41 $ 121,243,308.41 $ 5,591,600.00 4.41%
TOTAL DEPARTMENTS $ 398,671,381.00 $ 399,602,289.15 $ 386,257,489.15 3 13,344,800.00 3,34%
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTAL
45,492,998,00 $ 44,442,326.00 $ 44,137,326.00 305,000.00 0.69%
TOTAL GOVERNMENTAL EXPENDITURES 444,064,379.00 $ 444 044 615 15 $ 430,394,816.16 $ 13,649,800.00 3.07%
General Fund/General Purpose
Favorable/(Unfavorable) - Budget Perspective 15,498,163.00 $ 15,498,163.00
GAAP Required Adjustment (eliminating use of fund balance "revenue") $ (30,730,999.16) $ (30,730,999.15)
GAAP - BASED REPORT (forecasted Impact on Fund Balance) ($15,232,836.15) ($16,232,836.15)
22
Other Taxes -Trailer Tax Total Taxes 80,000.00 80,000.00 80,000.00 $ 216,275,088.00 $ 216,275,088.00 $ 216,082,788.00 $ (192,300.00) 0.00% -0.09% Total Federal Grants 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 702,685.00 $ 708,785.00 $ 733,785.00 $ 25,000.00 - $ 1,000.00 - $ 1,000.00 - $ 1,000,00 4,709,523.00 40,000.00 4,730,006.00 40,000.00 4,730,006.00 45,000.00 15,578,050.00 20,000.00 15,390,673.00 20,000.00 14,690,673.00 5,000,00 (700,000.00) COUNTY OF OAKLAND GENERAL FUND GENERAL PURPOSE REVENUES FY 2017 SECOND QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES TAXES (601000-601999) Property Taxes - July Tax Levy $ 215,796,588.00 $ 215,796,558.00 $ 215,456,585.00 $ (340,000.00) -0.16% Unfav, due to the net change in real property taxable value which is .33% less than the adopted budget amount. Other Taxes - Delinquent Tax - Prior Years 98,500.00 98,500.00 98,500.00 0.00% Treasurer Payment in Lieu of Taxes 300,000.00 300,000.00 447,700.00 147,700.00 49.23% Fay. due to tax payments from the state on DNR land. 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 8.33% Fay. Refunds School Meals (lunch program) primarily due to an increase in population at Children's Village as well as an increase in per meal reimbursement rate from the State. 3.53% 0.00% 0.00% 0.00% 0.00% 0.00% 12.50% Fay - Storm Asset Management Wastewater (SAW) grant $6,000 due to revenue reimbursement being more than anticipated budget projection. 0.00% -4.55% 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. FEDERAL GRANTS (610000-610999) Sheriff-Patrol Sheriff Sheriff - Investigative/Forensic Services Prosecuting Attorney Homeland Security - Disaster Control Health Division Children's Village 5 27,220.00 205,000.00 60,800.00 109,665.00 300,000.00 27,220.00 205,000.00 78,167.00 98,398.00 300,000.00 27,220.00 205,000.00 78,167.00 98,398.00 325,000.00 25,000.00 Total State Grants $ 20,328,603.00 $ 20,181,579.00 $ 19,485,579.00 $ (695,000.00) -3.44% OTHER INTER-GOVERNMENTAL REVENUES (620000 - 626999) 0.00% 0.00% 0.00% 0.00% 0.00% Non-Departmental HHS - Homeland Security Circuit Court District Court Sheriff $ 41,988,159.00 18,000.00 4,500.00 1,800.00 263,675.00 $ 41,988,159.00 18,000.00 4,500.00 1,800.00 263,675.00 $ 41,988,159.00 $ 18,000.00 4,500.00 1,800.00 263,675.00 23
CHARGES FOR SERVICES (630000-635999) Administration of Justice Circuit Court - Judicial/Administration Circuit Court - Circuit Court - Family Division District Court - Division I (Novi) District Court Division II (Clarkston) District Court- Division ill (Rochester Hills) 1,800,000.00 4,099,200.00 1,730,200.00 3,558,900.00 1,800,000.00 4,099,200.00 1,730,200.00 3,555,900.00 1,770,000.00 3,899,200.00 1,780,200.00 3,538,900.00 - $ - $ - $ 2,436,000.00 2,436,000.00 2,476,000.00 40,000.00 (30,000.00) (200,000.00) 50,000.00 250,000.00 COUNTY OF OAKLAND GENERAL FUND GENERAL PURPOSE REVENUES FY 2017 SECOND QUARTER REPORT Non-Departmental - Reimb Judges Salaries Total Other Intergovernmental Revenue ADOPTED BUDGET 1,929,420.00 44,205,554.00 $ AMENDED BUDGET 1,929,420.00 44,205,554.00 AMOUNT FY 2017 FAVORABLE FORECAST (UNFAVORABLE) 1,929,420,00 - $ 44,205,554.00 $ PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 0.00% 0.00% 0.00% 1.64% Fav. E Filing Fees $25,000 due to unanticipated E-Filing revenue. Fav. Court Costs $25,000 due to more than anticipated revenue. Partially offset by unfav. Jury Fees ($10,000) due to reduction in jury trials. -1.67% Unfav. Govt Benefit Board and Care ($15,000) along with Refund Fees PD Def Attorney ($15,000) due to an unanticipated reduction in revenue. -4.88% Unfav. Probation Fees ($150,000) and Ordinance Fines and Costs ($50,000) due to a reduction in caseload. 2.59% Fav. State Law Costs due to an increase in Criminal/Traffic caseload and continued collection efforts. 6.97% Fav. Ordinance Fines and Costs $300,000 based on continued collection efforts. Partially offset by unfav. Probation Fees ($50,000) due to probationer's inability to pay monthly Probationary Oversight Expense. 3.33% Fay. Ordinance Fines and Costs $50,000 based on continued collection efforts. Fay. Refund Fees PD Def Attorney $25,000 due to an increase in public defender requests. 5.91% Fay. Gross Estate Fees $40,000 due to an increase in fees paid. Partially offset by unfav. Refund Fees PD Def Attorney ($10,000) due to a decrease in activity. 1.31% 32.28% Fay. Reim General $77,000 due to Juvenile Resentencing reimbursement from the state, Also fav, State Approp Victim Witness $26,100 and Microfilming $2,500 due to increased activity. Partially offset by unfav. Welfare Fraud Case Review ($12,000) due to the State performing the review in-house. 126.32% Fay. Reimbursement General due to auction of abandoned vehicles. -27.75% Unfav. Gun Registrations ($200,000) as income is directed to County clerk per M1 Firearms Act 207. Partially offset by Fav. Fingerprints $50,000 due to requirement that new teachers be fingerprinted. District Court - Division IV (Troy) 2,249,781.00 2,249,781.00 2,324,781.00 75,000.00 Probate Court - Estates and Mental Health 507,600.00 507,600.00 537,600.00 30,000.00 Total Administration of Justice $ 16,411,681.00 $ 16,411,681.00 $ 16,626,681.00 $ 215,000.00 Law Enforcement Prosecuting Attorney 294,800.00 $ 290,000.00 383,600.00 $ 93,600.00 Sheriffs Office 1,900.00 1,900.00 4,300.00 2,400.00 Sheriff -Administrative Services 432,400.00 432,400.00 312,400.00 (120,000.00) 24
COUNTY OF OAKLAND GENERAL FUND !GENERAL PURPOSE REVENUES FY 2017 SECOND QUARTER REPORT Sheriff Corrective Services ADOPTED BUDGET 3,155,266.00 AMENDED BUDGET 3,155,266.00 FY 2017 FORECAST 3,255,266.00 AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 100,000.00 3.17% Fay. Diverted Felon revenue of $300,000 due to higher number of inmates with certain offenses that are billable to the state and a nominal per diem reimbursement rate increase. Partially offset by Unfav. Reimb Salaries ($150,000) due to declining reinbursements from State Criminal Alien Assistance Program, Fee Income ($20,000) and Clinic Charges (20,000) from inmates inability to reimburse for clinic services. Sheriff - Corrective Services Satellites Sheriff - Emergency Preparedness Training and Communications 565,278.00 894,450.00 565,278.00 894,450.00 565,278.00 744,450,00 (150,000.00) 0.00% -16.77% Unfav. ($150,000) due to the decline in number of foreclosures and civil service requests (see corresponding favorability in Fees Civil Service expenditures). Sheriff - Patrol Services 48,455,029.00 49,589,894.00 49,589,594.00 0.00% Sheriff - Emergency Communications Operations Sheriff - Investigative Forensic Services 1,536,000.00 1,015,000.00 1,586,950.00 1,015,000.00 1,586,950.00 1,165,000.00 150,000.00 0.00% 14.78% Fay. Drug Testing $100,000 collected from Results Program and probation clinics. Also fay. Reimb Salaries 650,000 from unbudgeted billable activity. Total Law Enforcement $ 58,349,123.00 $ 57,531,138.00 $ 57,607,138.00 $ 75,000.00 0.13% General Government Clerk - County Clerk $ 2,215,600.00 $ 2,215,600.00 $ 2,309,200.00 $ 93,600,00 4.22% Fay. Photostats $100,000, CVR County Portion $17,000, and Garnishment Fees $10,000 due to increased activity. Also favorable, E-Filing Fees $24,700 due to extension of pilot project; awaiting legislation approval of new statewide E-filing system. Partially offset by unfavorable Civil Action Entry Fees ($50,000) due to less than anticipated activity. Clerk - Elections 82,900.00 161,900.00 194,500.00 32,600.00 20:14% Fay, due to Election Filing Fees Late $30,600 due to Corporation Counsel efforts to collect on late filers Passport Fees $4,800, and Photographs $1,000 due to increased activity. Partially offset by unfavorable Voter Registration Application ($3,800) due to less than anticipated activity. 25
COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2017 SECOND QUARTER REPORT Clerk - Register of Deeds & Micrographics ADOPTED BUDGET 11,304,500.00 AMENDED BUDGET 11,304,500.00 FY 2017 FORECAST 12,130,000.00 AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 825,500.00 7.30% Fay. Revenue is favorable due to a legislative change, effective October 1, 2016. Per PA 224 of 2016, the fee structure for recording a document at the county level changed to a flat fee of $30. The Clerk Register of Deeds office will be charging $30 per recorded document regardless of number of document pages. The following accounts will be affected: Recording Fees $700,000 and Deeds $150,090. In addition, partially offset by unfavorable Reimb. General ($15,000), Mortgages ($6,600) due to less than antincipated use. Treasurer Board of Commissioners Library Board Water Resources Commissioner 5,032,300.00 12,500.00 14,000.00 1,953,732.00 5,032,300.00 12,500.00 14,000.00 1,953,732.00 5,307,400.00 12,500.00 14,000.00 2,183,732.00 275,100.00 230,000,00 5.47% Fav. Admin Fees $170,000, Tax Reverted Land Co Portion $84,000, Deeds $72,000 Partially offset by unfavorable Tax Statements ($47,600), and Photostats ($3,200) due to reduced activity. 0.00% 0.00% 11.77% Fay - Reimbursement General $200,000 a result of Drain Administration able to charge more time than anticipated to special revenue and proprietary funds. Fav - Soil Erosion Fees $30,000 increase in building activity/permits due to improvement in the housing market. Partially offset by Drain Equipment labor expenditures. Total General Government $ 20,615,532.00 $ 20,694,532.00 $ 22,151,332.00 $ 1,456,800.00 7.04% County Executive County Exec - Compliance Office 230,000.00 $ 230,000.00 $ 230,000.00 0.00% M&B Equalization Division 3,260,000.00 3,260,000.00 3,290,000.00 30,000.00 0.92% Fay. Reimbursment Equalization Services $30,000 due to contract billing vs budget. M&B - Fiscal Services Division Central Services - Support Services Human Resources HHS - Administration 505,600.00 316,780.00 475.00 505,600.00 316,780.00 475.00 505,600.00 316,780.00 (475.00) 0.00% 0.00% -100.00% Unfav. Miscellaneous ($475) fees no longer collectible due to a procedural change. 0.00% 26
339,000.00 914,700.00 339,000.00 913,200.00 339,000.00 913,200.00 24,000.00 24,000.00 453,318.00 455,818.00 455,818.00 $ 13,399,772.00 5 13,601,472.00 $ 13,996,397.00 $ 1,216,812.00 716,812.00 $ 716,812,00 500,000.00 500,000.00 2,642,725.00 716,812.00 $ 108,955,635.00 $ 8,000,000.00 $ 1,216,812.00 $ 111,598,360.00 $ 8,000,000.00 716,812.00 $ 107,492,920.00 $ 8,000,000.00 0.00% 1,500.00 0.16% Fay. Fee Income $1,000 due to citation tickets, 0.00% (24,000.00) -100.00% Unfav. Seminars/Conferences revenue for Business Roundtable is not expected to materialize in FY2017. 0.00% 394,925.00 2.90% 69.75% Favorable Commission Public Telephone revenue greater than anticipated. 69.75% 2.43% 0.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) COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2017 SECOND QUARTER REPORT HHS - Health Division ADOPTED BUDGET 4,281,399.00 AMENDED BUDGET 4,281,399.00 FY 2017 FORECAST 4,183,399.00 AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES (98,000.00) -2.29% Unfav. Clinic Charges ($99,500) due to revenues being captured in another account (Administration Fees); Unfav. Laboratory Charges 3rd Party ($114,600) due to a delay in the start of program. Unfav. Diff Between Chg and Init Pay ($66.500) due to increased 3rd party billing and contractual write-offs. Partially offset by fay. Permits $88,400 due to increased demand for private sewage and water permits. Fay. Administration Fees $53,200 due to increased Medicaid billing of administration fees and capturing revenues from another account (Clinic Charges). Fay. Inspection Fees $34,300 due to increased enfrocement activity. 500,000.00 HHS - Children's Village HHS - Homeland Security Public Services - Community Corrections Public Services - MSU Extension 2,865,000.00 190,000.00 21,000.00 3,064,200.00 190,000.00 21,000.00 3,564,200.00 190,000.00 6,900.00 16.32% Fav. Board and Care $300,000 as well as Out County Board and Care $200,000 due to increase in reimbursement rate from the State. 0.00% 0.00% (14,100.00) -67.14% Unfav. Reimbursement General due to staffing changes and classes no longer being offered by Oakland County. INVESTMENT INCOME (655000-6559991 District Courts (Div. I - IV) 2,400.00 $ 2,400.00 $ 2,400.00 $ 0.00% Sheriff Corrective Services 0.00% Sheriff Investigative/Technical Services 0.00% Treasurer 100,000.00 100,000.00 100,000.00 0.00% Clerk/Register of Deeds 2,500.00 2,500.00 2,500.00 0.00% 27
COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2017 SECOND QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Economic Development 0.00% Non-Departmental 1,800,000.00 1,800,000.00 1,800,000.00 0.00% Total Investment Income $ 1,904,900.00 $ 1,904,900.00 $ 1,904,900.00 $ 0.00% OTHER REVENUES (670000-695500) Circuit Court-Donations 18,940.00 $ 18,940.00 $ 0.00% Circuit Court-County Auction 0.00% Circuit Court 0,00% District Courts (Div. I - IV) 0.00% Probate Court 0.00% Prosecuting Attorney 0.00% Sheriff Office 5,000.00 5,000.00 5,000,00 0.00% Sheriff -Administrative Services 0,00% Sheriff - Corrective Services 800.00 800.00 100.00% Fay. Refund of Prior Years Expenditures. Sheriff - Corrective Services-Satellites Sheriff- Emergency Prep and Communications Sheriff- Emergency Communications Operations Sheriff- Patrol Services Sheriff- Investigative/Forensic Svc 6,000.00 6.000.00 6,000,00 13.100.00 13,100.00 0.00% 0.00% 0.00% 0.00% 100.00% Fav. Refund of Prior Years Expenditures for reimbursement of Sheriffs overtime. 600.00 Clerk/Register of Deeds Treasurer Board of Commissioners Library Board Water Resources Commissioner County Exec - Compliance Office Management and Budget - Fiscal Services Central Services - Support Services Facilities Management Engineering Health Division - Contributions Health Division Health Division - Transfers In Children's Village Children's Village - Transfers In 950.00 950.00 100.00% Fay. Due to cash overages. 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 6,112.00 100.00% Fay. Refund Prior Years Expenditure due to the refund payment error to vendor. 600.00 100.00% Fay. Due to $549 donation from Michigan Public Health Institute for Health Education Program. 9,862.00 100.00% Fay. primarily due to Refund Prior Years Expenditure in order to reflect refund for vaccines. 0.00% 17,875.- 00 17,875.00 100,00% Fay. Prior Years Adjustments to adjust accounts payable for amounts previously accrued but determined to be no longer required. 5,533.00 5,533,00 0.00% 600.00 600.- 00 6,112.00 600.00 9,862.00 28
Homeland Security Public Services - Medical Examiner Public Services -Animal Control-Other Revenues Public Services -Animal Control-Transfers In Economic Development & Comm Affairs - Other Economic Development - Contributions Non Departmental - Donations Non-Dept - Sundry Sheriffs Transfers Treasurers' Transfers ADOPTED BUDGET 44,263.00 29,240.00 417,500.00 71,046.00 3,048,178.00 AMENDED BUDGET 44,263.00 29,240.00 417,500.00 506,721.00 3,048,178.00 FY 2017 FORECAST 21,535.00 35,000.00 35,507.00 417,500.00 506,721.00 3,048,178.00 COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2017 SECOND QUARTER REPORT AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 21,635,00 100.00% Fav. Refund Prior Years Expenditure primarily due to the recovery of costs associated with accidental damage caused to one outdoor warning system. Revenue favorabifity is offset in expenditure accounts (Maintenance Contract and Tornado Siren Equip). 0.00% 0.00% (44,263.00) -100.00% Unfav. Transfers In budgeted with M.R. #14275 not anticipated in FY 2017. 35,000,00 100.00% Fav.Prior Year Expenditures $35,000 due to refund of Software Maintenance for 2016 Collaborative Development Council Grant. 6,267.00 21.43% Fay. due to Fire and Ice Festival. 0.00% 0.00% 0.00% 0.00% Non-Departmental - Transfers In 9,000,000.00 9,000,000.00 9,000,000.00 0.00% Total Other Revenues $ 12,621,827.00 $ 13,081,975.00 13,149,913.00 $ 67,938.00 0.52% PLANNED USE OF FUND BALANCE (665000-665999) Encumbrances and Carry forwards Use of Prior Yrs Fund Balance Total Planned Use of Fund Balance $ 32,532,802.00 $ 32,532,802.00 3,796,446.15 $ 26,934,553.00 $ 30,730,999.15 3,796,446.15 26,934,553.00 $ 30,730,999.15 $ 0.00% 0.00% 0.00% TOTAL GEN. FUND / GEN. PURPOSE REVENUE 444,064.379.00 $ 444,044,615.15 $ 445,892,978.15 $ 1,848,363.00 0.42% 29
Internal Support Expenditures 401,261.00 469,249.00 394,749.00 74,500.00 COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 3.43% - Fav. due to underfilled and vacant positions. 24.96% Fav. Special Projects $75,000 due to the distribution of Judicial Technology funds from the State and Judge On-Line project (MR #09017) used for courtroom technology improvements. Fay. Expendable Equipment $50,000 due to lower than anticipated use Fav. Office Supplies $17,500 and Printing $15,000 due to continued efforts to minimize expenses and contain costs. Partially offset by unfav. Library Continuations ($55,000) due to higher than anticipated use. 15.88% - Fav. Bldg Space Cost Allocation $73,000 due to realignment of actuals charged to this division but should be charged to Family Division, offset in Family Division. Fay. Info Tech Operations $5,500 due to lower than anticipated use. Partially offset by unfav. Info Tech CLEMIS ($4,000) due to higher than anticipated use. -- Judicial Administration Personnel Expenditures Operating Expenditures $ 8,939,506.00 $ 8,738,099.00 $ 8,438,099.00 $ 110,876.00 410,652.55 308,152.55 300,000.00 102,500.00 Transfer Out 18,940.00 18,940.00 0.00% $ 9,451,643.00 $ 9,636,940.55 $ 9,159,940.55 $ $ 1,810,631.00 $ 1,774,480.00 $ 1,699,480.00 $ 77,234.00 77,234.00 49,734.00 159,310.00 161,292.00 161,292.00 ---------- $ 2,047,175.00 $ 2,013,006.00 $ 1,910,506.00 $ 477,000.00 4.95% 75,000.00 4.23% - Fav. due to underlined and vacant positions. 27,500.00 35.61% - Fay. Visiting Judges $15,000; Computer Supplies $7,500; and Metered Postage $5,000 due to lower than anticipated use. 0.00% - 102,500.00 5.09% Business Division Personnel Expenditures Operating Expenditures Internal Support Expenditures 30
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Civil / Criminal Division Personnel Expenditures $ 1,862,100,00 $ 1,823,57t00 $ 1,863,571.00 $ (40,000.00) -2.19% - Unfav. due to overfilled positions as well as an Emergency Salary position that is being charged to this division but not Operating Expenditures 5,191,431.00 5,966,750.00 4,876,750.00 1,090,000.00 18.27% - Fav. Defense Atty Fees $300,000; Defense Atty Fees Trials $275,000; and Defense Atty Fees Appellate $175,000 due to a decline in both caseload and requests for appointed counsel. Fav. Juror Fees and Mileage $300,000 along with Attorney Fees Mediators $75,000 due to a decline in caseload. Partially offset by unfav. Professional Services ($35,000) due to a higher than anticipated use. Internal Support Expenditures 2,541,069.00 2,836,019,00 2,371,519,00 464,500.00 16.38% - Fay. Info Tech Operations $275,000 due to lower than anticipated use. Fay. Bldg Space Cost Allocation $159,500 due to realignment of actuals charged to this division but should be charged to Family Division; offset in Family Division. Fay, Equipment Rental $30,000 due to higher than anticipated use. Transfers Out $ 9,694,600.00 $ 10,626,340.00 $ 9,111,840.00 $ 1,514,500.00 14.25% 225,000.00 4,125,000.00 (138,800.00) Family Division/Juvenile Maint. Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out $ 11,394,873.00 $ 11,218,136.00 $ 10,993,136.00 $ 13,115,409.00 12,990,450.32 8,865,450.32 1,665,439.00 1,668,985.00 1,807,785.00 5,246,653.00 5,246,653.00 5,246,653.00 2,01% - Fav. due to underlined and vacant positions, 31.75% - Fay. due to decrease in placements to State Institutions $3,500,000 and Priv Institutions Residential $550,000. Fav., Professional Services $75,000 due to lower than anticipated use. Offset by unfavorable Non-Dept Child Care Subsidy Revenue (50% Reimbursement). -8.32% - Unfav. Bldg Space Cost Allocation ($231,800) due to realignment of actuals between Judicial and Civil/Criminal divisions. Partially offset by fav. Info Tech Operations $100,000 due to lower than anticipated use. 0.00% - $ 31,422,374.00 $ 31,124,224.32 $ 26,913,024.32 $ 4,211,200.00 13.53% 31
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES CIRCUIT COURT ADOPTED BUDGET AMENDED BUDGET FY 2017 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 560,000.00 5,345,000.00 400,200.00 - Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 24,007,110.00 $ 23,554,286.00 18,494,950.00 19,445,086.87 4,867,079.00 5,135,545.00 5,246,653.00 5,265,593.00 $ 22,994,286.00 $ 14,100,086.87 4,735,345.00 5,265,593.00 2.38% 27.49% 7.79% 0.00% $ 52,615,792.00 $ 53,400,510.87 $ 47,095,310.87 $ 8,305,200.00 11.81% 32
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES DISTRiCT COURT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES District Court Administration Personnel Expenditures $ 211,708.00 $ 208,544,00 $ 213,544.00 $ (5,000.00) -2.40% - Unfav. Primarily due to change in medical (Hospitalization) plan offset by favorable personnel expenditures in other District Court divisions. Operating Expenditures 10,300.00 10,300.00 10,300.00 0.00% Internal Support Expenditures 1,766.00 1,766.00 1,766.00 0.00% Transfers Out 0.00% $ 223.774.00 $ 220,610.00 $ 225,610.00 5 (5,000.00) -2.27% Total Division 1 - Novi 2_99% - Fay. due to turnover and underfilleci positions/vacancies. 0.49% Fay. Software Support Maintenance $7,500 due to a reduction in caseload and equipment which affects the Judicial Information Systems (JIS) Services Fees invoiced by the State of Ml. Fav. Medical Exam $7,500 due to continued efforts to minimize expenses and contain costs. Partially offset by unfav. Building Maintenance Charges ($10,000) due to replacement of carpet within two courtrooms. 1.35% Fay. Info Tech Operations $10,000 due to lower than anticipated use. Partially offset by unfav. Info Tech CLEMIS ($5,000) due to higher than anticipated use. 0.00% 5 5,646.781.00 5 5,578,870.00 5 5,443,870.00 $ 135,000.00 2.42% 1.19% - Fay. due to turnover and underfilled positions/vacancies. 6.62% - Fav. Defense Attorney Fees $25,000 due to restructured schedule for defense attorneys. Fav. Software Support Maintenance $7,500, Electrical Service $5,000 and Printing $5,000 due to lower than anticipated use. Division 1 - Novi Personnel Expenditures $ 4,275,049,00 5 4,186,523.00 5 4,061,523.00 125,000.00 Operating Expenditures 1,021,191.00 1,021.191.00 1,016,191.00 5,000.00 Internal Support Expenditures 350.541.00 371,156,00 356,156.00 5,000.00 Transfers Out Division 2 - Clarkston Personnel Expenditures $ 2,140,363.00 $ 2,098,390.00 5 2,073,390.00 25,000.00 Operating Expenditures 642,068.00 642,068.00 599,568.00 42,500.00 Internal Support Expenditures 190,457.00 214,707.00 214,707.00 0.00% - Transfers Out 0.00% - Total Division 2 - Clarkston $ 2,972,888.00 $ 2,955,165.00 $ 2,887,665.00 $ 67,500.00 2.28% 33
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Division 3 - Rochester Hills Personnel Expenditures $ 3,978,448.00 $ 3,899,044.00 $ 3,799,004.00 100,000.00 2.56% - Fay. due to turnover and underMlled positions/vacancies. Operating Expenditures 416,733.00 416,733.00 369,233,00 47,500.00 11.40% - Fay, Juror Fees and Mileage $20,000; Printing $5,000; Postage- Standard Mailing $5,000; and Software Support Maintenance $5,000 due to continued efforts to minimize expenses and contain costs. Fay. Defense Attorney Fees $12,500 due to a decrease in requests for appointed counsel. Internal Support Expenditures 781,040.00 800,622.00 798,122.00 2,500.00 0.31% - Fay. Info Tech Operations $7,500 due to lower than anticipated use. Partially offset by unfav. Info Tech CLEM'S ($5,000) due to higher than anticipated use. Transfers Out 0.00% $ 5,176,221.00 $ 5,116,399.00 $ 4,966,399.00 $ 150,000.00 2.93% 0.00% - -1.90% - Unfav. Defense Attorney Fees ($30,000) due to an increase in requests for appointed counsel: partially offset by fay. Electrical Service $15,000 and Software Support Maintenance $5,000 due to lower than anticipated use. 2.74% - Fay. Info Tech Operations $7,500 and Equipment Rental $2,500 due to lower than anticipated use. Partially offset by unfav. Info Tech CLEMIS ($2,500) due to higher than anticipated use. Division 4- Troy Personnel Expenditures $ 2,307,909.00 $ 2,262,633.00 $ 2,262,633.00 Operating Expenditures 526,388.00 526,388.00 536,388.00 (10,000,00) Internal Support Expenditures 240,845.00 273,811.00 266,311.00 7,500.00 $ 3,075,142.00 $ 3,062,832.00 $ 3,065,332.00 $ (2,500,00) -0.08% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 12,913,477.00 $ 12,655,134.00 $ 12,410,134.00 $ 2,616,680.00 2,616,680,00 2,531,680.00 1,564,649.00 1,662.062.00 1,647,062.00 245,000.00 85,000,00 15,000.00 1.94% 3,25% 0.90% $ 17,094,806.00 $ 16,933,876,00 $ 16,588,876.00 $ 345,000.00 2.04% 34
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES PROBATE COURT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Judicial/Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out $ 2,391,300.00 $ 2,339,144.00 $ 2,239,144.00 $ 100,000.00 29,481.00 29,481.00 16,981.00 12,500,00 293,944.00 294,711.00 287,211.00 7,500.00 4.28% Fast. due to turnover and undertilled positions/vacancies. 42.40% Fay, Library Continuations $7,500 due to efforts to reduce spending and Visiting Judges $5,000 due to the Court limiting the use of visiting judges. 2.54% Fay. Info Tech Operations due to less than anticipated use. $ 2,714,725.00 $ 2,663,336.00 $ 2,543,336.00 $ 120,000.00 4.51% $ 2,261,029.00 $ 2,214,430.00 $ 2,139,430.00 $ 75,000.00 3.39% Fay. due to turnover and underlined positions/vacancies. 781,943.00 794,770.00 857,270.00 (62,500.00) -7.86% Unfav. Fees Guardian Ad Litem ($25,000) and Defense Atty Fees ($25,000) based on caseload activity. Unfav. Medical Services Guardianship/Probate ($12,500) due to continued high demand for these services. 623,560.00 646,081.00 633,581.00 12,500.00 1.93% Fay. Info Tech Operations due to less than anticipated use. 5 3,666,532.00 5 3,655,281.00 $ 3,630,281.00 $ 25,000.00 0.68% Estates/Mental Health Personnel Expenditures Operating Expenditures Internal Support Expenditures Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out $ 4,652,329.00 $ 4,553,574.00 $ 4,378,574.00 $ 811,424.00 824,251.00 874,251.00 917,504.00 940,792.00 920,792.00 175,000.00 (50,000.00) 20,000.00 3.84% -6.07% 2.13% $ 6,381,257.00 $ 6,318,617.00 $ 6,173,617.00 5 145,000.00 2.29% 35
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 2,264,405.00 $ 2,221,491.00 $ 2.221,491.00 $ 0.00% Operating Expenditures 515,213.00 515,213.00 510,213.00 5,000.00 0.97% Fay. Computer Research Service $20,000, Witness Pees and Mileage $15,000, Printing $15,000, Travel & Conference $10,000, Professional Services $9,500 and Filing Fees $8,000 due to less than anticipated use. Partially offset by unfav. Library Continuations ($39,000) and Extradition Expense ($33,500) due to increased activity. Internal Support Expenditures 1,822,989.00 1,872,040.00 1,858,040.00 14,000.00 0.75% Fay. due to Info Tech Operations $10,000 and Motor Pool $10,000; partially offset by unfav. Info Tech CLEMIS ($5,900) due to actual usage. 67,000.00 67,000.00 0.00% $ 4,602,607.00 $ 4,675,744.00 $ 4,656,744.00 $ 19,000.00 0.41% Transfers Litigation Personnel Expenditures $ 10,184,987.00 $ 9,942,663.00 $ 9,742,663.00 $ 200,000.00 2.01% Fay. due to underfilled positions and positions assigned to this division but actually working across divisional disciplines. Operating Expenditures 33,296.00 33,296.00 30,796.00 2,500.00 7.51% Fay. Personal Mileage $4,800 due to less than anticipated use. Partially offset by unfav. Clothing Allowance ($2,250) due to increased use. Internal Support Expenditures 36,591.00 36,591.00 15,591.00 21,000.00 0.00% Fay. Info Tech Operations $19,200 and Telephone communications $1,800 due to usage. Transfers Out 975,027.00 975,027.00 975,027.00 0.00% $ 11,229,901.00 $ 10,987,577.00 $ 10,764,077.00 $ 223,500.00 2.03% 36
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Warrants Personnel Expenditures $ 2,297,211.00 $ 2,246,227.00 $ 2,121,227.00 $ 125,000.00 5.56% Fay. due to underfilled positions and positions assigned to this division but actually working across divisional disciplines. Operating Expenditures 3,199,00 3,199.00 4,999.00 (1,800.00) -56.27% Unfav. Personal Mileage due to increased use. Internal Support Expenditures 3,306,00 3,306.00 3,306.00 $ 2,303,716.00 $ 2,252,732.00 $ 2,129,532.00 $ 123,200.00 0.00% 5,47% Appellate Personnel Expenditures $ 1,874,849.00 $ 1,830,599.00 $ 1,807,599.00 $ 23,000.00 1.26% Fav. due to underfilled positions and positions assigned to this division but actually working across divisional disciplines. Operating Expenditures 8,458.00 8,458.00 3,458.00 5,000.00 59.12% Fey. Personal Mileage due to less than anticipated use. Internal Support Expenditures 2,415.00 2,415.00 2,415.00 0.00% $ 1,885,722.00 $ 1,841,472,00 $ 1,813,472.00 $ 28,000.00 1.52% Department Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 16,621,452.00 $ 16,240,980.00 560,166.00 560,166.00 1,865,301.00 1,914,352.00 975,027.00 1,042,027.00 $ 15,892,980,00 549,466.00 1,879,352.00 1,042,027,00 $ 348,000.00 2.14% 10,700.00 1.91% 35,000.00 1.83% 0.00% $ 20,021,946.00 $ 19,757,525.00 $ 19,363,825.00 $ 393,700.00 1.99% 37
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE EXPLANATION OF SIGNIFICANT VARIANCES Fay. Office Supplies 510,000 due to less than anticipated use. Unfav. info Tech Ops (530,000) due to usage; Fay. Motor Pool Fuel charges $1,000 due to usage; offset in other divisions. AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Sheriffs Office Personnel Expenditures $ 1,755,727.00 $ 1,715,117.00 $ 1,715,117.00 $ 0.00% Operating Expenditures 75,736.00 75,736.00 65,736.00 10,000.00 13.20% Internal Support Expenditures 580,572.00 580,572.00 609,572.00 (29,000.00) Transfers Out 0.00% $ 2,412,035.00 $ 2,371,425.00 $ 2,390,425.00 $ (19,000.00) -0,80% Administrative Services Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 2,151,837.00 $ 2,111,470.00 5 1,692,738.00 2,111,470.00 1,737,738.00 1,692,738.00 0.00% (45,000.00) -2.66% Unfav. Deputy Supplies (5100,000) and Uniforms ($20,000) (partially offset in other divisions) due to increased activity. Partially offset by Fay. Uniform Cleaning $30,000, Office Supplies $25,000, Indigent Orders $10,000 and Printing $10,000 due to less than anticipated use. 78,158.00 78,158.00 82,158.00 (4,000.00) -5.12% Unfav Info Tech Ops (510,000) due to usage; Fay. Info Tech Managed Print Svcs $6,000 due to usage; offset in other divisions. 0.00% $ 3,922,533.00 5 3,882,366.00 5 3,931,366.00 $ (49,000.00) -1.26% Corrective Services Personnel Expenditures Operating Expenditures 30,858,585.00 $ 30,235,594.00 $ 29,935,594.00 300,000.00 0.99% Fay. Salaries and Fringe Benefits of $2,600,000 partially offset by Unfav. Overtime of ($2,300,000) as a result of a large number of vacancies, officers in the academy and officers in training. Hiring, training and filling-in for deputies is the major factor contributing to the high use of overtime. 7,871,073.00 7,871,073.00 7,711,073.00 160,000.00 2.03% Fay. Prisoner Housing Outside of County $85,500, Deputy Supplies $37,500 (partially offset in other divisions), Bedding and Linen $20,000, Laundry and Cleaning $20,000, Transportation of Prisoners $17,000, Computer Supplier $10,000, Groceries $8,000 and Provisions 58,000, all due to less than anticipated use. Partially offset by Unfav. Custodial Supplies ($30,000), Officers Training ($11,300) and Interpreter Fees ($7,000) due to increased activity. Internal Support Expenditures 7,723,401.00 7,934,423.00 7,808,423.00 126,000.00 1.59% Fay. Info Tech Ops $100,000, Motor Pool Fuel Charges $4,000, Info Tech Managed Print Svcs $7,000 and Radio Communications $15,000 due to usage; partially offset in other divisions. Transfers Out 0.00% Corrective Services-Satellites Personnel Expenditures ---------------- --_-_-_-_-____ $ 46,453,059.00 5 46,041,090.00 $ 45,455,090.00 $ 588,000,00 1.27% $ 13,240,284.00 $ 13,007,511.00 $ 14,407,511.00 $ (1,400,000.00) -10.76% Unfav. due to increased usage of Overtime at the Corrective Services Satellite facilities ($1,150,000) caused by Hospital Watch, vacant positions, prisoner transport employee disability and other leaves, security at Animal Control and East Annex. Also unfav. overtime related Fringe Benefits of ($406,000). Partially offset by fay, regular salaries of $150,000. 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. 38
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES SHERIFFS OFFICE ADOPTED BUDGET AMOUNT AMENDED FY 2017 FAVORABLE BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Operating Expenditures 226,494.00 227,745.00 227,745.00 0.00% Internal Support Expenditures 1,205,421.00 1,209,958.00 1,194,958.00 15,000.00 1.24% Fay. Motor Pool 510,000 and Motor Pool Fuel Charges $5,000 due to usage; partially offset in other divisions. Transfers Out 0,00% $ 14,572,199.00 $ 14,445,214.00 $ 15,830,214.00 $ (1,385,000,00) -9.59% (200,000.00) -10.47% Untav. Overtime as well as two emergency salary positions which are not budgeted in Sheriff, Emergency Salaries will be re-appropriated fron Non-Departmental General Fund to Sheriff at year end, if necessary. 150,000.00 15.28% Fay. Fees Civil Services $150,000 due to continuing decline in the number of home foreclosures and civil service requests (see corresponding unfavorability in Civil Action Service Fee revenues). (182,400.00) -240.99% Unfav Bldg Space Cost Allocation ($108,400) and Telephone Communications ($10,000) due to usage; offset in other divisions Unfav Into Tech Ops ($60,000) and Info Tech Managed Print Svcs ($4,000) due to usage; offset in other divisions. 0.00% (232,400.00) -7.83% Emergency Prep Training and Communications Personnel Expenditures $ 1,873,948.00 $ 1,909,436.00 $ 2,109,436.00 $ Operating Expenditures 981,585.00 981,585.00 831,585.00 Internal Support Expenditures 75,688.00 75,688,00 258,088.00 Transfers Out $ 2,931,221.00 $ 2,966,709.00 $ 3,199,109.00 $ Patrol Services Personnel Expenditures $49,550,294 $ 48,855,277.00 $ 47,855,277,00 $ 1,000,000.00 2.05% Fay. Salaries and Fringe Benefits of $1,000,000 due to turnover and vacancies. Operating Expenditures Internal Support Expenditures Transfers Out 1,064,522.00 5,087,459.00 1,374,686.00 5,173,129.00 174,633.00 1,274,588.00 5,131,129.00 174,633.00 100,000.00 7.27% Fav. Gasoline Charges $45,000, Uniforms $40,000 (partially offset in other divisions) and Equipment Rental $40,000; partially offset by Unfav. Equipment Maintenance ($25,000). 42,000.00 0.81% Unfav. Telephone Communications ($8,000) due to usage; offset in other divisions. Fay. Motor Pool Fuel Charges $235,000 and Radio Communications $25,000 due to usage. Unfav. Motor Pool ($175,000) and Info Tech CLEMIS ($35,000) due to usage; partially offset in other division. 0, 00 % $ 55,702,275.00 5 65,577,625.00 $ 54,435,625.00 $ 1,142,000.00 2.05% Emergency Communications Operations Personnel Expenditures $ 7,675,028.00 5 7,693,883.00 $ 8,843,883.00 $ (950,000.00) -12.35% Unfav. ($950,000) due to Overtime from vacant positions and turnover. Operating Expenditures 159,715.00 160,132.00 160,132.00 0.00% 39
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 145,221.00 145,221.00130,100.00 89.59% Fay. Bldg Space Cost Allocation $108,400 and Telephone Communications 15,121.00 $13,000 due to usage; offset in other divisions. Fay. Info Tech Managed Print Services $8,700 due to usage; partially offset in other divisions. 0.00% Internal Support Expenditures Transfers Out ------------------------ --------_-_-_-__ --------------- 8 7,979,964.00 $ 7.999,236.00 $ 8,819,136.00 8 (819,900.00) -10.25% Investigative/Forensic Svcs Personnel Expenditures $ 8,752,790.00 $ 8,661,685.00 $ 8,751,685.00 $ (90,000,00) -1.04% Unfav. Overtime ($165,000) and overtime related Fringe Benefits ($50,000), partially offset by Fav. Salaries of $125,000 largely due to turnover. Operating Expenditures Internal Support Expenditures Transfers Out 813,133.00 2,521,884.00 334,086.00 1,280,612.00 2,529,491.00 669,491.00 1,235,612.00 2,405.491.00 669,491.00 45,000,00 3.51% Fay. Contracted Services $70,000 partially offset by Unfav. Communications ($25,000) due to higher than expected use. 124,000.00 4.90% Fay. Telephone Communications $5,000 due to usage; offset in other divisions. Fav. Motor Pool Fuel charges $55,000, Info Tech CLEMIS $25,000, Motor Pool $65,000 and Radio Communications $4,000 due to usage. Unfav. Info Tech Ops ($30,000) due to usage; partially offset in other divisions. 0.00% $ 12,421,893.00 $ 13,141,279.00 8 13,062,279.00 $ 79,000.00 0.60% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 115,858,293.00 $ $ 12,884,996.00 $ $ 17,417,804.00 $ $ 334,085.00 $ 114,189,973.00 13,664,207.00 17,726,640.00 844,124,00 $ 115,529,973.00 $ 13,244,207.00 $ 17,504,940.00 844,124,00 (1,340,000.00) -1.17% 420,000.00 3.07% 221,700.00 1.25% 0.00% $ 146,495,179.00 5 146,424,944.00 $ 147,123,244.00 $ (698,300.00) -0.48% 40
COUNTY OF OAKLAND FY2017 SECOND QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures Transfers Out $ 769,412.00 $ 751,238.00 $ 641,238.00 $ 110,000.00 14.64% Fav. Due to turnover. 34,900.00 34,900.00 24,500.00 10,400.00 29.80% Fay, Printing $4,900, Office Supplies $4,000, and Expendable Equipment $1,000 all due to less than anticipated use. 109,250.00 104,450.00 4,800.00 4.39% Fav. Info Tech Operations $3,600 and Telephone Communications $1,200 due to less anticipated activity. 0.00% $ 913,296.00 $ 895,388.00 $ 770,188.00 $ 125,200.00 13.98% Internal Support Expenditures 108,984.00 County Clerk (Vital Stets & Legal Rees) Personnel Expenditures $ 3,585,031.00 $ 3,512,145.00 $ 3,114,945.00 $ 397,200.00 11.31% Fay. Due to vacancies, turnover and underfilled positions. Operating Expenditures 279,160.00 279,160.00 187,250.00 91,900.00 32.92% Fav. Court Transcripts $42,000 due to prosecutors ordering fewer transcripts; Professional Services $35,200, Office Supplies $8,000, Personal Mileage $4,800, Equipment Maintenance $3,000 and Membership Dues $2,500 all are due to less than anticipated use. Partially offset by unfavorable Charge Card Fee ($3,000) due to increased activity. Internal Support Expenditures 650,560.00 852,192.00 848,592.00 3,600.00 0.42% Fav. Equipment Rental $3,600 due to reduced activity. Transfers Out - 0.00% $ 4,514,751,00 $ 4,643,497.00 $ 4,150,797.00 $ 492,700.00 10.61% 41
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Elections Personnel Expenditures Operating Expenditures $ 851,493.00 $ 837,601,00 $ 737,601.00 $ 100,000.00 781,178.00 892,647.00 883,847.00 8,800.00 11.94% Fay. Due to turnover and underfilled positions. 0.99% Fay. Materials and Supplies $4,800, Office Supplies $2,600, and Travel and Conference $2,500 due to reduced activity. Partially offset by Workshops and Meetings ($900) and Charge Card Fee ($200) due to increased activity. Internal Support Expenditures 298,309.00 311,808.00 311,808.00 0.00% Transfers Out 0.00% $ 1,930,980.00 $ 2,042,056.00 $ 1,933,256.00 $ 108,800.00 5.33% Register of Deeds (and Micrographics) Personnel Expenditures $ 2,609,903.00 $ 2,561,258.00 $ 2,311,258.00 $ 250,000.00 9.76% Fay. Due to vacancies, turnover and underfilled positions. Operating Expenditures 271,494.00 271,494.00 $ 168,394.00 103,100.00 37.98% Fay, Material and Supplies $33,500, Metered Postage $25,500, Professional Services $24,000, Office Supplies $19,900, Expendable Equipment $5,000 and Printing $3,400, due to less than anticipated use. Partially offset by Maintenance Contract ($9,000) and Charge Card Fees ($1,500) due to increased activity. Internal Support Expenditures 278,018.00 279,703.00 $ 279,703.00 0.00% Transfers Out 0.00% $ 3,159,415.00 $ 3,112,455.00 $ 2,759,355.00 $ 353,100.00 11.34% 42
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Jury Commission Personnel Expenditures $ 14,938.00 $ 14,889.00 $ 3,189.00 $ 11,700.00 78.58% Operating Expenditures 68,776.00 68,776.00 44,076.00 24,700.00 35.91% Internal Support Expenditures 11,467.00 11,467.00 11,467.00 0.00% $ 95,181.00 $ 95,132.00 $ 58,732.00 $ 36,400.00 38.26% Fav. Due to vacant position. Fav. Metered Postage $18,900, Printing $4,500 and Miscellaneous $1,000 due to less than anticipated use. Department Total Personnel Expenditures $ 7,830,777.00 $ 7,677,131.00 $ 6,808,231.00 $ 868,900.00 Operating Expenditures 1,435,508.00 1,546,977.00 1,308,077.00 $ 238,900.00 Internai Support Expenditures 1,347,338.00 1,564,420.00 1,556,020.00 $ 8,400.00 Transfers Out 11.32% 15.44% 0.54% 0.00% $ 10,613,623.00 $ 10,788,528.00 $ 9,672,328.00 $ 1,116,200.00 10.35% 43
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES COUNTY TREASURER AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 3,372,686.00 $ 3,301,521.00 $ 3,061,521.00 $ 240,000.00 7.27% - Fav. Turnover, underfills, overfills, and vacant positions. Operating Expenditures 4,512,105.00 4,512,105.00 4,601,005.00 (88,900.00) -1.97% - UnFav. Claims Paid ($240,200) from a settlement on a foreclosed property that was in litigation. Also unfavorable Contracted Services ($165,000) for increased activity, Recording Fee Redemption Certificate ($100,000) due to withdravving properties from foreclosure and Register of Deeds ($5,000) due to an increase in statutory fees for recording deeds. Partially offset by favorable Title Search Fee $308,900, Fees Civil Service $100,000, Twp & City Treasurer Bonds $8,000, Personal Mileage $2,800, Membership Dues $2,200 and Tax Collection Supplies $1,400 due to less than anticipated use. Internal Support Expenditures 780,029.00 927,172.00 874,472,00 52,700.00 5.68% - Fay. Primarily due to Info Tech Operations $50,800 due to less than anticipated use. Transfers Out Division Total Department Total 120,000.00 201,500.00 ---------- ------------ - $ 8,784,820.00 $ 8,942,298.00 ------------- --------- $ 8,784,820.00 $ 8,942,298.00 201,500.00 0.00% $ 8,738,498.00 $ 203,800.00 2.28% $ 8,738,498.00 $ 203,800.00 228% 44
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES BOARD OF COMMISSIONERS ADOPTED AMENDED BUDGET BUDGET AMOUNT FY 2017 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures $ 2,185,531.00 $ 2,135,904.00 $ 2,135,904.00 $ 475,305.00 622,393.00 5 581,393.00 0.00% - 41,000.00 6.59% - Fav. Personal Mileage $11,000, Workshops and Meeting $10,000, Travel and Conference $5,000, Legal Services $8,000 and Legislative Expense $7,000 due to less than anticipated use. Internal Support Expenditures 235,909.00 240,888.00 $ 240,888.00 0,00% - $ 2,896,745.00 $ 2,999,185.00 $ 2,958,185.00 $ 41,000.00 1.37% Department Total Personnel Expenditures $ 2,185,531.00 $ 2,135,904.00 $ 2,135,904,00 $ 0.00% Operating Expenditures 475,305.00 622,393.00 551,393.00 41,000.00 6.59% Internal Support Expenditures 235,909.00 240,888.00 240,888.00 0.00% $ 2,896,745.00 $ 2,999,185.00 $ 2,958,185.00 5 41,000.00 1.37% 45
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES LIBRARY BOARD AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Library Board Personnel Expenditures $ 495,412.00 $ 483,831.00 $ 483,831.00 $ 0.00% Operating Expenditures 379,281.00 381,264.87 379,664.87 1,600.00 0.42% Fay. Computer Research Service $10,000 and Fees per Diem $200 due to less than anticipated use; partially offset by unfavorable Library Continuations ($3,700) due to cost increases on print material, Software Support Maintenance ($2,500) due to timing of invoice not being accrued for FY 2017 and Equipment Maintenance ($2,400) due to repairs on aging photo vending equipment Internal Support Expenditures 468,447.00 475,376.00 475,376.00 0.00% Transfers $ 1,343,140.00 $ 1,340,471.87 $ 1,338,871.87 $ 1,600.00 0.12% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 495,412.00 $ 483,831.00 $ 483,831.00 $ 379,281.00 381,264.87 379,664.87 468,447.00 475,376.00 475,376.00 $ 1,343,140.00 $ 1,340,471.87 $ 1,338,871.87 $ 0.00% 1,600.00 0.42% 0.00% 1,600.00 0.12% 46
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES WATER RESOURCES COMMISSIONER AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Water Resource Commissioner Personnel Expenditures $ 218,414.00 $ 213,224.00 $ 213,224.00 $ 0.00% Operating Expenditures 532,975.00 532,975.00 532,975.00 0.00% Internal Support Expenditures 4,881,378.00 5,059,061.00 5,159,061.00 (100,000.00) -1.98% Unfav - Drain Equipment Labor ($100,000) due to employee's labor that could not be charged to other funds; offset by favorable Charges for Services revenue. Transfers 55,165.00 56,165,00 56,165.00 0,00% Division Total $ 5,688,932.00 $ 5,861,425.00 $ 5,961,425.00 $ (100,000.00) -1.71% Department Total $ 5,688,932.00 $ 5,861,425.00 $ 6,961,425.00 $ (100,000.00) -1.71% 47
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES COUNTY EXECUTIVE AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (U N FAVORAB L E) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 2,224,612.00 $ 2,170,288.00 2,170,288.00 $ 0.00% Operating Expenditures 277,991.00 277,991.00 277,991.00 0.00% Internal Support Expenditures 441,771.00 458,041.00 458,041.00 0.00% $ 2,944,374.00 $ 2,906,320.00 $ 2,906,320.00 $ 0.00% Compliance Office Personnel Expenditures $ 1,645,259.00 $ 1,607,459.00 $ 1,607,459.00 $ 0.00% Operating Expenditures 49,252.00 80,202.00 80,202.00 0.00% Internal Support Expenditures 191,794.00 220,609.00 220,609.00 0.00% $ 1,886,305.00 $ 1,908,270.00 $ 1,908,270.00 $ 0.00% Corporation Counsel Personnel Expenditures $ 2,288,295.00 $ 2,235,430.00 $ 2,235,430.00 $ 0.00% Operating Expenditures 87,333.00 87,333.00 87,333.00 0.00% Internal Support Expenditures 385,885.00 395,181.00 395,181.00 0.00% $ 2,761,513.00 $ 2,717,944.00 $ 2,717,944.00 $ Department Total Personnel Expenditures $ 6,158,166.00 $ 6,013,177.00 $ 6,013,177.00 $ Operating Expenditures 414,576.00 $ 445,526.00 445,526.00 Internal Support Expenditures 1,019,450.00 1,073,831.00 1,073,831.00 Transfers Out - - - $ 7,592,192.00 $ 7,532,534.00 $ 7,532,534.00 $ 0.00% 0.00% 0.00% 0.00% 0.00% 48
ADOPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT FY 2017 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Equalization Personnel Expenditures $ 225,527.00 $ 219,706.00 $ 219,706.00 $ 4,017.00 4,017.00 4,017.00 14,997.00 14,997.00 14,997.00 $ 24-4,541.00 $ 238,720.00 $ 238,720.00 $ $ 8,462,699.00 $ 8,278,343.00 $ 7,578,343.00 $ 700,000.00 8.46% Fay, due to vacancies and underfilled positions. 0.00% 0.00% 0.00% 0.00% Operating Expenditures 431,404.00 431,404.00 371,404.00 60,000.00 13.91% Fay. Professional Services $20,000, Personal Mileage $20,000, and Printing $20,000 due to less than anticipated use, internal Support Expenditures 918,024.00 1,095,050.00 1,095,050.00 0.00% $9,812,127.00 $9,804,797.00 $ 9,044,797.00 $ 760,000.00 7.75% Fiscal Services Personnel Expenditures $ 8,124,132.00 $ 7,953,612.00 $ 7,303,612.00 $ 650,000.00 8.17% Fay. due to vacancies and underfilled positions. Operating Expenditures 388,600.00 391,397.34 359,397.34 32,000.00 8.18% Fay. Metered Postage $15,000, Printing $12,000, and Office Supplies $5,000 due to less than anticipated use. Internal Support Expenditures 1,253,714.00 1,560,368.00 1,560,368.00 0.00% $ 9,766,446.00 $ 9,905,377.34 $ 9,223,377.34 $ 682,000.00 6.89% Department Total Personnel Expenditures $ 16,812,358.00 $ 16,451,661.00 $ 15,101,661.00 $ 1,350,000,00 Operating Expenditures 824,021.00 826,818.34 734,818.34 92,000.00 Internal Support Expenditures 2,186,735.00 2,670,415.00 2,670,415.00 Transfers Out - - 8.21% 11.13% 0.00% 0.00% $ 19,823,114.00 $ 19,948,894.34 $ 18,506,894.34 $ 1,442,000.00 7.23% 49
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES CENTRAL SERVICES AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administrative Personnel Expenditures 5 225,444.00 5 219,623.00 5 219,623.00 5 0.00% Operating Expenditures Internal Support Expenditures Transfers Out 3,298.00 14,295.00 3,298.00 14,295.00 3,298.00 14,295.00 0.00% 0.00% $ 243,037.00 $ 237,216.00 $ 237,216.00 $ 0.00% Support Services Personnel Expenditures $ 1,223,085.00 $ 1,198,604.00 $ 1,198,604.00 $ 0.00% Operating Expenditures 372,695.00 401,695.00 401,695.00 0.00% Internal Support Expenditures 755,809.00 773,857.00 $ 773,857.00 0.00% Transfers Out $ 2,351,589.00 $ 2,374,156.00 $ 2,374,156.00 5 Department Total Personnel Expenditures $ 1,448,529.00 $ 1,418,227.00 $ 1,418,227.00 $ - Operating Expenditures 375,993.00 404,993.00 404,993.00 - Internal Support Expenditures 770,104.00 788,152.00 788,152.00 - Transfers Out - -------------- ------------- -------------- ------- $ 2,594,626.00 $ 2,611,372.00 5 2,611,372.00 $ 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 50
ADOPTED AMENDED BUDGET BUDGET FY 2017 FORECAST COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES FACILITIES MANAGEMENT AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 208,485.00 $ 203,689.00 $ 203,689.00 $ - 0.00% 5,764.00 5,764.00 4,764.00 1,000.00 17.35% Fav. Membership Dues as a result of less than anticipated usage. 16,290.00 16,290.00 11,290.00 5,000.00 30.69% Fav. Info Tech Operations based on actual usage. $ 230,539.00 5 225,743.00 $ 219,743.00 5 6,000.00 2.66% $ 828,821.00 $ 811,787.00 $ 824,287.00 $ (12,500.00) -1.54% Unfav. Due to overfilled positions. 168,682.00 168,682.00 170,182.00 (1,500.00) -0.89% Unfav. Personal Mileage due to use of personal vehicles for satellite locations. 54,224.00 54,356.00 54,356.00 - 0.00% $1,051,727.00 $ 1,034,825.00 5 1,048,825.00 $ (14,000.00) -1.35% Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Facilities Engineering Personnel Expenditures Operating Expenditures Internal Support Expenditures Department Total Personnel Expenditures $1,037,306.00 $ 1,015,476.00 $ 1,027,976.00 $ (12,500.00) -1.23% Operating Expenditures 174,446.00 174,446.00 174,946.00 (500.00) -0.29% Internal Support Expenditures 70,514.00 70,646.00 65,646.00 5,000.00 7.08% $1,282,266.00 $1,260,568.00 $ 1,268,568.00 $ (8,000.00) -0.63% 51
2,972,869.00 $ 172,721.00 $ 13,977.00 163,284.00 349,982.00 $ 2,798,869.00 $ 172,721.00 $ 13,977.00 163,284.00 349,982.00 $ 174,000.00 5.85% 0.00% 0.00% 0.00% 0.00% COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES HUMAN RESOURCES AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures 774,116.00 $ 758,889.00 $ 713,489.00 $ 45,400.00 5.98% Fay. Due to vacant position. Operating Expenditures 337,622.00 503,422.00 481,722.00 21,700.00 4.31% Fav. Fees- Per Diems $7,500, Metered Postage $7,200, Court Reporter Services $2,900, and Printing $1,800 due to less activity. 37,914.00 Internal Support Expenditures Transfers Out Workforce Management Personnel Expenditures Operating Expenditures Internal Support Expenditures Benefits Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures 1,304,064.00 $ 1,236,964.00 $ 67,100.00 5.15% 1,818,174.00 $ 1,818,174.00 $ 0.00% 390,612.00 275,512.00 115,100.00 29.47% Fay. Recruitment Expense $56,400, Examination Material $30,000, Software Rental Lease Purchase $7,800, Travel and Conference $7,800, and Printing $5,000 due to less than anticipated use. 764,083.00 705,183.00 58,900.00 7.71% Fay. Info Tech Operations $42,600, Equipmental Rental $12,500, and Telephone Communication $3,800 due to reduced activity. 41,753.00 41,753.00 0.00% 1,149,662.00 $ 1,860,382.00 $ 390,612.00 647,635.00 176,926.00 $ 13,977.00 163,284.00 354,187.00 $ Department Total Personnel Expenditures 2,811,424.00 $ Operating Expenditures 742,211.00 Internal Support Expenditures 848,833.00 Transfers Out 2,749,784.00 $ 2,704,384.00 $ 45,400.00 1.65% 908,011.00 771,211.00 136,800.00 15.07% 969,120.00 910,220.00 58,900.00 6.08% 4,402,468.00 $ 4,626,915.00 $ 4,385,815.00 $ 241,100.00 5.21% 52
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 209,063.00 $ 205,263,00 $ 205,263.00 $ 0.00% Operating Expenditures 8,389,499.00 8,013,143.00 7,238,143.00 775,000.00 9.67% Fay. due to Private Institutions Foster Care $500,000, Fay. Foster Boarding Homes $275,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 12,571.00 12,571.00 12,571.00 0.00% Transfers Out $ 8,611,133.00 $ 8,230,977.00 5 7,455,977.00 $ 775,000.00 9.42% Health Personnel Expenditures $ 25,563,772.00 $ 25,018,242.00 $ 22,815,242.00 $ 2,200,000.00 8.79% Fay. due to turnover and underfilled positions. 302,100.00 Operating Expenditures Internal Support Expenditures 3,363,684.00 3,424,761.96 3,122,661.96 2,867,716.00 8.82% Fay. Professional Services $230,000 due to increased individuals enrolled in Medicaid which makes them ineligible for the County's Dental program. Fav. Software Support Maintenance $125,000 due in part to funds budgeted for new Environmental Health application, but was not needed. Unfav. Adj Prior Years Revenue ($52,889) due to adjustment for FY 2016 estimated administrative overhead cost distribution. Also, a budget amendment is recommended for $16,994 to finalize the 2010.-2014 OCCHMA Cost Settlement. 3,136,486.00 3,115,486.00 21,000.00 0.67% Fay. Telephone Communications $12,000 and Info Tech Operations $10,000 based on usage. Favorability partially offset by unfav. Info Tech Managed Print Services ($1,400). Transfers Out 43,401.00 43,401.00 $ 31,795,172.00 $31,622,890.96 $ 29,099,790.96 $ 2,523,100.00 7.98% 53
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Children's Village Personnel Expenditures $ 16,776,215.00 $ 16,814,178.00 $ 17,213,678.00 $ (399,500.00) -2.38% Unfav. Primarily due to overtime. Operating Expenditures 3,693,861.00 3,954,714.11 3,806,714.11 148,000.00 3.74% Fav. Provisions $50,000 due to increased reimbursement for improved nutritional requirements and lower food costs. Fav. Medical Services Physicians $35,000 due to services provided by Oakland Integrated Healthcare Network (OIHN). Fay. Drugs $25,000 and Hospitalization $18,000 due to fewer medical needs along with cost saving initiatives. Internal Support Expenditures 2,728,667.00 2,811,614.00 2,811,614.DD 0.00% Transfers Out $ 23,198,743.00 $ 23,580,506.11 $ 23,832,006.11 $ (251,500.00) -1.07% Homeland Security Personnel Expenditures $ 852,675.00 $ 833,970.00 $ 833.970.00 $ 0.00% Operating Expenditures 304,866.00 304,866.00 289,866.00 15,000.00 4.92% ray_ Equipment Maintenance $15,000 due to limited normal, regular maintenance costs plus unforeseen major repairs incurred on spedalty/hazmat vehicles. Internal Support Expenditures 532,046.00 555,297.00 555,297.00 0.00% Transfers Out $ 1,689,587.00 $ 1,694,133.00 $ 1,679,133.00 $ 15,000.00 Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 43,401,725.00 15,751,910.00 6,141,000.00 $ 42,871,653.00 15,697,485.07 6,515,968.00 43,401.00 $ 41,071,153.00 14,457,385.07 6,494,968_00 43,401.00 $ 1,800,500.00 1,240,100.00 21,000.00 4_20% 7.90% 0.32% 0.00% $ 65,294,635.00 $ 65,128,507.07 $ 62,066,907.07 $ 3,061,600.00 4.70% 54
ADOPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT FY 2017 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 225,492.00 $ 219,671.00 219,671.00 $ 0.00% 4,800.00 4,800.00 3,300.00 1,500.00 31.25% Fav. Special Event Program less than anticipated activity. 7,039.00 7,039.00 7,039.00 0.00% $ 237,331.00 $ 231,510.00 $ 230,010,00 $ 1,500.00 0.65% Public Services - Admin. Personnel Expenditures Operating Expenditures Internal Support Expenditures Veterans Services Personnel Expenditures $ 1,641,689.00 $ 1,604,980.00 1,604,980.00 $ 0.00% Operating Expenditures 190,912.00 190,912.00 175,912.00 15,000.00 7.86% Fay. Soldier Burial $10,000 and Soldier Relief $5,000 due to less than anticipated activity. Internal Support Expenditures 202,229.00 204,372.00 204,372.00 0.00% $ 2,034,830.00 $ 2,000,264.00 $ 1,985,264.00 $ 15,000.00 0,75% Community Corrections Personnel Expenditures $ 3,983,111.00 $ 3,904,519.00 3,904,519.00 $ 0.00% Operating Expenditures 502,025.00 502,025.00 502,025.00 0.00% Internal Support Expenditures 522,899.00 562,525.00 562,525.00 0.00% $ 5,008,035.00 $ 4,969,069.00 $ 4,969,069.00 $ 0.00% MSU Ext. - Oakland County Personnel Expenditures $ 666,407.00 $ 650,491.00 $ 550,491.00 $ 100,000.00 15.37% Fay. due to vacant and underfilled positions. Operating Expenditures 227,239.00 227,239.00 227,239.00 0.00% Internal Support Expenditures 286,148.00 293,755.00 293,755.00 0.00% $ 1,179,794,00 $ 1,171,485.00 $ 1,071,485.00 $ 100,000.00 8.54% 55
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Medical Examiner Personnel Expenditures $ 3,421,087.00 $ 3,347,810.00 $ 3,197,810.00 $ 150,000.00 4.48% Fav. due to vacant and under filled positions. Operating Expenditures 600,006.00 631,059.00 675,159.00 (44,100.00) -6.99% Unfav. Transportation Service ($37,700), Medical Supplies, ($15,700) Laboratory Fees ($10,000), Laboratory Supplies ($6,300), Laundry and Cleaning ($4,300) due to increased activity. Partially offset by favorable Training $9,800, Film and Processing $4,900, and Professional Services $3,200 due to less than anticipated activity. Internal Support Expenditures 812,143.00 832,424.00 832,424.00 0.00% $ 4,833,236_00 $ 4,811,293.00 $ 4,705,393.00 $ 105,900.00 2.20% Animal Control Personnel Expenditures $ 2,444,619,00 $ 2,402,243.00 $ 2,322,243.00 $ 80,000.00 3.33% Fay. due to vacant and underfilled positions. Operating Expenditures 280,097.00 280,097.00 353,897_00 (73,800.00) -26.35% Unfav. Medical Supplies ($30,100), Animal Supplies ($20,800), Metered Postage ($20,100), Housekeeping and Janitor Exp ($4,500) Special Event Program ($2,900), Tax Collection Supplies ($2,400) and Uniforms ($1,200) due to increased activity. Partially offset by favorable Contracted Services $5,000, and Training $4,800 due to less than anticipated activity. Internal Support Expenditures 862,554.00 944,391.00 944,391.00 0,00% Transfers Out $ 3,587,270.00 $ 3,626,731.00 $ 3,620,531.00 $ 6,200.00 0.17% Circuit Court Probation Personnel Expenditures $ - $ $ - $ 0.00% Operating Expenditures 54,326.00 54,326.00 54,326.00 0.00% Internal Support Expenditures 569,207.00 573,064.00 573,064.00 0.00% $ 623,533.00 $ 627,390.00 $ 627,390.00 $ 0.00% 56
ADOPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT FY 2017 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 12,382,405.00 $ 12,129,714.00 $ 11,799,714,00 $ 330,000.00 1,859,405.00 1,890,458.00 1,991.858,00 (101,400.00) 3,262,219.00 3,417,570.00 3,417,570.00 2.72% -5.36% 0.00% $ 17,504,029.00 $ 17,437,742.00 $ 17,209,142.00 $ 228,600.00 1.31% 57
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST [UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 1,322,000.00 $ 1,292,549.00 $ 1,292,549.00 $ - 0.00% Operating Expenditures 442,222.00 442,222.00 338,022.00 104,200.00 23.56% Fay. Primarilly due to Professional Services $102,600 due to reduction of contractual services. Internal Support Expenditures 65,089.00 132,648.00 138,648.00 (6,000.00) -4.52% Unfav. Info Tech Operations due to a one time charge of software license fees. Transfers $ 1,829,311.00 $ 1,867,419.00 $ 1,769,219.00 $ 98,200.00 5.26% Planning and Economic Development Services Personnel Expenditures $ 4,077,694.00 $ 3,990,256.00 Operating Expenditures 1,376,353.00 1,569,934.00 Internal Support Expenditures $ 3,697,956.00 $ 292,300.00 7.33% Fay. due to vacancies and underlined positions. 1,326,734.00 243,200.00 15.49% Fay. Workshops and Meetings $112,200 and Business Recruitment $54,800 due to lower than anticipated costs subsequent to budget. Fay. Printing $53,700, Supplies $29,000, Travel $4,000 and Mileage $4,000 due to usage. Offset by unfav. Special Event ($18,100) due to Fire and Ice Festival expenditures; a second quarter budget amendment is recommended. 832,833.00 835,147.00 842,547,00 (7,400.00) -0.89% Unfav Insurance Fund ($15,100) and Info Tech Operations ($2,400) due to usage. Offset by fay. Telephone Communications $8,000, and Info Tech Managed Print Services $2,000 due to less than anticipated usage. Transfers _ - ----- -- -- ---- - ------- $ 6,286,880.00 $ 6,395,337.00 $ 5,867,237.00 $ 528,100.00 8.26% 58
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST [UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Community and Home Improvement Personnel Expenditures $ Operating Expenditures Internal Support Expenditures Transfers $ n $ $ $ $ n n $ $ n n Workforce Development Personnel Expenditures $ 25,620.00 $ 25,620.00 $ 25,620.00 $ 0.00% Operating Expenditures 1.n Internal Support Expenditures $ 25,620,00 $ 25,620.00 $ 25,620.00 $ Department Total Personnel Expenditures $ 5,425,314.00 $ 5,308,425.00 $ 5,016,125.00 $ 292,300.00 Operating Expenditures 1,818,575.00 2,012,156.00 1,664,756.00 347,400.00 Internal Support Expenditures 897,922.00 967,795.00 981,195.00 (13,400.00) Transfers - - - 0.00% 5.51% 17.27% -1.38% 0.00% $ 8,141,811.00 $ 8,288,376.00 $ 7,662,076.00 $ 626,300.00 7.56% 59
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT NON-DEPARTMENTAL EXPENDITURES AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION NON-DEPARTMENT APPROPRIATIONS COUNTY OPERATIONS Insurance Fund Insurance Surety Bonds $ 367,1133.00 $ 367,183.00 $ 367,183.00 $ 33,305.00 33,305.00 13,305.00 0.00% 20,000.00 60.05% Fav. projection based on actual payments approved by Risk Mgmt to date. Logos Trademarks Intellect Property 20,000.00 20,000.00 20,000.00 0.00% Road CommissionlCurrent Drain Assessment 1,450,000.00 1,450,000.00 1,650,000.00 (200,000.00) -1319% Unfav. due to projected county portion of drain assessments for county roads. Road CommissionlTri Party Agreement 100.00 1,790,585.00 1,790.585.00 0.00% Interest Expense - - 0,00% Provisions 30,000.00 30,000.00 30,000.00 0.00% Transfer to Community Mental Health Authority 9,620,616.00 9,520,616.00 9,620,616.00 0.00% Total $ 11,521,204.00 $ 13,311,689.00 $ 13,491,689.00 $ (180,000.00) -1.35% COUNTY BUILDINGS $ 2,781,940.00 $ 2,381,768.00 $ 2,381,768.00 $ 0.00% 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 $ 315,936.00 321,602.00 300,000.00 406,815,00 1,443,887.00 5,281,710.00 600,000.00 8,600.00 250,000.00 298,638.00 130,922.00 300,000.00 406,815.00 1,068,282.00 3,211,329.00 600,000.00 8,600.00 120,932.00 145,093.00 $ 298,638.00 $ 130,922.00 300,000.00 406,815.00 1,068,282.00 2,781,329.00 600,000.00 8,600.00 120,932.00 145,093.00 450,000.00 0.00% 0.00% 0.00% 0.00% 0,00% 14.01% 0.00% 0.00% 0.00% 0.00% Favorable based on IT Development projections to date. 60
ADOPTED BUDGET 275,000,00 1,725,980.00 4,212,170.00 250,000.00 AMENDED BUDGET 275,000.00 1,080,298.00 4,212,170.00 250,000.00 FY 2017 FORECAST 275,000.00 1,080,298.00 4,212,170.00 250,000.00 AMOUNT FAVORABLE {UNFAVORABLE) PERCENT 0.00% 0.00% 0,00% 0.00% EXPLANATION $ 15,391,900.00 $ 12,108,079.00 $ 11,658,079.00 $ 450,000.00 3.72% $ 461,742,00 1,844,186.00 3,620,676.00 2,244,250.00 1,200,000,00 5,500,000.00 461,742.00 $ 461,742.00 1,844,186.00 1,844,186.00 3,520, 676.00 3,620,676.00 2,244,250.00 2,244,250.00 2,042,836.00 2,042,836.00 5,500,000.00 5,500,000.00 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.000/0 0.00% 0.00% 0.00% 0.00% COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT NON-DEPARTMENTAL EXPENDITURES Overtime Reserve Security Reserve Substance Abuse Coord Agency Summer Employees Salary Appropriation Total 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 Facilities Maintenance and Operations Building Fund Economic Development Corp BA Animal Ctrl Pet Adopt Debt Imaging System Project Domestic Equipment Preparedness $ 14,870,854.00 $ 15,713,690.00 5 15,713,690.00 5 0.00% TOTAL NON-DEPT. APPROPRIATIONS $ 45,492,998.00 $ 44,942,326.00 $ 44,137,326.00 $ 305,000,00 0.69% TRANSFER TO GENERAL PURPOSE FUNDS Child Care Fund Social Welfare Fund Foster Care $ 23,442,791.00 $ 23,283,446.00 $ 23,283,446.00 $ 1,000,00 1,000.00 1,000.00 0.00% 0.00% $ 23,443,791.00 $ 23,284,446.00 $ 23,284,946.00 5 0,00% TOTAL EXPENDITURES $ 68,936,789.00 $ 67,726,772.00 $ 67,421,772.00 $ 305,000.00 0.45% 61
FY 2017 BUDGET AMENDMENTS
FY 2017 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS
BUDGET AMENDMENTS
M.R. #16264 - 10/06/2016
Sheriffs Office - Contract Amendment #1 Law Enforcement Services in the Charter Township of Lyon 2016
M.R. #16290 - 10/26/2016
Circuit Court - 2017 Michigan Drug Court Grant Program (Adult Treatment Court) - Grant Acceptance
M.R. #16291 -10/26/2016
Circuit Court - 2017 Michigan Drug Court Grant Program (Juvenile Drug Court) - Grant Acceptance
M.R. #16298 - 11/10/2016
Sheriffs Office - Contract for Police Dispatch Services for the Village of Oxford 2017 - 2018
$ 444,064,379.00
$ 132,736.00
18,940.00
$ (39,235.00)
60,967.00
M.R. #16324 - 12/08/2016
Management & Budget Fiscal Year 2016 Year-End Report and Budget Amendments
Encumbrances $ 123,763.15
Carry Forwards $ 3,672,683,00 $ 3,796,446.15
M.R. #16331 - 12/08/2016
Human Resources Department - Fiscal Year 2017- Fiscal Year 2018 Collective Bargaining Agreement
for Employees Represented By the Oakland County Deputy Sheriffs Association (OCDSA) Law
Enforcement Unit
M.R. #16339 - 12109/2016
Sheriff's Office - Standard Law Enforcement Services Agreement with the Charter Township of Commerce,
January 1, 2017- December 31, 2018
$ 103,838.00
32,899.00
- 02/16/2017
Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance)
MR. #17025 - City of Huntington Woods
M.R. #17027 - City of South Lyon
M.R. #17028 - Township of Lyon
M.R. #17029 - City of Novi
6,833.00
12,578.00
13,923.00
83,333.00
$ 116,667.00
M.R. #17032 - 02/15/2017
Facilities Management/Facilities Planning and Engineering - Building Security Enhancements Project -
Jail K Block Intercom System Replacement
M.R. #17000 - 02/16/2017
Board of Commissioners - Establishment of an Oakland County Human Trafficking Task Force
M.R. #17023 - 02/15/2017
Sheriffs Office - Contract Amendment #1 for Law Enforcement Services in the City of Pontiac 2017/2018
M.R. #17024 -02/15/2017
Sheriffs Office - Use of Lab Enhancement Funds for Equipment Purchase
M.R. #17050 - 03/15/2017
Sheriffs Office - 2017 Michigan Medical Marihuana Operation and Oversight - Grant Acceptance
M.R. #17052 - 03/15/2017
Sheriffs Office - Contract Amendment #1 for Law Enforcement Services in the Charter Township
of Orion 2017/2018
M.R. #17046 - 03/15/2017
Department of Health and Human Services/Children's Village, Waterford School District Interlocal
Agreement, July 1, 2016 - June 30, 2019
M.R. #17045 - 03/15/2017
Department of Health and Human Services Children's Village Division - Oakland County Interlocal
$ 275,000.00
50,000.00
$ 161,586.00
59,872.00
2,525.00
65,755.00
$ 124,200.00
62
FY 2017 BUDGET AMENDMENTS
Agreement between Oakland County and the Oakland County Community Mental Health Authority
for Psychiatric Services for Oakland County Children's Village 75,000.00
M.R. #17043 03/15/2017
Management & Budget FY 2017 First Quarter Report
Adjustments to Circuit Court Child Care Fund
Adjustments to Sheriffs Office
Adjustments to Clerk/Register of Deeds - Elections
Adjustments to Children's Village Child Care Fund
Adjustments to Economic Development and Community Affairs
Adjustments to Fringe Benefits - Retirement
Adjustments to Fringe Benefits - Retirement - Child Care Fund
Adjustments to Non-Departmental
$ (27,569.00)
$ 111,250.00
$ 124,700.00
5,533,00
2,500.00
$ (5,532,077.00)
$ (187,407.00)
$ 27,569.00 $ (5,475,501.00)
M.R. 03/3012017
Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance)
M.R. #17061 - City of Farmington $ 14,489.00
M.R. #17062 - Township of Novi 1,066,00
15,555.00
M.R. #17060 - 03/30/2017
Sheriffs Office - Use of Forfeited Funds $ 402,986.00
TOTAL AMENDED BUDGET AS OF 03/3112017 $ 444,044,615.15
63
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT ENTERPRISE FUND TREASURER'S OFFICE ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DELINQUENT TAX REVOLVING FUND 61600 REVENUES Charges for Services $14,000,000.00 $14,000,000.00 $14,000,000.00 $0.00 0.00% Other Revenues 1,470,000.00 1,470,000.00 1,470,000.00 $0.00 0.00% Total Revenues $15,470,000.00 515,470,000.00 615,470,000.00 $0.00 0.00% OPERATING EXPENSES Personnel Expenditures Operating Expenditures $ 204,011.00 588,555.00 $ 199,524.00 $ 199,524.00 588,555.00 311,900.00 0.00% 276,655.00 47.01% Fay. Info Tech Development $200,000, and Professional Services $60,000 due to less than anticipated use. Also favorable Indirect Costs $16,600 actual charges determined after budget finalization. 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 223,069.00 3,048,178.00 9,000,000.00 1,582,700.00 1,877,800.00 1.310,800,00 $ 16.819,478.00 $ 17,835,113.00 223,069.00 3,048,178.00 9,000,000.00 1,582,700.00 1,877,800.00 1.310,800.00 $ 16.819 478,00 $ 17,830,626.00 125,000.00 3,048,178.00 9,000,000.00 1,582,700.00 1,877,800.00 1.310,800.00 $ 16.819,478.00 $ $ 17,455,902,00 98,069.00 43.96% Fav. related to lower debt interest rates. 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2.10% $ 374,724.00 REVENUE OVER (UNDER) EXPENDITURES* Total Net Position - Beginning Total Net Position - Ending ($2,365,113.00) ($2,360,626,00) ($1,985,902.00) $200,191,992.94 $198,206,090.94 $374,724.00 Ending FY 2016 Designated Net Positions: NP-UnRes - Designated - Debt Service NP-UnRes - Designated - Delinq Taxes Receivable NP-UnRes - Designated - Collection Fees Undesignated - Net Position Total Net Position - Ending $46,033,797.00 147,516,430.63 6,641,765.31 ($1,985,902.00) $198.206,090.94 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 64
$452,300.00 480,995.00 $450,000.00 342,900.00 $107,100.00 750.00 ($28,695.00) 750.00 $107,850.00 ($27,945.00) 165,942.82 $273,792.82 ($27,945.00) $ 107,350.00 OPERATING EXPENSE OPERATING REVENUE -0.51% - UnFav. Reimbursement Salaries less than anticipated activity. TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS NET OPERATING INCOME (LOSS) NON-OPERATING REVENUE (EXPENSE) TRANSFERS OUT TOTAL NET INCOME (LOSS)* ($34,259.00) TOTAL NET POSITION - BEGINNING TOTAL NET POSMON - ENDING 28.71% - Fay. Controllable Personnel $59,200 due to vacant and part-time positions. Favorable Indirect Cost $75,000 due to roll forward credit. Also, favorable Motor Pool Leased Vehicles $5,300 and Motor Pool Fuel Charges $2,500 due to less use. -473.24% 0.00% $135,795.00 $135,795.00 $452,300,00 487,309.00 ($2,300.00) $138,095.00 ($35,009.00) 750.00 ($34,259.00) $135,795.00 $0.00 COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT ENTERPRISE FUNDS TREASURER ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DELINQUENT PERSONAL PROPERTY TAX (51800) Please note that in the Adopted Budget (line-item book) this is budgeted as 'Planned Use of Balance" in the revenue category. 65
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT ENTERPRISE FUND PARKS & RECREATION ADOPTED BUDGET AMENDED BUDGET FY 2017 FORECAST VARIANCE FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES [OAKLAND COUNTY PARKS & RECREATION COMMISSION (5081101 OPERATING REVENUE OPERATING EXPENSE NET OPERATING INCOME (LOSS) NON-OPERATING REVENUE (EXPENSE) TOTAL INCOME BEFORE TRANSFERS TRANSFERS IN $ 9,975,565.00 $ 10,317,465.00 $ 10,317,466.00 $ $ 25,207,064.00 $ 25,730,206.00 $ 25,730,206.00 $ $ (15,231,499.00) $ (15,412,741.00) 5 (15,412,741,00) 5 5 13,208,900.00 5 13,503,728.00 $ 13,503,728.00 $ (2,022,599,00) 5 (1,909,013.00) $ (1,909,013.00) $ 0,00% Revenue and expense variances are not anticipated at this time since a majority of the revenue and expense activity occurs in the 3rd and 4th quarter. 0,00% 0.00% 0.00% 0.00% A FY2017 operating budget amendment is proposed for the purchase of 170 replacement golf carts in the amount of $272,425. Purchase was approved by the Parks and Recreation Commission at their March 1,2017 meeting. TOTAL NET INCOME/PLANNED USE OF BALANCE (LOSS)* as. $ (1,909,013,00) TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING 93,203,817.64 91,294,804.64 66
COUNTY OF OAKLAND FY 2917 SECOND QUARTER REPORT INTERNAL SERVICE FUND WATER RESOURCES COMMISSIONER ADOPTED AMENDED Fy 2017 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DRAIN EQUIPMENT FUND ( 63900) OPERATING REVENUES: Inside 541,681,166,00 $41,881,166.00 $38,331,166.00 ($3,500,000.00) -8.36% Unfav - Reimbursement Salaries ($3,500,000) due to unallocated payroll charges for turnover and vacant positions offset in Salaries and Fringes. Outside 161,000,00 161,000,00 161,000.00 $0.00 0.00% Total Revenue 42,042,166.00 42,042,166.00 38,542,166.00 (3,500,000,00) -8.32% OPERATING EXPENSES 42,901,850,00 42,179,056.00 38,323,463.00 3,555,593.00 9.14% Fav - Salaries $2,100,000 and Fringes $1,400,000 due to turnover and vacant positions. Fav - Depreciation $359,900 primarily due to change in implementation date to FY 2018 for the Supervisory Control and Data Acquisition (SCADA) system common to all project. Fay - Indirect Cost $100,584 due to a roll forward credit reducing the expense. Fay - Property Taxes $3,500 due to the tax exempt status now in effect on the Dixie Highway Building. Unfav - Info Tech Development ($53,000) due to continued implementation costs for the Stormwater, Asset, Management and Wastewater (SAW) common to all project. Unfav - Maintenance Contract ($35,000) for the Supervisory Control and Data Acquisition (SCADA) system maintenance contract charges; budget will be updated with the FY 2018-FY 2020 County Executive Recommended Budget. (859,684.00) (136,890.00) 218,703.00 355,593.00 -259.775'o 821,583.00 621,583,00 854,083.00 32,500.00 3.96% Fay - Income from Investment $30,000 the result of fund earning a return due to an improved cash balance. Fav - Interest Expense $2,000 a result of the decreasing principal balance and decrease in variable interest rate related to the Drain Equipment Storage Building. NET INCOME (LOSS) BEFORE NON-OPERATING REVENUE/(EXPENSE) 67
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT INTERNAL SERVICE FUND WATER RESOURCES COMMISSIONER ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES TRANSFER IN 0.00% TRANSFERS (OUT) NET REVENUES OVER (UNDER) (538,101.00) $684,693.00 61,072,786.00 $388,093.00 EXPENSES TOTAL NET POSITION - BEGINNING 16,107,614.30 $16,180,400.30 TOTAL NET POSITION - ENDING 68
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT INTERNAL SERVICE FUND RISK MANAGEMENT ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES LIABILITY INSURANCE FUND 67700 OPERATING REVENUES: Outside Revenue $ 10,397.00 $ 10,397.00 $ 10,397.00 $ Inside Revenue 3,623,171.00 3,623,171.00 3,623,171.00 0.00% Total Operating Revenue $ 3,633,568.00 $ 3,633,568.00 $ 3,633,568,00 $ 0.00% OPERATING EXPENSE $ 3,593,374.00 $ 3,575,317.00 $ 3,747,524.00 $ (172,507,00) -4.82% - Unfav. Medical Supplies ($75,040), Expendable Equipment ($63,555) and Professional Services ($33,882) due to replacement of Automated External Defibrillators (AED's) that will be retired by manufacture and the purchase of new AED's requested by departments. Second quarter budget amendment recommended for Medical Supplies, Expendable Equipment and Professional Services to more accurately reflect the budget with actual expenditures. CLAIMS PAID 1,178,895.00 1,178,895.00 1,178,895.00 0.00% TOTAL OPERATING EXPENSES $ 4,772,269.00 $ 4,754,212.00 $ 4,926,719.00 $ (172,507.00) -3.63% OPERATING INCOME (LOSS) (1,138,701.00) (1,120,644.00) (1,293,151.00) (172,507.00) 15.39% NON-OPERATING REVENUE (EXPENSE) 150,000.00 150,000.00 150,000.00 0.00% NET REVENUES OVERONDER) EXPENSES $ (988,701.00) $ (970,644.00) (1,143,151.00) $ (172,507.00) TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 6,431,731.14 5,258,580.14 69
205,000 1,172,700 296,700 996,000 100,000 615,200 99,200 460,000 2,929,000 450,000 16,300,000 205,000 1,172,700 296,700 996,000 100,000 615,200 99,200 460,000 2,929,000 450,000 16,300,000 33,952,500 33,952,500 9,921,000 9,921,000 EXT -TRAINING EKE- OTHER REVENUE - ICMA REBATES TOTAL REVENUE 7,600 10,000 10,000 10,000 140,798,000_ 132,750,441 141,923,641 7,600 0.00% 0.00% 9,173,200 6.91% COUNTY OF OAKLAND FY2017 SECOND QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND FRINGE BENEFITS FUND 67800 ADOPTED AMENDED BUDGET BUDGET FY2017 VARIANCE FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUE RETIREES MEDICAL - VEBA DEBT RETIREMENT ADMINISTRATION RETIREMENT ADMINISTRATION - PTNE DEFERRED COMPENSATION-MATCH DEFINED CONTRIBUTION PLAN 34,001,200 25,953,641 28,953,641 3,000,000 11.56% - Favorable due to actual revenue more than budget projection after reduction of retirement rate effective with the pay period beginning February 4, 2017 in an effort to reduce the equity position of the Fringe Benefit Fund. 3,045,800 3,045,800 3,176,500 130,700 4.29% - Favorable due to projected revenue more than budget projections. 200,000 200,000 200,000 0.00% 1,400,000 1,400,000 1,400,000 0.00% 17,280,000 '17,280,000 17,810,000 530,000 3.07% Favorable due to actual revenue more than budget projections - increase of new hires who participate in the Defined Contribution Plan. Offset by unfavorable expense. DEFINED CONTRIBUTION PLAN - PINE EMPLOYEE IN-SERVICE TRAINING EMPLOYEE RECOGNITION EMPLOYEE BENEFITS UNIT FLEX BENEFIT PLAN WELLNESS UNIT FRINGE BENEFITS TUITION REIMBURSEMENT RETIREMENT HEALTH SAVINGS GROUP LIFE INSURANCE SOCIAL SECURITY MEDICAL INSURANCE PRESCRIPTION COVERAGE INSURANCE 205,000 1,172,700 296,700 996,000 100,000 615,200 99,200 460,000 2,929,000 450,000 16,600,000 300,000 36,538,400 2,585,900 10,913,700 992,700 0.00% 00..0000% % 0.00% 0.00% 0.00% 0.00% 00..0000,y%, 1.84% - Favorable due to projected revenue more than budget projections - an increase in new hires. Offset by unfavorable related expense. 7.62% - Favorable due to projected revenue more than budget projections. Offset by unfavorable related expense. 10.01% - Favorable due to projected revenue more than budget projections, 15,75% - Favorable due to actual revenue more than budget projections. 80.58% - Favorable due to projected revenue more than budget projections. 2.10% Favorable due to actual revenue more than budget projections. Offset by unfavorable expense. 5,44% - Favorable due to projected revenue more than budget projections. 0.00% 0.00% -01..0305% - Unfavorable due to actual revenue less than budget projections. % 64.71% - Favorable due to actual revenue more than budget projections. 0.00% 00:0000%% 0.00% 0.00% 0.00% - Favorable due to forfeiture of non-vested International City Management Association (ICMA) accounts. DENTAL INSURANCE 3,174,000 3,174,000 3,674,000 500,000 VISION INSURANCE 190,500 190,500 344,000 153,500 DISABILITY INSURANCE 3,046,000 3,046,000 3,110,000 64,000 WORKERS COMPENSATION 3,267,400 3,267,400 3,445,200 177,800 UNEMPLOYMENT COMPENSATION 500,000 500,000 500,000 INVESTMENT INCOME 305,300 305,300 305,300 EXT - FLEX BEN MEDICAL- EMPLOYEE 5,200,000 5,200,000 5,130,000 (70,000) EXT - MEDICAL INSURANCE 180,000 180,000 180,000 EXT - PRESCRIPTION DRUG REBATES 850,000 850,000 1,400,000 550,000 EXT - DENTAL INSURANCE 16,000 16,000 16,000 EXT - VISION INSURANCE 1,500 1,500 1,500 EXT - FLEX BEN LIFE INSURANCE 400,000 400,000 400,000 EXT - FLEX BEN DENTAL INSURANCE 115,000 115,000 115,000 EXT FLEX BEN VISION INSURANCE 118,000 118,000 118,000 EXT - FORFEITURE OF DEPOSIT & DC PLAN 251,000 251,000 70
23,020,000 10,981,200 3,245,800 1,400,000 17,280,000 205,000 560,700 262,000 350,000 996,000 100,000 615,200 296,700 99,200 460,000 2,929,000 850,000 16,300,000 38,715,000 10,691,000 3,280,000 23,020,000 10,981,200 3,234,128 1,834,500 17,280,000 205,000 551,674 262,000 350,000 985,004 100,000 612,497 291,789 96,513 460,000 2,929,000 850,000 16,300,000 38,715,000 10,691,000 3,280,000 310,000 310,000 3,046,000 3,046,000 FRINGE BENEFITS FUND 67800 ADOPTED AMENDED BUDGET BUDGET COUNTY OF OAKLAND FY2017 SECOND QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND FY2017 VARIANCE FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 3,267,400 (530,000) (300,000) (2,585,900) 363,700 225,700 (64,000) 1,000,000 25,000 53,000 OPERATING EXPENSE RETIREES MEDICAL - VEBA DEBT PRINC. RETIREES MEDICAL - VEBA DEBT INT/AGING RETIREMENT ADMINISTRATION DEFERRED COMP-COUNTY PMTS (MATCH) DEFINED CONTRIBUTION PLAN DEFINED CONTRIBUTION PLAN - PINE EMPLOYEE IN-SERVICE TRAINING EMPLOYEE IN-SERVICE TRAINING - OTHER E IN-SERVICE TRAINING - INFO TECH EMPLOYEE BENEFITS UNIT FLEXIBLE BENEFIT PAYMENTS WELLNESS PROGRAM EMPLOYEE RECOGNITION ACCOUNTING SERVICES TUITION REIMBURSEMENT RETIREMENT HEALTH SAVINGS GROUP LIFE INSURANCE SOCIAL SECURITY MEDICAL INSURANCE PRESCRIPTION COVERAGE DENTAL INSURANCE VISION INSURANCE DISABILITY INSURANCE WORKERS COMPENSATION UNEMPLOYMENT COMPENSATION CHILD CARE FACILITY HEALTH INSURANCE PREMIUM TAX REINSURANCE FEES MICHIGAN HICAA TAX PATIENT CENTERED OUTCOME RESEARCH INDIRECT COSTS TOTAL EXPENSE NET REVENUE OVERAUNDER) EXPENSES TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 23,020,000 10,981,200 3,234,128 1,834,500 17,810,000 205,000 551,674 262,000 350,000 985,004 100,000 612,497 291,789 96,513 460,000 2,929,000 850,000 16,600,000 41,300,900 10,327,300 3,054,300 310,000 3,110,000 3,261,836 2,261,836 475,000 215,300 25,000 03,961,378 62,932,978 0.00% 0.00% 0.00% 0.00% -3.07% - Unfavorable due to actual costs more than budget projections - increase of new hires who participate in the Defined Contribution Plan. Offset by favorable revenue. 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -1.84% - Unfavorable due to projected costs more than budget projections - increase in new hires. Offset by favorable revenue. -6,68% - Unfavorable due to actual costs more than budget projections. 3.40% - Favorable due to actual costs less than budget projections. 6.88% Favorable due to actual costs less than budget projections. 0.00% -2.10% Unfavorable due to costs more than budget projections. Offset by favorable revenue. 30.66% Favorable due to one vacant position and the Workers Compensation Claims costs trending less than budget projections. 5.00% Favorable due to projected costs less than budget projections. 0.00% 67.95% Favorable due to the Health Insurance Premium Tax being suspended for one year, and the Transitional Program Fee expiring in 2016. 0.00% 0.00% 0.00% 45.40% - Favorable due to actual charges developed after budget finalization. -1.25% 241,000 385,000 18,500 54,600 45,400 142,952,041 (1,767,100) (1,028,400) 7,406,100 500,000 500,000 215,300 215,300 78,000 78,000 241,000 241,000 385,000 385,000 18,500 18,500 100,000 100,000 140,798,000 141,184,941 0.00 (8.434,500.00) 71
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT ENTERPRISE FUNDS CENTRAL SERVICES ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAVONFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES WAKLAND COUNTY INTERNATIONAL AIRPORT (56500) OPERATING REVENUE $4,415,400.00 54,415,400.00 $4,516.900.00 $101,500.00 2.30% - Fav. Land Lease $70,000 due to higher than anticipated land leases, T Hangar Rental $50,000 due to an increase in the number of T Hangar's being leased, Aviation Gas $10,000 due to higher than anticipated gas concessions, and Car Rental Concessions $10,000 due to increased car rentals; Unfav. Miscellaneous ($38,500) due to Airport Expo not held this Fiscal Year. OPERATING EXPENSE 6,765,378.00 6,724,657.00 5,619,257.00 105,400.00 1.57% - Fav. Personnel $228,700 due to under filled positions, retirement emergency salaries not used and less than expected hospitalization and retirement costs. Also fav. Grounds Maintenance $20,000 due to less than anticipated snow removal services, Gasoline Charges $10,000 due to lower gasoline costs and Maintenance Supplies $10,000 due to less than expected maintenance supply purchases. Unfav. Professional Service ($56,000) due to asphalt repairs on runway at Oakland/Southwest Airport and pavement crack filling at Oakland International Airport, Equipment Maintenance ($50,000) due to repair of fuel separator equipment, Indirect Costs ($22,300) due to actual charges being developed after budget finalization, Water and Sewer Charges ($20,000) due to higher than anticipated water use for ground sprinklers, and Building Maintenance Charges ($15,000) due to the repair and painting of the airport maintenance building. NET OPERATING INCOME (LOSS) (52,349,978.00) ($2,309,257.00) ($2,102,357.00) $205,900.00 -8.96% NON-OPERATING REVENUE (EXPENSE) 245,000.00 245,000.00 245,000.00 0.00 0,00% TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS ($2,104,978.00) ($2,064,257.00) $ (1,857,357.00) $206,900.00 TRANSFERS IN CAPITAL CONTRIBUTION 0.00 0.00 0.00 $0.00 0.00% TOTAL NET INCOME (LOSS) ($2,104,978.00) (52,064,257.00) ($1,857,357.00) $206,900.00 TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING $ 77,525.805.00 $75,668,448.00 72
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT INTERNAL SERVICE FUNDS CENTRAL SERVICES ADOPTED BUDGET AMENDED BUDGET FY2017 FORECAST VARIANCE FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 1MOTOR POOL FUND 66100 OPERATING REVENUE: Outside Revenue $ 112,000.00 $ 112,000.00 135,000.00 $ 23,000.00 20.54% - Fav. External Revenue $23,000 due to greater than anticipated restitution, litigation and subrogation payments. Inside Revenue Total Revenue 8,154,424.00 8,261,803.00 8,266,424.00 8,373,803.00 7,928,803.00 8,063,803.00 (333,000.00) (310,000.00) -4.03% - Unfav. Gasoline, Oil & Grease Charges ($400,000) due to decreased fuel cost; partially offset by a favorable variance for Gasoline Charges. Fav. Leased Equipment $67,000 due to fleet expansion and the replacement of vehicles from the old rate plan being retired and replaced with vehicles on the new rate plan. OPERATING EXPENSE 8,986,941.00 9,027,413.00 8,811,513.00 215,900.00 2.39% - Fav. Gasoline Charges $300,000 due to decreased fuel cost, Information Technology services $11,000 based on use, Hospitalization Expenses $16,000 fell lower than anticipated and actual Insurance premiums were less than expected by $40,000 due to insurance market rate fluctuations. Unfav. Depreciation ($112,000) due to the replacement of fully depreciated vehicles, an increase in Indirect Costs ($26,100) due to the development of actual charges after budget finalization and a Prior Period Expense Adjustment ($13,000) for an expense not recognized in the prior year. OPERATING INCOME (LOSS) (720,517.00) (653,610.00) (747,710.00) (94,100.00) NON-OPERATING REVENUE 385,000.00 385,000.00 385,000.00 0.00% (EXPENSE) NET INCOME (LOSS) BEFORE OPERATING TRANSFERS (335,517.00) (268,610.00) (362,710.00) (94,100,00) TRANSFERS IN / (OUT) 24,563.00 207,796.00 207,796.00 NET REVENUE OVER/(UNDER) EXPENSES (PLANNED USE OF FUND BAL.)* $ (310,954.00) $ (60,814.00) (154,914,00) $ (94,100.00) TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 9,248,969.00 $ 9,094,055.00 73
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT INTERNAL SERVICE FUND FACILITIES MANAGEMENT ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET ACTUAL FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES FACILITIES MAINTENANCE & OPERATIONS (#63100) 1 NET INCOME (LOSS) BEFORE OPERATING TRANSFERS 529,073.00 $ 65,000.00 14.01% - Fay. Ext - Other Revenue primarily due to more than anticipated Outside Agencies Maintenance Charges for Oakland County Community Mental Health Authority (OCCMHA). 0.20% Fay. Maintenance Dept Charges based on Department requests. 0.44% 7.14% -Fay. Sublet Repairs $800,000 due to more efficient management of building maintenance; Natural Gas $550,000 due to purchasing natural gas from third party sources, mild weather conditions and lower market prices; Salaries and Fringe Benefits $450,000 due to underlined/vacant positions; Electrical Service $226,000 due to lower-cost third-party contracts and savings from FM&O energy conservation initiatives; Water & Sewage Charges $125,000 based on actual usage; Security Supplies $75,000 due to the use of alternative sources of funding (security enhancement). Partially offset by unfav. Info Tech Development ($125,000) due to Collaborative Asset Management System (CAMS) mobile upgrade, infrastructure, GIS, and building management system; Info Tech Operations ($50,000) due to AutoCAD and Kronos software maintenance along with one-time IT equipment purchase; Adj Prior Years Exp ($50,000) due to adjustment of sewage charges and Telephone Communications ($25,000) due to telephone upgrades. OPERATING REVENUES: Outside Revenue 464,073.00 $ 464,073.00 $ Inside Revenue 25,547,867.00 25,547,867,00 Total Revenue $ 26,011,940.00 $26,011,940.00 OPERATING EXPENSES $ 27,958,969.00 $27,669,622,00 25,597,867.00 $ 26,126,940.00 $ 25,694,622.00 50,000,00 $ 115,000.00 $ 1,975,000.00 $ (1,947,029.00) $ (1,657,682.00) $ 432,318.00 $ 2,090,000.00 NON-OPERATING REVENUE 100,000.00 $ 100,000.00 $ 100,000.00 $ 0.00% TRANSFERS IN TRANSFERS OUT $ 653,221.00 $ 653,221.00 (24,563.00) $ (24,563.00) $ (773,781.00) $ (749,218.00) 0.00% Transfers In from Project Work Order Fund for closed Maintenance Projects. 0.00% Transfers Out to Project Work Order Fund to close Maintenance Projects. A third quarter budget amendment will be completed to close Maintenance Projects. NET REVENUES OVER(UNDER) EXPENSES" (1,871,592.00) $ (1,582,245,00) $ 411,758.00 $ 1,994,003.00 TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING $ 9,808,349.70 $ 10,220,107.70 *Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category. 74
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT INTERNAL SERVICE FUNDS! ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET Information Technology - Operations (63600) AMENDED BUDGET FY 2017 FORECAST VARIANCE FAVI(UNFAV1 PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUES: Outside $1,794,428.00 $1,798,666,00 $2,222,365.00 $423,500.00 23.54% Fav. Enhanced Access Fees $537,200, Managed Print Services $15,100 and Deferred Land File Tax $6,300 due to higher than anticipated usage. Offset by unfavorable Outside Agencies ($130,400) and Reimb Equalization Services ($4,300) due to reduction in external customer requests. Inside 24,857,946.00 24,889,158.00 24,487,518.00 (401,640,00) -1.61% Unfav. OC Depts Development Support & Non Governmental Development ($617,200) and OC Depts Operations & Non Governmental Operations ($43,200) clue to rates remaining at prior year levels and limited resources available to complete development due to vacancies. Offset by favorable Prior Year Adjustments $182,762 due to prior year expense of equipment purchases. Also, CLEMIS Operations $76,000 due to actuals higher than anticipated. TOTAL OPERATING REVENUE $26,652,376.00 $26,588,024.00 $26,709,884.00 $21,860.00 0.08% OPERATING EXPENSES $36,391,110.00 $36,603,025,00 634,979,625.00 $1,623,400.00 4.44% - Fav, Salaries & Fringes $1,581,000 due to vacant positions; Expendable Equipment $579,000 for equipment replacement and Printing $63,000 due to less anticipated use. Offset by unfav. Software Maintenance ($291,000) due to timing of software support; Charge Card Fees ($270,600) for increased credit card activity and Professional Services (635,000) for previously approved IT projects. 61,645,260,00 12,600,00 11.94% Fay. primarily due to Interest Income; higher cash balance than anticipated. 58,100.00 1.40% Fay due to completion of the following projects: Info Tech Reference Archietecture Project-Computer Room Reconfigeration project per 12/26116 FM0 Project Work Order Closure memo. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS ($9,735,734.00) ($9,915,001.00) (68,269,741.00) NON-OPERATING REVENUE 105,500,00 105,500.00 118,100.00 TRANSFERS IN 3,906,676.00 4,143,349.00 4,201,449.00 TRANSFERS (OUT) 0.00% CAPITAL CONTRIBUTION 325,000.00 325,000.00 3,119,100.00 2,794,100.00 0.00% Fay Capital Contributions revenue recognized for building authority capital projects for ff. NET REV OVER(UNDER) EXP" (65,401,558.001 ($5,341,152,00) ($831,092.00) 64,510,060.00 TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING 26,406,564.94 625,575,492.94 *Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category. 75
$2,863,908.00 $2,873,408.00 $2,872,215,00 ($9,500.00) -0.33% Unfav. Professional Services ($18,100) due to higher than anticipated contract rates and Depreciation ($3,400) based on projected depreciation schedules. Offset by fav. Tower Charges $12,000 due to decreased pager usage. ($9,610.00) ($17,917.00) ($9,500.00) ($19,110,00) 36,800.00 30,000.00 30,000.00 900,000.00 900,000.00 $917,490.00 $897.100.00 $20,390.00 $12,083,00 TOTAL NET POSITION - ENDING 4,420,527.07 $5,338,017.07 OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN CAPITAL CONTRIBUTION TRANSFERS (OUT) NET REV OVER(UNDER) EXP* TOTAL NET POSITION - BEGINNING 6,600.00 22.00% Fav, primarily due to Interest Income; higher cash balance than anticipated, 0.00% 0.00% Due to timing for Unified Communications and Collaboration project funded by Building Authority. 0.00% COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT INTERNAL SERVICE FUNDS !ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAV/f UNFAV1 PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - Telephone Communications (67500) OPERATING REVENUES: Outside $12,000.00 $12,000,00 $12,000.00 $ 0.00% Inside 2,842,298.00 2,842,298.00 $2,842,298.00 0.00% TOTAL OPERATING REVENUE $2,854,298.00 52,854,298,00 $2,854,298.00 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. 76
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET Information Technology - CLEMIS (53500) AMENDED BUDGET FY 2017 FORECAST VARIANCE FAVHUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUES: Outside $4,425,955.00 $4,425,955.00 $4,600,655.00 $174,700.00 3.95% Fay. Access Fees Non Oakland $65,800 due to updated law enforcement Full Time Equivalent count used for billing (offset by unfav. Access Fees Oakland ($4,200); CLEMIS Crash $54,300, Maintenance Contracts $11,000 due to Livescan maintenance after warranty; In-Car Terminals External $8,300 for fleet of CLEMIS agencies; CLEMIS Citation $35,100 and Crime Mapping $4,200 due to increased usage by Oakland and non-Oakland agencies. Inside 1,839,178.00 1,842,623.00 1,827,723.00 (14,800.00) -0.80% Unfav. primarily due to Service Fees based on actual billing for Computer Aided Dispatch (CAD) expense charge directly to Radio Fund. TOTAL OPERATING REVENUE $6,265,133.00 $6,268,478.00 $6,428,378.00 $159,900.00 2.55% OPERATING EXPENSES $10,945,881,00 $10,886,435.00 $8,986,135.00 $1,000,300.00 17.46% Fay. Depreciation $1,241,500 based on projected depreciation schedules; Salaries & Fringe Benefits $314,200 due to vacancies; Internal Services $253,500 primarily due to IT Development based on actual usage; Bank Charges $179,000 due to less than anticipated costs for PayPal services for E-Commerce transactions; Software Maintenance $137,800 due to support internally; Communications $101,200 due to actual costs less than anticipated; Rebillable Services $50,000 based on actual connectivity costs to Tier 2.5 and 3,0 agencies and Printing $2,000 based on actual usage. Offset by unfav. Professional Services ($247,100) due to higher than anticipated contractual costs for staffing services; Equipment Maintenance ($100,000) due to cost of repairs; Indirect Cost ($6,900) due to charges determined after finalization of the budget; Supplies ($19,800) and Travel ($5,100) due to usage. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS ($4,660,748.00) ($4,617,957.00) ($2,557,757.00) $2,060,200.00 NON-OPERATING REVENUE 35,000.00 35,000,00 116,200.00 81,200.00 232.00% Fay. primarily due to Interest Income; higher cash balance than anticipated. TRANSFERS IN 1,844,186.00 1,844,186.00 1,844,186.00 0.00% TRANSFERS (OUT) 0.00% CAPITAL CONTRIBUTION 0.00 0.00 0.00 0.00% NET REV OVER(UNDER) EXP* ($2,801,562.00) ($2,738,771.00) ($597,371.00) $2.141,400,00 TOTAL NET POSITION - BEGINNING 17,904,957.03 TOTAL NET POSITION - ENDING $17 307,586.03 Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses. 77
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT INTERNAL SERVICE FUNDS! ENTERPRISE FUND INFORMATION TECHNOLOGY FY 2017 VARIANCE FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ADOPTED AMENDED BUDGET BUDGET $6,977,700.00 Information Technolo y - Radio Communications I53BO0) OPERATING REVENUES: Outside $6,965,000.00 $6,965,000.00 $12,700.00 0.18% Fav, Outside Agency Revenue $4,000 due to fewer non-emergency agencies than anticipated and Antenna Site Management $8,700 due to updates in rental contracts, Inside 470,788.00 470,788.00 567,788.00 97,000.00 20.60% Fav. Prior Year Adjustment $45,300 due to FY 2015 expenditure accruals not reversed in FY 2016; Parts Access $27,000 reimbursement by participating agencies for equipment replacement; Leased Equipment $16,200 due to higher than anticipated non-public users and Productive Labor $8,500 due to Mobile Data Computer repairs for OC Agencies. TOTAL OPERATING REVENUE $7,435,788.00 $7,435,788.00 $7,545,488.00 $109,700.00 1.48% OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN TRANSFERS (OUT) CAPITAL CONTRIBUTION NET REV OVER(UNDER) EX?' $14,114,895.00 $14,147,140.00 $10,813,340.00 $3,333,800.00 ($6,579,108.00) ($6,711,352,00) ($3,267,852.00) $3,443,500.00 180,000.00 180,000.00 198,700.00 18,700,00 39,000.00 39,000.00 286,000.00 286,000.00 286,000.00 ($6,213,108.00) ($6,206,352.00) ($2,744,152,00) $3,462,200.00 23.57% Fay. Depreciation $1,319,800 based on projected depreciation schedule; Software Maintenance $1,302,700 due to the timing of the Emergency Services tp Network project; Professional Services $249,600 due to project usage; Internal Services $217,900 primarily due to Info Tech CLEMIS based on usage; Equipment Maintenance $146,400 due to maintenance costs; Salaries & Fringe Benefits $115,200 due to vacancies; Expendable Equipment $78,800 due to the timing of equipment purchases; Tower Charges $45,900 for tower rental agreements; Travel $86,300, Special Projects $39,000, Utilities $36,300 and Supplies $7,000 due to usage. Offset by unfav. Parts and Accessories ($175,000); Communications ($85,100) for connectivity costs for cell tower sites used for coverage enhancements of the Radio system; Adjust Prior Year Rev ($34,500) to correct for a prior year's accrual adjustment and Indirect Cost ($16,500) due to charges determined afar finalization of budget. 10.39% Fay. primarily due to Interest Income; higher cash balance than anticipated. 0.00% 0,00% 0,00% TOTAL NET POSITION BEGINNING TOTAL NET POSITION - ENDING 38,395,729.87 $35,651,577.87 Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses. 78
COUNTY OF OAKLAND FY 2017 SECOND QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY Fire Records Management ($3109) ADOPTED BUDGET AMENDED BUDGET FY 2017 FORECAST VARIANCE FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUES: Outside $214,665.00 $214,665,00 $216,965.00 $2,300.00 1.07% Fay. primarily due to Participation Fee Revenue for to the addition of City of Livonia Fire Department TOTAL OPERATING REVENUES $214,665.00 $214,665,00 $216,955.00 $2,300.00 1.07% OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE $719,350.00 ($504,685.00) 3,000.00 $709,835,00 ($495,220.00) 3,000.00 $651,965.00 ($435,020.00) 4,800.00 $57,900.00 8.16% Fay. Salaries & Fringes $28,300 due to vacancies; Communications $19,000 due to decrease in connectivity rates; Depreciation $11,300 based on projected depreciation schedule; Expendable Equipment $6,000 due to the timing of equipment purchases made by tech support for maintaining the system; Software Maintenance $4,300 due to decrease in maintenance costs and TraveI $3,000 due to less than anticipated use. Offset by unfav. overall Internal Services ($14,000) primarily due to IT Development ($8,500) and IT Operations ($5,100) based on actual usage. $60,200.00 1,300.00 60.00% Fay, primarily due to Interest Income; higher cash balance than anticipated. TRANSFERS IN 461,742.00 461,742.00 461,742.00 0.00% TRANSFERS (OUT) 0,00% CAPITAL CONTRIBUTION 0,00% NET REV OVER(UNDER) EXP' TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING ($39,943.00) ($30,478.00) $31,522.00 1,369,874.24 $1,401,396.24 $62,000.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. 79
2017 UNCOLLECTABLE HOME IMPROVEMENT LOANS
COMMUNITY DEVELOPMENT BLOCK GRANT
CASE # BAL DUE
5349 $ 7,980.02 i
6198 $ 15,322.00
6203 $ 20,240.00
6355 $ 28,367.88
6437 $ 19,485.59
6514 $ 18,652.99
6745 $ 13,275.00
6797 $ 8,770.00
7142 $ 7 171 00
2226 $ 6,754.00
2614 $ 8,155.00
2837 $ 7,000.00
2851 $ 6,970.00
3283 $ 7,684.00
4380 $ 9,818.00
4816 $ 12,100.00
5234 $ 13,200.00
5425 $ 24,396.65
5374 $ 17,181.00
5851 $ 19,461.00
5891 $ 20,000.00
TOTAL: $ 291,984.13
Total Write offs: 21
01/17 to 03/17
80
2017 UNCOLLECTABLE HOME IMPROVEMENT LOANS
HOME INVESTMENT PARTNERSHIP ACT ACCOUNTS
CASE # BAL DUE
9178 $ 19,981.00
9244 $ 16,620.00
8420 $ 18,039.00
10638 $ 6,584.00
9462 $ 18,325.00
9610 $ 20,342.00
9625 $ 16,574.00
9631 $ 19,401.00
9674 $ 12,259.00
9786 $ 18,995.00
9834 $ 14,950.00
9856 $ 19,605.00
10029 $ 22,225.00
10488 $ 14,531.00
10515 $ 7,470.00
11199 $ 23,716.00
8141 $ 9,900.00
8208 $ 9,819.00
8309 $ 11,798.00
8401 $ 12,045.00
8441 $ 12,060.00
8482 $ 11,680.00
8541 $ 14,492.00
8591 $ 13,200.00
8731 $ 13,101.00
8971 $ 15,590.00 '
8981 $ 12,861.00
8998 $ 14,208.00
9042 $ 20,000.00
9062 $ 18,736.00
8441 $ 12,060.00
TOTAL: $471,167.00
TOTAL AMOUNT UNCOLLECTABLE:
Write offs: 01/17-03/17
*Client has more than one loan
Total Write offs: 31
rand total of Write offs: 5
1 763,151.13
81
tOAKIAMIT--
4
COUNTY MICHIGAN
L. BROOKS PATTERSON, OAKLAND COUNTY EXECUTIVE
Mark Newman, Mentor
MEMO
To: Lynn Sonkiss, Fiscal Services Officer
From: Mark Newman, Director of Public Services Pe 111/4
Date: May 12, 2017
RE: City of Royal Oak Animal Control Invoice
Lynn,
I received a call from the Assistant Manager of the City of Royal Oak, Corey O'Donohue disputing
the attached invoice. He indicated that no one from the city authorized the holding of the animal
that is described in invoice ANC0000663 dated January 31, 2017. After a discussion with Robert
Gatt, Manager - Oakland County Animal Shelter it was discovered that this animal was brought to
the Animal Shelter by a private citizen with no authorization from the city of Royal Oak.
Therefore, the city of Royal Oak should not be billed.
EXECUTIVE OFFICE BUILDING 41 WEST- 2100 PONTIAC LAKE ROAD, DEPT 409 WATERFORD, MI 48328-0409 • (248) 858-1074 • FAX (248) 452-9215
82
INVOICE Invoice:
Invoice Date:
Page:
0
COUNTY MICHIGAN
Make Checks Payable to
=ANC) COUNTY
THLkOORERS-CASH AOOTG BLDG 12 E
1200 N TELEGRAPH RD
PONTIAC MI 48341-0479
ANG0000663
1/31/2017 •
1 of
ANC00000016
NET 30
3/2/2017
CITY OF ROYAL OAK ANIMAI CONTROL
ATTN MEGAN OLPERE
: 221 E 3R0 ST
ROYAL om MI 48067-2602
168.00 USD
For billing questions, please call: -248-858-1216
Line Desception Quantity UOM
Unit Amt Net Amount
1 ' Animal Control Service Fees 1.00 EA 7.00 7.00
Original
• L/
Animal Control Pound Fees
ANIMAL CONTROL SERV ICES - JANUARY 2017
1.00 EA 161.00
Subtotal:
AMOUNT DUE:
161.00
156,00
168.00
PLEASE INCLUDE YOUR INVOICE NUMBER WHEN SUBMITTING PAYMENT.
83
Department of Health and Human Services Oakland County Children's Village Donation Tracking : Donation Period January 2017 to March 2017 Date: Donor: Cash/Check: Items: Estimated Value: University Presbyterian Church Frozen Birthday Cakes (3) Months $495.00 1/9/2017 Jorge Roman Books $100.00 1/10/2017 Marie Carriere Hats, Socks, Toiletries $15.00 1/13/2017 American House Store 21 Knitted Scarves $100.00 1/13/2017 Audrey Moon Embroidery Floss $50.00 1/13/2017 Brittany Harville Toys, Games, & Puzzles $75.00 1/13/2017 Sweet Dreams for Kids 15 Pillow Cases $75.00 1/17/2017 Mary Ann Schick 91 Beanie Babies $200.00 1/18/2017 Mark Ryden Craft Supplies $10.00 1/20/2017 Sharon Moore Clothes $100.00 1/26/2017 Clarkston Senior Center Craft Items $5.00 1/27/2017 Marina Mayton Clothes $50.00 2/1/2017 Waterford Public Library Yarn $8.00 2/2/2017 Clarkston Senior Center Yarn $10.00 2/3/2017 Deb Shea Magazines $5.00 2/10/2017 Grace Centers of Hope Toiletries $100.00 2/13/2017 Great Lakes Heritage Quilters 12 Quilts $600.00 2/13/2017 Audrey Moon Yarn $50.00 2/13/2017 Sweet Dreams for Kids 15 Pillow Cases $75.00 2/15/2017 Waterford Public Library Yarn $20.00 2/21/2017 Holy Family School Care Packages $300.00 2/24/2017 Datsun Doctor 21 Magazines for Lobby $10.00 2/28/2017 Cub Scout Pack 1081 Bags of Toys $100.00 3/2/2017 Sarah May 10 Cases Depends - 10 Boxes Gloves $300.00 3/3/2017 Pam Morgan 30 Boxes of Girl Scount Cookies $120.00 3/4/2017 Grace Christian Church Food for party @TAG&BTS & Crafts $280.00 3/6/2017 Mark & Chris Brown Wii Game, Controllers & Games $200.00 3/15/2017 Waterford Public Library Yarn $40.00 3/16/2017 Sweet Dreams for Kids 15 Pillow Cases $75.00 3/16/2017 Dedra Jenkins Clothes $150.00 3/20/2017 Brittany Harviile Clothing & Toys $15.00 3/31/2017 Clarkston Senior Center Adults Diapers & Yarn $280.00 Total: $4,013.00 1:\ChildVil\Clerical\Billing\Donations\FY17 Donation Tracking Sheet.xlsx 84
HEALTH DIVISION
FY 2017 2nd Quarter Report For Contributions (Donations)
January 1, 2017 - March 31, 2017
Project/Program Source Amount
Health Education Michigan Public Health Institute (MPHI) $ 549.52
Grand Total $ 549.52
85
If approved, each of the above listed personnel will be receiving a K-9 vest.
SinceNly,
iehael McCabe
Undersheriff / Chief Deputy
Oakland County Sheriff's Office
1200 N. Telegraph Bldg. 38 East
Pontiac, Michigan 48341
COUNTY OF OAKLAND
OFFICE OF THE SHERIFF
MICHAEL J. BOUCHARD
April 4, 2017
Mrs. Laurie Van Pelt
Director of Management & Budget
Oakland County
2100 Pontiac Lake Road
Executive Office Building
Waterford, MI 48328-0409
RE: Approval for donation of six 1(9 vests
Dear Mrs. Van Pelt,
In accordance with the Oakland County Board of Commissioners Miscellaneous Resolution # 83204, this letter
is to inform you that Vested Interest in 1(9's {50143)} has offered to donate six lifesaving body armor vests to
the Oakland County Sheriff's Office. The non-profit was established in 2009 to assist law enforcement
agencies with this potentially lifesaving body armor for their four-legged K-9 Officers. All vests are custom
made in the USA by Armor Express in Central Lake, Michigan.
The program is open to dogs actively employed in the United States with law enforcement who are certified
and at least 20 months of age. The donation of each protective vest for a law enforcement K-9 is estimated to
be worth $1,050 for a total of $6300. Each vest has a five-year warranty, and an average weight of 4 pounds.
This donation would allow the Sheriff Office to provide protection to the following personnel:
Deputy Dick and his K-9 Clay
Deputy Pesko and his K-9 Bolt
Deputy Topacio and his K-9 Mordus
Deputy Kershaw and his K-9 Jax
Deputy White and his K-9 Diago
Deputy Cadotte and his K-9 Odin
86
OAKLAND COUNTY PARKS & RECREATION
COMMISSION AGENDA
WEDNESDAY, JUNE 7, 2017 AGENDA ITEM No. FOR ADMIN'S USE
PLANNING &RESOURCE DEVELOPMENT
To: Chairman Fisher and Commission Members
From: Daniel J. Stencil, Executive Officer
Melissa Prowse, Supervisor of Planning & Resource Development
Submitted: June 2, 2017
Subject: FY 2017 2" Quarter Contributions Report
INTRODUCTION AND HISTORY
Attached is the FY 2017 2 ' Quarter report for contributions received from January 1, 2017 through March 31,
2017.
ATTACHMENTS
FY 2017 2" Quarter Contributions Report
STAFF RECOMMENDATION
The staff recommends to receive and file.
MOTION
Consent Agenda
87
Totals $3.00 $1.00 Independence Oaks.PirliSub4ota.fi $35.00 - Lyon Oaks Golf Course Sub-Total $5.00 $5.00 $5.00 5.00 $5.00 OAKLAND COUNTY PARKS & RECREATION COMMISSION FY 2017 2nd Quarter Report for Contributions (Donations) -January 1, 2017 - March 31, 2017 Budget Center Project / Program Source Amount IND General Donation IND General Donation LYG General Donation REC Tuning Your Tot Contribution REC Tuning Your Tot Contribution REC Tuning Your Tot Contribution REC Tuning Your Tot Contribution REC Tuning Your Tot Contribution REC Tuning Your Tot Contribution REC Tuning Your Tot Contribution SAC 2016 Ellis Barn Dance Proceeds Stepanski Childcare Park Patron J. David VanderVeen Park Patron Park Patron Good Shepard Church Nature Center St. Joseph Elementary St. Joseph Elementary Recreation PrOgrams.& Services Sub-Total Clarkstciri Community Historical Society $571.15 Springfield dl6kS Activity Center Sub-Total.' $35.00 -$571.15 FY2017 2nd Quarter Contributions (Donations) Revenue Grand Total $645.151 88
Resolution #17170 June 15, 2017
Moved by Berman supported by Quarles the resolutions (with fiscal notes attached) on the amended
Consent Agenda be adopted (with accompanying reports being accepted).
AYES: Crawford, Dwyer, Fleming, Gershenson, Gingell, Hoffman, Jackson, Kochenderfer,
Long, McGillivray, Middleton, Quarles, Spisz, Taub, Weipert, Woodward, Zack, Berman,
Bowman. (19)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the amended
Consent Agenda were adopted (with accompanying reports being accepted).
I HEREBY APPROVE THIS RESOLVION
CHIEF DEPUTY COUNTY EXECUTRX
ACTING PURSUANT TO MCI. 45,509A (7)
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Lisa Brown, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and
accurate copy of a resolution adopted by the Oakland County Board of Commissioners on June 15, 2017,
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 15th day of June, 2017.
Lisa Brown, Oakland County