HomeMy WebLinkAboutResolutions - 2017.03.15 - 22799MISCELLANEOUS RESOLUTION #17043 March 15, 2017
BY: Commissioner Thomas Middleton, Chairperson, Finance Committee
IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2017 FIRST QUARTER
FINANCIAL FORECAST AND BUDGET AMENDMENTS
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of
Government, provides for adjustments to the adopted budget; and
WHEREAS in accordance with Oakland County General Appropriations Act Section 22, which authorizes
budget amendments for variances between the budgeted revenue and actual revenue, and Section 23,
which authorizes budget amendments for variance between estimated revenue and projected
expenditures, amendments are required; and
WHEREAS the Fiscal Year (FY) 2017 First Quarter Financial Forecast Report has identified several
variances and budget amendments are recommended; and
WHEREAS a budget amendment is recommended to reallocate funds from the Circuit Court's State
Institution Line Item and the Equipment Maintenance Line Item to the Circuit Court's IT operations Line
Item in the amount of $27,569 for FY2017 and $55,137 for FY2018 and FY2019 to account for the Circuit
Court Jury Management Replacement System and on-going costs; and
WHEREAS a budget amendment of $41,589 is recommended to remove Transfers-In within the Sheriff's
Department's Corrective Services Satellites division, approved per M.R. #13263 and no longer required;
and
WHEREAS the Sheriff's Office receipt of forfeiture/enhancement funds are recorded in separate restricted
funds that require a transfer to the General Fund for use of the monies. Transfers In from the various
restricted funds in the amount of $34,867 is being recognized for eligible forensic lab, dispatch costs and
correction officers training; and
WHEREAS a budget amendment is recommended to transfer funding in the amount of $111,250 from the
General Fund Assigned Fund Balance for Sheriff Aviation (GL Account #383488) to the Sheriff's Office
General Fund (#10100) to cover the final cost of repairs for the Air 1 helicopter (M.R. #16009); and
WHEREAS a budget amendment is recommended for the Treasurer's Office to correct the department ID
for Transfers Out carryforward, included in M.R. #16324 FY 2016 Year End Report; and
WHEREAS a budget amendment is recommended to recognize the costs associated with the 2016
Presidential Election recount of which the State reimbursed $79,000 and the remaining $45,700 will be
appropriated from the General Fund Assigned Fund Balance for Unfunded Mandates (GL Account
#383515); and
WHEREAS a budget amendment of $9,500 is recommended for the County Executive to reallocate the
Software Rental Lease Purchase budget to the proper division and program; and
WHEREAS a budget amendment totaling $23,631 is recommended for the Management and Budget
Equalization Division to reallocate funds from various line items to more accurately account for actual
activity; and
WHEREAS a budget amendment is recommended for the Health Division in the amount of $353 in order
to reallocate the budget for Interpreter Fee between the proper divisions; and
WHEREAS a budget amendment is recommended for Planning and Economic Development Services
received a $2,000 contribution from Oakland University and $500 contribution from Wenzel America in
support of Economic Development and Community Affairs' involvement with Manufacturing Day on
October 7, 2016; and
WHEREAS a budget amendment is recommended to transfer funds in the amount of $5,533 from the
Children's Village Donations Fund (#21330) to the Child Care Fund (#20293) which properly accounts for
expenditures eligible for Children's Village Donation funding; and
WHEREAS a budget amendment totaling $20,741 is recommended for the Friend of the Court (FOC)
Fund (#27100) reallocating $10,000 from the Office Supply line item and recognizing $10,741 from the
SMILE Donations account (#229340) to the Smile program line item to cover the cost of the new Friend of
FINANCE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote with Crawford absent,
the Court (FOC) Smile Video; and
WHEREAS a budget amendment is recommended to the project ID chartfield for the FY 2017 Community
Corrections Comprehensive Grant (#27370) to correct the grant numbers; and
WHEREAS a budget amendment is recommended for the Water Resources Commissioner to transfer
$43,191 from the Lower Pettibone Lake Sanitary Chapter 4 Construction fund to the Lower Pettibone
Drain Chapter 4 fund to pay for future maintenance expenses; and
WHEREAS a budget amendment is recommended for the Water Resources Commissioner to transfer a
total of $202,626 from various Water and Sewer funds to the Information Technology Fund (#63600) to
pay for the Interactive Voice Response (IVR) solution and Automatic Call Distribution (ADC) solution
project; 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 in the amount of $48,895 which is less than
fifteen percent of the original agreement required to accept each of the amendments via separate
resolution;
WHEREAS a budget amendment of $6,100 is recommended for the Economic Development Corporation
(EDC) Board as the board approved their FY 2017 Special Revenue Budget totaling $22,600; and
WHEREAS a budget amendment of $5,000 is recommended for Planning and Economic Development.
The funding was part of 2016 Collaborative Development Council Grant (CDC) grant award (M.R.
#16150) from Michigan Economic Development Corporations (MEDC) however, the funding was not used
during the grant period. The MEDC amended the 2017 CDC grant so that the $5,000 from the 2016 grant
could be used for the 2017 Manufacturing Day; the amendment is less than fifteen percent of the original
agreement required to accept each of the amendments via separate resolution; and
WHEREAS a Parks and Recreation Commission budget amendment in the amount of $298,400 is
recommended to recognize Personal Property Tax Loss Reimbursement from the State of Michigan and
reallocate specific line-items based on current activity levels; and
WHEREAS a budget amendment of $8,000,000 is recommended for the FY 2017 Fringe Benefit rate
adjustment that was made effective February 4, 2017 due to better than anticipated FY 2016 year end
operating results in the Fringe Benefit Fund. The rate adjustment is a one-time adjustment for FY 2017
and is not expected to continue for FY 2018 and FY 2019. The FY 2017 savings associated with the
General Fund/General Purpose funds will be used for one-time capital facility and technology projects;
and
WHEREAS a budget amendment of $1,000 is recommended in the Fringe Benefits Fund (#67800)
in order to reallocate the budget to the correct department ID in the Health division; and
WHEREAS a budget amendment of $3,500 is recommended in the Fringe Benefit Fund (#67800) to
reallocate expenses from Metered Postage to Other Expendable Equipment due to incorrect budget
allocation; and
WHEREAS an amendment of $749,345 is recommended for the Information Technology Fund (#63600)
to reallocate funds between the proper divisions and programs based on the FY 2017-2018 Master Plan
priorities established by the Leadership Groups; and
WHEREAS a budget amendment of $29,569 for FY 2017 and $59,137 for FY 2018-2019 is
recommended to the Information Technology Fund (#63600) for the billing and on-going maintenance
costs for the new Jury Management System; and
WHEREAS a budget amendment of $400 is recommended to the Motor Pool Fund (#66100) to correct
the transfer of funds for the purchase of a two (2) wheel drive Tahoe (M.R. #16181); and
WHEREAS the Oakland County Department of Economic Development and Community Affairs has
attempted to collect funds from loan recipients for the Home Investment Partnership Act Accounts totaling
$18,705 and recommends it to be written off as uncollectible loans; and
WHEREAS the Parks and Recreation Commission has requested write-offs totaling $37,454.90 of which
$168.75 are for uncollectible fees and $37,286.15 for uncollectible accounts receivable for utilities owed
by Katherine's Catering that was already approved with M.R. #16336; and
WHEREAS the Department of Human Resources has requested a write-off in the amount of $24.36 for
uncollectible 2016 healthcare contributions due to employee death; and
WHEREAS the Sheriff's Office received a donation of one (1) protective vest for the law enforcement K9
division, an estimated value of $1,050; and
WHEREAS the Parks and Recreation received donations totaling $2,138.03 for various programs; and
WHEREAS the Department of Health and Human Services Children's Village Division received donations
of various items with an estimated total value of $18,769.59.
NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2017
First Quarter Financial Report.
BE IT FURTHER RESOLVED that $111,250 be transferred in FY 2017 from the General Fund Assigned
Fund Balance for Sheriff Aviation (GL #383488) to the Sheriff's Office to cover the final cost of repairs for
the Air 1 helicopter.
GENERAL FUND (#10100)
Revenues
9010101-196030-665882
Expenditures
4030601-116220-730646
FY 2017
Planned Use of Balance
Total Revenues
Equipment Maintenance
Total Expenditures
$111,250.00
$111,250 00
$111,250.00
$111,260 00
BE IT FURTHER RESOLVED that $45,700 be transferred in FY 2017 from the General Fund Assigned
Fund Balance for Unfunded Mandates (GL #383515) to cover the costs associated with the 2016
Presidential Election recount and which represents costs over the $79,000 reimbursed by the State of
Michigan.
GENERAL FUND (#10100) FY 2017
Revenues
9010101-196030-665882 Planned Use of Balance $ 45,700.00
Total Revenues $ 45,700.00
Expenditures
4030301-112590-712020
2010301-18501 0-7 12020
2010301-185010-731617
9010101-148050-775754
Overtime
Overtime
Relocation
Maintenance Department Charges
Total Expenditures
$ 2,795.00
$ 3,822.00
$ 32,469.00
$ 6,614.00
$ 45,7000Q
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 Sheriff's Department, Department
of Health and Human Services Children's Village Division and Parks and Recreation Commission.
BE IT FURTHER RESOLVED that the FY 2017 — FY 2019 Budgets are amended pursuant to Schedules
A, B and C.
Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution.
(1---
irk-14
'ommissioner homas Middleton, Disffia#4
Chairperson, Finance Committee
COAKLANDV
COUNTY MICHIGAN
MANAGEMENT & BUDGET
OAKLAND COUNTY EXECUTIVE L. BROOKS PATTERSON
Laurie Van Pelt, Director
(248) 858-2163 I vanpeltl@oakgov.com
TO: Members of the Finance Committee
FROM: Laurie Van Pelt, Director, Management and Budget
Lynn Sonkiss, Manager, Fiscal Services
Gaia Piir, Chief, Fiscal Services
Ebru Adoglu-Jones, Supervisor of Fiscal Services
SUBJECT: Letter of Transmittal - Fiscal Year 2017 First Quarter Forecast
DATE: March 9, 2017
FY 2017 FIRST QUARTER REPORT
Attached please find the Fiscal Year (FY) 2017 First Quarter Forecast Repot In total, Fiscal Services
forecasts that the County will complete FY 2017 with an overall favorable variance of $11,526,533 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 ($361,936) less revenue than anticipated and projected
favorability in expenditures of $11,888,469.
REVENUES
GF/GP revenues are .08% less than budget or ($361,936). Major variances are the result of the
following events:
A. STATE GRANTS — Unfavorable: ($1,062,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 and Private Institutions - Residential and Foster Care.
B. CHARGES FOR SERVICES — Favorable: $621,625
Favorable primarily in Children's Village Board and Care $300,000 and Out County Board and
Care $200,000 due to an increase in reimbursement rate from the State; also favorable
Reimbursement General $100,000 and $20,000 Soil Erosion Fees in the Water Resources
Commissioners Office.
EXPENDITURES
In total, expenditures are projected to be 2.65% under budget or $11,888,469 favorable. Many
departments have experienced personnel savings as the result of turnover and under-filling of
positions. As the year progresses this overall net favorability may increase as departments continue to
work to reduce their costs and reorganize.
There is one department projected to be unfavorable at the end of the fiscal year (barring any
amendments); Water Resources Commissioner.
Water Resources Commissioner — Unfavorable: ($100,000)
2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 I Fax (248) 452-9172 I OakGov.com
• The department is forecasted to be unfavorable primarily due to Drain Equipment Labor
expenditures ($100,000) for employee labor that cannot be charged to other funds. The overall
unfavorability is offset by favorable revenues of $120,000 for Soil Erosion Fees and
Reimbursement General. 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 2017:
Revenues - over/ (under) budget
Expenditures — (over)/under budget
Total Officially Reported Favorability
$ (361,936)
11,888,469
$ 11,526,533
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 $35,665,779 in fund balance. Fund balance is budgeted, and if
available can be used as a funding source, however GAAP does not allow fund balance to be "recorded
as revenue". This is because Fund Balance is the residual of revenue and expenditures accumulated
over the years, revenue cannot be recognized as income more than once. Thus when Use of Fund
Balance is removed from the revenue calculation, the impact on the County's official financial
statements is:
Revenue Variance
Reduce — Planned use of Fund Balance
Revenue Variance
Expenditure Variance (Comparing Actual to Approved Plan)
GAAP Reported Effect on Fund Balance
$ (361,936)
(35,665,779)
$ (36,027,715)
11,888,469 mg. „gm
It is important to analyze the forecast using both the Budget perspective and the GAAP perspective to
accurately reflect the impact of fiscal activity generated from FY 2017 operations.
The Budget perspective recognizes the overall favorable operating budget variance and confirms the
County's continuing efforts to maintain long-term fiscal stability particularly through continuation of
2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 I Fax (248) 452-9172 I OakGov.com
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 $11.5 million when comparing budget to actuals.
The GAAP perspective provides information as to the effect on Fund Balance. This forecast projects
that the General Fund balance will decrease by $24.1 million by the end of Fiscal Year 2017. The use
of Fund Balance is consistent with information provided to the Finance Committee and the Board of
Commissioners, as well as what is reflected in the FY 2017-2019 Triennial Budget. The County
PLANNED to use fund balance, which has built up over the years through accelerated budget
reductions, to support operations in FY 2017. However, it should be noted while the amended budget
reflects the utilization of $35.6 million of Fund Balance, this forecast projects the use of Fund Balance
needed to support FY 2017 activities of $24.1 million, $11.5 million less than planned.
2100 Pontiac Lake Road I County Executive Building 41W 1 Waterford, MI 48328 I Fax (248) 452-9172 I OakGov.com
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2017 FY 2018 AMENDMENTS AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) DEPT PROGRAM ACCT FUND AFF. OP UNIT CIRCUIT COURT Expenditure 3010301 121130 730646 3010301 121100 774636 9010101 112700 788001 20293 ACCOUNT NAME Equipment Maintenance Info Tech Operations Transfers Out - Child Care Fund Total Expenditures $ (1,872.00) $ 29,441.00 (27,569.00) - $ (3,743.00) $ 58,880.00 (55,137.00) - $ (3,743.00) 58,880.00 (55,137.00) $ (27,569.00) $ (55,137,00) $ (55,137.00) $ (27,569.00) $ (65,137.00) $ (55,137.00) $ (27,569.00) $ (55,137.00) 5 (55,137.00) $ (27,569.00) $ (55,137.00) $ (55,137.00) $ (41,589.00) 41,589.00 CHILD CARE FUND (#202931 Circuit Court Revenue 9090101 112700 695500 10100 Transfers In - General Fund Total Revenues Expenditure 3010402 112570 731843 State Institutions Total Expenditures SHERIFFS OFFICE Revenues 4030401 121280 695500 63100 Transfers In 9010101 196030 665882 Planned Use of Balance Total Revenues 4030901 4030501 4030301 9010101 116240 116230 112580 196030 695500 695600 695500 665882 21340 Transfers In 21396 Transfers In 21397 Transfers In Planned Use of Balance Total Revenues $ 25,584.00 1,001.00 8,282.00 (34,867.00)
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2017 FY 2018 FY 2019 FY 2020 AMENDMENTS AMENDMENTS AMENDMENTS AMENDMENTS IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) DEPT PROGRAM ACCT FUND AFF. OP UNIT TREASURER E>Goenditures 7010101 186130 788001 40400 Transfers-Out 7010110 186130 788001 40400 Transfers-Out ACCOUNT NAME Total Expenditures $ (81,500.00) 81,500.00 CLERK REGISTER OF DEEDS - ELECTIONS DIVISION Revenues 2010301 185010 631827 Reimb. General 79,000.00 Total Revenues 79,000.00 Expenditures 2010301 185010 731617 Relocation 79,000.00 Total Expenditures 79,000.00 COUNTY EXECUTIVE Expenditures 1010501 181020 731773 1010205 181010 731773 MANAGEMENT AND BUDGET - EQUALIZATION DIVISION Expenditures 1020501 186000 730072 1020501 186030 730324 1020501 186020 731101 1020501 173040 731458 1020501 186020 732018 1020501 186020 731528 1020501 186020 731213 1020501 186020 731941 Software Rental Lease Purchase Software Rental Lease Purchase Total Expenditures $ (9,500.00) 9,500.00 Advertising Communications Library Continuations Professional Services Travel and Conference Publishing Legal Notices Membership Dues Training Total Expenditures $ (1,000.00) $ (400.00) (31.00) (10,000,00) (12,200.00) 1,431.00 10,000.00 12,200.00 - $ (1,000.00) $ (400.00) (31.00) (10,000.00) (12,200.00) 1,431.00 10,000.00 12,200.00 (1,000.00) (400.00) (31.00) (10,000.00) (12,200.00) 1,431.00 10,000.00 12,200.00
SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2017 FY 2018 AMENDMENTS AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND 0101001 DEPT PROGRAM ACCT FUND AFF. OP UNIT HEALTH AND HUMAN SERVICES - HEALTH DIVISION Expenditures 1060236 133390 730982 1060240 133390 730982 ACCOUNT NAME Interpreter Fees Interpreter Fees Total Expenditures $ (353.00) $ (353.00) $ (353.00) 353.00 353.00 353.00 $ - $ - $ ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS Revenues 1090205 172090 631827 Reimb General 2,500.00 Expenditures 1090205 172090 732165 Total Revenues Workshops and Meeting Total Expenditures 2,500.00 2,500.00 2,500.00 CHILD CARE FUND 020293} Revenues 1060501 112255 695500 21330 Transfer In - Children's Village Donations Fund Total Revenues 5,533.00 5,533.00 Expenditures 1060501 1060501 1060501 1060501 1060501 112255 112255 112255 112255 112255 750056 750119 750246 750399 750476 Culinary Supplies Dry Goods and Clothing Incentives Office Supplies Recreation Supplies Total Expenditures 165.00 2,145.00 670.00 449.00 2,084.00 5,533.00
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY/SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Sheriff LAW ENFORCEMENT ENHANCE LAB FEES (#21340) Revenue 4030901 116240 665882 21340 Account Name 25,584.00 25,584.00 Planned Use of Fund Balance Total Revenues Expenditures 4030101 112580 788001 10100 Sheriff - TRAINING (#21396) Revenue 4030501 116230 665882 21396 Transfer Out - to Sheriff Total Expenditures Planned Use of Fund Balance Total Revenues 25,584.00 25,584.00 1,001.00 1,001.00 1,001.00 1,001.00 Expenditures 4030301 112590 788001 10100 Transfer Out - to Sheriff Total Expenditures Sheriff -SHERIFF BOOKING FEE TRAINING (#213971 Revenue 4030301 112580 665882 Planned Use of Fund Balance 8,282.00 Total Revenues 8,282.00 Expenditures 4030301 112580 788001 10100 Transfer Out - to Sheriff 8,282.00 Total Expenditures 8,282.00
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY/SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS 1PROPRIETARY /SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name CHILDREN'S VILLAGE DONATIONS FUND (#21330) Revenues 9010101 112255 665882 Planned Use of Balance Total Revenues (5,533.00) (5,533,00) Expenditures 9010101 112255 788001 20293 Transfer Out - Child Care Fund Total Expenditures 5,533.00 5,533.00 FRIEND OF THE COURT (#27100) Revenue 3010404 126030 632408 Expenditure 3010404 126030 731759 3010404 126030 750399 Video Copying Total Revenues Smile Program Office Supplies Total Expenditures 10,741.00 10,741.00 20,741.00 (10,000.00) 10,741.00 COMMUNITY CORRECTIONS COMPREHENSIVE GRANT (#27370) GR0000000093 Activity: GLB Analysis: GLB Budet Reference: 2017 Revenue 1070401 113180 615571 4030301 112650 615571 Expenditures 1070401 1070401 1070401 1070401 1070401 1070401 113000 702010 113000 722740 113000 731213 113000 732018 113000 773630 113000 770631 State Operating Grants State Operating Grants Total Revenues Salaries Fringe Benefits Membership, Dues Travel, Conference IT Development Bldg, Space Rental $ (1,337,304.00) (493,034.00) $ (1,830,338.00) (47,534.00) (31,627.00) (500.00) (2,000.00) (10,000.00) (9,207.00)
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program ?kept Fund Aff Oper Unit Account Name 1070401 113000 731941 Training 1070401 113000 774636 IT Cost 1070401 113000 778675 Telecommunications 1070401 113000 731388 Public Education (Printing) 1070401 113000 731818 Board Expense (Special Event Program) 1070401 113020 702010 Salaries 1070401 113020 722740 Fringe Benefits 1070401 113035 702010 Salaries 1070401 113035 722740 Fringe Benefits 1070401 113035 730373 Contracted Services 1070401 123010 702010 Salaries 1070401 123010 722740 Fringe Benefits 1070401 113120 731458 Professional Services 1070401 113120 702010 Salaries 1070401 113120 722740 Fringe Benefits 1070401 113120 731773 Software Rental/Lease 1070401 113130 702010 Salaries 1070401 113130 722740 Fringe Benefits 1070401 113131 702010 Salaries 1070401 113131 722740 Fringe Benefits 1070401 113130 731458 Professional Services 1070401 113150 702010 Salaries 1070401 113150 722740 Fringe Benefits 1070401 113190 731458 Professional Services 4030301 113000 702010 Salaries 4030301 113000 722740 Fringe Benefits 4030301 112651 702010 Salaries (2,000.00) (6,952.00) (2,800.00) (500.00) (1,000.00) (84,859.00) (53,450.00) (21,387.00) (12,836.00) (15,000.00) (231,945.00) (129,649.00) (37,000.00) (27,688.00) (1,285.00) (2,400.00) (193,718.00) (121,838.00) (33,966.00) (21,308.00) (25,500.00) (132,618.00) (63,983.00) (12,754.00) (52,520.00) (29,676.00) (109,040.00)
Revenue 1070401 113180 615571 4030301 112650 615571 Expenditures 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 113000 113000 113000 113000 113000 113000 113000 113000 113000 113000 113000 113020 113020 113035 113035 113035 123010 123010 702010 722740 731213 732018 773630 770631 731941 774636 778675 731388 731818 702010 722740 702010 722740 730373 702010 722740 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 4030301 112651 722740 Fringe Benefits 4030301 113130 702010 Salaries 4030301 113130 722740 Fringe Benefits 4030301 112620 731885 Support Services Total Expenditures (62,775.00) (109,040.00) (62,775.00) (67,208.00) (1,830,338.00) COMMUNITY CORRECTIONS COMPREHENSIVE GRANT (#27370) GR0000000772 Activity: GLB Analysis: GLB Budet Reference: 2017 State Operating Grants State Operating Grants Total Revenues Salaries Fringe Benefits Membership, Dues Travel, Conference IT Development Bldg, Space Rental Training IT Cost Telecommunications Public Education (Printing) Board Expense (Special Event Frog) Salaries Fringe Benefits Salaries Fringe Benefits Contracted Services Salaries Fringe Benefits 1,337,304.00 493,034.00 1,830,338.00 47,534.00 31,627.00 500.00 2,000.00 10,000.00 9,207.00 2,000.00 6,952.00 2,800.00 500.00 1,000.00 84,859.00 53,451.00 21,387.00 12,836,00 15,000.00 231,945,00 129,649,00
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 1070401 123010 731458 Professional Services 1070401 113120 702010 Salaries 1070401 113120 722740 Fringe Benefits 1070401 113120 731773 Software Rental/Lease 1070401 113130 702010 Salaries 1070401 113130 722740 Fringe Benefits 1070401 113130 730373 Contracted Services 1070401 113131 702010 Salaries 1070401 113131 722740 Fringe Benefits 1070401 113130 731458 Professional Services 1070401 113150 702010 Salaries 1070401 113150 722740 Fringe Benefits 1070401 113190 731458 Professional Services 4030301 113000 702010 Salaries 4030301 113000 722740 Fringe Benefits 4030301 112651 702010 Salaries 4030301 112651 722740 Fringe Benefits 4030301 113130 702010 Salaries 4030301 113130 722740 Fringe Benefits 4030301 112620 731885 Support Services Total Expenditures (3,500.00) 27,688.00 1,285.00 2,400.00 193,718.00 121,838.00 3,500.00 33,966.00 21,308.00 62,500.00 132,618.00 63,983.00 12,753.00 52,520.00 29,676.00 109,040.00 62,775.00 109,040.00 62,775.00 67,208.00 1,830,338.00 LOWER PETTIBONE DRAIN CHAPTER 4 FUND (25370) Revenue 6010101 149030 695500 45370 Transfer In 43,191.00 Total Revenues 43,191.00 Expense Budget Equity Adjustment 43,191.00 6010101 149030 796500 Total Expenses 43,191.00 LOWER PETTIBONE LAKE SANITARY CHAPTER 4 CONSTRUCTION FUND (45370) Revenue Planned Use of Balance 43,191.00 6010101 149015 665882 Total Revenues 43,191.00
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Expense Transfer Out 43,191.00 6010101 149015 788001 25370 Total Expenses 43,191.00 WATER AND SEWER TRUST FUND (57010) Revenue 6010101 149030 665882 Expense 6010101 149030 788001 63600 PONTIAC WATER FUND (57234) Revenue 6010101 149662 665882 Planned Use of Balance Total Revenues Total Expenses Planned Use of Balance Total Revenues 94,517.00 94,517.00 94,517,00 94,517.00 65,519.00 65,519.00 Expense 6010101 149662 788001 63600 PONTIAC SEWER/WWTP FUND (57434) Revenue 6010101 149662 665882 Transfer Out Total Expenses Planned Use of Balance Total Revenues 65,519.00 65,519.00 42,590.00 42,590.00 Expense Transfer Out 42,590.00 6010101 149662 788001 63600 Total Expenses 42,590.00
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS PROPRIETARY/SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Over Unit INFORMATI N TECHNOLOGY FUND (63600) Revenue Transfer In 1080101 152000 695500 57010 Transfer In 1080101 152000 695500 57234 Transfer In 1080101 152000 695500 57434 Account Name Total Revenues 94,517.00 65,519.00 42,590.00 202,626.00 Expense 1080102 152010 731458 Professional Services Total Expenses 202,626.00 202,626.00 HEALTH Communities Planning (#28320) GR0000000562 Bud Ref: 2017 Activity: GLB Analysis: GLB Revenues 1060233 133390 615571 State Operating Grants 65,000.00 Total Revenues 65,000.00 Expenditures 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 '133390 133390 702010 722740 730072 730373 730555 730926 730982 731346 731388 731941 732018 750245 750294 Salaries Regular Fringe Benefits Advertising Contracted Services Education Programs Indirect Costs Interpreter Fees Personal Mileage Printing Training Travel and Conference Incentives Material and Supplies 26,220.00 1,515.00 2,400.00 5,487.00 2,500.00 3,123.00 550.00 399.00 2,600.00 1,500.00 100.00 3,125.00 5,431.00
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY/SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS IPROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 1060233 133390 750399 Office Supplies 1060233 133390 750448 Postage-Standard Mailing 1060233 133390 750567 Training-Educational Supplies 1060233 133390 774677 Insurance Fund Total Expenditures HEALTH - MCH Block (#28563) GR0000000207 Bud Ref: 2017 Activity: GLB Analysis: GLB Revenues 1060291 133190 610313 Federal Operating Grants 1060291 133230 610313 Federal Operating Grants Total Revenues 900.00 7,400.00 1,500.00 250.00 65,000.00 (164,807.00) 164,807.00 Expenditures 1060291 1060291 1060291 1060291 1060291 1060291 1060291 1060291 1060291 1060291 1060291 1060291 1060291 1060291 1060291 133190 133190 133190 133190 133190 133190 133190 133190 133190 133230 133230 133230 133230 133230 133230 702010 722740 730926 730982 731388 731346 750567 774636 778675 702010 722740 730926 730982 731388 731346 Salaries Regular Fringe Benefits Indirect Costs Interpreter Fees Printing Personal Mileage Training-Educational Supplies Info Tech Operations Telephone Communications Salaries Regular Fringe Benefits Indirect Costs Interpreter Fees Printing Personal Mileage (85,892.00) (49,575.00) (11,897.00) (2,500.00) (2,000.00) (4,050.00) (1,901.00) (5,600.00) (1,392.00) 85,892.00 49,575.00 11,896.00 2,500.00 2,000.00 4,051.00
Expenditures 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 115010 115010 115010 115010 115010 115010 115010 115010 730926 731346 731780 750077 750399 750448 770631 774636 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS Federal Operating Grants State Operating Grants Total Revenues Salaries Regular Fringe Benefits Training Total Expenditures Federal Operating Grants Total Revenues Indirect Costs Personal Mileage Software Support Maintenance Disaster Supplies Office Supplies Postage-Standard Mailing Bldg Space Cost Allocation Info Tech Operations 1,901.00 5,600.00 1,392.00 (1,000.00) (19,000.00) (20,000.00) (28,826.00) 4,629.00 4,197.00 (20,000.00) 2,131.00 2,131.00 13,228.00 1,428.00 565.00 (22,707.00) 500.00 131.00 1,035.00 3,855.00 PROPRIETARY/SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 1060291 133230 750567 Training-Educational Supplies 1060291 133230 774636 Info Tech Operations 1060291 133230 778675 Telephone Communications Total Expenditures HEALTH - Nurse Family Partnership (#28607) GR0000000279 Bud Ref: 2017 Activity: GLB Analysis: GLB Revenues 1060230 133215 610313 1060230 133215 615571 Expenditures 1060230 133215 702010 1060230 133215 722740 1060230 133215 731941 HEALTH - PHEP (#28610) GR0000000750 Bud Ref: 2017 Activity: GLB Analysis: GLB Revenues 1060290 - 115010 610313
Expenditures 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 115035 115035 115035 115035 115035 115035 115035 115035 115035 115035 115035 115035 115035 115035 722740 730646 730926 731388 731780 731941 732018 732165 750077 750948 770631 774636 774677 778675 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS HEALTH - PHEP (#28610) GR0000000750 Bud Ref: 2017 Activity: GLB Analysis: GLB Revenues 1060290 115035 610313 Federal Operating Grants Total Revenues Fringe Benefits Equipment Maintenance Indirect Costs Printing Software Support Maintenance Training Travel and Conference Workshops and Meetings Disaster Supplies Postage-Standard Mailing Bldg Space Cost Allocation Info Tech Operations Insurance Fund Telephone Communications Total Expenditures 3,222.00 291.00 583.00 2,131.00 1,764.00 1,764.00 1.00 2,000.00 (1,266.00) 3,000.00 5,000.00 1,597.00 3,916.00 450.00 (13,161.00) 50.00 (1,161.00) (291.00) (117.00) 1,746.00 1,764.00 PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 1060290 115010 774637 Info Tech Managed Print Svcs 1060290 115010 774677 Insurance Fund 1060290 115010 778675 Telephone Communications Total Expenditures
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS 1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name ECONOMIC DEVELOPMENT CORP FUND (#21180) Revenue 1090202 171110 630280 Closing Fee 1090202 171110 655385 Income from Investments Total Revenues (6,500.00) 400.00 (6,100.00) Expenditures 1090202 1090202 1090202 1090202 1090202 1090202 171110 171110 171110 171110 171110 171110 730072 730709 731213 731507 731818 732165 Advertising Fees - Per Diems Membership Dues Public Notices Special Event Program Workshops and Meeting Total Expenditures (200.00) 100.00 (2,000.00) (1,500.00) (2,000.00) (500.00) (6,100.00) MICHIGAN ECONOMIC DEVELOPMENT FUND (#29245) GR0000000782 Activity GLB, Analysis Type GLB, Bud Ref 2017 Revenue 1090205 171030 615571 5,000.00 5,000.00 State Operating Grants Total Revenues Expenditure 1090205 171030 732165 PARKS AND RECREATION FUND (#50800) Revenue 5060101 160000 620573 5060831 160210 630644 5060666 160666 665882 Workshops and Meeting Total Expenditure Local Comm Stabilization Share Entrance Fees Gen Admission Planned Use of Balance Total Revenues 5,000.00 5,000.00 271,123.00 100,000.00 (72,723.00) 298,400.00
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY/SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Expense 5060101 5060101 5060326 5060327 5060330 5060356 5060417 5060426 5060427 5060431 5060456 5060715 5060724 5060725 5060732 5060735 5060831 5060837 1020601 1020601 1020658 1020658 1020658 1020658 5060101 5060101 5060101 5060101 5060326 5060326 160000 160000 160010 160010 160010 160010 160044 160044 160044 160044 160044 160070 160070 160070 160070 160070 160210 160210 182040 182040 182050 182050 182080 182080 160000 160000 160001 160001 160010 160010 730926 731269 731269 731269 731269 731269 731269 731269 731269 731269 731269 731269 731269 731269 731269 731269 731269 731269 702010 722740 702010 722740 702010 722740 702010 722740 702010 722740 702010 722740 Indirect Cost Natural Gas Natural Gas Natural Gas Natural Gas Natural Gas Natural Gas Natural Gas Natural Gas Natural Gas Natural Gas Natural Gas Natural Gas Natural Gas Natural Gas Natural Gas Natural Gas Natural Gas Salaries Fringe Benefits Salaries Fringe Benefits Salaries Fringe Benefits Salaries Fringe Benefits Salaries Fringe Benefits Salaries Fringe Benefits 83,700.00 (2,000.00) (2,000.00) (8,000.00) (1,000.00) (4,000.00) (5,000.00) (3,000.00) (3,000.00) 1,000.00 (4,000.00) (5,000.00) 1,000.00 (8,000.00) (7,000.00) 12,000.00 (8,000.00) (31,000.00) 600.00 (2,200.00) 34,400.00 25,000.00 800.00 (3,300.00) (441,200.00) (80,900.00) 286,000.00 107,700.00 23,700.00 200.00
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060326 160015 702010 Salaries 5060326 160015 722740 Fringe Benefits 5060327 160010 702010 Salaries 5060327 160010 722740 Fringe Benefits 5060327 160015 702010 Salaries 5060327 160015 722740 Fringe Benefits 5060328 160010 702010 Salaries 5060328 160010 722740 Fringe Benefits 5060328 160015 702010 Salaries 5060328 160015 722740 Fringe Benefits 5060330 160010 702010 Salaries 5060330 160010 722740 Fringe Benefits 5060330 160015 702010 Salaries 5060330 160015 722740 Fringe Benefits 5060356 160010 702010 Salaries 5060356 160010 722740 Fringe Benefits 5060356 160015 702010 Salaries 5060356 160015 722740 Fringe Benefits 5060417 160044 702010 Salaries 5060417 160044 722740 Fringe Benefits 5060420 160044 702010 Salaries 5060420 160044 722740 Fringe Benefits 5060427 160044 702010 Salaries 5060427 160044 722740 Fringe Benefits 5060430 160044 702010 Salaries 5060430 160044 722740 Fringe Benefits 6060431 160044 702010 Salaries 5060431 160044 722740 Fringe Benefits 5060437 160044 702010 Salaries 5060437 160044 722740 Fringe Benefits 5060540 160500 702010 Salaries 5060540 160500 722740 Fringe Benefits (10,000.00) (13,200.00) 10,100.00 (13,400.00) 52,600.00 1,700.00 (9,200.00) (46,500.00) 31,300.00 2,600.00 48,200.00 42,200.00 19,200.00 (8,100.00) 81,900.00 25,900.00 (36,500.00) (32,800.00) (8,700.00) (12,200.00) (17,600.00) (1,000.00) (24,000.00) (7,900.00) 100.00 700.00 (14,400.00) 9,200.00 (25,000.00) (1,200.00) 19,200.00 (9,400.00)
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dent ID Program Acct Fund Aff Over Unit Account Name 5060715 160070 702010 Salaries 5060715 160070 722740 Fringe Benefits 5060720 160070 702010 Salaries 5060720 160070 722740 Fringe Benefits 5060724 160070 702010 Salaries 5060724 160070 722740 Fringe Benefits 5060725 160070 702010 Salaries 5060725 160070 722740 Fringe Benefits 5060729 160070 702010 Salaries 5060729 160070 722740 Fringe Benefits 5060732 160070 702010 Salaries 5060732 160070 722740 Fringe Benefits 5060735 160070 702010 Salaries 5060735 160070 722740 Fringe Benefits 5060751 160070 702010 Salaries 5060751 160070 722740 Fringe Benefits 5060755 160070 702010 Salaries 5060755 160070 722740 Fringe Benefits 5060760 160070 702010 Salaries 5060760 160070 722740 Fringe Benefits 5060765 160070 702010 Salaries 5060765 160070 722740 Fringe Benefits 5060805 160210 702010 Salaries 5060805 160210 722740 Fringe Benefits 5060831 160210 702010 Salaries 5060831 160210 722740 Fringe Benefits 5060837 160210 702010 Salaries 5060837 160210 722740 Fringe Benefits 5060845 160210 702010 Salaries 5060845 160210 722740 Fringe Benefits 5060870 160210 702010 Salaries 5060870 160210 722740 Fringe Benefits 75,500.00 28,800.00 26,700.00 15,400.00 (24,700.00) (10,300.00) 26,400.00 40,800.00 (4,500.00) 5,700.00 (14,200.00) (27,100.00) 58,100.00 18,900.00 (3,200.00) 2,700.00 21,300.00 4,800.00 (3,900.00) (4,100.00) (4,400.00) (3,800.00) 45,500.00 (40,900.00) 46,400.00 24,000.00 (20,700.00) (25,800.00) (800.00) (3,400.00) 8,700.00 800.00
ACCOUNT NUMBER PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060837 160210 732018 Travel and Conference 5060101 160000 761042 Depreciation Park Improvements 5060326 160010 761042 Depreciation Park Improvements Depreciation Park Improvements Depreciation Park Improvements Depreciation Park Improvements Depredation Park Improvements Depreciation Park Improvements Depreciation Park Improvements Depreciation Park Improvements Depreciation Park Improvements Depreciation Park Improvements Depreciation Park Improvements Depreciation Park Improvements Depreciation Park Improvements Depreciation Park Improvements Depreciation Park Improvements Depreciation Park Improvements Depreciation Vehicles Equipment Rental Equipment Maintenance Grounds Maintenance Licenses and Permits General Program Administration Total Expenses Employee In-Service Training Employee In-Service Training Total Expenses FRINGE BENEFITS (#67800) Expenditures 1060231 183190 730576 1060230 183190 730576 5060327 5060330 5060417 5060426 5060427 5060456 5060715 5060720 5060725 5060735 5060751 5060755 5060760 5060831 5060870 5060910 5060805 5060805 5060831 5060724 5060910 160010 160010 160044 160044 160044 160044 160070 160070 160070 160070 160070 160070 160070 160210 160210 160430 160210 160210 160210 160070 160430 761042 761042 761042 761042 761042 761042 761042 761042 761042 761042 761042 761042 761042 761042 761042 761156 730653 730646 730814 731115 730789 SCHEDULE B FY 2018 FY 2019 AMENDMENTS AMENDMENTS 5,400.00 900.00 (2,600.00) (7,400.00) (800.00) 1,900.00 1,200.00 1,300.00 1,100.00 4,400.00 67,900.00 (4,100.00) (85,100.00) 1,000.00 (400.00) 2,700.00 31,700.00 900.00 8,400.00 20,366.00 (20,366.00) 11,379.00 400.00 (11,779.00) 298,400.00 (1,000.00) 1,000.00 OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS
SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2017 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2017 AMENDMENTS FY 2018 FY 2019 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID program Acct Fund Aff Oper Unit Account Name Expenses 9011503 183180 750170 9011503 183180 750392 INFORMATION TECHNOLOGY FUND (#63600) Expenses 1080101 152000 731458 1080201 152010 731458 1080601 152100 731458 Other Expendable Equipment Metered Postage Total Expenses 3,500.00 (3,500.00) Professional Services Professional Services Professional Services Total Expenses OC Depts Operations Outside Agencies Total Revenues (31,903.00) $ (717,442.00) 749,345.00 (31,903.00) (717,442.00) 749,345.00 Revenues 1080101 152000 631372 1080101 152000 635017 27,569.00 $ 2,000.00 29,569.00 $ 55,137.00 $ 4,000.00 59,137.00 $ 55,137.00 4,000.00 59,137.00 Expenses 1080601 152010 731780 Software Support/Maintenance Total Expenses 29,569.00 $ 29,569.00 $ 59,137.00 $ 59,137.00 $ 59,137.00 59,137.00 MOTOR POOL FUND (#661001 Revenues 1030811 184010 695500 10100 Expenses 1030811 184010 796500 Transfer In-Gen. Fund 400.00 Total Revenuess 400.00 Budgeted Equity Adjustment 400.00 Total Expenses 400.00
OAKLAND COUNTY, MICHIGAN SCHEDULE C FRINGE BENEFIT FUND RETIRMENT AMENDMENTS FISCAL YEAR 2017 FIRST QUARTER AMENDMENTS Unit Ledger Fund Dept Program Account Project OU Fund Aff BudRef Proj Unit Activity Analysis Adjustment Amount General Fund General Purpose Funds - All Departments USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY BUDGET 10100 1010101 181000 BUDGET 10100 1010105 181000 BUDGET 10100 1010201 181010 BUDGET 10100 1010205 181010 BUDGET 10100 1010210 182090 BUDGET 10100 1010501 181020 BUDGET 10100 1020101 182010 BUDGET 10100 1020501 173010 BUDGET 10100 1020501 173020 BUDGET 10100 1020501 173030 BUDGET 10100 1020501 173040 BUDGET 10100 1020501 173050 BUDGET 10100 1020501 173060 BUDGET 10100 1020501 186000 BUDGET 10100 1020501 186010 BUDGET 10100 1020501 186020 BUDGET 10100 1020501 186030 BUDGET 10100 1020601 182020 BUDGET 10100 1020601 182040 BUDGET 10100 1020601 182050 BUDGET 10100 1020601 182080 BUDGET 10100 1020650 126000 BUDGET 10100 1020650 126010 BUDGET 10100 1020650 126020 BUDGET 10100 1030101 184000 BUDGET 10100 1030801 184030 BUDGET 10100 1030803 184020 BUDGET 10100 1030803 184025 BUDGET 10100 1040101 140000 BUDGET 10100 1040801 148020 BUDGET 10100 1050101 183010 BUDGET 10100 1050103 183130 BUDGET 10100 1050401 183010 BUDGET 10100 1050403 183020 BUDGET 10100 1050409 183070 BUDGET 10100 1050415 183100 BUDGET 10100 1050501 183010 BUDGET 10100 1060101 133000 BUDGET 10100 1060201 133020 BUDGET 10100 1060201 133150 BUDGET 10100 1060201 133170 BUDGET 10100 1060211 133020 BUDGET 10100 1060211 133150 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 (37,291.00) (17,033.00) (6,119.00) (5,659,00) (26,022.00) (52,865.00) (5,821.00) (27,910.00) (70,342.00) (24,984.00) (8,914.00) (8,021.00) (2,733.00) (10,210.00) (13,265.00) (14,732.00) (3,245.00) (12,987.00) (19,966.00) (28,843.00) (60,694.00) (21,087.00) (21,109.00) (5,834.00) (5,821.00) (4,470.00) (12,361.00) (7,650.00) (4,796.00) (17,034.00) (9,001.00) (6,226.00) (3,005.00) (19,200.00) (10,920.00) (9,083.00) (4,205.00) (3,800.00) (20,726.00) (23,677.00) (9,386.00) (4,331.00) (28,089.00)
OAKLAND COUNTY, MICHIGAN SCHEDULE C FRINGE BENEFIT FUND RETIRMENT AMENDMENTS FISCAL YEAR 2017 FIRST QUARTER AMENDMENTS Unit Ledger Fund Dept Program Account Project OU Fund Aff BudRef Proj Unit Activity Analysis Adjustment Amount USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 BUDGET 10100 1060211 1060211 1060211 1060212 1060213 1060214 1060220 1060220 1060230 1060230 1060230 1060232 1060233 1060233 1060233 1060234 1060237 1060237 1060237 1060240 1060283 1060601 1060601 1060601 1070101 1070301 1070301 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070401 1070501 1070501 1070501 1070501 1070601 1070801 1070801 133390 133990 134390 133120 133130 133150 134190 134390 133150 133390 133990 134850 133350 133370 133390 133990 133300 133310 133390 133390 133120 115090 115120 115180 132020 132050 132080 113000 113010 113020 113050 113060 113080 113130 113140 123000 123010 131030 132120 174000 174170 132030 114000 114010 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 100000001994 722770 100000001941 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 (3,153.00) (21,420.00) (9,025.00) (10,402.00) (3,704.00) (3,377.00) (4,389.00) (160,956.00) (3,358.00) (3,185.00) (2,546.00) (3,885.00) (23,880.00) (9,858.00) (6,426.00) (63,148.00) (2,229.00) (3,941.00) (2,541.00) (115,577.00) (2,321.00) (14,636.00) (3,989.00) (80.00) (5,821.00) (35,207.00) (1,502.00) (12,480.00) (5,439.00) (7,328.00) (3,846.00) (10,181.00) (5,041.00) (6,218.00) (2,826.00) (4,094.00) (21,139.00) (6,274.00) (3,199.00) (3,883.00) (2,560.00) (73,277.00) (9,452.00) (46.00) 2017 GRANT GLB GLB 2017 GRANT GLB GLB
OAKLAND COUNTY, MICHIGAN SCHEDULE C FRINGE BENEFIT FUND RETIRMENT AMENDMENTS FISCAL YEAR 2017 FIRST QUARTER AMENDMENTS Unit Ledger Fund Dept Program Account Project OU Fund Aff BudRef Proj Unit Activity Analysis Adjustment Amount USCTY BUDGET 10100 1070805 114090 USCTY BUDGET 10100 1070810 114100 USCTY BUDGET 10100 1090101 171000 USCTY BUDGET 10100 1090101 171030 USC1Y BUDGET 10100 1090108 171030 USCTY BUDGET 10100 1090201 171000 USCTY BUDGET 10100 1090201 171080 USCTY BUDGET 10100 1090202 171100 USCTY BUDGET 10100 1090204 172020 USCTY BUDGET 10100 1090204 172040 USCTY BUDGET 10100 1090204 173100 USCTY BUDGET 10100 1090204 174220 USCTY BUDGET 10100 1090205 171010 USCTY BUDGET 10100 1090206 171090 USCTY BUDGET 10100 1090207 174230 USCTY BUDGET 10100 2010101 180000 USCIY BUDGET 10100 2010201 125000 USCTY BUDGET 10100 2010205 132305 USCTY BUDGET 10100 2010210 125000 USCTY BUDGET 10100 2010301 185010 USCTY BUDGET 10100 2010401 172190 USCTY BUDGET 10100 2010501 121285 USCTY BUDGET 10100 2010601 172190 USCTY BUDGET 10100 3010101 121100 USCTY BUDGET 10100 3010101 121120 USCTY BUDGET 10100 3010101 121130 USCTY BUDGET 10100 3010101 121210 USCTY BUDGET 10100 3010101 121220 USCTY BUDGET 10100 3010201 121100 USCTY BUDGET 10100 3010301 121100 USCTY BUDGET 10100 3010301 121130 USCTY BUDGET 10100 3010301 121140 USCTY BUDGET 10100 3010301 121150 USCTY BUDGET 10100 3010301 121160 USCTY BUDGET 10100 3010301 121170 USCTY BUDGET 10100 3010301 121180 USCTY BUDGET 10100 3010301 121190 USCTY BUDGET 10100 3010402 111000 USCTY BUDGET 10100 3010402 121100 USCTY BUDGET 10100 3010402 135060 USCTY BUDGET 10100 3010402 135070 USCTY BUDGET 10100 3010403 121100 USCTY BUDGET 10100 3010403 121230 USCTY BUDGET 10100 3010403 121240 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 (11,741.00) (21,137.00) (9,440.00) (46.00) (19,965.00) (1,414.00) (2,819.00) (2,148.00) (2,719.00) (13,600.00) (5,022.00) (6,767.00) (32,125.00) (13,549.00) (7,275.00) (18,174.00) (6,361.00) (14,309.00) (52,216.00) (17,714.00) (43,148.00) (49.00) (5,497.00) (15,865.00) (20,664.00) (131,417.00) (5,776.00) (27,685.00) (36,151.00) (6,743.00) (4,712.00) (11,070.00) (3,166.00) (1,282.00) (1,762.00) (6,795.00) (2,999.00) (64,801.00) (3,005.00) (54,189.00) (1,942.00) (7,108.00) (30,531.00) (38,448.00)
OAKLAND COUNTY, MICHIGAN SCHEDULE C FRINGE BENEFIT FUND RETIRMENT AMENDMENTS FISCAL YEAR 2017 FIRST QUARTER AMENDMENTS Unit Ledger Fund Dept Program Account Project CU Fund Aft BudRef Proj Unit Activity Analysis Adjustment Amount 2017 GRANT GLB GLB SHERF GLB GLB USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY usc-n, usc-ry USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET 10100 3010403 10100 3020101 10100 3020201 10100 3020205 10100 3020301 10100 3020305 10100 3020401 10100 3020405 10100 3020501 10100 3020505 10100 3040101 10100 3040101 10100 3040403 10100 3040403 10100 4010101 10100 4010101 10100 4010101 10100 4010101 10100 4010201 10100 4010201 10100 4010201 10100 4010201 10100 4010201 10100 4010301 10100 4010301 10100 4010401 10100 4030101 10100 4030201 10100 4030201 10100 4030201 10100 4030301 10100 4030301 10100 4030301 10100 4030301 10100 4030401 10100 4030401 10100 4030401 10100 4030401 10100 4030401 10100 4030401 10100 4030501 10100 4030501 10100 4030505 10100 4030601 135080 121030 121020 113290 121020 113290 121020 113290 121020 113290 121080 121090 121080 124015 122000 125010 135170 135170 122030 122040 122050 122060 122080 122050 122060 122050 112580 112580 112680 113380 112590 112620 112620 112650 112590 112670 113381 116245 116245 121280 116230 116230 110110 110000 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 100000002090 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 RESULTS_PROG 722770 722770 722770 40050 722770 722770 722770 (8,910.00) (3,164.00) (57,393.00) (31,133.00) (33,098.00) (8,875.00) (53,217.00) (26,187.00) (34,721.00) (10,555.00) (3,749.00) (48,407.00) (7,850.00) (38,749.00) (31,189.00) (8,052.00) (7,262.00) (3,069.00) (22,090.00) (20,713.00) (153,079.00) (44,670.00) (1,772.00) (48,259.00) (2,725.00) (44,250.00) (40,610.00) (19,923.00) (16,704.00) (3,540.00) (9,623.00) (456.00) (518,681.00) (107,666.00) (8,008.00) (92,511.00) (78,752.00) (5,399.00) (173.00) (47,930.00) (4,956.00) (11,166.00) (22,379.00) (8,087.00)
OAKLAND COUNTY, MICHIGAN SCHEDULE C FRINGE BENEFIT FUND RETIRMENT AMENDMENTS FISCAL YEAR 2017 FIRST QUARTER AMENDMENTS Unit Ledger Fund Dept Program Account Project OU Fund AU BudRef Proj Unitl Activity Analysis Adjustment Amount USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USGTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030601 10100 4030701 10100 4030901 10100 4030901 10100 4030901 10100 4030901 10100 4030901 10100 4030901 10100 4030901 10100 4030901 10100 4030901 10100 5010101 10100 5010101 10100 5010302 10100 5010303 10100 6010101 10100 7010101 10100 7010101 10100 7010101 10100 7010101 10100 7010101 110010 110020 110030 112670 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 116181 116181 116190 116200 116200 116210 116230 110040 110050 110060 110090 110100 116240 116250 116260 116270 180010 180020 165020 165040 155012 186040 186050 186070 186080 186090 722770 722770 722770 722770 722770 ADDISON 40010 722770 BRANDON 40030 722770 COMMERCE 40040 722770 HIGHLAND 40060 722770 INDEPENDENC 40080 722770 LYON 40090 722770 OAKLAND 40120 722770 ORION 40130 722770 OXFORD 40140 722770 PONTIAC 40420 722770 ROCH_HILLS 40440 722770 SPRINGFIELD 40180 722770 40090 722770 40140 722770 PARKS 722770 722770 722770 MARINE 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 (5,391.00) (16,244.00) (24,436.00) (11,378.00) (16,196.00) (31,123.00) (84,927.00) (46,206.00) (82,991.00) (48,784.00) (43,385.00) (73,127.00) (38,814.00) (208,649.00) (150,697.00) (26,389.00) (1,874.00) (1,874.00) (13,109.00) (683.00) (2,839.00) (3,931.00) (78.00) (6,953.00) (145,533.00) (14,074.00) (25,540.00) (25,450.00) (27,562.00) (7,958.00) (43,670.00) (24,520.00) (10,267.00) (2,101.00) (20,817.00) (28,810.00) (7,029.00) (4,552.00) (5,190.00) (19,671.00) (10,306.00) (9,649.00) (12,403.00) (3,540.00) SHE RE GLB GLB SHERF GLB GLB SHERF GLB GLB SHERF GLB GLB SHERF GLB GLB SHERF GLB GLB SHERF GLB GLB SHERF GLB GLB SHERF GLB GLB SHERF GLB GLB SHERF GLB GLB SHERF GLB GLB SHERF GLB GLB SHERF GLB GLB
OAKLAND COUNTY, MICHIGAN SCHEDULE C FRINGE BENEFIT FUND RET1RMENT AMENDMENTS FISCAL YEAR 2017 FIRST QUARTER AMENDMENTS Unit Ledger Fund Dept Program Account Project OU Fund Aff BudRef Proj Unit" Activity Analysis Adjustment Amount USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY U SCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET 10100 7010101 186100 722770 10100 7010110 186130 722770 20293 1060501 112010 722770 20293 1060501 112020 722770 20293 1060501 112030 722770 20293 1060501 112050 722770 20293 1060501 112060 722770 20293 1060501 112070 722770 20293 1060501 112100 722770 20293 1060501 112150 722770 20293 1060501 112170 722770 20293 1060501 112190 722770 20293 1060501 112210 722770 20293 1060501 112450 722770 20293 1060501 112470 722770 20293 1060501 112480 722770 20293 1060501 112500 722770 20293 1060501 112520 722770 20293 1060501 112540 722770 20293 1060501 112560 722770 20293 1060501 131000 722770 20293 1060501 131010 722770 20293 3010402 113310 722770 20293 3010402 121200 722770 20293 3010402 135120 722770 20293 9090101 112700 695500 20293 9010101 112700 615359 10100 9010101 196030 788001 10100 9010101 196030 666882 (4,763.00) (10,833.00) (36,712.00) (20,649.00) (16,992.00) (52,571.00) (692.00) (17,774.00) (18,058.00) (32,060.00) (23,272.00) (6,121.00) (80.00) (14,352.00) (11,293.00) (14,629.00) (11,382.00) (12,472.00) (13,810.00) (1,776.00) (6,875.00) (35,323.00) (15,677.00) (6,043.00) (6,201.00) 187,407.00 187,407.00 (.187,407.00). 5,532,077.00 10100 20293
OAKLAND COUNTY, MICHIGAN SCHEDULE C FRINGE BENEFIT FUND RETIRMENT AMENDMENTS FISCAL YEAR 2017 FIRST QUARTER AMENDMENTS Unit Ledger Fund Dept Program Account Project OU Fund Aft] Bud Ref Proj Unit Activity Analysis Adjustment Amount USCTY USCTY usc-n, usc-n, usury usc-n, USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USC1Y USCTY USCri' USCTY USC1Y USCTY USCTY USCrif USCTY USC1Y USCTY USCTY USCTY uscri, USCTY USCTY USCTY USCTY BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 BUDGET 50800 1020601 1020658 1020658 5060101 5060101 5060101 5060101 5060326 5060326 5060326 5060326 5060327 5060327 5060327 5060328 5060328 5060328 5060330 5060330 5060330 5060330 5060356 5060356 5060356 5060417 5060417 5060420 5060420 5060427 5060427 5060430 5060431 5060437 5060456 182040 182050 182080 160000 160000 160001 160001 160010 160010 160015 160015 160010 160010 160015 160010 160010 160015 160010 160010 160015 160015 160010 160010 160015 160044 160044 160044 160044 160044 160044 160044 160044 160044 160044 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 (3.139.00) .3439.09:, (11,055.00) 171,055,00 (13,335.00) 13_5 00 (3,064.00) (4,748.00) (1,940.00) (53,005.00) (2,009.00) (5,923.00) (357.00) (3,675.00) (167.00) (723.00) (163.00) (4,554.00) (252.00) (222.00) (1,310.00) (150.00) (188.00) (2,245.00) (462.00) (1,524.00) (140.00) (5,341.00) (289.00) (226.00) (418.00) (78.00) (14.00) (5.00) (399.00) (9.00) (234.00) (755.00) (1.00) (1,189.00) Concealed Pistol Licensing Fund #20300 USCTY BUDGET 20300 2010205 132315 722770 USCTY BUDGET 20300 2616205 132315 796500 Register of Deeds Automation Fund #21160 USCTY BUDGET 21160 2010401 172220 722770 .LitOW ii(1.000f :21.1W1010401,472220 666882 BFC Personnel Fund #21184 USCTY BUDGET 21184 1090202 171100 722770 USCTX::::::::flUDPET 0184109020.Z 171106: 665862 Parks and Recreation Fund #50800
OAKLAND COUNTY, MICHIGAN SCHEDULE C FRINGE BENEFIT FUND RETIRMENT AMENDMENTS FISCAL YEAR 2017 FIRST QUARTER AMENDMENTS Unit Ledger Fund Dept Program Account Project USCTY BUDGET 50800 5060456 160044 722740 USCTY BUDGET 50800 5060540 160500 722740 USCTY BUDGET 50800 5060540 160500 722740 USCTY BUDGET 50800 5060715 160070 722740 USCTY BUDGET 50800 5060715 160070 722740 USCTY BUDGET 50800 5060720 160070 722740 USCTY BUDGET 50800 5060720 160070 722740 USCTY BUDGET 50800 5060724 160070 722740 USCTY BUDGET 50800 5060724 160070 722740 USCTY BUDGET 50800 5060725 160070 722740 USCTY BUDGET 50800 5060725 160070 722740 USCTY BUDGET 50800 5060729 160070 722740 USCTY BUDGET 50800 5060729 160070 722740 USCTY BUDGET 50800 5060732 160070 722740 USCTY BUDGET 50800 5060732 160070 722740 USCTY BUDGET 50800 5060735 160070 722740 USCTY BUDGET 50800 5060735 160070 722740 USCTY BUDGET 50800 5060751 160070 722740 USCTY BUDGET 50800 5060751 160070 722740 USCTY BUDGET 50800 5060755 160070 722740 USCTY BUDGET 50800 5060755 160070 722740 USCTY BUDGET 50800 5060760 160070 722740 USCTY BUDGET 50800 5060760 160070 722740 USCTY BUDGET 50800 5060765 160070 722740 USCTY BUDGET 50800 5060765 160070 722740 USCTY BUDGET 50800 5060805 160210 722740 USCTY BUDGET 50800 5060805 160210 722740 USCTY BUDGET 50800 5060831 160210 722740 USCTY BUDGET 50800 5060831 160210 722740 USCTY BUDGET 50800 5060837 160210 722740 USCTY BUDGET 50800 5060845 160210 722740 USCTY BUDGET 50800 5060845 160210 722740 USCTY BUDGET 50800 5060870 160210 722740 USCTY BUDGET 50800 5060870 160210 722740 USCTY BUDGET 50800 5060910 160430 722740 USCTY BUDGET 50800 5060910 160430 722740 ps0Ty, BUDGET 50800 :MOW ,440066::: Delinquent Tax Revolving Fund #51600 USCTY BUDGET 51600_ _ 701.0110..1.86050 722770 :1'‘7JSCTY BUDGET 51600 T010IIG 1860501 665802 Delinquent Personal Prop Tax Admin Fund #51800 USCTY BUDGET 51800 7010110 186060 722770 USCTY BUDGET 51800 7010410 186060 000.0,.; Fire Records Management Fund #53100 OU Fund Aff BudRef Proj Unit Activity Analysis Adjustment Amount (10.00) (2,013.00) (140.00) (6,985.00) (708.00) (3,416.00) (176.00) (1.00) (77.00) (5,406.00) (740.00) (401.00) (74.00) (1,135.00) (267,00) (4,040.00) (347.00) (570.00) (152.00) (2,440.00) (203.00) (52.00) (21.00) (36.00) (37.00) (12,087.00) (790,00) (4,760.00) (145.00) (61.00) (335.00) (16.00) (320.00) (47.00) (19,261.00) (901.00) ;163,949:00 (4,487.00) 4,487.00 (6,314.00) 6,314 00
OAKLAND COUNTY, MICHIGAN SCHEDULE C FRINGE BENEFIT FUND RETIRMENT AMENDMENTS FISCAL YEAR 2017 FIRST QUARTER AMENDMENTS Unit Ledger Fund Dept Program Account Project OU Fund Aff BudRef Proj Unit Activity Analysis Adjustment Amount USCTY BUDGET 53100 1080325 115100 722770 USCTY.:,13LibOtt ,53100j::1000325 115100 665882 CLEWS Fund #53500 USCTY BUDGET 53500 1080301 116020 722770 USCTY. BUDGET 53500 1080301 116155 .722770 53500 :116020 ilis000g: Radio Communications Fund #53600 USCTY BUDGET 53600 1080310 115150 722770 USCTY auppu:5.3600:::::1000.310):114150::. County Airports Fund #56500 USCTY BUDGET 56500 1030701 154000 722770 USCTY BUDGET 56500 1030701 154010 722770 USCTY BUDGET 56500 1030745 154010 722770 USCTY BUDGET 56500 1030750 154010 722770 *Or BUDGET 56500:: 10300t:154016 665802! Water & Sewer Fund #57010 USCIY BUDGET 57010 1020601 182080 722770 USCTY 000gt57010 6010101 149030 665882 Facilities Maintenance & Operations Fund #63100 (9,465.00) .9,465.00 (54,073.00) (5,373.00) 59;446:00 (17.756.00) 17,766.6-0 (12,168.00) (28,223.00) (165.00) (165.00) 40,721 00 (3,745:00)._ USCIY BUDGET 63100 1040701 USCTY BUDGET 63100 1040718 USCTY BUDGET 63100 1040718 USCTY BUDGET 63100 1040718 USCTY BUDGET 63100 1040718 USCTY BUDGET 63100 1040718 USCTY BUDGET 63100 1040718 USCTY BUDGET 63100 1040718 USCTY BUDGET 63100 1040719 USCTY BUDGET 63100 1040725 USCTY BUDGET 63100 1040740 USCTY BUDGET 63100 1040770 USCTY BUDGET 63100 1040801 :USGTY BUDGET::,631(Kr:104070V: Information Technology Fund #63600 140101 140299 140299 140299 140299 140299 140299 140299 140399 140599 148499 145100 140030 140010:::. 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 665882 25900 20038 20037 20047 20033 25900 20010 20025 25900 25900 25900 25900 25900 _ FAC MNT OPF \dmin Annex I E -nation Technolc land CMH Cent lforcement Con FAC MNT OPF Administration Courthouse Cc FAG MNT OPF FAG MNT OPF FAG MNT OPF FAG MNT OPF FAC MNT OPF (15,530.00) (945.00) (2,766.00) (2,966.00) (8,164.00) (8,201.00) (10,472.00) (41,466.00) (104,841.00) (23,280.00) (15,327.00) (40,963,00) (14,426.00) USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY BUDGET 63600 1080101 BUDGET 63600 1080101 BUDGET 63600 1080201 BUDGET 63600 1080201 BUDGET 63600 1080201 BUDGET 63600 1080201 BUDGET 63600 1080201 BUDGET 63600 1080201 BUDGET 63600 1080601 121000 152000 121010 132200 152000 152020 152030 182190 152000 722770 722770 722770 722770 722770 722770 722770 722770 722770 (290.00) (72,329.00) (29,464.00) (59,322.00) (16,670.00) (7,017.00) (14,945.00) (20,281.00) (2,556.00)
(81307:00) TObi.06 (4,443.00) (13,614.00) 18.,057.00 47,559.00 (5,564.00) (2,687.00) (9,026.00) (4,911.00) (11,672.00) (10,996.00) (2,703.00) (8000 000.00) 8;000,00000 OAKLAND COUNTY, MICHIGAN SCHEDULE C FRINGE BENEFIT FUND RETIRMENT AMENDMENTS FISCAL YEAR 2017 FIRST QUARTER AMENDMENTS Unit Ledger Fund Dept Program Account Project USCTY BUDGET 63600 1080601 152015 722770 USCTY BUDGET 63600 1080601 152090 722770 USCTY BithdEll'ktielidatifif.-15200 665382 Drain Equipment Fund #63900 USCTY BUDGET 63900 6010101 149760 722770 ii:td.r.rei:OUDGET 63900 6010101 -0504 Motor Pool Fund #66100 USCTY BUDGET 66100 1030811 184010 722770 USCTY BUDGET 66180 1030811-.184010 685882 Telephone Communications Fund #67500 USCTY BUDGET 67500 1080601 152090 722770 USCTY BUDGET 6150 1068601 152080 665882 Building Liability Fund #67700 USCTY BUDGET 67700 1010501 182000 722770 USCTY BUDGET 67700 1010502 182000 722770 USCTY BUDGET 67700 9015501 182110 685882- USCTY BUDGET 67800 9011501 183190 630672 USCTY BUDGET 67800 1010502 183000 722770 USCTY BUDGET 67800 1020615 182080 722770 USC7Y BUDGET 67800 1050411 183150 722770 USCTY BUDGET 67800 1050504 183194 722770 USCTY BUDGET 67800 1050515 183165 722770 USCTY BUDGET 67800 1050520 183160 722770 U SC-FY BUDGET 67800 1050521 183192 722770 USCTY BUDGET 67800 1050521 183192 630672 :t4t0Ty poppgr,.5788a:105-052t 183192 _ _ 665882 INFORMATIONAL - DO NOT POST OU Fund Affl BudRef Proj Unit Activity Analysis Adjustment Amount (32,580.00) (115,186.00) 370,640 00 (722,794.00) (30,921.00) Friend of the Court Fund #27100 (informational only - do not post) USCTY BUDGET 27100 3010404 126030 722770 USCTY BUDGET 27100 3010404 126035 722770 USCTY BUDGET 27100 3010404 126050 722770 USCTY BUDGET 27100 3010404 135140 722770 USCTY BUDGET 27100 4030925 110070 722770 Grants Drug Court District 52 2 SCA() Fund #27160 (informational only - do not post) USCTY BUDGET 27160 3020301 121050 722770 GR0000000243 USCTY BUDGET 27160 3020305 121050 722770 GR0000000243 ATPA Grants Fund #27310 (informational only - do not post) USCTY BUDGET 27310 4030901 116270 722770 GR0000000377 Prosecutor Co Op Reimbursement Fund #27315 (informational only - do not post) USCTY BUDGET 27315 4010201 126070 722770 GR0000000143 Sheriff Road Patrol Fund #27345 (informational only - do not post) (194,339.00) (2,453.00) (42,992.00) (52,249.00) (20,164.00) 2017 GRANT GLB GLB 1,105.00 2017 GRANT GLB GLB (1,105.00) 2017 GRANT GLB GLB (17,417.00) 2017 GRANT GLB GLB (49,077.00)
OAKLAND COUNTY, MICHIGAN SCHEDULE C FRINGE BENEFIT FUND RETIRMENT AMENDMENTS FISCAL YEAR 2017 FIRST QUARTER AMENDMENTS Unit Ledger Fund Dept Program Account Project OU Fund Aff BudRef Proj Unit Activity Analysis Adjustment Amount USCTY BUDGET 27345 4030601 110010 722770 GR0000000142 2017 GRANT GLB GLB (16,135.00) Paul Coverdell Grant Fund #27346 (informational only - do not post) USCTY BUDGET 27346 4030901 116240 722770 GR0000000708 2017 GRANT GLB GLB (2,238.00) Community Development Block Grants Fund #29701(informational only - do not post) 2015 2015 2015 2015 2015 USCTY USCTY USCTY USCTY USCTY BUDGET 29701 1020622 132000 BUDGET 29701 1090611 132210 BUDGET 29701 1090611 132280 BUDGET 29701 1090611 172130 BUDGET 29701 1090680 132210 722770 722770 722770 722770 722770 GR0000000381 27003 GR0000000381 27004 GR0000000381 27003 GR0000000381 27002 GR0000000381 27004 GRANT GRANT GRANT GRANT GRANT (2,102.00) (1,792.00) (27,824.00) (10,977.00) (4,927.00) GLB GLB GLB GLB GLB GLB GLB GLB GLB GLB Workforce Dev Undistributed Fund #29801(informational only - do not post) USCTY BUDGET 29801 1020622 170000 722770 GR0000000294 2017 GRANT GLB GLB (1,788.00) USCTY BUDGET 29801 1090205 171010 722770 GR0000000294 2017 GRANT GLB GLB (2,693.00) USCTY BUDGET 29801 1090701 170010 722770 GR0000000294 2017 GRANT GLB GLB (10,312.00)
COUNTY OF OAKLAND
FY 2017 FIRST QUARTER REPORT
GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT
FY 2017
ADOPTED
BUDGET
BUDGET
AS
AMENDED
FY 2017
FORECAST
AMOUNT
FAVORABLE/
rUNFAVORABLQ PERCENT
REVENUES
GENERAL FUND
Taxes $ 216275,088.00 $ 216,275,088.00 3 216,275,088,00
Federal Grants 702,685.00 702,685,00 727,685.00
Stale Grants 20,328,603.00 20,328,603.00 19,266,103 00
Other Intergovernmental Revenue 44,205,554.00 44,205,554,00 44,205,554.00
Charges for Services 107,492,920.00 108,447,594.00 109,069,219.00
Indirect Cost Recovery 8,000,000.00 8,000,000.00 8,000,000.00
Investment Income 1,904,900.00 1,904,900.00 1,904,900.00
Other Revenues 12,621,827.00 12,640,767.00 12,694,706.00
0,00%
25,000.00 3.56%
(1,062,500.00) -5.23%
0.00%
621,625.00 0.57%
0.00%
0.00%
53,939.00 043%
SUB-TOTAL GENERAL FUND/GENERAL PURPOSE $ 411,531,577,00 $ 412,505,191.00 $ 412,143,255.00 $ (361,936.00) -0.09%
PLANNED USE OF FUND BALANCE $ 32,532,802.00 $ 35,665,779.15 $ 35,665,779.15 $ 0.00%
TOTAL GF/GP FUNDS $ 4447064,379.00 $ 448,170,970.15 $ 447 809 034 5 (361,936.00) -0.08%
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
52nd District Court
Probate Court
TOTAL ADMIN. OF JUSTICE
LAW ENFORCEMENT
Prosecuting Attorney
Sheriff
$ 52,615,792.00
17,094,806.00
6,381,267,00
$ 76,091,865.00
$ 53,783,235.87 $ 50,278,235.87 3 3,505,003,00
17,144,015.00 16,827,015.00 317,000.00
6,405,250.00 6,360,250.00 45,000,00
$ 77,332,500.87 $ 73,465,500.87 $ 3,867,000.00
20,021,946,00 20,125,103.00 19,567,903.00 557,200.00
146,495,179.00 147,527,815.00 147,518,815,00 9,000.00
6.52%
1,85%
0.70%
5.00%
2.77%
0.01%
TOTAL LAW ENFORCEMENT $ 166,517,125.00 $ 167,652,918.00 $ 167,086,718.00 $ 566,200.00 0.34%
GENERAL GOVERNMENT
Clerk/Register of Deeds
Treasurer
Board of Commissioners
Library Board
Water Resources Commissioner
TOTAL GENERAL GOVERNMENT
COUNTY EXECUTIVE
County Executive Admit,
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
10,613,623.00
8,784,820.00
2,896,745.00
1,343,140,00
5,688,932.00
$ 29,327,260.00
$ 7,592,192.00
19,823,114.00
2,594,626.00
1,282,266.00
4,402,468.00
65,294,635.00
17,504,029,00
8,141,811.00
$ 126,635,141.00
$ 398,571,381.00
10,678,829.00
8,941,567.00
2,994,904.00
1,349,408.87
5,749,453.00
$ 29,714,16t87
$ 7,650,926.00
20,066,412.34
2,630,395.00
1,282,325.00
4,623,813.00
65,638,606.07
17,625,380.00
8,359,696.00
$ 127,877,453.41
$ 402,577,034.15
9,892,429,00
8,940,067.00
2,937,104.00
1,323,508.87
5,849,453.00
$ 28,942,56t87
786,400.00 7.36%
1,500.00 0.02%
57,800,00 1.93%
25,900.00 1.926'o
(1130,000,00) -1.74%
771,600.00 2.60%
$ 7,650,926.00 0,00%
18,921,412.34 1,145,000.00 5.71%
2,630,395.00 0.00%
1,282,325,00 0,00%
4,573,813.00 60,000.00 1.08%
61 ,338,337.07 4,300,269.00 6.55%
17,385,380.00 240,000.00 1.36%
7,411,196,00 948,400.00 11.35%
$ 121,193,784.41 $ 6,683,689.00
$ 390,688,565.15 $ 11,888,469,00 2.95%
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTAL
45,492,998,00 $ 45,593,936.00 $ 45,593,936.00 0,00%
TOTAL GOVERNMENTAL EXPENDITURES 444 064 379.00 $ 448 170 970 15 $ 436,282 501.15 11,888,469.00 2.65%
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)
$ 11,526,533.00 $ 11,526,533.00
3 (36,665,779 15) $ (35,665,779,15)
(324,139,246.15) ($24,139,246.15)
38
Other Taxes - Trailer Tax Total Taxes 80,000.00 80,000.00 80,000.00 $ 216,275,088.00 $ 216,275,088.00 $ 216,275,088.00 $ 0.00% 0.00% Total Federal Grants STATE GRANTS (615000-615999) Sheriff- Patrol State Match Foster Care Prosecuting Attorney Economic Development Health Division Water Resources Commissioner Public Services - Veteran's Services Non-Departmental - Child Care Subsidy 702,685.00 $ 702,685.00 $ 727,685.00 $ 25,000.00 - $ - $ - $ 1,000.00 1,000.00 1,000.00 4,709,523.00 4,709,523.00 4,709,523.00 40,000.00 40,000.00 40,000.00 15,578,080.00 15,578,080.00 14,515,580.00 (1,062,500.00) COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2017 FIRST QUARTER REPORT ADOPTED BUDGET AMENDED BUDGET FY 2017 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES TAXES (601000-601999) Property Taxes - July Tax Levy $ 215,796,588.00 $ 215,796,588.00 $ 215,796,588.00 $ 0.00% Other Taxes - Delinquent Tax - Prior Years 98,500.00 98,500.00 98,500.00 0.00% Treasurer Payment in Lieu of Taxes 300,000.00 300,000.00 300,000.00 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 8.33% Fay. Refunds School Meals (lunch program) primarily due to an increase in population at Children's Village as well as an increase in per meal reimbursement rate from the State. 3.56% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -6.82% Built into the Circuit Court Family Division, Human Services Administration and Children's Village budgets are Child Care Fund expenditures. A favorable variance within these expense areas reduces the 50% reimbursement the county receives. Unfav revenue variance is offset by Child Care Fund expenditure favorability. FEDERAL GRANTS (610000-610999) Sheriff- Patrol Sheriff Sheriff- investigative/Forensic Services Prosecuting Attorney Homeland Security - Disaster Control Health Division Children's Village 27,220.00 205,000.00 60,800.00 109,665.00 300,000.00 27,220.- 00 205,000.- 00 60,800.00 109,665.00 300,000.00 27,220.- 00 205,000.00 60,800.00 109,665.00 326,000.00 25,000.00 Total State Grants $ 20,328,603.00 $ 20,328,603.00 $ 19,266,103.00 $ (1,062,500.00) -5,23% OTHER INTER-GOVERNMENTAL REVENUES (620000 - 626999) Non-Departmental $ 41,988,159.00 $ 41,988,159.00 $ 41,988,159.00 $ 0.00% HHS - Homeland Security 18,000.00 18,000.00 18,000.00 0.00% Circuit Court 4,500.00 4,500.00 4,500.00 0.00% District Court 1,800.00 1,800.00 1,800.00 0.00% Sheriff 263,675.00 263,675.00 263,675.00 0.00% Non-Departmental - Reimb Judges Salaries 1 929 420.00 1,929,420.00 1,929,420.00 0.00% Total Other Intergovernmental Revenue $ 44,205,554.00 $ 44,205,554.00 5 44,205,554.00 $ 0.00%
COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2017 FIRST QUARTER REPORT ADOPTED BUDGET AMENDED BUDGET FY 2017 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES CHARGES FOR SERVICES (630000-635999) Administration of Justice Circuit Court - Judicial/Administration Circuit Court - Civil/Criminal Circuit Court - Family Division District Court - Division I (Novi) - $ 2,436,000.00 1,800,000.00 4,099,200.00 - $ - $ 2,436,000.00 2,436,000.00 1,800,000.00 1,800,000.00 4,099,200.00 3,899,200.00 (200,000.00) 0.00% 0.00% 0.00% -4.88% Unfav. Probation Fees ($100,000) and Ordinance Fines and Costs ($100,000) due to a reduction in caseload. District Court - Division II (Clarkston) 1,730,200.00 1,730,200.00 1,730,200.00 0.00% District Court - Division III (Rochester Hills) 3,588,900.00 3,588,900.00 3,588,900.00 0.00% District Court - Division IV (Troy) 2,249,781.00 2,249,781.00 2,249,781.00 0.00% Probate Court - Estates and Mental Health 507,600.00 507,600.00 537,600.00 30,000.00 5.91% Fav. Gross Estate Fees due to an increase in fees paid. Total Administration of Justice $ 16,411,681.00 $ 16,411,681.00 $ 16,241,681.00 $ (170,000.00) -1.04% Law Enforcement Prosecuting Attorney 294,800.00 $ 290,000.00 306,600.00 $ 16,600.00 5,72% Fav. State Approp Victim Witness $26,100 and Microfilming $2,500 due to increased activity. Partially offset by unfavorable Welfare Fraud Case Review ($12,000) due to the State performing the review in-house. Sheriffs Office 1,900.00 1,900.00 1,900.00 0.00% Sheriff - Administrative Services 432,400.00 432,400.00 433,300.00 900.00 0.21% Fay. Fee Income for collections related to Indigent Inmate Commissary goods, Sheriff - Corrective Services Sheriff - Corrective Services Satellites Sheriff - Emergency Preparedness Training and Communications Sheriff - Emergency Communications Operations Sheriff - Patrol Services Sheriff - Investigative Forensic Services 3,155,266.00 565,278.00 894,450.00 1,535,000.00 48,455,029.00 1,015,000.00 3,155,266.00 565,278.00 894,450.00 1,586,950.00 49,362,553.00 1,015,000.00 3,140,966.00 591,278.00 894,450.00 1,586,950.00 49,364,953.00 1,026,200.00 -0.45% Unfav. due to declining Reimbursed Salaries receipts. 4.60% Fav. projected receipts of Reimburse Court Services for District Court Security. 0.00% (14,300.00) 26,000.00 0.00% 2,400.00 0.00% Favorable Fee Income of $2,200 from various 52nd District Court fee assessments and revenue sharing's; and Liquor Control Sheriff $200 reimbursement activity. 11,200.00 1.10% Fav. largely due to Reimbursement Salaries of $10,600 from unbudgeted billable activity; Miscellaneous $600 due to the timing in start-up of the DNA Laboratory. Total Law Enforcement $ 56,349,123.00 $ 57,303,797.00 $ 57,346,597.00 $ 42,800.00 0.07%
COUNTY OF OAKLAND GENERAL FUND !GENERAL PURPOSE REVENUES FY 2017 FIRST QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST JUN FAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES General Government Clerk - County Clerk $ 2,215,600.00 $ 2,215,600.00 $ 2,396,100,00 $ 180,500.00 8.15% Fav, Photostats $143,000, CVR County Portion $17,000, and Garnishment Fees $10,000 due to increased activity. Also favorable, E-Filing Fees $12,600 due to extension of pilot project; awaiting legislation approval of new statewide E-filing system. Clerk - Elections 82,900.00 82,900.00 128,600.00 45,700.00 55.13% Fay, due to Reimb. General $30,000 reimbursement from State of Michigan for costs associated with the 2016 Presidential Election recount. Election Filing Fees Late $13,100 due to Corporation Counsel efforts to collect on late filers. Passport Fees $1,600 and Photographs $1,000 due to increased activity. (73,500.00) Clerk - Register of Deeds & Micrographics Treasurer 11,304,600.00 11,231,000.00 5,032,300.00 -0,65% Unfav. Revenue is unfavorable due to a legislative change, effective October 1, 2016. Per PA 224 of 2016, the fee structure for recording a document at the county level changed to a fiat fee of $30. The Clerk Register of Deeds office will be charging $30 per recorded document regardless of number of document pages. The following accounts will be affected: unfavorable Mortgages ($700,000) partially offset by favorable Recording Fees $500,000 and Deeds $150,000. In addition, Reimb. General unfavorable ($15,000) due to less than antincipated use. 11,304,500.00 5,032,300.00 5,043,100.00 10,800.00 0,21% Fav. Deeds $10,100 due to increased in activity. Board of Commissioners Library Board Water Resources Commissioner 12,500.00 14,000.00 1,953,732.00 12,500.00 14,000.00 1,953,732,00 12,500.00 14,000.00 2,073,732.00 120,000.00 0.00% 0.00% 6.14% Fay - Reimbursement General $100,000 a result of Drain Administration able to charge more time than anticipated to special revenue and proprietary funds. Fav - Soil Erosion Fees $20,000 increase in building activity/permits due to improvement in the housing market. Total General Government $ 20,615,532.00 3 20,615,532.00 $ 20,899,032.00 $ 283,500.00 1.38% County Executive County Exec - Compliance Office M&B - Equalization Division M&B - Fiscal Services Division Central Services - Support Services 230,000.00 $ 230,000.00 $ 3,260,000.00 3,260,000.00 505,600.00 505,600.00 316,780.00 316,780.00 230,000.00 3,260,000.00 505,600.00 316,780.00 0.00% 0.00% 0.00% 0.00%
COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2017 FIRST QUARTER REPORT ADOPTED BUDGET 475.00 AMENDED BUDGET 475.00 FY 2017 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES (475.00) -100.00% Untav. Miscellaneous ($475) fees no longer collectible due to a procedural change. Human Resources 0.00% -0.47% Unfav. Clinic Charges ($125,000) due to decrease in flu vaccines and revenues being captured in another account (Administration Fees). Unfav. Laboratory Charges 3rd Party ($100,000) due to a delay in the start of program. Unfav. Diff Between Chg and Mit Pay ($75,000) due to the difference between insurance billing and reimbursements. Partially offset by fav. Permits $125,000 due to increased demand. Fav. Administration Fees $100,000 due to receipt of delayed Medicaid Outreach payment from State; increase in vaccination clinic visit fees; and capturing revenues from another account (Clinic Charges). Fav. Pneumo Vax 3rd Party $30,000 and Flu 3rd Party $25,000 due to increased reimbursement from 3rd party payers. 17.45% Fav. Board and Care $300,000 as well as Out County Board and Care $200,000 due to increase in reimbursement rate from the State. 0.00% 0.00% -67.62% unfav. Reimbursement General due to staffing changes and classes no longer being offered by Oakland County. HHS - Administration HHS - Health Division 4,281,399.00 4,281,399.00 4,261,399.00 (20,000.00) HHS - Children's Village 2,865,000.00 2,865,000.00 3,365,000.00 500,000.00 HHS - Homeland Security Public Services - Community Corrections 190,000.00 190,000.00 190,000.00 Public Services - MSU Extension 21,000.00 21,000.00 6,800.00 (14,200.00) Public Services - Medical Examiner 339,000.00 339,000.00 339,000.00 0.00% Public Services - Animal Control 913,200.00 913,200.00 913,200.00 0.00% Public Services - Circuit Court Probation 0.00% 24,000.00 453,318.00 13,399,772.00 $ Economic Dev. & Comm. Affairs - Admin Economic Dev. & Comm. Affairs - PEDS Total County Executive Non-Departmental Non-Dept - Charges for Services 24,000.00 453,318.00 $ 13,399,772.00 $ 24,000.00 0.00% 453,318.00 0.00% 13,865,097.00 $ 465,325.00 3.47% 716,812.00 0.00% 716,812.00 $ 716,812.00 Total Non-Departmental 716,812.00 $ 716,812.00 $ 716,812.00 $ 0.00% Total Charges for Services $ 107,492,920.00 $ 108,447,594.00 $ 109,069,219.00 $ 621,625.00 0.57% INDIRECT COST RECOVERY (640100) $ 8,000,000.00 $ 8,000,000.00 $ 8,000,000.00 0.00%
Economic Development Non-Departmental Total Investment Income $ 1,904,900.00 $ 1,904,900.00 $ 1,904,900.00 $ 1,800,000.00 1,800,000.00 1,800,000.00 0.00% 0.00% 0.00% 18,940.00 $ 5,000.- 00 5,000.- 00 6,000.00 18,940.00 $ 5,000.00 800.00 6,000.00 6,000.00 13,100.00 600.00 OTHER REVENUES (670000-6955001 Circuit Court-Donations Circuit Court-County Auction Circuit Court District Court Probate Court Prosecuting Attorney Sheriff Office Sheriff - Administrative Services Sheriff - Corrective Services Sheriff - Corrective Services-Satellites Sheriff - Emergency Prep and Communications Sheriff- Emergency Communications Operations Sheriff - Patrol Services Sheriff - Investigative/Forensic Svc Clerk/Register of Deeds Treasurer 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 800.00 100.00% Fav. Refund of Prior Years Expenditures. 0.00% 0.00% 0.00% 0.00% 13,100.- 00 100.00% Fay. Refund of Prior Years Expenditures for reimbursement of Sheriffs overtime. 600.00 100.00% Fay. Due to cash overages. 0.00% COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2017 FIRST QUARTER REPORT AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ADOPTED AMENDED FY 2017 BUDGET BUDGET FORECAST INVESTMENT INCOME (655000-655999) District Courts (Div. I - IV) 2,400.00 $ 2,400.00 $ 2,400.00 $ 0.00% Sheriff Corrective Services 0.00% Sheriff Investigative/Technical Services 0.00% Treasurer 100,000.00 100,000.00 100,000.00 0.00% Clerk/Register of Deeds 2,500.00 2,500.00 2,500.00 0.00% Board of Commissioners Library Board Water Resources Commissioner County Exec - Compliance Office Management and Budget - Fiscal Services Central Services - Support Services Facilities Management Engineering Health Division - Contributions 600.00 600.00 70.00 600.00 0.00% 0.00% 70.00 100.00% Fay. Refund of Prior Year Expenditures 0.00% 0.00% 0.00% 0.00% 0.00%
Public Services - Medical Examiner Public Services - Animal Control-Other Revenues Public Services - Animal Control-Transfers In 44,263.00 44,263.00 Economic Development & Comm Affairs - Other 35,000.00 Economic Development - Contributions Non Departmental - Donations Non-Dept - Sundry Sheriffs' Transfers Treasurers' Transfers 29,240.00 417,500.00 71,046.00 3,048,178.00 29,240.00 417,500.00 71,046.00 3,048,178.00 28,500.00 417,500.00 71,046.00 3,048,178.00 COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2017 FIRST QUARTER REPORT Health Division Health Division - Transfers In Children's Village ADOPTED BUDGET AMENDED BUDGET FY 2017 FORECAST 9,862.00 17,875.00 AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 9,862.00 100.00% Fay. primarily due to Refund Prior Years Expenditure in order to reflect refund for vaccines. 0.00% 17,875.00 100.00% Fav. Prior Years Adjustments to adjust accounts payable for amounts previously accrued but determined to be no longer required. 0.00% 100.00% Fav. Refund Prior Years Expenditure primarily due to the recovery of costs associated with accidental damage caused to one outdoor warning system. Revenue favorability is offset in expenditure accounts (Maintenance Contract and Tornado Siren Equip) 0.00% 0.00% -100.00% Transfers In budgeted with MR #14275 not anticipated in FY 2017. Children's Village - Transfers In Homeland Security 21,635.00 21,635.00 (44,263.00) 35,000.00 100.00% Fav.Prior Year Expenditures $35,000 due to refund of Software Maintenance for 2016 Collaborative Development Council Grant. (740.00) -2.53% Unfav, due to reduction in Medical Main Street activity. 0.00% 0.00% 0.00% 0.00% Non-Departmental -Transfers In 9,000,000.00 9,000,000.00 9,000,000.00 0.00% Total Other Revenues $ 12,621,827.00 $ 12,640,767.00 12,694,706.00 $ 53,939.00 0.43% PLANNED USE OF FUND BALANCE (665000-665999) Encumbrances and Carry forwards - 3,796,446.15 3,796,446.15 0.00% Use of Prior Yrs Fund Balance $ 32,532,802.00 $ 31,869,333.00 31,869,333.00 0.00% Total Planned Use of Fund Balance $ 32,532,802.00 $ 35,665,779.15 $ 35,665,779.15 $ 0.00% TOTAL GEN. FUND! GEN. PURPOSE REVENUE $ 444,064,379.00 $ 448,170,970.15 $ 447 809 034.15 $ (361,936.00) -0.08%
Internal Support Expenditures Civil! Criminal Division Personnel Expenditures 159,310.00 160,266.00 160,266.00 5 2,047,175.00 5 2,048,131.00 5 2,043,131.00 $ $ 1,862,100.00 5 1,862,100.00 $ 1,862,100.00 $ 0.00% - 5,000.00 0.24% 0.00% - COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Judicial Administration Personnel Expenditures $ 8,939,506.00 $ 8,939,506.00 $ 8,739,506.00 $ 200,000.00 2.24% - Fay. due to underrilled and vacant positions. Operating Expenditures 110,876.00 410,652.55 410,652.55 0.00% Internal Support Expenditures 401,261.00 426,350.00 426,350.00 0.00% - Transfer Out 18,940.00 18,940.00 0.00% Business Division Personnel Expenditures Operating Expenditures $ 9,451,643.00 $ 9,795,448.55 $ 9,595,448.55 $ $ 1,810,631.00 $ 1,810,631.00 $ 1,810,631.00 $ 77,234.00 77,234.00 72,234.00 200,000.00 2.04% 0.00% - 5,000.00 6.47% - Fay. Computer Supplies $5,000 due to lower than anticipated US9. Operating Expenditures 5,191,431.00 5,968,622.00 5,618,622.00 350,000.00 5.86% - Fay. Defense attorney Fees $250,000 due to a decline in both caseload and requests for appointed counsel. Also fay. Attorney Fees Mediators $50,000 and Juror Fees and Mileage $50,000 due to a decline in caseload. 45
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT— EXPLANATION OF SIGNIFICANT VARIANCES Internal Support Expenditures 2,641,069.00 2,723,200.00 2,723,200.00- 0.00% - Transfers Out $ 9,694,600.00 $ 10,553,922.00 $ 10,203,922.00 $ 350,000.00 3.32% Family Division/Juvenile Maint. Personnel Expenditures Operating Expenditures $ 11,394,873.00 $ 11,454,991.00 $ 11,254,991.00 $ 13,115,409.00 13,016,874.32 10,266,874.32 200,000.00 2,750,000.00 1.75% - Fav. due to underlined and vacant positions. 21.13% - Fay, due to decrease in placements to State Institutions $2,500,000 and Priv Institutions Residential $200,000. Also fav., Professional Services $50,000 due to lower than anticipated use. Offset by unfavorable Non-Dept Child Care Subsidy Revenue (50% Reimbursement). Internal Support Expenditures 1,665,439.00 1,667,216.00 1,667,216.00 0.00% - Transfer Out 5,246,653.00 5,246,653.00 5,246,653.00 0.00% - -------- $ 31,422,374.00 $ 31,385,734.32 $ 28,435,734.32 $ 2,950,000.00 9.40% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 24,007,110.00 18,494,950.00 4,867,079.00 5,246,653.00 $ 24,067,228.00 $ 23,667,228.00 $ 19,473,382.87 16,368,382.87 4,977,032.00 4,977,032.00 5,265,593.00 5,265,593.00 400,000.00 3,105,000.00 1.66% 15.94% 0.00% 0.00% $ 52,615,792.00 $ 53,783,235.87 $ 50,278,235.87 $ 3,505,000.00 6.52% 46
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES District Court Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Division 1 - Novi Personnel Expenditures Operating Expenditures $ 211,708.00 $ 211,708.00 $ 211,708.00 $ 10,300.00 10,300.00 10,300.00 1,766.00 1,766.00 1,766.00 $ 223,774.00 $ 223,774.00 $ 223,774.00 $ $ 4,275.049.00 $ 4,275,049.00 $ 4,200,049.00 1,021,191.00 1,021,191.00 1,001,191.00 0.00% 0.00% 0.00% 0.00% 0.00% 75,000.00 1.75% - Fay. due to turnover and undertIlled positions/vacancies. 20,000.00 1.96% - Fay. Software Support Maintenance $10,000 due to a reduction In caseload and equipment which affects the Judicial Information Systems (JIS) Services Fees invoiced by the State of MI. Also fay. Medical Exam $5,000 and Office Supplies $5,000 due to efforts to keep costs down. Internal Support Expenditures 350,541.00 363,690.00 358,690.00 5,000.00 1.37% - Fay. Info Tech Operations due to lower than anticipated use. Transfers Out 0.00% - Total Division 1 - Novi $ 5,646,781.00 $ 5,659,930.00 $ 5,559,930.00 $ 100,000.00 1.77% 45,000.00 2.10% - Fay. due to turnover and underilled positions/vacancies. 40,000.00 6.23% - Fay. Defense Attorney Fees $20,000 due to restructured schedule for defense attorneys. Also fay. Software Support Maintenance $10,000, Electrical Service $5,000 and Printing $5,000 due to lower than anticipated use. Division 2 - Clarkston Personnel Expenditures $ 2,140,363.00 $ 2,140,363.00 $ 2,095,363.00 Operating Expenditures 642,068.00 642,068.00 602,068.00 Internal Support Expenditures 190.457.00 206,853.00 206,853.00 0.00% - Transfers Out 0.00% - Total Division 2- Clarkston $ 2,972,888.00 $ 2,989,284.00 $ 2,904,284.00 $ 85,000.00 2.84% 47
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT FY 2017 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ADOPTED AMENDED BUDGET BUDGET 2.51 % - Fay. due to turnover and underfilled positions/vacancies. 11.28% - Fav. Defense Attorney Fees $15,000 due to a decrease in requests for appointed counsel. Also Fav. Juror Fees and Mileage $15,000, Printing $5,000, Office Supplies $7,000 and Software Support Maintenance $5,000 due to effort to keep costs down. -4.75% - Unfav. Defense Attorney Fees ($40,000) due to an increase in requests for appointed counsel; partially offset by fey. Electrical Service $10,000 and Software Support Maintenance $5,000 due to lower than anticipated use. Division 3 - Rochester Hills Personnel Expenditures $ 3,978,448.00 $ 3,978,448.00 $ 3,878,448.00 100,000.00 Operating Expenditures 416,733.00 416,733.00 369,733.00 47000.00 Internal Support Expenditures Transfers Out Division 4- Troy Personnel Expenditures Operating Expenditures 526,388.00 526,388.00 551,388.00 (25,000.00) 781,040.00 793,493.00 788,493.00 5,000.00 0.63% - Fav. Info Tech Operations $5,000 due to lower than anticipated use. - 0.00% $ 5,176,221.00 $ 5,188,674,00 $ 5,036,674.00 $ 152,000.00 2.93% $ 2,307,909.00 $ 2,307,909.00 $ 2,307,909.00 0.00% Internal Support Expenditures 240,845.00 248,056.00 243,056.00 5.000.00 2.02% - Fay. Info Tech Operations $5,000 due to lower than anticipated use. Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 3,075,142.00 $ 3,082,353.00 $ 3,102,353.00 $ (20,000.00) -0.65% $ 12,912,477.00 $ 12,913,477.00 $ 12,693,477.00 $ 220,000.00 1.70% 2,616,680.00 2,616,680.00 2,534,680.00 82,000.00 3.13% 1,564,649.00 1.613,858.00 1,598,858.00 15,000.00 0.93% - - - $ 17,094,806.00 $ 17,144,015.00 $ 16,827,015.00 $ 317,000.00 1.85% 48
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES PROBATE COURT ADOPTED BUDGET AMENDED BUDGET AMOUNT FY 2017 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Judicial/Administration Personnel Expenditures $ 2,391,300.00 $ 2,391,300.00 $ 2,361,300.00 $ 30,000.00 1.25% Fay. due to turnover and underfilled positions/vacancies. Operating Expenditures 29,481.00 29,481.00 19,481.00 10,000.00 33.92% Fay. Library Continuations $5,000 due to efforts to reduce spending and Visiting Judges $5,000 due to the Court limiting the use of visiting judges. Internal Support Expenditures 293,944.00 294,309.00 294,309.00 0.00% Transfer Out $ 2,714,725.00 $ 2,715,090.00 $ 2,675,090.00 $ 40,000.00 1.47% 50,000.00 2.21% Fav. due to turnover and unclerfilled positions/vacancies. (45,000.00) -5.66% Unfav. Defense Attorney Fees ($30,000) and Medical Services Guardianship/Probate ($15,000) due to an increased number of case filings and continued high demand for these services. Estates/Mental Health Personnel Expenditures $ 2,261,029.00 $ 2,261,029.00 $ 2,211,029.00 $ Operating Expenditures 781,943.00 794,770.00 839,770.00 Internal Support Expenditures 623,560.00 634,361.00 634,361.00 0.00% $ 3,666,532.00 $ 3,690,160.00 $ 3,685,160.00 $ 5,000.00 0.14% Department Total Personnel Expenditures $ 4,652,329.00 $ 4,652,329.00 $ 4,572,329.00 $ 80,000.00 1.72% Operating Expenditures 811,424.00 824,251.00 859,251.00 (35,000.00) -4.25% Internal Support Expenditures 917,504.00 928,670.00 928,670.00 0,00% Transfer Out - $ 6,381,257.00 $ 6,405,250.00 $ 6,360,250.00 $ 45,000.00 0.70% 49
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY ADOPTED BUDGET AMENDED BUDGET AMOUNT FY 2017 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 2,264,405.00 $ 2,271,063.00 $ 2,232,663.00 $ 38,400.00 1.69% Fay. due largely to a number of underlilled positions and personnel working across divisional disciplines as assigned. Operating Expenditures 515,213.00 515,213.00 524,213.00 Internal Support Expenditures 1,822,989.00 1,852.488.00 1,815,788.00 (9,000.00) -1.75% Unfav. Library Continuations ($52,900), Extradition Expense ($22,000), Membership Dues ($18,000) due to increased activity. Partially offset by favorable Computer Research Service $25,000, Travel 8. Conference $15,000, Witness Fees and Mileage $15,000, Professional Services $9,500, Training $5,000, Expendable Equipment $5,000, Security Supplies $5,000 and Microfilming $3,300 due to less than anticipated use. 36,700.00 1.98% Fay, primarily due to Info Tech Operations $40,600, Motor Pool Fuel Charges $2,000; partially offset by unfavorable Info Tech CLEMIS ($5,900) due to actual usuage. Transfers 67,000.00 67,000.00 0.00% $ 4,602,607.00 $ 4,705,764.00 $ 4,639,664.00 $ 66,100,00 1.40% Litigation Personnel Expenditures $ 10,184,987.00 $ 10,184,987.00 $ 9,959,987.00 $ 225,000.00 2.21% Fav. due largely to a number of underfilled positions and positions assigned to this division but actually working across divisional disciplines. Operating Expenditures Internal Support Expenditures Transfers Out 33,296.00 33,296.00 30,796.00 2,500.00 7.51% Fay. Persona] Mileage $4,800 due to less than anticipated use. Partially offset by unfavorable Clothing Allowance ($2,250) due to increased use. 36,591.00 36,591.00 50,291.00 (13,700.00) 0.00% Unfav. Info Tech Operations ($15,600) partially offset by favorable Telephone communications $1,800 due to usage. 975,027.00 975,027.00 975,027.00 0.00% $ 11,229,901.00 $ 11,229.901.00 $ 11,016,101.00 $ 213,800.00 1.90% 50
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Warrants Personnel Expenditures Operating Expenditures $ 2,297,211.00 $ 2.297,211.00 $ 2,118,711.00 5 178,500.00 7.77% Fay, due largely to a number of undeffilled positions and positions assigned to this division but actually working across divisional disciplines. 3,199.00 3,199.00 4,499.00 (1,300.00) -40.64% Unfav. Personal Mileage due to increased use. Internal Support Expenditures 3,306.00 3,306.00 3,306.00 0.00% Appellate Personnel Expenditures Operating Expenditures $ 2,303,716.00 $ 2,303,716.00 $ 2,126,516.00 $ 177,200.00 $ 1,874,849.00 $ 1,874,849.00 $ 1,779,749.00 $ 95,100.00 7.69% 5.07% Fay. due largely to a number of underfilled positions and positions assigned to this division but actually working across divisional disciplines. 8,458.00 8,458.00 3,458.00 5,000.00 59.12% Fav. due to less than anticipated use in Personal Mileage. Internal Support Expenditures 2,415.00 2,415.00 2,415.00 0.00% $ 1,885,722.00 $ 1,885,722.00 $ 1,785,622.00 $ 100,100.00 5.31°/D Department Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 16,621,452.00 $ 16,628,110.00 560,166.00 560,166.00 1,865,301.00 1,894,800.00 975,027.00 1,042,027.00 ------------- ------------- $ 20,021,946.00 $ 20,125,103.00 $ 16.091,110.00 $ 537,000.00 562,966.00 (2,800,00) 1,871,800.00 23,000.00 1,042,027.00 - ------------- ------------- $ 19,567,903.00 $ 557,200.00 3.23% -0.50% 1.21% 0.00% 2/7% 51
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Sheriffs Office Personnel Expenditures 1,755,727.00 $ 1,755,727.00 $ 1,707,027,00 $ 48,700.00 2.77% fay. Salaries of $16,000 and Fringe Benefits of $32,700 due to turnover. Transfers Out 75,736,00 75,736.00 66,736.00 7,000.00 9.24% Fav. Workshops and Meetings $7,000 due to less than anticipated use. 580,572.00 580,572.00 580,572.00 0.00% 0.00% Operating Expenditures Internal Support Expenditures $ 2,412,035.00 5 2,412,035.00 5 2,356,335.00 5 55,700,00 2.31% 31,900.00 1,48% Fay. Overtime of $27,400 and Salaries and Fringe Benefits of $4,500 due to turnover. 35,000.00 2.07% Favorabie Uniform Cleaning $25,000 and Indigent Orders of $10,000 due to less than anticipated use. Administrative Services Personnel Expenditures Operating Expenditures $ 2,151,637.00 5 2,151,637,00 $ 2,119,737.00 1,692,738.00 1,692,738.00 1,557,738.00 Internal Support Expenditures 78,158.00 78,158.00 78,158.00 0.00% Transfers Out 0,00% $ 3,922,533.00 $ 3,922,533.00 5 3,855,633.00 5 66,900.00 1.71% Corrective Services Personnel Expenditures 30,858,586.00 $ 30,869,225.00 $ 30,313,425.00 555,800.00 1.80% Fay. Salaries and Fringe Benefits of $2,901,800 partially offset by unfav. Overtime of ($2,346,000): a result of large number of vacancies, officers in the academy and officers in training. Hiring, training and filling-in for deputies is the major factor contributing to the high use of overtime. Operating Expenditures 7,871,073.00 7,871,073,00 6,793,673.00 1,077,400.00 13,69% Fay. Primarily due to Contracted Services of $980,000 which is related to savings in the Jail Food and Jail Clinic contracts. Also, favorable Prisoner Housing Outside of County $70,500; Transportation of Prisoners $19,000, Provisions $8,500, Groceries $8,500, all due to less than anticipated use. Partially offset by unfavorable Officers Training ($8,300); Interpreter Fees ($800), due to increased activity. Internal Support Expenditures 7,723,401.00 7,813,327.00 7,813,327.00 0,00% Transfers Out 0.00% $ 46,453,059.00 $ 46,553,625.00 $ 44,920,425.00 5 1,633,200.00 3.51% 52
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES SHERIFFS OFFICE AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Corrective Services-Satellites Personnel Expenditures $ 13,240,284.00 $ 13,240,284.00 $ 14,363,584.00 $ (1,123,300.00) -8.48% Unfav. due to increased usage of overtime at the Corrective Services Satellite facilities ($921,000) caused by Hospital Watch, vacant positions, prisoner transport, employee disability and other leaves, security at Animal Control and East Annex, Also unfavorable overtime related Fringe Benefits of ($533,600). Partially offset by favorable regular salaries of $331,300. Hiring, training and retaining Corrections Deputies and filling-in for deputies on disability has been a major factor contributing to the high use of overtime. Operating Expenditures 226,494.00 227,745.00 232,145.00 (4,400.00) -1.93% Unfavorable Travel Employee Taxable Meals of ($4,400). Internal Support Expenditures 1,205,421.00 1.207,309.00 1,207,309.00 0.00% Transfers Out 0.00% $ 14,672,199.00 $ 14,675,338.00 $ 15,803,038.00 $ (1,127.700.00) -7.58% Emergency Prep Training and Communications Personnel Expenditures $ 1,873,948.00 $ 1,897,848.00 $ 2,176,748.00 $ (278,900.00) -14.70% Unfav. Primarily due to Overtime due to vacant positions and turnover. Operating Expenditures 981,585.00 981,585,00 981,585.00 0.00% Internal Support Expenditures 75,688.00 75,688.00 75,688.00 0.00% Transfers Out 0.00% $ 2,931,221.00 $ 2,955,121.00 $ 3,234,021.00 $ (278,900,00) -9.44% Emergency Communications Operations Personnel Expenditures $ 7,675,028.00 $ 7,839,416.00 $ 9,236,216.00 $ (1,396,800.00) -17.82% Unfav. Primarilty due to Overtime due to vacant positions and turnover. Operating Expenditures Internal Support Expenditures Transfers Out 160,132.00 0.00% 0.00% 0.00% $ 7,979,964.00 $ 8,144,769.00 5 9,541,569.00 $ (1,396,800.00) -17.15% 159,715.00 160,132.00 145,221.00 145,221.00 145,221.00 53
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $49,550,294 $ 49.642,720.00 $ 48,574,220.00 $ 1,068.500.00 2.15% Fay, Salaries and Fringe Benefits of $886,000 due to turnover and vacancies; also fay. Overtime $182,500 related to patrol services activity. 1,064,522.00 1,259,119.001,174,519.00 84,600.00 6.72% Fav. Equipment Rental of $28,000 and Gasoline Charges $48,200; Officer Training of $8,400 due to less than anticipated use. Patrol Services Personnel Expenditures Operating Expenditures Internal Support Expenditures 5,087,459.00 5,140,657.00 5,140,657.00 0.00% Transfers Out - 91,182.00 91,182.00 0.00% ------------- ------------ ----------- -------------- $ 55,702,275.00 $ 56,133,678.00 $ 54,980,578.00 $ 1,153,100.00 2.05% $ 8,752,790.00 $ 8,752,790.00 $ 8,865,990.00 $ (113,200.00) -1.29% Unfav. Overtime of ($140,900) and overtime related fringe benefits of ($28,800), partially offset by favorable salaries of $56,500 largely due to turnover. 813,133.00 813,133.00796,433.00 16,700.00 2.05% Favorable Extradition Expense of $9,000; Fingerprint Supplies $8,000; all related to the delay in certification of the DNA Lab. Investigative/Forensic Svcs Personnel Expenditures Operating Expenditures Internal Support Expenditures 2,521,884.00 2,522,102.00 2,522,102.00 0.00% Transfers Out 334,086.00 642,691.00 642,691.00 0.00% $ 12,421,893.00 $ 12,730,716.00 $ 12,827,216.00 5 (96,500.00) -0.76% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 115,858,293.00 $ 116,149,647.00 $ 12,864,996.00 $ 13,081,261,00 $ 17,417,804.00 $ 17,563,034.00 $ 334,086.00 $ 735,873.00 --------------- ----------- 5 146,495,179.00 $ 147,527,815.00 $ 117,356,947.00 $ (1,207.300.00) $ 11,864,961.00 $ 1,216.300.00 $ 17,563,034.00 $ 733,873.00 $ 147,518,815.00 $ 9,000.00 0.01% -1.04% 9.30% 0.00% 0.00% 54
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 769,412,00 $ 769,412.00 $ 669,412.00 $ 100,000.00 13.00% Fay. Due to turnover, Operating Expenditures 34,900.00 34,900.00 28,200.00 6,700.00 19.20% Fav. Printing $4,900, Expendable Equipment $1,000 and Freight and Express $800 all due to less than anticipated use. Internal Support Expenditures 108,984.00 108,984.00 108,984.00 0.00% Transfers Out 0.00% $ 913,296.00 $ 913,296.00 $ 806,596.00 $ 106,700.00 11.68% County Clerk (Vital Stats & Legal Rec's) Personnel Expenditures $ 3,585,031.00 $ 3,585,031.00 $ 3,385,031.00 $ 200,000.00 5.58% Fav. Due to vacancies, turnover and underlined positions Operating Expenditures 279,160.00 279,160.00 179,060.00 100,100.00 35.86% Fay. Court Transcripts $42,000 due to prosecutors ordering fewer transcripts; Professional Services $34,200, Office Supplies $28,000, Personal Mileage $4,800, Equipment Maintenance $2,400 and Membership Dues $2,000 all are due to less than anticipated use. Partially offset by unfavorable Metered Postage ($9,600) and Charge Card Fee ($3,700) due to increased activity. Internal Support Expenditures 650,560.00 702,992.00 702,992.00 0.00% Transfers Out 0.00% --------------------- $ 4,514,751.00 $ 4,567,183.00 $ 4,267,083.00 $ 300,100.00 6.57% 55
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Elections Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 851,493.00 $ 781,178.00 298,309.00 851,493.00 $ 771,493.00 $ 80,000.00 781,178.00 808,178.00 (27,000.00) 310,257.00 310,257.00 9.40% Fay. Due to turnover and underfilled positions. -3.46% UnFav. Primarily due to Relocation for expenditures related to the 2016 Presidential Election recount however, partially offset by revenue Reimbursement General. A budget amendment is recommended. 0.00% 0.00% $ 1,930,980.00 $ 1,942,928.00 $ 1,889,928.00 $ 53,000.00 2.73% Register of Deeds (and Micrographics) Personnel Expenditures $ 2,609,903.00 $ 2,609,903.00 $ 2,359,903.00 $ 250,000.00 9.58% Fay. Due to vacancies, turnover and underfilied positions Operating Expenditures 271,494.00 271,494.00 $ 198,894.00 72,600.00 26.74% Fay. Metered Postage $25,500, Professional Services $24,000, Office Supplies $18,500 and Printing $3,892 due to less than anticipated use. Internal Support Expenditures 278,018.00 278,844.00 $ 278,844.00 0.00% Transfers Out 0.00% 5 3,159,415.00 $ 3,160,241.00 $ 2,837,641.00 $ 322,600.00 10.21% 56
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 14,938.00 $ 68,776.00 11,467.00 Jury Commission Personnel Expenditures Operating Expenditures Internal Support Expenditures 14,938.00 $ 14,938.00 5 68,776.00 67,776.00 1,000.00 11,467.00 8,467.00 3,000.00 0.00% 1.45% Fav. Miscellaneous due to less than anticipated use. 26.16% Fay. Building Space Allocation due to no longer occupying office space within Circuit Courts Jury area. $ 95,181.00 5 95,181.00 $ 91,181.00 5 4,000.00 4.20% Department Total Personnel Expenditures $ 7,830,777.00 $ 7,830,777.00 $ 7,200,777.00 $ 630,000.00 Operating Expenditures 1,435,508.00 1,435,508.00 1,282,108.00 $ 153,400.00 Internal Support Expenditures 1,347,338.00 1,412,544.00 1,409,544.00 $ 3,000.00 Transfers Out - - - 8.05% 10.69% 0.21% 0.00% $ 10,613,623.00 $ 10,678,829.00 $ 9,892,429.00 $ 786,400.00 7.36% 57
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES COUNTY TREASURER AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 3,372,686.00 $ 3,372,686.00 $ 3,372,686.00 $ _ 0,00% Operating Expenditures 4,512,105.00 4,512,105.00 4,510,605.00 1,500,00 0.03% - Fay. Title Search $293,900, Office Supplies $10,000, Twp & City Treasurer Bonds $8,700 and Membership Dues $3,190, Tax Collection Supplies $1,400 and Expendable Equipment $500 due to less than anticipated use. Partially offset by Claims Paid ($240,200) from a settlement on a foreclosed property that was in litigation and Recording Fee Redemption Certificate ($76,000) due to taxes paid in full on properties no longer in foreclosure. Internal Support Expenditures 780,029.00 855,276.00 855,276.00 0.00% - Transfers Out 120,000.00 201,500.00 201,500,00 - 0.00% Division Total 5 8,784,820.00 5 8,941,567.00 5 8,940,067.00 $ 1,500.00 0.02% Department Total 5 8,784,820.00 $ 8,941,567.00 $ 8,940,067.00 $ 1,500.00 0.02% 58
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES BOARD OF COMMISSIONERS AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures $ 2,185,531.00 $ 2,185,531.00 $ 2,185,531.00 $ 475,305.00 572,393.00 $ 514,593.00 0.00% - 57,800.00 10.10% - Pay. Workshops and Meeting $13,300 Personal Mileage $11,300, Travel and Conference $9,500, Legal Services $8,000, Legislative Expense $7,700, Printing $3,800, Special Events $2,000 and Expendable Equipment $1,000 due to less than anticipated use. Internal Support Expenditures 235,909,00 236,980.00 $ 236,980.00 0.00% - $ 2,896,745.00 $ 2,994,904.00 $ 2,937,104.00 $ 57,800.00 1.93% Department Total Personnel Expenditures $ 2,185,531.00 $ 2,185,531.00 $ 2,185,531.00 $ 0.00% Operating Expenditures 475,305.00 572,393.00 514,593.00 57,800.00 10.10% Internal Support Expenditures 235,909.00 236,980.00 236,980.00 0.00% $ 2,896,745.00 $ 2,994,904.00 $ 2,937,104.00 $ 57,800.00 1.93% 59
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES LIBRARY BOARD AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Library Board Personnel Expenditures $ 495,412.00 $ 495,412.00 $ 495,412.00 $ 0.00% Operating Expenditures Internal Support Expenditures Transfers Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers 379,281.00 381,264.87 355,364.87 468,447.00 472,732.00 472,732.00 $ 1,343,140.00 $ 1,349,408.87 $ 1,323,508.87 $ $ 495,412.00 $ 495,412.00 $ 495,412.00 $ 379,281.00 381,264.87 355,354.87 468,447.00 472,732.00 472,732.00 $ 1,343,140.00 $ 1,349,408.87 $ 1,323,508.87 $ 25,900.00 6.79% Fay. Computer Research Service $32,100 due to less than anticipated use; partially offset by unfavorable Library Continuations ($3,700) due to cost increases on print material Equipment Maintenance ($2,120) due to repairs on aging photovending equipment. 0.00% 25,900.00 1.92% 0.00% 25,900.00 6.79% 0.00% 25,900.00 1.92% 60
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES WATER RESOURCES COMMISSIONER AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Water Resource Commissioner Personnel Expenditures $ 218,414,00 $ 218,414.00 $ 218,414.00 $ 0.00% Operating Expenditures 532,975.00 532,975.00 532,975.00 0.00% Internal Support Expenditures 4,881,378.00 4,941,899.00 5,041,599.00 (100,000.00) -2.02% Untav - Drain Equipment Labor ($100,000) due to employee's labor that could not be charged to other funds. Transfers 56,165.00 56,165,00 56,165.00 0.00% Division Total $ 5,688,932.00 $ 5,749,453.00 $ 5,849,453.00 $ (100,000.00) -1.74% Department Total $ 5,688,932.00 $ 5,749,453.00 $ 5,849,453.00 $ (100,000.00) -1.74% 61
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES COUNTY EXECUTIVE AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 2,224,612.00 $ 2,224,612.00 2,224,612.00 $ 277,991.00 277,991.00 277,991.00 441,771.00 446,691.00 446,691.00 0.00% 0.00% 0.00% $ 2,944,374.00 $ 2,949,294.00 $ 2,949,294.00 $ 0.00% Compliance Office Personnel Expenditures $ 1,645,259.00 $ 1,645,259.00 $ 1,645,259.00 $ 0,00% Operating Expenditures 49,252.00 70,702.00 70,702.00 0.00% Internal Support Expenditures 191,794.00 210,927.00 210,927.00 0.00% $ 1,886,305.00 $ 1,926,888.00 $ 1,926,888.00 $ 0.00% Corporation Counsel Personnel Expenditures $ 2,288,295.00 $ 2,288,295.00 $ 2,288,295.00 $ 0.00% Operating Expenditures 87,333.00 96,833.00 96,833.00 0.00% 389,616,00 0.00% Internal Support Expenditures 385,885.00 389,616.00 $ 2,761,513.00 $ 2,774,744.00 $ 2,774,744.00 $ 0.00% Department Total Personnel Expenditures $ 6,158,166.00 $ 6,158,166.00 $ 6,158,166.00 $ 0.00% Operating Expenditures 414,576.00 $ 445,526.00 945,526.00 0.00% Internal Support Expenditures 1,019,450.00 1,047,234.00 1,047,234.00 0.00% Transfers Out $ 7,592,192.00 $ 7,650,926.00 $ 7,650,926.00 $ 0.00% 62
ADOPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT FY 2017 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Equalization Personnel Expenditures $ 225,527.00 $ 225,527.00 $ 225,527.00 $ 4,017.00 4,017.00 4,017.00 14,997.00 14,997.00 14,997.00 $ 244,541.00 $ 244,541.00 $ 244,541.00 $ $ 8,462,699.00 $ 8,462,699.00 $ 8,062,699.00 $ 0.00% 0.00% 0.00% 0.00% 400,000.00 4.73% Fay. due to vacancies and underfilled positions. Operating Expenditures Internal Support Expenditures Fiscal Services Personnel Expenditures Operating Expenditures 60,000.00 13.91% Fav. Professional Services $20,000, Personal Mileage $20,000, Printing $20,000 due to less than anticipated use. 0.00% $9,812,127.00 $9,908,515.00 $ 9,448,515.00 $ 460,000.00 4.64% 650,000.00 8.00% Fav. due to vacancies and underfilled positions. 35,000.00 8.94% Fav. Metered Postage $15,000, Printing $10,000, Office Supplies $5,000, and Filing Fees $5,000 due to less than anticipated use. 431,404.00 431,404.00 371,404.00 918,024.00 1,014,412.00 1,014,412.00 $ 8,124,132.00 $ 8,124,132.00 $ 7,474,132,00 $ 388,600.00 391,397.34 356,397.34 Internal Support Expenditures 1,253,714.00 1,397,827.00 1,397,827.00 0.00% $ 9,766,446.00 $ 9,913,356,34 $ 9,228,356,34 $ 685,000.00 6.91% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 16,812,358.00 $ 16,812,358.00 $ 15,762,358.00 $ 1,050,000.00 824,021.00 826,818.34 731,818.34 95,000.00 2,186,735.00 2,427,236.00 2,427,236.00 6.25% 11.49% 0.00% 0.00% $ 19,823,114.00 $ 20,066,412.34 $ 18,921,412.34 $ 1,145,000.00 5.71% 63
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES CENTRAL SERVICES AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administrative Personnel Expenditures $ 225,444.00 $ 225,444.00 $ 225,444.00 $ 0.00% Operating Expenditures 3,298.00 3,298.00 3,298.00 0.00% Internal Support Expenditures 14,295.00 14,295.00 14,295.00 0.00% Transfers Out $ 243,037.00 $ 243,037.00 $ 243,037.00 $ 0.00% Support Services Personnel Expenditures $ 1,223,085.00 $ 1,223,085.00 $ 1,223,085.00 $ 0.00% Operating Expenditures 372,695.00 401,695.00 401,695.00 0.00% Internal Support Expenditures 755,809.00 762,578.00 5 762,578.00 0.00% Transfers Out 0.00% $ 2,351,589.00 $ 2,387,358.00 $ 2,387,358.00 $ 0.00% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 1,448,529.00 $ 375,993.00 770,104.00 1,448,529.00 $ 1,448,529.00 5 404,993.00 404,993.00 776,873.00 776,873.00 0.00% 0.00% 0.00% 0.00% $ 2,594,626.00 $ 2,630,395.00 5 2,630,395.00 $ 0.00% 64
Facili-ties Engineering Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 828,821.00 $ 828,821.00 $ 828,821.00 $ 168,682.00 168,682.00 168,682.00 54,224.00 54,283.00 54,283.00 $1,051,727.00 $ 1,051,786.00 $ 1,051,786.00 $ 0.00% 0.00% 0.00% 0.00% COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES FACILITIES MANAGEMENT ADOPTED AMENDED BUDGET BUDGET FY 2017 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 0.00% 0.00% 0.00% 0.001/4 $ 208,485.00 $ 208,485.00 $ 208,485.00 $ 5,764.00 5,764.00 5,764.00 16,290.00 16,290.00 16,290.00 $ 230,539.110 $ 230,539.00 $ 230,539.00 $ Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Department Total Personnel Expenditures $ 1,037,306.00 $1,037,306.00 $ 1,037,306.00 $ 0.00% Operating Expenditures 174,446.00 174,446.00 174,446.00 0.00% Internal Support Expenditures 70,514.00 70,573.00 70,573.00 0.00% $ 1,282,266.00 $ 1,282,325.00 $ 1,282,325.00 $ 0.00% 65
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES HUMAN RESOURCES AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Workforce Management Personnel Expenditures Operating Expenditures Internal Support Expenditures Benefits Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures 774,116.00 $ 337,622.00 37,914.00 1,149,652.00 $ 1,860,382.00 $ 390,612.00 647,635.00 2,898,629,00 $ 176,926.00 $ 13,977.00 774,116.00 $ 503,422.00 41,117.00 1,860,382.00 $ 390,612.00 699,977.00 2,950,971.00 $ 176,926.00 $ 13,977.00 2,811,424.00 $ 908,011.00 904,378.00 4,623,813.00 $ 759,116.00 $ 503,422.00 41,117.00 1,825,382.00 $ 390,612.00 699,977.00 2,915,971.00 $ 176,926.00 $ 13,977.00 163,284.00 2,761,424.00 $ 908,011.00 904,378.00 4,573,813.00 $ 15,000.00 1.94% Fay. due to turnover and underfilled positions. 0.00% 0.00% 35,000.00 1.88% Fay. due to turnover and underfilled positions. 0.00% 0.00% 35,000.00 1.19% 0.00% 0.00% 0.00% 0.00% 50,000.00 1.78% 0.00% 0.00% 50,000.00 1.08% Department Total Personnel Expenditures 2,811,424.00 $ Operating Expenditures 742,211.00 Internal Support Expenditures 848,833.00 Transfers Out 4,402,468.00 $ 163,284,00 163,284.00 354,187.00 $ 354,187.00 $ 1,318,655.00 $ 1,303,655.00 $ 15,000.00 1.14% --------- 354,187.00 $ 66
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST {UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 209,063.00 $ 209,063.00 $ 209,063.00 $ 0.00% Operating Expenditures 8,389,499.00 8,013,143.00 6,138,143.00 1,875,000.00 23.40% Fay. due to Private Institutions $1,100,000 and Private Institutions Foster Care $500,000. Fay. Foster Boarding Homes $275,000. Costs are based on caseload, difficulty of care, and treatment of services ordered by the Court. Favorability is partially offset by unfav. Non-Dept. Child Care Subsidy Revenue (50% reimbursement). Internal Support Expenditures 12,571.00 12,571.00 12,571.00 0.00% Transfers Out $ 8,611,133.00 $ 8,234,777.00 $ 6,359,777.00 $ 1,875,000.00 22.77% Health Personnel Expenditures $ 25,563,772.00 $ 25,563,772.00 $ 23,313,772.00 $ 2,250,000.00 8.80% Fay. due to turnover and undertilled positions. 3,363,684,00 100,269.00 2,867,716.00 Operating Expenditures Internal Support Expenditures Transfers Out 3,433,147.96 3,332,878.96 3,026,960.00 3,001,960.00 2.92% Fay. Professional Services $200,000 due to changes in coverage under the Affordable Care Act. Partially offset by unfav. Laboratory Supplies ($50,000) due to increased cost for supplies. Unfav. Adj Prior Years Revenue ($49,731) due to correction for FY 2016 estimated administrative overhead cost distribution. 25,000.00 0.83% Fay, Info Tech Operations $15,000 and Telephone Communications $10,000 based on usage. $ 31,795,172.00 $32,023,879.96 $ 29,648,610.96 $ 2,375,269.00 7.42% 67
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Children's Village Personnel Expenditures $ 16,776,215.00 5 17,161,071.00 $ 17,161,071.00 5 0.00% Operating Expenditures 3,693,861.00 3,749,981.11 3,714,981.11 35,000.00 0.93% Fav. Medical Services Physicians $35,000 due to services provided by Oakland Integrated Healthcare Network (OIHN) a Federally Qualified Health Center. Internal Support Expenditures 2,728,667.00 2,768,732.00 2,768,732.00 0.00% Transfers Out $ 23,198,743.00 $ 23,679,784.11 $ 23,644,784.11 5 35,000.00 0.15% Homeland Security Personnel Expenditures 5 852,675.00 $ 852,675,00 $ 852,675.00 $ 0.00% Operating Expenditures 304,866.00 304,866.00 289,866.00 15,000.00 4.92% Fay. Equipment Maintenance $15,000 due to limited normal, regular maintenance costs plus unforeseen major repairs incurred on specialty/hazmat vehicles. Internal Support Expenditures 532,046.00 542,624.00 542,624.00 0.00% Transfers Out $ 1,689,587.00 5 1,700,165.00 5 1,685,165.00 $ 15,000.00 Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 43,401,725.00 $ 43,786,581.00 $ 41,536,581.00 5 15,751,910.00 15,501,138.07 13,475,869.07 6,141,000.00 6,350,887.00 6,325,887.00 2,250,000.00 2,025,269.00 25,000.00 5.14% 13.07% 0.39% 0.00% $ 65,294,635.00 $ 65,638,606.07 $ 61,338,337.07 $ 4,300,269.00 6.55% 68
ADOPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT FY 2017 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Public Services -Admin. Personnel Expenditures $ 225,492.00 $ 225,492.00 225,492.00 $ 0.00% Operating Expenditures 4,800.00 4,800.00 4,800.00 0.00% Internal Support Expenditures 7,039.00 7,039.00 7,039.00 0.00% Community Corrections Personnel Expenditures $ 237,331.00 $ 237,331.00 $ 237,331.00 $ $ 1,641,689.00 $ 1,641,689.00 1,641,689.00 $ 190,912.00 190,912.00 190,912.00 202,229.00 203,754.00 203,754.00 $ 2,034,830.00 $ 2,036,355.00 $ 2,036,355.00 $ $ 3,983,111.00 $ 3,983,111.00 3,983,111.00 $ 502,025.00 502,025.00 502,025.00 522,899.00 543,818.00 543,818.00 $ 5,008,035.00 $ 5,028,954.00 $ 5,028,954.00 $ Veterans' Services Personnel Expenditures Operating Expenditures Internal Support Expenditures Operating Expenditures Internal Support Expenditures 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% MSU Ext. - Oakland County Personnel Expenditures $ 666,407.00 $ 666,407.00 $ 586,407.00 $ 80,000.00 12.00% Fav. due to vacant and underlined positions. Operating Expenditures 227,239.00 227,239.00 227,239.00 0.00% Internal Support Expenditures 286,148.00 288,293.00 288,293.00 0.00% $ 1,179,794.00 $ 1,181,939.00 $ 1,101,939.00 $ 80,000.00 6.77% 69
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Medical Examiner Personnel Expenditures $ 3,421,087.00 $ 3,421,087.00 $ 3,271,087.00 $ 150,000.00 4.38% Fay. due to vacant and under filled positions. Operating Expenditures 600,006.00 631,059.00 671,059.00 (40,000.00) -6.34% Unfav. Transportation Service ($20,000), Laboratory Fees ($10,000), Laboratory Supplies ($8,000), Laundry and Cleaning ($2,000) due to higher number of cases driving increased use. Internal Support Expenditures 812,143.00 823,278.00 823,278.00 0.00% $ 4,833,236.00 $ 4,875,424.00 $ 4,765,424.00 $ 110,000.00 2.26% Animal Control Personnel Expenditures $ 2,444,619.00 $ 2,444,619.00 $ 2,394,619.00 $ 50,000.00 2.05% Fay_ due to vacant and underlined positions. Operating Expenditures 280,097.00 280,097.00 280,097.00 0.00% Internal Support Expenditures 862,554.00 915,043.00 915,043.00 0.00% Transfers Out $ 3,587,270.00 $ 3,639,759_00 $ 3,589,759.00 $ 50,000.00 1.37% Circuit Court Probation Personnel Expenditures - $ $ - $ 0.00% Operating Expenditures 54,326.00 54,326.00 54,326.00 - 0.00% Internal Support Expenditures 569,207.00 571,292.00 571,292.00 0.00% $ 623,533.00 $ 625,618,00 $ 625,618.00 $ 0.00% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 12,382,405.00 1,859,405.00 3,262,219.00 $ 12,382,405.00 $ 1,890,458.00 3,352,517.00 12,102,405.00 $ 280,000.00 1,930,458.00 (40,000.00) 3,352,517.00 2.26% -2.12% 0.00% $ 17,504,029.00 $ 17,625,380.00 $ 17,385,380.00 $ 240,000.00 1.36% 70
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST :UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 1,322,000.00 $ 1,322,000.00 $ 1,322,000.00 $ 0.00% Operating Expenditures Internal Support Expenditures Transfers 442,222.00 442,222.00 158,422.00 65,089.00 90,238.00 85,238.00 283,800.00 64.18% Fay. Professional Services $228,800 due to reduction of contractual services; Printing $22,100, Travel $17,500, Supplies $8,700 and Mileage $6,700 due to usage. 5,000.00 5.54% Fav.Info Tech Operaions due to less than anticipated usage. -------------------- $ 1,829,311.00 $ 1,854,460.00 $ 1,565,660.00 $ 288,800.00 15.57% Planning and Economic Development Services Personnel Expenditures $ 4,077,694.00 $ 4,077,694.00 $ 3,711,794.00 $ 365,900.00 8.97% Fay. due to turnover and undertilled positions. Operating Expenditures 1,376,353.00 1,567,434.00 1,266,934.00 300,500.00 19.17% Fay. Workshops and Meetings $151,900, Printing $41,400, Supplies $28,100, Travel $9,900 and Mileage $4,200 due to usage; Software Maintenance $64,300 due to decreased maintenance and Charge Card Fee $700 for credit card activity. Internal Support Expenditures Transfers 832,833.00 834,388.00 841,188.00 (6,800.00) -0.81% Unfav Insurance Fund ($21,500) due to usage offset by fav.Telephone Communications $9,800, Info Tech Managed Print Services $2,700 and Info Tech Operations $2,200 due to less than anticipated usage. $ 6,286,880.00 $ 6,479,516.00 $ 5,819,916.00 $ 659,600.00 10.18% 71
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST [UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 01.0.1.1.101~nn•.....••n•••nn,•n
•n•n•nn••n ...... Community and Home Improvement Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Workforce Development Personnel Expenditures $ 25,620.00 $ 25,620.00 $ 25,620.00 $ 0.00% Operating Expenditures Internal Support Expenditures Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 25,620.00 $ 25,620.00 $ 25,620.00 $ $ 5,425,314.00 $ 5,425,314.00 $ 5,059,414.00 $ 365,900.00 1,818,575.00 2,009,656.00 1,425,356.00 584,300.00 897,922.00 924,626.00 926,426.00 (1,800.00) 0.00% 6.74% 29.07% -0.19% 0.00% $ 8,141,811.00 $ 8,359,596.00 $ 7,411,196.00 $ 948,400.00 11.35% 72
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT NON-DEPARTMENTAL EXPENDITURES AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION NON-DEPARTMENT APPROPRIATIONS COUNTY OPERATIONS Insurance Fund Insurance Surety Bonds Logos Trademarks Intellect Property Road Commission1Current Drain Assessment Road Comrnissiongn Party Agreement Interest Expense Provisions Transfer to Community Mental Health Authority Total 5 367,183.00 5 367,183,00 5 367,183.00 5 33,305.00 33,305.00 33,305.00 20,000.00 20,000.00 20,000.00 1,450,000.00 1,450,000.00 1,450,000.00 100.00 1,658,363.00 1,658363.00 30,000.00 30,000.00 30,000.00 9,620,616.00 9,620,616.00 9,620,616.00 $ 11,521,204.00 5 13,179,467.00 $ 13,179,467.00 $ 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% COUNTY BUILDINGS $ 2,781,940.00 $ 2,599,226.00 $ 2,599,226.00 $ 0.00% STATE AND FEDERAL - COUNTY ASSOCIATIONS Michigan Assoc. of Counties $ 73,000.00 $ 73,000.00 $ 73,000.00 $ 0.00% National Assoc. of Counties 24,100.00 24,100.00 24,100.00 0.00% S.E.M.C.O.0. 500,000,00 500,000.00 500,000.00 0.00% Traffic Improvement Association 30,000.00 30,000,00 30,000.00 0.00% Total $ 627,100.00 $ 627,100.00 $ 627,100.00 $ 0.00% SUNDRY EXPENSE $ 300,000.00 $ 300,000.00 $ 300,000.00 $ 0.00% RESERVED FOR TRANSFERS Expenditures Classification and Rate Change Contingency Disaster Recovery Emergency Salaries Grant Match Info Tech Development Juvenile Resentencing Legislative Expense Local Road Funding Program Misc. Capital Outlay Overtime Reserve Security Reserve Substance Abuse Coord Agency Summer Employees Salary Appropriation Total $ 315,936.00 321,802.00 300,000,00 406,815.00 1,443,887.00 5,281,710.00 600,000.00 8,600.00 250,000.00 275,000.00 1,725,980.00 4,212,170.00 250,000.00 298,638.00 230,620,00 300,000.00 406,815.00 1,068,282.00 4,336,802.00 600,000.00 8,600.00 120,932.00 183,450.00 275,000.00 1,725,980.00 4,212,170.00 250,000.00 $ 298,638.00 230,620.00 300,000.00 406,815.00 1,068,282.00 4,336,802,00 600,000.00 8,600.00 120,932.00 183,450.00 275,000.00 1,725,980.00 4,212,170.00 250,000.00 0.00°k 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% $ 15,391,900.00 $ 14,017,289.00 $ 14,017,289.00 $ 73
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT NON-DEPARTMENTAL EXPENDITURES AMOUNT ADOPTED AMENDED FY 2017 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION Transfers to Other Funds Fire Records Management CLEMIS Information Technology Bldg Auth Fac Infras IT Debt Facilities Maintenance and Operations Fringe Benefit Fund Project Work Order Fund Long Term Revolving Fund Facilities Maintenance and Operations Building Fund Economic Development Corp BA Animal Ctrl Pet Adopt Debt Imaging System Project Domestic Equipment Preparedness $ 461,742.00 $ 461,742.00 $ 461,742.00 0.00% 1,844,186.00 1,844,186.00 1,844,186.00 0.00% 3,620,676,00 3,620,676.00 3,620,676.00 0.00% 2,244,250.00 2,244,250.00 2,244,250.00 0.00% 0.00% 0.00% 1,200,000.00 1,200,000.00 1,200,000.00 0.00% 0.00% 0.00% 5,500,000.00 5,500,000,00 5,500,000.00 0.00% 0.00% 0.00% 0.00% 0.00% $ 14,870,854.00 $ 14,870,854.00 $ 14,870,854.00 $ 0.00% TOTAL NON-DEPT. APPROPRIATIONS $ 45,492,998,00 $ 45,593,936.00 $ 45,593,936.00 $ 0.00% TRANSFER TO GENERAL PURPOSE FUNDS Child Care Fund Social Welfare Fund Foster Care TOTAL EXPENDITURES $ 23,442,791.00 $ 23,455,540.00 $ 23,455,540.00 $ 0,00% 1,000.00 1,000.00 1,000.00 0.00% $ 23,443,791.00 $ 23,456,540.00 $ 23,456,540.00 $ 0.00% $ 68,936,789.00 $ 69,050,476.00 $ 69,050,476.00 $ 0.00% 74
FY 2017 BUDGET AMENDMENTS FY 2017 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS BUDGET AMENDMENTS M.R. #16264 - 10106/2016 Sheriffs Office - Contract Amendment #1 Law Enforcement Services in the Charter Township of Lyon 2016 M.R. #16290 - 10126/2016 Circuit Court - 2017 Michigan Drug Court Grant Program (Adult Treatment Court) - Grant Acceptance MR. #16291 - 10126/2016 Circuit Court - 2017 Michigan Drug Court Grant Program (Juvenile Drug Court) - Grant Acceptance MR. #16298 -11/10/2016 Sheriffs Office - Contract for Police Dispatch Services for the Village of Oxford 2017 -2018 $ 444,064,379.00 $ 132,736.00 18,940.00 $ (39,235.00) 60,967.00 M.R. #16324 - 12/08/2016 Management & Budget Fiscal Year 2016 Year-End Report and Budget Amendments Encumbrances $ 123,763.15 Carry Forwards $ 3,672,683.00 $ 3,796,446.15 MR. #16331 - 12/08/2016 Human Resources Department - Fiscal Year 2017 - Fiscal Year 2018 Collective Bargaining Agreement for Employees Represented By the Oakland County Deputy Sheriffs Association (OCDSA) Law Enforcement Unit M.R. #16339 - 12/09/2016 Sheriffs Office - Standard Law Enforcement Services Agreement with the Charter Township of Commerce, January 1, 2017- December 31, 2018 $ 103,838.00 32,899.00 TOTAL AMENDED BUDGET AS OF 12/31/2016 $ 448,170,970.15 75
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT ENTERPRISE FUND TREASURER'S OFFICE ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DELINQUENT TAX REVOLVING FUND 51600 REVENUES Charges for Services $14,000,000.00 $14,000,000.00 $14,000,000.00 $0.00 0.00% Other Revenues 1,470,000,00 1,470,000.00 1,470,000.00 $0,00 0.00% Total Revenues 815,470,000.00 $15,470,000.00 $15,470,000.00 $0.00 0.00% OPERATING EXPENSES Personnel Expenditures $ 204.011.00 $ 204,011.00 $ 204,011.00 0.00% Operating Expenditures 588,555,00 588,555,00 588,555,00 0.00% Interest Expense Transfer Out to Other Funds: General Fund.- Collection Fees GE - Non-Departmental Work Release Facility Refunding Debt Svc Office Bldg Renovation Refunding Debt Svc 52-3 District Court Refunding Debt Svc Total Transfer Out to Other Funds Total Operating Expenses 223.069.00 3,048,178.00 9,000,000.00 1,582,700.00 1,877,800.00 1,310,300.00 $ 16,819,478.00 $ 17,835,113,00 223,069.00 3,048,178.00 9,000,000.00 1,582,700.00 1,877,500.00 1,310.800.00 $ 16,819,478.00 $ 17,835,113,00 223,069.00 3,048,178.00 9,000,000.00 1,582,700.00 1,877,800.00 1.310,800.00 $ 16.819,478.00 $ 17,835,113,00 0.00% 0.00% 0.00% 0.00% 0.00% 0,00% 0.00% 0.00% REVENUE OVER (UNDER) EXPENDITURES* Total Net Position - Beginning Total Net Position - Ending ($2,365,113,00) (82,365,113,00) ($2,365,113,00) $200,191,992,94 $197,826,879.94 $0,00 Ending FY 2016 Designated Net Positions.-: NP-UnRes - Designated - Debt Service NP-UnRes - Designated - Delinq Taxes Receivable NP-UnRes - Designated - Collection Fees Undesignated - Net Position Total Net Position - Ending $46,033,797.00 147,516,430.63 6,641,765.31 ($2.365,113.00) $197,626,879.94 *Please note that in the Adopted Budget (line-item book) this is budgeted as 'Planned Use of Balance' in the revenue category. **Please note the designated equity amounts are adjusted at year-end only 76
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT ENTERPRISE FUNDS TREASURER ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAW{UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DELINQUENT PERSONAL PROPERTY TAX (51800) OPERATING REVENUE $452,300.00 $452,300.00 $452,300.00 $0.00 0.00% - OPERATING EXPENSE 487,309.00 487,309.00 423,900.00 $63,409.00 13.01% - Fav. Controllable Personnel $59,200 due to vacant and part-time positions. Also, favorable Motor Pool Fuel Charges $2,500 due to less use. -181.12% ($34,259.00) ($34,259.00) NET OPERATING INCOME (LOSS) NON-OPERATING REVENUE (EXPENSE) TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS TRANSFERS OUT TOTAL NET INCOME (LOSS)* $28,400.00 $29,150.00 $63,409.00 $0.00 $63,409.00 $63,409.00 ($35,009.00) ($35,009.00) 750.00 750.00 750.00 ($34,259.00) ($34,259.00) $ 29,150.00 0.00% TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING 165,942.82 $195,092.82 Please note that in the Adopted Budget (line-item book) this is budgeted as 'Planned Use of Balance" in the revenue category. 77
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT ENTERPRISE FUND PARKS & RECREATION ADOPTED AM ENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OAKLAND COUNTY PARKS & RECREATION COMMISSION (50800) OPERATING REVENUE OPERATING EXPENSE NET OPERATING INCOME (LOSS) NON-OPERATING REVENUE (EXPENSE) TOTAL INCOME BEFORE TRANSFERS TRANSFERS IN $ 9,975,555.00 $ 9,975,565.00 $ 9,975,565.00 $ $ 25,207,064.00 $ 25,207,064.00 $ 25,207,064.00 $ $ (15,231,499.00) $ (15,231,499.00) $ (15,231,499.00) $ $ 13,208,900.00 $ 13,232,505.00 $ 13,232,605.00 $ $ (2,022,599.00) $ (1,998,894.00) 6 (1,998,894.00) $ 0.00% A FY2017 budget amendment is proposed to bring the adopted budget in-line with activity trends observed in the 3rd and 4th quarters of FY2016. Amended accounts include Salaries and Fringe Benefits, Natural Gas, Entrance Fees Gen Admission, Indirect Cost, Facilities Maintenance transfer, and Deprecation. Amendment also includes a one-time recognition of Local Comm Stabilization Share of $271,123 from the State of Michigan for personal property tax loss reimbursement. 0.00% 0.00% 0.00% 0.00% TOTAL NET INCOME/PLANNED USE OF BALANCE (LOSS) $ (2,022,599,00) $ (1,998,894,00) $ (1,998,894.00) $ TOTAL NET POSITION - BEGINNING $ 93,203,817.64 TOTAL NET POSITION - ENDING $ 91,204,923.64 78
42,901,850.00 42,901,850.00 40,909,550.00 1,992,300.00 4.64% Fay - Salaries $1,200,000 and Fringes $800,000 due to turnover and vacant positions. Fay - Indirect Cost $50,000 due to a roll forward credit reducing the expense. Fay - Depreciation Buildings $12,000 due to over estimated depreciation schedule. Unfav - Maintenance Contract (835,000) for the Supervisory Control and Data Acquisition (SCADA) system maintenance contract charges; budget will be updated with FY 2018-FY 2020 County Executive Recommended Budget Unfav Info Tech Development ($33,000) a result of more than anticipated maintenance performed on the Automatic Meter Reading System. 0.90% (659,584.00) (859,684.00) (7,700.00) (867,384.00) 821,583.00 821,583.00 840,683.00 19,100.00 2.32% Fay - Income from Investment $17,000 the result of fund earning a return due to an improved cash balance. Fay - Interest Expense $2,000 a result of the decreasing principal balance and decrease in variable interest rate related to the Drain Equipment Storage Building, NON-OPERATING REVENUE/(EXPENSE) OPERATING EXPENSES NET INCOME (LOSS) BEFORE COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT INTERNAL SERVICE FUND WATER RESOURCES COMMISSIONER ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAV/{UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DRAIN EQUIPMENT FUND ( 63900) OPERATING REVENUES; Inside $41,881,166.00 641,881,166.00 $39,881,166.00 ($2,000,000.00) -4.78% Unfav - Reimbursement Salaries ($2,000,000) due to unallocated payroll charges for turnover and vacant positions offset in Salaries and Fringes. Outsfde 161,000.00 161,000.00 161,000.00 $0.00 0.00% Total Revenue 42,042,166.00 42,042,166.00 40,042,166.00 (2,000,000,00) -4.76% 79
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT INTERNAL SERVICE FUND WATER RESOURCES COMMISSIONER ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAW(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES TRANSFER IN 0.00% TRANSFERS (OUT) 0.00% NET REVENUES OVER (UNDER) ($38,101.00) ($38,101.00) ($26,701.00) $11,400.00 EXPENSES TOTAL NET POSITION - BEGINNING 16,107,614.30 TOTAL NET POSITION - ENDING $15,080,913.30 80
CLAIMS PAID TOTAL OPERATING EXPENSES OPERATING INCOME (LOSS) 1,178,895.00 $ 4,772,269.00 $ 4,772,269.00 8 4,772,269.00 $ (1,138,701.00) (1,138,701.00) (1,138,701.00) 1,178,895.00 0.00% 1,178,896.00 0.00% 0,00% COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT INTERNAL SERVICE FUND RISK MANAGEMENT ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 'LIABILITY INSURANCE FUND 67700 OPERATING REVENUES: Outside Revenue $ 10,397.00 $ 10,397.00 $ 10,397.00 $ Inside Revenue 3,623,171.00 3,623,171.00 3,623,171.00 0.00% Total Operating Revenue $ 3,633,588.00 $ 3,633,568.00 8 3,633,568.00 $ 0.00% OPERATING EXPENSE $ 3,593,374.00 8 3,593,374.00 $ 3,593,374.00 $ 0.00% - NON-OPERATING REVENUE (EXPENSE) 150,000.00 160,000.00 150,000.00 0.00% NET REVENUES OVERAUNDER) EXPENSES $ (988.701.00) $ (988,701.00) (988,701.00) $ TOTAL NET POSITION - BEGINNING 6,431,731.14 TOTAL NET POSITION - ENDING 5,443,030.14 81
3,046,000.00 3,046,000.00 3,267,400.00 3,417,400.00 0.00% 0.00% 0.00% 0.00% 0.00% 0.00°A 0.00% 0.00% 0.00% 0.00% 82 AMENDED BUDGET FY 2017 VARIANCE FORECAST FAV/IUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 34,001,200.00 26,001,200,00 (6,000,000.00) -23.53% - Unfavorable due to reduction of retirement rate effective with the pay period beginning February 4, 2017 in an effort to reduce the equity position of the Fringe Benefit Fund. A budget amendment is recommended to reflect the rate reduction for all departments. 3,045,800.00 3,175,800.00 130,000.00 4.27% - Favorable due to projected revenue more than budget projections. 200,000.00 200,000.00 0.00% 1,400,000.00 1,834,500.00 434,500.00 31.04% - Favorable due to projected revenue more than budget projections. 17,280,000,00 205,000.00 1,172,700.00 296,700.00 996,000.00 100,000.00 615,200.00 99,200.00 460,000.00 2,929,000.00 450,000.00 16,300,000.00 17,280,000.00 205,000.00 1,172,700.00 296,700.00 995,000.00 100,000.00 615,200.00 99,200.00 460,000.00 2,929,000.00 450,000.00 16,500,000.00 200,000.00 33,952,500.00 34,952,500.00 1,000,000.00 9,921,000.00 10,421,000.00 500,000,00 3,174,000.00 3,674,000.00 500,000.00 190,500.00 350,500.00 160,000.00 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0,00% 0.00% 1.23% - Favorable due to projected revenue more than budget projections - an increase in new hires. Offset by unfavorable related expense. 2.95% - Favorable due to projected revenue more than budget projections. 5.04% - Favorable due to projected revenue more than budget projections. 15.75% - Favorable gusto projected revenue more than budget projections. 83.99% - Favorable due to projected revenue more than budget projections. 0.00% 150,000.00 4.59% - Favorable due to projected revenue more than budget projections. 500,000.00 305,300.00 5,200,000,00 180,000.00 850,000.00 16,000.00 1,500.00 400,000,00 115,000.00 118,000.00 500,000.00 305,300.00 5,200,000.00 180,000.00 850,000.00 16,000.00 1,500.00 400,000.00 115,000.00 118,000.00 COUNTY OF OAKLAND FY2017 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND FRINGE BENEFITS FUND 67800 OPERATING REVENUE RETIREES MEDICAL - VEBA DEBT RETIREMENT ADMINISTRATION RETIREMENT ADMINISTRATION - PINE DEFERRED COMPENSAT1ON-MATCH DEFINED CONTRIBUTION PLAN DEFINED CONTRIBUTION PLAN - PTNE EMPLOYEE IN-SERVICE TRAINING EMPLOYEE RECOGNITION EMPLOYEE BENEFITS UNIT FLEX BENEFIT PLAN WELLNESS UNIT FRINGE BENEFITS TUITION REIMBURSEMENT RETIREMENT HEALTH SAVINGS GROUP LIFE INSURANCE SOCIAL SECURITY MEDICAL INSURANCE PRESCRIPTION COVERAGE INSURANCE DENTAL INSURANCE VISION INSURANCE DISABILITY INSURANCE WORKERS COMPENSATION UNEMPLOYMENT COMPENSATION INVESTMENT INCOME EXT - FLEX BEN MEDICAL - EMPLOYEE EXT - MEDICAL INSURANCE EXT - PRESCRIPTION DRUG REBATES EXT - DENTAL INSURANCE EXT - VISION INSURANCE EXT - FLEX BEN LIFE INSURANCE EXT - FLEX BEN DENTAL INSURANCE EXT - FLEX BEN VISION INSURANCE ADOPTED BUDGET 34,001,200.00 3,045,800.00 200,000.00 1,400,000.00 17,280,000.00 205,000.00 1,172,700.00 296,700.00 999,000.00 100,000.00 815,200.00 99,200.00 460,000.00 2,929,000.00 450,000.00 16,300,000.00 33,952,500.00 9,921,000.00 3,174,000.00 190,500.00 3,046,000.00 3,287,400.00 500,000.00 305,300.00 5,200,000.00 180,000.00 850,000.00 16,000.00 1,500.00 400,000.00 115,000.00 118,000.00
CHILD CARE FACILITY HEALTH INSURANCE PREMIUM TAX REINSURANCE FEES MICHIGAN HICAA TAX PATIENT CENTERED OUTCOME RESEARCH INDIRECT COSTS 215,300.00 78,000.00 241,000.00 385,000.00 18,500.00 100,000.00 215,300.00 78,000.00 241,000.00 385,000.00 18,500.00 100,000.00 COUNTY OF OAKLAND FY2017 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND ADOPTED AMENDED FY 2017 VARIANCE FRINGE BENEFITS FUND 67800 BUDGET BUDGET FORECAST FAVRUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES EXT - FORFEITURE OF DEPOSIT 8, DC PLAN 150,000.00 150,000,00 0,00% - Favorable due to forfeiture of non-vested International City Management Association (ICMA) accounts. EXT -TRAINING - - 2,500.00 2.500.00 0.00% EXT - OTHER REVENUE - ICMA REBATES 10,000.00 10,000.00 10,000.00 - 0.00% TOTAL REVENUE 140,798,000.00 140,798,000.00 136,025,000.00 (4,773,000.00) -3.39% OPERATING EXPENSE RETIREES MEDICAL - VEBA DEBT PRINC. RETIREES MEDICAL - VEGA DEBT INT/AGING RETIREMENT ADMINISTRATION DEFERRED COMP-COUNTY PMTS (MATCH) DEFINED CONTRIBUTION PLAN 23,020,000.00 10,981,200.00 3,245,800.00 1,400,000.00 17,280,000.00 23,020,000.00 10,981,200,00 3,245,800.00 1,834,500.00 17,280,000.00 23,020,000.00 10,981,200.00 3,245,800,00 1,634,500.00 17,960,000.00 (680,000.00) 0.00% 0.00% 0.00% 0.00% -3.94% - Unfavorable due to projected costs more than budget projections - increase of new hires who participate in the Defined Contribution Plan. DEFINED CONTRIBUTION PLAN - PINE EMPLOYEE IN-SERVICE TRAINING EMPLOYEE IN-SERVICE TRAINING - OTHER E IN-SERVICE TRAINING - INFO TECH EMPLOYEE BENEFITS UNIT FLEXIBLE BENEFIT PAYMENTS WELLNESS PROGRAM EMPLOYEE RECOGNITION ACCOUNTING SERVICES TUITION REIMBURSEMENT RETIREMENT HEALTH SAVINGS GROUP LIFE INSURANCE SOCIAL SECURITY 205,000.00 560,700.00 262,000.00 350,000.00 996,000.00 100,000.00 615,200.00 296,700.00 99,200.00 460,000.00 2,929,000.00 850,000.00 16,300,000.00 205,000,00 560,700.00 262,000.00 350,000,00 996,000.00 100,000.00 615,200.00 296,700.00 99,200.00 460,000.00 2,929,000.00 850,000.00 16,300,000.00 205,000.00 560,700.00 262,000.00 350,000.00 996,000.00 100,000.00 615,200.00 296,700.00 99,200.00 460,000.00 2,929,000.00 850,000.00 16,500,000.00 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% (200,000.00) -1.23% - Unfavorable due to projected costs more than budget projections - increase in new hires. Offset by favorable revenue. MEDICAL INSURANCE PRESCRIPTION COVERAGE DENTAL INSURANCE VISION INSURANCE DISABILITY INSURANCE WORKERS COMPENSATION UNEMPLOYMENT COMPENSATION 38,715,000.00 10,691,000.00 3,280,000.00 310,000.00 3,046,000.00 3,267,400.00 500,000.00 38,715,000.00 38,715,000.00 10,691,000.00 10,691,000.00 3,280,000.00 3,260,000.00 310,000.00 310,000.00 3,046,000.00 3,046,000.00 3,267,400.00 3,267,400.00 500,000.00 400,000.00 100,000.00 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 20.00% - Favorable due to projected costs less than budget projections. 215,300.00 0.00% 78,000.00 0.00% 241,000.00 - 0.00% 385,000,00 - 0,00% 18,500.00 - 0.00% 54,600.00 45,400.00 45.40% - Favorable due to actual charges developed after budget finalization. TOTAL EXPENSE 140,798,000.00 141,232,500.00 141,967,100.00 (734,600.00) -0.52% NET REVENUE OVER/(UNDER) EXPENSES (434.500.00) (5,942,100.00) (5,507,600,00) 83
COUNTY OF OAKLAND FY2017 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND ADOPTED AMENDED FY 2017 VARIANCE FRINGE BENEFITS FUND 67800 BUDGET BUDGET FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES TOTAL NET POSITION - BEGINNING' TOTAL NET POSITION - ENDING 63,961,377.76 58,019,27716 'Adjusted for FY 2016 GASB #68 impact 84
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT ENTERPRISE FUNDS CENTRAL SERVICES ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAVONFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OAKLAND COUNTY INTERNATIONAL AIRPORT (56500) OPERATING REVENUE $4,415,400.00 $4,415,400.00 $4,560,400.00 $145,000.00 3.28% - Fee. Land Lease $130,000 due to higher than anticipated land leases and Car Rental Concessions $15,000 due to increased car rentals. 3.46% - Fay. Personnel $335,000 due to two under filled positions, one employee retirement, summer help and emergency salaries not used, and less than expected hospitalization and retirement costs; Unfav. Professional Service ($41,000) due to ashpalt repairs on runway at Oakland/Southwest Airport, Depreciation Land Improvement ($38,000) due to the timing of a land improvement project, and Indirect Costs ($22,300) due to actual charges being developed after budget finalization. -16.12% 0.00% 0.00% OPERATING EXPENSE 6,765,378.00 6,765,378.00 6,531,578.00 233,800.00 NET OPERATING INCOME (LOSS) ($2,349,978.00) ($2,349,978.00) ($1,971,178.00) NON-OPERATING REVENUE (EXPENSE) 245,000.00 245,000.00 245,000.00 TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS ($2,104,978.00) ($2,104,978.00) $ (1,726,178.00) TRANSFERS IN CAPITAL CONTRIBUTION 0.00 0.00 0.00 8378,500.00 0.00 $378,800.00 $0.00 TOTAL NET INCOME (LOSS) ($2,104,978.00) ($2,104,978.00) ($1,726,178.00) $378,800.00 TOTAL NET ASSETS - BEGINNING $ 77,525,805.00 TOTAL NET ASSETS - ENDING $75,799,627.00 85
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS CENTRAL SERVICES ADOPTED AMENDED FY2017 VARIANCE BUDGET BUDGET FORECAST FAVONFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES MOTOR POOL FUND 66100 OPERATING REVENUE: Outside Revenue 112,000.00 $ 112,000.00 $ 112,000.00 $ 0.00% - 8,262,811.00 $ 45,000.00 $ 8,266,424.00 $ 8,329,811.00 $ 8,374,811.00 $ 45,000.00 $ (720,517.00) $ (698,628,00) $ (681,728.00) $ 16,900.00 Inside Revenue Total Revenue OPERATING EXPENSE OPERATING INCOME (LOSS) 8,154,424.00 8,217,811.00 8,986,941.00 9,028,439.00 0.55% - Fay. Leased Equipment $45,000 due to fleet expansion for Water Resources Commissioner and Sheriff Office, and vehicles from the old rate plan being retired and replaced with vehicles on the new rate plan. 9,056,539.00 $ (28,100.00) -0.31% - Unfav. Tires and Tubes ($50,000) due to increased cost of tires, Indirect Costs ($26,100) due to actual charges being developed after budget finalization; Fay. Insurance $48,000 due to actual premiums less than expected based on insurance market fluctuations and rates. NON-OPERATING REVENUE 385,000.00 385,001/00 385,000.00 $ 0,00% (EXPENSE) NET INCOME (LOSS) BEFORE OPERATING TRANSFERS $ (335,517.00) $ (313,628.00) $ (296,728.00) $ 16,900.00 TRANSFERS IN / (OUT) 24,563.00 142,447.00 142,447.00 $ NET REVENUE OVER/(UNDER) EXPENSES (PLANNED USE OF FUND BAL.)* $ (310,954.00) $ (171,181.00) $ (154,281,00) 16,900.00 TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING $ 9,248,969.25 $ 9,094,688,25 86
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT INTERNAL SERVICE FUND FACILITIES MANAGEMENT ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET ACTUAL FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES FACILITIES MAINTENANCE & OPERATIONS (#63100) OPERATING REVENUES: Outside Revenue 464,073.00 $ 464,073.00 $ 539,073.00 $ 75.000.00 16.16% - Fay. External - Other Revenue primarily due to more than anticipated Outside Agencies Maintenance Charges for Oakland County Community Mental Health Authority (OCCMHA). Inside Revenue 25,547,867.00 25,547,867.00 25,547,867.00 0.00% NET INCOME (LOSS) BEFORE OPERATING TRANSFERS $ 26,011,940.00 $26,011,940.00 $26,086,940.00 $ 75,000.00 0.29% $ 27,958,969.00 $27,958,969.00 $26,544,469.00 $ 1,414.500.00 5.06% -Fay. Salaries and Fringe Benefits $600,000 due to underfilledivacent positions; Sublet Repairs $500,000 due to more efficient management of building maintenance; Natural Gas $275,000 due to purchasing natural gas from third party sources, mild weather conditions and lower market prices; Electrical Service $200,000 due to lower-cost third-party contracts and savings from FM&O energy conservation initiatives; Security Supplies $75,000 due to the use of alternative sources of funding (security enhancement); Water & Sewage Charges $50,000 based on actual usage. Partially offset by unfav. IT Development ($125,000) due to Collaborative Asset Management System (CAMS) mobile upgrade, infrastructure, GIS, and building management system; IT Operations ($75,000) due to AutoCAD and Kronos software maintenance; Adj Prior Years Exp ($60,500) due to adjustment of sewage charges and Small Tools ($25,000) due to irrigation projects. $ (1,947,029.00) $ (1,947,029.00) $ (457,529.00) $ 1,489,500.00 Total Revenue OPERATING EXPENSES NON-OPERATING REVENUE 100,000.00 $ 100,000.00 $ 100,000.00 $ 0.00% TRANSFERS IN $ $ - $ 0.00% TRANSFERS OUT (24,563.00) $ (24,563.00) $ (24,563.00) $ 0.00% NET REVENUES OVER(UNDER) EXPENSES* $ (1,871,592.00) $ (1,871,592.00) $ (382.092.00) $ 1.489,500.00 TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING $ 9,808,349.70 $ 9,426,257.70 "Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category. 87
ADOPTED BUDGET AMENDED BUDGET FY 2017 FORECAST VARIANCE FAV/(UNFAV) PERCENT Information Technology - Operations (KII OPERATING REVENUES: Outside $1,794,428.00 $1,796,866.00 $2,046,666.00 $249,800.00 13.90% COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS I ENTERPRISE FUND INFORMATION TECHNOLOGY EXPLANATION OF SIGNIFICANT VARIANCES Fav. Enhanced Access Fees $392,400 and Deferred Land File Tax $6,500 due to higher than anticipated usage. Offset by unfavorable Outside Agencies ($139,600) and Reimb Equalization Services ($4,600) due to reduction in external customer requests; Sale of Equipment ($4,700) due to less than anticipated use. Inside 24,857,948,00 24,860,631.00 24,120,131.00 (740,500.00) -2.98% Unfav. OC Depts Development Support & Non Governmental Development ($608,200) and OC Depts Operations & Non Governmental Operations ($140,400) due to rates remaining at prior year levels and limited resources available to complete development due to vacancies. Offset by favorable CLEM'S Operations $8,100 due to actuals higher than anticipated. TOTAL OPERATING REVENUE $26,652,376.00 $26,557,497.00 $26,166,797.00 ($490,700,00) -1.84% OPERATING EXPENSES $36,391,110.00 $36,393,793.00 $35,388,793.00 $1,005,000.00 2.76% - Fay. Salaries & Fringes $1,953,800 due to vacant positions; Expendable Equipment $531,800 for equipment replacement: Printing $81,700 due to anticipated usage; Indirect Cost $22,600 due to actual charges being developed after budget finalization and Equipment Maintenance $5,700 due to lower than anticipated hardware maintenance costs. Offset by unfav. Software Maintenance ($811,000) due to timing of software support; Professional Services ($717,400) for previously approved IT projects and Charge Card Fees ($42,000) for increased credit card activity. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS ($9,738,734.00) ($9,736,296.00) ($9,221,995.00) $514,300.00 NON-OPERATING REVENUE 105,500.00 105,500.00 106,700.00 1,200.00 1.14% Fav. primarily due to Interest Income; higher cash balance than anticipated. TRANSFERS IN 3,906,678.00 3,929,374.00 3,929,374.00 0.00% TRANSFERS (OUT) 0.00% CAPITAL CONTRIBUTION 325,000.00 325,000.00 2,125,000,00 1,800,000,00 0,00% Due to timing for IT projects funded by Building Authority. NET REV OVER(UNDER) EXP' ($5,401.558.00) ($5,376,422.00) ($3,060,922.00) $2,315,500.00 TOTAL NET POSITION - BEGINNING 26,406,564.94 TOTAL NET POSITION - ENDING $23,345,662.94 *Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category. 88
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS! ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2017 VARIANCE BUDGET BUDGET FORECAST FAV/{UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - Telephone Communications (67500) OPERATING REVENUES: Outside $12,000.00 $12,000.00 $12,000.00 $ 0.00% Inside 2,842,298.00 2,842,298.00 82,842,298,00 0.00% TOTAL OPERATING REVENUE $2,854,298.00 $2,854,298.00 $2,854,298.00 0.00% OPERATING EXPENSES $2,872,215.00 $2,872,215.00 82,892,515.00 ($20,300.00) -0.71% Unfav. Depreciation ($24,100) based on projected depreciation scheddes and Professional Services ($8,200) due to higher than anticipated contract rates. Offset by fay. Tower Charges $12,000 due to decreased pager usage. $12,085.00 NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN CAPITAL CONTRIBUTION TRANSFERS (OUT) NET REV OVER(UNDER) EXP* TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING ($17,917.00) ($38,217,00) ($20,300.00) 30,000,00 39,660.00 660.00 1,271,915.00 1,271,915.00 $12,083.00 81,264,358.00 $1.252,275.00 4,420,527.07 $5,684,885.07 2.20% Fay, primarily due to Interest Income; higher cash balance than anticipated. 0.00% 0.00% Due to timing for Unified Communications and Collaboration project funded by Building Authority. 9.00% ($17,917.00) 30,000.00 *Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category. 89
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS! ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET AMENDED BUDGET FY 2017 FORECAST VARIANCE FAV/{UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - CLEM'S {53600) OPERATING REVENUES: Outside $4,425,955.00 $4,425,955.00 $4,594,255,00 $168,300.00 3.80% Fay. CLEMIS Crash $78,500, Access Fees Oakland $63,200 due to updated law enforcement Full Time Equivalent count used for billing; Maintenance Contracts $8,800 due to Livescan maintenance after warranty; In-Car Terminals External $7,900 for fleet of CLEMIS agencies; CLEM'S Citation $5,200, Crime Mapping $4,100 and CLEMIS Parking $600 due to increased usage by Oakland and non-Oakland agencies. Inside 1,839,178.00 1,841,122.00 1,772,222.00 (68,900.00) -3.74% Unfav. primarily due to Service Fees based on actual billing for Computer Aided Dispatch (CAD) expense charge directly to Radio Fund. TOTAL OPERATING REVENUE $6,265,133.00 $6,267,077.00 $6,366,477.00 $99,400.00 1.59% OPERATING EXPENSES $10,945,881.00 $10,945,881.00 $10,306,981.00 $638,900.00 5.84% Fay. Salaries & Fringe Benefits $434,500 due to vacancies; Depreciation $763,500 based on projected depreciation schedules; Internal Services $204,000 primarily due to IT Development based on actual usage; Communications $148,800 due to actual costs less than anticipated; Software Maintenance $114,700 due to support internally; Rebillable Services $50,000 based on actual connectivity costs to Tier 2.5 and 3.0 agencies; Supplies $15,400 and Printing $2,000 based on actual usage. Offset by unfav. Professional Services ($954,000) due to higher than anticipated contractual costs for staffing services; Equipment Maintenance ($100,000) due to cost of repairs; Bank Charges ($29,600) due to cost of PayPal services for E-Commerce transactions; Indirect Cost ($6,900) due to charges determined after finalization of the budget and Travel ($3,500) due to usage. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS ($4,680,748,00) ($4,678,804.00) ($3,940,504.00) $738,300.00 NON-OPERATING REVENUE 35,000,00 35,000.00 121,200.00 86,200.00 246.29% Fay, primarily due to Interest Income; higher cash balance than anticipated. TRANSFERS IN 1,844,186.00 1,844,186,00 1,844,186,00 0.00% TRANSFERS (OUT) 0.00% CAPITAL CONTRIBUTION 0.03 0.00 0.00 0.00% NET REV OVER(UNDER) EXE* ($2,801,562.00) (62,799,618.00) ($1,975,118.00) $824,500.00 TOTAL NET POSITION - BEGINNING 17,904,957.03 TOTAL NET POSITION - ENDING $15,929,839.03 Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses. 90
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS I ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET AMENDED BUDGET FY 2917 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - Radio Communications (53600) OPERATING REVENUES: Outside $6,965,000.00 $6,965,000.00 $6,976,600.00 $11,600.00 0.17% Fey. Outside Agency Revenue $2,800 due to fewer non-emergency agencies than anticipated; Antenna Site Management $8,700 due to updates in rental contracts. Inside 470,788.00 470,788,00 611,888.00 141,100.00 29.97% Fay. Productive Labor $10,700 due to Mobile Data Computer repairs for DC Agencies; Parts Access $69,200 reimbursement by participating agencies for equipment replacement; Prior Year Adjustment $45,400 for correction of a prior period discount erroneously included in CIP and Leased Equipment $15,800 due to higher than anticipated non-public users. TOTAL OPERATING REVENUE $7,435,786.00 $7,435,788.00 $7,588,488.00 $152,700.00 2.05% OPERATING EXPENSES $14,114,896.00 $14,164,896.00 $10,667,996.00 $3,496,900.00 24.69% Fay. Depreciation $1,319,400 based on projected depreciation schedule; Software Maintenance $1,255,700 due to the timing of the Emergency Services IP Network project; Professional Services $317,200 due to project usage; Internal Services $232,500 primarily due to Info Tech GLEMIS based on usage; Salaries & Fringe Benefits $155,100 due to vacancies; Tower Charges $55,300 for tower rental agreements; Travel $86,800, Special Projects $39,000, Utilities $37,800 due to usage; Equipment Maintenance $146,100 due to maintenance costs. Partially offset by unfav. Communications ($77,000) for connectivity costs for cell tower sites used for coverage enhancements of the Radio system; Adjust Prior Year Rev ($34,500) to correct for a prior year's accrual adjustment and Indirect Cost ($16,500). NET INCOME (LOSS) BEFORE OPERATING TRANSFERS ($5,679,108.00) ($6,729,108.00) ($3,079,508.00) $3,649,600.00 NON-OPERATING REVENUE 150,000.00 180,000.00 183,300.00 3,300.00 1.83% Fay, primarily due to Interest Income; higher cash balance than anticipated. TRANSFERS IN 15,600.00 15,600.00 0.00% TRANSFERS (OUT) 266,000.00 286,000.00 286,000.00 0.00% CAPITAL CONTRIBUTION 0.00% NET REV OVER(UNDER) EXP" ($6,213,108.00) ($6,247,508.00) ($2,594,608.00) $3,652,900.00 TOTAL NET POSITION - BEGINNING 38,395,729.87 TOTAL NET POSITION - ENDING $35 801 121.87 Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses. 91
COUNTY OF OAKLAND FY 2017 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS! ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET AMENDED BUDGET FY 2017 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Fire Records Management ( 53100) OPERATING REVENUES: Outside $214,665.00 $214,665.00 $205,965.00 ($8,700.00) -4.05% Unfav. primarily due to Rebilled Charges for reduction in data lines billed to the City of Novi for equipment turned in. TOTAL OPERATING REVENUES OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE ($8,700.00) -4.05% $48,900.00 6.80% $40,200.00 Fay. Communications $26,300 due to decrease in connectivity rates; Depreciation $11,300 based on projected depreciation schedule; Salaries & Fringes $7,900 due to vacancies; Expendable equipment $6,000 due to the timing of equipment purchases made by tech support for maintaining the system; Travel $3,000 due to reduction in traveling to conferences and Software Maintenance $3,800 due to decrease in maintenance costs. Offset by unfav. overall Internal Services ($9,500) primarily due to IT Development ($4,700) and IT Operations ($4,800) based on actual usage. $214,665.00 $719,350.00 ($504,685.00) $214,665.00 $719,350.00 ($504,685.00) $205,965.00 $670,450.00 ($464,485.00) 3,000.00 3,000.00 3,200.00 200.00 6.67% Fay, primarily due to Interest Income; higher cash balance than anticipated. TRANSFERS IN 461,742.00 461,742.00 461,742.00 0.00% TRANSFERS (OUT) 0.00% CAPITAL CONTRIBUTION 0.00% NET REV OVER(UNDER) EXP* ($39,943.00) ($39,943.00) $457.00 $40,400.00 TOTAL NET POSITION - BEGINNING 1,369,874.24 TOTAL NET POSITION - ENDING $1,370,331.24 *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. 92
2017 UNCOLLECTABLE HOME IMPROVEMENT LOANS HOME INVESTMENT PARTNERSHIP ACT ACCOUNTS CASE # BAL DUE 10087 $ 18,705.00 TOTAL: $18,705.00 TOTAL AMOUNT UNCO4ECTABLE: Write offs: 2/16/2017 *Client has more than one loan Total Write Iffs: 1 Grand Total Write offs: 1 93
OAKLAND COUNTY PARKS & RECREATION COMMISSION FY2017 Uncollectible Debt Write-offs October 1, 2016 - December 31, 2016 Name (Last, First) OR last four digits of credit card il Type of Debt ' Case Number of credit card) . Description of 'Revenue Owed . Budget Center Transaction Date OC.BoC Approval .Date (if>$1000) Amount Month - Written-off 8979 Credit Card 1026070988 Greens Fees/Cart RDG 10108116 n/a 44.00 10/16 0734 Credit Card 1026183405 Concession food/bev RWC 07/12/16 n/a 64_75 12/16 1952 Credit Card 1025949901 Waterpark entry fees RWP 08120116 nla 60.00 12/16 Katherine's Catering LLC Accounts Receivable n/a Utilities reimbursement LYC/WLC 09/30/16 12/8/2016 (MR t16336) 37,286_15 12/16 Total 5 37,454_90 Uncollectible NSF checks of $100 or more are referred to Oakland County Corporation Counsel. Oakland County Fiscal Services Policy: If it is determined that a receivable is uncollectible, then amounts up to $1,000 may be written off by approval of the manager of Fiscal Services. All write-offs shall be reported to the Board of Commissioners with the quarterly forecast report. Write-offs in excess of $1,000 require Board of Commissioners' approval /Authorized by: CA$DataWy DocanentsladarlCash ManagementlDebt Write-OffsSOCPR Uncollectible Debt Write-offs.xlsx FY2017-01 1/19,2017 8:10 AM 94
FRINGE BENEFIT HEALTHCARE CONTRIBUTIONS FY 2017 Uncollectible Debt Write-offs October 1, 2016 - December 31, 2016 2016 Healthcare Contributions. Uncollectible due to employee's Human Resources/Benefits 27XXX death Administration n/a $ 24.36 Jan-17 TOTAL $ 24.36 Oakland County Fiscal Services Policy: If if is determined that a receivable is uncollectible, then amounts up to $1,000 may be written off by approval of the manager of Fiscal Services. All write-offs shall be reported to the Board of Commissioners with the quarterly forecast report. Write-offs in excess of $1,000 require Board of Commissioners' approval. Authorized by: 1/4._ 'enik-f I 141//1,-- , VI Yirr- 95
COUNTY OF OAKLAND OFFICE OF THE SHERIFF MICHAEL J. BOUCHARD November 28, 2010 Laurie Van Pelt Director of Management & Budget County of Oakland - Executive Office Building 2100 Pontiac Lake Road Waterford, MI 48328-0409 RE: Approval for donation vest for K9 Dear Mrs. Van Pelt, In accordance with the Oakland County Board of Commissioners Miscellaneous Resolution # 83204, this letter is to inform you that Vested Interest in K9's {501 c(3)} has offered to donate one (1) lifesaving body armor to the Oakland County Sheriffs Office. This non-profit organization was established in 2009 to assist law enforcement agencies with this potentially lifesaving body armor for their four-legged K9 Officers. All vests are custom made in the USA by Armor Express in Central Lake, Mi. The program is open to dogs actively employed in the United States with law enforcement who are certified and at least 20 months of age. The donation to provide one (1) protective vest for the law enforcement K9 is estimated to be worth $1,050. Each vest has a five-year warranty and has an average weight of 4 pounds. This donation would allow the Sheriff Office to provide protection to one of our K9 deputies in its line of duty to the Sheriff's Office. Michael McCabe Undersheriff / Chief Deputy Oakland County Sheriff's Office 1200 N. Telegraph Road, Building 38 East Pontiac, Michigan 48341 96
OAKLAND COUNTY PARKS & RECREATION COMMISSION AGENDA WEDNESDAY, MARCH 1, 2017 AGENDA ITEM NO. FOR ADMIN'S USE PLANNING &RESOURCE DEVELOPMENT To: Chairman Fisher and Commission Members From: Daniel J. Stencil, Executive Officer Melissa Prowse, Supervisor of Planning & Resource Development Submitted: March 3, 2017 Subject: FY 2017 1st Quarter Contributions Report INTRODUCTION AND HISTORY Attached is the FY 2017 1st Quarter report for contributions received from October 1, 2016 through December 31, 2016. ATTACHMENTS FY 2017 1st Quarter Contributions Report STAFF RECOMMENDATION The staff recommends to receive and file. MOTION Consent Agenda 97
Amount 50.03 Administration Office Sub-Total Budget Center Project! Program Source ADM General Contribution Pa k Patron Eagle Scout Project - Extra Funds $58.00 , Independence Oaks Park Sub-Total- .. General Contribution RK REC _ REC General Contribution - --- General Contribution Nature Center Program Park Patron Park Patron Tuning Your Tot Contribution $60.00 $2.00 $3.00 Totals Nature Center Program Nature Center Program Nature Center Program Donation for the Construction of a New Manure Ramp General Contribution Tuning Your Tot Contribution Tuning Your Tot Contribution Tuning Your Tot Contribution Recreation Programs & Services Sub-Total': OC 4-H Horse Council Waterford Oaks Waterpark Sub-Iota $5 .00 $5.00 55.00 $17500.00 5toringtioltVgak.A000Wc0010,400tWal: Volunteer Association Contribution $500.00 $80 00 $1,500.00 $500.00 Grand Total $2438.03 REC REC REC OAKLAND COUNTY PARKS & RECREATION COMMISSION FY 2017 1st Quarter Report for Contributions (Donations) - October 1, 2016 - December 31, 2016 98
Department of Health and Human Services Oakland County Children's Village Donation Tracking : Donation Period October 2016 - December 2016 Date: Donor: Cash/Check: Items: Estimated Value: 10/1/2016 University Presbyterian Church Frozen Birthday Cakes (3) Months $495.00 10/8/2016 Grace Christian Church Food Items For Cookout $104.00 10/8/2016 Devon Larache BowFlex $300.00 10/10/2016 Waterford Public Library Yarn $50.00 10/11/2016 Sweet Dreams for Kids (15) Pillow Cases $75.00 10/17/2016 Madalyn Gareau Sweetest Day Goody Bags for Mandy's Place $50.00 10/26/2016 Joyce Mehlberg New Quilts $150.00 11/1/2016 David Mihelcich Candy $9.00 11/3/2016 William Cable Puzzles & Games $45.00 11/3/2016 Craig Wolanin 20 Piston Tickets $300.00 11/3/2016 Datsun Doctor Used Magazines For Lobby $5.00 11/7/2016 Waterford Public Library Yarn $25.00 11/7/2016 DL Sflkf Car Magazines $20.00 11/9/2016 Jennifer Gilboe Clothing, School Supplies, & Games $100.00 11/15/2016 Julie McDonald Craft Paper & Stickers $25.00 11/16/2016 Sweet Dreams for Kids (15) Pillow Cases $75.00 11/14/2016 Datsun Doctor Used Magazines For Lobby $1.00 11/16/2016 Milford Book Club New Book From Wish List $120.00 11/10/2016 Caruso, Caruso 225 Pairs of Jeans $3,500.00 11/15/2016 Cindy Harper Yarn $20.00 11/7/2016 Huntington Woods Women's League Games, Clothes, & Toiletries $275.00 11/21/2016 Roxanne DeGriselles Misc. Boy & Girls Clothes $300.00 11/22/2016 Rosemary Sawyer Books, Games, & Puzzles $5.00 11/22/2016 Ciarkston Senior Center Yarn $1.00 11/28/2016 Eviels Preschool Stocking Stuffers $10.00 11/29/2016 Karen Kalman Shirts & Belts $10.00 12/5/2016 Senior Men's Club of Birmingham Check & Cash $4,000.00 12/5/2016 Christ The Redeemer Games, Ponies, Clothes, Craft Supplies & Balls $1,300.00 12/7/2016 Lisa Andridge Check $20.00 12/7/2016 St. William Church Check $140.00 12/7/2016 St. Mary Church Check $20.00 12/7/2016 St. Rita Church Check $20.00 12/8/2016 Bloomfield Hills Country Club Misc. Christmas Gifts $150.00 99
Department of Health and Human Services Oakland County Children's Village Donation Tracking : Donation Period October 2016 - December 2016 Date: Donor: Cash/Check: Items: Estimated Value: 12/9/2016 Marcia Lonteen-Martin Misc. Toys $40.00 12/12/2016 Waterford Public Library Yarn $35.00 12/12/2016 St. Mary of the Hills Clothing, Games, Balls, Puzzles, & Gift Cards $1,200.00 12/13/2016 Christ Church Cranbrook Check $90.59 12/13/2016 Sweet Dreams for Kids (15) Pillow Cases $75.00 12/13/2016 Christ Church Cranbrook Clothes, Toys, Puzzles, Hats, & Gloves $500.00 12/14/2016 Terri Guzzy (3) Bags Travel Size Hygiene items $10.00 12/14/2016 Pam Dorris (50) Dozen Christmas Cookies $100.00 12/14/2016 Robert Church Check $100.00 12/16/2016 AGC Automotive Clothing, Coats, & Gift Cards $650.00 12/16/2016 Encinares Check (included with AGC Automotive donation) $50.00 12/16/2016 Briarina Trippensee Clothes and Toys $145.00 12/16/2016 St. Paul's UMC Toys $200.00 12/19/2016 Jane Makuch Toys, Candy, & Toiletries $300.00 12/19/2016 JC Penny Backpacks, Watches, Toys & Gift Card $300.00 12/20/2016 Rick & Jennifer Buzomowski (20) Sets of Pajamas $200.00 12/21/2016 Tammy Thompson Clothes $22.00 12/21/2016 Waterford School District Cash Administration Casual Day Funds $82.00 12/21/2016 Jesslyn Molnar Clothes $150.00 12/21/2016 Anonymous Toiletries & Toys $50.00 12/22/2016 Phi Theta Kappa Toiletries $200.00 12/22/2016 Canine Companions Rescue Center Clothing, Toys & Toiletries $500.00 12/22/2016 Lisa Harris Toiletries $100.00 12/22/2016 Love & Buttercream Clothing, Toys & Toiletries $1,500.00 12/22/2016 Breakie Bunch Clothing, Toys & Gift Cards $300.00 12/22/2016 Jon Noyes Clothing & Books $100.00 12/29/2016 Waterford Senior Center Yarn $50.00 Total: $18,769.59 100
Resolution #17043 March 15, 2017
Moved by Fleming supported by Bowman the resolutions (with fiscal notes attached) on the Consent
Agenda be adopted (with accompanying reports being accepted).
AYES: Crawford, Dwyer, Fleming, Gershenson, Gingell, Hoffman, Jackson, Kochenderfer,
KowaII, Long, McGillivray, Middleton, Quarles, Spisz, Taub, Tietz, Weipert, Woodward, Zack,
Bowman. (20)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent
Agenda were adopted (with accompanying reports being accepted).
HEREBY APPROVE THIS RESOLUTION
CHIEF DEPUTY COUNTY EXECUTIVE
ACTING PURSUANT TO rvICL 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 March 15,
2017, with the original record thereof now remaining in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the County of Oakland at
Pontiac, Michigan this l5 of March, 2017. _
Lisa Brown, Oakland County