Loading...
HomeMy WebLinkAboutResolutions - 2018.06.13 - 23642MISCELLANEOUS RESOLUTION #18236 June 13, 2018 BY: Commissioner Thomas Middleton, Chairperson, inui ° mim ittee IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2018 SECOND QUARTER FINANCIAL FORECAST AND BUDGET AMENDMENTS To the Oakland County Board of Commissioners Chairperson, Ladies and Gentlemen: WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of Government, provides for adjustments to the adopted budget; and WHEREAS in accordance with Oakland County General Appropriations Act Section 22, which authorizes budget amendments for variances between the budgeted revenue and actual revenue, and Section 23, which authorizes budget amendments for variance between estimated revenue and projected expenditures, amendments are required; and WHEREAS the Fiscal Year (FY) 2018 Second Quarter Financial Forecast Report has identified several variances and budget amendments are recommended; and WHEREAS a budget amendment is recommended to correct the Circuit Court's Family Division Transfers Out line item in the amount of $524,670 for FY2018 to reflect the required grant match total County share amount for the Friend of the Court Cooperative Reimbursement Program (CRP) grant acceptance, originally approved per Miscellaneous Resolution #17317; 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 $51,015 is being recognized for eligible personnel, forensic lab and training costs for corrections officers and dispatchers; and WHEREAS a budget amendment is recommended for Facilities Engineering in the amount of $17,000 for FY 2018 and $14,000 in FY2019 and FY 2020 due to a review of the billing for five computer workstations along with associated software; and WHEREAS a budget amendment of $1,646 is recommended for Human Resources to reallocate funds from Recruitment Expense line item to Software Rental Lease Purchase line item to more accurately account for actual activity; and WHEREAS a budget amendment of $240,000 is recommended for the Health Division to reallocate funds from Administration Fees revenue line item to Federal Operating Grants revenue line item to accurately reflect funding for Medicaid Outreach; and WHEREAS a budget amendment is recommended for Homeland Security to recognize additional funding in the amount of $7,457 to reflect Amendment #1 from the Michigan Department of State Police, Emergency Management Division. Miscellaneous Resolution (MR.) #17194 authorizes Management and Budget to administratively process grant agreements and grant amendments of $10,000 or less, after review and approval by Management and Budget, Human Resources, Risk Management and Corporation Counsel when the grant does not require an associated interlocal agreement, there are no position changes and the grantor does not require a separate resolution; and WHEREAS a budget amendment is recommended for the Veterans Services Division to accept reimbursement funding of $4,565 for continuing education costs from the Michigan Veterans Affairs Agency (MVAA). M.R. #17194 authorizes Management and Budget to administratively process grant agreements and grant amendments of $10,000 or less, after review and approval by Management and Budget, Human Resources, Risk Management and Corporation Counsel when the grant does not require an associated interlocal agreement, there are no position changes and the grantor does not require a separate resolution; and WHEREAS a budget amendment of $1,200 is recommended for the Medical Examiner to reallocate funds from the Training line item to the Workshops and Meetings line item to more accurately account for actual activity; and WHEREAS a budget amendment is recommended to transfer $19,524 from the Animal Control Legacy Fund (#21310) to the Animal Control General Fund (#10100) for the purchase and installation of a built-in kennel for a replacement van; and WHEREAS a budget amendment is recommended for the Animal Control to accept reimbursement funding of $3,315 from the Bissell Pet Foundation's Empty the Shelter event. M. R. #17194 authorizes FINANCE COMMITTEE VOTE: Motion carried unanimously on a roll call vote. Management and Budget to administratively process grant agreements and grant amendments of $10,000 or less, after review and approval by Management and Budget, Human Resources, Risk Management and Corporation Counsel when the grant does not require an associated interlocal agreement, there are no position changes and the grantor does not require a separate resolution; and WHEREAS a budget amendment in the amount of $75,000 is recommended for Economic Development & Community Affairs (EDCA) to transfer funds to Information Technology Fund for the 2018 EDCA Digital Marketing Program; and WHEREAS a budget amendment in the amount of $12,372 is recommended in Economic Development & Community Affairs for operating revenues and expenditures related to the Fire and Ice Festival; and WHEREAS a budget amendment in the amount of $12,500 is recommended for Economic Development & Community Affairs to reflect operating revenues and expenditures related to MiCareerQuest Southeast; and WHEREAS a budget amendment is recommended for the Circuit Court's Michigan Mental Health Drug Court Grant (#27175) to reallocate $5,000 from Private Institutions Residential line item in which $3,000 will be reallocated to Laboratory Supplies line item and $2,000 will be reallocated to Incentives line item to reflect Amendment #2 within fifteen percent of the FY 2018 Michigan Mental Health Court Grant Program agreement (M.R. #17304); and WHEREAS a FY 2018 budget amendment is recommended for Friend of the Court Fund (#27100) to reallocate funding in the amount of $195,742 from personnel favorability to Indirect Costs under the Cooperative Reimbursement Program (CRP) Grant which more accurately reflects the budget with actual expenditures; and WHEREAS a budget amendment is recommended for the Prosecuting Attorney to accept funding in the amount of $400 from the Prosecuting Attorneys Association of Michigan (PAAM) and Michigan Department of Health and Human Services (MDHHS) for Crime Victim Rights Week Grant Fund (#29327). M.R. #17194 authorizes Management and Budget to administratively process grant agreements and grant amendments of $10,000 or less, after review and approval by Management and Budget, Human Resources, Risk Management and Corporation Counsel when the grant does not require an associated interlocal agreement, there are no position changes and the grantor does not require a separate resolution; and WHEREAS a budget amendment totaling $15,000 is recommended for Community Corrections to reallocate $10,000 from Salaries and Fringe Benefits to Professional Services line item and reallocate $5,000 from IT Development line item to Contracted Services line item to reflect Amendment #1 for FY 2018 Community Corrections Comprehensive Plan Grant which is within fifteen percent of Original Agreement (M.R.#17338); and WHEREAS a budget amendment is recommended to accept $10,000 award from Two Seven Oh for the purchase of safety equipment for the benefit of employees and volunteers working at the Oakland County Animal Control and Pet Adoption Center. M.R. #17194 authorizes Management and Budget to administratively process grant agreements and grant amendments of $10,000 or less, after review and approval by Management and Budget, Human Resources, Risk Management and Corporation Counsel when the grant does not require an associated interlocal agreement, there are no position changes and the grantor does not require a separate resolution; and WHEREAS a budget amendment totaling $331,800 is recommended for the Health Division to reallocate funds between grant revenue line items to more accurately reflect the FY 2018 Comprehensive Planning, Budgeting, and Contracting (CPBC) Agreement (M.R. #17237); and WHEREAS a budget amendment of $77,472 is recommended for Health Division to recognize adjustments to the FY 2018 Comprehensive Planning, Budgeting, and Contracting (CPBC) Agreement to reflect Amendment #2 which is less than fifteen percent of the original agreement (M.R. #17237); and WHEREAS a budget amendment of $2,451 is recommended for Health Division to recognize adjustments to the FY 2018 Comprehensive Planning, Budgeting, and Contracting (CPBC) Agreement to reflect Amendment #3 which is less than fifteen percent of the original agreement (MR. #17237); and WHEREAS grant acceptance is recommended from the Michigan Department of Transportation to accept $2,000 in reimbursement funding for Aircraft Rescue and Fire Fighting (ARFF) training at Oakland County International Airport. A budget amendment is not required. M.R. #17194 authorizes Management and Budget to administratively process grant agreements and grant amendments of $10,000 or less, after review and approval by Management and Budget, Human Resources, Risk Management and Corporation Counsel when the grant does not require an associated interlocal agreement, there are no position changes and the grantor does not require a separate resolution; and WHEREAS grant acceptance in the amount of $189,090 is recommended for Oakland County International Airport Rehabilitate and Strengthen Taxiway C and B including Associated Connectors grant to reflect Amendment #1 which is less than fifteen percent of the original agreement (MR. #16284); no budget amendment is required; and. WHEREAS a Parks and Recreation Commission budget amendment totaling ($187,745) is recommended to reduce the operating maintenance budget for Red Oaks waterslide structure restoration project ($160,000) and trail enhancement projects at Independence Oaks and Orion Oaks ($27,745) which are to be capitalized upon completion, adjust the budget $60,240 for a Prior Years Adjustment at Red Oaks Waterpark for the waterslide restoration project, amend Contributions Operating $10,000 contribution related to the Ellis Barn acquisition agreement, and to transfer General Program Administration funds in the amount of $93,878 from the Facilities Maintenance cost center to various cost centers incurring expenses during the second quarter of FY2018; and WHEREAS grant acceptance is recommended for the Parks and Recreation Commission to accept funding of $300 with a $450 match for the 2018 Arts and Humanities Touring Grant from the Michigan Humanities Council and Michigan Council of Arts and Cultural Affairs; a budget amendment is not required. Miscellaneous Resolution (MR.) #17194 authorizes Management and Budget to administratively process grant agreements and grant amendments of $10,000 or less, after review and approval by Management and Budget, Human Resources, Risk Management and Corporation Counsel when the grant does not require an associated interlocal agreement, there are no position changes and the grantor does not require a separate resolution; and WHEREAS a Parks and Recreation Fund (#50800) correction to the fiscal note accompanying M.R. #18058 Addison Oaks and Groveland Oaks Position Deletions, Creations and Reclassifications is needed to reflect the correct amount of $14,743 (was noted as $14,473 on the miscellaneous resolution) for each park's Fees Camping revenue line item, a budget amendment is not needed; and WHEREAS a budget amendment is recommended to transfer funding in the amount of $13,912 from the Veteran's Service's Donation Fund (#21381) to the Project Work Order Fund (#40400) for the reinstallation and rededication of the World War I plaque, per Miscellaneous Resolution #15231 which allows for administrative approval of capital improvement program projects under $30,000; and WHEREAS an amendment is recommended to reverse the transfer funding from the Building Improvement Fund (#40100) in the amount of $496,800 to the Project Work Orders Fund (#40400) for the Sheriff's Administration to Resource Crisis Center Steam Tunnel Remediation Phase II project, that was approved through M.R. #18066, as the full funding will be derived from the Building Authority bond proceeds for the Facilities Infrastructure and Info Tech Projects Fund (#41423); and WHEREAS a budget amendment in the amount of $23,870,000 is recommended in the Fringe Benefit Fund (#67800). Governmental Accounting Standards Board (GASB) 75 requirements state that full Retiree Healthcare debt be recognized within the fund itself. Bonds maturing expense line item is now recognized as Current - Bonds Payable liability account 225500 on the Balance Sheet; and WHEREAS a budget amendment totaling $750,000 is recommended for Information Technology Fund (#63600) to reallocate expenses between divisions, programs and accounts for IT Security costs; and WHEREAS a budget amendment of $111,900 is recommended for Information Technology Fund (#63600) due to the timing of replacing Children's Village Case Management software with the Next Steps software originally approved by M.R. #17209; and WHEREAS a budget amendment totaling $101,253 is recommended for Information Technology Fund (#63600) to reallocate revenue between divisions and programs to accurately reflect activity; and WHEREAS a budget amendment of $54,671 is recommended for Information Technology (#63600) to reallocate expense between divisions; and WHEREAS per the General Appropriations Act and Miscellaneous Resolution #93156, a review of the carry forward appropriation has been conducted to determine if the appropriation shall continue for the remainder of the fiscal year; and WHEREAS the departments have expended the majority of their carry forward requests and the remaining balance is expected to be utilized by the end of FY 2018; and WHEREAS the Oakland County Department of Economic Development and Community Affairs has attempted to collect funds from loan recipients for the Community Development Block Grant totaling $606,485.20 and the Home Investment Partnership Act Accounts totaling $127,071.33 and recommends $733,556.53 be written off in uncollectible loans; and WHEREAS Parks and Recreation has requested a write-off in the amount of $66 for an uncollectible camping fee; and WHEREAS Prosecuting Attorney's Office received donations for the period of January 2018 through March 2018 totaling $202.28; and WHEREAS Department of Health and Human Services, Children's Village division received donations for the period of January 2018 through March 2018 totaling $17,793.05 of which $5,764.56 were cash donations; and WHEREAS Department of Public Services, Animal Shelter and Pet Adoption Center received donations for the period of January 2018 through March 2018 totaling $6,392.77; and WHEREAS Department of Public Services, Veterans Services received a donation in the amount of $3,911.60 for the reinstallation and rededication of the World War I plaque; and WHEREAS Parks and Recreation Commission received donations for the period of January 2018 through March 2018 totaling $5,030. NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2018 Second Quarter Financial Report. BE IT FURTHER RESOLVED that the uncollectible debts, as recommended by the Department of Management and Budget and detailed in the attached schedules are authorized to be written off. BE IT FURTHER RESOLVED that the donations be recognized in the Prosecuting Attorney's Office, Children's Village division, Animal Control and Pet Adoption Center, Veteran's Services and Parks and Recreation Commission. BE IT FURTHER RESOLVED that the FY 2018 — FY 2020 Budgets are amended pursuant to Schedules A and B. Chairperson, on behalf of the Finance Committee, I move the ac_ joRtion of the fo Cdmmissioner Thomas Middleton, District #4 Chairperson, Finance Committee COUNTY MICHIGAN MANAGEMENT & BUDGET OAKLAND COUNTY EXECUTIVE L. BROOKS PATTERSON Laurie Van Pelt, Director (248) 858-2163 vanpeltI©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 2018 Second Quarter Forecast DATE: June 7, 2018 FY 2018 SECOND QUARTER REPORT Attached please find the Fiscal Year (FY) 2018 Second Quarter Forecast Report. In total, Fiscal Services forecasts that the County will complete FY 2018 with an overall favorable variance of $16,918,228 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 $2,680,716 more revenue than anticipated and projected favorability in expenditures of $14,237,512. REVENUES GF/GP revenues are .56% more than budget or $2,680,716. Major variances are the result of the following events: A. TAXES — Favorable $150,000 Favorable Payment in Lieu of Taxes $150,000 in the Treasurer's Office to reflect actual revenue activity for payments from the State on Department of Natural Resources (DNR) land. B. FEDERAL GRANTS — Favorable: $130,462 Favorable Sheriff's Office $70,462 due to timing of the High Intensity Drug Trafficking Areas (HIDTA) Grant and $60,000 in the Prosecuting Attorney's Office for the Michigan Department of Health and Human Services Title IV-E Contract. C. STATE GRANTS — Unfavorable: ($787,500) Reduced state funding is primarily the result of reduced Child Care fund costs. The revenue loss is more than offset by projected reduced expenditures. Expenditures are favorable for Foster Boarding Homes and Private Institutions - Residential and Foster Care. D. CHARGES FOR SERVICES — Favorable: $2,850,500 Favorable primarily in the County Clerk's Office $1.2 million for Recording Fees and $230,000 for Deeds; Treasurer's Office $755,000 Payments Other than Anticipated due to the sale of foreclosed property and $250,000 Administration Fees; Children's Village Out County Board and Care $725,000 and County Board and Care $100,000 due to an increase in reimbursement rate from the State; also favorable $420,000 across the District Courts primarily in Ordinance Fines and Costs and State Law Costs due to collection efforts. This is partially offset by 2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 I Fax (248) 452-9172 I OakGov.com unfavorable Mortgages ($500,000) and Enhanced Access Fees ($220,000) in the County Clerk's Office due to less than anticipated activity and unfavorable Civil Mediation Payments ($100,000) in the Circuit Court due to a reduction in use of Mediation. E. OTHER REVENUES — Favorable: $326,754 Favorable primarily in the Health Division $319,700 Prior Years Revenue due to the adjustment for the FY 2017 estimated administrative overhead cost distribution for the Comprehensive Planning, Budgeting and Contracting (CPBC) grant agreement. EXPENDITURES In total, expenditures are projected to be 3.00% under budget or $14,237,512 favorable. Many departments have experienced personnel savings as the result of turnover and under-filling of positions. As the year progresses this overall net favorability may increase as departments continue to work to reduce their costs and reorganize. There are two departments projected to be unfavorable at the end of the fiscal year (barring any amendments); Sheriff's Office and Facilities Management. Sheriff— Unfavorable: ($595,000) • The department is forecasted to be unfavorable due to increased use of overtime and related fringe benefits; primarily in the Corrective Services area which has a large number of vacant positions and employees on leave. The unfavorable overtime is partially offset by favorable salaries and fringe benefits for the vacant positions. A budget amendment will be made by year end if the trend continues. Facilities Management Unfavorable: ($16,124) • The department is forecasted to be unfavorable in internal support expenditures primarily due to Info Tech Operations ($17,000). A Second Quarter budget amendment is recommended to adjust Info Tech Operations due to a review of the billing for five computer workstations along with associated software. Note that while individual divisions may be over budget, the budget is controlled at the department level. The General Appropriations Act requires that appropriations accumulate at the following three summary levels of expenditures within each County Department and are deemed maximum authorization for expenditures: Personnel Expenditures, Operating Expenditures, and Internal Support Expenditures. Required Reporting Adjustments The Quarterly Forecast presents the County's financial position in relation to the amended budget (Budget perspective). This form of presentation is used so that users of this forecast can assess the true financial impact of County operations in comparison to the budget for the current fiscal year. However, it is important to note that this presentation style does not fully coincide with the accounting requirements of audited financial statements produced by the County. The County's financial statements are required to follow Generally Accepted Accounting Principles or GAAP. 2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 I Fax (248) 452-9172 I OakGov.com Forecast Presentation — Budgetary Perspective The presentation reflects the true fiscal activity of the County for FY 2018: Revenues - over/ (under) budget $ 2,680,716 Expenditures — (over)/under budget 14,237,512 Total Officially Reported Favorability $ 16,918,228 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 $49,546,471 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 $ 2,680,716 (49,546,471) $ (46,865,755) 14,237,512 $ (32,628,243) It is important to analyze the forecast using both the Budget perspective and the GAAP perspective to accurately reflect the impact of fiscal activity generated from FY 2018 operations. The Budget perspective recognizes the overall favorable operating budget variance and confirms the County's continuing efforts to maintain long-term fiscal stability particularly through continuation of prudent fiscal policies, such as budgeting for full employment of all authorized positions and the stringent scrutiny applied to all requested expenditures. The Budget perspective shows that the County is projected to be favorable by $16.9 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 $32.6 million by the end of Fiscal Year 2018. The use of Fund Balance is consistent with information provided to the Finance Committee and the Board of Commissioners, as well as what is reflected in the FY 2018-2020 Triennial Budget. The County PLANNED to use fund balance, which has built up over the years through accelerated budget reductions, to support operations in FY 2018. However, it should be noted while the amended budget reflects the utilization of $49.5 million of Fund Balance, this forecast projects the use of Fund Balance needed to support FY 2018 activities of $32.6 million, $16.9 million less than planned. 2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 I Fax (248) 452-9172 I OakGov.com SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS GENERAL FUNDIGENERAL PURPOSE (GF/GP) FY 2018 FY 2019 FY 2020 AMENDMENTS AMENDMENTS AMENDMENTS $ (524,670.00) 524,670.00 $ $ 11,390.00 1,108.00 16,968.00 12,007.00 9,542.00 (1,108.00) $ 49,907.00 $ 11,390.00 16,968.00 12,007.00 9,542.00 $ 49,907.00 $ 17,000.00 $ 14,000.00 $ 14,000.00 $ 17,000.00 $ 14,000.00 $ 14,000.00 GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) DEPT PROGRAM ACCT FUND AFF. OP UNIT ACCOUNT NAME CIRCUIT COURT- FAMILY DIVISION Expenditures 9090101 196030 730800 Grant Match 3010401 126030 788001 27100 Transfers Out - Friend of the Court Total Expenditure SHERIFF'S OFFICE Revenue 4030901 116240 695500 21340 Transfers In - Law Enforcement Enhance Lab Fees 4030901 110090 695500 21341 Transfers In - Law Enforcement Enhance State 4030701 116230 695500 21396 Transfers In - Sheriff Training 4030301 112620 695500 21397 Transfers In - Sheriff Booking Fee Training 4030301 112620 695500 21397 Transfers In - Sheriff Booking Fee Training 9010101 196030 665882 Planned Use of Balance Total Revenue Expenditures 4030901 116240 750203 Forensic Lab Enhancement 4030701 116230 731304 Officers Training 4030301 112620 731304 Officers Training 4030301 112620 731304 Officers Training Total Expenditures FACILITIES ENGINEERING Revenues 9010101 196030 665882 Planned Use of Balance Total Revenues 4 SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2018 FY 2019 FY 2020 AMENDMENTS AMENDMENTS AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) DEPT PROGRAM ACCT FUND AFF. OP UNIT ACCOUNT NAME Expenditures 1040801 148020 774636 Info Tech Operations 17,000.00 $ 14,000.00 $ 14,000.00 Total Expenditures 17,000.00 $ 14,000.00 $ 14,000.00 HUMAN RESOURCES Expenditures 1050403 183020 731570 1050403 183020 731773 Recruitment Expense Software Rental Lease Purchase Total Expenditures $ (1,646.00) 1,646.00 HEALTH DIVISION Project ID 100000002527 Analysis: GLB Activity Type : GLB Budget Reference: 2018 Revenues 1060201 133150 610313 1060201 133150 630014 Federal Operating Grants Administration Fees Total Revenues $ 240,000.00 (240,000.00) HOMELAND SECURITY Project ID 100000002372 Analysis: GLB Activity Type : GLB Budget Reference: 2017 Revenues 1060601 115180 610313 9010101 196030 665882 VETERANS SERVICES Revenue 1070301 132050 631827 Federal Operating Grants Planned Use of Balance Total Revenues Reimb General Total Revenue 7,457.00 $ (7,457.00) 4,565.00 4,565.00 5 Revenues 1070805 1070805 1070801 1070801 1070805 132130 114050 114000 114000 114000 630028 630070 630074 631253 665882 SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2018 FY 2019 FY 2020 AMENDMENTS AMENDMENTS AMENDMENTS IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND 1#10100) DEPT PROGRAM ACCT FUND AFF. OP UNIT ACCOUNT NAME Expenditures 1070301 132070 732108 MEDICAL EXAMINER Expenditures 1070601 132030 731941 1070601 132030 732165 1070801 114000 760126 1070801 114000 776661 Travel and Conference Total Expenditures Training Workshops and Meetings Total Expenditures Capital Outlay Miscellaneous Motor Pool Total Expenditures Adoptions Animal Shots Animal Stedization Fees Miscellaneous Planned Use of Balance Total Revenues 4,565.00 4,565.00 $ (1,200.00) 1,200.00 $ 19,524.00 $ 19,524.00 $ 16,835.00 2,689.00 $ 19,524.00 705.00 480.00 1,950.00 180.00 (3,315.00) ANIMAL CONTROL Revenues 1070801 114000 695500 21310 Transfer In Legacy Fund Total Revenue 6 SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2018 FY 2019 FY 2020 AMENDMENTS AMENDMENTS AMENDMENTS IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) DEPT PROGRAM ACCT FUND AFF. OP UNIT ACCOUNT NAME ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS Expenditures 1090201 171000 731458 1090201 171000 788001 63600 Revenues 1090108 172072 650104 Professional Services Transfer Out- Information Technology Fund Total Expenditures Contributions Total Revenues $ (75,000.00) 75,000.00 $ 12,372.00 $ 12,372.00 Expenditures 1090108 172072 750511 Revenues 1090201 171047 632065 Special Event Supplies Total Expenditures Seminars/Conferences Total Revenues $ 12,372.00 $ 12,372.00 $ 12,500.00 $ 12,500.00 Expenditures 1090201 171047 731388 Printing $ 515.00 1090201 171047 750511 Special Event Supplies 11,985.00 Total Expenditures 12,500.00 7 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY f SPECIAL REVENUE FUNDS ACCOUNT NUMBER FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name SHERIFF - LAW ENFORCEMENT ENHANCE LAB FEES (#21340) Revenue 4030901 116240 665882 Planned Use of Balance Total Revenue 11,390.00 11,390.00 Expenditures 4030901 116240 788001 10100 Transfers Out - General Fund 11,390.00 Total Expenditures 11,390.00 SHERIFF - LAW ENFORCEMENT ENHANCE STATE (#21341) Revenue 4030901 110090 665882 Planned Use of Balance 1,108.00 Total Revenue 1,108.00 Expenditures 4030901 110090 788001 10100 SHERIFF - SHERIFF TRAINING (#21396) Revenue 4030701 112630 665882 Transfers Out - General Fund Total Expenditures Planned Use of Balance Total Revenue 1,108.00 1,108.00 16,968.00 16,968.00 Expenditures 4030701 112630 788001 10100 Transfers Out - General Fund 16,968.00 Total Expenditures 16,968.00 8 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY I SPECIAL REVENUE FUNDS FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY I SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID program Acct Fund Aff Oper Unit Account Name SHERIFF - SHERIFF BOOKING FEE TRAINING (#21397) Revenue 4030301 112620 665882 Planned Use of Balance Total Revenue Expenditures 4030301 112620 788001 10100 Expenditures 4030301 112620 788001 10100 ANIMAL CONTROL LEGACY FUND (#21310) Revenue 9010101 114000 665882 Expenditure 9010101 114000 788001 10100 Transfers Out - General Fund Total Expenditures Transfers Out - General Fund Total Expenditures Planned Use of Balance Total Revenue Transfers Out - General Fund Total Expenditures 12,007.00 12,007.00 12,007.00 12,007.00 9,542.00 9,542.00 9,542.00 9,542.00 19,524.00 19,524.00 19,524.00 19,524.00 SHERIFF - SHERIFF BOOKING FEE TRAINING (#213971 Revenue 4030301 112620 665882 Planned Use of Balance Total Revenue 9 INFORMATION TECHNOLOGY (#63600) Revenue 1080101 152000 695500 10100 Transfers In - General Fund Total Revenue $ 75,000.00 $ 75,000.00 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS ACCOUNT NUMBER FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program, Acct Fund Aff Oper Unit MOTORPOOL (#66100) Revenue 1030811 184010 631463 1030811 184010 631610 Account Name Parts and Accessories Productive Labor Total Revenues $ 1,647.00 $ 1,042.00 $ 2,689.00 Expenses 10308011 184010 796500 Budgeted Equity Adjustment Total Expenses $ 2,689.00 $ 2,689.00 Expenses 1080201 152000 731458 Professional Services Total Expenses $ 75,000.00 $ 75,000.00 CIRCUIT COURT - MICHIGAN MENTAL HEALTH SCAO (#27175) GR0000000423 Activity GLB, Analysis Type GLB, Budget Ref 2018 Expenditure $ $ $ $ CIRCUIT COURT - FRIEND OF THE COURT(#27100) Expenditures 3010404 126030 702010 3010404 126030 730926 3010301 3010301 3010301 121200 121200 121200 731416 750245 750280 Priv Institutions Residential Incentives Laboratory Supplies Total Expenditure Salaries Regular Indirect Costs (5,000.00) 2,000.00 3,000.00 $ (195,742.00) $ 140,260.00 10 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS l'Ap.) Program Acct Fund Aff Oper Unit Account Name 3010404 135140 730926 Indirect Costs 4030925 110070 730926 Indirect Costs Total Expenditures PROSECUTING ATTORNEY - CRIME VICTIM RIGHTS WEEK (#29327) GR0000000819 Activity: GLB Analysis Type: GLB Budget Reference: 2018 Revenue 4010101 135170 615571 State Operating Grants Total Revenue 37,256,00 18,226.00 400.00 400.00 Expenditures 4010101 135170 750511 Special Event Supplies 400_00 Total Expenditures 400.00 COMMUNITY CORRECTIONS COMPREHENSIVE GRANT (#27370) GR0000000772 Activity: GLB Analysis Type: GLB Budget Reference: 2018 Expenditures 1070401 1070401 1070401 1070401 1070401 113000 113035 113150 113150 113190 773630 730373 702010 722740 731458 Info Tech Development Contracted Services Salary Fringe Benefits Professional Services Total Expenditures (5,000.00) 5,000.00 (5,000.00) (5,000,00) 10,000.00 ANIMAL CONTROL GRANTS (#29215) GR0000000820 Activity: GLB Analysis Type: GLB Budget Reference: 2018 Revenue 1070801 114000 650104 Contributions Operating Total Revenue 10,000.00 10,000.00 11 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL. REVENUE FUNDS FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID. Program Acct Fund Aff Oper Unit Account Name Expenditures 1070801 114000 750014 Animal Supplies Total Expenditures HIV DATA TO CARE (#28619) GRO000000811 Activity: GLB Analysis Type: GLB Budget Reference 2018 10,000.00 10,000.00 Revenues 1060294 133250 610313 1060294 133250 615571 Federal Operating Grants State Operating Grants Total Revenues (128,800.00) 128,800.00 HEP A RESPONSE (#28620) GR0000000814 Activity: GLB Analysis Type: GLB Budget Reference 2018 Revenues 1060290 133050 610313 1060290 133050 615571 Federal Operating Grants State Operating Grants Total Revenues (203,000.00) 203,000.00 GONOCOCCAL ISOLATE (#28310) GR0000000689 Activity: GLB Analysis Type: GLB Budget Reference: 2018 Revenues 1060234 133120 610313 Federal Operating Grants (26,833.00) 1060234 133120 615571 State Operating Grants 36,500.00 Total Revenues 9,667.00 Expenditures 1060234 1060234 1060234 133120 133120 133120 732018 750280 774677 Travel and Conference Laboratory Supplies Insurance Fund Total Expenditures 3,500.00 6,113.00 54.00 9,667.00 12 Federal Operating Grants $ 3,611.00 Total Revenues $ 3,611.00 Revenues 1060230 133215 610313 1060230 133215 615571 Expenditures 1060230 133215 731346 1060230 133215 731458 1060230 133215 731941 1060230 133215 731997 1060230 133215 774677 352,372.00 (334,372.00) $ 18,000.00 136.00 18,000.00 (687.00) (136.00) 687.00 $ 18,000.00 Federal Operating Grants State Operating Grants Total Revenues Personal Mileage Professional Services Training Transportation of Clients Insurance Fund Total Expenditures SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS ACCOUNT NUMBER FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name HIV SURVEILLANCE (28558) GR0000000666 Activity: GLB Analysis Type: GLB Budget Reference: 2018 Revenues 1060294 133940 610313 $ Expenditures 1060294 133940 1060294 133940 1060294 133940 1060294 133940 702010 722740 730926 770631 Salaries Regular Fringe Benefits Indirect Costs Bldg Space Cost Allocation Total Expenditures (26.00) (5.00) 18.00 3,624.00 3,611.00 NURSE FAMILY PARTNERSHIP (#28607) GR0000000279 Activity: GLB Analysis Type: GLB Budget Reference: 2018 13 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 1060284 133270 133270 133270 133270 133270 133270 133270 133270 133270 133270 133270 133270 133270 133270 133270 133270 133270 133270 133270 133270 133270 133270 133270 702010 722740 730072 730373 730646 730926 730982 731346 731388 731458 731626 731941 732018 750294 750301 750392 750399 750567 770631 774636 774637 774677 778675 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS ACCOUNT NUMBER FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS !PROPRIETARY I SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit WIC (#28553) GR0000000205 Activity: GLB Analysis Type: GLB Budget Reference: 2018 Revenues 1060284 133270 610313 Account Name Total Revenues Federal Operating Grants (108,750.00) (108,750.00) Expenditures Salaries Regular Fringe Benefits Advertising Contracted Services Equipment Maintenance Indirect Costs interpetation Fees Personal Mileage Printing Professional Services Rent Training Travel and Conference Material and Supplies Medical Supplies Metered Postage Office Supplies Training-Educational Supplies Bldg Space Cost Allocation Info Tech Operations Info Tech Managed Print Svcs Insurance Fund Telephone Communications Total Expenditures (43,768.00) 6,766.00 (16,000.00) (6,210.00) (1,000.00) 2,988.00 (300.00) (341.00) (3,000.00) (500.00) (2,173.00) 250.00 (1,718.00) (700.00) (2,945.00) (1,250.00) (500.00) (4,000.00) (3,795.00) (30,368.00) (5,495.00) 3,069.00 2,240.00 $ (108,750.00) 14 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID program Acct Fund Aff Oper Unit Account Name BIOTERROR COORDINATOR (#28610) GR0000000796 Activity: GLB Analysis Type: GLB Budget Reference: 2018 Expenditures $ 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 1060290 115010 115010 115010 115010 115010 115010 115010 115010 115010 115010 115010 702010 722740 730926 731388 732018 750077 750399 760567 774636 774637 778675 Salaries Regular Fringe Benefits Indirect Costs Printing Travel & Conference Disaster Supplies Office Supplies Training-Educational Supplies Info Tech Operations Info Tech Managed Print Svcs Telephone Communications Total Expenditures (7,253.00) (5,574.00) 83.00 400.00 1,017_00 400.00 1,209.00 400.00 7,158.00 2,199.00 (39.00) CITIES READINESS (#28610) GR0000000796 Activity: GLB Analysis Type: GLB Budget Reference: 2018 Expenditures 1060290 116035 702010 1060290 115035 722740 1060290 115035 730926 1060290 115035 731346 1060290 115035 731388 1060290 115035 731941 1060290 115035 732018 1060290 115035 732165 1060290 115035 750077 1060290 115035 750399 1060290 115035 750448 1060290 115035 770631 Salaries Regular Fringe Benefits Indirect Costs Personal Mileage Printing Training Travel & Conference Workshops and Meeting Disaster Supplies Office Supplies Postage - Standard Mailing Bldg Space Cost Allocation (12,158.00) (9,334.00) (940.00) 53.00 606.00 500.00 3,910.00 760.00 550.00 1,500.00 (26.00) 1,734.00 15 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY I SPECIAL REVENUE FUNDS FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 1060290 115035 774636 Info Tech Operations 1060290 115035 774677 Insurance Fund 1060290 115035 778675 Telephone Communications Total Expenditures BIOTERROR COORDINATOR (#28610) GR0000000796 Activity: GLB Analysis Type: GLB Budget Reference 2018 Revenues 1060290 115010 610313 Federal Operating Grants Total Revenues 14,480.00 (36.00) (1,599.00) 3,753.00 3,753.00 Expenditures 1060290 115010 702010 Salaries Regular (6,113.00) 1060290 115010 722740 Fringe Benefits (4,688.00) 1060290 115010 730926 Indirect Costs (782.00) 1060290 115010 731346 Personal Mileage 1,465.00 1060290 115010 731388 Printing 4,600.00 1060290 115010 732018 Travel & Conference 2,500.00 1060290 115010 750077 Disaster Supplies 15,189.00 1060290 115010 750399 Office Supplies 791.00 1060290 115010 750567 Training-Educational Supplies (400.00) 1060290 115010 774636 Info Tech Operations (7,158.00) 1060290 115010 774637 Info Tech Managed Print Svcs (1,375.00) 1060290 115010 774677 Insurance Fund 135.00 1060290 115010 778675 Telephone Communications (411.00) Total Expenditures 3,753.00 CITIES READINESS (#28610) GR0000000796 Activity: GLB Analysis Type: GLB Budget Reference 2018 Revenues 1060290 115035 610313 Federal Operating Grants Total Revenues 13,796.00 13,796.00 16 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Expenditures 1060290 115035 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 702010 722740 730926 731346 731388 731941 732018 732165 750077 750448 770631 774636 774677 778675 Salaries Regular Fringe Benefits Indirect Costs Personal Mileage Printing Training Travel & Conference Workshops and Meeting Disaster Supplies Postage - Standard Mailing Bldg Space Cost Allocation Info Tech Operations Insurance Fund Telephone Communications Total Expenditures (3,933.00) (3,022.00) (503.00) 321.00 1,394.00 1,000.00 8,090.00 2,000.00 3,559.00 300.00 2,996.00 1,308.00 86.00 200.00 13,796.00 Expenditures 1060233 134865 1060233 134865 1060233 134865 1060233 134865 730072 731388 750448 750567 Advertising Printing Postage - Standard Mailing Training-Educational Supplies Total Expenditures (10,000.00) (10,000.00) (3,000.00) (1,700.00) (300.00) (5,000.00) (10,000.00) ZIKA COMMUNITY SUPPORT (#28618) GR0000000785 Activity: GLB Analysis Type: GLB Budget Reference 2018 Revenues 1060233 134865 610313 Federal Operating Grants Total Revenues 17 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY !SPECIAL REVENUE FUNDS FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name MIKA MOSQUITO SURVEILLANCE (#28818) GR0000000786 Activity: GLB Analysis Type: GLB Budget Reference 2018 Revenues 1060220 134865 610313 Federal Operating Grants Total Revenues (10,000.00) (10,000.00) Expenditures 1060220 134865 702010 Salaries Regular (3,959.00) 1060220 134865 722740 Fringe Benefits (2,692.00) 1060220 134865 730926 Indirect Costs (472.00) 1060220 134865 731346 Personal Mileage (1,874.00) 1060220 134865 750399 Office Supplies (1,003.00) Total Expenditures (10,000.00) PARKS AND RECREATION 5060101 160000 650104 Contributions Operating 10,000.00 5060831 160210 670456 Prior Years Adjustments 60,240.00 5060666 160666 665882 Planned Use of Balance (60,240.00) 5060666 160666 665882 Planned Use of Balance (10,000.00) 5060666 160666 665882 Planned Use of Balance (27,745.00) 5060666 160666 665882 Planned Use of Balance (160,000.00) Total Revenues (187,745.00) 5060326 5060330 5060330 5060715 5060715 5060715 5060720 5060720 160010 160010 160010 160070 160070 160070 160070 160070 730814 731115 730814 731115 730653 730814 731115 730814 Grounds Maintenance Licenses and Permits Grounds Maintenance Licenses and Permits Equipment Rental Grounds Maintenance Licenses and Permits Grounds Maintenance 4,875.00 400.00 7,950.00 400.00 560.00 2,196.00 400.00 456.00 18 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060720 160070 777560 Radio Communications 5060720 160070 778675 Telephone Communciations 5060724 160070 731115 Licenses and Permits 5060724 160070 730653 Equipment Rental 5060724 160070 730814 Grounds Maintenance 5060725 160070 730653 Equipment Rental 5060725 160070 731115 Licenses and Permits 5060725 160070 730814 Grounds Maintenance 5060735 160070 730814 Grounds Maintenance 5060751 160070 730814 Grounds Maintenance 5060755 160070 730814 Grounds Maintenance 5060760 160070 730653 Equipment Rental 5060760 160070 730814 Grounds Maintenance 5060765 160070 730814 Grounds Maintenance 5060765 160070 730653 Equipment Rental 5060831 160210 730814 Grounds Maintenance 5060831 160210 730198 Building Maintenance Charges 5060910 160430 730198 Building Maintenance Charges 5060910 160430 730789 General Program Administration 5060910 160430 730789 General Program Administration 5060910 160430 730789 General Program Administration Total Expenses (500.00) 500.00 400.00 560.00 696.00 560.00 600.00 10,259.00 366.00 1,221.00 861.00 560.00 576.00 441.00 560.00 18,837.00 40,000.00 144.00 (93,878.00) (160,000.00) (27,745.00) (187,745.00) VETERANS SERVICES DONATION FUND (#21381) Revenue 9010101 114000 665882 Planned Use of Balance Total Revenue 13,912.00 13,912.00 Expenditure 9010101 114000 788001 40400 Transfers Out - Project Work Order Fund Total Expenditures 13,912.00 13,912.00 19 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY I SPECIAL REVENUE FUNDS FY 2018 AMENDMENTS FY 2019 FY 2020 AMENDMENTS AMENDMENTS !PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name PROJECT WORK ORDER FUND (#40400) PCBU: FACMG Project: 100000002799, Activity: PROJ Revenues 1040801 148020 695500 21381 Expenditures 1040801 148020 796500 Transfer In-Veterans Services Donation Fund $ Total Revenues Budgeted Equity Adjustments Total Expenditures 13,912.00 13,912.00 13,912.00 13,912.00 BUILDING IMPROVEMENT FUND (#40100) Revenues 1040801 148020 665882 Planned Use of Balance Total Revenues (496,800.00) (496,800.00) Expenditures 1040801 148020 788001 40400 Transfer Out-Project Work Order Fund (496,800.00) Total Expenditures (496,800.00) PROJECT WORK ORDER FUND (#40400) PCBU: FACMG Project: 100000002604, Activity: PROJ Revenues 1040801 148020 695500 40100 Transfer In-Building Improvement Fund (496,800.00) Total Revenues (496,800.00) Expenditures 1040801 148020 796500 Budgeted Equity Adjustments (496,800.00) Total Expenditures (496,800.00) 20 INFORMATION TECHNOLOGY FUND (#63600) Expenses 1080101 152000 731458 1080101 152000 702010 1080101 152000 731780 1080601 152090 731458 1080601 152090 702010 1080601 152090 731780 1080601 152090 730373 Revenues 1080101 152000 665882 Expenses 1080601 152150 731773 Revenues 1080201 152010 1080601 152010 1080101 152000 1080101 152000 631372 631372 631372 631372 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS $ (23,870,000.00) $ 23,870,000.00 Professional Services Salaries Regular Software Support/Maintenance Professional Services Salaries Regular Software Support/Maintenance Contracted Services Total Expenses Planned Use of Fund Balance Total Revenue Software Rental Lease Total Expenses OC Depts Operations OC Depts Operations OC Depts Operations OC Depts Operations Total Revenues ACCOUNT NUMBER PROPRIETARY/SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name FRINGE BENEFIT FUND (#67800) Expenses 9011501 183191 764023 Bond Maturing 9011501 183190 796500 Budgeted Equity Adjustment Total Expenses FY 2018 FY 2019 FY 2020 AMENDMENTS AMENDMENTS AMENDMENTS (480,000.00) (200,000.00) (70,000.00) 430,000.00 200,000.00 70,000.00 50,000.00 111,900.00 111,900.00 111,900.00 111,900.00 (39,900.00) (61,353.00) 39,900.00 61,353.00 21 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2018 SECOND QUARTER BUDGET AMENDMENTS PROPRIETARY /SPECIAL REVENUE FUNDS FY 2018 FY 2019 FY 2020 ACCOUNT NUMBER AMENDMENTS AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name INFORMATION TECHNOLOGY FUND (#63600) Expenses 1080601 152010 731773 1080201 152010 731773 Software Rental Lease Software Rental Lease Total Expenses (54,671.00) 54,671.00 22 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES SUMMARY BY DEPARTMENT REVENUES GENERAL FUND Taxes Federal Grants State Grants Other Intergovernmental Revenue Charges for Services Indirect Cost Recovery Investment Income Other Revenues FY 2018 ADOPTED BUDGET $ 226,626,898,00 693,892.00 20,565,842.00 44,760,644.00 110,083,318,00 8,134,737.00 1,904,700.00 9,090,297.00 BUDGET AS AMENDED $ 226,626,698.00 804,611.00 20,575,006.00 46,468,690,00 111,498,717.00 8,134,737.00 1,904,700.00 9,192,732,00 FY 2018 FORECAST $ 226,776,698.00 935,073.00 19,787,506,00 46,459,690.00 114,349,217.00 8,134,737,00 1,924,200,00 9,519,486.00 AMOUNT FAVORABLE/ (UNFAVORABLE) PERCENT 150,000.00 0.07% 130,462,00 16.21% (787,500,00) -3.83% (9,000.00) -0.02% 2,850,500.00 2.56% 0.00% 19,500.00 1.02% 326,754.00 3.55% 0.63% SUB-TOTAL GENERAL FUND/GENERAL PURPOSE $ 421,860,128.00 $ 425,205,891,00 $ 427,886,607.00 $ 2,680,716.00 PLANNED USE OF FUND BALANCE $ 33,122,397.00 $ 49,546,471.21 $ 49,548,471,21 0.00% TOTAL GF/GP FUNDS $ 454,982525.00 474,752.362.21 $ 477,433,078.21 2,680,716.00 0.56% EXPENDITURES ADMINISTRATION OF JUSTICE Circuit Court 52nd District Court Probate Court TOTAL ADMIN. OF JUSTICE $ 52,897,286.00 17,468,272.00 6,422,263.00 $ 76,787,821.00 $ 54,146,040.00 17,550,352.21 6,447,973.00 $ 78,144,385.21 46,898,540.00 $ 7,247,500.00 13.39% 17,002,852.21 547,500.00 3.12% 6,145,473.00 302,500.00 4.69% $ 70,046,865.21 $ 8,097,600.00 10.36% LAW ENFORCEMENT Prosecuting Attorney 20,714,070,00 20,816,959.00 19,501,959.00 1,315,000.00 6.32% Sheriff 151,190,737.00 153,717,622.26 154,312,622.26 (595,000.00) -0,39% TOTAL LAW ENFORCEMENT $ 171,904,807.00 $ 174,534,581.26 $ 173,814,581.28 720,000.00 0.41% GENERAL GOVERNMENT Clerk/Register of Deeds Treasurer Board of Commissioners Library Board Water Resources Commissioner TOTAL GENERAL GOVERNMENT COUNTY EXECUTIVE County Executive Admn. Management and Budget Central Services Facilities Management Human Resources Health and Human Services Public Services Economic Dev. and Comm Affairs TOTAL COUNTY EXECUTIVE TOTAL DEPARTMENTS 10,750,706,00 8,853,534.00 3,093,086.00 1,368,601.00 6,738,890.00 $ 30,804,817.00 $ 7,896,852.00 20,299,401,00 2,665,437.00 1,374,924.00 4,090,723.00 67,324,551,00 18,038,978.00 8,386,708.00 $ 130,075,574.00 $ 409,573,019.00 $ 7,935,455,00 20,699,126.46 2,913,704.00 1,386,550.00 4,432,548,00 68,409,273.28 18,357,925.00 9,241,096,00 133,375,677.74 417,499,965,21 $ 7,916,855.00 19,565,126.46 2,913,704.00 1,402,674.00 4,198,248.00 67,119,313,28 18,238,825,00 8,938,596.00 $ 130,293,341.74 $ 403,317,453.21 18,600.00 0.23% 1,134,000.00 5.48% 0,00% (16,124.00) 416% 234,300,00 5,29% 1,289,960.00 1.89% 119,100.00 0.65% 302,500.00 3.27% $ 3,082,336.00 2.31% $ 14,182,512.00 3.40% 10,937,414.00 9,902,138,00 1,035,276.00 9.47% 8,999,849.00 7,805,249,00 1,194,600.00 13.27% 3,194,238,00 3,144,238.00 50,000.00 1.57% 1,377,835.00 1,375,035.00 2,800,00 0.20% 6,936,005.00 6,936,005.00 - 0.00% $ 31,445,341.00 $ 29,162,665.00 $ 2,282,676.00 7.26% NON-DEPARTMENTAL APPROPRIATIONS TOTAL NON-DEPARTMENTAL 45,409,506.00 57,252,397.00 $ 57,197,397.00 55,000.00 0.10% TOTAL GOVERNMENTAL EXPENDITURES 454 982 525 00 $ 474,762,362.21 $ 460,514,850.21 14 237 512.00 3.00% General Fund/General Purpose Favorable/(Unfavorable) - Budget Perspective GAAP Required Adjustment (eliminating use of fund balance "revenue") 16 918 228 00 $ 16 918 228.00 (49,546,471.21) $ (49,546,471.21) GAAP - BASED REPORT (forecasted impact on Fund Balance) ($32,628,243.21) - ($32,628,243.21) 23 60,800.00 60,800.00 60,800.00 100,872.00 100,334.00 100,334.00 300,000.00 300,000.00 300,000.00 $ 693,892.00 5 804,611.00 $ 935,073.00 $ 130,462.00 - $ 1,000.00 - s 1,000.00 - $ 1,000.00 10,000.00 4,811,324.00 4,812,160.00 10,000.00 4,811,324.00 15,752,682.00 16,752,682.00 14,965,182.00 (787,500.00) Homeland Security - Disaster Control Health Division Children's Village Total Federal Grants STATE GRANTS (615000-615999) Sheriff - Patrol State Match Foster Care Prosecuting Attorney Economic Development Health Division Water Resources Commissioner Public Services - Veteran's Services Non-Departmental - Child Care Subsidy 0.00% 0.00% 0.00% 16.21% 0.00% 0.00% 0,00% 0.00% 0.00% 0.00% 0.00% -5.00% 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, COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2018 SECOND QUARTER REPORT ADOPTED BUDGET AMENDED BUDGET FY 2018 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES TAXES (601000-601999) Property Taxes -July Tax Levy Other Taxes - Delinquent Tax - Prior Years Treasurer Payment in Lieu of Taxes Other Taxes - Trailer Tax Total Taxes $ 226,148,198.00 98,500.00 300,000.00 80,000.00 $ 226,626,698.00 $ 226,148,198.00 $ 226,148,198.00 $ 98,500.00 98,500.00 360,000.00 450,000,00 150,000.00 80,000.00 80,000,00 $ 226,626,698.00 $ 226,776,698.00 $ 150,000.00 0.00% 0.00% 50.00% Fay. due to tax payments from the state on DNR land. 0.00% 0.07% FEDERAL GRANTS (510000-610999) Sheriff - Patrol 138,477.00 $ 138,477.00 $ 0.00% Sheriff - Corrective Services 27,220.00 0.00% Sheriff - Investigative/Forensic Services Prosecuting Attorney 205,000.00 70,462.00 70,462,00 100.00% Fay. Due to timing of funding for the High Intensity Drug Trafficking Areas (HIDTA) Grant. 205,000.00 265,000.00 60,000.00 29.27% Fast. due to contract with Michigan Department of Health and Human Services Title IV-E. Total State Grants $ 20,565,842.00 $ 20,575,006.00 $ 19,787,506.00 $ (787,500.00) -3.83% OTHER INTER-GOVERNMENTAL REVENUES (620000 - 626999) Non-Departmental $ 42,519,178.00 $ 44,227,224.00 $ 44,227,224.00 $ HHS - Homeland Security 18,000.00 18,000.00 9,000.00 Circuit Court 4,500.00 4,500.00 4,500.00 District Court 1,800,00 1,800.00 1,800.00 Sheriff 268,706.00 258,706.00 268,706.00 0.00% (9,000.00) -50.00% Unfav. Local Match due to the instaliation of fewer than anticipated sirens. 0.00% 0.00% 0.00% Non-Departmental - Reimb Judges Salaries 1,948,460.00 1,948,460.00 1,948,460.00 0,00% 24 COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2018 SECOND QUARTER REPORT 140,000.00 3.70% Fay. State Law Costs $100,000 as well as Ordinance Fines and Costs $100,000 due to continued collection efforts. Partially offset by unfav. Probation Fees ($25,000); Garnishment Fees ($20,000); Refund Fees PD Def Attorney ($15,000) due to a reduction in caseload. 45,000.00 2.60% Fay. Ordinance Fines and Costs $25,000 as well as State Law Costs $20,000 due to an increase in Criminal/Traffic caseload and continued collection efforts. 500,000.00 14.03% Fay. Ordinance Fines and Costs $425,000 as well as State Law Costs $100,000 based on continued collection efforts. Partially offset by unfav. Probation Fees ($25,000) due to probationer's inability to pay monthly Probationary Oversight Expense. AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST IUNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Total Other Intergovernmental Revenue $ 44,760,644.00 $ 46,468,690.00 $ 46,459,690.00 $ (9,000.00) -0.02% CHARGES FOR SERVICES 1630000-635999) Administration of Justice Circuit Court- Judicial/Administration - $ $ - $ 0.00% Circuit Court - Civil/Criminal 2,466,000.00 2,586,500.00 2,511,500.00 (75,000.00) -2.90% Unfav. Civil Mediation Payments ($100,000) due to a reduction in use of mediation. Unfav. Refund Fees PD Def Attorney ($50,000) due to a decrease in activity. Unfav. Jury Fees ($25,000) due to reduction in jury trials. Partially offset by fav. Court Costs $75,000 due to more than anticipated revenue and E Filing Fees $25,000 due to unanticipated E-Filing revenue. Circuit Court - Family Division 1,799,500.00 1,799,500.00 1,784,500.00 (15,000.00) -0.83% Unfav. Refund Fees PD Def Attorney ($25,000) due to a decrease in activity and Reimb Clinical Evaluations ($15,000) due to a reduction in family caseload. Partially offset by an increase in Board and Care $25,000. District Court- Division I (Novi) 3,784,200.00 3,784,200.00 3,924,200.00 District Court - Division II (Clarkston) 1,731,200.00 1,731,200.00 1,776,200.00 District Court - Division Ill (Rochester Hills) 3,553,900.00 3,563,900.00 4,063,900.00 25 COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2018 SECOND QUARTER REPORT Probate Court Estates and Mental Health AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 12,500.00 0.55% Fay. Forfeiture of Bonds $15,000 due to an increased number of defendants failing to appear before the court. Fay. State Law Costs $12,500; Ordinance Fines and Costs $10,000; along with Refund Fees PD Def Attorney $10,000 based on continued collection efforts. Partially offset by unfav. Miscellaneous ($15,000) due to decrease in filings. Unfav. Probation Fees ($10,000) due to probationer's inability to pay monthly Probationary Oversight Expense. Unfav. Garnishment Fees ($10,000) due to a decrease in the number of civil cases filed. 516,600.00 516,600.00 551,600.00 35,000.00 6.78% Fay. Gross Estate Fees $30,000 due to an increase in fees paid. Fav. Certified Copies $20,000 due to an increase in activity. Partially offset by unfav. Refund Fees PD Def Attorney ($15,000) due to a decrease in fees collected. ADOPTED AMENDED FY 2018 BUDGET BUDGET FORECAST District Court - Division IV (Troy) 2,263,350.00 2,263,350.00 2,275,850.00 Total Administration of Justice $ 16,114.750.00 $ 16,245.250.00 $ 16,857,750.00 $ 642,500.00 3.96% Law Enforcement Prosecuting Attorney $ 295,053.00 $ 295,053.00 292,553.00 $ (2,500.00) -0.85% Unfav. Welfare Fraud Case Review ($2,500) due to the State performing the review in-house. Sheriffs Office Sheriff - Administrative Services Sheriff - Corrective Services 1,900.00 392,400.00 3,233,298.00 1,900.00 392,400.00 3,362,584.00 1,900.00 372,400.00 3,037,584.00 (20,000.00) (325,000.00) 0,00% -5.10% Unfav. Fingerprints ($20,000) due to less usage. -9,67% Unfav. Reimb Salaries ($170,000) due to declining reimbursements, Inmate Board and Care ($150,000) due to timing of collections and inmates inability to pay, Fee Income ($22,000) from bond fees and indigent jail commissary collections, Clinic Charges ($20,000) from inmates inability to reimburse for clinic services and OUIL Third Offense ($15,000) reduction in court driven assessments; partially offset by Commission Contracts $50,000 from increased jail commissary collections. Sheriff - Corrective Services Satellites 645,386.00 645,386.00 645,386.00 0.00% Sheriff - Emergency Response and Prep Sheriff - Patrol Services Sheriff - Emergency Communications Operations 832,220.00 50,452,186.00 1,595,337.00 -40.00% Unfav. Civil Action Service Fees ($200,000) due to the decline in number of foreclosures and civil service requests (see corresponding favorability in Fees Civil Service expenditures). -1.27% Unfav. Sheriff Special Deputies based on billable activity for law enforcement services. 0.00% 500,000.00 300,000.00 (200,000.00) 51,201,373.00 50,551,373.00 (650,000.00) 2,084,264.00 2,084,264.00 26 COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2018 SECOND QUARTER REPORT Sheriff - Investigative Forensic Services ADOPTED BUDGET 1,015,000.00 AMENDED BUDGET 1,015,000.00 FY 2018 FORECAST 1,225.000.00 AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 210,000.00 20.69% Fay. Drug Testing $140,000 collected from Results Program and probation clients. Also fay. Reimb Salaries $70,000 from unbudgeted billable activity. Total Law Enforcement $ 58,465,780.00 $ 59,497,960.00 $ 58,510,460.00 $ (987,500.00) -1.66% General Government Clerk - County Clerk $ 2,212,100.00 $ 2,212,100.00 $ 2,654,000.00 $ 441,900.00 19.96% Fay. Certified Copies $130,700, Photostats $93,400, Jury Fees $92,000, Forfeiture of Bonds $56,100, E-Filing Fees $42,700, Forfeiture of Surety Bonds $34,300, and CVR County Portion $5,000 due to increased activity. Partially offset by unfavorable Assumed Names ($11,700) and Miscellaneous ($3,400) due to less activity. Also unfavorable, Costs ($2,900) due to revenue associated with court ordered fees. 80,700.00 48,600.00 1,116,200.00 695,200.00 Clerk - Elections Clerk - Register of Deeds & Micrographics Treasurer Board of Commissioners Library Board 80,700.00 129,300.00 11,449,500.00 12,144,700.00 4802,300.00 5,918,500.00 12,500.00 6,500.00 14,000.00 16,000.00 60.22% Fay. Election Filing Fees Late $35,400 due to Corporation Counsel efforts to collect on late filers. Nominating Filing Forfeit $12,600, Passport Fees $10,000, and Photographs $2,200 due to increased activity. Partially offset by unfavorable Reimb General ($11,600) due to less than anticipated use. 6.07% Fay. Recording Fees $1,200,000 due to change in legislation in FY 2017 and Deeds $230,000 due to increased activity. Partially Offset by Unfavorable Mortgages ($500,000), Enhanced Access Fees ($220,000) and Reirnb. General ($15,000) due to less than anticipated Use. 23.24% Fay. Payment Other Than Anticipated $755,000 due to the sale of foreclosed properties (land sale activity). Also favorable Admin Fees $250,000, Deeds $82,000, Recording Fee Forfeiture Certificate $50,000, and Recording Fee Redemption Certificate $50,000, and FOIA Fees $2,500. Partially offset by unfavorable Maintenance Contracts ($38,300) and Tax Statements ($35,000) due to reduced activity. -48.00% Unfav. due to change in vendors and anticipated reduction in prescription program royalty fee income. 14.29% Fav. Reimb. Salaries $3,000 due to State aid to public 11,449,500.00 4,802,300.00 12,500.00 14,000.00 (6,000.00) 2,000.00 libraries; partially offset by unfavorable Copier Machine Charges ($1,000) due to increased functionalities of downloading and e-mailing documents. Water Resources Commissioner 2,497,177.00 2,497,177.00 2,632,177.00 35,000.00 1.40% Pay - Soil Erosion Fees $25,000 increase in building activity/permits due to improvement in the housing market. Fay - Reimbursement General $10,000 a result of Drain Administration able to charge more time than anticipated to special revenue and proprietary funds. Total General Government $ 21,066,271.00 $ 21,068,277.00 $ 23,401,177.00 $ 2,332,900.00 11.07% 27 COUNTY OF OAKLAND GENERAL FUND !GENERAL PURPOSE REVENUES FY 2018 SECOND QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFI ANT VARIANCES County Executive County Exec - Compliance Office 265,690,00 $ 265,690.00 $ 265,690.00 0.00% 39,100.00 1.20% Fay. Reirrioursement Equalization Services due to actual contract billing. 0.00% 0.00% 0.00% 0.00% 39,000.00 0.91% Fey. Rabies Vaccines $78,000 due to improved reimbursement from insurance and increased animal bite exposures. Fav. Flu 3rd Party $25,000 due to increased reimbursement from 3rd party payers. Fay, Difference Between Change and Initial Pay $20,000 due to fewer than anticipated 3rd party billing and contractual write-offs: and fay. Hepatitis Vaccine $15,000 due to increase in demand. Partially offset by unfav. Immunizations ($100,000) due to decrease in demand for certain vaccines and timing of claims billing as a result of 3rd Party Clearing House vendor canceling contract without notice. 825,000.00 25.27% Fav. Out County Board and Care $725,000 as well as Board and Care $100,000 due to increase in Department of Health and Human Services placement County Exec - Compliance Office County Exec - Corp Counsel County Exec - Admin M&B - Equalization Division 3,260,000.00 3,260,000.00 3,299,100.00 M&B - Fiscal Services Division 505,600.00 505,600.00 505,600.00 Central Services - Support Services 321,950,00 321,950.00 321,950.00 Human Resources HHS - Administration HHS - Health Division 4,267,834.00 4,267,834.00 4,306,834.00 FIRS - Children's Village 3,189,200.00 3,264,600.00 4,089,600.00 HHS - Homeland Security 0.00% Public Services - Community Corrections 190,000.00 190,000.00 190,000.00 0.00% Public Services - MSU Extension 0.00% Public Services - Medical Examiner 339,000.00 339,000.00 305,000.00 (34,000.00) -10.03% Unfav. Autopsies due to less than anticipated need. Public Services - Animal Control 913,200.00 1,090,519.00 1,108,019.00 17,500.00 1.60% Fast. Animal Sterilization Fees $12,300 and Pound Fees 82,400 due to initiatives to place animals in forever homes. Also, fay. Fee Income $2,000 due to citation tickets. 28 COUNTY OF OAKLAND GENERAL FUND GENERAL PURPOSE REVENUES FY 2018 SECOND QUARTER REPORT Public Services - Circuit Court Probation Economic Dev. & Comm. Affairs - Admin Economic Dev. & Comm. Affairs - PEDS Total County Executive Non-Departmental Non-Dept - Charges for Services Total Non-Departmental AMOUNT FY 2018 FAVORABLE FORECAST UNFAVORABLE) (24,000.00) 441,225.00 $ 13,717,699.00 $ 13,970,418.00 $ 14,833,018.00 8 862,600.00 716,812.00 716,812.00 716,812.00 718,812.00 716,812.00 $ 716,812.00 8 PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 0.00% -100.00% Unfav. Seminars/Conferences revenue for Business Roundtable which will not occur in FY2018. 0.00% 6.17% 0.00% 0.00% ADOPTED AMENDED BUDGET BUDGET 24,000.00 24,000.00 441.225.00 441,225.00 Total Charges for Services $ 110,083,318,00 $ 111,498,717.00 $ 114,349,217.00 $ 2,850,500.00 2.55% INDIRECT COST RECOVERY (640100) $ 8,134,737.00 $ 8,134,737.00 $ 8,134,737.00 0.00% INVESTMENT INCOME 1655000-655999) District Courts (Div, I - IV) Sheriff Corrective Services Sheriff Investigative/Technical Services Treasurer Clerk/Register of Deeds Economic Development Non-Departmental Total Investment Income OTHER REVENUES 1670000-695500) Circuit Court-Donations Circuit Court-County Auction Circuit Court District Courts (Div. I - IV) Probate Court Prosecuting Attorney Sheriff Office 100,000,00 2,200.00 $ 100,000.00 2,200.00 $ 100,000.00 2,200.00 $ 0,00% 0.00% 0.00% 0.00% 2,500,00 2,500.00 22,000.00 19,500.00 780.00% Fav. due to investment base and market rate adjustment. 1,800,000.00 1,800,000.00 1,800,000.00 $ 1,904,700.00 $ 1,904,700.00 $ 1,924,200.00 $ 19,500,00 0.00% 0,00% 1.02% 0,00% 0.00% 0,00% 0.00% 0.00% 0.00% 5,000.00 5,000.00 5,000.00 0.00% Sheriff -Administrative Services 0.00% Sheriff - Corrective Services 0.00% Sheriff - Corrective Services-Satellites 0.00% Sheriff - Emergency Rasp and Prepare 0.00% Sheriff - Patrol Services 6,000.00 6,000.00 6,000.00 0.00% Sheriff - Emergency Communications Operations 0,00% 29 COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2018 SECOND QUARTER REPORT AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 17,484.00 100.00% Fav. Refund of Prior Years Expenditures $16,480 for reimbursement of Sheriff's overtime and Adjustment Prior Years Revenue $1,004 High Intensity Drug Trafficking Area (HIDTA) prior year reimbursement. 0.00% 0.00% 0,00% 0.00% 0.00% 0.00% 0.00% 2,500.00 416.67% Fav. Prior Years Revenue due to receipt of FY 2017 Vending Machine Commission payment higher than anticipated. 0.00% 0.00% 0.00% 320,100.00 100.00% Fav. Prior Years Revenue $319,700 due to correction of FY 2017 estimated administrative overhead cost distribution. 0.00% 0.00% ADOPTED AMENDED FY 2018 BUDGET BUDGET FORECAST Sheriff - Investigative/Forensic Svc 17,484.00 Clerk/Register of Deeds Treasurer Board of Commissioners Library Board Water Resources Commissioner County Exec - Compliance Office Management and Budget - Fiscal Services Central Services - Support Services Human Resources Facilities Management Engineering Health Division - Contributions Health Division Health Division - Transfers In Children's Village 600.00 600.00 3,100.00 320,100.00 Children's Village - Transfers In 813.00 813.00 0.00% Homeland Security 0.00% Public Services - Medical Examiner 0.00% Public Services - Animal Control-Other Revenues 0.00% Public Services - Animal Control-Transfers In 0.00% Economic Development & Comm Affairs - Other 0,00% Economic Development - Contributions 29,240.00 60,240.00 60,240,00 0.00% Non Departmental - Donations Non-Dept - Sundry Sheriffs' Transfers In 0,00% 417,500.00 417,500.00 417,500.00 - 0.00% 31,957,00 102,579.00 89,249.00 (13.330.00) -12.99% Unfav. due to Transfer In budget occurring beyond life of budget amendments for MR #13315 ($9,430) and MR #14177 ($3,900) 30 COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2018 SECOND QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST f UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Treasurers' Transfers 2,600,000.00 2,600,000.00 2,600,000.00 0.00% Non-Departmental - Transfers In 6,000,000.00 6,000,000.00 6,000,000.00 0.00% Total Other Revenues 9,090,297.00 $ 9,192,732.00 9,519,486.00 $ 326,754.00 3.55% PLANNED USE OF FUND BALANCE (665000-665999) Encumbrances and Carry forwards Use of Prior Yrs Fund Balance Total Planned Use of Fund Balance 33,122,397.D0 33,122,397.00 5,039,686.21 44,506,765.00 49,546,471.21 5,039,686.21 44506,765.00 $ 49,546,471.21 $ 0.00% 0.00% 0.00% TOTAL GEN. FUND! GEN. PURPOSE REVENUE $ 454,982,525.00 $ 474,752,362.21 $ 477,433,078.21 $ 2,680,716.00 0.56% 31 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 475,000.00 155,000.00 7,500.00 175,000.00 25,000.00 (75,000.00) Judicial Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out Business Division Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 9,342,100.00 $ 9,342,100.00 $ 8,867,100.00 5 110,876.00 449,900.00 294,900.00 401,464.00 503,327.00 495,827.00 $ 9,854,440.00 $ 10,295,327.00 $ 9,657,827.00 $ $ 1,783,372.00 5 1,783,372.00 $ 1,608,372.00 $ 131,834.00 131,834.00 106,834.00 164,842.00 164,842.00 239,842.00 5.08% - Fav. due to underfilled and vacant positions. 34.45% Fay. Expendable Equipment $125,000 due to lower than anticipated use. Fay. Special Projects $85,000 due to the distribution of Judicial Technology funds from the State and Judge On-Line project (MR #09017) used for courtroom technology improvements. Partially offset by unfav. Library Continuations ($55,000) due to higher than anticipated use. 1.49% - Fay. Info Tech CLEMIS due to lower than anticipated use. 0.00% 9.81% - Fay. due to underfilled and vacant positions. 18.96% - Fay. Visiting Judges due to lower than anticipated use. -45.50% - Unfav. Info Tech Operations due to higher than anticipated use. 637,500.00 6.19% $ 2,080,048.00 $ 2,080,048.00 5 1,955,048.00 $ 125,000.00 6.01% (20,000.00) -1.06% - Unfav. due to overfilled positions as well as an Emergency Salary position that is being charged to this division but not budgeted. 1,675,000.00 28.07% - Fay. Defense Atty Fees $675,000 and Defense Atty Fees Trials $475,000 due to increased budget allocation as a result of prior year carryforward for Juveniles to Life Without Parole (JLWOP). Fay. Juror Fees and Mileage $300,000 along with Attorney Fees Mediators $100,000 due to lower than anticipated use. Fay. Defense Atty Fees Appellate $125,000 due to decline in requests for appointed counsel. 255,000.00 9.63% - Fay. Info Tech Operations $275,000 due to lower than anticipated use. Partially offset by unfav. Equipment Rental ($10,000) and Info Tech CLEWS ($10,000) due to higher than anticipated use. Civil / Criminal Division Personnel Expenditures $ 1,883,613.00 $ 1,883,613.00 $ 1,903,613.00 $ Operating Expenditures 5,187,688.00 5,968,094.00 4,293,094.00 Internal Support Expenditures 2,359,256.00 2,648,822.00 2,393,822.00 Transfers Out $ 9,430,557.00 $ 10,500,529.00 $ 8.590,529.00 $ 1,910,000.00 18.19% 32 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 11,746,860.00 $ 11,746,860.00 $ 11,196,860.00 $ 12,743,184.00 12,743,184.00 8,618,184.00 1,795,544.00 1,795,774.00 1,895,774.00 5,246,653.00 4,984,318.00 4,984,318.00 $ 31,532,241.00 $ 31,270,136,00 $ 26,695,136.00 $ 550,000.00 4.68% - Fay. due to underlined and vacant positions. 4,125,000.00 32.37% - Fay. due to decrease in placements to State Institutions $3,500,000 and Priv Institutions Residential $500,000. Fav. Professional Services $125,000 due to lower than anticipated use. Offset by unfavorable Non-Dept Child Care Subsidy Revenue (50% Reimbursement). (100,000.00) -5.57% - Unfav. Info Tech Operations due to higher than anticipated use. 0.00% - 4,575,000.00 14.63% Family Division/Juvenile Maint. Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out 1,180,000.00 5,980,000.00 87,500.00 Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 24,755,945.00 18,173,582.00 4,721,106.00 5,246,653.00 $ 24,755,945.00 $ 19,293,012.00 5,112,765.00 4,984,318.00 23,575,945.00 $ 13,313,012.00 5,025,265.00 4,984,318.00 4.77% 31.00% 1.71% 0.00% $ 52,897,286.00 $ 54,146,040.00 $ 46,898,540.00 $ 7,247,500.00 13.39% 33 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT FY 2018 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ADOPTED AMENDED BUDGET BUDGET 226,703.00 $ 2,800.00 1,935.00 District Court Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 236,703.00 $ 236,703.00 $ 10,300.00 10,300.00 1,935.00 1,935.00 10,000.00 4.22% - Fay, due to turnover and underfilled positions/vacancies. 7,500.00 72.82% Fay. Visiting Judges due to lower than anticipated use. 0.00% 0.00% $ 248,938.00 $ 248,938.00 $ 231,438.00 $ 17,500.00 7.03% Division 1 - Novi Personnel Expenditures $ 4,314,794.00 $ 4,314,794.00 $ 4,189,794.00 125,000.00 2.90% - Fay. due to turnover and under5Iled positions/vacancies. Operating Expenditures 1,021,191.00 1,021,191.00 991,191.00 30,000.00 2.94% - Fay. Defense Attorney Fees $12,500 due to restructured scheduling improvements and efforts to contain costs. Fay. Medical Exam $7,500 due to lower than anticipated use. Fay. Office Supplies $5,000 and Postage-Standard Mailing $5,000 due to continued efforts to minimize expenses and contain costs. Internal Support Expenditures 355,641.00 377,555.00 362,555.00 15,000.00 3.97% - Fay. Info Tech Operations $10,004 and Telephone Communications $5,000 due to lower than anticipated use. Transfers Out - - 0.00% - Total Division 1 - Novi $ 5,691,626.00 $ 5,713,540.00 $ 5,543,540.00 $ 170,000.00 • 2.98% Division 2 - Clarkston Personnel Expenditures $ 2,202,500.00 $ 2,202,500.00 $ 2,127,500.00 75,000.00 3.41% - Fay. due to turnover and underfilleci positions/vacancies. Operating Expenditures 648,811.00 648,811.00 623,811.00 25,000.00 3.85% Fav. Defense Attorney Fees due to restructured schedule for defense attorneys. Internal Support Expenditures 199,833.00 222,012.00 217,012.00 5,000.00 2.25% - Fav. Info Tech Operations due to lower than anticipated use. Transfers Out 0.00% - Total Division 2 - Clarkston $ 3,051,144.00 $ 3,073,323.00 $ 2,968,323,00 $ 105,000.00 3.42% Division 3 - Rochester Hills Personnel Expenditures Operating Expenditures $ 4,079,798.00 $ 4,079,798.00 $ 3,879,798.00 416,733.00 416,733.00 366,733,00 200,000.00 50,000.00 4.90% Fav. due to turnover and underfilled positions. 12.00% Fav. Office Supplies $20,000 along with Juror Fees and Mileage $15,000 due to continued efforts to minimize expenses and contain costs. Fay. Defense Attorney Fees $15,000 due to a decrease in requests for appointed counsel. Internal Support Expenditures 814,425.00 836,510.00 836,510,00 0.00% Transfers Out 0.00% $ 5,310,956.00 $ 5,333,041.00 $ 5,083.041.00 $ 250,000.00 4.69% 34 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Division 4 - Troy Personnel Expenditures Operating Expenditures Internal Support Expenditures Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 2,384,376.00 $ 2,384,376,00 $ 2,359,376.00 526,388.00 530,307.21 565.307.21 254,844.00 256,827.00 251,827.00 $ 3,165,508.00 $ 3,181,510.21 $ 3,175,510.21 $ $ 13,218,171.00 $ 13,216,171.00 $ 12,783,171.00 $ 2,623,423.00 2,627,342.21 2,549,842.21 1,626,678.00 1,704,839.00 1,669,839.00 25,000,00 1.06% - Fay. due to turnover and undeitlied positions/vacancies. (35,000.00) -6,60% - Linty. Defense Attorney Fees ($50,000) due to an increase in requests for appointed counsel. Partially offset by fav. Electrical Service $15,000 due to lower than anticipated use. 15,000.00 5.62% - Pay. info Tech Operations $10,000 and Equipment Rental $5,000 due to lower than anticipated use. 5,000.00 0,16% 435,000.00 3.29% 77,500.00 2.95% 36,000.00 2.05% $ 17,468,272.00 $ 17,550,352.21 $ 17,002,852.21 $ 547,500.00 3.12% 35 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES PROBATE COURT AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES --- Judicial/Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out $ 2,399,017.00 $ 2,399,017.00 $ 2,274,017.00 $ 125,000.00 29,481.00 29,481,00 26,981.00 2,500.00 284,930.00 289,080.00 284,080.00 5,000,00 521% Fay. due to turnover and underfilled positions/vacancies. 8.48% Fay. Library Continuations $5,000; Court Reporter Services $2,500; Membership Dues $2,000 due to lower than anticipated use. Partially offset by unfav. Visiting Judges ($7,000) due to an extended leave of absence by current sitting judge. 1.73% Fay. Info Tech Operations due to less than anticipated use. $ 2,713,428.00 $ 2,717,578.00 $ 2,585,078.00 $ 132,500.00 4.88% $ 2,293,622.00 $ 2,293,622.00 $ 2,118,622.00 $ 175,000.00 7.63% Fay. due to turnover and underfilled positions/vacancies. 781,943.00 781,943.00 851,943.00 (70,000.00) -8.95% Unfav. Defense Attorney Fees ($30,000); Fees Guardian Ad Litem ($25,000); and Medical Services Guardianship ($15,000) due to an increased number of case filings and continued high demand for these services. 633,270.00 654,830.00 589,830.00 65,000.00 9.93% Fav. Info Tech Operations $35,000 due to less than anticipated use. Fay. Equipment Rental $30,000 based on actual usage. $ 3,708,835.00 $ 3,730,395.00 $ 3,560,395.00 $ 170,000.00 4.56% Estates/Mental Health Personnel Expenditures Operating Expenditures Internal Support Expenditures Department Total Personnel Expenditures $ 4,692,639.00 $ 4,692,639.00 $ 4,392,639.00 $ Operating Expenditures 811,424.00 811,424.00 878,924.00 Internal Support Expenditures 918,200.00 943,910.00 873,910.00 Transfer Out - - - 300,000.00 6.39% (67,500.00) -8.32% 70,000.00 7.42% $ 6,422,263.00 $ 6,447,973.00 $ 6,145,473.00 $ 302,500.00 4.69% 36 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 2,354,441.00 $ 2,354,441.00 $ 2,297,441.00 $ 57,000.00 2A2% Fay, due to vacant positions. Operating Expenditures 515,213.00 515,213.00 500,213.00 15,000.00 2.91% Fay. Printing $20,000, Witness Fees and Mileage $15,000, Training $14,000, Travel & Conference $12,000, Filing Fees $10,000, Professional Services $8,000, Security Supplies $5,000 and Personal Mileage $4,000 due to less than anticipated use; partially offset by unfav. Library Continuations ($60,000) and Extradition Expense ($12,000) due to usage. 102,000.00 5.19% Fav. Info Tech Operations $80,000, Motor Pool $17,000 and Telephone Communications $4,000 due less than anticipated use. 0.00% $ 4.797,511.00 $ 4,900,400.00 $ 4,726,400.00 $ 174,000.00 3.55% $ 10,603,067.00 $ 10,603,067.00 $ 9,903,067.00 $ 700,000.00 6.60% Fay, due to underfilled positions and positions assigned to this division but actually working across divisional disciplines. 33,296.00 33,296.00 27,296.00 6,000.00 18.02% Fav. Personal Mileage $7,000 due to less than anticipated use; partially offset by unfav. Clothing Allowance ($1,000) due to increased use. Internal Support Expenditures Transfers Litigation Personnel Expenditures Operating Expenditures 1,927,857.00 1,963,746.00 1,861,746.00 67,000.00 67,000.00 Internal Support Expenditures 112,538.00 112,538.00 112,538.00 0.00% Transfers Out 975,027.00 975,027.00 775,027.00 200,000.00 20.51% Fay, due to lower Cooperative Reimbursement Prosecutor grant match $ 11,723,928.00 $ 11,723,928.00 $ 10,817,928.00 $ 906,000.00 7.73% Warrants Personnel Expenditures $ 2,248,109.00 $ 2,248,109.00 $ 2,118,109.00 $ 130,000.00 5.78% Fav. due to turnover, underfilled positions and positions assigned to this division but actually working across divisional disciplines. Operating Expenditures 3,199.00 3,199.00 3,199.00 0.00% 37 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Internal Support Expenditures 24,081.00 24,1381.00 24,081.00 0.00% $ 2,275,389.00 $ 2,275,389.00 $ 2,145,389.00 $ 130,000.00 $ 1,891,047.00 $ 1,891,047.00 $ 1,791,047.00 $ 100,000.00 8,458.00 8,458.00 3,458.00 5.000.00 17,737.00 17,737.00 17,737.00 $ 1,917,242.00 $ 1,917,242.00 $ 1,812,242.00 $ 105,000.00 5.71% 5.29% Fay, due to turnover, undefined positions and positions assigned to this division but actually working across divisional disciplines. 59.12% Fav. Personal Mileage due to less than anticipated use. 0.00% 5.48% Appellate Personnel Expenditures Operating Expenditures Internal Support Expenditures Department Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 17,096,664.00 560,166.00 2,082,213.00 975,027.00 $ 17,096,664.00 560,166.00 2,118,102.00 1,042,027.60 $ 16,109,664.00 534,166.00 2,016,102.00 842,027.00 987,000.00 26,000.00 102,000.00 200,000.00 5.77% 4.64% 4.82% 19.19% $ 20,714,070.00 $ 20,816.959.00 $ 19,501,959.00 $ 1,315,000.00 6.32% 38 $ 2,578,260.00 $ 2,577,760.00 $ 2,492,760.00 $ 85,000.00 3.30% Fay. due to vacancies, turnover and underfills; offset in other divisions. Fay. Office Supplies $30,000 Uniform Cleaning $20,000, Indigent Orders $10,000 and Postage-Standard Mailing $5,000 due to less than anticipated use; partially offset by unfav, Library Continuations ($5,000) due to usage. Unfav. Info Tech Ops ($47,000) and Info Tech Managed Print Svcs ($7,000) due to usage; partially offset by fav. Telephone Communications $4,000 and Radio Communications $3,000 due to less than anticipated use. 185.00 185.00 0.00% $ 4,095,881.00 $ 4,119,738.86 $ 3,906,738.86 $ 213,000.00 5.17% 31,674,994.00 $ 31,674,994.00 $ 31,099,994.00 575,000.00 1.82% Fay. Salaries and Fringe Benefits $2,780,000 as a result of a large number of vacancies, officers in the academy and officers in training; partially offset by unfav. Overtime ($2,205,000). Hiring, training and filling-in for deputies is the major factor contributing to the use of overtime; offset in other divisions. Administrative Services Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Corrective Services Personnel Expenditures $ 2,324,558.00 $ 2,324,558.00 $ 2,124,558.00 200,000.00 8.60% 1,692,738.00 1,716,410.86 1,656,410.86 60,000.00 3.50% 78,585.00 78,585.00 125,585.00 (47,000.00) -59.81% COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE ADOPTED BUDGET AMENDED BUDGET FY 2018 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Sheriffs Office Personnel Expenditures Operating Expenditures $ 1,858,505.00 $ 1,858,505.00 $ 1,778,505.00 $ 80,000.00 75,736.00 75,236.00 65,236.00 10,000.00 4.30% Fay. due to vacancies and turnover; offset in other divisions, 13.29% Fay. Office Supplies $13,000 and Contracted Services $7,000 due to less than anticipated use. Partially offset by unfav. Communications ($10,000) due to usage. Internal Support Expenditures 644,019.00 644,019.00 649,019.00 (5,000.00) -0.78% Unfav. Info Tech Ops ($7,000) and Info Tech Managed Print Svcs ($2,500) due to usage; partially offset by Fav. Telephone Communications $3,000 and Motor Pool $1,500 due to less than anticipated use. Transfers Out 0.00% 4.14% Fay. Contracted Services $200,000 due to food and clinic contracts, Prisoner Housing Outside of County $75,000, Transportation of Prisoners $10,000, Bedding and Linen $10,000, Laundry and Cleaning $9,000, Groceries $8,000 and Provisions $8,000 due to less than anticipated use. Operating Expenditures 7,741,746.00 7,978,510.34 7,648,510.34 330,000.00 39 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE Internal Support Expenditures Transfers Out AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES - - — 7,968,097.00 8,186,050.00 7,636,050.00 550,000.00 6.72% Fay. Info Tech Ops $596,000 due to less than anticipated use; partially offset by unfav. Radio Communications ($24,000) and Motor Pool ($23,000) due to usage. 0.00% Corrective Services-Satellites Personnel Expenditures $ 47,384,837.00 $ 47,839,554.34 $ 46,384,554.34 $ 1,455,000.00 3.04% $ 13,734,940.00 $ 13,759,081.00 $ 16,769,081.00 $ (3,000,000.00) -21.79% Unfav. primarily due to Overtime ($1,800,000) at the Corrective Services Satellite facilities caused by circuit court security, vacant positions, prisoner transport, employee disability and other leaves. Also unfav. Salaries ($600,000) due to overfilled positions and unfav. Fringe Benefits ($600,000) related to overtime. Hiring, training and retaining Corrections Deputies and filling-in for deputies on disability has been a major factor contributing to the high use of overtime. Operating Expenditures Internal Support Expenditures Transfers Out 126,494.00 1,275,010.00 128,778.00 1,277,992.00 12,800.00 78,778.00 1,325,992.00 12,800.00 50,000.00 38.83% Fay. Deputy Supplies $20,000, Uniforms $15,000, Laundry and Cleaning $10,000 due to less than anticipated use and Equipment Maintenance $5,000 due to recent equipment replacement. (48,000.00) -3.76% Unfav. Info Tech Ops ($56,000) due to usage; partially offset by fay. Motor Pool Fuel Charges $9,000 due to less than anticipated use. 0.00% $ 15,136,444.00 $ 15,188,651.00 $ 18,186,651.00 $ (2,998,000.00) -19.74% Emergency Response and Preparedness Personnel Expenditures $ 2,373,876.00 $ 2,412,860.00 $ 2,287,860.00 $ 125,000,00 5.18% Fay. Due to vacancy and underfills; offset in other divisions. Operating Expenditures 623,457.00 623,457.00 403,457.00 220,000.00 35.29% Fay. Fees Civil Service $200,000 due to continuing decline in the number of home foreclosures and civil service requests (see corresponding unfavorabihty in Civil Action Service Fee revenues) and Employees Medical Exams $20,000 due to less than anticipated use. 40 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ----- ---------- -------- ----- ------ ----------- Internal Support Expenditures Transfers Out Patrol Services Personnel Expenditures 90,378.00 114,157.00 131,157.00 (17,000.00) -14.89% Unfav. Telephone Communications ($17,000), and Info Tech Managed Print Svcs ($15,000) due to usage; partially offset by fay. info Tech Ops $13,000 and Radio Communications $2,000 due to less than anticipated use. 0.00% $ 3,087,711.00 $ 3,150,474.00 $ 2,822,474.00 $ 328,000.00 10.41% $51,496,688 $ 52,294,667.00 $ 50,719,667.00 $ 1,575,000.00 3.01% Fay. due to Salaries and Fringe Benefits as a result of vacancies and turnover; offset in other divisions. Operating Expenditures 979,054.00 946,519.00 821,519.00 125,000.00 13.21% Fay. Uniforms $50,000, Equipment Rental $40,000, Deputy Supplies $13,000, Gasoline Charges $9,000 and Office Supplies $4,000 due to less than anticipated use. Internal Support Expenditures 5,284,973.00 5,514,716.00 5,909,716.00 (395,000.00) -7.16% Unfav. Info Tech Ops ($203,000), Motor Pool ($157,000), Info Tech CLEMIS ($74,000) and Equipment Rental ($29,000) due to usage; partially offset by fay. Motor Pool Fuel Charges $51,000 and Radio Communications $19,000 due to less than anticipated use. Transfers Out 788.00 274,815.00 274,815.00 0.00% $ 57,761,503.00 $ 59,030,717.00 $ 57,725,717.00 $ 1,305,000.00 2.21% Emergency Communications Operations Personnel Expenditures $ 7,995,971.00 $ 8,191,262.00 $ 9,191,262.00 $ (1,000,000.00) -12.21% Unfav. due to Overtime and associated Fringe Benefits from vacant positions and turnover. Operating Expenditures 160,215.00 226,501.00 186,501.00 40,000.00 17.66% Fav. Equipment Maintenance $35,000 due to recent equipment replacement. Also fay. Uniforms $6,000 due to less than anticipated use. Internal Support Expenditures 148,159.00 148,159.00 171,159.00 (23,000.00) -15.52% Unfav. Info Tech Ops ($39,000) and Radio Communications ($3,000) due to usage; partially offset by fay. Telephone Communications $11,000 and Info Tech Managed Print Services $8,000 due to less than anticipated use. Transfers Out 0.00% $ 8,304,345.00 $ 8,565,922.00 $ 9,548,922.00 $ (983,000.00) -11.48% 41 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES SHERIFFS OFFICE AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES InvestigativelForensic Svcs Personnel Expenditures $ 9,099,524.00 $ 9,099,524.00 $ 9,179,524.00 $ (80,000.00) -0.88% Unfav. Overtime due to workload. 130,000.00 14.56% Fay. Contracted Services $70,000, Evidence Fund NET $60,000, Software Support Maintenance $20,000, Equipment Rental $12,000, Extradition Expense $10,000 and Fingerprint Supplies $10,000 due to less than anticipated use; partially offset by unfav. Material and Supplies ($50,000) used in RESULTS testing and offset in Drug Testing revenue. (50,000.00) -1.89% Unfav. Info Tech Operations (168,000) due to usage; partially offset by Fay. Motor Pool $81,000, Motor Pool Fuel charges $32,000, and Telephone Communications $4,000 due to less than anticipated use. Operating Expenditures 764,882.00 893,084.06 763,084.06 Internal Support Expenditures 2,643,264.00 2,650,173.00 2,700,173.00 Transfers Out 334,086.00 602,024.00 602,024.00 0.00% $ 12,841,756.00 $ 13,244,805.06 $ 13,244,805.06 $ 0.00% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 120,559,056.00 $ 12,164,322.00 $ 18,132,485.00 $ 334,874.00 $ 121,625,451.00 $ 12,588,496.26 $ 18,613,851_00 889,824.00 $ 123,150,451.00 $ 11,623,496.26 $ 18,648,851.00 $ 889,824.00 $ (1,525,000_00) $ 965,000.00 $ (35,000.00) -1.25% 7.67% -0.19% 0.00% $ 151,190,737.00 $ 153,717,622.26 $ 154,312,622.26 $ (595,000.00) -0.39% 42 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 800,086.00 $ 800,086.00 $ 700,086.00 $ 100,000.00 12.50% Fay. due to vacant position. Operating Expenditures 34,900.00 34,900.00 25,000.00 9,900.00 28.37% Fav. Printing $4,900, Office Supplies $4,000 and Expendable Equipment $1,000 due to less than anticipated use. Internal Support Expenditures 60,359.00 60,359.00 60,359.00 0.00% Transfers Out 0.00% $ 895,345.00 $ 895,345.00 $ 785,445.00 $ 109,900.00 12.27% County Clerk (Vital Stats & Legal Rec's) Personnel Expenditures $ 3,652,076.00 $ 3,652,076.00 $ 3,352,076.00 $ 300,000.00 8.21% Fay. due to vacancies, turnover and underfilled positions. Operating Expenditures Internal Support Expenditures Transfers Out 279,160,00 698,799.00 279,160.00 188,760.00 872,131.00 872,131.00 90,400.00 32.38% Fay. Professional Services $33,600 and Office Supplies $20,200 due to less than anticipated use. Also favorable Court Transcripts $23,500 due to prosecutors ordering fewer transcripts; Printing $11,100, Membership Dues $3,200, and Equipment Maintenance $1,500 due to less than anticipated use. Partially offset by unfavorable Metered Postage ($10,600) due to increased rate change and increased activity. 0.00% 0.00% $ 4,630,035.00 $ 4,803,367.00 $ 4,412,967.00 $ 390,400.00 8.13% 43 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Elections Personnel Expenditures Operating Expenditures $ 871,829.00 $ 871,829.00 $ 785,029.00 $ 779,078.00 779,078.00 744,378.00 86,800.00 9.96% Fav. due to turnover and underfilled positions. 34,700.00 4.45% Fav. Fees - Per Diem $25,500, Materials and Supplies $4,200, Travel and Conference $2,600, and Charge Card Fee $1,800 due to reduced activity. Internal Support Expenditures 294,662.00 307,085.00 307,085.00 0.00% Transfers Out 0.00% $ 1,945,509.00 $ 1,957,992.00 $ 1,836,492.00 $ 121,500.00 6.21% Register of Deeds (and Micrographics) Personnel Expenditures $ 2,664,429.00 $ 2,664,429.00 $ 2,387,229.00 $ 277,200.00 Operating Expenditures 271,494.00 271,494.00 $ 168,494.00 103,000.00 10.40% Fay. due to vacancies, turnover and underfilled positions. 37.94% Fay. Metered Postage $31,000, Materials and Supplies $27,700, Professional Services $24,000, Office Supplies $21,600, Expendable Equipment $6,000, Printing $2,800, and Travel and Conference $1,000 due to less than anticipated use. Partially offset by Maintenance Contract ($10,200) and Charge Card Fees ($1,000) due to increased activity. Internal Support Expenditures 259,611.00 260,413.00 $ 260,413.00 0.00% Transfers Out 0.00% $ 3,195,534.00 $ 3,196,336.00 $ 2,816,136.00 $ 380,200.00 11.89% 44 ADOPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT FY 2018 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 15,383.00 $ 68,776.00 64.00 15,383.00 $ 68,776.00 215.00 2,107.00 $ 13,276.00 86.30% Fay. due to underfilled position. 48,776.00 20,000.00 215.00 Jury Commission Personnel Expenditures Operating Expenditures Internal Support Expenditures 29.08% Fay. Metered Postage $16,700, Printing $2,300 and Miscellaneous $1,000 due to less than anticipated use. 0.00% $ 84,223.00 $ 84,374.00 $ 51,098.00 $ 33,276.00 39.44% Department Total Personnel Expenditures $ 8,003,803.00 $ 8,003,803.00 $ 7,226,527.00 $ 777,276.00 911% Operating Expenditures 1,433,408.00 1,433,408.00 1,175,408.00 $ 258,000.00 18.00% Internal Support Expenditures 1,313,495.00 1,500,203.00 1,500,203.00 $ - 0.00% Transfers Out - - - 0.00% ----------- ---------- ----------- --------- $ 10,750,706.00 $ 10,937,414.00 $ 9,902,138.00 $ 1,035,276.00 9.47% 45 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES COUNTY TREASURER AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures 5 3,443,735.00 $ 3,443,735.00 5 3,254,435.00 $ 189,300.00 5.50% - Fay. um:left-ills and vacant positions. Operating Expenditures 4,512,105.00 4,512,105.00 3,557,405.00 954,700.00 21.16% - Fay. Title Search $793,800, Fees Civil Service $275,000, Office Supplies $10,000, Metered Postage $9,200, Twp & City Treas Bonds $7,000, Membership Dues $3,200, Rent $2,500, Personal Mileage $2,000, and Tax Collection Supplies $1,400 due to less than anticipated use. Partially offset by unfavorable Recording Fee Redemption Certificate ($100,000) due to properties withdrawing from foreclosure and Recording Fee Forfeiture Certificate ($40,000) due to properties entering second year of delinquency. Register of Deeds ($9,400) due to an increase in statutory fees for recording deeds. Internal Support Expenditures 777,694.00 924,009.00 873,409.00 50,600.00 5.48% - Fay. Primarily due to Info Tech Operations $48,500 and Info Tech Managed Print Services $2,100 due to less than anticipated use. Transfers Out 120,000.00 120,000.00 120,000.00 0.00% Division Total $ 8,853,534.00 $ 8,999,849.00 5 7,805,249,00 $ 1,194,600.00 13.27% Department Total $ 8,853,534.00 $ 8,999,849.00 5 7,805,249.00 5 1,194,600.00 13.27% 46 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES BOARD OF COMMISSIONERS AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 2,264,759.00 $ 2,264,759.00 $ 2,254,759.00 $ 10,000.00 0.44% - Favorable due to vacancy, turnover, and underfilled positions. Operating Expenditures 614,190.00 681,490.00 $ 641,490.00 40,000.00 5.87% - Favorable Workshops and Meeting $16,000, Personal Mileage $8,000, Legal Services $6,000, Legislative Expense $4,000, Professional Services-Annual Audit $4,000 and Printing $3,000 due to less than anticipated use. Internal Support Expenditures 214,137.00 247,989.00 $ 247,959.00 0.00% - $ 3,093,086.00 $ 3,194,238.00 $ 3,144,238.00 $ 50,000.00 1.57% Department Total Personnel Expenditures $ 2,264,759.00 $ 2,264,759.00 $ 2,254,759.00 $ 10,000.00 0.44% Operating Expenditures 614,190.00 681,490.00 641,490.00 40,000.00 5.87% Internal Support Expenditures 214,137,00 247,989.00 247,989.00 0.00% $ 3,093,056.00 $ 3,194,238.00 $ 3,144,235.00 $ 50,000.00 1.57% 47 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES LIBRARY BOARD AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES M•••n••n•••... Library Board Personnel Expenditures $ 510,599.00 $ 510,599.00 $ 510,599.00 $ 0.00% Operating Expenditures 383,333.00 383,333.00 380,533.00 2,800.00 0.73% Favorable Computer Research Service $3,000 and Workshops and Meetings $1,200 due to less than anticipated use; partially offset by unfavorable Periodicals Books Publ ($1,400) due to inflationary price increases. Internal Support Expenditures 474,669.00 483,903.00 483,903.00 0.00% Transfers $ 1,368,601.00 $ 1,377,835.00 $ 1,375,035.00 $ 2,800.00 0.20% Department Total Personnel Expenditures $ 510,599.00 $ 510,599.00 $ 510,599.00 $ 0.00% Operating Expenditures 383,333.00 383,333.00 380,533.00 2,800.00 0.73% Internal Support Expenditures 474,669.00 483,903.00 483,903.00 0.00% Transfers $ 1,368,601.00 $ 1,377,835.00 $ 1,375,035.00 $ 2,800.00 0.20% 48 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES WATER RESOURCES COMMISSIONER AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Water Resource Commissioner Personnel Expenditures $ 224,606.00 $ 224,606.00 $ 224,606.00 $ 0.00% Operating Expenditures 487,975.00 487,975.00 487,975.00 0.00% Internal Support Expenditures 5,970,144.00 6,135,739.00 6,135,739.00 0.00% Transfers 56,165.00 87,685.00 87,685.00 0.00% Division Total $ 6,738,890.00 $ 6,936,005.00 $ 6,936,005.00 $ 0.00% Department Total $ 6,738,800.00 $ 6,936,005.00 $ 6,936,005.00 $ 0.00% 49 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES COUNTY EXECUTIVE AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 2,278,720.00 $ 2,278,720.00 2,278,720.00 $ 0.00% Operating Expenditures 277,991.00 277,991.00 275,391.00 2,600.00 0.94% Fay. Printing $15,000, Metered Postage $7,000 and Personal Mileage $2,000 due to less than anticipated use; partially offset by unfavorable Professional Services ($12,000), Special Projects ($8,000), and Periodicals Books Publ Sub ($1,400) due to increased activity. Internal Support Expenditures 431,227.00 450,886.00 450,886.00 0.00% $ 2,987,938.00 $ 3,007,597.00 $ 3,004,997.00 $ 2,600.00 0.09% Compliance Office Personnel Expenditures $ 1,700,887.00 $ 1,700,887.00 $ 1,700,887,00 $ 0.00% Operating Expenditures 49,252.00 49,252.00 44,252.00 5,000.00 10.15% Fay. Professional Services $5,000 due to less than anticipated use. Internal Support Expenditures 185,071.00 197,572.00 197,572.00 0,00% $ 1,935,210.00 $ 1,947,711.00 $ 1,942,711.00 $ 5,000.00 0.26% Corporation Counsel Personnel Expenditures $ 2,532,651.00 $ 2,532,551.00 $ 2,522,551.00 $ 10,000,00 0.39% Fay. due to vacancies and underlined positions. Operating Expenditures 87,333.00 87,333.00 86,333.00 1,000.00 1.15% Fay. Computer Supplies due to less than anticipated use. 50 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES COUNTY EXECUTIVE AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Internal Support Expenditures 353,820.00 360,263.00 360,263.00 0.00% $ 2,973,704.00 $ 2,980,147.00 $ 2,969,147.00 $ Department Total Personnel Expenditures $ 6,512,158.00 $ 6,512,158.00 $ 6,502,158.00 $ Operating Expenditures 414,576.00 $ 414,576.00 405,976.00 Internal Support Expenditures 970,118.00 1,008,721.00 1,008,721.00 Transfers Out $ 7,896,852.00 $ 7,935,455.00 $ 7,916,855.00 $ 11,000.00 0.37% 10,000.00 0.15% 8,600.00 2.07% 0.00% 18,600.00 0.23% 51 ADOPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT FY 2018 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 231,432.00 $ 231,432.00 $ 231,432.00 $ 0.00% Operating Expenditures 4,017.00 4,017.00 4,017.00 0.00% Internal Support Expenditures 14,704.00 14,704.00 14,704.00 0.00% $ 250,153.00 $ 250,153.00 $ 250,153.00 $ 0.00% Equalization Personnel Expenditures $ 8,714,164.00 $ 8,714,164.00 $ 8,264,164.00 $ 450,000.00 5.16% Fay. due to vacancies and underfilled positions. Operating Expenditures 431,404.00 453,125.46 388,125.46 65,000.00 14.34% Fay. Personal Mileage $20,000; Printing $20,000; Professional Services $10,000; Office Supplies $10,000; and Membership Dues $5,000 due to less than anticipated activity. Internal Support Expenditures 939,266.00 1,081,449.00 1,081,449.00 0.00% $10,084,834.00 $10,248,738.46 $ 9,733,738.46 $ 515,000.00 5.03% Fiscal Services Personnel Expenditures $ 8,265,954.00 $ 8,265,954.00 $ 7,665,954.00 $ 600,000.00 7.26% Fay. due to vacancies and underfilled positions. Operating Expenditures 383,600.00 383,600.00 364,600.00 $ 19,000.00 4.95% Fay. Metered Postage $20,000; Printing $5,000; and Office Supplies $5,000 due to less than anticipated use. Partially offset by unfav. Expendable Equipment ($11,000) due to greater than anticipated use. Internal Support Expenditures 1,314,860.00 1,550,681.00 1,550,681.00 0.00% $ 9,964,414.00 $ 10,200,235.00 $ 9,581,235.00 $ 619,000.00 6.07% 52 ADOPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT FY 2018 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Department Total Personnel Expenditures $ 17,211,550.00 $ 17,211,550.00 $ 16,161,550.00 Operating Expenditures 819,021.00 840,742.46 756,742.46 Internal Support Expenditures 2,268,830.00 2,646,834.00 2,646,834.00 Transfers Out $ 1,050,000.00 84,000.00 6.10% 9.99% 0.00% 0.00% $ 20,299,401.00 $ 20,699,126.46 $ 19,565,126.46 $ 1,134,000.00 5.48% 53 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES CENTRAL SERVICES 231,349.00 $ 231,349.00 $ 3,298.00 3,298.00 13,941.00 13,941.00 Administrative Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Support Services Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out ADOPTED BUDGET $ 231,349.00 $ 3,298.00 13,941.00 AMOUNT FAVORABLE (UNFAVORABLE) PERCENT AMENDED FY 2018 BUDGET FORECAST 5 248,588.00 $ 248,588.00 $ 248,588.00 $ 5 1,250,374.00 $ 1,250,374.00 $ 1,250,374.00 $ 396,895.00 636,495.00 636,495.00 769,580.00 778,247.00 5 778,247.00 $ 2,416,849.00 $ 2,665,116.00 $ 2,665,116.00 $ $ 1,481,723.00 $ 1,481,723.00 $ 1,481,723.00 $ 400,193.00 639,793.00 639,793.00 783,521.00 792,188.00 792,188.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% EXPLANATION OF SIGNIFICANT VARIANCES $ 2,665,437.00 $ 2,913,704.00 $ 2,913,704.00 $ 0.00% 54 0.00% 876.00 0.38% 0.00% 0.00% (17,000.00) -29.35% Unfav. Info Tech Operations ($17,000). A Second Quarter budget amendment is recommended to adjust Info Tech Operations due to a review of the billing for five computer workstations along with associated software. ADOPTED AMENDED BUDGET BUDGET FY 2018 FORECAST COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES FACILITIES MANAGEMENT AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 213,673.00 $ 213,673.00 $ 213,673.00 $ 0.00% Operating Expenditures Internal Support Expenditures Facilities Engineering Personnel Expenditures Operating Expenditures Internal Support Expenditures 5,764.00 5,764.00 4,888.00 876.00 15.20% Fay. Personal Mileage $600; Periodicals Books Publ Sub $500; and Office Supplies $400 due to continued efforts to minimize expenses and contain costs. Partially offset by unfav. Membership Dues ($624) as a result of more than anticipated usage. 11,271.00 11,271.00 11,271.00 $ 230,708.00 $ 230,708.00 $ 229,832.00 $ $ 865,777.00 $ 865,777.00 $ 865,777.00 $ 225,182.00 232,149.00 232,149.00 53,257.00 57,916.00 74,916.00 $1,144,216.00 $1,155,842.00 $ 1,172,842.00 $ (17,000.00) -1.47% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures $1,079,450.00 $1,079,450.00 $ 230,946.00 237,913.00 64,528.00 69,187.00 1,079,450.00 $ 237,037.00 876.00 86,187.00 (17,000.00) 0.00% 0.37% . -24.57% $1,374,924.00 $ 1,386,550.00 $ 1,402,674.00 $ (16,124.00) -1.16% 55 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES HUMAN RESOURCES AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures 918,095.00 $ 918,095.00 $ 872,695.00 $ 45,400.00 4.95% Fav. due to vacant position. Operating Expenditures 337,622.00 407,622.00 392,322.00 15,300.00 3.75% Fay. Fees- Per Diems $7,000, Metered Postage $6,300, and Printing $2,300 due to less activity. Partially offset by unfavorable Office Supplies ($700) due to increased activity. Internal Support Expenditures 76,511.00 80,800.00 80,800.00 0.00% Transfers Out Workforce Management Personnel Expenditures Operating Expenditures 1,332,228.00 $ 1,797,687.00 $ 377,785.00 1,406,517.00 $ 1,345,817.00 $ 60,700.00 4.32% 1,797,687.00 $ 1,797,687.00 $ 0.00% 550,035.00 445,435.00 104,600.00 19.02% Fay. Recruitment Expense $50,900, Examination Material $19,800, Employees Medical Examination $14,600, Travel and Conference $8,500, Professional Services $3,000, Periodicals Books Publ Sub $2,200, Computer Supplies $2,000, Expendable Equipment $2,000, Equipment Maintenance $1,100, and Membership Dues $1,000 due to less than anticipated use. Partially offset by unfavorable Printing ($1,500) due to increased activity. 69,000.00 10.17% Fay. Info Tech Operations $61,000, Info Tech Managed Print Services $6,500, and Equipment Rental $1,400 due to reduced activity. Internal Support Expenditures Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out 583,023.00 2,715,782.00 $ 715,407.00 659,534.00 678,309.00 2,715,782.00 $ 957,657.00 759,109.00 609,309.00 2,670,382.00 $ 837,757.00 690,109.00 2,758,495.00 $ 3,026,031.00 $ 2,852,431.00 $ -------- 173,600.00 5.74% 45,400.00 1.67% 119,900.00 12.52% 69,000.00 9.09% 4,090,723.00 $ 4,432,548.00 $ 4,198,248.00 $ 234,300.00 5.29% 56 COUNTY OF OAKLAND FY 201B SECOND QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES ADOPTED BUDGET AMENDED BUDGET FY 2018 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 190,507.00 $ 190,507.00 $ 190,507.00 $ 0.00% Operating Expenditures 7,491,479.00 7,251,479,00 6,301,479.00 950,000.00 13.10% Fay. due to Private Institutions $400,000; Private Institutions Foster Care $400,000; and Foster Boarding Homes $150,000. Costs are based on caseload, difficulty of care, and treatment of services ordered by the Court. Favorability is partially offset by unfav. Non-Dept. Child Care Subsidy Revenue (50% reimbursement). Internal Support Expenditures 13,091.00 13,091.00 13,091.00 0.00% Transfers Out $ 7,695,077.00 $ 7,455,077.00 $ 6,505,077.00 $ 950,000.00 12.74% Health Personnel Expenditures $ 26,730,529.00 $ 25,730,529.00 $ 26,078,529.00 $ 652,000.00 2.44% Fav. due to turnover and underfilled positions. Operating Expenditures 3,308,063.00 3,930,193.28 4,028,333.28 (98,140.00) -2.50% Unfav. Adjusted Prior Years Revenue ($148,100) due to correction of FY 2017 estimated administrative overhead cost distribution. Unfav. Vaccines ($30,000) due to increased demand for vaccines and unfav. Drugs ($29,000) due to high costs for TB testing and treatment drugs. Unfavorability offset by Fay. Professional Services $80,000 due to increased individuals enrolled in Medicaid which makes them ineligible for the County's Dental program and Contracted Services $30,000 to comply with HIPAA regulations. Internal Support Expenditures 3,023,452.00 3,264,425.00 3,264,425.00 0.00% Transfers Out 15,870.00 15,870.00 ------------ -------------- ----------------------- $ 33,062,044.00 $33,941,017.28 $ 33,387,157.28 $ 553,860.00 1.63% 57 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Children's Village Personnel Expenditures $ 18,134,919.00 $ 18,134,919,00 $ 18,509,919.00 $ (375,000.00) -2.07% Unfav. primarily due to overtime. Operating Expenditures 3,798,761.00 4,121,974.00 3,999,474.00 122,500.00 2.97% Fay. Medical Services Physicians $41,000 due to services provided by Oakland Integrated Healthcare Network (OIHN). Fay. Provisions $32,000 due to lower food costs and fluctuations in resident population. Fay. Drugs $20,000 due to fewer medical needs along with cost saving initiatives and Fay. Security Supplies $16,000 and Fav. Printing $14,500 due to lower than anticipated use. Favorability partially offset by Unfav. Laundry and Cleaning ($9,000) due to higher than anticipated activity. Internal Support Expenditures 2,940,888.00 3,033,077.00 3,033,077.00 0.00% Transfers Out $ 24,874,568.00 $ 25,289,970.00 $ 25,542,470.00 $ (252,500.00) -1.00% Homeland Security Personnel Expenditures $ 903,537.00 $ 903,537.00 $ 895,837.00 $ 7,700.00 0.85% Fay. Salaries $6,900 and Fringes $3,300 due to positon vacancy. Partially offset by unfav. Overtime ($2,500) due to emergency response and training needs, Operating Expenditures 304,866.00 305,526.00 274,626.00 30,900.00 10.11% Fay. Tornado Siren Equipment $12,000 due to the installation of fewer than anticipated sirens. Fay. Equipment Maintenance $10,000 due to limited repair costs incurred on specialty/hazmat vehicles and Fav. Personal Mileage $5,400 due to less than anticipated activity. Internal Support Expenditures 484,459.00 514,146.00 514,146.00 0.00% Transfers Out - _ -_-_-_-_----- ----------- --------- -----_-_-_-___ $ 1,692,862.00 $ 1,723,209.00 $ 1,684,609.00 $ 38,600.00 58 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Department Total Personnel Expenditures $ 45,959,492.00 $ 45,959,492.00 $ 45,674,792.00 $ Operating Expenditures 14,903,169.00 15,609,172.28 14,603,912.28 Internal Support Expenditures 6,461,890.00 6,824,739.00 6,824,739.00 Transfers Out - 15,870.00 15,870.00 284,700.00 1,005,260.00 0.62% 6.44% 0.00% 0.00% $ 67,324,551 .00 $ 68,409,273.28 $ 67,119,313.28 $ 1,289,960.00 1.89% 59 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Public Services - Admin. Personnel Expenditures $ 231,432.00 $ 231,432.00 231,432.00 $ 0,00% Operating Expenditures 4,800.00 4,800.00 4,800.00 0.00% Internal Support Expenditures 6,636.00 6,636.00 6,636.00 0.00% $ 242,868.00 $ 242,868.00 $ 242,868.00 $ 0.00% Veterans' Services Personnel Expenditures $ 1,705,218.00 $ 1,705,218.00 1,705,218.00 $ 0.00% Operating Expenditures 190,912.00 190,912.00 175,212.00 15,700.00 8.22% Fav. Soldier Burial $10,600 and Soldier Relief $5,100 due to less than anticipated activity. Internal Support Expenditures 205,840.00 212,319.00 212,319.00 0.00% Transfers Out 0.00% $ 2,101,970.00 $ 2,108,449.00 $ 2,092,749.00 $ 15,700.00 0.74% Community Corrections Personnel Expenditures $ 4,066,292.00 $ 4,066,292.00 4,066,292.00 $ 0.00% Operating Expenditures 502,025.00 502,025.00 502,025.00 0.00% Internal Support Expenditures 559,672.00 618,193.00 618,193.00 0.00% Transfers Out 18,606.00 18,606.00 0.00% - $ 5,127,989.00 $ 5,205,116.00 $ 5,205,116,00 $ 0.00%. 60 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES PUBLIC SERVICES ADOPTED BUDGET AMENDED BUDGET AMOUNT FY 2018 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ••••••n••n•.n•n•••n• MSU Ext. - Oakland County Personnel Expenditures $ 666.420.00 $ 666,420.00 $ 575,620.00 $ 90,800.00 13.63% Fay. Due to vacant position. Operating Expenditures 227,239.00 227,239.00 227,239.00 0.00% Internal Support Expenditures 290,122.00 291,667.00 291,667.00 0.00% $ 1,183,781.00 $ 1,185,326.00 $ 1,094,526.00 $ 90,600.00 7.66% Medical Examiner Personnel Expenditures $ 3,521,198.00 $ 3,521,198.00 $ 3,521,198.00 $ 0.00% Operating Expenditures Internal Support Expenditures Transfers Out Animal Control Personnel Expenditures Operating Expenditures 657,006.00 666,917.00 656,617.00 10,300.00 1.54% Fay. Training $9,500, Freight and Express $1,900, Equipment Rental $1,700, Periodicals Books Publ Sub $1,000, Printing $1,000 and Metered Postage $1,000 due to less than anticipated activity. Partially offset by unfavorable Miscellaneous ($3,200), Membership Dues ($1,400), Equipment Maintenance ($1,200) due to increased activity. 815,459.00 848,924.00 848,924.00 0.00% $ 4,993,663.00 $ 5,037,039.00 $ 5,026,739.00 $ 10,300.00 0.20% $ 2,463,584.00 $ 2,510,334.00 $ 2,510,334.00 $ 0.00% 280,097.00 362,336.00 367,236.00 (4,900.00) -t35% Unfav. Metered Postage ($9,800) due to rate increases, Uniforms ($3,417) due to new staff, and Tax Collection Supplies ($1,100) due to new permits with new address. Partially offset by favorable Animal Supplies $11,300 due to less than anticipated activity. 61 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES PUBLIC SERVICES ADOPTED AMENDED BUDGET BUDGET FY 2018 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Internal Support Expenditures 1,004,615.00 1,064,413.00 1,064,413.00 0.00% Transfers Out $ 3,748,296.00 $ 3,937,083.00 $ 3,941,983.00 $ (4,900.00) -0.12% Circuit Court Probation Personnel Expenditures 0.00% Operating Expenditures 54,326.00 54,326.00 47,126.00 7,200.00 13.25% Fay. Office Supplies $4,300 and Metered Postage $2,900 due to less than anticipated acivity. Internal Support Expenditures 584,085.00 587,718.00 587,718.00 0.00% $ 638,411.00 $ 642,044.00 $ 634,844.00 $ 7,200.00 1.12% Department Total Personnel Expenditures $ 12,654,144.00 $ 12,700,894.00 $ 12,610,094.00 $ Operating Expenditures 1,916,405.00 2,008,555.00 1,980,255.00 Internal Support Expenditures 3,466,429.00 3,629,870.00 3,629,870,00 Transfers Out „ 18,606.00 18,605.00 90,800.00 28,300.00 0.71% 1.41% 0.00% $ 18,036,978.00 $ 18,357,925.00 $ 18,238,825.00 $ 119,100.00 0.65% 62 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST :UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures $ 1,428,170.00 $ 1,447,238.00 $ 1,423,738.00 $ 23,500.00 442,222.00 473,222.00 453,222.00 20,000,00 1.62% Fay. due to vacancies and underfilled positions. 4.23% Fav. Printing $15,000; Travel and Conferences $10,000; Personal Mileage $5,800; and Periodicals Books Publ Sub $3,800 due to less than anticipated activity. Partially offset by unfav. Membership Dues ($14,000) due to higher than anticipated activity. Internal Support Expenditures Transfers 53,333.00 66,551.00 66,551.00 0.00% $ 1,923,725.00 $ 1,987,011.00 $ 1,943,511.00 $ 43,500.00 2.19% Planning and Economic Development Services Personnel Expenditures $ 4,186,824.00 $ 4,167,756.00 $ 3,939,056.00 $ 228,700.00 Operating Expenditures 1,395,509.00 1,685,569.00 1,655,269.00 30,300.00 Internal Support Expenditures 855,030.00 880,122.00 880,122.00 Transfers 5.49% Fay. due to vacancies and underfilled positions. 1.80% Fay. Business Recruitment $48,000 due to lower than anticipated costs subsequent to budget. Fay. Travel and Conferences $11,000 and Printing $10,000 due to less than anticipated activity. Partially offset by unfav. Advertising ($41,500) due to higher than anticipated activity. 0,00% $ 6,437,363.00 $ 6,733,447.00 $ 6,474,447.00 $ 259,000.00 3.85% 63 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS AMENDED BUDGET ADOPTED BUDGET Community and Home improvement Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers AMOUNT FY 2018 FAVORABLE FORECAST :UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 495,018.00 495,018,00 $ 495,018.00 $ 495,018.00 $ Workforce Development Personnel Expenditures $ 25,620.00 $ 25,620.00 $ 25,620.00 $ 0.00% Operating Expenditures Internal Support Expenditures $ 25,620.00 $ 25,620.00 $ 25,620.00 $ 0.00% Department Total Personnel Expenditures $ 5,640,614.00 $ 5,640,614.00 Operating Expenditures 1,837,731.00 2,158,791.00 Internal Support Expenditures 908,363.00 946,673.00 Transfers 495,018.00 $ 5,388,414.00 2,108,491.00 946,673.00 495,018.00 $ 252,200.00 50,300.00 4.47% 2.33% 0.00% 0.00% $ 8,386,708.00 $ 9,241,096.00 $ 8,938,596.00 $ 302,500.00 3.27% 64 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT NON-DEPARTMENTAL EXPENDITURES AMOUNT ADOPTED AMENDED FY 2018 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION NON-DEPARTMENT APPROPRIATIONS COUNTY OPERATIONS Insurance Fund Insurance Surety Bonds Logos Trademarks Intellect Property Road Comtnission \Current Drain Assessment Road Commission \Tri Party Agreement Interest Expense Provisions Transfer to Community Mental Health Authority Total $ 361,309.00 $ 361,309.00 $ 361,309.00 $ 33,305.00 33,305.00 13,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,449,453.00 1,449,453.00 - - - 30,000.00 30,000.00 30,000.00 9,620,616.00 9,620,616.00 9,620,616.00 $ 11,515,330.00 $ 12,964,683.00 $ 12,944,683.00 $ 0.00% 20,000.00 60.05% Fay. projection based on actual payments approved by Risk Management to date. 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 20,000.00 0.15% COUNTY BUILDINGS $ 2,652,589.00 $ 2,306,032.00 $ 2,306,032.00 $ 0.00% STATE AND FEDERAL - COUNTY ASSOCIATIONS Michigan Assoc. of Counties National Assoc. of Counties S.E.M.C.O.G. Traffic Improvement Association Total $ 73,000.00 $ 24,100.00 500,000.00 30,000.00 $ 627,100.00 $ 73,000.00 $ 24,100.00 500,000.00 30,000.00 627,100.00 $ 73,000.00 $ 24,100.00 465,000.00 35,000.00 30,000.00 592,100.00 $ 35,000.00 0.00% 0.00% 7.00% 0.00% Fay. due to membership rate less than budget. 5.58% SUNDRY EXPENSE $ 300,000.00 $ 300,000.00 $ 300,000.00 8 0.00% RESERVED FOR TRANSFERS Expenditures Classification and Rate Change Contingency Disaster Recovery Emergency Salaries Grant Match Info Tech Development Juvenile Resentencing Legislative Expense Local Road Funding Program Misc. Capital Outlay $ 298,179.00 $ 298,179.00 $ 298,179.00 $ 300,000.00 50,294.00 50,294.00 300,000.00 300,000.00 300,000.00 500,000.00 461,016.00 451,016.00 1,470,937.00 1,379,728.00 1,379,728.00 5,698,874.00 3,616,677.00 3,616,677.00 1,186,866.00 1,186,866.00 8,600,00 8,600.00 8,600.00 366,065.00 366,055.00 791,950.30 500,312.00 500,312.00 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0,00% 0.00% 65 ADOPTED BUDGET 256,000.00 1,141,166.00 4,550,000.00 250,000.00 AMENDED BUDGET 256,000.00 91,941.00 4,550,000.00 250,000.00 FY 2018 FORECAST 256,000.00 91,941.00 4,550,000.00 250,000.00 AMOUNT FAVORABLE (UNFAVORABLE) $ 15,565,706.00 $ 13,315,668.00 $ 13,315,668.00 $ $ 477,919.00 $ 477,919.00 $ 477,919.00 1,644,186.00 1,644,186.00 1,644,186.00 3,620,676.00 3,720,676.00 3,720,676.03 2,238,000.00 2,238,000.00 2,238,000.00 1,268,000.00 7,124,902.00 7,124,902.00 5,500,000.00 5,500,000.00 5,500,000.00 1,708,046.00 1,708,046.00 1,113,861.00 1,113,861.00 4,211,324.00 4,211,324.00 $ 14,748,781.00 $ 27,738,914.00 $ 27,738,914.00 $ COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT NON-DEPARTMENTAL EXPENDITURES Overtime Reserve Security Reserve Substance Abuse Coord Agency Summer Employees Salary Appropriation Total Transfers to Other Funds Fire Records Management CLEM1S Information Technology Bldg Auth Fac lnfras IT Debt Facilities Maintenance and Operations Fringe Benefit Fund Project Work Order Fund Long Term Revolving Fund Building Fund Economic Development Corp BA Animal Ctrl Pet Adopt Debt Imaging System Project HIPAA Compliance Project UCC Network Equipment Replacement Project Domestic Equipment Preparedness PERCENT 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% EXPLANATION TOTAL NON-DEPT. APPROPRIATIONS $ 45,409,506.00 $ 57,252,397.00 $ 57,197,397.00 $ 55,000.00 0.10% TRANSFER TO GENERAL PURPOSE FUNDS Child Care Fund $ 23,323,944.00 $ 23,416,133.00 $ 23,416,133.00 $ 0.00% Social Welfare Fund Foster Care 1,000.00 1,000.00 1,000.00 0.00% $ 23,324,944.00 $ 23,417,133.00 $ 23,417,133.00 $ 0.00% TOTAL EXPENDITURES $ 68,734,450.00 $ 80,669,530.00 $ 80,614,530.00 $ 55,000.00 0.07% 66 FY 2018 BUDGET AMENDMENTS FY 2018 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS BUDGET AMENDMENTS M.R. #17285 - 10111/2017 Department of Health and Human Services/Health Division - Funding for the Area Agency on Aging 1-B - Community Living Program Services M.R. #17310 - 11/09/2017 Department of Information Technology Universal Communications and Collaboration Program, Network Equipment Replacement Project M.R. #17318 - 11/09/2017 Risk Management and Information Technology - Policy for the Health Insurance Portability and Accountability Act of 1996 (HIPAA) as Amended by the HITECH Act of the American Recovery and Reinvestment Act of 2009 and HIPAA Compliance Project $ 454,982,625.00 $ 600,000.00 $ 4,211,324.00 $ 1,113,861.00 M.R. #17324 - 12107/2017 Management 8; Budget Fiscal Year 2017 Year-End Report and Budget Amendments Encumbrances Carry Forwards Adjustments to Circuit Court Adjustments to Children's Village Child Care Fund Adjustments to Water Resource Commissioner $ 192,145.21 $ 4,847,541.00 $ 130,500.00 400.00 $ 31,520.00 $ 5,202,106.21 M.R. #17336 - 12/07/2017 Department of Facilities Management and Sheriffs Office - Amendment to the Lease Agreement with 2470 Elizabeth Lake Road, LLC M.R. #17337 - 12/07/2017 Public Services/Animal Control - Modifications of Rates and Positions M.R. #17340 - 12/07/2017 Sheriffs Office - Contract Amendment #1 for Law Enforcement Services in the Charter Township of Commerce 2017-2018 M.R. #17341 - 1210712017 Sheriffs Office - Contract Amendment #1 for Law Enforcement Services in the Charter Township of Highland 2017-2018 M.R. #17342 - 12/0712017 Sheriffs Office - Contract Amendment #2 for Law Enforcement Services in the Charter Township of Orion 2017-2018 M.R. #17343 - 12/07/2017 Sheriffs Office - Contract Amendment #1 for Law Enforcement Services in the Charter Township of Oxford 2017-2018 M.R. #17344 - 12107/2017 Sheriffs Office - Contract Amendment #1 for Law Enforcement Services in the City of Rochester Hills 2017-2018 M.R. #18002 - 01/17/2018 Department of Health and Human Services/Children's Village Division — Oakland County Interlocal Agreement Between Oakland County and the Oakland Community Health Network for Psychiatric Services for Oakland County Children's Village 4,990.00 $ 173,111.00 $ 320,416.00 $ 130,924.00 $ 150,437.00 $ 130,924.00 $ 237,811.00 75,000.00 M.R. 02/01/2018 Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance) M.R. #18010 - City of Troy $ 249,266.00 M.R. #18011 - City of Rochester Hills $ 160,578.00 $ 409,844.00 67 FY 2018 BUDGET AMENDMENTS M.R. #18048 - 02/21/2018 Board of Commissioners - Sponsorship of the 2018 International Bocce Tournament at the Palazzo Di Bocce M.R. - 02/2112018 Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance) M.R. #18049 - Charter Township of Springfield M.R. #18050 -0212112018 Board of Commissioners - Funding Support for Haven's Conference for Domestic Abuse Professionals M.R. #18053 -0212112018 Board of Commissioners - Tr-Party Program — Additional Appropriation #2 for Charter Township of Oxford — Project No. 53331 M.R. #18021 -02/21/2018 Sheriff's Office-Establishment of Dispatch Services Contract Rates April 1, 2018 through March 31, 2021 M.R. #18059 - 03/08/2018 Facilities Management/Facilities Planning & Engineering / Sheriff's Office — Additional Priority 2 Building Security Enhancement and Priority 3 Building Security Enhancement Projects 12,000.00 37,000 00 4,000.00 36,606.00 $ 153,707.00 $ 4,692,766.00 M.R. #18081 - 03121/2018 Corporation Counsel/Risk Management — Matter Management System and Access Database Replacement Project $ M.R. #18082 - 03/21/2018 Facilities Management/Facilities Planning & Engineering/Probate Courtroom Ingress/Egress Flow Enhancements $ Project 100,000.00 164,136.00 M.R. #18083 - 03/21/2018 Management & Budget FY 2018 First Quarter Report Adjustments to Sheriffs Office Adjustments to Children's Village Child Care Fund Adjustments to Economic Development and Community Affairs Adjustments to Non-Departmental $ 59,015.00 813.00 $ 41,000.00 $ 1,708,046.00 $ 1,808,874.00 TOTAL AMENDED BUDGET AS OF 03/3112018 $ 474,752,362.21 68 List of Grants $10,000 and under Grant sign off Department or Division Grant Title Award/ Amendment Amount Quarter included (QTPJFY) 2/22/2018 Homeland Security 2017 HMEP Grant Amendment under $10,000 $ 7,45726 2QTR/FY18 3/6/2018 Parks and Rec 2018 Arts and Humanities Touring Grant $ 300.00 2QTR/FY1I3 3/8/2018 Prosecutor's Office 2018 Crime Victim Rights Week Grant $ 400.00 2QTR/FY18 3/19/2018 Animal Control & Pet Adoption 2018 Animal Safety Equipment $ 10,000.00 2QTR/FY18 3/12/2018 Airport 2018 Aircraft Rescue and Firefighter Training $ 2,000.00 2QTR/FY18 3129/2018 Animal Control & Pet Adoption 2018 Bissell Empty the Shelters Grant Up to $5000 2QTR/FY18 5/15/2018 Veterans' Services 2018 Michigan Veterans Affairs Agency's County Training Reimbursement - Application/Acceptance $ 4,565.25 2QTR/FY18 69 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT ENTERPRISE FUND TREASURERS OFFICE ADOPTED AMENDED FY 2018 VARIANCE BUDGET BUDGET FORECAST FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $14,782,900.00 $14,782,900.00 DELINQUENT TAX REVOLVING FUND 51600 REVENUES Charges for Services Other Revenues Total Revenues n..............nn•nn•00,•*.r., • n••nnnnn•nnn•nnn $13,312,900.00 1,470,000.00 $14,782,900.00 $13.312,900.00 1,470,000.00 813,312,900.00 1,470,000.00 $0.00 0.00% $0.00 0.00% $0.00 0.00% 0.00% 464,481.00 47.19% OPERATING EXPENSES Personnel Expenditures Operating Expenditures $ 211,894.00 984,381.00 $ 211,894.00 $ 211,894.00 984,381.00 519,900.00 Interest Expense Transfer Out to Other Funds: General Fund - Collection Fees GF - Non-Departmental Work Release Facility Refunding Debt Svc Office Bldg Renovation Refunding Debt Svc 52-3 District Court Refunding Debt Svc Total Transfer Out to Other Funds Total Operating Expenses Fay. Info Tech Development $400,000 due timing of the Tax Management system. Also favorable Indirect Costs 827,000 due to actual charges determined after budget finalization; Professional Services $25,000, Legal Services $7,500 and Professional Services-Financial Consultant $5,000 due to less than anticipated activity. 22,325.00 9,68% Fay. related to lower debt interest rates. 2,600,000.00 0.00% 6,000,000.00 0.00% 1,587,500,00 0.00% 1,866,700.00 0.00% 1,301,800.00 $ 13,356,000.00 0.00% $ 14,296,094,00 $ 486,80670 3.29% 230,625.00 2,600,000.00 6,000,000.00 1,587,500.00 1,866,700.00 1.301,800.00 $ 13.356 000.00 $ 14,782,900.00 230,625.00 2,600,000.00 6,000,000.00 1,587,500.00 1,865,700.00 1.301,800.00 13.358,000.00 $ 14,782,900.00 208,300.00 REVENUE OVER (UNDER) EXPENDITURES" $0.00 $0.00 $486.806.00 $486,806.00 Total Net Position - Beginning $197,362,617.65 Total Net Position - Ending $197,849,423.65 Ending FY 2017 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 $40,479,591.00 150,599,953.87 6,283,472.78 $0.00 * Please note that in the Adopted Budget (line-item book) this is budgeted as 'Planned Use of Balance" in the revenue category. ** Please note the designated equity amounts are adjusted at year-end only 70 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT ENTERPRISE FUNDS TREASURER ADOPTED BUDGET AMENDED BUDGET FY 2018 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ••n••nn•n•*o*.o•.r•.n DELINQUENT PERSONAL PROPERTY TAX (51800) $402,000.00 OPERATING REVENUE OPERATING EXPENSE NET OPERATING INCOME (LOSS) NON-OPERATING REVENUE (EXPENSE) $402,300.00 $402,300.00 485,365.00 485,365.00 ($83,065.00) ($83,065.00) ($300.00) -0.07% - Unfav. Reimbursement Salaries ($2,300) due to less than anticipated activity. Partiallyoffset by fay. to Income from Investments $2,000 due to investment base and market rate adjustments. 13.43% - Fav. Controllable Personnel $58,800 due to vacant and underfilled positions. Favorable Metered Postage $2,300, Motor Pool Leased Vehicles $2,100 and Motor Pool Fuel Charges $2,000 due to less use. -78.09% 0.00% 420,200.00 ($18,200.00) 500.00 500.00 500.00 $65,165.00 $64,865.00 $0.00 TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS ($82,565.00) ($82,565.00) $ (17,700.00) $64,865.00 TRANSFERS OUT TOTAL NET INCOME (LOSS)" ($82,565.00) ($82,565.00) ($17,700.00) $64,865.00 TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING 403,915.82 $386,215.82 * Please note that in the Adopted Budget ((ne-item book) this is budgeted as 'Planned Use of Balance" in the revenue category. 71 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT ENTERPRISE FUND PARKS & RECREATION ADOPTED BUDGET AMENDED BUDGET FY 2018 FORECAST VARIANCE FAW(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OAKLAND COUNTY PARKS & RECREATION COMMISSION 450800) OPERATING REVENUE OPERATING EXPENSE NET OPERATING INCOME (LOSS) NON-OPERATING REVENUE (EXPENSE) TOTAL INCOME BEFORE TRANSFERS $ 10,596,390.00 $ 10,778,876.00 $ 10,778,876.00 $ $ 26455,766.00 $ 27,578,673.00 27,518,673.00 $ $ (15,859,376.00) $ (16,799,797.00) 8 (16,799,797.00) $ 8 14,294,200,00 $ 14,611,961.00 $ 14,611,961.00 $ $ (1,565,176.00) $ (2,187,836.00) $ (2,187,836,00) $ 0,00% Revenue and expense variances are not anticipated at this time since a majority of the revenue and expense activity occurs in the 3rd and 4th quarter. 0.00% 0.00% 0,00% 0.00% TRANSFERS IN $ $ - $ TOTAL NET INCOME/PLANNED USE OF BALANCE (LOSS)* $ (1,565,176.00) $ (2,1871336.00) $ (2,187,836.00) TOTAL NET POSITION - BEGINNING 91,318,493.38 TOTAL NET POSITION - ENDING 89,130,657.38 72 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT INTERNAL SERVICE FUND WATER RESOURCES COMMISSIONER ADOPTED AMENDED FY 2018 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DRAIN EQUIPMENT FUND ( 63900) OPERATING REVENUES: Inside $43,948,708.00 $44,216,988.00 $41,905,988.00 ($2,311,000.00) -5.23% Unfav. Reimbursement Salaries ($2,500,000) due to unallocated payroll charges for turnover and vacant positions offset in Salaries and Fringes. Unfav - Maintenance Contracts (91,000) due to an adjustment in the Supervisory Control and Data Acquisition (SCADA) maintenance allocation rate to be more in line with actual expenses. ParitaHy offset by fay. Reimbursement General $250,000 a result of increased allocation base allocated to special revenue and proprietary funds. Fay - Reimbursement Building Space Cost $30,000 due to a rate adjustment for the maintenance and operations of the Dixie Highway Building. Outside 181,000.00 181,000.00 251,000.00 870,000.00 38,67% Fav. due to External Rebilled Charges Revenue revenue is determined by a increase in rebillable repair jobs, offset by unfavorable expenses pertaining to the repair jobs. Total Revenue -5.05% 44,129,708.00 44,397,988.00 42,153,988.00 (2,241,000.00) OPERATING EXPENSES 844,224,020.00 844,382,941.00 841,533,309.00 82,849,632.00 6.42% Fay. Salaries $1,500,000 and Fringes $1,000,000 due to turnover and vacant positions. Fay - Depreciation Equipment $400,000 due to a change in the implementation date from FY 2018 to FY 2020 for the Supervisory Control and Data Acquisition (SCADA) system common to all project. Fay - Indirect Cost $50,000 due to a roll forward credit reducing the expense, Unfav Info Tech Development ($70,000), Travel and Conference ($10,100) due to the Capital Asset Management Plan (CAMP) cost for the development of the asset water management program. Unfav - Maintenance Department Charges ($7,000) a result of labor charges from Facilities Maintenance and Operations for repair work at the Dixie Highway Building, Unfav. Personal Mileage ($3,650) due to employees using their own personal vehicle to attend meetings. Unfav - Equipment Maintenance ($3,500) the result of actual spending being more than anticipated budget, 73 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT INTERNAL SERVICE FUND WATER RESOURCES COMMISSIONER ADOPTED AMENDED FY 2018 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES NET INCOME (LOSS) BEFORE ($94,312.00) $15,047.00 $523,679.00 $608,632.00 4044.87% NON-OPERATING REVENUE/(EXPENSE) $251,427.00 $76,200.00 6107,200.00 $31,000.00 40.66% Fay. income from Investment $31,000 the result of fund earning a return due to a positive cash balance. TRANSFER IN 316,236.00 318,236.00 0.00% TRANSFERS (OUT) 157,115.00 409,483.00 409,483.00 0.00% NET REVENUES OVER (UNDER) $639,632.00 $639,632.00 EXPENSES TOTAL NET POSITION - BEGINNING 18,375,650.10 TOTAL NET POSITION - ENDING $19,015,267.10 74 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT INTERNAL SERVICE FUND RISK MANAGEMENT ADOPTED AMENDED FY 2018 VARIANCE BUDGET BUDGET FORECAST FANNUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ILIABILITY INSURANCE FUND 67700 OPERATING REVENUES: Outside Revenue 5 10,211.00 $ 10,211.00 $ 21,311.00 $ 11,100.00 - Fav. due to refunds received for prior year expenses and litigation settlements. Inside Revenue 3,629,579.00 3,629,579.00 3,629,579.00 0.00% Total Operating Revenue $ 3,639,790.00 $ 3,639,790.00 $ 3,650,890.00 $ 11,100.00 0.30% OPERATING EXPENSE $ 3,641,668.00 5 3,641,668.00 $ 3,641,658,00 $ 0.00% CLAIMS PAID 1,253,279.00 1,253,279.00 1,253,279.00 0.00% TOTAL OPERATING EXPENSES $ 4,694,947,00 $ 4,894,947.00 $ 4,894,947.00 $ 0.00% OPERATING INCOME (LOSS) (1,255,157.00) (1,255,157.00) (1,244.057.00) 11,100.00 -0.88% NON-OPERATING REVENUE (EXPENSE) 150,000.00 150,000.00 150,000.00 0.00% NET REVENUES OVER/(UNDER) EXPENSES $ (1,105,157.00) $ (1,105,157.00) (1,094,057.00) $ 11,100.00 TOTAL NET ASSETS- BEGINNING 6,644,395,00 TOTAL NET ASSETS - ENDING S 5,550 338.00 75 DEFINED CONTRIBUTION PLAN - PTNE DEFERRED COMPENSATION-MATCH EMPLOYEE IN-SERVICE TRAINING EMPLOYEE BENEFITS UNIT EMPLOYEE RECOGNITION FLEX BENEFIT PLAN WELLNESS UNIT 230,000.00 1,400,000.00 1,200,300.00 1,836,300.00 316,800.00 90,000.00 610,000.00 230,000.00 1,400,000.00 1,200,300.00 1,836,300.00 316,800.00 90,000,00 610,000.00 230,000.00 1,450,000.00 1,232,000.00 1,886,700.00 327,400.00 90,000.00 624,700.00 COUNTY OF OAKLAND FY2018 SECOND QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND ADOPTED AMENDED FY 2018 VARIANCE FRINGE BENEFITS FUND 67800 BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ......nn•••n••n•n•nn• ..... n••n•• /1.1~/ nn•n11...1. OPERATING REVENUE RETIREES MEDICAL - VEBA DEBT RETIREMENT ADMINISTRATION 34,002.500.00 34,002,500.00 34,915,000.00 912,500.00 2.68% - Fay. due to projected revenue more than budget projection. 3,324,900.00 3,324,900.00 3,412,100.00 87,200.00 2.62% - Fay, due to projected revenue more than budget projection. 0,00% 100,000.00 0.53% - Fay. due to projected revenue more than budget projection - increase in new hires who participate in the Defined Contribution Plan. Offset by unfavorable Defined Contribution Plan expense. 0.00% 50,000.00 3.57% - Fay. due to projected revenue more than budget projection. Offset by unfavorable Deferred Compensation-County Payments expense. 31,700.00 2.64% - Fay. due to projected revenue more than budget projection. 50,400.00 2.74% Fav. due to projected revenue more than budget projection. 10,600.00 3.35% Fay, due to projected revenue more than budget projection. 0.00% 14,700.00 2.41% - Fay. due to projected revenue more than budget projection. RETIREMENT ADMINISTRATION - PINE 240,000,00 240,000.00 240,000.00 DEFINED CONTRIBUTION PLAN 18,900,000.00 18,900,000.00 19,000,000.00 FRINGE BENEFITS 114,600.00 114,600.00 114,600.00 0.00% TUITION REIMBURSEMENT 460,000.00 460,000,00 474,000.00 14,000.00 1/1 - Fay. due to projected revenue more than budget projection. RETIREMENT HEALTH SAVINGS 3,570,000.00 3,570,000.00 3,363,900.00 (206,100.00) -5.77% - Unfav. due to projected revenue less than budget projection, offset by favorable Retirement Health Savings expense. 457,000.00 457,000.00 457,000.00 0.00% 16,300,000.00 16,300,000.00 17,490,900.00 1,190,900.00 7.31% - Fay. due to projected revenue more than budget projection - an increase in new hires. Offset by unfavorable Social Security expense. 37,015,000.00 37,015,000.00 36,500,000.00 (515,000.00) -1.39% - Unfav. due to projected revenue less than budget projection, offset by favorable Medical Insurance expense. 10,171,000.00 10,171,000.09 10,292,000.00 121,000.00 1.19% - Fay. due to projected revenue more than budget projection. 3,145,000.00 3,145,000.00 3,723,000.00 578,000.00 18.38% - Fay. due to projected revenue more than budget projection. 188,500.00 188,500.00 345,000.00 156,500.00 83.02% - Fay. due to projected revenue more than budget projection. 3,203,000.00 3,203,000.00 3,229,000.0026,000.00 0.81% - Fav. due to projected revenue more than budget projection. Offset by unfavorable Disability Insurance expense. 3,122,700.00 3,122,700.00 3,636,500.00 513,800.00 16.45% - Fav. due to projected revenue more than budget projection. GROUP LIFE INSURANCE SOCIAL SECURITY MEDICAL INSURANCE PRESCRIPTION COVERAGE INSURANCE DENTAL INSURANCE VISION INSURANCE DISABILITY INSURANCE WORKERS COMPENSATION UNEMPLOYMENT COMPENSATION 400,000.00 400,000.00 400,000.00 0.00% 76 366,600.00 1,653,000.00 316,800.00 90,000.00 606,000.00 366,600.00 1,653,000.00 316,800.00 90,000.00 606,000.00 0.00% 0.00% 0.00% 0.00% 0.00% 77 COUNTY OF OAKLAND FY2018 SECOND QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND FY 2018 VARIANCE FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ----- 579,900.00 300,000.00 107.18% - Fay. due to projected revenue more than budget projection. 5,245,000.00 45,000.00 0.87% - Fav. due to projected revenue more than budget projection. ADOPTED AMENDED FRINGE BENEFITS FUND 67800 BUDGET BUDGET INVESTMENT INCOME 279,900.00 279,900.00 EXT- FLEX BEN MEDICAL - EMPLOYEE 5,200,000.00 5,200,000.00 180,000.00 950,000.00 15,000.00 1,500.00 435,000.00 120,000.00 120,000.00 10,000.00 EXT- MEDICAL INSURANCE 180,000.00 EXT- PRESCRIPTION DRUG REBATES 950,000.00 EXT - DENTAL INSURANCE 15,000.00 EXT - VISION INSURANCE 1,500.00 EXT - FLEX BEN LIFE INSURANCE 435,000.00 EXT - FLEX BEN DENTAL INSURANCE 120,000.00 EXT - FLEX BEN VISION INSURANCE 120,000.00 EXT - FORFEITURE OF DEPOSIT & DC PLAN EXT - TRAINING EXT - OTHER REVENUE - ICMA REBATES 10,000.00 EXT - WELLNESS REVENUE EXT - FLEX BEN ARREARAGES 180,000.00 950,000.00 15,000.00 1,500.00 435,000.00 120,000.00 120,000.00 475,000.00 6,600.00 10,000.00 1,50100 7,000.00 - 0.00% 0.00% - 0.00% 0.00% 0.00% 0.00% 0.00% 475,000.00 0.00% - Fay. due to forfeiture of non-vested International City Management Association (ICMA) accounts. 6,600.00 0.00% - Fay, due to training provided to outside agencies. 0.00% 1,500.00 - Fay. due to sponsorship of wellness fair. 7,000.00 - Fay. due to post tax benefit arrearages due from County employees for 2017 benefits. 100.00% - Fav. due to Governmental Accounting Standards Board (GASB) 75 requirements. The expense must be recognized as a current liability on Balance Sheet. A second quarter budget amendment is recommended. TOTAL REVENUE 147,609,000.00 147,609,000.00 151,580,300.00 3,971,300.00 2.69% OPERATING EXPENSE RETIREES MEDICAL - VEBA DEBT PRINC. 23,870,000.00 23,870,000.00 23,871000.00 RETIREES MEDICAL VEBA DEBT INT/AGING 10,132,500.00 10,132,500.00 10,132,500.00 0.00% RETIREMENT ADMINISTRATION 3,381,600.00 3,381,600.00 2,645,300.00 736,300.00 21.77% - Fay. Sick and Annual Leave Cash Out $600,000 due to historical trends, Monitoring Services $115,000 due to new vendor with lower contract rate, and Personnel $21,300 due to vacant position. DEFINED CONTRIBUTION PLAN 18,9011000.00 18,900,000.00 19,000,000.00 (100,000.00) -0.53% Unfav. due to projected costs more than budget projection - increase in new hires who participate in the Defined Contribution Plan. Offset by favorable Defined Contribution Plan revenue. DEFINED CONTRIBUTION PLAN - PTNE DEFERRED COMP-COUNTY PMTS (MATCH) EMPLOYEE 1N-SERVICE TRAINING IN-SERVICE TRAINING - INFO TECH BENEFITS ADMINISTRATION EMPLOYEE BENEFITS UNIT EMPLOYEE RECOGNITION FLEXIBLE BENEFIT PAYMENTS WELLNESS PROGRAM 230,000.00 1,400,000.00 850,300.00 350,000.00 356,600.00 1,653,000.00 316,800.00 90,000.00 610,000.00 0.00% (50,000.00) -3.57% - Unfav. due to projected expense more than budget projection. Offset by favorable Deferred Compensation-Match revenue. 59,400.00 6.99% - Fay. due to projected Employee In-Service Training costs less than budget projection. 50,000.00 14.29% - Fay, due to departments not utilizing training funds as budgeted. 230,000.00 230,000.00 1,400,000.00 1,450,000.00 850,300.00 790,900.00 350,000.00 300,000.00 COUNTY OF OAKLAND FY2018 SECOND QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND AMENDED FY 2018 VARIANCE BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 114,600.00 114,600.00 0.00% 460,000.00 300,000.00 160,000.00 34.78% - Fay. due to projected expenses less than budget projection, based on historical trends. 3,570,000.00 3,363,901100 206,100.00 5.77% - Fay. due to projected expense less than budget projection, offset by unfavorable Retirement Health Savings revenue. FRINGE BENEFITS FUND 67800 ACCOUNTING SERVICES TUITION REIMBURSEMENT RETIREMENT HEALTH SAVINGS ADOPTED BUDGET 114,600.00 460,000.00 3,570,000.00 GROUP LIFE INSURANCE SOCIAL SECURITY MEDICAL INSURANCE PRESCRIPTION COVERAGE DENTAL INSURANCE VISION INSURANCE DISABILITY INSURANCE MICHIGAN HICA TAX WORKERS COMPENSATION UNEMPLOYMENT COMPENSATION CHILD CARE FACILITY HEALTH INSURANCE PREMIUM TAX PATIENT CENTERED OUTCOME RESEARCH INDIRECT COSTS TOTAL EXPENSE 892,000.00 892,000.00 916,500.00 (24,500.00) -2.75% Unfav, due to costs higher than budget projection. 16,300,000.00 16,300,000.00 17,490,900.00 (1,190,900.00) -7.31% Unfav, due to projected expense more than budget projection - increase in new hires. Offset by favorable Social Security revenue. 42,090,000.00 42,090,000.00 38,050,000.00 4,040,000.00 9.60% Fay. due to projected expense less than budget projections, offset by unfavorable Medical Insurance revenue. 11,026,000.00 11,026,000.00 10,281,300.00 744,700.00 6.75% - Fay. due to projected expense less than budget projection. 3,250,000.00 3,250,000.00 2,713,700.00 536,300.00 16.50% - Fay. due to projected expense less than budget projection. 310,000.00 310,000.00 225,000.00 85,000.00 27.42% Fav. due to projected expense less than budget projection. 3,203,000.00 3,203,000.00 3,393,700.00 (190,700.00) -5.95% - Unfav. due to higher number of filled full time eligible positions, with less vacancies. Partially offset by favorable Disability Insurance revenue. 411,000.00 411, 000. 00 481,500.00 (70,500.00) -17.15% - Unfav. due to higher projected HICA Tax due to increase of rate from .75% to 1% in 2017. 3,122,700.00 3,122,700.00 3,040,400.00 82,300.00 2.64% - Fay. Risk Management personnel $82,300 due to one vacant position. 400,000.00 400,000.00 330,000.00 70,000.00 17.50% - Fav. due to projected costs less than budget projections. 204,900.00 204,900.00 214,900.00 (10,000.00) -4.88% - Unfav. due to higher than expected Maintenance Department Charges. 56,500.00 (56,500.00) - Unfav. due to the reinstatement of Health Insurance Premium Tax in January 2018. 19,000.00 19,000.00 19,000.00 0.00% 85,000.00 85,000.00 230,100.00 (145,100.00) -170,71% - Unfav. due to actual charges developed after budget finalization. 147,609,000.00 147,605,000.00 118,803,100.00 28,801,900.00 19.51% NET REVENUE OVER/(UNDER) EXPENSES TOTAL NET POSITION - BEGINNING* TOTAL NET POSITION - ENDING 4,000.00 32,777,200.00 32,773,200.00 275,699,122.97 308,476,322.97 78 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT ENTERPRISE FUNDS CENTRAL SERVICES n•n••n••n•n•nnnnnn•n•n••n••••........,n•n••n•n•••!•••n.•••••n ......... OAKLAND COUNTY INTERNATIONAL AIRPORT (56500) ADOPTED BUDGET AMENDED BUDGET FY 2018 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUE $4,627,500.00 $4,729,339.00 $4,664,639.00 ($64,500.00) -1.36% - Unfav. Reimb U.S. Customs Service ($65,100) due to the timing of reimbursments received for Customs and fewer international flights needing inspections by Customs (partially offset by U.S. Customs Service Expense), Avlation Gas ($25,000) due to lower than anticipated gas concessions. Partially offset by fay, T-Hangar Rentals $25,600 due to increased T-Hangar rentals. OPERATING EXPENSE $6,381,354.00 $6,381,354.00 $6,311,254.00 $70,100.00 1.10% - Fav. Personnel $76,900 due to three underfilled posttions, favorable emergency salaries and less than expected hospitalization and higher than expected retirement costs, Grounds Maintenance $65,000 due to less than anticipated snow removal, Electrical Services $23,700 due to lower energy costs, Maintenance Supplies $20,500 due to fewer maintenance supply costs, U.S. Customs $15,000 due to fewer international flights needing inspections by Customs (partially offset by unfavorable US Reimb Customs Service); Unfav. Depreciation Land Improvement ($76,300) due to closing of capital projects at the end of Fiscal Year 2017, Gasoline Charges ($30,100) due to higher gas costs, Water and Sewer Charges ($14,600) due to higher than anticipated water and sewer charges. NET OPERATING INCOME (LOSS) ($1,753,854.00) NON-OPERATING REVENUE (EXPENSE) 145,000.00 TOTAL INCOME BEFORE ($1,652,015.00) ($1.646,415.00) 145,000.00 223,200.00 $5,600.00 -0.34% 78.200.00 53.93% Fay. Income from Investments due to higher than expected interest income. CONTRIBUTIONS AND TRANSFERS ($1,608,854.00) ($1,507,015.00) $ (1,423,215.00) $83,800.00 TRANSFERS IN 0.00 0.00 0.00 0.00 CAPITAL CONTRIBUTION 94,200.00 94,200.00 94,200.00 $0.00 0.00% TOTAL NET INCOME (LOSS) ($1,514,654.00), ($1,412,815.00) $ (1,329,015.00) $83,800.00 TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING $ 76,899,620.16 $ 75,570,505.16 79 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT INTERNAL SERVICE FUNDS CENTRAL SERVICES ADOPTED AMENDED FY2018 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES MOTOR POOL FUND 66100 OPERATING REVENUE: Outside Revenue 130,000.00 $ 130,000.00 $ 130,000.00 $ 0.00% Total Revenue OPERATING INCOME (LOSS) 8,613,850.00 $ (301,922.00) -3.39% - Unfav. Gasoline, Oil & Grease Charges ($312,900) due to current fuel cost (partially offset by a favorable expenditure for Gasoline Charges), Leased Equipment ($148,022) due to actual activity trends to date; Partially offset by fay. Productive Labor $80,300 due to new vehicle builds and vehicle repairs handled in-house, Parts and Accessories $78,700 due to fleet expansion in various departments. 9,258,568.00 $ (212,571.00) -2.35% - Unfav. Depreciation Vehicles ($264,300) due to the replacement of older vehicles with new vehicles, Expendable Equipment ($110,000) due to the purchase of additional used vehicles, Insurance Reserve Expense ($56,000) due to higher costs associated with garage owned vehicles involved in accidents, Indirect Costs ($39,200) due to the development of actual charges after budget finalization, Shop Supplies ($15,200) due to the need for additional shop supplies, and Car Wash ($10,000) due to increased number of car washes; offset by fay. Gasoline Charges $183,300 due to market fluctuations and miles driven (offset by unfav. Gasoline, Oil Grease Charges revenue); partially offset by fay. Personnel $45,529 due to underfilled positions, turnover, emergency salary position and lower than expected Retirement costs, Insurance Fund $23,600 due to less than anticipated insurance costs, IT Development $18,300 due to less than anticipated charges, and Insurance $11,400 due to actual premiums less than expected based on insurance market fluctuations and rates. Inside Revenue 8,763,023.00 # 8,915,772.00 OPERATING EXPENSE 8,941,968.00 9,045,997.00 $ 8,893,023.00 $ 9,045,772.00 $ 8,743,850.00 $ (301,922,00) $ (48,945.00) $ (225.00) $ (514,718.00) $ (514,493.00) NON-OPERATING REVENUE (EXPENSE) 437,500.00 437,500.00 437,500.00 0.00% NET INCOME (LOSS) BEFORE OPERATING TRANSFERS $ 388,555.00 $ 437,275.00 $ (77,218.00) $ (514,493.00) TRANSFERS IN / (OUT) 288,070.00 527,824.00 527,824.00 $ 0.00% NET REVENUE OVER/(UNDER) EXPENSES (PLANNED USE OF FUND BAL.) $ 676,625.00 $ 965,099.00 $ 450,606.00 $ (514,493.00) TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING $ 9,832,252.15 $ 10,282,858.15 80 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT INTERNAL SERVICE FUND FACILITIES MANAGEMENT ADOPTED AMENDED FY 2018 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 'FACILITIES MAINTENANCE & OPERATIONS (#63100) 450,908.00 $ 450,908.00 $ 450,908.00 $ 0.00% - 26,015,442.00 26,021,192.00 26,036,192.00 15,000.00 0.06% Fay. Maintenance Dept Charges based on Department requests. $ 26,456,350.00 $26,472,100.00 $ 26,487,100.00 $ 15,000.00 0.06% $ 28,267,576.00 $28,273,326.00 $ 27,198,326.00 $ 1,075,000.00 3.50% - Fay. Natural Gas $500,000 due to purchasing natural gas from third party sources and lower market prices; Salaries and Fringe Benefits $450,000 due to underfilled/vacant positions; Sublet Repairs $300,000 due to more efficient management of grounds maintenance; Water & Sewage Charges $150,000 based on actual usage; Electrical Service $75,000 due to lower-cost third-party contracts and savings from FM&O energy conservation initiatives; Security Supplies $70,000 due to the use of alternative sources of funding (security enhancement); Fuel Oil $50,000 due to the lack of availability of specialized fuel grade; Equipment Maintenance $40,000 based on increased use of internal staff to repair/maintain equipment and specialty vehicles. Partially offset by unfav. Material and Supplies ($200,000) based on actual usage; Info Tech Development ($125,000) due to infrastructure and custodial software study; Info Tech Operations ($75,000) due to AutoCAD and Kronos software maintenance along with one-time IT equipment purchase; Grounds Supplies ($60,000) and Maintenance Supplies ($50,000) based on increase of services performed internally; Custodial Supplies ($50,000) due to increase in cleaning services requested by department. $ (1,801,226.00) $ (1,801,226.00) $ (711,226.00) $ 1,090,000.00 100,000.00 $ 100,000.00 $ 120,000.00 $ 20,000.00 20.00% ray. Investment Income due to higher than anticipated rate of return on OPERATING REVENUES: Outside Revenue Inside Revenue Total Revenue OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN - $ 8,500.00 $ 8,500.00 0.00% Transfers In from Project Work Order Fund for closed Maintenance Projects. TRANSFERS OUT (64,018.00) $ (64,018.00) $ (64,018.00) $ 0,00% NET REVENUES OVER(UNDER) EXPENSES* $ (1,765,244.00) $ (1,765,244,00) $ (646,744.00) $1,118,500.00 TOTAL NET POSITION - BEGINNING $ 10,996,803.11 TOTAL NET POSITION - ENDING $ 10,350,059.11 *Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance' in the revenue category. 81 25,165,289.00 26,173,629.00 24,736,129.00 (1,437,500.00) Inside COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET Information Technology - Operations (83600) AMENDED BUDGET FY 20113 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 16.52% - Fay. Enhanced Access Fees $369,000, Managed Print Services $40,100 and Deferred Land File Tax $5,700 due to higher than anticipated usage; Sale of Equipment $1,100 due to higher than anticipated usage. Offset by unfavorable Outside Agencies ($33,100) and Reimb Equalization Services ($4,500) due to reduction in external customer requests. -5.49% - Unfav. OC Depts Development Support & Non Governmental Development ($1,118,500) and OC Depts Operations & Non Governmental Operations ($319,000) due to rates remaining at prior year levels and limited resources available to complete development due to vacancies. OPERATING REVENUES: Outside $2,308,103.00 $2,306,103.00 $2,689,403.00 $351,300.00 TOTAL OPERATING REVENUE $28,473,392.00 $28,481,732.00 827,425,532.00 ($1,055,200,00) -3.71% OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN $38,297,176.00 $39,854,103.00 $38,957,603.00 $926,500.00 ($9,823,754.00) ($11,402,371.00) ($11,532,071.00) ($129,700.00) 105,500.00 105,500.00 107,500.00 2.000.00 3,906,676.00 4,346,154.00 4,346,164.00 2.32% Fay. Salaries & Fringes $1,113,800 due to vacant positions; Expendable Equipment $377,100 due to timing of equipment replacements; Equipment Maintenance $207,300 due to lower than anticipated hardware maintenance costs; Depreciation $193,000 for IT capital projects in progress not fully operational; Indirect Cost $119,300 and Contracted Services $15,400 due to actual charges being developed after budget finalization; Internal Services overall favorability of $13,500 primarily due to: Insurance Fund $8,500, Motor Pool Fuel Charges $4,500 and Leased Vehicles $2,400 due to lower than anticipated use offset by Telephone Communications ($1,500). Also fav. Printing $62,900 due to less than anticipated use. Partially offset by unfav. Professional Services ($813,300) for previously approved IT projects; Bank Charges ($176,100) and Charge Card Fees ($58,800) for increased credit card activity; Software Maintenance ($50,500) due to timing of software support; Supplies ($45,600) and Travel ($16,700) based on usage; Communications ($15,000) due to the on-going implementation change over to the new Universal Communications and Collaboration system. 1.90% Fay, Interest Income due to anticipated investment income. 0.00% TRANSFERS (OUT) 0.00% CAPITAL CONTRIBUTION 3,147,262.00 3,147,252.00 0.00% Fav Capital Contributions revenue recognized for Building Authority capital projects for IT. NET REV OVER(UNDER) EXP* ($5,811,608.00) ($6,950,707.00) ($3,931,145.00) $3,019,562.00 TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING 24,679,819.10 $20 748.674.10 "Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category. 82 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT INTERNAL SERVICE FUNDS! ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED AMENDED FY 2018 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - Telephone Communications (67500) OPERATING REVENUES: Outside $12,000.013 $12,000.00 $8,300.00 $ (3,700.00) -30.83% Unfav. Sale of Phone External due to reduction in landlIne charges. Inside 2,842,228.00 2,842,228,00 $2,837,328.00 (4,900.00) -0.17% Unfav. Sale of Phone Internal due to decreased usage. TOTAL OPERATING REVENUE OPERATING EXPENSES $2,854,228.00 $3,082,131.00 $2,854,228.00 $2,845,628.00 $3,082,131.00 83,221,931.00 (8,600.00) ($139,800.00) -0.30% -4.54% Unfav. Communications ($260,400) due to increased activity; Internal Services (842,200) primarily due to Info Tech Operations based on actual usage and costs; indirect Cost ($19,900) due to actual charges determined alter budget finalization and Equip Maintenance ($15,000) due to maintenance costs being higher than the budget projection. Partially offset by fay. Depreciation 8194,300 based on depreciation schedule and Salaries & Fringes $3,100 due to less than anticipated overtime. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN CAPITAL CONTRIBUTION TRANSFERS (OUT) ($227,903.00) ($227,903,00) 30,000.00 30,000.00 ($376,303.00) 31,700.00 ($148,400.00) 1,700,00 5.67% Fav. Interest Income due to anticipated Investment income. 0.00% 0.00% 0.00% NET REV OVER(UNDER) EXP* ($197,903.00) ($197.903.00) ($344,603.00) ($146,700.00) TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING 4,459,626.89 $4,125,023.139 "Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund BaIance" in the revenue category. 83 ($4,523,404,00) 35,000.00 1,644,186.00 ($2,812,104.00) $1,711.300.00 80,651.00 45,651.00 1,644,186.00 130.43% Fay. interest Income due to anticipated investment income. 0,00% 0,00% 0.00 0.00 0.00% COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET Information Technology - CLEM1S (53500) AMENDED BUDGET FY 2018 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUES: Outside $4;664,758.00 $4,664,758.00 $4,859,158.00 $194,400,00 4.17% Fay. Access Fees Non Oakland $31,100 due to updated law enforcement Full Time Equivalent count used for billing partially offset by unfav. Access Fees Oakland ($69,900) due to lower than anticipated activity; CLEMIS Crash $142,200, CLEMIS Citation $38,800, Crime Mapping $7,000 and CLEMIS Parking $3,400 due to increased usage by Oakland and non-Oakland agencies. Also fay. Maintenance Contracts $48,000 due to Livescan maintenance after warranty. Offset by unfav. Rebilled Charges ($5,000) and Parts and Accessories ($1,300) billed to Tier 2.5 and 3.0 agencies for connectivity costs. Inside 1,983,525.00 1,987,629.00 1,513,129,00 (474,500.00) -23.87% Unfav. Service Fees ($379,400) based on actual billing for Computer Aided Dispatch (CAD) expense charge directly to Radio Fund and Reimb General ($95,100) based on anticipated CLEMIS staff resources supporting Sheriff projects. TOTAL OPERATING REVENUE $6,648,283,00 $6,652,387.00 $6,372,287.00 ($280,100,00) -4.21% OPERATING EXPENSES $11,175,791.00 NET INCOME (LOSS) BEFORE OPERATING TRANSFERS ($4,527,508.00) NON-OPERATING REVENUE 35,000,00 TRANSFERS IN 1,644,186.00 TRANSFERS (OUT) CAPITAL CONTRIBUTION 0.00 NET REV OVER(UNDER) EXP* ($2,848,322.00) TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING $11,175,791.00 $9,184,391.00 $1,991,400,00 (52.844.218.00) ($1,087.267.00) $1,756,951.00 16,943,114.71 $15,855,847.71 17.82% Fay. Depreciation $1,214,600 based on depreciation schedules; Salaries & Fringe Benefits $711,060 due to vacancies; Software Rental $387,900 due to timing of expenses; internal Services $112,900 prima* due to IT Development based on actual usage; Communications $85,800 due to actual costs less than anticipated; Bank Charges $87,900 due to less than anticipated costs for PayPal services for E-Commerce transactions; Equipment Maintenance $81,000 for cost of repairs; Rebillable Services $7,200 based on actual connectivity costs to Tier 2.5 and 3.0 agencies; Printing $1,700 based on actual usage. Offset by unfav. Professional Services ($550,700) due to higher than anticipated contractual costs for stalling services; Expendable Equipment ($20,700) for equipment replacement; Supplies ($16,900) and Travel ($10,300) due to usage. 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. 84 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET AMENDED BUDGET FY 2018 FORECAST VARIANCE FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - Radio Communications (53600) OPERATING REVENUES: Outside $7,645,000.00 $7,645,000.00 $7,756,700.00 $111,700.00 146% • Fay. E-911 Surcharge $183,900 due to increased volume of users/receipt of 911 surcharge; Outside Agency Revenue $7,300 due to higher non-emergency agencies than anticipated. Offset by unfav. Antenna Site Management ($79,600) due to updates in rental contracts. Inside 490,000.00 490,000.00 514,700.00 24,700.00 5.04% Fay. primarily due to Parts Access reimbursement by participating agencies for equipment replacement. TOTAL OPERATING REVENUE $8,135,000.00 $8,135,000.00 $8,271,400.00 8136,400.00 1.68% OPERATING EXPENSES 814,109,201.00 $14,777,201.00 $11,209,701.00 $3,567,500.00 24.14% Fay. Software Maintenance $1,872,900 due to the timing of the Emergency Services IP Network project; Depreciation $737,200 based on depreciation schedule; Internal Services $332,200 primarily due to Info Tech CLEMIS based on usage; Professional Services $450,000 due to less than anticipated use; Equipment Maintenance $105,000 due to less than anticipated maintenance costs; Training Related $75,000 due to timing of implementing Radio Upgrade project Salaries and Fringe Benefits $23,500 due to vacancies; Utilities $17,700 and Supplies $7,100 due to usage. Offset by unfav. Communications ($50,100) and Indirect Cost ($3,000) due to charges determined after finalization of budget. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN ($5,974,201,00) ($6,642,201.00) 210,000.00 210,000.00 52,500.00 ($2,938,301.00) $3,703,900.00 210,000.00 52,800.00 0.00% 0.00% TRANSFERS (OUT) 334,000.00 334,000.00 0.00% CAPITAL CONTRIBUTION NET REV OVER(UNDER) EXP* ($5,764,201.00) ($6,045,401.00) ($2,341,501.00) $3,703,900.00 TOTAL NET POSITION - BEGINNING 35,934,002.39 TOTAL NET POSITION - ENDING $33,592 501.39 Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses. 0.00% 85 COUNTY OF OAKLAND FY 2018 SECOND QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET AMENDED BUDGET FY 2018 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Fire Records Management ( 63100) OPERATING REVENUES: Outside $231,566.00 $231,566.00 $253,166.00 $21,600.00 9.33% Fay. primarily due to Participation Fees for Non-Oakland Agencies; the following agencies have been added: Eastpointe, Roseville and St. Clair Shores. TOTAL OPERATING REVENUES $231,566.00 $231,566.00 $253,166.00 $21,600.00 9.33% OPERATING EXPENSES $826,870.00 $826,1370,00 $609,070.00 $217,800.00 26.34% Fay. Salaries & Fringes $209,500 due to vacancies; Depreciation $42,400 based on depreciation schedule; Communications $20,000 due to decrease in connectivity rates; Software Maintenance $6,800 due to decrease in maintenance costs; Travel $5,000 due to less than anticipated use; Expendable Equipment $3,530 due to the timing of equipment purchases made by tech support for maintaining the system and Equipment Maintenance $1,000 due to lower than anticipated maintenance costs. Offset by unfav. overall Internal Services ($49,800) primarily due to IT Development based on actual usage; Professional Services ($15,000) due to higher than anticipated contractual costs and Indirect Costs ($5,600) due to actual charges determined after budget finalization. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS ($595,304.00) ($595,304.00) ($355,904.00) $239,400.00 NDN-OPERATING REVENUE 3,000.00 3,003.30 4,239.00 1,209.00 40.30% Fay. Interest Income due to anticipated investment income. TRANSFERS IN 477,919.00 477,919.00 477,919.00 0.00% TRANSFERS (OUT) 0.00% CAPITAL CONTRIBUTION 0.00% NET REV OVER(UNDER) EXP" ($114,365.00) ($114,385.00) 5126,224.00 $240,609.00 TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING 1,437.818.71 $1 564.042.71 *Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance" in the revenue category and Budgeted Equity Adj in Expenses. 86 OAKLAND COUNTY COMMUNITY & HOME IMPROVEMENT DIVISION HOME IMPROVEMENT PROGRAM UNCOLLECTIBLE LOANS 2ND QUARTER FY 2018 CVT ZIP CODE CASE NO. WRITE OFF AMOUNT MCI 565.382 GRANT CDBG/HOME Berkley 48072 63-532 $ 4,029.00 MCL 565.382 RENTAL REHAB Highland 48357 1313 $ 5,460.00 MCL 565,382 CDBG Madison Hts 48071 1373 $ 5,114.00 Ma 565.382 CDBG New Hudson 48165 1443 $ 1,810.00 MCL 565.382 CDBG Union Lake 48386 1444 $ 2,557.00 MCL 565.382 CDBG Ferndale 48220 1456 $ 7,696.00 MCI 565.382 CDBG Madison Hts 48071 1487 $ 1,783.00 Ma 565.382 CDBG Madison Hts 48071 1501 $ 4,860.00 Ma 565.382 CDBG Ferndale 48220 1503 $ 5,114.00 MCL 565382 CDBG Ferndale 48220 1550 $ 458.66 MCL 565.382 CDBG White Lake 48386 1553 $ 6,176.00 MCI 565.382 CDBG Highland 48356 1558 $ 6,373.00 MCI 565.382 CDBG Hazel Park 48030 1568 $ 5,121.00 MCL 565.382 CDBG Hazel Park 48030 1584 $ 7,074.00 MCL 565.382 CDBG Highland 48356 1595 $ 6,177.00 MCI 565.382 CDBG Highland 48356 1596 $ 4,693.00 MCL 565.382 CDBG White Lake 48383 1613 $ 1,315.00 MCI. 565.382 CDBG Oak Park 48237 1630 $ 2,199.00 Ma 565.382 CDBG Oak Park 48237 1634 $ 1,180,00 Ma 565.382 CDBG Berkley 48072 1635 $ 6,108.00 MCL 565.382 CDBG Keego Harbor 48320 1652 $ 6,354.00 MCL 565.382 CDBG Oak Park 48237 1706 $ 6,000.00 MCI 565.382 CDBG Rochester Hills 48307 1763 $ 954,46 MCL 565.382 CDBG Rochester Hills 48307 1764 $ 5,319.00 MCL 565.382 CDBG Rochester Hills 48307 1778 $ 7,386.00 MCL 565.382 CDBG Auburn Hills 48326 1801 $ 2,800.00 MCL 565.382 CDBG Highland 48357 1811 $ 1,785.00 MCL 565.382 CDBG Ortonville 48462 1831 $ 4,707.00 15,646.75-I MCI 565.382 MCL 565.382 CDBG CDBG Holly 48442 1847 Oak Park 48237 1872 2,717.70 MCL 565.382 CDBG Highland 48356 1877 $ 3,292.28 MCL 565.382 CDBG Hazel Park 48030 1906 $ 4,617.00 MCL 565.382 CDBG Pontiac 48057 1962 7,040.00 Ma 565.382 CDBG Clarkston 48348 1989 $ 2,030,00 Ma 565.382 CDBG Commerce Twp 48390 2020 $ 7,337.00 MCL 565.382 CDBG Oak Park 48237 2036 $ 254.12 MCI 565,382 CDBG Milford 48381 2046 $ 11,299.00 MCL 565.382 CDBG Wolverine Lake 48390 2047 3,025,00 MCL 565.382 CDBG Clarkston 48346 2083 13,858,13 Ma 565.382 CDBG 87 Madison Hts 48071 2120 $ 3,860.00 MCI 565.382 CDBG Clarkston 48348 2133 $ 2,938.00 MCI 565.382 CDBG Rochester Hills 48307 2138 $ 2,000.34 MCI 565.382 CDBG Ortonville 48462 2139 $ 7,977.00 MCL 565.382 CDBG Auburn Hills 48326 2145 $ 5,193.00 MCL 565.382 CDBG Clarkston 48346 2156 3,276.00 MCL 565.382 CDBG White Lake 48386 2212 7,145.00 MCL 565,382 CDBG Rochester Hills 48307 2232 $ 6,940.00 MCL 565.382 CDBG Hazel Park 48030 2238 $ 11,314.00 MCL 565.382 CDBG Madison Hts 48072 2240 $ 7,829.00 MCL 565.382 CDBG Madison Hts 48072 2245 4,034.00 MCL 565.382 CDBG Rochester Hills 48307 2304 7,495.00 MCL 565.382 CDBG Hazel Park 48030 2310 5,884.00 MCL 565.382 CDBG W Bloomfield 48323 2322 $ 7,529.00 MCL 565.382 CDBG Hazel Park 48030 2350 $ 7,485.00 MCI 565.382 CDBG Commerce Twp 48382 48309 2388 $ 6,990.00 MCL 565.382 CDBG Rochester Hills 2404 $ 7,628.44 MCL 565.382 CDBG Clarkston 48346 2436 $ 2,619.00 MCI 565,382 CDBG Highland 48356 2448 2465 $ 4,124.00 MCL 565.382 CDBG Oxford 48371 7,597.00 MCL 565,382 CDBG W Bloomfield 48323 2492 $ 7,416.00 MCL 565.382 CDBG Holly 48442 2501 $ 6,653.00 MCL 565.382 CDBG Oak Park 48327 2505 $ 3,253.86 MCL 565.382 CDBG White Lake 48386 2524 6,886.00 MCL 565.382 CDBG Highland 48357 2540 $ 3,163.00 MCI 565.382 CDBG Beverly Hills 48025 2550 $ 6,940.00 MCL 565.382 CDBG Oak Park 48237 2552 $ 7,700.00 MCL 565.382 CDBG Troy 48085 2553 $ 7,700.00 MCL 565.382 CDBG Oxford 48371 2575 $ 7,200,00 MCL 565.382 CDBG Ferndale 48220 2596 $ 7,550.00 MCL 565.382 CDBG Ferndale 48220 2597 $ 6,242.00 MCL 565.382 CDBG Ferndale 48220 2622 $ 1,260.00 MCL 565.382 CDBG Commerce Twp 48382 2629 $ 6,835.00 MCL 565.382 CDBG White Lake 48383 2632 $ 9,851.84 MCI 565.382 CDBG Oak Park 48237 2646 $ 7,523.00 MCI 565.382 CDBG Clawson 48017 2661 $ 7,625,00 MCL 565.382 CDBG Clawson 48017 2690 $ 7,275.00 MCI 565.382 CDBG Hazel Park 48030 2707 $ 7,880.00 MCL 565.382 CDBG Madison Hts 48071 2726 $ 7,350,00 MCL 565.382 CDBG Rochester Hills 48307 2729 $ 4,515.62 MCI 565.382 CDBG Madison Hts 48071 2739 $ 7,616.00 MCL 565.382 CDBG Troy 48085 2778 7,580.00 MCL 565.382 CDBG White Lake 48386 2785 $ 3,230.00 MCL 565.382 CDBG Madison Hts 48071 2804 $ 6,560.00 MCL 565.382 CDBG Berkley 48072 2824 6,050.00 MCL 565.382 CDBG White Lake 48386 2859 6,351.00 MCL 565.382 CDBG Hazel Park 48030 2862 $ 7,453.00 MCL 565.382 CDBG 88 Commerce Twp 48382 2893 3,388.00 MCL 565.382 CDBG Hazel Park 48030 2932 1,596.00 MCL 565.382 CDBG Hazel Park 48030 2945 7,445.00 MCL 565.382 CDBG White Lake 48386 2955 $ 7,641.00 MCL 565,382 CDBG Madison Hts 48071 2964 $ 6,520.00 MCL 565.382 CDBG Oak Park 48237 2965 $ 7,689.00 MCL 565.382 CDBG Ferndale 48220 2984 $ 7,692.00 MCL 565.382 CDBG Hazel Park 48030 2996 $ 7,700,00 MCL 565.382 CDBG Keego Harbor 48320 3014 $ 7,700.00 MCL 565.382 CDBG Ferndale 48220 3020 6,520.00 MCL 565.382 CDBG Oak Park 48237 3054 $ 7,120.00 MCL 565.382 CDBG Berkley 48072 3080 $ 7,665.00 MCL 565,382 CDBG Hazel Park 48030 3101 $ 7,380.00 MCL 565.382 CDBG Hazel Park 48030 3102 $ 2,230.00 MCI 565.382 CDBG Madison Hts 48071 3109 $ 2,885.00 MCL 565.382 CDBG Hazel Park 48030 3110 $ 6,981.00 MCL 565.382 CDBG Holly 48442 48071 3115 $ 7,428.00 MCL 565,382 CDBG Madison Hts 3118 6,818.00 MCL 565.382 CDBG White Lake 48383 3128 $ 6,850.00 MCI 565.382 CDBG Total $ 606,485.20 i 'I 0 ‘ Chief of Operations April 13, 2018 Nik Gordon A. Lambert, 89 OAKLAND COUNTY COMMUNITY & HOME IMPROVEMENT DIVISION HOME IMPROVEMENT PROGRAM UNCOLLECTIBLE LOANS 2ND QUARTER FY 2018 CVT ZIP CODE CASE NO. WRITE OFF AMOUNT TAX/ MORTGAGE GRANT CDBG/HOME Ferndale 48220 10204 $25,115.00 MORTGAGE HOME Commerce 48382 9941 $7,798.00 MORTGAGE HOME Hazel Park 48030 9704 $9,930.00 MORTGAGE HOME Oak Park 48237 9067 $22,094.00 MORTGAGE HOME Oak Park 48237 6536 $15,911.41 MORTGAGE CDGB Oak Park 48237 5935 $23,057,33 MORTGAGE CDGB Madison Heights 48071 5791 $9,701.59 MORTGAGE CDGB Hazel Park 48030 4634 $13,464.00 MORTGAGE CDGB Total $127,071.33 j / ,....---"li Gordon A. Lambert, Chief of Operations April 13, 2018 i 90 TransactionDate ADD 08121/17 ...:lOCESOCAPpreval.:;' Date (it>$1000) OAKLAND COUNTY PARKS & RECREATION COMMISSION FY2018 Uncollectible Debt Write-offs January 1, 2018- March 31, 2018 1 Narriegast, First) OR last four digits of credit card # Randazzo, Michael Type. of.. Case Number DebtAlf Credit Accounts Receivable n/a Description of Revenue Owed. Camping 'Month ArrieUnt Written-off 66.00 03118 Total 66.00 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: C ASDatalMy DocumerasTrian\Cash Management\ Debt Write-OffslOCPR Uncollectible Debt Write-offs.xlsx FY2018-Q2 4/24/2018 5:05 PM 91 OAKLAND COUNTY PROSECUTING ATTORNEY Donations - FY 2018 Second Quarter Date of Donation Dono Amount Journal umber 3/15/2018 Haven 3/15/2018 Parents of Murdered Children, Inc 4/18/2018 Common Ground 3/15/2018 Emily McIntyre Hancook Grand Total $25.00 $25.00 $25.00 $127.28 $202.28 281971 281971 283833 281971 92 Department of Health and Human Services Oakland County Children's Village Donation Tracking : Donation Period January 2018 to March 2018 Date: Donor: Cash/Check: Items: Estimated Value: University Presbyterian Church Frozen Birthday Cakes (3) Months $495.00 1/4/2018 ACEDS Detroit Check $235.00 1/4/2018 Leoni Engineering Check $654.56 1/16/2018 Sweet Dreams for Kids (15) Pillowcases $225.00 1/17/2018 M. Pawlak (4) Handmade Quilts $100.00 1/17/2018 Our Lady of Refuge New Games for Mandy's Place $200.00 1/22/2018 Waterford Library (1) Bag of Yarn $45.00 1/22/2018 Anonymous Hats, Coats, T-shirts & Pants $752.00 1/24/2018 Kimberly Blaine Boys Clothes, Boots, Outerwear $325.00 1/26/2018 Crosshairs Foundation Check $1,000.00 1/26/2018 Senior's Men Club of Birmingham Check $3,450.00 1/31/2018 Detroit Auto Dealers Association Auto Show Tickets for Mandy's Place $140.00 1/31/2018 Karen Koshen Suitcase $50,00 2/5/2018 Pastor Douglas Jones Event for Mandy's Place-Pizza & Pop $120.00 2/7/2018 Karen Kalmer Ping Pong Paddles $16.99 2/8/2018 Barb Finney Men's/Boys Clothing $300.00 2/8/2018 Rebecca Lopez Clothing and Games $10.00 2/9/2018 CV Foundation Gas Cards for Resident Parents $1,000.00 2/9/2018 CV Foundation Donation to Furniture Bank-Resident Family $75.00 2/10/2018 Waterford Library (3) Bags of Yarn $50.00 2/13/2018 Datsun Doctor Magazines for Lobby $10.50 2/13/2018 Sweet Dreams for Kids (15) Pillowcases $225.00 2/14/2018 Renate Kovakli Physics Book $9.00 2/14/2018 Mark & Lisa Ziskie Clothing $50.00 2/15/2018 Clarkston Senior Center (2) Bags of Yarn $30.00 2/15/2018 George Miller Crafts, Toys, Pillows, Hats, Gloves & Lotions $300,00 2/15/2018 George Miller Sheet Cake for Mandy's Place $50.00 2/22/2018 Senior's Men Club of Birmingham Check $125.00 2/24/2018 L. Simon 36 Magazines $3.00 2/27/2018 Ken Rogers Check $100.00 2/27/2018 William Buck Check $100.00 2/28/2018 Mr. & Mrs. Luchenbach Check $50.00 CAUsers\strongl\Desktop\2nd Cirtr. Donation Tracking Sheet FY18.xlsx 93 Department of Health and Human Services Oakland County Children's Village Donation Tracking : Donation Period January 2018 to March 2018 Date: Donor: Cash/Check: Items: Estimated Value: 3/1/2018 Datsun Doctor Magazines for Lobby $7.00 3/2/2018 Clarkston Knit Shop (2) Bags of Yarn $70.00 3/5/2018 Lake Crest Baptist Church Easter Basket of Snacks $20.00 3/5/2018 Clarkston Senior Center (2) Packs Adult Diapers $18.00 3/6/2018 Datsun Doctor Magazines for Lobby $10.00 3/8/2018 Clarkston Senior Center (2) Packs Adult Diapers & (8) Packs Blue Pads $96.00 3/12/2018 Soled Shermon Suitcase $5.00 3/12/2018 Lori Strong Young Men's Clothing New/Used $40.00 3/14/2018 Jim & Rena Honer Clothing $25.00 3/13/2018 CV Foundation Teachers Pet for Calendar Year 2018 $6,800.00 3/16/2018 Mr. gf. Mrs. Morley Check $50.00 3/19/2018 Waterford Senior Center New Blanket & Pillows $20.00 3/20/2018 Sweet Dreams for Kids (15) Pillowcases $225.00 3/1/2018 Senior's Men Club of Birmingham Returned Check Closed Account -JE#282153 -$50.00 3/23/2018 Steven Burman (193) Books $136.00 3/26/2018 Waterford Senior Center (2) Bags of Yarn & (2) Bags of Poly-fill $25.00 Total: $17,793.05 C:\Users\strongl\Desktop\2nd Qrtr. Donation Tracking Sheet FY18.xisx 94 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2018 Second Quarter . D te of Donation Donor Receipt Number Amount Journal Number 1/212018 Helen Kotwicki 20262 $20.00 278013 1/212018 Hilary Kokerios 20280 $16.00 278013 1/3/2018 Angela Williams 20310 $40.00 278106 1/3/2018 Donation Box 20311 $33.00 278106 1/3/2018 Joseph & Darlene Pulcini 20312 $30.00 278106 1/3/2018 Gloria & David Shipley 20323 $100.00 278106 1/3/2018 Lynne Thompson 20327 $42.50 278106 1/4/2018 Mark Mudd 20339 $5.00 278192 1/4/2018 Linda & David Londo 20340 $10.00 278192 1/4/2018 Deporre Family Foundation 20369 $333.33 278192 1/4/2018 Donation Box 20372 $81.37 278192 1/5/2018 Donation Box 20381 $83.00 278254 1/5/2018 Donation Box 20394 $15.00 278254 1/6/2018 Bonnie Sciba 20426 $25.00 278255 1/10/2018 Randall Smithling 20477 $7.50 278501 1/1112018 Donation Box 20509 $2330 278589 1/11/2018 Stephen Sparks 20529 $1.00 278589 1/11/2018 Michelle Swigart 20538 $28.00 278589 1/16/2018 Anita Holtz 20594 $100.00 278790 1/17/2018 Tammy Gaspas 20616 $220.00 278894 1/18/2018 Donation Box 20633 $22.00 278999 1/18/2018 Elissa Staeuble 20645 $15.00 278999 1/18/2018 John Little 20648 $5.00 278999 1/19/2018 Steven Stewart 20674 $8.00 279057 1/19/2018 Steven Stewart 20675 $60.00 279057 1/20/2018 Donation Box 20732 $18.00 279058 1/20/2018 Melissa Grubbs 20733 $50.00 279058 1/22/2018 Donation Box 20734 $87.00 279182 1/22/2018 William Rex 20736 $39.50 279182 1/22/2018 Donation Box 20741 $20.00 279182 1/23/2018 Donation Box 20762 $17.25 279266 95 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2018 Second Quarter Date of Donation Donor Receipt Number Amount $2.50 Journal Number 279362 1/24/2018 Jake Kropinski 20798 1/2412018 Morgan Hammon 20800 $2.50 279362 1/25/2018 Lynn Dodson 20826 550.00 279437 1/25/2018 Aaron Levine 20828 5100.00 279437 1125/2018 Jennifer Schneider 20836 $50.00 279437 1/26/2018 Lakes Community Credit Union 20904 $113.00 279495 1/29/2018 Bert & Larry Wilmot 20954 $1,000.00 279575 1/31/2018 Mark Mudd 21001 $5.00 279745 2/1/2018 Ron Rossi 21010 $50.00 279826 2/1/2018 Donna Wilder 21014 5100.00 279826 2/1/2018 Donation Box 21029 5157.75 279826 2/2/2018 Dade Dimaggio 21033 515.00 279915 2/2/2018 Janet McKervey 21044 $10.00 279915 2/5/2018 Alex Yuen-Ting Siu 21104 $50.00 279977 2/5/2018 Vance Hardiman 21116 $1.00 279977 2/9/2018 Mike Schoemann 21187 $50.00 280280 2/12/2018 Donation Box 21236 $8.00 280359 2/12/2018 Janet McKee 21242 $5.00 280359 2/12/2018 Melissa Bowman 21246 $5.00 280359 2/13/2018 John Little 21266 55.00 280469 2/13/2018 Elissa Staeuhle 21267 $15.00 280469 2/13/2018 Cristina Artalejo 21274 $0.50 280469 2/13/2018 Takata 21279 $400.00 280469 2/14/2018 Jennifer Dow 21289 $50.00 280556 2/14/2018 Kristina Hoffner 21344 $20.00 280556 2/16/2018 Donation Box 21340 $39.87 280636 2/17/2018 Brian Radovanovic 21383 $25.00 280680 2/20/2018 Toni Weddle 21401 $50.00 280741 2/20/2018 Donation Box 21428 515.00 280741 2/22/2018 Karen Pouender 21457 $21.00 280879 2/22/2018 Howard Leake 21467 $50.00 280879 96 OAKLAND COUNTY ANIMAL CONTROL AND PET ADOPTION CENTER Restricted Fund (Legacy) Donations - FY 2018 Second Quarter Date of Donation Donor Receipt Number Amount $50.00 Journal Number ......... 280919 2/2312018 Howard Leake 21488 2127/2018 Janet McKervey 21612 $10.00 281083 3/1/2018 Pet Supplies Plus Waterford 21667 $235.40 281248 3/2/2018 Russell Becker 21698 $34.00 281338 3/3/2018 Nancy Connor 21735 $190.25 281339 3/6/2018 Mark Mudd 21778 $5.00 281512 3/6/2018 AIlie Gorcyca 21783 $25.00 281512 3/6/2018 Jessica Smith 21797 $139.50 281512 3/6/2018 Donation Box 21809 $6.30 281512 3/10/2018 Christine Bresett 21904 $28.00 281718 3/13/2018 Donation Box 21953 $4.50 281898 3/1312018 Elissa Staeuble 51954 $15.00 281898 3/13/2018 John Little 21955 $5.00 281898 3/13/2018 Jasmine Daniel 21970 $5.00 281898 3/14/2018 Donation Box 21993 $19.00 281991 3/15/2018 Donation Box 22020 $9.50 282050 3/15/2018 Donation Box 22034 $11.50 282050 3/17/2018 Pet Supplies Plus Waterford 22066 $114.00 282116 3/19/2018 A.G. Holtz 22109 $50.00 282169 3/20/2018 Sandra Hays 22152 $25.00 282260 3/23/2018 Karrie Cortes 22227 $14.00 282447 3/24/2018 Donation Box 22255 $59.00 282448 3/26/2018 Linda Houlihan 22277 $0.25 282531 3/26/2018 Janet McKervey 22290 $10.00 282531 3/28/2018 Kimberly Bockhorn 22361 $42.50 282684 3/28/2018 Ramona Nave 22363 $1,200.00 282684 3/29/2018 Virginia Dyke 22389 $20.00 28268 3/30/2018 Donation Box 22428 $43.00 282839 Grand Total $6,392.77 97 OAKLAND COUNTY VETERANS SERVICES Veterans Services Donations - FY 2018 Second Quarter ReceiPt Nunlber Journal Number oTiation Donor Amount 5/11/2018 Stoney Creek Chapter of the Daughters of the American Revolution Health Receipt 54486 3,911.60 0000286161 Second Quarter 2018 Total $3;011.60_ 98 OAKLAND COUNTY PARKS & RECREATION COMMISSION FY 2018 2nd Quarter Report for Contributions (Donations) - January 1, 2018 - March 31, 2018 Budget Center Project / Program Source otais Amount IND Nature Center Improvements ITC Holdings Corp., $5,000.00 REC REC REC REC REC Park Patron Park Patron Park Patron Park Patron Park Patron General Donation Tuning Your Tot Contribution Animal Care Tuning Your Tot Contribution. General Donation Independence Oaks Park Sub -Total $1.00 $8.00 $1.00 $10.00 $10.00 . Recreation Program's.. & $ervitns.SuWTOta $5,000.00 $30.00 FY2018 2nd Quarter Contributions (Donations) Revenue Grand Total $5,030.00 99 Resolution #18236 June 13, 2018 Moved by Hoffman supported by Zack the resolutions (with fiscal notes attached) on the amended Consent Agenda be adopted (with accompanying reports being accepted), AYES: Crawford. Fleming, Gershenson, Hoffman, Jackson, Kochenderfer, KowaII, Long, McGillivray, Middleton, Quarles, Spisz, Taub, Tietz, Weipert, Woodward, Zack, Berman, Bowman. (19) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the amended Consent Agenda were adopted (with accompanying reports being accepted). I HEREBY Ar3PAciste tHIS RESOLUTION CHIEF DEPUTY COUNTY EXECUTIVE ACTING PURSUANT TO MCL 46.559A (7) STATE OF MICHIGAN) COUNTY OF OAKLAND) Lisa Brown, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on June 13, 2018, with the original record thereof now remaining in my office. In Testimony Whereof, I have hereunto set my hand and affixed the seal of the County of Oakland at Pontiac, Michigan this 13th day of June, 2018. Lisa Brown, Oakland County