04-19-10 CC WS AgPCITY OF SHOREWOOD
CITY COUNCIL WORK SESSION
MONDAY, APRIL 19, 2010
09132M
55755 COUNTRY CLUB ROAD
CITY HALL
6:00 P.M.
� 41 �
B. Review Agenda
3. ROAD FINANCING
Mayor Liz6e _
Bailey_
Turgeon _
Woodruff
Zerby
Finance / Admin.
CAF
Administrator's CAF
4. ADJOURN
COUNCIL ACTION FORM
Department Council Meeting Item Number
Fina n ministration April 19 2010 �
Item Description: CIP Draft for Discussion
Attached is a first draft of the 2011-2015 Capital Improvement Plan (CIP) for discussion. The OPexhibits
in this draft include: Projects bvDepartment; Summary Sources and Uses uf Funds; Detail Sources and
Uses of Funds; Projects by Year.
A few notes regarding this CIP draft:
l. The Manor Park Shelter and the Silverwood Parksheke/estimates are revised per Building
Inspector Joe PazandaKsestimates.
Z. A public works vehicle lift has been included for year 3012.
3. Meadowview, Wild Rose and Nelsine street and storm water estimates have been revised per
the recent bids.
4. For now, this CIP shows transfers into the capital funds continuing at 2010 amounts.
Staff Recommendation
For council discussion.
Council Action:
1
2011- 2015 CAPITAL IMPROVEMENT PROGRAM
DISCUSSION DRAFT - April 15, 2010
4-
O
O
O
■
0
I
O
O
O
O
O
O
'J Q, Q,
Q 1 � o' — — — -1 1
O " - - c'! 'Ci I C
O
C�
V V
!�L! O O '2
CD c::i "li
C=i
o
o
- m O m m U7 c0
M CO
u: uj ut uw IL aj uj w w kL w L6 u, w LL dj U� L;j w aj Q5 w uL 12, uw d, dj LL
CL CD
U) U)
E
c C CO U) co — LL m a)
IN 0
0 2 LL
, 9 - 0
(D L 'o C,
2 2
U cD 0 0
IS IS
0 0 P
Ll- w c LL x � o cD
cf
C I I I
0 �:
0 CD m
0 0 0
0 0
U) <
O
:m
ray
� I
I
Q,
U-)
LO
m
Q,
d
d
d C
C
Q
CJ
Q,
C�
11,
O
Oi
d
QI
Q-1
11
Cy
O
Q,
C� 11
:6 uo
O2
::5 c,
r
2
c,
04
Z:
N
c
0
c q
czi
cD
cD
0
C)
CI L
C O
0
LO
cl7
00
0
o
ti
C14
C)
cD
0 0
4
C
m
n
04
cl: L
try
a,
m
�
C�t
cD
�2
m
co
cD
C)
cD
cD
O
o
cD
to
ID
cD
cD
0
c)
cD
0
cD
cl>
O
CWL
O
l zv�
O
c=1
cyi
O c0
M
1 ZL
C 3
cz)
cy,
■
U-)
LO
m
�2
V
w
O
Oi
O2
r
2
c,
04
Z:
N
0
c q
czi
cD
cD
0
C)
CI L
C O
0
LO
cl7
00
0
o
ti
C14
cD
0 0
4
C
m
n
04
cl: L
try
a,
m
�
C�t
cD
�2
m
co
cD
C)
cD
cD
O
o
cD
to
cD
cD
0
c)
cD
0
cD
cl>
O
CWL
O
l zv�
O
c=1
1 ZL
C 3
'F
C 9
1 9
2
ZO
�
�
tr
o
cj
CJ
0
U
m
E
Z5
o
o
o
m
w
cj
2
2
w
m
o)
cj
I
E
t
o
CC
E
m
m
E
u)
C�
0
W
<D
o
c)
cj
ID
E
0
m
E
o
m
o
m
m
rl
6
C—
. 6
u
E
E
76
o
cr
>
- 2
o
G-
u-
C
o
lY
D
cf)
3 :
v
CJ
o
o
m o
o
7m
3:
m
0�
—
0
o
E
� @
v
^
QD
G
G
G
m
J
o
o
0
o
cl�
Fj
c
�j
o
o
m
Cl
Ez
ID
- T
2
3:
3:
3:
<
cr,
7
■
.
1�
Q,
Q,
C, C5
Ch
C3
I
C�
Q, ��
1�
O
Q,
1-1
O
1�
C�
Q,
a
lz�
o
C,
Q,
Q
Q,
-t�
c, Z3
-6
CD
C)
CD
cz_
C=i
cli
C14
O
CD
W)
C)
C:�
11"i
10
O
O
lz�
Ci
CD
to
rl.:,
CN
co
r—
C4
C) C)
0
0
cD
cD
cD
cD
CD
cD
0
I n
0
c:i
0
0
c:l
c)
0
cD
O
O
O
O
cD O
O
cD
C)
cm)
(D
C)
O
cD
C)
cD
C)
ID
6
O
ID
CD
O
O
O
CD
C�
Lo
lz�i
cl i
'Zi
( =i
Ci
�
- e
- 2f
- 2
- c
- a
- e
- I'z
- c
d
c
c
c
c
c
c
1 � 1
O.,
4
Q,
d-
d
c1. O.
d-
d-
cL
C;
Q.
d cL
R
R.
cL
[L
QL
QL
QL
d
d
R
cL
cL
L
O
cr
C
m
Itz
—
E
2
o
o
L.
CJ
U
—
.9)
N
4J
O
c ',
-o
*o
D
C)�
M
o-
cz
"
<
—
,
w
- 2
—
�
o
—
c,
w l
F.
w
m
o
w
C O
E
C D
cc
fr
E
C O
O
C
L
u)
Q
0
17;
m
o•
E
Q
—
0��
a
o E
w
E
E_
w
-a
u
W
w
d'
L
O
-S
0
w
c/)
o
(Z
Q-
—
co
o-
o
o
N
(G
(D
CD
o
o
o
o
G-
cl
c2 E
U
w
- rE
7� m
C6
65
cf)
cr) m
V)
c,-) L
co
U) u
u
u
LT
m
m
m
co
(f)
C-)
�
G
U)
Lij
a-
umu
8-
■
C-I 11 o
"I
c�
ILI
CD
cD
co
C)
ID ID
O cn
O
CD
Cl
Cl
CD
C)
C
O
CD
r--
ID
t
C'I�
N O V
O
C)
(D
m
m
m
CD
C)
O
CD
m
CD
w
N
co
CD
ID
, I *
M
M
ID
ci
C
I
M
ID
CD
CN
m
V'
m
- a
- e
i!
—
—
—
—
—
—
—
—
—
—
—
—
—
—
—
—
—
1
CJ
0
0
m
0
o
t:�
0
cr
m
W
K
0
0
4.
cd
CL
o
E
Q)
cr�
u)
m
CC
lo
u)
u-I
u)
m
c )
W
u)
7U
m
v
w
a)
it
ID
cr
of
E
ol
cu
(D
o
u)
E
E
o
'o
u)
o
EL
c!�
a--
E
m
ts
w
V)
is
o
o-
a:
a-
Z5
<
u
,
ID
r,
o
o
.22
o
C)
w
- ,E
Lu
o
Q�:
-�=
r
L
,
ll�
w
a,
Q
,
E
m
c73
o
Cr
§
=
ifJ
(/)
--
CO
:4
J5
E5
■
Q,
C-1
.0 1-)
cv
o
C=l
C
Cl)
CL
C,4
r—
c
CN
O
O
to
Cl i
M
Ay
cl�
OL
C: �
U"y
Cl i
CD
ID
1=1
C::,
�-t
CD
I =L
C::
Cl i
In
co
C)
10
P
CD
C,
cn.
CIZ
OD
CD
O
CD
lD
a)
Iri
CD
Ci
LO
CD
0
C>
C
.
6
61
Cd
C4
C
0
0
u
1 7:
(1)
(D
0
c,
Cd
Cd
Cd
Cd
Source 2010 2011 2012 2013 2014
Equipment Replacement Fund
Beginnin Balance
Beginning
g
841,026
740,087
598,661
487,341
373,786
Revenues and Other Fund Sources
700,000
700,000
700,000
1,785,023
1,645,867
Total Revenues and Other Fund Sources
100,000
100,000
100,000
100,000
100,000
Total Funds Available
941,026
840,087
698,661
587,341
473,786
Expenditures and Uses
Total Expenditures and Uses
(200,939)
(241,426)
(211,320)
(213,555)
(171,514)
Change in Fund Balance
Ending Balance
Source
(100,939) (141,426) (111,320) (113,555) (71,514)
740,087 598,661 487,341 373,786 302,272
2010 2011 2012 2013 2014
Local Street Reconstruction
Beginning Balance
Revenues and Other Fund Sources
Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
1,085,023
945,867
650,037
(131,313)
(202,797)
700,000
700,000
700,000
700,000
700,000
1,785,023
1,645,867
1,350,037
568,687
497,203
(839,156) (995,830) (1,481,350) (771,484) (903,435)
(139,156) (295,830) (781,350) (71,484) (203,435)
945,867 650,037 (131,313) (202,797) (406,232)
Source 2010 2011 2012 2013 2014
Municipal Water Fund
Beginning Balance
3,446,747
3,346,747
3,056,747
2,784,747
2,084,747
Revenues and Other Fund Sources
Total Revenues and Other Fund Sources
0
0
0
0
0
Total Funds Available
3,446,747
3,346,747
3,056,747
2,784,747
2,084,747
Expenditures and Uses
Total Expenditures and Uses
(100,000)
(290,000)
(272,000)
(700,000)
(340,000)
Change in Fund Balance
Ending Balance
Source
(100,000) (290,000) (272,000) (700,000) (340,000)
3,346,747 3,056,747 2,784,747 2,084,747 1,744,747
2010 2011 2012 2013 2014
Park Fund
Beginning Balance
Revenues and Other Fund Sources
Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
292,424 158,624 38,924 25,159 45,159
42.000 42,000 42,000 42,000 42,000
334,424 200,624 80,924 67,159 87,159
(175,800) (161,700) (55,765) (22,000) (50,000)
(133,800) (119,700) (13,765) 20,000 (8,000)
158,624 38,924 25,159 45,159 37,159
0
Source
2010
2011
2012
2013
2014
Public Facilities Fund
Source
2010
2011
Be innin Balance
LI L,
227,287
205,287
200,287
150,287
150,287
Revenues and Other Fund Sources
Beginning Balance
b t,
3,674,369
3,313,846
Total Revenues and Other Fund Sources
0
0
0
0
0
Total Funds Available
227,287
205,287
200,287
150,287
150,287
E xpenditures and Uses
0
0
Total Funds Available
3,734,369
3,313,846
Total Expenditures and Uses
(22,000)
(5,000)
(50,000)
0
0
Change in Fund Balance (22,000) (5,000) (50,000) 0 0
Ending Balance
205,287
200,287
150,287
150,287
150,287
Source
2010
2011
2012
2013
2014
,Sanitary Sewer Fund
Beginning Balance
b t,
3,674,369
3,313,846
3,118,846
2,923,846
2,783,846
Revenues and Other Fund Sources
Total Revenues and Other Fund Sources
60,000
0
0
0
0
Total Funds Available
3,734,369
3,313,846
3,118,846
2,923,846
2,783,846
Expenditures and Uses
Total Expenditures and Uses
(420,523)
(195,000)
(195,000)
(140,000)
(70,000)
Change in Fund Balance
Ending Balance
(360.523) (195,000) (195,000) (140,000) (70,000)
3,313,846 3,118,846 2,923,846 2,783,846 2,713,846
I
Source
2010 2011 2012 20,13 - 1- 2014
608,946
363,348
207,585
139,820
(198,394)
0
0
0
0
0
608,946
363,348
207,585
139,820
(198,394)
(245,598)
(155,763)
(67,765)
(338,214)
(402,028)
Change in Fund Balance
Ending Balance
Source
(245,598) (155,763) (67.765) (338,214) (402,028)
363,348 207,585 139,820 (198,394) (600,422)
2010 2011 2012 2013 2014
Technology /Office Equipment Fun
I
Beginning Balance
Revenues and Other Fund Sources
Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
104,337 74,337 64,337 49,337 39,337
0 0 0 0 0
104,337 74,337 64,337 49,337 39,337
(30,000) (10,000) (15,000) (10,000) (10,000)
(30,000) (10,000) (15,000) (10,000) (10,000)
74,337 64,337 49,337 39,337 29,337
a
City of Shorewood, Minnesota
(_"appal Improven Pro
2010 thru 2014
SOURCES N USES OF FUNDS
Source 2010 2011 2012 2013 2014
Equipment Repiaeeitueut Fund
Beginning Balance 841,026 740,087 598,661 487,341 373,786
Revenues and Other Fund Sources
Other Fund Sources
Transfers In
100,000 100,000 100,000 100,000 100,000
Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Capital Projects & Equipment
Equipment Replacement
Blower Attachment - Skid Steer
Broom Attachment - Skid Steer
Tractor - Ford 3910
Sweeper - Tennant 240
Flatbed - 4 x 2 F350
Skid Steer - Bobcat 753
Groundsmaster Mower- Toro 328D
Attach - Flail rear mower Ag tractor
Attach - Flail side mower Ag Tractor
Track Excavator
Dump Truck - Ford L8000 (1988)
Trailer 24' - Trail King
Trailer 12' Tops
Sand Pro 3000
Dump Truck - Ford
Mower - Toro Groundmaster 328D
Mower - Toro Walk Behind Proline 44
Air Compressor - Ingersoll Rand 185
Dump Truck
Pick -up - 4 x 4 Ford F150
Attach - two (2) Cabs for Groundmaster
Mower - Toro Groundsmaster 325D
Ford F450 Utility Truck - with crane & toolbox
Total 100,000 100,000 100,000 100,000 100,000
100,000 100,000 100,000 100,000 100,000
941,026 840,087 698,661 587,341 473,786
E -10 -100
(5,200)
0
0
0
0
E -10 -101
(2,932)
0
0
0
0
E -10 -35
(45, 631)
0
0
0
0
E -10 -46
(21,638)
0
0
0
0
E -10 -49
(45,369)
0
0
0
0
E -10 -63
(28,519)
0
0
0
0
E -10 -75
(24,429)
0
0
0
0
E -10 -93
(9,353)
0
0
0
0
E -10 -94
(17,868)
0
0
0
0
E -11 -22
0
(100,000)
0
0
0
E -11 -33
0
(141,426)
0
0
0
E -12 -21
0
0
(15,017)
0
0
E -12 -41
0
0
(3,716)
0
0
E -12 -64
0
0
(13,159)
0
0
E -12 -68
0
0
(148,930)
0
0
E -12 -84
0
0
(27,092)
0
0
E -12 -95
0
0
(3,406)
0
0
E -13 -38
0
0
0
(12,715)
0
E -13 -65
0
0
0
(156,824)
0
E -13 -78
0
0
0
(30,974)
0
E -13 -90
0
0
0
(13,042)
0
E -14 -70
0
0
0
0
(27,464)
E -14 -76
0
0
0
0
(97,842)
11
Source
2010
2011
2012
2013
2014
Equipment Replacement Fmid
740,087
598,661
487,341
Dodge Grand Caravan E-14-77
0
0
0
0
(23,688)
Attach-Two (2) Blowers for Grndsmstr (1972 & 200 E-14-89
0
0
0
0
(15,654)
Attach-Cab for Groundsmaster (1985) E-14-92
0
0
0
0
(6,866)
Tule71
(200,939)
(241,426)
(211,320)
(213,555)
(171,514)
Total ExpenditUITS and USeS
(200,939)
(241,426)
(211,320)
(213,555)
(171,514)
Change in Fund Balance
(100,939)
(141,426)
(111,320)
(113,555)
(71,514)
740,087
598,661
487,341
373,786
302,272
12
Sou rce
20
2
2012
2013
2014
Local Street Reconstruction
700,000
700,000
1,350,037
Local Street Reconstruction
700,000
700,000
497,203
Smithtown Lane - Reclaim
LR -10 -01
Meadowview Road - Reconstruct
Beginning; Balance
1,085,023
945,867
650,037
(131,313)
(202,797)
Revenues and Other Fund Sources
Vine Hill Road: Mill & Overlay (Shorewood portion)
LR -11 -02
Valleywood Circle & Lane - Reconstruct
LR -12 -01
Afton Rd - Reclaim
Other 1=1111d Sources
Sunnyvale Lane - Reclaim
LR -13 -02
Club Valley - Reclaim
LR -14 -01
Lake Virginia Drive - Reclaim
Transfers In
700,000
700,000
700,000
700,000
700,000
No Funds
0
0
0
0
0
Tolol
Total Revenues and Other Fund Sources
0
Total Fends available
0
Expenditures and Uses
700,000
700,000
1,785,023
Capital Projects & Equipment
700,000
700,000
1,350,037
Local Street Reconstruction
700,000
700,000
497,203
Smithtown Lane - Reclaim
LR -10 -01
Meadowview Road - Reconstruct
LR- 10 -02 -A
Wild Rose Segment- Reconstruct
LR- 10 -02 -B
Nelsine Drive - Reclaim
LR -10 -05
Star Roads (Circle & Lane)- Reconstruct
LR -11 -01
Vine Hill Road: Mill & Overlay (Shorewood portion)
LR -11 -02
Valleywood Circle & Lane - Reconstruct
LR -12 -01
Afton Rd - Reclaim
LR -13 -01
Sunnyvale Lane - Reclaim
LR -13 -02
Club Valley - Reclaim
LR -14 -01
Lake Virginia Drive - Reclaim
LR -14 -02
Maintenance- Bituminous Sealcoating
LR -99 -100
Maintenance - Bituminous Overlays
LR -99 -99
0
Total
Total Expenditures and Uses
Change in Fund Balance
(65,156)
0
0
0
0
700,000
700,000
1,785,023
700,000
700,000
1,645,867
700,000
700,000
1,350,037
700,000
700,000
568,687
700,000
700,000
497,203
(65,156)
0
0
0
0
(218, 000)
0
0
0
0
(106,000)
0
0
0
0
(64, 000)
0
0
0
0
0
(593, 989)
0
0
0
0
(176,741)
0
0
0
0
0
(1,055,850)
0
0
0
0
0
(196,013)
0
0
0
0
(128,696)
0
0
0
0
0
(135,130)
0
0
0
0
(299,191)
(214,400)
(225,100)
(236,300)
(248,115)
(260,521)
(171,600)
0
(189,200)
(198,660)
(208,593)
(839,156) (995,830) (1,481,350) (771,484) (903,435)
(839,156) (995,830) (1,481,350) (771,484) (903,435)
(139,156) (295,830) (781,350) (71,484) (203,435)
Ending Balance 945,867 650,037 (131,313) (202,797) (406,232)
13
Source 1-010 2011 201.2 201.E 2014
Municipal Water Fund
Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Capital Projects cF Equipment
Municioal Water System
RadiollSP Communications System
Reroof SE Area Water Treatment Plant
Water Main - Meadowview Road
Water Main - Wild Rose Segment
Water Main - Nelsine Drive
SE Area Water Plant Control System
Water Main - Star Circle & Lane
Water Main - Valleywood Circle & Lane
Water Main - Afton
Water Main - Sunnyvale Lane
W. Water Tower - Rehab & Painting
Water Main - Club Valley
Water Main - Lake Virginia Drive
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
Total 0
0
0
0
0
0
0
0
0
0
3,446,747
3,346,747
3,056,747
2,784,747
2,084,747
W -10 -01
(75,000)
0
0
0
0
W -10 -02
(25,000)
0
0
0
0
W- 10 -03 -A
0
0
0
0
0
W- 10 -03 -8
0
0
0
0
0
W -10 -04
0
0
0
0
0
W -11 -01
0
(160,000)
0
0
0
W -11 -02
0
(130,000)
0
0
0
W -12 -01
0
0
(272,000)
0
0
W -13 -01
0
0
0
(150,000)
0
W -13 -02
0
0
0
(100,000)
0
W -13 -03
0
0
0
(450,000)
0
W -14 -01
0
0
0
0
(100,000)
W -14 -02
0
0
0
0
(240,000)
"Total (100,000) (290,000) (272,000) (700,000) (340,000)
(100,000) (290,000) (272,000) (700,000) (340,000)
(100,000) (290,000) (272,000) (700,000) (340,000)
3,346,747 3,056,747 2,784,747 2,084,747 1,744,747
14
Source
2010 2011 2012 2013 0 1
292,424 158,624 38,924 25,159 45,159
Total
'Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Capital Prqjects & Equipment
42,000
Parks
42,000
Silverwood Park- Bituminous Parking Lot
P -10 -01
Silverwood Park - Picnic Shelter Canopy
P -10 -02
Signage - Tennis Court Signs
P -10 -03
Badger Park - Tennis Court Resurface
P -10 -04
Manor Park Shelter Building Addition
P -10 -10
All Parks - Tot Lot Equipment
P -10 -12
Skate Park - Drinking Fountain
P -10 -13
Skate Park- Community Garden Sign & Fence
P -10 -14
Skate Park -Rehab
P -10 -15
Signage -All parks & entry points
P -11 -01
Cathcart Park - Replace Hockey Rink Lights
P -11 -03
Cathcart Park -Swing Set Replacement
P -11 -04
Cathcart Park - New Rink Boards
P -11 -05
Freeman Park - Picnic Shelter Re -roof
P -11 -06
Freeman Park- Rink/Open Skate
P -11 -07
Badger Park - Warming House Rehab
P -11 -08
Badger Park - Install Rustic Trail
P -12 -03
Badger Park- Overlook/benches
P -12 -04
Silverwood Park-Equipment (slide, benches)
P -12 -05
Silverwood Park - Resurface 1/2 court
P -12 -06
Manor Park - Resurface Tennis Courts
P -12 -07
Cathcart Park - Resurface tennis Courts
P -12 -08
Skate Park - Shelter
P -13 -04
Manor Park - Equipment Replacement
P -14 -01
Picnic Tables
P -99 -99
0
Total
Total Expenditures and Uses
42,000 42,000 42,000 42,000 42,000
42,000
42,000
42,000
42,000
42,000
42,000
42,000
42,000
42,000
42,000
334,424
200,624
80,924
67,159
87,159
(22,000)
0
0
0
0
(22,000)
0
0
0
0
(750)
0
0
0
0
(10,000)
0
0
(6,000)
0
(85,000)
0
0
0
0
(12,000)
0
(12,000)
0
0
(7,500)
0
0
0
0
(5,200)
0
0
0
0
(4,350)
0
0
0
0
0
(30,000)
0
0
0
0
(50,000)
0
0
0
0
(2,500)
0
0
0
0
(15,000)
0
0
0
0
(2,200)
0
0
0
0
(50,000)
0
0
0
0
(5,000)
0
0
0
0
0
(7,500)
0
0
0
0
(7,500)
0
0
0
0
(7,765)
0
0
0
0
(2,000)
0
0
0
0
(6,000)
0
0
0
0
(6,000)
0
0
0
0
0
(16,000)
0
0
0
0
0
(50, 000)
(7,000)
(7,000)
(7,000)
0
0
(175,800) (161,700) (55,765) (22,000) (50,000)
(175,800) (161,700) (55,765) (22,000) (50,000)
15
Source
2010
2011
2012
2013
2014
0
0
0
0
227,287
205,287
Park Fund
150,287
150,287
Change in Fund Balance
(133,800)
(119,700)
(13,765)
20,000
(8,000)
Ending Balance
158,624
38,924
25,159
45,159
37,159
Source
2010
2011
2012
2013
2014
227,287 205,287 200,287 150,287 150,287
No Funds
Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Capital Projects & Equipment
Public Facilities
PW Facility - Roofing
City Hall Facility - Parking Lights
Public Works-Vehicle Lift
5795 Country Club-Residence
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
0 0 0 0 0
7'otal 0
0
0
0
0
0
0
0
0
0
227,287
205,287
200,287
150,287
150,287
PF-10-01
PF-10-03
PF-12-01
PF-99-99
Total
(10,000) 0 0 0 0
(7,000) 0 0 0 0
0 0 (50,000) 0 0
(5,000) (5,000) 0 0 0
(22,000) (5,000) (50,000) 0 0
(22,000) (5,000) (50,000) 0 0
(22,000) (5,000) (50,000) 0 0
205,287 200,287 150,287 150,287 150,287
16
Total Revenues and tither Fund Sources
Total Finds Available
Expenditures and Uses
Capital Projects & Equipment
Sanitary Sewer
Lift Station 15 Rehab -4360 Enchanted Dr.
Lift Station 17 Rehab -5295 Shady Island Rd
Meadowview Rd Sewer
Wild Rose Segment Sewer
Nelsine Dr Sewer
Smithtown Lane Sewer
Purchase Video Camera
Radio /ISP Communications - Lift Stations
Lift Station 5 Rehab - 27135 Edgewood
Lift Station 6 Rehab 27950 Smithtown Rd.
Lift Station 11 Rehab - 20465 Radisson Rd.
Infiltration and Inflow Reduction
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
Total 60,000
0
0
0
0
60,000
0
0
0
0
3,734,369
3,313,846
3,118,846
2,923,846
2,783,846
SS -08 -06
SS -09 -01
SS- 10 -01 -A
SS- 10 -01 -B
SS -10 -02
SS -10 -06
SS -10 -09
SS -10 -10
SS -11 -01
SS -12 -01
SS -13 -01
SS -99 -05
Total
(200,000)
0
0
0
0
(78,000)
0
0
0
0
(14,439)
0
0
0
0
(2,959)
0
0
0
0
(2,959)
0
0
0
0
(2,166)
0
0
0
0
(10,000)
0
0
0
0
(40, 000)
(40, 000)
(40, 000)
0
0
0
(85, 000)
0
0
0
0
0
(85, 000)
0
0
0
0
0
(70,000)
0
(70,000)
(70,000)
(70,000)
(70,000)
(70,000)
(420,523) (195,000) (195,000) (140,000) (70,000)
(420,523) (195,000) (195,000) (140,000) (70,000)
(360,523) (195,000) (195,000) (140,000) (70,000)
3,313,846 3,118,846 2,923,846 2,783,846 2,713,846
17
IN
Total
0
0
0
0
0
"Total Revenues and Other Fund Sources
0
0
0
0
0
Total Funds Available
608,946
363,348
207,585
139,820
(198,394)
Expenditures and Uses
Capital Projects & Equipment
Stormwater Management
Meadowview Rd Storm
STM- 10 -01 -A
(49,736)
0
0
0
0
Wild Rose Segment
STM- 10 -01 -B
(24,868)
0
0
0
0
Nelsine Dr Drainage
STM -10 -02
(36,352)
0
0
0
0
6180 Murray Drainage - WSB Report
STM -10 -03
(34,178)
0
0
0
0
5925 Grant Drainage - WSB Report
STM -10 -04
(46,305)
0
0
0
0
5830 Echo Rd Drainage - WSB Report
STM -10 -05
(33,075)
0
0
0
0
Smithtown Lane
STM -10 -06
(21,084)
0
0
0
0
Manor Park Pond - Rehabilitation
STM -10 -07
0
0
0
0
0
Vine Hill Road Stormwater
STM -11 -01
0
(40,000)
0
0
0
Star Circle & Lane - Stormwater
STM -12 -02
0
(84, 507)
0
0
0
22015 Stratford PI Drainage - WSB Report
STM -12 -03
0
(31,256)
0
0
0
Lake South Auto Drainage - WSB Report
STM -12 -05
0
0
(23,095)
0
0
Valleywood Circle & Lane - Drainage
STM -12 -08
0
0
(44,670)
0
0
Boulder Bridge Pond (To be Assessed)
STM -12 -10
0
0
0
0
0
Afton Rd Drainage
STM -13 -01
0
0
0
(146,772)
0
Sunnyvale Lane Drainage
STM -13 -02
0
0
0
(191,442)
0
Club Valley Drainage
STM -14 -01
0
0
0
0
(100,507)
Lake Virginia Drive Drainage
STM -14 -02
0
0
0
0
(282, 760)
6120 Riviera Drainage - WSB Report
STM -14 -04
0
0
0
0
(18,761)
Total
(245,598)
(155,763)
(67,765)
(338,214)
(402,028)
Total Expenditures and Uses
(245,598)
(155,763)
(67,765)
(338,214)
(402,028)
Change in Fund Balance
(245,598)
(155,763)
(67,765)
(338,214)
(402,028)
Ending Balance
363,348
207,585
1 39,820
(198,394)
(600,422)
IN
Source 2111£1 2011 2012 2013 2014
Technology/Office Equipment Fun
Total Revenues and Other Fund Sources
Total Funds Available
Expenditures and Uses
Capital Prqjects &- Equipment
Tech nology/Office Equip
City Hall Copier & Maintenance Contract
City Council Laptop Computers (5)
Computer Upgrades
Total Expenditures and Uses
Change in Fund Balance
Ending Balance
Total 0
0
0
0
0
0
0
0
0
0
104,337
74,337
64,337
49,337
39,337
T-10-02
T-12-01
T-99-99
Total
(20,000)
0
0
0
0
0
0
(5,000)
0
0
(10,000)
(10,000)
(10,000)
(10,000)
(10,000)
(30,000) (10,000) (15,000) (10,000) (10,000)
(30,000) (10,000) (15,000) (10,000) (10,000)
(30,000) (10,000) (15,000) (10,000) (10,000)
74,337 64,337 49,337 39,337 29,337
City of Shorewood, Miruriesota
ID
2010 ti,rL, 2014
PROJECT'S ' YEAR
Project Name Depat Project # Pl iarit } Project Cost
2010
Blower Attachment - Skid Steer
Equipment Replacement
E -10 -100
n/a
5,200
Broom Attachment - Skid Steer
Equipment Replacement
E -10 -101
n/a
2,932
Tractor - Ford 3910
Equipment Replacement
E -10 -35
n/a
45,631
Sweeper - Tennant 240
Equipment Replacement
E -10 -46
n/a
21,638
Flatbed - 4 x 2 F350
Equipment Replacement
E -10 -49
n/a
45,369
Skid Steer - Bobcat 753
Equipment Replacement
E -10 -63
n/a
28,519
Groundsmaster Mower- Toro 328D
Equipment Replacement
E -10 -75
n/a
24,429
Attach - Flail rear mower Ag tractor
Equipment Replacement
E -10 -93
n/a
9,353
Attach - Flail side mower Ag Tractor
Equipment Replacement
E -10 -94
n/a
17,868
Smithtown Lane - Reclaim
Local Street Reconstruction
LR -10 -01
1
65,156
Meadowview Road- Reconstruct
Local Street Reconstruction
LR- 10 -02 -A
1
218,000
Wild Rose Segment- Reconstruct
Local Street Reconstruction
LR- 10 -02 -B
1
106,000
Nelsine Drive - Reclaim
Local Street Reconstruction
LR -10 -05
1
64,000
Maintenance - Bituminous Sealcoating
Local Street Reconstruction:
LR -99 -100
n/a
214,400
Maintenance - Bituminous Overlays
Local Street Reconstruction
LR -99 -99
n/a
171,600
Radio /ISP Communications System
Municipal Water System
W -10 -01
n/a
75,000
Reroof SE Area Water Treatment Plant
Municipal Water System
W -10 -02
n/a
25,000
Water Main - Meadowview Road
Municipal Water System
W- 10 -03 -A
n/a
0
Water Main - Wild Rose Segment
Municipal Water System
W- 10 -03 -B
n/a
0
Water Main - Nelsine Drive
Municipal Water System
W -10 -04
n/a
0
Silverwood Park- Bituminous Parking Lot
Parks
P -10 -01
n/a
22,000
Silverwood Park - Picnic Shelter Canopy
Parks
P -10 -02
n/a
22,000
Signage - Tennis Court Signs
Parks
P -10 -03
n/a
750
Badger Park - Tennis Court Resurface
Parks
P -10 -04
n/a
10,000
Manor Park Shelter Building Addition
Parks
P -10 -10
n/a
85,000
All Parks - Tot Lot Equipment
Parks
P -10 -12
n/a
12,000
Skate Park - Drinking Fountain
Parks
P -10 -13
n/a
7,500
Skate Park- Community Garden Sign & Fence
Parks
P -10 -14
n/a
5,200
Skate Park -Rehab
Parks
P -10 -15
n/a
4,350
Picnic Tables
Parks
P -99 -99
n/a
7,000
PW Facility - Roofing
Public Facilities
PF -10 -01
n/a
10,000
City Hall Facility - Parking Lights
Public Facilities
PF -10 -03
n/a
7,000
5795 Country Club- Residence
Public Facilities
PF -99 -99
n/a
5,000
Lift Station 15 Rehab -4360 Enchanted Dr.
Sanitary Sewer
SS -08 -06
n/a
200,000
Lift Station 17 Rehab -5295 Shady Island Rd
Sanitary Sewer
SS -09 -01
n/a
78,000
Meadowview Rd Sewer
Sanitary Sewer
SS- 10 -01 -A
n/a
14,439
Wild Rose Segment Sewer
Sanitary Sewer
SS- 10 -01 -B
n/a
2,959
Nelsine Dr Sewer
Sanitary Sewer
SS -10 -02
n/a
2,959
Smithtown Lane Sewer
Sanitary Sewer
SS -10 -06
n/a
2,166
Purchase Video Camera
Sanitary Sewer
SS -10 -09
n/a
10,000
Radio /ISP Communications - Lift Stations
Sanitary Sewer
SS -10 -10
n/a
40,000
Infiltration and Inflow Reduction
Sanitary Sewer
SS -99 -05
n/a
70,000
Meadowview Rd Storm
Stormwater Management
STM- 10 -01 -A
1
49,736
Project N artte Departrraent PI - 0jecrt # Pr°iolity Project Cost
Wild Rose Segment
Stormwater Management
STNi- 10 -01 -8 1
24,868
Neisine Dr Drainage
Stormwater Management
STM -10 -02 1
36,352
6180 Murray Drainage - WSB Report
Stormwater Management
STM- 10 -03 1
34,178
5925 Grant Drainage - WSB Report
Stormwater Management
STM -10 -04 1
46,305
5830 Echo Rd Drainage - WSB Report
Stormwater Management
STM -10 -05 1
33,075
Smithtown Lane
Stormwater Management
STM -10 -06 1
21,084
Manor Park Pond - Rehabilitation
Stormwater Management
STM -10 -07 1
0
City Hall Copier & Maintenance Contract
Technology /Office Equip
T -10 -02 nla
20,000
Computer Upgrades
Technology /Office Equip
T -99 -99 nla
10,000
21
Total f'or 2010
2,034,016
2011
Track Excavator
Equipment Replacement
E -11 -22
n/a
100,000
Dump Truck- Ford L8000 (1988)
Equipment Replacement
E -11 -33
n/a
141,426
Star Roads (Circle & Lane)- Reconstruct
Local Street Reconstruction
LR -11 -01
1
593,989
Vine Hill Road: Mill & Overlay (Shorewood portion)
Local Street Reconstruction
LR -11 -02
1
176,741
Maintenance - Bituminous Sealcoating
Local Street Reconstruction
LR -99 -100
n/a
225,100
Maintenance - Bituminous Overlays
Local Street Reconstruction
LR -99 -99
n/a
0
SE Area Water Plant Control System
Municipal Water System
W -11 -01
n/a
160,000
Water Main - Star Circle & Lane
Municipal Water System
W -11 -02
n/a
130,000
Signage - All parks & entry points
Parks
P -11 -01
n/a
30,000
Cathcart Park - Replace Hockey Rink Lights
Parks
P -11 -03
n/a
50,000
Cathcart Park -Swing Set Replacement
Parks
P -11 -04
n/a
2,500
Cathcart Park - New Rink Boards
Parks
P -11 -05
n/a
15,000
Freeman Park - Picnic Shelter Re -roof
Parks
P -11 -06
n/a
2,200
Freeman Park - Rink/Open Skate
Parks
P -11 -07
n/a
50,000
Badger Park - Warming House Rehab
Parks
P -11 -08
n/a
5,000
Picnic Tables
Parks
P -99 -99
n/a
7,000
5795 Country Club- Residence
Public Facilities
PF -99 -99
n/a
5,000
Radio /ISP Communications - Lift Stations
Sanitary Sewer
SS -10 -10
n/a
40,000
Lift Station 5 Rehab - 27135 Edgewood
Sanitary Sewer
SS -11 -01
n/a
85,000
Infiltration and Inflow Reduction
Sanitary Sewer
SS -99 -05
n/a
70,000
Vine Hill Road Stormwater
Stormwater Management
STM -11 -01
1
40,000
Star Circle & Lane - Stormwater
Stormwater Management
STM -12 -02
1
84,507
22015 Strafford PI Drainage - WSB Report
Stormwater Management
STM -12 -03
1
31,256
Computer Upgrades
Technology /Office Equip
T -99 -99
n/a
10,000
Total for 2011
2,054,719
2012
Trailer 24' - Trail King
Equipment Replacement
E -12 -21
n/a
15,017
Trailer 12' Tops
Equipment Replacement
E -12 -41
n/a
3,716
Sand Pro 3000
Equipment Replacement
E -12 -64
n/a
13,159
Dump Truck - Ford
Equipment Replacement
E -12 -68
n/a
148,930
Mower - Toro Groundmaster 328D
Equipment Replacement
E -12 -84
n/a
27,092
Mower - Toro Walk Behind Proline 44
Equipment Replacement
E -12 -95
n/a
3,406
Valleywood Circle & Lane - Reconstruct
Local Street Reconstruction
LR -12 -01
1
1,055,850
Maintenance - Bituminous Sealcoating
Local Street Reconstruction
LR -99 -100
n/a
236,300
Maintenance- Bituminous Overlays
Local Street Reconstruction
LR -99 -99
n/a
189,200
Water Main - Valleywood Circle & Lane
Municipal Water System
W -12 -01
n/a
272,000
All Parks - Tot Lot Equipment
Parks
P -10 -12
n/a
12,000
Badger Park - install Rustic Trail
Parks
P -12 -03
n/a
7,500
Badger Park- Overlook/benches
Parks
P -12 -04
n/a
7,500
Silverwood Park - Equipment (slide, benches)
Parks
P -12 -05
n/a
7,765
21
PrG]ect Naioe Departrtie€xt Project 4 Prioritv Project Cost
Silverwood Park- Resurface 1/2 court
Parks
P -12 -06
n/a
2,000
Manor Park - Resurface Tennis Courts
Parks
P -12 -07
n/a
6,000
Cathcart Park - Resurface tennis Courts
Parks
P -12 -08
n/a
6.000
Picnic Tables
Parks
P -99 -99
n/a
7,000
Public Works - Vehicle lift
Public Facilities
PF -12 -01
n/a
50,000
Radio /ISP Communications - Lift Stations
Sanitary Sewer
SS -10 -10
n/a
40,000
Lift Station 6 Rehab - 27950 Smithtown Rd,
Sanitary Sewer
SS -12 -01
n/a
85,000
Infiltration and Inflow Reduction
Sanitary Sewer
SS -99 -05
n/a
70,000
Lake South Auto Drainage - WSB Report
Stormwater Management
STM -12 -05
1
23,095
Valleywood Circle & Lane - Drainage
Stormwater Management
STM -12 -08
1
44,670
Boulder Bridge Pond (To be Assessed)
Stormwater Management
STM -12 -10
nla
0
City Council Laptop Computers (5)
Technology /Office Equip
T -12 -01
n/a
5,000
Computer Upgrades
Technology /Office Equip
T -99 -99
n/a
10,000
22
'1 - otal for 2012
2,348,200
2013
Air Compressor- Ingersoll Rand 185
Equipment Replacement
E -13 -38
n/a
12,715
Dump Truck
Equipment Replacement
E -13 -65
n/a
156,824
Pick -up - 4 x 4 Ford F150
Equipment Replacement
E -13 -78
n/a
30,974
Attach - two (2) Cabs for Groundmaster
Equipment Replacement
E -13 -90
n/a
13,042
Afton Rd - Reclaim
Local Street Reconstruction
LR -13 -01
1
196,013
Sunnyvale Lane - Reclaim
Local Street Reconstruction
LR -13 -02
1
128,696
Maintenance - Bituminous Sealcoating
Local Street Reconstruction
LR -99 -100
n/a
248,115
Maintenance - Bituminous Overlays
Local Street Reconstruction
LR -99 -99
n/a
198,660
Water Main - Afton
Municipal Water System
W -13 -01
n/a
150,000
Water Main - Sunnyvale Lane
Municipal Water System
W -13 -02
n/a
100,000
W. Water Tower - Rehab & Painting
Municipal Water System
W -13 -03
n/a
450,000
Badger Park - Tennis Court Resurface
Parks
P -10 -04
n/a
6,000
Skate Park - Shelter
Parks
P -13 -04
n/a
16,000
Lift Station 11 Rehab - 20465 Radisson Rd.
Sanitary Sewer
SS -13 -01
n/a
70,000
Infiltration and Inflow Reduction
Sanitary Sewer
SS -99 -05
n/a
70,000
Afton Rd Drainage
Stormwater Management
STM -13 -01
1
146,772
Sunnyvale Lane Drainage
Stormwater Management
STM -13 -02
1
191,442
Computer Upgrades
Technology /Office Equip
T -99 -99
n/a
10,000
'rota) for 2013
2,195,253
''
2014 14
Mower - Toro Groundsmaster 325D
Equipment Replacement
E -14 -70
n/a
27,464
Ford F450 Utility Truck - with crane & toolbox
Equipment Replacement
E -14 -76
n/a
97,842
Dodge Grand Caravan
Equipment Replacement
E -14 -77
n/a
23,688
Attach -Two (2) Blowers for Grndsmstr (1972 & 2000)
Equipment Replacement
E -14 -89
n/a
15,654
Attach -Cab for Groundsmaster (1985)
Equipment Replacement
E -14 -92
n/a
6,866
Club Valley - Reclaim
Local Street Reconstruction
LR -14 -01
1
135,130
Lake Virginia Drive - Reclaim
Local Street Reconstruction
LR -14 -02
1
299,191
Maintenance - Bituminous Sealcoating
Local Street Reconstruction
LR -99 -100
n/a
260,521
Maintenance - Bituminous Overlays
Local Street Reconstruction
LR -99 -99
n/a
208,593
Water Main - Club Valley
Municipal Water System
W -14 -01
n/a
100,000
Water Main - Lake Virginia Drive
Municipal Water System
W -14 -02
n/a
240,000
Manor Park - Equipment Replacement
Parks
P -14 -01
n/a
50,000
Infiltration and Inflow Reduction
Sanitary Sewer
SS -99 -05
n/a
70,000
Club Valley Drainage
Stormwater Management
STM -14 -01
1
100,507
Lake Virginia Drive Drainage
Stormwater Management
STM -14 -02
1
282,760
6120 Riviera Drainage - WSB Report
Stormwater Management
STM -14 -04
1
18,761
22
Project Name
Computer Upgrades
GRAN 3 TOTAL
Technology /Otiice Equip
P
ject # PHOT
F-99-99 nta
Project Cos
10,000
1,946,977
10,579,165
23
C ACTION FORM
Bass 0- a
transfer, etc.
The Council directed staff tu prepare u few more scenarios that use the newly created infrastructure
fund. Two more options are included for discussion.
Recommendation
Provide staff with additional direction.
Council Action:
700000
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
$ 4,816,107
$ 4,859,452
0
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
202.7
$ 4,887,056
2028
Beginning balance
$ 1,096,343
$ 1,065,621
$ 879,543
$ 263,889
$ 546,336
$ 564,969
$ 375,292
$ 430,582
$ (360,645)
$ (517,671)
$ (594,934)
$ (351,014)
$ 88,758
$ 737,168
$ 1,073,369
$ 1,185,800
$ 165,938
$ 690,222
$
1,167,034
Anticipated revenue
$ 78,090
$ 77,583
$ 74,512
$ 64,354
$ 69,015
8 69,322
$ 66,192
$ 67,105
$ 54,049
$ 51,458
$ 50,184
$ 54,208
$ 62,464
$ 72,163
$ 77,711
$ 79,566
$ 62,738
$ 71,389
$
79,256
General Fund Transfer
$ 700,000
$ 762,370
$ 824,740
$ 873,134
$ 920,168
$ 969,049
$ 1,01.8,764
$ 1,069,062
$ 1,129,447
$ 1,171,783
$ 1,232,161
$ 1,267,155
$ 1,313,598
$ 1,372,348
$ 1,399,707
$ 1,416,971
$ 1,438,411
$ 1,464,053
$
1,494,378
Infrastructure Fund
1.50%
$ 150,000
$ -
$ 150,000
$ -
$ 150,000
2.00%
$ 150,000
$ 19,907.59
$ 62,370.10
$ 48,393.83
$ 47,033.67
$ 48,881.67
$ 49,714.91
$ 50,298.16
$ 60,384.70
$ 42,335.97
$ 60,378.29
$ 34,993.80
$ 46,443.07
Total Revenue
$ 1,874,433
$ 2,055,574
$ 1,778,796
$ 1,351,377
$ 1,535,518
$ 1,753,340
$ 1,460,249
$ 1,716,749
$ 822,852
$ 705,570
$ 687,411
$ 970,350
$ 1,463,820
$ 2,181,680
$ 2,550,787
$ 2,682,337
$ 1,667,087
$ 2,225,664
$
2,740,668
Road Projects
$ 808,812
$ 1,176,031
$ 1,481,350
$ 771,484
$ 903,435
$ 1,277,377
$ 928,996
$ 1,976,723
$ 1,239,852
$ 1,233,390
$ 971,311
$ 848,035
$ 693,095
$ 1,108,311
$ 1,364,987
$ 2,516,399
$ 976,865
$ 1,058,630
$
928,813
Infrastructure fund payback
$ -
$ -
$ 33,557
$ 33,557
$ 67,114
$ 100,671
$ 100,671
$ 100,671
$ 100,671
$ 67,114
$ 67,114
$ 33,557
$ 33,557
Balance
$ 1,065,621
$ 879,543
$ 263,889
$ 546,336
$ 564,969
$ 375,292
$ 430,582
$ (360,645)
$ (517,671)
$ (594,934)
$ (351,014)
$ 88,758
$ 737,168
$ 1,073,369
$ 1,185,800
$ 165,938
$ 690,222
$ 1,167,034
$
1,811,855
Levy Impact
2010 Levy
$ 4,776,292
$ 4,838,662
$ 4,887,056
$ 4,934,090
$ 4,982,971
$ 5,032,686
$ 5,082,984
$ 5,143,369
$ 5,185,705
$ 5,246,083
$ 5,281,077
$ 5,327,520
$ 5,386,270
$ 5,413,629
$ 5,430,893
$ 5,452,333
$ 5,477,975
$ 5,508,300
$
5,543,193
Projected increase in dollars
$ -
$ 62,370
$ 48,394
$ 47,034
$ 48,882
$ 49,715
$ 50,298
$ 60,385
$ 42,336
$ 60,378
$ 34,994
$ 46,443
$ 58,750
$ 27,359
$ 17,264
$ 21,440
$ 25,642
$ 30,325
$
34,893
Percent increase
0%
1.31%
1.00%
0.96%
0.99%
1.00%
1.00%
1.19%
0.82%
1.16%
0.67%
0.88%
1.10%
0.51%
0.32%
0.39%
0.47%
0.55%
0.63%
Assumptions
The levy limits continue as currently in statute
The maximum levy increase is the Iplicit Price Deflator (IPD) or 3 %, which ever is less
There is an anticipation for moderate recovery overtime
Transfer to Road fund increased at 100% of the allowable levy for the first few years and then reduces based on future financial need.
Anticipated revenue includes interest on balance at 1.65% and state road aid of $60,000 per year.
The $60,000 maintenance money currenity flows to the General fund for general maintenance items.
All other levy supported spending remains flat.
No change in project schedule.
Borrow from $150,000 from the the infrastructure fund over four years.
Payback on the infrastructure loan is 10 years at 4.5%
Allowable Levy
Actual Levy
Difference
Percent allowable
Anticipated levy limit
Transfer amount
Actual Increase in Levy
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
$ 4,816,107
$ 4,859,452
$ 4,903,187
$ 4,949,767
$ 4,999,265
$ 5,049,258
$ 5,099,750
$ 5,163,497
$ 5,228,041
$ 5,306,462
$ 5,386,059
$ 5,466,849
$ 5,562,519
$ 5,659,863
$ 5,758,911
$ 5,859,692
$ 5,965,166
$ 6,084,470
$ 6,206,159
$ 4,776,292
$ 4,838,662
$ 4,887,056
$ 4,934,090
$ 4,982,971
$ 5,032,686
$ 5,082,984
$ 5,143,369
$ 5,185,705
$ 5,246,083
$ 5,281,077
$ 5,327,520
$ 5,386,270
$ 5,413,629
$ 5,430,893
$ 5,452,333
$ 5,477,975
$ 5,508,300
$ 5,543,193
$ 39,815
$ 83,160
$ 64,525
$ 62,712
$ 65,176
$ 66,287
$ 67,064
$ 80,513
$ 84,672
$ 120,757
$ 139,975
$ 185,772
$ 234,999
$ 273,593
$ 345,282
$ 428,799
$ 512,833
$ 606,495
$ 697,859
0.83%
1.71%
1.32%
1.27%
1.30%
1.31%
1.32%
1.56%
1.62%
2.28%
2.60%
3.40%
4.22%
4.83%
6.00%
7.32%
8.60%
9.97%
11.24%
0.8336%
0.90%
0.90%
0.95%
1.00%
1.00%
1.00%
1.25%
1.25%
1.50%
1.50%
1.50%
1.75%
1.75%
1.75%
1.75%
1.80%
2.00%
2.00%
$ 19,907.59
$ 62,370.10
$ 48,393.83
$ 47,033.67
$ 48,881.67
$ 49,714.91
$ 50,298.16
$ 60,384.70
$ 42,335.97
$ 60,378.29
$ 34,993.80
$ 46,443.07
$ 58,749.77
$ 27,359.34
$ 17,264.08
$ 21,439.93
$ 25,641.65
$ 30,324.74
$ 34,892.97
0.42%
1.29%
0.99%
0.95%
0.98%
0.99%
0.99%
1.17%
0.82%
1.15%
0.66%
0.87%
1.09%
0.51%
0.32%
0.39%
0.47%
0.55%
0.63%
700000
0
Beginning balance
Anticipated revenue
General Fund Transfer
Excess Fund Balance Transfer
Infrastructure Fund
Total Revenue
Road Projects
Infrastructure fund payback
Balance
Levy Impact
2010 Levy
Projected increase in dollars
Percentincrease
2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2.023 2024 2025 2026 2027 2028
1,096,343 $ 1,065,621 $
$ 78,090 $ 77,583 $
$ 700,000 $ 762,370 $
$ 90,000 $
$ 150,000 $
$ 1,874,433 $ 2,145,574 $
$ 808,812 $ 1,176,031 $
$ - $ 33,557 $
$ 1,065,621 8 935,986 $
935,986 $
75,444 $
824,740 $
90,000 $
150,000 $
2,076,170 $
1,481,350 $
67,114 $
527,706 $
527,706 $ 837,392 $
68,707 S 73,817
873,134 $ 920,168 $
90,000 $ 90,000 $
150,000 $ 1S0,000
1,709,547 $ 2,071,377 $
771,484 $ 903,435 $
100,671 $ 134,228 $
837,392 $ 1,033,714 $
1,033,714 $
77,056 $
969,049 $
90,000 $
2,169,819 $
1,277,377 $
100,671 $
791,771 $
791,771 $
73,064 $
1,018,764 $
60,000 $
1,943,600 $
928,996 $
100,671 $
913,933 $
913,933 $ 74,238 $
75,080 $ 61,225 $
1,069,062 $ 1,129,447 $
60,000 $ 55,000 $
2,118,075 $ 1,319,910 $
1,976,723 $ 1,239,852 $
67,114 $ 33,557
74,238 $ 46,501 $
46,501 $
60,767 $
1,171,783 $
56,000 $
1,334,052 $
1,233,390 $
100,662 $
100,662 $ 453,173
61,661 $ 67,477 $
1,232,161 $ 1,267,155 $
30,000 $ 30,000 $
1,424,484 $ 1,817,806 5
971,311 $ 848,035 $
453,173 $ 969,771 $
969,771 $
76,001 $
1,313,598 $
30,000 $
2,389,370 $
693,095 $
1,696,275 $
1,696,275 $
87,989 $
1,372,348 $
25,000 $
3,181,612 $
1,108, 311 $
2,073,301 $
2,073,301. $ 2,227,230 $
94,209 $ 96,749 $
1,399,707 $ 1,41.6,971 $
25,000 $ 25,000 $
3,592,217 $ 3,765,951 $
1,364,987 $ 2,516,399 $
2,227,230 $ 1,249,552 $
1,249,552 $
80,618 $
1,438,411 $
25,000 $
2,793,581 $
976,865 $
1,816,716 $
1,816,716 $ 2,337,11'
89,976 $ 98,567
1,464,053 $ 1,494,371;
25,000 $ 25,OOC
3,395,745 $ 3,955,055
1,058,630 $ 928,813
2,337,115 $ 3,026,242
$ 4,776,292 $ 4,838,662 $ 4,887,056 $ 4,934,090 $ 4,982,971 $ 5,032,686 $ 5,082,984 $ 5,143,369 $ 5,185,705 $ 5,246,083 $ 5,281,077 $ 5,327,520 $ 5,386,270 $ 5,413,629 $ 5,430,893 $ 5,452,333 $ 5,477,975 $ 5,508,300 $ 5,543,193
$ $ 62,370 $ 48,394 $ 47,034 $ 48,882 $ 49,715 $ 50,298 $ 60,385 $ 42,336 $ 60,378 $ 34,994 $ 46,443 $ 58,750 $ 27,359 $ 17,264 $ 21,440 $ 25,642 $ 30,325 $ 34,893
0% 1.31% 1.00% 0.96% 0.99% 1.00% 1.00% 1.19% 0.82% 1.16% 0.67% 0.88% 1.10% 0.51% 0.32% 0.39% 0.47% 0.55% 0.63%
Assumptions
The levy limits continue as currently in statute
The maximum levy increase is the Iplicit Price Deflator (IPD) or 3 %, which ever is less
The IPD increases as GDP advances, thus as the economy improves, the IPD increases - anticipate moderate recovery overtime
Transfer to Road fund increased at 100% of the allowable levy for the first few years and then reduces based on future financial need.
Anticipated revenue includes interest on balance at 1.65% and state road aid of $60,000 per year.
The $60,000 maintenance money currenity flows to the General fund for general maintenance items.
All other levy supported spending remains flat.
Transfer excess fund balance over the amount retained via policy to Road Fund at end of year in addition to other transfers.
No change in project schedule.
Borrow from $150,000 from the the infrastructure fund over four years.
Payback on the infrastructure loan is 10 years at 4.5%
Alter General Fund balance policy such that 60% amount over 60% of the operating budget is transferred to the Road Fund
Estimate excess general fund balance equals 150,000 over next 5 years, decreases thereafter
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
Allowable Levy
$
4,816,107
$ 4,859,452
$ 4,903,187
$ 4,949,767
$ 4,999,265
$ 5,049,258
$ 5,099,750
$ 5,163,497
$ 5,228,041
$ 5,306,462
$ 5,386,059
$ 5,466,849
$ 5,562,519
$ 5,659,863
$ 5,758,911
$ 5,859,692
$ 5,965,166
$ 6,084,470
$ 6,206,159
Actual Levy
$
4,776,292
$ 4,838,662
$ 4,887,056
$ 4,934,090
$ 4,982,971
$ 5,032,686
$ 5,082,984
$ 5,143,369
$ 5,185,705
$ 5,246,083
$ 5,281,077
$ 5,327,520
$ 5,386,270
$ 5,413,629
$ 5,430,893
$ 5,452,333
$ 5,477,975
$ 5,508,300
$ 5,543,193
Difference
$
39,815
$ 83,160
$ 64,525
$ 62,712
$ 65,176
$ 66,287
$ 67,064
$ 80,513
$ 84,672
$ 120,757
$ 139,975
$ 185,772
$ 234,999
$ 273,593
$ 345,282
$ 428,799
$ 512,833
$ 606,495
$ 697,859
Percent allowable
0.83%
1.71%
1.32%
1.27%
1.30%
1.31%
1.32%
1.56%
1.62%
2.28%
2.60%
3.40%
4.22%
4.83%
6.00%
7.32%
8.60%
9.97%
11.24%
Anticipated levy limit
0.8336%
0.90%
0.90%
0.95%
1.00%
1.00%
1.00%
1.25%
1.25%
1.50%
1.50%
1.50%
1.75%
1.75%
1.75%
1.75%
1.80%
2.00%
2.00%
Transfer amount
$
19,907.59
$ 62,370.10
$ 48,393.83
$ 47,033.67
$ 48,881.67
$ 49,714.91
$ 50,298.16
$ 60,384.70
$ 42,335.97
$ 60,378.29
$ 34,993.80
$ 46,443.07
$ 58,749.77
$ 27,359.34
$ 17,264.08
$ 21,439.93
$ 25,641.65
$ 30,324.74
$ 34,892.97
Actual Increase in Levy
0.42%
1.29%
0.99%
0.95%
0.98%
0.99%
0.99/
°
1.17/
0.82%
1.15%
0.66/
%
0.87/
%
°
1.09/
0.51%
°
0.32/
°
0.39/
0.47%
0.55%
0.63%