HomeMy WebLinkAboutResolutions - 2017.09.28 - 23112MISCELLANEOUS RESOLUTION #17264 September 28, 2017
BY: Commissioner Thomas Middleton, Chairperson, Finance Committee
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2017 THIRD
QUARTER FINANCIAL FORECAST AND BUDGET AMENDMENTS
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of
Government, provides for adjustments to the adopted budget; and
WHEREAS in accordance with Oakland County General Appropriations Act Section 22, which authorizes
budget amendments for variances between the budgeted revenue and actual revenue, and Section 23,
which authorizes budget amendments for variance between estimated revenue and projected
expenditures, amendments are required; and
WHEREAS the Fiscal Year (FY) 2017 Third Quarter Financial Forecast Report has identified several
variances and budget amendments are recommended; and
WHEREAS the Circuit Court, along with the County Clerk and Information Technology (IT) are working on
a project to migrate from the current e-filing environment to the new mandatory statewide e-filing system,
the goal of which is to complete implementation by January 1, 2018 to ensure that Oakland County can
continue to e-file by adopting the statewide electronic filing solution. This implementation project is aligned
to comply with the legislation in which the current fee-based e-filing application will no longer be an option
for courts in Michigan after December 2017. The estimated 1,211 IT Development hours, which equates
to approximately $167,000, are planned for the remainder of FY 2017 and early FY 2018 to complete the
project with funding available from the existing non-departmental General Fund IT Development line item;
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 totaling $48,985 is being recognized for eligible personnel, forensic lab and training costs;
and
WHEREAS a budget amendment is recommended for the Sheriff's Office in the amount of $200,000 for FY
2017 and $40,000 for FY 2018 — 2020 as Gun Registrations are no longer collected by the department.
Per Public Act #3 of 2015 Concealed Pistol Licensing fees are collected by the Clerk/Register of Deeds
(#20300); and
WHEREAS a budget amendment of $175,000 is recommended for Sheriff's Office to reallocate Fringe
Benefit Adjustment line item from Sheriff Emergency Response and Preparedness division (4030501) to
Sheriff Emergency Communications Operations Center division (4030701); it was not included in M.R.
#16253 which moved budgets to the new division; and
WHEREAS a budget amendment is recommended for the Sheriff's Office to return $1,044 from the
Sheriff's General Fund to the Prosecuting Attorney's Operating While Intoxicated (OWI) Crime Victims
Fund (#21393) to correct allocation of net auction proceeds (per M.R. #17093); and
WHEREAS a budget amendment is recommended for the Health Division to accept a grant award of
$6,000 from the Michigan State University Center for Regional Food Systems for the 2017 Michigan Local
Food Council Network Seed Grant Program; M.R. #17194 authorizes Management and Budget to
administratively process grant agreements and grant amendments of $10,000 or less, after review and
approval by Management and Budget, Human Resources, Risk Management and Corporation Counsel
when the grant does not require an associated interlocal agreement, there are no position changes and
the grantor does not require a separate resolution; and
WHEREAS a budget amendment of $35,500 is recommended to transfer funds from Animal Control's
Legacy Fund (#21310) to Animal Control's General Fund budget to cover expenditures in various line
items; and
WHEREAS a budget amendment is recommended for Children's Village Division in the amount of $142 to
transfer funding from the Children's Village Donations Fund (#21330) to the Child Care Fund (#20293)
which properly accounts for eligible expenditures for Children's Village Donation funding; and
WHEREAS a budget amendment is recommended for Circuit Court to reallocate funding in the amount of
$1,310 from Fringe Benefits to Salaries to reflect Amendment #1 within fifteen percent of the FY 2017
Michigan Drug Court Grant Program (MDCGP) Juvenile Drug Court grant agreement (M. R. #16291); and
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote.
WHEREAS a budget amendment is recommended for Friend of the Court to accept additional funding in
the amount of $6,000 from State Court Administrative Office (SCAO) for the FY 2017 Access and Visitation
Grant Amendment #1; M.R. #17194 authorizes Management and Budget to administratively process grant
agreements and grant amendments of $10,000 or less, after review and approval by Management and
Budget, Human Resources, Risk Management and Corporation Counsel when the grant does not require
an associated interlocal agreement, there are no position changes and the grantor does not require a
separate resolution; and
WHEREAS a budget amendment is recommended for 52/4 District Court-Troy to reallocate funding in the
amount of $12,022 from Fringe Benefits to $11,022 Drug Testing and $1,000 Incentives to reflect
Amendment #1 within fifteen percent of the FY 2017 Michigan Drug Court Grant Program (MDCGP) grant
agreement (M.R. #16289); 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 #4 in the amount of
$124,840 which is less than fifteen percent of the original agreement required to accept each of the
amendments via separate resolution; and
WHEREAS an amendment totaling $6,000 is recommended for Community Corrections to reallocate line
items to reflect Amendment #3 within fifteen percent of the FY 2017 Michigan Department of Corrections
Comprehensive Corrections Plan (MR. #16350); and
WHEREAS a budget amendment is recommended for Parks and Recreation Commission Fund (#50800)
to transfer $359,321 from the Facilities Maintenance cost center to various cost centers incurring expenses
during the third quarter of FY 2017, transfer $46,000 from Operating Maintenance Funds for window
replacement at Independence Oaks, appropriate $19,655 for paving repair at Glen Oaks Golf Course and
Conference Center and transfer of $7,414 from Capital Equipment for the purchase of a mobile trailer for
recreation program services; and
WHEREAS a budget amendment is recommended for the Water Resources Commissioner Drain
Equipment Fund (#63900) totaling $265,828 for FY 2017 and $67,898 for FY 2018 — FY 2019 for the
transfer of seven (7) Pontiac system owned vehicles to be Drain Equipment leased vehicles; and
WHEREAS a budget amendment is recommended for Water Resources Commissioner in the amount of
$684,693 to correct the budget from Planned Use of Balance line item to Budgeted Equity Adjustment line
item; and
WHEREAS a budget amendment is recommended for Information Technology Fund (#63600) in the
amount of $1,175,000 to reappropriate funds for various IT projects such as, Medical Examiner's, Ehealth,
IT Print Management Services, Cyber Security and Collaborative Asset Management System (CAMS),
funding is available in the IT Fund Net Assets-Designated for Projects equity account; and
WHEREAS a budget amendment in the amount of $860,000 is recommended for CLEMIS Fund (#53500)
to reallocate funds for various CLEMIS projects such as OakVideo Upgrade, CAD Upgrade, San Project,
Crash software, Mugshot Upgrade; funding is available in the CLEMIS Fund Equity-Designated for
Projects equity account; and
WHEREAS the Oakland County Department of Economic Development and Community Affairs has
attempted to collect funds from loan recipients for the Community Development Block Grant and
recommends $265,303.17 be written off in uncollectible loans; and
WHEREAS the Oakland County International Airport has requested a reversal of late fees totaling
$539.40; and
WHEREAS the Parks and Recreation Commission has requested a write-off in the amount of $157 for
uncollectible fees; and
WHEREAS the Department of Information Technology has requested a write-off in the amount of $110.50
for uncollectible fees; and
WHEREAS Department of Health and Human Services, Children's Village division received donations for
the period of April 2017 through June 2017 totaling $7,070 of which $72 was a cash donation; and
WHEREAS Department of Public Services, Animal Shelter and Pet Adoption Center received donations for
the period of April 2017 through June 2017 totaling $13,216.06; and
WHEREAS Department of Public Services, Michigan State University (MSU) Extension division received
donations for the period of January 2017 through June 2017 totaling $1,254; and
WHEREAS Parks and Recreation Commission received donations for the period of April 2017 through
June 2017 totaling $7,628.
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2017
Third Quarter Financial Report.
BE IT FURTHER RESOLVED that the uncollectible debts, as recommended by the Department of
Management and Budget and detailed in the attached schedules are authorized to be written off.
BE IT FURTHER RESOLVED that the donations be recognized in the Children's Village division, Animal
Control and Pet Adoption Center, MSU Extension division 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 adgption of the foregoing resolution.
COmmissioner Thomas Middleton, District #4
Chairperson, Finance Committee
COAKLAND*
COUNTY MICHIGAN
MANAGEMENT & 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 Third Quarter Forecast
DATE: September 14, 2017
FY 2017 THIRD QUARTER REPORT
Attached please find the Fiscal Year (FY) 2017 Third Quarter Forecast Report. In total, Fiscal Services
forecasts that the County will complete FY 2017 with an overall favorable variance of $26,461,586 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 $9,620,735 more revenue than anticipated and projected
favorability in expenditures of $16,930,860.
REVENUES
GF/GP revenues are 2.14% more than budget or $9,620,736. Major variances are the result of the
following events:
A. TAXES — Unfavorable ($170,500)
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 $169,500 in the Treasurer's Office to reflect actual revenue activity for
payments from the State on Department of Natural Resources (DNR) land.
B. FEDERAL GRANTS — Favorable $111,633
Favorable primarily due to the Prosecuting Attorney's Title IV-E contract with Michigan
Department of Health and Human Services (MDHHS) for legal consultation $86,633 and
favorable Children's Village Refunds School Meals program $25,000.
C. STATE GRANTS — Unfavorable: ($1,103,876)
Reduced state funding is primarily the result of reduced Child Care fund costs ($1,131,000).
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.
This is partially offset by favorable Water Resources Commissioner Stormwater, Asset
Management and Wastewater (SAW) Grant reimbursement $27,125.
D. CHARGES FOR SERVICES — Favorable: $10,600,625
Favorable primarily in the Treasurer's Office $5.6 million Payments Other than Anticipated due
to the sale of foreclosed property, $170,000 Administration Fees and $109,000 for Tax Reverted
Land County Portion; County Clerk's Office $1.6 million due to increased activity for Land
2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 I Fax (248) 452-9172 I OakGov.com
Transfer Tax, $1.5 million for Recording Fees and $290,000 for Deeds; Children's Village Board
and Care $650,000, Out County Board and Care $250,000 due to an increase in reimbursement
rate from the State, and Non-Departmental Commission Public Telephone of $600,000 for
revenue greater than anticipated.
EXPENDITURES
In total, expenditures are projected to be 3.80% under budget or $16,930,850 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); Sheriffs Office, Water Resources Commissioner and Facilities Management.
Sheriff — Unfavorable: ($690,000)
• The department is forecasted to be unfavorable due to increased use of overtime and related
fringe benefits; primarily in the Corrective Services - Satellites 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: ($360,300)
• The department is forecasted to be unfavorable primarily due to Drain Equipment Labor
expenditures ($371,700) for employee labor that cannot be charged to other funds. The overall
unfavorability is offset by favorable revenues of $406,300 for Reimbursement General and
$100,000 in Soil Erosion Fees. A budget amendment will be made by year end if the trend
continues.
Facilities Management — Unfavorable: ($9,050)
• 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, Ml 48328 I Fax (248) 452-9172 I OakGov.com
Forecast Presentation — Budgetary Perspective
The presentation reflects the true fiscal activity of the County for FY 2017:
Revenues - over/ (under) budget
Expenditures — (over)/under budget
Total Officially Reported Favorability
$ 9,520,735
16,930,850
$ 26,451,585
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 $32,360,834 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
Expenditure Variance (Comparing Actual to Approved Plan)
GAAP Reported Effect on Fund Balance
$ 9,520,735
(32,360,834)
$ (22,840,099)
16,930,850
$ (5,909,249)
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 $26.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 $5.9 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 $32.4 million of Fund Balance, this forecast projects the use of Fund Balance
needed to support FY 2017 activities of $5.9 million, $26.5 million less than planned.
2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 I Fax (248) 452-9172 1 OakGov.com
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (010100) aptProqram Acct Fund Aft Op Unit Account Name FY 2017 FY 2018 FY 2019 FY 2020 AMENDMENTS AMENDMENTS AMENDMENTS AMENDMENTS SHERIFF'S OFFICE Revenues 4030901 116240 4030101 116270 4030301 112580 9010101 196030 695500 21340 Transfers In - LE Enhance Lab Fees 695500 21341 Transfers In - LE Enhance Sheriff 695500 21397 Transfers In - Sheriff Training 665882 Planned Use of Balance Total Revenues $ 38,430.00 7,444.00 3,111.00 (37,474.00) $ 11,511.00 Expenditures 4030901 116240 750203 4030301 112620 731304 Revenues 9010101 496030 665882 4030201 112680 630875 Expenditures 4030501 110110 722900 4030701 116230 722900 Forensic Lab Enhancement Officers Training Total Expenditures Planned Use of Balance Gun Registrations Total Revenues Fringe Benefit Adjustments Fringe Benefit Adjustments Total Expenditures 8,400.00 3,111.00 $ 11,511.00 $ 200,000.00 $ (200,000.00) - $ $ (175,000.00) 175,000.00 40,000.00 $ 40,000.00 $ 40,000.00 (40,000.00) (40,000.00) (40,000.00) $ - $ Expenditures 4030101 112580 731885 Supportive Services $ (1,044.00) 4030301 112580 788001 21393 Transfer Out - Sheriff OWI Crime Victims Fund 1,044.00 Total Expenditures
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2017 FY 2018 FY 2019 FY 2020 AMENDMENTS AMENDMENTS AMENDMENTS AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND {#10100) Dept Program Acct Fund Aff. Op Unit Account Name HEALTH DIVISION Revenues 1050233 133371 631799 9010101 133371 665882 Reim b Contracts Planned Use of Balance Total Revenues 6,000.00 (6,000.00) PUBLIC SERVICES - ANIMAL CONTROL DIVISION Revenue 1070801 114000 695500 21310 Transfers In - Legacy Fund $ 35,500.00 Total Revenues $ 35,500.00 Expenditure 1070805 114090 750014 Animal Supplies $ 15,000.00 1070801 114000 750301 Medical Supplies 15,000.00 1070801 114000 750392 Metered Postage 5,500.00 Total Expenditures $ 35,500.00 CHILD CARE FUND (#20293) Revenues 1060501 112255 695500 21330 Transfer In - Children's Village Donations Fund Total Revenues 142.00 142.00 Expenditures 1060501 112255 750245 Incentives Total Expenditures 142.00 142.00
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2017 FY 2018 AMENDMENTS AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name SHERIFF'S OFFICE - LAW ENFORCEMENT ENHANCE LAB FEES (#21340) Revenue 4030901 116240 665882 Planned Use of Balance Total Revenue Expenditures 4030101 112580 788001 10100 Transfer Out Sheriff General Fund Total Expenditures SHERIFF'S OFFICE- LAW ENFORCEMENT ENHANCE SHERIFF (#21341) Revenue 4030101 116270 665882 Planned Use of Balance Total Revenue 38,430.00 38,430.00 38,430.00 38,430.00 7,444.00 7,444.00 Expenditures 4030101 116270 788001 10100 Transfer Out - Sheriff General Fund Total Expenditures 7,444.00 7,444.00 SHERIFF'S OFFICE - TRAINING (#21397) Revenue 4030301 112580 665882 Planned Use of Balance 3,111.00 Total Revenue 3,111.00 Expenditures 4030301 112580 788001 10100 Transfer Out - Sheriff General Fund Total Expenditures SHERIFF'S OFFICE - PA OW] CRIME VICTIMS FUND (#213931 Revenue 4030301 112580 633442 Restr PA OWI Forfeiture 4030301 112580 695500 10100 Transfers In - Sheriff General Fund Total Revenue 3,111.00 3,111.00 (1,044.00) 1,044.00
6,000.00 6,000.00 Federal Operating Grants Total Revenues 3010404 126030 610313 Expenditures 3010404 126030 731458 Professional Services 6,000.00 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY/SPECIAL REVENUE FUNDS FY 2017 FY 2018 AMENDMENTS AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name PUBLIC SERVICES -ANIMAL CONTROL LEGACY FUND (#21310) Revenue 9010101 114110 665882 21310 Planned Use of Balance 35,500.00 Total Revenue 35,500.00 Expenditures 90101131 114110 788001 21310 Transfer Out - Animal Control Gen. Fund 35,500.00 Total Expenditures 35,500.00 CHILDREN'S VILLAGE DONATIONS FUND (#21330) Revenues 9010101 112255 665882 Planned Use of Balance Totaf Revenues 142.00 142.00 Expenditures 9010101 112255 788001 20293 Transfer Out - Child Care Fund TotaI Expenditures 142.00 142.00 CIRCUIT COURT - DRUG COURT CIRCUIT JUVENILE SCAO (#27140) GR0000000236 Bud Ref: 2017 Activity: GLB Analysis: GLB Expenditures 3010402 121200 702010 3010402 121200 722740 Salaries Regular Fringe Benefits Total Expenditures 1,310.00 (1,310.00) FRIEND OF THE COURT - ACCESS VISITATION (#27120) GR0000000282 Bud Ref: 2017 Activity: GLB Analysis: GLB Revenues Total Expenditures 6,000.00
Revenues 1060290 115035 610313 1060290 115010 610313 Expenditures 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 115035 115035 115035 115035 115035 115035 115035 115035 115010 115010 115010 115010 115010 115010 702010 722740 730926 770631 774636 774637 774677 778675 702010 722740 730926 731346 750077 750399 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY /SPECIAL REVENUE FUNDS FY 2017 FY 2018 AMENDMENTS AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name TROY DISTRICT COURT - DRUG COURT DISTRICT 52-4 SCAO (#27167) GROOM:MONO Bud Ref: 2017 Activity: GLB Analysis: GLB Expenditures 3020505 121050 722740 Fringe Benefits (12,022.00) 3020505 121050 730548 Drug Testing 11,022.00 3020505 121050 750245 Incentives 1,000.00 Total Expenditures HEALTH - NURSE FAMILY PARTNERSHIP (#28607) GR0000000796 Bud Ref: 2017 Activity: GLB Analysis: GLB Federal Operating Grants Federal Operating Grants Total Revenues Salaries Regular Fringe Benefits Indirect Costs Bldg Space Cost Allocation Info Tech Operations Info Tech Managed Print Svcs Insurance Fund Telephone Communications Salaries Regular Fringe Benefits Indirect Costs Personal Mileage Disaster Supplies Office Supplies 50,710.00 74,130.00 124,840.00 24,118.00 18,517.00 2,873.00 1,821.00 2,382.00 372.00 45.00 582.00 37,334.00 28,666.00 4,446.00 297.00 1,125.00 300.00
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2017 FY 2018 AMENDMENTS AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PARKS AND RECREATION COMMISSION (#501300) Revenue 5060666 160666 665882 5060666 160666 665882 5060666 160666 665882 1070401 1070401 1070401 1070401 1070401 1070401 1070401 Expenses 5060327 5060427 5060725 5060805 5060725 5060805 5060715 5060715 5060327 123010 113130 113130 113000 113000 113000 113130 160010 160010 160070 160210 160070 160210 160070 160070 160010 722740 702010 722740 731941 731213 732018 730373 730814 730814 750476 730814 750511 750511 730198 730814 730198 Fringe Benefits Salaries Fringe Benefits Training Membership Dues Travel and Conference Contracted Services Total Expenditures Planned Use of Balance Planned Use of Balance Planned Use of Balance Total Revenues Grounds Maintenance Grounds Maintenance Recreation Supplies Grounds Maintenance Special Event Supplies Special Event Supplies Building Maintenance Charges Grounds Maintenance Building Maintenance Charges 300,00 465.00 45.00 1,152.00 124,840,00 (700,00) (3,180.00) (2,120.00) 700.00 700.00 1,700.00 2,900.00 19,655.00 (46,000.00) 7,414.00 (18,931.00) 9,828.00 9,827.00 (1,025.00) (300.00) 1,025.00 300.00 13,305.00 1,125.00 1,020.00 PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff °per Unit Account Name 1060290 115010 750448 Postage-Standard Mailing 1060290 115010 774637 Info Tech Managed Print SVCS 1060290 115010 774677 Insurance Fund 1060290 115010 778675 Telephone Communications Total Expenditures COMMUNITY CORRECTIONS (#27370) GR0000000772 Bud Ref: 2017 Activity: GLB Analysis: GLB Expenditures
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY I SPECIAL REVENUE FUNDS FY 2017 FY 2018 AMENDMENTS AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060420 160044 730198 Building Maintenance Charges 2,716.00 5060720 160070 730814 Grounds Maintenance 10,395.00 5060720 160070 730814 Grounds Maintenance 30,035.00 5060765 160070 730814 Grounds Maintenance 8,780.00 5060725 160070 730814 Grounds Maintenance 8,423.00 5060724 160070 730814 Grounds Maintenance 9,156.00 5060328 160010 730814 Grounds Maintenance 5,742.00 5060751 160070 730814 Grounds Maintenance 34,318.00 5060760 160070 730814 Grounds Maintenance 7,830.00 5060831 160210 730814 Grounds Maintenance 223,391.00 5060732 160070 730814 Grounds Maintenance 780.00 5060330 160010 730814 Grounds Maintenance 640.00 5060326 160010 730814 Grounds Maintenance 687.00 5060736 160070 730814 Grounds Maintenance 978.00 5060910 160430 730789 General Program Administration (359,321.00) 5060910 160430 730789 General Program Administration (46,000.00) 5060805 160210 750154 Expendable Equipment 7,414.00 Total Expenses (18,931.00) DRAIN EQUIPMENT FUND {#63900) Revenue 6010101 149760 632401 Vehicle Rental 100,915.00 5 67,898.00 $ 67,898.00 $ 67,899.00 Total Revenue 100,915.00 5 67,898.00 $ 67,898.00 $ 67,899.00 Expenses 6010101 6010101 6010101 149760 776659 Motor Pool Fuel Charges 149760 776661 Motor Pool Leased Equipment 149760 788001 66100 Transfer Out - Motor Pool Fund Total Expenses 7,500.00 $ 43,424.00 $ 49,991.00 $ 100,915.00 $ 10,000.00 $ 57,898.00 $ - $ 67,898.00 $ 10,000.00 $ 57,898.00 $ - $ 67,898.00 $ 10,000.00 57,898.00 67,898.00 WATER AND SEWER TRUST FUND (#57010) Revenue 6010101 149030 632086 6010101 149030 665882 Sewage Disposal Services Planned Use of Balance Total Revenue 39,873.00 $ 53,163.00 $ 53,163.00 $ 53,163.00 164,913.00 -5 204,786.00 5 53,163.00 5 53,163.00 $ 53,163.00
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2017 FY 2018 AMENDMENTS AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Expenses 6010101 149030 771639 Drain Equipment 6010101 149030 788001 66100 Transfer Out - Motor Pool Total Expenses PON11AC WASTEWATER TRUST FUND CHAPTER 20 (#82534) Revenue 6010101 155020 505572 Special Assessment 6010101 155020 565882 Planned Use of Balance Total Revenue 39,873.00 5 53,163.00 5 53,163.00 5 164,913.00 204,786.00 5 53,163.00 5 53,163.00 5 53,163,00 53,163.00 11,051.00 14,735.00 $ 14,735.00 5 14,735.00 49,991.00 5 61,042.00 5 14,735.00 5 14,735.00 $ 14,735.00 Expenditures 6010101 155010 771639 Drain Equipment 61,042.00 5 14,735.00 5 14,735.00 $ 14,736.00 Total Expenditures 61,042.00 $ 14,735.00 $ 14,735.00 5 14,736.00 MOTOR POOL FUND (#66100) Revenue 1030811 184010 631071 1030811 184010 630833 1030811 184010 695500 1030811 184010 695500 Leased Equipment Gasoline Oil Grease Charges 63900 Transfer In - Drain Equipment Fund 57010 Transfer In - Water and Sewer Trust Fund Total Revenue 43,424.00 5 57,898.00 $ 7,500.00 10,000.00 49,991.00 164,913.00 57,898.00 $ 10,000.00 57,898.00 10,000.00 265,828.00 $ 67,898.00 5 67,898.00 $ 67,898.00 DRAIN EQUIPMENT FUND 0063900) Revenue 6010101 149760 665882 Depreciation Vehicles Gasoline Charges Budgeted Equity Adjustment Total Expenses Planned Use of Balance Total Revenue 32,236.00 $ 7,500.00 225,092.00 255,828.00 $ 684,693.00 684,693.00 42,980.00 $ 10,000.00 14,918.00 67,898.00 5 42,980.00 $ 10,000.00 14,918.00 67,898.00 $ 42,980.00 10,000.00 14,918.00 67,898.00 elpise 1030811 184010 761156 1030811 184010 750210 1030811 184010 796500 Expense 6010101 149760 796500 Budgeted Equity Adjustment 5 684,693.00 Total Expense 5 684,693.00
SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2017 FY 2018 AMENDMENTS AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name INFORMATION TECHNOLOGY FUND (#63600) Revenue 1080101 152000 665882 Expense 1080601 152010 731458 CLEMIS FUND (#53500) Revenue 1080301 116020 665882 Expenses 1080305 116020 731458 Planned Use of Balance Total Revenue Professional Services Total Expenses Planned Use of Balance Total Revenue Professional Services Total Expenses $ 1,175,000.00 $ 1,175,000.00 $ 1,175,000.00 $ 1,175,000.00 860,000.00 860,000.00 $ 860,000.00 $ 860,000.00
COUNTY OF OAKLAND
FY 2017 THIRD QUARTER REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
REVENUES
GENERAL FUND
Taxes
Federal Grants
State Grants
Other intergovernmental Revenue
Charges for Services
Indirect Cost Recovery
Investment Income
Other Revenues
FY 2017
ADOPTED
B UDGET
$ 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
BUDGET
AS
AMENDED
$ 216,275,088.00
708,785.00
20,181,679,00
44,208,244.00
108,966,875,00
8,046,170.00
1,904,900.00
13,171,388.00
FY 2017
FORECAST
$ 216,104,588.00
820,418.00
19,077,804,00
44,190,244.00
119,567,500,00
8,046,170.00
1,930,600,00
13,246,540.00
AMOUNT
FAVORABLE/
(UNFAVORABLE) PERCENT
$ (170,500.00) -0.08%
111,633.00 15.75%
(1,103,875.00) -5.47%
(18,000.00) -0.04%
10,600,625.00 9,73%
0.00%
25,700,00 1.35%
75,152.00 0.57%
SUB-TOTAL GENERAL FUND/GENERAL PURPOSE $ 411,531,577.00 $ 413,463,129.00 $ 422,983,864.00 $ 9,520,735.00 2.30%
PLANNED USE OF FUND BALANCE $ 32,532,802.00 $ 32,360,834.15 $ 32,360,834.15 $ 0.00%
TOTAL OF/OP FUNDS $ 444,064,379.00 $ 445,823,963.15 $ 455,344,696.15 $ 9,520,735.00 2.14%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
52nd District Court
Probate Court
TOTAL ADMIN. OF JUSTICE
LAW ENFORCEMENT
Prosecuting Attorney
Sheriff
TOTAL LAW ENFORCEMENT
GENERAL GOVERNMENT
Cleric/Register of Deeds
Treasurer
Board of Commissioners
Library Board
Water Resources Commissioner
$ 52,615,792.00 8 53,550,206.87 46,174,106.87 $ 7,376,100.00 13.77%
17,094,806.00 16,958,520.00 16,433,620.00 525,000.00 3.10%
6,381,257.00 6,328,991.00 6,103,991.00 225,000.00 3,56%
$ 76,091,855.00 8 76,837,817.87 $ 68,711,717.87 $ 8,126,100.00 10.58%
20,021,946.00
146,495,179.00
$ 166,617,125.00
19,777,811.00 18,968,011,00 809,800,00
146,585,150.00 147,275,150.00 (690,000.00)
$ 166,362,961.00 $ 166,243,161.00 $ 119,800.00
-0.47%
4.09%
0.07%
10,613,623.00
8,784,820.00
2,896,745.00
1,343,140.00
5,688,932.00
11,069,795.00
9,048,096.00
3,032,404.00
1,342,819.87
5,939,975.00
9,600,895.00
8,376,896,00
2,912,404.00
1,342,819,87
6,300,275.00
1,468,900.00
671,200,00
120,000.00
-
(360,300.00)
13.27%
7,42%
3.96%
0.00%
-6.07%
TOTAL GENERAL GOVERNMENT 6..24% $ 29,327,260.00 $ 30,433,089.87 $ 28,533,289.87 $ 1,899,800,00
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
19,823,114,00
2,594,626.00
1,282,266,00
4,402,468.00
65,294,635,00
17,504,029.00
8,141,811,00
$ 7,600,630.00
20,146,232.34
2,628,817.00
1,260,592,00
4,715,155.00
65,354,590.07
17,533,569.00
8,337,723.00
$ 7,494,630.00
18,647,232.34
2,554,617.00
1,269,642.00
4,267,555.00
62,275,090.07
16,823,469,00
7,694,923.00
106,000.00
1,499,000.00
74,200.00
(9,050.00)
447,600.00
3,079,500 00
710,100.00
642 800 00
1.39%
7.44%
2.82%
-0.72%
9.49%
4.71%
4.05%
7.71%
TOTAL COUNTY EXECUTIVE 126,635,141.00 $ 127,577,308.41 $ 121,027,168.41 $ 6,550,160.00 5,13%
TOTAL DEPARTMENTS $ 398,571,381.00 $ 401,211,177.15 $ 384,515,327.15 $ 16,695,850.00 4.16%
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTAL 45,492,998.00 $ 44,612,786.00 $ 44,377,786.00 235,000.00 0,53%
TOTAL GOVERNMENTAL EXPENDITURES 444,064,379.00 $ 445,823,963.15 $ 428,893,113.15 $ 16,930,850.00 3.80%
General Fund/General Purpose
Favorable/(Unfavorable) - Budget Perspective 26,451,585.00 $ 26,451,585.00
GARP Required Adjustment (eliminating use of fund balance "revenue") $ (32,360,834.15) $ (32,360,834.15)
GAAP - BASED REPORT (forecasted impact on Fund Balance) ($5,909,249.15) ($5,909,249.15)
Other Taxes - Trailer Tax 80,000.00 80,000.00 80,000,00 0.00% Total Taxes $ 216,275,088.00 $ 216,275,088.00 $ 216,104,588.00 $ (170,500.00) -0.08% FEDERAL GRANTS (610000-610999) Sheriff - Patrol Sheriff Sheriff - Investigative/Forensic Services Prosecuting Attorney - $ 27.220.00 205,000.00 - 8 - $ 27.220.00 27,220.00 205,000.00 291,633.00 86,633.00 Homeland Security - Disaster Control Health Division Children's Village Total Federal Grants STATE GRANTS (615000-615999) Sheriff - Patrol State Match Foster Care Prosecuting Attorney Economic Development Health Division Water Resources Commissioner 60,800.00 109,665.00 300,000.00 - $ 1,000.00 4,709,523.00 40,000.00 78,167.00 98,398.00 300,000.00 - $ 1,000.00 4,730,006.00 40,000.00 78,167.00 98,398.00 325.000.00 25,000.00 - $ 1,000.00 4,730,006.00 67,125.00 27,125.00 $ 702,685.00 $ 708,785.00 $ 820,418.00 $ 111,633.00 Public Services - Veteran's Services 20.000.00 20,000.00 Non-Departmental - Child Care Subsidy 15,578,080,00 15,390,673.00 14,259,673.00 (1,131,000.00) COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2017 THIRD QUARTER REPORT ADOPTED BUDGET AMENDED BUDGET FY 2017 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES TAXES (601000-601999) Property Taxes - July Tax Levy $ 215,796,588.00 8 215,796,588.00 $ 215,456,588.00 8 (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 469,500,00 169,500.00 56.80% Fay. due to tax payments from the state on DNR land. 0.00% 0.00% 0.00% 42.26% Fay, due to Contract with Michigan Department of Health and Human Services Title IV-E. 0.00% 0.00% 5.33% Fav. Refunds School Meals (lunch program) primarily due to fluctuations in population at Children's Village as well as lower food costs. 15.75% 0.00% 0.00% 0.00% 0.00% 0.00% 67.81% Fav Stormwater Asset Management and Wastewater (SAW) grant $27,125 due to revenue reimbursement being more than anticipated budget projection, 0.00% -7.35% Built into the Circuit Court Family Division, Human Services Administration and Children's Village budgets are Child Care Fund expenditures. A favorable variance within these expense areas reduces the 50% reimbursement the county receives. Unfav revenue variance is offset by Child Care Fund expenditure favorability. Total State Grants $ 20,328,603.00 $ 20,181,679.00 $ 19,077,804.00 $ (1,103,875.00) -5.47% OTHER INTER-GOVERNMENTAL REVENUES (620000 -626999) Non-Departmental $ 41,988,159.00 $ 41,988,159.00 $ 41,988,159.00 $ HHS - Homeland Security 18,000.00 18,000.00 Circuit Court 4,500.00 4,500.00 4,500.00 District Court 1,800.00 1,800.00 1,800.00 (18,000.00) 0.00% -100.00% Unfav. Local Match due to the installation of fewer than anticipated sirens. 0.00% 0.00%
1,800,000.00 4,099,200.00 1,730,200.00 1,755,000.00 3,899,200.00 1,855,200.00 1,800,000.00 4,099,200.00 1,730,200.00 (35,000.00) (200.000.00) 125,000.00 325,000.00 3,588,900.00 3,913,900.00 3,588,900.00 75,000.00 2,324,781.00 2,249,781.00 2,249,781.00 507,600.00 40,000.00 547,600.00 507,600,00 $ 16,411,681.00 $ 16,411,651.00 $ 16,839,681.00 $ 428,000.00 -1.94% Unfav, Refund Fees PD Def Attorney ($20,000) due to an unanticipated reduction in revenue along with Govt Benefit Board and Care ($15,000). -4.88% Unfav, Probation Fees ($175,000) along with Ordinance Fines and Costs ($25,000) due to a reduction in caseload. 7.22% Fay. State Law Costs $100,000 along with Ordinance Fines and Costs $25,000 due to an increase in Criminal/Traffic caseload and continued collection efforts. 9.06% Fav. Ordinance Fines and Costs $400,000 based on continued collection efforts. Partially offset by unfav. Probation Fees ($75,000) due to probationer's inability to pay monthly Probationary Oversight Expense. 3.33% Fay. Ordinance Fines and Costs $50,000 along with Refund Fees PD Def Attorney $25,000 based on continued collection efforts, 7.88% Fay. Gross Estate Fees $50,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. 2.61% Circuit Court - Family Division District Court - Division I (Novi) District Court - Division II (Clarkston) District Court - Division III (Rochester Hills) District Court - Division IV (Troy) Probate Court - Estates and Mental Health Total Administration of Justice COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2017 THIRD QUARTER REPORT Sheriff Non-Departmental - Reim b Judges Salaries Total Other Intergovernmental Revenue ADOPTED BUDGET 263,675.00 1,929,420.00 $ 44,205,554.00 AMENDED BUDGET 266,365.00 1,929,420.00 $ 44,208,244.00 AMOUNT FY 2017 FAVORABLE FORECAST (UNFAVORABLE) 266,365.00 1,929,420.00 $ 44,190,244.00 5 (18,000.00) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 0.00% 0.00% -0.04% CHARGES FOR SERVICES (630000-635999) Administration of Justice Circuit Court - Judicial/Administration Circuit Court - Civil/Criminal - $ 2,436,000.00 - $ - $ 2,436,000.00 2,534,000,00 0.00% 98,000,00 4.02% Fay. Court Costs $100,000 due to more than anticipated revenue. Fay. E Filing Fees $48,000 due to unanticipated E-Filing revenue. Partially offset by unfav. Civil Mediation Payments ($50,000) due to reduction in caseload. Law Enforcement Prosecuting Attorney 294,800.00 $ 290,000.00 407,000.00 $ 117,000.00 40.34% Fay. Reim b. General $77,000 due to Juvenile Resentendng reimbursement from the state and Restored PA Seized Funds $21,000 from forfeiture. Also fav. State Approp Victim Witness $26,000, Educational Training $3,500 and Microfilming $1,500 due to increased activity. Partially offset by unfav. Welfare Fraud Case Review ($12,000) due to the State performing the review in-house. Sheriffs Office 1,900.00 1,900,00 5,100.00 3,200.00 168.42% Fay. Reimbursement General $2,000 due to auction of abandoned vehicles. Also fay. DNA Testing Fees $1,200 due to more requests.
565,278.00 544,450.00 565,278.00 894,450.00 (350.000.00) 1,586,950.00 1,811,950.00 1,015,000.00 1,285,000.00 1,535,000.00 1,015,000.00 49,601,134.00 48,601,134.00 $ 56,349,123.00 $ 57,542,378,00 $ 56,797,578.00 $ (744,800.00) Sheriff - Corrective Services Satellites 0.00% Sheriff - Emergency Preparedness Training and Communications Sheriff - Patrol Services Sheriff - Emergency Communications Operations Sheriff - Investigative Forensic Services Total Law Enforcement -39.13% Unfav. Dispatch Services ($200,000) offset in Emergency Communications Operations division, Also unfav. Civil Action Service Fees ($150,000) due to the decline in number of foreclosures and civil service requests (see corresponding favorability in Fees Civil Service expenditures). -2.02% Unfav. Sheriff Special Deputies ($500,000) and Reimb. Salaries ($500,000) based on billable activity for law enforcement services 14.18% Fav. Dispatch Services $225,090 partially offset in Emergency Preparedness Training and Communications division. 26.60% Fay. Drug Testing $200,000 collected from Results Program and probation clients. Also fay. Reimb Salaries $70,000 from unbudgeted billable activity. -1.29% 565,278.00 894,450.00 48,455,029.00 (1,000,000.00) 225,000.00 270,000.00 COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2017 THIRD QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES -25.44% Unfav. Gun Registrations ($200,000) as income is directed to County Clerk per Public Act #3 of 2015. A budget amendment is recommended. Partially offset by Fay. Fingerprints $90,000 due to requirement that new teachers be fingerprinted. 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 reimbursements from State Criminal Alien Assistance Program, Fee Income ($20,000) and Clinic Charges ($20,000) from inmates inability to reimburse for clinic services. Sheriff Administrative Services 432,400.00 432,400.00 322,400.00 (110,000.00) Sheriff- Corrective Services 3,155,266.00 3,155,266.00 3,255,266.00 100,000.00 General Government Clerk County Clerk $ 2,215,600.00 $ 2,215,600.00 $ 2,311,000.00 $ 95,400,00 4,31% Fay. Photostats $100,000 due to increased activity. Also favorable E-Filing Fees $37.400 due to extension of pilot project; awaiting legislation approval of new statewide E-filing system. Forfeiture of Surety Bonds $27,000, CVR County Portion $17.000, due to increased activity. Partially offset by unfavorable Civil Action Entry Fees ($60,000), Bond Fees ($8,400), Garnishment Fees ($4.500), Motion Fees ($4,200), Costs ($2,400), Miscellaneous ($2,100) due to less than anticipated activity.
COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2017 THIRD QUARTER REPORT AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 58,400.00 36.07% Fay, due to Election Filing Fees Late $43,000 due to Corporation Counsel efforts to collect on late filers Passport Fees $16,600, and Photographs $2,000 due to increased activity. Partially offset by unfavorable Voter Registration Application ($3,800) due to less than anticipated activity. 2,317,900.00 20.50% Fay. Revenue 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: an increase in Recording Fees $1,500,000 and decrease in Mortgages ($1,000,000) due to legislation change. The Land Transfer Tax is favorable $1,550,100 and Deeds $290,000 due to increased activity. Partially offset by unfavorable Reimb. General ($15,000), and Remonumentation Fee ($4,000) due to less than anticipated use. ADOPTED AMENDED FY 2017 BUDGET BUDGET FORECAST Clerk - Elections 82,900,00 161,900.00 220,300.00 Clerk - Register of Deeds & Micrographics 11,304,500.00 11,304,500.00 13,622,400.00 Treasurer 5,032,300,00 5,032,300.00 11,345,600.00 6,313,300.00 125.46% Fay. Primarily due to Payment Other Than Anticipated 65,955,000 due to the sale of foreclosed properties. Also favorable Administration Fees $170,000, Tax Reverted Land Co Portion $109,000 and Deeds $72,000. 2,500.00 20.00% Fay, due to prescription program royalty fee income, 2,000.00 14.29% Fay, Reimb, Salaries $3,000 due to State aid to public libraries offset by unfavorable Copier Machine Charges ($1,000) due to increased functionalities of downloading and eiimailing documents. 506,300.00 25.91% Fay - Reimbursement General $406,300 a result of Drain Administration able to charge more time than anticipated to special revenue and proprietary funds. Fav - Soil Erosion Fees $100,000 increase in building activity/permits due to improvement in the housing market. Partially offset by Drain Equipment labor expenditures. Board of Commissioners Library Board Water Resources Commissioner 14,000.00 14,000.00 16,000.00 1,953,732.00 1,953,732.00 2,460,032.00 12,500.00 12,500.00 15,000.00 Total General Government $ 20,615,532.00 5 20,694,532.00 $ 29,990,332.00 $ 9,295,800.00 44.92% 50,000.00 21.74% Fay. Refunds Miscellaneous due to increased members in vendor incentive program. 125,600.00 3.85% Pay. Reimbursement Equalization Services due to contract billing vs budget. County Executive County Exec - Compliance Office 230,000.00 $ 230,000.00 $ 280,000.00 M&B - Equalization Division 3,260,000.00 3,260,000.00 3,385,600.00
COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2017 THIRD QUARTER REPORT 29.37% Fay. Board and Care $650,000 as well as Out County Board and Care $250,000 due to increase in Department of Health and Human Services placement 0.00% 0.00% -64.76% Unfav. Reimbursement General due to staffing changes and classes no longer being offered by Oakland County. -3.24% Unfav. Autopsies ($14,000) and Medical Services ($7,000) due to less than anticipated need. Partially offset by favorable Cremation Approval Fee $10,000 due to greater than anticipated requests. AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES M&B - Fiscal Services Division 505,600.00 505,600.00 515,600.00 10,000.00 1.98% Fay. Reimbursement Contracts $4,000, Reimbursement Filing Fees $3,000, and Tax Intercept Fee $3,000 due to collection efforts by Reimbursement staff. Central Services - Support Services 316,780.00 316,780.00 327,780.00 11,000.00 3.47% Fav. Metered Postage $18,000 due to United States Postal Service rate change and customers switching to metered mail. Offset by unfav, Standard Mail ($5,000) as a result of an increase standard mail being metered and Commission Vending Machines ($2,000) due to less than anticipated sales, Human Resources 475.00 475.00 (475.00) -1 DOM% Unfav. Miscellaneous fees no longer collectible due to a procedural change. HHS -Administration 0.00% HHS - Health Division 4281,399.00 4,281,399.00 4,226.399.00 (56.000.00) -1.31% Urfav, Laboratory Charges 3rd Party ($210,000) due to a delay in the start of program. Unfav. Clinic Charges ($90,000) due to actual clinic fee revenue vs budget. Unfav. Diff Between Chg and !nit Pay ($53,000) due to increased 3rd party billing and contractual write-offs. Partially offset by fay. Administration Fees $100,000 due to increased Medicaid billing of administration fees and Medicaid Outreach billable activities. Fav. Permits $87,500 due to increased demand for private sewage, private water, and body art permits. Fay. Inspection Fees $37,800 due to increased enforcement activity as well as increased demand for swimming pool inspections and body art establishments. Fay. Rabies Vaccine Fees $30,000 due to improved reimbursement from insurance and increased animal bite exposures. Fav. Licensed Facility Inspections $14,000, Licenses $7,000, Laboratory Charges $7,000, Flu 3rd Party $7,000, and Radon Testing $6,500 due to increased demand. HHS - Children's Village 2,865,000.00 3,064,200.00 3,964,200.00 900,000.00 HI-IS - Homeland Security Public Services - Community Corrections 190,000.00 190,000.00 190,000.00 Public Services - MSU Extension 21,000.00 21,000.00 7,400.00 (13,600.00) Public Services - Medical Examiner 339,000.00 339,000.00 328,000.00 (11,000.00)
COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2017 THIRD QUARTER REPORT Public Services -Animal Control ADOPTED BUDGET 913,200.00 AMENDED BUDGET 913,200.00 FY 2017 FORECAST 943,300,00 AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 30,100.00 3.30% Fav. Sale of License $28,600 due to higher amount of dog license sales and Fee Income $1,500 due to citation tickets. Public Services - Circuit Court Probation 0.00% Economic Dev. & Comm. Affairs -Admin 24,000,00 24,000.00 (24,000.00) -100.00% Unfav. Seminars/Conferences revenue for Business Roundtable is not expected to materialize in FY2017. Economic Day. & Comm. Affairs - PEDS Total County Executive Non-Departmental Non-Dept - Charges for Services Total Non-Departmental Total Charges for Services INDIRECT COST RECOVERY (640100) 453,318.00 455,818.00 455,818.00 $ 13,399,772.00 $ 13,601,472.00 $ 14,623,097.00 $ 1,021,625.00 116,812.00 $ 716,812.00 1,316,812.00 600,000.00 5 716,812.00 5 716,812.00 $ 1,316.812.00 $ 600,000.00 $ 107,492,920.00 $ 108,966,875,00 $ 119,567,500.00 $ 10,600,625.00 $ 8,000,000.00 $ 8,046,170.00 $ 8,046,170.00 $ 0.00% 7.51% 83.70% Favorable Commission Public Telephone revenue greater than anticipated. 83.70% 9.73% 0.00% INVESTMENT INCOME (655000-6559991 District Courts (Div. I - IV) Sheriff Corrective Services Sheriff Investigative/Technical Services Treasurer Clerk/Register of Deeds $ 2,400.00 $ 2,400.00 2,400.00 $ 0.00% 0.00% 0.00%. 100,000.00 100,000.00 100,000.00 0.00% 2,500.00 2,500,00 28,200.00 25,700.00 1028.00% Fay, due to investment base and market rate adjustment. 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,930,600.00 $ 25,700.00 1.35% OTHER REVENUES (670000-695500) Circuit Court-Donations Circuit Court-County Auction Circuit Court District Courts (Div. I - IV) Probate Court Prosecuting Attorney Sheriff Office 5,000.00 18.940.00 $ 5,000.00 18,940.00 $ 175.00 57.00 5,000.00 0.00% 0.00% 0.00% 175.00 100.00% Fay. due to Cash Overages. 0.00% 57.00 100.00% Fav. Refund Prior Years Expenditure due to credit balance on P-card. 0.00% Sheriff - Administrative Services Sheriff - Corrective Services Sheriff- Corrective Services-Satellites Sheriff - Emergency Prep and Communications 0.00% 750.00 750.00 100.00% Fay. Refund of Prior Years Expenditures-medical reimbursement due to lab tests billed in error. 0.00% 0.00%
1,300.00 1,200.00 1,300,00 1,200,00 100.00% Fay. Due to cash overages. 100.00% Fay. Due to cash overages. 0.00% 0.00% 0.00% 0.00% 600.00 600,00 6,112.00 100.00% Fay. Refund Prior Years Expenditure due to a refund payment error to vendor, 0,00% 600.00 6,112.00 8.566.00 2,800.00 48.56% Fay. due to closeout of J-Building Acoustical Panels Project. 5,766.00 COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2017 THIRD QUARTER REPORT 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 0.00% 628.00 628,00 100.00% Fay. primarily due to $549 donation from Michigan Public Health Institute for Health Education Program, 10,700.00 10,700.00 100.00% Fay. primarily due to Refund Prior Years Expenditure in order to reflect refund for vaccines. 0.00% 44,200.00 44,200.00 100.00% Fay. due to Refund Prior Years Expenditure $26,100 as a result of final cost settlement with Waterford School District for 2015/2016. Fay. Prior Years Adjustments $17,757 to adjust accounts payable for amounts previously accrued but determined to be no longer required. ADOPTED BUDGET FY 2017 FORECAST 266,00 AMENDED BUDGET 6,000.00 6,000.00 6,000.00 16,400.00 16,400.00 100.00% Fay. Refund of Prior Years Expenditures for reimbursement of Sheriffs overtime. 0.00% 0,00% (44,263,00) 44,263.00 44,263.00 -100.00% Unfav. Transfers In budgeted with M.R. #14275 not anticipated in FY 2017. Sheriff - Emergency Communications Operations Sheriff - Patrol Services Sheriff - Investigative/Forensic Svc AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 266,00 100.00% Fay. Refund of Prior Years Expenditures overpayment of salary. 0.00% Homeland Security Public Services - Medical Examiner Public Services -Animal Control-Other Revenues Public Services -Animal Control-Transfers In 21,900.00 21,900.00 100.00% Fay. Refund Prior Years Expenditure $21,600 primarily due to the recovery of costs associated with accidental damage caused to one outdoor warning system. Revenue favorability is offset in expenditure accounts (Maintenance Contract and Tornado Siren Equip).
9,000,000.00 32,532,802.00 $ 32,532,802.00 9,000,000.00 3,796,446.15 $ 28,564,388.00 $ 32,360,834.15 PLANNED USE OF FUND BALANCE (665000-665999) Encumbrances and Carry forwards Use of Prior Yrs Fund Balance Total Planned Use of Fund Balance Non-Departmental - Transfers In Total Other Revenues 9,000,000.00 $ 12,621,827.00 $ 13,171,388.00 13,246,540.00 $ 75,152.00 3,796,446.15 28,564,388.00 $ 32,360,834.15 $ 0.00% 0.57% 0.00% 0,00% 0,00% COUNTY OF OAKLAND GENERAL FUND I GENERAL PURPOSE REVENUES FY 2017 THIRD QUARTER REPORT ADOPTED BUDGET AMENDED BUDGET FY 2017 FORECAST 35.000.00 38674.00 AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 35,000.00 100.00% Fay. Prior Year Expenditures $35,000 due to refund of Software Maintenance for 2016 Collaborative Development Council Grant. (22,073.00) -36.34% Unfav. due to Medical Main Street Event which will not occur in FY2017 Economic Development & Comm Affairs - Other Economic Development - Contributions 29.240.00 60,747,00 Non Departmental - Donations 0.00% Non-Dept - Sundry 417,500.00 417,500.00 417,500.00 0.00% Sheriffs' Transfers 71,046.00 564,394.00 564,394.00 0.00% Treasurers' Transfers 3,048,178.00 3,048,178.00 3,048,178.00 0.00% TOTAL GEN. FUND / GEN. PURPOSE REVENUE $ 444,064,379.00 445,823,963.15 $ 455,344,698.15 $ 9,520,735,00 2.14%
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 5.42% - Fay. due to underlined and vacant positions. 28.00% Fay. 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 $30,000 due to lower than anticipated use. Fav. Furniture and Fixtures $30,000; Office Supplies $20,000; 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,00% - Fay. Bldg Space Cost Allocation $73,200 due to realignment of actuals charged to this division but should be charged to Family Division, offset in Family Division. Fair. Info Tech Operations $5,500 due to lower than anticipated use. Partially offset by unfav. Info Tech CLEMIS ($3,500) due to higher than anticipated use. Judicial Administration Personnel Expenditures $ 8,939,506,00 $ 8,766,169.00 $ 8,291,169.00 $ 475,000.00 Operating Expenditures 110,876.00 410,652.55 295,652.55 115,000.00 Internal Support Expenditures 401,261.00 501,221.00 426,021.00 75,200.00 Transfer Out 18,940.00 18,940.00 0.00% 665,200.00 6.86% Business Division Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 9,451,643.00 $ 9,696,982.55 $ 9,031,782.55 $ $ 1,810,631.00 $ 1,774,480.00 $ 1,624,480.00 $ 77,234.00 95,434,00 52,434.00 159,310.00 161,292,00 211,292.00 8.45% - Fay. due to underlined and vacant positions. 45.06% - Fav. Visiting Judges $30,000; Computer Supplies $7,500; and Metered Postage $5,500 due to lower than anticipated use. -31.00% - Unfav. Info Tech Operations due to the purchase of site subscriptions and maintenance. 150,000.00 43,000.00 (50,000.00) $ 2,047,175.00 $ 2,031,206.00 $ 1,888,206.00 $ 143,000.00 7.04%
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES -2.19% - Unfav. due to overfilled positions as well as an Emergency Salary position that is being charged to this division but not budgeted. 29.58% - Fay. Defense Atty Fees $700,000 and Defense Atty Fees Trials $600,000 due to increased budget allocation as a result of prior year carryforward for Juveniles to Life Without Parole (JLWOP). Fav. Juror Fees and Mileage $300,000 along with Attorney Fees Mediators $75,000 due to a decline in caseload. Fay. Defense Atty Fees Appellate $125,000 due to a decline in both caseload arid requests for appointed counsel. Partially offset by unfav, Professional Services ($35,000) due to a higher than anticipated use. 15.57% Fay. Info Tech Operations $300,000 due to lower than anticipated use. Fav. Bldg Space Cost Allocation $159,700 due to realignment of actuals charged to this division but should be charged to Family Division; offset in Family Division. Civil / Criminal Division Personnel Expenditures $ 1,862,100.00 $ 1,823,571.00 $ 1,863,571.00 $ (40,000.00) Operating Expenditures 5,191,431.00 5,966,750.00 4,201,750.00 1,765,000.00 Internal Support Expenditures 2,641,069.00 2,952,168.00 2,492,468.00 459,700.00 Transfers Out $ 9,694,600.00 5 10,742,489.00 $ 8,557,789.00 5 2,184,700.00 20.34% Family Division/Juvenile Maint. Personnel Expenditures $ 11,394,873.00 $ 11,240,048.00 5 10,765,048.00 $ 475,000.00 4.23% - Fay, due to underfilled and vacant positions. Operating Expenditures 13,115,409.00 12,922,268.32 8,847,268.32 4,075,000.00 31.53% - Fav. due to decrease in placements to State Institutions $3,500,000 and Priv Institutions Residential $500,000. Fay. Professional Services $75,000 due to lower than anticipated use. Offset by unfavorable Non-Dept Child Care Subsidy Revenue (50% Reimbursement). Internal Support Expenditures 1,665,439.00 1,670,560.00 1,837,360.00 (166,800.00) -9.98% - Unfav. Bldg Space Cost Allocation ($231,800) due to realignment of actuals between Judicial and CiviVCriminal divisions, Partially offset by fav. Info Tech Operations $65,000 due to lower than anticipated use. Transfer Out 5,246,653.00 5,246,653.00 5,246,653.00 0.00% - $ 31,422,374.00 5 31,079,529.32 5 26,696,329.32 $ 4,383,200.00 14.10%
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES — Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 24,007,110,00 $ 23,604,268.00 $ 22,544,268.00 $ 18,494,950.00 19,395,104.87 13,397,104.87 4,867,079.00 5,285,241.00 4,967,141.00 5,246,653.00 5,265,593.00 5,265,593.00 1,060,000.00 4.49% 5,998,000,00 30.93% 318,100.00 6.02% 0.00% $ 52,615,792.00 $ 53,550,206.87 $ 46,174,106.87 $ 7,376,100.00 13.77%
COUNTY OF OAKLAND FY 2017 THIRD 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 Operating Expenditures Internal Support Expenditures Transfers Out $ 211,708.00 $ 208,544.00 $ 211,044.00 $ (2,500,00) 10,300.00 10,300.00 1,766.00 1,766.00 -1.20% - Unfav. Primarily due to change in medical (Hospitalization) plan offset by favorable personnel expenditures in other District Court divisions. Fay. Visiting Judges due to lower than anticipated use. 2,800.00 7,500.00 72.82% 1,766.00 0,00% 0.00% $ 223,774.00 $ 220,610.00 $ 215,510.00 $ 5,000.00 227% Division 1 - Novi Personnel Expenditures $ 4,275,049.00 $ 4,186.523.00 $ 3,936,523.00 250.000.00 5.97% - Fay. due to turnover and underfilled positions/vacancies. Operating Expenditures 1,021,191.00 1,021,191.00 1,003,691.00 17,500.00 1.71% Fav. Software Support Maintenance $20,000 due to a reduction in caseload and equipment which affects the Judicial Information Systems (J1S) Services Fees invoiced by the State of MI. Fay. 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. Internal Support Expenditures 350,541.00 378,842.00 373,842.00 5,000.00 1.32% Fay. Info Tech Operations $10,000 due to lower than anticipated use. Partially offset by unfav. Info Tech CLEM1S ($5,000) due to higher than anticipated use. Transfers Out 0.00% $ 5,646,781.00 $ 5,586,556.00 $ 5,314,056.00 $ 272,500.00 4.88% Total Division 1 - Novi Division 2 - Clarkston Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out 45,000.00 2.14% 32,500.00 5.06% 12,500.00 5.45% 0.00% Fay. due to turnover and underfilled positions/vacancies. Fay. Defense Attorney Fees $25,000 due to restructured schedule for defense attorneys. Fay. Software Support Maintenance $7.500 due to lower than anticipated use. Fay. Info Tech Operations due to lower than anticipated use. $ 2,140,363.00 $ 2,098,390.00 $ 2,053,390.00 642,068.00 642.068.00 609,568.00 190,457.00 229,335.00 216,835.00 Total Division 2- Clarkston $ 2,972,888.00 $ 2,969,793.00 $ 2,879,793.00 $ 90,000.00 3.03%
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES n•nnn•nn,. Division 3 - Rochester Hills Personnel Expenditures $ 3,978,448.00 $ 3,899,044.00 $ 3,749,044.00 150,000.00 3.85% Fay, due to turnover and underfilled positions/vacancies. Operating Expenditures 416,733.00 416,733.00 369,233.00 47,500.00 11.40% Fay. Juror Pees and Mileage $20,000; Office Supplies $10,000; Travel and Conference $5,000; as well as Software Support Maintenance $5,000 due to continued efforts to minimize expenses and contain costs. Fay. Defense Attorney Fees $7,500 due to a decrease in requests for appointed counsel. Internal Support Expenditures 781,040.00 808,726.00 806,226.00 2,500.00 0.31% - Fay. Info Tech Operations $5,000 due to lower than anticipated use. Partially offset by unfav. Info Tech CLEMIS ($2,500) due to higher than anticipated use. Transfers Out 0.00% $ 5,176,221.00 $ 5,124,503.00 $ 4,924,503.00 $ 200,000.00 3.90% 0.00% -9.50% - Unfav. Defense Attorney Fees ($75,000) due to an increase in requests for appointed counsel. Partially offset by fay. Electrical Service $15,000 and Software Support Maintenance 610,000 due to lower than anticipated use. 2.80% - Fay. Info Tech Operations $10,000 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 576,388.00 (50,000.00) Internal Support Expenditures 240,845.00 268,137.00 260,637.00 7,500.00 $ 3,075,142.00 $ 3,057,158.00 $ 3,099,658.00 $ (42,500.00) -1.39% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 12,913,477.00 $ 12,655,134.00 $ 2,616,680.00 2,616,680.00 1,564,649.00 1,686,806.00 12,212,634.00 $ 2,561,680.00 1,659,306.00 442.500.00 55,000.00 27.500.00 3,50% 2.10% 1.63% $ 17,094,806.00 $ 16,958,620.00 $ 16,433,620.00 $ 525,000.00 3.10%
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES PROBATE COURT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Internal Support Expenditures $ 2,391,300.00 $ 2,339,144.00 $ 2,189,144.00 $ 150,000.00 6.41% Fay. due to turnover and undefined positions/vacancies. 29,481.00 29,481.00 19,481.00 10,000.00 33.92% Fay. Library Continuations $5,000 due to efforts to reduce spending and Visiting Judges $5,000 due to the Court limiting the use of visiting judges. 293,944.00 295,907.00 288,407.00 7,500.00 2.53% Fay, Info Tech Operations due to less than anticipated use. $ 2,714,725.00 $ 2,664,532.00 $ 2,497,032.00 $ 167,500.00 6.29% $ 2,261,029.00 $ 2,214,430.00 $ 2,089,430.00 $ 125,000.00 5.64% Fay. due to turnover and undefined positions/vacancies. 781,943.00 794,770.00 877,270.00 (82,500.00) -10.38% Unfav. Defense Atty Fees ($40,000) and Fees Guardian Ad Litem ($30,000) based on caseload activity. Unfav. Medical Services Guardianship/Probate ($12,500) due to continued high demand for these services. 623,560.00 655,259.00 640,259.00 15,000.00 2.29% Fay, Info Tech Operations due to less than anticipated use. $ 3,666,532.00 $ 3,664,459.00 $ 3,606,959.00 $ 57,500.00 1.57% Judicial/Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out Estates/Mental Heafth Personnel Expenditures Operating Expenditures Department Total Personnel Expenditures $ 4,652,329.00 $ 4,553,574.00 $ 4,278,574.00 $ Operating Expenditures 811,424.00 824,251,00 896,751.00 Internal Support Expenditures 917,504.00 951,166.00 928,666.00 Transfer Out 275,000.00 6.04% (72,500.00) -8.80% 22,500.00 2.37% 5 6,381,257.00 $ 6,328,991.00 $ 6,103,991.00 $ 225,000.00 3.56%
COUNTY OF OAKLAND FY 2017 THIRD 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,251,491.00 $ (30,000.00) -1.35% Unfav. due to Overtime ($35,000) partially offset by fay. Salaries $5,000. Offset in other divisions Operating Expenditures 515,213.00 515,213.00 521,213,00 Internal Support Expenditures 1,822,989.00 1.892,326.00 1,868,226,00 Transfers 67,000.00 67,000.00 (6,000.00) -1.16% Unfav. Library Continuations ($53,000), Extradition Expense ($39,000), Expert Witness Fee and Mileage ($16,000), and Membership Dues ($13,000) due to increased activity. Partially offset by fay. Computer Research Service $15,000, Witness Fees and Mileage $20,000, Printing $10,000, Travel & Conference $10,000, Office Supplies $10,000, Professional Services $10,00 Training $10,000, Expendable Equipment $5,000, Filing Fees $5,000, Security Supplies $5,000, Personal Mileage $4,000, Microfilming and Reproductions $3,000 and Transcript on Appeals $3,000 due to less than anticipated use. 24,100.00 1.27% Fav. due to Info Tech Operations $15,000, Motor Pool $10,000 and Info Tech Managed Print Services $5,000 due to actual usage; partially offset by unfav. Info Tech CLEMIS ($5,900) due to actual usage. 0.00% $ 4,602.607.00 $ 4.696,030.00 $ 4,707,930,00 $ (11,900.00) -0.25% Litigation Personnel Expenditures $ 10,184,987.00 $ 9,942,663.00 $ 9,542,663.00 $ 400,000.00 4.02% Fay. due to underfilled positions and positions assigned to this division but actually working across divisional disciplines. Operating Expenditures Internal Support Expenditures 33,296.00 33,296.00 29,296.00 4,000.00 12.01% Fay. Personal Mileage $7,000 due to less than anticipated use. Partially offset by unfav. Clothing Allowance ($2,000) and Witness Fees and Mileage ($1,000) due to increased use. 36.591,00 36,591.00 16,591,00 20,000.00 54.66% Fay. Info Tech Operations $19,000 and Telephone Communications $1,000 due to usage. Transfers Out 975,027.00 975,027.00 775,027,00 200,000.00 20,51% Fay. $200,000 due to lower Cooperative Reimbursement Prosecutor (CRP) grant match. $ 11,229,901.00 $ 10,987,577.00 $ 10,363,577.00 $ 624,000.00 5,68%
COUNTY OF OAKLAND FY 2017 THIRD 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,116,227.00 $ 130,000.00 5.79% 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 5,499.00 (2,300.00) -71.90% Unfav. Personal Mileage due to increased use. Internal Support Expenditures 3,306.00 3.306.00 3,306.00 0.00% Appellate Personnel Expenditures Operating Expenditures $ 2,303,716.00 $ 2,252,732.00 $ 2,125,032.00 $ 127,700.00 5.67% $ 1,874,849.00 $ 1,830,599.00 $ 1,765,599.00 $ 65,000.00 3.55% Fav. 685,000 due to underhIled positions and positions assigned to this division but actually working across divisional disciplines. Partially offset by unfav. ($20,000) Overtime. 8,458.00 8,458.00 3,458.00 5,000.00 59.12% Fay. Personal Mileage due to less than anticipated use. Internal Support Expenditures 2,415.00 2,415.00 2,415,00 0.00% Department Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 1,885,722.00 $ 1,841,472.00 $ 1,771.472.00 $ 70,000.00 $ 16,621,452.00 $ 16,240,980.00 $ 15.675,980.00 $ 565,000.00 560,166.00 560,166.00 559,466.00 700.00 1,865,301.00 1,934,638,00 1,890,538.00 44,100.00 975,027.00 1,042,027.00 842,027,00 200,000.00 $ 20,021,946.00 $ 19,777,811.00 $ 18,968,011.00 $ 809,800.00 3.80% 3.48% 0. 1 2% 2.28% 19.19% 4.09%
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES SHERIFFS OFFICE Sheriff`s Office Personnel Expenditures Operating Expenditures ADOPTED BUDGET $ 1,755,727.00 $ 75,736.00 AMENDED BUDGET 1,735,060.00 $ 102,342.00 FY 2017 FORECAST 1,735,060.00 $ 85,342.00 AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 0.00% 17,000.00 16.61% Fay. Office Supplies 315,000, Contracted Services $10,000 and Workshops and Meeting $7,000 due to less than anticipated use. Partially offset by unfav. Library Continuations ($7,000) and Material and Supplies ($6,000) due to increased use. Internal Support Expenditures 580,572.00 580,572.00 615,572.00 (35,000.00) -6.03% Unfav. Info Tech Ops ($37,000) and Telephone ($2,000) due to usage; Partially offset by fav. Motor Pool $2,000 and Motor Pool Fuel Charges $2,000 due to less than anticipated use; offset in other divisions. Transfers Out 0.00% ------------- $ 2,412,035.00 $ 2,417,974.00 $ 2,435,974.00 3 (18,000.00) -0.74% 0.00% 130,000.00 7.68% Fay. Printing $50,000, Uniform Cleaning $38,003, Office Supplies $29,000 and Indigent Orders $12,000 due to less than anticipated use. (2,000.00) -2.56% Unfav. Info Tech Ops ($8,500) due to less than anticipated use; Partially offset by fey. Info Tech Managed Print Svcs $5,000 due to usage; offset in other divisions. 0.00% 128,000.00 3.30% 650,000.00 2.15% Fav. Salaries and Fringe Benefits $2,880,000 partially offset by unfav. Overtime ($2,230,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. Administrative Services Personnel Expenditures $ 2,151,637.00 $ 2,111,470.00 $ 2,111,470.00 Operating Expenditures 1,692,738.00 1,692,738.00 1,562,738.00 Internal Support Expenditures 78,158.00 78,158.00 80,158,00 Transfers Out 3 3,922,533.00 $ 3.882,366.00 3 3,754,366.00 $ Corrective Services Personnel Expenditures 30,858,585.00 $ 30,235,594.00 $ 29,585,594.00 Operating Expenditures 7,871,073.00 7,862,785.00 7,662,785.00 200,000,00 2,54% Fav. Prisoner Housing Outside of County $89,000, Other Expendable Equipment $85,000, Transportation of Prisoners $20,000, Laundry and Cleaning $17,000. Drug Testing $12,000, Culinary Supplies $10,000 and Provisions $9,000 due to less than anticipated use. Partially offset by unfav. Custodial Supplies ($25,000) due to increased activity and Contracted Services (518,030) due to additional services to prepare meals during kitchen floor project Internal Support Expenditures 7,723,401.00 8,047,847.00 7,927,847.00 120,000.00 1.49% Fav. Info Tech Ops $92,000 and Radio Communications $25,000 due to usage; partially offset in other divisions. Transfers Out 0.00% $ 46,453,059.00 $ 46,146,226.00 $ 45,176,226.00 $ 970,000.00 2.10%
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES SHERIFFS OFFICE AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Corrective Services-Satellites Personnel Expenditures $ 13,240,284.00 $ 13,007,511.00 $ 14,807,511.00 $ (1,800,000.00) -13.84% Unfav. due to increased usage of Overtime ($1,267,000) at the Corrective Services Satellite facilities 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 ($580,000). Partially offset by fav. Salaries of $32,000. Hiring, training and retaining Corrections Deputies and filling-in for deputes on disability has been a major factor contributing to the high use of overtime. 226,494.00 227,745.00 174,745.00 7i1/111111 Fay. Equipment Maintenance $19,000 due to replacement of washers and dryers. Also fay. Uniforms $17,000 and Laundry and Cleaning $14,000 due to Lower than anticipated usage. 20,000.00 1.65% Fay. Motor Pool $13,000 and Motor Pool Fuel Charges $8,000 due to usage; partially offset in other divisions. 0.00% $ 14,672,199.00 5 14,447,177.00 5 16,174,177.00 5 (1,727,000.00) -11.95% Operating Expenditures Internal Support Expenditures Transfers Out 1,205,421.00 1,211.921,00 1,191,921.00 (355,000.00) -18.59% Untav. due to full-employment, overfilled positions and three emergency positions which are not budgeted in Sheriff. Emergency Salaries will be re-appropriated from Non-Departmental General Fund to Sheriff at year end if necessary. A budget amendment is recommended to reallocate Fringe Benefits to Sheriff's division Emergency Communications Operations. 200,000.00 20.38% Fay. Fees Civil Service $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). Also fay. Employees Medical Exams $40,000 doe to lower than anticipated fitness testing, (75,000.00) -99.09% Unfav. Info Tech Ops ($48,000), Telephone Communications ($15,000) and Info Tech Managed Print Svcs ($5,000) due to usage; partially offset in other divisions. Also unfav. Bldg Space Cost Allocation ($8,000) offset in Emergency Communications Operations. 0.00% (230,000.00) -7.75% 500,000.00 1.02% Fay, due to turnover and vacancies. 200,000.00 14.72% Fay. Uniforms $50,000, Gasoline Charges $45,000, Equipment Rental $40,000, Rent $26,000, Natural Gas $10,000, Office Supplies $6,000 and Deputy Supplies $5,000 due to lower than anticipated usage 32,000,00 0.62% Fav. Motor Pool Fuel Charges $255,000 due to usage. Partially offset by unfav. Motor Pool ($200,000) and Info Tech CLEMIS ($20,000) due to usage; partially offset in other divisions. Emergency Prep Training and Communications Personnel Expenditures $ 1,873,948.00 $ 1,909,436.00 $ 2,264,436.00 $ Operating Expenditures 981,585.00 981,585.00 781,585.00 Internal Support Expenditures 75,688.00 75,688.00 150,688.00 Transfers Out $ 2,931,221.00 $ 2,966,709.00 $ 3,196,709.00 $ Patrol Services Personnel Expenditures $49,550,294 $ 48.866,184.00 $ 48,366,184.00 5 Operating Expenditures 1,064,522.00 1,358,497.00 1,158.497.00 Internal Support Expenditures 5,087,459,00 5,177,148.00 5,145,148.00 Transfers Out 191,218.00 191,218.00 0.00% ---------------- ----------------- ------------------- ----------------- $ 55,702,275.00 5 55,593,047.00 5 54,861,047.00 $ 732,000.00 1.32%
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES SHERIFFS OFFICE AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Emergency Communications Operations Personnel Expenditures $ 7,675,028.00 $ 7,693,883.00 $ 8,383,883.00 5 (690,000,00) -8.97% Unfav, due to Overtime from vacant positions and turnover. A budget amendment is recommended to reallocate Fringe Benefits from Sheriffs division Emergency Prep Training and Communications. Operating Expenditures 159,715,00 160,132.00 160,132.00 0.00% Internal Support Expenditures Transfers Out 145,221.00 145,221.00 110,221.00 35,000.00 24.10% Fay. Telephone Communications 513,400, Info Tech Managed Print Services $9,000 and Info Tech Ops $4,400 due to usage; partially offset in other divisions. Also fav. Bldg Space Cost Allocation $8,000 due to actuals charged in Emergency Prep Training and Communications division. 0.00% $ 7,979,964.00 $ 7.999,236.00 5 8,654,236.00 $ (655,000.00) -8.19% Investigative/Forensic Svcs Personnel Expenditures Operating Expenditures $ 8,752,790.00 $ 8,681,997.00 $ 8,811,997.00 $ (130,000.00) 813,133.00 1,250,612.00 1,160,612.00 90,000.00 -1.50% Unfav. due to Overtime from vacant positions and turnover. 7.20% Fav. Contracted Services $80,000, Evidence Fund NET $75,000 and Equipment Rental $10,000 due to usage; partially offset by unfav. Material and Supplies ($50,000) and Communications ($30,000) clue to higher than expected use. 5 115,858,293,00 $ 12,684,996.00 $ 17,417,804.00 $ 334,086.00 116,066,135.00 $ 12,746,436.00 $ 17,601,870.00 $ 860,709.00 $ 5 12,421,893.00 $ 13,132,415.00 $ 13,022,415.00 $ Internal Support Expenditures Transfers Out Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out 2,500,315.00 669,491,00 $ 114,241,135.00 $ $ 13,636,436.00 $ $ 17,846,870.00 $ 860,709.00 $ 150,000.00 5.93% Fay. Motor Pool Fuel charges $65,000, Motor Pool $50,000, Info Tech CLEMIS $25,000, and Telephone Communications $10,000 due to usage; partially offset in other divisions. 0.00% 110,000.00 0.84% (1,825,000.00) -1.60% 890,000.00 6.53% 245,000.00 1.37% 0.00% 2,521,884.00 334,086.00 2,380,315.00 659,491.00 $ 146,495,179.00 $ 146,585,150.00 $ 147,275,150,00 $ (690,000.00) -0.47%
COUNTY OF OAKLAND FY 2017 THIRD 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 $ 769,412.00 $ 751,238.00 $ 609,338.00 $ 141,900.00 18.89% Fay. due to turnover. Operating Expenditures 34,900.00 34,900.00 25,000.00 9,900.00 28.37% Fay. Printing $4,900, Office Supplies $4,000, Expendable Equipment $1,000 due to less than anticipated use. Internal Support Expenditures 108,984.00 109,429.00 104,629.00 4,800.00 4.39% Fav. Info Tech Operations $3,600 and Telephone Communications $1,200 due to less anticipated use. Transfers Out 0.00% $ 913,296.00 $ 895,567.00 $ 738,967.00 $ 156,600.00 17.49% County Clerk (Vital Stats & Legal Rec's) Personnel Expenditures $ 3,585,031.00 $ 3,512,145.00 $ 3,046,845.00 $ 465,300.00 13.25% Fay. due to vacancies, turnover and underfilled positions. 34.75% Fav. Court Transcripts $32,700 due to prosecutors ordering fewer transcripts; Professional Services $34,500, Office Supplies $8,000, Personal Mileage $4,800, Equipment Maintenance $3,000 and Membership Dues $2,500 due to less than anticipated use. Partially offset by unfavorable Charge Card Fee ($3,000) due to increased activity. 2.67% Fav. Equipment Rental $3,600 and Info Tech Operations $22,400 due to less than anticipated use. 0.00% Operating Expenditures 279,160.00 279,160.00 182,160.00 97,000.00 Internal Support Expenditures 650,560.00 975,519.00 949,519.00 26,000.00 Transfers Out $ 4,514,751.00 5 4,766,824.00 $ 4,178,524.00 $ 588,300.00 12.34%
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES CLERKIREGISTER 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 $ 699,801.00 $ 137,800.00 781,178,00 1,042,647.00 792,847.00 249,800.00 16.45% Fay. due to turnover and undeffilled positions. 23.96% Fay. Elections Supplies $217,600 and Fees Per Diem $21,700 due to this year not being a major election year. Also favorable, Materials and Supplies $5,000, Office Supplies $2,600 and Travel and Conference $2,500 all due to reduced activity. Internal Support Expenditures 298,309.00 318,851,00 318,851.00 0.00% Transfers Out 0.00% $ 1,930,980.00 $ 2,199,099.00 $ 1,811,499.00 $ 387,600.00 17.63% Register of Deeds (and Micrographics) Personnel Expenditures $ 2,609,903.00 $ 2,561,258.00 $ 2,347,458,00 $ 213,800.00 Operating Expenditures 271,494.00 271,494.00 $ 187,794.00 83,700.00 8.35% Fay, due to vacancies, turnover and underfilled positions. 30.83% Fay. Metered Postage $25,500, Professional Services $24,000, Office Supplies $19,900, Material and Supplies $15,000, Expendable Equipment $6,000 and Printing $2,900, due to less than anticipated use. Partially offset by unfavorable Maintenance Contract ($9,800) and Charge Card Fees ($1,500) due to increased activity, Internal Support Expenditures 278,018.00 280,076.00 $ 278,276.00 1,800.00 0.64% Fay. Equipment Rental due to less than anticipated use. Transfers Out 0.00% $ 3,159,415.00 $ 3,112,828.00 $ 2,813,528.00 $ 299,300.00 9.62%
COUNTY OF OAKLAND FY 2017 THIRD 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 $ 6,289.00 $ Operating Expenditures 68,776.00 68,776.00 47,376.00 Internal Support Expenditures 11,467.00 11,812.00 4,712.00 $ 95,181.00 $ 95,477.00 $ 58,377.00 $ 8,600.00 57.76% Fay, due to vacant position. 21,400.00 31.12% Fay. Metered Postage $18,900 based on District Court activity and Printing $1,500 and Miscellaneous $1,000 due to less than anticipated use. 7,100.00 60.11% Fav. Info Tech Operations $7,100 due to the office no longer in existence. 37,100.00 38.86% Department Total Personnel Expenditures $ 7,830,777.00 $ 7,677,131.00 $ 6,709,731.00 $ Operating Expenditures 1,435,508.00 1,696,977.00 1,235,177.00 $ Internal Support Expenditures 1,347,338.00 1,695,687.00 1,655,987.00 $ Transfers Out 967,400.00 461,800.00 39,700.00 12.60% 27.21% 2.34% 0.00% $ 10,613,623.00 $ 11,069,795.00 $ 9,600,895.00 $ 1,468,900.00 13.27%
COUNTY OF OAKLAND FY 2017 THIRD 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,621.00 5 239,900.00 7.27% - Fay. Turnover, underfills, overfills, and vacant positions. Operating Expenditures 4,512,105.00 4,512,105.00 4,131,605.00 380,500.00 8.43% Fay. Title Search Fee $693,900 due to a change in the price structure with vendor contract. Also favorable, Fees Civil Service $161,000 and Foreclosure Notification $35,400, due to less than anticipated use. Partially offset by unfavorable Claims Paid ($240,200) from a settlement on a foreclosed property that was in litigation. Also unfavorable, Recording Fee Forfeiture Certificate ($157,700) due to properties entering second year of delinquency. Also unfavorable, Recording Fee Redemption Certificate ($104,800) due to withdrawing properties from foreclosure and Recording Fees ($14,300) due to filing a certificate of foreclosure, judgement, and certificate of error. In addition, Register of Deeds ($4,600) due to an increase in statutory fees for recording deeds. Internal Support Expenditures 780,029.00 1,032,970.00 982,170.00 50,800.00 4.92% - Fav. Primarily due to Info Tech Operations $50,800 due to less than anticipated use. Transfers Out 120,000.00 201,500.00 201,500.00 0.00% Division Total 5 8,784,820.00 $ 9,048,096.00 5 8,376,896.00 $ 671,200.00 7.42% Department Total $ 8,784,820.00 5 9,048,096.00 $ 8,376,896.00 $ 671,200.00 7.42%
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES BOARD OF COMMISSIONERS AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 2,185,531.00 $ 2,145,630.00 $ 2,075,630.00 $ 70,000.00 3.26% - Fay. due to vacancies and under-filled positions. Operating Expenditures 475,305.00 627,667.00 $ 582,667.00 Internal Support Expenditures 235,909.00 259,107.00 $ 254,107.00 45,000.00 7.17% - Fay. Professional Services-Annual Audit $13,000, Workshops and Meeting $10,000, Personal Mileage $9,000, Legal Services $8,000, Legislative Expense $7,000 and Printing $3,000 due to less than anticipated use. Partially offset by Unfav. Office Supplies ($5,000) due to unanticipated purchases. 5,000.00 1.93% - Fav. Telephone Communications due to less anticipated use. $ 2,896,745.00 $ 3,032,404.00 $ 2,912,404.00 $ 120,000.00 3.96% Department Total Personnel Expenditures $ 2,185,531.00 $ 2,145,630.00 $ 2,075,630.00 $ 70,000.00 3.26% Operating Expenditures 475,305.00 627,667.00 582,667,00 45,000.00 7.17% Internal Support Expenditures 235,909.00 259,107.00 254,107,00 5,000.00 1.93% $ 2,896,745.00 $ 3,032,404.00 $ 2,912,404.00 $ 120,000.00 3.96%
COUNTY OF OAKLAND FY 2017 THIRD 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 381,254.87 0.00% Internal Support Expenditures 468,447.00 477,724.00 477,724.00 0.00% Transfers Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 1,343,140.00 $ 1,342,819.87 $ 1,342,819.87 $ $ 495,412.00 $ 483,831.00 $ 483,831.00 $ 379,281.00 381,264.87 381264.87 468,447.00 477,724.00 477,724.00 $ 1,343,140.00 $ 1,342,819.87 $ 1,342,819.87 $ 0.00% 0.00% 0.00% 0.00% 0.00%
COUNTY OF OAKLAND FY 2017 THIRD 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 480,775.00 52,200.00 9.79% Fay - Professional Services-Consultants and Professional Services $15,000 due to less spending on these services related to soil erosion and environmental issues. Fav - Contracted Services $15,000 due to decreased spending on Soil Erosion corrective action issues. Fay - Material and Supplies $12,000 and Printing $10,000 the result of less demand for these items. Fay - Education Programs $10,000 due to reduced spending for Soil Erosion education programs to inform the public on the usage of soil erosion products. Fay - Legal Services $10,000 a result of Soil Erosion spending less on legal issues to enforce the laws of the soil erosion program. Fav - Metered Postage $4,000 due to post card flushing notices being charged to the system funds. Unfav - Expendable Equipment Expense ($14.000) due to replacing office chairs. Unfav - Travel and Conference ($8,000) the result of seminars to keep employees current on Michigan's Dept of Environmental Quality regulations. Internal Support Expenditures 4,881,378.00 5,137,611.00 5,550.111.00 (412.500,00) -8.03% Unfav - Drain Equipment Labor ($371,700) and Drain Equipment ($36,800) due to employee's labor and associated equipment that can not be charged to other funds; offset by favorable Charges for Services Revenue. Unfav - Info Tech Managed Print Services ($2,000) the result of actual spending more than budget Unfav - Insurance Fund ($2,000) due to an increase in the number of random drug tests. Transfers 56,165.00 56,165.00 56,165.00 0.00% Division Total $ 5,688,932.00 6 5,939,975.00 $ 6,300,275.00 $ (360,300.00) -6.07% Department Total $ 5,688,932.00 $ 5,939,975.00 $ 6,300,275.00 $ (360,300.00) -6.07%
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES COUNTY EXECUTIVE AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST {UNFAVORABLE) 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 244,991.00 33,000.00 11.87% Fav. Professional Services 818,000, Printing $10,000 and Metered Postage $5,000 due to less than anticipated use. Internal Support Expenditures 441,771.00 467,808.00 458,808.00 9,000.00 1.92% Fav. Info Tech Operations due to usage. $ 2,944,374.00 $ 2,916,087.00 $ 2,874,087.00 $ 42,000.00 1,44% Compliance Office Personnel Expenditures $ 1,645,259.00 $ 1,607,459.00 $ 1,587,459.00 $ 20,000.00 1.24% Fav. due to vacancies and underfilled positions. Operating Expenditures 49,252.00 80,202.00 80,202.00 0.00% Internal Support Expenditures 191,794.00 227,848.00 227,848.00 0.00% $ 1,886,305,00 $ 1,915,509.00 $ 1,895,509.00 $ 20,000.00 1.04% Corporation Counsel Personnel Expenditures $ 2,288,295.00 $ 2,278,992.00 $ 2,248,992.00 $ 30,000.00 1.32% Fav. due to vacancies and underfilled positions. Operating Expenditures 87,333.00 87,333,00 83,333.00 4,000.00 4.58% Fay. Expendable Equipment due to less than anticipated use, Internal Support Expenditures 385,885.00 402,709.00 392,709.00 10,000.00 2.48% Fay. Insurance Fund due to usage. $ 2,761,513.00 $ 2,769,034.00 $ 2,725,034.00 $ Department Total Personnel Expenditures $ 6,158,166.00 $ 6,056,739.00 $ 6,006,739.00 $ Operating Expenditures 414,576.00 $ 445,526.00 408,526.00 Internal Support Expenditures 1,019,450.00 1,098,365.00 1,079,365.00 Transfers Out 5 7,592,192.00 $ 7,600,630.00 $ 7,494,630,00 $ 44,000.00 1.59% 50,000.00 0.83% 37,000.00 8.30% 19,000.00 1.73% 106,000.00 1.39%
ADOPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT FY 2017 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 225,527.00 $ 219,706.00 $ 219,706.00 $ 0.00% Operating Expenditures 4,017.00 4,017.00 1,017.00 3,000.00 74.68% Fay. Training $2,000 and Membership Dues $800 due to less than anticipated use. internal Support Expenditures 14,997.00 14,997.00 14,997.00 0.00% $ 244,541.00 $ 238,720.00 $ 235,720.00 $ 3,000.00 1.26% Equalization Personnel Expenditures $ 8,462,699.00 $ 8,278,343.00 $ 7,738,343.00 $ 540,000.00 6.52% Fay. due to vacancies and underlined positions. Operating Expenditures Internal Support Expenditures Fiscal Services Personnel Expenditures 431,404.00 431,404.00 333,404.00 98,000.00 22.72% Fay. Personal Mileage $30,000, Professional Services $29,000, Printing $20,000, and Office Supplies $19,000 due to less than anticipated use. 918,024.00 1,149,948.00 1,149,948.00 0.00% $9,812,127.00 $9,859,695.00 $ 9,221,695.00 $ 638,000.00 6.47% $ 8,124,132.00 $ 7,953,612.00 $ 7,203,612.00 $ 750,000.00 9.43% Fay. due to vacancies and underfilled positions. Operating Expenditures 388,600.00 391,397.34 323,397.34 68,000.00 17.37% Fay. Metered Postage $25,000, Professional Services $18,000, Printing $15,000, and Office Supplies $10,000 due to less than anticipated use. Internal Support Expenditures 1,253,714.00 1,702,808.00 1,662,808.00 40,000.00 2.35% Fay. Info Tech Operations $40,000 due to usage. $ 9,766,446.00 $ 10,047,817.34 $ 9,189,817.34 $ 858,000.00 8.54% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 16,812,358.00 $ 16,451,661.00 $ 15,161,661.00 $ 1,290,000.00 824,021.00 826,818.34 657,818.34 169,000.00 2,186,735.00 2,867,753.00 2,827,753.00 40,000.00 7.84% 20.44% 1.39% 0.00% $ 19,823,114.00 $ 20,146,232.34 $ 18,647,232.34 $ 1,499,000.00 7.44%
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES CENTRAL SERVICES AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administrative Personnel Expenditures $ 225,444.00 $ 219,623.00 5 219,623.00 $ 0.00% Operating Expenditures 3,298.00 3,298.00 598.00 2,700.00 81.87% Fav. Travel and Conference $2,500 due to no travel anticipated to occur in FY 2017. Internal Support Expenditures 14.295.00 15,038.00 15,038.00 0.00% Transfers Out $ 243,037.00 $ 237,959.00 $ 235,259.00 $ 2700.00 1.13% Support Services Personnel Expenditures $ 1,223,085.00 $ 1,198,604.00 $ 1,171,704.00 $ 26,900.00 2.24% Fay. due to underfilled position. Operating Expenditures 372,695.00 401,695.00 357,095.00 44,600.00 11.10% Pay. Mail Handling-Postage Svc $25,000 due to customers switching to metered mail. Also, favorable Equipment $13,000 due to less than anticipated cost of replacement lift truck with new vendor contract; Equipment Maintenance $11,600 due to less anticipated equipment repairs; Maintenance Contract $4,000 due to maintenance included in the first year of the new scanner system; Contracted Services $3,000 due to less than anticipated use; Office Supplies $3,000 due to less than anticipated supplies needed; offset by Unfav, Metered Postage (515,000) as a result of an increase in the activity of standard mail being metered. Internal Support Expenditures 755,809.00 790,559.00 $ 790,559.00 0.00% Transfers Out 0.00% $ 2,351,589.00 $ 2,390,858.00 $ 2,319,358.00 $ 71,500.00 2.99% Department Total Personnel Expenditures $ 1,448,529.00 $ 1,418,227.00 $ 1,391,327.00 $ Operating Expenditures 375,993.00 404,993.00 357,693.00 Internal Support Expenditures 770,104.00 805,597.00 805,597,00 Transfers Out 26.900.00 47,300.00 1.90% 11.68% 0.00% 0.00% $ 2,594,626.00 $ 2,628,817.00 5 2,554,617.00 $ 74,200.00 2.82%
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES FACILITIES MANAGEMENT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 208,485.00 $ 203,689.00 $ 203,689.00 $ 0.00% Operating Expenditures Internal Support Expenditures Facilities Engineering Personnel Expenditures 5,764.00 5,764.00 3,764.00 2,000.00 34,70% Fav. Membership Dues $1,000 along with Travel and Conference $1,000 as a result of less than anticipated usage. 16,290.00 16,290.00 10,790.00 5,500.00 33.76% Fay. Info Tech Operations based on actual usage. $ 230,539.00 $ 225,743.00 5 218,243.00 $ 7,500.00 3.32% $ 828,821.00 $ 811,787.00 $ 824,287.00 $ (12,500.00) -1.54% Unfav. due to overfilled positions. Operating Expenditures 168,682.00 168,682.00 172,732.00 (4,050.00) -2.40% Unfav. Licenses and Permits ($5,000) due to increase in cost of nuclear gauge inspection. Unfav. Personal Mileage ($1,250) due to use of personal vehicles for satellite locations. Partially offset by fay. Software Support Maintenance $2,200 due to timing of software support. Internal Support Expenditures 54,224.00 54,380.00 54,380.00 0.00% $ 1,051,727.00 $ 1,034,849.00 5 1,051,399.00 $ (16,550.00) -1.60% 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 176,496.00 (2,050.00) -1.18% Internal Support Expenditures 70,514.00 70,670.00 65,170.00 5,500.00 7,78% $1,282,266.00 $ 1,260,592.00 $ 1,269,642.00 $ (9,050.00) -0.72%
COUNTY OF OAKLAND FY 2017 THIRD 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 $ 734,389.00 $ 24,500.00 3.23% Fay. due to turnover. Operating Expenditures Internal Support Expenditures Transfers Out 337,622.00 37,914.00 503,422.00 47,003.00 291,722.00 73,103.00 211,700.00 (26,100.00) 42.05% Fay. Legal Services $95,000, Professional Services $85,900, Fees- Per Diems $8,500, Metered Postage $8,300, Court Reporter Services $3,300 Travel, and Conference $2,900 due to less than anticipated activity. -55.53% tinFav. Primarily Info Tech Operations ($24,500) due to actual charges more than budget; offset by favorability in Workforce Management division. Also unfavorable Motor Pool ($1,400) due to increased usage. 1,149,652.00 $ 1,309,314.00 $ 1,099,214.00 $ 210,100.00 16.05% Workforce Management Personnel Expenditures 1,860,382.00 $ 1,818,174.00 $ 1,809,274.00 $ 8,900.00 0.49% Fay. due to overtime, underfilled and overfilled positions. Operating Expenditures Internal Support Expenditures 390,612.00 647,635.00 390,612.00 847,073.00 254,012.00 716,573.00 136,600.00 34.97% 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. 130,500.00 15.41% Fav. Info Tech Operations $112,800 partially offset by unfavorability in Benefits Adminstration and Administration divisions. Also favorable Equipment Rental $12,500 and Telephone Communication $4,800 due to reduced usage. 276,000.00 9.03% 0.00% 3,777.00 10,200.00 72.98% Fay. Travel and Conference $3,200, Office Supplies $3,100 and Expendable Equipment $1,000 due to less than anticipated activity. 2,898,629.00 $ 3,055,859.00 $ Benefits Administration Personnel Expenditures 176,926.00 $ 172,721.00 $ Operating Expenditures 13,977.00 13,977.00 2,779,859.00 $ 172,721.00 $
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES HUMAN RESOURCES ADOPTED BUDGET AMENDED BUDGET FY 2017 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Internal Support Expenditures 163,284.00 163,284.00 211,984.00 (48,700.00) -29.83% UnFav. Primarily in Info Tech Operations ($49,900) due to actual charges more than budget; offset by favorability in Workforce Management Division. 354,187.00 $ Department Total Personnel Expenditures 2,811,424.00 $ Operating Expenditures 742,211.00 Internal Support Expenditures 848,833.00 Transfers Out 4,402,468.00 $ 349,982.00 $ 388,482.00 $ (38,500.00) -11.00% 2,749,784.00 $ 2,716,384.00 $ 33,400.00 1.21% 908,011.00 549,511.00 358,500.00 39.48% 1,057,360.00 1,001,660.00 55,700.00 5.27% 4,715,155.00 $ 4,267,555.00 $ 447,600.00 9A9%
COUNTY OF OAKLAND FY 2017 THIRD 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 $ 213,263.00 $ (8,000.00) -3.90% Unfav. due to anticipated Fringe Benefit charges. Operating Expenditures 8,389,499.00 7,955,451.00 6,268,451.00 1,687,000.00 21.21% Fav. due to Private Institutions $1,032,000, Private Institutions Foster Care $500,000, and Foster Boarding Homes $155,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,173,285.00 $ 6,494,285.00 $ 1,679,000.00 20.54% Health Personnel Expenditures $ 25,563,772,00 $ 25,034,335.00 $ 23,834.335.00 $ 1,200,000.00 4.79% Fay. due to turnover and underfilled positions. 290,600.00 Operating Expenditures Internal Support Expenditures 3,363,684.00 3,407,767_96 3,117,167.96 2,867,716.00 3,282,269.00 3,226,769.00 8.53% Fay. Professional Services $225,000 due to increased individuals enrolled in Medicaid which makes them ineligible for the County's Dental program. Fay. Software Support Maintenance $129,700 due in part to funds budgeted for new Environmental Health application, but is not needed. Unfav. Adj Prior Years Revenue ($52,900) due to adjustment for FY 2016 estimated administrative overhead cost distribution and Metered Postage ($11,200) due to higher than anticipated use. 55,500.00 1.69% Fay. Telephone Communications $32,000 and Info Tech Operations $31,300 based on usage. Partially offset by unfav. Info Tech Managed Print Services ($7,800) due to usage. Transfers Out 60,395.00 60,395.00 $ 31,795,172.00 $31,784,766.96 $ 30,238,666_96 $ 1,546,100.00 4.86%
COUNTY OF OAKLAND FY 2017 THIRD 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,234,178,00 $ (420,000.00) -2.50% Unfav. primarily due to overtime. 3,693,861.00 129,400.00 2,728,667.00 Operating Expenditures Internal Support Expenditures 3,954,947.11 3,825,547.11 2,850,194.00 2,854,594.00 3.27% Fav. Provisions $40,000 due to lower food costs and fluctuations in resident population. Fav. Medical Services Physicians $35,000 due to services provided by Oakland Integrated Healthcare Network (011-LN). Fay. Drugs $25,000 and Hospitalization $18,000 due to fewer medical needs along with cost saving initiatives. Fay. Printing $11,400 due to lower than anticipated use. (4,400.00) -0.15% Unfav. Radio Communications ($6,500) and Info Tech CLEMIS ($4,800) due to higher than anticipated use. Partially offset by fav. Info Tech Operations $6,900 due to usage. Transfers Out 57,692.00 57,692.00 $ 23,198,743.00 $ 23,677,011.11 $ 23,972,011.11 $ (295,000.00) -1.25% Homeland Security Personnel Expenditures $ 852,675.00 $ 833,970.00 $ 783,970.00 $ 50,000.00 6.00% Fay. due to turnover. Operating Expenditures 304,866.00 304,866.00 271,466.00 33,400.00 10.96% Fay. Equipment Maintenance $23,000 due to Limited, regular maintenance costs plus unforeseen major repairs incurred on specialty/hazmat vehicles. Fav Personal Mileage $6,500 due to use of grant funding for mileage reimbursement. Fav. Professional Services $4,400 due to less than anticipated use. Internal Support Expenditures Transfers Out Department Total Personnel Expenditures 532,046.00 580,691.00 514,691.00 66,000.00 11.37% Fay. Info Tech Operations $45,000 due to usage and Insurance Fund $21,000 due to actual premiums less than expected due to insurance market fluctuations and rates. $ 1,689,587.00 $ 1,719,527.00 $ 1,570,127.00 $ 149,400.00 $ 43,401,725.00 $ 42,887,746.00 $ 42,065,746.00 $ 822,000.00 1.92%
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES ADOPTED AMENDED BUDGET BUDGET Operating Expenditures 15,751,910.00 15,623,032.07 Internal Support Expenditures 6.141,000.00 6,725,725.00 Transfers Out - 118,087.00 FY 2017 FORECAST 13,482,632.07 6,608,625.00 118,087.00 AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 2,140,400.00 13.70% 117,100.00 1.74% 0.00% $ 65,294,635.00 $ 65,354,590.07 $ 62,275,090.07 $ 3,079,500.00 4.71%
190.912.00 46,500.00 144,412.00 190,912.00 202,229.00 202,926.00 206,726.00 3,800.00 1.84% Fav. Insurance Fund $2,500 and Motor Pool Fuel Charges $1,300 due to less than antidpatsd usage. 24.36% Fav, Soldier Burial $34,600 and Soldier Relief $9,400 due to less than anticipated activity. Partially offset by unfavorable Travel and Conference ($2,000) due to increased activity. 0.00% Operating Expenditures Internal Support Expenditures Transfers Out ADOPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT FY 2017 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Public Services - Admin. Personnel Expenditures $ 225,492.00 $ 219,671.00 219,671.00 $ 0,00% Operating Expenditures 4,800.00 4,800.00 4,800.00 0.00% Internal Support Expenditures 7,039.00 7,039.00 7,039.00 0.00% $ 237,331.00 $ 231,510.00 $ 231,510.00 $ 0.00% Veterans Services Personnel Expenditures $ 1,641,689.00 $ 1,604,980.00 1,592,180.00 $ 12,800.00 0.80% Fay. due to underfilled positions. $ 2,034,830.00 $ 2,002,618.00 $ 1,939,518.00 $ 63,100.00 3.15% Community Corrections Personnel Expenditures $ 3,983.111.00 $ 3,904,519.00 3,844,519.00 $ 60,000.00 1.54% Eav. due to vacant and underfilled positions. 7,29% Fay, Office Supplies $15,000, Software Rental Lease Purchase $9,800, Personal Mileage $3,000, and Printing $5,500 due to lea than anticipated use. Partially offset by unfavorable Metered Postage ($1,100) due to increased use. 3.50% Fay. Info Tech Operations $16,400, Motor Pool Fuel Charges $3,000 and Motor Pool $6,500 due to less than anticipated use. Partially offset by unfavorable Info Tech CLEM'S ($5,500). Operating Expenditures 502,025,00 502,025.00 465,425.00 36,600.00 Internal Support Expenditures 522,899.00 583,366.00 562,966.00 20,400.00 Transfers Out - 0.00% $ 5,008,035.00 $ 4,989,910.00 $ 4,872,910.00 3 117,000.00 2.34%
ADOPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT FY 2017 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES IVISU Ext. - Oakland County Personnel Expenditures $ 666,407.00 3 650,491.00 $ 582,391.00 $ 68,100.00 10.47% Fay, due to vacant and undertined positions. 9,900,00 4.36% Fay. Special Events Program $3,700, Office Supplies $2,300, Travel and Conference $1,800, Printing $1,500 and Personal Mileage $1,400 due to less than anticipated use. Partially offset by unfavorable Advertising ($800). 10,000.00 3.36% Info Tech Operations $7,100, Motor Pool $1,700, and Insurance Fund $1,300 due to less than anticipated use. Operating Expenditures 227,239.00 227.239.00 217,339.00 Internal Support Expenditures 285,148.00 297,390.00 287,390.00 $ 1,179,794.00 $ 1,175,120.00 $ 1,087,120.00 8 88,000.00 7,49% Medical Examiner Personnel Expenditures $ 3,421,087.00 $ 3,347,810.00 $ 3,072,310.00 $ 275,500.00 8.23% Fav. due to vacant and underlined positions. Operating Expenditures 600,006.00 631,059.00 666,259.00 (35,200.00) -5.58% Unfav. Transportation Service ($37,700), Medical Supplies ($9,700), Laboratory Supplies ($8,600). Miscellaneous ($4,400) and Laundry and Cleaning ($4,300) due to increased activity. Partially offset by favorable Training $9,800, Office Supplies $5,500, Film and Processing $4,900, Professional Services $2,600, and Freight and Express $2,000 due to less than anticipated activity. Internal Support Expenditures 812,143.00 844,109.00 781,009.00 63,100.00 7.48% Fay. Equipment Rental $40,600, Info Tech Operations $12,800, Insurance Fund $7,700 and Motor Pool Fuel Charges $2,000 due to less than anticipated activity. Transfers Out $ 4,833,236,00 $ 4,822,978.00 $ 4,519,578.00 8 303,400.00 6.29% Animal Control Personnel Expenditures $ 2,444,619,00 $ 2,402.243.00 $ 2,260,343.00 3 141,900.00 5.91% Fay, due to vacant and underfilled positions, overtime and an call. Operating Expenditures 280,097.00 280,097.00 320,097.00 (40,000.00) -14.28% Unfav. Animal Supplies ($14,300), Uniforms ($9,900), Metered Postage ($6,900), Medical Supplies ($5,000),and Tax Collection Supplies ($2,700) due to increased activity. Partially offset by favorable Contracted Services $10,000 and Travel and Conference $1,500 due to less than anticipated activity. A budget amendment is recommended to transfer funds from the Legacy Fund.
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT EXPENDITURES PUBLIC SERVICES ADOPTED BUDGET Internal Support Expenditures 862,554.00 AMENDED BUDGET 993,327.00 AMOUNT FY 2017 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ------------ -------- ---------- ----- 980,627.00 12,700.00 1.28% Fay. Insurance Fund 513,400 and Motor Pool Fuel Charges $7,000 due to lesss than anticiapted use. Partially offset by unfavorable Info Tech Equipment Rental ($8,000) and Radio Communications ($1,500) due to increased usage. Transfers Out $ 3,587,270.00 $ 3,675.657.00 $ 3,561,057.00 $ 114,600.00 3.12% Circuit Court Probation Personnel Expenditures Operating Expenditures 54,326.00 56,411.00 43,911,00 12,500.00 22.16% Fav. Expendable Equipment 52,100, Metered Postage $3,700 and Office Supplies $8,800 due to less than anticipated use. 5 0.00% Internal Support Expenditures 569,207.00 579,355.00 567,855.00 11,500.00 1.95% Fav. Info Tech Operations 56,700 and Info Tech Managed Print Services $4,800 due to less than anticipated use. 5 623,533.00 $ 635,766,00 $ 611,766.00 $ 24,000.00 3.77% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out 5 12,382,405.00 5 12,129,714,00 1,859,405.00 1,892,543.00 3,262,219.00 3,511,312.00 $ 11,571,414.00 $ 555,300.00 1,862,243.00 30,300.00 3,389,512.00 121,500.00 4.60% 1.60% 3.46% $ 17,504,029.00 $ 17,533,569.00 $ 16,823,469,00 $ 710,100.00 4.05%
COUNTY OF OAKLAND FY 2017 THIRD 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,340,549.00 $ (48,000.00) -3.71% Unfav. due to User Support Specialist position (1090108-10242) budgeted in Planning and Economic Development Services Division but was charged to Administration and Emergency Salaries for Workforce Development. 379,901.00 71,800,00 Operating Expenditures Internal Support Expenditures 442,222.00 451,701.00 65,089.00 148,103.00 15.90% Fay. Professional Services $23,800 due to reduction of contractual services. Fav. Printing $21,400, Travel and Conferences $10,600, and Personal Mileage $8,600 due to less than anticipated activity. 149,903.00 (1,800.00) -1.22% Unfav. Info Tech Operations due to a one time charge of software license fees. Transfers 22,028.00 22,028.00 _ $ 1,829,311.00 $ 1,914,381.00 $ 1,892,381.00 $ 22,000.00 1.15% Planning and Economic Development Services Personnel Expenditures $ 4,077,694.00 $ 3,990,256.00 $ 3,672,256.00 $ 318,000.00 Operating Expenditures 1,376,353.00 1,494,934.00 1,193,934.00 301,000.00 7.97% Fay. due to vacancies and under filled positions. 20.13% Fay. Professional Services $99,200 due to reduction of contractual services. Fay. Workshops and Meetings $116,300 and Business Recruitment $44,800 due to lower than anticipated costs subsequent to budget as well as fav. Printing $49,300 due to less than anticipated use. Partially offset by unfav. Advertising ($45,100) for support of business development events and trade missions. 0.21% Fay. Telephone Communications $9,800, and Info Tech Managed Print Services $1,100 due to less than anticipated usage. Offset by Unfav. Insurance Fund ($9,100) due to usage. Internal Support Expenditures 832,833.00 837,532.00 835,732.00 1,800.00 Transfers 75,000.00 75,000.00 $ 6,286,880.00 $ 6,397,722.00 $ 5,776,922.00 $ 620,800.00 9.70%
COUNTY OF OAKLAND FY 2017 THIRD 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 ••n Operating Expenditures Internal Support Expenditures Transfers Workforce Development Personnel Expenditures 5 25,620.00 $ 25,620.00 $ 25,620.00 $ 0.00% Operating Expenditures Internal Support Expenditures Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 25,620.00 $ 25,620.00 $ 25,620.00 $ 0.00% $ 5,425,314.00 $ 5,308,425.00 $ 5,038,425.00 $ 270,000.00 5,09% 1,818,575.00 1,946,635.00 1,573,835.00 372,800.00 19.15% 897,922.00 985,635.00 985,635.00 0.00% 97,028.00 97,028.00 0.00% --- $ 8,141,811.00 $ 8,337,723.00 $ 7,694,923.00 $ 642,800.00 7.71%
COUNTY OF OAKLAND FY 2017 THIRD 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,153.00 $ 367,153.00 5 367,183.00 5 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) -13.79% Unfav. due to projected county portion of drain assessments for county roads. Road Commission \Tri Party Agreement 100.00 1,819,944.00 1,819,944.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,620,616.00 9,620,616.00 0.00% Total 5 11,521,204.00 $ 13,341,048.00 $ 13,521,048.00 $ (180,000.00) -1.35% COUNTY BUILDINGS $ 2,781,940.00 $ 2,181,177.00 $ 2,241,177.00 $ (60,000.00) -2.75% Unfavorable Maintenance Department Charges. Offset by favorable Grant Match and IT Development. A budget amendment will be made by year end if the trend continues. STATE AND FEDERAL - COUNTY ASSOCIATIONS Michigan Assoc. of Counties 5 73,000.00 $ 73,000.00 $ 73,000.00 5 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 5 300,000.00 $ 300,000.00 5 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 5 315,936.00 5 282,545.00 $ 282,545.00 5 321,502.00 130,922.00 130,922.00 300,000.00 300,000.00 300,000.00 406,815.00 406,815.00 406,815.00 1,443,887.00 1,068,282.00 868,282.00 5.281,710.00 2,104,656.00 1,864,656.00 600,000.00 1,186,866.00 1,186,866.00 8,600.00 5,600.00 8,600.00 726,780.00 726,780.00 250,000.00 193,502.00 193,502.00 200.000.00 240,000.00 0.00% 0.00% 0.00% 0.00% 18.72% 11.40% 0.00% 0.00% 0.00% 0.00% Favorable based on timing of grant agreements. Favorable based on lT Development projections to date,
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT NON-DEPARTMENTAL EXPE NDITU RES AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION 0.00% 0.00% 0.00% 0.00% 3.61% Overtime Reserve Security Reserve Substance Abuse Coord Agency Summer Employees Salary Appropriation Total 275,000.00 1,725,980.00 4,212,170.00 250,000.00 275,000.00 1,052,298.00 4,212,170.00 250,000.00 275,000.00 1,052,298.00 4,212,170,00 250,000.00 $ 15,391,900.00 $ 12,198,436.00 $ 11,758,436.00 $ 440,000.00 Transfers to Other Funds Fire Records Management CLEMIS Informatiort 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 $ 451,742.00 $ 461,742.00 $ 461,742.00 1,844,186.00 1,844,186.00 1.844,186.00 3,620,676,00 3.620,676.00 3,620,676.00 2,244,250.00 2,244,250.00 2,244,250.00 1,200, 000.00 2,294,171.00 2,294,171.00 5,500.000.00 5,500,000.00 5,500,000.00 $ 14,870,854.00 $ 15,965,025.00 $ 15,965,025.00 $ 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0,00% 0.00% 0.00% 0.00% 0.00% 0.00% 0,00% 0.00% 0.00% TOTAL NON-DEPT. APPROPRIATIONS $ 45,492,998.00 $ 44,612,786.00 $ 44,377,786.00 $ 235,000.00 0.53% TRANSFER TO GENERAL PURPOSE FUNDS Child Care Fund $ 23,442,791.00 $ 23,257,258.00 $ 23,257,258.00 $ 0.00% Social Welfare Fund Foster Care 1,000,00 1,000.00 1,000.00 0.00% $ 23,443,791.00 $ 23,258,258.00 $ 23,258,258.00 $ 0.00% TOTAL EXPENDITURES $ 68,936,789.00 $ 67,871,044.00 $ 67,636,044.00 $ 235,000,00 0.35%
FY 2017 BUDGET AMENDMENTS
FY 2017 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS
BUDGET AMENDMENTS
M.R. #16264 - 10/0612016
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
MR. #16291 - 10/26/2016
Circuit Court -2017 Michigan Drug Court Grant Program (Juvenile Drug Court) - Grant Acceptance
M.R. #16298 - 11/1012016
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/0812016
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 - 12/09/2016
Sheriffs Office - Standard Law Enforcement Services Agreement with the Charter Township of Commerce,
January 1, 2017 - December 31, 2018
$ 103,838.00
32,899.00
M.R. 02/15/2017
Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance)
M.R. #17025 - City of Huntington Woods 6,833.00
M.R. #17027 - City of South Lyon $ 12,578.00
M.R. #17028 - Township of Lyon $ 13,923.00
MR. #17029 - City of Novi $ 83,333.00
$ 116,667.00
M.R. #17032 - 02115/2017
Facilities 'Management/Facilities Planning and Engineering - Building Security Enhancements Project -
Jail K Block Intercom System Replacement
M.R. #17000 - 02/15/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 Interlace'
Agreement, July 1, 2016- June 30, 2019
MR. 417046 - 03/15/2017
Department of Health and Human Services Children's Village Division - Oakland County Interlace'
$ 275,000.00
50,000.00
$ 161,586.00
59,672.00
2,525.00
65,755.00
$ 124,200.00
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 - 0311512017
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. - 0313012017
Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance)
M.R. #17061 - City of Farmington
M.R. #17062 - Township of Novi
MR. #17060 -0313012017
Sheriffs Office - Use of Forfeited Funds
MR. #17082 -04126/2017
Clerk/Register of Deeds - Elections Division - 2017 Help America Vote Act (NAVA) Grant
Acceptance and Equipment Purchase
14,489.00
1,066.00
15,555.00
$ 402,986.00
$ 150,000.00
MR. - 05/10/2017
Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance)
M.R. #17096 - Charter Township of Highland $ 59,398,00
M.R. #17097 - Charter Township of White Lake $ 58,563.00
M.R. #17098 - City of Clawson $ 14,259.00
M.R. #17093 - 05110/2017
Sheriffs Office - Use of Crime Victim's Rights Act Funds
M.R. #17095 - 05/10/2017
Sheriffs Office -2017 Reorganization, Position Deletions and Creations
M.R. - 05/2512017
Board of Commissioners - Pilot Local Road Improvement Program (Planned Use of Fund Balance)
M.R. #17110 - City of Hazel Park $ 19,223.00
M.R. #17111 - City of Huntington Woods 7,267.00
M.R. #17112 - City of Troy $ 108,105.00
M.R. #17113 - City of Clawson $ 12,480.00
M.R. #17114 - City of Orchard Lake Village 4,199.00
M.R. #17116 - City of Keego Harbor 3,774.00
M.R. #17116 - City of Sylvan Lake 3,287.00
M.R. #17117 - City of Pleasant Ridge 5,627.00
M.R. #17118 - City of Madison Heights $ 37,716.00
M.R. #17124 - City of Berkley $ 15,252.00
M.R. #17126 - City of Auburn Hills $ 29,877.00
M.R. #17127 - City of Rochester $ 14,440.00
M.R. #17129 - City of Rochester Hills $ 86,914.00
M.R. #17133 - City of Lathrup Village 8,934.00
M.R. #17137 - City of Pontiac $ 84,753.00
M.R. #17138 - City of Farmington Hills $ 100,745.00
M.R. #17139 - City of Farmington $ 11,642.00
M.R. #17140 - City of VVixom $ 18,814.00
M.R. #17141 - Village of Milford 8,358.00
M.R. #17145 - Village of Leonard 1,409.00
132,220.00
26,606.00
11,240.00
FY 2017 BUDGET AMENDMENTS
M.R. #17147 - Village of Ortonville 2,981.00
M.R. #17149 - Village of Holly 7,711.00
M.R. #17150 - City of the Village of Clarkston 1,820.00
MR. #17152 - City of Bloomfield Hills $ 10,520.00
$ 605,848.00
- 0512512017
Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance)
M.R. #17128 - City of Rochester Hills $ 160,578.00
M.R. #17135 - Charter of West Bloomfield $ 278,780.00
M.R. #17143 - Charter Township of Oakland $ 42,254.00
M.R. #17144 - Township of Addison $ 19,767.00
M.R. #17148 - Township of Rose $ 20,506.00
$ 521,885.00
M.R. #17099 - 05/25/2017
Board of Commissioners - Designation of June 2017 as National Safety Month in Oakland County
and Support of Efforts to Promote Firearms Safety Month in Oakland County
M.R. #17106 - 05/2512017
County Executive/Corporation Counsel - Creation of One Senior Assistant Corporation Counsel
Position
M.R. #17153 - 05/25/2017
Board of Commissioners - Sponsorship of Art, Beats and Eats Festival
and Support of Efforts to Promote Firearms Safety Month in Oakland County
M.R. - 06/15/2017
Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance)
M.R. #17168 - Charter Township of Oxford
5,000.00
46,170.00
10,000.00
32,678.00
MR. #17170 - 06/3012017
Management & Budget FY 2017 Second Quarter Report
Adjustments to Children's Village Child Care Fund
Adjustments to Economic Development and Community Affairs
Adjustments to Non-Departmental
M.R. #17172 - 06/15/2017
Board of Commissioners - Position Deletion/Position Creations and Webcasting System
Project
M.R. #17176 - 06/15/2017
Sheriff's Office - Marine Patrol Services Agreement with the Charter Township of Bloomfield
2017/2018
M.R. #17177 - 06/15/2017
Facilities Planning and Engineering (FPE)/Sheriff's Office (SO) - Jail Kitchen Flooring and
Dishwasher Replacement Project
233.00
$ 31,507.00
$ 34,936.00 $ 66,676.00
44,796.00
$ 2,690.00
$ 123,539.00
TOTAL AMENDED BUDGET AS OF 06/30/2017 $ 445,823,963.15
Award/Amendment IQuarter included (QTR/FY) IDeadline $ 6,000.00 3OTR/FY17 8/10/2017 $ 6,000.00 3QTR/FY17 8/10/2017 Grants $10,000 and Under ]Grant sign off I Department or Division 'Grant Title 7/20/2017 Friend of the Court FY 2017 Access and Visitation Grant - Amendment 7127/2017 Health 2017 Michigan Local Food Council Network Seed Grant Acceptance
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT ENTERPRISE FUND TREASURER'S OFFICE ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAVALINFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DELINQUENT TAX REVOLVING FUND 51600 REVENUES Charges for Services $14,000,000.00 $14,000,000.00 $14,100,000.00 5100,000.00 0.71% Fav. Mainly due to increased activity for Collection Fees. Other Revenues 1,470,000.00 1,470,000.00 1,718,800.00 $248,800.00 18.93% Fay. Mainly due to the Premiums on Bond Sales. The premiums were for the Delinquent Tax Anticipation Notes sale. Total Revenues 815,470,000.00 815,470,000.00 815,818,800.00 $348,800.00 2.25% OPERATING EXPENSES Personnel Expenditures Operating Expenditures $ 204,011.00 588,565.00 $ 199,524.00 $ 199,524.00 533,555,00 297,500.00 0.00% 291,055.00 49.45% Fay. Info Tech Development $200,000 due to anticipated project delay until FY 2018. Also favorable, Professional Services $60.000 due to less than anticipated use and Indirect Costs 816,600 actual charges determined after budget finalization. Ending FY 2016 Designated Net Positions—, NP-Un Res - Designated - Debt Service NP-Un Res - Designated - DeIing Taxes Receivable NP-Un Res - Designated - Collection Fees Undesignated - Net Position Total Net Position - Ending Interest Expense Transfer Out to Other Funds: General Fund - Collection Fees GE - Non-Departmental Work Release Facility Refunding Debt Svc Office Bldg Renovation Refunding Debt Svc 52-3 District Court Refunding Debt Svc Total Transfer Out to Other Funds Total Operating Expenses REVENUE OVER (UNDER) EXPENDITURES' Total Net Position - Beginning Total Net Position - Ending 223,069.00 3048,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,682,700.00 1,877,800.00 1,310.800.00 $ 16,819,478.00 $ 17,830,828.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,441,502.00 ($1,622,702.00) $200,191,992.94 $1913,569,290.94 $46.033,797.00 147,516,430.63 6,641,765.31 ($1,622,702.00) $1 98.569,290.94 98,069.00 43.96% Fay, related to lower debt interest rates. 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2.18% $737,924.00 (52,365,113.00) (52,360,626.00) 389,124.00 * 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
487,309.00 480,995.00 ($35,009.00) ($28,695.00) $138,395.00 342,500,00 $146,095.00 $117,400.00 28.77% - 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,600 due to less use, -509.13% ($27,945.00) $ 118.900.00 $146 845.00 ($34,259.00) $118,900.00 5146,845.00 ($34,259.00) ($27,945.00) OPERATING EXPENSE NET OPERATING INCOME (LOSS) TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS TRANSFERS OUT NON-OPERATING REVENUE (EXPENSE) TOTAL NET INCOME (LOSS)* TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING 165,942.82 $254,842.52 750.00 750.00 1,500.00 $750,00 100.00% Fay. Due to accrued interest and income from investments. COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT ENTERPRISE FUNDS TREASURER ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DEUNQUENT PERSONAL PROPERTY TAX (51800) OPERATING REVENUE $452,300.00 $452.300,00 $450,000.00 $7,700.00 1.70% - Fay. Administrations Fees $10,000 due to increased collections. Partially offset by Reimbursement Salaries ($2,300) due to less than anticipated activity. * Please note that in the Adopted Budget (line-item book) this is budgeted as 'Planned Use of Balance" in the revenue category.
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT ENTERPRISE FUND PARKS & RECREATION ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OAKLAND COUNTY PARKS & RECREATION COMMISSION (55800) OPERATING REVENUE OPERATING EXPENSE NET OPERATING INCOME (LOSS) NON-OPERATING REVENUE (EXPENSE) TOTAL INCOME BEFORE TRANSFERS TRANSFERS IN $ 9,975,555.00 $ 10,317,465.00 $ 10,179,465.00 $ (138,000.00) -1.34% Overal Charges for Services revenues are unfav. ($171,000) compared to activity through the third-quarter of FY2016 due to weather fluctuations and demand, including Entrance Fees Gen Admission ($194,000), Greens Fees ($109,000), and Water Feature Ride ($5,000). Partially offset by fay, Sales Retail $54,000, Rental Goff Carts $25,000, Fees Camping $14,000, and Fees Day Use $14,000. Also favorable general material Donations $33,000; a budget amendment is recommended. $ 25,207,064.00 $ 26,144,406.00 $ 25,904,406.00 $ 240,000.00 0.92% Fay. variances are based on historical use which usage may change due to seasonal conditions: Contracted Services $20,000, Building Maintenance $50,000, Grounds Maintenance $50,000 and General Program Administration $100,000, and Info Tech Operations $20,000. $ (15,231,499.00) $ (15,826,941.00) $ (15,724,941.00) $ 102,000.00 0.64% $ 13,205,900.00 $ 13,511,853.00 $ 13,334,853.00 $ (177,000.00) -1.31% Unfav. Property Tax Levy based on actual collections ($475,345). Partially offset by Local Comm Stabalization Share, $271,100. Fav Income from Investments $35,000. $ (2,022,599.00) $ (2,315,088.00) $ (2,390,088.00) $ (75,000.00) -3.24% TOTAL NET INCOME/PLANNED USE OF BALANCE (LOSS)* $ (2,022,599.00) $ (2,315.088.00) $ (2,390,088.00) $ (75,000.00) TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 94,216,006.08 91,825,918.08
COUNTY OF OAKLAND FY 2017 THIRD 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 $41,881,166.00 $41,883,085.00 838,779,985.00 ($3,103,100.00) -7.41% Unfav - Reimbursement Salaries ($3,501,000) due to unallocated payroll charges for turnover and vacant positions offset in Salaries and Fringes, Fav - Equipment Rental $300,000 due to under estimate of billable equipment charges. Fav - Maintenance Contracts $46,300 a result of increased revenue for Supervisory Control and Data Acquisition (SCADA) system maintenance charges. Fay - Vehicle Rental $31,000 due to under estimate of billable vehicles hours and a third quarter budget amendment to transfer seven (7) Pontiac Fund owned vehicles to Drain Equipment Fund leased vehicles. Fay - Reimbursement Building Space Cost $20,600 due to a rate adjustment for the maintenance and operations of the Dixie Highway Building. Outside 161,000.00 161,000.00 161,000.00 $0.00 0.00% Total Revenue 42,042,166.00 42,044,085.00 38,940,985.00 (3,103,100.00) -7.38% OPERATING EXPENSES 42,901,860.00 42,180,975.00 38,550,572.00 3,620,403.00 8.58% Fey - Salaries $2,101,000 and Fringes $1,400,000 due to turnover and vacant positions. Fav - Depreciation $379,400 primarily due to change in implementation date to FY 2018 for the Supervisory Control and Data Acquisition (SCADA) system common to all project. Fav - Indirect Cost $100,584 due to a roll forward credit reducing the expense. Fav - Property Taxes $3,500 due to the tax exempt status now in effect on the Dixie Highway Building. Fav - Office Supplies $6,000, Natural Gas $3,000 and Electric Service $2,000 a result of actual spending less than budget projection. Unfav - Material and Supplies ($200,000) and Drain Equipment Materials ($11,500) the result that the budget needs to be updated for these items being tracked through Collaborative Asset Management System (CAMS). 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 was updated with the FY 2018-FY 2020 County Executive Recommended Budget
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT INTERNAL SERVICE FUND WATER RESOURCES COMMISSIONER ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES NET INCOME (LOSS) BEFORE (859,684.00) (136,890.00) 360,413.00 517,303.00 -377.90% Unfav - Info Tech Managed Print Services ($2,660) the result of increased billing for two additional copy machines. Unfav - Expendable Equipment Expense ($25,350), Drain Equipment ($20,000), Equipment Repair Motor Vehicle ($15,000), Travel and Conference ($3,000), Personal Mileage ($2,500), Towing and Storage Fees ($2,500) and Garbage and Rubbish disposal ($2,300) the result of increased activity. NON-OPERATING REVENUE/(EXPENSE) 821,583.00 821,583.00 888,483.00 66,900.00 8.14% Fav - Income from Investment $58,000 the result of fund earning a return due to an improved cash balance. Fay - Capital Contributions State Grants $7,400 due to SAW Grant hardware and software eligible for grant reimbursement. Fay - Interest Expense $2,000 a result of the decreasing principal balance and decrease in variable interest rate related to the Drain Equipment Storage Building. TRANSFER IN 0.00% TRANSFERS (OUT) 0.00% NET REVENUES OVER (UNDER) ($38,101.00) $684,693.00 $1,268,896.00 $684,203.00 EXPENSES TOTAL NET POSITION - BEGINNING 15,107,614.30 TOTAL NET POSITION - ENDING $16,376,510.30
Inside Revenue 3,623,171,00 3,623,171.00 3,286,571.00 (336,600.00) -9.29% Unfav. due to rebills to departments lower based on actual premiums paid, offset by decrease in expense. Total Operating Revenue 5 3,633,568.00 $ 3,533,568.00 $ 3,296,968.00 $ (336,600.00) -9.26% COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT INTERNAL SERVICE FUND RISK MANAGEMENT ADOPTED BUDGET AMENDED BUDGET FY 2017 FORECAST VARIANCE FAW(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES LIABILITY INSURANCE FUND 67700 OPERATING REVENUES: Outside Revenue $ 10,397.00 $ 10,397.00 $ 10,397.00 $ OPERATING EXPENSE 5 3,593,374.00 5 3,747,824.00 $ 3,440,224.00 $ 307,600.00 8.21% - Fay. Insurance $362,412 due to actual premiums less than expected due to insurance market fluctuations, partially offset by decrease in revenue and Motor Pool $7,071 due to vehicle being fully depreciated. Unfav. Indirect Cost ($52,159) due to actual charges determined after budget finalization, CLAIMS PAID 1,178,895.00 1,178,895.00 1,599,995.00 (421,100.00) -35.72% Unfav. due to timing and claims amounts more than anticipated with budget, TOTAL OPERATING EXPENSES 5 4,772,269,00 $ 4,926,719,00 $ 5,040219.00 $ (113,500.00) -2.30% OPERATING INCOME (LOSS) (1,138,701.00) (1,293,151.00) (1,743,251.00) (450,100.00) 34.81% 150,000.00 160,000.00 111,000.00 (39,000.00) -26.00% Unfav. due to lower than expected available cash balance. NON-OPERATING REVENUE (EXPENSE) NET REVENUES OVER/(UNDER) EXPENSES $ (988,701.00) $ (1,143,151,00) (1,632,251.00) $ (450,100.00) 6,431,731.14 TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 4,799,480.14
EMPLOYEE RECOGNITION EMPLOYEE BENEFITS UNIT FLEX BENEFIT PLAN WELLNESS UNIT FRINGE BENEFITS TUITION REIMBURSEMENT RETIREMENT HEALTH SAVINGS GROUP LIFE INSURANCE SOCIAL SECURITY 296,700 996,000 100,000 515,200 99,200 460,000 2,929,000 450,000 18,300,000 296,700 996,000 100,000 615,200 99,200 460,000 2,929,000 450,000 16,300,000 296,700 1,032,100 100,000 638,000 99,200 477,200 2,929,000 450,000 16,650,000 MEDICAL INSURANCE 33,952,500 PRESCRIPTION COVERAGE INSURANCE 9,921,000 DENTAL INSURANCE 3,174,000 VISION INSURANCE 190,500 DISABILITY INSURANCE 3,046,000 WORKERS COMPENSATION 3,267,400 UNEMPLOYMENT COMPENSATION 500,000 INVESTMENT INCOME 305,300 EXT - FLEX BEN MEDICAL - EMPLOYEE 6,200,000 EXT - MEDICAL INSURANCE 180,000 EXT - PRESCRIPTION DRUG REBATES 850,000 EXT - DENTAL INSURANCE 16,000 EXT VISION INSURANCE 1,600 EXT - FLEX BEN LIFE INSURANCE 400,000 33,952,500 9,921,000 3,174,000 190,500 3,046,000 3,267,400 600,000 305,300 5,200,000 180,000 850,000 16,000 1,500 400,000 35,472,500 10,886,000 3,670,200 343,300 3,028,600 3,463,600 500,000 420,300 5,200,000 180,000 1,211,400 16,000 1,500 423,600 COUNTY OF OAKLAND FY2017 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND ADOPTED AMENDED FY2017 VARIANCE 'FRINGE BENEFITS FUND 67800 BUDGET BUDGET FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUE RETIREES MEDICAL - VEBA DEBT RETIREMENT ADMINISTRATION RETIREMENT ADMINISTRATION - PTNE DEFERRED COMPENSATION-MATCH DEFINED CONTRIBUTION PLAN DEFINED CONTRIBUTION PLAN - PTNE EMPLOYEE IN-SERVICE TRAINING 34,001.200 25,953,641 30,764,741 4,811,100 18.54% Favorable due to actual revenue more than budget projection after reduction of retirement rate effective vvith 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,172,700 126,900 4.17% Favorable due to projected revenue more than budget projections. 200,000 200,000 236,400 36,400 15.20% Favorable due to projected revenue more than budget projections. 1,400,000 1,400,000 1,296,900 (103,100) -7.36°k - Unfavorable due to projected revenue less than budget projections. Offset by favorable expense. 17,250,000 17,280,000 17,830,000 550,000 3.18% - Favorable due to projected revenue more than budget projections - increase of new hires who participate in the Defined Contribution Plan. Partially offset by unfavorable expense. 205,000 205,000 205,000 - 0,00% 1,172,700 1,172,700 920,600 (252,100) -21.50% - Unfavorable due to projected revenue less than budget projections. Partially offset by favorable Information Technology In-Service Training expense. 0.00% 36,100 3.6020;0. - Favorable due to projected revenue more than budget projections. 0. 22,800 3.71% - Favorable due to projected revenue more than budget projections. 0.00% 17,200 03..704% - Favorable due to projected revenue more than budget projections. 0% 0.00% 350,000 2.15% - Favorable due to projected revenue more than budget projections - an increase in new hires. Partially offset by unfavorable related expense. 1,520,300 4.48% - Favorable due to projected revenue more than budget projections. 965,000 9.73% - Favorable due to projected revenue more than budget projections. 496,200 15.63% - Favorabie due to projected revenue more than budget projections. 152,800 80.21% - Favorable due to projected revenue more than budget projections. (17,400) -0.57% - Unfavorable due to projected revenue less than budget projections. 196,200 06..0000:2 - Favorable due to projected revenue more than budget projections. 115,000 37.67% - Favorable due to projected revenue more than budget projections. - 0.00% - 0.00% 361,400 42.52% - Favorable due to projected revenue more than budget projections, 0.00% 0.00% 23,600 5.90% - Favorable due to projected revenue more than budget projections. Partially offset by unfavorable group fife insurance expense. EXT - FLEX BEN DENTAL INSURANCE EXT - FLEX BEN VISION INSURANCE EXT - FORFEITURE OF DEPOSIT & DC PLAN 115.000 118,000 115,000 118,000 115,000 118,000 311,200 311,200 0.00% 0.00% 0.00% - Favorable due to forfeiture of non-vested International City Management Association (ICMA) accounts. EXT -TRAINING 0,00% EXT - OTHER REVENUE -10MA REBATES 10,000 10,000 10,000 0.00% TOTAL REVENUE 140,798,000 132,750,441 142,470,041 9,719,600 7.32%
460,000 2,929,000 650,000 16,300,000 38,715,000 10,691,000 3,280,000 310,000 3,046,000 3,261,836 500,000 215,300 78,000 241,000 385,000 18,500 100,000 141,184,941 342,200 3,004,600 870,200 16,596,300 42,876,500 10,422,700 3,163,000 289,100 3.146,200 2,112,936 350,000 215,300 20,000 220,000 450,000 18,500 54,600 143,568,941 [FRINGE BENEFITS FUND 67800 ADOPTED AMENDED BUDGET BUDGET COUNTY OF OAKLAND FY2017 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND FY2017 VARIANCE FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING EXPENSE RETIREES MEDICAL - VEBA DEBT PR1NC. RETIREES MEDICAL - VEBA DEBT INT/AGING RETIREMENT ADMINISTRATION DEFERRED COMP-COUNTY PMTS (MATCH) DEFINED CONTRIBUTION PLAN DEFINED CONTRIBUTION PLAN - PTNE EMPLOYEE 1N-SERVICE TRAINING EMPLOYEE IN-SERVICE TRAINING - OTHER 1N-SERVICE TRAINING - INFO TECH EMPLOYEE BENEFITS UNIT 23,020,000 23,020,000 23,020,000 10,981,200 10,981,200 10,981,200 3,245,800 3,234,128 3,234,128 1,400,000 1,834,500 1,296,900 17,280,000 17,280,000 17,737,800 0.00% 0.00% 0.00% 537,600 29.30% - Favorable due to projected costs less than budget projections. Partially offset by unfavorable revenue. (457,800) -2.65% - Unfavorable due to actual costs more than budget projections - increase of new hires who participate in the Defined Contribution Plan. Offset by favorable revenue. 205,000 205,000 205,000 - 0.00% 560,700 551,674 551,674 0,00% 262,000 262,000 262,000 0,00% 350,000 350,000 315,000 35,000 10.00% - Favorable due to projected costs less than budget projections. Offset by in service training revenue. 996,000 985,004 882,804 102,200 10.38% - Favorable due to Professional Services, Printing, Travel and Conference, Postage, and Office Supply costs being less than budget projections. 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 0.00% 112,800 18.42% - Favorable due to Wellness Screening, Special Event Program, and Printing costs being less than projected budget. 57,900 19.84% - Favorable due to one undertilled position and Special Even Program and Travel and Conference costs being less than projected budget 0,00% 117,800 25.61% - Favorable due to fewer tuition reimbursement submissions compared to budget projection. (75,800) -2.59% - Unfavorable due to actual costs more than budget projections - increase of new hires who participate in the Retirement Health Saving Plan. (20,200) -2.38% Unfavorable due to costs higher than budget projection. Offset by favorable Ext- Flex Ben Life Insurance revenue. (296,300) -1.62% - Unfavorable due to projected costs more than budget projections - increase in new hires. Offset by favorable revenue. (4,161,500) -10.75% - Unfavorable due to actual costs more than budget projections. 268,300 2,51% - Favorable due to actual costs less than budget projections. 117,000 3.57% - Favorable due to actual costs less than budget projections. 20,900 6.74% - Favorable due to actuat costs less than budget projections. (100,200) -3.29% - Unfavorable due to costs more than budget projections. 1,148,900 35.22% - Favorable due to one vacant position and the Workers Compensation Claims costs less than budget projections. 150,000 30.00% - Favorable due to projected costs less than budget projections. 0.00% 58,000 74.36% - Favorable due to projected costs less than budget projections. 21,000 8.71% - Favorable duet° projected costs less than budget projections. (65,000) -16.88% - Unfavorable due to projected costs more than budget projections. 0.00% 45,400 45.40% - Favorable due to actual charges developed after budget finalization. (2,384,000) -1.69% 100,000 615,200 296,700 99,200 100,000 612,497 291,789 96,513 100,000 499,697 233,889 96,513 460,000 2,929,000 850,000 16,300,000 38,715,000 10,691,000 3,280,000 310,000 3,046,000 3,267,400 500,000 215,300 78,000 241,000 385,000 18,500 100,000 140,798,000 NET REVENUE OVER/(UNDER) EXPENSES 0.00 (8,434,500) (1,098,900) 7,335,600 63,961,378 62,862,478 TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING
COUNTY OF OAKLAND FY 2417 THIRD QUARTER REPORT ENTERPRISE FUNDS CENTRAL SERVICES ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OAKLAND COUNTY INTERNATIONAL AIRPORT (56500) OPERATING REVENUE $4,415,400.00 $4,415,400.00 $4,636,100.00 $220,700.00 5.00% - Fay. T Hangar Rental $112,000 due to an increase in the number of T Hangar's being leased, Land Lease $96,000 due to higher than anticipated land leases, Aviation Gas $35,000 due to higher than anticipated gas concessions, and Car Rental Concessions $15,000 due to increased car rentals: Unfav. Miscellaneous ($37,300) due to Airport Expo not held this Fiscal Year. OPERATING EXPENSE 6,765.378.00 6,726,178.00 6,456,073,00 270,100.00 4.02% - Fay. Personnel $231,900 due to two under filled positions, one employee retirement, non-use of Emergency Salaries, and less than expected hospitalization/retirement costs, Also fav. Insurance Fund expense $52,000 due to market fluctuations, Grounds Maintenance $49,000 due to less than anticipated snow removal services, Gasoline Charges $18,000 due to lower gasoline costs, Advertising $13,000 due to Airport Expo not held this fiscal year, Electrical Services $11,700 due to lower energy costs, Metered Postage $7,700 due to no mailings for the Airport Expo this fiscal year, Equipment Maintenance $6,800 due to less than expected maintenance costs, Grounds Supplies $6,500 due to less than expected grounds supplies purchases; Unfav. Professional Service ($66,000) due to various services, Runway and Taxiway Repairs 8(25,500) due to asphalt repairs on runway at Oakland/Southwest Airport and pavement crack filling at Oakland International Airport, Indirect Costs ($22.000) due to actual charges being developed after budget finalization, and Electrical Supplies ($13,000) due to higher than expected electrical supplies purchases. NET OPERATING INCOME (LOSS) ($2,349,978.00) ($2,310,778.00) ($1,819,978.00) $490,800.00 -2124% NON-OPERATING REVENUE (EXPENSE) 245,000.00 245,000.00 233,800,00 38,800.00 15.84% Fay. Income from Investments $38,800 due to higher than expected interest rates. TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS ($2,104,978.00) ($2,065,778.00) $ (1,536,178.00) $529,600.00 TRANSFERS IN CAPITAL CONTRIBUTION 0.00 0.00 0.00 $0.00 0.00% TOTAL NET INCOME (LOSS) ($2,104,978,00) ($2,065,778.00) $ (1,536,178.00) $529,600.00 TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING $ 77,525,805.00 $ 75,989,627.00
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS CENTRAL SERVICES ADOPTED AMENDED FY2017 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES MOTOR POOL FUND 66100 OPERATING REVENUE: Outside Revenue $ 112,000.00 $ 112,000.00 135,000.00 $ 23,000.00 20.54% - Fav. Ext. Productive Labor Rev $12,100 due to higher than expected service levels associated with City, Village, and Township vehicle repairs, Ext Other Revenue $10,900 due to greater than anticipated restitution and subrogation payments. Inside Revenue Total Revenue 8,154,424.00 8,261,803.00 8,266,424.00 8,373,803.00 7,891,303.00 (370,500.00) 8.026,303.00 (347,500.00) -4.48% - Unfav. Gasoline, Oil & Grease Charges ($485,000) due to decreased fuel cost (partially offset by a favorable expenditure for Gasoline Charges), Parts and Accessories ($15,600) due to newer vehicles needing less repairs; partially offset by favorable expenses. Fay. Leased Equipment $89,400 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, Productive Labor $40,700 due to new vehicle builds and vehicles repairs handled in-house. OPERATING EXPENSE 8,986,941.00 9,027,013.00 8.725,336.00 301,677.00 3.34% - Fay. Gasoline Charges $314,400 due to decreased fuel cost (offset by unfavorable Gasoline, Oil, Grease Charges revenue), Parts and Accessories $71,300 due to newer vehicles having fewer repairs and a reduction in new police car builds as well as a reduction in equipment purchased this fiscal year, Personnel $64,177 due to underfilled positions and lower than expected Retirement and Hospitalization costs and Insurance premiums $40,900 due to insurance market rate fluctuations. Unfav. Depreciation ($133,800) 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, Adj Prior Years Exp ($13,700) due to timing of invoice. Insurance Reserve Expense ($10,200) due to higher costs associated with garage-owned vehicles involved in accidents. and Auction Expense ($5,300) due to higher than expected expenses associated with vehicles sold at auction. OPERATING INCOME (LOSS) (720,517.00) (653,210.00) (699,033.00) (45,823.00) NON-OPERATING REVENUE 385,000.00 385,000.00 471,800.00 86,800,00 22.55% - Fay. Gain on Sale of Vehicles $100,500 due to proceeds from vehicles sold at (EXPENSE) auction. Unfav. Income from Investments ($13,700) due to lower than expected interest rates. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS (335,517.00) (268,210.00) (227,233.00) 40,977.00 TRANSFERS IN! (OUT) 24,563.00 207,396.00 207,396.00 NET REVENUE OVER/(UNDER) EXPENSES (PLANNED USE OF FUND BAL.)* $(310,954.00) $ (60,814.00) $ (19,837.00) $ 40,977.00 9,094,055.00 TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING $9,074,218.00
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT INTERNAL SERVICE FUND FACILITIES MANAGEMENT ADOPTED BUDGET --------------- FACILITIES MAINTENANCE & OPERATIONS (#63100) AMENDED BUDGET FY 2017 ACTUAL VARIANCE FAV/{UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUES: Outside Revenue Inside Revenue Total Revenue OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN TRANSFERS OUT NET REVENUES OVER(UNDER) EXPENSES* TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING $ 27,958,969.00 $27,669,622.00 $ 25,619,622.00 $ 2,050,000.00 $ (1,947,029.00) $ (1,657,682.00) $ 507,318.00 $ 2,165,000.00 - $ 818,189.00 $ 818,189.00 (24,563,00) $ (24,563.00) $ (697,063.00) $ (672,500.00) (1,871,592.00) $ (1,582,245.00) $ 748,444.00 $ 2,330,689.00 $ 9,808,349.70 $ 10,556,793.70 7,41% -Fav. Sublet Repairs $800,000 due to more efficient management of building maintenance; Natural Gas $525,000 due to purchasing natural gas from third party sources, mild weather conditions and lower market prices; Salaries and Fringe Benefits $500,000 due to underfilled/vacant positions; Electrical Service $300,000 due to lower-cost third-party contracts and savings from FM&O energy conservation initiatives; Water & Sewage Charges $125,000 as well as Material and Supplies $75,000 based on actual usage; Security Supplies $100,000 due to the use of alternative sources of funding (security enhancement). Partially offset by unfav. Info Tech Development ($100,000) due to Collaborative Asset Management System (CAMS) mobile upgrade, infrastructure, GIS, and building management system; Custodial Supplies ($75,000) based on actual usage; Info Tech Operations ($50,000) due to AutoCAD and Kronos software maintenance along with one-time IT equipment purchase; Grounds Supplies ($50,000) as well as Maintenance Supplies ($25,000) based on increases of services performed internally; Ad) Prior Years Exp ($45,000) due to adjustment of sewage charges; Telephone Communications ($30,000) due to telephone upgrades. 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. 464,073.00 $ 464,073.00 $ 524,073.00 $ 60,000.00 12.93% - Fay. Ext - Other Revenue primarily due to more than anticipated Outside Agencies Maintenance Charges for Oakland Community Health Network (OCHN). 25,547,867.00 25,547,867.00 25,602,867.00 55,000.00 0.22% Fay. Maintenance Dept Charges based on Department requests. $ 26,011,940.00 $26,011,940.00 $ 26,126,940.00 $ 115,000.00 0.44% 100,000,00 $ 100,000.00 $ 120,000.00 $ 20,000.00 20.00% Fav. Income from Investments due to higher than anticipated rate of return on investments. *Please note that in the Adopted Budget (line-item book) this is budgeted as 'Planned Use of Fund Balance' in the revenue category.
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS! ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET AMENDED BUDGET FY 2917 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - Operations (83600) 28.70% Fay. Enhanced Access Fees $554,800, Managed Print Services $57,600 and Deferred Land File Tax $20,900 due to higher than anticipated usage. Offset by unfavorable Outside Agencies ($112,800) and Reimb Equalization Services ($4,300) due to reduction in external customer requests. -5.20% - Untav. OC Depts Development Support & Non Governmental Development ($1,500,400) and OC Depts Operations & Non Governmental Operations ($40,000) due to rates remaining at prior year levels and limited resources available to complete development due to vacancies. Offset by favorable Prior Year Adjustments $182,800 due to prior year expense of equipment purchases. Also, CLEMIS Operations $52,800 due to actuals higher than anticipated and Commission Contracts $11,500 for G2G Marketplace Vendor Annual Revenue Share from Kronos. OPERATING REVENUES: Outside $1,794,428.00 $1,798,856.00 $2,315,066.00 $516,200.00 Inside 24,1357,948.00 24,889,158,00 23,595,858.00 (1,293,300.00) TOTAL OPERATING REVENUE $26,652,376.00 $26,688,024.00 $25,910,924.00 ($777,100.00) -2.91% OPERATING EXPENSES $36,391,110.00 $30,757,745,00 $35,052,945.00 $1,704,800.00 4.64% - Fay. Salaries & Fringes $1,614,200 due to vacant positions; Expendable Equipment $639,300 for equipment replacement; Depreciation $519,900 for IT capital projects in progress not fully operational; Equipment Maintenance $296,000 due to lower than anticipated hardware maintenance costs; Indirect Cost $184,400 due to actual charges being developed after budget finalization; Maintenance Contracts $113,400 due to office equipment purchases that are still under warranty; Communications $104,800 due to rate reductions; Printing $63,800 and Mileage $6,300 due to less anticipated use. Offset by unfav. Professional Services ($985,700) a budget amendment is recommended to adjust the account for projects previously approved in prior year-, Software Maintenance ($492,100) due to timing of software support; Charge Card Fees ($325,600) for increased credit card activity; Supplies ($27,300) and Travel ($6,600) based on usage. $927,700.00 (2,800.00) -2.65% Unfav, Interest Income due to lower rates and cash balance than anticipated. 55,100.00 1.35% Fay due to completion of the following projects: Info Tech Reference Archietecture Project-Computer Room Reconfigeration project per 12128116 EMO Project Work Order Closure memo. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS ($9,738,734.00) ($10,069,721,00) ($9,142,021.00) NON-OPERATING REVENUE 105,500,00 105,500.00 102,700.00 TRANSFERS IN 3,906,676.00 4,298,069.00 4,356,169.00 TRANSFERS (OUT) CAPITAL CONTRIBUTION 325,000,00 (39,540.00) 325,000.00 (39,540.00) 3,334,000,00 3,009,000.00 0.00% 0.00% Fav Capital Contributions revenue recognized for building authority capital projects for IT. NET REV OVER(UNDER) EXP* ($5,401,558.00) ($5,380.692.00) ($1,388,692.00) $3,992,000.00 TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING 26,406,584.94 $25 017 892.94 "Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category.
$2,863,908.00 ($9,510.00) 30,000.00 $909,790.00 $889,400.00 $20,390.00 $12 083.00 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 TOTAL NET POSITION - ENDING $2,872,215.00 ($17,917.00) 30,000.00 ($19,900.00) ($19,900.00) 9,300.00 900,000.00 -0.69% Unfav. Expendable Equipment ($18,100) due to equipment replacements higher than anticipated; Professional Services ($13,200) due to higher than anticipated contract rates and Equipment Maintenance ($4,100) due to maintenance costs being higher than the budget projection. Offset by fay. Tower Charges $12,000 due to decreased pager usage and Depreciation $3,500 based on projected depreciation schedules. 31.00% Fay, 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% $2,883,808.00 ($29,510.00) 39,300.00 900,000.00 4,420,527.07 $5,330,317.07 COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAV/fUNFAV) PERCENT EXPLANATION or SIGNIFICANT VARIANCES Information Technology - Telephone Communications (67500) OPERATING REVENUES: Outside $12,000.00 $12,000.00 $12,000.00 $ 0.00% Inside 2,642,298.00 2,842,298.00 $2,842,298.00 0.00% TOTAL OPERATING REVENUE $2,854,298.00 $2,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.
Information Technology - CLEMIS (53500) OPERATING REVENUES: Outside $4,425,955.00 $4,425,955.00 $4,629,755.00 $203,800.00 4.60% COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Fay. Access Fees Non Oakland $72,200 due to updated law enforcement Full Time Equivalent count used for billing (offset by unfav. Access Fees Oakland ($4,200); CLEMIS Crash $51,000, CLEM'S Citation $44,200 and Crime Mapping $4,200 due to increased usage by Oakland and non-Oakland agencies; Maintenance Contracts $23,700 due to Livesc.an maintenance after warranty and In-Car Terminals External $12,700 for fleet of CLEMIS agencies. Inside 1,839,178.00 1,842,523.00 1,693,723.00 (148,800.00) -8.08% Unfav. Service Fees ($278,100) based on actual billing for Computer Aided Dispatch (CAD) expense charge directly to Radio Fund. Offset by fay. Prior Year Revenue $85,100 due to the timing of CLEMIS Crash invoices billed to customers; OC Dept $32,600 and In-Car Terminals Internal $8,600 due to participation count higher than budget projection. TOTAL OPERATING REVENUE $6,265,133.00 $6,268,478.00 $6,323,478.00 $55,000.00 0,88% OPERATING EXPENSES $10,945,881.00 $10,886,435.00 $9,896,735.00 $989,700.00 9.09% Fey, Depreciation $1,328,000 based on projected depreciation schedules; Salaries & Fringe Benefits $303,700 due to vacancies; Bank Charges $197,600 due to less than anticipated costs for PayPal services for E-Commerce transactions; Internal Services $192,700 primarily due to IT Development based on actual usage; RebilIable Services $50,000 based on actual connectivity costs to Tier 2.5 and 3.0 agencies; Printing $2,000 and Mileage $1,300 based on actual usage. Offset by unfav. Professional Services ($850,700) due to higher than anticipated contractual costs for staffing services; Equipment Maintenance ($188,700) due to cost of repairs; Software Maintenance ($16,000) due to additional software purchases in excess of budget projections; Travel ($13,100) and Supplies ($10,200) due to usage; Indirect Cost ($6,900) due to charges determined after finalization of the budget. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS ($4,680,748.00) ($4,617,957.00) ($3,573,257,00) $1,044,700.00 NON-OPERATING REVENUE 35,000.00 35,000.00 104,600.00 69,600.00 198.86% 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) ($1,624,471.00) $1,114,300.00 TOTAL NET POSITION - BEGINNING 17,904,957.03 TOTAL NET POSITION - ENDING $16,280,486.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.
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS I ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET Information Technology - Radio Communications (53600) AMENDED BUDGET FY 2017 FORECAST VARIANCE FAV4UNFAVI, PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUES: Outside $6,965,000.00 $7,135,000.00 $6,943,200.00 ($191,800.00) -2.69% Unfav. E-911 Surcharge ($204,800) due to decreased volume of users/receipt of 911 surcharge. Offset by fay. Antenna Site Management $8,700 due to updates in rental contracts and Outside Agency Revenue $4,300 due to higher non-emergency agencies than anticipated. Inside 470,788.00 470,788.00 564,288.00 93,500.00 19.66% Fay. Prior Year Adjustment $40,100 due to FY 2015 expenditure accruals not reversed in FY 2016; Parts Access $25,800 reimbursement by participating agencies for equipment replacement Leased Equipment $16,200 due to higher than anticipated non-public users; Productive Labor $6,000 due to Mobile Data Computer repairs for OC Agencies and Refund Prior Years Expenditure $5,200 due to communications expense credits received that relate to FY 2016. TOTAL OPERATING REVENUE $7,435,788.00 $7,605,788.00 $7,507,488.00 ($96,300.00) -1.29% OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN TRANSFERS (OUT) $14,114,896.00 ($6,679,106.00) 180,000.00 285,000.00 $14,147,140.00 $10,691,540.00 $3,455,600.00 ($6,541,352.00) ($3,134,052.00) $3,357,300.00 180,000.00 184,200.00 4,200.00 49,553.00 52,353.00 12,500.00 286,000.00 286,000.00 24.43% Fay. Software Maintenance $1,325,000 due to the timing of the Emergency Services IP Network project Depreciation $1,320,000 based on projected depreciation schedule; Internal Services $301,300 primarily due to Info Tech CLEMIS based on usage; Professional Services $241,300 due to less than anticipated use; Equipment Maintenance 3108,100 due to maintenance costs; Salaries and Fringe Benefits $118,000 due to vacancies; Expendable Equipment $66,300 due to the timing of equipment purchases; Tower Charges $34,600 for tower rental agreements; Travel $86,600, Special Projects $39,000, Utilities $36,300 and Supplies $7,200 due to usage. Offset by unfav. Parts and Accessories (6151,300) due to increased volume of non-billable equipment repairs; Adjust Prior Year Rev ($34,500) to correct for a prior year's accrual adjustment; Communications (T25,600) for connectivity costs for cell tower sites used for coverage enhancements of the Radio system and Indirect Cost ($16,500) due to charges deternined afer finalization of budget. 2.33% Fay, primarily due to Interest Income; higher cash balance than anticipated. 0.00% 0.00% CAPITAL CONTRIBUTION NET REV OVER(UNDER) EXP* TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING 0.00% (S6,213,108.00) (66.025,799.00) (62,651,499.00) $3,374,300,00 38,395,729.87 $35,744,230.87 Please note that in the Adopted Budget (line-item n book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses.
COUNTY OF OAKLAND FY 2017 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS! ENTERPRISE FUND INFORMATION TECHNOLOGY Fire Records Management S3100) ADOPTED BUDGET AMENDED BUDGET FY 2017 FORECAST VARIANCE FAV/(UNFAV1 PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUES: Outside $214,665.00 $214,665.00 $217,405.00 $2,740.00 1.28% Fav, primarily due to Participation Fee Revenue for to the addition of City of Livonia Fire Department. TOTAL OPERATING REVENUES $214,665.00 $214,655.00 $217,405.00 $2,740.00 1.29% OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE 5719,350,00 ($504,655.00) 3,000.00 $709,885.00 ($495,220.00) 3,000.00 $635,667.00 ($418.262.00) 7,350,00 $74,218.00 10.45% Fav. Salaries & Fringes $55,200 due to vacancies; Communications $25,800 due to decrease in connectivity rates; Depreciation $13,300 based on projected depreciation schedule; Expendable Equipment $7,000 due to the timing of equipment purchases made by tech support for maintaining the system; Software Maintenance $5,200 due to decrease in maintenance costs and Travel $5,000 due to less than anticipated USE, Offset by unfav. overall Internal Services ($37,300) primarily due to IT Development ($32,000) and IT Operations ($5,100) based on actual usage. $76,958.00 4,350.00 145.00% Fay, primarily clue to Interest Income: higher cash balance than anticipated. TRANSFERS IN 451,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 (539,943.00) ($30,478.00) $50,830.00 $51,308.00 1,369,874.24 $1,420,704.24 "Please note that in the Adopted Budget (line-item book) this is budgeted as "Manned use of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses.
2017 UNCOLLECTABLE HOME IMPROVEMENT LOANS
COMMUNITY DEVELOPMENT BLOCK GRANT
CASE #
5258
5199
5154
4910
4301
4483
4116
4010
3686
3583
3657
5235
3208
3125
2411
5376
5337
5306
3820
6382
5807
5968
5946
3145
5846
5624
Total
04/17-07/17
Total Write offs: $265,303.17
BALANCE DUE
6,915.00
13,085.00
12,200.00
13,378.00
9,900.00
9,708.00
9,900.00
9,900.00
5,450.00
8,089.34
3,686.00
12,738.00
4,427.07
4,370.00
5,785.00
3,298.00
12,704.00
13,118.00
4,279.69
15,199.52
15,391.75
14,789.17
11,269.98
7,680.00
24,505.00
13,536.65
265,303.17
AIRPORT FUND #56500 LATE FEE REVERSALS FY2017 MONTH DATE AMOUNT AIR # CUSTOMER NAME REQUESTED BY REASON OCT 2016 NOV 2016 DEC 2016 Michelle Stover Michelle Stover FEB 2017 12/1/2016 60.00 AIR00003028 VARCOE, CASSANDRA 2/9/2017 23.00 X[100001)487 FIND PLANE CO Customer came into office on 12-1-16 with cash for Nov 2017 Rent Customer's credit card declined in auto-pay. Customer was out of country on honeymoon. He wasn't aware the card had declined and a payment was missed. Customer has been a prepay acct since 2006. The customer forgot to make prepay amount in Jan 2017. JAN 2017 1/15/2017 24.20 Ai R00000272 CB AIR Pam VanNest Pam VanNest Michelle Stover Pam VanNest Pam VanNest Michelle Stover 3/16/2017 26.00 AIR00001886 JAMAL FARHAT 3/16/2017 50.00 AIR00000108 AV8R'S 3/1/2017 26.00 AIR00002943 AGRI-FLIGHT 5/15/2017 45.00 AIR00001461 B & C PROPERTY GROUP 5/4/2017 285.20 A1R00000145 BRIAN BARR MAR 2017 APR 2017 MAY 2017 JUNE 2017 Customer prepays every year. He forgot it was time again. Customer wasn't given discount rate on prepay. Customer didn't receive any of Michelle Stover's ret'd phone calls regarding the Airport's 10 day cancellation policy Customer came in and paid one year in advance after the end of February 2017. Customer was also out of town. Customer has been prepaid for many years and forgot prepay payment was due in April 2017. Customer had a payment that OCIA didn't receive in 2016. Due to the missing payment, customer was always behind one month's rent. Late fees were being assessed each month since 7-1-16. 539.40 TOTAL No late fees reversed for that month Requested by:
Budget Transaction ,OCSOCAppitiVal Center Date Date (if >$1 000) GLG 07125/16 n/a ADD 09/27/16 n/a IND 04/17/17 n/a SPG 06/04/17 n/a OAKLAND COUNTY PARKS & RECREATION COMMISSION FY2017 Uncollectible Debt Write-offs April 1, 2017 June 30, 2017 Name(Last.First)OR lest four Aigif*Of credit cTd Avagian, Harry L. Otto, Jason Oliver, Matt Trumble, Robert Type of Case Number! Debt* (if credit card) Accounts Receivable n/a Accounts Receivable nta Accounts Receivable n/a Accounts Receivable n/a • Description of Revenue Owed NSF check fee Camping Day Use Fees Greens Fees/Cart MonthAMOUnt:::: :,WrjttentOff: 25.00 04/17 15.00 04117 37.00 05/17 60.00 06/17 Total 157.00 * Uncollectible NSF checks of $100 or more are referred to Oakland County Corporation Counsel. Oakland County Fiscal Services Policy: If it is determined that a receivable is uncollectible, then amounts up to $1,000 may be written off by approval of the manager of Fiscal Services. All write-offs shall be reported to the Board of Commissioners with the quarterly forecast report. Write-offs in excess of $1,000 require Board of Commissioners' approval. Authorized by:
f0014kOW Environmental Health 1025168355 1336331 Environmental Health 9/12/2016 $ (64.00) 7912 n/a 6/17 2593 MSU Extension Workshop 1025023992 1306287 MSU Extension Workshop 9/12/2016 n/a $ (4650) 6/17 INFORMATION TECHNOLOGY FY 2017 Uncollectible Debt Write-offs April 1, 2017 -June 30, 2017 TOTAL $ (110.50) • Uncaiiectible NSF checks of $100 or more are referred to Oakland County Corporation Counsel. Oakland County Fiscal Services Policy: if it is determined that a receivable is uncoflectible, then amounts up to $1,000 may be written off by approval of the inarrager of Fiscal Services. All write-offs shall be reported to the Board of Commissioners with the quarterly forecast report. Write-offs in excess of $1,000 Authorized by:
Department of Health and Human Services Oakland County Children's Village Donation Tracking : Donation Period April 2017 to June 2017 Date: Donor: Cash/Check: Items: Estimated Value: University Presbyterian Church Frozen Birthday Cakes (3) Months $495.00 4/7/2017 Waterford Senior Center Yarn - 3 Bags $5.00 4/7/2017 Metro North Credit Union Jeans-125 prs. & Recreation Items $1,500.00 4/10/2017 Sweet Dreams for Kids 15 Pillow Cases $75.00 4/10/2017 Holy Spirit & St Mary Parishes 140 Filled Easter Baskets $1,400.00 4/13/2017 Scott Guzzy 8 T-shirts, 6 Books $25.00 4/13/2017 St William Parish 16 Filled Easter Baskets $160.00 4/19/2017 Crowne Plaza Hotel Staff 28 Arm/Wrist Band Radios $228.48 4/20/2017 Patrice Godfrey 7 Bags Used Clothing $200.00 4/26/2017 Datsun Doctor Magazines For Lobby $10.00 4/26/2017 Daisy Troop 76408 Care Bags Of Toiletry Items $50.00 5/1/2017 Children's Village Foundation Art Program For Mandy's Place Residents $1,640.00 5/9/2017 Girl Scout Troop 71751 Girl Scout Cookies $115.00 5/11/2017 Greg Moss Magazines $5.00 5/16/2017 Sweet Dreams for Kids 15 Pillow Cases $75.00 5/31/2017 Rebecca Lopez Clothes, Coats & Games $200.00 6/6/2017 Datsun Doctor Magazines For Lobby & Books-Mandy's Place $20.00 6/7/2017 Waterford Public Library Misc Yarn $60.00 6/8/2017 Roxanne DeGriselles Clothing $125.00 6/12/2017 Tammy Jones Clothing $200.00 6/12/2017 St. Mary of The Hills CASH For Resident Birthday Gits $72.00 6/14/2017 Waterford Public Library New and Used Yarn $20.00 6/16/2017 Ann Marie Eliakis Craft Supplies, Books, & Wrapping Paper $15.00 6/20/2017 Sweet Dreams for Kids 15 Pillow Cases $75.00 6/26/2017 T. Brune Clothing Drive Items $250.00 6/29/2017 James and Roma Honer 3 Bags Used Clothing $25.00 6/30/2017 Susan Ross 1 Bag Used Clothing $20.00 6/30/2017 Ethan Beyer & Family Air Hockey & Fuse Ball Table $5.00 Total: $7,070.48 IAChildVil\Clerical\Billing\Donations\FY17 Donation Tracking Sheet.xlsx
Animal Shelter and Pet Adoption Center
P1 2017 3rd Quarter Report For Contributions (Donations)
April 1, 2017 -June 30, 2017
Date Description Amount
1-Apr-2017 Animal Shelter And Pet Adoption Center $49.37
1-Apr-2017 Pehrson $50.00
3-Apr-2017 Hanson $25.00
3-Apr-2017 Hume $50.00
3-Apr-2017 Mudd $5.00
3-Apr-2017 Smith $100.00
6-Apr-2017 Animal Shelter And Pet Adoption Center $43.30
6-Apr-2017 Trask $78.00
6-Apr-2017 Cosgrove $330.00
7-Apr-2017 Fleishans $25.00
8-Apr-2017 Troop 71585 $300.00
10-Apr-2017 Byrd $2.50
10-Apr-2017 Tatus $50.00
11-Apr-2017 Little $5.00
11-Apr-2017 Animal Shelter And Pet Adoption Center $65.40
12-Apr-2017 Bobbitt $30.00
12-Apr-2017 Husch $10.00
14-Apr-2017 Animal Shelter And Pet Adoption Center $78.00
14-Apr-2017 Ostheimer $20.00
14-Apr-2017 Lempert $10.00
15-Apr-2017 Smith $20.00
17-Apr-2017 Tatus $50.00
20-Apr-2017 Faga $40.00
21-Apr-2017 Animal Shelter And Pet Adoption Center $77.11
24-Apr-2017 Staeuble $15.00
24-Apr-2017 Utterback $20.00
24-Apr-2017 Voisin $25.00
24-Apr-2017 Kimball $100.00
25-Apr-2017 Armstrong $8.50
26-Apr-2017 Nave $400.00
27-Apr-2017 Zembrzucki $2.50
29-Apr-2017 Thomas $1.00
1-May-2017 Animal Shelter And Pet Adoption Center $32.50
2-May-2017 Mudd $5.00
2-May-2017 Animal Shelter And Pet Adoption Center $6.00
3-May-2017 Botha $25.00
3-May-2017 Poissant $181.11
6-May-2017 Animal Shelter And Pet Adoption Center $114.00
6-May-2017 Vangeenhoven $5,00
8-May-2017 Vackaro $100.00
8-May-2017 Zeigler $30.00
Animal Shelter and Pet Adoption Center
FY 2017 3rd Quarter Report For Contributions (Donations)
April 1, 2017 -June 30, 2017
Date Description Amount
9-May-2017 Chapel $40.00
9-May-2017 Smith $2.00
10-May-2017 Mentor Inc. $1,978.25
10-May-2017 Kittell $12.50
10-May-2017 Animal Shelter And Pet Adoption Center $70.00
11-May-2017 Fournier $20.00
12-May-2017 Little $5.00
13-May-2017 Miller $50.00
13-May-2017 Adams $5.00
13-May-2017 Animal Shelter And Pet Adoption Center $60.47
15-May-2017 Animal Control $0.25
15-May-2017 Cousineau-Dovall $5.00
16-May-2017 Animal Shelter And Pet Adoption Center $50.00
16-May-2017 Farnham $50.00
16-May-2017 Kelly $78.00
17-May-2017 Sanders $50.00
17-May-2017 Bembenek $10.25
17-May-2017 Barton $15.00
18-May-2017 Henderson $28.00
22-May-20 7 Staeubie $15.00
23-May-2017 Capen $17.50
23-May-2017 Bonner $25.00
24-May-2017 Harris $50.00
24-May-2017 Animal Shelter And Pet Adoption Center $58.00
30-May-2017 Gillies $28.00
30-May-2017 Sonkiss $50.00
31-May-2017 Animal Shelter And Pet Adoption Center $33.80
31-May-2017 Glenn $6.00
2-Jun-2017 Jerga $100.00
2-Jun-2017 Creech $6.00
2-Jun-2017 Mudd $5.00
3-Jun-2017 Lentz $100.00
5-Jun-2017 Walsh $82.00
5-Jun-2017 Animal Control $0.75
7-Jun-2017 Hammer $12.00
7-Jun-2017 Abbott $15.00
7-Jun-2017 Feld $100.00
9-Jun-2017 Shipley $100.00
Animal Shelter and Pet Adoption Center
FY 2017 3rd Quarter Report For Contributions (Donations)
April 1, 2017 -June 30, 2017
Date Description Amount
12-Jun-2017 Little $5.00
13-Jun-2017 Visser $150.00
13-Jun-2017 Berry $1.50
14-Jun-2017 Sweetomh $3.00
15-Jun-2017 Animal Shelter And Pet Adoption Center $54.00
16-Jun-2017 Williams $25.00
16-Jun-2017 Brohman $25.00
16-Jun-2017 Levine $100.00
17-Jun-2017 Urquhart $52.50
19-Jun-2017 Drafta $20.00
19-Jun-2017 Hoffman $100.00
20-Jun-2017
Revocable Family Trust of Joseph & Anna
Olah $ 500.00
21-Jun-2017 Staeuble $15.00
21-Jun-2017 Propulsion Systems $228.00
21-Jun-2017 Animal Shelter And Pet Adoption Center $33.00
21-Jun-2017 Animal Shelter And Pet Adoption Center $5.00
22-Jun-2017 Schoettley $100.00
22-Jun-2017 Ryba $150.00
22-Jun-2017 McKnight $35.00
22-Jun-2017
Revocable Living Trust Agreement of Lisa
Maria Perazza $ 5,000.00
23-Jun-2017 Malila $50.00
23-Jun-2017 Conway $28.00
24-Jun-2017 Hauser $40.00
26-Jun-2017 Breckenridge $100.00
26-Jun-2017 Birdsall $28.00
28-Jun-2017 Donoghue $50.00
29-Jun-2017 Rose $200.00
29-Jun-2017 O'Hara $50.00
29-Jun-2017 Mehall $50.00
29-Jun-2017 Lack $40.00
29-Jun-2017 O'Hara $50.00
30-Jun-2017 Kidd $10.00
Grand Total $13,216.06
MSU Extension
FY 2017 3rd Quarter Report For Contributions (Donations)
January 1, 2017 - June 30, 2017
Date Description Amount
1/5/2017 eggs, cheese, peppers, onions, mushrooms, spinach tostadas $56
1/5/2017 printing and laminating $54
1/5/2017 paper products, water $4
1/12/2017 bread, eggs, green onion, salt, pepper, garlic, paprika, cinnamon, $35
1/12/2017 printing and laminating $54
1/12/2017 paper products, water $4
1/19/2017 eggs, feta cheese, mushrooms, peppers, onions $44
1/19/2017 printing and laminating $54
1/19/2017 paper products, water $4
1/26/2017
penne pasta, fresh mozzarella cheese, cherry tomatoes, fresh basil,
balsamic vinegar, olive oil, noodles, $55
1/26/2017 printing and laminating $54
1/26/2017 paper products and water $4
2/2/2017 tortillas, shredded cheese, zucchini, onions tomatoes, lettuce, $35
2/2/2017 printing and laminating $54
2/2/2017 paper products and water $4
2/9/2017
bell peppers, whole grain rice, taco seasoning, tomatoes, black beans
grated cheese $40
2/9/2017 printing and laminating $54
2/9/2017 paper products and water $4
2/16/2017 apples, oats, maple syrup, sugar, flour, brown sugar, butter $28
2/16/2017 paper products and water $4
2/16/2017 printing and laminating $54
3/2/2017
rice cakes, eggs, carrots, celery, broccoli, tomatoes, peas, cucumbers,
peppers, grates cheese, blueberries, banans, grapes $50
3/2/2017 paper products and water $4
3/2/2017 printing and laminating $54
3/16/2017
yogurt, whole grain cereal, berries, bananas, peaches, pineapple,
grapes, apples $54
3/16/2017 paper products and water $4
3/16/2017 printing and laminating $54
3/23/2017
pita bread, lettuce, tomatoes, cucumbers, spinach, onion, peppers,
grated cheese, grapes, apples, ranch dressing $52
3/23/2017 paper products and water
3/23/2017 printing and laminating $54
3/30/2017
tortillas, bell peppers, tomatoes, shredded carrots, corn, peas,
spinach, lettuce, purple cabbage, radicchio, cream cheese $48
3/30/2017 paper products and water $4
3/30/2017 printing and laminating $54
4/6/2017
frozen yogurt, berries, whipping cream, sugar, sprinkles, chocolate
syrup, strawberry syrup $61
4/6/2017 paper products and water $4
4/6/2017 printing and laminating $54
Grand Total $1,254
BUdget Center :Projectf Program PrO12;711 Amount otals mParks Park Patron Tuning Your Tot Contribution Recreation Programs & Services Sub-Total $5,103.00 $2,500.00 ..".•ROd.oakeilf.COUrSe..:Park Sub-Total $2,500 00 ... • ••.•:.,•::.::.:. .......• •.... .•:• $25.00 Red..0ak.i.fiattire.CenterSub-TOtali,,, „.......,....: .....:: .:..:.:...:.......:..... ................: ....,...,...:...$25 00 Commemorative Bench - New Composite Bench Gugan Family and Friends FY2017 3rd Quarter Contributions Donations Revenue Grand Total $7,628.00 REC Archery Program Cooperative Agreement REC General Donation - Nestwatch Program REC Nature Center Program $5,000.00 5100.00 $3.00 OAKLAND COUNTY PARKS & RECREATION COMMISSION FY 2017 3rd Quarter Report for Contributions (Donations) - April 1, 2017 -June 30, 2017
Resolution #17264 September 28, 2017
Moved by Hoffman 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, Kochenderfer, KowaII, Long,
McGillivray, Middleton, Quarles, Taub, Tietz, 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).
_53.,4C2-2
1 c't 7
HEREBY APPR6VerHI8 RESOLUTION
CHIEF DEPUTY COUNTY EXECUTIVE
ACTING PURSUANT TO MCL 45.559A (7)
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Lisa Brown, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and
accurate copy of a resolution adopted by the Oakland County Board of Commissioners on September 28,
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 28 th day of September, 2017.
la/1W./
Lisa Brown, Oakland County