Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Agenda Packets - 2014/10/06
CITY OF MOUNDS VIEW CITY COUNCIL WORK SESSION AGENDA MOUNDS VIEW CITY HALL Monday, October 6, 2014 7:00 p.m. ROLL CALL: Flaherty, Gunn, Hull, Meehlhause, Mueller PUBLIC COMMENT Citizens may speak to issues not on tonight’s agenda. Before speaking, please give your full name and address for the minutes. Also, please limit your comments to three minutes. Agenda Items Discussed by Consensus 1. Joint Meeting with Festival in the Park Committee 2. Review Possible Code Amendment for Temporary Structures 3. Joint meeting with Charter Commission 4. Review Community Center Hours of Operation and Other Updates 5. Review Other Funds Budgets for 2015 Next Work Session: Monday, November 3, 2014, at 7pm Next City Council Meeting: Monday, October 13, 2014, at 7pm Item No: 5 Meeting Date: October 6, 2014 Type of Business: Work Session Administrator Review: _____ City of Mounds View Staff Report To: Honorable Mayor and City Council From: Mark Beer, Finance Director Item Title/Subject: Other Funds Budgets for 2015 Attached are the budgets for the Other Funds (Special Revenue, Debt Service, Capital Projects, and Enterprise) for your consideration. The Council has had several opportunities to review the General Fund and will again in November or December. The Special Revenue, Debt Service, Capital Projects, and Enterprise funds have not been reviewed. Enterprise Funds The City continues to have low utility rates based on rate studies the City participates in and staff has shared with the City Council. Staff advocates a policy of nominal increases to maintain the infrastructure rather than larger increases with greater intervals between increases. The Water fund anticipates an increase in base user charges by a dime which will add about $8 per year for the average home. The increase is based on continuing maintenance costs that were deferred in past years and recent major infrastructure improvements. The five year plan projects the need for a fifteen cent base rate increase in 2016 and 2017 and a dime increase in the base rate for 2018 and 2019. The Sewer fund anticipates a 6% increase in user charges which will add $17 to a residential utility bill. Met Council Environmental Services (MCES) waste charges increased by .12% in 2015 but have significantly increased in the past along with deferred maintenance. Future increases of 6% for 2016 and 2017 and 4% for 2018 and 2019 will help stabilize the sewer fund. The Storm Water fund does not require an increase in 2015. The Storm Water fund does not anticipate a rate increase until 2018 and 2019. This will begin to fund the sediment removal from Silver View pond that will occur in 2026. The City will be exploring the possibility of slip lining some of the storm sewers to extend their lives in the coming years and that could impact future rates also. The Street Light Fund anticipates a $.25 per quarter increase in 2015 thru 2019 to offset higher electrical and trailway lighting and maintenance costs. Capital Projects Funds There are a number of capital projects that are anticipated to occur in 2015, the most prominent are the street project for Area H, Mustang Drive storm water improvements and mill and overlay project, trail segments 6 and 11, and Groveland Park improvements. Future funding of the Special Projects Fund will need to be considered. There is a $10,000 transfer budgeted in the General Fund for 2015. 1 Special Revenue Funds Most of the special revenue funds are small and the budgets are driven by the specific revenues received. The most note worthy are the Cable, Police Forfeiture, EDA, Community Center, TIF 2 and TIF 5 as they have the most significant activity. TIF 2 will be decertified after 2015. The Council will need to consider additional funding for the EDA fund after 2015. The EDA fund will be limited to 5% of the increment in TIF 5 (approx. $65,000) going forward and a $10,000 transfer from the General Fund. This will be insufficient after 2015 so staff is looking for direction on the EDA fund. Staff would recommend that Council review the funds and make any recommendations that they may have. Respectfully Submitted, Mark Beer, Finance Director 2 THIS PAGE LEFT BLANK INTENTIONALLY 3 CITY OF MOUNDS VIEW, MINNESOTA Special Revenue Funds 2015 Budgets Combining Statement of Revenues and Expenditures and Net Changes in Fund Balances Economic Cable Development Community Television DARE Forfeiture Authority Center Revenues: Taxes 118,000 - - - - Intergovernmental: County grants - - - - - Other local govt.- - - - - Charges for services: Culture and recreation - - - - 216,457 Miscellaneous: Fines - 800 5,500 - - Investment income - - - - 1,000 Other 2,400 - - - - Total revenues 120,400 800 5,500 - 217,457 Expenditures: Public safety Supplies - - 7,900 - - Contractual services - 50 1,500 - - Capital outlay - - 10,000 - - Sanitation Personal services - - - - - Contractual services - - - - - Culture and recreation: Personal services 87,474 - - - 60,079 Supplies 4,500 - - - 10,900 Contractual services 46,791 - - - 314,738 Capital outlay - - - - 2,500 Economic development Personal services - - - 75,645 - Supplies - - - 330 - Contractual services - - - 15,845 - Capital outlay - - - - - Total expenditures 138,765 50 19,400 91,820 388,217 Surplus of revenues over (under) expenditures (18,365) 750 (13,900) (91,820) (170,760) Other financing sources (uses) Transfers in - - - 91,820 170,000 Transfers out - - - - - Total other financing sources (uses)- - - 91,820 170,000 Net change in fund balance (18,365) 750 (13,900) - (760) Fund balance, January 1:313,010 4,499 49,694 48,748 118,801 Fund balance, December 31 294,645 5,249 35,794 48,748 118,041 4 Lakeside Recycling TIF TIF Park Grant District #2 District #5 2015 2014 - - 168,628 1,299,181 1,585,809 1,992,634 - 25,211 - - 25,211 25,211 23,000 - - - 23,000 21,216 - - - - 216,457 206,090 - - - - 6,300 6,300 300 - 500 4,000 5,800 12,050 250 - - - 2,650 2,650 23,550 25,211 169,128 1,303,181 1,865,227 2,266,151 - - - - 7,900 13,850 - - - - 1,550 1,650 - - - - 10,000 - - 13,570 - - 13,570 12,834 - 11,641 - - 11,641 12,377 3,783 - - - 151,336 144,112 3,000 - - - 18,400 15,950 16,767 - - - 378,296 367,580 - - - - 2,500 4,000 - - - - 75,645 80,735 - - - - 330 360 - - 2,000 1,238,223 1,256,068 1,677,864 - - 1,050,000 - 1,050,000 1,050,000 23,550 25,211 1,052,000 1,238,223 2,977,236 3,381,312 - - (882,872) 64,958 (1,112,009) (1,115,161) - - - - 261,820 437,736 - - (16,863) (64,958) (81,821) (267,736) - - (16,863) (64,958) 179,999 170,000 - - (899,735) - (932,010) (945,161) (3,661) 15,010 880,220 704,178 2,130,499 3,391,015 (3,661) 15,010 (19,515) 704,178 1,198,489 2,445,854 Total 5 2015 Budget Summary Y-T-D 2011 2012 2013 2014 09/30/14 2015 Change from 2014 Actual Actual Actual Budget Actual Request Dollar Percent Cable TV (Fund 210): Revenues 3180 Franchise fee 116,767 119,881 122,921 116,000 61,954 118,000 2,000 1.72% 3680 Other revenue 5,100 5,100 3,750 2,400 1,200 2,400 - 0.00% Total revenue 121,867 124,981 126,671 118,400 63,154 120,400 2,000 1.69% Operating expenses Operations (4350) Personnel services 0100 Salaries, regular 60,079 61,611 62,331 64,758 44,812 65,207 449 0.69% 0150 Salaries, part-time 1,689 1,684 - - - - 0.00% 0300 Social security 4,439 4,711 4,631 4,954 3,307 4,989 35 0.71% 0321 PERA 4,452 4,582 4,496 4,695 3,218 4,890 195 4.15% 0400 Group insurance 7,981 8,937 10,073 10,987 7,916 11,970 983 8.95% 0500 Workers compensation 260 258 253 293 379 418 125 42.66% 0600 Unemployment - - - - - 0.00% Total personnel services 78,901 81,783 81,784 85,687 59,632 87,474 1,787 2.09% Materials & supplies 1230 Supplies, equipment 592 - - 2,000 1,080 3,000 1,000 50.00% 1600 Supplies, operating 2 - - 1,000 428 1,500 500 50.00% Total materials & supplies 594 - - 3,000 1,508 4,500 1,500 50.00% Contractual services 3030 Other professional services 3,600 3,672 3,672 4,800 1,873 7,200 2,400 50.00% 3630 Training & conferences - - - 700 675 300 (400) -57.14% 3800 Mileage & parking 23 16 24 50 24 50 - 0.00% 3900 Grants & subsidies 27,232 27,414 27,658 29,083 28,390 29,241 158 0.54% 5130 Repairs, equipment - - - 10,000 - 10,000 - 0.00% Total contractual services 30,855 31,102 31,354 44,633 30,962 46,791 2,158 4.83% Capital 7030 Equipment - - - - - - - 0.00% Total capital outlays - - - - - - - 0.00% Total expenditures 110,350 112,885 113,138 133,320 92,102 138,765 5,445 4.08% Net change in fund balance 11,517 12,096 13,533 (14,920) (28,948) (18,365) (3,445) 23.09% Fund balance, beginning year 290,784 302,301 314,397 327,930 327,930 313,010 (14,920) -4.55% Fund balance, end of year 302,301$ 314,397$ 327,930$ 313,010$ 298,982$ 294,645$ (18,365)$ -5.87% 6 Fund: 210 Cable TV Revenues Account Description 2012 2013 2014 2015 Description 3180 Franchise fee revenue 100,000 110,000 116,000 118,000 Estimated collections 100,000 110,000 116,000 118,000 3680 Other revenue 5,100 5,100 2,400 2,400 Lease revenue from Library fiber connection 5,100 5,100 2,400 2,400 Fund: 210 Department: 4350 Operations 1230 Supplies, equipment < $5000 2,000 2,000 2,000 3,000 Equipment costing less than $5,000 per item 2,000 2,000 2,000 3,000 1600 Supplies, operating 750 750 1,000 1,250 Recording media - tapes, DVD's 250 250 250 250 Batteries, cables, bulbs, tapes, misc 1,000 1,000 1,250 1,500 3030 Other professional services 4,140 4,260 4,800 7,200 Web streaming meetings $600 per month. 4,140 4,260 4,800 7,200 3630 Training & conferences 300 300 300 300 Attendance at local training - - 400 - NATOA National Conference (local no travel) 300 300 700 300 3800 Mileage & parking 75 75 50 50 Mileage 75 75 50 50 3900 Grants & subsidies 27,232 28,236 29,083 29,241 Share of costs of North Suburban Cable Commission 27,232 28,236 29,083 29,241 5130 Repairs, equipment 10,000 10,000 10,000 10,000 Repair and maintenance of equipment 10,000 10,000 10,000 10,000 7030 Capital, equipment > $5000 - ???Supplemental duct work/air conditioning ($5,000 - $15,000) - ???Video Camera ($5,000 - $8,000) - ???Computer graphics - bulletin board (Tightrope Carousel CG310)($4,000) - ???Video storage network ($5,100) - ???Control room replacement ($100,000 - $200,000) - - - - 44,747 45,871 47,883 51,291 28.09%2.51%4.39%7.12% 7 Y-T-D 2011 2012 2013 2014 09/30/14 2015 Actual Actual Actual Budget Actual Request Dollar Percent DARE (Fund 220): Revenues 3511 Fines - controlled substnc 884 911 837 800 369 800 - 0.00% 3680 Other revenue - 1,500 - - - - - 0.00% Total revenue 884 2,411 837 800 369 800 - 0.00% Operating expenses (4200): Materials & supplies 1600 Supplies, operating 583 1,121 - 1,100 768 (1,100) -100.00% Total Supplies 583 1,121 - 1,100 768 - (1,100) -100.00% Contractual services 3430 Printing - - - 100 - (100) -100.00% 3610 Memberships - - - 50 - 50 - 0.00% Total contractual services - - - 150 - 50 (100) -66.67% Transfers 9900 Transfers out 3,000 - - - - - - 0.00% Total capital outlays 3,000 - - - - - - 0.00% Total expenditures 3,583 1,121 - 1,250 768 50 (1,200) -96.00% Net change in fund balance (2,699) 1,290 837 (450) (399) 750 3,842 -853.82% Fund balance, beginning year 5,520 2,822 4,112 4,949 4,949 4,499 (450) -9.09% Fund balance, end of year 2,822$ 4,112$ 4,949$ 4,499$ 4,550$ 5,249$ 750$ 16.67% 2015 Budget Summary Change from 2014 8 Fund: 220 DARE Revenues Account Description 2012 2013 2014 2015 Description 3511 Fines - controlled substance 500 500 800 800 Estimated collections 500 500 800 800 Fund: 220 Department: 4200 Operations 1600 Supplies, operating 350 350 1,100 - DARE apparel and supplies. 350 350 1,100 - 3430 Printing 100 100 100 - Programs and parent guides. 100 100 100 - 3610 Memberships 50 50 50 50 NSRO, NDOA, & MNDARE. 50 50 50 50 500 500 1,250 50 -86.84%-86.84%-67.11%-90.00% 9 2015 Budget Summary Y-T-D 2011 2011 2013 2014 09/30/14 2015 Change from 2014 Actual Actual Actual Budget Actual Request Dollar Percent Forfeiture (Fund 225): Revenues 3510 Ramsey Co Municipal Court - - - - 1,680 - - #DIV/0! 3514 Forfeitures 14,467 26,676 27,457 5,500 23,348 5,500 - 0.00% Total revenue 14,467 26,676 27,457 5,500 25,028 5,500 - 0.00% Operating expenses (4200): Materials & supplies 1230 Supplies, equipment - - 1,079 12,250 8,306 7,400 (4,850) -39.59% 1600 Supplies, operating 66 28 795 500 9,108 500 - 0.00% Total materials & supplies 66 28 1,874 12,750 17,414 7,900 (4,850) -38.04% Contractual services 3030 Other professional services 4,074 8,976 7,976 1,500 1,500 - 0.00% Total contractual services 4,074 8,976 7,976 1,500 - 1,500 - 0.00% Capital 7030 Equipment 29,186 - - - - 10,000 10,000 #DIV/0! 7040 Vehicles 4,694 - - - 12,914 - - 0.00% Total capital outlays 33,880 - - - 12,914 10,000 10,000 #DIV/0! Total expenses 38,020 9,004 9,850 14,250 30,328 19,400 5,150 36.14% Net change in fund balance (23,553) 17,672 17,607 (8,750) (5,300) (13,900) (5,150) 58.86% Fund balance, beginning year 46,718 23,165 40,837 58,444 58,444 49,694 (8,750) -14.97% Fund balance, end of year 23,165 40,837 58,444 49,694 53,144 35,794 (13,900) -27.97% 10 Fund: 225 Forfeiture Revenues Account Description 2012 2013 2014 2015 Description 3514 Forfeitures 5,500 5,500 5,500 5,500 Sale of forfeited vehicles at auction. 5,500 5,500 5,500 5,500 Fund: 225 Department: 4200 Operations 1230 Supplies - equipment < $5000 - 1,100 1,100 1,100 Taser - 4,000 4,000 1,000 Body camera system - - 950 - Gun clearing safety device - - - 900 Long rifle - - 2,500 - Ballistic shield - - 1,000 1,500 Replacement Glock pistols (5) with trade-in - 2,000 2,700 2,900 Radar - 7,100 12,250 7,400 1600 Supplies - operating 500 500 500 500 Supplies to prepare vehicles for auction. (tows, title fees, batteries) 500 500 500 500 3030 Other professional services 1,500 1,500 1,500 1,500 Share of auction costs. 1,500 1,500 1,500 1,500 7030 Equipment > $5000 - - - 10,000 (2) In-squad cameras - - - - One squad $23,000 + set-up $6000 One in General Fund. - - - 10,000 2,000 9,100 14,250 19,400 -93.55%355.00%56.59%36.14% 11 Y-T-D 2011 2012 2013 2014 09/30/14 2015 Change from 2014 Actual Actual Actual Budget Actual Request Dollar Percent EDA (Fund 230): Revenues 3610 Investment income 3 5 4 - - - - 0.00% 3615 Interest received on notes 99 172 439 - - - - 0.00% 3680 Other revenue 5,743 5,858 5,988 - 2,500 - - 0.00% 3972 Transfers 168,091 134,758 119,870 267,736 - 91,820 (175,916) -65.71% Total revenue 173,936 140,793 126,301 267,736 2,500 91,820 (175,916) -65.71% Operating expenses Economic Development (4650): Personnel services 0100 Salaries, regular 76,297 83,852 74,095 63,023 20,505 56,641 (6,382) -10.13% 0300 Social security 5,763 6,219 5,601 4,821 1,550 4,334 (487) -10.10% 0321 PERA 5,470 6,048 5,319 4,568 1,460 4,249 (319) -6.98% 0400 Group insurance 9,455 10,991 10,991 7,925 2,096 9,906 1,981 25.00% 0500 Workers compensation 382 399 435 398 513 515 117 29.40% Total personnel services 97,367 107,509 96,441 80,735 26,124 75,645 (5,090) -6.30% Materials & supplies 1600 Supplies, operating - - 11 100 - 100 - 0.00% 2100 Book & periodicals 175 229 249 260 278 230 (30) -11.54% Total materials & supplies 175 229 260 360 278 330 (30) -8.33% Contractual services 3030 Other professional services 18,325 23,265 19,059 73,400 27,286 13,080 (60,320) -82.18% 3420 Advertisements 365 1,246 1,635 1,500 - - (1,500) -100.00% 3430 Printing 156 857 9 1,000 - 600 (400) -40.00% 3610 Memberships 3,236 3,551 4,751 3,736 3,251 710 (3,026) -81.00% 3630 Training & conferences 694 1,030 518 2,305 810 1,000 (1,305) -56.62% 3800 Mileage 22 - 27 100 25 100 - 0.00% 4800 Insurance 3,494 2,929 3,158 4,600 3,037 355 (4,245) -92.28% 5210 Housing replacement 451 493 1,030 50,000 - - (50,000) -100.00% Total contractual services 26,744 33,371 30,187 136,641 34,409 15,845 (120,796) -88.40% Capital outlays 9300 Business subsidies - - - 50,000 - - (50,000) -100.00% Total capital outlays - - - 50,000 - - (50,000) -100.00% Total expenditures 124,285 141,109 126,888 267,736 60,811 91,820 (175,916) -65.71% Net change in fund balance 49,651 (316) (587) - (58,311) - - 0.00% Fund balance, beginning year - 49,651 49,335 48,748 48,748 48,748 - 0.00% Fund balance, end of year 49,651 49,335 48,748 48,748 (9,563) 48,748 - 0.00% 2015 Budget Summary 12 Fund: 230 EDA Revenues Account Description 2012 2013 2014 2015 Description 3610 Interest income - - - - Estimated interest earnings at 1.25%. - - - - 3635 Rental income - - - - Rental on EDA owned houses - - - - 3972 Transfers 389,437 388,840 268,636 81,820 Transfers from TIF 2,5 - - - 10,000 Transfers from General Fund 389,437 388,840 268,636 91,820 Fund: 230 Department: 4650 Economic Development 1600 Supplies, operating 100 100 100 100 Misc office supplies 100 100 100 100 2100 Books & periodicals 30 30 30 - LMC directory 170 230 230 230 Misc. reports & periodicals (Finance & Commerce) 200 260 260 230 3030 Other professional services 7,000 6,500 6,500 - Legal fees for development reviews 12,000 11,000 11,000 - Financial consultant fees (Ehlers) 25,000 24,000 24,000 - Special project consultant fees 5,000 4,500 4,500 - Appraisal and environmental fees 4,498 4,560 4,650 1,580 5% audit fee (reduced from 15%) 12,500 12,750 12,750 11,500 Housing Resource Center fees 3,000 3,000 10,000 - Marketing Consultant fees 68,998 66,310 73,400 13,080 3420 Advertising 1,000 1,000 1,500 - Targeted advertisements. 1,000 1,000 1,500 - 3430 Printing 500 500 500 500 Property ad printing 200 200 200 - Stationary/business cards/signs/site info 300 300 300 100 Misc printing 1,000 1,000 1,000 600 3610 Memberships 400 400 400 400 Economic Development Assoc of MN (EDAM) 250 250 250 250 Twin Cities North Chamber of Commerce dues - 60 60 60 MN Assoc. of Govt. Communicators (MAGC) - 225 225 - Urban Land Institute 2,801 2,801 2,801 - North Metro Mayors Assoc (all in General Fund for 2015) 3,451 3,736 3,736 710 3630 Training & conferences 300 300 300 - Chamber of Commerce meetings 650 650 650 - DEED/ EDC training 300 300 300 - EDAM monthly meetings 600 600 600 600 EDAM summer conference 150 150 455 400 Other miscellaneous training (Ehlers Finance Seminar) 2,000 2,000 2,305 1,000 3800 Mileage 100 100 100 100 Misc. mileage 4800 Insurance 4,600 4,600 4,600 355 Allocation of the City's property & liability insurance (moved to Central Serv) 4,600 4,600 4,600 355 5210 Housing programs 150,000 150,000 50,000 - Housing Improvement programs 150,000 150,000 50,000 - 9300 Business loans/subsidies 50,000 50,000 50,000 - Business improvement partnership loans/subsidies 50,000 50,000 50,000 - 281,449 279,106 187,001 16,175 -1.93%-0.83%-33.00%-91.35% 13 THIS PAGE LEFT BLANK INTENTIONALLY 14 2015 Budget Summary Y-T-D 2011 2012 2013 2014 09/30/14 2015 Change from 2014 Actual Actual Actual Budget Actual Request Dollar Percent Community Center (Fund 252): Building overhead (4350) Building overhead revenues 178,288 171,831 144,298 171,000 1,166 171,000 - 0.00% Building overhead expenditures - - - - 36,390 - - 0.00% Net Building Overhead Operations 178,288 171,831 144,298 171,000 (35,224) 171,000 - 0.00% Banquet Center (4730): Banquet revenues 91,136 82,471 106,268 84,000 61,901 86,000 2,000 2.38% Banquet Center expenditures 128,685 207,066 127,495 114,766 88,022 116,649 1,883 1.64% Net Banquet Center (37,549) (124,595) (21,227) (30,766) (26,121) (30,649) 117 -0.38% YMCA (4732): YMCA revenues 48,118 52,620 61,138 35,425 25,916 45,425 10,000 28.23% YMCA expenditures 215,981 253,667 215,783 223,193 166,221 233,599 10,406 4.66% Net YMCA (167,863) (201,047) (154,645) (187,768) (140,305) (188,174) (406) 0.22% Chamber of Commerce (4734): Chamber revenues - - 3,495 3,300 - - (3,300) -100.00% Chamber expenditures - - 5,733 1,712 2,693 - (1,472) -85.98% Net Chamber of Commerce - - (2,238) 1,588 (2,693) - (1,828) -115.11% Creative Kids Child Care Center (4736): Creative Kids revenues 77,379 79,900 81,730 83,365 62,351 85,032 1,667 2.00% Creative Kids expenditures 38,370 47,933 40,128 36,942 23,379 37,969 1,027 2.78% Net Creative Kids 39,009 31,967 41,602 46,423 38,972 47,063 640 1.38% Total revenue 394,922 386,822 396,929 377,090 151,334 387,457 10,367 2.75% Total expenditures 383,036 508,666 389,139 376,613 316,705 388,217 11,844 3.14% Net change in fund balance 11,886 (121,844) 7,790 477 (165,371) (760) (1,477) -309.73% Fund balance, beginning year 228,283 240,168 118,324 118,324 118,324 118,801 477 0.40% Fund balance, end of year 240,168 118,324 126,114 118,801 (47,047) 118,041 (760) -0.64% (continued) 15 2015 Budget Summary YTD 2011 2012 2013 2014 09/30/14 2015 Change from 2014 Actual Actual Actual Budget Actual Request Dollar Percent Community Center (continued): Building overhead (4350) Building revenues: 3610 Investment income 2,710 1,519 (1,295) 1,000 1,211 1,000 - 0.00% 3634 Equipment rental 18 - 153 - - - - 0.00% 3650 Donations 5,358 - - - - - - 0.00% 3680 Miscellaneous 202 312 440 - (45) - - 0.00% 3972 Transfers 170,000 170,000 145,000 170,000 - 170,000 - 0.00% 178,288 171,831 144,298 171,000 1,166 171,000 - 0.00% Operating expenses Personnel services 0100 Salaries, regular 35,867 35,864 36,391 36,502 25,778 39,716 3,214 8.80% 0110 Salaries,overtime 757 284 1,328 1,755 2,110 1,611 (144) -8.21% 0300 Social Security 2,377 2,566 2,713 2,926 2,051 3,161 235 8.03% 0321 PERA 2,622 2,594 2,710 2,773 1,994 3,100 327 11.79% 0400 Group insurance 7,774 8,212 8,652 9,000 6,798 9,792 792 8.80% 0500 Workers compensation 1,371 1,361 1,489 1,739 2,243 2,699 960 55.20% 999 Allocation of salaries (50,768) (50,881) (53,283) (54,695) (31,118) (60,079) (5,384) 9.84% Total personnel services - - - - 9,856 - - 0.00% Materials & supplies 1210 Supplies, buildings & grounds 1,647 2,176 2,961 1,150 2,477 1,150 - 0.00% 1230 Supplies, equipment 686 877 1,972 800 188 800 - 0.00% 1600 Supplies, operating 4,822 5,132 7,923 7,000 4,170 7,000 - 0.00% 2400 Uniforms 616 626 432 650 341 550 (100) -15.38% 2410 Mats & towels 712 654 253 1,250 2,321 1,000 (250) -20.00% 2999 Allocation of supplies (8,483) (9,465) (13,541) (10,850) (5,998) (10,500) 350 -3.23% Total materials & supplies - - - - 3,499 - - 0.00% Contractual services 3030 Other professional services 1,921 4,250 1,352 200 343 1,000 800 400.00% 3100 Telephone 3,374 2,740 2,839 3,600 2,144 3,200 (400) -11.11% 3200 Water & sewer 7,473 8,198 7,871 9,000 3,712 9,000 - 0.00% 3210 Electricity 60,978 56,410 65,926 58,000 40,104 58,000 - 0.00% 3220 Natural gas 12,181 8,496 12,282 10,000 9,707 11,000 1,000 10.00% 3530 Refuse collection 4,124 4,215 2,723 4,420 1,809 3,980 (440) -9.95% 3610 Memberships - - - - 30 - 0.00% 3630 Training & conferences - - 73 - 58 - 0.00% 3999 Allocation of utilities (89,281) (84,309) (93,066) (85,220) (41,409) (86,180) (960) 1.13% 5110 Repairs, building & grounds 25,564 70,533 14,592 17,330 10,480 18,770 1,440 8.31% 5130 Repairs, equipment 11,402 28,574 17,944 6,700 8,084 6,500 (200) -2.99% 5999 Allocation of repairs (37,736) (99,107) (32,536) (24,030) (12,027) (25,270) (1,240) 5.16% Total contractual services - - - - 23,035 - - 0.00% Capital 7030 Equipment - - - - - - 0.00% Total capital outlays - - - - - - - 0.00% Total Building Overhead Net 178,288 171,831 144,298 171,000 (35,224) 171,000 - 0.00% (continued) 16 Fund: 252 Department: 4350 Community Center Building Overhead Expenditures Account Description 2012 2013 2014 2015 Description 1210 Supplies, bldgs & grounds 1,100 1,100 1,150 1,150 Lights, signs, fertilizer 1,100 1,100 1,150 1,150 1230 Supplies, equipment < $5000 800 800 800 800 Small tools & equipment 800 800 800 800 1600 Supplies, operating 7,000 7,000 7,000 7,000 Batteries, soap, paper towels, cleaning supplies for bathrooms Paper cups, plates, etc. for lounge & customer service events 7,000 7,000 7,000 7,000 2400 Uniforms 582 582 650 550 Uniforms/Clothing 7.5% 582 582 650 550 2410 Mats & towels 2,000 1,250 1,000 750 Floor mats and cleaning towelsto provide better protection of carpets 800 500 250 250 Special events 2,800 1,750 1,250 1,000 3030 Other professional services 200 200 200 1,000 Backflow inspection, annual sprinkler test, alarm inspection, 200 200 200 1,000 3100 Telephone & internet 3,600 3,600 3,600 3,200 Office & customer phones, internet, maintenance agreements, & repairs 3,600 3,600 3,600 3,200 3200 Water & Wastewater 9,500 9,000 9,000 9,000 Water & sewer charges for community center 9,500 9,000 9,000 9,000 3210 Electricity 56,000 62,000 58,000 58,000 Estimated electrice charges 56,000 62,000 58,000 58,000 3220 Natural gas 17,000 14,000 10,000 11,000 Estimated natural gas charges 17,000 14,000 10,000 11,000 3530 Refuse collection 3,720 3,720 3,120 3,280 Dumpsters $273 x 12 months 680 680 1,200 600 Extra garbage pick-up charges 100 100 100 100 Ramsey County recyclying fee 4,500 4,500 4,420 3,980 5110 Repairs, building & grounds 5,760 5,760 5,760 7,200 Custodial services: 12 mths X $480 3,000 3,000 3,000 3,000 Commercial carpet cleaning service (twice annually) 4,500 4,500 4,500 4,500 Exterior building maintenance 770 770 770 770 Exterminator: 12 months X 64.02 1,500 1,500 1,500 1,500 Fire alarm system service 1,300 1,300 1,300 1,300 Parking lot & grounds maintenance 500 500 500 500 Security system service 17,330 17,330 17,330 18,770 5130 Repairs, equipment 5,000 5,000 5,000 5,000 HVAC system maintenance 200 200 200 - Sprinkler inspections (moved to 3030) 1,500 1,500 1,500 1,500 Plumbing, electrical, & misc. interior maintenance 6,700 6,700 6,700 6,500 7030 Capital, equipment > $5000 - - - - HVAC Improvements - - - - Community Center Roof repairs - - - - 127,112 128,562 120,100 121,950 -8.72%1.14%-6.58%1.54% 17 2015 Budget Summary Y-T-D 2011 2012 2013 2014 09/30/14 2015 Change from 2014 Actual Actual Actual Budget Actual Request Dollar Percent Community Center (continued): Banquet Center (4730): Banquet Revenues 3644 Equipment rental - - - - 1,435 - - 0.00% 3645 Rental - banquet facility 91,136 82,471 106,268 84,000 60,466 86,000 2,000 2.38% 0.00% 91,136 82,471 106,268 84,000 61,901 86,000 2,000 2.38% Banquet Expenditures Personnel services 0999 Allocation of salaries 10,144 10,452 10,754 10,939 6,224 12,016 1,077 9.84% Total personnel services 10,144 10,452 10,754 10,939 6,224 12,016 1,077 9.84% Materials & supplies 1210 Supplies, buildings & grounds - 82 - - - - - 0.00% 1230 Supplies, equipment 4,220 587 4,354 - 78 - - 0.00% 2999 Allocation of supplies 2,484 2,650 3,791 3,038 1,679 2,940 (98) -3.23% Total materials & supplies 6,704 3,319 8,145 3,038 1,757 2,940 (98) -3.23% Contractual services 3030 Other professional services 62,096 61,763 62,504 59,337 61,252 61,441 2,104 3.55% 3100 Telephone 607 180 - - - - - 0.00% 3420 Advertising 66 - - 500 - 500 - 0.00% 3430 Printing - - - 250 - 250 - 0.00% 3999 Allocation of utilities 27,705 22,458 25,725 23,574 11,455 23,874 300 1.27% 4800 Bonding & insurance 1,595 1,337 1,442 2,100 1,386 2,100 - 0.00% 5110 Repairs, building & grounds 5,940 18,840 7,182 2,700 2,580 2,700 - 0.00% 5130 Repairs, equipment 1,215 449 2,633 1,600 - 1,600 - 0.00% 5999 Allocation of repairs 12,613 27,750 9,110 6,728 3,368 6,728 - 0.00% Total contractual services 111,837 132,777 108,596 96,789 80,041 99,193 2,404 2.48% Capital 7030 Equipment - 60,518 - 4,000 - 2,500 (1,500) -37.50% Total capital outlays - 60,518 - 4,000 - 2,500 (1,500) -37.50% 128,685 207,066 127,495 114,766 88,022 116,649 1,883 1.64% Total Banquet Center net (37,549) (124,595) (21,227) (30,766) (26,121) (30,649) 117 -0.38% (continued) 18 Fund: 252 Community Center - 4730 Banquet Center Expenditures Account Description 2012 2013 2014 2015 Description 2999 Allocation of supplies 3,439 3,145 3,038 2,940 28% Allocation from overall building support 3,439 3,145 3,038 2,940 3030 Other professional services 745 760 775 790 2.5% of audit 2,600 2,600 2,600 2,600 Miscellaneous professional services (linen service) 50,411 51,923 52,962 54,551 Banquet facility management - - 2,500 3,000 Extra staff for large events 1,500 1,500 500 500 Legal costs 55,256 56,783 59,337 61,441 3100 Telephone/Internet 500 - - - Internet service (1/2 reimbursed from other tenants) 500 - - - 3420 Advertising & marketing 500 500 500 500 Website and traditional advertising, marketing 500 500 500 500 3430 Printing 250 250 250 250 Brochures, flyers, etc. 250 250 250 250 3999 Allocation of utilities 25,136 25,836 23,574 23,874 28% Allocation from overall building utilities 25,136 25,836 23,574 23,874 4800 Bonding & insurance 2,100 2,100 2,100 2,100 Insurance & bonding cost 2,100 2,100 2,100 2,100 5110 Repairs, building & grounds 1,200 1,200 1,200 1,200 Interior building repairs specific to the banquette center 500 500 1,500 1,500 Dance floor maintenance 1,700 1,700 2,700 2,700 5130 Repairs, equipment 1,600 1,600 1,600 1,600 Repairs to kitchen, audio system, and other banquette equipment 1,600 1,600 1,600 1,600 5999 Allocation of repairs 6,728 6,728 6,728 6,728 28% Allocation from overall building repairs 6,728 6,728 6,728 6,728 7030 Capital, equipment > $5000 4,000 4,000 4,000 2,500 Tables or other banquet equipment replacement 40,000 - - - Chairs for banquet center (400 @ $100) 44,000 4,000 4,000 2,500 141,209 102,642 103,827 104,633 2.29%-27.31%1.15%0.78% 19 2015 Budget Summary YTD 2011 2012 2013 2014 09/30/14 2015 Actual Actual Actual Budget Actual Request Dollar Percent Community Center (continued): YMCA (4732): YMCA Revenues 3405 Recreation profit 24,767 20,811 19,124 15,000 - 15,000 - 0.00% 3660 Gym & meeting room rental 9,395 13,947 23,139 7,000 12,483 15,000 8,000 114.29% 3661 Open gym participant fees 13,693 17,576 18,363 13,000 13,107 15,000 2,000 15.38% 3679 Commissions - vending 263 286 512 425 326 425 - 0.00% 48,118 52,620 61,138 35,425 25,916 45,425 10,000 28.23% YMCA Expenditures Personnel services - 0999 Allocation of salaries 35,829 36,635 36,764 38,833 21,471 43,257 4,424 11.39% Total personnel services 35,829 36,635 36,764 38,833 21,471 43,257 4,424 11.39% Materials & supplies 1230 Supplies, equipment - - - - - 400 400 #DIV/0! 1600 Supplies, operating - 4,221 - - - - - 0.00% 2999 Allocation of supplies 4,496 5,016 6,771 5,642 2,999 5,565 (77) -1.36% Total materials & supplies 4,496 9,237 6,771 5,642 2,999 5,965 323 5.72% Contractual services 3030 Other professional services 94,703 96,598 97,204 99,325 100,808 102,370 3,045 3.07% 3300 Postage - - - 1,200 - 600 (600) -50.00% 3430 Printing 5,142 5,642 5,797 6,000 4,609 6,600 600 10.00% 3999 Allocation of utilities 45,231 48,105 47,468 45,322 21,124 46,539 1,217 2.69% 4010 Rental, equipment - - - - - 500 500 #DIV/0! 4800 Bonding & insurance 3,057 2,562 2,763 4,025 2,657 4,025 - 0.00% 5110 Repairs, building & grounds 7,187 106 1,180 9,000 4,261 9,000 - 0.00% 5130 Repairs, equipment 2,382 2,255 1,568 1,350 2,278 1,350 - 0.00% 5999 Allocation of repairs 17,954 52,527 16,268 12,496 6,014 13,393 897 7.18% Total contractual services 175,656 207,795 172,248 178,718 141,751 184,378 5,660 3.17% 215,981 253,667 215,783 223,193 166,221 233,599 10,406 4.66% Total YMCA net (167,863) (201,047) (154,645) (187,768) (140,305) (188,174) (406) 0.22% (continued) Change from 2014 20 Fund: 252 Community Center - 4732 YMCA Expenditures Account Description 2012 2013 2014 2015 Description 1230 Supplies, equipment - - - 400 Miscellaneous - - - 400 2999 Allocation of supplies 6,509 5,953 5,642 5,565 52% Allocation from overall building support 6,509 5,953 5,642 5,565 3030 Other professional services 97,270 100,188 97,000 100,000 YMCA management contract (other half of fee in parks) 2,235 2,280 2,325 2,370 7.5% of audit 99,505 102,468 99,325 102,370 3300 Postage 1,200 1,200 1,200 600 52% of the cost of mailing the Mounds View Matters newsletter 1,200 1,200 1,200 600 3430 Printing 6,000 6,000 6,000 6,600 52% of the cost of printing the Mounds View Matters newsletter 6,000 6,000 6,000 6,600 3999 Allocation of utilities 49,096 50,421 45,322 46,539 52% Allocation from overall building utilities 49,096 50,421 45,322 46,539 4010 Rental, equipment - - - 500 Scissor lift rental - - - 500 4800 Bonding & insurance 4,025 4,025 4,025 4,025 Insurance & bonding cost. 4,025 4,025 4,025 4,025 5110 Repairs, building & grounds 3,000 3,000 3,000 3,000 General building repairs 7,000 4,000 4,000 4,000 Interior improvements 2,000 2,000 2,000 2,000 Gym floor resurfacing & maintenance 12,000 9,000 9,000 9,000 5130 Repairs, equipment 2,650 2,650 500 - Copier maintenance contract 1,000 1,000 500 500 Registration system support 350 350 350 850 Repairs to other equipment 4,000 4,000 1,350 1,350 5999 Allocation of repairs 12,736 12,736 12,496 13,393 52% Allocation from overall building repairs 12,736 12,736 12,496 13,393 195,071 195,803 184,360 189,942 -0.52%0.38%-5.84%3.03% 21 2015 Budget Summary 2011 2012 2013 2014 09/30/14 2015 Change from 2014 Actual Actual Actual Budget Actual Request Dollar Percent Chamber of Commerce (4734); Chamber of Commerce Revenues 3633 Lease - Chamber of Commerce - - 3,495 3,300 - - (3,300) -100.00% - - 3,495 3,300 - - (3,300) -100.00% Chamber of Commerce Expenditures Personnel services 0999 Allocation of salaries - - 1,598 547 934 - (547) -100.00% Total personnel services - - 1,598 547 934 - (547) -100.00% Materials & supplies 2999 Allocation of supplies - - 406 109 180 - (109) -100.00% Total materials & supplies - - 406 109 180 - (109) -100.00% Contractual services 3999 Allocation of utilities - - 2,753 816 1,218 - (816) -100.00% 5999 Allocation of repairs - - 976 240 361 - (240) -100.00% Total contractual services - - 3,729 1,056 1,579 - (816) -77.27% 0 - - 5,733 1,712 2,693 - (1,472) -85.98% Total Chamber of Commerce Net - - (2,238) 1,588 (2,693) - (1,828) -115.11% (continued) 22 2015 Budget Summary YTD 2011 2012 2013 2014 09/30/14 2015 Change from 2014 Actual Actual Actual Budget Actual Request Dollar Percent Creative Kids Child Care (4736): Child Care Revenues 3632 Lease - Child Care 77,379 79,900 81,730 83,365 62,351 85,032 1,667 2.00% 77,379 79,900 81,730 83,365 62,351 85,032 1,667 2.00% Child Care Ed Expenditures (19%) Personnel services 0999 Allocation of salaries 4,080 4,071 4,263 4,376 2,489 4,806 430 9.83% Total personnel services 4,080 4,071 4,263 4,376 2,489 4,806 430 9.83% Materials & supplies 2999 Allocation of supplies 1,612 1,798 2,572 2,062 1,139 1,995 (67) -3.25% Total materials & supplies 1,612 1,798 2,572 2,062 1,139 1,995 (67) -3.25% Contractual services 3999 Allocation of utilities 16,344 13,747 17,120 15,508 7,612 15,766 258 1.66% 4750 Taxes, licenses, & fees 8,100 8,596 9,030 9,030 8,930 9,200 170 1.88% 4800 Bonding & insurance 1,063 891 961 1,400 924 1,400 - 0.00% 5999 Allocation of repairs 7,170 18,830 6,182 4,566 2,285 4,801 235 5.15% Total contractual services 32,678 42,064 33,293 30,504 19,751 31,168 664 2.18% Total Child Care expenditures 38,370 47,933 40,128 36,942 23,379 37,969 1,027 2.78% Total Child Care net 39,009 31,967 41,602 46,423 38,972 47,063 640 1.38% 23 2015 Budget Summary Y-T-D 2011 2012 2013 2014 09/30/14 2015 Change from 2014 Actual Actual Actual Budget Actual Request Dollar Percent Lakeside Park (Fund 255): Revenues 3370 Spring Lake Pk contribution 10,608 10,608 10,608 10,608 10,608 11,500 892 8.41% 3370 Mounds View contribution 10,608 23,108 10,608 10,608 10,608 11,500 892 8.41% 3610 Investment income 362 219 (466) 300 576 300 - 0.00% 3665 Park site permit 201 571 448 250 461 250 - 0.00% 3680 Other revenue 25,209 9,558 - - - - 0.00% Total revenue 46,989 44,064 21,198 21,766 22,253 23,550 1,784 8.20% Operating expenses (4350): Personnel services 0150 Salaries, part-time 3,360 3,320 3,360 3,360 1,533 3,360 - 0.00% 0300 Social security 257 254 257 257 117 257 - 0.00% 0500 Workers compensation 84 83 106 113 146 166 53 46.90% Total personnel services 3,701 3,657 3,723 3,730 1,796 3,783 53 1.42% Materials & supplies 1210 Supplies, bldgs & grounds 1,058 1,844 458 600 - 1,200 600 100.00% 1600 Supplies, operating 671 4,483 4,337 1,500 - 1,800 300 20.00% Total materials & supplies 1,730 6,327 4,795 2,100 - 3,000 900 42.86% Contractual services 3030 Other professional services - - - - - - - 0.00% 3200 Water & sewer 1,962 2,428 1,646 1,400 767 1,600 200 14.29% 3210 Electricity 1,421 1,021 984 1,400 1,305 1,600 200 14.29% 3530 Refuse collection 48 48 48 250 - 75 (175) -70.00% 4010 Equipment Contribution SLP 4,481 4,986 4,986 4,372 - 4,600 228 5.22% 4030 Satellites 260 520 609 500 552 500 - 0.00% 4800 Insurance 4,150 4,411 4,638 4,500 - 4,800 300 6.67% 5130 Repairs, equipment 324 992 2,558 3,514 - 3,592 78 2.22% Total contractual services 12,646 14,406 15,469 15,936 2,624 16,767 831 5.21% Capital 7030 Equipment - 13,385 - - - - - 0.00% 7050 Construction - 33,878 13,361 - - - - 0.00% Total capital outlays - 47,263 13,361 - - - - 0.00% Total expenses 18,077 71,653 37,348 21,766 4,420 23,550 1,784 8.20% Net change in fund balance 28,912 (27,589) (16,150) - 17,833 - - 0.00% Fund balance, beginning year 11,165 40,078 12,489 (3,661) (3,661) (3,661) - 0.00% Fund balance, end of year 40,078 12,489 (3,661) (3,661) 14,172 (3,661) - 0.00% 24 Fund: 255 Lakeside Park Revenues Account Description 2012 2013 2014 2015 Description 3370 Contributions 10,608 10,608 10,608 11,500 Spring Lake Park contribution for half of cost for joint park 10,608 10,608 10,608 11,500 3370 Contributions 10,608 10,608 10,608 11,500 Mounds View contribution for half of cost for joint park 10,608 10,608 10,608 11,500 3610 Interest revenue 300 300 300 300 Estimated interest earnings at 1.25%. 300 300 300 300 3680 Park sit rental 250 250 250 250 Rental of the park by groups or individuals 250 250 250 250 Fund: 255 Department: 4350 Expenditures 1210 Supplies, bldgs & grounds 600 600 600 1,200 Paper, sand, etc. 600 600 600 1,200 1600 Supplies, operating 1,800 1,500 1,500 1,800 Fertilizer & pesticides 1,800 1,500 1,500 1,800 3200 Water & sewer 1,400 1,400 1,400 1,600 Estimated water & sewer charges 1,400 1,400 1,400 1,600 3210 Electricity 1,500 1,400 1,400 1,600 Estimated electric charges 1,500 1,400 1,400 1,600 3530 Refuse collection 250 250 250 75 Six months service 250 250 250 75 4010 Equipment, capital charge 4,372 4,372 4,372 4,600 Capital charge for usage of SLP city equipment 4,372 4,372 4,372 4,600 4030 Satellites 500 500 500 500 Five months service 500 500 500 500 4800 Insurance & bonds 4,200 4,500 4,500 4,800 Property & liability insurnace 4,200 4,500 4,500 4,800 5130 Repairs, equipment 3,445 3,514 3,514 3,592 Repair of equipment at the park 3,445 3,514 3,514 3,592 18,067 18,036 18,036 19,767 0.56%-0.17%0.00%9.60% 25 2015 Budget Summary Y-T-D 2011 2012 2013 2014 09/30/14 2015 Change from 2014 Actual Actual Actual Budget Actual Request Dollar Percent Recycling (Fund 290): Revenues 3360 Other County grants 26,185 25,199 24,565 25,211 8,210 25,211 - 0.00% 3610 Investment income 220 85 (209) - 258 - - 0.00% 3680 Other revenue - - - - - - - 0.00% Total revenue 26,405 25,284 24,356 25,211 8,468 25,211 - 0.00% Operating expenses Operations (4420) Personnel services 0100 Salaries, regular 8,728 8,470 8,650 8,929 6,187 9,481 552 6.18% 0110 Salaries, overtime - - - - 107 - 0.00% 0300 Social security 564 554 565 683 412 725 42 6.15% 0321 PERA 632 615 625 647 452 711 64 9.89% 0400 Group insurance 2,303 2,311 2,416 2,520 1,842 2,570 50 1.98% 0500 Workers compensation 56 54 58 55 71 83 28 50.91% 0990 Severence pay - - - - 0.00% Total personnel services 12,283 12,004 12,314 12,834 9,071 13,570 736 5.73% Materials & supplies 1600 Supplies, operating - 3,864 3,252 - - - - 0.00% Contractual services 3030 Other professional services 824 - - - - - - 0.00% 3300 Postage 2,682 4,552 4,671 3,000 5,730 3,600 600 20.00% 3430 Printing 2,161 1,595 860 1,600 1,936 1,000 (600) -37.50% 3530 Refuse collection 12,982 3,345 3,892 7,777 2,716 7,041 (736) -9.46% Total contractual services 18,650 9,492 9,423 12,377 10,382 11,641 (736) -5.95% Total expenses 30,933 25,360 24,989 25,211 19,453 25,211 - 0.00% Net change in fund balance (4,528) (76) (633) - (10,985) - - 0.00% Fund balance, beginning year 20,247 15,719 15,643 15,010 15,010 15,010 - 0.00% Fund balance, end of year 15,719 15,643 15,010 15,010 4,025 15,010 - 0.00% 26 Fund: 290 Recycling Grant Revenues Account Description 2012 2013 2014 2015 Description 3360 Other grants & aid 25,199 25,133 25,133 25,133 Estimated Ramsey County recycling grant 25,199 25,133 25,133 25,133 Fund: 290 Department: 4420 Expenditures 1600 Supplies, operatin - - - - - - - - 3030 Other professional services - - - - - - - - 3300 Postage 1,700 1,700 3,000 3,000 City wide mailing for Cleanup Day and Newsletter 1,700 1,700 3,000 3,000 3420 Advertisements - - - - Promotional items - - - - 3430 Printing 600 600 800 800 Articles in City newsletter 800 800 800 800 Clean-up Day printing of direct mailing items 1,400 1,400 1,600 1,600 3530 Refuse collection 10,138 9,868 7,777 7,777 Contractual services for City Cleanup Day 10,138 9,868 7,777 7,777 13,238 12,968 12,377 12,377 -6.68%-2.04%-4.56%0.00% 27 2015 Budget Summary Y-T-D 2011 2012 2013 2014 09/30/14 2015 Change from 2014 Actual Actual Actual Budget Actual Request Dollar Percent TIF # 2 (Fund 420): Revenues 3101 Tax collections 150,264 167,454 185,688 168,628 88,607 168,628 - 0.00% 3102 Tax collections - delinquent 6,999 3,696 5,247 - - - - 0.00% 3103 Market value credit - - - - - - - 0.00% 3610 Investment income 8,279 6,083 (16,973) 1,750 21,868 500 (1,250) -71.43% 3680 Other revenue - - - - 230 - - 0.00% 3972 Transfer from other funds - - - - - - 0.00% Total revenue 165,542 177,233 173,962 170,378 110,705 169,128 (1,250) -0.73% Operating expenses (4650): Contractual services 3030 Other professional 2,460 837 874 2,000 461 2,000 - 0.00% 7050 Construction - - - - - 1,050,000 1,050,000 #DIV/0! 8010 Developer PAG, principal 42,495 19,120 - - - - - 0.00% 9900 Transfers out to EDA 35,893 23,794 21,403 101,389 - 16,863 (84,526) -83.37% Total contractual services 80,848 43,751 22,277 103,389 461 1,068,863 965,474 933.83% Net change in fund balance 84,694 133,482 151,685 66,989 110,244 (899,735) (966,724) -1443.11% Fund balance, beginning year 443,371 528,064 661,546 813,231 813,231 880,220 66,989 8.24% Fund balance, end of year 528,064 661,546 813,231 880,220 923,475 (19,515) (899,735) -102.22% 28 Fund: 420 TIF District #2 Revenues Account Description 2012 2013 2014 2015 Description 3101 Tax increment collections 154,335 154,335 168,628 168,628 Estimated collections of incremental taxes on properties 154,335 154,335 168,628 168,628 in the district. 3610 Investment income 2,500 2,500 1,750 500 Estimated interest earnings at 1.00%. 2,500 2,500 1,750 500 Fund: 420 Department: 4650 Economic Development 3030 Other professional services 2,000 2,000 2,000 2,000 TIF administration and reporting fees 2,000 2,000 2,000 2,000 7050 Construction > $25000 - - - 250,000 2015 Area H Street Proj - - - 450,000 Mill and overlay Mustang Drive - - - 350,000 Trail segments 6 & 11 - - - 1,050,000 8010 Pay-as-you-go principal 38,238 - - - Principal on a revenue note issued to promote a development. 38,238 - - - (Silver Lake Point Project - Heartland MV Common Bond, LLC.) 9900 Transfer out to EDA Fund 109,674 107,500 101,389 16,863 Transfer to cover the EDA operating budget. 109,674 107,500 101,389 16,863 149,912 109,500 103,389 1,068,863 -3.34%-26.96%-5.58%933.83% 29 Y-T-D 2011 2012 2013 2014 09/30/14 2015 Actual Actual Actual Budget Actual Request Dollar Percent TIF # 5 (Fund 450): Revenues 3101 Tax collections 1,208,260 1,326,776 1,390,103 1,299,181 707,606 1,299,181 - 0.00% 3610 Investment income 6,818 2,435 (8,333) 4,000 10,696 4,000 - 0.00% Total revenue 1,215,078 1,329,211 1,381,770 1,303,181 718,302 1,303,181 - 0.00% Operating expenses (4650): Contractual services 3030 Other professional 2,839 1,122 1,315 3,000 656 4,000 1,000 33.33% 8010 Developer PAG, principal - - 132,268 - 765,609 - - 0.00% 8020 Developer PAG, interest 1,458,101 1,204,143 1,158,249 1,234,223 566,916 1,234,223 - 0.00% 9900 Transfers out to EDA 60,413 63,376 69,505 64,958 - 64,958 - 0.00% Total contractual services 1,521,354 1,268,641 1,361,337 1,302,181 1,333,181 1,303,181 1,000 0.08% Net change in fund balance (306,276) 60,570 20,433 1,000 (614,879) - (1,000) -100.00% Fund balance, beginning year 928,451 622,175 682,745 703,178 703,178 704,178 1,000 0.14% . Fund balance, end of year 622,175 682,745 703,178 704,178 88,299 704,178 - 0.00% 2015 Budget Summary Change from 2014 30 Fund: 450 TIF District #5 Revenues Account Description 2012 2013 2014 2015 Description 3101 Tax increment collections 1,208,260 1,326,776 1,299,181 1,299,181 Estimated collections of incremental taxes on properties 1,208,260 1,326,776 1,299,181 1,299,181 in the district. 3610 Investment income 6,000 5,000 4,000 4,000 Estimated interest earnings at 1.00%. 6,000 5,000 4,000 4,000 Fund: 430 Department: 4650 Economic Development 3030 Other professional services 2,600 3,000 3,000 2,420 TIF administration and reporting fees - - - 1,580 5% audit fee (moved from EDA) 2,600 3,000 3,000 4,000 8010 Pay-as-you-go principal 1,147,847 1,260,437 1,234,223 1,234,223 Principal on a revenue note issued to promote a development. (Medtronic) 1,147,847 1,260,437 1,234,223 1,234,223 9900 Transfer out to EDA Fund 60,413 66,339 64,958 64,958 Transfer to cover the EDA operating budget. 60,413 66,339 64,958 64,958 31 2011 2012 2013 2014 Y-T-D 2015 Change from 2014 Actual Actual Actual Budget 09/30/14 Request Dollar Percent GO Improvement Bonds of 2004A Debt Service (Fund 505): Revenues 3101 Property taxes 187,736 190,965 193,887 191,798 99,106 - (191,798) -100.00% 3550 Spec assess prepayments - - 102,136 - - - 0.00% 3551 Spec assess current 35,435 34,095 33,032 25,652 520 - (25,652) -100.00% 3552 Spec assess delinquent 518 - - - - - 0.00% 3553 Spec assess penalty & int 154 - 121 - - - 0.00% 3610 Investment income 4,020 1,589 (4,702) 1,600 5,958 800 (800) -50.00% Total revenue 227,863 226,649 324,474 219,050 105,584 800 (218,250) -99.63% Operating expenses (4650): Contractual services 8010 Debt, principal 225,000 230,000 235,000 240,000 240,000 225,000 (15,000) -6.25% 8020 Debt, interest 37,300 29,563 21,308 17,078 12,757 4,219 (12,859) -75.30% 8030 Paying agent 431 431 431 475 450 475 - 0.00% 8040 Continuing disclosure 2,181 725 800 1,000 - 1,000 - 0.00% Total contractual services 264,912 260,719 257,539 258,553 253,207 230,694 (27,859) -10.77% Net change in fund balance (37,049) (34,070) 66,935 (39,503) (147,623) (229,894) (190,391) 481.97% Fund balance, beginning year 377,988 340,939 306,869 373,804 373,804 334,301 (39,503) -10.57% Fund balance, end of year 340,939 306,869 373,804 334,301 226,181 104,407 (229,894) -68.77% Final payment on 2004 bonds will be made 2-1-15 ($225,000+$4,218.75) 2015 Budget Summary 32 CITY OF MOUNDS VIEW, MINNESOTA Capital Project Funds 2015 Budgets Combining Statement of Revenues and Expenditures Park Vehicle and Special Street Dedication Equipment Projects Improvement 2015 2014 Revenue: Taxes -$ -$ -$ 300,000$ 300,000$ 300,000$ Franchise fees - - - 255,000 255,000 253,000 Special assessments - - - 25,000 25,000 20,000 Intergovernmental: State - - - 315,000 315,000 315,000 Miscellaneous: Investment income 2,000 - 2,000 75,000 79,000 84,000 Other 6,000 - - - 6,000 6,000 Total revenue 8,000 - 2,000 970,000 980,000 978,000 Expenditures: General government - 80,000 298,125 - 378,125 686,000 Public safety - 65,000 - 65,000 220,000 Streets and highways - 2,701,463 2,701,463 2,176,000 Culture and recreation 347,500 - - 347,500 78,600 Total expenditures 347,500 145,000 298,125 2,701,463 3,492,088 3,160,600 Excess (deficiency) of revenue over expenditures (339,500) (145,000) (296,125) (1,731,463) (2,512,088) (2,182,600) Other financing sources (uses) Operating transfers Transfers in - 292,000 - 240,000 532,000 512,000 Transfers out - (21,000) - - (21,000) (243,600) Total other financing sources (uses)- 271,000 - 240,000 511,000 268,400 Net change in fund balance (339,500) 126,000 (296,125) (1,491,463) (2,001,088) (1,914,200) Fund balance, January 1 210,822 1,443,118 (47,977) 6,312,778 7,918,741 9,832,941 Fund balance, December 31 (128,678)$ 1,569,118$ (344,102)$ 4,821,315$ 5,917,653$ 7,918,741$ Total Budget 33 2015 Budget Summary Y-T-D 2011 2012 2013 2014 09-30-14 2015 Change from 2014 Actual Actual Actual Budget Actual Request Dollar Percent Park Dedication (Fund 451): Revenues 3610 Investment income 17,530 4,555 (11,465) 3,000 13,773 2,000 (1,000) -33.33% 3650 Park donations 4,500 10,000 8,155 - 1,499 - - 0.00% 3652 Park dedication fees - - - 6,000 81,300 6,000 - 0.00% Total revenue 22,030 14,555 (3,310) 9,000 96,572 8,000 (1,000) -11.11% Operating expenses Operations (4470): Materials & supplies 1600 Supplies, operating - 739 86 - - - - 0.00% Total materials & supplies - 739 86 - - - - 0.00% Contractual services 3030 Other professional services - 819 3,654 - - - - 0.00% Total contractual services - 819 3,654 - - - - 0.00% Capital 7050 Construction 258,302 285,175 119,640 78,600 3,315 347,500 268,900 342.11% Total capital outlays 258,302 285,175 119,640 78,600 3,315 347,500 268,900 342.11% Total expenses 258,302 286,733 123,380 78,600 3,315 347,500 268,900 342.11% Net change in fund balance (236,272) (272,178) (126,690) (69,600) 93,257 (339,500) (269,900) 387.79% Fund balance, beginning year 915,562 679,290 407,112 280,422 280,422 210,822 (69,600) -24.82% Fund balance, end of year 679,290$ 407,112$ 280,422$ 210,822$ 373,679$ (128,678)$ (339,500)$ -161.04% 34 Fund: 451 Park Dedication Fund Revenues Account Description 2012 2013 2014 2015 Description 3610 Investment income 10,000 10,000 3,000 2,000 Estimated interest earnings at 1%. 10,000 10,000 3,000 2,000 3652 Park dedication fees 6,000 6,000 6,000 6,000 Developer payments 6,000 6,000 6,000 6,000 Fund: 451 Department: 4470 Expenditures 7050 Construction > $25000 35,000 - - - Lambert Park building (construction) 40,000 - - - Relocate Lambert ballfield to accomodate reconfig. bld. site. (Carryover) 10,000 - - - Hillview hockey rink expansion and grading 4,500 - - - Reconstruct irrigation controls at Silverview Park 100,000 - - - Replace playground equipment - Lambert - - - 100,000 Splash pad - - - 220,000 Groveland Park Improvements - - 25,000 25,000 Disk golf course improvements at Silverview Park - - 20,000 - Shelter and grounds improvements Silverview Park - - 10,000 - Irrigation improvements Silverview Park - - 5,600 2,500 Bike racks, Benches, Trash containers, Picknick tables, etc (BBC donations) - - 3,000 - Furniture replacement Random Park (BBC donations) - - 15,000 - Engineering for tennis court redesign Groveland Park - 100,000 - - Replace playground equipment - Silverview Park 13,000 - - - PIP - Security lighting Imp. - Greenfield & Groveland Parks 8,000 - - - PIP - Replace playground media - City Hall Park - 8,500 - - Hillview Park building roof 25,000 25,000 - - Park Improvement Program (PIP) - 50,000 - - Greenfield Park Parking area (with area F street reconstruction) 235,500 183,500 78,600 347,500 35 2015 Budget Summary Y-T-D 2011 2012 2013 2014 09-30-14 2015 Change from 2014 Actual Actual Actual Budget Actual Request Dollar Percent Vehicle & Equipment (Fund 460): Revenues 3972 Transfers in - General fund 75,000 75,000 90,000 100,000 - 110,000 10,000 10.00% 3972 Transfers in - Water Fund 58,000 58,000 58,000 60,000 - 58,000 (2,000) -3.33% 3972 Transfers in - Sewer Fund 36,000 36,000 36,000 36,000 - 53,000 17,000 47.22% 3972 Transfers in - Storm Water Fund 16,000 16,000 16,000 16,000 - 71,000 55,000 343.75% Total revenue 185,000 185,000 200,000 212,000 - 292,000 80,000 37.74% Operating expenses Materials & supplies 0.00% 1600 Supplies, operating - 941 - - - - - 0.00% 0.00% Capital 7030 Equipment - 72,139 15,344 147,500 150,588 80,000 80,000 54.24% 7040 Vehicles - 57,048 89,804 220,000 126,487 65,000 65,000 29.55% Total capital outlays - 129,187 105,148 367,500 277,075 145,000 145,000 83.78% Other 9900 Transfer out - General Fund 175,142 11,340 23,736 81,600 - 21,000 (60,600) -74.26% 9900 Transfer out - Water Fund - 289,000 - 72,000 - (72,000) -100.00% 9900 Transfer out - Sewer Fund 300,000 - - - - - - 0.00% 9900 Transfer out - Storm Water Fund 40,000 - - - - - 0.00% Total other 515,142 300,340 23,736 153,600 - 21,000 (132,600) -86.33% Total expenses 515,142 430,468 128,884 521,100 277,075 166,000 12,400 2.38% Net change in fund balance (330,142) (245,468) 71,116 (309,100) (277,075) 126,000 435,100 -140.76% Fund balance, beginning year 2,256,712 1,926,570 1,681,102 1,752,218 1,752,218 1,443,118 (309,100) -17.64% Fund balance, end of year 1,926,570 1,681,102 1,752,218 1,443,118 1,475,143 1,569,118 126,000 8.73% 36 Fund: 460 Vehicle & Equipment Fund Revenues Account Description 2012 2013 2014 2015 Description 3961 Transfers in 75,000 90,000 100,000 110,000 From General Fund ($256,000 5yr Fin Plan) 58,000 58,000 60,000 58,000 From Water Fund 36,000 36,000 36,000 53,000 From Sanitary Sewer Fund 16,000 16,000 16,000 71,000 From Storm Water Fund 185,000 200,000 212,000 292,000 Fund: 460 Department: 4160 Central Services Operations 7030 Equipment > $5000 18,000 - - - 11 computers, software and network hardware reduce from $23,000. 18,000 - - - Fund: 460 Department: 4200 Police Operations 7030 Equipment > $5000 7,000 - - - Squad mobile computers (2), light bar, (Police) 4,800 - - - radar $2,800, light bar $2,000 (Police) 11,800 - - - 7040 Vehicles 29,000 87,000 62,000 65,000 1 SUV $26,000 set-up $10,000 1 Admin sedan $24,000 set-up $5,000 29,000 87,000 62,000 65,000 Fund: 460 Department: 4360 Parks Operations 7030 Equipment > $5000 - 90,000 130,000 - Parks mower (AEBI Terratrac TT705) - - 17,500 - Batwing mower for AEBI - - - 80,000 (2) Parks mowers 7,500 - - - Air compressor (1/2 parks 1/2 pavement mgt.) 6,000 - - - Plow for pick-up (Parks)(Carryover from General Fund) 13,500 90,000 147,500 80,000 7040 Vehicles 36,000 36,000 63,000 - Parks - 3/4 ton pick-up 36,000 36,000 63,000 - Fund: 460 Department: 4460 Building & Grounds Operations 7030 Equipment > $5000 4,000 - - - Replace City Hall entrance lights (Bldg & grnds) 4,000 - - - Fund: 460 Department: 4470 Pavement Management Operations 7030 Equipment > $5000 4,000 - - - Brine solution equipment (Snow & Ice removal) 7,500 - - - Air compressor (1/2 parks 1/2 pavement mgt.) 11,500 - - - 7040 Vehicles 45,000 - - - Boom truck (Streets - pvmt mgt)(Carryover) - - 25,000 - Street maint 1/2 ton pick-up - 40,000 70,000 - Street maint 1 ton pick-up 45,000 40,000 95,000 - 9900 Transfers out - 18,000 81,600 21,000 Various equipment purchases general fund 11,340 5,736 - - Fire equipment per SBM 289,000 - - - Water Tower major maintenance (Carryover) - - - ?Storm Water - street sweeper - - 72,000 Water - 3/4 ton pick-up 300,340 23,736 153,600 21,000 37 2015 Budget Summary Y-T-D 2011 2012 2013 2014 09-30-14 2015 Change from 2014 Actual Actual Actual Budget Actual Request Dollar Percent Special Projects (Fund 480): Revenues 3552 Spec assessmt delinquent - 68 - - - 0.00% 3553 Spec assessmt penalty & interes - 186 256 - - - 0.00% 3610 Investment income 24,547 8,881 (22,992) 6,000 28,464 2,000 (4,000) -66.67% 3972 Transfers in - - - - - 10,019 10,019 #DIV/0! Total revenue 24,547 9,135 (22,736) 6,000 28,464 12,019 6,019 100.32% Operating expenses 3030 Other professional services 29,405 13,305 22,057 2,000 1,272 - (2,000) -100.00% 5130 Repairs; Equipment - 3,145 3,261 - - - - 0.00% Total contractual services 29,405 16,450 25,318 2,000 1,272 - (2,000) -100.00% Capital 7030 Capital equipment 50,673 - 29,975 90,000 58,174 13,500 (76,500) -85.00% 7050 Construction 167,749 245,228 189,977 446,500 40,794 284,625 (161,875) -36.25% Total capital outlays 218,422 245,228 219,952 536,500 98,968 298,125 (238,375) -44.43% Other 9900 Transfer out - - - 90,000 - - (90,000) -100.00% Total other - - - 90,000 - - (90,000) -100.00% Total expenses 247,827 261,678 245,270 628,500 100,240 298,125 (330,375) -52.57% Net change in fund balance (223,280) (252,543) (268,006) (622,500) (71,776) (286,106) 336,394 -54.04% Fund balance, beginning year 1,318,352 1,095,072 842,529 574,523 574,523 (47,977) (622,500) -108.35% Fund balance, end of year 1,095,072 842,529 574,523 (47,977) 502,747 (334,083) (286,106) 596.35% 38 Fund: 480 Special Projects Revenues Account Description 2012 2013 2014 2015 Description 3610 Investment income 10,000 10,000 6,000 2,000 Estimated interest earnings at 1%. 10,000 10,000 6,000 2,000 Fund: 480 Department: 4180 Expenditures 3030 Other professional services 10,000 5,000 2,000 - Scanning of microfilm to laser fiche 10,000 5,000 2,000 - 7030 Capital, equipment > $5000 - 28,000 28,000 - Purchase copiers (3) Main copier, police, comm dev/finance - - 6,000 6,000 Card Key Access - City Hall - 10,000 12,500 7,500 Council Chambers chairs/tables (50 chairs @ $150) - - 3,500 - Dias chairs - 10,000 10,000 - Video Security improvements for CH and CC (BBC grant of $2,000) - - 30,000 - Unleaded fuel tank, pump, and monitoring equipment - 40,000 - - City Hall sign - 88,000 90,000 13,500 7050 Construction > $25000 30,000 - - - Community center parking lot improvements 13,000 13,000 25,000 - City Hall irrigation and landscape project 30,000 - - - Edgewood Dr. boulevard project (carryover from 2007)(Carryover) 104,000 100,000 - - Pathway construction program 65,000 - - - Community center energy improvements (carryover from 09) - - 79,500 - PW Building Project (schematic design) 20,000 20,000 200,000 200,000 Pathway rehabilitation program (Silver View Park) 250,000 - - - Community Center roof replacement/repair - - 12,000 8,000 Police parking lot lighting - - 30,000 - Masonry renovation of CH & CC - - 75,000 50,000 CC retro commissioning Improvements (phase 1) - - 25,000 - Cty Rd H sidewalk - - - 22,125 New carpet PD - - - 4,500 Interior painting PD 512,000 133,000 446,500 284,625 9900 Transfer to General Fund 90,000 45,000 90,000 - 90,000 45,000 90,000 - 39 2015 Budget Summary Y-T-D 2011 2012 2013 2014 09-30-14 2015 Change from 2014 Actual Actual Actual Budget Actual Request Dollar Percent Street Improvement (Fund 485): Revenues 3101 Property taxes 264,313 278,744 276,447 300,000 156,630 300,000 - 0.00% 3180 Franchise fee 241,289 219,581 259,070 253,000 207,481 255,000 2,000 0.79% 3319 Other federal grants - 16,306 - - - - - 0.00% 3352 MSA street construction 325,787 315,426 395,280 315,000 327,190 315,000 - 0.00% 3550 Spec assessmt prepayment 24,444 40,229 49,226 20,000 21,897 25,000 5,000 25.00% 3610 Investment income 125,713 83,914 (220,669) 75,000 281,627 75,000 - 0.00% 3680 Other revenue 45,090 7,898 18,480 - 9,170 - 0.00% 3972 Transfer from other funds 300,000 300,000 300,000 300,000 240,000 (60,000) -20.00% Total revenue 1,326,636 1,262,098 1,077,834 1,263,000 1,003,995 1,210,000 (53,000) -4.20% Operating expenses Operations (4470): Capital 7050 Construction 143,213 551,292 1,706,436 2,176,000 354,028 2,701,463 525,463 24.15% Total capital outlays 143,213 551,292 1,706,436 2,176,000 354,028 2,701,463 525,463 24.15% Total expenses 143,213 551,292 1,706,436 2,176,000 354,028 2,701,463 525,463 24.15% Net change in fund balance 1,183,423 710,806 (628,602) (913,000) 649,967 (1,491,463) (578,463) 63.36% Fund balance, beginning year 5,960,151 7,143,574 7,854,380 7,225,778 7,225,778 6,312,778 (913,000) -12.64% Fund balance, end of year 7,143,574$ 7,854,380$ 7,225,778$ 6,312,778$ 7,875,745$ 4,821,315$ #########-23.63% 40 Fund: 485 Street Improvement Revenues Account Description 2012 2013 2014 2015 Description 3101 Property taxes 300,000 300,000 300,000 300,000 General tax levy for streets 300,000 300,000 300,000 300,000 3180 Franchise fee 253,000 253,000 253,000 253,000 Half of the 4% franchase fee on gas & electric utilities 253,000 253,000 253,000 253,000 3319 Other federal grants 630,000 - - - Federal safety grant for Cty H intersection(2013) 630,000 - - - 3352 MSA Street Construction 383,000 383,000 315,000 315,000 State aid funds 383,000 383,000 315,000 315,000 3359 Other state grants 300,000 - - - MNDOT Coop Agreement (2011 H and Cty 10 intersection project) 70,000 - - - Ramsey Cty CSAH (2010 H and Cty 10 intersection project) 125,000 - - - CR 10 Turnback Funds (2010 H and Cty 10 intersection project) 495,000 - - - 3550 Special assessments - - 20,000 20,000 Special assessments on private improvements - - 20,000 20,000 3610 Investment income 72,500 80,000 75,000 75,000 Estimated interest earnings at 1%. 72,500 80,000 75,000 75,000 3972 Transfer in 300,000 300,000 300,000 300,000 Transfers from utility funds (water 85,000, sewer 140,000, storm 75,000) 300,000 300,000 300,000 300,000 Fund: 485 Department: 4470 Expenditures 3030 Other professional services - - - - - - - - 7050 Construction > $25000 778,280 - 94,805 - 2013 Area F Street & Utility project - 495,460 1,408,424 96,770 2014 Area G Street & Utility project - - 247,771 1,856,049 2015 Area H Street & Utility project - - - 348,644 2016 Area I Street & Utility project 300,000 - - - Mill and overlay (Mustang Drive)(move to TIF 430)(50,000 in utility funds) - - 50,000 50,000 Other pavement improvements - 90,000 375,000 350,000 Seal coat project Area A, B, C, D and trails 1,078,280 585,460 2,176,000 2,701,463 41 THIS PAGE LEFT BLANK INTENTIONALLY 42 CITY OF MOUNDS VIEW, MINNESOTA Enterprise Funds 2015 Budgets Combining Statement of Revenues and Expenses Sanitary Street Storm Water Sewer Lighting Water 2015 2014 Operating revenue: Operating revenues 994,974 1,410,821 92,067 265,000 2,762,862 2,523,645 Special assessments 50,000 - - - 50,000 50,000 Connection charges - - - - - 300 Other income - - - - - 1,000 Total operating revenue 1,044,974 1,410,821 92,067 265,000 2,812,862 2,574,945 Operating expenses: Personal services 353,042 352,714 8,277 122,907 836,940 735,151 Supplies 67,010 36,679 1,000 24,041 128,730 138,190 Contractual services 202,803 112,102 3,900 56,246 375,051 394,981 Electricity & gas 115,000 2,300 90,000 - 207,300 187,100 Disposal charges - 832,084 - - 832,084 822,568 Contingency 15,000 15,000 - - 30,000 30,000 Depreciation 245,000 167,000 - 32,000 444,000 439,000 Capital outlays 116,750 294,750 - 127,750 539,250 918,250 Total operating expenses 1,114,605 1,812,629 103,177 362,944 3,393,355 3,665,240 Net operating income (loss)(69,631) (401,808) (11,110) (97,944) (580,493) (1,090,295) Non-operating revenue (expenses): Investment income 1,000 30,000 1,300 15,000 47,300 57,300 Principal payment on debt - - - - - - Interest expense - - - - - - Bond fees / discounts - - - - - (1,200) Total non-operating 1,000 30,000 1,300 15,000 47,300 56,100 Transfers Transfers in - - - - - - Transfers out (154,475) (267,611) (2,536) (153,383) (578,005) (545,985) Revenues over (under) expenditures (223,106) (639,419) (12,346) (236,327) (1,111,198) (1,580,180) Add back: Capital outlays 116,750 294,750 - 127,750 539,250 918,250 Principal on debt - - - - - - Net income (loss)(106,356) (344,669) (12,346) (108,577) (571,948) (661,930) Net assets (deficit), January 1 3,943,598 3,989,814 111,285 3,029,543 11,074,239 11,923,080 Net assets (deficit), December 31 3,837,242$ 3,645,145$ 98,939$ 2,920,966$ 10,502,291$ 11,261,150$ Total 43 2011 2012 2013 2014 Y-T-D 2015 Change from 2014 Actual Actual Actual Budget 07/31/14 Request Dollar Percent Water (Fund 700): Revenues 3424 Meter charge (6) (4) - - - - - 0.00% 3426 Reimbursed staff time - - 100 - - - - 0.00% 3551 Spec assessments-current 71,371 64,167 69,242 50,000 36,875 50,000 - 0.00% 3552 Spec assessments-delinquent 8,799 2,721 2,922 - 1,322 - - 0.00% 3553 Spec assess.-penalty & interest 1,807 2,904 1,713 - 209 - 0.00% 3610 Investment income 23,536 3,838 (8,287) 4,000 9,000 1,000 (3,000) -75.00% 3680 Other revenues 9,929 2,916 3,220 2,000 11,508 2,000 - 0.00% 3710 Water sales 680,647 806,698 777,150 847,805 477,180 906,974 59,169 6.98% 3712 Utility credits - - 50 - - - 0.00% 3714 Water service fee 52,258 52,562 54,980 68,000 49,552 85,000 17,000 25.00% 3715 Utility connections 1,635 1,625 2,750 1,000 2,950 1,000 - 0.00% 3716 Penalties 7,903 6,837 7,011 - 8,747 4,000 4,000 #DIV/0! 3913 Meter sales 3,859 1,806 1,269 - 424 - - 0.00% WAC/SWM charges 500 1,500 2,500 - 50,000 - - 0.00% 3972 Transfers - Vehicle & Equip - 289,000 - 72,000 - - (72,000) -100.00% Total revenue 862,238 1,236,570 914,620 1,044,805 647,767 1,049,974 5,169 0.49% Operating expenses Billing Services (4820): Personnel services 0100 Salaries, regular 33,152 37,472 38,295 38,585 27,849 40,591 2,006 5.20% 0300 Social security 2,404 2,653 2,798 2,953 2,044 3,107 154 5.22% 0321 PERA 2,379 2,631 2,686 2,797 1,959 3,044 247 8.83% 0400 Group insurance 3,103 3,609 3,700 4,729 2,791 5,370 641 13.55% 0500 Workers compensation 196 216 234 241 311 360 119 49.38% 0990 Severance - - - - - - 0.00% Total personnel services 41,234 46,581 47,713 49,305 34,954 52,472 3,167 6.42% Materials & supplies 1600 Supplies, operating 68 - - 50 - 50 - 0.00% Total materials & supplies 68 - - 50 - 50 - 0.00% Contractual services 3030 Other professional services 6,986 7,120 6,901 8,177 6,661 8,942 765 9.36% 3300 Postage 3,017 3,727 3,232 3,596 1,733 3,626 30 0.83% 3430 Printing 1,048 802 881 900 900 - 0.00% 3630 Training - - - 1,500 1,500 - 0.00% 5130 Repairs, equipment 3,345 3,513 3,693 3,875 4,017 4,545 670 17.29% Total contractual services 14,396 15,162 14,707 18,048 12,411 19,513 1,465 8.12% Debt Service: 8010 Principal - 215,000 230,000 - - - - 0.00% 8020 Interest 15,938 8,650 680 - - - - 0.00% 8030 Paying agent fees 431 431 - - - - - 0.00% 8040 Continuing disclosure 2,181 725 - 1,200 - - (1,200) -100.00% Total capital outlays 18,550 224,806 230,680 1,200 - - (1,200) -100.00% Miscellaneous: 9800 Loss on disposal of asset 153 - - - - - - 0.00% 9900 Transfers out to General Fund 63,505 65,410 67,372 69,393 - 71,475 2,082 3.00% 9900 Transfers out to Vehicle Fund 58,000 58,000 58,000 60,000 - 58,000 (2,000) -3.33% Total capital outlays 121,658 123,410 125,372 129,393 - 129,475 82 0.06% Total Billing 195,906 409,959 418,472 197,996 47,365 201,510 3,514 1.77% 2015 Budget Summary 44 Fund: 700 Department: 4820 Billing Services Account Description 2012 2013 2014 2015 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 6,705 6,840 6,977 7,742 24.5% of audit fee (up from 22.5%) 800 800 800 800 Inserting & mailing bills 400 400 400 400 Legal services 375 394 - - Annual maintenance (meter reading software)(50% sewer, 50% Water) 8,280 8,434 8,177 8,942 3300 Postage 2,816 2,880 3,136 3,136 3200 bills X $0.49 postage X 4 billings X 1/2 cost 440 450 460 490 Late notices: 500 bills X $0.49 postage X 4 billings X 1/2 cost 3,256 3,330 3,596 3,626 3430 Printing 450 450 450 450 Utility bills (1/2 cost) 450 450 450 450 Envelopes 900 900 900 900 3630 Training 250 250 1,500 1,500 Seminars on new regulations, software updates, etc. INCODE training 250 250 1,500 1,500 Defer INCODE Training to future year $1,250 5130 Repairs, equipment 3,180 3,339 3,506 3,682 INCODE software support (30%) - - - 475 Neptune software maintenance (1/2 in sewer) 318 334 369 388 Handheld interface support for meter readers (50% water 50% sewer) 3,498 3,673 3,875 4,545 8010 Principal 215,000 230,000 - - Principal due on bonds 215,000 230,000 - - 8020 Interest 11,705 4,025 - - Interest due on 2002 A Bonds 11,705 4,025 - - 8030 Paying agent fees 475 475 - - Paying agent fees on bond issues 475 475 - - 8040 Continuing Disclosure 1,500 2,200 1,200 - Annual debt disclosure requirements and Ramsey county sp. Assmt. Fees 1,500 2,200 1,200 - 9900 Transfers out 65,410 67,372 69,393 71,475 Transfer to General Fund for administrative overhead costs 58,000 58,000 60,000 58,000 Transfer to Vehicle & Equipment Fund to fund future purchases 123,410 125,372 129,393 129,475 368,324 378,709 148,691 149,038 45 2011 2012 2013 2014 Y-T-D 2015 Change from 2014 Actual Actual Actual Budget 07/31/14 Request Dollar Percent Water (Fund 700): 2015 Budget Summary Infrastructure & Equip Maintenance (4823): Personnel services 0100 Salaries, regular 173,564 178,690 155,246 180,443 130,651 176,088 (4,355) -2.41% 0110 Salaries, overtime 6,662 5,947 11,268 9,462 8,633 9,231 (231) -2.44% 0150 Salaries, part-time 14,486 8,408 - 18,475 5,099 10,320 (8,155) -44.14% 0300 Social security 13,284 13,330 12,077 15,942 10,193 14,967 (975) -6.12% 0321 PERA 12,761 12,457 12,254 14,052 10,026 14,204 152 1.08% 0400 Group insurance 28,791 28,828 24,469 32,756 23,324 32,577 (179) -0.55% 0500 Workers compensation 5,445 5,459 6,020 6,817 8,792 7,660 843 12.37% Total personnel services 254,993 253,119 221,334 277,947 196,718 265,047 (12,900) -4.64% Materials & supplies 1210 Supplies, bldg & grnds 1,443 1,494 1,131 3,800 561 2,750 (1,050) -27.63% 1220 Supplies, vehicles 1,091 1,434 1,712 1,000 402 1,500 500 50.00% 1230 Supplies, equipment 8,851 3,898 10,607 7,425 5,011 1,625 (5,800) -78.11% 1240 Supplies, streets 1,602 4,825 11,191 3,000 1,756 3,000 - 0.00% 1250 Supplies, utilities 12,602 2,170 16,192 7,000 16,759 10,250 3,250 46.43% 1260 Supplies, traffic control - - 257 200 200 200 - 0.00% 1600 Supplies, operating 2,845 4,562 8,812 4,800 4,871 5,800 1,000 20.83% 1700 Motor fuels 4,785 6,034 9,271 5,875 3,120 4,025 (1,850) -31.49% 2400 Uniforms 1,496 1,460 1,618 1,475 695 995 (480) -32.54% 2410 Mats & towels 1,677 1,657 642 1,620 422 775 (845) -52.16% Total materials & supplies 36,392 27,534 61,433 36,195 33,797 30,920 (5,275) -14.57% Contractual services 3030 Other professional services 3,938 9,548 7,310 6,130 8,397 4,630 (1,500) -24.47% 3100 Communications - telephone 2,386 2,277 2,535 2,060 1,632 2,060 - 0.00% 3200 Water & wastewater charges 8,226 12,740 7,286 7,200 1,351 7,200 - 0.00% 3220 Natural gas 7,455 5,999 7,668 7,000 5,767 7,000 - 0.00% 3610 Memberships 189 214 208 470 477 290 (180) -38.30% 3630 Training 2,600 4,489 1,676 4,000 2,690 3,850 (150) -3.75% 4010 Equipment rental 5,123 2,672 2,672 4,000 117 4,500 500 12.50% 4800 Insurance 9,940 18,165 7,023 10,230 6,754 10,230 - 0.00% 5110 Repairs, bldgs & grnds - - 248 11,000 805 7,000 (4,000) -36.36% 5120 Repairs, vehicles - - - 1,500 - 1,000 (500) -33.33% 5130 Repairs, equipment 3,249 7,118 19,057 9,600 7,104 6,600 (3,000) -31.25% 5140 Repairs, streets 35,096 7,198 34,222 10,000 - 10,000 - 0.00% 5150 Repairs, utilities 592 1,530 2,148 17,500 14,500 17,500 - 0.00% 5155 Water service repair 65,267 59,509 170,240 65,000 70,475 80,000 15,000 23.08% 5160 Repairs, system maintenance 9,955 9,954 5,800 10,500 430 3,500 (7,000) -66.67% Total contractual services 154,016 141,413 268,093 166,190 120,499 165,360 (830) -0.50% Capital outlays 7030 Equipment - - - 116,250 35,487 56,750 (59,500) -51.18% 7050 Construction - - - 375,000 323,451 60,000 (315,000) -84.00% 7950 Depreciation 213,184 220,231 251,946 240,000 - 245,000 5,000 2.08% Total capital outlays 213,184 220,231 251,946 731,250 358,938 361,750 (369,500) -50.53% Miscellaneous: 9100 Contingency - - - 15,000 - 15,000 - 0.00% 9900 Transfer to Street Fund 100,000 100,000 100,000 85,000 - 25,000 (60,000) -70.59% Total miscellaneous 100,000 100,000 100,000 100,000 - 40,000 (60,000) -60.00% Total infrastructure & equip maint 758,585 742,297 902,806 1,311,582 709,952 863,077 (448,505) -34.20% 46 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance Account Description 2012 2013 2014 2015 Description 1210 Supplies, Bldgs & grounds 100 100 100 100 Mops, buckets, brooms 600 600 600 500 Light tubes & ballasts 200 200 200 200 Paper products 200 200 200 200 Paint, thinner, & brushes 2,500 1,000 1,000 750 Black dirt & sod/seed, landscaping materials 500 500 500 500 Misc. cleaners for well houses & % of shop 400 400 400 - Fertilizer/seed/weed control 500 500 500 500 Irrigation parts 300 300 300 - Goose repellent 5,300 3,800 3,800 2,750 1220 Supplies, vehicles 200 200 300 300 Air, oil, fuel, & transmission filters 100 100 100 100 Fluids 100 100 100 400 Batteries and tires 50 50 50 50 Paint sealant 150 150 150 150 Tune ups 200 200 300 500 Misc repairs 800 800 1,000 1,500 1230 Supplies, equipment < $5000 100 100 100 100 Tune ups 100 100 100 100 Grounds maintenance equipment 100 100 100 100 Blades, suction hoses, filter screens 168 175 175 175 Hydraulic fluid: 35 gallons @ $4.80 / gallon 200 200 200 200 Solvents & cleaning fluids 150 200 200 200 Air compressor & dehumidifier parts 2,100 2,100 1,500 500 Chemical equipment parts (fluoride pumps) - 1,100 4,800 - Fluoride tank replacement (3 tanks every 3 years)(2017 next) 150 250 250 250 Air, oil, fuel, & trans filters (emergency generator) 3,068 4,325 7,425 1,625 1240 Supplies, streets 5,000 3,000 3,000 3,000 Asphalt/concrete/sod/seed for patching minor street, curb, driveway repairs. 5,000 3,000 3,000 3,000 1250 Supplies, utilities 5,000 - - - Meter batteries (200 @ $25) 500 500 500 2,000 Paint & sandblasting materials for hydrants 500 500 500 500 Copper, steel & PVC pipe 1,500 1,500 1,500 1,500 Valve box risers, main repair clamps 1,000 1,000 1,000 250 Hydrant markers 1,500 1,500 1,500 3,000 Hydrant parts 2,000 2,000 2,000 3,000 Meter supplies, etc. (move from account 1600) - 2,000 - - Motorized gate valve wrench - 1,500 - - Motorized hydrant wrench - 1,500 - - Hydrant cut-off tool - 2,000 - - Plasma cutter 12,000 14,000 7,000 10,250 1260 Supplies, traffic control 200 200 200 200 Traffic cones / safety vests 200 200 200 200 1600 Supplies, operating 500 500 500 500 Propane, acetylene & oxygen supplies 400 400 400 400 Gloves, masks, & rags 650 650 650 650 Film, first aid supplies, & batteries 1,500 1,500 2,000 2,500 Location flags & paint (moved from account 1250) 250 250 250 250 Cleaning supplies 1,000 1,000 1,000 1,500 Additional & replacement hand tools 4,300 4,300 4,800 5,800 1700 Motor fuels & lubs 450 450 675 650 Diesel fuel - 200 gallons @ $3.75 - - - 450 Oil 200 200 - - Propane: 50 gallons @ $4 5,200 5,200 5,200 2,925 Unleaded fuel: 900 gallons @ $3.25 5,850 5,850 5,875 4,025 2400 Uniforms 1,475 1,475 1,475 995 Uniforms 15.5% of $4,500 and clothing 1.7 FTE x $175 per contract 1,475 1,475 1,475 995 2410 Mats & towels 1,620 1,620 1,620 775 Share of floor mats & shop towels (15.5% of $5,000) 1,620 1,620 1,620 775 3030 Other professional services 180 180 180 180 Backflow prevention testing (3 @ $60 per test) - 3,000 - - Water system leak survey (every 2 years, 2015) - 250 250 - Water tower evaluation 200 200 250 250 Fire sprinkler inspections/testing 200 200 200 200 Fire extinguisher inspection/service (10 @ $20) 2,750 2,750 2,750 1,500 Gopher State One-call locates 2,500 1,000 2,500 2,500 Arcview/GIS base map consulting 5,830 7,580 6,130 4,630 3100 Communications - telephone 400 400 400 400 Service & repair 1,570 1,570 1,570 1,570 Cellular phone service (18.5% of $8,500) 90 90 90 90 800 MHz license fee (33%)(5 radios @ $4.48 per month) 2,060 2,060 2,060 2,060 3200 Water and wastewater charges 6,000 7,200 7,200 7,200 6,000 7,200 7,200 7,200 47 THIS PAGE LEFT BLANK INTENTIONALLY 48 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance Account Description 2012 2013 2014 2015 Description 3220 Natural gas 10,000 8,500 7,000 7,000 Heating fuel 10,000 8,500 7,000 7,000 3610 Memberships 150 150 180 - American Public Works Association (APWA)(25% of $710) 100 100 100 100 MN Rural Water Association (50%) 80 80 80 80 MN Safety Council (19% of $405) 50 50 50 50 Suburban Utility Superintendant Association (SUSA)(50% of $100) 60 60 60 60 Pressurized vessel license 440 440 470 290 3630 Training 250 250 250 250 Computer training/webinars 1,200 - 1,200 1,200 Trench safety training (on-site)(not annual) 110 110 110 110 Hearing test/R2K (2.15 FTE * $50) 60 60 60 60 Maintenance Expo 820 820 820 820 Water operator class/exam/certificate ($205 per person) 200 200 200 200 Misc. training seminars 390 390 390 390 Equipment operator training 200 200 200 200 MRWA workshops 150 150 150 - MN Public Works Assoc workshop 560 560 560 560 Tuition reimbursement - - 60 60 Work zone safety seminar (every 3 years) 3,940 2,740 4,000 3,850 4010 Rental, equipment 3,500 3,500 3,500 4,000 Skid steer - upgrade 600 300 300 300 Barricades & signs 400 200 200 200 Tools & equipment 4,500 4,000 4,000 4,500 4800 Insurance 10,230 10,230 10,230 10,230 Share of property/liability insurance 10,230 10,230 10,230 10,230 5110 Repairs, buildings & grounds - - 5,000 2,000 Door & lock repairs - - 2,000 1,000 Roof & wall repairs - - 3,000 3,000 Electrical & mechanical repairs - - 1,000 1,000 Site repairs (pavement, fence, irrigation, etc...) - - 11,000 7,000 5120 Repairs, vehicles - - 1,500 1,000 Utility truck repairs - - 1,500 1,000 5130 Repairs, equipment 100 - - - Chemical pump repairs - 2,500 1,500 1,500 Well and water treatment plant repairs 1,000 1,500 1,500 1,500 Miscellaneous repairs (Backhoe, Skid steer) - - 3,000 - Backhoe tires - - 1,500 1,500 Meter and valve repairs - - 2,000 2,000 SCADA repairs - 5,500 - - 10" gate valve repair (well #3) 150 100 100 100 Radio repairs 1,250 9,600 9,600 6,600 5140 Repairs, streets 10,000 14,000 10,000 10,000 Contractor repairs to streets after water main breaks 10,000 14,000 10,000 10,000 5150 Repairs, utilities 800 - - - RTU panel repairs 1,000 - - - Electrical modifications & repairs - - 5,000 5,000 Fire hydrant repairs - - 5,000 5,000 Gate valve repairs - 5,000 7,500 7,500 Water main repairs 1,800 5,000 17,500 17,500 5155 Water service repairs 50,000 50,000 50,000 65,000 Contractor repairs to residential water services. - - 15,000 15,000 Pavement & curb repairs 50,000 50,000 65,000 80,000 5160 System maintenance 12,500 10,000 - - Building repairs (moved to 5110) 2,500 3,500 3,500 3,500 Water system maintenance & repair items - 7,500 7,000 - Well #4 perimeter fencing 15,000 21,000 10,500 3,500 7030 Capital, equipment > $5000 8,000 17,000 15,000 15,000 Gate valves 10,500 10,500 - - Plate compactor for backhoe 8,500 8,500 14,000 14,000 Trench box - - 2,750 2,750 Electric rain gauges SCADA System (33%)(total cost $8,250) 19,000 - 7,500 - Chemical feed equipment 3,200 - - - Dehumidifier (well #6) 1,200 - - - Laptop and mounting bracket for infield use of record drawings - - 25,000 25,000 Security cameras & card key access - - 5,000 - Air Compressor (well #5) - - 72,000 - 3/4 ton pick-up 1,800 - - - Hydrant diffuser 52,200 36,000 141,250 56,750 7050 Construction > $25000 70,000 - - - Water tower rehabilitation 2011 - $800,000 22,700 - - - Well #1,2,3 building repairs (int. and exterior repairs)(carryover from 10,11) 250,000 250,000 350,000 ?Reservoir & booster station building and roof repairs (carryover from 10,11) 50,000 - - - Roof replacement well #1 75,000 - - 60,000 Well pump rehabilitation project (well no. 6) ($60,000 - 2015) 467,700 250,000 350,000 60,000 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance 7950 Depreciation 240,000 240,000 240,000 245,000 Estimated depreciation 240,000 240,000 240,000 245,000 49 2011 2012 2013 2014 Y-T-D 2015 Change from 2014 Actual Actual Actual Budget 07/31/14 Request Dollar Percent Water (Fund 700): 2015 Budget Summary Water Production (4825): Personnel services 0100 Salaries, regular - 842 361 - 269 25,391 25,391 #DIV/0! 0300 Social security - 61 26 - 19 1,942 1,942 #DIV/0! 0321 PERA - 60 26 - 19 1,904 1,904 #DIV/0! 0400 Group insurance - 104 37 - 40 4,896 4,896 #DIV/0! 0500 Workers compensation - - - - - 1,390 1,390 #DIV/0! Total personnel services - 1,067 450 - 347 35,523 35,523 #DIV/0! Materials & supplies 1600 Supplies, operating 24,570 32,574 32,919 35,175 18,861 35,175 - 0.00% 1700 Motor fuels - - - 450 - 450 - 0.00% 2400 Uniforms - - - - - 235 235 #DIV/0! 2410 Mats & towels - - - - - 180 180 #DIV/0! Total materials & supplies 24,570 32,574 32,919 35,625 18,861 36,040 415 1.16% Contractual services 3030 Other professional services 22,889 27,291 24,962 27,930 1,835 24,930 (3,000) -10.74% 3210 Electricity 82,096 93,188 107,531 95,000 68,090 108,000 13,000 13.68% Total contractual services 104,985 120,479 132,493 122,930 69,925 132,930 10,000 8.13% Total water production 129,555 154,120 165,862 158,555 89,133 204,493 45,938 28.97% Total expenditures 1,084,046 1,306,376 1,487,140 1,668,133 846,450 1,269,080 (399,053) -23.92% Revenues over (under) expenditures (221,808) (69,806) (572,520) (623,328) (198,683) (219,106) 404,222 -64.85% Add back: capital outlays - - - 491,250 358,938 116,750 (374,500) -76.23% principal payment on debt - 215,000 230,000 - - - - 0.00% Change in net assets (221,808) 145,194 (342,520) (132,078) 160,255 (102,356) 29,722 -22.50% Net Assets, beginning year 4,494,810 4,273,002 4,418,196 4,075,676 4,075,676 3,943,598 (132,078) -3.24% Net Assets, end of year 4,273,002$ 4,418,196$ 4,075,676$ 3,943,598$ 4,235,931$ 3,841,242$ (102,356)$ -2.60% 50 9100 Contingency 15,000 15,000 15,000 15,000 Contingency 15,000 15,000 15,000 15,000 9900 Transfers out 100,000 100,000 85,000 25,000 Water system upgrades in conjunction with major roadway program 100,000 100,000 85,000 25,000 1,035,563 822,720 1,033,635 598,030 Fund: 700 Department: 4825 Water Production Account Description 2012 2013 2014 2015 Description 1600 Supplies, operating 550 550 550 550 Computer supplies 800 800 800 800 Testing reagents 3,950 3,950 4,125 4,125 Sulfur dioxide: 25 150# cylinders @ $1.10 per pound 8,000 8,000 8,800 8,800 Chlorine: 8 - 1 ton cylinders @ .55 per pound 8,438 8,438 9,350 9,350 75 - 150 # cylinders @ $.83 6,600 6,600 7,400 7,400 Hydrofluosilic acid: 20,000 pounds @ $0.37 3,190 3,190 3,300 3,300 R-999 Buffer solution 2 - 55 gal drums @ $30 per gal. 850 850 850 850 Sand separator 400 400 - - Water conservation program implementation 32,778 32,778 35,175 35,175 1700 Motor fuels & lubs 200 200 200 200 Turbine & electric motor oil 250 250 250 250 Oil for generators 2,700 1,800 - - Diesel fuel for primary generator: 400 gallons @ $4.50 3,150 2,250 450 450 2400 Uniforms - - - 235 Uniforms 3.6% of $4,500 and clothing .4 FTE x $175 per contract - - - 235 2410 Mats & towels - - - 180 Share of floor mats & shop towels (3.6% of $5,000) - - - 180 3030 Other professional services 960 960 960 960 Bacteria tests (8*$10*12 months) 800 800 800 800 Computer maintenance 1,000 1,000 1,000 1,000 Consumer confidence report 7,500 7,500 10,000 10,000 DNR water permit fee (annual surcharge) 300 300 300 300 Emergency Response Commission fees 1,120 1,120 1,120 1,120 Full scan tests - 4 @ $280 600 600 600 600 Minimum contamination level (MCL) tests 1,000 1,000 1,000 1,000 Radon tests 800 800 800 800 Random sample tests 825 825 1,050 1,050 MCES discharge permits (3*$350) 300 300 300 300 MNDPS - EPCRA program ($100/WTP) 15,000 15,000 10,000 7,000 Well head protection plan (req. by Dept. of Health) 30,205 30,205 27,930 24,930 3210 Electricity 77,000 80,000 95,000 108,000 Electricity for wells, tower & reservoir 77,000 80,000 95,000 108,000 3630 Training 200 - - - General training 200 - - - 143,333 145,233 158,555 168,970 1,547,220 1,346,662 1,340,881 916,038 -31.60%-12.96%-0.43%-31.68% 51 2015 Budget Summary 2011 2012 2013 2014 Y-T-D 2015 Change from 2014 Actual Actual Actual Budget 07/31/14 Request Dollar Percent Sanitary Sewer (Fund 730): Revenues 3426 Reimbursed staff time 85 - - - - - - 0.00% 3551 Spec. Assessments 1,848 502 78 - - - 0.00% 3610 Investment income 59,917 31,367 (79,782) 30,000 100,450 30,000 - 0.00% 3680 Other revenues 170 750 - - 30,000 - - 0.00% 3716 Penalties 10,363 8,018 7,678 - 11,853 6,000 6,000 #DIV/0! 3720 Utility sales 1,167,808 1,182,806 1,227,815 1,250,976 980,107 1,410,821 159,845 12.78% 3721 SAC charges 268 (464) (1,753) 1,000 13,046 - (1,000) -100.00% 3725 Utility connections 775 350 850 300 1,300 - (300) -100.00% 3726 Penalties & interest 824 545 811 - 607 - - 0.00% 3911 Gain on sale of assets 30,204 - - - - - - 0.00% 3972 Transfers from Vehicle Fund 300,000 - - - - - - 0.00% Total revenue 1,572,262 1,223,874 1,155,697 1,282,276 1,137,363 1,446,821 164,545 12.83% Operating expenses Billing Services (4820): Personnel services 0100 Salaries, regular 33,152 37,472 38,295 38,585 27,849 40,591 2,006 5.20% 0300 Social security 2,403 2,653 2,798 2,953 2,044 3,107 154 5.22% 0321 PERA 2,379 2,630 2,686 2,797 1,958 3,044 247 8.83% 0400 Group insurance 3,105 3,609 3,701 4,729 842 5,370 641 13.55% 0500 Workers compensation 196 216 233 241 311 360 119 49.38% Total personnel services 41,235 46,580 47,713 49,305 33,004 52,472 3,167 6.42% Materials & supplies 1600 Supplies, operating 57 - - 50 - 50 - 0.00% Total materials & supplies 57 - - 50 - 50 - 0.00% Contractual services 3030 Other professional services 6,986 7,120 6,901 8,177 6,780 8,942 765 9.36% 3300 Postage 3,017 3,727 3,231 3,596 1,733 3,626 30 0.83% 3430 Printing 1,048 802 801 900 - 900 - 0.00% 3630 Training - - - 1,500 - 1,500 - 0.00% 5130 Repairs, equipment 3,345 3,513 3,693 3,875 4,017 4,544 669 17.26% Total contractual services 14,396 15,162 14,626 18,048 12,530 19,512 1,464 8.11% Miscellaneous: 9900 Transfers out to General Fund 50,298 51,807 53,361 54,962 - 56,611 1,649 3.00% 9900 Transfers out to Vehicle Fund 36,000 36,000 36,000 36,000 - 71,000 35,000 97.22% Total miscellaneous 86,298 87,807 89,361 90,962 - 127,611 36,649 40.29% Total Billing 141,986 149,549 151,700 158,365 45,534 199,645 41,280 26.07% Infrastructure & Equip Maintenance (4823): Personnel services 100 Salaries, regular 157,397 165,270 167,543 178,773 129,417 202,260 23,487 13.14% 110 Salaries, overtime 7,552 5,852 7,884 7,889 6,100 8,078 189 2.40% 150 Salaries, part-time 9,369 8,885 11,503 11,100 - 11,520 420 3.78% 300 Social security 12,207 12,857 13,641 15,130 9,554 16,974 1,844 12.19% 321 PERA 11,489 12,210 12,788 13,816 9,595 16,082 2,266 16.40% 400 Group insurance 24,423 26,151 27,159 31,604 22,422 36,945 5,341 16.90% 500 Workers compensation 4,937 4,954 5,413 6,411 8,268 8,383 1,972 30.76% Total personnel services 227,374 236,179 245,931 264,723 185,356 300,242 35,519 13.42% 52 Fund: 730 Department: 4820 Billing Services Account Description 2012 2013 2014 2015 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 825 825 825 825 Inserting & mailing bills 375 375 375 375 Annual maintenance (meter reading software)(50% sewer, 50% Water) 6,705 6,840 6,977 7,742 24.5% of audit fee (up from 22.5%) 7,905 8,040 8,177 8,942 3300 Postage 2,816 2,880 3,136 3,136 3200 bills X $0.49 postage X 4 billings X 1/2 cost 440 450 460 490 Late notices: 500 bills X $0.49 postage X 4 billings X 1/2 cost 3,256 3,330 3,596 3,626 3430 Printing 450 450 450 450 Envelopes 450 450 450 450 Utility bills (1/2 cost) 900 900 900 900 3630 Training 250 250 1,500 1,500 Seminars on new regulations, software updates, etc. INCODE training (new) 250 250 1,500 1,500 Defer INCODE training to a future year $1,250 5130 Repairs, equipment 3,180 3,339 3,506 3,681 Incode software support (30%) - - - 475 Neptune software maintenance (1/2 in water) 318 334 369 388 Handheld interface support for meter readers (50% water 50% sewer) 3,498 3,673 3,875 4,544 9900 Transfers out 51,807 53,361 54,962 56,611 Transfer to General Fund for admin costs 36,000 36,000 36,000 71,000 Transfer to Vehicle & Equipment Fund for vehicle use 87,807 89,361 90,962 127,611 103,666 105,604 109,060 147,173 53 2015 Budget Summary 2011 2012 2013 2014 Y-T-D 2015 Change from 2014 Actual Actual Actual Budget 07/31/14 Request Dollar Percent Sanitary Sewer (Fund 730): Materials & supplies 1210 Supplies, bldg & grnds 28 - 151 200 - 200 - 0.00% 1220 Supplies, vehicles 1,948 2,635 590 2,775 751 2,775 - 0.00% 1230 Supplies, equipment 1,685 6,580 4,636 8,250 5,264 4,650 (3,600) -43.64% 1240 Supplies, streets 5,320 - - 3,000 - 3,000 - 0.00% 1250 Supplies, utilities 11 1,541 571 5,850 112 5,850 - 0.00% 1260 Supplies, traffic control - - 447 300 325 300 - 0.00% 1600 Supplies, operating 2,526 9,045 12,952 8,200 11,089 12,250 4,050 49.39% 1700 Motor fuels 6,560 8,158 4,347 8,500 4,514 5,525 (2,975) -35.00% 2400 Uniforms 1,861 1,360 1,304 1,475 695 1,169 (306) -20.75% 2410 Mats & towels 1,677 1,657 642 1,620 422 910 (710) -43.83% Total materials & supplies 21,616 30,976 25,640 40,170 23,172 36,629 (3,541) -8.82% Contractual services 3030 Other professional services 4,746 1,824 1,262 5,950 5,442 5,700 (250) -4.20% 3100 Communications - telephone 1,641 1,554 1,659 1,660 991 1,660 - 0.00% 3200 Water & sewer 2,620 3,102 3,328 2,600 2,483 3,000 400 15.38% 3210 Electricity 2,494 1,845 2,306 2,100 1,863 2,300 200 9.52% 3230 Wastewater disposal - MCES 776,066 760,913 816,267 822,568 690,868 832,084 9,516 1.16% 3610 Memberships - - - 230 153 230 - 0.00% 3630 Training 965 3,054 2,470 4,770 2,211 4,450 (320) -6.71% 4010 Equipment rental - - - 500 - 500 - 0.00% 4800 Insurance 5,544 4,647 7,951 7,300 7,273 7,300 - 0.00% 5130 Repairs, equipment 6,133 10,563 706 8,750 9,344 8,750 - 0.00% 5140 Repairs, streets - - - - - 10,000 10,000 #DIV/0! 5150 Repairs, utilities 40,886 265 4,065 2,500 3,901 17,500 15,000 600.00% 5155 Utility service repairs 15,443 6,850 53,846 - 10,827 - - 0.00% 5160 Repairs, maintenance 9,934 1,150 10,893 63,500 9,665 33,500 (30,000) -47.24% Total contractual services 866,472 795,767 904,753 922,428 745,021 926,974 4,546 0.49% Capital outlays 7030 Equipment - - - 47,750 7,308 44,750 (3,000) -6.28% 7050 Construction - - - 250,000 - 250,000 - 0.00% 7950 Depreciation 161,512 165,698 166,533 167,000 - 167,000 - 0.00% Total capital outlays 161,512 165,698 166,533 464,750 7,308 461,750 (3,000) -0.65% Miscellaneous: 9100 Contingency - - - 15,000 - 15,000 - 0.00% 9900 Transfer to Street fund 160,000 160,000 160,000 140,000 - 140,000 - 0.00% Total miscellaneous 160,000 160,000 160,000 155,000 - 155,000 - 0.00% Total infrastructure & equip maint 1,436,974 1,388,620 1,502,857 1,847,071 960,857 1,880,595 33,524 1.81% Total expenditures 1,578,960 1,538,169 1,654,557 2,005,436 1,006,391 2,080,240 74,804 3.73% Revenues over (under) expenditures (6,698) (314,295) (498,860) (723,160) 130,972 (633,419) 89,741 -12.41% Add back: capital outlays - - - 297,750 7,308 294,750 (3,000) -1.01% Change in net assets (6,698) (314,295) (498,860) (425,410) 138,280 (338,669) 86,741 -20.39% Net Assets, beginning of year 5,235,077 5,228,379 4,914,084 4,415,224 4,415,224 3,989,814 (425,410) -9.64% Net Asset, end of year 5,228,379$ 4,914,084$ 4,415,224$ 3,989,814$ 4,553,504$ 3,651,145$ (251,928)$ -6.31% 54 Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance Account Description 2012 2013 2014 2015 Description 1210 Supplies, bldgs & grounds 100 100 100 100 Paint, bulbs, fuses, etc 100 100 100 100 Seed, dirt, sod, etc 200 200 200 200 1220 Supplies, vehicles 75 75 75 75 Air, oil, fuel & transmission filters 775 775 775 775 Fluids 125 125 125 125 Repair & replacement parts 600 600 600 600 Tires & batteries - - 1,200 1,200 Back-up camera for televising van 1,575 1,575 2,775 2,775 1230 Supplies, equipment < $5000 650 650 650 650 Tune up parts 500 500 500 500 Hydraulic fluids & hoses 200 200 200 200 Cutting edges (skid loader) 300 300 300 300 Misc. replacement & repair parts 300 300 300 300 Light equip misc replacement & repair parts 1,000 1,000 1,500 2,000 Camera track and parts (CCTV) 300 300 300 300 Minor repairs - - 500 100 Gas detection device parts and supplies - 1,500 4,000 300 Vactor cleaning nozzle parts and supplies 3,250 4,750 8,250 4,650 1240 Supplies, streets 50 200 200 200 Tack coat 300 300 300 300 Dewatering rock 500 2,500 2,500 2,500 Asphalt mix 850 3,000 3,000 3,000 1250 Supplies, utilities 100 100 1,500 1,500 Replacement pumps & motors 100 100 100 100 Filters, packings, relays, etc 300 300 300 300 Speed crete (mortar) 700 700 700 700 Repair parts - 2,500 2,500 2,500 Portable flow meter 750 750 750 750 Manhole covers, adjust rings & bolts 1,950 4,450 5,850 5,850 1260 Supplies, traffic control 300 300 300 300 Traffic cones, work zone sign face, safety vests 300 300 300 300 1600 Supplies, operating 500 500 500 500 Additional & replacement hand tools 250 250 250 250 Glove & paper products 150 150 150 150 Disinfectant supplies 500 500 500 500 Camera supplies 200 200 200 200 First aid supplies, protective equip 400 400 400 400 CD's, DVD's, software 500 500 500 250 Engineering supplies 700 700 700 700 Shop supplies, fastners, soap, degreasers, steet, batteries 500 500 500 500 Pipe, fittings, and accessories (connectors) - 1,500 2,000 500 Locating supplies (paint, flags, markers, etc.) - 500 2,000 8,000 Chemical blocks for lift stations 600 600 500 300 Filter replacement for sewer gas monitors 4,300 6,300 8,200 12,250 1700 Motor fuels & lubs 300 300 300 300 Fluids 600 600 600 600 Motor oil - 100 gallons $6 gal. 4,000 4,000 4,000 1,625 Unleaded fuel 500 gallons @ $3.25 3,600 3,600 3,600 3,000 Diesel fuel 800 gallons @ $3.75 8,500 8,500 8,500 5,525 2400 Uniforms 1,475 1,475 1,475 1,169 Uniforms 18.2% of $4,500 and clothing 2.0 FTE x $175 per contract 1,475 1,475 1,475 1,169 2410 Mats & towels 1,620 1,620 1,620 910 Share of floor mats & shop towels (18.2% of $5,000) 1,620 1,620 1,620 910 3030 Other professional services 2,750 2,750 2,750 1,500 Gopher State One Call locates - - 600 600 Consulting engineering services - annual lift station inspections 100 100 100 100 Fire extinguisher inspection/servcie (5 @ $20) - - - 1,000 Asset management software 2,500 2,500 2,500 2,500 Arcview/GIS base map consulting 5,350 5,350 5,950 5,700 3100 Communications - telephone 1,570 1,570 1,570 1,570 Cellular phone service (18.5% of $8,500) 90 90 90 90 800 Mhz radio license fee (33%)(5 radios @ $4.48 per month) 1,660 1,660 1,660 1,660 3200 Water & Sewer service 2,600 2,600 2,600 3,000 Estimated annual charge 2,600 2,600 2,600 3,000 3210 Electricity 2,100 2,100 2,100 2,300 Electricity for lift stations 2,100 2,100 2,100 2,300 35,730 43,880 52,480 49,289 55 THIS PAGE LEFT BLANK INTENTIONALLY 56 Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance (continued) Account Description 2012 2013 2014 2015 Description 3230 Metro Waste Commission 760,913 816,267 822,568 832,084 Estimated annual charge 760,913 816,267 822,568 832,084 3610 Memberships 100 100 100 100 MN Rural Water Assoc. (50%) 50 50 50 50 Suburban Utility Superintendant Association (SUSA)(50% of $100) 80 80 80 80 MN Safety Council (20%) 230 230 230 230 3630 Training 1,400 1,400 1,400 1,400 Collection operators training/renewal ($350 per person) 560 560 560 560 Tuition reimbursement (PW Mgt. Class - North Hennepin CC) 250 250 250 250 Computer training/webinars 110 110 110 110 Hearing test/R2K (2.15 FTE * $50) 1,200 1,200 1,200 1,200 Confined space seminar (on-site)(not annual) 320 320 320 - Metro school - - 120 120 Pesticide applicators license 300 300 300 300 Miscellaneous wastewater training 60 60 60 60 Maintenance Expo 390 390 390 390 Equipment operator training - - 60 60 Work zone safety seminar (every 3 years) 4,590 4,590 4,770 4,450 4010 Rental, equipment 1,000 1,000 500 500 Barricades & signs 1,000 1,000 500 500 4800 Insurance 7,300 7,300 7,300 7,300 Share of property/liability insurance 7,300 7,300 7,300 7,300 5130 Repairs, equipment 2,500 2,500 2,500 2,500 Repairs to motors & pumps 2,500 2,500 2,500 2,500 Repairs to Vactor (jet truck) 2,500 2,500 2,500 2,500 Repairs to camera van and camera equipment 1,000 1,000 1,000 1,000 Repairs to utility truck 250 250 250 250 Misc repairs 8,750 8,750 8,750 8,750 5140 Repairs, streets - - - 10,000 Contractor restoration of pavement, bwd., etc... - - - 10,000 5150 Repairs, utilities 1,000 2,500 2,500 2,500 Lift station repairs - - - 15,000 Sanitary collection system repairs 1,000 2,500 2,500 17,500 5155 Utility service repairs 4,500 - - - Service line repairs 4,500 - - - 5160 System maintenance 15,000 15,000 15,000 - Sanitary collection system repairs 25,000 25,000 25,000 25,000 Root control - 15,000 15,000 - Contractor restoration of pavement, bwd., etc... 2,500 4,500 4,500 4,500 Lift station maintenance/cleaning/pump service - - 4,000 4,000 Sewer debris disposal costs 42,500 59,500 63,500 33,500 7030 Capital, equipment > $5000 30,000 30,000 30,000 30,000 Generator - trailer mounted (carryover) 8,500 - - - Wincam software upgrade/desktop license/training - - 2,750 2,750 Electronic rain gauges for SCADA (33%)(total cost $8,250) - - 12,000 12,000 Grinder station for Bronson lift station - - 3,000 - Camera Cable (Sewer & Storm Water) 38,500 30,000 47,750 44,750 7050 Construction > $25000 125,000 125,000 250,000 250,000 Sewer pipe relining program (carryover from 12,13) - - - ?Bronson lift station rehabilitation - - - ?Groveland lift station rehabilitation (with area H project) 125,000 125,000 250,000 250,000 7950 Depreciation 160,000 160,000 167,000 167,000 Estimated depreciation 160,000 160,000 167,000 167,000 9100 Contingency 15,000 15,000 15,000 15,000 Contingency - may include lift station impeller replacement at Bronson 15,000 15,000 15,000 15,000 9900 Transfer out 160,000 160,000 140,000 140,000 Sewer system upgrades in conjunction with major roadway program 160,000 160,000 140,000 140,000 1,329,283 1,390,137 1,529,868 1,531,064 57 2011 2012 2013 2014 Y-T-D 2015 Change from 2014 Actual Actual Actual Budget 07/31/14 Request Dollar Percent Street Lighting (Fund 740): Revenues 3610 Investment income 2,678 1,262 (3,218) 1,300 4,034 1,300 - 0.00% 3716 Penalties 635 650 679 500 770 500 - 0.00% 3740 Street lighting charges 75,493 75,581 81,946 88,364 65,162 91,567 3,203 3.62% Total revenue 78,806 77,493 79,407 90,164 69,966 93,367 3,203 3.55% Operating expenses Operations (4416) Personnel services 0100 Salaries, regular 2,700 2,734 2,617 2,828 1,951 6,470 3,642 128.78% 0110 Salaries, overtime 2 - - - - - - 0.00% 0300 Social security 179 188 189 216 132 495 279 129.17% 0321 PERA 190 195 198 205 141 415 210 102.44% 0400 Group insurance 518 550 575 600 441 612 12 2.00% 0500 Workers compensation 17 17 19 17 22 285 268 1576.47% Total personnel services 3,606 3,684 3,598 3,866 2,687 8,277 4,411 114.10% Materials & supplies 0 1600 Supplies, operating - - - 1,000 - 1,000 - 0.00% 0 Contractual services 3030 Other professional services - 0.00% 3210 Electricity 82,017 78,023 87,326 83,000 37,084 90,000 7,000 8.43% 4800 Insurance 684 573 618 900 594 900 - 0.00% 5150 Repairs, utilities 2,173 133 5,032 3,000 1,409 3,000 - 0.00% Total contractual services 84,874 78,729 92,976 86,900 39,087 93,900 7,000 8.06% Other 9900 Transfer to General Fund 2,252 2,320 2,390 2,462 - 2,536 74 3.01% Total other 2,252 2,320 2,390 2,462 - 2,536 74 3.01% 0.00% Total expenditures 90,732 84,733 98,964 94,228 41,774 105,713 11,485 12.19% Revenues over (under) expenditures (11,926) (7,240) (19,557) (4,064) 28,192 (12,346) (8,282) 203.79% 0.00% Add back: Capital outlays - - - - - - - 0.00% Change in net assets (11,926) (7,240) (19,557) (4,064) 28,192 (12,346) (8,282) 203.79% Net assets, beginning year 154,072 142,146 134,906 115,349 115,349 111,285 (4,064) -3.52% 0.00% Net assets, end of year 142,146$ 134,906$ 115,349$ 111,285$ 143,541$ 98,939$ (12,346)$ -11.09% 2015 Budget Summary 58 Fund: 740 Street Lighting Fund Revenues Account Description 2012 2013 2014 2015 Description 3610 Interest revenue 2,000 1,500 1,300 1,300 Estimated interest earnings at 1%. 2,000 1,500 1,300 1,300 3716 Penalties - 500 500 500 Estimated late fees on street lighting charges. - 500 500 500 3740 Street lighting charges 74,000 79,900 88,364 91,567 Estimated utility charges for street lighting. 74,000 79,900 88,364 91,567 Fund: 740 Department: 4416 Operations 1600 Supplies, operating - - 1,000 1,000 Bulbs, ballasts, covers, etc... - - 1,000 1,000 3210 Electricity 73,000 83,000 83,000 90,000 Estimate 73,000 83,000 83,000 90,000 4800 Insurance 900 900 900 900 Share of property/liability insurance 900 900 900 900 5150 Repairs, utilities 3,000 3,000 3,000 3,000 Repairs to street and trail lighting. 3,000 3,000 3,000 3,000 9900 Transfer out 2,320 2,390 2,462 2,536 Transfer to General Fund for administrative overhead costs 2,320 2,390 2,462 2,536 79,220 89,290 90,362 97,436 5.41%12.71%1.20%7.83% 59 2015 Budget Summary 2011 2012 2013 2014 Y-T-D 2015 Change from 2014 Actual Actual Actual Budget 07/31/14 Request Dollar Percent Storm Water (Fund 745): Revenues 3610 Investment income (charge 31,550 18,879 (51,529) 22,000 65,806 15,000 (7,000) -31.82% 3680 Other revenues 2,500 - - - - - - 0.00% 3716 Penalties & interest 2,052 2,093 2,215 - 2,256 - - 0.00% 3730 Surface water charges 263,924 264,302 266,372 265,000 206,035 265,000 - 0.00% 3972 Transfer from other funds 40,000 - - - - - 0.00% Total revenue 340,026 285,274 217,058 287,000 274,097 280,000 (7,000) -2.44% Operating expenses System Maintenance (4415): Personnel services 0100 Salaries, regular 47,563 49,428 53,978 51,960 41,497 71,361 19,401 37.34% 0110 Salaries, overtime 1,855 1,898 3,198 1,183 6,378 1,212 29 2.45% 0150 Salaries, part-time 5,295 3,311 6,139 4,920 5,910 2,640 (2,280) -46.34% 0300 Social security 4,166 4,100 4,682 4,441 4,025 5,754 1,313 29.57% 0321 PERA 3,595 3,638 3,589 3,853 3,327 5,443 1,590 41.27% 0400 Group insurance 6,384 7,651 2,864 5,965 2,631 13,110 7,145 119.78% 0500 Workers compensation 3,466 3,433 3,748 4,348 5,608 5,476 1,128 25.94% Total personnel services 72,324 73,459 78,198 76,670 69,376 104,996 28,326 36.95% Materials & supplies 1230 Supplies, equipment 648 5,511 7,106 3,250 760 3,250 - 0.00% 1240 Supplies, streets 54 - - 300 - 300 - 0.00% 1600 Supplies, operating 1,871 2,178 2,741 5,675 2,071 5,675 - 0.00% 1700 Motor fuels 2,553 1,767 3,078 3,350 3,325 2,925 (425) -12.69% 2100 Books/Periodicals - - - 100 40 100 - 0.00% 2400 Uniforms 715 918 768 740 314 470 (270) -36.49% 2410 Mats & towels 875 829 321 810 196 365 (445) -54.94% Total materials & suppli 6,716 11,203 14,014 14,225 6,706 13,085 (1,140) -8.01% Contractual services 3030 Other professional services 10,451 6,988 6,482 23,375 14,234 12,206 (11,169) -47.78% 3100 Telephone 1,417 1,122 697 780 409 780 - 0.00% 3610 Memberships 690 914 937 975 344 1,035 60 6.15% 3630 Training 2,094 1,329 368 3,195 1,092 2,445 (750) -23.47% 4800 Insurance 2,919 4,031 3,559 4,000 4,027 4,000 - 0.00% 5120 Repairs, vehicles - - 1,624 1,500 - 1,500 - 0.00% 5150 Repairs, utilities 3,336 265 - 25,000 50,366 25,000 - 0.00% Total contractual service 20,907 14,649 13,667 58,825 70,472 46,966 (11,859) -20.16% Capital outlays 7030 Equipment - - - 17,750 12,000 2,750 (15,000) -84.51% 7050 Construction - - - 125,000 - 125,000 - 0.00% 7950 Depreciation 30,566 31,397 30,708 32,000 - 32,000 - 0.00% Total capital outlays 30,566 31,397 30,708 174,750 12,000 159,750 (15,000) -8.58% Miscellaneous: 9900 Transfer out 56,000 46,756 46,959 82,168 - 82,383 215 0.26% Total miscellaneous 56,000 46,756 46,959 82,168 - 82,383 215 0.26% Total System Maintenance 186,513 177,464 183,546 406,638 158,554 407,180 542 0.13% 0.00% 60 Fund: 745 Storm Water Revenues Account Description 2012 2013 2014 2015 Description 3610 Interest revenue 22,000 22,000 22,000 15,000 Estimated interest earnings at 1%. 22,000 22,000 22,000 15,000 3730 Utility sales 250,718 250,718 265,000 265,000 Estimated surface water charges. 250,718 250,718 265,000 265,000 3972 Transfers - Vehicle & equip Fd 40,000 40,000 - - Transfer for capital equipment purchases 40,000 40,000 - - Fund: 745 Department: 4415 System Maintenance 1230 Supplies, equipment < $5000 500 250 1,500 1,500 Miscellaneous equipment & parts (AEBI parts, pole camera parts) - - 1,250 1,250 Filters, brakes, bulbs, wipers, tires, batteries, etc... - 2,500 - - Leveling bar for skidsteer - 3,500 - - Winch for pick-up truck - 3,700 - - Tommy gate fro pick-up truck - 600 - - Truck springs 1,500 1,000 500 500 Hoses & nozzles 2,000 11,550 3,250 3,250 1240 Supplies, streets 600 300 300 300 Bituminous mix 600 300 300 300 1600 Supplies, operating 300 250 250 250 Concrete 2,000 2,450 2,450 2,450 Rain Garden mix, riprap, topsoil, seed and sod 200 175 175 175 Concrete adjustment rings - 150 150 150 Hand tools 200 175 150 150 CD's, DVD's, software upgrade for camera van 500 2,500 2,500 2,500 Catch basin castings, pipe, approns, etc... 3,200 5,700 5,675 5,675 1700 Motor fuels 1,350 1,350 1,350 - 300 gallons diesel fuel @ $3.75 / gallon for Vactor 2,000 2,000 2,000 2,925 900 gallons unleaded @ $3.25 for utility truck 3,350 3,350 3,350 2,925 2100 Books/Periodicals 100 100 100 100 Storm water books/periodicals 100 100 100 100 2400 Uniforms 740 740 740 470 Uniforms/clothing (7.3% of $4,500, .8 FTE x $175 per contract) 740 740 740 470 2410 Mats & towels 810 810 810 365 Share of floor mats & shop towels (7.3% of $8,500) 810 810 810 365 3030 Other professional services 5,000 5,000 7,500 7,500 Consulting engineers (SWPPP, Studies, etc...) 1,250 1,250 2,500 2,500 Arcview/GIS base map consulting - - 12,500 - Silverview pond sediment removal - - - 1,000 Asset management software 100 100 100 100 Fire extinguisher inspection/servcie (5 @ $20) - 760 775 1,106 Audit fees 3.5% (up from 2.5%) 6,350 7,110 23,375 12,206 3100 Communications 690 690 690 690 Cell Phone (8% of $8,500) 90 90 90 90 800 Mhz radio license fee (33%)(5 radios @ $4.48 per month) 780 780 780 780 3610 Memberships 150 150 180 190 American Public Works Association (APWA)(25% of $710) 725 725 750 800 Minnesota Cities Storm Water Coalition 45 45 45 45 MN Safety Council (11% of $405) 920 920 975 1,035 3630 Training 200 200 200 200 Seminars & training sessions (Stormwater) 55 55 55 55 Hearing test/R2K (1.1 FTE * $50) 350 350 350 350 Safety training 750 750 750 500 NPDES compliance training 1,250 1,250 1,250 750 Tuition reimbursement 270 270 270 270 Erosion & Stormwater Maint. Certification 220 220 220 220 Equipment operator training 100 100 100 100 Computer/webinar training 3,195 3,195 3,195 2,445 4800 Insurance 1,900 1,900 2,500 2,500 Share of property/liability insurance - - 1,500 1,500 Deductible 1,900 1,900 4,000 4,000 5120 Repairs, vehicles - 1,500 1,500 1,500 Utility truck & equipment repairs - 1,500 1,500 1,500 5150 Repairs & maint., utilities 25,000 25,000 25,000 25,000 Repair & maintain storm sewers, ponds, basins, and drainage issues - 10,000 - - Storm Sewer slip linning improvements 25,000 35,000 25,000 25,000 7030 Equipment > $5000 4,000 4,000 - - Small generator for trailer 5,000 5,000 - - Concrete mixer - - 3,000 - Camera Cable (Sewer & Storm Water) - - 12,000 - Flail mower for AEBI - - 2,750 2,750 Electronic rain gauges for SCADA (33%)(total cost $8,250) 9,000 9,000 17,750 2,750 7050 Construction > $25000 25,000 - - - Sewer sliplining program 35,000 50,000 75,000 75,000 Mustang Drive improvements 48,000 48,000 50,000 50,000 Storm water projects, Subwatershed SC-1, SC-3, EW-4 108,000 98,000 125,000 125,000 61 2015 Budget Summary 2011 2012 2013 2014 Y-T-D 2015 Change from 2014 Actual Actual Actual Budget 07/31/14 Request Dollar Percent Storm Water (Fund 745): Street Sweeping (4417): Personnel services 0100 Salaries, regular 7,940 8,174 7,588 8,204 5,990 11,202 2,998 36.54% 0110 Salaries, overtime 286 256 304 1,183 228 1,212 29 2.45% 0150 Salaries, part-time - - - 240 - - (240) -100.00% 0300 Social security 571 596 547 736 441 950 214 29.08% 0321 PERA 595 570 525 681 444 931 250 36.71% 0400 Group insurance 1,349 1,482 914 1,570 911 2,280 710 45.22% 0500 Workers compensation 570 567 616 721 930 1,336 615 85.30% Total personnel services 11,311 11,645 10,494 13,335 8,944 17,911 4,576 34.32% Materials & supplies 1230 Supplies, equipment 6,039 7,352 3,869 2,500 2,048 2,500 - 0.00% 1600 Supplies, operating 1,456 2,526 2,608 3,500 1,977 3,500 - 0.00% 1700 Motor fuels 4,987 5,249 2,755 4,650 3,081 4,750 100 2.15% 2400 Uniforms 75 104 79 115 48 116 1 0.87% 2410 Mats & towels 130 130 51 110 31 90 (20) -18.18% Total materials & suppli 12,687 15,361 9,362 10,875 7,185 10,956 81 0.74% Contractual services 3030 Other professional services - 205 3 4 - 0.00% 3530 Disposal - - - 5,000 - 5,000 - 0.00% 3630 Training - 15 40 280 11 280 - 0.00% 5130 Repairs, equipment 8,139 117 1,395 4,000 - 4,000 - 0.00% Total contractual service 8,139 337 1,438 9,280 15 9,280 - 0.00% Capital outlays 7030 Equipment - - - - - - 0.00% Total capital outlays - - - - - - - 0.00% 0.00% Miscellaneous:0.00% 9900 Transfer out - 16,000 16,000 16,000 - 71,000 55,000 343.75% Total miscellaneous - 16,000 16,000 16,000 - 71,000 55,000 343.75% Total street sweeping 32,137 43,343 37,294 49,490 16,144 109,147 59,657 120.54% Total expenditures 218,650 220,807 220,840 456,128 174,698 516,327 60,199 13.20% Revenues over expenditures 121,376 64,467 (3,782) (169,128) 99,399 (236,327) (67,199) 39.73% Add back: Capital outlays - - - 142,750 12,000 127,750 (15,000) -10.51% Change in net asssets 121,376 64,467 (3,782) (26,378) 111,399 (108,577) (82,199) 311.62% Net assets, beginning year 2,873,860 2,995,236 3,059,703 3,055,921 3,055,921 3,029,543 (26,378) -0.86% Net assets, end of year 2,995,236$ 3,059,703$ 3,055,921$ 3,029,543$ 3,167,320$ 2,920,966$ (108,577)$ -3.58% 62 Fund: 745 Department: 4415 System Maintenance 7950 Depreciation 32,000 32,000 32,000 32,000 Estimated depreciation 32,000 32,000 32,000 32,000 9900 Transfer out 40,000 40,000 75,000 75,000 Storm water system upgrades in conjunction with major roadway program 6,756 6,959 7,168 7,383 General Fund 46,756 46,959 82,168 82,383 244,701 258,914 329,968 302,184 Fund: 745 Department: 4417 Street Cleaning 1230 Supplies, equipment < $5000 2,500 2,500 2,500 2,500 Misc. sweeper repairs - belts, pumps, hoses, filters, etc. 2,500 2,500 2,500 2,500 1600 Supplies, operating 2,300 2,300 2,300 2,300 Gutter brooms 700 700 700 700 Belts, pumps, hoses, filters, etc... for sweeper 100 100 100 100 Gloves, hearing protection, etc... 400 400 400 400 2 dirt shoes 3,500 3,500 3,500 3,500 1700 Motor fuels 4,000 4,000 4,500 3,750 Diesel fuel - 1000 gallons @ $3.75/gallon 150 150 150 1,000 Hydraulic oil - 4 changes 4,150 4,150 4,650 4,750 2400 Uniforms 115 115 115 116 Uniforms/clothing (1.8% of $4,500, .2 FTE x $175 per contract) 115 115 115 116 2410 Mats & towels 110 110 110 90 Share of floor mats & shop towels (1.8% of $5,000) 110 110 110 90 3530 Disposal 5,000 5,000 5,000 5,000 Dumping charges for sweeping disposals 5,000 5,000 5,000 5,000 3630 Training 250 250 250 250 NPDES compliance training 30 30 30 30 Maintenance Expo 280 280 280 280 5130 Repairs, equipment 4,000 4,000 4,000 4,000 Elgin sweeper repairs 4,000 4,000 4,000 4,000 7030 Equipment > $5000 - - - ?Street sweeper - - - - 9900 Transfer out to Vehicle & Equip 16,000 16,000 16,000 71,000 Transfer to Vehicle & Equip Fund for future replacements 16,000 16,000 16,000 71,000 35,655 35,655 36,155 91,236 280,356 294,569 366,123 393,420 19.96%5.07%24.29%7.46% 63 THIS PAGE LEFT BLANK INTENTIONALLY 64 Item No: 1 Meeting Date: October 6, 2014 Type of Business: WS City Administrator Review: ______ City of Mounds View Staff Report To: Honorable Mayor and City Council From: Desaree Crane, Assistant City Administrator Item Title/Subject: Joint Meeting with the Festival in the Park Committee The Festival in the Park of Mounds View Committee is requesting a meeting with the City Council to discuss the Festival in the Park Committee’s current financial condition. Attached is the Committee’s current budget as of September 30, 2014. It appears the Festival budget will be at a deficit of approximately $3,000, if not more. The Car Show is already looking at about a $1,000 deficit for 2015. The Committee will be respectfully requesting some financial support from the City. The Committee does have a fundraising subcommittee, and did receive some money and in-kind donations from area businesses. However, the donations were not enough to sustain the Festival budget. The President (Theresa Cermak) and the Treasurer (Diane Wuori) will be present at this meeting to make their presentation to the City Council. Respectfully Submitted, Desaree Crane Item No: 2 Meeting Date: October 6, 2014 Type of Business: W orksession Administrator Review : ________ City of Mounds View Staff Report To: Honorable Mayor and City Council From: Heidi Heller, Planning Associate Item Title/Subject: Continued Discussion about allowing Tubular Tent Structures in the City Introduction: At the August 25, 2014 City Council meeting, a resident approached the City Council to ask why he was not allowed to have a tubular tent structure but someone else could have a greenhouse, which according to this resident, are very similar. The Council agreed to discuss the topic at a Worksession, and did so at the September Worksession meeting. No consensus was determined, so the discussion continues. Discussion: Staff’s concern with these tubular tent structures is that they deteriorate much quicker than a regular shed, particularly if they have a canvas or plastic roof, and whatever is stored underneath the tent is visible and potentially aesthetically displeasing. They are designed to cover a boat or vehicle, but other items tend to accumulate under any type of shelters. And in the winter, tarps end up attached to them to fully enclose the sides. A shed or garage will hide everything inside and the property is much cleaner and visually pleasing. In 2000 and 2009, the Council amended the Zoning Code to specifically not allow these types of structures. These temporary structures tend to get placed next to or in front of the houses and garages, and the Code specifies that all accessory buildings must be placed only in rear yards. Greenhouses were allowed because they have a specific purpose for gardening and are typically fairly small. Shoreview does not allow these types of structures. They have specific design criteria for accessory buildings and these temporary structures would not meeting those standards. New Brighton requires all accessory structures to meet the building code for snow load and ground anchoring, and temporary accessory structures are not typically able to meet those requirements. Although they did note that some of the styles that are heavy-duty and all metal may possibly be able to meet the building code requirements, so they would consider allowing them. If the Council is inclined to be more permissive with these temporary structures, staff would suggest that the Zoning Code be amended to only specifically allow ones that are completely metal. Staff also suggests that the Council continue to not allow any use of cloth, canvas, plastic or tarps on accessory structures. Tubular Structure Staff Report October 6, 2014 Page 2 Current Zoning Code for Accessory Buildings: 1103.06: ACCESSORY BUILDINGS, USES AND EQUIPMENT: Subd. 1. Connection to Principal Building: An accessory building shall be considered an integral part of the principal building if it is connected to the principal building by a covered passageway. Subd. 2. Location in Yards: a. No accessory building, other than a garage, shall be erected or located within any required yard other than the rear yard. (1988 Code §40.04) b. Accessory uses or equipment must be located in the rear yard, except those expressly allowed in side yards in subdivision 1104.01(5) of this Title. (Ord. 453, 2-27-89) 1106.03: ACCESSORY USES: The following are permitted accessory uses in an R-1 District: (1988 Code §40.10) Subd. 1. Accessory Buildings: Accessory buildings, which for these purposes shall include garages, tool houses, carports, sheds and similar buildings for storage of domestic supply and noncommercial recreational equipment, whether attached or detached. (Ord. 664, 8-14-00) a. Every R-1 zoned property improved with a single-family dwelling is allowed a maximum of one-thousand eight hundred (1,800) square feet of combined accessory building area, subject to the requirements noted herein. (Ord. 664, 8-14-00; Ord. 693, 3-25-02) b. Accessory buildings shall not exceed eighteen feet (18’) or that of the principal structure, whichever is less, in height, shall be five feet (5’) or more from all lots lines of adjoining lots and shall have a pitch or slope of at least 2-12, but no steeper than 12-12. Rounded, dome or geodesic dome roofs are not allowed on accessory buildings. Accessory buildings one hundred twenty (120) square feet or under shall be three feet (3’) or more from any other building or structure. Accessory buildings over one hundred twenty (120) square feet shall meet the minimum fire separation distance as required by the Minnesota State Building Code. (Ord. 664, 8-14-00; Ord. 828, 10-8-09) c. No accessory building in an R-1 District shall exceed nine hundred fifty-two (952) square feet in area, except by conditional use permit. (Ord. 620, 7-27-98; Ord. 664, 8-14-00) d. The combined square footage of accessory buildings in a rear yard shall not exceed twenty percent (20%) of the rear yard. (Ord. 442, 7-11-88; Ord. 620, 7-27-98; Ord. 664, 8-14-00) e. An outdoor living room or patio shall not be used for storage of automobiles or trucks. (Ord. 664-8-14-00) Tubular Structure Staff Report October 6, 2014 Page 3 f. No permit shall be issued for the construction of more than three (3) accessory buildings in any R-1 District. One (1) of the three (3) permits must be for a garage. (Ord. 664, 8-14-00) g. Accessory buildings shall have a weather resistant, treated or finished exterior. Structures composed of tubular metal and canvas or exposed plywood, particle board or similar materials shall not be permitted. The City does not allow cloth, canvas, plastic sheets and tarps or similar materials as primary exterior materials on accessory buildings (except for green houses). (Ord. 664, 8-14-00; Ord. 828, 10-8-09) h. If any accessory building is to be utilized for the storage of frequently-used vehicles, it shall be serviced by an improved driveway so as to control dust, drainage and erosion, according to the requirements as set forth in Section 902.05 of this Code. (Ord. 664, 8-14-00) i. The roof of all accessory buildings exceeding two hundred fifty (250) square feet in size shall: (Added, Ord. 828, 10-8-09) (1) Match or be similar to the character and style of the roof of the principal structure. (Added, Ord. 828, 10-8-09) (2) Have a pitch or slope of at least 2-12. (Added, Ord. 828, 10-8-09) Recommendation: After discussing, staff requests that the Council provide direction as to whether or not staff should move forward with a code amendment to allow tubular tent structures in the City of Mounds View. Respectfully submitted, Heidi Heller Planning Associate Attachment: Photos of tubular tent structure next to the garage- Wayne Gardas, 8200 Red Oak Drive (this is the resident who approached the Council about these structures) Item No: 3 Meeting Date: October 6, 2014 Type of Business: Work Session City of Mounds View Staff Report To: Honorable Mayor and City Council From: James Ericson, City Administrator Item Title/Subject: Joint Meeting with the Charter Commission Introduction: Through the Mayor, the City Council has expressed a desire to meet with the Charter Commission to discuss membership levels in light of the low number of appointed participants. Members apply to and are appointed by the Ramsey County District Court, however there haven’t been any applicants in some time for County consideration. The intent of the joint meeting is to address the existing membership deficiency and to formulate appropriate strategies. Discussion: The Charter Commission is authorized to have eleven members, however their number has dropped to five, often with only three members attending a meeting. It has been suggested that a Charter Commission, not unlike a City Council, needs to operate at full capacity, with a quorum assuming full capacity (in other words, six members.) Both the City Council and the Charter Commission have announced the openings during their respective meetings; and despite advertisements in the newspapers, on the Cable TV channel and the website, residents are not lining up to volunteer their time on the Commission. Staff has also been in communication with the District Court regarding the declining membership and asked if perhaps they had any pending applications (no) and if they had any recommendations to address the declining membership. The Court declined to provide any suggestions, indicating that it was not their role to do so. Recommendation: Staff recommends the Council discuss the issue of membership with the Charter Commission and determine what actions, if any, can be taken to address the deficiency. Respectfully submitted, ________________________ James Ericson City Administrator Item No: 4 Meeting Date: October 6, 2014 Type of Business: Work Session City of Mounds View Staff Report To: Honorable Mayor and City Council From: James Ericson, City Administrator Item Title/Subject: Review Proposed Hours of Operation for the Mounds View Community Center Introduction: At the September YMCA Advisory Committee meeting, the Y staff discussed the possibility of expanding the hours that the building is open to better address the changing needs of the community. Presently, the Community Center is open 85 hours each week; the proposal would increase that number to 92 hours. The additional cost of the expanded hours would be about $4,400 per year. Discussion: The following represents the MVCC’s current building hours: Mon Tues Weds Thur Fri Sat Sun Total Hours: 9 am 9 am 9 am 9 am 9 am 8 am 11 am 10 pm 10 pm 10 pm 10 am 10 am 9 pm 6 pm 85 The following revised schedule is being proposed: Mon Tues Weds Thur Fri Sat Sun Total Hours: 8 am 8 am 8 am 8 am 8 am 8 am 10 am 9 pm 9 pm 9 pm 9 pm 10 pm 10 pm 8 pm 90 As can be seen, the only change Mondays through Thursdays would be to open and close one hour earlier. The building would be open an hour earlier on Fridays, and on Saturdays the building would remain open an hour later. Sundays the building would open an hour earlier and stay open two hours later. In addition to the five more hours on the weekend, the Y proposes two additional hours during the week (not shown above) specifically for open volleyball, bringing the total staffed hours of the building up to 92. The calculated cost of the additional seven hours of staff time would come to $4,368. The current management fee paid to the YMCA for the 85 hours amounts to $250,742, excluding costs for warming house attendants or any part-time event center staff. There would be a partial offset to the additional labor costs from new user fees (program fees and gym fees) collected during the expanded hours of operation. The extent of the potential revenue offset however is unknown at this point. MVCC Hours of Operation October 6, 2014 Page 2 Recommendation: Staff recommends the Council discuss the proposed expansion to the hours of operation for the Mounds View Community Center. Nate Danielson, Community Program Director at the facility, will be on hand to answer any questions regarding the proposal, as well to provide other updates regarding the facility. Respectfully submitted, ________________________ James Ericson City Administrator