HomeMy WebLinkAboutResolutions - 2015.09.17 - 22012MISCELLANEOUS RESOLUTION #15239 September 17, 2015
BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 20'15 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) 2015 Third Quarter Financial Forecast Report has identified several
variances and budget amendments are recommended; and
WHEREAS a budget amendment of $9,500 is recommended to reallocate funds from Sheriff's Corrective
Services Division Prisoner Housing Outside County account to Sheriff's Patrol Services Division Electrical
Service and Water and Sewage Charges accounts for utility service at the Elizabeth Lake Road Storage
Facility (MR #14264); and
WHEREAS a budget amendment of $12,000 is recommended to reallocate funds from Sheriff's
Investigative/Forensic Services Division to Sheriff's Corrective Services Division for drug testing kits for
the East Annex Facility; and
WHEREAS a budget amendment of $28,274 is recommended to reallocate funds from Sheriffs
Corrective Services Division Contracted Services account to Sheriff's Emergency Response and
Preparedness Division to purchase six (6) dispatch workstation licenses due to the Village of Milford
ceasing as a primary Public Safety Answering Point (PSAP); and
WHEREAS a budget amendment of $4,566 for FY 2015 and $788 for FY 2016-2017 is recommended to
correct the allocation of funds for the Sheriff's Patrol Services Division Transfers Out account and Radio
Communications account (MR #15186); and
WHEREAS the Sheriff's Office receipt of forfeiture/enhancement funds were previously posted to a
liability account (deferred revenue) within the General Fund; due to the implementation of GASB 63, the
deferred revenue account can no longer be used for this activity and these funds were moved to separate
restricted funds that will require a transfer to the General Fund for use of the monies. Transfers In from
the various restricted funds in the amount of $50,586 is being recognized for eligible forensic lab, dispatch
and auto theft forfeiture funds; and
WHEREAS a budget amendment is recommended to transfer $3,000 from Sheriff Auto Theft Prevention
Restricted Fund (#21394) to Technical Services Division for travel and conference expense for two
deputies to attend an auto theft prevention conference and seminar in Phoenix, Arizona; and
WHEREAS a budget amendment totaling $10,000 is recommended to reallocate funds from the Circuit
Court General Jurisdictions Civil Mediation Payments account (GL #240201) to the Judicial
Administration's Professional Services account to partially offset expenditures by the Oakland County Bar
Association related to their assistance for case evaluation; and
WHEREAS a budget amendment of $1,587,897 is recommended to allocate funds from Circuit Court to
Friend of the Court (FOC) Fund (#27100) for the FY 2015 FOC Cooperative Reimbursement Program
(CRP) grant; and
WHEREAS a budget amendment totaling $10,000 is recommended to reallocate funds from Emergency
Salaries (Non Departmental) to District Court Visiting Judges account due to additional hours needed
during transition period for vacant Judge position; and
WHEREAS a budget amendment is recommended within the County Clerk Division to reallocate budget
amounts to the proper divisions and programs; and
WHEREAS a budget amendment totaling $850,500 is recommended within the Treasurer's Office to more
accurately reflect the budget with actual revenue activity; and
FINANCE COMMITTEE VOTE:
Ayes: Taub, Matis, Crawford, Middleton (4)
Nays: Woodward, Zack, Quarles (3)
Absent: KowaII and Long
Motion carried on a roll call vote.
WHEREAS a budget amendment of $12,490 is recommended within the Board of Commissioners
Department to recognize revenue in the Fee Income Revenue account and to reallocate funds from the
Travel & Conferences Expenditure account to the Telephone Communications account for the purchase
of iPads; and
WHEREAS a budget amendment of $28,200 is recommended for Corporation Counsel for on-going
maintenance of Freedom of Information Act (FOIA) software and Active Directory licenses; and
WHEREAS a budget amendment of $7,000 is recommended to reallocate funds from Human Resources
Recruitment Expense account to Psychological Testing account to cover testing of new deputy hires; and
WHEREAS a budget amendment is recommended within the Health Division in the amount of $325,000
due to an increase in the cost of vaccines along with an increase in the demand for certain vaccines; and
WHEREAS a budget amendment in the amount of $26,466 is recommended in Economic Development &
Community Affairs for operating revenues and expenditures related to the Fire and Ice Festival; and
WHEREAS a budget amendment in the amount of $15,987 is recommended in Economic Development &
Community Affairs for operating revenues and expenditures related to the Economic Outlook Luncheon;
and
WHEREAS a budget amendment in the amount of $700 is recommended in Economic Development &
Community Affairs for operating revenues and expenditures related to the Tech 248 program; and
WHEREAS a budget amendment in the amount of $20,232 is recommended in Economic Development &
Community Affairs for operating revenues and expenditures related to Oakland Edge event; and
WHEREAS a budget amendment of $1,060,000 is recommended in the Non-Departmental Substance
Abuse Coordinating Agency line item for required payments to Oakland County Community Mental Health
Authority for one-half of Convention Facility Tax revenues earmarked for substance abuse prevention and
treatment programs; and
WHEREAS a budget amendment of $2,262 is recommended for prior year adjustments for FEMA and
Domestic Preparedness Equipment grants; and
WHEREAS a budget amendment totaling $76,568 is recommended to transfer grant match funds
required to close out several Homeland Security grants; and
WHEREAS a budget amendment totaling $1,374,842 is recommended to the Friend Of the Court (FOC)
Fund (#27100) to correct the allocations of funds for the FY 2015 FOC Cooperative Reimbursement
Program (CRP) grant award and recognize additional revenue within 15% of the grant agreement; and
WHEREAS a budget amendment totaling $3,200 is recommended to correct a grant amendment for
FY2015 FOC Access and Visitation grant to reflect increased contract award of $18,500 which is within
15% of the grant agreement; and
WHEREAS an Economic Development - Community Home Improvement amendment is recommended to
accept funds in the amount of $28,581 for the Home Investment Partnership Act Pontiac Fund (#29712)
within 15% of grant agreement; and
WHEREAS a budget amendment of $16,000 is recommended for the Community Corrections
Comprehensive Plan Grant (#27370) to reallocate line item budget to reflect Amendment #1 within 15%
of grant agreement; and
WHEREAS a budget amendment of $92,200 is recommended for the Community Corrections
Comprehensive Plan Grant (#27370) to reallocate line item budgets to reflect Amendment #2 within 15%
of grant agreement; and
WHEREAS a budget amendment of $1,400 is recommended to transfer funding from the Animal Control
Legacy Fund (#21310) to the Animal Control Grant Fund (#29215) to cover the additional cost for two
sided resting platforms in new cat cages; and
WHEREAS a budget amendment is recommended to recognize that the Health Division has received
additional funding from Michigan Department of Community Health (MDCH) through the Comprehensive
Planning, Budgeting, and Contracting (CPBC) Agreement amendment #3 in the amount of $70,531
which is less than 15% of the original agreement required to accept each of the amendments via separate
resolution; and
WHEREAS a budget amendment is recommended to recognize that the Health Division has received
additional funding from MDCH through the Comprehensive Planning, Budgeting, and Contracting (CPBC)
Agreement amendment #4 in the amount of $130,589 which is less than 15% of the original agreement
required to accept each of the amendments via separate resolution; and
WHEREAS a budget amendment is recommended to recognize that the Health Division has received
additional funding from MDCH through the Comprehensive Planning, Budgeting, and Contracting (CPBC)
Agreement amendment #5 in the amount of $31,418 which is less than 15% of the original agreement
required to accept each of the amendments via separate resolution; and
WHEREAS a Fire Records Management System (FRMS) Fund budget amendment is recommended for
$85,000 to reappropriate funds for various projects such as Mobile Data Project, funding is available in
the FRMS Equity; and
WHEREAS the Parks and Recreation Commission recommends a budget amendment totaling
$1,601,123 to reduce the FY 2015 operating budget in an effort to maintain fund balance; and
WHEREAS a Parks and Recreation Fund budget amendment is recommended to transfer Building
Maintenance funds in the amount of $424,235 to various cost centers incurring expenses during the third
quarter of FY 2015; and
WHEREAS a Water Resources Commissioner (WRC) budget amendment is recommended to transfer
$94,000 from various WRC Proprietary funds to the Drain Equipment Fund to pay for the Dixie Highway
Building roof replacement project; and
WHEREAS a Water Resources Commissioner budget amendment is recommended to balance out
Planned Use of Balance and Budgeted Equity Adjustment for various WRC Proprietary funds; and
WHEREAS a budget amendment in the amount of $15,800 is recommended in the Building & Liability
Insurance Fund (#67700) to reallocate funds from Planned Use of Balance to Expendable Equipment due
to the replacement of outdated Automated External Defibrillators (AED) and purchase of additional AEDs
requested by the departments; and
WHEREAS a budget amendment in the amount of $24,200 is recommended in the Building & Liability
Insurance Fund (#67700) to reallocate funds from Planned Use of Balance to Medical Supplies due to the
replacement of expiring AED supplies (batteries and pads) and additional requests from departments;
and
WHEREAS an amendment is recommended for the Information Technology Fund (#63600) to reallocate
funds from equipment maintenance to software maintenance in the amount of $109,000 for Business
Objects upgrade project; and
WHEREAS an Information Technology budget amendment in the amount of $650,000 is recommended to
reappropriate funds for various IT projects such as Medical Examiner's, Ehealth, IT Print Mgt Svcs, Cyber
Security and CAMS, funding is available in the IT Fund Net Assets-Designated for Projects; and
WHEREAS a budget amendment totaling $177,100 is recommended in the Motor Pool Fund (#66100) to
reallocate funds from the Gasoline Charges account to Insurance Reserve Expense and Sublet Repairs
accounts to more accurately reflect the budget with actual expenses; and
WHEREAS an amendment is recommended to Telephone Communications Fund (#67500) to reallocate
funds in the amount of $4,000 to more accurately reflect budget with actual usage; and
WHEREAS Clerk/Register of Deeds (ROD) budget amendment is recommended to transfer funds in the
amount of $41,345 from the Register of Deeds Automation Fund (#21160) to the Project Work Order
Fund (#40400) to cover costs associated with the Lean Process Improvement review, in which ROD staff
have derived and identified a reconfiguration of the ROD office furniture and workspace in order to
improve the efficiency of processing incoming public documents, with project to be initiated after full
Board of Commissioners approval; and
WHEREAS Oakland County International Airport has attempted to collect funds totaling $34,412 from
various customers and recommends the amount to be written off as uncollectable; and
WHEREAS Parks and Recreation received donations totaling $251 for various programs; and
WHEREAS Children's Village received various non-monetary donations valued at $3,611.
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2015
Third Quarter Financial Report.
BE IT FURTHER RESOLVED that $10,000 be transferred in FY 2015 from the Circuit Court General
Jurisdiction's Civil Mediation Payments account (10100-3010301-121150-240201) to the Judicial
Administration's Professional Services account to partially offset the expenditures by the Oakland County
Bar Association related to their assistance for case evaluation.
GENERAL FUND (#10100)
Revenues
3010301-121150-630245 Circuit Court — Civil Mediation Pymts
Total Revenues
FY 2015
$10,000
$10,000
Expenditures
3010101-121100-731458 Professional Services
Total Expenditures
$10,000
$10,000.
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 Parks and Recreation and
Children's Village.
BE IT FURTHER RESOLVED that the FY 2015— FY 2018 Budgets are amended pursuant to Schedules
A and B.
Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution.
FINANCE COJI,AMITEE
TOAmANDT
COUNTY MICHIGAN
MANAGEMENT & BUDGET
OAKLAND COUNTY EXECUTIVE L. BROOKS PATTERSON
Laurie Van Pelt, Director
(248) 858-2163 I vanpeltl@thakgov.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 2015 Third Quarter Forecast
DATE: September 10, 2015
• 14-oety-
FY 2015 THIRD QUARTER REPORT
Attached please find the Fiscal Year (FY) 2015 Third Quarter Forecast Report. In total, Fiscal Services
forecasts that the County will complete FY 2015 with an overall favorable variance of $24,711,566 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 $3,770,584 more revenue than anticipated and projected
favorabiiity in expenditures of $20,940,982.
REVENUES
GF/GP revenues are .86% more than budget or $3,770,584. Major variances are the result of the
following events:
A. TAXES — Unfavorable: ($2,673,000)
Unfavorable Property Taxes ($3,000,000) due to millage reduction per MR #15052 and includes
countywide taxable value increase compared to budget. This is offset by favorable Payment in
Lieu of Taxes $327,000 in the Treasurer's Office to reflect actual revenue activity for payments
from the State on Department of Natural Resources (DNR) land.
B. STATE GRANTS — Unfavorable: ($1,412,500)
Reduced state funding is the result of reduced Child Care fund costs. The revenue loss is more
than offset by projected reduced expenditures. Expenditures are favorable for Foster Boarding
Homes, Independent Living, and Private Institutions - Residential and Foster Care.
C. OTHER INTERGOVERNMENTAL REVENUE — Favorable: $4,226,665
Favorable Revenue Sharing $2,200,000 from the State of Michigan and favorable Convention
Facility Liquor Tax $2,100,000 of which half must be used for substance abuse prevention and
treatment programs. A budget amendment is recommended to appropriate the required amount
to Oakland County Community Mental Health Authority (OCCMHA) as the coordinating agency.
This is partially offset by unfavorable Cigarette Tax Distribution ($48,000).
D. CHARGES FOR SERVICES — Favorable: $3,331,498
Favorable $2,500,000 in the Treasurer's Office for Land Sale Activity, Land Transfer Tax of
$1,000,000 in the County Clerk budget, favorable Commission Public Telephone of $500,000,
2100 Pontiac Lake Road County Executive Building 41W I Waterford, MI 48328 I Fax (248) 452-9172 I OakGov.
favorable Reimbursement General of $400,000 for grant administrative overhead in the Health
Division, Drug Testing $186,100 in the Sheriff's Office, Out County Board and Care of $175,000
in Children's Village and Soil Erosion Fees $70,000 in the Water Resources Commissioner. The
favorability is partially offset by unfavorable fines, fees and costs ($770,000) across the District
Courts due to statutory changes and fluctuations in caseloads, Treasurer's Office Civil Action
Service Fees ($450,000) due to the decline in foreclosures and ($100,000) Title Search Fees.
Also offset by unfavorable Sheriff's Office Diverted Felon revenue of ($200,000).
E. INVESTMENT INCOME — Favorable: $130,600
Favorable Interest on Investments in the Cleric/Register of Deeds Office of $15,600 and
favorable Income from Investments of $115,000 in the Treasurer's Office related to reallocation
of interest income for land sale activity.
F. OTHER REVENUES — Favorable: $140,521
Primarily due to favorable Refund of Prior Years Expenditures in the Sheriff's Office for Federal
overtime reimbursement and favorable Prior Years Revenue in the Health Division related to FY
2014 adjustment of administrative overhead cost distribution for grants.
EXPENDITURES
In total, expenditures are projected to be 4.80% under budget or $20,940,982 favorable.
Many departments have experienced personnel savings as the result of the hiring freeze, 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.
Water Resources Commissioner — Unfavorable: ($46,196)
• The department is forecasted to be unfavorable in Info Tech Operations ($67,956) a result of
maintenance costs related to the CAMS system and unfavorable in Telephone Communications
($9,900). This is offset by favorable Soil Erosion Fee revenue of $70,000. A budget amendment
will be made by year end if the trend continues.
Note that while individual divisions may be over budget, the budget is controlled at the department
level. The General Appropriations Act requires that appropriations accumulate at the following three
summary levels of expenditures within each County Department and are deemed maximum
authorization for expenditures: Personnel Expenditures, Operating Expenditures, and Internal Support
Expenditures.
Required Reporting Adjustments
The Quarterly Forecast presents the County's financial position in relation to the amended budget
(Budget perspective). This form of presentation is used so that users of this forecast can assess the
true financial impact of County operations in comparison to the budget for the current fiscal year.
However, it is important to note that this presentation style does not fully coincide with the accounting
requirements of audited financial statements produced by the County. The County's financial
statements are required to follow Generally Accepted Accounting Principles or GAAP.
Forecast Presentation — Budgetary Perspective
The presentation reflects the true fiscal activity of the County for FY 2015:
2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 I Fax (248) 452-9172 I OakGov.c,
Revenues - over/ (under) budget $ 3,770,584
Expenditures — (over)/uncler budget 20,940,982
Total Officially Reported Favorability $ 24,711,566
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 $39,638,852 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
$ 3,770,584
(39,638,852)
$ (35,868,268)
Expenditure Variance (Comparing Actual to Approved Plan)
GAAP Reported Effect on Fund Balance
20,940,982
$ (14,927,286)
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 2015 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 $24.7 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 $14.9 million by the end of Fiscal Year 2015. 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 2015-2017 Triennial Budget — the County
PLANNED to use fund balance, which has increased over the past several years through accelerated
budget reductions, to support operations beginning in FY 2015. However, it should be noted while the
amended budget reflects the utilization of $39.6 million of Fund Balance, this forecast projects the use
of Fund Balance needed to support FY 2015 activities of $14.9 million, $24.7 million less than planned.
2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 I Fax (248) 452-9172 I OakGov.c 1
788.00 768.00 - $ Revenues 4030901 4030501 116240 695500 116230 695500 4030601 110000 788001 53600 Transfer Out - Radio Communications 4030601 110000 788001 53600 Transfer Out-Radio Communications 4030601 110000 777560 Radio Communications Total Expenditures $ (4,566.00) $ 4,500.00 66.00 - $ $ 26,489.00 20,804.00 3,293.00 (47,293.00) 3,293.00 3,293.00 3,293.00 (788.00) $ (788.00) 4030301 116270 695500 9010101 196030 665882 Expenditures 4030601 116270 712020 21340 Transfers In L E Enhance Lab Fees 21396 Transfers In - Sheriff Training 21394 Transfers In - Sheriff Auto Theft Prevention Planned Use of Balance Total Revenue Overtime Total Expenditures SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF(GP) FY 2015 FY 2016 FY 2017 FY 2018 AMENDMENTS AMENDMENTS AMENDMENTS AMENDMENTS IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#101001 Dent Program Acct Fund Aff. Op Unit Account Name SHERIFFS OFFICE Expenditures 4030301 112620 731402 Prisoner Housing Outside County 4030601 110000 730562 Electrical Service 4030601 110000 732102 Water and Sewage Charges Total Expenditures $ (9,500.00) $ 7,500.00 2,000.00 - (9,500.00) $ (9,500.00) $ 7,500.00 7,500.00 2,000.00 2,000.00 - $ - $ (9,500.00) 7,500.00 2,000.00 4030901 116245 730548 4030301 112620 730548 Drug Testing Drug Testing Total Expenditures Contracted Services Software Rental Lease Purchase Total Expenditures $ (12,000.00) $ (12,000.00) $ 12,000.00 12,000.00 - $ $ $ (28,274.00) 28,274.00 (12,000.00) $ (12,000.00) 12,000.00 12,000.00 4030301 112630 730373 4030501 116230 731773
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2015 FY 2016 FY 2017 FY 2018 AMENDMENTS AMENDMENTS AMENDMENTS AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#101001 Dept Program Acct Fund Aff. Op Unit Account Name Revenues 4030901 116270 695500 21394 Transfer In - Sheriff Auto Theft Prevention Total Revenue 3,000.00 3,000.00 Expenditures 4030901 116270 732018 Travel and Conference 3,000.00 Total Expenditures 3,000.00 CIRCUIT COURT Revenue 9010101 196030 665882 Planned Use of Balance Total Revenues Expenditure 3010401 121100 788001 27100 Transfer Out - Friend of the Court Total Expenditures Visiting Judges Emergency Salaries Total Expenditures Admission to the Bar Admission to the Bar Appeals Appellate Court Appeals Appellate Court Assumed Names Assumed Names $ 1,587,897.00 $ 1,587,897.00 $ 1,587,897.00 $ 1,587,897.00 $ 10,000.00 (10,000.00) $ (6,100.00) $ (6,100.00) $ (6,100.00) $ 6,100.00 6,100.00 6,100.00 (7,000.00) (7,000.00) (7,000.00) 7,000.00 7,000.00 7,000.00 (60,000.00) (60,000.00) (60,000.00) 60,000.00 60,000.00 60,000.00 DISTRICT COURT ADMINISTRATION Expenditures 3020101 121020 732081 9090101 196030 740058 COUNTY CLERK Revenues 2010201 125000 2010210 125000 2010201 125000 2010210 125000 2010201 125000 2010205 132305 630021 630021 630091 630091 630119 630119 (6,100.00) 6,100.00 (7,000.00) 7,000.00 (60,000.00) 60,000,00
Account Name Bond Fees Bond Fees Certified Copies Certified Copies Certified Copies Civil Action Entry Fees Civil Action Entry Fees Co Partnership New Co Partnership New Construction Lien Construction Lien Costs Costs CVR County Portion CVR County Portion Forfeiture of Bonds Forfeiture of Bonds Forfeiture of Surety Bonds Forfeiture of Surety Bonds Garnishment Fees Garnishment Fees Jury Fees Jury Fees Marriage Licenses Marriage Licenses Marriage Waivers Marriage Waivers Miscellaneous Miscellaneous Motion Fees Motion Fees Notary Commission Notary Commission (55,000.00) (55,000.00) 55,000.00 55,000.00 (1,000,000.00) 270,000.00 630,000.00 (400,000.00) (400,000.00) 400,000.00 400,000.00 (2,000.00) (2,000.00) 2,000.00 2,000.00 (1,500.00) (1,500.00) 1,500.00 1,500.00 (7,000.00) (7,000.00) 7,000.00 7,000.00 (20,000.00) (20,000.00) 20,000.00 20,000.00 (20,000.00) (20,000.00) 20,000.00 20,000.00 (3,000.00) (3,000.00) 3,000.00 3,000.00 (50,000.00) (50,000.00) 50,000.00 50,000.00 (150,000.00) (150,000.00) 150,000.00 150,000.00 (35,000.00) (35,000.00) 35,000.00 35,000.00 (11,500.00) (11,500.00) 11,500.00 11,500.00 (12,000.00) (12,000.00) 12,000.00 12,000.00 (250,000.00) (250,000.00) 250,000.00 250,000.00 (32,000.00) (32,000.00) 32,000.00 32,000.00 (55,000.00) 55,000.00 (1,000,000.00) 270,000.00 630,000.00 (400,000.00) 400,000.00 (2,000.00) 2,000.00 (1,500.00) 1,500.00 (7,000.00) 7,000.00 (20,000.00) 20,000.00 (20,000.00) 20,000.00 (3,000.00) 3,000.00 (50,000.00) 50,000.00 (150,000.00) 150,000.00 (35,000.00) 35,000.00 (11,500.00) 11,500.00 (12,000.00) 12,000.00 (250,000.00) 250,000.00 (32,000.00) 32,000.00 (55,000.00) 55,000.00 (1,000,000.00) 270,000,00 630,000.00 (400,000.00) 400,000.00 (2,000.00) 2,000.00 (1,500.00) 1,500.00 (7,000.00) 7,000.00 (20,000.00) 20,000.00 (20,000.00) 20,000.00 (3,000.00) 3,000.00 (50,000.00) 50,000.00 (150,000.00) 150,000.00 (35,000.00) 35,000.00 (11,500.00) 11,500.00 (12,000.00) 12,000.00 (250,000.00) 250,000.00 (32,000.00) 32,000.00 SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2015 FY 2016 FY 2017 FY 2018 AMENDMENTS AMENDMENTS AMENDMENTS AMENDMENTS CF/OP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aff. Op Unit 2010201 125000 630161 2010210 125000 630161 2010201 125000 630210 2010210 125000 630210 2010205 132305 630210 2010201 125000 630231 2010210 125000 630231 2010201 125000 630287 2010205 132305 630287 2010201 125000 630364 2010210 125000 630364 2010201 125000 630385 2010210 125000 630385 2010201 125000 630441 2010210 125000 630441 2010201 125000 630798 2010210 125000 630798 2010201 125000 630812 2010210 125000 630812 2010201 125000 630826 2010210 125000 630826 2010201 125000 631015 2010210 125000 631015 2010201 125000 631155 2010205 132305 631155 2010201 125000 631162 2010205 132305 631162 2010201 125000 631253 2010201 132300 631253 2010201 125000 631281 2010210 125000 631281 2010201 125000 631323 2010205 132305 631323
125000 132300 125000 125000 125000 132300 125000 125000 125000 125000 132300 125000 125000 132305 125000 125000 125000 125000 132300 730247 730247 730422 730422 730646 730646 730772 731101 731101 731213 731213 731213 731346 731346 731346 731388 731388 731 388 731388 Charge Card Fee Charge Card Fee Court Transcripts Court Transcripts Equipment Maintenance Equipment Maintenance Freight & Express Library Continuations Library Continuations Membership Dues Membership Dues Membership Dues Personal Mileage Personal Mileage Personal Mileage Printing Printing Printing Printing SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2015 FY 2016 FY 2017 FY 2018 AMENDMENTS AMENDMENTS AMENDMENTS AMENDMENTS Expenditures 2010201 2010201 2010201 2010210 2010201 2010201 2010201 201 0201 2010210 2010201 2010201 2010210 2010201 2010205 2010210 2010205 2010201 2010210 2010201 (4,000.00) 4,000.00 (1,500.00) 1,500.00 (2,500.00) 2,500.00 $ (18,000.00) $ 18,000.00 (100,000.00) 100,000.00 (4,000.00) 4,000.00 (1,000.00) (400.00) 400.00 (3,500.00) 3,500.00 (750.00) 250.00 500.00 (628.00) (5,950.00) 1,100.00 478.00 (4,000.00) 4,000.00 (1,500.00) 1,500.00 (100,000.00) 195,000.00 5,000.00 (2,500.00) 2,500.00 (10,000.00) 10,000.00 (18,000.00) $ 18,000.00 - (4,000.00) 4,000.00 (3,000.00) 3,500.00 (3,500.00) (2,250.00) 750.00 1,500.00 (1,884.00) (17,850.00) 3,300.00 1,434.00 (4,000.00) 4,000.00 (1,500.00) 1,500.00 (100,000.00) 195,000.00 5,000.00 (2,500.00) 2,500.00 (4,000.00) 4,000.00 (3,000.00) 3,500.00 (3,500.00) (2,250.00) 750.00 1,500.00 (1,884.00) (17,850.00) 3,300.00 1,434.00 (4,000.00) 4,000.00 (1,500.00) 1,500.00 (100,000.00) 195,000.00 5,000.00 (2,500.00) 2,500.00 (4,000.00) 4,000.00 (3,000.00) 3,500.00 (3,500.00) (2,250.00) 750.00 1,500.00 (1,884.00) (17,850.00) 3,300.00 1,434.00 IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#101001 apt Prooram Acct Fund Aff. Op Unit Account Name 2010201 125000 631414 Order Reinstating Case 2010210 125000 631414 Order Reinstating Case 2010201 125000 631477 Paternity Judgement Fee 2010210 125000 631477 Paternity Judgement Fee 2010201 125000 631526 Photostats 2010210 125000 631526 Photostats 2010205 132305 631526 Photostats 2010201 125000 655770 Interest on Investments 2010210 125000 655770 Interest on Investments 2010201 132300 631519 Photographs 2010205 132305 631519 Photographs Total Revenues (18,000.00) 5 (18,000.00) 18,000.00 18,000.00
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2015 FY 2016 FY 2017 FY 2018 AMENDMENTS AMENDMENTS AMENDMENTS AMENDMENTS IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aff. Op Unit 2010205 132305 731388 2010201 125000 731458 2010201 132300 731458 2010205 132305 732018 2010210 125000 732018 2010201 125000 732018 2010201 125000 732165 2010201 125000 750392 2010205 132305 750392 2010210 125000 750392 2010201 125000 750399 2010201 132300 750399 2010210 125000 750399 2010205 132305 750399 2010201 125000 770631 2010205 132305 770631 2010210 125000 770631 2010201 125000 772618 2010201 132300 772618 2010205 132300 774636 2010205 132305 774636 2010210 125000 778675 2010201 125000 778675 Account Name Printing Professional Services Professional Services Travel & Conference Travel & Conference Travel & Conference Workshops & Meeting Metered Postage Metered Postage Metered Postage Office Supplies Office Supplies Office Supplies Office Supplies Bldg Space Cost Allocation Bldg Space Cost Allocation Bldg Space Cost Allocation Equipment Rental Equipment Rental Info Tech Operations Info Tech Operations Telephone Communications Telephone Communications Total Expenditures 5,000.00 (40,000.00) 40,000.00 408.00 408.00 (150.00) (666.00) (11,296.00) 6,296.00 5,000.00 (6,667.00) 8,333.00 (4,333.00) 3,667.00 (80,963.00) 21,761.00 59,202.00 (3,860.00) 3,860.00 (42,088.00) 42,088.00 113.00 (113.00) - $ 15,000.00 1,225,00 1,225.00 (450.00) (2,000.00) (33,887.00) 18,887.00 15,000.00 (20,000.00) 25,000.00 (13,000.00) 11,000.00 (272,546.00) 73,253.00 199,293.00 (3,860.00) 3,860.00 10,880.00 (10,880,00) 339.00 (339.00) - $ 15,000.00 15,000.00 1,225.00 1,225.00 1,225.00 1,225.00 (450.00) (450.00) (2,000.00) (2,000.00) (33,887.00) (33,887.00) 18,887.00 18,887.00 15,000.00 15,000.00 (20,000.00) (20,000.00) 25,000.00 25,000.00 (13,000.00) (13,000.00) 11,000.00 11,000.00 (295,303,00) (296,423.00) 79,370.00 79,671.00 215,933.00 216,752.00 (3,860,00) (3,860.00) 2,860.00 3,860.00 10,880.00 10,880.00 (10,880.00) (10,880.00) 339.00 339.00 (339.00) (339.00)
TREASURER'S OFFICE Revenues 7010101 186070 7010101 186070 7010101 186070 7010101 186070 7010101 186070 7010101 186070 601637 630945 631358 632285 632289 632310 BOARD OF COMMISSIONERS Revenue 5010101 132325 630686 SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GFIGP) GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#101001 Dept Program Acct Fund Aff. Op Unit Account Name FY 2015 FY 2016 FY 2017 FY 2018 AMENDMENTS AMENDMENTS AMENDMENTS AMENDMENTS Property Tax Levy Industrial Facilities Tax Obsolete Property TDRRZ Act 376 TIFA DDA Recovery Ad Valorem TIFA DDA Recovery IFT Total General Fund Revenue Fee Income Total General Fund Revenue $ 850,500.00 $ 993,500.00 $ 993,500.00 $ 993,500.00 (112,000.00) (400,000.00) (400,000.00) (400,000.00) (500.00) (500.00) (500.00) (500.00) (5,000.00) (10,000.00) (10,000.00) (10,000.00) (700,000.00) (550,000.00) (550,000.00) (550,000.00) (33,000.00) (33,000.00) (33,000.00) (33,000.00) _ _ 7,400.00 7,400.00 Expenditures 501 01 01 180010 732018 Travel & Conferences (5,090.00) 5010101 180010 778675 Telephone Communications 12,490.00 Total General Fund Expenditure 7,400.00 CORPORATION COUNSEL Expenditures 9090101 196030 773630 1010501 181020 731780 HUMAN RESOURCES Expenditures 1050402 183020 731570 1050402 183040 731493 Non-Dept! Info Tech Development Software Support Maintenance Total Expenditures Recruitment Expense Psychological Testing Total Expenditures $ (28,200.00) $ 28,200.00 S - $ $ (7,000.00) 7,000.00 (28,200.00) $ (28,200.00) $ (28,200.00) 28,200.00 28,200.00 28,200.00 - $ - $
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GFIGP) FY 2015 FY 2016 FY 2017 FY 2018 AMENDMENTS AMENDMENTS AMENDMENTS AMENDMENTS FF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#101001 Dept Program Acct Fund Aff. Op Unit Account Name DEPARTMENT OF HEALTH AND HUMAN SERVICES Revenue 1060234 133910 631568 1060234 133910 630917 Expenditures 1060234 133910 750588 ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS Revenue 1090108 172072 650104 Expenditures 1090201 172072 750511 Revenue 1090201 171050 632065 Expenditures 1090201 171050 732165 Pneumo Vax 3rd Party Immunizations Total Expenditures Vaccines Total Expenditures Contributions Total Revenues Special Event Supplies Total Expenditures Seminars/Conferences Total Revenues Workshops/Meetings Total Expenditures $ 25,000.00 $ 25,000.00 $ 25,000.00 $ 25,000.00 300,000.00 300,000.00 300,000.00 300,000.00 $ 325,000.00 $ 325,000.00 $ 325,000.00 $ 325,000.00 5 325,000.00 $ 325,000.00 5 325,000.00 $ 325,000.00 325,000.00 $ 325,000.00 $ 325,000.00 $ 325,000.00 $ 26,466.00 $ 26,466.00 $ 26,466.00 $ 26,466.00 $ 15,987.00 $ 15,987.00 $ 15,987.00 $ 15,987.00 Revenue 1090205 171025 631757 Expenditures 1090205 171025 731458 Registration Fees Total Revenues Professional Services Total Expenditures 700.00 700,00 700.00 700.00
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2015 FY 2016 FY 2017 FY 2(318 AMENDMENTS AMENDMENTS AMENDMENTS AMENDMENTS 1F1GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100), Dept Program Acct Fund Aff. Op Unit Account Name Revenue 1090201 172071 631757 Registration Fees $ 20,232.00 Total Revenues $ 20,232.00 Expenditures 1090201 172071 731458 Professional Services $ 20,232.00 Total Expenditures $ 20,232.00 NON-DEPARTMENTAL Revenue 9010101 196010 620302 Convention Facility Liquor Tax $ 1,060,000.00 Total Revenue $ 1,060,000.00 Expenditures 9010101 134790 740160 Substance Abuse Coord Agency $ 1,060,000.00 Total Expenditures $ 1,060,000.00 Revenue 9010101 9010101 9010101 1 96030 695500 29330 Transfer In - FEMA Grants $ 573.00 196030 695500 29340 Transfer In - Domestic Preparedness Equip Grant 1,689,00 196030 665882 Planned Use of Balance $ (2,262.00) Total Revenues $ Expenditures 9090101 196030 730800 Grant Match (76,568.00) 9010101 196030 788001 29340 Transfer Out - Domestic Preparedness Equip Grant $ 76,568.00 Total Expenditures $
FY 2016 FY 2017 AMENDMENTS AMENDMENTS FY 2015 AMENDMENTS Transfer Out - Sheriff Total Expenditures 26,489.00 26,489.00 Planned Use of Balance Total Revenue 20,804.00 20,804.00 Transfer Out - Sheriff Total Expenses 20,804.00 20,804.00 Planned Use of Balance Total Revenue 3,293.00 3,293.00 Transfer Out - Sheriff Total Expenditures 3,293.00 3,293.00 Planned Use of Balance Total Revenue SHERIFF - LAW ENFORCEMENT ENHANCE LAB FEES (#21340) Revenue 4030901 116240 665882 21340 SCHEDULE B ACCOUNT NUMBER Expenditures 4030101 112580 788001 10100 SHERIFF - TRAINING (#21396) Revenue 4030501 116230 665882 21396 Expenditures 4030301 112590 788001 10100 Dispatch SHERIFF - ATPA FORFEITURE (#21394) Revenue 4030601 116270 665882 21394 Expenditures 4030601 116270 788001 10100 OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 26,489,00 26,489.00
Transfer Out - Sheriff 3,000.00 Total Expenditures 3,000.00 CRP FOC Federal Incentive Payment CRP State Supplement Transfers In Total Revenue $ (1,389,881.00) 122,726.00 1,054,100.00 1,587,897.00 1,374,842.00 Miscellaneous 1,374,842.00 Total Expenditures 1,374,842.00 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Revenue 4030601 116270 665882 21394 Planned Use of Balance Total Revenue 3,000.00 3,000.00 Expenses 4030601 116270 788001 10100 FRIEND OF THE COURT FUND (#27100) Revenue 3010404 126030 625210 3010404 126030 625517 3010404 126030 625212 3010404 126050 695500 Expenditure 3010404 126030 731241 FOC ACCESS VISITITATION FUND (#27120) GR0000000282 Bud Ref 2016 PCBU Grant Activity GLB Anaysis Type GLB Revenue 3010404 126030 610313 Federal Operating Grant Total Revenue Expenditure 3010404 126030 731458 3,200.00 3,200.00 Professional Services 3,200.00 Total Expenditures 3,200.00
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name HOME INVESTMENT PARTNERSHIP ACT PONTIAC FUND (#29712) GR0000000614 Bud Ref 2015 PCBU COMHI Activity GLB Analysis Type GLB A Expenditures 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 113000 113000 113000 113020 113020 113035 113035 113035 123010 123010 123010 113120 113120 113120 113130 731213 750294 773630 702010 722740 702010 722740 730373 702010 722740 731458 702010 722740 731773 702010 Federal Operating Grant Total Revenues CHDO Rehab Total Expenditures Total Expenditures Membership Dues Materials, Supplies IT Development Salaries Fringe Benefits Salaries Fringe Benefits Contracted Services Salaries Fringe Benefits Professional Services Salaries. Fringe Benefits Software Rental/Lease Salaries 28,581.00 28,581.00 28,581.00 28,581.00 (16,000.00) 8,500.00 7,500.00 (500.00) (400.00) 92,200.00 (6,141.00) (9,859.00) (7,845.00) (9,155.00) (11,000.00) (2,360.00) (1,640.00) (1,600.00) (5,857.00) (643.00) (1,200.00) (9,000.00) Revenue 1090659 132230 610313 Expenditures 1090659 132230 730275 COMMUNITY CORRECTIONS COMPREHENSIVE PLAN GRANT FUND (#27370) GR0000000093 Bud Ref 2015 PCBU Grant Activity GLB Anaysis Type GLB Expenditures 1070401 113130 731458 Professional Services 1070401 113130 702010 Salaries 1070401 123010 702010 Salaries
HEALTH -ADOLESCENT SCREENING CPBC (#28310). GR0000000689 Bud Ref 2015 PCBU Grant Activity GLB Anaysis Type GLB Revenues 1060234 133120 610313 Federal Operating Grants Total Revenues Expenditures 1060234 133120 1060234 133120 1060234 133120 730646 750280 750567 Equipment Maintenance Laboratory Supplies Training-Educational Supplies Total Expenditures 2,000.00 2,000.00 800.00 700.00 500.00 2,000.00 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS LPROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 1070401 113130 731458 Professional Services 4030301 112652 702010 Salaries 4030301 112652 722740 Fringe Benefits 4030301 112651 702010 Salaries 4030301 112651 722740 Fringe Benefits Total Expenditures (2,000.00) (5,834.00) (1,166.00) (1,206.00) (14,794.00) ANIMAL CONTROL LEGACY FUND (#21310) Revenues 9010101 114110 665882 Planned Use of Balance 1,400.00 Total Revenues 1,400.00 Expenditures 9010101 114110 788001 29215 Transfer Out-Animal Control Grants Fund $ 1,400.00 Total Expenditures ANIMAL CONTROL GRANTS FUND (#29215) GR0000000715 Bud Ref 2015 PCBU Grant Activity GLB Anaysis Type GLB Revenues 1070801 114000 695500 21310 Total Revenues 1,400.00 1,400.00 1,400,00 Transfer In-Animal Control Legacy Fund $ Expenditures 1070801 114000 750014 Animal Supplies 1,400.00 Total Expenditures 1,400.00
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY I SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aft Oper Unit Account Name HEALTH - COMMUNITIES PLANNING (#28320) GR0000000562 Bud Ref 2015 PCBU Grant Activity GLB Anaysis Type GLB Revenues 1060233 133350 610313 Federal Operating Grants (10,455.00) Total Revenues Expenditures (10,455.00) 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 133350 133350 133350 133350 133350 133350 133350 133350 133350 133350 133350 133350 702010 722740 730072 730926 731346 731388 731931 732018 750294 750448 750462 750567 Salaries Regular Fringe Benefits Advertising Indirect Costs Personal Mileage Printing Training Travel and Conference Material and Supplies Postage-Standard Mailing Provisions Training-Educational Supplies Total Expenditures (2,213.00) (128.00) (4,060.00) 1,872.00 41.00 (4,047.00) (344.00) (475.00) 1,114.00 (2,004.00) (710.00) 499.00 (10,455.00) HEALTH - TB OUTREACH (#28556) GR0000000192 Bud Ref 2015 PCBU Grant Activity GLB Anaysis Type GLB Revenues 1060235 133970 610313 Federal Operating Grants 10,380.00 Total Revenues 10,380.00 Expenditures 1060235 133970 1060235 133970 1060235 133970 1060235 133970 730982 731346 732018 731997 Interpreter Fees Personal Mileage Travel and Conference Transportation of Clients 1,050.00 6,830.00 1,000.00 500.00
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS PROPRIETARY 1 SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 1060235 133970 750301 Medical Supplies 1,000.00 Total Expenditures 10,380.00 HEALTH - AIDS COUNSELING (#28557) GR0000000194 Bud Ref 2015 PCBU Grant Activity GLB Anaysis Type GLB Expenditures 1060294 1060294 1060294 1060294 1060294 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 133940 133940 133940 133940 133940 133021 133021 133021 133021 133021 133021 133021 133021 702010 722740 730926 732018 750294 702010 722740 730926 731458 750077 750399 774636 778675 Salaries Regular Fringe Benefits Indirect Costs Travel and Conference Material and Supplies Total Expenditures Salaries Regular Fringe Benefits Indirect Costs Professional Services Disaster Supplies Office Supplies Info Tech Operations Telephone Communications Total Expenditures (6,610.00) (2,799.00) (1,002.00) 5,000.00 5,411.00 57,506.00 57,506.00 8,368.00 2,000.00 1,268.00 22,906.00 22,000.00 150.00 700.00 114.00 57,506.00 EBOLA VIRUS DISEASE - PHASE II (#28614) GR0000000724 Bud Ref 2015 PCBU Grant Activity GLB Anaysis Type GLB Revenues 1060290 133021 610313 Federal Operating Grants Total Revenues Expenditures
ACCOUNT NUMBER FY 2016 FY 2017 AMENDMENTS AMENDMENTS OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS $ $ 5,100.00 5,100.00 PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCLNG AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name HEALTH - GREAT START TRAUMA (#28613) GR0000000273 Bud Ref 2015 PCBU Grant Activity GLB Anaysis Type GLB Revenues 1060231 133390 610313 Federal Operating Grants Total Revenues Expenditures SCHEDULE B Salaries Regular Fringe Benefits Indirect Costs Personal Mileage Training-Educational Supplies Total Expenditures Salaries Regular Fringe Benefits Indirect Costs Personal Mileage Office Supplies Total Expenditures Federal Operating Grants Federal Operating Grants Total Revenues 1,533.00 1,089.00 232.00 1,246.00 1,000.00 5,100.00 6,000.00 6,000.00 2,281.00 1,693.00 346.00 978.00 702.00 6,000.00 $ 77,514.00 $ 53,075.00 $ 130,589.00 HEALTH - PHEP (#28610) GR0000000716 Revenues 1060290 115010 610313 1060290 115035 610313 Bud Ref 2015 PCBU Grant Activity GLB Anaysis Type GLB 1060231 1060231 1060231 1060231 1060231 133390 133390 133390 133390 133390 702010 722740 730926 731346 750567 1060220 1060220 1060220 1060220 1060220 134870 134870 134870 134870 134870 702010 722740 730926 731346 750399 HEALTH - WEST NILE VIRUS (#28690) GR0000000722 Bud Ref 2015 PCBU Grant Activity GLB Anaysis Type GLB Revenues 1060220 134870 610313 Federal Operating Grants Total Revenues Expenditures
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aft Oper Unit Account Name Expenses 1060290 115010 702010 Salaries Regular 1060290 115010 722740 Fringe Benefits 1060290 115010 730926 Indirect Costs 1060290 115010 731346 Personal Mileage 1060290 115010 731388 Printing 1 060290 115010 750077 Disaster Supplies 1060290 115010 750399 Office Supplies 1060290 115010 770631 Bldg Space Cost Allocation 1060290 115010 774636 Info Tech Operations 1060290 115010 774637 Info Tech Managed Print Svcs 1060290 115010 774677 Insurance Fund 1060290 115010 778675 Telephone Communications 1060290 115035 702010 Salaries Regular 1060290 115035 722740 Fringe Benefits 1060290 115035 730646 Equipment Maintenance 1060290 115035 730926 Indirect Costs 1060290 115035 731346 Personal Mileage 1060290 115035 731388 Printing 1060290 115035 750077 Disaster Supplies 1060290 115035 750399 Office Supplies 1060290 115035 770631 Bldg Space Cost Allocation 1060290 115035 774636 Info Tech Operations 1060290 115035 774677 Insurance Fund 1060290 115035 777560 Radio Communications 1060290 115035 778675 Telephone Communications Total Expenditures 33,045.00 23,793.00 4,953.00 799.00 2,000.00 4,101.00 800.00 2,095.00 2,100.00 2,639.00 195.00 994.00 20,086.00 14,462.00 1,676.00 3,011.00 288.00 2,000.00 2,544.00 800.00 1,698.00 3,642.00 150.00 2,286.00 432.00 130,589.00
PARKS AND RECREATION COMMISSION (#50800) Revenue 5060666 160666 665882 Expenses 5060101 5060101 5060101 5060101 5060101 5060101 5060101 160000 160000 160000 160000 160000 160000 160000 702010 722740 730072 730520 730789 731780 732018 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS [PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name HEALTH - IMMUNIZATION ACTION PLAN (#28550) GR0000000182 Bud Ref 2015 PCBU Grant Activity GLB Anaysis Type GLB Revenues 1060218 133910 610313 FIRE RECORDS FUND 53100 Revenue 53100 1080325 115100 665882 Federal Operating Grants Total Revenues Salaries Regular Fringe Benefits Indirect Costs Printing Total Expenditures Planned Use of Balance Total Revenue Professional Svcs Total Expenses Planned Use of Balance Total Revenue Salaries Regular Fringe Benefits Advertising Design Fees General Program Administration Software Support Maintenance Travel and Conference 31,418.00 31,418.00 23,594.00 4,237.00 3,575.00 12.00 31,418.00 85,000.00 85,000.00 85,000,00 85,000.00 1,601,123.00 1,601,123.00 (218,676.00) (63,103.00) (100,000.00) (31,400.00) (100,000.00) (1,000.00) (9,950,00) Expenditures 1060218 133910 1060218 133910 1060218 133910 1060218 133910 702010 722740 730926 731388 Expenses 53100 1080325 115100 731458
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY I SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID program Acct Fund Aff Oper Unit Account Name 5060101 160000 750154 Expendable Equipment 5060101 160000 773630 Info Tech Development 5060326 160010 702010 Salaries Regular 5060326 160010 731780 Software Support Maintenance 5060326 160010 732018 Travel and Conference 5060326 160010 750154 Expendable Equipment 5060326 160015 702010 Salaries Regular 5060326 160800 730811 Greenhouse Allocation 5060327 160010 702010 Salaries Regular 5060327 160010 722740 Fringe Benefits 5060327 160010 732018 Travel and Conference 5060327 160010 750154 Expendable Equipment 5060327 160015 702010 Salaries Regular 5060327 160015 731780 Software Support Maintenance 5060328 160010 702010 Salaries Regular 5060328 160010 732018 Travel and Conference 5060328 160010 750154 Expendable Equipment 5060328 160015 702010 Salaries Regular 5060328 160800 730811 Greenhouse Allocation 5060330 160010 702010 Salaries Regular 5060330 160010 722740 Fringe Benefits 5060330 160010 732018 Travel and Conference 5060330 160010 750154 Expendable Equipment 5060330 160015 702010 Salaries Regular 5060330 160800 730811 Greenhouse Allocation 5060356 160010 702010 Salaries Regular 5060356 160010 722740 Fringe Benefits 5060356 160010 732018 Travel and Conference 5060356 160010 750154 Expendable Equipment 5060356 160015 702010 Salaries Regular 5060417 160044 730520 Design Fees 5060417 160044 730811 Greenhouse Allocation 5060420 160044 750154 Expendable Equipment 5060427 160044 730811 Greenhouse Allocation 5060431 160044 750154 Expendable Equipment 5060437 160044 750154 Expendable Equipment (185.00) (150,000.00) (10,000.00) (5,000.00) 1,852.00 (14,000.00) (10,000.00) (1,700.00) (47,752.00) (11,326.00) 51.00 (14,000.00) (10,000.00) (5,000.00) (10,000.00) (23.00) 1,405.00 (5,000.00) (1,700.00) (47,752.00) (11,326.00) (215.00) (12,000.00) (10,000.00) (1,700.00) (52,752.00) (11,326.00) (1,006.00) (16,000.00) (10,000.00) (2,100.00) (300.00) (4,000.00) (1,700.00) (6,500.00) (4,000.00)
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060456 160044 730811 Greenhouse Allocation 5060540 160500 702010 Salaries Regular 5060540 160500 732018 Travel and Conference 5060540 160500 750154 Expendable Equipment 5060715 160070 702010 Salaries Regular 5060715 160070 722740 Fringe Benefits 5060715 160070 731780 Software Support Maintenance 5060715 160070 732018 Travel and Conference 5060715 160070 750154 Expendable Equipment 5060715 160800 730811 Greenhouse Allocation 5060720 160070 702010 Salaries Regular 5060720 160070 731780 Software Support Maintenance 5060720 160070 732018 Travel and Conference 5060720 160070 750154 Expendable Equipment 5060720 160800 730811 Greenhouse Allocation 5060724 160070 702010 Salaries Regular 5060724 160070 722740 Fringe Benefits 5060724 160070 750154 Expendable Equipment 5060725 160070 70201 0 Salaries Regular 5060725 160070 731780 Software Support Maintenance 5060725 160070 732018 Travel and Conference 5060725 160070 750154 Expendable Equipment 5060725 160800 730811 Greenhouse Allocation 5060729 160070 702010 Salaries Regular 5060732 160070 702010 Salaries Regular 5060732 160070 722740 Fringe Benefits 5060732 160070 750154 Expendable Equipment 5060732 160800 730811 Greenhouse Allocation 5060735 160070 702010 Salaries Regular 5060735 160070 722740 Fringe Benefits 5060735 160070 731780 Software Support Maintenance 5060735 160070 732018 Travel and Conference 5060735 160070 750154 Expendable Equipment 5060735 160800 730811 Greenhouse Allocation 5060751 160070 702010 Salaries Regular 5060751 160070 732018 Travel and Conference (1,700.00) (5,000.00) (33.00) (700.00) (20,000.00) (1,000.00) (25,000.00) (970.00) (9,900.00) (1,700.00) (20,000.00) (20,000.00) (292.00) (11,000.00) (1,700.00) (1,000.00) (50.00) (300.00) (20,000.00) (7,500.00) (1,115.00) (3,500.00) (1,700.00) (1,000.00) (1,000.00) (50.00) 2,040.00 (1,700.00) (15,000.00) (750.00) (2,500.00) (1,051.00) (4,000.00) (1,700.00) (1,000.00) (599.00)
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060751 160070 750154 Expendable Equipment 5060755 160070 702010 Salaries Regular 5060755 160070 722740 Fringe Benefits 5060755 160070 732018 Travel and Conference 5060755 160070 750154 Expendable Equipment 5060755 160800 730811 Greenhouse Allocation 5060760 160070 731780 Software Support Maintenance 5060765 160070 731780 Software Support Maintenance 5060805 160210 702010 Salaries Regular 5060805 160210 722740 Fringe Benefits 5060805 160210 731780 Software Support Maintenance 5060805 160210 732018 Travel and Conference 5060831 160210 702010 Salaries Regular 5060831 160210 722740 Fringe Benefits 5060831 160210 732018 Travel and Conference 5060831 160210 750154 Expendable Equipment 5060831 160800 730811 Greenhouse Allocation 5060831 160800 731780 Software Support Maintenance 5060837 160210 702010 Salaries Regular 5060837 160210 722740 Fringe Benefits 5060837 160210 731780 Software Support Maintenance 5060837 160210 732018 Travel and Conference 5060837 160210 750154 Expendable Equipment 5060837 160800 730811 Greenhouse Allocation 5060845 160210 702010 Salaries Regular 5060845 160210 722740 Fringe Benefits 5060845 160210 732018 Travel and Conference 5060845 160800 730811 Greenhouse Allocation 5060870 160210 702010 Salaries Regular 5060870 160210 722740 Fringe Benefits 5060870 160800 730811 Greenhouse Allocation 5060910 160430 702010 Salaries Regular 5060910 160430 722740 Fringe Benefits 5060910 160430 730198 Building Maintenance Charges 5060910 160430 731780 Software Support Maintenance (500.00) (5,000.00) (100.00) (400.00) (2,600.00) (1,700.00) (1,000.00) (1,000.00) (20,000.00) (1,000.00) (1,000.00) 741,00 (20,000,00) (1,000.00) (4,020.00) (2,000.00) (1,100.00) (5,000.00) (20,000.00) (1,000.00) (5,000.00) (500.00) (11,000.00) (600.00) (1,000.00) (50.00) (400.00) (600.00) (1,000.00) (50.00) (600.00) (25,000.00) (1,250.00) (272,700.00) (2,500.00)
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS Grounds Maintenance Expendable Equipment Contingency Building Maintenance Charges Building Maintenance Charges Building Maintenance Charges Building Maintenance Charges Building Maintenance Charges Building Maintenance Charges Building Maintenance Charges Building Maintenance Charges Building Maintenance Charges Building Maintenance Charges Building Maintenance Charges Building Maintenance Charges Grounds Maintenance Grounds Maintenance Grounds Maintenance Grounds Maintenance Grounds Maintenance Grounds Maintenance Grounds Maintenance Grounds Maintenance Grounds Maintenance Grounds Maintenance Grounds Maintenance Grounds Maintenance PARKS AND RECREATION FUND (#50800) Expenses 5060330 160010 730814 5060910 160430 750154 5060666 160666 730359 5060417 160044 730198 5060715 160070 730198 5060427 160044 730198 5060327 160010 730198 5060720 160070 730198 5060751 160070 730198 5060831 160210 730198 5060732 160070 730198 5060330 160010 730198 5060326 160010 730198 5060735 160070 730198 5060910 160430 730198 5060417 160044 730814 5060715 160070 730814 5060327 160010 730814 5060720 160070 730814 5060765 160070 730814 5060725 160070 730814 5060755 160070 730814 5060724 160070 730814 5060328 160010 730814 5060760 160070 730814 5060831 160210 730814 5060732 160070 730814 (2,070.00) 2,530.00 (1,601,123.00) 6,762.00 3,239.00 (10,001.00) 35,201.00 32,192.00 393.00 16,600.00 15,200.00 12,736.00 57,555.00 15,808.00 15,200.00 15,135.00 9,970.00 (424,235.00) 1,292.00 16,008.00 2,067.00 3,201.00 4,121.00 16,179.00 9,318.00 19,463.00 7,120.00 10,718.00 21,947.00 61,897.00 PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060910 160430 732018 Travel and Conference 5060910 160430 750154 Expendable Equipment Total Expenses
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 20'16 FY 2017 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS pep...t) Program Acct Fund Aff Oder Unit Account Name 5060330 160010 730814 Grounds Maintenance 5060326 160010 730814 Grounds Maintenance 5060735 160070 730814 Grounds Maintenance 5060724 160070 730198 Building Maintenance Charges 5060666 160066 730359 Contingency Total Expenses 10,206.00 2,954.00 11,754.00 4,968.00 (4,968.00) DRAIN EQUIPMENT FUND (#63900) Revenue 6010101 149750 695500 6010101 149750 695500 6010101 149750 695500 6010101 149750 695500 6010101 149750 695500 6010101 149750 695500 6010101 149750 695500 57010 57234 57434 58600 58410 58510 58700 26486 26486 26486 26486 26486 26486 26486 Transfer In Transfer In Transfer In Transfer In Transfer In Transfer In Transfer In 18,800.00 3,196.00 6,016.00 15,886.00 20,962.00 25,756.00 3,384.00 94,000.00 Total Revenue Expenses 6010101 149750 761084 6010101 149750 796500 26486 Depreciation Building 26486 Budget Equity Adjustment Total Expenses 940.00 93,060.00 94 000.00 WATER AND SEWER TRUST FUND (#57010) Revenue 6010101 149290 665882 6010101 149300 665882 Planned Use of Balance Planned Use of Balance Total Revenue 9,776.00 9,024.00 18,800.00 Expenses 6010101 149290 788001 63900 Transfer Out - Drain Equipment Fund 9,776.00 6010101 149300 788001 63900 Transfer Out - Drain Equipment Fund 9,024.00 Total Expenses 18,800.00
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dent ID Program Acct Fund Aff Oper Unit Account Name PONTIAC WATER FUND (#57234) Revenue 6010101 149030 665882 Planned Use of Balance Total Revenue Expenses 6010101 149030 788001 63900 Transfer Out - Drain Equipment Fund Total Expenses 3,196.00 3,196.00 3,196.00 3,196.00 PONTIAC SEWER/VVWTP FUND (#57434) Expenses 6010101 149030 788001 63900 6010101 149030 796500 63900 Transfer Out - Drain Equipment Fund Budgeted Equity Adjustment Total Expenses 6,016.00 (6,016.00) CLINTON OAKLAND SDS FUND (#58600) Revenue 6010101 149667 665882 Planned Use of Balance Total Revenue 15,886.00 15,886.00 Expenses 6010101 149667 788001 63900 Transfer Out - Drain Equipment Fund 15,886.00 Total Expenses 15,886.00 EVERGREEN FARMINGTON SDS FUND (#58410) Revenue 6010101 149667 665882 Planned Use of Balance Total Revenue 20,962.00 20,962.00 Expenses 6010101 149667 788001 63900 Transfer Out - Drain Equipment Fund $ 20,962.00 Total Expenses $ 20,962.00
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS [PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Prodram Acct Fund Aft Oper Unit Account Name GWK SOUTHEASTERN SDS FUND (#58510) Revenue 6010101 149667 665882 Planned Use of Balance Total Revenue Expenses 6010101 149667 788001 63900 Transfer Out - Drain Equipment Fund Total Expenses 25,756.00 25,756.00 25,756.00 25,756.00 HURON ROUGE SDS FUND (#58700) Revenue 6010101 149667 665882 Planned Use of Balance 3,384.00 Total Revenue 3,384.00 Expenses 6010101 149667 788001 63900 Transfer Out - Drain Equipment Fund 3,384.00 Total Expenses 3,384.00 PONTIAC SEWER FUND (57434) Revenue 6010101 149030 665882 Planned Use of Balance Total Revenue (17,132.00) (17,132.00) Expenses 6010101 149030 796500 Budgeted Equity Adjustment Total Expenses (17,132.00) (17,132.00) SOCSDS POLLUTION CONTROL FUND (58520) Revenue 6010101 149030 665882 Planned Use of Balance Total Revenue (8,121.00) (8,121.00) Expenses 6010101 149030 796500 Budgeted Equity Adjustment Total Expenses (8,121.00) (8,121.00)
ACCOUNT NUMBER FY 2016 FY 2017 AMENDMENTS AMENDMENTS OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS Planned Use of Balance Dept ID Program Acct Fund Aff Oper Unit Account Name BUILDING LIABILITY INSURANCE (#67700) Revenue 9015501 182210 665882 $ 15,800,00 $ 15,800.00 $ 15,800.00 1 llli.Uli Expendable Equipment I otai expenses Expenses 1010502 182000 750154 $ $ $ $ 24,200.00 24,200.00 24,200.00 24,200.00 Planned Use of Balance Total Revenue Medical Supplies Total Expenses Revenue 9015501 182210 665882 Expenses 1010502 182000 750301 SCHEDULE B PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Total Revenue INFORMATION TECHNOLOGY (#63600) Expenses 63600 1080601 152090 730646 63600 1080201 152030 731780 Revenue 63600 1080101 152000 665882 Expenses 63600 1080201 152010 731458 $ (109,000.00) $ 109,000.00 $ $ 650,000.00 $ 650,000.00 $ 650,000 00 $ 650,000 00 Equipment Maintenance Software Maintenance Total Expenses Planned Use of Balance Total Revenue Professional Svcs Total Expenses
FY 2016 FY 2017 AMENDMENTS AMENDMENTS FY 2015 AMENDMENTS 152000 730324 152000 731458 TELEPHONE COMMUNICATIONS (#67500) Expenses 67500 1080601 67500 1080601 (4,000.00) 4,000.00 Communications Professional Services Total Expenses (41,345.00) 41,345.00 Professional Services Transfer Out-Project Work Order Fund Total Expenditures 41,345.00 41,345.00 Transfer In Total Revenue 41,345.00 41,345.00 Budget Equity Adjustment Total Expenditures Transfers In - 0R250 45.00 Domestic Preparedness Equipment Fund #29340 GR #0000000248 Bud Ref 2004 PCBU Grant Activity GLB Analysis Type GLB Revenue 1010115 115080 695500 29340 Total Revenue 45.00 SCHEDULE B ACCOUNT NUMBER REGISTER OF DEEDS AUTOMATION (#21160) Expenditures 2010401 172220 731458 2010401 172220 788001 40400 FM8.0 PROJECT WORK ORDER (#40400) Project ID#100000002200 Revenue 1040101 148020 695500 21160 Expenditures 1040101 148020 796500 97,100.00 80,000.00 (177,100.00) OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund All Oper Unit Account Name MOTOR POOL (#661001 Expenses 1030811 184010 730947 Insurance Reserve Exp 1030811 184010 731878 Sublet Repair 1030811 184010 750210 Gasoline Charges Total Expenses
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Expenditures 1010115 115080 796500 Budgeted Equity Adjustment Total Expenditures GR #0000000250 Bud Ref 2005 PCBU Grant Activity GLB Analysis Type GLB Revenue 1010115 115120 665882 Planned Use of Balance Total Revenue 45.00 45.00 1,740.00 1,740.00 Expenditures 1010115 115120 1010115 115120 1010115 115120 788001 788001 788001 29340 29330 10100 Transfer Out - GR248 Transfer Out - GR486 Transfer Out - General Fund Total Expenditures 45.00 6.00 1,689.00 1,740.00 GR #0000000343 Bud Ref 2007 PCBU Grant Activity GLB Analysis Type GLB Revenue 1010115 115095 665882 Planned Use of Balance Total Revenue 173,649.00 173,649.00 Expenditures 1010115 115095 788001 29340 Transfer Out - GR397 77,492.00 1010115 115095 788001 29340 Transfer Out - GR398 60,170.00 1010115 115095 788001 29340 Transfer Out - GR399 35,987.00 Total Expenditures 173,649,00
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name GR #0000000397 Bud Ref 2008 PCBU Grant Activity GLB Analysis Type GLB Revenue 1060601 115125 695500 29340 Transfers In GR343 Total Revenue 77,492.00 77,492.00 Expenditures 1060601 115125 796500 Budgeted Equity Adjustment 77,492.00 Total Expenditures 77,492.00 GR #0000000398 Bud Ref 2007 PCBU Grant Activity GLB Analysis Type GLB Revenue 1060601 115126 695500 29340 Transfers In - GR343 60,170.00 Total Revenue 60,170.00 Expenditures 1060601 115126 796500 Budgeted Equity Adjustment 60,170.00 Total Expenditures 60,170.00 GR #0000000399 Bud Ref 2007 PCBU Grant Activity GLB Analysis Type GLB Revenue 1060601 115127 695500 10100 1060601 115127 695500 29340 1060601 115127 695500 29340 1060601 115127 695500 29340 1060601 115127 695500 29340 1060601 115127 695500 29340 Expenditures 1060601 115127 796500 Transfers In - General Fund Transfers In - GR343 Transfers In - GR454 Transfers In - GR496 Transfers In - GR497 Transfers In - GR629 Total Revenue 1,431.00 35,987.00 9,412.00 559.00 1,535.00 11,021.00 59,945.00 Budgeted Equity Adjustment Total Expenditures 59,945.00 59,945.00
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS [PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name GR #0000000453 Bud Ref 2008 PCBU Grant Activity GLB Analysis Type GLB Revenue 1060601 115127 695500 10100 Transfers In - General Fund 1060601 115127 695500 29340 Transfers In - GR629 Total Revenue 50,877.00 3,858.00 54,735.00 Expenditures 1060601 115127 796500 Budgeted Equity Adjustment 54,735.00 Total Expenditures 54,735.00 GR #0000000454 Bud Ref 2009 PCBU Grant Activity GLB Analysis Type GLB Revenue 1060601 115126 665882 Planned Use of Balance Total Revenue 9,412.00 9,412.00 Expenditures 1060601 115126 788001 29340 Transfer Out - GR399 Total Expenditures 9,412.00 9,412.00 GR #0000000455 Bud Ref 2008 PCBU Grant Activity GLB Analysis Type GLB Revenue 1060601 115125 695500 10100 Transfers In - General Fund Total Revenue 3,217.00 3,217.00 Expenditures 1060601 115125 796500 Budgeted Equity Adjustment 3,217.00 Total Expenditures 3,217.00
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aft Oper Unit Account Name GR #0000000496 Bud Ref 2009 PCBU Grant Activity GLB Analysis Type GLB Revenue 1060601 115125 665882 Planned Use of Balance Total Revenue 559.00 559.00 Expenditures 1060601 115125 788001 29340 Transfer Out - GR399 Total Expenditures Total Revenue GR #0000000497 Bud Ref 2010 PCBU Grant Activity GLB Analysis Type GLB Revenue 1060601 115127 665882 Planned Use of Balance $ 559.00 $ 559.00 $ 1,535.00 $ 1,535.00 Expenditures 1060601 115127 788001 29340 Transfer Out - GR399 $ 1,535.00 Total Expenditures $ 1,535.00 GR #0000000498 Bud Ref 2009 PCBU Grant Activity GLB Analysis Type GLB Revenue 1060601 115126 695500 10100 Transfers In - General Fund Total Revenue $ 5,152.00 $ 5,152.00 Expenditures 1060601 115126 796500 Budgeted Equity Adjustment $ 5,152.00 Total Expenditures 5,152.00
ACCOUNT NUMBER FY 2016 FY 2017 AMENDMENTS AMENDMENTS OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS Transfers In - General Fund GR #0000000594 Bud Ref 2012 PCBU Grant Activity GLB Analysis Type GLB Revenue 1060601 115127 695500 10100 Planned Use of Balance GR #0000000629 Bud Ref 2013 PCBU Grant Activity GLB Analysis Type GLB Revenue 1060601 115125 665882 11,021.00 3,858.00 14,879.00 Transfer Out - GR399 Transfer Out - GR453 Total Expenditures Expenditures 1060601 115125 788001 29340 1060601 115125 788001 29340 SCHEDULE B PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name GR #0000000568 Bud Ref 2011 PCBU Grant Activity GLB Analysis Type GLB Revenue 1060601 115095 695500 10100 Expenditures 1060601 115095 796500 Expenditures 1060601 115127 796500 Transfers In - General Fund Total Revenue Budgeted Equity Adjustment Total Expenditures Budgeted Equity Adjustment Total Expenditures Total Revenue Total Revenue 307.00 307.00 307.00 307.00 15,584.00 15,584.00 15,584.00 15,584.00 14,879.00 14,879.00
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2015 THIRD QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2015 AMENDMENTS FY 2016 FY 2017 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name FEMA Grants #29330 GR #0000000252 Bud Ref 2004 PCBU Grant Activity GLB Analysis Type GLB Revenue 1010115 115080 665882 Planned Use of Balance 1.00 Total Revenue 1.00 Expenditures 1010115 115080 788001 10100 Transfer Out - General Fund 1.00 Total Expenditures 1.00 GR #0000000255 Bud Ref 2004 PCBU Grant Activity GLB Analysis Type GLB Revenue 1010115 115080 665882 Planned Use of Balance Total Revenue 572.00 572.00 Expenditures 1010115 115080 788001 10100 Transfer Out - General Fund Total Expenditures GR #0000000486 Bud Ref 2009 PCBU Grant Activity GLB Analysis Type GLB Revenue 1010115 115095 695500 29340 Transfers In - GR250 Total Revenue 572.00 572.00 6.00 6.00 Expenditures 1010115 115095 796500 Budgeted Equity Adjustment 6.00 Total Expenditures 6.00
0.95% $ 400,614,451.00 $ 3,770,584.00 388,226,553.00 $ 396,843,867.00 SUB-TOTAL GENERAL FUND/GENERAL PURPOSE $
0,00% $ 34,115,409.00 $ 39,638,852.13 $ 39,638,852.13 PLANNED USE OF FUND BALANCE
0.86% $ 436,482,719.13 $ 440,253,303.13 3,770,584.00 $ 422,341,962.00 TOTAL GFIGP FUNDS
$ 50,255,654.00
16,121,116.00
5,976,991.00
$ 72,353,761.00
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
52nd District Court
Probate Court
TOTAL ADMIN. OF JUSTICE
$ 50,866,393,00 $ 43,781,393 00 $ 7,085,000,00 13.93%
16,374,647.00 15,666647.00 708,000.00 4.32%
6,139,889,00 5,993,889.00 146,000.00 2.38%
$ 73,380,929.00 $ 65,441,929.00 $ 7,939,000.00 10.82%
LAW ENFORCEMENT
Prosecuting Attorney
Sheriff
3.98% 18,223,862.00
135,661,194.97
18,978,762,00
137,257,894.97
18,851,506.00
133,840,273.00
754,900.00
1,596,700.00
1.51% $ 162,691,779.00 $ 166,236,656.97 $ 153,885,056.97 $ 2,351,600.00 TOTAL LAW ENFORCEMENT
4.81% $ 29,818,797.99 $ 28,384,893.99 $ 1,433,904.00 $ 27,816,979.00 TOTAL GENERAL GOVERNMENT
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTALS 0.92% 519,030,00 55,599,865.00 56,118,895.00 51,364,190.00
4.80% 416,541,737.13 $ 20,940,982.00 TOTAL GOVERNMENTAL EXPENDITURES 436,482,719.13 $ 422,341,962.00
COUNTY OF OAKLAND
FY 2015 THIRD QUARTER REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2015
ADOPTED
BUDGET
BUDGET
AS
AMENDED
FY 2015
FORECAST
AMOUNT
FAVORABLE/
(UNFAVORABLE) PERCENT
REVENUES
GENERAL FUND
Taxes
Federal Grants
State Grants
Other Intergovernmental Revenue
Charges for Services
Indirect Cost Recovery
Investment Income
Other Revenues
$ 209,419,939.00
565,647 00
19,466,588.00
21,367871.00
103,815,319.00
7,800,000.00
1,864,900.00
23,926,289.00
$ 209,467,939.00
612,074.00
19,904,300.00
27,493,628.00
105,188,788.00
7,800,000.00
1,864,900.00
24,512,238.00
$ 206,794,939.00
636,874.00
18,491,800,00
31,720,293.00
108,520,286.00
7,800,000.00
1,995,500,00
24,652,759.00
$ (2,673,000.00)
26,800.00
(1,412,500.00)
4,226,665.00
3,331,498.00
130,600.00
140,521.00
-1.28%
4.38%
-7.10%
15,37%
3.17%
0.00%
7.00%
0.57%
GENERAL GOVERNMENT
Clerk/Register of Deeds
Treasurer
Board of Commissioners
Library Board
Water Resources Commissioner
10,215,808,00
8,487,522.00
2,722,883.00
1,334,523.00
5,056,243.00
10,365,919.00
10,174,607.00
2,749,855.99
1,297,238.00
5,231,178.00
9,227,419.00
9,872,307 00
2,710,555.99
1,297,238.00
5,277,374.00
1,138,500.00
302,300.00
39,300,00
(46,196.00)
10,98%
2.97%
1,43%
0,00%
-0.88%
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
TOTAL COUNTY EXECUTIVE
TOTAL DEPARTMENTS
$ 6,780,436,00
18,880,613.00
2,427,361 00
1,226,514.00
4,088,980,00
61,002,688.00
16,099,835,00
7,608,826,00
$ 118,115,253.00
$ 370,977,772.00
$ 7,235,842.84
19,370,412.00
2,479,190.00
1,226,610.00
4,235,831.00
61,618,507.00
16,655,134.00
8,105,913.33
$ 6,776,842.84
17,289,912.00
2,414,790.00
1,206,110,00
3,850,831.00
56,763,359.00
16,259,134.00
7,669,013.33
459,000.00
2,080,500.00
64,400.00
20,500.00
385,000.00
4,855,148.00
396,000.00
436,900.00
$ 120,927,440.17 $ 112,229,992.17 $ 8,697,448.00
$ 380,363,824.13 $ 359,941,872.13 $ 20,421,952.00
6,34%
10.74%
2.60%
1.67%
9.09%
7.88%
2,38%
5.39%
7.19%
5.37%
General Fund/General Purpose
Favorable/(Unfavorable) - Budget Perspective
GAAP Required Adjustment (eliminating use of fund balance "revenue")
GAAP - BASED REPORT (forecasted impact on Fund Balance)
24,711,666.00 $ 24,711,566.00
$ (39,638,852.13) $ (39,638,852.13)
$ (14,927,286.13) ($14,927,286.13)_
Other Taxes - Trailer Tax Total Taxes 80,000.00 80,000.00 80,000.00 $ 209,419,939.00 $ 209,467,939.00 $ 206,794,939.00 $ (2,673,000.00) 0.00% -1.28% 82,000.00 85,500.00 49,940.00 48,207.00 300,000.00 565,647.00 $ 82,000.00 85,500.00 51,380.00 93,194.00 300,000.00 612,074.00 $ 450.00 1,000.00 1,000.00 86,600.00 85,500.00 4,542,255.00 4,496,912.00 90,000.00 90,000.00 COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2015 THIRD QUARTER REPORT Amount Adopted Amended FY 2015 Favorable Budget Budget Forecast (unfavorable) Percent Explanation of Significant Variances TAXES (601000-601999) Property Taxes - July Tax Levy Other Taxes - Delinquent Tax - Prior Years $ 209,066439.00 $ 209,066,439 00 $ 206,066,439.00 $ (3,000,000.00) 98,500.00 98,500.00 98,500.00 -1.43% Unfav. due to millage reduction per MR #15052; partially offset by countywide taxable value increase which was a 0.7% improvement over the adopted budget amount. 0.00% Treasurer Payment in Lieu of Taxes 175,000.00 223,000.00 650,000.00 327,000.00 146.64% Fav. due to tax payments from the state on DNR land. FEDERAL GRANTS (610000-610999) Sheriff Prosecuting Attorney 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 58,800.00 $ (23,200.00) 85,500.00 90,380.00 39,000.00 89,194.00 (4,000.00) 315,000.00 15,000.00 638,874.00 $ 26,800.00 450.00 $ 1,000.00 85,500 00 4,496,912.00 90,000.00 -28.29% Unfav. State Criminal Alien Assist Program and Bullet Proof Vests due to reduced grant awards. 0.00% 75.91% Fay. Disaster Control Fed Subsidy primarily due to accrued variance for 2015 Emergency Management Performance Grant (EMPG). -4,29% Unfav. Federal Operating Grants as renewal of operator certifications for Type II water will not be fully realized. 5.00% Fay. Refunds School Meals (lunch program) due to increase in per meal reimbursement from the State. 4.38% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Non-Departmental - Child Care Subsidy Total State Grants 14,747,833.00 19,466,588.00 $ -9.27°A 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. 15,230,438.00 13,817,938.00 (1,412,500.00) 19,904,300.00 $ 18,491,800.00 $ (1,412,500.00) -7.10% 1 of 1541/2015
COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2015 THIRD QUARTER REPORT Amount Adopted Amended FY 2015 Favorable Budget Budget Forecast (unfavorable) Percent Explanation of Significant Variances OTHER INTER-GOVERNMENTAL REVENUES (620000 - 626999) Non-Departmental 19,092,476.00 25,218,233.00 $ 29,470,233.00 $ 4,252,000.00 54.000 00 29,665.00 (24,335.00) 4,500.00 4,500.00 - 1,800.00 1,800.00 - 300,000.00 299,000.00 (1,000.00) 16.86% Fav Revenue Sharing $2,200,000 from the State of Michigan partially offset by unfav Cigarette Tax Distribution ($48,000). Fav Convention Facility Liquor Tax $2,100,000 which is offset by unfavorable Substance Abuse Coord Agency expenditures for required payments to Oakland County Community Mental Health Authority_ A budget amendment is recommended. -45.06% Unfav. Local Match due to the installation of fewer than anticipated sirens. Offset by expenditure favorability (Tornado Siren Equip). 0.00% 0.00% -0.33% Unfav. Due to lower Marine Safety grant award of ($60,000) partially offset by Fav. increase in Social Security Incentive Payment receipts of $59,000. HHS - Homeland Security 54,000.00 Circuit Court 4,500.00 District Court 1,800.00 Sheriff 300,000.00 Non-Departmental - Reimb Judges Salaries 1,915,096.00 1,915,095.00 Total Other Intergovernmental Revenue 21,367,871.00 $ 27,493,628.00 $ 1,915,095.00 31,720,293.00 $ 4,226,665.00 0.00% 15.37% CHARGES FOR SERVICES (630000-6359991 Administration of Justice Circuit Court - CivillCriminal 2,786,000.00 $ 2,896,000.00 $ 2,826,000.00 $ (70,000.00) -2.42% Unfav. Court Costs ($100,000) and Civil Mediation Payments ($60,000) due to a reduction in civil/criminal caseload; partially offset by Refund Fees PD Def Attorney $70,000 and Fay. E Filing Fees $20,000 due to an increase in activity. Circuit Court - Family Division 1,947,000.00 1,947,000.00 1,877,000.00 (70,000.00) -3.60% Unfav. Refund Fees PD Del Attorney ($35,000), Court Service Fees Probation ($25,000), and Reimb Clinical Evaluations ($10,000) due to a reduction in family caseload. 2 of 15 422015
COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2015 THIRD QUARTER REPORT District Court - Division I (Novi) Adopted Budget 4,458,000.00 Amended Budget 4,458,000.00 Amount FY 2015 Favorable Forecast (unfavorable l Percent Explanation of Significant Variances 3,943,000.00 (515,000.00) -11_55% Unfav. Probation Fees ($220,000) due to a decrease in the public's ability to pay, Assessment Fees ($210,000) due to assessing a fee on Sobriety Court participants only rather than all convicted drinking and driving offenders, Ordinance Fines and Costs ($130,000) based on historical collection for the past several years, Assessments and PSI ($80,000) due to a statutory change allowing these assessments for specific offenses only and Filing Fees DCU ($40,000) due to a decrease in the number of civil cases filed; partially offset by Fav. State Law Costs $115,000 due to an increase in State violation caseload and Late Penalty $50,000 based on collection for the past two years. District Court - Division II (Clarkston) District Court - Division III (Rochester Hills) 1,668,200.00 3,784,935.00 1,668,200.00 3,784,935.00 1,778,200.00 3,669,936.00 110,000 00 (115,000.00) 6.59% Fav. Ordinance Fines and Costs $100,000 based on historical collection. Also Fay. State Law Costs $80,000 due to an increase in State violation caseload; partially offset by Unfav. Assessment Fees ($20,000) due to assessing a fee or Sobriety Court participants only rather than all convicted drinking and driving offenders, Garnishment Fees ($30,000) and Filing Fees DCU ($20,000) due to a decrease in the number of civil cases filed. -3.04% Unfav. State Law Costs ($80,000) due to late fee assessed incorrectly, Assessments and PSI ($70,000) due to a statutory change allowing these assessments for specific offenses only. Also Unfav. Probation Fees ($30,000) due to a decline in caseload. In addition, Unfav. Garnishment Fees ($30,000) and Filing Fees DCU ($30,000) due to a decrease in the number of civil cases filed. Unfavorability is partially offset by Fav Ordinance Fines and Costs $110,000 and Late Penalty $15,000 based on collection efforts. 3 of 15 432015
COUNTY OF OAKLAND GENERAL FUND I GENERAL PURPOSE REVENUES FY 2015 THIRD QUARTER REPORT District Court - Division IV (Troy) Adopted Budget 2,285,050.00 Amended Budget 2,285,050.00 FY 2015 Forecast 2,280,050.00 Amount Favorable (unfavorable) Percent Explanation of Significant Variances (5,000.00) -0.22% Unfav. Probation Fees ($50,000) due to a decline in caseload and Ordinance Fines and Costs ($20,000) due to the People vs. Cunningham impact. Also Unfav. Garnishment Fees ($20,000) and Filing Fees DCU ($5,000) due to a decrease in the number of civil cases filed. These are partially offset by Fay. Refund Fees PD Def Attorney $60,000 due to an increase in public defender requests, Miscellaneous Rev $15,000, Drunk Driving Caseflow DDCAF $10,000 due to an increase in filings and Warrant Recall Fee $5,000 due to an increase in bench warrant appearances_ 0.00% -3.79% -11.96% Unfav, largely due to lower recovery revenue activity for FOIA and prosecution in the Reimbursement General account ($38,500). 78.95% Fay. receipt of unbudgeted Reimbursement General of $1,500. 83.19% Fav. Commissions Contracts of $112,000 due to food services contract for Jail Commissary commissions; increased Gun Registrations of $68,000; Fingerprints of $49,500 due to new teachers required to be fingerprinted; Photostats of $43,000 due to increased requests for copies of records and reports; Photographs of $6,000 due to increased request for crime scene photos and Fee Income of $3,000 from Jail/Records collections for indigent commissary items ordered by inmates; partially offset by decreased Registration Fees of ($11,200) from Sex Offender Registry fee required by state and Reimbursement Postage of ($4,000) resulting from Employee Suggestion savings from mailing inmate belongings to their residence (offset . Probate Court - Estates and Mental Health 507,600.00 507,600.00 507,600.00 Total Administration of Justice 17,436,785.00 $ 17,546,785.00 $ 13,881,755.00 $ (665,000.00) Law Enforcement Prosecuting Attorney 287,000.00 $ 322,000.00 283,500.00 $ (38,500.00) Sheriffs Office 1,900.00 1,900.00 3,400.00 1,500.00 Sheriff - Administrative Services 249,100.00 314,100.00 575,400.00 261,300.00 4 of 15442015
COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2015 THIRD QUARTER REPORT Sheriff- Corrective Services Adopted Budget 3,018,266.00 Amended Budget 3,018,266.00 FY 2015 Forecast 2,778,266.00 Amount Favorable funfavorablel Percent Explanation of Significant Variances (240,000.00) -7.95% Unfav, largely due to reduced receipts of Diverted Felon revenue of ($200,000) due to lower number of inmates with certain offenses that are billable to the State; Commissions Contracts of ($112,000) due to food services contract for Jail Commissary commissions; Fee Income of ($18,000) for Commissary goods collections from inmates accounts; Hospital Cost Recovery ($2,500) from inmates with ability to pay; and Miscellaneous of ($6,500) due to less than anticipated activity. Partially offset by favorable Board and Care receipts of $60,000 from inmates with ability to pay, Transportation of Prisoners of $3,000 collected from inmates with ability to pay for transportation; and Inmate Board and Care of $20,000 from inmates with ability to pay; and OUIL Third Offense of $16,000 which is a court driven assessment. Sheriff - Corrective Services Satellites Sheriff - Emergency Response and Prepared. 576,816.00 1,986,502.00 576,816.00 2,159,825.00 516,816.00 1,796,025.00 (60,000.00) (363,800.00) -10.40% Unfav. Board and Care receipts of ($60,000) received in the Corrective Services Div. -16.84% Unfav. receipts of Civil Action Service Fees of ($364,000) due to the decline in the number of foreclosures, and civil service requests (see corresponding favorability in Fees Civil Service expense). Sheriff - Patrol Services Sheriff - Investigative Forensic Services 46,235,675.00 813,391 00 47,216,104.00 813,391.00 47,189,604.00 924,091.00 (26,500.00) 110,700.00 -006% Unfav. OUIL Third Offense of ($35,000) due to less than anticipated activity; partially offset by favorable receipts of unbudgeted Fee Income of $5,800; Wrecker Service of $1,000 Reimbursement General $1,200 and Liquor Control Sheriff of $500. 13.61% Fay. largely Drug Testing of $186,100 collected from inmates with ability to pay; Confiscated Property $9,500; Miscellaneous $9,100 due to higher than anticipated activity; partially offset by Refund Forensic Lab Fees of ($50,000) and Forensic Lab Fees of ($44,000) due to the timing in start-up of the DNA Laboratory. Total Law Enforcement 53,168,650.00 $ 54,422,402.00 $ 54,067,102.00 $ (355,300.00) -0.65% 5 of 15 452015
COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2015 THIRD QUARTER REPORT Adopted Budget Amended Budget FY 2015 Forecast Amount Favorable (unfavorable} Percent Explanation of Significant Variances 9,600.00 (11,100.00) General Government Clerk - County Clerk Clerk - Elections 2,890,100.00 $ 2,890,100.00 $ 2,899,700.00 $ 96,500.00 96,500.00 85,400.00 0.33% Fav. Photographs $51,500, Forfeiture of Bonds $19,300, CVR County Portion $11,100 and Costs $9,500 due to increased activity. Partially offset by unfavorable Forfeiture of Surety Bonds ($50,000) and Assumed Names ($6,000) due to less than anticipated activity. Unfavorable Gun Permits ($26,000) due to PA 3 of 2015 which required the creation of Special Revenue Fund for Concealed Pistol Licenses activity. -11.50% Unfav. Board of Canvasser Service Fee ($11,000), Nominating Filing Forfeit ($6,000) and Voter Registration Application ($3,600) due to lass than anticipated activity. Partially offset by favorable Election Filing Fees Late $6,400 due to Corporation Counsel efforts to collect on late filers. Passport Fees $3,100 due to increased activity. Clerk - Register of Deeds & Micrographics Treasurer 9,287,250.00 6,349,200.00 9,287,250.00 6,301,200 00 10,081,250.00 8,397,900.00 794,000.00 2,096,700.00 8.55% Fay. Land Transfer Tax $1,000,000 due to increased activity. Partially offset by unfavorable Enhanced Access Fee ($200,000) and Tract Index ($6,000) due to reduced activity. 33.27% Fay. Payments Other Than Aniticipated $2,500,000 due sale of foreclosed property. Also, favorable Maintenance Contracts $100;000, Administration Fees $70,000, Deeds $6,900 and Photostats $1,800 due to anticipated increase in activity. Partially offset by unfavorable Civil Action Service Fees ($450,000) due to declining foreclosures, Title Search Fees ($100,000) due to less searches on delinquent parcels. in addition, Recording Fee Forfeiture Certifications ($16,000) and Recording Fee Redemption Certification ($16,000) due to lower number of delinquent properties. A budget amendment is recommended to adjust line items from the Charges for Services category accounts; Industrial Facilities Tax, Obsolete Property, TDRRZ Act 376, TIFA/DDA Recovery Ad Valorem and TIFA/DDA Recovery IFT to the Taxes category to accurately reflect budget with actual activity. 6 of 15 462015
COUNTY OF OAKLAND GENERAL FUND I GENERAL PURPOSE REVENUES FY 2015 THIRD QUARTER REPORT Board of Commissioners Library Board Water Resources Commissioner Adopted Budget 7,900.00 14,000.00 1,831_848.00 Amended Budget 7,900.00 14,000.00 1,831_848.00 FY 2015 Forecast 9,100.00 11,900.00 1,901,848.00 Amount Favorable funfavorable) Percent Explanation of Significant Variances 1,200.00 15.19% Hay, due to prescription program royalty fee income. A 3rd quarter budget amendment is recommended for Cornmisioners iPad purchase. (2,100.00) -15.00% Unfav. Copier Machine Charges ($2,000) and Miscellaneous ($1,600) lower usage due to on-line functionality and a-mailing documents. Offset by favorable Reimb Salaries $1,400 due to State Aid to Public Libraries. 70,000.00 3.82% Fay - Soil Erosion Fees $70,000 increase in building activity/permits due to improvement in the housing market. This is partially offset by unfavorable internal service and expenditures for CAMS maintenance. 14.48% 39.13% Fav Refunds Miscellaneous due to increased rate and usage for P-card and increased members in vendor incentive program. 0.00% 2.94% Fay Reimb Equalization Services due to parcels added to the assessment rolls resulting in additional revenue. 7.00% Fay Late Penalties 966,000 due to collection efforts by Reimbursement staff partially offset by unfavorable Court Ordered Board & Care ($20,000) based on activity. -4.44% Unfavorable Standard Mail ($15,300) due to loss of business with Oakland County Community Mental Health Authority (OCCMHA) (offset by favorable expenditure Mail Handling-Postage Service). Total General Government 20,476,798.00 $ 20,428,798.00 $ 23,387,098_00 $ 2,958,300.00 County Executive County Exec - Compliance Office 230,000.00 $ 230,000.00 $ 320,000 00 $ 90,000 00 County Exec - Corp Counsel M&B - Equalization Division 3,233,968.00 3,233,968.00 3,328,968.00 95,000.00 M&B - Fiscal Services Division 500,000.00 500,000.00 535,000.00 35,000.00 Central Services - Support Services 335,651 00 335,651.00 320,751.00 (14,900.00) Human Resources 475.00 475.00 475.00 0.00% HHS - Administration 0.00% 7 of 1547/2015
COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2015 THIRD QUARTER REPORT HHS - Health Division Adopted Budget 3,057,097.00 Amended Budget 3,060,598.00 FY 2015 Forecast 3,420,598.00 Amount Favorable (unfavorable) Percent Explanation of Significant Variances 360,000.00 11.76% Fav. Reimb General $400,000 due to grant administrative overhead. Fav. Flu 3rd Party $150,000 due to an increase in the number of individuals utilizing insurance as a form of payment for service. Fav. Permits 875,000; Food Service Licenses $50,000; and Inspection Fees $35,000 due to increased demand. Partially offset by unfav. Administration Fees ($100,000) due to billing methodology between Michigan Department of Health and Human Services and Oakland County Health Dept. Unfav. Diff Between Chg and 'nit Pay ($100,000) due to the difference between insurance billing and reimbursements. Unfav. Flu Vaccine Fees ($100,000) due to a decrease in the number of individuals utilizing cash and cash equivalent forms of payment for service, Unfav. Clinic Charges ($50,000) due to revenue being captured in Immunizations account. (20,000.00) (6,000.00) HHS - Children's Village HI-IS - Homeland Security Public Services - Veterans Services Public Services Community Corrections Public Services - MSU Extension Public Services - Medical Examiner 2,865.000.00 230,000.00 21,000.00 308,000.00 2,865,000.00 230,000_00 21,000.00 308,000.00 3,040,000.00 106.00 210,000.00 15,000.00 308,000.00 6.11% Fay. Out County Board and Care due to an increase in out of County DHS wards. 100.00% Fay, Educational Training due to revenue received for CPR supplies and equipment rental. 0.00% -8.70% Unfav. Charges for Services due to less than anticipated court referrals to the Weekend & Weekday Alternative for Misdemeanants (WWAM) program. -28.57% Unfav. Reimbursement General due to cancellation of the Fall Master Gardener Volunteer Program class in order to accommodate program updates. 0.00% 175,000.00 106.00 Public Services - Animal Control 886,495 00 686,495.00 886,495.00 0.00% Public Services - Circuit Court Probation 0.00% Economic Dev, & Comm. Affairs Adrnin 0.00% 6 of 15 482015
Economic Development Non-Departmental Total Investment Income 1,800,000.00 1,800,000.00 1,800,000.00 1,864,900.00 $ 1,864,900.00 $ 1,995,500.00 $ 130,600.00 0.00% 0.00% 7.00% COUNTY OF OAKLAND - GENERAL FUND / GENERAL PURPOSE REVENUES FY 2015 THIRD QUARTER REPORT Economic Dev. & Comm. Affairs - PEDS Adopted Budget 353.400.00 Amended Budget 405,410.00 FY 2015 Forecast 584,702.00 Amount Favorable (unfavorable) Percent pxplanation of Significant Variances 179,292.00 4-4.22% Fay. due to Economic Outlook, Medical Main Street revenue was moved from Donations to Seminars/Conferences to more accurately reflect coats. and Salesforce reimbursement for software Total County Executive Non-Departmental Non-Dept - Charges for Services Total Non-Departmental Total Charges for Services INDIRECT COST RECOVERY (640100) INVESTMENT INCOME (655000-655999) District Courts (Div. I - IV) Sheriff Corrective Services Sheriff Investigative/Technical Services Treasurer Cleric/Register of Deeds 12,021,086.00 $ 12,076,597.00 $ 12,970,095.00 $ 893,498.00 712,000.00 $ 714,206.00 1,214,206.00 500,000.00 712,000.00 $ 714,206.00 1,214,206.00 $ 500,000.00 105,188,788.00 $ 108,520,286.00 $ 3,331,498.00 7,800,000.00 7,800,000.00 $ 2,400.00 $ 2,400.00 $ 60,000.00 175,000.00 115,000.00 2,500.00 18,100 00 15,600.00 7.40% 70.01% Fav. Commission Public Telephone revenue greater than anticipated. 70.01% 3.17% 0.00% 0.00% 0.00% 0.00% 191.67% Fay, based on reallocation of interest income for land sale activity. 62400% Fay. Due to investment base and market rates adjustment. $ 103,815,319.00 $ 7,800,000.00 $ 2,400.00 $ 60,000,00 2,500.00 OTHER REVENUES (670000-695500) Circuit Court-Donations Circuit Court-County Auction District Court Probate Court Prosecuting Attorney Sheriff Office Sheriff - Administrative Services Sheriff Corrective Services Sheriff - Emergency Prep and Communications Sheriff - Patrol Services 5,000.00 6,000.00 76,778.00 $ 5,000.00 226,000.00 76,778.00 $ 13.00 50.00 6.00 16,600.00 100.00 229,600.00 0.00% 100.00% 5103..0000 100.00% Cash Overage 6.00 100.00% Cash Overage 0.00% 11,600.00 232.00% Fay. Enhancement Funds of $11,600 transferred from Restricted Funds to purchase law enforcement tactical equipment and training. 0.00% 100.00 100.00% Refund Prior Years Expenditures, 0.00% 3,600.00 1.59% Fay. Refund of Prior Years Expenditures of $1,600; Insurance Recoveries of $2,000 related to replacement of helicopter video antenna due to storm damage sustained in prior year. 9 of 15 492015
COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2015 THIRD QUARTER REPORT Sheriff - Investigative/Forensic Svc Clerk/Register of Deeds Treasurer Board of Commissioners Adopted Budget Amended Budget FY 2015 Forecast 67,400.00 3,200.00 4,200.00 Amount Favorable 'unfavorable' Percent Explanation of Significant Variances 67,400.00 100.00% Refund of Prior Years Expenditures of $48,500; and Donations of $18,800 from High Intensity Drug Traffic Area (HIDTA) grant for a Gas Chromatograph Mass Spectrometer for the DNA Lab. 3,200.00 100.00% Fav due to Cash Overages. 0.00% 4,200.00 100.00% Fay, contributions due to voluntary donations for elected officials fringe benefits. Library Board Water Resources Commissioner Human Resources Central Services - Support Services Facilities Management Engineering Health Division Children's Village 300.00 300.00 300.00 0.00% 0.00% 0.00% 0.00% 0.00% 100.00% Fay. Prior Years Revenue primarily due to correction for FY 2014 estimated administrative overhead cost distribution. 100.00% Fay. due to County Auction $187 and Refund Prior Years Expenditure $80 50,086.00 267.00 50,085.00 267.00 Homeland Security Public Services Public Services - Animal Control-Other Revenues Public Services - Animal Control-Transfers In Economic Development & Comm Affairs Economic Development - Contributions 168,240.00 Non Departmental - Donations - Non-Dept - Sundry 417,500.00 Sheriffs' Transfers 144,328.00 Treasurers Transfers 4,005,543.00 Non-Departmental - Transfers In 19,179,378.00 Total Other Revenues 23,926,289.00 $ 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.57% 85,765.00 168,240.00 417,500.00 340,584.00 4,005,543.00 19,186,528.00 24,512,238.00 86,765.00 168,240.00 417,500.00 340,584.00 4,005,543.00 '19,186.528.00 24,652,759.00 $ 140,521.00 2,552,227.13 37,086,625.00 PLANNED USE OF FUND BALANCE (665000-665999) Encumbrances and Carry forwards 2,552,227.13 Use of Prior Yrs Fund Balance 34,115,409.00 $ 37,086,625.00 Total Planned Use of Fund Balance $ 34,115,409.00 $ 39,638,852.13 $ 39,638,852.13 $ TOTAL GEN. FUND / GEN. PURPOSE REVENUE $ 422,341,962.00 $ 436,482,719.13 $ 440,253,303.13 $ 3,770 584.00 0.00% 0.00% 0,00% 0.86% 10 of 15 582015
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Judicial Administration Personnel Expenditures Operating Expenditures $ 8,414,182.00 $ 8,414,182.00 $ 7,814,182.00 $ 110,876.00 368,550.00 248,550.00 600,000.00 120,000.00 7.13% - Fay. due to underfilled and vacant positions. 32.56% - Fay. Expendable Equipment $100,000 due to lower than anticipated use and Fav. Special Projects $80,000 due to the distribution of Judicial Technology funds from the State and Judge On-Line project (MR #09017) used for courtroom technology improvements. Also Fav. Printing $15,000 and Office Supplies $15,000 due to efforts to reduce spending. These are partially offset by Unfav. Library Continuations ($90,000) due to higher than anticipated use. Internal Support Expenditures 321,802.00 380,326.00 380,326.00 0.00% - Transfer Out 76,778.00 76,778.00 0.00% $ 8,846,860.00 5 9,239,836.00 $ 8,519,836.00 $ 720,000.00 7.79% Business Division Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 1,748,494.00 5 1,719,892.00 $ 1,719,892.00 $ 77,234,00 77,234.00 42,234.00 161,880.00 164,293.00 164,293.00 0.00% - 35,000.00 45.32% - Fay. due to a reduction in the use of Visiting Judges $25,000, Computer Supplies $5,000, and Metered Postage $5,000 due to lower than anticipated use. 0.00% - $ 1,987,608.00 $ 1,961,419.00 $ 1,926,419.00 $ 35,000 00 1.78% (50,000.00) 1,190,000.00 40,000.00 Civil / Criminal Division Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out 5 1,752,676.00 $ 1,752,676.00 $ 1,802,676.00 $ 5,221,944.00 5,221,944.00 4,031,944.00 2,236,709.00 2,445,203.00 2,405,203.00 -2.85% - Unfav. Due to overfilled positions/staff changes. Also Unfav. due to an emergency salary position #3806 that is charged to this division, but not budgeted in Salary forecast. 22.79% - Fav. Defense Attorney Fee payments $800,000, Juror Fees and Mileage $250,000, Attorney Fees Mediators $80,000 and Computer Research Services 520,000 due to a decline in caseload. In addition, Fav. Office Supplies $20,000, Printing $20,000 and Metered Postage $20,000 due to lower than anticipated use. These are partially offset by Unfav. Prof. Services ($20,000) due to a higher than anticipated use. 1.64% - Fay. Info Tech Operations due to lower than anticipated use. $ 9,211,329.00 $ 9,419,823.00 $ 8,239,823.00 $ 1,180,000.00 12.53% 9/4/2015 51
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Family Division/Juvenile Maint Personnel Expenditures $ 10,894,494.00 5 10,928,121.00 $ 10,353,121.00 $ 575,000.00 5.26% - Fav. due to turnover and underfilled positions/vacancies Operating Expenditures 13,121,945.00 13,110,615.00 8,635,615.04 4,475,000.00 34.13% - Fav. due to decrease in placements to State Institutions $3,700,000 and Priv Institutions Residential $500,000. Also, Fav. Professional Services $100,404 due to a lower than anticipated use. In addition, fay. Defense Attorney Fee payments $100,000 and Fees Guardian Ad Litem $75,000 due to decrease in caseload; offset by unfavorable Non-Dept Child Care Subsidy Revenue (50% Reimbursement). Internal Support Expenditures 1,546,624.00 1,550,294.00 1,450,294.00 100,000.00 6.45% - Fav. Info Tech Operations due to lower than anticipated use. Transfer Out 4,646,794.00 4,656,285.00 4,656,285.00 0.00% - $ 30,209,857.00 $ 30,245,315.00 $ 25,095,315.00 $ 5,150,000.00 17.03% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 22,809,846.00 18,531,999.00 4,267,015.00 4,646,794.00 $ 22,814,871.00 18,778,343.00 4,540,116.00 4,733,063.00 $ 21,689,871.00 $ 12,958,343.00 4,400,116.00 4,733,062.00 1,125,000.00 5,820,000.00 140,000.00 4.93% 30.99% 3.08% 0.00% $ 50,255,654.00 $ 50,866,393.00 $ 43,781,393.00 $ 7,085,000.00 13.93% 9/4/2015 52
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES -- e.... ... .............n.rn n•••••.
, .'"' A" rrenen....0.1~non.•nnn•••••n•row.....................n.r.....,,r,orro:rarnen•nn•Vownwy.nnn,.........~..w...4.: District Court Administration Personnel Expenditures $ 203,583.00 $ 203,583.00 $ 203,583,00 $ - 0.00% - Operating Expenditures 7,300.00 7,300.00 7,300.00 - 0.00% Internal Support Expenditures - - - - 0.00% Transfers Out - - 0.00% Division I - Novi Personnel Expenditures Operating Expenditures $ 210,883.00 $ 210,883.00 $ 210,883.00 $ $ 4,107,055.00 $ 4,107,055.00 $ 3,837,055.00 $ 270,000.00 901,941.00 898,960.00 877,960.00 21,000.00 0.00% 6.57% - Fay. due to turnover and underfilled positions/vacancies. 2.34% - Fay. Electrical Service $5,000, Professional Services $5,000, Office Supplies $5,000, Equipment Maintenance $3,000 and Interpreter Fees $3,000 due to lower than anticipated use. 60,000.00 3.12% - Fay, due to turnover and undeffilled positions/vacancies. 53,000.00 8.36% - Fay. Defense Attorney Fees $20,000 due to restructured schedule for defense attorneys. Also Fay. Software Support Maintenance $8,000, Electrical Service $7,000, Travel and Conference $4,000, and Printing $4,000 is due to effort to keep costs down. In addition, Fav. Juror Fees and Mileage $3,000, Professional Services $3,000, Medical Exam $2,000, and Computer Research Service $2,000 is due to lower than anticipated use. Internal Support Expenditures Transfers Out Total Division 1 - Novi 352,254.00 511,894.00 511,894.00 0.00% - 11,095.00 11,095.00 0.00% - $ 5,361,250.00 $ 5,529,004.00 $ 5,238,004.00 $ 291,000.00 5.26% Division 2 - Clarkston Personnel Expenditures $ 1,924,781.00 $ 1,924,781.00 $ 1,864,781.00 $ Operating Expenditures 631,208.00 633,846.00 580,846.00 Internal Support Expenditures 196,123.00 228,190.00 228,190.00 0.00% Transfers Out 0.00% - Total Division 2- Clarkston $ 2,752,112.00 $ 2,786,817.00 $ 2,673,817.00 $ 113,000.00 4.05% 532015
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Division 3 - Rochester Hills Personnel Expenditures Operating Expenditures $ 3,730,634.00 $ 3,730,634.00 $ 3,520,634.00 $ 210,000.00 417,483.00 417,483.00 333,483.00 84,000.00 5.63% - Fav. due to turnover and underlined positions/vacancies. 20.12% - Fay. Defense Attorney Fees $25,000 due to a decrease in requests for appointed counsel. Also Fay. Juror Fees and Mileage $15,000, Postage-Standard Mailing $8,000, Travel and Conference $5,000, Printing $5,000, Software Support Maintenance $5,000, Office Supplies $5,000, and Computer Research Service $3,000 due to effort to keep costs down. In addition, Fay, Expendable Equipment $4,000, Bank Charges $3,000, Laboratory Supplies $3,000, Personal Mileage $2,000 and Periodicals Books Publ Sub $1,000 are due to lower than anticipated use. Internal Support Expenditures 733,223.00 750,778.00 750,778.00 0.00% - Transfers Out 0.00% $ 4,881,340.00 $ 4,898,895.00 $ 4,604,895.00 $ 294,000.00 6.00% Division 4 - Troy Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 2,183,425.00 $ 2,183,425.00 $ 2,163,425.00 $ 20,000.00 479,207.00 495,187.00 515,187,00 (20,000.00) 252,399.00 270,436.00 260,436.00 10,000.00 $ 2,915,531.00 $ 2,949,048.00 $ 2,939,048.00 $ 10,000.00 0.92% - Fay. due to turnover and underlined positions/vacancies. -4,04% - Unfav. Defense Attorney Fees ($30,000) due to an increase in requests for appointed counsel and Interpreter Fees ($5,000) due to higher than anticipated use; partially offset by Fay. Electrical Service $10,000 and Postage-Standard Mailing $5,000 due to lower than anticipated use. 3.70% - Fav. Info Tech Operations due to lower than anticipated use. 0.34% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 12,149,478.00 $ 12,149,478.00 $ 11,589,478.00 $ 2,437,139.00 2,452,776.00 2,314,776.00 1,534,499.00 1,761,298.00 1,751,298.00 11,095.00 11,095.00 $ 16,121,116.00 $ 16,374,647.00 $ 15,666,647,00 $ 560,000.00 4.61% 138,000.00 5.63% 10,000.00 0.57% 708,000.00 4.32% 542015
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES PROBATE COURT AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Judicial/Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out $ 2,301,583.00 $ 2,301,583.00 $ 2,271,583.00 $ 30,000.00 1.30% Fay. due to turnover and underfilled positions/vacancies. 29,481.00 29,481.00 13,481.00 16,000.00 54.27% Fay. Library Continuations $8,000 due to efforts to reduce spending, Visiting Judges $6,000 due to the Court limiting the use of visiting judges and Court Reporter Services $2,000 because substitute court reporters are not needed as often due to video courtrooms. 287,098.00 308,464.00 303,464.00 5,000.00 1.62% Fav. Info Tech Operations due to less than anticipated use. Estates/Mental Health Personnel Expenditures Operating Expenditures $ 2,618,162.00 $ 2,639,528.00 $ 2,588,528.00 $ 51,000.00 1.93% $ 2,022,586.00 $ 2,022,586.00 $ 1,922,586.00 $ 100,000.00 4.94% 709,943.00 791,943.00 796,943.00 (5,000.00) -0.63% Fay. due to turnover and underfilted positions/vacancies. Unfav. Medical Services Guardianship ($7,000), Medical Services Probate Exam ($6,000) and Interpreter Fees ($5,000) due to a continued high demand for these services; partially offset by Fay. Printing $8,000 and Fees Guardian Ad Litem $5,000. Internal Support Expenditures 626,300.00 685,832.00 685,832.00 0,00% $ 3,358,829.00 $ 3,500,361.00 $ 3,405,361.00 $ 95,000.00 2.71% Department Total Personnel Expenditures $ 4,324,169.00 $ 4,324,169.00 $ 4,194,169.00 $ 130,000.00 3.01% Operating Expenditures 739,424.00 821,424.00 810,424.00 11,000.00 1.34% Internal Support Expenditures 913,398.00 994,296.00 989,296.00 5,000.00 0.50% Transfer Out - - $ 5,976,991.00 $ 6,139,889.00 $ 5,993,889.00 $ 146,000.00 2.38% 9/4/2015 55
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures 8 2,182,099.00 $ 2,182,099.00 $ 2,121,599.00 $ 60,500.00 2.77% Favorable due largely fit: a number of underfilled positions and personnel working across divisional disciplines as assigned. 515,213.00 515,213.00 476,213.00 39,000.00 7.57% Favorable Training $17,000, Travel & Conference $15,000, Witness Fees and Mileage $15,000, Professional Services $10,000, Filing Fees $10,000, Printing $8,900, Office Supplies $7,000, Expendable Equipment $5,000, Security Supplies $5,000, Personal Mileage $4,400, Microfilming & Reproduction $3,000 &Transcript on Appeals $3,000 due to less than anticipated use. Partially offset by Unfavorable Library Continuations ($28,600), Extradition Expense ($23,000) and Expert Witness Fee & Mileage ($12,000) due to increased activity. Internal Support Expenditures 1,754,573.00 1,804,829.00 1,804,829.00 0.00% Transfers Litigation Personnel Expenditures 77,000.00 77,000.00 ----------- ------------- ------------ 4,451,885.00 $ 4,579,141.00 8 4,479,641.00 $ 99,500.00 $ 9,569,771.00 $ 9,569,771.00 $ 9,139,171.00 $ 430,600.00 0.00% 2.17% 4.50% Favorable due largely to a number of underfilled positions and positions assigned to this division but actually working across divisional disciplines. Operating Expenditures 33,296.00 33,296.00 26,698.00 6,600.00 19.82% Favorable primarily due to less than anticipated use in Personal Mileage; partially offset in other divisions. Internal Support Expenditures Transfers Out Warrants Personnel Expenditures 855,589.00 855,589.00 855,589.00 -------------- ------------ ------------- ---------------- $ 10,458,656.00 $ 10,458,656.00 $ 10,021,456.00 $ 437,200.00 $ 2,152,545.00 $ 2,152,545.00 $ 2,042,845.00 $ 109,700.00 0.00% 0.00% 4.18% 5.10% Favorable due largely to a number of underfilled positions and positions assigned to this division but actually working across divisional disciplines. Operating Expenditures 3,199.00 3,199.00 3,499.00 (300.00) -9.38% Unfavorable due to greater than anticipated use in Personal Mileage; offset in litigation division. Internal Support Expenditures 0.00% $ 2,155,744.00 $ 2,155,744.00 $ 2,046,344.00 $ 109,400.00 5.07% 9/4/2015 56
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Appellate Personnel Expenditures $ 1.776,763.00 $ 1,776,763.00 $ 1,672,363.00 $ 104,400.00 5.88% Favorable due largely to a number of undertilled positions and positions assigned to this division but actually working across divisional disciplines. Operating Expenditures 8,458,00 8,458.00 4,068.00 4,400.00 52.02% Favorable due to less than anticipated use in Personal Mileage; offset in litigation division. Internal Support Expenditures 0.00% 8 1,785,221.00 $ 1,785,221.00 $ 1,676,421.00 $ 108,800.00 6.09% Department Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 15,681,178.00 560,166,00 1,754,573.00 855,589.00 18,851,506.00 $ 15,681,178.00 $ 14,975,978.00 $ 705,200.00 560,166.00 610,466.00 49,700.00 1,804,829.00 1,804,829.00 932,589.00 932,689.00 -------------- ---------- ------------ $ 18,978,762.00 $ 18,223,862.00 $ 754,900,00 4.50% 8.87% 0.00% 0.00% 3.98% 9/4/2015 57
ADOPTED BUDGET AMENDED BUDGET FY 2015 FORECAST Internal Support Expenditures Transfers Out Corrective Services Personnel Expenditures 237,537.00 237,537.00 130,637.00 106,900.00 45.00% 0.00% $ 3,500,617.00 $ 3,804,578.97 $ 3,537,578.97 $ 267,000.00 7.02% 30,244,662.00 $ 30,195,436.00 $ 29,886,436.00 309,000.00 1.02% couNTy OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Sheriffs Office Personnel Expenditures $ 1,664,024.00 $ 1,664,024.00 $ 1,605,524.00 $ 58,500,00 3.52% Favorable salaries due to turnover $25,800, favorable projected overtime of $12,800 and favorable fringe benefits of $19,900. The fringe benefit variance is largely due to retirement of $19,400 Social Security of $4,400; and Overtime Fringes of $4,800; partially offset by unfavorable Hospitalization of ($8,700). Operating Expenditures Internal Support Expenditures Transfers Out 68,236.00 318,690.00 68,236.00 318,690.00 68,236.00 413,690.00 0,00% (95,000.00) -29.81% 0.00% Unfavorable in Info. Tech. Operations of ($88,100) and Motor Pool of ($6,900) due to budget allocations between Sheriffs Office divisions. $ 2,050,950.00 $ 2,050,950.00 $ 2,087,450.00 $ (36,500.00) -1.78% 5.16% Favorable salaries due to turnover, vacant and undeffilled positions. 3.56% Favorable largely in Printing $37,000; Uniform Cleaning of $35,000; Professional Svcs of $12,500 and Office Supplies of $2,200 due to less than anticipated use. Partially offset by unfavorable Contracted Svcs of ($19,700); Personal Mileage of ($2,600); Membership Dues of ($1,300); Periodicals Books & Publication Subscriptions of ($1,100) and Uniforms of ($8,600) due to increased usage. Administrative Services Personnel Expenditures $ 2,055,342.00 $ 2,067,480.00 $ 1,960,780.00 106,700.00 Operating Expenditures 1,207,738.00 1,499,561.97 1,446,161.97 53,400.00 Favorable Info, Tech. Operations of $117,700 partially offset by unfavorable Info. Tech, Managed Print Svcs of ($10,300). Favorable salary expense of $2,457,600; and fringe benefits of $152,700 is due to the large number of vacancies and deputies on short term leave or worker's compensation. This is partially offset by unfavorable Overtime usage of ($2,301,300) to cover the vacant positions. The two Corrections Divisions currently have 23 employees on short term disability and 15 vacant positions. The vacancy rate is declining as more deputies complete the Corrections Academy and others return from disability. New deputies are required to complete 13 weeks of additional training and certification prior to assuming official duties. Hiring, training and retaining Corrections Deputies, and filling-in for deputies on disability is the major factor contributing to the high use of overtime. 9/4/2015 58
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE EXPLANATION OF SIGNIFICANT VARIANCES Favorable largely in Contracted Services of $797,200 related to savings in the Jail Food and Jail Clinic contracts. Also, lower need for Prisoner Housing Outside of County of $100,000; favorable Transportation of Prisoners of $21,000, Bedding and Linen of $20,000; Laundry and Cleaning of $19,000; Personal Mileage of $1,800; Printing of $1,600 and Adjustment of Prior Year's Expense of $1,600; partially offset by unfavorable for Officer Training of ($41,600); Equipment Maintenance of ($10,000), Interpreter Fees of ($2,900) and Adjustment of Prior Year's Revenue of ($3,500). AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Operating Expenditures 8,231,031.00 8,157,945.00 7,253,745.00 904,200.00 11.08% Internal Support Expenditures 7,095,128.00 7,466,840.00 7,411,440.00 55,400.00 0.74% Favorable in Info, Tech. Managed Print Service of $24,800; Radio Communications of $30,600. Transfers Out 18,862.00 18,86100 0.00% $ 45,570,821.00 $ 45,839,083.00 $ 44,570,483.00 $ 1,268,600.00 2.77% Corrective Services-Satellites Personnel Expenditures $ 11,520,119.00 $ 11,610,571.00 $ 12,884,271.00 $ (1,273,700.00) -10.97% Unfavorable due to increased usage of overtime at the Corrective Services Satellite facilities ($1,088,600) caused by Hospital Watch, vacant positions, prisoner transport, employee disability and other leaves, security at Animal Control and East Annex security; and overtime related fringe benefits ($415,800). Partially offset by favorable regular salaries of $230,700. Hiring, training and retaining Corrections Deputies, and filling-in for deputies out on disability has been a major factor contributing to the high use of overtime, Operating Expenditures 80,750.00 86,625.00 64,825.00 21,800.00 25.17% Favorable Laundry and Cleaning of $25,500 for laundry soap and supplies, partially offset by unfavorable Travel Employee Taxable Meals of ($3,700). Internal Support Expenditures 979,245.00 984,690.00 997,190.00 (12,500.00) -1.27% Unfavorable Info, Tech. Operations of ($2,300) and Motor Pool of ($10,200) due to usage. Transfers Out 0.00% $ 12,580,114.00 $ 12,681,886.00 $ 13,946,286.00 $ (1,264,400.00) -9.97% Emergency Response and Preparedness Personnel Expenditures $ 7,165,249.00 $ 7,548,364.00 $ 7,279,164.00 $ 269,200.00 3,57% Favorable salaries of $465,700 due to turnover and vacancies; including 6 vacancies in Dispatch; partially offset by unfavorable overtime of ($194,100); and fringe benefits of ($2,400). 9/4/2015 59
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE Operating Expenditures ADOPTED AMENDED BUDGET BUDGET 1,064,122.00 1,068,897.00 146,042.00 —146,042.00 FY 2015 FORECAST 725,997.00 160,742.00 EXPLANATION OF SIGNIFICANT VARIANCES Favorable Fees Civil Services expense of $353,000 is due to the continuing decline in the number of home foreclosures, and civil service requests (see corresponding unfavorability in Civil Action Service Fee revenues); Employee Medical Exams of $20,000 is impacted by lower numbers of new employee hires; lower spending for Professional Services of $9,000 was impacted by the privatization of the Jail Clinic and the Pro-C software and protocol audit. Partially offset by unfavorable Equipment Rental of ($2,100); Equipment Maintenance of ($34,000); Personal Mileage of ($700); Adjustment of Prior Years Expense of ($2,300). AMOUNT FAVORABLE (UNFAVORABLE) PERCENT 342,900.00 32.08% Internal Support Expenditures Transfers Out (14,700.00) -10.07% Unfavorable in Info. Tech. Operations of ($4,400); Radio Communications of ($1,600); Telephone Communications of ($3,000) and Info. Tech. Managed Print Services of ($5,700). 0.00% $ 8,375,413.00 $ 8,763,303.00 $ 8,165,903.00 $ 597,400.00 6.82% 9/4/2015 $45,047,404 $ 45,735,886.00 $ 44,454,386.00 $ 1,281,500.00 2.80% Favorable salaries of $952,000 and fringe benefits of $329,500 due to turnover and vacancies. 647,278.00 1,312,071.00 1,270,571.00 41,500.00 3.16% Favorable Equipment Maintenance expense of $52,300; and Other Expendable Equipment of $6,000 is offset by expenditures in other divisions; partially offset by unfavorable Towing and Storage Fees of ($10,000) due to higher numbers of vehicles being towed during road patrol activity; and Fuel Oil/Natural Gas of ($6,800) for utility cost for the Elizabeth Lake Road Storage Facility. 4,838,736.00 4,944,454.00 4,878,754.00 65,700.00 1.33% Favorable Motor Pool of $83,900; Telephone Communications of $10,800; offset by unfavorable Radio Communications of 40,595.00 333,997,00 333,997.00 0.00% $ 50,574,013.00 $ 52,326,408.00 $ 50,937,708.00 $ 1,388,700.00 2.65% $ 7,858,524.00 $ 7,870,662,00 $ 8,261,162.00 $ (390,500.00) -4.96% Unfavorable salaries and fringe benefits of ($196,600) largely due to turnover and overtime fringes, in addition unfavorable overtime of ($193,900). 970,133.00 1,264, 133.00 1,392,133.00 (128,000.00) -10.13% Unfavorable Equipment Maintenance of ($8,000) reflects increased spending for maintenance agreements on DNA Lab Equipment; Forensic Lab Enhancements of ($111,000); Material and Supplies of ($13,300); is partially offset by favorable Photographic Supplies of $4,300 all related to the delay and certification of the DNA Laboratory. 60 Patrol Services Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Investigative/Forensic Svcs Personnel Expenditures Operating Expenditures
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Internal Support Expenditures 2,025,602.00 2,078,485.00 2,184,085.00 (105,600.00) -5.08% Unfavorable in Info. Tech. Operations of ($23,000); Motor Pool of ($66,700); Telephone Communications of ($7,800) and Info. Tech. Managed Print Services of ($8,100). Transfers Out 334,086.00 578,406.00 578,406.00 0,00% $ 11,188,345.00 $ 11,791,686.00 $ 12,415,786,00 $ (624,100.00) -5.29% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 105,555,324.00 $ 106,692,423.00 12,269,288.00 13,457,463.97 15,640,980.00 16,176,738.00 374,681.00 931,265.00 $ 106,331,723.00 12,221,668.97 16,176,538.00 931,265.00 $ 360,700.00 0.34% 1,235,800.00 9.18% 200.00 0.00% 0.00% $ 133,840,273.00 $ 137,257,894.97 $ 135,661,194.97 $ 1,596,700.00 1.16% 9/4/2015 61
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures $ 746,428.00 $ 746,428.00 $ 746,428.00 $ 52,300.00 52,300.00 33,100.00 0.00% 19,200.00 3611% Fav. Printing County Directory $11,000 due to less volume being printed, Office Supplies $5,000, Equipment Maintenance $1,000, Expendable Equipment $1,000, Freight and Express $800 and Fees-Per Diem $400 due to less than anticipated use. Internal Support Expenditures 63,733.00 66,365.00 66,365.00 0.00% Transfers Out 0.00% $ 862,461.00 $ 865,093.00 $ 845,893.00 $ 19,200.00 2.22% County Clerk (Vital Stats & Legal Rec's) Personnel Expenditures $ 3,502,039.00 $ 3,505,323.00 $ 3,042,423.00 $ 462,900.00 13.21% Fay. due to turnover, underfilled, vacant and part-time positions. Operating Expenditures 303,896.00 303,896.00 266,596.00 37,300.00 12.27% Fay. Court Transcripts $30,000 due to prosecutors ordering fewer transcripts; Personal Mileage $4,000, Freight and Express $2,900, Workshops and Meetings $2,000 due to less than anticipated use. Partially offset by unfavorable, Charge Card Fee ($2,000) due to increased activity. Internal Support Expenditures 606,402.00 747,268.00 747,268.00 0.00% Transfers Out 0.00% $ 4,412,337.00 $ 4,556,487.00 $ 4,056,287.00 $ 500,200.00 10.98% 9/4/2015 62
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Elections Personnel Expenditures $ 817,875.00 $ 817,875.00 $ 713,175.00 $ 104,700.00 12.80% Fav. due to turnover and underlined positions. Operating Expenditures 779,078.00 779,078.00 684,478.00 94,600.00 12.14% Fav. Election Supplies $95,000 due to less than anticipated use. Internal Support Expenditures 260,040.00 262,970.00 278,870.00 (15,900.00) -6.05% Unfav. Telephone Communications ($15,900) due to cellular service activations inside voting machines from May's statewide election. Transfers Out 0.00% $ 1,856,993.00 $ 1,859,923.00 $ 1,678,523.00 $ 183,400.00 9.86% Register of Deeds (and Micrographics) Personnel Expenditures $ 2,468,334.00 $ 2,468,334.00 $ 2,093,534.00 $ 374,800.00 Operating Expenditures 265,494.00 265,494.00 $ 222,894.00 42,600.00 15.18% Fav. due to undefiled, part-time and vacant positions. 16.05% Fay. Metered Postage $24,100 Office Supplies $14,500, Printing $3,800 and Travel and Conference $1,000 due to less than anticipated use. Partially offset by unfavorable Charge Card Fee ($1,300) due to increased activity. Internal Support Expenditures 232,354.00 232,446.00 $ 233,146.00 (700.00) -0.30% Unfav. Info Tech Managed Print Svc due to greater than anticipated use. Transfers Out 0.00% $ 2,966,182.00 $ 2,966,274.00 $ 2,549,574.00 $ 416,700.00 14.05% 9/4/2015 63
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Jury Commission Personnel Expenditures $ 17,522.00 $ 17,522.00 $ 17,522.00 $ Operating Expenditures 68,776.00 68,776.00 49,776.00 0.00% 19,000.00 27.63% Fav. Metered Postage $20,400 and Miscellaneous $1,000 due to less than anticipated use. Partially offset by unfavorable Printing ($2,500) due to volume of juror questionnaires and return envelopes replenishments. Internal Support Expenditures 31,537.00 31,844.00 31,844.00 0.00% $ 117,835.00 $ 118,142.00 $ 99,142.00 $ 19,000.00 16.08% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 7,552,198.00 $ 7,555,482.00 $ 6,613,082.00 $ 1,469,544.00 1,469,544.00 1,256,844.00 $ 1,194,066.00 1,340,893.00 1,357,493.00 $ 942,400.00 212,700.00 (16,600.00) 12.47% 14.47% -1.24% 0.00% $10,215,808.00 $ 10,365,919.00 $ 9,227,419.00 $ 1,138,500.00 10.98% 9/4/2015 64
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES COUNTY TREASURER AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures $ 3,204,451.00 5 3,204,451.00 $ 3,045,651.00 $ 4,605,440.00 4,692,440.00 4,668,940.00 158,800.00 4.96% - Fay. Vacant and under-filled positions. 23,500.00 0.50% - Fay. Computer Supplies $12,000, Twp & City Trees Bonds $8,800, Professional Services $4,000, Personal Mileage $1,700, Tax Collection Supplies $1,400 and Rent $1,100 due to less than anticipated use. Partially offset by unfavorable, Printing ($2,000), Recording Fee-Forfeiture Cert ($1,800) and Travel and Conference ($1,700) due to increased activity. Internal Support Expenditures 557,631.00 958,693.00 958,693.00 0.00% - Transfers Out 120,000.00 1,319,023.00 1,199,023.00 120,000.00 9.10% Fav. Due to no transfers required to Facilities for demolition of property. Division Total 8,487,522.00 10,174,607.00 $ 9,872,307.00 $ 302,300.00 2.97% ----------- Department Total 8,487,522.00 $ 10,174,607.00 $ 9,872,307.00 $ 302,300.00 2.97% 9/4/2015 65
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES BOARD OF COMMISSIONERS AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 2,060,511.00 $ 2,034,957.00 $ 2,025,357.00 $ 6,500.00 0.32% - Fav. due to underfilled position. Operating Expenditures 475,305.00 524,694.99 $ 481,694.99 43,000.00 8.20% - Fav. Workshops and Meetings $10,000, Legal Expense $8,000, Personal Mileage $8,000, Legislative Expense $7,900, Travel and Conference $6,300 and Printing $5,200 due to less anticipated use. Partially offset by unfavorable Special Event Program costs ($2,000) due to increased activity for plaques, awards and related shipping costs. internal Support Expenditures 187,067.00 193,204.00 $ 203,504.00 (10,300.00) -5.33% - Unfav. Telephone Communications ($10,200) due to lpad purchase for Commissioners. A 3rd quarter budget amendment is recommended for Commissioners iPad purchase. $2,722,883.00 $2,749,855.99 $ 2,710,555.99 $ 39,300.00 1.43% Department Total Personnel Expenditures $ 2,060,511.00 $ 2,031,957.00 $ 2,025,357.00 $ 6,600.00 0.32% Operating Expenditures 475,305.00 524,694.99 481,694.99 43,000.00 8.20% internal Support Expenditures 187,067.00 193,204.00 203,504.00 (10,300.00) -5.33% $2,722,883.00 $2,749,855,99 $2,710,555.99 $ 39,300.00 1.43% 9/4/2015 66
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES LIBRARY BOARD AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Library Board Personnel Expenditures $ 535,842.00 $ 487,256.00 $ 487,256.00 $ 0.00% Operating Expenditures 371,528.00 371,528.00 371,528.00 0.00% Internal Support Expenditures 427,153.00 438,454.00 438,454.00 0.00% $ 1,334,523.00 $ 1,297,238.00 $ 1,297,238.00 $ $ 535,842.00 $ 487,256.00 $ 487,256.00 $ 371,528.00 371,528.00 371,528.00 427,153.00 438,45400 438,454.00 $ 1,334,523.00 $ 1,297,238.00 $ 1,297,238.00 $ Transfers Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers 0.00% 0.00% 0.00% 0.00% 0.00% 9/4/2015 67
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES WATER RESOURCES COMMISSIONER AMOUNT FY 2015 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SEGNIFICANT VARIANCES ADOPTED AMENDED BUDGET BUDGET Water Resource Commissioner Personnel Expenditures $ 208,781.00 $ 208,781.00 $ 208,781.00 $ 0.00% Operating Expenditures 587,975 00 587,975.00 552,075.00 35,900.00 6.11% Fav - Legal Services $20,000 a result of Soil Erosion spending less on legal issues to enforce the laws of the soil erosion program. Fav - Education Programs $10,000 due to reduced spending by Soil Erosion for education programs to inform the public on the usage of soil erosion products. Fav - Training Education Supplies $7,700 based on Environmental Unit spending less on education materials to train the public on environmental issues. Fav - Professional SVC-Consultants $5,000 due to less spending on these services related to soil erosion and environmental issues _Fay - Expendable Equipment Expense $5,000 because budget exceeded actual spending needs on these items. Fav - Uniforms $4,000 a result of Soil Erosion spending less on jackets, overalls and logo patches. Fay - Contracted Services $2,008 due to ieSS spending on soil erosion corrective action issues. Unfav - Office Supplies (815,700) based on actual office supply needs. Unfav - Metered Postage ($2,000) due to an increasing trend for addition postage usage. Internal Support Expenditures 4203,322.00 4,378,257.00 4,460,353.00 (82,096.00) -1.88% Unfav - Info Tech Operations ($67,956) a result of maintenance cost related to CAMS, offset in revenue already budgeted in Reimbursement General, Unfav - Telephone Communications ($9,900) and Info Tech Managed Print Svcs ($4,240) a result of actual spending being more than anticipated budget_ Transfers 56,165.00 56,165.00 56,165.00 0.00% Division Total $ 5,056,243.00 $ 5,231,178.00 $ 5,277,374.00 $ (46,196.00) -0.88% Department Total 5,056,243.00 $ 5,231,178.00 $ 5,277,374.00 $ (46,196.00) -0.88% 9/4/2015 68
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES COUNTY EXECUTIVE AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures $ 2,112,426.00 $ 2,115,474.00 2,105,474.00 $ 10,000.00 282,944.00 694,449.00 $ 284,449.00 410,000.00 0.47% - Fav due to turnover. 59.04% - Fay Professional Services $400,000 due to Detroit Water & Sewerage Department (DWSD) alternative study no longer considered necessary and Postage/Office Supplies $10,000 due to less than anticipated use. Internal Support Expenditures 399,485.00 416,225.00 $ 409,225.00 7,000.00 1.68% - Fay Info Tech Operations $7,000 due to less than anticipated use. $ 2,794,855.00 $ 3,226,148.00 $ 2,799,148.00 $ 427,000.00 13.24% Compliance Office Personnel Expenditures $ 1,491,384.00 $ 1,496,222.00 $ 1,496,222.00 0.00% Operating Expenditures 49,252.00 $ 49,952.84 34,952.84 15,000.00 30.03% Fay Professional Services $15,000 due to less than anticipated use. internal Support Expenditures 179,751.00 186,502.00 181,502.00 5,000.00 2.68% Fav Info Tech Operations $5,000 due to less than anticipated use. Transfer Out Corporation Counsel Personnel Expenditures Operating Expenditures $ 1,720,887.00 $ 1,732,676.84 $ 1,712,676.84 $ 20,000.00 $ 2,013,215.00 $ 2,013,215.00 $ 2,013,215.00 1.15% 0.00% - 59,133.00 59,133.00 50,133.00 9,000.00 15.22% - Fay Computer Research Service $6,000, Persona! Mileage $1,500, and Professional Services $1,500 due to less than anticipated use. Internal Support Expenditures 192,346.00 204,670.00 201,670.00 3,000.00 1.47% - Fay Info Tech Operations $3,000 due to less than anticipated use. $ 2,264,694.00 $ 2,277,018.00 $ 2,265,018.00 $ 12,000.00 0.53% 8.92015
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES COUNTY EXECUTIVE AMOUNT FY 2015 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ADOPTED AMENDED BUDGET BUDGET Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 5,617,525.00 $ 5,624,911.00 $ 5,614,911.00 391,329.00 $ 803,534.84 369,534.84 771,582.00 807,397.00 792,397.00 10,000.00 434,000.00 15,000.00 0.18% 54.01% 1.86% $ 6,780,436.00 $ 7,235,842.84 $ 6,776,842.84 $ 459,000.00 6.34% yi2015
Internal Support Expenditures Equalization Personnel Expenditures Operating Expenditures 431,404 00 12,739.00 12,739.00 12,739.00 $ 236,937.00 $ 236,937.00 $ 232,937.00 $ 4,001100 $ 7,991,445.00 $ 7,991,445.00 $ 6,791,445.00 $ 1,200,000.00 431,404.00 347,404.00 84,000.00 ADOPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT FY 2015 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 220,181.00 $ 220,181.00 $ 216,181.00 $ 4,000.00 1.82% Fav fringe benefits due to a change in the number of dependents. Operating Expenditures 4,017.00 4,017.00 4,017.00 $ 0.00% 15.02% Fav due to vacancies and under filled positions. 19.47% Fav due to Professional Services $49,000, Office Supplies $15,000, Personal Mileage $10,000, Printing $10,000 and Travel & Conference $5,000 due to efforts to reduce spending partially offset by unfavorable Membership Dues ($2,000) and Expendable Equipment ($3,000) due to increased use. 2.34% Fav Info Tech Operations $25,000 due to less than anticipated use. 0.00% 13.79% 0.00% 1.69% Internal Support Expenditures 864,152.00 1,069,193.00 1,044,193.00 25,000.00 Transfers Out $9,287,001.00 $9,492,042.00 $ 8,183,042.00 $ 1,309,000.00 71 J:WiscalSvc\BudgetWorecast_New112.xls 914/2015
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Fiscal Services Personnel Expenditures $ 7,739,088.00 $ 7,739,088.00 $ 7,139,088.00 $ 600,000.00 7.75% Fav due to vacancies and under filled positions. Operating Expenditures 388,600.00 388,600.00 327,100,00 61,500.00 15.83% Fay due to Metered Postage $25,000, Printing $20,000, Office Supplies $5,000, Training $4,000, Filing Fees $4,000, Expendable Equipment $2,000 and Persona] Mileage $1,500 due to efforts to reduce spending. Internal Support Expenditures 1,228,987.00 1,513,745.00 1,407,745.00 106,000.00 7.00% Fay Info Tech Operations $110,000 due to less than anticipated use. Partially offset by unfavorable IT Managed Print Services ($4,000) based on printing activity fluctuations. Transfers Out . 00 % $ 9,356,675.00 $ 9,641,433.00 $ 8,873,933.00 $ 767,500.00 Department Total Personnel Expenditures $ 15,950,714.00 $ 15,950,714,00 $ 14,146,714.00 $ 1,804,000.00 Operating Expenditures 824,021.00 824,021.00 678,521.00 145,500.00 Internal Support Expenditures 2,105,878.00 2,595,677.00 2,464,677.00 131,000.00 Transfers Out - - $ 18,880,613.00 $ 19,370,412.00 $ 17,289,912.00 $ 2,080,500.00 7.96% 11.31% 17.66% 5.05% 0.00% 10.74% 72 J:IFiscalSyclBudgettForecast_Newt12,xts 9/4/2015
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES CENTRAL SERVICES AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administrative Personnel Expenditures $ 215,082.00 $ 215,082.00 $ 215,082.00 $ 0.00% Operating Expenditures 3,298.00 3,298.00 $ 598.00 2,700.00 81.87% Fav - Travel and Conference primarily due to less than anticipated travel. Internal Support Expenditures 9,121.00 9,121.00 $ 9,121.00 0.00% Transfers Out $ 227,501.00 $ 227,501.00 $ 224,801.00 $ 2,700.00 1.19% $ 1,134,895.00 $ 1,134,895.00 $ 1,134,895.00 $ 0.00% 400,622.00 400,622.00 $ 338,922.00 61,700.00 15.40% Fay - Mail Handling-Postage Svc $38,800 due to loss of business with Oakland County Community Mental Health Authority (OCCMHA) (offset by unfavorable revenue-Standard Mail) , Equipment Maintenance $9,300 due to less than anticipated equipment repairs, Maintenance Contract $7,300 due to the OmniRim Record Retention inventory system software maintenance contract paid by IT and charged back to the department through internal billing, Office Supplies $3,700 due to less than anticipated supplies needed, and Auction Expense $2,500 due to less than anticipated general fund auction expenses. Support Services Personnel Expenditures Operating Expenditures Internal Support Expenditures 664,343.00 716,172.00 $ 716,172.00 0.00% Transfers Out - - - - 0.00% $ 2,199,860.00 $ 2,251,689.00 $ 2,189,989.00 $ 61,700.00 2.74% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 1,349,977.00 $ 1,349,977.00 $ 403,920.00 403,920.00 673,464.00 725,293.00 1,349,977.00 $ 339,520.00 725,293.00 64,400.00 0.00% 15.94% 0.00% 0.00% $ 2,427,361.00 $ 2,479,190.00 $ 2,414,790.00 $ 64,400.00 2.60% 9/4/2015 73
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES FACILITIES MANAGEMENT AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 198,756.00 $ 198,756.00 $ 198,756.00 $ 0.00% _ Operating Expenditures 5,764.00 5,764.00 5,764.00 0.00% - Internal Support Expenditures 19,167.00 19,167.00 14,167.00 5,000.00 26.09% - Fay, Info Tech Operations based on actual usage. $ 223,687.00 $ 223,687.00 5 218,687.00 $ 5,000.00 2.24% Facilities Engineering Personnel Expenditures $ 780,420.00 $ 780,420.00 $ 735,420.00 $ 45,000.00 5.77% - Fav. due to underged positions. Operating Expenditures 168,682.00 168,682.00 193,182.00 (24,500.00) -14.52% - Unfav. Professional Services ($30,000) due to more projects than anticipated. Partially offset by fay. Software Support Maintenance $2,200; Personal Mileage $2,000; and Expendable Equipment $1,300 based on actual usage. Internal Support Expenditures 53,725.00 53,821.00 58,821.00 (5,000.00) -9.29% - Unfav. Motor Pool based on actual usage. $1,002,827.00 $ 1,002,923.00 $ 987,423.00 $ 15,500.00 1.55% Department Total Personnel Expenditures $ 979,176.00 $ 979,176.00 $ 934,176.00 $ 45,000.00 4.60% Operating Expenditures 174,446.00 174,446.00 198,946.00 (24,500.00) -14.04% Internal Support Expenditures 72,892.00 72,988.00 72,988.00 0.00% $1,226,514.00 $ 1,226,610.00 $ 1,206,110.00 $ 20,500.00 1.67% 9/4/2015 74
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES HUMAN RESOURCES AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 736,771.00 $ 736,771.00 $ 586,771.00 $ 150,000.00 20.36% Fav due to part time positions and turnover. Operating Expenditures 287,622.00 287,622.00 237,622.00 $ 50,000.00 17.38% Fav Legal Services $30,000, Professional Services $10,000, Fees - Per Diems $10,000 due to less than anticipated use. Internal Support Expenditures 34,874.00 40,617.00 40,617.00 $ 0.00% Transfers Out 5 1,059,267.00 $ 1,065,010.00 $ 865,010.00 5 200,000.00 18.78% Workforce Management Personnel Expenditures $ 1,813,648.00 $ 1,813,648.00 $ 1,713,648.00 $ 100,000.00 5.51% Fav due to utilizing part time employees and turnover. Operating Expenditures 248,740.00 248,740.00 245,740.00 $ 3,000.00 1.21% Fav Recruitment Expense $3,000 due to less than anticipated use. Internal Support Expenditures Transfers Out Benefits Administration 632,680.00 773,788.00 698,788.00 $ 75,000.00 9.69% Fav Info Tech Operations $75,000 due to less than anticipated use. $ 2,695,068.00 $ 2,836,176.00 5 2,658,176.00 5 178,000.00 6.28% Personnel Expenditures 168,496.00 $ 168,496.00 $ 168,496.00 $ 0.00% Operating Expenditures 16,977.00 $ 16,977.00 9,977.00 $ 7,000.00 41.23% Fav Office Supplies $2,000, Travel & Conference $2,000 and Expendable Equipment $2,000 due to less than anticipated use. Internal Support Expenditures 149,172.00 149,172.00 149,172.00 $ 0.00% Transfers Out Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 334,645.00 $ 334,645.00 $ 327,645,00 $ 5 2,718,915.00 $ 2,718,915.00 $ 2,468,915.00 $ 553,339.00 553,339.00 493,339.00 816,726.00 963,577,00 888,577.00 7,000.00 2.09% 250,000.00 9.19% 60,000.00 10.84% 75,000.00 7.78% $ 4,088,980.00 $ 4,235,831.00 $ 3,850,831.00 $ 385,000.00 9.09% 752015
Operating Expenditures 8,760,134.00 8,731,642.00 6,481,642.00 2,250,000.00 25.77% - Fay. due to Private Institutions Foster Care, Private Institutions Residential, and Private Institutions $1,500,000; Independent Living $450,000; Foster Boarding Homes $300,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,789.00 12,789.00 32,789.00 (20,000.00) -156.38% - Unfav. Info Tech Operations due to on-going fee for emergency notification system. COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 199,496.00 $ 199,496.00 $ 199,496.00 $ 0.00% - Transfers Out 28,492.00 28,492 00 $ 8,972,419.00 $ 8,972,419.00 $ 6,742,419.00 $ 2,230,000.00 24.85% Health Personnel Expenditures $ 23,535,707.00 $ 23,535,707.00 $ 21,285,707.00 $ 2,250,000.00 9.56% - Fav. due to turnover and underfiiled positions. (59,392.00) -2.03% - Unfav. Vaccines ($175,000) due to increased costs and increased demand from employee vaccination program; a budget amendment is recommended. Unfav. Adj Prior Years Revenue ($174,392) due to correction for FY 2014 estimated administrative overhead cost distribution along with adjustment for uncollectable accounts receivable from third party biller. Unfav. Personal Mileage ($25,000) due to increase in field activities. Partially offset by fav. Professional Services 5225,000 due to contractor accepting Medicaid rates and reduced demand for services. Fav. Laboratory Supplies $50,000 and Office Supplies $25,000 due to continued efforts to minimize expenses and contain costs. Fay. TB Cases Outside $15,000 due to limited number of patients requiring service. 2,500.00 0.08% - Fav. Info Tech Operations $18,000 based on usage. Fay. Radio Communications $9,000 due to the use of available grant funding. Partially offset by unfav. Info Tech Managed Print Svcs ($12,500) and Telephone Communications ($12,000) based on usage. 8,640.00 - Fay. due to grant funding which covers the rental lease agreement with Walled Lake Consolidated Schools for office space to accommodate the Women, Infants and Children (WIC) Supplemental Food program. No General Fund transfer required. Operating Expenditures 2,888,269.00 2,920,296.00 2,979,688.00 Internal Support Expenditures 2,612,932.00 3,054,764.00 3,052,264.00 Transfers Out 8,640 00 8,640.00 $ 29,045,548.00 $29,519,407.00 $ 27,317,659.00 $ 2,201,748.00 7.46% 76/2015
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Children's Village Personnel Expenditures 5 15,354,849.00 $ 15,357,376.00 $ 15,207,376.00 $ 150,000.00 0.98% - Fay. due to turnover and underfilled positions. 158,400.00 4.29% - Fay. Provisions $50,000 due to increased reimbursement for improved nutritional requirements and decrease in resident population. Fay. Psychological Testing $45,000 due the use of available grant funding. Fay. Medical Services Physicians $43,400 due to services provided by Oakland Integrated Healthcare Network (011-IN). Fay. Professional Services $20,000 due to the utilization of part-time nursing staff in lieu of contracted nursing staff. (12,500.00) -0.50% - Unfav. Motor Pool ($7,500) and Into Tech Managed Print Svcs (55,000) based on usage. Operating Expenditures $ 3,693,661.00 3,691,216.00 3,532,816.00 Internal Support Expenditures 2,395,910.00 2,507,864.00 2,520,364.00 Transfers Out 6,283.00 6,283.00 $ 21,444,620.00 $ 21,562,739.00 $ 21,266,839.00 $ 295,900.00 1.37% Homeland Security Personnel Expenditures $ 810,780.00 $ 810,780 00 $ 775,780.00 $ 35,000.00 4.32% - Fay. due to turnover. Operating Expenditures Internal Support Expenditures Transfers Out 290,680.00 301,932.00 251,932.00 50,000.00 16.56% - Fav. Tornado Siren Equip $30,000 due to the installation of fewer than anticipated sirens. Partially offset by revenue unfavorability (Local Match). Fay. Equipment Maintenance $25,000 due to limited repair casts incurred on specialty/hazmat vehicles. Fav. Printing $5,000 due to reduced need for printed materials. Partially offset by unfav. Maintenance Contract ($10,000) due to Digipeating project and preventive maintenance on Tornado Sirens. 438,641.00 451,230.00 408,730.00 42,500.00 9.42% - Fay. Info Tech Operations $45,000 and Telephone Communications $2,500 based on usage. Partially offset by unfav. Motor Pool ($5,000) based on usage. $ 1,540,101.00 5 1,563,942.00 $ 1,436,442.00 $ 127,500.00 Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 39.900,832.00 15,632,944.00 5,460,272 00 8,640.00 $ 39,903,359.00 15,645,086.00 6,026,647.00 43,415.00 $ 37,468,359.00 13,246,078.00 6,014,147.00 34,775.00 $ 2,435,000.00 2,399,008.00 12,500.00 8,640.00 6.10% 15.33% 0.21% 0.00% $ 61,002,688.00 $ 61,618,507.00 $ 56,763,359.00 $ 4,855,148.00 7.88% 724/2015
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Public Services - Admin. Personnel Expenditures $ 215,166.00 $ 215,166.00 215,166.00 $ 0.00% - Operating Expenditures 4,800.00 4,800.00 2,800.00 2,000.00 41.67% - Fay Special Event Program $2,000 due to less than anticipated use. Internal Support Expenditures 5,734.00 5,734.00 5,734.00 0.00% - $ 225,700.00 $ 225,700.00 $ 223,700.00 $ 2,000.00 0.89% Veterans' Services Personnel Expenditures $ 1,539,184.00 $ 1,533,815.00 1,458,815.00 $ 75,000.00 4.89% - Fav due to vacant and under filled positions. Operating Expenditures 190,912.00 190,912.00 175,912.00 15,000.00 7.86% - Fav Soldier Burial $9,000 due to fewer than anticipated applications for burials including favorable Soldier Relief $4,000. Favorable Metered Postage $2,000 due to less than anticipated use. Internal Support Expenditures 166,852.00 170,196.00 170,196.00 0.00% - Transfers Out 0.00% $ 1,896,948.00 $ 1,894,923.00 $ 1,804,923.00 $ 90,000.00 4.75% Community Corrections Personnel Expenditures $ 3,584,502.00 $ 3,662,816.00 3,562,816.00 $ 100,000.00 2.73% - Fay due to vacant and under filled positions. Operating Expenditures Internal Support Expenditures Transfers Out 502,025.00 506,290.00 502,025.00 570,240.00 557,025.00 570,240.00 (55,000.00) -10.96% - Unfav due to Contracted Services ($50,000) due to increased court referrals from judges and Metered Postage ($2,000) due to increased activity. This is partially offset by favorable Transportation of Clients $4,000, Grounds Supplies $7,000 and Office Supplies $2,000 due to less than anticipated use. 0.00% - 0.00% - $ 4,592,817.00 $ 4,735,081.00 $ 4,690,081.00 $ 45,000.00 0.95% MSU Ext. - Oakland County Personnel Expenditures $ 789,000.00 $ 653,900.00 $ 643,900.00 $ 10,000.00 1.53% - Fay due to vacant-and under filled positions. Operating Expenditures 89,689.00 216,689.00 216,689.00 0.00% - V02015
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Internal Support Expenditures 247,566.00 251,479.00 246,479.00 5,000.00 1.99% - Fay Info Tech Operations $5,000 due to less than anticipated use. Medical Examiner Personnel Expenditures $ 1,126,255.00 $ 1,122,068.00 $ 1,107,068.00 $ 15,000.00 1.34% $ 3,241,704.00 $ 3,241,704.00 $ 3,061,704.00 $ 180,000.00 5.55% Fav due to vacant and under filled positions. Partially offset by unfavorable Laboratory Fees for vacant Chief Forensic Toxicologist. Operating Expenditures 520,006.00 520,006.00 565,006.00 (45,000.00) -8.65% - Unfav due to Laboratory Fees ($45,000) offset by favorable personnel expenditures for vacant Chief Forensic Toxicologist and Transportation Services ($17,000) due to increased use partially offset by favorable Training $10,000, Film & Processing $4,000, and Professional Services $3,000 due to less than anticipated use. Internal Support Expenditures 782,650.00 835,374.00 833,374.00 2,000.00 0,24% - Fav Info Tech Operations $2,000 due to less than anticipated use, Transfers Out $ 4,544,360.00 $ 4,597,084.00 $ 4,460,084.00 $ 137,000.00 2.98% Animal Control Personnel Expenditures $ 2,239,095.00 $ 2,280,229.00 $ 2,180,229.00 $ 100,000.00 4.39% - Fay due to vacant and under filled positions. Operating Expenditures 190,097.00 262,597.00 262,597.00 0.00% - Internal Support Expenditures 764,143.00 1,009,507.00 1,009,507.00 0.00% - Transfers Out ------------------ ---------------- --------------- ---------------- $ 3,193,335.00 $ 3,552,333.00 $ 3,452,333.00 $ 100,000.00 2.82% Circuit Court Probation Personnel Expenditures 0,00% Operating Expenditures 54,326.00 54,326.00 49,326.00 5,000.00 920% Fav Office Supplies $3,000, Equipment Maintenance $1,000 and Metered Postage $1,000 due to less than anticipated use. n2015
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Internal Support Expenditures 466,094.00 473,619.00 471,619.00 2,000.00 0.42% ----------------- ----------------- ------------- ----------------- $ 520,420,00 $ 527,945.00 $ 520,945.00 $ 7,000.00 1.33% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 11,608,651.00 $ 11,587,630.00 $ 11,122,630.00 $ 1,551,855.00 1,751,355.00 1,829,355.00 2,939,329.00 3,316,149.00 3,307,149.00 $ 16,099,835.00 $ 16,655,134.00 $ 16,259,134.00 $ 465,000.00 4.01% (78,000.00) -4.45% 9,000.00 0.27% 396,000.00 2.38% 892015
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST :UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 1,204,321.00 $ 1,204,321.00 $ 1,181,121.00 $ 23,200.00 1.93% - Fay. due to turnover and underlined positions. Operating Expenditures 358,222.00 403,582.00 368,882.00 34,700.00 8.60% - Fay. Supplies $19,700, Travel $7,800 and Mileage $7,200 due to less than anticipated usage. Internal Support Expenditures 55,767.00 284,405.00 281,205.00 3,200.00 1.13% Fay. Info Tech Operations $1,800, Telephone Communications $1,000 and Motor Pool $400 due to less than anticipated usage. Transfers $ 1,618,310.00 $ 1,892,308.00 $ 1,831,208.00 $ 61,100.00 3.23% Transfers 6.42% Fav. due to turnover and underlined positions. 4.79% - Fay, Software Maintenance $19,500 due to decreased maintenance; Supplies $41,100 and Travel $10,600 due to reduced usage. 6.74% Fav Info Tech Operations $51,000, Telephone Comm $3,700 and Info Tech Managed Print Services $2,900 due to less than anticipated usage. Planning and Economic Development Services Personnel Expenditures $ 3,847,020.00 $ 3,847,020.00 $ 3,600,020.00 $ 247,000.00 Operating Expenditures 1,302,983.00 1,485,999.33 1,414,799.33 71,200.00 Internal Support Expenditures 814,893.00 854,966.00 797,366.00 57,600.00 $ 5,964,896.00 $ 6,187,985.33 $ 5,812,185.33 $ 375,800.00 6.07%
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS ADOPTED AMENDED BUDGET BUDGET Community and Home Improvement Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers AMOUNT FY 2015 FAVORABLE FORECAST :UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 5,076,961.00 1,661,205.00 870,660.00 Workforce Development Personnel Expenditures Operating Expenditures Internal Support Expenditures Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 5,076,961.00 $ 4,806,761.00 $ 270,200.00 1,889,581.33 1,783,681.33 105,900.00 1,139,371.00 1,078,571.00 60,800.00 $ 25,620.00 $ 25,620.00 $ 25,620.00 $ $ 25,620.00 $ 25,620.00 $ 25,620.00 $ 0.00% 0.00% 5.32% 5.60% 5.34% 0.00% $ 7,608,826.00 $ 8,105,913.33 $ 7,669,013.33 $ 436,900.00 5.39%
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT NON-DEPARTMENTAL EXPENDITURES AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION NON-DEPARTMENT APPROPRIATIONS COUNTY OPERATIONS Insurance Fund Insurance Surety Bonds Logos Trademarks Intellect Property Road CommissionlCurrent Drain Assessment Road Commission\Tri Party Agreement S 325,187.00 $ 325,187.00 $ 325,187.00 $ 33,305.00 33,306.00 3,305.00 18,000.00 18,000.00 18,970.00 1,400,000.00 1,400,000.00 1,400,000.00 100.00 2,043,259.00 2,043,259.00 0.00% 30,000.00 90.08% Favorable based on year to date actual payments approved by Risk Mgmt. (970.00) -5.39% Unfavorable due to required payments for licensing. 0.00% 0.00% Interest Expense 1,500,000.00 1,500,000.00 1,500,000.00 100.00% Favorable - no short-term borrowing required for FY 2015 operating expenses. Provisions 30,000.00 30,000.00 30,000.00 0.00% Transfer to Community Mental Health Authority 9,620,616.00 9,820,616.00 9,620,616.00 0.00% Total $ 12,927,208.00 $ 14,970,367.00 $ 13,441,337.00 $ 1,529,030.00 10.21% COUNTY BUILDINGS $ 2,854,447.00 $ 2,345,313.00 $ 2,345,313.00 $ 0.00% STATE AND FEDERAL - COUNTY ASSOCIATIONS Michigan Assoc. of Counties National Assoc. of Counties S.E.M.C.C).G. Traffic Improvement Association 73,000.00 $ 24,100.00 500,000.00 30,000.00 73,000.00 $ 24,100.00 500,000 00 30,000.00 73,000.00 $ 24,100.00 450,000.00 30,000.00 50,000.00 0.00% 0.00% 10.00% 0.00% Favorable due to membership rate less than budget. Total $ 627,100.00 $ 627,100.00 $ 577,100.00 $ 50,000.00 7.97% SUNDRY EXPENSE $ 300,000.00 $ 2,300,000.00 $ 2,300,000.00 $ 0.00% RESERVED FOR TRANSFERS Expenditures Classification and Rate Change Contingency Disaster Recovery Emergency Salaries Grant Match Info Tech Development Legislative Expense Misc. Capital Outlay Overtime Appropriation Security Reserve $ 329,954.00 $ 235,355.00 $ 235,355.00 S 254,405.00 27,096.00 27,096.00 300,000.00 300,000.00 831,000.00 860,300.00 860,300.00 1,160,000.00 838,680.00 838,680.00 5,326,050.00 2,201,900.00 2,201,900.00 8,600,00 8,600.00 8,600.00 125,000.00 31,383.00 31,383.00 53,000.00 53,000.00 53,000.00 2,919,904.00 2,787,240.00 2,787,240.00 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
$ 413,145.00 1,844,186.00 3,820,676.00 2,278,375.00 4,555,000.00 3,500,000.00 1,500,000.00 442,803.00 1,844,186.00 4,620,676.00 2,278,375.00 4,555,000.00 3,722,200.00 1,500,000.00 $ 442,803.00 $ 1,844,186.00 4,620,676.00 2,278,375_00 4,555,000.00 3,722,200.00 1,500,000.00 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT NON-DEPARTMENTAL EXPENDITURES AMOUNT ADOPTED AMENDED FY 2015 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION Substance Abuse Coord Agency 5,688,140.00 9,319,321.00 10,379,321.00 (1,060,000.00) -11.37% Unfavorable due to required payments to Oakland County Community Mental Health Authority for one-half of Convention Facility Tax revenues earmarked for substance abuse services. Offset by favorable revenue. A budget amendment is recommended. Summer Employees Salary Appropriation 250,000.00 250,000.00 250,000.00 0.00% Total $ 16,944,053.00 $ 16,912,875.00 $ 17,972,875.00 $ (1,060,000.00) -6.27% Transfers to Other Funds Fire Records Management CLEMIS Information Technology Bldg Auth Fac Infras IT Debt Fringe Benefit Fund Project Work Order Fund Long Term Revolving Fund Facilities Maintenance and Operations Building Fund $ 17,711,382.00 $ 18,963,240.00 $ 18,963,240.00 $ 0.00% TOTAL NON-DEPT. APPROPRIATIONS $ 51,364,190.00 $ 56,118,895.00 $ 55,599,865.00 $ 519,030.00 0.92% TRANSFER TO GENERAL PURPOSE FUNDS Child Care Fund Social Welfare Fund Foster Care $ 22,747,833.00 $ 23,346,030.00 $ 23,346,030.00 $ 1,000.00 1,000.00 1,000.00 $ 22,748,833.00 $ 23,347,030.00 $ 23,347,030.00 $ 0.00% 0.00% 0.00% TOTAL EXPENDITURES $ 74,113,023.00 $ 79,465,925.00 $ 78,946,895.00 $ 519,030.00 0.65%
FY 2015 BUDGET AMENDMENTS FY 2015 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS BUDGET AMENDMENTS M.R. #14252 - 1012312014 Facilities IVIgmt/Facilities Planning & Engineering - Treasurer's Office - Book Room Conversion Project $ 422,341,962.00 8,200.00 M.R. #14242 - 10/23/2014 Public Services / MSU Extension - Modification of Professional Services Contract for 4-H Youth Development (8,100.00) Coordinator Positions and Educational Programming Services M.R. #14243 - 10/23/2014 Circuit Court / Friend of the Court - Creation of Friend of the Court Referee Position (1,839.00) M.R. #14245 - 10/23/2014 Board of Commissioners - Funding for Safe and Healthy Kids Partnership with Oakland Schools to Provide Anti- $ 30,000,00 Bullying Training for Educators and School Administrators M.R. #14259 - 11/19/2014 Treasurer's Office Tax Management System M.R. #14260 - 11119/2014 Information Technology Reference Architecture Project M.R. #14264 - 11/19/2014 Departments of Facilities Management/Sheriffs Office - Approval and Acceptance of Lease Agreement with 2470 Elizabeth Lake Road, LLC, for use of the Quality Pontiac Building for Storage of Equipment at 2470 Elizabeth Lake Road, Waterford, Michigan M.R. #14270 - 11/1912014 Circuit Court -2015 Michigan Drug Court Grant Program (Adult Treatment Court) Grant Acceptance M.R. #14271 - 11/1912014 Circuit Court - 2015 Michigan Drug Court Grant Program (Juvenile Drug Court) Grant Acceptance $ 1,199,023.00 $ 1,000,000.00 $ 323,753.00 18,940.00 57,838.00 M.R. #14295 - 12/04/2014 Management & Budget Fiscal Year 2014 Year-End Report and Budget Amendments Encumbrances Carry Forwards Disaster Recovery $ 555,360.13 $ 1,996,867,00 $ 300,000.00 $ 2,852,227,13 M.R. #14284 - 12/04/2014 Department of Health and Human Services/Health Division - Youth Prescription Drug Abuse Prevention Campaign M.R. #14274 - 12/04/2014 Human Resources Department - Salary Administration Plan 1st Quarterly Report for FY 2015 M.R. #14275 - 12/04/2014 Department of Public Services - Veterans Services and Animal Control Position Changes M.R. #14278 - 12/04/2014 Sheriffs Office - Position Changes - Inmate Program Services M.R. #14281 - 12/04/2014 Sheriffs Office - Contract Amendment #1 for Law Enforcement Services in the Charter Township of Lyon 2013 - 2015 15,000.00 1,263.00 35,765.00 (249,00) $ 483,098.00 M.R. #14283 - 12/04/2014 Sheriffs Office - Contract Amendment #2 for Law Enforcement Services in the Charter Township of Commerce $ 14,464,00 2013- 2015 85
FY 2015 BUDGET AMENDMENTS M.R. #14282 - 1210412014 Sheriffs Office - Contract Amendment #2 for Law Enforcement Services in the City of Rochester Hills $ 109,944.00 2013-2015 M.R. #14298 - 1210412014 Sheriffs Office - Contract Amendment #3 for Law Enforcement Services in the Charter Township of Oakland 29,984.00 2013 -2015 M.R. #14299 -1210412014 Sheriffs Office - Contract Amendment #1 for Law Enforcement Services in the Charter Township of Oxford 2013 2015 M.R. #14302 - 12/04/2014 Board of Commissioners - Position Changes and Reorganization M.R. #14303 - 12104/2014 Board of Commissioners - Annual Stipend Allowance for Board Leadership MR. #14304 - 12/04/2014 Animal Control (AC)/Facilities Planning & Engineering (FPE) - Animal Control Building Security Enhancement Project M.R. #14279 - 12/0412014 Sheriffs Office - Position Changes - OCCMHA Reimbursement for Jail Alliance With Support (JAWS) Program M.R. - 01/29/2015 Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance) M.R. #15000 - Village of Holly M.R. #15012 - 02/18/2015 Sheriffs Office - Contract Amendment #2 For Law Enforcement Services for the Parks and Recreation Commission 2013 -2015 MR. #15013 - 02/18/2015 Sheriffs Office - Contract Amendment #2 For Law Enforcement Services in the Charter Township of Independence 2013 -2015 M.R. #15014 - 02/18/2015 Sheriff's Office - Contract Amendment #3 For Law Enforcement Services in the Charter Township of Commerce 2013- 2015 M.R. 03/18/2015 Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance) M.R. #15049 - Charter Township of Milford M.R. #15027 - 03/18/2015 Sheriffs Office - Establishment of Dispatch Services Contract Rates - April 1, 2015 through March 31, 2018 26,594.00 (42,963.00) 12,035.00 $ 214,000.00 $ (24,701,00) 14,000.00 10,068.00 76,351.00 78,988.00 58,474.00 $ 173,323.00 M.R. #15062 - 03/1812015 M&B FY 2015 First Quarter Report Adjustments to Circuit Court Adjustments to Probate Court Adjustments to Treasurer's Office Adjustments to Sheriffs Office Adjustments to Public Services - Animal Control Adjustments to Economic Development and Community Affairs Adjustments to Non-Departmental $ 110,000.00 $ 60,000.00 $ 87,000.00 $ 220,000.00 $ 22,500.00 $ 52,010.00 $ 3,519,180.00 $4,070,690.00 M.R. #15024 - 03/18/2015 Board of Commissioners/Library Board Deletion of Library Technician II Position (71,939.00) 86
FY 2015 BUDGET AMENDMENTS M.R. - 04/0212015 Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance) M.R. #15072 - Charter Township of Independence M.R. #15073 - Charter Township of White Lake M.R. #15075 - Township of Groveland M.R. #15076 - Charter Township of Lyon M.R. #15071 - 04/02/2015 Sheriffs Office - Contract Amendment #2 For Law Enforcement Services in the Charter Township of Orion 2013- 2015 M.R. - 05/21/2015 Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance) M.R. #15130 - Village of Beverly Hills M.R. #15138- Charter Township of Independence M.R. #15113 - Charter Township of Bloomfield M.R. #15135 - 0512112015 Board of Commissioners - Road Commission for Oakland County - Appropriation of One-Time Funding for Purchase of Capital Assets 538,148.00 29,494,00 10,054.00 35,675.00 $ 613,371.00 67,919.00 37,655.00 108,999.00 45,118.00 $ 191,772.00 $ 2,000,000.00 M.R. - 06110/2015 Board of Commissioners - Tr-Panty Road Improvement Program (Planned Use of Fund Balance) M.R. #15147 - Township of Addison $ 9,972.00 M.R. #15150 - City of Novi $ 53,679.00 M.R. #15151 - City of Troy $ 134,752.00 M.R. #15152 - City of Oak Park $ 32,830.00 M.R. #15153 - Township of Rose $ 10,062.00 $ 241,295.00 M.R. #15156 - 06/10/2015 M&B FY 2015 Second Quarter Report Adjustments to Board of Commissioners 7,150.00 Adjustments to Sheriffs Office $ 157,482.00 Adjustments to Public Services - Animal Control $ 50,000.00 M.R. #15145 - 06/1012015 Sheriffs Office - Contract for Auxiliary Deputy Services In the City of Wixom 2015 M.R. #15158 - 0611012015 Sheriffs Office - Contract Amendment #3 For Law Enforcement Services in the Charter Township of Brandon 2013 -2015 $214,632,00 5,873,00 41,664.00 TOTAL AMENDED BUDGET AS OF 06130/2015 $ 436,482,719.13 87
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT ENTERPRISE FUND TREASURERS OFFICE ADOPTED AMENDED FY 2015 VARIANCE BUDGET BUDGET FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DELINQUENT TAX REVOLVING FUND 51600 REVENUES Charges for Services Other Revenues $17,500,000,00 884,000.00 $17,500,000.00 884,000.00 $17,500,000.00 1,069,900.00 $0.00 185,900,00 0.00% 21.03% Fey. Prior Years Adjustment $169,900 due to interest charges on older delinquencies, Michigan Tax Tribunal, July and December Boards of review decisions. Total Revenues $18,384,000.00 $18,384,000.00 $18,569,900.00 $185,900.00 1.01% OPERATING EXPENSES Personnel Expenditures Operating Expenditures $ 183,331.00 $ 183,331.00 318,210.00 318,210.00 Interest Expense Transfer Out to Other Funds: General Fund - Collection Fees GF - 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 Assets - Beginning Total Net Assets - Ending Ending FY 2014 Designated Net Positions": NP-UnRes - Designated - Debt Service NP-UnRes - Designated - Define Taxes Receivable NP-UnRes - Designated - Collection Fees Undesignated - Net Position Total Net Position - Ending 183,331.00 289,210.00 50,000 00 4,005,543.00 10,800,000.00 1,607,350.00 1,871,300.00 1.323,300.00 $ 19,607,493.00 $ 20,130,034.00 ($1,560 134 00) $205,462,591.19 $203,902,457.19 $41,184,956.00 156,265,861.95 8,011,773.24 ($1,560.134 00) 0.00% 9.11% Fay. Professional Services $56,000 and Legal Services $10,000 due to less than anticipated use. Partially offset by unfavorable Administrative Overhead ($17,700) due to agency fees associated with wall street ratings for DTRF tax notes. Also, Indirect Costs ($17,900) due to actual charges determined after budget finalization. 84.13% Fay. related to lower debt interest rates/level of debt. 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 1.44% 29,000.00 265,000.00 294,000.00 $479,900.00 315,000.00 315,000.00 4,005,543.00 4,005,543.00 10,800,000.00 10,800,000.00 1,607,350.00 1,607,350.00 1,871,300.00 1,871,300.00 1,323,300.00 1,323 300.00 $ 19,607,493.00 $ 19,607493.00 $ 20,424,034 00 $ 20,424,034.00 ($2,040,034.00) ($2,040,034.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 DTRF 51600 Quarterly Forecast.xfsx 882015
DELINQUENT PERSONAL PROPERTY TAX (51800) FY 2016 THIRD QUARTER REPORT ENTERPRISE FUNDS TREASURER ADOPTED AMENDED FY 2015 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUE OPERATING EXPENSE $733,042.00 936,038.00 $733,042.00 936,038.00 $550,000.00 812,111.00 ($183,042.00) $123,927.00 -24.97% - Unfav. Administration Fees ($180,700) due to fewer delinquencies and Reimb Salaries ($2,300) due to less than anticipated use. 13.24% - Fay. Controllable Personnel $44,100 due to underlined position. Also, favorable Professional Services $144,200, Postage-Standard Mailing $10,000, Expendable Equipment $2,000, Metered Postage $2,000 and Office Supplies $1,500 due to less than anticipated use. Partially offset by unfavorable Indirect Costs ($81,900) due to actual charges determined after budget finalization. NET OPERATING INCOME (LOSS) ($202,996.00) ($202,996.00) ($262,111.00) ($59,115.00) 29.12% NON-OPERATING REVENUE (EXPENSE) 6,288.00 6,288.00 1,600.00 ($4,688.00) -74.55% Unfav. Due to lower investment base. TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS ($196,708.00) ($196,708.00) $ (260,511.00) ($63,803.00) TRANSFERS OUT TOTAL NET INCOME (LOSS)* ($196,708.00) ($196,708.00) ($260,511.00) ($63,803.00) TOTAL NET POSITION - BEGINNING 327,098.78 TOTAL NET POSITION - ENDING $66,587.76 * Please note that in the Adopted Budget (line-item book) this is budgeted as 'Planned Use of Balance" in the revenue category. 9/4/2015 89
COUNTY OF OAKLAND FY 2915 THIRD QUARTER REPORT ENTERPRISE FUND PARKS & RECREATION ADOPTED BUDGET AMENDED BUDGET FY 2015 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OAKLAND COUNTY PARKS & RECREATION COM MISS/ON (50800) $ 8,752,911.00 $ 9,210,411 00 $ 9,359,511.00 $ 149,100.00 1.62% Unfav. Greens Fees ($57,500) and Rental Golf Carts ($21,000) due to unfavorable early summer weather conditions. Fax. Entrance Fees Gen Admission due to favorable late summer weather, $95,000. Fax. Fees Camping $183,100 based on continued increased demand and favorable camping weather conditions. Fax. Temporary Licenses $33,200 based on activity. Unfav. Antenna Site Management ($60,000) due to anticipated additional towers that did not take place at Addison Oaks and Springfield Oaks, Unfav. Commission Food Services ($50,900) due to seasonal fluctuations and demand. Cnfav Sales Retail ($35,000) and Sales ($50,000) due to less than anticipated activity. $ 25,151,352.00 5 25,561,432.00 $ 24,587,432.00 $ 974,000.00 3.81% Due to operating losses the past two years the Pants and Recreation Commission approved to reduce the FY2015 budget by $1,601,123 to maintain fund balance. The recommended budget amendment removes historical operating expense favorabillies in the following accounts: Salaries and Fringe Benefits $711,313, Building Maintenance Charges $272,700, Software Support Maintenance $61,500, Travel and Conference $20,000, Expendable Equipment $110,210, Advertising $100,000, Greenhouse Allocation $21,900, Design Fees $33,500, Info Tech Development $150,000 and General Program Administration $100,000 Unfav. Ad) Prior Years Exp ($106,500) for cancelled capital project which were expensed. Unfav. Contracted Services ($119,000), Unfav. Natural Gas ($75,000), Training ($13,900), Design Fees ($30,300) due to increased activity and demand. Grounds Maintenance ($130.000) ix offset by fay. Building Maintenance Charges. Unfav. Uniforms ($57,000) due to replacement needs. Unfav. Maintenance Department Charges ($16,800) due to required maintenance. In addition, Planned Use of Balance was used to purchase seven (7) pickup trucks from the Motor Pool at a cost of ($208,552) during the second quarter of FY2015 contributing to overal operating expense projections exceeding revenues, as described below. $ (16,398,441.00) 5 (16,351,021.00) $ (15,227.921.00) $ 1.123,100.00 6.87% $ 16,398,441.00 $ 16,351,021.00 $ 13,477,921 90 $ (2,873,100.00) -17.57% Fax. Property Tax Levy $143,100 based on actual collections. Non-operating revenue budget inducted Planned Use of Fund Balance, $4,271,071. FY2015 operating expenses are expected to exceed revenues by $1.75 million based on projected fourth quarter seasonal trends and year-to-date operating activity. Fax. Prior Years Revenue $33,900 and Gain on Saie of Vehicles $25,600. Unfav. Increase Market Value Invest ($70,500). (1,750,000.00) S (1,750,000.00) 0.00% $ (1.750,000.00) $ (1.750,00000) 95,820, .$47 29 $ 94,070.847 29 OPERATING REVENUE OPERATING EXPENSE NET OPERATING INCOME (LOSS) NON-OPERATING REVENUE (EXPENSE) TOTAL NET INCOME (LOSS)* TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING TOTAL INCOME BEFORE TRANSFERS TRANSFERS IN CAPITAL IMPROVEMENT PROGRAM 901/2015
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT INTERNAL SERVICE FUND WATER RESOURCES COMMISSIONER ADOPTED AMENDED FY 2015 VARIANCE BUDGET BUDGET FORECAST FAVONFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DRAIN EQUIPMENT FUND ( 63900) OPERATING REVENUES: Inside $32,999,781.00 $33,412,837.00 $31,706,108.00 ($1,706,729.00) -5.11% Unfav - Reimbursement Salaries ($1,700,000) due to unallocated payroll charges for turnover and vacant positions offset in Salaries and Fringes. Unfav - Rebilled Charges ($50,000) revenue is determined by a decrease in rebillable repair jobs, offset by favorable expenses pertaining to the repair jobs. Fav - Reimbursement Building Space Cost $43,271 due to updated allocation to include the new Office Building on Dixie Highway; partially offset by unfavorable operating expenses for new office building. Outside 351,000.00 351,000.00 201,000.00 ($150,000.00) -42.74% Unfav - External Rebilled Charges Revenue ($150,000) revenue is determined by a decrease in rebillabie repair jobs, offset by favorable expenses pertaining to the repair jobs. Total Revenue 33,350,781 00 33,763,837.00 31,907,108.00 (1,858,729.00) -5.50% OPERATING EXPENSES 33,679,949.00 33,959,775.00 31,920,311.00 2,039,464.00 6.01% Fav - Salaries $1,000,000 and Fringes $700,000 due to turnover and vacant positions. Fav - Drain Equipment Labor $200,000, Drain Equipment $40,000 and Drain Equipment Materials $4,500 due to a decrease in the amount of rebili projects. Fay - Indirect Cost $140,000 due to indirect cost rate finalized after budget process. Fav - Protective Clothing and Equipment $25,000 due to decreased spending for replacement and maintenance on gas detectors. Fay - Information Technology Development $11,000 a result of less maintenance performed on the Automatic Meter Reading System. Fay - Depreciation Buildings $8,623 due to over estimated depreciation schedule, Fav - Maintenance Department Charges $7,000 over estimate in charges to the department for SCADA dispatch services. Fav - Equipment Rental $2,000 a decrease in specialty equipment needed for maintenance projects. 931/2015
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT INTERNAL SERVICE FUND WATER RESOURCES COMMISSIONER ADOPTED AMENDED FY 2015 VARIANCE BUDGET BUDGET FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Fav - Material and Supplies $100,000, Equipment Maintenance $8,500 and Computer Supplies $5,000 the result of actual spending being less than budget projection. Unfav - Maintenance Supplies ($6,500) a result of needed maintenance supplies at the new Office Building on Dixie Highway. Unfav - Electric Service ($7,300), Natural Gas ($1,000) and Water and Sewage Charges ($1,000) due to the new Office Building on Dixie Highway. Unfav - Personal Mileage ($1,000) due to employees using their own personal vehicles to attend meetings. Unfav - Motor Pool ($90,000), Equipment Repair Motor Vehicle ($50,500), Other Expendable Equipment ($24,000), Info Tech Operations ($13,745), Small Tools ($10,000), Laboratory Supplies ($3,500) and Shop Supplies ($2,100) the result of actual spending being more than budget projection. (329,168 00) (195,938.00) (13,203.00) 182,735.00 -93.26% 729,168.00 729,168 00 716,313.00 (12,855.00) -1.76% Unfav - Gain on Sale of Vehicles ($25,000) the result of sales for these items at county auction being less than anticipated budget projection. Fav - Interest Expense $11,900 a result of the decreasing principal balance and decrease in variable interest rate related to the Drain Equipment Storage Building loan from Delinquent Tax Revolving Fund and the loan from GVVK Fund for 2 Vactors and +,-. NET INCOME (LOSS) BEFORE NON-OPERATING REVENUE/(EXPENSE) TRANSFER IN 0.00% TRANSFERS (OUT) 133,230.00 133,230.00 0.00% NET REVENUES OVER (UNDER) $400,000.00 8400,000.00 $569,880.00 $169,880.00 EXPENSES TOTAL NET ASSETS - BEGINNING 8,361,173.07 TOTAL NET ASSETS - ENDING $8,931,053.07 I 2 0 1 5
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT INTERNAL SERVICE FUND RISK MANAGEMENT ADOPTED AMENDED FY 2015 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES LIABILITY INSURANCE FUND 67700 OPERATING REVENUES: Outside Revenue $ 16,192.00 16,192.00 11,800.00 $ (4,392.00) -27.12% - Unfav. due to external property billings less than budgeted. Inside Revenue 2,475,176.00 2,475,176.00 2,353,400.00 (116,776.00) -4.72% - Unfav. due to rebills to departments lower based on actual premiums paid, offset by decrease in expense. Total Operating Revenue $ 2,491,365.00 $ 2,491,368.00 $ 2,370,200.00 $ (121,168.00) -4.86% OPERATING EXPENSE $ 3,533,550 00 $ 3,533,550.00 $ 2,689,300.00 $ 844,250.00 23.89% - Fav. due to actual premiums less than expected due to insurance market fluctuations and rates, partially offset by decrease in revenue. CLAIMS PAID 769,400.00 769,400.00 6,247,900.00 (5,478,500.00) -712.05% Unfav. due to timing and claim amounts more than anticipated with budget. TOTAL OPERATING EXPENSES $ 4,302,950.00 $ 4,302,950.00 5 8,937,200.00 $ (4,634,250.00) -107.70% OPERATING INCOME (LOSS) (1,811,582.00) (1,811,582.00) (6,567,000.00) (4,755,418.00) 262.50% NON-OPERATING REVENUE (EXPENSE) 150,000.00 150,000.00 172,000.00 22,000.00 14.67% - Fav. due to conservative investment income budgeted. NET REVENUES OVER/(UNDER) EXPENSES $ (1,661,582.00) $ (1,661,582.00) (6,395,000.00) $ (4733,418.00) TOTAL NET POSITION - BEGINNING 12,516,265.00 TOTAL NET POSITION - ENDING $ 6,121,265.00 9/4/2015 93
OPERATING REVENUE RETIREES MEDICAL - VESA DEBT RETIREMENT ADMINISTRATION RETIREMENT ADMINISTRATION - PTNE DEFINED CONTRIBUTION PLAN 33,998,500 2,511,900 160,000 14.700,000 33,998,500 2,511,900 160,000 14,700,000 34,998,500 2,591,900 200,000 16,950,000 1,000,000 80,000 40,000 1,250,000 DEFINED CONTRIBUTION PLAN - PINE EMPLOYEE IN-SERVICE TRAINING EMPLOYEE BENEFITS UNIT FLEX BENEFIT PLAN WELLNESS UNIT FRINGE BENEFITS TUITION REIMBURSEMENT RETIREMENT HEALTH SAVINGS GROUP LIFE INSURANCE SOCIAL SECURITY MEDICAL INSURANCE PRESCRIPTION COVERAGE INSURANCE DENTAL INSURANCE VISION INSURANCE DISABILITY INSURANCE 200,000 1,351,200 833,700 200,000 701,900 94,000 460,000 1,200,000 555,000 14,600,000 34,551,000 9,590,000 3,038,000 217,500 2,530,000 200,000 1,351,200 833,700 200,000 701,900 94,000 460,000 1,200,000 555,000 14,600,000 34,551,000 9,590,000 3,038,000 217,500 2530,000 3,009,800 700,000 319,600 5,000,000 280,000 200,000 1,351,200 855,700 205,000 723,900 94,000 460,000 1,490,000 515,000 15,300,000 33,551,000 9,470,000 3,358,000 312,500 2,660,000 3,139,800 700,000 319,600 5,000,000 170,000 WORKERS COMPENSATION 3,009,800 UNEMPLOYMENT COMPENSATION 700,000 INVESTMENT INCOME 319,600 EXT - FLEX BEN MEDICAL - EMPLOYEE 5,000,000 EXT - MEDICAL INSURANCE 280,000 EXT PRESCRIPTION DRUG REBATES 700,000 700,000 839,900 EXT - DENTAL INSURANCE 25,000 25,000 15,000 EXT - VISION INSURANCE EXT - FLEX BEN LIFE INSURANCE EXT - FLEX BEN DENTAL INSURANCE EXT - FLEX BEN VISION INSURANCE EXT - FORFEITURE OF DEPOSITS 1,500 355,000 115,000 105,000 20,000 1,500 355,000 115,000 105,000 20,000 1,500 378,000 110,000 113,000 816,000 FRINGE BENEFITS FUND 67800 ADOPTED AMENDED BUDGET BUDGET COUNTY OF OAKLAND FY2015 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND FY2015 VARIANCE FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 2.94% - Charges from departments favorable due to underestimated budget. 3.18% - Favorable due to projected revenue more than budget projections. 25.00% - Favorable due to projected revenue more than budget projections. 8.50% - Favorable due to projected revenue more than budget projections - increase of new hires who participate in the Defined Contribution Plan. Offset by unfavorable expense. 0.00% 0.00% 22,000 2.64% - Favorable due to projected revenue more than budget projections. 6,000 2.50% 22,000 3.13% - Favorable due to projected revenue more than budget projections. 0.00% 0.00% 290,000 24.17% - Favorable due to projected revenue more than budget projections. Offset by unfavorable expense. (40,000) -7.21% - Unfavorable due to projected revenue less than budget projections. Partially offset by favorable expense. 700,000 4.79% - Favorable due to projected revenue more than budget projections - increase in new hires. Offset by unfavorable expense. (1,000,000) -2.89% - Unfavorable due to projected revenue less than budget projections, Offset by favorable expense. (120,000) -1.25% - Unfavorable due to projected revenue less than budget projections. Offset by favorable expense. 320,000 10.53% - Favorable due to projected revenue more than budget projections. 95,000 43.68% - Favorable due to projected revenue more than budget projections. 130000 5.14% ..Favorable due to projected revenue more than budget projections. Offset by , unfavorable expense. 130,000 4.32% - Favorable due to projected revenue more than budget projections. 0.00% 0.00% 0.00% (110,000) -39.29% - Unfavorable due to projected revenue less than budget projections. Offset by favorable expense. 139,900 19.99% - Favorable due to projected revenue more than budget projections. (10,000) -40.00% - Unfavorable due to projected revenue less than budget projections. Offset by favorable expense. 0.00% 23,000 6.48% - Favorable due to projected revenue more than budget projections. (6,000) -4.35% 8,000 7.62% 796,000 3980.00% - Favorable due to forfeitures of non-vested International City Management Association (ICMA) accounts; forfeitures are not budgeted. EXT - TRAINING EXT - WELLNESS - EXT - OTHER REVENUE - LOMA REBATES 150,000 Transfer In 4,555,000 TOTAL REVENUE 136,828,600 3,000 10,700 160,000 112,500 4,555,000 4,565,000 136,828,600 140,570,700 0.00% 0.00% - Favorable due to sponsorship of Wellness programs. -25.00% - Unfavorable due to termination of ICMA rebates - rebates return to employees. 0.00% 2.73% 3,000 10,700 (37,500) 3,742,100 99142015
OPERATING EXPENSE RETIREES MEDICAL - VEBA DEBT PRINC. RETIREES MEDICAL - VEBA DEBT INT. RETIREMENT ADMINISTRATION FLEXIBLE BENEFIT PAYMENTS WELLNESS PROGRAM DEFINED CONTRIBUTION PLAN - PTNE PENSION CONTRIBUTION EXPENSE EMPLOYEE IN-SERVICE TRAINING IN-SERVICE TRAINING - INFO TECH EMPLOYEE BENEFITS UNIT DEFINED CONTRIBUTION PLAN 94,700 0.00% (500) 0.00% 3.54% 15,950,000 (1,250,000) 14,700,000 14,700,000 0.00% 0.00% 3.50% 0.00% 200,000 4,555,000 966,200 350,000 35,000 - Favorable due to one vacant position and two underfilled positions. 3.27% 882,446 29,800 - Favorable due to two underfilled positions and one position underflled for two months and vacant for two months, offset by unfavorable Professional Service spending due to new contract. 100,000 100,000 50.00% - Favorable due to projected costs less than budget projections 664,700 37,200 5.30% - Favorable due to projected saving in Professional Services, Special Event Program and Wellness Rewards. 200,000 4,555,000 1,001,200 350,000 912,246 200,000 4,555,000 1,001,200 350,000 912,246 - Favorable due to projected Sick and Annual Leave Cash-Out costs less than budget projections. -8.50% - Unfavorable due to projected costs more than budget projections - Increase of new hires who participate in the Defined Contribution Plan. Offset by favorable revenue. 200,000 200,000 701,900 701,900 21,410,000 12,588,500 2,671,900 21,410,000 12,588,500 2,671,900 21,410,000 12,589,000 2,577,200 FRINGE BENEFITS FUND 67800 COUNTY OF OAKLAND FY2015 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND ADOPTED AMENDED FY2015 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 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 94,000 94,000 94,000 0.00% 460,000 460,000 300,000 160,000 34.78% - Favorable due to projected costs less than budget projections. 1,200,000 1,200,000 1,490,000 (290,000) -24.17% - Unfavorable due to projected costs more than budget projections - increase of new hires who participate in the Retirement Health Saving Plan. Offset by favorable revenue. 910,000 910,000 886,000 24,000 2.64% - Favorable due to reduction of group life insurance rate in renewal contract with Hartford. Offset by unfavorable revenue. 14,600,000 14,600,000 15,300,000 (700,000) -4.79% - Unfavorable due to projected costs more than budget projections - increase in new hires. Offset by favorable revenue. 38,921,454 38,921,454 36,921,454 2,000,000 5.14% - Favorable due to projected costs less than budget projections. Partially offset by unfavorable revenue. 10,200,000 10,200,000 9,800,000 400,000 3.92% - Favorable due to projected costs less than budget projections. Partially offset by unfavorable revenue. 3,150,000 3,150,000 3,065,000 85,000 2.70% - Favorable due to projected costs less than budget projections. 324,000 324,000 280,000 44,000 13.58% - Favorable due to projected costs less than budget projections. 2,530,000 2,530,000 2,700,000 (170,000) -6.72% - Unfavorable due to increase of disability rates in renewal contract with Hartford. Partially offset by favorable revenue. 3,009,800 3,009,800 2,233,800 776,000 25.78% - Favorable due to projected Claims costs less than budget projections. 700,000 700,000 400,000 300,000 42.86% - Favorable due to the nonqualification of seasonal workers, State of Michigan reduction in the weeks eligible and termination of the extended benefits. 209,600 209,600 209,600 - 0.00% 35,000 35,000 51,000 (16000) -45.71% - Unfavorable due to projected costs more than budget projections 504,000 504,000 502,000 2,000 0.40% 386,000 386,000 346,000 40,000 10.36% - Favorable due to tax rate reduction of Michigan Health Insurance Claims Assessment Act. PATIENT CENTERED OUTCOME RESEARC 24,000 24,000 15,300 INDIRECT COSTS 280,000 280,000 391,500 TOTAL EXPENSE 136,828,600 136,828,600 135,230,200 NET REVENUE OVER/(UNDER) EXPENSES 0.00 0.00 5,340,500 TOTAL NET POSITION - BEGINNING 33,493,389 TOTAL NET POSITION - ENDING 38,833,889 8,700 (111,500) 1,598,400 5 340 500 36.25% -39.82% - Unfavorable due to actual charges developed after budget finalization. 1.17% 9P4/2015
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT ENTERPRISE FUNDS CENTRAL SERVICES ADOPTED AMENDED FY 2015 VARIANCE BUDGET BUDGET FORECAST FAV1(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $97,500.00 2.27% - Fee. Land Lease $48,000 due to increase in land leases, T-hangar Rental $32,600 due to increased number of T-hangars rented, Car Rental Concessions $28,100 due to increased car rentals, Aviation Gas $17,900 due to higher than anticipated gas concessions, Landing Fees $8,600 due to more transient aircraft utilizing the airport, Miscellaneous $8,000 due to special events - airport expo and ground run-up enclosure photo shoots, and Parking Fees $2,700 due to increased customer parking; Unfav, Reimb US Customs Service ($42,200) due to fewer international flights needing services by Customs, (offset by favorable US Customs Service Expense), Tie Down ($5,000) due to less than expected tie down revenues, and Late Penalty ($2,200) due to more timely payments from customers. (55,500,00) -0.83% - Unfav. Depreciation Land Improvements (837,200) due to closing of capital projects, Ad) Prior Years Exp ($22,200) due to US Customs invoices received for prior fiscal year services, Building Maintenance Charges ($16,800) due to renovations at Troy airport, Grounds Maintenance ($15,600) due to snow removal and landscape repairs, Electrical Supplies ($12,500) and Maintenance Supplies ($10,000) due to renovations at Troy airport Professional Services ($6,000) due to renovations at Troy airport and Equipment Maintenance ($5,000) due to an increase in equipment needing maintenance, Travel and Conference ($2,600) due to two employees attending fire school, Workshops and Meeting ($1,900) due to additional charges associated with meetings, Firefighting Supplies ($1,600) due to replenishment of firefighting supplies, Grounds Supplies ($1,400) due to additional supplies needed for grounds maintenance, Management Services ($1,200) due to higher than expected management fees, and Office Supplies ($1,200) due to the purchase of office chairs; Fay. US Customs Services $30,000 due to fewer international flights needing services by customs, offset by unfavorable Reimb US Customs Service revenues, Indirect Costs $15,500 due to actual charges being developed after budget finalization, Electrical Service $14,600 due to lower energy costs with DTE and Consumers, Water and Sewage Charges $9,600 due to less than expected expenses, Gasoline Chargers $5,800 due to decrease in fuel costs, Security Expense $5,000 due to IT taking over phone services including security system charges, Training $2,400 due to fewer trainings attended by staff, and Refund Prior Years Expenditure $2,200 due to project reimbursements from prior years and reimbursement for damages by landscape vendor. .........L1.1,n•nnn••n••••••• OAKLAND COUNTY INTERNATIONAL AIRPORT (56500) OPERATING REVENUE $4,297,821.00 $4,297,821.00 $4,395,321.00 OPERATING EXPENSE 6,654,963.00 6,654,963,00 6,710,463.00 NET OPERATING INCOME (LOSS) NON-OPERATING REVENUE (EXPENSE) TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS TRANSFERS IN ($2,357,142.00) ($2,357,142.00) ($2,315,142.00) 278,744.00 278,744.00 144,144.00 ($2,078,398.00) ($2,078,398.00) $ (2,170,998.00) $42,000.00 (134,600.00) ($92,600,00) -1.78% -48.29% Unfav. Income from Investments ($137,250) due to lower than expected interest rates; Fav. Sale of Scrap $2,000 due to sale of scrap wire, and Gain on Sale of Equipment $650 due to sale of miscellaneous equipment at Spring auction. CAPITAL CONTRIBUTIONS 0.00 0.00 382,458.00 $382,458.00 To recognize Federal and State contributions for capital projects that have been completed. TOTAL NET INCOME (LOSS)* TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING ($2.078,398.00) ($2,078,398.00) ($1,788,540,00) $ 80,154,509.84 $78,365,969.84 $289.858.00 9/4/2015 *Please note that in the Adopted Budget (line-item bock) this is budgeted as "Planned Use of Fund Balance" in the revenue category and "Budgeted Equity Ad)" in expenses. 96
TRANSFERS IN / (OUT) NET REVENUE OVER/(UNDER) EXPENSES" 621,149.00 621,149.00 $ $ (331,177.00) $ 306,574.00 $ 945,774.00 $ 639,200.00 23,500.00 COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS CENTRAL SERVICES ADOPTED BUDGET AMENDED BUDGET FY2015 FORECAST VARIANCE FAW(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 'MOTOR POOL FUND 66100 29.55% - Fay. Ext-Productive Labor Rev $52,500 and Ext-Parts and Accessories $13,900 due to CVT's requesting patrol car build-ups; Unfav. Ext-Warranty Reimbursement ($28,000) due to fewer Claims, Ext-Other Revenue ($9,000) due to fewer subrogation payments for vehicle damages. 3.93% - Fav. Leased Equipment $294,100 based on actual activity trends to date, Parts and Accessories $60,700, Productive Labor $58,200, and Sublet Repairs $46,000 due to fleet expansion within various departments; Unfav. Gasoline Oil Grease Charges ($159,000) due to lower fuel costs, offset by favorable Gasoline expense. OPERATING REVENUE: Outside Revenue 99,500.00 $ 99,500.00 128,900.00 29,400.00 Inside Revenue 7,457,194.00 7,626,513.00 7,926,513.00 $ 300,000.00 2.07% - Fav. Gasoline Charges $693,600 due to lower fuel costs, (partially offset by unfavorable fuel revenue), License Plates and Title Fees $30,000 due to lower than anticipated usage, Car Wash $8,000 due to lower than anticipated usage, and Travel and Conference $2,400 due to fewer travel expenses than anticipated, Refund Prior Years Expenditure $1,000 due to reimbursement of expenses paid in FY2014 ; Unfav. Depreciation Vehicles ($116,000) due to additional vehicles purchased, Parts and Accessories ($111,800) due to feet expansion, Insurance Reserve Expense ($97,100) due to additional costs to repair garage leased vehicles involved in accidents, Sublet Repairs ($80,000) due to hail damage repairs and pit car transmission repairs and replacements, Indirect Costs ($46,700) due to actual charges being developed after budget finalization, Tires and Tubes ($31,500) due to increased cost of tires and increased fleet, Insurance ($23,700) due to increased feet, Expendable Equipment ($23,000) due to fleet expansion within various departments, Shop Supplies ($15,000) due to increased activity in shop, Auction Expense ($7,500) due to higher number of vehicles sold at auction, Oil Grease and Solvents ($4,900) due to the purchase of additional solvents, Laundry and Cleaning ($2,300) due to higher cleaning charges, Equipment Maintenance (61,600) due to unexpected equipment repairs and Custodial Supplies ($1,100) due to additional supplies needed. Total Revenue $ 7,556,694.00 $ 7,726,013.00 $ 8,055,413.00 $ 329,400.00 OPERATING EXPENSE 8,146,371.00 8,281,911.00 8,110,411.00 $ 171,500.00 OPERATING INCOME (LOSS) $ (589,677.00) $ (565,898.00) $ (54,998.00) $ 500,900.00 NON-OPERATING REVENUE (EXPENSE) 235,000.00 241,323.00 379,623.00 $ 138,300.00 57.31% - Fav. Sale of Vehicles $145,400 due to proceeds from vehicles sold at auction; Unfav. Income from Investments ($8,000) due to lower than expected interest rates. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS $ (354,677.00) $ (314,575.00) $ 324,626.00 $ 639,200.00 TOTAL NET POSITION - BEGINNING $ 8,216,738.87 TOTAL NET POSITION - ENDING $ 9,162,512 87 97 "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 Ad)' in Expenses. 9/4/2015
ADOPTED BUDGET FACILITIES MAINTENANCE & OPERATIONS (#63100) AMENDED BUDGET COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT INTERNAL SERVICE FUND FACILITIES MANAGEMENT FY 2015 VARIANCE FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUES: Outside Revenue $333,500.00 $333,500.00 $737,515.00 $404,015.00 121.14% - Fav. External- Other Revenue $250,000 more than anticipated Outside Agencies Maintenance Charges for Oakland County Community Mental Health Authority (OCCMHA); $136,000 subrogation payment for property damage; and $18,015 insurance claims reimbursement for water damage at Courthouse. Inside Revenue 22,813,360.00 22,824,193.00 22,824,193.00 0.00% NET INCOME (LOSS) BEFORE OPERATING TRANSFERS $23,146,860.00 $23,157,693.00 $23,561,708.00 $404,015.00 1.74% $27,093,014.00 $27,250,049.00 $25,180,549.00 $2,069,500.00 7.59% -Fav. Salaries and Fringe Benefits $675,000 due to underfilled/vacant positions; Electrical Service $500,000 due to lower-cost third-party contracts and savings from FM&O energy conservation initiatives; Natural Gas $400,000 due to purchasing natural gas from third party sources; Sublet Repairs $300,000 due to more efficient management of building maintenance; Water & Sewage Charges $250,000 and Road Salt $45,000 based on actual usage; Security Supplies $100,000 due to funding through security enhancement projects; Radio Communications $50,000 due to budget allocation which includes one time charge from FY 2014 that will not reoccur in FY 2015. Partially offset by unfav. IT Operations ($60,000) primarily for new CAD workstations and GIS training; Adj Prior Years Exp ($55,500) due to adjustment of sewage charges; Material and Supplies ($50,000) to account for higher than anticipated inventory usuage; Info Tech Development ($50,000) due to Kronos project as well as City Works Workorder Mobile Project; Motor Pool ($20,000) due to vehicle fleet expansion; and Maintenance Supplies ($15,000) due to increased cost of materials. ($3,946,154,00) ($4,092,356.00) ($1,618,841.00) $2,473,515.00 Total Revenue OPERATING EXPENSES NON-OPERATING REVENUE $100,000.00 $118,750,00 $118,750.00 $0.00 0.00% - TRANSFERS IN TRANSFERS OUT NET REVENUES OVER(UNDER) EXPENSES" 67,055.21 67,055.21 0.00% - Transfers In from Project Work Order Fund for closed Maintenance Projects. (134,910.00) (145,349.82) (10,439.82) 0.00% - Transfers Out to Project Work Order Fund to close Maintenance Projects. ($3,846,154.00) ($4,108,516,00) ($1,578,385.61) $2,530,130.39 TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING $10,442,409.97 $8,864,024.36 *Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category. 9/§2015
ADOPTED BUDGET AMENDED BUDGET Information Technology - Operations (63600) OPERATING REVENUES: Outside $1,750,518.00 $1,750,518.00 COUNTY OF OAKLAND FY 2016 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY FY 2015 VARIANCE FORECAST FAVI(UNFAVI PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $2,151,818.00 $401,300.00 22.92% - Fay. Enhanced Access Fees $387,800 and Managed Print Services $25,500 due to higher than anticipated usage. Offset by unfav.Outside Agencies ($8,000) due to fewer non-emergency agencies than anticipated and Deferred Land File Tax ($4,000) due to lower than anticipated usage. -5.28% Unfav. OC Dept l ($1,462,300) and fav. OC Dept Ops & Non_Gov Ops $148,000 due to rates remaining at phor year levels & limited resources available to complete development due to vacancies. Fav. Equip Rental $16,200 due to increased rebills to departments for maintenance charges on IT Office Equipment items. Inside 24,550,372.00 24,567,718.00 23,269,618.00 (1,298,100.00) TOTAL OPERATING REVENUE $26,300,890.00 $26,318,236.00 $25,421,436.00 ($896,800.00) -3.41% OPERATING EXPENSES $33,334,833.00 $34,345,179.00 $31A99,179.00 $2,846,000.00 8.29% - Fav.Salarles & Fringes $2,485,500 due to vacant positions; Depreciation $605,900 for IT capital projects in progress net fully operational; Expendable Equipment $580,300 for equipment replacement; Software Maintenance $347,100 due to timing of software support payments; Equipment Maintenance $346,100 due to lower than anticipated hardware maintenance costs; Indirect Cost $88,700; Communications $80,000 due to rate reductions; Printing $68,300, Membership Dues $8,700 Travel $8,500 Mileage and $7,500 due to lower than anticipated usage. Partially offset by unfav. Professional Services ($1,295,200) for previously approved IT projects; a budget amendment is recommended to adjust Prof Svcs to account for projects previously approved in prior year. Unfav. Contracted Services ($311,000) due to increase in usage; Charge Card Fees ($123,300) for increase of credit card activity, Supplies ($25,700) and Internal Services ($25,400) based on usage. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS ($7,033,943.00) ($8,026,943.00) ($6,077,743.00) $1,949,200.00 NON-OPERATING REVENUE 105,500.00 105,500.00 113,200.00 7,700.00 7.30% Fav. primarily due to Interest Income; higher cash balance than anticipated. TRANSFERS IN 3,915,971.00 4,981,208.00 4,981,208.00 0.00 0.00% TRANSFERS (OUT) 0.00% CAPITAL CONTRIBUTION 1,310,640.00 1,310,640.00 1,738,440.00 427,800.00 0.00% Fav. Capital Contributions revenue recognized for Building Authority Capital Projects for IT. NET REV OVER(UNDER) EXP" ($1,701,832.00) ($1,629,595.00) $755,105.00$-ZI,R12‘013 TOTAL NET ASSETS- BEGINNING 21,609,586.44 TOTAL NET ASSETS - ENDING $22,364,691.44 *Please note that in the Adopted Budget (line-item book) this is budgeted as 'Planned Use of Fund Balance" in the revenue category. 99
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS I ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET AMENDED BUDGET FY 2015 FORECAST VARIANCE FAIMUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - Telephone Communications (67500) OPERATING REVENUES: Outside $30,000.00 $30,000.00 $9,700.00 $ (20,300.00) -67.67% Unfav. Sale of Phone External due to reduction in landline charges. Inside 2,828,952.00 2,830,052.00 82,858,552.00 25,500.00 1.01% Fay. Sale of Phone Internal due to increased usage. TOTAL OPERATING REVENUE OPERATING EXPENSES 52,858,952.00 $2,860,052.00 $3,307,438.00 $3,308.538.00 $2,868,252.00 $2,945,938.00 $8,200.00 $362,600.00 0.29% 10.96% Fay. Depreciation $239,800 subsequent to budget; Sublet Repairs $74,000 due to lower than anticipated repair volume; Communications $44,800 due to decreRd rates; Software Maintenance $23,900 due to tower maintenance rates; Maintenance Equipment $18,900 due to lower than anticipated contract rates; Tower Charges $8,500 due to decreased pager usage; Travel $5,200 due to decreased usage and Fringes $2,800 due to reduced Fringe Benefit Rate. Partially offset by unfav. Internal Services ($36,400) due to actual usage; Voice Mail ($11,000) due to higher than anticipated costs and Equipment Maintenance ($7,900) due to maintenance costs being higher than the budget projection. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS ($448,486.00) ($448,486.00) (577,686.00) $370,800.00 NON-OPERATING REVENUE 30,000.00 30,000.00 35,500.00 5,500.00 18.33% Fay, primarily due to Interest Income; higher cash balance than anticipated. TRANSFERS IN - - 0.00% TRANSFERS (OUT) 0.00% NET REV OVER( UNDER) EXP* ($418,486.00) ($418,486.00) ($42,186.00) 5376,300.00 TOTAL NET ASSETS - BEGINNING 4,116,226.81 TOTAL NET ASSETS - ENDING 54,074,040.81 *Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category. 100
COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS I ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2015 VARIANCE BUDGET BUDGET FORECAST FAVHUNFAVI PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - CLEMIS (53500) OPERATING REVENUES: Outside $3,829,116.00 $3,829,116.00 $4,301,616.00 $472,500.00 12.34% Fay. CLEMIS Crash 5146,000, CLEMIS Citation $82,100, CLEMIS Parking $11,000 and Crime Mapping $4,500 due to increased usage by Oakland and non-Oakland agencies; Rebilled Charges $178,200 and Parts & Access $4,100 billed to Tier 2,5 & 3.0 agencies for connectivity costs; Access Oakland Fee $30,500 due to updated law enforcement Full Time Equivalent count used for billing and Maintenance Contracts $16,100 due to an increase in the volume of agency owned equipment out of warranty that was not included in the budget projection. Inside 2,158,732.00 2,162,661.00 1,912,561.00 (249,900.00) -11.56% Unfav. Service Fees ($264,700) based on actual billing for Computer Aided Dispatch (CAD) expense charge directly to Radio Fund. Offset by fay. In-Car Terminals Internal $12,900 and OC Dept Ops $1,900 due to Mobile Data participation count higher than budget projection. TOTAL OPERATING REVENUE $5,987,848.00 $5,991,677.00 $6,214,277.00 $222,600.00 3.72% $8,817,035.00 ($2,829,187.00) 35,000.00 2,044,166.00 0.00 ($750.001.00) OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN TRANSFERS (OUT) CAPITAL CONTRIBUTION NET REV OVER(UNDER) EXP* TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING $8,817,035.00 $10,226,836.00 ($1,408,800.00) ($2,826,358.00) ($4,011,558.00) ($1,186,200.00) 35,000.00 96,900,00 63,900.00 2,044,186.00 2,044,186.00 0.00 364,000.00 _ 364,000 00 ($746,172.00) ($1,504,472,00) ($758,300.00) 20,321,097,99 $18 816,625.99 -15.98% Unfav. Depreciation ($1,238,700) due to additional equipment not included in the original budget projection; Professional Services ($673,700) due to higher than anticipated contractual costs for Simtech for an additional programmer; Software Maintenance ($549,900) due to additional software purchases in excess of budget projections; Rebillable Services ($220,600) based on actual connectivity costs to Tier 2.5 and 3.0 agencies; Bank Charges ($108,300) due to cost of PayPal services for E-Commerce transactions; Expendable Equipment ($21,600) due to higher than anticipated actual costs; Indirect Cost ($18,100); Travel ($5,800) and Supplies ($1,900) due to usage. Offset by fay. Salaries & Fringe Benefits $778,200 due to vacancies; Communications $200,000 due to actual costs less than anticipated, Equipment Maintenance $177,800 due to less than anticipated cost of repairs; Internal Services $177,100 based on actual usage and Software Rental $96,600 due to the timing of software expenses. 152.57% Fay. primarily due to Interest Income; higher cash balance than anticipated. 0.00% 0.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 and Budgeted Equity Ad) in Expenses. 101
TOTAL OPERATING REVENUE $5,981,000.00 OPERATING EXPENSES $8,948,128.00 NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN TRANSFERS (OUT) ($2,967,128.00) 180,000.00 7,800.00 (486,000.00) CAPITAL CONTRIBUTION NET REV OVER(UNDER) EXP" ($3.265,328.00) TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS- ENDING ($2,882,928.00) ($3,869,028.00) ($986,100.00) 45,619,328.45 $41 750 300.45 0.00% COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS I ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET AMENDED BUDGET FY 2015 FORECAST VARIANCE FAVi(UNFAVI PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - Radio Communications (53600) OPERATING REVENUES: Outside $5,595,000.00 $5,945,000.00 $5,924,200.00 ($20,800.00) -0.35% Unfav. Antenna Site Management ($22,300) due to removal of equipment and Outside Agency Revenue ($5,400) due to fewer non-emergency agencies than anticipated. Partially offset by Fav.Adjusted Prior Year Revenue $6,900. Inside 386,000.00 386,000.00 502,400.00 116,400.00 30.16% Fay. Parts Access $96,400 due to reimbursement by participating agencies for equipment replacement, Productive Labor $13,100 due to Mobile Data Computer repairs for OC Agencies and Leased Equip $6,900 due to higher than anticipated non-public users of the new system. 095,600.00 $8,948,128.00 $9, 995,928.00 ($1,047,800.00) $6,331,000.00 $6,426,600.00 ($3,569,328.00) 180,000.00 146,000.00 40,200.00 40,300.00 (486,000.00) (486,000.00) -11.71% Unfav. Depreciation ($1,755,600) due to acceleration of useful-lives for all portable and mobile radios; Software Lease ($40,300) due to the timing of software license purchases for new member agencies and Supplies ($14,000) due to usage. Partially offset by fay. Internal Services $276,100 based on usage; Professional Services $205,300 due to CAD Upgrade project enhancements; Salaries & Fringe Benefits $72,900 due to vacancies; Expendable Equipment $48,300 for equipment that falls under the threshold of a capitalized asset; Indirect Cost $48,200 subsequent to budget projection; Special Projects $40,000 due to timing of projects including tower painting; Equipment Maintenance $35,800 due to maintenance costs of the radio system; Utilities $27,900 based on actual usage and Travel $7,600 due to decline in out-of-state training. ($2,617,128_00) ($952,200.00) (34,000.00) -18.89% Unfav. Interest Income due to lower rates and cash balance than anticipated. 100.00 0,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 and Budgeted Equity Ad) in Expenses_ 102
$91,900.00 13.41% Fay. Salaries & Fringes $107,700 due to vacancies; Communications $18,100 due to decrease in connectivity rates; Software Maintenance $14,100 due to decrease in maintenance costs; Expendable Equipment $5,000 due to the timing of equipment purchases; Travel $4,000 due to decline in traveling; Equipment Maintenance $1,000 due to lower than anticipated server maintenance charges. Offset by unfav. Indirect Cost ($30,600) subsequent to budget,- Internal Services ($21,500) due to actual usage; Professional Services ($4,000) due to contractual costs higher than anticipated and Depreciation ($1,900) due to equipment that became operational subsequent to the budget projection. 0.00% 0.00% $54,875.00 400;659.38 $455,534.38 442,803.00 $90 900.00 TRANSFERS IN 413,145.00 442,803,00 TRANSFERS (OUT) NET REV OVER(UNDER) EXP" ($62478.00) ($33,025.00) TOTAL NET ASSETS BEGINNING TOTAL NET ASSETS - ENDING $675,076.00 ($478,623.00) 3,000.00 $685,107.00 ($481,828.00) 3,000.00 $593,207.00 ($390,428.00) 2,500.00 OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE $91,400.00 (500.00) -16.67% Unfav. Interest Income due to lower rates and cash balance than anticipated. COUNTY OF OAKLAND FY 2015 THIRD QUARTER REPORT INTERNAL SERVICE FUNDS! ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET AMENDED BUDGET FY 2015 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Fire Records Management ( 53100) OPERATING REVENUES: Outsicie TOTAL OPERATING REVENUES $196,453.00 $196,453.00 $203;279.00 $203,279.00 $202,779.00 $202,779.00 ($500.00) -0.25% Unfav. primarily due to Outside Agencies participation due to the timing of implementation of anticipated new member agencies. ($500.00) -0.25% "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. 103
OAKLAND COUNTY INTERNATIONAL AIRPORT WRITE-OFFS MAY 2015 CUSTOMER # CUSTOMER NAME INVOICE# INVOICE DATE AMOUNT TOTAL AIR00000031 AERO TOY STORE A1R0049164 10/15/2011 55.00 55.00 No response - phone calls, em ailed AIR00000033 AERODYNAMICS INC various 2012-2013 8,273.27 8,273.27 Declared bankruptcy 2012 - Unable to collect A1R00000627 HENNESSY, MICHAEL A1R0063980 10/15/2013 260.00 298.30 Renter passed away fall 2013 - AIR0063980 12/5/2013 (39.00) Unable to collect AIR0063980 12/30/2013 (208.70) A1R0064425 11/1/2013 26.00 A1R0064596 11/15/2013 260.00 A1R00000673 SWIFT AIR LLC AIR0054154 6/15/2012 600.00 798.48 Chapter 11 - Unable to collect AIR0054154 6/15/2012 198.48 AIR00000834 MARTIN, GARY various 2010 3,365.76 3,365.76 Declared bankruptcy 2010 - Unable to collect AIR00000899 MOTOR CITY AVIATION various 2010-2011 16,143.49 16,143.49 Sent to RDK Collections. Rich stated he was unable to collect. AIR00000924 NASHVILLE JET CHARTERS AIR0058414 1/15/2013 450.00 505.00 A/C sold/spoke to different AIR0058414 1/15/2013 55.00 companies. Charges from 2011 - Unable to collect A1R00001343 WINN, ROY A1R0043644 1/15/2011 240.00 1,582.00 Declared bankruptcy 2011 - AIR0043644 4/22/2013 (170.00) Unable to collect AIR0044283 2/15/2011 240,00 A1R0044919 3/15/2011 240.00 A1R0045533 4/15/2011 240.00 A1R0046152 5/15/2011 240.00 A1R0046788 6/15/2011 240.00 A1R0047435 7/15/2011 240.00 ,A1R0048440 9/1/2011 24.00 A1R0049073 10/1/2011 24.00 A1R0049713 11/1/2011 24.00 A1R00001484 DOVE AIR INC A1R0047850 8/15/2011 450.00 560.00 Bankruptcy 1/20/2012 A1R0047850 8/15/2011 55.00 -A1R0048527 9/15/2011 55.00 _ J:\FiscalSvc\Budget\Forecast_New1201513rd Quarter\Write-OffslAirport Accts Receivable Write °filth*
OAKLAND COUNTY INTERNATIONAL AIRPORT WRITE-OFFS MAY 2015 CUSTOMER # CUSTOMER NAME INVOICE# INVOICE DATE AMOUNT TOTAL A1R00002423 BDJ AIRCRAFT INC A1R0044085 2/15/2011 200.00 705.00 No response - mailed to different addresses, A1R0049129 10/15/2011 55.00 phone calls, and faxes AIR0049129 10/15/2011 450.00 A1R00002696 KHAN, ARSAD A1R0054137 6/1/2012 6.50 71.60 Dispute over cancellation date. AIR0054675 6/15/2012 65.00 Tenant claims he cancelled a month prior to our notification. Unable to collect AIR00002711 SOURCE HR TPS A1R0060696 4/15/2013- 260.00 962.00 Dispute over cancellation date. AIR0060696 8/22/2013 (156.00) Tenant advised cancellation, but didn't AIR0060791 5/1/2013 26.00 return keys to hangar. AIR0061282 5/15/2013 260.00 Unable to collect AIR0061382 6/1/2013 26.00 A1R0061881 6/15/2013 260.00 A1R0061984 7/1/2013 26.00 A1R0062489 7/15/2013 260.00 A1R00002752 AIRKRAFFT LLC AIR0042086 11/15/2010 15.00 15.00 No response - phone calls, faxed A1R00002779 LOCAIR INC A1R0045317 4/15/2011 15.00 15.00 Unable to contact - mail returned and phone disconnected AIR00002908 ALPINE AVIATION CORP AIR0049775 11/15/2011 145.00 160.00 Unable to collect - many calls, emails AIR0049775 11/15/2011 15.00 and faxes. Spoke to 2 different girls. AIR00002913 STARWOOD MANAGEMENT AIR0050430 12/15/2011 509.47 724.47 No response - many phone calls, AIR0050430 12/15/2011 145.00 emails, and faxes. Tried different AIR0050430 12/15/2011 55.00 addresses, and email addresses. AIR0051738 2/15/2012 15.00 A1R00002990 JET AVIATION AIR0054818 7/15/2012 15.00 15.00 No response - Mailed to several addresses, faxed also. AIR00003049 BETTERROADS ASPHALT AIR0057209 11/15/2012 15.00 15.00 Called - was sure he paid at FBO - Unable to collect AIR00003078 RDV AVIATION LLC AIR0058464 1/15/2013 35.00 35.00 No response - mailed to different locations J:\FiscalSvc\Budget\Forecast_New1201513rd QuarterlWrite-Offsirport Accts Receivable Write Off406
OAKLAND COUNTY INTERNATIONAL AIRPORT WRITE-OFFS MAY 2015 CUSTOMER # CUSTOMER NAME INVOICE# INVOICE DATE AMOUNT TOTAL AIR00003173 DEPENDABLE COMPONENT AIR0063288 9/15/2013 35.00 35.00 no contact info available - Unable to contact . AIR00003205 GLOBAL AIRCRAFT ACQUISITIONS AIR0064517 11/15/2013 15.00 15.00 Mailed & faxed - sold a/c - Unable to collect AIR00003209 CURRENT AVIATION GROUP AIR0065060 12/15/2013 15.00 15.00 No response - mailed & faxed different locations A1R00003217 PERSAUD, RAYMOND A1R0065068 12/15/2013 47.30 47.30 U. S. Customs charged an Overtime Fee. In turn, we billed him, but after researching he cleared during our regular hours. TOTAL 34,411.57 J:\FiscalSvc1Budget\Forecast_New1201513rd Quarter\Write-Offs‘Airport Accts Receivable Write 011406
OAKLAND COUNT( PARKS & RECREATION COMMISSION FY 2015 3rd Quarter Report for Contributions (Donations) - April 1, 2015 - June 30, 2015 Totals REC REC NatureCenter.program Citizen Science - Nest Watch Program Red Oaks Nature Center Red Oaks Nature Center Amount Tuning Your Tot Contribution$5.00 Tristan Thomas - Eagle Scout Project $194.03 Recreation Programs & Services Sub:Total --- . -: : Christine Thompson $50.00 General Contribution $2.00 Red Oaks Park-Sub-Total Budget Center Project Program $199.03 . . $52.00 Grand Total $251.03 107
Department of Health and Human Services Oakland County Children's Village Donation Tracking : Donation Period April 2015 to June 2015 Date: Donor: Cash/Check: Items: Estimated Value: 4/2/2015 Catholic Charities Easter Candy $30.00 4/3/2015 St. William 20 Easter Baskets @ 10$ per basket $200.00 4/6/2015 Prosecutor's Office Easter Cake (MP) $25.00 4/13/2015 Jeanne Fowler Items for Independent Living Program $200.00 4/13/2015 Thomas Gillotte Car Magazines (20 Magazines @ $.10) $2.00 4/16/2015 Dedra Jenkins Boy/Girl Clothing $10.00 4/16/2015 Delores Carble Boy/Girl Clothing $10.00 4/16/2015 Basketful of Yarn Yarn $30.00 4/17/2015 Tom Perkins/Talmer West Bank 5 Tigers Corporate Tickers @ $65 ea Youth Activity $325.00 4/17/2015 Ron Sypniewsky Car Magazines (600 Magazines @ $.10) $60.00 4/20/2015 Waterford Twp Library Yarn $30.00 4/21/2015 Datsun Doctor Car Magazines (40 Magazines @ $.10) $4.00 4/21/2015 Sweet Dreams for Kids 15 Pillowcases $15.00 4/28/2015 Joann Moss / Children's Hospital 2 Car Seats $140.00 4/28/2015 Temple Israel Clothing for Youth $15.00 5/6/2015 American Legion Unit 20 Chips and Candy $25.00 5/8/2015 Independence Twp Senior Ctr Yarn $30.00 5/19/2015 Stephen Huber (OC) 3 Boxes Event T-Shirts $300.00 5/19/2015 Sweet Dreams for Kids 15 Pillowcases $15.00 5/21/2015 Paul Walton (Prosecutors) Fitness Mat $199.72 5/21/2015 Paul Walton (Prosecutors) Fitness Ball and Upright Bike $243.95 5/21/2015 Paul Walton (Prosecutors) Elliptical Machine $577.00 5/21/2015 Charles McCall 150 Car Magazines @ $0.10 $15.00 5/22/2015 Datsun Doctor 40 Car/History Magazines @ $0.10 $4.00 5/22/2015 Madalyn Gareau Clothing Articles $17.00 5/27/2015 Dr. Jennifer Hichme 5 New Hoodies, Billard Tips and Chalk $255.00 5/27/2015 Lamon Mathison (OC) Clothing and Shoes (for MP) $150.00 6/2/2015 Roxanne DeGriselles Clothing $25.00 6/3/2015 Brewster Elementary School Toiletry Bags $100.00 108
Department of Health and Human Services Oakland County Children's Village Donation Tracking : Donation Period April 2015 to June 2015 Date: Donor: Cash/Check: Items: Estimated Value: 6/5/2015 Sheppy McConell Clothing $20.00 6/5/2015 Kamila Flynn Clothing $20.00 6/5/2015 Kristi Stesinski Clothing $20.00 6/5/2015 Jeanette Smith Clothing $20.00 6/5/2015 Amanda Stesinski Clothing $20.00 6/8/2015 Al Serra Grand Blanc Popcorn Machine $250.00 6/9/2015 David Bilson (0C) Art Supplies $100.00 6/10/2015 Costco/Alicia Susalla Vegetable/Herb Pod Kits $60.00 6/12/2015 Pam Dorris 5 Magazines & Craft Sticks $0.75 6/16/2015 Tyler Family School Supplies $5.00 6/17/2015 Anonymous Clothing $25.00 6/18/2015 Sweet Dreams for Kids 15 Pillow Cases $15.00 6/22/2015 Anonymous Bar soap & dental floss $3.00 6/25/2015 Datsun Doctor 30 Magazines @ $.10 ea $3.00 Total: $3,611.42 COMPILED BY: NICOLE KRLIMM FINALIZED 6/30/2015 109
Resolution #15239 September 17, 2015
Moved by Middleton supported by Gershenson the resolution be adopted.
AYES: Gingell, Gosselin, Hoffman, Jackson, KowaII, Long, Matis, McGillivray, Middleton,
Quarles, Scott, Spisz, Taub, Weipert, Woodward, Zack, Bowman, Crawford, Dwyer, Fleming,
Gershenson. (21)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolution was adopted.
71/ 7/ /3 ----
I HEREBY APP; 1S 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 17,
2015, 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 17th day of September 2015.
Lisa Brown, Oakland County