Loading...
HomeMy WebLinkAboutORD-2018-025 Fiscal Year 2017-18 Budget Amendment #10ORD- 2018 -025 ORANGE COUNTY BOARD OF COMMISSIONERS ACTION AGENDA ITEM ABSTRACT Meeting Date: June 19, 2018 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 Action Agenda Item No. 8 -e INFORMATION CONTACT: Paul Laughton, (919) 245 -2152 Gary Donaldson, (919) 245 -2453 1 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. 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 1) 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 iDroiect: Aaaroariated for this aroiect: 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 Aaaroariated for this aroiect: • 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 oroiect: 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 oroiect: Aaarooriated for this oroiect: 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 Aaarooriated for this oroiect: 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 K 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 oroiect: Aaaroariated for this aroiect: 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 Aaaroariated for this aroiect: SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goals are applicable to this item: 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: M • 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 eroiect: Appropriated for this groiect: 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 groiect: 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 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 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' 401 k 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) 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 oroiect: Appropriated for this eroiect: 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 eroiect: 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) 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) 7 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 44 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 oroiect: 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 Appropriated for this project: New Hope Elementary Renovations (- $59,549) - Project # 50010 Revenues 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: Appropriated 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: Asbestos Removal (- $50,000) - Project # 51001 Revenues 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: Appropriated 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: Handicap Accessibility (- $100,000) - Project # 51005 Revenues 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 9 Appropriated for this project: Roofing Projects (- $7,500) - Project # 51010 Revenues 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: Appropriated 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: Indoor Air Quality (- $10,193) - Project # 51019 Revenues 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: Appropriated 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: District Wide Improvements ( -$258) - Project # 51021 Revenues 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 10 Appropriated for this project: Bathroom Renovations (- $75,218) - Project # 51023 Revenues 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: Appropriated 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: Fire /Safety /Upgrades (- $89,642) - Project # 51024 Revenues 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: Appropriated 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: Classroom /Building Improvements (- $572,219) - Project # 51025 Revenues 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 11 Appropriated for this project: Window Replacements (- $1,542) - Project # 51026 Revenues 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: Appropriated 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: Athletic Facilities (- $230,708) - Project # 51027 Revenues 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: Appropriated 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: Mechanical Systems (- $31,226) - Project # 51029 Revenues 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 12 Appropriated for this project: Paving /Parking Lot Improvements (- $15,281) - Project # 51030 Revenues 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: Appropriated 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: Doors/Windows /Canopies (- $220,000) - Project # 51037 Revenues 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: Appropriated 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: 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 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 13 Appropriated for this proiect: 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. 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. 14 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 15 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 aroiect: Appropriated for this iDroiect: 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 iDroiect: 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 $173807833. RECOMMENDATION(S): The Manager recommends the Board approve budget, capital, and grant project ordinance amendments for fiscal year 2017 -18. 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 $173807833. RECOMMENDATION(S): The Manager recommends the Board approve budget, capital, and grant project ordinance amendments for fiscal year 2017 -18. Attachment 1. Orange County Proposed 2017 -18 Budget Amendment The 2017 -18 Orange County Budget Ordinance is amended as follows: Expenditures Community Relations -PubI is Affairs $ 291,874 $ 4,110 $ 295,984 $ 295,984 #3. Library Services - #4. Department on Aging Finance and Administrative Services $ 1,405,885 $ 1,405,885 $ 1,405,885 2. Health Department- Additienal Revenue. - Addiental HCCBG Asset Management SerAces $ 4,541,095 $ 181,088 $ 4,722,183 $ 4,722,183 1. Department an Aging - receipt of $300,000 $z2os frem smart start funds fran TJCCG Human Resources $ 935,443 $ 14,365 $ 949,808 $ 949,808 reciept of donated funds Kenen Gheriteble Trust end $875 fmm Orange f- 0,ip $11018 for Pessmare Information Technologies $ 3,328,135 Encumbrance $ 3,376,498 Budget as Amended °f $2,520 in the Grant, etldtienal Feed Ceu my P f°r furnishings, edd,ti°nal Non - Departmental Original Budget Carry Forwards Budget as Amended Through BOA p9 Spay /Neuter FUnd, and and Ledgingfunds of Yeung Children for Time venue ef$3550 for ethe Support Services $ 14,101,197 $ 259,608 $ 14,360,805 $ 14,360,805 .-pt of donated funds of $2, 93 fo..... n the $5 224, and addiienal 10 d-,d Gast to Reed project traiuiug Operatien Fan Pregram, and edddi°nal County Comm issioners $ 913,708 $ 4,620 $ 918,328 $ 918,328 Animal Shelter Settlement funds of chldcare previders techniques Nteech anticipated revenue of County Attorney $ 590,669 $ 590,669 $ 590,669 $1098134 chiltlren m read $4085 from Wellness County 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 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 $ 3,000,223 $ 2,893 Cooperative 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 $ 11,143,693 DEAPR $ 4,073,800 $ 80,786 Total General Fund Revenues $ 219,656,033 $ 1,313,300 $ 220,969,333 $ 223,513,781 $ 2,893 1 $ 5,224 $ $ 14,566 Expenditures Community Relations -PubI is Affairs $ 291,874 $ 4,110 $ 295,984 $ 295,984 Finance and Administrative Services $ 1,405,885 $ 1,405,885 $ 1,405,885 Asset Management SerAces $ 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 Comm issioners $ 913,708 $ 4,620 $ 918,328 $ 918,328 County Attorney $ 590,669 $ 590,669 $ 590,669 County Manager's Office $ 2,821,481 $ 5,388 $ 2,826,869 $ 2,826,869 Board of Elections $ 830,014 $ 830,014 $ 830,014 Register of Deeds $ 985,215 $ 985,215 $ 985,215 Tax Adm inistration $ 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 SerAces $ 2,095,292 $ 10,838 $ 2,106,130 $ 2,109,130 $ 2,893 Orange Public Transportation $ 1,586,943 $ 1,200 $ 1,588,143 $ 1,605,092 Cooperative 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 $ 51,655 $ 2,144,524 $ 2,326,818 $ 14,566 Child Support SerAces $ 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 Emer enc Sermces $ 10,975,924 $ 209,404 $ 11,185,328 $ 11,185,328 Non Departrnental $ 418,047 $ 418,047 $ 418,047 Public Safety $ 25,583,899 $ 449,706 $ 26,033,605 $ 26,164,822 $ $ $ $ Education $ 104,991,508 $ 104,991,508 $ 104,991,508 $ $ $ $ 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 1 $ 5,224 $ $ 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 $ 320,000 $ 914,000 $ - #3. Library Services - #4. Department on Aging $ Alternative Financing $ $ 2. Health Department- Additienal Revenue. - Addiental HCCBG Appropriated Fund Balance $ 1. Department an Aging - receipt of $300,000 $z2os frem smart start funds fran TJCCG Miscellaneous reciept of donated funds Kenen Gheriteble Trust end $875 fmm Orange f— 0,ip $11018 for Pessmare Encumbrance Budget as Amended °f $2,520 in the Grant, etldtienal Feed Ceu my P f°r furnishings, edd,ti°nal Original Budget Carry Forwards Budget as Amended Through BOA p9 Spay /Neuter FUnd, and and Ledgingfunds of veung Children for Time venue ef$3550 for ethe $ 320,000 1 $ 1A33,621 1 $ - $ 1,096,134 .—pt of donated funds of $2, 93 fo..... n the $5 224, and addiienal 10 d—,d Gast t° Reed project traiuiug Operatien Fan Pregram, and edddi°nal Animal Shelter Settlement funds of chldcare previders antated revenue of $1098134 techniques Nteech $4085 from Wellness children m read class fees County Capital Project Fund Revenues Transfer From the General Fund $ 320,000 $ 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 $ 1,096,134 $ $ Total Revenues $ 320,000 1 $ - $ 320,000 1 $ 1A33,621 1 $ - $ 1,096,134 1 $ - $ Expenditures County Capital Projects $ 320,000 $ 320,000 $ 1A33,621 $ - $ 1,096,134 $ - $ Fire District Funds Revenues Property Tax $ 5,724,102 $ 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 Rem ittance to Fire Districts $ 5,726,068 $ 5,726,068 $ 5,756,068 Section 8 Housing Fund Revenues Intergovernmental $ 4,211,164 $ 4,211,164 $ 4,211,164 Miscellaneous $ Transfer from General Fund $ 262,066 $ 262,066 $ 460,230 Appropriated Fund Balance $ - I $ 18,500 1 $ 18,500 $ 18,500 Total Housing Fund Revenues $ 4,473,230 1 $ 18,500 1 $ 4,491,730 $ 4,689,894 $ Expenditures Housing Fund $ 4,473,230 $ 18,500 $ 4,491,730 $ 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 #3. Library Services - #4. Department on Aging Grant Funds $ $ 217,457 $ 2. Health Department- Additional Revenue. - Addiental HCCBG $ 4,085 From General Fund $ 1. Department an Aging - receipt of $300,000 $z2os frem smart start funds fran TJCOG Appropriated Fund Balance reciept of donated funds Kenen Gheriteble Trost end $875 fmm Orange f- 0,ip $11018 for Pessmare 1 $ Encumbrance $ 675 Budget as Amended °f $2,520 in the Grant, etldtienal FOOd Cod my P for furnishings, additional Original Budget Carry Forwards Budget as Amended Through BOA p9 Spay /Neuter FUnd, and and LOdgingfunds of vodng Children for Time venue of $3,550 for ethe 1 $ 2,731 $ 2,731 ceipt of donated funds of $2, 93 fo..... n the $5 224, and addiional 10 do ,d Gast to Reed project traiui g Operation Fan Program, add edddian al 1 $ 2,731 1 $ 2,343,512 $ 878,302 $ - Animal Shelter Settlement funds of chldcare providers anticipated revenue of $ - $ $ $1096134 techniques m teach $8005 from Wellness Growing New Farmers Grant $ $ chiltlren m reetl 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 1 $ 19,079 1 $ 177,189 $ 177,189 1 $ $ 675 Total Revenues $ 753,460 1 $ 19,079 1 $ 772,539 $ 772,539 $ - $ - $ - $ Expenditures Emergency Telephone System Fund $ 753,460 $ 19,079 $ 772,539 $ 772,539 Vehicle Replacement Fund Revenues Charges for Services $ I $ $ $ 300,000 $ 2,025 Appropriated Fund Balance $ - $ 217,457 1 $ 217,457 $ 217,457 $ 4,085 Debt Financing $ 757,514 $ 757,514 $ 757,514 o a a rc e Replacement Fund Revenues $ 757,514 $ 217,457 1 $ 974,971 1 $ 974,971 1 $ $ 675 Expenditures Vehicle Replacement Fund I $ 757,514 $ 217A57 1 $ 974,9711 $ 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 $ 878,302 $ - $ 300,000 $ 2,700 $ 4,085 Expenditures 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) $ 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 (Multi -Yr) $ $ SeniorNet Program (Multi -Year) $ $ Enhanced Child Services Coord -SS $ $ Diabetes Education Program (Multi -Year) $ $ Specialty Crops Grant $ $ Local Food Initiatives G rant $ $ - ReducingHealthDisparitiesGrant (Multi -Yr) $ $ Triple P Initiative Grant (Multi -Yr) $ $ Meaningful Use Incentive Grant (Multi -Yr) $ $ - EmergencySolutionsGrant - DSS(Multi -Yr) $ $ 25,000 FY 2009 Recovery Act HPRP $ $ Com in unity Response Frog ram- DSS(Mul $ 204,833 $ 204,833 $ - Susan G Kom en Grant $ $ IN Attachment 1. Orange County Proposed 2017 -18 Budget Amendment The 2017 -18 Orange County Budget Ordinance is amended as follows: 19 #3. Library Services - #4. Department on Aging 2. Health Department- Additienal Revenue. - Addiental HCCBG 1. Department an Aging - receipt of $300,000 $z2os frem smart start funds fran TJCCG reciept of donated funds Kenen Gheriteble Trust end $875 fmm Orange f— 0,ip $11018 for Pessmare Encumbrance Budget as Amended °f $2,520 in the Grant, etldtienal Feed Ceu my P f°r furnishings, edd,ti°nal Original Budget Carry Forwards Budget as Amended Through BOA Spay /Neuter FUnd, and and Ledgingfunds of veung Children for Time venue ef$3550 for ethe ceipt of donated funds of $2, 93 fo..... n the $5 224, and addiienal 10 d—,d Gast t° Reed project traiuiug Operatien Fan Pregram, and edddi°nal Animal Shelter Settlement funds of chldcare previd.r anticipated revenue of $1098134 techniques Nteech $4085 from Wellness chiltlren m read 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 $ 607A88 $ - $ 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 1 $ - $ - $ - $ 142,814 $ - $ - $ - $ Total Expenditures $ 2,340,781 $ 2,731 $ 2,343,512 $ 878,302 1 $ - $ 300,000 1 $ 2,700 1 $ 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 #3. Library Services - #4. Department on Aging Appropriated Fund Balance $ $ $ 10,000 $ - $ - $ - $ 2. Health Department- Additienal Revenue. - Addiental HCCBG 1. Department an Aging - receipt of $300,000 $z2os frem smart start funds fran TJCOG $ $ $ 10,000 $ - $ - $ - $ reciept of donated funds Kenen Gheriteble Trust end $875 fmm Orange f— 0,ip $11018 for Pessmare Encumbrance Budget as Amended °f $2,520 in the Grant, etldtienal Feed Ceu my P f°r furnishings, edd,ti°nal Original Budget Carry Forwards Budget as Amended Through BOA p9 Spay /Neuter FUnd, and and Ledgingfunds of Yeung Children for Time venue ef$3550 for ethe .—pt of donated funds of $2, 93 fo..... n the $5 224, and addiienal 10 d—,d Gast t° Reed project traiuiug Operatien Fan Pregram, and edddi°nal $ - $ - $ - $ - Animal Shelter Settlement funds of chldcare previders anticipated revenue of $1098134 techniques Nteech $4085 from Wellness $ $ $ $ - $ - $ - $ chiltlren m read class fees Jail Inmate Fund Revenues Appropriated Fund Balance $ $ $ 10,000 $ - $ - $ - $ Total Revenues $ - $ - $ - $ 10,000 $ - $ - $ - $ Expenditures Transfer to General Fund $ $ $ 10,000 $ - $ - $ - $ Drug Forfeiture Fund Revenues Federal Forfeiture Funds $ $ $ $ - $ - $ - $ State Forfeiture Funds Total Revenues $ - $ - $ - $ - $ - $ - $ - $ Expenditures Transfer to General Fund $ $ $ $ - $ - $ - $ 20 Attachment 1. Orange County The 2017 -18 Orange County Bud 21 Fxnendihrres Communi Relations -Public Affairs #6. Allocation to $ 2183 #10. Allocation to $ 1431 Finance and Admin is Services Departments of #7. Allocation from #8. Allocation to #9. Allocation to Depertrnents of #11. Allocation m # 12 Technical Asset Mana ement Services #5 Housing $1492851 for Wage Departments for Selery Departments of Departments 10 $18on,ptoor Selery Departments for Health Amendment Social Human Resources Department - receipt of incr se end employee ea Savings of $2000000 $800,000 to match for Living Wage W.g. Gampressian Insurance increase of Services - transfers Inform ation Technolo ies edddianel HUD funds of performance awards budgeted in a Support employees' 401 k match increase budgeted in edjustmentr budgeted in $524,433 budgeted in e $23 891 from the Non -De artm ental $280,601 butlgetetlin Support Service Non- Services Non- Departmental account in butlgetetlin Support Services Non- Support Services Nan- Support Services Nan- Support So, ices Nan - General Fund to the Information lnd Support Services $ Departmental account in FY 2017 -18 Departmental account Departmental account Departmental account in Departmental account .ots F Capital Pmjects Funtl Coun Commissioners FY 2017 -18 149 $ 10,178 FY 2017 -18 $ 5,283 General Fund $ 11,683 j$2 $ 4,340 $ 2,412 Coun Mana er's Office $ 17 563 $ 7 013 $ 370 $ 3 225 Revenue Board of Elections $ 8 838 $ 4 999 $ 2 289 $ 126 $ 2 745 Property Taxes $ $ $ $ $ $ $ $ Sales Taxes $ $ $ $ $ $ $ $ License and Permits $ $ $ $ $ $ $ $ Intergovernmental $ $ $ $ $ $ $ $ Charges for Service $ $ $ $ $ $ $ $ Investment Earnings $ $ $ $ $ $ $ $ Miscellaneous Oran ePublic Trans ortation $ 27110 $ 162244 $ 12,087 $ 4,665 $ 227 $ 10,955 Transfers from Other Funds Coo erative Extension Fund Balance Economic Develo ment $ 16808 $ 4,718 $ 1,390 $ 2,834 Total General Fund Revenues $ $ $ $ $ $ $ $ Fxnendihrres Communi Relations -Public Affairs $ 5386 $ 2183 $ 1431 Finance and Admin is Services $ 27,469 914 $ 11662 $ 1884 $ 8759 Asset Mana ement Services $ 65,210 233 $ 26,555 $ 3,746 $ 6599 $ 21759 Human Resources $ 21,053 799 $ 9,248 $ 100 $ 5,155 Inform ation Technolo ies $ 35447 033 $ 12,674 $ 232 $ 10,658 Non -De artm ental $ 1 492 651 000 $ (600,000) $ (94,410) $ (188,481) $ (524,433) Support Services $ $ (1,338,086) ,021 $ (537,678) $ (90,665) $ (179,666) $ (476,671) $ Coun Commissioners $ 16,308 149 $ 10,178 $ 282 $ 5,283 Coun Attorne $ 11,683 j$2 $ 4,340 $ 2,412 Coun Mana er's Office $ 17 563 $ 7 013 $ 370 $ 3 225 Board of Elections $ 8 838 $ 4 999 $ 2 289 $ 126 $ 2 745 Re ister of Deeds $ 26 044 042 $ 15183 $ 2 009 $ 8 075 ax Administaton $ 80 641 1 780 $ 30 958 $ 802 $ 9 557 $ 25 277 Coun Debt Service Non -De artm ental General Government $ $ 161,077 ,971) $ 72,671 $ 3,091 $ 12,344 $ 47,017 $ Animal Services $ 38 578 510 $ 17,177 $ 4,813 $ 5,265 $ 16,271 Oran ePublic Trans ortation $ 27110 $ 162244 $ 12,087 $ 4,665 $ 227 $ 10,955 Coo erative Extension Economic Develo ment $ 16808 $ 4,718 $ 1,390 $ 2,834 DEAPR $ 69557 $ 46838 $ 29,641 $ 18,663 $ 4,701 $ 17,881 Plannin and lns actions $ 68155 $ 92788 $ 30701 $ 5,062 $ 19,420 Non -De artm ental 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 De artm ent on A in $ 31,333 $ 19 443 $ 19,453 $ 2,509 $ 6 986 $ 11,699 Ch ild Su ort Services $ 20,319 $ 10,986 $ 4686 $ 7,678 Housin ,Human Ri hts 8 Comm De, Human Ri hts and Rel ations $ 6031 $ 37189 $ 2565 $ 385 $ 1,753 Lbra Services $ 46,129 $ 32188 $ 19,814 $ 1,338 $ 3,765 $ 14,794 Non -De artmental Human Services $ $ 565,639 $ (874,670) $ 246,193 $ 25A98 $ 69,196 $ 195,137 $ (23,891) Courts Criminal Justice Resource De pa ent $ 8,090 $ 24141 $ 5,233 $ 3,122 Sheriff $ 202,719 $ 220,106)1 $ 27,754 1 $ 24,422 $ 61,407 1 $ 89,294 Emer enc Serdces $ 180,353 $ 332,753 $ 91,503 $ 9,511 $ 20,074 $ 74,740 Non De artrnental Public Safety $ $ 391,162 $ (577,000) $ 124A90 $ 33,933 $ 81 A81 $ 167,156 $ Education $ $ $ $ $ $ $ $ Transfers Out $ 23,891 Total General Fund Appropriation $ $ $ $ $ (0) $ $ $ 7 7 = 7 - 7 = 7 lul 7 = 7 - 7 Attachment 1. Orange County The 2017 -18 Orange County Bud County Capital Project Fund Rivuenues Transfer From the General Fund #6. Allocation to $ $ $ $ $ $ $ Departments of #7. Allocation from #8. Allocation to #10. Allocation to # 12 Technical $1492851 for Wage Departments for Selery Departments of #9. Allocation to Depertrnents of #11. Allocation m Amendment Social #5 Housing incr se end employee ea Savings of $2000000 $800,000 to match Departments 10 $18on,ptoor Selery Departments for Health Services - transfers Department - receipt of edddianel HUD funds of performance awards butlgetetl in a Support employees' 401 k match for Living Wage W.g. increase budgeted in Gampressian edjustmentr budgeted in Insurance increase of $524,433 budgeted in e $23 891 from the $280,601 butlgetetl in Support Services Non- butlgetetlin Support Support Services Nan- Support Services Nan- Support Srtu%. Nan - General Fund to the ServiceNon- Departmental account in Services Non- Departmental account Departmental account in Departmental account Information Technology Departmental account in FV 2017 -18 FV 2017 -18 Departmental account FV 2017 -18 Capital Pmjects Fund County Capital Project Fund Rivuenues Transfer From the General Fund $ $ $ $ $ $ $ $ Alternative Financing Appropriated Fund Balance Miscellaneous Medicaid Maximization Funds $ $ $ $ $ $ $ $ Total Revenues Expenditures County Capital Projects Fire District Funds Rivuenues Property Tax $ 280,601 Intergovernmental Investment Earnings Appropriated Fund Balance Total Fire Districts Fund Revenue $ $ $ $ $ $ $ $ Expenditures Remittance to Fire Districts Section 8 Housing Fund Revenues Intergovernmental $ 280,601 Mscellaneous Transfer from General Fund Appropriated Fund Balance Total Housing Fund Revenues $ 280,601 $ - $ Expenditures Housing Fund $ 280,601 22 Attachment 1. Orange County The 2017 -18 Orange County Bud Emergency Telephone System Fund Raw Charges for Services #6. Allocation to Departments of #7. Allocation from #8. Allocation to #10. Allocation to # 12 Technical $1492851 for Wage Departments for Selery Departments of #9. Allocation to Depertrnents of #11. Allocation m Amendment Social #5 Housing incr se end employee ea Savings of $2000000 $800,000 to match Departments 10 $18on,ptoor Selery Departments for Health Services - transfers Department - receipt of edddianel HUD funds of performance awards butlgetetl in a Support employees' 401 k match for Living Wage W.g. increase budgeted in Gampressian edjustmentr budgeted in Insurance increase of $524,433 budgeted in e $23 891 from the $280,601 butlgetetl in Support Services Non- butlgetetlin Support Support Services Nan- Support Services Nan- Support Sutu%. Nan - General Fund to the ServiceNon- Departmental account in Services Non- Departmental account Departmental account in Departmental account Information Technology Departmental account in FV 2017 -18 FV 2017 -18 Departmental account FV 2017 -18 Capital Pmjects Fund Emergency Telephone System Fund Raw Charges for Services Grant Funds From General Fund Appropriated Fund Balance $ Total Revenues Expenditures Emergency Telephone System Fund Vehicle Replacement Fund Revenues Charges for Services Appropriated Fund Balance Debt Financing o a a rc e e acemen un 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 Expenditures NCACC Employee Wellness Grant CFAT Propane Vehicle Grant(multi-year) Electric Vehicle Charging Stations Su ort 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 Gran Golden LEAF Foundation Grant Communi 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 200g Recovery Act HPRP Community Response Program - DSS (M 23 Attachment 1. Orange County The 2017 -18 Orange County Bud 24 #5 Housing Department - receipt of edddianel HUD funds of $280,601 #6. Allocation to Departments of $1492851 for Wage incr se end employee ea performance awards butlgetetlin Support ServiceNOn- Departmental account in FY 2017 -18 #7. Allocation from Departments for Selery Savings of $2000000 budgeted in a Support Services Non- Departmental account in FY 2017 -18 #8. Allocation to Departments of $800,000 to match employees' 401 k match butlgetetlin Support Services Non- Departmental account #9. Allocation to Departments W.g. 10 for Living Wage increase budgeted in Support Services Nan- Departmental account #10. Allocation to Depertrnents of $18on,ptoor Selery Gampressian edjustmentr budgeted in Support Services Nan- Departmental account in FY 2017 -18 #11. Allocation m Departments for Health Insurance increase of $524,433 budgeted in e Support Sutu%. Nan - Departmental account # 12 Technical Amendment Social Services - transfers $23 891 from the General Fund to the Information Technology Capital Pmjects Fund Susan G Komen Grant Kenan Charitable Trust Grant Building Futures Program - DSS (Multi -Yr) Foster Youth Opportunities -DSS (Multi - 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 Safe $ - $ - $ - $ - $ - $ - $ - $ Total Expenditures $ - $ - $ - $ - $ - $ - $ - $ 24 Attachment 1. Orange County The 2017 -18 Orange County Bud Jail Inmate Fund Revenues #6. Allocation to Departments of #7. Allocation from #8. Allocation to $ - $ - $ - $ - $ - $ - $ - $ #10. Allocation to # 12 Technical $1492851 for Wage Departments for Selery Departments of #9. Allocation to Depertrnents of #11. Allocation m Amendment Social #5 Housing incr se end employee ea Savings of $2000000 $800,000 to match Departments 10 $18on,ptoor Selery Departments for Health Services - transfers Department - receipt of edddianel HUD funds of performance awards butlgetetl in a Support employees' 401 k match for Living Wage W.g. increase budgeted in Gampressian edjustmentr budgeted in Insurance increase of $524,433 budgeted in e $23 891 from the $280,601 butlgetetl in Support Services Non- butlgetetlin Support Support Services Nan- Support Services Nan- Support So, ices Nan - General Fund to the ServiceNon- Departmental account in Services Non- Departmental account Departmental account in Departmental account Information Technology $ - Departmental account in FV 2017 -18 FV 2017 -18 Departmental account Expenditures FV 2017 -18 Capital Pmjects Fund Jail Inmate Fund Revenues Appropriated Fund Balance $ - $ - $ - $ - $ - $ - $ - $ Total Revenues $ - $ - $ - $ - $ - $ - $ - $ Expenditures Transfer to General Fund $ - $ - $ - $ - $ - $ - $ - $ Drug Forfeiture Fund Revenues Federal Forfeiture Funds $ - $ - $ - $ - $ - $ - $ - $ State Forfeiture Funds Total Revenues $ - $ - $ - $ - $ - $ - $ - $ Expenditures Transfer to General Fund $ - $ - $ - $ - $ - $ - $ - $ 25 Attachment 1. Orange County The 2017 -18 Orange County Bud 26 Expenditures Communi Relations -Public Affairs # 13 Technical #14. Emergency #16. Sherrffs Office - #17. Revised Vehicle # 18. Orange County $ 304984 Finance. Services Amendment- Social Telephone System #,,t Sat tp Orange Eire Yearend aQ.,t —t, in Replacment lntemal Food Council- receipt $ 1437745 Asset Mana ement Services Services - budget re- Fund(E911 FUnd)- District - appropriation of the Jail Inmate FUnd Service EUnd financial of pass #hmugh funds $ 4 796 819 Human Resources purposed funds fmm fund balance $0 000 from the South end the Omg Forteitare plan for EV 2017 -18, tNeling $2,000 fmm the Budget as Amended Information Technolo ies Gmnt Project closed out appropriation of orange Fire ostdors Fund, as well as receipt end the closing oat of Towns of Chapel Hill Through BOA #10 9 Non -De artmental an March 20, 2018 to Social Services within $44449 from the General EUnd to the eileble fund balance of e Alzheimer's Foundation of America the Vehicle Replacement lntemal end Hillsborough for se bythe Orange $ 2710472 Support Services the General Fund E911 Fund $ grant award of $2500 Service Fund County F.O Council $ 13,613,061 General Fund $ 944230 Coun Attorne Revenue Coun Mana er'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 $ 3,003,116 Transfers from Other Funds $ 70,651 $ 84,732 1 $ 335,000 $ 4 427,429 Fund Balance Coo erative Extension $ 44,449 $ 115,925 11, $ 304,067 Total General Fund Revenues $ 70,651 1 $ 44,449 $ $ 87,232 1 $ 450,925 1 $ 2,000 1 $ 224,191,721 Expenditures Communi Relations -Public Affairs $ 304984 Finance. Services $ 1437745 Asset Mana ement Services $ 4 796 819 Human Resources $ 961 565 Information Technolo ies $ 3401476 Non -De artmental $ 2710472 Support Services $ $ $ $ $ $ $ 13,613,061 Coun Commissioners $ 944230 Coun Attorne $ 609104 Coun Mana er's Office $ 2 855 040 Board of Elections $ 849 011 Re ister of Deeds $ 1 026 484 Tax Administration $ 3864173 Coun Debt Serdce $ 450 925 $ 12135 551 Non -De artm ental $ 103391 General Government $ $ $ $ $ 450,925 $ $ 22,386,984 Animal Services $ 2120617 Oran ePublic Trans ortation $ 1497892 Coo erative Extension $ 385 530 Economic Develo ment $ 607475 DEAPR $ 4327717 Plannin and lnsections $ 3186672 Non -De artm ental $ 2543257 Community Services $ $ $ $ $ $ $ 14,669,161 De artm ant of Social Services $ 70651 $ 19613019 Health $ 10438640 Cardinal Innovations MOE $ 1 050187 De artmentonA in $ 2393921 Ch ild Su ort SeMces $ 1106062 Housin Human Ri hts 8 Comm Dev $ 37,555 Human Ri hisand Relations $ 282362 Lbra Services $ 2312117 Non -De artmental $ 2000 $ 1993165 Human Services $ 70,651 $ $ $ $ $ 2,000 $ 39,227,028 Courts $ 70000 Criminal Justice Resource De artment $ 509903 Sheriff $ 2500 $ 14161838 Emer enc Serdces $ 84,732 $ 11,313,488 Non De artrn ental $ 418047 Public Safety $ $ $ $ 87,232 $ $ $ 26,473,276 Education $ $ $ $ $ $ $ 104,991,508 Transfers Out $ 44,449 $ 2,830,703 Total General Fund Appropriation $ 70,651 $ 44,449 $ $ 87,232 $ 450,925 $ 2,000 $ 224,191,721 7 7 7 7 7 7 7 lul Attachment 1. Orange County The 2017 -18 Orange County Bud # 13 Technical #14. Emergency $ #16. Sherrffs Office - #17. Revised Vehicle # 18. Orange County $ Amendment- Social Telephone System #,,t Sat tp Orange Eire Yearend aQ.,t —t, in Replacment lntemal Food Council- receipt $ 929,908 Services - budget re- Fund(E911 FUnd)- District - appropriation of the Jail Inmate FUnd Service EUnd financial of Pass #hmugh funds purposed funds fmm fund balance $0 000 from the South end the Omg Forteitare plan for EV 2017 -18, tNeling $2,000 fmm the Budget as Amended Gmnt Project closed out appropriation of orange Fire ostdors Fund, as well as receipt end the closing oat of Towns of Chapel Hill Through BOA #10 9 an March 20, 2018 to Social Services within $44449 from the General EUnd to the eileble fund balance of e Alzheimer's Foundation of America the Vehicle Replacement lntemal end Hillsborough for se bythe Orange $ - the General Fund E911 Fund $ - grant award of $2500 Service Fund County F.O Council County Capital Project Fund Reve Transfer From the General Fund $ $ $ $ $ $ $ 914,000 Alternative Financing $ 929,908 $ 778,462 Appropriated Fund Balance $ 217,457 $ 217,457 Mscellaneous $ 48,000 $ 4,200 Medicaid Maxim¢ation Funds $ $ $ 48,000 $ $ $ $ 1,763,001 Total Revenues $ - $ - $ - $ - $ 1,147,365 $ - $ 3,677,120 Expenditures County Capital Projects $ - $ - $ - $ - $ 1,147,365 $ - $ 3,677,120 Fire District Funds Revenues 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 Rem ittance to Fire Districts $ 48,000 $ 5,804,068 Section 8 Housing Fund Revenues Intergovernmental $ 4,491,765 Mscellaneous $ Transfer from General Fund $ 460,230 Appropriated Fund Balance $ 18,500 Total Housing Fund Revenues $ - $ - $ - $ - $ - $ - 1 $ 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. Sherrffs Office - #17. Revised Vehicle # 18. Orange County Amendment- Social Telephone System #,,t Sat tp Orange Eire Yearend aQ.,t —t, in Replacment lntemal Eood Council - receipt $ (217,457) Services - budget re- Eund(E911 EUnd)- District - appropriation of the Jail Inmate Fund Service EUnd financial of Pass #hmugh funds purposed funds fmm fund balance $48000 from the South end the Omg Eorteitare plan for EV 2017 -18, tNeling $2000 fmm the Budget as Amended —t Project closed oat appropriation of orange Eire Distfiofs Fund, as well as receipt end the closing oat of Towns of Chapel Hill Through BOA #10 9 S March 20, 2018 to Social Services within $44449 from the General EUnd to the eileble fund balance of e Alzheimer's E oundeW. of America the Vehicle Replacement lntemal and Hillsborough for se bythe0renge the General Eund E911 Eund grant award of $2500 Service Eund County F.O Council Total Revenues Emergency Telephone System Fund Raw 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 1 $ - 1 $ 44,449 1 $ - $ - $ - $ - $ 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) $ o a ­.' —pl acamert un Revenues $ - $ - $ - $ - $ (974,971) $ - 1 $ 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 Expenditures NCACC Employee Wellness Grant $ CFAT Propane Vehicle Grant(multi -year) $ Electric Vehicle Charging Stations $ Su ort 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 Communi Services $ - $ - $ - $ - $ - $ - $ 128,000 Parent Ed Initiative - DSS (Multi -year) $ Child Care Subsidy- DSS (Multi -year) $ Canboro Growing Healthy Kids Grant $ Healthy Carolinians $ Health & Wellness Trust Grant $ Senior Citizen Health Promotion Wellness 1 $ 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 (M $ M Attachment 1. Orange County The 2017 -18 Orange County Bud 29 # 13 Technical Amendment- Social Services - budget re- purposed funds fmm Gmnt Project closed out an March 20, 2018 to Social Services within the General Fund #14. Emergency Telephone System Fund(E911 FUnd)- fund balance appropriation of $44449 from the General EUnd to the E911 Fund #,,t Sat tp Orange Eire District - appropriation of $0 000 from the South orange Fire ostdors eileble fund balance #16. Sherrffs Office - Yearend aQ.,t —t, in the Jail Inmate FUnd end the Omg Forteitare Fund, as well as receipt of e Alzheimer's Foundation of America grant award of $2500 #17. Revised Vehicle Replacment lntemal Service EUnd financial plan for EV 2017 -18, end the closing oat of the Vehicle Replacement lntemal Service Fund # 18. Orange County Food Council- receipt of Pass #hmugh funds tNeling $2,000 fmm the Towns of Chapel Hill end Hillsborough for se bythe Orange County F.O Council Budget as Amended Through BOA #10 9 Susan G Komen Grant $ Kenan Charitable Trust Grant $ 300,000 Building Futures Program - DSS (Multi -Yr) $ Foster Youth Opportunities -DSS (Multi -ye $ WIOA 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 Assstance Act (JAG) Program $ FE MA Assistance to Firefighters Grant 1 $ Public Safe $ - $ - $ - $ - $ - $ - $ 142,814 Total Expenditures $ - $ - $ - $ - $ - $ - $ 1,185,087 29 Attachment 1. Orange County The 2017 -18 Orange County Bud # 13 Technical #14. Emergency #16. Sherrffs Office - #17. Revised Vehicle # 18. Orange County Amendment- Social Telephone System #,,t Sat tp Orange Eire Yearend aQ.,t —t, in Replacment lntemal Food Council- receipt $ - $ - $ - $ Services - budget re- Fund(E911 Fund)- District - appropriation of the Jail Inmate Fund Service EUnd financial of Pass #hmugh funds purposed funds fmm fund balance $0 000 from the South end the Omg Forteitare plan for EV 2017 -18, tNeling $2,000 fmm the Budget as Amended Gmnt Project closed out appropriation of orange Fire ostdors Fund, as well as receipt end the closing oat of Towns of Chapel Hill Through BOA #10 9 an March 20, 2018 to Social Services within $44449 from the General EUnd to the eileble fund balance of e Alzheimer's Foundation of America the Vehicle Replacement lntemal end Hillsborough for se bythe Orange $ - the General Fund E911 Fund State Forfeiture Funds grant award of $2500 Service Fund County F.O Council $ 111,837 Jail Inmate Fund Revenues Appropriated Fund Balance $ - $ - $ - $ 84,732 $ - $ - $ 94,732 Total Revenues $ - $ - $ - $ 84,732 $ - $ - $ 94,732 Expenditures Transfer to General Fund $ - $ - $ - $ 84,732 $ - $ - $ 94,732 Drug Forfeiture Fund Revenues Federal Forfeiture Funds $ - $ - $ - $ 776,396 $ - $ - $ 776,396 State Forfeiture Funds $ 111,837 $ 111,837 Total Revenues is - $ - $ - $ 888,233 $ - $ - I $ 888,233 Expenditures Transfer to General Fund $ - $ - $ - $ 888,233 $ - $ - $ 888,233 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 1 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 Attachment 3 TOWN OF CARRBORO NORTH CAROLINA W W W,TOW NOFCARR80RO.ORG Paul Laughton, Deputy Director Orange County Finance and Administrative Sei vices 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, aw- a4_4� 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 22 "' day of May, 2018 The motion carried by the following vote: 301 WEST MAIN STREET, CARRBORO, NC 27510 • (919) 942 -8541 - FAX (919) 918 -4456 • V0ICE/TTY /TDD /ASCIL711 AN EQUAL OPPORTUNITY PROVIDER 34 TOWN OF CARRBORO NORTH CAROLINA WWWTOWNOFCARRB0R0,0RG Aye: Alderman Foushee, Alderman Slade, Alderman Haven-O'Donnell, Alderman Gist, Alderman Chaney and Mayor Lavelle Absent: Alderman Seils Catherilw 0klralldo I o% 11 Clwfk i�oj III(:,. I ov"I) fil'rchy 'kwo.oirw' i.:` a True aml cornm cop : ,)I' (,I rosib I I) t It a) I adopwd' b"'' dw (',,.inbot () I At s,,m I(,!' ;'� I J�:rmuw b. N' loll 301 WEST MAIN STREET, CARRBORO, NC 27510 • (919)942-8541- FAX (919) 918-4456 • VCICE/TTY/TDD/ASC1Ii711 AN EQUAL OPPORTUNITY PROVIDER Attachment 4 35 �J f� /iii,,,; 299 E. King Street Hillsborough, NC 27278 I www.orangecountyfirst.com 1 919,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 $ 61,432 —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. $10,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. 36 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.