Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
10-10-11 CC WS Agenda
CITY OF SHOREWOOD 5755 COUNTRY CLUB ROAD CITY COUNCIL WORK SESSION COUNCIL CHAMBERS MONDAY, OCTOBER 10, 2011 6:00 P.M. AGENDA Attachments 1. CONVENE CITY COUNCIL WORK SESSION A. Roll Call Mayor Lizée ____ Hotvet____ Siakel ____ Woodruff____ Zerby ____ B. Review Agenda 2. ENTERPRISE BUDGET AND CAPITAL IMPROVEMENT PROGRAM Finance Director’s memo 3. ADJOURN MEMORANDUM Date: October 10, 2011 To: Mayor Lizee Council Members From: Bruce DeJong, Finance Director Reviewed by: Brian Heck Larry Brown Re: Enterprise Fund Budget Discussion _____________________________________________________________________________ The city has four enterprise funds – Water, Sewer, Stormwater Management, and Recycling. The Water and Sewer funds have very large cash balances. The water fund is profitable while the sewer fund is projected to be modestly unprofitable for 2011 and 2012. The Stormwater Management Fund is profitable, but has been constructing new facilities at a pace that will outstrip its cash balance and will need both short-term funding assistance and long-term rate increases to cover the increased maintenance that will soon be required. The Recycling fund is about breaking even with the current cost of operations. The amount of annual loss is small, but rates need to be raised to provide break-even operations at some point in the next few years. The Water fund is profitable to the extent that $40,000 of the revenues associated with antenna leases have been transferred to the General Fund. This is to replace the loss of transfer from the liquor funds that are now moved into the Community Infrastructure Fund. The Sewer fund is facing modestly increased rates from Metropolitan Council Environmental Services (MCES). This is primarily in response to the lack of SAC permit fees from new development. Rates will need to be raised at some point to cover the increased cost of the system. The Recycling fund needs to cover its expenses. Council should consider phasing in rate increases annually to bring the fund to a break-even position before the cash is fully depleted. The Stormwater Management fund will need additional analysis to determine what projects need to be performed based on the new maintenance requirements in the National Pollution Discharge Elimination System (NPDES) rules that go into effect in 2012. Staff hesitates to suggest increasing rates for the water and sewer charges since those funds have such large cash balances. The Water Fund could finance extension of water to areas that do not currently have service at the time of street reconstruction. Some of the fund balance from the Sewer Fund could be transferred to cover the storm water projects for the next several years without imperiling the viability of the existing sewer projects. Those are City Council policy decisions but will have a large impact on future projects and utility rates. Attachments: Enterprise Fund Budget Spreadsheets Salary Allocation Spreadsheet Enterprise Fund CIP Spreadsheets WATER FUND Revenue Coding: 601- Expenditure Coding: 601-49400-Preliminary ActualActualActualBudgetYTDProjectedBudgetPercentDollar 2008200920102011201120112012ChangeChange REVENUES 37110Water Sales601,905577,565465,861630,000417,495600,000630,0000%164,139 36101Special Assessments34,90840,21421,74435,0006,66714,00035,0000%13,256 37170Permits & Connection Fees92028,88529,1841,00015,38015,3801,0000%(28,184) 36210Interest Earnings106,0013,74031,99935,0004,11825,00035,0000%3,001 37171Water Meter Sales4,6884,8383,0282,5001,3301,3302,5000%(528) 37175Antennae Space Rental109,453132,816148,859140,00074,998149,000100,000-29%(8,859) Total Revenues857,875788,058700,675843,500519,988804,710803,500-5%142,825 EXPENSES Personal Services 101Regular Salaries74,43868,22964,35973,73856,37474,00079,4748%9,379 102O.T. Salaries2,7883,2562,0572,0002,6243,0003,00050%(57) 121PERA City Share5,0224,8224,5245,3464,2775,8005,97212%822 122FICA City Share5,5815,2794,8175,6414,2906,0006,31012%824 131Ins. City Share7,9058,2058,1589,2091,9299,20010,0119%1,051 151Workers Compensation683 Total Personal Services95,73489,79184,59895,93469,49498,000104,7679%11,336 Supplies 200Office Supplies 107 - 101 - 106 106 - 208Postage 1,335 1,574 1,235 1,000 1,031 1,300 1,30030%(235) 221Maint-Equipment 7,736 4,414 4,244 6,500 3,027 4,000 6,5000%2,256 223Maint-Buildings 316 246 252 1,000 258 500 1,0000%748 240Small Tools 75 19 290 550 43 300 5500%260 245General Supplies 7,551 10,955 7,608 10,000 7,015 9,000 10,0000%2,392 260Wtr Purch - Tonka Bay 2,228 3,050 2,125 3,300 1,419 3,300 3,3000%1,175 261Wtr Purch - Excelsior 16,130 17,082 18,892 17,500 8,730 17,500 17,5000%(1,392) 262Wtr Purch - Mtka 737 990 687 1,000 528 1,000 1,0000%313 263Wtr Purch - Chan 14,879 11,387 11,380 12,000 8,144 11,500 12,0000%620 265Water Meters 1,945 4,751 5,631 5,000 2,752 3,000 5,0000%(631) Total Supplies 53,039 54,468 52,445 57,850 33,053 51,506 58,1501%5,405 Other Services & Charges 301Financial & Audit 2,250 2,250 2,250 2,250 - 2,250 2,2500%0 302Consulting - 4,448 - - 1,775 3,000 -0 303Engineering - - 2,070 - - -(2,070) 304Legal Fees - - - - 107 -0 321Communication 1,984 14,329 978 1,500 626 1,200 1,5000%522 331Travel, Conf,Sch 1,400 558 350 600 700 700 6000%250 351Print/Publish 422 629 628 1,000 583 900 1,0000%372 360Insurance-Total 7,900 10,125 7,816 7,500 - 7,900 8,0007%(316) 394Utilities - Amesbury 9,204 4,142 9,672 5,500 6,689 9,600 10,00082%(4,172) 395Utilities - Badger 11,376 10,561 10,243 11,000 8,444 11,000 11,0000%757 396Utilities - Boulder Bridge 20,157 16,673 16,799 15,000 9,418 13,000 15,0000%(1,799) 397Utilities - Woodhaven 6,788 501 - - - -0 398Utilities - SE Area/Tower 29,635 38,077 29,892 30,000 17,301 23,000 30,0000%108 400Contractual 13,905 14,329 13,987 15,000 10,625 15,000 15,0000%1,013 420Depreciation 237,022 274,066 279,699 270,000 - 280,000 290,0007%(9,699) 433Subscrip-Member - - - - - -0 437Licenses-Sales Taxes 3,645 2,669 4,382 3,000 542 1,000 3,0000%(1,382) 440Misc. Services 183 119 126 200 137 200 2000%74 450Bank Svc Chgs 676 509 95 525 - 700 5250%430 Total Other Services & Charges 346,548 393,983 378,987 363,075 56,947 369,450 388,0757%(15,912) Capital Outlay 580Other Improve 616,116 - 2,446 - 25,869 30,000(2,446) Total Capital Outlay 616,116 - 2,446 - 25,869 30,000 -(2,446) Debt Service 601Bond Principal - 310,000 - 295,000 180,000 180,000 295,0000%295,000 611Bond Interest - 133,302 124,656 110,488 59,953 110,000 110,4880%(14,168) 620Fiscal Agent Fees - 750 750 1,500 318 750 1,5000%750 Total Debt Service - 444,051 125,406 406,988 240,271 290,750 406,9880%281,582 Total Transfers 260,000 - - - - - 0 TOTAL EXPENSES 1,371,437 982,294 643,882 923,847 425,634 839,706 957,9804%279,965 REVENUES OVER/(UNDER) EXPENSES (513,562) (194,236) 56,793 (80,347) 94,354 (34,996) (154,480) 55 SEWER FUND Revenue Coding: 611- Expenditure Coding: 611-49450- Preliminary ActualActualActualBudgetYTDProjectedBudgetPercentDollar REVENUES20112011 20082009201020112012ChangeChange 33635MCES I & I Grant - - - - - - 36210Interest Earnings 139,194 50,143 38,439 36,000 4,074 36,000 36,000 0% (2,439) 36240Refunds/Reimburse - 37250Metro Sac Charges 37210Sewer Serv Charges 826,867 801,552 812,537 825,000 612,713 825,000 825,000 0% 12,463 37220Sewer Chg-Cnty Coll - 28,456 - - 37250Local SAC Charges 1,200 - 2,400 - - - - (2,400) 37270Sewer Permits 1,050 700 1,650 700 900 300 700 0% (950) 39201Tsfr From Other Funds 50,000 - 60,000 - - 60,000 - (60,000) Total Revenues 1,018,311 852,395 943,482 861,700 617,687 921,300 861,700 0% (81,782) EXPENSES Personal Services Regular Salaries 69,256 53,332 53,842 63,898 51,416 58,632 71,179 10111% 10,056 O.T. Salaries 1,135 815 922 1,654 - 1,200 102 Part Time Salaries - - - - - 103 PERA City Share 4,579 3,662 3,740 4,633 3,848 4,104 5,260 12114% 893 FICA City Share 5,091 4,041 4,004 4,888 3,938 4,485 5,545 12213% 884 Ins. City Share 7,128 5,908 6,538 7,017 1,670 9,090 9,017 13129% 479 Workers Compensation 683 151 87,188 67,757 69,729 80,436 62,526 76,311 92,201 Total Personal Services15% 10,707 Supplies Office Supplies 107 - 102 - 105 - 110 200 Postage 1,431 1,593 1,211 1,500 987 1,300 1,500 2080% Motor Fuel & Lube - - - - - - - 212 Maint-Equipment 3,561 2,526 14,640 5,000 1,673 4,000 5,000 2210% (9,640) Maint-Buildings - - - - - - - 222 - Small Tools 639 1,017 79 550 - 1,000 550 2400% 471 General Supplies 2,151 1,796 919 2,100 543 2,100 2,100 2450% 1,181 7,889 6,932 16,951 9,150 3,308 8,400 9,260 Total Supplies1% (7,801) Other Services & Charges Financial & Audit 2,250 2,250 2,250 2,250 - 2,250 2,250 3000% - Consulting 103 4,448 - 1,500 - 1,500 1,500 3080% 1,500 Engineering Fees 6,316 - - - - - 303 Engineering - Design Stage - 273 4,634 5,000 1,536 3,500 5,000 3130% 366 Communication 3,784 3,537 3,806 4,000 3,052 4,500 4,000 3210% 194 Travel, Conf,Sch 1,405 868 934 1,500 1,300 1,200 1,500 3310% 566 Print/Publish 524 - - - - - - 351 - Insurance-Total 5,288 6,427 5,225 6,500 - 2,021 6,500 3600% 1,275 Utilities-Gas/Elec 6,086 5,845 5,919 6,000 4,164 4,600 6,000 3800% 81 MCES Service Charges 549,534 576,016 564,332 713,835 535,651 580,250 728,000 3852% 149,503 Excelsior Sewer Chg 30,040 31,006 29,941 30,000 15,759 31,000 31,000 3863% 59 Contractual 9,530 31,351 31,825 20,000 15,371 20,000 20,000 4000% (11,825) Depreciation 210,408 218,481 218,483 219,000 - 219,000 225,000 4203% 517 Dues & Subscriptions - 23 - - - - - 433 - Licenses-Taxes - - 265 - 23 - - 437 (265) Misc. Services 84 105 126 150 114 200 150 4400% 24 Service Charges 808 636 110 900 - 500 900 4500% 790 826,161 881,264 867,850 1,010,635 576,970 870,521 1,031,800 Total Other Services & Charges2% 142,785 Capital Outlay Machinery-Equip - - - - - - 540 - Furn & Fixtures - - - - - - 560 Other Improve - - 25,643 36,031 70,000 580 (25,643) - - 25,643 - 36,031 70,000 - Total Capital Outlay (25,643) Transfers Permanent - 1,000,000 - - - - - 720 - Total Transfers - 1,000,000 - - - - - - TOTAL EXPENSES 921,239 1,955,954 980,173 1,100,221 678,835 1,025,232 1,133,261 3% 120,048 REVENUES OVER/(UNDER) EXPENSES 97,072 (1,103,559) (36,691) (238,521) (61,148) (103,932) (271,561) 56 RECYCLING FUND BUDGET Revenue Coding: 621- Expenditure Coding: 621-49550- Preliminary YTDProjectedPercent ActualActualActualBudgetBudgetDollar REVENUES 2008200920102011201120112012ChangeChange County Recycling Aid 23,202 22,830 23,560 21,000 23,086 23,086 23,000 3362010% (560) Interest Earnings 2,659 986 656 350 54 250 350 362100% (306) Recycling Service Charges 57,062 60,009 154,279 150,000 114,525 150,000 150,000 373100% (4,279) City Clean-up Fees 7,104 4,983 - - (1,247) 5,958 6,000 37320 6,000 Recycling Bin Sales 463 120 - - - - - 37330 - Revenue from Contractor - - - - - - - 37340 - Transfers from Other Funds - - - - - - - 39201 - Total Revenues 90,490 88,928 178,495 171,350 136,418 179,294 179,350 855 5% EXPENSES Personal Services Regular Salaries - - - - 910 910 - 101 O.T. Salaries 743 - 788 - 997 997 1,000 102 212 Part Time Salaries 160 3,448 4,307 10,271 2,175 5,000 5,251 103-49% 944 PERA City Share 48 233 353 745 292 400 450 121-40% 97 FICA City Share 63 264 388 786 308 400 475 122-40% 87 Ins. City Share 95 353 - 1,386 - - 619 131 619 1,110 4,297 5,836 13,188 4,682 7,707 7,795 Total Personal Services-41% 1,959 Supplies Office Supplies - 102 105 100 200 (2) Postage 604 1,211 325 864 900 900 208177% (311) General Supplies 1,421 112 170 250 176 200 200 245-20% 30 1,421 716 1,483 575 1,145 1,100 1,200 Total Supplies109% (283) Other Services & Charges Contractual 83,880 94,104 166,449 166,992 124,976 166,992 166,992 4000% 543 Misc. Services 10,519 158 8,405 150 7,613 7,259 8,000 4405233% (405) Service Charges 16 10 - 20 - - - 450-100% - 94,415 94,273 174,854 167,162 132,589 174,251 174,992 Total Other Services & Charges5% 138 TOTAL EXPENSES 96,946 99,286 182,173 180,925 138,416 183,058 183,987 2% 1,814 REVENUES OVER/(UNDER) EXPENSES (6,456) (10,358) (3,678) (9,575) (1,998) (3,764) (4,637) 58 STORMWATER MANAGEMENT FUND Revenue Coding: 631- Expenditure Coding: 631-49600- Preliminary YTDProjectedPercent ActualActualActualBudgetBudgetDollar REVENUES 2008200920102011201120112012ChangeChange Grant Proceeds 4,748 5,658 5,202 5,100 5,157 5,157 5,100 336200% (102) Special Assessments - 7,651 - - - - 36101 (7,651) 12,269 4,991 5,637 5,100 742 5,000 3,000 Interest Earnings 36210-41% (2,637) Miscellaneous Revenue 273 125 122 75 10,550 10,550 75 362700% (47) Cellular Antenna Revenue - - - 37175 Storm Utility Charges 204,345 191,032 190,819 200,500 144,485 200,150 200,500 374100% 9,681 Transfers/Internal Loans - - - - - - 39201 -1% (756) Total Revenues 221,635 201,806 209,431 210,775 160,934 220,857 208,675 EXPENSES Personal Services Regular Salaries 12,473 47,576 17,816 41,196 24,971 37,159 27,642 101-33% 9,826 O.T. Salaries - 158 300 102 Part Time Salaries - 103 PERA City Share 811 3,117 1,186 2,987 1,822 2,601 2,004 121-33% 818 FICA City Share 912 3,628 1,287 3,152 1,881 2,843 2,115 122-33% 828 Ins. City Share 1,323 1,507 2,448 4,839 545 5,754 2,834 131-41% 386 15,520 55,828 22,737 52,174 29,377 48,657 34,595 Total Personal Services-34% 11,858 Supplies Office Supplies 478 - 102 106 106 100 200 (2) Postage - - 1,211 350 864 1,000 1,000 208186% (211) Maint-Equipment 373 1,087 - 5,500 - 1,000 5,500 2210% 5,500 Small Tools 16 - 300 - 120 300 2400% 300 General Supplies 6,441 691 1,268 3,000 2,074 3,000 3,000 2450% 1,732 7,292 1,795 2,581 9,150 3,044 5,226 9,900 Total Supplies8% 7,319 Other Services & Charges Financial & Audit - - 300 Engineering 92 3,000 8,384 5,000 8,661 10,000 5,000 3030% (3,384) Legal 138 46 1,000 240 500 1,000 3040% 954 Communication - - - - - Engineering - Design Stage - 1,418 5,000 4,150 5,000 5,000 3130% 3,582 Print/Publish 39 25 - 100 324 400 100 3510% 100 Insurance-TotalInsurance-Total - - - - - - 360360 -- Contractual 62,366 24,935 40,871 50,000 17,644 20,000 50,000 4000% 9,129 Depreciation 19,833 19,833 19,833 20,000 - 20,000 22,000 42010% 2,167 Subscrip-Member - 600 - - 600 4330% 600 Misc. Services 933 1,235 1,748 1,100 117 1,000 1,100 4400% (648) Service Charges 69 59 14 500 - 75 500 4500% 486 83,332 49,226 72,314 83,300 31,136 56,975 85,300 Total Other Services & Charges2% 12,986 Capital Outlay Land 870 510 Other Improvements - - 33,475 120,000 392,022 400,000 120,000 5800% 86,525 Total Capital Outlay - - 33,475 120,000 392,892 400,000 120,000 0% 86,525 -6% 118,688 TOTAL EXPENSES 106,144 106,848 131,107 264,624 456,449 510,858 249,795 REVENUES OVER/(UNDER) EXPENSES 115,490 94,957 78,324 (53,849) (295,515) (290,001) (41,120) 5757 2012 Wages (using 2011 Base) SalariesPERAFICABenefitsTotal Administration$ 284,291$ 20,611$ 21,748$ 33,369$ 360,019 General Government$ -$ -$ -$ -$ - Elections$ -$ -$ -$ -$ - Finance$ 102,399$ 7,424$ 7,834$ 10,759$ 128,415 Planning and Zoning$ 133,887$ 9,707$ 10,242$ 16,830$ 170,666 Protective Inspections$ 90,403$ 6,554$ 6,916$ 12,676$ 116,549 Engineer $ 72,196$ 5,234$ 5,523$ 7,919$ 90,872 Public Works$ 325,676$ 23,611$ 24,914$ 41,932$ 416,134 Streets and Roads$ -$ -$ -$ -$ - Snow and Ice$ 36,052$ 2,614$ 2,758$ 5,076$ 46,500 Weeds$ -$ -$ -$ -$ - Trees$ -$ -$ -$ -$ - Park and Recreation$ 116,967$ 8,480$ 8,948$ 8,393$ 142,788 Water$ 79,474$ 5,762$ 6,080$ 10,011$ 101,327 Sewer$ 71,179$ 5,160$ 5,445$ 9,017$ 90,801 Recycling$ 5,251$ 381$ 402$ 619$ 6,652 Storm Sewer$ 27,642$ 2,004$ 2,115$ 2,834$ 34,595 $ 1,345,417$ 97,543$ 102,924$ 159,435$ 1,705,319 City of Shorewood, Minnesota Capital Improvement Program 20122021 thru PROJECTS BY SOURCE Source #Priority2012201320142015201620172018201920202021Total 601 - Water Fund Radio/ISP Communications System W-10-01 1 75,000 75,000 Water Main - Star Circle & Lane n/a 130,000 W-11-02 130,000 Water Main - Valleywood Circle & W-12-01 n/a 272,000 272,000 Lane Boulder Bridge Well Controls 5 220,000 W-12-03 220,000 Water Main - Sunnyvale Lane W-13-02 n/a 100,000 100,000 W. Water Tower - Rehab & Painting 3 450,000 W-13-03 450,000 Water Main - Club Valley W-14-01 n/a 100,000 100,000 Water Main - Lake Virginia Drive n/a 240,000 W-14-02 240,000 295,000722,000440,000130,0001,587,000 601 - Water Fund Total 611 - Sanitary Sewer Fund Radio/ISP Communications - Lift 1 40,00040,000 SS-10-10 80,000 Stations Lift Station 6 Rehab - 27950 SS-12-01 2 125,000125,000 Smithtown Rd. Utility Locator SS-12-02 2 5,000 5,000 Lift Station 11 Rehab - 20465 3 130,000 SS-13-01 130,000 Radisson Rd. Infiltration and Inflow Reduction SS-99-05 1 70,00070,00070,00070,00070,00070,00070,00070,00070,000700,000 70,000 240,000240,00070,00070,00070,00070,00070,00070,00070,00070,0001,040,000 611 - Sanitary Sewer Fund Total 535,000962,000510,000200,00070,00070,00070,00070,00070,00070,000 2,627,000 GRAND TOTAL City of Shorewood, Minnesota Capital Improvement Program 20122021 thru PROJECTS BY SOURCE Source #Priority2012201320142015201620172018201920202021Total 631 - Stormwater Management Fund Star Circle & Lane - Stormwater STM-12-02 3 31,000 31,000 Lake South Auto Drainage - WSB 3 24,000 STM-12-05 24,000 Report Valleywood Circle & Lane - Drainage STM-12-08 4 142,000 142,000 Afton Rd Drainage 4 147,000 STM-13-01 147,000 Sunnyvale Lane Drainage STM-13-02 4 192,000 192,000 Club Valley Drainage 4 101,000 STM-14-01 101,000 Lake Virginia Drive Drainage STM-14-02 4 283,000 283,000 6120 Riviera Drainage - WSB Report 3 19,000 STM-14-04 19,000 Star Circle & Lane STM-15-01 5 31,000 31,000 23610 Gillette Curve Drainage - 3 211,000 STM-15-03 211,000 WSB Report 23350 Academy Drainage STM-15-04 4 75,000 75,000 Garden Road 4 26,000 STM-15-05 26,000 Gillette Road STM-15-06 4 17,000 17,000 Echo Rd Drainage 4 270,000 STM-16-01 270,000 Manitou Lane STM-16-02 4 75,000 75,000 Riveria Lane 4 87,000 STM-17-01 87,000 Shorewood Lane STM-17-02 4 99,000 99,000 Mann Lane 4 105,000 STM-18-01 105,000 Maple St STM-18-02 4 24,000 24,000 Eureka Road N 4 452,000 STM-19-01 452,000 Seamans Drive STM-20-01 4 148,000 148,000 2,559,000 24,000289,000595,000391,000345,000186,000129,000452,000148,000 631 - Stormwater Management Fund Total 24,000289,000595,000391,000345,000186,000129,000452,000148,000 2,559,000 GRAND TOTAL 20 Year Storm Sewer Program Total Cost Updated 10/6/11 These roads are scheduled for reconstructions so storm sewer improvements should also be made at the same time. 2012201320142015201620172018201920202021 Road Name Inflation Factor:2.0% AMLEE RD - - - - 78,186 - - - - - EUREKA RD N - - - - - - - 452,170 - - MANITOU LA - - - - 74,672 - - - - - MANN LA - - - - - - 104,559 - - - MAPLE ST - - - - - - 23,639 - - - RIVIERA LA - - - - - 87,295 - - - - SEAMANS DR - - - - - - - - 148,068 - SHOREWOOD LA - - - - - 99,484 - - - - STAR CIR - - - 32,555 - - - - - - STAR LA - - - 73,999 - - - - - - SUNNYVALE LA - - 53,538 - - - - - - - VALLEYWOOD CIR - 42,430 - - - - - - - - VALLEYWOOD LA - 98,914 - - - - - - - - Annual Total $ - $ 141,344$ 53,538$ 106,554$ 152,859$ 186,779$ 128,198$ 452,170$ 148,068$ -