Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Welcome 2020 – 2021
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Tax Rate Summary Summary The District’s overall tax rate remains unchanged from the prior year ($0.46 per $100 taxable value), and the Defined Area Interest and Sinking Fund (Debt Service) tax rate has been lowered by $0.005 per $100 assessed valuation. Due to increases in certified assessed valuations within the District, the adopted tax rates will result in a modest increase in property tax revenues for the District. Taxable Valuations 2020 District Taxable Valuation1: $2,206,313,816 Defined Area Taxable Valuation2: $521,736,141
2019 District Taxable Valuation: $2,170,989,094 Defined Area Taxable Valuation: $516,650,174
Adopted Tax Rates District MO Tax Rate District DS Tax Rate Defined Area DS Tax Rate
2020 Adopted Tax Rates $0.32 per $100 $0.14 per $100 $0.16 per $100
2019 Adopted Tax Rates $0.32 per $100 $0.14 per $100 $0.165 per $100
Projected Tax Revenues District MO Tax Revenue District DS Tax Revenue Defined Area DS Tax Revenue
2020 Projected Tax Revenues $6,919,0003
2019 Tax Revenues $6,674,984
$3,027,0624
$3,004,428
$818,0825
$864,119
1
Based on WCAD Certified Assessed Valuation of $2,141,343,817 plus $64,969,999 taxpayers’ estimate of value under protest furnished by WCAD. 2 Based on WCAD Certified Assessed Valuation of $501,020,443 plus $20,715,698 taxpayers’ estimate of value under protest furnished by WCAD. 3 Based on a District M&O Tax Rate of $0.3200 per $100 of assessed value with a 98% estimated collection rate: $2,206,313,816 * $0.3200 / $100 * 98% = $6,919,000 4 Based on a District Debt Service (I&S) Tax Rate of $0.1400 per $100 of assessed value with a 98% estimated collection rate: $2,206,313,816 * $0.1400 / $100 * 98%= $3,027,062 5 Based on a Defined Area I&S Rate of $$0.16 per $100 of assessed valuation with a 98% estimated collection rate: $521,736,141 * $0.16 / $100 * 98% = $818,082
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Tax Rate Summary Comments and Analysis
1. The Tax Year 2020 average tax liability per District homestead is $1,628.99, which represents an increase of $49.20 compared to 2019.6 2. The Tax Year 2020 average tax liability for Defined Area taxes per Defined Area homestead is $721.54, which represents a decrease of $1.26 compared to 2019.7 3. The Tax Year 2020 average total tax liability (including both District taxes and Defined Area taxes) per Defined Area homestead is $2,795.97, which represents an increase of $58.09 compared to 2019.8 4. Each $0.01 (penny) of District tax is projected to generate $216,218.75 in projected District tax revenues.9 5. Each $0.01 (penny) of Defined Area tax is projected to generate $51,130.14 in projected Defined Area tax revenues.10
6
Based on 2020 Average Taxable Homestead Value furnished by WCAD ($354,129.52) multiplied by total District tax rate ($0.46); and, a 2019 Average Taxable Homestead Value furnished by WCAD ($342,778.65) multiplied by a 2019 Total District Tax Rate ($0.46). 7 Based on 2020 Average Taxable Value for Defined Area Homestead furnished by WCAD ($450,962.44) multiplied by a Defined Area Tax Rate ($0.16); and, a 2019 Average Taxable Homestead Value furnished by WCAD ($438,060.12) multiplied by a 2019 Defined Area Tax Rate ($0.165). 8 Based on 2020 Average Taxable Value for Defined Area Homestead furnished by WCAD ($450,962.44) multiplied by $0.62 total combined tax rate of the District and Defined Area; and, a 2019 Average Taxable Value for Defined Area Homestead furnished by WCAD ($438,060.12) multiplied by $0.625 total combined 2019 tax rate of the District and Defined Area. 9 Based on total taxable value in District ($2,206,313,816) multiplied by $0.01 tax rate multiplied by 98% collection rate. 10 Based on total taxable value in Defined Area ($521,736,141) multiplied by $0.01 tax rate multiplied by 98% collection rate.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
i
HISTORY OF BRUSHY CREEK When was the District Established? Brushy Creek Municipal Utility District (the District) was originally created as “Williamson County Municipal Utility District No. 2� on October 27, 1977 with a confirmation election held on January 21, 1978. The original area encompassed approximately 725 acres of land. An annexation in 1983 involving most of the land in the present District south of Brushy Creek increased that number to 2,210 acres. On August 31, 1990, the District name was changed to Brushy Creek Municipal Utility District. Area Today the District includes nearly 2,300 acres in two, non-contiguous areas. One area is generally located between Sam Bass Road and FM 1431 (Brushy Creek North) and the other area is generally located south of Brushy Creek, including an area south of FM 620. The HOAs in the District include: Brushy Creek North, Sendero Springs, Brushy Creek South, Liberty Village/Neenah Oaks, the Villages of Brushy Creek, Hunter Brook, Cat Hollow, Cat Hollow Condominiums, Meadows of Brushy Creek, the Woods of Brushy Creek, Woods of Brushy Creek Sec VI, Woods of Brushy Creek VII, Highlands of Brushy Creek, Highland Horizon and the Enclave at Highland Horizon. Extra-Territorial Jurisdictions For the first 20 years, parts of the District were included in the extra-territorial jurisdictions (ETJ) of Austin and Round Rock. In 1997, the BCMUD Board of Directors chose to move all District land into the ETJ of Round Rock. What is a MUD? Municipal Utility Districts (MUDs) are one type of special district allowed by Texas law that functions as an independent, limited government. These special districts are governed by a Board of elected district residents and property owners, and have responsibility for providing water, wastewater and drainage services as well as parks and recreation. A MUD lying in an ETJ of a city can be annexed by that city subject to certain provisions and requirements in the state law.
Original District Office
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
ii
HISTORY OF BRUSHY CREEK Water Service Through the years, Brushy Creek Municipal Utility District has provided water service from both groundwater wells and water purchased from the City of Round Rock. The District now treats raw water from Lake Georgetown and its own groundwater wells with advanced membrane filtration technology at the District Water Facility located on Sam Bass Road. Wastewater Service Brushy Creek Municipal Utility District’s wastewater is treated by the Brushy Creek Regional Wastewater Treatment Plant owned by the cities of Round Rock, Austin, and Cedar Park. The District previously operated wastewater treatment plants located in both the North and South portions of the District.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
iii
HISTORY OF BRUSHY CREEK Parks and Recreation The District's parks and recreation programs and facilities have grown dramatically. A portion of the funding was provided by developer fees paid on each new lot sold. The District parks include Sendero Springs Park, Brushy Creek North Park, Creekside Park, Shirley McDonald Park (duck pond), Cat Hollow Park, Pepper Rock Park, Racine Woods Park, Little Village Park, Highland Horizon Park, Sendero Valley Park, and Community Park. The District has numerous trails and greenbelts, an 18-hole disc golf course, and a Community Center with over 60,000 square feet of recreation and meeting space. The Community Center originally opened in 2004 with 35,000 square feet and was expanded and renovated in 2017. The District also owns and operates four swimming pools. The District has sought to provide a sense of community through exceptional utility services, parks, recreation, and a staff dedicated to maintaining the high quality Brushy Creek Life for residents.
Established 1977
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
2
INTRODUCTION How To Use This Document The Annual Budget Document for Fiscal Year 2021, beginning October 1, 2020, is presented as a Board approved policy document, a financial plan, an operations guide, and a communications device prepared in alignment with the Government Finance Officers Association's best practices. As such, the budget conveys how the District will translate Board policy and intentions into services and organizational priority, providing scope to operational activities for the fiscal year. The Budget Message section expresses Board policy and strategic goals. The District Programs section interprets Board policy and goals into planned programs and operations. The Consolidated Financials demonstrates how limited revenues fund planned programs and operations. The Budget Message identifies fund descriptions and structures, fund relationships, the basis of budgeting, and financial policies. The District Program section provides an overview of revenues, expenditures, and capital: the effects of long-term financial plans; short-term factors influencing decisions; priorities and issues which significantly changed from the prior fiscal year; and the impact of capital improvements. Identified with the document are the budgeting process, organization descriptions, and position summaries. The Consolidated Financials provide fund financial schedules, fund balances, revenue sources, capital expenditures, and legal debt limits.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
3
INTRODUCTION Table of Contents District Leadership .......................................................................................................... 4 Board of Director's Message ..................................................................................... 5 Budget Process ......................................................................................................... 6 Vision ........................................................................................................................ 7 Fiscal Year 2020 – 2021 Strategic Goals .................................................................. 8 Resident Advisory Committees ................................................................................. 9 Parks and Space Open Master Plan 2012 – 2022 .................................................. 10 Asset Management Plan ......................................................................................... 12 External Short-term Budget Factors ........................................................................ 13 Funding Sources .......................................................................................................... 14 Revenues ................................................................................................................ 14 Taxable Assessed Values ....................................................................................... 15 Property Tax Rate ................................................................................................... 16 Property Tax Rate History ....................................................................................... 17 Utility Rates ............................................................................................................. 18 District Funding ............................................................................................................. 19 Fund Descriptions and Structure ............................................................................. 19 Financial Policies: Fund Balance ............................................................................ 20 Financial Policies: Expenditure ............................................................................... 21 Budget Funding Plan .............................................................................................. 22 General Fund ................................................................................................................ 23 Debt Service Fund......................................................................................................... 36 Consolidated Financial Statements .............................................................................. 44
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
4
DISTRICT LEADERSHIP
Place 1 Director .................................... REBECCA B. TULLOS Place 2 Director ......................................... MICHAEL TUCKER Place 3 Director .......................................... KIM FILIATRAULT Place 4 Director ....................................... DONNA B. PARKER Place 5 Director ........................................ SHEAN R. DALTON
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
5
DISTRICT LEADERSHIP Board of Directors’ Budget Message We are pleased to present the approved Budget for the Fiscal Year 2021, which keeps the District tax rate the same as in 2020 and decreases the Defined Area tax rate. The approved tax rates are projected to raise more revenue from property taxes than last year's budget by an amount of $51,400, which is a 0.7% increase from last year's budget. We remain focused on our key strategic goals while meeting the challenge of limited funding with innovative service delivery that our residents have come to expect. Input from District Resident Advisory Committees, the Ten-Year Parks and Open Spaces Master Plan was approved in 2011, and the long-range Financial Plan guided our decisions in preparing the FY2021 Budget. The Board of Directors establishes District Goals each year, which provide strategic direction to the District's operations, programming, capital projects, and long-term planning. The goals adopted for the 2018-2021 fiscal years are available in this budget document. No Increase on Total Tax and Defined Area Tax Decreased The total District tax rate remains the same as last year at $.4600 per $100 of assessed valuation. The budget also includes a $0.005 decrease in the District's Defined Area tax rate to $.1600 per $100 of assessed valuation. The Defined Area tax is levied to cover debt service. These tax rates are accommodated in our long-range plan and will allow us to meet all obligations and continue to provide quality service levels. Water and Wastewater rates remain the same for purposes of the Fiscal Year 2021 Budget. Parks & Recreation Improvements Continuing the District's priority of providing high-quality parks and recreation amenities, the FY2021 Budget includes funding for new equipment and projects including: • Community Park turn around • Design of the Community Park playground • Expansion and redesign of the Sendero Springs Pool building • Revitalization of the Community Center Demonstration Garden • Pepper Rock Park Expansion Phase II • Creekside pool deck replacement Utility Projects The FY2021 Budget supports the Board's commitment to improving the utility infrastructure with funding for the following projects/purchases in alignment with the District's long-term plans: • Improvements to the water system to mitigate the impact of Zebra Mussels at the raw water intake structure at Lake Georgetown and Lake Stillhouse • Improvements at four wastewater lift stations • Upgraded Woods Lift Station Conclusion The FY2021 Budget addresses the Board's top priorities, including an emphasis on maintaining and improving existing facilities most cost-effectively while continuing to deliver services at a level that reflects "The Brushy Creek Life."
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
6
DISTRICT LEADERSHIP Budget Process The budget process is a year-round initiative to articulate regulatory, legislative, community, and infrastructure priorities into strategic goals. The goals, in turn, define long term plans and budget year programs. The budget programs, goals, and priorities factor into making budget requests. Requests are refined into a balanced budget proposal. The 2021 Fiscal Year Budget Process, and procedures for adoption of 2020 Tax Year Tax Rates, are summarized below: Salary and Benefit projections ........................................................................................ January Approve Parks Master Plan projects ............................................................................ February Approve Updates to Financial Model ............................................................................ February Strategic Planning and Goals ........................................................................................ February Budget request submissions by department:
payroll .................................................. April 02 revenue and M&O ............................... April 09 capital ................................................... April 16
Board of Director's review of budget requests: Public Works ........................................ April 16 Parks and Recreation .......................... April 30 Department manager Budget meetings ............................................................. 1st Week in May Draft Budget presentation to Board Treasurer .................................................................. May 08 Board reviews FY 2021 Project Concepts:
Admin and Utilities ............................... May 14 Parks and Recreation ........................... May 28
Draft Budget presentation to Board ................................................................................. May 28 Issuance of approved Appraisal Rolls by WCAD ............................................................. July 23 Calculation of Mandatory Election Tax Rates .................................................................. July 27 Board budget presentation (Include calculations and tax rates) ..................................August 13 Board presentation to Adopt Proposed Tax Rate ........................................................August 27 Proposed tax rates Public Hearing notice published (7 days prior to the hearing) ............August 28 Public Hearing and Board Adoption of an Order Levying Final Tax Rates for Tax Year 2020 .......................................................................................................... Sept. 10 Furnish copy of Order Adopting Tax Rates to Tax Assessor/Collector .......................... Sept. 15 Board Resolution Approving fund balance policy and commitments ............................. Sept. 24
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
7
DISTRICT LEADERSHIP Vision The vision of the Brushy Creek Municipal Utility District is to ensure we continually provide carefully managed and sustainable community infrastructure. Foremost, the high-efficiency delivery of a recognized Superior quality rated water and amenities and services, which support and preserve the natural elements of Brushy Creek, and provides our residents with access to parks, attractions, programs, and recreational opportunities that appeal to a growing and diverse population. This is "The Brushy Creek Life."
Strategic Goals and Priorities for Fiscal Year 2020 – 2021 1. The Brushy Creek Life Branding and Awareness a) Promote opportunities throughout the District that promote The Brushy Creek Life in a variety of ways that appeal to District residents; b) Integrate The Brushy Creek Life brand into the Community so that it becomes what we are known for; and c) Revitalize the Community Center Demonstration Garden to facilitate educational and social opportunities, promoting The Brushy Creek Life through the nurturing and enjoyment of our natural resources. 2. Service and Management a) Continue engagement with advisory committees and seek feedback on District activities and operations; b) Continue to place an important emphasis on customer relations and satisfaction by developing, monitoring, and evaluating ways to deliver exceptional customer service; c) Leverage parks and recreational spaces to fulfill needs identified by the District and expressed by the Community;
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
8
DISTRICT LEADERSHIP Strategic Goals and Priorities Fiscal Year 2020 – 2021 (continued) d) Assess risk for District operations, assets, and programs, ensuring proper oversight and mitigation; e) Support initiatives and programs that make technology the cornerstone of the District for effective and efficient operations; f) Maintain the continuity and integrity of the Board relations/communications model to facilitate effective governance and oversight of District matters; and g) Update and continually monitor the District's financial reports and planning models to ensure fiscal stability. 3. Diversified and Expanded Programming a) Promote effective Community outreach and engagement throughout the District; and b) Embrace multi-cultural populations through programming, events, and activity with emphasis on teen and active adult programming. 4. Regulatory Management & Oversight a) Ensure utility system infrastructure and lift stations are properly managed and evaluated; b) Evaluate and update the District's Karst feature management protocols to assess effectiveness and compliance; and c) Manage the District's assets to ensure proper utilization and care and conduct assessments of conditions. 5. Partnerships a) Grow, expand, and nurture relationships with Community partners including local municipalities and leaders to look for opportunities to promote and protect the District's interests; and b) Evaluate, leverage, and mitigate the impact of growth surrounding the District and engage with partners and others to ensure that The Brushy Creek Life is a valued consideration.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
9
DISTRICT LEADERSHIP Resident Advisory Committees UTILITIES INFRASTRUCTURE ADVISORY COMMITTEE The Utilities Infrastructure Advisory Committee advises the Board of Directors regarding the management, enhancement, and expansion of District water supply and wastewater facilities, and general planning for the District. PARKS & RECREATION COMMITTEE The Parks & Recreation Committee works with staff to advise the Board of Directors regarding parks and recreation policy matters, capital expenditures, budgetary oversight as well as the management, maintenance, enhancement, and expansion of District parks, pools, greenbelts, and recreational areas and programs. COMMUNITY CENTER ADVISORY COMMITTEE The Community Center Advisory Committee (CCAC) provides an opportunity to provide meaningful input and assistance to improve the Community Center and its operations for the benefit of the Community.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
10
DISTRICT LEADERSHIP Parks and Open Space Master Plan 2012 – 2022 The Park and Open Space Master Plan Advisory Committee established a blueprint for parks development and maintenance of facilities and assisted in the decision-making process for allocating resources. The goals, objectives, and strategies provide the vision for what the community wants for its park and recreation system as well as recommending priorities for the parks system and Community Center. Goals •
Provide facilities and programs that meet or exceed the expectations of the users.
•
Provide for a diversity of recreational opportunities that will serve all of the neighborhoods and age groups in Brushy Creek MUD including parks and open space during the planning period
•
Expand the parks system to include undeveloped properties owned or controlled by the Brushy Creek MUD within available resources.
•
Maintain and upgrade the Community Center Complex to meet the short term and longterm recreational needs of the residents and members.
•
Future development should be affordable from both a development and operations and maintenance perspective.
•
Parks, open space and recreational amenities are critical to maintaining property values in the District. The District needs to effectively maintain existing parks and recreational facilities during the planning period.
•
Develop parks and recreational opportunities and programs that will educate and enable residents to develop a greater understanding of local natural resources and the importance of protecting those resources for future generations.
Objectives
•
Develop parks and recreation standards for different types of parks, open space, and recreational facilities.
•
Maintain existing facilities and provide recreational amenities so that residents don't have to travel to other areas.
•
Identify public and private property that is available for acquisition and/or development.
•
Work with other political subdivisions and private interests to develop park projects that are cost-effective.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
11
DISTRICT LEADERSHIP Parks and Open Space Master Plan 2012 – 2022 (continued) Objectives
•
Work with other political subdivisions and private interests to develop park and recreation projects that are not duplicative.
•
Identify and expand potential revenue-producing activities.
•
Develop a method to prioritize how available resources are allocated.
•
Work with other political subdivisions to link facilities and properties.
•
Work with private property owners to assure that park and recreational amenities are available for new developments within the District.
Outstanding Prioritized Projects
•
Cat Hollow: Replace Sidewalks
•
Community Center Park: Amphitheater /Stage / Portable Stage; Shade over playscape/expand; Skateboard Park; More Sports Fields; Tennis Courts; Boulder/Rock Climb;
•
Creekside Park: Drainage Improvement; Connect Parking Lots;
•
Disc Golf Course: Add Signage;
•
Greenbelt: Protect Trails from Washouts
•
Highland Horizon: Parking Expansion; Southern Cross Pond Trail; Playscape Additions;
•
Little Village: Pavilion; Add Trail to North Side of Park
•
Miscellaneous: Dual Volleyball Courts;
•
North Park: Restrooms, Parking, Adaptability Playground, Restrooms; Shade Over Playscape
•
Pepper Rock: Expand Trails and Walking Paths; Ad Climbing Berms; Add Butterfly / Seasonal garden; Improve Appearance of Restroom Building; Expand/Improve Pavilion; Improve Ball Fields; Improve Landscaped Areas
•
Racine Woods: Replace Swings and Surfacing; Add Permanent Trash Cans
•
Sendero Springs: Pool Building Expansion; Playscape in SS Section 7; Fitness Stations in Park
•
Shirley McDonald: Restrooms; Additional Parking
•
Standardization: Benches as Trail; Dog Stations; Trail Markers; New Disc Golf Baskets; Trash Cans; Water Station/Mister; Tables;
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
12
DISTRICT LEADERSHIP Asset Management Plan •
Zebra Mussel treatment at both intake locations: The Districts intake system at Lake Georgetown and Brazos River Authorities intake system at Lake Stillhouse
•
Zebra Mussel prevention intake screens at Lake Georgetown
•
Raw water intake power contingency: prepare an action plan and conduct an operational test to run the Raw Water intake on a 1000kW portable generator in the event of a PEC transformer failure
•
Testing and modeling of water interconnects
•
Liberty Walk Lift Station power failure contingency
•
Microfiltration Membrane module replacements
•
Additional inventories for water intake and treatment shelf spares
•
HVAC assessments at the water treatment facility and Raw Water intake
•
Safety assessments and improvements
•
Fire Hydrant replacements
•
Gravity Sewer Line and Manhole maintenance
•
Waterline and valve maintenance
•
EPA unfunded mandate: America's Water Infrastructure Act: Risk Assessments and Emergency Response Plans
•
Brushy Creek Regional Waster Water System expansion and treatment improvements
•
Brazos River Authority Lake Stillhouse intake pump additions (two)
•
Woods lift station improvements
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
13
DISTRICT LEADERSHIP External Short-Term Budget Factors Austin Metropolitan Area Growth Rate: For eight consecutive years, the US Census Bureau population estimates identify the Austin metropolitan area to be the fastest growing in the nation. Recorded as the 11th largest in the nation and soon to be associated with San Antonio as Dallas is to Fort Worth. North Austin economic development: A strong economy and sought-after quality of life lull Texans from other Texas cities, as well as other states. Strong business sectors include Business and Financial Services, Defense and Security, Information Technology and Telecommunications, and Manufacturing. Recent announcements of significant expansions into the commutable area include Google, Facebook, Apple's ($1B campus), Kalahari Resorts, BAE, Amazon, US Army's Future Command, and Tesla. "Texas Property Tax Reform and Transparency Act of 2019": Senate Bill 2 is a property tax revenue cap, requiring referendum if the combined tax rate results in taxes on the average residential homestead to increase by more than 3.5%. The property tax revenues can be averaged over three years. COVID-19: FY2020 experienced budget shortfalls in Parks and Recreation revenues and Utility collection revenues. An initial FY2020 COVID response provided Short term relief in Utility late fee assessments. A sustained pandemic response action to limit interaction among people to prevent the spread reduces or eliminates camps, classes, fitness training, events, rentals, and community center memberships revenues. The District is creative to create and modify events to adapt: The Brushy Creek Life in COVID-19 times.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
14
FUNDING SOURCES Revenues The District funds its maintenance and operational expenses and capital projects with a variety of revenue sources. These sources include property taxes, utility service fees (water and wastewater, solid waste and stormwater), recreational program fees, Investments, Service Charges, Late fees, and, before the District reached build-out, builder fees assessed on new construction.
FY2021 % Change FY2020 % Change FY2019 % Change FY2018 % Change FY2017 % Change
Property Tax Revenues $ 10,846,811 0.78% $ 10,762,426 3.51% $ 10,397,430 6.72% $ 9,742,675 6.22% $ 9,172,506 9.47%
Brushy Creek Utility, Compliance, & Solid Waste Revenues $ 6,585,408 0.29% $ 6,566,557 -1.10% $ 6,639,877 0.44% $ 6,611,111 2.24% $ 6,466,556 1.86%
Brushy Creek Municipal Utility District
Sources of Funding
Recreation and Program Fees $ 1,310,613 -30.87% $ 1,895,991 5.69% $ 1,793,992 21.57% $ 1,475,646 7.59% $ 1,371,609 6.19%
Investments, Service Charges, and Late Fees $ 393,800 -18.13% $ 481,000 88.70% $ 254,900 44.37% $ 176,558 -40.52% $ 296,857 -20.29%
Building Fees $ $ $ $ $
4,749 -80.31% 24,121 -79.22% 116,080 -54.42% 254,660 -31.16%
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
15
FUNDING SOURCES Taxable Assessed Values The overall growth of Williamson County and the appeal of Brushy Creek MUD has resulted in increased assessed valuations. This growth has enabled the District to keep the District tax rate relatively steady while funding increased costs related to the provision of services and the maintenance of parks and facilities. This fiscal year, the District is able to maintain the total tax rate at $0.46 per $100 of valuation. The District is able to keep the tax rate at 2018 levels due to the District's valuations increasing, a significant balance in the debt service reserves, and the debt service obligations decreasing over time. The continued operations and maintenance rate provide the revenue needed to keep pace with the growing need for maintenance of the District's assets and the increased costs of providing services to a growing population. The Defined Area tax rate decreased again this year by $.005 to $0.16 per $100 valuation in the FY2021 budget. The Defined Area tax rate is used exclusively for debt service for defined area bonds.
Certified Appraisal Values x 1000 2009 $ 1,125,280 2010 $ 1,118,615 2011 $ 1,170,174 2012 $ 1,189,523 2013 $ 1,271,855 2014 $ 1,454,418 2015 $ 1,609,331 2016 $ 1,785,289 2017 $ 1,947,448 2018 $ 2,089,151 2019 $ 2,170,989 2020 $ 2,206,314
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
16
FUNDING SOURCES Property Tax Rates Property tax rates, levied by the District, are based on certified 2020 property valuations appraised by the Williamson County Appraisal Districts (WCAD). The District approves three tax rates (1) The Brushy Creek MUD Maintenance and Operations tax rate, (2) The Brushy Creek MUD Debt Service Tax rate, and (3) the Defined Area Debt Service Tax rate. Tax rates are based on each $100 of WCAD certified assessed values. The Brushy Creek MUD tax rates includes all property within the District boundaries. The Brushy Creek MUD Defined Area includes only the properties within the Defined Area. Tax Year
Tax Rate per $100 Appraised Value (AV) 2020 2019 2018 2017
2016
2015
District Total $ 0.4600 Maintenance and Operations $ 0.3200 Debt Service (I&S) $ 0.1400
$ 0.4600 $ 0.3200 $ 0.1400
$ 0.4600 $ 0.3000 $ 0.1400
$ 0.4600 $ 0.3000 $ 0.1600
$ 0.4650 $ 0.2950 $ 0.1700
$ 0.4700 $ 0.2800 $ 0.1900
Defined Area Total $ 0.1600 Maintenance and Operations $ Debt Service (I&S) $ 0.1600
$ 0.1650 $ $ 0.1650
$ 0.1750 $ $ 0.1750
$ 0.1900 $ $ 0.1900
$ 0.2250 $ $ 0.2250
$ 0.2700 $ $ 0.2700
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
17
FUNDING SOURCES Property Tax Rate History
Debt Tax Year Service 2009 0.310 2010 0.310 2011 0.300 2012 0.250 2013 0.250 2014 0.230 2015 0.190 2016 0.170 2017 0.160 2018 0.140 2019 0.140 2020 0.140
M&O 0.190 0.190 0.200 0.250 0.250 0.250 0.280 0.295 0.300 0.320 0.320 0.320
Brushy Creek Municipal Utility District
Total 0.500 0.500 0.500 0.500 0.500 0.480 0.470 0.465 0.460 0.460 0.460 0.460
Defined Area 0.360 0.360 0.360 0.360 0.360 0.350 0.270 0.225 0.190 0.175 0.165 0.160
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
18
FUNDING SOURCES Utility Rates The following FY2020 rates will remain unchanged for purposes of the FY2021 Budget. A District homeowner using 10,000 gallons of water per month will pay $69.20 in the Winter and $76.00 in the Summer.
Water Rates In-District Base Rate $ Winter Rate $ Summer Rate $ State Assessment
15.00 2.25 per 1,000 gallons 2.95 per 1,000 gallons 0.5%
Water Rates Out-of-District Base Rate $ Winter Rate $ Summer Rate $ State Assessment
37.42 2.25 per 1,000 gallons 2.95 per 1,000 gallons 0.5%
Wastewater Rates In-District Base Rate $ Volume Charge $
6.00 2.70 per 1,000 gallons
Wastewater Rates Out-of-District Base Rate $ Volume Charge $
12.00 10.80 per 1,000 gallons
Regulatory Compliance Fee Disconnect Fee for Non-Payment Late Fee
1.50 30.00 10.0% of total past due
Brushy Creek Municipal Utility District
$ $
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
19
DISTRICT FUNDS Fund Descriptions and Structure The District operates with two major governmental funds, the General Fund and the Debt Service Fund, and a Capital Projects Fund. For all funds, the budgeting basis of accounting and audited financial statements are the same using the modified accrual basis. Capital projects appear in the General Fund. The funds consist of cost centers, such as Administrative, Parks Maintenance, Water, and Aquatics Programs. Cost centers consist of common categories, such as Payroll, Contractual, Supplies, and Capital. Categories consist of common line items, such as Salary, Computer supplies, Major equipment, and Subscriptions.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
20
DISTRICT FUNDS Financial Policies: Fund Balance In accordance with the District Fund Balance Policy, fund balances are displayed in the following classifications: • •
•
• •
Nonspendable fund balance: Amounts not in a spendable form or are required to be maintained intact; Restricted fund balance: Amounts that can be spent only for the specific purposes stipulated by external resource providers; o Customer deposits in the General Fund; o Debt Service Fund for District bonds; o Debt Service Fund for Defined Area bonds; o Water Impact Fee Revenues; o Wastewater Impact Fee Revenues; o Park Capital Fees o Restricted fund balances will change regularly as specified revenues are recognized, and as such, the Board does not designate a specific fund balance. Committed fund balance: Amounts that can be used only for the specific purposes determined by formal action of the Board of Directors of the District. o Operating Reserve Fund balance equivalent to six months budgeted General Fund operating revenues, based on preceding annual financial statements; o Revenue Protection Reserve Fund balance equivalent of three months of budgeted revenues in the District's Water, Wastewater, and Administration cost centers based on preceding annual financial statements; ▪ Revenue Protection Reserve Fund balance is not used to fund solid waste, maintenance costs, or recreational programs; ▪ As necessary, the Revenue Protection Reserve Fund balances will fund deficits to the Operating Reserve Fund balance. o Repair, Replacement and Capital Reserve Fund balance funds anticipated repairs, replacements, improvements, and capital purchases related to the District's water, wastewater, parks, and recreation facilities Assigned fund balance: Amounts intended to be used by the District for specific purposes. In the Debt fund, assigned fund balance represents the amount that is not restricted or committed; Unassigned fund balance: all residual classification amounts of the General Fund not contained in other classifications. Deficits to the Operating Reserve Fund are funded by the unassigned fund balance;
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
21
DISTRICT FUNDS Financial Policies: Fund Expenditures Management of distributions, expenditures, investments, and capitalization are governed by the District's policies. Purchases are capitalized when the initial cost is over $5,000, and the useful life is more than two years. The District's Board of Directors approves all capital expenditures. Set forth below are key policies adopted by the Board of Directors governing District expenditures, investments and other financial matters. •
Order Authorizing General Manager to Approve Certain Expenditures and Contracts, Providing For The Disbursement of District Funds And Containing Other Matters Related To the Safekeeping Of District Funds (19-0320-01)
•
Order Adopting District Fees, Rates, Penalties, and Charges (18-0125-01)
•
Resolution Amending Brushy Creek Municipal Utility District Policies for Funding District Cost Centers (20-0910-03)
•
A Resolution Approving Capitalization Policy (05-0310-02)
•
Resolution Approving Fund Balance Policy; Establishing Fund Balance Commitments, and Containing Other Matters Related Thereto (20-0910-02)
•
Order Adopting Park and Recreation Fees and Rates (19-0124-02)
•
Resolution Adopting District Personnel Policy
•
Resolution Approving Amended Procedures Concerning Financial Reporting (19-041101)
•
Order Declaring Property Surplus and Authorize Sale (19-0627-01)
•
Order Adopting Amended and Restated Investment Policy and Investment Strategies (20-0827-01)
•
Resolution Expressing Official Intent to Reimburse Certain Expenditures for Improvements to Long Term Water Project (19-0822-01)
•
Resolution of Brushy Creek Municipal Utility District Approving Revisions to Parks and Open Spaces Master Plan Project List (17-0928-03)
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
22
DISTRICT FUNDS Budget and Funding Plan The budgeting basis of accounting and audited financial statements are the same using the modified accrual basis. This District's funding plan allocates revenues to expense categories in the following ways: •
•
• •
•
Property Tax Revenue o The Board has adopted a Maintenance and Operations (M&O) tax rate for tax year 2020 in an amount equal to $0.3200 per $100 of valuation. M&O tax revenues are allocated to the General Fund cost centers; o The Board has adopted an Interest and Sinking (I&S) tax rate for tax year 2020 in an amount equal to $0.16 per $100 of valuation. I&S tax revenues are allocated to the Debt Fund; o The Defined Area I&S Tax rate is exclusively levied for debt service for Defined Area bond debts within the Debt Fund. Utility Service Fee Revenue o Funds the cost centers: Water, Wastewater, BC Water Facility, Regulatory Compliance, and Solid Waste Operations; o A Board-approved amount per utility connection funds the cost centers: Parks Program, Aquatics Programs, and Community Center Programs. Recreation Program Fees o Funds the cost centers: Parks Program, Aquatics Programs, and Community Center Programs Investments, Service Charges, and Late Fees o Funds the cost centers: Administration and Parks Maintenance o Funds debt service payments o Funds wastewater impact fee reserves Builder Fees o Fund park fees fund balance o Fund annual debt service for long-term water projects o Fund regional wastewater capital charges
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
23
GENERAL FUND General Fund: Overview The General Fund represents the cost centers associated with the day-to-day management of the District. Operationally, the District is organized into four departments, and the departments are accountable for managing the cost center budgets. The four departments are Public Works, Parks and Recreation, Financial Services, and Shared Services. General Fund: Public Works Public works include both Utilities and Property Maintenance. Utilities are responsible for the treatment and delivery of water, management of wastewater and stormwater, regulatory compliance. Property Maintenance is responsible for the safety and availability of District parks, pools, and facilities; and, preservation of District features. Goals and objectives: The goal for the Utility Department is the efficient delivery of Superior rated water, the environmentally sound treatment and disposal of wastewater, and the highlevel maintenance of stormwater assets. The Goal of Property Management is the create the space and opportunity for the Brushy Creek Life. Short-term factors which influence decisions include • • • •
Ongoing compliance with new TCEQ regulations, including phosphorous removal from wastewater; Age of the system and individual components (mechanical, electrical, software, support, and documentation); Zebra mussel infestation of Lake Georgetown and Lake Stillhouse; Availability of certified, experienced recruits.
Cost Centers: Aquatics Maintenance, Park Maintenance, Community Center Maintenance, Wastewater, Water Distribution, Water Treatment Facility, and Regulatory Compliance.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
24
GENERAL FUND General Fund: Parks and Recreation Parks and Recreation include programs, revenues, and costs associated with the Community Center and programming at the parks and pools. In February 2009, the Board approved the funding plan for each of these cost centers. This plan was revised in 2018, which eliminated the transfer of 10% of revenues from other cost centers to administration. The Board also approved increasing the transfer of water revenue per connection from $120 to $240. This money is distributed among the Recreation cost centers (Park Programs, Aquatics, and Community Center). The Parks and Recreation Department operates in a deficit. The deficit is funded by revenue from the Services departments at a level equivalent to $436 per water connections: funded at $240/LUE in FY2020, and 10% of utility revenues in FY2017. An additional transfer of $196 from utility revenues is required for FY2021 due to the number of projects. Goals and objectives: The Parks and Recreation 2020 goals include the construction of the Sendero Springs Pool building expansion, Community Garden renovation, Community Center parking lot turnaround, growth of the youth and adult soccer leagues, updating recreation software versions, the continuation of Drive-in Movie series, and implementations to conclude the ten year Parks Master Plan (2012 – 2022). Short-term factors which influence decisions: • •
COVID-19 Impact on operations, revenues, expenses o Assume impact for the first six months of FY21 Trends in recreation programming (fitness classes, sports, day camps)
Cost Centers: Parks Programs, Aquatics Programs, and Community Center Programs.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
25
GENERAL FUND General Fund: Shared Services Goals and objectives: The continual transformation of District operations, enabling a culture of service excellence and the space to deliver the Brushy Creek Life. Short-term factors which influence decisions: • • • •
The ongoing revitalization of information technology infrastructure and software systems (CUSI, RecTrac); Safety program initiatives; Higher conversion fees to online payments increase merchant fees; Metropolitan area growth warrants additional security guard resources;
Cost Centers: Administrative and Customer Service. General Fund: Financial Services Goals and objectives: The timely, accurate, and controlled processing and delivery of financial information and investment opportunities to enable prudent and compliant operations. Short-term factors which influence decisions: •
Upgrading software systems (Abila);
Cost Centers: Administrative cost center
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
26
GENERAL FUND General Fund: Cost Centers Expenses The General Fund expenses, including Capital Projects, for FY2021 are budgeted at $14.45 million, a $2.3 million or 13.8% decrease from FY2020 budgeted expenses. Revenue is budgeted at $15.15 million, a $0.5 million or 3.3% decrease from FY2020 budget. It is not unusual for expenses to fluctuate year over year, especially project spending. Operating expenses fluctuate less. The chart below compares the historical operating and capital expenditures.
The District has funded studies in the previous fiscal years to assist the Board and staff in preparing for the District's future. These studies included audits and master plans for the water and wastewater systems in addition to a Parks and Open Spaces master plan. Internally, staff has also developed a long-term financial plan, property and capital inventories, capital replacement plans, and the impact of the District, reaching 100% build-out. The driving factors in the decrease in operating expenses for the fiscal year 2021 are special projects and capital projects. The District has budgeted nearly $1.57 million for new projects, a
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
27
$2.3 million decrease over FY2020. The District is partially funding these projects with $6.6 million from committed reserves (Repair, Replacement & Capital Fund) that were established specifically for these type projects. The District also has $6.0 million in unassigned reserves for future project use and $11.7M in operating and revenue reserve for unanticipated expenditures.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
28
GENERAL FUND General Fund: Public Works, BC Water Facility (BCWF) Cost Center This cost center reflects the costs of operating and maintaining the District's water intake structure and the plant that produces water. Significant items in the FY2021 Budget include • • • • •
IT Server failover testing New VT Scada Trihedral maintenance contract EPA risk & resiliency assessment (unfunded mandate) Inventory of shelf spares Raw water action plan and intake testing
The FY2021 Budget includes the following Capital items and projects: Rebuild HSP Cla-Valves (4)
• • • • • • •
Electrical switchgear maintenance (WTP) Replace recycle pump control panel and rebuild pump #2 Replace the original water softener system BRA adding pumps at Lake Stillhouse Hach SC200 controllers Painting/coating of exterior piping Install 6" trailer mounted portable pump for transfer at Liberty Walk Lift (and as needed District-wide)
General Fund: Public Works, Water Distribution Cost Center The Water Distribution cost center reflects revenue related to water sales and the expenses associated with distributing that water to customers. The FY2020 budget reflects revenue based on current rates and average consumptions. Significant items in the FY2021 Budget include • • •
Arcware transferred to a software Go Track to connectivity Licenses for GIS Arcware data
The FY2021 Budget includes the following Capital items and projects: • •
Vehicle replacement Upgrade meter reading software and equipment
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
29
GENERAL FUND General Fund: Public Works, Wastewater Cost Center The Wastewater cost center reflects the costs of maintaining the District's wastewater and stormwater infrastructure and the related revenue to support those costs. The primary expense is the contractual costs associated with participating in the regional wastewater treatment plant. Significant items in the FY2021 Budget include the following: • • •
Four sewer line repairs Availability of Sewer Jet machine Travel to and from District for Stipend for on-call operators
The FY2021 Budget includes the following Capital items and projects: • • • •
New Woods Lift Station Sewer Jet Machine Cat Hollow Lift Station rehabilitation Third Vortex Pump for Highland Horizon Lift Station
General Fund: Public Works, Regulatory Compliance Cost Center The Regulatory Compliance Cost Center tracks expenditures related to the mandated stormwater permit, inspections of stormwater inlets, and the District's drainage system. The costs are recovered through a fee charged to each District water customer at $1.50 per LUE. In FY2021, those fees are budgeted to be $121,000. Significant items in the FY2021 Budget include the following: • • •
Stormwater system mapping update Incorporating additional Texas Water Development Board Best Management Practices Pasada pond repair
The FY2021 Budget includes the following Capital items and projects: •
The funding of no capital expenditure projects
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
30
GENERAL FUND General Fund: Public Works, Parks Maintenance Cost Center Maintenance of the Parks, Grounds, and other Facilities is funded with Maintenance and Operations taxes as approved by the Board in February 2009. Park projects are separated into two categories 1) repair and replacement projects which are budgeted in Maintenance and 2) new capital projects which are budgeted in Recreation Programs. Significant items in the FY2021 Budget include the following: • • •
Playground Safety and Tree Conference Utilizing new maintenance yard to store haunted house Internal repair of irrigation systems
The FY2021 Budget includes the following Capital items and projects: • • • • •
Cat Hollow Park - Parking Lot resurface Community Park – Trail repair Community Park – Playground design Community Park - Restrooms update Pepper Rock - Restrooms update
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
31
GENERAL FUND General Fund: Public Works, Aquatics Maintenance Cost Center Maintenance of the Pools is funded with Maintenance and Operations taxes as approved by the Board in February 2018 (18-0308-01). Aquatic projects are separated into two categories 1) repair and replacement projects which are budgeted in Maintenance and 2) new capital projects which are budgeted in Recreation Programs Significant items in the FY2021 Budget include the following: • • • • • •
Increased allocation from Parks Maintenance Sendero Springs shade sail Pool vacuum Cat Hollow Pool bathroom flooring and fixtures Sendero Springs filter media change Creekside pool filter replacement
The FY2021 Budget includes the following Capital items and projects: • • •
Creekside pool deck replacement Highland Horizon poll replaster Sendero Springs thermal cover
General Fund: Public Works, Community Center Facilities Maintenance Cost Center Facility maintenance includes the costs to repair, clean, and maintain the Community Center. Costs associated with repairing, cleaning, and maintaining other facilities such as the Water Facility, Utilities, and Parks administration building, or the parks and pools, are charged to those cost centers although they may be coordinated by the Facility Maintenance Coordinator. Significant items in the FY2021 Budget include the following: •
Increased allocation from Public Works & Parks Maintenance
The FY2021 Budget includes the following Capital items and projects: • • • •
Community Center Garden improvements HVAC system (East side) replacement Red lobby concierge desk Red Gym air handlers
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
32
GENERAL FUND General Fund: Parks and Recreation, Community Center Cost Center The Community Center cost center includes revenue and expenses related to Recreation Management, Programming, Fitness, Memberships, Concierge, and Child Play. Significant items in the FY2021 Budget include the following: • • •
Purchase of fitness equipment for new classes New backpack disinfectant sprayer Fuel/Oil cost for Programs vehicle
The FY2021 Budget includes the following Capital items and projects: •
Program staff vehicle – Ford Escape (approved in FY2020)
Parks and Recreation: Parks Program Cost Center This cost center includes revenue and expenses related to any Programming and Fitness activities that occur in the parks. Additionally, any new capital investments to the Parks are budgeted in this cost center. Significant items in the FY2021 Budget include the following: •
Decrease in revenue and expenses due to COVID-19
The FY2021 Budget includes the following Capital items and projects: • • • • • •
Landscaping @ Hairy Man Bridge Community Park turn around Shirley McDonald Park - Trail lighting Community Park Amphitheater – Design New Highland Horizon Trail Pepper Rock Park – Expansion Phase II
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
33
GENERAL FUND General Fund: Parks and Recreation, Aquatics Program Cost Center This cost center includes the cost of operating the pools and related programming, including lessons, meets, rentals, and open swimming. The Sendero Springs and Highland Horizon pools are open year-round. Significant items in the FY2021 Budget include the following: • • •
New pool furniture to update all pool furniture over two fiscal years Replacement of parkas used by lifeguards in the Winter Acceptance of credit cards at pools
The FY2021 Budget includes the following Capital items and projects: •
Sendero Springs Pool Building Expansion
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
34
GENERAL FUND General Fund: Shared Services and Financial Services, Admin Cost Center The Administration Cost Center budget includes the costs associated with the General Manager's office, Accounting, Information Technology, and Human Resources. District M&O Property tax revenue and interest revenue from General Fund reserve accounts are reflected here. Significant items in the FY2021 Budget include the following: • • • • •
Information technology upgrades and risk abatement initiatives; Absorbing t-shirt transfer from Executive cost center District-wide safety training and campaign initiative IT Server failover testing Retirement rate increases from 6.38% to 6.64%
The FY2021 Budget includes the following Capital items and projects: •
Security vehicle
General Fund: Shared Services, Customer Service Cost Center Customer Service supports the Recreation and Utility billing customers and responds to all inquiries for information or services within the District. Significant items in the FY2021 Budget include the following: • • •
CUSI software upgrade, training, and implementation; Mobile customer service station; Paperless billing initiative.
The FY2021 Budget includes the following Capital items and projects: •
The funding of no capital expenditure projects
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
35
GENERAL FUND General Fund: Shared Services, Solid Waste Services Cost Center The District contracts with a third-party vendor to provide solid waste services, including recycling to the residential accounts in the District. Significant items in the FY2021 Budget include: •
A new contract with TDS and the new services successful implementation.
The FY2021 Budget includes the following Capital items and projects: •
The funding of no capital expenditure projects
General Fund: Board of Directors, Executive Cost Center The Executive Cost Center budget includes items related to the Board of Directors. Significant items in the FY2021 Budget include: •
T-shirt transfer to administration cost center
The FY2021 Budget includes the following Capital items and projects: •
The funding of no capital expenditure projects
General Fund: Builders Park Fee (BPF) Builder's Park Fee revenue funds capital improvement purchases for the District's parks. The FY2021 budget is based on the sale of no new LUEs.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
36
DEBT SERVICE FUND Fund Sources The taxable assessed value for the District for 2020 is $2,206,313,816 as of original certification of the 2020 tax rolls by the Williamson Central Appraisal District. Based on this value and the amount of the District’s debt service fund balance, the Board has adopted a $0.14 District debt service (IS) tax rate for tax year 2020. The Defined Area assessed value for 2020 is $521,736,141. Based on this value for the Defined Area, the amount of the Defined Area debt service fund balance, and the use of approximately $880,000 of excess reserves in the Defined Area debt service fund for a proposed defeasance transaction to retire $830,000 principal amount of the Defined Area’s Series 2013 bonds, the Board has adopted a $0.160 Defined Area tax rate for tax year 2020. Assuming a 98% tax collection rate, these rates will generate $3,027,063 in debt service tax revenue (plus $818,082 for the Defined Area). The District’s assessed value for 2020 increased 1.627% from $2.170 billion in the previous year. Additional revenues include interest income ($35,750) budgeted at an estimated 1.0% earnings on the fund balances. Debt Service revenues are not enough to support the annual debt payment and transfers of $268,970 from the District debt service reserves and $54,112 from the Defined Area Debt Service fund balance are budgeted.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
37
DEBT SERVICE FUND Fund Balance The Debt Service Fund balance is projected to be $3,575,000 as of 10-1-2020. The projected debt service fund balance restricted to Defined Area debt shown below assumes the use, on or before 10-1-20, of approximately $880,000 of excess reserves in the Defined Area debt service fund for a proposed defeasance transaction to retire $830,000 principal amount of the Defined Area's Series 2013 bonds. All Debt Service funds are restricted to making debt payments.
Projected Fund Balance
$3,575,000
Restricted to District Debt
$2,725,000
Restricted to Defined Area Debt $ 850,000 Unassigned
Brushy Creek Municipal Utility District
$
0
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
38
DEBT SERVICE FUND Debt Service Obligations Fiscal Year 2021 The required bond debt service payments for the fiscal year 2020–2021 are set forth in the following chart. The bond interest payments are made in November and May and the principal payment is made in May of each year. The amount of interest due on Non-Revenue Defined Area Bonds, as shown below, reflects a reduction in the amount of interest due during fiscal 2021 as a result of the proposed defeasance transaction to retire $830,000 principal amount of the Defined Area's Series 2013 bonds.
Revenue Bonds Non-Revenue Defined Area Bonds Non-Revenue District Bonds Total
Principal Interest Total $440,000 $130,317 $570,317 $525,000 $347,194 $872,194 $2,555,000 $741,032 $3,296,032 $3,520,000 $1,218,543 $4,738,543
Other Debt Service Expenditures The only other expenditures charged to the debt service fund are (1) the costs associated with the fiscal agents, and (2) the costs charged by the Williamson County Appraisal District to process the appraisals, issue tax bills, and collect and transmit tax receipts on behalf of the District.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
39
DEBT SERVICE FUND Debt Service Revenue Sources Property Taxes - District The primary source of revenue for the District's debt service expenditures is Interest and Sinking (I&S) tax revenue. I&S tax revenue is derived from property taxes collected from all owners of taxable property in the District on the District's behalf by the Williamson County Appraisal District. The I&S tax rate for the District was $0.14 per $100 of Assessed Value (AV) in FY2020. The FY2021 Budget reflects an I&S tax rate of $0.14 per $100 of AV. Water Capital Recovery Fee Revenue The District charges a Water Capital Recovery Fee (CRF) as part of the Builder's fee to connect to the District water distribution system. The Water CRF revenue historically is transferred to the Debt Service fund to contribute to the cost of the debt associated with the Long-Term Water Project. There is approximately $868,865.00 in this fund balance. Defined Area The primary source of revenue for the Defined Area's debt service is Interest and Sinking (I&S) tax revenue, specifically from the Defined Area. Tax revenue is derived from property taxes collected from Defined Area residents on the District's behalf by the Williamson County Appraisal District. In FY2020, the I&S tax rate for the Defined Area was $0.165 per $100 of AV. The FY2021 Budget decreases the I&S tax rate for the Defined Area to $0.160 per $100 of AV. This $0.160 I&S rate levied for tax year 2020 assumes the use of approximately $880,000 of excess reserves in the Defined Area debt service fund for a proposed defeasance transaction to retire $830,000 principal amount of the Defined Area's Series 2013 bonds. Fund Balance The District typically transfers funds from the Debt Service retained earnings for current year obligations. The Debt Service fund balance is projected to be $2.725 million at the end of FY2020 plus an additional $0.850 million for the Defined Area, assuming, on or before 10-120, the use of approximately $880,000 of excess reserves in the Defined Area debt service fund for a proposed defeasance transaction to retire $830,000 principal amount of the Defined Area's Series 2013 bonds. In FY2021, the debt service fund balance will contribute $255,250 to annual debt cost. The Defined Area fund balance will contribute $54,112 to the FY2021 payments. Interest from the debt service fund balance also contributes to the annual debt payments.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
40
DEBT SERVICE FUND Overview of Outstanding Debt At the beginning of the 2021 fiscal year, the Brushy Creek Municipal Utility District bonded indebtedness will be $38,530,000. This includes the District bonds, the Defined Area bonds, and a revenue bond, as shown below. This amount of bonded indebtedness assumes, on or before 10-1-20, the use of approximately $880,000 of excess reserves in the Defined Area debt service fund for the proposed defeasance transaction to retire $830,000 principal amount of the Defined Area's Series 2013 bonds. The residents of the District approved the issuance of up to $74,100,000 in bond principal payable in whole or part from taxes. To date, all $74,100,000 in Bond principal has been issued. The outstanding principal on the issued bonds will be $23,485,000 at the beginning of FY2021. The residents of the Defined Area of the District approved the issuance of up to $24,500,000 in bond principal payable all or in part from taxes. The purpose of the debt is for purchasing, constructing, operating, and maintaining water, wastewater, and drainage system within the Sendero Springs and Cornerstone Defined Area. As of the beginning of FY2021, there have been five new money Defined Area bond issues with original principal amounts totaling $13,785,000 and two refundings with original principal amounts totaling $5,420,000.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
41
DEBT SERVICE FUND Overview of Outstanding Debt (continued)
Brushy Creek Municipal Utility District Bond Debt - Outstanding At the start of Fiscal Year 2021 Name of Issue
Original Principal
Amount Retired
Amount Outstanding
Series 2012 (Refunding)
9,260,000
8,600,000
660,000
Series 2013 (Refunding)
6,125,000
145,000
5,980,000
Series 2019 (Refunding)
6,605,000
0
6,605,000
Series 2020 (Refunding)
8,140,000
0
8,140,000
Series 2020 (New Money)
2,100,000
0
2,100,000
32,230,000
8,745,000
23,485,000
TOTAL
Note: Bond issues that no longer have principal outstanding are not listed above. Also, the proposed Series 2020A refunding transaction is not considered.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
42
DEBT SERVICE FUND Overview of Outstanding Debt (continued)
Brushy Creek Municipal Utility District - Defined Area Bond Debt - Outstanding At the start of Fiscal Year 2021 Name of Issue
Original Principal
Amount Retired
Amount Outstanding
Series 2011 (New Money)
2,370,000
2,285,000
85,000
Series 2013 (New Money)
3,500,000
1,455,000
2,045,000
Series 2015 (New Money)
3,530,000
480,000
3,050,000
Series 2015 (Refunding)
3,625,000
510,000
3,115,000
Series 2020 (Refunding)
1,795,000
0
1,795,000
14,820,000
4,730,000
10,090,000
TOTAL
Note: Bond issues that no longer have principal outstanding are not listed above. In addition, the amount retired under Series 2013 of $1,455,000 assumes the use of approximately $880,000 of excess reserves in the Defined Area debt service fund for the proposed defeasance transaction to retire $830,000 principal amount of such series.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
43
DEBT SERVICE FUND Overview of Outstanding Debt (continued) In late January 2016, the District issued a $6.94 million revenue note for the construction of the Community Center expansion. This is a fifteen-year note. Utility revenues in the General Fund cover the annual payments on this debt.
Brushy Creek Municipal Utility District Revenue Bond Debt - Outstanding At the start of Fiscal Year 2021
Name of Issue
Original Principal
Amount Retired
Amount Outstanding
Series 2016 CC Expansion
6,940,000
1,985,000
4,955,000
TOTAL
6,940,000
1,985,000
4,955,000
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
44
CONSOLIDATED FINANCIAL STATEMENTS Increasing Transparency Brushy Creek Municipal Utility District will engage to provide clear and meaningful financial information not only by posting financial documents but also through summaries, visualizations, downloadable data, and other relevant information in such a manner to pursue the Texas Comptroller of Public Accounts' Transparency Star program for Traditional Finances.
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek Municipal Utility District
3,869,900 (2,303,214)
303,076
303,076 313,241 (10,165)
Contingency
Pr Yr Budget Variance Inc/(Dec)
2,567,815
Brushy Creek MUD - Fiscal Year 2021 Budget
(1,081,207)
(1,211,778)
Pr Yr Budget
Variance Inc/(Dec)
1,789,855
708,649
1,356,038
Excess / (Deficiency)
313,241 (10,165)
16,443,964 (2,301,868)
14,142,096
3,869,900 (2,303,214)
1,566,686
1,346
12,574,064
12,575,410
4,168,127 1,190,906 20,174 1,636,540 1,638,444 1,151,000 850,000 460,600 500,813 958,805
15,675,998 (522,177)
15,153,821
6,953,000 6,573,408 1,177,413 175,000 275,000
General Fund
20,609,261 (3,142,554)
Pr Yr Budget Variance Inc/(Dec)
17,466,707
1,566,686
Capital Projects
Pr Yr Budget Variance Inc/(Dec)
Total Expenditures
(839,340)
Variance Inc/(Dec)
16,739,361
15,900,021
Subtotal Expenditures
Pr Yr Budget
4,168,127 1,190,906 20,174 1,704,540 1,638,444 1,151,000 850,000 460,600 500,813 4,215,416
19,710,724 (584,903)
19,125,821
10,836,000 6,577,408 1,177,413 260,000 275,000
Payroll Benefits Travel Contractual Expenses Supplies Solid Waste Svc WW Capacity Utilities Debt service (P&I) All Other Expenditures
Pr Yr Budget Variance Inc/(Dec)
Total Revenue
Property Tax Revenue Utilities Revenue Recreational Programs Investments Other
Total Budget
Brushy Creek MUD - FY2021 Budget Comparison Summary
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
797,859
(174,470)
623,389
-
-
4,165,297 (840,686)
3,324,611
-
-
(840,686)
4,165,297
3,324,611
68,000 3,256,611
3,990,827 (42,827)
(19,899)
43,899
24,000
-
-
-
-
-
-
-
-
-
-
43,899 (19,899)
24,000
20,000 -
65,000 -
3,948,000
4,000
Capital Recovery
3,883,000 -
Debt Service
-
-
-
-
(35,545)
(673,186)
(708,731)
313,241 (10,165)
303,076
359,945 45,710
405,655
-
-
45,710
359,945
405,655
36,000 4,300 1,400 329,250 16,605 18,100
Exec
2,681,459
(3,735,731)
(1,054,272)
10,341,288 (2,666,608)
7,674,680
3,508,900 (2,446,420)
1,062,480
(220,188)
6,832,388
6,612,200
1,198,140 402,079 6,000 991,100 1,113,700 1,151,000 850,000 378,500 521,681
6,605,557 14,851
6,620,408
6,573,408 47,000
Public Works
(632,658)
(1,850,416)
(2,483,075)
3,615,407 45,080
3,660,488
345,000 124,206
469,206
(79,126)
3,270,407
3,191,282
1,644,935 379,358 7,774 60,940 402,940 75,600 500,813 118,922
1,764,991 (587,578)
1,177,413
1,177,413 -
Parks & Recreation
(222,550)
5,177,276
4,954,726
2,127,324 273,950
2,401,274
16,000 19,000
35,000
254,950
2,111,324
2,366,274
1,289,053 405,169 5,000 255,250 105,200 6,500 300,102
7,304,600 51,400
7,356,000
6,953,000 175,000 228,000
Shared & Financial Services
General Fund - Business Area
BPF
(850)
850
-
-
-
-
-
-
-
-
-
850 (850)
-
-
-
Brushy Creek Municipal Utility District
Committed Fund
Repair, Replacement & Capital Fund
Restricted Fund
Park Fees
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek MUD - Fiscal Year 2021 Budget
Growth
Grand Total Reserves
Restricted Fund Subtotal Restricted
Restricted Fund
Defined Area Debt
Restricted Funds: Utility Deposits
Restricted Fund
Growth
Unassigned Fund Total Committed & Unassigned
Bond Reserve Commitment
M&O Contingency
Unassigned Fund Subtotal Committed & Unassigned
Committed Fund
Revenue Reserve
Undesignated
Committed Fund
Operating Reserve
FY2021 - Projected Fund Balance
4,361,697
2,519,312
6,919,757
303,076 $
507,381
3,860,131 $
677,770 $
882,390 $
1,724,971 $
575,000 $
3,922,478 $
3,846,932 $
659,035 $
860,388 $
1,752,509 $
575,000 $
4,562,375 $
$
504,344 $
3,935,678 $
4,568,407 $
$ 28,510,325 $ 28,005,981 $ 24,070,304 $
677,770 $ 3,860,131 $
$
882,390 $
1,724,971 $
575,000 $
504,344 $
$
$
$
$
$
$ 24,650,194 $ 24,145,850 $ 20,223,372 $
$
2,505,224
19,501,896
3,840,899
671,591
821,750
1,772,558
575,000
1,551,625
15,660,997
15,660,997
5,478,709 $
2,874,312 $
6,919,757 $
FY2018 Actual
$ 24,347,118 $ 23,638,469 $ 20,223,372 $
4,442,263 $
8,141,900 $
3,385,770 $
7,668,536 $
FY2019 Actual
1,860,231
6,056,788 $
6,590,847 $
3,309,545 $
8,389,938 $
FY2020 Budget
4,950,594 $
$
$
$
$
FY2021 Budget
1,581,453
4,257,336
2,277,728
5,992,855
2,887,300
668,594
410,985
1,807,721
$ 16,996,672
$
$
$
$
$ 14,109,372
$ 14,109,372
$
$
$
$
FY2017 Actual
46
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
5,693 $436.16
Water 3,285,000 421,765 2,863,235
$436.16
Parks 110,317 643,653 (533,336)
$22,063,138 $0.32 98.0% $34,000
Brushy Creek MUD - Fiscal Year 2021 Budget
Connections Per Connection Rate
UTILITIES Non-Tax Revenue Expenditures Net
RECREATION Non-Tax Revenue Expenditures Net
Assesed Value (per $100) Tax Rate Collection Rate Deliinquent Prop. Tax Inc.
Exec
ADMINISTRATION Non-Tax Revenue Expenditures Net 708,731 (708,731)
Parks 14,000 1,198,789 (1,184,789)
MAINTENANCE Non-Tax Revenue Expenditures Net
FY2021 - Cost Center Funding Summary
266,620 (266,620)
CS
802,393 (802,393)
Facilities
CC BPF 929,893 2,123,061 (1,193,168)
2,031,449 0
Transfer In - From Administration Net Excess / (Deficiency)
FY21 5,216,000 4,055,726 1,160,274
2,483,075 -
(2,483,075) (708,649) (2,031,449)
WW Compliance 1,785,000 121,000 1,490,873 240,617 294,127 (119,617)
47.6%
FY21 1,177,413 3,660,488 (2,483,075)
2,031,449 (2,031,449) -
6,953,000
(4,921,551)
FY21 1,793,408 4,271,647 (2,478,239)
FY 2021 14,000 2,457,311 (2,443,311)
Transfer out - From Water Revenue to Recreation Programs Transfer out - From Water Revenue to Reserves Subtotal Excess / (Deficiency)
BCWF 25,000 1,902,472 (1,877,472)
-
Solid Waste 1,390,408 1,161,643 228,765
Transfer In - from Utilities Water Revenue Net Excess / (Deficiency)
Aquatics 137,203 893,774 (756,571)
Net Excess / (Deficiency) Transfer out to Utilities Net Excess / (Deficiency)
Tax Revenue
Subtotal Maintenance & Admin
Admin 403,000 2,134,654 (1,731,654)
456,130 (456,130)
Aquatics
47
Brushy Creek Municipal Utility District
Subtotal
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek MUD - FY2021 Budget
381,765
1,391,873
Waste Water
Water
1,161,643
(79,126) -2%
3,191,282
Solid Waste
YoY Variance $ YoY Variance %
2,123,061
449,153
Park Programs
Community Center Programs
619,068
418,258
1,349,276
1,334,447
1,491 0%
3,270,407
2,383,577
347,991
538,839
70,299 5%
1,600,475
1,667,811 67,336 4%
198,016
1,216,331
186,128
265,393
1,123,789
278,630
219,735 10%
2,471,269
2,771,928 300,659 12%
277,038
1,834,286
359,945
FY2020 Budget
266,620
2,099,654
405,655
Aquatic Programs
YoY Variance $ YoY Variance %
Subtotal
Facilities Maintenance
Parks Maintenance
Aquatics Maintenance
YoY Variance $ YoY Variance %
Subtotal
Customer Service
Administration
Executive
FY2021 Budget
496,244
1,295,391
1,301,902
3,268,916
2,494,073
282,951
491,892
1,530,176
208,002
1,108,232
213,942
2,251,534
248,822
1,649,058
353,654
FY2019 Actual
(36,493)
42,597
(172,804)
(79,126)
(260,516)
101,162
80,228
67,336
67,377
(92,542)
92,502
300,659
(10,418)
265,367
45,710
FY2021 vs FY2020 Variance
Cost Center Expenditure Summary vs Prior Years Non-Capital Expenditures
48
Brushy Creek Municipal Utility District
Total Non-Capital Expenditures
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek MUD - FY2021 Budget
YoY Variance $ YoY Variance %
1,346 0%
12,575,410
757,236 6%
12,574,064
465,711 10%
5,231,912
(287,524) -5%
4,944,389
YoY Variance $ YoY Variance %
Subtotal
264,674
240,617
Reg / Compliance
1,865,258
1,768,492
BC Water Facility
11,816,828
4,766,202
134,414
1,538,251
1,346
(287,524)
(24,058)
(96,766)
49
Brushy Creek Municipal Utility District
Plus new requests Additional Reserve for New Woods Lift Station Event staff vehicle - Ford Escape
Subtotal Remaining Repair, Replacement and Capital Reserve Commitments
Less FY2020 Reserve Spending (Estimate) Cat Hollow Park - Restrooms and New Sign Community Park Trail Repair Community Park Playground Community Center Garden Improvements Gym Divider Curtain - Red Gym Sendero Springs Pool - Building Expansion Maintenance Yard Renovation Replace 3 Singer Pump valves at Intake (2005) - Installation only/ pumps purchased 2019 Replace Hach Lab Equipment New Woods Lift Station Total FY2020 Reserve spending
Total Repair, Replacement and Capital Reserve Commitments (FY2020)
465,000 23,000
6,125,847.00
(410,363) (12,800) (50,000) (110,000) (15,000) (24,900) (1,328,000) (990) (9,000) (80,000) (2,041,053)
8,166,900.00
Repair, Replacement and Capital Reserve Commitments Bridge
50
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek Municipal Utility District
135,223 (18,500) 116,723 75,000 (60,000) (15,000) 9,010 (9,010) -
Assign Utility Equipment Replacement Reserve to: - Upgrade meter reading software and equip (Neptune) Remaining Utility Equipment Replacement Reserve
Assign Lift Station Improvements Reserve to: - Cat Hollow Lift Station Rehab - Liberty Walk Lift Remaining Lift Station Improvements Reserve
Assign Singer Pump valve Installation to: - Rebuild Cla valves
Total Repair, Replacement and Capital Reserve Commitments (FY2021)
469,728 (150,000) (250,000) 69,728
Assign 2012 - 2022 Master Plan - Parks Projects Reserve to: - Pepper Rock Expansion - Phase II - New Highland Horizon Trail (Southern Cross Pond) Remaining 2012 - 2022 Master Plan - Parks Projects Reserve balance
6,590,847.00
Only shifting funds Net Impact is zero
51
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek MUD - Fiscal Year 2021 Budget
Parks and Recreation Manager Aquatics Supervisor Head Lifeguard Lifeguards / Shift Leads / Swim Lessons Head Swim Instructor
Property Maintenance Manager Facility Maintenance Specialist Gardner Property Maintenance Technician TOTAL MAINTENANCE
General Manager Executive Assistant Administrative Assistant Documentation Specialist IT Support Specialist Administrative Services and Purchasing Specialist District Project Manager Chief Financial Officer Accounting Manager Accounting Assistant Payroll/Accounting Specialist Utility Billing Specialist HR Manager HR Specialist Community Engagement Specialist Customer Service Representative Customer Service Supervisor Security Guard TOTAL ADMINISTRATION
POSITION
FY2021 Headcount by Position
1 1 6 60 1
1 1 1 5 8
1 1 4 1 2 21
1 1 1 1 1 1 1 1 1 1 1 1
FY20
1.00 1.00 4.73 10.58 0.50
1.00 1.00 1.00 5.00 8.00
1.00 1.00 1.00 0.88 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.00 1.00 1.00 4.00 1.00 2.00 20.88
FTE
1 1 3 60 1
1 1 1 5 8
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 4 1 3 23
FY21
1.00 1.00 2.13 11.97 0.75
1.00 1.00 1.00 5.00 8.00
1.00 1.00 1.00 0.88 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 4.00 1.00 1.00 20.88
FTE
52
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek MUD - Fiscal Year 2021 Budget
DISTRICT TOTAL
Public Works Manager Public Works Administrative Assistant Utilities Systems Manager Utilities Maintenance Senior Technician Utilities Maintenance Technician Regulatory Compliance Specialist Water Facility Supervisor Utility Systems Operater (WTP) TOTAL UTILITIES
Fitness Specialist Member Services Supervisor Weekend and Evening Community Center Supervisor Member Services Representative Community Center Manager Information & Rental Specialist Child Play Attendant Fitness Specialist Recreation Assistant Sports & Fitness Supervisor Youth/Adult League Specialist Program Assistant Programs Specialist Recreation Assistant After School Camp Specialist Community Events Specialist Instructor (Water, Fitness, Water Fitness, Sports & Fitness) TOTAL RECREATION
POSITION
168
1 1 1 5 1 1 3 13
93.35
0.00 1.00 1.00 1.00 5.00 1.00 1.00 3.00 13.00
9.15 1.00 1.00 2.55 1.72 4.63 1.00 1.50 5.96 1.00 1.00 0.30 0.00 1.35 51.47
9 1 1 4 3 9 1 2 12 1 1 1 10 126
0.5 1.00
FTE
1 1
FY20
188
1 1 1 1 5 1 1 3 14
1 1 1 14 1 1 5 1 12 1 2 23 1 1 1 1 10 143
FY21
98.32
1.00 1.00 1.00 1.00 5.00 1.00 1.00 3.00 14.00
0.50 1.00 1.00 12.03 1.00 1.00 1.97 1.00 5.51 1.00 1.53 5.96 1.00 1.00 0.75 1.00 1.35 55.45
FTE
53
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Property Tax Income Delinquent Property Tax Income Plan Review Income Inspection Fees Builders Fees Water Service WW Service Water Connection WW Connections New Connection Fees Solid Waste Services Raw Water Sales Wholesale Water Regulatory Compliance Fee Service Charges Donations Late Charges Interest Income Other Income Rental Income Promotional Materials Community Events Revenue Program Revenue Contract Programming Events Income Camp Income Memberships - Short Term New Memberships Memberships Season Passes Day Passes
4101 4102 4110 4112 4130 4201 4203 4211 4213 4220 4230 4240 4245 4301 4401 4402 4403 4405 4500 4501 4502 4504 4505 4510 4515 4518 4519 4520 4521 4522
6,674,984 788 7,650 21,350 19,953 3,069,590 1,803,495 4,620 1,260 170 1,388,800 104,251 119,013 122,581 33,434 200 62,780 564,348 708,598 260,293 4,099 15,218 271,549 78,531 283,421 42,832 26,030 538,232 71,439 78,232
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
Description
Object Code
General Fund Summary
6,867,264 34,336 2,400 4,000 3,059,798 1,785,516 1,376,209 104,660 112,000 121,644 28,000 65,000 350,000 41,262 227,687 5,480 111,847 25,732 170,890 27,725 15,402 331,189 37,605 47,030
FY2020 Forecast 6,867,264 34,336 2,400 4,000 850 3,059,798 1,785,516 330 1,376,209 104,660 112,000 121,644 28,000 65,000 175,000 43,000 302,883 10,575 237,110 96,719 294,515 41,850 22,940 409,275 79,482 68,727
FY2020 Original Budget 6,919,000 34,000 3,000 5,000 3,060,000 1,785,000 1,390,408 105,000 112,000 121,000 28,000 65,000 175,000 40,800 216,118 10,500 147,012 52,667 198,654 29,475 17,269 358,670 50,701 50,014
FY2021 Budget 51,736 (336) 600 1,000 (850) 202 (516) (330)
14,199 340 (644)
(2,200) (86,765) (75) (90,098) (44,052) (95,861) (12,375) (5,671) (50,605) (28,781) (18,713)
1% 0% -1%
-5% -29% -1% -38% -46% -33% -30% -25% -12% -36% -27%
Original Budget Variance $ Inc / (Dec)
1% -1% 25% 25% -100% 0% 0% -100%
Original Budget Variance % Inc / (Dec)
54
Brushy Creek Municipal Utility District
Fitness Revenue Senior Programs Child Programs / Child Play
4523 4524 4525
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
FICA / Medicare Health Vision Insurance Dental Life Disability Insurance Workers Compensation Unemployment Insurance Retirement Total Benefits
3,341,704 66,609 3,408,313 252,188 342,212 4,050 20,409 4,684 16,523 107,545 13,074 191,810 952,494
269,023 364,258 4,375 21,927 5,041 16,278 63,637 8,798 206,817 960,154
15,133,526
16,779,876 3,539,496 64,221 3,603,717
176,923 3,927
FY2020 Forecast
394,800 298 7,036
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
5020 5030 5031 5032 5034 5035 5040 5050 5070
EXPENSES 5010 Salary 5011 Merit Salary 5012 Overtime Total Payroll
TOTAL REVENUE
Description
Object Code
General Fund Summary
433,303 676,272 1,109,575
3,842,731 9,517 52,581 3,904,829
15,675,998
326,615 300 5,000
FY2020 Original Budget
319,670 431,468 5,438 26,996 6,224 21,225 122,545 26,672 230,667 1,190,906
4,086,028 9,650 72,449 4,168,127
15,153,821
176,733 2,800
FY2021 Budget
7%
-26% -36%
6% 1% 38% 7%
-3%
-46% -100% -44%
Original Budget Variance % Inc / (Dec)
(113,633) (244,804) 5,438 26,996 6,224 21,225 122,545 26,672 230,667 81,331
243,297 133 19,868 263,298
(522,177)
(149,882) (300) (2,200)
Original Budget Variance $ Inc / (Dec)
55
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Total Capital Projects
Total Capital Expenditures
Contractual-Legal Contractual/Auditing Contractual/ Trainers- Instructors Contractual/Network maint/dev. Contractual/Website Security Appraisal Fees Depository Contract Maintenance Contracts Plumbing Inspections Engineering Fees Contractual/Contract Labor Total Contractual
5901
5902
6010 6025 6030 6040 6045 6055 6060 6065 6070 6078 6079 6080
1,542 2,608 539 1,376 85 1,375 12,631 20,155 3,396,292 196,208 41,750 179,516 2,100 115,483 138,265 601,038 19,140 229,632 321,008 1,844,140
724,604 131,428 34,750 2,700 107,054 6,772 75,525 113,259 570,434 14,735 169,089 323,521 1,549,266
FY2020 Forecast
3,331 4,006 80 2,634 790 1,672 13,576 26,089
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
Airfare Lodging Lodging Tax Cab Fare / local transportation Parking Travel Meals Mileage Other Travel Expenses Total Travel
Description
5201 5202 5203 5204 5205 5206 5207
Object Code
General Fund Summary
110,000 41,200 5,000 75,000 2,000 108,000 1,000 85,000 602,876 5,200 146,000 458,900 1,640,176
-
3,869,900
4,035 142 100 210 2,515 11,720 18,722
FY2020 Original Budget
130,000 41,750 2,700 125,000 2,100 118,500 150,700 617,190 4,000 160,000 284,600 1,636,540
1,097,480
469,206
1,900 3,700 100 210 2,860 11,404 20,174
FY2021 Budget
8%
18% 1% -46% 67% 5% 10% -100% 77% 2% -23% 10% -38% 0%
20,000 550 (2,300) 50,000 100 10,500 (1,000) 65,700 14,314 (1,200) 14,000 (174,300) (3,636)
1,097,480
(3,400,694)
1,452
14% -3%
-88%
345 (316)
-8% -100%
Original Budget Variance $ Inc / (Dec) 1,900 (335) (142)
Original Budget Variance % Inc / (Dec)
56
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Minor Equipment General Office Supplies Materials & Supplies Chemicals Lab Supplies Uniforms Fuel / Oil Furniture Major Equipment Computer Supplies Software Copier/Laser Printer Supplies Business Meals Community Events Camp Expense (4515) Revenue Sharing Expense (4505) Programs - Internal (4510) Fitness - Internal (4523) Water Purchases Water Meters Building Materials Pipes and Components Training Materials T-Shirts/Pins/Etc. Total Supplies
Description 20,278 6,428 186,573 138,410 9,105 9,963 32,736 7,165 52,594 13,701 45,209 6,766 3,236 101,983 55,780 204,100 30,011 110,193 620,652 19,190 18,032 55 2,501 1,694,659
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
6153 6154 6155 6156 6160 6180
6032
6105 6110 6115 6120 6121 6122 6124 6130 6135 6140 6145 6148 6150
Object Code
General Fund Summary
11,297 3,834 135,048 140,552 3,529 10,376 25,780 12,236 28,988 12,212 47,687 5,517 6,559 72,350 90,885 173,777 28,610 109,775 706,592 10,951 32 16,008 13,314 1,665,908
FY2020 Forecast 25,375 11,805 156,795 223,000 8,500 20,300 33,250 14,300 40,500 8,240 13,785 7,650 5,800 79,650 90,885 173,777 28,610 98,925 718,250 15,000 22,900 1,700 6,650 1,805,647
FY2020 Original Budget 20,975 5,430 155,225 149,300 4,000 16,100 27,900 12,800 76,100 16,000 50,475 5,300 7,300 94,700 39,730 111,585 19,210 58,865 716,000 15,000 26,100 5,350 5,000 1,638,444
FY2021 Budget (4,400) (6,375) (1,570) (73,700) (4,500) (4,200) (5,350) (1,500) 35,600 7,760 36,690 (2,350) 1,500 15,050 (51,155) (62,192) (9,400) (40,060) (2,250)
3,200 3,650 (1,650) (167,203)
14% 215% -25% -9%
Original Budget Variance $ Inc / (Dec)
-17% -54% -1% -33% -53% -21% -16% -10% 88% 94% 266% -31% 26% 19% -56% -36% -33% -40% 0%
Original Budget Variance % Inc / (Dec)
57
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Rent Expense Building Maintenance District Vehicle Repairs Facility Rent Expense Equipment Rent Expense Postage Expense Express Mail/Parcel Shipping Solid Waste Service Phone/ Cable / Connectivity Exp Pager / Cell Phone Utility Bill Expenses Fees/Dues/Subscription Expense TCEQ Regulatory Fees WW Capacity Charges Professional Development Fees Lab Fees
Repair/Mtc/Warranty Expense
Printing Expense Advertising Recruiting Expense Program Meals Utilities Expense Longevity Awards Professional Liability Insurance Bad Debt Expense
6210 6212 6213 6215 6216 6220 6222 6224 6250 6300 6304 6305 6310 6311 6312 6314 6315
6320
6322 6324 6325 6327 6400 6405 6416 6425
145,552 15,924 5,620 9,828 2,406 453,315 11,670 98,285 821
19,347 1,886 19,589 4,148 448,610 10,038 93,091 2,281
13,649 123,422 11,333 3,978 24,059 39,053 46 4,842 1,292,658 51,833 8,238 28,477 35,225 14,137 837,298 10,672 11,585
FY2020 Forecast
135,952
11,953 126,483 23,432 5,279 17,756 40,801 530 806 1,296,316 48,248 12,039 23,316 45,701 15,474 845,343 13,768 16,455
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
Description
Object Code
General Fund Summary
22,570 6,000 4,730 4,500 513,500 9,500 90,250 3,500
178,200
4,120 117,956 16,957 5,300 26,000 41,650 560 300 1,317,436 52,945 14,305 27,950 42,110 20,000 825,300 17,350 15,500
FY2020 Original Budget
16,600 3,600 2,400 2,000 460,600 12,000 100,250 2,500
302,100
5,100 115,000 13,000 4,000 14,200 40,000 4,450 1,151,000 55,430 9,670 26,700 43,480 15,000 850,000 22,525 15,000
FY2021 Budget
-26% -40% -49% -56% -10% 26% 11% -29%
70%
24% -3% -23% -25% -45% -4% -100% 1383% -13% 5% -32% -4% 3% -25% 3% 30% -3%
Original Budget Variance % Inc / (Dec)
(5,970) (2,400) (2,330) (2,500) (52,900) 2,500 10,000 (1,000)
123,900
980 (2,956) (3,957) (1,300) (11,800) (1,650) (560) 4,150 (166,436) 2,485 (4,635) (1,250) 1,370 (5,000) 24,700 5,175 (500)
Original Budget Variance $ Inc / (Dec)
58
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
TOTAL EXPENSES
Streetlights Principal - 2016 Series CC Revenue Interest - 2016 Series CC Revenue Contingency Total Other Expenses
Description 123,630 430,000 70,813 3,878,368 15,165,671
12,541,450
FY2020 Forecast
131,649 420,000 152,672 3,982,961
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
6430 6455 6456
Object Code
General Fund Summary
16,757,205
145,000 430,000 141,626 313,241 4,408,356
FY2020 Original Budget
14,445,172
133,800 430,000 70,813 303,076 4,224,294
FY2021 Budget
(2,312,033)
(70,813) (10,165) (184,062)
-50% -3% -4% -14%
(11,200)
Original Budget Variance $ Inc / (Dec)
-8%
Original Budget Variance % Inc / (Dec)
59
Object Code
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
0
4,238,427 -
Brushy Creek MUD District - Fiscal Year 2021 Budget
TB Difference 0
-1,062,481 13,975,966 303,076 13,672,890 896,176
12,887,305 313,241 12,574,064
(0)
4,514,524 4,514,524 708,649
FY2021 Budget
0
0
4,238,427
REVENUE IN EXCESS OF EXPENSES
(32,144)
1,346,160 1,346,160 1,371,194 289,987
FY2020 Forecast
1,375,920 1,375,920 -
FY2019 Actual
FY2020 Original Budget
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
Description
General Fund Summary Original Budget Variance % Inc / (Dec)
(1)
Original Budget Variance $ Inc / (Dec)
60
Brushy Creek Municipal Utility District
Lodging Lodging Tax Cab Fare / local transportation Parking Travel Meals Mileage Total Travel
Total Capital Projects
Total Capital Expenditures
Contractual-Legal Contractual/Auditing Security Contractual/Contract Labor Total Contractual Minor Equipment General Office Supplies Materials & Supplies Furniture Major Equipment
5202 5203 5204 5205 5206 5207
5901
5902
6010 6025 6055 6080
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
-
-
196,208 41,750 112,183 133,106 483,247 946 223 2,149 (17) 1,050
469 53 523
263 263
131,428 34,750 73,650 22,725 262,553 529 8,230 286 2,757
2,597 711 190 3,498
2,226 639 244 3,109
Brushy Creek MUD District - Fiscal Year 2021 Budget
6105 6110 6115 6130 6135
FICA / Medicare Workers Compensation Unemployment Insurance Total Benefits
5020 5040 5050
35,100 35,100
FY2020 Forecast
29,100 29,100
2,039
TOTAL REVENUE
EXPENSES 5010 Salary Total Payroll
2,039
Promotional Materials
4502
FY2019 Actual
Description
Object Code
Executive 110
-
110,000 41,200 105,000 20,000 276,200 1,000 3,000 -
-
50 110 800 440 1,400
4,300 4,300
36,000 36,000
FY2020 Original Budget
-
-
130,000 41,750 116,500 41,000 329,250 975 230 2,200 1,000
-
-
50 110 800 440 1,400
4,300 4,300
36,000 36,000
FY2021 Budget
-77% -27%
18% 1% 11% 105% 19%
Original Budget Variance % Inc / (Dec)
1,000
20,000 550 11,500 21,000 53,050 975 (770) (800)
Original Budget Variance $ Inc / (Dec)
61
Brushy Creek Municipal Utility District
Computer Supplies Software Copier/Laser Printer Supplies Business Meals T-Shirts/Pins/Etc. Total Supplies
Description 25 1,638 3,236 16,701
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
6140 6145 6148 6150 6180
Object Code
Executive 110
4,177 720 6,371 6,063 21,682
FY2020 Forecast 1,000 5,000 4,650 14,650
FY2020 Original Budget 4,200 800 7,200 16,605
FY2021 Budget
-20% 44% -100% 13%
Original Budget Variance % Inc / (Dec) 4,200 (200) 2,200 (4,650) 1,955
Original Budget Variance $ Inc / (Dec)
62
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Description
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
570,758
353,654
(570,758)
26,709
41,927
(351,615)
55 212 58 1,420 1,550 9,560 2,034 11,670 150
FY2020 Forecast
463 5,542 109 168 1,467 635 3,369 51 15,688 4,148 10,038 250
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
REVENUE IN EXCESS OF EXPENSES
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
TOTAL EXPENSES
6216 Equipment Rent Expense 6220 Postage Expense 6222 Express Mail/Parcel 6224 Shipping 6300 Phone/ Cable / Connectivity Exp 6310 Fees/Dues/Subscription Expense 6314 Professional Development Fees 6322 Printing Expense 6324 Advertising 6325 Recruiting Expense 6327 Program Meals 6405 Longevity Awards 6416 Professional Liability Insurance Contingency Contingency Total Other Expenses
Object Code
Executive 110
(673,186)
-
673,186
2,000 175 1,500 350 4,120 5,000 4,500 9,500 250 313,241 340,636
FY2020 Original Budget
(708,731)
708,731
220 180 1,500 350 1,600 2,000 12,000 250 303,076 321,176
FY2021 Budget
(2,520) (5,000) (2,500) 2,500 (10,165) (19,460)
-61% -100% -56% 26% -3% -6%
213,595
35,545
220 5 3%
5%
(2,000)
Original Budget Variance $ Inc / (Dec)
-100%
Original Budget Variance % Inc / (Dec)
63
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Airfare Lodging Lodging Tax Cab Fare / local transportation Parking Travel Meals
5201 5202 5203 5204 5205 5206
31,425 39,254 474 2,411 579 2,304 9,156 14 27,062 112,678 1,542 1,412 469 1,331 15 749
56,769 78,238 947 4,773 1,235 4,458 13,552 852 57,814 218,637 3,331 3,507 2,634 222 476
Brushy Creek MUD District - Fiscal Year 2021 Budget
FICA / Medicare Health Vision Insurance Dental Life Disability Insurance Workers Compensation Unemployment Insurance Retirement Total Benefits
5020 5030 5031 5032 5034 5035 5040 5050 5070
414,102 12,155 426,258
761,430 11,981 773,411
7,111,502
8,073,612
TOTAL REVENUE
EXPENSES 5010 Salary 5011 Merit Salary 5012 Overtime Total Payroll
6,856,147 3,999 30 17,340 25,396 159,226 2,127 47,238
6,674,984 788 160 33,434 62,780 543,395 659,775 98,296
Property Tax Income Delinquent Property Tax Income New Connection Fees Service Charges Late Charges Interest Income Other Income Rental Income
FY2020 Actual
4101 4102 4220 4401 4403 4405 4500 4501
YTD
Description
FY2019 Actual
Object Code
Administrative 120
985,384 2,463 9,458 997,305 111,049 174,486 285,535 600 50 100 550
61,705 83,004 973 4,955 1,274 5,072 28,617 2,178 53,085 240,863 1,542 1,412 469 1,331 15 749
6,867,264 34,336 28,000 65,000 175,000 135,000 7,304,600
FY2020 Original Budget
817,586 22,703 840,290
7,479,600
6,867,264 34,336 28,000 65,000 350,000 135,000
FY2020 Forecast
1,500 600 50 100 550
83,909 118,751 1,512 7,583 2,194 7,481 32,605 7,097 72,118 333,249
1,084,919 2,500 11,934 1,099,353
7,356,000
6,919,000 34,000 28,000 65,000 175,000 135,000
FY2021 Budget
17%
-24% -32%
10% 1% 26% 10%
1%
0.8% -1.0%
Original Budget Variance % Inc / (Dec)
1,500
(27,140) (55,735) 1,512 7,583 2,194 7,481 32,605 7,097 72,118 47,714
99,535 37 2,476 102,048
51,400
51,736 (336)
Original Budget Variance $ Inc / (Dec)
64
Brushy Creek Municipal Utility District
Add an additional vehicle for Security Total Capital Expenditures
5902 2,700 105,127 6,772 82,210 24,631 55,534 276,974
26,446
4,200 14,370
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
Contractual/ Trainers- Instructors Contractual/Network maint/dev. Contractual/Website Appraisal Fees Depository Contract Maintenance Contracts Contractual/Contract Labor Total Contractual
Total Capital Projects
5901
6030 6040 6045 6060 6065 6070 6080
Mileage Total Travel
Description
5207
Object Code
Administrative 120
YTD
53,002 2,100 42,843 33,374 22,029 153,349
2,468 7,986
FY2020 Actual
153,925 2,100 94,756 37,844 30,637 319,262
16,000
3,412 8,930
FY2020 Forecast
5,000 65,000 2,000 1,000 60,000 54,796 3,000 190,796
16,000
1,200 2,500
FY2020 Original Budget
2,700 100,000 2,100 110,000 35,450 5,000 255,250
35,000 35,000
-
1,200 4,000
FY2021 Budget
-46% 54% 5% -100% 83% -35% 67% 34%
-100%
60%
Original Budget Variance % Inc / (Dec)
(2,300) 35,000 100 (1,000) 50,000 (19,346) 2,000 64,454
35,000
(16,000)
1,500
Original Budget Variance $ Inc / (Dec)
65
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Rent Expense District Vehicle Repairs Facility Rent Expense Equipment Rent Expense Postage Expense Express Mail/Parcel Shipping Phone/ Cable / Connectivity Exp Pager / Cell Phone Fees/Dues/Subscription Expense Professional Development Fees Repair/Mtc/Warranty Expense Printing Expense Advertising Recruiting Expense Program Meals Utilities Expense Professional Liability Insurance
6210 6213 6215 6216 6220 6222 6224 6300 6304 6310 6314 6320 6322 6324 6325 6327 6400 6416
3,892 2,057 3,563 5,834 134 12,165 805 2,369 357 2,164 530 2,813 248 103 3,214 49,067
2,311 3,435 8,060 8,099 421 11 24,146 2,230 6,404 1,573 1,925 570 1,834 2,687 5,253 92,841
FY2020 Actual 920 1,067 1,131 3,048 24,211 1,784 54 32,214
YTD
3,117 2,862 3,645 94 1,859 1,707 13,676 41,565 2,328 70,853
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
Minor Equipment General Office Supplies Materials & Supplies Uniforms Furniture Major Equipment Computer Supplies Software Copier/Laser Printer Supplies Business Meals Training Materials T-Shirts/Pins/Etc. Total Supplies
Description
6105 6110 6115 6122 6130 6135 6140 6145 6148 6150 6160 6180
Object Code
Administrative 120
1,250 5,665 3,090 4,000 4,000 8,240 13,785 4,000 100 500 44,630 4,120 3,500 10,000 7,200 500 50 26,000 2,500 7,000 4,500 250 2,500 1,000 1,500 5,400 90,000
11,477 25 3,822 7,559 8,334 298 24,167 1,305 6,552 365 3,019 983 4,485 268 103 6,054 98,135
FY2020 Original Budget
1,590 2,035 4,022 87 2,204 3,973 12,038 43,271 3,409 54 72,683
FY2020 Forecast
4,000 3,500 8,000 8,000 100 25,000 1,800 6,500 5,500 800 1,000 3,600 2,400 6,500 91,602
1,600 3,000 3,000 1,000 2,000 30,000 16,000 41,500 3,000 100 3,000 104,200
FY2021 Budget
(500) 3,000 59,570
-100%
(120)
(2,000) 800 (500) 50 (1,000) (700) (500) 1,000 550 (1,500) 2,600 900 1,100 1,602
-3%
-20% 11% -100% 100% -4% -28% -7% 22% 220% -60% 260% 60% 20% 2%
133%
94% 201% -25%
350 (2,665) (90) (3,000) (2,000) 30,000 7,760 27,715 (1,000)
Original Budget Variance $ Inc / (Dec) 28% -47% -3% -75% -50%
Original Budget Variance % Inc / (Dec)
66
Brushy Creek Municipal Utility District
REVENUE IN EXCESS OF EXPENSES
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
TOTAL EXPENSES
Bad Debt Expense Streetlights Total Other Expenses
Description
6,398,109
6,232,387
-
879,115
1,675,504
FY2020 Actual 541 56,773 146,631
YTD
1,364 131,649 294,813
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
6425 6430
Object Code
Administrative 120
5,680,569
1,799,031
424 123,630 301,004
FY2020 Forecast
5,454,314
-
1,850,286
2,500 145,000 313,520
FY2020 Original Budget
3,189,897
2,031,449
2,134,654
1,500 133,800 303,602
FY2021 Budget
15%
-40% -8% -3%
Original Budget Variance % Inc / (Dec)
(2,422,417)
284,367
(1,000) (11,200) (9,918)
Original Budget Variance $ Inc / (Dec)
67
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
TOTAL REVENUE
Description
Brushy Creek Municipal Utility District
Total Capital Projects
Total Capital Expenditures
5901
5902
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Minor Equipment General Office Supplies Materials & Supplies Uniforms Furniture Copier/Laser Printer Supplies
-
-
307 415 2,095 887
-
100 100
-
180 825 25 1,200 -
435 243 180 54
-
22,068 52,194 74,262
12,795 30,734 367 1,843 352 1,248 5,687 699 10,730 64,453
195,817 490 2,699 199,006
-
13,477 33,819 400 2,017 432 1,322 3,452 176 10,837 65,931
164,430 4,087 168,517
-
FY2020 Forecast
FY2020 Original Budget
173,174 4,016 177,190
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
6105 6110 6115 6122 6130 6148
Airfare Lodging Travel Meals Mileage Total Travel
5201 5202 5206 5207
Total Contractual
FICA / Medicare Health Vision Insurance Dental Life Disability Insurance Workers Compensation Unemployment Insurance Retirement Total Benefits
5020 5030 5031 5032 5034 5035 5040 5050 5070
EXPENSES 5010 Salary 5011 Merit Salary 5012 Overtime Total Payroll
Object Code
Customer Service 130
-
-
200 600 200
-
-
-
400 400 100 100 1,000
14,474 33,985 421 2,083 378 1,290 5,624 1,224 12,440 71,920
183,004 500 6,196 189,700
FY2021 Budget
11% -27% 700% -100%
900%
-3%
-34% -35%
-7% 2% 130% -5%
Original Budget Variance % Inc / (Dec)
20 (225) 175 (1,200)
900
400 400 100
(7,594) (18,209) 421 2,083 378 1,290 5,624 1,224 12,440 (2,342)
(12,813) 10 3,497 (9,306)
Original Budget Variance $ Inc / (Dec)
68
Brushy Creek Municipal Utility District
REVENUE IN EXCESS OF EXPENSES
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
TOTAL EXPENSES
Phone/ Cable / Connectivity Exp Pager / Cell Phone Utility Bill Expenses Fees/Dues/Subscription Expense Professional Development Fees Printing Expense Recruiting Expense Total Other Expenses
Total Supplies
Description
235,916
248,822
(235,916)
195 176 1,109 26 390 139 2,034
168 211 1,162 269 186 1,996
(248,822)
912
FY2020 Forecast
3,704
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
6300 6304 6305 6310 6314 6322 6325
Object Code
Customer Service 130
(277,038)
-
277,038
190 450 500 200 100 1,440
2,230
FY2020 Original Budget
(266,620)
266,620
200 200 1,200 200 1,000 200 3,000
1,000
FY2021 Budget
-4%
10,418
(10,418)
(100) 1,560
-100% 108%
-60%
10 (250) 1,200 (300) 1,000
(1,230)
Original Budget Variance $ Inc / (Dec)
5% -56%
-55%
Original Budget Variance % Inc / (Dec)
69
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Lodging Lodging Tax Parking Travel Meals Mileage Total Travel
Total Capital Projects
Cat Hollow Park - Parking Lot resurface Total Capital Expenditures
5202 5203 5205 5206 5207
5901
5902
20,348 44,904 512 2,659 557 1,893 8,577 1,006 17,141 97,597 540,238
21,542 45,658 542 2,815 642 2,021 5,452 64 17,995 96,730 80 512 614 689 1,895 68,307
Brushy Creek MUD District - Fiscal Year 2021 Budget
FICA / Medicare Health Vision Insurance Dental Life Disability Insurance Workers Compensation Unemployment Insurance Retirement Total Benefits
5020 5030 5031 5032 5034 5035 5040 5050 5070
260,714 11,964 272,678
277,376 10,663 288,039
14,000
11,992
TOTAL REVENUE
EXPENSES 5010 Salary 5011 Merit Salary 5012 Overtime Total Payroll
14,000
11,992
Other Income
4500
FY2020 Forecast
Description
FY2019 Actual
Object Code
Park Maintenance 275
650,500
1,785 97 815 1,075 3,772
33,284 72,074 105,358
295,344 738 7,727 303,809
14,000 14,000
FY2020 Original Budget
75,000 75,000
-
1,800 800 1,000 3,600
22,279 44,269 544 2,768 582 1,986 8,657 1,884 19,148 102,119
276,026 750 15,205 291,981
14,000
14,000
FY2021 Budget
75,000
(650,500)
(15) (75) (172)
-2% -7% -5% -100%
15 (97)
(11,005) (27,805) 544 2,768 582 1,986 8,657 1,884 19,148 (3,239)
(19,318) 12 7,478 (11,828)
Original Budget Variance $ Inc / (Dec)
1% -100%
-3%
-33% -39%
-7% 2% 97% -4%
Original Budget Variance % Inc / (Dec)
70
Brushy Creek Municipal Utility District
Minor Equipment General Office Supplies Materials & Supplies Chemicals Uniforms Fuel / Oil Major Equipment Computer Supplies Copier/Laser Printer Supplies Business Meals Community Events Pipes and Components Training Materials OtherSupplies Supplies Expenses Total
Rent Expense District Vehicle Repairs Facility Rent Expense Equipment Rent Expense Postage Expense Shipping Solid Waste Service Phone/ Cable / Connectivity Exp Pager / Cell Phone Fees/Dues/Subscription Expense Professional Development Fees Repair/Mtc/Warranty Expense
6105 6110 6115 6120 6122 6124 6135 6140 6148 6150
6210 6213 6215 6216 6220 6224 6250 6300 6304 6310 6314 6320
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
7,500 515 58,105 1,000 3,000 15,450 15,000 750 700 7,300 1,900 100111,320
1,212 63 35,487 2,196 3,207 7,325 8,814 88 4,522 62,914 2,172 2,361 156 14 1,122 4,800 1,111 1,525 399 2,850 22,763
5,452 56 75,279 4,646 2,825 13,153 3,973 93 4,864 1,962 55 112,358 9,227 1,844 367 50 6,684 1,182 1,790 864 3,431 22,323
7,957 1,800 5,500 6,500 1,030 2,575 1,960 3,500 20,000
500,050 56,000 75,400 631,450
FY2020 Forecast
FY2020 Original Budget
515,462 10,942 526,404
496,826 7,297 50,794 554,916
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
6156 6160
Maintenance Contracts Engineering Fees Contractual/Contract Labor Total Contractual
Description
6070 6079 6080
Object Code
Park Maintenance 275
1,100 2,500 500 1,200 5,000 1,000 1,700 600 3,500 58,000
1,200 60,000 5,000 3,000 8,400 8,800 7,300 5,600 99,300
528,000 11,100 539,100
FY2021 Budget
(750) (700) 3,700 (100) (12,020)
-100% -100% 195% -100% -11%
1,200 (1,500) (30) (875) (1,360) 38,000
-23% -3% -34% -69% 190%
1,100 (5,457) (1,300) (5,500)
(7,050) (6,200)
-46% -41%
-69% -72% -100%
(6,300) (515) 1,895 4,000
27,950 (56,000) (64,300) (92,350)
Original Budget Variance $ Inc / (Dec)
-84% -100% 3% 400%
6% -100% -85% -15%
Original Budget Variance % Inc / (Dec)
71
Brushy Creek Municipal Utility District
REVENUE IN EXCESS OF EXPENSES
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
TOTAL EXPENSES
Printing Expense Recruiting Expense Utilities Expense Professional Liability Insurance Total Other Expenses
Description
(1,533,447)
1,547,447
1,176,539
(1,164,547)
660 7,681 47,615
FY2020 Forecast
956 50 5,528 54,294
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
6322 6325 6400 6416
Object Code
Park Maintenance 275
(1,427,831)
425,000 -
1,866,831
2,750 250 6,800 60,622
FY2020 Original Budget
(1,184,789)
1,198,789
800 8,000 3,789 87,689
FY2021 Budget
-36%
45%
-71% -100% 18%
Original Budget Variance % Inc / (Dec)
243,042
(668,042)
(1,950) (250) 1,200 3,789 27,067
Original Budget Variance $ Inc / (Dec)
72
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
TOTAL REVENUE
Description
Other Supplies Expenses Other Supplies Expenses Other Supplies Expenses
Brushy Creek MUD District - Fiscal Year 2021 Budget
Minor Equipment Materials & Supplies Chemicals
6105 6115 6120
6080
5902
Creekside Pool - Deck Replacement Highland Horizon Pool - Replaster Sendero Springs - Thermal Cover Total Capital Expenditures
Contractual/Contract Labor Total Contractual
5901
Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses
5010 5011 5012
Visible
Total Capital Projects
Total Travel
FICA / Medicare Health Vision Insurance Dental Life Disability Insurance Workers Compensation Unemployment Insurance Retirement Other Benefit Expenses Total Benefits
6080
5902
5901
5020 5030 5031 5032 5034 5035 5040 5050 5070
EXPENSES 5010 Salary 5011 Merit Salary 5012 Overtime Total Payroll
Object Code
Aquatics Maintenance 450
-
3,690 12,678 41,640
2,437 2,437
7,500 44,444
405 405
122,275
-
11,815
92,281
4,015 3,458 40 197 51 166 1,101 2 1,800 10,831
4,278 4,021 46 224 53 154 992 265 1,781
52,404 540 52,944
-
FY2020 Forecast
55,604 756 56,360
FY2019 Actual -
1,545 7,500 51,000
2,000 2,000
104,400
-
4,273 8,587 12,860
37,918 95 604 38,617
FY2020 Original Budget -
1,600 7,600 45,000
-
110,000 59,000 8,500 177,500
-
-
7,451 13,828 167 848 184 627 2,895 630 6,404 33,033
94,586 100 2,810 97,496
FY2021 Budget
4% 1% -12%
-100% -100%
-100%
157%
74% 61%
149% 5% 365% 152%
Original Budget Variance % Inc / (Dec)
55 100 (6,000)
(2,000) (2,000)
177,500
(104,400)
20,173
3,178 5,241 167 848 184 627 2,895 630 6,404
56,668 5 2,206 58,879
Original Budget Variance $ Inc / (Dec)
Brushy Creek Municipal Utility District
Rent Expense Building Maintenance Shipping Pager / Cell Phone Fees/Dues/Subscription Expense Professional Development Fees Repair/Mtc/Warranty Expense Utilities Expense Total Other Expenses
6210 6212 6224 6304 6310 6314 6320 6400
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
All Other Expenses All Other Expenses All Other Expenses All Other Expenses All Other Expenses All Other Expenses 6320 6400
Other Supplies Expenses Other Supplies Expenses Other Supplies Expenses
Visible
Brushy Creek MUD District - Fiscal Year 2021 Budget
REVENUE IN EXCESS OF EXPENSES
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
TOTAL EXPENSES
Uniforms Major Equipment Computer Supplies Total Supplies
Description
6122 6135 6140
Object Code
Aquatics Maintenance 450
303,049
306,223
(303,049)
9,958 529 68 7 (30) 16,887 35,530 62,948
9,643 2,857 90 19,628 43,335 75,553
(306,223)
1,668 35 53,647
FY2020 Forecast
9,769 67,778
FY2019 Actual
(290,528)
-
290,528
4,456 150 12,500 55,000 72,106
500 60,545
FY2020 Original Budget
(456,130)
456,130
20,000 530 70 23,000 41,500 85,100
8,800 63,000
FY2021 Budget
57%
(165,602)
165,602
10,500 (13,500) 12,994
84% -25% 18%
-53%
15,544 530 (80)
2,455
4% 349%
(500) 8,800
Original Budget Variance $ Inc / (Dec) -100%
Original Budget Variance % Inc / (Dec)
74
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek MUD District - Fiscal Year 2021 Budget
REVENUE IN EXCESS OF EXPENSES
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To 40,889
-
18
-
850
-
-
Total Other Expenses
TOTAL EXPENSES
-
-
Total Supplies
Depository Contract Total Contractual
6065
-
Total Capital Expenditures
5902
-
18 18
Total Capital Projects
-
-
Total Travel
5901
-
-
Total Benefits
850 850 -
-
-
FY2020 Original Budget
-
TOTAL REVENUE
FY2020 Forecast
Total Payroll
40,907
Builders Fees Interest Income
4130 4405
EXPENSES
19,953 20,953
Description
FY2019 Actual
Object Code
Builder Park Fees 225
FY2021 Budget
-
-
-
-
-100%
-100.0%
Original Budget Variance % Inc / (Dec)
0
(850)
(850)
Original Budget Variance $ Inc / (Dec)
75
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
TOTAL REVENUE
Description
5901
Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses
5010 Other Payroll Expenses Other Payroll Expenses
Visible
Minor Equipment Materials & Supplies Total Supplies
6105 6115
6105 6115
Other Contractual Expenses 6080
Brushy Creek MUD District - Fiscal Year 2021 Budget
Engineering Fees Contractual/Contract Labor Total Contractual
Replace HVAC Systems (East side) Replace Red Lobby Concierge Desk Red Gym Air Handlers (FY21 and FY22) Community Center Garden Improvements 5902 Total Capital Expenditures
Total Capital Projects
Total Travel
FICA / Medicare Health Vision Insurance Dental Life Disability Insurance Workers Compensation Unemployment Insurance Retirement Total Benefits
6079 6080
5902
5901
5020 5030 5031 5032 5034 5035 5040 5050 5070
EXPENSES 5010 Salary 5011 Merit Salary 5012 Overtime Total Payroll
Object Code
Facilities Maintenance 400
9,070 9,070 14,302 14,302
3,523 700 4,223 1,107 17,686 18,793
147,247
-
21,186
2,515 4,923 57 280 77 249 1,175 2,200 11,476
2,528 5,396 62 301 85 252 626 2,166 11,416
32,554 1,901 34,454
-
FY2020 Forecast
34,066 696 34,762
FY2019 Actual -
800 18,000 18,800
4,500 4,500
15,000
-
4,561 9,415 13,976
40,469 101 1,420 41,990
FY2020 Original Budget -
800 18,000 18,800
-
34,000 8,000 30,000 465,000 537,000
-
-
5,330 8,568 103 501 139 475 2,071 451 4,581 22,219
66,342 100 3,333 69,774
FY2021 Budget
-100% -100%
-100%
59%
17% -9%
64% -1% 135% 66%
Original Budget Variance % Inc / (Dec)
(4,500) (4,500)
537,000
(15,000)
769 (847) 103 501 139 475 2,071 451 4,581 8,243
25,873 (1) 1,913 27,784
Original Budget Variance $ Inc / (Dec)
Brushy Creek Municipal Utility District
REVENUE IN EXCESS OF EXPENSES
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
TOTAL EXPENSES
Building Maintenance District Vehicle Repairs Shipping Pager / Cell Phone Repair/Mtc/Warranty Expense Total Other Expenses
Description
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
6212 All Other Expenses All Other Expenses 6304 6320
Visible
Brushy Creek MUD District - Fiscal Year 2021 Budget
6212 6213 6224 6304 6320
Object Code
Facilities Maintenance 400
(378,983)
378,983
229,188
(229,188)
102,296 45 63 240 59,790 162,434
FY2020 Forecast
107,518 240 31,050 138,808
FY2019 Actual
(198,016)
15,000 -
213,016
103,000 300 15,450 118,750
FY2020 Original Budget
(802,393)
802,393
85,000 300 69,300 154,600
FY2021 Budget
(549,377)
589,377
53,850 35,850
349% 30% 277%
(18,000)
Original Budget Variance $ Inc / (Dec) -17%
Original Budget Variance % Inc / (Dec)
77
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
FICA / Medicare Health Vision Insurance Dental Life Disability Insurance Workers Compensation Unemployment Insurance Retirement Total Benefits
7,666 7,588 90 450 95 334 5,193 35 5,589 27,041
8,258 8,217 96 477 105 343 1,923 174 6,007 25,601
Brushy Creek MUD District - Fiscal Year 2021 Budget
5020 5030 5031 5032 5034 5035 5040 5050 5070
100,248 512 100,760
108,014 1,354 109,368
79,206
185,782
TOTAL REVENUE
EXPENSES 5010 Salary 5011 Merit Salary 5012 Overtime Total Payroll
4,796 5,480 16,789 2,965 49,176
150 18 10,862 2,060 15,218 25,789 10,258 3,651 117,776
Donations Other Income Rental Income Promotional Materials Community Events Revenue Program Revenue Contract Programming Events Income Season Passes Fitness Revenue
4402 4500 4501 4502 4504 4505 4510 4521 4523
FY2020 Forecast
Description
FY2019 Actual
Object Code
Park Programs 200
20,151 28,879 49,030
178,812 447 177 179,436
8,600 10,575 23,300 15,325 3,250 79,790 140,840
FY2020 Original Budget
16,932 18,590 227 1,125 265 903 6,579 1,432 10,147 56,200
219,653 450 1,683 221,786
110,317
6,630 10,500 16,762 8,225 3,250 64,950
FY2021 Budget
(14,840)
-18.6%
15%
-16% -36%
23% 1% 851% 24%
(3,219) (10,289) 227 1,125 265 903 6,579 1,432 10,147 7,170
40,841 3 1,506 42,350
(30,523)
(75) (6,538) (7,100)
-0.7% -28.1% -46.3%
-22%
(1,970)
Original Budget Variance $ Inc / (Dec)
-22.9%
Original Budget Variance % Inc / (Dec)
78
Brushy Creek Municipal Utility District
6115 6135 6145 6148 6150
Brushy Creek MUD District - Fiscal Year 2021 Budget
6180
6032
16,960 2,600 50 70 72,350 17,900 2,650 32,775 7,250 152,605
Materials & Supplies Major Equipment Software Copier/Laser Printer Supplies Business Meals Community Events Revenue Sharing Expense (4505) Programs - Internal (4510) Fitness - Internal (4523) T-Shirts/Pins/Etc. Total Supplies
6055 6080 3,780 84 88,999 19,582 3,817 31,407 147,669
Security Contractual/Contract Labor Total Contractual
5902
96,000
197 197
2,600 36,644 39,244
Total Capital Expenditures
5901
FY2020 Forecast
-
-
Community Park Turn around Shirley McDonald Park - Trail lighting Total Capital Projects
5207
-
Description
FY2019 Actual
Mileage Total Travel
Object Code
Park Programs 200
-
500 72,350 17,900 2,650 25,775 119,175
-
70,000
FY2020 Original Budget -
500 87,400 13,900 2,650 26,350 130,800
-
-
169,500 25,000 194,500
FY2021 Budget
11,625
575
2% 10%
15,050 (4,000)
124,500
Original Budget Variance $ Inc / (Dec)
21% -22%
178%
Original Budget Variance % Inc / (Dec)
79
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek Municipal Utility District
(70,000)
20,408
REVENUE IN EXCESS OF EXPENSES
(347,435)
207,151 -
117,577
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
417,991
426,641
282,951
350 350
TOTAL EXPENSES
Equipment Rent Expense Shipping Pager / Cell Phone Fees/Dues/Subscription Expense Professional Development Fees Lab Fees Repair/Mtc/Warranty Expense Printing Expense Advertising Program Meals Professional Liability Insurance Total Other Expenses
7,716 326 100 1,377 (248) 352 991 180 10,795
FY2020 Forecast
FY2020 Original Budget
273 40 313
Description
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
6216 6224 6304 6310 6314 6315 6320 6322 6324 6327 6416
Object Code
Park Programs 200
(0)
533,336
643,653
300 40,000 67 40,367
FY2021 Budget
54%
11433%
-14%
Original Budget Variance % Inc / (Dec)
41,790
225,662
67 40,017
40,000
(50)
Original Budget Variance $ Inc / (Dec)
80
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
104,921 302,613 466 303,079 20,480 8,224 95 467 85 263 7,911 2,340 6,388 46,252 599 45 70 329 5,310 6,353
196,172 358,780 5,582 364,362 27,922 13,614 156 760 92 268 6,616 2,797 7,174 59,399 43 36 174 6,542 6,794
Salary Merit Salary Overtime Total Payroll
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek MUD District - Fiscal Year 2021 Budget
Lodging Cab Fare / local transportation Parking Travel Meals Mileage Total Travel
FICA / Medicare Health Vision Insurance Dental Life Disability Insurance Workers Compensation Unemployment Insurance Retirement Total Benefits
Rental Income Program Revenue Contract Programming Events Income Memberships Season Passes Day Passes
TOTAL REVENUE
FY2020 Forecast 36,500 18,896 34,640 14,885
FY2019 Actual 47,163 54,454 2 67,788 26,765
Description
Aquatic Programs 250
400 200 5,305 5,905
45,138 25,204 70,342
400,528 1,001 1,428 402,957
49,283 5,000 68,229 76,232 30,417 229,161
FY2020 Original Budget
400 200 5,305 5,905
45,138 25,204 70,342
400,528 1,001 1,428 402,957
229,161
49,283 5,000 68,229 76,232 30,417
FY2020 Revised Budget
400 200 5,464 6,064
34,986 26,002 316 1,559 167 571 13,595 2,959 11,815 91,969
457,330 1,000 458,330
137,203
32,900 38,117 47,451 18,735
FY2021 Budget
3% 3%
31%
-22% 3%
14% 0% -100% 14%
159 159
(10,152) 798 316 1,559 167 571 13,595 2,959 11,815 21,627
56,802 (1) (1,428) 55,372
(91,958)
(28,781) (11,682)
-37.8% -38.4% -40%
(16,383) (5,000) (30,112)
Original Budget Variance $ Inc / (Dec)
-33.2% -100.0% -44.1%
Original Budget Variance % Inc / (Dec)
81
Brushy Creek Municipal Utility District
205 3,616 2,000 865 5,240 1,557 400 100 11,000 24,983
932 352 4,413 1,962 793 721 12,241 1,412 132 15,124 38,080
24,900
250 250
-
FY2020 Forecast
-
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
Minor Equipment General Office Supplies Materials & Supplies Uniforms Fuel / Oil Furniture Major Equipment Software Community Events Camp Expense (4515) Revenue Sharing Expense (4505) Programs - Internal (4510) Training Materials Total Supplies
Depository Contract Contractual/Contract Labor Total Contractual
Total Capital Expenditures
Sendero Springs Pool - Building Expansion Total Capital Projects
Description
Aquatic Programs 250
1,000 500 2,575 2,000 1,000 4,800 5,000 400 100 11,000 500 28,875
-
275,000
FY2020 Original Budget
1,000 500 2,575 2,000 1,000 4,800 5,000 400 100 11,000 500 28,875
-
112,806
FY2020 Revised Budget
500 250 3,725 3,600 1,000 7,800 3,000 2,775 11,500 34,150
700 700
-
274,706 274,706
FY2021 Budget
(500) (250) 1,150 1,600 3,000 (2,000) 2,775 (400) (100) 500 (500) 5,275
63% -40%
-100% -100% 5% -100% 18%
700
700
(294)
Original Budget Variance $ Inc / (Dec)
-50% -50% 45% 80%
0%
Original Budget Variance % Inc / (Dec)
82
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek Municipal Utility District
(112,806)
(34,730)
REVENUE IN EXCESS OF EXPENSES
Brushy Creek MUD District - Fiscal Year 2021 Budget
(325,844)
309,678 162,194 -
260,990
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
813,839
430,765
500 15,000 530 13,000 1,000 200 530 30,760
491,892
District Vehicle Repairs Equipment Rent Expense Shipping Phone/ Cable / Connectivity Exp Pager / Cell Phone Fees/Dues/Subscription Expense Professional Development Fees Printing Expense Recruiting Expense Total Other Expenses
TOTAL EXPENSES
FY2020 Forecast 123 830 54 12,471 300 10,031 670 469 24,948
FY2019 Actual
FY2020 Original Budget
1,402 11,920 505 7,688 1,102 540 100 23,256
Description
Aquatic Programs 250
(112,806)
309,678 -
651,645
500 15,000 530 13,000 1,000 200 530 30,760
FY2020 Revised Budget
0
756,571
893,774
1,000 13,000 300 11,680 1,375 500 27,855
FY2021 Budget
112,807
79,934
(2,000) (230) (1,320) 375 300 (530) (2,905)
-13% -43% -10% 38% 150% -100% -9% 10%
500
Original Budget Variance $ Inc / (Dec)
100%
Original Budget Variance % Inc / (Dec)
83
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
New Connection Fees Donations Other Income Rental Income Program Revenue Contract Programming Events Income Camp Income Memberships - Short Term New Memberships Memberships Day Passes
Fitness Revenue
Senior Programs Child Programs / Child Play
4220 4402 4500 4501 4505 4510 4515 4518 4519 4520 4522
4523
4524 4525
FICA / Medicare Health Vision Insurance Dental Life Disability Insurance Workers Compensation Unemployment Insurance Other Benefits Retirement Total Benefits
Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses Other Benefit Expenses
5010 Other Payroll Expenses Other Payroll Expenses
Other Revenue Other Revenue
4523
Other Revenue Other Revenue Other Revenue 4501 4505 4510 4515 4518 Other Revenue 4520 Other Revenue
Visible
Brushy Creek MUD District - Fiscal Year 2021 Budget
5020 5030 5031 5032 5034 5035 5040 5050 5060 5070
EXPENSES 5010 Salary 5011 Merit Salary 5012 Overtime Total Payroll
TOTAL REVENUE
Description
Object Code
Community Center Programs 300
74,102 80,346 962 4,770 1,032 3,123 27,926 4,853 55,008 252,121
81,723 82,119 994 4,844 957 2,887 17,917 3,947 60,244 255,632
864,572
1,592,716
967,176 6,700 973,875
3,927
298 7,036
1,068,888 13,619 1,082,507
127,747
2,262 51,391 95,058 6,836 170,890 27,725 15,402 331,189 32,145
FY2020 Forecast
277,024
10 50 2,767 103,972 245,760 13,820 283,421 42,832 26,030 538,230 51,467
FY2019 Actual
108,365 154,581 262,946
961,567 2,404 7,792 971,763
300 5,000 1,394,990
246,825
4,000 110,000 208,810 13,165 294,515 41,850 22,940 409,275 38,310
FY2020 Original Budget
73,625 68,480 867 4,122 840 2,866 28,609 6,227 45,553 231,188
955,519 2,400 6,900 964,819
929,893
2,800
111,783
1,800 41,588 130,250 6,325 198,654 29,475 17,269 358,670 31,279
FY2021 Budget
-12%
-32% -56%
-1% 0% -11% -1%
-33%
-100.0% -44.0%
-54.7%
-55.0% -62.2% -37.6% -52.0% -32.5% -29.6% -24.7% -12.4% -18.4%
Original Budget Variance % Inc / (Dec)
45,553 (31,758)
(34,740) (86,101) 867 4,122 840 2,866 28,609 6,227
(6,048) (4) (892) (6,944)
(465,097)
(300) (2,200)
(135,042)
(2,200) (68,412) (78,560) (6,840) (95,861) (12,375) (5,671) (50,605) (7,031)
Original Budget Variance $ Inc / (Dec)
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Total Capital Projects
Total Capital Expenditures
Security Depository Contract Maintenance Contracts Engineering Fees Contractual/Contract Labor Total Contractual
Minor Equipment General Office Supplies Materials & Supplies Chemicals Uniforms Fuel / Oil Furniture Major Equipment Copier/Laser Printer Supplies Business Meals Community Events Camp Expense (4515) Revenue Sharing Expense (4505) Programs - Internal (4510) Fitness - Internal (4523) Building Materials T-Shirts/Pins/Etc. Total Supplies
5901
5902
6055 6065 6070 6079 6080
6105 6110 6115 6120 6122 6124 6130 6135 6148 6150
Other Supplies Expenses Other Supplies Expenses Other Supplies Expenses Other Supplies Expenses Other Supplies Expenses Other Supplies Expenses Other Supplies Expenses Other Supplies Expenses Other Supplies Expenses Other Supplies Expenses Other Supplies Expenses Other Supplies Expenses Other Supplies Expenses Other Supplies Expenses Other Supplies Expenses Other Supplies Expenses Other Supplies Expenses
Other Contractual Expenses Other Contractual Expenses Other Contractual Expenses Other Contractual Expenses Other Contractual Expenses
5902
5901
Other Travel Expenses Other Travel Expenses Other Travel Expenses
Visible
Brushy Creek MUD District - Fiscal Year 2021 Budget
6155 6180
6032
Lodging Travel Meals Mileage Total Travel
Description
5202 5206 5207
Object Code
Community Center Programs 300
700 43,509 8,189 52,398 2,878 592 36,501 326 2,000 4,808 8,110 1,181 65 90,485 155,777 14,960 77,000 32 394,716
526 1,273 43,858 2,013 2,204 4,727 1,293 6,707 55,649 184,518 11,070 78,786 386 393,010
-
204 2,276 2,481
FY2020 Forecast
1,875 31,031 10,939 745 3,155 47,745
11,956
278 344 713 1,335
FY2019 Actual
3,400 1,000 35,000 1,300 4,500 5,500 4,000 1,400 90,485 155,777 14,960 73,150 390,472
3,000 25,000 9,270 37,270
-
1,000 500 1,500
FY2020 Original Budget
8,000 600 42,000 1,000 4,500 1,000 3,000 1,500 1,400 39,730 97,685 5,060 32,515 237,990
2,000 40,000 8,740 9,500 60,240
-
-
210 1,500 1,710
FY2021 Budget
-39%
(152,482)
(50,755) (58,092) (9,900) (40,635)
1,000 (2,500) (2,500) -45% -63%
-56% -37% -66% -56%
4,600 (400) 7,000 (300)
9,500 22,970 62% 135% -40% 20% -23%
(1,000) 15,000 (530)
(1,000) 210 1,000 210
Original Budget Variance $ Inc / (Dec)
-33% 60% -6%
200% 14%
-100%
Original Budget Variance % Inc / (Dec)
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
REVENUE IN EXCESS OF EXPENSES
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
TOTAL EXPENSES
District Vehicle Repairs Equipment Rent Expense Postage Expense Shipping Phone/ Cable / Connectivity Exp Pager / Cell Phone Fees/Dues/Subscription Expense Professional Development Fees Repair/Mtc/Warranty Expense Printing Expense Advertising Recruiting Expense Program Meals Utilities Expense Principal - 2016 Series CC Revenue Interest - 2016 Series CC Revenue Total Other Expenses
Description
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
All Other Expenses All Other Expenses All Other Expenses All Other Expenses All Other Expenses All Other Expenses All Other Expenses All Other Expenses 6320 All Other Expenses All Other Expenses All Other Expenses All Other Expenses 6400 All Other Expenses All Other Expenses
Visible
Brushy Creek MUD District - Fiscal Year 2021 Budget
6213 6216 6220 6224 6300 6304 6310 6314 6320 6322 6324 6325 6327 6400 6455 6456
Object Code
Community Center Programs 300
(159,256)
(1,422,302)
84,039
2,383,577 829,331 -
2,286,874
2,506,029
1,500 3,800 3,000 1,200 16,000 2,000 5,000 9,000 1,500 105,000 430,000 141,626 719,626
997,353
37 713 3,749 1,317 3,243 1,218 13,149 4,723 2,126 9,774 144 89 70,191 430,000 70,813 611,284
FY2020 Forecast
63 776 3,066 451 3,157 1,237 27,679 2,222 10,445 12,062 885 79,129 420,000 152,672 713,844
FY2019 Actual
FY2020 Original Budget
0
1,193,168
2,123,061
500 700 4,200 1,300 3,000 1,200 20,000 4,800 5,000 10,000 75,600 430,000 70,813 627,113
FY2021 Budget
1,000 (1,500) (29,400) (70,813) (92,513)
11% -100% -28% -50% -13%
(18,674)
(260,516)
4,000 2,800
25% 140%
-11%
500 (800) 400 1,300
Original Budget Variance $ Inc / (Dec) -53% 11%
Original Budget Variance % Inc / (Dec)
86
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Lodging Lodging Tax Parking Travel Meals Mileage Other Travel Expenses Total Travel
5202 5203 5205 5206 5207
315 315
178 20 64 189 451
13,271 23,520 287 1,449 332 1,201 5,590 1,041 11,489 58,180
15,234 29,584 364 1,835 451 1,408 3,752 99 12,965 65,692
Brushy Creek MUD District - Fiscal Year 2021 Budget
FICA / Medicare Health Vision Insurance Dental Life Disability Insurance Workers Compensation Unemployment Insurance Retirement Total Benefits
5020 5030 5031 5032 5034 5035 5040 5050 5070
3,282,858 173,076 6,704 179,780
TOTAL REVENUE
2,400 4,000 3,059,798 104,660 112,000
FY2020 Forecast
202,116 5,372 207,488
3,359,814
Plan Review Income Inspection Fees Water Service Water Connection Raw Water Sales Wholesale Water Other Income
4110 4112 4201 4211 4240 4245 4500
EXPENSES 5010 Salary 5011 Merit Salary 5012 Overtime Total Payroll
7,650 21,350 3,069,590 4,620 104,251 119,013 33,339
Description
FY2019 Actual
Object Code
Water 500
250 45 150 1,300 1,745
21,690 43,832 65,522
192,463 481 5,837 198,781
2,400 4,000 3,059,798 330 104,660 112,000 3,283,188
FY2020 Original Budget
300 100 300 700
13,958 27,518 350 1,729 365 1,244 5,424 1,180 11,997 63,765
174,302 500 8,155 182,957
3,285,000
105,000 112,000 -
3,000 5,000 3,060,000
FY2021 Budget
(1,045)
(50) (1,000)
-33% -77% -60%
50 (45)
(7,732) (16,314) 350 1,729 365 1,244 5,424 1,180 11,997 (1,757) 20% -100%
-3%
-36% -37%
(18,161) 19 2,318 (15,824)
1,812
0% -9% 4% 40% -8%
600 1,000 202 (330) 340
Original Budget Variance $ Inc / (Dec)
25% 25% 0% -100% 0%
Original Budget Variance % Inc / (Dec)
87
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
3,100 19,140 178,706 5,543 206,489 912 204 3,937 327 849 8,095 52 95 10,951 2,793 28,217
872 242 9,057 1,092 8,643 4,395 19,190 6,164 1,838 51,492
2,206,246
FY2020 Forecast
3,100 14,735 108,221 3,212 129,268
Brushy Creek MUD District - Fiscal Year 2021 Budget
Minor Equipment General Office Supplies Materials & Supplies Chemicals Uniforms Fuel / Oil Major Equipment Computer Supplies Software Copier/Laser Printer Supplies Water Meters Pipes and Components Training Materials T-Shirts/Pins/Etc. Total Supplies
6105 6110 6115 6120 6122 6124 6135 6140 6145 6148 6154 6156 6160 6180
5902
Maintenance Contracts Plumbing Inspections Engineering Fees Contractual/Contract Labor Total Contractual
2011 Ford F150, #1103 - Replace with a F250 and utility bed Total Capital Expenditures
6070 6078 6079 6080
Total Capital Projects
5901
189,456
Description
FY2019 Actual
Object Code
Water 500
4,500 500 12,000 1,500 7,000 4,500 15,000 12,500 250 57,750
1,800 5,200 25,000 10,000 42,000
1,050,000
FY2020 Original Budget -
1,000 250 10,000 300 1,500 8,500 4,500 1,800 15,000 10,000 250 53,100
4,000 15,000 14,500 33,500
40,000 40,000
FY2021 Budget
-8%
-20%
1,500
21%
(4,650)
(2,500)
1,800
(3,500) (250) (2,000) 300
(1,800) (1,200) (10,000) 4,500 (8,500)
40,000
(1,050,000)
Original Budget Variance $ Inc / (Dec)
-78% -50% -17%
-100% -23% -40% 45% -20%
-100%
Original Budget Variance % Inc / (Dec)
88
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
REVENUE IN EXCESS OF EXPENSES
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
TOTAL EXPENSES
Building Maintenance District Vehicle Repairs Equipment Rent Expense Postage Expense Express Mail/Parcel Shipping Phone/ Cable / Connectivity Exp Pager / Cell Phone Utility Bill Expenses Fees/Dues/Subscription Expense Professional Development Fees Lab Fees Repair/Mtc/Warranty Expense Printing Expense Recruiting Expense Utilities Expense Professional Liability Insurance Bad Debt Expense Total Other Expenses
Description
1,298,193
566,043
2,716,815
685,701 1,375,920
1,809 2,717 2,342 9,414 163 2,100 875 11,160 2,114 631 615 1,955 1,296 397 37,589
FY2020 Forecast
(171) 7,141 2,997 9,256 205 1,130 1,190 7,754 892 3,076 40 4,222 1,664 1,540 918 41,853
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
6212 6213 6216 6220 6222 6224 6300 6304 6305 6310 6314 6315 6320 6322 6325 6400 6416 6425
Object Code
Water 500
404,633
2,031,449 2,483,075
1,346,160 200,000 264,137
1,702,961
708,649
421,765
3,500 3,000 10,000 200 2,500 1,000 9,000 2,500 2,500 4,000 2,500 1,500 4,542 1,000 47,742
FY2021 Budget
1,468,258
2,000 3,500 3,000 11,000 60 100 1,000 1,500 10,300 750 2,500 500 10,000 3,500 250 1,500 1,000 52,460
FY2020 Original Budget
(500) (6,000) (1,000) (250)
-100% -60% -29% -100%
-71%
-9%
(1,000) (60) 100 1,500 (500) (1,300) 1,750
-9% -100% 100% 150% -33% -13% 233%
1,358,329
(1,046,493)
(4,718)
4,542
(2,000)
Original Budget Variance $ Inc / (Dec)
-100%
Original Budget Variance % Inc / (Dec)
89
Other Income
4500
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Lodging Lodging Tax Travel Meals Mileage Total Travel
Total Capital Projects
5202 5203 5206 5207
5901
1,014,000
163,386
240,942
1,000 1,000
127 17 92 1,121 1,357
852 852
28,380 50,215 78,595
16,287 26,555 314 1,557 417 1,501 7,314 585 14,098 68,627
251,831 630 7,802 260,263
16,780 28,624 338 1,686 454 1,494 4,146 163 14,172 67,858
25,000
25,000 25,000
FY2020 Original Budget
218,810 1,896 220,706
-
25,000
FY2020 Forecast
226,144 3,423 229,567
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
FICA / Medicare Health Vision Insurance Dental Life Disability Insurance Workers Compensation Unemployment Insurance Retirement Total Benefits
5020 5030 5031 5032 5034 5035 5040 5050 5070
EXPENSES 5010 Salary 5011 Merit Salary 5012 Overtime Total Payroll
TOTAL REVENUE
Description
Object Code
BC Water Facility 525
-
200 100 1,100 1,400
20,185 32,065 414 2,090 528 1,800 7,844 1,707 17,349 83,981
259,062 650 4,799 264,511
25,000
25,000
FY2021 Budget
-100%
10% 40%
7%
-29% -36%
3% 3% -38% 2%
Original Budget Variance % Inc / (Dec)
(1,014,000)
100 100 400
200
(8,195) (18,150) 414 2,090 528 1,800 7,844 1,707 17,349 5,386
7,231 20 (3,003) 4,249
Original Budget Variance $ Inc / (Dec)
90
Brushy Creek Municipal Utility District
9,359 814 23
16,279 2,392 -
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek MUD District - Fiscal Year 2021 Budget
Rent Expense Building Maintenance District Vehicle Repairs Equipment Rent Expense Express Mail/Parcel
6210 6212 6213 6216 6222
7,500 2,000 1,000 -
2,200 1,500 10,000 169,700 8,500 1,500 4,500 7,500 500 718,250 1,000 250 925,400
10,000 1,700 -
2,600 500 3,500 95,000 4,000 1,200 3,500 17,000 200 100 716,000 3,000 846,600
2,601 284 3,509 92,772 3,529 1,160 2,879 1,216 189 58 706,592 2,892 817,679
2,090 808 5,089 89,088 9,105 897 3,829 13,024 3,644 443 620,652 1,255 749,924
Minor Equipment General Office Supplies Materials & Supplies Chemicals Lab Supplies Uniforms Fuel / Oil Major Equipment Software Copier/Laser Printer Supplies Water Purchases Pipes and Components Training Materials Total Supplies
6105 6110 6115 6120 6121 6122 6124 6135 6145 6148 6153 6156 6160
25,000 10,000 80,000 37,000 152,000
10,000 4,000 15,000 200,000 229,000
24,792 2,225 5,117 36,885 69,018
1,927 2,110 4,411 118,080 126,527
Contractual/Network maint/dev. Maintenance Contracts Engineering Fees Contractual/Contract Labor Total Contractual
6040 6070 6079 6080
5902
FY2021 Budget 40,000 35,990 12,000 20,990 25,000 133,980
FY2020 Original Budget
Replace original water softener system (2006) BRA - Add pumps at Stillhouse Hollow WTP - Hach SC200 Controllers Re-build HSP Cla-Valves (4) Replace Recycle Pump control panel / Re-build pump #2 Total Capital Expenditures
FY2020 Forecast
Description
FY2019 Actual
Object Code
BC Water Facility 525
33% -15% -100%
-80% 0% 200% -100% -9%
18% -67% -65% -44% -53% -20% -22% 127%
150% 150% 433% -82% -34%
Original Budget Variance % Inc / (Dec)
2,500 (300) (1,000)
400 (1,000) (6,500) (74,700) (4,500) (300) (1,000) 9,500 200 (400) (2,250) 2,000 (250) (78,800)
15,000 6,000 65,000 (163,000) (77,000)
133,980
Original Budget Variance $ Inc / (Dec)
91
Brushy Creek Municipal Utility District
Shipping Phone/ Cable / Connectivity Exp Pager / Cell Phone Fees/Dues/Subscription Expense TCEQ Regulatory Fees Professional Development Fees Lab Fees
Repair/Mtc/Warranty Expense
Recruiting Expense Utilities Expense Total Other Expenses
6224 6300 6304 6310 6311 6314 6315
6320
6325 6400 1,713,787
1,779,193
(1,688,787)
306,617 373,014
178 287,337 363,524
(1,779,193)
20,229
666 7,363 1,432 48 14,137 741 11,585
FY2020 Forecast
17,313
118 5,013 2,873 153 14,424 1,029 16,415
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
REVENUE IN EXCESS OF EXPENSES
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
TOTAL EXPENSES
Description
Object Code
BC Water Facility 525
(2,870,258)
9,000 25,000
2,879,258
500 309,000 371,000
5,000
5,000 3,000 1,000 20,000 2,000 15,000
FY2020 Original Budget
(1,877,472)
1,902,472
300,000 420,000
65,000
700 9,000 1,500 100 15,000 2,000 15,000
FY2021 Budget
-34%
-100% -3% 13%
1200%
80% -50% -90% -25%
Original Budget Variance % Inc / (Dec)
992,786
(976,786)
(500) (9,000) 49,000
60,000
700 4,000 (1,500) (900) (5,000)
Original Budget Variance $ Inc / (Dec)
92
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Mileage Total Travel
Total Capital Projects
Total Capital Expenditures
Maintenance Contracts Engineering Fees Contractual/Contract Labor Total Contractual
5207
5901
5902
6070 6079 6080
-
-
34,218 12,986 865 48,069
-
-
32,828 22,167 54,995
2,972 5,104 61 317 77 259 2,153 144 2,655 13,742
2,899 5,048 65 341 80 251 781 9 2,569 12,043
Brushy Creek MUD District - Fiscal Year 2021 Budget
FICA / Medicare Health Vision Insurance Dental Life Disability Insurance Workers Compensation Unemployment Insurance Retirement Total Benefits
5020 5030 5031 5032 5034 5035 5040 5050 5070
39,112 2,400 41,512
39,931 1,375 41,306
121,644
122,581
TOTAL REVENUE
EXPENSES 5010 Salary 5011 Merit Salary 5012 Overtime Total Payroll
121,644
122,581
Regulatory Compliance Fee
4301
FY2020 Forecast
Description
FY2019 Actual
Object Code
Regulatory Compliance 540
32,960 10,000 1,000 43,960
25,000
450 450
8,355 14,988 23,343
74,135 185 1,801 76,121
121,644 121,644
FY2020 Original Budget
35,000 25,000 1,500 61,500
-
-
-
7,953 11,400 161 831 208 709 3,090 673 6,835 31,860
100,680 200 3,277 104,157
121,000
121,000
FY2021 Budget
6% 150% 50% 40%
-100%
-100% -100%
36%
-5% -24%
36% 8% 82% 37%
-1%
-0.5%
Original Budget Variance % Inc / (Dec)
2,040 15,000 500 17,540
(25,000)
(450) (450)
(402) (3,588) 161 831 208 709 3,090 673 6,835 8,517
26,545 15 1,476 28,035
(644)
(644)
Original Budget Variance $ Inc / (Dec)
93
Brushy Creek Municipal Utility District
District Vehicle Repairs Postage Expense Shipping Phone/ Cable / Connectivity Exp Pager / Cell Phone Utility Bill Expenses Fees/Dues/Subscription Expense TCEQ Regulatory Fees Professional Development Fees Repair/Mtc/Warranty Expense Printing Expense Utilities Expense Total Other Expenses
6213 6220 6224 6300 6304 6305 6310 6311 6314 6320 6322 6400
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
(11,833)
(4,838)
126,482
1,744 2,767 48 44 123 2,460 36 106 789 5,452 13,569
1,917 2,275 21 43 210 2,215 180 400 660 8,529 5,116 21,565 134,414
185 (14) 4,576 297 4,494 53 9,590
FY2020 Forecast
73 355 3,334 465 278 4,505
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
REVENUE IN EXCESS OF EXPENSES
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
TOTAL EXPENSES
Minor Equipment General Office Supplies Materials & Supplies Uniforms Fuel / Oil Pipes and Components Training Materials T-Shirts/Pins/Etc. Total Supplies
Description
6105 6110 6115 6122 6124 6156 6160 6180
Object Code
Regulatory Compliance 540
(143,030)
25,000 -
289,674
1,000 2,500 50 250 2,500 100 500 100,000 300 5,800 113,000
1,000 2,000 500 2,300 2,000 7,800
FY2020 Original Budget
(119,617)
240,617
1,800 2,800 50 50 300 2,500 100 500 17,000 5,500 30,600
500 2,000 500 2,500 5,000 2,000 12,500
FY2021 Budget
(83,000) (300) (300) (82,400)
-83% -100% -5% -73%
23,414
(49,058)
50
20%
-17%
800 300 50
4,700 80% 12%
60%
200
9%
5,000
(500)
Original Budget Variance $ Inc / (Dec)
-50%
Original Budget Variance % Inc / (Dec)
94
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek MUD District - Fiscal Year 2021 Budget
5902
80,000
Sewer Jet Machine (1999) Third vortex pump for HH1 Install 6" trailer mounted portable pump for transfer at Liberty Walk Lift Total Capital Expenditures
74,029
-
128 128
Total Capital Projects
Mileage Total Travel
5207
13,269 23,519 286 1,448 331 1,199 5,271 11,488 56,811
15,231 29,583 363 1,834 450 1,406 3,752 8 12,963 65,590
5901
FICA / Medicare Health Vision Insurance Dental Life Disability Insurance Workers Compensation Unemployment Insurance Retirement Total Benefits
5020 5030 5031 5032 5034 5035 5040 5050 5070
175,698 6,703 182,401
202,799 5,371 208,171
1,785,516
1,804,755
TOTAL REVENUE
EXPENSES 5010 Salary 5011 Merit Salary 5012 Overtime Total Payroll
1,785,516
1,803,495 1,260
WW Service WW Connections
4203 4213
FY2020 Forecast
Description
FY2019 Actual
Object Code
Waste Water 550
650,000
350 350
20,452 41,236 61,688
181,483 454 5,451 187,388
1,785,516 1,785,516
FY2020 Original Budget
70,000 14,000 15,000 99,000
-
300 300
13,958 27,518 350 1,729 365 1,244 5,424 1,180 11,997 63,765
174,302 500 8,155 182,957
1,785,000
1,785,000 -
FY2021 Budget
-100%
-14% -14%
3%
-32% -33%
-4% 10% 50% -2%
0%
0.0%
Original Budget Variance % Inc / (Dec)
99,000
(650,000)
(50) (50)
(6,494) (13,718) 350 1,729 365 1,244 5,424 1,180 11,997 2,077
(7,181) 46 2,704 (4,430)
(516)
(516)
Original Budget Variance $ Inc / (Dec)
95
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Minor Equipment General Office Supplies Materials & Supplies Chemicals Uniforms Fuel / Oil Major Equipment Pipes and Components Training Materials Total Supplies
Building Maintenance District Vehicle Repairs Equipment Rent Expense Postage Expense Express Mail/Parcel Shipping Phone/ Cable / Connectivity Exp Pager / Cell Phone Utility Bill Expenses Fees/Dues/Subscription Expense TCEQ Regulatory Fees WW Capacity Charges Professional Development Fees
6105 6110 6115 6120 6122 6124 6135 6156 6160
6212 6213 6216 6220 6222 6224 6300 6304 6305 6310 6311 6312 6314
800 32,824 56,661 90,285 536 2,308 487 777 2,122 5,748 11,979 3,467 4,900 9,386 23 44 1,080 875 8,709 68 837,298 479
1,992 2,370 3,036 725 2,985 8,185 19,292 1,288 5,093 7,963 1,323 1,190 7,754 107 650 845,343 -
FY2020 Forecast
22,726 66,884 89,609
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
Contractual/Network maint/dev. Engineering Fees Contractual/Contract Labor Total Contractual
Description
6040 6079 6080
Object Code
Waste Water 550
1,000 2,000 5,000 10,000 150 1,500 1,500 10,000 300 825,300 1,000
2,000 300 5,000 1,600 3,000 4,500 7,500 100 24,000
40,000 143,000 183,000
FY2020 Original Budget
2,000 2,500 10,000 150 1,500 1,000 9,000 300 850,000 1,000
2,000 2,500 3,000 800 3,000 1,500 7,500 100 20,400
40,000 165,000 205,000
FY2021 Budget
(3,000)
(3,600)
-67%
-15%
(1,000) (2,500)
(500) (1,000)
24,700
-100% -50%
-33% -10%
3%
-50%
(300) (2,500) 3,000 (800)
22,000 22,000
Original Budget Variance $ Inc / (Dec)
-100% -50%
15% 12%
Original Budget Variance % Inc / (Dec)
96
Brushy Creek Municipal Utility District
REVENUE IN EXCESS OF EXPENSES
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
TOTAL EXPENSES
Repair/Mtc/Warranty Expense Printing Expense Recruiting Expense Utilities Expense Total Other Expenses
Description
457,843
1,327,673
1,369,420
435,335
19,334 42 20,494 906,197
FY2020 Forecast
20,517 21,372 912,601
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
6320 6322 6325 6400
Object Code
Waste Water 550
321,240
535,000 -
1,999,276
10,000 100 25,000 892,850
FY2020 Original Budget
294,127
1,490,873
20,000 22,000 919,450
FY2021 Budget
(27,113)
(508,403)
(100) (3,000) 26,600
-100% -12% 3% -25%
10,000
Original Budget Variance $ Inc / (Dec)
100%
Original Budget Variance % Inc / (Dec)
97
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Minor Equipment Total Supplies
-
500 500
-
-
-
-
-
-
165 332 4 19 5 16 319 141 1,001
155 337 4 19 5 15 37 129 701
Brushy Creek MUD District - Fiscal Year 2021 Budget
6105
Total Capital Expenditures
5902
Total Contractual
Total Capital Projects
Total Travel
FICA / Medicare Health Vision Insurance Dental Life Disability Insurance Workers Compensation Unemployment Insurance Retirement Total Benefits
5901
5020 5030 5031 5032 5034 5035 5040 5050 5070
2,184 34 2,218
2,075 12 2,087
1,376,209
1,389,507
TOTAL REVENUE
EXPENSES 5010 Salary 5011 Merit Salary 5012 Overtime Total Payroll
1,376,209
1,388,800 707
Solid Waste Services Other Income
FY2020 Forecast
4230 4500
FY2019 Actual
Description
Object Code
Solid Waste 575
-
-
-
-
1,237 581 1,818
10,980 27 385 11,392
1,376,209 1,376,209
FY2020 Original Budget
-
-
-
-
-
329 496 6 29 9 29 128 28 283 1,337
4,305 4,305
1,390,408
1,390,408 -
FY2021 Budget
-26%
-73% -15%
-61% -100% -100% -62%
1%
1.0%
Original Budget Variance % Inc / (Dec)
(908) (85) 6 29 9 29 128 28 283 (481)
(6,675) (27) (385) (7,087)
14,199
14,199
Original Budget Variance $ Inc / (Dec)
98
Brushy Creek Municipal Utility District
REVENUE IN EXCESS OF EXPENSES
87,605
74,761
1,301,448
1,301,902
TOTAL EXPENSES
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
5,335 1,287,858 3 5,039 (5) 1,298,229
FY2020 Forecast
4,550 1,289,633 4,431 1,298,614
FY2019 Actual
Postage Expense Solid Waste Service Pager / Cell Phone Utility Bill Expenses Professional Development Fees Total Other Expenses
Description
Brushy Creek MUD District - Fiscal Year 2021 Budget
6220 6250 6304 6305 6314
Object Code
Solid Waste 575
41,762
-
1,334,447
5,150 1,310,936 5,150 1,321,236
FY2020 Original Budget
228,765
1,161,643
5,000 1,146,000 5,000 1,156,000
FY2021 Budget
(165,236)
-13%
187,003
(172,804)
(150)
-3%
-13%
(150) (164,936)
Original Budget Variance $ Inc / (Dec)
-3% -13%
Original Budget Variance % Inc / (Dec)
99
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Interest - 2019 Refunding Principal - 2015 Series DA Interest - 2015 Series DA Principal - 2015 Refunding Interest - 2015 Refunding Principal - 2009 Refunding Principal - 2005 Bond
105,000 104,556 125,000 107,550 215,000 595,000
120,000 109,950 100,000 106,556 720,000 570,000
68,000 68,000
-
1,500 64,078 55 65,633
Brushy Creek MUD District - Fiscal Year 2021 Budget
6441 6451 6452 6453 6454 6459 6460
Total Supplies
Contractual/Auditing Appraisal Fees Depository Contract Total Contractual
6025 6060 6065
-
-
Total Travel
-
-
-
Total Benefits
Total Capital
-
3,990,827
11,010,178
-
3,004,428 15,022 837,106 4,270 130,000 -
FY2020 Forecast
2,920,306 123 864,119 578 6,605,000 408,548 193,092 18,412
FY2019 Actual
FY2020 Original Budget
Total Payroll
5901
EXPENSES
Property Tax Income Delinquent Property Tax Income Defined Area Tax Defined Area Delinquent Taxes Bond Revenue Bond Premium Revenue Interest Income Other Income
4101 4102 4103 4104 4120 4121 4405 4500
TOTAL REVENUE
Description
Object Code
Debt Service 610
108,575 125,000 53,775 105,000 52,728 215,000 595,000
-
68,000 68,000
-
-
-
3,929,082
3,027,000 15,000 818,082 4,000 65,000 -
FY2021 Budget
19% -49% -16% -51%
108,575 20,000 (50,781) (20,000) (54,822)
(61,745)
(65,000)
-50.0%
-2%
22,572 (22) (19,024) (270)
Variance $ Inc / (Dec)
0.8% -0.1% -2.3% -6.3%
Variance % Inc / (Dec)
100
Brushy Creek Municipal Utility District
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
7,500 85,000 100,000 80,000 175,000 28,588 1,270,000 304,400 85,850 71,808 4,200 17,850 134,170 45,000 15,000 197,775 223,050 4,097,297 4,165,297
40,000 15,000 198,075 224,250 25,445 51,135 68,129 69,050 4,965 6,855,598 11,665,363 11,730,995
TOTAL EXPENSES
FY2020 Forecast
7,075 80,000 95,000 75,000 175,000 45,798 1,215,000 346,925 89,250 78,528 8,138 34,950 136,545
FY2019 Actual
FY2020 Original Budget
Fiscal Agent Fees Principal-2011 Series DA Principal - 2013 Series DA Principal - 2009 Series DA Principal-2011 Refunding Interest - 2009 Refunding Principal - 2010 Refunding Interest - 2010 Refunding Interest - 2011 Series DA Interest - 2011 Refunding Interest - 2009 Series DA Interest - 2005 Issue Interest - 2013 Series DA Interfund Transfers (6482) Principal-2012 Refunding Principal-2013 Refunding Interest-2013 Refunding Interest-2012 Refunding Bond Costs Bond Discount Costs Bond Issue Cost Advisory Fees Bond Issue Cost Counsel Fees Bond Issue Cost Misc Pymt to Escrow Agent Total Other Expenses
Description
Brushy Creek MUD District - Fiscal Year 2021 Budget
6484 6485 6486 6487 6490 6491 6492 6493 6494 6495
6461 6462 6463 6464 6465 6466 6470 6471 6472 6473 6474 6476 6478
Object Code
Debt Service 610
3,324,611
45,000 15,000 98,888 10,575 3,256,611
7,500 85,000 100,000 80,000 175,000 4,300 1,270,000 25,400 3,400 3,360 2,100 8,925 67,085
FY2021 Budget
(840,686)
(840,686)
-21% -20%
(98,887) (212,475)
(279,000) (82,450) (68,448) (2,100) (8,925) (67,085)
-92% -96% -95% -50% -50% -50%
-50% -95%
(24,288)
Variance $ Inc / (Dec)
-85%
Variance % Inc / (Dec)
101
Brushy Creek Municipal Utility District
REVENUE IN EXCESS OF EXPENSES
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
Description
(720,818)
FY2019 Actual
Brushy Creek MUD District - Fiscal Year 2021 Budget
Object Code
Debt Service 610
FY2020 Forecast
(0)
174,470 -
FY2020 Original Budget
-
604,471 -
FY2021 Budget
Variance % Inc / (Dec)
Variance $ Inc / (Dec)
0
102
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek Municipal Utility District
-
60,720
Total Other Expenses
Revision: 2020 Sept 10 Last Rev: 2019 Sept 12
Brushy Creek MUD District - Fiscal Year 2021 Budget
REVENUE IN EXCESS OF EXPENSES
Intrafund - Transfer From Intrafund - Transfer To Interfund - Transfer From Interfund - Transfer To Reserve - Transfer From Reserve - Transfer To
TOTAL EXPENSES
88,954
-
-
Total Supplies
43,899
-
-
43 43
Depository Contract Total Contractual
-
60,678
6065
-
-
Total Travel
Total Capital
-
-
Total Benefits
5901
-
2,095 1,804 40,000 43,899
FY2020 Original Budget
-
TOTAL REVENUE
FY2020 Forecast
Total Payroll
149,674
CRF - Water CRF - WW Interest Income
4202 4204 4405
EXPENSES
43,995 37,884 67,795
Description
FY2019 Actual
Object Code
Capital Fund 620
(1,903,650)
1,927,650
-
-
-
1,927,650
-
-
-
24,000
2,200 1,800 20,000
FY2021 Budget
-45%
5.0% -0.2% -50.0%
Variance % Inc / (Dec)
(1,947,549)
1,927,650
1,927,650
(19,899)
105 (4) (20,000)
Variance $ Inc / (Dec)
103