HomeMy WebLinkAboutBudget Followup handoutMEMORANDUM
DATE: August 29, 2011
TO: Honorable Mayor and Council
FROM: Tom Brymer, Town Manager
RE: FY 2011 -2012 Budget Workshop Follow -Up
X
�b
During the Council's recent budget workshop held on August 12, 2011, the Mayor and Council
requested additional information and /or follow -up on several items. Staff made note of these and
prepared the following materials in response to these requests. The list below identifies the item
or topic discussed, a description of the materials provided and their location in this packet.
Item /Topic
Utility Profits /Water Rates
Dove/Randol Mill Intersection
Trail Connection GW- Vaquero
Speed Limit Signs
$30 M Unfunded CIP
HOT tax revenues
Payroll Allocation
Hayes Plan
Description
Retail /Wholesale cost comparison
Traffic Circle Cost Estimate
Project Detail sheet for E. Dove
Cost estimate for numeric displays
FY 08 -09 budget excerpt
HOT tax revenue information
Payroll allocations by fund
Future BOT discussion item
Page
1 11 --1Z.
2 15000D
3
4
5
6
7
WATER AND SEWER COSTS
WATER - the wholesale component includes the cost of water — both water purchase and peak charges. The
Retail component is the amount necessary to provide water service to Westlake customers from the Fort Worth
meter. This amount is determined by subtracting wholesale costs from revenues then dividing by the amount of
water purchased.
(Revenues - Wholesale costs) = Retail Costs
Total number of gallons purchased
WATER
Westlake Retail vs Wholesale
$6.00
$5.00 – —
m
c $4.00
-- - - - - -- --
° $3.00 $1.99
$1.81 $1.
Q. $2.00
$1.00
$0.00
$2.11 $2.04 $2.09 $2.29 $2.75
Audited FY Audited FY Audited FY Audited FY Audited FY Audited FY Est. FY 10/11 Proposed FY
04/05 05/06 06/07 07/08 08/09 09/10 11/12
Wholesale - The cost of water from provider Wholesale ■ Westlake Retail
Westlake Retail - Westlake system costs
SEWER - the wholesale component includes the cost of sewer treatment provided by TRA. The Retail
component is the amount necessary to provide sewer service to Westlake customers up to the TRA meter. This
amount is determined by subtracting wholesale costs from revenues then dividing by the amount of sewer
treated.
(Revenues - Wholesale costs) = Retail Costs
Total number of gallons purchased
SEWER
Westlake Retail vs Wholesale
$10.00
$8.00
$6.00 $3.39 $3.18
$3.18 $2.95
Q $4.00
t�
$2.00
$0.00 '
Audited FY Audited FY Audited FY Audited FY
04/05 05/06 06/07 07/08
Wholesale - The cost from treatment provider
Westlake Retail - Westlake system costs
1
$3.65
$2.98 $4.38
$3.56
Audited FY Audited FY Est. FY 10/11 Proposed FY
08/09 09/10 11/12
Wholesale 0 Westlake Retail
Project Description:
Reconstruction and reconfiguration of
Dove /Randol Mill from a 3 -way stop
intersection to to a traffic circle to improve
traffic safety.
i k. L_�
>r
Thru
09/30111
PROJECT
Budget
FY 11/12
EXPENSE
Planned
Project
Total
12/13
13/14
14/15
15116
Engineering
-
15,000
467,550
-
-
-
482,550
Construction
-
-
1,599,000
-
-
-
1,599,000
ROW purchase
-
-
-
-
-
-
0
Equipment
-
-
I -
-
i -
I -
1 0
EXPENDITURES TOTAL
-
15,0001
2,066,550
-
I -
I -
1 2,081,550
IMPACT
Thru
09/30/11
ON OPERATING
Budget
FY 11112
BUDGET
Planned
Project
Total
12113
13/14
14/15
15116
Supplies
-
-
-
-
-
-
-
Maintenance
-
-
2,500
2,500
2,500
7,500
Services
-
-
-
-
-
-
-
Equipment
-
-
-
-
I -
I -
-
OPERATING IMPACT TOTAL
-
-
2,500
1 2,500
2,500
7,500
Vision Point: Inviting Neighborhoods
Project Description:
The project will provide stabilization of road subgrade
and 6" of asphalt to approximately 6,500 LF of Dove
Road and replace /improve culverts and ditches.
Anticipate crack sealing 2nd year from completion. The
cost below reflects construction by private contractor
without Tarrant County participation. This work will also
include construction of a pedestrian trail from FM 1938 to
the Glenwyck Farms. This includes 3rd party
construction inspection services.
GL CODE: TBD
Est.
09/30/11
PROJECT
Budget Planned Project
FY 11/12
12/13
13/14
14/15
15116
Total
Engineering
-
-
-
106,590
-
-
106,590
Construction
-
-
-
393,750
-
-
393,750
Trail Construction
-
-
-
126,600
-
-
126,600
EXPENDITURES TOTAL
-
-
-
626,940
-
-
626,940
IMPACT ON OPERATING
Est. Budget
09130/11 FY 11/12
BUDGET
Planned
I
Project
Total
12/13
13/14
14/15
15116
Supplies
-
-
-
-
-
-
-
Maintenance - Landscaping
-
-
-
-
3,728
3,763
7,490
Services
-
-
-
-
-
-
-
Water & Power Usage
-
-
-
-
10,600
-
10,600
Debt Service
-
-
-
46,023
46,296
46,236
138,554
OPERATING IMPACT TOTAL
-
-
-
46,023
60,623
49,998
156,644
Radar Signs
As Council requested, staff has researched radar signs similar to the one on Randol mill Road in
Southlake and the one that the City of Keller uses. The signs will cost approximately $3,500
each. If the signs are placed in areas without an existing power source we would need to install a
solar panel and battery at an additional cost of approximately $500.
SPEED
LIMIT
51
..•
1
YOUR SPEED
4
Town Hall /Municipal Court /Library $ 10.00 million
Major Trail Enhancements 2.00 million
Fire Station 4.00 million
Park Improvements 2.00 million
Additional Academy Building Expansion 8.00 million
Road and Bridge Improvements
Dove Road (50% paid by Developer) 1.50 million
Major Cemetery Improvements 1.07 million
FM 1938 Streetscape /Way Finder 1.50 million
$ 30.07 million
(Excerpt from FY 2008/2009 Budget document)
5
$600,000
$500,000
$400,000
$300,00(
$200,00
$100,0(
■ Y/E TOTAL w BUDGET
FY 07/08 ~
F)
Fiscal Year = October through September
FY 09/10
FY 10/11
Visitors Association Fund
31320 HOTEL OCCUPANCY TAX
This revenue reflects occupancy tax of 7% derived from the Marriott hotel.
State law allows municipalities to collect 7% hotel /motel taxes for special uses.
Westlake has specific legislative authority to utilize hotel /motel tax money for a
broader range of uses than most municipalities in the state
FY 03/04
55,231
30,321
47,409
30,530
30,548
33,701
33,290
33,339
34,025
54,330
24,953
33,171
440,849
325,000
115,849
FY 04/05
36,467
28,909
22,594
29,486
29,751
29,400
36,657
32,596
32,788
24,619
50,961
26,992
381,221
414,000
(32,779)
FY 05/06
37,225
32,024
24,965
32,251
33,742
37,871
37,441
42,273
38,836
31,357
36,338
31,221
415,544
425,000
(9,456)
FY 06/07
37,583
45,489
65,445
31,896
30,187
25,862
35,113
40,864
37,208
30,078
31,856
46,889
458,471
400,000
58,471
FY 07/08
35,499
30,021
25,640
37,687
47,473
50,242
50,720
48,792
42,943
41,865
31,762
85,019
527,662
430,000
97,662
FY 08/09
53,873
41,066
30,248
37,570
36,020
33,526
46,031
36,277
46,953
26,281
33,300
76,626
497,769
450,000
47,769
FY 09/10
40,584
34,431
21,508
34,905
36,058
32,751
42,997
38,124
32,366
29,982
34,221
79,765
457,693
450,000
7,693
FY 10/11
44,949
40,171
29,263
43,123
49,065
37,358
45,724
43,094
41,420
38,327
0
0
412,494
535,000
(122,506)
6
Position Summary FY 2011/2012
Employees by Department and Fund Allocation
GENERAL FUND VISITOR FUND UTILITY FUND
Position EmplDepts Percent Total Percent Total Percent Total
per
11 Town Manager
1.00
70% 0.70
15% 0.15
15% 0.15
Assistant to the Town Manager
0.75
70% 0.53
15% 0.11
15% 0.11
Part-Time Intern
0.75
100% 0.75
0% -
0% -
2.50
1.98
0.26
0.26
12 Planning & Development Director
1.00
100% 1.00
0% -
0% -
Administrative Clerk
0.33
100% 0.33
0% -
0% -
1.33
1.33
-
-
13 Town Secretary
1.00
100% 1.00
0% -
0% -
1.00
1700
1 1
1 1 -
14 Fire Chief
1.00
100% 1.00
0% -
0% -
Lt. Firemen /Paramedics
2.00
100% 2.00
0% -
0% -
Firemen /Paramedics
6.00
100% 6.00
0% -
0% -
9.00
9.00
-
-
15 Court Administrator
0.25
100% 0.25
0% -
0% -
Supervisor
1.00
100% 1.00
0% -
0% -
Deputy Clerk (2)
1.00
100% 1.00
0% -
0% -
Judge
1.00
100% 1.00
0% -
0% -
Marshal
1.00
100% 1.00
0% -
0% -
Part -Time Clerk
0.50
100% 0.50
0% -
0% -
4.75
16 Public Works Superintendent
1.00
25% 0.25
0% -
75% 0.75
Utility & Building Technician
1.00
40% 0.40
0% -
60% 0.60
2.00
0.65
-
1.35
17 Facilities Maintenance Director
0.50
75% 0.38
25% 0.13
0% -
Administrative Clerk
0.33
50% 0.17
50% 0.17
0% -
0.83
�_j 0.54
0.29
18 Finance Director
1.00
50% 0.50
25% 0.25
25% 0.25
Finance Assistant
1.00
50% 0.50
25% 0.25
25% 0.25
Records & Revenue Clerk
1.00
25% 0.25
25% 0.25
50% 0.50
3.00
�® 1.25
0.75
1.00
19 Parks & Recreation Director
0.50
75% 0.38
25% 0.13
0% -
Westlake Academy Technician
0.25
100% 0.25
0% -
0% -
0.75
0.63
0.13
-
20 Information Technology Director
0.50
100% 0.50
0% -
0% -
Westlake Academy Technician
6.25
100% 0.25
0% -
0% -
0.75
0.75
-
-
21 Human Resources Director
0.50
87% 0.43
8% 0.04
5% 0.02
Administrative Clerk
0.33
87% 0.29
8% 0.03
5% 0.02
0.83 ®
0.72
0.07
1 1 0704
22 Communications Director
1.00
0% -
100% 1.00
0% -
1.00
-
1.00
Total Employees
27.75
GF= 22.60
VA= 2.50
UF= 2.65
7 81%
9%
10%