Loading...
HomeMy WebLinkAboutResolutions - 2016.03.17 - 22224MISCELLANEOUS RESOLUTION #16041 March 17, 2016 BY: FINANCE COMMITTEE, TOM MIDDLETON, CHAIRPERSON IN RE: DEPARTMENT OF MANAGEMENT AND BUDGET - FISCAL YEAR 2016 FIRST QUARTER FINANCIAL FORECAST AND BUDGET AMENDMENTS TO THE OAKLAND COUNTY BOARD OF COMMISSIONERS Chairperson, Ladies and Gentlemen: WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of Government, provides for adjustments to the adopted budget; and WHEREAS in accordance with Oakland County General Appropriations Act Section 22, which authorizes budget amendments for variances between the budgeted revenue and actual revenue, and Section 23, which authorizes budget amendments for variance between estimated revenue and projected expenditures, amendments are required; and WHEREAS the Fiscal Year (FY) 2016 First Quarter Financial Forecast Report has identified several variances and budget amendments are recommended; and WHEREAS a budget amendment is recommended to recognize the Restore Foundation donation in the amount of the $550 and transfer from Circuit Court's General Fund to Juvenile Drug Court (JDC) Grant (#27140); and WHEREAS a budget amendment is recommended to re-appropriate funds in the amount of $26,572 from Circuit Court Child Care Fund (#20293) State Institution line item to Circuit Court General Fund (#10100) Software Maintenance Support line item to cover funding required for the use of the State of Michigan's Trial Court Services (TCS) Case Management System; and WHEREAS a budget amendment totaling $39,000 is recommended to reallocate a portion of District Court's Miscellaneous Revenue Line Item to Reirnb Interpreter Fees Line Item to more accurately account for actual activity; and WHEREAS a budget amendment totaling $76,000 is recommended to reallocate funds from Probate Court's Professional Services line item and Non-Departmental General Fund IT Development to Probate Court's Software Maintenance Support line item to cover funding required for the use of the State of Michigan's TCS Case Management System; 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 $43,457 is being recognized for eligible forensic lab and dispatch costs; and WHEREAS a budget amendment of $14,378 is recommended for the Sheriff's Office to cover the additional cost for the purchase of seven (7) Mobile Data Computers (MDCs) with cameras that were authorized under Miscellaneous Resolutions: #15299, #15294, #15295, #15296 and #15297; and WHEREAS a budget amendment of $24,500 is recommended for the Sheriff's Office to purchase seven (7) portable hand-held radios which were inadvertently omitted from Miscellaneous Resolutions: #15294, #15295, #15296, #15297 and #15299; and WHEREAS a budget amendment of $27,664 is recommended for the Sheriff's Office to purchase seven (7) hand-held portable radios for the seven (7) part-time non-eligible positions that were added for building security (MR. #15026, #15208 and #15275); and WHEREAS a budget amendment of $47,215 is recommended for the Sheriffs Office to reallocate costs associated with building space vacated by IT CLEMIS and occupied by the Sheriff's Office Emergency Communications Dispatch unit; and WHEREAS a budget amendment is recommended for the County Clerk/Register of Deeds Department Clerks Division to reallocate $3,000 of Court Transcripts line item to Overtime and $4,156 from Professional Services line item to Expendable Equipment to more accurately account for actual activity; and WHEREAS a budget amendment of $8,000 is recommended for the County Clerk/Register of Deeds Department Elections Division to reflect the operating revenue and expenditure budgets for upcoming 2016 elections; and WHEREAS a budget amendment is recommended for the Treasurer's Department to reallocate $49,200 from Title Search line item to Software Rental Lease Purchase line item for the purchase of debt management software; and FINANCE COMMITTEE VOTE: Motion carried unanimously on a roll call vote. WHEREAS a budget amendment of $64,984 is recommended for FY 2016, $70,403 for FY 2017 and $70,642 for FY 2018 which reallocates the budgets for Building Space Allocation between for the Treasurer's Department General Fund (#10100) and Delinquent Personal Property Tax Administration Fund (#51800) to properly match actuals to budget due to space reconfiguration; and WHEREAS a budget amendment of $88,345 is recommended for the Human Resources Department to reallocate the budget between the proper divisions and programs; and WHEREAS a budget amendment is recommended to transfer additional funding in the amount of $9,687 from Human Resources General Fund to the Project Work Order Fund (total project cost of $27,701) to redesign the structure of cubicles for the Workforce Management Division within Human Resources to provide efficiencies in workflow and increase collaboration, per M.R. #15231 which allows for administrative approval of Capital Improvement Projects under $30,000; and WHEREAS a budget amendment is recommended to transfer funding from the General Fund Assigned Fund Balance for Pandemic Response (GL Account #383358) to the Health Division in the amount of $159,000 for FY 2016 in order to assist local CVT's with abatement issues as well as develop an awareness campaign for the Zika Virus; and WHEREAS a budget amendment is recommended within the Health and Human Services Administration Division in the amount of $7,000 for FY 2016, $11,555 for FY 2017 and FY 2018 to increase the administrative match portion of the Area Agency on Aging (AAA-1B) contract; and WHEREAS a budget amendment is recommended to reallocate funding in the amount of $26,899 from the Health and Human Services Administration Division to the Homeland Security Division to fund the use of a County wide Emergency Notification System; and WHEREAS a budget amendment is recommended to transfer funds in the amount of $1,390 from the Children's Village Donations Fund (#21330) to the Child Care Fund (#20293) which properly accounts for expenditures eligible for Children's Village Donation funding; and WHEREAS a budget amendment of $16,196 is recommended to transfer funding from Animal Control's Legacy Fund (#21310) to Information Technology Fund (#63600) to cover additional cost for the Mobile Data Computers' modems and antenna approved per M.R. #15187; and WHEREAS a budget amendment in the amount of $3,709 is recommended in Economic Development & Community Affairs (EDCA) for operating revenues and expenditures related to the Fire and Ice Festival; and WHEREAS a budget amendment in the amount of $139,000 to reallocate funds between programs in Economic Development & Community Affairs for operating revenues and expenditures related to the Main Street Oakland County program; and WHEREAS Planning and Economic Development Services received a $10,000 contribution from Detroit Regional Chamber of Commerce and the Michigan Economic Development Corporation for sponsorship of planned 2016 support to improve economic development coordination between EDCA and Oakland County communities; and WHEREAS Planning and Economic Development Services received a $5,529 contribution from Detroit Regional Chamber of Commerce in support of EDCA's involvement with Manufacturing Day on October 2,2015; and WHEREAS Planning and Economic Development Services received a $31,398 contribution from Michigan Economic Development Corporation for software support of the Salesforce product; and WHEREAS a budget amendment in the amount of $14,208 is recommended to transfer funds from Economic Development & Community Affairs to Information Technology fund (#63600) for the 2016 EDCA Digital Promotions project; and WHEREAS a budget amendment is recommended in the amount of $78,681 from the No-Haz Donation restricted fund (#21380) to the General Fund to properly account for prior year program revenue; and WHEREAS a budget amendment of $538,381 is recommended to correct the funding source for the Building Security Enhancement Priority 1 (part 2 of 3) Project approved per M.R. #16018 from the Capital Improvement Program/Building Fund (#40100) to the General Fund Assigned Fund Balance for Homeland Security Enhancements (GL Account #383455);and WHEREAS a budget amendment of $295 is recommended for the FY 2016 Michigan Drug Court Grant Program (MDCGP) to reallocate line item budgets to reflect Amendment #1 within 15% of grant award; and WHEREAS a budget amendment of $25,651 in FY 2016 and $34,512 in FY 2017 and FY 2018 is recommended to correct the Department number (from 3010402 to 3010404) per Human Resources/Friend of the Court request for salaries, fringes, and associated operating costs for the newly created FOC Court Clinical Psychologist (M.R. #16024); and WHEREAS a budget amendment of $434,107 is recommended to the correct the project chartfields for the FY 2016 Narcotics Enforcement Team (NET) Byrne Grant (Fund #27320); and WHEREAS a budget amendment is recommended to recognize that the Health Division has received additional funding from MDCH through the Comprehensive Planning, Budgeting, and Contracting (CPBC) Agreement in the amount of $63,105 which is less than fifteen percent of the original agreement required to accept each of the amendments via separate resolution; and WHEREAS the Economic Development Corporation (EDC) Board has approved the FY 2016 Special Revenue Budget for the EDC in the amount of $24,600, a reduction of ($4,100) from FY 2015; a budget amendment is required to amend the FY 2016 Special Revenue budget; and WHEREAS a budget amendment of $7,300 is recommended within the Sheriff's Office to cover the additional cost of batteries, battery cradle and increased radio range for the i-Robot project; authorized under M.R. #15267; funding is available from the Sheriff's Law Enforcement Enhancement Fund (#21341) to the Justice Assistance Grant (JAG Fund) (#27322); and WHEREAS a FY2016 Parks and Recreation (#50800) budget amendment is recommended to increase the depreciation budget by $216,785 to align with projected depreciation schedules; and WHEREAS the Parks and Recreation Commission approved a FY2016 budget amendment on March 1, 2016 to reduce the FY2016 operating budget by $747,444 reflecting current revenue and expense projections; and WHEREAS a Parks and Recreation budget amendment is recommended to transfer General Program Administration funds in the amount of $14,765 from the Facilities Maintenance cost center to various cost centers incurring expenses during the first quarter of FY2016; and WHEREAS an amendment is recommended to Telephone Communications Fund (#67500) to reallocate funds in the amount of $128,000 for to more accurately reflect budget with actual usage; and WHEREAS a budget amendment is recommended to transfer funding in the amount of $7,130 from the Law Enforcement Enhance Lab Fees Fund to the Project Work Order Fund to construct an office for the Assistant Laboratory Director within the Sheriff's Office Forensic Science Lab, per M.R. #15231 which allows for administrative approval of Capital Improvement Projects under $30,000; and WHEREAS a budget amendment is recommended to correct the Project ID for Building Security Enhancement Priority 1 (part 1 of 3) Project approved per M.R. #15275; and WHEREAS a budget amendment is recommended to transfer funding in the amount of $15,541 from the Building Improvement Fund to the Project Work Order Fund remodel the Information Technology Executive Office area on the 2nd floor to facilitate a cyber security work area, per M.R. *15231 which allows for administrative approval of Capital Improvement Projects under $30,000; and WHEREAS a budget amendment is recommended to transfer funding in the amount of $28,302 from the Building Improvement Fund to the Project Work Order Fund construct a separate woman's bathroom within the Radio Shop as referenced in the FY2016 — FY2025 Capital improvement Program, per M.R. #15231 which allows for administrative approval of Capital Improvement Projects under $30,000; and WHEREAS a budget amendment of $8,000,000 is recommended for the FY 2016 Fringe Benefit rate adjustment that was made effective December 26, 2015 due to better than anticipated FY 2015 year end operating results in the Fringe Benefit Fund. The rate adjustment is a one-time adjustment for FY 2016 and is not expected to continue for FY 2017 and FY 2018. The FY 2016 savings associated with the General Fund/General Purpose funds will be used for one-time capital facility and technology projects; 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 $139,122.72 and the Home Investment Partnership Act Accounts totaling $49,985 and recommends $189,107.72 be written off in uncollectible loans; and WHEREAS the Parks and Recreation has attempted to collect funds from an installment rental agreement in the amount of $2,93T59 and recommends that the amount be written off due to a Chapter 7 bankruptcy and death; and WHEREAS the Department of Information Technology has requested write-offs totaling $919 for uncollectible charges; and WHEREAS the Library Board received five (5) pieces of furniture valued at $2,068 donated from Oakland County Bar Association; and WHEREAS the Department of Health and Human Services Children's Village Division received donations of various items with an estimated total value of $38,677.64. Planned Use of Balance BUILDING IMPROVEMENT FUND (#40100) Revenues 1040101-148020-665882 Total Revenues ($538,381.00) (sma,aai 00) NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 2016 First Quarter Financial Report. BE IT FURTHER RESOLVED that $159,000 be transferred in FY 2016 from the General Fund Assigned Fund Balance for Pandemic Response (GL #383358) to the Health Division to assist local CVT's with abatement issues as well as develop an awareness campaign for the Zika Virus. GENERAL FUND (#10100) Revenues 9010101 - 196030- 665882 Expenditures 1060201 — 134870 - 740184 1060201 — 134865 - 730072 1060201 — 134865 - 73138 1060201 — 134865 - 750294 FY 2016 Planned Use of Balance Total Revenues West Nile Advertising Printing Material and Supplies Total Expenditures $159,000.00 $159,000.00 $119,000.00 20,000.00 15,000.00 5,000.00 $159,000 00 BE IT FURTHER RESOLVED that $538,381 be transferred in FY 2016 from General Fund Assigned Fund Balance for Homeland Security Enhancement (GL #383455) to the Project Work Order Fund (#40400) correct the funding source for the Building Security Enhancement Priority 1 (part 2 of 3) Project approved per M.R. #16018 from the Capital Improvement Program/Building Fund (#40100). Expenditures 9010101-196030-788001-40400 Transfers Out - Project Work Order Fund Total Expenditures GENERAL FUND (#10100) Revenues 9010101-196030-665882 $538,381.00 $538,381.00 $538,381.00 $638 381 00 Planned Use of Balance Total Revenues Expenditures 1040101-148020-788001-40400Transfers Out - Project Work Order Fund Total Expenditures PROJECT WORK ORDER FUND (#40400) Project: 100000002329, Activity: PROJ Revenues 1040101-148020-695500-40100Transfer In - Building Improvement Fund 1040101-148020-695500-10100Transfer In - General Fund Total Revenues ($538,381.00) ($538,381.00) ($538,381.00 $538,381.00 0 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 Department of Health and Human Services Children's Village Division, Library Board and Circuit Court. BE IT FURTHER RESOLVED that the FY 2016 — FY 2018 Budgets are amended pursuant to Schedules A, B and C. Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution. FINANCE COMMITTEE COUNTY MICHIGAN MANAGEMENT 8t. BUDGET OAKLAND COUNTY EXECUTIVE L. BROOKS PATTERSON Laurie Van Pelt, Director (248) 858-2163 vanpelnoakgov.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 2016 First Quarter Forecast DATE: March 10, 2016 FY 2016 FIRST QUARTER REPORT Attached please find the Fiscal Year (FY) 2016 First Quarter Forecast Report. In total, Fiscal Services forecasts that the County will complete FY 2016 with an overall favorable variance of $12,004,421 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,104,411 more revenue than anticipated and projected favorability in expenditures of $9,900,010. REVENUES GF/GP revenues are .48% more than budget or $2,104,411. Major variances are the result of the following events: A. STATE GRANTS — Unfavorable: ($757,500) Reduced state funding is the result of reduced Child Care fund costs. The revenue loss is more than offset by projected reduced expenditures. Expenditures are favorable for Foster Boarding Homes, Independent Living, and Private Institutions - Residential and Foster Care. B. CHARGES FOR SERVICES — Favorable: $2,809,960 Favorable primarily due to increased activity for Land Transfer Tax $2 million in the County Clerk's Office. Also favorable fines and costs $370,000 across the District Courts due to increases in caseload and collections efforts and $300,000 Children's Village Board and Care due to an increase in Department of Human Services (DHS) wards. EXPENDITURES In total, expenditures are projected to be 2.24% under budget or $9,900,010 favorable. Many departments have experienced personnel savings as the result of turnover and under-filling of positions. As the year progresses this overall net favorability may increase as departments continue to work to reduce their costs and reorganize. There is one department projected to be unfavorable at the end of the fiscal year (barring any amendments); Sheriff's Office. Sheriff — Unfavorable: ($533,800) 2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 I Fax (248) 452-91721 OakGov.c • 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. Note that while individual divisions may be over budget, the budget is controlled at the department level. The General Appropriations Act requires that appropriations accumulate at the following three summary levels of expenditures within each County Department and are deemed maximum authorization for expenditures: Personnel Expenditures, Operating Expenditures, and Internal Support Expenditures. Required Reporting Adjustments The Quarterly Forecast presents the County's financial position in relation to the amended budget (Budget perspective). This form of presentation is used so that users of this forecast can assess the true financial impact of County operations in comparison to the budget for the current fiscal year. However, it is important to note that this presentation style does not fully coincide with the accounting requirements of audited financial statements produced by the County. The County's financial statements are required to follow Generally Accepted Accounting Principles or GAAP. Forecast Presentation — Budgetary Perspective The presentation reflects the true fiscal activity of the County for FY 2016: Revenues - over/ (under) budget $ 2,104,411 Expenditures — (over)/under budget 9,900,010 Total Officially Reported Favorability $ 12,004,421 GAAP Required Reporting Method Under GAAP, the Planned Use of Fund Balance is removed as a "revenue" source. The amended revenue budget assumed the use of $39,518,497 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,104,411 (39,518,4971 $ (37,414,086) 9,900,010 $ (27,514,076) 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 2016 operations. The Budget perspective recognizes the overall favorable operating budget variance and confirms the County's continuing efforts to maintain long-term fiscal stability particularly through continuation of 2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 I Fax (248) 452-9172 I OakGov.c 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 $12.0 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 $27.5 million by the end of Fiscal Year 2016. 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 2016-2018 Triennial Budget — the County PLANNED to use fund balance, which has increased over the past several years through accelerated budget reductions, to support operations beginning in FY 2016. However, it should be noted while the amended budget reflects the utilization of $39.5 million of Fund Balance, this forecast projects the use of Fund Balance needed to support FY 2016 activities of $27.5 million, $12.0 million less than planned. 2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 I Fax (248) 452-9172 I OakGov.o SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2-016 FY 2017 FY 2018 AMENDMENTS AMENDMENTS AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aft Op Unit CIRCUIT COURT Revenue 3010101 121205 650301 Account Name Donations Total Revenue 550.0G 550.00 Expenditure 3010101 121205 788001 27140 Transfers Out - JDC Fund Total Expenditure 550.00 550.00 $ 26,572.00 $ $ (26,572.00) $ - $ 26,572.00 $ 26,572.00 (26,572.00) $ (26,572.00) - $ Expenditures 3010403 121240 731780 Software Support Maintenance 9010101 112700 788001 20293 Transfer Out - Child Care Fund Total Expenditures CHILD CARE FUND (#20293) CIRCUIT COURT Revenue 9090101 112700 695500 10100 Expenditure 3010402 112570 731843 Transfer In - General Fund Total Revenue State Institutions Total Expenditure (26,572.00) (26,572.00) (26,572.00) (26,572.00) $ (26,572.00) $ (26,572.00) (26,572.00) $ (26,572.00) $ (26,572.00) (26,572.00) $ (26,572.00) $ (26,572.00) SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY2016 FY 2017 FY 2018 AMENDMENTS AMENDMENTS AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#101001 Dept Program Acct Fund Aft. Op Unit Account Name DISTRICT COURTS Revenues 3020201 121020 631830 Reimb Interpreter Fees 3020301 121020 631830 Reimb Interpreter Fees 3020401 121020 631830 Reirnb Interpreter Fees 3020501 121020 631830 Reirnb Interpreter Fees 3020201 121020 631253 Miscellaneous 3020301 121020 631253 Miscellaneous 3020401 121020 631253 Miscellaneous 3020501 121020 631253 Miscellaneous 9,000.00 5,000.00 10,000.00 15,000.00 (9,000.00) (5,000.00) (10,000.00) (15,000.00) Total Revenues PROBATE COURT Expenditures 3040403 124015 3040403 124015 9090101 196030 731780 731458 773630 Software Support Maintenance Professional Services Info Tech Development Total Expenditures $ 76,000.00 $ (64,000.00) (12,000.00) 76,000.00 $ 76,000.00 (64,000.00) (64,000.00) (12,000.00) (12,000.00) - SHERIFF'S OFFICE Revenues 4030901 116240 695500 21340 Transfers In Sheriff LE Enhance Lab Fees 4030501 116230 695500 21396 Transfers In - Sheriff Training 9010101 196030 665882 Planned Use of Balance Total Revenues $ 28,142.00 15,315.00 (43,457.00) 9 SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2016 FY 2017 FY 2018 AMENDMENTS AMENDMENTS AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aff. Op Unit Account Name Expenditures 9090101 196030 730359 Contingency 4030601 112630 788001 63600 Transfer Out - FT Fund Total Expenditures Expenditures 9090101 196030 730359 Contingency 4030601 112630 788001 53600 Transfers Out - Radio Fund Total Expenditures Expenditures 9090101 196030 740145 Security Reserve 4030401 112670 788001 53600 Transfer Out - Radio Fund Total Expenditures $ (14,378.00) $ 14,378.00 $ (24,500.00) $ 24,500.00 $ (27,664.00) 27,664.00 Revenue 9010101 196030 665882 Planned Use of Balance $ 47,215.00 Total Revenue $ 47,215.00 Expenditures 9010101 148050 773631 Non Dept.- Building Space Allocation 4030501 116230 770631 Bldg Space Cost Allocation Total Expenditure $ (3,117.00) 50,332.00 $ 47,215.00 10 $ 8,000.00 $ 4,200.00 $ 500.00 $ 8,000.00 $ 4,200.00 $ 500.00 $ 4,000.00 $ 2,000.00 2,000.00 2,100.00 $ 500.00 1,050.00 1,050.00 $ 8,000.00 $ 4,200.00 $ 500.00 $ (49,200.00) 49,200.00 $ $ 64,984.00 $ 70,403.00 $ 70,642.00 $ 64,984.00 $ 70,403.00 $ 70,642.00 SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aff. Op Unit Account Name COUNTY CLERK/REGISTER OF DEEDS Expenditures 2010201 132300 712020 Overtime 2010210 125000 730422 Court Transcripts 2010201 132300 750154 Expendable Equipment 2010201 132300 731458 Professional Services Total Expenditures FY 2016 FY 2017 FY2018 AMENDMENTS AMENDMENTS AMENDMENTS $ 3,000.00 (3,000.00) 4,156.00 (4,156.00) $ TREASURER'S OFFICE Expenditures 7010101 186130 731913 7010101 186040 731773 Revenue 2010301 185010 630147 Revenue 9010101 196030 665882 10100 Board of Canvasser Service Fee Total Revenue Overtime Election Supplies Office Supplies Total Expenditures Title Search Software Rental Lease Purchase Total Expenditures Planned Use of Balance Total Revenue Expenditures 2010301 185010 712020 2010301 185010 750126 2010301 185010 750399 11 SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2016 FY 2017 FY 2018 AMENDMENTS AMENDMENTS AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100} Dept Program Acct Fund Aft Op Unit Expenditure 7010101 186040 770631 10100 Account Name Bldg Space Cost Allocation Total Expenditure $ 64,984.00 $ 70,403.00 $ 70,642.00 64,984.00 $ 70,403.00 $ 70,642.00 Expenditures 1050101 183010 731458 Professional Services 1050101 183010 788001 40400 Transfer Out - Project Work Order Fund Total Expenditures $ (42,600.00) $ (42,600.00) $ (42,600.00) 42,600.00 42,600.00 42,600.00 $ (45,745.00) $ (45,745.00) $ (45,745.00) 45,745.00 45,745.00 45,745.00 - $ - $ $ (9,687.00) 9,687.00 HUMAN RESOURCES Expenditures 1050102 183130 1050101 183130 1050401 183010 1050102 183020 731458 731458 731773 731773 Professional Services Professional Services Software Rental Lease Purchase Software Rental Lease Purchase Total Expenditures HEALTH AND HUMAN SERVICES Expenditures 1060101 133000 731458 1060101 133000 740006 Professional Services Area Agency on Aging Total Expenditures $ (7,000.00) $ 7,000.00 (11,555.00) $ (11,555.00) 11,555.00 11,555.00 - $ 12 SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) IGF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#10100) Dept Program Acct Fund Aft On Unit Expenditures 1060101 133000 774636 Info Tech Operations 1060601 115090 774636 Info Tech Operations Total Expenditures CHILD CARE FUND (#20293) Revenue 1060501 112255 695500 21330 Transfer In - Children's Village Donation Fund Total Revenue FY 2016 FY 2017 FY 2018 AMENDMENTS AMENDMENTS AMENDMENTS $ (26,899.00) $ (26,899.00) $ (26,899.00) 26,899.00 26,899.00 26,899.00 - $ - $ 1,390.00 1,390.00 Account Name Expenditures 1060501 112255 750245 Incentives 306.00 1060501 112255 750476 Recreation Supplies 1,084.00 Total Expenditures 1,390.00 GENERAL FUND (#10100) ANIMAL CONTROL (#10100) Revenue 1070801 114000 695500 21310 Transfer In-Legacy Fund $ 16,196.00 Total Revenue $ 16,196.00 Expenditure 1070801 114000 788001 63600 Transfer Out-IT Fund Total Expenditure $ 16,196.00 $ 16,196.00 13 SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2016 FY 2017 FY 2018 AMENDMENTS AMENDMENTS AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#101001 Dept Program Acct Fund AM Op Unit ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS Revenue 1090108 172072 650104 Account Name Contributions $ 3,709.00 $ 3,709.00 Total Revenue Expenditures 1090108 172072 750511 Special Event Supplies Total Expenditure $ 3,709.00 $ 3,709.00 Expenditures 1090201 1090205 1090201 171000 171125 172100 731458 732165 732165 Professional Services Workshops and Meeting Workshops and Meeting Total Expenditures $ (89,000.00) $ (50,000.00) 139,000.00 (89,000.00) $ (89,000.00) (50,000.00) (50,000.00) 139,000.00 139,000.00 $ - $ Revenue 1090205 171030 631827 Expenditure 1090205 171030 732165 Revenue 1090205 172090 631827 Reimb General Total Revenue Workshops and Meeting Total Expenditure Reimb General $ 10,000.00 $ 10,000.00 $ 10,000.00 $ 10,000.00 $ 5,529.00 Total Revenue $ 5,529.00 14 SCHEDULE A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) FY 2016 FY 2017 FY 2018 AMENDMENTS AMENDMENTS AMENDMENTS GF/GP OPERATIONS - SELF BALANCING AMENDMENTS GENERAL FUND (#101001 Dept Program Acct Fund AU. Op Unit Account Name Expenditure 1090205 172090 732165 Workshops and Meeting Total Expenditure 5,529.00 5,529.00 (LAOLI1L '111111111:1 Total Revenue Expenditure 1090205 171030 731780 Software Support Maintenance Total Expenditure $ 31,398.00 $ 31,398.00 $ 31,398.00 $ 31,398.00 Expenditures 1090201 171000 731458 Professional Services 1090201 171000 788001 63600 Transfers Out- IT Fund Total Expenditures Revenue 1090201 174240 670513 Prior Year Revenue 9010101 196030 665882 Planned Use of Balance Total Revenues $ (14,208.00) 14,208.00 $ 78,681.00 $ (78,681.00) 15 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY /SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS [PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name CIRCUIT COURT - DRUG COURT CIRCUIT JUVENILE GRANT (#27140) GR0000000236 Activity GLB, Analysis Type GLB, Budget Ref 2016 Revenue 3010402 121205 695500 10100 Transfer In $ 550.00 Total Revenue $ 550.00 Expenditure 3010402 121205 750245 Incentives $ 550.00 Total Expenditure $ 550.00 SHERIFF - LAW ENFORCEMENT ENHANCE LAB FEES (#21340) Revenue 4030901 116240 665882 21340 Planned Use of Balance $ 28,142.00 Total Revenue $ 28,142.00 Expenditure 4030101 112580 788001 10100 Transfer Out - General Fund Total Expenditure 28,142.00 28,142.00 SHERIFF - TRAINING (#21396) Revenue 4030501 116230 665882 21396 Planned Use of Balance $ 15,315.00 Total Revenue $ 15,315.00 Expenditure 4030301 112590 788001 10100 Transfer Out - General Fund $ 15,315.00 Total Expenditure $ 15,315.00 16 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY I SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name INFORMATION TECHNOLOGY FUND #53600 Revenues 1080601 152096 695500 10100 Transfers In-General Fund 1080601 152096 665882 Planned Use of Balance Total Revenues 14,378.00 (14,378.00) RADIO COMMUNICATIONS FUND #53600 Revenues 1080310 115150 695500 10100 1080310 115150 665882 Transfers In - General Fund Planned Use of Balance Total Revenues 24,500.00 (24,500.00) RADIO COMMUNICATIONS FUND #53600 Revenue 1080310 115150 695500 10100 1080310 115150 665882 Transfers In - General Fund Planned Use of Balance Total Revenues 27,664.00 (27,664.00) CLEMIS FUND (#53500) Revenue 1080305 116020 665882 Planned Use of Balance Total Revenue 47,215.00 47,215.00 Expenses 1080305 116020 770631 Bldg Space Cost Allocation Total Expenses (47,215.00) (47,215.00) Planned Use of Balance Total Revenue DELINQUENT PERSONAL PROPERTY TAX ADM1N FUND (#51800) Revenues 7010110 186060 665882 (64,984.00) $ (64,984.00) $ (70,403.00) $ (70,403.00) $ (70,642.00) (70 642.00) 17 Budgeted Equity Adjustments $ 9,687.00 Total Expenditure $ 9,687.00 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Expense 7010110 186060 770631 Bldg Space Cost Allocation Total Expense $ (64,984.00) $ (70,403.00) $ (70,642.00) (64,984.00) $ (70,403.00) $ (70,642.00) PROJECT WORK ORDER FUND (#40400) PCBU: FACMG, Project: 100000002260, Activity: PROJ Revenues 1040101 148020 695500 10100 Transfer In - General Fund 9,687.00 Total Revenues $ 9,687.00 Expenditures 1040101 148020 796500 CHILDREN'S VILLAGE DONATIONS FUND (#21330) Revenue 9010101 112255 665882 Expenditure 9010101 112255 788001 20293 ANIMAL CONTROL LEGACY FUND (#21310) Revenue 9010101 114110 665882 Planned Use of Balance $ 1,390.00 Total Revenue $ 1,390.00 Transfer Out - Child Care Fund $ 1,390.00 Total Expenditure $ 1,390.00 Planned Use of Balance $ 16,196.00 Total Revenue $ 16,196.00 Expenditure 9010101 114110 788001 10100 Transfer Out - General Fund $ 16,196.00 Total Expenditure $ 16,196.00 18 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY /SPECIAL REVENUE FUNDS ACCOUNT NUMBER INFORMATION TECHNOLOGY FUND (63600) Revenue 1080101 152000 695500 10100 Expense 1080201 152010 731458 NO HAZ DONATION FUND (#21380) Revenue 9010101 174240 665882 Expenditure 9010101 174240 730044 FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS 16,196.00 (16,196.00 Transfers In 14,208.00 Total Revenue 14,208.00 Professional Services 14,208.00 Total Expenses 14,208.00 Planned Use of Balance 78,681.00 Total Revenue 78,681.00 Adjustment of Prior Years Revenue 78,681.00 Total Expenditure 78,681.00 PROPRIETARY/SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name INFORMATION TECHNOLOGY (#63600) Revenue 1080601 152010 695500 10100 Transfer In - General Fund 1080601 152010 665882 Planned Use of Balance Total Revenue DISTRICT COURT- DRUG COURT DISTRICT 52/3 SCAO GRANT (#27165) GR0000000468 Activity GLB, Analysis Type GLB, Budget Ref 2016 Expenditures 3020405 121050 750399 Office Supplies 295.00 3020405 121050 732018 Travel and Conference (295.00) Total Expenditures 19 16,979.00 976.00 196.00 2,500.00 5,000.00 (16,979.00) (976.00) (196.00) (2,500.00) (5,000.00) 5,000.00 (27,590.00) (1,586.00) (336.00) 5,000.00 (27,590.00) (1,586.00) (336.00) 27,590.00 $ 27,590.00 1,586.00 1,586.00 336.00 336.00 (5,000.00) (5,000.00) (77,000) $ (77,000) $ (126,107) $ (77,000) $ (77,000) $ (434,107) $ (77,000) $ (77,000) $ (125,107) $ (77,000) $ (77,000) $ (434,107) $ (77,000) (77,000) (126,107) (77,000) (77,000) (434,107) SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS IPROPRIETARY/SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name FRIEND OF THE COURT (#27100) Expenditures 3010404 126035 702010 Salaries 3010404 126035 722740 Fringe Benefits 3010404 126035 778675 Tel. Communications 3010404 126035 750154 Expendable Equipment 3010404 126035 750539 Testing Materials 3010402 126035 702010 Salaries 3010402 126035 722740 Fringe Benefits 3010402 126035 778675 Tel. Communications 3010402 126035 750154 Expendable Equipment 3010402 126035 750539 Testing Materials Total Expenditures SHERIFFS OFFICE - DRUG POLICY GRANT (#27320) GR0000000147 Activity GLB, Analysis Type GLB, Budget II II Revenues 4010201 122080 610313 Grants Federal 4030901 110090 610313 Grants Federal 4030901 110090 695500 21341 Transfers In - Sheriff LE Enhancement 4030901 110090 695500 10100 Transfers In - Sheriff General Fund 4010201 122080 695500 10100 Transfers In - Prosecutor General Fund Total Revenues Expenditures 4030901 4010201 4030901 4030901 4010201 4010201 110090 112085 110090 110090 122080 122080 702010 702010 722740 702140 722740 702140 Salaries Salaries Fringe Benefits Other Misc Salaries Fringe Benefits Other Misc Salaries Total Expenditures (168,279) $ (94,386) $ (110,647) $ (5,049) $ (52,914) $ (2,832) $ (434,107) $ (168,279) $ (94,386) $ (110,647) $ (5,049) $ (52,914) $ (2,832) $ (434,107) $ (168,279) (94,386) (110,647) (5,049) (52,914) (2,832) (434,107) 20 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY/SPECIAL REVENUE FUNDS ACCOUNT NUMBER FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aft Oper Unit Account Name GR0000000146 Activity GLB, Analysis Type GLB, Budget Ref 2016 Revenues 4010201 122080 610313 Grants Federal $ 4030901 110090 610313 Grants Federal $ 4030901 110090 695500 21341 Transfers In - Sheriff LE Enhancement $ 4030901 110090 695500 10100 Transfers In - Sheriff General Fund $ 4010201 122080 695500 10100 Transfers In - Prosecutor General Fund $ Total Revenues $ 77,000 77,000 77,000 77,000 77,000 77,000 126,107 126,107 126,107 77,000 77,000 77,000 77,000 77,000 77,000 434,107 434,107 434,107 Expenditures 4030901 4010201 4030901 4030901 4010201 4010201 110090 112085 110090 110090 122080 122080 702010 702010 722740 702140 722740 702140 Salaries Salaries Fringe Benefits Other Misc Salaries Fringe Benefits Other Misc Salaries Total Expenditures 168,279 94,386 110,647 5,049 52,914 2,832 434,107 168,279 94,386 110,647 5,049 52,914 2,832 434,107 168,279 94,386 110,647 5,049 52,914 2,832 434,107 HEALTH - TOBACCO REDUCTION (#28315) GR0000000740 Activity GLB, Analysis Type GLB, Budget Ref 2016 Revenue 1060233 133490 615571 State Operating Grants Total Revenue 30,000.00 30,000.00 Expenditures 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 133490 133490 133490 133490 133490 133490 133490 133490 702010 722740 730072 730926 731346 731388 774677 778675 Salaries Regular Fringe Benefits Advertising Indirect Costs Personal Mileage Printing Insurance Fund Telephone Communications Total Expenditures 22,016.00 1,684.00 395.00 3,049.00 1,150.00 1,070.00 86.00 550.00 30,000.00 21 OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2016 SCHEDULE B FY 2017 FY 2018 ACCOUNT NUMBER 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name HEALTH - COMMUNITIES PLANNING (#28320) GR0000000562 Activity GL18, Analysis Type GLB, Budget Ref 2016 Revenue 1060233 133390 615571 State Operating Grants Total Revenue AMENDMENTS AMENDMENTS AMENDMENTS 62,641.00 62,641.00 Expenditures 1060233 133390 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 1060233 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 133390 702010 722740 730072 730373 730555 730926 730982 731346 731388 731941 732018 750245 750294 750399 750448 750567 774677 Salaries Regular Fringe Benefits Advertising Contracted Services Education Programs Indirect Costs Interpreter Fees Personal Mileage Printing Training Travel and Conference Incentives Material and Supplies Office Supplies Postage-Standard Mailing Training-Educational Supplies Insurance Fund Total Expenditures 15,423.00 887.00 4,312.00 3,761.00 5,500.00 2,136.00 1,580.00 345.00 5,776.00 1,000.00 100.00 2,825.00 11,550.00 1,250.00 4,611,00 1,406.00 179.00 62,641.00 HEALTH - WIC (#28553) GR0000000205 Activity GLB, Analysis Type GLB, Budget Ref 2016 Revenue 1060284 133270 610313 (113,600.00) (113,600.00) Federal Operating Grants Total Revenue 22 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY/SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS [PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Expenditures 1060284 133270 702010 Salaries Regular 1060284 133270 722740 Fringe Benefits 1060284 133270 730072 Advertising 1060284 133270 730646 Equipment Maintenance 1060284 133270 730772 Freight and Express 1060284 133270 730926 Indirect Costs 1060284 133270 731059 Laundry and Cleaning 1060284 133270 731388 Printing 1060284 133270 731458 Professional Services 1060284 133270 731941 Training 1060284 133270 750154 Expendable Equipment 1060284 133270 750294 Material and Supplies 1060284 133270 750301 Medical Supplies 1060284 133270 750392 Metered Postage 1060284 133270 750399 Office Supplies 1060284 133270 750567 Training-Educational Supplies 1060284 133270 770631 Bldg Space Cost Allocation 1060284 133270 778675 Telephone Communications Total Expenditures (65,526.00) (30,520.00) (9,250.00) (400.00) (100.00) (9,075.00) (600.00) (3,948.00) (1,250.00) (250.00) 500.00 17.00 (50.00) 1,000.00 (350.00) (900.00) 6,352.00 750.00 (113,600.00) HEALTH - HIV SURVEILLANCE(#28558) GR0000000666 Activity GLB, Analysis Type GLB, Budget Ref 2016 Revenue 1060294 133940 610313 10,000.00 10,000.00 Federal Operating Grants Total Revenue Expenditures 1060294 133940 770631 Bldg Space Cost Allocation 10,000.00 Total Expenditures 10,000.00 23 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS 'PROPRIETARY/ SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name HEALTH - NURSE FAMILY PARTNERSHIP (#28607) GR0000000279 Activity GLB, Analysis Type GLB, Budget Ref 2016 Revenues 1060231 133215 610313 Federal Operating Grants 1060231 133215 615571 State Operating Grants Total Revenues 1,000.00 19,000.00 20,000.00 Expenditures 1060231 133215 702010 1060231 133215 722740 1060231 133215 730072 1060231 133215 730373 1060231 133215 731346 1060231 133215 731388 1060231 133215 731941 1060231 133215 731997 1060231 133215 750245 1060231 133215 750399 1060231 133215 750567 1060231 133215 770631 1060231 133215 774636 1060231 133215 774637 Salaries Regular Fringe Benefits Advertising Contracted Services Personal Mileage Printing Training Transportation of Clients Incentives Office Supplies Training-Educational Supplies Bldg Space Cost Allocation Info Tech Operations Info Tech Managed Print Svcs Total Expenditures (1,844.00) 508.00 700.00 6,821.00 (217.00) (2,000.00) 14,350.00 10.00 (3,800.00) (800.00) (776.00) 6,611.00 (1,800.00) 2,237.00 20,000.00 HEALTH - PHEP (#28610) GR0000000716 Activity GLB, Analysis Type GLB, Budget Ref 2016 Revenue 1060290 115010 610313 11,850.00 11,850.00 Federal Operating Grants Total Revenue 24 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS PROPRIETARY/SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Expenditures 1060290 115010 731780 Software Support Maintenance 1060290 115010 750077 Disaster Supplies 1060290 115010 774637 Info Tech Managed Print Svcs Total Expenditures HEALTH - GREAT START TRAUMA (#28613) GR0000000273 Activity GLB, Analysis Type GLB, Budget Ref 2016 Revenue 1060231 133390 610313 Federal Operating Grants Total Revenue 8,878.00 2,975.00 (3.00) 11,850.00 3,800.00 3,800.00 Expenditures 1060231 133390 1060231 133390 1060231 133390 1060231 133390 730982 731346 731458 750567 Interpreter Fees Personal Mileage Professional Services Training-Educational Supplies Total Expenditures 300.00 1,035.00 2,000.00 465.00 3,800.00 31,914.00 31,914.00 HEALTH - EVD PHASE II (#28614) GRO000000724 Activity GLB, Analysis Type GLB, Budget Ref 2016 Revenue 1060290 133021 610313 Federal Operating Grants Total Revenue Expenditures 1060290 133021 722740 Fringe Benefits $ (10,038.00) 1060290 133021 730982 Interpreter Fees 4,062.00 1060290 133021 731941 Training (10,000.00) 1060290 133021 750077 Disaster Supplies 47,890.00 Total Expenditures $ 31,914.00 25 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS ACCOUNT NUMBER FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit HEALTH - WEST NILE VIRUS (#28690) GR0000000722 Activity GLB, Analysis Type GLB, Budget Ref 2016 Revenue 1060220 134870 610313 Account Name Total Revenue Federal Operating Grants 6,500.00 6,500.00 Expenditures 1060220 134870 1060220 134870 1060220 134870 1060220 134870 1060220 134870 1060220 134870 702010 722740 730926 731346 732018 750399 Salaries Regular Fringe Benefits Indirect Costs Personal Mileage Travel and Conference Office Supplies Total Expenditures 2,401.00 2,007.00 333.00 1,093.00 228.00 438.00 6,500.00 ECONOMIC DEVELOPMENT CORP FUND (#21180) Revenues 1090202 171110 630098 Application and Admin Fee 500.00 1090202 171110 630280 Closing Fee (5,000.00) 1090202 171110 655385 Income from Investments 400.00 Total Revenues (4,100.00) Expenditures 1090202 171110 730072 Advertising (200.00) 1090202 171110 730709 Fees - Per Diems 500.00 1090202 171110 731213 Membership Dues (2,000.00) 1090202 171110 731507 Public Notices- (1,000.00) 1090202 171110 731818 Special Event Program (1,000.00) 1090202 171110 732165 Workshops and Meeting (400.00) Total Expenditures (4,100.00) 26 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY I SPECIAL REVENUE FUNDS ACCOUNT NUMBER FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name LAW ENFORCEMENT ENHANCEMENT FUND #21341 Revenue 4030101 116270 665882 Planned Use of Balance Total Revenue 7,300.00 7,300.00 Expenditure 4030101 116270 788001 27322 Transfers Out - JAG Grant 7,300.00 Total Expenditure 7,300.00 JAG (2015 DJ BX 0841) #27322 GR0000000741 Activity GLB, Analysis Type GLB, Budget Ref 2016 Revenue 4030601 110000 695500 21341 Transfers In- Sheriff LE Enhancement Total Revenue 7,300.00 7,300.00 Expenditure 4030601 110000 760157 FA Proprietary Equipment Exp Total Expenditure 7,300.00 7,300.00 PARKS AND RECREATION (#50800) Revenue 216,785.00 5060666 160666 665882 Planned Use of Balance 216,785.00 Total Revenue Expenses 5060326 160010 761042 Depreciation Park Improvements 2,500.00 5060326 160010 761121 Depreciation Equipment (6,200.00) 5060327 160010 761042 Depreciation Park Improvements 24,000.00 5060327 160010 761084 Depreciation Buildings (19,600.00) 5060327 160010 761121 Depreciation Equipment (1,200.00) 5060328 160010 761042 Depreciation Park Improvements 1,000.00 5060328 160010 761121 Depreciation Equipment 7,800.00 5060330 160010 761042 Depreciation Park Improvements (700.00) 5060330 160010 761084 Depreciation Buildings 1,100.00 27 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060330 160010 761121 Depreciation Equipment 5060356 160010 761042 Depreciation Park Improvements 5060356 160010 761084 Depreciation Buildings 5060356 160010 761121 Depreciation Equipment 5060417 160044 761084 Depreciation Buildings 5060420 160044 761084 Depreciation Buildings 5060420 160044 761121 Depreciation Equipment 5060426 160044 761042 Depreciation Park Improvements 5060427 160044 761084 Depreciation Buildings 5060430 160044 761084 Depreciation Buildings 5060431 160044 761084 Depreciation Buildings 5060431 160044 761121 Depreciation Equipment 5060437 160044 761084 Depreciation Buildings 5060437 160044 761121 Depreciation Equipment 5060456 160044 761042 Depreciation Park Improvements 5060540 160500 761042 Depreciation Park Improvements 5060715 160070 761042 Depreciation Park Improvements 5060715 160070 761084 Depreciation Buildings 5060715 160070 761121 Depreciation Equipment 5060720 160070 761042 Depreciation Park Improvements 5060720 160070 761084 Depreciation Buildings 5060720 160070 761121 Depreciation Equipment 5060724 160070 761042 Depreciation Park Improvements 5060725 160070 761042 Depreciation Park Improvements 5060725 160070 761084 Depreciation Buildings 5060725 160070 761121 Depreciation Equipment 5060729 160070 761042 Depreciation Park Improvements 5060732 160070 761084 Depreciation Buildings 5060732 160070 761121 Depreciation Equipment 5060735 160070 761042 Depreciation Park Improvements 5060735 160070 761084 Depreciation Buildings 5,900.00 1,600.00 700.00 14,800.00 31,400.00 2,900.00 (500.00) 2,200.00 29,100.00 3,500.00 2,700.00 (500.00) 2,600.00 (500.00) 1,100.00 2,500.00 16,700.00 3,985.00 5,800.00 56,900.00 1,500.00 8,800.00 (1,600.00) 1,200.00 3,000.00 2,100.00 (23,500.00) 14,800.00 (2,300.00) 1,400.00 500.00 28 SCHEDULE B ACCOUNT NUMBER PARKS AND RECREATION (#50800) Revenues 5060101 160000 601637 5060724 160070 630084 5060837 160210 630301 5060431 160044 630308 5060437 160044 630308 5060837 160210 630308 5060456 160044 630308 5060831 160210 630644 5060837 160210 630644 5060720 160070 630693 5060715 160070 630693 5060751 160070 630700 5060755 160070 630700 5060101 160000 631001 5060101 160000 631253 5060456 160044 631799 5060735 160070 631911 OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2016 FY 2017 FY 2018 AMENDMENTS AMENDMENTS AMENDMENTS (3,600.00) (1,800.00) 3,600.00 5,300.00 1,100.00 (100.00) 6,600.00 (1,600.00) (2,400.00) 12,200.00 216,785.00 Property Tax Levy 100,000.00 Antenna Site Management (30,000.00) Commission Contracts (4,000.00) Commission Food Services 1,500.00 Commission Food Services 500.00 Commission Food Services (12,000.00) Commission Food Services (110,000.00) Entrance Fees Gen Admission 140,000.00 Entrance Fees Gen Admission 60,000.00 Fees Camping 123,500.00 Fees Camping 66,500.00 Fees Day Use 5,000.00 Fees Day Use 5,000.00 Interest on Delinquent Taxes 4,000.00 Miscellaneous (1,000.00) Reimb Contracts 90,000.00 Rent House (7,200.00) PROPRIETARY/SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060735 160070 761121 Depreciation Equipment 5060751 160070 761084 Depreciation Buildings 5060755 160070 761042 Depreciation Park Improvements 5060760 160070 761042 Depreciation Park Improvements 5060805 160210 761121 Depreciation Equipment 5060805 160210 761156 Depreciation Vehicles 5060831 160210 761042 Depreciation Park improvements 5060831 160210 761121 Depreciation Equipment 5060837 160210 761121 Depreciation Equipment 5060910 160430 761121 Depreciation Equipment Total Expenses 29 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY/SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060725 160070 631911 Rent House 5060732 160070 631925 Rental Facilities 5060725 160070 631925 Rental Facilities 5060735 160070 631925 Rental Facilities 5060870 160210 631925 Rental Facilities 5060720 160070 631925 Rental Facilities 5060356 160010 631932 Rental Golf Carts 5060326 160010 631932 Rental Golf Carts 5060327 160010 631932 Rental Golf Carts 5060330 160010 631932 Rental Golf Carts 5060328 160010 631932 Rental Golf Carts 5060805 160210 631946 Rental Units or Events 5060420 160044 632023 Sales 5060431 160044 632023 Sales 5060437 160044 632023 Sales 5060437 160044 632037 Sales Retail 5060420 160044 632037 Sales Retail 5060431 160044 632037 Sales Retail (7,800.00) 80,000.00 10,000.00 10,000.00 5,000.00 1,000.00 10,000.00 7,500.00 7,500.00 7,500.00 2,500.00 20,000.00 (5,000.00) (10,000.00) (10,000.00) 10,000.00 (30,000.00) (50,000.00) 30 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS PROPRIETARY/SPECIAL REVENUE FUNDS SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060101 160000 632135 Special Contracts 5060715 160070 632135 Special Contracts 5060720 160070 632135 Special Contracts 5060540 160500 632135 Special Contracts 5060715 160070 632443 Water Feature Ride 5060720 160070 632443 Water Feature Ride 5060101 160000 650305 Sponsorships 5060101 160000 655077 Accrued Interest Adjustments 5060845 160210 632135 Special Contracts 5060666 160666 665882 Planned Use of Balance Total Revenues 5,000.00 2,000.00 2,000.00 1,000.00 10,000.00 2,000.00 40,000.00 10,000.00 (8,000.00) (1,301,444.00) (747,444.00) Expenses 5060101 5060101 5060101 5060101 5060101 5060101 5060101 5060101 5060101 5060101 5060101 5060101 5060101 5060101 5060101 5060101 5060101 5060101 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 702010 712020 722740 730093 730121 730247 730520 730562 730709 730926 731339 731388 731500 731689 731780 731836 732018 750063 Salaries Regular Overtime Fringe Benefits Appraisal Fees Bank Charges Charge Card Fee Design Fees Electrical Service Fees - Per Diems Indirect Costs Periodicals Books Publ Sub Printing Public Information Security Expense Software Support Maintenance Sponsorship Travel and Conference Custodial Supplies (82,285.00) 15,000.00 (4,700.00) (500.00) 2,500.00 (500.00) (10,000.00) (5,000.00) (250.00) 10,000,00 (300.00) (2,000.00) (57,000.00) (5,000.00) (500.00) (5,000.00) 2,450.00 (500.00) 31 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY/SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS 'PROPRIETARY / SPECAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Over Unit Account Name 5060101 160000 750392 Metered Postage 5060101 160000 750399 Office Supplies 5060101 160000 750448 Postage-Standard Mailing 5060101 160000 750504 Small Tools 5060101 160000 750581 Uniforms 5060101 160000 776659 Motor Pool Fuel Charges 5060101 160000 778675 Telephone Communications 5060326 160010 712020 Overtime 5060326 160010 730646 Equipment Maintenance 5060326 160010 750063 Custodial Supplies 5060326 160010 750154 Expendable Equipment 5060326 160010 750399 Office Supplies 5060326 160010 776659 Motor Pool Fuel Charges 5060327 160010 712020 Overtime 5060327 160010 730121 Bank Charges 5060327 160010 730247 Charge Card Fee 5060327 160010 730646 Equipment Maintenance 5060327 160010 731689 Security Expense 5060327 160015 731780 Software Support Maintenance 5060327 160010 750154 Expendable Equipment 5060327 160010 750399 Office Supplies 5060327 160010 776659 Motor Pool Fuel Charges 5060328 160010 730646 Equipment Maintenance 5060328 160010 731689 Security Expense 5060328 160010 750154 Expendable Equipment 5060328 160010 750399 Office Supplies 5060328 160010 750581 Uniforms 5060330 160010 712020 Overtime 5060330 160010 730562 Electrical Service -5060330 160010 730646 Equipment Maintenance 5060330 160010 731269 Natural Gas (1,000.00) (5,000.00) (250.00) (1,000.00) (400.00) (3,000.00) (2,000.00) 4,000.00 3,000.00 (200.00) (40,000.00) (500.00) (500.00) (2,000.00) (200.00) (1,500.00) 3,000.00 (1,000.00) (4,000.00) (40,000.00) (1,000.00) (500.00) 3,000.00 (2,500.00) (40,000.00) (500.00) (400.00) (1,000.00) (5,000.00) 3,000_00 (2,500.00) 32 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS ACCOUNT NUMBER FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060330 160010 731780 Software Support Maintenance 5060330 160010 750154 Expendable Equipment 5060330 160010 776659 Motor Pool Fuel Charges 5060356 160010 730646 Equipment Maintenance 5060356 160010 731213 Membership Dues 5060356 160010 731689 Security Expense 5060356 160010 750154 Expendable Equipment 5060356 160010 750399 Office Supplies 5060356 160010 750504 Small Tools 5060356 160010 750581 Uniforms 5060356 160010 774636 Info Tech Operations 5060356 160010 776661 Motor Pool 5060417 160044 730520 Design Fees 5060417 160044 731269 Natural Gas 5060420 160044 730786 Garbage and Rubbish Disposal 5060420 160044 731500 Public Information 5060420 160044 731780 Software Support Maintenance 5060420 160044 750063 Custodial Supplies 5060420 160044 750154 Expendable Equipment 5060420 160044 750385 Merchandise 5060420 160044 750581 Uniforms 5060420 160044 774636 Info Tech Operations 5060426 160044 730562 Electrical Service 5060427 160044 730562 Electrical Service 5060427 160044 731269 Natural Gas 5060427 160044 731689 Security Expense 5060430 160044 732102 Water and Sewage Charges 5060431 160044 730198 Building Maintenance Charges 5060431 160044 731500 Public Information 5060431 160044 731780 Software Support Maintenance 5060431 160044 731941 Training (1,000.00) (40,000.00) (500.00) 3,000.00 (500.00) (500.00) (40,000.00) (500.00) (500.00) (500.00) 3,000.00 (500.00) (7,100.00) (1,500.00) (500.00) (500.00) (500.00) (1,500.00) (1,000.00) (2,500.00) (250.00) 500.00 12,000.00 (5,000.00) (2,000.00) (1,500.00) (1,500.00) (5,000.00) (500.00) (500.00) (500.00) 33 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060431 160044 750063 Custodial Supplies 5060431 160044 750154 Expendable Equipment 5060431 160044 750385 Merchandise 5060431 160044 750581 Uniforms 5060437 160044 731388 Printing 5060437 160044 731500 Public Information 5060437 160044 750063 Custodial Supplies 5060437 160044 750385 Merchandise 5060437 160044 750581 Uniforms 5060456 160044 730562 Electrical Service 5060456 160044 731689 Security Expense 5060540 160500 730562 Electrical Service 5060540 160500 731269 Natural Gas 5060540 160500 750063 Custodial Supplies 5060540 160500 750504 Small Tools 5060715 160070 730121 Bank Charges 5060715 160070 730562 Electrical Service 5060715 160070 731689 Security Expense 5060715 160070 750504 Small Tools 5060715 160070 774636 Info Tech Operations 5060715 160070 776659 Motor Pool Fuel Charges 5060720 160070 730121 Bank Charges 5060720 160070 730198 Building Maintenance Charges 5060720 160070 730786 Garbage and Rubbish Disposal 5060720 160070 731241 Miscellaneous 5060720 160070 731689 Security Expense 5060720 160070 731780 Software Support Maintenance 5060720 160070 750063 Custodial Supplies 5060720 160070 750511 Special Event Supplies 5060720 160070 750581 Uniforms 5060720 160070 776659 Motor Pool Fuel Charges (500.00) (500.00) (7,500.00) (500.00) (250.00) (500.00) (500.00) (7,500.00) (550.00) (2,000.00) (2,000.00) (2,700.00) (3,200.00) (500.00) (500.00) (300.00) 12,000.00 (5,000.00) (500.00) (4,000.00) (3,000.00) (300.00) (7,500.00) (5,000.00) (1,500.00) (5,000.00) 15,244.00 (500.00) (2,000.00) (500.00) (2,000.00) 34 SCHEDULE B OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS ACCOUNT NUMBER FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060720 160070 777560 Radio Communications 5060724 160070 730562 Electrical Service 5060724 160070 750399 Office Supplies 5060724 160070 750504 Small Tools 5060724 160070 776659 Motor Pool Fuel Charges 5060725 160070 702010 Salaries Regular 5060725 160070 722740 Fringe Benefits 5060725 160070 730562 Electrical Service 5060725 160070 731689 Security Expense 5060725 160070 750063 Custodial Supplies 5060725 160070 750399 Office Supplies 5060725 160070 750476 Recreation Supplies 5060725 160070 750581 Uniforms 5060725 160070 776661 Motor Pool 5060729 160070 731689 Security Expense 5060732 160070 731689 Security Expense 5060732 160070 774636 Info Tech Operations 5060732 160070 774677 Insurance Fund 5060735 160070 730562 Electrical Service 5060735 160070 731269 Natural Gas 5060735 160070 731689 Security Expense 5060735 160070 750504 Small Tools 5060735 160070 776659 Motor Pool Fuel Charges 5060751 160070 730562 Electrical Service 5060751 160070 731689 Security Expense 5060755 160070 750399 Office Supplies 5060755 160070 750581 Uniforms 5060760 160070 731689 Security Expense 5060765 160070 730562 Electrical Service 5060765 160070 731241 Miscellaneous 5060765 160070 750581 Uniforms (200.00) (500.00) (1,000.00) (500.00) (500.00) (56,556.00) (33,535.00) (5,000.00) (10,000.00) (1,000.00) (600.00) (5,000.00) (1,000.00) (1,000.00) (1,000.00) (2,500.00) (500.00) 7,000.00 12,000.00 5,000.00 (10,000.00) (600.00) (500.00) (1,000.00) (1,000.00) (500.00) (300.00) (2,500.00) (200.00) (1,000.00) (100.00) 35 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS 1PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name 5060805 160210 702010 Salaries Regular 5060805 160210 712020 Overtime 5060805 160210 722740 Fringe Benefits 5060805 160210 730373 Contracted Services 5060805 160210 732018 Travel and Conference 5060805 160210 750399 Office Supplies 5060805 160210 750476 Recreation Supplies 5060805 160210 750504 Small Tools 5060805 160210 750581 Uniforms 5060805 160210 776659 Motor Pool Fuel Charges 5060805 160210 778675 Telephone Communications 5060831 160210 730373 Contracted Services 5060831 160210 731689 Security Expense 5060831 160210 750063 Custodial Supplies 5060831 160210 750399 Office Supplies 5060831 160210 750476 Recreation Supplies 5060831 160210 750504 Small Tools 5060831 160210 776659 Motor Pool Fuel Charges 5060837 160210 730562 Electrical Service 5060837 160210 731689 Security Expense 5060837 160210 750063 Custodial Supplies 5060837 160210 750399 Office Supplies 5060845 160210 702010 Salaries Regular 5060845 160210 722740 Fringe Benefits 5060845 160210 730814 Grounds Maintenance 5060845 160210 750476 Recreation Supplies 5060845 160210 750504 Small Tools 5060870 160210 731689 Security Expense 5060870 160210 750476 Recreation Supplies 5060870 160210 750504 Small Tools 5060910 160430 702010 Salaries Regular (41,786.00) (5,000.00) (2,403.00) (5,000.00) (2,250.00) (1,000.00) (1,300.00) (5,000.00) (500.00) (5,000.00) (1,000.00) (1,500.00) (2,500.00) (500.00) (500.00) (2,500.00) (500.00) (500.00) (5,000.00) (2,500.00) (500.00) (500.00) (6,700.00) (1,300.00) (2,000.00) (1,000.00) (1,000.00) (1,500.00) (1,200.00) (300.00) (8,107.00) 36 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS Grounds Maintenance Grounds Maintenance Grounds Maintenance Licenses and Permits Grounds Maintenance Licenses and Permits Grounds Maintenance Licenses and Permits Grounds Maintenance Grounds Maintenance Grounds Maintenance Licenses and Permits Grounds Maintenance Grounds Maintenance Grounds Maintenance Grounds Maintenance PARKS AND RECREATION FUND (#508001 Expenses 5060326 160010 730814 5060327 160010 730814 5060330 160010 730814 5060330 160010 731115 5060715 160070 730814 5060715 160070 731115 5060720 160070 730814 5060720 160070 731115 5060724 160070 730814 5060724 160070 730814 5060725 160070 730814 5060725 160070 731115 5060735 160070 730814 5060751 160070 730814 5060755 160070 730814 5060755 160070 730814 (2,000.00) (466.00) (510,000.00) 420,000.00 (600.00) (500.00) (5,000.00) (2,000.00) (2,000.00) (747,444.00) 511.00 3,086.00 511.00 400.00 600.00 400.00 1,841.00 400.00 1,065.00 562.00 320.00 200.00 511.00 1,923.00 1,040.00 523.00 PROPRIETARY/SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Deot1D Program Acct Fund Aff Oiler Unit Account Name 5060910 160430 712020 Overtime 5060910 160430 722740 Fringe Benefits 5060910 160430 730198 Building Maintenance Charges 5060910 160430 730789 General Program Administration 5060910 160430 750504 Small Tools 5060910 160430 750581 Uniforms 5060910 160430 774636 Info Tech Operations 5060910 160430 776659 Motor Pool Fuel Charges 5060910 160430 778675 Telephone Communications Total Expenses 37 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS 'PROPRIETARY/ SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program, Acct Fund Aff Oper Unit Account Name 5060760 160070 730814 Grounds Maintenance 5060765 160070 730814 Grounds Maintenance 5060910 160430 730789 General Program Administration Total Expenses 523.00 349.00 (14,765.00) TELEPHONE COMMUNICATIONS FUND 67500 Expenses 1080601 152000 730324 1080601 152000 730373 1080601 152000 731458 Communications Contracted Services Professional Services Total Expenses (128,000.00) 88,000.00 40,000.00 LAW ENFORCEMENT ENHANCE LAB FEES FUND (#21340) Revenue 4030101 112580 665882 Planned Use of Balance 7,130.00 Total Revenue 7,130.00 Expenditure 4030101 112580 788001 40400 Transfer Out - Project Work Order Fund 7,130.00 Total Expenditure 7,130.00 PROJECT WORK ORDER FUND (#40400) PCBU: FACMG, Project 100000002337, Activity: PROJ Revenue 1040101 148020 695500 21340 Transfer In-LE Enhance Lab Fees Fund $ 7,130.00 Total Revenue 7,130.00 38 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Expenditure 1040101 148020 796500 Budgeted Equity Adjustments Total Expenditure 7,130.00 7,130.00 PROJECT WORK ORDER FUND (#40400) Project: 100000002184, Activity: PROJ Revenue 1040101 148020 695500 10100 Expenditure 1040101 148020 796500 PROJECT WORK ORDER FUND (#40400) Project: 100000002306, Activity: PROJ Revenue 1040101 148020 695500 10100 Expenditure 1040101 148020 796500 Transfer In - General Fund Total Revenue $ (1,387,170.00) $ (1,387,170.00) Budgeted Equity Adjustment Total Expenditure (1,387,170.00) (1,387,170.00) Transfer In - General Fund 1,387,170.00 Total Revenue 1,387,170.00 Budgeted Equity Adjustment 1,387,170.00 Total Expenditure 1,387,170.00 BUILDING IMPROVEMENT FUND (#4011:10) Revenue 1040101 148020 665882 10100 Planned Use of Balance 15,541.00 Total Revenue 15,541.00 39 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY /SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS 'PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit Account Name Expenditure 1040101 148020 788001 40400 Transfer Out Proj Wrk Order Fund Total Expenditure 15,541.00 15,541.00 PROJECT WORK ORDER FUND (#40400) PCBU: FACMG, Project: 100000002316, Activity: PROJ Revenue 1040101 148020 695500 40100 Transfer in - Building Improvement Fund $ 15,541.00 15,541.00 Total Revenue Expenditure 1040101 148020 796500 BUILDING IMPROVEMENT FUND (#40100) Revenue 1040101 148020 665882 10100 Budgeted Equity Adjustment Total Expenditure Planned Use of Balance Total Revenue 15,541.00 15,541.00 28,302.00 28,302.00 Expenditure 1040101 148020 788001 40400 Transfer Out - Proj Wrk Order Fund 28,302.00 Total Expenditure 28,302.00 40 SCHEDULE B ACCOUNT NUMBER OAKLAND COUNTY, MICHIGAN FISCAL YEAR 2016 FIRST QUARTER BUDGET AMENDMENTS PROPRIETARY / SPECIAL REVENUE FUNDS FY 2016 AMENDMENTS FY 2017 FY 2018 AMENDMENTS AMENDMENTS PROPRIETARY! SPECIAL REVENUE FUNDS - SELF BALANCING AMENDMENTS Dept ID Program Acct Fund Aff Oper Unit PROJECT WORK ORDER FUND (#40400) PCBU: FACMG, Project: 100000002315, Activity: PROJ Revenue Account Name 1040101 148020 695500 40100 Transfer In - Building Improvement Fund 28,302.00 Total Revenue 28,302.00 Expenditure 1040101 148020 796500 Budgeted Equity Adjustment 28,302.00 Total Expenditure 28,302.00 41 Fringe Benefit Retirement Amendments 1st Quarter Amendments Fiscal Year 2016 SCHEDULE C Unit Ledger Fund Dept Program lAccount Project OU Fund Aff BudRef Proj Unit ctivity 1---aTiTil; Res Type Amount General Fund General Purpose Funds - All Departments USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY usGry USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY BUDGET 10100 1010101 181000 722770 BUDGET 10100 1010105 181000 722770 BUDGET 10100 1010201 181010 722770 BUDGET 10100 1010205 181010 722770 BUDGET 10100 1010210 182090 722770 BUDGET 10100 1010501 181020 722770 BUDGET 10100 1020101 182010 722770 BUDGET 10100 1020501 173010 722770 BUDGET 10100 1020501 173020 722770 BUDGET 10100 1020501 173030 722770 BUDGET 10100 1020501 173040 722770 BUDGET 10100 1020501 173050 722770 BUDGET 10100 1020501 173060 722770 BUDGET 10100 1020501 186000 722770 BUDGET 10100 1020501 186010 722770 BUDGET 10100 1020501 186020 722770 BUDGET 10100 1020501 186030 722770 BUDGET 10100 1020601 182020 722770 BUDGET 10100 1020601 182040 722770 BUDGET 10100 1020601 182050 722770 BUDGET 10100 1020601 182080 722770 BUDGET 10100 1020650 126000 722770 BUDGET 10100 1020650 126010 722770 BUDGET 10100 1020650 126020 722770 BUDGET 10100 1030101 184000 722770 BUDGET 10100 1030801 184030 722770 BUDGET 10100 1030803 184020 722770 BUDGET 10100 1030803 184025 722770 BUDGET 10100 1040101 140000 722770 BUDGET 10100 1040801 148020 722770 BUDGET 10100 1050101 183010 722770 BUDGET 10100 1050102 183130 722770 BUDGET 10100 1050401 183010 722770 BUDGET 10100 1050402 183020 722770 BUDGET 10100 1050402 183070 722770 BUDGET 10100 1050402 183100 722770 BUDGET 10100 1050415 183020 722770 BUDGET 10100 1050415 183100 722770 (38,360) (17,024) (6,269) (5,789) (26,334) (50,758) (5,980) (26,642) (67,177) (25,758) (9,382) (8,223) (2,795) (8,345) (13,491) (14,802) (3,023) (12,950) (19,968) (28,262) (59,186) (21,985) (21,646) (5,611) (5,984) (4,583) (11,192) (8,575) (4,930) (16,964) (8,796) (8,441) (3,671) (15,311) (11,061) (3,071) (3,416) (6,116) 42 Fringe Benefit Retirement Amendments 1st Quarter Amendments Fiscal Year 2016 SCHEDULE C Ledger Fund Dept Program lAccount Project 110U J Fund All BudRef Proj Unit lActivity IAJ,aysis Res Type Amount 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET 1050501 1060101 1060201 1060201 1060201 1060211 1060211 1060211 1060211 1060211 1060212 1060213 1060214 1060220 1060220 1060231 1060231 1060231 1060232 1060233 1060233 1060233 1060234 1060236 1060237 1060237 1060237 1060261 1060283 1060601 1060601 1060601 1070101 1070301 1070301 1070401 1070401 1070401 1070401 183010 133000 133020 133150 133170 133020 133150 133390 133990 134390 133120 133130 133150 134190 134390 133150 133390 133990 134850 133350 133370 133390 133990 133390 133300 133310 133390 134790 133120 115090 115120 115180 132020 132050 132080 113000 113010 113020 113050 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 100000001994 722770 100000001941 722770 722770 722770 722770 722770 722770 722770 (4,311) (3,923) (18,007) (24,258) (9,523) (3,826) (28,101) (3,208) (21,438) (9,174) (8,789) (3,773) (3,439) (4,277) (141,813) (3,444) (3,416) (3,097) (4,099) (19,061) (9,783) (6,583) (70,770) (120,320) (2,274) (3,909) (2,600) (3,097) (2,373) (14,025) (4,097) (81) (5,980) (34,660) (1,461) (12,475) (5,568) (7,491) (3,857) 2016 GRANT GLB GLB 2016 GRANT GLB GLB 43 Fringe Benefit Retirement Amendments 1st Quarter Amendments Fiscal Year 2016 SCHEDULE C Unit Ledger Fund Dept Program lAccount Project ilOU Fund Aff Bud Ref Proj Unit Activity lAnalysis Res Type Amount 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET 1070401 1070401 1070401 1070401 1070401 1070401 1070501 1070501 1070501 1070501 1070601 1070801 1070801 1070805 1070810 1090101 1090101 1090108 1090201 1090201 1090202 1090204 1090204 1090204 1090204 1090205 1090206 1090207 2010101 2010201 2010205 2010210 2010301 2010401 2010501 2010601 3010101 3010101 3010101 113060 113080 113130 113140 123000 123010 131030 132120 174000 174170 132030 114000 114010 114090 114100 171000 171030 171030 171000 171080 171100 172020 172040 173100 174220 171010 171090 174230 180000 125000 132305 125000 185010 172190 121285 172190 121100 121120 121130 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 (10,294) (5,148) (6,791) (2,857) (4,190) (21,612) (6,437) (2,978) (4,065) (2,616) (74,798) (9,698) (46) (11,176) (20,598) (9,695) (52) (20,093) (1,440) (2,766) (2,379) (2,784) (14,354) (4,506) (6,820) (33,983) (13,200) (7,437) (19,275) (6,681) (15,262) (52,997) (17,058) (45,278) (61) (5,544) (14,740) (21,704) (133,166) 44 Fringe Benefit Retirement Amendments 1st Quarter Amendments SCHEDULE C Fiscal Year 2016 Unit Ledger Fund Dept [Program 'Account Project OU Fund Aff BudRef Proj UnitcF"-tiity AriaIysis Res Type Amount 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET 3010101 3010101 3010201 3010301 3010301 3010301 3010301 3010301 3010301 3010301 3010301 3010402 3010402 3010402 3010402 3010403 3010403 3010403 3010403 3020101 3020201 3020205 3020301 3020305 3020401 3020405 3020501 3020505 3040101 3040101 3040101 3040403 3040403 4010101 4010101 4010101 4010201 4010201 4010201 121210 121220 121100 121100 121130 121140 121150 121160 121170 121180 121190 111000 121100 135060 135070 121100 121230 121240 135080 121030 121020 113290 121020 113290 121020 113290 121020 113290 121015 121090 121091 121015 124015 122000 125010 135170 122030 122040 122050 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 (5,817) (30,565) (36,395) (6,735) (4,814) (11,283) (3,229) (1,307) (1,795) (6,746) (3,071) (57,808) (3,104) (41,175) (1,978) (7,290) (31,145) (39,046) (8,832) (3,234) (56,494) (31,773) (31,807) (8,851) (53,735) (26,721) (35,426) (8,878) (3,848) (35,099) (15,957) (8,146) (37,568) (32,471) (8,177) (10,726) (22,439) (20,872) (155,572) 45 Fringe Benefit Retirement Amendments 1st Quarter Amendments SCHEDULE C Fiscal Year 2016 Unit Ledger LFund Dept Program nraccount Project OU Fund Ail [Bud Ref ilProj Unit I cFatil,(74 lAnalysis Res Type Amount 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 SHERF GLB GLB USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET 4010201 4010201 4010301 4010301 4010401 4030101 4030201 4030201 4030201 4030301 4030301 4030301 4030401 4030401 4030401 4030401 4030401 4030401 4030501 4030505 4030510 4030601 4030601 4030601 4030601 4030601 4030601 4030601 4030601 4030601 4030601 4030601 4030601 4030601 4030601 4030601 4030601 4030601 4030601 122060 122080 122050 122060 122050 112580 112580 112680 113380 112590 112620 112650 112590 112670 113381 116190 116245 121280 116230 110110 116230 110000 110010 110020 110030 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 116180 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 RESULTS_PROG 722770 722770 722770 722770 722770 722770 722770 722770 722770 40060 722770 40080 722770 40030 722770 ROYAL OAK 40160 722770 40120 722770 40130 722770 40090 722770 ADDISON 40010 722770 SPRINGFIELD 40180 722770 BRANDON 40030 722770 OAKLAND 40120 722770 OXFORD 40140 722770 LYON 40090 722770 HIGHLAND 40060 (44,309) (1,803) (49,319) (2,728) (45,747) (41,549) (19,696) (18,687) (3,606) (9,847) (532,863) (108,052) (8,207) (104,756) (78,134) (1,177) (4,060) (40,393) (2,755) (21,773) (133,003) (8,293) (5,431) (15,675) (23,157) (699) (2,316) (2,663) (2,728) (2,789) (3,268) (3,668) (15,446) (26,638) (28,163) (39,315) (39,629) (42,976) (46,870) SHERF GLB GLB SHERF GLB GLB SHERF GLB GLB SHERF GLB GLB SHERF GLB GLB SHERF GLB GLB SHERF GLB GLB SHERF GLB GLB 46 Fringe Benefit Retirement Amendments 1st Quarter Amendments SCHEDULE C Fiscal Year 2016 Unit Ledger Fund Dept Program lAccount Project OU Fund Aft BudRef Proj Unit lActivity naIysis Res Type Amount 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 10100 20293 20293 20293 20293 20293 20293 20293 SHERF GLB GLB SHERF GLB GLB USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USC-P( USCTY USCTY USCTY USCTY USCTY BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET 4030601 4030601 4030601 4030601 4030601 4030601 4030601 4030601 4030601 4030901 4030901 4030901 4030901 4030901 4030901 4030901 4030901 4030901 4030901 4030901 5010101 5010101 5010302 5010303 6010101 7010101 7010101 7010101 7010101 7010101 7010101 7010110 1060501 1060501 1060501 1060501 1060501 1060501 1060501 116180 116180 116180 116180 116180 116181 116190 116200 116210 110040 110050 110060 110060 110090 110100 116240 116240 116250 116260 116270 180010 180020 165020 165040 155012 186040 186050 186070 186080 186090 186100 186130 112010 112020 112030 112050 112060 112070 112100 722770 ORION 722770 INDEPENDENCE 722770 COMMERCE 722770 ROCH_HILLS 722770 722770 PARKS 722770 722770 MARINE 722770 722770 722770 722770 NON_PROJ_OT 722770 722770 722770 722770 FORENSIC LAB 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 (68,712) (82,082) (86,177) (154,050) (211,938) (12,624) (2,902) (2,791) (6,513) (11,696) (23,409) (1,937) (22,987) (27,887) (14,461) (2,542) (38,124) (25,010) (13,886) (2,158) (21,334) (29,594) (7,086) (4,653) (5,351) (20,302) (10,352) (9,715) (14,042) (3,606) (4,881) (11,255) (36,353) (20,994) (17,159) (52,841) (698) (18,001) (18,456) 40130 SHERF GLB GLB 40080 SHERF GLB GLB 40040 SHERF GLB GLB 40440 SHERF GLB GLB 40420 GLB GLB SHERF GLB GLB GLB GLB SHERF GLB GLB 47 Fringe Benefit Retirement Amendments 1st Quarter Amendments Fiscal Year 2016 SCHEDULE C USCTY BUDGET 20293 1060501 112150 722770 USCTY BUDGET 20293 1060501 112170 722770 USCTY BUDGET 20293 1060501 112190 722770 USCTY BUDGET 20293 1060501 112210 722770 USCTY BUDGET 20293 1060501 112450 722770 USCTY BUDGET 20293 1060501 112470 722770 USCTY BUDGET 20293 1060501 112480 722770 USCTY BUDGET 20293 1060501 112500 722770 USCTY BUDGET 20293 1060501 112520 722770 USCTY BUDGET 20293 1060501 112640 722770 USCTY BUDGET 20293 1060501 112560 722770 USCTY BUDGET 20293 1060501 131000 722770 USCTY BUDGET 20293 1060501 131010 722770 USCTY BUDGET 20293 3010402 113310 722770 USCTY BUDGET 20293 3010402 113321 722770 USCTY BUDGET 20293 3010402 121200 722770 USCTY BUDGET 20293 3010402 135120 722770 USCTY BUDGET 20293 9090101 112700 695500 USCTY BUDGET 20293 9010101 112700 615359 USCTY BUDGET 10100 9010101 196030 788001 USCTY BUDGET 10100 9010101 196030 665882 Concealed Pistol Licensing Fund #20300 USCTY BUDGET 20300 2010205 132315 722770 USCTY BUDGET 20300 2010205 132315 796500 Register of Deeds Automation Fund #21160 USCTY BUDGET 21160 2010401 172220 722770 USCTY BUDGET 21160 2010401 172220 665882 BFC Personnel Fund #21184 USCTY BUDGET 21184 1090202 171100 722770 USCTY BUDGET 21184 1090202 171100 665882 Friend of the Court Fund #27100 (informational only - do not post) (29,677) (23,303) (6,147) (81) (15,149) (12,048) (15,114) (11,809) (11,600) (13,314) (1,794) (6,930) (34,721) (16,236) (29,400) (6,181) (6,206) 10100 202,107 202,107 20293 (202,107) 5,527,104 (3,116) 3,116 (11,074) 11,074 (14,045) 14,045 USCTY BUDGET 27100 3010404 126030 722770 (193,797) USCTY BUDGET 27100 3010404 126050 722770 (42,783) USCTY BUDGET 27100 3010404 135140 722770 (48,848) USCTY BUDGET 27100 4030925 110070 722770 (19,744) Drug Court District 52 2 SCAO Fund #27160 (informational only - do not post) USCTY BUDGET 27160 3020301 121050 722770 G R0000000243 2016 GRANT GLB GLB 1,147 USCTY BUDGET 27160 3020305 121050 722770 GR0000000243 2016 GRANT GLB GLB (1,147) ATPA Grants Fund #27310 (informational only - do not post) 48 Fringe Benefit Retirement Amendments 1st Quarter Amendments Fiscal Year 2016 SCHEDULE C Unit Ledger Fund Dept Program count Project Fund Aff Bud Ref Proj Unit FActivity nalysis Res Type Amount USCTY BUDGET 27310 4030901 116270 722770 0R0000000377 Prosecutor Co Op Reimbursement Fund #27315 (informational only - do not post) USCTY BUDGET 27315 4010201 126070 722770 GR0000000143 Sheriff Road Patrol Fund #27345 (informational only - do not post) USCTY BUDGET 27345 4030601 110010 722770 GR0000000142 Paul Coverdell Grant Fund #27346 (informational only - do not post) USCTY BUDGET 27346 4030901 116240 722770 GR0000000708 Community Development Block Grants Fund #29701(informational only - do not post) USCTY BUDGET 29701 1020622 132000 722770 GRO000000381 USCTY BUDGET 29701 1090611 132210 722770 GR0000000381 USCTY BUDGET 29701 1090611 132280 722770 GROOOD000381 USCTY BUDGET 29701 1090611 172130 722770 GRO000000381 USCTY BUDGET 29701 1090680 132210 722770 GR0000000381 Workforce Dev Undistributed Fund #29801(informational only - do not post) 2016 GRANT GLB GLB (20,553) 2016 GRANT GLB GLB (49,997) 2016 GRANT GLB GLB (16,505) 2016 GRANT GLB GLB (2,323) 27003 2014 COMHI GLB GLB A (2,182) 27004 2014 COMHI GL13 GLB A (1,860) 27003 2014 COMHI GLB GLB A (28,882) 27002 2014 COMHI GLB GLB A (11,394) 27004 2014 COMHI GLB GLB A (5,116) USCTY BUDGET 29801 1020622 170000 722770 GR0000000294 2016 GRANT GLB GLB (1,856) USCTY BUDGET 29801 1090205 171010 722770 GR0000000294 2016 GRANT GLB GLB (2,796) USCTY BUDGET 29801 1090701 170010 722770 GR0000000294 2016 GRANT GLB GLB (10,704) Delinquent Tax Revolving Fund #51600 USCTY BUDGET 51600 7010110 186050 722770 USCTY BUDGET 51600 7010110 186050 665882 Delinquent Personal Prop Tax Admin Fund #51800 USCTY BUDGET 51800 7010110 186060 722770 USCTY BUDGET 51800 7010110 186060 665882 Fire Records Management Fund #53100 USCTY BUDGET 53100 1080325 115100 722770 USCTY BUDGET 53100 1080325 115100 665882 CLEMIS Fund #53500 USCTY BUDGET 53500 1080301 116020 722770 USCTY BUDGET 53500 1080301 116155 722770 USCTY BUDGET 53500 1080301 116020 665882 Radio Communications Fund #53600 USCTY BUDGET 53600 1080310 115150 722770 USCTY BUDGET 53600 1080310 115150 665882 County Airports Fund #56500 USCTY BUDGET 56500 1030701 154000 722770 USCTY BUDGET 56500 1030701 154010 722770 USCTY BUDGET 56500 1030745 154010 722770 USCTY BUDGET 56500 1030750 154010 722770 USCTY BUDGET 56500 1030701 154010 665882 (4,488) 4,488 (6,444) 6,444 (9,513) 9,513 (60,638) (5,388) 66,026 (20,371) 20,371 (12,212) (28,691) (166) (166) 41,236 49 Drain Equipment Fund #63900 USCTY BUDGET 63900 6010101 149760 722770 USCTY BUDGET 63900 6010101 149760 796500 Motorpool Fund #66100 USCTY BUDGET 66100 1030811 184010 722770 USCTY BUDGET 66100 1030811 184010 796500 Telephone Communications Fund #67500 USCTY BUDGET 67500 USCTY BUDGET 67500 Building Liability Fund #67700 USCTY BUDGET 67700 USCTY BUDGET 67700 USCTY BUDGET 67700 1080601 152070 722770 1080601 152070 665882 1010501 182000 722770 1010502 182000 722770 9015501 182210 665882 Unit Ledger Fund Dept Program lAccount Project OU Fund Aff BudRef Proj Unit IActivity AnaIysis likes Type Amount Water & Sewer Fund #57010 USCTY BUDGET 57010 1020601 182080 722770 USCTY BUDGET 57010 1020601 182080 665882 Facilities Maintenance & Operations Fund #63100 USCTY BUDGET 63100 1040701 140101 722770 25900 USCTY BUDGET 63100 1040718 140299 722770 25900 USCTY BUDGET 63100 1040719 140399 722770 25900 USCTY BUDGET 63100 1040725 140599 722770 25900 USCTY BUDGET 63100 1040740 148499 722770 25900 USCTY BUDGET 63100 1040770 145100 722770 25900 USCTY BUDGET 63100 1040801 140030 722770 25900 USCTY BUDGET 63100 1040701 140010 665882 Information Technology Fund #63600 Fringe Benefit Retirement Amendments 1st Quarter Amendments Fiscal Year 2016 SCHEDULE C 63600 63600 63600 63600 63600 63600 63600 63600 63600 63600 63600 63600 63600 (3,717) 3,717 (17,610) (77,480) (102,113) (23,483) (15,629) (40,048) (14,191) 290,554 (3,052) (49,962) (1,940) (25,682) (66,170) (16,929) (13,067) (16,165) (20,517) (2,616) (38,202) (118,379) 372,679 (689,469) 689,469 (30,430) 30,430 (8,381) 8,381 (4,559) (13,886) 18,445 USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET 1080101 1080101 1080101 1080201 1080201 1080201 1080201 1080201 1080201 1080601 1080601 1080601 1080101 121000 152000 152070 121010 132200 152000 152020 152030 182190 152000 152015 152090 152000 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 722770 665882 50 183000 182080 183165 183160 183192 183150 183190 183190 182040 182050 182080 160000 160001 160010 160015 160010 160015 160010 160015 160010 160015 160010 160015 160044 160044 160044 160044 160044 160044 160500 160070 160070 160070 160070 160070 160070 160070 722770 722770 722770 722770 722770 722770 630672 665882 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 (6,461) (2,751) (13,574) (11,118) (2,835) (11,950) (7,951,311) 8,000,000 (3,237) (4,907) (2,094) (61,158) (6,682) (3,206) (1,197) (4,524) (189) (1,784) (209) (3,018) (1,251) (3,636) (203) (65) (120) (357) (288) (363) (1,678) (2,106) (7,776) (5,113) (109) (6,664) (468) (1,249) (4,710) Fringe Benefit Retirement Amendments 1st Quarter Amendments Fiscal Year 2016 SCHEDULE C Unit Ledger Fund Dept ProgramccF.'OT—JM. Project OU Fund Aff Bud Ref Prej Unit c.fity Anarysis Res Type Amount Fringe Benefit Fund #67800 USCTY BUDGET 67800 1010502 USCTY BUDGET 67800 1020615 USCTY BUDGET 67800 1050515 USCTY BUDGET 67800 1050520 USCTY BUDGET 67800 1050525 USCTY BUDGET 67800 1050525 USCTY BUDGET 67800 9011501 USCTY BUDGET 67800 9011501 Parks end Recreation Fund #50800 USCTY BUDGET 50800 1020601 USCTY BUDGET 50800 1020658 USCTY BUDGET 50800 1020658 USCTY BUDGET 50800 5060101 USCTY BUDGET 50800 5060101 USCTY BUDGET 50800 5060326 USCTY BUDGET 50800 5060326 USCTY BUDGET 50800 5060327 USCTY BUDGET 50800 5060327 USCTY BUDGET 50800 5060328 USCTY BUDGET 50800 5060328 USCTY BUDGET 50800 5060330 USCTY BUDGET 50800 5060330 USCTY BUDGET 50800 5060356 USCTY BUDGET 50800 5060356 USCTY BUDGET 50800 5060417 USCTY BUDGET 50800 5060426 USCTY BUDGET 50800 5060427 USCTY BUDGET 50800 5060430 USCTY BUDGET 50800 5060431 USCTY BUDGET 50800 5060456 USCTY BUDGET 50800 5060540 USCTY BUDGET 50800 5060715 USCTY BUDGET 50800 5060720 USCTY BUDGET 50800 5060724 USCTY BUDGET 50800 5060725 USCTY BUDGET 50800 5060729 USCTY BUDGET 50800 5060732 USCTY BUDGET 50800 5060735 51 Fringe Benefit Retirement Amendments 1st Quarter Amendments SCHEDULE C Fiscal Year 2016 Unit Fund Dept Program lAccount Project OU Fund Aff BudRef Proj Unit W, -rib! AnaIysis Res Type Amount 50800 50800 50800 50800 50800 50800 50800 50800 50800 50800 50800 USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY USCTY BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET 5060751 5060755 5060760 5060765 5060805 5060831 5060837 5060845 5060870 5060910 5060666 160070 160070 160070 160070 160210 160210 160210 160210 160210 160430 160666 722740 722740 722740 722740 722740 722740 722740 722740 722740 722740 665882 (610) (1,523) (49) (33) (16,859) (4,842) (162) (38) (306) (19,989) 172,772 52 53 $ 404,540,375,00 $ 2,104,411.00 SUB-TOTAL GENERAL FUND/GENERAL PURPOSE $ 401,292,070.00 $ 402,435,964.00 0.52% $ 29,363,330.00 $ 39,518,497.08 $ 39,518,497.08 0.00% PLANNED USE OF FUND BALANCE $ 430,655,400.00 $ 441,954,461.08 0.48% TOTAL OF/OP FUNDS $ 444,0513,872.08 2,104,411.00 LAW ENFORCEMENT Prosecuting Attorney Sheriff 19,573,867,00 141,369,640.00 19,653,051.27 144,128,196.82 18,967,651.27 144,661,996,82 3,49% (533,800.00) -0.37% 685,400.00 $ 160,943,507.00 $ 163,781,248.09 $ 163,829,648.09 151,600.00 0.09% TOTAL LAW ENFORCEMENT 7.05% 0.57% 1.89% 0.00% 0.00% 740,700.00 50,710.00 53,300.00 9,768,647.00 8,782,196.00 2,772,236.05 1,318,431.00 5,767,877.00 10,399,820.00 8,651,276.00 2,823,846.00 1,315,339,00 5,720,839.00 10,509,347.00 8,832,906.00 2,825,536.05 1,318,431.00 5,767,877.00 GENERAL GOVERNMENT Clerk/Register of Deeds Treasurer Board of Commissioners Library Board Water Resources Commissioner $ 28,911,120.00 $ 29,254,097.05 $ 28,409,387.06 $ 844,710.00 2.89% TOTAL GENERAL GOVERNMENT 0.00% 4.24% 0.00% 0.00% 0.00% 4.80% 0.00% 4.60% 835,000.00 3,041,500.00 367,200.00 $ 122,848,006.00 $ 123,771,433.65 $ 119,527,733.65 $ 4,243,700.00 3.43% TOTAL COUNTY EXECUTIVE 386,838,499,00 $ 391,545,397,08 8 381,645,387,08 2.53% TOTAL DEPARTMENTS 9,900,010.00 NON•DEPARTMENTAL APPROPRIATIONS TOTAL NON-DEPARTMENTALS 43,816,901.00 $ 50,409,064.00 $ 50,409,064.00 0.00% 9,900,010.00 2.24% TOTAL GOVERNMENTAL EXPENDITURES $ 430,655,400.00 $ 441,954,461.08 $ 432,054,451.08 12 004 421 00 $ 12,004,421.00 $ (39,518,497.08) $ (39,518,497.08) ($27,514,076.08) ($27,514,076.08) General Fund/General Purpose Faverablei(LInfaverable) - Budget Perspective GAAP Required Adjustment (eliminating use of fund balance "revenue") GAAP BASED REPORT (rorecasted Impact on Fund Balance) COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDITURES SUMMARY BY DEPARTMENT FY 2015 ADOPTED BUDGET BUDGET AS AMENDED FY 2015 FORECAST AMOUNT FAVORABLE/ (UNFAVORABLE) PERCENT REVENUES GENERAL FUND Taxes Federal Grants State Grants Other Intergovernmental Revenue Charges for Services Indirect Cost Recovery Investment Income Other Revenues $ 211,428,975.00 729,074.00 20,319,294.00 39,546,206.00 104,658,074.00 7,900,000.00 1,904,900.00 14,805,547.00 $ 211,428,975.00 690,765.00 20,527,537.00 39,463,356.00 105,695,944,00 7,900,000.00 1,904,900.00 14,824,487.00 $ 211,428,975.00 $ 690,765.00 19,770,037.00 (757,500.00) 39,484,356.00 21,000.00 108,505,904.00 2,809,960.00 7,900,000.00 1,913,144.00 8,244.00 14,847,194.00 22,707,00 0,00% 0.00% -3,69% 0.05% 2.66% 0.00% 0.43% 0.15% EXPENDITURES ADMINISTRATION OF JUSTICE Circuit Court 52nd District Court Probate Court TOTAL ADMIN. OF JUSTICE $ 51,351,244.00 8 51,900,161.00 $ 47,640,161.00 $ 4,260,000,00 16,550,943.00 16,587,466.00 16,237,466,00 350,000.00 6,233,680,00 6,250,991.29 6,200,991.29 50,000,00 $ 74,135,867.00 $ 74,738,616.29 $ 70,078,818.29 $ 4,660,000.00 COUNTY EXECUTIVE County Executive Admn. Management and Budget Central Services Facilities Management Human Resources Health and Human Services Public Services Economic Dev. and Comm Affairs $ 7,116,474.00 19,477,979,00 2,544,697.00 1,414,477.00 4,223,346.00 63,128,004.00 17,112,541.00 7,830,487.00 $ 7,132,402.00 19,680,427.00 2,551,501.00 1,414,542.00 4,328,120.00 63,428,896,55 17,245,325.00 7,990,220.10 $ 7,132,402.00 18,845,427.00 2,551,501.00 1,414,542.00 4,328,120.00 60,387,396.55 17,245,325.00 7,623,020.10 8,21% 2.11% 0,80% 6.24% COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2016 FIRST QUARTER REPORT ADOPTED BUDGET AMENDED BUDGET FY 2016 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES TAXES (601000-601999) Property Taxes - July Tax Levy 210,950,475.00 $ 210,950,475.00 $ 210,950,475.00 $ 0.00% Other Taxes - Delinquent Tax - Prior Years 98,500.00 98,500.00 98,500.00 0.00% Treasurer Payment in Lieu of Taxes Other Taxes - Trailer Tax Total Taxes 300,000.00 300,000.00 300,000.00 80,000.00 80,000.00 80,000.00 0.00% 0.00% 0.00% 211,428,975.00 $ 211,428,975.00 $ 211,428,975.00 $ FEDERAL GRANTS (610000-610999) Sheriff - Patrol - $ - $ 0.00% Sheriff 82,000.00 27,220.00 27,220.00 $ 0.00% Sheriff - Investigative/Forensic Services 0.00% Prosecuting Attorney Homeland Security - Disaster Control Health Division Children's Village Total Federal Grants STATE GRANTS (615000-615999) Sheriff- Patrol State Match Foster Care Prosecuting Attorney Economic Development Health Division Water Resources Commissioner Public Services - Veteran's Services 202,500.00 51,380.00 93,194.00 300,000.00 729,074.00 $ 1,000.00 2,500.00 4,521,752.00 90,000,00 202,500.00 51,380.00 109,665.00 300,000.00 690,765.00 $ 1,000.00 2,500.00 4,693,704.00 90,000.00 202,500.00 51,360.00 109,665.00 300 000.00 690,765.00 $ 1,000.00 2,500.00 4,693,704.00 90,000.00 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 1 of 13542016 Non-Departmental - Reimb Judges Salaries 1,915,095.00 1,915,095.00 1 915 095.00 0.00% Total Other Intergovernmental Revenue 39,546,206.00 $ 39,463,356.00 $ 39,484,356.00 $ 21,000.00 0.05% COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2016 FIRST QUARTER REPORT Non-Departmental - Child Care Subsidy ADOPTED BUDGET 15,704,042.00 AMENDED BUDGET 15,740,333.00 FY 2016 FORECAST 14,982,833.00 AMOUNT FAVORABLE (UNFAVORABLE). PERCENT EXPLANATION OF SIGNIFICANT VARIANCES (757,500.00) -4.81% Built into the Circuit Court Family Division, Human Services Administration and Children's Village budgets are Child Care Fund expenditures. A favorable variance within these expense areas reduces the 50% reimbursement the county receives. Unfav revenue variance is offset by Child Care Fund expenditure favorability. Total State Grants 20,319,294.00 $ 20,527,537.00 $ 19,770,037.00 $ (757,500.00) -3.69% OTHER INTER-GOVERNMENTAL REVENUES (620000 - 626999) Non-Departmental 37,288,811.00 $ HHS - Homeland Security 36,000 00 37,288,811.00 $ 36,000.00 37,288,811.00 $ 18,000.00 (18,000.00) 0.00% -50.00% Unfav. Local Match due to the installation of fewer than anticipated sirens. Offset by expenditure favorability (Tornado Siren Equip). Circuit Court District Court Sheriff 4,500.00 1,800.00 300,000.00 4,500,00 1,800.00 217,150.00 4,500.00 1,800.00 256,150.00 39,000.00 0.00% 0.00% 17.96% Favorable Social Security Incentive Payment receipts of $39,000; funds are collected from jail inmates receiving SSI for cost of incarceration. - 2,746,700.00 1,947,000.00 4,092,200.00 CHARGES FOR SERVICES 1630000-635999) Administration of Justice Circuit Court - Judicial/Administration - $ Circuit Court - Civil/Criminal 2,596,000.00 Circuit Court - Family Division 1,947,000.00 District Court- Division I (Novi) 4,092,200.00 District Court - Division II (Clarkston) 1,587,200.00 District Court- Division III (Rochester Hills) 3,575,400.00 District Court - Division IV (Troy) 2,201,850.00 - $ 2,746,700.00 1,947,000.00 4,012,200.00 1,837,200 00 3,725,400.00 2,251,850.00 0.00% 0.00% 0.00% (80,000.00) -1.95% Unfav. Probation Fees ($150,000) due to a reduction in caseload; partially offset by Fay. State Law Costs $70,000 due to an increase in State violation caseload. 250,000.00 15.75% Fay. State Law Costs $200,000 and Ordinance Fines and Costs $50,000 due to an increase in caseload and continued collection efforts. 150,000.00 4.20% Fay. Ordinance Fines and Costs based on collection efforts. 50,000.00 2.27% Fay. Ordinance Fines and Costs $60,000 due to collection efforts and Refund Fees PD Def Attorney $50,000 due to an increase in public defender requests partially offset by unfav. Probation Fees ($60,000) due to probationer's inability to pay monthly Probationary Oversight Expense. 1,587,200.00 3,575,400.00 2,201,850.00 Probate Court - Estates and Mental Health Total Administration of Justice 507,600.00 507,600.00 507,600.00 17,027,950.00 $ 0.00% 16,507,250.00 $ 16,657,950.00 $ 370,000.00 2.22% 2 of 13552016 COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2016 FIRST QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Law Enforcement Prosecuting Attorney 287,000.00 $ 326,800.00 289,100.00 $ (37,700.00) -11.54% Unfav largely from Reimbursement General ($31,900) due to less than anticipated activity for Freedom Of Information Act (FOIA) and recovery of prosecution revenues. Sheriff's Office 1,900.00 1,900.00 1,100,00 (800.00) -42.11% Unfavorable DNA Testing Fees of ($700); and Subpoena Fees of ($400); partially offset by fay. Reimbursement General $300. Sheriff - Administrative Services 357,100.00 357,100.00 451,500.00 94,400.00 26.44% Fav. increased Fingerprints of $69,500 due to new teachers required to be fingerprinted; Photostats of $45,000 due to increased requests for copies of records and reports and Fee Income of $4,000 from Jail/Records collections for indigent commissary items ordered by inmates; partially offset by unfavorable Registration Fees of ($19,200) from Sex Offender Registry fee required by state and Reimbursement Postage of ($4,900) resulting from Employee Suggestion savings from mailing inmate belongings to their residence. Sheriff - Corrective Services Sheriff - Corrective Services Satellites 3,113,266.00 3,113,266.00 2,917,666.00 (195,600.00) -6.28% Unfav. largely due to reduced receipts of Diverted Felon revenue of ($75,000) due to lower number of inmates with certain offenses that are billable to the State; Fee Income of ($21,500) for Commissary goods collections from inmates accounts; Hospital Cost Recovery ($3,000) from inmates with ability to pay and Miscellaneous of ($7,000) due to less than anticipated activity; Reimbursement Salaries of ($101,300), and OUIL Third Offense of ($14,000) which is a court driven assessment. Partially offset by favorable Inmate Board and Care of $25,000 from inmates with ability to pay and Participation Fees of $1,200. 577,790.00 577,790.00 552,990.00 (24,800.00) -4.29% Unfav. Board and Care receipts of ($58,700) from inmates with ability to pay; partially offset by favorable Reimbursement Court Services of $33,900 for Court Security to non 52nd District Courts who contract with the Sheriff's Office for security. 3 of 13562016 COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2016 FIRST QUARTER REPORT AMOUNT FAVORABLE (UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES (159,700.00) -7.04% Unfav, receipts of Civil Action Service Fees of ($164,000) due to the decline in the number of foreclosures, and civil service requests (see corresponding favorability in Fees Civil Service expenditures); Dispatch Services receipts of ($0). Partially offset by favorable Reimbursement of Salaries of $4,000 and Reimbursement General of $300 all related to level of billable activity. 56,600.00 0.12% Favorable Reimbursement Salaries of $42,300; Fee Income of $8,000; Liquor Control Sheriff of $5,000; Wrecker Service of $2,000 due to higher than expected activity. 135,500.00 12.91% Fay, largely due to Drug Testing of $160,000 collected from inmates with ability to pay; Reimbursement Salaries $55,000; Confiscated Property $19,500; Miscellaneous $5,000 due to higher than anticipated activity; partiedy offset by unfav Refund Forensic Lab Fees of ($50,000); Forensic Lab Fees of ($44,000) due to the timing in start-up of the DNA Laboratory. Sheriff- Emergency Response and Preparedness Sheriff - Patrol Services Sheriff- Investigative Forensic Services Total Law Enforcement ADOPTED AMENDED FY 2016 BUDGET BUDGET FORECAST 2,269,741.00 2,269,741.00 2,110,041.00 48,088,619.00 48,935,989.00 48,992,589.00 1,049,499.00 1,049,499.00 1,184,999.00 55,744,915.00 $ 56,632,085,00 $ 56,499,985.00 $ (132,100.00) -0.23% General Government Clerk - County Clerk Clerk - Elections 2,237,500.00 $ 137,700.00 2,237,600.00 $ 137,700.00 2,365,300.00 $ 151,900.00 127,700.00 5.71% Fay. E-Filing Fees $97,000 and Photographs $7,500 due to extension of pilot project; awaiting legislation approval of new E-filing system. In addition, Jury Fees $25,000 and CVR County Portion $15,000 due to increased activity. Partially offset by unfavorable Notary Commission ($12,000) and Motion Fees ($5,000) due to less than anticipated activity. 14,200.00 10.31% Fay. Board of Canvassers $8,000 and Passport Fees $4,200 due to increased activity. In addition, Election Filing Fees Late $2,000 due to Corporation Counsel efforts to collect on late filers. A budget amendment for Board of Canvassers is recommended to realign budget to reflect actual activity. 4 of 13572016 COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2016 FIRST QUARTER REPORT AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 1,769,500.00 18.680/n Fay. Land Transfer Tax $2,000,000 and Tract Index $8,000 due to increased activity. Partially offset by unfavorable Enhanced Access Fee ($175,000), Deeds ($50,000) and Reimb General ($12,500) due to reduced activity, 70,000.00 1.39% Fay. Administration Fees $70,000 and Deeds $20,000 due to increase in activity. Partially offset by Unfav. Maintenance Contracts ($20,000) due to less than anticipated use. 0.00% (300.00) -2.14% Unfav. Copier Machine Charges ($2,000) and Miscellaneous ($1,300) lower usage due to on-line functionality and &mailing documents. Offset by favorable Reirnb Salaries $3,000 due to State Aid to Public Libraries. 40,000.00 2.18% Fav - Reimbursement General $20,000 a result of Drain Administration able to allocate more time than anticipated to special revenue and proprietary funds. Fay - Soil Erosion Fees $20,000 increase in building activity/permits due to improvement in the housing market. 2,021,100,00 10.78% 0.00% 26,000.00 0.80% Fay. Reimbursement Equalization Services $26,000 due to a FY 2016 contract rate increase of 3% partially offset by a reduction in the number of personal property contracts. 0.00% 5,000.00 1.56% Fay. Standard Mail $5,000 due to new school district customers working with Oakland Schools. Clerk - Register of Deeds & Micrographics Treasurer Board of Commissioners Library Board Water Resources Commissioner Total General Government County Executive County Exec - Compliance Office M&B - Equalization Division M&B - Fiscal Services Division Central Services - Support Services ADOPTED BUDGET 9,472,500.00 5,032,300.00 12,500.00 14,000.00 1,837,226.00 18,743,826.00 $ 230,000.00 $ 3,233,968.00 505,600.00 320,000.00 AMENDED BUDGET 9,472,500.00 5,032,300.00 12,500.00 14,000.00 1,837,226.00 18,743,826.00 $ 230,000.00 $ 3,233,968.00 505,600.00 320,000.00 FY 2016 FORECAST 11,242,000.00 5,102,300.00 12,500.00 13,700.00 1,877,226.00 20,764,926,00 $ 230,000.00 3,259,968.00 505,600.00 325,000.00 Human Resources HHS - Administration HHS - Health Division 475.00 3,912,612.00 475.00 3,912,612.00 475.00 4,092,612.00 180,000.00 0.00% 0.00% 4.60% Fay. Immunizations 5150,000 due to higher costs to purchase vaccines. Fay. Pneumc Vax 3rd Party $100,000 due to higher costs to purchase vaccines along with revenues obtained from certain pneumo vaccine previously not covered. Fay. Permits 525,000 due to increased demand. Partially offset by unfav. Diff Between Ghg and lnit Pay ($95,000) due to the difference between insurance billing and reimbursements. 5 of 13582016 Total County Executive Non-Departmental Non-Dept - Charges for Services Total Non-Departmental 12,945,271.00 $ 716.812.00 $ 716,512.00 $ 12,945,271,00 $ 716,812.00 716,812.00 $ 13,496,231.00 $ 716,812.00 716,812.00 $ 550,960.00 4.26% 0.00% 0.00% COUNTY OF OAKLAND GENERAL FUND! GENERAL PURPOSE REVENUES FY 2016 FIRST QUARTER REPORT AMOUNT FAVORABLE fUNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 300,000.00 10.47% Fav. Out County Board and Care $200,000 due to an increase in out of County OHS wards. Fav. Board and Care $100,000 due to an increase in Oakland County OHS wards. ADOPTED AMENDED FY 2016 BUDGET BUDGET FORECAST HHS - Children's Village 2,865,000.00 2,865,000,00 3,165,000.00 HHS - Homeland Security Public Services - Community Corrections Public Services - MSU Extension Public Services - Medical Examiner 0.00% 215,000.00 215,000.00 190,000.00 (25,000.00) -11.63% Unfav. - Fee Income ($25,000) due to less than anticipated referrals from judges to the Weekend and Weekday Alternative for Misdemeanants (WWAM) Program. 21,000.00 21,000.00 21,000.00 0.00% 308,000.00 308,000.00 308,000.00 0.00% Public Services - Animal Control 913,200,00 913,200.00 913,200.00 0.00% Public Services - Circuit Court Probation Economic Dev. & Comm. Affairs - Admin Economic Dev. & Comm, Affairs - PEDS 24,000.00 395,416.00 24,000.00 396,416.00 24,000,00 461,376.00 0.00% 0.00% 64,960.00 16.39% Fav. due to Economic Outlook, Medical Main Street and Detroit Chamber of Commerce reimbursement for economic development events between Oakland County and local Communities. Total Charges for Services 104,658,074.00 $ 105,695,944.00 $ 108,505,904.00 $ 2,809,960.00 2.66% INDIRECT COST RECOVERY (640100) 7,900,000.00 $ 7,900,000.00 $ 7,900,000.00 $ 0.00% INVESTMENT INCOME (655000-655999) District Courts (Div. I - IV) Sheriff Corrective Services Sheriff Investigative/Technical Services Treasurer Clerk/Register of Deeds Economic Development Non-Departmental 2,400.00 $ 100,000.00 2,500.00 1,800,000.00 2,400.00 $ 100,000.00 2,500.00 1,800,000.00 2,400.00 $ 100,000.00 10,744.00 1,800,000.00 8,244.00 0.00% 0.00% 0.00% 0,00% 329.76% Fav. due to investment base and market rates adjustment. 0.00% 0,00% 6 of 13592016 COUNTY OF OAKLAND GENERAL FUND I GENERAL PURPOSE REVENUES FY 2016 FIRST QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE), PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Total Investment Income 1,904,900.00 $ 1,904,900.00 $ 1,913,144.00 $ 8,244.00 0.43% OTHER REVENUES (670000.6955001 Circuit Court-Donations 18,940.00 $ Circuit Court-County Auction District Court Probate Court Prosecuting Attorney Sheriff Office 5,000.00 5,000.00 Sheriff- Administrative Services Sheriff - Corrective Services Sheriff - Corrective Services-Satellites Sheriff - Emergency Prep and Communications Sheriff - Patrol Services 6,000.00 6,000.00 Sheriff - Investigative/Forensic Svc Clerk/Register of Deeds Treasurer Board of Commissioners Library Board Water Resources Commissioner Management and Budget - Fiscal Services Human Resources Central Services - Support Services 300.00 300.00 Facilities Management Engineering Health Division Children's Village Homeland Security Public Services - Community Corrections Public Services - Animal Control-Other Revenues Public Services - Anirnal Control-Transfers In 44,263.00 Economic Development & Comm Affairs Economic Development - Contributions 44,240.00 Non Departmental - Donations Non-Dept - Sundry 417,500,00 Sheriffs Transfers 68,546.00 Treasurers' Transfers 3,419,698.00 Non-Departmental - Transfers In 10,800,000.00 Total Other Revenues 14,805,547.00 $ 14,824,487.00 44,263.00 44,240.00 417,500.00 68,546.00 3,419,698.00 10,800,000.00 14,847,194.00 $ 22,707.00 18,940.00 $ 107.00 107.00 7,700.00 2,700.00 6,000.00 19,200.00 19,200.00 400.00 600.00 400.00 300,00 0.00% 100.00% 0.00% 0.00% 0.00% 54.00% Fay. Enhancement Funds of $2,700 transferred from Restricted Funds to purchase law enforcement tactical equipment 0.00% 0.00% 0.00% 0.00% 0.00% 100.00% Refund of Prior Years Expenditures of $19,200 reimbursement of overtime. 0.00% 0.00% 100.00% Fay. contributions due to voluntary donations for elected officials fringe benefits. 0.00% 0.00% 0.00% 0.00% 100.00% Fay. County Auction $300 due to greater than anticipated sales of auction items. 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.15% 44,263.00 44,240.00 417,500.00 68,546.00 3,419,698.00 10,800,000.00 7 of 13602016 COUNTY OF OAKLAND GENERAL FUND / GENERAL PURPOSE REVENUES FY 2016 FIRST QUARTER REPORT AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES PLANNED USE OF FUND BALANCE (665000-665999) Encumbrances and Carry forwards Use of Prior Yrs Fund Balance 29,363,330.00 $ 2,486,925.08 37,031,572.00 39,518,497.08 $ 2,486,925.08 37,031,572.00 39,518,497.08 $ 0.00% 0.00% 0.00% Total Planned Use of Fund Balance 29,363,330.00 $ TOTAL GEN. FUND! GEN. PURPOSE REVENUE $ 430,655,400.00 $ 441,954,461.08 $ 444,058,872.08 $ 2,104,411.00 9.48% 8 of 136412016 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Judicial Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfer Out $ 8,735,410.00 $ 8,735,410.00 $ 110,876.00 485,514.00 361,474.00 409,515.00 18,940.00 $ 9,207,760.00 $ 9,649,379.00 $ 8,735,410.00 $ 485,514.00 409,515,00 18,940.00 9,649,379.00 $ 0.00% - 0.00% - 0.00% - 0.00% 0.00% Business Division Personnel Expenditures Operating Expenditures Internal Support Expenditures Civil / Criminal Division Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 1,670,222.00 77,234.00 153,151.00 -------------- $ 1,900,607.00 $ 1,809,151.00 5,191,431.00 2,353,088.00 0.00% - 0.00% - 0.00% - 0.00% 0.00% - 19.64% - Fav. Defense Attorney Fee payments $700,000, Juror Fees and Mileage $250,000, and Attorney Fees Mediators $70,000 due to a decline in caseload. 0.00% - $ 1,670,222.00 $ 1,670,222.00 $ 77,234.00 77,234.00 153,914.00 153,914.00 $ 1,901,370.00 $ 1,901,370.00 $ $ 1,809,151.00 $ 1,809,151.00 $ 5,194,531.00 4,174,531.00 1,020,000.00 2,414,147.00 2,414,147.00 $ 9,353,670.00 $ 9,417,829.00 $ 8,397,829.00 $ 1,020,000.00 10.83% Family Division/Juvenile Maint. Personnel Expenditures Operating Expenditures $ 11,280,597.00 13,121,945.00 $ 11,357,212.00 $ 11,357,212.00 $ 13,085,654.00 9,845,654.00 3,240,000.00 0.00% - 24.76% - Fay. due to decrease in placements to State Institutions $3,000,000 and Priv Institutions Residential $100,000. Also, Fay. Professional Services $100,000 and Defense Attorney Fee payments $40,000 due to lower than anticipated use. Offset by unfavorable Non-Dept Child Care Subsidy Revenue (50% Reimbursement). Internal Support Expenditures Transfer Out 1,509,440,00 1,511,492.00 1,511,492.00 0.00% 4,977,225.00 4,977,225.00 4,977,225.00 0.00% - $ 30,889,207.00 $ 30,931,583.00 $ 27,691,583.00 $ 3,240,000.00 10.47% 3/4/2016 62 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES CIRCUIT COURT AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 23,495,380.00 $ 23,571,995.00 18,501,486.00 18,842,933.00 4,377,153.00 4,489,068.00 4,977,225.00 4,996,165.00 $ 23,571,995.00 $ 14,582,933.00 4,489,068.00 4,996,165.00 4,260,000.00 0.00% 22.61% 0.00% 0.00% $ 51,351,244.00 $ 51,900,161.00 $ 47,640,161.00 $ 4,260,000.00 8.21% 3/4/2016 63 ADOPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT FY 2016 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES District Court Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Division 1 - Novi Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out Total Division 1 - Novi Division 2 - Clarkston Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 208,504.00 $ 208,504.00 $ 208,504.00 $ 0.00% - 7,300.00 7,300.00 7,300.00 0.00% 1,417.00 1,417.00 1,417.00 0.00% 0.00% $ 217,221.00 $ 217,221.00 $ 217,221.00 $ 0.00% $ 4,148,048.00 $ 4,148,048.00 $ 4,073,048.00 $ 75,000.00 1.81% - lay, due to turnover and underfilled positions/vacancies. 901,941.00 901,941.00 901,941.00 0.00% 355,264.00 377,982.00 367,982.00 10,000.00 2.66% - Fav. Info Tech Operations due to lower than anticipated use. 0.00% - $ 5,405,253.00 $ 5,427,971.00 $ 5,342,971.00 $ 85,000.00 1.57% $ 2,044,989.00 $ 2,044,989.00 $ 2,004,989.00 $ 40,000.00 1.96% - Fay, due to turnover and underfilled positions/vacancies. 637,162.00 637,162.00 597,162.00 40,000.00 6.28% - Fay. Defense Attorney Fees $20,000 due to restructured schedule for defense attorneys. Also Fav. Software Support Maintenance $10,000, Electrical Service $5,000 and Printing $5,000 due to lower than anticipated use. 193,996.00 201,909.00 196,909.00 5,000.00 2.48% - Fav. Info Tech Operations due to lower than anticipated use. 0.00% - Total Division 2- Clarkston $ 2,876,147.00 $ 2,884,060.00 $ 2,799,060.00 $ 85,000.00 2.95% 90,000.00 2.33% - Fav. due to turnover and underfilled positions/vacancies. 55,000.00 13.17% - Fay. Defense Attorney Fees $20,000 due to a decrease in requests for appointed counsel. Also Fay. Juror Fees and Mileage $15,000, Office Supplies $5,000, Software Support Maintenance $5,000, Travel and Conference $5,000 and Printing $5,000 due to effort to keep costs down. 10,000.00 1.26% - Fay. Info Tech Operations $10,000 due to lower than anticipated use. Division 3 - Rochester Hills Personnel Expenditures $ 3,862,364.00 $ 3,862,364.00 $ 3,772,364.00 $ Operating Expenditures 417,483.00 417,483.00 362,483.00 Internal Support Expenditures 790,968.00 795,286.00 785,286.00 Transfers Out 0.00% $ 5,070,815.00 $ 5,075,133.00 $ 4,920,133.00 $ 155,000.00 3.05% 642016 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES DISTRICT COURT AMOUNT FY 2016 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ADOPTED AMENDED BUDGET BUDGET Division 4- Troy Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 2,256,306.00 $ 2,256,306.00 $ 2,226,306.00 $ 30,000.00 479,207.00 479,207.00 494,207.00 (15,000.00) 1.33% - Fay. due to turnover and underilled positions/vacancies. -3.13% - Unfav. Defense Attorney Fees ($20,000) due to an increase in requests for appointed counsel. In addition, Unfav. Interpreter Fees ($5,000) due to higher than anticipated use; partially offset by Fay. Software Support Maintenance $5,000 and Electrical Service $5,000 due to lower than anticipated use. 4.04% - Fay, Info Tech Operations due to lower than anticipated use. 245,994.00 247,568.00 237,568.00 10,000.00 $ 2,981,507,00 $ 2,983,081.00 $ 2,958,081.00 $ 25,000.00 0.84% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 12,520,211.00 $ 12,520,211.00 $ 12,285,211.00 $ 2,443,093.00 2,443,093.00 2,363,093,00 1,587,639.00 1,624,162.00 1,589,162.00 235,000.00 80,000.00 35,000.00 1.88% 3.27% 2.15% $ 16,550,943.00 $ 16,587,466.00 $ 16,237,466.00 $ 350,000.00 2.11% 652016 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES PROBATE COURT AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Judicial/Administration Personnel Expenditures $ 2,379,191,00 $ 2,379,191.00 $ 2,379,191.00 $ 0.00% Operating Expenditures 29,481.00 29,481.00 21,481.00 8,000.00 27.14% Fav. Library Continuations $4,000 due to efforts to reduce spending and fay. Visiting Judges $4,000 due to the Court limiting the use of visiting judges. Internal Support Expenditures 286,072.00 286,603.00 286,603.00 0.00% Transfer Out $ 2,694,744.00 $ 2,695,275.00 $ 2,687,275.00 $ 8,000.00 0.30% Estates/Mental Health Personnel Expenditures $ 2,154,153.00 $ 2,154,153.00 $ 2,104,153.00 $ 50,000.00 2.32% Fay. due to turnover and underfilied positions/vacancies. Operating Expenditures 769,943.00 771,976.29 779,976.29 (8,000.00) -1.04% Unfav. Defense Attorney Fees ($8,000) due to a increased number of case filings and continued high demand for these services. Internal Support Expenditures 614,840.00 629,587.00 629,587.00 0.00% $ 3,538,936.00 $ 3,555,716.29 $ 3,513,716.29 $ 42,000.00 1.18% Department Total Personnel Expenditures $ 4,533,344.00 $ 4,533,344,00 $ 4,483,344.00 $ 50,000.00 1.10% Operating Expenditures 799,424.00 801,457.29 801,457.29 - 0.00% Internal Support Expenditures 900,912.00 916,190.00 916,190.00 - 0.00% Transfer Out - - - $ 6,233,680.00 $ 6,250,991.29 $ 6,200,991.29 $ 50,000.00 0.80% 3/4/2016 66 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 2,216,777.00 $ 2,216,777.00 $ 2,153,577.00 $ 63,200.00 2.85% Favorable due largely to a number of underfilled positions and personnel working across divisional disciplines as assigned. Operating Expenditures Internal Support Expenditures Transfers 515,213.00 516,438.27 490,638.27 1,855,987.00 1,866,946.00 1,866,946.00 67,000.00 67,000.00 25,800.00 5.00% Favorable Witness Fees and Mileage $10,000, Travel & Conference $10,000, Printing $10,000, Training $6,000 and Professional Services $5,000 due to less than anticipated use. Partially offset by Unfavorable Extradition Expense ($5,200), Transcript on Appeals ($5,000) and Expert Witness Fee & Mileage ($4,000) due to increased activity. 0.00% 0.00% Litigation Personnel Expenditures $ 4,587,977.00 $ 4,667,161.27 $ 4,578,16127 $ 89,000.00 $ 9,918,192.00 $ 9,918,192.00 $ 9,465,892.00 $ 452,300.00 1.91% 4.56% Favorable due largely to a number of underfilled positions and positions assigned to this division but actually working across divisional disciplines. Operating Expenditures 33,296.00 33,296.00 33,296.00 0.00% Internal Support Expenditures - - - 0.00% 3/4/2016 67 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Transfers Out 926,544.00 926,544.00 926,544.00 0.00% Warrants Personnel Expenditures Operating Expenditures Internal Support Expenditures Appellate Personnel Expenditures Operating Expenditures Internal Support Expenditures $ 10,878,032.00 $ 10,878,032.00 $ 10,425,732.00 $ 452,300.00 $ 2,246,061.00 $ 2,246,061.00 $ 2,139,061.00 $ 107,000.00 3,199.00 3,199.00 3,199.00 $ 2,249,260.00 $ 2,249,260.00 $ 2,142,260.00 $ 107,000.00 $ 1,850,140.00 $ 1,850,140.00 $ 1,818,240.00 $ 31,900.00 $ 1,858,598.00 $ 1,858,598.00 $ 1,821,498.00 $ 37,100.00 4.16% 4.76% Favorable due largely to a number of underfilled positions and positions assigned to this division but actually working across divisional disciplines, 0.00% 0.00% 4.76% 1.72% Favorable due largely to a number of underfilled positions and positions assigned to this division but actually working across divisional disciplines. 8,458.00 8,458.00 3,258.00 5,200.00 61.48% Favorable due to less than anticipated use in Personal Mileage $5,200; partially offset in other divisions. 0,00% 2.00% Department Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 16,231,170.00 560,166.00 1,855,987.00 926,544.00 $ 16,231,170.00 561,391.27 1,866,946.00 993,544.00 $ 15,576,770.00 $ 654,400.00 530,391.27 31,000.00 1,866,946,00 993,544.00 4.03% 5,52% 0.00% 0.00% $ 19,573,867.00 $ 19,653,051.27 $ 18,967,651.27 $ 685,400,00 3.49% 3/4/2016 68 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES SHERIFFS OFFICE AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Sheriffs Office Personnel Expenditures $ 1,721,501,00 $ 1,721,501.00 $ 1,714,201.00 $ 7,300.00 0.42% Favorable Overtime of $13,300 partially offset by unfavorable Salaries of ($6,000) due to turnover. Operating Expenditures 75,736.00 75,736.00 64,736.00 11,000.00 14.52% Favorable Contracted Services of $11,000 and Office Supplies of $9,000; partially offset by unfavorable Communications of ($5,000) for reimbursement of cell phone use and Library Continuations of ($4,000) due to cost of professional, technical and legislative documentation updates. Internal Support Expenditures 409,714.00 409,714.00 409,714.00 0.00% Transfers Out 0.00% $ 2,206,951.00 $ 2,206,951,00 $ 2,188,651.00 $ 18,300.00 0.83% Administrative Services Personnel Expenditures $ 2,130,252.00 $ 2,130,252.00 $ 2,121,052.00 9,200.00 0.43% Favorable projected overtime. Operating Expenditures 1,692,738.00 1,696,897A0 1,696,897.40 0.00% Internal Support Expenditures 167,439.00 167,439.00 167,439.00 0.00% Transfers Out 0.00% Corrective Services Personnel Expenditures $ 3,990,429.00 $ 3,994,588.40 $ 3,985,388.40 $ 30,398,810.00 $ 30,398,810.00 $ 31,409,310.00 9,200.00 0.23% (1,010,500.00) -3.32% Unfavorable Overtime usage of ($2,324,400) largely to cover vacant positions, deputies on short-term leave and Academy Training. Partially offset by favorable salary expense of $1,313,900 due to the large number of vacancies and deputies on short term disability or worker's compensation. Hiring, training and filling-in for deputies on disability is the major factor contributing to the high use of overtime. The Sheriff projects that vacancies and overtime usage levels will continue at the same level as last year. Operating Expenditures 8,211,531.00 8,228,859.42 6,793,059.42 1,435,800.00 17.45% Favorable largely in Contracted Services of $1,283,700 related to savings in the Jail Food and Jail Clinic contracts. Also, favorable Laundry and Cleaning $19,000, Prisoner Housing Outside of County of $90,500 Transportation of Prisoners $18,500, Drug Testing of $10,000 and Personal Mileage of $1,100; Groceries $9,000; Provisions $9,000, all based on actual and historical usage. Partially offset by unfavorable Interpreter Fees of ($5,000) Internal Support Expenditures 7,674,853.00 7,808,749.00 7,782,049.00 26,700.00 0.34% Favorable Info. Tech. Operations $26,700 this is offset by unfavorable charges in other divisions of the Sheriffs Office. Transfers Out 0.00% $ 46,285,194.00 $ 46,436,418.42 $ 45,984,418.42 $ 452,000.00 0.97% 3/4/2016 69 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES SHERIFFS OFFICE AMOUNT FY 2016 FAVORABLE ADOPTED BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES ..y.......•n•n•••••n•••n Corrective Services-Satellites Personnel Expenditures $ 12,746,915.00 $ 12,868,510.00 $ 13,845,010.00 $ (976,500.00) -7.59% Unfavorable due to increased usage of overtime at the Corrective Services Satellite facilities ($1,390,200) caused by Hospital Watch, vacant positions, prisoner transport, employee disability and other leaves, security at Animal Control and East Annex. Partially offset by favorable regular salaries of $413,700. Hiring, training and retaining Corrections Deputies and filling-in for deputies out on disability has been a major factor contributing to the high use of overtime. Operating Expenditures 130,100.00 132,682.00 124,182.00 8,500.00 6.41% Favorable Laundry and Cleaning $14,500; partially offset by unfavorable Travel Employee Taxable Meals of ($6,000). Internal Support Expenditures 1,121,323.00 1,123,258.00 1,123,558.00 (300.00) -0.03% Unfavorable Info. Info. Tech. Managed Print Svc. ($300). Transfers Out 0.00% $ 13,998,338.00 $ 14,124,450.00 $ 15,092,750.00 $ (968,300.00) -6.86% Emergency Response and Preparedness Personnel Expenditures $ 8,096,591.00 $ 8,265,972.00 $ 8,572,172.00 $ (306,200.00) -3.70% Unfavorable Overtime of ($417,500) due to vacant positions partially offset by favorable salaries of $111,300 due to turnover including two vacancies in Dispatch. Operating Expenditures Internal Support Expenditures Transfers Out 896,672.00 149,800.00 896,672.00 149,800.00 835,772.00 176,200.00 60,900.00 6.79% Favorable Fees Civil Services expense of $114,000 due to the continuing decline in the number of home foreclosures and civil service requests (see corresponding unfavorability in Civil Action Service Fee revenues), Employee Medical Exams of $19,800 is impacted by lower number of new employee hires. Partially offset by unfavorable Officer Training of ($43,000), Equipment Maintenance ($19,700), Personal Mileage ($1,200), Office Supplies ($9,000); all based on usage. (26,400.00) -17.62% Unfavorable Info. Tech. Operations ($25,300), and Radio Communications ($1,100), due to usage and is offset in other divisions. 0.00% $ 9,143,063.00 $ 9,312,444.00 $ 9,584,144.00 $ (271,700.00) -2.92% 3/4/2016 70 AMENDED BUDGET COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES SHERIFF'S OFFICE AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Patrol Services Personnel Expenditures $47,408,139 $ 48,052,919.00 $ 47,805,919.00 $ 247,000.00 0.51% Favorable salaries of $338,700 due to turnover and vacancies. Partially offset by unfavorable Overtime of ($91,700). Operating Expenditures 921,399.00 1,790,783.00 1,755,583.00 35,200.00 1.97% Favorable Gas Oil and Grease $35,200. Internal Support Expenditures 5,424,690.00 5,560,382.00 5,560,382.00 0.00% Transfers Out 335,083.00 335,083.00 0.00% $ 53,754,228.00 $ 55,739,167.00 $ 55,456,967.00 $ 282,200.00 0.51% Investigative/Forensic Svcs Personnel Expenditures $ 8,568,514.00 $ 8,568,514.00 $ 8,624,014.00 $ (55,500.00) -0.65% Unfavorable overtime of ($127,000), partially offset by favorable salaries of $71,500 largely due to turnover. Operating Expenditures 808,133.00 808,133.00 808,133.00 0.00% Internal Support Expenditures 2,280,704.00 2,332,260.00 2,332,260.00 0.00% Transfers Out 334,086.00 605,271.00 605,271.00 0.00% $ 11,991,437.00 $ 12,314,178.00 $ 12,369,678.00 $ (55,500.00) -0.45% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 111,070,722.00 $ 112,006,478.00 12,736,309.00 13,629,762.82 17,228,523.00 17,551,602.00 334,086.00 940,354.00 $ 114,091,678.00 $ 12,078,362.82 17,551,602.00 940,354.00 (2,085,200,00) 1,551,400.00 -1.86% 11.38% 0.00% 0.00% $ 141,369,640.00 $ 144,128,196.82 $ 144,661,996.82 $ (533,800.00) -0.37% 3/4/2016 71 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 775,273.00 $ 775,273,00 $ 708,073.00 $ 67,200.00 8.67% Fay. due to vacant position. Operating Expenditures 34,900.00 34,900,00 34,900.00 - 0.00% Internal Support Expenditures 64,356.00 65,505.00 65,505.00 Transfers Out $ 874,529.00 $ 875,678.00 $ 808,478.00 $ 67,200.00 0.00% 0.00% 7.67% County Clerk (Vital Stets & Legal Rees) Personnel Expenditures $ 3,512,165.00 $ 3,517,459.00 $ 3,242,459.00 $ 275,000.00 7.82% Fav. due to turnover, underfilled, vacant and part-time positions. Operating Expenditures 280,921.00 277,259.00 196,559.00 80,700.00 29.11% Fav. Court Transcripts $35,000 due to prosecutors ordering fewer transcripts; Professional Services $34,800, Office Supplies $20,500, Personal Mileage $4,000, Travel & Conference $3,000 due to less than anticipated use. Partially offset by unfavorable Printing ($7,000) and Metered Postage ($6,100) due to increased activity; Charge Card Fee ($2,000) due to new security laws mandating the update of credit card readers. Internal Support Expenditures 623,487.00 728,163.00 728,163.00 0.00% Transfers Out 0.00% ----------- _-_-_-_-_-_-_-____ -_-_-__________ -----,-------- $ 4,416,573.00 $ 4,522,681.00 $ 4,167,181.00 $ 355,700.00 7.86% 3/4/2016 72 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Elections Personnel Expenditures $ 850,957.00 $ 850,957.00 $ 759,657.00 $ 91,300.00 10.73% Fay. due to vacant and underfilled positions. Operating Expenditures 779,078.00 779,078.00 763,478.00 15,600.00 2.00% Fay. Primarily due to less than anticipated use in Fees - Per Diem for the Board of Canvassers $16,300. Internal Support Expenditures 300,198.00 302,268.00 302,268.00 0.00% Transfers Out 0.00% $ 1,930,233.00 $ 1,932,303.00 $ 1,825,403.00 $ 106,900.00 5.53% Register of Deeds (and Micrographics) Personnel Expenditures $ 2,541,907.00 $ 2,541,907.00 $ 2,393,107.00 $ 148,800.00 Operating Expenditures 265,494.00 265,494.00 $ 219,194.00 46,300.00 5.85% Fay. due to underfilled, part-time and vacant positions. 17.44% Fay. Metered Postage $20,000, Professional Services $20,000, Office Supplies $17,300 and Travel and Conference $1,000 due to less than anticipated use. Partially offset by unfavorable Maintenance Contract ($7,000) and Material and Supplies ($5,000) due to increased activity. Internal Support Expenditures 249,980.00 249,980.00 $ 249,980.00 0.00% Transfers Out 0.00% $ 3,057,381.00 $ 3,057,381.00 $ 2,862,281.00 $ 195,100.00 6.38% Jury Commission Personnel Expenditures $ 18,051.00 $ 18,051.00 $ 10,551.00 $ 7,500.00 41.55% Fav. due to recently vacated PTNE position. Operating Expenditures 68,776.00 68,776.00 60,476.00 8,300.00 12.07% Fay. Metered Postage $8,500 due to less than anticipated use. Partially offset by unfavorable Fees Per Diem ($200) due to increased activity. Internal Support Expenditures 34,277.00 34,277.00 34,277.00 0.00% ----------------------------- ---------------- ------------------ $ 121,104.00 $ 121,104.00 $ 105,304.00 $ 15,800.00 13.05% Department Total 3/4/2016 73 ADOPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT FY 2016 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Personnel Expenditures $ 7,698,353.00 $ 7,703,647.00 $ 7,113,847.00 $ 589,800.00 Operating Expenditures 1,429,169.00 1,425,507.00 1,274,607.00 $ 150,900.00 Internal Support Expenditures 1,272,298.00 1,380,193.00 1,380,193.00 $ Transfers Out - --------------- --- $ 10,399,820.00 $ 10,509,347.00 $ 9,768,647.00 $ 740,700.00 7.66% 10.59% 0.00% 0.00% 7.05% 3/4/2016 74 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES COUNTY TREASURER AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 3,335,018.00 $ 3,335,018.00 $ 3,128,308.00 $ 206,710.00 6.20% - Fav. due to under-filled positions. Operating Expenditures 4,512,105.00 4,561,305.00 4,717,305.00 (156,000.00) -3.42% Unfav. Contracted Services ($165,000) due to increased maintenance activity on delinquent tax foreclosed properties. Partially offset by favorable, Twp & City Treas Bonds $9,000 due to less than anticipated use. In addition, a budget amendment is recommended to reallocate a Canyforward request that was included in the Fiscal 2015 Year End report for the purchase of debt management software; $49,200 from Title Search to Software Rental Lease Purchase. Internal Support Expenditures 684,153.00 816,583.00 816,583.00 0.00% - Transfers Out 120,000.00 120,000.00 120,000.00 0.00% Division Total $ 8,651,276.00 $ 8,832,906.00 $ 8,782,196.00 $ 50,710.00 0,57% Department Total $ 8,651,276.00 $ 8,832,906,00 $ 8,782,196.00 $ 50,710.00 0.57% 3/4/2016 75 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES BOARD OF COMMISSIONERS AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 2,151,427.00 $ 2,151,427.00 $ 2,104,727.00 $ 46,700.00 2.17% - Fay. due to turnover and undeifilled positions. Operating Expenditures 475,305.00 475,961.05 $ 469,361.05 6,600.00 1.39% - Fay. Personal Mileage $5,000 due to less than anticipated use and Metered Postage $1,400 due to less activity on mailing committee and board packets to Commissioners. Internal Support Expenditures 197,114.00 198,148.00 $ 198,148.00 0.00% - $ 2,823,846.00 $ 2,825,536.05 $ 2,772,236.05 $ 53,300.00 1.89% Department Total Personnel Expenditures $ 2,151,427.00 $ 2,151,427.00 $ 2,104,727.00 $ 46,700.00 2.17% Operating Expenditures 475,305.00 475,961.05 469,361.05 6,600.00 1.39% Internal Support Expenditures 197,114.00 198,148.00 198,148.00 0.00% $ 2,823,846.00 $ 2,825,536.05 $ 2,772,236.05 $ 53,300.00 1.89% 3/4/2016 76 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES LIBRARY BOARD AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES *r..,n*w • • .••••nerra..,./~rua..4 ......daa.4raa.wraaw aa........worarrawrawrowa warrrroarrrwarra.n..hrmemarrarmwr. Library Board Personnel Expenditures $ 482,345.00 $ 482,345.00 $ 482,345.00 Operating Expenditures 375,347.00 375,347.00 375,347.00 Internal Support Expenditures 457,647.00 460,739.00 460,739.00 Transfers 0.00% 0.00% 0.00% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 1,315,339.00 $ 1,318,431.00 $ 1,318,431.00 $ $ 482,345.00 $ 482,345.00 $ 482,345.00 $ 375,347.00 375,347.00 375,347.00 457,647.00 460,739.00 460,739.00 $ 1,315,339.00 $ 1,318,431.00 $ 1,318,431.00 $ 0.00% 0.00% 0.00% 0.00% 0.00% 3/4/2016 77 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES WATER RESOURCES COMMISSIONER AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Water Resource Commissioner Personnel Expenditures $ 214,965,00 $ 214,965.00 $ 214,965.00 $ 0.00% Operating Expenditures 587,975.00 587,975.00 587,975.00 0.00% Internal Support Expenditures 4,861,734.00 4,908,772.00 4,908,772.00 Transfers 56,165.00 56,165.00 56,165.00 Division Total $ 5,720,839.00 $ 5,767,877.00 $ 5,767,877.00 $ 0.00% 0.00% 0.00% Department Total $ 5,720,839.00 $ 5,767,877.00 $ 5,767,877.00 $ 0.00% 3/4/2016 78 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES COUNTY EXECUTIVE AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 2,177,374.00 $ 2,177,374.00 2,177,374.00 $ 0.00% - Operating Expenditures 277,991.00 277,991.00 277,991.00 0.00% - Internal Support Expenditures 420,395.00 425,613.00 425,613.00 0.00% - $ 2,875,760.00 $ 2,880,978.00 $ 2,880,978.00 $ 0.00% Compliance Office Personnel Expenditures $ 1,600,143.00 $ 1,600,143.00 $ 1,600,143.00 $ 0.00% Operating Expenditures 49,252.00 49,252.00 49,252.00 0.00% Internal Support Expenditures 182,323.00 182,967.00 182,967.00 0.00% $ 1,831,718.00 $ 1,832,362.00 $ 1,832,362.00 $ 0.00% Corporation Counsel Personnel Expenditures $ 2,122,335.00 $ 2,122,335.00 $ 2,122,335.00 $ 0.00% - Operating Expenditures 87,333.00 87,333.00 87,333.00 0.00% - Internal Support Expenditures 199,328.00 209,394.00 209,394.00 0.00% - $ 2,408,996.00 $ 2,419,062.00 $ 2,419,062.00 $ 0.00% Departrrient Total Personnel Expenditures $ 5,899,852.00 $ 5,899,852.00 $ 5,899,852.00 $ 0.00% Operating Expenditures 414,576.00 $ 414,576.00 414,576.00 0.00% Internal Support Expenditures 802,046.00 817,974.00 817,974.00 0.00% Transfers Out $ 7,116,474.00 $ 7,132,402.00 $ 7,132,402.00 $ 0.00% 79 3/4/2016 ADOPTED BUDGET AMENDED BUDGET COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES MANAGEMENT AND BUDGET AMOUNT FY 2016 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 221,486.00 $ 221,486.00 $ 221,486.00 $ 0.00% Operating Expenditures 4,017.00 4,017.00 4,017.00 0.00% Internal Support Expenditures Equalization Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out 14,084.00 14,084.00 14,084.00 - 0.00% ----------- ------------ ----------------------------------- $ 239,587.00 $ 239,587.00 $ 239,587.00 $ 0.00% $ 8,347,443.00 $ 8,347,443.00 $ 7,947,443.00 $ 400,000.00 4.79% Fav. due to vacancies and underfilled positions. 431,404.00 431,404.00 431,404.00 0.00% 905,913.00 1,028,797.00 1,028,797.00 0.00% 0.00% $9,684,760.00 $9,807,644.00 $ 9,407,644.00 $ 400,000.00 4.08% Fiscal Services Personnel Expenditures $ 8,010,091.00 $ 8,010,091.00 $ 7,610,091.00 $ 400,000.00 4.99% Fav. due to vacancies and underlined positions. Operating Expenditures 388,600.00 388,600.00 353,600.00 35,000.00 9.01% Fav. Printing $20,000 due to efforts to reduce spending and Metered Postage $15,000 due to less than anticipated use. Internal Support Expenditures 1,154,941.00 1,234,505.00 1,234,505.00 0.00% $ 9,553,632.00 $ 9,633,196.00 $ 9,198,196.00 $ 435,000.00 4.52% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 16,579,020.00 $ 16,579,020.00 $ 15,779,020.00 $ 824,021.00 824,021.00 789,021.00 2,074,938.00 2,277,386.00 2,277,386.00 800,000.00 35,000.00 4.83% 4.25% 0.00% 0.00% ---_-_-_-_-_-_-- -------------------------- _-_-_-_-_-_-_-_-_-_-_-_-__ -_-_-_-_-_-_-_-_-_-_-_-___ $ 19,477,979.00 $ 19,680,427.00 $ 18,845,427.00 $ 835,000.00 4.24% 80 3/4/2016 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES CENTRAL SERVICES AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST {UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administrative Personnel Expenditures $ 221,405.00 $ 221,405.00 $ 221,405.00 $ 0.00% Operating Expenditures 3,298.00 3,298.00 3,298.00 0.00% Internal Support Expenditures 13,356.00 13,356.00 13,356.00 0.00% Transfers Out $ 238,059.00 $ 238,059.00 $ 238,059.00 $ 0.00% Support Services Personnet Expenditures $ 1,173,985.00 $ 1,173,985.00 $ 1,173,985.00 $ 0.00% Operating Expenditures 411,767.00 411,767.00 411,767.00 0.00% Internal Support Expenditures 720,886.00 727,690.00 $ 727,690.00 0.00% Transfers Out 0.00% 0.00% Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 2,306,638.00 $ 2,313,442.00 $ 2,313,442.00 $ $ 1,395,390,00 $ 1,395,390,00 $ 1,395,390.00 $ 415,065.00 415,065,00 415,065.00 734,242.00 741,046.00 741,046.00 $ 2,544,697,00 5 2,551,501.00 $ 2,551,501.00 $ 0.00% 0.00% 0.00% 0.00% 0.00% 3/4/2016 81 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES FACILITIES MANAGEMENT AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $ 204,652.00 $ 204,652.00 $ 204,652.00 $ 5,764.00 5,764.00 5,764.00 13,805.00 13,805.00 13,805.00 $ 224,221.00 $ 224,221.00 $ 224,221.00 $ $ 806,436.00 $ 806,436.00 $ 806,436.00 $ 327,584.00 327,584.00 327,584.00 56,236.00 56,301.00 56,301.00 $1,190,256.00 $ 1,190,321.00 $ 1,190,321.00 $ Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Facilities Engineering Personnel Expenditures Operating Expenditures Internal Support Expenditures 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Department Total Personnel Expenditures $1,011,088.00 $1,011,088.00 $ 1,011,088.00 $ 0.00% Operating Expenditures 333,348.00 333,348.00 333,348.00 0.00% internal Support Expenditures 70,041.00 70,106.00 70,106.00 0.00% $1,414,477.00 $1,414,542.00 $ 1,414,542.00 $ 0.00% 3/4/2016 82 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES HUMAN RESOURCES AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures 765,824.00 $ 765,824.00 $ 765,824.00 $ 0.00% Operating Expenditures 337,622.00 337,622.00 337,622.00 0.00% Internal Support Expenditures 37,007.00 39,428.00 39,428.00 0.00% Transfers Out 1,140,453.00 $ 1,142,874.00 $ 1,142,574.00 $ 0.00% Workforce Management Personnel Expenditures 1,596,614.00 $ 1,896,614.00 $ 1,896,614.00 $ 0.00% Operating Expenditures 311,740.00 311,740.00 311,740.00 0.00% Internal Support Expenditures 524,059.00 626,412.00 626,412.00 0.00% Transfers Out 2,732,413.00 $ 2,834,766.00 $ 2,834,766.00 $ 0.00% Benefits Administration Personnel Expenditures 5 173,615.00 $ 173,615.00 $ 173,615.00 $ 0.00% Operating Expenditures 13,977.00 13,977.00 13,977.00 0.00% Internal Support Expenditures 162,888.00 162,888.00 162,888.00 0.00% Transfers Out Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out 350,480.00 $ 2,836,053.00 $ 663,339.00 723,954.00 350,480.00 $ 2,836,053.00 $ 663,339.00 828,728.00 350,480.00 $ 2,836,053.00 $ 663,339.00 828,728.00 0.00% 0.00% 0.00% 0.00% 4,223,346.00 $ 4,328,120.00 $ 4,328,120.00 $ 0.00% 832016 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures $ 205,346.00 $ 205,346.00 $ 205,346.00 $ 0.00% Operating Expenditures 8,454,239.00 8,482,365.31 7,207,365.31 1,275,000.00 15.03% Fav. due to Private Institutions Foster Care and Private Institutions $1,250,000. Fay. Foster Boarding Homes $225,000. Unfav. Private Institutions Residential ($200,000). Costs are based on caseload, difficulty of care, and treatment of services ordered by the Court. Favorabiiity is partially offset by unfav. Non-Dept. Child Care Subsidy Revenue (50% reimbursement). Internal Support Expenditures 40,611.00 40,611.00 40,611.00 0.00% Transfers Out $ 8,700,196.00 $ 8,728,322.31 $ 7,453,322.31 $ 1,275,000.00 14.61% Health Personnel Expenditures $ 24,363,859.00 $ 24,363,859.00 $ 22,363,859.00 $ 2,000,000.00 8.21% Fav. due to turnover and under-tilled positions. 3,255,636.00 (315,000.00) 2,713,306.00 Operating Expenditures Internal Support Expenditures Transfers Out 3,269,789.91 3,584,789.91 2,837,874.00 2,995,374.00 -9.63% Unfav. Vaccines ($500,000) due to increased costs and increased demand. Unfav. Personal Mileage ($20,000) due to increased field activities. Unfav. Medical Supplies ($15,000) due to increased activities. Partially offset by fav. Professional Services $200,000 due to difficulties identifying under insurred individuals eligible for the dental program; efforts are planned to target seniors for the program. Fay. Office Supplies $20,000 due to continued efforts to minimize expenses and contain costs. (157,500.00) -5.55% Unfav. info Tech Operations ($150,000) and Radio Communications ($7,500) based on usage. 8,640.00 8,640.00 8,640.00 ------------------- $ 30,341,441.00 $30,480,162.91 $ 28,952,662.91 $ 1,527,500.00 5.01% 842016 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Children's Village Personnel Expenditures $ 16,191,178.00 $ 16,191,178.00 $ 16,191,178.00 $ 0.00% Operating Expenditures 3,693,861.00 3,717,796.79 3,542,796.79 175,000.00 4.71% Fav. Provisions $50,000 due to increased reimbursement for improved nutritional requirements and decrease in resident population. Fav. Drugs $35,000 due to fewer medication needs of resident population along with cost saving initiatives. Fay. Psychological Testing $25,000 due to fluctuating psychological needs of resident population. Fay. Professional Services $20,000 due to the utilization of part-time nursing staff in lieu of contracted nursing staff. Fay. Medical Services Physicians $15,000 due to services provided by Oakland Integrated Healthcare Network (OIHN) a Federally Qualified Health Center. Fav. Custodial Supplies $15,000 due to continued efforts to minimize expenses and contain costs. Fav. Hospitalization $15,000 due to fewer medical emergencies. Internal Support Expenditures 2,625,087.00 2,655,084.00 2,630,084.00 25,000.00 0.94% Fav. Info Tech Operations based on usage. Transfers Out $ 22,510,126.00 $ 22,564,058.79 $ 22,364,058.79 $ 200,000.00 0.89% Homeland Security Personnel Expenditures $ 822,185.00 $ 822,185.00 $ 807,185.00 $ 15,000.00 1.82% Fay. due to turnover. Operating Expenditures 304,519.00 370,627.00 346,627.00 24,000.00 6.48% Fay. Tornado Siren Equip due to the installation of fewer than anticipated sirens. Partially offset by revenue unfavorability (Local Match). Internal Support Expenditures 449,537.00 463,540.54 463,540.54 0.00% Transfers Out $ 1,576,241.00 $ 1,656,352.54 $ 1,617,352.54 $ 39,000.00 852016 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES HEALTH AND HUMAN SERVICES AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out $ 41,582,568.00 $ 41,582,568.00 15,708,255.00 15,840,579.01 5,828,541.00 5,997,109.54 8,640.00 8,640.00 ------------------ ---------------- $ 63,128,004.00 $ 63,428,896.55 $ 39,567,568.00 $ 2,015,000.00 4.85% 14,681,579.01 1,159,000.00 7.32% 6,129,609.54 (132,500.00) -2.21% 8,640.00 0,00% ------------------ $ 60,387,396.55 $ 3,041,500.00 4.80% 862016 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET Forecast (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Veterans Services Personnel Expenditures Public Services - Admin. Personnel Expenditures Operating Expenditures Operating Expenditures Internal Support Expenditures Internal Support Expenditures $ 221,486.00 $ 221,486.00 221,486.00 $ 4,800.00 4,800.00 4,800.00 6,331.00 6,331.00 6,331.00 $ 232,617.00 $ 232,617.00 $ 232,617.00 $ $ 1,579,106.00 $ 1,579,106.00 1,579,106.00 $ 190,912.00 190,912.00 190,912.00 193,357.00 193,932.00 193,932.00 $ 1,963,375.00 $ 1,963,950.00 $ 1,963,950.00 $ 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Community Corrections Personnel Expenditures $ 3,865,604.00 $ 3,865,604.00 3,865,604.00 $ 0.00% Operating Expenditures 502,025.00 502,025.00 502,025.00 0.00% Internal Support Expenditures 537,919.00 559,983.00 559,983.00 0.00% $ 4,905,548.00 $ 4,927,612.00 $ 4,927,612.00 $ 0.00% MSU Ext. - Oakland County Personnel Expenditures $ 678,332.00 $ 678,332.00 $ 678,332.00 $ ••n 0.00% Operating Expenditures 220,689.00 220,689.00 220,689.00 0.00% Internal Support Expenditures 273,656.00 275,246.00 275,246.00 0.00% $ 1,172,677.00 $ 1,174,267,00 $ 1,174,267.00 $ 0.00% N2016 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET Forecast (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Medical Examiner Personnel Expenditures $ 3,359,380.00 $ 3,359,380.00 $ 3,359,380.00 $ 0.00% Operating Expenditures 520,006.00 520,006.00 520,006.00 0.00% Internal Support Expenditures 800,016.00 813,191.00 813,191 00 0.00% $ 4,679,402.00 $ 4,692,577.00 $ 4,692,577.00 $ 0.00% Animal Control Personnel Expenditures $ 2,397,293.00 $ 2,375,329.00 $ 2,375,329.00 $ 0.00% Operating Expenditures 280,097.00 280,097.00 280,097.00 0.00% Internal Support Expenditures 877,137.00 994,023.00 994,023.00 0.00% $ 3,554,527.00 $ 3,649,449.00 $ 3,649,449.00 $ 0,00% Transfers Out Circuit Court Probation Personnel Expenditures 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 54,326.00 550,527.00 604,853.00 $ Operating Expenditures Internal Support Expenditures Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers Out 54,326.00 54,326.00 550,069.00 550,527.00 $ 604,395.00 $ 604,853.00 $ $ 12,101,201.00 $ 12,079,237.00 $ 12,079,237.00 $ 1,772,855.00 1,772,855.00 1,772,855.00 3,238,485.00 3,393,233.00 3,393,233.00 $ 17,112,541.00 $ 17,245,325.00 $ 17,245,325.00 $ 0.00% 2016 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET ACTUAL :UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 1,264,827.00 $ 1,264,827.00 $ 1,251,427.00 $ 13,400.00 358,222.00 358,222.00 342,822.00 15,400.00 55,528.00 71,632.00 70,532.00 1,100.00 1.06% Fay. due to turnover and underfilled positions. 4.30% Fay. Travel $8,100 and Mileage $7,300 due to usage. 1.54% Fay. Info Tech Operations $2,000 and Telephone Communications $900 due to less than anticipated usage. Offset by unfav. Insurance Fund ($1,100) and Motor Pool ($700) based on usage. $ 1,678,577.00 $ 1,694,681.00 $ 1,664,781.00 $ 29,900.00 1.76% Planning and Economic Development Services Personnel Expenditures $ 3,988,767.00 $ 3,988,767.00 $ 3,692,867.00 $ 295,900.00 Operating Expenditures 1,318,895.00 1,453,526.10 1,442,526.10 11,000.00 7.42% 0.76% Fav. due to turnover and underfilled positions. Fay. Printing $35,300, Supplies $21,000 and Mileage $2,600 due to usage. Partially offset by unfav. Advertising ($44,000) for support of business development events and trade mission; Contracted Services ($2,000) due to higher than anticipated to budget and Charge Card Fee ($1,900) for increase of credit card activity. Internal Support Expenditures Transfers 818,628.00 827,626.00 797,226.00 30,400.00 3.67% Fay. Info Tech Operations $21,600, Telephone Communications $5,500 and Info Tech Managed Print Services $3,300 due to less than anticipated usage. $ 6,126,290.00 $ 6,269,919.10 $ 5,932,619.10 $ 337,300.00 5.38% Community and Home Improvement Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT EXPENDITURES ECONOMIC DEVELOPMENT AND COMMUNITY AFFAIRS AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET ACTUAL :UNFAVORABLE PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Workforce Development Personnel Expenditures $ 25,620.00 $ 25,620.00 $ 25,620.00 $ 0.00% Operating Expenditures Internal Support Expenditures ... Department Total Personnel Expenditures Operating Expenditures Internal Support Expenditures Transfers $ 25,620.00 $ 25,620.00 $ 25,620.00 $ - 0.00% $ 5,279,214.00 $ 5,279,214.00 $ 4,969,914.00 $ 309,300.00 5.86% 1,677,117.00 1,811,748.10 1,785,348.10 26,400.00 1.46% 874,156.00 899,258.00 867,758,00 31,500.00 3.50% - - - 0.00% $ 7,830,487,00 $ 7,990,220.10 $ 7,623,020.10 $ 367,200.00 4.60% COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT NON-DEPARTMENTAL EXPENDITURES AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION NON-DEPARTMENT APPROPRIATIONS COUNTY OPERATIONS Insurance Fund Insurance Surety Bonds Logos Trademarks Intellect Property Road CommissionlCurrent Drain Assessment Road Commission \Tri Party Agreement $ 351,802.00 $ 351,802.00 $ 351,802.00 $ 33,305.00 33,305.00 33,305.00 18,000.00 18,000.00 18,000.00 1,450,000.00 1,450,000.00 1,450,000.00 100.00 1,008,718.00 1,008,718.00 0.00% 0.00% 0.00% 0.00% 0.00% Interest Expense 0.00% Provisions 30,000.00 30,000.00 30,000.00 0.00% Transfer to Community Mental Health Authority 9,620,616.00 9,620,616.00 9,620,616.00 0.00% Total $ 11,503,823.00 $ 12,512,441.00 $ 12,512,441.00 $ 0.00% COUNTY BUILDINGS $ 2,936,215.00 $ 2,734,032.00 $ 2,734,032.00 $ 0.00% STATE AND FEDERAL - COUNTY ASSOCIATIONS Michigan Assoc. of Counties $ 73,000.00 $ 73,000.00 $ 73,000.00 $ 0.00% National Assoc. of Counties 24,100.00 24,100.00 24,100.00 0.00% S.E.M.C.O.G. 500,000.00 500,000.00 500,000.00 0.00% Traffic Improvement Association 30,000.00 30,000.00 30,000.00 0.00% Total $ 627,100.00 $ 627,100.00 $ 627,100.00 $ 0.00% SUNDRY EXPENSE $ 300,000.00 $ 300,000.00 $ 300,000.00 $ 0.00% RESERVED FOR TRANSFERS Expenditures Classification and Rate Change Contingency Disaster Recovery Emergency Salaries Grant Match Info Tech Development Legislative Expense Misc. Capital Outlay Overtime Appropriation Security Reserve Substance Abuse Coord Agency Summer Employees Salary Appropriation Total $ 92,428.00 $ 9,768.00 $ 9,768.00 $ 324,840.00 139,757.00 139,757.00 300,000.00 300,000.00 300,000.00 560,000.00 560,000.00 560,000.00 1,089,045.00 600,860,00 600,860.00 5,297,860.00 4,227,099.00 4,227,099.00 8,600.00 8,600.00 8,600.00 250,000.00 250,000.00 250,000.00 53,000.00 53,000.00 53,000.00 2,100,799.00 611,416,00 611,416.00 2,959,452.00 2,959,452.00 2,959,452.00 250,000.00 248,368.00 248,368.00 $ 13,286,014.00 $ 9,968,320.00 $ 9,968,320.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% PAO 1 6 $ 424,512.00 $ 1,844,186.00 3,620,676.00 2,274,375.00 1,500,000.00 5,500,000.00 1,140,764.00 $ 1,844,186,00 3,620,676.00 2,274,375.00 2,887,170.00 5,500,000.00 7,000,000.00 1,140,764.00 $ 1,844,186.00 3,620,676.00 2,274,375.00 2,887,170.00 5,500,000.00 7,000,000.00 0,00% 0.00% 0.00% 0.00% 0,00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% $ 15,163,749.00 $ 24,267,171.00 $ 24,267,171.00 $ COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT NON-DEPARTMENTAL EXPENDITURES AMOUNT ADOPTED AMENDED FY 2016 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION Transfers to Other Funds Fire Records Management CLEMIS Information Technology Bldg Auth Fac Entree IT Debt Fringe Benefit Fund Project Work Order Fund Long Term Revolving Fund Facilities Maintenance and Operations Building Fund BA Animal Ctrl Pet Adopt Debt Domestic Equipment Preparedness TOTAL NON-DEPT. APPROPRIATIONS $ 43,816,901.00 $ 50,409,064.00 $ 50,409,064.00 $ 0.00% TRANSFER TO GENERAL PURPOSE FUNDS Child Care Fund Social Welfare Fund Foster Care TOTAL EXPENDITURES $ 23,595,326,00 $ 23,649,258.79 $ 23,649,258.79 $ 0.00% 1,000.00 1,000.00 1,000.00 0.00% $ 23,596,326.00 $ 23,650,258.79 $ 23,650,258.79 $ 0.00% $ 67,413,227.00 $ 74,059,322.79 $ 74,059,322.79 $ 0.00% FY 2016 BUDGET AMENDMENTS FY 2016 BUDGET AS ADOPTED - GENERAL FUND/GENERAL PURPOSE FUNDS BUDGET AMENDMENTS M.R. - 10/22/2015 Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance) M. R. #15257- Charter Township of West Bloomfield M.R. #15261 - 10/2212015 Circuit Court - 2016 Michigan Drug Court Grant Program (Adult Treatment Court) - Grant Acceptance M.R. #15271 -10/22/2015 Circuit Court -2016 Michigan Drug Court Grant Program (Juvenile Drug Court) - Grant Acceptance M.R. - 11112/2015 Board of Commissioners - Tr-Party Road Improvement Program (Planned Use of Fund Balance) M.R. #15272- City of Walled Lake M.R. #15293 - 12/09/2015 Sheriffs Office - Standard Law Enforcement Services Agreement with the Charter Township of Highland, January 1, 2016 - December 31, 2016 M.R. #15294 - 12/0912015 Sheriffs Office - Standard Law Enforcement Services Agreement with the Charter Township of Independence. January 1. 2016- December 31, 2016 M.R. #15295 - 12/09/2015 Sheriff's Office - Standard Law Enforcement Services Agreement with the Charter Township of Lyon, January 1, 2016 - December 31, 2016 M.R. #15296 - 12/09/2015 Sheriffs Office - Standard Law Enforcement Services Agreement with the Charter Township of Oakland, January 1, 2016- December 31, 2016 M.R. #15297 - 12/0912015 Sheriffs Office - Standard Law Enforcement Services Agreement with the Charter Township of Orion, January 1, 2016- December 31, 2016 M.R. #15299 - 12/09/2015 Sheriffs Office - Standard Law Enforcement Services Agreement with the City of Pontiac, January 1, 2016- December 31, 2016 M.R. #15302 - 12/09/2015 Department of Information Technology - CLEMIS Fire Records Management Program $ 430,655,400.00 15,233.00 18,940.00 36,291.00 27,350.00 24,908.00 $ 109,750.00 $ 215,451.00 $ 190,544.00 95,272,00 $ 211,445.00 5 716,252.00 M.R. #15315 - 12/09/2015 Management & Budget Fiscal Year 2015 Year-End Report and Budget Amendments Encumbrances Carry Forwards Adjustments to Circuit Court Adjust Non-Departmental Revenue $ 153,041.08 $ 2,333,884.00 $ 150,700.00 $ 7,000,000.00 $ 9,637,625.08 TOTAL AMENDED BUDGET AS OF 12/31/2015 $ 441,954,461.08 93 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT ENTERPRISE FUND TREASURER'S OFFICE ADOPTED AMENDED FY 2016 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DELINQUENT TAX REVOLVING FUND 51600 REVENUES Charges for Services $17,000,000.00 $17,000,000.00 $17,000,000.00 $0.00 0.00% Other Revenues 884,000.00 884,000 00 884,000.00 0.00 0.00% Total Revenues $17,884,000.00 $17,884,000.00 $17,884,000.00 $0.00 0.00% 10,800,000.00 1,596,500,00 1,862,400.00 1,328,300.00 $ 19,006,898.00 $ 19,702,040.00 10,800,000.00 1,596,500.00 1,862,400.00 1,328,300.00 $ 19.006.898.00 $ 19,702,040.00 OPERATING EXPENSES Personnel Expenditures Operating Expenditures 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 193,692.00 0.00% 352,400.00 (19,700.00) -5.92% Unfav. Indirect Costs ($19,700) due to actual charges determined after budget finalization. 108,500.00 60,250.00 35.70% Fay. related to lower debt interest rates/level of debt. 3,419,698.00 0.00% 10,800,000.00 0.00% 1,596,500.00 0.00% 1,862,400 00 0.00% 1,328.300.00 0.00% $ 19.006.898.00 0.00% $ 19,661,490.00 $ 40,550.00 0.21% $ 193,692.00 $ 193,692.00 332,700.00 332,700.00 168,750.00 168,750.00 3,419,698.00 3,419,698.00 REVENUE OVER (UNDER) EXPENDITURES" Total Net Assets - Beginning Total Net Assets - Ending ($1,818,040.00) ($1,818,040.00) (81,777,490.00) 8202,820,870.47 $201,043,380.47 $36,383,006.00 159,217,116.45 7,220,748.02 (81,777,490.00) 120,24.47 Ending FY 2015 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 840,550.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 9421316 DELINQUENT PERSONAL PROPERTY TAX (51800) COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT ENTERPRISE FUNDS TREASURER ADOPTED AMENDED FY 2016 VARIANCE BUDGET BUDGET FORECAST FAW(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUE OPERATING EXPENSE $502,300.00 721,261.00 $502,300.00 721,261.00 $502,300.00 449,175.12 $0.00 $272,085.88 0.00% - 37.72% - Fay. Controllable Personnel $42,000 due to part-time position. Also, favorable Indirect Costs $165,100 due to actual charges determined after budget finalization. In addition, favorable Bldg Space Cost Allocation $65,000 due to the actual apportionment of building space between Treasurer Proprietary Fund and Treasurer GF/GP determined after the adopted budge; a budget amendment is recommended. NET OPERATING INCOME (LOSS) ($218,961.00) ($218,961.00) $53,124.88 $272,085.88 -124.26% NON-OPERATING REVENUE (EXPENSE) 1,000.00 1,000.00 1,000.00 $0.00 0.00% TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS ($217,961.00) ($217,961.00) $ 54,124.88 $272,085.88 TRANSFERS OUT TOTAL NET INCOME (LOSS)* ($217961.00) ($217,961.00) $54,124.88 $272,085.88 TOTAL NET POSITION - BEGINNING TOTAL NET POSITION - ENDING 123,170.59 $177,295.47 * Please note that in the Adopted Budget (line-item book) this is budgeted as 'Planned Use of Balance" in the revenue category. 3/4/2016 95 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT ENTERPRISE FUND PARKS & RECREATION ADOPTED BUDGET AMENDED BUDGET FY 2016 FORECAST VARIANCE FAVAUNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OAKLAND COUNTY PARKS & RECREATION COMMISSION (50800) OPERATING REVENUE $ 9,272,581.00 $ 9,272,581.00 $ 9,272,581.00 $ 0.00% 0.00% 0.00% 0.00% 0.00% OPERATING EXPENSE NET OPERATING INCOME (LOSS) NON-OPERATING REVENUE (EXPENSE) TOTAL INCOME BEFORE TRANSFERS TRANSFERS IN $ 24,283,545.00 5 24,283,545.00 24,283,545.00 $ (15,010,964.00) $ (15,010,964.00) $ (15,010,964.00) $ $ 12,669,550.00 $ 12,669,550.00 $ 12,669,550.00 $ $ (2,341,414.00) $ (2,341,414.00) $ (2,341,414.00) 5 TOTAL NET INCOME/PLANNED USE OF BALANCE (LOSS)* $ (2,341,414,00) $ (2,341,414.00) TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING (2,341,414.00) $ 94,216,006.08 91,874,592.08 926/2016 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT INTERNAL SERVICE FUND WATER RESOURCES COMMISSIONER ADOPTED AMENDED FY 2016 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES DRAIN EQUIPMENT FUND ( 63900) OPERATING REVENUES: Inside $37,918,534.00 638,056,070.00 $36,056,070.00 ($2,000,000.00) -5.26% Unfav - Reimbursement Salaries ($2,000,000) due to unallocated payroll charges for turnover and vacant positions; offset in Salaries and Fringes. Outside 171,000.00 171,000.00 171,000.00 $0.00 0.00% Total Revenue 38,089,534.00 38,227,070.00 36,227,070.00 (2,000,000.00) -5.23% OPERATING EXPENSES 38,424,430.00 38,564,566.00 36,506,446.00 2,058,120.00 5.34% Fav - Salaries $1,176,000 and Fringes $824,000 due to turnover and vacant positions. Fav - Indirect Cost $50,000 due to indirect cost rate finalized after budget process. Fav - Depreciation Buildings $8,620 based on projected depreciation schedule. (334,896.00) (337,496.00) (279,376.00) 58,120.00 -17.22% 719,167.00 719,167.00 730,658.00 11,491.00 1.60% Fav - Income from Investment $6,000 the result of fund earning a return due to a positive cash balance. Fav - Interest Expense $4,500 a result of the decreasing principal balance and decrease in variable interest rate related to the Drain Equipment Storage Building. Fav - Other Non Operating Revenue $991 a result of scrap equipment and meter sales. NET INCOME (LOSS) BEFORE NON-OPERATING REVENUE(EXPENSE) TRANSFER IN 0.00% TRANSFERS (OUT) 61,314.00 61,314.00 0.00% NET REVENUES OVER (UNDER) $384,271.00 $320,357.00 $389,968.00 $69,611.00 EXPENSES VI/2016 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT INTERNAL SERVICE FUND WATER RESOURCES COMMISSIONER ADOPTED AMENDED FY 2016 VARIANCE BUDGET BUDGET FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES TOTAL NET ASSETS - BEGINNING 12,049,342.46 TOTAL NET ASSETS - ENDING $12,439,310.46 gq2016 CLAIMS PAID TOTAL OPERATING EXPENSES OPERATING INCOME (LOSS) 769,400.00 769,400.00 5 4,530,840.00 $ 4,530,840.00 $ 4,530,840.00 $ (1,813,760.00) (1,813,760.00) (1,813,760.00) 0.00% 769,400.00 0.00% 0.00% COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT INTERNAL SERVICE FUND RISK MANAGEMENT ADOPTED AMENDED FY 2016 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES LIABILITY INSURANCE FUND 67700 OPERATING REVENUES: Outside Revenue $ 10,198.00 $ 10,198.00 $ 10,196.00 $ Inside Revenue 2,706,882.00 2,706,882.00 2,706,882.00 0.00% Total Operating Revenue $ 2,717,080.00 $ 2,717,080.00 $ 2,717,080.00 $ 0.00% OPERATING EXPENSE $ 3,761,440.00 $ 3,761,440.00 $ 3,761,440.00 $ 0.00% - NON-OPERATING REVENUE (EXPENSE) 150,000.00 150,.000.00 150,000.00 0.00% NET REVENUES OVER/(UNDER) EXPENSES $ (1,663,760.00),, $ (1,663,760.00) (1,663,760.00) $ TOTAL NET ASSETS - BEGINNING 7,786,719.00 TOTAL NET ASSETS - ENDING 6.122959.00 3/4/2016 99 35,125,000 9,630,000 2,816,000 3,107,000 500,000 570,800 5,100,000 200,000 730,000 18,000 1,500 300,000 115,000 105,000 35,125,000 10,000,000 2,816,000 3,107,000 500,000 570,800 5,100,000 200,000 700,000 18,000 1,500 300,000 115,000 105,000 100,000 3,082,000 3,382,000 192,500 302,500 FRINGE BENEFITS FUND 67800 ADOPTED AMENDED BUDGET BUDGET COUNTY OF OAKLAND FY2016 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND FY2016 VARIANCE FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUE RETIREES MEDICAL - VEBA DEBT 33,999,600 33,999,600 25,999,600 (8,000,000) -23.53% - Unfavorable due to reduction of retirement rate effective with the pay period beginning December 26, 2015 in an effort to reduce the equity position of the Fringe Benefit Fund. A budget amendment is recommended to reflect the rate reduction for all departments. RETI REM ENT ADMINISTRATION Z 941,700 RETIREMENT ADMINISTRATION PTNE 180,000 DEFERRED COMPENSATION-MATCH 1,050,000 DEFINED CONTRIBUTION PLAN 16,200,000 2,941,700 180,000 1,050,000 16,200,000 2,941,700 180,000 1,060,000 17,100,000 0.00% 0.00% 0.00% 900,000 5.56% - Favorable due to projected revenue more than budget projections - an increase of new hires who participate in the Defined Contribution Plan. Offset by unfavorable related expense. DEFINED CONTRIBUTION PLAN - PTNE EMPLOYEE IN-SERVICE TRAINING EMPLOYEE BENEFITS UNIT FLEX BENEFIT PLAN WELLNESS UNIT FRINGE BENEFITS TUITION REIMBURSEMENT RETIREMENT HEALTH SAVINGS GROUP LIFE INSURANCE SOCIAL SECURITY 200,000 1,370,200 976,700 100,000 712,000 97,400 460,000 2,400,000 500,000 15,300,000 200,000 1,370,200 976,700 100,000 712,000 97,400 460,000 2,400,000 500,000 15,300,000 200,000 1,370,200 1,000,000 100,000 712,000 97,400 460,000 2,400,000 500,000 15,990,000 23,300 690,000 0.00% 0.00% 2.39% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 4.51% - Favorable due to projected revenue more than budget projections - an increase in new hires. Offset by unfavorable related expense. MEDICAL INSURANCE 35,125,000 PRESCRIPTION COVERAGE INSURANCE 9,630,000 DENTAL INSURANCE 3,082,000 VISION INSURANCE 192,500 DISABILITY INSURANCE 2,816,000 WORKERS COMPENSATION 3,107,000 UNEMPLOYMENT COMPENSATION 500,000 INVESTMENT INCOME 570,800 EXT - FLEX BEN MEDICAL - EMPLOYEE 5,100,000 EXT - MEDICAL INSURANCE 200,000 EXT - PRESCRIPTION DRUG REBATES 730,000 EXT - DENTAL INSURANCE 18,000 EXT -VISION INSURANCE 1,500 EXT- FLEX BEN LIFE INSURANCE 300,000 EXT- FLEX BEN DENTAL INSURANCE 115,000 EXT - FLEX BEN VISION INSURANCE 105,000 EXT- FORFEITURE DC PLAN EXT - FORFEITURE OF DEPOSITS EXT - PREMIUM ADJUSTMENT EXT - TRAINING EXT - OTHER REVENUE - ICMA REBATES TOTAL REVENUE 0.00% 370,000 3.84% - Favorable due to projected revenue more than budget projections. Partially offset by unfavorable related expense. 300,000 9.73% - Favorable due to projected revenue more than budget projections. 110,000 57.14% - Favorable due to projected revenue more than budget projections. 0.00% op 0000/ /: 0.00% 0.00% 0.00% (30,000) -4.11% 0.00% 0.00% 0.00% 0.00% 0.00% 100,000 0.00% - Favorable due to forfeiture of non-vested International City Management Association (ICMA) accounts. 0.00% 11,500 191.67% 1,600 0.00% 0.00% (5,523,600L -4.00% 20,000 20,000 20,000 6,000 6,000 17,500 1,600 10,000 10,000 10,000 138,116,400 138,116,400 132,592,800 100 39,000 200,000 981,200 350,000 965,700 100,000 712,000 97,400 460,000 2,400,000 800,000 15,990,000 200,000 1,020,200 350,000 976,700 100,000 712,000 97,400 460,000 2,400,000 800,000 15,300,000 200,000 1,020,200 350,000 976,700 100,000 712,000 97,400 460,000 2,400,000 800,000 15,300,000 11,000 39,690,000 39,690,000 39,090,000 10,280,000 10,280,000 10,564,400 3,190,000 3,000,000 3,190,000 299,000 2,816,000 3,113,000 500,000 250,000 2,816,000 3,094,700 400,000 299,000 2,816,000 3,113,000 500,000 DEFINED CONTRIBUTION PLAN - PTNE EMPLOYEE IN-SERVICE TRAINING IN-SERVICE TRAINING - INFO TECH EMPLOYEE BENEFITS UNIT FLEXtBLE BENEFIT PAYMENTS WELLNESS PROGRAM ACCOUNTING SERVICES TUITION REIMBURSEMENT RETIREMENT HEALTH SAVINGS GROUP LIFE INSURANCE SOCIAL SECURITY MEDICAL INSURANCE PRESCRIPTION COVERAGE DENTAL INSURANCE VISION INSURANCE DISABILITY INSURANCE WORKERS COMPENSATION UNEMPLOYMENT COMPENSATION 0.00% 3.82% 0.00% 1.13% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% (690,000) -4.51% - Unfavorable due to projected costs more than budget projections - increase in new hires. Offset by favorable revenue. 600,000 1.51% - Favorable due to projected costs less than budget projections; offset by favorable related revenue. (284,400) -2.77% - Unfavorable due to projected costs more than budget projections; offset by favorable related revenue. 190,000 5.96% - Favorable due to projected costs less than budget projections. 49,000 16.39% - Favorable due to projected costs less than budget projections. 0.00% 18,300 0.59% 100,000 20.00% - Favorable due to projected costs less than budget projections. FRINGE BENEFITS FUND 67800 ADOPTED AMENDED BUDGET BUDGET COUNTY OF OAKLAND FY2016 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS FRINGE BENEFITS FUND FY2016 VARIANCE FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING EXPENSE RETIREES MEDICAL - VEBA DEBT PRINC. RETIREES MEDICAL -VEBA DEBT INT/AGIN RETIREMENT ADMINISTRATION DEFERRED COMP-COUNTY PMTS (MATCH DEFINED CONTRIBUTION PLAN 22,200,000 11,799,600 3,121,700 1,050,000 16,200,000 22,200.000 11,799,600 3,121,700 1,050,000 16,200,000 22,200,000 11,799,600 3,121,700 1,050,000 17,100,000 (900,000) 0.00% 0.00% 0.00% 0.00% -5.56% - Unfavorable due to projected costs more than budget projections - increase of new hires who participate in the Defined Contribution Plan. Offset by favorable related revenue. CHILD CARE FACILITY HEALTH INSURANCE PREMIUM TAX REINSURANCE FEES MICHIGAN HICAA TAX PATIENT CENTERED OUTCOME RESEARC INDIRECT COSTS 208,800 50,000 388,000 385,000 17,000 392,000 208,800 50,000 388,000 385,000 17,000 392,000 208,800 50,000 388,000 385,000 17,000 77,600 314,400 0.00% 0.00% 0.00% 0.00% 0.00% 80.20% - Favorable due to actual charges developed after budget finalization. Budget amendment is recommended. TOTAL EXPENSE NET REVENUE OVER/(UNDER) EXPENSES TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 138,116,400 138,116,400 138,669,100 (552,700) -0.40% 0.00 0.00 (6,076,300) (6,076,300) 69,433,308 63,357 008 101 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT ENTERPRISE FUNDS CENTRAL SERVICES ADOPTED AMENDED FY 2016 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES •••n••nn •••nn•••~~ n•nn ..,•••••••n•n 0.7.n•••nn OAKLAND COUNTY INTERNATIONAL AIRPORT (56500) OPERATING REVENUE $4,316,400.00 $4,316,400.00 $4,329,400.00 $13,000.00 0.30% - Fay. Landing Fees $13,000 due to higher traffic at Fixed Based Operators located on Airport property. OPERATING EXPENSE 6,836,677.00 6,836,677.00 6,849,677.00 (13,000.00) -0.19% - Unfav. Runway and Taxiway Repairs ($56,000) due to unexpected runway repair and crack sealing at Oakland Southwest Airport, Ads. Prior Years Exp ($15,200) due to invoices received for pilor year services, Firefighting Supplies ($9,800) due to the replacement of 7 sets of tum-out gear that are due to expire, Motor Pool ($3,000) due to the cost of a vehicle build for a van that was replaced, and Sponsorship ($2,000) to sponsor Economic Development - Emerging Sectors for the Sky's The Limit event; Fay. Indirect Costs $73,000 due to actual charges being developed after budget finalization. NET OPERATING INCOME (LOSS) ($2,520,277.00) ($2,520,277.00) ($2,520,277.00) $0.00 0.00% NON-OPERATING REVENUE (EXPENSE) 145,000.00 145,000.00 154,300.00 9,300.00 6.41% Fav. Refund Prior Years Expenditure $9,300 due to State reimbursement for grant project expenses paid in prior years. TOTAL INCOME BEFORE CONTRIBUTIONS AND TRANSFERS ($2,375,277.00) ($2,375,277.00) $ (2,365,977.00) $9,300.00 TRANSFERS IN CAPITAL CONTRIBUTION 0.00 0.00 0.00 $0.00 0.00% TOTAL NET INCOME (LOSS) ($2,375,277.00) ($2,375,277.00) ($2,365,977.00) $9,300.00 TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING $ 78,467,034.51 $76,101,057.51 3/4/2016 102 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS CENTRAL SERVICES ADOPTED AMENDED FY2016 VARIANCE BUDGET BUDGET FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES MOTOR POOL FUND 66100 OPERATING REVENUE: Outside Revenue 142,000.00 $ 142000.00 $ 162,000.00 $ 20,000.00 14.08% - Fav. Ext. Litigation Settlements $20,000 for Settlement in Antitrust Litigation Suit. Inside Revenue 8,798,539.00 9,072,115.00 9,072,115.00 $ 0.00% Total Revenue $ 8,940,539.00 $ 9,214,115.00 $ 9,234,115.00 $ 20,000.00 OPERATING EXPENSE 9,278,414.00 9,477,501.00 9,514,701.00 $ (37,200.00) -0.39% - Unfav. Indirect Costs ($37,200) due to actual charges being developed after budget finalization. OPERATING INCOME (LOSS) $ (337,875.00) $ (263,386.00) $ (280,586.00) $ (17,200.00) NON-OPERATING REVENUE (EXPENSE) 235,000.00 235,000.00 235,000.00 $ 0.00% NET INCOME (LOSS) BEFORE OPERATING TRANSFERS $ (102,875.00) $ (28,386.00) $ (45,586.00) $ (17,200.00) TRANSFERS IN / (OUT) 118,885.00 418,717.00 418,717.00 $ NET REVENUE OVER/(UNDER) EXPENSES (PLANNED USE OF FUND BAL.)* TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING $ 16,010.00 $ 390,331.00 $ 373,131.00 $ (17,200.00) $ 8,727,729.95 $ 9,100,860.95 103 3/4/2016 ADOPTED BUDGET FACILITIES MAINTENANCE & OPERATIONS (#63100) AMENDED BUDGET COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT INTERNAL SERVICE FUND FACILITIES MANAGEMENT FY 2016 VARIANCE FORECAST FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES OPERATING REVENUES: Outside Revenue Inside Revenue Total Revenue OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS 519,400.00 $ 519,400.00 $ 662,400.00 $ 143,000.00 27.53% - Fay. External - Other Revenue due to subrogation payment for property damage. 25,113,789.00 25,113,789.00 25,113,789.00 0.00% $ 25,633,189.00 $ 25,633,189.00 $25,776,189.00 $ 143,000.00 0.56% $ 27,457,697.00 $ 27,457,697.00 $26,017,697.00 $ 1,440,000.00 5.24% -Fay. Salaries and Fringe Benefits $650,000 due to underfilled/vacant positions; Electrical Service $500,000 due to lower-cost third-party contracts and savings from FM&O energy conservation initiatives; Natural Gas $500,000 due to purchasing natural gas from third party sources and mild weather conditions; Road Salt $75,000 due to mild weather conditions and Security Supplies $50,000 due to the use of alternative sources of funding (security enhancement). Partially offset by unfav. IT Operations ($100,000) due to one time Kronos project costs; Custodial Supplies ($100,000) and Material & Supplies ($75,000) based on actual usage; as well as Adj Prior Years Exp ($60,000) due to adjustment of $ (1,824,508.00) $ (1,824,508.00) $ (241,508.00) $ 1,583,000.00 NON-OPERATING REVENUE 100,000.00 $ 100,000.00 $ 100,000.00 $ 0.00% TRANSFERS IN TRANSFERS OUT NET REVENUES OVER(UNDER) EXPENSES* - $ - $ - $ (18,761.00) $ (18,761.00) $ (18,761.00) $ 0.00% 0.00% $ (1,743,269.00) $ (1,743,269.00) $ (160,269.00) $ 1,583,000.00 TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING $ 8,981,062.19 $ 8,820,793.19 *Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category. 9)2o16 ($8,493,957.00) 105,500.00 3,906,676.00 ($8,489,689.00) 105,500.00 3,971,741.00 ($6,369,289.00) 104,800.00 3,971,741.00 NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN TRANSFERS (OUT) $2,120,400.00 (700.00) -0.66% Unfav. Interest Income due to lower rates and cash balance than anticipated. 0.00 0.00% 0.00% 0.00 0.00% 1,346,164.00 1,345,164.00 1,345,164.00 CAPITAL CONTRIBUTION NET REV OVER(UNDER) EXP" ($3,136,617.00) ($3,067,284.00) ($947,584.00) $2,119,700.00 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET AMENDED BUDGET FY 2016 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - Operations (63600) 21.36% - Fay. Enhanced Access Fees $372,300 and Managed Print Services $15,900 due to higher than anticipated usage. Offset by unfavorable Deferred Land File Tax ($5,300) due to less anticipated use and Reimb Equalization Services ($4,400) due to reduction in external customer requests. -4.22% - Unfav. OC Dept ($1,276,000) and fay. OC Dept Ops & Non Gov Ops $214,300 due to rates remaining at prior year levels & limited resources available to complete development due to vacancies. Also favorable, County Auction $9,100 and Equip Rental $5,700 due to increased rebills to departments for maintenance charges on IT Office Equipment items and CLEWS Ops $300 due to actuals higher than anticipated. OPERATING REVENUES: Outside $1,772,148.00 $1,772,148.00 $2,150,648.00 $378,500.00 Inside 24,790,978.00 24,808,512.00 23,761,912.00 (1,046,600.00) TOTAL OPERATING REVENUE $26,563,126.00 $26,580,660.00 $25,912,560.00 ($668,100.00) -2.61% OPERATING EXPENSES $35,057,083.00 $35,070,349.00 $32,281,849.00 $2,788,500.00 7.95% - Fay. Salaries & Fringes $1,568,200 due to vacant positions; Expendable Equipment $1,136,700 for equipment replacement; Depreciation $928,300 for IT capital projects in progress not fully operational; Equipment Maintenance $356,100 due to lower than anticipated hardware maintenance costs; Communications $118,300 due to rate reductions; Internal Services $46,900 primarily due to: Insurance Fund $53,200, Telephone Communications $9,500, Motor Pool Fuel Charges $9,100, Leased Vehicles $300 based on usage offset by unfav, Maintenance Dept Charges ($25,300). Printing $58,400, Travel $23,500 and Mileage $1,300 due to lower than anticipated usage. Partially offset by unfav. Professional Services ($1,031,700) for previously approved IT projects; Software Maint ($253,900) due to timing of software support; Contracted Services ($104,900) and Supplies ($30,900) based on usage and Charge Card Fees ($27,800) for increased credit card activity. TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 26,588,395.97 $25 640.811.97 *Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned Use of Fund Balance" in the revenue category. 105 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET AMENDED BUDGET FY 2016 FORECAST VARIANCE FAV1(UNFAV1 PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - Telephone Communications (67500) OPERATING REVENUES: Outside $12,000.00 $12,000.00 $10,000.00 $ (2,000.00) -16.67% Unfav. Sale of Phone External due to reduction in landline charges. Inside 2,823,224.00 2,823,620.00 $2,821,920.00 (1,700.00) -0.06% Unfav. Sale of Phone Internal due to decreased usage. TOTAL OPERATING REVENUE OPERATING EXPENSES $2,835,224.00 $2,835,620.00 $3,383,950.00 $3,384,346.00 $2,831,920.00 $2,572,646.00 ($3,700.00) $811,700.00 23.98% Fav. Communications $482,800 due to decreased rates; Depreciation $305,500 based on projected depreciation schedules; Sublet Repairs $33,600 due to lower than anticipated repair volume; Software Maintenance $24,400 due to lower maintenance rates; Maintenance Equipment $18,300 due to lower than anticipated contract rates; Tower Charges $10,000 due to decreased pager usage; Voice Mail $700 due to lower than anticipated costs and Internal Services $400 primarily due to Motor Pool Charges based on actual usage and costs. Partially offset by unfav. Professional Services ($26,500) due to implementation of previously approved projects; Contracted Services ($23,000) due to telephone communication consultants and Expendable Equipment ($14,500) due to maintenance costs being higher than the budget projection. NET INCOME (LOSS) BEFORE OPERATING TRANSFERS ($548,726.00) ($548,726.00) $259,274.00 $808,000.00 40,600.00 10,600.00 NON-OPERATING REVENUE TRANSFERS IN TRANSFERS (OUT) NET REV OVER(UNDER) EXP" TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 30,000.00 30,000.00 35.33% Fay, primarily due to Interest Income; higher cash balance than anticipated. 0.00% 0.00% ($518.726.00) ($518,726.00) $299,874.00 $818 600.00 4,343,776.83 $4,643,650.83 "Please note that in the Adopted Budget (line-item book) this is budgeted as "Planned use of Fund Balance' in the revenue category. 106 COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS / ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET AMENDED BUDGET FY 2016 FORECAST VARIANCE FAVI(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - CLEM1S 153500) OPERATING REVENUES: Outside $4,142,303.00 $4,142,303.00 $4,645,603.00 $503,300.00 12.15% Fay. Rebilied Charges $300,000 billed to Tier 2.5 &3.0 agencies for connectivity costs; CLEMIS Crash $48,600, CLEMIS Citation $28,300, In-Car Terminals External $25,200, CLEMIS Parking $8,000 and Crime Mapping $2,500 due to increased usage by Oakland and non-Oakland agencies and Access Fees Oakland $102,700 due to updated law enforcement Full Time Equivalent count used for billing. Partially offset by unfav. Maintenance Contracts ($12,000) due to Livescan maintenance after warranty. -15.92% Unfav. Service Fees ($243,600) based on actual billing for Computer Aided Dispatch (CAD) expense charge directly to Radio Fund and Reimb General ($88,900) based on actuals for CLEMIS staff supporting Sheriff projects. 2.74% 12.83% Fav. Depreciation $1,044,800 based on projected depreciation schedules; Salaries & Fringe Benefits $943,900 due to vacancies; Communications $101,100 due to actual costs less than anticipated; Internal Services $250,800 primarily due to IT Development based on actual usage; Equipment Maintenance $230,000 due to less than anticipated cost of repairs; Software Rental $16,900 due to the timing of software expenses; Printing $2,000 and Supplies $5,300 based on actual usage. Offset by unfav. Software Maintenance ($487,300) due to additional software purchases in excess of budget projections; Rebillable Services ($300,000) based on actual connectivity costs to Tier 2.5 and 3.0 agencies; Professional Services ($297,100) due to higher than anticipated contractual costs for Simtech staffing services for an additional programmer; Bank Charges ($133,200) due to cost of PayPai services for E-Commerce transactions; Indirect Cost ($34,500) due to charges determined after finalization of the budget and Travel ($8,600) due to usage. Inside 2,086,815.00 2,088,076.00 1,755,576.00 (332,500.00) TOTAL OPERATING REVENUE $6,229,118.00 $6,230,379.00 $6,401,179.00 $170,800.00 OPERATING EXPENSES $10,400,915.00 $10,400,915.00 $9,066,815.00 $1,334,100.00 NET INCOME (LOSS) BEFORE OPERATING TRANSFERS ($4,171,797.00) ($4,170,536.00) ($2,665,636.00) $1,504,900.00 NON-OPERATING REVENUE 35,000.00 35,000.00 110,800.00 75,800,00 216.57% Fay. primarily due to Interest Income; higher cash balance than anticipated. TRANSFERS IN 2,044,186.00 2,044,186.00 2,044,186.00 0.00% TRANSFERS (OUT) 0.00% CAPITAL CONTRIBUTION 150,000.00 150,000.00 150,000.00 0.00 0.00% NET REV OVER(UNDER) EXP* ($1,942.611.00) ($1,941.350.00) ($360,650.00) ,....,,11.1.682L_700.00 18,970,019.70 $18 609 369.70 TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING 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 Acli in Expenses. 107 $6,995,000.00 $6,995,000.00 $6,887,400.00 ($107,600.00) COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS! ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET AMENDED BUDGET FY 2016 FORECAST VARIANCE FAV/(UNFAV) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Information Technology - Radio Communications (53600) -1.54% Unfav. E-911 Surcharge ($114,700) due to decreased volume of users/receipt of 911 surcharge; Outside Agency Revenue ($4,200) due to fewer non-emergency agencies than anticipated. Partially offset by Fay. Antenna Site Management $11,300 due to removal of equipment. 5.63% Fay. Productive Labor $23,100 due to Mobile Data Computer repairs for DC Agencies and Parts Access $2,600 due to reimbursement by participating agencies for equipment replacement 7.56% Fay. Depreciation $501,700 based on projected depreciation schedule; Internal Services $333,600 primarily due to info Tech CLEMIS based on usage; Salaries & Fringe Benefits $107,300 due to vacancies; Professional Services $48,400 due to CAD Upgrade project enhancements; Tower Charges $35,600 for tower rental agreements; Utilities $30,500 based on actual usage; Equipment Maintenance $12,000 due to maintenance costs of the radio system; Supplies $6,600 due to usage and Software Lease $4,600 due to the timing of the Emergency Services IP Network project. Partially offset by unfav. Communications ($66,800) for connectivity costs for cell tower sites used for coverage enhancements of the Radio system. OPERATING REVENUES: Outside Inside TOTAL OPERATING REVENUE OPERATING EXPENSES 456,788.00 456,788.00 482,488.00 25,700.00 $13,399,533.00 $13,399,533.00 $12,386,033.00 $1,013,500.00 $7,451,788.00 $7,451,788.00 $7,369,888.00 ($81,900.00) -1.10% ($5,016,145.00) 167,400,00 31,500.00 486,000,00 NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE TRANSFERS IN TRANSFERS (OUT) CAPITAL CONTRIBUTION NET REV OVER(UNDER) EXP" TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING ($5,947,745.00) ($5,947,745.00) 180,000.00 180,000.00 31,500.00 486,000.00 485,000.00 ($5,281.745.00) ($5,250,245.00) $931,600.00 (12,600.00) -7,00% Unfav. Interest Income due to lower rates and cash balance than anticipated. 0.00% 0.00% 0.00% ($4,331,245.00) $919 000 00 41,379,447.63 $37,048,202.63 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. 108 ($538,502.00) ($1,454,754.00) ($1,130,054.00) $324,700.00 3,000.00 3,000.00 2,500.00 (500.00) -16.67% Unfav. Interest Income due to lower rates and cash balance than anticipated. TOTAL OPERATING REVENUES OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE $196,587.00 $196,587.00 $204,787.00 $8,200.00 4.17% $735,089.00 $1,651,341.00 $1,334,841.00 $316,500.00 19.17% Fay. Professional Services $300,000 due to lower than anticipated contractual costs; Salaries & Fringes $26,500 due to vacancies; Communications $18,100 due to decrease in connectivity rates; Software Maintenance $3,300 due to decrease in maintenance costs. Offset by unfav. Indirect Cost ($13,000) and Internal Services ($18,400) primarily due to FT Development ($25,500) partially offset by fay. IT Operations $6,800 based on actual usage. COUNTY OF OAKLAND FY 2016 FIRST QUARTER REPORT INTERNAL SERVICE FUNDS !ENTERPRISE FUND INFORMATION TECHNOLOGY ADOPTED BUDGET Fire Records Management ( 53100) OPERATING REVENUES: Outside $196,587.00 AMENDED BUDGET $196,587.00 FY 2016 FORECAST $204,787.00 VARIANCE FAVHUNFAVI PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $8,200.00 4.17% Fay. primarily due to Outside Agencies participation due to the timing of implementation of anticipated new member agencies. TRANSFERS IN 424,512.00 1,140,764.00 1,140,764,00 0.00% TRANSFERS (OUT) -- 0.00% CAPITAL CONTRIBUTION 0.00 0.00% NET REV OVER(UNDER) EXP" TOTAL NET ASSETS - BEGINNING TOTAL NET ASSETS - ENDING ($110,990.00) (S310,990.00) $13,210.00 $324,200.00 615,981 22 $629,191.22 *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. 109 2016 UNCOLLECTABLE HOME IMPROVEMENT LOANS COMMUNITY DEVELOPMENT BLOCK GRANT CASE # BAL DUE 1111 (111..1ii 9,577.00 8,055.00 14,725.00 111111 18,301.86 8,131.94 111111 TOTAL: $139,122.72 Total Write offs 12 5213 5412 5524 5727 5330 6372 6733 5059 5320 6292 6420 6441 110 2016 UNCOLLECTABLE HOME IMPROVEMENT LOANS HOME INVESTMENT PARTNERSHIP ACT ACCOUNTS BAL DUE CASE # 10015 $ 18,265.00 10043 $ 4,300.00 9891 $ 16,835.00 10536 10,585.00 TOTAL: $49,986.00 TOTAL AMOUNT UNCOLLECTIBLE Write offs 10/10 to 09/1 11-H1 *Client has more than one loan Total Write offs: 4 Grand Total Write offs: 16 $189,107.72 111 OAKLANDCOUNTYPARKS OAKLAND COUNTY PARKS & RECREATION COMMISSION AGENDA FEBRUARY 2, 2016 AGENDA ITEM No. 8 C P & R FISCAL SERVICES To: From: Submitted: Subject: Chairman Fisher and Commission Members Daniel J. Stencil, Executive Officer Jeff Phelps, Fiscal Services Coordinator January 28, 2016 Uncollectible Debt Write-off— Installment Rental Agreement INTRODUCTION AND HISTORY In 2012, Darlene Miller and her daughter Melanie Alexander were tenants in the residential home at Independence Oaks-North, located at 9965 Sashabaw Road, Clarkston. Mrs. Miller and Ms. Alexander got behind on their payments and accumulated a large amount of past due rent. With the assistance from Oakland County Corporation Counsel we were able to create an agreed upon installment payment agreement plan to clear up these past due amounts, Melanie Alexander, the joint co-signee of the Agreement, was discharged from payment obligations via a Chapter 7 Bankruptcy proceeding in 2014. Payments were received on this debt until July 2015, which was for the March 2015 installment payment. We have received confirmation from Darlene Miller's daughter that she passed away in August of 2015, At this point Corporation Counsel is not aware of any other collection remedies that can be attempted to satisfy the remaining balance on the installment payment agreement. As a result, this uncollectible debt amount will need to be written off the OCPR Accounts Receivables. The amount to be written off is $2,937.59. As this debt is over $1,000.00, it requires final approval by the Oakland County Board of Commissioners. STAFF RECOMMENDATION Staff recommends the Commission approve the write-off of the uncollectible debt from Darlene Miller for past due rent at Independence Oaks North, 9965 Sashabaw Road, Clarkston, MI in the amount of $2,937.59. MOTION Move to approve the write-off of the uncollectible debt from Darlene Miller for past due rent at Independence Oaks North, 9966 Sashabaw Road, Clarkston, MI in the amount of $2,937,69, and forward it to the Oakland County Board of Commissioners for final approval. 112 69 INFORMATION TECHNOLOGY UN RECOVERED CHARGEBACKS Order Transaction Action Title Description Number Amount Status Start Date Due Date Last Activity needed Assigned To 10229611472 - 52-3 1023236122 -Clerk Legal 1023088432 Reimbursement 1023026742 - Clerk Legal 1023147252 52-3 1023084948 Health 10231252211T 1023961719 52-3 8/18/2015 Court Fees DTCdisputed. Notified Vicki Nellie 10/26/15 No other action on this and it Is expired in Elavon per Sue did a payment CD in FF 1098775 $ 8/28/2015 Chargeback Notice. Please notify Clerk 9/2/15 emalled Jennifer Howden, Heidi Walling 9/8/15 received email from Heidi: I contacted the cardholder and she did dispute the charge because she did not make A. Her name, address and phone number are correct on the order but the email address that was used is unknown by her She also did not know the case name or number and said she has never used Court Explorer to order court documents. 9/23/15 received more info notice. Emailed Elavon and stated customer has a valid claim per above email from Heidi 10/26/15 Per Sue did a payment CB In FF system emailed Heidi 9/8/15 received 1st chargeback emalled Deb Bachman asked if it was a valid charge 9/9/15 Hi Cyndi, Mr. Pickett said the payment was frorn his aunt and she probably thought G2G was fraud. He is going to come in arid pay rash so allow the chargeback to go through. Thanks, Debby sent her an email back should we wait until he actually pays or should we pursue? 9/10 received email from Deb: Client came in and paid $150 cash on 9/9/15. Thanks for checking. Emalled Elavon valid chargeback 10/26/15 per Sue did a payment C8 in FF system, emalied Deb 1113921 $ 8/28/2015 Chargeback received. Please notify Clerk 9/2/15 emailed Jennifer Howden, Heidi Walling 9/17/15 received credit, emalled Jennifer and Heidi 10/29/15 Received 2nd CB; emalled Jennifer and Heidi 1/12/16 per Treasurer this was chargedback in 620 1097521 $ 9/15/15 received let chargeback, ernalled Flavor and Vicki Nellie; 1 10/15 Received credit notice, Ed called Vicki Nellie 10/27/15 Vicki requested copy of credit notice but it Is not saved here. 11/2/15 Received Pre Are; emalled Vicki 11/12/2015 Received second chargeback notice; emalled Vicki 1/12/16 per Treasurer this was charged hackle 620 1109623 $ 9/8/15 Received 1st chargeback; emailed Elavon and Leigh-Anne Stafford. 10/1/15 Received a more information letter from Clarion. Clarion wants batch information whIchl sent them. The batch info states it loan approved payment but the street address and zip did not match the card. 11/06/2015 Received Pre-Arbitration notice. emailed Leigh- Anne Stafford. 11/30/2015 Second chargeback 1/12/15 per Treasurer this was chargeback In 626 1110274 $ 9/10/15 Received let CB, entailed Eleven. This is access fees for a payment made to 18DC 10/08/15 Received a more Info request for batch details. Mailed Elavon 11/5/2015 Pre-arbritration notice. 11/30/2015 - Second chargeback notice 1/12/16 per Treasurer this was charged back In 626 1097674 $ 8/31/15 Received 1st CB, entailed havoc and Vicki Nellie 10/09/15 Received credit; emailed Vicki Nellie 11/12/2015 Received Pre-arbitration Notice, mailed Vicki 12/3/2015 Second chargeback 01/12/16 per treasurer this was charged back In 626, 1055250 $ Undisputed - Chargeback 79.00 Accepted Undisputed - Chargeback 155.50 Accepted Second Chargeback - Mark as 20.00 Credit Second Chargeback - Mark as 155.50 Credit Second Chargeback - Mark as 62,00 Credit Second Chargeback - Mark as 24.75 Credit Second Chargeback - Mark as 130.50 Credit 8/17/2015 9/19/2015 10/26/2015 FALSE Sager, Edward It 9/4/2015 10/6/2015 10/26/2015 FALSE Peterson, Cynthia N 8/28/2015 9/29/2015 11/2/2015 FALSE Peterson, Cynthia N 9/12/2015 10/16/2015 11/2/2015 TRUE Peterson, Cynthia N 9/3/2015 10/7/2015 11/30/2515 TRUE Peterson, Cynthia N 9/10/2015 10/14/2015 11/30/2015 TRUE Peterson, Cynthia N 8/31/2015 11/24/2015 12/3/2015 TRUE Peterson, Cynthia N Undisputed - Chargeback 1104211 $ 4.50 Accepted 8/28/2015 10/1/2015 10/26/2015 FALSE Peterson, Cynthia N 113 INFORMATION TECHNOLOGY UNRECOVERED CHARG HACKS Title 1023230571 IT 1023556421-52-3 Order Transaction Action Description Number Amount Status Start Date Due Date Last Activity needed Assigned To 9/25/15 Received chargeback; ernalled Elavon Second 10/20/15 Received credit Chargeback 12/3/2015 Prearb notice Mark as 12/17/2015 Second Chargeback 1083057 $ 13.75 Credit 9/24/2015 10/29/2015 12/3/2015 TRUE Peterson, Cynthia N Second 11/1312015 Received 1st CE; emailed Elavon and Vickie Nellis Chargeback - 12/13/2015 Reversed; Notified Vicki Mark as 12/29/2015 Second Chargeback; Notified Vicki 1157259 $ 12030 Credit 11/13/2015 12/16/2015 12/29/2015 TRUE Sager, Edward 11 1023510524- 52-1 11/10/2015 - Received chargeback notice. Notified Vicki Nellis. 12/11/2015 Reversed;Notified Vicki 12/78/2015 Second chargeback;Notified Vicki 1155499 $ Second Chargeback - Mark as 135.50 Credit 11/10/2015 12/10/2015 1/4/2016 TRUE Sager, Edward Ii 11/2/15 received chargeback; emalled Elavon and Heidi Walling/Jennifer Howden. Second 12/7/2015 Reversed; ernalled Heidi Walling/Jennifer Howden. Chargeback - 12/30/2015 Pre-Arb Notice; Notified Heidi Mark as 1023468717 Clerk Legal 1/13/2015 2nd Chargeback, notified Heidi Walling 1095864 $ 17.50 Credit $ 919.00 10/30/2015 12/3/2015 1/13/2016 FALSE Peterson, Cynthia N 114 Department of Health and Human Services Oakland County Children's Village Donation Tracking : Donation Period October 2015 - December 2015 Date: Donor: Cash/Check: Items: Estimated Value: 10/1/2015 Unasource Health Check $3,500.00 10/1/2015 Jack & Jill Check $2,865.00 10/5/2015 Datsun Doctor Magazines $5.00 10/9/2015 Jennifer Hichme Books, Toiletries, Clothing $75.00 10/10/2015 Matt Montmorency 1 Pair Jeans $2.00 10/12/2015 Sweet Dreams for Kids 25 Pillowcases $25.00 10/13/2015 Leilani Triplett Outerwear $45.00 10/15/2015 CVS Pharmacy Cloioring Books & Play Balls $10.00 10/19/2015 Jane Makuch Clothing $50.00 10/22/2015 Diane Malik Shoes & Crafts $50.00 10/23/2015 Charles McCall Misc Magazines $5.00 10/28/2015 Linda Simon Magazines $5.00 11/9/2015 Leilani Triplett Clothes $10.00 11/9/2015 Roxanne Degriselles Clothing for Young & Teen Boys & Girls $250.00 11/11/2015 Sweet Dreams for Kids 15 Pillowcases $15.00 11/16/2015 Linda Oleary Bags $3.00 11/18/2015 Carolyn Cohen 500 Books $25.00 11/20/2015 Fran Vallely Board Games/ Ping Pong Supplies $40.00 11/20/2015 Jane Makuch Toiletries & Toys $10.00 11/20/2015 Datsun Doctor Magazines $5.00 11/24/2015 Jane Makuch Clothes & Shoes $75.00 12/4/2015 Michael McCanhan Games and Puzzles $30.00 12/7/2015 Caruso Caruso 242 Pairs Jeans $5,000.00 12/7/2015 Christ Church Cranbrook $101.23 Check Christmas Gifts $451.00 12/8/2015 Jennifer Buzonowski Clothing, Gift Cards, Toys $200.00 12/8/2015 Welcome Mission Baptist Hair Care Supplies $1,500.00 12/9/2015 Monica Scott Hair Care Supplies $400.00 12/9/2015 Skinny Tees Clothing, Cosmetics, Crafts $75.00 12/9/2015 University Hills Elementary PTA Check $739.47 12/9/2015 Grace Christian Church Board Games $120.00 115 Department of Health and Human Services Oakland County Children's Village Donation Tracking : Donation Period October 2015 - December 2015 Date: Donor: Cash/Check: Items: Estimated Value: 12/10/2015 Jane Makuch 20 AM/FM Radio Headsets $440.00 12/10/2015 John Ashley 35 New Stuffed Animals $70.00 12/10/2015 Amerisure Hoodies/Holiday Party in D, G & MP $1,425.00 12/10/2015 Aetna Pajama Sets/ Hats/Scarves $40.00 12/11/2015 St. Paul's United Methodist 7 Boxes Children's Toys $140.00 12/11/2015 Sweet Dreams for Kids 15 Pillowcases $15.00 12/11/2015 Coolzips - Lauren Altman 5400 Charm Packs, 60 Tote Bags $250.00 12/11/2015 Anoited Word Ministries Pajamas $100.00 12/14/2015 St. Mary of the Hills Christmas Gifts $6,000.00 12/15/2015 Carol Greania Toys, Art Supplies, Stuffed Animals $100.00 12/15/2015 St. Dans Christmas Gifts $1,400.00 12/16/2015 Henry Ford Radiology Dept Gloves, Toiletries, Wrapping Paper $160.00 12/16/2015 ALPS Electric Toys, Clothing, Toiletries $1,700.00 12/17/2015 WSD Board Office Cash Proceeds from casual days $77.00 12/17/2015 Senior Men's Club of Birmingham Checks (36 total checks) $3,500.00 12/17/2015 Lockwood of Waterford Hats and Gloves $25.00 12/17/2015 Trinity Deacones Ministry Toiletries $50.00 12/17/2015 Williams Lake Bunco Club Hats and Mittens $100.00 12/18/2015 Macomb DHS Beauty Products $300.00 12/18/2015 Sea Life Aquarium Toys, Gloves, Scarves $250.00 12/21/2015 Clarkston Brandon C. Union Winter Gear, Books, DVDs $500.00 12/21/2015 Pam Dorris 46 Dozen Cookies $100.00 12/21/2015 Jody Hall (0C) Stuffed Animals, Candy, Chips $200.00 12/21/2015 Chris Cortez Yarn $50.00 12/21/2015 Love & Buttercream Clothing, Diapers, Toys $100.00 12/21/2015 St. Vincent de Paul Oranges $10.00 12/21/2015 Kristina Kohler Childrens Toys $50.00 12/21/2015 Lakes Area Rotary Christmas Gifts $1,500.00 12/22/2015 Karl Wolf Cookies $40.00 12/22/2015 Paul Pepple / Denise Geeig Toys, Toiletries $200.00 116 Department of Health and Human Services Oakland County Children's Village Donation Tracking : Donation Period October 2015 - December 2015 Date: Donor: Cash/Check: Items: Estimated Value: 12/22/2015 Covisint Corporation Clothing & Toiletries $250.00 12/25/2015 Prosecutor's Foundation for Kids Christmas Gifts $2,000.00 12/28/2015 Fathead Wall Decals $1,950.17 Total: $38,677.64 COMPILED BY: NICOLE KRUMM FINALIZED 12/30/2015 117 From: Andrews, Michael B To: plfr. Gala V; Adoglu-Jones, Ebru. Subject: FW: Donatan to the Library Board Date: Monday, November 23, 2015 8:42:33 AM Fyi From: Mancini, Laura N Sent: Friday, November 20, 2015 5:29 PM To: Andrews, Michael B Cc: VerPloeg, James A Subject: Donation to the Library Board Dear Michael: The Oakland County Bar Association has donated five pieces of furniture to the Law Library. The Library Board accepted the donation at its meeting earlier this week. The donation consists of the following: 2 small wood computer desks 2008 purchase price= $400.00 66" wide wood desk 2008 purchase price=$900.00 2 black leather conference chairs 2008 purchase price -$768.00 All of the furniture was purchased in 2008. The Bar provided me with the above information as to the purchase price. I saw the furniture earlier today and it has definitely seen some wear and tear over the last eight years. I will leave it to you financial folks to calculate the depreciation. © I can easily say though the value has decreased over the last eight years. Please let me know if you require any additional information from me. Thanks! Laura Laura Mancini, MLIS Director-Library Services Oakland County Library 1200 N. Telegraph Pontiac, MI 48341 248-858-0380 rnancinilVoakgov,com 118 Resolution #16041 March 17, 2016 Moved by Kochenderfer supported by Jackson the resolutions (with fiscal notes attached) on the Consent Agenda be adopted (with accompanying reports being accepted). AYES: Dwyer, Fleming, Gershertson, Gingell, Hoffman, Jackson, Kochenderfer, KowaII, Long, McGillivray, Middleton, Quarles, Scott, Spisz, Taub, Weipert, Woodward, Bowman, Crawford. (19) NAYS: None. (0) A sufficient majority having voted in favor, the resolutions (with fiscal notes attached) on the Consent Agenda were adopted (with accompanying reports being accepted). HEREON/APPROVE THIS RESOLUTION CHIEF DEPUTY COUNTY EXECUTIVE ACTING PURSUANT TO MCL 45.559A (7) STATE OF MICHIGAN) COUNTY OF OAKLAND) I, Lisa Brown, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on March 17, 2016, 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 17 th day of March, 2016. Lisa Brown, Oakland County ds<gefi__