HomeMy Public PortalAboutBox 505 REK #1 WATER FUND COST EST.Water Fund
0) • O� W a) a) O (n- h
O 0-)C')0L0N C NC))(O() .0 CO
LL N N 0) V' co 0) 00 (A
N a- .0. a- N
v) Ca v) v) w CA Ca CR CR w w
Of CO
N CO O)O r 0)�� CO O
} N,- N- �— co M 0csi co 0))� co.Nco.
W N ▪ N
Le EaEA/ V3w 4,4, ER ER w w
co co N 0 co(n cm (0 (O (17 CO O CO
O CO (n CO. N (n (n h 1()
o } a- 0() COaM N 0) a- h a-
✓ N a- M N
(»E0v>(»w E0fie 60E0 w w
0 (- (f) O N 0 CO0 00 (0
� CO CO 00.
LO 0)� c.. s— CO CO 0 c0
V.
>-10(1 MN 00)-N CO co
U. N M `�
(» (n (» (» w (n to, u3 (» (» w pp
L
C 3 7
C N- CO C.) N
Q N
co 0
- (0
0)�
r;
co
N 0)
69
6a
O
()- (OO CO
M (n
COCO(O
N O)
CO- a-
a- el
N N-
69
0)
0
M N
el CO
COV-
CO
(n CO (f) O (
N
0 (j
(O
O
6 9
6a
C)00— OO � OM c0
c)N (f) (() N 00 ((i (0 0 N- V' O >` O ) co T >.
.L.L ((�0)N OOIA OCO Ma-0N N O OL a L
CO N (- a-M (. 0) O (0 0 0) to C N 0) a) (VO () U
O (0 co O (n 1n 0) M O (f) 0 0) in a) -0 to a) >. (
LL ,- co co co N N 0) ,- (n c)N N N 7 L co a).c N
v- V- M M (0 co c o v N (9 Q
6a 6a Ea Eaw V3 (A(A V3Cflw w 0 U L C'C U V) (()
C c o C c v
0 0 0 0 0 \ 0 0 . N C 0 E C
C) (.0 C) 0 0ao ,- in m ) MI C0 3
N 0 C E 7 1.51
._
0 E C 7 N (1) O
c)Q
Q Q 0. O 0
0 a N N Y E
a) c E QQ0 y
c> y y LLl w N Q
2 X Q >� C o co `
:(j C � O comic m y
C N NC
o 0) 7 — 0) N
OcamOaO01-
N
0 CO O
O • LJ V- O N
COCO
V
} L (.0
0)
LL LL
a>
((0 O
(/)d .•
> � (A LLB}
N N w y O L
U i c Q C
c_ �a) 3Q
( C C .0 co c,
C a) (0 °' j LE, CO
(0 ) N N 0 co A )
CO �U 8 co
N N�
o o m 0 c 0
I o=LL0>-
a N0.S T
CO
O N N } (n } a0
y a) CO 1L 7 LL To}
C O O C LL
OO LL 322 ) N N
O '5 N O) Q N.0 0)
C a) > C a) N N
saOC">10
°cf0Ef0Em
O .L. O O (0
2 0) C (0
E c
0 N
(n 0) C C
1i C , > > 0. a ) CO
> _ c W W
O Nr > CO N
• a> CXfY c'a w
O co
C Z j. a) :a6
O a) 7 .- O a) 0C - a) (a O
—101nm01- dO01-UF
Revenue over (Expense)
110 LO
r--
(- CO
O
N.- CO
69
6a
0
} 10 N
LLr-O
N CO
0 0
LO
(0 N-
ea 4,
N
c
0
0 (0
Cl) c
C
c >.
CO.) 1)
Water Fund
FY05 FY06 FY07 FY08 FY09 FY10
Cash to Spend $ 3,142,977 $ 4,378 $ 94,924 $ 11,862 $ 60,614 $ 114,012
DEQ Loan $ $ - $ $ - $ $
Connection Fees 10% $ 65,000 $ 162,500 $ 178,750 $ 196,625 $ 216,288 $ 237,916
Service Revenue 5% $ 1,750,401 $ 1,837,921 $ 1,929,817 $ 2,026,308 $ 2,127,623 $ 2,234,004
Buy -In 10% $ 375,000 $ 1,301,250 $ 1,431,375 $ 1,574,513 $ 1,731,964 $ 1,905,160
Other Revenue 0% $ 204,521 $ 51,850 $ 51,850 $ 51,850 $ 51,850 $ 51,850
Total Revenue $ 5,537,899 $ 3,357,899 $ 3,686,716 $ 3,861,158 $ 4,188,339 $ 4,542,942
Personnel Expense 10% $ 270,908 $ 297,074 $ 326,781 $ 359,460 $ 395,405 $ 434,946
Operating Expense 8% $ 277,267 $ 239,685 $ 258,860 $ 279,569 $ 301,934 $ 326,089
Debt $ 816,760 $ 817,052 $ 813,085 $ 823,217 $ 884,893 $ 842,253
Transfers 0% $ 133,855 $ 156,164 $ 156,164 $ 156,164 $ 156,164 $ 156,164
Capital $ 4,034,731 $ 1,753,000 $ 2,119,964 $ 2,182,134 $ 2,335,931 $ 1,649,832
Total Expense $ 5,533,521 $ 3,262,975 $ 3,674,854 $ 3,800,543 $ 4,074,327 $ 3,409,284
Revenue over (Expense)
$ 4,378 $ 94,924 $ 11,862 $ 60,614 $ 114,012 $ 1,133,659
Connection Fees - Assumes a 10% increase each year in number of connections over FY06 budget and no increase in fees.
Service Revenue - Assumes a 5% increase each year from the previous year.
Buy -In - Assumes a 10% increase each year in number of connections over FY06 budget and no increase in fees.
Other Revenue - Assumes no significant change each year (starting with FY06 budget amount).
Personnel Expense - Assumes a 10% increase each year from the previous year (salaries & benefits on existing staff - no new employees).
Operating Expense - Assumes a 10% increase each year from the previous year. (4 year average - FY03 & FY04 actuals plus FY05 & FY06 budget).
Debt - Based on known debt payments each year.
Transfers - Assumes no significant change each year (4 year average - FY03 & FY04 actuals plus FY05 & FY06 budget).
East Storage Tank (1
Million Gallons -
Includes Pumps,
Transmission Lines,
and PRV's) 20%
12" Line on Boydstun
Street (Hwy 55 to Rio
Vista Blvd)
12" Line on Rio Vista
(Boydstun Street to
River Crossing)
6" Line on Rio Vista
(Rowland Street to
Sunny Way) & Gabi
Lane 20%
8" Line on 3rd Street
(Floyde Street to
Park Street) 20%
6" Line on Davis
Avenue (Wanda
Avenue to Ruby
Street) 20%
12" Line on Spring
Mountain Boulevard
(connect the 12" line
from Majestic View
Drive to the 12" line
from Lick Creek
Road)
10" Line on Hwy 55
(M Resorts to
Knowles Road)
8" Line on Boydstun
Lane & Hayes Street
(Hwy 55 to Herrick
Street)
6" Line on Louisa
Avenue (Pine Street
to Hemlock Street)
8" Line on Miles
Standish Road
(University Lane to
Carico Road)
6" Lines on Allen
Avenue, Timm
Street, & McGinnis
Street
6" Line on
Saddlehorn Lane
(Baycolt Way to
Buckboard Way)
West Storage Tank
WhiteTail Oversize
Subdivision Oversize
4" Line Replacement
Projects
Truck & Chlorine
Analyzer
Equipment &
Vehicles
Mapping
TOTAL
Estimated Costs
FY01 FY05 FY06 FY07
4 5 6
$ 2,488,320
322,500
20%���'. , e ) $ 1,087,811
FY08
7
$ 1,917,002
$ 633,029
$ 931,627
20% as "i $ 328,458
FY09 FY10
8 9
20% iE gf $ 1,238,347
20% $ 485,879
20% ' 3t � # ° $ 300,987
20% .t ts) $ 257,989
20% $ 768,807
20% $ 257,989
20% , y `i"' $ 1,500,000
$ 100,000
20% ( $ 50,000 $ 60,000 $ 72,000 $ 86,400
20% 90,000 $ 108,000 $ 129,600 $ 155,520 $ 186,624 $ 223,949
$ 31,100
5% } ( $ 30,000 $ 31,500 $ 33,075 $ 34,729 $ 36,465
5% )j? $ 15,000 $ 15,000 $ 15,750 $ 16,538 $ 17,364 $ 18,233
$ 4,034,731 $ 1,753,000 $ 2,119,964 $ 2,182,134 $ 2,335,931 $ 1,649,832
Water Fund
FY05 FY06 FY07 FY08 FY09 FY10
Cash to Spend $ 3,142,977 $ 48,490 $ 15,935 $ 105,384 $ (22,712) $ 1,932,798
DEQ Loan $ 1,800,000 $ $ $ $ - $
Connection Fees 10% $ 65,000 $ 162,500 $ 178,750 $ 196,625 $ 216,288 $ 237,916
Service Revenue 5% $ 1,750,401 $ 1,837,921 $ 1,929,817 $ 2,026,308 $ 2,127,623 $ 2,234,004
Buy -In 10% $ 375,000 $ 1,301,250 $ 1,431,375 $ 1,574,513 $ 1,7351,9654 $ 1,905,160
Other Revenue 0% $ 204,521 $ 51,850 $ 51,850 $ 51,850 $ 51,850 $ 51,850
Total Revenue $ 7,337,899 $ 3,402,011 $ 3,607,727 $ 3,954,680 $ 4,105,012 $ 6,361,728
Personnel Expense 10% $ 270,908 $ 297,074 $ 326,781 $ 359,460 $ 395,405 $ 434,946
Operating Expense 8% $ 277,267 $ 239,685 $ 258,860 $ 279,569 $ 301,934 $ 326,089
Debt $ 905,474 $ 940,153 $ 936,186 $ 946,318 $ 1,007,994 $ 965,354
Transfers 0% $ 133,855 $ 156,164 $ 156,164 $ 156,164 $ 156,164 $ 156,164
Capital $ 5,701,905 $ 1,753,000 $ 1,824,351 $ 2,235,882 $ 310,717 $ 365,047
Total Expense $ 7,289,409 $ 3,386,076 $ 3,502,343 $ 3,977,392 $ 2,172,215 $ 2,247,599
Revenue over (Expense)
$ 48,490 $ 15,935 $ 105,384 $ (22,712) $ 1,932,798 $ 4,114,129
Connection Fees - Assumes a 10% increase each year in number of connections over FY06 budget and no increase in fees.
Service Revenue - Assumes a 5% increase each year from the previous year.
Buy -In - Assumes a 10% increase each year in number of connections over FY06 budget and no increase in fees.
Other Revenue - Assumes no significant change each year (starting with FY06 budget amount).
Personnel Expense - Assumes a 10% increase each year from the previous year (salaries & benefits on existing staff - no new employees).
Operating Expense - Assumes a 10% increase each year from the previous year. (4 year average - FY03 & FY04 actuals plus FY05 & FY06 budget).
Debt - Based on known debt payments each year plus annual payments of $123,101 for the DEQ loan ($1.8 million at 3.25% over 20 years).
Transfers - Assumes no significant change each year (4 year average - FY03 & FY04 actuals plus FY05 & FY06 budget).
East Storage Tank (1
Million Gallons -
Includes Pumps,
Transmission Lines,
and PRV's) 20%
12" Line on Boydstun
Street (Hwy 55 to Rio
Vista Blvd)
12" Line on Rio Vista
(Boydstun Street to
River Crossing) 20%
6" Line on Rio Vista
(Rowland Street to
Sunny Way) & Gabi
Lane 20%
8" Line on 3rd Street
(Floyde Street to
Park Street) 20%
6" Line on Davis
Avenue (Wanda
Avenue to Ruby
Street) 20%
12" Line on Spring
Mountain Boulevard
(connect the 12" line
from Majestic View
Drive to the 12" line
from Lick Creek
Road) 20%
10" Line on Hwy 55
(M Resorts to
Knowles Road) 20%
8" Line on Boydstun
Lane & Hayes Street
(Hwy 55 to Herrick
Street) 20%
6" Line on Louisa
Avenue (Pine Street
to Hemlock Street) 20%
8" Line on Miles
Standish Road
(University Lane to
Carico Road) 20%
6" Lines on Allen
Avenue, Timm
Street, & McGinnis
Street 20%
6" Line on
Saddlehorn Lane
(Baycolt Way to
Buckboard Way) 20%
West Storage Tank 20%
WhiteTail Oversize
Subdivision Oversize 20%
4" Line Replacement
Projects 20%
Truck & Chlorine
Analyzer
Equipment &
Vehicles 5%
Mapping 5%
TOTAL
Estimated Costs
FY01 FY05 FY06 FY07
4 5 6
$ 2,488,320
322,500
1,087,811
$ 1,597,501
$ 439,603
$ 646,963
$ 228,096
145,152
103,680
FY08
7
$ 1,031,956
$ 404,899
$ 533,894
FY09 FY10
8 9
103,680
$ 1,500,000
$ 100,000
$ 50,000 $ 60,000 $ 72,000 $ 86,400
90,000 $ 108,000 $ 129,600 $ 155,520 $ 186,624 $ 223,949
31,100
$ 30,000 $ 31,500 $ 33,075 $ 34,729 $ 36,465
15,000 $ 15,000 $ 15,750 $ 16,538 $ 17,364 $ 18,233
5,701,905 $ 1,753,000 $ 1,824,351 $ 2,235,882 $ 310,717 $ 365,047
Water Fund
FY05 FY06 FY07 FY08 FY09 FY10
Cash to Spend $ 3,142,977 $ 3,125,975 $ 134,296 $ 8,755 $ (65,594) $ 978,354
DEQ Loan $ 1,800,000 $ $ $ $ $ -
Connection Fees 10% $ 65,000 $ 162,500 $ 178,750 $ 196,625 $ 216,288 $ 237,916
Service Revenue 5% $ 1,750,401 $ 1,837,921 $ 1,929,817 $ 2,026,308 $ 2,127,623 $ 2,234,004
Buy -In 10% $ 375,000 $ 1,301,250 $ 1,431,375 $ 1,574,513 $ 1,7351,964 $ 1,905,160
Other Revenue 0% $ 204,521 $ 51,850 $ 51,850 $ 51,850 $ 51,850 $ 51,850
Total Revenue $ 7,337,899 $ 6,479,496 $ 3,726,088 $ 3,858,050 $ 4,062,130 $ 5,407,285
Personnel Expense 10% $ 270,908 $ 297,074 $ 326,781 $ 359,460 $ 395,405 $ 434,946
Operating Expense 8% $ 277,267 $ 239,685 $ 258,860 $ 279,569 $ 301,934 $ 326,089
Debt $ 905,474 $ 940,153 $ 936,186 $ 946,318 $ 1,007,994 $ 965,354
Transfers 0% $ 133,855 $ 156,164 $ 156,164 $ 156,164 $ 156,164 $ 156,164
Capital $ 2,624,420 $ 4,712,124 $ 2,039,342 $ 2,182,134 $ 1,222,278 $ 365,047
Total Expense $ 4,211,924 $ 6,345,200 $ 3,717,333 $ 3,923,644 $ 3,083,776 $ 2,247,599
Revenue over (Expense)
$ 3,125,975 $ 134,296 $ 8,755 $ (65,594) $ 978,354 $ 3,159,686
Connection Fees - Assumes a 10% increase each year in number of connections over FY06 budget and no increase in fees.
Service Revenue - Assumes a 5% increase each year from the previous year.
Buy -In - Assumes a 10% increase each year in number of connections over FY06 budget and no increase in fees.
Other Revenue - Assumes no significant change each year (starting with FY06 budget amount).
Personnel Expense - Assumes a 10% increase each year from the previous year (salaries & benefits on existing staff - no new employees).
Operating Expense - Assumes a 10% increase each year from the previous year. (4 year average - FY03 & FY04 actuals plus FY05 & FY06 budget).
Debt - Based on known debt payments each year plus annual payments of $123,101 for the DEQ loan ($1.8 million at 3.25% over 20 years).
Transfers - Assumes no significant change each year (4 year average - FY03 & FY04 actuals plus FY05 & FY06 budget).
East Storage Tank (1
Million Gallons -
Includes Pumps,
Transmission Lines,
and PRV's) 20%
12" Line on Boydstun
Street (Hwy 55 to Rio
Vista Blvd)
12" Line on Rio Vista
(Boydstun Street to
River Crossing) 20%
6" Line on Rio Vista
(Rowland Street to
Sunny Way) & Gabi
Lane 20%
8" Line on 3rd Street
(Floyde Street to
Park Street) 20%
6" Line on Davis
Avenue (Wanda
Avenue to Ruby
Street) 20%
12" Line on Spring
Mountain Boulevard
(connect the 12" line
from Majestic View
Drive to the 12" line
from Lick Creek
Road) 20%
10" Line on Hwy 55
(M Resorts to
Knowles Road) 20%
8" Line on Boydstun
Lane & Hayes Street
(Hwy 55 to Herrick
Street) 20%
6" Line on Louisa
Avenue (Pine Street
to Hemlock Street) 20%
8" Line on Miles
Standish Road
(University Lane to
Carico Road) 20%
6" Lines on Allen
Avenue, Timm
Street, & McGinnis
Street 20%
6" Line on
Saddlehorn Lane
(Baycolt Way to
Buckboard Way) 20%
West Storage Tank 20%
WhiteTail Oversize
Subdivision Oversize 20%
4" Line Replacement
Projects 20%
Truck & Chlorine
Analyzer
Equipment &
Vehicles 5%
Mapping 5%
TOTAL
Estimated Costs
FY01 FY05 FY06 FY07
4 5 6
$ 2,488,320
$ 90,000
$ 31,100
15,000
2,624,420
$ 322,500
$ 1,305,373
$ 776,356
$ 273,715
$ 281,180
$ 859,963
$ 209,019
$ 149,299
$ 444,912
FY08
7
$ 1,917,002
FY09 FY10
8 9
$ 911,561
$ 149,299
$ 1,500,000
$ 100,000
$ 50,000 $ 60,000 $ 72,000 $ 86,400
$ 108,000 $ 129,600 $ 155,520 $ 186,624 $ 223,949
$ 30,000 $ 31,500 $ 33,075 $ 34,729 $ 36,465
$ 15,000 $ 15,750 $ 16,538 $ 17,364 $ 18,233
$ 4,712,124 $ 2,039,342 $ 2,182,134 $ 1,222,278 $ 365,047