Loading...
HomeMy WebLinkAboutAgenda - Item 8-e - Fiscal Year 2017-18 Budget Amendment #10 ORD-2018-025 ORANGE COUNTY BOARD OF COMMISSIONERS ACTION AGENDA ITEM ABSTRACT Meeting Date: June 19, 2018 Action Agenda Item No. 8-e SUBJECT: Fiscal Year 2017-18 Budget Amendment #10 DEPARTMENT: Finance and Administrative Services ATTACHMENT(S): 1. Budget as Amended Spreadsheet 2. Year-to-Date Budget Summary 3. Letter of Request from Town of Carrboro Related to South Orange Fire Service District 4. Memo from Orange County Schools for Repurposing of School Capital Project Funds INFORMATION CONTACT: Paul Laughton, (919) 245-2152 Gary Donaldson, (919) 245-2453 PURPOSE: To approve budget, capital, and grant project ordinance amendments for fiscal year 2017-18. BACKGROUND: Animal Services 1. The Animal Service Department has received the following additional funds: • Donations (Spay/Neuter Fund) – receipt of donations totaling $2,520 to be used in agreement with the Spay Neuter Assistance Program of North Carolina to provide one day of subsidized spay and neuter services for barn cats in the County within the Community Spay/Neuter Fund, a Special Revenue Fund outside of the General Fund. • Donations – receipt of donations totaling $2,893 to be used for a musical enrichment pilot project in the County Animal Shelter. This budget amendment provides for the receipt and appropriation of these donated funds for the above stated purpose. This budget amendment provides for the receipt of these donated funds. (See Attachment 1, column 1) SOCIAL JUSTICE IMPACT: There are no Orange County Social Justice Goals associated with this item. 1 Health Department 2. The Health Department has received notification of the following additional funds: • Kenan Charitable Trust Grant – receipt of grant funds in the amount of $300,000 from the Kenan Charitable Trust to be used by the Family Success Alliance over a three-year period. These funds will support a time-limited FTE (Social Worker Supervisor I) position, contracted services, and programming consistent with delivery of the Navigator program. Kenan Charitable Trust Grant – ($300,000) - 30 Fund Project # 71133 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Kenan Charitable Trust Funds $0 $300,000 $300,000 Total Project Funding $0 $300,000 $300,000 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Kenan Charitable Trust Grant $0 $300,000 $300,000 Total Costs $0 $300,000 $300,000 • Food and Lodging Funds – receipt of an additional $5,224 in Food and Lodging program funding from the NC Department of Health and Human Services. These funds will be used for departmental supplies supporting the Food and Lodging program. • Medicaid Cost Settlement Funds – receipt of notification of the 2017 Medicaid Cost Settlement Funds in the amount of $1,096,134. These funds will be appropriated to the Medicaid Maximization account for the purpose of renovations and amends the following Medicaid Maximization Capital Project Ordinance: Medicaid Maximization – ($1,096,134) - Project # 30012 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Medicaid Maximization Funds $8,072,626 $1,096,134 $9,168,760 Total Project Funding $8,072,626 $1,096,134 $9,168,760 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Medicaid Maximization Project $8,072,626 $1,096,134 $9,168,760 Total Costs $8,072,626 $1,096,134 $9,168,760 2 This budget amendment provides for the receipt of these additional funds. (See Attachment 1, column 2) SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goals are applicable to these items. • GOAL: ESTABLISH SUSTAINABLE AND EQUITABLE LAND-USE AND ENVIRONMENTAL POLICIES The fair treatment and meaningful involvement of people of all races, cultures, incomes and educational levels with respect to the development and enforcement of environmental laws, regulations, policies, and decisions. Fair treatment means that no group of people should bear a disproportionate share of the negative environmental consequences resulting from industrial, governmental and commercial operations or policies. • GOAL: ENSURE ECONOMIC SELF-SUFFICIENCY The creation and preservation of infrastructure, policies, programs, and funding necessary for residents to provide shelter, food, clothing, and medical care for themselves and their dependents. Library Services 3. The Orange County Library Services Department anticipates additional Smart Start funds of $2,025 and $675 from the Orange County Partnership for Young Children, both for the Time to Read program. Funds will support training for child care providers to learn techniques for teaching young children to read. This budget amendment provides for the receipt of these additional funds and amends the following Grant Project Ordinance: (See Attachment 1, column 3) Library Outreach Literacy Grant – “Time to Read” ($2,700) - Project # 71355 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Smart Start funds $16,091 $2,025 $18,116 Orange County Partnership for Young Children $ 0 $675 $675 Total Project Funding $16,091 $2,700 $18,791 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Literacy “Time to Read” Grant $16,091 $2,700 $18,791 Total Costs $16,091 $2,700 $18,791 SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goals are applicable to this item: 3 • GOAL: FOSTER A COMMUNITY CULTURE THAT REJECTS OPPRESSION AND INEQUITY The fair treatment and meaningful involvement of all people regardless of race or color; religious or philosophical beliefs; sex, gender or sexual orientation; national origin or ethnic background; age; military service; disability; and familial, residential or economic status. Department on Aging 4. The Department on Aging has received the following additional funds: • Home and Community Block Grant - anticipates receipt of additional Home Community Block Grant Funds, distributed by the Triangle J Council of Governments, in the amount of $11,016. Funds will be used to purchase furnishings for the Passmore Senior Center. • Operation Fan Program - anticipates additional revenue for the Operation Fan Program from Duke Energy and Valassis Energy, totaling $3,550, for fans and window air conditioning units, for Orange County adults 60 years old and over. • Wellness Class Fees - based on current year and historical collections, the Department on Aging anticipates receiving additional revenue of $4,085 in wellness class fees, which will pay wellness instructors and class expenses related to the Senior Citizen Health Promotion Wellness Program. This budget amendment amends the current Senior Citizen Health Promotion Grant Project Ordinance as follows: Senior Citizen Health Promotion Wellness Grant ($4,085) - Project # 294303 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Senior Citizen Wellness Funds $156,157 $4,085 $160,242 Total Project Funding $156,157 $4,085 $160,242 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Senior Citizen Wellness $156,157 $4,085 $160,242 Total Costs $156,157 $4,085 $160,242 This budget amendment provides for the receipt of these additional funds. (See Attachment 1, column 4) SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goals are applicable to this item: • GOAL: FOSTER A COMMUNITY CULTURE THAT REJECTS OPPRESSION AND INEQUITY The fair treatment and meaningful involvement of all people regardless of race or color; religious or philosophical beliefs; sex, gender or sexual orientation; national 4 origin or ethnic background; age; military service; disability; and familial, residential or economic status. • GOAL: CREATE A SAFE COMMUNITY The reduction of risks from vehicle/traffic accidents, childhood and senior injuries, gang activity, substance abuse and domestic violence. Housing and Community Development 5. The Department of Housing and Community Development has received additional revenue from the US Department of Housing and Urban Development in the amount of $280,601. This budget amendment provides for the receipt and appropriation of these funds within the Housing Fund, a special revenue fund outside of the General Fund. (See Attachment 1, column 5) SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goal is applicable to these agenda items: • GOAL: ENSURE ECONOMIC SELF-SUFFICIENCY The creation and preservation of infrastructure, policies, programs, and funding necessary for residents to provide shelter, food, clothing, and medical care for themselves and their dependents. Miscellaneous 6. The FY 2017-18 Board of Commissioners’ Approved Budget included funds of up to $1,506,824 for a Wage Increase of 2.0%, effective July 1, 2017, as well as an employee performance award of either $500, $750, or $1,000, effective with Work Planning and Performance Review (WPPR) dates from July 1, 2017 to June 30, 2018. This budget amendment provides for the actual allocation of $1,492,651 within departments to cover the Wage Increase and performance awards in FY 2017-18. (See Attachment 1, column 6) 7. The FY 2017-18 Board of Commissioners’ Approved Budget included Salary Savings funds of $2,000,000. This budget amendment provides for the actual allocation of these funds within the affected departments to cover these Salary Savings funds in FY 2017- 18. (See Attachment 1, column 7) 8. The FY 2017-18 Board of Commissioners’ Approved Budget included funds of up to $600,000 to continue the County match of employees’ 401k contributions of up to $63.00 per pay period for all general (non-sworn law enforcement officer) employees. This budget amendment provides for the allocation of projected year-end actuals of $600,000 within departments to cover these increases. (See Attachment 1, column 8) 9. The FY 2017-18 Board of Commissioners’ Approved Budget included funds of $131,425 for an increase in the Living Wage from $13.15/hour to $13.75/hour, effective July 1, 2017. This budget amendment provides for the actual allocation of $94,410 to cover the Living Wage increase within the affected departments. (See Attachment 1, column 9) 5 10. The FY 2017-18 Board of Commissioners’ Approved Budget included funds of $250,000 to address salary compression adjustments affecting County employees effective July 1, 2017. This budget amendment provides for the actual allocation of $188,481 to cover the adjustments made to 538 employees in FY 2017-18. (See Attachment 1, column 10) 11. The FY 2017-18 Board of Commissioners’ Approved Budget included funds of $524,433 to address Health Insurance premium increases effective July 1, 2017. This budget amendment provides for the actual allocation of $524,433 within departments to cover this increase in FY 2017-18. (See Attachment 1, column 11) SOCIAL JUSTICE IMPACT: There are no Orange County Social Justice Goals associated with these items. Department of Social Services – Technical Amendments 12. On April 17, 2018, the BOCC approved a technical amendment transferring FY 2017-18 budgeted funds related to Information Technology Governance Council approved projects from the Capital Projects Fund to the Department of Social Services within the General Fund in order to simplify the cost allocation process and reimbursement process for the department. The department realized savings when purchasing information technology items, purchasing items under budgeted amounts. This technical amendment provides for the transfer of these budgeted funds totaling $23,891 to the Capital Projects Fund from the General Fund and amends the following Information Technology Capital Project Ordinance: (See Attachment 1, column 12) Information Technology Capital Project ($23,891) - Project # 30007 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Alternative Financing $10,585,154 $23,891 $10,609,045 From General Fund $1,545,257 $0 $1,545,257 Appropriated Fund Balance $200,000 $0 $200,000 Total Project Funding $12,330,411 $23,891 $12,354,302 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Information Technology $12,330,411 $23,891 $12,354,302 Total Costs $12,330,411 $23,891 $12,354,302 13. On March 20, 2018, the BOCC approved the closing out of several prior year multi-year grant projects related to the Department of Social Services (DSS), and repurposed available funds to the Adoption Enhancement Fund. When one of the grant projects (Building Futures Program grant) was closed out, $70,651 in unused funds from the General Fund should have been moved to the General Fund within DSS. This technical budget amendment provides for the budgeting of these funds in the General Fund. Funds totaling $40,651 will be budgeted to cover Food and Nutritional Services Program Payments, and $30,000 will be used to replace broken and worn out furnishings in the classrooms, computer lab, waiting area, and a conference room at the Skills Development Center in Chapel Hill. (See Attachment 1, column 13) 6 SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goal is applicable to these items: • GOAL: ENSURE ECONOMIC SELF-SUFFICIENCY The creation and preservation of infrastructure, policies, programs, and funding necessary for residents to provide shelter, food, clothing, and medical care for themselves and their dependents. Emergency Telephone System (E911 Fund) 14. Through discussion and analysis efforts with County staff and the staff at the NC 911 Board, an adjustment is needed to reconcile a discrepancy between the County’s stated amounts in the E911 fund balance and the stated amounts from the NC 911 Board. This budget amendment provides for a fund balance appropriation of $44,449 from the General Fund in order to comply with NC E911 Board’s stated fund balance amount. (See Attachment 1, column 14) SOCIAL JUSTICE IMPACT: There are no Orange County Social Justice Goals associated with this item. South Orange Fire Service District 15. The Town of Carrboro Fire Department provides fire protection for the South Orange Fire Service District through a contract between the County and the Town. The Board of Aldermen for the Town of Carrboro has requested the use of $48,000 from the South Orange Fire District’s available fund balance to purchase a replacement 4x4 command vehicle. (See Attachment 3). With this appropriation, approximately $124,000 remains available in the district’s fund balance. (See Attachment 1, column 15) SOCIAL JUSTICE IMPACT: There are no Orange County Social Justice Goals associated with this item. Orange County Schools Capital Projects 16. The Orange County Schools Board of Education has requested the repurposing of available funds of $1,463,407 through the close out of existing projects to be used to cover increased construction costs associated with geothermal project at Orange High School. (See Attachment 4). This budget amendment provides for the transferring of available funds from these projects to the Mechanical Systems - 2016 Bonds project and amends the following School Capital Project Ordinances: Alternative School/Partnership Academy (-$67) - Project # 50009 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Lottery Proceeds $356,720 $0 $356,720 From General Fund $5,000 ($67) $4,933 Total Project Funding $361,720 ($67) $361,653 7 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Construction $361,720 ($67) $361,653 Total Costs $361,720 ($67) $361,653 New Hope Elementary Renovations (-$59,549) - Project # 50010 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised From General Fund $325,000 ($59,549) $265,451 Total Project Funding $325,000 ($59,549) $265,451 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Construction $325,000 ($59,549) $265,451 Total Costs $325,000 ($59,549) $265,451 Asbestos Removal (-$50,000) - Project # 51001 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised 2/3 Net Debt Bonds $50,000 ($50,000) $0 Total Project Funding $50,000 ($50,000) $0 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Abatement $50,000 ($50,000) $0 Total Costs $50,000 ($50,000) $0 Handicap Accessibility (-$100,000) - Project # 51005 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised 2/3 Net Debt Bonds $16,000 $0 $16,000 From General Fund $583,300 ($100,000) $483,300 Total Project Funding $599,300 ($100,000) $499,300 8 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Renovations $599,300 ($100,000) $499,300 Total Costs $599,300 ($100,000) $499,300 Roofing Projects (-$7,500) - Project # 51010 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised 2/3 Net Debt Bonds $254,155 $0 $254,155 From General Fund $1,106,200 ($7,500) $1,098,700 QSC Bonds $1,600,000 $0 $1,600,000 Alternative Financing $478,000 $0 $478,000 Total Project Funding $3,438,355 ($7,500) $3,430,855 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Roofing $3,438,355 ($7,500) $3,430,855 Total Costs $3,438,355 ($7,500) $3,430,855 Indoor Air Quality (-$10,193) - Project # 51019 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised From General Fund $15,000 ($10,193) $4,807 Total Project Funding $15,000 ($10,193) $4,807 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Construction $15,000 ($10,193) $4,807 Total Costs $15,000 ($10,193) $4,807 District Wide Improvements (-$258) - Project # 51021 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised From General Fund $200,000 $0 $200,000 Appropriated Fund Balance $47,745 ($258) $47,487 Total Project Funding $247,745 ($258) $247,487 9 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Construction $247,745 ($258) $247,487 Total Costs $247,745 ($258) $247,487 Bathroom Renovations (-$75,218) - Project # 51023 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Lottery Proceeds $180,532 ($75,218) $105,314 Total Project Funding $180,532 ($75,218) $105,314 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised General Renovations $180,532 ($75,218) $105,314 Total Costs $180,532 ($75,218) $105,314 Fire/Safety/Upgrades (-$89,642) - Project # 51024 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised 2/3 Net Debt Bonds $35,000 $0 $35,000 Lottery Proceeds $250,000 $0 $250,000 From General Fund $962,117 ($89,642) $872,475 Total Project Funding $1,247,117 ($89,642) $1,157,475 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Emergency/Security Systems $1,247,117 ($89,642) $1,157,475 Total Costs $1,247,117 ($89,642) $1,157,475 Classroom/Building Improvements (-$572,219) - Project # 51025 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised 2/3 Net Debt Bonds $289,500 $0 $289,500 From General Fund $1,349,888 ($572,219) $777,669 QSC Bonds $2,946,819 $0 $2,946,819 Alternative Financing $508,100 $0 $508,100 Total Project Funding $5,094,307 ($572,219) $4,522,088 10 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Construction $5,094,307 ($572,219) $4,522,088 Total Costs $5,094,307 ($572,219) $4,522,088 Window Replacements (-$1,542) - Project # 51026 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised 2/3 Net Debt Bonds $30,000 $0 $30,000 From General Fund $360,000 ($1,542) $358,458 Total Project Funding $390,000 ($1,542) $388,458 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Construction $390,000 ($1,542) $388,458 Total Costs $390,000 ($1,542) $388,458 Athletic Facilities (-$230,708) - Project # 51027 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised 2/3 Net Debt Bonds $67,500 $0 $67,500 From General Fund $951,067 ($230,708) $720,359 Total Project Funding $1,018,567 ($230,708) $787,859 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised General Renovations $1,018,567 ($230,708) $787,859 Total Costs $1,018,567 ($230,708) $787,859 Mechanical Systems (-$31,226) - Project # 51029 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised From General Fund $450,000 ($31,226) $418,774 Total Project Funding $450,000 ($31,226) $418,774 11 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Equipment $450,000 ($31,226) $418,774 Total Costs $450,000 ($31,226) $418,774 Paving/Parking Lot Improvements (-$15,281) - Project # 51030 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised 2/3 Net Debt Bonds $150,000 $0 $150,000 From General Fund $218,281 ($15,281) $203,000 Total Project Funding $368,281 ($15,281) $353,000 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Construction $368,281 ($15,281) $353,000 Total Costs $368,281 ($15,281) $353,000 Doors/Windows/Canopies (-$220,000) - Project # 51037 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised 2016 Bonds $220,000 ($220,000) $0 Total Project Funding $220,000 ($220,000) $0 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Construction $220,000 ($220,000) $0 Total Costs $220,000 ($220,000) $0 Mechanical Systems – 2016 Bond Project ($1,463,403) - Project # 51038 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised 2016 Bonds $8,900,000 $220,000 $9,120,000 From General Fund $0 $1,118,185 $1,118,185 Lottery Proceeds $0 $75,218 $75,218 2/3 Net Debt Bonds $0 $50,000 $50,000 Total Project Funding $8,900,000 $1,463,403 $10,363,403 12 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Equipment $8,900,000 $1,463,403 $10,363,403 Total Costs $8,900,000 $1,463,403 $10,363,403 SOCIAL JUSTICE IMPACT: There are no Orange County Social Justice Goals associated with this item. Sheriff’s Office 17. The Sheriff’s Office has the following year-end adjustments that are needed in the Jail Inmate Fund and the Drug Forfeiture Fund, as well as the receipt of a grant award: • The Jail Inmate Fund is a fiduciary fund and all remaining funds should be transferred out of the fund to either a special revenue fund or to the General Fund and reported as revenues of the County and used to track expenditures for equipment needs or providing indigent services to the inmates. The Sheriff’s Office recommends using current remaining funds of $84,732 in the following manner: (1) Increase the current Jail Nurse contract with Southern Health Partners from 12 hours per day, 7 days per week to 18 hours per day, 7 days per week, at an annual cost of $60,540; and (2) Designate the remaining $24,192 in Committed Fund Balance within the General Fund for use in FY 2018-19. This budget amendment provides for the transfer of funds totaling $84,732 from the Jail Inmate Fund to the General Fund for the above stated purposes. • The Drug Forfeiture Fund was established in FY 2015-16 to record Federal and State Forfeiture funds, and to account for the receipt and disbursement of these funds. This budget amendment provides for the budgeting of these funds in the amount of $888,233 in order to receive the funds and to establish appropriation authorization for the expenditure of these funds. • The Sheriff’s Office has received notification of a Grant award of $2,500 from the Alzheimer’s Foundation of America to help those affected by Alzheimer’s and other dementia related illnesses. These funds will be used to support training and equipment needs for the life track program (to track walk off patients). This budget amendment provides for the receipt of these grant funds. This budget amendment provides for these year-end adjustments, as well as the receipt of the grant funds (See Attachment 1, column 16) SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goal is applicable to these agenda items: • GOAL: CREATE A SAFE COMMUNITY The reduction of risks from vehicle/traffic accidents, childhood and senior injuries, gang activity, substance abuse and domestic violence. 13 Vehicle Replacement Fund 18. The Approved FY 2017-18 Budget Ordinance included a financial plan for the Vehicle Replacement Internal Service Fund of projected revenues/proceeds and expenses of $757,514. This budget amendment provides for a revised financial plan of projected revenues/proceeds and working capital, and expenses of $1,380,833, and closes out the Vehicle Replacement Internal Service Fund in FY 2017-18. Income and expenses will be transferred to the General Fund, and Assets and Liabilities will be transferred to the Long Term Debt Fund and the Fixed Assets Fund. All future proceeds and expenditures will be accounted for through the County Capital Fund. (See Attachment 1, column 17) SOCIAL JUSTICE IMPACT: There are no Orange County Social Justice Goals associated with this item. Orange County Food Council 19. Receipt of $2,000 ($1,000 each from the Town of Chapel Hill and Town of Hillsborough) as per the Human Services Performance Agreement with the towns. These are pass- through funds to the Orange County Food Council for program related expenses. This budget amendment provides for the receipt of these funds on behalf of the Orange County Food Council (See Attachment 1, column 18) SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goal is applicable to these agenda items: • GOAL: ENSURE ECONOMIC SELF-SUFFICIENCY The creation and preservation of infrastructure, policies, programs, and funding necessary for residents to provide shelter, food, clothing, and medical care for themselves and their dependents. Health and Dental Insurance Fund 20. The Approved FY 2017-18 Budget Ordinance included financial plans for the Health Insurance Fund of $9,435,744 and the Dental Insurance Fund of projected receipts and expenses of $521,054. This budget amendment provides for a revised financial plan for FY 2017-18 of projected receipts and expenses of $10,010,550 for the Health Insurance Fund, and projected receipts and expenses of $525,759 for the Dental Insurance Fund, given the annual activity of the fund. SOCIAL JUSTICE IMPACT: There are no Orange County Social Justice Goals associated with this item. Historic Rogers Road Infrastructure Capital Project/Community Loan Fund 21. This budget amendment provides for the transfer of $200,000 from the Historic Rogers Road Neighborhood Infrastructure Capital Project to the Community Loan Fund to 14 support County-wide no interest loans for sewer connection. The loans will range from $3,500 to $10,000 with a 10 year repayment. Per the Community Loan terms, the loan is secured by a deed of trust and the borrowed loans will be itemized on the recipient’s annual County tax bill for the annual payment. This budget amendment provides for the transfer of these funds, and amends the following Capital Project Ordinance: Historic Rogers Road Neighborhood Infrastructure (-$200,000) - Project # 10054 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Alternative Financing $6,492,000 ($200,000) $6,292,000 Contribution from Chapel Hill $77,400 $0 $77,400 Contribution from Carrboro $25,200 $0 $25,200 From General Fund $77,400 $0 $77,400 Total Project Funding $6,672,000 ($200,000) $6,472,000 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Land and Associated Costs $212,000 $0 $212,000 Professional Services $780,000 $0 $780,000 Construction $5,205,000 ($200,000) $5,005,000 Project Management $475,000 $0 $475,000 Total Costs $6,672,000 ($200,000) $6,472,000 SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goal is applicable to these agenda items: • GOAL: ENSURE ECONOMIC SELF-SUFFICIENCY The creation and preservation of infrastructure, policies, programs, and funding necessary for residents to provide shelter, food, clothing, and medical care for themselves and their dependents. FINANCIAL IMPACT: Financial impacts are included in the background information above. This budget amendment provides for the receipt of these additional funds and increases the FY 2017-18 budgets in the General Fund by $677,940, the County Capital Projects Fund by $920,025, the Community Spay/Neuter Fund by $2,520, the Grant Projects fund by $306,785, the Housing Voucher Fund by $280,601, the Drug Forfeiture Fund by $888,233, the Health and Dental Fund by $579,511, and the Community Loan Fund by $200,000; and decreases the FY 2017-18 budgets in the E911 Fund by $44,449, the Jail Inmate Fund by $84,732, the Fire Districts Fund by $48,000, and the Vehicle Replacement Fund by $1,380,833. RECOMMENDATION(S): The Manager recommends the Board approve budget, capital, and grant project ordinance amendments for fiscal year 2017-18. 15 Attachment 1. Orange County Proposed 2017 -18 Budget Amendment The 2017 -18 Orange County Budget Ordinance is amended as follows: Exoenditures Community Relations - Public Affairs $ 291,874 $ 4,110 $ 295,984 $ 295,984 #11 ibrary Services - #4' Department on Aging Finance and Administrative Services $ 1,405,885 $ 1,405,885 $ 1,405,885 2. Health Department- Additienal Revenue: -Addiordal HCCBG Asset Management Services $ 4,541,095 $ 181,088 $ 4,722,183 $ 4,722,183 1. Depertrnent on Aging- receipt of $300,000 $2,d Smart Start funds from TJCOG Human Resources $ 935,443 $ 14,365 $ 949,808 $ 949,808 receept of donated funds $2,520 in the Kenan Charitable Trust Grant; Food and $675 from Orange $675m $11 016 for Passmore furnishings; Information Technologies $ 3,328,135 Encumbrance $ 3,376,498 Budget Amended of atltlitional County r atltlitional Non-Departmental Original Budget Carry Forwards Budget as Amended Through BOA #9 Through Spay/Neuter Fund, and donated funds. and Lodging funds of $5,224; Young Chiltlron for Time hild -rfor Time r ue of $3,550 for in' Operation Fan Support Services $ 14,101,197 $ 259,608 $ 14,360,805 $ 14,360,805 receipt of of $2,8 3 for use in the and additional Medicaid Cast to Read p roject training Program; and additional County Commissioners $ 913,708 $ 4,620 $ 918,328 $ 918,328 Animal Sheller Ani Settlement funds of e e a techniques W teach anfidpated revenue of Court Attome $ 590,669 $ 590,669 $ 590,669 $1,096,134 children to mad $4085from Wellness Count Manager's Office $ 2,821,481 $ 5,388 $ 2,826,869 $ 2,826,869 class fees General Fund $ 830,014 $ 830,014 $ 830,014 Revenue Register ister of Deeds $ 985,215 Property Taxes $ 151,557,768 $ $ 151,557,768 $ 151,557,768 $ $ $ $ Sales Taxes $ 23,566,784 $ $ 23,566,784 $ 23,566,784 $ $ $ $ License and Permits $ 328,000 $ $ 328,000 $ 328,000 $ $ $ $ Intergovernmental $ 16,035,147 $ $ 16,035,147 $ 18,150,914 $ $ 5,224 $ $ 14,566 Charges for Service $ 11,551,045 $ $ 11,551,045 $ 11,564,353 $ $ $ $ Investment Earnings $ 265,000 $ 2,893 $ 265,000 $ 265,000 $ $ $ $ Miscellaneous $ 2,817,629 $ 2,817,629 E 3,000,223 $ 2,893 Coo erative Extension $ 384,780 $ 750 Transfers from Other Funds $ 3,765,600 $ 3,765,600 $ 3,937,046 Economic Development $ 578,725 $ 3,000 Fund Balance $ 9,769,060 $ 1,313,300 $ 11,082,360 1 $ 11,143,693 DEAPR $ 4,073,800 $ 80,786 Total General Fund Revenues $ 219,656,033 $ 1,313,300 $ 220,969,333 1 $ 223,513,781 $ 2,893 $ 5,224 $ $ 14,586 Exoenditures Community Relations - Public Affairs $ 291,874 $ 4,110 $ 295,984 $ 295,984 Finance and Administrative Services $ 1,405,885 $ 1,405,885 $ 1,405,885 Asset Management Services $ 4,541,095 $ 181,088 $ 4,722,183 $ 4,722,183 Human Resources $ 935,443 $ 14,365 $ 949,808 $ 949,808 Information Technologies $ 3,328,135 $ 48,363 $ 3,376,498 $ 3,376,498 Non-Departmental $ 3,598,765 $ 11,682 $ 3,610,447 $ 3,610,447 Support Services $ 14,101,197 $ 259,608 $ 14,360,805 $ 14,360,805 $ $ $ $ County Commissioners $ 913,708 $ 4,620 $ 918,328 $ 918,328 Court Attome $ 590,669 $ 590,669 $ 590,669 Count Manager's Office $ 2,821,481 $ 5,388 $ 2,826,869 $ 2,826,869 Board of Elections $ 830,014 $ 830,014 $ 830,014 Register ister of Deeds $ 985,215 $ 985,215 $ 985,215 Tax Administration $ 3,710,504 $ 38,214 $ 3,748,718 $ 3,748,718 County Debt Service $ 11,684,626 $ 11,684,626 $ 11,684,626 Non-Departmental $ 102,500 $ 891 $ 103,391 $ 103,391 $ General Government $ 21,638,717 $ 49,113 $ 21,687,830 $ 21,687,830 $ $ $ $ Animal Services $ 2,095,292 $ 10,838 $ 2,106,130 $ 2,109,130 $ 2,893 Oran a Public Transportation $ 1,586,943 $ 1,200 $ 1,588,143 $ 1,605,092 Coo erative Extension $ 384,780 $ 750 $ 385,530 $ 385,530 Economic Development $ 578,725 $ 3,000 $ 581,725 $ 581,725 DEAPR $ 4,073,800 $ 80,786 $ 4,154,586 $ 4,234,112 Planning and Inspections $ 3,134,861 $ 3,461 $ 3,138,322 $ 3,156,122 Non-Departmental $ 2,477,573 $ 64,684 $ 2,542,257 $ 2,543,257 Community Services $ 14,331,974 $ 164,719 $ 14,496,693 $ 14,614,968 $ 2,893 $ $ $ Department of Social Services $ 18,772,740 $ 151,211 $ 18,923,951 $ 19,458,286 Health $ 9,912,099 $ 149,734 $ 10,061,833 $ 10,437,799 $ 5,224 Cardinal Innovations MOE $ 1,050,187 $ 1,050,187 $ 1,050,187 Department on Aging $ 2,092,869 1 $ 51,655 $ 2,144,524 $ 2,326,818 $ 14;566 Child Support Services $ 1,062,393 $ 1,062,393 $ 1,062,393 Housing, Human Ri hts & Comm Dev $ 386,298 $ 37,554 $ 423,852 $ 37,555 Human Rights and Relations $ 308,817 Library Services $ 2,243,717 $ 2,243,717 $ 2,258,465 Non-Departmental $ 1.,988,165 $ 1,988,165 $ 1,991,165 Human Services $ 37,508,468 $ 390,154 $ 37,898,622 $ 38,931,485 $ $ 5,224 $ $ 14,566 Courts $ 70,000 $ 70,000 $ 70,000 Criminal Justice Resource Department $ 481,432 $ 481,432 $ 517,599 Sheriff $ 13,638,496 $ 240,302 $ 13,878,798 $ 13,973,848 Emergency Services $ 10,975,924 $ 209,404 $ 11,185,328 $ 11,185,328 Non Departmental $ 418,047 $ 418,047 $ 418,047 Public Safety 25,5,89 $ 449,706 $ 26,033,605 $ 6994508 $ $ $ Education $ 10491508 $ 104,991,508 $ 1 E E Transfers Out $ 1,500,270 $ 1,500,270 $ 2,762,363 Total General Fund Appropriation $ 219,656,033 $ 1,313,300 $ 220,969,333 $ 223,513,781 $ 2,893 $ 5,224 $ E 14,566 a a a a a a a a 16 Attachment 1. Orange County Proposed 2017 -18 Budget Amendment The 2017 -18 Orange County Budget Ordinance is amended as follows: County Capital Project Fund Revenues Transfer From the General Fund $ 320,000 1 $ 320,000 $ 914,000 $ - #11 ibrary Services - #4' Department on Aging $ Alternative Financing $ $ 2. Health De300,00 t- Additienal Revenue: -Addiordal HCCBG Appropriated Fund Balance $ 1. Depertrnent on Aging- receipt of $300,000 $2,d Smart Start funds from TJCOG Miscellaneous receept of donated funds $2,520 in the Kenan Charitable Tiusl Grant; Footl and $675 from Orange $675m $11 016 for Passmore furnishings; Encumbrance Budget Amended of atltlitional County r atltlitional Original Budget Carry Forwards Budget as Amended Through Through BOA #9 Spay/Neuler Fund, and dmated funds. and Lodging funds of $5,224; Time Young gd hild —rfor Time ue of $3,550 for r the Operation Fan $ 320,000 $ 1,433,621 $ - $ 1,096,134 receipt of of $2,8 ionise i, the and addibond Medicaid Cost F.Jenfor to Read project training Program; and additional Animal Sheller settlement funds of e a techniques W t eac h anfidpated revenue of $1,096,134 children to mad $4085from Wellness class fees County Capital Project Fund Revenues Transfer From the General Fund $ 320,000 1 $ 320,000 $ 914,000 $ - $ - $ - $ Alternative Financing $ $ $ (151,446) Appropriated Fund Balance $ $ $ Miscellaneous I $ - $ 18,500 $ $ 4,200 Medicaid Maximization Funds $ 5,726,068 $ $ $ 666,867 $ $ 1,096,134 $ $ Total Revenues $ 320,000 $ - $ 320,000 $ 1,433,621 $ - $ 1,096,134 $ - $ Expenditures County Capital Projects $ 320,000 E 320,000 $ 1,433,621 $ - $ 1,096,134 $ -Is Fire District Funds Revenues Property Tax $ 5,724,102 1 $ 5,724,102 $ 5,724,102 Intergovernmental $ $ $ Investment Earnings $ 1,966 $ 1,966 $ 1,966 Appropriated Fund Balance I $ - $ 18,500 $ $ 30,000 Total Fire Districts Fund Revenue $ 5,726,068 $ $ 5,726,068 $ 5,756,068 $ $ $ $ Expenditures Remittance to Fire Districts $ 5,726,068 $ 5,726,068 $ 5,756,068 Section 8 Housing Fund Revenues Intergovernmental I $ 4,211,164 1 Is 4,211,164 1 $ 4,211,164 Miscellaneous Transfer from General Fund $ 262,066 $ 262,066 $ 460,230 Appropriated Fund Balance I $ - $ 18,500 1 $ 18,500 1 $ 18,500 Total Housing Fund Revenues I $ 4,473,230 $ 18,500 1 $ 4,491,730 1 $ 4,689,894 1 $ - Is - I $ - I $ Expenditures Housing Fund $ 4,473,230 1 $ 18,500 1 $ 4,491,730 1 $ 4,689,894 17 Attachment 1. Orange County Proposed 2017 -18 Budget Amendment The 2017 -18 Orange County Budget Ordinance is amended as follows: Emergency Telephone System Fund Revenues Charges for Services $ 595,350 $ 595,350 $ 595,350 #11 ibrary Services - #4' Department on Aging Grant Funds $ $ 217,457 $ 2. Health Department - Adtlilional Revenue; -Addiontal HCCBG $ 4,085 From General Fund $ 1. Department on Aging- 300,00 receipt of $300,000 $2'205 from Smart Start funds from TJCOG Appropriated Fund Balance recieptNdonated funds $2,520 in the Kenan Charitable Tiusl Grant; Footl and from Orange $11016 for Passmcm furnishings; $ - Encumbrance $ - Budget as Amended of atltlitional County Partnership far my P atltlitional Original Budget Carry Forwards gadget as Amended Through BO SpayMeuler Fund, and mcant dmated funds. and Lodging funds of $5,224; Youngd Time ue of $3,550 for rihe Operation Fan 1 $ 2,731 $ 2,731 of of $2,8 far use it the and additional Medicaid Cast Frpienfor to Read project training Program; and additional 1 $ 2,731 1 $ 2,343,512 $ 678,302 $ - Animal Animal Sheller Battlement funds of ehilticare provitlers techniques W teach anticipated revenue of $ - $ $ $1,096,134 chiltlren to reatl $4085 from Wellness Growing New Fanners Grant $ $ class fees Emergency Telephone System Fund Revenues Charges for Services $ 595,350 $ 595,350 $ 595,350 $ 300,000 $ 2,025 Grant Funds $ $ 217,457 $ $ $ 4,085 From General Fund $ $ $ Appropriated Fund Balance $ 158,110 $ 19,079 $ 177,189 $ 177,189 $ - $ - $ - $ Total Revenues $ 753,460 $ 19,079 $ 772,539 $ 772,539 $ - $ - $ - $ Expenditures Emergency Telephone System Fund $ 753,460 1 $ 19,079 $ 772,539 $ 772,539 Vehicle Replacement Fund Rev Charges for Services $ $ $ $ 300,000 $ 2,025 Appropriated Fund Balance $ - $ 217,457 $ 217,457 $ 217,457 $ 4,085 Debt Financing $ 757,514 $ 757,514 $ 757,514 Total Vehicle Replacement Fund Revenues $ 757,514 $ 217,457 $ 974,971 $ 974,971 $ - $ - $ - $ Expenditures Vehicle Replacement Fund $ 757,514 1 $ 217,45*11 $ 974,971 $ 974,971 Grant Project Fund Revenues Intergovernmental $ 2,147,149 $ 2,147,149 $ 734,895 $ 300,000 $ 2,025 Charges for Services $ 65,000 $ 65,000 $ 85,000 $ 4,085 Transfer from General Fund $ 128,632 $ 128,632 $ 55,676 Miscellaneous $ - $ - $ $ $ 675 Transfer from Other Funds $ - $ $ Appropriated Fund Balance $ - I $ 2,731 1 $ 2,731 $ 2,731 Total Revenues $ 2,340,781 1 $ 2,731 1 $ 2,343,512 $ 678,302 $ - $ 300,000 $ 2,700 $ 4,085 Exrendlturea NCACC Employee Wellness Grant $ $ CFAT Propane Vehicle Grant(multi-year) $ $ Electric Vehicle Charging Stations $ $ Support Services $ - $ - $ - $ NPDES Grant (Multi -year) $ - $ $ Orange- Alamance Connector (3 year) $ - $ $ NC Tomorrow CDBG (Multi-year) $ - $ $ Jordan Lake Watershed Nutrient Grant $ - $ $ Growing New Fanners Grant $ $ Historic Resources Inventory Grant $ $ USDA Rural Business Development Grant $ $ Golden LEAF Foundation Grant $ 128,000 Community Services $ $ - $ $ 128,000 $ - $ - $ - $ Parent Ed Initiative - DSS (Multi -year) $ 73,740 $ 73,740 $ Child Care Subsidy - DSS (Multi -year) $ 219,858 $ 219,858 $ Carrboro Growing Healthy Kids Grant $ $ Healthy Carolinians $ $ Health & Wellness Trust Grant $ $ Senior Citizen Health Promotion Wellness $ 135,676 $ 2,731 $ 138,407 $ 166,157 $ 4,085 CARES Grant - Aging(Multi -Year) $ 339,708 $ 339,708 $ 339,708 Dental Health - Smart Start $ $ Intensive Home Visiting $ $ Medical Reserve Corps - NACCHO $ $ Human Rights & Relations HUD Grant $ $ Senior Citizen Health Promotion (Mulb-Yr) $ $ SeniorNet Program (Multi-Year) $ $ Enhanced Child Services Coord -SS $ $ Diabetes Education Program (Multi -Year) $ $ Specialty Crops Grant $ $ Local Food Initiatives Grant $ $ Reducing Health Disparities Grant (Multi -Yr) $ $ Triple P Initiative Grant (Multi -Yr) $ $ Meaningful Use Incentive Grant (Multi-Yr) $ $ Emergency Solutions Grant - DSS(Multi -Yr) $ $ 25,000 FY 2009 Recovery Act HPRP $ $ Community Response Program - DSS (Mull $ 204,833 $ 204,833 $ Susan G Komen Grant I $ $ i Attachment 1. Orange County Proposed 2017 -18 Budget Amendment The 2017 -18 Orange County Budget Ordinance is amended as follows: 19 #11 ibrary Services - #4' Department on Aging 2. Health De300,00 t- Additienal Revenue: -Addiordal HCCBG 1. Depertinent on Aging- receipt of $300,000 $2,m Smart Start funds from TJCOG receept of donated funds $2,520 in the Kenan Charitable Tiusl Grant; Footl and d $675 $675 from Orange $11 016 for Passmcre furnishings; Encumbrance Budget Amended of etltlitional County r atltlitional Original Budget Carry Forwards Budget as Amended Through Through BOA #9 Spay/Neuler Fund, and donated funds. and Lodging funds of $5,224; Time hild —rfor Time YoungdF ue of $3,550 for r the Operation Fan receipt of of $2,8 ionise i the and additional Medicaid Cost jenfor to Read project training Program; and additional Animal Sheller , settlement funds of e e a techniques W teach anfidpated revenue of $1,096,134 children to mad $4085from Wellness class fees Kenan Charitable Trust Grant $ $ 300,000 Building Futures Program - DSS (Multi -Yr) $ 970,470 $ 970,470 $ Foster Youth Opportunities -DSS (Multi -yea $ 60,000 $ 60,000 $ WIOA Adult Dislocated Worker Grt-DSS $ 255,298 $ 255,298 $ Outreach Literacy Time to Read - Library $ 81,198 $ 81,198 $ 52,832 $ 2,700 Outreach Literacy MotheRead- Library $ 23,791 Human Services $ 2,340,781 $ 2,731 $ 2,343,512 $ 607,488 $ - $ 300,000 $ 2,700 $ 4,085 Hazard Mitigation Generator Project $ $ Buffer Zone Protection Program $ $ 800 MHz Communications Transition $ $ Secure Our Schools - OCS Grant $ $ Citizen Corps Council Grant $ $ COPS 2008 Technology Program $ $ COPS 2009 Technology Program $ $ EM Performance. Grant $ 142,814 2010 Homeland Security Grant - ES $ 2011 Homeland Security Grant - ES $ $ Justice Assistance Act (JAG) Program $ $ FEMA Assistance to Firefighters Grant $ $ Public Safety $ - $ - $ - $ 142,814 $ - $ - $ - $ Total Expenditures $ 2,340,781 $ 2,731 $ 2,343,512 $ 878,302 $ - $ 300,000 $ 2,700 $ 4,085 19 Attachment 1. Orange County Proposed 2017 -18 Budget Amendment The 2017 -18 Orange County Budget Ordinance is amended as follows: Jail Inmate Fund Revenues #11 ibrary Services - #4' Department on Aging Appropriated Fund Balance $ $ $ 10,000 2. Health De300,00 t Additienal Revenue: -Addiordal HCCBG Total Revenues Is I $ $ - Is - Is 10,000 1 $ - $ - $ - $ Expenditures 1. Depertinent on Aging- receipt of $300,000 $2,m Smart Start funds from TJCOG Transfer to General Fund 1 $ receept of donated funds $2,520 in the Kenan Charitable Tiusl Grant; Footl and d $675 $675 from Orange $11 016 for Passmore furnishings; $ - Encumbrance Drug Forfeiture Fund Revenues Budget Amended of atltlitional County r atltlitional Original Budget Carry Forwards Budget as Amended Through Through BOA #9 Spay/Neuler Fund, and donated funds. and Lodging funds of $5,224; Young Chiltlren for Time hild —rfor Time ue of $3,550 for r the Operation Fan $ - $ - $ State Forfeiture Funds receipt of of $2,8 3 for use in the and additional Medicaid Cost to Read project " Program; and additional Animal Sheller Ani Settlement funds of e a techniques W t eac h anfidpated revenue of $ d $ - $ - $ - $ $1,096,134 children to mad $4085from Wellness Transfer to General Fund $ class fees Jail Inmate Fund Revenues Appropriated Fund Balance $ $ $ 10,000 $ - $ - -is Total Revenues Is I $ $ - Is - Is 10,000 1 $ - $ - $ - $ Expenditures Transfer to General Fund 1 $ a Is 10,000 1 $ - $ - I $ - $ Drug Forfeiture Fund Revenues Federal Forfeiture Funds $ $ E $ - $ - $ - $ State Forfeiture Funds Total Revenues $ - $ d $ d $ d $ - $ - $ - $ Expenditures Transfer to General Fund $ $ b $ - $ - $ - $ 20 Attachment 1. Orange County The 2017 -18 Orange County Bud 21 Expenditures Community Relations - Public Affairs #6. Allacation to $ 2,183 #10. Allocation to $ 1,431 Finance and Administrative Services Deparbnents of V. Allocation from #8. Allocation to #9. Allocation W Departraents of #11. Allocation to # 12 Technical Asset Management Services #5. Housing $1,492,651 for Wage Departments for Salary DeparMienis of Departments of $94,410 $188,481 for Salary Departinenis for He Amentlmen[ -SOpal Human Resources Department of inaeas e and employee Savings of $2,000,000 $600,000 to match for Living Wage Compression Insurance lncreasen of Services - transfers Information Technologies E) funds additional HUD funds of performance awartls budgeted in a Support employees' 401 k match Increase budgeted in adjustments budgeted in $524,433 budgeted in a $23.891 from the Non-Departmental $280,601 budgeted in Support Services Non- budgeted in Support Support Services Non- Support Services Nan- Support Services Non - General Fund the Support Services $ S -i Service Non- Depar net account in Services IN Departrnental account Departrnental account In Departmental account Infomution Technology at County Commissioners Departmental account in FY 201 FY 2017 -18 Deparmental account FY 2017 -1 B $ 5,283 Capital Projects Fund County Attorney FY 2017 -18 $ 4,340 $ 2,412 General Fund $ 17,563 $ 7,013 $ 370 $ 3,225 Board of Elections $ 8,838 $ 4,999 $ 2,289 $ 126 $ 2,745 Revenue Register of Deeds $ 26,044 $ 10 042 $ 15,183 $ 2,009 $ 8,075 Property Taxes $ $ $ $ $ $ $ $ Sales Taxes $ $ $ $ $ $ $ $ License and Permits $ $ $ $ $ $ $ $ Intergovernmental $ $ $ $ $ $ $ $ Charges for Service $ $ $ $ $ $ $ $ Investment Earnings $ $ $ $ $ $ $ $ Miscellaneous Cooperative Extension Transfers from Other Funds Economic Development $ 16,808 $ 4,718 $ 1,390 $ 2,834 Fund Balance DEAPR $ 69,557 $ 46,838 $ 29,641 $ 18,663 $ 4,701 $ 17,881 Total General Fund Revenues $ $ $ $ $ $ $ $ Expenditures Community Relations - Public Affairs $ 5,386 $ 2,183 $ 1,431 Finance and Administrative Services $ 27,469 $ 17914 $ 11,662 $ 1,884 $ 8,759 Asset Management Services $ 65,210 $ 49,233 $ 26,555 $ 3,746 $ 6,599 $ 21,759 Human Resources $ 21,053 $ 23799 $ 9,248 $ 100 $ 5,155 Information Technologies $ 35,447 $ 34,033 $ 12,674 $ 232 $ 10,658 Non-Departmental $ 1,492,651 $ 2,000,000 $ 600000 $ 94,410 $ 188,481 $ 524433 Support Services $ $ (1,338,086) $ 1,875,021 $ (537,678) $ (90,665) $ (179,666) $ (476,671) $ County Commissioners $ 16308 $ 6,149 $ 10,178 $ 282 $ 5,283 County Attorney $ 11,683 $ 4,340 $ 2,412 County Managers Office $ 17,563 $ 7,013 $ 370 $ 3,225 Board of Elections $ 8,838 $ 4,999 $ 2,289 $ 126 $ 2,745 Register of Deeds $ 26,044 $ 10 042 $ 15,183 $ 2,009 $ 8,075 Tax Administration $ 80,641 $ 31780 $ 30,958 $ 802 $ 9,557 $ 25,277 County Debt Service Non-Departmental General Government $ $ 161,077 $ (47,971) $ 72,671 $ 3,091 $ 12,344 $ 47,017 $ Animal Services $ 38,578 $ 73 510 $ 17,177 $ 4,813 $ 5,265 $ 16,271 Orange Public Transportation $ 27,110 $ 162 244 $ 12,087 $ 4,665 $ 227 $ 10,955 Cooperative Extension Economic Development $ 16,808 $ 4,718 $ 1,390 $ 2,834 DEAPR $ 69,557 $ 46,838 $ 29,641 $ 18,663 $ 4,701 $ 17,881 Planning and Inspections $ 68,155 $ 92,788 $ 30,701 $ 5,062 $ 19,420 Non-Departmental Community Services $ $ 220,208 $ (375,380) $ 94,324 $ 28,142 $ 16,645 $ 67,361 $ Department of Social Services $ 276,720 $ (437,064) $ 115,953 $ 15,783 $ 37,383 $ 99,198 $ 23,891 Health $ 185,107 $ (348,786) $ 77,422 $ 5,868 $ 15,991 $ 60,015 Cardinal Innovations MOE Department on Aging $ 31,333 $ 19,443 $ 19,453 $ 2,509 $ 6,986 $ 11,699 Child Support Services $ 20,319 1 $ 10,986 $ 4,686 $ 7,678 Housing, Human Rights & Comm Dev Human Riqhts and Relations $ 6,031 $ (37,189) $ 2,565 $ 385 $ 1,753 Library Services $ 46,129 $ 32,188 $ 19,814 $ 1,338 $ 3,765 $ 14,794 Non-Departmental Human Services $ $ 565,639 $ (874,670) $ 246,193 $ 25,498 $ 69,196 $ 195,137 $ (23,891) Courts Criminal Justice Resource Department $ 8,090 $ 24,141 $ 5,233 $ 3,122 Sheriff $ 202,719 $ 220106 $ 27,754 $ 24,422 $ 61,407 $ 89,294 Emergency Services $ 180,353 $ (332,753)1 $ 91,503 $ 9,511 $ 20,074 $ 74,740 Non Departmental Public Safety $ $ 391,162 $ (577,000) $ 124,490 $ 33,933 $ 81,481 $ 167,156 $ Education $ $ $ $ $ 8 $ E Transfers Out 1 $ 23,891 Total General Fund Appropriation $ $ $ $ $ (0) E E $ Attachment 1. Orange County The 2017 -18 Orange County Bud County Capital Project Fund Rev Transfer From the General Fund #6. Allocation to $ - $ - $ - #10. Allocation to Deparbnents of V. Allocation from It& Allocation to #9. Allocation to Departraents of #11. Allocation to # 12 Technical #5. Housing $1,492,651 for Wage Depanmenls for Salary DeparMients of Departments of $94,410 $188,481 for Salary Departrnenis for Heatih Amentlmen[ -SOpal D. ant of inaeas e and employee Savings of $2,000,000 $600,000 to match for Living Wage Compression Insurance Increase of Services - transfers additional HUD funds of HUD —rd pudoeted budgeted in a Support employees' 401 k match Increase budgeted in adjustments budgeted i- budgeted in a $23.891 from the $280,601 in Support budgeted in Support Services Non- budgeted in Support Support 8ervlces Non- Support 8ervlces Nan- Support Support Services Non - General Fund to the $ - Service Non- Depar account in Services Non- Departrnental account Deparl account In Departmental account Information Technology Departmental account in FY 201 FY 2017 -18 Deparmental account FY 201rojects FY 2017 -1 B Capital P Fund FY 201] -16 County Capital Project Fund Rev Transfer From the General Fund $ $ - $ - $ - $ Alternative Financing Appropriated Fund Balance Miscellaneous Medicaid Maximization Funds $ $ $ $ E S $ $ Total Revenues $ - $ - $ - $ - $ - $ - $ - $ Expenditures County Capital Projects $ - $ - $ - $ - $ - $ Fire District Funds Rev Property Tax $ 280,601 Intergovernmental Investment Earnings Appropriated Fund Balance Total Fire Districts Fund Revenue $ $ $ $ E S $ $ Expenditures Remittance to Fire Districts Section 8 Housing Fund Rev Intergovernmental $ 280,601 Miscellaneous Transfer from General Fund Appropriated Fund Balance Total Housing Fund Revenues $ 280,601 $ Expenditures Housing Fund $ 280,601 PA Attachment 1. Orange County The 2017 -18 Orange County Bud Emergency Telephone System Fund Revenues #6. Allocation to Departments of #]. Allocation fmm #8. Allocation to - #10. Allocation to - # 12 Technical -- $1,492,651 far Wage Departments for Salary Departments of #9. Allocation to Departments of #1 i. Allocation to Amendment- Social #5. Housing incr se antl employee ez Savingsd $2,000,000 $600,000to match Departments of $94,410 $188,481 for Salary Departments for Health Services - transfers Department - receipt of performance awards budgeted In a Support employees'h match for Living Wage Compression Insurance increase of $23,891 from He additional HUD funds of butlgetetl in Support Services Non- S,, budgetetl in Support mcrease budgeted in adjustments budgeted in $524,433 Wdgeletl in a General Funtl to the $280,601 Service Non- Departmental account in Services No $UPPOrt Services Non- Departmental Support Services Non- Departmental in Support Services Non - Departmental Information Technology $ - Departmental account in FY 2017-18 Departmental account account account account Capital Projects Fund FY 2017-18 FY 2017 -18 Emergency Telephone System Fund Revenues Expenditures Emergency Telephone System Fund Vehicle Replacement Fund Revenues Charges for Services 'Grant Funds -- - - - - -- Debt Financing -------- Total Vehicle Replacement Fund Revenues -------- $ - $ - $ - $ - $ - $ - $ Transfer from Other Funds Expenditures Emergency Telephone System Fund Vehicle Replacement Fund Revenues Charges for Services Appropriated Fund Balance Debt Financing Total Vehicle Replacement Fund Revenues $ - $ - $ - $ - $ - $ - $ - $ Expenditures Vehicle Replacement Fund Grant Project Fund Revenues Intergovernmental Charges for Services Transfer from General Fund Miscellaneous $ - $ - $ - $ - $ - $ - $ - $ Transfer from Other Funds Appropriated Fund Balance Total Revenues $ - $ - $ - $ - $ - $ - $ - $ Fxnendilrmes NCACC Employee Wellness Grant CFAT Propane Vehicle Grant(multi -year) Electric Vehicle Charging Stations Support Services $ - $ - $ - $ - $ - $ - $ - $ NPDES Grant (Multi -year) Orange- Alamance Connector (3 year) NC Tomorrow CDBG (Multi -year) Jordan Lake Watershed Nutrient Grant Growing New Farmers Grant Historic Resources Inventory Grant USDA Rural Business Development Grant Golden LEAF Foundation Grant Community Services $ - $ - $ - $ - $ - $ - $ - $ Parent Ed Initiative - DSS (Multi -year) Child Care Subsidy - DSS (Multi -year) Carrboro Growing Healthy Kids Grant Healthy Carolinians Health & Wellness Trust Grant Senior Citizen Health Promotion(Wellness CARES Grant -Aging (Multi -Year) Dental Health - Smart Start Intensive Home Visiting Medical Reserve Corps - NACCHO Human Rights & Relations HUD Grant Senior Citizen Health Promotion (Multi -Yr) SeniorNet Program (Multi -Year) Enhanced Child Services Coord -SS Diabetes Education Program (Multi -Year) Specialty Crops Grant Local Food Initiatives Grant Reducing Health Disparities Grant (Multi -Y Triple P Initiative Grant (Multi -Yr) Meaningful Use Incentive Grant (Multi -Yr) Emergency Solutions Grant - DSS (Multi - FY 2009 Recovery Act HPRP Community Response Program - DSS (Mt 23 Attachment 1. Orange County The 2017 -18 Orange County Bud PzI #5. Housing Department E) funds of additional HUD funds of $280,601 #6. Allacation to Doparbnents of $1,492,651 for Wage inaeas e and employee pertormance awartls budgeted S —i in Support Service Non- Departmental account in FY 2017 -18 V. Allocation from Departments for Salary Savings of $2,000,000 budgeted in a Support Services Non- net Depar, FY 201 account in FY 2017 -18 #8. Allocation to Deparments of $600,000 to match employees' 401 k match budgeted in Support Services IN Deparmental account #9. Allocation W Departments of $94,410 for Living Wage Increase budgeted in Support Services Non- Departrnental account #10. Allocation to Departraents of $188,481 for Salary Compression adjustments budgeted in Support Services Nan- Departmental account In FY 2017 -1 B #11. Allocation to Departinenis for He of Insurance lncreasen $524,433 budgeted in a Support Services Non - Departmental account # 12 Technical Amentlmen[ -SOpal Services - transfers $23.891 from the General Fund at the Infomal Pe Technology Capital Projects Fund Susan G Komen Grant Kenan Charitable Trust Grant Building Futures Program - DSS (Mulfi -Yr) Foster Youth Opportunities- DSS Multi -ye WIOA Adult Dislocated Worker Grt-DSS Outreach Literacy Time to Read - Library Outreach Literacy MotheRead- Library Human Services $ - $ - $ - $ - $ - $ - $ - $ Hazard Mitigation Generator Project Buffer Zone Protection Program 800 MHz Communications Transition Secure Our Schools - OCS Grant Citizen Corps Council Grant COPS 2008 Technology Program COPS 2009 Technology Program EM Performance Grant 2010 Homeland Security Grant- ES 2011 Homeland Security Grant - ES Justice Assistance Act (JAG) Program FEMA Assistance to Firefighters Grant Public Safety $ - $ - $ - $ - $ - $ - $ - $ Total Expenditures $ - $ - $ - $ - $ - $ - $ - 8 PzI Attachment 1. Orange County The 2017 -18 Orange County Bud Jail Inmate Fund Revenues Appropriated Fund Balance $ - $ - $ $ - $ $ - $ - $ Total Revenues $ - $ - $ - $ - $ - $ - $ - $ Expenditures Transfer to General Fund $ - $ - $ - $ - $ - $ - $ - $ Drug Forfeiture Fund Expenditures Transfer to General Fund 25 #6. Allacation to #10. Allocation to Don nn ents of V. Allocation from #8. Allocation to #9. Allocation W Departraents of #11. Allocation to # 12 Technical #5. Housing $1,492,651 for Wage Departments for Salary Deparments of Departments of $94,410 $188,481 for Salary Departinenis for Heath Amentlmen[ -SOpal Department of inaeas e and employee Savings of $2,000,000 $600,000 to match for Living Wage Compression Insurance lncreeen of Services - transfers E) funds additional HUD funds of performance awartls budgeted in a Support employees' 401 k match Increase budgeted in budgeted i- budgeted in a $23.891 from the $280,601 budgeted in Support Services Non- budgeted in Support Support Services Non- Suppo t Se Support 8ervlces Nan- Support Services Non - Support General Fund the Service Non- dope net account in Services Non- Departrrwntal account Departmental account In Departmental account at Infomution Technology Departmental account in FY 2017 -18 Deparmental account FY 2017 -18 Capital Projects Fund FY 2017 -18 Jail Inmate Fund Revenues Appropriated Fund Balance $ - $ - $ $ - $ $ - $ - $ Total Revenues $ - $ - $ - $ - $ - $ - $ - $ Expenditures Transfer to General Fund $ - $ - $ - $ - $ - $ - $ - $ Drug Forfeiture Fund Expenditures Transfer to General Fund 25 Attachment 1. Orange County The 2017 -18 Orange County Bud 26 Expenditures Community Relations - Public Affairs # 13 Technical #14. Emergency #16. Sheriffs Office- #17. Revised Vehicle # 1B. Orange County $ 304984 Finance and Administrative Services Amendment - Social Telephone System #15. South Omnga Fire Year-end adjustments in Replacment Internal Food Council - receipt $ 1,437,745 Asset Management Services Services - budget re- Fund (E911 Fund) - District0 of the Jail Inmate Fund Service Fund financial of pass - through funds $ 4,796,819 Human Resources purposed funds from fund balance from the $Orang from the South and the Drug Forfeiture plan for FY 2017 -18, totaling $2,000 from the Budget as Amended Information Technologies Grant Prolect closed out apprepmWon of Orange Fire District's Fund, as well as receipt and the closing out of Towns of Chapel HIII Through BOA #10 Non-Departmental on Mamh 20, 2018 to Social Services within $44,449 from the General Fund to the Bailable fund balance a Alzheimer's Foundation afAmedca the Vehicle Replacement internal and Hillsborough for use by the Orange $ 2,710,472 Support Services the General Fund E911 Fund $ grant award of $2,500 Service Fund County Food Council $ 13,613,061 General Fund $ 944,230 County Attorney Revenue County Manager's Office Property Taxes $ $ $ $ $ $ $ 151,557,768 Sales Taxes $ $ $ $ $ $ $ 23,566,784 License and Permits $ $ $ $ $ $ $ 328,000 Intergovernmental $ $ $ $ 2,500 $ $ 2,000 $ 18,175,204 Charges for Service $ $ $ $ $ $ $ 11,564,353 Investment Earnings $ $ $ $ $ $ $ 265,000 Miscellaneous Animal Services i $ 3,003,116 Transfers from Other Funds $ 70,651 $ 84,732 $ 335,000 $ 4,427,429 Fund Balance Cooperative Extension 1 $ 44,449 1 $ 115 1 $ 11,304,067 Total General Fund Revenues $ 70,651 1 $ 44,449 $ $ 87,232 1 $ 450,925 $ 2,000 1 $ 224,191,721 Expenditures Community Relations - Public Affairs $ 304984 Finance and Administrative Services $ 1,437,745 Asset Management Services $ 4,796,819 Human Resources $ 961,565 Information Technologies $ 3,401,476 Non-Departmental $ 2,710,472 Support Services $ $ $ $ $ $ $ 13,613,061 County Commissioners $ 944,230 County Attorney $ 609,104 County Manager's Office $ 2,855,040 Board of Elections $ 849,011 Register of Deeds $ 1,026,4134 Tax Administration $ 3,864,173 County Debt Service 450,925 $ 12,135,551 Non-Departmental $ 103,391 General Government $ $ $ $ $ 450,925 $ $ 22,386,984 Animal Services $ 2,120,617 Orange Public Transportation $ 1,497,892 Cooperative Extension $ 385,530 Economic Development $ 607,475 DEAPR $ 4,327,717 Planning and Inspections $ 3,186,672 Non-Departmental $ 2,543,257 Community Services $ $ $ $ $ $ $ 14,669,161 Department of Social Services $ 70,651 $ 19,613,019 Health $ 10,438,640 Cardinal Innovations MOE $ 1,050,187 Department on Aping $ 2,393,921 Child Support Services $ 1,106,062 Housing, Human Rights & Comm Dev $ 37,555 Human Rights and Relations $ 282,362 Library Services $ 2,312,117 Non-Departmental $ 2,000 $ 1,993,165 Human Services $ 70,651 $ $ $ $ $ 2,000 $ 39,227,028 Courts $ 70,000 Criminal Justice Resource Department $ 509,903 Sheriff $ 2,500 1 14,161838 Emergency Services $ 84,732 $ 11,313,488 Non Departmental $ 418 047 Public Safety $ $ $ $ 87,232 $ $ $ 26,473,276 Education $ $ $ $ $ $ $ 104,991,508 Transfers Out 1 $ 44,449 $ 2,830,703 Total General Fund Appropriation $ 70,651 1 $ 44,449 $ $ 87,232 $ 450,925 $ 2,000 $ 224,191,721 $ $ $ $ $ $ $ t0) Attachment 1. Orange County The 2017 -18 Orange County Bud # 13 Technical #14. Emergency $ - #16. Sheriffs Office - #17. Revised Vehicle # 16. Orange County I $ Amendment - Social Telephone System #15. South Omnge Fire Year-end adjustments in Replacment Internal Food Council - receipt $ 929,908 Services - budget re- Fund (E911 Fund) - District0 of the Jail Inmate Fund Service Fund financial of pass - through funds purposed funds from Grant Prolect fund balance from the $Orang from the South and the Drug Forfeiture Fund, plan for FY 2017 -18, totaling $2,000 from the Towns Chapel HIII Budget as Amended closed out apprepmWon of Orange Fire District's as well as receipt and the closing out of of Through BOA #10 on Mamh 20, 2018 to Social Services within $44,449 from the General Fund to the Bailable fund balance a Alzheimer's Foundation afAmedca the Vehicle Replacement internal and Hillsborough for use by the Orange $ - the General Fund E911 Fund $ - grant award of $2,500 Service Fund County Food Council County Capital Project Fund Rev Transfer From the General Fund $ - $ - $ $ $ - I $ $ 914,000 Alternative Financing $ 929,908 $ 778,462 Appropriated Fund Balance $ 217,457 $ 217,457 Miscellaneous $ 48,000 $ 4,200 Medicaid Maximization Funds $ $ $ 48,000 $ $ $ $ 1,763,001 Total Revenues $ - $ - $ - $ - $ 1,147,365 $ - $ 3,677,120 Expenditures County Capital Projects $ - $ - $ - $ - $ 1,147,365 1 $ Fire District Funds Rev Property Tax $ 5,724,102 Intergovernmental $ Investment Earnings $ 1,966 Appropriated Fund Balance $ 48,000 $ 78,000 Total Fire Districts Fund Revenue $ $ $ 48,000 $ $ $ $ 5,804,068 Expenditures Remittance to Fire Districts $ 48,000 $ 5,804,068 Section 8 Housing Fund Revenues Intergovernmental $ 4,491,765 Miscellaneous $ Transfer from General Fund $ 460,230 Appropriated Fund Balance $ 18,500 Total Housing Fund Revenues $ $ $ $ $ $ $ 4,970,495 Expenditures Housing Fund $ 4,970,495 27 Attachment 1. Orange County The 2017 -18 Orange County Bud # 13 Technical #14. Emergency #16. Sheriff's Office- #17. Revised Vehicle # 18. Orange County Am rd—t- Social Telephone System #imi South Orange Fire Year -end adjustments h Replacmenl Internal Food Council- receipt $ (217,457) Services- butlget re- Fund (E911 Fund)- District - appropriation of the Jail Inmate Fund Service Fund financial of pass - through funtls pure —d funds from furl balance $48,000 from the South and the Drug Forfeiture plan for FY 2017 -18, totaling $2,000 from the Budget a5 Amended Grant Project closed out appropriation of Orange Fire DISMCCS Fund, as well as receipt and the closing out of Towns of Chapel Hill Through BOA #10 9 on March 20, 201810 Social Services within $44,449 from the General Fund to the vailable fund balance of a Alzheimer's Fountlation of America Me Vehicle Replacement Internal antl Hillsborough for se by the Orange the General Fund E911 Fund grant awartl of $2,500 Service Fund County Footl Council Total Revenues Emergency Telephone System Fund Revenues Charges for Services $ $ 595,350 Grant Funds $ (217,457) $ From General Fund $ 44,449 $ (757,514) $ 44,449 Appropriated Fund Balance $ - $ - $ - $ - $ 974,971) $ - $ 177,189 Total Revenues $ $ 44,449 $ $ $ $ $ 816,988 Expenditures Emergency Telephone System Fund $ 44,449 $ 816,988 Vehicle Replacement Fund Revenues Charges for Services $ $ Appropriated Fund Balance $ (217,457) $ Debt Financing $ (757,514) $ Total Vehicle Replacement Fund Revenues $ - $ - $ - $ - $ 974,971) $ - $ Expenditures Vehicle Replacement Fund 1 $ (974,971) $ Grant Project Fund Revenues Intergovernmental $ 1,036,920 Charges for Services $ 89,085 Transfer from General Fund $ 55,676 Miscellaneous $ - $ - $ - $ - $ - $ - $ 675 Transfer from Other Funds $ Appropriated Fund Balance $ 2,731 Total Revenues $ - $ - $ - $ - $ - $ - $ 1,185,087 Fxnendit—.. NCACC Employee Wellness Grant $ CFAT Propane Vehicle Grant(multi -year) $ Electric Vehicle Charging Stations $ Support Services $ - $ - $ - $ - $ - $ - $ NPDES Grant (Multi -year) $ Orange - Alamance Connector (3 year) $ NC Tomorrow CDBG (Multi -year) $ Jordan Lake Watershed Nutrient Grant $ Growing New Farmers Grant $ Historic Resources Inventory Grant $ USDA Rural Business Development Grant $ Golden LEAF Foundation Grant $ 128,000 Community Services $ $ $ $ $ $ $ 128,000 Parent Ed Initiative - DSS (Multi -year) $ Child Care Subsidy - DSS (Multi -year) $ Carrbom Growing Healthy Kids Grant $ Healthy Carolinians $ Health & Wellness Trust Grant $ Senior Citizen Health Promotion(Wellness $ 170,242 CARES Grant - Aging(Multi -Year) $ 339,708 Dental Health - Smart Start $ Intensive Home Visiting $ Medical Reserve Corps- NACCHO $ Human Rights & Relations HUD Grant $ Senior Citizen Health Promotion (Multi -Yr) $ SeniorNet Program (Multi -Year) $ Enhanced Child Services Coord -SS $ Diabetes Education Program (Multi -Year) $ Specialty Crops Grant $ Local Food Initiatives Grant $ Reducing Health Disparities Grant (Multi -Y $ Triple P Initiative Grant (Multi -Yr) $ Meaningful Use Incentive Grant (Multi -Yr) $ Emergency Solutions Grant - DSS(Multi- $ 25,000 FY 2009 Recovery Act HPRP $ Community Response Program - DSS (MI. $ W. Attachment 1. Orange County The 2017 -18 Orange County Bud 29 # 13 Technical Amendment - Social Services - budget re- purposed funds from Grant Prolect closed out on Mamh 20, 2018 to Social Services within the General Fund #14. Emergency Telephone System Fund (Eat 1 Fund) - fund balance apprepmWon of $44,449 from the General Fund to the E911 Fund #15. South OmnW Fire District0 from the of $Orang from the South Orange Fire Oistdcl's Bailable fund balance #16. Sheriff's Office- Year-end adjustments in the Jail Inmate Fund and the Drug Forfeiture Fund, as well as receipt a Alzheimer's Foundation afAmedca grant award of $2,500 #17. Revised Vehicle Replacment Internal Service Fund financial plan for FY 2017 -18, and the closing out of the Vehicle Replacement internal Service Fund # 18. Orange County Food Council - receipt of pass - through funds totaling $2,000 from the Towns of Chapel HIII and Hillsborough for use by the Orange County Food Council Budget as Amended Through BOA #10 Susan G Komen Grant $ Kenan Charitable Trust Grant $ 300,000 Building Futures Program - DSS (Multi -Yr) $ Foster Youth Opportunities- DSS (Multi -ye $ W IOA Adult Dislocated Worker Grt-DSS $ Outreach Literacy Time to Read - Library $ 55,532 Outreach Literacy MotheRead- Library $ 23,791 Human Services $ $ $ $ $ $ $ 914,273 Hazard Mitigation Generator Project $ Buffer Zone Protection Program $ 800 MHz Communications Transition $ Secure Our Schools - OCS Grant $ Citizen Corps Council Grant $ COPS 2008 Technology Program $ COPS 2009 Technology Program $ EM Performance Grant $ 142,814 2010 Homeland Security Grant- ES $ 2011 Homeland Security Grant- ES $ Justice Assistance Act (JAG) Program $ FEMA Assistance to Firefighters Grant $ Public Safety $ - $ - $ - $ - $ - $ - $ 142,814 Total Expenditures $ - $ - $ - $ - $ - $ - $ 1,185,087 29 Attachment 1. Orange County The 2017 -18 Orange County Bud # 13 Technlcal #14. Emergency #16. Sheriffs Office - #17. Revised Vehicle # 18. Orange County Amendment - Social Telephone System #15. South Omnge Fire Year-end adjustments in Replacment Internal Food Council - receipt Services - budget re- Fund (E911 Fund) - District0 of the Jail Inmate Fund Service Fund financial of pass - through funds purposed funds from Grant Project fund balance from the $Orang from the South and the Drug Forfeiture Fund, plan for FY 2017 -18, totaling $2,000 from the Towns Chapel HIII Budget as Amended closed out apprepmWon of Orange Fire District's as well as receipt and the closing out of of Through BOA #10 on Mamh 20, 2018 to Social Services within $44,449 from the General Fund to the Bailable fund balance a Alzheimer's Foundation afAmedca the Vehicle Replacement internal and Hillsborough for use by the Orange the General Fund E911 Fund grant award of $2,500 Service Fund County Food Council Jail Inmate Fund Revenues Appropriated Fund Balance $ - $ - $ - $ 84,732 $ - $ - $ 94,732 Total Revenues $ - $ - $ - $ 84,732 $ - $ - $ 94,732 Expenditures Transfer to General Fund $ - $ - $ - $ 84,732 1 $ Drug Forfeiture Fund Expenditures Transfer to General Fund $ - $ - $ - $ 888,233 1 $ 30 Attachment 2 Year -To -Date Budget Summary Fiscal Year 2017 -18 General Fund Budget Summary Original General Fund Budget $219,656,033 Additional Revenue Received Through Budget Amendment #10 (June 19, 2018) 92.837 Grant Funds $237,291 Non Grant Funds $2,763,390 General Fund - Fund Balance for Anticipated Appropriations (i.e. Encumbrances) $1,313,300 General Fund - Fund Balance Appropriated to Cover Anticipated and Unanticipated Expenditures $221,707 Total Amended General Fund Budget $224,191,721 Dollar Change in 2017 -18 Approved General Fund Budget $4,535,688 % Change in 2017 -18 Approved General Fund Budget 2.06% Authorized Full Time Equivalent Positions Original Approved General Fund Full Time Equivalent Positions 893.863 Original Approved Other Funds Full Time Equivalent Positions 92.837 Total Approved Full- Time - Equivalent Positions for Fiscal Year 2017 -18 986.700 31 Paul: To cover expenditures ($14,408) related to respite services in Department on Aging (BOA #4); to cover reorganization costs ($46,925) of the Department of Human Rights and Relations (BOA #4) Paul: includes the addition of a 1.0 FTE Time - limited Community Health Worker position (BOA #1); includes moving 1.387 FTEs from division of Human Rights and Relations in GF to Housing Fund (1.194 FTEs) and to the Community Development Fund (.193 FTEs) BOA #4; includes addition of 1.0 FTE time - limited Erosion Control Officer I (BOA #6 -B) May 24, 2018 TOWN OF CARRBORO NORTH CAROLINA W W W.TOW NOFCARRBORO,ORG Paul Laughton, Deputy Director Orange County Finance and Administrative Services 200 S. Cameron Street Hillsborough, NC 27278 Dear Mr. Laughton: 32 On May 22, 2018 the Board of Aldermen for the Town of Carrboro authorized me to submit a request to Orange County to use some of the South Orange Fire District (SOFD) fund balance to purchase a 4x4 command vehicle (Resolution adopted by Board of Aldermen is attached.). It's our understanding that as of June 30, 2017, the total available fund balance was $171,888. The Carrboro Fire- Rescue Department currently has a Brush Truck that is ill- suited for the needs of the Town and SOFD. This truck has never been utilized for its intended purpose. As a result of non -use, the Brush Truck has experienced extensive and expensive maintenance issues. The Town would like to utilize up to $48,000 of the SOFD fund balance to purchase a replacement 4x4 SUV that will serve as a command staff vehicle. If you have questions or need additional information, please feel free to contact me or Chief Susana Williams. Thank you for consideration of the request. Sincerely, 04,04' a4.z,� David Andrews Town Manager Enclosure cc: Susanna Williams Arche McAdoo 301 WEST MAIN STREET, CARRBORO, NC 27510 • (919) 942 -8541 • FAX (919) 918 -4456 • VOICE/TTY/TDD /ASCII:711 AN EQUAL OPPORTUNITY PROVIDER 33 TOWN OF CARRBORO NORTH CAROLINA W W W.TO W NOFCARRBORO.ORG Motion was made by Alderman Gist, seconded by Alderman Haven- O'Donnell, to approve the resolution below: RESOLUTION TO REQUEST USE OF SOUTH ORANGE FIRE DISTRICT FUND BALANCE TO PURCHASE A COMMAND STAFF VEHICLE WHEREAS, The Town of Carrboro provides fire, rescue and EMS services to the South Orange Fire District; and WHEREAS, the taxes paid by property owners in the South Orange Fire District are used to pay the Town of Carrboro for services provided to the South Orange Fire District; and, WHEREAS, the South Orange Fire District has accumulated at fund balance of $171,888 through June 20, 2017; and, WHEREAS, the Town of Carrboro has identified a need to purchase a vehicle for command staff at an estimated cost of $48,000; and. WHEREAS, a new vehicle for command staff is expected to potentially reduce vehicle maintenance and fuel costs, as well as improve efficiency in service delivery; NOW THEREFORE, the Town of Carrboro Board of Aldermen hereby: Authorizes the Town Manager to submit a letter of request to Orange County requesting to use available Fund Balance from South Orange Fire District, 2. Such letter of request shall be limited to an amount not to exceed $48,000. 3. This Resolution if effective upon passage by the Town of Carrboro Board of Aldermen. 4. A copy of this resolution shall be forwarded to the Finance Officer within 2 days. This the 22nd day of May, 2018 The motion carried by the following vote: 301 WEST MAIN STREET, CARRSORO, NC 27510 • (919) 942 -8541 • FAX (919) 918 -4456 • VOICE/TY /TDD /ASCII:711 AN EQUAL OPPORTUNITY PROVIDER 34 TOWN OF CARRBORO NORTH CAROLINA WWW.TOWNOFCARRBORO,ORG Aye: Alderman Foushee, Alderman Slade, Alderman Haven - O'Donnell, Alderman Gist, Alden-nan Chaney and Mayor Lavelle Absent: Alderman Seils 1, Catherine 1.)orw.1doJ'(.'iwn Clerk, ror ilic I own of'CarrNwo. cI rtW (fiat the l'orc-90ilig i,; a true anti WITVO COPY ol'a n4 ilutiou adopted b� the Canboro Board c'-,,J'Akkrrriom 9p loll 301 WEST MAIN STREET, CAR8130110, NC 27510 - (919) 942-8541 - FAX (919) 918-4456 - VOICE/TTY/TDD/ASCII:711 AN EQUAL OPPORTUNITY PROVIDER 35 ORANGE COUNTY SCHOOLS 200 E. King Street Hillsborough, NC 27278 1 www.orangecountyfirst.com 1919.732.8126 Memorandum To: Bonnie Hammersley, County Manager From: Dr. Todd Wirt, Superintendent RE: Repurposing Funds for Orange High School Geothermal Project Date: June 12, 2018 As you are aware, Orange County Schools (OCS) included a geothermal project for Orange High School (OHS) on the Orange County 2016 Education Bond. The project was in planning for over two years and while design estimates throughout the process indicated the design was aligned with budget expectations, on April 12, 2018 in a well- attended bid opening, it was apparent market conditions had eclipsed the budget. The four bids submitted ranged from a low of $9,829,589 to a high of $12,366,000. In collaboration with the low bidder, we were able to reduce this amount by $143,961 through a value engineering exercise that would not adversely affect the outcome of the project. In addition, the Board of Education chose to accept two alternates for a total of $88,332. The Board awarded the bid to a local firm, Warren -Hay Mechanical Contractors, Inc. on May 7, 2018. The bid was awarded contingent upon funding, which includes the $1,463,401 repurposed funds request currently before the Board of Orange County Commissioners. The expenses for the project are estimated as follows: $ 650,000— Design Fees $ 75,000 — Reimbursable expenses (includes installation of one test well) $ 9,829,589 — Geothermal System Base Bid $ 26,900 —Alt #1— Lacrosse Field drainage improvements following well field installation 61432 —Alt #2— Cultural Arts Wing New Ceilings and Light Fixtures $10,642,921 —Total Estimated Project Cost Funding for project: $ 8,900,000 -2016 Education Bond Proceeds $ 1,463,401— Requested Repurposed Funding $ 500,000 —OCS Capital Fund Balance has been allocated to fund this project and to develop a 2% contingency for change orders and additional owner expenses as may be required over the 2 year project duration. 510,863.401* —Total Estimated Funding *Allows approximately 2% contingency for additional owner responsibilities and change orders that may be necessary as a result of hidden conditions in the 50 -year old facility. W. Bonnie Hammersley, County Manager June 12, 2018 Page 2 You may recall the steam lines that provide heat to this school have been failing for several years, which prompted the inclusion of this work on the bond. The $150,000 capital allocation needed to patch the system wastes precious resources. The multi -year duration, combined with the project's complexity and the age of the building are factors that will continue to be exacerbated over time. The installation will pay a return on investment through reduced energy and maintenance costs, so waiting for more favorable market conditions is not desirable. For these and other reasons, even though the project is significantly above the budgeted amount, the Board of Education has recommended moving forward. After careful evaluation, we believe the District's impact of repurposing the requested funds will be manageable. The projects where repurposing is requested fall into three categories: 1.) Completed projects with remaining unallocated balances; 2.) Projects that are specific to Orange High School that will be addressed through the geothermal installation project or other planned projects (currently budgeted in a separate line item); and 3.) Projects that will be addressed through recurring capital funding. In order to maximize the limited summer break when the construction site will be less encumbered by the presence of students and staff, we are seeking County Commissioner approval as soon as practicable. Upon approval by the County Commissioners, we will fully execute the contract approved by the Board of Education and move this important project forward. We appreciate your consideration of our request.