10-08-12 CC WS Agenda PacketCITY OF SHOREWOOD
CITY COUNCIL WORK SESSION
MONDAY, OCTOBER 8, 2012
NOTNUM
1. CONVENE CITY COUNCIL WORK SESSION
A. Roll Call
B. Review Agenda
2. CAPITAL IMPROVEMENT PROGRAM
5755 COUNTRY CLUB ROAD
COUNCIL CHAMBERS
6:00 P.M.
Mayor Liz&
Hotvet
Siakel
Woodruff
Zerby
ATTACHMENTS
Finance Director's
memo
3. ADJOURN
M City of Shorewood Work Session Item
3A
MEETING TYPE
Work Session
Meeting
Title / Subject: Review 2013 -2022 Capital improvement Plan
Meeting Date: October 8, 2012
Prepared by: Bruce DeJong, Finance Director
Reviewed by: Brad Nielsen, Planning Director
Larry Brown, Public Works Director
James Landini, City Engineer
Joe Pazandak, Building Official
Jean Panchyshyn, Deputy Clerk
Bill Jaynes, Interim City Administrator
Attachments: Fund Balance Timeline
Projects by Department
Policy Consideration:
How should capital projects be prioritized, scheduled, and funded?
Background:
The ten -year capital improvement plan (CIP) has been updated based on new information regarding the
condition and estimated cost of planned projects.
The capital projects funds that we will be examining at this meeting will be:
• Fund 401— Public Facilities
• Fund 402 — Park
• Fund 403 — Equipment Replacement
• Fund 404 — Local Streets
• Fund 405 — MSA
• Fund 406 —Trail Construction
• Fund 408 — Technology /Office Equipment
• Fund 450 — Community Infrastructure
Enterprise funds to be reviewed at the next meeting include:
• Fund 490— Southshore Center
• Fund 601 —Water
• Fund 611 — Sewer
• Fund 621— Recycling
• Fund 631— StormwaterManagement
Mission Statement: The City of Shorewood is committed to providing residents quality public services, a
healthy environment, a variety of attractive amenities, a sustainable tax base, and sound financial
management through effective, efficient and visionary leadership. Page 1
Fund 401— Public Facilities has no projects scheduled. Projects that were included in this fund are now
in Fund 403 to allow equipment and building projects together since they are competing for the same
funding pool. The remaining balance should be transferred to Fund 403 and this fund should be closed.
Fund 402 - Park Capital Improvements has become much clearer than previous years based on
discussions at the last several Park Commission meetings. The Park Commission has merged its various
project lists into one that includes everything on the CIP. Because of this, the projects beyond 2013 are
still somewhat speculative in nature and include some items that were on the maintenance list and the
"wish" list that previously existed. This fund spends all of its annual transfer allotment and uses a lot
more over the ten year span. Longer term analysis of park needs— particularly in Badger Park - will
determine the annual amount that will adequately fund the community's needs and City Council desires.
Fund 403 - Equipment Replacement fund generally covers all of the city's rolling stock and attachments
along with the equipment at the Public Works shop to keep everything running. Projects from the Public
Facilities and Technology have been incorporated into this fund. The next ten years of equipment
purchases average about $185,000 per year, so this level of replacement requires additional resources
to fully fund equipment needs over the long term.
Staff believes that the Public Facilities and Technology funds should be transferred into the Equipment
Replacement fund. These funds primarily exist to cover replacement of long -term assets which are
competing for the same pool of available funds. Combining them gives a more complete picture of the
amount of total capital replacement anticipated in a given year and the resources that can be applied.
No funds have been allocated for the rental house at 5795 Country Club Road. Staff is hesitant to
include anything as there seems to be concern about keeping this property for the long -run. Three
technology projects are not included because staff has not had the opportunity to discuss them with the
City Council, but should be considered.
1. The first is a wide -area network connection from City Hall to the Southshore Center and Public
Works. This could be accomplished several different ways —fiber optic cable, point -to -point
wireless, or potentially through Mediacom. Costs for these various options have yet to be
determined. The benefit of a link is that resources can be shared much more easily with access
to City Hall computers, printer /copiers, and phone system.
2. The second project is an upgrade to the Laserfiche system which allows better access to city
records by internet users and includes workflow software to allow easier entry of documents by
staff in the normal course of business rather than as a process after the fact. The cost today
would be about $5,900 because we have some pro -rated credit available from our unused
annual maintenance. The cost will increase by over $2,060 if we wait until January to purchase
this upgrade.
3. The third project is replacement of the color copier. We could purchase or lease a new copier
and substantially lower the cost per copy from our current maintenance agreement. The cost to
purchase a color copier is about $9,000 and the annual per -copy costs would go down by about
$1,900 per year. This would be about a five year payback of the costs and the current copier has
had a service life of seven years.
Staff would like direction from the Council to include or exclude these projects.
Fund 404 — Street Reconstruction incorporates all maintenance activities for streets including seal -coat,
mill and overlay, and reconstruction projects. This schedule was approved by the City Council last year
and has only minor tweaks in the timing based on current pavement condition and project coordination.
Fund 405 — MSA Construction is shown to accumulate funds for Eureka Road North. Minnesota State
Aid (MSA) funds are accumulated at the Minnesota Department of Transportation for each city that
qualifies for the program. We are accumulating funds at a rate of about $200,000 per year. If that rate
continues, the city should have sufficient funds on hand to cover Eureka Road North reconstruction.
Mr. Landini has pointed out that MSA funds are also allowed to be used for sidewalk construction along
MSA routes so a portion of this money could be used for the trail segment along Smithtown Road that is
anticipated to be constructed next year as well as for the segment along County 19 to connect to the
regional trail.
Fund 406 —Trail Construction has been updated to reflect the delay of the project to the LRT to 2013. In
accordance with Council action last year, the funding source for all trail projects is considered to be a
transfer from the Community Infrastructure fund. Grant funding is potentially available for some trail
segments, but the competition for those grants is rigorous. We can't reasonably assume that any
particular segment will be funded but staff intends to pursue the Safe Routes to School grant that will be
open later this year for 2013 project along Smithtown Road.
Fund 408 — Technology has no projects scheduled. Projects that formerly were included in this fund are
now in Fund 403 to allow all equipment and city building projects together since they are competing for
the same funding pool. The remaining fund balance should be transferred to Fund 403 and this fund
should be closed.
Fund 450 - Community Infrastructure fund does not have any future projects assigned to it. It functions
as a holding fund until projects are created in other funds that may use the approximate $1,680,000
cash balance left after funding the purchase of the 24620 Smithtown Road property and the balance of
the South Shore Center sign. Council should define what projects may use this funding source and how
the fund balance will be replenished.
The Water, Sewer, and Stormwater Management funds will be covered in the discussion of their
operating budgets. Storm Water projects have been updated to include estimated consultant costs
required for the initial design and project management phases. The water projects included with this
plan are the ones that staff reasonably anticipates based on the road reconstruction schedule where a
connection to the existing system is relatively close. If a city -wide water connection plan is to be
included, then more work is needed on this section and the expenditures will be substantially higher.
The 2013 projects essentially become the capital outlay portion of the budget. The remaining year's
projects are then used to evaluate the solvency and funding adequacy of each capital projects fund and
the utility funds over the ten years shown in the plan.
Staff recommends that projects included in the CIP with an estimated cost of less than $100,000 be
delegated to staff to complete as long as the total cost is at or below the amount listed in the CIP. If a
project estimate exceeds the budgeted amount, staff will bring that back for a budget amendment.
Projects estimated to cost in excess of $100,000 will be brought back to the City Council for approval of
plans and specifications and awarding of bids. If equipment over $100,000 can be purchased from
cooperative purchasing contracts (where another agency has already accepted bids), staff intends to use
that avenue for acquiring the equipment and does not anticipate bringing the purchase back to City
Council for further approval except as an item on the claims list.
Financial or Budget Considerations:
Several funds do not have adequate resources to purchase all of the items listed. The Park Capital
Improvement fund runs out of money in 2014 if all the Badger Park items are funded. The Equipment
Replacement fund runs out of money in 2015 if no adjustments are made. The Community
Infrastructure fund runs out of money in 2020 if no adjustments are made. City Council should prioritize
the projects in each of these funds and determine a method of funding the highest ranking projects over
the selected time horizon.
Recommendation / Action Requested:
Staff recommends that the City Council review the scheduled purchases and direct staff to make any
changes that are desired.
Next Steps and Timelines:
This schedule will be reviewed again in November. Adoption of the CIP is anticipated for December 10.
Connection to Vision / Mission:
These purchases contribute to providing excellent public facilities by replacing worn and unsafe
equipment, maintaining streets, constructing trails, and maintaining public utility infrastructure.
Fund Balance Timeline — When do funds run out of money?
Fund
2014
2015
2016
2017
2018
2019
2020
2021
Park Improvement
X
X
X
X
X
X
X
X
Equipment
Replacement
OK
OK
X
X
_
X
X
X
X
Street
Reconstruction
OK
OK
OK
OK
OK
OK
_
OK
OK
MSA Street
Construction
OK
OK
OK
OK
OK
OK
OK
OK
Trail Construction
OK
OK
OK
OK
OK
OK
X
X
Community
Infrastructure *
OK
O K
OK
OK
OK
OK
X
X
* The Community Infrastructure Fund will transfer an amount equal to the cost of Trail Construction expenditures in accord with
the direction taken with the adoption of the most recent CIP.
94pp
City of Shorewood, Minnesota
Capital Improvement Program
2012 thin 2021
PROJECTS BY DEPART TMEN T
Department # Priority 2012 2013 2014 2015 2 2017 2018 2019 2020 2021 Total
402 - Park Capital Improvement I
Message Boards
P0001
1
4,140
4,140
Picnic Tables
P0002
1
16,500
16,500
Gideon Glen Parking Lot & Signage
P0003
5
20,000
20,000
Freeman Plaza
P0100
5
5,000 5,000
Freeman North Playground Equipment
P0102
4
55,000
55,000
Freeman Parking Lot wt MCWD
P0103
s
50,000
50,000
Freeman Ball Field Lights
P0104
5
75,000
75,000
Freeman Picnic Shelter Re -Roof
P0105
4
3,000
3,000
Freeman Park Buckthorn Removal
P0106
4
11,500
11,500
Freeman Park BallBeld Fencing
P0107
4
10,000
10,000
Freeman Park - Eddy Station
P010e
4
8,500
8,500
Cathcart Park - Resurface
P0200
1
6,300
6,500
7,000
7,000 26,800
Tennis /Basketball Courts
Cathcart Park Hockey Boards
P0201
3
20,000
20,000
Cathcart Park Tot Lot
P0202
s
50,000
50,000
Cathcart Parking Lot
P0203
5
100,000 100,000
Badger Park - Rustic Trail
P0300
0
10,000
10,000
Badger Park Tennis Courts
P0301
2
200,000
8,000
8,500 216,500
Badger Park Hockey Rink
P0302
2
200,000
200,000
Badger Park Swing Set
P0303
2
12,000
12,000
Badger Park Green Space
P0304
2
20,000
20,000
Badger Park Warming House
P0305
2
80,000
80,000
Badger Park Playground Equipment
Mrs
2
65,000
65,000
Manor Park - Versa -Court Tennis Surface
PO400
1
30,000
30,000
Manor Park- Water Source for Garden
PO401
1
8,000
8,000
Manor Park- Shelter Outside Floor&
PO402
1
5,400 5,400
Stoops
Silverwood Park - Resurface 112 court
P0500
2
2,000
2,000
2,500
2,500 9,000
Silverwood Park Equipment
P0501
3
60,000
60,000
Department # Priority 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Total
Silverwood Park Swing Set P0502 3 14,000 14,000
Skate Park Rehab P0600 3 75,000 75,000
Skate Park Picnic Shelter POW 5 15,000 15,000
Skate Park- Community Garden Fencing P0602 s 5,000 5,000
402 - Park Capital Improvement Total 50,440 141,500 652,000 28,500 3,000 113,000 134,500 19,000 128,900 9,500 1,280,340
GRAND 50,440 141,500 652,000 28,500 3,000 113,000 134,500 19,000 128,900 9,500 1,280,340
PARK CAPITAL IMPROVEMENT FUND
Fund: 402- Park Capital Outlay
REVENUES
Beginning Fund Balance
Park Dedication Fees
Interest Earnings`
Contributions / donations
Concession Sales
Grants
Miscellaneous revenue
Transfers in
TOTAL REVENUES
EXPENDITURES
OTHER SERVICES
Contractrual Services
Miscellaneous Charges
TOTAL OTHER SERVICES
CAPITAL OUTLAY
Other Improvements
TOTAL CAPITAL OUTLAY
TOTAL EXPENDITURES
Revenue - Over /(under)
Ending Fund Balance
Actual Actual Actual Estimate Budget
2009 2010 2011 2012 2013
262,710
293,430
190,380
150,958
153,273
-
10,000
-
10,000
30,000
2,771
2,730
964
755
800
394
-
82,386
(39,422)
50,440
2,315
141,500
(68,700)
-
104,200
150,958
153,273
84,573
45,000
42,000
42,000
42,000
42,000
48,165
158,930
42,964
52,755
72,800
3,800
40
3,840
13,605
-
261,980
-
82,386
-
50,440
-
141,500
13,605
261,980
82,386
50,440
141,500
17,445
30,720
261,980
(103,050)
82,386
(39,422)
50,440
2,315
141,500
(68,700)
293,430
190,380
150,958
153,273
84,573
• O
City of Shorewood, Minnesota
Capital Improvement Program
2012 thru 2021
PROJECTS BY DEPARTMENT
Department # Pri 2 2 2 2015 2016 2017 2018 2019 2020 2021 Total
403 - Equipment Replacement
DumpTruck - Replace Unit 33
Ell 01
1
155,000
166,000
Replace Unit 21 - 24' trailer
E42 -01
2
16,000
16,000
Sand Pro 3000 - replace Unit 64
E 12 02
2
13,000
13,000
Groundsmaster Mower -Toro 328D-
E12 03
2
24,000
30,000
54,000
replace unit 75
Air Compressor - Replace unit 38
E13 01
3
12,000
12,000
DumpTruck - replace unit 65
E -1302
3
160,000
160,000
DumpTruck - Replace Unit 68
E -13-03
2
165,000
165,000
Pickup 4x4- Replace Unit 78
E1304
3
38,000
38,000
Cab for mower - replace A3
E13 05
3
8,000 8,000
Utility Truck wfcome& toolbox replace
E 14 01
5
77,000
77,000
unit 76
Mower - Replace Unit 84
E-14 -02
4
25,000
25,000
Utility Vehicle - replace unit 77
E-1403
4
26,000
26,000
Blower Attachment for Skid Steer
E -14-04
4
12,500
12,500
Cab attachement for mower replace unit
E-14 05
4
7,000
7,000
A4
Pick -up- 4 x 4150 Replace Unit 80
E155o1
5
35,000
35,000
DumpTruck - replace unit 72
E1s 03
5
175,000
175,000
Trailer 18' replace unit 59
E 16 01
5
15,000
15,000
Sewer Jetter - replace unit 60
E16 02
5
53,000
53,000
Pickup - 350 4 x4 replace unit 81
E -17 -01
s
42,000
42,000
Groundsmaster Mower replace unit 91
E 17 02
5
28,000
28,000
Mower blower attachment replace unit Al
En -03
5
6,000
6,000
Cab for mower replace A4
E -1704
5
7,000
7,000
Vehicle Analysis station replace A9
E18 01
5
4,000
4,000
Skid Steer - replace unit 63
E19-01
5
35,000
46,000 81,000
ATV - replace unit 34
E19 02
5
20,000
20,000
Sander replace Al 0
E 19 04
s
12,000
12,000
4" pump replace unit 50
E-2001
5
45,000 45,000
Department # Priority 2012 2013 2014 2015 2016 2017 2015 2019 2020 2021 Total
Trailer 12' replace unit 69
E -2002
5
4,000
4,000
Roller - replace unit 73
E20 03
5
37,000
37,000
Pickup 350 44 - replace unit 91
e -2o -04
5
42,000
42,000
Sweeper - replace unit 74
E -21 -01
5
190,000
190,000
Cab for mower - replace A3
E -21 -03
5
8,000
8,000
Flatbed - 4 x 2 Replace unit 49
E -24 -01
5
44,000
44,000
Broom Attachment- Skid Steer replace
E25 -02
5
3,000
3,000
A13
Street Sign Replacement
tR -99 -001
2
6,000
6,300
6,600
6,900
7,200
7,500
7,800
8,100 8,400
8,700
73,500
South Shore Community Center
PF 1-01
'1a
2,500
43,000
41,000
2,000
88,500
Public Works Building
PF-1201
1e
6,500
4,000
10,000
81,000
101,500
City Council laptop Computers (5)
x42-01
1
5,000
5,000
Server and Operating System
x42-02
2
10,000
10,000
Replacements
Financial Software
r -12-03
2
90,000
90,000
Computer Upgrades
x99 -99
1
10,000
20,000
10,000
10,000
10,000
10,000
10,000
10,000 10,000
10,000
110,000
403 - Equipment Replacement Total 394,500 213,300 235,100 256,900 258,700 263,500 71,800 68,100 253,400 82,700 2,098,000
GRAND TOTAL 394,500 213,300 235,100 256,900 258,700 263,500 71,800 68,100 253,400 82,700 2,098,000
EQUIPMENT REPLACEMENT FUND
Fund: 403 - Equipment & Building Capital Outlay
Actual
Actual
Actual
Budget
Budget
REVENUES 2009
2010
2011
2012
2013
Beginning Fund Balance 671,447
842,786
732,105
521,172
181,772
Interest Earnings
7,282 8,495
4,788 2,600 900
Miscellaneous Income
- -
6,271 - -
Sale of Old Equipment
- 31,130
- - -
Transfers in
175,000 100,000
50,000 50,000 58,500
TOTAL REVENUES
182,282 139,625
61,059 52,600 59,400
EXPENDITURES
OTHER SERVICES
Contractual Services 1,126
Bank Charges 71
TOTAL OTHER SERVICES 1,197
CAPITAL OUTLAY
Machinery and Equipment 9,746 250,306 271,992 392,000 213,300
TOTAL CAPITAL OUTLAY 9,746 250,306 271,992 392,000 213,300
TOTAL EXPENDITURES 10,943
250,306 271,992 392,000 213,300
Revenue over /(under) 171,339
(110,681) (210,933) (339,400) (153,900)
Ending Fund Balance 842,786
732,105 521,172 181,772 27,872
Available funds in 401- Public Facilities
178,089
Available funds in 408 - Technology
79,089
257,178
PUBLIC FACILITY FUND
Fund: 401- Public Facility Fund
REVENUES
Beginning Fund Balance
Interest Earnings*
Miscellaneous revenue
Transfers in
TOTAL REVENUES
EXPENDITURES
OTHER SERVICES
Contractrual Services
Miscellaneous Charges
TOTAL OTHER SERVICES
CAPITAL OUTLAY
Other Improvements
TOTAL CAPITAL OUTLAY
Transfers Out
TOTAL EXPENDITURES
Revenue - Over /(under)
Ending Fund Balance
Actual Actual Actual Budget Budget
2009 2010 2011 2012 2013
226,755 227,762 196,080 178,089 178,089
2,339 2,333 1,456 - -
2,339 2,333 1,456
132
-
1,200
5
1,332
5
-
-
2,371
19,447
2,371
19,447
31,639
1,332
34,015
19,447
1,007
(31,682)
(17,991)
227,762 196,080 178,089 178,089 178,089
Technology
Fund: 408 - Technology Replacement Fund
REVENUES
Beginning Fund Balance
Interest Earnings
Grants
Transfers in
Total Revenue
EXPENDITURES
CAPITAL OUTLAY
Other Improvements
TOTAL CAPITAL OUTLAY
Transfers Out
TOTAL EXPENDITURES
Revenue over /(under)
Ending Fund Balance
Actual Actual Actual Budget Budget
2009 2010 2011 2012 2013
103,500 104,525 90,754 79,089 79,089
1,039 854 708 - -
1,039 854 708
14 3 12,373
14 3 12,373
14,622
14 14,625 12,373
1,025 (13,771) (11,665)
104,525 90,754 79,089 79,089 79,089
• � � • • •
City of Shorewood, Minnesota
Capital Improvement Program
2012 thru 2021
PROJECTS BY DEPARTMENT
Department # Priority 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Total
404 - Street Reconstruction
Afton Road
LR -11 -01
1
33,000
33,000
Clover Lane
LR 1201
2
26,000
26,000
Club Lane
LR -1202
2
25,000
25,000
Elder Turn
LR -1203
2
26,000
26,000
Knightsbridge Road
LR-1204
2
62,000
62,000
Lakeway Terrace
LR -1205
2
46,000
46,000
Pleasant Avenue
LR -12 -06
2
21,000
21,000
TeeTrail
LR-12-07
2
19,000
19,000
Wood Drive
LR 12 08
2
46,000
46,000
Wood Duck Circle
LR -1209
2
36,000
36,000
Elbert Point
LR -13.01
3
27,000
27,000
KcKinley Circle
LR -13-02
3
21,000
21,000
McLain Road
LR 13
3
26,000
26,000
Shady Hills Rd (& Ailey)
LR -1303
3
58,000
58,000
Shore Road
LR-13 -05
3
26,000
26,000
Valleywood Circle & Lane
LR -13 -06
3
601,000
601,000
Charleston Circle
LR -1401
4
36,000
36,000
Club Valley Road
LR 14
4
29,000
29,000
Lake Virginia Drive
LR -1403
4
63,000
63,000
Radisson Entrance
LR -14-04
4
33,000
33,000
Shady Lane
LR 1405
4
24,000
24,000
Sunnyvale Lane
LR 14 -06
4
228,000
228,000
Timber Lane
LR-14 07
4
55,000
55,000
Chaska Road
LR-1s01
5
87,000
87,000
Mayflower Road
LR -15 -02
5
33,000
33,000
McKinley Court
LR -15 -03
5
40,000
40,000
Murray Hill Road
LR 15 -04
5
52,000
52,000
Star Circle & Lane
LR 1505
5
453,000
453,000
Summit Avenue
LRas.06
5
32,000
32,000
Department # Priority 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Total
Amiss Road
LR 1"1
5
332,000
332,000
Garden Road
LR 16 -02
5
42,000
42,000
Gillette Curve
LR 16-03
5
35,000
35,000
Manton Lane
LR-15 -04
5
317,000
317,000
McKinley Place N & S
LR -16 -05
5
65,000
65,000
Shady Hills Circle
LR 16-08
5
51,000
51,000
Echo Road
18-11-01
5
71,000
71,000
Howards Point Road
LR 11-02
5
180,000
180,000
Kathleen Court
LR 1I -03
5
22,000
22,000
Oak Ridge Circle
LR 1704
5
29,000
29,000
Riviera Lane
LR 17 05
5
371,000
371,000
Shorewood Lane
LR 17 08
5
432,000
432,000
Mann Lane
LR 1801
5
444,000
444,000
Maple Street
1R -1802
5
100,000
100,000
Bayswater Road
LR -19 Of
5
100,000
100,000
Boulder Circle
LR -1902
5
49,000
49,000
Christmas Lane W
LR 19 03
5
32,000
32,000
Lilac Lane
1R -1905
5
46,000
46,000
Strawberry Lane
18-19 -06
5
85,000
85,000
Vine Street
LR-19-07
5
33,000
33,000
Birch Bluff Road
LR 20 -01
5
107,000
107,000
Excelsior Blvd
LR 20 02
5
19,000
19,000
Seamans Drive
1R -2003
5
629,000
629,000
West Lane
LP-20 04
5
32,000
32,000
Christmas Lane E
LR -21 -01
5
21,000
21,000
Christmas Lake Road
IF -21 02
5
107,000
107,000
Country Club Road
LR -2103
5
95,000
95,000
Maintenance - Bituminous Sealcoating
0R- 99-100
1
141,000 220,000 270,000 228,000 245,000
184,000
238
305,000
274,000
255,000
2,360,000
404 - Street Reconstruction Total
448,000 955,000 762,000 958,000 1,087,000
1,289,000
782,000
650,000
1,061,000
478,000
8,470,000
GRAND TOTAL 448,000 955,000 762,000 958,000 1,087,000 1,289,000 782,000 650,000 1,061,000 478,000 8,470,000
STREET RECONSTRUCTION FUND
Fund: 404 - Street Capital Outlay
REVENUES
Beginning Fund Balance
MSA Maintenance Money
Interest Earnings
Transfers in
Total Revenue
EXPENDITURES
CAPITAL OUTLAY
Other Improvements
TOTAL CAPITAL OUTLAY
TOTAL EXPENDITURES
Revenue over /(under)
Ending Fund Balance
Actual Actual Actual Budget
2009 2010 2011 2012
Budget
2013
1,625,965 1,619,643 1,311,707 1,481,482 1,740,882
11,142
13,981
11,413
7,400
8,700
700,000
712,135
700,000
700,000
714,000
711,142
726,116
711,413
707,400
722,700
717,464 1,034,052 541,638 448,000 955,000
717,464 1,034,052 541,638 448,000 955,000
717,464 1,034,052 541,638 448,000 955,000
(6,322) (307,936) 169,775 259,400 (232,300)
1,619,643 1,311,707 1,481,482 1,740,882 1,508,582
� •� • •
City of Shorewood, Minnesota
Capital Improvement Program
2012 tluu 2021
PROJECTS BY DEPARTMENT
Department # Priority 2012 2013 2014 2015 2016 2017
2018 2019 2020 2021 Total
1405 - MSA Construction
Eureka Road N IR 19 -04 5
405 - MSA Construction Total
GRAND TOTAL
1,922,000
1,922,000
1,922,000 1,922,000
1,922,000 1,922,000
MSA STREET CONSTRUCTION FUND
Fund: 405 - MSA Capital Outlay
EXPENDITURES
MATERIALS & SUPPLIES
General Supplies
TOTAL MATERIALS & SUPPLIES
OTHER SERVICES
Miscellaneous Services 15 167
TOTAL OTHER SERVICES 15 167
CAPITAL OUTLAY
Other Improvements
TOTAL CAPITAL OUTLAY - -
TOTAL EXPENDITURES 15 167 - -
Revenue over /(under) 3,594 4,078 901 700 700
Ending Fund Balance 127,671 131,749 132,650 133,350 134,050
MSA Construction Account Balance - at MN DOT 120,956 325,606 coming in Oct
Actual
Actual
Actual
Budget
Budget
REVENUES
2009
2010
2011
2012
2013
Beginning Fund Balance
124,077
127,671
131,749
132,650
133,350
MSA Construction Money
-
-
-
-
-
Interest Earnings
3,594
4,093
1,068
700
700
Transfers in
-
-
-
-
-
Total Revenue
3,594
4,093
1,068
700
700
EXPENDITURES
MATERIALS & SUPPLIES
General Supplies
TOTAL MATERIALS & SUPPLIES
OTHER SERVICES
Miscellaneous Services 15 167
TOTAL OTHER SERVICES 15 167
CAPITAL OUTLAY
Other Improvements
TOTAL CAPITAL OUTLAY - -
TOTAL EXPENDITURES 15 167 - -
Revenue over /(under) 3,594 4,078 901 700 700
Ending Fund Balance 127,671 131,749 132,650 133,350 134,050
MSA Construction Account Balance - at MN DOT 120,956 325,606 coming in Oct
im4p
406 - Trails I
Trail Connection to LRT 7001 1
72,000
72,000
Smithtown from West Borderto x002 r
357,500
357,500
Minnewashta Elem
Galpin Lake Rd T003 1
192,500
192,500
Mill Street T004 1
137,500
137,500
From 7141 to Chanhassen Trail T005 1
24,000 24,000
Smithtown from Minnewashta to 19 T006 1
412,500 412,500
Strawberry Lane T 007 1
192,500 192,500
County Road 19 from Pub Works to T00e 1
220,000 220,000
Excelsior
St, Albans Bay Rd T009 1
110,000 110,000
Edgewood Road TOM 1
165,000 165,000
Excelsior Blvd Trail Tii 1
30,000
30,000
406 - Trails Total
459,500 192,500 137,500
24,000 412,500 192,500 220,000 110,000 165,000 1,913,500
GRAD TOTAL,
459,500 192,500 137,500
24,000 412,500 192,500 220,000 110,000 165,000 1,913,500
TRAIL CONSTRUCTION FUND
Fund: 406 - Trail Capital Outlay
REVENUES
Beginning Fund Balance
Interest Earnings
G ra nts
Transfers in
Total Revenue
CAPITAL OUTLAY
Other Improvements
TOTAL CAPITAL OUTLAY
TOTAL EXPENDITURES
Revenue over /(under)
Ending Fund Balance
Actual Actual Actual
2009 2010 2011
Budget Budget
2012 2013
54,000
18,000 459,500
72,000 459,500
72,000 459,500
72,000 459,500
72,000 459,500
•
COMMUNITY INFRASTRUCTURE FUND
Fund: 450 - Community -wide Capital Outlay
REVENUES
Beginning Cash Balance
Interest Earnings
Miscellaneous Income
Transfersin
Total Revenues
EXPENDITURES
OTHER SERVICES
Miscellaneous Services
TOTAL OTHER SERVICES
CAPITAL OUTLAY
Other Improvements
TOTAL CAPITAL OUTLAY
Transfers out
Total
TOTAL EXPENDITURES
Revenue over /(under)
Ending Cash Balance
Actual Actual Actual Budget Budget
2009 2010 2011 2012 2012
1,000,000 1,867,783 1,679,410 1,669,810
13,206 15,827 8,400 8,300
1,000,000 854,590 - - -
1,000,000 867,796 15,827 8,400 8,300
13
13
150,068
150,068
54,132 18,000 459,500
- 54,132 18,000 459,500
- 13 204,200 18,000 459,500
1,000,000 867,783 (188,373) (9,600) (451,200)
1,000,000 1,867,783 1,679,410 1,669,810 1,218,610