HomeMy WebLinkAbout08-09-17 TC Agenda PacketThe Regular Meeting of the Town of Westlake Town Council will begin immediately following the conclusion
of the Town Council Work Session but not prior to the posted start time.
Mission Statement
Westlake is a unique community blending preservation of our natural environment and
viewscapes, while serving our residents and businesses with superior municipal and academic
services that are accessible, efficient, cost-effective, and transparent.
Westlake, Texas – “One-of-a-kind community; natural oasis – providing
an exceptional level of service.”
Page 1 of 2
TOWN OF WESTLAKE, TEXAS
Vision Statement
An oasis of natural beauty that maintains our open spaces in balance with distinctive
development, trails, and quality of life amenities amidst an ever expanding urban landscape.
TOWN COUNCIL MEETING
AGENDA
August 9, 2017
1500 Solana Boulevard
Building 7, Suite 7200
1st FLOOR, COUNCIL CHAMBER
WESTLAKE, TX 76262
Workshop Session: 12:00 p.m.
Page 2 of 2
Workshop Session
1. CALL TO ORDER
2. DISCUSSION OF THE PROPOSED MUNICIPAL BUDGET FOR FISCAL YEAR 2017-
2018, FUNDED AND UNFUNDED (UNDER DISCUSSION) PROJECTS CONTAINED
IN THE TOWN’S PROPOSED FIVE (5) YEAR CAPITAL IMPROVEMENT PLAN, AS
WELL AS THE OPERATING BUDGET FOR WESTLAKE ACADEMY FOR FISCAL
YEAR 2017-2018.
3. ADJOURNMENT
ANY ITEM ON THIS POSTED AGENDA COULD BE DISCUSSED IN EXECUTIVE SESSION
AS LONG AS IT IS WITHIN ONE OF THE PERMITTED CATEGORIES UNDER SECTIONS
551.071 THROUGH 551.076 AND SECTION 551.087 OF THE TEXAS GOVERNMENT
CODE.
CERTIFICATION
I certify that the above notice was posted at the Town Hall of the Town of Westlake, 1500 Solana Blvd.,
Building 7, Suite 7200, Westlake, TX 76262, August 3 2017, by 5:00 p.m. under the Open Meetings Act,
Chapter 551 of the Texas Government Code.
_____________________________________
Kelly Edwards, TRMC, Town Secretary
If you plan to attend this public meeting and have a disability that requires special needs, please advise
the Town Secretary 48 hours in advance at 817-490-5710 and reasonable accommodations will be made
to assist you.
The Town of Westlake * 1500 Solana Blvd, Suite 7200 * Westlake, Texas 76262 * www.westlake-tx.org
T OWN OF
W ESTLAKE
P ROPOSED
O PERATING
B UDGET
B UDGET W ORKSHOP
W EDNESDAY
A UGUST 9, 2017
T RANSMITTAL L ETTER
Letter and summary Financials 1
A LL F UNDS O VERVIEW
Program Summary; SLA Form;
Property Tax Analysis; SLA Reports;
2
P ERSONNEL O VERVIEW
Program Summary: SLA Form
Position Summary; 5 Year Forecast
3
G ENERAL F UND
Program Summary and SLA Form 4
E NTERPRISE F UNDS
Program Summary and SLA Form 5
I NTERNAL S ERVICE F UNDS
Program Summary and SLA Form;
Five Year Forecast for Each Fund
6
S PECIAL R EVENUE F UNDS
Program Summary and SLA Form 7
D EBT S ERVICE F UNDS
Program Summary and SLA Form 8
C APITAL P ROJECT F UNDS
Program Summary and SLA Form
Five Year Capital Forecast
9
C APITAL I MPROVEMENTS
Funded and Unfunded Reports 10
W ESTLAKE A CADEMY
Program Summary and SLA Form 11
L ONG T ERM F ORECAST
Forecast Assumptions 12
SECTION 01
Section 1 Executive
Transmittal Letter
August 9th, 2017
Honorable Mayor and Town Council:
On behalf of the Town of Westlake’s Senior Leadership Team, I am pleased to submit the FY 2017-18
Proposed Budget for the Town Council’s consideration. This year’s budget theme is “Maintaining
our Vision in a Sea of Change”. This builds on the FY 2016-17 theme of “Forging Westlake,
Managing the Impact of Growth”.
I. THEME SIGNIFICANCE, OUR TRENDS, & AN OVERVIEW
Because of the current and potential development within our community, it is both an exciting and
challenging time in Westlake! This fiscal year’s theme, as well as last year’s, reflects our
commitment to approaching new growth in a planned and deliberate manner in concert with the
Town’s Comprehensive Plan - Forging Westlake. Our community has experienced significant
growth patterns over the last few years in both commercial and residential sites.
Adhering to the Town’s Vision is the key to Westlake’s success for managing the significant growth.
Staff has developed the theme of “Maintaining our Vision in a Sea of Change” to adequately
reflect our current environment. While growth is occurring, it also presents very clear challenges for
our community if we wish to continue to maintain the elements of Westlake that make it so unique.
These community attributes include our beautiful neighborhoods with top quality residences, strong
aesthetic standards, a top-tier Town owned K-12 charter school, open space preservation,
streetscaping, emphasis on proactive planning, and maintaining our view corridors. The “sea of
change” that surrounds Westlake involves not only our current internal development but also the
current growth and opportunities planned for the State Highway (SH 114) corridor in northeast
Tarrant County and into southern Denton County. The communities that surround us are
undergoing significant development and growth as well which adds to the “sea of change” that
affects Westlake.
The impact of anticipated growth along the SH 114 corridor is described by Mr. Robin McCaffrey
(AIA and APA) of MESA Planning, the firm that was engaged to update the Town’s latest
Comprehensive Plan, Forging Westlake. According to Mr. McCaffrey:
Westlake, with the arrival of the Charles Schwab Corporation project, is crossing
through a portal into the future suggested by the Town’s 2015 Comprehensive Plan.
In conjunction with Fidelity and other financial services in and around Westlake,
Westlake hosts nearly 4 million square feet of an industry type (i.e. financial services),
constituting a significant Industry Cluster. At this scale, the aggregation of a single
industrial code activity is important enough to attract vertical and horizontal
expansion, which further substantiates Westlake’s importance as a financial services
center in the Dallas/ Fort Worth Metroplex. Bringing the above described
importance to the Town’s other advantages of proximity, makes Westlake a singularly
important center for growth and development going forward.
1
Section 1 Executive
Transmittal Letter
These advantages of proximity include:
• Next in the sequence of market advancement: It is an historical phenomenon that
corridor growth markets advance along the corridor at key threshold densities achieved
in the “downstream” growth areas. In Dallas, advancement from one market to
another along a corridor (such as the I-45 corridor) happens when the downstream
growth center attains a density in the range of 4 million square feet. This happened
when Richardson attained such a threshold and the market advanced to Plano. Once
Plano attained the threshold, the market advanced to Allen. Once Allen attained the
threshold, the market advanced to Fairview and McKinney. Now along the SH114
corridor, Southlake is approaching this important threshold, thereby intensifying market
interest in Westlake.
• End of the line for corridor growth: Advancement of the market into Westlake is more
unusual than other corridor conditions because Westlake holds an “end-of-the-line”
relationship to such market advancement. West of Westlake lies Alliance, a massive
industrial based development which extends all the way to I-35W (the easterly boundary
of Fort Worth) at which point the 114/170 corridor ends with limited expectation of
extension. Therefore, Westlake alone will receive most of the market growth within the
114 corridors for the foreseeable future.
• Large land supply in a market of high demand: The end-of-the-line position held by
Westlake, intensifies demand for development land upon a Town with an ample, but
finite, land supply. Therefore, Westlake will have an unusual opportunity to be selective
and the worse thing Westlake can do in the face of that demand is allow lower level
development to corrupt the opportunities this market position affords. The Town should
first understand the true unusual opportunities over which it governs and in the full
understanding of that position consider important questions.
II. UNDERSTANDING “OUR SEA OF CHANGE”
LOCAL CHALLENGES INVOLVING RESIDENTIAL GROWTH
Westlake’s unique position in the SH 114 corridor that Mr. McCaffrey describes makes it imperative
that, as we consider the FY 2017-18 program of municipal services for our Town, we maintain our
vision in this “sea of change” within and around Westlake. Our Town’s vision is:
Westlake is an oasis of natural beauty that maintains our
open spaces in balance with distinctive development,
trails, and quality of life amenities amidst an ever-
expanding urban landscape.
2
Section 1 Executive
Transmittal Letter
What are some of the local challenges within Westlake that have influenced the recommendations
for services and funding levels in the FY 17-18 Budget?
• Westlake’s Permanent Population Growth: This is the portion of our population
considered to be our permanent residents. From the 1990 population of 185 to 2016’s
population of 1,264 represents an increase of 583% equal to 1,079 additional residents.
We will need to continue to monitor and plan for the continued increase in these
numbers considering our Comprehensive Plan’s (Forging Westlake) forecast of
approximately 7.21% annual population growth between now and 2040. This would
bring us to around 7,000 residents.
• Traffic Demands Due to Growth in Westlake and Surrounding Areas: The four (4)
municipalities surrounding Westlake (Keller, Southlake, Trophy Club, and Roanoke) are
projected to have a combined population of 215,000 people by 2040. The growth in
these communities will generate additional traffic that commutes through our Town.
With our projected level of residents (7,000) and the existing zoning entitlements (if
executed) we would expect an estimated 300,000 vehicle trips per day. Local impacts
associated with this level of growth affect our street infrastructure, water and sewer
system capital investment requirements, as well as demand for daily municipal services.
Policies established in Forging Westlake will be essential for addressing this issue via the
Town’s thoroughfare plan as it pertains to development which occurs in the community.
• Balanced Growth to Impact Cost of Municipal Services: Likewise, the ability to fund
municipal services utilizing a cost-effective revenue format requires balanced growth
that provides for commercial development and a diversified tax base, while maintaining
the community’s open space and bucolic atmosphere. At the same time, we must
continue to ensure the policy direction of the Town is focused on growth paying for the
infrastructure for which it creates the demand.
• Housing Start Increases and Maintaining Westlake’s High Quality Residential Housing:
We continue to see strong single family residential construction demand. This has been
demonstrated in Granada Phase 1 as well as in existing subdivisions such as Vaquero,
Paigebrooke, and Terra Bella. Additionally, the infrastructure for three (3) new single
family residential developments, Carlyle Court, Granada Phase 2 and Quail Hollow, has
been completed, accepted by the Town and building permit issuance in those
developments is underway.
Also, the mixed-use development called Entrada continues to progress with
infrastructure construction making significant headway. Entrada’s infrastructure is being
financed with a Town approved Public Improvement District (PID), the bonds for which
are paid back by assessments on development within Entrada. When the infrastructure
is complete, it will add (over time) a wide variety of 322 residential units to Westlake -
ranging from single family homes, to villas, to town homes. Once complete, these four
(4) developments will add approximately 463 new lots to our residential inventory.
3
Section 1 Executive
Transmittal Letter
Our residential construction activity shows a steady increase in building permits for
housing which has occurred since we have emerged from the 20808-09 recession.
Housing starts in Westlake, due to the high value of our homes, add taxable value to our
taxing base; however, this also impacts the demand for municipal services, especially
the Town’s charter school, Westlake Academy.
As the area economy continues to perform well, and Westlake and our surrounding communities
continue to experience commercial development, this will further attract individuals who work for
and own these businesses. In turn, these individuals will need housing. As our housing stock
expands in response to these forces, we will need to manage our distinctive developments to
ensure we maintain our community as an ‘oasis of natural beauty’ as outlined in our Vision
statement, and achieve high-end housing options as identified in the Housing element of Forging
Westlake.
III. UNDERSTANDING “OUR SEA OF CHANGE”
LOCAL CHALLENGES INVOLVING COMMERCIAL GROWTH
Commercial land use growth in Westlake is also a trend which this budget for FY17-18 must respond
to.
The local challenges related to commercial growth include:
• Commercial Development, Economic Development, and Daytime Population Growth:
Because Westlake is the home to major corporate office campuses, its Monday-Friday
daytime population is growing and is conservatively estimated to be approximately
10,000 - 12,000 individuals. These office complexes are comprised of notable corporate
clients that include Deloitte, LLP and Fidelity Investments. Currently, Fidelity has almost
6,000 employees at their Westlake campus, with expansion room for two (2) more office
buildings in addition to their two (2) existing office buildings.
• New Charles Schwab Corporate Campus: The announcement of their regional
corporate campus in 2016 is beginning to come to fruition. Phase 1 will consist of a
500,000-sq. ft. office building and parking garage. Adjacent to the Schwab campus will
be a mixed-use development, which Hillwood Properties will develop near the
intersection of SH170 and SH114. The campus will initially have approximately 1,500-
1,900 employees and should round out with an estimated 5,000 employees when all
phases are complete. Presently, Schwab is well underway in the process of hiring 500
employees for its temporary Roanoke Road location in Westlake.
• Commercial Development in Entrada: The mixed-use development called Entrada,
located at FM1938/Davis Blvd. and SH114, will also create growth in our commercial tax
base. During the past budget year, commercial buildings totaling 55,000 sq. ft. have
been approved by the Town for the development. A CVS Pharmacy is open for
business as well as a Primrose Private School. Other commercial uses include various
retail, restaurants, amphitheater and hotels.
4
Section 1 Executive
Transmittal Letter
• Solana Redevelopment/Reinvestment: The Solana Office Complex, acquired by Equity
Office (Blackstone) approximately two (2) years ago, has seen a resurgence in
occupancy. Equity’s multi-million-dollar investment in the complex to improve its
parking, landscaping and buildings has been a strong positive path for Westlake. The
investment is boosting office occupancy levels with Sabre Corporation expanding their
area presence into Westlake leasing significant office space in Solana. They are also
hiring up to 500 new employees. The municipality has also contributed to the
revitalization efforts by leasing 20,000 sq. ft. of office space for the next 10 years. The
new location in Solana will allow us to all be in one office suite and better serve the
Westlake community.
• Economic Development: The Town has also pursued the ideas advanced in the
Economic Development element of Forging Westlake. That is, where appropriate, to
pursue businesses that ultimately expand the Town’s tax base with high quality office
buildings, and at the same time, compliments our financial services business cluster
which has already been created through our corporate residents of Fidelity and
Deloitte. Further, we pursue the types of businesses interested in high quality office
campus development and creating well-paying positions for employees. With the
Schwab announcement (and the start of construction of the TD AmeriTrade’s complex
in Southlake) we are well on our way to becoming a financial services corridor within the
DFW Metroplex.
While offering economic development incentives for the Schwab project, the tax
abatement provided is in-line with incentives offered in our region, plus the company is
also providing one-time funding for Westlake Academy. Staff will continue to monitor
our corporate stakeholders and attempt to identify avenues to strengthen these
relationships and assist in attracting new corporations to Westlake. The expansion of
commercial development will continue to grow Westlake’s daytime population.
IV. UNDERSTANDING “OUR SEA OF CHANGE”
OTHER LOCAL CHALLENGES INVOLVING STRATEGIC PLANNING,
RESIDENTS FEEDBACK AND WESTLAKE ACADEMY
There are other local challenges involving both financial and physical site planning, strategic
forecasting, residential feedback through our survey instruments and the Town’s public charter
school, Westlake Academy, which have shaped the SY17-18 Budget:
• Westlake’s residential growth impact on the Academy: The number of Westlake
residents who are selecting Westlake Academy as the educational choice for their
students has doubled in the past five years. Resident surveys continually indicate that
the Academy is a strong motivator for our residents to locate in Westlake, and one of
the top three (3) reasons why they plan to remain in our community. For example, the
2017 municipal services survey results indicate 75% of the new residents say enrollment at
Westlake Academy was extremely important/important to their decision to live in the
5
Section 1 Executive
Transmittal Letter
community. With the majority of those residents then listing this as the number one (1)
reason they will remain in Westlake over the next five (5) years.
Planning for Academy growth in the face of
residential development continues to be a
challenge. Wherever possible, the Town has
entered economic development
agreements with residential developers to
provide funding for Westlake Academy
facilities to lessen the impact of their
residential development on the Academy’s
enrollment.
Westlake Academy has experienced steady
enrollment growth from 491 students in SY
2009-10 to a projected 856 in SY 2017-18. The
current increase of student population is a
result of the Phase I expansion efforts on the
Academy campus and our development.
Our growth requires that we carefully
manage our student enrollment processes to
provide adequate space for children of
Westlake residents.
Approximately 39,000 sq. ft. of new facilities
space was opened on campus in SY 14/15.
It was comprised of a secondary classroom
building, field house, and a primary years’
multi-use hall. These buildings increased our capacity and allowed for decompression
of our current school facilities. The lottery waiting list for student admissions from our
secondary boundaries continues to grow from 705 in 2011 to over approximately 2,411
students for this coming school year.
• Continued Public Education Funding Shortfall: State funding of public education was
decreased by the State Legislature in 2011. While it has increased somewhat since then,
the allocation has not kept pace with basic cost increases. And, in the Legislature’s
most recent 2017 session, the per student funding for public education was not
increased for the next biennium. This negatively impacts Westlake since it owns and
operates our public charter school, Westlake Academy, which receives approximately
80% of its operational funding from the State. The municipal government continues to
allocate significant resources to the school to deal with State funding limitations,
maintain high quality educational services, provide for the Academy’s facilities and
support services, as well as preserve space for the children of Westlake residents.
Additionally, the Westlake Academy Foundation (WAF) raises significant operating funds
for the Academy, without which the school could not operate.
6
Section 1 Executive
Transmittal Letter
• Implementation of the Comprehensive Plan: With the 2015 adoption of the Town’s new
Comp Plan, Forging Westlake, several ordinances have been rewritten and new ones
drafted so that the Plan’s recommendations can be implemented. The task of
implementing the changes to the ordinances as well as dealing with the demands of
growth required additional staff in FY16-17. Those staffing costs are carried forward into
the FY17-18 budget given the significant and continued demand on staff time for new
development review and planning required in our high growth environment.
• Pursuit of Infrastructure and Services Reinvestment While Combating Certain Cost
Increases: We must reinvest in maintaining our infrastructure. However, with growth
comes the need to also allocate capital spending in new public buildings and our water
and sewer utility. An example of a key project needed to deal with the Town’s growth, is
a Phase 2 water transmission line to our wholesale water provider. This is a costly project
which will require us to significantly invest in our water system.
• Staffing Levels, Insurance Costs, and Retention: Our infrastructure investment must be
monitored in tandem with the staffing needs to maintain our current service delivery
levels. This includes keeping our compensation/benefit package competitive to attract
and retain excellent employees so we can continue delivering exceptional service. We
have found this to be especially true as it relates to having adequate staffing to deal
with development review and construction. We have balanced all these components
in light of maximizing staff
efficiencies and processes to help
contain large expenditure drivers
such as employee health
insurance.
Customer interactions and our
methodology to deliver services
remains of interest to our residents
and we continue to receive high
marks for our personalized
approach. In early 2017, our
consultant, Chris Tathum with ETC
presented Council with positive
feedback indicating that our staff
team is “setting the standard for service delivery compared to other communities.”
Since 2009, our composite index score for overall satisfaction has increased 21 points.
• Continued Emphasis on Long-range Financial and Strategic Planning: The FY17-18
budget contains an updated Long-Range Financial Forecast which identifies key
revenue and expenditure drivers while assessing historical financial trends and their
potential impact upon the town’s financial stability. The forecast must be monitored and
updated during the budget formulation process, as well as reviewed with the Town
Council as the budget is being prepared. Staff will also continue to produce a quarterly
financial report for the Council that monitors and analyzes trends in the General Fund,
7
Section 1 Executive
Transmittal Letter
Utility Fund, and Visitor Association Fund. The report serves as a valuable tool to assist in
developing a proactive, rather than reactive, approach to our changing financial
trends.
In FY13/14 we began utilizing the Balanced Scorecard framework for our long-term
strategic visioning for the community. Council has identified our vision, approved the
municipal and academic mission statements, along with the performance measures
and reviewed staff identified strategic and departmental initiatives for the coming fiscal
year.
We will utilize this methodology for our organization and update and review on an
annual basis to ensure we are staying current with our communities needs and the
factors influencing our neighboring municipalities.
TOWN OF WESTLAKE TIER ONE STRATEGY MAP
8
Section 1 Executive
Transmittal Letter
SERVICE LEVEL ADJUSTENTS BY PERSPECTIVE
This budget aligns our organizational priorities contained in the Town’s Balanced Score Card by
Perspective, with the resources needed to fund Service Level Adjustments (SLA). This also shows
how these SLA’s impact the BSC’s strategic objectives within each of the BSC perspective. Further,
it connects how each SLA within each Perspective addresses challenges identified in Section II of
this letter.
V. UNDERSTANDING “OUR SEA OF CHANGE”
REGIONAL CHALLENGES THAT IMPACT US
Westlake does not exist in a vacuum. As stated in our Vision, we are surrounded by an “ever
expanding landscape” of urban growth in the DFW area, especially northeast Tarrant and Southern
Denton counties.
PERSPECTIVE & OUTCOME OBJECTIVE ONE
TIME
ON
GOING TOTAL
CUSTOMERS, STUDENTS, STAKEHOLDERS
Outcome Objectives:
• Preserve Desirability & Quality of Life
• Increase CSS Satisfaction
$200,160
69%
$89,564
31%
$289,724
FINANCIAL STEWARDSHIP
Outcome Objectives:
• Increase Financial Capacity & Reserves
• Increase Revenue Streams
$1,422,299
84%
$263,181
16%
$1,685,480
MUNICIPAL AND ACADEMIC OPERATIONS
Outcome Objectives:
• Maximize Efficiencies & Effectiveness
• Encourage Westlake’s Unique Sense of Place
• Increase Transparency, Accessibility & Communications
$176,205
38%
$286,500
62%
$462,705
PEOPLE, FACILITIES AND TECHNOLOGY
Outcome Objectives:
• Attract, Recruit, Retain & Develop the Highest Quality Workforce
• Improve Technology, Facilities & Equipment
• Optimize Planning & Development Capabilities
$7,588,000
96%
$295,075
4%
$7,883,075
9
Section 1 Executive
Transmittal Letter
Regional factors that continue to affect Westlake include:
• DFW Metro Area Employment and Population Growth: Since 1970, the DFW Metro area
has grown by more than 150% - a faster pace than the state and nation. At 9,500
square miles, it is larger in total area than five (5) of our states. With a population of
nearly 6.8 million, it is the fourth largest metropolitan area in the country. Forecasts from
the North Central Texas Council of Governments (NCTCOG) predict employment to
grow, in this 12-county standard metropolitan statistical (SMSA) area, by almost 70% over
the next 30 years. Population growth over this same 30-year period is forecasted by
NCTCOG to be 69%. This regional growth is currently and will continue to impact
Westlake.
• Water Demand: Westlake is in the State’s Region C water planning area which covers
all or a part of 16 North Central Texas counties. The population of Region C is projected
to grow from what was nearly 6.5 million in 2010 to just over 9.9 million in 2040 and
ultimately to over 14.3 million by 2070. Dry-year water demands in Region C are
expected to reach 2.2 million acre-feet per year by 2040, and 2.9 million acre-feet per
year by 2070, largely due to population growth. This increased demand will create a
projected shortage of 1.2 million acre-feet per year by 2070 – which is why planning and
development of new water management strategies are so critical. And, while much of
the recent years’ drought has been alleviated by heavy rain fall in the past 12 months,
increased water demand due to growth requires that we not be complacent about this
regional issue.
• Transportation, Mobility, and Traffic Congestion: With the region’s population and
employment growth, traffic and the associated congestion has also increased. The
recent 2014 amendment to Mobility 2035, the region’s transportation plan, estimates
that between now and 2035, an estimated $395.3 billion is needed to eliminate the
worst levels of congestion in our region. However, this plan only identifies $94.5 billion in
funding for these projects, meaning that congestion will worsen and mobility will be
further impeded over time.
VI. THIS YEAR’S BUDGET THEME AND
UNDERSTANDING WHERE WE HAVE COME FROM
Context is always helpful for understanding where we stand today as a community. Each of our
budgets have reflected a theme of challenges, initiatives, and/or areas of emphasis that the
budget for that fiscal year was intended to address.
10
Section 1 Executive
Transmittal Letter
Those budget themes have been:
FY 2011-12
“INVESTING IN OUR FUTURE”
Ad valorem property tax implemented to stabilize our revenue streams,
provide for financial sustainability, and invest in our infrastructure.
FY 2012-13
“DRIVING SERVICE EXCELLENCE”
Focused on our ability to deliver excellent customer service.
FY 2013-14
“MOVING FORWARD TOGETHER: A GROWING COMMUNITY, A GROWING SCHOOL”
Expansion at the Academy and infrastructure reinvestment
However, things began to change in 2014 as reflected in the budget themes from the last 2 years:
FY 2014-15
“COMMUNITY GROWTH ON THE HORIZON”
Recognizing the growth that was about to occur.
FY 2015-16
“FORGING WESTLAKE: WRITING THE NEXT CHAPTER”
The first fiscal year where we began to utilize our new Comprehensive Plan
(Comp Plan), Forging Westlake, to plan for our growth.
11
Section 1 Executive
Transmittal Letter
FY2016-17
“FORGING WESTLAKE: MANAGING THE IMPACT OF GROWTH”
This fiscal year’s budget emphasized moving from implementing our new
Comp Plan, to inculcating it into our budget with sufficient resources to
properly administer our planning and development review services in a way
that more effectively deals proactively with the impact of growth in all the
Town’s services.
VII. THE IMPORTANCE OF “MAINTAINING OUR VISION”
The trend (of the last two (2) fiscal years) for growth in Westlake shows no sign of abating. Short of a
cooling of the local or national economy (or both), major corporations and their employees
continue to relocate to the DFW metroplex and our SH 114 corridor continues to reflect that
economic growth. This is also true for expansion of existing companies and businesses in the
Metroplex. So, we are now launched into a “sea of change”.
Hence, this year’s budget theme of “Maintaining our Vision in a
Sea of Change”
The question does not appear to be if we will grow, but rather
how we will grow. And, the “how we will grow” is why this
budget theme is so important. Using our community Vision to
guide us will be key to becoming the type of community
Westlake envisions itself to be now and into the future. This vison
permeates our Comprehensive Plan (Forging Westlake) and
likewise, must be reflected in this budget as well.
The growth predicted in Forging Westlake, and identified as early
as the Town’s FY14-15 Budget as being on our horizon, is under
way for the third straight year. Westlake finds itself in the “vortex” of one of DFW’s most desirable
executive housing corridors. With growth now arriving in full force, it becomes imperative that we
not only understand and deal with the changes that are now occurring, but also understand the
impact that future potential growth will have if existing zoning entitlements are utilized.
In the face of these growth challenges, maintaining Westlake’s unique bucolic character,
exceptional quality of life, and distinctive development standards, while at the same time
managing the challenges development creates, is no small task. Growth projections of the
magnitude projected for the next 30 years in Forging Westlake require that we plan, be proactive,
and be prudent in our decision making, all the while striving to continue to offer the high-quality
services Westlake currently enjoys. Our role as a Town government must be to maintain and
advance our position as a premier community. We have moved from planning for growth to
experiencing it and, with that, we must embrace all the challenges and benefits growth creates.
12
Section 1 Executive
Transmittal Letter
There is no doubt that we continue to face challenges – many from the “macro perspective”, i.e.
challenges created by growth throughout the Dallas-Fort Worth metropolitan area. Further
challenges remain from the “micro perspective” for those specific to Westlake. The challenges, first
identified and outlined beginning in the FY15-16 Budget, are still in place, and it appears they will
be with us for the foreseeable future - into FY17-18 and beyond. Planner Robin McCaffrey’s
assessment of the SH 114 corridor growth in Westlake and the reasons for it, described above, are
now coming to pass.
VIII. CLOSING THOUGHTS ON TAKING THE LONG VIEW
AND ITS BENEFITS FOR WESTLAKE
In the FY15-16 Budget transmittal letter, I recounted how almost 25 years ago, Westlake’s governing
body recognized that their Town stood at a crossroads; one of change driven by growth in and
around Westlake. In 2013, while Westlake’s vision had remained much the same, it was recognized
by the Town Council that further growth in Westlake and our surrounding area was pending and
required a proactive approach. The Council’s response was to embark on a two (2) year long
process, with much community input, to formulate an updated Comprehensive Plan (Comp Plan).
In March 2015, the Town Council adopted this newly drafted Comprehensive Plan which is titled
Forging Westlake. The Plan is “mission critical” for the Town to effectively deal with the growth now
occurring in Westlake in a manner that is true to our vision, mission and values as a community.
That vision is:
The FY17-19 budget was formulated to address these challenges within the context of Town Council
financial policies, available resources, our Strategy Map, and a conservative 5-year financial
forecast.
My thanks to our great Leadership Team and Finance Department staff for their dedicated
participation in this journey toward our Vision as we prepared this proposed FY2017-18 Proposed
Budget. Without their unerring belief in that Vision, and their working as a team with the Town
Council, our success in moving towards our Vision would not be possible.
Thomas E. Brymer
Town Manager
Westlake is an oasis of natural beauty that maintains our
open spaces in balance with distinctive development,
trails, and quality of life amenities amidst an ever-
expanding urban landscape.
13
SECTION 02
14
Base Proposed Estimated Proposed
Budget Budget Change Change Budget Budget Change Change
FY 17/18 FY 17/18 Amount Percent FY 16/17 FY 17/18 Amount Percent
1 General Sales Tax On-going 4,550,000 4,950,000 400,000 9%4,550,000 4,950,000 400,000 9%
2 General Sales Tax One-time - - - 0%- - - 0%
3 Property Tax 1,298,965 1,477,116 178,151 14%1,565,510 1,477,116 (88,394) -6%
4 Hotel Tax 837,280 845,000 7,720 1%837,280 845,000 7,720 1%
5 Charge for Services 3,536,775 3,604,470 67,695 2%3,565,755 3,604,470 38,715 1%
6 Beverage Tax 62,500 62,500 - 0%62,500 62,500 - 0%
7 Franchise Fees 960,870 970,485 9,615 1%960,870 970,485 9,615 1%
8 Permits & Fees Other 291,720 291,720 - 0%326,320 291,720 (34,600) -11%
9 Permits & Fees Building 1,289,822 2,137,121 847,299 66%2,356,233 2,137,121 (219,112) -9%
10 Permits & Fees Utility 155,365 155,365 - 0%155,365 155,365 - 0%
11 Fines & Forfeitures 809,880 809,880 - 0%809,880 809,880 - 0%
12 Investment Earnings 99,190 99,190 - 0%109,190 99,190 (10,000) -9%
13 Contributions 750,000 925,000 175,000 23%2,739,565 925,000 (1,814,565) -66%
14 Misc Income 62,020 62,020 - 0%195,080 62,020 (133,060) -68%
15 14,704,387 16,389,867 1,685,480 11%18,233,548 16,389,867 $ (1,843,681)-10%
16 Payroll Salaries 3,540,247 3,762,990 222,743 6%3,373,370 3,762,990 389,620 12%
17 Payroll Insurance Medical/Dental/Life 577,577 588,786 11,209 2%579,109 588,786 9,677 2%
18 Payroll Retirement ICMA/TMRS 459,929 488,484 28,555 6%434,773 488,484 53,711 12%
19 Payroll Taxes Social Security/Medicare 270,758 287,798 17,040 6%252,232 287,798 35,566 14%
20 Payroll Taxes Unemployment/Work Comp 48,089 50,901 2,812 6%46,454 50,901 4,447 10%
21 Payroll Transfer In (940,985) (1,055,775) (114,790) 12%(991,606) (1,055,775) (64,169) 6%
22 Total Payroll and Related 3,955,615 4,123,184 167,569 4%3,694,332 4,123,184 428,852 12%
23 Capital Outlay 51,470 57,470 6,000 12%51,470 57,470 6,000 12%
24 Debt 2,976,034 3,114,664 138,630 5%3,701,794 3,114,664 (587,130) -16%
25 Economic Development 134,640 234,640 100,000 74%134,640 234,640 100,000 74%
26 Insurance 42,375 42,375 - 0%42,375 42,375 - 0%
27 Payroll Transfer Out 940,984 1,055,775 114,791 12%917,147 1,055,775 138,628 15%
28 Repair & Maintenance 366,620 406,115 39,495 11%366,620 406,115 39,495 11%
29 Rent & Utilities 541,234 659,034 117,800 22%543,934 659,034 115,100 21%
30 Services 3,437,690 3,569,174 131,484 4%4,063,555 3,569,174 (494,381) -12%
31 Supplies 222,959 269,534 46,575 21%221,819 269,534 47,715 22%
32 Water Purchases 1,344,600 1,344,600 - 0%1,344,600 1,344,600 - 0%
33 Total Expenditures 10,058,606 10,753,381 694,775 7%11,387,954 10,753,381 (634,573) -6%
34 14,014,221 14,876,565 862,344 6%15,082,286 14,876,565 $ (205,721)-1%
35 Capital Projects CP and UF 2,757,840 10,288,000 7,530,160 273%3,693,515 10,288,000 6,594,485 179%
36 Capital Projects UMR, GMR, VMR 289,000 532,000 243,000 84%1,554,735 532,000 (1,022,735) -66%
37 3,046,840 10,820,000 7,773,160 255%5,248,250 10,820,000 $ 5,571,750 106%
38 Transfers In 3,382,058 4,439,844 1,057,786 31%3,845,404 4,439,844 594,440 15%
39 Other Sources - - - 0%12,732,300 - (12,732,300) -100%
40 Total Other Sources 3,382,058 4,439,844 1,057,786 31%16,577,704 4,439,844 (12,137,860) -73%
41 Transfers Out 3,382,058 4,439,844 1,057,786 31%3,837,069 4,439,844 602,775 16%
42 Other Uses - - - 0%- - - 0%
43 Total Other Uses 3,382,058 4,439,844 1,057,786 31%3,837,069 4,439,844 602,775 16%
44 - - - 0%12,740,635 - $ (12,740,635)-100%
45 (2,356,674)$ (9,306,698)$ (6,950,024)$ 295%10,643,647$ (9,306,698)$ $ (19,950,345)-187%
-
46 FUND BALANCE BEGINNING 25,940,512 25,940,512 0.00 0%15,296,866 25,940,512 10,643,647 70%
47 23,583,838$ 16,633,814$ (6,950,024)$ -29%25,940,512$ 16,633,814$ $ (9,306,698)-36%
TOTAL OPERATING EXPENDITURES
TOTAL OTHER SOURCES & USES
NET CHANGE TO FUND BALANCE
FUND BALANCE ENDING
TOTAL CAPITAL
BASE VS PROPOSED PY ESTIMATED VS CY PROPOSED
TOTAL REVENUES
Wednesday, August 02, 2017
SLA Requests based on these numbers GFOA REquirements based on these numbersALL FUNDS
Program Summary
15
SERVICE LEVEL ADJUSTMENT OVERVIEW
The Town utilizes “service level adjustments” to create an organizational outcome of being fiscal
stewards and tracking our cost increases or decreases. A service level adjustment (SLA) is a request
for any dollars in excess of the baseline/target budget. (FY 2015-16 budget, adjusted for year-end
estimates, less one-time purchases).
There are 2 types of “Service Level Adjustments”.
Maintain
o Same level of service as previous year, but increased due to inflation, etc.
o Activities that require additional resources to maintain the current level of service due to
growth, new equipment, etc. are considered additions to the baseline/target budget
and are included in the “SLA”.
New or expanded level of service.
o All requests for new personnel, programs or equipment that represent a new addition to
the current operation are considered additions to the baseline/target budget and are
included in the new costs.
o Show any revenues or reduction in current expenditures the new or expanded levels of
service will create
o Designate if item represents an “Unfunded Mandate”. An unfunded mandate is a
statute or regulation that requires a state or local government to perform certain
actions, yet provides no money for fulfilling the requirements.
This budget reflects the following service level adjustments.
ONE-TIME
AMOUNT
ON-GOING
AMOUNT
TOTAL
AMOUNT
REVENUES $ 1,422,299 $ 263,181 $ 1,685,480
Percent 84% 16%
EXPENDITURES $ 7,964,365 $ 671,139 $ 7,773,160
percent 92% 8%
NET CHANGE $(6,542,066) $ (407,958) $ 6,950,024
16
TOTAL AMOUNT ONE-TIME COSTS ON-GOING COSTS
General Sales Tax 23.7%$400,000 $400,000 $0
Property Tax 10.6%$178,151 $0 $178,151
Hotel Occupancy Tax 0.5%$7,720 $0 $7,720
Utility Fund Charges for Service 4.0%$67,695 $0 $67,695
Franchise Fees 0.6%$9,615 $0 $9,615
Building Permits and Fees 50.3%$847,299 $847,299 $0
Contributions 10.4%$175,000 $175,000 $0
1,685,480$ 1,422,299$ 263,181$
percentage 84%16%
TOTAL AMOUNT ONE-TIME COSTS ON-GOING COSTS
Payroll Market Adjustment 100.0%$167,569 $0 $167,569
Performance Pay 0.0%$0 $0 $0
Payroll New Employees 0.0%$0 $0 $0
TOTAL 167,569$ -$ 167,569$
percentage 0%100%
Capital Outlay 0.9%$6,000 $6,000 $0
Debt Payments 20.0%$138,630 $0 $138,630
Economic Development 14.4%$100,000 $100,000 $0
Payroll Transfers 16.5%$114,791 $0 $114,791
Repair & Maintenance 5.7%$39,495 $31,380 $8,115
Rent & Utilities 17.0%$117,800 $0 $117,800
Services 18.9%$131,484 $30,700 $100,784
Supplies 6.7%$46,575 $23,125 $23,450
TOTAL 694,775$ 191,205$ 503,570$
percentage 28%72%
Capital Projects 87.2%$7,530,160 $7,530,160 $0
M&R Projects 2.8%$243,000 $243,000 $0
TOTAL 7,773,160$ 7,773,160$ -$
percentage 100%0%
8,635,504$ 7,964,365$ 671,139$
percentage 92%8%
TOTAL AMOUNT ONE-TIME COSTS ON-GOING COSTS
(6,950,024)$ (6,542,066)$ (407,958)$
percentage 94%6%
TOTAL AMOUNT ONE-TIME COSTS ON-GOING COSTS
Customers, Students Stakeholders $289,724 $200,160 $89,564
Financial Stewardship $1,685,480 $1,422,299 $263,181
Municipal/Academic Operations $462,705 $176,205 $286,500
People $295,075 $0 $295,075
Facilities/Technology $7,588,000 $7,588,000 $0
(6,950,024)$ (6,542,066)$ (407,958)$
percentage 94%6%
Revenues
SUMMARY of ALL SLA FUND CHANGES
SERVICE LEVEL ADJUSMENT TYPE
does not include transfers in
NET CHANGE TO FUND BALANCE
NET CHANGE TO FUND BALANCE
SERVICE LEVEL ADJUSMENT TYPE
BY BALANCED SCORECARD PERSPECTIVE
does not include transfers out
BY GENERAL LEDGER ACCOUNT TYPE
Payroll & Related Costs
Operating Expenditures
Capital Projects
TOTAL ALL EXPENDITURES
TOTAL
SERVICE LEVEL ADJUSMENT TYPE
17
BALANCED SCORECARD OVERVIEW
S TRATEGIC T HEMES guide the way the Town does business and helps us determine how we
should invest our time and resources. Themes are also indicators of our “pillars of excellence”
which translates our vision and mission statements into focus areas for our community. The
Council identifies each theme and creates a strategic result (or definition) to assist us in telling
the Westlake story. In the budget process, this allows for increased transparency, clarity, and
accountability, providing the Town a framework for demonstrating results. The continued quality
and success of this community does not happen without the diligent effort of a committed team
of residents, businesses, community leaders, and staff members.
A S TRATEGIC P ERSPECTIVE is a view of the Town’s strategy from a specific vantage point.
The Town’s operational model encompasses our mission, vision, and values statement, and
utilizes the four Perspectives as a framework. As the name implies “a balanced scorecard”
is divided into these perspectives that help ensure that we focus on the components necessary
to achieve our
strategy and aligns
our work with the
vision and mission for
our community.
Our current
perspectives
encompass the
areas of People,
Facilities, and
Technology
(organizational
capacity building), Municipal & Academic Operations (operational processes), Financial
Stewardship (public funds and financial oversight), and Citizen, Students, & Stakeholders
(customer service). All work together to ensure we create a vibrant and responsive community
for our residents.
STRATEGIC THEMES
Natural
Oasis
Exemplary Service &
Governance
High Quality Planning,
Design, & Development
Exemplary Education –
Westlake Academy
Preserve and
maintain a perfect
blend of the
community’s
natural beauty.
We set the standard
by delivering
unparalleled municipal
and educational
services at the lowest
cost.
We are a desirable, well
planned, high-quality
community that is
distinguished by
exemplary design
standards.
Westlake is an
international
educational leader
where each individual’s
potential
is maximized.
SLA COSTS BY PERSPECTIVE
PERSPECTIVE ONE-TIME
COSTS
ON-GOING
COSTS
TOTAL
COSTS
Citizens, Students
& Stakeholders $200,160 $89,564 $289,724
Financial
Stewardship $1,422,299 $263,181 $1,685,480
Municipal &
Academic Operations $176,205 $286,500 $462,705
People, Facilities
and Technology $7,588,000 $295,075 $7,883,075
18
SERVICE LEVEL ADJUSTENTS BY PERSPECTIVE
This budget aligns our organizational priorities contained in the Town’s Balanced Score Card by
Perspective, with the resources needed to fund Service Level Adjustments (SLA).
This shows how these SLA’s impact the BSC’s strategic objectives within each of the BSC
perspectives. Further, it connects how each SLA within each Perspective addresses challenges
identified in the transmittal letter.
PERSPECTIVE & OUTCOME OBJECTIVE ONE
TIME
ON
GOING TOTAL
CUSTOMERS, STUDENTS, STAKEHOLDERS
Outcome Objectives:
• Preserve Desirability & Quality of Life
• Increase CSS Satisfaction
$200,160
69%
$89,564
31%
$289,724
FINANCIAL STEWARDSHIP
Outcome Objectives:
• Increase Financial Capacity & Reserves
• Increase Revenue Streams
$1,422,299
84%
$263,181
16%
$1,685,480
MUNICIPAL AND ACADEMIC OPERATIONS
Outcome Objectives:
• Maximize Efficiencies & Effectiveness
• Encourage Westlake’s Unique Sense of Place
• Increase Transparency, Accessibility & Communications
$176,205
38%
$286,500
62%
$462,705
PEOPLE, FACILITIES AND TECHNOLOGY
Outcome Objectives:
• Attract, Recruit, Retain & Develop the Highest Quality Workforce
• Improve Technology, Facilities & Equipment
• Optimize Planning & Development Capabilities
$7,588,000
96%
$295,075
4%
$7,883,075
19
Based on July report
FY10/11 Actual FY11/12 Actual FY12/13 Actual FY13/14 Actual FY14/15 Actual FY15/16 Actual FY16/17 Estimated FY17/18 Proposed
1,025,535,296$ 1,090,892,532$ 1,209,948,755$ 1,227,858,917$ 1,248,082,317$ 1,274,372,828$ 1,431,173,915$ 1,500,171,790$
amount change 65,357,236$ 119,056,223$ 17,910,162$ 20,223,400$ 26,290,511$ 156,801,087$ 68,997,875$
percent change 6%11%1%2%2%13%5%
$ cumulative chg 65,357,236$ 184,413,459$ 202,323,621$ 222,547,021$ 248,837,532$ 405,638,619$ 474,636,494$
% cumulative chg 6%18%20%22%24%40%46%
Based on "Estimated Net
Taxable Value " July report
FY10/11 Actual FY11/12 Actual FY12/13 Actual FY13/14 Actual FY14/15 Actual FY15/16 Actual FY16/17 Adjusted FY17/18 Proposed
Total Taxable Values 796,958,772$ 937,254,545$ 856,969,250$ 889,054,513$ 920,188,732$ 943,308,794$ 1,124,442,640$ 1,172,624,627$
amount change 140,295,773$ (80,285,295)$ 32,085,263$ 31,134,219$ 23,120,062$ 181,133,846$ 48,181,987$
percent change 18%-9%4%4%3%20%4%
$ cumulative chg 140,295,773$ 60,010,478$ 92,095,741$ 123,229,960$ 146,350,022$ 327,483,868$ 375,665,855$
% cumulative chg 18%8%12%15%18%41%47%
Residential 454,890,952$ 463,311,801$ 473,314,728$ 494,062,920$ 530,229,036$ 565,082,645$ 698,417,863$ 769,281,608$
$ cumulative chg 8,420,849$ 18,423,776$ 39,171,968$ 75,338,084$ 110,191,693$ 243,526,911$ 314,390,656$
% cumulative chg 2%4%9%17%24%54%69%
Commercial 354,362,708$ 398,732,749$ 309,259,502$ 288,880,663$ 288,318,142$ 313,905,939$ 319,566,649$ 334,417,549$
$ cumulative chg 44,370,041$ (45,103,206)$ (65,482,045)$ (66,044,566)$ (40,456,769)$ (34,796,059)$ (19,945,159)$
% cumulative chg 13%-13%-18%-19%-11%-10%-6%
Personal 73,238,159$ 86,462,635$ 102,298,461$ 115,051,251$ 110,305,420$ 86,780,414$ 129,385,534$ 106,304,321$
$ cumulative chg 13,224,476$ 29,060,302$ 41,813,092$ 37,067,261$ 13,542,255$ 56,147,375$ 33,066,162$
% cumulative chg 18%40%57%51%18%77%45%
Ag Properties 263,775$ 263,775$ 269,301$ 274,698$ 257,671$ 246,487$ 219,661$ 216,057$
New Residential 19,299,376$ 14,557,925$ 17,679,732$ 18,340,000$ 28,002,713$ 39,358,755$ 54,909,400$ 29,594,736$
New Commercial 2,905,474$ 63,612,427$ 24,418,346$ 1,148,172$ -$ -$ -$ 12,765,665$
FY10/11 Actual FY11/12 Actual FY12/13 Actual FY13/14 Actual FY14/15 Actual FY15/16 Actual FY16/17 Estimated FY17/18 Proposed
Total Revenue 1,257,246$ 1,442,069$ 1,366,542$ 1,353,355$ 1,432,916$ 1,479,452$ 1,565,510$ 1,596,528$
amount change 184,823$ (75,527)$ (13,187)$ 79,561$ 46,536$ 86,058$ 31,018$
percent change 14.70%-5.24%-0.96%5.88%3.25%5.82%1.98%
New Residential 30,898$ 22,833$ 27,729$ 28,764$ 43,779$ 61,533$ 75,198$ 40,293$
amount change (8,066)$ 4,896$ 1,036$ 15,015$ 17,754$ 13,665$ (34,905)$
percent change -26.10%21.44%3.73%52.20%40.55%22.21%-46.42%
$ cumulative chg 53,731$ 81,460$ 110,224$ 154,004$ 215,537$ 290,736$ 331,029$
New Commercial 4,652$ 99,770$ 38,298$ 1,801$ -$ -$ -$ 17,380$
amount change 95,118$ (61,472)$ (36,497)$ (1,801)$ -$ -$ 17,380$
percent change 2044.82%-61.61%-95.30%-100.00%0.00%0.00%100.00%
$ cumulative chg 104,421$ 142,719$ 144,520$ 144,520$ 144,520$ 144,520$ 161,900$
Thursday, August 03, 2017AD VALOREM PROPERTY TAX
EIGHT YEAR ANALYSIS
Fiscal Year 2017/2018
Homestead exemption 20% Over 65 exemption - $10,000
NET TAXABLE VALUES (these values will not always total due to court appears, ARB, etc)
APPRAISED VALUES
TOTAL TAX REVENUE GENERATED
20
Thursday, August 03, 2017AD VALOREM PROPERTY TAX
EIGHT YEAR ANALYSIS
Fiscal Year 2017/2018
Homestead exemption 20% Over 65 exemption - $10,000
Based on July Report
FY10/11 Actual FY11/12 Actual FY12/13 Actual FY13/14 Actual FY14/15 Actual FY15/16 Actual FY16/17 Adjusted FY17/18 Proposed
Avg Market Value 1,354,987$ 1,359,897$ 1,365,344$ 1,416,737$ 1,472,247$ 1,492,650$ 1,803,855$ 1,815,388$
amount change 4,910$ 5,447$ 51,393$ 55,510$ 20,403$ 311,205$ 11,533$
percent change 0.36%0.40%3.76%3.92%1.44%21.14%0.64%
$ cumulative chg 4,910$ 10,357$ 61,750$ 117,260$ 137,663$ 448,868$ 460,401$
Based on July Report
FY10/11 Actual FY11/12 Actual FY12/13 Actual FY13/14 Actual FY14/15 Actual FY15/16 Actual FY16/17 Adjusted FY17/18 Proposed
Avg Taxable Value 1,152,595$ 1,163,219$ 1,166,338$ 1,203,398$ 1,247,251$ 1,270,576$ 1,425,943$ 1,508,097$
Tax Payment 1,845$ 1,460$ 1,463$ 1,510$ 1,560$ 1,589$ 1,562$ 1,643$
amount change (386)$ 4$ 46$ 50$ 29$ (27)$ 80$
percent change -20.91%0.27%3.18%3.31%1.87%-1.69%5.14%
FY10/11 Actual FY11/12 Actual FY12/13 Actual FY13/14 Actual FY14/15 Actual FY15/16 Actual FY16/17 Estimated FY17/18 Proposed
General Fund 0.15620$ 0.13835$ 0.14197$ 0.13907$ 0.13710$ 0.13947$ 0.12882$ 0.11133$
Debt Service 0.00390 0.01849 0.01487 0.01777 0.01924 0.01687 0.00813 0.02482
TOTAL 0.16010$ 0.15684$ 0.15684$ 0.15684$ 0.15634$ 0.15634$ 0.13695$ 0.13615$
amount change (0.00326) - - (0.00050) - (0.01939) (0.00080)
percent change -2.04%0.00%0.00%-0.32%0.00%-12.40%-0.58%
FY10/11 Actual FY11/12 Actual FY12/13 Actual FY13/14 Actual FY14/15 Actual FY15/16 Actual FY16/17 Estimated FY17/18 Proposed
General Fund 97.56%88.21%90.52%88.67%87.69%89.21%94.06%81.77%
Debt Service 2.44%11.79%9.48%11.33%12.31%10.79%5.94%18.23%
TOTAL 100%100%100%100%100%100%100%100%
FY10/11 Actual FY11/12 Actual FY12/13 Actual FY13/14 Actual FY14/15 Actual FY15/16 Actual FY16/17 Estimated FY17/18 Proposed
General Fund 1,226,689$ 1,271,975$ 1,236,978$ 1,198,373$ 1,256,795$ 1,318,059$ 1,471,000$ 1,305,483$
Debt Service 30,558$ 170,094$ 129,565$ 154,982$ 176,121$ 161,393$ 94,510$ 291,045$
TOTAL 1,257,246$ 1,442,069$ 1,366,542$ 1,353,355$ 1,432,916$ 1,479,452$ 1,565,510$ 1,596,528$
amount change 184,823$ (75,527)$ (13,187)$ 79,561$ 46,536$ 86,058$ 31,018$
percent change 14.70%-5.24%-0.96%5.88%3.25%5.82%1.98%
TAX RATE DISTRIBUTION PERCENT
TAX RATE DISTRIBUTION AMOUNT
AVERAGE MARKET VALUE PER HOME
AD VALOREM TAX PAYMENT ON AVERAGE HOME VALUE (w/homestead exemption)
TAX REVENUE BY FUND TYPE
21
0.00
0.10
0.20
0.30
0.40
0.50
Ad Valorem Tax Comparison per $100
Trophy Club
Southlake
Keller
Roanoke
Grapevine
Haslet
Westlake
PROPERTY TAX OVERVIEW
This Town has assessed a property tax since FY2011-12. The ad valorem tax rate per $100 of
assessed valuation for the Town of Westlake continues to be the lowest for municipalities in the
immediate area.
FY 16/17
Adopted
Tax Rate
FY 17/18
Adopted
Tax Rate
Change
Amount
M&O $ 0.12882 $ 0.11133 $ (0.01749)
I&S $ 0.00813 $ 0.02482 $ 0.01669
$0.13695 $ 0.13615 $ ( 0.00080)
The ad valorem tax rate per $100 of assessed valuation will decrease by $0.00080 for
FY 2017-18 to the adopted tax rate of $.13615 (the calculated effective rate). As a reminder, the
effective tax rate is the total tax rate calculated to raise the same amount of property tax
revenue for the Town from the same properties.
This budget will raise more revenue
from property taxes than last year’s
adopted budget by approximately
$49,640 (does not include any prior
year payments and penalties),
which is a 3.37% increase from last
year's budget.
The Total debt obligation for the Town secured by property taxes for various projects totals
$277,700. This amount covers the series 2011 CO payment for street projects of $115,300 and the
2013 CO payment of $162,400 for Arts & Science Center construction. The debt payment for the
Science Center was originally paid from the Visitor Association Fund.
Based on our July 2017 certified
values, the Town’s “net taxable
value” increased by $48,181,987
over the prior year adjusted
information for FY 16-17.
This is attributable to
• 69% increase in residential
• 6% reduction in commercial
• 45% increase in personal
$0.16010$0.15684$0.15684$0.15684$0.15634$0.15634$0.13695$0.13615FY10/11
Actual
FY11/12
Actual
FY12/13
Actual
FY13/14
Actual
FY14/15
Actual
FY15/16
Actual
FY16/17
Estimated
FY17/18
Proposed
Property Tax Rate per $100 Assessed Valuation
(shown in millions)
22
SECTION 03
23
Base Proposed Estimated Proposed
Budget Budget Change Change Budget Budget Change Change
FY 17/18 FY 17/18 Amount Percent FY 16/17 FY 17/18 Amount Percent
1 Full-Time Regular Wages 3,147,064$ 3,350,543$ 203,479$ 6%2,884,203$ 3,350,543$ 466,340$ 16%
2 Full-Time Overtime Wages 123,087 133,131 10,044 8%110,543 133,131 22,588 20%
3 Part-Time Regular Wages 227,756 231,976 4,220 2%341,644 231,976 (109,668) -32%
4 Premium Pay 13,560 13,560 - 0%8,200 13,560 5,360 65%
5 Auto Allowance 21,100 26,100 5,000 24%21,100 26,100 5,000 24%
6 Cell Phone Allowance 7,680 7,680 - 0%7,680 7,680 - 0%
7 Performance Pay - - - 100%- - - 100%
8 Operating Xfr in for PR Costs (940,985) (1,055,775) (114,790) 12%(991,606) (1,055,775) (64,169) 6%
9 Total Base Wages 2,599,262 2,707,215 107,953 4%2,381,764 2,707,215 325,451 14%
10 Medical Insurace 523,926 534,266 10,340 2%524,847 534,266 9,419 2%
11 Dental Insurance 28,061 28,588 527 2%28,459 28,588 129 0%
12 LTD/AD&D/Life Insurance 25,590 25,932 342 1%25,803 25,932 129 0%
13 Total Insurance 577,577 588,786 11,209 2%579,109 588,786 9,677 2%
14 Social Security 219,495 233,307 13,812 6%204,361 233,307 28,946 14%
15 Medicare 51,263 54,491 3,228 6%47,871 54,491 6,620 14%
16 Unemployment Taxes 8,144 8,656 512 6%8,099 8,656 557 7%
17 Worker's Compensation 39,945 42,245 2,300 6%38,355 42,245 3,890 10%
18 Total Taxes 318,847 338,699 19,852 6%298,686 338,699 40,013 13%
19 TMRS 432,659 461,214 28,555 7%407,503 461,214 53,711 13%
20 ICMA 457 Plan 27,270 27,270 - 0%27,270 27,270 - 0%
21 Total Retirement 459,929 488,484 28,555 6%434,773 488,484 53,711 12%
22
23
24 TOTAL GENERAL FUND IMPACT 3,955,615$ 4,123,184$ 167,569$ 4%3,694,332$ 4,123,184$ $ 428,852 12%
1 Transfer from Visitor Fund to GF 506,432 518,510 12,078 2%480,002 518,510 38,508 8%
2 Transfer from Utility Fund to GF 434,552 482,700 48,148 11%437,145 482,700 45,555 10%
3 TRANSFERS TO GENERAL FUND 940,984$ 1,001,210$ 60,226$ 6%917,147$ 1,001,210$ $ 84,063 9%
PAYROLL & RELATED
SUMMARY
Tuesday, August 01, 2017
General Fund Impact General Fund Impact
BASE VS PROPOSED PY ESTIMATED VS CY PROPOSED
GFOA REquirements based on these numbersSLA Requests based on these numbers
24
/
Revenues, Transfers In & Other Sources:+
Payroll and Related Taxes, Insurance:--=
Expenses, Transfers Out & Other Uses:-
Net Budget Impact:===
Type Recur BSC
1 N P PFT
2 N P PFT
3 N P PFT
4
5 E P PFT
6 E P PFT Payroll Transfer In
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
100-42698-16-000 Payroll Transfers in from CP -$36,380.00 PR Transfer In from CP Fund for Public Works Technician 40%
100-42698-00-000
SHOULD BE ZERO
TOTAL SLA AMOUNT
$90,950.00
Payroll Transfers in from UF -$54,570.00
$0.00
$191,025.00 Market Band AdjustmentsPayroll and Related Costs
SHOULD MATCH AMOUNT NOTED ABOVE
100-41000-10-000
S E R V I C E L E V E L A D J U S T M E N T F O R M
2017 2018Fiscal Year:
FUND INFORMATION
PR Transfer In from Utility Fund and Visitor Fund-$23,456.00
Expense SLA Form - revised 04.20.2017
3
-$167,569.00
-$167,569
ACCOUNTS CAUSING VARIANCE
100-41000-16-000
ACCT DESCRIPTION CHANGE AMT
Fund Type:PAYROLL AND RELATED
ACCOUNT NUMBER
MINUS $3,955,615.00 $4,123,184.00
ADD
MINUS
EQUALS
JUSTIFICATION FOR CHANGE
-$4,123,184.00
BASE BUDGET AMT NEW BUDGET AMT
includes All Departments for Fund 100
100-42698-16-000 PR Transfer In from Utility Fund for Public Works Technician 60%
$167,569.00
Payroll and Related Costs Additional Employee - Project Manager for PW Dept
-$3,955,615.00
BUDGET INFORMATION
REVISION 2 REVISION
CHANGE AMOUNTACCOUNT DESCRIPTION/TYPES
25
Assistant .50
C ITIZENS OF W ESTLAKE
Finance
ASSISTANT TOWN
MANAGER
Fire Chief
Human Resources
Public Works
Planning &
Development
Town Secretary
Supervisor
Deputy Clerk
Marshal
Communications
Information
Technology
WA Coordinator
Police Services
(contracted thru the
City of Keller)
Manager
TOWN MANAGER &
Facilities
Maintenance .50
Lieutenants
(3)
2 Part Time
Court Clerks
Court
Administrator
PT Firefighter
Paramedics 24
HR Generalist
Academic
Acctg Tech II
WA Technician Assistant .50
Advisory Boards
And Committees
Town Attorney
Court Judge
Texas Student Housing
Deputy Chief
Fire Marshal
1 Technician UB Coordinator
Building Inspector
Permit Clerk
P&D Coordinator
Municipal
Acctg Tech II
Intern .50
This organizational chart is a visual depiction of the way work is distributed within the Town of
Westlake. It is also meant to be a tool to help enhance our working relationship with our
customers, students and stake-holders, and to clear channels of communications to better
accomplish our goals and objectives.
Assistant .50
M AYOR AND T OWN C OUNCIL
PW Inspector
Project Manager
WA SUPERINTENDENT
continued on next page
Parks and
Recreation .50
FT Firefighter
Paramedics 9
WA Technician
26
WA SUPERINTENDENT
BOARD OF TRUSTEES
Heads of
Department
Grade Level
Team Leads
SPED Coordinator
Primary Principal
SPED Faculty
and Staff
Primary Assistant
Principal
Primary Curriculum
Coordinator
Primary Counselor
Primary Faculty
and Staff
WESTLAKE ACADEMY
EXECUTIVE DIRECTOR
Librarian
Technology
Coordinator
Secondary
Principal
Secondary Counselor
College Counselor
MYP/DP Faculty
and Staff
Registrar
Administrative
Staff
Secondary Assistant
Principal
Athletic Director
Student Life Coord
Secondary Curriculum
Coordinator
continued from previous page
Administrative
Staff
Executive Director
W.A. Foundation
Assistant
This organizational chart is a visual depiction of the way work is distributed within Westlake Academy
27
Dept Position FY 16/17 Estimated FY 17/18 Projection Change
1 10 GENERAL ADMINISTRATIVE
2 Administrative Assistant 1.00 1.00 -
3 1.00 1.00 -
4
5 11 TOWN MANAGER'S OFFICE
6 Town Manager 1.00 1.00 -
7 Assistant Town Manager 1.00 1.00 -
8 Assistant to the Town Manager 0.50 0.50 -
9 2.50 2.50 -
10
11 12 PLANNING & DEVELOPMENT
12 Planning & Development Director 1.00 1.00 -
13 Development Coordinator 0.50 - (0.50)
14 Intern to P&D Coordinator 0.75 1.00 0.25
15 Zone Enforcement 1.00 - (1.00)
16 Building Inspector 1.00 1.00 -
17 Permit Clerk 1.00 1.00 -
18 5.25 4.00 (1.25)
19
20 13 TOWN SECRETARY'S OFFICE
21 Town Secretary 1.00 1.00 -
22 Administrative Assistant 0.50 0.50 -
23 1.50 1.50 -
24
25 14 FIRE/EMS DEPARTMENT
26 Fire Chief 1.00 1.00 -
27 Deputy Chief/Fire Marshal 1.00 1.00 -
28 Lieutenants 3.00 3.00 -
29 Firefighter/Paramedics FT 9.00 9.00 -
30 Firefighter/Paramedics PT 1.50 1.50 -
31 15.50 15.50 -
32
33 15 MUNICIPAL COURT OFFICE
34 Supervisor 1.00 1.00 -
35 Deputy Clerk 1.00 1.00 -
36 Judge 0.50 0.50 -
37 Marshal 1.00 1.00 -
38 Part-Time Clerk 1 0.50 0.50 -
39 Part-Time Clerk 2 0.50 0.50 -
40 4.50 4.50 -
41
42 16 PUBLIC WORKS OFFICE
43 Public Works Director 1.00 1.00 -
44 Utility Technician 1 1.00 1.00 -
45 Project Manager - 1.00 1.00
46 Utility Billing Coordinator 1.00 1.00 -
47 3.00 4.00 1.00
48
49 17 FACILITIES MAINTENANCE
50 Facilities Maintenance Director 0.50 0.50 -
51 Part-Time Summer Technicians 0.25 0.25 -
52 Part-Time Clerk 0.50 0.50 -
53 1.25 1.25 -
54
55 18 FINANCE OFFICE
56 Finance Director 1.00 1.00 -
57 Finance Supervisor 1.00 1.00 -
58 Management Analyst 0.50 - (0.50)
59 Accounting Tech Municipal 1.00 1.00 -
60 Accounting Tech Academic 1.00 1.00 -
61 4.50 4.00 (0.50)
62
63 19 PARKS & RECREATION OFFICE
64 Parks & Recreation Director 0.50 0.50 -
65 0.50 0.50 -
66
67 20 INFORMATION TECHNOLOGY
68 Information Technology Director 1.00 1.00 -
70 1.00 1.00 -
71
72 21 HUMAN RESOURCES OFFICE
73 Human Resources Director 1.00 1.00 -
74 HR Generalist 1.00 1.00 -
75 2.00 2.00 -
76
77 22 COMMUNICATIONS OFFICE
78 Communications Director 1.00 1.00 -
79 Manager 1.00 1.00 -
82 2.00 2.00 -
83
84 44.50 43.75 (0.75) Grand Total All Positions
Personnel Position Summary
28
Dept
# Department Name FY 16-17
Actual
FY 17-18
Projection
change
FY 18-19
Projection
FY 19-20
Projection
FY 20-21
Projection
FY 21-22
Projection
10 General Administrative 1.00 1.00 - 1.00 1.00 1.00 1.00
11 Administration 2.50 2.50 - 2.50 2.50 2.50 2.50
12 Planning & Development 5.25 4.00 (1.25) 4.00 4.00 4.00 4.00
13 Town Secretary 1.50 1.50 - 1.50 1.50 1.50 1.50
14 Fire & EMS 15.50 15.50 - 15.50 16.50 16.50 16.50
15 Court 4.50 4.50 - 4.50 4.50 4.50 4.50
16 Public Works 3.00 4.00 1.00 4.00 4.00 4.00 4.00
17 Facilities 1.25 1.25 - 1.75 1.75 1.75 1.75
18 Finance 4.50 4.00 (0.50) 4.00 5.00 5.00 5.00
19 Parks and Recreation 0.50 0.50 - 0.50 0.50 0.50 0.50
20 IT Dept 1.00 1.00 - 2.00 2.00 2.00 2.00
21 Human Resources 2.00 2.00 - 2.50 3.00 3.00 3.00
22 Communications 2.00 2.00 - 2.50 3.50 3.50 3.50
TOTAL MUNICIPAL 44.50 43.75 (0.75) 46.25 49.75 49.75 49.75
2.50 3.50 - -
Add PW Project Manager 1.00
Deduct Eddie Edwards (1.00)
Deduct Joel Enders (1.00)
Change Nick to FTE 0.25
TOTAL CHANGE 17/18 (0.75)
Change Kerry to FTE 0.50
Add HR Dept PT Clerk 0.50
Add IT Network Manager 1.00
Add Comm Dept PT Clerk 0.50
TOTAL CHANGE 18/19 2.50
Fire Services Administrator 1.00
Add Finance Acctg Tech 1.00
Change HR clerk to FTE 0.50
Add CVB Position 1.00
TOTAL CHANGE 19/20 3.50
No Changes -
TOTAL CHANGE 20/21 -
No Changes -
TOTAL CHANGE 21/22 -
Recommended 5 Year Staffing Levels
Includes all part-time employees and interns
change amount
29
=>
Year 4 Year 5
$148
$64,640
42220 1.45%$956 $144
$68,576
42210 6.20%$4,088 $4,467
Year 3
$140
$4,337
$5,150 $5,305 $5,464 $5,628
$66,579Base Annual Salary
Social Security
Auto Allowance $5,796
16 - Public Works
BUDGET IMPACT
Year 2
$136
$8,706
$10,650
$543
$157
Fund Balance
41110
$4,739
$153
$9,798
$11,987
$611
$396
$9,513
$176
42310
42111
Description
41640
Account
Total Payroll & Related Taxes & Insurance
Total Expenditures for Employee
Total Expenditure Reductions/Revenue Enhancements
Expense Impact to the budget
Payroll Impact to the budget
SUMMARY OPERATING IMPACT TO THE BUDGET
Expenditure Reductions/Increased Revenues -$90,951
$3,550
$92,830
$0
Computer Equip/Software
Office Supplies
Training
Dues Subscriptions
Uniforms
$104,481
$300
$1,500
$98,165
$0
$102,034$95,380
$0
$103,988
$0
$0$0
$0
per year $250 $250 $250
$3,550 $2,550
$107,031
$2,550
SUMMARY OPERATING IMPACT TO THE BUDGET
$0
$0 $0
$0
$250
$0
per year $0
$9,236
Medicare
$0
$0per year $0
$0
12.82%
$0
$170
TMRS
Medical Insurance
$0
$0
per year
-$90,951
per year $527 $559
per year $165
$2,550
$175
$300
per year $5,000
$62,757
$4,210
Dept:
Year 1
$0
Misc
PR Transfer in from Capital Projects
PR Transfer in from Utility Fund
description
$60,929
$1,500
$0
per year $0 $0
per year -$54,570 $0
$0
$0
$60,929
0
0
2,080
Fire=24 All Other=26Pay Periods:26
Salaried
Full Time
Permanent Fund:General Fund
EMPLOYEE POSITION INFORMATION
Funded By:
Position Type:
DETAILED EXPLANATION FOR THIS PAYROLL CHANGE
Public Works Inspector/Project Manager
PAYROLL SERVICE LEVEL ADJUSTMENT (FY2017/2018)
PAY PERIOD & ANNUAL INFORMATION
Regular Hours:
Premium Hours:
Overtime Hours:
New Position
EMPLOYEE INFORMATION
Hourly Rate:
Premium Rate:
Overtime Rate:
$29.29
Duration:
Status:
Rate Type:
RATE OF PAY
$0
$0
$4,601
Year 6
$11,638
$8,452
$70,633
$8,967
$1,500
42510
42110 per year $10,340 $10,970 $11,299
per year $152 $161 $166
Dental Insurance
Life Insurance
Unemployment
42130 per year $342 $363
46105
45830
46115
46115
43405
$191
$171
$576 $593
$385$374
$180 $186
$90,951
$1,500 $500
$98,484
$500
per year $300 $300
$250
$300 $300
$1,500
$250
$101,438$95,615
$0
$0 $0
$0
$0 $0
$3,550 $2,550
$0 $0
$1,500
1.03
$90,951
per year $0 $0$0
$0
descriptionacct
1.02 $3,550 $2,550
42698 per year -$36,380
acct
42698
46190
$1,500 $500
per year $1,500
$92,830
$500
Additional workload demands due to increased population/customers and regulatory mandates necessitate the addition of an employee.
Manages and Inspects construction activities for compliance with approved plans, contract specifications, and Public Works Department
(PWD) standards; performs onsite inspection of paving, drainage, sewer, water, concrete structures, sidewalks and ADA accessibility
ramps; reports deficiencies to Director. Reviews documents; performs technical review of plans and project specifications. Meets with
contractors to discuss inspection issues and concerns; attends pre-construction meetings. Tests or monitors testing of water and sewer
main lines for environmental compliance. Recommends acceptance of project milestone completions. Monitors job sites, and enforces
compliance to Town policies, procedures, and safety standards. Maintains records and logs of inspection services performed. Reviews
construction, paving and drainage plans for compliance with Town construction standards. Supports the Town operations with regular
and timely attendance at work. Inspect traffic control devices for compliance with plans and the Texas Manual on Uniform Control
Devices. Make safety inspections to note deficiencies for correction. Coordinate with police/fire, utility companies, landowners, etc.
before and during construction. Acts as project field coordinator for contractors, utility companies and Town departments. Researches
utility locations and right of way. Flexibility to perform on-call rotation. Supports the relationship between the Town and stakeholders
by demonstrating courteous and cooperative behavior when interacting with visitors and Town staff; maintains confidentiality of work-
related issues and Town information; performs other duties as required or assigned. Extensive knowledge of state, federal, and local
laws and requirements regarding construction, surveying and safety standards.
42610 Workers Compensation
$352
$104,481
$3,550 $2,550 $2,550
$98,484 $101,438
$60,929
80
0
0
$95,615
BASE ANNUAL PAY:
$0 $0
$0 $0
$0
$2,550
30
SECTION 04
31
Base Proposed Estimated Proposed
Budget Budget Change Change Budget Budget Change Change
FY 17/18 FY 17/18 Amount Percent FY 16/17 FY 17/18 Amount Percent
1 General Sales Tax On-going 3,310,500 3,510,500 200,000 6%3,310,500 3,510,500 200,000 6%
2 General Sales Tax One-time - - - 0%- - - 0%
3 Property Tax RATE ####1,205,205 1,205,205 - 0%1,471,000 1,205,205 (265,795) -18%
4 Hotel Tax - - - 0%- - - 0%
5 Charge for Services - - - 0%- - - 0%
6 Beverage Tax 62,500 62,500 - 0%62,500 62,500 - 0%
7 Franchise Fees 960,870 970,485 9,615 1%960,870 970,485 9,615 1%
8 Permits & Fees Other 285,720 285,720 - 0%310,320 285,720 (24,600) -8%
9 Permits & Fees Building 1,289,822 2,137,121 847,299 66%2,356,233 2,137,121 (219,112) -9%
10 Permits & Fees Utility - - - 0%- - - 0%
11 Fines & Forfeitures 809,880 809,880 - 0%809,880 809,880 - 0%
12 Investment Earnings 36,500 36,500 - 0%36,500 36,500 - 0%
13 Contributions - - - 0%35 - (35) -100%
14 Misc Income 16,930 16,930 - 0%41,150 16,930 (24,220) -59%
15 7,977,927 9,034,841 1,056,914 13%9,358,988 9,034,841 $ (324,147)-3%
16 Payroll Salaries 3,540,247 3,762,990 222,743 6%3,373,370 3,762,990 389,620 12%
17 Payroll Insurance Medical/Dental/Life 577,577 588,786 11,209 2%579,109 588,786 9,677 2%
18 Payroll Retirement ICMA/TMRS 459,929 488,484 28,555 6%434,773 488,484 53,711 12%
19 Payroll Taxes Social Security/Medicare 270,758 287,798 17,040 6%252,232 287,798 35,566 14%
20 Payroll Taxes Unemployment/Work Comp 48,089 50,901 2,812 6%46,454 50,901 4,447 10%
21 Payroll Transfer In (940,985) (1,055,775) (114,790) 12%(991,606) (1,055,775) (64,169) 6%
23 Total Payroll and Related 3,955,615 4,123,184 167,569 4%3,694,332 4,123,184 428,852 12%
37 Capital Outlay 31,690 31,690 - 0%31,690 31,690 - 0%
38 Debt 351,680 351,680 - 0%351,680 351,680 - 0%
39 Economic Development - - - 0%- - - 0%
40 Insurance 33,625 33,625 - 0%33,625 33,625 - 0%
22 Payroll Transfer Out - - - 0%- - - 0%
41 Repair & Maintenance 209,465 242,580 33,115 16%209,465 242,580 33,115 16%
42 Rent & Utilities 360,286 442,746 82,460 23%362,986 442,746 79,760 22%
42 Services 2,165,315 2,229,784 64,469 3%2,309,280 2,229,784 (79,496) -3%
43 Supplies 215,834 252,284 36,450 17%214,694 252,284 37,590 18%
44 Water Purchases - - - 0%- - - 0%
45 Total Expenditures 3,367,895 3,584,389 216,494 6%3,513,420 3,584,389 70,969 2%
46 7,323,510 7,707,573 384,063 5%7,207,752 7,707,573 $ 499,821 7%
47 Capital Projects CP and UF - - - 0%- - - 0%
48 Capital Projects UMR, GMR, VMR - - - 0%- - - 0%
49 - - - 0%- - $ - 0%
50 Transfers In 50,000 50,000 - 0%231,278 50,000 (181,278) -78%
51 Other Sources - - - 0%- - - 0%
52 Total Other Sources 50,000 50,000 - 0%231,278 50,000 (181,278) -78%
52 Transfers Out 1,338,308 2,296,094 957,786 72%1,339,331 2,296,094 956,763 71%
52 Other Uses - - - 0%- - - 0%
52 Total Other Uses 1,338,308 2,296,094 957,786 72%1,339,331 2,296,094 956,763 71%
52 (1,288,308) (2,246,094) (957,786) 74%(1,108,053) (2,246,094) $ (1,138,041)103%
53 (633,891)$ (918,826)$ (284,935) 45%1,043,183$ (918,826)$ (1,962,009)-188%
54 FUND BALANCE BEGINNING 9,596,304 9,596,304 0.00 0%8,553,121 9,596,304 1,043,183 12%
55 8,962,413 8,677,478 (284,935) -3%9,596,304 8,677,478 $ (918,826)-10%
BASE VS PROPOSED PY ESTIMATED VS CY PROPOSED
TOTAL REVENUES
SLA Requests based on these numbers GFOA REquirements based on these numbersGENERAL FUND
Program Summary
Tuesday, August 01, 2017
TOTAL OPERATING EXPENDITURES
TOTAL OTHER SOURCES & USES
NET CHANGE TO FUND BALANCE
FUND BALANCE ENDING
TOTAL CAPITAL
32
Revenues, Transfers In & Other Sources:++=
Payroll and Related Taxes, Insurance:--=
Expenses, Transfers Out & Other Uses:--=
Net Budget Impact:===
Type Recur BSC
1 M P FS
2 M P FS
3 E O FS
4
5 M P FS
6 M P FS
7 M P FS
8 M P FS
9 M P FS
10 M P FS
11
12 E P PFT
13 E P MO
14
22 M P MO
23 M P PFT
24 M P PFT
25 M P PFT
27 M P PFT
28 M O MO
29
32 M P PFT
33 M P PFT Maintain Old Fire Station
34 N P PFT New Town Hall Building
35 M P PFT
38 M P PFT
39 N P PFT
40 M P PFT New Fire Station
41 N P PFT New Town Hall Building
42 M P PFT Maintain Old Fire Station
43 N P PFT New Fire Station
44 N P PFT New Town Hall Building
48 M P PFT Maintain Old Fire Station
49 N P PFT New Fire Station
50 N P PFT New Town Hall Building
53 M P PFT Maintain Old Fire Station
54 N P PFT New Fire Station
55 N P PFT New Town Hall Building
58 M P PFT Load of rock for parking area at Temp. Fire Station
59 M P PFT Replacement at Old Fire Station
60 N P PFT Replacement at New Fire Station
61
68 M P PFT
69 M P PFT
70
78 M P CSS
79
80
81
82 M R FS
83 M P FS
84 M P FS
85
86
$250.00
$250.00
100-43350-17-000*Contract Security Monitoring $500.00
Contract Window Cleaning
Contract Security Monitoring
100-43341-17-000*
100-43341-17-000*Contract Window Cleaning
Contract Security Monitoring
100-43350-17-000*
100-43350-17-000*
Signage for New Town Hall Building
100-46605-14-000 Uniforms
100-45907-17-000 HVAC R&M
14 Fire-EMS
100-46115-14-000 Dues & Subscriptions
$1,000.00
$500.00
$2,915.00
100-43354-17-000*
Repairs at Old Fire Station and pump station
$2,812.00
100-46220-10-000 Electric Service $7,560.00
100-40000-10-000 PR Wages $222,743.00
Contract Security R&M
100-45913-17-000 Fire Station R&M
100-46170-14-000
100-44222-14-000 Communication Services $40.00 FW N. Beach Tower access-improve radio receptionminimize disruptions
100-46150-14-000
Contract Security R&M $500.00100-43354-17-000*
Security
TRANSFERS OUT
100-62580-99-000 Transfer Out to DS Increased to cover revenue shortages for DS payments
100-62600-99-000 Transfer Out to GMR Decreased transfers out to GMR fund
100-62590-99-000 Transfer Out to CP Increased due to Entrada permit and inspection fees
$957,786.00
$193,012.00
-$250,550.00
$1,015,324.00
100-43255-23-000 Keller Police Contract Anticipated increase for Police Services
23 Police Services
$44,424.00
$44,424.00
100-43336-20-000 Contract Services Anticipated 3% cost increase
100-43266-20-000 SW/HW Maintenance Contracts Licensing increase for Microsoft, Adobe, AV/Security software
20 Information Technology
$11,705.00
$13,290.00
$1,585.00
$41,215.00
100-44218-17-000*Lamp/Bulb Supplies $1,125.00
17 Town Facilities
$633.33
$1,200.00
$633.33
$633.33
100-43345-17-000*
100-43345-17-000*
100-44218-17-000*Lamp/Bulb Supplies $1,125.00
Contract Janitorial Service
Contract Janitorial Service
100-44216-17-000 Ground Supplies
100-43345-17-000*Contract Janitorial Service
Contract Sweeping/Washing
100-43341-17-000*Contract Window Cleaning $250.00
$3,200.00
$250.00
100-43339-17-000*Contract Sweeping/Washing $250.00
100-43346-17-000*Contract Building R&M $25,000.00
Contract Building R&M
100-46615-14-000 Medical Supplies LUCAS 3 Chest Compression System (CPR Machine)
$1,000.00
$10,000.00
Payroll - Retirement TMRS and ICMA
100-42200-10-000 PR SSM $17,040.00 Payroll - Social Secutiry and Medicare
100-42300-10-000 PR Retirement $28,555.00
Payroll - Unemployment and Workers Comp
100-42600-10-000 PR Transfer In -$114,790.00 Payroll - Transfers In from Utility Fund and Visitor Fund
SHOULD MATCH AMOUNT NOTED ABOVE
SHOULD BE ZERO
100-44410-10-000 Office Rent $74,900.00 Increased due to new Town Hall building
10 General Services $82,460.00
TOTAL SLA AMOUNT
$23,000.00
Implement Bunker Gear replacement plan
S E R V I C E L E V E L A D J U S T M E N T F O R M
includes All Departments for Fund 100Fund Type:GENERAL FUND
100-32200-12-000
Anticipated increase for franchise fee revenue 100-31800-10-000
TOTAL ALL EXPENDITURES $1,341,849.00
Payroll - Base wages, allowances, overtime,
TOTAL PAYROLL $167,569.00 MARKET BAND ADJUSTMENTS ONLY
100-42400-10-000 PR Taxes
ACCT DESCRIPTION
$1,056,913.85TOTAL REVENUES
Building Permits/Inspections
JUSTIFICATION FOR CHANGE
Payroll - Insurance for Health, Dental and Life
ADD
MINUS
EQUALS
$8,144,869.15
$4,706,203.00
-$516,948.85
$9,201,783.00
-$801,884.00
MINUS $3,955,615.00 $4,123,184.00 $167,569.00
Increase based on most recent building forecast$847,298.85
Franchise Fee Revenues
100-31310-10-000 General Sales Tax
ACCOUNT NUMBER
100-42000-10-000 PR Insurance
$5,880,483.00
$1,056,913.85
$1,174,280.00
-$284,935.15
-$284,935
$0.00
$9,615.00
CHANGE AMT
$35,105.00
$200,000.00 No Anticipated increase for Sales Tax revenues
Increased due to new Town Hall building
$11,209.00
Maintain cost of service for security
Licenses/Registrations $500.00 Maintain cost of service for licenses/registrations
$565.00
OPERATING EXPENDITURES $216,494.00
$500.00
$500.00
100-43346-17-000*
Maintain cost of service for NEFDA
Any repairs not under warranty
100-43339-17-000*
Control board replacement at temp fire station, pump station
33
SECTION 05
34
Base Proposed Estimated Proposed
Budget Budget Change Change Budget Budget Change Change
FY 17/18 FY 17/18 Amount Percent FY 16/17 FY 17/18 Amount Percent
1 General Sales Tax On-going - - - 0%- - - 0%
2 General Sales Tax One-time - - - 0%- - - 0%
3 Property Tax - - - 0%- - - 0%
4 Hotel Tax - - - 0%- - - 0%
5 Charge for Services 3,536,775 3,604,470 67,695 2%3,565,755 3,604,470 38,715 1%
6 Beverage Tax - - - 0%- - - 0%
7 Franchise Fees - - - 0%- - - 0%
8 Permits & Fees Other - - - 0%- - - 0%
9 Permits & Fees Building - - - 0%- - - 0%
10 Permits & Fees Utility 155,365 155,365 - 0%155,365 155,365 - 0%
11 Fines & Forfeitures - - - 0%- - - 0%
12 Investment Earnings 12,520 12,520 - 0%12,520 12,520 - 0%
13 Contributions - - - 0%50,000 - (50,000) -100%
14 Misc Income 35,780 35,780 - 0%35,780 35,780 - 0%
15 3,740,440 3,808,135 67,695 2%3,819,420 3,808,135 $ (11,285)-0.3%
16 Payroll Salaries - - - 0%- - - 0%
17 Payroll Insurance Medical/Dental/Life - - - 0%- - - 0%
18 Payroll Retirement ICMA/TMRS - - - 0%- - - 0%
19 Payroll Taxes Social Security/Medicare - - - 0%- - - 0%
20 Payroll Taxes Unemployment/Work Comp - - - 0%- - - 0%
21 Payroll Transfer In - - - 0%- - - 0%
23 Total Payroll and Related - - - 0%- - - 0%
37 Capital Outlay 19,780 25,780 6,000 30%19,780 25,780 6,000 30%
38 Debt 267,460 267,014 (446) 0%1,155,620 267,014 (888,606) -77%
39 Economic Development - - - 0%- - - 0%
40 Insurance 8,750 8,750 - 0%8,750 8,750 - 0%
22 Payroll Transfer Out 434,552 482,700 48,148 11%437,145 482,700 45,555 10%
41 Repair & Maintenance 157,155 163,535 6,380 4%157,155 163,535 6,380 4%
42 Rent & Utilities 138,829 156,499 17,670 13%138,829 156,499 17,670 13%
42 Services 1,003,515 1,017,930 14,415 1%1,003,515 1,017,930 14,415 1%
43 Supplies 7,125 7,250 125 2%7,125 7,250 125 2%
44 Water Purchases 1,344,600 1,344,600 - 0%1,344,600 1,344,600 - 0%
45 Total Expenditures 3,381,766 3,474,058 92,292 3%4,272,519 3,474,058 (798,461) -19%
46 3,381,766 3,474,058 92,292 3%4,272,519 3,474,058 $ (798,461)-19%
47 Capital Projects CP and UF - - - 0%- - - 0%
48 Capital Projects UMR, GMR, VMR - - - 0%- - - 0%
49 - - - 0%- - $ - 0%
50 Transfers In - - - 0%- - - 0%
51 Other Sources - - - 0%- - - 0%
52 Total Other Sources - - - 0%- - - 0%
52 Transfers Out 156,250 156,250 - 0%278,593 156,250 (122,343) -44%
52 Other Uses - - - 0%- - - 0%
52 Total Other Uses 156,250 156,250 - 0%278,593 156,250 (122,343) -44%
52 (156,250) (156,250) - 0%(278,593) (156,250) $ 122,343 -44%
53 202,424$ 177,827$ (24,597) -12%(731,692)$ 177,827$ 909,519 -124%
-
54 FUND BALANCE BEGINNING 548,372 548,372 0.00 0%1,280,064 548,372 (731,692) -57%
55 750,796 726,199 (24,597) -3%548,372 726,199 $ 177,827 32%
BASE VS PROPOSED PY ESTIMATED VS CY PROPOSED
TOTAL REVENUES
SLA Requests based on these numbers GFOA REquirements based on these numbersENTERPRISE FUNDS
Program Summary
Tuesday, August 01, 2017
TOTAL OPERATING EXPENDITURES
TOTAL OTHER SOURCES & USES
NET CHANGE TO FUND BALANCE
FUND BALANCE ENDING
TOTAL CAPITAL
35
/
Revenues, Transfers In & Other Sources:++=
Payroll and Related Taxes, Insurance:--=
Expenses, Transfers Out & Other Uses:--=
Net Budget Impact:===
Type Recur BSC
1 M P FS
2
3
4
5
6
7
8
9
10
11 E P MO
12 E P MO
13 E P MO
14 E P MO
15 E P MO
16 E P MO
17
18
18 M P PFT
19 E P PFT
20 E P PFT
21 E P PFT
22 E P PFT
23 E O PFT
24 E O PFT
24 M P PFT
25
26
27
28
29
30
31
32
33
255-44306-00-000 Grounds R&M $1,775.00 Funded by $200K donation in FY17 - section markers
$0.00 $0.00 $0.00
includes 255 Cemetary Fund and 500 Utility Fund
Computer Eqpmt/Software $125.00
JUSTIFICATION FOR CHANGE
255-43215-00-000 Engineering $12,000.00 Funded by $200K donation in FY17
255-43340-00-000 Irrigation R&M $4,605.00 Funded by $200K donation in FY17
No Revenue Increases $67,695.00
CHANGE AMT
MINUS
EQUALS
$3,740,440.00
$3,538,016.00
$202,424.00
$3,808,135.00
$177,827.00
MINUS
ACCOUNTS CAUSING VARIANCE
$3,630,308.00
$67,695.00
$92,292.00
-$24,597.00
ADD
500-46150-16-000 Licenses/Registrations $700.00 Water and Wastewater license and renewal for 3 employees
500-46220-10-000 Electric Service $1,620.00 Increased Electric cost due to new Town Hall building
Utility Fund $67,587.00
500-48810-16-000 DS Principal - Keller OHS -$2.00 Decreased debt service costs for Keller Overhead Storage
500-48850-16-000 DS Interest - GS Tank
Expense SLA Form - revised 04.20.2017
-$24,597
SHOULD BE ZERO
Cemetary Fund $24,705.00
$0.00
500-47413-16-000 Computer Hardware/Software $1,000.00 Computer, equipment and software for new employee
500-44410-10-000
$0.00
-$444.00 Decreased debt service costs for Ground Storage Tank
500-46115-16-000 Dues & Subscriptions $515.00 ICMA and TCMA dues
TOTAL PAYROLL $0.00
Increased Rent cost due to new Town Hall building
500-42699-10-000 Operating Xfr Out for PR Costs $48,148.00 Increased costs for payroll transfers out to General Fund
255-43348-00-000 Contract Landscaping $1,200.00 Funded by $200K donation in FY17
255-47417-00-000 Land Improvements $5,000.00 Funded by $200,000 donation in 2017 - Clean north fence line
Funded by $200K donation in FY17255-43405-00-000
$0.00
Anticipated 1% increase for new residents
$0.00
TOTAL SLA AMOUNT
Utility Fund
ACCOUNT NUMBER
Office Rent $16,050.00
$67,695.00TOTAL REVENUES
$0.00
SHOULD MATCH AMOUNT NOTED ABOVE
TOTAL PROJECTS $92,292.00
$0.00
$0.00
S E R V I C E L E V E L A D J U S T M E N T F O R M
2017 2018Fiscal Year:
FUND INFORMATION
BASE BUDGET AMT NEW BUDGET AMT
BUDGET INFORMATION
REVISION 2 REVISION
CHANGE AMOUNTACCOUNT DESCRIPTION/TYPES
3
Fund Type:ENTERPRISE FUNDS
Cemetary Fund No Revenue Increases $0.00
ACCT DESCRIPTION
36
SECTION 06
37
Base Proposed Estimated Proposed
Budget Budget Change Change Budget Budget Change Change
FY 17/18 FY 17/18 Amount Percent FY 16/17 FY 17/18 Amount Percent
1 General Sales Tax On-going - - - 0%- - - 0%
2 General Sales Tax One-time - - - 0%- - - 0%
3 Property Tax - - - 0%- - - 0%
4 Hotel Tax - - - 0%- - - 0%
5 Charge for Services - - - 0%- - - 0%
6 Beverage Tax - - - 0%- - - 0%
7 Franchise Fees - - - 0%- - - 0%
8 Permits & Fees Other 6,000 6,000 - 0%6,000 6,000 - 0%
9 Permits & Fees Building - - - 0%- - - 0%
10 Permits & Fees Utility - - - 0%- - - 0%
11 Fines & Forfeitures - - - 0%- - - 0%
12 Investment Earnings 5,810 5,810 - 0%5,810 5,810 - 0%
13 Contributions - - - 0%118,660 - (118,660) -100%
14 Misc Income - - - 0%22,130 - (22,130) -100%
15 11,810 11,810 - 0%152,600 11,810 $ (140,790)-92%
16 Payroll Salaries - - - 0%- - - 0%
17 Payroll Insurance Medical/Dental/Life - - - 0%- - - 0%
18 Payroll Retirement ICMA/TMRS - - - 0%- - - 0%
19 Payroll Taxes Social Security/Medicare - - - 0%- - - 0%
20 Payroll Taxes Unemployment/Work Comp - - - 0%- - - 0%
21 Payroll Transfer In - - - 0%- - - 0%
23 Total Payroll and Related - - - 0%- - - 0%
37 Capital Outlay - - - 0%- - - 0%
38 Debt - - - 0%- - - 0%
39 Economic Development - - - 0%- - - 0%
40 Insurance - - - 0%- - - 0%
22 Payroll Transfer Out - - - 0%- - - 0%
41 Repair & Maintenance - - - 0%- - - 0%
42 Rent & Utilities - - - 0%- - - 0%
42 Services - - - 0%- - - 0%
43 Supplies - - - 0%- - - 0%
44 Water Purchases - - - 0%- - - 0%
45 Total Expenditures - - - 0%- - - 0%
46 - - - 0%- - $ - 0%
47 Capital Projects CP and UF - - - 0%- - - 0%
48 Capital Projects UMR, GMR, VMR 289,000 532,000 243,000 84%1,554,735 532,000 (1,022,735) -66%
49 289,000 532,000 243,000 84%1,554,735 532,000 $ (1,022,735)-66%
50 Transfers In 656,800 406,250 (250,550) -38%667,220 406,250 (260,970) -39%
51 Other Sources - - - 0%- - - 0%
52 Total Other Sources 656,800 406,250 (250,550) -38%667,220 406,250 (260,970) -39%
52 Transfers Out - - - 0%- - - 0%
52 Other Uses - - - 0%- - - 0%
52 Total Other Uses - - - 0%- - - 0%
52 656,800 406,250 (250,550) -38%667,220 406,250 $ (260,970)-39%
53 379,610$ (113,940)$ (493,550) -130%(734,915)$ (113,940)$ 620,975 84%
-
54 FUND BALANCE BEGINNING 394,367 394,367 0.00 0%1,129,282 394,367 (734,915) -65%
55 773,977 280,427 (493,550) -64%394,367 280,427 $ (113,940)-29%
TOTAL OPERATING EXPENDITURES
NET OTHER SOURCES & USES
NET CHANGE TO FUND BALANCE
FUND BALANCE ENDING
TOTAL CAPITAL
Tuesday, August 01, 2017
BASE VS PROPOSED PY ESTIMATED VS CY PROPOSED
TOTAL REVENUES
SLA Requests based on these numbers GFOA Requirements based on these numbersINTERNAL SERVICE FUNDS
Program Summary
38
/
Revenues, Transfers In & Other Sources:++=
Payroll and Related Taxes, Insurance:--=
Expenses, Transfers Out & Other Uses:--=
Net Budget Impact:===
Type Recur BSC
1 M P FS
2
3 E O MO
4 E O MO
5 E O MO
6 E O MO
7 E O MO
8
9
10 M P PFT
11 M P PFT
12 M P PFT
13 M P PFT
14 M P PFT
15 M P PFT
16 M P PFT
17 M P PFT
18
19
20 M O PFT
21 M O PFT
22
M O PFT
23
M P PFT
24
25
26 M P PFT
27 M P PFT
28 M P PFT
29 M P PFT
30 M P PFT
31
32
33
SHOULD BE ZERO
additional security components as part of Phase 2 of network equipment
replacement at WA
600-45909-16-000-000046 Solana Pavement Repair $0.00 Repairs to sections Solana pavements that are breaking up
$100,000.00PUBLIC WORKS
600-43405-20-000-000033 Server Replacements $0.00 current cost to replace a single server in the event of failure
TOTAL SLA AMOUNT
600-43405-20-000-000020 Servers & Network Storage $15,000.00 need for additional primary and backup data storage
SHOULD MATCH AMOUNT NOTED ABOVE
$15,000.00
600-45305-20-000-000028 Phone System/Peripheal Devices $0.00
current phone system end-of-life announced in Feb 2017;
Phase 1 of 3 (17/18) will replace the phone backend;
Phases 2 and 3 (18/19; 19/20) will replace phones
TOTAL PROJECTS
WA-Heater Boilers $4,000.00 Anticipated Westlake Academy Repairs & Maintenance
600-44303-16-000-000048 SH 114 Repainting $0.00 Repainting of retaining walls & railing on service road bridges
-$250,550.00TOTAL REVENUES
additional large volume pump to function as a back-up
S E R V I C E L E V E L A D J U S T M E N T F O R M
2017 2018Fiscal Year:
FUND INFORMATION
BASE BUDGET AMT NEW BUDGET AMT
BUDGET INFORMATION
REVISION 2 REVISION
CHANGE AMOUNTACCOUNT DESCRIPTION/TYPES
505 & 510 Utility M&R Fund; 600 & 605 General M&R FundFund Type:INTERNAL SERVICE FUNDS
Expense SLA Form - revised 04.20.2017
3
$532,000.00
-$250,550.00
$243,000.00
-$493,550.00
ADD
MINUS
EQUALS
$668,610.00
$289,000.00
$379,610.00
$418,060.00
-$113,940.00
-$493,550
600-43405-20-000-000027 Network Equipment $0.00
ACCOUNTS CAUSING VARIANCE
$0.00
ACADEMY FACILITIES $103,000.00
INFORMATION TECHNOLOGY
$243,000.00
Replacement chairs for new Town Hall Courtroom
600-43340-26-000-000007 Town-Irrigation R&M $0.00 Irrigation at old and new Fire Station
600-43343-26-000-000052 Town-Open Space Improvements $0.00 Clean open space at Roanoke Road and Kirkwood Creek
510-44123-16-000-000005 Pump Station Equipment
WA-Carpet/VCT Flooring
600-44306-26-000-000015 Town-Parking Lot $0.00 New gravel in parking area at old fire station
600-45908-26-000-000010 Town-Env Bldg UG light/water $0.00 Upgrade to LED lighting in new Town Hall building
$100,000.00
JUSTIFICATION FOR CHANGE
600-44303-16-000-000041 Wyck Hill Pavement Resurface $0.00 This project will provide for the resurfacing of Wyck Hill streets
600-44303-16-000-000047 FM 1938 Pavement Repairs $0.00 Repairs to section of enhanced concrete that are breaking up
Increase transfers into GMR from GF to build fund balance600-52510-88-000
600-43347-17-000-000032
600-44306-17-000-000009
600-45908-17-000-000017
TOWN FACILITIES $25,000.00
MINUS $0.00 $0.00
600-47415-26-000-000045 Town-Furniture/Interior Bldg $25,000.00
ACCT DESCRIPTION
Transfer in from GF -$250,550.00
CHANGE AMT
Anticipated Westlake Academy Repairs & Maintenance
Anticipated Westlake Academy Repairs & Maintenance
Anticipated Westlake Academy Repairs & Maintenance
Anticipated Westlake Academy Repairs & Maintenance
Anticipated Westlake Academy Repairs & Maintenance
Anticipated Westlake Academy Repairs & Maintenance
Anticipated Westlake Academy Repairs & Maintenance
600-43347-17-000-000024
600-43347-17-000-000026
$0.00
ACCOUNT NUMBER
600-44219-17-000-000029
600-45908-17-000-000008
600-45909-17-000-000013
WA-15 Ton Split HVAC System $9,000.00
WA-AC ton/7.5 ton server room $9,000.00
WA-HVAC System Replacement $9,000.00
WA-Ext Envrnmt Imprvmts Irrig $9,000.00
WA-Refurbish Classrooms $9,000.00
$14,000.00
WA-Roof Repairs $40,000.00
39
5 Year Projection
FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22
ESTIMATED PROPOSED Budget Budget Budget Budget
Description Account Number BUDGET BUDGET
1 REVENUES AND OTHER SOURCES
2 Interest Earned 505-36110-16-000 35 35 - - - -
3 Sales of Surplus 505-34144-16-000 8,650 - - - - -
4 Transfer In from UF 505-52550-88-000 16,670 6,250 6,250 6,250 6,250 6,250
5 Fund 505 total 25,355 6,285 6,250 6,250 6,250 6,250
6 Interest Income 510-36110-00-000 3,400 3,400 3,400 3,400 3,400 3,400
7 Transfer in from UF 510-52550-88-000 100,000 100,000 25,000 25,000 25,000 25,000
8 Fund 510 total 103,400 103,400 28,400 28,400 28,400 28,400
9 Interest Income 600-36110-00-000 1,550 1,550 1,750 1,750 1,750 1,750
10 Contributions 600-33700-14-101 500 - - - - -
11 Firefighter Equipment Fees 600-34008-14-000 6,000 6,000 6,000 6,000 6,000 6,000
12 Transfer in from GF 600-52510-88-000 550,550 300,000 300,000 200,000 200,000 200,000
13 Fund 600 total 558,600 307,550 307,750 207,750 207,750 207,750
14 Interest Earned 605-36110-00-000 825 825 200 200 200 -
15 Contributions 605-33700-10-000 118,160 - - 150,000 - -
16 Insurance Proceeds 605-39100-14-000 8,715 - - - - -
17 Sales of Surplus Fire Dept 605-34144-14-000 4,765 - - - - -
20 Transfer In from GF 605-52510-88-000 - - 125,000 110,000 - -
21 Fund 605 total 132,465 825 125,200 260,200 200 -
22 TOTAL REVENUES AND OTHER SOURCES 819,820$ 418,060$ 467,600$ 502,600$ 242,600$ 242,400$
25
26
27 MAINTENANCE/REPLACEMENT PROJECTS
28 Motor Vehicle 505-47410-16-000 - - - - 50,000 -
29 Fund 505 total - - - - 50,000 -
30 Sewer Easement Cleaning Machin 510-44114-16-000-000014 45,000 45,000 - - - -
31 Repaint Ground Storage Tank 510-44119-16-000-000015 100,000 100,000 - - - -
32 Pump Station Equipment 510-44123-16-000-000005 - 100,000 - - - -
33 Fund 510 total 145,000 245,000 - - - -
34 WA-Irrigation System 600-43340-17-000-000007 15,000 9,000 5,000 15,000 5,000 5,000
35 WA-15 Ton Split HVAC System 600-43347-17-000-000024 11,250 9,000 15,000 10,000 25,000 25,000
36 WA-2 Ton Roof Top Units 600-43347-17-000-000025 13,200 9,000 5,000 15,000 10,000 10,000
37 WA-AC ton/7.5 ton server room 600-43347-17-000-000026 5,000 9,000 5,000 - 20,000 20,000
38 WA-HVAC System Replacement 600-43347-17-000-000032 10,000 9,000 10,000 - 5,000 5,000
39 WA-Update Security System 600-43354-17-000-000018 25,000 4,000 25,000 5,000 8,000 8,000
40 WA-Update Security Cameras 600-43354-17-000-000019 15,000 9,000 - 2,000 12,000 12,000
41 WA-Heater Boilers 600-44219-17-000-000029 - 4,000 5,000 - 25,000 25,000
42 WA-Painting/Cloth Wall R&M 600-44220-17-000-000012 11,250 9,000 8,000 10,000 8,000 8,000
43 WA-Ext Envrnmt Imprvmts Irrig 600-44306-17-000-000009 7,500 9,000 10,000 - 12,000 12,000
44 WA-Parking Lot 600-44306-17-000-000015 5,000 - 25,000 - - -
45 WA-Plumbing Repair/Replacement 600-45904-17-000-000036 4,965 4,000 9,000 15,000 5,000 5,000
46 WA-Carpet/VCT Flooring 600-45908-17-000-000008 30,000 29,000 15,000 15,000 15,000 15,000
47 WA-Envrnmt Bldg UG light/water 600-45908-17-000-000010 30,000 4,000 10,000 - 5,000 5,000
48 WA-Refurbish Classrooms 600-45908-17-000-000017 15,000 24,000 30,000 35,000 25,000 25,000
49 WA-Interior Building R&M 600-45908-17-000-000023 15,000 7,000 15,000 10,000 15,000 15,000
50 WA-Exterior Paint & Wood R&M 600-45909-17-000-000011 11,000 7,000 4,000 4,000 8,000 8,000
51 WA-Roof Repairs 600-45909-17-000-000013 50,000 45,000 9,000 15,000 5,000 5,000
52 WA-Furniture/Interior Bldg 600-47415-17-000-000045 5,400 - - - - -
53 Trail Repairs and Maintenance 600-43343-19-000-000014 12,000 12,000 10,000 10,000 10,000 10,000
54 Park Repairs and Maintenance 600-45911-19-000-000043 10,000 20,000 10,000 10,000 10,000 10,000
55 Servers & Network Storage 600-43405-20-000-000020 25,000 15,000 40,000 15,000 15,000 15,000
56 Network Printers/Peripheal Dev 600-43405-20-000-000021 7,500 5,000 5,000 5,000 5,000 5,000
57 Network Equipment 600-43405-20-000-000027 75,000 - 115,000 25,000 25,000 25,000
58 Server Replacements 600-43405-20-000-000033 12,710 5,000 20,000 12,500 100,000 12,500
59 Phone System/Peripheal Devices 600-45305-20-000-000028 5,000 5,000 65,000 10,000 10,000 10,000
60 Town-Irrigation R&M 600-43340-26-000-000007 - - 5,000 5,000 5,000 5,000
61 Town-HVAC System Replacement 600-43347-26-000-000032 - - 5,000 5,000 5,000 5,000
62 Town-Heater 600-44219-26-000-000029 - - 3,000 3,000 3,000 3,000
63 Town-Parking Lot 600-44306-26-000-000015 - - 4,000 4,000 4,000 4,000
64 Town-Env Bldg UG light/water 600-45908-26-000-000010 - - 10,000 10,000 10,000 10,000
65 Town-Furniture/Interior Bldg 600-47415-26-000-000045 809,800 25,000 - - - -
66 Fund 600 total 1,236,575 287,000 497,000 265,500 410,000 322,500
------------------------------Projection------------------------------
Maintenance and Replacement Funds
40
5 Year Projection
FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22
ESTIMATED PROPOSED Budget Budget Budget Budget
Description Account Number BUDGET BUDGET ------------------------------Projection------------------------------
Maintenance and Replacement Funds
67 Motor Vehicle (WA Buses 605-47410-10-000 118,160 - - 150,000 - -
68 Motor Vehicle F ire Dept 605-47410-14-000 55,000 - 250,000 60,000 - -
69 Motor Vehicle Facilities 605-47410-17-000 - - - 50,000 - -
70 Fund 605 total 173,160 - 250,000 260,000 - -
71 GRAND TOTAL PROJECTS 1,554,735$ 532,000$ 747,000$ 525,500$ 460,000$ 322,500$
74
75
76 NET CHANGE TO FUND BALANCE (734,915)$ (113,940)$ (279,400)$ (22,900)$ (217,400)$ (80,100)$
77
78
79 BEGINNING FUND BALANCEC 1,129,282 394,367 280,427 1,027 (21,873) (239,273)
80 ENDING FUND BALANCE 394,367$ 280,427$ 1,027$ (21,873)$ (239,273)$ (319,373)$
41
SECTION 07
42
Base Proposed Estimated Proposed
Budget Budget Change Change Budget Budget Change Change
FY 17/18 FY 17/18 Amount Percent FY 16/17 FY 17/18 Amount Percent
1 General Sales Tax On-going 1,239,500 1,439,500 200,000 16%1,239,500 1,439,500 200,000 16%
2 General Sales Tax One-time - - - 0%- - - 0%
3 Property Tax - - - 0%- - - 0%
4 Hotel Tax 837,280 845,000 7,720 1%837,280 845,000 7,720 1%
5 Charge for Services - - - 0%- - - 0%
6 Beverage Tax - - - 0%- - - 0%
7 Franchise Fees - - - 0%- - - 0%
8 Permits & Fees Other - - - 0%10,000 - (10,000) -100%
9 Permits & Fees Building - - - 0%- - - 0%
10 Permits & Fees Utility - - - 0%- - - 0%
11 Fines & Forfeitures - - - 0%- - - 0%
12 Investment Earnings 3,960 3,960 - 0%3,960 3,960 - 0%
13 Contributions 750,000 750,000 - 0%870,000 750,000 (120,000) -14%
14 Misc Income 9,310 9,310 - 0%96,020 9,310 (86,710) -90%
15 2,840,050 3,047,770 207,720 7%3,056,760 3,047,770 $ (8,990)-0.3%
16 Payroll Salaries - - - 0%- - - 0%
17 Payroll Insurance Medical/Dental/Life - - - 0%- - - 0%
18 Payroll Retirement ICMA/TMRS - - - 0%- - - 0%
19 Payroll Taxes Social Security/Medicare - - - 0%- - - 0%
20 Payroll Taxes Unemployment/Work Comp - - - 0%- - - 0%
21 Payroll Transfer In - - - 0%- - - 0%
23 Total Payroll and Related - - - 0%- - - 0%
37 Capital Outlay - - - 0%- - - 0%
38 Debt - - - 0%- - - 0%
39 Economic Development 134,640 234,640 100,000 74%134,640 234,640 100,000 74%
40 Insurance - - - 0%- - - 0%
22 Payroll Transfer Out 506,432 518,510 12,078 2%480,002 518,510 38,508 8%
41 Repair & Maintenance - - - 0%- - - 0%
42 Rent & Utilities 42,119 59,789 17,670 42%42,119 59,789 17,670 42%
42 Services 268,860 321,460 52,600 20%749,160 321,460 (427,700) -57%
43 Supplies - 10,000 10,000 100%- 10,000 10,000 100%
44 Water Purchases - - - 0%- - - 0%
45 Total Expenditures 952,051 1,144,399 192,348 20%1,405,921 1,144,399 (261,522) -19%
46 952,051 1,144,399 192,348 20%1,405,921 1,144,399 $ (261,522)-19%
47 Capital Projects CP and UF - - - 0%- - - 0%
48 Capital Projects UMR, GMR, VMR - - - 0%- - - 0%
49 - - - 0%- - $ - 0%
50 Transfers In - - - 0%- - - 0%
51 Other Sources - - - 0%- - - 0%
52 Total Other Sources - - - 0%- - - 0%
52 Transfers Out 1,887,500 1,987,500 100,000 5%2,219,145 1,987,500 (231,645) -10%
52 Other Uses - - - 0%- - - 0%
52 Total Other Uses 1,887,500 1,987,500 100,000 5%2,219,145 1,987,500 (231,645) -10%
52 (1,887,500) (1,987,500) (100,000) 5%(2,219,145) (1,987,500) $ 231,645 -10%
53 499$ (84,129)$ (84,628) -16960%(568,306)$ (84,129)$ 484,177 -85%
-
54 FUND BALANCE BEGINNING 1,177,335 1,177,335 0.00 0%1,745,641 1,177,335 (568,306) -33%
55 1,177,834 1,093,206 (84,628) -7%1,177,335 1,093,206 $ (84,129)-7%
BASE VS PROPOSED PY ESTIMATED VS CY PROPOSED
TOTAL REVENUES
SLA Requests based on these numbers GFOA Requirements based on these numbersSPECIAL REVENUE FUNDS
Program Summary
Tuesday, August 01, 2017
TOTAL OPERATING EXPENDITURES
NET OTHER SOURCES & USES
NET CHANGE TO FUND BALANCE
FUND BALANCE ENDING
TOTAL CAPITAL
43
/
Revenues, Transfers In & Other Sources:++=
Payroll and Related Taxes, Insurance:--=
Expenses, Transfers Out & Other Uses:--=
Net Budget Impact:===
Type Recur BSC
1 M P FS
2
3
4
5
6
7
8
9
10 M P PFT
11
12
13
14
15
16
17 E P MAO
1 M P CSS
18 N O FS
19 E P PFT
20 M P FS
21 E O CSS
22 E P CSS
23
24
25
26
27
28
29
30
31
32
33
$0.00
SHOULD MATCH AMOUNT NOTED ABOVE
SHOULD BE ZERO
$0.00
$0.00
220-44410-10-000 Office Rent $16,050.00 Increased Rent cost due to new Town Hall Building
$0.00
TOTAL PAYROLL $12,078.00
$0.00
increased transfers out to debt service fund200-62580-99-000 Transfer Out to DS from 4B $100,000.00
JUSTIFICATION FOR CHANGE
220-46220-10-000 Electric Service $1,620.00 Increased Electric cost due to new Town Hall Building
220-43531-22-000 Marketing & Promotions $2,500.00 Marketing and Promotions for Trails
ACCT DESCRIPTION
Marriott Hotel Occupancy Tax $7,720.00
CHANGE AMT
S E R V I C E L E V E L A D J U S T M E N T F O R M
2017 2018Fiscal Year:
FUND INFORMATION
BASE BUDGET AMT NEW BUDGET AMT
BUDGET INFORMATION
REVISION 2 REVISION
CHANGE AMOUNTACCOUNT DESCRIPTION/TYPES
3
ADD
MINUS
EQUALS
$2,840,050.00
$2,839,551.00
$499.00
$3,047,770.00
-$84,129.00
ACCOUNTS CAUSING VARIANCE
Increase anticipated Hotel Occupancy Tax
$0.00
No Change
220-31320-10-001
ACCOUNT NUMBER
$0.00
$107,720.00TOTAL REVENUES
$0.00
220-43336-22-000
220-43336-22-000
Expense SLA Form - revised 04.20.2017
$0.00
$0.00
$0.00
$0.00
$3,131,899.00
$207,720.00
$292,348.00
-$84,628.00
-$84,628
$0.00
TOTAL SLA AMOUNT
$0.00
Contract Services $35,100.00 Photo shoot; mktg collateral; retainage; branding; logo & tagline
Contract Services $15,000.00 Marketing Videography (Video)
$0.00
Sales Tax Revenue $100,000.00 Increase anticipated Sales Tax due to Schwab
$0.00
TOTAL PROJECTS $180,270.00
$0.00
$0.00
220-42699-10-000 Operating Xfr Out for PR Costs $12,078.00
$0.00
220-45610-10-001 Community Tree Lighting $10,000.00 2017 budget was removed while reviewing; add back in for 2018
MINUS $0.00 $0.00 $0.00
200 ED 4B Fund; 210 ED Fund; 215 PID Fund; 220 Visitor Fund ; 418 LS FundFund Type:SPECIAL REVENUE FUNDS
$0.00
$0.00
$0.00
210-31310-00-000
44
SECTION 08
45
Base Proposed Estimated Proposed
Budget Budget Change Change Budget Budget Change Change
FY 17/18 FY 17/18 Amount Percent FY 16/17 FY 17/18 Amount Percent
1 General Sales Tax On-going - - - 0%- - - 0%
2 General Sales Tax One-time - - - 0%- - - 0%
3 Property Tax 93,760 271,911 178,151 190%94,510 271,911 177,401 188%
4 Hotel Tax - - - 0%- - - 0%
5 Charge for Services - - - 0%- - - 0%
6 Beverage Tax - - - 0%- - - 0%
7 Franchise Fees - - - 0%- - - 0%
8 Permits & Fees Other - - - 0%- - - 0%
9 Permits & Fees Building - - - 0%- - - 0%
10 Permits & Fees Utility - - - 0%- - - 0%
11 Fines & Forfeitures - - - 0%- - - 0%
12 Investment Earnings - - - 0%- - - 0%
13 Contributions - - - 0%- - - 0%
14 Misc Income - - - 0%- - - 0%
15 93,760 271,911 178,151 190%94,510 271,911 $ 177,401 188%
16 Payroll Salaries - - - 0%- - - 0%
17 Payroll Insurance Medical/Dental/Life - - - 0%- - - 0%
18 Payroll Retirement ICMA/TMRS - - - 0%- - - 0%
19 Payroll Taxes Social Security/Medicare - - - 0%- - - 0%
20 Payroll Taxes Unemployment/Work Comp - - - 0%- - - 0%
21 Payroll Transfer In - - - 0%- - - 0%
23 Total Payroll and Related - - - 0%- - - 0%
37 Capital Outlay - - - 0%- - - 0%
38 Debt 2,356,894 2,495,970 139,076 6%2,194,494 2,495,970 301,476 14%
39 Economic Development - - - 0%- - - 0%
40 Insurance - - - 0%- - - 0%
22 Payroll Transfer Out - - - 0%- - - 0%
41 Repair & Maintenance - - - 0%- - - 0%
42 Rent & Utilities - - - 0%- - - 0%
42 Services - - - 0%1,600 - (1,600) -100%
43 Supplies - - - 0%- - - 0%
44 Water Purchases - - - 0%- - - 0%
45 Total Expenditures 2,356,894 2,495,970 139,076 6%2,196,094 2,495,970 299,876 14%
46 2,356,894 2,495,970 139,076 6%2,196,094 2,495,970 $ 299,876 14%
47 Capital Projects CP and UF - - - 0%- - - 0%
48 Capital Projects UMR, GMR, VMR - - - 0%- - - 0%
49 - - - 0%- - $ - 0%
50 Transfers In 1,925,258 2,218,270 293,012 15%2,076,906 2,218,270 141,364 7%
51 Other Sources - - - 0%- - - 0%
52 Total Other Sources 1,925,258 2,218,270 293,012 15%2,076,906 2,218,270 141,364 7%
52 Transfers Out - - - 0%- - - 0%
52 Other Uses - - - 0%- - - 0%
52 Total Other Uses - - - 0%- - - 0%
52 1,925,258 2,218,270 293,012 15%2,076,906 2,218,270 $ 141,364 7%
53 (337,876)$ (5,789)$ 332,087 -98%(24,678)$ (5,789)$ 18,889 77%
-
54 FUND BALANCE BEGINNING 5,789 5,789 0.00 0%30,468 5,789 (24,678) -81%
55 (332,087) 0 332,087 -100%5,789 0 $ (5,789)-100%
should be zero should be zero
Tuesday, August 01, 2017
TOTAL OPERATING EXPENDITURES
NET OTHER SOURCES & USES
NET CHANGE TO FUND BALANCE
FUND BALANCE ENDING
TOTAL CAPITAL
BASE VS PROPOSED PY ESTIMATED VS CY PROPOSED
TOTAL REVENUES
SLA Requests based on these numbers GFOA REquirements based on these numbersDEBT SERVICE FUNDS
Program Summary
46
/
Revenues, Transfers In & Other Sources:++=
Payroll and Related Taxes, Insurance:--=
Expenses, Transfers Out & Other Uses:--=
Net Budget Impact:===
Type Recur BSC
1 E P FS
2 M P FS
3
4
5
6
7
8
9
10
11 M P FS
12 M P FS
13 M P FS
14 M P FS
15 M P FS
16 M P FS
17 M P FS
18
19
20 M P FS
21 M P FS
22 M P FS
23 M P FS
24 M P FS
25
26
27
28
29
30
31
32
33
300-48850-00-013 DS Interest - 2013 GORB
301-48850-00-011 DS Interest - 2011 CO -$7,310.88
-$89,098.33
SHOULD MATCH AMOUNT NOTED ABOVE
SHOULD BE ZERO
300-48850-00-014 DS Interest - 2014 GORB -$180.00
TOTAL DS PRINCIPAL
TOTAL SLA AMOUNT
300-48850-00-012 DS Interest - 2013 CO -$3,558.00
300-48850-00-010
$100,000.00
$471,163.00
300-48850-00-007 DS Interest - 2007 GORB -$17,002.00
Property Tax CY 2011 CO $178,151.00
CHANGE AMT
TOTAL REVENUES
TOTAL DS INTEREST $228,174.12
-$39,950.00
DS Interest - 2011 GORB -$14,625.00
S E R V I C E L E V E L A D J U S T M E N T F O R M
2017 2018Fiscal Year:
FUND INFORMATION
BASE BUDGET AMT NEW BUDGET AMT
BUDGET INFORMATION
REVISION 2 REVISION
CHANGE AMOUNTACCOUNT DESCRIPTION/TYPES
300-48840-00-017 DS Principal - 2017 CO -$3,098.33
Expense SLA Form - revised 04.20.2017
3
$2,495,970.00
$471,163.00
$139,075.79
$332,087.21
$2,019,018.00
$2,356,894.21
-$337,876.21
$2,490,181.00
-$5,789.00
$332,087
ACCOUNTS CAUSING VARIANCE
300-52560-88-000
$0.00
Increased anticipated Property Taxes (2011 CO)
Transfer in from 4B
JUSTIFICATION FOR CHANGE
TOTAL PROJECTS $139,075.79
300-48840-00-007 DS Principal - 2007 GORB -$385,000.00
301-48840-00-011 DS Principal - 2011 CO $4,000.00
300-48840-00-010 DS Principal - 2011 GORB $425,000.00
300-48840-00-013 DS Principal - 2013 GORB -$130,000.00
300-48850-00-017 DS Interest - 2017 CO $310,800.00
MINUS $0.00 $0.00 $0.00
includes 300 DS Revenue supported; 301 DS Tax supportedFund Type:DEBT SERVICE FUNDS
300-52510-88-000 Transfer in from GF $193,012.00 Increased transfers into Debt Service from the General Fund
301-31315-00-011
ACCOUNT NUMBER
ADD
MINUS
EQUALS
Increased transfers into Debt Service from the 4B
ACCT DESCRIPTION
47
SECTION 09
48
Base Proposed Estimated Proposed
Budget Budget Change Change Budget Budget Change Change
FY 17/18 FY 17/18 Amount Percent FY 16/17 FY 17/18 Amount Percent
1 General Sales Tax On-going - - - 0%- - - 0%
2 General Sales Tax One-time - - - 0%- - - 0%
3 Property Tax - - - 0%- - - 0%
4 Hotel Tax - - - 0%- - - 0%
5 Charge for Services - - - 0%- - - 0%
6 Beverage Tax - - - 0%- - - 0%
7 Franchise Fees - - - 0%- - - 0%
8 Permits & Fees Other - - - 0%- - - 0%
9 Permits & Fees Building - - - 0%- - - 0%
10 Permits & Fees Utility - - - 0%- - - 0%
11 Fines & Forfeitures - - - 0%- - - 0%
12 Investment Earnings 40,400 40,400 - 0%50,400 40,400 (10,000) -20%
13 Contributions - 175,000 175,000 100%1,700,870 175,000 (1,525,870) -90%
14 Misc Income - - - 0%- - - 0%
15 40,400 215,400 175,000 433%1,751,270 215,400 $ (1,535,870)-88%
variance 0 0 0 0%0 0 0 0%
16 Payroll Salaries - - - 0%- - - 0%
17 Payroll Insurance Medical/Dental/Life - - - 0%- - - 0%
18 Payroll Retirement ICMA/TMRS - - - 0%- - - 0%
19 Payroll Taxes Social Security/Medicare - - - 0%- - - 0%
20 Payroll Taxes Unemployment/Work Comp - - - 0%- - - 0%
21 Payroll Transfer In - - - 0%- - - 0%
23 Total Payroll and Related - - - 0%- - - 0%
37 Capital Outlay - - - 0%- - - 0%
38 Debt - - - 0%- - - 0%
39 Economic Development - - - 0%- - - 0%
40 Insurance - - - 0%- - - 0%
22 Payroll Transfer Out - 54,565 54,565 100%- 54,565 54,565 100%
41 Repair & Maintenance - - - 0%- - - 0%
42 Rent & Utilities - - - 0%- - - 0%
42 Services - - - 0%- - - 0%
43 Supplies - - - 0%- - - 0%
44 Water Purchases - - - 0%- - - 0%
45 Total Expenditures - 54,565 54,565 100%- 54,565 54,565 100%
46 - 54,565 54,565 100%- 54,565 $ 54,565 100%
47 Capital Projects CP and UF 2,757,840 10,288,000 7,530,160 273%3,693,515 10,288,000 6,594,485 179%
48 Capital Projects UMR, GMR, VMR - - - 0%- - - 0%
49 2,757,840 10,288,000 7,530,160 273%3,693,515 10,288,000 $ 6,594,485 179%
50 Transfers In 750,000 1,765,324 1,015,324 135%870,000 1,765,324 895,324 103%
51 Other Sources - - - 0%12,732,300 - (12,732,300) -100%
52 Total Other Sources 750,000 1,765,324 1,015,324 135%13,602,300 1,765,324 (11,836,976) -87%
52 Transfers Out - - - 0%- - - 0%
52 Other Uses - - - 0%- - - 0%
52 Total Other Uses - - - 0%- - - 0%
52 750,000 1,765,324 1,015,324 135%13,602,300 1,765,324 $ (11,836,976)-87%
53 (1,967,440)$ (8,361,841)$ (6,394,401) 325%11,660,055$ (8,361,841)$ (20,021,896)-172%
-
54 FUND BALANCE BEGINNING 14,218,345 14,218,345 0.00 0%2,558,290 14,218,345 11,660,055 456%
55 12,250,905 5,856,504 (6,394,401) -52%14,218,345 5,856,504 $ (8,361,841)-59%
BASE VS PROPOSED PY ESTIMATED VS CY PROPOSED
TOTAL REVENUES
SLA Requests based on these numbers GFOA Requirements based on these numbersCAPITAL PROJECT FUNDS
Program Summary
Tuesday, August 01, 2017
TOTAL OPERATING EXPENDITURES
TOTAL OTHER SOURCES & USES
NET CHANGE TO FUND BALANCE
FUND BALANCE ENDING
TOTAL CAPITAL
49
/
Revenues, Transfers In & Other Sources:++=
Payroll and Related Taxes, Insurance:--=
Expenses, Transfers Out & Other Uses:--=
Net Budget Impact:===
Type Recur BSC
1 E O AO
2 E O FS
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17 N O MAO Capital Project
18 N O MAO Capital Project
19 N O PFT Capital Project
20 N P PFT Payroll Transfer Out to GF for Dept 16 Capital Projects
21
22
23
24
25
26
27
28
29
30
31
32
33
SHOULD MATCH AMOUNT NOTED ABOVE
SHOULD BE ZERO
410-73000-00-000-000076 Cemetary Improvements $100,000.00
$1,015,324.00
$0.00
$0.00
TOTAL PAYROLL $0.00
$0.00
ACCT DESCRIPTION
WA Outdoor Science Project $175,000.00
CHANGE AMT
$0.00
TOTAL SLA AMOUNT
410-33700-00-000-000071
ACCOUNT NUMBER
$1,190,324.00TOTAL REVENUES
$0.00
TOTAL PROJECTS $7,584,725.00
$0.00
$0.00
Transfer In from General Fund
$0.00
S E R V I C E L E V E L A D J U S T M E N T F O R M
2017 2018Fiscal Year:
FUND INFORMATION
BASE BUDGET AMT NEW BUDGET AMT
BUDGET INFORMATION
REVISION 2 REVISION
CHANGE AMOUNTACCOUNT DESCRIPTION/TYPES
JUSTIFICATION FOR CHANGE
Increased due to Entrada permit and inspection fees
$0.00
410-74400-00-000-000071 WA Outdoor Science Project $85,160.00
Expense SLA Form - revised 04.20.2017
3
$10,342,565.00
$1,190,324.00
$7,584,725.00
-$6,394,401.00
$790,400.00
$2,757,840.00
-$1,967,440.00
$1,980,724.00
-$8,361,841.00
-$6,394,401
ACCOUNTS CAUSING VARIANCE
410-52510-88-000
$0.00
Grant from the W.A. Foundation
410-72000-00-000-000064 Fire Station Complex $7,345,000.00
410-42699-00-000 PR Transfers Out to GF $54,565.00
$0.00
MINUS $0.00 $0.00 $0.00
includes 410 Capital Projects; 412 WA ExpansionFund Type:CAPITAL PROJECT FUNDS
$0.00
$0.00
$0.00
ADD
MINUS
EQUALS
50
SECTION 10
51
ALL CAPITAL FUNDSFORMERLY ADOPTED and NEW PROPOSED PROJECTS
FIVE YEAR FORECAST
New Proposed Project
ACTUALS FY 16-17 FY 17-18 FY 18-19 FY 19-20 PROJECT
Proj THRU ESTIMATED PROPOSED Budget Budget GRAND
No.Project Description FY 15-16 BUDGET BUDGET TOTAL
1 CP64 Fire-EMS Station 42,938 482,175 9,843,000 1,591,300 - 11,959,413
CP64 Land In Kind Donation - 1,998,000 - - - 1,998,000
2 CP73 Land Sale Expenses - 17,825 - - - 17,825
3 Sub-Total - Municipal Facilities Improvements 42,938 2,498,000 9,843,000 1,591,300 - 13,975,238
4
5
6 CP71 WA Outdoor Learning Space 15,975 89,840 175,000 - 150,000 430,815
7 CP72 WA Bleachers & Tower 37,868 4,590 - - - 42,458
8 CP77 WA Pond Repairs - - - 82,000 - 82,000
9 Sub-Total - Facilities Improvements 53,843 94,430 175,000 82,000 150,000 555,273
10
11
12 CP42 Trail Connection at Hwy 114 and Solana Blvd.- - - 30,000 - 30,000
13 CP67 Wayfinding Signage - - - 229,500 - 229,500
14 CP75 Flashing Crosswalk Lights (Dove @ Pearson&Ottinger)- - - 80,000 - 80,000
15 CP76 Cemetary Improvements - - 100,000 50,000 - 150,000
16 Sub-Total - Trail/Park/Cemetery Improvements - - 100,000 389,500 - 489,500
17
18
19 CP34 Roanoke Road Recon/Drainage South 2,900 - - - 480,180 483,080
20 CP40 Sam School Road Recon/Drainage - - - 281,960 - 281,960
21 CP78 Solana Pavement Repairs - - - 90,000 - 90,000
22 CP79 Wyck Hill Pavement Resurface - - - 54,450 - 54,450
23 CP80 FM1938 Pavement Repairs - - - 80,000 - 80,000
24 CP41 Dove Rd Recon/Drainage (Vaquero/Terra Bella) Cash 69,825 330,260 - - -
25 CP41 Dove Rd Recon/Drainage (Vaquero/Terra Bella) Bonds - 366,000 - - -
26 CP68 FM 1938/Dove Road Signalization 12,400 285,000 160,000 - - 457,400
27 CP70 FM 1938/Solana Traffic Signalization 259,540 102,000 10,000 - - 371,540
28 Sub-Total - Road/Street Improvements 344,665 1,083,260 170,000 506,410 480,180 2,584,515
29
30
31 CP52 Trail - Academy to Cemetery - - - - 300,949 300,949
32 CP58 Ottinger Road Recon/Drainage - - - - 983,954 983,954
33 CP53 Trail - Dove/Pearson/Aspen - - - 290,016 - 290,016
34 CP60 Pearson Lane Recon/Drainage - - - 404,125 - 404,125
35 Sub-Total - Trail and Road Improvements - - - 694,141 1,284,903 1,979,044
36
37 441,446$ 3,675,690$ 10,288,000$ 3,263,351$ 1,915,083$ 19,583,570$
40
41 UF31 N1 Sewer Line Transfer I&I - - - 96,435 - 96,435
42 -$ -$ -$ 96,435$ -$ 96,435
43
44
45 $ 441,446 $ 3,675,690 $ 10,288,000 $ 3,359,786 $ 1,915,083 $ 19,680,005
46
47
48
49
50 ACTUALS FY 16-17 FY 17-18 FY 18-19 FY 19-20 PROJECT
51 THRU ESTIMATED PROPOSED Budget Budget GRAND
52 FY 15-16 BUDGET BUDGET TOTAL
53 Contributions (Formerly adopted)297,408 2,104,590 10,000 - - 2,411,998
54 Contributions (New requests))- - 100,000 50,000 - 150,000
55 Foundation Contribution 15,975 89,840 175,000 - 150,000 430,815
56 TOTAL CONTRIBUTIONS $313,383 $2,194,430 $285,000 $50,000 $150,000 $2,992,813
57
58 Cash (Formerly adopted)128,063 615,260 160,000 96,435 - 999,758
59 TOTAL CASH $128,063 $615,260 $160,000 $96,435 $0 $999,758
60
61 FY 10/11 Road Improvement Bonds (formerly adopted)- 366,000 - - - 366,000
62 FY 16/17 Fire Station - 30 yr Bonds - 500,000 9,843,000 1,591,300 - 11,934,300
63 FY 18/19 Street/Trail - 20 yr Bonds - - - 1,622,051 1,765,083 3,387,134
64 TOTAL BONDS $0 $866,000 $9,843,000 $3,213,351 $1,765,083 $15,687,434
65
66 $ 441,446 $ 3,675,690 $ 10,288,000 $ 3,359,786 $ 1,915,083 $ 19,680,005
766,085
GRAND TOTAL ALL PROJECTS
TOTAL GOVERNMENTAL PROJECTS
TOTAL UTILITY FUND PROJECTS
-------- Projection----------
GRAND TOTAL ALL PROJECTS
---------- Projection------------ FUNDING TOTALS
52
Project Description:
410-72000-00-000-000064 Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 22/22 Total
Consultant/Engineering 23,438 482,175 650,000 4,100 - - 1,159,713
Construction - 6,000,000 1,331,700 - - - 7,331,700
Construction - Exterior only - - 1,998,000 - - - - 1,998,000
Design 19,500 - 332,500 180,500 - - 532,500
FF&E - - 275,000 - - - - 275,000
IT/Security - - 212,500 - - - - 212,500
Land Sale Expense - 17,825 - - - - - 17,825
Contingency - - 75,000 75,000 - - - 150,000
Other (Foundation) - - 300,000 - - - - 300,000
PROJECT EXPENDITURES 42,938 500,000 9,843,000 1,591,300 - - - 11,977,238
Land Purchase (in kind) - 1,998,000 - - - - - 1,998,000
PROJECT TOTAL 42,938 2,498,000 9,843,000 1,591,300 - - - 13,975,238
410-33501-00-000-000064 Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 22/22 Total
Cash (Fund Balance) 42,938 29,232 - - - - 72,170
7 Year Tax Note (US Bank) - 1,500,768 - - - - - 1,500,768
Bonds 2016/17 CO Bonds - 9,204,300 - - - - - 9,204,300
Sale of Land - 1,200,000 - - 1,200,000
FUNDING SUBTOTAL 42,938 11,934,300 - - - - - 11,977,238
Land Contribution (in kind) - 1,998,000 - - - - - 1,998,000
FUNDING TOTAL 42,938 13,932,300 - - - - - 13,975,238
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 22/22
Services - - - - 5,150 5,305 5,464 -
Insurance - - - - 4,893 5,040 5,191 -
Repair & Maintenance - - - - 50,000 51,500 53,045 -
Rent & Utilities - - - - 64,580 66,517 68,513 -
Debt Service CO 2017 - - `509,725 508,500 507,125 510,525 -
Other - - - - - - - -
OPERATING IMPACT - - - 509,725 633,123 635,487 642,738 -
5 Year Projection
FUNDED CAPITAL IMPROVEMENT
Iconic Fire-EMS Station
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
5 Year Projection
IMPACT ON OPERATING BUDGET
This project will provide an inconic Fire-EMS Station, which includes 4 bays, sleeping
areas for staff members, kitchen/food preparation, storage, multi-purpose space to serve
as a community/staff training, EOC room and offices for administration. The station is
estimated to be approximately 18K square feet of usable space and would also include
the Town's Emergency Operations Center (EOC) with a back-up generator for
sustainability. It does not include any apparatus or a fire training facility. The project
includes the acquisition of land by private donation,
53
Project Description:
410-74400-00-000-000071 Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 22/22 Total
Engineering - - - - - - - -
Construction - 89,840 148,000 - 150,000 - - 387,840
Design 15,975 - 10,000 - - - - 25,975
FF&E - - 10,000 - - - - 10,000
IT/Security - - - - - - - -
Contingency - - 7,000 - - - - 7,000
Other (Foundation) - - - - - - - -
Other Admin cost - - - - - - - -
EXPENDITURES TOTAL 15,975 89,840 175,000 - 150,000 - - 430,815
410-33700-00-000-000071 Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 22/22 Total
Cash (Fund Balance) - - 3,555 - 15,000 - - 18,555
Transfer in from General Fund - - - - - - - -
Transfer in from Utility Fund - - - - - - - -
Grant - Foundation 102,200 - 175,000 - 135,000 - - 412,200
Other - 60 - - - - - 60
FUNDING TOTAL 102,200 60 178,555 - 150,000 - - 430,815
Totals Thru Estimated
IMPACT TYPE FY 14/15 FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21
Services - - - - 1,000 1,000 1,000 -
Insurance - - - - - - - -
Repair & Maintenance - - - 2,000 2,060 2,122 2,185 -
Rent & Utilities - - - - - - - -
Debt Service - - - - - - - -
Other - - - - - - - -
OPERATING IMPACT - - - 2,000 3,060 3,122 3,185 -
5 Year Projection
IMPACT ON OPERATING BUDGET
5 Year Projection
FUNDED CAPITAL IMPROVEMENT
Westlake Academy - Outdoor Learning Space
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
The outdoor classroom would greatly facilitate teachers’ flexibility in their lessons to incorporate more
hands-on science experiences. Establishing an area for on-going investigations would provide the
students an authentic opportunity to connect their learning to the natural environment. Activities may
include plant and animal investigations (including insects & small invertebrates), water chemistry
projects using both our own pond as well as additional water sources housed within the facility, earth
science, as well as understanding weather and weather patterns. The space will be located along the
north drive and around the pond. Phase I was completed in May 2017 which includes the vegetable
garden and planter boxes located north of the Gym. Phase II would be the Math & Science Plaza which
would include two concrete pads, one for the phase of the moon, sundial, compass, simple machine
rack and ruler, sidewalks and retaining walls.
54
Project Description:
410-73000-00-000-000077 Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 22/22 Total
Engineering - - 12,000 - - - - 12,000
Construction - - 70,000 - - - - 70,000
Design - - - - - - - -
Contingency - - - - - - - -
Other (Foundation) - - - - - - - -
Other Admin cost - - - - - - - -
EXPENDITURES TOTAL - - 82,000 - - - - 82,000
410-10110-00-000-000077 Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 22/22 Total
Cash (Fund Balance) - - 82,000 - - - - 82,000
Transfer in from General Fund - - - - - - - -
Transfer in from Utility Fund - - - - - - - -
Other - - - - - - - -
FUNDING TOTAL - - 82,000 - - - - 82,000
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 22/22
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - 2,000 2,060 2,122 2,185 -
Rent & Utilities - - - - - - - -
Debt Service - - - - - - - -
Other - - - - - - - -
OPERATING IMPACT - - - 2,000 2,060 2,122 2,185 -
5 Year Projection
IMPACT ON OPERATING BUDGET
5 Year Projection
NEW CAPITAL IMPROVEMENT REQUEST
Westlake Academy Pond Repairs
The irrigation pond at the Westlake Academy is leaking on the east side with water
running onto the property east of the campus. In March of 2017 a clay dam was installed
which has slowed the water flow. This project will be to remove the silt from the pond and
install a clay liner.
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
55
Project Description:
410-74400-00-000-000042 Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering -
Construction 30,000 30,000
Design -
Contingency -
Other (Foundation) -
Other Admin cost -
EXPENDITURES TOTAL - - - 30,000 - - - 30,000
410-33501-00-000-000042 Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) -
Bond Issuance - 30,000 30,000
Transfer in from Utility Fund -
Other -
FUNDING TOTAL - - - 30,000 - - - 30,000
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - - - -
Utilities - - - - - - - -
Debt Service - - - - - - - -
OPERATING IMPACT - - - - - - - -
5 Year Projection
IMPACT ON OPERATING BUDGET
5 Year Projection
NEW CAPITAL IMPROVEMENT REQUEST
Trail Connection at Hwy 114 and Solana Blvd.
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
This project would extend an existing 8 ft. concrete trail an
estimated 1,000 feet from the west side of Hwy 114 to the
east side of Hwy 114. This project will start at the same time
the signal project for the intersection of Solana Blvd and
Hwy 114 begins.
56
Project Description:
410-74400-00-000-000067 Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - - - - - - -
Construction - - - 229,500 - - - 229,500
Design - - - - - - - -
Contingency - - - - - - - -
Other - - - - - - - -
EXPENDITURES TOTAL - - - 229,500 - - - 229,500
410-33501-00-000-000067 Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash/Transfers - - - - - - - -
Contributions/Grants - - - - - - - -
Bond Issuance - - - 229,500 - - - 229,500
UnFunded - - - - - - - -
Other - - - - - - - -
FUNDING TOTAL - - - 229,500 - - - 229,500
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - - - -
Rent & Utilities - - - - - - - -
Debt Service - - - - - - -
OPERATING IMPACT - - - - - - -
IMPACT ON OPERATING BUDGET
5 Year Projection
NEW CAPITAL IMPROVEMENT REQUEST
Wayfinding Signage
The "Wayfinding" Sign Project will showcase the town’s major venues, direct visitors
through major corridors that lead to various Town’s destinations and trails. The project
would include the locations, design and cost estimate to create and install the
wayfinding signage.
The package would include but not limited to the following,
• Development of a Master Plan to provide staff a guideline and template for wayfinding
• Implementation.
• Recognizable wayfinding system that is easily adaptable for future development
• Create a signage system that blends into Westlake
• Material selections
• Define trail access points
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
5 Year Projection
57
Project Description:
410-73000-00-000-000075 Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - - - - - - -
Construction - - - 55,000 - - - 55,000
Design - - - 25,000 - - - 25,000
Contingency - - - - - - - -
Other (Foundation) - - - - - - - -
Other Admin cost - - - - - - - -
EXPENDITURES TOTAL - - - 80,000 - - - 80,000
410-33501-00-000-000075 Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Bond Issuance - 80,000 - - - 80,000
Transfer in from Utility Fund - - - - - - - -
Other - - - - - - - -
FUNDING TOTAL - - - 80,000 - - - 80,000
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - 2,000 2,060 2,122 -
Utilities - - - - - - - -
Debt Service - - - - - - - -
OPERATING IMPACT - - - - 2,000 2,060 2,122 -
NEW CAPITAL IMPROVEMENT REQUEST
Flashing Crosswalk Lights (Dove @ Pearson & Ottinger)
PROJECT EXPENSE
5 Year Projection
IMPACT ON OPERATING BUDGET
5 Year Projection
PROJECT FUNDING
5 Year Projection
The town trail system currently starts and/or stops at the Westlake
Academy campus. The use of the trail has increased over the past two
years due to the growth of the cummunity and the Academy. Flashing
light at the crosswalk would give vehicles a warning that pedestrians are
crossing the Dove and Ottinger roads. The project would include flashing
signs and lights being installed in the pavement. Ottinger Road
58
Project Description:
410-73000-00-000-000076 Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - 10,000 - - - - 10,000
Construction - - 90,000 50,000 - - - 140,000
Design - - - - - - - -
FF&E - - - - - - - -
Contingency - - - - - - - -
Other Admin cost - - - - - - - -
EXPENDITURES TOTAL - - 100,000 50,000 - - - 150,000
410-33700-000-000076 Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance)- - - - - - - -
Transfer in from General Fund - - - - - - - -
Transfer in from Utility Fund - - - - - - - -
Contribution - 150,000 - - - - - 150,000
Other - - - - - - - -
FUNDING TOTAL - 150,000 - - - - - 150,000
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - 2,000 2,060 2,122 -
Utilities - - - - - - - -
Debt Service - - - - - - - -
OPERATING IMPACT - - - - 2,000 2,060 2,122 -
IMPACT ON OPERATING BUDGET
5 Year Projection
NEW CAPITAL IMPROVEMENT REQUEST
Cemetery Improvements
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
5 Year Projection
This project would include a new water well, storage tanks,
irrigation system, fence on the southeast corner and
underground power for the water well.
59
Project Description:
410-73000-00-000-000034 Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering 2,900 - - - 55,000 - - 57,900
Construction - - - - 403,000 - - 403,000
Design - - - - - - - -
Contingency - - - - 22,180 - - 22,180
Other - - - - - - - -
EXPENDITURES TOTAL 2,900 - - - 480,180 - - 483,080
vision link 2,900 0 0 0 480,180 0
410-10110-00-000-000034 Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) 2,900 - - - - - - 2,900
Contributions/Grants - - - - - - - -
Bonds 2018/19 - - - 480,180 - - - 480,180
Unfunded - - - - - - - -
Other - - - - - - - -
FUNDING TOTAL 2,900 - - 480,180 - - - 483,080
vision link 0 0 0 480,180 0 0 0
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - - 5,088 -
Rent & Utilities - - - - - - - -
Debt Service - - - - - 30,038 30,038 -
OPERATING IMPACT - - - - - 30,038 35,126 -
5 Year Projection
5 Year Projection
IMPACT ON OPERATING BUDGET
The project will provide stabilization of road subgrade and 6" of asphalt to approximately
4,000 LF of Roanoke Road and replace/improve culverts and ditches, consistent with
2011 Graham Pavement Evaluation Study. Project improvements will be from Highway
170 south to the Town limits. Anticipate crack sealing during the 2nd year after
completion.
FUNDED CAPITAL IMPROVEMENT
Roanoke Road Reconstruction and Drainage South
(Highway 170 south to Town limits)
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
60
Project Description:
410-73000-00-000-000040 Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - - 49,308 - - - 49,308
Construction - - - 232,652 - - - 232,652
Design - - - - - - - -
Contingency - - - - - - - -
Other - - - - - - - -
EXPENDITURES TOTAL - - - 281,960 - - - 281,960
vision link 0 0 0 281,960 0 0 0
410-10110-00-000-000040 Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Contributions/Grants - - - - - - - -
Bond Issuance - - - 281,960 - - - 281,960
Unfunded - - - - - - - -
Other - - - - - - - -
FUNDING TOTAL - - - 281,960 - - - 281,960
vision link 0 0 0 281,960 0 0 0
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - 5,000 5,150 -
Rent & Utilities - - - - - - - -
Debt Service - - - - - - -
OPERATING IMPACT - - - - - 5,000 5,150 -
5 Year Projection
5 Year Projection
PROJECT FUNDING
IMPACT ON OPERATING BUDGET
FUNDED CAPITAL IMPROVEMENT
Sam School Road Reconstruction and Drainage
(Solana to Town limits)
PROJECT EXPENSE
5 Year Projection
The project will provide stabilization of road subgrade and 6" of asphalt to
approximately 2,000 LF of Sam School Road and replace/improve culverts
and ditches, consistent with 2011 Graham Pavement Evaluation Study.
Anticipate crack sealing 2nd year from completion. Includes 150 linear
feet of sidewalk.
61
Project Description:
410-73000-00-000-000078 Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - - 90,000 - - - 90,000
Construction - - - - - - - -
Design - - - - - - - -
Contingency - - - - - - - -
Other - - - - - - - -
EXPENDITURES TOTAL - - - 90,000 - - - 90,000
vision link 0 0 0 281,960 0 0 0
410-33501-00-000-000078 Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Contributions/Grants - - - - - - - -
Bond Issuance - - - 90,000 - - - 90,000
Unfunded - - - - - - - -
Other - - - - - - - -
FUNDING TOTAL - - - 90,000 - - - 90,000
vision link 0 0 0 281,960 0 0 0
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - - - -
Rent & Utilities - - - - - - - -
Debt Service - - - - - - -
OPERATING IMPACT - - - - - - - -
5 Year Projection
IMPACT ON OPERATING BUDGET
5 Year Projection
NEW CAPITAL IMPROVEMENT REQUEST
Solana Pavement Repair
his project will provide repairs to several sections of concrete pavement
failures on Solana Boulevard. The repairs will consist of
removal/replacement of concrete and failed subgrade and traffic control.
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
added from GMR Fund
62
Project Description:
410-73000-00-000-000079 Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - - - - - - -
Construction - - - 54,450 - - - 54,450
Design - - - - - - - -
Contingency - - - - - - - -
Other - - - - - - - -
EXPENDITURES TOTAL - - - 54,450 - - - 54,450
vision link 0 0 0 281,960 0 0 0
410-33501-00-000-000079 Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Contributions/Grants - - - - - - - -
Bond Issuance - - - 54,450 - - - 54,450
Unfunded - - - - - - - -
Other - - - - - - - -
FUNDING TOTAL - - - 54,450 - - - 54,450
vision link 0 0 0 281,960 0 0 0
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - - - -
Rent & Utilities - - - - - - - -
Debt Service - - - - - - -
OPERATING IMPACT - - - - - - - -
5 Year Projection
IMPACT ON OPERATING BUDGET
5 Year Projection
NEW CAPITAL IMPROVEMENT REQUEST
Wyck Hill Pavement Resurface
This project will provide for the removal and replacement of 1" to 2" of the
existing 6" asphalt on Wyck Hill Lane. The existing subgrade is in
excellent condition and does not require re-stabilization.
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
added from GMR Fund
63
Project Description:
410-73000-00-000-000080 Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - - - - - - -
Construction - - - 80,000 - - - 80,000
Design - - - - - - - -
Contingency - - - - - - - -
Other - - - - - - - -
EXPENDITURES TOTAL - - - 80,000 - - - 80,000
vision link 0 0 0 281,960 0 0 0
410-33501-00-000-000080 Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Contributions/Grants - - - - - - - -
Bond Issuance - - - 80,000 - - - 80,000
Unfunded - - - - - - - -
Other - - - - - - - -
FUNDING TOTAL - - - 80,000 - - - 80,000
vision link 0 0 0 281,960 0 0 0
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - - - -
Rent & Utilities - - - - - - - -
Debt Service - - - - - - -
OPERATING IMPACT - - - - - - - -
5 Year Projection
IMPACT ON OPERATING BUDGET
5 Year Projection
NEW CAPITAL IMPROVEMENT REQUEST
FM1938 Pavement Repair
This project will provide repairs to several sections of stamped/stained
concrete pavement failures on FM 1938. The repairs will consist of
removal/replacement of concrete and failed subgrade and traffic control
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
added from GMR Fund
64
Project Description:
410-73000-00-000-000041 Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - 100,000 - - - - - 100,000
Construction - 596,260 - - - - - 596,260
Design 69,825 - - - - - - 69,825
Contingency - - - - - - - -
Other - - - - - - - -
EXPENDITURES TOTAL 69,825 696,260 - - - - - 766,085
vision link 69,825 696,260 0 0 0 0 0
410-33501-00-000-000041 Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) 69,825 330,260 - - - - - 400,085
Contributions/Grants - - - - - - - -
Bonds 2011 Bond Issuance - 366,000 - - - - - 366,000
Unfunded - - - - - - - -
Other - - - - - - - -
FUNDING TOTAL 69,825 696,260 - - - - - 766,085
vision link 0 0 0 0 0 0 0
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - 5,000 5,150 -
Rent & Utilities - - - - - - - -
Debt Service - - - - - - - -
OPERATING IMPACT - - - - - 5,000 5,150 -
5 Year Projection
5 Year Projection
IMPACT ON OPERATING BUDGET
FUNDED CAPITAL IMPROVEMENT
Dove Road Reconstruction and Drainage
(Vaquero to Terra Bella)
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
The project will provide stabilization of road subgrade and 6" of asphalt to
approximately 6,500 LF of Dove Road and replace/improve culverts and
ditches, consistent with 2011 Graham Pavement Evaluation Study. Staff is
working with the Southlake developer to include a portion of this project
when the Southlake portion is realigned and reconstructed in 2015/2016.
65
Project Description:
410-73000-00-000-000068 Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering 12,400 10,000 - - - - - 22,400
Construction - 275,000 160,000 - - - - 435,000
Design - - - - - - - -
Contingency - - - - - - - -
Other - - - - - - - -
EXPENDITURES TOTAL 12,400 285,000 160,000 - - - - 457,400
vision link 0 0 0 0
410-10110-00-000-000034 Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) (13,989) 285,000 160,000 431,011
Contributions (Fidelity) 26,389 - - - - - - 26,389
Bonds - - - - - - - -
Unfunded - - - - - - - -
Other - - - - - - - -
FUNDING TOTAL 12,400 285,000 160,000 - - - - 457,400
vision link 0 0 0 0
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - - - -
Rent & Utilities - - - - - - - -
Debt Service - - - - - - - -
OPERATING IMPACT - - - - - - - -
5 Year Projection
IMPACT ON OPERATING BUDGET
5 Year Projection
FUNDED CAPITAL IMPROVEMENT
FM 1938/Dove Road Signalization
This project will provide for the signalization of the FM 1938 and Dove Road intersection
consistent with the enhancements at SH 114. The need to signalize is being caused by
the proposed signalization of FM 1938 and Solana Blvd/Capital Pkwy that is currently
included with the Entrada development improvements. The installation of a proposed
traffic signal at FM 1938 and Solana Blvd/Capital Pkwy. in connection with the Granada
and Entrada developments, the intersection would decrease traffic congestion and
increase safety at the FM 1938 and Dove Road intersection. While FM 1938 is a
TxDOT roadway, the cost to signalize will be the responsibility of the Town. Staff will
continue to pursue TxDOT funding for signalization of this intersection.
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
66
Project Description:
410-74400-00-000-000070 Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - - - - - - -
Construction 259,540 102,000 10,000 - - - - 371,540
Design - - - - - - - -
Contingency - - - - - - - -
Other - - - - - - - -
EXPENDITURES TOTAL 259,540 102,000 10,000 - - - - 371,540
vision link 0 0 0
410-33700-00-000-000070 Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Contributions/Grants - 112,000 - 112,000
Entrada PID 217,413 - - - - - - 217,413
Granada 15,738 - - - - - - 15,738
Fidelity 26,389 - - - - - - 26,389
Cash (Fund Balance) - - - - - - - -
FUNDING TOTAL 259,540 112,000 - - - - - 371,540
vision link 259,540 112,000 0 0 0 0 0
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - - - -
Rent & Utilities - - 200 200 200 200 200 -
Debt Service - - - - - - - -
OPERATING IMPACT - - 200 200 200 200 200 -
FUNDED CAPITAL IMPROVEMENT
FM 1938/Solana Traffic Signalization
5 Year Projection
This project will provide for the signalization of the FM 1938 and Solana Blvd intersection
consistent with the enhancements at SH 114. The installation of the proposed traffic
signals is in connection with the Granada and Entrada developments that would
decrease traffic congestion and frustration. Staff is also currently working with TxDot for
a proposed signal at the FM 1938/Dove Road intersection.
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
5 Year Projection
IMPACT ON OPERATING BUDGET
67
Project Description:
410-74400-00-000-000052 Totals Thru Estimated Project
410-73000-00-000-000058 FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Trail- Engineering/Design - - - - 32,999 - - 32,999
Trail - Construction - - - - 231,080 - - 231,080
Trail - Design - - - - 46,870 - - 46,870
Road/Bridge - Engineering - - - - 204,985 - - 204,985
Road/Bridge - Construction - - - - 768,969 - - 768,969
EXPENDITURES TOTAL - - - - 1,284,903 - - 1,284,903
vision link 0 0 0 0 1,284,903 0 0
410-33501-00-000-000052 Totals Thru Estimated Project
410-33501-00-000-000058 FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Contributions/Grants - - - - - - - -
Bonds 2018/2019 CO - - - 1,284,903 - - - 1,284,903
Unfunded - - - - - - - -
Other - - - - - - - -
FUNDING TOTAL - - - 1,284,903 - - - 1,284,903
vision link 0 0 0 1,284,903 0 0 0
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Trail - Services - - - - - - - -
Insurance - - - - - - - -
Trail - Repair & Maintenance - - - - - - - -
Trail - Rent & Utilities - - - - - - - -
Debt Service - - - - - 78,165 78,165 -
OPERATING IMPACT - - - - - 78,165 78,165 -
FUNDED CAPITAL IMPROVEMENT
5 Year Projection
5 Year Projection
5 Year Projection
PROJECT EXPENSE
PROJECT FUNDING
IMPACT ON OPERATING BUDGET
This project will provide stabilization of road subgrade and 7" asphalt to approximately 4,000 LF of
Ottinger Road (from Westlake Academy to SH 170) and replace/improve culverts and ditches,
consistent with 2011 Graham Pavement Evaluation Study. Anticipate crack sealing during the 2nd
year after completion. In conjunction with this project, the existing Ottinger Road bridge will be
replaced with new box culvert, much like the Dove Road improvements. Staff will determine
through engineering design analysis the final design criteria including horizontal and vertical
alignment. A trail will provide East to West interconnectivity within the Westlake trail system.
Includes a primitive trail head on the Southeast corner of the cemetery property (primitive parking,
restrooms and water fountain).
Ottinger Road Reconstruction/Drainage & Trail
(North of Westlake Academy)
Project 52 Trail $ 300,949
Project 58 R&D $ 983,954
Grand Total $1,284,903
68
Project Description:
410-74400-00-000-000053 Totals Thru Estimated Project
410-73000-00-000-000060 FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Trail - Engineering - - - 27,260 - - 27,260
Trail - Construction - - - 220,600 - - 220,600
Trail - Contingency - - - 45,156 - - 45,156
Road - Engineering - - - 57,505 - - 57,505
Road - Construction - - - 343,620 - - 343,620
EXPENDITURES TOTAL - - - 694,141 - - - 694,141
vision link 0 0 0 694,141 0 0 0
410-33501-00-000-000053 Totals Thru Estimated Project
410-33501-00-000-000060 FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Contributions/Grants - - - - - - - -
Bonds 2018/19 CO - - - 694,141 - - - 694,141
Unfunded - - - - - - - -
Other - - - - - - - -
FUNDING TOTAL - - - 694,141 - - - 694,141
vision link 0 0 0 694,141 0 0 0
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Trail - Services - - - - - - - -
Insurance - - - - - - - -
Trail - Repair & Maint - - - - - - - -
Trail - Rent & Utilities - - - - - - - -
Debt Service - - - - - 42,230 42,230 -
OPERATING IMPACT - - - - - 42,230 42,230 -
FUNDED CAPITAL IMPROVEMENT
5 Year Projection
PROJECT EXPENSE
5 Year Projection
Pearson Lane Reconstruction/Drainage &
Trail - Dove Road / Pearson Road / Aspen Lane
PROJECT FUNDING
5 Year Projection
IMPACT ON OPERATING BUDGET
This project will providetrail connectivity from Aspen Lane north to Dove Road
along the east side of Pearson Road. This will include crosswalk devices at
the corner of Dove and Pearson. In addition the project will provide
stabilization of road subgrade and 5" of asphalt to approximately 1,300 LF of
Pearson Lane and replace/improve culverts and ditches, consistent with 2011
Graham Pavement Evaluation Study. Anticipate crack sealing during the 2nd
year after completion.
Project 53 Trail $290,016
Project 60 R&D $404,125
Grand Total $694,141
69
Project Description:
Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering 42,847 - - - - - 42,847
Construction 242,545 - - 96,435 - - - 338,980
Design - - - - - - - -
Contingency - - - - - - - -
Other - - - - - - - -
EXPENDITURES TOTAL 285,392 - - 96,435 - - - 381,827
Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash/Transfers 285,392 - - 96,435 - - - 381,827
Contributions/Grants - - - - - - - -
Bond Issuance - - - - - - - -
UnFunded - - - - - - - -
Other - - - - - - - -
FUNDING TOTAL 285,392 - - 96,435 - - - 381,827
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - - - -
Rent & Utilities - - - - - - - -
Debt Service - - - - - - -
OPERATING IMPACT - - - - - - -
5 Year Projection
5 Year Projection
IMPACT ON OPERATING BUDGET
FUNDED CAPITAL IMPROVEMENT
TRA Assumption of N-1 Sewer Line
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
This project is intended to transfer ownership of a section of sewer line from
Westlake and Southlake to TRA. It includes the design and construction of a
metering station with SCADA equipment at the proposed Town of Westlake
"Point of Entry."
70
ALL UNFUNDED (UNDER DISCUSSION) CAPITAL PROJECTS
New Project
ACTUALS FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22
THRU PROPOSED Budget Budget Budget Budget
Project Description FY 15/16 BUDGET
1 Hwy 377 Landscape Improvements (Phase I and II)- - 411,100 436,000 - - 847,100
2 SH114 and Schwab Way Traffic Signal Upgrade - - 257,500 - - - 257,500
3 Trail - Fidelity to Westlake Parkway at Hwy 114 - - - 330,338 - - 330,338
4 Hwy 170 and 377 Traffic Signal Upgrade - - 15,000 250,000 - - 265,000
5 Dove Road & Randol Mill Traffic Circle - - - - 674,238 892,427 1,566,665
6 Hwy 170 and Roanoke Traffic Signal Upgrade - - - 15,000 257,500 - 272,500
7 Glenwyck Farms Telecommunications Ductbank - - - - - 806,400 806,400
8 WA Pedestrian Underpass - - - - - 741,600 741,600
9 SH 114/170 Enhancements 239,433 - - - - 830,592 1,070,025
10 Total Road/Street Improvements/Trails 239,433$ -$ 683,600$ 1,031,338$ 931,738$ 3,271,019$ 6,157,128$
11
12 Cemetery Improvements - - - - 73,609 77,904 151,513
13 15-30 Acre Community Park - - - - 8,033,126 183,706 8,216,832
14 Total Parks/Cemetery -$ - - - 8,106,735 261,610 8,368,345
15
19 TOTAL UNFUNDED (UNDER DISCUSSION) 239,433$ -$ 683,600$ 1,031,338$ 9,038,473$ 3,532,629$ 14,525,473$
20 PROJECTS FOR FUTURE YEARS (TBD)
21 Municipal Town Hall - - - - - - -
22 Fire Dept Ladder Truck - - - - - - -
23 WA Sports Field Lighting - - - - - - -
24 WA Phase II Construction - - - - - - -
25 WA Phase III Construction - - - - - - -
26 TOTAL TO BE DECIDED -$ -$ -$ -$ -$ -$ -$
FIVE YEAR PROJECTION
TOTAL
------------------------- Projection---------------------------
71
Project Description:
Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - - 30,000 - - - 30,000
Construction Phase II - - - 381,100 - - - 381,100
Construction Phase II - - - - 436,000 - - 436,000
Contingency - - - - - - - -
Other - - - - - - - -
EXPENDITURES TOTAL - - - 411,100 436,000 - - 847,100
Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Contributions/Grants - - - - - - - -
Bonds - - - - - - - -
Unfunded - - - 411,100 436,000 - - 847,100
Other - - - - - - - -
FUNDING TOTAL - - - 411,100 436,000 - - 847,100
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - 5,150 5,305 -
Rent & Utilities - - - - - 10,300 10,609 -
Debt Service - - - - - - - -
OPERATING IMPACT - - - - - 15,450 15,914 -
PROJECT FUNDING
5 Year Projection
IMPACT ON OPERATING BUDGET
5 Year Projection
UNFUNDED (UNDER DISCUSSION) CAPITAL IMPROVEMENT
Hwy 377 Landscape Improvements
The project will include streetscape enhancements (hardscape,
landscape) along US Hwy 377 starting at Westport Parkway stretching
north for 3/4 mile. The enhancements will only be located in the median
and consist of native and naturalized plantings, trees, plant bed
preparations, drip irrigation, and concrete edging/mowstrip. Since the
project will be within state ROW, the Town will submit this project to
TxDOT for potential grant funding opportunities similar to the FM 1938
median landscape project.
PROJECT EXPENSE
5 Year Projection
72
Project Description:
Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - - 15,000 - - - 15,000
Construction - - 242,500 - - - 242,500
Design - - - - - - - -
Painting - - - - - - - -
Other - - - - - - - -
EXPENDITURES TOTAL - - - 257,500 - - - 257,500
Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Contributions/Grants - - - - - - - -
Bonds - - - - - - - -
Unfunded - - - 257,500 - - - 257,500
Other - - - - - - - -
FUNDING TOTAL - - - 257,500 - - - 257,500
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - - - -
Rent & Utilities - - - 200 2,016 212 219 -
Debt Service - - - - - - - -
OPERATING IMPACT - - - 200 2,016 212 219 -
5 Year Projection
IMPACT ON OPERATING BUDGET
5 Year Projection
UNFUNDED (UNDER DISCUSSION) CAPITAL IMPROVEMENT
114 and Schwab Way Traffic Signal Upgrade
This project will upgrade the current signal poles at the SH 170/Roanoke Road
intersection with poles and internally illuminated street name signs consistent with the
enhanced signals on FM 1938. This project will upgrade the current signalization of the
SH 170/Roanoke Road intersection with poles and internally illuminated street name
signs consistent with the enhanced signals on FM 1938. The current configuration of
Roanoke Road will change once the main lanes of SH 170 are constructed, resulting in
the reduction of the traffic signalization for northbound and southbound traffic
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
73
Project Description:
Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - 70,000 - - 70,000
Construction - - 115,000 - - 115,000
Design - - 145,338 - 145,338
Contingency - - - -
Other - - - - - - - -
EXPENDITURES TOTAL - - - - 330,338 - - 330,338
Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Contributions/Grants - - - - - - - -
Bonds - - - - - - - -
Unfunded - - - - 330,338 - - 330,338
Other - - - - - - - -
FUNDING TOTAL - - - - 330,338 - - 330,338
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - - - -
Rent & Utilities - - - - - - - -
Debt Service - - - - - - - -
OPERATING IMPACT - - - - - - - -
PROJECT FUNDING
5 Year Projection
IMPACT ON OPERATING BUDGET
5 Year Projection
UNFUNDED (UNDER DISCUSSION) CAPITAL IMPROVEMENT
Trail - Fidelity Campus to Westlake Parkway on Hwy 114
PROJECT EXPENSE
5 Year Projection
This project will provide connectivity from Hwy 114 to
Capital Parkway along the east side of Westlake Parkway.
74
Project Description:
Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - - 15,000 - - - 15,000
Construction - - - 250,000 - - 250,000
Design - - - - - - - -
Painting - - - - - - - -
Other - - - - - - - -
EXPENDITURES TOTAL - - - 15,000 250,000 - - 265,000
Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Contributions/Grants - - - - - - - -
Bonds - - - - - - - -
Unfunded - - - 15,000 250,000 - - 265,000
Other - - - - - - - -
FUNDING TOTAL - - - 15,000 250,000 - - 265,000
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - - - -
Rent & Utilities - - - - 200 206 212 -
Debt Service - - - - - - - -
OPERATING IMPACT - - - - 200 206 212 -
5 Year Projection
IMPACT ON OPERATING BUDGET
5 Year Projection
UNFUNDED (UNDER DISCUSSION) CAPITAL IMPROVEMENT
170 and 377 Traffic Signal Upgrade
This project will upgrade the current signalization of the SH 170 and US 377 intersection
with poles and internally illuminated street name signs consistent with the enhanced
signals on FM 1938.
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
75
Project Description:
Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - - - - - 106,090 106,090
Construction - - - - - - 786,337 786,337
Design - - - - - 36,050 - 36,050
Contingency - - - - - - - -
Other - - - - - 638,188 - 638,188
EXPENDITURES TOTAL - - - - - 674,238 892,427 1,566,665
Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Contributions/Grants - - - - - - - -
Bonds - - - - - - - -
UnFunded - - - - - 674,238 892,427 1,566,665
Other - - - - - - - -
FUNDING TOTAL - - - - - 674,238 892,427 1,566,665
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - 2,971 3,060 -
Rent & Utilities - - - - - 5,941 6,119 -
Debt Service - - - - - - - -
OPERATING IMPACT - - - - - 8,912 9,179 -
PROJECT FUNDING
5 Year Projection
IMPACT ON OPERATING BUDGET
5 Year Projection
UNFUNDED (UNDER DISCUSSION) CAPITAL IMPROVEMENT
Dove Road & Randol Mill Traffic Circle
Reconstruction and reconfiguration of Dove Road and
Randol Mill from a 3-way stop intersection to a traffic circle
to improve traffic safety. Pavement construction will be
consistent with 2011 Graham Pavement Evaluation Study.
PROJECT EXPENSE
5 Year Projection
76
Project Description:
Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - - - 15,000 - - 15,000
Construction - - - - 257,500 - 257,500
Design - - - - - - - -
Painting - - - - - - - -
Other - - - - - - - -
EXPENDITURES TOTAL - - - - 15,000 257,500 - 272,500
Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Contributions/Grants - - - - - - - -
Bonds - - - - - - - -
Unfunded - - - - 15,000 257,500 - 272,500
Other - - - - - - - -
FUNDING TOTAL - - - - 15,000 257,500 - 272,500
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - - - -
Rent & Utilities - - - - 200 206 212 -
Debt Service - - - - - - - -
OPERATING IMPACT - - - - 200 206 212 -
5 Year Projection
IMPACT ON OPERATING BUDGET
5 Year Projection
UNFUNDED (UNDER DISCUSSION) CAPITAL IMPROVEMENT
170 and Roanoke Road Traffic Signal Upgrade
This project will upgrade the current signalization of the SH 170/Roanoke Road
intersection with poles and internally illuminated street name signs consistent with the
enhanced signals on FM 1938. The current configuration of Roanoke Road will change
once the main lanes of SH 170 are constructed, resulting in the reduction of the traffic
signalization for northbound and southbound traffic.
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
77
Project Description:
Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - - - - - 806,400 806,400
Construction - - - - - - - -
Design - - - - - - - -
Contingency - - - - - - - -
Other - - - - - - - -
EXPENDITURES TOTAL - - - - - - 806,400 806,400
Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Contributions/Grants - - - - - - - -
Bonds - - - - - - - -
Unfunded - - - - - - 806,400 806,400
Other - - - - - - - -
FUNDING TOTAL - - - - - - 806,400 806,400
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - - - -
Rent & Utilities - - - - - - - -
Debt Service - - - - - - - -
OPERATING IMPACT - - - - - - - -
5 Year Projection
IMPACT ON OPERATING BUDGET
5 Year Projection
UNFUNDED (UNDER DISCUSSION) CAPITAL IMPROVEMENT
Glenwyck Farms Telcommunications Ductbank
This project will provide for the construction of approximately 11,000 LF of
telecommunication ductbank within the Glenwyck subdivision to
accomodate the installation of improved telecommunication lines.
Additionally, this will provide a connection of the ductbank from Granda to
Terra Bella.
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
78
Project Description:
Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - - - - - 61,800 61,800
Construction - - - - - - 618,000 618,000
Design - - - - - - - -
Contingency - - - - - - 61,800 61,800
Other - - - - - - - -
EXPENDITURES TOTAL - - - - - - 741,600 741,600
Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Contributions/Grants - - - - - - - -
Bonds - - - - - - - -
Unfunded - - - - - - 741,600 741,600
Other - - - - - - - -
FUNDING TOTAL - - - - - - 741,600
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - - - -
Rent & Utilities - - - - 206 212 219 -
Debt Service - - - - - - - -
OPERATING IMPACT - - - - 206 212 219 -
UNFUNDED (UNDER DISCUSSION) CAPITAL IMPROVEMENT
Westlake Academy - Pedestrian Underpass
5 Year Projection
5 Year Projection
PROJECT FUNDING
5 Year Projection
IMPACT ON OPERATING BUDGET
PROJECT EXPENSE
This project will provide for the construction of a pedestrian underpass on
the south side of the Westlake Academy campus and connections to the
existing trail system. This will require the reconstruction of a section of
Ottinger Road and the relocation of water, gas, and telecommunications.
79
Project Description:
Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - - - - - - -
Construction - - - - - 830,592 830,592
Design - - - - - - - -
Painting 239,433 - - - - - - 239,433
Other - - - - - - - -
EXPENDITURES TOTAL 239,433 - - - - - 830,592 1,070,025
Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Contributions/Grants 149,622 - - - - - 149,622
Bonds 2011 CO $2.095M 89,811 - - - - - - 89,811
Bonds - - - - - - - -
Unfunded - - - - - - 830,592 830,592
FUNDING TOTAL 239,433 - - - - - - 1,070,025
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - - - - -
Insurance - - - - - - - -
Repair & Maintenance - - - - - - - -
Rent & Utilities - - - - - - - -
Debt Service - - - - - - 60,835 -
OPERATING IMPACT - - - - - - 60,835 -
PROJECT FUNDING
5 Year Projection
IMPACT ON OPERATING BUDGET
5 Year Projection
UNFUNDED (UNDER DISCUSSION) CAPITAL IMPROVEMENT
SH114/170 Enhancements
PROJECT EXPENSE
This project was anticipated to be a cooperative effort between Westlake, Trophy Club,
and Roanoke consisting of the design and construction of landscape and hardscape
improvements to the SH 170 & Hwy 114 interchange to include plantings, painting, and
entry monuments. Maintenance is for irrigation only. To-date the Town has paid
$239,433 for engineering and paintintg in FY 13/14. Project costs are estimated to be
$3,000,000 for construction. Funding participation is anticipated to be 1/3 from each
party. This project will be submitted for a TxDot grant (Green Ribbon). The Town
anticipates getting $160,000 reimbursement of engineering costs in FY 15/16 from
Trophy Club and Roanoke and will use those funds towards the final construction. If
project does not move forward, the funds will go to the Capital Projects fund balance.
5 Year Projection
80
Project Description:
Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - - - - - - -
Construction - - - - - 73,609 77,904 151,513
Design - - - - - - - -
Contingency - - - - - - - -
Other - - - - - - - -
EXPENDITURES TOTAL - - - - - 73,609 77,904 151,513
Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Contributions/Grants - - - - - - - -
Bond Issuance - - - - - - - -
Unfunded - - - - - 73,609 77,904 151,513
Other - - - - - - - -
FUNDING TOTAL - - - - - 73,609 77,904 151,513
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - - - - - -
Services - - - - 5,614 5,782 5,955 -
Insurance - - - - - - - -
Repair & Maintenance - - - - 16,841 17,346 17,866 -
Rent & Utilities - - - - - - - -
Debt Service - - - - - - - -
OPERATING IMPACT - - - - 22,454 23,128 23,821 -
UNFUNDED (UNDER DISCUSSION) CAPITAL IMPROVEMENT
5 Year Projection
Cemetery Improvements
PROJECT EXPENSE
5 Year Projection
PROJECT FUNDING
5 Year Projection
IMPACT ON OPERATING BUDGET
These improvements will consist of section markers,
roadways and landscaping. The project also anticipates a
future trail head with rest facilities that will accomodate the
future cemetery/academy trail. Based on current funding
sources, this project will be dependent upon the future sale
of plots and would be completed in four phases. Phase I &
II includes the road improvements and Phase III & IV will
consist of the landscaping and trail improvements.
81
Project Description:
Totals Thru Estimated Project
EXPENDITURE TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Engineering - - - - - 65,508 67,473 132,981
Construction - - - - - 3,476,610 - 3,476,610
Design - - - - - 65,508 67,473 132,981
Contingency - - - - - 58,300 48,760 107,060
Land Purchase (390K for 10
Acres) - - - - - 4,367,200 - 4,367,200
EXPENDITURES TOTAL - - - - - 8,033,126 183,706 8,216,832
Totals Thru Estimated Project
FUNDING TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Total
Cash (Fund Balance) - - - - - - - -
Contributions/Grants - - - - - - - -
Bond Issuance - - - - - - - -
Unfunded - - - - - 8,033,126 183,706 8,216,832
Other - - - - - - - -
FUNDING TOTAL - - - - - 8,033,126 183,706 8,216,832
Totals Thru Estimated
IMPACT TYPE FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22
Supplies - - - 2,975 3,065 -
Services - - - 17,851 18,387 -
Insurance - - - - - -
Repair & Maintenance - - - 2,975 3,065 -
Rent & Utilities - - - 9,521 9,807 -
Debt Service - - - - - - - -
OPERATING IMPACT - - - - - 33,323 34,323 -
PROJECT FUNDING
5 Year Projection
IMPACT ON OPERATING BUDGET
5 Year Projection
UNFUNDED (UNDER DISCUSSION) CAPITAL IMPROVEMENT
15-30 Acre Community Park
This project would include the purchase of 15 to 30 acres of
open space with the ability to add amenities such as small
covered pavilions, trail heads, playground stations, sports
fields, general use open spaces, dog park, restroom,
football field, running track, cross country trail, outdoor
tennis and basketball courts, baseball and softball fields.
The project would include restrooms, concession area with
outdoor eating area and parking. This facility would provide
programs and activities to the Westlake community and
Westlake Academy.
PROJECT EXPENSE
5 Year Projection
82
SECTION 11
83
Estimated Proposed
Budget Budget Change Change
FY 16/17 FY 17/18 Amount Percent
1 Transportation 10,000 10,000 - 0%
2 Parking 15,050 15,000 (50) 0%
3 Athletic Activities 90,724 90,700 (24) 0%
4 Interest Earned 4,500 3,000 (1,500) -33%
5 WAF Blacksmith Donation 1,025,000 1,000,000 (25,000) -2%
6 WAF Salary Reimbursement 66,432 67,800 1,368 2%
7 Town Contribution - Westlake Reserve 300,000 300,000 - 0%
8 Town Contribution 15,000 15,000 - 0%
9 Other Local Revenue (BTS, Tech & Other)95,886 58,800 (37,086) -39%
10 Fund raiser (Back to School)16,000 16,000 - 0%
11 Food Services 6,000 6,100 100 2%
12 Total Local Revenues 1,644,592 1,582,400 (62,192) -4%
13 TEA - Foundation School Funds (Inc. accrual)5,539,350 5,781,200 241,850 4%
14 CTE Funding (additional TEA-FSP Funds)299,605 572,200 272,595 91%
15 TEA - Available School Funds 287,790 191,300 (96,490) -34%
16 TEA - IB Training 6,300 6,300 - 0%
17 TRS On-behalf/Medicare Part B 450,326 450,700 374 0%
18 Total State Revenues 6,583,371 7,001,700 418,329 6%
19 8,227,963 8,584,100 $ 356,137 4%
20
21 Function 11 - Instructional 4,759,616 4,975,270 215,654 5%
22 Function 12 - Resources & Media 82,639 82,639 - 0%
23 Function 13 - Curriculum & Staff Development 86,623 84,545 (2,078) -2%
24 Function 21 - Instructional Leadership 278,148 206,623 (71,525) -26%
25 Function 23 - School Leadership 853,935 757,692 (96,243) -11%
26 Function 31 - Guidance & Counseling 228,950 223,973 (4,977) -2%
27 Function 33 - Health Services 68,024 66,024 (2,000) -3%
28 Function 36 - Co/Extracurricular Activities 246,013 218,358 (27,655) -11%
29 Function 41 - Administrative 307,126 260,167 (46,959) -15%
30 Function 51 - Maintenance & Operations 893,738 960,743 67,005 7%
31 Function 53 - Data Processing 176,401 195,505 19,104 11%
32 Function 61 - Community Services 122,020 124,460 2,440 2%
33 Function 71 - Debt Service 257,238 166,200 (91,038) -35%
34 8,360,471 8,322,199 $ (38,272)-0.5%
35
36 Other Resources - Local 20,000 - (20,000) -100%
37 Transfer in - Campus Activity Fund 37,090 - (37,090) -100%
38 Other Uses - Local - - - 0%
39 57,090 - $ (57,090)-100%
40
41 (75,418)$ 261,901$ $ 337,319 447%
42
43
44 FUND BALANCE BEGINNING 1,072,464 997,046 (75,418) -7%
45 997,046$ 1,258,947$ $ 261,901 26%
TOTAL OPERATING EXPENDITURES
NET OTHER SOURCES & USES
NET CHANGE TO FUND BALANCE
FUND BALANCE ENDING
TOTAL REVENUES
Tuesday, August 01, 2017
PY ESTIMATED VS CY PROPOSED
GFOA REquirements based on these numbersWESTLAKE ACADEMY
Program Summary
84
SECTION 12
85
FORECAST ASSUMPTIONS
FY 2017-2018 PROPOSED BUDGET
GENERAL FUND:
REVENUES (DECREASED 3% = $324K)
•Property Tax Rate
o Decreased $.00080 from $0.13695 to $0.13615 per $100 valuation
o General Fund Portion = $0.11133 per $100 Valuation (PY $0.12882)
o Debt Service Fund Portion = $0.02482 per $100 Valuation (PY $0.00813)
o Tax payment increase of average home value = $80 in total
o Property tax revenue in the General Fund is budgeted to be $1.205M – a decrease
of $265K (18%) due to the decision to include the Arts & Sciences debt which was
previously paid from the Visitors Association Fund to the I&S portion of the tax
•Sales Tax
o Sales tax Is budgeted to be $3.510M – an increase of $200K (6%) due to the situs
agreement anticipated with Schwab construction
o Because of the uncertainly of the funds, we are conservative with these estimates.
o Includes the Property Tax Reduction portion of the Sales tax receipts
•Building permits/inspection/plan review fees
o are budgeted to be $2.137M – a decrease of $219K (9%) due to anticipated one-
time revenues received in FY16/17; Residential fees budgeted at $1.519M and
commercial fees budgeted at $618K
•Franchise Fees
o Are budgeted to be $970K – Based on current year receipts, fees are budgeted at a
1% increase
OPERATING EXPENDITURES (INCREASED 7% = $499K)
o Payroll and Related Expenditures are budgeted at $4.123M
o Compared to FY16/17 estimated budgeted this is an increase of $428K (12%)
o Prior year payroll adopted budget was decreased by $108K for departments that
had employees who had retired or quit mid-year.
o Market band adjustments of $167K are reflected and is based on most recent salary
surveys done by the HR department.
o No Performance Pay is included
o Addition of Public Works Project Manager is proposed. Total pay is $90K with cost
being offset 100% by transfers in from the Utility Fund at $55K and from the Capital
Fund at $35K
o Medical insurance reflects a 5% increase
o Dental and Life insurance reflect a 1% increase.
o Payroll Transfers in were reduced due to the reallocation of the percentage of time
by personnel allocated to each fund.
o Transfer in from Visitor fund was decreased by approximately $15K for
Communication expenditures.
o Non-Payroll Expenditures are budgeted at $3.584M
o Compared to FY16/17 estimated budget this is an increase of $70K (2%)
86
o This includes service and supply expenditures, rent, utilities and repairs and
maintenance expenditures.
OTHER SOURCES AND USES
•Transfers In
o Budgeted at $50K – a decrease of $181K (78%)
o Due to one-time transfers from the prior year from Utility Fund for Fort Worth Impact
Fees
•Transfers Out
o Budgeted at $2.296M – an increase of $956K (71%)
o To Debt Service Fund – increased from $788K to $980K – Fire Station Debt payment
o To Capital Fund – increased from $0 to $1.015M - 100% of all anticipated Entrada
fees
o To General M&R – decreased from $550K to $300K for current year with any
additional monies being transferred as needed with approval
ENTERPRISE FUNDS
•Revenues decreased by $11K (-.3%)
•Operating expenses decreased by $798K (19%) due primarily to one-time payment of $880K
in FY16/17 to Fort Worth Water.
•Transfers out decreased $122K due to one-time transfers out to the General Fund in the prior
year for Fort Worth Impact Fees
INTERNAL SERVICE FUNDS
•Transfers In from General Fund to the GMR Fund 600
o Reduced to $300K for current year with any additional monies being transferred as
needed with approval
SPECIAL REVENUE FUNDS
•Visitors Association Fund
o Payroll Transfers Out were reduced due to reallocation of percentage of time by
personnel allocated to each fund.
o Transfer in from General fund was decreased by approximately $15K for
Communication expenditures.
o Transfers Out - reduced by A&S debt service payment - moved to tax supported
debt service
DEBT SERVICE FUNDS
•Fund 301 (Property Tax Supported Debt)
o Increased property tax by $0.016 per $100 valuation to pay an additional $162,400
for the Arts and Sciences Center in addition to the Street bond payment
CAPITAL PROJECT FUND
•Based on adopted CIP
87
FORECAST ASSUMPTIONS
FY 18-19 AND BEYOND PROJECTION
GENERAL FUND:
REVENUES
•Sales Tax Revenue
o increase 3% annually
o Schwab one-time revenue of $200K added in FY18/19 in anticipation of a situs
agreement
•Property Tax Revenue
o increase 3% annually
o Estimate value on the roll two years from date of permit for new construction–
separate line-item on forecast
o Fidelity Abatement ends FY19/20
o Deloitte Abatement ends FY21/22
o Schwab abatement proposed to start FY19/20
•Building permits/inspection/plan review fee are based on estimated schedule of annual
permits for commercial and residential growth shown separately
•Franchise Fees increase annually by 1%
•Fines and Forfeitures increase annually 1%
•All other revenues – are increased 1% to 2.5% annually based on analysis
OPERATING EXPENDITURES
•Salary and wages increase annually by 2.5% annually
•Service Expenditures increase annually by 1%
•Rent and Utilities increase annually by 1%
•Supplies increase annually by 1.5%
•Insurance increase annually by 1.25%
•Repair and Maintenance increase annually 1.25%
•Debt remains flat
•Westlake Academy reserve - $315K/annually
•Capital project impact to budget is based on proposed CIP
•Capital Outlay remains flat for FY18/19 thru FY21/22
OTHER SOURCES AND USES
•Transfers in
o from Utility Fund increase annually by 1%
•Transfers Out
o To Debt Service Fund – represents payment of additional funds needed after sales
and property tax revenues used
o To Maintenance and Replacement Funds - $200K to $300K as needed
o To Capital Fund - 100% of all Entrada fees transferred
88
UTILITY FUND
•Revenues and Other Sources increase annually by 1%
•Payroll Transfers Out to General Fund increase annually by 2.5%
•All other expenditures increase annually 1% to 2%
•Restricted Funds were added for Hillwood and Fort Worth Water
VISITOR ASSOCIATION FUND
•Revenues and Other Sources increase annually by 1%
•Entrada hotel Tax – Due to uncertainly the anticipated $400K in FY 20-21 and FY 21-22 was
removed
•Transfers Out - reduced by A&S debt service payment - moved to tax supported debt
service
•Expenditures increase annually 1%
89
ESTIMATED PROPOSED 1 2 3 4
FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22
1 Sales Tax (ongoing 100% minus one time)3.0%4,550,000 4,550,000 4,686,500 4,827,095 4,971,908 4,976,252
2 Sales Tax (audit/one-time)hard coded 0 0 0 0 0 0
3 Schwab One Time hard coded 0 400,000 400,000 0 0 0
4 Allocation to 4B linked to 4B (1,137,500)(1,237,500)(1,271,625)(1,206,774)(1,242,977)(1,244,063)
5 Allocation to ED linked to ED (102,000)(202,000)(202,000)(102,000)(102,000)(102,000)
6 Sales Tax Subtotal 3,310,500 3,510,500 3,612,875 3,518,321 3,626,931 3,630,189
7 Property Tax 3.0%1,471,000 1,205,205 1,241,361 1,278,602 1,316,960 1,318,111
Fidelity Abatement Ends 3.0%0 0 0 104,338 107,468 107,562
Deloitte Abatement Ends 3.0%0 0 0 0 0 120,621
Schwab Abatement Starts hard coded 0 0 0 (122,535)(123,760)(114,366)
8 Additional Property Tax Residential from schedule 0 0 350,326 636,178 931,562 1,213,034
9 Additional Property Tax Commercial from schedule 0 0 0 0 0 0
10 Property Tax Subtotal 1,471,000 1,205,205 1,591,687 1,896,583 2,232,230 2,644,961
13 Granada keep in GF 292,703 292,703 43,905 0 0 0
14 Entrada Xfr out to CP 256,233 711,757 1,081,871 1,081,871 1,081,871 370,114
15 Vaquero keep in GF 206,063 206,063 206,063 206,063 206,063 206,063
16 Quail Hollow keep in GF 103,031 206,063 206,063 206,063 206,063 206,063
17 Carlyle Court keep in GF 58,541 14,635 14,635 14,635 0 0
18 Terra Bella keep in GF 131,716 14,635 14,635 0 0 0
19 All Other Residential keep in GF 160,987 73,176 73,176 73,176 73,176 73,176
20 Entrada Commercial Xfr out to CP 73,854 303,567 368,872 88,839 0 0
21 Schwab Commercial keep in GF 1,000,000 314,524 0 0 314,524 314,524
22 All Other Commercial keep in GF 73,107 0 0 0 0 0
23 Permits and Fees (Building Residential & Commercial)2,356,233 2,137,122 2,009,219 1,670,646 1,881,696 1,169,939
24 Liquor Permit Fees 10 1.0%1,655 1,655 1,672 1,688 1,705 1,722
25 Other Misc Permits 10 2.5%0 0 0 0 0 0
26 Administrative Fees 10 1.0%1,860 1,860 1,879 1,897 1,916 1,936
27 Reforestation Tree Escrow 12 1.0%17,265 17,265 17,438 17,612 17,788 17,966
28 Erosion Control Fees 12 1.0%42,000 28,500 28,785 29,073 29,364 29,657
29 Re-Inspection Fees 12 2.5%200 200 205 210 215 221
30 Gas Well - Site Permits 12 2.5%0 0 0 0 0 0
31 Gas Well - Drilling Permits 12 2.5%0 0 0 0 0 0
32 Gas Well Misc Fees 12 1.0%22,950 22,950 23,180 23,411 23,645 23,882
33 Insurance & Surety Review Fees 12 1.0%3,000 3,000 3,030 3,060 3,091 3,122
34 Renewal Fees 12 1.0%1,000 1,000 1,010 1,020 1,030 1,041
35 Engineer Review/Civil 12 1.0%15,000 15,000 15,150 15,302 15,455 15,609
36 Pre-Submittal Reviews 12 2.5%0 0 0 0 0 0
37 Development Fees 12 1.0%56,690 45,590 46,046 46,506 46,971 47,441
38 Development Fees - Entrada 12 2.5%0 0 0 0 0 0
39 Contractor Registration Fees 12 1.0%16,575 16,575 16,741 16,908 17,077 17,248
40 EMS Revenues 14 1.0%100,000 100,000 101,000 102,010 103,030 104,060
41 Firefighter Equipment Fees 14 1.0%2,000 2,000 2,020 2,040 2,061 2,081
42 Fire Code Inspections 14 1.0%525 525 530 536 541 546
43 Fire Inspection Permits 14 1.0%20,625 20,625 20,831 21,040 21,250 21,462
44 Administrative Fees 15 1.0%8,975 8,975 9,065 9,155 9,247 9,339
45 Pad Site-Road Maint Fee 16 2.5%0 0 0 0 0 0
46 Misc Permits and Fees (Not Related to Building Permits)310,320 285,720 288,580 291,469 294,387 297,334
47 Flex Plan Gain 10 2.5%0 0 0 0 0 0
48 Special Events 10 2.5%0 0 0 0 0 0
49 Sales of Surplus/Scrap Items 10 1.0%600 600 606 612 618 624
50 Insurance Refund/Equity Return 10 1.0%10,405 10,405 10,509 10,614 10,720 10,827
51 Misc Revenue 10 1.0%3,400 3,400 3,434 3,468 3,503 3,538
52 Misc Revenue 12 1.0%250 250 253 255 258 260
53 Misc Revenue 16 2.5%24,220 0 0 0 0 0
54 Misc Revenue 17 2.5%0 0 0 0 0 0
55 Facility Rental 17 1.0%2,000 2,000 2,020 2,040 2,061 2,081
56 Facility Rental 19 1.0%275 275 278 281 283 286
57 Misc Income 41,150 16,930 17,099 17,270 17,443 17,617
58 AT&T/SBC 1.0%470,000 474,700 479,447 484,241 489,084 493,975
59 Verizon 1.0%45,000 45,450 45,905 46,364 46,827 47,295
60 TXU/Atmos Gas 1.0%34,500 34,845 35,193 35,545 35,901 36,260
61 Charter 1.0%14,000 14,140 14,281 14,424 14,568 14,714
62 One Source 1.0%4,800 4,850 4,899 4,947 4,997 5,047
63 Southwestern Bell 1.0%180 185 187 189 191 193
64 Tri-County Electric 1.0%300,000 303,000 306,030 309,090 312,181 315,303
65 Trinity Waste/AWIN Mgmt 1.0%42,750 43,180 43,612 44,048 44,488 44,933
66 Misc. Franchise Fees 1.0%49,640 50,135 50,636 51,143 51,654 52,171
67 Franchise Fees 960,870 970,485 980,190 989,992 999,892 1,009,891
68 Citation Revenue 1.0%727,200 727,200 734,472 741,817 749,235 756,727
69 Citation Revenue 1.5%0 0 0 0 0 0
70 Court Techology 1.0%16,320 16,320 16,483 16,648 16,815 16,983
71 Court Security 1.0%12,240 12,240 12,362 12,486 12,611 12,737
72 Warrant Fees 1.0%41,820 41,820 42,238 42,661 43,087 43,518
73 NSF Check Fees 1.0%5,240 5,240 5,292 5,345 5,399 5,453
74 Court Efficiency Fees 1.0%765 765 773 780 788 796
75 Law Enforcement Stds/Edu 1.0%685 685 692 699 706 713
76 Collection Fees 1.0%5,610 5,610 5,666 5,723 5,780 5,838
GENERAL FUND
TOWN OF WESTLAKEFIVE YEAR FORECASTAll Municipal Funds
DESCRIPTION
90
ESTIMATED PROPOSED 1 2 3 4
FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22
TOWN OF WESTLAKEFIVE YEAR FORECASTAll Municipal Funds
DESCRIPTION
77 Fines and Forfeitures (Court)809,880 809,880 817,979 826,159 834,420 842,764
78 Beverage Tax 1.0%62,500 62,500 63,125 63,756 64,394 65,038
79 Beverage Tax 1.0%0 0 0 0 0 0
80 Beverage Tax 62,500 62,500 63,125 63,756 64,394 65,038
81 Interest Income Dept 11 1.0%35,000 35,000 35,350 35,704 36,061 36,421
82 Interest Income Dept 15 1.0%1,500 1,500 1,515 1,530 1,545 1,561
83 Interest Income 36,500 36,500 36,865 37,234 37,606 37,982
84 Contributions Dept 11 1.0%35 0 0 0 0 0
85 Contributions Dept 14 1.0%0 0 0 0 0 0
86 Contributions 35 0 0 0 0 0
87 Total Revenues 9,358,988 9,034,842 9,417,620 9,311,429 9,988,998 9,715,716
88 Transfer In - UF 500 for Impact Fees 1.0%170,258 50,000 50,500 51,005 51,515 52,030
89 Transfer In - VA 220 for Dept 22 0.0%61,020 0 0 0 0 0
90 Total Transfers In 231,278 50,000 50,500 51,005 51,515 52,030
91
92 TOTAL REVENUES AND TRANSFERS IN 9,590,266 9,084,842 9,468,120 9,362,434 10,040,513 9,767,746
95
96 Payroll Salaries Full Time 41110 2.5%(2,884,203)(3,350,543)(3,434,307)(3,520,164)(3,608,168)(3,698,373)
97 Payroll Salaries Part Time 41210 2.5%(341,644)(231,976)(237,775)(243,720)(249,813)(256,058)
98 Payroll Salaries Overtime 41120 2.5%(110,543)(133,131)(136,459)(139,871)(143,368)(146,952)
99 Payroll Salaries Premium Pay 41510 2.5%(8,200)(13,560)(13,899)(14,246)(14,603)(14,968)
100 Payroll Salaries Security 41516 0.0%0 0 0 0 0 0
101 Payroll Salaries Merit Pay 41660 0.0%0 0 0 0 0 0
102 Payroll Salaries Car Allowance 41640 0.0%(21,100)(26,100)(26,100)(26,100)(26,100)(26,100)
103 Payroll Salaries Performance 41647 0.0%0 0 0 0 0 0
104 Payroll Salaries Phone Allowance 41641 0.0%(7,680)(7,680)(7,680)(7,680)(7,680)(7,680)
105 Payroll Insurance Medical 42110 7.5%(524,847)(534,266)(574,336)(617,411)(663,717)(713,496)
106 Payroll Insurance Dental 42111 1.0%(28,459)(28,588)(28,874)(29,163)(29,454)(29,749)
107 Payroll Insurance Life 42130 0.5%(25,803)(25,932)(26,062)(26,192)(26,323)(26,455)
108 Payroll Taxes SS FICA 42210 2.5%(204,361)(233,307)(239,140)(245,118)(251,246)(257,527)
109 Payroll Taxes Medicare 42220 2.5%(47,871)(54,491)(55,853)(57,250)(58,681)(60,148)
110 Payroll Taxes Unemployment 42510 1.0%(8,099)(8,656)(8,743)(8,830)(8,918)(9,007)
111 Payroll Taxes Workers Comp 42610 1.0%(38,355)(42,245)(42,667)(43,094)(43,525)(43,960)
112 Payroll Retirement TMRS 42310 2.5%(407,503)(461,214)(472,744)(484,563)(496,677)(509,094)
113 Payroll Retirement ICMA 42311 0.0%(27,270)(27,270)(27,270)(27,270)(27,270)(27,270)
114 Payroll Transfers In Dept 11 2.5%158,726 161,194 165,224 169,354 173,588 177,928
115 Payroll Transfers In Dept 16 2.5%256,295 351,158 359,937 368,935 378,159 387,613
116 Payroll Transfers In Dept 17 2.5%56,391 56,625 58,041 59,492 60,979 62,503
117 Payroll Transfers In Dept 18 2.5%240,711 198,945 203,919 209,017 214,242 219,598
118 Payroll Transfers In Dept 19 2.5%45,467 45,467 46,604 47,769 48,963 50,187
119 Payroll Transfers In Dept 21 2.5%11,500 12,077 12,379 12,688 13,006 13,331
120 Payroll Transfers In Dept 22 2.5%222,511 230,309 236,067 241,968 248,018 254,218
121 Total Payroll and Related (3,694,337)(4,123,184)(4,249,740)(4,381,448)(4,518,589)(4,661,458)
122
123 General Services Dept 10 1.0%(444,078)(359,563)(363,159)(366,790)(370,458)(374,163)
124 Administrative Dept 11 1.0%(29,524)(29,524)(29,819)(30,117)(30,419)(30,723)
125 Planning & Development Dept 12 1.0%(307,740)(282,850)(285,679)(288,535)(291,421)(294,335)
126 Town Secretary Dept 13 1.0%(45,360)(52,990)(53,520)(54,055)(54,596)(55,142)
127 Fire Department Dept 14 1.0%(96,815)(98,920)(99,909)(100,908)(101,917)(102,937)
128 Municipal Court Dept 15 1.0%(99,901)(99,901)(100,900)(101,909)(102,928)(103,957)
129 Public Works Dept 16 1.0%(100,230)(67,930)(68,609)(69,295)(69,988)(70,688)
130 Facilities Maintenance Dept 17 1.0%(56,485)(31,135)(56,485)(56,485)(56,485)(56,485)
131 Finance Department Dept 18 1.0%(53,851)(35,186)(35,538)(35,893)(36,252)(36,615)
132 Parks & Recreations Dept 19 1.0%(35,240)(80,240)(35,240)(35,240)(35,240)(35,240)
133 Information Technology Dept 20 1.0%(114,220)(121,285)(122,498)(123,723)(124,960)(126,210)
134 Human Resources Dept 21 1.0%(29,115)(29,115)(29,406)(29,700)(29,997)(30,297)
135 Communications Dept 22 1.0%(8,235)(8,235)(8,317)(8,401)(8,485)(8,569)
136 Police Services Dept 23 1.5%(888,486)(932,910)(946,904)(961,107)(975,524)(990,157)
137 Total Service Expenditures (2,309,280)(2,229,784)(2,235,983)(2,262,160)(2,288,670)(2,315,517)
138 Office Rent 0.0%(159,600)(234,500)(354,200)(354,200)(354,200)(354,200)
139 Electric Service 0.0%(27,440)(35,000)(35,000)(35,000)(35,000)(35,000)
140 Electric Service - Fire Station Dept 14 1.0%(4,430)(4,430)(4,474)(4,519)(4,564)(4,610)
141 Electric Service - Public Works Dept 16 1.0%(2,595)(2,595)(2,621)(2,647)(2,674)(2,700)
142 Electric Service - Parks/Rec Dept 19 1.0%(8,780)(8,780)(8,868)(8,956)(9,046)(9,137)
143 Electric Service - Parchman Dept 10 1.0%(80)(80)(81)(82)(82)(83)
144 Telephone Service - Town Dept 10 1.0%(3,380)(3,380)(3,414)(3,448)(3,482)(3,517)
145 Telephone Service - Fire Dept Dept 14 1.0%(4,295)(4,295)(4,338)(4,381)(4,425)(4,469)
146 Telephone Service - Court Dept 15 1.5%0 0 0 0 0 0
147 Internet Service - Town Dept 10 1.0%(7,661)(7,661)(7,738)(7,815)(7,893)(7,972)
148 Internet Service - Fire Dept Dept 14 1.0%(4,315)(4,315)(4,358)(4,402)(4,446)(4,490)
149 Internet Service - Court Dept 15 1.5%0 0 0 0 0 0
150 Internet Service - Facilities Dept 17 1.0%(500)(800)(808)(816)(824)(832)
151 Water Service - Town Dept 10 1.5%0 0 0 0 0 0
152 Water Service - Fire Dept Dept 14 1.0%(2,450)(2,450)(2,475)(2,499)(2,524)(2,549)
153 Water Service - ROW Irrigation Dept 16 1.0%(135,000)0 0 0 0 0
154 Water Service - ROW Irrigation Dept 19 1.0%0 (132,000)(133,320)(134,653)(136,000)(137,360)
155 Water Service - Parks & Rec Dept 19 1.0%(855)(855)(864)(872)(881)(890)
156 Gas Service - Town Dept 10 1.5%0 0 0 0 0 0
157 Gas Service - Fire Station Dept 14 1.0%(1,605)(1,605)(1,621)(1,637)(1,654)(1,670)
91
ESTIMATED PROPOSED 1 2 3 4
FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22
TOWN OF WESTLAKEFIVE YEAR FORECASTAll Municipal Funds
DESCRIPTION
158 Total Rent & Utilities (362,986)(442,746)(564,178)(565,928)(567,696)(569,480)
159 General Services dept 10 1.5%(28,459)(28,459)(28,886)(29,319)(29,759)(30,205)
160 Administrative dept 11 1.5%(2,534)(2,534)(2,572)(2,611)(2,650)(2,689)
161 Planning & Development dept 12 1.5%(29,290)(29,290)(29,729)(30,175)(30,628)(31,087)
162 Town Secretary dept 13 1.5%(3,775)(3,775)(3,832)(3,889)(3,947)(4,007)
163 Fire Department dept 14 1.5%(69,945)(102,945)(69,945)(69,945)(69,945)(69,945)
164 Municipal Court dept 15 1.5%(13,076)(12,916)(13,110)(13,306)(13,506)(13,709)
165 Public Works dept 16 1.5%(4,510)(4,510)(4,578)(4,646)(4,716)(4,787)
166 Facilities Maintenance dept 17 1.5%(29,180)(33,930)(29,180)(29,180)(29,180)(29,180)
167 Finance Department dept 18 1.5%(6,660)(6,660)(6,760)(6,861)(6,964)(7,069)
168 Parks & Recreations dept 19 1.5%(9,645)(9,645)(9,790)(9,937)(10,086)(10,237)
169 Information Technology dept 20 1.5%(5,850)(5,850)(5,938)(6,027)(6,117)(6,209)
170 Human Resources dept 21 1.5%(4,270)(4,270)(4,334)(4,399)(4,465)(4,532)
171 Communications dept 22 1.5%(7,500)(7,500)(7,613)(7,727)(7,843)(7,960)
172 Total Supplies (214,694)(252,284)(216,265)(218,022)(219,806)(221,616)
173 General Services dept 10 1.25%(20,085)(20,085)(20,336)(20,590)(20,848)(21,108)
174 Planning & Development dept 12 1.25%(500)(500)(506)(513)(519)(525)
175 Fire Department dept 14 1.25%(11,905)(11,905)(12,054)(12,204)(12,357)(12,512)
176 Municipal Court dept 15 1.25%(545)(545)(552)(559)(566)(573)
177 Facilities Maintenance dept 17 1.25%(590)(590)(597)(605)(612)(620)
178 Total Insurance (33,625)(33,625)(34,045)(34,471)(34,902)(35,338)
179 Fire Department dept 14 1.25%(54,345)(54,345)(55,024)(55,712)(56,409)(57,114)
180 Municipal Court dept 15 1.25%(300)(300)(304)(308)(311)(315)
181 Public Works dept 16 1.25%(38,295)(38,295)(38,774)(39,258)(39,749)(40,246)
182 Facilities Maintenance dept 17 1.25%(34,225)(67,340)(68,182)(69,034)(69,897)(70,771)
183 Parks & Recreations dept 19 1.25%(82,300)(82,300)(83,329)(84,370)(85,425)(86,493)
184 Total Repair & Maintenance (209,465)(242,580)(245,612)(248,682)(251,791)(254,938)
185 General Service Debt dept 10 0.00%(36,680)(36,680)(36,680)(36,680)(36,680)(36,680)
186 K-5 Westlake Reserve Slots dept 10 0.00%(315,000)(315,000)(315,000)(315,000)(315,000)(315,000)
187 Total Debt (351,680)(351,680)(351,680)(351,680)(351,680)(351,680)
188 Capital Operating Impact - Facilities hard coded 0 0 (10,747)(136,692)(140,763)(144,956)
189 Capital Operating Impact - Parks/Rec hard coded 0 0 0 (4,000)(4,120)(4,244)
190 Capital Operating Impact - Roads hard coded 0 0 (400)(400)(10,400)(15,788)
191 Capital Operating Impact - Trail/Road hard coded 0 0 0 0 0 0
192 Total Capital Operating Impact 0 0 (11,147)(141,092)(155,283)(164,988)
193 Planning & Development dept 12 0.00%(490)(490)(490)(490)(490)(490)
194 Fire Department dept 14 0.00%(27,900)(27,900)(27,900)(27,900)(27,900)(27,900)
195 Municipal Court dept 15 0.00%0 0 0 0 0 0
196 Public Works dept 16 0.00%(500)(500)(500)(500)(500)(500)
197 Facilities Maintenance dept 17 0.00%0 0 0 0 0 0
198 Finance Department dept 18 0.00%(1,800)(1,800)(1,800)(1,800)(1,800)(1,800)
199 Parks & Recreations dept 19 0.00%(1,000)(1,000)(1,000)(1,000)(1,000)(1,000)
200 Total Capital Outlay (31,690)(31,690)(31,690)(31,690)(31,690)(31,690)
201 Total Expenditures non-payroll)(3,513,420)(3,584,389)(3,690,601)(3,853,725)(3,901,517)(3,945,247)
202
203 Transfer Out - GMR 600 linked to GMR (550,550)(300,000)(300,000)(200,000)(200,000)(200,000)
204 Transfer Out - VMR 605 linked to VMR 0 0 (125,000)(110,000)0 0
205 Transfer Out - DS 300 linked to DS (788,781)(980,770)(938,411)(1,003,744)(962,681)(969,019)
206 Transfers Out - Operating (1,339,331)(1,280,770)(1,363,411)(1,313,744)(1,162,681)(1,169,019)
207 Transfer Out - CP 410 (Entrada)linked to dept12 XO to CP 0 (1,015,324)(1,450,742)(1,170,710)(1,081,871)(370,114)
208 Keep Entrada Permit Fees 0 0 0 0 0 0
209 Transfers Out - Non Operating 0 (1,015,324)(1,450,742)(1,170,710)(1,081,871)(370,114)
210 Total Transfers Out (1,339,331)(2,296,094)(2,814,153)(2,484,453)(2,244,551)(1,539,133)
211
212 TOTAL PAYROLL, EXPENDITURES AND TRANSFERS OUT (8,547,083)(10,003,667)(10,754,493)(10,719,627)(10,664,656)(10,145,838)
215
216 NET CHANGE TO FUND BALANCE 1,043,183 (918,826)(1,286,374)(1,357,193)(624,143)(378,093)
217 Beginning Fund Balance 8,553,121 9,596,304 8,677,479 7,391,105 6,033,912 5,409,769
218 Ending Fund Balance 9,596,304 8,677,479 7,391,105 6,033,912 5,409,769 5,031,677
219 Restricted/Committed/Assigned 0.0%553,034 553,034 283,146 283,146 283,146 283,146
220 Unassigned Ending Balance 9,043,270 8,124,444 7,107,959 5,750,766 5,126,623 4,748,531
221 Operating Cost per Day 23,417 24,626 25,490 26,161 26,254 26,783
222 Operating Days 386 330 279 220 195 177
223 % of Operating Expenditures without transfers 257%227%193%149%131%120%
226
227
228
229
230 Section Sales 0.0%11,125 11,125 11,125 11,125 11,125 11,125
231 Perpetual Care - Section 15%0.0%150 150 150 150 150 150
232 Perpetual Care-interment 100 %0.0%50 50 50 50 50 50
233 Marker Sales 0.0%250 250 250 250 250 250
234 Private Contributions 0.0%50,000 0 0 0 0 0
235 Contractor Fee 0.0%350 350 350 350 350 350
236 Interest Income 1.0%900 900 909 918 927 937
237 Total Revenues 62,825 12,825 12,834 12,843 12,852 12,862
240
241 Attorney - Boyle & Lowry 0.0%(240)(240)(240)(240)(240)(240)
242 Engineering 0.0%0 (12,000)0 0 0 0
CEMETERY FUND
92
ESTIMATED PROPOSED 1 2 3 4
FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22
TOWN OF WESTLAKEFIVE YEAR FORECASTAll Municipal Funds
DESCRIPTION
243 Contract Services 0.0%(225)(225)(225)(225)(225)(225)
244 Irrigation R&M 0.0%(395)(5,000)(5,000)(5,000)(5,000)(5,000)
245 Contract Landscaping 0.0%(4,800)(6,000)(6,000)(6,000)(6,000)(6,000)
246 Computer Eqpmt/Software 0.0%(225)(350)(350)(350)(350)(350)
247 Grounds R&M 0.0%(225)(2,000)(2,000)(2,000)(2,000)(2,000)
248 Training/Meetings/Seminars 0.0%(225)(225)(225)(225)(225)(225)
249 Dues & Memberships 0.0%(75)(75)(75)(75)(75)(75)
250 Land Improvements 0.0%0 (5,000)0 0 0 0
251 Cost of Sales - Cemetery Lots 0.0%(700)(700)(700)(700)(700)(700)
252 Total Expenditures (7,110)(31,815)(14,815)(14,815)(14,815)(14,815)
255
256 NET CHANGE TO FUND BALANCE 55,715 (18,990)(1,981)(1,972)(1,963)(1,953)
257 Beginning Fund Balance 158,238 213,953 194,963 192,982 191,010 189,047
258 Ending Fund Balance 213,953 194,963 192,982 191,010 189,047 187,094
259 Restricted/Committed/Assigned 213,953 194,963 192,982 191,010 189,047 187,094
260 Unassigned Ending Balance 0 0 0 0 0 0
261
262
263
264
265
266 Water Revenue 1.0%2,541,490 2,592,320 2,618,243 2,644,426 2,670,870 2,697,579
267 DS - Hillwood Service Area 1.0%48,000 48,000 48,480 48,965 49,454 49,949
268 DS - Town Service Area Accts 1.0%43,000 43,000 43,430 43,864 44,303 44,746
269 Waste Management 1.0%5,305 5,415 5,469 5,524 5,579 5,635
270 Sewer Revenue - Westlake 1.0%793,860 809,740 817,837 826,016 834,276 842,619
271 Sewer Revenue - Keller 1.0%1,260 1,285 1,298 1,311 1,324 1,337
272 Water Tap Fees 1.0%31,410 32,040 32,360 32,684 33,011 33,341
273 Sewer Tap Fees 1.0%10,875 11,095 11,206 11,318 11,431 11,546
274 Fort Worth Impact fees 1.0%78,980 50,000 50,500 51,005 51,515 52,030
275 Charge For Service Total 3,554,180 3,592,895 3,628,824 3,665,112 3,701,763 3,738,781
276 Meter Repair & Replacement 1.0%18,200 18,200 18,382 18,566 18,751 18,939
277 Interest Income 1.0%11,620 11,620 11,736 11,854 11,972 12,092
278 Duct Bank Leases 1.0%30,965 30,965 31,275 31,587 31,903 32,222
279 TRA Wastewater Settle-Up 1.0%50,000 50,000 50,500 51,005 51,515 52,030
280 Duct Bank Permit Fees - other 1.0%0 74,400 75,144 75,895 76,654 77,421
281 Duct Bank Permit Fees - Vaquer 2.0%18,600 0 0 0 0 0
282 Duct Bank Permit Fees - Terra 2.0%12,400 0 0 0 0 0
283 Duct Bank Permit Fees - Granada 2.0%34,100 0 0 0 0 0
284 Duct Bank Permit Fees - Carlyle 2.0%9,300 0 0 0 0 0
285 Insurance Refund/Equity Return 1.0%750 750 758 765 773 780
286 Misc Reimbursements 1.0%3,020 3,020 3,050 3,081 3,112 3,143
287 Misc Revenue Dept 16 1.0%8,000 8,000 8,080 8,161 8,242 8,325
288 Administrative CC Fee 1.0%5,460 5,460 5,515 5,570 5,625 5,682
289 Total Misc Income 202,415 202,415 204,439 206,484 208,548 210,634
290 Total Revenues & Transfers In 3,756,595 3,795,310 3,833,263 3,871,596 3,910,312 3,949,415
293
294 PR Transfer Out 1.0%(437,145)(482,700)(487,527)(492,402)(497,326)(502,300)
295 PR Retirement (Pension)2.5%0 0 0 0 0 0
296 PR Compensated Absences 2.5%0 0 0 0 0 0
297 Total Payroll and Related (437,145)(482,700)(487,527)(492,402)(497,326)(502,300)
298 Office Rent 0.0%(34,200)(50,250)(75,900)(75,900)(75,900)(75,900)
299 Electric Service 0.0%(5,880)(7,500)(7,500)(7,500)(7,500)(7,500)
300 Telephone Service Dept 10 1.5%(724)(724)(735)(746)(757)(768)
301 Telephone Service Dept 16 1.5%(1,000)(1,000)(1,015)(1,030)(1,046)(1,061)
302 Water - Pump Station Dept 16 1.5%(20,600)(20,600)(20,909)(21,223)(21,541)(21,864)
303 Electric - Pump Station Dept 16 1.5%(72,100)(72,100)(73,182)(74,279)(75,393)(76,524)
304 Electric - Lift Station Dept 16 1.5%(2,680)(2,680)(2,720)(2,761)(2,802)(2,844)
305 Internet Service Dept 10 1.5%(1,645)(1,645)(1,670)(1,695)(1,720)(1,746)
306 Total Rent & Utilities (138,829)(156,499)(183,630)(185,134)(186,660)(188,209)
307 Computer Hardware/Software 1.5%0 (1,000)(1,015)(1,030)(1,046)(1,061)
308 Furniture & Fixtures 1.5%0 0 0 0 0 0
309 Mechanical Equipment 1.5%(1,000)(1,000)(1,015)(1,030)(1,046)(1,061)
310 Motor Vehicles 1.5%0 0 0 0 0 0
311 Water Meters /Equipment 1.5%(10,000)(10,000)(10,150)(10,302)(10,457)(10,614)
312 Water Taps 1.5%(8,780)(8,780)(8,912)(9,045)(9,181)(9,319)
313 Total Capital Outlay (19,780)(20,780)(21,092)(21,408)(21,729)(22,055)
314 Insurance General Liability 1.5%(980)(980)(995)(1,010)(1,025)(1,040)
315 Insurance Automobile 1.5%(1,700)(1,700)(1,726)(1,751)(1,778)(1,804)
316 Insurance Property 1.5%(6,070)(6,070)(6,161)(6,253)(6,347)(6,442)
317 Total lnsurance (8,750)(8,750)(8,881)(9,014)(9,150)(9,287)
318 Meter Repair & Replacement 2.0%0 0 0 0 0 0
319 Water/Sewer R&M 2.0%0 0 0 0 0 0
320 Vehicle R&M 2.0%0 0 0 0 0 0
321 WaterTower Landscape R&M 1.5%(7,000)(7,000)(7,105)(7,212)(7,320)(7,430)
322 Water Main R&M 1.5%(42,545)(42,545)(43,183)(43,831)(44,488)(45,156)
323 Water Tower R&M 1.5%(1,000)(1,000)(1,015)(1,030)(1,046)(1,061)
324 Sewer Main R&M 1.5%(18,000)(18,000)(18,270)(18,544)(18,822)(19,105)
325 Pump Station Landscape R&M 1.5%(13,500)(13,500)(13,703)(13,908)(14,117)(14,328)
UTILITY FUND
93
ESTIMATED PROPOSED 1 2 3 4
FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22
TOWN OF WESTLAKEFIVE YEAR FORECASTAll Municipal Funds
DESCRIPTION
326 Lift Station R&M 1.5%(6,000)(6,000)(6,090)(6,181)(6,274)(6,368)
327 Instrument R&M 1.5%(9,750)(9,750)(9,896)(10,045)(10,195)(10,348)
328 Ground Storage Tank R&M 1.5%(2,300)(2,300)(2,335)(2,370)(2,405)(2,441)
329 Generator R&M 1.5%(4,000)(4,000)(4,060)(4,121)(4,183)(4,245)
330 Pump Station R&M 1.5%(22,500)(22,500)(22,838)(23,180)(23,528)(23,881)
331 Duct Bank R&M 1.5%(7,940)(7,940)(8,059)(8,180)(8,303)(8,427)
332 FM1938 ROW Landscape 1.5%0 0 0 0 0 0
333 Meter Repair & Replacement 1.5%(21,000)(21,000)(21,315)(21,635)(21,959)(22,289)
334 Grounds R&M 1.5%0 0 0 0 0 0
335 Water/Sewer R&M 1.5%0 0 0 0 0 0
336 Audio Visual R&M 1.5%0 0 0 0 0 0
337 Vehicle R&M 1.5%(1,000)(1,000)(1,015)(1,030)(1,046)(1,061)
338 Total Repair and Maintenance lnsurance (156,535)(156,535)(158,883)(161,266)(163,685)(166,141)
339 Bank Service Charges 1.5%(3,750)(3,750)(3,806)(3,863)(3,921)(3,980)
340 Engineering 1.5%(775)(775)(787)(798)(810)(823)
341 Water Utility Engineering 1.5%(37,555)(37,555)(38,118)(38,690)(39,270)(39,860)
342 Auditor 1.5%(5,750)(5,750)(5,836)(5,924)(6,013)(6,103)
343 Misc Legal 1.5%0 0 0 0 0 0
344 Attorney - Boyle & Lowry 1.5%(15,000)(15,000)(15,225)(15,453)(15,685)(15,920)
345 Attorney - Lloyd Gosselink 1.5%(10,000)(10,000)(10,150)(10,302)(10,457)(10,614)
346 Contract Labor 1.5%(5,000)(5,000)(5,075)(5,151)(5,228)(5,307)
347 Contract Services 1.5%(7,860)(7,860)(7,978)(8,098)(8,219)(8,342)
348 TRA-Wastewater Treatment 1.5%(340,000)(340,000)(345,100)(350,277)(355,531)(360,864)
349 Southlake-Wastewater Treatment 1.5%(500,000)(500,000)(507,500)(515,113)(522,839)(530,682)
350 Testing-Water/Bacteria/Rgltry 1.5%(30,000)(30,000)(30,450)(30,907)(31,370)(31,841)
351 Utility Billing 1.5%(15,000)(15,000)(15,225)(15,453)(15,685)(15,920)
352 Line Location 1.5%(5,660)(5,660)(5,745)(5,831)(5,919)(6,007)
353 Application Software Maint.1.5%(10,750)(10,750)(10,911)(11,075)(11,241)(11,410)
354 Keller Waste Water 1.5%(1,300)(1,300)(1,320)(1,339)(1,359)(1,380)
355 Mobile Phone 1.5%(1,000)(1,000)(1,015)(1,030)(1,046)(1,061)
356 Misc Rental/Lease 1.5%(500)(500)(508)(515)(523)(531)
357 Travel Airfare 1.5%(800)(800)(812)(824)(837)(849)
358 Travel Car Rental/Parking 1.5%(100)(100)(102)(103)(105)(106)
359 Travel Lodging 1.5%(1,000)(1,000)(1,015)(1,030)(1,046)(1,061)
360 Travel Meals 1.5%(135)(135)(137)(139)(141)(143)
361 Travel Mileage 1.5%0 0 0 0 0 0
362 Training/Seminars/Meetings 1.5%(3,000)(3,000)(3,045)(3,091)(3,137)(3,184)
363 Dues & Subscriptions 1.5%(985)(1,500)(1,523)(1,545)(1,569)(1,592)
364 Printing 1.5%(1,130)(1,130)(1,147)(1,164)(1,182)(1,199)
365 Licenses/Registrations 1.5%0 (700)(711)(721)(732)(743)
366 Courier Service 1.5%(200)(200)(203)(206)(209)(212)
367 Total Service (997,250)(998,465)(1,013,442)(1,028,644)(1,044,073)(1,059,734)
368 Computer Eqpmt/Software 2.0%0 0 0 0 0 0
369 Safety Supplies 1.5%(100)(100)(102)(103)(105)(106)
370 Misc Hand Tools 1.5%(1,000)(1,000)(1,015)(1,030)(1,046)(1,061)
371 Chemical Supplies 1.5%(350)(350)(355)(361)(366)(371)
372 Office Supplies 1.5%(1,550)(1,550)(1,573)(1,597)(1,621)(1,645)
373 Office Equipment 1.5%0 0 0 0 0 0
374 Postage & Shipping 1.5%(400)(400)(406)(412)(418)(425)
375 Books & Printed Materials 1.5%0 0 0 0 0 0
376 Misc. Supplies 1.5%0 0 0 0 0 0
377 Meeting Expense 1.5%0 0 0 0 0 0
378 Vehicle Fuel 1.5%(3,000)(3,000)(3,045)(3,091)(3,137)(3,184)
379 Uniforms 1.5%(500)(500)(508)(515)(523)(531)
380 Capital Operating Impact - Utility fixed 0 0 (26,735)(27,537)(28,363)(34,036)
381 Total Supplies (6,900)(6,900)(33,739)(34,646)(35,578)(41,359)
382 Water Purchases 2.0%(934,500)(934,500)(953,190)(972,254)(991,699)(1,011,533)
383 Water Service Charge 2.0%(600)(600)(612)(624)(637)(649)
384 Peak Payment 2.0%(409,500)(409,500)(417,690)(426,044)(434,565)(443,256)
385 Total Water Purchase Expense (1,344,600)(1,344,600)(1,371,492)(1,398,922)(1,426,900)(1,455,438)
386 Transfer Out - UMR Fund 510 linked to UMR (100,000)(100,000)(25,000)(25,000)(25,000)(25,000)
387 Transfer Out - VMR Fund 505 linked to VMR (8,335)(6,250)(6,250)(6,250)(6,250)(6,250)
388 Transfer Out - GF 100 Impact Fees linked to Impact (170,258)(50,000)(50,500)(51,005)(51,515)(52,030)
389 Total Transfers Out (278,593)(156,250)(81,750)(82,255)(82,765)(83,280)
390 Fort Worth Payment - Phase I 0.0%(888,160)0 0 0 0 0
391 DS - Principal Keller OH Storage ends 20/21 (104,145)(104,143)(108,950)(113,756)(120,165)0
392 DS - Interest Keller OH Storage ends 20/21 (16,395)(16,395)(11,986)(7,393)(2,523)0
393 DS - Hillwood Service Area 1.0%(48,240)(48,240)(48,722)(49,210)(49,702)(49,702)
394 DS - Town Service Area 1.0%(43,215)(43,215)(43,647)(44,084)(44,524)(44,524)
395 DS - Principal - 2013 CO Ground Storage Tank from schedule (22,000)(22,000)(22,550)(23,650)(23,650)(24,750)
396 DS - Interest - 2013 CO Ground Storage Tank from schedule (33,465)(33,021)(32,576)(32,114)(31,582)(30,977)
397 Total Debt (1,155,620)(267,014)(268,431)(270,206)(272,146)(149,953)
398 Total Expenses & Transfers Out (4,544,002)(3,598,493)(3,628,867)(3,683,897)(3,740,013)(3,677,755)
401
402 NET CHANGE TO FUND BALANCE (787,407)196,817 204,396 187,699 170,298 271,659
403 Beginning Fund Balance 1,121,826 334,419 531,236 735,632 923,331 1,093,629
404 Ending Fund Balance 334,419 531,236 735,632 923,331 1,093,629 1,365,289
405 Restricted/Committed/Assigned FW Water/ Hillwood 0 888,000 1,670,000 1,670,000 1,670,000 1,670,000
406 Restricted/Committed/Assigned Deposits 1.5%235,555 240,266 245,071 249,973 254,972 260,072
94
ESTIMATED PROPOSED 1 2 3 4
FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22
TOWN OF WESTLAKEFIVE YEAR FORECASTAll Municipal Funds
DESCRIPTION
407 98,864 (597,030)(1,179,439)(996,642)(831,343)(564,783)
408 Operating Expenses 4,245,629 3,421,463 3,526,025 3,580,234 3,635,519 3,572,420
409 Operating Cost Per Day 11,632 9,374 9,660 9,809 9,960 9,787
410 Operating Days 29 57 76 94 110 139
411
412
413
414
415
416 Interest Income vision 3,400 3,400 3,400 3,400 3,400 3,400
417 Transfers In from UF 500 vision 100,000 100,000 25,000 25,000 25,000 25,000
418 Total Revenues & Transfers In 103,400 103,400 28,400 28,400 28,400 28,400
421
422 Sewer Easement Cleaning Machine vision (45,000)(45,000)0 0 0 0
423 Repaint Ground Storage Tank vision (100,000)(100,000)0 0 0 0
424 Pump Station Equipment vision 0 (100,000)0 0 0 0
425 Total Expenditures & Transfers Out (145,000)(245,000)0 0 0 0
428
429 NET CHANGE TO FUND BALANCE (41,600)(141,600)28,400 28,400 28,400 28,400
430 Beginning Fund Balance 722,939 681,339 539,739 568,139 596,539 624,939
431 Ending Fund Balance 681,339 539,739 568,139 596,539 624,939 653,339
432 Restricted/Committed/Assigned 681,339 539,739 568,139 596,539 624,939 653,339
433 Unassigned Ending Balance (projected)0 0 0 0 0 0
434
435
436
437
438
439 Contributions vision 500 0 0 0 0 0
440 Environmental Upgrade Grant vision 0 0 0 0 0 0
441 Firefighter Equipment Fees vision 6,000 6,000 6,000 6,000 6,000 6,000
442 Interest Income vision 1,550 1,550 1,750 1,750 1,750 1,750
443 Transfer in from CP vision 0 0 0 0 0 0
444 Transfer in from GF vision 550,550 300,000 300,000 200,000 200,000 200,000
445 Total Revenues & Transfers In 558,600 307,550 307,750 207,750 207,750 207,750
448
449 Public Works dept 16 vision 0 0 0 0 0 0
450 Facilities WA dept 17 vision (279,565)(200,000)(205,000)(151,000)(208,000)(208,000)
451 Parks and Rec dept 19 vision (22,000)(32,000)(20,000)(20,000)(20,000)(20,000)
452 I.T. Department dept 20 vision (125,210)(30,000)(245,000)(67,500)(155,000)(67,500)
453 Facilities Town dept 26 vision (809,800)(25,000)(27,000)(27,000)(27,000)(27,000)
454 Total Expenditures & Transfers Out (1,236,575)(287,000)(497,000)(265,500)(410,000)(322,500)
457
458 NET CHANGE TO FUND BALANCE (677,975)20,550 (189,250)(57,750)(202,250)(114,750)
459 Beginning Fund Balance 228,768 (449,207)(428,657)(617,907)(675,657)(877,907)
460 Ending Fund Balance (449,207)(428,657)(617,907)(675,657)(877,907)(992,657)
461 Restricted/Committed/Assigned (449,207)(428,657)(617,907)(675,657)(877,907)(992,657)
462 Unassigned Ending Balance 0 0 0 0 0 0
463
464
465
466
467
468 Sales of Surplus vision 8,650 0 0 0 0 0
469 Insurance Proceeds vision 0 0 0 0 0 0
470 Interest Earned vision 35 35 0 0 0 0
471 Transfer in from UF vision 16,670 6,250 6,250 6,250 6,250 6,250
472 Total Revenues & Transfers In 25,355 6,285 6,250 6,250 6,250 6,250
475
476 Public Works Vehicle dept 16 vision 0 0 0 0 (50,000)0
477 Total Expenditures & Transfers Out 0 0 0 0 (50,000)0
480
481 NET CHANGE TO FUND BALANCE 25,355 6,285 6,250 6,250 (43,750)6,250
482 Beginning Fund Balance 0 25,355 31,640 37,890 44,140 390
483 Ending Fund Balance 25,355 31,640 37,890 44,140 390 6,640
484 Restricted/Committed/Assigned 25,355 31,640 37,890 44,140 390 6,640
485 Unassigned Ending Balance 0 0 0 0 0 0
486
487
488
489
490
491 Sales of Surplus Dept 16 vision 0 0 0 0 0 0
492 Sales of Surplus Dept 14 vision 4,765 0 0 0 0 0
493 WA/WAF Contribution for Buses vision 118,160 0 0 150,000 0 0
494 Insurance Proceeds vision 8,715 0 0 0 0 0
495 Interest Earned vision 825 825 200 200 200 0
496 Transfer In from GF vision 0 0 125,000 110,000 0 0
497 Transfer in from UF vision 0 0 0 0 0 0
VEHICLE MAINT & REP (Utility)
GENERAL MAINT & REPLACEMENT
VEHICLE MAINT & REP (General)
UTILITY MAINT & REPLACEMENT
Unassigned Ending Balance
95
ESTIMATED PROPOSED 1 2 3 4
FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22
TOWN OF WESTLAKEFIVE YEAR FORECASTAll Municipal Funds
DESCRIPTION
498 Total Revenues & Transfers In 132,465 825 125,200 260,200 200 0
501
502 Academy Buses dept 10 vision (118,160)0 0 (150,000)0 0
503 Fire Dept Vehicles dept 14 vision (55,000)0 (250,000)(60,000)0 0
504 Court Vehicle dept 15 vision 0 0 0 0 0 0
505 Facilities Vehicles dept 17 vision 0 0 0 (50,000)0 0
506 Total Expenditures & Transfers Out (173,160)0 (250,000)(260,000)0 0
509
510 NET CHANGE TO FUND BALANCE (40,695)825 (124,800)200 200 0
511 Beginning Fund Balance 177,574 136,879 137,704 12,904 13,104 13,304
512 Ending Fund Balance 136,879 137,704 12,904 13,104 13,304 13,304
513 Restricted/Committed/Assigned 136,879 137,704 12,904 13,104 13,304 13,304
514 Unassigned Ending Balance 0 0 0 0 0 0
515
516
517
518
519
520 Hotel Tax (Marriott) 1.0%772,000 779,720 787,517 795,392 803,346 811,380
521 Hotel Tax (Deloitte)1.0%32,640 32,640 32,966 33,296 33,629 33,965
522 Entrada Hotel Tax hard coded 0 0 0 0 0 0
523 Total Hotel Tax 804,640 812,360 820,484 828,688 836,975 845,345
524 Interest Income 10 1.0%3,900 3,900 3,939 3,978 4,018 4,058
525 Insur Refund/Equity Return 10 1.0%835 835 843 852 860 869
526 Administrative Fees 00 1.0%10 0 0 0 0 0
527 Misc Revenue 26 1.0%250 250 253 255 258 260
528 Grants 22 1.0%1,700 0 0 0 0 0
529 Membership Fees 24 1.0%1,775 1,775 1,793 1,811 1,829 1,847
530 Special Events Revenue 24 1.0%3,250 3,250 3,283 3,315 3,348 3,382
531 Sales of Printed Material 24 1.0%200 200 202 204 206 208
532 Sponsors 24 1.0%3,000 3,000 3,030 3,060 3,091 3,122
533 Total Other Revenues 14,920 13,210 13,342 13,476 13,610 13,746
534 Total Revenues & Transfers In 819,560 825,570 833,826 842,164 850,586 859,091
537
538 Office Rent 1.0%(34,200)(50,250)(75,900)(75,900)(75,900)(76,659)
539 Electric Service 1.0%(5,880)(7,500)(7,500)(7,500)(7,500)(7,575)
540 Telephone Service 1.0%(624)(624)(630)(637)(643)(649)
541 Internet Service 1.0%(1,415)(1,415)(1,429)(1,443)(1,458)(1,472)
542 Total Rent and Utilities (42,119)(59,789)(85,459)(85,480)(85,501)(86,356)
543 PR Transfer Out 1.0%(480,002)(518,510)(523,695)(528,932)(534,221)(539,564)
544 Total PR Transfer Out (480,002)(518,510)(523,695)(528,932)(534,221)(539,564)
545 General Services dept 10 1.0%(144,075)(144,075)(145,516)(146,971)(148,441)(149,925)
546 Communications dept 22 1.0%(109,680)(137,280)(138,653)(140,039)(141,440)(142,854)
547 Historical Board dept 24 1.0%(7,405)(7,405)(7,479)(7,554)(7,629)(7,706)
548 Public Arts dept 25 1.0%(35,000)(30,200)(30,502)(30,807)(31,115)(31,426)
549 Arbor Day dept 26 1.0%0 (2,500)(2,525)(2,550)(2,576)(2,602)
550 Total Service (296,160)(321,460)(324,675)(327,921)(331,201)(334,513)
551 General Services dept 10 1.0%0 (10,000)(10,100)(10,201)(10,303)(10,406)
552 Communications dept 22 0.0%0 0 0 0 0 0
553 Historical Board dept 24 0.0%0 0 0 0 0 0
554 Public Arts dept 25 0.0%0 0 0 0 0 0
555 Arbor Day dept 26 0.0%0 0 0 0 0 0
556 Total Supplies 0 (10,000)(10,100)(10,201)(10,303)(10,406)
557 Transfer Out - GF 100 0.0%(61,020)0 0 0 0 0
558 Transfer Out - DS 300 0.0%(150,625)0 0 0 0 0
559 Total Transfers Out (211,645)0 0 0 0 0
560 Total Expenditures & Transfers Out (1,029,926)(909,759)(943,929)(952,534)(961,226)(970,838)
563
564 NET CHANGE TO FUND BALANCE (210,366)(84,189)(110,103)(110,370)(110,640)(111,747)
565 Beginning Fund Balance 1,011,947 801,581 717,392 607,288 496,918 386,278
566 Ending Fund Balance 801,581 717,392 607,288 496,918 386,278 274,531
567 Restricted/Committed/Assigned 151,700 0 0 0 0 0
568 Unassigned Ending Balance 649,881 717,392 607,288 496,918 386,278 274,531
569 Operating Days 230 288 235 190 147 103
570
571
572
573
574
575 Sales tax (on-going)2.0%1,137,500 1,237,500 1,271,625 1,206,774 1,242,977 1,244,063
576 Sales tax (one-time)fixed 0 0 0 0 0 0
577 Interest 3.0%0 0 0 0 0 0
578 Total Revenues & Transfers In 1,137,500 1,237,500 1,271,625 1,206,774 1,242,977 1,244,063
581
582 Transfer Out - DS 300 linked to above (1,137,500)(1,237,500)(1,271,625)(1,206,774)(1,242,977)(1,244,063)
583 Total Expenditures & Transfers Out (1,137,500)(1,237,500)(1,271,625)(1,206,774)(1,242,977)(1,244,063)
586
587 NET CHANGE TO FUND BALANCE 0 0 0 0 0 0
588 Beginning Fund Balance 0 0 0 0 0 0
4B ECONOMIC DEVELOPMENT FUND
VISITORS ASSOCIATION FUND
96
ESTIMATED PROPOSED 1 2 3 4
FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22
TOWN OF WESTLAKEFIVE YEAR FORECASTAll Municipal Funds
DESCRIPTION
589 Ending Fund Balance 0 0 0 0 0 0
590 Restricted/Committed/Assigned 0 0 0 0 0 0
591 Unassigned Ending Balance 0 0 0 0 0 0
592
593
594
595
596
597 General Sales Tax 0.0%102,000 202,000 202,000 102,000 102,000 102,000
598 Hotel/Motel Tax 0.0%32,640 32,640 32,640 32,640 32,640 32,640
599 Economic Development for WA $10K/Lot from schedule 870,000 750,000 840,000 810,000 810,000 310,000
600 Total Revenues & Transfers In 1,004,640 984,640 1,074,640 944,640 944,640 444,640
603
604 ED - Deloitte Sales Tax linked to above (102,000)(102,000)(102,000)(102,000)(102,000)(102,000)
605 ED - Deloitte Hotel Tax linked to above (32,640)(32,640)(32,640)(32,640)(32,640)(32,640)
606 ED - Schwab Sales Tax linked to above 0 (100,000)(100,000)0 0 0
606 Transfer Out - WAE 412 linked to above (870,000)(750,000)(840,000)(810,000)(810,000)(310,000)
607 Total Expenditures & Transfers Out (1,004,640)(984,640)(1,074,640)(944,640)(944,640)(444,640)
610
611 NET CHANGE TO FUND BALANCE 0 0 0 0 0 0
612 Beginning Fund Balance 0 0 0 0 0 0
613 Ending Fund Balance 0 0 0 0 0 0
614 Restricted/Committed/Assigned 0 0 0 0 0 0
615 Unassigned Ending Balance 0 0 0 0 0 0
616
617
618
619
620
621 Development Fees (Platting)0.0%10,000 0 0 0 0 0
622 Miscellaneous Reimbursments 0.0%85,000 0 0 0 0 0
623 Total Revenues & Transfers In 95,000 0 0 0 0 0
626
627 Consultant Fees 0.0%(275,000)0 0 0 0 0
628 Boyle & Lowry 0.0%(18,000)0 0 0 0 0
629 Admin Fees 0.0%0 0 0 0 0 0
630 PID Meeting Expense 0.0%0 0 0 0 0 0
631 Construction Expense 0.0%(160,000)0 0 0 0 0
632 Total Expenditures & Transfers Out (453,000)0 0 0 0 0
635
636 NET CHANGE TO FUND BALANCE (358,000)0 0 0 0 0
637 Beginning Fund Balance 720,015 362,015 362,015 362,015 362,015 362,015
638 Ending Fund Balance 362,015 362,015 362,015 362,015 362,015 362,015
639 Restricted/Committed/Assigned 362,015 362,015 362,015 362,015 362,015 362,015
640 Unassigned Ending Balance 0 0 0 0 0 0
641
642
643
644
645
646 Revenues 1.0%60 60 61 61 62 62
647 Total Revenues & Transfers In 60 60 61 61 62 62
650
651 Expenditures 1.0%0 0 0 0 0 0
652 Total Expenditures & Transfers Out 0 0 0 0 0 0
655
656 NET CHANGE TO FUND BALANCE 60 60 61 61 62 62
657 Beginning Fund Balance 13,679 13,739 13,799 13,860 13,921 13,983
658 Ending Fund Balance 13,739 13,799 13,860 13,921 13,983 14,046
659 Restricted/Committed/Assigned 13,739 13,799 13,860 13,921 13,983 14,046
660 Unassigned Ending Balance 0 0 0 0 0 0
661
662
663
664
665
666 Transfer in - GF 100 GF links to this 788,781 980,770 938,411 1,003,744 962,681 969,019
667 Transfer In - VA 220 Linked to VA 150,625 0 0 0 0 0
668 Transfer In - 4B 200 Linked to 4B 1,137,500 1,237,500 1,271,625 1,206,774 1,242,977 1,244,063
669 Total Transfers In 2,076,906 2,218,270 2,210,036 2,210,518 2,205,658 2,213,083
672
673 Bank Charge - 2007 GORB Refunding of 2002 (400)0 0 0 0 0
674 DS Principal - Issue 2007 GORB (425,000)(40,000)(40,000)(45,000)(50,000)(55,000)
675 DS Interest - Issue 2007 GORB (276,610)(259,608)(258,008)(256,408)(254,608)(252,608)
676 Bank Charge - 2011 GORB Refunding of 2002/2003 (400)0 0 0 0 0
677 DS Principal - Issue 2011 GORB (275,000)(700,000)(715,000)(730,000)(750,000)(770,000)
678 DS Interest - Issue 2011 GORB (207,275)(192,650)(171,425)(149,750)(127,550)(104,750)
679 Bank Charge - 2013 CO Academy Expansion (400)0 0 0 0 0
680 DS Principal - Issue 2013 CO (178,000)(178,000)(182,450)(191,350)(191,350)(200,250)
DEBT SERVICE (revenue supported)
LONE STAR FUND
ECONOMIC DEVELOPMENT FUND
PUBLIC IMPROVEMENT DISTRICT
97
ESTIMATED PROPOSED 1 2 3 4
FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22
TOWN OF WESTLAKEFIVE YEAR FORECASTAll Municipal Funds
DESCRIPTION
681 DS Interest - Issue 2013 CO (270,730)(267,172)(263,568)(259,830)(255,525)(250,630)
682 Bank Charge - 2013 GORB (400)0 0 0 0 0
683 DS Principal - Issue 2013 GORB (130,000)0 0 0 0 0
684 DS Interest - Issue 2013 GORB (39,950)0 0 0 0 0
685 Bank Charge - 2014 GORB Refunding of 2003 0 0 0 0 0 0
686 DS Principal - Issue 2014 GORB (5,000)(5,000)(5,000)(5,000)(5,000)(5,000)
687 DS Interest - Issue 2014 GORB (65,220)(65,040)(64,860)(64,680)(64,500)(64,320)
688 Bank Charge - 2017 CO Fire Station Complex 0 0 0 0 0 0
689 DS Principal - Issue 2017 CO (203,098)(200,000)(205,000)(210,000)(215,000)(225,000)
690 DS Interest - Issue 2017 CO 0 (310,800)(304,725)(298,500)(292,125)(285,525)
691 Total Expenditures & Transfers Out (2,077,483)(2,218,270)(2,210,036)(2,210,518)(2,205,658)(2,213,083)
694
695 NET CHANGE TO FUND BALANCE (577)0 0 0 0 0
696 Beginning Fund Balance 0 0 0 0 0 0
697 Ending Fund Balance 0 0 0 0 0 0
698 Restricted/Committed/Assigned 0 0 0 0 0 0
699 Unassigned Ending Balance 0 0 0 0 0 0
700
701
702
703
704
705 Property Tax PY 2011 CO 0.0%0 0 0 0 0 0
706 Property Tax CY 2011 CO linked to below 94,510 271,911 531,819 535,341 538,643 537,774
711 Total Revenues 94,510 271,911 531,819 535,341 538,643 537,774
714
715 Bank Charge - 2011 CO 0 0 0 0 0 0
716 DS Principal - Issue 2011 CO (75,000)(79,000)(83,000)(87,000)(91,000)(96,000)
717 DS Interest - Issue 2011 CO (43,611)(36,300)(34,356)(32,316)(30,180)(27,936)
718 Bank Charge - 2013 GORB 0 0 0 0 0 0
719 DS Principal - Issue 2013 GORB 0 (125,000)(135,000)(140,000)(145,000)(145,000)
720 DS Interest - Issue 2013 GORB 0 (37,400)(34,463)(31,025)(27,463)(23,838)
721 Bank Charge 2019 0 0 0 0 0 0
722 DS Principal 2019 0 0 0 0 0 0
723 DS Interest 2019 0 0 (245,000)(245,000)(245,000)(245,000)
724 Bank Charge 2019 0 0 0 0 0 0
725 DS Principal 2019 0 0 0 0 0 0
726 DS Interest 2019 0 0 0 0 0 0
727 Total Expenditures (118,611)(277,700)(531,819)(535,341)(538,643)(537,774)
730
731 NET CHANGE TO FUND BALANCE (24,101)(5,789)0 0 0 0
732 Beginning Fund Balance 29,890 5,789 0 0 0 0
733 Ending Fund Balance 5,789 0 0 0 0 0
734 Restricted/Committed/Assigned 5,789 0 0 0 0 0
735 Unassigned Ending Balance 0 0 0 0 0 0
736
737
738
739
740
741
742 Transfer in from GF linked to GF 0 1,015,324 1,450,742 1,170,710 1,081,871 370,114
743 Payroll Transfers Out to GF 0 (54,565)0 0 0 0
744 Interest Income 48,000 38,000 6,000 6,000 6,000 0
745 NET 48,000 998,759 1,456,742 1,176,710 1,087,871 370,114
746
747 Bond Revenue - Issue $3.1M 0 0 480,180 0 0 0
748 ROANOKE ROAD RECON/DRAIN SOUTH 0 0 0 (480,180)0 0
749 NET 0 0 480,180 0 0 0
750
751 Contribution 219,625 0 0 0 0 0
752 FM1938 TOWN IMPROVEMENTS 0 0 0 0 0 0
753 NET 219,625 0 0 0 0 0
754
755 Bond Revenue - Issue $3.1M 0 0 281,960 0 0 0
756 SAM SCHOOL ROAD RECON & DRAINANGE 0 0 (281,960)0 0 0
757 NET 0 0 0 0 0 0
758
759 Cash (Fund Balance)0 0 0 0 0 0
760 E. DOVE ROAD RECON & DRAINAGE (Vaquero - TB)(696,260)0 0 0 0 0
761 NET (696,260)0 0 0 0 0
762
763 Bond Revenue - Issue $3.1M 0 0 30,000 0 0 0
764 TRAIL CONNECTION AT 114/SOLANA 0 0 (30,000)0 0 0
765 NET 0 0 0 0 0 0
766
767 Bond Revenue - Issue $3.1M 0 0 300,949 0 0 0
768 TRAIL - WESTLAKE ACADEMY TO CEMETERY 0 0 0 (300,949)0 0
769 NET 0 0 300,949 (300,949)0 0
DEBT SERVICE (tax supported)
CAPITAL PROJECTS FUND
Road & Street
Improvements
Refunding of Series
2008 (A&S)
Road & Street
Improvements
WA Expansion for 15
Classrooms
NEW
ISSUE
NEW
ISSUE
Moved
from 300
Refunding of 2008 (A&S)
MOVED TO FUND 301
98
ESTIMATED PROPOSED 1 2 3 4
FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22
TOWN OF WESTLAKEFIVE YEAR FORECASTAll Municipal Funds
DESCRIPTION
770
771 Bond Revenue - Issue $3.1M 0 0 290,016 0 0 0
772 TRAIL - DOVE/PEARSON/ASPEN 0 0 (290,016)0 0 0
773 NET 0 0 0 0 0 0
774
775 Cash (Fund Balance)0 0 0 0 0 0
776 HWY 377 LANDSCAPE IMPROVEMENTS (PHASE 1)0 0 0 0 0 0
777 NET 0 0 0 0 0 0
778
779 Bond Revenue - Issue $3.1M 0 0 983,954 0 0 0
780 OTTINGER ROAD RECON & DRAINAGE 0 0 0 (983,954)0 0
781 NET 0 0 983,954 (983,954)0 0
782
783 Bond Revenue - Issue $3.1M 0 0 404,125 0 0 0
784 PEARSON LANE RECON & DRAINAGE 0 0 (404,125)0 0 0
785 NET 0 0 0 0 0 0
786
787 Bond Proceeds 9,204,300 0 0 0 0 0
788 Texas Tax Note Revenue 1,530,000 0 0 0 0 0
789 Contribution Revenue 1,200,000 0 0 0 0 0
790 Land Donation 1,998,000 0 0 0 0 0
791 FIRE STATION CONSTRUCTION and LAND (2,498,000)(9,843,000)(1,591,300)0 0 0
792 NET 11,434,300 (9,843,000)(1,591,300)0 0 0
793
794 Cash (Fund Balance)0 0 0 0 0 0
795 MAINTENANCE AND STORAGE FACILITY 0 0 0 0 0 0
796 NET 0 0 0 0 0 0
797
798 Bond Revenue - Issue $3.1M 0 0 229,500 0 0 0
799 WAYFINDING SIGNAGE 0 0 (229,500)0 0 0
800 NET 0 0 0 0 0 0
801
802 Cash (Fund Balance)0 0 0 0 0 0
803 DOVE ROAD/FM1938 SIGNALIZATION (285,000)(160,000)0 0 0 0
804 NET (285,000)(160,000)0 0 0 0
805
806 Contribution Revenue 112,000 0 0 0 0 0
807 SOLANA/FM1938 SIGNALIZATION (102,000)(10,000)0 0 0 0
808 NET 10,000 (10,000)0 0 0 0
809
810 WAF Grant 60 175,000 0 135,000 0 0
811 WA - OUTDOOR LEARNING CENTER (89,840)(175,000)0 (150,000)0 0
812 NET (89,780)0 0 (15,000)0 0
813
814 Grants (WAF $11750 - HOC $5000 - WAAC $2975)15,175 0 0 0 0 0
815 WA - BLEACHERS AND FILM TOWER (4,590)0 0 0 0 0
816 NET 10,585 0 0 0 0 0
817
818 Land Sale 4,010 0 0 0 0 0
819 LAND SALE EXPENSE (17,825)0 0 0 0 0
820 NET (13,815)0 0 0 0 0
821
822 Bond Revenue - Issue $3.1M 0 0 80,000 0 0 0
823 FLASHING CROSSWALK LIGHTS 0 0 (80,000)0 0 0
824 NET 0 0 0 0 0 0
825
826 Contribution 150,000 0 0 0 0 0
827 CEMETARY IMPROVEMENTS 0 (100,000)(50,000)0 0 0
828 NET 150,000 (100,000)(50,000)0 0 0
829
830 Bond Revenue - Issue $3.1M 0 0 82,000 0 0 0
831 WA - POND REPAIRS 0 0 (82,000)0 0 0
832 NET 0 0 0 0 0 0
833
834 Bond Revenue - Issue $3.1M 0 0 90,000 0 0 0
835 SOLANA PAVEMENT REPAIRS 0 0 (90,000)0 0 0
836 NET 0 0 0 0 0 0
837
838 Bond Revenue - Issue $3.1M 0 0 54,450 0 0 0
839 WYCK HILL PAVEMENT RESURFACE 0 0 (54,450)0 0 0
840 NET 0 0 0 0 0 0
841
842 Bond Revenue - Issue $3.1M 0 0 80,000 0 0 0
843 FM1938 PAVEMENT REPAIRS 0 0 (80,000)0 0 0
844 NET 0 0 0 0 0 0
845
846
847 Total Revenues & Transfers in 14,481,170 1,228,324 4,843,876 1,311,710 1,087,871 370,114
848 Total Expenditures & Transfers Out (3,693,515)(10,342,565)(3,263,351)(1,915,083)0 0
99
ESTIMATED PROPOSED 1 2 3 4
FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22
TOWN OF WESTLAKEFIVE YEAR FORECASTAll Municipal Funds
DESCRIPTION
849 NET CHANGE TO FUND BALANCE 10,787,655 (9,114,241)1,580,525 (603,373)1,087,871 370,114
850 Beginning Fund Balance 2,161,162 12,948,817 3,834,576 5,415,101 4,811,728 5,899,599
851 Ending Fund Balance 12,948,817 3,834,576 5,415,101 4,811,728 5,899,599 6,269,713
852 Restricted/Committed/Assigned 12,948,817 3,834,576 5,415,101 4,811,728 5,899,599 6,269,713
853 Unassigned Ending Balance 0 0 0 0 0 0
861
862
863
864
865
866 Interest Earned vision 2,400 2,400 500 500 500 500
867 Bond Issuance fy 18/19 0 0 0 0 0 0
868 Transfer in from ED 200 linked to ED Fund 870,000 750,000 840,000 810,000 810,000 310,000
869 Total Revenues & Transfers In 872,400 752,400 840,500 810,500 810,500 310,500
872
873 Construction Expense vision 0 0 0 0 0 0
874 Total Expenditures & Transfers Out 0 0 0 0 0 0
877
878 NET CHANGE TO FUND BALANCE 872,400 752,400 840,500 810,500 810,500 310,500
879 Beginning Fund Balance 397,127 1,269,527 2,021,927 2,862,427 3,672,927 4,483,427
880 Ending Fund Balance 1,269,527 2,021,927 2,862,427 3,672,927 4,483,427 4,793,927
881 Restricted Funds 1,269,527 2,021,927 2,862,427 3,672,927 4,483,427 4,793,927
882 Unassigned Ending Balance 0 0 0 0 0 0
WESTLAKE ACADEMY EXPANSION
100