Loading...
11-10-14 CC WS AgendaPCITY OF SHOREWOOD CITY COUNCIL WORK SESSION MONDAY, NOVEMBER 10, 2014 GTa-"L 1. CONVENE CITY COUNCIL WORK SESSION A. Roll Call B. Review Agenda 2. ENTERPRISE BUDGET /CIP FUNDS FINAL REVIEW 3. ADJOURN 5755 COUNTRY CLUB ROAD COUNCIL CHAMBERS 5:35 PM, OR IMMEDIATELY FOLLOWING CANVASSING BOARD MEETING Mayor Zerby Hotvet Siakel Sundberg Woodruff ATTACHMENTS Finance Director's memo #2 MEETING TYPE City of Shorewood Council Meeting Item Work Session Title / Subject: Enterprise Fund & 2015 -2019 CIP Review Meeting Date: November 10, 2014 Prepared by: Bruce DeJong, Finance Director Reviewed by: Bill Joynes, City Administrator Larry Brown, Public Works Director Paul Hornby, City Engineer Attachments: Unfunded Project Listing CIP Projects by Funding Source Financial Management Plan Update Budget Worksheets Policy Consideration: How should the City of Shorewood prepare enterprise fund budgets and Capital Improvement Plans (CIP) for 2015 -2019? Background: City Council and Staff had a conversation regarding the CIP for 2015 -2019 on October 27. There are many challenges in regard to funding CIP projects as we continue to run into low cash balances in many of the funds for trails, parks, and equipment. This may necessitate various revenue raising methods including property taxes, transfers from enterprise funds (Water or Sewer), or possibly bonding. The 2015 Budget does anticipate increased funding for the Equipment Replacement and Street Reconstruction funds. There are major changes to the CIP from the one adopted for 2014 -2018 in Equipment Replacement, Street Reconstruction, Trails, and Storm Water. The Equipment Replacement fund needs to have a more specialized trail plow. This piece of equipment costs about $150,000. The good news is that it can also be fitted with attachments for mowing. As a result, we can avoid replacing the Ford tractor ($54K) and the side and rear mower attachments ($30K) that were planned in 2015. This gets us over halfway to the cost of the new machine and there is some trade value left in the old equipment. In Street Reconstruction, staff has added Glen Road to the 2016 work plan along with Amlee and Manitou. This project only anticipates the eastern portion of Glen Road along with storm water improvements. The proposed reconstructing Strawberry Lane and a West 62nd Street in 2019 instead of the seal coat that was planned. This is coordinated with constructing a trail and improving storm sewer processes in that area. This is a major increase in cost. We have also added Eureka Road N to the Street Reconstruction plan. In response to the City Council deciding against an MSA funded project, something needs to be done on the road. Staff is proposing a reclamation which is preliminarily estimated at $260,000. The Storm Water improvements associated with Eureka Road N are still included in this preliminary analysis waiting on some direction from City Council. In Trails, we have updated the numbers for all trail segments based on recent history and bidding. The Galpin Lake Road and Smithtown East trails will likely cost significantly more than was anticipated a year ago. The Strawberry Lane trail is basically extended south from Smithtown Road and curves around W 62nd Street to Cathcart Park. By constructing the trail in conjunction with road work there is some savings but the trail portion is now estimated to cost $1,135,000 including storm water and right of way costs. The Stormwater Fund absorbs new costs for Strawberry Lane and W 62nd in the amount of $283,000. This will have to be accomplished in conjunction with other regional improvements in the area storm water management around Freeman Park and Shorewood Oaks area. The primary challenge in the Park Improvement Fund is deciding what to do in Badger Park. The current Badger Park plans are over $1,300,000 with a phased approach and staff and WSB are reviewing what can possibly be done to reduce the cost. Even with the more modest estimate of about $523,000 included in the 2014 -2015 CIP can't be funded from current resources. The Park Improvement Fund has about $213,000 in fund balance at year end 2013 - less about $4,000 of remaining project costs for 2014 projects. There may be park dedication fees of The Water Fund will postpone a couple of projects from 2014 to 2015. This is the result of the west water tower inspection. There was freeze damage that makes cleaning and repainting more difficult which will require more time than will be available this fall after the sprinkling season. This will also delay the radio /ISP project until 2015. Both projects are adequately funded and delaying a year doesn't pose any problem from the staff viewpoint. Financial or Budget Considerations: The challenge is to determine the most acceptable financing method for the projects the City Council wants to undertake. There are resources available to pay for many of the contemplated projects, but the timing of those projects and the specific funding is debatable since there is no one "right way" to cover these costs. The enterprise funds were reviewed to determine appropriate rates to cover all the costs associated with the operations. The Storm Water fund rates need to be increased but a determination of how much of the storm water work associated with trails is crucial to that process. The Sewer and Water funds have cash balances in excess of what is necessary for operations and much of that could be transferred out to other capital projects. The trail projects have been designed to State Aid (MSA) standards and part or all of the MSA construction allocations that the city receives could be allocated to trails. Eureka Road North was the only street project anticipated to use MSA funds, but the road could be reclaimed in its current configuration for significantly less than the amount required to meet MSA standards. This would potentially free up funds for the trail projects. There are no other MSA construction plans at this point. The budgets are very dependent on the capital projects that are adopted. We will review utility rates after CIP projects are determined along with their funding sources. Options: The City Council is encouraged to discuss any capital project changes with staff. Recommendation / Action Requested: Staff recommends that the City Council determine which projects it wants to fund and how the costs should be allocated between funds prior to the adoption of the preliminary levy later this summer. Next Steps and Timelines: The City Administrator and Finance Director intend to continue discussions regarding capital and budget items through the Truth -in- Taxation hearing in December. Connection to Vision / Mission: Adopting a prudent capital plan contributes to sound financial management. Unfunded Project Listing by Type 11/10/2014 Project Cost Available Gap Trails Excelsior Blvd 300,000 180,000 120,000 Galpin Lake Road 1,560,000 910,100 649,900 Smithtown East 1,340,000 988,500 351,500 Strawberry Lane 1,135,000 283,000 852,000 4,335,000 2,361,600 1,973,400 * Available includes Storm water costs Streets - Glen Road 1,145,000 1,145,000 Strawberry Lane 1,140,000 1,140,000 2,285,000 - 2,285,000 Park & Recreation Badger Park 1,323,797 575,000 748,797 Southshore Center 344,400 - 344,400 1,668,197 575,000 1,093,197 Misc - Green Energy 50,000 50,000 - Consultant Fees - Golf Course 75,000 75,000 125,000 50,000 75,000 Totals 8,413,197 2,986,600 5,426,597 Financing Options Borrowing from Water and /or Sewer Funds Repayment Each $50,000 payment equals 1% tax levy increase Bonding General Obligation Each $50,000 payment equals 1% tax levy increase Capital Improvement Each $50,000 payment equals 1% tax levy increase EDA Lease Revenue Each $50,000 payment equals 1% tax levy increase Bonding $480,000 over 10 years = $50,000 annual payment Park Dedication Fees $5,000 per lot Potential of up to $500,000 from golf course development Public Safety Bonds repaid E Fire Bonds Last year for debt service is 2021- Save $79,000 W Fire Bonds Last year for debt service is 2022 - Save $200,000 Police Bonds Last year for debt service is 2022 - Save $224,000 There will likely be some annual amount needed for building maintenance that will reduce the savings from the expiring bond issues. City of Shorewood, Minnesota Capital Improvement Program 2015 thru 2019 Source Project# Priority 2015 2016 2017 2018 2019 Total [02 -Park Improvements _ Gideon Glen Signage & Parking Lot P0003 5 25,000 25,000 Freeman Plaza P0100 5 Sweeper - replace unit 46 5,000 5,000 Freeman North Playground Equipment P0102 4 55,000 55,000 Freeman Parking Lot w/ MCWD P0103 5 50,000 50,000 Freeman Ball Field Lights P0104 5 Trailer 18' replace unit 59 75,000 75,000 Freeman - Waterline for Community Garden P0111 4 8,000 8,000 Cathcart Park - Resurface Tennis /Basketball Courts P0200 1 6,500 7,000 13,500 Cathcart Park Hockey Boards P0201 3 40,000 072 40,000 Cathcart Park Tot Lot P0202 5 50,000 50,000 Badger Park - Phase 1 P0300 3 577,000 38,000 577,000 Badger Park Tennis Courts P0301 2 8,000 8,000 16,000 Badger Park - Phase 2 P0302 n/a 747,000 747,000 Silverwood Park - Resurface 1/2 court P0500 2 2,000 2,500 4,500 Silverwood Park Equipment P0501 3 Boom Truck 60,000 60,000 Silverwood Park Swing Set P0502 3 14,000 14,000 Skate Park Rehab P0600 3 75,000 45,000 75,000 402 - Park Improvements Total 618,500 862,000 113,000 202,500 19,000 1,815,000 X403 - Equipment Replacement Fund UTV - replace unit 34 034 5 20,000 20,000 Sweeper - replace unit 46 046 5 4,000 4,000 Flatbed - 4 x 2 Replace unit 49 049 5 44,000 44,000 Trailer 18' replace unit 59 059 5 15,000 15,000 Sand Pro 3000 - replace Unit 64 064 2 13,000 13,000 Dump Truck - replace unit 72 072 5 170,000 170,000 Pickup 44 - Replace Unit 78 078 3 38,000 38,000 Pickup - 350 44 replace unit 81 081 5 42,000 42,000 Groundsmaster Mower replace unit 93 093 5 28,000 28,000 Boom Truck 100 5 84,000 84,000 Chipper 101 5 45,000 45,000 Trackless Trail Machine wl Flail Mower 103 1 150,000 150,000 Cab & Blower for mower- replace A04 A04 4 21,000 21,000 EnginelTransmission Analysis Station A09 n/a 4,500 4,500 Replace Sander A10 3 14,000 14,000 Plow Blade & Snow Kit for Skid Steer All 3 7,500 7,500 South Shore Community Center PF -11 -01 n/a 2,500 43,000 41,000 86,500 Public Works Building PF -12 -01 n/a 81,000 81,000 Computer Upgrades T -99 -99 1 10,000 10,000 10,000 10,000 10,000 50,000 403 - Equipment Replacement Fund Total 427,500 194,500 183,000 68,500 44,000 917,500 Thursday, November 06, 2014 Source Proiect# Priority 2015 2016 2017 2018 2019 Total X404 - Street Reconstruction Fund Chaska Road LR -15 -01 5 87,000 1405 - MSA Road Reconstruction Fund 87,000 Mayflower Road LR -15 -02 5 33,000 8,000 8,000 Total 33,000 McKinley Court LR -15 -03 5 40,000 Galpin Lake Rd Sidewalk T003 40,000 Murray Hill Road LR -15 -04 5 52,000 1,340,000 Strawberry Lane & W 62nd T007 1 852,000 52,000 Star Circle & Lane LR -15 -05 5 453,000 406 - Trails Total 2,970,000 852,000 3,822,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 Glen Road East LR -16 -07 5 927,000 927,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 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 455,000 455,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 & W 62nd LR -19 -06 5 1,140,000 1,140,000 Vine Street LR -19 -07 5 33,000 33,000 Eureka Road N LR -19 -08 5 260,000 260,000 Street Sign Replacement LR -99 -001 2 6,900 7,200 7,500 7,800 8,100 37,500 Maintenance- Bituminous Sealcoating LR -99 -100 1 228,000 245,000 184,000 238,000 305,000 1,200,000 404 - Street Reconstruction Fund Total 931,900 2,021,200 1,319,500 789,800 1,973,100 7,035,500 1405 - MSA Road Reconstruction Fund Christmas Lake Rd Signal Refurbish MSA -1501 nla 8,000 8,000 405 - MSA Road Reconstruction Fund 8,000 8,000 Total 406 - Trails Galpin Lake Rd Sidewalk T003 1 1,330,000 1,330,000 Smithtown from Cc Rd 19 to Regional Trail T006 1 1,340,000 1,340,000 Strawberry Lane & W 62nd T007 1 852,000 852,000 Excelsior Blvd - Greenwood to Barrington T016 1 300,000 300,000 406 - Trails Total 2,970,000 852,000 3,822,000 [601 - Water Fund Air Compressor - Replace unit 38 038 3 12,000 12,000 Utility Truck w /crane & toolbox replace unit 76 076 5 77,000 77,000 Utility Vehicle - replace unit 77 077 4 27,000 27,000 Thursday, November 06, 2014 Source Project# Priority 2015 Pick -up - 4 x 4 150 Replace Unit 80 080 5 35,000 RadiollSP Communications System W -10 -01 1 80,000 Water Main - Star Circle & Lane W -11 -02 nla 130,000 W. Water Tower - Rehab & Painting W -13 -03 3 450,000 601 - Water Fund Total 784,000 [611 - Sanitary Sewer Fund Sewer Jetter - replace unit 60 060 Lift Station 10 Rehab - 4773 Lakeway Terrace SS -15 -01 Lift Station 20 Rehab - 26550 Noble Road SS -16 -01 Lift Station 7 Rehab - 5600 Woodside Road SS -16 -02 Lift Station 18 Rehab - 4996 Shady Island Point SS -17 -01 Infiltration and Inflow Reduction SS -99 -05 611 -Sanitary Sewer Fund Total 631 - Stormwater Management fund Galpin Lake Rd Trail Stormwater SS003 Smithtown Road Trail Stormwater SS006 Shorewood Lane Ditch STM -13 -01 Star Circle & Lane STM -15 -01 23350 Academy Drainage STM -15 -04 Garden Road STM -15 -05 Amlee Road STM -16 -01 Manitou Lane STM -16 -02 Glen Road East STM -16 -03 Riveria Lane STM -17 -01 Shorewood Lane STM -17 -02 Mann Lane STM -18 -01 Maple St STM -18 -02 Eureka Road N STM -19 -01 Strawberry & W 62nd STM -19 -02 631 - Stormwater Management Fund 26,000 Total 78,000 GRAND TOTAL 2016 2017 2018 2019 Total 5 3 80,000 3 3 3 1 70,000 51,000 70,000 80,000 70,000 10,000 70,000 70,000 70,000 51,000 80,000 70,000 80,000 10,000 350,000 150,000 271,000 80,000 70,000 70,000 641,000 1 230,000 230,000 1 285,000 285,000 4 172,500 172,500 5 31,000 31,000 4 75,000 75,000 4 26,000 26,000 4 78,000 78,000 4 75,000 75,000 4 218,000 218,000 4 87,000 87,000 4 99,000 99,000 4 105,000 105,000 4 24,000 24,000 4 452,000 452,000 4 283,000 283,000 819,500 371,000 186,000 129,000 735,000 2,240,500 6,709,400 3,746,700 1,881,500 1,259,800 3,693,100 17,290,500 Thursday, Noveniber 06, 2014 11/6/2014 LIUMM ••r R"Mm" . rqxvelr�ely"l November 10, 2014 101 Park Improvement Fund - This fund covers capital expenditures for the improvement of park facilities 0.0% 0.0% 0.0% 0.0% Actual Budget Projected Projected Projected Projected Projected REVENUES 2013 2014 2015 2016 2017 2018 2019 Beginning Fund Balance 168,427 213,366 566,580 (7,120) (827,120) (902,220) (1,067,220) Park Dedication Fees 55,000 30,000 - - - - - Interest Earnings* 966 800 2,800 - (4,100) (4,500) (5,300) Concession Sales - - - - - - - Grants - - - - - - - Transfers in 42,000 325,414 42,000 42,000 42,000 42,000 42,000 TOTAL REVENUES 97,966 356,214 44,800 42,000 37,900 37,500 36,700 EXPENDITURES OTHER SERVICES Contractrual Services - - - - - - - Miscellaneous Charges - - - - - - - TOTAL OTHER SERVICES CAPITAL OUTLAY Machinery and Equipment - - - - - - - Other Improvements 53,027 3,000 618,500 862,000 113,000 202,500 19,000 TOTAL CAPITAL OUTLAY 53,027 3,000 618,500 862,000 113,000 202,500 19,000 TOTAL EXPENDITURES 53,027 3,000 618,500 862,000 113,000 202,500 19,000 Revenue - Over /(under) 44,939 353,214 (573,700) (820,000) (75,100) (165,000) 17,700 Ending Fund Balance 213,366 566,580 (7,120) (827,120) (902,220) (1,067,220) (1,049,520) Note: * Interest projected at 0.5% of fund balance 2014 2015 2016 2017 2018 2019 Expenditures 3,000 618,500 862,000 113,000 202,500 19,000 Fund Balance 566,580 (7,120) (827,120) (902,220) (1,067,220) (1,049,520) 11/6/2014 City of Shorewood Financial Management Plan November 10, 2014 Equipment Replacement Fund 7 500,000 i 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 200,000 Actual Budget Projected Projected Projected Projected Projected REVENUES 2013 2014 2015 2016 2017 2018 2019 Beginning Balance 613,693 413,263 423,763 88,363 (15,737) (108,837) (87,837) Interest Earnings 6,809 21,000 2,100 400 (100) (500) (400) Miscellaneous Income - - - - Sale of Old Equipment - - - - - - - Transfers in 58,500 75,000 90,000 90,000 90,000 90,000 90,000 TOTAL REVENUES 65,309 96,000 92,100 90,400 89,900 89,500 89,600 EXPENDITURES OTHER SERVICES Engineering Fees - - - - - - - Contractual Services - - - - - - - Miscellaneous Services - - - - - - - Bank Charges TOTAL OTHER SERVICES - - - - - - - CAPITAL OUTLAY Machinery and Equipment 265,739 85,500 427,500 194,500 183,000 68,500 44,000 Fire SCBA Purchase - - - - - - - TOTAL CAPITAL OUTLAY 265,739 85,500 427,500 194,500 183,000 68,500 44,000 Transfers Out TOTAL EXPENDITURES 265,739 85,500 427,500 194,500 183,000 68,500 44,000 Revenue over /(under) (200,430) 10,500 (335,400) (104,100) (93,100) 21,000 45,600 Ending Fund Balance 413,263 423,763 88,363 (15,737) (108,837) (87,837) (42,237) This is a Joan and repayment for the Excelsior Fire District SCBq'equipment purchased in 2011. 403 2014 2015 2016 2017 2018 2019 Available funds in 401- Public Facilities Expenditures 85,500 427,500 194,500 183,000 68,500 44,000 Available funds in 408 - Technology Fund BalancE 423,763 88,363 (15,737) (108,837) (87,837) (42,237) 500,000 i 400,000 300,000r 200,000 Expenditures 1, Fund Balance 100,000 3 1 2 3 6 (200,000) -- - - -.__ 11/6/2014 City of Shorewood Financial Management Plan November 10, 2014 Street Maintenance Fund - This fund covers expenditures related to street reconstruction and sealcoating 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% REVENUES 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 Actual Budget Projected Projected Projected Projected Projected 2013 2014 2015 2016 2017 2018 2019 1,760,337 2,143,328 1,509,428 1,310,028 20,428 (573,972) (641,672) 9,013 10,700 7,500 6,600 100 (2,900) (3,200) 714,000 725,000 725,000 725,000 725,000 725,000 725,000 723,013 735,700 732,500 731,600 725,100 722,100 721,800 340,022 1,369,600 931,900 2,021,200 1,319,500 789,800 1,973,100 340,022 1,369,600 931,900 2,021,200 1,319,500 789,800 1,973,100 340,022 1,369,600 931,900 2,021,200 1,319,500 789,800 1,973,100 382,991 (633,900) (199,400) (1,289,600) (594,400) (67,700) (1,251,300) 2,143,328 1,509,428 1,310,028 20,428 (573,972) (641,672) (1,892,972) 2014 2015 2016 2017 2018 2019 Expenditures 1,369,600 931,900 2,021,200 1,319,500 789,800 1,973,100 Fund Balance 1,509,428 1,310,028 20,428 (573,972) (641,672) (1,892,972) 11/6/2014 City of Shorewood Financial Management Plan November 10, 2014 7 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% REVENUES Actual 2013 Budget 2014 Projected 2015 Projected 2016 Projected 2017 Projected 2018 Projected 2019 Beginning Balance 133,937 134,637 149,394 465,000 785,606 1,102,212 1,413,818 MSA Construction Allocation 325,606 475,000 323,606 320,606 316,606 311,606 305,606 Interest Earnings 700 700 - - - Transfers in - - - - - - - Total Revenue 326,306 475,700 323,606 320,606 316,606 311,606 305,606 EXPENDITURES CAPITAL OUTLAY Other Improvements 325,606 460,943 8,000 - - - TOTAL CAPITAL OUTLAY 325,606 460,943 8,000 - - - - TOTAL EXPENDITURES 325,606 460,943 8,000 - - - - Revenue over /(under) 700 14,757 315,606 320,606 316,606 311,606 305,606 Ending Fund Balance 134,637 149,394 465,000 785,606 1,102,212 1,413,818 1,719,424 MSA Construction Account - assumes $213,; 325,606 475,000 assumes $213,567 annual allocation with actual balance from 2012 Amount goes down as new cities and roads qualify 323,606 320,606 316,606 311,606 305,606 -2000 -3000 -4000 -5000 -6000 11/6/2014 10 City of Shorewood Financial Management Plan November 10, 2014 Trail Construction Fund - This fund covers expenditures related to local trails Actual Budget Projected Projected Projected Projected Projected REVENUES 2013 2014 2015 2016 2017 2018 2019 Beginning Balance (34,576) 971,959 (1,998,041) (1,998,041) (1,998,041) (1,998,041) Interest Earnings - - - - - - MSA Grants Transfers in from MSA - 405 460,943 Transfers in from Sewer - 611 22,645 Transfers in from Comm Infr Fund - 450 1,476,000 488,371 - - - - - Total Revenue 1,476,000 971,959 - - - - EXPENDITURES CAPITAL OUTLAY Other Improvements 1,493,861 - 2,970,000 - - - 852,000 TOTAL CAPITAL OUTLAY 1,493,861 - 2,970,000 - - - 852,000 TOTAL EXPENDITURES 1,493,861 - 2,970,000 - - - 852,000 Revenue over /(under) (17,861) 971,959 (2,970,000) - - - (852,000) Ending Fund Balance (52,437) 971,959 (1,998,041) (1,998,041) (1,998,041) (1,998,041) (2,850,041) 2014 2015 2016 2017 2018 2019 Expenditures - 2,970,000 - - - 852,000 Fund Balance 971,959 (1,998,041) (1,998,041) (1,998,041) (1,998,041) (2,850,041) 11/6/2014 11 City of Shorewood Financial Management Plan November 10, 2014 Community Infrastructure Fund - policies for the use of this fund are yet to be determined Actual Budget Projected Projected Projected Projected Projected REVENUES 2013 2014 2015 2016 2017 2018 2019 Beginning Balance 1,692,262 219,907 221,007 172,107 173,007 173,907 174,807 Interest Earnings 7,194 1,100 1,100 900 900 900 900 Miscellaneous Income - - - - - - - Transfers in - - - - - - - Total Revenues 7,194 1,100 1,100 900 900 900 900 EXPENDITURES OTHER SERVICES - - - - - - - Engineering Fees - - - Contractual Services - 50,000 - - Miscellaneous Services - - - - Bank Charges - - - - TOTAL OTHER SERVICES 50,000 - - CAPITAL OUTLAY Machinery and Equipment - - - - - Other Improvements 3,549 - - - TOTAL CAPITAL OUTLAY 3,549 - - - - Transfers out 1,476,000 - - - Operating Transfers - - - - Total 1,476,000 - - TOTAL EXPENDITURES 1,479,549 - 50,000 - - - - Revenue over /(under) (1,472,355) 1,100 (48,900) 900 900 900 900 Ending Fund Balance 219,907 221,007 172,107 173,007 173,907 174,807 175,707 11/6/2014 City of Shorewood Financial Management Plan November 10, 2014 Water Utility Fund - This fund is to be used for all water services 0.0% 0.0% Actual Budget 2013 2014 0.0% 0.0% Budget Budget 2015 2016 0.0% 0.0% Budget Budget 2017 2018 12 0.0% Budget 2019 REVENUES 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% ##k## Water Sales 494,202 630,000 630,000 630,000 630,000 630,000 630,000 #### Special Assessments 37,492 15,000 15,000 15,000 15,000 15,000 15,000 # # ## Permits & Connection Fees 41,200 15,000 15,000 15,000 15,000 15,000 15,000 # ### Interest Earnings 17,887 35,000 35,450 28,450 28,870 29,470 30,060 #### Water Meter Sales 4,820 2,500 2,500 2,500 2,500 2,500 2,500 ## ## Antennae Space Rental 0 0 0 0 0 0 0 Total Revenues 595,601 697,500 697,950 690,950 691,370 691,970 692,560 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% EXPENSES 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% Personal Services 101 Regular Salaries 73,949 79,796 81,392 83,020 84,680 86,374 88,101 102 O.T. Salaries 8,424 3,000 3,060 3,121 3,184 3,247 3,312 121 PERA City Share 5,941 6,003 6,123 6,246 6,370 6,498 6,628 122 FICA City Share 5,899 6,334 6,461 6,590 6,722 6,856 6,993 131 Ins. City Share 12,784 12,726 12,981 13,240 13,505 13,775 14,051 Total Personal Services 106,997 107,859 110,016 112,217 114,461 116,750 119,085 Supplies 200 Office Supplies 146 - - - - - - 208 Postage 1,308 1,400 1,428 1,457 1,486 1,515 1,546 212 Motor Fuel & Lube - - - - - - - 221 Maint- Equipment 4,332 6,500 6,630 6,763 6,898 7,036 7,177 223 Maint- Buildings 760 1,000 1,020 1,040 1,061 1,082 1,104 240 Small Tools - 550 561 572 584 595 607 245 General Supplies 13,887 10,000 10,200 10,404 10,612 10,824 11,041 260 Wtr Purch - Tonka Bay 2,121 3,500 3,570 3,641 3,714 3,789 3,864 261 Wtr Purch - Excelsior 18,267 22,000 22,440 22,889 23,347 23,814 24,290 262 Wtr Purch - Mtka 881 1,500 1,530 1,561 1,592 1,624 1,656 263 Wtr Purch - Chan 9,498 16,000 16,320 16,646 16,979 17,319 17,665 265 Water Meters 6,926 15,000 15,300 15,606 15,918 16,236 16,561 Total Supplies 58,126 77,450 78,999 80,579 82,191 83,834 85,511 Other Services & Charges 301 Financial & Audit 2,250 2,500 2,550 2,601 2,653 2,706 2,760 302 Consulting 1,383 5,000 5,100 5,202 5,306 5,412 5,520 321 Communication 663 2,800 2,856 2,913 2,971 3,031 3,091 331 Travel, Conf,Sch - 800 816 832 849 866 883 351 Print /Publish 552 1,000 1,020 1,040 1,061 1,082 1,104 360 Insurance -Total 8,000 8,000 8,160 8,323 8,490 8,659 8,833 394 Utilities - Amesbury 12,368 12,000 12,240 12,485 12,734 12,989 13,249 395 Utilities - Badger 9,270 12,500 12,750 13,005 13,265 13,530 13,801 396 Utilities - Boulder Bridge 21,097 20,000 20,400 20,808 21,224 21,649 22,082 397 Utilities - Woodhaven - - - - - - - 398 Utilities - SE Area /Tower 34,917 33,000 33,660 34,333 35,020 35,720 36,435 400 Contractual 26,018 30,000 30,600 31,212 31,836 32,473 33,122 410 Rental - - - - - - - 11/6/2014 13 Actual Budget Budget Budget Budget Budget Budget 2013 2014 2015 2016 2017 2018 2019 433 Subscrip- Member - - - - - 437 Licenses -Sales Taxes - 3,000 3,060 3,121 3,184 3,247 3,312 440 Misc. Services 635 200 204 208 212 216 221 450 Bank Svc Chgs 8 1,000 1,020 1,040 1,061 1,082 1,104 Debt Service Total Other Services & Charges 117,161 131,800 134,436 137,125 139,867 142,665 145,518 Capital Outlay 540 Machinery -Equip - 245,000 204,000 27,000 580 Other Improve 193,950 100,000 580,000 - - Total Capital Outlay 193,950 345,000 784,000 27,000 - - - Debt Service 601 Bond Principal - 190,000 195,000 205,000 215,000 220,000 230,000 611 Bond Interest 74,887 91,303 81,555 73,808 65,595 57,010 48,050 620 Fiscal Agent Fees 49,908 1,500 1,500 1,500 1,500 1,500 1,500 Total Debt Service 124,795 282,803 278,055 280,308 282,095 277,010 278,050 Total Transfers - 12,500 12,500 12,500 12,500 12,500 12,500 TOTAL EXPENDITURES 601,029 957,412 1,398,006 649,728 631,114 632,759 640,664 REVENUES OVER /(UNDER) EXPENDITURES (5,428) (259,912) (700,056) 41,222 60,256 59,211 51,896 Beginning Cash Balance 3,810,729 3,805,301 3,545,389 2,845,333 2,886,555 2,946,812 3,006,023 Ending Cash Balance 3,805,301 3,545,389 2,845,333 2,886,555 2,946,812 3,006,023 3,057,919 5,428 259,912 700,056 (41,222) (60,256) (59,211) (51,896) - (0) 0 (0) (0) 2014 2015 2016 2017 2018 2019 Expenditures 957,412 1,398,006 649,728 631,114 632,759 640,664 Cash Balam 3,545,389 2,845,333 2,886,555 2,946,812 3,006,023 3,057,919 11/6/2014 14 City of Shorewood Financial Management Plan November 10, 2014 Sewer Utility Fund - This fund is to be used for all provisions of sewer services 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Actual Budget Budget Budget Budget Budget Budget 2013 2014 2015 2016 2017 2018 2019 REVENUES 2.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 33635 MCES I & 1 Grant - - - - - - - 36210 Interest Earnings 14,191 36,000 23,220 21,200 14,970 13,610 13,870 36240 Refunds /Reimburse 3,139 2,500 2,575 2,652 2,732 2,814 2,898 37250 Metro Sac Charges 5,092 5,197 5,353 5,513 5,679 5,849 6,025 37210 Sewer Sery Charges 802,377 835,000 860,000 886,000 912,500 940,000 968,000 37220 Sewer Chg -Cnty Coll 28,882 10,787 11,111 11,444 11,787 12,141 12,505 37250 Local SAC Charges 13,200 - - - - - - 37270 Sewer Permits 3,060 700 700 700 700 700 700 39201 Tsfr From Other Funds - - - - - - - Total Revenues 861,710 871,700 883,920 907,900 928,170 954,310 982,570 EXPENSES 2.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% Personal Services 2.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 101 Regular Salaries 68,010 69,186 71,262 73,399 75,601 77,869 80,206 102 O.T. Salaries 3,139 2,500 2,575 2,652 2,732 2,814 2,898 121 PERA City Share 5,092 5,197 5,353 5,513 5,679 5,849 6,025 122 FICA City Share 5,093 5,484 5,649 5,818 5,993 6,172 6,357 131 Ins. City Share 10,293 10,787 11,111 11,444 11,787 12,141 12,505 Total Personal Services 91,627 93,154 95,949 98,827 101,792 104,846 107,991 Supplies 208 Postage 1,470 1,650 1,700 1,750 1,803 1,857 1,913 212 Motor Fuel & Lube - - - - - - - 221 Maint- Equipment 3,382 5,000 5,150 5,305 5,464 5,628 5,796 Small Tools 732 550 567 583 601 619 638 General Supplies 1,293 2,100 2,163 2,228 2,295 2,364 2,434 Total Supplies 6,877 9,300 9,579 9,866 10,162 10,467 10,781 Other Services & Charges 300 Financial & Audit 2,250 2,500 2,575 2,652 2,732 2,814 2,898 308 Consulting 10,753 5,000 5,150 5,305 5,464 5,628 5,796 313 Engineering - Design Stage 1,701 5,000 5,150 5,305 5,464 5,628 5,796 321 Communication 4,103 4,500 4,635 4,774 4,917 5,065 5,217 331 Travel, Conf,Sch 975 1,500 1,545 1,591 1,639 1,688 1,739 360 Insurance -Total 6,500 7,000 7,210 7,426 7,649 7,879 8,115 380 Utilities- Gas /Elec 5,588 7,500 7,725 7,957 8,195 8,441 8,695 385 MCES Service Charges 529,386 575,000 592,250 610,018 628,318 647,168 666,583 386 Excelsior Sewer Chg 31,676 31,000 31,930 32,888 33,875 34,891 35,937 400 Contractual 17,940 20,000 20,600 21,218 21,855 22,510 23,185 433 Dues & Subscriptions - - - - - - - 440 Misc. Services 33,983 150 155 159 164 169 174 450 Service Charges - 1,500 1,545 1,591 1,639 1,688 1,739 Total Other Services & Charges 644,855 660,650 680,470 700,884 721,910 743,567 765,874 Capital Outlay 540 Machinery -Equip - 175,000 51,000 - 580 Other Improve 399,790 370,000 150,000 220,000 80,000 70,000 70,000 Total Capital Outlay 399,790 545,000 150,000 271,000 80,000 70,000 70,000 Transfers 11/6/2014 15 Actual Budget Budget Budget Budget Budget Budget 2013 2014 2015 2016 2017 2018 2019 720 Permanent - 226,700 234,500 12,500 12,500 12,500 12,500 720 Interfund Loan - 475,000 150,000 450,000 150,000 Total Transfers - 475,000 150,000 450,000 150,000 - - TOTAL EXPENDITURES 1,143,149 1,783,104 1,085,997 1,530,577 1,063,864 928,880 954,647 REVENUES OVER /(UNDER) EXPENDITURES (281,439) (911,404) (202,077) (622,677) (135,694) 25,430 27,923 Beginning Cash Balance 3,514,714 3,233,275 2,321,871 2,119,794 1,497,117 1,361,423 1,386,852 Ending Cash Balance 3,233,275 2,321,871 2,119,794 1,497,117 1,361,423 1,386,852 1,414,776 2014 2015 2016 2017 2018 2019 Expenditures 1,783,104 1,085,997 1,530,577 1,063,864 928,880 954,647 Cash Balanef 2.321.871 2.119,794 1,497,117 1,361,423 1.386.852 1.414.776 11/6/2014 City of Shorewood Financial Management Plan November 10, 2014 Recycling Utility Fund - This fund accounts for all revenues and expenses related to residential recycling TOTAL EXPENDITURES 0.0% 0.0% 0.0% M% 0.0% 0.0% 0.0% Actual Budget Budget Budget Budget Budget Budget REVENUES 2013 2014 2015 2016 2017 2018 2019 # # ## County Recycling Aid 25,830 23,000 21,000 21,000 21,000 21,000 21,000 #### Interest Earnings 253 350 521 768 1,003 1,225 1,434 #### Recycling Service Charges 160,628 155,000 155,000 155,000 155,000 155,000 155,000 #### City Clean -up Fees 5,086 8,000 8,000 8,000 8,000 8,000 8,000 #### Recycling Bin Sales - - - - - - - #### Revenue from Contractor - - - - - - - #### Transfers from Other Funds - - - - - - 132,821 Total Revenues 191,797 186,350 184,521 184,768 185,003 185,225 185,434 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% EXPENSES 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% 2.0% Personal Services 102 O.T. Salaries - 1,000 1,020 1,040 1,061 1,082 1;104 103 Part -Time Salaries 2,365 5,410 5,518 5,629 5,741 5,856 5,973 121 PERA City Share 166 475 485 494 504 514 524 122 FICA City Share 176 500 510 520 531 541 552 131 Ins. City Share 831 717 731 746 761 776 792 Total Personal Services 3,538 8,102 8,264 8,429 8,598 8,770 8,945 TOTAL EXPENDITURES Supplies 184,794 135,158 137,861 140,618 143,431 146,299 208 Postage 1,298 1,400 1,428 1,457 1,486 1,515 1,546 245 General Supplies 193 300 306 312 318 325 331 104,252 Total Supplies 1,491 1,700 1,734 1,769 1,804 1,840 1,877 200,522 Other Services & Charges 286,700 325,834 400 Contractual 167,345 166,992 117,000 119,340 121,727 124,161 126,645 440 Misc. Services 9,163 8,000 8,160 8,323 8,490 8,659 8,833 450 Service Charges - - - - - - - Total Other Services & Charges 176,508 174,992 125,160 127,663 130,216 132,821 135,477 TOTAL EXPENDITURES 181,537 184,794 135,158 137,861 140,618 143,431 146,299 REVENUES OVER /(UNDER) EXPENDITURES 10,260 1,556 49,363 46,907 44,384 41,794 39,134 Beginning Cash Balance 92,436 102,696 104,252 153,615 200,522 244,906 286,700 Ending Cash Balance 102,696 104,252 153,615 200,522 244,906 286,700 325,834 IN 11/6/2014 17 City of Shorewood Financial Management Plan November 10, 2014 Storm Water Utility Fund - This fund is used for all storm water 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Actual Budget Budget Budget Budget Budget Budget 2013 2014 2015 2016 2017 2018 2019 REVENUES 2.0% 3.0% 3.0% 3.0% 3.0% 3.0% #### Grant Proceeds - - - - - - - ## ## Special Assessments 9,321 7,400 7,400 7,400 7,400 7,400 7,400 #### Interest Earnings 582 1,200 1,884 (1,584) 320 1,347 1,923 #### Miscellaneous Revenue 6 - - - - - - # # ## Storm Utility Charges 185,622 224,352 269,000 323,000 388,000 465,000 465,000 #### Transfers - 226,700 234,500 1,767 1,820 131 Ins. City Share # # ## Interfund Loans - 450,000 150,000 450,000 150,000 (12,500) (12,500) Total Revenues 195,531 909,652 662,784 778,816 545,720 461,247 461,823 Capital Outlay 2.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% EXPENSES 129,000 2.0% 3.0% 3.0% 3.0% 3.0% 10% 3.0% 720 Loan Repayment Personal Services 66,000 101,000 114,000 114,000 TOTAL EXPENDITURES 81,812 917,452 1,009,535 588,446 101 Regular Salaries 36,437 20,523 21,139 21,773 22,426 23,099 23,792 121 PERA City Share 2,632 1,500 1,545 1,591 1,639 1,688 1,739 122 FICA City Share 2,643 1,570 1,617 1,666 1,716 1,767 1,820 131 Ins. City Share 2,490 2,059 2,121 2,184 2,250 2,317 2,387 Total Personal Services 44,202 25,652 26,422 27,214 28,031 28,872 29,738 Supplies 200 Office Supplies 146 100 103 106 109 113 116 208 Postage 1,298 1,400 1,442 1,485 1,530 1,576 1,623 221 Maint- Equipment 1,031 5,500 5,665 5,835 6,010 6,190 6,376 240 Small Tools - 300 309 318 328 338 348 245 General Supplies 706 3,000 3,090 3,183 3,278 3,377 3,478 Total Supplies 3,181 10,300 10,609 10,927 11,255 11,593 11,941 Other Services & Charges 300 Financial & Audit 303 Engineering 18,700 20,000 20,600 21,218 21,855 22,510 23,185 304 Legal 518 1,000 1,030 1,061 1,093 1,126 1,159 321 Communication 331 5,000 5,150 5,305 5,464 5,628 5,796 313 Engineering - Design Stage 5,160 500 515 530 546 563 580 351 Print /Publish 129 100 103 106 109 113 116 360 Insurance -Total - - - - - - - 400 Contractual 4,551 71,500 73,645 75,854 78,130 80,474 82,888 433 Subscrip- Member 6,600 6,798 7,002 7,212 7,428 7,651 440 Misc. Services 2,520 1,100 1,133 1,167 1,202 1,238 1,275 450 Service Charges 221 1,000 1,030 1,061 1,093 1,126 1,159 Total Other Services & Charges 32,130 106,800 110,004 113,304 116,703 120,204 123,810 Capital Outlay 580 Other Improvements 2,299 774,700 819,500 371,000 186,000 129,000 735,000 Total Capital Outlay 2,299 774,700 819,500 371,000 186,000 129,000 735,000 720 Loan Repayment 43,000 66,000 101,000 114,000 114,000 TOTAL EXPENDITURES 81,812 917,452 1,009,535 588,446 442,989 403,669 1,014,489 REVENUES OVER /(UNDER) EXPENDITURES 113,719 (7,800) (346,751) 190,371 102,731 57,579 (552,665) Beginning Cash Balance Ending Cash Balance 1116/2014 18 Actual Budget Budget Budget Budget Budget Budget 2013 2014 2015 2016 2017 2018 2019 82,479 196,198 188,398 (158,353) 32,018 134,750 192,328 WATER FUND Revenue Coding: 601 -00- Expenditure Coding: 601 -00- Approved Dept Actual Actual YTD Budget Request Percent Dollar REVENUES 2012 2013 2014 2014 2015 Change Change 3710 Water Sales 612,892 494,201 148,650 630,000 600,000 -5% (30,000) 3610 Special Assessments 19,486 37,492 20,307 15,000 35,000 133% 20,000 3711 Permits & Connection Fees 21,230 46,020 36,510 15,000 25,000 67% 10,000 3620 Interest Earnings 32,351 17,887 0 35,000 25,000 -29% (10,000) 3713 Water Meter Sales 1,845 6,920 2,500 2,500 0% 0 3627 Antenna Space Rental 101,942 0 0 0 0 Total Revenues 789,746 595,600 212,387 697,500 687,500 -1% (10,000) EXPENSES Personal Services 4101 Regular Salaries 105,532 73,949 82,521 79,796 79,796 0% 0 4102 O.T. Salaries 1,348 8,424 3,408 3,000 3,000 0% 0 4121 PERA City Share 7,945 5,941 5,633 6,003 6,003 0% 0 4122 FICA City Share 7,720 5,899 5,694 6,334 6,334 0% 0 4131 Ins. City Share 14,750 12,784 1,545 12,726 12,726 0% 0 4151 Workers Compensation 2,194 0 Total Personal Services 137,295 106,997 100,995 107,858 107,858 0% 0 Supplies 4200 Office Supplies 109 146 - - - 4208 Postage 1,292 1,308 760 1,400 1,400 0% 0 4221 Maint - Equipment 5,494 4,332 2,018 6,500 6,500 0% 0 4223 Maint - Buildings 2,335 760 - 1,000 1,000 0% 0 4240 Small Tools 686 583 550 600 9% 50 4245 General Supplies 11,891 13,887 5,637 10,000 12,000 20% 2,000 4260 Wtr Purch -Tonka Bay 3,331 2,121 989 3,500 3,500 0% 0 4261 Wtr Purch - Excelsior 21,221 18,267 7,354 22,000 22,000 0% 0 4262 Wtr Purch - Mtka 1,245 881 254 1,500 1,500 0% 0 4263 Wtr Purch - Chan 15,645 9,498 5,846 16,000 16,000 0% 0 4265 Water Meters 10,659 6,926 6,720 15,000 15,000 0% 0 Total Supplies 73,908 58,126 30,161 77,450 79,500 3% 2,050 Other Services & Charges 4301 Financial & Audit - 2,250 2,500 2,500 2,500 0% 0 4303 Engineering 11,926 1,327 8,824 5,000 5,000 0% 0 4304 Legal Fees - 56 - - - 0 4321 Communication 766 663 680 2,800 2,800 0% 0 1- 4331 Travel, Conf,Sch 525 - 1,096 800 800 0% 0 4351 Print /Publish 558 552 543 1,000 1,100 10% 100 4360 Insurance -Total - 8,000 2,500 8,OOd 8,000 0% 0 4394 Utilities - Amesbury 11,835 12,368 5,115 12,000 12,000 0% 0 4395 Utilities - Badger 8,557 9,270 3,811 12,500 12,500 0% 0 4396 Utilities - Boulder Bridge 21,565 21,097 7,342 20,000 20,000 0% 0 4398 Utilities - SE Area /Tower 33,180 34,917 19,731 33,000 34,000 3% 1,000 4400 Contractual 10,190 26,018 25,303 30,000 30,000 0% 0 4420 Depreciation 274,917 271,166 - 290,000 290,000 0% _ 0 4437 Licenses -Sales Taxes 3,072 635 - 3,000 3,000 0% 0 4440 Misc. Services 196 17,949 392 200 200 0% 0 4450 Bank Svc Chgs 44 8 16 1,000 1,000 0% 0 Total Other Services & Charges 377,331 406,276 77,853 421,800 422,900 0% 1,100 Bond Expense 4711 Bond Interest 99,910 74,887 51,425 91,303 77,796 -15% (13,507) 4720 Fiscal Agent Fees 758 46,908 495 800 800 0% 0 Total Bond Expense 100,668 121,795 51,920 92,103 78,596 -15% (13,507) Transfers 4820 Transfers Out - - 12,500 12,500 0% 0 Total Transfers - - 12,500 12,500 0% 0 TOTAL EXPENSES 689,202 693,194 260,929 711,711 701,354 -1% (10,357) REVENUES OVER /(UNDER) EXPENSES 100,544 (97,594) (48,542) (14,211) (13,854) SEWER FUND Revenue Coding: 611-00 - Expenditure Coding: 611-00 - Approved Requested Actual Actual YTD Budget Budget Percent Dollar REVENUES 2012 2013 2014 2014 2015 Change Change 3620 Interest Earnings 29,842 14,191 - 36,000 25,000 -31% (11,000) 3710 Sewer Sery Charges 801,996 831,259 430,830 835,000 860,050 3% 25,050 3610 Sewer Chg -Cnty Coll 26,493 15,634 0 3400 Local SAC Charges 2,400 13,200 6,170 - 6,000 6,000 3712 Sewer Permits 3,150 3,060 2,100 700 700 0% 0 Total Revenues 863,881 861,710 454,734 871,700 891,750 1% 10,000 EXPENSES Personal Services 4101 Regular Salaries 68,000 68,010 68,2.48 69,186 69,186 0% 0 4102 O.T. Salaries 2,636 3,139 1,651 2,500 2,500 0% 0 4121 PERA City Share 5,343 5,092 4,541 5,197 5,197 0% 0 4122 FICA City Share 5,182 5,093 4,764 5,484 5,484 0% 0 4131 Ins. City Share 13,456 10,293 1,545 10,787 10,787 0% 0 4151 Workers Compensation 1,645 - 2,500 2,500 Total Personal Services 94,617 91,627 82,394 93,155 95,655 3% 2,500 Supplies 4200 Office Supplies 109 146 - 150 150 0% 0 4208 Postage 1,265 1,324 694 1,500 1,500 0% 0 4221 Maint- Equipment 1,182 3,382 6 5,000 5,000 0% 0 4240 Small Tools 45 732 21 550 550 0% 0 4245 General Supplies 550 1,293 354 2,100 2,100 0% 0 Total Supplies 3,151 6,877 1,075 9,300 9,300 0% 0 Other Services & Charges 4301 Financial & Audit - 2,250 2,500 2,500 2,500 0% 0 4303 Engineering 13,927 10,753 617 5,000 5,000 0% 0 4313 Engineering - Design Stage 583 1,701 - 5,000 5,000 0% 0 4321 Communication 3,374 4,103 3,762 4,500 5,500 22% 1,000 4331 Travel, Conf,Sch 1,300 975 600 1,500 1,500 0% 0 4360 Insurance -Total 773 6,500 - 7,000 7,000 0% 0 4380 Utilities- Gas /Elec 5,326 5,588 3,725 7,500 7,500 0% 0 4385 MCES Service Charges 675,409 529,386 406,191 575,000 609,180 6% 34,180 4386 Excelsior Sewer Chg 26,797 31,676 18,120 31,000 31,000 0% 0 4400 Contractual 10,230 17,940 3,042 20,000 20,000 0% 0 4200 Depreciation 221,214 81,329 - 225,000 225,000 0% 0 4437 Licenses -Taxes - 23 73 - - 0 4440 Misc. Services 195 33,960 - 150 150 0% 0 4450 Service Charges 12 - 8 1,500 1,500 0% 0 Total Other Services & Charges 959,140 727,684 440,026 887,150 922,330 4% 35,180 Transfers 4820 Transfers to General Fund 12,500 12,500 0% 0 4820 Transfers to Storm Water 226,700 226,700 0% 0 Total Transfers - - 239,200 239,200 0% 0 TOTAL EXPENSES 1,056,908 826,188 523,495 1,228,805 1,266,485 3% 37,680 REVENUES OVER /(UNDER) EXPENSES (193,027) 35,522 (68,761) (357,105) (374,735) RECYCLING FUND Revenue Coding: 621-00 - Expenditure Coding: 621 -00- EXPENSES Personal Services Approved Requested 4101 Regular Salaries Actual Actual YTD Budget Budget Percent REVENUES 2012 2013 2014 2014 2015 Change 3362 County Recycling Aid 23,007 22,989 - 23,000 23,000 0% 3362 County Park Recycling Grant 339 2,841 8,250 475 475 0% 3610 Special Assessment 5,588 6,363 3,437 500 500 0% 3620 Interest Earnings 528 253 - 350 350 0% 3710 Recycling Service Charges 154,288 154,265 80,719 155,000 155,000 0% 3732 City Clean -up Fees (2,291) 5,086 7,815 6,000 8,000 33% Total Revenues 181,120 191,797 100,221 184,350 186,350 1% EXPENSES Personal Services 4101 Regular Salaries - 69 5,749 - 5,410 4102 O.T. Salaries 774 - - 1,000 1,000 0% 4103 Part Time Salaries 4,126 2,296 306 5,410 - -100% 4121 PERA City Share 339 166 360 475 475 0% 4122 FICA City Share 377 176 352 500 500 0% 4131 Ins. City Share 876 831 126 717 717 0% 4151 Workers Comp - 1 - - Total Personal Services 6,492 3,538 6,894 8,102 8,102 0% Supplies 4200 Office Supplies 109 - - 100 100 0% 4208 Postage 1,904 1,298 694 900 1,400 56% 4245 General Supplies 664 193 193 200 200 0% Total Supplies 2,677 1,491 887 1,200 1,700 42% Other Services & Charges 4400 Contractual 165,730 167,345 110,385 166,992 117,000 -30% 4440 Misc. Services 12,810 9,163 8,025 8,000 8,500 6% 4450 Service Charges - - - - - Total Other Services & Charges 178,540 176,508 118,410 174,992 125,500 -28% TOTAL EXPENSES 187,709 181,537 126,191 184,294 135,302 -27% REVENUES OVER /(UNDER) EXPENSES (6,589) 10,260 (25,970) 56 51,048 STORMWATER MANAGEMENT FUND Revenue Coding: 631-00 - Expenditure Coding: 631-00 - Approved Requested Actual Actual YTD Budget Budget Percent Dollar REVENUES 2012 2013 2014 2014 2015 Change Change 3362 Grant Proceeds - - - - - 0 3610 Special Assessments 7,605 9,321 4,231 7,400 7,400 0% 0 3620 Interest Earnings 1,411 582 - 1,200 1,200 0% 0 3670 Miscellaneous Revenue - 6 6 - - 2,632 0 3710 Storm Utility Charges 186,326 185,622 106,039 224,352 224,352 0% 0 3920 Transfers from Sewer 1,570 1,570 0% 226,700 226,700 0% 0 Total Revenues 195,342 195,531 110,276 459,652 459,652 0% 0 EXPENSES TOTALEXPENSES 162,944 107,935 66,244 176,552 176,752 0% 200 REVENUES OVER /(UNDER) EXPENSES 32,398 87,596 44,032 283,100 282,900 Personal Services 4101 Regular Salaries 45,744 35,089 37,355 20,523 20,523 0% 0 4102 O.T. Salaries 163 1,348 2,153 0 4121 PERA City Share 3,336 2,632 2,766 1,500 1,500 0% 0 4122 FICA City Share 3,269 2,644 2,616 1,570 1,570 0% 0 4131 Ins. City Share 5,099 2,490 158 2,059 2,059 0% 0 4151 Workers Comp - 994 0 Total Personal Services 57,611 44,203 46,042 25,652 25,652 0% 0 Supplies 4200 Office Supplies 109 146 - 100 100 0% 0 4208 Postage 1,265 1,298 457 1,200 1,400 17% 200 4421 Maint - Equipment - 1,031 - 5,500 5,500 0% 0 4240 Small Tools - - 300 300 0% 0 4245 General Supplies 310 706 295 3,000 3,000 0% 0 Total Supplies 1,684 3,181 752 10,100 10,300 2% 200 Other Services & Charges 4303 Engineering 10,914 13,540 5,647 20,000 20,000 0% 0 4304 Legal 2,534 518 - 1,000 1,000 0% 0 4313 Engineering - Design Stage 5,955 5,160 169 5,000 5,000 0% 0 4321 Communication 315 331 355 500 500 0% 0 4351 Print /Publish 64 129 643 100 100 0% 0 4400 Contractual 36,430 4,551 2,135 71,500 71,500 0% 0 4420 Depreciation 32,314 33,802 - 34,000 34,000 0% 0 4433 Subscrip- Member - - 6,600 6,600 0% 0 4440 Misc. Services 935 2,520 10,497 1,100 1,100 0% 0 4450 Service Charges - 4 1,000 1,000 0% 0 Total Other Services & Charges 89,461 60,551 19,450 140,800 140,800 0% 0 TOTALEXPENSES 162,944 107,935 66,244 176,552 176,752 0% 200 REVENUES OVER /(UNDER) EXPENSES 32,398 87,596 44,032 283,100 282,900