The URL can be used to link to this page

Home My WebLink AboutAgenda - 03-20-2018 8-b - Fiscal Year 2017-18 Budget Amendment #7 ORD-2018-011 ORANGE COUNTY BOARD OF COMMISSIONERS ACTION AGENDA ITEM ABSTRACT Meeting Date: March 20, 2018 Action Agenda Item No. 8-b SUBJECT: Fiscal Year 2017-18 Budget Amendment #7 DEPARTMENT: Finance and Administrative Services ATTACHMENT(S): 1. Budget as Amended Spreadsheet 2. Year-to-Date Budget Summary INFORMATION CONTACT: Paul Laughton, (919)245-2152 Gary Donaldson, (919) 245-2453 PURPOSE: To approve budget, grant, and capital project ordinance amendments for fiscal year 2017-18 BACKGROUND: Social Services 1. The Department of Social Services has received additional revenue for the following programs: • Child Day Care Administration – receipt of additional administrative revenue of $14,111 from the State related to childcare services and subsidies to low-income families. • Café 113 – receipt of anticipated additional revenue of $11,000, based on current sales trend this fiscal year, through the sale of goods at the department’s Café 113 at Hillsborough Commons. This budget amendment provides for the receipt of these additional funds. (See Attachment 1, column 1) SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goal is applicable to this item: • 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. 1 2. The Department of Social Services has reviewed their multi-year Grant Projects (30 fund) and recommends closing several of these completed projects. This budget amendment provides for the closing out of prior year budgets to close out these grant projects, provides for the re-purposing of available funds of $83,186 to the Adoption Enhancement Fund (now proposed to be called “DSS Client Services Fund”), and amends the following grant project ordinances: (See Attachment 1, column 2) Close Out Grant Projects (Grant Projects Fund – Fund 30): Parent Education Initiative Grant Project (-$73,740) – Project # 304004 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Parent Education Initiative Funds $73,740 ($73,740) $0 Total Project Funding $73,740 ($73,740) $0 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Parent Education Initiative Project $73,740 ($73,740) $0 Total Costs $73,740 ($73,740) $0 Smart Start Child Care Subsidy Grant Project (-$219,858) – Project # 304051 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Smart Start Funds $219,858 ($219,858) $0 Total Project Funding $219,858 ($219,858) $0 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Child Care Subsidy Project $219,858 ($219,858) $0 Total Costs $219,858 ($219,858) $0 Fostering Youth Opportunities Grant Project (-$60,000) – Project # 71091 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised United Way Funds $60,000 ($60,000) $0 Total Project Funding $60,000 ($60,000) $0 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Fostering Youth Opportunities Project $60,000 ($60,000) $0 Total Costs $60,000 ($60,000) $0 2 Building Futures Program Grant Project (-$970,470) – Project # 71082 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Building Futures Program Funds $970,470 ($970,470) $0 Total Project Funding $970,470 ($970,470) $0 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Building Futures Program Grant Project $970,470 ($970,470) $0 Total Costs $970,470 ($970,470) $0 Community Response Program Grant Project (-$204,833) – Project # 71089 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Community Response Program Funds $214,833 ($204,833) $10,000 Total Project Funding $214,833 ($204,833) $10,000 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Community Response Program Grant Project $214,833 ($204,833) $10,000 Total Costs $214,833 ($204,833) $10,000 Re-Purpose Available Grant Projects Funds: Adoption Enhancement Fund (“DSS Client Services Fund”) ($83,186) – Fund 39 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised From Grant Projects $0 $83,186 $83,186 Adoption Services $27,268 $0 $27,268 Foster Care Donations $163,932 $0 $163,932 General Assistance $252,610 $0 $252,610 Adoption Enhancement $111,000 $0 $111,000 Special Child Incentive $121,665 $0 $121,665 From General Fund $76,945 $0 $76,945 Total Project Funding $753,420 $83,186 $836,606 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Adoption Enhancement Fund $753,420 $83,186 $836,606 Total Costs $753,420 $83,186 $836,606 3 SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goal is applicable to this item: • 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. 3. The Department of Social Services has also reviewed the Adoption Enhancement Fund (Fund 39), and recommends closing out some current accounts to improve the monitoring of this Fund, as well as changing the name of the Fund to the “DSS Client Services Fund”. This budget amendment provides for amending the Adoption Enhancement Fund (“DSS Client Services Fund”) by closing out prior year budgets totaling $138,268: (See Attachment 1, column 3) DSS Client Services Fund (-$138,268) – Fund 39 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised From Grant Projects $83,186 $0 $83,186 Adoption Services $27,268 ($27,268) $0 Foster Care Donations $163,932 $0 $163,932 General Assistance $252,610 $0 $252,610 Adoption Enhancement $111,000 ($111,000) $0 Special Child Incentive $121,665 $0 $121,665 From General Fund $76,945 $0 $76,945 Total Project Funding $836,606 ($138,268) $698,338 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Adoption Enhancement Fund $836,606 ($138,268) $698,338 Total Costs $836,606 ($138,268) $698,338 SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goal is applicable to this item: • 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. 4. The Department of Social Services recommends transferring the $10,000 remaining in FY 2017-18 budgeted funds within the Community Response Program Grant Project to the department’s Economic Services division within the General Fund for use in FY 2017- 18. This budget amendment provides for the transfer of these funds from the Grant Project to the General Fund, and amends and closes out the following Community Response Program Grant Project: (See Attachment 1, column 4) 4 Community Response Program Grant Project (-$10,000) – Project # 71089 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Community Response Program Funds $10,000 ($10,000) $0 Total Project Funding $10,000 ($10,000) $0 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Community Response Program Grant Project $10,000 ($10,000) $0 Total Costs $10,000 ($10,000) $0 SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goal is applicable to this item: • 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 Department 5. The Health Department has received notification from the N. C. Department of Health and Human Services, Division of Medical Assistance, of additional 2014 Medicaid Cost Settlement Funds totaling $34,664. This budget amendment provides for the receipt of these funds and amends the following Capital Project Ordinance for the receipt of the additional $34,664 in the Medicaid Maximization Capital Project. Medicaid Maximization Capital Project ($34,664) - Project # 30012 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Medicaid Maximization Funds $7,405,759 $34,664 $7,440,423 Total Project Funding $7,405,759 $34,664 $7,440,423 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Medicaid Maximization Project $7,405,759 $34,664 $7,440,423 Total Costs $7,405,759 $34,664 $7,440,423 SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goal is applicable to this item: • 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. 5 This budget amendment provides for the receipt of these additional funds. (See Attachment 1, column 5) Library Services 6. The Orange County Library has received a donation of $1,000 through the Triangle Community Foundation by the Greenwald Family Charitable Trust. These funds will be used to support Summer Learning kickoff events and programming throughout the summer. This budget amendment provides for the receipt of these donated funds. (See Attachment 1, column 6) SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goal is applicable to this item: • GOAL: CREATE A SAFE COMMUNITY The reduction of risks from vehicle/traffic accidents, childhood and senior injuries, gang activity, substance abuse and domestic violence. 7. The Orange County Library has received notification from the Orange County Partnership for Young Children of additional funds of $2,025 for the department’s Outreach Literacy MotheRead Program. This budget amendment provides for the receipt of these additional funds and amends the following grant project ordinance: (See Attachment 1, column 7) Library Outreach Literacy Grant – “MotheRead” ($2,025) - Project # 71356 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Smart Start funds $14,066 $2,025 $16,091 Friends of OC Library $ 4,000 $0 $4,000 From General Fund $ 3,700 $0 $3,700 Total Project Funding $21,766 $2 025 $23,791 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Literacy “MotheRead” Grant $21,766 $2,025 $23,791 Total Costs $21,766 $2,025 $23,791 SOCIAL JUSTICE IMPACT: There is no Orange County Social Justice Goal impact associated with this item. Economic Development - Visitors Bureau 8. The Economic Development Department has received additional revenue through the Visitor’s Bureau, from the Town of Chapel Hill, for surpassing FY 2016-17 performance benchmarks. The Town of Chapel Hill agreed to award the Visitors Bureau 50% of revenues, from hotel/motel occupancy receipts of collections exceeding $1,000,000. The Visitors Bureau met this performance goal and received additional revenue of $93,755, from the Town of Chapel Hill. The Bureau will use the funds for Spring/Summer advertising in Our State Magazine and This is Tourism radio spots on WCHL, as well as 6 the publication of an Orange County Neighborhood Guide. This budget amendment provides for the receipt of these additional funds. (See Attachment 1, column 8) SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goal is applicable to this agenda item: • GOAL: ENSURE ECONOMIC SELF-SUFFICIENCY The creation and reservation of infrastructure, polices, programs and funding necessary for resident to provide shelter, food, clothing and medical care for themselves and their dependents. County Manager’s Office – Arts Commission 9. The County Manager’s Office has received a total $1,234 from Hillsborough Arts Commission. This represents funds raised through the 2017 Paint It Orange Plein Air Paint-out, which was a joint fundraiser with the Hillsborough Arts Council this past fall. This budget amendment provides for the receipt of these funds for use in FY 2017-18 by the Orange County Arts Commission within the Visitors Bureau Fund. (See Attachment 1, column 9) SOCIAL JUSTICE IMPACT: There is no Orange County Social Justice Goal impact associated with this item. Criminal Justice Resource Department 10. The County has received funds of $23,667 from Cardinal Innovations as a refund from maintenance of efforts funds provided to Cardinal Innovations in FY 2016-17. These funds will be used by the Orange County Criminal Justice Department for several contract services in FY 2017-18, as well as encumbering some of the funds for use in FY 2018-19. This budget amendment provides for the receipt of this refund for the above stated purpose. (See Attachment 1, column 10) SOCIAL JUSTICE IMPACT: There is no Orange County Social Justice Goal impact associated with this item. County Manager’s Office – Orange County Partnership to End Homelessness 11. The Orange County Partnership to End Homelessness has received notification from the Triangle Community Foundation of a sponsorship award of $1,000. These funds will be used to help support the Point-in-Time street count. This budget amendment provides for the receipt of these funds within the Community Development Fund, outside of the General Fund. (See Attachment 1, column 11) 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 7 origin or ethnic background; age; military service; disability; and familial, residential or economic status. • GOAL: ENSURE ECONOMIC SELF-SUFFICIENCY The creation and reservation of infrastructure, polices, programs and funding necessary for resident to provide shelter, food, clothing and medical care for themselves and their dependents. Planning and Inspections Department 12. The Orange County Planning Department requests the transfer of available funds of $26,767 from the completed Buckhorn EDD Phase 2 capital project to the Efland Sewer to Mebane Phase 2 Extension capital project, in order to facilitate possible future extension and sewer line connections by having additional geotechnical work completed near the new infrastructure. This type of work was suggested by the EDD SWOT consultant. This budget amendment transfers $26,767 from the Buckhorn EDD Phase 2 project to the Efland Sewer to Mebane Phase 2 project, and amends both Capital Project Ordinances as follows: Buckhorn EDD Phase 2 (-$26,767) - Project # 30040 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Alternative Financing $4,256,046 $0 $4,256,046 Appropriated Fund Balance $200,000 $0 $200,000 From General Fund $135,500 ($26,767) $108,733 Total Project Funding $4,591,546 ($26,767) $4,564,779 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Professional Services $475,000 $0 $475,000 Construction $4,016,546 ($26,767) $3,989,779 Contingency $100,000 $0 $100,000 Total Costs $4,591,546 ($26,767) $4,564,779 Efland Sewer to Mebane, Phase 2 Extension ($26,767) - Project # 30044 Revenues for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Alternative Financing $4,581,400 $0 $4,581,400 From General Fund $ 151,600 $26,767 $178,367 Total Project Funding $4,733,000 $26,767 $4,759,767 Appropriated for this project: Current FY 2017-18 FY 2017-18 Amendment FY 2017-18 Revised Land & Associated Costs $40,000 $0 $40,000 Professional Services $462,860 $0 $462,860 8 Construction $4,206,690 $26,767 $4,233,457 Project Management $23,450 $0 $23,450 Total Costs $4,733,000 $26,767 $4,759,767 SOCIAL JUSTICE IMPACT: There is no Orange County Social Justice Goal impact associated with this item. Department of Environment, Agriculture, Parks and Recreation (DEAPR) 13. The Department of Environment, Agriculture, Parks and Recreation has received additional revenues from athletic rentals, facility rentals, concessions, and recreation fees totaling $44,304. These funds will be used for seasonal staff cost, contract services, and supplies associated with summer camp and other athletic and recreational programs. This budget amendment provides for the receipt of these additional revenues. (See Attachment 1, column 12) SOCIAL JUSTICE IMPACT: The following Orange County Social Justice Goal is 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. 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 $108,082, decreases the Grant Projects Fund by $1,536,878, decreases the Adoption Enhancement Fund (“DSS Client Services Fund”) by $55,082, increases the Visitor’s Bureau Fund by $94,989, increases the Community Development Fund by $1,000, and increases the County Capital Fund by $34,664. RECOMMENDATION(S): The Manager recommends the Board approve budget, grant, and capital project ordinance amendments for fiscal year 2017-18. 9 1 Attachment 1. Orange County Proposed 2017-18 Budget Amendment The 2017-18 Orange County Budget Ordinance is amended as follows: Original Budget Encumbrance Carry Forwards Budget as Amended Budget as Amended Through BOA #6-B #1 Social Services - receipt of $14,111 additional administrative revenue from the State related to childcare services; and receipt of anticipated $11,000 additional revenue from the sale of goods at Café 113 at Hillsborough Commons #2 Social Services - close out and re- purpose funds associated with completed multi-year grant projects #3 Social Services - close out some prior year accounts in the Adoption Enhancement Fund ("DSS Cleint Services Fund") #4 Social Services - transfer remaining $10,000 in the Community Response Program Grant Project to Social Services within the General Fund #5 Health Department - receipt of $34,664 in additional 2014 Medicaid Cost Settlement Funds in the County Capital Fund #6 Library Services - receipt of $1,000 donation through the Triangle Community Foundation #7 Library Services - receipt of $2,025 in additional funds for the department's Outreach Literacy Motheread Program in the Grant Projects Fund #8 Economic Developemt - Visitor's Bureau receipt of $93,755 in additional revenue from the Town of Chapel Hill for surpassing FY 2016-17 performance benchmarks #9 County Manager's Office - Arts Commission (Visitor's Bureau Fund) receipt of $1,234 from the Hillsborough Arts Commission for the 2017 Paint It Orange Plein Air Paint-out event #10 Criminal Justice Resource Department - receipt of a $23,667 refund from Cardinal Innovations maintenance of effort funds #11 County Manager's Office - Orange County Partnership to End Homelessness receipt of $1,000 from Triangle Community Foundation to help support the Point-in-Time street count #12 DEAPR - receipt of $44,304 in additional revenues from athletic rentals, facility rentals, concessions, and recreation fees Budget as Amended Through BOA #7 General Fund Revenue Property Taxes 151,557,768$ -$ 151,557,768$ 151,557,768$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 151,557,768$ Sales Taxes 23,566,784$ -$ 23,566,784$ 23,566,784$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 23,566,784$ License and Permits 328,000$ -$ 328,000$ 328,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 328,000$ Intergovernmental 16,035,147$ -$ 16,035,147$ 17,223,266$ 14,111$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 17,237,377$ Charges for Service 11,551,045$ -$ 11,551,045$ 11,491,248$ 11,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 44,304$ 11,546,552$ Investment Earnings 265,000$ 265,000$ 265,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 265,000$ Miscellaneous 2,817,629$ 2,817,629$ 2,972,011$ 1,000$ 23,667$ 2,996,678$ Transfers from Other Funds 3,765,600$ 3,765,600$ 3,775,600$ 10,000$ 3,785,600$ Fund Balance 9,769,060$ 1,313,300$ 11,082,360$ 11,143,693$ 11,143,693$ Total General Fund Revenues 219,656,033$ 1,313,300$ 220,969,333$ 222,323,370$ 25,111$ -$ -$ 10,000$ -$ 1,000$ -$ -$ -$ 23,667$ -$ 44,304$ 222,427,452$ Expenditures Support Services 14,101,197$ 259,608$ 14,360,805$ 14,360,805$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 14,360,805$ General Government 21,638,717$ 49,113$ 21,687,830$ 21,687,830$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 21,687,830$ Community Services 14,331,974$ 164,719$ 14,496,693$ 14,557,618$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 44,304$ 14,601,922$ Human Services 37,508,468$ 390,154$ 37,898,622$ 38,565,279$ 25,111$ -$ -$ 10,000$ -$ 1,000$ -$ -$ -$ -$ -$ -$ 38,601,390$ Public Safety 25,583,899$ 449,706$ 26,033,605$ 26,141,155$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 23,667$ -$ -$ 26,164,822$ Education 104,991,508$ 104,991,508$ 104,991,508$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 104,991,508$ Transfers Out 1,500,270$ 1,500,270$ 2,019,175$ 2,019,175$ Total General Fund Appropriation 219,656,033$ 1,313,300$ 220,969,333$ 222,323,370$ 25,111$ -$ -$ 10,000$ -$ 1,000$ -$ -$ -$ 23,667$ -$ 44,304$ 222,427,452$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Visitors Bureau Fund Revenues Occupancy Tax 1,278,341$ 1,278,341$ 1,278,341$ 1,278,341$ Sales and Fees 500$ 500$ 500$ 93,755$ 94,255$ Intergovernmental 230,330$ 230,330$ 236,913$ 236,913$ Investment Earnings 100$ 100$ 100$ 100$ Miscellaneous -$ -$ 2,000$ 1,234$ 3,234$ Appropriated Fund Balance 118,588$ 4,000$ 122,588$ 323,588$ 323,588$ Total Revenues 1,627,859$ 4,000$ 1,631,859$ 1,841,442$ -$ -$ -$ -$ -$ -$ -$ 93,755$ 1,234$ -$ -$ -$ 1,936,431$ Expenditures Community and Environment 1,627,859$ 4,000$ 1,631,859$ 1,841,442$ 93,755$ 1,234$ 1,936,431$ County Capital Project Fund Revenues Transfer From the General Fund 320,000$ 320,000$ 518,000$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 518,000$ Transfer From E911 Fund -$ -$ -$ -$ Medicaid Maximization Funds -$ -$ 34,664$ 34,664$ Total Revenues 320,000$ -$ 320,000$ 518,000$ -$ -$ 34,664$ -$ -$ -$ -$ -$ -$ -$ 552,664$ Expenditures County Capital Projects 320,000$ 320,000$ 518,000$ -$ -$ 34,664$ -$ -$ -$ -$ -$ -$ -$ 552,664$ 10 2 Attachment 1. Orange County Proposed 2017-18 Budget Amendment The 2017-18 Orange County Budget Ordinance is amended as follows: Original Budget Encumbrance Carry Forwards Budget as Amended Budget as Amended Through BOA #6-B #1 Social Services - receipt of $14,111 additional administrative revenue from the State related to childcare services; and receipt of anticipated $11,000 additional revenue from the sale of goods at Café 113 at Hillsborough Commons #2 Social Services - close out and re- purpose funds associated with completed multi-year grant projects #3 Social Services - close out some prior year accounts in the Adoption Enhancement Fund ("DSS Cleint Services Fund") #4 Social Services - transfer remaining $10,000 in the Community Response Program Grant Project to Social Services within the General Fund #5 Health Department - receipt of $34,664 in additional 2014 Medicaid Cost Settlement Funds in the County Capital Fund #6 Library Services - receipt of $1,000 donation through the Triangle Community Foundation #7 Library Services - receipt of $2,025 in additional funds for the department's Outreach Literacy Motheread Program in the Grant Projects Fund #8 Economic Developemt - Visitor's Bureau receipt of $93,755 in additional revenue from the Town of Chapel Hill for surpassing FY 2016-17 performance benchmarks #9 County Manager's Office - Arts Commission (Visitor's Bureau Fund) receipt of $1,234 from the Hillsborough Arts Commission for the 2017 Paint It Orange Plein Air Paint-out event #10 Criminal Justice Resource Department - receipt of a $23,667 refund from Cardinal Innovations maintenance of effort funds #11 County Manager's Office - Orange County Partnership to End Homelessness receipt of $1,000 from Triangle Community Foundation to help support the Point-in-Time street count #12 DEAPR - receipt of $44,304 in additional revenues from athletic rentals, facility rentals, concessions, and recreation fees Budget as Amended Through BOA #7 Community Development Fund (Homelessness Partnership) Revenues General Government Revenue -$ -$ -$ -$ 1,000$ 1,000$ Intergovernmental 86,406$ 86,406$ 102,046$ 102,046$ Appropriated Fund Balance 41,000$ 41,000$ 41,000$ 41,000$ Transfer from General Fund 43,096$ 43,096$ 43,096$ 43,096$ Total Revenues 170,502$ -$ 170,502$ 186,142$ -$ -$ -$ -$ -$ -$ -$ -$ 1,000$ -$ 187,142$ Expenditures Homelessness Partnership Program 170,502$ 170,502$ 186,142$ 1,000$ 187,142$ Grant Project Fund Revenues Intergovernmental 2,147,149$ 2,147,149$ 2,070,815$ (1,455,945)$ (10,000)$ 2,025$ 606,895$ Charges for Services 65,000$ 65,000$ 85,000$ 85,000$ Transfer from General Fund 128,632$ 128,632$ 128,632$ (72,956)$ 55,676$ Miscellaneous -$ -$ -$ Transfer from Other Funds -$ -$ -$ Appropriated Fund Balance -$ 2,731$ 2,731$ 2,731$ 2,731$ Total Revenues 2,340,781$ 2,731$ 2,343,512$ 2,287,178$ -$ (1,528,901)$ -$ (10,000)$ -$ -$ 2,025$ -$ -$ -$ -$ -$ 750,302$ 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 -$ -$ Community Services -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Parent Ed Initiative - DSS (Multi-year)73,740$ 73,740$ 73,740$ (73,740)$ -$ Child Care Subsidy - DSS (Multi-year)219,858$ 219,858$ 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$ 166,157$ CARES Grant - Aging (Multi-Year)339,708$ 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 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$ 25,000$ FY 2009 Recovery Act HPRP -$ -$ -$ Community Response Program - DSS (Mu 204,833$ 204,833$ 214,833$ (204,833)$ (10,000)$ -$ Susan G Komen Grant -$ -$ -$ Building Futures Program - DSS (Multi-Yr)970,470$ 970,470$ 970,470$ (970,470)$ -$ Foster Youth Opportunities- DSS (Multi-ye 60,000$ 60,000$ 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$ 52,832$ Outreach Literacy MotheRead-Library 21,766$ 2,025$ 23,791$ Human Services 2,340,781$ 2,731$ 2,343,512$ 2,144,364$ -$ (1,528,901)$ -$ (10,000)$ -$ -$ 2,025$ -$ -$ -$ -$ -$ 607,488$ 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$ 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$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 142,814$ Total Expenditures 2,340,781$ 2,731$ 2,343,512$ 2,287,178$ -$ (1,528,901)$ -$ (10,000)$ -$ -$ 2,025$ -$ -$ -$ -$ -$ 750,302$ Adoption Enhancement Fund ("DSS Client Services Fund") Revenues Intergovernmental 131,865$ 131,865$ 251,884$ -$ (111,000)$ -$ -$ -$ -$ -$ -$ -$ -$ 140,884$ General Government 424,591$ 424,591$ 424,591$ (27,268)$ 397,323$ Transfer from Grant Projects 76,945$ 76,945$ 76,945$ 83,186$ 160,131$ Total Revenues 633,401$ -$ 633,401$ 753,420$ -$ 83,186$ (138,268)$ -$ -$ -$ -$ -$ -$ -$ -$ 698,338$ Expenditures General Assistance 633,401$ 633,401$ 753,420$ -$ 83,186$ (138,268)$ -$ -$ -$ -$ -$ -$ -$ -$ 698,338$ 11 Attachment 2 General Fund Budget Summary Original General Fund Budget $219,656,033 Additional Revenue Received Through Budget Amendment #7 (March 20, 2018) Grant Funds $216,111 Non Grant Funds $1,180,675 General Fund - Fund Balance for Anticipated Appropriations (i.e. Encumbrances)$1,313,300 General Fund - Fund Balance Appropriated to Cover Anticipated and Unanticipated Expenditures $61,333 Total Amended General Fund Budget $222,427,452 Dollar Change in 2017-18 Approved General Fund Budget $2,771,419 % Change in 2017-18 Approved General Fund Budget 1.26% 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 Year-To-Date Budget Summary Fiscal Year 2017-18 Authorized Full Time Equivalent Positions 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) 12