Loading...
Res 03-53 Adopting the Budget for Fiscal Year 2003-2004TOWN OF WESTLAKE RESOLUTION NO. 03-53 A RESOLUTION OF THE BOARD OF ALDERMEN OF THE TOWN WESTLAKE, TEXAS APPROVING THE 2003104 BUDGET. BE IT RESOLVED BY THE BOARD OF ALDERMEN OF THE TOWN OF WESTLAKE, TEXAS: SECTION 1: That the Board of Aldermen of the Town of Westlake does hereby approve the 2003104 budget. OF SECTION 2: That this Resolution shall become effective upon the date of its passage. PASSED AND APPROVED ON THIS 8' DAY OF SEPTEMBER 2003. ATTEST: 6ing& Crosswy, Town cretary APPROVED AS TO FO V. Scott Bradley, Mayor Trent O. Petty, Town,Manager Town of Westlake Annual Budget FY 2003/2004 Mayor Scott Bradley Board of Aldermen Fred Held, Mayor Pro -Terry Buddy Brown Bill Frey Don Redding Larry Sparrow Trent Petty Town Manager Stan Lowry Dawn Lenzie Town Attorney Assistant to the Town Manager Debbie Piper Finance Director Ginger Crosswy Town Secretary Town of Westlake Organizational Chart I Citizens of Westlake I I Mayor & Board of Aldermen I Town Attorney I I Town Manager I I Town Secretary Assistant to Town Manager I I I Finance Director Administrative Intern Accounts Payable Clerk Personnel Mana er F -- Westlake FireIEMS Muni. Court Admin. Fire/EMS Staff Town Marshall I Deputy Ct. Clerk I Town Consultants I I Westlake Academy I I Public Works Superintendent WESTLAKE August 25, 2003 Honorable Mayor and Members of the Board of Aldermen: It is my sincere pleasure to present to you, the fiscal year 2003/2004 program of services for the Town of Westlake. As in previous years, this budget represents our commitment to conservative fiscal budgeting and adherence to strict planning to meet the growing needs of Westlake without assessing a property tax. Due to the proactive decisions made by the Board of Alderman and the effort by the Town employees, we have made significant changes in order to better serve residents and increase our margin of revenue. By eliminating many of the costly and time consuming activities of our consultants and slowly transitioning to full and part-time employees, we have been able to identify the point where overall costs are contained or reduced. In reducing the reliance on outside sources, our service dramatically improves. Major Events of FY 2002-2003 In 2003, the Town issued its second series of Certificates of Obligation, totaling $6.4 million to complete the construction of the Westlake Civic Campus. The Westlake Civic Campus will house the Westlake Academy, the Board of Aldermen/School Board Chambers, the Town Recreation Center, Town Hall offices, and Texas Student Housing Entities. Another year of progressive thinking and an impressive "A" bond rating has allowed the Town to capitalize on low interest rates to fund these improvements. Fiscal Year 2003/2004 is a pivotal year for the Town. The decision on the mall project has obvious long-term implications which will affect the Town's financial future and overall direction of growth. This budget does not assume the mall project will come to pass, but it is designed to be flexible enough to accommodate increases in cost that will track with increases in revenue to support the project. Construction and hook up of the Westlake/Keller Overhead Storage Tank was completed in order to reduce peak charges and improve Westlake's ability to supply water to its customers. The first full year of service from the Keller Police Department, resulted in a much improved service to customers as well as a 25% increase in citation revenue. With the increase in patrol activity, the Town has realized an increase in the backlog of warrants, many of which were inherited from the Trophy Club Municipal Court. It is hoped that the retainage of a collection agency will help reduce the large backlog. The Town hired its first Finance Director to ensure the fiscal responsibility and conformance to ever increasing federal public accounting requirements. Debbie Piper, a CPA and former school ill 3 Village Circle • Suite 207 Solana • Westlake, Texas 76262 Metro: 817-430-0941 • Fax: 817-430-1812 • www.westiake-tx.org and municipal auditor has joined the staff in an effort to decrease our reliance on outside auditors and upgrade the Town's financial reporting system. The Town also hired its first Public Works Superintendent. Jarrod Greenwood will help to decrease the Town's reliance on Aquasource, Graham & Associates, Cheatham & Associates, and Parson's Transportation. Besides overseeing water and sewer operations, Jarrod will also take over utility infrastructure inspections, thus reducing the Town's reliance on outside engineers for this service. We hope to begin billing our water customers directly in the next year, which will not only decrease costs, but also increase responsiveness of the Town to resident's concerns. The Public Safety in Westlake took a giant step forward in 2002/2003 by virtue of the decision to staff and equip a full time Fire and Rescue squad. Thanks to a FEMA grant which supplied 90% of the funds for the new fire engine, the Town was able to purchase state of the art equipment to help protect the growing residential population and to aide in the protection of the commercial buildings of Solana, Fidelity, and Daimler Chrysler. Goals and Results Goals for FY 2003/2004 will focus on continuing current services and operations while reducing expenditures through internalizing operations and eliminating unnecessary costs. The Town is also focusing on exploring new revenue sources. Meet growing residential service demand II. Strongly pursue commercial and retail development to expand sales tax base III. Increase revenue without raising rates or implementing property tax IV. Reduce spending without reducing services V. Maintain competitive and motivated workforce VI. Support community involvement activities VII. Improve Westlake hotel occupancy The FY 2002/2003 budget focused on eight points and assumed the mall project would continue as planned. The delay of that project radically changed the planning related to goals for 2002/2003. I. Update Plans Because of the uncertainty of the mall, the Thoroughfare Plan, Comprehensive Land Use Plan, and Open Space Plan updates were put on hold. M Improve Westlake's self sufficiency A. Hired a Finance Director to streamline accounting process B. Hired a Public Works Superintendent to relieve outside contractors of a portion of their duties iv Ill. Continue to evaluate new revenue enterprises The Town realized $271,282 in duct bank revenues in 2.00212003 and expects more in 2003/2004. IV. Attract new retail and commercial development in compliance with Town standards. While the mall project is currently unknown, the Town has attempted to assist Maguire Partners in business attraction as well as supported the local and regional commercial real estate community. It is hoped that the properties owned by Hillwood along 377 and 170 may develop in FY 2003/2004. V. Budget, Organize, Staff and Open the Westlake Academy, Fall '03 Completed Vl. Prepare plan to move Westlake Fire/Rescue to permanent facilities This plan was delayed due to the mall delay. FY 2003/2004 Budget The FY 2003/2004 Budget consists of five funds, however, we are budgeting with the expectation that the 4A Development Fund will be replaced by a Crime Control District. The General Fund The General Fund supports the bulk of the Town's services. A portion of the Town's sales tax, development and permit fees, citation revenue, and miscellaneous other revenues support this fund. Expenditures from this fund include non -enterprise fund personnel costs, Westlake Fire and Rescue expenditures, street and park right-of-way maintenance, Municipal Court expenditures, and general operating costs of the Town. The most significant cost increases proposed for FY 2003-2004 results from the planned dissolution of the 4A Fund. These historic expenditures were disallowed by the 780' legislature. Another major cost is proposed in an effort to boost revenues. The staff of Westlake DPS who are also certified as police will work a combined (5 officers working 8 hours apiece) forty hours a week collecting warrants, and occasionally issuing citations. A new position of Personnel Manager is a lateral transfer for the current Office Manager position. An Accounts Payable Clerk/Receptionist will be hired to greet the public, help the Finance Director, and to better control the accounting system of the Town. The Town budget also includes a full year of a Public Works Superintendent, who began in late 2003. Revenues are expected to increase next year due to an increase in Building Permits, Warrant Collections, and Franchise Taxes from Tri -County Electric. The additional revenues from Building permits are due to a surge in residential building in the Town. Along with the increased development is a new plan for collecting warrants. Tri -County has agreed to raise franchise fees from 3% to 4% to generate an additional $54,034 in revenue to the General Fund. The Utility .Fund The Utility Fund provides all water, sewer, and telecommunication duct bank services to the Town. Water service to the Town is expanding as the new Overhead Storage facility comes on line to reduce peak expenses and supplement supply and pressure. This year, the Utility Fund will be able make scheduled loan payments to the 4B Corporation and the General Fund. For the first year, the Utility Fund will also make payments on the debt service for the Westlake/Feller Overhead Storage Tank. Rates are still a major concern. Due to the large debt and relatively small number of customers, the fund barely pays its own costs and ha not been able to refund all the start up money provided by General Fund reserves. Water, Sewer, and Duct Bank revenue does not supplement the General Fund nor Utility Fund operations. The Utility Fund has leased two sections of duct bank each for 20 -year leases totaling $271,282. By the end of the year, the Town hopes to receive new leases from Verizon, SBC, MCI, and hopefully Charter Communications. The Westlake Visitors Association Established in late FY 1999-2000, this fund collects 7% of the gross receipts on most services offered to visitors of Marriott and future Westlake hotels. FY 2402-2003 saw the first large expenditure from the Visitor's Fund which totaled $225,000 for the cost of a Visitor's Center at the Civic Campus. The Visitor's Center approved by the bonds, is integrated into the Civic Campus site and is the first fully funded and completed project of the Visitor's Association. Several visitors' oriented capital projects will be considered for the 2003/2004 budget to enhance tourism. The Town has provided the Marriott Hotel with a collection of Westlake Historical Journals to furnish the hotel rooms. This will allow the Visitor's Fund to assist in funding the Westlake Historical Preservation Society. 4A Development Fund The 4A Development Fund collects a % cent sales tax for the purpose of creating jobs and encouraging development. 4A has made grants and loans which have been used to reimburse Fidelity Investment and construction of the telecommunication duct bank as well as other capital projects in Westlake. However, the Texas Legislature passed a bill this year limiting the uses of 4A funds, severely reducing their application to Westlake. The Town proposes to keep the 4B tax but, dissolve the 4A tax, and simultaneously adopt the Crime Control District at a level of 1/z cent per dollar spent. The Crime Control District would result in revenues of $355,004 to help offset the cost of the Keller Police Contract, which will cost $646,964 for FY 03/04. Once 4A is dissolved, the remaining balance will be transferred to the General Fund and become available for standard operating and maintenance costs incurred by the Town. 4B Development Fund The 4B Development Fund operates in a similar fashion to the 4A fund, by collecting an additional %2 cent sales tax to be used for qualified development projects. The limitations on the use of these funds however, are less restrictive than the amended Section 4A, but nevertheless, reduce the V1 Town's discretion of spending these funds. As a result, 4B will be primarily used for debt service payments related to job generating activities of the Town. Crime Control District The goal of a Crime Control District is to provide municipalities with dedicated fiends that are intended for uses pertaining to crime prevention. A Crime Control District may collect 118, 114, or 112 cent sales tax except that it may not be applied to electric sales as in the case of 4A. It is the recommendation of the staff to adopt the 1/z cent option to replace 4A dollars. Summary The FY 2003/2004 Budget is generally a "hold the line" budget. The changes recommended either reduce current costs to the Town, increase revenues, or provide additional services based on demand. We have not budgeted for the major staff changes, which will need to occur to accommodate the construction of the mall As always I appreciate the hard work of the staff in developing the budget. Special thanks and recognition are due; Dawn Lenzie, Assistant to the Town Manager; Corey Fickes, Budget Manager; Debbie Piper, Finance Director; and Todd Wood, Personnel Manager; as well as Don Wilson and Amanda DeGan for their help in keeping their respective departments running efficiently and maintaining an aggressive level of service with conservative budgets and creative ideas. Sincerely, Trent Pet Town Manager Vii TABLE OF CONTENTS Town Officials i To<<vn Or:;auiza(ion Chart ii Defter to IMayor and Aldcruian iii Table of Contents viii 1*:40141aY►+/�.�ilu ►�i�►:�11.1 Introduction x Basis of Accounting/Budgeting xi Budget Process xii Budget Amendment Process xiii General Fund xiv Utility Fund xvi Westlake Visitors Association xvi Long Term Financial Plan xviii Employee Summary xx Goals Report xxi GENERAL FUND Fund Summary 1 Income Detail 3 Expenditure Detail 5 Public Safety Detail 9a Receivables and Payables From Other Sources 10 Repayment Scliedules 11 Board Appointed Entities 16 UTILITY FUND Fund Summary 17 Income 18 Expenditures 19 Receivables and Payables From Other Sources 21 Repayment Schedules 22 WESTLAKE VISITORS ASSOCIATION Fund Summary 25 Income 26 Expenditures 26 Receivables and Payable From Other Sources 27 viii DEVELOPMENT" FUNDS 4A Fund Summary 28 Receivables and Payables From Other Sources 29 413 36 Fund Summary 30 Receivables and Payables From Other Sources 31 Repayment Schedule 32 Crime Control District Fund Summary 33 Receivables and Payables From Other Sources 34 CAPITAL PROJECTS Capital Project Details General Fund Civic Campus 35 377 R.O.W. Purchase 36 FM 1938 Engineering 37 FM 1938 / 1.14 Interchange Improvements 38 Dove Road Overlay 39 Westlake Visitor's Association Blacksmith & Forge Statue 40 Entryway Improvements at Dove & Pearson Drive 41 Westlake Restoration Project 42 Paint Retaining Walls at Westlake Parkway & 114 43 4A Development Corporation Bridge Enhancements 44 Duct Bank Infrastructure 45 Circle T Mall Development 46 4A Loan to Westlake Academy Foundation 47 4B Development Corporations Keller/Westlake OH Storage Connection to Dove Rd. Water Line 48 Park & Open Space Planning 49 Master Thoroughfare Update — Retail Development 50 Ottinger Overlay 51 Permanent DPS Facility 52 Unfunded Needs 53 ix INTRODUCTION The Town of Westlake 2003/2004 annual operating budget is the result of many hours of deliberation as well as a response to both internal and external forces that have defined fiscal boundaries in its preparation. The mission is to produce an accurate and user-friendly budget document that can be utilized as a resource tool by the Board of Aldermen, the Town staff and the citizens of Westlake. To accomplish this mission., a set of budget preparation guidelines, which represent generally accepted budgeting practices, has been established: 1. The annual operating budget presents appropriations of expenditures and estimates of revenues for all local government fiands, including sales tax revenues, franchise tax, mixed beverage tax, licenses and permits, development fees, sales of printed material and interest income. 2. The annual operating budget illustrates expenditures, anticipated revenue and estimated impact on reserves and or surpluses. 3. Revenue projections are prepared for each revenue source based on an analysis of past revenue trends and current fiscal conditions. 4. The budget process includes a multi-year projection of capital improvement requirements. S. A budget message, which summarizes local financial conditions and the principal budget issues the locality must face, is presented to the governing board along with the annual budget. The data for each fund is organized similarly: • Program Summary • Goals Report • Revenue Detail • Capital Expenditure Details and Expenditure Projects • Funds From Other Sources Detail BASIS OF ACCOUNTING/BUDGETING All governmental fund types are budgeted and accounted for on a GAAP basis for purposes of financial statement Presentations. The FY 2003/2004 Budget complies with GAAP 34 reporting requirements and is consistent with the expanded reporting required by GAAP 34. All funds use a financial resources measurement focus and are accounted and budgeted for using the modified accrual basis of accounting. Under the modified accrual basis of accounting, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectable within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures represent a decrease in net financial resources and, other than interest on general long- term debt, are recorded when the fund liability is incurred, if measurable. Interest on general long- term debt is recorded when due. The Proprietary Fund types are accounted and budgeted for on a cost of services or "capital maintenance" measurement focus, using the accrual basis of accounting. Under the accrual basis of accounting, revenues are recognized when earned and expenses are recognized when incurred, For purposes of this budget presentation, depreciation is not displayed and capital expenditures and bond principal payments are shown as uses of funds. Governmental Fund Types Governmental fund types are those through which most governmental functions of the Town are financed. The acquisition, use, and balances of the Town's expendable financial resources and the related liabilities (except those accounted for in the Proprietary and Fiduciary fund types) are accounted for through Governmental Fund types. The following are the Town's governmental fund types. 1. The General Fund is the general operating fund of the Town. It is used to account for all revenues and expenditures except those required to be accounted for in other funds. Westlake Fire & Rescue as well as the Interlocal agreement with Keller for Police services are two major functions financed by the General Fund. 2. Special Revenue Funds are used to account for the proceeds of specific revenue sources, other than expendable trusts or major capital projects. An example would be federal block grant funds or similar revenues. Following are our special revenue funds: Economic Development Corporation 4A and 4B funds are provided as local options, under section 4A & 4B of the local government code. The funds are generated from a 112 cent sales tax levy for each Economic Development Corporation. The proceeds are used for general economic development and infrastructure support. 0 Westlake Visitors Association is the result of a 7% hotel occupancy tax adopted within the Town of Westlake in FY 99 — 00. A 7% tax on hotel stays and services within the Town generate the funds. The proceeds are required to be used for the promotion of travel and tourism in the Town of Westlake. KAI The Crime Control district, proposed in this budget, generates funds in a similar method as the 4A and 4B Development funds. A 1/z cent sales tax will be collected for crime prevention purposes but is not charged to electricity costs Capital Projects Funds are used to account for .Financial resources to be used for the acquisition or construction of major capital facilities. This fund budget is driven by estimated construction costs for each project scheduled for a specific construction period. Therefore, it has a proj ect budget, which may span more than one budget year. These have been divided into three types: • General Government Capital Projects are those projects that are typically funded with general obligation bond funds, state and federal grants, and transfers from the general fund. Utility Capital Projects are projects for the Utility fiends. Funding sources are typically revenue bond funds or water and wastewater impact fees. Westlake Visitor's Association Capital Projects are projects for the Visitor's Association. They are used to generate tourism and interest in the Town and are funded by the hotel/motel tax. Proprietary Fund Types Proprietary fund types operate in a manner similar to private business utilizing an accrual basis of accounting. Enterprise Funds — are used to account for operations that are either financed and operated in a manner similar to private business enterprises, or where the governing body has decided that periodic determination of revenues earned, expenses incurred, and/or net income is appropriate for capital maintenance, public policy, management control, accountability or other purposes. • The Utility Fund accounts for water, wastewater and telecommunications conveyance (duct bank) services for the residents of the Town. All activities necessary to provide such services are accounted for in the Fund, including administration, operations, maintenance, financing and related debt service, and billing and collection. THE BUDGET PROCESS The Town Manager submits the budget to the Board of Aldermen. The Town's fiscal year runs from October 1 through September 30. Prior to the beginning of the fiscal year, the Town Manager must submit a proposed budget, which includes: • A budget message • A consolidation statement of anticipated receipts and proposed expenditures for all funds • General fund resources in detail • Special fund resources in detail • A summary of proposed expenditures by function, department and activity xii Detailed estimates of expenditures shown separately for each activity to supportthe proposed expenditure The appropriation ordinance and the tax levying ordinance (if applicable) The proposed revenues and expenditures must be compared to prior year revenues and expenditures. The budget preparation process begins early in the calendar year with the establishment of overall town goals and the analysis of current year operations compared to expenditures. Budget policies and procedures are reviewed at the same time to reduce errors and omissions, Funding levels/programs are agreed upon and the proposed budget is presented by the Town Manager to the Board of Aldermen. A public hearing on the budget is conducted according to state and local law. This meeting is held after the Board has reviewed the budget. The Board of Aldermen approves a level of expenditure (or appropriation) for each fund to go into effect October 1, prior to the expenditure of any Town funds for that budget year. BUDGET AMENDMENT PROCESS The Town Manager may request that the current year budget be amended. The Town Manager will review the documentation and draft an ordinance that will amend the current budget. This ordinance is then presented to the Board of Aldermen at a regularly scheduled Board of Aldermen meeting for Board consideration. After considering the amendment, the Board of Aldermen votes on the amendment. If the amendment is approved, the necessary budget changes are then made. All budget amendments will be approved by the Board of Aldermen prior to the expenditure of funds in excess of the previously authorized budgeted amounts within each department of the Town. GENERAL FUND Revenues Funding of the Town's General Fund operations is derived from four revenue categories. Each of these categories is detailed below with a brief description, how internal and external factors affect revenue amounts and how amounts differ from the prior year. Revenues for FY 2003/2004 are projected to be $3,354,819 as compared to FY 2002/2003 total of $2,702,810. The 24% increase occurs largely as a result of the balance transfer from the dissolved 4A fund to the General Fund to cover the cost of the Keller Police Contract. Sales &[Tse Taxes Sales tax receipts are the result of a tax levy on the sale of goods and services within the Town as authorized by the State of Texas. The maximum sales tax allowed in the Town of Westlake is 8.25% per dollar on all goods and services deemed taxable. The State remits to the Town, on a monthly basis, an amount equal to 1 % of the taxable sales within the Town, for the general fund, in addition to .5% to each of the two economic development corporations, which were formed for the benefit of the Town of Westlake. In FY 2003/2004 a change in the way sales tax will be recognized will occur if 4A is dissolved and the Crime Control District is enacted. If the voters of the Town of Westlake choose to make this change, sales tax revenue in the Crime Control District will be slightly lower because the .5% tax does not apply to electricity purchased in the Town. This change will cause revenues in the Crime Prevention Funds to be between 34% lower than the Economic Development Fund's (413) revenues. Sales taxes are budgeted to be slightly lower for FY 2003/2004 due to surplus anomaly which occurred in FY 2002/2003 as a result of a sales tax spike by one Westlake business. This will not be duplicated in FY 2003/2004 and cannot be considered sustaining revenue. Alcoholic beverage taxes are the result of mixed beverage and -private club registration permits remitting a 14% mixed beverage gross receipt tax to the state. The state then remits 10.7143% of those taxes to the Town. The Hotel Occupancy Taxes are obtained through the assessment of a 7% hotel occupancy tax. Authority granted by the State of Texas allows cities to levy a tax not to exceed 7% of the rental rate for a hotel/motel room. Funds generated by the occupancy tax are required to be used in a manner, which directly enhances and promotes visitors, tourism, and the convention and hotel industry. Sales and use taxes constitute the largest revenue source for the general fund. Franchise Taxes The FY 2003/2004 budget includes a raise in electric franchise fess from the existing 3% to 4%. Tri -County has verbally agreed to the change but would like to negotiate if Westlake ever imposes a property tax. This equates to an additional $54,034 for the upcoming year. Licenses & Permits License and permit revenue includes fees charged by the Town for certain types of operator licenses and permits for construction and other items regulated by Town ordinances. Commercial building xiv activity is expected to improve throughout 2003/2004. Revenue projections should remain constant for this category based on the expectation that residential and commercial construction activity will continue at the current rate. Miscellaneous Revenue Includes the sale of printed materials as well as interest earned. Expenditures FY 2003/2004 proposes operating expenditures in the General Fund to total $3,309,668. This compares with $2,660,996 projected in FY 2002/2003 for an increase of 25%. The increases appear to be much larger than prior years primarily because of the transfer of 4A balance and what would have been 4A expenditures to the General Fund once 4A is dissolved. Consultant Expenditures 900,000 9 800,000 700,000 600,000 500,000 O E 400,000 300,000 - 200,000 100,000 0 2000/2001 200//2002 2002/2003 200312004 Year Other increases in expenditures, are intended to decrease expenses elsewhere and help the Town in its goal of becoming self-sufficient. As seen in the chart above, Consultant expenditures have decreased drastically in the past four years as the Town internalizes operations and reduces its dependence on outside sources. Expenditures were adjusted down. in FY 2002/2003 at the beginning of the year when it was thought revenues would be lower than expected. Sales tax however, rebounded so the General Fund should end the year with a net gain. FY 2002/2003 actual revenues are expected to be $2,702,810 with expenditures totaling $2,646,996. xv UTILITY FUND The Utility bund accounts for water and wastewater services for the residents of the 'Town. All activities necessary to provide such services are accounted for in the fund, including administration, operations, maintenance, financing and related debt service, and billing and collection. In addition, this fund contains the planning and implementation of the "Westlake Duct Bank". The duct bank is a series of conduit designed to house all telecom and transmission lines in Westlake. The duct bank is a public/private partnership that utilizes private sector capital, town planning and engineering g and town operation. Phase I was completed in FY 2000/2001 and became ready for occupancy in FY 2001/2002. The first leases were entered into in late FY 2001/2002. This year, payments totaling $271,282 were realized from Verizon and Southwestern Bell. Revenue The Utility Fund receives revenues from water sales, wastewater services, and the duct bank. FY 2002/2003 revenues are projected to end with a total of $1,030,084. FY 2003/2004 proposed revenues are budgeted at $977,850. Water Rates Westlake has one of the highest water rates in the State of Texas. A common misconception is that the Town subsidizes operating revenue for General Fund services by Water and Sewer revenue. On the contrary, the opposite has been the historic reality. The Town's Water and Sewer Revenues total $730,000; of that total, $490,996 is dedicated to pay debt associated with the construction of facilities. The remaining revenue covers normal operating costs. Once Westlake is able to put more customers on the system, the rates will drop. This will especially be the case if heavy commercial development occurs to affect the current residential burden. Expenditures FY 2002/2003 projected expenditures in the Utility Fund total $956,008. The expenditures are higher than budgeted this year due to an invoice from the City of Southlake for the N-1 sewer line. The bill covers over 2 years of service, which Southlake is only now billing. If the proposed dissolution of 4A occurs, the debt to 4A for duct bank construction will be forgiven and the projected annual payments of $95,000 will no longer be necessary. FY 2003/2004 proposed expenditures for the Utility Fund total $909,162. For the past two years, the Utility Fund has borrowed heavily from the Town's other funds. At the end of FY 2002/2003, the Utility Fund will have repaid all loans from other funds. WESTLAKE VISITORS ASSOCIATION FUND Hotel Occupancy Taxes are allocated to this fund and obtained through the assessment of a 7% hotel occupancy tax. Authority granted by the State of Texas allows cities to levy a tax not to exceed 7% of the rental rate for a hotel/motel room. Funds generated by the occupancy tax are required to be used in a manner, which directly enhances and promotes tourism and the convention and hotel industry.. Hotel occupancy revenue was greater than expected for FY 2002/2003. xvi Major projects budgeted for Board consideration this year are three items intended to begin an aggressive program of visitor attraction to Westlake. The first is a life size bronze statue of the symbol of the Westlake Academy; a blacksmith complete with a perpetual burning forge. The Town is also planning on designing and constructing entryways for Dove and Pearson Drive so visitor's to the Town will be aware of Westlake's boundaries, as well as provide residents with a sense of community. Third, the Westlake Historical Renovation project designed to acquire and reconstruct historic buildings in North Tarrant and South Denton County to put back in service in a historic multi -use village to be constructed as a buffer for heavy retail and commercial to hotel, golf and residential land uses. The location is still under consideration. Revenues for the Westlake Visitor's Association are based on the Hotel/Motel tax and interest income on the account. Revenues for FY 2002/2003 are projected to be $390,188. While next year, revenues are proposed to total $359,000. Proposed ending balance for FY 2003/2004 is $744,346. Expenditures for Administration, Accounting, and management of the Westlake Visitor's Association Fund are $113,258 for FY 2002/2003. FY 2003/2004 proposed expenditures for the Westlake Visitor's Association total $86,473. The decrease in expenditures is due to a more representative allocation of expenses across the fiends. xvii s s n 't N O 00 O C0 M O to rr I�r era N C O COI) � O O r 'C !) 17 C(4CD ca N CF 0 ^7 00 N Cn f-_ t0 4 O O O CIt � 04 tD O} ODp m 00 Cl) M r..:,MCl) O O V" C'O'1 p tiY O M ti LL7 to m O C N O lA O � N04 CD N ® LO O CO 00 M h CD r 04 0 r V 0 C? ei M V 00 O N cl Cta C'i C)3 M to 'd' t+) m O to C(D '�} m 00 Ln CO0 tf) 0 0 !to 04 N 0 N N 000 N O p 00 O c0 C7 CCy OC CD M C7) O h 00 - O m M COD O) m r O Ln v Cf 1!) �.t 0) O Ci [*) U N !~+ CD )a) r V v M S`i V) 0) � to � M M CD 00 CD U) T r O CD CD O CD O V O Q) O CD O Q CO O M N C) CD CF N O <F 4 O 0 0 N O? W Cl) LO r -I N Ci) N Cl) CLO Ij 00 N O d1 W 4) 00 O CD CD (3) Cro li M O co !� N r- 0) W CO M �^ U= CO*)_ 000 40 00 0 1, 0 Cl) Of co CDr V' r CC) C7 Cr) O V) N O N O r CD OD V O CA N Cfl C3 Cry CD 4 O O] 9 N 00 W V OD .07 C6 vi co 0 cl' h SOV !ry M N 0 0 h N C 000 M S7 r V) Crj �-- 04 CO Q) 1C7 r N r !19 r r r CO O O 0 O CNS! M O co m m N N N d' Q O O O O C' CA O CAO N CD CO m lr co m O c CD M M r 0O O q)) N 00 CD � C� fC) NO N s}' 0) N CD SD Ni pl�C) N CV 0) C0 CD co lir -)CR � U) co LO N N '� : t N t t R 00 P- U �^ N !D r V r r CD (f7 U) US fll rL O E m a U) N ') 'a o N CO o CO D y = nMn 2 LL LL N 'C1 N 0 N O Ns C a .2 0❑ C c E ami cl . U. di6 E CD '-' `' CO C N LL m R) �` in C.3 R O N E M a o w E E2 [22 U�ma`��-U U a a c ca C9 x .N W CO r m L 4:'a a a a Q 0 Cv�o E E E c c 4)z as U U i` rri Q w f" m` C ' j m .i+ �1 3 .) SL A F- � F- Z 'C ` U C Oi C d U � U C} � C y � 16 ❑ M C ¢ a!L mOm O LU :X J Z r W CDM m LWL /r V z 0 It r- h d T COD Oo7 co CO 0 aQ O q N (0V l� I� (7 W CD V C4 O r coS W 000 m N b N V M CO m lzr m r r n m m co cls rn m IT 03 NN CD +��j M 00 [b +T''I� c'•S iS M cD T co cit r to CJ N L'7 ~ r_ r m N O m m V (D CO o O (!l V Oq M CC d, T m CL7 N N Ln m 0 0 Cx7r 0 7` r; N V CD M �' T r m to rn o o 00 lr7v v V LO � m N ri ch o CS�7 dV' O N B c h OO CT7 N M r O co co 0 co V CmfJ_ � 0 Cf1 h L,2 Cfj h V 6V7 V COTr coc LO u? +ct d V rT'Il m aO P I� CYJ (P O 0 r (flh m ti N to V m N O 0) � (0D � M O r CO Cm*7 O OI N r if LON I,- O V Ln V O m O N LO 4i C4 I, Gj 0 V' m CSi `cF' CO Lor m V Ci' N N 1� G1 TLri N V (m0 O p co N C.0 V CO CA coL N N M a CA C7 R N d' CA V 0 V t0D N O N un r m w O R ONO fW V vi aJI N W C 1 V N Go M Cl) CO V N m (O f77 a J N O- CA V co T ti O cn V 'SF C (O7k1 V C� T (C CO 10 co Cl) C7 CD Cl) m (D (7 m CIO ' 607 m Cl ETD o p co Ca CO t! � C' N C5 co m m O OV7 V 00 N N m cDO *? t�D qG V V U) 0 w C C 67 O 0 G Co y ? UE m c o N w CLL 0u ami c l mc: .20000 C Cp (O C � '8 7 s ami ru c o n ;; El L7 ? U N v=- E U °8 L E 5, i N CO ftl tJ ami Q7 'C � C3 u C1 E m m ri `o_ m a a7 � e N v m V? U) c U -t IL C3 = m U7 C Q" 0 * 7 .L v v EL[ v CT N7 Sh C CL cl CL CL a d c a 4 cu Z ro m L C C C y Ep U U U V 67 `� 3 i w a(D al X LUR� = 3 7 7 LL v ? , �' �° �"• EIA H Z CD .0 41 U U U �. C6 Ei C N C H O 4 {O ID C. w m o ul IL x `x Employee Summary FY 200312004 9/9/2003 xx FY 00-01 FY 01-02 FY 02-03 FY 03-04 Town Manager 1 1 1 1 Assistant to Town Manager 1 1 1 1 Finance Director 0 0 1 1 Part-time Intern 1 1 1 1 Office Manager 0 1 1 0 Personnel Manager 0 0 0 1 Administrative Assistant 0 1 1 0 Public Works Superintendent 0 0 0 1 Part -Time Parks & Recreation Coordinator 0 0 0 1 Town Secretary 1 1 1 1 Accounts Payable Clerk 0 1 1 1 Fire/EMS Coordinator 0 1 1 1 Firemen/Medics 0 0 9 9 Municipal Court Clerk 0 1 1 1 Municipal Court Deputy Clerk 0 0 0 1 Municipal Court Judge 0 1 1 1 Municipal Court Marshall 0 1 1 1 Total 4 11 21 23 9/9/2003 xx Town of Westlake Goals Report IY 2903/2004 1, Meet growing residential service demand a. Improve water and wastewater equipment efficiency b. install pressure reduction valve in Dove Rd. line c. Modify Fort Worth main valve to eliminate peak charge d. Install SCADA system for remote monitoring e. Take over meter reading f. Take over water and sewer billing g. Take over maintenance at Glenwyck Farms (contractual) h. Improve Ottinger Rd. i. Improve Dove/Pearson Intersection j. Install N-1 SCADA k. Transfer N-1 connection to TRA I° Support the revocation of 4A and adoption of Crime Control District to maximize service impact of sales tax dollars m. Provide justification for reduction in residential water rates n. Improve on-line access to community services 2. Strongly pursue commercial and retail development to expand sales tax base as Facilitate mall construction if project moves forward b. Create infrastructure reimbursement mechanism c. Enter into Section 380 Agreement d. Require new traffic studies to buffer residential areas e. Continue to spearhead FM 1938 construction f. Protect Fidelity private roadway g. Update Master Thoroughfare Plan - Developer paid h. Update Master Parks/Open Space Plan - Developer paid 1. Conduct election to allow sale of on premise mixed beverages to support restaurant attractiveness j. Install FM 1938 water line extension - Fidelity paid k. Gain 3771170 retail commitment I. Support Solana space leasing m. Identify and secure new grant funds to support small business 3. increase revenue without raising rates or implementing property tax a. Reduce outstanding warrant backlog b. Sell additional duct bank space leases 4. Reduce spending without reducing services a. Investigate additional water sources for park and open space irrigation b. Reduce reliance on outside consultants when cost can be reduced by using in-house personnel c. Privatize or contract services that can be conducted more efficiently and effectively xxi 5. Maintain competitive and motivated workforce a. Increase salaries 5% b. Maintain current benefits c. Complete Employee Handbook (in-house) d. Develop pay step system for all employees 6. Support Community Involvement activities a. Support Tree City USA events b. Support Westlake Historical Society efforts 7. Improve Westlake Hotel occupancy a. Kickoff Westlake Art Fund b. Kickoff Westlake Historic Renovation and Revitalization Project c. Provide direct advertising and marketing support for Marriott 2002!2003 1. Update Master Thoroughfare Plan a. Because of the uncertainty of the mall, the pian update has been put on hold 2. Update Master Open Space Plan a. Because of the uncertainty of the mall, the plan update has been put on hold 3. Update Comprehensive Land Use Plan and Zoning Maps a. Because of the uncertainty of the mall, the plan update has been put on hold 4. Improve'Westlake's self sufficiency a. Hired a Finance Director to streamline accounting process b. Hired a Public Works Superintendent to relieve outside contractors of a portion of their duties 5. Continue to evaluate new revenue enterprises a. This is an on-going goal of the Town and retrains a continuous effort 6• Attract new retail and commercial development in compliance with Town standards a. While the mall project is currendy unknown, the Town has attempted to assist Maguire Partners in business attraction as well as supported the local and regional commercial real estate commwaity and provided information about Westlake. It is Hoped that the properties ovvned by Hillwood along 377 and 170 may develop in FY 2003/2004. 7. Budget, Organize, Staff and open the Westlake Academy, Fall 2003 a. Completed 8. Prepare plan to move Fire/EMS to permanent facilities a. This plan has been delayed due to the mall delay 200112002 1. Continue to maintain and improve service and development standards a• Insure that all quality standards adopted for the Town via the UDC are also adopted for the PD's b. Update the master thoroughfare plan to protect residential standards and improve commercial access and attractiveness c. Update open space (trail) plan as major new developments occur d. Overlay Dove Rd. from east city limit to FM 1938 e. See that all residents have adequate telecom utility choices 2. Improve revenue -generating capacity a. tease FM 1938 section of duct bank, Vaquero section, and Kirkwood section (yield approximately 250k for twenty year lease) b. Investigate creation of home/business alarm enterprise c. Complete 50,000 sq. ft. of new commercial sales tax producing enterprise 3. Provide financial and planning support for the Westlake Academy a. Conduct space utilization plan and design for joint facilities b. Sell bonds for project and begin capitalizing interest where applicable c. Secure site d. Hire headmaster in 4th quarter 4. Insure that development revenues support development costs a. Establish PO system of charges for professional services that is Capital Project based b. Perform fund accounting audit to identify and separate development costs and revenues 5. Improve cost efficiency and quality of professional services to the Town a. Investigate costs, structure, service and efficiency comparison for independent Department of Public Safety b. Hire full time employees in areas that have exceeded consultants and/or contracted agents effectiveness and/or efficiency General Fund Program Summary General Fund Actual FY 01102 Amended FY 02103 Projected FY 02103 Proposed FY 03104 Beginning Balance 1,987,653 1,807,054 1,806,902 1,624,384 Revenue '* 2,578,603 2,318,559 2,702,810 3,354,819 Transfers In 803,306 - 1,377,858 2,180,430 Expenditures 2,335,693 2,270,836 2,660,996 3,309,668 TransfersOut- Reserves 1,226,967 474,590 1,602,190 2,265,951 Ending Balance 1,806,902 1,616,402 1,624,384 1,584,013 Restricted Funds 496,121 259,802 157,390 186,240 Funds Available 1,310,781 1,356,600 1 1,466,994 1,397,773 # Days Operating in Reserves 2821 2601 223 175 * Revenue includes the 112 cent sales tax which will be recognized by the Crime Control District. This revenue is in the General Fund Operating Budget because the Town's expectation is that the money will be automatically transferred every month to defray a portion of the Keller Police Contract. 9/9/2003 2:55 PM General Fund Program Summary General Fund Transfers In Actual Amended FY 01/02 FY 02103 Projected FY 02103 Proposed FY 03104 Transfers In Transfers Out Utility Fund TC / WL DPS 2000/2001 Shortfall 90,695 4A Dissolved Funds - - - 1,176,437 4B Debt Service for Civic Campus - - - 742,080 Civic Campus Bond Funds - - 927,600 261,913 Bond Interest Earnings (Prior Year) - 232,024 - Capital Projects - 4A Dissolution for Crime Control District - FM 19381 114 Interchange Improvements - 4A - 218,234 Utility Fund Loan Auditor's Corrections (for prior years) 803,306 157,390 186,240 Total Transfers In 803,306 1 - 1,377,858 2,180,430 General Fund Reserves Transfers Out Actual FY 01/02 Amended FY 02103 Projected FY 02103 Proposed FY 03/04 Transfers Out TC / WL DPS 2000/2001 Shortfall 90,695 - - - DPS 1st Quarter Payment TC 1 WL 97,295 - - - TC 1 WL DPS Buyout 100,251 - - 75,000 Keller Police Services 6/02-9102 108,094 - - - 4A Dissolution for Crime Control District - 102,412 - 530,296 Utility Fund Loan 496,121 259,802 157,390 186,240 Duct Bank Reimbursement - Vaquero - 38,420 38,420 - Keller Reimbursement 2000 40,400 - Peak Payment 95,000 - - 2002 Certificates of Obligation - 927,600 742,080 2003 Certificates of Obligation - 261,913 Capital Projects 377 ROW Purchase from TxDOT - 221,000 221,000 - Civic Campus 79,870 - - Dove Road Escrow 85,000 - - - Dove Road Overlay 30,000 - - Fire & Rescue 319,892 215,170 215,170 - FM 1938 Escrow 140,000 200,000 458,662 FM 1938 / 114 Interchange Improvements _ _ _ 273,000 Circle T MUD Deannexation 40,470 - - Total Transfers Out 1,226,967 474,590 1,602,190 2,265,951 General Fund - Restricted Actual FY 01102 Amended FY 02/03 Projected FY 02103 Proposed FY 03104 Restricted Funds Court Security 26,953 41,138 41,138 56,488 Court Technology 30,434 41,252 41,252 54,752 Trail Escrow 75,000 75,000 75,000 75,000 FM 1938 363,734 102,412 - Total FM 1938 363,734 102,412 - - Total Restricted Funds 496,121 259,802 157,390 186,240 9/9/2003 2:55 PM Income 313.000 Sales Tax 313.100 Sales Tax Revenue Total 313.000 Sales Tax 314.300 Mixed Beverage Tax 314.300 Mixed Beverage Tax Total 314.300 Mixed Beverage Tax 318.200 Franchise Taxes 318.210 Other 318.211 AT&T 318.220 Verizon 318.240 TXU Gas 318.250 Charter Communication 318.260 One Source 318.270 Southwest Bell 318.280 Tri County Electric 318.290 Trinity Waste Services Total 318.200 Franchise Taxes 322.000 Licenses & Permits 322.100 Building Permits 322.200 Liquor Permit Fees Total 322.000 Licenses & Permits 330.000 FlreIEMS Income 330.100 EMS User Fee 330.200 Fire Code Permits Total 330.000 FirelEMS Income 341.300 Development Fees 341.310 Development Fees 341.320 Contractor Registration Fees 341.330 Special Event Fee Total 341.300 Development Fees 341.400 Sales of Printed Material 341.400 Sales of Printed Material * 370.000 Historical Journal Subscriptions Total 341.400 Sales of Printed Material 351.000 Westlake Court Revenues 351.100 Citation Revenue 351.200 Court Technology 351.300 Court Security 351.400 Warrant Rev. - Supplemental Officers 351.500 Warrant Fees 351.600 NSF Check Fees 351700 Court Efficiency Fees General Fund Budget 2003/2004 Actual Budgeted Projected Proposed FY 01102 FY 02103 FY 02/03 FY 03104 594,407 900,000 900,000 750,000 584;407 900,000 900,000. 73fJ,ft00,; 9,256 10,000 9,500 8,000 3,427 9,400 6,152 6,000 68,222 41,000 35,000 40,000 1,723 2,100 2,724 2,724 6,595 6,500 6,000 7,000 157 152 160 180 337 550 550 606 93,403 87,000 87,327 87,350 164,721 135,000 145,966 200,000 8,761 5,400 7,500 8,000 208,383 200,000 300,000 250,000 1,420 1,100 750 750 0 6,500 6,500 10,680 1,200 1,000 338 500 29,005 200,000 175,000 170,000 6,500 12,000 15,600 15,600 500 500 500 500 600 500 507 500 1,500 9,500 0 373,677 450,000 482,054 475,000 15,931 20,000 19,825 22,500 11,972 15,000 15,056 17,000 0 0 0 168,000 7,000 8,706 10,000 175 1,200 576 1,200 0 220 0 250 9/9/2003 3 2:55 PM Income Total 351.000 Court Fees Received 361.000 Interest Earned 361.100 Gen. Fund interest Earned 361.200 Muni. Court Interest Earned 361.300 Bond interest Earned Total 361.000 interest Earned 375.000 Glenwyck Farms H.O.A. Reimbursement 394.000 Misc. Income Transfers From Other Sources EMS Startup DPS Shortfall 2000/2001 DPS 2001/2002 1st Qtr. Payment TC 1 WL DPS Buyout Keller Police Contract 6102-9102 Kaleidoscope i WL Acad. Dove Road Overlay - Private Glenwyck Farms Waterline EMS Grants FM 1938 Rowland Arthur Maguire Partners Southlake, Keller MUD Deannexation Duct Bank Reimbursement - Vaquero Total Transfers From Other Sources Transfer From Utility Fund Repayment of Infrastructure Loan Interest Earned on Loan Repayments Total Transfer From Utility Fund Transfer From Crime Control District Crime Control District for Keller Police Total Transfer From Crime Control District 4A Dissolution Revenue For Keller Police Total Income Total Expenses Net to General Fund General Fund Budget 2003/2004 Actual Budgeted Projected Proposed FY 01102 1 1 FY 02103 FY 02143 FY.03104 401,755 1 493,420 1 526,217 1 693,950 41,380 17,000 17,000 18,000 87 50 60 60 103,000 5,500 319,892 0 0 0 90,695 0 0 0 97,295 0 0 0 100,251 0 0 0 108,094 0 0 0 79,871 0 0 0 85,000 0 0 0 15,000 0 0 0 0 0 211,413 0 0 0 0 101,739 0 0 0 246,353 0 0 0 73,713 40,470 0 0 0 0 38,420 0 0 0 135,000 135,400 0 14,217 0 0 0 0 0 116,668 2,578,603 2,318,559 2,702,810 3,354,819 2,335,693 2,270,836 2,660,996 3,309,668 See Attached sheet, Board Appointed Entities * Assumes Crime Control District is adopted by Westlake voters in November Election. 9/91201)3 4 2:55 PM Expenses 410,100 Payroll Expenses 410.110 Salaries 410.110 Salaries 410,120 Internships Tota1410J10 Salaries 410.130 TMRS 410.140 Insurance 490.141 Health 410.142 Dental 410,143 LTD, AD&D, Life Total 410.140 Insurance 410.150 Worker's Compensation 410.160 Admin. Fee 410.100 Payroll Expenses -Other Tota1410.100 Payroll Expenses 410.200 Payroll Taxes 410.220 FICA 410.221 Medicare 410.253 Unemployment Taxes Total 410.200 Payroll Taxes 410.300 Professional Services 410.310 Administrative Expense 410.310 Administrative Expense Total 410.310 Administrative Expense 410.320 Traffic Services 410.330 Legislative 410.350 Engineering Fees 410.351 Civil Engineering 410.353 Duct Bank Engineering 410.354 Legal Engineering Fees 410.355 Misc. Engineering Fees Total 410.350 Engineering Fees 410.360 Legal 410.361 Boyle & Lowry 410.362 Goins, Underkofier 410.363 Lloyd, Gosselink 410.364 Misc. Legal Total 410.360 Legal General Fund Budget 2003/2004 Actual. Budgeted Projected Proposed , FY 01102 FY 02103 FY 02103 FY 03104 . 106,722 156,450 150,000 175,421 0 0 8,500 22,440 7,750 15.000 10,482 11,000 1,995 3,000 2,571 3,369 1,053 1,500 1,500 9,711 2,080 i [ ` /323 j3C2�3 55 1,203 1,203 3,257 65 0 0 0 893 500 499 750 4,889 6,610 9,827 12,267 1,556 1,600 2,298 2,869 3,951 2,�5y0/0� 0 0 2,080 i [ ` /323 j3C2�3 3&¢,009 ?3,000 121;250 200;040' 87,360 29,030 46,432 102,375 171,313 20,000 45,000 25,000 6,890 0 0 0 4,080 0 0 0 2,080 2,500 1,735 2,500 290,437 90,000 85,000 165,000 40,096 1,000 15,000 25,000 10,153 6,000 6,250 0 45,322 6,000 15,000 10,000 3&¢,009 ?3,000 121;250 200;040' 5 9/9/2003 2:55 PM Expenses 410.370 Planners Fees 410.371 Planners Fees Total 410.370 Planners Fees 410.380 Professional Consulting Fees 410.380 Professional Consulting Fees 410.381 Technology Consultant Total 410.380 Prof. Consulting Fees 410.380 Financial Consultants 410.390 Financial Consultant 410.391 Auditor Total 410.391 Financial Consultants Total 410.300 Professional Services 410.400 Contracted Services 410.410 DPS Expense 410.411 Trophy Club 1 Westlake DPS 410.412 Shortfall DPS 200112002 1st Qtr. Payment TC I WL DPS Buyout 410.413 Keller Police Contract Total410.410 DPSExpense 410.420 Maintenance & Repairs 410.421 IT Infrastructure 410,422 Copier Repairs & Maint. 410.423 Road Repairs & Maint. 410.424 Sign Repair & Maint. 410.425 ROW Irrigation 410.426 Facilities Maintenance m Civic Campus 410.427 Mechanical System Maintenance 410.428 Landscape Maintenance iGlenwyck Farms ROW/Civic Campus Accounting Software Maintenance Total 410.420 Maintenance & Repairs 410.430 Courier Service 410.450 Codification 410.460 Building Inspection Total 490.400 Contracted Services - Other 410,440 Rent 410.441 Office Rent Total 410.440 Rent Genera[ Fund Budget 200312004 . Actual Budgeted Projected Proposed FY 01102 . FY 02103 I FY 02103 1=Y 03104 1,195 0 0 0 1,1J5 I _ 0.11 0 0 0 5,600 0 0 74,182 0 0 0 74,182 5,600 0 O f 58,418 12,000 78,462 6,500 0 0 0 26,250 829,444 224,136 `` 356,179: 389,62x' 178,199 0 0 0 90,695 0 0 0 97,295 0 0 0 100,251 0 0 0 108,094 635,220 635,220 646,964 ' 579;534 :"'635,.220. 635,221) � 646i_�64?: 41888 3,500 2,600 3,500 1,200 4,300 4,300 4,000 31,543 22,000 16,500 20,000 2,270 6,000 5,000 5,000 30,864 10,000 26,400 25,000 0 0 0 25,000 0 0 ❑ 10,000 0 0 0 18,000 0 0 0 42,000 0 0 0 4,500 70;764.: 45,800 54,$00 157,000 1,604 9,200 750 850 6,464 6,000 6,080 4,000 93,054 90,000 175,000 90,000 748;421 778,220 871,850 898,814 46,051 52,500 62,871 10,308 46,051 52,500 62,871 10,3081 91912{303 6 2:55 PM Expenses 410.500 insurance 410.520 Insurance - Liability Insurance - Property Total 410.500 Insurance 410.530 Telephone 410.531 Telephone Expense (65%) 410.532 Mobile Phone 410.533 Internet Expense (65%n) 410.534 Phone System Lease (65%) Total410.530 Telephone 410.540 Interest Expense 410.580 Travel 410.581 Airfare 410.582 Car Rental 410.583 Lodging 410.584 Other 410.585 Meals 410.586 Mileage 410.587 Training, Seminars, Meetings Total 410.580 Travel 410.600 Office Expense 410.601 Office Expense - General 410.602 Office Equipment 410.603 Dues & Subscriptions 410.604 Postage 410.605 Printing 410.606 Books & Printed Materials 410.607 Bank Charges 410,608 Moving Expense 410.609 Petty Cash Total 410.600 Office Expense 410.700 utilities 410.701 Gas Utility 410.705 Storm Water Management Total 410.700 Utilities 410.800 Fire/EMS 410.801 Salaries 410.802 Standard Overtime 410.803 FLSA Overtime 410.804 Part Time Contractors 410.805 Personnel Insurance 410.806 TMRS 410.807 Payroll Taxes 410.808 Fire Equipment & Supplies General Fund Budget 2003/2004 Actual I Budgeted Projected Proposed FY 01102 FY 02/03 FY 02103 FY 03104 061 4,000 3,494 8,350 0 0 0 8,842 1,241 '- 4,1100 J. 3,494 37,./92 11,493 10,000 9,455 5,070 2,188 2,000 1,909 1,640 1,241 1,500 858 1,853 2,241 2,300 2,245 383 F 474 1,250 1,824 1,000 80 500 0 0 1,036 500 303 500 8 0 0 0 983 1,000 1,300 1,300 713 800 469 450 1,227 1,000 750 1,500 20,885 10,000 10,000 10,000 815 2,000 800 1,000 5,259 5,700 6,536 7,000 2,892 3,500 4,750 4,500 1,227 1,500 1,446 1,500 395 500 503 500 310 125 113 200 0 0 0 5,000 (50) 200 20p0 0 7 181 400 700 2,500 7,050 4,706 4,706 0 182,641 475,000 459,906 469,250 0 0 0 8,960 0 0 0 29,515 0 0 0 19,090 864 31,000 36,000 51,979 3,469 30,000 24,000 39,886 2,842 25,000 24,000 36,908 56,939 0 0 0 9/9/2003 7 2;55 PM General Fund Budget 2003/2004 Actual Sudgeted jected PFY Proposed Expenses Y 01/02 FY 02103 . 02103 IIII�I�1lIM��I��I FY @3104 IIUYIMi�lll�� 410.809 Office Supplies 4,515 5,000 1,470 2,000 410.810 Vehicle Fuel I Maint. 0 15,000 9,284 11,705 410.811 Computer Equip. I Software 0 1,500 1,433 4,000 410.812 Facility Supplies 0 6,000 4,772 11,450 410.813 Misc. Supplies 0 2,500 1,512 2,500 410.814 Auto Allowance 3,002 0 0 4,800 410.815 Contracted Service 56,887 10,000 17,628 18,295 410.816 Mobile Phones 978 1,000 731 1,000 410.817 Licenses & Registration 1,548 8,000 8,875 2,450 410.818 Telephone 1,135 1,500 1,369 1,850 410.819 Medical Supplies & Equipment 18,483 4,500 3,758 4,500 410.820 Travel, Training, Publications 1,516 3,000 3,039 17,015 410.821 Utilities 4,721 6,500 5,943 7,600 410.822 Property Insurance 0 6,420 6,420 3,685 410.823 Pre-employment Testing 0 3,500 3,500 1,975 410.824 Firefighter Physicals 0 0 0 4,250 410.825 Uniforms/Personal Gear 0 0 0 9,060 410.826 Weapons & Accessories 0 0 0 10,990 410.827 Supplemental Officers for Warrants 0 0 0 57,824 410.828 Vehicle for Supplemental Officers 0 0 0 41,984 %fa1410.800 FireJEMS 39;539 „3,,e _._ . 5 5,42ft F13,ii4[7 574 2lI, 410.900 Municipal Court Expense 410.901 Salaries 72,664 135,000 126,280 116,124 410.902 Court Technology 7,741 9,000 8,484 14,000 410.903 Court Supplies 4,566 4,500 3,816 4,500 410.904 Personnel Insurance 9,196 15,000 16,781 23,285 410.905 Court Security 2,742 1,500 2,831 1,650 410.906 Payroll Taxes 3,613 7,500 7,400 9,186 410.907 TMRS 4,549 10,140 8,800 9,871 410.908 Misc. Court Expense 11,851 4,600 3,915 4,600 410.909 Training & Seminars 726 2,250 2,139 3,430 410.910 Paymentech Service 481 1,200 1,505 1,200 410.911 Printing 710 4,900 3,350 4,900 410.912 Marshal's Vehicle 6,667 0 0 0 410.913 Legal Services 9,003 9,500 10,924 35,420 410.914 Marshal's Vehicle Maintenance 164 2,500 2,447 3,450 410.915 Courtroom Expense 0 0 0 5,600 Insurance 0 0 0 605 Total 410.900 Municipal Court Expense 134 tii4, :MT 411.000 Publlc Warks 411.100 Public Works Superintendent 0 0 2,917 17,500 411.200 Parks & Recreation Director 0 0 0 20,000 411.300 Public Works Vehicle 0 0 7,500 0 411.400 Supplies 0 0 1,000 0 411.500 Maintenance 0 0 0 1,500 411.600 TMRS 0 0 248 3,188 411.700 Payroll Taxes 0 0 233 2,899 411.800 insurance 0 0 292 1,750 Personnel Insurance 0 0 0 4,394 9/912003 8 2.55 PM Expenses Worker's Compensation Total 411.000 Public Works 415.000 Community Expense 415.100 Community Services 415.200 Public Notice Expense * 415.300 Historical Preservation Board * 415.400 Tree City USA Advisory Committee 415.500 Election Expense 415.600 Meeting Expense Total 415.000 Community Expense 419,000 Misc. Expense 420.000 Contingency 421.000 Duct Bank Reimbursement -Vaquero FM 1938 Capital Project Expense 422.000 Westlake Portion FM 1938 Capital Project Expense Total FM 1938 Capital Project Expense 700.000 Capital Outlay 700.743 Public Works Superintendent vehicle EMS Grant Used for FirelEMS Total Expenses Total Income Net to General Fund * See Attached sheet, Board Appointed Entities General Fund Budget 2003/2004 Actual Budgeted Projected Proposed FY 01102FY 02103 FY 02103 FY 03t04 E 0 0 60 750 0 Q 72,25,0 51,981 9,477 10,000 7,750 8,000 6,429 2,500 873 2,000 8,450 0 8,000 4,000 (83) 1,500 1,500 2,680 995 1,200 15 1,200 0 0 150 0 0 0 36,857 0 0 0 421,805 2,335,693 2,270,836 2,660,996 3,309,668 2,578,603 2,318,559 2,702,810 3,354,819 9/9/2003 2.55 PM Town of Westlake Public Safety (Included in General Fund Budget) Revenue 330.000 FireIEMS Income 330.100 EMS User Fee 330.200 Fire Code Permits Total 330.000 Fire/EMS Income 351.000 Westlake Court Revenues 351.100 Citation Revenue 351.200 Court Technology 351.300 Court Security 351.400 Warrant Rev. - Supplemental Officers 351.500 Warrant Fees 351.600 NSF Check Fees 351.700 Court Efficiency Fees Total 351.000 Court Fees Received Total Revenue Expenditures 410.800 FirelEMS 410.801 Salaries 410.802 Standard Overtime 410.803 FLSA Overtime 410.804 Part Time Contractors 410.805 Personnel Insurance 410.806 TM RS 410.807 Payroll Taxes 410.808 Fire Equipment & Supplies 410.809 Office Supplies 410.810 Vehicle Fuel I Maint. 410.811 Computer Equip, I Software 410.812 Facility Supplies 410.813 Misc. Supplies 410.814 Auto Allowance 410.815 Contracted Service 410.816 Mobile Phones 410.817 Licenses & Registration 410.818 Telephone 410.819 Medical Supplies & Equipment 410.820 Travel, Training, Publications 410.821 Utilities 410.822 Property insurance 410.823 Pre-employment Testing 410.824 Firefighter Physicals 410.825 Uniforms/Personal Gear 410.826 Weapons & Accessories 410.827 Supplemental Officers for Warrants 410.828 Vehicle for Supplemental Officers Total 410.800 Fire/EMS Actual Budgeted Projected Proposed FY 01102 FY 02103 FY 02103 1=Y 03104 0 6,500 6,500 10,680 1,200 1,000 338 500 '. ,'x,200. .. ,_of?. '. 6,83$ _::: ._i,i80 373,677 450,000 482,054 475,000 15,931 20,000 19,825 22,500 11,972 95,000 15,056 17,000 0 0 0 168,000 864 7,000 8,706 10,000 175 1,200 576 1,200 0 220 0 250 402,955 500,920 533,055 705,130 182,641 475,000 459,906 469,250 0 0 0 8,960 0 0 0 29,515 0 0 0 19,090 864 31,000 36,000 51,979 3,469 30,000 24,000 39,886 2,842 25,000 24,000 36,908 56,939 0 0 0 4,515 5,000 1,470 2,000 0 15,000 9,284 11,705 0 1,500 1,433 4,000 0 6,000 4,772 11,450 0 2,500 1,512 2,500 3,002 0 0 4,800 56,887 10,000 17,628 18,295 978 1,000 731 1,000 1,548 8,000 8,875 2,450 1,135 1,500 1,369 1,850 18,483 4,500 3,758 4,500 1,516 3,000 3,039 17,015 4,721 6,500 5,943 7,600 0 6,420 6,420 3,685 0 3,500 3,500 1,975 0 0 0 4,250 0 0 0 9,060 0 0 0 10,990 0 0 0 57,824 0 0 0 41,984 339,539 535,420 :. 613;640: &74,521 9/9/2003 9a 2:55 PM 410,900 Municipal Court Expense 410.901 Salaries 410.902 Court Technology 410.903 Court Supplies 410.904 Personnel Insurance 410.905 Court Security 410.906 Payroll Taxes 410.907 TMRS 410.908 Misc. Court Expense 410,909 Training & Seminars 410.910 Paymentech Service 410.911 Printing 410.912 Marshal's Vehicle 410.913 Legal Services 410.914 Marshal's Vehicle Maintenance 410.915 Courtroom Expense Insurance Total 410.900 Municipal Court Expense 410.413 Keller Police Contract 72,664 135,000 126,280 116,124 7,741 9,000 8,484 14,000 4,566 4,500 3,816 4,500 9,196 15,000 16,781 23,285 2,742 1,500 2,831 1,650 3,613 7,500 7,400 9,186 4,549 10,140 8,800 9,871 11,851 4,600 3,915 4,600 726 2,250 2,139 3,430 481 1,200 1,505 1,200 710 4,900 3,350 4,900 6,667 0 0 0 9,003 9,500 10,924 35,420 164 2,500 2,447 3,450 0 0 0 5,600 0 0 0 605 Total Expenditures 582,307 1,478,230 1,447,532 1,759,306 9/10/2003 9:57 AM General Fund Receivables and Payables From Other Sources Actual Actual Projected Proposed ReceivablelPayable FY 00!01 FY 01102 FY 02103 FY 03/04 Receivables Utility Fund Peak Payment Reimbursement 0 0 40,400 0 Keller Reimbursement 0 0 95,000 0 Total Utility Fund Q fflw135,400,_ 7' 4A FM 1938/114 Interchange Improvements 0 0 218,234 0 Dissolved Funds ❑ 0 0 1,176,437 Total 4A234;"" 4B Debt Service for Civic Campus 0 0 0 742,080 Total ,4B Crime Control District CCD Funds for Keller Police 0 0 0 116,668 Total Crime Control District Miscellaneous Auditor's Corrections 803,306 Total Miscellaneous Actual Actual Projected Proposed FY 00101 FY 01102 FY 02103 FY 03104 Payables Utility Fund Keller Payment 0 40,400 0 0 Peak Payment 0 95,000 0 0 Duct Bank Reimbursement - Vaquero 0 0 38,420 0 Total Utillty Fund 9/9/2003 10 2:55 PM Town of Westlake Certificates of Obligation Series 2002 ues & EXpenSeS Revenues Par Value 12,400,000.00 Total Revenues $ 12,400,000.00 Expenses Capitalized Interest Fund 927.600.00 Standard & Poor's 9,000°00 Allen Moon 11,750.00 John F. Boyle 5,750.00 Bowne of Dallas 1,820.00 Larry Williamson 104,000.00 Lawrence Financial Consulting LLC 20,000.00 Total Expenses $ 1,079,920.00 9/10/2003 11 9:58 AM Loan Repayment Schedule Civic Campus Bonds Year End The Certificates 9= P-rincipal Interest Total 2002 $0 $0 $0 2003 0 927,600 927,600 2004 0 742,080 742,080 2005 0 742,080 742,080 2006 210,000 742,080 952,080 2007 225,000 728,430 953,430 2008 235,000 713,805 948,805 2009 250,000 698,530 948,530 2010 265,000 682,280 947,280 2011 280,000 665,055 945,055 2012 295,000 646,855 941,855 2013 315,000 627,680 942,680 2014 330,000 607,205 937,205 2015 350,000 585,755 935,755 2016 365,000 563,005 928,005 2017 385,000 539,280 924,280 2018 405,000 514,255 919,255 2019 425,000 490,968 915,968 2020 445,000 466,530 911,530 2021 470,000 440,943 910,943 2022 495,000 413,918 908,918 2023 520,000 385,455 905,455 2024 550,000 355,555 905,555 2025 580,000 323,930 903,930 2026 610,000 290,290 900,290 2027 640,000 254,910 894,910 2028 675,000 217,790 892,790 2029 710,000 178,640 888,640 2030 750,000 137,460 887,460 2031 790,000 93,960 883,960 2032 830,000 48.140 878,140 Totals $12,00,000 $1 x.824.464 $27.22464 9/10/2003 12 10:00 AM Town of Westlake Certificates of Obligation (2nd Series) 2003 Sources Par Value Accrued Interest Total Sources of Funds Uses: Deposit to Debt Service Fund Deposit to Construction Fund Original Issue Discount Costs of Issuance Rounding Underwriter's Discount Total Uses of Funds 6,410,000.00 17,460.00 $ 6,427,460.00 17,460.00 5,900,000.00 58,387,50 322,000.00 1,409.90 128,202.60 $ 6,427,460.00 9/1012003 13 9:59 AM Date Moan Repayment Schedule Town of Westlake Certificates of Obligation - Second Series 2003 Net Debt Service Schedule Principal Interest Total Principal & Interest 2003 $ - $ - $ - 2004 - 261,913 261,913 2005 - 285,724 285,724 2006 140,000 285,724 425,724 2007 145,000 282,924 427,924 2008 145,000 279,444 424,444 2009 150,000 275,529 425,529 2010 155,000 271,029 426,029 2011 160,000 265,914 425,914 2012 165,000 260,314 425,314 2013 170,000 254,291 424,291 2014 175,000 248,001 423,001 2015 185,000 241,220 426,220 2016 190,000 233,820 423,820 2017 200,000 225,840 425,840 2018 210,000 217,240 427,240 2019 220,000 208,000 428,000 2020 230,000 197,550 427,550 2021 240,000 186,625 426,625 2022 250,000 175,225 425,225 2023 260,000 163,350 423,350 14 2024 275,000 151,000 426,000 2025 290,000 137,250 427,250 2026 300,000 122,750 422,750 2027 315,000 107,750 422,750 2028 335,000 92,000 427,000 2029 350,000 75,750 425,750 2030 365,000 57,750 422,750 2031 385,000 39,500 424,500 2032 405,000 20,250 425,250 $ 6,410,000 $ 5,623,677 $ 12,033,677 15 Board Appointed Entities Approved Proposed Net Owed to Westlake Academy Foundation F 00/01 FY 01102 FY 02103 FY 03/04 GF Revenues Donations / Fund Raising 0 0 0 0 Town 0 0 25,000 0 Carry Over from Previous Year 0 0 0 25,000 Expenses 0 0 0 0 Town Reimbursement 0 0 0 0 Net 0 0 25,000 25,000 Expense to 4A 0 0 25,000 0 25,000 This account will be transferred to GF after 4A is dissolved Approved Proposed Net Owed to Westlake Historical Preservation Board F 00101 FY 01102 FY 02103 FY 03104 GF Revenues Donations / Fund Raising Town Carry Over from Previous Year Expenses Town Reimbursement Net Expense to General Fund Tree City USA Revenues Donations / Fund Raising Town Carry Over from Previous Year Expenses Town Reimbursement Net Expense to General Fund 0 9,500 2,500 8,450 0 4,000 0 0 1,500 8,450 8,000 8,000 0 0 1,500 0 0 8,450 0 4,000 12,450 Approved Proposed Net Owed to F 00101 FY 01102 FY 02103 FY 03104 GF 0 83 1,500 2,680 0 0 0 83 1,500 500 0 0 0 2,180 0 83 1,500 2,680 4,263 9/10/2003 16 10:02 AM Utility Fund Program Summary Utility Fund Actual FY 01102 Budgeted FY 02103 Projected FY 02103 Proposed FY 03104 Beginning Balance 209,280 36,540 29,876 0 Auditor's Correction " - - - 76,626 - - Adjustments* - 38,420 (1,971) 135,000 - Corrected Beginning Balance 209,280 36,540 104,531 0 Revenue 727,972 1,051,517 1,030,084 977,850 Transfers In 135,000 - 38,420 - Expenditures 1,042,376 813,233 956,008 909,162 Transfers Out - I - 1 217,028 37,529 Ending Balance J 29,876 1 163,210 1 0 1 31,159 Utility Fund Transfers In Actual Budgeted FY 01102 FY 02103 Projected Proposed FY 02103 FY 03104 Transfers In Transfers Out General Fund General Fund Keller Reimbursement 40,000 - - Peak Payment 95,000 - - Duct Bank Reimbursement - Vaquero - - 38,420 Total Transfers In 135,000 - 38,420 - Utility Fund Transfers Out Actual Budgeted FY 01102 FY 02103 Projected FY 02103 Proposed FY 03104 Transfers Out General Fund Repayment of Peak Payment Loan - 95,000 Repayment of Keller Loan 40,400 4A Repayment of Duct Bank ** - 95,000 - 4B Repayment of Short Term Loan - 20,000 - Repayment of WL/Keller OH Storage *** - 118,887 81,628 1 37,529 Total Transfers Out - 233,887 217,028 1 37,529 * For the beginning balance of FY 02103, two adjustments have been made. First, as per the audit, an item that was expensed twice has been added back into the balance ($76,626). Second, the Adjustments line is for errors in the projection process. The $1,971 consists of $858 of budgeting error and $1,113 in rounding error of the 4B transfers (rounded to $140,000 when actual amount is $138,887). These adjustments allow for a beginning balance of $104,531 which is the proper beginning balance. ** Due to the dissolution of 4A, the loan to the Utility Fund for Duct Bank Construction will be forgiven *** Total amount owed to 4B is $118,887. Due to Fund Balance, only $81,628 will be repaid this year. The remaining portion of $37,529 will be repaid in FY 03104 9/9/2003 17 2:55 PM Income 375.000 Impact Fees 375,100 Ft. Worth Impact Fees Total 375.000 impact Fees 390.000 Duct Bank Leases 410.000 Reconnectfees 410.100 Water Total410.000 Reconnect fees 420.000 Wastewater Revenue 440.000 Tap Fees 440.100 Water Tap Fees 440.200 Sewer Tap Fees Total 440.000 Tap Fees 460.000 Water Revenue 460.100 Water Revenue 460.200 Water Charges Total460.000 Water Revenue Total Income Total Expenses Net to Utility Fund Utility Fund Budget 2003-2004 Actual Budgeted Projected Proposed FY 01102 FY 02103 FY 02103 FY 03104 24,938 20,130 20,130 21,000 24,938 20,130 20;130 21,000 0 291,472 271,82? "107;000,.. 120 100 0 100 720 10 100;' 137; k:73 130,089 130,000 ` 150;000' 8,150 6,721 6,563 7,500 1,450 1,004 1,125 1,250 555,620 600,250 600,000 690,000 520 9,751 984 1,000 556,11 _.:"602,flfli SOfl 984; �691<,OOfl" 727,972 1,051,517 1,030,084 977,850 1,042,376 813,233 956,008 909,162 314;434] ..23;2$4;'74,1177, " : . " 68,688.1; 9/9/2003 18 2:55 PM Expenses Expenses 510.000 'Bank Service Charges 551.000 Debt Service 551,100 Line Extension 551.200 Keller Reimbursement 551.400 TRA Wastewater Contract 551.500 Hiliwood Infrastructure Repayment 551,600 WL 1 Keller Overhead Storage Total 551.000 Debt Service $65.000 Maintenance Expense 565.100 Water & Sewer Maintenance Total 565.000 Maintenance Expense 585.000 Interest Expense 585.100 TRA Interest Expense 585.200 Keller Interest Expense Total 585.000 Interest Expense 610,000 Operations (AquaSource) 610.100 Office Supplies 610.200 Office Equipment Utility Infrastructure Insurance 620.000 Payroll Expense 620.100 Salaries 620.200 Automobile Expense 620.300 Payroll Expense - Other 620.400 Administrative Overhead 620.500 TM RS 620.600 Insurance 620,700 Workers Comp 620.800 Admin. Fee Total 620.000 Payroll Expense 611.000 Public Works 611,100 Public Works Superintendent 611,200 Public Works Vehicle 611.300 Supplies 611.400 Maintenance 611.500 TMRS 611.600 Payroll Taxes 611.700 Insurance Personnel insurance Workers Compensation Tota1611.000 Public Works 625,000 Payroll Taxes 625.100 FICA 625.300 Medicare Utility I°tand Budget 2003/2004 Actual Budgeted Projected Proposed FY 01102 FY 02103 FY 021103 FY 03104 25 1 40 169. 150. 0 0 0 0 40,308 40,308 40,308 0 56,792 28,396 28,396 28,331 0 42,716 42,716 25,000 118,887 119,668 119,668 120,429 215,987 231,00 731;008" 173,TG0 4,568 18,000 653 5,000 4,568 _ 18,(tU0 653 5,00{1;; 11,676 3,404 3,404 1,695 4,434 2,217 2,217 0 16x110 ,621 f,695" 49,600 ` 36,01)0 36,000 36,000, 25:`. 41P 0 50�: 570"" 90,0 0" 3,4300' 0I 14,112 ii.. 15,549 10,742 16,286 15,000 42,590 0 0 0 0 0 0 0 0 13,440 14,112 14,765 23,625 2,231 2,827 2,044 3,620 1,549 1,500 1,218 2,841 36 12 30 931 8 15 0 0 0 0 2,917 17,500 0 0 7,500 0 0 0 1,000 0 0 0 0 1,500 0 0 248 1,488 0 0 233 1,359 0 0 292 1,750 0 0 0 4,394 0 0 60 350 0 o 12,250 28,341 626 1,010 1,010 2,641 153 236 207 618 9/9/2003 19 2:561 PM Expenses 625.400 Unemployment Taxes Total 625.000 Payroll Taxes 640.000 Professional Fees 640.100 Engineering 640.200 Boyle 8 'Lowry Lloyd, Gosselink Financial Consultant 640.700 Auditor 640.800 Water Utility Engineer Total 640.000 Professional Fees 650.000 Office Rent 670.000 Wastewater Treatment 670.000 Wastewater Treatment 670.100 Southlake / TRA Maint. Total 670.000 Wastewater Treatment 680.000 Telephone 680.100 Telephone Expense (10%) 680.200 Internet Expense (10%) 680.300 Mobile Phone 680.400 Telephone Lease (10%p) Total 680.000 Telephone 705.000 Utilities 705.100 Gas and Electric Total 705.000 Utilities 711.000 Water Meter Reading I Billing 711.100 Meter Installation 711.200 Equipment 711.300 Meter Reading/ Billing Tota1711.000 Water Meter Reading/ Billing Utility Fund Budget 2003/2004 Actual Budgeted Projected Proposed FY 01102 FY 02103 FY 02103 FY 03/04 0 236 194 34 779 1,482 1,411 3,292_ 47,078 20,000 30,000 0 0 22,500 9,389 30,000 0 0 0 2,500 0 0 0 5,000 0 4,000 0 5,250 225,000 30,00/0. '/ p0 4f) Q7O, .. ' , 1 *"500 +34,969 f df85V i2 75V : -'10,725 12,800 „2,209[ 76,818 105,989 78,000 90,000 0 0 150,000 90,000 76,818 . I0,91i9... . :..... .... _ -22$ U00... X80,000 ': 1,463 1,800 1,258 780 191 200 76 285 366 275 350 840 318 322 346 54 U559182 16,158 19,200 15,200 17 13,786 16,850 5,500 5,000 1,724 2,650 651 1,000 0 10,800 10,800 10,800 1510- 30ii0 1,95,, , 16 80Ui 720.000 Water Purchases 720.100 Water Purchases 384,182 150,000 125,000 150,000 720.200 Peak Payment 175,000 95,000 123,000 130,000 Total 720.000 Water Purchases U559182 725.000 Water Transport Fees 726.000 Duct Bank Reimbursement - Vaquero: 0 .3�,4z0 0 Total Expenses 1,042,376 813,233 956,008 909,162 Total Income 727,972 1,051,517 1,030,084 977,850 Net to Utility Fund 3 14,404) 238.,:284 74,077 68,688 9/9/2003 20 2:55 PM Utility Fund Receivables and Payables From Other Sources Actual Actual Projected Proposed Receivablel Payable FY 00101 FY 01102 FY 02103 FY 03104 Receivables General Fund Keller Reimbursement Peak Payment * Duct Bank Reimbursement - Vaquero Total General Fund 4B WL/Keller OH Storage Tank Total 4B Payables General Fund Keller Reimbursement Peak Payment Total General Fund 4B WL/Keller OH Storage Tank Total 4B * 0 40,400 0 0 0 95,000 0 0 0 0 38,420 0 118,887 0 0 0 Actual Actual Projected Proposed FY 00101 FY 01102 FY 02103 FY 03104 0 0 40,400 0 0 0 95,000 0 0 0 81,628 37,259 In the past, Duct Bank Reimbursements were collected in the General Fund under Lot Development Fees, then transferred to the Utility Fund for repayment to the payees. The money will now be collected and paid from the Utility Fund so FY 03104 will not require a transfer to be made from General Fund. Initially 4A was responsible for reimbursing Duct Bank costs in the loan from 4A, made to the General Fund in 2000. With the dissolution of 4A, the General Fund will not be owed additional funds from the Utility Fund for Duct Bank construction 9/912(}03 21 2:55 PM Keller Reimbursement Amortization Schedule Date Principal Interest Payment Balance Loan TRA Wastewater Contract Repayment 132,029 Compound Period:..... .... Annual 4,434 44,742 Nominal Annual Rate......,...: 5,000 2001/2002 40,308 4,434 44,742 Effective Annuai Rate.........: 6.000 % 42,545 2002/2003 40,308 Periodic Rate.. ........ ....... -: 6,0000 Grand Totai 120,924 11,085 132,009 Daily Rate.... ...... ............. 0.01644 % Cash Flow Data Event Start Date Amount Number Period End Date 1 Payment 2/16/2000 28,396.00 1 Fixed Payment (+ Interest) 2 Loan 311/2000 141,980.00 1 3 Payment 2/16/2001 28,396.00 4 Annual 2J16/2004 Fixed Payment 4 Payment 4/1/2005 -69.78 1 Amortization Schedule - Normal Amortization Date Loan Payment Interest Principal Balance 1 2/16/2000 28,936.00 0.00 28,396.00 -28,396.00 Loan 3/1/2000 141,980.00 -65.35 65.35 113,518.65 2000 Totals 141,980.00 28,396.00 -65.35 28,461.35 2 2/1612001 34,964.53 6,568.53 28,396.00 85,122.65 2001 Totals 0.00 34,964.53 6,568.53 28,396.00 3 2/16/2002 33,503.36 5,107.36 28,396,00 55,726.65 2002 Totals 0.00 33,503.36 5,107,36 28,396.00 4 2116/2003 31,799.60 3,403.60 28,396.00 28,330.65 2003 Totals 0.00 31,799.60 3,403.60 28,396.00 5 2/16/2004 30,026.06 1,695.44 28,330.62 0.00 2004 Totals 0.00 30,026.06 1,695.44 28,330.62 Grand Total 141,980.00 158,689.55 16,709.58 141,979.97 0.00 Keller Reimbursement Amortization Schedule Date Principal Interest Payment Balance Loan 132,029 2000/2001 40,308 4,434 44,742 87,287 2001/2002 40,308 4,434 44,742 42,545 2002/2003 40,308 2,217 42,525 Grand Totai 120,924 11,085 132,009 9/10/2003 22 10:00 AM Westlake/Keller Overhead Storage Repayment Schedule of Debt Requirements Combination Tax and Revenue Certificates of Obligation, Series 2000 Principal & f=iscal Year Westlake Date Principal Due Coupon Interest Due Interest Total Portion 2115/2001 $ 100,000.00 5.65% $ 147,450.63 $ 247,450.63 8/15/2001 - 5.65% 123,561.25 123,561.25 913012001 100,000.00 271,011.88 371,011.88 $ 371,011.88 $ 118,887.05 2/15/2002 130,000.00 5.65% 123,561.25 253,561.25 8/1512002 - 5.65% 119,888.75 119,888.75 913012002 130,000.00 243,450.00 373,450.00 373,450,00 119,668.32 2/15/2003 140,000.00 5.65% 119,888.75 259,888.75 8/15/2003 - 5.65% 115,933.75 115,933.75 913012003 140,000.00 235,822.50 375,822.50 375,822.50 120,428.56 2/15/2004 145,000.00 5.65% 115,933.75 260,933.75 8/15/2004 - 5.65% 111,837.50 111,837.50 913012004 145,000.00 227,771.25 372,771.25 372,771.25 119,450.82 2/15/2005 155,000.00 5.65% 111,837.50 266,837.50 8/15/2005 - 5.65% 107,458.75 107,458.75 913012005 155,000.00 219,296.25 374,296.25 374,296.25 119,939.49 2/15/2006 165,000.00 5.65% 107,458.75 272,458.75 8/15/2008 - 5.65% 102,797.50 102,797.50 913012006 165,000,00 210,256.25 375,25625 375,256.25 120,247.11 2115/2007 175,000.00 5.65% 102,797.50 277,797.50 8/15/2007 - 5.65% 97,853.75 97,853.75 9/30/2007 175,000.00 200,651.25 375,651,25 375,651.25 120,373.69 2/15/2008 185,000.00 6.50% 97,853.75 282,853.75 8/15/2008 - 6.50% 91,841.25 91,841.25 9130/2008 185,000.00 189,695.00 374,695.00 374,695.00 120,067.27 211512009 200,000.00 6.50% 91,841.25 291,841.25 8/1512009 - 6.50% 85,341.25 85,341.25 9/3012009 200,000.00 177,182.50 377,182.50 377,182.50 120,864,36 2/15/2010 210,000.00 5.00% 85,341.25 295,341,25 8/15/2010 - 5.00% 80,091.25 80,091,25 9/3012010 210,000.00 165,432.50 375,432.50 375,432.50 120,303.59 2/15/2011 225,000.00 5.10% 80,091.25 305,091.25 8/15/2011 - 5.10% 74,466.25 74,466.25 9/3012011 225,000.00 154,557.50 379,557.50 379,557.50 121,625.41 2/15/2012 235,000.00 5.20% 74,466.25 309;466.25 8/15/2012 - 5.20% 68,473.75 68,473.75 9/30/2012 235,000.00 142,940.00 377,940.00 377,940,00 121,107.09 2/15/2013 250,000.00 5.20% 68,473.75 318,473.75 8/15/2013 - 5.20% 61,973.75 61,973.75 913012013 250,000.00 130,447.50 380,447.50 380,447.50 121,910.60 2115/2014 270,000.00 5.30% 61,973.75 331,973.75 8/15/2014 - 5.30% 54,818.75 54,818.75 9/30/2014 270,000.00 116,792.50 386,792.50 386,792.50 123,943.79 2/15/2015 285,000.00 5.35% 54,818.75 339,818.75 8/15/2015 5.35% 47,195.00 47,195.00 9/30/2015 285,000.00 102,013.75 387,013.75 387,013.75 124,01469 2/15/2016 300,000.00 5.40% 47,195.00 347,195M 9110/2003 23 10:01 AM Westlake/Keller Overhead Storage Repayment Schedule of Debt Requirements Combination Tax and Revenue Certificates of Obligation, Series 2000 Principal & Fiscal Year Westlake Date Principal Due Coupon Interest Due Interest Total Portion 8/15/2016 - 5.40% 39,095.00 39,095.00 913012016 300,000.00 86,290.00 386,290.00 386,290.00 123,782.77 2/15/2017 320,000.00 5.50% 39,095.00 359,095.00 8115120'17 - 5.50% 30,295.00 30,295.00 9/3012017 320,000.00 69,390.00 389,390.00 389,390.00 124,776.13 2/15/2018 340,000,00 5.60% 30,295.00 370,295.00 8/1512018 - 5.60% 20,860.00 20,860.00 9/3012018 340,000.00 51,155.00 391,155.00 391,155.00 125,341.71 2/1512019 360,000.00 5.60% 20,860.00 380,860.00 8/1512019 - 5.60% 10,780.00 10,780.00 9/3012019 360,000.00 31,640.00 391,640.00 391,640.00 125,497.12 2/15/2020 385,004.00 5.60% 10,780.00 395,780.00 8/15/2020 - 5.60% - - 9130/2020 385,000.00 10,780.00 395,780.00 395,780.00 126,823.74 `total $ 4,575,000.00 $ 3,036,575.63 7 7,611,575.63 $ 7,611,575.63 $ 2,439,053.31 9/10/2003 24 10:01 AM Westlake Visitor's Association Fund Program Summary Westlake Visitor's Association Fund Actual FY 01102 Budgeted FY 02103 Projected FY 02103 'Proposed FY 03104 Beginning Balance 579,385 534,450 559,479 611,409 Revenue 329,000 332,000 390,188 359,000 Transfers In - - 18,000 Expenditures 93,988 150,246 113,258 86,473 Transfers Out 246,918 - 225,000 153,000 Ending Balance 559,479 716,204 611,409 730,936 Actual Budgeted Projected Proposed Westlake Visitor's Association Fund Transfers In FY 01102 FY 02103 FY 02103 FY 03104 Transfers In Capital Projects Total Transfers In - - - Westlake Visitor's Association Fund Transfers Out Actual Budgeted FY 01102 FY 02103 Projected FY 02103 Proposed FY 03104 Transfers Out Capital Projects - - Civic Campus 225,000 Paint retaining walls at Westlake Parkway and 114 18,000 Westlake Restoration Project - 25,000 Entryways at Dove and Pearson Drive - - - 10,000 Blacksmith and Forge Statue - - - 100,000 Auditor's Corrections 246,918 - - Total Transfers Out 246,918 - 1 225,000 153,000 919/2003 25 2:56 PM Income 315.000 Hotel Occupancy Tax 325.000 Interest Income Total income Expenses 410.100 Payroll Expenses 410.101 Salaries 410.102 Insurance 410.103 TMRS Workefs Compensation Total 410.100 Payroll Expenses 410.201 Taxes 410.311 Administration 410.442 Office Rent 410.510 Boyle & Lowry 410.511 Auditor 410.530 Computers 410.531 Equipment 410.532 Service Total 410.530 Computers 410.540 Telephone Expense 410.541 Mobile Phone 410.542 Telephone Expense (25%) 410.543 Internet Expense (25%) 4110.544 Telephone Lease (25%) Total 410.540 Telephone Expense 427.000 CV8 Membership 430.000 Marriott Marketing 431.000 Website Development 432.000 New Logo Total Expenses Total Income Net to Westlake Visitors Association Westlake Visitor's Association Budget 18,100 15,138 15,045 200312004 7,550 6,090 1,410 4,B42 Actual 1,129 Budgeted Projected Proposed 0 Fy 00101 0 FY 02!03 FY 02103 1=Y 03104 2,731 5,000 504 1,000 240 317,841 320,000 381,998 350,000 11,155 9,000 8,190 9,000 328,996 329,000 390,188 359,000 19,142 18,100 15,138 15,045 5,220 7,550 6,090 1,410 4,B42 1,683 1,129 1,279 0 0 0 465 2,062 1,638 1,307 1,181 33,600 37,500 37,500 23,625 19,627 7,918 8,113 2,209 0 11,250 6,485 5,000 0 0 0 2,450 2,731 5,000 504 1,000 240 500 0 500 1,065 750 669 750 3,318 2,500 2,669 1,950 585 500 288 713 706 875 866 146 750 1,200 750 750 0 28,000 7,250 28,000 14,500 14,500 0 0 25,000 10,000 0 93,988 164,464 113,258 86,473 328,996 329,000 390,188 359,000 26 919/2003 2:56 PM Westlake Visitor's Association Receivables and Payables From Other Sources Actual Actual Projected Proposed Receivable/Payable FY 00109 FY 01/02 FY 02103 FY 03104 Receivables Payables Miscellaneous Auditor's Correction Total Miscellaneous Actual Actual Projected Proposed FY 00101 FY 01102 FY 02103 FY 03/04 246,918 9/9/2003 27 4A Corporation Program Summary 4A Corporation Actual FY 01102 Budgeted FY 02103 Projected FY 02103 Proposed FY 03/04 Beginning Balance 1,114,890 1,108,431 1,212,679 938,101 Income * 297,203 375,000 450,000 233,336 Interest Income 22,871 25,000 15,000 5,000 Transfers In - 1 95,000 - Transfers Out 222,285 993,582 1 739,578 1,176,437 Ending Balance 1,212,679 6091,849 1 938,101 - 4A Corporation Transfers In Actual u ge a Projected ropose FY 01102 FY 02103 FY 02103 FY 03104 Transfers in Budgeted FY 02103 General Fund - - - Utility Fund Duct Bank Repayment ** - 95,000 Capital Projects - - - Total Transfers In - 95,000 - - 4A Corporation Transfers Out Budgeted for Capital Actual FY 01102 Budgeted FY 02103 Projected FY 02103 Proposed FY 03104 Transfers Out General Fund - Dissolution of 4A - - 1,176,437 Capital Projects FM 19381 114 Interchange improvements 355,570 4B - - 57,367 - Capital Project Expense - 292,633 60,714 - General Fund - - 218,234 FM 1938 Engineering - WL Portion 82,174 - 77,603 82,174 - Fidelity Tax Reimbursement 110,571 - 105,000 110,571 Circle T Mall Development 122,196 70,275 51,921 Expanded Level Bridge Enhancements 43,071 42,500 43,071 Ottinger/Dove Rd Intersection rebuild 315,000 - 315,000 9,071 - Westlake Academy Foundation Loan 25,000 - 25,000 25,000 - Civic Campus 50,000 - Duct Bank Infrastructure 1,900,000 1 222,285 65,571 81,455 Total Transfers Out 3,003,582 1 222,285 993,582 739,578 1,176,437 * Assumes eight months sales tax and interest revenue before dissolution. Remaining funds transferred to GF. ** Due to the dissolution of 4A the loan to the Utility Fund for the Duct Bank Construction will be forgiven 9/9/2003 2:54 PM 28 4A Receivables and Payables From Other Sources ReceivablelPayable Receivables Payables General Fund FAIL 1938/114 Interchange Improvements Dissolved Funds Total General fund 4B FAR 1939/114 Interchange Improvements Total 4B 29 Actual Actual Projected Proposed FY 00/01 FY 01102 FY 02/03 FY 03104 Actual .Actual Projected Proposed FY 00101 FY 01102 FY 02103 FY 03104 0 0 218,234 0 0 0 0 1,176,437 57,637 9/9/2003 2:55 PM 4B Corporation Program Summary 4B Corporation Actual FY 01102 Budgeted FY 02103 Projected FY 02103 Proposed FY 03104 Beginning Balance 2,065,012 1,586,071 102,663 695,658 Income 297,203 375,000 450,000 350,000 Interest Income 31,062 50,000 4,000 9,000 Transfers In - 118,887 258,887 1 555,995 1 581,431 Transfers Out 2,290,614 509,500 1 417,000 1 892,080 Ending Balance 102,663 1,760,458 1 695,658 1 744,009 4B Corporation Transfers In Actual Budgeted FY 01102 FY 02103 Projected FY 02103 Proposed FY 03104 Transfers In Proposed FY 03104 Transfers Out General Fund Utility Fund Short Term Loan ' 140,000 Debt Service for Civic Campus WL/Keller Overhead Storage Tank Repayment - 118,887 81,628 37,259 4A Repayment - FM 1938/114 Interchange Improvements - - 57,367 - Civic Campus Bond Proceeds Non Civic Campus Capital Projects - 417,000 - Repayment for Civic Campus site - - WL/Keller OH Storage Loan 544,172 Capital Projects - Total Transfers In 258,887 555,995 581,431 413 Corporation Transfers Out Budgeted For Capital Actual FY 01102 Budgeted FY 02103 Projected FY 02103 Proposed FY 03104 Transfers Out General Fund Debt Service for Civic Campus - - 742,080 FM 1938 / 114 Interchange Improvements - Utility Fund Loan Short Term Loan - WL/Keller OH Storage Loan - Civic Campus 1,477,169 Capital Projects Keller Overhead Water Storage 118,887 - - - Dove Road Overlay 234,049 234,049 - - Park & Open Space Planning - 19,500 2,000 - Master Thoroughfare Update - Retail Dev. - 80,000 2,000 Permanent DPS Facility - 20,000 2,000 - Glenwyck Water Line 125,000 - - Elevated Storage Tank Connection to Dove i - 390,000 411,000 FM 1938 / 114 Interchange Improvements 200,000 125,646 Ottinger Overlay - - 150,000 Southlake N-1 Sewer Line 588,852 - I - Auditor's Correction - Due to Other Funds 453,750 - Total Transfers Out 1,266,788 2,290,614 1 509,500 1 417,000 1 892,080 This line item mistakenly includes the $118,887 (counted twice) owed from the Utility Fund as well as a $20,000 Short term loan made to the OF from 413. The $20,000 loan was never made and the amount of $140,000 (rounded from $138,887) will not be repaid to 413. The $118,887 has been repaid as of FY 200212003. 9/9/2003 2:54 PM 30 4B Development Corporation Receivables and Payables From Other Sources Actual Actual ReceivablelPayable FY 00101 FY 01102 Receivables Utility Fund WL/Keller OH Storage Tank Total Utility Fund Civic Campus Non Civic Campus Capital Projects Repayment for Civic Campus Site Total Civic Campus 4A FM 1938/114 Interchange Improvements Total 4A Projected Proposed FY 02103 FY 03104 0 0 81,628 37,259 0 0. 81;628 37,258- 0 0 417,000 0 0 0 0 544,172 0 0 57,367 0 Actual Actual Projected Proposed FY 00101 FY 01102 FY 02103 FY 03104 Payables General Fund * Debt Service for Civic Campus 0 0 0 742,080 Total General Fund 4 Q. .. �, Utility Fund WIJKeller OH Storage Loan 118,887 0 0 0 Total Utility Fund 18,87 Miscellaneous Auditor's Corrections 0 453,750 0 0 Total Miscellaneous 4B Obligations in FY 2002/2003 were budgeted in anticipation of the repayment of monies used for the purchase of the Civic Campus. * This represents 100% of the 2nd Installment of the $11.5 million Debt Service 9/9/2003 31 2:55 PM Fidelity Tax Reimbursement Date Payment Sept. 30, 2003 $107,118 Sept. 30, 2004 Sept. 30, 2005 35,760 Sept. 30, 2006 35,760 Sept. 30, 2007 35,760 Sept. 30, 2008 35,760 Sept. 30, 2009 35,760 Sept. 30, 2010 35,760 Sept. 30, 2011 35,760 Sept. 30, 2012 35,760 Sept. 30, 2013 35,760 Sept. 30, 2014 35,760 Sept. 30, 2015 35,760 Sept. 30, 2016 35,760 Total $536,238 FY 02103 Payment included FY 01/02, FY 02/03, and FY 03104 9110/2003 32 10:00 AM Crime Control District Program Summary Crime Control Proposed FY 03/04 Beginning Balance 0 Income * 116,668 Transfers In 0 Transfers Out 116,668 Ending Balance 4 Proposed Crime Control Transfers In FY 03104 Transfers In General Fund Utility Fund 413 Total Transfers In 0 Crime Control Transfers Out Proposed FY 03104 Transfers Out General Fund 116,668 Total Transfers Out 116,668 Due to State law, Crime Control Funds will not be collected until April 1, 2004 and the first payment to the Town collected as CCD Funds, will not be received until June 2004. In order to properly account for this delay, the Income line item is budgeted at four months of CCD. No interest will be collected in the Crime Control District because funds will be automatically used to aide the General Fund in paying for the Keller Police Contract. 9/9/2003 2:54 PM 33 Crime Control District * Receivables and Payables From Other Sources Actual Actual Projected Proposed Receivable/Payable FY 00101 FY 01102 FY 02103 FY 03104 Receivables Actual Actual Projected Proposed FY 00101 FY 01102 FY 02/03 FY 03104 Payables General Fund Crime Control District for Keller Police 0 0 0 116,668 Total General Fund Assumes the Town Dissolves 4A during the November 4th election and votes to create Crime Control District. 9/9/2003 34 2:55 PM General Fund Capital Project FV 2003/2004 Civic Campus Capital Project # 738 Project Descri to ion Plan, design, construct and open facilities for Town Hall and the Westlake Academy, Project Schedule Begin End Design May -02 Aug -02 Construction Sep -02 Aug -03 Fiscal Impact 9/9/2003 35 2:57 PM LTD Budget FY Planned FY 04105 FY 05106 FY 06107 FY 07108 Project Expense 9130103 03104 Design/Architecture 82,500 60,180 60,180 Construction 750,000 44,025 Grants 4,418 Repayment to 4B 417,000 544,172 70,000 Debt Service 927,600 742,080 742,080 952,080 953,430 948,805 Installment Sale 261,913 285,724 425,724 427,924 424,444 TOTAL $ 1,427,100 $ 2,298,165 $ 1,027,804 $ 1,377,804 $ 1,381,354 $ 1,373,249 Funding Source 18,107,400 15,809,235 14,781,431 13,403,627 12,022,273 Prior Year's Remaining Funds Certificates of Obligations - 1 11,500,000 184,705 Total Expense Total Revenues Certificates of Obligations - 2 6,100,000 TOTAL Private $ (218,923) $ $ $ - $ (184,705) General Fund 82,500 Enterprise Fund Westlake Visitor's Association 225,000 Grants 100,000 Utility Fund 18,007,500 18,107,400 15,809,235 14, 781,431 13,403, 627 12,022,273 Total Interfund Loans 4A 50,000 413 1,477,000 Total 1,527,000 - - TOTAL $ 18,107,400 $ 15,809,235 $ 14,781,431 $ 13,403,627 $ 12,022,273 $ 10,649,024 9/9/2003 35 2:57 PM LTD Budget FY Planned Projected Annual Operating Budget 9130103 03104 FY 04105 FY 05106 FY 06107 Total Personnel Expenses 60,180 60,180 Administrative Expenses 44,025 44,025 Rent 4,418 Town Attorney 70,000 70,000 Civii Engineer 29,800 Auditor 10,500 10,500 Debt Service Capital Outlay - 218,923 184,705 Total Expense Total Revenues TOTAL Is $ (218,923) $ $ $ - $ (184,705) 9/9/2003 35 2:57 PM General Fund Capital Project FY 200212003 377 RAW Purchase Project Descri tp ion The purchase of 2.03 acres of ROW on Highway 377 which was previously used for construction of 377 by the state of Texas. Project Schedule Implementation Fiscal Impact ge W End June 2003 July 2003 Impact on Operating Budget LTD Budget FY Planned FY 04105 FY 05106 FY 06/07 FY 07108 Project Expense 9/30103 03104 Purchase of 377 ROW 221,000 - TOTAL $ 221,000 $ - $ - $ - $ $ Funding Source - Certificates of Obligations Private - Debt Service General Fund 221,000 Capital Outlay Enterprise Fund - Westlake Visitor's Association - Total Expense Total Revenues Grants TOTAL Utility Fund $ $ - $ $ $ 221,000 - - - Tota] Interfund LoanslGrant 4A Grant 4B Total - - - TOTAL $ - $ $ $ - $ $ Impact on Operating Budget 9/9/2003 36 2:56 PM LTD Budget FY Planned FY 04105 FY 05106 FY 06107 Total Projected Annual Operating Budget 9/30103 03/04 Personnel Expenses - Supplies Maintenance - Services - Debt Service Capital Outlay - - Total Expense Total Revenues TOTAL $ $ $ - $ $ $ 9/9/2003 36 2:56 PM General Fund Capital Project FY 200312004 FM 1938 Capital Project # 742 Project Description The engineering, design and construction document package with TXDot review and approval for FM 1938 between SH 114 in Westlake and FM 1709 in Southlake/Keller. Implementation costs for Texas U-turns at SH 1141 FM 1938 interchange are also included. Westlake portion of costs relative to Southlake and Keller is 57.11% for FM 1938 and 40% for SH 114 interchange improvements. Project Schedule Seain End Design Construction Fiscal Impact Sep -00 Feb -02 May -03 Sep -04 ll.: •.�. 1M LTD Budget FY Planned FY 04105 FY 05106 FY 06107 FY 07108 Project Expense 9130103 03104 Design 838,655 458,662 4,000 Construction - Contingencies 16,492 TOTAL $ 838,655 $ 458,662 $ 16,492 $ $ $ - Funding Source (Restricted) 16,492 16,492 - - Prior Year's Remaining Funds Certificates of Obligatlons - Private 610,026 348,091 - 4,000 Total Expense Total Revenues General Fund 36,857 TOTAL Other Cities (Keller, Southlake) 162,947 73,714 $ $ $ (4,000} Enterprise Fund Westlake Visitor's Association Grants Utility Fund Interfund Loans 4A 82,174 4B 855,147 475,154 16,492 Total TOTAL $ 16,492 $ 16,492 $ - $ $ - $ - ll.: •.�. 1M 9/9/2003 37 2'.58 PM LTD Budget FY Planned Projected Annual Operating Budget 9130103 03104 FY 04105 FY 05106 FY 06/07 Total Administrative Expense 4,000 4,000 Town Attorney - Civil Engineer Audtior - Debt Service Capital Outlay - 4,000 - 4,000 Total Expense Total Revenues TOTAL $ - $ (4,000) $ $ $ $ (4,000} 9/9/2003 37 2'.58 PM General Fund Capital Project FY 2003/2004 FM 1938 1114 Interchange Improvements Capital Project # 741 Project pescri ion As State Highway 114 is improved by TXDot, the Town of Westlake will make aesthetic improvements to the basic state supported design and construction specifications in order to accent the major entryway of FM 1938 and SH 114. Project Schedule Begin En Design Oct -00 Dec -01 Construction Feb -01 Ongoing Fisgal Impact 9/1012003 38 10:10 AM LTD Budget FY Planned FY 04105 FY 05106 FY 06/07 FY 07108 Project Expense 9130103 03104 Design - Construction 318,081 273,000 - Contingencies TOTAL $ 318,081 $ 273,000 $ $ - $ $ Funding Source - Prior Year's Remaining Funds Certificates of Obligations Private - Total Expense Total Revenues General Fund 273,000 TOTAL 4A Dissolved Funds $ a $ $ - $ $ Enterprise Fund Grants Utility Fund Interfund Loans 4A to 4B 57,367 4A Expense 60,714 4B 200,000 Total 318,081 - - - TOTAL $ - $ (273,000) $ - $ -1 $ - $ 9/1012003 38 10:10 AM LTD Budget FY Planned FY 04105 FY 05106 FY 06107 Total Projected Annual Operating Budget 9130103 03/04 Administrative Expense - Town Attorney - Civil Engineer Auditor Debt Service - Capital Outlay - Total Expense Total Revenues TOTAL $ - $ a $ $ - $ $ 9/1012003 38 10:10 AM General Fund Capital Project FY 200312004 Dove Road Overlay Capital Project # 739 Pro-ject Descri to ion Dove Road will be overlaid from the east border to PD 3-1 and west to PD 3-1 to the proposed new intersection of Dove Road and Ottinger. Project Schedule Benin End Design Sep -01 Sep -01 Construction Oct -03 Jun -04 Fiscal Imp 9/9/2003 39 2:58 PM LTD Budget FY Planned FY 04105 FY 05106 FY 06107 FY 07108 Project Expense 9130103 03104 Design Construction 234,049 118,951 Contingencies TOTAL $ 234,049 $ - $ 118,951 $ $ $ Funding Source - Certificates of Obligations Private 89,000 General Fund 30,000 - Total Expense Total Revenues Enterprise Fund TOTAL Westlake Visitor's Association $ - $ $ $ - $ Grants Utility Fund - 119,000 Total Inteitund Grants 4A 4B 234,049 Total 234,049 - TOTAL $ - $ - $ 49 $ - $ - $ 9/9/2003 39 2:58 PM LTD Budget FY Planned FY 04/05 FY 05106 FY 06107 Total Projected Annual Operating Budget 9130103 03104 Personnel Expenses Supplies Maintenance Services - Debt Service - Capital Outlay - Total Expense Total Revenues TOTAL $ $ - $ $ $ - $ 9/9/2003 39 2:58 PM Westlake Visitor's Association Capital Project FY 2003/2004 Blacksmith and Forge Statue Capital Project # Project Description Seek out and identify an artist that will create a life-size statue of a Blacksmith at his forge for the Civic Campus Site, The Town will examine the possibility of selling small scale replicas to generate revenue. Project Schedule Begin End Design Nov -03 Dec -03 Creation Mar -04 Aug -04 Fiscal Impact Impact on Operating Budget LTD Budget FY Planned FY 04105 FY 05106 FY 06107 FY 07108 Project Expense 9130103 03104 Design/Creation 100,000 - TOTAL $ $ 100,000 $ - $ $ - $ Funding Source Certificates of Obligations Private Debt Service General Fund - Capital Outlay Enterprise Fund Westlake Visitor's Association 100,000 - Total Expense Total Revenues Grants TOTAL Utility Fund $ - $ $ $ Interfund Loans 4A 4B Total 100,0001 i i - TOTAL 1 $ 1 $ -Is -I $ a1 $ -I $ Impact on Operating Budget 919/2003 40 2:56 PM LTD Budget FY Planned FY 04105 FY 05106 FY 06107 Total Projected Annual Operating Budget 9130103 03104 Personnel Expenses - Supplies - Maintenance Services Debt Service - Capital Outlay - - Total Expense Total Revenues TOTAL $ $ - $ $ $ 919/2003 40 2:56 PM Westlake Visitor's Association Capital Project FY 2003/2004 Entryway Improvements at Dove & Randol Mill Capital Project # Pro leO Description Landscaping and signs will be placed at Dove and Randol Mill to create entryways into the Town. The entryways will aide in the locational awareness of the Town's boundaries and welcome visitors and residents alike. Project Schedule Begin En Design Construction Nov -03 Dec -03 Mar -04 Mar -04 Impact on Operating _Budget LTD Budget FY Planned FY 04105 FY 05106 FY 06/07 FY 07/08 Project Expense 9130103 03104 Construction 10,000 TOTAL $ $ 10,000 $ - $ $ - $ - Funding Source - Certificates of Obligations Private Debt Service General Fund - Capital Outlay Enterprise Fund Westlake Visitor's Association 10,000 Total Expense Total Revenues Grants TOTAL Utility Fund $ $ $ $ $ Interfund Loans 4A 4B Total - 10,000 TOTAL $ $ $ $ $ $ Impact on Operating _Budget 9191.2003 41 2:57 PM LTD Budget FY Planned FY 04105 FY 05/06 FY 06107 Total Projected Annual Operating Budget 9130103 03104 Personnel Expenses Supplies Maintenance - Services Debt Service - Capital Outlay - m Total Expense Total Revenues TOTAL $ $ $ $ $ $ 9191.2003 41 2:57 PM Westlake Visitor's Association Capital Project FY 2003/2004 Westlake Restoration Project Capital Project # Project Description Perform a feasibility study and develop a site plan for a Westlake Restoration Project which will identify location and plan for area structures that warrant saving, relocating and renovating. The area will then be put back into retail and commercial use and serve as an important visitor's attraction for Westlake. Project Schedule Begin End Design Jan -04 July -04 Implementation N/A N/A Impact on Operating Budget LTD Budget FY Planned FY 04106 FY 05106 FY 06107 FY 07108 Project Expense 9/30/03 03104 Design 25,000 Implementation TOTAL $ - $ 25,000 $ $ - $ - $ Funding Source - Certificates of Obligations Private Capital Outlay General Fund - - Utility Fund Total Expense Total Revenues Enterprise Fund TOTAL Westlake Visitor's Association $ 25,000 $ $ - $ Grants Interfund Loans 4A 4B Total 25,000 - TOTAL $ - $ - $ - $ - $ - $ Impact on Operating Budget 919/2003 42 2:57 PM LTD Budget FY Planned FY 04105 FY 05106 FY 06107 FY 07108 Projected Annual Operating Budget 9130103 03104 Personnel Expenses Supplies Maintenance Services - Debt Service Capital Outlay - - Total Expense Total Revenues TOTAL $ $ $ $ $ - $ 919/2003 42 2:57 PM Westlake Visitor's Association Capital Project FY 200312004 Paint retaining walls at Westlake Parkway and Highway 114 Capital Project # Project Description Paint retaining walls at Westlake Parkway and Highway 114. Construction Fiscal Impact Begin Ear -d May -04 June -04 impact on Operating Budget LTD Budget FY Planned FY 04105 FY 05106 FY 06107 FY 07108 Project Expense 9130103 03104 Construction 18,000 TOTAL $ $ 18,000 $ - $ - $ - $ Funding Source - Certificates of Obligations Private Debt Service General Fund - Capital Outlay Enterprise Fund Westlake Visitor's Association 18,000 - Total Expense Total Revenues Grants TOTAL Utility Fund $ $ $ - $ - $ Interfund Loans 4A 4B Total 18,000 - - TOTAL I $ - $ 18,000 $ - $ - $ -I $ impact on Operating Budget 9/9/2003 43 2:57 PM LTD Budget FY Planned FY 04105 FY 05106 FY 06107 Total Projected Annual Operating Budget 9130103 03104 Personnel Expenses Supplies Maintenance - Services Debt Service - Capital Outlay - Total Expense Total Revenues TOTAL $ $ $ $ - $ - $ 9/9/2003 43 2:57 PM Capital Project FY 2003/2004 Bridge Enhancements Capital Project # 761 Project Description Additional paint/stain to retaining walls of Hwy 114 bridges. I;J 7 q&7M T- -M Construction Fiscal Impact Begin ELdi Nov -02 Jan -03 Impact on Operating Bijdget LTD Budget FY Planned FY 04105 FY 05106 FY 06107 FY 07107 Project Expense 9130103 03104 Design 7,500 571 Engineering - Construction 35,000 TOTAL $ 42,500 $ - $ - $ - $ $ Funding Source Certificates at Obligations Private - 571 General Fund 571 Total Expense Total Revenues Enterprise Fund TOTAL Westlake Visitor's Association $ $ $ - $ $ (571) Grants Utility Fund - - Total Intertund Loans 4A 43,071 4B Total 43,071 - - - TOTAL $ - $ $ $ - $ - $ Impact on Operating Bijdget 9/9/2003 44 2:58 PM LTD Budget FY Planned FY 04105 FY 05105 FY 06107 Total Projected Annual Operating Budget 9130103 03104 Personnel Expenses 571 571 Supplies - Maintenance Services Debt Service Capital Outlay - 571 571 Total Expense Total Revenues TOTAL $ (571) $ $ $ - $ $ (571) 9/9/2003 44 2:58 PM DRAFT Capital Project FY 2003/2004 Duct Bank Infrastructure Capital Project # 730 Protect Descri tp ion System whereby the Town manages tight -of -way by constructing a telecom duct bank system which is owned and operated by the Town and ]eased to telecom providers. Phase 11 of the Duct Bank will extend west of Dove Road and will be built as growth demands it. Protect Schedul B eg:ln Ern Design Sep -00 Nov -00 Construction Nov -00 Ongoing Fiscal Impact Impact on Operating Budget LTD Budget FY Planned FY 04105 FY 05106 FY 06/07 FY 07108 Project Expense 9130103 03104 Design/Architecture 238,169 - Construction 1,548,472 - Conduit Extension 65,571 4A Repayment TOTAL $ 1,852,212 $ - $ - $ - $ - $ - Funding Source Certificates of Obligations Private Total Expense Total Revenues General Fund TOTAL Enterprise Fund 1 $ - $ - $ - $ $ Westlake Visitor's Association Grants Utility Fund - - - Total Interfund Loans 4A 1,900,000 4B Total 1,900,000 - - - TOTAL $ 47,788 $ - $ - $ - $ $ - Impact on Operating Budget 9/912003 45 2:58 PM LTD Budget FY Planned FY 04105 FY 05106 FY 06107 Total Projected Annual Operating Budget 9130/03 03104 Personnel Expenses - Supplies - Maintenance Services Debt Service Capital Outlay - Total Expense Total Revenues TOTAL Is 1 $ - $ - $ - $ $ 9/912003 45 2:58 PM Capital Project FY 2003/2004 Circle T Mail Development Capital Project # 752 Project Description The Development of a Mall on the northern part of the Circle T Ranch, Prject ScheduIo Begin End Design Oct -03 Oct -04 Construction Oct -04 Oct -06 Fiscal Impact Impag;t on Operating Budget LTD Budget FY Planned FY 04105 FY 05106 FY 06107 FY 07108 Project Expense 9130103 03104 Design/Architecture 51,921 20,000 Construction 30,000 30,000 Grants 18,275 18,275 Contingencies 2,000 2,000 TOTAL $ 51,921 $ $ - $ - $ - $ Funding Source Prior Year's Remaining Funds Certificates of Obligations 70,275 Total Revenues Private TOTAL General Fund $ $ $ e $ $ (70,275) Enterprise Fund Westlake Visitor's Association Grants Utility Fund Total - - Interfund Loans 4A 122,196 4B Total 122,196 - - TOTAL $ 70,275 $ -Is - $ --I $ - $ Impag;t on Operating Budget 9/9/2003 46 2.57 PM LTD Budget FY Planned FY 04/05 FY 05106 FY 06107 Total Projected Annual Operating Budget 9130103 03104 Administrative Expense 20,000 20,000 Town Attorney 30,000 30,000 Civil Engineer 18,275 18,275 Auditor 2,000 2,000 Debt Service Capital Outlay Total Expense 70,275 70,275 Total Revenues TOTAL $ (70,275) $ $ $ e $ $ (70,275) 9/9/2003 46 2.57 PM Capital Project FY 2003/2004 4A Loan to Westlake Academy Foundation Capital Project # Project Descrl tp 9on Economic Development incentive for the Academy Foundation Project Schedule Begin End Planning X11 �a =!I.7114. i. .._ LTD Budget FY Planned FY 04105 FY 05106 FY 06/07 FY 07108 Project Expense LTD 9130103 03104 Contingencies 25,000 TOTAL $ 25,000 $ $ $ - $ - $ Funding Source Certificates of Obligations Private Debt Service General Fund Capital Outlay Utility Fund 25,000 Enterprise Fund Total Expense Total Revenues Westlake Visitor's Association TOTAL Grants $ - $ $ _ $ _ $ Total - Interfund Loans 4A 25,000 Q Total 25,000 - - - TOTAL $ -is - $ $ - $ - $ =!I.7114. i. .._ 9/10/2003 47 10:10 AM LTD Budget FY Planned FY 04105 FY 05106 FY 06107 FY 07/08 Projected Annual Operating Budget 9130103 03/04 Personnel Expenses Supplies - Maintenance Services Debt Service Capital Outlay 25,000 - Total Expense Total Revenues 25,000 TOTAL $ - $ - $ $ _ $ _ $ 9/10/2003 47 10:10 AM Utility Fund Capital Project FY 2003/2004 WL/Keller Overhead Storage Tank Capital Project # 900.6 Project De.5pri.ptiVrj Water storage tank the City of Keller and the Town of Westlake share. Funding provided by City of Keller and Town of Westlake. Reimbursed from the Utility Fund via a loan from 4B. Project Schedule Began. End Design Jan -01 May -01 Construction Jun -01 Jun -02 Fiscal Impact .i. .. .o. •.- .. LTD Budget FY Planned FY 04105 FY 05106 FY 06107 FY 07108 Project Expense 9130103 03/04 Design Engineering Contingencies 238,555 120,429 119,451 119,939 120,247 120,374 TOTAL $ 238,555 $ 120,429 $ 119,451 $ 119,939 $ 120,247 $ 120,374 Funding Source - Certificates of Obligations Private General Fund - - - Total Expense Total Revenues Utility Fund 119,668 120,429 119,451 119,939 120,247 120,374 Westlake Vsitors Association $ - $ $ - $ $ Net to Fund Balance Grants Total 119,668 120,429 119,451 119,939 120,247 120,374 Interfund Loans 4A 4B 118,887 Total 118,887 - TOTAL Is - $ -1 $ -1 $ -1 $ -1 $ .i. .. .o. •.- .. 919/2008 48 2:58 PM LTD Budget FY Planned FY 04105 FY 05106 FY 06107 Total Projected Annual Operating Budget 9130/03 03/04 Personnel Expenses Supplies Maintenance Services Debt Service - Capital Outlay - - - Total Expense Total Revenues TOTAL $ $ - $ $ - $ $ Net to Fund Balance 919/2008 48 2:58 PM Capital Project FY 200312004 Park &. Open Space Planning Capital Project # 757 Project Description To maintain the physical beauty of the Town's settings; it is necessary to create an intensive plan outlining the Parks and Open Spaces of Westlake, Design Fiscal Impggt Oct -04 Sept -05 Impact on Operating. Budget LTD Budget FY Planned FY 04105 FY 05/06 FY 06107 FY 07108 Project Expense 9130103 03104 Design 2,000 2,000 TOTAL. $ - $ - $ - $ $ - $ Funding Source Prior Year's Remaining Funds Certificates of Obligations - Debt Service Private - Capital Outlay General Fund - 2,000 Enterprise Fund - - 2,000 Total Expense Total Revenues Westlake Visitor's Association TOTAL Grants $ $ $ - $ $ (2,000) Utility Fund - - - Total Interfund Grant 4A 413 2,000 19,500 Total 2,000 19,500 - TOTAL $ 2,000 $ - $ 19,500 $ - $ Impact on Operating. Budget 9/9/2003 49 2:58 PM LTD Budget FY Planned FY 04105 FY 05106 FY 06107 Total Projected Annual Operating Budget 9130103 03/04 Administrative Expenses 2,000 2,000 Town Attorney Civil Engineer Auditor - Debt Service - Capital Outlay - 2,000 - - - 2,000 Total Expense Total Revenues TOTAL $ (2,000) $ $ $ - $ $ (2,000) 9/9/2003 49 2:58 PM Capital Project FY 2003/2004 Master Thoroughfare Update - Retail Development Capital Project # 753 Project Description Developing the infrastructure for the Town is an important part of creating commercial development. In order to keep development growing in an organized and anticipated manner, it is necessary to update the Master Throroughfare plan. This will allow the Town to shape growth in a way that coincides with the vision of Westlake, Project Schedule Design Fiscal Impact Begin gin Qct -04 Sept -05 [WORKSTIVITF-M-M n. LTD Budget FY Planned FY 04105 FY 05/06 FY 06/07 FY 07108 Project Expense 9130103 03104 Design 2,000 80,000 2,000 TOTAL $ - $ - $ 80,000 $ - $ - $ -- Funding Source Prior Year's Remaining Funds Certificates of Obligations Debt Service Private - Capital Outlay General Fund - Total Expense Enterprise Fund - 2,000 Total Revenues Westlake Visitor's Association TOTAL Grants $ - $ $ - $ - $ (2,000) Utility Fund Total - - - Interfund Grant 4A 4B 2,000 80,000 Total 2,000 80,000 TOTAL $ 2,000 $ $ $ $ - $ - [WORKSTIVITF-M-M n. 9/9/2003 50 2:58 PM LTD Budget FY Planned FY 04105 FY 05106 FY 06/07 Total Projected Annual Operating Budget 9130/03 03/04 Administrative Expense 2,000 2,000 Review Finance / Audit Attorney Debt Service - Capital Outlay - Total Expense 2,000 - 2,000 Total Revenues TOTAL $ (2,000) $ - $ $ - $ - $ (2,000) 9/9/2003 50 2:58 PM Capital Project FY 2003/2004 Ottinger Overlay Capital Project # Project Description Construction of the Ottinger Road Overlay. The overlay is a safety need due to the immense traffic Ottinger Road will endure with the opening of the Westlake Academy. Prgiect Schede —Be 0i Erid Design May -04 June -04 Construction June -04 July -04 Fiscal impact Impact on Operating Budget LTD Budget FY Planned FY 04/05 FY 05106 FY 06107 FY 07108 Project Expense 9130103 03104 Engineering 45,000 Construction 105,000 7,338 Contingencies TOTAL $ - $ 150,000 $ - $ - $ $ Funding Source Certificates of Obligations Private General Fund 8,238 Total Expense Total Revenues Enterprise Fund TOTAL Westlake Visitor's Association 1$ (8,238) $ $ $ - $ (8,238) Grants Utility Fund - - - Total Interfund Loans 4A 4B 130,000 Total 130,000 - - - TOTAL $ $ (20,000) $ -is $ - $ - Impact on Operating Budget 919/2003 51 2:57 PM LTD Budget FY Planned FY 04105 FY 05106 FY 06107 Total Projected Annual Operating Budget 9130103 03104 Personnel (Salary, Taxes) Administrative Expenses 7,338 7,338 Civil Engineer Auditor 900 900 Dent Service Capital Outlay 8,238 8,238 Total Expense Total Revenues TOTAL 1$ (8,238) $ $ $ - $ (8,238) 919/2003 51 2:57 PM Capital Project FY 200312004 Permanent DPS Facility Capital Project # 756 Project Description To better serve residents and businesses in Westlake, the DPS will need a permanent structure to be housed in. This project includes all phases of building these facilities. Project Schedule Begin Ern Design Jct -03 Dec -03 Construction Dec -03 Oct -04 Fiscal Impact Impact on Operating Budget LTD Budget FY Planned FY 04105 FY 05106 FY 06/07 FY 07108 Project Expense 9130103 03104 Design 2,000 2,000 Construction 3,200,000 Grants Contingencies TOTAL $ - $ - $ 3,200,000 $ - $ q $ - Funding Source Prior Year's Remaining Funds Certificates of Obligations 21000 Total Expense Total Revenues Private TOTAL General Fund $ $ $ $ $ (2,000) Enterprise Fund Westlake Visitor's Association Grants Utility Fund - - Total Interfund Loans 4A 4B 2,000 20,000 Total 2,000 20,000 TOTAL $ 2,000 $ 1 $ (3,180,000) $ - $ - $ Impact on Operating Budget 9/9/2003 52 2:58 PM LTD Budget FY Planned FY 04105 FY 05106 FY 06107 Total Projected Annual Operating Budget 9/30103 03104 Administrative Expenses 2,000 2,000 Town Attorney Civil Engineer Auditor Debt Service Capital Outlay 2,000 21000 Total Expense Total Revenues TOTAL $ (2,000) $ $ $ $ $ (2,000) 9/9/2003 52 2:58 PM Unfunded Needs FY 200312004 Items listed are needed in order to maintain an exceptional level of service to the Town, but are unfunded for the upcoming fiscal year due to budget constraints. The Town plans to implement the following projects when funds become available 1e Bi -Directional Amplifiers for Daimler/Chrysler Building $45,000 2, Dove & Ottinger Intersection Ike -work $100,000 3. Update Master Plans $50,000 0!1012003 53 10:12 AM Westlake Academy Budget FY 2003/2004 Operating Budget Income Local 0 State 934.610 Federal 275.000 Lunch service 45.000 Beverage Sales 1.350 Total Income 1,255,900 Total Expenses 1 252,117 Net 40, Expenses Payroll Expenses Salaries Instructional ' 627.325 Leadership 156.800 Staff 65,385 Total Salaries Worker's Compensation Total Payroll Professional Services Technology 30,000 Professional &Contracted 5,000 Legal 5.000 Health Services O Total Professional Services Insurance Liability Insurance 88.944 Liability Insurance 'Umbrella 3.000 School Leader Errors & Omissions 8.580 Prnperty|nmuranoe-Bni|er 913 Total Insurance Travel / Training /Publications ESC XI Fees 22,792 Travel 10,50O Staff Development 9,COC Bids / Notices /Ads 3500 Total Travell Training / Publications Office Expense Printing 5.000 Copier Lease 4800 Total Office Expense QMA/2O03 Westlake Academy Budget FY 2003/2004 Operating Budget Telephone Phone Service 8.400 Internet T1 Line 6720 Total Telephone Utilities 4`000 Utilities 12.000 mmn 2,580 Total Utilities 94.500 Supplies & Materials Instructional 4`000 Textbooks 10'000 Startup 25,000 Technology /Hardware 94.500 K8odio 600 Total Supplies & 88otedu|o Food Services Beverage Service |BOFeeo Other Operating Costs Total Expenses 1.262.117 Total Income 1,255,960 Net QMB/2003