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 - 2016/10/03
CITY OF MOUNDS VIEW CITY COUNCIL WORK SESSION AGENDA MOUNDS VIEW CITY HALL Monday, October 3, 2016 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 the Charter Commission 2. Draft 2017 Other Funds Budgets 3. Water Infrastructure and Production Assessment 4. Review Non-compliant Curb Cuts from Previous Street Projects Next Work Session: Monday, November 7, 2016, at 7pm Next City Council Meeting: Monday, October 10, 2016, at 7pm DRAFT - Water Treatment System Needs Assessment September 2016 P05367-2015-000 50 CHAPTER 8 CONCLUSIONS AND RECCOMENDATIONS The goal of this assessment was to review the process, mechanical, electrical, and controls for all of Mounds Views water treatment infrastructure and construct a plan for Mounds View to follow that would responsibly and efficiently assist them in re-investing in these facilities. This plan will ensure that the City of Mounds View is equipped with a reliable and robust treatment system for years to come. The City of Mounds View currently has adequate water supplies to provide clean drinking water to its residents for the foreseeable future, but this assessment indicated many areas where the treatment infrastructure is nearing the end of its life and could be improved. All three water treatment facilities are nearing 25 years old. Two of the treatment facilities have already undergone one round of tank rehabilitation. Most of the control panels that operate these systems are obsolete and parts are no longer available. AE2S would recommend that Mounds View begin to plan for the replacement of portions of these systems. 8.1 Proposed Improvements Based on the review of WTP’s No. 1, No. 2, and No. 3, the Booster Station and Wells 1-6 the following observations were made. Improvement No. 1: WTP No. 2 is at the end of its life and is should take priority for rehabilitation. The suggested timeline for this rehabilitation would be sometime in the next 1-2 years but can be adjusted to accommodate City priorities. The costs and needs that were addressed in chapter 4 can either be done in small pieces or as a larger project. Because WTP No. 2 has multiple items that are in need of replacement it may be more cost effective to complete these improvements as one large project. The estimated cost to completely rehabilitate WTP No. 2 is $1,601,600. Mounds View should also budget for an additional $300,000 in engineering services when they decide to undergo rehabilitation of WTP No. 2. The detailed estimate for this project is included in Appendix D. Improvement No. 2: Mounds View’s control panels are in need of replacement. Many are utilizing equipment that is no longer available. Figure 8.1 below summarizes the anticipated costs to replace/rehabilitate these control panels and a suggested timeline to accomplish these improvements. The total estimated costs for these improvements is shown in Figure 8.1 and is approximately $482,000 (2016 dollars). Most of these improvements could be completed in the next 2 years but the well No. 1 and No. 2 control panel improvements could be scheduled for 5 years. Control panel replacement can be done in conjunction with process improvements. If Mounds View decides to rehabilitate WTP No. 2 the controls for that facility would be completed at that time and is already included in the $1.6M estimate for that project. DRAFT - Water Treatment System Needs Assessment September 2016 P05367-2015-000 51 I&C Control Panel Needs Figure 8.1 Modifications to any of the three (3) water treatment facilities will require updates to achieve complete chemical code compliance. This should be kept in mind when choosing to accomplish any of the needed improvements. These three (3) observations were the main drivers to the implementation plan that was developed and included in Appendix I. 8.2 Implementation Plan The main goal of the implementation plan is to accomplish the two main improvements listed above (WTP No. 2 rehabilitation and control panel replacement). Following those improvements WTP No. 3 rehabilitation and other various improvements were scheduled. These improvements are completely adjustable depending on the City of Mounds Views priorities and goals. They can also be spaced out more to accommodate funding coordination. In the current plan WTP No. 2 and WTP No. 3 rehabilitations were spaced out to minimize budget issues and Mounds View staffing conflicts. $ 153,000 $ 165,485 $ - Complete Panel Replacement Replace in 1-2 years $ 153,000 $ 165,485 $ 42,000 $ 3,245 $ 47,449 PLC Replacement Replace in 5 years - Modifications in Existing Panel $ 33,000 $ 40,150 Radio Replacement Replace in 5 years - Modifications in Existing Panel $ 3,000 $ 3,245 OIT Installation Replace in 5 years - Modifications in Existing Panel $ 6,000 $ 7,300 $ 42,000 $ 3,245 $ 47,449 PLC Replacement Replace in 5 years - Modifications in Existing Panel $ 33,000 $ 40,150 Radio Replacement Replace in 5 years - Modifications in Existing Panel $ 3,000 $ 3,245 OIT Installation Replace in 5 years - Modifications in Existing Panel $ 6,000 $ 7,300 $ 45,000 $ 48,672 $ - PLC Replacement Replace in 1-2 years - Modifications in Existing Panel $ 36,000 $ 38,938 Radio Replacement Replace in 1-2 years - Modifications in Existing Panel $ 3,000 $ 3,245 OIT Installation Replace in 1-2 years - Modifications in Existing Panel $ 6,000 $ 6,490 $ 58,000 $ 62,733 $ - Complete Panel Replacement Replace in 1-2 years $ 58,000 $ 62,733 $ 58,000 $ 62,733 $ - Complete Panel Replacement Replace in 1-2 years $ 58,000 $ 62,733 $ 41,000 $ 44,346 Complete Panel Replacement Replace in 1-2 years $ 41,000 $ 44,346 $ 43,000 $ 46,509 PLC Replacement Replace in 1-2 years - Modifications in Existing Panel $ 34,000 $ 36,774 Radio Replacement Replace in 1-2 years - Modifications in Existing Panel $ 3,000 $ 3,245 OIT Installation Replace in 1-2 years - Modifications in Existing Panel $ 6,000 $ 6,490 482,000$ 436,966$ 94,899$ Total Estimated Costs 2018 Budget 2021 Budget I&C Improvements Well No. 3 I&C Improvements WTP No. 1 I&C Improvements Well No. 1 I&C Improvements PROJECT WTP No. 1 Well No. 2 I&C Improvements 2 YEAR REPLACEMENT (2018) 5 YEAR REPLACEMENT (2021)ASSESSMENT Public Works Well 6 and WTP I&C Improvements Booster Station I&C Improvements WTP No. 2 Well 5 and WTP I&C Improvements WTP No. 3 CONSTRUCTION COST (2016 Dollars) CITY OF MOUNDS VIEW, MINNESOTA Enterprise Funds 2017 Budgets Combining Statement of Revenues and Expenses Sanitary Street Storm Water Sewer Lighting Water 2017 2016 Operating revenue: Operating revenues 1,052,376 1,507,830 104,402 270,000 2,934,608 2,783,585 Special assessments 60,000 - - - 60,000 55,000 Connection charges 2,000 - - - 2,000 1,000 Total operating revenue 1,114,376 1,507,830 104,402 270,000 2,996,608 2,839,585 Operating expenses: Personal services 372,274 366,598 8,641 124,358 871,871 857,742 Supplies 74,999 31,112 1,000 20,295 127,406 126,471 Contractual services 218,570 106,809 3,900 154,140 483,419 470,829 Electricity & gas 115,500 2,100 70,000 - 187,600 195,300 Disposal charges - 918,137 - - 918,137 898,071 Contingency 15,000 15,000 - - 30,000 30,000 Depreciation 270,000 153,000 - 32,000 455,000 454,000 Capital outlays 149,640 150,000 - 75,000 374,640 624,183 Total operating expenses 1,215,983 1,742,756 83,541 405,793 3,448,073 3,656,596 Net operating income (loss)(101,607) (234,926) 20,861 (135,793) (451,465) (817,011) Non-operating revenue (expenses): Investment income 500 30,000 1,300 15,000 46,800 47,300 Principal payment on debt (ESP Lease)- - (6,924) - (6,924) (9,556) Total non-operating 500 30,000 (5,624) 15,000 39,876 37,744 Transfers Transfers in - - - - - 83,000 Transfers out (139,828) (98,058) (2,690) (39,832) (280,408) (520,144) Revenues over (under) expenditures (240,935) (302,984) 12,547 (160,625) (691,997) (1,216,411) Add back: Capital outlays 149,640 150,000 - 75,000 374,640 624,183 Principal on debt - - 6,924 - 6,924 9,556 Net income (loss)(91,295) (152,984) 19,471 (85,625) (310,433) (582,672) Net assets (deficit), January 1 3,589,863 3,574,815 50,254 3,030,193 10,245,124 11,082,653 Net assets (deficit), December 31 3,498,568$ 3,421,831$ 69,725$ 2,944,568$ 9,934,691$ 10,499,981$ Total 1 2013 2014 2015 2016 Y-T-D 2017 Change from 2015 Actual Actual Actual Budget 09/30/16 Request Dollar Percent Water (Fund 700): Revenues 3426 Reimbursed staff time 100 - - - - - 0.00% 3551 Spec assessments-current 69,242 62,591 63,729 55,000 29,474 60,000 5,000 9.09% 3552 Spec assessments-delinquent 2,922 3,133 3,212 - 2,226 2,500 2,500 #DIV/0! 3553 Spec assess.-penalty & interest 1,713 647 415 545 - - 0.00% 3610 Investment income (8,287) 8,909 (1,995) 1,000 (96) 500 (500) -50.00% 3680 Other revenues 3,220 10,399 2,598 2,000 3,960 2,000 - 0.00% 3710 Water sales 777,150 768,838 783,857 906,974 599,897 956,876 49,902 5.50% 3712 Utility credits 50 - - - - - - 0.00% 3714 Water service insurance 54,980 65,848 83,413 85,000 67,783 85,000 - 0.00% 3715 Utility connections 2,750 3,750 4,050 1,000 1,400 2,000 1,000 100.00% 3716 Penalties 7,011 7,022 8,649 5,000 12,422 6,000 1,000 20.00% 3913 Meter sales 1,269 855 3,208 - 1,328 - - 0.00% WAC/SWM charges 2,500 53,680 6,000 - 2,000 - - 0.00% 3972 Transfers - Vehicle & Equip - 72,000 - - - - - 0.00% Total revenue 914,620 1,057,672 957,136 1,055,974 720,939 1,114,876 58,902 5.58% Operating expenses Billing Services (4820): Personnel services 0100 Salaries, regular 38,295 40,222 42,117 42,116 31,649 43,167 1,051 2.50% 0300 Social security 2,798 2,911 3,055 3,221 2,311 3,302 81 2.51% 0321 PERA 2,686 2,810 3,039 3,159 2,300 3,238 79 2.50% 0322 GASB 68 Pension Exp - - 8,173 - - - - 0.00% 0400 Group insurance 3,700 3,722 3,286 5,128 2,509 5,407 279 5.44% 0500 Workers compensation 234 311 437 476 310 354 (122) -25.63% Total personnel services 47,713 49,976 60,107 54,100 39,079 55,468 1,368 2.53% Materials & supplies 1600 Supplies, operating - - - 50 - 50 - 0.00% Total materials & supplies - - - 50 - 50 - 0.00% Contractual services 3030 Other professional services 6,901 6,891 8,040 8,289 8,008 8,436 147 1.77% 3300 Postage 3,232 3,330 3,430 4,377 1,796 4,352 (25) -0.57% 3430 Printing 881 - 271 900 - 900 - 0.00% 3630 Training - - - 1,500 - 1,500 - 0.00% 5130 Repairs, equipment 3,693 4,017 4,264 4,729 5,223 4,448 (281) -5.94% Total contractual services 14,707 14,238 16,005 19,795 15,027 19,636 (159) -0.80% Debt Service: 8010 Principal 230,000 - - - - - - 0.00% 8020 Interest 680 - - - - - - 0.00% Total capital outlays 230,680 - - - - - - 0.00% Miscellaneous: 9900 Transfers out to General Fund 67,372 69,393 - 73,619 - 75,828 2,209 3.00% 9900 Transfers out to Vehicle Fund 58,000 60,000 - 64,000 - 64,000 - 0.00% Total capital outlays 125,372 129,393 - 137,619 - 139,828 2,209 1.61% Total Billing 418,472 193,607 76,112 211,564 54,106 214,982 3,418 1.62% 157,464 159,514 2017 Budget Summary 2 Fund: 700 Department: 4820 Billing Services Account Description 2014 2015 2016 2017 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 6,977 7,742 7,889 8,036 24.5% of audit fee (2017 - $32,800, 2018 - $33,400) 800 - - - Inserting & mailing bills (move to 3300) 400 400 400 400 County special assessment maintenance fee 8,177 8,142 8,289 8,436 3300 Postage 3,136 3,136 3,136 3,072 3200 bills X $0.48 postage X 4 billings X 1/2 cost - 800 800 800 Inserting & mailing bills (moved from 3030) 460 490 441 480 Late notices: 500 bills X $0.48 postage X 4 billings X 1/2 cost 3,596 4,426 4,377 4,352 3430 Printing 450 450 450 450 Utility bills (1/2 cost) 450 450 450 450 Envelopes 900 900 900 900 3630 Training 1,500 1,500 1,500 1,500 Seminars on new regulations, software updates, etc. INCODE training 1,500 1,500 1,500 1,500 5130 Repairs, equipment 3,506 3,682 3,866 4,060 INCODE software maintenance support (30%) - 475 475 - Neptune software maintenance (1/2 in sewer)(every 3 years)(2019) 369 388 388 388 Handheld interface support for meter readers (1/2 in sewer)(Incode) 3,875 4,545 4,729 4,448 8040 Continuing Disclosure 1,200 - - - Annual debt disclosure requirements and Ramsey county sp. Assmt. Fees 1,200 - - - 9900 Transfers out 69,393 71,475 73,619 75,828 Transfer to General Fund for administrative overhead costs 60,000 58,000 64,000 64,000 Transfer to Vehicle & Equipment Fund to fund future purchases 129,393 129,475 137,619 139,828 148,691 149,038 157,464 159,514 3 2013 2014 2015 2016 Y-T-D 2017 Change from 2015 Actual Actual Actual Budget 09/30/16 Request Dollar Percent Water (Fund 700): 2017 Budget Summary Infrastructure & Equip Maintenance (4823): Personnel services 0100 Salaries, regular 155,246 195,190 177,110 181,542 130,170 187,284 5,742 3.16% 0110 Salaries, overtime 11,268 12,053 10,701 9,669 4,974 9,911 242 2.50% 0150 Salaries, part-time - 8,921 8,318 10,320 2,813 10,320 - 0.00% 0300 Social security 12,077 14,989 13,853 15,417 9,754 15,873 456 2.96% 0321 PERA 12,254 14,625 13,564 14,646 10,073 15,095 449 3.07% 0400 Group insurance 24,469 31,480 28,772 32,682 21,843 33,480 798 2.44% 0500 Workers compensation 6,020 8,784 9,304 10,137 6,886 7,835 (2,302) -22.71% Total personnel services 221,334 286,042 261,622 274,413 186,513 279,798 5,385 1.96% Materials & supplies 1210 Supplies, bldg & grnds 1,131 833 1,347 2,750 70 2,750 - 0.00% 1220 Supplies, vehicles 1,712 506 (488) 1,500 2,130 1,500 - 0.00% 1230 Supplies, equipment 10,607 21,853 8,041 1,625 739 1,625 - 0.00% 1240 Supplies, streets 11,191 2,226 5,186 3,000 1,709 3,000 - 0.00% 1250 Supplies, utilities 16,192 17,265 17,350 11,500 7,094 15,000 3,500 30.43% 1260 Supplies, traffic control 257 200 - 200 - 200 - 0.00% 1600 Supplies, operating 8,812 8,615 8,770 5,800 2,100 7,000 1,200 20.69% 1700 Motor fuels 9,271 5,652 5,145 3,575 2,604 4,000 425 11.89% 2400 Uniforms 1,618 1,025 1,474 1,100 1,013 1,100 - 0.00% 2410 Mats & towels 642 634 697 620 520 620 - 0.00% Total materials & supplies 61,433 58,809 47,522 31,670 17,979 36,795 5,125 16.18% Contractual services 3030 Other professional services 7,310 20,946 34,125 22,630 12,728 8,630 (14,000) -61.86% 3100 Communications - telephone 2,535 2,435 3,025 3,056 2,552 3,164 108 3.53% 3200 Water & wastewater charges 7,286 6,398 8,501 7,200 2,714 7,200 - 0.00% 3220 Natural gas 7,668 8,336 7,405 7,000 3,903 7,500 500 7.14% 3610 Memberships 208 527 - 290 26 290 - 0.00% 3630 Training 1,676 2,737 2,950 3,850 1,251 3,850 - 0.00% 4010 Equipment rental 2,672 7,117 2,905 4,500 - 4,500 - 0.00% 4800 Insurance 7,023 6,754 6,933 10,230 7,469 10,230 - 0.00% 5110 Repairs, bldgs & grnds 248 1,758 6,531 7,000 5,836 11,540 4,540 64.86% 5120 Repairs, vehicles - - 20 1,000 128 1,000 - 0.00% 5130 Repairs, equipment 19,057 8,025 7,670 12,600 4,592 15,600 3,000 23.81% 5140 Repairs, streets 34,222 3,110 6,450 10,000 - 10,000 - 0.00% 5150 Repairs, utilities 2,148 14,516 19,415 17,500 2,921 17,500 - 0.00% 5155 Water service repair 170,240 121,561 71,104 80,000 54,679 80,000 - 0.00% 5160 Repairs, system maintenance 5,800 9,280 742 3,500 - 3,500 - 0.00% Total contractual services 268,093 213,500 177,776 190,356 98,799 184,504 (5,852) -3.07% Capital outlays 7030 Equipment - - - 133,708 19,949 92,640 (41,068) -30.71% 7050 Construction - - - 105,000 7,612 57,000 (48,000) -45.71% 7950 Depreciation 251,946 254,991 277,657 255,000 - 270,000 15,000 5.88% Total capital outlays 251,946 254,991 277,657 493,708 27,561 419,640 (74,068) -15.00% Miscellaneous: 9100 Contingency - - - 15,000 - 15,000 - 0.00% 9900 Transfer to Street Fund 100,000 - - 25,000 - - (25,000) -100.00% Total miscellaneous 100,000 - - 40,000 - 15,000 (25,000) -62.50% Total infrastructure & equip maint 902,806 813,342 764,577 1,030,147 330,852 935,737 (94,410) -9.16% 755,734 655,939 4 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance Account Description 2014 2015 2016 2017 Description 1210 Supplies, Bldgs & grounds 100 100 100 100 Mops, buckets, brooms 600 500 500 500 Light tubes & ballasts 200 200 200 200 Paper products 200 200 200 200 Paint, thinner, & brushes 1,000 750 750 750 Black dirt & sod/seed, landscaping materials 500 500 500 500 Misc. cleaners for well houses & % of shop 700 - - - Fertilizer/seed/weed control/goose repellent 500 500 500 500 Irrigation parts 3,800 2,750 2,750 2,750 1220 Supplies, vehicles 300 300 300 300 Air, oil, fuel, & transmission filters 100 100 100 100 Fluids 100 400 400 400 Batteries and tires 50 50 50 50 Paint sealant 150 150 150 150 Tune ups 300 500 500 500 Misc repairs 1,000 1,500 1,500 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 175 175 175 175 Hydraulic fluid: 35 gallons @ $4.80 / gallon 200 200 200 200 Solvents & cleaning fluids 200 200 200 200 Air compressor & dehumidifier parts 1,500 500 500 500 Chemical equipment parts (fluoride pumps) - - - - Locator ($5000 defer to 2018) 4,800 - - - Fluoride tank replacement (3 tanks every 3 years)(2018 next) 250 250 250 250 Air, oil, fuel, & trans filters (emergency generator) 7,425 1,625 1,625 1,625 1240 Supplies, streets 3,000 3,000 3,000 3,000 Asphalt/concrete/sod/seed for patching minor street, curb, driveway repairs. 3,000 3,000 3,000 3,000 1250 Supplies, utilities 500 2,000 2,500 2,500 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 250 1,000 1,000 Hydrant markers - - - 1,050 De-chlorinator 1,500 3,000 3,000 3,450 Hydrant parts (hydrant pump $450 - 2017) 2,000 3,000 3,000 5,000 Meter supplies, etc. (move from account 1600) - - - - Motorized valve exerciser (Hurco Spin Doctor)($4830 defer to 2018) 7,000 10,250 11,500 15,000 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 1,850 Film, first aid supplies, & batteries (add hearing protection) 2,000 2,500 2,500 2,500 Location flags & paint (moved from account 1250) 250 250 250 250 Cleaning supplies 1,000 1,500 1,500 1,500 Additional & replacement hand tools 4,800 5,800 5,800 7,000 1700 Motor fuels & lubs 675 700 650 560 Diesel fuel - 200 gallons @ $2.80 - 450 450 450 Oil 5,200 2,700 2,475 2,990 Unleaded fuel: 1,300 gallons @ $2.30 5,875 3,850 3,575 4,000 2400 Uniforms 1,475 995 1,100 1,100 Uniforms 15.5% of $4,500 and clothing 1.7 FTE x $175 per contract 1,475 995 1,100 1,100 2410 Mats & towels 1,620 775 620 620 Share of floor mats & shop towels (15.5% of $4,000) 1,620 775 620 620 3030 Other professional services 180 180 180 180 Backflow prevention testing (3 @ $60 per test) - - 3,000 - Water system leak survey (every 2 years, next in 2018) - - 11,000 - Production assessment ($312,000 defer to 2018 or later) - 500 500 500 Broadleaf control - 1,000 1,000 1,000 Asset management software 250 250 250 250 Fire sprinkler inspections/testing 200 200 200 200 Fire extinguisher inspection/service (10 @ $20) 2,750 1,500 1,500 1,500 Gopher State One-call locates 2,750 5,000 5,000 5,000 Arcview/GIS base map and engineering consulting 6,130 8,630 22,630 8,630 3100 Communications - telephone 400 400 400 400 Service & repair 1,570 1,505 1,846 1,954 Cellular phone service (20.06% of $9,200) - 720 720 720 Data cards for SCADA (2)(75%) balance in Sewer 90 90 90 90 800 MHz license fee (33%)(5 radios @ $4.48 per month) 2,060 2,715 3,056 3,164 3200 Water and wastewater charges 7,200 7,200 7,200 7,200 7,200 7,200 7,200 7,200 5 THIS PAGE LEFT BLANK INTENTIONALLY 6 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance Account Description 2014 2015 2016 2017 Description 3220 Natural gas 7,000 7,000 7,000 7,500 Heating fuel 7,000 7,000 7,000 7,500 3610 Memberships 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 470 290 290 290 3630 Training 250 250 250 250 Computer training/webinars 1,200 1,200 1,200 1,200 Trench safety/confined space alternate years 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 - - - MN Public Works Assoc workshop 560 560 560 560 Tuition reimbursement 60 60 60 60 Work zone safety seminar (every 3 years) 4,000 3,850 3,850 3,850 4010 Rental, equipment 3,500 4,000 4,000 4,000 Skid steer - upgrade 300 300 300 300 Barricades & signs 200 200 200 200 Tools & equipment 4,000 4,500 4,500 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 2,000 2,000 Door & lock repairs 2,000 1,000 1,000 1,000 Roof & wall repairs 3,000 3,000 3,000 7,540 Electrical & mechanical repairs (well #2 unit heater $4540) 1,000 1,000 1,000 1,000 Site repairs (pavement, fence, irrigation, etc...) 11,000 7,000 7,000 11,540 5120 Repairs, vehicles 1,500 1,000 1,000 1,000 Utility truck repairs 1,500 1,000 1,000 1,000 5130 Repairs, equipment 1,500 1,500 1,500 1,500 Well and water treatment plant repairs 1,500 1,500 1,500 1,500 Miscellaneous repairs (Backhoe, Skid steer) - - - 3,000 Repair boiler @ main plant 3,000 - - - Backhoe tires - - 3,500 3,500 Generator service - Onan - - 2,500 2,500 VFD service 1,500 1,500 1,500 1,500 Meter and valve repairs 2,000 2,000 2,000 2,000 SCADA repairs 100 100 100 100 Radio repairs 9,600 6,600 12,600 15,600 5140 Repairs, streets 10,000 10,000 10,000 10,000 Contractor repairs to streets after water main breaks 10,000 10,000 10,000 10,000 5150 Repairs, utilities 5,000 5,000 5,000 5,000 Fire hydrant repairs 5,000 5,000 5,000 5,000 Gate valve repairs 7,500 7,500 7,500 7,500 Water main repairs 17,500 17,500 17,500 17,500 5155 Water service repairs 50,000 65,000 65,000 65,000 Contractor repairs to residential water services. 15,000 15,000 15,000 15,000 Pavement & curb repairs 65,000 80,000 80,000 80,000 5160 System maintenance 3,500 3,500 3,500 3,500 Water system maintenance & repair items 7,000 - - - Well #4 perimeter fencing ($5000 well #5 fencing defer to 2018) 10,500 3,500 3,500 3,500 7030 Capital, equipment > $5000 15,000 15,000 15,000 15,000 Gate valves - - 31,958 42,640 SCADA system upgrades (automatic controls) - - 35,000 35,000 Booster station (pressure valve) - - 10,000 - Water treatment plant (leaking valve) 14,000 14,000 14,000 - Trench box 2,750 2,750 2,750 - Electric rain gauges SCADA System (33%)(total cost $8,250) 7,500 - - - Chemical feed equipment 25,000 25,000 25,000 - Security cameras & card key access 5,000 - - - Air Compressor (well #5) 72,000 - - - 3/4 ton pick-up 141,250 56,750 133,708 92,640 7050 Construction > $25000 - - 80,000 - Wells #6 building repairs (int. and exterior repairs) - - - 12,000 Well #5 repairs (design in 2017)($90,000 defer to 2018) 350,000 200,000 - - Reservoir & booster station building and roof repairs (carryover from 10,11) - - 25,000 - Water system upgrades wells #1,2 - 60,000 - 45,000 Well pump rehabilitation project (well no. 1) ($60,000 - 2015) 350,000 260,000 105,000 57,000 7 2013 2014 2015 2016 Y-T-D 2017 Change from 2015 Actual Actual Actual Budget 09/30/16 Request Dollar Percent Water (Fund 700): 2017 Budget Summary Water Production (4825): Personnel services 0100 Salaries, regular 361 269 24,576 25,900 18,188 26,548 648 2.50% 0110 Salaries, overtime - - 1,717 - 1,918 - - 0.00% 0300 Social security 26 19 1,760 1,981 1,472 2,031 50 2.52% 0321 PERA 26 19 2,045 1,943 1,421 1,991 48 2.47% 0400 Group insurance 36 41 4,492 4,944 3,690 5,040 96 1.94% 0500 Workers compensation - - 1,688 1,799 1,224 1,398 (401) -22.29% Total personnel services 449 348 36,278 36,567 27,913 37,008 441 1.21% Materials & supplies 1600 Supplies, operating 32,919 27,583 25,855 35,175 20,569 37,775 2,600 7.39% 2400 Uniforms - - - 235 - 235 - 0.00% 2410 Mats & towels - - - 144 - 144 - 0.00% Total materials & supplies 32,919 27,583 25,855 35,554 20,569 38,154 2,600 7.31% Contractual services 3030 Other professional services 24,962 2,155 7,154 24,930 6,800 21,930 (3,000) -12.03% 3210 Electricity 107,531 103,552 101,917 108,000 80,907 108,000 - 0.00% Total contractual services 132,493 105,707 109,071 132,930 87,707 129,930 (3,000) -2.26% Total water production 165,861 133,638 171,204 205,051 136,189 205,092 41 0.02% 168,484 168,084 Total expenditures 1,487,139 1,140,587 1,011,893 1,446,762 521,147 1,355,811 (90,951) -6.29% Revenues over (under) expenditures (572,519) (82,915) (54,757) (390,788) 199,792 (240,935) 149,853 -38.35% Add back: capital outlays - - - 238,708 27,561 149,640 (89,068) -37.31% principal payment on debt 230,000 - - - - - - 0.00% Change in net assets (342,519) (82,915) (54,757) (152,080) 227,353 (91,295) 60,785 -39.97% Net Assets, beginning year 4,418,196 4,075,677 3,992,762 3,741,943 3,741,943 3,589,863 (152,080) -4.06% Accounting Change GASB 68 pension (196,062) Net Assets, end of year 4,075,677$ 3,992,762$ 3,741,943$ 3,589,863$ 3,969,296$ 3,498,568$ (91,295)$ -2.54% 1,081,682 983,537 8 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance 7950 Depreciation 240,000 245,000 255,000 270,000 Estimated depreciation 240,000 245,000 255,000 270,000 9100 Contingency 15,000 15,000 15,000 15,000 Contingency 15,000 15,000 15,000 15,000 9900 Transfers out 85,000 25,000 25,000 - Water system upgrades in conjunction with major roadway program 85,000 25,000 25,000 - 1,033,635 802,510 755,734 655,939 Fund: 700 Department: 4825 Water Production Account Description 2014 2015 2016 2017 Description 1600 Supplies, operating 550 550 550 550 Computer supplies 800 800 800 800 Testing reagents 4,125 4,125 4,125 4,125 Sulfur dioxide: 25 150# cylinders @ $1.10 per pound 8,800 8,800 8,800 10,400 Chlorine: 8 - 1 ton cylinders @ .65 per pound 9,350 9,350 9,350 10,350 75 - 150 # cylinders @ $.92 per pound 7,400 7,400 7,400 7,400 Hydrofluosilic acid: 20,000 pounds @ $0.37 3,300 3,300 3,300 3,300 R-999 Buffer solution 2 - 55 gal drums @ $30 per gal. 850 850 850 850 Sand separator 35,175 35,175 35,175 37,775 1700 Motor fuels & lubs 200 - - - Turbine & electric motor oil 250 - - - Oil for generators 450 - - - 2400 Uniforms - 235 235 235 Uniforms 3.6% of $4,500 and clothing .4 FTE x $175 per contract - 235 235 235 2410 Mats & towels - 180 144 144 Share of floor mats & shop towels (3.6% of $4,000) - 180 144 144 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 10,000 10,000 10,000 7,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 1,050 1,050 1,050 1,050 MCES discharge permits (3*$350) 300 300 300 300 MNDPS - EPCRA program ($100/WTP) 10,000 7,000 7,000 7,000 Well head protection plan (req. by Dept. of Health)(11, 12, 13 Barr Eng.) 27,930 24,930 24,930 21,930 3210 Electricity 95,000 108,000 108,000 108,000 Electricity for wells, tower & reservoir 95,000 108,000 108,000 108,000 158,555 168,520 168,484 168,084 1,340,881 1,120,068 1,081,682 983,537 -0.43%-16.47%-3.43%-9.07% 9 2017 Budget Summary 2013 2014 2015 2016 Y-T-D 2017 Change from 2015 Actual Actual Actual Budget 09/30/16 Request Dollar Percent Sanitary Sewer (Fund 730): Revenues 3551 Spec. Assessments 78 - 13,105 - - - - 0.00% 3610 Investment income (79,782) 128,382 26,380 30,000 1,303 30,000 - 0.00% 3680 Other revenues - 30,000 - - - - - 0.00% 3716 Penalties 7,678 9,117 10,936 6,000 15,534 6,000 - 0.00% 3720 Utility sales 1,227,815 1,301,911 1,375,522 1,410,821 1,096,068 1,501,830 91,009 6.45% 3721 SAC charges (1,753) 13,170 (1,988) - 5,020 - - 0.00% 3725 Utility connections 850 1,200 1,900 - 1,102 - - 0.00% 3726 Penalties & interest 811 603 612 - 825 - - 0.00% 3972 Transfers from Vehicle Fund - - - 83,000 - - (83,000) -100.00% Total revenue 1,155,697 1,484,383 1,426,467 1,529,821 1,119,852 1,537,830 8,009 0.52% Operating expenses Billing Services (4820): Personnel services 0100 Salaries, regular 38,295 40,222 42,139 42,116 31,649 43,167 1,051 2.50% 0300 Social security 2,798 2,911 3,059 3,221 2,311 3,302 81 2.51% 0321 PERA 2,686 2,809 3,042 3,159 2,300 3,238 79 2.50% 0322 GASB 68 Pension expense - - 7,871 - - - - 0.00% 0400 Group insurance 3,701 3,721 3,289 5,128 2,509 5,407 279 5.44% 0500 Workers compensation 233 311 437 476 314 359 (117) -24.58% Total personnel services 47,713 49,974 59,837 54,100 39,083 55,473 1,373 2.54% Materials & supplies 1600 Supplies, operating - - - 50 - 50 - 0.00% Total materials & supplies - - - 50 - 50 - 0.00% Contractual services 3030 Other professional services 6,901 6,780 7,620 7,889 8,008 8,036 147 1.86% 3300 Postage 3,231 3,330 3,430 4,426 1,796 4,352 (74) -1.67% 3430 Printing 801 - 271 900 - 900 - 0.00% 3630 Training - - - 1,500 - 1,500 - 0.00% 5130 Repairs, equipment 3,693 4,017 4,264 4,729 5,223 4,943 214 4.53% Total contractual services 14,626 14,127 15,585 19,444 15,027 19,731 287 1.48% Miscellaneous: 9900 Transfers out to General Fund 53,361 54,962 56,611 58,309 - 60,058 1,749 3.00% 9900 Transfers out to Vehicle Fund 36,000 36,000 53,000 42,000 - 38,000 (4,000) -9.52% Total miscellaneous 89,361 90,962 109,611 100,309 - 98,058 (2,251) -2.24% Total Billing 151,700 155,063 185,033 173,903 54,110 173,312 (591) -0.34% 119,803 117,839 Infrastructure & Equip Maintenance (4823): Personnel services 100 Salaries, regular 167,543 192,664 187,913 203,566 138,975 210,439 6,873 3.38% 110 Salaries, overtime 7,884 7,942 5,326 8,241 4,055 8,447 206 2.50% 150 Salaries, part-time 11,503 - 8,318 11,520 2,813 11,520 - 0.00% 300 Social security 13,641 13,753 14,237 17,085 10,171 17,624 539 3.15% 321 PERA 12,788 13,885 14,010 16,191 10,661 16,723 532 3.29% 400 Group insurance 27,159 30,670 30,258 37,116 24,331 37,998 882 2.38% 500 Workers compensation 5,413 8,245 10,183 10,817 7,349 8,374 (2,443) -22.58% Total personnel services 245,931 267,159 270,245 304,536 198,355 311,125 6,589 2.16% 10 Fund: 730 Department: 4820 Billing Services Account Description 2014 2015 2016 2017 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 825 - - - Inserting & mailing bills (move to 3300) 375 - - - Annual maintenance (moved to 5130) 6,977 7,742 7,889 8,036 24.5% of audit fee (2017 - $32,800, 2018 - $33,400) 8,177 7,742 7,889 8,036 3300 Postage 3,136 3,136 3,136 3,072 3200 bills X $0.48 postage X 4 billings X 1/2 cost - 800 800 800 Inserting & mailing bills (moved from 3030) 460 490 490 480 Late notices: 500 bills X $0.48 postage X 4 billings X 1/2 cost 3,596 4,426 4,426 4,352 3430 Printing 450 450 450 450 Envelopes 450 450 450 450 Utility bills (1/2 cost) 900 900 900 900 3630 Training 1,500 1,500 1,500 1,500 Seminars on new regulations, software updates, etc. INCODE training 1,500 1,500 1,500 1,500 5130 Repairs, equipment 3,506 3,681 3,866 4,060 Incode software support (30%) - 475 475 475 Neptune software maintenance (1/2 in water)(reader) 369 388 388 408 Handheld interface support for meter readers (50% water 50% sewer)(Incode) 3,875 4,544 4,729 4,943 9900 Transfers out 54,962 56,611 58,309 60,058 Transfer to General Fund for admin costs 36,000 53,000 42,000 38,000 Transfer to Vehicle & Equipment Fund for vehicle use 90,962 109,611 100,309 98,058 109,060 128,773 119,803 117,839 11 2017 Budget Summary 2013 2014 2015 2016 Y-T-D 2017 Change from 2015 Actual Actual Actual Budget 09/30/16 Request Dollar Percent Sanitary Sewer (Fund 730): Materials & supplies 1210 Supplies, bldg & grnds 151 - - 200 - 200 - 0.00% 1220 Supplies, vehicles 590 1,872 244 1,575 2,564 1,575 - 0.00% 1230 Supplies, equipment 4,636 7,895 4,963 4,650 2,072 8,350 3,700 79.57% 1240 Supplies, streets - - - 3,000 670 2,500 (500) -16.67% 1250 Supplies, utilities 571 112 904 3,350 163 1,400 (1,950) -58.21% 1260 Supplies, traffic control 447 325 - 300 - 300 - 0.00% 1600 Supplies, operating 12,952 11,944 3,732 14,250 1,147 10,550 (3,700) -25.96% 1700 Motor fuels 4,347 4,789 5,061 4,875 3,648 4,290 (585) -12.00% 2400 Uniforms 1,304 1,168 1,007 1,169 705 1,169 - 0.00% 2410 Mats & towels 642 634 697 728 520 728 - 0.00% Total materials & supplies 25,640 28,739 16,608 34,097 11,489 31,062 (3,035) -8.90% Contractual services 3030 Other professional services 1,263 6,697 1,341 5,700 924 8,200 2,500 43.86% 3100 Communications - telephone 1,659 1,492 1,575 2,115 1,151 2,086 (29) -1.37% 3200 Water & sewer 3,328 3,301 3,335 3,000 2,673 3,300 300 10.00% 3210 Electricity 2,306 2,668 1,923 2,300 1,398 2,100 (200) -8.70% 3230 Wastewater disposal - MCES 816,267 822,568 832,084 892,571 749,859 912,137 19,566 2.19% 3231 Wastewater disposal - Strength c - 5,394 5,157 5,500 - 6,000 500 9.09% 3610 Memberships - 153 - 230 - 230 - 0.00% 3630 Training 2,470 2,258 1,693 4,450 1,853 4,430 (20) -0.45% 4010 Equipment rental - - - 500 308 500 - 0.00% 4800 Insurance 7,951 9,024 7,451 7,300 4,796 7,300 - 0.00% 5130 Repairs, equipment 706 10,899 3,259 8,750 4,746 14,032 5,282 60.37% 5140 Repairs, streets - - - 10,000 141 10,000 - 0.00% 5150 Repairs, utilities 4,065 3,941 719 17,500 13,774 17,500 - 0.00% 5155 Utility service repairs 53,846 10,827 - - - - - 0.00% 5160 Repairs, maintenance 10,893 9,665 2,418 33,500 3,466 13,500 (20,000) -59.70% Total contractual services 904,754 888,887 860,955 993,416 785,089 1,001,315 7,899 0.80% Capital outlays 7030 Equipment - - - 44,750 - - (44,750) -100.00% 7050 Construction - - - 250,000 138,905 150,000 (100,000) -40.00% 7950 Depreciation 166,533 165,752 151,592 167,000 - 153,000 (14,000) -8.38% Total capital outlays 166,533 165,752 151,592 461,750 138,905 303,000 (158,750) -34.38% Miscellaneous: 9100 Contingency - - - 15,000 - 15,000 - 0.00% 9900 Transfer to Street fund 160,000 140,000 140,000 140,000 - - (140,000) -100.00% Total miscellaneous 160,000 140,000 140,000 155,000 - 15,000 (140,000) -90.32% 1,644,263 1,350,377 Total infrastructure & equip maint 1,502,858 1,490,537 1,439,400 1,948,799 1,133,838 1,661,502 (287,297) -14.74% Total expenditures 1,654,558 1,645,600 1,624,433 2,122,702 1,187,948 1,834,814 (287,888) -13.56% Revenues over (under) expenditures (498,861) (161,217) (197,966) (592,881) (68,096) (296,984) 295,897 -49.91% Add back: capital outlays - - - 294,750 138,905 150,000 (144,750) -49.11% Change in net assets (498,861) (161,217) (197,966) (298,131) 70,809 (146,984) 151,147 -50.70% Net Assets, beginning of year 4,914,084 4,415,223 4,254,006 3,872,946 3,872,946 3,574,815 (298,131) -7.70% Accounting Change GASB 68 pension (183,094) Net Asset, end of year 4,415,223$ 4,254,006$ 3,872,946$ 3,574,815$ 3,943,755$ 3,427,831$ 4,163$ 0.12% 1,764,066 1,468,216 12 Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance Account Description 2014 2015 2016 2017 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 2,775 2,775 1,575 1,575 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,500 2,000 2,000 2,000 Camera track and parts (CCTV) 300 300 300 300 Minor repairs 500 100 100 100 Gas detection device parts and supplies 4,000 300 300 4,000 Vactor cleaning nozzle parts and supplies (New Bulldog nozzle 2017) 8,250 4,650 4,650 8,350 1240 Supplies, streets 200 200 200 200 Tack coat 300 300 300 300 Dewatering rock/agg. base 2,500 2,500 2,500 2,000 Asphalt mix 3,000 3,000 3,000 2,500 1250 Supplies, utilities 1,500 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 - - Portable flow meter 750 750 750 300 Manhole covers, adjust rings & bolts 5,850 5,850 3,350 1,400 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 1,500 First aid supplies, protective equip (add hearing equipment for 2017) 400 400 400 400 CD's, DVD's, software 500 250 250 250 Engineering supplies 700 700 700 700 Shop supplies, fastners, soap, degreasers, steet, batteries 500 500 500 500 Pipe, fittings, and accessories (connectors) 2,000 500 500 500 Locating supplies (paint, flags, markers, etc.) 2,000 8,000 10,000 5,000 Chemical blocks for lift stations 500 300 300 300 Filter replacement for sewer gas monitors 8,200 12,250 14,250 10,550 1700 Motor fuels & lubs 300 300 300 300 Fluids 600 600 600 600 Motor oil - 100 gallons $6 gal. 4,000 1,500 1,375 1,150 Unleaded fuel 500 gallons @ $2.30 3,600 2,800 2,600 2,240 Diesel fuel 800 gallons @ $2.80 8,500 5,200 4,875 4,290 2400 Uniforms 1,475 1,169 1,169 1,169 Uniforms 18.2% of $4,500 and clothing 2.0 FTE x $175 per contract 1,475 1,169 1,169 1,169 2410 Mats & towels 1,620 910 728 728 Share of floor mats & shop towels (18.2% of $4,000) 1,620 910 728 728 3030 Other professional services 2,750 1,500 1,500 1,500 Gopher State One Call locates 600 600 600 600 Consulting engineering services - annual lift station inspections 100 100 100 100 Fire extinguisher inspection/servcie (5 @ $20) - 1,000 1,000 1,000 Asset management software 2,500 2,500 2,500 5,000 Arcview/GIS base map and engineering consulting (add comp plan maps 2017 5,950 5,700 5,700 8,200 3100 Communications - telephone 1,570 1,455 1,785 1,785 Cellular phone service (19.4% of $9,200) - 240 240 211 Data cards for SCADA (2)(25%) balance in Water (35.01 per card per month) 90 90 90 90 800 Mhz radio license fee (33%)(5 radios @ $4.48 per month) 1,660 1,785 2,115 2,086 3200 Water & Sewer service 2,600 3,000 3,000 3,300 Estimated annual charge 2,600 3,000 3,000 3,300 3210 Electricity 2,100 2,300 2,300 2,100 Electricity for lift stations 2,100 2,300 2,300 2,100 52,480 49,089 47,212 46,748 13 THIS PAGE LEFT BLANK INTENTIONALLY 14 Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance (continued) Account Description 2014 2015 2016 2017 Description 3230 Met Council Environ. Servies 822,568 832,084 892,571 912,137 Annual charge (1.57% increase for 2017)($76,011.37/mo) - - 5,500 6,000 Strength Charge (new charge from MCES) 822,568 832,084 898,071 918,137 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,500 Collection operators training/renewal ($300 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/trench safety alternate years) 320 - - - Metro school 120 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 60 60 Work zone safety seminar (every 3 years next 2020) 4,770 4,450 4,450 4,430 4010 Rental, equipment 500 500 500 500 Barricades & signs 500 500 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 - Repairs to motors & pumps (in 5150) - - - 7,782 Move omni antenna at groveland lift station 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 14,032 5140 Repairs, streets - 10,000 10,000 10,000 Contractor restoration of pavement, bwd., etc... - 10,000 10,000 10,000 5150 Repairs, utilities 2,500 2,500 2,500 2,500 Lift station repairs - 15,000 15,000 15,000 Sanitary collection system repairs 2,500 17,500 17,500 17,500 5160 System maintenance 15,000 - - - Sanitary collection system repairs 25,000 25,000 25,000 5,000 Root control 15,000 - - - Contractor restoration of pavement, bwd., etc... 4,500 4,500 4,500 4,500 Lift station maintenance/cleaning/pump service 4,000 4,000 4,000 4,000 Sewer debris disposal costs 63,500 33,500 33,500 13,500 7030 Capital, equipment > $5000 30,000 - - - Generator - trailer mounted (carryover) - - 30,000 - Generator - Bronson (natural gas)(New to replace mobile generator) 2,750 2,750 2,750 - Electronic rain gauges for SCADA (33%)(total cost $8,250) 12,000 12,000 12,000 - Grinder station for Bronson lift station 3,000 - - - Camera Cable (Sewer & Storm Water) 47,750 14,750 44,750 - 7050 Construction > $25000 250,000 250,000 250,000 150,000 Sewer pipe relining program - 350,000 - - Groveland lift station rehabilitation (with area H project) 250,000 600,000 250,000 150,000 7950 Depreciation 167,000 167,000 167,000 153,000 Estimated depreciation 167,000 167,000 167,000 153,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 140,000 140,000 140,000 - Sewer system upgrades in conjunction with major roadway program 140,000 140,000 140,000 - 1,529,868 1,851,064 1,597,051 1,303,629 15 2013 2014 2015 2016 Y-T-D 2017 Change from 2015 Actual Actual Actual Budget 09/30/16 Request Dollar Percent Street Lighting (Fund 740): Revenues 3610 Investment income (3,218) 5,251 1,250 1,300 62 1,300 - 0.00% 3716 Penalties 679 603 719 500 922 500 - 0.00% 3740 Street lighting charges 81,946 87,449 90,844 97,290 72,405 103,902 6,612 6.80% Total revenue 79,407 93,303 92,813 99,090 73,389 105,702 6,612 6.67% Operating expenses Operations (4416) Personnel services 0100 Salaries, regular 2,617 2,768 8,430 6,600 4,949 6,765 165 2.50% 0110 Salaries, overtime - - 115 - 77 - - 0.00% 0300 Social security 189 189 487 505 360 518 13 2.57% 0321 PERA 198 202 504 424 375 434 10 2.36% 0400 Group insurance 575 588 1,133 618 879 630 12 1.94% 0500 Workers compensation 19 22 346 313 240 294 (19) -6.07% Total personnel services 3,598 3,769 11,015 8,460 6,880 8,641 181 2.14% Materials & supplies 1600 Supplies, operating - - - 1,000 25 1,000 - 0.00% Contractual services 3030 Other professional services - - 796 - 35 - - 0.00% 3210 Electricity 87,326 62,996 73,907 78,000 45,060 70,000 (8,000) -10.26% 4800 Insurance 618 594 604 900 591 900 - 0.00% 5150 Repairs, utilities 5,032 1,409 698 3,000 - 3,000 - 0.00% 5160 Repairs, system maintenance - - 93,208 - - - - 0.00% Total contractual services 92,976 64,999 169,213 81,900 45,686 73,900 (8,000) -9.77% Other 8011 Lease payable - principal (ESP)- - 2,335 9,556 5,038 6,924 (2,632) -27.54% 8021 Lease payable - interest (ESP)- - - - 1,901 2,329 2,329 #DIV/0! 9900 Transfer to General Fund 2,390 2,462 2,536 2,612 - 2,690 78 2.99% Total other 2,390 2,462 4,871 12,168 6,939 11,943 (225) -1.85% Total expenditures 98,964 71,230 185,099 103,528 59,530 95,484 (8,044) -7.77% Revenues over (under) expenditures (19,557) 22,073 (92,286) (4,438) 13,859 10,218 14,656 -330.24% Add back: Capital outlays/Prin on debt - - - 9,556 5,038 6,924 (2,632) -27.54% Change in net assets (19,557) 22,073 (92,286) 5,118 18,897 17,142 12,024 234.94% Net assets, beginning year 134,906 115,349 137,422 45,136 45,136 50,254 5,118 11.34% Net assets, end of year 115,349$ 137,422$ 45,136$ 50,254$ 64,033$ 67,396$ 17,142$ 34.11% 95,068 86,843 2017 Budget Summary 16 Fund: 740 Street Lighting Fund Revenues Account Description 2014 2015 2016 2017 Description 3610 Interest revenue 1,300 1,300 1,300 1,300 Estimated interest earnings at 1%. 1,300 1,300 1,300 1,300 3716 Penalties 500 500 500 500 Estimated late fees on street lighting charges. 500 500 500 500 3740 Street lighting charges 88,364 91,567 97,290 103,902 Estimated utility charges for street lighting. 88,364 91,567 97,290 103,902 Fund: 740 Department: 4416 Operations 1600 Supplies, operating 1,000 1,000 1,000 1,000 Bulbs, ballasts, covers, etc... 1,000 1,000 1,000 1,000 3210 Electricity 83,000 90,000 78,000 70,000 Estimate 83,000 90,000 78,000 70,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 8011 Lease payable (principal)- - 9,556 6,924 Energy savings program (LED trail lighting) 8021 Lease payable (interest)- - - 2,329 Interest - - 9,556 9,253 9900 Transfer out 2,462 2,536 2,612 2,690 Transfer to General Fund for administrative overhead costs 2,462 2,536 2,612 2,690 90,362 97,436 95,068 86,843 1.20%7.83%-2.43%-8.65% 17 2017 Budget Summary 2013 2014 2015 2016 Y-T-D 2017 Change from 2015 Actual Actual Actual Budget 09/30/16 Request Dollar Percent Storm Water (Fund 745): Revenues 3610 Investment income (charges)(51,529) 85,811 18,137 15,000 897 15,000 - 0.00% 3716 Penalties & interest 2,215 1,706 1,990 - 2,467 1,500 1,500 #DIV/0! 3718 Impact charges - - 848 - 848 - - 0.00% 3730 Surface water charges 266,372 276,652 263,254 270,000 199,378 270,000 - 0.00% 3972 Transfer from other funds - - 210,000 - - - - 0.00% Total revenue 217,058 364,169 494,229 285,000 203,590 286,500 1,500 0.53% Operating expenses System Maintenance (4415): Personnel services 0100 Salaries, regular 53,978 61,400 70,056 71,821 54,071 74,708 2,887 4.02% 0110 Salaries, overtime 3,198 6,511 1,975 1,236 1,431 1,267 31 2.51% 0150 Salaries, part-time 6,139 5,910 5,452 2,640 3,872 2,640 - 0.00% 0300 Social security 4,682 5,553 5,629 5,792 4,407 6,014 222 3.83% 0321 PERA 3,589 4,780 5,109 5,479 4,046 5,697 218 3.98% 0322 GASB 68 Pension expens - - 2,648 - - - - 0.00% 0400 Group insurance 2,864 3,750 5,137 12,972 4,438 13,248 276 2.13% 0500 Workers compensation 3,748 5,608 6,652 7,062 2,495 2,851 (4,211) -59.63% Total personnel services 78,198 93,512 102,658 107,002 74,760 106,425 (577) -0.54% Materials & supplies 1230 Supplies, equipment 7,106 1,201 1,382 3,250 867 2,750 (500) -15.38% 1240 Supplies, streets - - - 300 - - (300) -100.00% 1600 Supplies, operating 2,741 3,297 3,478 6,725 888 4,725 (2,000) -29.74% 1700 Motor fuels 3,078 3,901 3,382 2,475 1,508 2,070 (405) -16.36% 2100 Books/Periodicals - 39 - 100 - - (100) -100.00% 2400 Uniforms 768 393 577 470 326 470 - 0.00% 2410 Mats & towels 321 285 293 292 218 292 - 0.00% Total materials & supplies 14,014 9,116 9,112 13,612 3,807 10,307 (3,305) -24.28% Contractual services 3030 Other professional services 6,482 17,537 4,475 12,227 4,228 29,748 17,521 143.30% 3100 Telephone 697 645 949 872 509 872 - 0.00% 3610 Memberships 937 345 950 1,035 955 1,045 10 0.97% 3630 Training 368 1,534 697 2,445 345 1,695 (750) -30.67% 4010 Equipment rental - - - 6,000 - 6,000 - 0.00% 4800 Insurance 3,559 4,027 5,613 4,000 2,628 4,000 - 0.00% 5120 Repairs, vehicles 1,624 192 46 1,500 535 1,500 - 0.00% 5150 Repairs, utilities - 50,366 8,132 44,000 4,646 55,000 11,000 25.00% Total contractual services 13,667 74,646 20,862 72,079 13,846 99,860 27,781 38.54% Capital outlays 7030 Equipment - - - 15,725 - - (15,725) -100.00% 7050 Construction - - - 75,000 - 75,000 - 0.00% 7950 Depreciation 30,708 32,503 44,623 32,000 - 32,000 - 0.00% Total capital outlays 30,708 32,503 44,623 122,725 - 107,000 (15,725) -12.81% Miscellaneous: 9900 Transfer out 46,959 82,168 82,383 82,604 - 7,832 (74,772) -90.52% Total miscellaneous 46,959 82,168 82,383 82,604 - 7,832 (74,772) -90.52% Total System Maintenance 183,546 291,945 259,638 398,022 92,413 331,424 (66,598) -16.73% 291,020 224,999 0.00% 18 Fund: 745 Storm Water Revenues Account Description 2014 2015 2016 2017 Description 3610 Interest revenue 22,000 15,000 15,000 15,000 Estimated interest earnings at 1%. 22,000 15,000 15,000 15,000 3716 Penalties - - - 1,500 Estimated late payment fees. - - - 1,500 3730 Utility sales 265,000 265,000 270,000 270,000 Estimated surface water charges. 265,000 265,000 270,000 270,000 3972 Transfers - Vehicle & equip Fd - 210,000 - - Transfer for capital equipment purchases - 210,000 - - Fund: 745 Department: 4415 System Maintenance 1230 Supplies, equipment < $5000 1,500 1,500 1,500 1,500 Miscellaneous equipment & parts (AEBI parts, pole camera parts) 1,250 1,250 1,250 1,000 Filters, brakes, bulbs, wipers, tires, batteries, etc... 500 500 500 250 Hoses & nozzles 3,250 3,250 3,250 2,750 1240 Supplies, streets 300 300 300 - Bituminous mix 300 300 300 - 1600 Supplies, operating 250 250 250 250 Concrete 2,450 2,450 3,500 2,000 Rain Garden mix, riprap, topsoil, seed and sod 175 175 175 175 Concrete adjustment rings 150 150 150 150 Hand tools 150 150 150 150 CD's, DVD's, software upgrade for camera van 2,500 2,500 2,500 2,000 Catch basin castings, pipe, approns, etc... 5,675 5,675 6,725 4,725 1700 Motor fuels 1,350 - - - 300 gallons diesel fuel @ $3.75 / gallon for Vactor 2,000 2,700 2,475 2,070 900 gallons unleaded @ $2.30 for utility truck 3,350 2,700 2,475 2,070 2100 Books/Periodicals 100 100 100 - Storm water books/periodicals 100 100 100 - 2400 Uniforms 740 470 470 470 Uniforms/clothing (7.3% of $4,500, .8 FTE x $175 per contract) 740 470 470 470 2410 Mats & towels 810 365 292 292 Share of floor mats & shop towels (7.3% of $4,000) 810 365 292 292 3030 Other professional services 7,500 7,500 7,500 25,000 Consulting engineers (SWPPP, comp plan, Proj Priority list) 2,500 2,500 2,500 2,500 Arcview/GIS base map consulting 12,500 - - - Silverview pond sediment removal - 1,000 1,000 1,000 Asset management software 100 100 100 100 Fire extinguisher inspection/servcie (5 @ $20) 775 1,106 1,127 1,148 Audit fees 3.5% (2017 - $32,800, 2018 - $33,400) 23,375 12,206 12,227 29,748 3100 Communications 690 635 782 782 Cell Phone (8.5% of $9,200) 90 90 90 90 800 Mhz radio license fee (33%)(5 radios @ $4.48 per month) 780 725 872 872 3610 Memberships 180 190 190 200 American Public Works Association (APWA)(25% of $800) 750 800 800 800 Minnesota Cities Storm Water Coalition 45 45 45 45 MN Safety Council (11% of $405) 975 1,035 1,035 1,045 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 500 500 500 NPDES compliance training 1,250 750 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 2,445 2,445 1,695 4010 Equipment rental - - 6,000 6,000 Rent mini excavater for clean-outs - - 6,000 6,000 4800 Insurance 2,500 2,500 2,500 2,500 Share of property/liability insurance 1,500 1,500 1,500 1,500 Deductible 4,000 4,000 4,000 4,000 5120 Repairs, vehicles 1,500 1,500 1,500 1,500 Utility truck & equipment repairs 1,500 1,500 1,500 1,500 5150 Repairs & maint., utilities 25,000 50,000 44,000 30,000 Repair & maintain storm sewers, ponds, basins, and drainage issues - - - 25,000 Storm Sewer slip linning improvements 25,000 50,000 44,000 55,000 7030 Equipment > $5000 - - 12,975 - Trailer for backhoe 3,000 - - - Camera Cable (Sewer & Storm Water) 12,000 - - - Flail mower for AEBI 2,750 2,750 2,750 - Electronic rain gauges for SCADA (33%)(total cost $8,250) 17,750 2,750 15,725 - 19 2017 Budget Summary 2013 2014 2015 2016 Y-T-D 2017 Change from 2015 Actual Actual Actual Budget 09/30/16 Request Dollar Percent Storm Water (Fund 745): Street Sweeping (4417): Personnel services 0100 Salaries, regular 7,588 8,695 11,787 11,427 8,762 11,713 286 2.50% 0110 Salaries, overtime 304 306 394 1,236 312 1,267 31 2.51% 0300 Social security 547 637 904 969 672 993 24 2.48% 0321 PERA 525 642 885 950 658 973 23 2.42% 0400 Group insurance 914 1,220 936 2,256 716 2,304 48 2.13% 0500 Workers compensation 616 929 1,623 1,726 598 683 (1,043) -60.43% Total personnel services 10,494 12,429 16,529 18,564 11,718 17,933 (631) -3.40% Materials & supplies 1230 Supplies, equipment 3,869 2,129 1,131 2,500 749 2,500 - 0.00% 1600 Supplies, operating 2,608 2,002 2,939 3,500 14 3,500 - 0.00% 1700 Motor fuels 2,755 4,124 2,841 4,250 1,980 3,800 (450) -10.59% 2400 Uniforms 79 60 52 116 41 116 - 0.00% 2410 Mats & towels 51 44 44 72 33 72 - 0.00% Total materials & supplies 9,362 8,359 7,007 10,438 2,817 9,988 (450) -4.31% Contractual services 3030 Other professional services 4 4 4 6 - 0.00% 3530 Disposal - - - 50,000 - 50,000 - 0.00% 3630 Training 40 11 6 280 11 280 - 0.00% 5130 Repairs, equipment 1,395 - 141 4,000 - 4,000 - 0.00% Total contractual services 1,439 15 151 54,280 17 54,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 71,000 32,000 - 32,000 - 0.00% Total miscellaneous 16,000 16,000 71,000 32,000 - 32,000 - 0.00% Total street sweeping 37,295 36,803 94,687 115,282 14,552 114,201 (1,081) -0.94% 96,718 96,268 Total expenditures 220,841 328,748 354,325 513,304 106,965 445,625 (67,679) -13.18% Revenues over expenditures (3,783) 35,421 139,904 (228,304) 96,625 (159,125) 69,179 -30.30% Add back: Capital outlays - - - 90,725 - 75,000 (15,725) -17.33% Change in net asssets (3,783) 35,421 139,904 (137,579) 96,625 (84,125) 53,454 -38.85% Net assets, beginning year 3,059,703 3,055,920 3,091,341 3,167,772 3,167,772 3,030,193 (137,579) -4.34% Accounting Change GASB 68 pension (63,473) Net assets, end of year 3,055,920$ 3,091,341$ 3,167,772$ 3,030,193$ 3,264,397$ 2,946,068$ (84,125)$ -2.78% 387,738 321,267 20 Fund: 745 Department: 4415 System Maintenance 7050 Construction > $25000 - - 50,000 - 2255 Lambert (pipe ditch)(possible matching grant from Rice Creek WSD) 75,000 75,000 - - Mustang Drive improvements 50,000 25,000 25,000 75,000 Storm water projects (Weir at Silverview Pond) 125,000 100,000 75,000 75,000 7950 Depreciation 32,000 32,000 32,000 32,000 Estimated depreciation 32,000 32,000 32,000 32,000 9900 Transfer out 75,000 75,000 75,000 - Storm water system upgrades in conjunction with major roadway program 7,168 7,383 7,604 7,832 General Fund 82,168 82,383 82,604 7,832 329,968 301,904 291,020 224,999 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,500 3,500 3,250 2,800 Diesel fuel - 1000 gallons @ $2.80/gallon 150 1,000 1,000 1,000 Hydraulic oil - 4 changes 4,650 4,500 4,250 3,800 2400 Uniforms 115 116 116 116 Uniforms/clothing (1.8% of $4,500, .2 FTE x $175 per contract) 115 116 116 116 2410 Mats & towels 110 90 72 72 Share of floor mats & shop towels (1.8% of $4,000) 110 90 72 72 3530 Disposal 5,000 5,000 50,000 50,000 Sweeping pile disposal (estimated 5 year project) 5,000 5,000 50,000 50,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 Sweeper repairs 4,000 4,000 4,000 4,000 7030 Equipment > $5000 - 210,000 - - Street sweeper (250,000 - trade-in of 40,000) - 210,000 - - 9900 Transfer out to Vehicle & Equip 16,000 71,000 32,000 32,000 Transfer to Vehicle & Equip Fund for future replacements 16,000 71,000 32,000 32,000 36,155 300,986 96,718 96,268 366,123 602,890 387,738 321,267 24.29%64.67%-35.69%-17.14% 21 THIS PAGE LEFT BLANK INTENTIONALLY 22 CITY OF MOUNDS VIEW, MINNESOTA Special Revenue Funds 2017 Budgets Combining Statement of Revenues and Expenditures and Net Changes in Fund Balances Cable Community Lakeside Recycling TIF TV Forfeiture EDA Center Park Grant District #5 2017 2016 Revenues: Taxes 126,000 - 100,000 - - - 1,555,982 1,781,982 1,677,982 Intergovernmental: County grants - - - - - 30,220 - 30,220 30,220 Other local govt.- - - - 23,000 - - 23,000 23,000 Charges for services: Culture and recreation - - - 242,780 - - - 242,780 234,680 Miscellaneous: Fines - 5,500 - - - - - 5,500 5,500 Investment income - - - 1,000 300 - 3,000 4,300 5,300 Other - - - - 250 - - 250 2,650 Total revenues 126,000 5,500 100,000 243,780 23,550 30,220 1,558,982 2,088,032 1,979,332 Expenditures: Public safety Supplies - 17,200 - - - - - 17,200 19,500 Contractual services - 1,500 - - - - - 1,500 1,500 Capital outlay - - - - - - - - 25,000 Sanitation Personal services - - - - - 13,800 - 13,800 13,469 Supplies - - - - - 500 - 500 1,000 Contractual services - - - - - 15,920 - 15,920 15,751 Culture and recreation: Personal services 91,057 - - 62,533 4,009 - - 157,599 154,075 Supplies 4,250 - - 15,670 2,600 - - 22,520 21,670 Contractual services 46,028 - - 305,400 16,941 - - 368,369 362,751 Capital outlay 10,000 - - - - - - 10,000 8,832 Debt Service - - - 53,120 - - - 53,120 44,156 Economic development Personal services - - 105,517 - - - - 105,517 103,091 Supplies - - 700 - - - - 700 330 Contractual services - - 69,114 - - - 1,483,243 1,552,357 1,458,200 Capital outlay - - 50,000 - - - - 50,000 - Total expenditures 151,335 18,700 225,331 436,723 23,550 30,220 1,483,243 2,369,102 2,229,325 Surplus of revenues over (under) expenditures (25,335) (13,200) (125,331) (192,943) - - 75,739 (281,070) (249,993) Other financing sources (uses) Transfers in - - 125,331 175,000 - - - 300,331 295,331 Transfers out - - - - - - (77,799) (77,799) (75,331) Total other financing sources (uses)- - 125,331 175,000 - - (77,799) 222,532 220,000 Net change in fund balance (25,335) (13,200) - (17,943) - - (2,060) (58,538) (29,993) Fund balance, January 1:331,480 6,776 48,048 99,774 3,802 21,569 787,466 1,298,915 1,279,906 Fund balance, December 31 306,145 (6,424) 48,048 81,830 3,802 21,569 785,406 1,240,376 1,249,913 Total 23 2017 Budget Summary Y-T-D 2013 2014 2015 2016 09/30/16 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Cable TV (Fund 210): Revenues 3180 Franchise fee 122,921 126,980 126,182 122,000 65,151 126,000 4,000 3.28% 3680 Other revenue 3,750 2,400 2,400 2,400 1,200 - (2,400) -100.00% Total revenue 126,671 129,380 128,582 124,400 66,351 126,000 1,600 1.29% Operating expenses Operations (4350) Personnel services 0100 Salaries, regular 62,331 63,790 65,002 66,502 45,936 68,174 1,672 2.51% 0300 Social security 4,631 4,697 4,813 5,087 3,382 5,215 128 2.52% 0321 PERA 4,496 4,599 4,850 4,988 3,409 5,113 125 2.51% 0400 Group insurance 10,073 10,570 10,747 11,718 8,313 12,096 378 3.23% 0500 Workers compensation 253 379 508 508 399 459 (49) -9.65% 0600 Unemployment - - - - - - 0.00% Total personnel services 81,784 84,035 85,920 88,803 61,439 91,057 2,254 2.54% Materials & supplies 1230 Supplies, equipment - 1,097 428 3,000 - 3,000 - 0.00% 1600 Supplies, operating - 863 - 1,500 - 1,250 (250) -16.67% Total materials & supplies - 1,960 428 4,500 - 4,250 (250) -5.56% Contractual services 3030 Other professional services 3,672 3,942 3,900 7,200 2,857 6,000 (1,200) -16.67% 3630 Training & conferences - 675 200 350 310 350 - 0.00% 3800 Mileage & parking 24 65 8 50 3 50 - 0.00% 3900 Grants & subsidies 27,658 28,390 28,560 29,826 28,765 29,628 (198) -0.66% 5130 Repairs, equipment - - - 10,000 - 10,000 - 0.00% Total contractual services 31,354 33,072 32,668 47,426 31,935 46,028 (1,398) -2.95% Capital 7030 Equipment - - - - - 10,000 10,000 #DIV/0! Total capital outlays - - - - - 10,000 10,000 #DIV/0! Total expenditures 113,138 119,067 119,016 140,729 93,374 151,335 10,606 7.54% Net change in fund balance 13,533 10,313 9,566 (16,329) (27,023) (25,335) (9,006) 55.15% Fund balance, beginning year 314,397 327,930 338,243 347,809 347,809 331,480 (16,329) -4.69% Fund balance, end of year 327,930$ 338,243$ 347,809$ 331,480$ 320,786$ 306,145$ (25,335)$ -7.64% 51,926 60,278 24 Fund: 210 Cable TV Revenues Account Description 2014 2015 2016 2017 Description 3180 Franchise fee revenue 116,000 118,000 122,000 124,000 Estimated collections 116,000 118,000 122,000 124,000 3680 Other revenue 2,400 2,400 2,400 - Lease revenue from Library fiber connection 2,400 2,400 2,400 - Fund: 210 Department: 4350 Operations 1230 Supplies, equipment < $5000 2,000 3,000 3,000 3,000 Equipment costing less than $5,000 per item 2,000 3,000 3,000 3,000 1600 Supplies, operating 1,000 1,250 1,250 1,000 Recording media - tapes, DVD's 250 250 250 250 Batteries, cables, bulbs, tapes, misc 1,250 1,500 1,500 1,250 3030 Other professional services 4,800 7,200 7,200 6,000 Web streaming meetings $500 per month. 4,800 7,200 7,200 6,000 3630 Training & conferences 300 300 350 350 Attendance at local training 400 - - - NATOA National Conference (local no travel) 700 300 350 350 3800 Mileage & parking 50 50 50 50 Mileage 50 50 50 50 3900 Grants & subsidies 29,083 29,241 29,826 29,628 Share of costs of North Suburban Cable Commission 29,083 29,241 29,826 29,628 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 - - - 10,000 Supplemental duct work/air conditioning - - - - Video Camera ($6,000 - $9,000) - - - - Editing Computer - ($8,600) - - - - Automation and control ($36,000) - - - - Control room/Council chambers replacement ($150,000 - $225,000) - - - 10,000 47,883 51,291 51,926 60,278 4.39%7.12%1.24%16.08% 25 2017 Budget Summary Y-T-D 2013 2014 2015 2016 09/30/16 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Forfeiture (Fund 225): Revenues 3510 Ramsey Co Municipal Court - 1,680 1,080 - - - - #DIV/0! 3514 Forfeitures 27,457 26,813 12,668 5,500 2,520 5,500 - 0.00% Total revenue 27,457 28,493 13,748 5,500 2,520 5,500 - 0.00% Operating expenses (4200): Materials & supplies 1230 Supplies, equipment 1,079 8,305 5,209 19,000 5,985 16,700 (2,300) -12.11% 1600 Supplies, operating 795 9,220 151 500 172 500 - 0.00% Total materials & supplies 1,874 17,525 5,360 19,500 6,157 17,200 (2,300) -11.79% Contractual services 3030 Other professional services 7,976 2,450 4,920 1,500 1,289 1,500 - 0.00% Total contractual services 7,976 2,450 4,920 1,500 1,289 1,500 - 0.00% Capital 7030 Equipment - 12,914 10,240 25,000 10,750 - (25,000) -100.00% Total capital outlays - 12,914 10,240 25,000 10,750 - (25,000) -100.00% Total expenses 9,850 32,889 20,520 46,000 18,196 18,700 (27,300) -59.35% Net change in fund balance 17,607 (4,396) (6,772) (40,500) (15,676) (13,200) 27,300 -67.41% Fund balance, beginning year 40,837 58,444 54,048 47,276 47,276 6,776 (40,500) -85.67% Fund balance, end of year 58,444 54,048 47,276 6,776 31,600 (6,424) (13,200) -194.80% 26 Fund: 225 Forfeiture Revenues Account Description 2014 2015 2016 2017 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 1,000 6,000 7,000 (6) Body cameras and storage system $1,000 each, $1,000 storage - - 2,000 - K-9 additional vehicle set-up costs 950 - - - Gun clearing safety device - 900 900 1,000 Long rifle 2,500 - 4,600 4,700 (2) Ballistic shields 1,000 1,500 1,500 1,000 Replacement Glock pistols (5) with trade-in 2,700 2,900 2,900 3,000 Radar 12,250 7,400 19,000 16,700 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 10,000 - (2) In-squad cameras - 15,000 15,000 - Stationary radar sign for County Rd I (Pinewood school) - 25,000 25,000 - 14,250 34,400 46,000 18,700 56.59%141.40%33.72%-59.35% 27 Y-T-D 2013 2014 2015 2016 09/30/16 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent EDA (Fund 230): Revenues 3101 Tax collections - - - - - 100,000 100,000 #DIV/0! 3610 Investment income 4 4 - - - - - 0.00% 3615 Interest received on notes 439 546 515 - - - - 0.00% 3680 Other revenue 5,988 5,547 - - - - - 0.00% 3972 Transfers 119,870 85,428 97,140 125,331 - 125,331 - 0.00% Total revenue 126,301 91,525 97,655 125,331 - 225,331 100,000 79.79% Operating expenses Economic Development (4650): Personnel services 0100 Salaries, regular 74,095 29,785 7,155 77,652 5,063 79,585 1,933 2.49% 0150 Salaries, part-time - 12,614 49,964 - 36,758 - - 0.00% 0300 Social security 5,601 3,133 4,302 5,941 3,132 6,088 147 2.47% 0321 PERA 5,319 3,020 4,272 5,824 3,125 5,969 145 2.49% 0400 Group insurance 10,991 4,272 9,705 12,838 7,359 13,345 507 3.95% 0500 Workers compensation 435 513 626 836 465 530 (306) -36.60% Total personnel services 96,441 53,337 76,024 103,091 55,902 105,517 2,426 2.35% Materials & supplies 1600 Supplies, operating 11 - - 100 - 500 400 400.00% 2100 Book & periodicals 249 278 - 230 139 200 (30) -13.04% Total materials & supplies 260 278 - 330 139 700 370 112.12% Contractual services 3030 Other professional services 19,059 28,844 19,978 17,610 9,915 34,240 16,630 94.43% 3420 Advertisements 1,635 898 - - - 1,500 1,500 #DIV/0! 3430 Printing 9 - - 600 300 500 (100) -16.67% 3610 Memberships 4,751 3,501 510 710 987 710 - 0.00% 3630 Training & conferences 518 1,055 1,354 1,991 - 3,410 1,419 71.27% 3800 Mileage 27 25 316 350 426 350 - 0.00% 4800 Insurance 3,158 3,037 435 649 - 649 - 0.00% 5210 Housing replacement 1,030 144 144 - - - 0.00% 5220 Highway 10 redevelopment - - - - 27,755 27,755 #DIV/0! Total contractual services 30,187 37,504 22,737 21,910 11,628 69,114 47,204 215.45% Capital outlays 9300 Business subsidies - - - - - 50,000 50,000 #DIV/0! Total expenditures 126,888 91,119 98,761 125,331 67,669 225,331 100,000 79.79% Net change in fund balance (587) 406 (1,106) - (67,669) - - 0.00% Fund balance, beginning year 49,335 48,748 49,154 48,048 48,048 48,048 - 0.00% Fund balance, end of year 48,748 49,154 48,048 48,048 (19,621) 48,048 - 0.00% 2017 Budget Summary 28 Fund: 230 EDA Revenues Account Description 2014 2015 2016 2017 Description 3101 Tax revenue - - - 100,000 EDA/HRA Levy - - - 100,000 3972 Transfers 268,636 81,820 75,331 75,331 Transfers from TIF 5 - 10,000 50,000 50,000 Transfers from General Fund 268,636 91,820 125,331 125,331 225,331 Fund: 230 Department: 4650 Economic Development 1600 Supplies, operating 100 100 100 500 Misc office supplies 100 100 100 500 2100 Books & periodicals 30 - - - LMC directory 230 230 230 200 Misc. reports & periodicals (Finance & Commerce) 260 230 230 200 3030 Other professional services 6,500 - - 4,000 Legal fees for development reviews 11,000 - - 5,000 Financial consultant fees (Ehlers) 24,000 - 4,500 14,500 Special project consultant fees 4,500 - - - Appraisal and environmental fees 4,650 1,580 1,610 1,640 5% audit fee (reduced from 15%)(2016-$32,200, 2017-$32,800) 12,750 11,500 11,500 2,100 Housing Resource Center fees (reduced to $2,000 in 2016) 10,000 - - 7,000 Marketing Consultant fees 73,400 13,080 17,610 34,240 3420 Advertising 1,500 - - 1,500 Targeted advertisements. 1,500 - - 1,500 3430 Printing 500 500 500 400 Property ad printing 200 - - - Stationary/business cards/signs/site info 300 100 100 100 Misc printing 1,000 600 600 500 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 60 MN Assoc. of Govt. Communicators (MAGC) 225 - - - Urban Land Institute 2,801 - - - North Metro Mayors Assoc (all in General Fund for 2015) 3,736 710 710 710 3630 Training & conferences 300 - - - Chamber of Commerce meetings 650 - - - DEED/ EDC training 300 - - - EDAM monthly meetings - - 535 535 IEDC Conference Minneapolis - - 275 275 Ehlers Finance Seminar 600 600 600 600 EDAM summer conference 455 400 581 2,000 Other miscellaneous training 2,305 1,000 1,991 3,410 3800 Mileage 100 100 350 350 Misc. mileage 4800 Insurance 4,600 649 649 649 Allocation of the City's property & liability insurance (moved to Central Serv) 4,600 649 649 649 5210 Housing programs 50,000 - - - Housing Improvement programs 50,000 - - - 5220 Highway 10 redevelopment - - - 27,455 Trailways & lighting in highway corridor, Gateway Signage - - - 27,455 9300 Business loans/subsidies 50,000 - - 50,000 Business improvement partnership loans/subsidies 50,000 - - 50,000 187,001 16,469 22,240 119,514 29 THIS PAGE LEFT BLANK INTENTIONALLY 30 2017 Budget Summary Y-T-D 2013 2014 2015 2016 09/30/16 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Community Center (Fund 252): Building overhead (4350) Building overhead revenues 144,145 166,478 709,349 171,000 80 176,000 - 0.00% Building overhead expenditure - - 579,183 52,988 55,165 53,120 132 0.25% Net Building Overhead Operations 144,145 166,478 130,166 118,012 (55,085) 122,880 (132) -0.11% Banquet Center (4730): Banquet revenues 106,421 94,423 88,935 88,000 66,244 91,000 3,000 3.41% Banquet Center expenditures 127,496 131,664 120,327 112,727 82,065 117,914 5,186 4.60% Net Banquet Center (21,075) (37,241) (31,392) (24,727) (15,821) (26,914) (2,186) 8.84% YMCA (4732): YMCA revenues 61,138 70,463 81,812 52,600 37,342 57,700 5,100 9.70% YMCA expenditures 215,785 228,783 240,024 223,673 166,346 228,058 4,385 1.96% Net YMCA (154,647) (158,320) (158,212) (171,073) (129,004) (170,358) 715 -0.42% Office/Chamber space (4734): Office/Chamber revenues 3,495 2,000 7,450 8,198 6,450 8,198 - 0.00% Office/Chamber expenditures 5,733 6,003 6,135 4,634 3,385 4,706 36 0.77% Net Office/Chamber space (2,238) (4,003) 1,315 3,564 3,065 3,492 (36) -1.01% Creative Kids Child Care Center (4736): Creative Kids revenues 81,730 83,135 84,854 85,882 64,226 85,882 - 0.00% Creative Kids expenditures 40,128 41,356 40,236 33,183 25,223 32,926 (257) -0.77% Net Creative Kids 41,602 41,779 44,618 52,699 39,003 52,956 257 0.49% Total revenue 396,929 416,499 972,400 405,680 174,342 418,780 8,100 2.00% Total expenditures 389,142 407,806 985,905 427,205 332,184 436,723 9,482 2.22% Net change in fund balance 7,787 8,693 (13,505) (21,525) (157,842) (17,943) (1,382) 6.42% Fund balance, beginning year 118,324 126,111 134,804 121,299 121,299 99,774 (21,525) -17.75% Fund balance, end of year 126,111 134,804 121,299 99,774 (36,543) 81,830 (17,943) -17.98% (continued) 31 2017 Budget Summary YTD 2013 2014 2015 2016 09/30/16 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Community Center (continued): Building overhead (4350) Building revenues: 3610 Investment income (1,295) 1,511 378 1,000 19 1,000 - 0.00% 3680 Miscellaneous 440 (33) 3,944 - 61 - - 0.00% 3972 Transfers 145,000 165,000 170,000 170,000 175,000 5,000 2.94% 3994 Capital lease proceeds - - 535,027 - - - 0.00% Total building overhead reve 144,145 166,478 709,349 171,000 80 176,000 - 0.00% Operating expenses Personnel services 0100 Salaries, regular 36,391 37,181 40,341 40,514 28,245 41,531 1,017 2.51% 0110 Salaries,overtime 1,328 2,983 1,659 1,643 1,032 1,685 42 2.56% 0300 Social Security 2,713 2,925 3,050 3,225 2,129 3,306 81 2.51% 0321 PERA 2,710 2,860 3,115 3,162 2,189 3,241 79 2.50% 0400 Group insurance 8,652 9,089 9,599 9,696 7,277 10,080 384 3.96% 0500 Workers compensation 1,489 2,243 3,278 3,249 2,357 2,690 (559) -17.21% 999 Allocation of salaries (53,283) (57,281) (61,042) (61,489) (38,078) (62,533) (1,044) 1.70% Total personnel services - - - - 5,151 - - 0.00% Materials & supplies 1210 Supplies, buildings & grounds 2,961 2,916 1,026 1,150 220 1,150 - 0.00% 1230 Supplies, equipment 1,972 588 149 800 75 800 - 0.00% 1600 Supplies, operating 7,923 7,534 8,191 7,500 5,811 7,500 - 0.00% 2400 Uniforms 432 575 468 470 351 470 - 0.00% 2410 Mats & towels 253 3,053 2,157 1,250 1,514 1,250 - 0.00% 2999 Allocation of supplies (13,541) (14,666) (11,991) (11,170) (6,575) (11,170) - 0.00% Total materials & supplies - - - - 1,396 - - 0.00% Contractual services 3030 Other professional services 1,352 343 12,480 13,750 11,145 13,750 - 0.00% 3100 Telephone 2,839 3,026 2,856 3,200 2,081 3,200 - 0.00% 3200 Water & sewer 7,871 8,720 10,196 9,000 3,696 9,000 - 0.00% 3210 Electricity 65,926 60,276 58,846 25,000 34,330 25,000 - 0.00% 3220 Natural gas 12,282 13,977 14,859 9,000 10,438 9,000 - 0.00% 3530 Refuse collection 2,723 2,837 3,299 3,980 2,261 4,144 164 4.12% 3610 Memberships - 30 - - - - - 0.00% 3630 Training & conferences 73 58 31 - 58 - - 0.00% 3999 Allocation of utilities (93,066) (89,267) (105,232) (63,930) (56,687) (64,094) (164) 0.26% 5110 Repairs, building & grounds 14,592 18,475 16,030 8,570 5,374 9,770 1,200 14.00% 5130 Repairs, equipment 17,944 21,892 14,220 12,500 8,631 12,500 - 0.00% 5999 Allocation of repairs (32,536) (40,367) (27,585) (21,070) (12,548) (22,270) (1,200) 5.70% Total contractual services - - - - 8,779 - - 0.00% Capital 7030 Equipment - - 535,027 - - - 0.00% Total capital outlays - - 535,027 - - - - 0.00% Debt service 8011 Lease payable - principal - - 31,205 52,988 26,947 39,752 (13,236) -24.98% 8021 Lease payable - interest - - 12,951 - 12,892 13,368 13,368 #DIV/0! Total debt service - - 44,156 52,988 39,839 53,120 132 0.25% Total Building overhead exp - - 579,183 52,988 55,165 53,120 132 0.25% Total Building Overhead Net 144,145 166,478 130,166 118,012 (55,085) 122,880 (132) -0.11% (continued) 32 Fund: 252 Department: 4350 Community Center Building Overhead Expenditures Account Description 2014 2015 2016 2017 Description 1210 Supplies, bldgs & grounds 1,150 1,150 1,150 1,150 Lights, signs, fertilizer 1,150 1,150 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,500 7,500 Batteries, soap, paper towels, cleaning supplies for bathrooms Paper cups, plates, etc. for lounge & customer service events 7,000 7,000 7,500 7,500 2400 Uniforms 650 470 470 470 Uniforms/Clothing (7.3% of $4,500 + .8 FTE x $175) 650 470 470 470 2410 Mats & towels 1,000 1,000 1,000 1,000 Floor mats and cleaning towelsto provide better protection of carpets 250 250 250 250 Special events 1,250 1,250 1,250 1,250 3030 Other professional services 200 800 800 800 Backflow inspection, alarm inspection, - 200 200 200 Sprinkler inspections - 9,000 11,000 11,000 Custodial services: 12 months $xxx - 1,750 1,750 1,750 Commercial carpet cleaning service (twice annually) 200 11,750 13,750 13,750 3100 Telephone & internet 3,600 3,200 3,200 3,200 Office & customer phones, internet, maintenance agreements, & repairs 3,600 3,200 3,200 3,200 3200 Water & Wastewater 9,000 9,000 9,000 9,000 Water & sewer charges for community center 9,000 9,000 9,000 9,000 3210 Electricity 58,000 58,000 25,000 35,000 Estimated electrice charges 58,000 58,000 25,000 35,000 3220 Natural gas 10,000 11,000 9,000 9,000 Estimated natural gas charges 10,000 11,000 9,000 9,000 3530 Refuse collection 3,120 3,280 3,280 3,444 Dumpsters $287 x 12 months 1,200 600 600 600 Extra garbage pick-up charges 100 100 100 100 Ramsey County recyclying fee 4,420 3,980 3,980 4,144 5110 Repairs, building & grounds 5,760 - - - Custodial services: 12 mths X $480 (moved to 3030) 3,000 - - - Commercial carpet cleaning service (twice annually)(moved to 3030) - - - 1,200 Repair floor tiles 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 8,570 8,570 9,770 5130 Repairs, equipment 5,000 11,000 11,000 11,000 HVAC system maintenance contract 200 - - - Sprinkler inspections (moved to 3030) 1,500 1,500 1,500 1,500 Plumbing, electrical, & misc. interior maintenance 6,700 12,500 12,500 12,500 8011 Lease payable (ESP)- - 52,988 39,752 Lease payable for energy savings program 8021 Interest - - - 13,368 - - 52,988 53,120 120,100 128,670 149,158 160,654 -6.58%7.14%15.92%7.71% 33 2017 Budget Summary Y-T-D 2013 2014 2015 2016 09/30/16 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Community Center (continued): Banquet Center (4730): Banquet Revenues 3634 Equipment rental 153 3,047 5,433 - 4,865 3,000 3,000 #DIV/0! 3645 Rental - banquet facility 106,268 91,376 83,502 88,000 61,379 88,000 - 0.00% 0.00% Total banquet center revenue 106,421 94,423 88,935 88,000 66,244 91,000 3,000 3.41% Banquet Expenditures Personnel services 0999 Allocation of salaries 10,754 11,456 12,208 12,298 7,616 12,507 209 1.70% Total personnel services 10,754 11,456 12,208 12,298 7,616 12,507 209 1.70% Materials & supplies 1210 Supplies, buildings & grounds - 78 1,586 - 2,739 - - 0.00% 1230 Supplies, equipment 4,355 59 79 2,500 1,841 2,500 - 0.00% 2999 Allocation of supplies 3,791 4,105 3,357 3,128 3,128 (0) -0.01% Total materials & supplies 8,146 4,242 5,022 5,628 4,580 5,628 (0) -0.01% Contractual services 3030 Other professional services 62,504 64,958 63,944 63,279 47,492 64,411 1,132 1.79% 3420 Advertising - - - 500 - 500 - 0.00% 3430 Printing - - - 250 - 250 - 0.00% 3999 Allocation of utilities 25,725 24,736 28,025 17,644 14,903 17,690 46 0.26% 4800 Bonding & insurance 1,442 1,387 1,408 2,100 1,380 2,100 - 0.00% 5110 Repairs, building & grounds 7,182 11,601 1,615 2,700 1,483 6,500 3,800 140.74% 5130 Repairs, equipment 2,633 1,997 381 1,600 1,097 1,600 - 0.00% 5999 Allocation of repairs 9,110 11,287 7,724 6,728 3,514 6,728 - 0.00% Total contractual services 108,596 115,966 103,097 94,801 69,869 99,779 4,978 5.25% Capital 7030 Equipment - - - - - - - 0.00% Total capital outlays - - - - - - - 0.00% Total banquet center exp 127,496 131,664 120,327 112,727 82,065 117,914 5,186 4.60% Total Banquet Center net (21,075) (37,241) (31,392) (24,727) (15,821) (26,914) (2,186) 8.84% (continued) 34 Fund: 252 Community Center - 4730 Banquet Center Expenditures Account Description 2014 2015 2016 2017 Description 1230 Supplies, equipment 4,000 2,500 2,500 2,500 Tables, mirrors, microphones, projectors, etc. for Banquet Room 4,000 2,500 2,500 2,500 2999 Allocation of supplies 3,038 2,988 3,128 3,128 28% Allocation from overall building support 3,038 2,988 3,128 3,128 3030 Other professional services 775 790 790 820 2.5% of audit (17 - $32,800, 18 - $33,400) 2,600 2,000 2,000 2,000 Miscellaneous professional services (linen service) 52,962 54,551 55,139 56,241 Banquet facility management (21% of 267,814) - 1,250 1,250 1,250 Carpet cleaning 2 x year 2,500 3,600 3,600 3,600 Extra staff for large events 500 500 500 500 Legal costs 59,337 62,691 63,279 64,411 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 23,574 26,884 17,644 17,690 28% Allocation from overall building utilities 23,574 26,884 17,644 17,690 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 5,000 Interior building repairs specific to the banquette center/center divider repairs 1,500 1,500 1,500 1,500 Dance floor maintenance 2,700 2,700 2,700 6,500 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 103,827 108,941 100,429 105,407 1.15%4.93%-7.81%4.96% 35 2017 Budget Summary YTD 2013 2014 2015 2016 09/30/16 2017 Actual Actual Actual Budget Actual Request Dollar Percent Community Center (continued): YMCA (4732): YMCA Revenues 3405 Recreation profit 19,124 30,157 33,194 18,000 - 20,000 2,000 11.11% 3660 Gym & meeting room rental 23,139 19,683 26,607 18,000 23,777 20,000 2,000 11.11% 3661 Open gym participant fees 18,363 19,856 20,135 16,000 12,254 17,000 1,000 6.25% 3679 Commissions - vending 512 767 1,876 600 1,311 700 100 16.67% Total YMCA revenues 61,138 70,463 81,812 52,600 37,342 57,700 5,100 9.70% YMCA Expenditures Personnel services - 0999 Allocation of salaries 36,764 39,524 42,119 42,427 26,274 43,148 721 1.70% Total personnel services 36,764 39,524 42,119 42,427 26,274 43,148 721 1.70% Materials & supplies 1230 Supplies, equipment - - - 500 2,335 2,000 1,500 300.00% 2999 Allocation of supplies 6,771 7,331 5,996 5,585 3,288 5,585 - 0.00% Total materials & supplies 6,771 7,331 5,996 6,085 5,623 7,585 1,500 24.65% Contractual services 3030 Other professional services 97,204 100,808 106,225 109,018 82,186 111,182 2,164 1.98% 3300 Postage - - - 600 - 600 - 0.00% 3430 Printing 5,797 6,042 6,298 6,600 5,329 6,600 - 0.00% 3999 Allocation of utilities 47,468 45,475 56,186 32,925 30,758 32,925 - 0.00% 4010 Rental, equipment - - 184 250 - 250 - 0.00% 4800 Bonding & insurance 2,763 2,657 2,699 4,025 2,644 4,025 - 0.00% 5110 Repairs, building & grounds 1,181 4,512 5,391 7,000 7,251 7,000 - 0.00% 5130 Repairs, equipment 1,569 2,278 1,134 1,350 7 1,350 - 0.00% 5999 Allocation of repairs 16,268 20,156 13,792 13,393 6,274 13,393 - 0.00% Total contractual services 172,250 181,928 191,909 175,161 134,449 177,325 2,164 1.24% Total YMCA exp 215,785 228,783 240,024 223,673 166,346 228,058 4,385 1.96% Total YMCA net (154,647) (158,320) (158,212) (171,073) (129,004) (170,358) 715 -0.42% (continued) Change from 2016 36 Fund: 252 Community Center - 4732 YMCA Expenditures Account Description 2014 2015 2016 2017 Description 1230 Supplies, equipment - 500 500 2,000 Miscellaneous (Basketball portable hoop pads 2017) - 500 500 2,000 2999 Allocation of supplies 5,642 5,655 5,585 5,585 50% Allocation from overall building support 5,642 5,655 5,585 5,585 3030 Other professional services 97,000 102,200 103,713 105,787 YMCA mgt. contract (other half of fee in parks)(39.5% of $267,814) - - 2,935 2,935 Copier ($2,100) Computer ($835) per agreement 2,325 2,370 2,370 2,460 7.5% of audit (17 - $32,800, 18 - $33,400) 99,325 104,570 109,018 111,182 3300 Postage 1,200 600 600 600 50% of the cost of mailing the Mounds View Matters newsletter 1,200 600 600 600 3430 Printing 6,000 6,600 6,600 6,600 50% of the cost of printing the Mounds View Matters newsletter 6,000 6,600 6,600 6,600 3999 Allocation of utilities 45,322 52,237 32,925 32,925 50% Allocation from overall building utilities 45,322 52,237 32,925 32,925 4010 Rental, equipment - 250 250 250 Scissor lift rental - 250 250 250 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 4,000 2,000 2,000 2,000 Interior improvements 2,000 2,000 2,000 2,000 Gym floor resurfacing & maintenance 9,000 7,000 7,000 7,000 5130 Repairs, equipment 500 - - - Copier maintenance contract 500 500 500 500 Registration system support 350 850 850 850 Repairs to other equipment 1,350 1,350 1,350 1,350 5999 Allocation of repairs 12,496 13,393 13,393 13,393 50% Allocation from overall building repairs 12,496 13,393 13,393 13,393 184,360 196,180 181,246 184,910 -5.84%6.41%-7.61%2.02% 37 THIS PAGE LEFT BLANK INTENTIONALLY 38 2017 Budget Summary 2013 2014 2015 2016 09/30/16 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Office space (4734); Office space revenues 3633 Lease - Office/Chamber space 3,495 2,000 7,450 8,198 6,450 8,198 - 0.00% Total office space revenues 3,495 2,000 7,450 8,198 6,450 8,198 - 0.00% Office space expenditures Personnel services 0999 Allocation of salaries 1,598 1,719 1,831 1,845 1,142 1,876 31 1.68% Total personnel services 1,598 1,719 1,831 1,845 1,142 1,876 31 1.68% Materials & supplies 2999 Allocation of supplies 406 440 360 335 197 335 0 0.03% Total materials & supplies 406 440 360 335 197 335 0 0.03% Contractual services 3999 Allocation of utilities 2,753 2,635 3,116 1,822 1,670 1,827 5 0.26% 5999 Allocation of repairs 976 1,209 828 632 376 668 36 5.71% Total contractual services 3,729 3,844 3,944 2,454 2,046 2,495 5 0.20% 0 Total office space exp 5,733 6,003 6,135 4,634 3,385 4,706 36 0.77% Total office space net (2,238) (4,003) 1,315 3,564 3,065 3,492 (36) -1.01% (continued) 2017 Budget Summary YTD 2013 2014 2015 2016 09/30/16 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Creative Kids Child Care (4736): Child Care Revenues 3632 Lease - Child Care 81,730 83,135 84,854 85,882 64,226 85,882 - 0.00% Total child care revenues 81,730 83,135 84,854 85,882 64,226 85,882 - 0.00% Child Care Ed Expenditures (19%) Personnel services 0999 Allocation of salaries 4,263 4,582 4,883 4,919 3,046 5,003 84 1.70% Total personnel services 4,263 4,582 4,883 4,919 3,046 5,003 84 1.70% Materials & supplies 1600 Supplies, operating - - 344 - - - - 0.00% 2999 Allocation of supplies 2,572 2,785 2,278 2,122 1,249 2,122 0 0.01% Total materials & supplies 2,572 2,785 2,622 2,122 1,249 2,122 0 0.01% Contractual services 3999 Allocation of utilities 17,120 16,475 17,905 11,539 9,356 11,570 31 0.27% 4750 Taxes, licenses, & fees 9,030 8,930 8,646 9,200 8,268 8,600 (600) -6.52% 4800 Bonding & insurance 961 925 939 1,400 920 1,400 - 0.00% 5999 Allocation of repairs 6,182 7,659 5,241 4,003 2,384 4,231 228 5.70% Total contractual services 33,293 33,989 32,731 26,142 20,928 25,801 (341) -1.30% Total child care exp 40,128 41,356 40,236 33,183 25,223 32,926 (257) -0.77% Total child care net 41,602 41,779 44,618 52,699 39,003 52,956 257 0.49% 39 2017 Budget Summary Y-T-D 2013 2014 2015 2016 09/30/2016 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Lakeside Park (Fund 255): Revenues 3370 Spring Lake Pk contribution 10,608 10,608 11,500 11,500 11,500 11,500 - 0.00% 3370 Mounds View contribution 10,608 10,608 11,500 11,500 11,500 11,500 - 0.00% 3610 Investment income (466) 729 132 300 7 300 - 0.00% 3665 Park site permit 448 678 921 250 702 250 - 0.00% Total revenue 21,198 22,623 24,053 23,550 23,709 23,550 - 0.00% Operating expenses (4350): Personnel services 0150 Salaries, part-time 3,360 3,528 2,079 3,360 2,805 3,520 160 4.76% 0300 Social security 257 270 159 257 215 269 12 4.67% 0500 Workers compensation 106 146 202 166 189 220 54 32.53% Total personnel services 3,723 3,944 2,440 3,783 3,209 4,009 226 5.97% Materials & supplies 1210 Supplies, bldgs & grounds 458 237 - 1,200 - 1,100 (100) -8.33% 1600 Supplies, operating 4,337 957 928 1,800 - 1,500 (300) -16.67% Total materials & supplies 4,795 1,194 928 3,000 - 2,600 (400) -13.33% Contractual services 3200 Water & sewer 1,646 1,869 2,090 1,600 1,028 1,800 200 12.50% 3210 Electricity 984 1,625 1,262 1,600 763 1,400 (200) -12.50% 3530 Refuse collection 48 - - 75 - 75 - 0.00% 4010 Equipment Contribution SLP 4,986 4,372 4,986 4,600 - 4,600 - 0.00% 4030 Satellites 609 875 1,487 500 720 650 150 30.00% 4800 Insurance 4,638 4,738 4,608 4,800 - 4,800 - 0.00% 5130 Repairs, equipment 2,558 - 2,795 3,592 - 3,616 24 0.67% Total contractual services 15,469 13,479 17,228 16,767 2,511 16,941 174 1.04% Capital 7030 Equipment - - - - - - - 0.00% 7050 Construction 13,361 - - - - - - 0.00% Total capital outlays 13,361 - - - - - - 0.00% Total expenses 37,348 18,617 20,596 23,550 5,720 23,550 - 0.00% Net change in fund balance (16,150) 4,006 3,457 - 17,989 - - 0.00% Fund balance, beginning year 12,489 (3,661) 345 3,802 3,802 3,802 - 0.00% Fund balance, end of year (3,661) 345 3,802 3,802 21,791 3,802 - 0.00% 40 Fund: 255 Lakeside Park Revenues Account Description 2014 2015 2016 2017 Description 3370 Contributions 10,608 11,500 11,500 11,500 Spring Lake Park contribution for half of cost for joint park 10,608 11,500 11,500 11,500 3370 Contributions 10,608 11,500 11,500 11,500 Mounds View contribution for half of cost for joint park 10,608 11,500 11,500 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 1,200 1,200 1,100 Paper, sand, etc. 600 1,200 1,200 1,100 1600 Supplies, operating 1,500 1,800 1,800 1,500 Fertilizer & pesticides 1,500 1,800 1,800 1,500 3200 Water & sewer 1,400 1,600 1,600 1,800 Estimated water & sewer charges 1,400 1,600 1,600 1,800 3210 Electricity 1,400 1,600 1,600 1,400 Estimated electric charges 1,400 1,600 1,600 1,400 3530 Refuse collection 250 75 75 75 Six months service 250 75 75 75 4010 Equipment, capital charge 4,372 4,600 4,600 4,600 Capital charge for usage of SLP city equipment 4,372 4,600 4,600 4,600 4030 Satellites 500 500 500 650 Five months service 500 500 500 650 4800 Insurance & bonds 4,500 4,800 4,800 4,800 Property & liability insurnace 4,500 4,800 4,800 4,800 5130 Repairs, equipment 3,514 3,592 3,592 3,616 Repair of equipment at the park 3,514 3,592 3,592 3,616 18,036 19,767 19,767 19,541 0.00%9.60%0.00%-1.14% 41 2017 Budget Summary Y-T-D 2013 2014 2015 2016 09/30/16 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Recycling (Fund 290): Revenues 3360 Other County grants 24,565 25,211 31,877 30,220 20,203 30,220 - 0.00% 3610 Investment income (209) 321 51 - 3 - - 0.00% Total revenue 24,356 25,532 31,928 30,220 20,206 30,220 - 0.00% Operating expenses Operations (4420) Personnel services 0100 Salaries, regular 8,650 8,939 10,036 10,180 7,362 10,436 256 2.51% 0110 Salaries, overtime - 286 281 185 - - 0.00% 0300 Social security 565 612 772 779 557 798 19 2.44% 0321 PERA 625 666 734 764 535 783 19 2.49% 0400 Group insurance 2,416 2,480 524 1,641 388 1,693 52 3.17% 0500 Workers compensation 58 71 101 105 79 90 (15) -14.29% Total personnel services 12,314 13,054 12,448 13,469 9,106 13,800 331 2.46% Materials & supplies 1600 Supplies, operating 3,252 - - 1,000 - 500 (500) -50.00% Contractual services 3300 Postage 4,671 6,722 5,069 5,000 4,120 5,100 100 2.00% 3420 Advertisements - - - - 1,208 - 0.00% 3430 Printing 860 1,936 2,912 1,000 655 3,000 2,000 200.00% 3530 Refuse collection 3,892 4,321 4,439 9,751 8,229 7,820 (1,931) -19.80% Total contractual services 9,423 12,979 12,420 15,751 14,212 15,920 169 1.07% Total expenses 24,989 26,033 24,868 30,220 23,318 30,220 - 0.00% Net change in fund balance (633) (501) 7,060 - (3,112) - - 0.00% Fund balance, beginning year 15,643 15,010 14,509 21,569 21,569 21,569 - 0.00% Fund balance, end of year 15,010 14,509 21,569 21,569 18,457 21,569 - 0.00% 16,420 42 Fund: 290 Recycling Grant Revenues Account Description 2014 2015 2016 2017 Description 3360 Other grants & aid 25,133 31,877 30,220 30,220 Estimated Ramsey County recycling grant 25,133 31,877 30,220 30,220 Fund: 290 Department: 4420 Expenditures 1600 Supplies, operatin - 3,000 1,000 500 - 3,000 1,000 500 3300 Postage 3,000 5,500 5,000 5,100 City wide mailing for Cleanup Day and Newsletter 3,000 5,500 5,000 5,100 3430 Printing 800 1,000 500 2,500 Articles in City newsletter 800 1,000 500 500 Clean-up Day printing of direct mailing items 1,600 2,000 1,000 3,000 3530 Refuse collection 7,777 8,789 9,751 7,820 Contractual services for City Cleanup Day 7,777 8,789 9,751 7,820 12,377 19,289 16,751 16,420 -4.56%55.85%-13.16%-1.98% 43 Y-T-D 2013 2014 2015 2016 09/30/16 2017 Actual Actual Actual Budget Actual Request Dollar Percent TIF # 5 (Fund 450): Revenues 3101 Tax collections 1,390,103 1,415,212 1,441,945 1,555,982 777,791 1,555,982 - 0.00% 3610 Investment income (8,333) 13,433 2,738 4,000 517 3,000 (1,000) -25.00% Total revenue 1,381,770 1,428,645 1,444,683 1,559,982 778,308 1,558,982 (1,000) -0.06% Operating expenses (4650): Contractual services 3030 Other professional 1,315 1,178 2,924 5,000 4,980 5,060 60 1.20% 8010 Developer PAG, principal 132,268 196,416 231,283 - 309,984 - - 0.00% 8020 Developer PAG, interest 1,158,250 1,136,109 1,125,867 1,431,290 1,113,841 1,478,183 46,893 3.28% 9900 Transfers out to EDA 69,505 70,760 72,863 75,331 - 77,799 2,468 3.28% Total contractual services 1,361,338 1,404,463 1,432,937 1,511,621 1,428,805 1,561,042 49,421 3.27% Net change in fund balance 20,432 24,182 11,746 48,361 (650,497) (2,060) (50,421) -104.26% Fund balance, beginning year 682,745 703,177 727,359 739,105 739,105 787,466 48,361 6.54% Fund balance, end of year 703,177 727,359 739,105 787,466 88,608 785,406 (2,060) -0.26% 2017 Budget Summary Change from 2016 44 Fund: 450 TIF District #5 Revenues Account Description 2014 2015 2016 2017 Description 3101 Tax increment collections 1,299,181 1,457,260 1,555,982 1,555,982 Estimated collections of incremental taxes on properties 1,299,181 1,457,260 1,555,982 1,555,982 in the district. 3610 Investment income 4,000 4,000 4,000 3,000 Estimated interest earnings at 1.00%. 4,000 4,000 4,000 3,000 Fund: 430 Department: 4650 Economic Development 3030 Other professional services 3,000 2,420 3,420 3,420 TIF administration and reporting fees - 1,580 1,580 1,640 5% audit fee (moved from EDA)(2017 - $32,800, 2018 - $33,400) 3,000 4,000 5,000 5,060 8010 Pay-as-you-go principal 1,234,223 1,364,425 1,431,290 1,478,183 Principal on a revenue note issued to promote a development. (Medtronic) 1,234,223 1,364,425 1,431,290 1,478,183 9900 Transfer out to EDA Fund 64,958 72,863 75,331 77,799 Transfer to cover the EDA operating budget. 64,958 72,863 75,331 77,799 45 THIS PAGE LEFT BLANK INTENTIONALLY 46 CITY OF MOUNDS VIEW, MINNESOTA Capital Project Funds 2017 Budgets Combining Statement of Revenues and Expenditures Park Vehicle and Special Street Dedication Equipment Projects Improvement 2017 2016 Revenue: Taxes -$ -$ -$ 300,000$ 300,000$ 300,000$ Franchise fees - - - 275,000 275,000 265,000 Special assessments - - - 20,000 20,000 20,000 Intergovernmental: State - - - 275,000 275,000 275,000 County - - - - - 39,300 Miscellaneous: Investment income 2,000 - 4,000 50,000 56,000 83,000 Other 3,000 - - - 3,000 6,000 Total revenue 5,000 - 4,000 920,000 929,000 988,300 Expenditures: General government - - 14,000 - 14,000 44,600 Public safety - 74,300 - - 74,300 84,000 Streets and highways - 179,000 347,027 841,000 1,367,027 5,858,250 Culture and recreation 114,850 9,000 - - 123,850 778,000 Total expenditures 114,850 262,300 361,027 841,000 1,579,177 6,764,850 Excess (deficiency) of revenue over expenditures (109,850) (262,300) (357,027) 79,000 (650,177) (5,776,550) Other financing sources (uses) Operating transfers Transfers in - 309,000 75,000 240,000 624,000 603,000 Transfers out - (53,000) - - (53,000) (105,000) Total other financing sources (uses)- 256,000 75,000 240,000 571,000 498,000 Net change in fund balance (109,850) (6,300) (282,027) 319,000 (79,177) (5,278,550) Fund balance, January 1 360,678 1,684,622 480,156 1,007,244 3,532,700 8,043,302 Fund balance, December 31 250,828$ 1,678,322$ 198,129$ 1,326,244$ 3,453,523$ 2,764,752$ Total Budget 47 2017 Budget Summary Y-T-D 2013 2014 2015 2016 09/30/16 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Park Dedication (Fund 451): Revenues 3360 Other county grants - 0.00% 3610 Investment income (11,465) 17,648 5,037 2,000 247 2,000 - 0.00% 3650 Park donations 8,155 8,900 15,085 - - - - 0.00% 3652 Park dedication fees - 213,529 - 6,000 1,082 3,000 (3,000) -50.00% Total revenue (3,310) 240,077 20,122 8,000 1,329 5,000 (3,000) -37.50% Operating expenses Operations (4350): Materials & supplies 1230 Supplies, equip. < $5,000 - 15,367 - - - - - 0.00% 1600 Supplies, operating 87 - - - - - - 0.00% Total materials & supplies 87 15,367 - - - - - 0.00% Contractual services 3030 Other professional services 3,654 2,235 - - - - - 0.00% Total contractual services 3,654 2,235 - - - - - 0.00% Capital 7050 Construction 119,640 7,960 67,380 95,000 11,860 114,850 19,850 20.89% Total capital outlays 119,640 7,960 67,380 95,000 11,860 114,850 19,850 20.89% Total expenses 123,381 25,562 67,380 95,000 11,860 114,850 19,850 20.89% Net change in fund balance (126,691) 214,515 (47,258) (87,000) (10,531) (109,850) (22,850) 26.26% Fund balance, beginning year 407,112 280,421 494,936 447,678 447,678 360,678 (87,000) -19.43% Fund balance, end of year 280,421$ 494,936$ 447,678$ 360,678$ 437,147$ 250,828$ (109,850)$ -30.46% 48 Fund: 451 Park Dedication Fund Revenues Account Description 2014 2015 2016 2017 Description 3610 Investment income 3,000 2,000 2,000 2,000 Estimated interest earnings at 1%. 3,000 2,000 2,000 2,000 3652 Park dedication fees 6,000 6,000 6,000 3,000 Developer payments 6,000 6,000 6,000 3,000 Fund: 451 Department: 4470 Expenditures 7050 Construction > $25000 - - 20,000 - Random Park Building interior remodeling - - 25,000 - Roofing shelters - 100,000 - - Splash pad - 220,000 50,000 - Groveland Park Improvements 25,000 25,000 - 25,000 Disk golf course improvements at Silverview Park 20,000 - - - Shelter and grounds improvements Silverview Park 10,000 - - 15,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 - - - 60,000 Greenfield tennis court - resurface - - - 14,850 Hillview hockey rink 78,600 347,500 95,000 114,850 49 2017 Budget Summary Y-T-D 2013 2014 2015 2016 09/30/16 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Vehicle & Equipment (Fund 460): Revenues 3972 Transfers in - General fund 90,000 100,000 110,000 150,000 - 175,000 25,000 16.67% 3972 Transfers in - Water 58,000 60,000 - 64,000 - 64,000 - 0.00% 3972 Transfers in - Sewer 36,000 36,000 53,000 42,000 - 38,000 (4,000) -9.52% 3972 Transfers in - Storm Water 16,000 16,000 71,000 32,000 - 32,000 - 0.00% Total revenue 200,000 212,000 234,000 288,000 - 309,000 21,000 7.29% Expenditures Central Services (4160): Materials & supplies 0.00% 1600 Supplies, operating - - - - - - - 0.00% Total Central Services - - - - - - - 0.00% 0.00% Police (4200): Materials & supplies 0.00% 1230 Supplies, equip < $5,000 - 2,897 - - - - - 0.00% 3030 Other professional services - 941 - - - - - 0.00% 5120 Repairs, vehicles - 4,542 - - - - - 0.00% Capital 7030 Equipment - - - 10,000 - - 0.00% 7040 Vehicles 89,804 45,952 57,947 74,000 57,788 74,300 74,300 100.41% Total Police 89,804 54,332 57,947 84,000 57,788 74,300 74,300 88.45% Park and rec (4360): Capital 7030 Equipment 15,344 183,224 93,649 18,000 10,931 9,000 9,000 50.00% 7040 Vehicles - 26,696 - - - - - 0.00% Total Park and rec 15,344 209,920 93,649 18,000 10,931 9,000 9,000 50.00% PW Streets (4470): Materials & supplies 0.00% 1230 Supplies, equip < $5,000 - 4,215 - - - - - 0.00% Capital 7030 Equipment - - - - 20,000 20,000 #DIV/0! 7040 Vehicles - 96,622 - - - 159,000 159,000 #DIV/0! Total PW Streets - 100,837 - - - 179,000 179,000 #DIV/0! Other (4160): 9100 Contingency - - - - - - - 0.00% 9900 Transfer out - General Fund 23,736 38,316 21,000 22,000 - 18,000 (4,000) -18.18% 9900 Transfer out - Water - 72,000 - - - 35,000 35,000 #DIV/0! 9900 Transfer out - Sewer - - - 83,000 - - (83,000) -100.00% 9900 Transfer out - Storm Water - - 210,000 - - - 0.00% Total other 23,736 110,316 231,000 105,000 - 53,000 (52,000) -49.52% Total expenditures 128,884 475,405 382,596 207,000 68,719 315,300 210,300 #DIV/0! Net change in fund balance 71,116 (263,405) (148,596) 81,000 (68,719) (6,300) (87,300) -107.78% Fund balance, beginning year 1,681,102 1,681,102 1,752,218 1,603,622 1,603,622 1,684,622 81,000 5.05% Fund balance, end of year 1,752,218 1,417,697 1,603,622 1,684,622 1,534,903 1,678,322 (6,300) -0.37% 50 Fund: 460 Vehicle & Equipment Fund Revenues Account Description 2014 2015 2016 2017 Description 3961 Transfers in 100,000 110,000 150,000 175,000 From General Fund ($232,000 5yr Fin Plan) 60,000 58,000 64,000 64,000 From Water Fund 36,000 53,000 42,000 38,000 From Sanitary Sewer Fund 16,000 71,000 32,000 32,000 From Storm Water Fund 212,000 292,000 288,000 309,000 Fund: 460 Department: 4200 Police Operations 7030 Equipment > $5000 - - 10,000 Radar trailer - - 10,000 - 7040 Vehicles 62,000 65,000 74,000 74,300 (1) SUV $27,500, setup $11,000, radio $3,800, camera $5,500 (1) staff car $19,500, setup $3,200, radio $3,800 62,000 65,000 74,000 74,300 Fund: 460 Department: 4360 Parks Operations 7030 Equipment > $5000 130,000 - - - Parks mower (AEBI Terratrac TT705) 17,500 - - - Batwing mower for AEBI - - 8,000 9,000 Utility cart - - 10,000 - Engine for parks mower - 115,000 - - Parks mower ($13,500 Walker MTGHS mower move to 2017) 147,500 115,000 18,000 9,000 7040 Vehicles 63,000 - - - Parks - 3/4 ton pick-up 63,000 - - - Fund: 460 Department: 4460 Building & Grounds Operations 7030 Equipment > $5000 - - - - Replace City Hall entrance lights (Bldg & grnds) - - - - Fund: 460 Department: 4470 Pavement Management Operations 7030 Equipment > $5000 - - - 20,000 Compactor - - - 20,000 7040 Vehicles 25,000 - - 34,000 Street maint 1/2 ton pick-up - - - 125,000 Dump truck ($160,000 net of trade-in $35,000) 70,000 - - - Street maint 1 ton pick-up 95,000 - - 159,000 9900 Transfers out 81,600 21,000 22,000 18,000 Various equipment purchases general fund - - 83,000 - Sewer - Generator lift station (natural gas) - 210,000 - - Storm Water - street sweeper (net of $40,000-$50,000 trade-in) 72,000 - - 35,000 Water - (1/2 ton truck 4x4 ($35,000) 153,600 231,000 105,000 53,000 51 2017 Budget Summary Y-T-D 2013 2014 2015 2016 09/30/16 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Special Projects (Fund 480): Revenues 3553 Spec assessmt penalty & intere 256 - - - 256 - - 0.00% 3610 Investment income (22,992) 33,985 12,483 6,000 - 4,000 (2,000) -33.33% 3680 Other revenue - 4,000 - - 606 - - 0.00% 3972 Transfers in - 912,000 200,000 75,000 - 75,000 - 0.00% 3993 Bond sales - - - - - - 0.00% Total revenue (22,736) 949,985 212,483 81,000 862 79,000 (2,000) -2.47% Operating expenses Operations (4160): Materials & supplies 1230 Supplies, equipment < $5,000 - 11,881 - - - - - 0.00% 1600 Supplies, operating - 828 - - - - - 0.00% Total materials & supplies - 12,709 - - - - - - Contractual services 3030 Other professional services - 190 - - - - 0.00% 5130 Repairs; Equipment - 3,189 - - - - - 0.00% Total contractual services - 3,379 - - - - - 0.00% Operations (4180): Contractual services 3030 Other professional services 22,057 5,969 4,763 - 14,000 14,000 #DIV/0! 5130 Repairs; Equipment 3,261 12,359 1,833 - - - - 0.00% Total contractual services 25,318 18,328 6,596 - - 14,000 14,000 #DIV/0! Capital 7030 Capital equipment 29,975 101,297 - 62,850 43,175 60,000 (2,850) -4.53% 7050 Construction 189,977 198,075 79,600 855,000 339,141 287,027 (567,973) -66.43% Total capital outlays 219,952 299,372 79,600 917,850 382,316 347,027 (570,823) -62.19% Total expenses 245,270 333,788 86,196 917,850 382,316 361,027 (556,823) -60.67% Net change in fund balance (268,006) 616,197 126,287 (836,850) (381,454) (282,027) 554,823 -66.30% Fund balance, beginning year 842,528 574,522 1,190,719 1,317,006 1,317,006 480,156 (836,850) -63.54% Fund balance, end of year 574,522 1,190,719 1,317,006 480,156 935,552 198,129 (282,027) -58.74% 52 Fund: 480 Special Projects Revenues Account Description 2014 2015 2016 2017 Description 3610 Investment income 6,000 2,000 6,000 4,000 Estimated interest earnings at 1%. 6,000 2,000 6,000 4,000 3972 Transfers in - 50,122 75,000 75,000 Transfer from General Fund - 50,122 75,000 75,000 3993 Bond proceeds - - - TBD G.O. Bonds for PW facility - - - - Fund: 480 Department: 4180 Expenditures 3030 Other professional services 2,000 - - - Scanning of microfilm to laser fiche - - - 14,000 Siren upgrades (3 sirens) - 4,500 - - Interior painting Police Department 2,000 4,500 - 14,000 7030 Capital, equipment > $5000 28,000 - - - Purchase copiers (3) Main copier, police, comm dev/finance (replace 2019) 6,000 - - - Card Key Access - City Hall 12,500 - - - Council Chambers chairs/tables (50 chairs @ $150)(Defer) 3,500 - - - Dias chairs - - 10,000 10,000 Park building video and door lock improvements 10,000 - 30,000 - Video and Security improvements for CH and CC (BBC grant of $2,000) - - 8,250 - Road sensors 3 locations - - 11,450 - Automatic Transfer switch (City Hall generator) - - 3,150 - Upgrade CH electrical panel - - - 50,000 Website 30,000 - - - Unleaded fuel tank, pump, and monitoring equipment 90,000 - 62,850 60,000 7050 Construction > $25000 - - 40,000 - Comm. Center relocate entrance sign (carryover from 2007) 25,000 - - - City Hall irrigation and landscape project ($10,000 defer to 2016) 79,500 200,000 200,000 TBD PW Building Project (design phase)(construction in 2017) 200,000 150,000 375,000 - Pathway rehabilitation program (Silver View Park) - - 200,000 250,000 Splash Pad/City Hall Park redesign 12,000 - - - Police parking lot lighting 30,000 - - - Masonry renovation of CH & CC 75,000 - - - CC retro commissioning Improvements (phase 1) - 25,000 - 37,027 CC HVAC Improvements (RTU-4,7 and VAV's) 25,000 - - - Cty Rd H sidewalk - 30,000 - - Remodel prep kitchen - - 40,000 - Remodel /Expand exercise area ($40,000 to 2016) - 8,000 - - Remodel Comm Ctr Admin offices 446,500 413,000 855,000 287,027 9900 Transfer to General Fund 90,000 - - - 90,000 - - - 53 2017 Budget Summary Y-T-D 2013 2014 2015 2016 09/30/16 2017 Change from 2016 Actual Actual Actual Budget Actual Request Dollar Percent Street Improvement (Fund 485): Revenues 3101 Property taxes 276,447 302,356 302,050 300,000 70,050 300,000 - 0.00% 3180 Franchise fee 259,070 336,711 309,039 265,000 177,356 275,000 10,000 3.77% 3352 MSA street construction 395,280 327,190 323,342 275,000 364,924 275,000 - 0.00% 3360 Other county grant - - - 39,300 - - (39,300) -100.00% 3550 Spec assessmt prepayment 49,226 42,215 62,890 20,000 17,809 20,000 - 0.00% 3610 Investment income (220,669) 363,537 70,636 75,000 3,498 50,000 (25,000) -33.33% 3680 Other revenue 18,480 42,670 3,235 - 5,306 - - 0.00% 3972 Transfer from other funds 300,000 215,000 215,000 240,000 240,000 - 0.00% Total revenue 1,077,834 1,629,679 1,286,192 1,214,300 638,943 1,160,000 (54,300) -4.47% Operating expenses Operations (4470): Contractual services 3030 Other professional services - 2,564 - - - - - 0.00% 5220 Mounds View Blvd improvement - - - - 27,128 - - 0.00% Total contractual services - 2,564 - - 27,128 - - 0.00% Capital 7050 Construction 1,706,436 1,663,718 3,031,842 5,650,000 2,204,272 841,000 (4,809,000) -85.12% Total capital outlays 1,706,436 1,663,718 3,031,842 5,650,000 2,204,272 841,000 (4,809,000) -85.12% Total expenses 1,706,436 1,666,282 3,031,842 5,650,000 2,231,400 841,000 (4,809,000) -85.12% Net change in fund balance (628,602) (36,603) (1,745,650) (4,435,700) (1,592,457) 319,000 4,754,700 -107.19% Fund balance, beginning year 7,853,799 7,225,197 7,188,594 5,442,944 5,442,944 1,007,244 (4,435,700) -81.49% Fund balance, end of year 7,225,197$ 7,188,594$ 5,442,944$ 1,007,244$ 3,850,487$ 1,326,244$ 319,000$ 31.67% 54 Fund: 485 Street Improvement Revenues Account Description 2014 2015 2016 2017 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 255,000 265,000 280,000 Half of the 4% franchase fee on gas & electric utilities 253,000 255,000 265,000 280,000 3352 MSA Street Construction 315,000 315,000 275,000 - State aid funds 315,000 315,000 275,000 - 3360 Other County grants - - 39,300 - County trail grants - - 39,300 - 3550 Special assessments 20,000 20,000 20,000 20,000 Special assessments on private improvements 20,000 20,000 20,000 20,000 3610 Investment income 75,000 75,000 75,000 25,000 Estimated interest earnings at 1%. 75,000 75,000 75,000 25,000 3972 Transfer in 300,000 240,000 240,000 - Transfers from utility funds (water 25,000, sewer 140,000, storm 75,000) 300,000 240,000 240,000 - 1,263,000 1,205,000 1,214,300 625,000 Fund: 485 Department: 4470 Expenditures 7050 Construction > $25000 94,805 - - - 2013 Area F Street & Utility project 1,408,424 96,770 - - 2014 Area G Street & Utility project 247,771 1,856,049 373,885 - 2015 Area H Street & Utility project - 348,644 3,964,115 441,000 2016 Area I Street & Utility project - - - 75,000 Program Avenue CSAH 10 to CR H2 (design phase) - - 125,000 150,000 Mill and overlay (CH & MVCC) - - - - Cty Rd H2/10 intersection (City share)(Ramsey Co is lead) - - 285,000 - Cty Rd H/10 intersection (MSA eligible)(City share)(Ramsey Co is lead) - - 627,000 - Trail segments 6 and 11 (County grant/match of $39,300) - - 125,000 - Cty Rd I and Quincy Intersection street lights 50,000 50,000 75,000 - Other pavement improvements (Silver View parking lot and trails) 375,000 350,000 75,000 175,000 Seal coat projects 2,176,000 2,701,463 5,650,000 841,000 55 THIS PAGE LEFT BLANK INTENTIONALLY 56 Item No: 2 Meeting Date: October 3, 2016 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 2017 Attached are the budgets for the Other Funds (Special Revenue, Capital Projects, and Enterprise) for your consideration. The Council has reviewed the General Fund and will again in November or December. The Special Revenue, Capital Projects, and Enterprise funds have not been reviewed. Enterprise Funds The City has and will continue to perform long term capital maintenance on the various utility systems. Many of the systems are aging and have received or will need attention in the next few years. This has driven the need for rate increases. The Water fund has experienced a steady decline in water use since 2007 as more residents and businesses conserve water. This has made it more difficult to generate enough revenue to support the water utility infrastructure. The City adopted a base water charge or water availability charge in 2016. Staff is recommending that the base charge increase by $2 per quarter per connection. Variable rates would stay the same for 2017. Staff is also recommending that the rate tiers for variable water use be adjusted to reflect lower average use. This would add less than $1 per quarter to the average user. Overall water rates would increase $1 per month or $12 annually. Future base charges would increase by smaller amounts until the base charge is approximately 65% of revenue. This may mean that variable rates won’t increase for several years but the base rate will. The Sewer fund anticipates a 6% increase in user charges which will add $1.50 per month or $18 annually to a residential utility bill. Met Council Environmental Services (MCES) waste charges increased by 2.19% for 2017. Future increases of 6% for 2018, 5% for 2019, and 4% foe 2020 will help stabilize the sewer fund. The Storm Water fund does not require an increase in 2017, an increase in 2018 should be considered. This will begin to fund the sediment removal from Silver View pond that will occur in approximately 2026. The cost estimate by the testing firm was $1 – 2 million depending on the condition of the sediment. The City will be 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 2017 thru 2019 to offset higher electrical costs for the approximately 275 street lights that we pay Xcel energy for. Trail lighting was converted to LED in 2015 and additional trail lights will be added in 2016 for trail segments 6, 10, and 11. Electric costs will go down but this accounts for only about 12% of the electric charges. Capital Projects Funds There are a number of capital projects that are anticipated to occur in 2017, the most prominent is the Public Works facility. There is a $75,000 transfer budgeted in the General Fund for 2017 to the Special Projects Fund. 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, and TIF 5 as they have the most significant activity. The EDA fund will be funded by an HRA/EDA levy not exceeding $100,000, a transfer from TIF 5 that is limited to 5% of the increment in TIF 5 (approx. $77,000) and a $50,000 transfer from the General Fund. Staff would recommend that Council review the funds and make any recommendations that they may have. Respectfully Submitted, Mark Beer, Finance Director Item No: 4 Meeting Date: Oct 3, 2016 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 Non-Compliant Curb Cuts Widened During Street Improvement Projects Introduction: After the City created the Street and Utility Improvement Program, the Council also created a Private Improvement Program whereby residents within project areas could pay to have certain additional work done within the right of way at their own expense. Originally, these improvements included replacement of the sanitary sewer from the main to the property line, installation of new services from the main to the property line, replacing a non- conforming or second curb cut, and, widening an existing curb cut. Discussion: Many residents took advantage of the Private Improvement Program (PIP) to replace sanitary services and to address non-conforming curb cuts. Many others (almost 100) opted to widen a curb cut on the condition that the driveway be widened within a year to match the new, wider curb cut. The original PIP Agreement included the following language, which each property owner acknowledged and agreed to when they signed the agreement: “Owner agrees to improve the driveway to match the curb cut within one year of the date that construction of the curb cut is completed. Owner understands and agrees that if Owner does not improve the driveway within this time period, the City has the right to remove the Improvements and Owner will be responsible for paying the cost of removal.” After the City had constructed five projects, it became clear that following up on the one- year requirement for the wider curb cuts would prove challenging, as many property owners had yet to make the requisite improvement to their driveways. As a result, the PIP Agreement was revised for the Area G project to require a $300 deposit as well as a permit in hand for the wider driveway before the City would agree to widen the curb cut. The new language is as follows: “Owner agrees to pay a $300 deposit and improve the driveway to match the curb cut within one year of the date that construction of the curb cut is completed. Owner understands and agrees that if Owner does not improve the driveway within this time period, the $300 deposit will be forfeited and the City will remove the Improvements. The Owner will also be responsible for paying all additional costs of removal over the $300 deposit.” The new language has helped to minimize the number of driveways that are not widened to match the curb cut after the project concludes. Curb Cut Report October 3, 2016 Page 2 Planner Jon Sevald indicates there are only five driveways that have not yet been improved to match the curb cut, however we are double-checking with Public Works to ensure the list is comprehensive. While some property owners have received extensions from the City for one reason or another, as a matter of fairness to all other owners who have widened their driveways as required, we are at the point now that non-conforming curb cut widths should be removed pursuant to the agreement signed by the resident, at the residents’ expense. There is one exception to the direction noted above regarding removal of the extra concrete and apron at the owners’ expense: the City is aware of at least one case where a property owner who had requested the wide curb cut sold the property before compliance was achieved, leaving the new owner unaware of the requirement to widen the driveway. In this case, staff would suggest we communicate with the new property owner and advise them of their options. If the new owner does not want to widen the driveway, staff would recommend the curb cut be corrected to match the old driveway and NOT charge the new resident. For all other owners, they would receive notice of the City’s intent to remove the extra curb cut width at their expense if the driveway is not widened by, for example, June 1, 2017. Public Works Director Brian Erickson has requested quotes from the street and concrete contractors to do the work with pricing valid through the end of next year. Any PIP curb cuts left non-compliant would be replaced at the owners’ expense after June 1, 2017. Recommendation: Review the information presented and confirm whether the proposed course of action and timeline should be pursued. Respectfully submitted, ________________________ James Ericson City Administrator