The URL can be used to link to this page

Home My WebLink AboutRes 04-36 Adopting Revised Budget for Fiscal Year 2004 and Adopting Proposed Budget for Fiscal Year 2005TOWN OF WESTLAKE RESOLUTION NO. 04-36 A RESOLUTION OF THE BOARD OF ALDERMEN OF THE TOWN OF WESTLAKE, TEXAS ADOPTING THE BUDGET FOR THE TOWN OF WESTLAKE, TEXAS FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2004 AND ENDING SEPTEMBER 30, 2005. WHEREAS, notice of a public hearing on the budget for the Town of Westlake, Texas for the fiscal year 2004-2005 (FY 2005) was heretofore published in accordance with law; and WHEREAS, a public hearing was duly held and all interested persons were given an opportunity to be heard for or against any item therein. BE IT RESOLVED BY THE BOARD OF ALDERMEN OF THE TOWN OF WESTLAKE, TEXAS: SECTION 1: That the Board of Aldermen hereby adopts the revised budget for the fiscal year ending September 30, 2004 and the proposed Annual Operating Budget for the fiscal year ending September 30, 2005 and appropriates the funds contained therein. SECTION 2: That a copy of the official adopted 2004-2005 budget document shall be kept on file in the office of the City Secretary. SECTION 3: That this Resolution shall become effective upon the date of its passage. PASSED AND APPROVED ON THIS 23rd DAY OF AUGUST 2004. ATTEST: 6inga Crosswy, To ecretary APPROVED AS TO FORM: tanto wry, Town Attomey Scott Bradley, Mayor Trent O. Petty, To anager *perati'ng Budget F1'scal Year 04/05 October Ist, 2004 to Scptcmbcr 30th, 2005 jkjkL4&. Xxzvj vg 4vow v u wvtsu' vx Air mix y. luzuz, x OF T♦ S '7 RCIAD jkjkL4&. Xxzvj vg 4vow v u wvtsu' vx Air mix y. luzuz, ADMINISTRATIVE OFFICIALS FISCAL YEAR 2004/2005 SCOTT BRADLEY Mayor FRED HELD Mayor Pro Tern DON R.EDDING, BILL FREY, LARRY SPARROW, BUDDY BROWN Board of Aldermen TRENT PETTY Town Manager GINGER GROSSWY Town Secretary STAN LOWRY Town Attorney THE, TOWN OF WESTLAKE. k 2650 OTTINGE.K ROAD k WE TLAKE, TEXAS 76262 July 26, 2004 Honorable Mayor and Members of the Board of Aldermen: It is my pleasure to present the FY 2004/ 2005 budget of the Town of Westlake. We continue to present a budget that provides basic services to meet the community's needs without assessing a property tax. Significant residential growth has required incremental service level increases. The Town anxiously awaits the first stream of new retail growth to enhance these services for future residents and businesses. Major Events of FY 2003-2004 The Town of Westlake opened a new chapter in its history as the Westlake Academy opened in the fall of 2003. In the first year of operations, the Academy was a resounding success. By the end of the year, test scores and student performance combined with the unique education environment offered by the Academy has produced a waiting list of over 520 students in grades K through 7. It is anticipated that FY 2003/2004 will end with the ground breaking for the long awaited mall on the Circle T Ranch. The mall is planned to open in March of 2007. While the mall generates substantial new development fees and promises positive sales tax revenue, it prompts the beginning of a number of expanded level service packages from building inspection to the Department of Public Safety that will begin gearing up during the FY 2004/2005. The opening of the Westlake Academy also afforded the Town the ability to move into new office space owned and operated for the first time by the Town of Westlake. The additional space allowed the town to continue expanding services by adding several key positions including; Carolyn Sims, Director of Marketing and Public Affairs; Troy Meyer, Director of Facilities and Maintenance; Ginger Awtry, Executive Assistant to the Town Manager and Westlake Academy CEO; and Jinn Taylor, the town's first full time Building Official. Public Safety in Westlake continues to grow due to the cross training of members of the Westlake DPS. All but one of our certified fire fighter paramedics is also a peace officer. A number of our Fire/EMS employees have finished Police Academy and are certified Public Safety Officers. This has helped to increase our citation and warrant revenue as well as make our Public Safety division more flexible when crisis arise. THE TOMN of WESTLAKE * 2650 OTTLNQt:R ROAD „ WESTLAKE, TEXAS 76262 i Crime Control District In the FY 2003/2004 Budget, the Board approved the possibility of dissolving the 4A Economic Development Corporation due to concerns raised during the legislative session about the future of 4A spending. Situations and players have changed however and the Town opted not to abandon the 4A in favor of the Crime Control District to give the issue more time to settle. The budget impact of this decision was dramatic in terms of General Fund balance reserves to which 4A would have been transferred but resulted in no additional expenditures or revenues across all fund balances. Fiscal Year 2004/2005 This year the budget consists of eight funds. Fund Summaries The General Fund The General Fund is the main fund for the Town of Westlake. half of the Town's sales tax, development and permit fees, franchise fees, citation revenue, and miscellaneous other revenues support this fund. The fund is responsible for all administrative expenditures including non -enterprise and non -visitor association personnel. Expenditures out of the general fund also include Municipal Court costs, Westlake Fire and Rescue costs, street and park right-of-way maintenance, and consulting expenditures. The Utilitv Fund The Utility Fund is responsible for all water, sewer, and telecommunications duct bank service in the Town. The water and sewer services have become more efficient with the inclusion of the Town's SCADA system and pressure release valves. Due to these new devices, water inflow from Fort Worth can be controlled to a greater degree than before, thereby allowing the Town to avoid large peak payments. Although peak payments can be limited they cannot be avoided due to Fort Worth's new regulations. Therefore, the Town will have a peak payment for next year and because of credits paid to the Town last year, FY 2004/2005 will seem higher than normal. THE TOWN of WESTLAKE * 2650 OTTINGER ROAD ` WESTLAKE, TEXAS 76262 ii Water Rates will be going down in FY 2004/2005 for Town residents and businesses, but due to the increased number of users, revenue should go up. New leases for the duct bank are also anticipated on additional duct bank to be installed by the Town from Pearson Road to Vaquero on the north side of Dove Road. The Utility Fund will take on a new role this upcoming year as the billing process is brought in-house. A third party will print the bills and mail them but the Town will be responsible for collecting the total amounts owed for each account. This should allow for a much more personal level of service to customers when problems arise. The Westlake Visitor's Association The Visitor's Association was established in late FY 1999/2000 and was set up to collect 7% of the gross receipts on most services offered to visitors of the Marriott Solana and any future Westlake hotels. FY 2003/2004 saw the first official employee of the Visitor's Association being hired. This new position will assist the Marriott marketing staff in increasing occupancy to the Hotel, which in turn increases revenue to the Town's Visitors Association fund. A significant new program proposed in this budget is an Airport Transportation Shuttle to deliver and return Marriott visitors to DFW Airport. It is projected that this new program, for which the town will expend from $170,000 to $200,000 depending upon success, will add room rate as well as room nights. 4A Development Fund The 4A Development Fund collects a 1/2 cent sales tax to be used for economic growth and job development projects. Last year the Town contemplated having to dissolve the 4A fund and replacing it with a Crime Control District. Following several changes in the legislation, the Town concluded that it would be premature to dissolve 4A. This resulted in a reduction to the anticipated General Fund ending balance since, had we dissolved the 4A, the remaining funds would have been transferred to the General Fund. In FY 2004/2005, the 4A will continue to honor its Fidelity Tax reimbursement requirement as well as fund a new program called the SH 114 Commercial Growth program designed to improve the Town's ability to attract new and quality commercial growth and the jobs that accompany them. THE TOWN OF WESTLAKE * 2650 OTTTNGER ROAD * WES`FLAK£, TEAS 76262 iii 4B Development Fund The 4B Development Fund operates in a similar fashion to the 4A fund by collecting an additional 1/2 cent sales tax to be used for qualified development projects. The 4B fund has been committed to repayment of the debt incurred for the Town's Civic Campus project. General Capital Project Fund This will be a new fund for the Town in FY 2004/2005. The goal is to take large capital expenditures out of the operating detail and show them in a more representative manner. Thanks to the implementation of a more flexible financial software system during the present fiscal year, the Town now has the accounting software and capability to create this type of fund breakdown which will help maintain the integrity of our accounting process and more clearly illustrate capital project expenses and funding sources. Debt Service Fund Another change in financial reporting this year will be the creation of a debt service fund. By consolidating the Towns debt obligations into one separate fund, the debt service picture is very clear and concise and no longer has to be extricated from each separate fund to see the entire debt picture. Permanent Capital Maintenance Fund In order to begin providing for long term capital repairs and replacement of major Town assets, the FY 2004/2005 budget proposes the creation of the Permanent Capital Maintenance Fund (PCM Fund). Each operating fund that owns and maintains capital assets will, each year, dedicate a planned portion of revenues to set aside for future capital repair and replacement. This helps avoid future bond programs and forces a more conservative pattern of spending in light of uncertain future revenues. Summary The FY 2004/2005 Budget covers a much larger spectrum than any Westlake budget before. The Town is still emphasizing reducing expenditures where possible and ensuring new expenditures, such as maintenance, are useful and cost effective. We are also aggressively researching new revenue sources. From franchise fees to oil and gas royalties, the Town is THE TOWN of WESTLAKE " 2650 oTTINGER ROAD " WESTLAKE, TEXAS -76262 iv searching for ways to maintain services and still avoid a property tax. The Town has budgeted for the beginning phases of the mall construction to begin in FY 2003/2004, with the majority of expenditures incurred in FY 2004/2005. The budget has a built in contingency if the Mall project does not move forward which is based on not hiring additional employees until the beginning of the 2nd Quarter and shifting responsibilities for new demands on existing staff. Westlake continues to be a challenging and rewarding community. Despite the delays of the Mall, the Town has been able to significantly expand services, lower water rates, and provide new quality facilities without adopting a property tax. The staff is committed to researching new and innovative projects that will continue to bring in new revenue streams to support these services and facilities long into the future. I want to offer my respect and thanks to our hard working staff for completing a new phase in Westlake's growth with an updated budget format that more appropriately recognizes cost centers, future demands, and revenue potential across each department. Sincerely, Trent Petty Town Manager THE TOWN of WESTLAKE " 2650 OTTIMER. ROAD * I(ESTLA,KE, TEXAS 76262 V inti' t�rs7� mr(I a A�1 I, Executive 1.....Organization Chart 2..... Employee Summary 3..... Executive Summary Goals & Objectives 15... Administration 16... Building & Code Compliance 17... Emergency Services 18... Municipal Court 19... Public Works 20... Facilities/Recreation 21... Finance — Accounting 22... Human Resources 23... Westlake Visitor's Association General - Fund 100 24... Program Summary 26... Budget Detail 40... Notes Receivable - Ambulance Utility - Fund 500 41... Program Summary 42... Budget Detail 46... Repayment Schedule to General Fund 47... Repayment Schedule to 4B Fund 48... Overhead Storage Payment Visitor - Fund 220 49... Program Summary 50... Budget Detail 4A Corporation Fund - 230 52... Program Summary 53... Budget Detail 54... Fidelity Tax Reimbursement 4B Corporation - Fund 200 55... Program Summary 56... Budget Detail Debt Service - Fund 300 57... Program Summary 58 ... Budget Detail 59...2002 Series Sources and Uses 60...2002 Series Bond Amortization 61...2003 Series Sources and Uses 62...2003 Series Bond Amortization Capital Maintenance - Fund 600 63 ... Program Summary 64 ... Budget Detail Capital Proiects - Fund 410 65... Program Summary 66 ... Budget Detail Capital Proiects Detail 67 ... Capital Project Summary 68 ... Cemetery Grounds Maintenance 69 ... Civic Campus Expansion 70 ... Dove Road Improvements 71 ... FM 1938 (114 to 1709) 72...114 Commercial Growth 73 ... Duct Bank Extension 74 ... Keller Waterline Acquisition 75...Meter Online Reading Platform 76...Scada Systems Improvements 77...Southlake N1 Sewer Line Acquisition 78...Water Meter Retrofit 79...Capital Projects Unfunded Technology Plan 80. --Technology Plan THE TOWN OF WESTL KE * 2654 OTTINQER,ROAD * ESTLAKE, TEXAS, '76262 Citizens of Westlake L Mayor & Board of Aldermen [ interns Page 1 Town � Secretary Cif LVG.y7i PIS' Employee Summary FY 2004/2005 *All new hires will be effective at the beginning of the 2nd quarter 2005 (January 1st 2005) Page 2 01-02 02-03 03-04 04-05 Town Manager 1 1 1 1 Assistant to Town Manager 1 1 1 0 Administrative Assistant 1 1 0 0 Executive Assistant 0 0 1 1 Part -Time Intern 1 0.5 0.5 1 Town Secretary 1 1 1 1 Building Official 0 0 1 1 Fire/EMS Coordinator 1 1 1 1 *Firemen/Paramedics 0 9 9 10 Municipal Court Clerk 1 1 1 1 Municipal Court Deputy Clerk 0 0 1.5 1.5 Municipal Court Judge 1 1 1 1 Municipal Court Marshal 1 1 1 0 Municipal Court Warrant Officer 0 0 0 1 Public Works Superintendent 0 0 1 1 *Utility & Building Technician 0 0 0 1 Facilities & Recreation 0 0 1 1 Finance Director 0 1 1 1 Human Resources 0 0 1 1 Accounts Payable 1 1 1 1 *Records & Revenue 0 0 0 1 Marketing & Public Affairs 0 0 1 1 Total 10.0 19.5 26.0 28.5 *All new hires will be effective at the beginning of the 2nd quarter 2005 (January 1st 2005) Page 2 Introduction The Town of Westlake 2004/2005 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 statement of intents and uses of Town monies, in a 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 funds, including sales tax revenues, citation revenue, 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 the 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. 5. 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 • Revenue Detail • Operating Expenditure Detail • Capital Expenditure Details • Goals and Objectives Report • Funds From Other Sources Detail Each division section contains statistical and financial data for two fiscal years: the current budget year and the fiscal year recently completed as of September 30, 2003 (as amended). THE. TOWN OF WESTLAKE K 2650 oTTINCER ROAD ; WESTLAKE, TEXAS 762.62. Page 3 COMPLIANCE WITH GASB STATEMENT NO. 34 The FY 2004/2005 annual operating budget hast been prepared in accordance to provisions outlined within the Governmental Accounting Standards Board (GASB) "Statement No. 34, Basic Financial Statements - and Management's Discussion and Analysis - for Stat and Local Governments"(GASB 34). The GASB establishes national standards for financial accounting and reporting for state and local governmental entities to make their financial reports more understandable, consistent, uniform and comparable, thereby being more easily understood by government employees, elected and appointed officials, and the general public. GASB 34 mandates new financial reporting standards that apply to most state and local government entities in Texas and around the nation. The most important aspect of GASB 34 requires that financial statements be prepared on a full accrual basis. GASB 34 also now requires governments to report infrastructure and depreciate their capital assets. BASIS OF ACCOUNTINGBUDGETING All governmental fund types are budgeted and accounted for on a GAAP basis for purposes of financial statement presentations. All of these 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 a 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. THE TOWN of WESTL KE * 2650 oTRNGER ROAD ` lL E rTLAKE, TEXAS 76262 Page 4 :i. 1p f 3 , rt 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. 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. 3. 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 1/2 cent sales tax levy for each Economic Development Corporation. The proceeds are used for general economic development and infrastructure support. 4. 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. 5. The Permanent Capital Maintenance Fund is an account to offset the future costs of maintenance and repairs of large capital assets due to age and use. Since most assets are owned by The Utility Fund, it will be the primary funding source and principal recipient of funds from the Permanent Capital Maintenance Fund. The major exception will be costs associated with the Westlake Civic Campus and major street repairs which will continue to be paid from the General Fund 6. The Debt Service Fund is used to illustrate the funding and payment of debt service. Operating budgets do not have appropriate places to show the payment of debt service so the creation of a fund is a more accurate accounting portrayal of the process. The Debt Service Fund will pay for the two issues of bonds made to build the Civic Campus. Funding will be from the 4B Development Fund. THE TOWN OF WESTLAKE * 26,50 QTTIN(aER. i OAD ` WESTLAKE, TEXAS -76262 Page 5 7. 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 project budget, which may span more than one budget year. These have been divided into four types: • General Government Capital Projects are those projects that are typically funded with general obligation bond funds, state and federal grants, and transfers from governmental funds. 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 TOWN OF WESTLAKE * 200, oTTINGEH ROAD * WESTLAKF, TEXAS 76262 Page 6 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 revenues 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 • Detailed estimates of expenditures shown separately for each activity to support the proposed expenditure • A revenue and expense statement for all bonds • A description of all bond issues outstanding • A schedule of the principal and interest payments of each bond issue • 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. THE TOWN of WESTL.AKE ' 2650 4TTIN(iER. E.QA0 `° WESTLAKE, TEXAS 76262 Page 7 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 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. THE TOWN OF WESTLAKE " 2650 QTTINEiER. ROAD ` WESTLArKE, TEXAS '76262 Page 8 GENERAL FUND Revenues Funding of the Town's General Fund operations is derived from five 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 2004/2005 are projected to be $5,459,370 as compared to FY 2003/2004 total of $3,274,910. Sales F Use 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. Sales taxes are budgeted to be slightly higher for FY 2004/2005 due to expanded economic growth, the beginning of construction on the mall, and a tax situs being developed for the mall project. 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 alcoholic beverage tax revenue is expected to increase only slightly for next year due to the closing of Chili's and the opening of the Vaquero Golf Clubhouse. Franchise Taxes Franchise tax represents those revenues collected from utilities operating within the Town that use the Town rights-of-way to conduct their business. The Town has raised the franchise fee 1%0 (to 5%) from Tri -County Electric in order to increase revenues. A flat rate is charged to both telephone operators (adjusted annually) based on the number of access lines. THE TOWN OF WEST(.,. KE * 2650 OTTINOER. ROAD * WESTLAKE., TEXAS -76262 Page 9 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 activity is expected to improve throughout 2004/2005 because of the mall. This will be the biggest revenue source for the Town in FY 2004/2005. The development fees related to the mall are projected to be over $1.6 million. Residential construction is also projected to increase next year with the Westlake Academy enticing many new people to move to town. Court Revenue The revenue generated from the Court is based on citations and warrants issued. The Keller Police department will continue to perform its contractual patrol of Westlake roads in 2004- 2005. The Fire/EMS staff of the Town who are trained as Police Officers help to reduce the warrant backlog and pursue current warrants. Citation revenue for FY 2004/2005 is projected at $600,000, an increase of $100,000 from FY 2003/2004. Miscellaneous Revenue Includes the sale of printed materials as well as interest earned. Expenditures FY 2004/2005 proposed operating expenditures in General Fund total $3,586,341, compared with $3,600,465 in FY 2003/2004. This variance of ($14,124) is due to a conservative budgeting strategy based on the uncertainty surrounding the mall project and its opening. Although the budget represents an overall decrease in expenditures, some line -items reflect notable increases. One significant increase scheduled for FY 2004/2005 is the maintenance and services required for the Civic Campus site. The Town is proposing costs of approximately $200,000 to maintain the integrity and cleanliness of the 54,000 sq. ft. campus. Staff additions of mid -year FY 2003/2004 will continue to decrease costs related to third -party outsourcing in 2004/2005. New positions budgeted for next year include a Records & Revenue Clerk along with a Building & Utilities Technician. The new full time positions, however, will not be hired until January 1, 2005 after a more certain plan for mall construction has been received. THE TOWN 0f WESTLAKE * 2050 OTUNGER EOAI] ` WESTLAKE, TEXAS 761262 Page 10 UTILITY FUND The Utility Fund 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 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 FY 2002/2003 with payments totaling $281.293. In FY 2003/2004 the Town received payment from Verizon in the amount of $183,452. In FY 2004/2005 the Town will enter into a lease with Verizon for a new portion of the duct bank which Verizon is building, and will sell to the Town, then lease. RPvPnlfp The Utility Fund receives revenues from the duct bank, selling water to residential and commercial users, and wastewater services the Town provides. Each of these is described in more detail below to provide an understanding of how different factors can explain their totals. FY 2003/2004 revenues are projected to end with a total of $1,335,020. For the FY 2004/2005 proposed revenues should equal $1,600,256. Most of the increase is due to an increase in usage, both residential and commercial. The mall construction project will have a tremendous effect on water revenue for this coming year. Water Revenue The Utility Fund is the recipient of all revenue generated from water sales in the Town. In preparing for the Town's future growth, a comprehensive utility infrastructure was put into place in 2000 and has been constantly updated. Because of the limited number of customers and very high cost of new infrastructure to serve the Town, commercial and residential rates have been historically among the highest in the state. Significant effort has been made to reduce the Towns water rates and still maintain fund integrity and service response. THE TOWN Of W STLAKE. * 2650 OTT NEER ROAD " WESTLAKK, TEXAS 76262 Page 11 ' / The 2004/2005 proposed budget does reflect a reduction in water rates for both residential and commercial users. The new rate will be 14% less for the average monthly residential consumer and will be 13% less for commercial customers dependent upon the amounts of water they use. Water Rate Comparison - Residential (Current Rate vs Proposed Rate) $250 $200 0 tz ' $150 $100 $50 a ' } Avg Vaquero Home Avg Glenwyck Home Avg Aspen Ln Home I] Current Rate ® Proposed Rate Average Homes using 3/4' meter and pumping 42,000/gpm (Vaquero), 56,000/gpm (Glenwyck), 15,000/gmp (Aspen Lane) Water Rate Comparison - Commercial (Current Rate vs. Proposed Rate) $1,800 -- _w.-- $1,600 ^� $1,400 $1,200 — $1,000 $800 $600 $400 $200 $0 50,000 gal. 100,000 ga1. 250,000 gal. ■ Current Rate 0 Proposed Rate Commercial rates based on 3" meter at 3 different pump rates. THE TOWN of WESTLAKE. * 2.650 OTThNGER POAD * 175 STLtkKE, TE AS'76262 Page 12 Wastewater Revenues The Town is not recommending a reduction in wastewater rates in 2004/2005. Next year, if the fund stays sound and adequate revenues can be generated, a wastewater rate reduction will be proposed. Duet Bank The duct bank is the conduit, which is intended to house utility infrastructure in a manner that helps the Town account for everything in the ground in Westlake. Revenues the Utility Fund receives from the duct bank are contingent upon utility companies leasing out portions of the conduit. Due to increased customer demand, the budget for FY 2003/2004 was amended up $76,452 to cover the increase in duct bank revenue, The Town has budgeted an additional $170,100 for the current year leases. Expenses FY 2004/2005 projected expenses in the Utility Fund total $1,182,462. The proposed expenses are lower than FY 2003/2004, due to the debt being paid off to Southlake for the N-1 line reimbursement. For the first year, the Utility Fund will begin to repay debt it owes to the General Fund and 4B. The numerous debts will be paid out over time with no interest being charged. THE, TOWN OF WESTLAKE ' 2650 OTUNGER ROAD ' W£STLAKE, TEXAS 76262 Page 13 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 lower than projected for FY 2003/2004. Revenues Revenues for the Westlake Visitor's Association are based on the Hotel/Motel tax and interest income on the account. Revenues for FY 2003/2004 are projected to be $335,500 compared to a budget of $427,328 for next year. The increase is due to increased marketing and promotions work by both Marriott Solana and the Towns new Director of Marketing and Public Affairs. Expenditures Expenditures for the FY 2003/2004 were $212,654, versus the $437,815 proposed for FY 2004/2005. This increase is based on the Town's desire to assist the Marriott in improving occupancy at the hotel which produces additional revenue for the Town. Most of this increase is a full year of salary plus general office expenses for the Director of Marketing and Public Affairs position added in 2003-2004. The Town has also proposed allocating up to $200,000 to the Marriott, currently Westlake's only hotel, to purchase shuttle buses so that the hotel can provide transportation to and from the airport for its guests. The minimum amount allocated for the Marriott Hotel is '$170,000 to $200,000, although more can be obtained by meeting certain performance objectives. Expected increases in revenue should offset this cost to the Visitor's Fund. The expenditures in this fund are to be used for the promotion of this community and its tourism business. THE TOWN OF WESTLAKE * 2.650 OTTINGER ROAD ` WESTLttKE, TEXAS 76262 Page 14 :lrFi't'Etij�.. t WW\ W6" VOd1S& Program Description .................................... .................. Make the Town of Westlake the most beautiful and desirable place to live, work, play and educate children in America. r Fy ADMINISTRATION Program Broad Goals ....................................................... Develop a reasonable and profitable plan which provides retail growth compliant with Westlake development standards. Maintain a competent and competitive work force Investigate new ways to partner with public and private sector service providers to control cost and improve services. Deploy additional revenue generating ventures in concert with development funding. Pool natural gas mineral right owners to maximize return and minimize intrusion for property owners, the Town of Westlake and the Westlake Academy. Deploy a real time water system of billing designed to conserve water and lower cast, THE TOWN OF WESTLAKE * 2650 OTI_M ROAD *'WFST`LAKE, TEAS 76262 Page 15 9- r .: .-FY BUILDING & CODE COMPLIANCE Program Description ....................................................... Commercial and Residential Inspections (including Building, Mechanical, Electrical, Plumbing & Energy) Commercial and Residential Construction Plans Review Commercial and Residential Energy Plans Review TAS (Texas Accessibility Standards) Plans Review Code and Ordinance Compliance Registration of Contractor's, Sub -Contractors, others Issuance of Building Permits Provide pre -construction consultation with Contractor's, Sub - Contractor's, Engineer's, and/or the individual property owner to facilitate code compliance Trends ......................................................... 50 SFR (Single Family Residences) anticipated to be Built 04-05 (approximately 10 inspections/SFR = 500 inspectiors) 10-20 Commercial renovations anticipated Undetermined future growth, Potential Mall Program Broad Goals ....................................................... Serve the Commercial and Residential Construction needs of the community, with professionalism, courtesy, and distinction. Create a fair and accurate building permit fee mechanism. Streamline the Building Permit process to insure expedient and efficient issuance. Insure Code and Ordinance Compliance. Establish a records system that meets the standards of municipal record keeping. Provide an opportunity for consumer feedback and re- evaluation of procedure(s). Program 2004/05 Objectives ........................................................ Develop data to show the most cost-effective use of outside Inspectors. Assess the viability and Impact of standardizing the Building Permit Fee extrapolation process. Expand the in-house or outsourced Building Inspection and/or Plans Review Services; TAS or ADA Certified Inspector and/or Certified Reviewer. To improve the existing Construction Inspection services, through feedback and self-evaluation. To provide (90%) some day Inspection service, if requested prior to noon. To Provide Maximum 10 day turn around time for all Plans review submittal to permit issued. Program Customers ....................................................... Homeowners Developers Builders Contractors Town Council's Broad Goal(s) Provide courteous, expedient and cost-effective service while maintaining profitability production levels. Equipment ............................ I.......................... Construction books Library of Standards, References and "[nternational" Code Books. Drafting Tables to expedite plans review process. Select lighting for the plans review process. THE TOWN OF WESTLAKE * 2650 0TriXQF_ROAD - WESTLAKE, TEXAS 6262 Page 16 r V Program Description Wea%vii" Goals & Objectives ,- FY 04 05 ....................................................... The Deportment of Public Safety provides the public safety needs of the Town via a variety of programs and services, The goal is to provide the most efficient method of delivering the traditional services - Fire Protection and Prevention, Emergency Medical Services, and Law Enforcement - while partnering other Town, as well as private and public, organizations to expand services. Trends ........................................................ The Department currently provides a portion - Fire and EMS - of the Town's public safety needs but is poised to assume the full responsibility of that role. Department personnel have received certification as Peace Officers and continue training to implement a fully integrated Department of Public Safety in order to meet the needs for the citizens, the business community and guest to the Town. This expectation of an expanded role for the Department will be addressed through public/private partnerships and coordination with our neighbors as well as other Town Departments. Program Broad Goals ....................................................... The challenge is to provide the most economical and efficient service to the Town as possible. Primarily, the continual improvement of existing programs is the goal of the Department. The Department plans to improve service; continue to support the Courts in reducing outstanding warrants; plan for the future by training personnel to assume the roles that are currently contracted out, such as the Fire Marshals' duties and Law Enforcement. Program 2004/05 Objectives ....................................................... The establishment of a fully integrated Department of Public Safety by adding Law Enforcement duties to the Department's mission. Hire personnel to phase out the current contractual services. Hiring tri -certified Public Safety Officers to handle the inspection and enforcement duties of the Fire Marshal, as well as those of a Prevention Specialist acting in the capacity of a crime prevention specialist and a victim's advocate. Enhance revenue streams to fund public safety needs and activities. Utilization of tri -certified personnel in the Courts Assistance Program and in traffic enforcement activities to provide efficient and flexible staffing options. EMERGENCY SERVICES Program Partnerships The City of Keller Police Department The City of Southlake Department of Public Safety - Fire Marshal's Office Northeast Fire Department Association (NEFDA) Northeast Tarrant County Radio Consortium North Central Texas Council of Governments -Emergency Management Ft. Worth and Tarrant County Office of Emergency Management Maguire Partners and the Solana Fitness Center Program Customers ....................................................... The citizens, business leaders, and visitors to the Town of Westlake Community business concerns located in the Solana Complex Fidelity Investments Daimler Chrysler Financial Center The Vaquero Development Westlake Academy The various builders, contractors, and developers located throughout the Town Program Equipment ....................................................... Law Enforcement vehicles and associated equipment Radio consortium full membership fees and infro-structure cost THE TOWN OF WA KE k 26500TMN(aE ROAD' * WtSMAKFI, TEAS 76262 Page 17 Program Description IVAGoals & Ob•ectives ,, ....................................................... Maintain the current level of service to the patrons of the Municipal Court and reduce the backlog of warrants to be issued. Trends ........................................................ Warrants have been backlogged an average of 10-12 months from delinquency to the date of issuance. Citation entry has had an average entry time of 5 - 8 business days from date of receipt by the court. At current, the Court is handling approximately 700 - 800 citations per month. Program Broad Goals ....................................................... Court staff will provide prompt assistance in a courteous manner. This includes telephone service, mail service and customers who appear in person. Court staff will work to enter tickets in a timely manner and complete daily court deposits, Remain current on warrant issuance. The Court will conduct hearings and trials in a professional and dignified manner in order to provide an impartial setting for cases to be reviewed by the Municipal Court Judge. Program 2004/05 Objectives ....................................................... Enter tickets within 3 days of receipt in the court office and daily court deposits to ensure accurate and timely reporting to the Town Management. Provide a Bench or Jury Trial docket every month to allow defendants the opportunity to present their cases to the Judge in an expedient manner. Issue two delinquent sets of warrants each month until the Court is current. Remain current on warrant issuance within 30 days of delinquency. MUNICIPAL COURT Program Provided in Partnership With ........................................ DPS Pmployees Keller Police Department Program Customers ........................................... Court Patrons Town Council's Broad Goal(s) Provide effective and efficient court services utilizing the most current technology and resources available to process citations and maximize collection of outstanding warrants and judgments. Equipment Computer Handheld Ticket writers THE TOWN OF T KF. " 2650 OTTIN11RE COAD * ' LARFE, TFXAS 76262 Rage 18 Program Description WCO%%" Goals & Objectives,- r � ve FY ....................................................... The water/wastewater and duct bank program is responsible for the operation, maintenance, repair, and installation of the water distribution, waste water collection, and duct bank system. The street maintenance program is responsible for inspecting and maintaining the Town's traffic signs, signals, roadway markings, and street pavement. Trends Most of the current water system is new and is in good condition. However, there has not been any funding for preventative maintenance. The purchase of the existing Keller waterlines in Westlake was completed last year. Westlake is now responsible for repairing the acquired waterlines. Over the last year there has been a 35.5 % increase in water/sewer revenue. A 54% increase in the number of water customers has created a higher demand on the water and wastewater system and is increasing operating costs. Program Broad Goals ............................................ I.......... To efficiently and effectively provide a safe and reliable potable water distribution, wastewater collection, and duct bank system for the Town's customers. Establish a preventative maintenance schedule for water and wastewater facilities to minimize emergency service disruptions and repair costs. To promote water conservation efforts; thereby saving water customers money. Maintain streets in safe travelable condition Program 2004/05 Objectives • Respond to all Public Works emergencies [water, sewer, street, duct bank] within 1 hour of notification. • Complete water customer work orders within 1 day. • Conduct water quality and facility inspections required by the Texas Department of Environmental Quality. • Develop a complete set of utility maps for the water, wastewater, and duct bank systems. • Exercise all water valves in the system once a year. • Inspect, lubricate, fuel, and repair all water and wastewater facilities as required. • Develop a sewer cleaning maintenance program for cleaning the entire system annually. PUBLIC WORKS Program 2004/05 Objectives (continued) .............................................. • Conduct infrastructure quality control inspections of all new installations and maintenance bond items. • Inspect, document, and repair all manholes within and adjacent to the Glenwyck Farms subdivision • Review existing engineering standards and implement new engineering drawings to ensure proper infrastructure construction. • Integrate existing pressure tank into the SCADA system to back up the elevated storage tank. • Connect waterlines to the Town's distribution system on Dove, Ottinger, Mahotea Boone, and Pearson. • Implement a meter testing and replacement schedule for the Town's water meters every five years. • Replace 50% of the existing manual read meters with radio read meters. • Continue to evaluate water, wastewater rates and tap fees. • Implement a "real-time" meter reading system for the civic campus. • Rehabilitate approx. 4000 IF of Dove Road. • Respond within 1 day to all pothole work orders. • Retain resource for sandinglsolting roadways during freezing conditions. • Respond to all sign repair work orders within two working days. Inventory all streets and identify prior maintenance. • Verify condition of streets every year. • Construct a replacement/rehabilitation plan based on subgrade, paving, and drainage conditions. Program Provided in Partnership With The City of Keller, City of Southlake, City of Fort Worth, Trinity River Authority, Consultant engineering firms, Tarrant County, and Denton County, and meter reading technology consultants, Program Customers ........................................................ Town water and wastewater customers, commuters, and private companies within the Town's duct bank, R.O.W., and easements. Town Council's Broad Goal(s) .............................................. I........ Safe and effective operation of the water, wastewater, and duct bank systems to conserve resources and provide innovative ways to encourage conservation. Provide safe and aesthetically pleasing driving experience that maximizes the intent of the thoroughfare plan. Equipment Obtain utility maintenance vehicle. THE TOC]' OF WESTLAKE * 2650 OTTINQER ROADk IST M,. TEXAS '70262 Page 19 Program Description I P, V Gni Goals & Objectives,- ff FACILITIES MAINTENANCE and PARKS & RECREATION ............................................. ..I............. The Facilities Maintenance program will perform preventive maintenance on all buildings and landscaping on the campus to protect the Town's investment in its infrastructure and to avoid significant cost as a result of system failures due lack of maintenance. The Recreation Program will offer leagues, lessons, summer camps, community education classes and after school programs for the adult and youth population in Westlake. The Westlake Academy and the park located within Glenwyck Farms will provide the facilities and space to deliver all recreation programs to the public. The park at Glenwyck Farms and the Academy campus will host Arbor Day, Bandana Bonanza, Christmas Lighting and other similar events. Trends Due to the occupancy of the 53,000 square foot civic campus facility in the fall of 2003, maintenance costs will increase. Made of natural stone and wood interior and exterior, the facility is surrounded by rolling landscape and manicured lawn areas. The facility is equipped with state of the art security cameras, card scanners and climate control systems. The completion of the recreational center and the population growth of The Town of Westlake, has increased the need for parks and recreation programs and services to be offered to citizens of Westlake for the first time. Program Broad Goals ............................................................. The Maintenance program will schedule timely, preventive maintenance and repair of the Academy, Town and Glenwyck Farms Park, to protect the Town's investment in its infrastructure and keep The Academy, Town facilities and Glenwyck Farms Park aesthetically pleasing. Our goal is to measure and implement the most cost effective plan for consumption of utility services according to state low and regulations. Recreational and educational opportunities for the adult and youth citizens of Westlake and surrounding communities will be offered Revenue generated through these programs and services will help to support facility cost. Program 2004/05 Objectives ............................................................. Create a quarterly and monthly maintenance agreement for Academy and municipal campus for the following systems: Cleaning service - Daily and semi-annual HVAC and heating - Quarterly Electrical systems - Quarterly Security systems - Semi-annual Fire sprinkler and alarm systems - Annual Maintain the integrity of athletic fields: 30 mowings and 2 fertilizations for athletic field 4 field mowings around athletic field Complete restoration and beautification of Civic Campus pond. Includes stocking the pond with fish and providing a natural habitat. Provide monthly energy usage reports and implement best practices by utilizing our climate control systems. Supplemental Recreation Programs: Enroll 40 students in after school programs each semester Provide 4 community education classes Host two tournaments and leagues. Provide tennis and golf lessons to students and residents Increase Park and Recreation revenues by 5% through team gym rentals and ticket sales for local sporting events and theme parks. Support and assist in increasing revenues for the following local community events: Arbor Day and Bandana Bonanza. Ensure the Christmas Lighting and Decoration Day have a quality setting to accommodated a 5% increase in participation. Program Provided in Partnership With Consulting with Tri County, Westlake Academy coaches, Glenwyck Farms Home Owners Association, Bowmen Sports (assist with summer programs), United States Tennis Association f coach) Program Customers ............................................. ' Academy students, Town & Academy employees, and participants in local celebrations. THE TOWN OF WESTLAKE " 2650OTTLNUER ROAD' * WESTLAKE, TEXAS 76202 Page 20 Program Description W"q%%" Goals & ....................................................... The Accounting program maintains the Town, Academy and Academy Foundation financial system and fiscal controls, i.e. general ledger, payroll, accounts payable, cash management, fixed assets inventory tracking system and accounts receivable for the Town. The program is also responsible for the coordination of the financial statement audit and the preparation of monthly reports and special reports. The Finance/Utility Billing program provides for the accurate and timely billing of the Town's wafer and sewer services, assists customers in applying for and discontinuing utility service, and responds to customer inquiries and disputes regarding their utility account. Trends ....................................................... With the move to the new facility and the growth of the Town's operations, the volume of accounts payable has more than doubled in the past year. Along with the implementation of the STW governmental accounting software as well as the hiring of additional staff, the efficiency and effectiveness of the Finance Department will continue to improve, in previous years, the Town has contracted with Aqua Source to read meters and generate utility billing, A Utility Billing software system has been purchased and will be maintained directly by Town personnel. Program Broad Goals ........................................................ Maintain the accounting and financial reporting systems in conformance with all state and federal laws, Generally Accepted Accounting Principles (GAAP), standards of the Governmental Accounting Standards Board (GASB) and the Government Finance Officers Association (GFOA). Provide sound and conservative fiscal management in compliance with ail state and federal regulations. Implement inter -department accounting procedures and internal control systems to ensure data integrity and ease of financial information tracking. Implement a utility billing/collection system and achieve a more efficient and effective collection of delinquent accounts. r FY FINANCE - Accounting Program 2004/05 Objectives ....................................................... Develop cash management and departmental reporting requirements. Provide monthly reports and support to all departments for review and feedback. Document policies and procedures for all accounting functions related to the Town, Academy and Foundation. Identify and log all fixed assets (Town and Academy) into the STW inventory system and maintain depreciation schedules for all applicable assets that exceed the approved capitalization threshold, Implement purchase order system for all Town and Academy purchases and provide training to all departments to ensure compliance. Review insurance coverages and premiums annually. Perform all utility billing functions in a timely and accurate manner, e.g, billing, collection, establishing and discontinuation of accounts, and response to customer inquires. Monitor accounts receivable aging report to ensure that aging is at a minimum of 85% and use appropriate collection methods following State and Federal collection laws to collect delinquent accounts owed to the Town. Program Provided in Partnership With Region XI Education Service Center Third party printing of utility billing Program Customers ........................................................ Westlake Academy Town of Westlake staff Westlake Academy Foundation Water/sewer consumers THE TOWN OF WESTLAKE * 26-50 OTTIM R0*D * WESTLAKE, TEXAS 76262 Page 21 Terri ri Program Description ................................ I...................... The Human Resources Department provides guidance and support to all Human Resources (HR) programs. Trends ....................................................... Evolving and complex employmenf laws and litigation threats, benefit regulations, rising insurance costs, and uncertain general fund revenues continue to stretch staff's capacity to address ongoing HR service delivery needs and workplace compliance requirements. Program Broad Goals ....................................................... Improve employee benefit package with emphasis on no -cost additions. Enhance Flex Plan benefit. Improve employee communications. Diligently pursue training & education opportunities in the HR field. Centralize the coordination of training opportunities for the Town. e'ctives � FY 04/05 HUMAN RESOURCES Program 2004/05 Objectives ....................................................... Implement additional retirement programs, as well as employee -paid supplemental insurance programs. Improve the Town's Flex plan by implementing ACH reimbursements, and improve pertinent literature regarding the benefits and use of Flexible Spending Plans. Strengthen employee communications through the development of an employee intranet site. The intranet website would contain payroll forms, benefits information, contacts, payroll calendars, employee newsletters, and benefit statements. Finalize the automation of HR benefits reporting with the IRS and TMRS. Coordinate the training opportunities for all Town Departments to meet each department's training goals through TML, TMHRA, NTMA, and professional associations. Maintain a salary structure that is in the top 25% percentile of surveyed cities. Conduct annual salary surveys to remain competitive. Implement a wellness program for all Town employees Program Provided in Partnership With ....................................................... Professional HR associations Insurance brokers Outside consultants Program Customers ....................................................... Town Employees, Board of Alderman, Legal THE TOWN OF WESTLAKE k 2650 OTTI aE ROAD 4- WEST KE,, TEXAS 762622 Page 22 ... Program Description W60%4" Goals & Miectives - FY 04/05 WESTLAKE VISITOR'S ASSOCIATION The Westlake Visitors Association is responsible for planning, marketing and implementing programs and activities that increase visitafion and tourism to the Town of Westlake, Trends Marriott Hotel occupancy has been performing at lower than expected levels. New management and new direction for the Hotel has warranted an increased level of activity by the Town to support this effort. Program Broad Goals ......................................................... Improve hotel occupancy Market and promote the Town of Westlake and the Westlake Academy around the world. Program 2004/05 Objectives Increase occupancy at the Marriott from 57% to 627o Participate in one trade show and one FAM tour with Marriott Work to establish a successful Leadership Westlake class with 10 members Determine interest in the creation of a tourism group/council to market the Metroport area Redesign the Town of Westlake website to be more visitor friendly Become familiar with Sister Cities program and determine its applicability to Westlake and the Westlake Academy Develop a Westlake brochure to include in trade show and event marketing Work with Parks and Facilities to host one new event at the Westlake Academy Work with businesses regarding marketing/promotion requests Establish a marketing plan for the Town of Westlake that integrates media, local community leaders, appointed and elected officials to systematically begin marketing Westlake Program Provided in Partnership With Marriott Solana Maguire Partners Metroporf Cities Westlake Academy Local Businesses Program Customers ................................................. Visitors Hotel clients Businesses Town Council's Broad Goal(s) ....................................................... Make Westlake a premier visitor location by attracting and retaining quality shopping, entertainment and hotel venues consistent with the Town's quality standards THE TOWN OF WESTLAKE * 2650 OT` MER ROAD, * EST KE, TEXAS76262 Page 23 GENERAL FUND Program Summary General Fund Actual FY 02103 Adopted FY 03/04 Amended FY 03104 Adopted FY 04105 Beginning Balance (Cash) (Actual) 1,845,340 1,410,335 1,410,335 1,346,450 Balance Sheet Affect to Cash 202,571 Capital Projects - Revenue 2,809,307 3,354,819 3,274,910 5,459,370 Transfers In 927,600 2,180,430 2,137,043 - Expenditures 2,835,725 3,342,883 3,600,465 3,586,341 Transfers Out 1,538,758 2,265,951 1,875,373 140,000 Ending Balance 1,410,335 1,336,750 1,346,450 3,079,479 Restricted Funds 469,926 186,240 191,200 821,660 Funds Available 940,409 1,150,510 1,155,250 2,257,819 # Days Operating 1211 126 117 230 General Fund -Transfers In Actual FY 02103 Adopted FY 03104 Amended Adopted FY 03104 FY 04/05 4A Dissolved Funds Keller Police 1,176,437 - Capital Projects Capital Projects Sale of 377 Land (owned) - 236,470 Sale of 377 Land to Hillwood 221,000 - 385,200 FM 1938 - RA,SL, Keller Shortfall Purchase of 377 Land (4,487 acres) - 175,452 360,000 FM 1938 (114 to 1709) 174,988 4A Funds 294,483 FM 19381 114 interchange (4A) FM 1938 - WL Portion per Budget 273,000 - 82,174 FM 1938 - WL Portion - - 36,857 FM 1938/114 Interchange Improvements - - 216,897 Transfer to Permanent Capital Maint Fund Debt Service Street Maintenance Debt Service for Civic Campus - 742,080 742,080 Civic Campus Bond Funds 927,600 261,913 261,913 Total Transfers In 927,600 2,180,430 2,137,043 General Fund_ - Transfers Out Actual FY 02/03 Adopted FY 03104 Amended FY 03104 Adopted FY 04105 Keller Police - 530,296 Capital Projects 377 ROW Purchase from TxDOT 221,000 - Purchase of 377 Land (4,487 acres) - - 360,000 FM 1938 (114 to 1709) 174,988 458,662 294,483 FM 19381 114 interchange (4A) - 273,000 216,897 Fire & Rescue 215,170 - Transfer to Permanent Capital Maint Fund Street Maintenance - - 10,000 Transfer to Capital Project Fund Dove Road Improvements - 95,000 Civic Campus Expansion 25,000 Cemetery Maintenance - - 10,000 Debt Service 2002 Certificates of Obligation 927,600 742,080 742,080 2003 Certificates of Obligation - 261,913 261,913 Total Transfers Out 1,538,758 2,265,951 1,875,373 140,000 Page 24 GENERALFUND Program Summary General Fund - Restricted Funds Actual FY 02103 Adopted FY 03104 Amended FY 03104 Adapted FY 04105 Court Security 43,178 56,488 59,900 66,225 Court Technology 46,032 54,752 56,300 67,975 Trail Escrow 75,000 75,000 75,000 75,000 Capital Projects - 4A 305,717 - - Long Range Commitment (debt service) ** - - 612,460 Total Restricted Funds 469,926 986,240 191,200 821,660 * Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in current year revenues and expenditures, i.e. payables and receivables posted to current year's books but cash is not paid nor received until the subsequent year. Also included are inter -fund loans not yet paid or received. Page 25 GENERAL FUND - Fund 100 Fiscal Year 2004/2005 Page 26 Actual FY 02103 Adopted Budget FY 03104 Amended Budget FY 03104 Adopted Budget FY 04105 REVENUE 31310 11 0 Sales Tax Revenue 1,193,030 750,000 1,080,000 1,300,000 31430 11 0 Mixed Beverage Tax 8,263 8,000 8,000 10,000 31820 11 0 AT&T 27,231 40,000 35,000 40,000 31821 11 0 Verizon 2,450 2,724 2,724 5,700 31822 11 0 TXU Gas 5,953 7,000 10,235 13,125 31823 11 0 Charter 161 180 180 200 31824 11 0 One Source 545 606 765 650 31825 11 0 Southwestern Bell 85,223 87,350 80,000 83,000 ' 31826 11 0 Tri County Electric 165,208 200,000 180,000 198,000 31827 11 0 Trinity Waste 7,115 8,000 12,000 7,800 31828 11 0 Misc Franchise Fees 5,916 6,000 5,000 5,000 32110 11 0 Liquor Permit Fees 1,460 750 750 750 33700 11 0 FM1938 Contributions 0 421,805 0 0 34133 11 0 Special Event Fee 250 500 500 500 34141 11 0 Sales of Printed Material 428 500 500 500 34142 11 0 Historical Board Revenue 0 0 5,000 0 36110 11 0 GF Interest Earned 17,385 18,000 6,500 7,500 36112 11 0 Bond Interest 6,723 6,500 0 0 36113 11 0 NIR Interest Income 0 0 5,776 4,767 37500 11 0 Glenwyck HOA Reimbursement 0 9,000 4,500 8,000 38805 11 0 Inter Fund Advance Debt Receipt fror 0 0 0 4,403 38805 11 0 Inter Fund Advance Debt Receipt fror 0 0 0 23,750 39400 11 0 Misc Income 15,671 150 15,000 15,000 39420 11 0 Texas Student Housing Donation 50,000 50,000 I 39410 11 0 Texas Student Housing Lease Income 0 0 0 5,602 I ADMINISTRATIVE -DEPT 11 REVENUESI 1,543,0121 1,567,065 1 1,502,430 1 1,784,246 32210 12 0 Building Permits 307,548 250,000 600,000 600,000 32211 12 0 Inspection/Plan Reviews 0 0 0 390,000 34130 34131 34132 12 0 12 0 12 0 Development Fees Development Fees - Mall Contractor Registrations 172,992 0 15,600 170,000 0 15,600 170,000 149,540 15,600 190,000 1,634,544 40,000 BUILDING - DEPT 12 REVENUESI 496,140 1 435,600 935,140 2,854,544 34000 14 0 EMS User Fee 10,080 10,680 15,000 18,480 34010 34005 39110 14 0 14 0 14 0 Fire Code Permits FEMA Federal Grant Operating Transfer In 225 211,413 0 500 0 646,964 500 0 172,940 350 0 0 EMS - DEPT 14 REVENUESI 221,718 1 658,144 1 188,440 1 18,830 Page 26 GENERAL FUND - Fund 100 Fiscal Year 2004/2005 Adopted Amended Adopted Actual Budget Budget Budget FY 02!03 FY 03104 FY 03104 FY 04105 35110 15 0 Citation Revenue 548,375 475,000 500,000 600,000 35120 15 0 Court Technology 0 22,500 22,500 25,000 35130 15 0 Court Security 0 17,000 17,000 18,000 35140 1.5 0 Warrant Rev, - SIO 0 168,000 80,800 110,000 35150 35160 15 15 0 Warrant Fees 0 NSF Check Fees 0 0 10,000 1,200 25,000 1,200 30,000 1,200 35170 15 0 Court Efficiency Fees 0 250 250 250 35180 36110 15 15 0 Law Enforcement Standards_ 0 Interest Earned 0 62 0 60 700 1,450 700 600 39410 15 0 Administrative fee 0 0 0 3,000 0 0 0 0 COURT - DEPT 15 REVENUES 548,437 1 694,010 1 648,900 1 788,750 new 17 0 Lessons 0 0 0 3,000 new 17 0 Clinics 0 0 0 3,000 new 17 0 Tournaments 0 0 0 1,000 new 17 0 Special Events 0 0 0 500 new 17 0 Leagues 0 0 0 2,500 new 17 0 Wellness 0 0 0 500 new 17 0 Court Fees 0 0 0 250 new 17 0 Kid's Programs 0 0 0 1,000 new 17 0 Equipment Rental new 17 0 Misc Income 0 0 0 0 0 0 250 1,000 PARK & RECS - DEPT 17 REVENUES1 0 1 0 1 0 1 13,000 TOTAL REVENUES 2,809,307 1 3,354,819 1 3,274,910 1 57459,370 Page 27 GENERAL FUND - Fund 100 Fiscal Year 2004/2005 Adopted Amended Adopted Actual Budget Budget Budget FY 02103 FY 03104 1 FY 03104 FY 04105 EXPENDITURES 11 4 Administrative Expense @ 70% 58,666 41110 11 1 Administrative Salaries @ 70% 22,595 19,816 23,160 28,862 42110 11 1 Medical/Dental insurance 2,478 2,369 6,000 3,825 42130 11 1 LTD, AD&D, Life 1,762 5,751 3,540 245 42210 11 1 Social Security 1,077 1,217 1,217 1,789 42220 11 1 Medicare 307 294 294 418 42310 11 1 TMRS 3,772 2,386 4,840 2,029 42510 11 1 Unemployment Taxes 110 123 151 145 42610 11 1 Worker's Compensation 453 2,507 1,250 121 43110 11 1 Internships 0 22,440 12,000 18,000 43130 11 1 Payroll Fees 587 750 250 250 165,000 140,000 140,000 Payroll & Relatedl 33,141 57,653 1 52,702 155,684 45,074 25,000 150,000 75,000 i 43325 11 4 Legislative 50,610 46105 11 2 Office Supplies 7,958 7,500 15,000 5,700 46106 46120 46130 46190 11 11 11 11 2 2 2 2 Hospitality Items Postage - town only Books & Printed Materials Misc Expense 0 5,646 335 5,260 0 4_,500 500 500 1,500 2,000 1,400 1,000 1,500 2,000 500 1,000 43205 11 4 Administrative Expense @ 70% 58,666 102,375 113,694 131,810 43206 11 4 Capitalized Administrative salary expense (30,000) (50,000) 43215 11 4 Civil Engineering (Graham & Assoc) 73,878 25,000 140,000 125,000 43230 11 4 Misc Engineering Fees 1,157 2,500 2,500 2,500 43235 11 4 Circle T Mall Engineering 0 0 0 0 43265 11 4 Information Services Contract 0 0 38,000 33,600 43265 11 4 Technology Maintenance Contracts 0 0 0 10,420 43305 11 4 Misc Legal (Bake r/West/MoonlGosse 39,857 10,000 100,000 25,000 43306 11 4 Circle T Mall Legal 0 0 0 0 43307 11 4 Litigation Counsel 0 0 0 25,000 43310 11 4 Boyle & Lowry 78,232 165,000 140,000 140,000 43315 11 4 Goins, Underkofler 45,074 25,000 150,000 75,000 i 43325 11 4 Legislative 50,610 15,000 36,000 50,000 43505 11 4 Historical Board Expense 0 4,000 8,000 0 43520 11 4 Contingency 41,414 50,000 50,000 50,000 i 44301 11 4 IT Infrastructure 0 3,500 2,000 0 44410 11 4 Office Rent 60,060 10,308 6,524 0 45210 11 4 Insurance - General Liability 3,494 8,350 8,350 20,860 45215 11 4 Insurance - R&PP/Automobile 9,785 8,842 8,745 1,005 45310 11 4 Mobile Phone @ 70% 1,957 1,640 1,000 1,214 45315 11 4 Internet Expense 694 0 0 0 45320 11 4 Phone System Lease (buyout) 2,246 383 4,060 0 j 45805 11 4 Airfare 1,416 1,000 500 400 45815 11 4 Lodging 202 500 900 320 45820 11 4 Meals 1,195 1,300 500 200 45825 11 4 Mileage 328 450 750 550 45830 11 4 Training, Seminars, Meetings 630 1,500 4,500 1,100 Page 28 GENERAL FUND - Fund 900 Fiscal Year 200412005 45305 46205 11 11 6 6 Utilities - Telephone 70% Utilities - Water 70% 9,362 4,706 Adopted Amended Adopted 46220 46225 11 11 6 6 Utilities - Electric 70% Utilities - Gas 70% Actual Budget 1 Budget Budget Utilitiesi FY 02103 FY 03/04 FY 03104 FY 04105 46115 11 4 Dues & Subscriptions 6,500 7,000 8,000 5,575 46125 11 4 Printing 1,885 1,500 5,000 1,500 46135 11 4 Bank Charges 209 200 350 200 46140 11 4 Moving Expense 0 5,000 3,446 0 46145 11 4 Courier Service 648 850 500 500 46160 11 4 Credit Card Processing 0 0 0 50 47900 11 7 Westlake Academy Grant 45,108 0 50,750 50,000 Services 525,242 451,198 854,069 701,804 43405 11 5 Computer Equipment/Software 2,209 0 13,500 12,500 46110 11 5 Office Equipment 0 1,000 1,300 1,300 44302 11 5 Copier Rental/R&M/Copy Chg 4,517 4,000 4,000 2,350 45325 11 5 Rentals/Leases (Quarteriv Mail Machi 0 0 840 840 45305 46205 11 11 6 6 Utilities - Telephone 70% Utilities - Water 70% 9,362 4,706 6,923 0 9,500 9,800 7,140 6,988 46220 46225 11 11 6 6 Utilities - Electric 70% Utilities - Gas 70% 0 545 0 2,500 44,000 10,000 17,745 6,188 Utilitiesi 14,613 1 9,423 1 73,300 1 38,061 ADMINISTRATIVE -DEPT 11 EXPENDITURES1 598,921 1 536,274 1 1,020,611 1823,239 Page 29 GENERAL FUND - Fund 100 Fiscal Year 2004/2005 Adopted Amended Adopted Actual Budget Budget Budget FY 02,03 1 FY 03104 1 FY 03104 FY 04105 41110 42110 12 1 12 1 Building Official Salary Medical/Dental insurance 0 0 0 0 25,000 0 61,238 21,268 42130 12 1 LTD, AD&D, Life 0 0 0 2,311 42210 12 1 Social Security 0 0 0 3,797 42220 42310 12 1 12 1 Medicare TMRS 0 0 0 0 0 0 888 4,305 42510 12 1 Unemployment Taxes 0 0 0 300 42610 41640 12 1 12 1 Worker's Compensation Auto Allowance 0 0 0 0 0 3,000 1,201 0 Payroll & Related 0 0 28,000 95,308 46105 12 2 Office Supplies 0 0 0 1,800 46106 12 2 Office Furniture 0 0 0 1,200 46130 12 2 Books & Printed Materials 0 0 0 1,750 46605 12 2 Uniforms 0 0 0 350 45830 12 4 Suppliesi 0 1 0 1 0 15,100 3,015 46215 12 3 Vehicle Fuel/Maintenance 0 0 0 5,400 Maintenancel 0 1 0 1 0 1 5,400 43260 12 4 Third Party Building Inspection 187,922 90,000 90,000 25,000 43260 12 4 Third Party Building Inspection - Mall 0 0 0 0 45310 12 4 _ Mobile Phone 0 0 0 1,800 45820 12 4 Meals 0 0 0 420 45830 12 4 Training, Seminars, Meetings 0 0 0 3,015 46115 12 4 Dues & Subscriptions 0 0 0 750 Sarvicesi 187,922 1 90,000 1 90,000 1 30,985 7 Vehicle Purchase - Building Official 0 0 0 18,000 BUILDING - DEPT 12 EXPENDITURES 187,922 90,000 118,000 154,793 Page 30 GENERAL FUND - Fund 100 Fiscal Year 2004/2005 Adopted Amended Adopted Actual Budget Budget Budget FY 02103 FY 03104 1 FY 03104 1 FY 04105 41110 13 1 Town Secretary Salary 54,651 57,605 57,605 48,000 41110 13 1 Payroll Credit from TSH 0 0 0 (15,000) 42110 13 1 Medical/Dental Insurance 6,960 4,000 8,000 8,290 42130 13 1 LTD, AD&D, Life 700 2,260 2,260 2,260 42210 13 1 Social Security 3,250 3,750 3,750 2,976 42220 13 1 Medicare 875 875 875 696 42310 13 1 TMRS 4,200 4,250 4,250 3,374 42510 13 1 Unemployment Taxes 150 100 200 207 42610 13 1 Worker's Compensation 250 250 250 253 Payroll & Related 71,036 73,090 77,190 51,056 46105 13 2 Office Supplies 700 700 700 700 46130 13 2 Books & Printed Materials 0 0 0 100 Suppliesi 700 1 700 1 700 1 800 43515 13 4 Community Services 45405 13 4 Advertising 45805 13 4 Airfare 45815 13 4 Lod& 45820 13 4 Meals 14,028 8,000 1,664 2,000 0 0 0 0 0 0 8,000 6,000 3,500 3,000 0 200 0 200 0 150 45825 13 4 Mileage 0 0 0 100 45830 13 4 Training, Seminars, Meetings 0 0 0 400 46115 13 4 Dues & Subscriptions 0 0 0 100 46175 13 4 Meeting Expense 0 150 150 100 46180 13 4 Election Expense 15 1,200 23 1,500 46185 13 4 Codification 6,379 4,000 2,000 2,000 44302 13 5 Copier Rental/R&M/Copy Chg 0 0 0 2 TOWN SECRETARY -DEPT 13 EXPENDITURES 1 93,822 1 89,140 1 91,563 1 Page 31 GENERAL FUND - Fund 100 Fiscal Year 2004/2005 Actual FY 02103 Adopted Amended Adopted Budget Budget Budget FY 03/04 FY 03104 FY 04105 41110 14 1 EMS Salaries 314,047 469,250 492,169 514,046 41120 14 1 EMS Overtime 5,397 29,515 76,469 39,520 41510 14 1 FLSA Regular/Warrant Officers 0 8,960 5,142 35,920 41515 14 1 Supplemental Officers for Warrants 9,737 57,824 20,500 0 41640 14 1 Auto Allowance 0 4,800 4,800 4,800 42110 14 1 Medical/Dental Insurance 48,148 51,979 57,938 68,110 42130 14 1 LTD, AD&D, Life 0 0 3,315 4,341 42210 14 1 Social Security 26,309 30,479 37,143 36,509 42220 14 1 Medicare 0 6,429 8,687 8,538 42310 14 1 TMRS 42510 14 1 Unemployment Taxes 42610 14 1 Worker's Comoensatian 25,341 39,886 50,982 41,397 0 0 1,944 2,277 0 0 9,394 18,458 44210 14 2 Facility Supplies 1,161 6,650 6,650 5,850 46105 46130 14 2 14 2 Office Supplies Books & Printed Materials 1,174 0 2,000 0 2,000 500 2,000 500 46155 14 2 Misc Supplies 2,524 2,500 2,950 2,500 46605 14 2 Uniforms/Personal Gear 1,562 9,060 7,395 8,650 46610 14 2 Weapons & Accessories 1,281 10,990 9,425 5,000 46615 14 2 Medical Supplies 4,067 4,500 4,500 4,500 new 14 2 Cleaning Supplies 0 0 0 500 new new 14 2 14 2 Safety Supplies Fire Hose, Brass, Appliances 0 0 0 0 0 11665 5,000 1,000 46215 14 3 Vehicle Fuel / Maint. 10,643 11,705 9,897 1.0,000 47410 14 3 Motor Vehicles 0 41,984 41,984 0 Maintenancel 10,643 1 53,689 1 51,881 110,000 1,975 4,250 43255 14 4 Keller Police Contract 635,220 646,964 646,964 685,589 43135 43140 14 14 4 Pre-employment Testing 4 Employee Physicals 3,124 0 1,975 4,250 1,975 4,000 2,000 4,150 43335 14 4 Supplemental Labor 140,090 19,090 35,200 35,425 43336 14 4 Contracted Services 15,996 18,295 18,295 16,795 45215 14 4 Property/Automobile Insurance 6,420 3,685 3,685 4,452 45310 14 4 Mobile Phones 671 1,000 750 1,000 45830 14 4 Training, Seminars, Meetings 5,712 17,015 9_,000 10,000 46115 45325 14 14 4 Dues & Subscriptions 5 Rental/Leases (Building Lease) 0 4,800 0 4,800 300 4,800 3,515 4,800 46150 14 4 Licenses & Registration 10,320 2,450 1,800 1,800 Servicesi 822,353 1 719,524 1 726,769 1 769,526 Page 32 GENERAL FUND - Fund 100 Fiscal Year 2004/2005 43405 14 5 Computer 45305 14 6 Utilities -Telephone 46205 14 6 Utilities - Water 46220 14 6 Utilities -Electric 46225 14 6 Actual FY 02103 Adopted Budget FY 03104 Amended Budget FY 03!04 Adopted Budget FY 04l0S 1,433 4,000 4,000 2,500 nentl 1,433 1 4,000 1 4,000 1 2,500 1,580 0 5,363 1,850 3,700 3,000 1,850 1,750 5,860 1,850 2,650 5,860 46225 14 6 Utilities -Gas 0 900 1,640 1,640 Utilitiesi 6,944 1 9,450 1 11,100 1 12,000 46620 14 7 46620 14 7 FEMA Expense (Westlake Portion) FEMA Expense 0 0 19,215 0 19,215 172,940 0 0 FEMAI 0 1 19,215 1 192,155 10 7 7 7 7 Ambulance Fire Truck Protective Equipment Temporary Facilities 144,981 16,037 10,204 41,025 0 0 0 0 0 0 0 0 0 0 0 0 Capitall 212,247 1 0 1 0 10 EMS - DEPT 14 EXPENDITURES 1 1,494,366 1 1,540,700 1 1,789,473 11,603,442 Page 33 GENERAL FUND - Fund 100 Fiscal Year 2004/2005 41110 15 1 Court Salaries 42110 15 1 Medical/Dental Insurance 42130 15 1 LTD, AD&D, Life 42210 15 1 Social Secu 42220 15 1 Medicare Adopted Amended Adopted Actual Budget Budget Budget FY 02103 FY 03104 1 FY 03104 1 FY 04/05 126,702 116,124 116,124 126,780 19,887 23,285 21,671 35,115 0 605 1,075 1,331 8,66.1 7,200 7,200 7,860 0 1,986 1,986 1,838 42310 15 1 TMRS 8,858 9,871 9,871 8,913 42510 15 1 Unemployment Taxes 0 0 0 828 42610 15 1 Worker's Compensation 0 0 1,614 660 Payroll & Relatedl 164,108 1 159,071 1 159,541 11$3,325 7,505 46105 15 2 Office Supplies 3,631 4,500 5,000 4,500 46120 15 2 Postage 0 0 1,000 1,000 46190 15 2 Misc Expense 4,240 4,600 4,450 2,000 Suppliesi 7,871 1 9,100 1 10,450 7,505 46215 15 3 Marshal's Vehicle Maintenance 2,502 3,450 800 500 Maintenancel 2,502 1 3,450 1 800 1500 43330 15 4 Legal Services 15,265 35,420 45,000 35,220 44415 15 4 Courtroom Expense 0 5,600 0 0 45815 15 4 Travel Lodging 0 0 _ 0 350 45825 15 4 Travel Mileage 0 0 100 650 45830 15 4 Training, Seminars, Meetings 2,918 3,430 3,430 2,200 46115 15 4 Dues & Subscriptions 0 0 75 330 46125 15 4 Printing 4,179 4,900 4,900 4,050 46160 15 4 Paymentech Service 2,214 1,200 2,520 3,000 46165 15 4 Court Technology 7,894 14,000 17,000 18,675 46170 15 4 Court Security 1,887 1,650 4,000 4,975 Services 34,357 66,200 77,025 69,450 44302 15 5 Copier Rental/R&M 1 Copy Chg/Supp 0 0 3,700 3,000 COURT - DEPT 15 EXPENDiTURES1 208,838 1 237,821 1 251,516 1263,775 Page 34 M =1 � I=1ZTs1_quel>J!WIN Fiscal Year 200412005 Actual FY 02103 Adopted Budget 1 FY 03104 Amended Budget FY 03104 Adopted Budget 1 FY 04105 17,500 17,500 25,000 41110 16 1 Public Works Salaries 11,339 17,500 17,500 25,000 42110 16 1 Medical/Dental Insurance 0 4,394 6,650 9,983 42130 16 1 LTD, AD&D, Life 0 1,750 120 222 42210 16 1 Social Security 0 2,325 2,325 1,550 42220 16 1 Medicare 0 574 574 363 42310 16 1 TMRS 0 3,188 3,188 1,758 42510 16 1 Unemployment Taxes 0 0 0 145 42610 16 1 Worker's Compensation 0 750 1,590 1,990 Payroll & Relatedl 11,339 1 30,481 1 31,947 1 41,011 46105 16 2 Office Supplies 46130 16 2 Books & Printed Materials 46190 16 2 Mise Expense new 16 2 Warning Devices 467 0 500 0 0 0 50 100 0 0 1,000 0 0 0 0 1,000 71 0 1 1.550 1 1.100 44303 16 3 Road Repair/Maintenance (contract) 12,725 20,000 20,000 5,000 44304 16 3 Sign Repair/Maintenance 5,345 5,000 1,500 1,500 46215 16 3 Vehicle Fuel &Maint 0 1,500 1,500 675 new 16 3 Street Materials (in-house) 0 0 0 500 new 16 3 Pothole Repairs 0 0 0 8,500 new 16 3 ROW Tree Removal 0 0 0 1,500 Maintenancel 18,070 1 26,500 1 23,000 117,675 43210 16 4 Traffic Services 11,225 12,000 8,000 5,000 44305 16 4 ROW Irrigation 45,029 25,000 25,000 25,000 7 Vehicle Purchase - Public Works (401 0 0 0 8,000 7 Ottinger Repair in Denton County 30,000 47902 11 7 FM1938 (114 to 1709) 0 458,662 0 0 CaDitall 0 1 458.662 1 0 1 38,000 PUBLIC WORKS - DEPT 16 EXPENDITURES1 86,130 1 552,643 1 89,497 1127,78fi Page 35 GENERAL FUND - Fund 100 Fiscal Year 200412005 Adopted Amended Adopted Actual Budget Budget Budget FY 02103 1 FY 03104 FY 03/04 FY 04105 41110 17 1 Facilities & Recreation 0 20,000 21,000 52,490 42110 17 1 Medical/Dental Insurance 0 0 0 13,937 42130 17 1 LTD, AD&D, Life 0 0 0 176 42210 17 1 Social Security 0 0 0 3,254 42220 17 1 Medicare 0 0 0 761 42310 17 1 TMRS 0 0 0 3,690 42510 17 1 Unemployment Taxes 0 0 0 104 42610 17 1 Worker's Compensation 0 0 0 1,667 new 172 Payroll & Relatedl D 1 20,000 1 21,000 176,079 3,200 44210 46105 17 2 17 2 Facility Cleaning Supplies Office Supplies 0 0 0 0 500 0 5,500 1,000 46120 17 2 Postage 0 0 0 3,000 46190 17 2 Misc Expense 0 0 0 7,150 46605 172 Uniforms 0 0 0 1,500 new 172 Misc Rec Supplies 0 0 0 9,000 new 172 Soccer & Lacrosse 0 0 0 3,200 new 17 2 Fencing 0 0 0 1,155 new 17 2 Flag Belts 0 0 0 1,150 new 17 2 Ball Machine/Cart 0 0 0 1,450 new 17 2 Radios 0 0 0 2,500 new 17 2 Tennis Supplies 0 0 0 4,000 new 17 2 Mechanical Supplies 0 0 0 2,000 new 17 2 Misc Ground Supplies/Materials 0 0 0 4,000 new 172 Other Building & Grounds 0 0 0 4,500 new 172 Trash Cans 0 0 0 5,000 new 172 Painting Supplies 0 0 0 1,000 new 172 Water Treatment Supplies 0 0 0 1,000 new 17 2 Misc Electrical Supplies/Materials 0 0 0 4,000 new 17 2 Security Supplies and Maintenance 0 0 0 10,000 new 17 2 Fire/Life Safety-AED 0 0 0 5,500 new 17 3 HVAC Supplies/Materials 0 0 0 2,000 45325 17 3 Equipment Rental 0 0 0 4,000 Suppliesi 0 1 0 1 500 183,fi05 new 173 Elevator R&M 0 0 0 1,500 new 17 3 Exterior Building R&M 0 0 0 9,000 new 17 3 Misc General R&M 0 0 0 4,000 new 17 3 Interior Building R&M 0 0 0 2,400 new 17 3 Plumbing R&M 0 0 0 1,000 new 17 3 Electrical R&M 0 0 0 9,100 new 17 3 HVAC Electrical R&M 0 0 0 500 new new 173 17 3 HVAC Filters R&M Fire Sprinkler Maintenance 0 0 0 0 0 0 1,000 4,507 new 17 3 HVAC Maintenance Contract 0 0 0 11,000 44307 17 3 LSl Maintenance 0 10,000 10,000 5,000 Page 36 GENERAL FUND - Fund 100 Fiscal Year 2004/2005 new 17 3 AV Maintenance new 17 3 Actual FY 02103 Adopted Budget 1 FY 03104 Amended Budget FY 03104 Adopted Budget FY 04105 0 0 0 0 2,800 0 0 5,000 43336 17 4 Contract Services 0 0 0 8,000 43510 17 4 Tree City USA 0 2,680 2,680 0 43531 17 4 Marketing & Promotions 0 0 0 3,500 44306 17 4 Contract Building Janitorial 0 39,000 35,000 45,000 44308 17 4 Landscape Maintenance Civic Camps 0 42,000 18,000 29,000 44309 17 4 Landscape Maintenance GW Farms 0 18,000 9,000 16,000 45310 17 4 Mobile Phone 0 0 0 1,200 45315 17 4 Internet Expense - DSL Line 0 0 0 600 45405 17 4 Advertising 0 0 0 1,500 45820 17 4 Travel/Meals 0 0 0 300 45825 17 4 Mileage 0 0 0 800 45830 17 4 Training/Seminars/Meetings 0 0 0 5,500 46115 17 4 Dues & Subscriptions 0 0 0 1,000 N 46125 17 4 Printing 0 0 0 1,000 46150 17 4 Licenses & Registration 0 0 0 3,000 46170 17 4 Security Monitoring 0 0 400 600 new 17 4 Officials (Contract Labor) 0 0 0 3,000 new 17 4 Contract Exterminator 0 0 0 6,625 new 174 Contract Sweeping/Washing 0 0 0 2,500 new 174 Contract Window Cleaning 0 0 0 3,500 new 17 4 Contract Carpet Cleaning 0 0 0 5,000 new 17 4 Irrigation Maintenance Contract 0 0 0 3,000 new new 17 4 17 4 Supplemental Median Maintenance Landscape Trail Maintenance 0 _ 0 0 0 0 0 8,000 5,500 Servicesi 0 1 101,680 1 657080 154,125 t FACILITIESIiRECREATION - DEPT 17 EXPI 0 1 131,680 1 96,580 1 370,616 Page 37 GENERAL FUND - Fund 100 Fiscal Year 2004/2005 42210 18 1 Adopted Amended Adopted 7,300 Actual Budget Budget Budget FY 02103 FY 03104 FY 03/04 FY 04105 42510 18 1 Unemployment Taxes 375 100 500 538 41110 18 1 Finance/HR Salaries 68,696 98,000 98,000 114,156 Capitalized salary expenditure 500 (20,000) (20,000) t 42110 18 1 Mariirallr]antal Insiiranr.P 4 ()An R On() 18 non 18 (]3A 42210 18 1 Social Security 4,500 7,300 7,300 7,078 42220 42310 18 1 18 1 Medicare TMRS 900 7,000 1,700 8,275 1,700 8,275 1,655 8,025 42510 18 1 Unemployment Taxes 375 100 500 538 42610 18 1 Worker's Compensation 500 500 500 498 6 Payroll & Related 87,051 125,575 113,975 129,693 46105 46130 46190 18 2 18 2 18 2 Office Supplies Books & Printed Materials Misc Expense 1,800 0 0 1,800 0 0 1,800 0 0 1,800 100 1,000 Suppliesi 1,800 1 1,800 1 1,800 1 2,900 I 44310 18 4 Accounting Software Maintenance 0 4,500 4,500 6,500 43245 18 4 Financial Consultant (Larry Williamsc 76,876 6,500 6,500 6,500 ' 43250 18 4 Auditor @ 70% 0 26,250 16,450 18,900 45805 18 4 Airfare 0 0 0 500 45815 18 4 Lodging 0 0 0 640 45820 18 4 Meals 0 0 0 400 45825 18 4 Mileage 0 0 0 375 45830 18 4 Training, Seminars, Meetings 0 0 0 3,750 46115 18 4 Dues & Subscriptions 0 0 0 1,800 new 18 4 Special Events (Employee Relations) 0 0 0 250 Servicesi 76,876 1 37,250 1 27,450 1 39,616 43405 18 5 Computer Equipment/Software 0 0 0 2,000 Equipmenti 0 1 0 1 0 1 2,000 FINANCE - DEPT 18 EXPENDITURESI 165,727 1 164,625 1 143,225 1 174,209 TOTAL EXPENDITURES1 2,835,725 1 3,342,883 1 3,600,4651 3,586,341 Page 38 GENERAL FUND - Fund 100 Fiscal Year 2004/2005 Adapted Amended Adopted Actual Budget Budget Budget FY 02/03 1 FY 03104 FY 03104 1 FY 04105 Total Revenue 2,809,307 3,354,819 3,274,910 5,459,370 Total Expenditures 2,835,725 3,342,883 3,600,465 3,586,341 MET (26,418)1 11,936 1 (325,555)1 1,873,029 (26,418) 11,936 TRANSFERS 9 Debt Service - 2002 series (413) 927,600 742,080 742,080 0 9 4A Dissolved Funds 0 1,176,437 0 0 9 Debt Service - 2003 series (CC) 0 261,913 261,913 0 9 FM1938 (114 to 1709) 0 0 294,483 0 9 FM1938 Interchange - xfr in from 4A 0 0 216,897 -0 9 9 Sale of 377 Land (owned) Sale of 377 Land (to Hlllwood) 0 0 0 0 236,470 385,200 0 0 TRANSFERS IN - OTHER FINANCING SOURCESI 927,600 1 2,180,430 1 2,137,043 0 9!002 Certificates of Obligation (to CC) 927,600 742,080 742,080 0 91003 Certificates of Obligation (to CC) 0 261,913 261,913 0 9 377 Land Purchase (4.487 acres) 215,170 0 360,000 0 9 377 ROW Purchase from TxDot 221,000 0 0 0 9 4A Dissolution for CCD 0 530,296 0 0 9 FM1938 (114 to 1709) 174,988 458,662 294,483 0 9 FM1938Interchange 0 273,000 216,897 0 Permanent Capital Maintenance Fund 640: 9 Street Maintenance 0 0 0 10,000 Capital Project Fund 410: 1,845,340 1,410,335 1,410,335 1,346,450 9 Dove Road Improvements 0 0 0 95,000 9 Civic Campus Expansion 0 0 0 25,000 9 Cemetery Maintenance 0 0 0 10,000 TRANSFERS OUT - OTHER FINANCING USESI 1,538,758 1 2,265,951 1,875,373 140,000 SUMMARY yected Ending Fund Balance 1,845,340 1,410,335 1,410,335 1,346,450 Balance Sheet Affect to Cash 202,571 0 0 0 Total Revenue 2,809,307 3,354,819 3,274,910 5,459,370 Transfers In 927,600 2,180,430 2,137,043 0 Total Expenditures (2,835,725) (3,342,883) (3,600,465) (3,586,341) Transfers Out (1,538,758) (2,265,951) (1,875,373) (140,000) Page 39 GENERAL FUND NOTE RECEIVABLE - TROPHY CLUB (Ambulance) Payment Beginning Total Ending Date Balance Payment Principal Interest Balance 06/01/01 $ 125,000 $ 20,731 $ 12,294 $ 8,438 $ 112,707 06/01/02 112,707 20,731 13,123 7,608 99,583 06/01/03 99,583 20,731 14,009 6,722 85,574 06/01/04 85,574 20,731 14,955 5,776 70,619 06/01/05 70,619 20,731 15,964 4,767 54,655 06/01/06 54,655 20,731 17,042 3,689 37,613 06/01/07 37,613 20,731 18,192 2,539 19,421 06/01/08 19,421 20,732 19,421 1,311 0 $ 165,849 $ 125,000 $ 40,849 Page 40 UTILITY FUND Program Summary Utility Fund Actual FY 02103 Adopted FY 03/04 Amended FY 03104 Adopted FY 04105 Beginning Balance 29,876 0 410,388 323,972 Auditor's Correction 76,626 - - - Adjustments (1,971) - - 25,000 Corrected Beginning Balance (Cash) 104,531 - 410,388 323,972 Balance Sheet Affect to Cash ** 581,812 - - - Revenue 929,951 977,850 1,335,020 1,600,256 Transfers In - 126,584 - - Expenses (Net of Amortization & Depreciation) 1,205,906 909,163 1,294,852 1,182,462 Transfers Out 37,529 10,000 Net Operating Balance 410,388 157,742 450,556 731,766 Capital Project. Expenses - 126,584 126,584 262,500 Ending Balance 410,388 31,158 323,972 469,266 # Days Operating 124 13 91 145 Utility Fund - Transfers In Actual Adopted Amended Adopted FY 02103 FY 03104 FY 03104 FY 04105 4A - - - 4B 126,584 - Total Transfers In 126,584 Utility Fund - Transfers Out Actual Adopted Amended FY 02103 FY 03104 FY 03104 Adopted FY 04105 Transfer to Permanent Capital Maint. Fund - - - 10,000 Repayment of W L/Keller OH Storage - 37,529 - Duct Bank Total Transfers Out 37,529 10,000 Utility Fund - Capital Projects Actual Adopted FY 02103 FY 03104 Amended FY 03104 Adopted FY 04105 Knox Road Connection - 126,584 126,584 - Duct Bank - - - 65,000 Keller Waterline - - - 25,000 Online Meter Platform - - - 25,000 SCADA System - - 20,000 Southlake N1 Sewer Line Improvement - - - 97,500 Water Meter Retrofit - - - 30,a00 Total Capital Projects 1.26,584 126,584 262,500 ** Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in current year revenues and expenditures, i.e. payables and receivables posted to current year's books but cash is not paid nor received until the subsequent year. Also included are inter -fund loans not yet paid or received nor received until the subsequent year. Also included are inter -fund loans not yet paid or received. Page 41 UTILITY FUND - Fund 500 Fiscal Year 2004/2005 REVENUES 34410 16 Adopted Amended Adopted Actual Budget Budget 1 Budget FY 02103 FY 03104 FY 03104 FY 04105 REVENUES 34410 16 Water Revenue 731,719 691,000 880,068 1,090,281 34420 16 Sewer Revenue 146,778 150,000 200,000 195,000 34430 16 Water Tap Fees 8,335 7,500 23,000 64,925 1 34440 16 Sewer Tap Fees 1,350 1,250 2,400 19,875 34450 16 Ft. Worth Impact Fees 26,170 21,000 43,000 56,975 34460 16 Water - Reconnect Fees 0 100 100 100 i 36110 16 Interest Earned 0 0 3,000 3,000 36200 39400 16 16 Duct Bank Leases Misc Income 6,349 9,250 107,000 0 183,452 0 170,100 0 TOTAL REVENUESI 929,951 1 977,850 1 1,335,020 1,600,256 EXPENSES 41110 11 1 GF Admin Salaries @ 15% 16,286 42,590 42,590 34,888 42110 11 1 Medical/Dental Insurance 15% 1,533 2,841 5,500 5,029 42130 11 1 LTD, AD&D, Life 15% 0 0 300 468 42210 11 1 Social Security 15% 1,010 2,641 2,641 2,163 42220 11 1 Medicare 15% 216 618 618 506 42310 11 1 TMRS 15% 2,827 3,620 3,620 2,453 42510 11 1 Unemployment Taxes 15% 236 34 124 176 42610 11 1 Worker's Compensation 15% 0 931 170 150 Administrative Payroll & Relatedl 22,108 1 53,275 1 55,563 145,831 41110 16 1 Public Works Salaries 0 17,500 17,500 36,250 I 42110 16 1 Medical/Dental Insurance 0 6,144 6,144 15,558 42130 16 1 LTD, AD&D, Life 0 0 350 349 42210 16 1 Social Security 0 1,105 1,105 2,248 42220 16 1 Medicare 0 254 254 526 42310 16 1 TMRS 0 1,488 1,488 2,548 42510 16 1 Unemployment Taxes 0 0 109 228 42610 i 16 1 Worker's Compensation 0 _ 350 1,064 2,974 Public Works Payroll & Related 0 26,841 28,014 60,680 44130 } 44210 16 2 16 2 Meter Purchases Facility Supplies 7,429 0 5,000 0 15,000 0 0 100 46105 16 2 Office Supplies 158 50 200 600 46120 16 2 Postage & Supplies 0 0 600 1,550 46190 16 2 Misc Expense 0 0 0 46605 16 2 Uniforms 0 0 0 780 47420 16 2 Water Meters 1,280 1,000 0 30,000 new 16 2 Misc Hand Tools 0 0 0 1,500 i new 16 2 Safety Equipment 0 0 0 250 new 16 2 Paint & Flags 0 0 0 200 new 16 2 Photo Supplies 0 0 0 50 new new 16 2 16 2 Chemicals Misc Hand Tools 0 0 0 0 0 0 100 200 Page 42 UTILITY FUND - Fund 500 Fiscal Year 2004/2005 43205 11 4 Admin Expense @ 15% Actual FY 02103 Adopted Budget FY 03104 Amended Budget 1 FY 03104 Adopted Budget FY 04105 43220 16 4 Water Utility Engineer 34,458 30,000 30,000 50,000 43230 16 4 Suppliesi 8,868 1 6,050 1 15,800 1 35,330 44115 16 3 TRA Wastewater Treatment 81,217 90,000 90,000 90,000 44120 16 3 Southlake I TRA Maintenance 0 90,000 90,000 30,000 44125 16 3 Southlake N1 Sewer Line 162,819 0 253,275 0 44311 16 3 Water & Sewer Maintenance 435 5,000 12,000 0 46215 16 3 Vehicle Fuel & Maintenance 0 1,500 1,500 1,500 new 16 3 Inflow & Infiltration Study 0 0 25,385 0 new 16 3 Lift Station Maintenance 0 0 0 1,950 new 16 3 Generator Maintenance 0 0 0 1,500 new 16 3 Water Main Maintenance 0 0 0 5,000 new 16 3 Water Tower Landscape Maintenanc( 0 0 0 6,000 new 16 3 Tower Maintenance 0 0 0 2,000 new 16 3 Sewer Main Maintenanace 0 0 0 5,000 new 16 3 Pump Station Landscape Maintenans 0 0 0 1,500 new 16 3 Bacterial Testing 0 0 0 300 new 16 3 Instrument Repairs & Maintenance 0 0 0 500 new 16 3 Ground Storage Tank Maintenance 0 0 0 2,000 new 16 3 Maintenance Expense - Other 16,385 0 0 0 Maintenance 260,856 186,500 472,160 147,250 43205 11 4 Admin Expense @ 15% 20,000 23,625 23,625 28,245 43220 16 4 Water Utility Engineer 34,458 30,000 30,000 50,000 43230 16 4 Misc Engineering 60,123 0 0 0 43245 16 4 Financial Consultant 0 5,000 5,000 5,000 43250 16 4 Auditor @ 15% 4,000 5,250 5,250 4,050 43310 16 4 Boyle & Lowry 21,975 30,000 30,000 30,000 43320 16 4 Lloyd, Gosselink 0 2,500 1,000 1,000 44105 16 4 Water Purchases 259,815 150,000 213,000 360,000 44110 16 4 Peak Payment 0 130,000 130,000 120,000 44135 16 4 Meter Reading 1 Billing 0 10,800 10,800 0 44140 16 4 AquaSource 46,800 36,000 36,000 0 44410 16 4 Office Rent 10,725 2,209 1,300 0 45225 16 4 Insurance - R&PPIAutomobile 0 15,549 15,549 5,503 45310 16 4 Mobile Phone 366 840 840 1,110 45315 16 4 Internet Expense 200 285 285 0 45320 16 4 Telephone Lease 346 54 921 0 45830 16 4 Training, Seminars, Meetings 0 0 0 680 46115 16 4 Dues & Subscriptions 0 0 0 420 46125 46135 16 4 16 4 Printing Bank Charges 0 90 0 150 0 50 100 0 new 16 4 Software Maintenance 0 0 0 2,000 new 16 4 UB Printing 0 0 0 100 new 16 4 UB Processing 0 0 0 1,800 Services 458,897 442,262 503,620 610,008 Page 43 UTILITY FUND - Fund 500 Fiscal Year 200412005 46110 43405 Adopted Amended Adopted Actual Budget Budget Budget FY 02103 FY 03104 FY 03104 FY 04105 46110 43405 16 2 16 2 Office Equipment Computer Equipment 698 0 1,000 0 250 0 100 0 Equipmenti 698 1 1,000 1 250 1100 45305 16 6 Telephone - Town 15% 1,800 780 1,600 1,530 46205 16 6 Utilities - Town Water 15% 0 0 2,100 1,498 46220 16 6 Utilities - Town Electric 15% 0 0 7,725 3,802 46220 16 6 Electricy (pump station) 15,795 17,000 17,000 17,979 46225 16 6 Utilities - Town Gas 15% 0 0 3,491 1,326 Utilitiesi 17,595 1 17,780 1 31,916 126,135 48810 16 9 WL/Keller Overhead Storage Pymt 0 120,429 120,429 119,451 48820 16 9 Fullwood Infrastructure Repayment 0 25,000 37,000 60,480 48830 16 9 TRA (Principal) 0 28,331 28,396 0 48831 16 9 TRA Interest Expense 3,408 1,695 1,704 0 48801 16 9 Interfund Advance Debt Pymt to Gen( 0 0 0 4,403 48801 16 9 Interfund Advance Debt Pymt to Gen( 0 0 0 23,750 48806 16 9 Interfund Advance Debt Pymt to 4B 0 0 0 35,543 x 16 9 Keller Overhead Interest Expense_ 75,569 0 0 0 x 16 9 Keller Interest Expense 2,217 0 0 0 x 16 9 Hillwood Interest Expense 355,691 0 0 0 Debt Payment 436,885 175,455 187,529 243,627 Utility Trailer Vehicle Purchase - Public Works (601 0 0 0 0 0 0 1,500 12,000 Capitall 0 1 0 1 0 1 13,500 TOTAL EXPENSES 1,2057906 909,163 1,294,852 1,182,462 Revenue 929,951 977,850 1,335,020 1,600,256 Expenses 1,205,906 909,163 1,294,852 1,182,462 Page 44 UTILITY FUND - Fund 500 Fiscal Year 2004/2005 Page 45 Actual FY 02/03 Adopted Budget FY 03104 Amended Budget FY 03104 Adopted Budget FY 04105 CAPITAL PROJECTS Knox Road Connection 0 126,584 126,584 0 Duct Bank 0 0 0 65,000 Keller Waterline 0 0 0 25,000 Online Meter Platform 0 0 0 25,000 SCADA System 0 0 0 20,000 TRA/ Southlake Sewer 0 0 0 97,500 Water Meter Retrofit 0 0 0 30,000 CAPITAL PROJECTS1 0 1 126,584 1 126,584 1 262,500 TRANSFERS Transfer in 4A - Duct Bank 0 0 0 0 Transfer in 4B 0 126,584 0 0 TRANSFERS IN - OTHER FINANCING SOURCESI 01 126,584 1 0 0 WL/Keller Overhead Storage Pymt 0 37,529 0 0 ermanent Capital Maintenance Fund 600 T 0 0 0 10,000 TRANSFERS OUT - OTHER FINANCING USESI 01 37,529 1 01 10,000 SUMMARY Projected Ending Fund Balance 104,531 0 410,388 323,972 Balance Sheet Affect to Cash 581,812 0 0 0 Total Revenue 929,951 977,850 1,335,020 1,600,256 Total Operating Expenses (1,205,906) (909,163) (1,294,852) (1,182,462) Total Capital Project Expenses 0 (126,584) (126,584) (262,500) Transfers In Transfers Out 0 0 126,584 (37,529) 0 0 0 (10,000) SUMMARYI 410,388 1 31,158 1 323,972 1 469,266 Page 45 UTILITY FUND Repayment Schedule to General Fund page 46 Balance Due to Description General Fund Schedule Annual Payment 377 Water Line $ 4,895.00 15 years $ 326.33 Extension of Water Mains $ 57,600.00 15 years $ 3,840.00 Sewer Line "A" $ 1,515.00 15 years $ 101.00 GW Farms Waterline $ 2,033.00 15 years $ 135.53 Peak Payment $ 95,000.00 4 years $ 23,750.00 $ 161,043.00 $ 28,152.87 page 46 Description UTILITY FUND Repayment Schedule to 4B Fund Balance Due to 4B Fund Schedule Annual Payment Glenwyck Farms Waterline $ 119,622.00 15 years $ 7,974.80 Knox Road Connection $ 413,529.52 15 years $ 27,568.63 $ 533,151.52 $ 35,543.43 Page 47 UTILITY FUND Overhead Storage Payment Pymt TOTAL PAYABLE WESTLAKE'S PORTION OF PAYABLE 32% Date Principal Interest Total Payable Principal Interest Total Balance 09!30101 $ 100,000 $ 271,012 $ 371,012 $ 118,887 $ 32,040 $ 86,847 $ 118,887 $ 1,433,959 09/30/02 130,000 243,450 373,450 119,668 41,657 78,012 119,668 1,,392,302 09/30/03 140,000 235,823 375,823 120,429 44,860 75,569 120,429 1,347,443 09/30104 145,000 227,771 372,771 119,451 46,466 72,984 119,451 1,300,976 09/30105 155,000 219,296 374,296 119,939 49,667 70,273 119,939 1,251,309 09/30106 165,000 210,256 375,256 120,247 52,873 67,374 120,247 1,198,437 09/30107 175,000 200,651 375,651 120,374 56,082 64,292 120,374 1,142,355 09/30108 185,000 189,695 374,695 120,067 59,277 60,790 120,067 1,083,078 09130/09 200,000 177,183 377,183 120,864 64,082 56,782 120,864 1,018,995 09/30/10 210,000 165,433 375,433 120,304 67,298 53,006 120,304 951,697 09130111 225,000 154,558 379,558 121,625 72,100 49,526 121,625 879,598 09/30112 235,000 142,940 377,940 121,107 75,304 45,803 121,107 804,293 09/30/13 250,000 130,448 380,448 121,911 80,107 41,803 121,911 724,186 09/30/14 270,000 116,793 386,793 123,944 86,513 37,431 123,944 637,673 09130!15 285,000 102,014 387,014 124,015 91,324 32,690 124,015 546,349 09/30/16 300,000 86,290 386,290 123,783 96,130 27,653 123,783 450,219 09/30/17 320,000 69,390 389,390 124,776 102,541 22,235 124,776 347,678 09/30/18 340,000 51,155 391,155 125,342 108,947 16,395 125,342 238,731 09/30/19 360,000 31,640 391,640 125,497 115,357 10,140 125,497 123,374 09/30/20 385,000 10,780 395,780 126,824 123,374 3,450 126,824 (0) $ 4,575,000 $ 3,036,576 $ 7,611,576 $ 2,439,053 $ 1,465,999 $ 973,054 $ 2,439,053 Page 48 VISITOR'S ASSOCIATION FUND Program Summary Visitors Fund Actual FY 02103 Adopted FY 03/04 Amended FY 03104 Adopted FY 04105 Beginning Balance 567,136 611_,409 571,058 665,387 Balance Sheet Affect to Cash ` (21,550) Civic Campus 225,000 - Revenues 381,867 359,000 335,500 427,328 Transfers In _ _ - _ Expenditures 131,395 98,973 212,654 437,815 Transfers Out 225,000 153,000 28,517 - Ending Balance 571,058 718,436 665,387 654,900 Actual Adopted Amended Adopted Visitors Fund - Transfers In FY 02103 FY 03/04 FY 03104 FY 04105 Capital Projects Total Transfers In Visitors Fund - Transfers Out Actual FY 02103 Adopted FY 03104 Amended Adopted FY 03104 FY 04105 Capital Projects - Civic Campus 225,000 - Paint Retaining Wall at WL Pkwy & Hwy114 - 18,000 - - Westlake Restoration Project - 25,000 - - Entryway Improvements at Dove & Randol Mill - 10,000 28,517 Blacksmith & Forge Statue - 100,000 - Total Transfers Out 225,000 153,000 1 28,517 Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in current year revenue and expenditures, i.e. payables and receivable posted to the current year's books but cash is not paid nor received until the subsequent year as well as inter -fund loans not yet paid or received. Page 49 Visitor's Association Fund - Fund 220 Fiscal Year 200412005 Actual FY 02103 Adopted Amended Adopted Budget Budget Budget FY 03104 FY 03104 FY 04/05 31320 11 0 Hotel Occupancy Tax 373,216 350,000 325,000 414,000 34142 11 0 Historical Board Subs/Contrib 0 4,000 5,000 6,000 36110 11 0 Interest Income 8,651 5,000 5,500 7,328 TOTAL REVENUES 381,867 359,000 335,500 427,328 EXPENDITURES 41110 11 1 Salaries 18,100 15,045 36,583 109,888 42110 11 1 Medical/Dental Insurance 4,727 1,410 4,640 14,942 42130 11 1 LTD, AD&D, Life 0 0 0 2,180 42210 11 1 Social Security 1,638 963 2,268 6,813 42220 42310 42510 11 11 11 1 1 1 Medicare TMRS Unemployment Taxes 0 1,683 0 218 1,279 465 531 3,069 147 1,593 7,725 331 42610 11 1 Worker's Compensation 0 0 0 372 Payroll & Relatedi 26,148 1 19,380 1 47,238 1 143,844 46105 46120 11 11 2 2 Office Supplies Postage 0 0 0 0 500 200 500 1,200 46190 11 2 Misc Expense 1,610 0 0 0 Suppliesi 1,6101 01 700 1 1,700 43205 43250 11 11 4 4 Admin Expense @ 15% _ Auditor 37,500 0 23,625 2,450 25,125 2,775 28,245 4,050 43310 11 4 Legal 11,250 5,000 7,000 5,000 43410 11 4 Computer Service 0 500 500 500 43505 11 4 Historical Board Expense 0 4,000 8,000 6,000 43515 11 4 Community Service 0 0 6,182 6,200 43517 11 4 Tree City USA 0 0 0 2,500 43525 11 4 CVB Membership 750 750 750 750 43530 11 4 Marriott Marketing 16,755 28,000 65,000 200,000 43531 11 4 Marketing & Promotions 0 8,500 13,000 8,500 43532 11 4 TML Expense 0 0 4,600 0 44410 11 4 Office Rent 10,068 2,209 1,696 0 45310 11 4 Mobile Phone 636 750 750 870 45315 11 4 Internet Expense 228 713 250 0 45320 11 4 Telephone Lease 865 146 2,379 0 45830 11 4 Training, Seminars, Meetings 0 0 600 2,500 46115 11 4 Dues & Subscriptions 0 0 1,500 2,500 46125 11 4 Printing 0 0 500 2,000 46140 11 4 Moving Expense Westlake Logo Website Development 0 7,290 14,500 0 0 0 3,793 0 0 0 0 14,000 Page 50 Visitor's Association Fund - Fund 220 Fiscal Year 200412005 Adopted Actual Budget FY 02103 1 FY 03/04 Amended Adopted Budget Budget FY 03104 FY 04105 43405 11 5 Computer Eqpt/Software 504 1,000 2,000 500 Equipmenti 504 1 1,000 1 2,000 1 500 45305 11 6 Telephone Expense 15% 3,290 1,950 5,000 1,530 46205 11 6 Utilities -Water 15% 0 0 2,100 1,498 46220 11 6 Utilities - Electric 15% 0 0 7,725 3,802 46225 11 6 Utilities -Gas 15% 0 _ 0 3,491 1,326 18,000 0 0 Utilities 3,290 1,950 18,316 8,156 Page 51 TOTAL EXPENDITURES1 131,395 1 98,973 1 212,654 1437,$15 - _ -- Revenue 381,867 359,000 335,500 427,328 Expenditures 131,395 98,973 212,654 437,815 NETI 250,472 1 260,027 1 122,846 1(10,487) TRANSFERS Transfer Out to Civic Campus 225,000 0 0 0 int Retaining Walls at WL Pkwy & SH114 0 18,000 0 0 Westlake Restoration Project 0 25,000 0 0 Entryways at Dove Rd & Randol Mill Blacksmith & Forge Statue 0 0 10,000 100,000 28,517 0 0 0 TRANSFERS OUTI 225,000 1 153,000 1 28,517 0 SUMMARY Projected Ending Fund Balance 567,136 611,409 571,058 665,387 Balance Sheet Affect to Cash (21,550) 0 0 0 Total Revenue 381,867 359,000 335,500 427,328 Total Expenditures (131,395) (98,973) (212,654) (437,815) Transfers Out (225,000) (153.000) (28.517) 0 Page 51 4A CORPORATION Program Summary 4A Corporation Actual FY 02103 Adopted FY 03104 Amended FY 03104 Adopted FY 04105 Beginning Balance 1,212,680 938,101 860,405 493,208 Balance Sheet Affect to Cash ** 1,304,015 - - Revenues 612,453 238,336 547,200 653,200 Expenditures 277,987 - 353,082 35,760 Transfers Out 1,990,756 1,176,437 561,315 945,687 Ending Balance 860,405 - 493,208 164,961 4A Corporation - Transfers Out Actual FY 02103 Adopted FY 03104 Amended FY 03104 Adopted FY 04105 General Fund - - Dissolution of 4A 1,176,437 Capital Projects FM 1938 Engineering -WL Portion of Unnamed - - 36,857 FM 1938 Engineering - WL Portion - - 82,174 56,667 Duct Bank Infrastructure 1,990,756 - - - SH 114 Commerical Growth - - 889,020 4B Funds Duct Bank (transferred from 4B - SIB 4A) - 442,284 - Total Transfers Out 1,990,756 1,176,437 561,395 945,687 ** Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in current year revenues and expenditures, i.e. payables and receivables posted to current year's books but cash is not paid nor received until the subsequent year. Also included are inter -fund loans not yet paid or received. Page 52 4A CORPORATION - Fund 230 Fiscal Year 200412005 Adopted Amended Adopted Actual Budget Budget Budget FY 02103 1 FY 03104 FY 03104 FY 04/05 REVENUE 31310 00 Sales Tax Revenue 596,500 233,336 540,000 650,000 36110 00 Interest Income 15,953 5,000 7,200 3,200 TOTAL REVENUES 612,453 238,336 547,200 653,200 EXPENDITURES 47901 00 114 Bridge Enhancements 0 0 0 0 43310 00 Boyle & Lowry Legal 0 0 0 0 47902 00 FM1938Interchange 39,809 0 216,897 0 47903 00 FM 1938 (114 to 1749) 0 0 0 0 47904 00 114 Commercial Growth 61,352 0 136,185 0 0 00 Fidelity Tax Reimbursement 110,000 0 0 35,760 0 00 Bridge Enhancements 571 0 0 0 0 00 Ottinger/Dove Rd Intersection Rebuilt 802 0 0 0 0 0 00 00 Westlake Academy Foundation Loan Telecommunications Conduit 25,000 40,453 0 0 0 0 0 0 TOTAL EXPENDITURES1 277,987 1 0 1 353,082 135,760 NETI 334,466 1 238,336 1 194,118 1 617,440 TRANSFERS 62509 FM 1938 Engineering (WL Portion) 0 0 36,857 0 62509 FM 1938 Engineering (WL Portion) 0 0 82,174 56,667 Duct Bank Infrastructure 1,990,756 0 0 0 General Fund - Dissolution of 4A 0 1,176,437 0 0 Duct Bank inadvertently transferred from 4B/slb 4A 0 0 442.284 0 Transfer to Capital Project Fund 410 SHII 14 Commercial Growth 0 0 0 889,020 TRANSFERS OUTI 1,990,756 1 1,176,437 1 561,315 1945,687 SUMMARY Projected Ending Fund Balance 1,212,680 938,101 860,405 493,208 Balance Sheet Affect to Cash 1,304,015 0 0 0 Total Revenue 612,453 238,336 547,200 653,200 Total Expenditures (277,987) 0 (353,082) (35,760) Transfers but (1,990,756) (1,176,437) (561,315) (945,687) SUMMARYI 860,405 1 0 1 493,208 1 164,961 Page 53 4A CORPORATION FUND Fidelity Tax Reimbursement Payment Annual Date Payment 9/30/2003 $ 107,274.72 9130/2004 ' 9/30/2005 35,758.24 9/30/2006 35,758.24 9/30/2007 35,758.24 9/30/2008 35,758.24 9/3012009 35,758.24 9/30/2010 35,758.24 9/30/2011 35,758.24 9/30/2012 35,758.24 9/3012013 35,758.24 9/30/2014 35,758.24 9/30/2015 35,758.24 9/30/2016 35,758.24 Total $ 536,373.60 * * FY 02103 Payment included FY 01102, FY 02103, and FY 03104 Page 54 413 CORPORATION Program Summary 4113 Corporation Actual FY 02103 Adopted FY 03104 Amended FY 03104 Adotped FY 04105 Beginning Balance 104,830 695,658 607,313 347,062 Balance Sheet Affect to Cash *' 1,063,577 4A Repayment - 1,027,804 Revenues 600,819 359,000 543,800 688,042 Transfers In Civic Campus 581,431 442,284 Repayment for Civic Campus Site Expenditures 6,000 150,000 150,000 442,284 Transfers Out 1,155,912 742,080 1,096,335 1,027,804 Ending Balance 607,313 744,009 347,062 7,300 413 Corporation -Transfers In Actual Adopted FY 02103 FY 03104 Amended Adopted FY 03104 FY 04105 Amended FY 03104 Adopted FY 04105 WL/Keller Overhead Storage Tank Repayment 37,259 Debt Service for Civic Campus - 4A Repayment 742,080 1,027,804 Duct Bank (transferred from 4B - SIB 4A) - 442,284 - 354,255 - 7otal Transfers Out Civic Campus 742,080 1,096,335 Repayment for Civic Campus Site 544,172 Total Transfers In - 581,431 442,284 4B Corporation - Transfers Out Actual FY 02103 Adopted FY 03104 Amended FY 03104 Adopted FY 04105 Debt Service for Civic Campus - 742,080 742,080 1,027,804 Civic Campus 1,155,912 - 354,255 - 7otal Transfers Out 1,155,912 742,080 1,096,335 1,027,804 ** Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in current year revenues and expenditures, i.e. payables and receivables posted to current year's books but cash is not paid nor received until the subsequent year. Also included are inter -fund loans not yet paid or received. Page 55 413 CORPORATION - FUND 200 Fiscal Year 2004/2005 Adapted Amended Adopted Actual Budget Budget Budget FY 02103 1 FY 03104 FY 03104 FY 04105 REVENUES 31310 00 Sales Tax Revenue 597,074 350,000 540,000 650,000 36110 00 Interest Income 3,745 9,000 3,800 2,500 38805 00 Interfund Advance - Debt Receipt frorr 0 0 0 35,543 TOTAL REVENUESI 600,819 1 359,000 1 543,800 1 688,042 EXPENDITURES 44312 00 Interest Expense 0 0 0 0 47900 00 Park & Open Space Planning 2,000 0 0 0 47901 00 Ottinger Road Overlay 0 150,000 150,000 0 X 00 Master Thoroughfare Update 2,000 0 0 0 X 00 Permanent DPS Facility 2,000 0 0 0 Projected Ending Fund Balance 104,830 TOTAL EXPENDITURES1 6,000 1 150,000 1 150,000 1 0 NET TOTAL 1 594,819 1 209,000 1 393,800 1 688,042 TRANSFERS WLIKeller Overhead Storage Tank Repayment 0 37,259 0 0 Duct Bank (transferred from 4B - SIB 4A) Repayment for Civic Campus site 0 0 0 544,172 442,284 0 0 0 TRANSFERS IN -OTHER FINANCING SOURCES 01 581,431 1 442,2841 0 Debt Service for Civic Campus 0 742,080 742,080 1,027,804 Civic Campus 1,155,912 0 354,255 0 TRANSFERS OUT -OTHER FINANCING USES 1,155,912 742,080 1,096,336 1,027,804 SUMMARY Projected Ending Fund Balance 104,830 695,658 607,314 347,062 Balance Sheet Affect to Cash 1,063,577 0 0 0 Total Revenues 600,819 359,000 543,800 688,042 Total Expenditures (6,000) (150,000) (150,000) 0 Transfers In 0 581,431 442,284 0 Transfers Out (1,155,912) (742,080) (1,096,336) (1,027,804) Page 56 DEBT SERVICE FUND Program Summary Debt Service Actual Adopted Amended Adopted FY 02103 FY 03104 FY 03104 FY 04105 Beginning Balance - - - Revenues - - - - Transfers In - 1,027,804 Expenditures - - - 1,027,804 Ending Balance - Debt Service - Transfers in Actual Adopted Amended Adopted FY 02103 FY 03104 FY 03104 FY 04105 4B Debt Service - 2002 series - - - 742,080 Debt Service - 2003 series - - - 285,724 Total Transfers In - 1,027,804 Page 57 DEBT SERVICE FUND - Fund 300 Fiscal Year 2004/2005 REVENUES Actual FY 02103 Adopted Budget I FY 03104 Amended Budget FY 03104 Adapted Budget FY 04105 0 2003 Series Interest Earned 0 2002 Series Interest Earned 0 0 0 0 2003 Series Interest Earned 0 0 0 0 TOTAL REVENUESI 0 1 0 1 0 10 0 EXPENDITURES 48840 2002 Series Principal 0 0 0 0 48850 2002 Series Interest 0 0 0 742,080 48840 2003 Series Principal 0 0 0 0 48850 2003 Series Interest 0 0 0 285,724 TOTAL EXPENDITURES1 0 1 0 1 0 1 1,027,804 NETI 0 01 0 1(1,027,804) TRANSFERS Debt Service - 2002 Series (4 Debt Service - 2003 Series (4 SUMMARY 0 0 I 2 0 742,080 0 285,724 Total Revenue 0 0 0 0 Total Expenditures 0 0 0 (1,027,804) Transfers In 0 0 0 1,027,804 SUMMARYI 0 1 0 1 0 1 0 Page 58 The Town of Westlake Certificates of Obligation (1st Series) 2002 Series Sources & Uses Sources Principal Amount of Certificates 12,400,000.00 Cash Premium 97.10 Total Sources of Funds $ 127400,097.10 Uses Available for Improvements Capitalized Interest Cost of Issuance Interest and Sinking Fund Total Sources of Funds Page 59 11,325,589.66 919,363.77 155,046.57 97.10 $ 12,400,097.10 DEBT SERVICE FUND 2002 SERIES BOND AMORTIZATION SCHEDULE Payment Principal Interest Total 09/30/03 09/30/04 09/30/05 09/30/06 09/30/07 09/30/08 09/30/09 09/30/10 09/30/11 09/30/12 09/30/13 09/30/14 09/30/15 09/30/16 09130/17 09/30/18 09/30/19 09/30/20 09/30/21 09/30/22 09/30/23 09/30/24 09/30/25 09/30/26 09/30/27 09/30/28 09/30/29 09/30/30 09/30/31 09/30/32 0 0 210,000 225,000 235,000 250,000 265,000 280,000 295,000 315,000 330,000 350,000 365,000 385,000 405,000 425,000 445,000 470,000 495,000 520,000 550,000 580,000 610,000 640,000 675,000 710,000 750,000 790,000 830,000 $ 12,400,000 Five year disclosure for report purposes 2005 $ - 2006 210,000 2007 225,000 2008 235,000 2009 250,000 Thereafter 11,480,000 $ 12,400,000 $ 927,600 742,080 742,080 742,080 728,430 713,805 698,530 682,280 665,055 646,855 627,680 607,205 585,755 563,005 539,280 514,255 490,968 466,530 440,943 413,918 385,455 355,555 323,930 290,290 254,910 217,790 178,640 137,460 93,960 48,140 $ 14,824,464 $ 742,080 742,080 728,430 713,805 698,530 9,529,859 $ 13,154,784 Page 60 $ 927,600 742,080 742,080 952,080 953,430 948,805 948,530 947,280 945,055 941,855 942,680 937,205 935,755 928,005 924,280 919,255 915,968 911,530 910,943 908,918 905,455 905,555 903,930 900,290 894,910 892,790 888,640 887,460 883,960 878,140 $ 27,224,464 $ 742,080 952,080 953,430 948,805 948,530 21,009,859 $ 25,554,784 The Town of Westlake Certificates of Obligation (2nd Series) 2003 Series Sources & Uses Sources Par Value 6,410,000.00 Accrued Interest 17,460.00 Total Sources of Funds $ 6,427,460.00 Uses Deposit to Debt Service Fund 17,460.00 Deposit to Construction Fund 5,900,000.00 Original Issue Discount 58,387.50 Cost of Issuance 322,000.00 Rounding 1,409.90 Underwriter's Discount 128,202.60 Total Sources of Funds $ 6,427,460.00 Page 61 DEBT SERVICE FUND 2003 SERIES BOND AMORTIZATION SCHEDULE Payment Principal Interest Total 09/30/05 09/30/06 09/30/07 09/29/08 09/29/09 09/29/10 09/29/11 09/28/12 09/28/13 09/28/14 09/28/15 09/27/16 09/27/17 09/27/18 09/27/19 09126/20 09/26/21 09/26/22 09/26/23 09/25124 09/25/25 09/25/26 09/25/27 09/24/28 09/24/29 09/24/30 09/24/31 09/23/32 140,000 145,000 145,000 150,000 155,000 160,000 165,000 170,000 175,000 185,000 190,000 200,000 210,000 220,000 230,000 240,000 250,000 260,000 275,000 290,000 300,000 315,000 335,000 350,000 365,000 385,000 405,000 $ 6,410,000 Five year disclosure for report purposes 2005 $ - 2006 140,000 2007 145,000 2008 145,000 2009 150,000 Thereafter 5,830,000 $ 6,410,000 $ 285,724 285,724 282,924 279,444 275,529 271,029 265,914 260,314 254,291 248,001 241,220 233,820 225,840 217,240 208,000 197,550 186,625 175,225 163,350 151,000 137,250 122,750 1.07,750 92,000 75,750 57,750 39,500 20,250 $ 5,361,764 285,724 285,724 282,924 279,444 275,529 3,952,419 $ 5,361,764 Page 62 285,724 425,724 427,924 424,444 425,529 426,029 425,914 425,314 424,291 423,001 426,220 423,820 425,840 427,240 428,000 427,550 426,625 425,225 423,350 426,000 427,250 422,750 422,750 427,000 425,750 422,750 424,500 425,250 $ 11,771,764 $ 285,724 425,724 427,924 424,444 425,529 9,782,419 $ 11,771,764 PERMANENT CAPITAL MAINTENANCE FUND Program Summary Permanent Capital Maintenance Fund Actual FY 02/03 Adopted FY 03104 Amended FY 03104 Adopted FY 04105 Beginning Balance 10,000 Revenue - Transfers In 20,000 Expenditures 20,000 Ending Balance PC Maintenance -Transfers In Actual FY 02103 Budgeted FY 03104 Projected FY 03104 Proposed FY 04105 Utility Fend 10,000 General Fund 10,000 Total Transfers In 20,000 Page 63 PERMANENT CAPITAL MAINTENANCE FUND - Fund 600 Fiscal Year 2004/2005 FUNDING SOURCES 52510 00 Transfers in from GF Actual Budget Budget Budget FY 02103 FY 03104 FY 03104 FY 04105 0 0 0 10,000 52550 00 Transfers in from OF 0 0 0 10,000 TOTAL FUNDINGI 0 1 0 10 20,000 FUNDING USES Buildings Total Buildingsi 0 1 0 1 0 10 Streets 10,000 Total Streetsi D 1 0 1 0 1 10,000 Water 5,000 Total Waterl 0 1 D 1 0 19,000 Sewer 5,000 Total Sewerl 0 1 0 1 0 15,000 Vehicles 0 Total Vehicles 0 0 0 0 TOTAL USESI 01 0 1 0 1 20,000 NETI 0 1 0 1 0 10 Page 64 CAPITAL PROJECTS FUND - GOVERNMENTAL Program Summary Capital Projects Fund Actual FY 02103 Adopted FY 03104 Amended FY 03104 Adopted FY 04105 Beginning Balance FM 1938 - Southalke 56,667 FM 1938 -Keller 56,667 Revenue General Fund - Transfers In Civic Campus Expansion 25,000 Dove Road Improvements 1,339,020 Expenditures 1,339,020 Ending Balance 114 Commerical Growth 889,020 FM 1938 - Westlake 56,667 Capital Projects Transfers In Actual Budgeted Amended Proposed FY 02/03 FY 03104 FY 03104 FY 04105 Other Sources FM 1938 - Tarrant County 150,000 FM 1938 - Southalke 56,667 FM 1938 -Keller 56,667 General Fund Cemetery Maintenance 10,000 Civic Campus Expansion 25,000 Dove Road Improvements 95,000 Fund 4A 114 Commerical Growth 889,020 FM 1938 - Westlake 56,667 Total Transfers In 1,335,020 Page 65 CAPITAL PROJECTS FUND - GOVERNMENTAL Fiscal Year 200412005 CAPITAL PROJECT EXPENDITURES OS - FM1938 (114 to 1709) 0 0 0 150,000 OS - FM 1938 (114 to 1709) 0 0 0 56,667 OS - FM1938 (114 to 1709) 0 0 0 56,667 GF - Cemetery Maintenance 0 0 0 10,000 GF - Civic Campus 0 0 0 25,000 GF - Dove Road Improvements 0 0 0 95,000 4A - FM1938 (114 to 1709) Adopted Amended Adopted Actual Budget Budget 1 Budget 1 FY 02103 FY 03104 FY 03104 FY 04105 CAPITAL PROJECT EXPENDITURES OS - FM1938 (114 to 1709) 0 0 0 150,000 OS - FM 1938 (114 to 1709) 0 0 0 56,667 OS - FM1938 (114 to 1709) 0 0 0 56,667 GF - Cemetery Maintenance 0 0 0 10,000 GF - Civic Campus 0 0 0 25,000 GF - Dove Road Improvements 0 0 0 95,000 4A - FM1938 (114 to 1709) 0 0 0 56,667 4A- 114 Commerical Growth 0 0 0 889,020 TOTAL EXPENDITURES 0 1 0 1 © 1 1,339,020 1,339,020 TRANSFERSIN NETI 0 1 52590 1 Transfers in from Other Sources 0 0 0 263,333 52510 2 Transfers in from GF 0 0 0 130,000 52570 3 Transfers in from 4A 0 0 0 945,687 TOTAL TRANSFERS IN 0 0 0 1,339,020 NETI 0 1 0 1 0 0 Page 66 Capital Projects Summary FY 04/05 ADOPTED Project Title Funding Amount Cemetery Maintenance General Fund $ 10,000 Civic Campus Expansion Dove Road Improvements General Fund General Fund 25,000 95,000 25,000 Total General Fund 130,000 FM1938 (114 to 1709) FM1938 (114 to 1709) FM1938 (114 to 1709) Tarrant County Southlake Keller 150,000 56,667 56,667 30,000 Total Other Resources 263,334 114 Commercial Growth FM1938 (114 to 1709) 4A 4A 889,020 56,667 Total 4A Fund 889,020 Duct Bank Extension Utility Fund 65,000 Keller Waterline Acquisition Meter {inline Reading Platform SCADA System Southlake N1 Sewer Line Improvement Water Meter Retrofit Utility Fund 25,000 Utility Fund 25,000 Utility Fund 20,000 Utility Fund 97,500 Utility Fund 30,000 Total Utility Fund 262,500 Total Capital Projects $ 1,544,854 Page 67 CAPITAL PROJECT FY 2004/2005 Cemetery Grounds Maintenance Project Description: Turf maintenance on current open area (04118!04). Mow, edge & trim, use a grass killer 8 inches around head stones. Cost $7500. Removing under brush and trash removal. PROJECT FUNDING IMPACT ON OPERATING PROJECT EXPENSE BUDGET 04105 Planned PROJECT 05!06 06!07 07108 08109 TOTAL Prior Year Remaining Fund 0 0 LTD 09/30104 BUDGET 04!05 I Planned 10,000 PROJECT TOTAL 05!06 06107 07108 0$109 Purchase _ 0 0 0 0 0 0 0 _ 001 0 0 0 0 1 0 0 0 0 0 0 Design Construction Implementation 0 0 0 10,000 0 0 0 0 10,000 Engineering 0 0 0 0 0 0 0 Legal 0 0 0 0 0 0 0 Contingencies 0 1 D 1 01 0 0 0 0 PROJECT EXPENSE TOTAL D 10,000 D 1 0 0 0 10,000 PROJECT FUNDING IMPACT ON OPERATING LTD 09130104 BUDGET 04105 Planned PROJECT 05!06 06!07 07108 08109 TOTAL Prior Year Remaining Fund 0 0 0 0 0 0 0 General Fund 10,000 0 0 0 0 10,000 Utility Fund 0 0 0 0 0 0 0 Visitor Fund 0 0 0 0 0 0 0 0 0 0 0 0 0 4A Loan 0 4B Loan Grants 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 Private 0 0 Certificates of Obligation 0 0 Q I 0 0 0 I 0 PROJECT FUNDING TOTAL 0 1 10,000 0 0 0 0 10,000 NET 1 0 1 D 1 D 1 D 1 D 1 0 D Page 68 IMPACT ON OPERATING BUDGET LTD 09!30!04 BUDGET 041D5 Planned PROJECT TOTAL 05106 06107 07108 08109 Administrative Expenses 0 0! 0 0 0 0 0 Par Expenses 0 0 0 0 0 2,000 0 2,000 0 10,000 0 -sonnet Supplies Maintenance 0 2,000 2,000 2,000 0 0 0 0 0 0 Services 0 0 0_ 0 0 0 0 Equipment Transfer i 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Debt 0 0 0 0 0 0 0 OPERATING IMPACT TOTAL 0 2,000 1 2,000 2,000 2,000 2,000 10,000 Page 68 CAPITAL PROJECT FY 2004/2005 Civic Campus Expansion Project Description: The project is for the planning and design of Phase II of the Civic Campus. The expansion will allow room for the school to spread out once the high school grades are reached as well as provide more ammenities to students. NET 0 1 0 1 0 1 0 1 D 1 0 1 0 IMPACT ON OPERATING BUDGET PROJECT EXPENSE BUDGET 04105 Planned PROJECT TOTAL 05/06 06107 07108 08109 LTD 09130104 LTD 09/30104 BUDGET 04105 0 0 0 Planned PROJECT TOTAL Prior Year Remaining Fund PROJECT TOTAL 05/06 08107 07108 08109 Purchase 0 0 0 0 0 0 0 Design 0 25,000 0 0 0 0 25,000 Construction 0 0 0 0 0 0 0 0 0 0 0 0 Implementation 0 0 Engineering Legal 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 Contingencies 0 1 0 PROJECT EXPENSE TOTAL 0 2520 01 0 0 0 25,000 NET 0 1 0 1 0 1 0 1 D 1 0 1 0 IMPACT ON OPERATING BUDGET PROJECT FUNDING LTD 09/30/04 BUDGET 04105 Planned PROJECT TOTAL 05/06 06107 07108 08109 LTD 09130104 BUDGET 04105 05106 Planned 06107 07108 0 0 0 08!09 PROJECT TOTAL Prior Year Remaining Fund 0 0 0 0 25,000 0 _ 0 0 0 0 0 0 25,000 General Fund Utility Fund 0 0 0 0 0 0 0 Visitor Fund 0 0 0 0 0 0 D 4A Loan 0 0 0 0 0 0 0 4B Loan 0 0 0 0 0 0 0 Grants Private 0 0 0 0 D 1 0 0 0 0 0 0 0 0 0 Certificates of Obligation 0 0 0 0 1 0 0 0 PROJECT FUNDING TOTAL 0 25,000 1 0 1 01 0 0 25,000 NET 0 1 0 1 0 1 0 1 D 1 0 1 0 IMPACT ON OPERATING BUDGET LTD 09/30/04 BUDGET 04105 Planned PROJECT TOTAL 05/06 06107 07108 08109 Administrative Expenses 0 0 0 0 0 0 0 0 0 Personnel Expenses 0 0 0 0 0 0 0 0 0 0 Supplies 0 0 Maintenance 0 0 0 0 0 0 0 Services 0 0 0 0 0 0 0 Equipment 0 0 0 0 0 0 0 Transfer 0 0 0 0 1 0 0 0 Debt 0 0 0 0 1 0 0 0 OPERATING IMPACT TOTAL 1 0 0 0 0 0 0 0 Page 69 CAPITAL PROJECT FY 2004/2005 Dove Road Improvements (between Vaquero & Ottinger) Project Description: Skirting and installion of ditches for Dove Road, from Ottinger to the western side of Vaquero. Parts of the road will also need to be widened to the minimum width of 24 feet. PROJECT EXPENSE PROJECT FUNDING LTD 09130104 BUDGET 04105 Planned PROJECT TOTAL 05!06 06107 07108 08109 Purchase Design 0 0 0 0 0 V 0 0 0_ OI 0 0 0 0 0 Construction 0 90,000 0 0 0 0 90,000 Implementation 0 0 0 0 0 01 0 Engineering 0 5,000 0 0 0 0 5,000 Legal 0 0 0 0 0 0 0 0 0 Contingencies 0 0 0 0 0 PROJECT EXPENSE TOTAL 0 1 95,000 1 0 0 0 0 95,000 NET 1 D 1 D 1 0 1 0 1 D 1 0 I 0 IMPACT ON OPERATING PROJECT FUNDING LTD 09/30/04 BUDGET Planned 08109 PROJECT TOTAL 04105 05106 06107 07108 08109 Prior Year Remaining Fund 0 0 0 O 0 0 Personnel Expenses General Fund 0 95,000 0 0 0 0 0 95,000 Utility Fund 0 0 0 0 0 0 Visitor Fund 4A Loan 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4B Loan 0 0 0 0 O 0 0 Grants 0 0 0 0 0 0 0 0 0 0 0 0 0 Private 0 Certificates of Obligation 0 0 0 0 1 0 0 0 PROJECT FUNDING TOTAL 0 95,000 0 D 0 o7- 95,000 NET 1 D 1 D 1 0 1 0 1 D 1 0 I 0 Page 70 IMPACT ON OPERATING BUDGET LTD BUDGET 09/30104 04105 Planned 05106 06107 07108 08109 PROJECT TOTAL Administrative Expenses 0 0 0 0 0 0 0 Personnel Expenses 0 0 0 0 0 0 0 Supplies 0 0; 0 0 0 0 0 Maintenance 0 0 0 0 0 0 0 Services 0 0 0 0 0 0 0 Equipment 0 0 0 0 0 0 0 Transfer 0 0 0 0 0 0 0 Debt 0 0 0 0 0 0 0 OPERATING IMPACT TOTAL 0 0 0 0 0 0 0 Page 70 CAPITAL PROJECT FY 2004/2005 FM1938 174 to 1709 Project Description; The engineering, design and construction document package with TXDOT review and approval for FM1938 between SH114 in Westlake and FM1709 in Southlake/Keller. Implementation costs for Texas U -Turns at SH1141FM1938 interchange are also included. Westlake portion of costs relative to Southlake and Kellef is 57.11% for FM1938 NET 4,370 4,371 4,371 4,371 4,371 4,371 4,371 IMPACT ON OPERATING BUDGET PROJECT EXPENSE' LTD BUDGET Planned 09/30104 04105 05106 06107 07!08 LTD 09/30/04 BUDGET 04105 05106 Planned 06107 07108 08109 PROJECT TOTAL Purchase 0 0 0 320,000 0 0 0 0 0 0 0 0 1,282,474 Design 1,313,809 962,474 Construction Implemenlation 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Engineering 0 0 0 0 0 0 0 Legal Contingencies 0 0 0 0 0 0 0 0 0 0 0 0 0 0 PROJECT EXPENSE TOTAL 962,474 320,000 0 1 0 0 0 1,282,474 NET 4,370 4,371 4,371 4,371 4,371 4,371 4,371 IMPACT ON OPERATING BUDGET PROJECT FUNDING LTD BUDGET Planned 09/30104 04105 05106 06107 07!08 LTD 09130104 BUDGET 04105 05106 Planned 06107 07108 08109 PROJECT TOTAL Prior Year Remaining Fund 0 4,370 4,371 4,371 4,371 4,371 0 General Fund 36,857 0 0 0 0 0 36,857 Utility Fund Visitor Fund 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4A Loan 82,174 56,667 0 0 0 0 138,841 Q Loan 0 0 0 0 0 0 0 Grants 0 0 0 0 0 0 0 Private Private - Tarrant County 847,813 0 0 150,000 0 0 0 0 0 0 0 0 847,813 150,000 Private - Southlake 0 56,667 0 0 0 0 56,667 Private - Keller Certificates of Obligation 0 0 56,667 0 0 0 0 0 0 0 0 I 0 56,667 0 PROJECT FUNDING TOTAL 966,844 324,371 4,371 4,371 4,371 4,371 1,286,845 NET 4,370 4,371 4,371 4,371 4,371 4,371 4,371 Page 71 IMPACT ON OPERATING BUDGET LTD BUDGET Planned 09/30104 04105 05106 06107 07!08 08109 PROJECT TOTAL Administrative Expenses Personnel Expenses 4,000 0 0 0 0 0 0 0 0 0 0 0 4,000 0 Supplies 0 0 0 0 0 _ 0 0 Maintenance 0 0 0 0 0 0 0 Services 0 0 0 0 0 0 0 Equipment 0 0 0 0 0 0 0 Transfer I 0 0 0 0 0 0 0 Debt 0 0 0 0 0 0' 0 OPERATING IMPACT TOTAL 4,000 01 0 0 0 0 4,000 Page 71 CAPITAL PROJECT FY 2004/2005 SH 114 Commercial Growth Project Description: The development of a major commercial and retail corridor on the northern part of the Circle T Ranch. NET 1 0 1 0 1 4 1 0 1 0 1 D 1 0 10 IMPACT ON OPERATING BUDGET PROJECT EXPENSE 09/30/04 BUDGET 04105 Planned PROJECT TOTAL 05106 06107 TOTAL BUDGET TOTALLTD BUDGET 09/30104 BUDGET 04105 I 05106 Personnel Expenses 0 0 Planned 06107 07108 PROJECT TOTAL 08109 PROJECT TOTAL Admin Expense/Personnel 140,000 70,000 70,000 67,500 0 0 0 0 140,000 Town Attorney Civil Engineer Auditor 95,500 183,315 5,271 28,000 133,315 129,775 0 0 0 0 95,500 50,000 0 0 0 0 183,315 2,571 2,700 0 0 0 0 0 0 0 0 0 5,271 713,820 Third Party Inspection Fees 713,820 15,000 698,820 PROJECT EXPENSE TOTAL 1,137,906 248,886 889,020 0 0 0 0 1,137,906 NET 1 0 1 0 1 4 1 0 1 0 1 D 1 0 10 IMPACT ON OPERATING BUDGET PROJECT FUNDING 09/30/04 BUDGET 04105 Planned PROJECT TOTAL 05106 06107 TOTAL BUDGET LTD 09130/04 BUDGETI 04105 05106 Planned 06107 07108 Personnel Expenses 0 0 08109 PROJECT TOTAL Prior Year Remaining Fund 1 0 01 0 1 0 0 0 0 4A Grant 2003 ` 119,111 119,111 0 _ 0 0 0 119,111 4A Grant 2004 129,775 129,775 0 0 0 0 0 129,775 4A Grant 2005 889,020 0 889,020 0 0 0 0 889,020 I PROJECT FUNDING TOTAL 1,137,906 248,886 889,020 01 01 0 1 0 1 1,137,906 NET 1 0 1 0 1 4 1 0 1 0 1 D 1 0 10 IMPACT ON OPERATING BUDGET TOTALLTD BUDGET 09/30/04 BUDGET 04105 Planned PROJECT TOTAL 05106 06107 07108 08109 Administrative Expenses 0 0 0 0 0I 0 01 0 Personnel Expenses 0 0 0 0 O 0 0 0 OPERATING IMPACT TOTAL D 0 1 0 01 0 1 0 0 0 Page 72 CAPITAL PROJECT FY 2004/2005 Duct Bank Extension Project Description: Duct Bank Extension Project. This project is divided into two phases: Pearson to Vaquero and Pearson to Ottinger. The Duct Bank section to Vaquero will consist of four conduits and will be completed first. The second phase will consist of 6, 4 inch conduits. The cost of the project will depend upon the reconstruction of the Dove Road/Ottinger Intersection. The cost of doing the work before the reconstruction is shown below NET 0 1 0 0 1 0 1 0 1 0 1 0 IMPACT ON OPERATING PROJECT EXPENSE LTD 09130/04 LTD 09130/04 BUDGET I 04105 05106 Planned 06107 07108 08109 08109 PROJECT TOTAL Purchase i 0 0 0 0 0 0 0 Design I 0 0 0 0 0 0 0 Construction 0 65,000 I 0 0 j 0 0 65,000 Implementation (2nd phase) 0 0 0 0 0 0 D Engineering 0 0 0 0 0 0 0 Legal Contingencies 0 0 0 0 D 0 0 0 0 0 0 0 0 j 0 PROJECT EXPENSE TOTAL 0 65,000 0 0 0 0 1 65,000 NET 0 1 0 0 1 0 1 0 1 0 1 0 IMPACT ON OPERATING PROJECT FUNDING LTD 09130/04 LTD 09130/04 BUDGET 04105 05106 Planned 06107 07108 08109 08109 PROJECT TOTAL Prior Year Remaining Fund General Fund Utility Fund 0 0 0 i 0 D 1 0 0 6m,000 0 0 0 0 0 0 0 0 0 0 0 65,000 Visitor Fund 0 0 0 0 0 0 0 4A Loan 0 0 0 0 0 0 0 413 Loan 0 0 0 1 0 0 0 0 0 Grants 0 0 0 0 0 0 0 Private 0 0 0 0 0 0 0 Certificates of Obligation 0 0 0 0 0 0 0 PROJECT FUNDING TOTAL 0 65,000 0 0 0 0 65,000 NET 0 1 0 0 1 0 1 0 1 0 1 0 Page 73 IMPACT ON OPERATING BUDGET LTD 09130/04 BUDGET 04/05 Planned 05106 06!07 07108 08109 PROJECT TOTAL Administrative Expenses Personnel Expenses 0 0 0 0 0 0 j 0 0 0 0 0 0 0 0 0 0 0 0 0 Supplies 0 0 Maintenance 0 0 0 0 0 0 0 Services 0 0 0 0 0 0 0 Equipment 0 0 0 0 0 1 0 0 Transfer 0 0 0 0 0 0 0 Debt 0 0 0 0 0I 0 0 OPERATING IMPACT TOTAL 0 0 0 0 0 0 0 Page 73 CAPITAL PROJECT FY 2444/2445 Keller Waterline Acquisition Project Description: Connecting the waterlines purchased from Keller to the Westlake distribution system. NET 1 0 1 0 1 0 1 0 1 0 1 0 1 0 IMPACT ON 'OPERATING BUDGET PROJECT EXPENSE LTD 09130104 BUDGET Planned 04/05 05106 06107 07108 LTD 09/30104 BUDGET 04105 05/06 Planned 06107 07108 0 08109 PROJECT TOTAL Purchase Design 0 0 0 0 0 0 0 0 0 0 0 0I 0 0 0 j 0 20,000 0 0 20,000 Construction 0 Implementation 0 0 0 5,000 0 0 0 0 0 0 0 0 0 0 0 5,000 Engineering Legal Contingencies 0 0 0 0 0 0 0 0 0_ 0 0 0 0 0 0 PROJECT EXPENSE TOTAL 0 1 25,000 1 0 0 1 0 1 0 25,Oaa NET 1 0 1 0 1 0 1 0 1 0 1 0 1 0 IMPACT ON 'OPERATING BUDGET PROJECT FUNDING LTD 09130104 BUDGET Planned 04/05 05106 06107 07108 LTD 09130104 BUDGET 04/05 PROJECT TOTAL Planned 0 0 0 0 PROJECT TOTAL 05/06 06107 07108 08109 Prior Year Remaining Fund General Fund 0 0 0 0 0 0 0 0 25,000 0 0 0 0 0 0 0 0 0 Utility Fund 0 25,000 Visitor Fund 0 0 0 0 0 0 0 0 0 0 0 0 0 4A Loan 0 413 Loan 0 0 0 0 0 0: 0 Grants 0 0 0 0 0 0 0 0 0 0 0 0 0 Private 0 Certificates of (obligation 0 0' 0 0 0 0 0 PROJECT FUNDING TOTAL 0 25,000 1 0 0 1 0 01 25,000 NET 1 0 1 0 1 0 1 0 1 0 1 0 1 0 Page 74 IMPACT ON 'OPERATING BUDGET LTD 09130104 BUDGET Planned 04/05 05106 06107 07108 08109 PROJECT TOTAL Administrative Expenses 0 0 0 0 0 0 0 Personnel Expenses 0 0 0 0 0 0 0 Supplies 0 0 0 0 0 0 0 Maintenance 0 0 0 0 0 0 0 Services 0 0 0 0 0 0 G Equipment Transfer 0 0 0 0 0 0 0 0 0 0 0 j 0 0; 0 Debt 0• 0 0 0 0 0 7 0 OPERATING IMPACT TOTAL 0 0 0 0 0 0 0 Page 74 CAPITAL PROJECT FY 2004/2005 Meter Online Reading Platform Project Description: Implementation of the online meter reading platform that would allow real-time data collection of water meters located within the Westlake Municipal Complex. Software Development $15,000 and Hardware $10,000. NET 1 0 1 0 1 0 1 0 1 0 1 0 10 IMPACT ON OPERATING PROJECT EXPENSE LTD 09/30/04 LTD 09/30104 BUDGET 04105 05106 Planned PROJECT TOTAL 08109 PROJECT TOTAL 05106 06/07 07108 08109 Purchase 0 0 0 0 0 0 0 Design 0 0 0 j 0 0 0 0 Construction Implementation 0 1 0 0 0 0 _ J 0 0 0 0 0 0 0 25,000 25,000 Engineering Legal 0 j 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Contingencies 0 0. 0 Private 0 0 0 0 PROJECT EXPENSE TOTAL 0 25,000 0 0 0 0 25,000 NET 1 0 1 0 1 0 1 0 1 0 1 0 10 IMPACT ON OPERATING PROJECT FUNDING LTD 09/30/04 LTO 09130104 BUDGET 04105 05106 Planned 06107 07108 PROJECT TOTAL 08109 PROJECT TOTAL Prior Year Remaining Fund 0 0 0 0 0 j 0 0 General Fund 0 0 0 0 0 0 0 Utility Fund Visitor Fund 0 0 25,000 0 0 0 0 25,000 0 0 0 0 0 0 4A Loan 0 0 0 0 0 0 0 4B Loan 0 0 0 0 0 0 0 Grants 0 0 0 0 0 0 0 Private 0 0 0 0 0 0 0 Certificates of Obligation 0 1 0 f 0 0 1 0 4 0 0 PROJECT FUNDING TOTAL 0 25,000 0 0 01 01 25,000 NET 1 0 1 0 1 0 1 0 1 0 1 0 10 Page 75 IMPACT ON OPERATING BUDGET LTD 09/30/04 BUDGET 04105 Planned 05106 06107 07/08 08109 PROJECT TOTAL Administrative Expenses 0 0 0 0 0 0 0 Personnel Expenses 0 0 0 0 0 0 0 Supplies 0 0 0 0 0 0 D Maintenance 0 0 0 0 0 0 i 0 Services 0 0 0' 01 0 0 0 0 0 0 0 0 j 0 0 0 0 0 0 0 0 0 Equipment Transfer Debt 0 0 0 0 0 0 0 OPERATING IMPACT TOTAL 0 0 0 0 1 0 0 10 Page 75 CAPITAL PROJECT FY 200412005 SCADA System Improvements Project Description: The SCADA improvements will allow the automated use of the existing pressure tank in the event that the elevated storage tank is out of service (maintenance or repairs, etc) The tank cannot be used without integrating it into the SCADA system. Costs based on estimate provided by WHECO. NET 1 0 1 0 1 0 1 0 1 0 1 0 1 0 IMPACT ON OPERATING BUDGET PROJECT EXPENSE LTD BUDGET Planned 09/30104 04105 05106 06107 07108 LTD 09/80/04 BUDGET 04105 05106 Planned 06107 07108 O 0 0 0 0 0 0 0 08/09 PROJECT TOTAL Purchase 0 0 0 0 O 0 0 Design 0 0 0 0 0` 0 0 Construction 0 0 0 0 0 0 0 Implementation 0 18,000 0 0 0 0 18,000 Engineering 0 0 0 0 0 0 0 Legal 0 0 0 0 0 0 0 Contingencies 0 1 2,000 0 0 1 0 1 0 2,000 PROJECT EXPENSE TOTAL 0 20,000 1 0 1 0 1 0 1 ol 20,000 NET 1 0 1 0 1 0 1 0 1 0 1 0 1 0 IMPACT ON OPERATING BUDGET PROJECT FUNDING LTD BUDGET Planned 09/30104 04105 05106 06107 07108 LTD BUDGET Planned O 0 0 0 0 0 0 0 0 0 PROJECT 0 0 09130104 04105 05106 06107 07108 0 08109 TOTAL Prior Year Remaining Fund 0 0 0 j 0 0 0 0 General Fund 0 0 0 0 0 0 0 Utility Fund 0 20,000 0 0 0 0 20,000 Visitor Fund 0 0 0 0 0 0 0 4A Loan 0 0 0 0 0 I 0 0 48 Loan 0 0 0 0 0 0 0 Grants 0 0 1 0 0 0 0 0 Private 0 0 0 0 1 0 0 0. Certificates of Obligation 0 0 0 0 0 0 0 PROJECT FUNDING TOTAL 0 20,000 0 0 0 0 1 20,000 NET 1 0 1 0 1 0 1 0 1 0 1 0 1 0 Page 76 IMPACT ON OPERATING BUDGET LTD BUDGET Planned 09/30104 04105 05106 06107 07108 08/09 PROJECT TOTAL Administrative Expenses Personnel Expenses O 0 0 0 0 0 0 0 0 0 0 0 0 0 Supplies 0 0 0 0 0 0 0 Maintenance 0 0 0 0 0 0 0 Services 0 0 0 0 0 0 0 Equipment 0 0 0 0 0 0 0 Transfer0 Debt 0 0 0 0 0 0 0 0 0 0 0 0 0 OPERATING IMPACT TOTAL 0 0 1 0 1 0 1 0 0 0 Page 76 CAPITAL PROJECT FY 204412005 Southlake N'1 Sewer Line Improvement Project Description: improvements to upgrade system for TRA acquisition. NET 1 0 1 0 1 a 1 a 1 0 1 0 1 0 IMPACT ON OPERATING PROJECT EXPENSE LTD BUDGET 09130/04 04105 LTD 09130104 BUDGET 04105 05106 Planned 06107 07/08 Planned 06107 07108 08109 PROJECT TOTAL Purchase 0 0 0 0 0 O I 0 Design 0 0 0 0 0 0 0 6 Construction 0 75,000 0 0 0 0 0 75,000 Implementation 0 0 0 0 0 0 01 0 Engineering 0 22,500 0 0 0 0 0 22,500 Legal Contingencies 1 0 0 j 0 0 0 0 0 0 0 0 0 0 0 0 PROJECT EXPENSE TOTAL Q 1 97,500 01 D 0 1 0 97,500 NET 1 0 1 0 1 a 1 a 1 0 1 0 1 0 IMPACT ON OPERATING PROJECT FUNDING LTD BUDGET 09130/04 04105 LTD 09130/04 BUDGET 04105 05106 Planned 06107 07108 05106 06107 07108 08109 08109 PROJECT TOTAL Prior Year Remaining Fund 0 0 0 0 0 0 0 0 General Fund 0 0 0 0 0 0 0 Utility Fund 0 97,500 0 0 0 0 97,500 Visitor Fund 0 0 1 0 0 0 0 0 4A Loan 0 0 0 0 0 0 0 4B Loan 0 0 0 0 0 I 0 0 Grants 0 0 0 0 0 0 0 Private Certificates of Obligation 0 0 0 0 0 0 0 0 0 0 0 0 0 0 PROJECT FUNDING TOTAL D 97,500 1 0 0 0 0 97,500 NET 1 0 1 0 1 a 1 a 1 0 1 0 1 0 Page 77 IMPACT ON OPERATING BUDGET LTD BUDGET 09130/04 04105 Planned PROJECT TOTAL 05106 06107 07108 08109 Administrative Expenses Personnel Expenses 0 0 0 0 0 0 i D 0 0 0 0 0 0 0 Supplies 0 0 0 0 0 0 D Maintenance 0 0 0 0 0 0 0 Services 0 0. 0 0 0 0 0 Equipment Transfer 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Debt 01 0 0, 0 0 0 0 OPERATING IMPACT TOTAL 0 0 0 0 0 1 0 0 Page 77 CAPITAL PROJECT FY 2004/2005 Water Meter Retrofit Project Description: Purchase of radio read water meters that will replace existing manual read meters. This will allow automated reading of meters and reduce the amount of time spent reading meters from 6 to 8 hours to approximately 30 to 45 minutes. NET 0 1 0 1 0 0 0 1 0 I 0 IMPACT ON OPERATING BUDGET PROJECT EXPENSE LTD 09/30104 BUDGETPlanned 04/05 05106 06/07 07108 LTD 09130/04 LTD 09/30104 BUDGET 04105 05106 Planned 06107 07/08 PROJECT 08109 PROJECT TOTAL Purchase 0 13,000 13,000 0 0 0 26,000 Design 0 0 0 0 0 0 0 0 0 0 0 0 0 Construction 0 Implementation 0 0 0 0 0 0 0 Engineering 0 0 0 0 0 0 0 Legal 0 0 0 0 0 0 0 Contingencies 0 2,000 2,000 0 0 0 4,000 PROJECT EXPENSE TOTAL D 95,000 1 15,000 0 0 0 30,000 NET 0 1 0 1 0 0 0 1 0 I 0 IMPACT ON OPERATING BUDGET PROJECT FUNDING LTD 09/30104 BUDGETPlanned 04/05 05106 06/07 07108 LTD 09130/04 BUDGET Planned Administrative Expenses 0 PROJECT 04105 05106 06/07 07108 08109 TOTAL Prior Year Remaining Fund 0 0 0 0 0 0 0 0 General Fund Utility Fund 0 0 0 0 0 0 0 fl 15,000 15,000 0 0 0 j 30,000 Visitor Fund 0 0 0 0 0 0 0 4A Loan 4B Loan 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Grants 0 0 0 0 0 0 0 Private 0 0 0 0 0 0 0 Certificates of Obligation 0 0 0 0 0 0 0 PROJECT FUNDING TOTAL 0 15,000 15,000 0 0 0 30,000 NET 0 1 0 1 0 0 0 1 0 I 0 Page 78 IMPACT ON OPERATING BUDGET LTD 09/30104 BUDGETPlanned 04/05 05106 06/07 07108 08109 PROJECT TOTAL Administrative Expenses 0 0 0 0 0 0 0 00 0 0_ 0 — 0 Personnel Expenses 0 0 Supplies 0 0 0 0 0 0 0 0 0 0 0 0 Maintenance 0 Services Equipment 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Transfer 0 0 0 0 0 0 0 Debt 0 0 0 0 0 0 0 OPERATING IMPACT TOTAL 0 0 0 01 0 1 0 0 Page 78 e Capital Projects Summarg FY 44/45 UNFUNDED - Future Project Title Funding Amount Radio Consortium Membership General Fund $ 402,665 Storage Building for Campus General Fund 1,115,000 Pond Improvements General Fund 50,000 Private Residence Life Trust General Fund 150,000 Lightning Protection General Fund 25,000 Athletic Concessions & Restroom General Fund 150,000 WLHPS Position General Fund 12,000 Total General Fund 1,904,665 Trailer Mounted Sewer Cleaner Utility Fund 25,250 Dove & ©ttinger Intersection Utility Fund 315,000 Total Utility Fund 340,250 FUTURE CAPITAL $ 2,244,915 Page 79 alt `F3j Technolo6�j Plan,- FY 04/05 Vision, Principles and Directives The Town of Westlake Technology Plan for 2004-2005 is aligned with the Town's Vision, Principles and Directives document that defines the goals and standards for Information Technology deployment. In summary: Town of Westlake Vision for Information Technology: To be an innovative leader in the use of Information Technology as a integrated tool to provide quality, effective, secure, robust and efficient services to the Citizens of Westlake, Texas. Guiding Principles Westlake shall use Information Technology to continually improve the quality, efficacy, security and efficiency of the services it provides to the citizens of Westlake. Westlake shall leverage its investment in Information Technology by maximizing the utility and interoperability of systems that it implements. Westlake shall maintain and enhance its role as a leader in the application of Information Technology to municipal operations. Westlake shall seek opportunities to form partnerships with other parties, both public and private, to maximize the effectiveness and maintenance of its use of Information Technology. Directives Security, Reliability, Availability Interoperability Open Source Considered Thin Client Preferred Server/Web Applications Preferred Self Sustainability Objectives for 2004-2005 The Town of Westlake has a strong Information Technology foundation in place with the completion of the projects initiated in 2003-2004. The following objectives are designed to properly maintain and support the existing technology base and to improve the quality and efficiency of services provided to Westlake citizens. Maintain and Enhance Security Measures Town of Westlake Website Automatic Water Meter Reading Integration and Westlake Citizen Portal New Equipment, Desktop Improvements, Enhancements THE TOWN OF WE TLAKE * 2650 OTTINGER. PO D * WESTLAKE, TEXAS -76262 Page 80 ht. t'r'.,syy t Tochnolo�,y Plan,- FY 0-4/05 Accomplishments 2003-2004 Design and provisioning of an integrated, scalable Information Technology infrastructure for the Town of Westlake was an important component of the design and building of the Municipal Complex. Acquisition and provisioning of all components of network infrastructure, telephone infrastructure, network servers and services and enhancements to the user `desktop' were initiatives over the past twelve months. An outline of key accomplishment follows. Cisco Network Infrastructure Deployment Fully switched, Cisco Network with significant capacity for expansion Redundant inter -building fiber optic, Giga -bit Ethernet Backbone Cat -6 Ethernet to the desktop Cisco AAVID Voice over Internet Protocol (VolP) Phone System Deployment WLCCM01: Primary Phone Server WLCCM02: Secondary Phone Server UNITY: Voicemail Server Desktop (Phone) Deployment Server Architecture and Provisioning FROST: Primary Domain Controller, Town Data Store, Veritas Backup Services TENNYSON: Building Access and Security HERBERT: Court Data Server, Remote Security Server BROWNING: WebCTRL, Building Controls RAND: Town Mail and Information Portal KEATS: Public Web server (wcstlakeacademy.or , eventually others) WSCADA: SCADA Server Integration with Academy Servers BRONTE: Secondary Domain Controller, N2112 BESS, Web filter POE: Student and Teacher Data Store Network Services Virtual Private Network (VPN) Support to Users and Vendors VERITAS: Backup Services OFFICESCAN: Managed Server and Desktop Virus Control POSTINI: Service for SPAM/Virus email Control N2112 BESS: Web Filtering Uninterruptible Power Supply Support wl Notification Desktop Enhancements Installation of New Desktops (DELL, 3YR On -Site Warranty) Conversion of all users to Domain Login w/ Network Data Store Initiated Office 2004 Upgrade VNC installed on each Desktop for Remote Support THE TOWN OF WESTLAKE * 2650 QTTINGEP, ROAD * ESTLAKE, TEXAS 76262 Page 81 ,tiS W r5/J f`I PS Ak'F A� Technole%&q Plan,- FY 04/05 IT Consulting, Development and Support Services Contracted The Town of Westlake will continue to contract with Kaleidoscope Information Services, Inc. for the human resources to maintain and grow its Information Technology systems. Kaleidoscope works with the Town Manager to identify and refine technology initiatives for the Town and for Westlake Academy. Kaleidoscope is responsible for directing these initiatives and for coordinating efforts of other outside solutions vendors that provide technology services to the Town. The Town's vision for integrated information flow and citizen interaction through the web Portal is an on-going process of innovation that requires both the integration of available `off-the-shelf solutions and custom application development. Kaleidoscope consultants work with Town staff to identify areas where technology solutions will improve the quality, efficacy, security and efficiency of the services it provides to the citizens of Westlake, and coordinates efforts to implement such solutions. The Town's Cisco network infrastructure and networked telephone implementation are maintained under the direction of a Kaleidoscope Cisco Certified Internetworking Engineer (CCIE). Kaleidoscope provides network, server and desktop computer support services to the town. Support includes routine surveys of servers and installation of software updates and security patches in a timely manner, monitoring the network, servers and desktop computers for signs of deterioration or security breach, and managing proper back-up routines. Most systems (all routers, switches, servers and desktops) can be supported remotely over secure Virtual Private Network (VPN) when consultants are not on site. On-site support for the town will be 1.5 scheduled days/ week for 2004-2005.The Town of Westlake may access Kaleidoscope support on-line chat or by telephone Monday -Friday, 8:00AM — 5:OOPM and 24x7x365 in the event of emergency. Westlake Technology Objectives for 2004-2005 Maintain and Enhance Security Measures Concern for information and network security is increasing globally. Prudence requires the Town of Westlake to maintain constant awareness of and readiness to deploy appropriate measures to protect the Town's Information Technology infrastructure and systems. The foundation of network and server security is current, up-to-date software and security patches. In order to provide continued hardware and software support for our Cisco network infrastructure and VOIP system, an annual contract for support will be renewed. Crucial to any security plan is provision for inadvertent data loss or disaster recovery. All computer data crucial to the business function of the Town of Westlake is captured on and archived on a routine basis using Veritas Backup Executive. Tape archives are cycled off-site on a weekly basis to provide data recovery should on-site systems and backups be compromised. THE TOWN OF WESTLAKE * 2650 QTTI-NUER ROAD * ESTLAKE, TEXAS 76262 Page 82 11'r. j '-�wwunt 11 Computer Viruses are an increasing concern to network data security. The Town of Westlake uses Postini SPAM and Virus detection software to quarantine viruses before they enter the network. Trend Micro OfficeScan Suite scans all network servers and desktop computers for viruses and effects repairs should an infection be identified. A central control mechanism allows support staff to monitor the protection status of all systems and identify outbreaks. Kaleidoscope has identified and will deploy a number of network analysis tools that monitor network activity in an effort to detect any unauthorized access or `intrusions.' Additionally, new systems and practices frequently emerge as `best practices' in the ongoing effort to secure networked computer systems. Kaleidoscope will monitor the availability and applicability of any tools that will aid Westlake in this objective. Performance Indicators for 2004-2005: • Network infrastructure and Servers will be kept current with all available and appropriate software updates and patches. • A Malware/Spyware Detection and Prevention Solution will be identified and deployed. • Network analysis tools will be deployed to provide improved intrusion detection. • Cisco hardware and software contracts will be renewed. • Veritas backup software support contract will be renewed. • Postini services will be continued. • TrendMicro anti-virus software license will be renewed. Town of Westlake' Website Tn an effort to improve on-line communication and services to the public, The Town of Westlake will extend and enhance the Content Management System (CMS) and Website Design framework put in place in the spring of 2003. The current framework provides for an integrated series of connected but uniquely identifiable websites for key content areas important to the Town of Westlake. Areas that have been identified: 1) Town of Westlake: targeted to potential corporate tenants, residents and landowners; 2) Town Governance: information on Town goverriance and management, building permits and zoning, notices, etc; 3) Visitors Guide: information about hotels, restaurants, meeting facilities and town events; 4) Municipal Court: information about the Westlake Municipal Court and provisions for on-line citation payment/dismissal; S) Westlake Academy: currently in place. The process of provisioning the content areas involves working with the Town Manager and Department Heads to finalize content outlines, managing the process of content collection from appropriate town staff, editing and writing custom copy from delivered content into a marketable "Westlake Story" in a powerful, web -friendly format. Page copy will be complemented with supporting graphics, illustrations or photography as appropriate. The resulting content can be re -purposed for other marketing material. The Town will outsource the initial content collection and preparation of the new websites to allow current, limited head -count to remain focused on mission -critical objectives. The Content Management System will THE TOWN OF WESTLAKE * 2650 OTr1_N(iER. RO*D * SLAKE, TEXAS 76262 Page 83 Technology Plan,- FY 04/05 enable internal staff to maintain site content on an ongoing basis with minimal dependence on outside graphic design or web design expertise. Performance Indicators for 2004-2005: • The Town of Westlake website will be redesigned in a manner consistent with existing Westlake Academy Website. • The Town of Westlake website will be moved from outside hosting server to an internal, Town of Westlake server. • On-line transaction capability for Municipal Court will be provisioned to accept citation payments via the Internet and will be integrated with the Incode Accounting system. • Master Plan maps will be published on the website to include data for the thoroughfare plan, water and sewer, zoning and parks. • Permits, applications, ordinances and other forms will be published on the website for end-user download and printing. • Appropriate Town staff will be trained to maintain site content using the Content Management System. Automatic Water Meter Reading Integration and Westlake Citizen Portal The Town of Westlake now has sufficient infrastructure in place to proceed with the vision of automating the collection of water meter data, real-time, and integrating that data into the criteria for customer billing. The primary goal is to permit billing water customers at a premium, Peak Rate, for water consumed during certain hours of the day. The Town will work with the telemetry -capable meter vendor and potentially other vendors of integration services to bring this long-standing vision to reality. Given the limitations of available Town staff, much of the required research and all of the required application development for this project will be outsourced. The Town of Westlake will begin the design and deployment of an e-commerce enabled government "Portal" that will enable the public, Westlake Citizens in particular, to access important civic information and interact with the Town government on-line. The Portal will be an integrated extension of the public informational website, but will enable appropriate parties to "Login" to access information that would otherwise require a phone call, fax or trip to the Town offices. One of the first uses of this Portal for citizens will be to login and view water usage. Parents of Westlake Academy students will access the Portal to access important calendar information, school lunch menus and to pay for school lunches on-line. Performance Indicators for 2004-2005: • The proof of concept for the automation of water meter reading will be demonstrated by: o Collecting data from the Town's water meters using remote telemetry; o Aggregating and logging this data to a central Town database; o Establishing a format compatible with STW Utility Billing Software for uploading data; THE TOWN Of WESTLAKE * 2650 OT`I`INQER, RMAD " WE_STLAKE, TE AS 76262 Page 84 �. L� Technolo6ij Plan,- FY 04/05 o Establishing any necessary modifications to STW export to Data Pro for customer invoicing indicating both Peak and Off -Peak water usage. • An on-line citizen portal will be established to provide password -protected, secure login to The Town of Westlake web server. • A Portal Application will be developed to permit water customers to graphically view water usage in near -real time, indicating Peak and Off -Peak usage and rates. • A Portal application will be developed to allow parents to view Academy lunch menus and place orders for student lunches with on-line payment by credit card or personal check. • A Portal application will be developed to permit secure, logged communications between staff and outside users. This system will initially be deployed as a means for Academy staff to communicate with parents, but will be further deployed to allow Town staff to communicate with citizens. New IT Equipment, Desktop Improvements, Enhancements Several areas have been identified where new equipment and software purchases will improve Town services and/or increase efficiency of the staff. The Town of Westlake has evaluated several alternatives but for reasons of compatibility with existing documents and outside users and the potential cost of training on alternative platforms, will continue to standardize on Microsoft Office for desktop productivity. Several upgrade and network enhancements will increase network reliability and user "up -time" in the Westlake Network. Directly connected printers that are currently being "Shared" through the computers to which they are connected will be provisioned with Printer Servers. (Any new printers designated for use by more than one individual will be purchased as network printers.) There are several older PCs in use at the Municipal Complex that are aging and may require repair or replacement within the next year. Provisions have been made accordingly. Performance Indicators for 2004-2005: • Procurement of a networked plotter to enable staff to print large CAD drawings and maps up to 42" wide and 150' long. • All Town systems will be upgraded to MS Office 2004 (Open License) for consistency in use and support. • Enhancements to Council Chambers including provision for a laptop on the dais; laptop cable connections on the podium; a multi -media capable PC dedicated for use in the Council Chambers and secured in the AV closet. • Any new or replacement desktop systems, approved by the Town Manager, will be purchased with three (3) year on-site warranty. THE TOWN a'P TLA -KF- * 2,65 O-T-nKiER. ROAD * 'WESTLAKE, TEXAS 76262 Page 85 iF -24;'l aim W, Requested Budget AA no r1owl;" 0/ wa#4x" Technology Plan-, FY 04/05 Kaleidoscope IT Consulting, Development, Support Security Measures and Subscription Updates Town of Westlake Website Automated Water Data Collection, Citizen Portal New Equipment, Desktop Improvements, Enhancements Hardware/Software Services Total $ 43,750 $ 43,750 12,000 12,000 14,000 14,000 $ 7,500 17,500 25,000 17,000 17,000 $ 24,500 $ 87,250 $ 111,750 THE TOWN OF WESTLAKE * 2650 OTT Ci . ROAD * WESTLAKE, TEXAS76262 Page 86