Loading...
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