Loading...
10-28-13 CC WS AgendaP CITY OF SHOREWOOD 5755 COUNTRY CLUB ROAD CITY COUNCIL WORK SESSION COUNCIL CHAMBERS MONDAY, OCTOBER 28, 2013 6:00 P.M. AGENDA 1. CONVENE CITY COUNCIL WORK SESSION A. Roll Call Mayor Zerby _____ Hotvet _____ Siakel _____ Sundberg _____ Woodruff _____ B. Review Agenda ATTACHMENTS 2. RATE STUDY Ehlers Report 3. CAPITAL IMPROVEMENT PLAN Administrator’s memo 4. ADJOURN #3 MEETING TYPE: CITY OF WORK SESSION SHOREWOOD 10/28/13  5755 Country Club Road Shorewood, Minnesota 55331 952-960-7900  Fax: 952-474-0128 www.ci.shorewood.mn.us cityhall@ci.shorewood.mn.us Date: October 23, 2013 To: Mayor and City Council Members From: Bill Joynes, City Administrator Cc: Bruce DeJong, Finance Director Re: Capital Improvement Plan _____________________________________________________________________________________ This memo is a summary of the direction Council gave staff at the October 14, 2013, Workshop and the recommended actions staff has for the implementation of those directives. The funding recommendations in each CIP and Enterprise fund below stem from the assumptions we made following your deliberations. They included:  First priority was to stabilize the Equipment / Technology / Building CIP  Proceeds from the Country Club House Sale would be credited to the Parks CIP and phase Badger Park improvements in conjunction with SouthShore Center decisions  Eliminate the Mill Street Trail from the Trails CIP in 2014 and proceed with Galpin in 2014 and Smithtown East in 2015  Use MSA Funds to support trail construction where appropriate  Use Sewer Fund reserve to support trail construction We have revised and recalculated financial information to comply with the above directions. What follows, by fund and program, is a set of recommended actions the Council may wish to consider to accomplish the above goals. Equipment / Technology / Building Capital Improvements Program We have moved future equipment purchases to the Sewer and Water Enterprise Funds where financing is more appropriate. That includes:  To Water: $315,000, consisting of four trucks and a compressor in 2014, 2015 and 2016  To Sewer: $216,000, consisting of a pump, a jetter, and a truck in 2014, 2016 and 2020 These changes have been communicated to Ehlers and are included in the information they will present at the workshop. With the transfer of the above equipment, the continuation of our yearly transfer and an additional $12- 15,000 a year from the levy or the General Fund Reserve, this CIP is balanced through 2023. Parks Capital Improvements Program  We recommend the deposit of the Country Club house sale proceeds in the amount of $288,000 be credited here.  Eliminate the Badger Park Hockey Rink relocation in 2014 for $40,000  Phase Badger Park improvements over two years: Playing field realignment in 2014 at $100,000 Road, parking lot and amenities in 2015 at $335,000 These changes will fund activities through 2016. To proceed with all other CIP items after 2016, $80,000 in additional revenue would be required. Trails Capital Improvements Program  MSA qualified transfer in 2013-2016 = $1,092,000  Storm Water Fund contributions for 25% of project costs in 2014 and 2015 = $461,200  Sewer Fund contributions in 2014 and 2015 = $306, 011 This assumes full construction of the County Road 19, Smithtown West, Excelsior Blvd., Galpin Lake and Smithtown East Trails through 2015. Any future trails will need additional funding sources. Sanitary Sewer and Storm Water Funds The above numbers assume the adoption by the Council of the recommended rates transmitted by the Ehlers study. Conclusions: The above actions are the staff recommendations put forth to accomplish the goals listed in the first section above. With these actions the Council still retains a significant amount of resources that can be used to fund future projects. At this date it is estimated that there are two main sources:  Water Fund Reserve= $3,000,000  General Fund Reserve = $1,500,000 (by adopting State Auditor standards) In addition, the Council could use various Bonding strategies, the use of Equipment Certificates, and will experience a reduction in yearly expenses for the Fire and Police Facility of about $510,000 in 2023. In the early part of 2014 the Council and Staff will meet to outline future goals and objectives at the yearly retreat. A future long range funding discussion would be appropriate at that time. City of Shorewood, Minnesota Capital Improvement Program 2013 thru 2022 :PROJECTS BY SOURCE Source # Priority 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Total ------ - - - - -- ------ - - - - -- 402 - Park Improvements Gideon Glen Signage & Parking Lot P0003 5 9,000 6,000 Freeman Plaza Po1oo 5 Freeman North Playground P0102 4 Equipment Freeman Parking Lot w/ MCWD P0103 5 Freeman Ball Field Lights P0104 5 Freeman Picnic Shelter Re -Roof P0105 4 Freeman Park - Eddy Station P0108 4 8,500 Freeman Ballfield Fence Polio 4 16,550 Freeman - Waterline for Community Poll' 4 Garden Cathcart Park - Resurface P0200 1 Tennis /Basketball Courts Cathcart Park Hockey Boards P0201 3 Cathcart Park Tot Lot P0202 5 Cathcart Parking Lot P0203 5 Badger Park - Creek Crossing P0300 3 Badger Park Tennis Courts P0301 2 Badger Park Field Improvements P0302 n/a Badger Park Parking & Road P0303 2 Badger Park Amenities P0304 2 Manor Park - Versa -Court Tennis P0400 1 30,000 Surface Manor Park - Water Source for P0401 1 8,000 Garden Manor Park - Shelter Outside Floor P0402 1 & Stoops Silverwood Park - Resurface 1/2 court P0500 2 Silverwood Park Equipment P0501 3 Silverwood Park Swing Set P0502 3 6,500 10,000 8,000 100,000 178,000 157,000 2,000 55,000 50,000 75,000 3,000 8,000 40,000 8,000 7,000 50,000 2,500 60,000 5,000 14,000 100,000 8,000 5,400 7,000 2,500 15,000 5,000 55,000 50,000 75,000 3,000 3,000 11,500 16,550 8,000 20,500 40,000 50,000 100,000 10,000 24,000 100,000 178,000 157,000 30,000 8,000 5,400 7,000 60,000 14,000 Thursday, October 24, 2013 -1 - -2- Source # Priority 2013 2014 . 2015 2016 . 2017 . 2018 2019 2020 2021. 2022 Total Skate Park Rehab P0600 3 75,000 75,000 Skate Park Picnic Shelter P0601 5 15,000 15,000 Skate Park - Community Garden P0602 5 5,000 5,000 Fencing 402 - Park Improvements Total 77,050 124,000 343,500 118,000 121,000 194,500 19,000 128,400 9,500 3,000 1,137,950 GRAND TOTAL 77,050 124,000 343,500 118,000 121,000 194,500 19,000 128,400 9,500 3,000 1,137,950 Thursday, October 24, 2013 -3- City Of Shorewood, Mnnps[t8 Cxn//n7 Improvement Program 2013 thru 2022 PROJECTS BY SOURCE Source # Priority 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Total Thursday, October 24, 2013 Replace Unit 21'o4' trailer mn u 1e,00 16,000 uTv replace unit 34 om s e0,00 20,000 Tractor - Ford oo10 m« « 54,000 54,000 Flatbed '*xo Replace unit 4o 049 s 44.000 44,000 Trailer 1u' replace unit oa m» s 15.000 15,000 Sand Pro 0000 replace Unit e* mw o 13.000 /o'000 Trailer 12' replace unit se 069 o 5,000 5,000 Dump Truck replace unit 7x 072 s 170.000 /n\mm Gmundomamo,Mower- Tnmaoao 075 z 28,000 31.000 59,000 replace unit ro Pickup 4A Replace Unit ro »m » 35,000 35,000 Pickup 000ww replace unit o1 08' o 42,000 42,000 Mowm, - nap|uoounitem 086 4 26,000 32,000 58,000 Pickup aooww replace unit n1 09' » 50,000 50,000 emunuamamo, Mower replace unit mo » 28,000 28,000 oo Plow and Sander ' One Ton Dump am « 155.000 155,000 Skid Steer replace unit or 097 s 55,000 55,000 owao»o, replace unit ee 099 o 178.335 /n\000 Boom Truck 100 » 84.000 84,000 Chipper m/ u 45.000 45.000 Blower for omunuamaute,-replace ^»' o 6,500 6,500 A01 Cab for mower replace A02 ^m » 8,000 8,000 Cab for mower replace A04 *w ^ 7.000 7,000 Mower Rear mm o 13.000 13,000 p|ei| Mower Side ^«« o 17.000 17,000 Blower for omunuumosto replace mm » 8.000 9,000 xo8 Thursday, October 24, 2013 -4- Source 14 Priority 2013 2014 2015 2016 2017 2018 2019 . 2020 2021 2022 Total Engine/Transmission Analysis A09 n/a 4,000 4,500 5,000 13,500 Station Replace Sander A10 3 14,000 14,000 Blower Attachment for Skid Steer Al2 4 12,500 12,500 Broom Attachment - Skid Steer A13 5 3,000 3,000 replace A13 Public Works Building PF -12 -01 n/a 4,000 10,000 81,000 95,000 Financial Software T -12 -03 2 90,000 90,000 Network Connection T-13 -01 2 20,000 20,000 Color Copier Replacement T -13 -03 2 9,000 10,000 19,000 Computer Upgrades T-99-99 1 20,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 110,000 - Equipment Replacement Fund Total 380,835 300,500 296,000 139,000 150,000 27,500 44,000 96,000 115,000 15,000 1,563,835 GRAND TOTAL. 380,835 300,500 296,000 139,000 150,000 27,500 44,000 96,000 115,000 15,000 1,563,835 Thursday, October 24, 2013 City of Shorewood, Minnesota Capital Improvement Program 2013 thru 2022 -5- Source # Priority 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 "Cotal 404 - Street Reconstruction Fund Elbert Point LR -13 -01 3 27,000 27,000 KcKinley Circle LR -13 -02 3 21,000 21,000 McLain Road LR-13-03 3 26,000 26,000 Shady Hills Rd (& Alley) LR -13 -04 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 -14 -01 4 36,000 36,000 Club Valley Road LR -14 -02 4 29,000 29,000 Lake Virginia drive LR -14 -03 4 63,000 63,000 Radisson Entrance LR -14-04 4 33,000 33,000 Shady Lane LR -14 -05 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 LP-15-01 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 -15 -05 5 453,000 453,000 Summit Avenue LR -15 -06 5 32,000 32,000 Amlee Road LR-16 -01 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 Manitou Lane LR -16 -04 5 317,000 317,000 McKinley Place N & S LR -16 -05 5 65,000 65,000 Shady Hills Circle LR -16 -06 5 51,000 51,000 Echo Road LR -17 -01 5 71,000 71,000 Howards Point Road LR -17 -02 5 180,000 180,000 Kathleen Court LR-17-03 5 22,000 22,000 Thzirsday, October 24, 2013 Ie Source # :Priority 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Total Oak Ridge Circle LR-17-04 5 29,000 29,000 Riviera Lane LR -17 -05 5 371,000 371,000 Shorewood Lane LR -17 -06 5 423,000 423,000 Mann Lane LR -18 -01 5 444,000 444,000 Maple Street LR -18 -02 5 100,000 100,000 Bayswater Road LR -19 -01 5 100,000 100,000 Boulder Circle LR -19 -02 5 49,000 49,000 Christmas Lane W LR -19 -03 5 32,000 32,000 Lilac Lane LR -19 -05 5 46,000 46,000 Strawberry Lane LR -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 LR -20 -03 5 629,000 629,000 West Lane LR -20 -04 5 32,000 32,000 Christmas Lane E LR-21-01 5 21,000 21,000 Christmas Lake Road LR -21 -02 5 107,000 107,000 Country Club Road LR -21-03 5 95,000 95,000 Chestnut Court & Chestnut Terrace LR -22 -01 5 58,000 58,000 Murray St LR -22 -02 5 82,000 82,000 Rampart Ct LR -22 -03 5 24,000 24,000 Silver Lake Trail LR -22 -04 5 47,000 47,000 Smithtown Circle LR -22 -05 5 25,000 25,000 Street Sign Replacement LR -99 -001 2 6,300 6,600 6,900 7,200 7,500 7,800 8,100 8,400 8,700 9,000 76,500 Maintenance - Bituminous Sealcoating LR -99 -100 1 220,000 270,000 228,000 245,000 184,000 238,000 305,000 274,000 255,000 248,000 2,467,000 G04 - Street Reconstruction Fund Total 961,300 768,600 931,900 1,094,200 1,287,500 789,800 658,100 1,069,400 486,700 493,000 8,540,500 GRAND TOTAL 961,300 768,600 931,900 1,094,200 1,287,500 789,800 658,100 1,069,400 486,700 493,000 8,540,500 Thursday, October 24, 2013 City of Shorewood, Minnesota Capital Improvement Program 2013 thru 2022 PROJECTS BY SOURCE Source 9 Priority 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Total 05 - MSA Road Reconstruction Fun I i Eureka Road N LR-19-04 5 1,922,000 1,922,000 VISA Road Reconstruction Fund Total 1,922,000 1,922,000 GRAND TOTAL 1,922,000 1,922,000 Thursday, October 24, 2013 City of Shorewood, Minnesota Capital Improvement Program 2013 thru 2022 M Source # Priority 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Total 4U6 Trails Co Rd 19 Trail - Connection to LRT T001 1 80,397 80,397 Smithtown - West Border to T002 1 1,460,000 1,460,000 Regional Trail Galpin Lake Rd Trail T003 1 680,100 680,100 Smithtown from Co Rd 19 to T006 1 703,500 703,500 Regional Trail Excelsior Blvd - Greenwood to T016 1 180,000 180,000 Barrington 406 - Trails Total 1,540,397 860,100 703,500 3,103,997 GRAND TOTAL 1,540,397 860,100 703,500 3,103,997 Thursday, October 24, 2013 Source # Priority 2013 2014 -8_ City of Shorewood, Mix`es01& (—>,n/&J7 Improvement Program 2013 Unu 2022 PROJECTS BY SOURCE 2016 2016 2017 2010 2019 2020 2021 2022 Total Tliursday, October 24, 2013 ^* unit 38 «m a 12,00 x\mm Dump Truck replace unit 65 ma o 1e5,00 165,000 Utility Truck w/cmne& toolbox om o 77,00 77,000 replace unit ro Utility Vehicle replace unit 77 077 * 26.000 26,000 Pick-up '4x^1oo Replace Unit ao mm » 35,000 35,000 Ramm|op Communications System W-/»w/ 1 80,000 80,000 Water Main Star Circle aLane W- 11~02 o/a 130.000 130,000 waterMoin - Gunnnm|ousne W-13-02 ma 100.000 100,000 W. Water Tower Rehab aPainting W-13-03 o 450.000 450\000 Hwnr Water Main Crossing W-13-05 o 311.300 311,300 001 - Water Fund Total 841.300 265,000 254,000 26,000 1,386,300 GRAND TOTAL 841.300 265,000 254.000 26.800 1.386,300 Tliursday, October 24, 2013 City of Shorewood, Minnesota Capital Improvement Program 2013 thru 2022 Source # Priority 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Total 611 - Sanitary Sewer Fund Sewer Jetter - replace unit 60 060 5 51,000 51,000 Dump Truck - Replace Unit 68 068 2 165,000 165,000 Radio /ISP Communications - Lift SS -10 -10 1 40,000 10,000 50,000 Station Retrofit Lift Station 11 Rehab - 20465 SS -13 -01 3 180,000 180,000 Radisson Rd. Lift Station 11 Force Main Separation SS -13 -02 3 194,800 194,800 Lift Station 9 Rehab - 20995 SS -14 -01 3 120,000 120,000 Minnetonka Blvd Lift Station 10 Rehab - 4773 SS -15 -01 3 80,000 80,000 Lakeway Terrace Lift Station 20 Rehab - 26550 Noble SS -16 -01 3 70,000 70,000 Road Lift Station 7 Rehab - 5600 SS -16 -02 3 80,000 80,000 Woodside Road Lift Station 18 Rehab - 4996 Shady SS -17 -01 3 10,000 10,000 Island Point Infiltration and Inflow Reduction SS- 99 -05 1 70,000 70,000 70,000 70,000 70,000 70,000 70,000 70,000 70,000 70,000 700,000 611 - Sanitary Sewer Fund Total 304,800 545,000 150,000 271,000 80,000 70,000 70,000 70,000 70,000 70,000 1,700,800 GRAND TOTAL 304,800 545,000 150,000 271,000 80,000 70,000 70,000 70,000 70,000 70,000 1,700,800 Thursday, October 24, 2013 City of Shorewood, Minnesota Capital Improvement Program 2013 thru. 2022 IN _C - 11 - Source # Priority 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Total 631 - Stormwater Management Fund i 4° pump replace unit 50 Q50 5 45,000 45,000 Galpin Lake Rd Trail Stormwater SS003 1 226,700 226,700 Smithtown Road Trail Stormwater SS006 1 234,500 234,500 Lake South Auto Drainage - WSB STM -12 -05 3 24,000 24,000 Report Valleywood Circle & Lane - Drainage STM -12 -08 4 142,000 142,000 Shorewood Lane Ditch STM -13 -01 4 70,000 70,000 Sunnyvale Lane Drainage STM -13 -02 4 192,000 192,000 Excelsior Blvd Drainage STM -13 -03 4 40,000 40,000 Club Valley Drainage STM -14 -01 4 101,000 101,000 6120 Riviera Drainage - WSB Report STM -14 -04 3 19,000 19,000 Star Circle & Lane STM -15 -01 5 31,000 31,000 Grant Lorenz STM -15 -02 5 50,000 50,000 50,000 150,000 23350 Academy Drainage STM -15 -04 4 75,000 75,000 Garden Road STM -15 -05 4 26,000 26,000 Amlee(Glen Road STM -16 -01 4 381,000 381,000 Manitou Lane STM -16 -02 4 75,000 75,000 Riveria Lane STM -17 -01 4 87,000 87,000 Shorewood Lane STM -17 -02 4 99,000 99,000 Mann Lane STM -18 -01 4 105,000 105,000 Maple St STM -18 -02 4 24,000 24,000 Eureka Road N STM -19 -01 4 452,000 452,000 Seamans Drive STM -20 -01 4 148,000 148,000 Rampart Ct. Drainage STM -22 -01 1 11,880 11,880 Storinwater Management Fund Total 40,000 774,700 416,500 506,000 236,000 129,000 452,000 193,000 11,880 2,759,080 GRAND TOTAL 40,000 774,700 416,500 506,000 236,000 129,000 452,000 193,000 11,880 2,759,080 Thursday, October 24, 2013 -12- 10/24/2013 City of Shorewood Financial Management Plan October 20, 2013 Park Improvement Fund - This fund covers capital expenditures for the replacement and improvement of park facilities 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected REVENUES 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Beginning Fund Balance 168,427 448,177 368,377 68,677 (7,023) (86,023) (238,923) (217,123) (305,123) (274,123) Park Dedication Fees 50,000 - - - - - - - - Interest Earnings* 800 2,200 1,800 300 - (400) (1,200) (1,100) (1,500) (1,400) Concession Sales - - - - - - Grants - - - - - - - - Transfers in 330,000 42,000 42,000 42,000 42,000 42,000 42,000 42,000 42,000 42,000 TOTAL REVENUES 380,800 44,200 43,800 42,300 42,000 41,600 40,800 40,900 40,500 40,600 EXPENDITURES OTHER SERVICES Contractrual Services Miscellaneous Charges - - - - - - - TOTAL OTHER SERVICES - - - - - - - CAPITAL OUTLAY Machinery and Equipment - - - - - - - - - Other Improvements 101,050 124,000 343,500 118,000 121,000 194,500 19,000 128,900 9,500 3,000 TOTAL CAPITAL OUTLAY 101,050 124,000 343,500 118,000 121,000 194,500 19,000 128,900 9,500 3,000 TOTAL EXPENDITURES 1011050 124,000 343,500 118,000 121,000 194,500 19,000 128,900 9,500 3,000 Revenue - Over /(under) 279,750 (79,800) (299,700) (75,700) (79,000) (152,900) 21,800 (88,000) 31,000 37,600 Ending Fund Balance 448,177 368,377 68,677 (7,023) (86,023) (238,923) (217,123) (305,123) (274,123) (236,523) Note: * Interest projected at 0.5% of fund balance City of Shorewood Financial Management Plan October 28, 2013 Equipment Replacement Fund REVENUES Beginning Balance Interest Earnings Miscellaneous Income Sale of Old Equipment Transfers in TOTAL REVENUES EXPENDITURES OTHER SERVICES Engineering Fees Contractual Services Miscellaneous Services Bank Charges TOTAL OTHER SERVICES CAPITAL OUTLAY Machinery and Equipment Fire SCBA Purchase TOTAL CAPITAL OUTLAY Transfers Out TOTAL EXPENDITURES Revenue over /(under) Ending Fund Balance 10/24/2013 - 1 3 - 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 613,693 294,158 67,158 (156,542) (224,342) (303,442) (260,442) (233,742) # # # # # ## # # # # # ## 2,800 1,500 300 (800) (1,100) (1,500) (1,300) (1,200) (1,300) (1,500) 58,500 72,000 72,000 72,000 72,000 72,000 72,000 72,000 72,000 72,000 61,300 73,500 72,300 71,200 70,900 70,500 70,700 70,800 70,700 70,500 380,835 300,500 .296,000 139,000 150,000 27,500 44,000 96,000 115,000 15,000 380,835 300,500 296,000 139,000 150,000 27,500 44,000 96,000 115,000 15,000 380,835 300,500 296,000 139,000 150,000 27,500 44,000 96,000 115,000 15,000 (319,535) (227,000) (223,700) (67,800) (79,100) 43,000 26,700 (25,200) (44,300) 55,500 294,158 67,158 (156,542) (224,342) (303,442) (260,442) (233,742) (258,942) (303,242) (247,742) 10/24/2013 City of Shorewood Financial Management Flan October 20, 2013 Street Maintenance Fund - This fund covers expenditures related to street reconstruction and sealcoating Revenue and. 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Actual Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected REVENUES 2009 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Beginning 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 1,625,965 1,760,337 1,528,137 1,481,137 1,270,637 896,837 327,837 253,637 310,837 (42,963) 184,138 11,142 8,800 7,600 7,400 6,400 4,500 1,600 1,300 1,600 (200) 900 700,000 714,000 714,000 714,000 714,000 714,000 714,000 714,000 714,000 714,000 714,000 700,000 722,800 721,600 721,400 720,400 718,500 715,600 715,300 715,600 713,801 714,901 955,000 768,600 931,900 1,094,200 1,287,500 789,800 658,100 1,069,400 486,700 493,000 955,000 768,600 931,900 1,094,200 1,287,500 789,800 658,100 1,069,400 486,700 493,000 717,464 955,000 768,600 931,900 1,094,200 1,287,500 789,800 658,100 1,069,400 486,700 493,000 (17,464) (232,200) (47,000) (210,500) (373,800) (569,000) (74,200) 57,200 (353,800) 227,101 221,901 1,608,501 1,528,137 1,481,137 1,270,637 896,837 327,837 253,637 310,837 (42,963) 184,138 406,039 -14- 10/24/2013 City of Shorewood Financial Management Plan October 28, 2013 MSA Street Construction Fund - This fund covers expenditures related to MSA street reconstruction 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected REVENUES 2013 2014 2015 2016 2017 2018 2019 2020 2021 2021 Beginning Balance MSA Construction Allocation Interest Earnings Transfers in Total Revenue EXPENDITURES CAPITAL OUTLAY Other Improvements TOTAL CAPITAL OUTLAY TOTAL EXPENDITURES Revenue over/(under) Ending Fund Balance 133,937 134,637 - - - 204,567 404,134 597,701 784,268 962,835 325,606 213,567 211,567 208,567 204,567 199,567 193,567 186,567 178,567 170,567 700 700 - - - 326,306 214,267 211,567 208,567 204,567 199,567 193,567 186,567 178,567 170,567 325,606 348,904 211,567 208,567 325,606 348,904 211,567 208,567 325,606 348,904 211,567 208,567 - - - - - - 700 (134,637) - - 204,567 199,567 193,567 186,567 178,567 170,567 134,637 204,567 404,134 597,701 784,268 962,835 1,133,402 -15- -16- 10/24/2013 City of Shorewood Financial Management Plan October 23, 2013 Trail Construction Fund - This fund covers expenditures related to local trails Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected REVENUES 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Beginning Balance (34,576) 180 - (208,567) Interest Earnings - - - MSA 325,606 348,904 211,567 208,567 Grants Transfers in from Sewer - 611 22,645 283,366 Transfers in from Comm Infr Fund - 450 1,214,791 488,371 - - Total Revenue 1,540,397 859,920 494,933 208,567 EXPENDITURES CAPITAL OUTLAY Other Improvements 1,505,641 860,100 703,500 - 'TOTAL CAPITAL OUTLAY 1,505,641 860,100 703,500 TOTAL EXPENDITURES 1,505,641 860,100 703,500 - Revenue over /(under) 34,756 (180) (208,567) 208,567 Ending Fund Balance 180 - (208,567) - 10/24/2013 City of Shorewood Financial Management Plan October 28, 2013 Community Infrastructure Fund - policies for the use of this fund are yet to be determined Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected REVENUES 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Beginning Balance Interest Earnings Miscellaneous Income Transfers in Total Revenues EXPENDITURES OTHER SERVICES Engineering Fees Contractual Services Miscellaneous Services Bank Charges TOTAL OTHER SERVICES CAPITAL OUTLAY Machinery and Equipment Other Improvements TOTAL CAPITAL OUTLAY Transfers out Operating Transfers Total TOTAL EXPENDITURES Revenue over/(under) Ending Fund Balance 1,692,262 8,500 485,971 2,400 8,500 2,400 1,214,791 488,371 1,214,791 488,371 1,214,791 488,371 (1,206,291) (485,971) 485,971