Loading...
HomeMy WebLinkAboutRes 06-50 Adopting Revised Budget for Fiscal Year 2006 and Adopting Proposed Budget for Fiscal Year 2007TOWN OF WESTLAKE RESOLUTION NO. 06-50 A RESOLUTION OF THE BOARD OF ALDERMEN OF THE TOWN OF WESTLAKE, TEXAS ADOPTING THE REVISED BUDGET FOR THE TOWN OF WESTLAKE, TEXAS FOR THE FISCAL YEAR ENDING SEPTEMBER 30, 2006 AND ADOPTING THE PROPOSED BUDGET FOR THE FISCAL YEAR ENDING SEPTEMBER 30, 2007. WHEREAS, a public hearing was duly held and all interested persons were given an opportunity to be heard for or against any item therein; and WHEREAS, as required by Texas Local Government Code 102.002, the budget officer has prepared a municipal budget to cover the proposed expenditures of the municipal government for the succeeding year. NOW, THEREFORE, BE IT RESOLVED BY THE BOARD OF ALDERMEN OF THE TOWN OF WESTLAKE, TEXAS: SECTION l: That the Board of Aldermen hereby adopts the revised budget for the fiscal year ending September 30, 2006 and the proposed Annual Operating Budget for the fiscal year ending September 30, 2007 and appropriates the funds contained therein. SECTION 2: That a copy of the official adopted 2006-2007 budget documents shall be kept on file in the office of the Town Secretary. SECTION 3: That this Resolution shall become effective upon the date of its passage. PASSED AND APPROVED ON THIS I ITH DAY OF SEPTEMBER, 2006, ATTEST: ( -"- Lw��aa - Jgn Dwinnell, Town Secretary APPROVE S TO RM: L. Canton L w , T ttorney Scott Brad ey, Mayor Trent O. Petty, Manager pF WEST TAKE A�Pq FISCAL YEAR 2006/2007 Scott Bradley Mayor Fred Held Mayor Pro Tem Don Redding, Bill Frey, Buddy Brown, Larry Corson Board of Aldermen Trent Petty Town Manager Jean Dwinnell Town Secretary Stan Lowry Town Attorney THE TOWN OF WESTLAKE * 2650 OTTINEiER ROAD * WESTLAKE, TEXAS 76,262 I-N-l: 20 TLS ,cn Annual Operating Budget - Fiscal Year 2006/2007 1 K Executive Letter 1 Executive Summary 2 3 General Fund Summary 3 4 General Fund Departmental 4 5 Utility Fund 5 6 Visitor's Association Fund 6 7 Property Tax Reduction Sales Tax Fund 7 E 10 4B Economic Dev. Fund 8 Debt Service Fund 9 Capital Proiects Fund 10 11 Capital Maintenance Fund 11 12 Long Range Plan 12 �F WEgT� SAKE JA AQP 1 `rUMIT) ,I Cal"N' 1. Executive Leiter Executive Letter 2. Executive Summary Organization Chart01 ------------------------------------------------------------------------------------------ EmployeeSummary--------------------------------------------------------------------------------------02 ExecutiveSummary----------------------------------------------------------------------------------------03-11 3. General Fund Summary - 100 ProgramSummary------------------------------------------------------------------------------------------12 Town Contribution to Westlake Academy ................................................. 13 Other Sources & Uses Summary________________ ________ ________ ________ _____________14 Departmental Summary by Revenue and Expenditures________ _____________15 Schedule of Revenues Graph----------------------------------------------------------------------16 Schedule of Expenditures Graph by Department ________ ________ _____________17 All Funds — Funding Sources Graph_________________________________________________________18 All Funds — Expenditure Categories Graph ________ ________ ________ _____________19 Schedule of Expenditures Graph by Category ........................................ _20 Salary vs Revenue Graph-----------------------------------------------------------------------------21 SalesTax Graph.--------------------------------------------------------------------------------------------22 Note Receivable — Trophy Club Ambulance ---------------------------------------------23 Inter -fund Repayment Schedule - Due from Utility Fund ....................... 24 Fidelity Tax Reimbursement Schedule .................................. -------------------25 4. General Fund Departmental - Goals & Objectives and Budget Detail Department // - Adm/n/strat/ve Goals& Objectives .-----------------------------------------------------------------------------------------26-27 BudgetDetail---------------------------------------------------------------------------------------------------28-30 Department 12 -&111d117 andCode Comp/lance Goals & Objectives-----------------------------------------------------------------------------------------31-32 BudgetDetail----------------------------------------------------------------------------------------------------33-34 Department 13 - Town Sec/etary Goals& Objectives .-----------------------------------------------------------------------------------------35-36 BudgetDetail----------------------------------------------------------------------------------------------------37-38 Department 14 - EinergencySerr�ices Goals& Objectives-----------------------------------------------------------------------------------------39-42 BudgetDetail----------------------------------------------------------------------------------------------------43-45 Department 15- Afmn/c/pa/Coillf Goals & Objectives-----------------------------------------------------------------------------------------46-48 BudgetDetail ..................................................................................................... 49-50 THE TOWN OF 1 TL : * 2650 OTTINEi ROAD * WESTLAKE, TEXAS 76262 i �F WEgT� SAKE JA AQP 1 `rUNIT) ,I Cal"N' 4. General Fund Departrnental - Goals & Objectives and Budget Detail (covemvo Dept >6 - Public WOIA-s Goals& Objectives .-----------------------------------------------------------------------------------------51-53 BudgetDetail...............................------------------------------------------------------------------....54 Dept 17- Faci/itieslWaintenanae Goals & Objectives-----------------------------------------------------------------------------------------55-56 BudgetDetail----------------------------------------------------------------------------------------------------57-58 Dept >8 — Finance & Human Resources Goals & Objectives Finance ......................................................................... 59-61 Goals & Objectives Human Resources ...................................................... 62-63 Budget Detail_____________________ Dept >9 - Parks andRecreation Goals & Objectives___________________ 66-67 BudgetDetail----------------------------------------------------------------------------------------------------68-69 Dept20 - /reformation Techno%gy Goals& Objectives .-----------------------------------------------------------------------------------------70-71 BudgetDetail----------------------------------------------------------------------------------------------------72 Dep121 —Engineering Goals& Objectives .-----------------------------------------------------------------------------------------73-75 BudgetDetail----------------------------------------------------------------------------------------------------76 5. Utility Fund - 500 ProgramSummary..........................................................................................77 BudgetDetail ...... ............................................................................................. 78-81 Inter -fund Repayment Schedule — Due to General Fund ...................... 82 Inter -fund Repayment Schedule — Due to 4A Fund................................83 Debt Payable Schedule — Keller Overhead Storage...............................84 Accounts Receivable Aging by month Graph ....................................... ---85 Total Water Accounts by Month Graph......................................................86 6. Visitor Association Fund 220 ProgramSummary------------------------------------------------------------------------------------------87 Goalsand Objectives-------------------------------------------------------------------------------------88 BudgetDetail---------------------------------------------------------------------------------------------------89-91 Revenue and Expenditure Analysis Graph...............................................92 RevenueAnalysis Graph-------------------------------------------------------------------------------93 Expenditure & Marriott Analysis Graph.. .................................................... 94 Revenue & Marriott Analysis Graph - -------- -------- -------- -------- -------------95 THE TOWN OF TL : E * 2650 OTTINEi ROAD * WESTLAKE, TEXAS 76262 ii �F WEgT� SAKE JA AQP 1 `rUNIT) ,I Cal"N' 7. Property Tax Reduction Sales Tax Fund - 260 ProgramSummary------------------------------------------------------------------------------------------96 BudgetDetail----------------------------------------------------------------------------------------------------97 8. 4B Economic Development Fund - 200 ProgramSummary------------------------------------------------------------------------------------------98 BudgetDetail---------------------------------------------------------------------------------------------------99 Inter -fund Repayment Schedule — Due from Utility Fund ----------------------100 9. Debt Service Fund - 300 ProgramSummary------------------------------------------------------------------------------------------101 BudgetDetail---------------------------------------------------------------------------------------------------102 2002 Series Bond Amortization 103 2003 Series Bond Amortization 104 10. Capital Projects Fund — 410 Capital Projects Program Summary ............................................................ 105 Capital Projects Budget Detail ..................................................................... -106-107 Proposed Capital Projects ............................................................................. 108 Civic Campus Expansion III Pod F 109 Roanoke & Ottinger Reconstruction------------------------------------------------------ ----110 FM 1938 Pedestrian Crossing------------------------------------- ---------------------111 High School Soccer Field --------- - ---------------------------------- ---------------------- 112 Art & Science Building------------------------------------------------------------------------------------113 FM1938 Engineering--------------------------------------------------------------------------------------114 TRA N1 Sewer Line ---------------------------------------------------------------------------------------- 115 Water Meter Automation 116 11. Capital Maintenance Fund — 600 Capital Maintenance Program Summary ---------------------------------------------------117 Capital Maintenance Budget Detail ............................................................. 118 Sanitary Sewer I&I Repairs-------------- 119 ---------------------------------------------------- General Maintenance 120 12. Long Range Plan Five Year Plan with 3% Growth 121 ------------------------------------------------------------------- Five Year Capital and Maintenance Plan --------------------------------------------------122 THE TOWN OF TL : E * 2650 OTTINEi ROAD * WESTLAKE, TEXAS 76262 iii pF WEST September 11, 2006 Honorable Mayor and Members of the Board of Aldermen: It is my pleasure to present the FY 2006/2007 budget of the Town of Westlake. The ability to continue providing basic services without a property tax has presented significant challenges during the past fiscal year. These challenges have prompted staff to recommend creative solutions to maximize revenue and operating efficiency. This budget addresses the impact of increasing residential service demands coupled with the lack of long -promised retail development and significant new capital required to accommodate expansion of Westlake Academy. Thanks to the approval of the 4A dissolution by the voters along with the creativity and commitment of the Town of Westlake employees, we are pleased to present a FY 2006/2007 budget that once again assesses no property tax. MAJOR EVENTS OF FISCAL YEAR 2005-2006 Budget In May, Westlake voters approved a measure to dissolve the 4A 1/z cent economic development tax and replace it with a 1/2 cent collection that is designed to reduce the property tax. Even though the Town of Westlake assesses no ad valorem property tax, Texas law allowed the Town to collect the new 1/z cent sales tax that did not share the restrictive spending limitations on revenues designated to the 4A Economic Development Fund. The results of the 4A dissolution transferred approximately $1,994,623 to the General Fund to be allocated to general operating expenditures, expansion of Westlake Academy and reserves. Town spending was also kept to a minimum in FY 2005/2006, resulting in the adoption of a revised budget in June which reflected $133,079 in net reduced General Fund expenditures. New Development The Town was pleased to welcome the First American Title relocation of 3,000 employees to the Solana complex in FY 05/06. This relocation required a $20 million renovation of 615,000 sq. ft. of office space in Campus Circle and produced a sales tax sharing agreement. As of June 2006, this agreement produced an additional $434,732 in sales tax revenues the Town would not have otherwise realized. These sales tax revenues will continue to be collected in FY 06/07 as well. Land Purchase Thanks to an anonymous donation of $1.2 million, the Town was able to acquire the Stan and Vontilla Parchman property on Ottinger Road to preserve the area for park and recreational use for future Westlake citizens. This $1.2 million appeared as an unexpected increase in both revenues and expenditures, and should be disregarded when examining the General Fund's revenue and expenditure patterns. The title to the Parchman property was transferred to the Town on August 15`'' Westlake Academy Expansion The Westlake Academy continued its expansion into office space previously occupied by the Town during the summer of 2006. The municipal court, town secretary, and Texas Student Housing offices relocated to the Solana complex in May 2006 at a capital cost of $15,000 and a new annual lease cost of $20,579. Sting The Town staff has continued to absorb additional service demands related to residential and commercial growth, as well and growth of the Westlake Academy. No new positions were added during 2005/2006, and the vacated Marketing Director position was not filled. This resulted in additional duties being absorbed by existing staff. Executive Letter - Page i DPS The lack of anticipated commercial and retail growth has severely impacted the Town's desire to operate a fully self-sufficient Department of Public Safety where cross -trained officers serve both as firefighter/paramedics and police officers. As a result, the Town continued its four-year old contract with the City of Keller for all police related services including jail, animal control and dispatch. Based on current service demands, the Town will be unable to offer joint services without significant new revenues. Staff has conducted a careful examination of the costs of capital, facilities, radio access, jail, dispatch, and animal control services. At the present time, the Town is not in the financial position to modify our Public Safety arrangements. Westlake firefighter/paramedics operated out of a portable building on Dove Road for the fourth consecutive year. Utilities FY 05-06 saw the beginning of the Town's effort to acquire a second source of water for the Town of Westlake. The Board approved a contract with Biggs & Mathews engineering out of Wichita Falls to begin exploring the feasibility of bringing water from the Upper Trinity River Water Authority via a charged line at 277 and 407 to Westlake. In addition, the Town contacted the City of Roanoke and the Town of Trophy Club to see if they were interested in participating in the study. The Town of Trophy Club agreed to participate and the study should be concluded by the end of the calendar year. Water rates for all customers were reduced during FY 05-06, allowing the Town to become much more competitive with surrounding communities. A new pilot program has been initiated to allow water meters within the Town to be read remotely and in real time, saving time and future resources. This emerging technology is currently not available anywhere else in the United States. Much like the telecommunications duct bank, Westlake continues to pioneer this unique concept that will have a far-reaching financial impact once perfected. This system will not only provide a means of altering water bills to introduce time variables, but will hopefully reduce the Town's peak charges by the City of Fort Worth and allow major revisions in the wholesale water contract. The Utility Fund is completing its second year of handling the billing process in-house. The Town utilizes a third - party for printing and mailing of utility bills, and payments are collected and applied by our finance department. This change has resulted in a better level of service for our customers and improved the Town's revenue stream by eliminating the outsourced billing service. This change was implemented with no additional staffing thanks to the dedication and talent of Westlake employees. FISCAL YEAR 2006/2007 The Town will continue its conservative budget approach in FY 2006/2007. Due to the continued uncertainty of commercial development in Westlake, there will be a continued emphasis of maintaining basic service levels without implementing a property tax. This philosophy has enabled Westlake staff to prioritize short and mid-term goals according to available resources. The creation of the Property Tax Reduction Sales Tax Fund in 2006 will allow the Town to use funds for general operations that were previously designated for economic development. This new 1/z cent sales tax was chosen to recommend to the voters over creating a Crime Control District (CCD), due to the less restrictive guidelines which govern how the funds can be used. The FY 06-07 budget reflects another large capital expenditure for the relocation of remaining town employees to leased office space in May 2007. When school convenes in September 2007, no town employees will remain at the civic campus location. The capital to renovate the existing space for school use and build a new soccer field is budgeted to be $531,000. The operating budget of the Town will also increase by $118,528 to pay for the new lease space in Solana to house all Town employees. Over the last two fiscal years, FY 04-05 and FY 05-06, the Town will have spent $1,785,641, based on square footage of Academy usage, in debt service for the Civic Campus which will soon be 100% occupied by Westlake Academy, and $456,721 in capital renovations to expand classrooms and parking facilities. In addition, for the FY 06-07, it is estimated that the Town will give $268,346 in Executive Letter - Page ii in-kind support of Town staff for Academy related functions. For the FY 06-07 budget, the facilities expenditures will decrease by $74,875 based on the Academy's proportionate share of occupancy of the facility. DEPARTMENTAL SUMMARIES Dept 12 - Building and Code Compliance The Building department is comprised of one FTE with clerical support from the accounting clerk who also functions as switchboard operator and receptionist. During FY 2005/2006, Jim Taylor was extremely successful in keeping our inspections and plan reviews delivered in a timely manner while still limiting the outsourcing of inspections in order to protect our profit margin. The challenge in 06/07 will be to continue this efficiency measure in view of a growing demand on inspections and plan review time. After the transition period for new staff is complete, certain aspects of the building process should be automated to the extent possible. A reasonably priced automation system is needed to reduce the required level of hard copy requirements and manual information access and retrieval by staff and builders. This item is included in the budget at a cost of $5,700. Dept 13 - Town Secretary The Town Secretary's office is committed to continued improvement in the area of record keeping and access to documents. With completion of the updated manual system as well as the codification of PD Ordinances, Engineering and Building Standards, and the indexing of the Board of Aldermen minutes, proper maintenance will be required to keep all areas updated with current information. The Town Secretary's office also provides support to the Texas Student Housing Authority. During FY 2005/2006, TSHA received approximately 900 applications and awarded approximately 500 scholarships. These figures are expected to increase in the next year. Additional follow-up and notification measures have also been added. The Texas Student Housing Authority Finance Manager has continued to take on more of the processing of and communications with the students. Dept 14 - Emergency Services The department has experienced a 25% increase in call volume since FY 03-04. Despite the growth in activity, the department has been able to expand their activities to achieve maximum efficiency. After being notified by City of Southlake that they would no longer be providing Fire Marshal inspection services to the Town, the DPS absorbed this responsibility in-house. The result has been a savings in contract expense, maximization of revenues and better utilization of available time. Department staff has developed expertise and a network to handle all inspections for new and existing occupancies. The DPS Department has a schedule for all annual inspections to be performed for commercial and business occupancies and will conduct these via routine in -company inspections. The FY 06-07 budget also includes replacing the existing rented portable station with a newer, cleaner rental unit at a cost of $2,000. Dept 15 - Municipal Court The Court will continue to provide efficient and courteous assistance to the public and the efficient processing of incoming citations. The daily operations of the front office have achieved the department's established goals of maintain a high level of productivity for the incoming citations. The Court relocated to the Solana office complex in June and has begun the process of establishing regular trial dates, attorney plea dockets, and pre-trial hearings. The allocation of a dedicated courtroom coupled with the increased flexibility in establishing court settings will reduce the backlog of trial dates within the first half of the fiscal year. In addition, the new office space and filing areas will increase overall productivity, organization and project a professional appearance to our customers. The Court staff has set a goal to fill the warrant officer position during the next fiscal year with the intent to collect and reduce the number of outstanding arrest warrants for the Town. The timely issuance of arrest warrants and warrant reduction will continue to be an integral portion of the departmental goals and objectives to be monitored in the coming year. In addition, the use of an outside collection agency was implemented in January 2006. In FY 06 - Executive Letter - Page iii 07, the process of submitting the cases for collection will be streamlined and monthly clearance reports will be submitted by the staff. The staff has submitted a request to migrate the citation data to an alternative software vendor. This measure will increase the flexibility of the software program, reduce the time allocated for warrant issuance, and enhance the reporting capabilities to reduce the processing time associated with citation entry and payments. The current software does not provide the flexibility to prepare customized reports or allow the format of documents necessary for warrant issuance. In addition, the current software is difficult to update and is not compatible with most word processing programs. The expected cost of this transition is $16,000 and will be paid primarily out of court technology funds, which is collected and designated for technology purposes. Dept 16 - Public Works One major focus of the Public Works Department for FY 06/07, will be the completion of planning for a second water source for the Town of Westlake. Though Fort Worth continues to meet the Town's current demand, the drought has taught us that the western area that serves the Tarrant Regional Water Supply, which in -turn supplies all the Fort Worth wholesale water customers, is depleting rapidly. If the Town of Westlake can achieve a second supply which would bring water from the Upper Trinity River Water Authority, the surface supply available to the town would be expanded from the limited western Trinity region to the new supplies currently planned in north east Texas such as the Ralph Hall Reservoir and the Marvin Nichols Reservoir. Having two water supplies would not only assure customers of Westlake a long term supply of water, but would also create opportunities to begin reducing cost by manipulating flows from two systems which would reduce peak requirements. The section of Ottinger Road just north of the Academy to SH170 continues to deteriorate and requires restoration. The rehabilitation of approximately 4,500 feet (2,000 feet in Denton County and 2,500 feet in Tarrant County) will include re -stabilization of the sub -grade with lime or cement and 2" of asphalt at an estimated cost of $101,174. Once completed, this overlay will have a useful service life of approximately seven years. Pavement failures on Roanoke Road south of Daimler Chrysler have increased over the last two years. The failures resulted in traffic hazards that have required major repairs. This project will provide stabilization of the road's sub - grade and 2" of HMAC from the area south of Daimler Chrysler to the Town limits (approximately 1,000 linear feet) at an estimated cost of $17,000. The existing 2" water line parallel to Ottinger Road was acquired from Keller in 2005. Since acquisition, this line has been repaired approximately two to three times per year. These repairs have resulted in costs of approximately $1,000 per repair, wasted water, and service interruptions. This project will abandon the existing 2" waterline that currently serves houses on Ottinger Road and provide a new 2" line south and an 8" line north of Dove Road. These new service lines will provide a more reliable service to our customers, as well as provide additional valves to isolate the water mains for repair work. Water meter automation is an ongoing project that will expand the pilot fixed -based meter reading project. This will allow the Town to read meters and monitor/record usage patterns through a network of metering devices connected to the Town Hall via radio, cable and/or internet transmissions. This system will ultimately maximize efficiency of staff and provide customers with invaluable information on-line, such as notification of a potential leak. Phase two for the water meter automation will allow real-time data collection/monitoring of water meters located within specific areas of the Town. These areas will be identified after the successful completion of the pilot program in May, 2007. During FY 05/06, staff inspected sewer lines, manholes, and clean -outs to identify items in need of repair. The recommended repairs will help reduce the amount of ground water intrusion into the sewer system. This reduction of infiltration will translate into reduced sewer treatment charges. In addition, the repairs will reduce the potential for sewer stoppages and discharges into nearby creeks, ponds, and yards. Executive Letter - Page iv Westlake and Southlake staff will also be actively pursuing TRA to assume ownership of the N-1 sewer line, currently owned by Westlake and Southlake. The transfer will require the installation of a new Westlake metering station and will be used by TRA to obtain flow readings for billing. This project is necessary to reduce the potential for a possible disagreement between Westlake and Southlake regarding billing methodology and volume. Dept 17 - Facilities Maintenance In FY 06/07, the Facilities Maintenance Department has proposed two capital projects. All of Pod F (current town offices) would be converted into five classrooms and one office in the summer of 2007. All remaining Town employees will be relocated to Solana in May 2007. This expansion gives the Academy the space necessary to add the tenth grade for the 2007/2008 school year. The estimated costs for the construction are $509,000. In addition, relocation expenses and lease fees are estimated at $140,380 beginning in April of 2007. Due to growth of the Academy, the Town has been asked to budget for an additional athletic field. The field would need to be sprigged in the summer of 2007 to have a playable surface by the spring of 2008. The cost of the new field and irrigation is estimated at $22,000. This field would serve as a practice field for soccer and other activities. In the fall of 2007, the Academy will occupy 100 percent of the campus. The Town's portion of the facilities maintenance budget will experience a decrease in 2006-2007. The Academy would absorb the cost of all cleaning services, paper products, security camera maintenance, and service calls. Dept 18 — Finance & Human Resources The Finance/Human Resources Department has continued to absorb additional service demands in FY 05/06. All measurable tasks increased throughout the year. These included accounts payable volume, payroll volume, benefits administration, utility billing, permitting, and records management. In addition, staff of the department has assumed the maintenance of the Town's website. FY 06/07 will include the upgrade of our general ledger and payroll software packages to a browser -based platform. The transition from an AS/400 platform to a Windows platform will increase staff efficiency, increase reporting capabilities, and decrease internal and external tech support requirements. The department continues to budget approximately $7,500 in overtime for the Finance Assistant, as the addition of a records & revenue clerk has been placed on hold indefinitely. Dept 19 - Parks and Recreation Expenditures have decreased by 15% in the FY 06-07 budget due to the academy taking over the tournaments and after school programs for kids. The increased use from the academy has limited the available times to provide other programs to the community. Due to severe drought conditions, new trees will need to be planted in the park, the Dove Road medians, and other public areas. Funds have been included in the FY 06-07 budget totaling $10,000 for this purpose. In addition, $15,000 has been budgeted to examine and implement options of beginning a reforestation program in the Town. Another significant improvement in overall irrigation efficiency and effectiveness will be available once the pilot water metering program has been deployed. In FY 05/06, the Parks Department trimmed dead trees in four different areas along Westlake roads. This is a maintenance item that will need to be performed each year in certain areas as a safety measure and is included in the FY 06-07 budget. Parks & Recreation revenue will decrease by 25% in the FY 06/07 budget due to surrounding communities providing full service recreation facilities and well established programs. The increased usage from the academy has also limited the resources necessary to offer programs to the community. Executive Letter -Page v Dept 20 - Information Technology The Department of Information Technology will pursue strategies to increase the efficiency of providing desktop computer support, reduce network security risks and improve information storage and delivery processes. Labor is a significant IT expense, and a key objective for FY 06/07 is the continuation of best practice policies and automation systems to better leverage IT staff efforts. Desktop computer support includes the installation of security "patches," software upgrades, virus / spyware detection and removal and recovery in the event of system failure or compromise. Dept 21— En ing eering The budget proposal for next year's Engineering Program requests that funding levels decrease from the previous fiscal year as several projects have been concluded. All of the usual services provided by Engineering will continue next year with coordination of the development review process being a top priority. There are several projects that are proposed to be carried forward from last year and new tasks that staff wishes to accomplish. These items are listed below: Engineering will conduct a study of the entire development review process to evaluate its efficiency and timeliness as the various applications and permits move through the system. This is an effort to insure that the submittals requiring review by the Town are processed in a timely manner and the developers and builders are not unreasonably delayed. As a part of the study, the current Development Fee Schedule will be evaluated to verify that the fees being collected are covering our costs and, more importantly generating revenue. Mapping of the Town's water and sewer systems was completed during this fiscal year. Next year, a parcel map will be produced that shows the status of platting in the Town. The maps are uploaded to the Town's website that provides a ready -reference for the staff and will be available to the public in the future. The mapping effort is an excellent start on developing a geographic information system for the Town in the future The Dove/Ottinger intersection continues to be a maintenance problem. This project will consist of re -alignment of the Dove Road and Ottinger Road intersection. This will improve visibility and safety while it reduces maintenance costs. The 2" water line that provides water for residents on Ottinger Road was acquired from Keller in 2005. The water line has been repaired numerous times in the last two years. The replacement of this line will provide customers more reliable service, reduce future maintenance costs and water loss from leaks. CAPITAL PROJECTS and CAPITAL MAINTENANCE Civic Campus Expansion III Pod F - $509,000 This project will remodel the town offices in Pod F into 5 classrooms and 1 office. All remaining Town staff will relocate to Solana in May 2007 before construction begins. This project also includes $25,000 to remodel the Parchman house for additional storage space. Roanoke & Ottinger Road Reconstruction - $118,174 This project will provide stabilization of road sub grade and 2" of HMAC. The Roanoke Road portion will include the area south of Daimler Chrysler to the Town limits (approximately 1,000 linear feet). The Ottinger Road portion will include the area north of the municipal complex to Hwy 170 (approximately 4,500 linear feet). FM1938 Pedestrian Crossing - $200,000 A pedestrian crossing under FM 1938 will be built, contingent upon TX Dot Funding. Executive Letter - Page vi High School Soccer Field - $22,000 The new field will be located on the west side of the current field. The current field will not sustain use from Elementary, Junior High and High School girl's and boy's teams. This project includes grading, installation of an irrigation system, hydromulching, and soccer goals. Work would be scheduled for the spring of 2007 and the field will be ready for play in spring of 2008. Art/Science Building - $1,176,818 Phase I of the Art/Science Building will include three laboratories, 4 offices, workroom, conference room, restroom, and entry hallway. The black box and art room will be included in Phase H construction, to be completed at a future date. Water Meter Automation - $34,690 The automation of water meters will apply to specific areas of the Town. These areas will be identified after the successful completion of the pilot program on Mahoeta Boone Trail. Ottinger Road Waterline - $85,000 This project provides for a new 2 -inch waterline south of Dove Road and a new 8 -inch waterline north of Dove Road. TRA Assumption of NI Sewer Line - $182,500 Assumption of the N-1 sewer line will require the design and construction of a metering station with SCADA equipment at the proposed Town of Westlake "Point of Entry". This project also includes video inspection, excavation to expose lines for inspection, as well as manhole and sewer main repair work. Sanitary Sewer Inflow & Infiltration Repairs - $27,000 This maintenance project includes the repair of manholes, clean -outs, and mains to minimize infiltration of groundwater. FUND SUMMARIES General Fund The General Fund is the main fund for the Town of Westlake. Half of the Town's sales tax, all 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 building and code compliance, municipal court, emergency services, public works, facilities maintenance, parks and recreation, consulting, and finance and human resources. Utility 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. The Town continues to use these new technologies to control inflows into our storage facilities and minimize the annual peak payment charges to the City of Fort Worth. Visitor's Association Fund The Visitor's Association Fund was established in late FY 1999/2000 and collects a 7% hotel occupancy tax from the Marriott Solana and any future Westlake hotels. FY 2004/2005 saw the launch of a new program in partnership with the Marriott to operate a shuttle service to deliver and return Marriott visitors to DFW Airport. After two years of supporting this program and hotel marketing efforts, it is unclear that this support has produced any additional revenues. The amount of support offered in FY 2006/2007 for this program has been reduced to $50,000. Executive Letter - Page vii 4B Economic Development Fund The 4B Economic Development Fund collects a 1/z cent sales tax to be used for qualified development projects. The 4B fund has been committed to the repayment of the debt incurred for the Town's Civic Campus project. Property Tax Reduction Sales Tax Fund The Westlake Property Tax Reduction Sales Tax Fund will receive its funding from a 1/z cent sales tax levy that was formerly earmarked for the 4A Economic Development Corporation. The purpose of this fund is to reduce local property tax rates throughout Texas by providing cities with an additional unrestricted revenue source. In Westlake's case, this fund will mitigate economic pressure to adopt a local property tax. These funds may be used for general Town expenditures. Debt Service Fund The Debt Service Fund was created to clearly illustrate the Town's debt service picture. The Town's debt obligations are consolidated into one fund with payments being transferred from 4B Economic Development Fund and the Property Tax Reduction Sales Tax Fund for the payment of our two issues of certificates of obligation in relation to the construction of the Civic Campus. Future CO's and General Obligation debt issuances will be paid from this fund. Capital Project Fund This fund tracks the infrastructure and building projects funded with general fund operating transfers, intergovernmental revenue, bond funds and other special fund sources. Capital projects are those projects over $25,000 that may extend over one fiscal year to complete and reflect multiple expense categories such as engineering, design and construction. All capital projects illustrate not only the expenditure and revenue sources, but ongoing operations impact. Permanent Capital Maintenance Fund The Permanent Capital Maintenance Fund (PCM Fund) was created to provide a mechanism for long term repair and replacement of large capital assets such as HVAC, walls floors and ceilings, plumbing, electric, pump stations, lift stations, elevated and ground storage facilities, roadways, etc. The PCM fund receives planned portions of revenues from each operating fund that owns and maintains capital assets to set aside for future capital repair and replacement. This helps to avoid future bond programs and forces a more conservative pattern of spending in light of uncertain future revenues. SUMMARY The FY 2006/2007 budget continues to reflect our fiscally conservative philosophies that we have embraced in years past. We continue to place an emphasis on maintaining service levels to our citizens, customers, and stakeholders without assessing a local property tax. Although we continue to face uncertainties associated with commercial development and sales tax fluctuations, our talented and dedicated staff has shown that they are capable of rising to that challenge. I want to extend my utmost appreciation and enduring respect to the employees of the Town of Westlake who freely bring forth their thoughtful recommendations for the future in the form of the annual budget. Sincerely, Trent Petty Town Manager Executive Letter - Page viii pp WEST SAKE ACP Town Texas Student Attorney Holing Executive Executive Manager Assistant Town Manager lyarrant Derxrty off/Cor Cbrlrs Public Wotks Bu//onq Off/c/;?/ Page 1 Twan SecreFary F— Visitor Assodadon Paiks and Recteation Finance Depattimit Finance 11ngn Assistant Resourms Fite Chief Fire and Ows Stat Facilities Fhance Maintenance manager Municipal Covet Town Manager lyarrant Derxrty off/Cor Cbrlrs Public Wotks Bu//onq Off/c/;?/ Page 1 Twan SecreFary F— Visitor Assodadon Paiks and Recteation Finance Depattimit Finance 11ngn Assistant Resourms Fite Chief Fire and Ows Stat �FAWESl, LAKE AC� ZV i 0 'v 10/ Wwt" Pi Town Manager 1 1 1 1 1 1 Assistant to Town Manager 1 1 0.5 0 0 0 Administrative Assistant 1 1 0 0 0 0 Executive Assistant 0 0 0.5 1 1 1 Part -Time Intern 1 0.5 0.5 0.5 0.5 0 Finance Assistant 1 1 1 1 1 1 Town Secretary 1 1 1 1 1 1 Building Official 0 0 1 1 1 1 Fire/EMS Coordinator 1 1 1 1 1 1 Firemen/Paramedics 0 9 9 10 10 10 Municipal Court Clerk 1 1 1 1 1 1 Municipal Court Deputy Clerk 0 0 1.5 1.75 1.75 2 Municipal Court Judge 1 1 1 1 1 1 Municipal Court Marshal 1 1 1 0 0 0 Municipal Court Warrant Officer 0 0 0 1 2 1 Public Works Superintendent 0 1 1 1 1 1 Utility & Building Technician 0 0 0 0 0 0 Facilities & Recreation 0 0 1 1 1 1 Finance Director 0 1 1 1 1 1 Human Resources Manager 0 0 1 1 1 1 Finance Assistant 1 1 1 1 1 1 Records & Revenue Clerk 0 0 0 0 0 0 Marketing & Public Affairs 0 0 1 1 1 0 Page 2 �F WEST r�9KE A�P� INTRODUCTION The Town of Westlake staff is pleased to present the recommended 2006/2007 annual operating budget, which is the product of many hours of preparation as well as a response to ever-changing internal and external influences. As in previous years, efforts have been made to control expenditures while continuing to deliver an excellent level of service to our citizens. Concentrated efforts have been made to produce a document that clearly illustrates the uses of Town resources, in a format that can be utilized as a resource tool by the Board of Aldermen, the Town staff and the citizens of Westlake. Our budget preparation process continues to be refined on an annual basis, operating within a set of budget preparation guidelines. The following procedures, which are guided by 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, interest income, water and sewer rates, duct bank income and miscellaneous revenues. 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 budget contains statistical and financial data for two fiscal years: the current budget year and the fiscal year recently completed as of September 30, 2005. COMPLIANCE WITH GASB STATEMENT NO. 34 The FY 2006/2007 annual operating budget has 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 State 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 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. Capital assets are depreciated in the annual audit, but are not reflected in the projection of revenues and expenditures detailed in the annual budget. Executive Summary - Page 3 BASIS OF ACCOUNTING/BUDGETING 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. 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. Descriptions of each fund contained in the Town's budget are as follows: 1. The General Fund is the general operating fund of the Town. It is used to account for all Town revenues and expenditures which are not accounted for in a special purpose fund. Primary sources of revenue include sales and use taxes, development fees and permits, court revenue, and franchise taxes. 2. The Economic Development Corporation 4B Fund is a local option established under the Texas local government code. 4B funds are generated from a 1/z cent sales tax levy and proceeds are used for general economic development and infrastructure support. 3. The Westlake Property Tax Reduction Sales Tax Fund will receive its funding from a 1/z cent sales tax levy that was formerly earmarked for the 4A Economic Development Corporation. The purpose of this fund is to reduce local property tax rates throughout Texas by providing cities with an additional unrestricted revenue source. In Westlake's case, this fund will mitigate economic pressure to adopt a local property tax. These funds may be used for general Town expenditures. 4. Westlake Visitors Association Fund receives its primary funding from a 7% hotel occupancy tax adopted by the Town of Westlake in FY 99 - 00. Proceeds from the hotel occupancy tax are required to be used for the promotion of travel and tourism in the Town of Westlake. 5. The Capital Project Fund tracks the infrastructure and building projects, funded with general operating transfers, intergovernmental revenue, bond funds and other special funding methods. Capital expenditures are clearly identified by their respective funding sources, and projects are shown in a clear, concise format. 6. The Permanent Capital Maintenance Fund is an account to offset the future costs of repair and/or replacement of large capital assets due to age and use. Contributions from the Town's operating funds are transferred on an annual basis; resulting in a cash balance which mitigates the cash flow impact of large maintenance and capital replacement costs. 7. The Debt Service Fund is established to account for, and the payment of, general long-term debt principal and interest. This fund provides a clearer accounting of ongoing debt obligations compared to operating budgets. The Debt Service Fund is used to make the payments for the two issues of certificates of obligation associated with the building of the Civic Campus. Executive Summary - Page 4 Proprietary Fund Types Proprietary fund types operate in a manner similar to private business utilizing an accrual basis of accounting. Enterprise Funds account for operations of governmental facilities operated in a manner similar to commercial enterprises where the intent is to recover, in whole or in part, the costs and expenses of providing goods and services to the public. Revenues are typically generated through usage fees based on individual demands of each customer. Enterprise funds may be used when the governing body has determined that periodic determination of revenue earned, expenses incurred, and/or net income is appropriate for capital maintenance, public policy, management control, accountability, or other purposes. The Utility Fund accounts for water, wastewater and telecommunications conveyance (duct bank) services for the residents of the Town. All activities necessary to provide such services are accounted for in the Fund, including administration, operations, maintenance, financing and related debt service, and billing and collection. THE BUDGET PROCESS The Town Manager submits the budget to the Board of Aldermen. The Town's fiscal year runs from October 1 through September 30. Prior to the beginning of the fiscal year, the Town Manager must submit a proposed budget, which includes: • A budget message • A consolidation statement of anticipated revenues and proposed expenditures for all funds • General fund resources in detail • Special fund resources in detail • A summary of proposed expenditures by department and activity • Detailed estimates of expenditures shown separately 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 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 objectives as well as performance measures, 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 in accordance with state and local law. This meeting is held after the Board has reviewed the budget. The Board of Aldermen approves a level of expenditure (or appropriation) for each fund to go into effect October 1, prior to the expenditure of any Town funds for that budget year. BUDGET AMENDMENT PROCESS The Town Manager may request that the current year budget be amended. The Town Manager will review the documentation and draft an ordinance that will amend the current budget. This ordinance is, as necessary, presented to the Board of Aldermen. 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. Executive Summary - Page 5 GENERAL FUND Revenues Funding of the Town's General Fund operations is segmented into five primary revenue categories. Each of these categories is detailed below with a brief description, how internal and external factors affect revenue amount, and how amounts differ from the prior year. Operating revenues for FY 2006/2007 are projected to be $3,818,049 a 22% decrease of the projected FY 2005/2006 total of $4,925,833. Of the General fund revenue received in FY 2005/2006, $1.3 million was the result of outside contributions. When separated for proper comparison, the General Fund's operating revenues are projected to increase by 5%. r ■ Other Permits & Fees ❑ Court 17W 2% 26% ❑ Taxes 4 ■ EM S 0% 4% F- BuildingDept 13% ❑ Texas Student Housing 3% El Interest Income 1% L Parks & Rec ■ Franchise Fees 0% 11% L- - on M 0 sales & Use Taxes Sales taxes are collected on the sale of goods and services within the Town as authorized by the State of Texas. The maximum sales tax allowed in the State of Texas is 8.25% per dollar on all taxable goods and services. Funds are collected by the Texas Comptroller of Public Accounts and remitted to the Town on a monthly basis. An amount equal to 1% of the taxable sales, or 50% of local collections are appropriated to the Town's the General Fund. The Town also receives an additional I % sales tax that is equally divided between the 413 economic development corporation and the Property Tax Reduction Sales Tax Fund. Sales taxes are budgeted to be $25,000 less for FY 2006/2007 over the previous year, a 2% decrease. In FY 2005/2006, sales tax collections exceeded original budget estimates primarily due to corporate relocations. Alcoholic beverage taxes are generated through a 14% mixed beverage gross receipt tax. Of this amount, 10.7% of gross liquor receipts are remitted to the Town, with the remainder kept by the State of Texas. Alcoholic beverage tax revenue is expected to increase by 5% over FY 2005/2006, due to ongoing growth of the Vaquero Golf Clubhouse. Franchise Taxes Franchise taxes represent revenues collected from utilities operating within the Town that use the Town rights-of-way to conduct their business. A flat rate is charged to both telephone operators (adjusted annually) and Tri -County Electric based on the number of access lines and services they render respectively. Overall, franchise taxes are expected to increase due to the proportionate residential and commercial growth. Executive Summary - Page 6 Licenses & Permits License and permit revenues include fees charged by the Town for certain types of operator licenses and permits for construction and other items regulated by Town ordinances. Residential building activity is projected to decrease in FY 2006/2007 by 18%, resulting in lower permit fees, plan reviews, and related inspection fees. Development fees are budgeted to drop dramatically in FY 2006/2007 due to lack of anticipated commercial development. In recent years, development fees have been collected primarily from corporate campus construction projects, as well as the Vaquero and Glenwyck Farms developments. Court Revenue The revenue generated from the Municipal Court is based on citations and warrants issued. The Keller Police Department will continue to perform its contractual patrol of Westlake roads in 2006-2007. Citation revenue for FY 2006/2007 is projected at $725,000, the same as FY 2005/2006. Overall, municipal court revenues are expected to increase 19% to $1,068,780 of which $72,000 is reflected in the DPS department's revenue due to their efforts in collecting warrants. This increase is primarily from more aggressive warrant collection efforts. Miscellaneous Revenue Miscellaneous revenue includes the sale of printed materials, interest earned, and parks & recreation fees. Expenditures FY 2006/2007 proposed operating expenditures in General Fund total $3,813,258, compared with FY 2005/2006 budget of $3,514,874. This number is net of the $1,200,000 donation with which land was purchased. This represents a 9% increase in operating expenditures from the prior year. Many expenditure areas are projected to decrease in FY 2006/2007. Capital expenditures in FY 2006/2007 are projected to total $834,174, an increase of 98% from the previous year's total of $368,800. As in recent years, Town staff continues to operate conservatively by controlling costs while maintaining the highest possible levels of service. These goals are on possible through continued strategic planning and the innovative use of available resources. Our overall budget philosophy continues to focus on meeting stated goals and objectives and maintaining a 90 day fund balance without adopting a local property tax. In the FY 2006/2007 budget, personnel expenditures remain the largest single expenditure category, accounting for 39% of all General Fund expenditures. This represents an increase from 29% in FY 2005/2006. ■ Parks & Rec ❑ Finance 3% -i I. T. 5% 2% i i Engineering 1% Facilitiesj/ 7% Admin 19% Public Works — ❑ Building 3% __ 3% ■ Court 11% 1 1 Secretary Fire Dept 2% 44 Executive Summary - Page 7 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 underground conduits 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. FY 2004/2005 saw the completion of the duct bank extension from Vaquero to Pearson Road. This extension was recently completed and generated $107,831 in revenue to the Town in FY 2004/2005. Staff is committed to maintaining an up to date cost/benefit analysis of water and sewer revenue to see that we are always charging more than we are paying to maintain the integrity of the fund. The short-term outlook for the Utility Fund is strong. The fund is however burdened with two outstanding long-term obligations. The first is the proportionate buyout of infrastructure owned by the Hunt Trust that sold the Circle T Ranch to Hillwood. The Town's agreement with Hillwood is that in exchange for dissolution of the MUDS, the Utility fund will reimburse Hillwood the share of purchased MUD infrastructure for each development based upon the acres removed from the MUDS. Hillwood, in turn, must deposit these funds into an escrow account owned by the Hunt Trust. The second long term liability is the loan from Hillwood to the Town to construct the Dove Road water line and the SH 377 Pump and Meter Station. The Town is contractually obligated to pay for this infrastructure through a surcharge on water rates. The Town is divided into two service areas, one being the Circle T Ranch, and the remaining areas within the Town's limits constitute the "Town" service area. The Town pays Hillwood $.25 cents per 1,000 gallons of water distributed to consumers in these two service areas. Each service area pays its respective portion of the overall debt based on the volume of water used from its customers. The contract clearly stipulates that this is not a general obligation of the Town. It is; however, required to be paid back through this assessment tacked on to the water rate. The rate would have to be doubled to pay this debt off in the twenty years contemplated under the agreement. Hillwood has stated that once the Town and Hillwood agree on proportionate future infrastructure funding, this liability will be erased. Nevertheless, the obligation does exist and water rates should always be reviewed with this obligation in mind. Revenue Utility Fund revenue is primarily comprised of fees for water and wastewater service. The fund also receives a small portion of its revenue through tap sees and interest income, and currently serves as a mechanism for collecting and distributing debt service and impact fees. FY 2006/2007 revenues are budgeted at $2,391,888, a 20% increase over the FY 2004/2005 budget of $1,998,335. A majority of this increase is attributed to residential growth; resulting in higher demand for water and sewer utilities. WaterRevenue The Utility Fund is the recipient of all revenue generated from water sales in the Town. With the advent of Westlake's master -planned residential developments, the Town placed new water infrastructure into service in 2000. As Westlake's customer base expands, additional demands have been placed on the utility system, requiring incremental expansion of our infrastructure. The health of the Utility Fund has continued to improve during the last several years, as the number residential and commercial customers have increased. Executive Summary - Page 8 Duct Bank The duct bank is the conduit that houses all underground utility infrastructure in Westlake. Revenues that the Utility Fund receives from the duct bank are contingent upon utility companies leasing out portions of the conduit. The Town has successfully executed new duct bank leases since 2001; however, no additional leases are anticipated for FY 2006/2007. WastewaterRevenues Another major component for Utility Fund revenues is for wastewater. Wastewater will continue to grow proportionate to future non -irrigation water demands. These future increases can be attributed to both residential and commercial growth. No reductions in wastewater rates are planned at this time. Executive Summary - Page 9 ■ Interest Income - Debt Service i% Contributions E Impact Fees 3% 2% \ u Other u Tap Fees ------ ___2% 2% _- ■ u Sewer Revenue 14% J� - Water _ - Revenue 77% Executive Summary - Page 9 Expenses FY 2006/2007 operating expenses in the Utility Fund total $1,922,874, a 10% increase over FY 2005/2006 expenses totaling $1,752,848. The Utility Fund will continue to fund capital projects that are necessary for infrastructure expansion and maintenance. ❑ Interfund ❑ Transfers Out ■ Capital Projects Payments— 0% 30% 1 % ❑ Admin 1% ❑ Contract Services 1% El Personnel Expenses 40 Supplies ❑ Peak Payments 3% 4% Maintenance 2% Wastewater ❑ Debt Service Treatment ■ Water Purchases 3% 3%12% Executive Summary - Page 10 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 that directly enhances and promotes tourism and the convention and hotel industry. Hotel occupancy revenue has remained relatively constant and has experienced only slight variances in the last several years. Revenues Revenues for the Westlake Visitor's Association are based mostly on Hotel Occupancy Taxes and interest income on the account. Other revenues are from the Westlake Historical Board and Arbor Days events. Revenues for FY 2006/2007 are projected to be $451,000, a 7% decrease from FY 2005/2006. This decrease is expected due to new hotel development in adjacent communities. — Interest Income ❑ Arbor 9% Days 1% ❑ Historical Board----------- 41L 1% Hotel Tax 89 Expenditures Operating expenditures for FY 2006/2007 are projected to be $243,347, a 46% decrease from the previous year total of $452,755. This decrease resulted from the elimination of the Director of Marketing and Public Affairs position and direct financial support for the Solana Marriott. For the past two years, the Town has contributed funds for the marketing of the Marriott and its shuttle bus service to DFW airport. The level of participation from the Town was to follow measurable performance indicators from occupancy rates and revenue totals. The contribution to Solana Marriott has been reduced to $50,000 for the FY 2006/2007. Executive Summary - Page 11 ■ Operating capital ❑admin 7% o Personnel 16% 1 Expenses 29% Website --- 1% -1 Professional services 11% F Shuttle program 21% -1 Special Events 5% ■ Marketlng -i Historical Board 2% 8% Executive Summary - Page 11 General Fund Program Summary Fiscal Year 2006/2007 Summary Actual FY 04105 Adopted Budget FY 05106 Amended Budget FY 05106 Adopted Budget FY 06107 Beginning Cash Balance $ 1,255,426 $ 1,223,306 $ 925,697 $ 2,495,598 Balance Sheet Affect to Cash " (267,080) (9,250) 114,436 114,436 Revenue 3,609,987 3,788,104 4,925,833 3,818,049 Transfers In 107,632 1,965,337 2,070,381 50,000 Payroll & Related Expenditures 1,288,790 1,407,094 1,343,005 1,489,188 Operating and Maintenance Expenditures 2,220,781 2,310,676 2,151,069 2,261,195 Capital Expenditures (Including Land Purchase) 170,543 10,000 1,220,800 62,875 Transfers Out 100,153 1,020,190 825,875 844,174 Ending Cash Balance $ 925,697 $ 2,219,538 $ 2,495,598 $ 1,820,651 Restricted Funds 355,841 364,824 437,385 545,185 Ending Balance $ 569,856 $ 1,854,714 $ 2,058,213 $ 1,275,466 # Days Operating (w/o capital) 59 182 215 124 Restdcted/Designated Funds Actual FY 04/05 Adopted Budget FY 05106 Amended Budget FY 05/06 Adopted Budget FY 06107 10112/10136 Court Technology $ 56,913 $ 55,646 $ 46,200 $ 50,000 10113/10137 Court Security 74,744 84,993 66,500 70,000 10116 Court Efficiency - - 500 1,000 10132 Trail Escrow 75,000 75,000 75,000 75,000 10134 Glenwyck Farms Trail 1 149,185 1 149,185 149,185 1491185 Building Fund (Texas Student Housing contribution) 100,000 200,000 Total Restdcted/Desi nated Funds $ 355,841 $ 364,824 $ 437,385 $ 545,185 ** 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. NOTE: See Page 13 for explanation of total contribution of expenditures and in-kind of $2,032,484 (from all Town funds) to the Academy. Page 12 O WEST �qKE ACA Based on Square Footage Usage - 86% Academy $ See Page 57-58 for detail of budget - relates to all contracts, repairs & maintenance of facility and portion of General Fund's Facilities/Ground Maintenance payroll budget allocation of 37.5% for Director - 86% Academy $ Civic Campus Expansion - Pod F & Staff Relocation General Fund contribution - 100% Academy $ Utility Fund Fund contribition -100% Academy $ Soccer Field - 100% Academy $ Proportionate share of Finance and HR staff - 20% Academy $ Academy Town Portion Portion Total 1,188,678 $ 193,506 $ 1,382,184 223,885 $ 36,446 $ 260,331 494,000 $ 494,000 15,000 --------------------- $ 15,000 22,000 $ 22,000 44,461 $ 177,842 $ 222,303 Total debt facilities and in-Idnd contribution to Westlake Academy $ 1,988,024 $ 407,795 $ 2,395,818 Notes: The allocation is based on square footage usage at the beginning of the fiscal year - 86%; 100% of building will be occupied by the Academy FY 2007-2008. The Town will move to Solana in May of 2007 but the Academy will not occupy the building until August, 2007; therefore, we will not differentiate the footage until FY 2007-2008. All contracts are between the vendor and The Town of Westlake; therefore all expenditures will be made through the Town versus transfering funds to the Academy for these payments. Page 13 OTHER SOURCES AND USES FUND 100 - General Fund OTHER SOURCES & USES Transfers In 52530 88 Transfer In from Civic Campus 16 - 52560 88 Transfer In from OF - Impact Fees 71,857 85,000 40,000 50,000 52570 88 Transfer In from 4A - dissolution - 1,880,337 1,994,623 - 52570 88 Transfer In from 4A - Fidelity Payment 35,758 - 35,758 - 494,000 62590 TOTAL TRANSFERS 1 107,632 1 1,965,337 2,070,381 50yf±fFO Transfers Out 62560 99 Xfr Out to 4B 16 - - - 62580 99 Xfr Out to DS - 481,664 368,683 - 62590 99 Xfr Out to CP - Civic Campus 97,447 266,525 260,000 494,000 62590 99 Xfr Out to CP - Roanoke/Ottinger Reconstruction - - - 118,174 62590 99 Xfr Out to CP - FM1938 Pedestrian Crossing 200,000 62590 99 Xfr Out to CP - Soccer Field - 22,000 62590 99 Xfr Out to CP - Portable Buildings - 57,400 - - 62590 99 Xfr Out to CP - Temp Parking Lot 2,690 93,800 108,800 - 62600 99 Xfr Out to PCM - Street Repair - 40,440 57,300 - 62600 99 Xfr Out to PCM - Street Repair 25,560 16,308 - 62900 99 Xfr Out to PCM - General Maintenance 10,000 10,000 10,000 62610 99 Xfr Out to SRF - 44,801 4,784 - TOTAL TRANSFERS OU 100,153 1,020,1901 825,875 844,174 NET TRANSFER 7,478 945,147 1,244,506 (794,174) Page 14 Percentage of Revenues and Expenditures by Department FUND 100 - General Fund Revenues Department 11 -Administrative 1,841,074 2,032,577 3,337,439 2,152,644 56% Department 12 - Building Official 657,788 658,752 623,820 513,710 13% Department 13 - Town Secretary - - - - 0% Department 14 - Fire/EMS 72,220 30,350 44,494 135,915 4% Department 15 - Municipal Court 1,016,238 1,028,000 894,780 996,780 26% Department 16 - Public Works - - - - 0% Department 17 - Facilities/Ground Maintenance - - 0% Department 18 - Finance/Human Resource - - - - 0% Department 19 - Parks and Recreation 22,667 28,425 25,300 19,000 0% Department 20 - Information Technology - 10,000 - - 0% Department 21 - Engineering - - - 0% 3,609,987 73,788,1041 4,925,833 3,818,049 100 Expenditures - Department 11 -Administrative 999,274 576,099 1,733,860 727,088 19% Department 12 - Building Official 119,793 121,601 118,113 127,199 3% Department 13 - Town Secretary 78,038 102,778 98,923 75,966 2% Department 14 - Fire/EMS 1,558,054 1,717,898 1,584,269 1,698,436 45% Department 15 - Municipal Court 291,851 339,828 398,321 404,368 11% Department 16 - Public Works 111,034 75,362 104,176 116,315 3% Department 17 - Facilities/Ground Maintenance 215,694 311,178 317,819 260,331 7% Department 18 - Finance/Human Resource 158,745 157,047 153,694 191,315 5% Department 19 - Parks and Recreation 96,655 114,578 120,299 104,241 3% Department 20 - Information Technology Department 21 - Engineering 50,976 - 83,000 128,400 52,000 33,400 73,000 35,000 2% 1% 3,680,114 3,727,77 4,714,874 3,813,25 100% Page 15 F Taxes 40% Texas Student Housing 3% ■ Other Permits & Fees 2% El Court 26% F- Parks & Rec ■ Franchise Fees 0% 11 Page 16 ::1 EMS 4% Building Dept 13% !rest Income 1% ❑1 LI Facilities 7% Public Works 3% ■ COL 11! ■ Parks & Rec 3% ■ Information Page 17 ❑ Fire Dept 44 Ing iministrative 19% ❑ Building 3% 5ecretary 2% OF WEg�G �2qK P10 go Property Reduction 10% 4B Fund Fundin_q from Page 18 63 !serves 14% (Fund of wEsrt TtgKE ACp� Operations and Operating Capital Maintenance I 1 34% I Town Stall Capital Relocatio 5% 1% r —� School Related Town Personnel 7 contributions to 23% Academy Town Debt Service 33% Portion 3% Page 19 �p WEST A# 10 Payroll & Related 32 Operating Capital 1% Transfers Out 18% Page 20 Operations & Maintenance 49 �FAAWEg7< go go / 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 FY 03/04 FY 04/05 FY 05/06 FY 06/07 Actual Actual Amended Proposed ■ Total Revenues ■ Pemonnel Expenditures Page 21 3,250,000 3,000,000 2,750,000 2,500,000 2,250,000 2,000,000 1,750,000 1,500,000 1,250,000 1,000,000 750,000 500,000 250,000 0 Aeo Tow*v V/ We4t"ew FMF 71 1,934,854 1,188,81 2,300,915 2000 actual 2001 actual 2002 actual 2003 actual 2004 actual 2005 actual 2006 budget 2007 budget Page 22 �p WEST 40 A we4t"460 06/01/01 $ 125,000.00 $ 20,731.00 $ 12,293.50 $ 8,437.50 $ 112,706.50 2 06/01/02 112,706.50 20,731.00 13,123.31 7,607.69 99,583.19 3 06/01/03 99,583.19 20,731.00 14,009.13 6,721.87 85,574.05 06/01/04 85,574.05 20,731.00 14,954.75 5,776.25 06/01/05 70,619.30 20,731.00 15,964.20 4,766.80 70,619.30 54,655.11 6 06/01/06 54,655.11 20,731.00 17,041.78 3,689.22 37,613.33 7 06/01107 37,613.33 20,731.00 18,192.10 2,538.90 19,421.22 8 06/01/08 19,421.22 20,732.16 19,421.23 1,310.93 (0.00) $165,849.16 $125,000.00 $40,849.16 Page 23 100.12802.00 100.36111.11 100.12801.00 Pymt # Payment Date Beginning Balance Total Payment Principal Interest Ending Balance 06/01/01 $ 125,000.00 $ 20,731.00 $ 12,293.50 $ 8,437.50 $ 112,706.50 2 06/01/02 112,706.50 20,731.00 13,123.31 7,607.69 99,583.19 3 06/01/03 99,583.19 20,731.00 14,009.13 6,721.87 85,574.05 06/01/04 85,574.05 20,731.00 14,954.75 5,776.25 06/01/05 70,619.30 20,731.00 15,964.20 4,766.80 70,619.30 54,655.11 6 06/01/06 54,655.11 20,731.00 17,041.78 3,689.22 37,613.33 7 06/01107 37,613.33 20,731.00 18,192.10 2,538.90 19,421.22 8 06/01/08 19,421.22 20,732.16 19,421.23 1,310.93 (0.00) $165,849.16 $125,000.00 $40,849.16 Page 23 OF WCS) _AAr Fo�C ,`n LAKE A�A� We4t"co, Page 24 Extension of 377 Water Sewer Line GW Falms 100.15205.00 100.38805.11 Water Mains Peak Paymen Line 'A" WateMine soo.z3ool.00 Pymt Payment Beginning $57,600 $95,000 $4,895 $1,515 $2,033 $161,043 Ending Amount Due Amount Due Amount Due Amount Due Amount Due TOTAL # Date Balance Balance 1 01/15/05 $ 161,043 3,840 23,750 4,895 1,515 2,033 $ 36,033 $ 125,010 2 01/15/06 $ 125,010 3,840 23,750 - - - $ 27,590 $ 97,420 3 01/15/07 97,420 3,840 23,750 - - - 27,590 69,830 4 01/15/08 69,830 3,840 23,750 27,590 42,240 5 01/15/09 42,240 21,120 - - 21,120 21,120 6 01/15/10 21,120 21,120 - 21,120 0 $57,600 $95,000 $4,895 $1,515 $2,033 $161,043 Page 24 pp WEsyf 40 �qKE A�A� Pymt FY End Beginning Total Ending # Date Balance Principal Interest Pymt Due Balance 1 09/30/02 536,373.60 - - - 536,373.60 2 09/30/03 536,373.60 21,460.78 85,813.94 107,274.72 429,098.88 ** 3 09/30/04 429,098.88 - - - 429,098.88 4 09/30/05 429,098.88 17,476.75 18,281.49 35,758.24 393,340.64 5 09/30/06 393,340.64 16,425.56 19,332.68 35,758.24 357,582.40 6 09/30/07 357,582.40 15,313.93 20,444.31 35,758.241 321,824.16 7 09/30/08 321,824.16 14,138.39 21,619.85 35,758.24 286,065.92 8 09/30/09 286,065.92 12,895.24 22,863.00 35,758.24 250,307.68 9 09/30/10 250,307.68 11,580.62 24,177.62 35,758.24 214,549.44 10 09/30/11 214,549.44 10,190.41 25,567.83 35,758.24 178,791.20 11 09/30/12 178,791.20 8,720.26 27,037.98 35,758.24 143,032.96 12 09/30/13 143,032.96 7,165.58 28,592.66 35,758.24 107,274.72 13 09/30/14 107,274.72 5,521.50 30,236.74 35,758.24 71,516.48 14 09/30/15 71,516.48 3,782.88 31,975.36 35,758.24 35,758.24 15 09/30/16 35,758.24 1,944.30 33,813.94 35,758.24 0.00 $ 146,616.20 $ 389,757.40 $ 536,373.60 $ - " FY 02/03 Payment of $107,274.72 included FY 01/02, FY 02/03, and FY 03/04 ($35,758.24 x 3) Page 25 pFAW_EST- ��AKE AC4� Goals & Objectives - FY 06/07 ADMINISTRATIVE—] Program Description ..................................................................................................................... The Administration Department coordinates and manages all facets of the Town's operations. The Town Manager serves as the chief administrative officer for all town operations. The Town Manager is responsible to the Board of Aldermen for proper administration of all municipal functions. The Town Manager is to implement the goals and objectives established by the Board of Aldermen including the preparation and submission of an annual municipal budget for Board review and adoption, as well as the implementation and oversight of the adopted budget throughout its effective fiscal year. Trends ..................................................................................................................... • Residential growth has slowed over the last twelve months • Commercial growth has been limited to the Solana campus expansion • Sales tax continues to hold relatively stable • Proportionate spending on Town M&O remains very low and consistent Program Broad Goals ..................................................................................................................... 1. Develop a reasonable and profitable plan which provides retail growth compliant with Westlake development standards. 2. Maintain a competent and competitive work force. 3. Investigate new ways to partner with public and private sector service providers to control cost and improve services. 4. Deploy additional revenue generating ventures in concert with development funding. 5. Conservatively develop and maintain an effective municipal budget and oversee all finances of the Town. 6. Keep Board of Aldermen abreast of the Town's financial condition and future needs in a timely manner. 7. Develop a new water supply in addition to the City of Fort Worth. 8. Avoid a municipal ad valorem property tax. 9. Update Westlake Code of Ordinances to completely reflect the installation of the government Council/Manager form of government adopted in 1999. Program Objectives - Ongoing ..................................................................................................................... 1. Pool natural gas mineral right owners to maximize return and minimize intrusion for property owners, the Town of Westlake and the Westlake Academy. 2. Provide quick and satisfactory resolution to citizens' concerns. 3. Continue to improve the quality and efficiency of services provided to Westlake citizens by all Town staff in achieving and implementing the Board of Aldermen's and citizens' priorities without an ad valorem property tax. Program Objectives FY 2005/2006 - Completed ..................................................................................................................... 1. Natural gas contacts continue to grow - partial royalties for the Town have been achieved. 2. All citizens' complaints are being addressed in a timely manner. 3. No ad valorem property tax 4. Achieved a designated "preferred last line" ZIP Code by the US Postal Service and listing in the National ZIP Code directory; providing a separate identity for the Town of Westlake. Program Objectives FY 2006/2007 ........................ Objectives for current year: 1. Prepare weekly update containing recommendations and summaries of all department and town activities. 2. Making budget, program and service recommendations to the Board of Aldermen when warranted. 3. Provide effective leadership, direction and oversight of the various town departments in developing policies and procedures to achieve and implement the goals and objectives of the Board. 5. Assist all Town staff in the training and enforcement of Westlake's Code of Ordinances in an effective and equitable manner to maintain the high quality of life in Westlake for its residents, businesses, and all customers. Page 26 pF WEST yY��u�t910 �LgKE A�P� Goals & Objectives - FY 06/07 ADM/N/STRA T/VE Performance Measures Program Provided in Partnership With ..................................................................................................................... • Board of Aldermen • Internal staff o Outside engineering and consulting firms • Outside legal firms Program Customers ..................................................................................................................... Citizens of Westlake Surrounding Westlake businesses Westlake Academy parents Page 27 Objective Budget FY05/06 Projected FY05/06 Budget FY06/07 Provide same day response to all citizens' calls N/A N/A 100% for services New measure New measure 2. Produce weekly update for Board of Aldermen New m/easure New measure 50/annually 3. 3 Complete program of services within adopted 100% 100% 100% or amended budget 4. Maintain annual 90 day Fund Balance 182 202 +90 5. Acquire 21d water supply for Town of Westlake N/A N/A Begin construction by New Measure New measure end of FY 06-07 6 %of Performance Evaluations administered on N/A N/A 100% time New Measure New Measure Program Provided in Partnership With ..................................................................................................................... • Board of Aldermen • Internal staff o Outside engineering and consulting firms • Outside legal firms Program Customers ..................................................................................................................... Citizens of Westlake Surrounding Westlake businesses Westlake Academy parents Page 27 FY 2006-2007 Operating Budget Fund 100 - General Fund C11J1VI.U,I10 11X1_1 l l v L' - Ll.:.r tfi� 1 ivllily 1 11 Revenues 31310 11 Sales Tax Revenue $ 994,606 $ 1,320,000 $ 1,525,000 $ 1,500,000 31430 11 Mixed Beverage Tax DEPT 11 - TOTAL PAYROL 39,64 13,846 38,49 10,500 13,000 13,650 31820 11 AT&T 33,669 50,500 40,000 42,000 31821 11 Verizon 7,632 12,000 6,600 6,930 31822 11 TXU/Atmos Gas 9,629 14,000 15,112 15,868 31823 11 Charter 222 250 340 357 31824 11 One Source 860 750 2,700 2,835 31825 11 Southwest Bell (now AT&T) 61,318 67,250 60,000 63,000 31826 11 Tri County Electric 226,243 205,000 260,000 273,000 31827 11 Trinity Waste Services 8,404 7,250 12,000 12,600 31828 11 Misc Franchise Fees 4,138 5,100 2,000 2,100 32110 11 Liquor Permit Fees - - 710 746 32208 11 Other Misc Permits 300 500 900 945 33700 11 Private Contributions - - 1,200,000 - 33701 11 Sale of Land 412,239 - - - 34130 11 Development Fees 35,422 210,550 14,500 15,225 34133 11 Special Event Fee - 500 500 525 34141 11 Sales of Printed Material 233 500 150 158 36109 11 Note Receivable Principal - 17,042 17,042 18,192 36110 11 Interest Earned 12,669 9,000 20,000 50,000 36111 11 Note Receivable interest 4,767 3,690 3,689 2,539 38805 39400 39410 39500 11 11 11 11 I/F Debt Pymt from OF Misc. Income Texas Student Housing Rental Income Texas Student Housing Donation Income - 8,860 6,018 - 27,590 15,000 5,605 50,000 27,590 10,000 5,605 100,000 27,590 500 3,885 100,000 DEPT 11 -TOTAL REVENU $ 1,841,07 $ 2,032,57 $ 3,337,43 $ 2,152,64 Expenditures 41110 11 42110 11 Salaries Medical Insurance $ 29,176 4,017 $ 29,952 4,912 $ 29,952 3,165 $ 35,563 3,360 42111 11 Dental Insurance 42130 11 LTD, AD&D, Life 42210 11 Social Security 42220 11 Medicare 341 229 1,028 368 234 315 2,301 1,,857 1,857 2,205 524 434 434 516 42310 11 TMRS 2,364 2,189 2,189 2,916 42510 11 Unemployment Taxes 156 19 189 189 42610 11 Worker's Compensation 79 121 135 109 DEPT 11 - TOTAL PAYROL 39,64 39,85 38,49 45,40 Page 28 FY 2006-2007 Operating Budget Fund 100 - General Fund 43110 11 Intern Program 8,267 10,500 - - 43130 11 Payroll Expenses - Other (2,073) 300 800 800 43205 11 Administrative Expense 134,613 124,,409 124,409 50,252 43206 11 Capitalized Administrative Expense (50,000) (50,000) (50,000) - 43215 11 Civil Engineering 87,931 43246 11 Appraisal Fees 3,250 - 43247 11 Surveyor Fees - - 3,650 - 43305 11 Misc. Legal 8,256 10,000 18,390 10,000 43307 11 Litigation Counsel 172,250 - - - 43310 11 Boyle & Lowry 155,064 125,000 92,000 100,000 43315 11 Goins, Underkofler 91,374 100,000 75,000 25,000 43325 11 Legislative (Akin/Gump) 58,644 55,000 60,000 60,000 43335 11 Contract Labor - - - 1,200 43405 11 Computer Equipment/Software 9,075 1,000 1,000 1,000 43515 11 Community Service 2,708 3,500 3,000 2,500 42214 11 Insurance - Auto - - - - 43520 11 Contingency 2,457 10,000 5,000 10,000 44110 11 Rent ( TSH at Solana) - - 1,295 5,178 44110 11 Rent (Secretary at Solana) - 2,723 2,723 44110 11 Rent (Court at Solona) 17,685 16,562 66,246 44110 11 Rent (Town at Solana $12 sq ft 6,000 (5 mo)(50%) - - 22,190 44111 11 Construction allowance $3 per ft. (50%) - - 9,000 44300 11 Copier Repairs & Maint. - 1,800 1,800 1,092 44302 11 Copier Lease 2,215 3,120 3,120 3,120 45205 11 Insurance Deductible 1,000 - 1,000 - 45209 11 Insurance - Law Enforcement - - 605 666 45210 11 Insurance - General Liability 17,375 19,115 9,167 9,948 45211 11 Insurance - Errors & Ommissions - - 15,104 16,852 45213 11 Insurance - Crime & Theft 1,124 1,236 45214 11 Insurance - Auto - - 456 502 45215 11 Insurance - Property 7,588 435 4,807 162 45305 11 Telephone Service 6,262 6,724 6,724 6,700 45310 11 Mobile Phone 1,422 1,750 1,750 1,700 45325 11 Postage Machine Lease 893 900 1,100 1,000 45805 11 Airfare 246 100 100 100 45815 11 Lodging - 100 100 100 45820 11 Meals 116 200 200 200 45825 11 Mileage 22 100 100 100 45825 11 Mileage (Town Secretary) - - - 1,200 45830 11 Training, Seminars, Meetings 728 500 1,600 1,600 46105 11 Office Supplies 7,359 6,400 6,400 6,400 46106 11 Hospitality Items 3,028 2,600 2,600 2,600 Page 29 FY 2006-2007 Operating Budget Fund 100 - General Fund 46115 11 Dues & Subscriptions 9,390 8,000 8,300 8,000 46120 11 Postage & Supplies 2,902 3,000 3,000 3,000 46125 11 Printing 10 100 100 100 46130 11 Books & Printed Materials - 250 250 250 46135 11 Bank Charges 31 200 200 100 46140 11 Moving Expense - 6,000 6,000 - 46140 11 Moving cost (50%) - - - 5,000 46160 11 Credit Card Processing 293 100 100 100 46190 11 Misc. Expense 2,429 - 1,700 1,000 46205 11 Utilities - Water 7,039 3,630 3,630 3,500 46215 11 Vehicle Fuel/Maint/Repairs 1,550 1,500 750 750 46220 11 Utilities - Electric (Town) 20,658 10,655 15,000 10,600 46220 11 Electric (TSH at Solana) 78 304 46220 11 Electric (Secretary at Solana) - - 40 160 46220 11 Electric (Court at Solona) 972 3,895 46220 11 Utilities Solana/House (50%) - - - 4,000 46225 11 Utilities - Gas 2,899 1,574 3,800 3,800 46520 46522 46523 47900 11 11 11 11 Economic Development Principal (Fidelity) Economic Development Interest (Fidelity) Economic Development (First American) Westlake Academy Grant 18,281 17,477 - - - 50,000 16,426 19,333 - 15,314 20,444 150,000 - DEPT 11 TOTAL OPERATIONS & MAIN 813,02 536,24 491,36 651,68 new 11 Equipment server (50%) - - 5,000 new 11 Recording devices and furniture (50%) 25,000 47412 11 Land Purchase 146,600 - 1,204,000 - DEPT 11 TOTAL CAPITA 146,60 1,204,00 30,00 DEPT 11 TOTAL EXPENDITURE 999,27 576,1-1,733,86 727,08 DEPT 11 - EXCESS REVENUES OVER (UNDER EXPENDITURE $ 841,79 $ 1,456,47 $ 1,603,57 $ 1,425,55 Pagc 30 r fAcoo ToW010.4 0 We4t"ew Goals & Objectives - FY 06/07 BUILDING & CODE COMPLIANCE Program Description ..................................................................................................................... The Building and Code Compliance Department program assures responsible administration and enforcement of the Town's adopted building codes and ordinances. It safeguards public health and property by overseeing the design, use of materials and construction methods used to build and maintain structures within the Town of Westlake. The program provides the following for all commercial and residential construction in Westlake: pre -construction consultation insures registration of contractors and sub -contractors, review of construction plan submittal, and issuance of building permits. Trends ..................................................................................................................... 1. Approximately 1 to 2 commercial renovations are anticipated this year. (not including the Hotel) 2. The overall trend will be a 20-25% reduction of revenue, as compared to previous years: o SFR "available" lots are decreasing ■ Estimating less than 156 SFR lots available; 5 outside Vaquero Subdivision 150 inside the Vaquero Subdivision 3. The trend will continue downward, if no more property is re -zoned to the residential "R-1 " classification 4. Single Family Residences built o FY 04/05 actual was 51 homes o FY 05/06 year end projection is 48 homes o FY 06/07/projection is 33 homes 5. Percentage of expenditures in comparison to revenues generated o FY 04/05 is 18% ■ Revenue $657,787 ■ Expenditure $537,995 o FY 05/06 year end projection is 20% ■ Revenues $623,820 ■ Expenditures $500,007 o FY 06/07 projection is 25% ■ Revenues $513,710 ■ Expenditures $127,280 Program Broad Goals ..................................................................................................................... 1. Serve the Commercial and Residential Construction needs of the community, with professionalism, courtesy, and distinction. 2. Issue building permits expediently and efficiently. 3. Insure Code and Ordinance Compliance. 4. Provide an opportunity for consumer feedback, through Contractor/Sub-contractor meetings with critiques and re- evaluation of procedures. Program Objectives Ongoing ..................................................................................................................... 1. To provide same day Inspection service, if requested prior to noon 2. Provide data to show the most cost effective use of outside inspections. Via Monthly Revenue/Procedures Report 3. Provide Maximum 10 day turn around time for SFR plans review submittal to permit issued Program Objectives FY 2005/2006 - Completed 1. Streamlined the building permit, plan submittal and review process to insure expedient and efficient issuance by creating an electronic database with the intra -departmental assistance and electronic project communication log. 2. Improved the existing construction inspection services, through feedback and self-evaluation by creating a "Consult Inspection." This provides the contractor a one-time consultation with specific inspection criteria for building projects at no additional fee. 3. Achieved one additional certification as Residential Electrical Inspector. Page 31 Acoo Tiow*v 10 Wwt"e [Goals & Objectives - FY 06/07 BU/LD/NG & CODE COMPLIANCE Program Objectives FY 2006/2007 ..................................................................................................................... Objectives planned for FY 06/07 year 1. Complete the master filing system, within the Building Department records system, with (optional) hard copy and/or electronic file for access by staff and public. 2. Establish a wireless communication system to create electronic reporting of field inspections. Performance Measures Program Customers ..................................................................................................................... o Homeowners • Developers o Builders • Contractors Page 32 Objective Budget FY05/06 Projected FY05/06 Budget FY06/07 1' SFR plans reviewed and completed within 10 100% 100% 100% days of submittal 2' % Commercial plans reviewed within 10 days 100% 95% 100% and log updated 3. % Building inspections responded to same day 80% 95% 90% 4' Revenue generated over department cost to 75% 80% 72% operate 5. Number of Contractor meetings sponsored 2 1 1 6. Achieve new ICC certification N/A (new measure) 100% 100% Program Customers ..................................................................................................................... o Homeowners • Developers o Builders • Contractors Page 32 Fiscal Year 2006-2007 Operating Budget Fund 100 - General Fund BUILDING OFFICIAL - DEPARTMENT 12 12 Salaries $ 53,418 $ 54,886 $ Revenues 56,127 41640 12 Auto Allowance 900 - 32209 12 Grading/Excavation Permits $ 20,900 $ 22,321 $ 18,000 $ 15,000 32210 12 Building Permits 398,722 396,476 374,000 307,450 32211 12 Inspection/Plan Reviews 215,281 221,831 216,000 177,550 32212 12 Reinspection Fees 2,860 600 2,300 2,025 34129 12 Pre -Submittal Reviews 800 - 2,000 1,200 34132 12 Contractor Registrations 19,225 17,524 11,000 9,900 34141 12 Code Book Sales - - 520 585 270 270 DEPT 12. TOTAL REVENU $ 657,78 $ 658,75 $ 623,82 $ 513,71 Expenditures 41110 12 Salaries $ 53,418 $ 54,886 $ 54,886 $ 56,127 41640 12 Auto Allowance 900 - - - 42110 12 Medical Insurance 18,670 21,570 9,032 8,300 42111 12 Dental Insurance - - 513 535 42130 12 LTD, AD&D, Life 280 525 441 525 42210 12 Social Security 3,017 3,403 3,100 3,480 42220 12 Medicare 718 796 790 814 42310 12 TMRS 4,284 4,012 3,900 4,602 42510 12 Unemployment Taxes 27 27 270 270 42610 12 Worker's Compensation 421 682 550 589 46115 12 DEPT 12. TOTAL PAYROL 81,73 85,901 73,48 75,24 43260 12 Third -party inspection/plan review 13,460 15,000 29,735 30,000 43405 12 Computer Equipment/software - 6,700 - 5,700 45214 12 Insurance - Automobile - - 506 557 45310 12 Mobile Phone 1,559 1,300 1,450 1,600 45815 12 Lodging 634 900 900 900 45820 12 Meals - - 58 500 45825 12 Mileage 160 - 300 1,600 45830 12 Training, Seminars, Meetings 2,130 3,500 3,300 3,400 46105 12 Office Supplies 534 1,000 1,000 1,000 46110 12 Office Equipment - 1,500 1,400 1,500 46115 12 Dues & Subscriptions 260 750 650 750 46125 12 Printing 1,020 750 1,162 750 46130 12 Books & Printed Materials 1,751 2,800 2,700 2,000 46215 12 Vehicle Fuel/Maint/Repairs 846 1,000 900 1,200 46605 12 Uniforms - 500 570 500 DEPT 12 TOTAL OPERATIONS & MAIN 22,35 35,70 44,631 51,95 Page 33 Fiscal Year 2006-2007 Operating Budget Fund 100 - General Fund 47410 12 Vehicles 15.704 DEPT 12 TOTAL CAPITA 15,70 DEPT 12 TOTAL EXPENDITURE 119,79 121,601 118,11 127,19 Page 34 DEPT 12 - EXCESS REVENUES OVER (UNDER EXPENDITURE $ 537,99 $ 537,151 $ 505,70 $ 386,511 Page 34 ?• i O' We4t"eoo Goals & Objectives - FY 06/07 TO WN SECRETARY Program Description ..................................................................................................................... Performs tasks outlined in the Texas Municipal Law and Procedure Manual for General Law Type A Cities. Responsible for recording of official proceedings of various Boards, conducting all Town elections, maintaining and preparing all official records and documents and providing legal and proper notice of all official meetings of various Boards, ordinances, and elections. Performs secretarial tasks related to the Texas Student Housing Authority. Responsible for updating application form, receiving, organizing, and logging applications, responding to all calls and e-mails regarding the scholarship program, sending letters to awardees, and acting as secretary to the Board of the Texas Student Housing Authority, sending out information, and arranging and attending meetings. Trends 1. There has been an Increase in number of Texas Student Housing applications from the previous year by approximately 100; an increase in the number of offers from approximately 500 to approximately 600; however fewer scholarships have been accepted due to lack of enough money, even with our scholarships, and the wider geographic and ethnic coverage, many families must choose local and community colleges. 2. More internal requests being processed. On average, maybe one request per month from outside the organization compared to approximately one per week from within. The overall requests have not significantly changed from the prior year. 3. There has been an increase in the number of meetings held by the various Boards including Board of Aldermen - 21 during 2004/2005 and by year-end we are anticipating 30 for 2005/2006; School Board - 8 during 2004/2005, anticipating 15 for 2005/2006; Planning and Zoning Commission - 3 during 2004/2005, anticipating 5 for 2005/2006. The number of Historical Board meetings has remained at 10 the past two years and the number of Zoning Board of Adjustment meetings has decreased from 4 in 2004/2005 to 1 in 2005/2006. With the increase in meetings comes an increase in the necessary time to prepare the packets for each meeting and the post meeting requirements such as processing Resolutions, Ordinances, Contracts, and preparing Minutes. Program Broad Goals ..................................................................................................................... 1. A commitment to leadership that ensures quality public service based on honesty, dependability, integrity, consistency, respectfulness, and fairness. 2. Maintain accurate records that are available to the public, Boards, and staff through a user-friendly records management program in compliance with state law and our own ordinance; 3. Conduct election accurately, efficiently, and in accordance with state law; 4. Accept and process Texas Student Housing applications in a timely and effective manner; 5. Prepare notifications of scholarship awards and record responses in a timely and effective manner. 6. Maintain all permanent Town records in digital form. Program Objectives Ongoing .................................................................................................................... 1. Provide outstanding citizen and staff responsiveness. 2. Provide guidance in the development of records management for staff. 3. Continue professional development and training to maintain state election law standards. 4. Continue professional development and training to maintain state Municipal Clerk Certification. 5. Continue to streamline the scholarship process and manage additional workload. 6. Provide outstanding customer service to students/parents regarding scholarships. Program Objectives FY 2005/2006 - Completed .................................................................................................................... 1. Conducted local option election 2. Conducted 4A dissolution election 3. Streamlined TSH record keeping 4. Scanning/Indexing of all Board of Aldermen minutes 5. Codification of Planned Development Ordinances Page 35 ?• i O' We4t"eoo Goals & Objectives - FY 06/07 TO WN SECRETARY Program Objectives FY 2006/2007 ..................................................................................................................... Objectives planned for the current year 1. Attend Texas Municipal Clerk's Graduate Institute for credit toward recertification - November 2006 2. Attend Texas Municipal Clerk's Election Law Seminar for credit toward recertification - January 2007 Performance Measures Program Provided in Partnership With ..................................................................................................................... • Consultants • Town of Westlake staff • Texas Student Housing Authority staff Program Customers ..................................................................................................................... • Board of Aldermen • Town Citizens • Texas Student Housing Authority Board • Town of Westlake Staff • Historical Board • Commissions Page 36 Objective Budget FY05/06 Projected FY05/06 Budget FY06/07 1. Complete codification of existing ordinances Jan -06 Sep -06 n/a 2 Submit new Ordinances for placement on N/A N/A website within 60 days of approval New measure New Measure 100% 3. Complete 100% record scan to digital media Aug -06 Sep -06 n/a 4 Complete Records management training for all May -Ob Carry over to 2007 May -07 administrative staff 5 Number of state training seminars necessary to 1 1 1 attend to maintain certification 6. Streamline TSH record keeping Nov -05 Nov -05 n/a 7 Update TSH application form and website N/A N/A annually New measure New measure Oct -06 8 Complete TSH information packet mail -out to New m/easure N/A Nov -Ob approximately 1,400 high schools New measure 9 Follow-up with high school contacts regarding New N/A TSH information packet m/easure New measure Jan -01-07 1o. Contact all students prior to sending award New m/easure NA Jun -07 letters (700-800) New measure Program Provided in Partnership With ..................................................................................................................... • Consultants • Town of Westlake staff • Texas Student Housing Authority staff Program Customers ..................................................................................................................... • Board of Aldermen • Town Citizens • Texas Student Housing Authority Board • Town of Westlake Staff • Historical Board • Commissions Page 36 Fiscal Year 2006-2007 Operating Budget Fund 100 - General Fund TOWN SECRETARY - DEPARTMENT 13 Revenues 39400 13 Misc Income $ $ $ $ DEPT 13 - TOTAL REVENU $ - Is - Is - Is - Expenditures 41110 13 Salaries $ 69,041 $ 66,491 $ 66,491 $ 68,156 41110 13 Payroll Credit from TSH (18,779) (21,942) (21,942) (23,855) 42110 13 Medical Insurance 7,294 7,017 4,389 4,800 42111 13 Dental Insurance - - 273 327 42130 13 LTD, AD&D, Life 270 525 525 450 42210 13 Social Security 4,253 4,122 4,000 4,226 42220 13 Medicare 987 964 964 988 42310 13 TMRS 5,429 4,860 4,700 5,589 42510 13 Unemployment Taxes 54 27 270 270 42610 13 Worker's Compensation 151 269 193 245 DEPT 13. TOTAL PAYROL 68,70 62,33 59,86 61,19 43241 43305 44300 44302 45325 45405 13 13 13 13 13 13 Records management Misc Legal Copier Rental/R&M/Copy Chg Copier lease Misc Rental Advertising - Public Notices - 122 - 2,861 - 1,416 13,500 - 750 1,380 300 2,500 13,500 - 630 1,350 300 1,266 1,000 200 750 1,380 300 2,000 45815 13 Lodging - - 360 400 45820 13 Meals - - 63 150 45830 13 Training, Seminars, Meetings 699 1,000 931 700 46105 13 Office Supplies 333 400 750 800 46115 13 Dues & Subscriptions 95 200 220 250 46120 13 Postage & Supplies 68 100 100 100 46130 13 Books & Printed Materials 100 100 100 310 46150 13 Licenses/Registrations 71 - - 100 46175 13 Meeting Expense 45 100 100 100 Page 37 Fiscal Year 2006-2007 Operating Budget Fund 100 - General Fund 46180 13 Election Expense 7,000 6,275 3,000 46185 13 Codification 3,448 13,000 13,000 3,030 46190 13 Misc Expense 80 115 115 200 DEPT 13 TOTAL OPERATIONS & MAIN 9,33 40,44 39,06 14,77 DEPT 13 TOTAL EXPENDITURE 78,03 102,77 98,92 75,96 DEPT 13 - EXCESS REVENUES OVER (UNDER EXPENDITURE $ (146,7381$ (102,778)$ (98,923)$ (75,966 Page 38 pFAW_EST- ��AKE AC4� Goals & Objectives - FY 06/07 EMERGENCYSERV/CES Program Description ..................................................................................................................... The Department of Public Safety provides the public safety needs of the Town via a variety of programs and services. The majority of these services are Fire and Emergency Medical Services (EMS) related but also includes Law Enforcement activities, especially those supporting the Courts in security and warrant collection. The Department continues to support and assist other Town Departments in the delivery of their services as well as provide personnel and services to Westlake Academy in the form of medical care, education, and security. Many civic organizations also benefit from these types of services. Business organizations have benefited through the training activities and inspection / prevention programs that the Department provides. The Department will continue to provide the most efficient method of delivering the traditional services - Fire Protection and Prevention, Emergency Medical Services, and Law Enforcement - while partnering with other towns and cities, as well as private and public, organizations to expand services. Trends ..................................................................................................................... 1. The Department currently provides Fire and EMS services portion of the triad of services for the Town's Public Safety needs. While the Department is not a fully integrated Department of Public Safety, it has and will continue to deliver a limited amount of the remaining leg of the triad of services - Law Enforcement - by partnering with the Courts. Under these services, the growth trend continues: ALARM RESPONSES • From FY 03/04 to present, the Department has experienced a 26% increase in call volume. The increase has demonstrated a steady climb in the number of emergency calls. EMS emergency demonstrates a slight lead in pacing the increase. o FY 03/04 actual was 252 emergency calls ■ Fire 114 • EMS 138 o FY 04/05 actual was 271 emergency calls • Fire 131 • EMS 140 o FY 05/06 year end projection is 340 emergency calls ■ Fire 175 projected ■ EMS 165 projected o FY 06/07 projection is 400 emergency calls • Fire 192 projected • EMS 207 projected INSPECTIONS • From FY 03/04 to present the Department has experienced a 69% increase in inspections. o FY 03/04 actual was 10 inspections ■ Bulk of the remaining inspections were contracted out with the Town of Trophy Club o FY 04/05 actual was 82 inspections • Mainly residential inspections • City of Southlake performed the bulk of the commercial / business inspections. o FY 05/06 year end projection is 192 inspections ■ The Department now performs all inspections for the Town. ■ These include residential, commercial / business, and in-service annual company inspections. o FY 06/07 projection is 214 inspections ■ The Department now performs all inspections for the Town. • These include residential, commercial / business, and in-service annual company inspections 2. Department personnel have received certification as Peace Officers and will continue utilize this training on a limited basis in Court and Academy/Town Security activities. • Seven (7) full time personnel are now police certified o One (1) full time employee is currently attending the Police Academy. • Eight (8) part time personnel are now police certified - o One (1) part time employee is currently attending the Police Academy • All personnel - full time and part time - are certified as firefighters and paramedics as a minimum. Page 39 ?• i O' We4t"eoo Goals & Objectives - FY 06/07 EMERGENCYSER V/CES 3. Personnel certifications and the mandated continuing education associated with these certifications has increased the training requirements. The trend for the next fiscal year will show an increase in this area with the mandated law enforcement continuing education requirements being increased. The State has mandated an additional 16 hours per person in Law Enforcement continuing education and will impact the training activities of the Department. The training trend has been: • FY 03-04 training was approximately 27.5 hours per member - (Totaling 240 hrs/Fire; 10.5 hrs/EMS; 24 hrs/Law Enforcement. The bulk of the personnel during this fiscal year received training through their previous departments. Also, during this fiscal year, three personnel completed the Police Academy. • FY 04-05 training was approximately 24 hours per member - (Totaling 48 hrs/Fire; 160 hrs/EMS; 32 hrs/Law Enforcement. Two personnel completed the Police Academy and one completed paramedic school. New personnel hired during the fiscal year still received the bulk of their training from their previous department. • FY 05-06 (through June 2006) was approximately 68 hours per member - (Totaling 508 hrs/Fire; 172 hrs/EMS; 68 hrs/Law Enforcement. During this fiscal year another member of the Department started the Police Academy and one completed paramedic school. Program Broad Goals ..................................................................................................................... 1. To provide the most economical and efficient service to the Town as possible. 2. Continue to improve services and support other Town Departments, i.e. Municipal Court in reducing outstanding warrants, Public Works in maintaining and mapping the Town's infrastructure, and assisting the Building Official with code compliance issues. 3. Plan for the future by training personnel to assume the roles that are currently contracted out, such as the Fire Marshals' duties. Program Objectives FY 2005/2006 - Ongoing ..................................................................................................................... 1. Enhance revenue streams to fund public safety needs and activities. 2. Continue training personnel to phase out the current contractual services Program Objectives FY 2005/2006 - Completed ..................................................................................................................... 1. Took over all residential inspections that were previously conducted by the Southlake Fire Marshal's Office. Personnel continue to gain experience and training in the commercial / industrial inspections and are now handling approximately 95% of all commercial /industrial inspections. The Department has also implemented an annual "In -Company" Inspection Program for all non-residential occupancies. 2. Transitioned from a paper EMS billing service to a computer internet based system. The approval by the Board of Intermedix, Inc. allows the Department to electronically submit EMS patient information in real time and track the billing process via the internet. 3. Conducted numerous CPR class and trained individuals at the Solana Fitness Center in the use of automatic external defibrillators (AED). The Department will continue this trend and expand the programs in the next fiscal year. (On going) With regards to this program, the Department participated in an informational seminar for AED use with the cooperation of Hillwood Properties, the tenants in the Alliance Corridor, the Town of Roanoke, and Medstar Ambulance Authority. Key Town and Academy personnel have been trained in the use of these devices. 4. Successful in obtaining State and Federal grants. The key funding from these grants allowed the purchase of a CAFS brush fire skid unit and additional AEDs for the Town and Academy. 5. Department personnel completed and enrolled in the Police Academy at Tarrant County College. 6. Along with Public Works and the Building Officials, the Department saw the successful remodeling and occupancy of the buildings in Solana - Campus Drive location by First American Mortgage Corporation. Program Objectives FY 2006/2007 Objectives carried forward 1. Enhance revenue streams to fund public safety needs and activities. 2. Complete the current round of the FEMA grant by equipping a quick attack/grass unit and placing it in service. Page 40 ?• i O' We4t"eoo Goals & Objectives - FY 06/07 EMERGENCYSERV/CES Program Objectives FY 2006/2007 /cont/nuedj Objectives planned for current year 1. Continue to test and map fire hydrant locations and flow data. The Department is conducting a water supply analysis for each fire hydrant and locating each based on GPS coordinates to be added to a database usable by the Department and Public Works. 2. Re -instate the Warrant Officer Program to assist in the clearance of warrants and provide additional security for the Courts. 3. Continue required training for all personnel in all disciplines of certification. Personnel trained in specialty areas - HazMat, Law Enforcement, and Technical Rescue will participate in continuing education classes with neighboring jurisdictions. 4. Adopt amended International Codes - 2006 International Fire, Building, Residential, Mechanical, Plumbing, and the Energy Conservation Codes - to meet the Town's requirements. 5. Participate with the other area Towns and Cities in the development of a new Medical Control Program to replace the previous system administered by Baylor Medical System - Grapevine. 6. Establish a vehicle replacement fund. Performance Measures Page 41 Objective Budget FY05/06 Projected FY05/06 Budget FY06/07 1. All employees trained in CPR and AED Jan -06 Jan -06 May -07 2. Conduct residential inspections 100% 100% 100% 3' Conduct business/commercial inspections - 75% 100% 100% For new and existing construction 4. Full participation in the radio re -banding process Sep -06 Oct -06 Oct -06 5. Collection of billable EMS revenue increased 15% 18% 45% 6. Have 25% of part-time employees tri -certified Jul -06 45% tri -certified Sep -07 Jul -06 7. Conduct LETTS program for the Westlake Academy N/A Oct -07 New Measure 8 Public Safety oriented summer camp for Westlake N/A N/A Jun -07 Academy New Measure Increase the interaction and cooperation with the 9 Roanoke and Trophy Club Fire and Police N/A N/A Department in the areas of training and joint New Measure Oct -07 response 0 10, Test and map 100% of the fire -hydrant located Jan -06 Jan -06 100% within Town limits Page 41 ?• i O' We4t"eoo Goals & Objectives - FY 06/07 EMERGENCYSERV/CES Program Provided in Partnership With ..................................................................................................................... • The City of Keller Police Department • The City of Southlake Department of Public Safety • The Town of Roanoke Fire and Police Departments • The Town of Trophy Club Fire and Police Departments • The Town of Flower Mound Fire Department • Dr. John Ansohn, D.O. and Medical Control Partners • 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 • Tarrant County College - Northeast and Northwest Campus • Maguire Partners and the Solana Fitness Center • Tarrant County Arson Task Force • Texas Department of Transportation Program Customers ..................................................................................................................... • Westlake citizens • Business leaders • Visitors to the Town of Westlake • Community businesses in the Solana Complex • Westlake Academy • Builders • Contractors • Developers Page 42 Fiscal Year 2006-2007 Operating Budget Fund 100 - General Fund Adopted Amended Actual Budget Budget FY 04/05 FY 05106 FY 05/06 FIRE/EMS - DEPARTMENT 14 Revenues 34000 14 EMS User Fee $ 33,034 $ 21,000 $ 28,500 $ 38,865 34005 14 FEMA Federal Grant Revenue 1,864 - - 34006 14 Homeland Security Grant 25,842 - 34007 14 NCTTRAC Grant - - 3,163 3,000 34010 14 Fire Code Inspections 1,000 600 400 400 34015 14 Fire Sprinkler Permits 8,900 7,150 9,500 7,150 35111 14 Citation Revenue (generated by firefighters) - - - 72,000 35180 14 Law Enforcement - - 1,331 4,500 39400 14 Misc Revenue 1,581 1,600 1,600 10,000 DEPT 14 - TOTAL REVENU4 $ 72,2201$ 30,3501$ 44,4941$ 135,915 Expenditures 41110 14 EMS Salaries $ 489,440 $ 532,012 $ 490,000 $ 541,318 41120 14 EMS Overtime 32,993 34,000 51,000 34,000 41210 14 Part Time Regular - - 16,000 36,000 41510 14 FLSA Regular 4,985 13,000 6,000 10,000 41515 14 Warrant Officer Overtime 6,350 - - - 41640 14 Auto Allowance 4,819 4,800 4,800 4,800 42110 14 Medical Insurance 69,106 79,176 62,000 68,914 42111 14 Dental Insurance - - 5,086 5,418 42130 14 LTD, AD&D, Life 4,206 5,565 3,750 5,947 42210 14 Social Security 31,475 35,899 36,000 38,819 42220 14 Medicare 7,293 8,396 8,500 9,079 42310 14 TMRS 41,795 42,326 38,400 48,390 42510 14 Unemployment Taxes 728 297 3,500 4,050 42610 14 Worker's Compensation 14,341 17,078 17,078 19,199 DEPT 14 - TOTAL PAYROL 707,531 1 ' 772,549 742,114 825,934 43125 14 Pre-employment Physicals 711.00 - 1,236.00 1,200.00 43135 14 Pre-employment Testing 3,350.70 2,000.00 1,500.00 1,600.00 43140 14 Employee Physicals - 4,675.00 4,000.00 5,225.00 43255 14 Keller Police Contract 685,589.00 710,339.00 710,340.00 729,932.00 43335 14 Supplemental Firemen Labor 51,904.00 108,775.00 21,944.00 - 43336 14 Contracted Services 15,600.00 16,795.00 14,010.00 14,350.00 43337 14 Exterminator Service 246.55 - 270.00 360.00 43405 14 Computer Equip. / Software 466.67 14,575.00 700.00 - Page 43 Fiscal Year 2006-2007 Operating Budget Fund 100 - General Fund Page 44 Actual FY 04/05 Adopted Budget FY 05/06 Amended Budget FY 05/06 44209 44210 14 Cleaning Supplies 14 Facility Supplies 355.17 2,394.44 1,000.00 1,600.00 1,950.00 800.00 2,235.00 1,600.00 47415 15 Furniture/Fixtures - 4,670.00 44211 14 Safety Supplies 949.08 2,000.00 300.00 1,570.00 44212 14 Building Supplies 618.91 1,200.00 600.00 1,200.00 44213 14 Fire Fighter Supplies 1,675.47 1,850.00 2,300.00 5,315.00 44226 14 Misc Hand Tools 246.11 100.00 270.00 350.00 45214 14 Insurance - Auto 4,500.00 5,000.00 3,466.00 3,812.60 45215 14 Insurance - Property 183.11 150.00 171.63 165.00 45305 14 Telephone 2,135.72 2,035.00 2,035.00 2,250.00 45310 14 Mobile Phones 1,080.94 670.00 1,050.00 1,100.00 45315 14 Internet Expense 337.00 800.00 800.00 3,860.00 45325 14 Rentals/Leases - Building 4,810.68 4,815.00 4,815.00 4,815.00 45325 14 Remove and replacement of trailer - - - 2,000.00 45815 14 Travel - Lodging - - 446.00 - 45820 14 Travel Meals 110.95 150.00 150.00 150.00 45825 14 Travel - Mileage - - 228.00 - 45830 14 Training/Seminars/Meetings 2,862.00 6,500.00 3,000.00 11,515.00 45907 14 HVAC Repairs & Maintenance - - 495.42 495.00 45910 14 Mechanical Repair & Maintenance - - 49.56 50.00 46105 14 Office Supplies 443.20 1,200.00 800.00 1,200.00 46106 14 Hospitality Items 18.66 - 60.00 100.00 46115 14 Dues & Subscriptions 5,470.37 7,870.00 7,870.00 7,850.00 46120 14 Postage/Shipping/Supplies 29.48 100.00 183.00 100.00 46125 14 Printing - - 150.00 150.00 46130 14 Books & Printed Materials 236.62 3,500.00 1,695.00 1,200.00 46150 14 Licenses & Registration 1,222.00 1,800.00 960.00 1,400.00 46155 14 Misc. Supplies 419.16 750.00 750.00 1,970.00 46190 14 Misc Expense - - 250.00 1,550.00 46205 14 Utilities - Water/Sewer 2,237.48 2,325.00 2,325.00 2,325.00 46215 14 Vehicle Fuel/Maint/Repairs 13,349.20 21,000.00 22,170.00 29,575.00 46220 14 Utilities - Electric 4,259.53 4,430.00 4,430.00 4,430.00 46225 14 Utilities - Gas 1,161.03 1,665.00 3,400.00 3,400.00 46605 14 Uniforms/Personal Gear 8,576.43 5,780.00 8,000.00 7,332.00 46610 14 Weapons & Accessories 1,826.10 4,250.00 3,035.00 3,800.00 46615 14 Medical Supplies & Equipment 3,456.85 5,650.00 9,150.00 6,300.00 Page 44 Fiscal Year 2006-2007 Operating Budget Fund 100 - General Fund Adopted Amended Actual Budget Budget FY 04/05 FY 05106 FY 05/06 46620 14 FEMA Grant Exp (WL 10%) 177.00 46621 14 FEMA Grant Exp (FEMA 90%) 1,593.00 46622 14 Homeland Security Grant 25,920.25 - - DEPT 14 TOTAL OPERATIONS & MAIN 850,524 1 945,349 842,155 872,502 DEPT 14 TOTAL EXPENDITURE 1,558,054 1 1,717,898 1,584,269 1,698,436 Pagc 45 DEPT 14 - EXCESS REVENUES OVER (UNDER EXPENDITURE $ (1,485,834) $ (1,687,548) $ (1,539,775) $ (1,562,521) Pagc 45 pFAW_EST- ��AKE AC4� Goals & Objectives - FY 06/07 MUNICIPAL COURT Program Description ..................................................................................................................... The Municipal Court program will perform the duties necessary to support municipal judicial functions, assist the public and manage court operations. The program will uphold the integrity of the court and build public trust by providing unbiased quality service and accurate information in an efficient and professional manner. Trends ..................................................................................................................... 1. Warrants have been backlogged an average of 6 months from delinquency to the date of issuance. o FY 03/04 actual warrants ■ issued 2,153 ■ monetary value $533,113 FY 04/05 actual warrants ■ issuance 2,416 ■ monetary value $616,813 FY 05/06 year-end projection ■ Include aged Trophy Club warrants and the additional assistance of a dedicated warrant clerk. ■ issuance of 3,080 ■ monetary value $750,000 2. Citation entry has an average entry time of 1 - 2 business days from date of receipt by the Court. At current, the Court is handling approximately 800 - 850 citations per month. o FY 03/04 actual citation issuance was 6,753 citations = 9,851 individual violations o FY 04/05 actual citation issuance was 8,554 citations = 12,522 individual violations * The statistics for this fiscal year were affected by the SH 114 construction zone. o FY 05/06 year-end projections are 6,750 citations = 9,950 individual violations 3. The clearance efforts of the Warrant Officer have averaged $25,000 per month in both cash and non-cash clearances. o FY 03/04 actual ■ cleared 1,597 ■ total reduction $314,918 o FY 04/05 actual ■ cleared 1,755 ■ total reduction $370,773 o FY 05/06 year-end projections is ■ cleared 1,450 ■ total reduction of $300,000 ■ clearances reduced due to 3 - 4 month anticipated vacancy in warrant officer position 4. Percentage of expenditures in comparison to revenues generated. o FY 03/04 is 38% ■ Revenue $682,990 ■ Expenditures $253,999 o FY 04/05 is 29% ■ Revenue $1,016,238 ■ Expenditure $291,851 * The decrease affected by the higher construction zone fine amounts o FY 05/06 year end projection is 45% ■ Revenues $892,780 ■ Expenditures $396,420 * The increase affected by relocation expenses to Solana office complex o FY 06/07 projection is 40% ■ Revenues $996,780 ■ Expenditures $398,274 Page 46 ?• i O' We4t"eoo Goals & Objectives - FY 06/07 MUNICIPAL COURT Trends (contlnuedj 5. The collection agency has averaged $5,500 per month in cash collections. o FY 05/06 year-end projections $50,000 reduction in delinquent warrants * The collection agency contract began in February 2006. 6. Violation statistics (yearly) for most common offenses Violation FY 03/04 FY 04/05 Projected FY05/06 Speeding 3,058 5,428 4,225 Speeding in construction zone 568 810 7 Ran red light 82 25 35 Ran stop sign 47 48 120 Failure to yield to emergency vehicle 31 26 44 FMFR (no insurance) 1,573 1,802 1,550 Expired Inspection 1,311 905 1,085 Expired drivers license 55 72 90 Expired vehicle registration 753 603 615 Fail to change address 270 546 500 Program Broad Goals ..................................................................................................................... 1. Court staff will provide prompt assistance in a courteous manner. This includes telephone service, mail service and customers who appear in person. 2. Court staff will work to enter tickets in a timely manner and complete daily court deposits. 3. Administrator will strive to remain current on warrant issuance. 4. 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. 5. Court staff will continue to work in conjunction with the collection agency and other involved agencies to reduce the number of outstanding arrest warrants. The collection efforts will be monitored and monthly updates reported to Town Management. Program Objectives - Ongoing ..................................................................................................................... 1. Citation entry within 3 days of receipt in the Court office and deposits completed on a daily basis 2. Provide one Bench or Jury trial date per month, which will allow defendants the opportunity to present their cases to the Judge in an expedient manner. The newly configured Court offices, with a dedicated courtroom, will greatly assist in increasing the trial settings and allow the staff to remain current with this program objective. 3 Remain current on warrant issuance. This is an ongoing process and the success of the objective is directly related to maintaining adequate staffing levels to ensure proper case flow management. Program Objectives FY 2005/2006 -Completed .................................................................................................................. 1. With the addition of a warrant clerk, the Court staff was able to complete the entry, issuance and fine adjustments to the outstanding Trophy Club warrants. 2. The entry of the information will allow the staff to prepare warrant reports and outstanding totals for all warrants, which were issued within the Town of Westlake. 3. The completion of this task also allowed the Administrator to send the delinquent aged warrants to the outside collection agency. Page 47 ?• i O' We4t"eoo Goals & Objectives - FY 06/07 MUNICIPAL COURT Program Objectives FY 2006/2007 ..................................................................................................................... Objectives carried forward 1. Increase warrant collection and clearance rates. The staff will continue to work with a collection agency to timely submit cases for outside collection and increase the clearance of the aged warrants. This objective is also related to the staffing levels in the office - vacant position in the Court office result in delayed submittal of the cases for outside collection. Objectives planned for current year 1. Issue one set of arrest warrants and one set of capias pro fine warrants per month. 2. Begin composition of policy and procedures manual for front office operations. Performance Measures Program Provided in Partnership With ..................................................................................................................... • DPS Employees • Keller Police Department Program Customers ..................................................................................................................... • Court patrons • Attorneys Page 48 Objective Budget FY 05/06 Projected FY 05/06 Budget FY 06/07 1. Conduct one Bench or Jury Trial per month 12 trial dates 5 Bench - 5 Jury 12 trial dates 2 Citations entered within 3 business days of 100% 100% 100% Receipt 3 Increase collections of warrant division in $15,000 Cash $ 11,990 Cash $20,000 Cash both cash and non-cash clearances $10,000 Non -Cash $ 14,375 Non -Cash $ 15,000 Non -Cash 4. Increase monthly case clearance rates 110 average cleared cases 110 average cleared cases 150 cleared cases per per month per month month Decrease time between aged delinquency and 180 days from delinquency 240 days from delinquency 120 days from delinquency 5. submittal to collection agency for outside to submittal to agency to submittal to submittal assistance 6. Process Court deposits daily 100% 80% 100% Program Provided in Partnership With ..................................................................................................................... • DPS Employees • Keller Police Department Program Customers ..................................................................................................................... • Court patrons • Attorneys Page 48 Fiscal Year 2006-2007 Operating Budget Fund 100 - General Fund Revenues 35110 15 Citation Revenue 35111 15 Collection Revenue 35115 15 Citation Refunds 35120 15 Court Technology 35130 15 Court Security 35140 15 Warrant Revenue 35150 15 Warrant Fees 35160 15 NSF Check Revenue 35170 15 Efficiency Fees 35180 15 Law Enforecement 35190 15 Collection Fees 36110 15 Interest Earned $ 809,126 $ 815,000 $ 725,000 $ 725,000 - 97,650 - - (19,519) - (19,000) (19,000) 29,921 22,500 22,500 22,500 22,441 17,500 17,500 17,500 113,886 - 73,000 148,000 50,787 70,000 41,000 70,000 500 500 775 775 - 250 650 650 1,479 700 655 655 18,000 18,000 4,033 1,900 8,700 8,700 39400 15 Misc Income - - 2,000 - 39401 15 Credit Card Admin Fee 3,583 2,000 4,000 4,000 DEPT 15 - TOTAL REVENU $ 1,016,23 $ 1,028,00 $ 894,78 $ 996,78 Expenditures 41110 15 Salaries $ 129,740 $ 161,148 $ 161,148 $ 185,194 41120 15 Overtime 41515 15 Bailliff Security 41516 15 Warrant Officer Security 42110 15 Medical Insurance 42111 15 Dental Insurance 3,272 2,500 2,500 1,850 1,850 - - 1,850 10,000 27,049 43,244 21,047 28,668 1,259 1,962 42130 15 LTD, AD&D, Life 931 1,670 988 2,664 42210 15 Social Security 8,338 10,146 10,146 11,597 42220 15 Medicare 1,932 2,373 2,373 2,712 42310 15 TMRS 9,309 11,963 11,963 15,338 42510 15 Unemployment Taxes 236 135 990 1,350 42610 15 Worker's Compensation 773 4,089 1,330 2,342 DEPT 15 - TOTAL PAYROL 181,58 237,26 217,44 263,67 Pre -Employment Testing 305 305 - 300 43135 15 43310 15 Legal Services - Boyle & Lowry 31,890 20,000 20,000 20,000 43330 15 Legal Services - Judge Services 27,243 30,000 30,000 30,000 43335 15 Contract Labor 677 - 1,060 1,000 43336 15 Contracted Services - 19,004 17,000 43405 15 Computer Equipment - 900 - 44300 15 Copier Repairs/Maint/Copy Chg 750 750 750 44302 15 Copier Lease 45214 15 Insurance - Auto Page 49 3,482 1,380 1,380 1,380 355 391 Fiscal Year 2006-2007 Operating Budget Fund 100 - General Fund 45305 45315 15 15 Telephone Internet Expense - T1 line - - 1,000 1,000 2,857 45325 15 Misc Rental/Lease 1 1,089 2,485 2,593 2,500 45325 15 Misc Rental/Lease 2 - - 318 744 45805 15 Travel - Airfare - - 250 250 45810 15 Travel - Car Rental/Parking 18 - - 25 45815 15 Travel - Lodging 475 350 350 500 45820 15 Travel - Meals 177 200 200 650 45825 15 Travel - Mileage 1,059 880 630 950 45830 15 Training/Seminars/Meetings 1,144 2,250 2,250 1,525 46105 15 Court Office Supplies 3,162 4,500 4,500 4,500 46106 15 Hospitality Items 76 30 163 100 46115 15 Dues & Subscriptions 548 330 330 370 46120 15 Postage & Supplies 1,619 1,500 1,500 1,500 46125 15 Printing 4,796 4,500 7,000 5,000 46135 15 Bank Service Charge 2,946 100 - 100 46140 15 Moving Expense 658 - - - 46160 15 Credit Card Processing 7,493 6,000 6,000 6,000 46165 15 Court Technology 17,580 16,850 30,650 17,100 46167 46170 46171 15 15 15 Court Efficiency Court Security Court TCLEOSE - 2,191 649 - 3,500 650 650 24,987 650 650 3,500 650 46190 15 Misc. Court Expense 28 1,000 100 1,000 46215 15 Vehicle Fuel/Maint/Repairs 727 5,000 3,200 3,200 46220 15 Utilities - Electric - - 2,200 - 46605 15 Uniforms 238 - 108 200 DEPT 15 TOTAL OPERATIONS & MAIN 110,271 102,56 164,07 124,69 Vehicle - - 1,800 - 47412 15 47415 15 Furniture/Fixtures 15,000 - new 15 Court Software - 16,000 DEPT 15 TOTAL CAPITA 16,80 16,00 404,36 DEPT 15 TOTAL EXPENDITURE 291,851 339,82 398,321 Page 50 DEPT 15 - EXCESS REVENUES OVER (UNDER EXPENDITURE $ 724,38 $ 688,17 $ 496,45 $ 592,411 Page 50 pFAW_EST- ��AKE AC4� Goals & Objectives - FY 06/07 PUBLIC WORKS Program Description The Public Works Department is responsible for: the operation, maintenance, repair, and installation of the water distribution, waste water collection, and duct bank system, inspecting and maintaining the Town's traffic signs, signals, roadway markings, and street pavement. Public Works also assist other departments, the Academy, and volunteer groups as needed: • Provide back-up coordinating/inspecting work for facility maintenance, • Setting up Arbor Days, providing traffic control devices for DPS use • Supervision of community service workers. Trends The Town experienced a surge in maintenance costs during the 05/06 FY as a result of two unrelated significant system failures. These failures could not be determined to be a result of pumping operations relating to an increase in water demands. 1. Water and Sewer Revenues: • FY 03/04 actual was $1,100,368 • FY 04/05 actual was $1,472,182 (33.79% growth) • FY 05/06 year end projection is $1,619,505 (10.01 % growth) • FY 06/07 projection is $1,848,000 (14.11 % growth) 2. City of Fort Worth Water Purchases: • FY 03/04 actual was $200,977 • FY 04/05 actual was $434,670 (116% increase) • FY 05/06 year end projection is $430,000 (1.07% decrease) • FY 06/07 07 projection is $500,000 (16.28% increase) 3. Water consumption • FY 03/04 was 150,869,000 gallons • FY 04/05 was 222,311,000 • FY 05/06 year end projection is 425,000,000 gallons • FY 06/07 projection is 450,000,000 gallons 4. City of Fort Worth peak Payments: • FY 03/04 actual was $131,141 • FY 04/05 actual was $157,739 (20.28% growth) • FY 05/06 year end projection is $195,000 (23.62% growth) • FY 06/07 projection is $185,000 (5.13% decrease) 5. New Utility customers added • FY 03/04 added 20 new utility customers (total of 204) (11 % growth) • FY 04/05 added 90 new utility customers (total of 294) (44% growth) • FY 05/06 year end projection is 51 new utility customers (total of 345) (17% growth) • FY 06/07 projection is 30 new utility customers added (total of 375) (9% growth) Program Broad Goals 1. To efficiently and effectively provide a safe and reliable potable water distribution, wastewater collection, and duct bank system for the Town's customers. 2. Maintain preventative maintenance schedules for water, wastewater and streets facilities to minimize emergency service disruptions and repair costs. 3. To complete the transfer of the N-1 sewer line from Westlake/Southlake to TRA. 4. To promote water conservation efforts; thereby saving water customers money. 5. Maintain streets in safe travelable condition. 6. Maintain accurate inventory of streets and their current condition. 7. Manage all Public Works capital projects to be on schedule and within budget Page 51 ?• i O' We4t"eoo Goals & Objectives - FY 06/07 PUBLIC WORKS Program Objectives Ongoing 1. Respond to all Public Works emergencies (water, sewer, street, duct bank) 2. Conduct water quality and facility inspections required by the Texas Department of Environmental Quality. 3. Inspect, lubricate, fuel, and repair all water and wastewater facilities as required. Program Objectives FY 2005/2006 - Completed 1. Conducted infrastructure quality control inspections of all new installations and maintenance bond items. 2. Implemented "real-time" meter reading system of Mahotea Boone Trail for a pilot project review. 3. Retained resource for sanding/salting roadways during freezing conditions 4. Evaluated water, wastewater rates and tap fees. 5. Rehabilitated approximately 4,000 LF of Dove Road Program Objectives FY 2006/2007 Objectives carried forward 1. Implement a meter testing and replacement schedule for the Town's water meters every five years. Meter replacement will be reflective of proposed "real time" meter reading equipment. 2. Maintain prioritized list of street maintenance needs based on sub -grade, paving, and drainage conditions. 3. Develop a schedule for the full scale implementation of the "real time" meter reading system. 4. Repair all manholes, clean outs, and sewer lines to reduce groundwater infiltration. Objectives planned for current year 1. Continue to work on updating utility maps for the water, wastewater, and duct bank systems. 2. Develop a sewer cleaning maintenance program for cleaning the entire system annually. 3. Create a meter reading technology development fee/ordinance as a requirement for new plats that will integrate the Town's (existing) system after successfully conducting pilot program. 4. Approach the City of Keller to explore a public works maintenance agreement for day to day operations. 5. Create a log and monitor complaints for garbage collection services. Performance Measures Page 52 Objective Budget FY05/06 Projected FY05/06 Budget FY06/07 1. Response times for all emergencies 1 hour 1 hour 2 hours 2. % of work orders completed within 2 days 100% 100% 100% 3. % of reduction peak charges 10% In progress 10% 4. % of Duct Bank access calls responded to in one our 100% 100% 100% 5. % of Dig permits reviewed within 5 days 100% 100% 100% 6. Meter Pilot program completion Jul -06 In progress May -07 7. %/# of manholes inspected 50%/250 10%/250 50%/250 8. Reduction of complaints regarding trash collection New Measure New Measure 50% Page 52 �F west SAKE ASA Goals : Objectives 06/07 PuBLIC WORKS Program Provided in Partnership With • City of Keller • City of Southlake • City of Fort Worth • Trinity River Authority • Consultant engineering firms • Tarrant County • Denton County • Meter reading technology consultants Program Customers • Town water and wastewater customers • Commuters • Companies within the Town's duct bank, R.O.W., and easements Page 53 Fiscal Year 2006-2007 Operating Budget Fund 100 - General Fund PUBLIC WORKS - DEPARTMENT 16 Revenues 39400 16 Misc Income $ $ $ $ - DEPT 16 - TOTAL REVENU $ - Is - Is - Is - Expenditures 41110 16 Salaries $ 10,706 $ 11,211 $ 11,211 $ 13,756 42110 16 Medical Insurance 2,028 2,753 2,883 2,613 42111 16 Dental Insurance 1,162 - 187 182 42130 16 LTD, AD&D, Life 119 131 90 128 42210 16 Social Security 588 695 695 853 42220 16 Medicare 122 163 163 199 42310 16 TMRS 980 820 820 1,128 42510 16 Unemployment Taxes 7 7 68 68 42610 16 Worker's Compensation 340 682 682 588 DEPT 16. TOTAL PAYROL 14,890 16,462 16,799 19,515 43211 16 Street Materials - 500 - - 43212 16 Pot Hole Repair (in house repair) 5,295 - 500 200 43213 16 ROW Tree Removal 1,510 2,000 2,295 2,000 43214 16 Street Drainage 7,170 10,000 - 5,000 43215 16 Civil Engineering 1,677 $ (116,315) 44206 16 Warning Devices 1,162 500 1,110 500 44303 16 Road Repairs & Maint. (contractor) 2,566 15,000 8,056 10,000 44304 44305 46215 46220 16 16 16 16 Sign Repair & Maint. ROW Irrigation Vehicle Fuel/Maint/Repairs ROW Electric 1,738 72,977 1,450 600 3,000 25,000 2,900 - 100 72,316 2,500 500 1,500 73,000 4,000 600 DEPT 16 TOTAL OPERATIONS & MAIN 1 96,144 58,900 87,377 96,800 DEPT 16 OPERATING CAPITA - - - - DEPT 16 TOTAL EXPENDITURE 111,034 75,362 104,176 116,315 Page 54 DEPT 16 - EXCESS REVENUES OVER (UNDER EXPENDITURE $ (111,034) $ (75,362)1$ (104,176) $ (116,315) Page 54 r � �TvW*V We4t"ew Goals & Objectives - FY 06/07 FACILITIESMAINTENANCE Program Description ..................................................................................................................... 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 to lack of maintenance. The increase in student growth at the academy will lead to an increase in remodeling of the current town office space into classrooms and new locations for town employees. Trends ..................................................................................................................... 1. As the civic campus ages, maintenance of exterior, landscaping and interior systems will continue to increase. 2. For the FY05/06 school year 700 sq. ft. was remodeled to accommodate the addition of the 8th grade. 3. The court office, town secretary and Texas student housing was relocated to the Solana Business Park and 4,000 sq. ft. were remodeled into classroom. 4. A 45 space, temporary parking lot was constructed on the west side of the gym as a pick up area for the 7th, 8th and 91h grades in FY 05/06 5. All Town staff offices will be relocated off the main campus in 2007. 6. There will be five new classrooms and one office added in Pod F Program Broad Goals ..................................................................................................................... 1. The Maintenance program will schedule timely, preventative maintenance and repair of the Academy and Town to protect the Town's investment in its infrastructure and keep the Academy and Town facilities aesthetically pleasing. 2. Implement a cost effective plan for consumption of utility services according to state law and regulations. 3. Development new classrooms and office space due to the expansion of student population is ongoing. Program Objectives Ongoing 1. Ensured the Christmas Lighting, Arbor Day and Decoration Day have a quality setting 2. Maintain a quarterly and monthly maintenance agreement for the Academy, Solana, Fire Station and Municipal Campus for the following systems: • Cleaning service - Daily and semi-annual, window, carpet and the floors • HVAC and heating - Quarterly • Electrical systems - Quarterly o Security systems - Semi-annual • Fire sprinkler and alarm systems - Annual 3. Maintain the campus landscaping: o Campus - 36 mowings, fertilizations, weed control 4. Maintain the integrity of athletic fields • Athletic Field - 2 field mowings around athletic field • Athletic Field - 36 mowings by staff Program Objectives FY 2005/2006 - Completed ..................................................................................................................... 1. Remodeled three classrooms in Pod E for Academy FY 05-06 2. Develop a new temporary turn around and parking area for the 7th and 8th grade classes on the west side of Pod G. Program 2006/07 Objectives ..................................................................................................................... Objectives carried forward from 2005/2006 1. Support and assist in planning for the arts and sciences building. Not funded 2. Provide monthly energy usage reports and implement best practices by utilizing our climate control systems. Page 55 ?• i O' We4t"eoo Goals & Objectives - FY 06/07 FACILIT/ES MAINTENANCE Objectives planned for current year: 1. Provide new office and parking spaces for town employees off site locations. 2. Install a second soccer field for the 2007 fall soccer teams 3. Remodel all of Pod F (Town Offices) into 5 classrooms and one office Performance Measures Program Provided in Partnership With ..................................................................................................................... • Tri County Electric • Westlake Academy coaches • Glenwyck Farms Home Owners Association Program Customers ..................................................................................................................... • Westlake Academy Employees • Town of Westlake Employees • Town of Westlake Residents • House of Commons Page 56 Objective Budget FY05/06 Projected FY05/06 Budget FY06/07 1. % compliant with fire sprinkler inspection schedule $2,500 $1,500/100% 100% 2. %compliant with alarm system inspection schedule $1,000 $1,000-100% 100% 3. %reduction in cleaning complaints - 50% 30% 4 Complete temporary office space for town employees within budget Moved to Solana $30,000 $15,000Apr-07 5. Town employees relocated $6,000 $4,097 $7,000/Apr-07 6. Complete Pod E within budget $85,000 $83,000 May -07 7 Support and assist in planning for the arts and sciences building Not funded Not funded Jan -07 8. Implement a tracking process for monthly energy usage Not Completed Dec -06 9. Complete budgeted repairs to building and ground $288,425 $200,000/Sep-06 $288,700Sep-07 10 Develop a new temporary turn around and parking area $98,000 $98,000 - ii. Maintain the campus contract services $155,600 $120,000 $153,500 12. Remodel three classrooms in Pod F completed $0 $0 $531,000/Aug-07 13. Court employees relocated to Solana $6,000 $4,097 Program Provided in Partnership With ..................................................................................................................... • Tri County Electric • Westlake Academy coaches • Glenwyck Farms Home Owners Association Program Customers ..................................................................................................................... • Westlake Academy Employees • Town of Westlake Employees • Town of Westlake Residents • House of Commons Page 56 FUND 100 - General Fund Proposed Budget FY 2006/2007 FACILITIES/GROUND MAINTENANCE - DEPARTMENT 17 Revenues 39400 17 Misc Income $ $ $ $ - DEPT 17 - TOTAL REVENU $ - Is - Is - Is - Expenditures 41110 17 Salaries $ 26,539 $ 27,308 $ 27,308 $ 21,093 42110 17 Medical Insurance 3,691 3,407 5,670 3,920 42111 42130 42210 42220 42310 42510 42610 17 Dental Insurance 17 LTD, AD&D, Life 17 Social Security 17 Medicare 17 TMRS 17 Unemployment Taxes 17 Worker's Compensation - 233 1,510 353 2,105 14 318 - 263 1,693 396 1,996 14 1,601 374 221 1,693 396 1,996 135 1,601 272 199 1,308 306 1,730 101 812 DEPT 17 - TOTAL PAYROL 34,762 36,678 39,394 29,741 43337 43338 43339 43340 17 Contract Exterminator 17 Contract Mechanical Maint - LSI 17 Contract Sweeping/Washing 17 Contract Irrigation Maintenance 2,603 5,471 148 4,970 5,000 5,000 1,000 3,000 3,500 5,600 1,000 5,500 5,000 7,000 1,000 4,000 43341 17 Contract Window Cleaning 545 3,000 1,500 3,000 43342 17 Contract Carpet Cleaning 1,605 4,000 4,000 420 43344 17 Contract Median Maintenance 8,338 7,000 19,000 13,000 43345 17 Contract Building Janitorial 38,472 46,000 43,000 6,020 43346 17 Contract Building Maintenance 7,500 29,000 32,000 16,000 43347 17 Contract HVAC Maintenance 7,994 11,000 11,000 12,000 43348 17 Landscape Maint Civic Campus 27,179 32,000 32,000 33,500 43350 17 Contract Security Monitoring - 700 1,000 1,600 43351 17 Contract Wastewater Treatment 1,570 2,400 2,400 2,400 43352 17 Contract Electrical/Lighting 11,500 11,500 11,500 12,500 43353 17 Contract Sanitation/Waste Removal 313 - 2,000 2,000 43354 17 Contract Security Maintenance 9,255 10,000 10,000 3,000 44210 17 Facility Supplies 5,559 6,000 6,000 350 44212 17 Building Supplies 1,391 4,000 4,000 4,000 44213 17 Electrical Supplies 691 4,500 4,500 5,000 44216 17 Ground Supplies 2,295 4,000 4,000 4,500 44217 17 HVAC Supplies 313 - 100 100 44218 17 Lamp/Bulb Supplies 2,665 3,500 4,500 4,500 44219 17 Mechanical Supplies 1,099 5,000 5,000 5,500 44220 17 Painting Supplies - 2,000 3,500 6,000 44221 17 Communication Supplies 552 700 700 - Page 57 FUND 100 - General Fund Proposed Budget FY 2006/2007 44224 44225 44226 17 Sanitation Supplies 17 Water Treatment Supplies 17 Misc Hand Tools 1,288 1,158 937 3,000 4,000 1,200 3,000 3,000 1,200 2,500 4,000 1,400 44306 17 Grounds maintenance - 12,000 12,000 12,000 45310 17 Mobile Phone 1,032 1,200 1,200 1,200 45315 17 Internet Expense - DSL Line 379 700 700 700 45325 17 Rental - Misc Equipment 181 3,000 3,000 3,000 45810 17 Travel - Car Rental/Parking - - 20 - 45820 17 Travel - Meals - - 40 - 45830 17 Training/Seminars/Meetings 1,189 4,500 4,500 4,500 45901 17 Audio Visual R&M 977 1,000 1,500 6,000 45902 17 Electrical R&M 3,532 4,000 4,000 4,000 45903 17 Elevator R&M 683 1,500 1,500 1,500 45904 17 Plumbing R&M 2,254 1,000 2,150 4,000 45905 17 Fire Sprinkler R&M 2,688 3,500 3,500 3,500 45906 17 Fire/Life Safety R&M 145 5,000 5,000 5,000 45907 17 HVAC R&M 9,994 2,000 2,000 4,500 45908 17 Building Interior R&M 486 2,200 3,000 6,000 45909 17 Building Exterior R&M 105 5,000 5,000 6,000 45910 17 Lawn Mower R&M 40 2,500 1,215 2,500 46105 17 Office Supplies 151 500 500 500 46115 17 Dues & Subscriptions 481 900 900 900 46130 46150 46190 46215 46605 17 Books & Printed Materials 17 Licenses & Registrations 17 Misc Expense 17 Vehicle Fuel & Maintenance 17 Uniforms 31 180 2,280 327 149 - 500 4,000 - 1,000 - 500 800 400 500 - 500 2,500 500 1,000 DEPT 17 TOTAL OPERATIONS & MAIN 172,693 264,500 278,425 230,590 47411 17 Mechanical Equipment 8,239 10,000 - DEPT 17 TOTAL CAPITA 8,239 10,000 - - DEPT 17 TOTAL EXPENDITURE 215,694 311,178 317,819 260,331 NOTE: $223,885 (representing 86%) of this budget is a direct contribution to Westlake Academy based on the allocation of square footage usage by the Academy. All contracts are between the vendor and the Town of Westlake; therefore, payment will be made through the Town. Page 58 DEPT 17 - EXCESS REVENUES OVER (UNDEa I R EXPENDITURE $ (215,694) $ (311,178) $ (317,819) $ (260,331) NOTE: $223,885 (representing 86%) of this budget is a direct contribution to Westlake Academy based on the allocation of square footage usage by the Academy. All contracts are between the vendor and the Town of Westlake; therefore, payment will be made through the Town. Page 58 ?• i O' We4t"eoo Goals & Objectives - FY 06/07 FINANCE -ACCOUNTING] Program Description The Finance Department program maintains the Town of Westlake and the Westlake Academy Foundation financial system and fiscal controls, i.e. general ledger, payroll, accounts payable, accounts receivable, and cash management. The Department works with the Education Service Center (Region XI) to maintain the Westlake Academy Charter School financial system and fiscal controls, i.e. general ledger, payroll, accounts payable, and cash management. The program is also responsible for the coordination of the financial statement audit for the Town as well as the Academy and the preparation of monthly reports and special reports for each. The Utility Billing section of the Finance program provides for the accurate and timely billing of the Town's water and sewer services, assists customers in applying for service, transferring service or discontinuing utility service, and responds to customer inquiries and disputes regarding their utility account. Trends 1. Processing of Accounts payable and payments to vendors: Town • FY 03/04 actual was 2,116 invoices • FY 04/05 actual was 2,611 invoices • FY 05/06 year end projection is 2,618 invoices • FY 06/07 projection is 2,750 invoices Westlake Academy • FY 03/04 actual was 604 invoices • FY 04/05 actual was 768 invoices • FY 05/06 year end projection is 790 invoices • FY 06/07 projection is 800 invoices 2. Contractor registrations: Average time to process registrations: FY 03/04 had 117 registrations = 29.25 hours for the year FY 04/05 had 120 registrations = 30.00 hours for the year FY 05/06 year end projection is 82 registrations = 20.50 hours for the year FY 06/07 projection is 66 registrations = 16.5 hours for the year 3. Building permits applications: Average time to process a building permits: • FY 03/04 had 169 permits = 42.25 hours for the year • FY 04/05 had 226 registrations = 56.50 hours for the year • FY 05/06 year end projection is 171 permits = 42.75 hours for the year • FY 06/07 projection is 132 permits = 33 hours for the year 4. Utility billing: New Utility customers added • FY 03/04 added 20 new utility customers (total of 204) (1 1 % growth) • FY 04/05 added 90 new utility customers (total of 294) (44% growth) • FY 05/06 year end projection is 51 new utility customers (total of 345) (17% growth) • FY 06/07 projection is 33 new utility customers added (total of 378) (9% growth) Average time to open and set up a new account: • FY 03/04 added 20 new utility customers = 10 hours for the year • FY 04/05 added 90 new utility customers = 45 hours for the year • FY 05/06 year end projection is 51 new utility customers = 25.5 hours for the year • FY 06/07 projection is 33 new utility customers = 16.5 hours per year) Page 59 ?• i O' We4t"eoo Goals & Objectives - FY 06/07 FINANCE -ACCOUNTING] Trends (contlnuedj 4. Utility billing: (continued) Average time to receive, prepare and process payments: FY 03/04 total utility customers was 204 = 10.20 hours per month x 12 months = 122.40 hours for the year FY 04/05 total utility customers was 294 = 14.70 hours per month x 12 months = 176.40 hours annually FY 05/06 projected total utility customers is 345 = 17.25 hours per month x 12 months = 207.00 annually FY 06/07 projected total utility customers is 378 = 18.90 hours per month x 12 months = 226.80 annually Accounts receivable aging percentages: Program Broad Goals 1. 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). 2. Provide sound and conservative fiscal management in compliance with all state and federal regulations. 3. Continue to improve on inter -department accounting procedures and internal control systems to ensure data integrity and ease of financial information tracking. 4. Achieve efficient and effective collection of delinquent accounts regarding Utility billing. Program Objectives - On -Going 1. Continued to provide monthly reports and support to all departments and Board. 2. Reviewed insurance coverage and premiums 3. 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. 4. Monitor accounts receivable aging report to ensure that current aging is at a minimum of 80% and use appropriate collection methods following State and Federal collection laws to collect delinquent accounts owed to the Town Program Objectives FY 2005/2006 - Completed 1. Documented accounting policies and procedures for the Town and Academy. 2. Analyzed and reviewed STW software option for upgrade from DOS based system - Proposed in FY 06/07 budget. Program Objectives FY 2006/2007 Objectives carried forward: 1. Integrate billing option into the Town's website by creating means to pay water bills, fees, etc. on line. - No funding in FY 05/06 Objectives planned for current year: 1. Systematically add information, charts and graphs to budget packet to give more detail to the user. Research and work towards preparing and submitting the budget to GFOA for recognition by FY 07/08. 2 Deliver required quarterly investments reports to the Board of Aldermen by the 15th of each quarter 3. Research process and work towards preparing and submitting a CAFR for GFOA recognition by FY 07/08. Page 60 Current 30 day 60 day 90 day • FY 04/05 actual 70.24% 22.46% 5.84% 1.46% • FY 05/06 year end projection 73.75% 17.25% 5.25% 3.75% • FY 06/07 projection 80.00% 13.00% 5.00% 2.00% Program Broad Goals 1. 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). 2. Provide sound and conservative fiscal management in compliance with all state and federal regulations. 3. Continue to improve on inter -department accounting procedures and internal control systems to ensure data integrity and ease of financial information tracking. 4. Achieve efficient and effective collection of delinquent accounts regarding Utility billing. Program Objectives - On -Going 1. Continued to provide monthly reports and support to all departments and Board. 2. Reviewed insurance coverage and premiums 3. 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. 4. Monitor accounts receivable aging report to ensure that current aging is at a minimum of 80% and use appropriate collection methods following State and Federal collection laws to collect delinquent accounts owed to the Town Program Objectives FY 2005/2006 - Completed 1. Documented accounting policies and procedures for the Town and Academy. 2. Analyzed and reviewed STW software option for upgrade from DOS based system - Proposed in FY 06/07 budget. Program Objectives FY 2006/2007 Objectives carried forward: 1. Integrate billing option into the Town's website by creating means to pay water bills, fees, etc. on line. - No funding in FY 05/06 Objectives planned for current year: 1. Systematically add information, charts and graphs to budget packet to give more detail to the user. Research and work towards preparing and submitting the budget to GFOA for recognition by FY 07/08. 2 Deliver required quarterly investments reports to the Board of Aldermen by the 15th of each quarter 3. Research process and work towards preparing and submitting a CAFR for GFOA recognition by FY 07/08. Page 60 ?• i O' We4t"eoo Goals & Objectives - FY 06/07 FINANCE -ACCOUNTING] Performance Measures Program Provided in Partnership With • Region XI Education Service Center • Third party printing and delivery of utility billing Program Customers • Westlake Academy Employees • Town of Westlake Employees • Westlake Academy Foundation • Westlake Water & Sewer customers • Westlake Historical Board • Westlake Historical Preservation Society Page 61 Objective Budget FY05/06 Projected FY05/06 Budget FY06/07 1. Bank statements reconciled within 30 days 1007o 100% 1007. 2 Monthly financials sent to department head by 15th of 100% 70% 100% each mo. 3 Complete and deliver audit report by February of Feb '06 Mar '06 Feb '07 subsequent year 4 Average number of days from received date to 30 days 22 days 30 days payment date. 5 Quarterly reports delivered to Board by 20th of each 100% 100% 100% quarter -end 6. Utility accounts receivable aging at 60+days 7% 7% 5% 7. Quarterly Investment reports delivered to Board by 15th 100% 100% 100% of each quarter -end Program Provided in Partnership With • Region XI Education Service Center • Third party printing and delivery of utility billing Program Customers • Westlake Academy Employees • Town of Westlake Employees • Westlake Academy Foundation • Westlake Water & Sewer customers • Westlake Historical Board • Westlake Historical Preservation Society Page 61 ?• i O' We4t"eoo Goals & Objectives - FY 06/07 HUMAN RESOURCES Program Description The Human Resources Department operates under the direction of Finance and provides guidance and support to all Human Resources (HR) programs, and facilitates all payroll and benefit related transactions. Trends Given our evolving and complex employment laws and litigation threats, benefit regulations, rising insurance costs, and uncertain general fund revenues, our staff's capacity to address ongoing HR service delivery needs and workplace compliance requirements continue to be challenged. Program Broad Goals 1. Maintain competitive and motivated workforce. 2. Identify and implement skill set and professional development opportunities. 3. Maintain competitive and cost effective benefit package. 4. Insure compliance with State law and best practices by updating Personnel Manual as necessary. Program Objectives Ongoing 1. Continue evaluation of additional employee benefit options that do not result in additional cost to the Town. 2. Conduct annual salary and benefit surveys for the Town of Westlake and Westlake Academy to remain competitive. 3. Review all insurance programs in terms of cost and service and if necessary develop RFP's. Program Objectives FY 2005/2006 - Completed ..................................................................................................................... 1. Completed a comprehensive RFP on all Town and Academy insurance policies. 2. Completed annual salary and benefit surveys for the Town and Academy. 3. Designed and facilitated a comprehensive benefit survey involving 41 metroplex cities. 4. Established a single non-profit trust for insurance premiums. (no -cost) 5. Completed MBA degree in lieu of IPMA certification 6. Updated employee manual with additional/amended policies 7. Completed design for employee intranet portal. Program Objectives FY 2006/2007 ..................................................................................................................... 1. Develop a wellness program for Town Manager and Board consideration. 2. Human Resources Manager to obtain IPMA-CP certification. 3. Implement employee intranet portal. Page 62 ?• i O' We4t"eoo Goals & Objectives - FY 06/07 HUMAN RESOURCES Performance Measures Program Provided in Partnership With • Professional HR associations • Insurance brokers • Outside consultants Program Customers • Town of Westlake Employees • Westlake Board of Alderman • Legal Entities Page 63 Objective Budget FY05/06 Projected FY05/06 Budget FY06/07 i Handbook reviews to update for compliance and best practices Quarterly Quarterly Quarterly 2. Employee evaluations completed on time 90% 0% 90% 3. Employee intranet portal completion N/A N/A Dec -06 4 Present new "no -cost" employee benefit options o the Town Manager 2 2 2 5. Salary surveys complete Jun -06 Jun -06 Jun -07 6. Wellness program presentation to the Board N/A N/A Jan -07 7. Complete Insurance plan reviews Jun -06 Jun -06 Jun -07 8. IPMA-CP certification complete N/A N/A Apr -07 Program Provided in Partnership With • Professional HR associations • Insurance brokers • Outside consultants Program Customers • Town of Westlake Employees • Westlake Board of Alderman • Legal Entities Page 63 Fiscal Year 2006-2007 Operating Budget Fund 100 - General Fund Adopted Amended Actual Budget Budget FY 04/05 FY 05/06 FY 05/06 FINANCE/HUMAN RESOURCE - DEPARTMENT 18 Revenue 39400 18 Misc Income $ $ $ $ - DEPT 18 - TOTAL REVENII $ - Is - Is - Is - Expenditures 41110 18 Salaries 41111 18 Capitalized salary expenditure 41120 18 Overtime 42110 18 Medical Insurance 42111 18 Dental Insurance 42130 18 LTD, AD&D, Life 42210 18 Social Se 42220 18 Medicare $ 99,804 $ 102,945 $ 102,945 $ 105,440 (10,000) (20,000) (20,000) - 5,607 3,500 3,500 3,750 12,719 15,597 11,181 10,204 - 0 685 743 822 936 858 1,031 6,298 6,600 1,454 1,543 6,600 6,537 1,543 1,529 42310 18 TMRS 8,204 7,781 7,781 8,646 42510 18 Unemployment Taxes 65 51 507 486 42610 18 Worker's Compensation 214 419 419 374 DEPT 18 - TOTAL PAYROL 125,187 119,372 116,019 138,740 43135 43245 43250 43405 18 18 18 18 Pre -Employment Testing Financial Consulant Auditor 0 70% Computer Equipment/Software 57 2,500 15,400 791 - 6,500 17,500 1,000 30 6,500 17,500 1,000 250 6,500 16,450 500 44310 18 Accounting Software Maint 6,806 2,625 2,500 1,950 45405 18 Advertising for HR 1,284 750 1,000 750 45610 18 Employee Relations 358 250 525 250 45805 18 Airfare 157 350 - 350 45810 18 Car Rental/Parking 60 100 - 100 45815 18 Lodging 955 1,200 1,200 1,200 45820 18 Meals - 250 250 250 45825 18 Mileage 36 250 250 250 45830 46105 46115 46130 46190 18 Training, Seminars, Meetings 18 Office Supplies 18 Dues & Subscriptions 18 Books & Printed Materials 18 Misc Expense 1,418 1,875 1,770 92 - 3,000 1,800 1,500 100 500 3,000 1,800 1,500 120 500 3,000 1,800 1,500 100 500 DEPT 18 TOTAL OPERATIONS & MAIN 33,558 37,675 37,675 35,700 Page 64 Fiscal Year 2006-2007 Operating Budget Fund 100 - General Fund Adopted Amended Actual Budget Budget FY 04/05 FY 05/06 FY 05/06 new 18 Computer Equipment/Software 2,000 new 18 Accounting Software upgrade 14,875 DEPT 18 TOTAL CAPITA DEPT 18 TOTAL EXPENDITURE 158,745 157,047 153,694 191,315 Page 65 DEPT 18 - EXCESS REVENUES OVER (UNDER EXPENDITURE $ (158,745) $ (157,047) $ (153,694) $ (191,315) Page 65 r - Ace Towoov Goals & Objectives - FY 06/07 PARKS and RECREAT/ON Program Description ..................................................................................................................... The Park and Recreation Department will maintain a 13.5 acre park located in the Glenwyck farms sub -division. The park has 3 ponds with water features, stage and a paved walking path. The trees along road ways and cemetery will be maintained to ensure the safety of the drivers and pedestrians. Westlake Academy and the park, located in Glenwyck Farms, will provide the facilities and space for recreation use to the public. The park at Glenwyck Farms and the Academy campus will host Arbor Day, Bandana Bonanza, Christmas Lighting and Decoration Day. Trends ..................................................................................................................... 1. The completion of the recreational center and the population growth of The Town of Westlake have increased the need for park and recreation programs and services to be offered to citizens of Westlake for the first time. 2. The growth of the academy has limited the use of the facility to provide programs to the residents. 3. Summer and holiday camps offered in 05-06 did not produce adequate revenue to offset the cost to heat and cool the facility. Surrounding communities offer full service recreation facilities to their residents and non-resident as well. 4. The Glenwyck Farm three year sub -division improvement agreement with the developer expired in 2004. The agreement states the town will share equally in the cost of maintaining and improvement of the open space. 5. With the build out of the Glenwyck Farms sub -division there is an increase in use of the park open space and road ways. 6. Conditions of landscape on town owned properties have been impacted as a result of the drought. This will place more pressure on budgets for replacement trees, sod, removal of dead trees, etc. Program Broad Goals ..................................................................................................................... 1. Schedule timely, preventative maintenance and repair in Glenwyck Farms Park, cemetery and road ways to protect the Town's investment in its infrastructure and keep Glenwyck Farms Park, cemetery and road ways aesthetically pleasing. 2. Tree replacement and creation of wild flower areas will be a focus in the upcoming year. Program Objectives - Ongoing ..................................................................................................................... 1. Provide tree trimming for road way and park 2. Athletic Field - 2 field mowings around athletic field 3. Dove Road median and Park - mowing, fertilizations, weed control 4. Maintain the parks, cemetery, road ways landscaping and trails maintenance Program Objectives FY 2005/2006 - Completed ..................................................................................................................... 1. Providing student after school programs - Provided by Westlake Academy 2. Hosted tournaments and/or leagues to increase revenue - 2 basketball tournaments 3. Provided summer youth programs Program 2006/07 Objectives ..................................................................................................................... Objectives for current year: 1. Assess the cost to create a tree farm or develop another alternative for tree reforestation 2. Install proposed soccer field on the west side of the campus depending on capital funding Page 66 r - Ace Towoov Goals & Objectives - FY 06/07 PARKS and RECREAT/ON Performance Measures Program Provided in Partnership With ..................................................................................................................... o Glenwyck Farms Home Owners Association o Texas Tree Foundation • Landscape contractors Program Customers ..................................................................................................................... • Westlake Academy o Town employees • Westlake Residents Page 67 Objective Budget FY05/06 Projected Budget FY06/07 FY05/06 1 Install proposed field on the west side of the campus within N/A N/A $22,000/Jun-07 budget and on time pending capital approval New measurement New Measurement 2. Investigate urban reforestation options New measurement New Measurement Jan -07 3 Dove road median - mowing, fertilizations, weed control, $7,000 $7,000 $9,000/Sep-07 reduce # of replace trees by 10% 4 Park -5 field mows and 36 mows around walkways and opens Snl7( P. $16,500 $16,500 $17,500/Sep-07 5 Provide tree trimming for road way and park once a year or $10,000 $10,000 $5,000/Sep-07 has need 6 Providing student after school programs, Developing and $4,000 $0 $0 implementing an assessment survey for after school programs 7 Host tournaments and/or leagues to increase revenue $2,000 $700 $0 8 Provide summer youth programs $2,000 $1,000 $0 9' Ticket sales for local sporting events and theme parks to $1,000 $0 $0 students and residences, was not offered 10. Total Revenue Glenwyck Farm HOA $23,000 $18,000 $18,000/Sep-07 Program Provided in Partnership With ..................................................................................................................... o Glenwyck Farms Home Owners Association o Texas Tree Foundation • Landscape contractors Program Customers ..................................................................................................................... • Westlake Academy o Town employees • Westlake Residents Page 67 Fiscal Year 2006-2007 Operating Budget Fund 100 - General Fund r r11% no M 1 iviv - Li:r ren i ivli i� i i Revenue 31110 19 Lessons $ - $ 500 $ - $ - 31120 19 Clinics 137 500 - 31130 19 Tournaments 1,793 1,600 500 - 31140 19 Leagues - 2,500 - 32120 19 Kid's Programs 1,338 6,000 300 - 32130 19 Wellness Program - 500 - - 33110 19 Court Fee 250 - 34110 19 Special Events - 75 - - 37500 19 Glenwyck HOA Reimbursement 18,945 15,500 23,000 18,000 39400 19 Misc Income 455 1,000 1,500 1,000 JL DEPT 19 TOTAL REVENU $ 22,6671$ 28,4251$ 25,3001$ 19,000 Expenditures 41110 19 Salaries $ 26,539 $ 27,308 $ 27,308 $ 21,093 42110 19 Medical Insurance 3,691 3,407 5,670 3,920 42111 19 Dental Insurance - 0 374 272 42130 19 LTD, AD&D, Life 233 263 221 199 42210 19 Social Security 1,510 1,693 1,693 1,308 42220 19 Medicare 353 396 396 306 42310 19 TMRS 2,105 1,996 1,996 1,730 42510 19 Unemployment Taxes 14 14 135 101 42610 19 Worker's Compensation 318 1,601 1,601 812 00000009- DEPT 19 TOTAL PAYROL 34,762 36,678 39,394 29,741 43336 19 Contract Services 1,450 4,000 2,000 - 43337 19 Contract Services - ROW Tree Maintenance - - - 4,000 43340 19 Contract Irrigation Maintenance - 2,000 2,000 3,000 43343 19 Contract Trail Maintenance 3,015 8,900 10,900 5,000 43349 19 Landscape Maint GW Farms 18,313 16,500 16,500 17,500 43531 19 Marketing & Promotions - 1,000 1,000 - 44222 19 Recreation Supplies 8,248 10,000 3,000 - 44223 19 Recreation Maintenance - - - 5,000 44306 19 Cemetary Maintenance 9,057 10,000 10,000 10,000 45405 19 Advertising - 2,000 2,000 1,000 45911 19 GWFarms Park Maintenance 12,062 15,000 15,000 14,000 45912 19 HOC Projects - - 2,000 2,000 46106 19 Hospitality Items (coaches/refs) 59 1,000 - - 46120 19 Postage/Shipping/Supplies - 1,000 25 46125 19 Printing - 500 500 46190 19 Misc Expense 35 - - Page 68 Fiscal Year 2006-2007 Operating Budget Fund 100 - General Fund 46215 19 Vehicle Fuel & Maintenance 500 500 46220 19 Park Electricity 91653 6,000 15,000 12,000 43528 19 Fertilizer/Soil for Resale - 435 500 43527 19 Snack Purchases fore Resale 20 43527 19 Drink Purchases for Resale - - 25 - DEPT 19 TOTAL OPERATIONS & MAIN 61,893 77,900 80,905 74,500 DEPT 19 TOTAL EXPENDITURE 96,655 114,578 120,299 104,241 Pagc 69 DEPT 19 - EXCESS REVENUES OVER (UNDER EXPENDITURE $ (73,988)1$ (86,153)1$ (94,999)1$ (85,241) Pagc 69 r TvW*V We4t"ew Professional Services - FY 06/07 INFORMAT/ON TECH/VOLOGY Program Description Information Technology works with the Town Manager to establish IT policy, evaluate and recommend technology solutions for specific departmental needs and provide administrative support to established servers, systems and staff. Trends 1. Scheduled upgrades, systems enhancements and other non-critical expenditures for 05/06 were placed on hold for budgetary reasons, and remain valid recommendations for 06/07. 2. Network and systems security require increasing resources. Westlake has Firewall, anti -SPAM and anti-virus measures in place, but repairing systems after Spyware/Malware infections constitutes the bulk of the staff support burden. 3. Improved information delivery now possible. Sufficient infrastructure is now in place to facilitate enhanced information delivery to staff, citizens and the public via the network. Program Broad Goals 1. Support town departments. Architect, deploy and maintain systems to support departmental objectives with hardware and software technologies. 2. Systems Administration. Maintain IT systems with prudent provisions for security, data archiving and disaster recovery. Program Objectives Ongoing 1. On-going Security assessments to validate the efficacy of existing measures and to evaluate and deploy solutions for new threats. 2. Assist Staff in identifying and implementing information technologies to improve the efficiency and/or security of business processes. Program Objectives FY 2005/2006 - Completed ..................................................................................................................... 1. Security Software updated to most recent version; installed on all Town, Court and DPS systems. 2. VPN network installed over broadband fiber connection at fire station, securing data communications to this remote location. 3. Designed and installed Wide Area Network (WAN) extension, via leased line T1, to Westlake Municipal Court facilities at Solana for support of data and voice traffic. 4. Prototype Automatic Meter Reading AMR Portal functionality in place 5. Wide Area Network (WAN) extension to new Town offices in Solana completed Program Objectives FY 2006/2007 1. AMR integration to Town portal. 2. Design and install WAN extension for Town office staff data and voice support at proposed new location in Solana. Page 70 pF WEST yY��u�t910 �LgKE A�P� Professional Services - FY 06/07 INFORMATION TECHNOLOGY Activities Service Amouni Fund Account Description of Service Number --Consultants to work with staff to define departmental IT needs, establish IT priorities, evaluate products and services, prepare IT budget, research and deploy security measures and develop IT Administration $25,000 General 100.43265.20 effective solutions internally and/or in conjunction with outside Fund vendors. --Systems and Network administration including implementation of planned infrastructure improvements, systems server maintenance, software upgrades, data management and training. Desktop Support $20,000 General 100.43267.20 Desktop support costs only Including staff assistance, repair of Services Fund compromised systems. Software/Hardware $13,000 General 100.43266.20 Annual hardware and software support contracts including Cisco Maintenance Contracts Fund networking and phone systems, etc. AMR Integration to $12,000 Utility 500.16600.00 Integration of Water Meter data into citizen portal. (Water Capital Portal Fund Budget) Miscellaneous Hardware/Software budget for extension, Computer $12,000 General 100.43405.20 maintenance, repair and upgrade of existing systems, and Equipment/Software Fund enhanced security measures including Anti-SPAM/VIRUS/SPYWARE as a roved by Town Manager General 100.43405.20 Miscellaneous graphical enhancements, informational additions to Website Updates $3,000 Fund Website Program Provided in Partnership With • Kaleidoscope Information Services, Inc. • Town of Westlake Employees Program Customers • Westlake Departments • Westlake Staff • Westlake Citizens Page 71 Fiscal Year 2006-2007 Operating Budget Fund 100 - General Fund INFORMATION TECHNOLOGY - DEPARTMENT 20 Revenue 31150 20 Sponsorship/Advertising Revenues $ $ 5,000 $ $ 31155 20 Webhosting Revenue 3,000 31160 20 Real Estate Listing Revenue 2,000 DEPT 20 - TOTAL REVENU $ 1 $ 10,000 $ 1 $ Expenditures 43265 20 Technology Consultant 43266 20 Technology Maintenance Contracts $ 40,147 $ 35,000 $ 15,000 $ 25,000 9,729 11,000 11,000 13,000 43267 20 Systems Admin & Support Services 1,100 10,000 15,000 20,000 43405 20 Computer Equipment - 16,000 10,000 12,000 43415 20 Website Development - 11,000 1,000 3,000 DEPT 20 TOTAL OPERATIONS & MAIN 50,976 83,000 52,000 73,000 DEPT 20 TOTAL EXPENDITURE 50,976 83,000 52,000 73,000 Page 72 DEPT 20 - EXCESS REVENUES OVER (UNDER EXPENDITURE $ (50,976)1$ (73,000)1$ (52,000)1$ (73,000) Page 72 pFAW_EST- ��AKE AC4� Professional Services - FY 06/07 ENG/NEER/NG Program Description Engineering oversees the design and construction of the Town's public street, drainage, water, sanitary sewer and duct bank infrastructure. When public improvements are proposed by a private developer, this program reviews and approves the construction plans to ensure that all work associated with new subdivisions is in compliance with the Town's codes and ordinances. Engineering prepares the construction plans and contract documents for the Town's capital improvement projects. The Engineering program also coordinates the review of all development -related submittals that include plats, zoning cases, site plans and permits. Trends 1. Development activity continues to decrease. 2. We do not anticipate any commercial development during the next fiscal year. 3. Although commercial development activity has not increased, there have been meetings and submittals regarding retail centers in the planning and design stages to be located along SH 114 and SH 170. 4. Public improvements scheduled for next year are the Dove/Ottinger intersection and the Ottinger Road waterline. Program Broad Goals 1. Public improvements for new subdivisions to be constructed in compliance with the Town's codes and regulations. 2. Proposals for new development to conform to the Town's master Land Use Plan, Thoroughfare Plan, Water Distribution Plan, Sanitary Sewer Plan and Open Space/Trail Plan. 3. Thorough and efficient review of all development -related submittals and the timely movement of them through the approval process. 4. Efficient and cost-effective operation of the Town's water and sewer systems. 5. Operate the Engineering program in such a manner that it produces revenue for the Town. Program Objectives FY 2005/2006 - Completed 1. Perform an annual review of the water fund to confirm the operating margin. 2. Update the Town's wafer system computer model to determine the optimum system operational characteristics. Program Objectives FY 2006/2007 Objectives carried forward 1. Review the Town's development fee schedule compared to review time/costs to verify revenue production. 2. Conduct a study of the Town's internal development review process to confirm efficiency and cost-effectiveness. Objectives for current year: 1. Participate in Utility rate Study in conjunction with new water source. 2. Conclude FM 1938 approval process 3. Participate in N1 transfer to TRA Page 73 ES ���AKE ACP��g 10 Professional Services - FY 06/07 ENG/NEER/NG Performance Measures Activities NAME Objective Budget FY05/06 Projected Budget FY06/07 $5,OOC Utility Fund Coordination/Meetings with City of Fort Worth & Trinity FY05/06 1 . %total services covered by development fees Mapping $5,OOC 75% Maintenance of Water & Sewer maps Duct Bank Contracts New measurement New measurement Coordination of leases 2 % revenue over expenditures included in water rate N/A N/A 10% $15,00 Capital Proj. New measurement New measurement $20,OOC 3. FM 1938 water line completion within budget and N/A N/A 100% sewer line schedule New measurement New measurement A formal study is required by TRA as a stipulation of 4. FM 1938 begin construction New measurement New measurement Jun O6 5. % of new duct bank leased vs built Sanitary Sewer Inflow & Infiltration Repair Development Activities 50% General Fund Review of construction plans, subdivision plans, etc. New measurement New measurement General Fund Street, pavement, signage, etc. issues % reduction in Fort Worth water bills achieved by $4,OOC General Fund Drainage problems 6. reducing power usage and minimizing the peak New measurement New measurement 10% demand. generation. Miscellaneous Engineering Fees $10,00 Activities NAME AMOUNT FUND DESCRIPTION Fort Worth/TRA Activities $5,OOC Utility Fund Coordination/Meetings with City of Fort Worth & Trinity River Authority Mapping $5,OOC Utility Fund Maintenance of Water & Sewer maps Duct Bank Contracts $5,OOC Utility Fund Coordination of leases Utility Fund Includes the designing and staking of water line to replace Ottinger Road waterline $15,00 Capital Proj. existing 2" on Ottin er. 9 9 TRA/Southlake N1 Sewer $20,OOC Utility Fund Work necessary for TRA to accept maintenance of N-1 Capital Proj. sewer line Infiltration/Inflow Study of the Sewer System in $75,00 Utility Fund A formal study is required by TRA as a stipulation of Glenwyck and Vaquero. Capital Proj. accepting the N-1 Line. Sanitary Sewer Inflow & Infiltration $2,OOC Perm Cap. MF Sanitary Sewer Inflow & Infiltration Repair Development Activities $15,00 General Fund Review of construction plans, subdivision plans, etc. Street Issues $1,OOC General Fund Street, pavement, signage, etc. issues Drainage Issues $4,OOC General Fund Drainage problems Development Review process analysis and Fee $500 , General Fund Review the process for efficiency and confirm revenue evaluation generation. Miscellaneous Engineering Fees $10,00 General Fund Miscellaneous tasks Page 74 ��AKE AC4�10 Professional Services - FY 06/07 ENG/NEER/NG Program Provided in Partnership With .................................................................................................................... o Graham Associates, Inc. o Alan Plummer Associates, Inc. o RJN, Inc. Program Customers .................................................................................................................... • Citizens of the Town • Developers • Consulting Engineers • Surveyors Page 75 Fiscal Year 2006-2007 Operating Budget Fund 100 - General Fund ENGINEERING - DEPARTMENT 21 Revenue 39400 21 Miscellaneous Income $ $ $ $ DEPT 21 - TOTAL REVENU $ - Is - Is - Is Expenditures 43215 21 General Civil Engineering $ $ 125,000 $ 30,000 $ 30,000 43215 21 Public Works related Civil Engineering 3,400 3,400 5,000 DEPT 21 TOTAL OPERATIONS & MAIN - 128,400 33,400 35,000 DEPT 21 TOTAL CAPITA - - - DEPT 21 TOTAL EXPENDITURE - 1 128,400 33,400 35,000 Page 76 DEPT 21 - EXCESS REVENUES OVER (UNDER EXPENDITURE $ - $ (128,400)1$ (33,400)1$ (35,000) Page 76 Utility Fund Program Summary Fiscal Year 2006/2007 Summary Actual FY 04/05 Adopted Budget FY 05/06 Amended Budget FY 05/06 Adopted Budget FY 06/07 Beginning Cash Balance $ 336,394 $ 289,433 $ 643,898 $ 383,239 Balance Sheet Affect to Cash 232,400 (9,329) 32,811 32,811 Revenue 2,095,626 2,146,770 1,998,335 2,391,888 Payroll & Related Expenses 97,691 100,351 97,746 112,078 Operating and Maintenance Expenses 1,790,994 1,435,612 1,655,103 1,776,296 Operating Capital Expenses - - - 34,500 Capital Project Expenses 59,981 559,390 461,956 302,190 Transfers Out 71,857 122,000 77,000 102,000 Ending Cash Balance $ 643,898 $ 209,521 $ 383,239 $ 480,874 Restricted Funds 388,357 75,000 75,000 85,000 Ending Balance $ 255,540 $ 134,521 $ 308,239 $ 395,874 # Days Operating (w/o capital) 49 32 64 77 Restricted/Designated Funds Actual FY 04/05 Adopted Budget FY 05/06 Amended Budget FY 05/06 Adopted Budget FY 06/07 Water & Sewer Deposits $ 77,410 $ 75,000 $ 75,000 $ 85,000 Fidelity Waterline 310,947 - Total Restdcte&Desi nated Funds $ 388,357 $ 75,0001 $ 75,000 $ 85, 000 *" 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. Page 77 Fiscal Year 2006-2007 Budget Fund 500 - Utility Fund REVENUE 33700 11 Private Contributions $ 370,551 $ 350,890 $ 16,010 $ - 34410 11 Water Revenue 1,151,693 1,280,505 1,474,750 1,843,438 34411 11 DS-Hillwood Service Area 34,768 44,000 44,000 44,000 34412 11 DS -Town Service Area 22,896 36,000 36,000 36,000 34420 11 Sewer Revenue 262,826 259,000 259,000 323,750 34421 11 Sewer Revenue - Keller 0 0 625 1,200 34430 11 Water Tap Fees 49,003 66,150 45,000 40,000 34440 11 Sewer Tap Fees 14,375 20,625 15,000 15,000 34450 34470 36110 36200 36201 39400 11 11 11 11 11 11 Ft. Worth Impact Fees Meter Repair/Replacement Interest Earned Duct Bank Leases TRA Wastewater Settle -up Misc Income 71,857 552 2,416 22,585 82,145 9,959 85,000 100 2,500 0 0 2,000 40,000 2,200 25,000 29,250 0 11,500 50,000 2,000 25,000 0 0 11,500 TOTAL UTILITY PAYROLL TOTAL REVENUd $ 2,095,6261 $ 2,146,770 $ 1,;98,3351 $ 2,391,888 EXPENSES 41110 00 Utility Salaries $ 26,606 $ 33,634 $ 33,634 $ 41,268 42110 00 Medical Insurance 8,519 8,258 7,043 7,839 42111 00 Dental Insurance 0 0 450 545 42130 00 LTD, AD&D, Life 59 394 273 383 42210 00 Social Security 1,707 2,085 2,085 2,559 42220 00 Medicare 401 488 488 598 42310 00 TMRS 2,603 2,459 2,459 3,384 42510 00 Unemployment Taxes 20 20 203 203 42610 00 Worker's Compensation 1,019 2,045 2,045 1,765 TOTAL UTILITY PAYROLL 40,9351 49,383 48,6801 58,544 41110 11 Administrative Salaries 6,303 6,418 6,418 7,621 42110 11 Medical Insurance 865 1,003 670 720 42111 11 Dental Insurance 0 0 64 49 42130 11 LTD, AD&D, Life 244 79 53 68 42210 11 Social Security 500 398 398 472 42220 11 Medicare 115 93 93 111 42310 11 TMRS 515 469 469 625 42510 11 Unemployment Taxes 32 4 41 41 42610 11 Worker's Compensation 17 26 26 23 TOTAL ADMIN PAYROLL 8,591 8,4901 8,2321 9,730 41110 18 Finance Salaries 34,389 29,546 29,546 31,832 41120 18 Overtime 4,603 2,450 2,450 2,625 42110 18 Medical Insurance 4,048 5,287 3,314 3,455 42111 18 Dental Insurance 0 0 200 245 42130 18 LTD, AD&D, Life 42210 18 Social Securitv Page 78 259 268 244 1.782 1.984 1.984 307 1.973 Fiscal Year 2006-2007 Budget Fund 500 - Utility Fund 42220 18 Medicare 421 464 464 462 42310 18 TMRS 2,491 2,339 2,339 2,611 42510 18 Unemployment Taxes 8 18 172 177 +LU t o I8 vvorKer s Gompensailon 164 ILL ILL I l i TOTAL FINANCE/HR PAYROLLI 48,1651 42,4781 40,8351 43,804 TOTAL PAYROU1 97,6911 100,3511 97,7461 112,078 43205 43215 43220 43250 43310 43335 43405 11 16 16 16 16 16 16 Administrative Expense Misc Engineering Water Utility Engineer Auditor @ 15% Boyle & Lowry Contracted Labor Computer Equipment 28,962 0 23,446 3,300 6,863 0 1,179 26,659 5,000 76,500 3,750 15,000 7,000 1,000 26,659 5,000 76,500 3,750 15,000 7,000 0 89,771 5,000 15,000 3,525 15,000 7,000 2,000 43533 16 Photo Supplies 0 50 50 50 44105 16 Water Purchases 434,671 430,000 538,893 695,610 44106 16 Water Service Charge 600 600 600 600 44110 16 Peak Payment 157,740 195,000 195,000 257,376 44111 16 Water Tower Landscape Maint 598 6,000 6,000 6,000 44112 16 Water Main Maintenance 334 5,000 50,000 10,000 44113 16 Tower Maintenance 0 1,000 1,000 1,000 44114 16 Sewer Main Maintenanace 3,096 2,500 1,000 2,500 44115 16 TRA Wastewater Treatment 83,284 122,000 150,000 170,000 44116 16 Pump Station Landscape Maintenanace 638 1,530 1,530 200 44117 16 Lift Station Maintenance 1,388 1,950 1,950 2,000 44118 16 Instrument Repairs & Maintenance 521 500 3,000 1,500 44119 16 Ground Storage Tank Maintenance 1,113 1,000 1,000 2,000 44120 16 Southlake / TRA Maintenance 25,725 50,000 50,000 50,000 44121 16 Generator Maintenance 948 1,500 1,500 1,500 44122 16 Bacterial Testing 215 800 800 300 44123 16 Pump Station R&M 0 14,000 14,000 14,000 44130 16 Meter Repair& Replacement 0 0 1,800 2,000 44135 16 Utility Billing 2,799 2,600 2,600 2,900 44210 16 Facility Supplies 0 100 100 50 44211 16 Safety Equipment 0 50 50 50 44220 16 Line Location 1,025 1,500 1,500 1,500 44226 16 Misc Hand Tools 1,269 1,000 500 500 44227 16 Chemical Supplies 100 500 688 500 44310 16 App Software Maintenance 1,916 878 878 1,950 44312 16 Keller Waste Water 0 0 700 1,200 45214 16 Insurance - Automobile 0 465 465 488 45215 16 Insurance - Property 5,358 5,589 3,239 3,401 45305 16 Telephone Service 1,342 1,441 1,441 1,441 45310 16 Mobile Phone 1,063 1,600 900 900 45830 16 Training, Seminars, Meetings 299 800 895 800 Page 79 Fiscal Year 2006-2007 Budget Fund 500 - Utility Fund 46105 46110 46115 46120 16 16 16 16 Office Supplies Office Equipment Dues & Subscriptions Postage & Supplies 44 0 0 131 150 100 420 250 10 100 420 275 150 0 100 600 46125 16 Printing 345 300 450 500 46135 16 Bank Charges 31 35 0 0 46155 16 Misc Supplies 6 0 0 0 46190 16 Misc Expense 293 500 500 0 46205 16 Town Water (15%) 3,591 3,059 750 750 46206 16 Pump Station Water (100%) 0 0 5,500 6,000 46215 16 Vehicle Fuel & Maintenance 1,884 2,900 2,500 4,000 46220 16 Town Electric (15%) 41,458 29,490 3,000 3,000 42661 16 Pump Station Electric (100%) 0 0 67,096 83,870 42662 16 OnLine Meter Electric (100%) 22,896 36,000 130 0 46225 16 Town Gas (15%) 621 337 625 625 46605 16 Uniforms 212 700 250 300 47105 16 Depreciation Expense 413,060 0 0 0 47110 16 Amortization Expense 31,760 0 0 0 47411 16 Mechanical Equipment 0 1,000 1,000 0 47420 16 Water Meters 35,314 30,000 25,000 25,000 47421 16 Water Taps 0 4,000 4,000 4,000 48801 16 Interfund Payable due to GF 0 27,590 27,590 27,590 48806 16 Interfund Payable due to 4B 0 29,731 29,731 29,731 48810 16 DS - Keller OHS - Principal 0 102,540 102,540 56,082 48811 16 DS - Keller OHS - Interest 70,273 137,648 137,648 64,292 48820 16 DS - Hillwood Service Area 34,768 44,000 44,000 44,000 48821 16 DS - Town Service Area 22,896 36,000 36,000 36,000 48823 16 DS - Hillwood - Interest 344,515 0 0 0 new new new new 16 16 16 16 Lease at Solana $12sq ft 6,000 ft (25%) Construction allowance $3 per foot (25%) Moving cost (25%) Utilities Solana/House (25%) 0 0 0 0 0 0 0 0 0 0 0 0 11,095 4,500 2,500 2,000 DEPT 16. TOTAL OPERATIONS & MAIN 1,790,9941 1,435,6121 1,655,1031 1,776,296 new Furniture and Equipment (25%) 0 0 0 12,500 new Equipment Server for Solana (25%) 0 0 0 2,500 new Computer Equipment/Software 0 0 0 2,000 new Accounting Software Upgrade 0 0 0 17,500 DEPT 16. TOTAL OPERATING CAPITAL 01 01 0 34,500 TOTAL EXPENSES 1,888,685 1,535,963 1,752,848 1,922,874 Page 80 Fiscal Year 2006-2007 Budget Fund 500 - Utility Fund CAPITAL PROJECTS 16600 02 Keller Water Line 16600 03 Water Meter Automation 16600 04 Ottinaer Road Waterline 14,146 0 0 0 10,301 37,000 15,000 34,690 0 0 0 85,000 16600 05 TRA Assumption of N1 Sewer 28,024 145,000 120,000 182,500 16600 07 Sewer/Water for Portable Bldgs 0 26,500 0 0 16600 08 Fidelity Waterline 7,510 350,890 326,956 0 TOTAL CAPITAL PROJECTS 59,981 559,390 461,9561 302,190 OTHER SOURCES & USES 62590 99 Xfr Out to Capital Projects Fund 0 0 0 15,000 62510 99 Xfr Out to General Fund 71,857 85,000 40,000 50,000 62600 99 Xfr Out to PCM Fund 0 27,000 27,000 27,000 62600 99 Xfr Out to PCM Fund 0 10,000 10,000 10,000 0 34,500 TOTAL TRANSFERS OU 71,857 122,000 1 = 77,0001 102,000 SUMMARY Total Revenue 2,095,626 2,146,770 1,998,335 2,391,888 Total Pavroll & Related 97,691 100,351 97,746 112,078 Total Operations and Maintenance 1,790,994 1,435,612 1,655,103 1,776,296 Total Operating Capital 0 0 0 34,500 Capital Projects 59,981 559,390 461,956 302,190 Transfers Out 71,857 122,000 77,000 102,000 MW NE $ 75,104 $(7,0583)1 $ 293,469 $ 64,823 CASH SUMMARY Beginning Cash $ 336,394 $ 289,433 $ 643,898 $ 383,239 B/S Affect to Cash 232,400 (9,329) 32,811 32,811 Total Revenue 2,095,626 2,146,770 1,998,335 2,391,888 Total Payroll & Related 97,691 100,351 97,746 112,078 Total Operations and Maintenance 1,790,994 1,435,612 1,655,103 1,776,296 Total Operating Capital 0 0 0 34,500 Capital Projects 59,981 559,390 461,956 302,190 Transfers Out 71,857 122,000 77,000 102,000 NE $ 643,8981$ 209,5211$ 383,2391$ 480,874 Page 81 pF WEST TEAK P , Page 82 Extension of Peak 377 Water Sewer Line GW Farms 100.15205.00 100.48801.16 Water Mains Payment Line 'A" Waterline 500.23001.00 Pymt Payment Beginning $57,600 $95,000 $4,895 $1,515 $2,033 $161,043 Ending Amount Due Amount Due Amount Due Amount Due Amount Due TOTAL # Date Balance Balance 1 01/15/05 $ 161,043 3,840 23,750 4,895 1,515 2,033 $ 36,033 $ 125,010 2 01/15/06 125,010 3,840 23,750 - - - 27,590 97,420 3 01/15/07 97,420 3,840 23,750 1 27,590.00 69,830 4 01/15/08 69,830 3,840 23,750 27,590 42,240 5 01/15/09 42,240 21,120 - 21,120 21,120 6 01/15/10 21,120 21,120 - 21,120 0 $57,600 $95,000 $4,895 $1,515 $2,033 $161,043 Page 82 pF WEST 4 ��qKE ACP Page 83 Glenwyck Fa►ms Watedtine Knox Road Connection 2003 Knox Road Connection 2004 1 200.15205.00 500.23006.00 Pymt # Payment Date Beginning Balance $119,622 $293,842 $119,688 $533,152 Ending Balance Payment Due Payment Due Payment Due TOTAL 0 1 2 3 4 11/17/03 08/15/05 08/15/06 08/15/07 08/15/08 $ 533,152 445,962 416,232 386,501 356,770 - 7,975 7,975 7,975 7,975 87,189 13,777 13,777 13,777 13,777 - 7,979 7,979 7,979 7,979 $ 87,189 $ 29,731 29,731 29,730.85 29,731 445,962.4 416,232 386,501 356,770 327,039 5 08/15/09 327,039 7,975 13,777 7,979 29,731 297,308 6 08/15/10 297,308 7,975 13,777 7,979 29,731 267,577 7 8 9 08/15/11 08/15/12 08/15/13 267,577 237,846 208,116 7,975 7,975 7,975 13,777 13,777 13,777 7,979 7,979 7,979 29,731 29,731 29,731 237,846 208,116 178,385 10 08/15/14 178,385 7,975 13,777 7,979 29,731 148,654 11 08/15/15 148,654 7,975 13,777 7,979 29,731 118,923 12 08/15/16 118,923 7,975 13,777 7,979 29,731 89,192 13 08/15/17 89,192 7,975 13,777 7,979 29,731 59,461 14 08/15/18 59,461 7,975 13,777 7,979 29,731 29,731 15 08/15/19 29,731 7,975 13,777 7,979 29,731 (0) $119,622 $293,842 $119,688 $533,152 Page 83 OFAWF 5j: A ST<AKE ALPO Pps Pow 1 11 TOTAL PAYABLEWESTLAKE'S 271,012 PORTION OF PAYABLE 32% 9 Dade Prindpel Interest TotaI 118,887 $ Payable Prindpa/ Interest Total Balance 1 09/30/01 $ 100,000 $ 271,012 $ 371,012 $ 118,887 $ 32,040 $ 86,847 $ 118,887 $ 1,433,959 2 09/30/02 130,000 243,450 373,450 119,668 41,657 78,012 119,668 1,392,302 3 09/30/03 140,000 235,823 375,823 120,429 44,860 75,569 120,429 1,347,443 4 09/30/04 145,000 227,771 372,771 119,451 46,466 72,984 119,451 1,300,976 5 09/30/05 155,000 219,296 374,296 119,939.49 49,666.94 70,272.55 119,939 1,251,309 6 09/30/06 165,000 210,256 375,256 120,247.11 52,872.65 67,374.46 120,247 1,198,437 7 09/30/07 175,000 200,651 375,651 120,374 56,0821 64,2921 120,373.69 1 1,142,355 8 09/30/08 185,000 189,695 374,695 120,067 59,277 60,790 120,067 1,083,078 9 09/30/09 200,000 177,183 377,183 120,864 64,082 56,782 120,864 1,018,995 10 09/30/10 210,000 165,433 375,433 120,304 67,298 53,006 120,304 951,697 11 09/30/11 225,000 154,558 379,558 121,625 72,100 49,526 121,625 879,598 12 09/30/12 235,000 142,940 377,940 121,107 75,304 45,803 121,107 804,293 13 09/30/13 250,000 130,448 380,448 121,911 80,107 41,803 121,911 724,186 14 09/30/14 270,000 116,793 386,793 123,944 86,513 37,431 123,944 637,673 15 09/30/15 285,000 102,014 387,014 124,015 91,324 32,690 124,015 546,349 16 09/30/16 300,000 86,290 386,290 123,783 96,130 27,653 123,783 450,219 17 09/30/17 320,000 69,390 389,390 124,776 102,541 22,235 124,776 347,678 18 09/30/18 340,000 51,155 391,155 125,342 108,947 16,395 125,342 238,731 19 09/30/19 360,000 31,640 391,640 125,497 115,357 10,140 125,497 123,374 20 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 84 OF WEST BAKE ACP Wc4t"& 100% 90% 80% 70% 60% 50% 40% 30% 20% 10% 0% OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ■ Current o 30-60 Days © 60-90 Days ❑ 90+ Days ■ 90 Day+ DLWLded ACCL Page 85 �F WES)f LAKE ACp� I 350 325 Page 86 322 294 294 AUG SEP N/ 325 325 ,300 - 314 318 306 300 298 309 303 275 294 283 275 270 250- 253 225 244 243 234 227 200 209 215 197 199 201 204 175 184 185 188 189 192 150 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL 3 FY 2004 --W- FY 2005 --W- FY 2006 Page 86 322 294 294 AUG SEP Visitor Association Fund Program Summary Fiscal Year 2006-2007 Summary Actual FY 04/05 Adopted Budget FY 05/06 Amended Budget FY 05/06 Adopted Budget FY 06/07 Beginning Cash Balance $ 843,082 $ 825,076 $ 771,233 $ 828,593 Balance Sheet Affect to Cash 33,187) - 3,229 - Revenues 411,323 453,000 485,000 451,000 Payroll and Related Expenditures 147,497 152,919 123,326 69,323 Operation and Maintenance Expenditures 302,489 297,338 297,543 156,399 ,Operating Ca ital Expenditures 10,000 17,625 Ending Balance 1 $ 771,2331$ 827,8191$ 828,5931$ 1,036,246 " 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. Page 87 pF WEST yY��u�t910 �LgKE A�P� Goals & Objectives - FY 05/06 VISITOR ASSOCIA T/O/V Program Description ..................................................................................................................... The Westlake Visitors Association is responsible for planning, marketing and implementing programs and activities that increase visitation and tourism to the Town of Westlake. Trends ..................................................................................................................... 1. The Marriott Hotel has increased its level of activity with new management and airport transportation. 2. With the update of the Town's website, applications, forms, calendar of events, information on the businesses in Westlake and the Town have become more accessible. Program Broad Goals ..................................................................................................................... Program 2005/06 Objectives - Completed ..................................................................................................................... 1. Increased occupancy at the Marriott from 57% to 62% 2. Worked with businesses regarding marketing/promotion requests 3. Expanded website 4. Worked with Parks and Rec on Arbor Days, Bandana Bonanza, Decoration Day, Holiday Lighting 5. Created information sheet for Town and Academy 6. Weekly press releases sent to all newspapers on Town and Academy 7. Applied for grants for Academy and Historical Board 8. Expanded Masterworks to 6 performances in the spring 9. Worked with Marriott on transportation and events with the Academy and Town of Westlake 10, Press releases sent to residents and parents for Board of Aldermen and/or School Board meetings 11. Displayed a Visitor information rack for the Town lobby 12. Banners and signage created for 50 year celebration 13. Worked with Historical Board on accumulating information for 50 year celebration book 14. Worked with Westlake Academy Foundation Board on events Program Provided in Partnership With ..................................................................................................................... Marriott Solana Fidelity Investments Maguire Partners Historical Preservation Board ARTSNET Westlake Academy Tree City USA Board Local Businesses Program Customers ..................................................................................................................... Visitors Residents Hotel clients Community leaders Businesses Board of Aldermen 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 Page 88 Fiscal Year 2006-2007 Operating Budget Fund 220 - Visitor Association Fund REVENUE 31320 11 Hotel Occupancy Tax $ 381,221 $ 425,000 $ 425,000 $ 400,000 34133 11 Special Events (50 Year) 0 0 8,000 0 34142 11 Historical Board Income 5,688 5,000 20,000 5,000 34143 11 Tree City/Arbor Days Income 4,113 6,000 7,000 6,000 36110 11 Interest Income 20,301 17,000 25,000 40,000 0 42310 TOTAL REVENUd $ 411,3231$ 453,0001$ 485,0001$ 451,000 42510 00 Unemployment Taxes 207 27 270 0 42610 EXPENDITURES 41110 00 Visitor Assoc Salaries $ 82,865 $ 84,630 $ 66,863 $ 436 42110 00 Medical Insurance 11,800 13,629 6,615 0 42111 00 Dental Insurance 0 0 396 0 42130 00 LTD/AD&D/Life Insurance 1,379 1,000 631 0 42210 00 Social Security 5,133 5,247 3,391 0 42220 00 Medicare 1,200 1,227 919 0 42310 00 TMRS 6,868 6,186 4,849 0 42510 00 Unemployment Taxes 207 27 270 0 42610 00 Workers Comp 251 340 151 0 TOTAL VISITOR PAYROLLI 109,7041 112,2861 84,085 D 41110 11 Administrative Salaries 6,266 6,418 6,418 7,621 42110 11 Medical Insurance 746 1,053 618 720 42111 11 Dental Insurance 0 0 63 49 42130 11 LTD/AD&D/Life Insurance 53 79 51 68 42210 11 Social Security 390 398 398 472 42220 11 Medicare 92 93 93 111 42310 11 TMRS 502 469 469 625 42510 11 Unemployment Taxes 31 4 41 41 42610 11 Workers Comp 26 26 30 23 TOTAL ADMIN PAYROLLI 8,1061 8,5401 8,1811 9,730 41110 17 Facilities/Ground Salaries 0 0 0 7,031 42110 17 Medical Insurance 0 0 0 1,307 42111 17 Dental Insurance 0 0 0 91 42130 17 LTD/AD&D/Life Insurance 0 0 0 66 42210 17 Social Security 0 0 0 436 42220 17 Medicare 0 0 0 102 42310 17 TMRS 0 0 0 577 42510 17 Unemployment Taxes 0 0 0 34 42610 17 Workers Comp 0 0 0 271 TOTAL FACILITIES/GROUND PAYROLLI 01 01 01 9,915 Page 89 Fiscal Year 2006-2007 Operating Budget Fund 220 - Visitor Association Fund 41110 18 Finance Salaries 22,980 23,381 23,381 30,123 41120 18 Overtime 45 1,050 1,050 1,125 42110 18 Medical Insurance 2,631 3,686 2,416 2,975 42111 18 Dental Insurance 0 0 147 213 42130 18 LTD/AD&D/Life Insurance 328 213 195 297 42210 18 Social Security 1,426 1,515 1,515 1,868 42220 18 Medicare 334 354 354 437 42310 18 TMRS 1,757 1,786 1,786 2,470 42510 18 Unemployment Taxes 93 12 120 150 42610 18 Workers Comp 93 96 96 106 11 TOTAL FINANCE/HR PAYROLL 29,6871 32,0931 31,0601 39,7641 41110 19 Parks/Rec Salaries 0 0 0 7,031 42110 19 Medical Insurance 0 0 0 1,307 42111 19 Dental Insurance 0 0 0 91 42130 19 LTD/AD&D/Life Insurance 0 0 0 66 42210 19 Social Security 0 0 0 436 42220 19 Medicare 0 0 0 102 42310 19 TMRS 0 0 0 577 42510 19 Unemployment Taxes 0 0 0 34 426iO i9 vvorkers Com 0 0 0 27i TOTAL PARKSIRECPAYROLLI 0 1 1 01 11 0 9,915 TOTAL PA YROLLI 147,4971 152,9191 123,3261 69,323 43205 43250 43310 43405 43415 11 11 11 11 11 Admin Expense Auditor c@ 15% Boyle & Lowry Computer Eqpt/Software Website Development/Maint 28,962 3,300 4,106 199 15,529 26,659 3,000 3,500 500 5,000 26,659 3,000 0 500 0 39,484 3,525 0 0 2,500 43505 11 Historical Board Expense 16,280 10,000 20,000 20,000 43510 11 Tree City 7,498 4,000 7,000 6,000 43515 11 Community Service 4,243 5,000 5,000 0 43526 11 Masterworks 2,000 3,000 3,000 3,750 43529 11 Marriott Marketing 47,870 48,000 48,000 0 43530 11 Marriott Transportation 152,000 156,000 156,000 50,000 43531 11 Marketing & Promotions 4,077 6,000 6,000 4,000 45305 11 Telephone Expense 1,342 1,441 1,441 1,440 45310 11 Mobile Phone 260 400 400 0 45610 11 Special Events (50 year celebration) 0 13,000 8,000 500 45805 11 Travel Airfare 417 500 500 0 45810 11 Travel Car Rental 66 100 100 0 45815 11 Travel Lodqinq 102 500 500 0 Page 90 Fiscal Year 2006-2007 Operating Budget Fund 220 - Visitor Association Fund 45825 45830 46105 46115 11 11 11 11 Travel Mileage Training/Seminars/Meetings Office Supplies Dues & Subscriptions 0 847 1,368 1,876 500 1,090 500 3,250 500 1,840 500 2,500 0 0 0 0 46120 11 Postage & Supplies 132 1,000 1,000 500 46125 11 Printing 1,385 1,000 1,000 500 46190 11 Misc Expense 74 0 0 0 46205 11 Utilities - water 1,508 778 778 780 46220 11 Utilities - electric 4,427 2,283 2,500 2,500 46225 11 Utilities - gas 621 337 825 825 47900 11 Dove Road/Randol Mill 2,000 0 0 0 new new new new 11 11 11 11 Lease at Solana $12 sq ft 6,000 (5 mo)(25%) Construction allowance $3 per ft. (25%) Moving cost (25%) Utilities Solana/House (25%) - - - - - - 11,095 4,500 2,500 2,000 DEPT 11 TOTAL OPERATIONS & MAIN 302,489 297,338 297,543 156,399 new 11 Accounting Software upgrade - 2,625 new 11 Capitalized equipment 10,000 - new 11 Equipment server 25% - 2,500 new 11 Recording devices and furniture (25%) 12,500 TOTAL OPERATING CAPITAL - - 10,0001 17,625 TOTAL EXPENDITURES 449,985 450,257 430,869 243,347 SUMMARY Total Revenue 411,323 453,000 485,000 451,000 Total Payroll & Related 147,497 152,919 123,326 69,323 Total Operations & Maintenance 302,489 297,338 297,543 156,399 Total Operating Capital - - 10,000 17,625 EXCESS REVENUES OVER UNDER EXPENDITURE $ (38,662)1$ 2,743 1 $ 54,1311$ 207,653 CASH SUMMARY Beginning Balance $ 843,082 $ 825,076 $ 771,233 $ 828,593 Balance Sheet Affect to Cash (33,187) - 3,229 Total Revenue 411,323 453,000 485,000 451,000 Total Payroll & Related 147,497 152,919 123,326 69,323 Total Operations & Maintenance 302,489 297,338 297,543 156,399 Total Operating Capital - - 10,000 17,625 NET TOTAL $ 771,2331$ 827,8191$ 828,593 $ 1,036,246 Pagc 91 OF WES)f10 SAKE ACA 500,000 450,000 400,000 350,000 300,000 250,000 200,000 150,000 — — 100,000 50,000 _ o 00 _ O of 0 FY 00/01 FY 01/02 FY 02/03 FY 03/04 FY 04/05 FY 05/06 FY 06/07 actual actual actual actual actual budget budget o Revenues O Expenditures 0 Capital ❑ Marriott Page 92 OF WEST SAKE ASA Page 93 500,000 450,000 400,000 350,000 300,000MM 250,000 200,000 150,000 100,000 50,000 munm 411,323 M490,000 M451yO001 0 FY FY FY FY FY FY FY 00/01 01/02 02/03 03/04 04/05 05/06 06/07 actual actual actual actual actual budget budget Page 93 OF WEST 7 SAKE ASA 450,000 400,000 350,000 300,000 250,000 200,000 150,000 100,000 50,000 0 FY 00/01 FY 01 /02 FY 02/03 FY 03/04 FY 04/05 FY 05/06 FY 06/07 actual actual actual actual actual budget budget W Expenditures Page 94 e Marriott Expense +110% 2% increase decrease -49% +63% decrease increase -14% +40% decrease increase 0 - s_' 0 35,14 ' ' 199,87 �Y• 204,00 �a v 50,000 FY 00/01 FY 01 /02 FY 02/03 FY 03/04 FY 04/05 FY 05/06 FY 06/07 actual actual actual actual actual budget budget W Expenditures Page 94 e Marriott Expense OF WEST SAKE ASA 500,000 450,000 400,000 350,000 300,000 250,000 200,000 150,000 100,000 50,000 0 FY 00/01 FY 01 /02 FY 02/03 FY 03/04 FY 04/05 FY 05/06 FY 06/07 actual actual actual actual actual budget budget W Revenues Page 95 M Marriott Expense Property Tax Reduction Sales Tax Fund Program Summary Fiscal Year 2006-2007 Summary Actual FY 04/05 Adopted Budget FY 05/06 Amended Budget FY 05/06 Proposed Budget FY 06/07 Beginning Cash Balance $ $ $ $ Balance Sheet Affect to Cash Revenue 753,500 Transfers Out 598,953 Ending Balance $ - $ - $ - $ 154,547 '* 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. Page 96 Fiscal Year 2006-2007 Operating Budget Fund 260 - Property Tax Reduction Sales Tax Fund REVENUE 31310 00 Sales Tax Revenue $ $ $ $ 750,000 36110 00 Interest Earned 3,500 TOTAL REVENU $ - Is - Is 1 $ 753,500 TRANSFERS 62580 99 Xfr Out to Debt Service $ $ $ $ 598,953 TOTAL TRANSFERS OU $ - Is - Is 1 $ 598,953 SUMMARY CASH SUMMARY Total Revenue 0 0 0 Transfers Out 0 0 0 598,953 NET TOTAL $ - Is - Is - Is 154,547 Beginning Balance $ $ $ $ B/S Affect to Cash Total Revenue 753.500 Transfers Out 598,953 NET TOTAL $ -is -Is Page 97 4B Economic Development Fund Program Summary Fiscal Year 2006-2007 Summaly Actual FY 04/05 Adopted Budges FY 05/06 Amended Budges FY 05/06 Adopted Budges FY 06/07 Beginning Cash Balance $ 505,456 $ 204,969 $ 221,681 $ Balance Sheet Affect to Cash " 31,064 - (7,810) Revenues 500,481 692,231 796,081 783,231 Transfers In 213,314 - - - Expenditures 530 - - - Transfers Out 1,028,104 897,200 1,009,951 783,231 Ending Balance $ 221,681 $ - $ - $ - ** 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. Page 98 Fiscal Year 2006-2007 Operating Budget Fund 200 - 4B Economic Development Fund REVENUE 31310 00 Sales Tax Revenue $ 497,303 $ 660,000 $ 762,500 $ 750,000 36110 00 Interest Earned 3,178 2,500 3,850 3,500 38805 00 Debt Pymt from OF 0 29,731 29,731 29,731 TOTAL REVENUd $ 500,4811$ 692,2311$ 796,0811$ 783,231 EXPENDITURES 46135 00 Bank Admin Charges $ 530 $ - $ - $ - TOTAL EXPENDITURES 530 0 0 0 OTHER SOURCES & USES 52510 88 Xfr in from General Fund 16 0 0 0 52530 88 Xfr in from Civic Campus 213,297 0 0 0 TRANSERS 1 213,314 0 0 0 62580 99 Xfr Out to Debt Service 1,028,104 897,200 1.009.951 783,231 TRANSERSOU 1,028,104 897,200 1,009,951 783,231 SUMMARY Total Revenue $ 500,481 $ 692,231 $ 796,081 $ 783,231 Total Expenditures 530 0 0 0 Transfers In 213,314 0 0 0 Transfers Out 1,028,104 897,200 1.009.951 783,231 NET TOTAL $ (314,839) $ (204,969) $ (213,870) $ CASH SUMMARY Beginning Balance $ 505,456 $ 204,969 $ 221,681 $ 0 B/S Affect to Cash 31,064 (7,810) - Total Revenue 500,481 692,231 796,081 783,231 Total Expenditures 530 0 0 0 Transfers In 213,314 0 0 0 Transfers Out 1,028,104 897,200 1,009,951 783,231 NET TOTAL $ 221,6811$ Page 99 pp -S <AKE ACA We4t"ew Interfund Repayment Schedule - Due from Utility Fund Glenwyck Farms Knox Road Knox Road Waterline Connection 2003 Connection 2004 $119,622 $293,842 $119,688 Payment Due Payment Due Pawnent Due Pymt Payment Beginning 7,975 # Date Balance 356,770 0 11/17/03 $ 533,152 1 08/15/05 445,962 2 08115106 416.232 - 87,189 7,975 13,777 7 7, 3 08/15/07 200.15205.00 7,975 13,777 500.23006.00 ,'33,152 356,770 Ending TOTAL 356,770 Balance 87,189 $ 445,962 29,731 416,232 29,731 08/15/09 386,501 3 08/15/07 386,501 7,975 13,777 7,979 29,731 356,770 4 08/15/08 356,770 7,975 13,777 7,979 29,731 327,039 5 08/15/09 327,039 7,975 13,777 7,979 29,731 297,308 6 08/15/10 297,308 7,975 13,777 7,979 29,731 267,577 7 08/15/11 267,577 7,975 13,777 7,979 29,731 237,846 8 08/15/12 237,846 7,975 13,777 7,979 29,731 208,116 9 08/15/13 208,116 7,975 13,777 7,979 29,731 178,385 10 08/15/14 178,385 7,975 13,777 7,979 29,731 148,654 11 08/15/15 148,654 7,975 13,777 7,979 29,731 118,923 12 13 08/15/16 08/15/17 118,923 89,192 7,975 7,975 13,777 13,777 7,979 7,979 29,731 29,731 89,192 59,461 14 08/15/18 59,461 7,975 13,777 7,979 29,731 29,731 15 08/15/19 29,731 7,975 13,777 7,979 29,731 (0) $119,622 $293,842 $119,688 $533,152 Page 100 Debt Service Fund Program Summary Fiscal Year 2006-2007 Suarnaly Actual FY 04/05 Adopted Budget FY 05/06 Amended Budget FY 05/06 Adopted Budget FY 06/07 Beginning Cash Balance $ $ $ Balance Sheet Affect to Cash " - Transfers In 1,028,104 1,378,864 1,378,634 1,382,184 Expenditures 1,028,104 1,378,864 1,378,634 1,3827184 Ending Balance $ - $ - $ - $ - *' 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. Page 101 Fiscal Year 2006-2007 Operating Budget Fund 300 - Debt Service Fund Adopted Amended Actual Budget Budget FY 04/05 FY 05/06 FY 05/06 TRANSERS IN 52510 88 Transfer in from GF $ - $ 481,664 $ 368,683 $ 52560 88 Transfer in from 4B 1,028,104 897,200 1,009,951 783,231 new 88 Transfer in from PTR 0 0 0 598,953 MP TOTAL TRANSFERS $ 1,028,104 $ 1,378,864 1 $ 1,378,634 1,382,184 EXPENDITURES 46135 00 Bank Service Charge $ 300 $ 1,060 $ 830 $ 830 48840 00 Debt Service Principal 0 350,000 350,000 370,000 48850 00 Debt Service Interest 1,027,804 1,027,804 1,027,804 1,011,354 TOTAL EXPENDITURES $ 1,028,104 1 $ 378,8641$ 1,378,634 $ 1,382,184 SUMMARY CASH SUMMARY Transfers In $ 1,028,104 $ 1,378,864 $ 1,378,634 $ 1,382,184 Total Expenditures 1,028,104 1,378,864 1,378,634 1,382,184 NET TOTA $ - $ Beginning Cash $ $ $ $ B/S Affect to Cash - Transfers In 1,028,104 1,378,864 1,378,634 1,382,184 Expenditures 1.028.104 1,378,864 1,378.634 1,382,184 NET TOTAL $ - Is - Is - Is Page 102 Sources & Uses Sources Principal Amount of Certificates Cash Premium Total Sources of Funds Uses Available for Improvements Capitalized Interest Cost of Issuance Interest and Sinking Fund Total Sources of Funds 12,400,000 97.10 $ 12,400,097 11,325,590 919,364 155,047 97 $ 12,400,097 1 09/30/03 $ - $ 927,600 $ 927,600 2 09/30/04 0 742,080 742,080 3 09/30/05 0 742,080 742,080 4 09/30/06 210,000 742,080 952,080 5 09/30/07 225,000 728,430 953,430 6 09/30/08 235,000 713,805 948,805 7 09/30/09 250,000 698,530 948,530 8 09/30/10 265,000 682,280 947,280 9 09/30/11 280,000 665,055 945,055 10 09/30/12 295,000 646,855 941,855 11 09/30/13 315,000 627,680 942,680 12 09/30/14 330,000 607,205 937,205 13 09/30/15 350,000 585,755 935,755 14 09/30/16 365,000 563,005 928,005 15 09/30/17 385,000 539,280 924,280 16 09/30/18 405,000 514,255 919,255 17 09/30/19 425,000 490,968 915,968 18 09/30/20 445,000 466,530 911,530 19 09/30/21 470,000 440,943 910,943 20 09/30/22 495,000 413,918 908,918 21 09/30/23 520,000 385,455 905,455 22 09/30/24 550,000 355,555 905,555 23 09/30/25 580,000 323,930 903,930 24 09/30/26 610,000 290,290 900,290 25 09/30/27 640,000 254,910 894,910 26 09/30/28 675,000 217,790 892,790 27 09/30/29 710,000 178,640 888,640 28 09/30/30 750,000 137,460 887,460 29 09/30/31 790,000 93,960 883,960 30 09/30/32 830,000 48,140 878,140 $ 12,400,000 $ 14,824,464 $ 27,224,464 Page 103 Sources & Uses Sources Par Value Accrued Interest Total Sources of Funds uses Deposit to Debt Service Fund Deposit to Construction Fund Original Issue Discount Cost of Issuance Rounding Underwriter's Discount Total Sources of Funds 6,410,000 17,460 $ 6,427,460 17,460 5,900,000 58,388 322,000 1,410 128,203 $ 6,427,460 Pymt # Due Date Principal Inter+esi Total 1 2 09/30/05 09/30/06 $ - $ 140,000 285,724 $ 285,724 285,724 425,724 3 09/30/07 145,000 282,924 427,924 4 09/29/08 145,000 279,444 424,444 5 09/29/09 150,000 275,529 425,529 6 09/29/10 155,000 271,029 426,029 7 09/29/11 160,000 265,914 425,914 8 09/28/12 165,000 260,314 425,314 9 09/28/13 170,000 254,291 424,291 10 09/28/14 175,000 248,001 423,001 11 09/28/15 185,000 241,220 426,220 12 09/27/16 190,000 233,820 423,820 13 09/27/17 200,000 225,840 425,840 14 09/27/18 210,000 217,240 427,240 15 09/27/19 220,000 208,000 428,000 16 09/26/20 230,000 197,550 427,550 17 09/26/21 240,000 186,625 426,625 18 09/26/22 250,000 175,225 425,225 19 09/26/23 260,000 163,350 423,350 20 09/25/24 275,000 151,000 426,000 21 09/25/25 290,000 137,250 427,250 22 09/25/26 300,000 122,750 422,750 23 09/25/27 315,000 107,750 422,750 24 09/24/28 335,000 92,000 427,000 25 09/24/29 350,000 75,750 425,750 26 27 28 09/24/30 09/24/31 09/23/32 365,000 385,000 405,000 57,750 39,500 20,250 422,750 424,500 425,250 $ 6,410,000 $ 5,361,764 $ 11,771,764 Page 104 Capital Projects Fund Program Summary Fiscal Year 2006-2007 Summary Actual FY 04/05 Adopted FY 05/06 Proposed Amended FY 05/06 Proposed Budget FY 06/07 Beginning Cash Balance $ - $ - $ - $ 99,860 Balance Sheet Affect to Cash " 50,129 0 28,470 0 Revenue 141,140 222,237 150,000 1,176,818 Capital Projects 410,669 1,939,962 627,270 2,125,852 Transfers In 219,400 1,717,725 448,800 849,174 Ending Balance $ 0 $ - $ - $ - ** 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. Page 105 Fiscal Year 2006-2007 Capital Projects (General Govemment) Budget Fund 410 - Capital Projects Fund REVENUE 33700 00 Private Contribution - Keller $ 68,903 $ - $ - $ 33700 00 Private Constribution - Tarrant County - 222,237 150,000 33700 00 Private Contribution - Southlake 72,237 33700 00 Private Contribution - WAF - 1,176,818 TOTAL REVENUE1 $ 141,1401 $ 222,2371$ 150,0001$ 1,176,818 CAPITAL PROJECTS 16600 00 Civic Campus Expansion III - Pod F $ $ $ $ 509,000 16600 00 Roanoke & Ottinger Reconstruction - - - 118,174 16600 00 FM1938 Pedestrian Crossing 57,400 200,000 16600 00 High School Soccer Field - - - 22,000 72000 00 Art/Science Building 2,690 1,300,000 108,800 1,176,818 43215 00 FM -I938 Engineering 173,265 222,237 178,470 99,860 72000 00 Civic Campus Expansion II - Pod E 87,921 266,525 260,000 - 73000 00 Temp Parking 9,153 93,800 108,800 74000 00 Portable Buildings - 57,400 - 74400 00 Mall 140,331 - 80,000 - TOTAL CAPITAL PROJECTS 1 410,6691 1,939,9621 627,2701 2,125,852 TRANSFERS IN 52510 88 Xfr In from GF - Civic Campus Exp 3 - Pod F 97,447 266,525 260,000 494,000 52510 88 Xfr In from GF - FM1938 Pedestrian Crossing - - - 200,000 52510 88 Xfr In from GF - Portable Buildings 57,400 - 52510 88 Xfr In from GF - Roanoke & Ottinger Reconstruction - - - 118,174 52510 88 Xfr In from GF - Temp Parking Lot 2,690 93,800 108,800 - 52510 52560 52570 52590 88 88 88 88 Xfr In from GF - High School Soccer Field Xfr In from OF - Civic Campus Exp 3 - Pod F Xfr In from 4A - Mall Xfr In from Other Sources - Art/Science Building - - 119,263 - - - 1,300,000 - - 80,000 - 22,000 15,000 - TOTAL TRANSFERS INI 219,400 1,717,7251 448,8001 849,174 SUMMARY Total Revenue 141,140 222,237 150,000 1,176,818 Total Capital Projects 410,669 1,939,962 627,270 2,125,852 Transfers In 219,400 1,717,725 448,800 849,174 - $ 28,470 $ 99,860 Page 106 Fiscal Year 2006-2007 Capital Projects (General Govemment) Budget Fund 410 - Capital Projects Fund CASH SUMMARY Beginning Cash Balance $ - $ $ - $ 99,860 Balance Sheet Affect to Cash 50,129 28,470 - Total Revenue 141,140 222,237 150,000 1,176,818 Total Capital Projects 410,669 1,939,962 627,270 2,125,852 Transfers In 219,400 1,717,725 448,800 849,174 NE $ (0)1$ - Is - Is - Page 107 74460 Tlofv*v 10/ We4t"460 Civic Campus Expansion - Pod F & Staff Relocation ** General Fund 494,000 Roanoke and Ottinger Road Reconstruction General Fund 118,174 FM 1938 Pedestrian Crossing General Fund 200,000 High School Soccer Field General Fund 22,000 Total General Fund $ 834,174 Art/Science Building Foundation 1,176,818 FM 1938 Contributions 99,860 Total Contributions $ 1,276,678 Civic Campus Expansion - Pod F & Staff Relocation ** Utility Fund 15,000 TRA/Southlake N1 Sewer Line Improvement Utility Fund 182,500 Water Meter Automation Utility Fund 34,690 Total Utility Fund $ 232,190 ** Total project = $509,000 (General Fund 97% ; Utility Fund 3%) Page 108 CAPITAL PROJECT Fiscal Year 2006-2007 ClWe Campus Expansion 9 - Pod F4 & StaffRelbc, on Phase III - Remodel of town offices in Pod F into 5 classrooms and 1 office. All remaining Town staff relocate to Solana. Remodeling of Parchman house for additional work and storage space. $25K NET 1 01 01 01 01 01 0 CAPITAL PROJECT EXPENDITURES 59,256 59,256 247,958 YTD THRU 09/30/06 YTD THRU 09/30106 BUDGET FY06107 FUTURE CAPITAL EXPENDITURES 07108 08109 09/10 09/10 PROJECT TOTAL 05 Purchase 44,380 0 0 0 6,500 0 0 0 0 0 0 0 6,500 10 Design 15 Construction 0 0 0 500,000 0 0 0 500,000 20 Implementation 0 0 0 0 0 0 0 25 Engineering Equipment server 0 0 0 0 0 0 30 Legal Utilities Solana/House 0 1,500 0 0 0 1,500 35 Auditor OPERATING IMPACT TOTAL 0 0 0 0 0 0 40 Payroll & Related 0 0 0 0 0 0 45 Administrative 0 0 0 0 0 0 50 Consultation 0 0 0 0 0 0 60 Postage/Shipping 0 0 0 0 0 0 0 0 0 0 0 0 65 Copies/Reproduction 70 Public Advertisements 0 1,000 0 0 0 1,000 PROJECT EXPENDITURE TOTAL 01 509,000 0 0 1 0 509,000 NET 1 01 01 01 01 01 0 CAPITAL PROJECT FUNDING 59,256 59,256 59,256 247,958 YTD THRU 09/30/06 YTD THRU 09/30/06 BUDGET FY06107 FUTURE FUNDING 07/08 1 08109 09/10 PROJECT TOTAL General Fund Utility Fund Private Contribution 44,380 0 494,000 0 15,000 0 0 0 494,000 0 0 0 15,000 0 0 0 0 0 0 PROJECT FUNDING TOTAL 0 0 1 0 509,0001 0 0 0 509,000 NET 1 01 01 01 01 01 0 GF - Total (Operating) IMPACT ON OPERATING BUDGET 59,256 59,256 59,256 247,958 YTD THRU 09/30/06 BUDGET FY06107 FUTURE OPERATING EXPENDITURES 07/08 08/09 09/10 PROJECT TOTAL Lease at Solana $12 sq ft 6,000 (5 mo) 0 0 44,380 106,512 106,512 106,512 363,916 Construction allowance $3 per ft. 18,000 0 0 0 18,000 Moving cost 118,512 0 10,000 0 0 0 10,000 Furniture and Equipment 0 50,000 0 0 0 50,000 Equipment server 0 10,000 0 0 0 10,000 Utilities Solana/House 0 8,000 12,000 12,000 12,000 44,000 OPERATING IMPACT TOTAL 01 140,3801 118,5121 118,5121 118,5121 495,916 GF - Total (Operating) 50% 70,190 59,256 59,256 59,256 247,958 OF - Total (Operating) 25% 35,095 29,628 29,628 29,628 123,979 VA - Total (Operating) 25% 35,095 29,628 29,628 29,628 123,979 TOTAL 140,380 118,512 118,512 118,512 495,916 " All lease related expenditures will be allocated as follows: GF 50%; OF 25%; VA 25% ' Includes monthly fee for common areas/cleaning/maintenance of $2,876 Page 109 CAPITAL PROJECT Fiscal Year 2006-2007 RoalzoAv & OttinggerRoodReconstruction Project Description: Project will provide stabilization of road subgrade and 2" of HMAC. Roanoke Road will include the area south of Daimler Chrysler to the Town limits (approximately 1000 LF). Ottinger Road will include the area north of the municipal complex to Hwy 170 (approximately 4,500 LF). CAPITAL PROJECT EXPENDITURES LTD BUDGET 09/30/06 06/07 FUTURE CAPITAL EXPENDITURES PROJECT TOTAL 07/08 08/09 09/10 05 Purchase 07/08 08/09 09/10 10 Design 15 Construction - 118,174 118,174 118,174 20 Implementation - 25 Engineering - - - - 30 Legal - - - 118,174 40 Payroll & Related 45 Administrative 50 Consultation 55 Technical 60 Postage/Shipping 65 Copies/Reproduction 70 Public Advertisements Contingencies - PROJECT EXPENDITURES TOTA41 118,1741 - - 118,174 CAPITAL PROJECT FUNDING LTD 09/30/06 BUDGET 06/07 FUTURE FUNDING PROJECT TOTAL 07/08 08/09 09/10 General Fund - 118,174 118,174 - - Utility Fund Private Contribution - - PROJECT FUNDING TOTAL - 118,174 - - - 118,174 IMPACT ON OPERATING BUDGET LTDBUDGET 09/30/06 06/07 FUTURE OPERATING EXPENDITURES PROJECT TOTAL 07/08 08/09 09/10 Supplies - Maintenance Services Equipment OPERATING IMPACT TOTAL - - - - - - Page 110 CAPITAL PROJECT Fiscal Year 2006/2007 FN 1998 Pedestrian CTssin Project Description: Pedestrian crossing under FM 1938 (contingent upon TxDot Funding) CAPITAL PROJECT EXPENDITURES IMPACT ON OPERATING BUDGET LTD BUDGET 09/30/06 06/07 FUTURE CAPITAL EXPENDITURES PROJECT 07/08 1 08/09 09/10 TOTAL 05 Purchase 10 Design 15 Construction - 200,000 20 Implementation General Fund - Utility Fund Private Contribution 200,000 - 25 Engineering - 30 Legal - 35 Auditor - PROJECT FUNDING TOTAL -1 40 Payroll & Related - - - 200,000 - - - - - - 45 Administrative 50 Consultation 55 Technical 60 Postage/Shipping 65 Copies/Reproduction 70 Public Advertisements Contingencies PROJECT EXPENDITURES TOTA - 200,000 - - - 200,000 CAPITAL PROJECT FUNDING IMPACT ON OPERATING BUDGET LTD 09/30/06 BUDGET 06/07 FUTURE FUNDING APROJECT 07/08 08/09 09/10 TOTAL General Fund - Utility Fund Private Contribution 200,000 200,000 Maintenance - Services - PROJECT FUNDING TOTAL -1 200,000 - - - 200,000 Page 111 IMPACT ON OPERATING BUDGET LTD BUDGET FUTURE OPERATING EXPENDITURES PROJECT 09/30/06 06/07 07/08 08/09 09/10 TOTAL Supplies - Maintenance Services - Equipment OPERATING IMPACT TOTAL - - - - - - Page 111 CAPITAL PROJECT Fiscal Year 2006-2007 high School SocaerFie%' The new field would be located on the west side of the current field. The current field will not hold up to the use of Elementary, Junior High and High School girl's and boy's teams. This would include grading, irrigation system, hydro mulching and soccer goals. Work would be scheduled for the Spring of 2007 and ready for play in Spring of 2008. CAPITAL PROJECT EXPENDITURES YTD THRU 09/30/06 BUDGET FY06/07 FUTURE CAPITAL EXPENDITURES PROJECT 07/08 08/09 09/10 TOTAL 05 Purchase - 10 Design 15 Construction 20 Implementation 22,000 - - - 22,000 22,000 - - - 25 Engineering 30 Legal - - 35 Auditor 8,000 - - 40 Payroll & Related - 2,000 - 45 Administrative - 50 Consultation - - - - - 55 Technical - 60 Postage/Shipping - 65 Copies/Reproduction - 70 Public Advertisements - - - PROJECT EXPENDITURES TOTA - 1 22,0001 22,000 CAPITAL PROJECT FUNDING YTD THRU 09/30/06 I BUDGET FY06/07 FUTURE FUNDING PROJECT 07/08 08/09 09/10 TOTAL General Fund - Utility Fund Visitor Fund 22,000 22,000 - - - - PROJECT FUNDING TOTAL - 22,000 - - - 22,000 NET - - - - - - IMPACT ON OPERATING BUDGET YTD THRU 09/30/06 BUDGET FY06/07 FUTURE OPERATING EXPENDITURES PROJECT TOTAL 07/08 08/09 09/10 Supplies Maintenance Services Equipment - - 2,000 - - - - - 2,000 2,000 2,000 - 8,000 - - - OPERATING IMPACT TOTAL - 2,000 2,000 2,000 1 2,000 8,000 Page 112 CAPITAL PROJECT Fiscal Year 2006-2007 Awlseenae Bui/ding Phase I of the Art/Science Building would include three laboratories, 4 offices, workroom, conference room, restroom and entry hallway. The black box and art room would be Phase II to be complete at a future date. NET 1 01 01 01 01 0 0 IMPACT ON OPERATING BUDGET CAPITAL PROJECT EXPENDITURES YTD THRU 09/30/06 BUDGET FY06/07 YTD THRU 09/30/06 YTD THRU 09/30/06 BUDGET FY06/07 FUTURE CAPITAL EXPENDITURES 07/08 08/09 09/10 PROJECT TOTAL PROJECT TOTAL 05 Purchase 0 0 0 0 0 0 0 10 Design 0 0 134,409 0 0 0 134,409 15 Construction 1,176,818 0 800,000 1,307,750 0 0 2,107,750 20 Implementation 0 0 100,000 100,000 0 0 200,000 25 Engineering 01 0 134,409 0 0 0 134,409 30 Legal 0 8,000 8,000 0 0 16,000 35 Auditor 0 0 0 0 0 0 40 Payroll & Related 0 0 0 0 0 0 45 Administrative 0 0 0 0 0 0 50 Consultation 0 0 0 0 0 0 55 Technical 0 0 0 0 0 0 60 Postage/Shipping 0 0 0 0 0 0 65 Copies/Reproduction 0 0 0 0 0 0 0 0 70 Public Advertisements 0 0 0 0 PROJECT EXPENDITURE TOTAL 1 01 1,176,8181 1,415,7501 01 01 2,592,568 NET 1 01 01 01 01 0 0 IMPACT ON OPERATING BUDGET CAPITAL PROJECT FUNDING YTD THRU 09/30/06 BUDGET FY06/07 YTD THRU 09/30/06 BUDGET FY06/07 FUTURE FUNDING 07/08 08/09 09/10 PROJECT TOTAL General Fund 0 0 0 0 0 0 0 0 0 0 0 Utility Fund 0 Visitor Fund 0 0 0 0 0 0 Westlake Academy Foundation 0 1,176,818 1,415,750 0 0 2,592,568 Private Contribution 0 0 0 0 0 0 PROJECT FUNDING TOTAL 1 01 1,176,8181 1,415,7501 01 01 2,592,568 NET 1 01 01 01 01 0 0 IMPACT ON OPERATING BUDGET YTD THRU 09/30/06 BUDGET FY06/07 FUTURE OPERATING EXPENDITURES 07/08 08/09 09/10 PROJECT TOTAL Supplies 0 0 0 5,000 10,000 10,000 25,000 Maintenance 0 5,000 30,000 30,000 65,000 Services 0 0 5,000 10,000 10,000 25,000 Equipment 0 0 0 8,000 8,000 16,000 OPERATING IMPACT TOTAL 01 0 15,000 1 58,000 58,0001 131,000 Page 113 CAPITAL PROJECT Fiscal Year 2006-2007 Fil91938(»4to 1709J Project Description: The engineering, design and construction document package with TXDOT review and approval for FM1938 between SH114 in Westlake and FM 1709 in Southlake/Keller. Implementation costs for Texas U -Turns at SH114/FM1938 interchange are also included. Westlake portion of costs relative to Southlake and Keller is 33% for FM1938 CAPITAL PROJECT EXPENSE CAPITAL PROJECT FUNDING PROJECT YTD THRU BUDGET 09/30/06 BUDGET FUTURE CAPITAL EXPENDITURES PROJECT FY06/07 07/08 08/09 09/10 TOTAL Design/Construction/Engineering 1.394,533 1.295.244 99,860 0 0 0 1,395,104 PROJECT EXPENDITURES TOTAL 1,394,533 1,295,2441 99,860 0 0 0 1,395,104 NET 1 0 99,860 0 0 0 0 0 CAPITAL PROJECT FUNDING PROJECT BUDGET YTD THRU 09/30/06 BUDGET FY06/07 FUTURE CAPITAL FUNDING 07/08 08/09 09/10 Maintenance Services Equipment PROJECT TOTAL Prior Year Remaining Fund 0 0 0 0 99,860 0 0 0 OPERATING IMPACT TOTAL 4A Grant - Westlake 03/04 81,603 82,174 0 0 0 0 82,174 4A Grant - Westlake 03/04 36,857 36,857 0 0 0 0 36,857 4A Grant - Westlake 04/05 32,046 32,047 0 0 0 0 32,047 Tx Dot Inspection (Westlake Portion) 3,333 3,333 0 0 0 0 3,333 Private - Fidelity 00/01 228,700 228,700 0 0 0 0 228,700 Private - General Growth 00/01 47,022 47,022 0 0 0 0 47,022 Private - Keller 00/01 49,513 49,513 0 0 0 0 49,513 Private - Keller 02/03 3,333 3,333 0 0 0 0 3,333 Private - Keller 03/04 36,857 36,857 0 0 0 0 36,857 Private - Keller 04/05 32,046 32,046 0 0 0 0 32,046 Private - Oakmont 00/01 174,676 174,676 0 0 0 0 174,676 Private - Rowland Arthur 03/04 101,739 101,739 0 0 0 0 101,739 Private - Sabre 00/01 44,030 44,030 0 0 0 0 44,030 Private - Southlake 00/01 113,434 113,434 0 0 0 0 113,434 Private - Southlake 02/03 3,333 3,333 0 0 0 0 3,333 Private - Southlake 03/04 36,857 36,857 0 0 0 0 36,857 Private - Southlake 04/05 32,047 32,047 0 0 0 0 32,047 Private - Tarrant County 04/05 150,000 150,000 0 0 0 0 150,000 Private - WB Texas 00/01 187,106 187,106 0 0 0 0 187,106 PROJECT FUNDING TOTAL 1 1,394,533 1,395,104 99,860 0 0 0 1,395,104 NET 1 0 99,860 0 0 0 0 0 Page 114 IMPACT ON OPERATING BUDGET PROJECTYTD BUDGET THRU 09/30/06 BUDGET FUTURE CAPITAL EXPENDITURES FY06/07 07/08 08/09 09/10 PROJECT TOTAL Maintenance Services Equipment 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 OPERATING IMPACT TOTAL 1 01 01 01 0 0 0 0 Page 114 CAPITAL PROJECT Utility Fund Fiscal Year 2006-2007 7R- 4 Assumptiot,i ofN> Sewer Includes the design and construction of a metering station with SCADA equipment at the proposed Town of Westlake "Point of Entry," video inspection, excavation to expose line for inspection, and manhole and sewer main repair work. NET 1 01 01 01 01 01 0 IMPACT ON OPERATING EXPENSES CAPITAL PROJECT EXPENSES YTD THRU 09/30/06 BUDGET FY06/07 FUTURE OPERATING EXPENSE PROJECT 07/08 08/09 1 09/10 TOTAL YTD THRU 09/30/06 BUDGET FY06/07 FUTURE CAPITAL EXPENSE 07/08 08/09 1 09/10 FUTURE FUNDING 07/08 08/09 PROJECT TOTAL 05 Purchase 10 Design 15 Construction 20 Implementation 0 0 0 0 0 0 87,500 0 0 0 0 0 0 0 0 0 0 0 0 87,500 0 0 0 0 25 Engineering 29,800 20,000 0 0 0 49,800 30 Legal 0 0 0 0 0 0 35 Auditor 0 0 0 0 0 0 40 Payroll & Related 0 0 0 0 0 0 45 Administrative 0 0 0 0 0 0 50 Consultation 0 0 0 0 0 0 55 Technical (I&I Study) 0 75,000 0 0 0 75,000 60 Postage/Shipping 0 0 0 0 0 0 65 Copies/Reproduction 70 Public Advertisements 0 0 0 0 0 0 0 0 0 0 0 0 PROJECT EXPENSE TOTAL 1 29,8001 182,5001 01 01 01 212,300 NET 1 01 01 01 01 01 0 IMPACT ON OPERATING EXPENSES CAPITAL PROJECT FUNDING YTD THRU 09/30/06 BUDGET FY06/07 FUTURE OPERATING EXPENSE PROJECT 07/08 08/09 1 09/10 TOTAL Supplies 0 Maintenance 0 Services 0 Equipment 0 YTD THRU 09/30/06 BUDGET FY06/07 FUTURE FUNDING 07/08 08/09 09/10 PROJECT TOTAL General Fund Utility Fund Visitor Fund 413 Fund Private Contribution 0 29,800 0 0 0 0 0 0 0 0 182,500 0 0 0 212,300 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 PROJECT FUNDING TOTAL 29,800 182,5001 01 01 01 212,300 NET 1 01 01 01 01 01 0 IMPACT ON OPERATING EXPENSES YTD THRU 09/30/06 BUDGET FY06/07 FUTURE OPERATING EXPENSE PROJECT 07/08 08/09 1 09/10 TOTAL Supplies 0 Maintenance 0 Services 0 Equipment 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 OPERATING IMPACT TOTAL 1 01 0 0 0 01 0 Page 115 CAPITAL PROJECT Utility Fund Fiscal Year 2006-2007 WaterNeter.4utomat10117 Specific areas of the Town. These areas will be identified after the successful completion of the pilot program on Mahoeta Boone Trail. NET 1 01 01 01 01 01 0 IMPACT ON OPERATING EXPENSES CAPITAL PROJECT EXPENSES YTD THRU 09/30/06 BUDGET FY06/07 FUTURE OPERATING EXPENSE PROJECT 07/08 08/09 09/10 TOTAL YTD THRU 09/30/06 BUDGET FY06/07 FUTURE CAPITAL EXPENSE 07/08 08/09 1 09/10 PROJECT TOTAL 05 Purchase 10 Design 0 0 0 0 0 0 0 0 0 0 0 0 15 Construction 7,991.43 25,000 25,000 60,000 52,009 170,000 20 Implementation 0 0 0 0 0 0 25 Engineering 0 0 0 0 0 0 30 Legal 0 0 0 0 0 0 35 Auditor 0 0 0 0 0 0 40 Payroll & Related 0 0 0 0 0 0 45 Administrative 0 0 0 0 0 0 50 Consultation 0 0 0 0 0 0 55 Technical 60 Postage/Shipping 65 Copies/Reproduction 70 Public Advertisements 2,310 0 0 0 9,690 0 0 0 0 0 0 12,000 0 0 0 0 0 0 0 0 0 0 0 0 PROJECT EXPENSE TOTAL 1 10,301.431 34,6901 25,0001 60,0001 52,0091 182,000 NET 1 01 01 01 01 01 0 IMPACT ON OPERATING EXPENSES CAPITAL PROJECT FUNDING YTD THRU 09/30/06 BUDGET FY06/07 FUTURE OPERATING EXPENSE PROJECT 07/08 08/09 09/10 TOTAL YTD THRU 09/30/06 I BUDGET FY06/07 FUTURE FUNDING 07/08 08/09 09/10 PROJECT TOTAL General Fund Utility Fund 0 10,301.43 0 0 0 0 0 34,690 0 25,000 60,000 0 0 52,009 0 182,000 0 Visitor Fund 413 Fund Private Contribution 0 0 0 0 0 0 0 0 0 0 0 0 0 PROJECT FUNDING TOTAL 1 10,301.431 34,6901 25,0001 60,0001 52,0091 182,000 NET 1 01 01 01 01 01 0 IMPACT ON OPERATING EXPENSES YTD THRU 09/30/06 BUDGET FY06/07 FUTURE OPERATING EXPENSE PROJECT 07/08 08/09 09/10 TOTAL Supplies 0 Maintenance 0 Services 0 Equipment 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 OPERATING IMPACT TOTAL 1 01 0 0 0 01 0 Page 116 Permanent Capital Maintenance Fund Program Summary R=91 2006-2007 summaly Actual FY 04/05 Adopted FY 05/06 Amended FY 05/06 Proposed Budget FY 06/07 Beginning Cash Balance $ $ $ $ 20,000 Balance Sheet Affect to Cash " - Transfers In 113,000 120,608 47,000 Expenditures 93,000 100,608 27,000 Ending Balance 1 $ - $ 20,000 $ 20,000 $ 40,000 ** 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. Page H 7 Fiscal Year 2006-2007 Budget Fund 600 - Permanent Capital Maintenance Fund Adopted Amended Actual Budget Budget FY 04/05 FY 05/06 FY 05/06 FUNDING SOURCES 52510 88 Transfers in from GF $ $ 10,000 $ 10,000 $ 10,000 52510 88 Transfers in from GF 40,440 57,300 - 52510 88 Transfers in from GF 25,560 16,308 - 52550 88 Transfers in from OF 27,000 27,000 27,000 52550 88 Transfers in from OF 10,000 10,000 10,000 TOTAL TRANSFERS INF$ 1 $ 113,0001 $ 120,608 1 $ 47,000 EXPENDITURES 44303 01.15 Road Repairs & Maint. $ $ 25,560 $ 16,308 $ 44303 02.15 Road Repairs & Maint. 40,440 57,300 - 44114 00 Sewer Repairs 27,000 27,000 27,000 TOTAL EXPENDITURES 1 93,0001 100,6081 27,000 SUMMARY CASH SUMMARY Transfers In 113,000 120,608 47,000 Total Other Expenditures 93,000 100,608 27,000 EXCESS TRANSFERS OVER EXPENDITURES1 1 20,000 20,000 20,000 Beginning Cash $ $ - $ - $ 20,000 Total Transfers In 113,000 120,608 47,000 Total Other Expenditures 93,000 100,608 27,000 PROJECTED NET ENDING CASH BALANC $ - $ 20,000 $ 20,000 $ 40,000 Page 1 18 PERMANENT CAPITAL MAINTENANCE PROJECT UTILITY FUND Fiscal Year 2006-2007 SanitatySewer11,71/oW& 11711watiot? Re WirS Repair of manholes, clean -outs, and mains to minimize infiltration of groundwater. NET 1 01 01 01 01 01 0 IMPACT ON OPERATING EXPENSES PROJECT EXPENSES YTD THRU 09/30/06 BUDGET FY06/07 FUTURE OPERATING EXPENSE PROJECT 07/08 08/09 09/10 TOTAL Supplies 0 Maintenance 0 Services 0 Equipment 0 YTD THRU BUDGET FUTURE CAPITAL EXPENSE 09/10 PROJECT General Fund Utility Fund Visitor Fund 413 Fund Private Contribution 09/30/06 FY06/07 07/08 08/09 09/10 0 TOTAL 05 Purchase 0 0 0 0 0 0 10 Design 0 0 0 0 0 0 15 Construction 0 25,000 0 0 0 25,000 20 Implementation 0 0 0 0 0 0 25 Engineering 0 2,000 0 0 0 2,000 30 Legal 0 0 0 0 0 0 35 Auditor 0 0 0 0 0 0 40 Payroll & Related 0 0 0 0 0 0 45 Administrative 0 0 0 0 0 0 50 Consultation 0 0 0 0 0 0 55 Technical 0 0 0 0 0 0 60 Postage/Shipping 0 0 0 0 0 0 65 Copies/Reproduction 0 0 0 0 0 0 70 Public Advertisements 0 0 0 0 0 0 PROJECT EXPENSE TOTAL 1 01 27,0001 01 01 01 27,000 NET 1 01 01 01 01 01 0 IMPACT ON OPERATING EXPENSES PROJECT FUNDING YTD THRU 09/30/06 BUDGET FY06/07 FUTURE OPERATING EXPENSE PROJECT 07/08 08/09 09/10 TOTAL Supplies 0 Maintenance 0 Services 0 Equipment 0 YTD THRU 09/30/06 BUDGET FY06/07 FUTURE FUNDING 07/08 08/09 09/10 PROJECT TOTAL General Fund Utility Fund Visitor Fund 413 Fund Private Contribution 0 0 0 0 0 0 0 0 0 0 27,000 0 0 0 27,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 PROJECT FUNDING TOTAL 01 27,0001 01 01 01 27,000 NET 1 01 01 01 01 01 0 IMPACT ON OPERATING EXPENSES YTD THRU 09/30/06 BUDGET FY06/07 FUTURE OPERATING EXPENSE PROJECT 07/08 08/09 09/10 TOTAL Supplies 0 Maintenance 0 Services 0 Equipment 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 OPERATING IMPACT TOTAL 1 01 0 0 0 01 0 Page 119 PERMANENT CAPITAL MAINTENANCE PROJECT Fiscal Year 2006-2007 Genera/iLlaintenance PROJECT FUNDING Aff PROJECT EXPENSES BUDGET FY06/07 YTD THRU 09/30/06 BUDGET FY06/07 FUTURE FUNDING M YTD THRU 09/30/06 BUDGET FY06/07 FUTURE CAPITAL EXPENSE 07/08 08/09 09/10 0 0 PROJECT TOTAL 05 Purchase 0 0 0 0 0 0 10 Design 0 0 0 0 0 0 15 Construction 0 0 0 0 0 0 20 Implementation 0 0 0 0 0 0 25 Engineering 0 0 0 0 0 0 30 Legal 0 0 0 0 0 0 35 Auditor 0 0 0 0 0 0 40 Payroll & Related 0 0 0 0 0 0 45 Administrative 0 0 0 0 0 0 50 Consultation 0 0 0 0 0 0 55 Technical 0 0 0 0 0 0 60 Postage/Shipping 0 0 0 0 0 0 65 Copies/Reproduction 0 0 0 0 0 0 70 Public Advertisements 0 0 0 0 0 0 PROJECT EXPENSE TOTAL 01 01 01 0 1 0 0 PROJECT FUNDING Aff YTD THRU 09/30/06 BUDGET FY06/07 YTD THRU 09/30/06 BUDGET FY06/07 FUTURE FUNDING M PROJECT TOTAL 07/08 1 08/09 09/10 General Fund 0 0 10,000 0 0 0 10,000 Utility Fund 0 0 0 0 0 Visitor Fund 0 0 0 0 0 0 4B Fund 0 0 0 0 0 0 Private Contribution 0 0 0 0 0 0 PROJECT FUNDING TOTAL 0 15,5551 01 01 01 10,000 NET 1 01 10,0001 01 01 0 10,000 IMPACT ON OPERATING EXPENSES YTD THRU 09/30/06 BUDGET FY06/07 FUTURE OPERATING EXPENSE PROJECT 07/08 08/09 09/10 TOTAL Supplies 0 Maintenance 0 0 0 0 0 0 0 0 0 0 0 Services 0 0 0 0 0 0 Equipment 0 0 0 0 0 0 OPERATING IMPACT TOTAL 0 01 01 01 01 0 Page 120 OpAWTST` Ir' ti WeAl"0460 Growth Rate Revenue 3.00% Growth Rate Expenditures 3.00% General Fund Beginning Fund Balance (CASH) Balance Sheet Affect to Cash Revenues Expenditures Transfers In (FW Impact Fees) Transfers in (Property Tax Reduction Fund) Transfers Out (Perm CMF) Transfers Out (Capital Projects) Net Cash Restricted Funds (Court and Trail restrictions) Restricted Funds (Building Fund from TSH) Ending Balance (projected) Operating Days 4B Beginning Fund Balance (CASH) Revenues Expenditures Transfers In Transfers Out (Debt Service) Ending Balance (projected) Property Tax Reduction Fund (CASH) Revenues Transfer out to Debt Service Fund Transfer out to General Fund FY 06/07 I FY 07/08 I FY 08/09 I FY 09/10 I FY 10/11 $ 2,380,389 $ 1,160,257 $ 990,902 $ 994,019 $ 1,026,002 114,436 114,436 114,436 114,436 114,436 3,818,049 3,932,590 4,050,568 4,172,085 4,297,248 (3,813,258) (3,927,656) (4,045,485) (4,166,850) (4,291,855) 50,000 50,000 50,000 50,000 50,000 362,389 253,598 302,312 354,054 (10,000) (10,000) (10,000) (10,000) (10,000) (834,174) (321,115) (40,000) (60,000) (110,000) 1,705,442 1,360,902 1,364,019 1,396,002 1,429,884 (345,185) (370,000) (370,000) (370,000) (370,000) (200,000) 1,160,257 990,902 994,019 1,026,002 1,059,884 113 92 90 90 90 753,500 776,105 799,388 823,370 848,071 29,731 29,731 29,731 29,731 29,731 (783,231) (805,836) (829,119) (853,101) (877,802) 154,547 753,500 776,105 799,388 823,370 848,071 (598,953) (568,263) (545,790) (521,058) (494,017) (362,389) (253,598) (302,312) (354,054) Ending Balance (projected) 154,547 - - - - Debt Service Fund Beginning Balance Transfers In (413) Transfers In (PTRD) Expenditures - debt service (series 1 & 2 Ending Balance (projected) 783,231 805,836 829,119 853,101 877,802 598,953 568,263 545,790 521,058 494,017 (1,382,184) (1,374,099) (1,374,909) (1,374,159) (1,371,819) Total GF, 4A & 4B Ending Balance (projected) $ 1,314,804 $ 990,902 $ 994,019 $ 1,026,002 $ 1,059,884 See Page 122 for requested Capital expenditures. Page 121 OF WEgp< s1�iAun� 9 to >. sem. . ;• ►��v SAKE ACA / PROJECTSCAPITAL FY 06107 Civic Campus Expansion III - Pod F $ 494,000 High School Soccer Field 22,000 Expand Dining Hall - Tennis Courts FY 07108 $ - - 30,000 - FY 08/09 $ FY 09110 $ - - - 5,000 FY 10/11 $ Roof Repair - 5,000 - Tree removal road ways & park 5,000 2,000 5,000 2,000 Park- Equipment 5,000 4,000 4,000 4,000 Carpet/VCT flooring 13,000 19,000 5,000 - Exterior Paint - Wood Treatment 7,500 7,500 7,500 - Cemetery 6,000 6,000 - 2,000 Campus Irrigation System 8,000 - 3,000 - HVAC Systems 9,500 9,500 9,500 9,500 Heating System 8,500 7,500 - 2,500 Parking 16,000 - Vehicle - Chassis for Attack / Brush Unit 88,200 - - - Apparatus - Re -mount Ambulance - - 90,000 - Protective Clothing - Bunker Gear 4,800 5,100 5,400 5,700 Self Contained Breathing Apparatus 12,000 - - Monitor / Defibrillators / AEDs 5,500 2,750 27,500 - Apparatus Replacement 30,000 - 30,000 - Hose and Appliances 2,115 8,500 2,350 2,615 Stagecoach Hills pavement rehabilitation 70,000 - - Roanoke & Ottinger Road Reconstruction 118,174 FM 1938 Pedestrian Crossing 200,000 Aspen Lane pavement rehabilitation - 50,000 - Mahotea Boone rehabilitation - 17,000 Wyck Hill resurface 25,000 - Dove Road Resurface - - 127,000 Ending Balance (projected) $ 834,174.00 $ 321,115 $ 121,850 $ 241,250 $ 155,315 ** ** Total is net of the following: Art/Science project (Outside source contribution) FM 1938 project (Outside source contribution) Utility Fund portion of $15K for the Civic Campus Expansion Page 122