HomeMy WebLinkAboutRes 05-30 Adopting Revised Budget for Fiscal Year 2005 and Adopting Proposed Budget for Fiscal Year 2006TOWN OF WESTLAKE
RESOLUTION NO. 05-30
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, 2005 AND ADOPTING
THE PROPOSED BUDGET FOR THE FISCAL YEAR ENDING SEPTEMBER 30, 2006.
WHEREAS, a public hearing was duly held and all interested persons were given an
opportunity to be heard for or against any item therein.
NOW, THEREFORE, BE IT RESOLVED BY THE BOARD OF ALDERMEN OF THE
TOWN OF WESTLAKE, TEXAS:
SECTION 1: That the Board of Aldermen hereby adopts the revised budget for the fiscal
year ending September 30, 2005 and the proposed Annual Operating Budget for the fiscal year
ending September 30, 2006 and appropriates the funds contained therein.
SECTION 2: That a copy of the official adopted 2005-2006 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 12th DAY OF SEPTEMBER 2005.
ATTEST:
�Dwinnell, Town Secretary
APPROVED TO F
L. Stanton L , orney
Fred Held, Mayor Pro Tem
Trent O. Petty, T anager
111,11 SI
A town for your
family.
A town for your
future.
r
V, I
Tp
SZ
y� SAAI \�'9��
t!'IKE
U�� Relissyl lfli
SCOTT BRADLEY
Mayor
FRED HELD
Mayor Pro Tem
DON REDDING, BILL FREY, LARRY SPARROW, BUDDY BROWN
Board of Aldermen
TRENT PETTY
Town Manager
JEAN DWINNELL
Town Secretary
STAN LOWRY
Town Attorney
THE TOWN OF 1t1 TL EKE * 2650 OTTINGER VO ID * WESTLAKE-, TEX, AS 762,2
Page 1 09/07/2010
Section 1
Transmittal
Letter
Page 2 09/07/2010
�iS� WES�C
September 1, 2005
Honorable Mayor and Members of the Board of Aldermen:
It is my pleasure to present the FY 2005/2006 budget of the Town of Westlake. As in previous years,
we are presenting a budget that provides basic services to meet the community's needs without assessing
a property tax.
The Town has continued its trend of steady residential growth during the past year, resulting in ongoing
service level increases.
MAJOR EVENTS OF FISCAL YEAR 2004-2005
Budget
The adopted FY 2004/2005 budget reflected two revenue scenarios. The first contemplated the mall and
the second did not. The 2005/2006 budget again reflects the same two scenarios. The latest updates
indicate that the mall is still planned to open in 2007 and the SH 170 retail component should be
simultaneously constructed, if not before the mall. While the mall generates substantial new
development fees and promises positive sales tax revenue, it prompts the inclusion of a number of
expanded level service packages from Building Inspection to the Department of Public Safety.
New Development
In late June, First American Title announced its relocation to Solana. This $20 million renovation of
615,000 sq. ft. of office space in Campus Circle will accommodate up to 3,000 First American
employees and will see Campus Circle 1, 2, 3 and 4 linked by a four story sky bridge.
Westlake Academy Expansion
The expansion of the Westlake Academy into space currently occupied by the Town offices has
necessitated several adjustments to the Town's office arrangements. Building Inspection was
consolidated into the administrative offices, and the Municipal Court offices are on track to move into a
temporary portable building in early FY 2005/2006.
Staffing
Existing staff absorbed additional service demands resulting from residential growth. Two positions that
originally were to be filled this year, a Records and Revenue Clerk and a Public Works Technician, have
been placed on hold pending new revenues. However, two new positions were added during this year, a
part-time court clerk to meet additional service demands and an additional DPS position. The extra DPS
position has actually served as a cost reduction measure, as intended, by reducing overtime costs. This
position covers shifts at a regular hourly rate that would have normally been paid at an overtime rate.
THE TOWN OF WESTLAKE * 2650 OTTIINGEP ROAD * TL KE, TEXAS 76262
Page 3 09/07/2010
Westlake Visitors Association
FY 2004/2005 saw many notable events for the Westlake Visitor's Association, beginning with the
launch of the new Town of Westlake website, which will serve as a valuable gateway to the Town's
residents, visitors, and employees on the World Wide Web. The Master Works Series, in conjunction
with Maguire Partners, had another successful year by promoting the arts in Westlake. Quality artists
from the area entertained the crowds with great live music and helped promote a stronger sense of
community. Other programs supported by the Visitor's Association include the Westlake Historical
Preservation Board, Tree City USA, and events such as Decoration Day and the Annual Tree Lighting
ceremony.
DPS
Public Safety in Westlake continues to grow due to the cross training of members of the Westlake DPS.
Of the eleven members of our DPS staff, ten are also certified peace officers. This tri -certification has
helped to increase our warrant revenue as well as make our Public Safety division more flexible when
needs arise. The cost of the DPS arrangement, however, in the absence of new revenues will be a major
factor in determining whether the Town continues to offer DPS services through its partnership with the
Keller PD or contract out all DPS services. Because of the Town's size and relatively low call volume
(267) in 2004, Westlake has one of the highest cost -per -call ratios of any municipality. Options must be
decided prior to January of 2006, which marks the deadline to notify Keller that Westlake intends to end
the contract effective October 1, 2006.
Utilities
Water rates for all customers were reduced during this year, making the Town much more competitive
with surrounding communities. A new pilot program has been initiated to allow water meters within
the Town to be read remotely, saving time and future resources. This technology will hopefully be
proven in the coming year and become a permanent component of our utility billing system.
The Utility Fund is about to complete its first 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
enabled us to respond to customer's concerns in a more accurate and efficient manner.
FISCAL YEAR 2005/2006
The key variable determining expenditures and revenues in 2005/2006 will be retail and commercial
development. This fiscal year, the Town will make its first full payment of debt service for the Civic
Campus. If significant new development fees and revenues resulting from development are not present
by the end of the calendar year 2005, staff is recommending an election in May 2006 which will
dissolve the %2 cent sales tax, Section 4A, Economic Development funds and transferring the fund
balance of $1,757,337 to the General Fund. Expenditures allowed under 4A have been significantly
reduced by the Legislature since the town began collecting the funds in October, 1996. In order to
continue collecting a '/2 cent for the Town, the voters will also be asked to approve a Crime Control
District (CCD). This will create a new '/2 cent sales tax, which may be used to fund police related public
safety costs, thus relieving the General Fund of a portion of police related expenditures. In future years,
a CCD will collect approximately $660,000 per year. Total DPS expenditures are expected to be
approximately $1,775,000 per year. By applying the CCD funds to these costs, the Town will be
reducing the annual General Fund obligation by 37%.
THE TOWN OF WESTLAKE * 2650 OTTIINGE ROAD * TI DE, TEXAS 76262
Page 4 09/07/2010
DEPARTMENTAL SUMMARIES
Dept 12 - Building and Code Compliance
The Building department is comprised of one FTE with limited clerical support. Jim Taylor has been
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. In order to continue
this efficiency measure in view of a growing demand on inspections and plan review time, it is
necessary to automate certain aspects of the building process. A reasonably priced automation system
will be researched and purchased which will reduce the hard copy requirements and manual information
retrieval while protecting the profit margin built into this function.
Dept 13 - Town Secretary
The Town Secretary's office is committed to improving record keeping and access. She has proposed a
major update of the manual system that is currently used to retrieve documents in a timely manner. The
overhaul will include codification of the Circle T PD Ordinances, the Westlake Engineering and
Building Standards and all other official Town documents that are not currently available in digital form.
In addition, maps and pertinent Ordinance attachments would be scanned and would also become
available online. This will not only save significant man hours in retrieving data but will also provide a
much more accurate and efficient means for citizens, developers and businesses to access critical Town
records. The cost of this project is reflected in the "Records Management" line item in the amount of
$13,500.
Dept 14 - Emergency Services
This year's budget for the Department of Public Safety emphasizes a transition from contracting services
to performing those services in-house. The key program allowing this is the Law Enforcement Field
Training Program for our tri -certified personnel that have little or no street experience. The purpose of
this program is to partner our personnel with a seasoned veteran street officer and allow that officer to
mentor our personnel. This mentor will involve actual street time, performing the duties of a patrol
officer under the mentor's supervision, performing the duties of a patrol officer under the supervision of
a second mentor (gathering a different perspective and a secondary evaluation) and finally a "shadowing
period evaluation" was our personnel perform singularly but with close support. This program will also
allow our personnel to begin law enforcement activities after completion of the training and mentoring
period. Such law enforcement activities would be scheduled for times when Keller Police Department
are not in our Town and would supplement their activities. It would also increase our law enforcement
presence in the Town. Once everyone has completed this program, the Department would have the
ability to assume all Department of Public Safety activities.
Secondary to this program, the Department has assumed the residential inspections and is moving
rapidly toward assuming the responsibility for commercial/business inspections. The Department plans
to assume the bulk of these inspections the coming fiscal year. This will be for existing and not new
inspections. New inspections will continue to be performed, in conjunction with our personnel, through
the City of Southlake.
Dept 15 - Municipal Court
During the coming budget year, the Court personnel are committed to continuing the level of service
they have provided for the preceding year. The Court has experienced a tremendous increase in revenue
and with continued effective case flow management; they will maximize the return to the Town. The
staff has reduced the backlog of outstanding warrants and has formulated a plan to remain current for the
coming year and expand the collection efforts of the warrant division. We will be retaining a new
THE TOWN OF WESTLAKE * 2650 OTTIINGEP ROAD * TI DE, TEXAS 76262
Page 5 09/07/2010
collection agency and an additional warrant officer to assist in the warrant clearances. The warrant
officer position will focus their efforts on reducing the total number of current outstanding cases and
assist the current officer in pursuing the older case files. The warrant division will receive goals and
objectives to clear the outstanding cases and the Court staff will monitor the achievements. This
program will become a primary focus for the upcoming budget year. The Court anticipates a significant
reduction in the outstanding warrants and an increase in the collection rate of judgments.
The Court will relocate to a temporary facility on the Civic Campus and will minimize the anticipated
problems for the defendants and attorneys who utilize the Court's services. In addition, they will be
working with the prosecutor to establish regular trial dockets to prevent a backlog of cases that are
pending trial.
As this was a legislative year, the Court will also be implementing any changes in the law as it pertains
to municipal courts. The staff does not anticipate any significant increase in expenditures to implement
these changes. They will need to order new ticket books and reprint the citation instruction sheets, but
the remaining changes can be accomplished in the office.
Dept 16 - Public Works
For the FY 05/06 Public Works has proposed six capital projects.
The subgrade on Dove Road has deteriorated to the point that requires restoration. The rehabilitation of
approximately 4000 feet of Dove Road (between Ottinger and Vaquero) will include re -stabilizing the
subgrade with either lime or cement and 2" of asphalt. This section of Dove Road will last about 7 years
and provide commuter with a safer driving experience. The Fidelity Developer's agreement included a
requirement for the construction of a waterline along the re -aligned FM 1938. This will extend the
water system from the existing 16" waterline on Dove Road and extended to Hwy. 114.
Water meter automation is a project that will expand the 04/05 pilot fixed based meter -reading project.
This will allow for the ability to read meters and monitor/record usage patterns through a network of
metering devices that transmit radio signals back to Town Hall. This system will ultimately be utilized
to maximize efficiency of staff and provide customers with invaluable information such as notification
of a potential leak.
The expansion of the Academy requires the installation of temporary modular office buildings to house
the Westlake Municipal Court personnel and Westlake Academy. Water and sewer lines will need to be
installed to provide the court offices with water and sewer services.
During the FY of 04/05 staff inspected sewer lines, manholes, and clean -outs to identify items in need of
repair. The repairs are included in the proposed budget as this will help reduce the amount of ground
water intrusion into the sewer system. The reduction of infiltration will translate into a reduction in
sewer treatment charges. The repairs will also help reduce the potential for sewer stoppages and
discharges into nearby creeks, ponds, and yards.
Westlake and Southlake staff will also be actively pursuing TRA to assume ownership of the N-1 sewer
line that is currently owned by Westlake and Southlake. The transfer will require the installation of a
new Westlake metering station; from which TRA will derive flow readings for billing. This project is
necessary to reduce the potential for a possible disagreement between Westlake and Southlake regarding
billing methodology and rates.
THE TOWN OF WESTLAKE * 2650 OTTIINGEP ROAD * TI DE, TEXAS 76262
Page 6 09/07/2010
Dept 17 - Facilities Maintenance
In 2005-2006 the facility's maintenance budget increased by 34%. One contributing factor is the
refinishing of the gym floor at a cost of $15,000. This is a process that will need to be completed every
two to three years. The front entrances to the Academy and Town will also need to be refinished every
three to four years at a cost of $2,000 to $3,000. Both of these projects would start in December 2005
over the Christmas holiday.
Three small leaks were discovered, on the east side of the pond, near the out flow structure. Low cost
repairs were completed ($2,500) May of 2005. If new leaks surface or the repairs do not hold up long
term, more extensive repairs will be needed to include a clay dam below ground around the out flow
structure would need to be installed. The estimated cost is $8,000 to $10,000. The repair may be
needed when the pond is at its highest level, with the fall rains.
With the new location of the temporary court facility near the pond, we will need to place signs and may
need fencing with shrubs and ground cover on the north and west side of the pond. Cost would range
from $2,000 to $3,000.
The landscaping and cleaning contract increased due to the temporary court facility. There will be
additional mowing and cleaning of the facility. Cost increase for both totals $4,500.
The campus will be three years old in the fall of 2006, which will require new paint, replacement of
some of the carpet tiles, repairs on doors and stone walls in some areas of the facility. The estimated
cost is $5,000 to $8,000. Most of the repairs will be on an as needed basis and will be performed over
the holidays or in the summer of 2006.
Dept 18 — Finance & Human Resources
The Finance/Human Resources Department's proposed payroll budget for FY 2005/2006 has decreased
by 3% from the prior year. The general fund's portion (70%) of the FY 2005/2006 audit fee will be
$14,000 as opposed to $15,400 in FY 2004/2005. The initial cost of the conversion of the Town's books
to conform to GASB 34 was incurred in the previous year; therefore, the remaining year of our contract
will not contain this additional fee.
The current year is the department's first complete year with the Stw, Inc. general ledger and payroll
software packages. With increased staff knowledge, we are anticipating fewer calls for assistance and
maintenance. Additional personnel hours dedicated to the implementation and maintenance of the utility
billing for the current year, as well as the absorption of the builder registration maintenance and the
receipting and distribution of building permits and plans, has led to approximately $7,000 in overtime
for the Finance Assistant. This overtime amount will be allocated as: 50% General Fund; 35% Utility
Fund; 15% Visitor Fund. We have again budgeted for this overtime, but plan to maintain the
department with no additional personnel.
Dept 19 - Parks and Recreation
The 05-06 budget was increased by 8% due to anticipate repairs on the aging well and irrigation system
in Glenwyck Farms Park. There are plans to purchase replacement trees in the park due to the loss of
six pecan and 3 oak trees in 2005. The HOA will pay 50% of all repairs and trees replaced in the park.
The Parks & Recreation revenue will stay the same for recreation programs and services. The
opportunities for education and facility rentals may be limited due to the increase in Academy activities
and the addition of the 8th grade. The key to new revenue for FY 05/06 is to develop partnerships with
THE TOWN OF WESTLAKE * 2650 OTTIINGEP ROAD * TL KE, TEXAS 76262
Page 7 09/07/2010
service vendors and web based services. The large increase in the FY 05/06 revenue budget comes
from the Glenwyck Farms reimbursement for services in the park.
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 the most significant IT expense, and a key objective for FY 05/06 is the
implementation 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. Industry
figures indicate the ongoing direct cost to support a "managed" desktop can be reduced by as much as
35% or more (Gartner Group). A more conservative 20% reduction in support costs savings from this
initiative would predict an ROI within two (2) years. Information archiving - including all email and
attachments -is critical for compliance with open records requests and better systems must be put in
place to provide this capability.
IT will continue to grow the Westlake on-line presence by introducing interactive map and illustrations
to our public website and establishing citizen access to key information via the Westlake "Portal."
Revenue opportunities from the IT Department include underwriting (sponsorship) of a Westlake
Information "Widget" to be deployed this fall as well as sponsorship of key website content areas. An
"Available Properties in Westlake" feature will be added to the website to be maintained directly by area
Realtors who will pay Westlake a fee for the service.
Dept 21 - Engineering
The budget proposal for next year's Engineering Program requests that funding levels remain the same
as the previous fiscal year. All of the usual services provided by Engineering will continue next year
with coordination of the development review process being a top priority. However, there are several
new tasks that staff wishes to accomplish and are highlighted 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.
The Town's current water system computer model and master plan was prepared in 1999. The model
should be evaluated and updated periodically to account for any changes in the system and verify the
assumptions used in developing the master plan. The Engineering staff proposes to update the water
model next year with two goals in mind. One goal is to reduce the peak charges from the City of Fort
Worth and the other is to reduce our pumping costs. By conducting a computer simulation of our water
distribution system, staff can determine the optimum operating characteristics of the system and reduce
costs.
Subsequent to 9/11, the EPA mandated that all water systems serving more than 3,300 people must have
a Vulnerability Assessment. Although, Westlake's system does not require a study, staff proposes
having an evaluation of the water system to identify security risks. For a relatively small cost, the Town
can have an assessment prepared that will alert us to any security issues and allow us to address them.
THE TOWN OF WESTLAKE * 2650 OTTIINGEP ROAD * TL KE, TEXAS 76262
Page 8 09/07/2010
A water rate study was completed last year that resulted in the Board adopting a rate reduction. In the
next fiscal year, staff will initiate an annual performance review of the Utility Fund. This will not be an
exhaustive study, but an evaluation of the fund's condition to see that bond coverage's and operating
margins are being met
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.
CAPITAL PROJECTS SUMMARY
Temporary Parking - $93,800
A two inch asphalt base temporary parking lot with 25 parking spaces will be built at the Town
portable building site. Also, a two inch asphalt base temporary parking lot with 86 parking spaces will
be built for the Academy with a pickup area located on the west side of Pod G for 7th and 8th graders.
The parking lots are to be completed in November, 2005.
Portable Buildings - $57,400
This project represents a 36'x 64' temporary office building to be occupied by the Court, Jim Taylor,
Texas Student Housing and files plus two (23' x 64') portables which will provide the Academy with
two classrooms, a workroom and restrooms. The cost includes delivery to jobsite, setup, anchor decks,
and ramp skirting. The Town's monthly lease of $1,965 (48 month lease=$92,355 total) will begin
November 15, 2005. Installation of phones and data lines from Pod G (Gym) to the temporary
buildings is necessary for occupancy.
Civic Campus Expansion - $266,525
This expansion includes the remodel of the court and offices in Pod E into three classrooms for the
Academy.
Art/Science Building - $1,300,000 — Donation from Westlake Academy Foundation
The foundation's donation will be for the building of an Art/Science building with three laboratories,
one or two art rooms, black box theatre, outside theater, 4-6 offices, workroom, conference room,
storage and entry hallway.
FM 1938 (114/1709) - $222,237 - Contributions from Southlake and Tarrant County
The engineering, design and construction document package with TxDot review and approval for FM
1938 between SH 114 in Westlake and FM 1709 in Southlake/Keller. Implementation costs for Texas
U -Turns at SH114/FM1938 interchange are also included. Westlake portion of cost relative to
Southlake and Keller is 57.11% and has been paid in full.
Water Meter Automation — $37,000
The project represents phase two for the water meter automation that 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 to be completed by January, 2006.
THE TOWN OF WESTLAKE * 2650 OTTIINGE ROAD * TL KE, TEXAS 76262
Page 9 09/07/2010
TRA/Southlake N1 Sewer Line Improvement - $145,000
Improvements include 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.
Sewer & Water Installation for Portable Office Building - $26,500
Project represents the sewer and water installation for temporary building to be used by court and town
employees.
Fidelity Waterline Extension - $350,890 - Contribution from Fidelity
The construction of a12" waterline from Dove Road to Hwy. 114 along proposed FM 1938. The
construction will be funded by Fidelity as outlined in the developer's agreement.
PERMANENT CAPITAL MAINTENANCE PROJECTS SUMMARY
Dove Road Improvements - $66,000
Improvement project is to overlay Dove Road with 2" of asphalt and improve drainage conditions
along ROW.
Sanitary Sewer Inflow & Infiltration Repairs - $27,000
Represents repair of manholes, clean -outs, and mains to minimize infiltration of groundwater.
FUND SUMMARIES
The 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.
The 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.
The Westlake Visitor's Association
The Visitor's Association 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. The shuttle also operates to local shopping centers and business meetings in the
Solana area. The amount of support offered in FY 2005/2006 for this program will be contingent on
measurable revenue indicators from the Marriott.
THE TOWN OF WESTLAKE * 2650 OTTIINGEP ROAD * t EsTL KE, TEXAS 76262
Page 10 09/07/2010
4A Economic Development Fund
The 4A Development Fund collects a 1/2 cent sales tax to be used for economic growth and job
development projects. Two years ago, the Town contemplated dissolving the 4A fund and replacing it
with a Crime Control District. Following several changes in the legislation, the Town concluded that it
would be premature to dissolve 4A. As factors continue to evolve, this issue is being re-evaluated for
FY 2005/2006. If the 4A Fund is dissolved, the remaining fund balance would be transferred to the
General Fund.
4B Economic Development Fund
The 4B Development Fund operates in a similar fashion to the 4A fund by collecting an additional %2
cent sales tax to be used for qualified development projects. The 4B fund has been committed to the
repayment of the debt incurred for the Town's Civic Campus project.
Crime Control District
A Crime Control District (CCD) is an additional 1/2 cent sales tax that is collected the same way as 4A
and 4B. The anticipated revenues from a Crime Control District would be identical to the funds
collected under the 4A tax; the only difference is the purpose that the funds are used for. Crime Control
District funds may be used for limited public safety, including expenditures related to police. Fire and
Ambulance services; however are not eligible expenditures within a CCD. We will propose a May
election to create this fund. The implementation of the CCD will require the Board appoint a seven
member Crime Control District Board (which may be made up of an unlimited number of aldermen)
who will then be responsible for adopting a plan and a budget. Voters would then decide whether or not
to approve the additional 1/2 cent sales tax to fund the CCD. A CCD must be established for a minimum
of 5 years after which point, voters must vote to renew the District.
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 General 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 Proiect 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.
THE TOWN OF WESTLAKE * 2650 OTTIINGE ROAD * TI DE, TEXAS 76262
Page 11 09/07/2010
Grant Fund
A special revenue fund has been created to account for the FEMA grant for the FY 2005/2006. If the
Town chooses to continue to self perform all or a part of our DPS functions, these grant funds will be
used to purchase a compressed air foam system to be used on brush and vehicle fires, funding to join the
NETCO (Bedford) radio consortium, purchase of technical rescue equipment, purchase of decon and
containment equipment to be used for hazardous material spills and the purchase of automatic external
defibrillators (AEDs).
SUMMARY
The FY 2005/2006 budget is a conservative one, and it is the most detailed and comprehensive budget to
date. The format changes help each department to begin to articulate their goals and objectives as well
as services. Each budget continues to build on the efficiencies of previous years, and seeks to better
inform the reader of the Town's priorities and services. Each budget over the last five years has helped
to contribute to expenditure efficiencies that now sustain a system that is flexible and creative. We
continue to be challenged, we continue to innovate, and we continue to serve our community with the
highest level of commitment.
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
THE TOWN OF WESTLAKE * 2650 OTTIINGE ROAD * TI DE, TEXAS 76262
Page 12 09/07/2010
Section 2
Executive
Summary
Page 13 09/07/2010
QF WEST
Town Texas Student
Attorney Housing
Executive
Manager
Finance
Manager
Town Town
Manager Secretary
Executive Town
Assistant Intern
Westlake
Academy
Facilities I
Maintenance
Municipal
Court
Warrant Deputy
Officers I I Clerks
Public
Works
Building
Official
Visitor
Association
Parks and
Recreation
Finance
Department
Finance Human
Assistant Resources
Fire
Chief
Fire and
EMS Staff
THE TOWN OF WEST KE * 2650 OTTTIN(iK ROAD * WESTLAKE, TEXAS 76262
Page 14
09/07/2010
Emplo-yee Summary FY 2005/2006
THE TOWN OF WESTLAKE * 2650 OTTINGER ROAD * WESTLAKE, TEXAS 76262
Page 15 09/07/2010
FY 01/02
FY 02/03
FY 03/04
FY 04/05
FY 05/06
Town Manager
1
1
1
1
1
Assistant to Town Manager
1
1
0.5
0
0
Administrative Assistant
1
1
0
0
0
Executive Assistant
0
0
0.5
1
1
Part -Time Intern
1
0.5
0.5
0.5
0.5
Town Secretary
1
1
1
1
1
Building Official
0
0
1
1
1
Fire/EMS Coordinator
1
1
1
1
1
Firemen/Paramedics
0
9
9
10
10
Municipal Court Clerk
1
1
1
1
1
Municipal Court Deputy Clerk
0
0
1.5
1.75
1.75
Municipal Court Judge
1
1
1
1
1
Municipal Court Marshal
1
1
1
0
0
Municipal Court Warrant Officer
0
0
0
1
2
Public Works Superintendent
0
1
1
1
1
Utility & Building Technician
0
0
0
0
0
Facilities & Recreation
0
0
1
1
1
Finance Director
0
1
1
1
1
Human Resources Manager
0
0
1
1
1
Finance Assistant
1
1
1
1
1
Records & Revenue Clerk
0
0
0
0
0
Marketing & Public Affairs
0
0
1
1
1
Total
10.0
20.5
25.0
26.25
27.25
THE TOWN OF WESTLAKE * 2650 OTTINGER ROAD * WESTLAKE, TEXAS 76262
Page 15 09/07/2010
��_wESTt
WIWI
Introduction
The Town of Westlake staff is pleased to present the recommended 2005/2006 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, 2004.
COMPLIANCE WITH GASB STATEMENT NO. 34
The FY 2005/2006 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.
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
THE TOT KE * 2650 OTTLNERER ROAD * WESTLAKE, TEXAS 76262
Page 16 09/07/2010
general long-term debt, are recorded when the fund liability is incurred, if measurable. Interest on general long-term debt is
recorded when due.
The Proprietary Fund types are accounted and budgeted for on a cost of services or "capital maintenance" measurement focus,
using the accrual basis of accounting. Under the accrual basis of accounting, revenues are recognized when earned and expenses
are recognized when incurred. For purposes of this budget presentation, depreciation is not displayed and capital expenditures
and bond principal payments are shown as uses of funds.
Governmental Fund Types
Governmental fund types are those through which most governmental functions of the Town are financed. The acquisition, use,
and balances of the Town's expendable financial resources and the related liabilities (except those accounted for in the
Proprietary and Fiduciary fund types) are accounted for through Governmental Fund types. The following are the Town's
governmental fund types.
1. The General Fund is the general operating fund of the Town. It is used to account for all revenues and expenditures
except those that are required to be accounted for in another fund.
2. Special Revenue Funds are used to account for the proceeds of specific revenue sources, other than expendable trusts
or major capital projects. The Town will use a special revenue fund to account for the FEMA grant.
3. Economic Development Corporation 4A and 4B funds are provided as local options, under section 4A & 4B of the
local government code. The funds are generated from a '/2 cent sales tax levy for each Economic Development
Corporation. The proceeds are used for general economic development and infrastructure support.
4. The Westlake Crime Control District, if adopted, will receive its funding from a'h cent sales tax levy that is currently
earmarked for the 4A Economic Development Corporation. Funds allocated to the Crime Control District would be
used to meet the Town's obligations to the Keller Police contract.
5. Westlake Visitors Association 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.
6. 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.
7. 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.
8. The Debt Service Fund is used to illustrate the funding and payment of debt service. Operating budgets do not have
appropriate places to show the payment of debt service so the creation of a fund is a more accurate accounting
portrayal of the process. The Debt Service Fund will be used to make the payments for the two issues of certificates
of obligation associated with the building of the Civic Campus.
Proprietary Fund Types
Proprietary fund types operate in a manner similar to private business utilizing an accrual basis of accounting.
Enterprise Funds — are used to account for operations that are either financed and operated in a manner similar to private
business enterprises, or where the governing body has decided that periodic determination of revenues earned, expenses incurred,
and/or net income is appropriate for capital maintenance, public policy, management control, accountability or other purposes.
• The Utility Fund accounts for water, wastewater and telecommunications conveyance (duct bank) services
for the residents of the Town. All activities necessary to provide such services are accounted for in the
Fund, including administration, operations, maintenance, financing and related debt service, and billing and
collection.
THE TOT KE * 2650 OTTLNERER ROAD * WESTLAKE, TEXAS 76262
Page 17 09/07/2010
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
according to state and local law. This meeting is held after the Board has reviewed the budget. The Board of Aldermen
approves a level of expenditure (or appropriation) for each fund to go into effect October 1, prior to the expenditure of any Town
funds for that budget year.
BUDGET AMENDMENT PROCESS
The Town Manager may request that the current year budget be amended. The Town Manager will review the documentation
and draft an ordinance that will amend the current budget. This ordinance is, 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.
THE TO OF WESTLAKE * 2650 OTTLNERER ROAD * WESTLAKE, TEXAS 76262
Page 18 09/07/2010
GENERAL FUND
Revenues
Funding of the Town's General Fund operations is derived from five revenue categories. Each of these categories is detailed
below with a brief description, how internal and external factors affect revenue amounts and how amounts differ from the prior
year. Operating revenues for FY 2005/2006 are projected to be $3,787,503 as compared to the projected FY 2004/2005 total of
$4,091,573. Projected transfers in represent an additional $1,965,337.
General Fund Proposed Revenues - FY 2005/2006
Sales & Use Taxes
Sales tax receipts are the result of a tax levy on the sale of goods and services within the Town as authorized by the State of
Texas. The maximum sales tax allowed in the Town of Westlake is 8.25% per dollar on all goods and services deemed
taxable. The State remits to the Town, on a monthly basis, an amount equal to 1% of the taxable sales within the Town, for
the General Fund, in addition to .5% to each of the two economic development corporations, which were formed for the
benefit of the Town of Westlake.
Sales taxes are budgeted to be slightly higher for FY 2005/2006 due to anticipated sales tax increases expected as a result of
corporate relocations to Westlake. Alcoholic beverage taxes are the result of mixed beverage and -private club registration
permits remitting a 14% mixed beverage gross receipt tax to the state. The state then remits 10.7143% of those taxes to the
Town. The alcoholic beverage tax revenue is expected to increase only slightly for next year, due to the growth of the
customer base 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.
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 expected to increase 1% over the
next year due to trends in home construction. The Westlake Academy continues to be a major attraction to prospective
homebuyers and will most certainly have a positive impact on residential development.
THE TOE TLAKE * 2650 OTTLN1GER ROAD * WESTLAKE, TEXAS 76262
Page 19 09/07/2010
Development fees related to the mall are projected to be over $1.6 million. Should these fees be collected, the Town Manager
will introduce appropriate budget amendments that will reflect the additional expenditures needed to accommodate the mall
construction.
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 2005-2006. Citation revenue for FY 2005/2006 is
projected at $815,000, a decrease of $55,000 from FY 2004/2005. This is due to the completion of SH 114, thereby
eliminating the construction zone, which carries double fine amounts if workers are present.
Miscellaneous Revenue
Miscellaneous revenue includes the sale of printed materials as well as interest earned.
Expenditures
FY 2005/2006 proposed operating expenditures in General Fund total $3,710,285, compared with FY 2004/2005 projection of
$3,528,937. This represents a 5% increase in overall expenditures from the prior year. The major portion of this increase is due
to a 15% increase in expenditures in the Fire/EMS department, which is the result of implementing an FTO training program. At
the end of the contract period, Westlake officers will be prepared to take over police services if the Board deems this decision to
be in the best interest of the Town.
Many departments saw an overall decrease in budgeted expenditures for FY 2004/2005. This is a product of conservative
planning, innovative cost control, and combining resources where possible. Our overall budget philosophy continues to focus on
meeting stated goals and objectives and maintaining a 90 day fund balance without having to adopt a property tax.
One component of cost control is the delay of hiring new positions. Two new positions budgeted for FY 2004/2005 have been
placed on hold until a more certain plan for mall construction has been received. These positions are now part of an expanded
level service package that will be presented as a budget amendment should the mall project move forward.
Personnel expenditures represent the largest single expenditure category, accounting for 38% of all Town expenditures. The
municipal court plans to hire an additional Warrant Officer for FY 2004/2005 to assist with the backlog of warrant collection.
The resulting revenue is expected to cover the cost of the hiring 3:1.
General Fund Proposed Expenditures by Department - FY 2005/2006
THE TOE T KE * 2650 OTTLNERER ROAD * WESTLAKE, TEXAS 76262
Page 20 09/07/2010
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 which 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 proportionate share of purchased MUD infrastructure
for each development based upon the acres removed form 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
The Utility Fund receives revenues from the duct bank, water sales, and wastewater billings. Each of these is described in more
detail below to provide an understanding of how different factors can explain their totals. FY 2004/2005 revenues are projected
to end with a total of $1,669,553. For the FY 2005/2006, proposed revenues equal $2,146,770. Most of the increase is due to an
increase in usage for water and sewer utilities which is attributed to residential growth.
Utility Fund Proposed Revenues - FY 2005/2006
THE TOF TKE * 2650 (S ERER ROAD * T1 E, TEXAS 76262
Page 21 09/07/2010
Water Revenue
The Utility Fund is the recipient of all revenue generated from water sales in the Town. The Town installed new water
infrastructure in 2000 in response to anticipated growth demands. Additional infrastructure has been added since that time to
accommodate significant residential growth. The Utility Fund continues to become more solvent as its customer base has
expanded. It is projected that the Utility Fund will become healthier over time as development, both residential and
commercial, continues to occur.
FY 2005/2006 saw a decrease in water rates for both residential and commercial customers, making the Town's rates more
reflective of that of surrounding cities.
Wastewater Revenues
Another major component for Utility Fund revenues is for wastewater. Wastewater will grow proportionate to water sales
significantly during FY 2005/2006 as residential growth continues.
No reductions in wastewater rates are planned at this time.
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 been
successful in leasing the duct bank conduit since FY 2001/2002. Additional duct bank leases are anticipated for FY
2005/2006 as new development comes on line.
Expenses
FY 2005/2006 projected expenses in the Utility Fund total $1,508,762. The proposed expenses are higher than FY 2004/2005,
which are projected to total $1,348,647. The major portion of this increase is attributed to making two annual payments for the
Overhead Storage Tank to the City of Keller to bring the Town current in this debt payment. The Utility Fund will continue to
fund capital projects that are necessary for infrastructure expansion and maintenance.
Utility Fund Proposed Expenses - FY 2005/2006
THE TOE T KE * 2650 OTTLNGER ROAD * WESTLAKE, TEXAS 76262
Page 22 09/07/2010
WESTLAKE VISITORS ASSOCIATION FUND
Hotel Occupancy Taxes are allocated to this fund and obtained through the assessment of a 7% hotel occupancy tax. Authority
granted by the State of Texas allows cities to levy a tax not to exceed 7% of the rental rate for a hotel/motel room. Funds
generated by the occupancy tax are required to be used in a manner, which directly enhances and promotes tourism and the
convention and hotel industry. Hotel occupancy revenue has increased over the past several years, with a slight decrease in FY
2004/2005. Projected revenues for FY 2005/2006 reflect a slight increase.
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 2004/2005 are
projected to be $440,100 compared to a budget of $453,000 for next year. The increase is due to increased marketing and
promotions, as well as encouraging hotel occupancy trends industry -wide.
Visitor Association Proposed Revenues - FY 2005/2006
Expenditures
Expenditures for the FY 2004/2005 are projected to be $440,100, which is 2% less than the FY 2005/2006 projections of
$453,000. Expenditures have increased over the last two years due to the addition of the Director of Marketing and Public
Affairs and the Marriott shuttle bus program. This program provides transportation to and from the airport for its guests, as well
as to local retail centers. The allocation for this program during FY 2005/2006 is $156,000, which is based on a percentage of
occupancy tax income. The level of participation from the Town can be expected to follow measurable performance indicators
from occupancy rates and revenue totals. The Board will be asked to consider a larger allocation by the Marriott for Marriott
related marketing and expense items.
Visitor Association Proposed Expenditures - FY 2005/2006
THE TO OF WESTLAKE * 2650 OTTLNGER ROAD * WESTLAKE, TEXAS 76262
Page 23 09/07/2010
Section 3
■ General Fund
Summary
Page 24 09/07/2010
General Fund
Program Summary
General Fund
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
Beginning Balance (Cash)
$
1,022,444
$
1,255,425
$ 1,255,425
$
1,440,078
Balance Sheet Affect to Cash '*
841,157
(550,247)
(550,247)
(9,250)
Revenue
3,196,309
5,459,371
4,091,573
3,788,104
Expenditures
3,804,485
3,606,340
3,528,937
3,709,269
Transfers In
1,515,373
-
85,000
1,965,337
Transfers Out
1,515,373
140,000
129,508
1,020,190
Ending Cash Balance
1,255,425
2,418,209
1,223,306
2,454,810
Restricted Funds
280,423
821,660
349,674
369,324
Ending Balance
$
975,002
$
1,596,549
$ 873,632
$
2,085,485
# Days Operating
94
162
90
205
General Fund - Transfers In
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
Capital Projects
FM 1938 - RA, MP,SL, Keller Shortfall
$
175,452
$
$ -
$
-
4A Funds
Dissolution of Fund
-
-
1,880,337
FM 1938 - Westlake Portion per Budget
82,174
-
-
FM 1938 - Westlake Portion
36,857
-
-
FM 1938/114 Interchange Improvements
216,897
-
-
Crime Control District
Transfer In
-
-
-
Utility Fund
Fort Worth Impact Fee Revenues
-
85,000
85,000
Debt Service
Debt Service for Civic Campus
742,080
-
-
Civic Campus Bond Funds
261,913
-
-
Total Transfers In
$
1,515,373
$
-
$ 85,000
$
1,965,337
Page 25 09/07/2010
General Fund
Program Summary
General Fund - Transfers Out
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
Transfer to Capital Projects
FM 1938 (114 to 1709)
$
294,483
$
-
$
34,508
$
-
FM 1938 / 114 Interchange (4A)
216,897
-
-
-
Transfer to Permanent Capital Maint Fund
Preventative Maintenance
-
10,000
-
10,000
Dove Road Improvements
-
95,000
-
66,000
Transfer to Special Revenue Fund - Grants
Town's 10% portion of FEMA grant
-
-
-
44,801
Transfer to Capital Project Fund
Cemetery Maintenance
-
10,000
-
-
Portable Buildings
-
-
-
57,400
Temporary Parking
10,000
93,800
Civic Campus Expansion
-
25,000
85,000
266,525
4B Economic Development Fund
2002 Certificates of Obligation
742,080
-
-
-
2003 Certificates of Obligation
261,913
-
-
Debt Service Fund
-
-
Shortfall of 4B funding for Debt Service
-
-
-
481,664
Total Transfers Out
$
1,515,373
$
140,000
$
129,508
$
1,020,190
General Fund
Restricted Funds/Designated
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
Court Security
$
54,493
$
66,225
$
70,993
$
84,993
Court Technology
43,641
67,975
49,996
55,646
Court Bonds
-
-
4,500
4,500
Trail Escrow
75,000
75,000
75,000
75,000
Glenwyck Farms Trail & Dove Road Escrow
-
-
149,185
149,185
Capital Projects - Civic Campus
107,289
-
-
-
Long Range Commitment (debt service)
-
612,460
-
-
Total Restricted/Designated Funds
$
280,423
$
821,660
$
349,674
$
369,324
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 26 09/07/2010
GRAND TOTAL REVENUES
Actual FY 03/04 3,196,309
Amended Budget 04/05 4,091,573
r -Adopted Budget 05/06 3,788,103 71
■ Other Misc
General
Fund
Schedule
0 Interest & Misc
of Revenues
1 %
28%13
Acct
Dept
Revenue Description
Actual
I FY 03104
Amendedq.
Budget
FY 04/05
Tax
Acct
Dept
Revenue Description
I
Actual
FY 03104
Amended
Budget
FY 04105
• r
0%
0%
13 Permits & Fees
Franchise
23%
Fees
R31312
F
31310 11 Sales Tax Revenue 882,685 1,016,000 1,320,000
F
New 20 Sponsorship/ Advertising 0 0
5,000
11 Sales Tax Refund (14,639) 0 0
New 20 Webhosting 0 0
3,000
31430 11 Mixed Beverage Tax 10,511 13,182 10,500
New 20 Real Estate Listings 0 0
2,000
_ Total Tax Revenuel 878,557 1 1,029,182 1 1,330,500
1 Total Technology RevenueT----------Ol Revenue ----------O 0
10,000
w
S
L)
z
u.
31820 11 AT&T Franchise 42,445 44,975 50,500
H
LL
w
w
ui
a
32208 11 Other Misc Permits 1,085 300
500
31821 11 Verizon Franchise 2,374 7,635 12,000
34133 11 Special Event Fees 0 0
500
31822 11 TXU/Atmos Gas Franchise 10,235 9,630 14,000
34130 12 Development Fees 135,740 175,000
210,550
31823 11 Charter Franchise 193 225 250
32209 12 Grading/Excavation Permits 0 22,100
22,321
31824 11 One Source Franchise 856 860 750
32210 12 Building Permits 623,144 392,550
396;476
31825 11 Southwestern Bell Franchise 66,694 63,480 67,250
32211 12 Inspection/Plan Reviews 0 219,635
221,831
31826 11 Tri County Electric Franchise 198,022 209,365 205,000
32212 12 Re -Inspection Fees 0 600
600
31827 11 Trinity Waste Franchise 12,705 7,500 7,250
34132 12 Contractor Registrations 22,000 17,350
17,524
31828 11 Misc Franchise Fees 3,698 4,125 5,100
34010 14 Fire Code Permits 200 1,000
600
34015 14 Fire Sprinkler Permits 0 8,625
7,150
Total Franchise Fee Revenuel 337,221 1 347,795 1 362,100
w
f
L)
Z
w
2
.F6
w
w
Lu
i
-
36110 11 Interest Earned 5,992 9,900
91000
w
00
34000 14 EMS User Fee 19,892 34,110 21,000
34005 14 FEMA Federal Grant Revenue 171,076 0 0
36110 15 Interest Earned 1,537 3,870
1,900
34006 14 Homeland Security Grant 0 25,512 0
36111 11 Note Receivable Interest 5,776 4,770
3,690
35110 15 Citation Revenue 561,874 870,000 815,000
39400 11 Misc Income 12,656 6,500
15,000
35110 15 FTO Citation Revenue 0 0 97,650
39400 13 Misc Income 0 0
0
35120 15 Court Technology 20,786 25,000 22,500
39400 14 Misc Income 0 1,600
1,600
35130 15 Court Security 15,594 20,000 17,500
39400 16 Misc Income 0 0
0
35140 15 Warrant Revenue 37,654 108,006 0
39400 17 Misc Income 0 0
0
35150 15 Warrant Service Fees 44,210 50,000 70,000
39400 18 Misc Income 0 0
0
35160 15 NSF Check Revenue 675 400 500
39400 19 Misc: Income 0 1,000
1,000
35170 15 Court Efficiency Fees 0 0 250
39400 21 Misc Income 0 0
0
35180 15 Law Enforcement Standards 660 1,479 700
39401 15 Administrative Fee 0 3,746 2,000
Total Court & EMS Revenuel 872,421 1 1,138,253 1 1,047,100
v
rn
f
w
O
1 Total Interest Income/Misc Revenue in
33701 11 Sale of Land 0 412,239
0
v
w
of
y
a
o.
31110 19 Lessons 0 500 500
31120 19 Clinics 0 500 500
34141 11 Sales of Printed Material 179 235
500
31130 19 Tournaments 0 1,750 1,600
34142 11 Historical Board 6,055 0
0
31140 19 Leagues 0 2,500 2,500
36111 11 Note Receivable Principal 0 15,964
17,042
32120 19 Kid's Programs 0 6,000 6,000
38805 11 Interfund Receivable due from OF 0 203,158
27,590
32130 19 Wellness Program 0 500 500
39410 11 TSH Rental Income 4,166 6,017
5,605
33110 19 Court Fee 0 250 250
39500 11 TSH Donation 50,000 50,000
50,000
33120 19 Equipment Rental 0 75 0
52590 88 Contribution from Others 101,739 0
0
34110 19 Special Events 0 75 75
52570 88 Contribution from Westlake (4A) 134,177 0
0
37500 11 Glenwyck HOA Reimbursement 3,663 11,780
15,500
Total Parks & Rec Revenue 0 12,150 11,925
Total Other Misc Revenue 299,979 699,393
116,237
GRAND TOTAL REVENUES
Actual FY 03/04 3,196,309
Amended Budget 04/05 4,091,573
r -Adopted Budget 05/06 3,788,103 71
Page 27
09/07/2010
■ Other Misc
3%
0 Interest & Misc
O Court & EMS
1 %
28%13
Tax
■ Parks & Rec
■ Technology
0%
0%
13 Permits & Fees
Franchise
23%
Fees
10%
Page 27
09/07/2010
General Fund Summary of Expenditures by Department
Department
Actual
FY 03/04
Amended
Budget
FY 04/05
r Adopted
Budget
IFY 05/06
Administrative
Building
1,072,082
84,404
740,107
118,146
561,099
121,601
Secretary
71,478
74,062
102,778
EMS
1,768,410
1,566,791
1,717,898
Court
253,999
281,393
339,828
Public Works
99,773
91,578
78,762
Facilities
99,456
231,793
311,178
Finance
136,939
158,334
153,547
Parks & Rec
9,767
105,923
114,578
Technology
53,761
60,810
86,200
Engineering
154,416
100,000
125,000
TOTALI
3,804,485
3,528,937
3,712,469
GRAND TOTAL EXPENSES
Actual FY 03/04 3,804,485
Amended Budget 04/05 3,528,937
Adopted Budget • i.
Page 28
EMS
46%
Court
Secretary 9%
3%
n Public Works
I 2%
Facilities
Building 9%
3%
ngineering
4% Parks & Rec
Administrative 3% Finance
15% Technology 4%
2%
09/07/2010
FUND 100 - General Fund
Proposed Budget FY 2005/2006
MHER SOURCES & USES
Transfers In
52560
88
Xfr in from OF
0
0
85,000
85,000
52530
88
Xfr In from CC
0
0
0
0
52510
88
Xfr In from OS
175,452
0
0
0
52570
88
Xfr In from 4A
0
0
0
1,880,337
52570
88
Xfr In from 4A
82,174
0
0
0
52570
88
Xfr In from 4A
36,857
0
0
0
52570
88
Xfr In from 4A
216,897
0
0
0
52530
52530
new
88
88
88
Xfr in from DS
Xfr in from DS
Xfr In from CCD
742,080
261,913
0
0
0
0
0
0
0
0
0
0
TOTAL TRANSFERS INI
1,515,373 1
85,000
1,965,337
Transfers Out
62590 99
Xfr Out to Capital Projects Fund
0
10,000
0
0
62590
99
Xfr Out to Capital Projects Fund
294,483
0
34,508
0
62590
99
Xfr Out to Capital Projects Fund
0
25,000
85,000
266,525
62590
99
Xfr Out to Capital Projects Fund
0
0
10,000
93,800
62590
99
Xfr Out to Capital Projects Fund
0
0
0
57,400
62590
99
Xfr Out to Capital Projects Fund
216,897
0
0
0
62600
99
Xfr Out to Permanent Capital Maintenance Fund
0
10,000
0
10,000
62600
99
Xfr Out to Permanent Capital Maintenance Fund
0
95,000
0
66,000
62590
99
Xfr Out to Special Revenue Fund
0
0
0
44,801
new
99
Xfr Out to Debt Service Fund
0
0
0
481,664
62610
99
Xfr Out to 413
742,080
0
0
0
62610
99
Xfr Out to 413
261,913
0
0
0
TOTAL TRANSFERS OUTI
1,515,373 1
140,000 1
129,508 1
1,020,190
NET TRANSFERS
0 1
(140,000)1(44,508)1945,147
Page 29 09/07/2010
Actual Sales Tax Revenue History
Values Shown at 100% Collected
General Fund 50% - 4A Fund 25% - 4B Fund 25%
3,000,000
2,719,080
2,750,000 w
2,500,000
2,300,915
2,250,000 2,169,785 A
A 2,032,000
2,000,000 1,934,854 e
A
1,766,359
1,750,000
1,521,760
1,500,000 A
1,308,816
1,250,000 A 1,188,813
1,000,000
738,258
750,000
500,000 r
228,127 or
250,000
81727 101,894 99,834 95,551
0
1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005/2006
actual actual actual actual actual actual actual actual actual actual actual actual actual actual actual budget
Page 30 09/07/2010
GENERAL FUND
Note Receivable - Trophy Club (Ambulance)
1 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
100.12802.00
100.36111.11
100.12801.00
Payment
Date
Beginning
Balance
Total
Payment
Principal
Interest
Ending
Balance
1 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
4
06/01/04
85,574.05
20,731.00
14,954.75
5,776.25
70,619.30
5
06/01/05
70,619.30
20,731.00
15,964.20
4,766.80
54,655.11
i61Mili!
54,655.11
20,731.00
37,613.33
7
06/01/07
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 31 09/07/2010
GENERAL FUND
Interfund Repayment Schedule - Due from Utility Fund
Page 32 09/07/2010
Extension of
GW Farms
1
100 15205.00
100.38805 .11
Water Mains
Peak Payment
377 Water Line Sewer Line "A"
Waterline
500.23001M
Pymt
Payment
Beginning
$57,600
$95,000
$4,895
$1,515
$2,033 1
$161,043
Ending
#
Date
Balance
Amount Due
Amount Due
Amount Due
Amount Due
Amount Due
TOTAL
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 32 09/07/2010
f i
t Aeo, Tiowololo Weot"e0000
Goals & Objectives - FY 05/06 ADMINISTRATIVE
Program Description
The Administration program will make the Town of Westlake the most beautiful and desirable place to live, work, play and educate
children in America.
Trends
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. Pool natural gas mineral right owners to maximize return and minimize intrusion for property owners, the Town of Westlake and
the Westlake Academy.
6. Deploy a real time water system of billing designed to conserve water and lower cost.
THE TOWN OF TI S. * 2650 OTTINEiER; ROAD * W T KE-, TEXAS 76262
Page 33 09/07/2010
d 'S
a �
1 e, To 10 we4t"*
5. Y
Goals & Objectives - FY 05/06 TOWN 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, coordinating and sending invitations to awardees for the annual reception, 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 32.6%,
2. Open records requests for FY 2005 are trending to decrease by approximately 26% compared to prior year.
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 low and our own ordinance;
3. Conduct elections 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.
Program 2005/06 Objectives
.....................................................................................................................
1. Conduct local option election Feb, '06
2. Conduct 4A dissolution election, Feb. '06
3. Conduct Crime Control District Election, Feb'06
4. Provide outstanding citizen and staff responsiveness.
5. Improve filing system for permanent records.
6. Provide guidance in the development of records management for staff.
7. Create more effective record keeping for Texas Student Housing.
8. Continue professional development and training to maintain state election law standards.
9. Continue professional development and training to maintain state Municipal Clerk Certification.
Performance Measures
.....................................................................................................................
1.
Complete codification of existing ordinances
January '06
2.
Complete record scan to digital media
August '06
3.
Post newly codified Ordinances, scan data
September'06
4.
Complete Records management training for all admin staff
May 'O6
5.
Streamline TSH Record keeping
November '05
6.
# State certification training seminars attended
1
(Election Law Training in Austin)
7.
Complete requirements to maintain certification
November '05.
Program Provided in Partnership With
.....................................................................................................................
Consultants
Town of Westlake staff
Program Customers
.....................................................................................................................
Board of Aldermen Town of Westlake staff Town of Westlake Citizens
Historical Board Commissions Texas Student Housing Authority Board
THE TOWN OF WESTLAKE * 2650 UTTINEiE DAD * TLAKE, TEAS 76262
Page 34 09/07/2010
f i
t Aeo, Tiowololo Weot"e0000
Goals & Objectives - FY 05/06 EMERGENCY SERVICES
Program Description
.....................................................................................................................
The Department of Public Safety provides the public safety needs of the Town via a variety of programs and services. The goal is to
provide the most efficient method of delivering the traditional services - Fire Protection and Prevention, Emergency Medical
Services, and Law Enforcement -while partnering other Town, as well as private and public, organizations to expand services.
Trends
.....................................................................................................................
1. The Department currently provides a portion - Fire and EMS - of the Town's public safety needs but is poised to assume the full
responsibility of that role.
2. Department personnel have received certification as Peace Officers and continue training to implement a fully integrated
Department of Public Safety in order to meet the needs for the citizens, the business community and visitors to the Town.
3. This expectation of an expanded role for the Department will be addressed through public/private partnerships and
coordination with our neighbors as well as other Town Departments
Program Broad Goals
.....................................................................................................................
1. To provide the most economical and efficient service to the Town as possible.
2. Primarily, the improvement of existing programs is the goal of the Department.
3. The Department plans to improve service; continue to support the Courts in reducing outstanding warrants; plan for the future
by training personnel to assume the roles that are currently contracted out, such as the Fire Marshals' duties and Law
Enforcement.
Program 2004/05 Objectives - Completed
.....................................................................................................................
1. The Department has taken 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.
2. The Board passed the ordinance creating the Department of Public Safety, paving the way for the creation of a fully
integrated Department of Public Safety for the Town of Westlake.
3. The Department has conducted numerous CPR class and trained individuals at the Solana Fitness Center in the proper use of
automatic external defibrillators (AED). The Department will continue this trend and expand the programs in the next fiscal
year. (On going)
Program 2005/06 Objectives
.....................................................................................................................
Objectives carried forward
1. The establishment of a fully integrated Department of Public Safety by adding Law Enforcement duties to the Department's
mission. The addition of Law Enforcement duties to the Department will still require contracting animal control,
communication, and jail services
2. Enhance revenue streams to fund public safety needs and activities.
3. Continue training personnel to phase out the current contractual services
Objectives planned for current year
1. Complete the current round of the FEMA grant by equipping a quick attack/grass unit and placing it in service; join the NETCO
radio system; and purchase the decontamination and containment equipment necessary for first response on hazardous
materials incidents. .
2. Begin training personnel in Law Enforcement activities by utilizing a recognized field -training program and partnering with the
Keller Police Department for implementation of this program. Department and Town Staff experienced in Law Enforcement
activities will also lend their expertise in this program.
3. 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.
4. Continue sending personnel not tri -certified to training. The main emphasis is to have all personnel attain their law
enforcement license.
THE TOWN OF TI S. * 2650 OTTINEiER; ROAD * W T KE-, TEXAS 76262
Page 35 09/07/2010
d 'S
a �
1 e, To 10 we4t"*
5. Y
Goals & Objectives - FY 05/06 EMERGENCY SERVICES
Performance Measures
.....................................................................................................................
1.
All employees trained in CPR and Automatic External Defibrillators (AED)
January 2006.
2.
Personnel conducts residential inspections
10070
3.
Personnel conducts business/commercial inspections ( not new construction)
75%
4.
Full participation in the radio re -banding process.
September, 2006
5.
Collections of billable EMS revenue increased
15%
6.
Training and certification of three (3) HazMat Technicians
July, 2006
7.
Completion of a Field Training Program by all tri -certified personnel
January, 2006
8.
Maintain the monthly traffic enforcement activities
August, 2006
9.
Establish four (4) crime watch programs
September, 2006
10.
Establish a community oriented police force
September, 2006
11.
25% of part-time employees are tri -certified
July, 2006
12.
Test and map 100% of the fire -hydrant located within Town limits
January, 2006
Program Provided in Partnership With
.....................................................................................................................
The City of Keller Police Department
The City of Southlake Department of Public Safety - Fire Marshal's Office
Northeast Fire Department Association (NEFDA)
Northeast Tarrant County Radio Consortium
North Central Texas Council of Governments - Emergency Management
Ft. Worth and Tarrant County Office of Emergency Management
Tarrant County College - Northwest Campus
Maguire Partners and the Solana Fitness Center
Program Customers
.....................................................................................................................
Westlake citizens
Business leaders
Visitors to the Town of Westlake
Community businesses in the Solana Complex
Westlake Academy
Builders
Contractors
Developers
THE TOWN OF TLAKE * 2650 OTTINEiER; ROAD * W T KE-, TEXAS 76262
Page 36 09/07/2010
f i
t Aeo, Tiowololo Weot"e0000
Goals & Objectives - FY 05/06 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 3 months from delinquency to the date of issuance.
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.
3. The collection efforts of the Warrant Officer have averaged $29,000 per month in both cash and non-cash clearances.
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. Remain current on warrant
issuance.
3. 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.
4. Court staff will develop a collection plan in conjunction with the collection agency and other involved agencies. The
collection efforts will be monitored and monthly updates reported to Town Management.
Program 2004/05 Objectives - Completed
.....................................................................................................................
1. Objective completed of citation entry within 3 days of receipt in the Court office.
2. Issue two delinquent sets of warrants each month until the Court is current.
Program 2005/06 Objectives
.....................................................................................................................
Objectives carried forward
1. Provide timely Bench and Jury Trials to all defendants the opportunity to present their cases to the Judge in an expedient
manner.
2. Remain current on warrant issuance. (On going)
Objectives planned for current year
1. Enter tickets and perform the deposit function on a timely basis.
2. Increase the collection rate of the outstanding warrant in both cash and non-cash collections.
Performance Measures
.....................................................................................................................
1.
# Bench or Jury Trial Dockets per month
1
2.
% Reduction in outstanding warrants
40%
3.
% citations entered within 3 days of receipt
100%
4.
% daily deposits of mail payments
100%
5.
$ increase in collection for clearances
$42,000
b.
% improvement in collection of outstanding warrants
50%
Program Provided in Partnership With
.....................................................................................................................
DPS Employees Keller Police Department
Program Customers
.....................................................................................................................
Court patrons Attorneys
THE TOWN OF WESTLAKE * 2650 O'TtNQE ROAD * WESTLAKE,, 'ham '76262
Page 37 09/07/2010
f i
t Aeo, Tiowololo Weot"e0000
Goals & Objectives - FY 05/06 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, such as assisting with:
• setting up and procuring items for Bandana Bonanza,
setting up Family Fun Nights, coordinating/inspecting work for facility maintenance,
• setting up Arbor Days, providing traffic control devices for DPS use, assist with supervising community service workers.
Trends
.....................................................................................................................
1. Most of the current water system is new and is in good condition. Over the past year preventative maintenance was
conducted on the ground storage tank and pump station generator.
2. The purchase of the existing Keller waterlines in Westlake was completed last year. Westlake is now responsible for repairing
the acquired waterlines.
3. Over FY 04/05 there has been a 21 % increase in water/sewer revenue with a 21 % increase in water/sewer expenditures.
4. A 49% increase in the number of water customers has created a higher demand on the water and wastewater system and is
increasing operating costs. (204 customers for FY 2004 - Estimated 303 customers for FY 2005)
5. The Max Hour cost has been reduced with the introduction of the water tower; however, the Max Day cost continues to
increase as the Town's population grows.
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. Establish a preventative maintenance schedule for water and wastewater 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.
Program 2004/05 Objectives - Completed
.....................................................................................................................
1. Conducted infrastructure quality control inspections of all new installations and maintenance bond items.
2. Repaired all manholes, clean outs, and sewer lines to reduce groundwater infiltration.
3. Reviewed "real-time" meter reading system of Mahoeta Boone for full scale implementation.
4. Responded within 1 day to all pothole work orders.
5. Retained resource for sanding/salting roadways during freezing conditions
6. Responded to all sign repair work orders within two working days. Inventory all streets and identify prior maintenance.
7. Reviewed existing engineering standards and implement new engineering drawings to ensure proper infrastructure
construction.
8. Evaluated water, wastewater rates and tap fees.
9. Inspected and documented all manholes within and adjacent to the Glenwyck Farms subdivision.
Program 2005/06 Objectives
.......................
Objectives carried forward
1. Integrate existing pressure tank into the SCADA system to back up the elevated storage tank.
2. Implement a meter testing and replacement schedule for the Town's water meters every five years. Replace 50% of the
existing manual read meters with radio read meters.
3. Verify condition of streets every year.
4. Construct a replacement/rehabilitation plan based on sub -grade, paving, and drainage conditions.
5. Repair all manholes within and adjacent to the Glenwyck Farms subdivision.
THE TOWN OF WESTLAKE * 2650 0TUNGER ROAD * WESTLAKE, TEAS 76262
Page 38 09/07/2010
d 'S
a �
1 e, To 10 we4t"*
5. Y
Goals & Objectives - FY 05/06 PUBLIC WORKS
Program 2005/06 Objectives (continued)
...............................
Objectives planned for current year
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. Continue to work on updating utility maps for the water, wastewater, and duct bank systems.
4. Inspect, lubricate, fuel, and repair all water and wastewater facilities as required.
5. Develop a sewer cleaning maintenance program for cleaning the entire system annually.
6. Create a meter reading technology development fee/ordinance as a requirement for new plats that will integrate the Town's
(existing) system.
7. Rehabilitate approximately 4,000 LF of Dove Road
Performance Measures
.....................................................................................................................
1.
Response times for all emergencies
1 hr.
2.
% work orders completed within 2 days
100%
3.
% reduction in peak charges
10%
4.
% Duct Bank access calls responded within 1 hr.
100%
5.
% Dig permits reviewed within 5 days
100%
6.
Meter Pilot program completion
July '06
7.
% manholes inspected
50%
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
THE TOWN OF WESTLAKE * 2650 0TUNGER ROAD * WESTLAKE, TEAS 76262
Page 39 09/07/2010
f � i
t Aeo, Tiowololo Weot"e0000
Goals & Objectives - FY 05/06 FACILITIES MAINTENANCE
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.
Trends
.....................................................................................................................
1. Since occupancy of the 53,000 square foot civic campus facility in the fall of 2003, maintenance costs have and will continue
to increase.
2. Made of natural stone and wood interior and exterior, the facility is surrounded by rolling landscape and manicured lawn
areas.
3. The facility is equipped with state of the art security cameras, card scanners and climate control systems.
Program Broad Goals
.....................................................................................................................
1. The Maintenance program will schedule timely, preventative maintenance and repair of the Academy, Town and Glenwyck
Farms Park, to protect the town's investment in its infrastructure and keep The Academy, Town facilities and Glenwyck Farms
Park aesthetically pleasing.
2. Our goal is to measure and implement the most cost effective plan for consumption of utility services according to state law
and regulations.
3. Develop new learning and office space due to the expansion of student population.
Program 2004/05 Objectives - Completed
.....................................................................................................................
1. Implemented maintenance contract for HVAC, landscaping, power needs, security systems, cemetery, fire system and
cleaning services
2. Implemented an online scheduler for the Town and Academy.
3. Planned and developed the expansion of the school, which includes class room conversions, parking and temporary facilities
for Town employees.
4. Responded to over 250 requests from teachers and employees for repair or maintenance calls for service.
5. Developed a pest management program to meet state requirements.
6. Ensured the Christmas Lighting and Decoration Day have a quality setting
Program 2005/06 Objectives
.......................
Objectives carried forward
1. Maintain the integrity of athletic fields: (On going)
2. Provide monthly energy usage reports and implement best practices by utilizing our climate control systems. Has track energy
usage and will use the past year as a bench mark on usage.
3. Ensured the Christmas Lighting and Decoration Day have a quality setting
Objectives planned for current year
1. Maintain a quarterly and monthly maintenance agreement for the Academy and municipal campus for the following systems:
• Cleaning service - Daily and semi-annual, window, carpet and file floors
• HVAC and heating - Quarterly
• Electrical systems - Quarterly
• Security systems - Semi-annual
• Fire sprinkler and alarm systems - Annual
2. Maintain the Campus and parks landscaping and trails maintenance:
• Campus and Park - 30 mowings, fertilizations, weed control
• Athletic Field - 2 field mowings around athletic field
• Park- 5 mowings
THE TOWN OF WESTLAKE * 2650 0TUNGER ROAD * WESTLAKE, TEAS 76262
Page 40 09/07/2010
d 'S
a �
1 e, To 10 we4t"*
5. Y
Goals & Objectives - FY 05/06 FACILITIES MAINTENANCE
Program 2005/06 Objectives (continued)
.....................................................................................................................
Objectives planned for current year (continued)
3. Provide new temporary buildings and parking for court and town offices that will be located on the north side of the pond.
4. Develop a new temporary turn around and parking area for the 7th and 8th grade classes on the west side of Pod G.
5. Remodel three class rooms in Pod E.
6. Support and assist in planning for the arts and sciences building.
7. Provide monthly energy usage reports and implement best practices by utilizing our climate control systems.
Performance Measures
.....................................................................................................................
1.
% compliant with fire sprinkler and alarm system inspection schedule
100%
2.
% reduction in cleaning complaints
50%
3.
Begin temporary parking areas
October 2005
4.
Complete temporary building
January 2006
5.
Court employees and building inspectors relocated
February 2006
6.
Complete final drawing on the Pod E remodel
February 2006
7.
Pod E start date
June 5th 2006
8.
Complete arts and science facilities estimates
January 2006
9.
Implement a tracking process for monthly energy usage by
December 2005
10.
Complete budgeted repairs to building
September 2006
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
THE TOWN OF WESTLAKE * 2650 OTTINGER ROAD * WESTLAKE, TEAS 76262
Page 41 09/07/2010
nk wesT
AKE A�
Goals & Objectives - FY 05/06 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, cash management and the fixed assets
inventory tracking system.
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, cash management and the fixed assets inventory.
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. With the implementation of the STW governmental accounting software in October 2004 and the training and experience of
staff, the efficiency and effectiveness of the Finance Department continues to improve.
a. The processing of accounts payable and payment of vendors for the Town has increased 26%, from a total of 2,116
invoices to a projected 2,670 for FY 04/05.
b. The processing of accounts payable for Westlake academy has increased 27%, from a total of 604 invoices to a
projected 768 for FY 04/05.
2. The purchase and implementation of the STW Utility Billing software took place in July 2004 and is now being maintained
directly by Town personnel.
a. There is an estimated account growth of 39%, from 20 new utility customers in FY 03/04 to a projected 99 new
accounts for FY 04/05.
b. The Utility Billing for FY 04/05 was completely maintained by Town personnel, with only 2 months in FY 03/04 under our
management. Approximately 30 minutes is needed to open and set up a new account. Based on this information,
the required time to set up new customer accounts has increased from 5 hours to 50 hours of personnel time for FY
04/05.
c. The average time to receive, prepare and process 20 payments on accounts into the utility billing software is
approximately 1 hour. In FY 2004 one-half of these payments were entered by AquaSource billing. Our personnel
hours were minimal when we were associated with AquaSource; approximately 5 minutes was needed to enter the
deposit amount into our general ledger based on a bank deposit and report. The conversion to the Utility Billing
software took place in July 2004 and the remaining payments were entered by town personnel totaling
approximately 30 hours of personnel time for FY 03/04. With the addition of an estimated 99 new customers, our
year-end accounts should total 303. The total time required to enter these payments is approximately 16
hours/month; an additional 162 personnel hours for the year.
3. In previous years, all contractor registrations were reviewed and processed by the Building Inspection department. In FY 2005
this responsibility was delegated to the Finance Department. The FY 04/05 year-end estimated registrations are 142. With the
processing of each contractor being approximately 15 minutes, this equates to approximately 35 additional personnel hours.
4. In addition, all completed building permits were previously distributed to the appropriate contractor by the Building Official.
The Finance department has also assumed these responsibilities. The estimated building permits for FY 04/05 is 273. The
processing of these is also approximately 15 minutes; thus, an additional 68 personnel hours was assumed by the Finance
Department during the FY 04/05.
THE TOWN OF WIES 1 KE *2650 OTTING ER ROAD * WESTLAKE, TEXAS 76262
Page 42 09/07/2010
d 'S
a �
1 e, To 10 we4t"*
5. Y
Goals & Objectives - FY 05/06 FINANCE - ACCOUNTING
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 2004/05 Objectives - Completed
.....................................................................................................................
1. Developed cash management and departmental reporting requirements.
2. Provided monthly reports and support to all departments for review and feedback.
3. Documented procedures for accounting functions related to the Town and Academy.
4. Reviewed insurance coverage and premiums.
5. 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.
Program 2005/06 Objectives
.....................................................................................................................
Objectives carried forward
1. Identify and log all fixed assets (Town and Academy) into the STW inventory system and maintain depreciation schedules for
all applicable assets that exceed the approved capitalization threshold in the system
2. Implement purchase order system for all Town and Academy purchases in conjunction with the software and provide training
to all departments to ensure compliance.
Objectives planned for current year
1. Integrate billing option into the Town's website by creating means to pay water bills, fees, etc. on line.
2. Analyze and review STW software option for upgrade from DOS based system.
3. Continue to provide monthly reports and support to all departments for review and feedback.
4. Document policies for the Town and Academy and policies and procedures for all accounting functions related to the
Foundation.
5. Review insurance coverage and premiums annually. (On-going)
6. 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. (On-going)
7. Monitor accounts receivable aging report to ensure that aging is at a minimum of 90% and use appropriate collection
methods following State and Federal collection laws to collect delinquent accounts owed to the Town.
Performance Measures
.....................................................................................................................
1. % bank statements reconciled within 30 days
100%
2. % monthly financials completed and sent to
the appropriate departments for review by
the 15th of each month
100%
3. Complete and deliver FY2004/2005 audit report
Feb'06
4. % invoices paid within 30 days of receipt
90%
5. Quarterly reports delivered
20th 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
Water/sewer consumers Westlake Historical Board
THE `OWN OF W,"EST KE *2650 OTTING ER ROAD * WESTLAKE, TEXAS 76262
Page 43 09/07/2010
d 'S
a �
1 e, To 10 we4t"*
5. Y
Goals & Objectives - FY 05/06 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 2004/05 Objectives - Completed
.....................................................................................................................
1. Improved the Town's flex plan by implementing Ach reimbursements, and improved pertinent literature regarding the benefits
and use of flexible spending plans.
2. Finalized the automation of HR benefits reporting with the IRS and TMRS.
3. Conducted annual salary surveys to remain competitive.
Program 2005/06 Objectives
1. Strengthen employee communications through use of the Town's website by providing an employee intranet. The intranet site
would contain payroll forms, benefits information, contacts, payroll calendars, employee newsletter, and benefit statements.
2. Evaluate addition employee benefit options that do not result in additional cost to the Town.
3. Develop a wellness program for Town Manager and Board consideration.
4. Conduct annual salary surveys for the Town of Westlake and Westlake Academy to remain competitive.
5. Review all insurance programs in terms of cost and service and if necessary develop RFP's.
6. Human Resources Manager to obtain IPMA-CP certification.
Performance Measures
.....................................................................................................................
1.
Handbook reviews to update for compliance and best practices
Quarterly
2.
Employee evaluations completed on time
90%
3.
Employee intranet portal completion
April 2006
4.
Present new "no -cost" employee benefit options o the Town Manager
2
5.
Salary surveys complete
July 2006
6.
Wellness program presentation to the Board
January 2006
7.
Complete Insurance plan reviews
June 2006
8.
IPMA-CP certification complete
August 2006
Program Provided in Partnership With
.....................................................................................................................
Professional HR associations Insurance brokers Outside consultants
Program Customers
.....................................................................................................................
Town of Westlake Employees Westlake Board of Alderman Legal Entities
THE TOWN OF WESTLAKE * 2650 OEiER ROAD * E, m TEXAS 76262
Page 44 09/07/2010
f i
t Aeo, Tiowololo Weot"e0000
Goals & Objectives - FY 05/06 PARIS and RECREATION
Program Description
.....................................................................................................................
The Recreation Program will offer leagues, lessons, summer camps, community education classes and after school programs for
the adult and youth population in Westlake. The Westlake Academy and the park, located within Glenwyck Farms, will provide the
facilities and space to deliver all recreation programs to the public. The park at Glenwyck Farms and the Academy campus will
host Arbor Day, Bandana Bonanza, Christmas Lighting and Decoration Day.
Trends
.....................................................................................................................
1. The completion of the recreational center and the population growth of The Town of Westlake have increased the need for
parks and recreation programs and services to be offered to citizens of Westlake for the first time.
2. The Glenwyck Farm three year subdivision 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.
Program Broad Goals
.....................................................................................................................
1. Recreational and educational opportunities for the adult and youth citizens of Westlake and surrounding communities will be
offered.
2. Revenue generated through these programs and services will help to support facility cost.
Program 2004/05 Objectives - Completed
.....................................................................................................................
1. Provided after school recreation program for K -71h grades. There were 276 kids enrolled for 15 different activities. from Sept. -
May - Net -$1,636.00
2. Provided community education class- Spanish class
3. Hosted the boys and girls 7'h and 8th grade basketball tournament, Net $818.00
4. Increased revenues for the following local community events: Arbor Day - 04 -$818.91 - 05- $52.38 increased paid service and
Bandana Bonanza 04-$5,000 - 05- $6,500
5. Developed a relationship with Glenwyck Farms HOA and received all park maintenance requests for the HOA
6. Recreational and educational opportunities for the adult and youth citizens of Westlake and surrounding communities will be
offered. Spanish classes and Sunday evening basketball were offered
Program 2005/06 Objectives
.....................................................................................................................
Objectives carried forward
1. Provide limited privet lessons to students
2. Increase Park and Recreation revenues through ticket sales for local sporting events and theme parks
Objectives planned for current year
1. Host tournaments and/or leagues to increase revenue
2. Provide summer youth programs
3. Ticket sales for local sporting events and theme parks to students and residences.
4. Provide limited private lessons for basketball and volleyball.
THE TOWN OF WESTLAKE * 2650 OTTINGER ROAD * WESTLAKE, TEAS 76262
Page 45 09/07/2010
Pit
Goals & Objectives - FY 05/06 PARKS and RECREATION
Performance Measures
.....................................................................................................................
1. Revenue from one basketball /volleyball tournament by February 2006 $1,600
2. % increased revenue for summer programs based on 2004/2005 15%
3. Revenues through facility rentals and ticket sales for sporting events and theme parks $1,000
4. Provide outdoor fishing and camping programs - March 2006 100 participants
Program Provided in Partnership With
.....................................................................................................................
Bowmen Sports Programs to assist with summer programs
Outsource United States Tennis Association coach
Program Customers
.....................................................................................................................
Westlake Academy
Town employees
Westlake Residents
THE TOWN OF WESTLAKE * 2650 OTTINGER, ROAD
WEST KE-, T X, AS 76262
Page 46 09/07/2010
f k
A �
a } AceTituv*V 0 We4t"eoo
Professional Services - FY 05/06 INFORMATION TECHNOLOGY
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. 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.
2. Regulatory compliance concerns increase IT burden. As the number of Westlake employees continues, traditional methods for
records archiving (including email) for, among other things, open records request will become increasingly inefficient and may
not prove sufficient.
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. Improve traditional services. Design and Implement innovative uses of technology to provide improved services to the Town's
citizens.
3. Systems Administration. Maintain IT systems with prudent provisions for security, data archiving and disaster recovery.
Program 2005/06 Objectives
.....................................................................................................................
1. On-going Security assessments to validate the efficacy of existing security measures and to evaluate and deploy solutions for new
threats.
2. Implement methods to reduce staff support time and costs including:
• Upgrade all systems to Windows XP operating system under a Open -License from Microsoft.
• Implement a managed, networked workstation re-imaging system to reduce staff downtime in worst case system failure from
several hours to an hour.
• Deploy Managed Spyware/Malware protection and recovery systems.
3. Improve data management at the department and staff level:
• Educate staff as to best practices for data storage on network drives.
• Deploy an improved email archiving system to remove dependency on local Outlook files for email storage.
4. Enhance Town Website and Portal:
• Implement 'in-line' polls to collect reader feedback and encourage citizen registration in an effort to engage citizenry to
participate in a "dialogue" with the Town via the website.
• Add information flows to the portal to improve efficiency of existing paper processes.
• Extend Portal to include registered citizen access.
• Prototype interactive Map technology.
5. ECommerce transactions for citizens
6. AMR integration to Town portal
Performance Measures
.....................................................................................................................
1.
Reduction in system compromises due to Virus/Spyware
25%
2.
Reduction in billed Desktop Support Services
25%
3.
Critical data migrated to network share
100%
4.
Reduction in email storage space requirements
10%
5.
Staff trained on archiving and data preservation efficiency
100%
6.
Website development
Number of on-line polls offered
2
Interactive map data available
June'06
Revenue producing transactions
June'06
New citizen access services
Mar'06
7.
Completion of portal enhancements
Dec '05
8.
Help -desk knowledge base and trouble ticket system
Feb'06
9.
IT generated revenue
$5,000
THE TOWN OF WESTLAKE * 2650 0TUNGER ROAD * WESTLAKE, TEAS 76262
Page 47 09/07/2010
f k
A �
a } AceTituv*V 0 We4t"eoo
Professional Services - FY 05/06 INFORMATION TECHNOLOGY
Activities
Program Provided in Partnership With
.....................................................................................................................
Kaleidoscope Information Services, Inc. provides IT direction, administration and support services to the Town of Westlake.
Program Customers
.....................................................................................................................
Westlake Departments Westlake Staff Westlake Citizens
THE TOWN OF WESTLAKE * 2650 0TUNGER ROAD * WESTLAKE, TEAS 76262
Page 48 09/07/2010
--Consultants to work with staff to define departmental IT needs, establish IT
priorities, evaluate products and services, prepare IT budget, research and
General Fund
deploy security measures and develop effective solutions internally and/or in
IT Administration
$35,OOC
100.43265.20
conjunction with outside vendors.
--Systems and Network administration including implementation of planned
infrastructure improvements, systems server maintenance, software upgrades,
data management and training.
Desktop Support Services
$10,000
General Fund
Desktop support costs only Including staff assistance, repair of compromised
100.43267.20
systems.
Software/Hardware
$11,000
General Fund
Annual hardware and software support contracts including Cisco networking and
Maintenance Contracts100.43266.20
phone systems, etc.
Website/Portal
$5,000
Visitor Fund
Site embellishments such as Interactive Maps and illustrations, additional
Enhancements (Visitors)
220.43415.1 1
photographic enhancements as requested and approved.
Website/Portal
General Fund
Interactive website "In-line Polling" setup, configuration and tuning: $2,500
Enhancements (IT)
$11,000
100.43415.20
e -Commerce transaction setup and Searchable properties index: $3,000
Citizen and Staff Portal development: $5,500
AMR Integration to Portal
$12,000
Utility Fund
500.16600.00
Integration of Water Meter data into citizen portal.
Departmental: Jim Taylor
$2,200
General Fund
100.43405.12
New Compute/Camera/Printer for Building Official - Department 12
Computer
$1,000
General Fund
New Computer for Executive Assistant - Department 11
Equipment/Software
100.43405.1 1
Computer
$3,000
General Fund
Enhanced security measures including Anti-SPAM/VIRUS/SPYWARE
Equipment/Software
100.43405.20
Computer
$5,000
General Fund
Windows XP and Office 2003 upgrades and desktop management solution
Equipment/Software
100.43405.20
Computer
$5,000
General Fund
Email archiving and retrieval measures
Equipment/Software
100.43405.20
Computer
$1,500
General Fund
GYM Wireless Access Points and installation
Equipment/Software
100.43405.20
Computer
$1,500
General Fund
Miscellaneous Hardware/Software budget for extension, maintenance, repair
Equipment/Software
100.43405.20
and upgrade of existing systems as approved by Town Manager
Program Provided in Partnership With
.....................................................................................................................
Kaleidoscope Information Services, Inc. provides IT direction, administration and support services to the Town of Westlake.
Program Customers
.....................................................................................................................
Westlake Departments Westlake Staff Westlake Citizens
THE TOWN OF WESTLAKE * 2650 0TUNGER ROAD * WESTLAKE, TEAS 76262
Page 48 09/07/2010
d 'S
a �
1 e, To 10 we4t"*
5. Y
Professional Services - FY 05/06 ENGINEERING
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. Residential development appears to be slowing with the completion of final platting in the Vaquero and Vaquero -Arthur
subdivisions.
2. Commercial development activity is increasing with some retail centers in the planning and design stages to be located
along SH 114 and SH 170.
3. Public improvements scheduled for next year are the Precinct Line Road water line and the beginning of construction on
FM 1938.
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 2005/06 Objectives
.....................................................................................................................
1. Conduct a study of the Town's internal development review process to confirm efficiency and cost-effectiveness.
2. Review the Town's development fee schedule compared to review time/costs to verify revenue production.
3. Perform an annual review of the water fund to confirm the operating margin.
4. Update the Town's water system computer model to determine the optimum system operational characteristics.
Performance Measures
.....................................................................................................................
1.
% total services covered by development fees
75%
2.
% revenue over expenditures included in water rate
10%
3.
FM 1938 water line completion within budget and schedule
100%
4.
FM 1938 begin construction
June '06
5.
% of new duct bank leased vs built
50%
6.
% reduction in Fort Worth water bills achieved
by reducing power usage and minimizing the peak demand.
10%
THE `OWN OF TI S. * 2650 OTTINEiER; ROAD * W T KE-, TEXAS 76262
Page 49 09/07/2010
d 'S
a �
1 e, To 10 we4t"*
5. Y
Professional Services - FY 05/06 ENGINEERING
Activities
NAME
AMOUNT
FUND
DESCRIPTION
Fort Worth/TRA Activities
$5,000
Utility Fund
Coordination/Meetings with City of Fort Worth & Trinity River
Authority
Update Water Distribution
$25,000
Utility Fund
The water model needs to be updated every few years. The
System Model
current model was prepared in 1999.
Vulnerability Assessment of the
$5,000
Utility Fund
This is not required until the Town reaches 3,300 population, but we
Water System
may want to consider it as a safety measure. Will identify measures
Mapping
$5,000
Utility Fund
Maintenance of Water & Sewer maps
Rate Analysis
$5,000
Utility Fund
Review performance of Utility Fund for previous year
Duct Bank Contracts
$5,000
Utility Fund
Coordination of leases
TRA/Southlake N1 Sewer
$20,000
Utility Fund Capital
Work necessary for TRA to accept maintenance of N-1 sewer line
Project
Infiltration/Inflow Study of the
Utility Fund Capital
A survey of the Glenwyck system has been performed in-house, but
Sewer System in Glenw ck and
y y
$75,000
Project
a formal study may be required by TRA as a stipulation of accepting
Vaquero.
the N-1 Line.
Sanitary Sewer Inflows &
Perm. Capital
Infiltration Repair
$2.000
Maintenance
Work associated with repairs identified by I&I Study
Project
FidelityWater Line
$4,400
Utility Fund Capital
Project
Preparation of construction plans and advertising for bids
Sewer/Water Installation for
$5,000
Utility Fund Capital
Work associated with the installation of sewer/water to building
Temporary Portable Building
Project
Development Activities
$45,000
General Fund
Review of construction plans, subdivision plans, etc.
Street Issues
$5,000
General Fund
Street, pavement, signage, etc. issues
Drainage Issues
$5,000
General Fund
Drainage problems
Mapping
$25,000
General Fund
Continue developing digital Town Maps for accessing from the
website. This funding will be used to produce parcel maps of the
TxDot Activities
$10,000
General Fund
Coordination of SH 114 and SH 170 issues
Boundary Issues
$15,000
General Fund
Roanoke and Trophy Club disputes and annexation issues
Development Review process
$10,000
General Fund
Review the process for efficiency and confirm revenue generation.
analysis and Fee evaluation
Miscellaneous Engineering Fees
$10,000
General Fund
Miscellaneous tasks
Program Provided in Partnership With
.....................................................................................................................
Graham Associates, Inc. Alan Plummer Associates, Inc. RJN, Inc.
Program Customers
.....................................................................................................................
Citizens of the Town Developers Consulting Engineers Surveyors
THE TOWN OF TLAKE * 2650 OTTINEiER; ROAD * W TLAKE—, TEXAS 76262
Page 50 09/07/2010
Section 4
Utility Fund
Page 51 09/07/2010
UTILITY FUND
Program Summary
Utility Fund
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
Beginning Balance
$ 410,388
$ 336,394
$ 336,394
$ 289,433
Balance Sheet Affect to Cash *
(297,046)
-
(44,894)
(9,329)
Revenue
1,203,905
1,600,256
1,669,553
2,146,770
Expenses (Net of depreciation/amortization)
980,853
1,182,463
1,348,647
1,508,762
Transfers In
126,584
-
-
-
Transfers Out
-
10,000
85,000
122,000
Net Operating Balance
462,978
744,187
527,406
796,112
Capital Project Expenses
126,584
262,500
237,973
559,390
Ending Balance
$ 336,394
$ 481,687
$ 289,433
$ 236,722
Utility Fund - Transfers In
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
4B Economic Development Fund
126,584
-
-
-
Total Transfers In
126,584
$ 10,000
-
$ 10,000
Utility Fund - Transfers Out
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
Transfer to Permanent Capital Maint. Fund
$ 126,584
$ -
$ -
$ -
General Maintenance
-
$ 10,000
-
$ 10,000
Sanitary Sewer Inflow & Infiltration Repairs
-
-
-
27,000
Transfer to GF - FW Impact Fee Revenue
-
-
85,000
85,000
Total Transfers Out
$ -
$ 10,000
$ 85,000
$ 122,000
Utility Fund - Capital Projects
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
Knox Road Connection
$ 126,584
$ -
$ -
$ -
Duct Bank
-
65,000
75,000
-
Keller Waterline
-
25,000
25,000
-
Water Meter Automation
-
25,000
25,000
37,000
SCADA System
-
20,000
20,000
-
TRA Assumption of N-1 Sewer
-
97,500
56,633
145,000
Water Meter Retrofit
-
30,000
-
-
Sewer/water Installation for Portable Bldg.
-
-
-
26,500
Fidelity Waterline Extension
-
-
36,340
350,890
Total Capital Projects
$ 126,584
$ 262,500
$ 237,973
$ 559,390
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 52 09/07/2010
UTILITY FUND
Interfund Repayment Schedule - Due to General Fund
3 01/15/07 97,420 3,840 23,750 -
4 01/15/08 69,830 3,840 23,750 -
F n111F/nQ A9 9dn 91 19n _ _
- - 27,590
69,830
- - 27,590
Extension of
- - 21,120
21,120
GW Farms
100.15205.00
100.48801.16
Water Mains
Peak Payment
377 Water Line
Sewer 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.040
23 750
-
-
-
27.590
97:420
3 01/15/07 97,420 3,840 23,750 -
4 01/15/08 69,830 3,840 23,750 -
F n111F/nQ A9 9dn 91 19n _ _
- - 27,590
69,830
- - 27,590
42,240
- - 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 53 09/07/2010
UTILITY FUND
Interfund Repayment Schedule - Due to the 413 Fund
3 08/15/07 386,501 7,975 13,777 7,979 29,731 356,770
4
08/15/08
356,770
Glenwyck Farms
Waterline
Knox Road
Connection 2003
Knox Road
Connection 2004
29,731
200.15205.00
500.23006.00
Pymt
#
Payment
Date
Beginning
Balance
$119,622
$293,842
$119,688 1
$533,152
1 Ending
Balance
Payment Due Payment Due Payment Due TOTAL
0
11/17/03
$ 533,152
-
87,189
-
$ 87,189
$ 445,962.4
1
2
08/15/05
08/15/06
445,962
416,232
7,975
7,975
13,777
13,777
7,979
7,979
29,731
29,731
416,232
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
6
08/15/09
08/15/10
327,039
297,308
7,975
7,975
13,777
13,777
7,979
7,979
29,731
29,731
297,308
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
12
08/15/15
08/15/16
148,654
118,923
7,975
7,975
13,777
13,777
7,979
7,979
29,731
29,731
118,923
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 54 09/07/2010
UTILITY FUND
Debt Payable Schedule - Keller Overhead Storage
Pymt
#
PymtTOTAL
Date
PAYABLE
I WESTLAKE'S PORTION OF PAYABLE 32%
Principal Interest Total
I Payable Principal 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,667
70,273
119,939
1,251,309
6
09/30/06
165,000
210,256
375,256
120,247
52,873
67,374
120,247
1,198,437
7
09/30/07
175,000
200,651
375,651
120,374
56,082
64,292
120,374
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 55 09/07/2010
-ioo,000
�z�o,oco
$150,000
$100,000
$50,000
$0
Utility Billing Statistical Information - FY 2005
0 Accounts Receivable Aging by Month
Oct -04 Nov -04 Dec -04 Jan -05 Feb -05 Mar -05 Apr -05 May -05 Jun -05 Jul -05 Aug -05
❑ Current ❑ 30 Days ❑ 60 Days ❑ 90 Day
Page 56 09/07/2010
Section 5
Visitor's
Association
Fund
Page 57 09/07/2010
VISITOR'S ASSOCIATION FUND
Program Summary
Visitors Fund
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
Beginning Balance
$ 571,058
$ 843,082
$ 843,082
$ 825,076
Balance Sheet Affect to Cash *
38,706
(7,557)
(7,557)
-
Revenues
447,512
427,328
440,100
453,000
Expenditures
214,194
437,818
450,549
450,257
Ending Balance
$ 843,082
$ 825,035
$ 825,076
$ 827,819
Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in
current year revenue and expenditures, i.e. payables and receivable posted to the current year's books but cash
is not paid nor received until the subsequent year.
Page 58 09/07/2010
d 'S
a �
1 e, To 10 we4t"*
5. Y
Goals & Objectives - FY 05/06 VISITOR ASSOCIATION
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
.....................................................................................................................
1. Continue to improve hotel occupancy and visibility of businesses
2. Market and promote the Town
3. Develop a program that will integrate community values with school philosophy in order to facilitate international exposure
relationships, cultural exchange
4. Identify additional funding
5. Expand and promote organizations/events
Program 2004/05 Objectives - Completed
.....................................................................................................................
1. Increase occupancy at the Marriott from 57% to 62%
2. Redesign the Town of Westlake website to be more visitor friendly
3. Become familiar with Sister Cities program and determine its applicability to Westlake and Westlake Academy
4. Work with Parks and Facilities to host one new event at the Westlake Academy
5. Work with businesses regarding marketing/promotion requests
Program 2005/06 Objectives
.......................
Objectives carried forward
1. Participate in one trade show and one FAM tour with Marriott
2. Develop a Westlake brochure to include in trade show and event marketing
3. Work with businesses regarding marketing/promotion requests
4. Establish a marketing plan for the Town of Westlake that integrates media, local community leaders, appointed and elected
officials to systematically begin marketing Westlake
Objectives planned for current year
1. Continue to increase occupancy at the Marriott from 62% to 68%
2. Participate in trade show or FAM tour with Marriott Solana
3. Work with businesses regarding marketing/promotion requests
4. Establish and implement a visitors' association board of 5-7 people
5. Develop a Westlake brochure and display board to include in trade show and event marketing
6. Continue to maintain the visitors' information on the Town of Westlake website
7. Implement a Sister Schools program with 1 school
8. Identify at least two grants and apply for additional funding for programs
9. Identify sponsors for events/activities/growth
10. Work with Parks and Facilities and community to host a 50 year celebration
11. Work with Historical Board to continue production of The Pathfinder and host Decoration Day
12. Work with Tree City USA Board to host Arbor Day in October
13. Expand the Masterworks series in the spring to include the fall in a continued partnership with Maguire Partners
14. Work with Metroport Cities Partnership to celebrate the opening of the expansion of Highway 114
THE TOWN OF WESTLAKE *2650 OTTING ER ROAD * WESTLAKE, TEXAS 76262
Page 59 09/07/2010
d 'S
a �
1 e, To 10 we4t"*
5. Y
Goals & Objectives - FY 05/06 VISITOR ASSOCIATION
Performance Measures
1. Hotel occupancy increased 68%
2. Participate in FAM tour with Marriott
3. Establish Visitors Association Board
4. Brochure and display boards created
5. Participate in regional tourism brochure/trade show
6. Visit from students at IB School in Mexico
7. Apply for Recreation/Parks Grant
8. Apply for Historical Preservation Grant
9. Number of sponsors for Historical Board
10. Number of sponsors for Arbor Days
11. 50 year Big Event
12. Production of The Pathfinder
13. Production of history book
14. $ made on Arbor Days
15. Number of Masterworks performances
16. Number of people at Hwy 114 expansion ceremony
Program Provided in Partnership With
June,2006
June,2006
March, 2006
February, 2006
June,2006
November, 2005
November, 2005
April, 2006
3
3
5 sponsors, 1000 people
500 copies
500 copies
$6000
6 - (3) spring and (3) fall
300
.....................................................................................................................
Marriott Solana
Fidelity Investments
Maguire Partners
Westlake Academy Foundation
Metroport Cities
Historical Preservation Board
ARTS NET
Westlake Academy
Tree City USA Board
Hillwood
Local Businesses
NorthEast Leadership Forum
TACVB - Texas Association of Convention & Visitors Bureau
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
THE `OWN OFWESTLAKE *2650 OTTING ER ROAD * WESTLAKE, 'TEXAS 76262
Page 60 09/07/2010
1,000,000
900,000
800,000
700,000
600,000
500,000
400,000
300,000
200,000
100,000
0
Visitor Association
Revenue & Expenditure Analysis
N
W
O
O
r
O
m
FY 00/01 actual FY 01/02 actual FY 02/03 actual FY 03/04 actual FY 04/05
FY 05/06
amended
adopted
budget
budget
00
O
47
00
r-
00
00
N LO
M O
O
n
O
I-
O
N
O
lC'1
O
O 17Y
O N
M O
cc(no
d a
OO Lf)
°°
C
V
V
v
N
CO
00
N
M
O
a
N
N
�
O
N
�
O
FY 00/01 actual FY 01/02 actual FY 02/03 actual FY 03/04 actual FY 04/05
FY 05/06
amended
adopted
budget
budget
❑ Revenues
❑ Expenditures
❑ Ending Cash
Page 61 09/07/2010
Section 6
Special
Revenue Grant
Fund
Page 62 09/07/2010
SPECIAL REVENUE GRANT FUND
Program Summary
Grant Fund
Adopted
FY 05/06
Beginning Balance
$ -
Balance Sheet Affect to Cash *
-
Revenues
403,209
Expenditures
448,010
Transfer In
44,801
Ending Balance
$ -
Grant Fund - Transfers In
Adopted
FY 05/06
Transfer in
Fund
$ 44,801
[General
Ending Balance
$ 44,801
This FEMA grant will allow the purchase of a compressed air foam system (CAFS) to be used on brush and vehicle fires;
funding to join the NETCO (Bedford) Radio consortium; purchase of technical rescue equipment; purchase of decon and
containment equipment to be used for hazardous materials spills; and purchase of automatic external defibrillators (AEDs).
Balance sheet affect to cash represents balances between the fiscal years that affect cash and are reflected in
current year revenue and expenditures, i.e. payables and receivable posted to the current year's books but cash
is not paid nor received until the subsequent year.
Page 63 09/07/2010
Section 7
4A Fund
Page 64 09/07/2010
4A ECONOMIC DEVELOPMENT FUND
Program Summary
4A Corporation
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
Beginning Balance
$ 860,405
$ 902,312
$ 902,312
$ 1,240,595
Balance Sheet Affect to Cash
82,350
23,088
23,088
-
Revenues
446,105
653,200
524,500
677,000
Expenditures
486,548
35,760
37,258
37,258
Transfers Out
945,687
1 172,047
1 1,880,337
Ending Balance
1 $ 902,312
1 $ 597,153
1 $ 1,240,595
1 $ (0)
4A Corporation
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
General Fund
Dissolution of 4A
$ -
$ -
$ -
$ 1,880,337
Capital Projects
FM 1938 Engineering - WL Portion
56,667
32,047
-
SH 114 Commerical Growth
889,020
140,000
-
Total Transfers Out
$ -
$ 945,687
$ 172,047
$ 1,880,337
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 65 09/07/2010
4A Economic Development Fund
Fidelity Tax Reimbursement Schedule
Pymt
#
Payment
Due Date
Beginning
Balance
Payment
Due
Ending
Balance
1
** 2
3
11/01/02
11/01/03
11/01/04
536,374
429,099
429,099
107,275
-
35,758
429,099
429,099
393,341
4
11/01/05
393,341
35,758
357,582
5
11/01/06
357,582
35,758
321,824
6
11/01/07
321,824
35,758
286,066
7
11/01/08
286,066
35,758
250,308
8
11/01/09
250,308
35,758
214,549
9
11/01/10
214,549
35,758
178,791
10
11/01/11
178,791
35,758
143,033
11
11/01/12
143,033
35,758
107,275
12
11/01/13
107,275
35,758
71,516
13
11/01/14
71,516
35,758
35,758
14
11/01/15
35,758
35,758
0
$
536,373.60
* * FY 02/03 Payment included FY 01/02, FY 02/03, and FY 03/04
Page 66 09/07/2010
Section 8
4B Fund
Page 67 09/07/2010
413 ECONOMIC DEVELOPMENT FUND
Program Summary
413 Economic Development Fund
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
Beginning Balance
$ 607,313
$ 505,456
$ 505,456
$ 204,969
Balance Sheet Affect to Cash*
573,183
-
(23,708)
-
Revenues
438,763
688,043
539,831
692,231
Expenditures
63,109
-
1,060
-
Transfers In
-
-
213,314
-
Transfers Out
1,050,695
1,027,804
1,028,864
897,200
Ending Balance
$ 505,456
$ 165,695
$ 204,969
$ 0
4B Economic Dev. Fund - Transfers In
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
Civic Campus
$ -
$ -
$ 213,314
$ -
General Fund
-
Total Transfers In
$ -
$ -
$ 213,314
$ -
413 Economic Dev. Fund - Transfers Out
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
Debt Service for Civic Campus
$ 1,050,695
$ 1,027,804
$ 1,028,864
$ 897,200
Total Transfers Out
1 $ 1,050,695
1 $ 1,027,804
1 $ 1,028,864
1 $ 897,200
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 68 09/07/2010
413 Economic Development Fund
Interfund Repayment Schedule - Due from Utility Fund
Glenwyck FarmsI Knox Road I Knox Road I I 200.15205.00
Waterline Connection 2003 Connection 2004 500.23006.00
Pymt
#
Payment
I Date
Beginning
I Balance
1 $119,622$293,842
87,189
1 $119,688 1
$533,152
d
Ending
Balance
I Payment Due I Payment Due I Payment Due I TOTAL
0
11/17/03 $
533,152
-
87,189
- $
87,189 $
445,962
1
08/15/05
445,962
7,975
13,777
7,979
29,731
416,232
2
08/15/06
416,232
7,975
13,777
7,979
29,731
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 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 69 09/07/2010
Section 9
Crime Control
District Fund
Page 70 09/07/2010
CRIME CONTROL DISTRICT
Program Summary
Crime Control District
Adopted
FY 05/06
Beginning Balance
$0
Balance Sheet Affect to Cash
$0
Revenues
$0
Expenditures
$0
Transfers Out
$0
Ending Balance
$ -
Crime Control District - Transfers Out
Adopted
FY 05/06
Transfers In
$0
General Fund
$0
$0
Total Transfers Out
$ -
After the approval of a Crime Control District, funds alloted to that District are not collected until the
end of a complete quarter after the election. Therefore, if we held an election in May, our
collections for CCD would begin October 1 st with these funds being sent to the Town in December, 2006.
The sales tax collections we are currently receiving on utilities (gas and electric) is for commercial use only.
This is a valid source for the Crime Control District as well. We have never collected local taxes on
residential utilities; therefore, our CCD sales tax collections will not differ from our 4A collections.
Page 71 09/07/2010
Section 10
Debt Service
Fund
Page 72 09/07/2010
DEBT SERVICE FUND
Program Summary
Debt Service
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
Beginning Balance
$ -
$ -
$ -
$ -
Balance Sheet Affect to Cash
-
-
-
$ 897,200
Transfers In
-
1,027,804
1,028,864
11378,864
Expenditures
-
1,027,804
1,028,864
1,378,864
Ending Balance
$ -
$ -
$ -
$ -
Debt Service - Transfers In
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
4B Economic Development Fund
$ -
$ 1,027,804
$ 1,028,864
$ 897,200
General Fund
To cover 4B shortfall for Series 2002 and 2003
-
-
-
481,664
Total Transfers In
$ -
1,027,804
1 1,028,864
1 1,378,864
Page 73 09/07/2010
DEBT SERVICE FUND
Certificates of Obligation (1st Series)
2002 Series
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
2002 SERIES BOND AMORTIZATION SCHEDULE
Pymt # Due Date Principal Interest Total
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 74 09/07/2010
DEBT SERVICE FUND
Certificates of Obligation (2nd Series)
2003 Series
Sources & Uses
Sources
Par Value 6,410,000
Accrued Interest 17,460
Total Sources of Funds $ 6,427,460
Uses
Deposit to Debt Service Fund 17,460
Deposit to Construction Fund 5,900,000
Original Issue Discount 58,388
Cost of Issuance 322,000
Rounding 1,410
Underwriter's Discount 128,203
Total Sources of Funds $ 6,427,460
2003 SERIES BOND AMORTIZATION SCHEDULE
Pymt # Due Date Principal Interest Total
1
2
3
09/30/05
09/30/06
09/30/07
$ - $
$ 140,000 $
145,000
285,724 $
285,724 $
282,924
285,724
425,724
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
09/24/30
365,000
57,750
422,750
27
09/24/31
385,000
39,500
424,500
28
09/23/32
405,000
20,250
425,250
$ 6,410,000 $
5,361,764 $
11,771,764
Page 75 09/07/2010
Section 11
Capital Projects
Fund
Page 76
09/07/2010
CAPITAL PROJECTS FUND - GOVERNMENTAL
Program Summary
Capital Projects Fund
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
Beginning Balance
$ 4,460,826
$ -
$ -
$ -
Balance Sheet Affect to Cash *
(1,925,545)
$ 150,000
213,297
-
Revenue
13,211
-
287,806
222,237
Expenditures
(3,599,188)
1,339,020
589,361
1,939,962
Transfers In
1,050,695
1,339,020
301,555
1,717,725
Transfers Out
-
-
213,297
-
Ending Balance
$ 7,198,375
$ -
$ -
$ -
Capital Projects Transfers In
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
Other Sources
$ -
$ -
$ 213,297
$
FM 1938 - Tarrant County
$ -
$ 150,000
$
$ -
FM 1938 - Southalke
-
56,667
$ 213,297
$ -
FM 1938 - Keller
-
56,667
-
Westlake Academy Foundation (Art/Science Building)
-
-
1,300,000
General Fund
Cemetery Maintenance
-
10,000
-
Portable Buildings
-
-
57,400
Temporary Parking
-
-
10,000
93,800
FM 1938 (Remaining of Roland Arthur's funds from PY)
-
-
34,508
-
Civic Campus Expansion
-
25,000
85,000
266,525
Dove Road
-
95,000
-
-
4A Economic Development Fund
114 Commerical Growth
-
889,020
140,000
FM 1938 - Westlake
-
56,667
32,047
4B Economic Development Fund
1,050,695
-
-
-
Total Transfers In
$ 1,050,695
$ 1,339,020
$ 301,555
$ 1,717,725
Capital Projects Transfers Out
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
4B Economic Development Fund
$ -
$ -
$ 213,297
$
Total Transfers Out
$ -
$ -
$ 213,297
$ -
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 09/07/2010
Section 12
Permanent
Capital Maint
Fund
Page 78 09/07/2010
PERMANENT CAPITAL MAINTENANCE FUND
Program Summary
Permanent Capital Maintenance Fund
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
Beginning Balance
$ -
$ -
$ -
$ -
Revenue
-
-
-
-
Transfers In
-
20,000
-
113,000
Expenditures
-
20,000
-
93,000
Ending Balance
$ -
$ -
$ -
$ 20,000
PC Maintenance Fund - Transfers In
Actual
FY 03/04
Adopted
FY 04/05
Amended
FY 04/05
Adopted
FY 05/06
Utility Fund
10,000
10,000
Sanitary Sewer Inflow & Infiltration Repairs
-
27,000
General Fund
-
-
-
General Maintenance
1 10,000
10,000
Dove Road Improvements
I -
1 -1
66,000
Total Transfers In
1 $ 20,000
1 $ - 1$
113,000
Page 79 09/07/2010
Section 13
Capital Project
Detail
Page 80 09/07/2010
Capital Projects & Permanent Capital Maintenance Projects
Summary FY 05/06
Project Title
Type Funding
Utility Fund
Amount
Temporary Parking
Portable Buildings
Civic Campus Expansion
Dove Road Improvements
Capital Project General Fund
Capital Project General Fund
Capital Project General Fund
Capital Maintenance General Fund
Utility Fund
93,800
57,400
266,525
66,000
Sewer & Water Installation for Portable Buildings
Total General Fund
$
483,725
Art/Science Building
Capital Project WA Foundation
Contributions
1,300,000
Sanitary Sewer Inflow & Infiltration Repairs
Total WA Foundation
$
1,300,000
FM 1938 - Southlake portion
FM 1938 - Tarrant County
Capital Project Contributions
Capital Project Contributions
586,390
72,237
150,000
Total Contributions
$
222,237
Water Meter Automation
Capital Project
Utility Fund
37,000
TRA/Southlake N1 Sewer Line Improvement
Capital Project
Utility Fund
145,000
Sewer & Water Installation for Portable Buildings
Capital Project
Utility Fund
26,500
Fidelity Waterline Extension
Capital Project
Contributions
350,890
Sanitary Sewer Inflow & Infiltration Repairs
Capital Maintenance Utility Fund
27,000
Total Utility Fund $
586,390
Total Capital Projects/Capital Maintenance Projects $ 2,592,352
Page 81 09/07/2010
CAPITAL PROJECT
FY 2005/2006
Temporary Parking
Project Description:
A two inch asphalt base temporary parking lot with 25 parking spaces at the Town portable building site. Also, a two inch asphalt base
temporary parking lot with 86 parking spaces for the Academy with a pickup area located on the west side of Pod G for 7th and 8th graders.
The parking lots are to be completed in November, 2005. Project includes the widening of Ottinger to provide a right and left hand turn
into the temporary parking.
NET 0 1 0 1 0 1 0 1 0 1 0 0
IMPACT ON OPERATING BUDGET
PROJECT EXPENSE
0
LTD
09/30/05
BUDGET
05106
LTD
BUDGET I
Planned
07/08
08/09
PROJECT
05/06 06/07
07/08 08/09
0
10,000
09/10
0 0
09/30/05
TOTAL
Construction
0
86,300 0
0
0
0
86,300
Signage
0
2,500 0
0
0
0
2,500
Engineering
10,000
5,000 0
0
0
0
15,000
Legal
0
0 0
0
0
0
0
Labor cost
0
0 0
0
0
0
0
PROJECT EXPENSE TOTAL
10,000
93,800 0
0 1
0
0
103,800
NET 0 1 0 1 0 1 0 1 0 1 0 0
IMPACT ON OPERATING BUDGET
PROJECT FUNDING
0
LTD
09/30/05
BUDGET
05106
LTD
09/30/05
BUDGET
05/06
06/07
07/08
08/09
09/10
PROJECT
TOTAL
Prior Year Remaining Fund
General Fund
0
10,000
0
0 0
0
0
0
93,800
0
0 0
0 0
0
0
0
0
103,800
0
Utility Fund 0
Visitor Fund
0
0
0 0
0
0
0
4A Loan
0
0
0 0
0
0
0
4B Loan
0
0
0 0
0
0
0
Grants
0
0
0 0
0
0
0
Private
0
0
0 0
0
0
0
Certificates of Obligation
0
0
0 0
0
0
0
PROJECT FUNDING TOTAL
10,000
93,800
0 0
0
0
103,800
NET 0 1 0 1 0 1 0 1 0 1 0 0
Page 82 09/07/2010
IMPACT ON OPERATING BUDGET
LTD
09/30/05
BUDGET
05106
Planned
PROJECT
06/07 07/08 08/09 09/10
TOTAL
Administrative Expenses
0 0 0 0
0
0
0
Personnel Expenses
0 0 0 0
0
0
0
Supplies
0 0 0 0
0
0
0
Maintenance
0 0 0 0
0
0
0
Services
0 0 0 0
0
0
0
Equipment
0 0 0 0
0
0
0
Transfer
0 0 0 0
0
0
0
Debt
0 0 0 0
0
0
0
OPERATING IMPACT TOTAL
0 0 0 0
0
0
0
Page 82 09/07/2010
CAPITAL PROJECT
FY 2005/2006
Portable Buildings
Project Description:
One 36'X 64' temporary office building for Court, Jim Taylor, Texas Student Housing and files and two (23'X 64') which will provide two
classrooms, work room and restrooms. Includes delivery to jobsite setup, anchors decks, ramps skirting. Town monthly lease of $1,965
(48 mo. lease -total $92,355) beginning January, 2006. Installation of phone and data line from Pod G (Gym) to temporary buildings.
NET 1 0 1 0 1 0 1 0 1 0 1 0 0
IMPACT ON OPERATING
PROJECT EXPENSE
LTD
09/30/05
LTD
09/30/05
BUDGET
05/06
I
Planned
TOTAL
PROJECT
TOTAL
06/07 07/08 08/09 09/10
Construction
0
41,400
0
0
0
0
41,400
Construction (Data lines)
0
11,000
0
0
0
0
11,000
Engineering
0
4,000
0
0
0
0
4,000
Engineering (Data lines)
0
1,000
0
0
0
0
1,000
Contingencies
0
0
0
0
0
0
0
PROJECT EXPENSE TOTAL
0
57,400
0
0
0
0
57,400
NET 1 0 1 0 1 0 1 0 1 0 1 0 0
IMPACT ON OPERATING
PROJECT FUNDING
LTD
09/30/05
LTD
09/30/05
BUDGET
05/06
I
Planned
TOTAL
PROJECT
TOTAL
06/07 07/08 08/09 09/10
Prior Year Remaining Fund
General Fund
Utility Fund
0
0
0
0 0
57,400 0
0 0
0
0
0
0
0
0
0
0
0
57,400
0
Visitor Fund
0
0 0
0
0
0
0
4A Loan
0
0 0
0
0
0
0
4B Loan
0
0 0
0
0
0
0
Grants
0
0 0
0
0
0
0
Private
0
0 0
0
0
0
0
Certificates of Obligation
0
0 1 0
0
0
0
0
PROJECT FUNDING TOTAL
0
57,400 1 0
0
0 1
0
57,400
NET 1 0 1 0 1 0 1 0 1 0 1 0 0
Page 83 09/07/2010
IMPACT ON OPERATING
BUDGET
LTD
09/30/05
BUDGET
05/06
Planned
IPROJECT
TOTAL
06/07 07/08 08/09 09/10
Administrative Expenses
0
0
0
0
0
0
0
Personnel Expenses
0
0
0
0
0
0
0
Supplies
0
0
0
0
0
0
0
Maintenance
0
0
0
0
0
0
0
Rental (48 month lease X $1965)
0
17,685
23,580
23,580
23,580
5,895
94,320
Equipment
0
0
0
0
0
0
0
Transfer
0
0
0
0
0
0
0
Debt
0
0
0
0
0
0
0
OPERATING IMPACT TOTAL
0
17,685
1 23,580
23,580
23,580
5,895
94,320
Page 83 09/07/2010
CAPITAL PROJECT
FY 2005/2006
Civic Campus Expansion
Project Description:
Remodel the court and office in Pod E into three class rooms.
NET 1 0 1 0 1 0 1 0 1 0 1 0 0
IMPACT ON OPERATING
BUDGET
PROJECT EXPENSE
LTD
09/30/05
BUDGET
05/06
Planned
PROJECT
TOTAL
06/07 07/08 08/09 09/10
LTD
09/30/05
BUDGET
05/06
I
Planned
Personnel Expenses
0 0
PROJECT
TOTAL
06/07 07/08 08/09 09/10
Construction
85,000
266,525
0
0
0
0
351,525
Implementation
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Engineering
Legal
Contingencies
0
0
0
0
0
0
0
0 1 0
0 0 0 0
0
PROJECT EXPENSE TOTAL
85,000
1 266,525
0
0
0
0
351,525
NET 1 0 1 0 1 0 1 0 1 0 1 0 0
IMPACT ON OPERATING
BUDGET
PROJECT FUNDING
LTD
09/30/05
BUDGET
05/06
Planned
PROJECT
TOTAL
06/07 07/08 08/09 09/10
LTD
09/30/05
BUDGET
05/06
0 0 0 0
Planned
Personnel Expenses
0 0
PROJECT
06/07 07/08 08/09 09/10
TOTAL
Prior Year Remaining Fund
0
0
0
0
0
0
Services
General Fund
85,000
266,525
0
0
0
0
351,525
Utility Fund
0
0
0
0
0
0
0
Visitor Fund
0
0
0
0
0
0
0
4A Loan
0
0
0
0
0
0
0
4B Loan
0
0
0
0
0
0
0
Grants
0
0
0
0
0
0
0
Private
0
0
0
0
0
0
0
Certificates of Obligation
0
0
0
0
0
0
0
PROJECT FUNDING TOTAL
85,000
266,525
0
0
0
0
351,525
NET 1 0 1 0 1 0 1 0 1 0 1 0 0
IMPACT ON OPERATING
BUDGET
LTD
09/30/05
BUDGET
05/06
Planned
PROJECT
TOTAL
06/07 07/08 08/09 09/10
Administrative Expenses
0 0
0 0 0 0
0
Personnel Expenses
0 0
0 0 0 0
0
Supplies
0 0
0 0 0 0
0
Maintenance
0 0
0 0 0 0
0
Services
0 0
0 0 0 0
0
Equipment
0 0
0 0 0 0
0
Transfer
Debt
0 0
0 0 0 0
0
0 0
0 0 0 0
0
OPERATING IMPACT TOTAL
0 0
0 1 0 1 0 0
0
Page 84 09/07/2010
PERMANENT CAPITAL MAINTENANCE PROJECT
FY 2005/2006
Dove Road Improvements
Project Description:
Overlay Dove Road with 2" of asphalt and improve drainage conditions along ROW.
NET 0 1 0 1 0 1 0 1 0 1 0 0
IMPACT ON OPERATING BUDGET
PROJECT EXPENSE
-F
LTD
09/30/05
BUDGET Planned
05/06 06/07 07/08 08/09
LTD
09/30/05
BUDGET
05/06
PROJECT
TOTAL
Planned
0
0 0 0
0 0 0
PROJECT
TOTAL
06/07 07/08 08/09 09/10
Purchase
Design
Construction
Implementation
Engineering
Legal
Contingencies
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
65,000
0
1,000
0
0
0
65,000
0
1,000
0
0
PROJECT EXPENSE TOTAL
01
66,000 1 0
01
0 1
0
166,000
NET 0 1 0 1 0 1 0 1 0 1 0 0
IMPACT ON OPERATING BUDGET
PROJECT FUNDING
-F
LTD
09/30/05
BUDGET Planned
05/06 06/07 07/08 08/09
LTD
09/30/05
BUDGET
05/06
PROJECT
TOTAL
Planned
0
0 0 0
0 0 0
PROJECT
TOTAL
06/07 1 07/08 08/09 09/10
Prior Year Remaining Fund
General Fund
Utility Fund
Visitor Fund
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
66,000
0
0
66,000
0
0
PROJECT FUNDING TOTAL
0
66,000 0
0
0
0
66,000
NET 0 1 0 1 0 1 0 1 0 1 0 0
Page 85 09/07/2010
IMPACT ON OPERATING BUDGET
-F
LTD
09/30/05
BUDGET Planned
05/06 06/07 07/08 08/09
09/10
PROJECT
TOTAL
Administrative Expenses
0
0 0 0
0 0 0
0
0
0
0
0
0
Personnel Expenses 0
Supplies
0
0 0 0
0
0
0
Maintenance
0
0 0 0
0
0
0
Services
0
0 0 0
0
0
0
Equipment
Transfer
Debt
0
0
0
0 0 0
0
0
0
0 0 0 0 0
0
0 0 0 0 0
0
OPERATING IMPACT TOTAL
0
01 0 1 01
0 1
0 10
Page 85 09/07/2010
CAPITAL PROJECT
FY 2005/2006
Art/Science Building
Building an Art/Science Building with three laboratories, one or two art rooms, black box theater, outside theater, 4-6 offices, workroom, conference room,
storage, and entry hallway
N E T 0 1 123,182 1 0 1 0 1 0 1 0 0
IMPACT ON OPERATING
PROJECT EXPENSE
IF
LTD
09/30/05
LTD
09/30/05
BUDGET
05/06
Planned
Planned
PROJECT
PROJECT
TOTAL
06/07 1 07/08 1 08/09 1 09/10
Purchase
Design
0
0
0
134,409
0
0
2,700,000
100,000
0
0
0
0
0
0
0
0
0
0
0
0
0
134,409
3,500,000
200,000
Construction $250/sq.ft.x 13,276 0 800,000
Implementation 0 100,000
Engineering
0
134,409
0
0
0
0
134,409
Legal
Contingencies
0
0
8,000
0
8,000
0
0
0
16,000
0 0 0 0
0
PROJECT EXPENSE TOTAL
0
1,176,818
2,808,000
0
0
0
3,984,818
N E T 0 1 123,182 1 0 1 0 1 0 1 0 0
IMPACT ON OPERATING
PROJECT FUNDING
IF
LTD
09/30/05
LTD
09130/057
BUDGET
05/06
Planned
Planned
PROJECT
PROJECT
06/07 07/08 08/09 09/10
TOTAL
Prior Year Remaining Fund
General Fund
0
0
0
123,182
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Utility Fund 0
0
Visitor Fund
0
0
0
0
0
0
0
Westlake Academy Foundation
0
1,300,000
2,684,818
0
0
0
3,984,818
4A Loan
0
0
0
0
0
0
0
4B Loan
0
0
0
0
0
0
0
Grants
Private
Certificates of Obligation
0
0
0
0
0
0
0
0
0
0
0 0 0 0
0
0
0 0 0 0
0
PROJECT FUNDING TOTAL
0
1,300,000
2,808,000
0
0
0
3,984,818
N E T 0 1 123,182 1 0 1 0 1 0 1 0 0
Page 86 09/07/2010
IMPACT ON OPERATING
BUDGET
LTD
09/30/05
BUDGET
05/06
Planned
PROJECT
06/07 07108 08/09 09/10
TOTAL
Administrative Expenses
0
0
0
0
0
0
0
Personnel Expenses
0
0
0
0
0
0
0
Supplies
0
0
0
10,000
10,000
10,000
30,000
Maintenance
0
0
0
30,000
30,000
35,000
95,000
Services
0
0
0
10,000
10,000
15,000
35,000
Equipment
0
0
0
5,000
8,000
8,000
21,000
Transfer
Debt
0
0
0
0
0
0
0
0
0
0 0 0 0
0
OPERATING IMPACT TOTAL
0
0
0
55,000 1
58,000
68,000
181,000
Page 86 09/07/2010
CAPITAL PROJECT
FY 2005/2006
FM1938 (114 to 1709)
Project Description:
The engineering, design and construction document package with TXDOT review and approval for FM1938 between SH114 in Westlake and
FM1709 in Southlake/Keller. Implementation costs for Texas U -Turns at SH114/FM1938 interchange are also included. Westlake portion of
costs relative to Southlake and Keller is 57.11 % for FM1938
PROJECT EXPENSE
PROJECT FUNDING
PROJECT
BUDGET
LTD
09/30/05
BUDGET
05/06
Planned
PROJECT
TOTAL
06/07 07/08
Design
Construction
1,394,533 1,172,296
222,237
0 0
1,394,533
0
0
0 0
0
PROJECT EXPENSE TOTAL
1,394,533 1,172,296
222,237
0 0
1,394,533
NET 0 1 0 1 0 1 0 1 0 1 0
IMPACT ON OPERATING BUDGET
PROJECT FUNDING
PROJECT
BUDGET
LTD BUDGET Planned PROJECT
09/30/05 05/06 06/07 07/08 TOTAL
Administrative Expenses 1 0 0 0 0 0
OPERATING IMPACT TOTAL 0 0 0 0 0
7Yearmaining
PROJECT
BUDGET
LTD
09/30/05
BUDGET
05/06
Planned
PROJECT
TOTAL
06/07 07/08
Fund
81,603
36,857
0
82,174
36,857
0
0
0
0
0
0
0
0
0
82,174
36,857
4A grant 03/04
4A grant 03/04
4A grant 04/05
32,046
31,476
0
0
0
31,476
Tx Dot Inspection (Westlake Portion)
3,333
3,333
0
0
0
3,333
Private - Fidelity 00/01
228,700
228,700
0
0
0
228,700
Private - General Growth 00/01
47,022
47,022
0
0
0
47,022
Private - Keller 00/01
49,513
49,513
0
0
0
49,513
Private - Keller 02/03
3,333
3,333
0
0
0
3,333
Private - Keller 03/04
36,857
36,857
0
0
0
36,857
Private - Keller 04/05
32,046
32,046
0
0
0
32,046
Private - Oakmont 00/01
174,676
174,676
0
0
0
174,676
Private - Rowland Arthur 03/04
101,739
101,739
0
0
0
101,739
Private - Sabre 00/01
44,030
44,030
0
0
0
44,030
Private - Southlake 00/01
113,434
113,434
0
0
0
113,434
Private - Southlake 03/04 (anticipated)
36,857
0
36,857
0
0
36,857
Private - Southlake 04/05 (anticipated)
32,047
0
32,047
0
0
32,047
Private - Southlake 02/03 (anticipated)
3,333
3,333
3,333
Private - Tarrant County 04/05 (anticipated)
150,000
0
150,000
0
0
150,000
Private - WB Texas 00/01
187,106
187,106
0
0
0
187,106
PROJECT FUNDING TOTAL
1,394,533
1,172,296
222,237
0
0
1,394,533
NET 0 1 0 1 0 1 0 1 0 1 0
IMPACT ON OPERATING BUDGET
PROJECT
BUDGET
LTD BUDGET Planned PROJECT
09/30/05 05/06 06/07 07/08 TOTAL
Administrative Expenses 1 0 0 0 0 0
OPERATING IMPACT TOTAL 0 0 0 0 0
Page 87 09/07/2010
CAPITAL PROJECT
FY 2005/2006
Water Meter Automation
Project Description:
Phase two for the water meter automation that 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 to be completed by January,
2006.
NET 1 0 1 0 1 0 1 0 1 0 1 0 1 0 0
IM AL
IMPACT ON
PROJECT EXPENSE
PROJECT
I LTD
BUDGET
06/07
Planned
09/10 1
PROJECT
Prior Year Remaining Fund
BUDGET
09/30/05
05/06
06/07
07/08 08/09
09/10
TOTAL
Purchase
0 0 0 0 0
0
Utility Fund
0
0
0 0
0
Design
0 0
0
0
0
0
0 0
0
Construction
0 0
0
0
0
0
0 0
0
Implementation
170,000
25,000
25,000
60,000
60,000
0 0
170,000
Engineering (IT support)
12000
0
12,000
0
0
0 0
12,000
Legal
0 0
0
0
0
0
0 0
0
Contingencies
0 0
0
0
0
0
0 0
0
PROJECT EXPENSE TOTAL
182,000
25,000
37,000
60,000
60,000
0 0
182,000
NET 1 0 1 0 1 0 1 0 1 0 1 0 1 0 0
IM AL
IMPACT ON
PROJECT FUNDING
PROJECT
BUDGET
LTD
09/30/05
BUDGET
05/06
06/07
Planned
07/08 08/09
09/10 1
PROJECT
TOTAL
Prior Year Remaining Fund
0
0
0
0
0
0
0
0
0 0
0 0 0 0 0
General Fund
0 0 0 0 0
0
Utility Fund
182,000
25,000
37,000
60,000
60,000
0 0
182,000
Visitor Fund
0 0
0
0
0
0
0 0
0
4A Loan
Transfer
Debt
0
0
0
0
0 0
0
4B Loan
0
0
0
0
0
0 0
0
Grants
0
0
0
0
0 0
0
Private
0
0
0
0
0 0
0
Certificates of Obligation
0
0
0
0
0 0
0
PROJECT FUNDING TOTAL
1 182,000
1 25,000
1 37,0007
60,000 1
60,000 1
01 0
182,000
NET 1 0 1 0 1 0 1 0 1 0 1 0 1 0 0
IM AL
IMPACT ON
OPERATING BUDGET
PROJECT
BUDGET
LTD
09/30/05
BUDGET
05/06
06/07 07/08
Planned
08/09
09/10
PROJECT
TOTAL
Administrative Expenses
0
0
0
0 0
0
0 0
0
Personnel Expenses
0 0 0 0 0
0
Supplies
0 0
0 0
0
0
0 0
0 0
0
0
Maintenance
0
Services
0
0 0
0
0 0
0
Equipment
0
0 0
0
0 0
0
Transfer
Debt
0
0 0
0
0 0
0
0
0 0 0 0 0
0
OPERATING IMPACT TOTAL
0
0 01
01
01 01
0
Page 88 09/07/2010
CAPITAL PROJECT
FY 2005/2006
TRA Assumption of N-1 Sewer
Project Description:
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 0 1 0 1 0 1 0 1 0 1 0 1 0 10
IMPACT ON OPERATING BUDGET
PROJECT EXPENSE
PROJECT
BUDGET
LTD
09/30/05
PROJECT
BUDGET
LTD
09/30/05
BUDGET
05/06 06/07
Planned
07/08 F 08/09
09/10
PROJECT
TOTAL
Purchase
0
0
0 0
0 0
0
0
0
0
0 0
0 0
0
0
Design
Construction
87,500
37,500 50,000
0
0
0 0
87,500
Implementation
0
0 0
0
0
0 0
0
Engineering
42,431
22,431 20,000
0
0
0 0
42,431
Legal
0
0 0
0
0
0 0
0
Contingencies (I & I Study)
75,000
0 75,000
0
0
0 0
75,000
PROJECT EXPENSE TOTAL
1 204,931
59,931 145,000
0
0 1
0 0
204,931
NET 1 0 1 0 1 0 1 0 1 0 1 0 1 0 10
IMPACT ON OPERATING BUDGET
PROJECT FUNDING
PROJECT
BUDGET
LTD
09/30/05
PROJECT
BUDGET
LTD
09/30/05
BUDGET
05/06
PROJECT
TOTAL
Planned
Administrative Expenses
PROJECT
TOTAL
06/07 07/08 08/09 09/10
Prior Year Remaining Fund
General Fund
0
0
0 0
0 0
59,931 145,000
0 0
0
0
0
0
0 0
0
Utility Fund 204,931
0 0 0 0
204,931
Visitor Fund 0
0 0 0 0
0
4A Loan
0
0 0
0
0
0
0 0
0
4B Loan
0
0 0
0
0
0
0 0
0
Grants
0
0 0
0 0
0
0
0 0
0
Private
0
0 0
0
0
0
0 0
0
Certificates of Obligation
0
0 0
0
0
0 0
0
PROJECT FUNDING TOTAL
204,931
59,931 145,000
0
0 1
0 0
204,931
NET 1 0 1 0 1 0 1 0 1 0 1 0 1 0 10
Page 89 09/07/2010
IMPACT ON OPERATING BUDGET
PROJECT
BUDGET
LTD
09/30/05
BUDGET
05/06
Planned
PROJECT
TOTAL
06/07 07/08 08/09 09/10
Administrative Expenses
0
0 0
0 0
0
0
0 0
0
Personnel Expenses 0
0 0 0 0
0
Supplies
0
0 0
0
0
0 0
0
Maintenance
0
0 0
0
0
0 0
0
Services
0
0 0
0
0
0 0
0
Equipment
0
0 0
0
0
0 0
0
Transfer
0
0 0
0
0
0 0
0
Debt
0
0 0
0
0
0 0
0
OPERATING IMPACT TOTAL
01
0 01
0 1
01
0 1 01
0
Page 89 09/07/2010
CAPITAL PROJECT
FY 2005/2006
Sewer & Water Installation for Portable Buildings
Project Description:
Sewer and water installation for temporary building to be used by court/town employees and Academy.
AL PROJECT EXPENSE
BUDGET
LTD
09/30/05
BUDGET
05/06
I Planned
PROJECT
TOTAL
06/07 07/08 08/09 09/10
Purchase
0 0
0 0 0 0
0 0 0 0
0
0
Design
0
0
Construction
0
23,500
0 0 0 0
23,500
Implementation
0
0
0 0 0 0
0
Engineering
0
3,000
0 0 0 0
3,000
Legal 0 0
Labor cost 0 0
0 0 0 0
0
0 0 0 0
0
PROJECT EXPENSE TOTAL 0 1 26,500
0 1 0 0 0
1 26,500
NET 1 0 1 0 1 0 1 0 1 0 1 0 0
JL IMPACT ON OPERATING
BUDGET
PROJECT FUNDING
LTD
09/30/05
BUDGET
05/06
Planned
PROJECT
TOTAL
06/07 07/08 08/09 09/10
LTD
09/30/05
BUDGET
05/06
0 0 0 0
Planned
Personnel Expenses
0 0 0 0
PROJECT
TOTAL
06/07 07/08 1 08/09 1 09/10
Prior Year Remaining Fund
General Fund
0
0
0 0
0 0
0
0
0
0
0
0
0
Utility Fund
0
26,500 0
0
0
0
26,500
Visitor Fund
0
0 0
0
0
0
0
4A Loan
0
0 0
0
0
0
0
4B Loan
0
0 0
0
0
0
0
Grants
0
0 0
0
0
0
0
Private
Certificates of Obligation
0
0
0 0
0 0
0
0
0
0
0
0
0
0
PROJECT FUNDING TOTAL
0
26,500 0
0
0
0
26,500
NET 1 0 1 0 1 0 1 0 1 0 1 0 0
JL IMPACT ON OPERATING
BUDGET
LTD
09/30/05
BUDGET
05/06
Planned
PROJECT
TOTAL
06/07 07/08 08/09 09/10
Administrative Expenses
0 0
0 0
0 0 0 0
0
0
Personnel Expenses
0 0 0 0
Supplies
0 0
0 0 0 0
0
Maintenance
0 0
0 0 0 0
0
Services
0 0
0 0 0 0
0
Equipment
0 0
0 0 0 0
0
Transfer
Debt
0 0
0 0 0 0
0
0 0
0 0 0 0
0
OPERATING IMPACT TOTAL
0 0
1 0 0 1 0 1 0
1 0
Page 90 09/07/2010
CAPITAL PROJECT
FY 2005/2006
Fidelity Waterline Extension
Project Description:
Construction of 12" waterline from Dove Road to Hwy. 114 along proposed FM1938. The construction will be funded by Fidelity as
outlined in the developers agreement.
PROJECT FUNDING
Project
Budget
PROJECT EXPENSE
LTD
09/30/05
BUDGET
05/06
Project
LTD BUDGET
Planned
PROJECT
Budget
09/30/05 05/06
06/07
07/08 08/09
TOTAL
Purchase
Grants
Equipment
Transfer
Debt
Design
36,340 350,890
387,230
Certificates of Obligation
Construction
250,000
300,890
300,890
Implementation
Engineering
36,340
36,340 50,000
86,340
Legal
Contingencies
PROJECT EXPENSE TOTAL
1 286,340
36,340 1 350,890
387,230
PROJECT FUNDING
Project
Budget
Project
Budget
LTD
09/30/05
BUDGET
05/06
Planned PROJECT
06/07 07/08 08/09 TOTAL
Prior Year Remaining Fund
General Fund _
Utility Fund
Personnel Expenses
Visitor Fund
4A Loan
4B Loan
Services
Grants
Equipment
Transfer
Debt
Private 286,340
36,340 350,890
387,230
Certificates of Obligation
OPERATING IMPACT TOTAL
PROJECT FUNDING TOTAL 286,340
36,340 350,890
387,230
IMPACT ON OPERATING BUDGET
Project
Budget
LTD
09/30/05
BUDGET
05/06
Planned PROJECT
06/07 07/08 08/09 TOTAL
Administrative Expenses
Personnel Expenses
Supplies
Maintenance
Services
Equipment
Transfer
Debt
OPERATING IMPACT TOTAL
Page 91 09/07/2010
PERMANENT CAPITAL MAINTENANCE PROJECT
FY 2005/2006
Sanitary Sewer Inflow & Infiltration Repairs
Project Description:
Repair of manholes, clean -outs, and mains to minimize infiltration of groundwater.
NET 1 01 01 01 01 01 0 0
IMPACT ON OPERATING BUDGET
PROJECT EXPENSE
IF
BUDGET
05/06
LTD
09/30/05
BUDGET
05/06
06/07 07/08
Planned
08/09
09/10
PROJECT
TOTAL
Purchase
Design
Construction
Implementation
0
0
0
0
0 0
0 0
0
0
0 0
0 0
0
0
25,000 0 0 0 0
25,000
0 0
2,000 0
0
0
0 0
0 0
0
2,000
Engineering
Legal
Contingencies
0
0
0
0 0
0
0 0
0
0 0 0 0 0
0
PROJECT EXPENSE TOTAL
0
27,000 0
0
0 0
27,000
NET 1 01 01 01 01 01 0 0
IMPACT ON OPERATING BUDGET
PROJECT FUNDING
IF
BUDGET
05/06
LTD
09/30/05
BUDGET
05/06
I
Planned
0
PROJECT
1 06/07 07/08 08/09 09/10
TOTAL
Prior Year Remaining Fund
0
0
0 0
0
0 0
0
General Fund
0
Utility Fund
0
27,000 0
0 0
0
0
0 0
0 0
27,000
0
Visitor Fund 0
PROJECT FUNDING TOTAL_F____70
0
27,000 0
0
0 0
27,000
NET 1 01 01 01 01 01 0 0
Page 92 09/07/2010
IMPACT ON OPERATING BUDGET
LTD
09/30/05
BUDGET
05/06
Planned
06/07 07/08 08/09
09/10
PROJECT
TOTAL
Administrative Expenses
0
0 0 0
0 0
0
Personnel Expenses
0
0 0 0
0 0
0
Supplies
0
0 0 0
0 0
0
Maintenance
0
0 0 0
0 0
0
Services
0
0 0 0
0 0
0
Equipment
0
0 0 0
0 0
0
Transfer
Debt
0
0
0 0 0
0 0
0
0 0 0 0 0
0
OPERATING IMPACT TOTAL
01
01 01 01
01
0
Page 92 09/07/2010
Section 14
Expanded
Level Service
Packages
Page 93 09/07/2010
Emplotjee Summarti FY 2005/2006
Expanded Level Service Package
Page 94 09/07/2010
FY 01/02
FY 02/03
FY 03/04
FY 04/05
FY 05/06
Town Manager
1
1
1
1
1
Assistant to Town Manager
1
1
0.5
0
0
Administrative Assistant
1
1
0
0
0
Executive Assistant
0
0
0.5
1
1
Part -Time Intern
1
0.5
0.5
0.5
0.5
Town Secretary
1
1
1
1
1
Building Official
0
0
1
1
1
Fire/EMS Coordinator
1
1
1
1
1
Firemen/Paramedics
0
9
9
10
10
Municipal Court Clerk
1
1
1
1
1
Municipal Court Deputy Clerk
0
0
1.5
1.75
1.75
Municipal Court Judge
1
1
1
1
1
Municipal Court Marshal
1
1
1
0
0
Municipal Court Warrant Officer
0
0
0
1
2
Public Works Superintendent
0
1
1
1
1
Utility & Building Technician
0
0
0
0
1
Facilities & Recreation
0
0
1
1
1
Finance Director
0
1
1
1
1
Human Resources Manager
0
0
1
1
1
Finance Assistant
1
1
1
1
1
Records & Revenue Clerk
0
0
0
0
1
Marketing & Public Affairs
0
0
1
1
1
Total
10.0
20.5
25.0
26.25
29.25
Page 94 09/07/2010
General Fund -Program Summary
Expanded Level Service
General Fund
Adopted
FY 05/06
Expanded
Level
FY 05/06
Beginning Balance (Cash)
$ 1,223,306$
1,223,306
Balance Sheet Affect to Cash '
(9,250)
(9,250)
Revenue
3,788,103
3,788,103
Expanded Level Service Revenue
-
1,597,897
Expenditures
3,712,469
3,712,469
Expanded Level Service Expenditures
-
580,870
Transfers In
1,965,337
1,965,337
Transfers Out
1,020,190
1,020,190
Ending Cash Balance
2,234,837
3,251,864
Restricted Funds
369,324
369,324
Ending Balance
$ 1,865,513 $
2,882,540
# Days Operating
183 1
245
General Fund - Transfers In
Adopted
FY 05/06
Expanded
Level
FY 05/06
Capital Projects
FM 1938 - RA, MP,SL, Keller Shortfall
$ - $
-
4A Funds
Dissolution of Fund
1,880,337
1,880,337
FM 1938 - Westlake Portion per Budget
-
-
FM 1938 - Westlake Portion
-
-
FM 1938/114 Interchange Improvements
-
-
Crime Control District
-
-
Transfer In
-
-
Utility Fund
-
-
Fort Worth Impact Fee Revenues
85,000
85,000
Debt Service
-
-
Debt Service for Civic Campus
-
-
Civic Campus Bond Funds
-
-
Total Transfers In
Is 1,965,337 1 $
1,965,337
Page 95 09/07/2010
General Fund -Program Summary
Expanded Level Service
General Fund - Transfers Out
Adopted
FY 05/06
Expanded
Level
FY 05/06
Transfer to Capital Projects
$ 55,646 $
55,646
FM 1938 (114 to 1709)
$ - $
-
FM 1938 / 114 Interchange (4A)
-
-
75,000
Transfer to Permanent Capital Maint Fund
-
-
Preventative Maintenance
10,000
10,000
Dove Road Improvements
66,000
66,000
Transfer to Special Revenue Fund - Grants
-
-
Town's 10% portion of FEMA grant
44,801
44,801
Long Range Commitment (debt service)
-
369,324
Transfer to Capital Project Fund
-
-
Cemetery Maintenance
57,400
57,400
Temp Office Building & Comm. Installation
93,800
93,800
Temp Parking and Pickup Area
266,525
266,525
Temp Parking for Portable Building Site
Civic Campus Expansion
-
-
4B Economic Development Fund
-
2002 Certificates of Obligation
-
-
2003 Certificates of Obligation
-
-
Debt Service Fund
Shortfall of 4B funding for Debt Service
-
-
Total Transfers Out
I $ 538,526 $
538,526
General Fund
Restricted Funds/Designated
Adopted
FY 05/06
Expanded
Level
FY 05/06
Court Security
$ 55,646 $
55,646
Court Technology
4,500
4,500
Court Bonds
-
-
75,000
Trail Escrow
-
-
149,185
Glenwyck Farms Trail & Dove Road Escrow
-
-
Capital Projects - Civic Campus
-
-
Long Range Commitment (debt service)
-
369,324
369,324
Total Restricted/Designated Funds
Is 653,656 1 $
429,470
Page 96 09/07/2010
General Fund -Program Summary
Expanded Level Service
General Fund
Expanded Level Service
Expanded
Adopted Level
FY 05/06 FY 05/06
Records and Revenue Clerk
$ - $ 19,838
Utility & Building Technician
- 20,443
STW Software Upgrade
- 13,283
Shops at Cirlce T Revenue
- 1,597,897
Shops at Cirlce T Expenditures
- 527,306
Total Expanded Level (Net)
$ - $ 1,017,027
Page 97 09/07/2010
Utility Fund -Program Summary
Expanded Level Service
Utility Fund
Adopted
FY 05/06
Expanded
Level
FY 05/06
Beginning Balance
$ 289,433 $
289,433
Balance Sheet Affect to Cash
(9,329)
(9,329)
Revenue
2,146,770
2,146,770
Expanded Level Service Revenue
-
75,484
Expenses (Net of depreciation/amortization)
1,508,762
1,508,762
Expanded Level Service Expenditures
-
68,537
Transfers In
-
-
Transfers Out
122,000
122,000
Net Operating Balance
$ 796,112 $
803,059
Capital Project Expenses
559,390
559,390
Ending Balance
$ 236,722 $
285,419
Utility Fund - Transfers Out
Adopted
FY 05/06
Expanded
Transfer to Permanent Capital Maint. Fund
Adopted
Level
Utility Fund - Transfers In
FY 05/06
FY 05/06
4B
-
-
Total Transfers In
-
85,000
Utility Fund - Transfers Out
Adopted
FY 05/06
Expanded
Level
FY 05/06
Transfer to Permanent Capital Maint. Fund
$ -
$ -
General Maintenance
$ 10,000
$ 10,000
Sanitary Sewer Inflow & Infiltration Repairs
27,0001
27,000
Transfer to GF - FW Impact Fee Revenue
85,0001
85,000
Total Transfers Out
$ 122,000
1 $ 122,000
Utility Fund - Capital Projects
Adopted
FY 05/06
Expanded
Level
FY 05/06
Knox Road Connection
$ -
$ -
Duct Bank
-
-
Keller Waterline
-
-
Water Meter Automation
37,000
37,000
SCADA System
-
-
TRA Assumption of N-1 Sewer
145,000
145,000
Water Meter Retrofit
-
-
Sewer/water Installation for Portable Bldg.
26,500
26,500
Fidelity Waterline Extension
350,890
350,890
Total Capital Projects
$ 559,390
$ 559,390
Expanded Level Service
Adopted
FY 05/06
Expanded
Level
FY 05/06
Records and Revenue Clerk
$ -
$ 13,886
Utility & Building Technician
-
20,443
STW Software Upgrade
-
9,298
Shops at Cirlce T Revenue
-
75,484
Shops at Cirlce T Expenditures
-
24,910
Total Expanded Level (Net)
$ -
$ 6,947
Page 98 09/07/2010
Visitor Fund -Program Summary
Expanded Level Service
Visitors Fund
Adopted
FY 05/06
Expanded
Level
FY 05/06
Beginning Balance
$ 825,076
$ 825,076
Balance Sheet Affect to Cash *
-
-
Revenues
453,000
453,000
Expenditures
450,257
450,257
Expanded Level Service Expenditures
-
9,936
Ending Balance
$ 827,819
$ 817,883
Expanded Level Service
Adopted
FY 05/06
Expanded
Level
FY 05/06
Records and Revenue Clerk
$ -
$ 5,951
STW Software Upgrade
-
1 3,985
Total Expanded Level (Net)
$ -
1 $ 9,936
Page 99 09/07/2010
EXPANDED LEVEL SERVICE PACKAGE
FY 2005/2006
Records and Revenue Clerk
Project Description:
Cost to hire, train, and equip a new Records and Revenue Clerk. Minimal training will be necessary. The cost will be split 25% to General
Fund Finance Department, 25% General Fund Building Inspcetion Department, 35% Utility Fund and 15% to Visitor Association Fund.
PROJECT FUNDING
IMPACT ON OPERATING
LTD
09/30/05
BUDGET
05/06
Planned
06/07 07/08 08/09 09/10
10/11
General Fund 50%
0
19,838
19,412 20,382 21,402 22,472
23,595
Utility Fund 35%
0
13,886
13,588 14,268 14,981 15,730
16,517
Visitor Fund 15%
0
5,951
5,824 6,115 6,420 6,742
7,079
4A Loan
0
0
0 0 0 0
0
4B Loan
Grants
0
0
0 0 0 0
0
0
0
0 0 0 0
0
Private
Certificates of Obligation
0
0
0
0 0 0 0
0
0
0
0 0 0 0
PROJECT FUNDING TOTAL
0
39,675 38,824 1 40,765 42,803 44,943
47,191
NET 1 0 0 1 0 1 0 1 0 1 0 0
Page 100 09/07/2010
IMPACT ON OPERATING
BUDGET
LTD
09/30/05
BUDGET
05/06
Planned
06/07 07/08 08/09 09/10
09/10
Personnel Salary (5% increase)
0
26,500
27,825
29,216
30,677
32,211 33,821
Taxes, TMS, WC (5% increase)
0
10,475
10,999
11,549
12,126
12,732 13,369
Initial Hiring Expense
0
500
0
0
0
0 0
Computer and Supplies
0
1,700
0
0
0
0 0
Renovate Existing Desk Space
0
1 500
0 1
0
0
0 0
OPERATING IMPACT TOTAL
01
39,675
1 38,824 1
40,765 1
42,803 1
44,943 147,191
NET 1 0 0 1 0 1 0 1 0 1 0 0
Page 100 09/07/2010
or west
�4 pr' --A
Job DescriptionforAdministrativeEmplo-Ljee
RECORDS & REVENUE CLERK
25% General Fund Dept 18 - 25% General Fund Dept 12 - 35% Utility Fund Dept 18 - 15% Visitor Assoc Dept 18
UTILITY FUND
• Accounts Receivable — Utility Billing
*Add new accounts to STW
*Change existing account information in STW
*Discontinue accounts in STW
*Transfer accounts in STW
*Maintain & update water account information (address, etc)
*Field A/R calls/inquiries from customers
*Review Aging Reports from STW
*Set up & maintain Collections System
*Review monthly billing register prior to exporting file to Dataprose
*Receive and review cash deposits from customers
*Administrative assistance for Public Work Director (dispatch calls, etc)
*General monthly statistical billing report and graph
BUILDING OFFICIAL
• Administrative
*Update and maintain Building Permit File
*Update and maintain contractor Registration File
*Receive permit fee payments
*Generate receipts
*Issue permits with approved sets of plans
*Filing
*Assist applicant in the submittal process to achieve a Permit and Contractor Registrations
*Receive construction plans and applications, cross checking to insure completeness.
*Coordinate with Westlake Academy regarding individuals who have registered their children
for enrollment are actually building a house in Westlake.
Set up and maintain a record keeping process for construction projects
Tabulate all modalities and time allocations performed
Process requests for gas and electric meters to be set
Receive and develop Field Inspection Requests
File completed Field Inspection Reports
* These duties are currently being Performed by J
THE TOWN OF WESTLAKE * 2650 OTTINGER ROAD * WESTLAKE,, TEXAS 76262
Page 101 09/07/2010
or west
�4 pr' --A
Job DescriptionforAdministrativeEmplo-Ljee
RECORDS & REVENUE CLERK
25% General Fund Dept 18 - 25% General Fund Dept 12 - 35% Utility Fund Dept 18 - 15% Visitor Assoc Dept 18
GENERAL FUND
Accounts Payable - (Academy & Foundation)
*Receive and review invoices against budget
*Code invoices for payment
*Prepare Accounts Payable Report for Board Meeting
*Prepare Accounts Payable Report for Foundation Board
*Obtain approval by Finance Director/Town Manager/Board
*Enter invoices into STW
*Print Checks
*Obtain appropriate signatures as needed
*Separate checks, stuff & mail out
*Match check copies to invoices & file
*Ongoing vendor statement reconciliation
• Banking
*Receive and review cash deposits - Town, Utility, Utility Accounts Receivable Payments,
Academy, Court, Foundation
*Code deposits for receipt and obtain approval of Finance Director
*Enter deposits into STW
*Complete 5 bank reconciliations - Town, Utility, Academy, Court, Foundation
*Complete 8 Texpool reconciliations - Town, Utility, Court, Visitor, 4A, 4B, Civic, Lone Star
*Obtain approval by Finance Director
Take deposits to the bank
• Administrative
Share front desk receptionist & telephone duties with Jaymi
Back up for Jaymi (vacation, etc)
*Place Office Depot orders for Town
*Update Telephone listing as needed
*Open incoming mail & distribute
*Stamp outgoing mail
*Administrative assistance for Debbie
* These duties are currently bein;7 performed by J
THE TOWN OF WESTLAKE * 2650 OTTINGER ROAD * WESTLAKE,, TEXAS 76262
Page 102 09/07/2010
o� west
�4 pr' --A
Job DescriptionforAdministrativeEmplo-Ljee
FINANCE ASSISTANT
50% General Fund Dept 18 - 35% Utility Fund Dept 18 - 15% Visitor Assoc Dept 18
ACCOUNTS RECEIVABLE
o Serve as backup to Additional Personnel
o Review Court Paymentech Statement against bank statement and general ledger
o Process invoice to Glenwyck Farms for Landscape Maintenance chargeback
o Process invoice to TSH for Office Depot & Postage chargeback
o Process invoice to Academy for Postage chargeback
o Process invoice to Foundation for Postage chargeback
ACCOUNTS PAYABLE - TOWN, UTILITY & COURT
o Receive and review invoices and compare to budget
o Code invoices for payment
o Prepare AP Invoice Report for Board Meeting
o Prepare $ l OK Invoice Report for Board Meeting
o Receive approval from Finance Director/Town Manager/Board
o Enter invoices into STW
o Print Checks - Town, Utility, Court/Obtain appropriate signatures as needed
o Separate checks, stuff & mail out
o Match check copies to invoices & file - Town, Utility, Court
o Ongoing Vendor Statement Reconciliation
BANKING
o Backup for Additional Personnel
o Process JE for Bank Charges
o Process JE for Texpool Charges
o Review completed bank reconciliations
ADMINISTRATIVE
o Back up additional personnel on front desk receptionist & telephone duties
o Back up for additional personnel (vacation, etc)
o Set up & maintain Funds/Accounts/Departments in STW
o Administrative assistance for Debbie
o Administrative assistance for Trent regarding special projects
THE TOWN OF WESTLAKE * 2650 OTTINGER ROAD * WESTLAKE, TEXAS 76262
Page 103 09/07/2010
o� west
�4 pr' --A
Job DescriptionforAdministrativeEmplo-Ljee
FINANCE ASSISTANT
50% General Fund Dept 18 - 35% Utility Fund Dept 18 - 15% Visitor Assoc Dept 18
OTHER MISCELLANEOUS
o Set-up and maintain Town's filing system
o Process Court month end JE's
o Process Texpool/bank transfer JE's in STW
o Process Electronic Funds Transfer JE's in STW
o Maintain Capital Projects File
o Update 6 Monthly Reports - Town, Utility, Visitor, 4A, 413, Civic
o Update Monthly Variance Reports
o Update Fort Worth Impact Fee Report
o Update Fort Worth Water/Peak Payment Report
o Update Sales Tax Report
o Update Due To/Due From Report
o Process Due To/Due From Payment Transfers
o Process Due To/Due From Payment JE
o Update 6 Cash Analysis Reports - Town, Utility, Visitor, 4A, 413, Civic
o Update Utility Billing Report - Electric, Gas, Phone, Water
o Process Petty Cash Reimbursements
o Assist in the Budget process
THE TOWN OF WESTLAKE * 2650 OTTINGER ROAD * WESTLAKE, TEXAS 76262
Page 104 09/07/2010
EXPANDED LEVEL SERVICE PACKAGE
FY 2005/2006
Utility and Building Technician
Project Description:
Cost to hire, train, and equip a new Utility and Building Technician employee. Training will consist of water, wastewater, street pavement,
safety training, and building inspections. Equipping will consist of a utility truck, personal safety equipment, uniforms, and miscellaneous
supplies. The cost will be split evenly between the Utility Fund and the General Fund Building Inspection Department.
NET 1 0 0 1 0 1 0 1 0 1 0 0
Page 105 09/07/2010
IMPACT ON OPERATING
PROJECT FUNDING
LTD
09/30/05
LTD
09/30/05
BUDGET
05/06
Planned
Planned
06/07 07/08 08/09 09/10
06/07 07/08
08/09 09/10
10/11
General Fund 50%
Utility Fund 50%
0
20,443
21,173
21,173
22,202
22,202
23,283
23,283
24,417
24,417
25,608
25,608
0
20,443
Visitor Fund
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
4A Loan
0
4B Loan
Grants
Private
Certificates of Obligation
0
0
0
0
0
0
0
0
0
0
0
0 0 0 0
0 0 0 0
0
0
0
PROJECT FUNDING TOTAL
01
40,885 42,346
44,404
46,565
48,834
51,216
NET 1 0 0 1 0 1 0 1 0 1 0 0
Page 105 09/07/2010
IMPACT ON OPERATING
BUDGET
LTD
09/30/05
BUDGET
05/06
Planned
06/07 07/08 08/09 09/10
10/11
Personnel Salary (5% increase)
0
26,500
27,825
29,216
30,677
32,211
33,821
Taxes, TMS, WC (5% increase)
0
12,475
13,099
13,754
14,441
15,163
15,922
Initial Hiring Expense
0
500
0
0
0
0
0
Uniforms (2% increase)
0
260
265
271
276
281
287
Training (2% increase)
0
340
347
354
361
368
375
Mobile Phone
0
600
600
600
600
600
600
Dues & Licenses
1 0
1 210
1 210 1
210
210
210
210
OPERATING IMPACT TOTAL
01
40,885
1 42,3461
44,404
46,565
48,834
51,216
NET 1 0 0 1 0 1 0 1 0 1 0 0
Page 105 09/07/2010
o� west
�4 �A
Job Descriptionfor Public Works Employee
UTILITY & BUILDING TECHNICIAN
50% Utility Fund Dept 16 - 25% General Fund Dept 12 - 25% General Fund Dept 16
PUBLIC WORKS & UTILITY
Maintain water distribution & waste water collection system
Read, install, test, and remove water meters
Maintain water meter boxes and sanitary sewer clean outs in good condition
Install new water meter boxes as necessary
Exercise water valves
Check lift stations for proper operation
Assist with utility inspections
Check manholes for debris accumulation and clean as necessary
Perform routine and emergency turn-offs as necessary
Perform utility line locates as needed
• Perform meter replacement program
Install and document meter replacements in accordance with approved replacement list.
Maintain streets and ROWS
Fill pot holes when non -conducive for contract work
Repair traffic control signs as needed
Clear roadways of debris
Assist with Street Evaluation Assessments
• Miscellaneous duties
Assist DPS with emergency traffic control (barricades, road closures)
Assist Academy as required
Assist Facilities and Recreation Department as required
THE TOWN OF WESTLAKE * 2650 OTTINGER ROAD * WESTLAKE, TEAS 76262
Page 106 09/07/2010
o� west
�4 �A
Job Descriptionfor Public Works Employee
UTILITY & BUILDING TECHNICIAN
50% Utility Fund Dept 16 - 25% General Fund Dept 12 - 25% General Fund Dept 16
BUILDING OFFICIAL
Construction Inspection
Share the Inspection Workload, as Competencies and Code Knowledge are demonstrated.
Study and Train to achieve Certifications in five areas of Residential Inspections
1- IECC Residential Energy Plans Examiner and Inspector Certification
2- Texas State Board of Plumbing Inspector License
3- IRC Residential Mechanical Inspector Certification
4- IRC Residential Electrical Inspector Certification
5- IRC Residential Plumbing Inspector Certification
6- IRC Residential Building Inspector Certification
7-
• Code Enforcement
Signage -Communicate to the sign owner, the applicable Sign Ordinance and retrieval procedure.
Parking — Maintaining adequate width of roadways for Emergency Vehicles to travel.
Construction Site — Life and Safety issues, as they arise. Debris, Noise, Hours of Construction
THE TOWN OF WESTLAKE * 2650 OTTINGER ROAD * WESTLAKE, TEAS 76262
Page 107 09/07/2010
EXPANDED LEVEL SERVICE PACKAGE
FY 2005/2006
Shops at Circle T
Project Description:
Development fees consist of platting, plan reviews, building inspections, construction inspection of on-site and off-site
utility improvemnts.
IMPACT ON OPERATING BUDGET
PROJECT FUNDING
BUDGET
05/06
Planned
PROJECT
TOTAL
06/07 07/08 08/09 09/10
LTD
09/30/05
BUDGET
05/06
Planned
Estimated Expenses - Utility Fund
0
PROJECT
TOTAL
06107 07/08 08/09 09/10
Inspection Fees - General Dund
0
0
452,176
0
0
0
1,276,691
824,515
Inspection Fees - Utility Fund
0
75,484
75,484
0
0
0
150,968
Plan Review Fees
0
280,941
63,023
0
0
0
343,964
Permit Fee
0
227,841
96,958
0
0
0
324,799
Sales Taxes
0
171,720
317,580
0
0
0
489,300
Subdivision Fees
0
92,880
0
0
0
0
92,880
Plan Review - Finish Out
0
0
0
0
96,932
11,835
108,767
Permit Fee - Finish Out
0
0
0
0
99,416
67,916
167,332
PROJECT FUNDING TOTAL
0
1,673,381
1,005,221
0
196,348
79,751
2,954,701
IMPACT ON OPERATING BUDGET
LTD
09/30/05
BUDGET
05/06
Planned
PROJECT
TOTAL
06/07 07/08 08/09 09/10
Estimated Expenses - Utility Fund
0
24,910
24,910 0 0 0
49,819
Estimated Expenses - General Fund
0
527,306
306,813 0 64,795 26,318
925,232
0
0
0
0
0
0
0
OPERATING IMPACT TOTAL 01
552,216
331,723 01 64,795 1 26,318 975,051
N E T 1 0 1 1,121,165 1 673,498 1 0 1 131,553 1 53,433 1,979,650
Page 108 09/07/2010
EXPANDED LEVEL SERVICE PACKAGE
FY 2005/2006
STW Software Upgrade
Project Description:
Conversion from DOS based software to Windows based software.
NET 1 0 1 0 1 0 1 0 0 1 0 0
Page 109 09/07/2010
IMPACT ON OPERATING BUDGET
PROJECT FUNDING
LTD
09/30/05
BUDGET
05/06
LTD
BUDGET
Planned
PROJECT
TOTAL
06/07 07/08 08/09 09/10
PROJECT
06/07
07/08 08/09
0
09/10
0
09/30/05
05/06
TOTAL
General Fund 50%
0
13,283 0
0
0
0
13,283
Utility Fund 35%
0
9,298 0
0
0
0
9,298
Visitor Fund 15%
0
3,985 0
0
0
0
3,985
4A Loan
0
0 0
0
0
0
0
4B Loan
0
0 0
0
0
0
0
Grants
0
0 0
0
0
0
0
Private
0
0 0
0
0
0
0
Certificates of Obligation
0
0 0
0
0
0
0
PROJECT FUNDING TOTAL
0
26,565 0
0
0
0
26,565
NET 1 0 1 0 1 0 1 0 0 1 0 0
Page 109 09/07/2010
IMPACT ON OPERATING BUDGET
LTD
09/30/05
BUDGET
05/06
Planned
PROJECT
TOTAL
06/07 07/08 08/09 09/10
Implementation & Data Conversion
0
4,800
0
0
0
0
4,800
End User Training
0
2,400
0
0
0
0
2,400
Impromptu Report Tool
0
2,195
0
0
0
0
2,195
Rework existing cutomer programs
0
1,200
0
0
0
0
1,200
ACH software
0
405
0
0
0
0
405
Server & Hardware
0
6,515
0
0
0
0
6,515
Server Software & Services
1 0
9,050
0
0
0
0
9,050
OPERATING IMPACT TOTAL
1 01
26,565
01
01
01
0
26,565
NET 1 0 1 0 1 0 1 0 0 1 0 0
Page 109 09/07/2010