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 - 2018/10/01
CITY OF MOUNDS VIEW CITY COUNCIL WORK SESSION AGENDA MOUNDS VIEW CITY HALL Monday, October 1, 2018 6:30 p.m. ROLL CALL: Mueller, Gunn, Hull, Meehlhause, Bergeron 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. Fire Department, New Wild land/Rescue/Rapid Intervention Truck, Update 2. 2019 Draft budgets for Special Revenue, Debt Service, Capital Projects, and Enterprise Funds 3. North Metro Mayor 2019 Legislative Platform 4. HR Update 5. Laserfiche Overview 6. Public Comment at Council and other Meetings 7. Code Chapters 700, 800, 900 Policy Questions 8. Hare Radio Antennae 9. Tablets/Digital Packets for Council 10. Long Lake Woods 11. Retreat — HR/Public Safety Strategic Plan THIS PAGE LEFT BLANK INTENTIONALLY MEMORANDUM to: Mounds View City Council from: Nyle Zikmund, City Administrator re: October 1, 2018 Workshop date: September 27, 2018 Item 1 - Fire Department, New Wildland/Rescue/Rapid Intervention Truck Chief Smith will be bringing the new truck over for show and tell along with giving a brief update on contemporary issues. Item 2 - 2019 Draft budgets for Special Revenue, Debt Service, Capital Projects, and Enterprise Funds — Finance Director Beer Consensus on direction Item 3 - North Metro Mayor 2019 Legislative Platform — Zikmund Consensus on submitting legislative idea for NMM consideration specific to Watersheds Consensus on submitting legislative idea for NMM consideration specific to workers compensation claims. Item 4 — HR Update — Zikmund — Verbal Report Item 5 - Laserfiche Overview — Zikmund - Demonstration Item 6 - Public Comment at Council and other Meetings — Zikmund Following up on a previous discussion at workshop/council and consistent with the City Administrators probation requirements (specific to improving meeting efficiency) included is a draft policy/guide for taking public input at meetings. Consensus to "adopt" policy/guide. Item 7 - Code Chapters 700, 800, 900 Policy Questions - Zikmund We currently allow chickens, ducks, and bees. We have had a couple of inquiries specific to pot bellied pigs. Do we want to allow pot bellied pigs? (Chapter 700) We currently have several exemptions to our overnight parking. We also receive a significant number of complaints, especially from non-residents, that are signage is poor. Subd. 2. Specific Areas, 9:00 P.M. to 2:00 A.M.: No person shall stop, stand or park a motor vehicle on the following sections of City streets between the hours of nine o'clock (9:00) P.M. and two o'clock (2:00) A.M., except as otherwise authorized by this Code or unless directed to do so by a police officer or traffic -control device: Wensen 1lriaro ra aa•41'a niao l,o�-.a mora >~annaa rra raa Tlria rn nava Tnnlr c�o*� T:ricro- Clear -view Avenue, e, be Li' een ifen lnle Read ea and �'irlgeweed Dfiye; Read u 2-- Gr-eenfield Avenue, between Aloodale Dr-ive and Getinb, Read 14 2 exeept adjaeent to 2400 GE)Hflt� Rona u 2i - O Genn ll Dt-iye,, between je ff+e , Drive and Gfeenfield Avenue. (lira 540, 6 13 94) I had public works do up an estimate of placing larger signs (18 x 24) at all major entrances to the City and smaller signs (12 x 18) on smaller streets (Red Oak). $3,000 for all (40 signs) and 80 hours of labor. Do we want to eliminate parking exemptions on any road and install more signs? (Chapter 800) Item 8 - Ham Radio Antennae — Zikmund Local resident involved in regional club requested placement of an antennae on top of tower. They would pay installation costs and utility usage as well as provide adequate insurance. Resident will be sending written proposal. Item 9 - Tablets/Digital Packets for Council — Zikmund/Beer As we have progressed on the digitalization of records, council inquired as to our ability to convert our packet process to digital thus further reducing our paper imprint. Included in the packet is an email from Metro IT that outlines the issues, pros and cons and well as challenges. Based on this feedback, consensus on direction? Item 10 - Long Lake Woods — Zikmund — Update and set neighborhood meeting Set neighborhood meeting date Item 11 - Retreat — HR/Public Safety Strategic Plan — Zikmund/Harder Set date for retreat Item No: 2 Meeting Date: October 1, 2018 MoS VIEW Type of Business: Work Session Administrator Review: City of Mounds View Staff Report MEMENEr- To: Honorable Mayor and City Council From: Mark Beer, Finance Director Item Title/Subject: Review Special Revenue, Debt Service, Capital Projects and Enterprise Funds Draft Budgets for 2019 Attached are the budgets for the Other Funds (Special Revenue, Debt Service, Capital Projects, and Enterprise) for your consideration. The Council has reviewed the General Fund and will again in November or December. The Special Revenue, Debt Service, Capital Projects, and Enterprise funds have not been reviewed. Enterprise Funds The City 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 City adopted a base water charge or water availability charge in 2016. Staff is recommending that the base charge increase by $4 per quarter per connection. Variable rates would increase by a dime for 2019. Overall water rates would increase $1.93 per month or $23 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 City is planning major improvements to the water treatment plants and well control equipment beginning with design activities in 2019. Build out would occur in 2020 and 2021 with approximately 4.5 million in bonds to be issued in 2020 to pay for the project. The Sewer fund anticipates a 5% increase in user charges which will add $1.42 per month or $17 annually to a residential utility bill. Met Council Environmental Services (MCES) waste charges increased by 2.03% for 2019 Future increases of 4% for 2020, and 4% for 2021 will help stabilize the sewer fund. The Storm Water fund will have a proposed $1 per quarter or $4 per year increase in 2019. This will begin to fund the sediment removal from Silver View pond that will occur in approximately 2026 or later. 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 will have no increase in 2019. Capital Projects Funds There are a number of capital projects that are anticipated to occur in 2019, the most prominent is mill and overlay of Bronson Drive from Edgewood to Long Lake and Woodale Drive south of Mounds View Blvd. Improvements to the Police office space are also being considered. There is a $75,000 transfer budgeted in the General Fund for 2019 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 EDA levy not exceeding $100,000, a transfer from TIF 5 that is limited to 5% of the increment in TIF 5 (approx. $85,000) and a $50,000 transfer from the General Fund. Debt Service Fund This fund accounts for a tax levy to pay the debt service for the Public Works facility, the amounts correspond to principal and interest amounts due on February 1 and August 1 and are collected the year prior to the debt service payment. Staff would recommend that Council review the funds and make any recommendations that they may have. Respectfully Submitted, E Mark Beer, Finance Dir ctor 2 CITY OF MOUNDS VIEW, MINNESOTA Special Revenue Funds 2019 Budgets Combining Statement of Revenues and Expenditures and Net Changes in Fund Balances 3 Cable Community Lakeside Recycling TIF Total TV Forfeiture EDA Center Park Grant District #5 2019 2018 Revenues: Taxes 130,000 - 100,000 - - - 1,704,290 1,934,290 1,900,873 Intergovernmental: County grants - - - - - 31,455 - 31,455 31,455 Other local govt. - - - - 23,000 - - 23,000 23,000 Charges for services: Culture and recreation - - - 312,062 - - - 312,062 257,414 Miscellaneous: Fines - 2,000 - - - - - 2,000 2,000 Investment income - - - 300 200 - 3,000 3,500 3,600 Other - - - - 500 - - 500 250 Total revenues 130,000 2,000 100,000 312,362 23,700 31,455 1,707,290 2,306,807 2,218,592 Expenditures: Public safety Supplies - 2,700 - - - - - 2,700 1,100 Contractual services - 500 - - - - - 500 500 Capital outlay - - - - - - - - 5,500 Sanitation Personal services - - - - - 12,342 - 12,342 14,026 Supplies - - - - - 500 - 500 500 Contractual services - - - - - 18,613 - 18,613 16,929 Culture and recreation: Personal services 93,954 - - 50,703 4,205 - - 148,862 144,464 Supplies 4,250 - - 19,970 2,500 - - 26,720 26,677 Contractual services 45,579 - - 356,876 16,995 - - 419,450 389,380 Capital outlay 10,000 - - - - - - 10,000 207,545 Debt Service - - - 53,120 - - - 53,120 53,120 Economic development Personal services - - 111,990 - - - - 111,990 108,665 Supplies - - 600 - - - - 600 700 Contractual services - - 121,822 - - - 1,611,326 1,733,148 1,695,316 Capital outlay - - 50,000 - - - - 50,000 50,000 Total expenditures 153,783 3,200 284,412 480,669 23,700 31,455 1,611,326 2,588,545 2,714,422 Surplus of revenues over (under) expenditures (23,783) (1,200) (184,412) (168,307) - - 95,964 (281,738) (495,830) Other financing sources (uses) Transfers in - - 135,215 190,000 - - - 325,215 323,543 Transfers out - - - - - - (85,215) (85,215) (83,543) Total other financing sources (uses) - - 135,215 190,000 - - (85,215) 240,000 240,000 Net change in fund balance (23,783) (1,200) (49,197) 21,693 - - 10,749 (41,738) (255,830) Fund balance, January 1: 140,806 (2,288) 298,157 157,546 9,479 28,360 846,829 1,478,889 1,473,287 Fund balance, December 31 117,023 (3,488) 248,960 179,239 9,479 28,360 857,578 1,437,151 1,217,457 3 Cable TV (Fund 210): Revenues 3180 Franchise fee 3680 Other revenue Total revenue Operating expenses Operations (4350) Personnel services 0100 Salaries, regular 0300 Social security 0321 PERA 0400 Group insurance 0500 Workers compensation Total personnel services 2019 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budget Reciuest Dollar Percent 126,182 134,883 135,353 130,000 130,000 - 0.00% 2,400 1,200 - - - - 0.00% 128,582 136,083 135,353 130,000 130,000 - 0.00% 65,002 66,948 68,323 69,769 70,237 468 0.67% 4,813 4,884 4,995 5,338 5,373 35 0.66% 4,850 4,975 4,914 5,233 5,267 34 0.65% 10,747 11,099 11,355 12,600 12,794 194 1.54% 508 399 357 212 283 71 33.49% 85,920 88,305 89,944 93,152 93,954 802 0.86% Materials & supplies 1230 Supplies, equipment 428 - 5,085 3,000 3,000 - 0.00% 1600 Supplies, operating - - 19 1,250 1,250 - 0.00% Total materials & supplies 428 - 5,104 4,250 4,250 - 0.00% Contractual services 119,016 123,100 130,863 354,476 153,783 (200,693) -56.62% 3030 Other professional services 3,900 5,714 5,829 8,012 12,012 4,000 49.93% 3630 Training & conferences 200 313 680 950 1,000 50 5.26% 3800 Mileage & parking 8 3 8 50 50 - 0.00% 3900 Grants & subsidies 28,560 28,765 29,298 30,517 30,517 - 0.00% 5130 Repairs, equipment - - - 10,000 2,000 (8,000) -80.00% Total contractual services 32,668 34,795 35,815 49,529 45,579 (3,950) -7.98% Capital 7030 Equipment - - - 207,545 10,000 (197,545) -95.18% Total capital outlays - - - 207,545 10,000 (197,545) -95.18% Total expenditures 119,016 123,100 130,863 354,476 153,783 (200,693) -56.62% Net change in fund balance 9,566 12,983 4,490 (224,476) (23,783) 200,693 -89.41% Fund balance, beginning year 338,243 347,809 360,792 365,282 140,806 (224,476) -61.45% Fund balance, end of year $ 347,809 $ 360,792 $ 365,282 $ 140,806 $ 117,023 $ (23,783) -16.89% 34,795 40,919 261,324 59,829 4 Fund: 210 Cable TV Revenues Operations 1230 Account Description 2016 2017 2018 2019 Description 3180 Franchise fee revenue 122,000 126,000 122,000 126,000 130,000 130,000 Estimated collections 130,000 130,000 3680 Other revenue 2,400 - 2,400 - - - Lease revenue from Library fiber connection - - Fund: 210 Department: 4350 Operations 1230 Supplies, equipment < $5000 3,000 3,000 3,000 3,000 Equipment costing less than $5,000 per item 3,000 3,000 3,000 3,000 1600 Supplies, operating 1,250 250 1,000 250 400 850 400 850 Recording media - tapes, DVD's Batteries, cables, bulbs, tapes, misc 1,500 1,250 1,250 1,250 3030 Other professional services 7,200 - 7,200 6,000 - 6,000 6,012 2,000 8,012 6,012 6,000 12,012 Web streaming meetings $501 per month. (current $1502/qtr) Technical support (due to loss of 100 hrs program) 3630 Training & conferences 350 - 350 400 350 600 350 650 Attendance at local training ACM National Conference (free registration)(1/2 paid by Little Canada) 350 750 950 1,000 3800 Mileage & parking 50 50 50 50 Mileage 50 50 50 50 3900 Grants & subsidies 29,826 29,628 30,517 30,517 Share of costs of North Suburban Cable Commission 29,826 29,628 30,517 30,517 5130 Repairs, equipment 10,000 10,000 10,000 2,000 Repair and maintenance of equipment 10,000 10,000 10,000 21000 7030 Capital, equipment > $5000 - - - - 10,000 - - - - - 8,300 8,850 190,000 395 - - - 10,000 - Supplemental duct work/air conditioning Video Camera Video storage (NAS) Control room/Council chambers replacement Bulletin Board - 10,000 207,545 10,000 51,926 60,678 261,324 59,829 1.24% 16.85% 330.67% -77.11% 2019 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budget Request Dollar Percent Forfeiture (Fund 225): Revenues 3510 Ramsey Co Municipal Court 1,080 - - - - - #DIV/0! 3514 Forfeitures 12,668 6,405 17,027 2,000 2,000 - 0.00% Total revenue 13,748 6,405 17,027 2,000 2,000 - 0.00% (6,772) (37,378) (7,086) Operating expenses (4200): (1,200) 3,900 -76.47% 54,048 47,276 9,898 2,812 (2,288) (5,100) Materials & supplies 1230 Supplies, equipment 5,209 19,160 17,401 900 2,500 1,600 177.78% 1600 Supplies, operating 151 236 159 200 200 - 0.00% Total materials & supplies 5,360 19,396 17,560 1,100 2,700 1,600 145.45% Contractual services 3030 Other professional services 4,920 2,722 6,553 500 500 - 0.00% Total contractual services 4,920 2,722 6,553 500 500 - 0.00% Capital 7030 Equipment Total capital outlays Total expenses Net change in fund balance Fund balance, beginning year Fund balance, end of year 10,240 21,665 - 5,500 - (5,500) -100.00% 10,240 21,665 - 5,500 - (5,500) -100.00% 20,520 43,783 24,113 7,100 3,200 (3,900) -54.93% (6,772) (37,378) (7,086) (5,100) (1,200) 3,900 -76.47% 54,048 47,276 9,898 2,812 (2,288) (5,100) -181.36% 47,276 9,898 2,812 (2,288) (3,488) (1,200) 52.45% H. Fund: 225 Forfeiture Revenues Account Description 2016 2017 2018 2019 Description 3514 Forfeitures 5,500 5,500 2,000 2,000 Sale of forfeited vehicles at auction. 5,500 5,500 2,000 2,000 Fund: 225 Department: 4200 Operations 1230 Supplies -equipment < $5000 1,100 - - - Taser (4) - - - 2,500 Miscellaneous equipment 6,000 10,000 - - Body cameras and storage system 2,000 - - - K-9 additional vehicle set-up costs - 900 - Portable Breath Tester (PBT) 900 1,000 - - Long rifle 4,600 4,700 - - (2) Ballistic shields 1,500 1,000 - - Replacement Glock pistols (5) with trade-in 2,900 - - - Radar (included with vehicle purchase in equipment fund) 19,000 16,700 900 21500 1600 Supplies - operating 500 500 200 200 Supplies to prepare vehicles for auction. (tows, title fees, batteries) 500 500 200 200 3030 Other professional services 1,500 1,500 500 500 Share of auction costs. 1,500 1,500 500 500 7030 Equipment> $5000 10,000 - 5,500 - (1) In -squad cameras 15,000 - - - Stationary radar sign for County Rd I (Pinewood school) 25,000 - 5,500 - 46,000 125,-/UU /'1UU .S,zuu 33.72% -59.35% -62.03% -54.93% EDA (Fund 230): Revenues - - - - - 3101 Tax collections 3610 Investment income 3615 Interest received on notes 3680 Other revenue 3972 Transfers 0.00% Total revenue 2019 Budget Summary 2015 2016 2017 2018 2019 Chance from 2018 Actual Actual Actual Budget Request Dollar Percent - - 95,591 100,000 100,000 - 0.00% - - - - - - 0.00% 515 439 556 - - - 0.00% - - 3,000 - - - 0.00% 97,140 125,331 129,498 133,543 135,215 1,672 1.25% 97,655 125,770 228,645 233,543 235,215 1,672 0.72% Operating expenses Housing and Economic Development (4650): Personnel services 0100 Salaries, regular 0150 Salaries, part-time 0300 Social security 0321 PERA 0400 Group insurance 0500 Workers compensation Total personnel services Materials & supplies 7,155 7,459 7,674 81,726 83,984 2,258 2.76% 49,964 53,006 54,826 - - - 0.00% 4,302 4,511 4,671 6,252 6,425 173 2.77% 4,272 4,511 4,638 6,130 6,299 169 2.76% 9,705 9,812 10,166 14,106 14,692 586 4.15% 626 465 415 451 590 139 30.82% 76,024 79,764 82,390 108,665 111,990 3,325 3.06% 1600 Supplies, operating - - - 500 400 (100) -20.00% 2100 Book & periodicals - 139 139 200 200 - 0.00% Total materials & supplies - 139 139 700 600 (100) -14.29% Contractual services 3030 Other professional services 19,978 9,915 5,071 36,670 36,703 33 0.09% 3420 Advertisements - - - 1,500 1,500 - 0.00% 3430 Printing - - - 500 500 - 0.00% 3610 Memberships 510 595 415 710 710 - 0.00% 3630 Training & conferences 1,354 1,042 1,217 3,410 3,410 - 0.00% 3800 Mileage 316 265 - 350 350 - 0.00% 4800 Insurance 435 427 414 649 649 - 0.00% 5210 Housing improvement 144 559 1,909 50,000 50,000 - 0.00% 5220 Highway 10 redevelopment - - - 28,000 28,000 - 0.00% Total contractual services 22,737 12,803 9,026 121,789 121,822 33 0.03% Capital outlays 9300 Business subsidies - - - 50,000 50,000 - 0.00% Total expenditures 98,761 92,706 91,555 281,154 284,412 3,258 1.16% Net change in fund balance (1,106) 33,064 137,090 (47,611) (49,197) (1,586) 3.33% Fund balance, beginning year 49,154 48,048 208,678 345,768 298,157 (47,611) -13.77% Adj for land held for resale 127,566 Fund balance, end of year 48,048 208,678 345,768 298,157 248,960 (49,197) -16.50% Fund: 230 EDA Revenues Account Description 2016 2017 2018 2019 Description 3101 Tax revenue - 100,000 100,000 100,000 EDA/HRA Levy - 100,000 100,000 100,000 3972 Transfers 75,331 79,498 83,543 85,215 50,000 50,000 50,000 50,000 Transfers from TIF 5 Transfers from General Fund 125,331 129,498 133,543 135,215 MUM W.Al9izZ�AWWwK Fund: 230 Department: 4650 Housing and Economic Develo `went 1600 Supplies, operating 100 500 500 400 Misc office supplies 100 500 500 400 2100 Books & periodicals 230 200 200 200 Misc. reports & periodicals (Finance & Commerce) 230 200 200 200 3030 Other professional services - - 4,500 1,610 11,500 - 4,000 5,000 14,500 1,640 2,100 7,000 4,000 5,000 14,500 1,670 4,500 7,000 4,000 5,000 14,500 1,703 4,500 7,000 Legal fees for development reviews Financial consultant fees (Ehlers) Special project consultant fees 5% of audit (2019 - $34,065, 2020 - $34,745, 2021 - $35,440) Loan Program and Energy Audit Consultant (CEE) Marketing Consultant fees 17,610 1 34,240 36,670 36,703 3420 Advertising - 1,500 1,500 1 500 Targeted advertisements. - 1,500 1,500 1,500 3430 Printing 500 100 400 100 400 100 400 100 Property ad printing Misc printing 600 500 500 500 3610 Memberships 400 250 60 400 250 60 400 250 60 400 250 60 Economic Development Assoc of MN (EDAM) Twin Cities North Chamber of Commerce dues MN Assoc. of Govt. Communicators (MAGC) 710 710 710 710 3630 Training & conferences 535 275 600 581 535 275 600 2,000 535 275 600 2,000 535 275 600 2,000 IEDC Conference Minneapolis Ehlers Finance Seminar EDAM summer conference Other miscellaneous training 1,991 3,410 3,410 3,410 3800 Mileage 350 350 350 350 Misc. mileage 4800 Insurance 649 649 649 649 Allocation of the City's property & liability insurance 649 649 649 649 5210 Housing programs - - 50,000 50,000 Housing Improvement programs - - 50,000 50,000 5220 Highway 10 redevelopment - 27,755 28,000 28,000 Trailways & lighting in highway corridor, Gateway Signage - 27,755 28,000 28,000 9300 Business loans/subsidies - 50,000 50,000 50,000 Business improvement partnership loans/subsidies - 50,000 50,000 50,000 22,24U 119,2514 172,4259 172,422 35.04% 438.73% 43.96% -0.04% THIS PAGE LEFT BLANK INTENTIONALLY Ice 2019 Budget Summary 11 2015 2016 2017 2018 2019 Chanize from 2018 Actual Actual Actual Budget Request Dollar Percent Community Center (Fund 252): Building overhead (4350) Building overhead revenues 712,348 170,400 190,496 190,300 190,300 - 0.00% Building overhead expenditure 579,183 53,119 53,119 53,120 53,120 - 0.00% Net Building Overhead Operations 133,165 117,281 137,377 137,180 137,180 - 0.00% Banquet Center (4730): Banquet revenues 88,935 90,750 90,492 92,500 94,500 2,000 2.16% Banquet Center expenditures 120,327 127,718 124,418 125,939 133,423 7,484 5.94% Net Banquet Center (31,392) (36,968) (33,926) (33,439) (38,923) (5,484) 16.40% YMCA (4732): YMCA revenues 81,812 72,952 106,215 67,200 77,200 10,000 14.88% YMCA expenditures 240,024 236,080 208,466 225,221 260,046 34,825 15.46% Net YMCA (158,212) (163,128) (102,251) (158,021) (182,846) (24,825) 15.71% Office/Chamber space (4734): Office/Chamber revenues 7,450 8,500 8,795 8,362 8,362 - 0.00% Office/Chamber expenditures 6,135 5,570 4,819 4,625 5,217 592 12.80% Net Office/Chamber space 1,315 2,930 3,976 3,737 3,145 (592) -15.84% Creative Kids Child Care Center (4736): Creative Kids revenues 84,854 85,635 87,297 89,352 132,000 42,648 47.73% Creative Kids expenditures 40,236 36,049 33,480 34,255 28,863 (5,392) -15.74% Net Creative Kids 44,618 49,586 53,817 55,097 103,137 48,040 87.19% Total revenue 975,399 428,237 483,295 447,714 502,362 54,648 12.21% Total expenditures 985,905 458,536 424,302 443,160 480,669 37,509 8.46% Net change in fund balance (10,506) (30,299) 58,993 4,554 21,693 17,139 376.35% Fund balance, beginning year 134,804 124,298 93,999 152,992 157,546 4,554 2.98% Fund balance, end of year 124,298 93,999 152,992 157,546 179,239 21,693 13.77% (continued) 11 2019 Budget Summary Total building overhead reve 712,348 170,400 190,496 190,300 190,300 - 0.00% Operating expenses 2015 2016 2017 2018 2019 Chanize from 2018 Actual Actual Actual Budizet Request Dollar Percent Community Center (continued): 0100 Salaries, regular 40,341 41,258 23,428 Building overhead (4350) 32,308 2,298 7.66% 0110 Salaries,overtime 1,659 Building revenues: 575 1,217 1,311 94 7.72% 0300 3610 Investment income 378 263 57 300 300 - 0.00% 3680 Miscellaneous 6,943 137 439 - - - 0.00% 3972 Transfers 170,000 170,000 190,000 190,000 190,000 - 0.00% 3994 Capital lease proceeds 535,027 - - - - - 0.00% Total building overhead reve 712,348 170,400 190,496 190,300 190,300 - 0.00% Operating expenses Personnel services 0100 Salaries, regular 40,341 41,258 23,428 30,010 32,308 2,298 7.66% 0110 Salaries,overtime 1,659 1,535 575 1,217 1,311 94 7.72% 0300 Social Security 3,050 3,083 1,336 2,389 2,572 183 7.66% 0321 PERA 3,115 3,166 1,227 2,342 2,521 179 7.64% 0400 Group insurance 9,599 9,714 2,564 9,600 9,792 192 2.00% 0500 Workers compensation 3,278 2,357 2,104 1,602 2,199 597 37.27% 999 Allocation of salaries (61,042) (61,113) (31,234) (47,160) (50,703) (3,543) 7.51% Total personnel services - - - - - - 0.00% Materials & supplies 1210 Supplies, buildings & grounds 1,026 415 931 1,150 1,150 - 0.00% 1230 Supplies, equipment 149 75 474 800 4,300 3,500 437.50% 1600 Supplies, operating 8,191 8,120 9,276 7,800 7,800 - 0.00% 2400 Uniforms 468 590 144 470 470 - 0.00% 2410 Mats & towels 2,157 2,129 2,001 1,750 1,750 - 0.00% 2999 Allocation of supplies (11,991) (11,329) (12,826) (11,970) (15,470) (3,500) 29.24% Total materials & supplies - - - - - - 0.00% Contractual services 3030 Other professional services 12,480 13,930 20,252 13,750 13,750 - 0.00% 3100 Telephone 2,856 2,933 2,887 3,200 3,200 - 0.00% 3200 Water & sewer 10,196 8,709 8,598 9,000 9,000 - 0.00% 3210 Electricity 58,846 48,968 42,408 25,000 40,000 15,000 60.00% 3220 Natural gas 14,859 14,062 15,005 14,000 15,000 1,000 7.14% 3530 Refuse collection 3,299 3,114 4,230 4,024 4,204 180 4.47% 3630 Training & conferences 31 58 - - - - 0.00% 3999 Allocation of utilities (105,232) (91,774) (93,380) (68,974) (85,154) (16,180) 23.46% 5110 Repairs, building & grounds 16,030 6,779 6,723 9,770 9,770 - 0.00% 5130 Repairs, equipment 14,220 16,153 17,852 16,000 16,000 - 0.00% 5999 Allocation of repairs (27,585) (22,932) (24,575) (25,770) (25,770) - 0.00% Total contractual services - - - - - - 0.00% Capital 7030 Equipment 535,027 - - - - - 0.00% Total capital outlays 535,027 - - - - - 0.00% Debt service 8011 Lease payable -principal 31,205 38,582 39,752 40,957 42,199 1,242 3.03% 8021 Lease payable - interest 12,951 14,537 13,367 12,163 10,921 (1,242) -10.21% Total debt service 44,156 53,119 53,119 53,120 53,120 - 0.00% Total Building overhead exp 579,183 53,119 53,119 53,120 53,120 - 0.00% Total Building Overhead Net 133,165 117,281 137,377 137,180 137,180 - 0.00% (continued) 12 Fund: 252 Department: 4350 Community Center Building Overhead Expenditures Account Description 2016 2017 2018 2019 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 3,500 Small tools & equipment Drinking fountains 800 800 800 4,300 1600 Supplies, operating 7,500 7,500 7,800 7,800 Batteries, soap, paper towels, cleaning supplies for bathrooms Paper cups, plates, etc. for lounge & customer service events 7,500 7,500 7,800 7,800 2400 Uniforms 470 470 470 470 Uniforms/Clothing (7.3% of $4,500 +.8 FTE x $175) 470 470 470 2410 Mats & towels 1,000 250 1,500 250 1,500 250 Floor mats and cleaning towels to provide better protection of carpets Special events 1,250 1,750 11750 3030 Other professional services F1,750 800 200 11,000 1,750 800 200 11,000 1,750 800 200 11,000 1,750 Backflow inspection, alarm inspection, Sprinkler inspections Custodial services: 12 months $xxx Commercial carpet cleaning service (twice annually) 13,750 13,750 13,750 13,750 3100 Telephone & internet 3,200 3,200 3,200 3,200 Office & customer phones, internet, maintenance agreements, & repairs 3,200 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 91000 3210 Electricity 25,000 25,000 25,000 40,000 Estimated electrice charges 25,000 25,000 25,000 40,000 3220 Natural gas 9,000 9,000 14,000 15,000 Estimated natural gas charges 9,000 9,000 14,000 15,000 3530 Refuse collection 3,280 600 100 3,444 600 100 3,624 400 - 3,804 400 - Dumpsters $317 x 12 months Extra garbage pick-up charges Ramsey County recyclying fee 3,980 4,144 4,024 4,204 5110 Repairs, building & grounds 4,500 770 1,500 1,300 500 1,200 4,500 770 1,500 1,300 500 1,200 4,500 770 1,500 1,300 500 1,200 4,500 770 1,500 1,300 500 Repair floor tiles Exterior building maintenance Exterminator: 12 months X 64.02 Fire alarm system service Parking lot & grounds maintenance Security system service 8,570 9,770 9,770 9,770 5130 Repairs, equipment 11,000 - 1,500 11,000 - 1,500 11,500 3,000 1,500 11,500 3,000 1,500 HVAC system maintenance contract HVAC repairs Plumbing, electrical, & misc. interior maintenance 12,500 12,500 16,000 16,000 8011 8021 Lease payable (ESP) Interest 52,988 - 39,752 13,368 40,957 12,163 42,199 10,921 Lease payable for energy savings program 52,988 53,120 53,120 53,120 149,158 150,654 159,834 179,514 15.92% 1.00% 6.09% 12.31% 13 2019 Budget Summary 2015 2016 2017 2018 2019 Chanize from 2018 Actual Actual Actual Budget Request Dollar Percent Community Center (continued): Banquet Center (4730): Banquet Revenues 3634 Equipment rental 5,433 5,563 3,740 4,500 4,500 - 0.00% 3645 Rental - banquet facility 83,502 85,187 86,752 88,000 90,000 2,000 2.27% 0.00% Total banquet center revenue 88,935 90,750 90,492 92,500 94,500 2,000 2.16% Banquet Expenditures Personnel services 0999 Allocation of salaries 12,208 12,223 6,385 9,432 10,141 709 7.51% Total personnel services 12,208 12,223 6,385 9,432 10,141 709 7.51% Materials & supplies 1210 Supplies, buildings & grounds 1,586 - - - - - 0.00% 1230 Supplies, equipment 79 2,745 165 2,500 2,500 - 0.00% 1600 Supplies, operating - - 299 - - - 0.00% 2999 Allocation of supplies 3,357 3,172 3,591 4,332 4,332 (0) -0.01% Total materials & supplies 5,022 5,917 4,055 6,832 6,832 (0) -0.01% Contractual services 3030 Other professional services 63,944 74,815 78,328 76,252 78,498 2,246 2.95% 3420 Advertising - - 379 500 500 - 0.00% 3430 Printing - - - 250 250 - 0.00% 3999 Allocation of utilities 28,025 24,347 24,295 19,057 23,587 4,530 23.77% 4800 Bonding & insurance 1,408 1,380 1,339 2,100 2,100 - 0.00% 5110 Repairs, building & grounds 1,615 1,517 700 2,700 2,700 - 0.00% 5130 Repairs, equipment 381 1,098 2,056 1,600 1,600 - 0.00% 5999 Allocation of repairs 7,724 6,421 6,881 7,216 7,216 (0) -0.01% Total contractual services 103,097 109,578 113,978 109,675 116,451 6,776 6.18% 116,507 123,282 Capital 7030 Equipment Total capital outlays Total banquet center exp Total Banquet Center net 0.00% 0.00% 120,327 127,718 124,418 125,939 133,423 7,484 5.94% (31,392) (36,968) (33,926) (33,439) (38,923) (5,484) 16.40% (continued) 14 Fund; 252 Community,Center - 4730 Ban net Center Expenditures Account Description 2016 2017 2018 2019 Description 1230 Supplies, equipment 2,500 2,500 2,500 2,500 Tables, mirrors, microphones, projectors, etc. for Banquet Room 2,500 2,500 2,500 2,500 2999 Allocation of supplies 3,128 3,128 4,332 4,332 28% Allocation from overall building support 3,128 3,128 4,332 4,332 3030 Other professional services 790 2,000 55,139 1,250 3,600 500 820 2,000 56,241 1,250 3,600 500 835 2,500 58,667 1,750 12,000 500 852 2,500 60,896 1,750 12,000 500 2.5% of audit (2019 - $34,065, 2020 - $34,745, 2021 - $35,440) Miscellaneous professional services (linen service) Banquet facility management (21 % of 289,980) Carpet cleaning 2 x year Extra staff for large events Legal costs 63,279 64,411 76,252 78,498 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 17,644 17,690 19,057 23,587 28% Allocation from overall building utilities 17,644 17,690 19,057 23,587 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,500 5,000 1,500 1,200 1,500 1,200 1,500 Interior building repairs specific to the banquette center/center divider repairs Dance floor maintenance 2,700 6,500 2,700 2,700 5130 Repairs, equipment 1,600 1,600 1,600 1,600 Repairs to kitchen, audio system, and other banquette equipment 1,600 1,600 1,600 1,600 5999 Allocation of repairs 6,728 6,728 7,216 7 216 28% Allocation from overall building repairs 6,728 6,728 7,216 7,216 100,429 105,407 116,507 123,283 -7.81% 4.96% 10.53% 5.82% 15 2019 Budget Summary YMCA Expenditures Personnel services - 0999 Allocation of salaries 42,119 42,168 21,551 32,540 34,985 2,445 7.51% Total personnel services 42,119 42,168 21,551 32,540 34,985 2,445 7.51% Materials & supplies 1230 Supplies, equipment - 2,474 3 2,000 2,000 - 0.00% 2999 Allocation of supplies 5,996 5,665 6,413 7,735 7,735 - 0.00% Total materials & supplies 5,996 8,139 6,416 9,735 9,735 - 0.00% Contractual services 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budge Re uest Dollar Percent Community Center (continued): 3.66% 3300 Postage - - - - YMCA (4732): - 0.00% 3430 Printing 6,298 7,056 1,930 YMCA Revenues 7,200 - 0.00% 3999 Allocation of utilities 56,186 49,254 3405 Recreation profit 33,194 19,388 51,558 20,000 30,000 10,000 50.00% 3660 Gym & meeting room rental 26,607 30,113 16,499 27,000 25,000 (2,000) -7.41% 3661 Open gym participant fees 20,135 21,840 36,357 19,000 21,000 2,000 10.53% 3679 Commissions - vending 1,876 1,611 1,801 1,200 1,200 - 0.00% Total YMCA revenues 81,812 72,952 106,215 67,200 77,200 10,000 14.88% YMCA Expenditures Personnel services - 0999 Allocation of salaries 42,119 42,168 21,551 32,540 34,985 2,445 7.51% Total personnel services 42,119 42,168 21,551 32,540 34,985 2,445 7.51% Materials & supplies 1230 Supplies, equipment - 2,474 3 2,000 2,000 - 0.00% 2999 Allocation of supplies 5,996 5,665 6,413 7,735 7,735 - 0.00% Total materials & supplies 5,996 8,139 6,416 9,735 9,735 - 0.00% Contractual services 3030 Other professional services 106,225 107,786 109,051 115,789 120,032 4,243 3.66% 3300 Postage - - - - - - 0.00% 3430 Printing 6,298 7,056 1,930 7,200 7,200 - 0.00% 3999 Allocation of utilities 56,186 49,254 51,237 35,447 43,537 8,090 22.82% 4010 Rental, equipment 184 - - 250 20,297 20,047 8018.80% 4800 Bonding & insurance 2,699 2,644 2,567 4,025 4,025 - 0.00% 5110 Repairs, building & grounds 5,391 7,271 3,426 6,000 6,000 - 0.00% 5130 Repairs, equipment 1,134 296 - 1,350 1,350 - 0.00% 5999 Allocation of repairs 13,792 11,466 12,288 12,885 12,885 - 0.00% Total contractual services 191,909 185,773 180,499 182,946 215,326 32,380 17.70% 192,681 225,061 Total YMCA exp 240,024 236,080 208,466 225,221 260,046 34,825 15.46% Total YMCA net (158,212) (163,128) (102,251) (158,021) (182,846) (24,825) 15.71% (continued) 0 Fund: 252 Community Center - 4732 YMCA Expenditures Account Description 2016 2017 2018 2019 Description 1230 Supplies, equipment 500 2,000 2,000 2,000 Miscellaneous (Basketball portable hoop pads 2017) 500 2,000 2,000 2,000 2999 Allocation of supplies 5,585 5,585 7,735 7,735 50% Allocation from overall building support 5,585 5,585 7,735 7,735 3030 Other professional services 103,713 2,935 2,370 105,787 2,935 2,460 110,349 2,935 2,505 114,542 2,935 2,555 YMCA mgt. contract (other half of fee in recreation)(39.5% of $289,980) Copier ($2,100) Computer ($835) per agreement 7.5% of audit (2019 - $34,065, 2020 - $34,745, 2021 - $35,440) 109,018 111,182 115,789 120,032 3300 Postage 600 600 - - 50% of the cost of mailing the Mounds View Matters newsletter 600 600 - - 3430 Printing 6,600 6,600 7,200 7,200 50% of the cost of printing and mailing the Mounds View Matters newsletter 6,600 6,600 7,200 7,200 3999 Allocation of utilities 32,925 32,925 35,447 43,537 50% Allocation from overall building utilities 32,925 32,925 35,447 43,537 4010 Rental, equipment 250 - 250 - 250 - 250 20,047 Scissor lift rental Fitness equipment 250 250 250 20,297 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 2,000 2,000 3,000 2,000 2,000 1,500 1,000 3,500 1,500 1,000 3,500 General building repairs Interior improvements Gym floor resurfacing & maintenance 7,000 7,000 6,000 6,000 5130 Repairs, equipment - 500 850 - 500 850 - 500 850 - 500 850 Copier maintenance contract Registration system support Repairs to other equipment 1,350 1,350 1,350 1,350 5999 Allocation of repairs 13,393 13,393 12,885 12 885 50% Allocation from overall building repairs 13,393 13,393 12,885 1 12,885 181,246 184,910 192,681 225,061 -7.61% 2.02% 4.20% 16.80% 17 THIS PAGE LEFT BLANK INTENTIONALLY 18 2019 Budget Summary 2015 2016 2017 2018 2019 Chanize from 2018 Actual Actual Actual Budget Request Dollar Percent Office space (4734); Office space revenues 3999 Allocation of utilities 17,905 15,463 15,088 3633 Lease - Office/Chamber space 7,450 8,500 8,795 8,362 8,362 - 0.00% 8,268 7,894 8,750 - (8,750) Total office space revenues 7,450 8,500 8,795 8,362 8,362 - 0.00% 1,400 - 0.00% 5999 Allocation of repairs 5,241 Office space expenditures 4,669 4,896 4,896 0 0.01% Personnel services 32,731 29,008 28,544 27,543 21,868 0999 Allocation of salaries 1,831 1,833 937 1,415 1,521 106 7.50% Total personnel services 1,831 1,833 937 1,415 1,521 106 7.50% Materials & supplies 2999 Allocation of supplies Total materials & supplies Contractual services 3999 Allocation of utilities 5999 Allocation of repairs Total contractual services Total office space exp Total office space net 360 340 385 464 464 0 0.02% 360 340 385 464 464 0 0.02% 3,116 2,709 2,760 1,973 2,459 486 24.61% 828 688 737 773 773 0 0.01% 3,944 3,397 3,497 2,746 3,232 486 17.68% 0 6,135 5,570 4,819 4,625 5,217 592 12.80% 1,315 2,930 3,976 3,737 3,145 (592) -15.84% (continued) 2019 Budget Summary 2015 2016 2017 2018 2019 Chanj4efrom 2018 Actual Actual Actual Budget Re uest Dollar Percent Creative Kids Child Care (4736): Child Care Revenues 3632 Lease - Child Care 84,854 85,635 87,297 89,352 132,000 42,648 47.73% Total child care revenues 84,854 85,635 87,297 89,352 132,000 42,648 47.73% Child Care Ed Expenditures (19%) Personnel services 0999 Allocation of salaries 4,883 4,889 2,499 3,773 4,056 283 7.51% Total personnel services 4,883 4,889 2,499 3,773 4,056 283 7.51% Materials & supplies 1600 Supplies, operating 344 - - - - - 0.00% 2999 Allocation of supplies 2,278 2,152 2,437 2,939 2,939 0 0.01% Total materials & supplies 2,622 2,152 2,437 2,939 2,939 0 0.01% Contractual services 3999 Allocation of utilities 17,905 15,463 15,088 12,497 15,571 3,074 24.60% 4750 Taxes, licenses, & fees 8,646 8,268 7,894 8,750 - (8,750) -100.00% 4800 Bonding & insurance 939 920 893 1,400 1,400 - 0.00% 5999 Allocation of repairs 5,241 4,357 4,669 4,896 4,896 0 0.01% Total contractual services 32,731 29,008 28,544 27,543 21,868 (5,675) -20.61% Total child care exp 40,236 36,049 33,480 34,255 28,863 (5,392) -15.74% Total child care net 44,618 49,586 53,817 55,097 103,137 48,040 87.19% W 2019 Budget Summary 2015 2016 2017 2018 2019 Chane from 2018 Actual Actual Actual Budget Request Dollar Percent Lakeside Park (Fund 255): Revenues 3370 Spring Lake Pk contribution 11,500 11,500 11,500 11,500 11,500 - 0.00% 3370 Mounds View contribution 11,500 11,500 11,500 11,500 11,500 - 0.00% 3610 Investment income 132 142 226 300 200 (100) -33.33% 3665 Park site permit 921 789 1,231 250 500 250 100.00% Total revenue 24,053 23,931 24,457 23,550 23,700 150 0.64% Operating expenses (4350): Personnel services 0150 Salaries, part-time 2,079 2,805 1,785 3,680 3,680 - 0.00% 0300 Social security 159 214 137 282 282 - 0.00% 0500 Workers compensation 202 189 196 190 243 53 27.89% Total personnel services 2,440 3,208 2,118 4,152 4,205 53 1.28% Materials & supplies 1210 Supplies, bldgs & grounds - 1,612 2,875 1,100 1,700 600 54.55% 1600 Supplies, operating 928 644 539 1,357 800 (557) -41.05% Total materials & supplies 928 2,256 3,414 2,457 2,500 43 1.75% Contractual services 3200 Water & sewer 2,090 2,812 2,549 1,800 2,400 600 33.33% 3210 Electricity 1,262 1,106 1,140 1,400 1,300 (100) -7.14% 3530 Refuse collection - - - 75 75 - 0.00% 4010 Equipment Contribution SLP 4,986 4,986 5,036 4,600 4,800 200 4.35% 4030 Satellites 1,487 819 680 650 700 50 7.69% 4800 Insurance 4,608 4,488 4,558 4,800 4,800 - 0.00% 5130 Repairs, equipment 2,795 - 3,541 3,616 2,920 (696) -19.25% Total contractual services 17,228 14,211 17,504 16,941 16,995 54 0.32% Total expenses Net change in fund balance Fund balance, beginning year Fund balance, end of year 20,596 19,675 23,036 23,550 23,700 150 0.64% 3,457 4,256 1,421 - - - 0.00% 345 3,802 8,058 9,479 9,479 - 0.00% 3,802 8,058 9,479 9,479 9,479 - 0.00% 20 Fund: 255 Lakeside Park Department: 4350 Revenues Account Description 2016 2017 2018 2019 Description 3370 Contributions 11,500 11,500 11,500 11,500 Spring Lake Park contribution for half of cost for joint park 1,800 1,500 11,500 11,500 11,500 11,500 3370 Contributions 11,500 11,500 11,500 11,500 Mounds View contribution for half of cost for joint park 2,400 Estimated water & sewer charges 11,500 11,500 11,500 11,500 3610 Interest revenue 300 300 300 250 Estimated interest earnings at 1.25%. 1,300 3530 300 300 300 250 3680 Park site rental 250 250 250 500 Rental of the park by groups or individuals 4,600 4,600 250 250 250 500 Fund: 255 Department: 4350 Expenditures 1210 Supplies, bldgs & grounds 1,200 1,100 1,100 1,700 Paper, sand, etc. 1,200 1,100 1,100 1,700 1600 Supplies, operating 1,800 1,500 1,357 800 Fertilizer & pesticides 1,800 1,500 1,357 800 3200 Water & sewer 1,600 1,800 1,800 2,400 Estimated water & sewer charges 1,600 1,800 1,800 21400 3210 Electricity 1,600 1,400 1,400 1,300 Estimated electric charges 1,600 1,400 1,400 1,300 3530 Refuse collection 75 75 75 75 Six months service 75 75 75 75 4010 Equipment, capital charge 4,600 4,600 4,600 4,800 Capital charge for usage of SLP city equipment 4,600 4,600 4,600 4,800 4030 Satellites 500 650 650 700 Five months service 500 650 650 700 4800 Insurance & bonds 4,800 4,800 4,800 4,800 Property & liability insumace 4,800 4,800 4,800 4,800 5130 Repairs, equipment 3,592 3,616 3,616 2 920 Repair of equipment at the park 3,592 3,616 3,616 2,920 1`l,"/6/ 19,J41 19,.i`J2S 1Y,4VD 0.00% -1.14% -0.73% 0.50% 21 2019 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budge Re uest Dollar Percent Recycling (Fund 290): Revenues 3360 Other County grants 31,877 20,202 33,345 31,455 31,455 - 0.00% 3610 Investment income 51 3 3 - - - 0.00% Total revenue 31,928 20,205 33,348 31,455 31,455 - 0.00% Operating expenses Operations (4420) Personnel services 0100 Salaries, regular 10,036 8,997 8,206 10,583 9,086 (1,497) -14.15% 0110 Salaries, overtime 281 350 - - - - 0.00% 0300 Social security 772 636 611 810 695 (115) -14.20% 0321 PERA 734 600 616 794 681 (113) -14.23% 0400 Group insurance 524 431 1,577 1,764 1,799 35 1.98% 0500 Workers compensation 101 79 71 75 81 6 8.00% Total personnel services 12,448 11,093 11,081 14,026 12,342 (1,684) -12.01% Materials & supplies 1600 Supplies, operating - - - 500 500 - 0.00% Contractual services 3300 Postage 5,069 5,154 1,004 2,200 2,200 - 0.00% 3420 Advertisements - 1,208 - - - - 0.00% 3430 Printing 2,912 655 1,720 2,500 2,500 - 0.00% 3530 Refuse collection 4,439 9,453 5,394 12,229 13,913 1,684 13.77% Total contractual services 12,420 16,470 8,118 16,929 18,613 1,684 9.95% Total expenses 24,868 27,563 19,199 31,455 31,455 - 0.00% Net change in fund balance 7,060 (7,358) 14,149 - - - 0.00% Fund balance, beginning year 14,509 21,569 14,211 28,360 28,360 - 0.00% Fund balance, end of year 21,569 14,211 28,360 28,360 28,360 - 0.00% 17,429 19,113 22 Fund: 290 Recycling Grant Revenues Account Description 2016 2017 2018 2019 Description 3360 Other grants & aid 30,220 32,284 31,455 31,455 Estimated Ramsey County recycling grant 30,220 32,284 31,455 31,455 Fund: 290 Department: 4420 Expenditures 1600 Supplies, operatin 1,000 500 500 500 1,000 500 500 500 3300 Postage 5,000 5,000 2,200 2,200 City wide mailing for Cleanup Day, Newsletter, organics 5,000 5,000 2,200 2,200 3430 Printing 500 500 500 500 Articles in City newsletter 500 1,000 2,000 2,000 Clean-up Day and Organics printing of direct mailing items 1,000 1 1,500 2,500 2,500 3530 Refuse collection 9,751 1 11,484 12,229 13,913 Recycling collections CH, CC, Festival, and Parks, Spring Clean-up Day 9,751 1 11,484 12,229 13,913 16,751 18,484 17,429 19,113 -13.16% 10.35% -5.71% 9.66% 23 2019 Budget Summary Operating expenses (4650): 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budget Request Dollar Percent TIF # 5 (Fund 450): 3030 Other professional 2,924 5,095 3,216 5,060 Revenues 63 1.25% 8010 Developer PAG, principal 231,283 309,984 416,419 3101 Tax collections 1,441,945 1,555,581 1,630,140 1,670,873 1,704,290 33,417 2.00% 3610 Investment income 2,738 2,335 3,047 3,000 3,000 - 0.00% Total revenue 1,444,683 1,557,916 1,633,187 1,673,873 1,707,290 33,417 2.00% Operating expenses (4650): Contractual services 3030 Other professional 2,924 5,095 3,216 5,060 5,123 63 1.25% 8010 Developer PAG, principal 231,283 309,984 416,419 - - - 0.00% 8020 Developer PAG, interest 1,125,867 1,113,841 1,096,798 1,568,467 1,606,203 37,736 2.41% 9900 Transfers out to EDA 72,863 75,331 79,498 83,543 85,215 1,672 2.00% Total contractual services 1,432,937 1,504,251 1,595,931 1,657,070 1,696,541 39,471 2.38% Net change in fund balance 11,746 53,665 37,256 16,803 10,749 (6,054) -36.03% Fund balance, beginning year 727,359 739,105 792,770 830,026 846,829 16,803 2.02% Fund balance, end of year 739,105 792,770 830,026 846,829 857,578 10,749 1.27% 24 Fund: 450 TIF District #5 Revenues Account Description 2016 2017 2018 2019 Description 3101 Tax increment collections 1,555,982 1,555,982 1,631,162 1,631,162 1,670,873 1,670,873 1,704,290 Estimated collections of incremental taxes on properties in the district 1,704,290 3610 Investment income 4,000 4,000 3,000 3,000 3,000 3,000 3,000 Estimated interest earnings at 1.00%. 3,000 Fund: 430 Department: 4650 Economic Development', 3030 Other professional services 3,420 1,580 3,420 1,640 3,420 1,640 3,420 1,703 TIF administration and reporting fees 5% of audit (2019 - $34,065, 2020 - $34,745, 2021 - $35,440) 5,000 5,060 5,060 5,123 8010 Pay-as-you-go principal 1,431,290 1,513,894 1,568,467 1,606,203 Principal on a revenue note issued to promote a development. (Medtronic) 1,431,290 1,513,894 1,568,467 1,606,203 9900 Transfer out to EDA Fund 1 75,331 79,498 83,543 85,215 Transfer to cover the EDA operating budget. 75,331 79,498 83,543 85,215 25 CITY OF MOUNDS VIEW, MINNESOTA Debt Service Fund 2019 Budgets Combining Statement of Revenues and Expenditures Revenue: Taxes: Property taxes Miscellaneous: Investment income Total revenue Expenditures: Debt service: Principal Interest Paying agent fees Continuing disclosure fees Total expenditures Surplus of revenue over (under) expenditures Net change in fund balance Fund balance, January 1 Fund balance, December 31 GO CIP Bonds Total 2017A 2019 2018 418,446 418,446 415,034 200 200 200 418,646 418,646 415,234 22500 22500 - 166,895 166,895 211,419 475 475 475 1,000 1,000 2,000 393,370 393,370 213,894 25,276 25,276 201,340 25,276 25,276 201,340 328,624 328,624 - 353,900 353,900 201,340 2019 Budget Summary Operating expenses (4650): 328,624 25,276 2018 2019 Change from 2018 328,624 0.00% Fund balance, end of year Budget Request Dollar Percent GO Capital Imp. Plan Bonds of 2017A Debt Service (Fund 506): 166,895 Revenues 8030 Paying agent 475 475 - 0.00% 8040 Continuing disclosure 3101 Property taxes 4153034 418,446 3,412 0.82% 3102 Delinquent taxes - - - 0.00% 3121 Fiscal disparities - - - 0.00% 3610 Investment income 200 200 - 0.00% 3680 Misc revenue - - - 0.00% 3972 Transfers 126,284 - (126,284) -100.00% 3993 Bond proceeds - - - 0.00% Total revenue 541,518 418,646 (122,872) -22.69% Operating expenses (4650): 328,624 25,276 (303,348) -92.31% Fund balance, beginning year Contractual services 328,624 0.00% Fund balance, end of year 328,624 353,900 8010 Debt, principal - 225,000 225,000 0.00% 8020 Debt, interest 211,419 166,895 (44,524) -21.06% 8030 Paying agent 475 475 - 0.00% 8040 Continuing disclosure 1,000 1,000 - 0.00% Total contractual services 212,894 393,370 180,476 84.77% Net change in fund balance 328,624 25,276 (303,348) -92.31% Fund balance, beginning year - 328,624 328,624 0.00% Fund balance, end of year 328,624 353,900 25,276 7.69% 27 THIS PAGE LEFT BLANK INTENTIONALLY CITY OF MOUNDS VIEW, MINNESOTA Capital Project Funds 2019 Budgets Combining Statement of Revenues and Expenditures 29 Park Vehicle and Special Street Total Budget Dedication Equipment Projects Improvement 2019 2018 Revenue: Taxes $ - $ - $ - $ 150,000 $ 150,000 $ - Franchise fees - - - 295,000 295,000 290,000 Special assessments - - - 15,000 15,000 20,000 Intergovernmental: State - - - 275,000 275,000 275,000 County - - - - - - Miscellaneous: Investment income 1,000 - 2,000 8,000 11,000 19,000 Other 3,000 - - - 3,000 3,000 Total revenue 4,000 - 2,000 743,000 749,000 607,000 Expenditures: General government - 20,500 413,058 - 433,558 40,000 Public safety - 111,000 - - 111,000 84,600 Streets and highways - 63,000 143,340 1,118,000 1,324,340 2,542,000 Culture and recreation 83,500 105,500 - - 189,000 320,000 Total expenditures 83,500 300,000 556,398 1,118,000 2,057,898 2,986,600 Excess (deficiency) of revenue over expenditures (79,500) (300,000) (554,398) (375,000) (1,308,898) (2,379,600) Other financing sources (uses) Operating transfers Bonds issued - - - - - - Transfers in - 436,000 75,000 - 511,000 471,000 Transfers out - (123,000) - - (123,000) (148,284) Total other financing sources (uses) - 313,000 75,000 - 388,000 322,716 Net change in fund balance (79,500) 13,000 (479,398) (375,000) (920,898) (2,056,884) Fund balance, January 1 22,739 1,657,813 577,345 1,053,752 3,311,649 4,142,040 Fund balance, December 31 $ (56,761) $ 1,670,813 $ 97,947 $ 678,752 $ 2,390,751 $ 2,085,156 29 2018 Budget Summary Operating expenses 2015 2016 2017 2018 2019 Chante from 2018 7050 Construction 1230 Supplies, equip. < $5,000 Actual Actual Actual Budget Reclues Dollar Percent Park Dedication (Fund 451): - - 0.00% - 32,700 Contractual services 83,500 (236,500) Revenues - 23,307 - - - - 0.00% 5110 Repairs, Buildings & Grounds - 23,707 - - - - 0.00% Total contractual services - 47,014 - - 3610 Investment income 5,037 4,334 4,762 2,000 1,000 (1,000) -50.00% 3650 Park donations 15,085 - - - - - 0.00% 3652 Park dedication fees - 1,082 - 3,000 3,000 - 0.00% -349.63% Total revenue 20,122 5,416 4,762 5,000 4,000 (1,000) -20.00% Operating expenses Operations (4350): Materials & supplies 7050 Construction 1230 Supplies, equip. < $5,000 - - 2,304 - - - 0.00% 1600 Supplies, operating - 3,973 34,126 - - - 0.00% Total materials & supplies - 3,973 36,430 - - - 0.00% - 32,700 Contractual services 83,500 (236,500) 3030 Other professional services - 23,307 - - - - 0.00% 5110 Repairs, Buildings & Grounds - 23,707 - - - - 0.00% Total contractual services - 47,014 - - - - 0.00% Capital 7050 Construction 67,380 - 32,700 320,000 83,500 (236,500) -73.91% Total capital outlays 67,380 - 32,700 320,000 83,500 (236,500) -73.91% Total expenses 67,380 50,987 69,130 320,000 83,500 (236,500) -73.91% Net change in fund balance (47,258) (45,571) (64,368) (315,000) (79,500) 235,500 -74.76% Fund balance, beginning year 494,936 447,678 402,107 337,739 22,739 (315,000) -93.27% Fund balance, end of year $ 447,678 $ 402,107 $ 337,739 $ 22,739 $ (56,761) $ (79,500) -349.63% 30 Fund: 451 Park Dedication Fund 7050 Construction > $25000 20,000 Revenues Account Description 2016 2017 2018 2019 Description 3610 Investment income 2,000 2,000 2,000 2,000 2,000 2,000 1,000 Estimated interest earnings at 1%. 1,000 3652 Park dedication fees 6,000 6,000 3,000 3,000 3,000 3,000 3,000 Developer payments 3,000 Fund: 451 ,Department: 4170 Expenditures -,,- x enditures7050 7050 Construction > $25000 20,000 - - - Random Park Building interior remodeling 25,000 - - - Roofing shelters - - 70,000 - City Hall Park redesign ? 50,000 - - - Groveland Park Improvements - 25,000 - - Disk golf course improvements at Silverview Park - 15,000 - - Irrigation improvements S ilverview Park - 60,000 250,000 - Greenfield basketball and tennis courts - resurface - 14,850 - - Hillview hockey rink - - - 58,500 2 park shelters (splash pad) - - 25,000 Silver View Park Shelter remodel - - - - Greenfield Park Playground (2020) 95,000 114,850 320,000 83,500 31 2018 Budget Summary Expenditures 2015 2016 2017 2018 2019 Chanize from 2018 9900 Transfer out - Sewer Actual Actual Actual Budget Request Dollar Percent Vehicle & Equipment (Fund 460): 7030 Equipment - - - - 20,500 20,500 0.00% Total Central Services Revenues - - 20,500 20,500 0.00% Police (4200): 3972 Transfers in - General fund 110,000 150,000 250,000 250,000 286,000 36,000 14.40% 3972 Transfers in - Water - - - 66,000 67,000 1,000 1.52% 3972 Transfers in - Sewer 53,000 42,000 38,000 48,000 52,000 4,000 8.33% 3972 Transfers in - Storm Water 71,000 32,000 32,000 32,000 31,000 (1,000) -3.13% 12,300 Total revenue 234,000 224,000 320,000 396,000 436,000 40,000 10.10% Expenditures 9900 Transfer out - General Fund 21,000 22,000 21,600 22,000 23,000 1,000 4.55% 9900 Central Services (4160): - - 35,000 - - - 0.00% 9900 Transfer out - Sewer - 60,000 - - 100,000 100,000 0.00% 9900 Capital 210,000 - - - - - 0.00% Total other 231,000 82,000 56,600 22,000 123,000 101,000 459.09% 7030 Equipment - - - - 20,500 20,500 0.00% Total Central Services - - - - 20,500 20,500 0.00% Police (4200): Materials & supplies 1230 Supplies, equip < $5,000 - 2,402 5,075 - - - 0.00% 3030 Other professional services - 2,535 4,820 - - - 0.00% Capital 7030 Equipment - - - - 14,100 14,100 0.00% 7040 Vehicles 57,947 79,444 62,322 84,600 96,900 12,300 14.54% Total Police 57,947 84,381 72,217 84,600 111,000 26,400 31.21% Park and rec (4360): Capital 7030 Equipment 93,649 10,931 7,800 - 51,500 - 0.00% 7040 Vehicles - - - - 54,000 54,000 0.00% Total Park and rec 93,649 10,931 7,800 - 105,500 54,000 0.00% PW Streets (4470): Capital 7030 Equipment - - - - 13,000 - 0.00% 7040 Vehicles - 15,519 186,356 - 50,000 50,000 0.00% Total PW Streets - 15,519 186,356 - 63,000 50,000 0.00% Other (4160): 9900 Transfer out - General Fund 21,000 22,000 21,600 22,000 23,000 1,000 4.55% 9900 Transfer out - Water - - 35,000 - - - 0.00% 9900 Transfer out - Sewer - 60,000 - - 100,000 100,000 0.00% 9900 Transfer out - Storm Water 210,000 - - - - - 0.00% Total other 231,000 82,000 56,600 22,000 123,000 101,000 459.09% Total expenditures 382,596 192,831 322,973 106,600 423,000 251,900 236.30% Net change in fund balance (148,596) 31,169 (2,973) 289,400 13,000 (276,400) -95.51% Fund balance, beginning year 1,488,813 1,340,217 1,371,386 1,368,413 1,657,813 289,400 21.15% Fund balance, end of year 1,340,217 1,371,386 1,368,413 1,657,813 1,670,813 13,000 0.78% 32 Fund: 460 Vehicle & Equipment Fund Revenues Account Description 2016 2017 2018 2019 Description 3961 Transfers in 150,000 64,000 42,000 32,000 175,000 64,000 38,000 32,000 250,000 66,000 48,000 32,000 286,000 67,000 52,000 31,000 From General Fund ($286,000 5yr Fin Plan) From Water Fund From Sanitary Sewer Fund From Storm Water Fund 288,000 309,000 396,000 436,000 Fund: 460 Department: 4160 Central Services Operations 7030 Equipment > $5000 - - - 20,500 Copiers (3) add pw in 2024 - - - 20,500 Fund: 460 Department: 4200 Police Operations 7030 Equipment > $5000 10,000 - - - - - - 14,100 - - - - Radar trailer Squad mobile computers, mounts, and antennas (3) (25) 800 Mhz radios ($101,000 in 2020 or 202 1) 10,000 - - 14,100 7040 Vehicles 74,000 77,300 84,600 96,900 (2) Squads $27,500, (2) setup $10,000, (2) radio $3,800, (2) cameras $5,500, (1) radar $3,300 74,000 77,300 84,600 96,900 Fund: 460 Department: 4360 Parks Operations 7030 Equipment > $5000 8,000 9,000 - 40,000 10,000 - - - - - - 11,500 Utility cart (Drag, paint arm, brush attachment) Engine for parks mower CH & CC mower ($13,500 Walker MTGHS mower move to 2019?) 18,000 9,000 - 51,500 7040 Vehicles - - - 54,000 Parks maint 1 ton pick-up - - - 54,000 Fund: 460 Department: 4470 PavementManagement Operations 7030 Equipment > $5000 - - 20,000 - - - - 13,000 Compactor Sweeper/Scrubber (new item) - 20,000 - 13,000 7040 Vehicles - - 34,000 125,000 - - 50,000 - Street maint 1 ton pick-up Dump truck ($160,000 net of trade-in $35,000) - 159,000 - 50,000 9900 Transfers out 22,000 - 83,000 - 21,600 - - 35,000 22,000 - - - 23,000 100,000 - - Various equipment purchases general fund Sewer Televising equipment Sewer - Generator lift station (natural gas) Water - (1/2 ton truck 4x4 ($35,000) 105,000 56,600 22,000 123,000 33 2018 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budget Request Dollar Percent Special Projects (Fund 480): Revenues 3553 Spec assessmt penalty & inter( - 256 - - - - 0.00% 3610 Investment income 12,483 11,171 34,655 2,000 2,000 - 0.00% 3972 Transfers in 200,000 375,000 275,000 75,000 75,000 - 0.00% 3993 Bond sales - - 6,114,203 - - - 0.00% Total revenue 212,483 386,427 6,423,858 77,000 77,000 - 0.00% Operating expenses Operations (4160): Materials & supplies 1230 Supplies, equipment < $5,000 - - 9,570 - - - 0.00% Total materials & supplies - - 9,570 - - - 0.00% Contractual services (4160) 3030 Other professional services - - - - 23,000 23,000 0.00% 5130 Repairs; Equipment - 3,679 - - - - 0.00% Total contractual services - 3,679 - - 23,000 23,000 0.00% Capital (4160) 7030 Capital equipment - - - - 54,950 54,950 - 7050 Construction - 198,413 - - 335,108 335,108 - Total capital outlays - 198,413 - - 390,058 390,058 - Contractual services (4180) 3030 Other professional services 4,763 4,624 42,561 40,000 - (40,000) -100.00% 5130 Repairs; Equipment 1,833 - 19,395 - - - 0.00% Total contractual services 6,596 4,624 61,956 40,000 - (40,000) -100.00% Capital (4180) 7030 Capital equipment 7050 Construction Total capital outlays Capital (4470) 7030 Capital equipment 7050 Construction Total capital outlays Other 8050 Issuance costs - debt service 9900 Transfer out Total other Total expenses Net change in fund balance - 44,462 116,677 66,000 - (66,000) -100.00% 79,600 407,896 19,498 726,000 - (726,000) -100.00% 79,600 452,358 136,175 792,000 - (792,000) -100.00% - - 143,340 143,340 0.00% - 5,415,082 300,000 - (300,000) -100.00% - 5,415,082 300,000 143,340 (156,660) -52.22% 86,805 - - - 0.00% - 126,284 - (126,284) -100.00% 86,805 126,284 - (126,284) -100.00% 86,196 659,074 5,709,588 1,258,284 556,398 (701,886) -55.78% 126,287 (272,647) 714,270 (1,181,284) (479,398) 701,886 -59.42% Fund balance, beginning year 1,190,719 1,317,006 1,044,359 1,758,629 577,345 (1,181,284) -67.17% Fund balance, end of year 1,317,006 1,044,359 1,758,629 577,345 97,947 (479,398) -83.03% 34 Fund: 480 Special Projects Expenditures 3030 Other professional services Revenues Account Description 2016 2017 2018 2019 Description 3610 Investment income 6,000 6,000 4,000 4,000 2,000 2,000 2,000 Estimated interest earnings at I%. 2,000 3972 Transfers in 75,000 75,000 75,000 75,000 75,000 75,000 75,000 Transfer from General Fund 75,000 3993 JBond proceeds - - 7,500,000 7,500,000 - - - G.O. Bonds for PW facility - Fund: 480 De artnent: 4180 Expenditures 3030 Other professional services - - 20,000 - CC upgrades (4 more cameras, dividers, bleechers, curtain repairs) - 16,000 10,000 - Siren upgrades (2 sirens)(Bronson, Mustang Circle) - 15,000 - - Security fence for PD parking lot - - - 8,000 CC Dividers - - 10,000 - Roof management survey - - - 15,000 Trench Drian PW Shop - - - - Interior painting Police Department - 31,000 40,000 23,000 7030 Capital, equipment > $5000 - - - 20,000 Purchase copiers (3) Main copier, police, comm dev/finance (replace 2019) 10,000 10,000 10,000 10,000 Park building video and door lock improvements 30,000 - - - Video and Security improvements for CH and CC (BBC grant of $2,000) 8,250 - - - Road sensors 3 locations 11,450 - 18,000 24,950 Automatic Transfer switch (City Hall generator)(defer to 2019) 3,150 - - - Upgrade CH electrical panel - - 38,000 - Audio Visual upgrades for Banquet Center - - - 43,340 PW Bldg cameras, floor sealing, security system - 100,000 - 100,000 City monument sign County H round -about gateway - 50,000 - - Website 62,850 160,000 66,000 198,290 7050 Construction > $25000 40,000 - - - Comm. Center relocate entrance sign (carryover from 2007) 200,000 7,000,000 300,000 - PW Building Project (design phase)(construction in 2017) 375,000 - - - Pathway rehabilitation program (Silver View Park) 200,000 250,000 483,000 - Splash Pad - - 218,000 - City Hall Park redesign - 37,027 - 43,553 CC HVAC Improvements (RTU -4,7 and VAV's) - - - 8,555 DP swithches CH & CC - - - - Remodel prep kitchen - - 25,000 26,000 CommCtr restrooms in gym locker rooms 40,000 - - - Remodel /Expand exercise area ($40,000 to 2016) - - - Remodel Comm Ctr Admin offices - - - 257,000 Remodel PD and Basement 855,000 7,287,027 1,026,000 335,108 9900 Transfer to Debt Service Fund - - 126,284 - February Interest Payment on PW CIP Bonds - - 126,284 - 35 2018 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budget Re uest Dollar Percent Street Improvement (Fund 485): Revenues 3101 Property taxes 302,050 211,317 283,108 - 150,000 150,000 0.00% 3180 Franchise fee 309,039 296,173 309,303 290,000 295,000 5,000 1.72% 3352 MSA street construction 323,342 364,924 363,357 275,000 275,000 - 0.00% 3370 Other local government revem - 126,323 - - - - 0.00% 3550 Spec assessmt prepayment 62,890 37,960 23,774 20,000 15,000 (5,000) -25.00% 3610 Investment income 70,636 48,172 38,102 15,000 8,000 (7,000) -46.67% 3680 Other revenue 3,235 5,306 66 - - - 0.00% 3972 Transfer from other funds 215,000 218,125 - - - - 0.00% Total revenue 11286,192 1,308,300 1,017,710 600,000 743,000 143,000 23.83% Operating expenses Operations (4470): Materials & supplies 1600 Supplies, operating - - 2,104 - - - 0.00% Total materials & supplies - - 2,104 - - - 0.00% Contractual services 3030 Other professional services - 17,918 250,821 - - - 0.00% 5220 Mounds View Blvd Imp. - 27,128 - - - - 0.00% Total contractual services - 45,046 250,821 - - - 0.00% Capital 7050 Construction Total capital outlays Total expenses Net change in fund balance Fund balance, beginning year Fund balance, end of year 3,031,842 3,881,294 1,686,518 1,450,000 1,118,000 (332,000) -22.90% 3,031,842 3,881,294 1,686,518 1,450,000 1,118,000 (332,000) -22.90% 3,031,842 3,926,340 1,939,443 1,450,000 1,118,000 (332,000) -22.90% (1,745,650) (2,618,040) (921,733) (850,000) (375,000) 475,000 -55.88% 7,189,175 5,443,525 2,825,485 1,903,752 1,053,752 (850,000) -44.65% $5,443,525 $2,825,485 $1,903,752 $1,053,752 $ 678,752 $ (375,000) -35.59% Fund: 485 Street Improvement Department:447Q,,,- Revenues Account Description 2016 2017 2018 2019 Description 3101 Property taxes 300,000 300,000 - 150,000 General tax levy for streets 300,000 300,000 - 150,000 3180 Franchise fee 265,000 280,000 290,000 295,000 Half of the 4% franchase fee on gas & electric utilities 265,000 280,000 290,000 295,000 3352 MSA Street Construction 275,000 275,000 275,000 275,000 State aid funds 275,000 275,000 275,000 275,000 3360 Other County grants 39,300 39,300 - - County trail grants (carryover) 39,300 39,300 - - 3550 Special assessments 20,000 20,000 20,000 15,000 Special assessments on private improvements 20,000 20,000 20,000 15,000 3610 Investment income 75,000 50,000 15,000 8,000 Estimated interest earnings at 1%. 75,000 50,000 15,000 81000 3972 Transfer in 240,000 - - - Transfers from utility funds (water 25,000, sewer 140,000, storm 75,000) 240,000 - - - 1,214,300 964,3UU buU,000 /4_3,uuu Fund: 485 Department:447Q,,,- FE entlitures 7050 Construction > $25000 373,885 312,000 - - 2015 Area H Street & Utility project 3,964,115 1,461,000 300,000 - 2016 Area I Street & Utility project - 75,000 1,000,000 75,000 Program Avenue CSAH 10 to CR H2 (design phase) - - 50,000 700,000 Bronson Dr from Edgewood to Long Lake & Woodale Dr. - - - 55,000 Engineering Quincy Street - - 100,000 100,000 Mill and overlay Silver View parking lot (Carryover to 2019) 125,000 150,000 - - Mill and overlay (CH & MVCC) 285,000 285,000 - - Cty Rd H/10 intersection (MSA eligible)(City share)(Ramsey Co is lead) 627,000 79,000 - - Trail segments 6 and 11 (County grant/match of $39,300) 125,000 125,000 - - Cty Rd I and Quincy Intersection street lights 75,000 - - - Other pavement improvements (Silver View parking lot and trails) 75,000 175,000 - 1 188,000 Seal coat projects (2004 Project Area, Area E) 5,650,000 2,662,000 1,450,000 1 1,118,000 37 THIS PAGE LEFT BLANK INTENTIONALLY 38 Operating revenue: Operating revenues Special assessments Connection charges Total operating revenue Operating expenses: Personal services Supplies Contractual services Electricity & gas Disposal charges Contingency Depreciation Capital outlays Total operating expenses Net operating income (loss) Non-operating revenue (expenses): CITY OF MOUNDS VIEW, MINNESOTA Enterprise Funds 2019 Budgets Combining Statement of Revenues and Expenses Sanitary Street Storm Water Sewer Lighting Water Total 2019 2018 1,155,660 1,663,618 104,402 286,500 3,210,180 3,081,018 60,000 - - - 60,000 60,000 2,000 - - - 2,000 2,000 1,217,660 1,663,618 104,402 286,500 3,272,180 3,143,018 384,741 374,696 8,094 136,453 903,984 874,243 77,949 31,502 1,000 20,475 130,926 149,976 230,575 103,571 3,900 191,684 529,730 499,161 129,500 2,100 75,000 - 206,600 187,600 - 997,993 - - 997,993 978,249 15,000 15,000 - - 30,000 30,000 238,000 95,000 - 35,000 368,000 358,000 500,000 316,000 - 105,000 921,000 379,320 1,575,765 1,935,862 87,994 488,612 4,088,233 3,456,549 (358,105) (272,244) 16,408 (202,112) (816,053) (313,531) Investment income 1,000 21,000 1,400 16,000 39,400 38,800 Principal payment on debt (ESP Lease) - - (7,349) - (7,349) (7,133) Interest on debt (ESP Lease) - - (1,902) - (1,902) (2,119) Total non-operating 1,000 21,000 (7,851) 16,000 30,149 29,548 Transfers Transfers in Transfers out Revenues over (under) expenditures Add back: Capital outlays Principal on debt Net income (loss) Net assets (deficit), January 1 Net assets (deficit), December 31 100,000 - - 100,000 - (147,447) (132,446) (2,854) (39,309) (322,056) (296,801) (504,552) (283,690) 5,703 (225,421) (1,007,960) (580,784) 500,000 316,000 - 105,000 921,000 379,320 - - 7,349 - 7,349 7,133 (4,552) 32,310 13,052 (120,421) (79,611) (194,331) 3,951,668 3,839,553 91,536 3,034,448 10,917,204 11,157,537 $3,947,116 $3,871,863 $ 104,588 $2,914,027 $10,837,593 $10,963,206 39 2019 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budget Request Dollar Percent Water (Fund 700): Revenues 3375 State pension contribution - 1,300 90 - - - 0.00% 3551 Spec assessments -current 63,729 82,620 68,276 60,000 60,000 - 0.00% 3552 Spec assessments -delinquent 3,212 7,972 10,194 2,500 2,500 - 0.00% 3553 Spec assess. -penalty & interest 415 762 1,745 - - - 0.00% 3610 Investment income (1,995) (648) 1,595 500 1,000 500 100.00% 3680 Other revenues 2,598 2,344 2,041 2,000 2,000 - 0.00% 3710 Water sales 783,857 866,184 896,826 1,009,676 1,060,160 50,484 5.00% 3714 Water service insurance 83,413 87,775 88,165 85,000 85,000 - 0.00% 3715 Utility connections 4,050 2,150 3,952 2,000 2,000 - 0.00% 3716 Penalties 8,649 8,967 8,574 6,000 6,000 - 0.00% 3913 Meter sales 3,208 1,564 5,896 - - - 0.00% 3917 WAC/SWM charges 6,000 3,000 26,500 - - - 0.00% 3972 Transfers - Vehicle & Equip - - 35,000 - - - 0.00% Contractual services Total revenue 957,136 1,063,990 1,148,854 1,167,676 1,218,660 50,984 4.44% Operating expenses Billing Services (4820): Personnel services 0100 Salaries, regular 42,117 43,284 43,698 42,806 41,787 (1,019) -2.38% 0300 Social security 3,055 3,071 3,043 3,274 3,197 (77) -2.35% 0321 PERA 3,039 3,105 2,940 3,211 3,134 (77) -2.40% 0322 GASB 68 Pension Exp 8,173 26,980 13,118 - - - 0.00% 0400 Group insurance 3,286 3,325 3,114 5,652 5,954 302 5.34% 0500 Workers compensation 437 310 277 289 360 71 24.57% Total personnel services 60,107 80,075 66,190 55,232 54,432 (800) -1.45% Materials & supplies 1600 Supplies, operating - - - 50 50 - 0.00% Total materials & supplies - - - 50 50 - 0.00% Contractual services 3030 Other professional services 8,040 8,008 8,519 8,583 8,746 163 1.90% 3300 Postage 3,430 3,513 3,238 4,352 4,352 - 0.00% 3430 Printing 271 - 218 900 900 - 0.00% 3630 Training - - - 1,500 2,400 900 60.00% 5130 Repairs, equipment 4,264 5,223 4,232 4,712 6,267 1,555 33.00% Total contractual services 16,005 16,744 16,207 20,047 22,665 2,618 13.06% Capital outlays 7030 Equipment - - - 4,200 - (4,200) -100.00% Total capital outlays - - - 4,200 - (4,200) 0.00% Miscellaneous: 9900 Transfers out to General Fund - - - 78,103 80,447 2,344 3.00% 9900 Transfers out to Vehicle Fund - - - 66,000 67,000 1,000 1.52% Total capital outlays - - - 144,103 147,447 3,344 2.32% Total Billing 76,112 96,819 82,397 223,632 224,594 962 0.43% 16,207 164,200 170,162 40 Fund: 700 Department: 4820 Billing Services Account Description 2016 2017 2018 2019 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 7,889 8,036 8,183 8,346 24.5% of audit (2019 - $34,065, 2020 - $34,745, 2021 - $35,440) 400 400 400 400 County special assessment maintenance fee 8,289 81436 8,583 8,746 3300 Postage 3,136 3,072 3,072 3,072 3200 bills X $0.48 postage X 4 billings X 1/2 cost 800 800 800 800 Inserting & mailing bills (moved from 3030) 441 480 480 480 Late notices: 500 bills X $0.48 postage X 4 billings X 1/2 cost 4,377 4,352 4,352 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 2,400 Seminars on new regulations, software updates, etc. INCODE training 1,500 1,500 1,500 2,400 5130 Repairs, equipment 3,866 4,060 4,264 41264 Incode software support (30%)(5% annual increase per agreement) - - - 305 Neptune reader maintenance (1/2 in sewer)(2019 first year $610) 475 - - 1,250 Neptune software maintenance (1/2 in sewer)(every 3 years)(2019)($2500) 388 408 448 448 Handheld interface support for meter readers (1/2 in sewer)(Incode) 4,729 41468 4,712 6,267 7030 Capital, equipment - - 4,200 - Meter reader (1/2 water 1/2 sewer) - - 4,200 - 9900 Transfers out 73,619 75,828 78,103 80,447 Transfer to General Fund for administrative overhead costs 64,000 64,000 66,000 67,000 Transfer to Vehicle & Equipment Fund to fund future purchases 137,619 139,828 144,103 147,447 157,464 159,534 168,400 170,162 41 2019 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Bud et Request Dollar Percent Water (Fund 700): Supplies, bldg & grnds 1,347 70 973 2,750 2,750 - Infrastructure & Equip Maintenance (4823): 1220 Supplies, vehicles (488) 1,660 1,543 1,500 1,500 Personnel services 0.00% 1230 Supplies, equipment 8,041 778 5,877 11,455 0100 Salaries, regular 177,110 177,908 162,521 187,150 191,591 4,441 2.37% 0110 Salaries, overtime 10,701 6,988 11,874 10,228 10,539 311 3.04% 0150 Salaries, part-time 8,318 4,637 - 10,320 11,180 860 8.33% 0300 Social security 13,853 13,236 12,253 15,888 16,317 429 2.70% 0321 PERA 13,564 13,618 12,793 15,108 15,491 383 2.54% 0400 Group insurance 28,772 28,957 24,890 35,474 36,808 1,334 3.76% 0500 Workers compensation 9,304 6,886 6,128 6,667 8,771 2,104 31.56% Total personnel services 261,622 252,230 230,459 280,835 290,697 9,862 3.51% Materials & supplies 1210 Supplies, bldg & grnds 1,347 70 973 2,750 2,750 - 0.00% 1220 Supplies, vehicles (488) 1,660 1,543 1,500 1,500 - 0.00% 1230 Supplies, equipment 8,041 778 5,877 11,455 2,625 (8,830) -77.08% 1240 Supplies, streets 5,186 4,464 1,583 3,000 4,500 1,500 50.00% 1250 Supplies, utilities 17,350 21,114 11,816 27,000 15,000 (12,000) -44.44% 1260 Supplies, traffic control - 200 - 200 200 - 0.00% 1600 Supplies, operating 8,770 3,676 7,724 7,000 7,000 - 0.00% 1700 Motor fuels 5,145 3,634 3,677 4,300 4,450 150 3.49% 2400 Uniforms 1,474 1,802 1,375 1,100 1,100 - 0.00% 2410 Mats & towels 697 714 516 620 620 - 0.00% Repairs, vehicles Total materials & supplies 47,522 38,112 35,084 58,925 39,745 (19,180) -32.55% Contractual services 3030 Other professional services 34,125 24,544 29,114 8,630 19,830 11,200 129.78% 3100 Communications - telephone 3,025 3,566 3,093 3,075 3,075 - 0.00% 3200 Water & wastewater charges 8,501 7,309 5,059 7,200 7,200 - 0.00% 3220 Natural gas 7,405 5,265 7,203 7,500 8,500 1,000 13.33% 3610 Memberships - 26 370 290 360 70 24.14% 3630 Training 2,950 1,274 2,059 3,850 5,030 1,180 30.65% 4010 Equipment rental 2,905 728 2,415 4,500 4,500 - 0.00% 4800 Insurance 6,933 7,550 6,525 10,230 10,230 - 0.00% 5110 Repairs, bldgs & grnds 6,531 15,323 9,069 11,540 11,540 - 0.00% 5120 Repairs, vehicles 20 1,265 525 1,000 1,800 800 80.00% 5130 Repairs, equipment 7,670 8,345 2,653 15,600 15,600 - 0.00% 5140 Repairs, streets 6,450 - 13,057 10,000 10,000 - 0.00% 5150 Repairs, utilities 19,415 25,821 6,472 17,500 17,500 - 0.00% 5155 Water service repair 71,104 82,048 93,668 80,000 80,000 - 0.00% 5160 Repairs, system maintenance 742 - - 3,500 3,500 - 0.00% Total contractual services 177,776 183,064 181,282 184,415 198,665 14,250 7.73% Capital outlays 7030 Equipment - - - 50,000 50,000 - 0.00% 7050 Construction - - - 50,000 450,000 400,000 800.00% 7950 Depreciation 277,657 240,583 237,949 241,000 238,000 (3,000) -1.24% Total capital outlays 277,657 240,583 237,949 341,000 738,000 397,000 116.42% Miscellaneous: 9100 Contingency - - - 15,000 15,000 - 0.00% Total miscellaneous - - - 15,000 15,000 - 0.00% Total infrastructure & equip maint 764,577 713,989 684,774 880,175 1,282,107 401,932 45.67% 454,315 599,340 991,410 42 Fund: 700 Department: 4823 Water Infrastructure & E ui ment Maintenance Account Description 2016 2017 2018 2019 Description 1210 Supplies, Bldgs & grounds 100 100 100 100 Mops, buckets, brooms 500 500 500 500 Light tubes & ballasts 200 200 200 200 Paper products 200 200 200 200 Paint, thinner, & brushes 750 750 750 750 Black dirt & sod/seed, landscaping materials 500 500 500 500 Misc. cleaners for well houses & % of shop 500 500 500 500 Irrigation parts 2,750 2,750 2,750 2,750 1220 Supplies, vehicles 300 300 300 300 Air, oil, fuel, & transmission filters 100 100 100 100 Fluids 400 400 400 400 Batteries and tires 50 50 50 50 Paint sealant 150 150 150 150 Tune ups 500 500 500 500 Misc repairs 1,500 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 500 500 500 1,500 Chemical equipment parts (fluoride pumps) - - 4,830 - Spin Doctor (battery operated valve operator) - - 5,000 - Line locator (Metrotech) - - - - Fluoride tank replacement (3 tanks every 3 years)(2018 next) 250 250 250 250 Air, oil, fael, & trans filters (emergency generator) 1,625 1,625 11,455 2,625 1240 Supplies, streets 3,000 3,000 3,000 4 500 Asphalt/concrete/sod/seed for patching minor street, curb, driveway repairs. 3,000 3,000 3,000 4,500 1250 Supplies, utilities 2,500 2,500 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 1,000 1,000 1,000 Hydrant markers - 1,050 1,050 1,050 De -chlorinator - - 12,000 - Scales in treatment plants ($2118 each x 5 plus incidentals) 3,000 3,450 3,450 3,450 Hydrant parts (hydrant pump $450 - 2017) 3,000 5,000 5,000 5,000 Meter supplies, etc. (move from account 1600) 11,500 15,000 27,000 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 1,850 1,850 1,850 Film, first aid supplies, & batteries (add hearing protection) 2,500 2,500 2,500 2,500 Location flags & paint (moved from account 1250) 250 250 250 250 Cleaning supplies 1,500 1,500 1,500 1,500 Additional & replacement hand tools 5,800 7,000 7,000 7,000 1700 Motor fuels & lubs 650 560 600 620 Diesel fuel - 200 gallons @ $3.10 450 450 450 450 Oil 2,475 2,990 3,250 3,380 Unleaded fuel: 1,300 gallons @ $2.60 3,575 4,000 4,300 4,450 2400 Uniforms 1,100 1,100 1,100 1,100 Uniforms 15.5% of $4,500 and clothing 1.7 FTE x $175 per contract 1,100 1,100 1,100 1,100 2410 Mats & towels 620 620 620 620 Share of floor mats & shop towels (15.5% of $4,000) 620 620 620 620 3030 Other professional services 180 180 180 180 Backflow prevention testing (3 @ $60 per test) 3,000 - - 3,500 Water system leak survey (every 2 years, next in 2019) 11,000 - - - Production assessment ($312,000 defer) - - - 7,700 Inspection of water tower and ground reservoir roof 500 500 500 500 Broadleaf control 1,000 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) 1,500 1,500 1,500 1,500 Gopher State One -call locates 5,000 5,000 5,000 5,000 Arc View/GIS base map and engineering consulting 22,630 8,630 8,630 19,830 3100 Communications - telephone 400 400 400 400 Service & repair 1,846 1,954 1,954 1,954 Cellular phone service (20.06% of $9,200) 720 720 631 631 Data cards for SCADA (2)(75%)(35.01 per card) balance in Sewer 90 90 90 90 800 MHz license fee (33%)(5 radios @ $4.48 per month) 3,056 3,164 3,075 3,075 3200 Water and wastewater charges 7,200 7,200 7,200 7,200 7,200 7,200 7,200 7,200 1 43 THIS PAGE LEFT BLANK INTENTIONALLY 44 Fund: 700 Department:4823 Water Infrastructure & Equipment Maintenance Account Description 2016 2017 2018 2019 Description 3220 Natural gas 7,000 7,500 7,500 8,500 Heating fuel 7,000 7,500 7,500 8,500 3610 Memberships 100 100 100 120 MN Rural Water Association (50%) 80 80 80 100 MN Safety Council (19% of $405) 50 50 50 60 Suburban Utility Superintendent Association (SUSA)(50% of $100) 60 60 60 80 Pressurized vessel license 290 290 290 360 3630 Training 250 250 250 250 Computer training/webinars 1,200 1,200 1,200 1,700 Trench safety/confined space alternate years/inspection safety 110 110 110 110 Hearing test/R2K (2.15 FTE * $50) 60 60 60 60 Maintenance Expo 820 820 820 1,500 Water operator class/exam/certificate ($xxx per person) 200 200 200 200 Misc. training seminars 390 390 390 390 Equipment operator training 200 200 200 200 MRWA workshops 560 560 560 560 Tuition reimbursement 60 60 60 60 Work zone safety seminar (every 3 years) 3,850 3,850 3,850 5,030 4010 Rental, equipment 4,000 4,000 4,000 4,000 Skid steer - upgrade 300 300 300 300 Barricades & signs 200 200 200 200 Tools & equipment 4,500 1 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 2,000 2,000 2,000 2,000 Door & lock repairs 1,000 1,000 1,000 1,000 Roof & wall repairs 3,000 7,540 7,540 7,540 Electrical & mechanical repairs (well #2 in 17 well #4 in 18 $4540) 1,000 1,000 1,000 1,000 Site repairs (pavement, fence, irrigation, etc...) 7,000 11,540 11,540 11,540 5120 Repairs, vehicles 1,000 1,000 1,000 1,800 Utility trick repairs (add $800 for rear springs) 1,000 1,000 1,000 1,800 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 3,000 3,000 Repair boiler @ main plant 3,500 3,500 3,500 3,500 Generator service - Onan 2,500 2,500 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 12,600 15,600 15,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 65,000 65,000 65,000 65,000 Contractor repairs to residential water services. 15,000 15,000 15,000 15,000 Pavement & curb repairs 80,000 80,000 80,000 80,000 5160 System maintenance 3,500 3,500 3,500 31500 Water system maintenance & repair items - - - - Well #4 perimeter fencing ($5000 well #5 fencing defer to 2018) 3,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 35,000 35,000 Booster station (pressure valve) 10,000 - - - Water treatment plant (leaking valve) 14,000 - - - Trench box 2,750 - - - Electric rain gauges SCADA System (33%)(total cost $8,250) 25,000 - - - Security cameras & card key access - 35,000 - I - 3/4 ton pick-up 133,708 127,640 50,000 50,000 7050 Constriction > $25000 80,000 - - - Wells #6 building repairs (int. and exterior repairs) - 12,000 - - Well #5 repairs (design in 2017)($90,000 defer to 2018) - - - 400,000 Water treatment plant engineering and design 25,000 - - Water system upgrades wells #1,2 - 45,000 50,000 50,000 Well pump rehabilitation project (well no. 6) 105,000 1 57,000 50,000 450,000 45 2019 Budget Summary M 2015 2016 2017 2018 2019 ChanIze from 2018 Actual Actual Actual Budget Request Dollar Percent Water (Fund 700): Water Production (4825): Personnel services 0100 Salaries, regular 24,576 25,292 33,780 27,399 28,228 829 3.03% 0110 Salaries, overtime 1,717 2,762 2,383 - - - 0.00% 0300 Social security 1,760 1,929 2,455 2,096 2,159 63 3.01% 0321 PERA 2,045 2,079 2,763 2,055 2,117 62 3.02% 0400 Group insurance 4,492 4,925 6,231 5,328 5,544 216 4.05% 0500 Workers compensation 1,688 1,224 1,093 1,189 1,564 375 31.54% Total personnel services 36,278 38,211 48,705 38,067 39,612 1,545 4.06% Materials & supplies 1600 Supplies, operating 25,855 26,528 26,615 37,775 37,775 - 0.00% 2400 Uniforms - - 46 235 235 - 0.00% 2410 Mats & towels - - 42 144 144 - 0.00% Total materials & supplies 25,855 26,528 26,703 38,154 38,154 - 0.00% Contractual services 3030 Other professional services 7,154 11,984 5,379 17,745 18,545 800 4.51% 3210 Electricity 101,917 113,215 120,518 108,000 121,000 13,000 12.04% Total contractual services 109,071 125,199 125,897 125,745 139,545 13,800 10.97% Capital outlays 0 7030 Equipment - - - - - - 0.00% 7050 Construction - - - - - - 0.00% Total capital outlays - - - - - - 0.00% 0 Total water production 171,204 189,938 201,305 201,966 217,311 15,345 7.60% 152,600 163,899 177,699 Total expenditures 1,011,893 1,000,746 968,476 1,305,773 1,724,012 418,239 32.03% Revenues over (under) expenditures (54,757) 63,244 180,378 (138,097) (505,352) (367,255) 265.94% Add back: capital outlays - - - 104,200 500,000 395,800 379.85% principal payment on debt - - - - - - 0.00% Change in net assets (54,757) 63,244 180,378 (33,897) (5,352) 28,545 -84.21% Net Assets, beginning year 3,992,762 3,741,943 3,805,187 3,985,565 3,951,668 (33,897) -0.85% Accounting Change GASB 68 pension (196,062) Net Assets, end of year $ 3,741,943 $ 3,805,187 $ 3,985,565 $ 3,951,668 $ 3,946,316 $ (5,352) -0.14% 927,439 1,339,271 M Fund: 700 Department: 4823 Water Production Account Water Infrastructure & E ui ment Maintenance 7950 Depreciation 255,000 270,000 241,000 238,000 Estimated depreciation 1600 255,000 270,000 241,000 238,000 9100 Contingency 15,000 15,000 15,000 15,000 Contingency 800 15,000 15,000 15,000 15,000 9900 Transfers out25,000 4,125 - - - Water system upgrades in conjunction with major roadway program Sulfur dioxide: 25 150# cylinders @ $1.10 per pound 25,000 - - - '/55 "/14 hV0 Y19 _')99 _140 991 41U Fund: 700 Department: 4825 Water Production Account Description 2016 2017 2018 2019 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 10,400 10,400 10,400 Chlorine: 8 - 1 ton cylinders @ .65 per pound 9,350 10,350 10,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 37,775 37,775 37,775 2400 Uniforms 235 235 235 235 Uniforms 3.6% of $4,500 and clothing .4 FTE x $175 per contract 235 235 235 235 2410 Mats & towels 144 144 144 144 Share of floor mats & shop towels (3.6% of $4,000) 144 1 144 144 144 3030 Other professional services 960 960 1,200 2,000 Bacteria tests (10*$10*12 months)(+$800 Health Dept Rule) 800 800 800 800 Computer maintenance 1,000 1,000 - - Consumer confidence report (on-line) 10,000 7,000 5,500 5,500 DNR water permit fee (annual surcharge)(14 - $3826, 15 - $4462, 16 - $4532' 300 300 - - Emergency Response Commission fees (same as MNDPS - EPCRA program 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,425 1,425 MCES discharge pen -nits (3*$475) 300 300 300 300 MNDPS - EPCRA program ($100/WTP) - - 5,000 5,000 Water Supply Plan 7,000 7,000 - - I Well head protection plan (req. by Dept. of Health)(11, 12, 13 Barr Eng.) 24,930 21,930 17,745 18,545 3210 108,000 108,000 108,000 121,000 Electricity for wells, tower & reservoir 108,000 108,000 108,000 121,000 JElectricity 108,484 1625,UZS4 16S,2Syy 1 / /,OVV 1,081,682 1,018,557 931,639 1,339,271 -3.43% -5.84% -8.53% 43.75% 47 2019 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budget Reclues Dollar Percent Sanitary Sewer (Fund 730): Revenues 3375 State pension contribution - 1,215 84 - - - 0.00% 3551 Spec. Assessments 13,105 - 13,489 - - - 0.00% 3610 Investment income 26,380 21,359 25,073 21,000 21,000 - 0.00% 3680 Other revenues - - 1,222 - - - 0.00% 3716 Penalties 10,936 12,225 11,176 8,000 8,000 - 0.00% 3720 Utility sales 1,375,522 1,456,900 1,569,161 1,591,940 1,655,618 63,678 4.00% 3721 SAC charges (1,988) 149 1,292 - - - 0.00% 3725 Utility connections 1,900 1,202 2,301 - - - 0.00% 3726 Penalties & interest 612 825 785 - - - 0.00% 3972 Transfers from Vehicle Fund - 60,000 - - 100,000 100,000 0.00% Materials & supplies Total revenue 1,426,467 1,553,875 1,624,583 1,620,940 1,784,618 163,678 10.10% Operating expenses Billing Services (4820): 7,620 8,008 8,144 8,183 8,346 163 1.99% Personnel services 3,430 3,513 3,238 4,352 4,352 - 0.00% 0100 Salaries, regular 42,139 43,284 43,698 42,806 41,787 (1,019) -2.38% 0300 Social security 3,059 3,071 3,588 3,274 3,197 (77) -2.35% 0321 PERA 3,042 3,105 3,386 3,211 3,134 (77) -2.40% 0322 GASB 68 Pension expense 7,871 25,217 12,260 - - - 0.00% 0400 Group insurance 3,289 3,325 3,113 5,652 5,954 302 5.34% 0500 Workers compensation 437 314 281 293 365 72 24.57% Total personnel services 59,837 78,316 66,326 55,236 54,437 (799) -1.45% Materials & supplies 270,245 263,656 245,984 305,063 320,259 15,196 4.98% 1600 Supplies, operating - - - 50 50 - 0.00% Total materials & supplies - - - 50 50 - 0.00% Contractual services 3030 Other professional services 7,620 8,008 8,144 8,183 8,346 163 1.99% 3300 Postage 3,430 3,513 3,238 4,352 4,352 - 0.00% 3430 Printing 271 - 218 900 900 - 0.00% 3630 Training - - - 1,500 2,400 900 60.00% 5130 Repairs, equipment 4,264 5,223 4,232 4,712 6,267 1,555 33.00% Total contractual services 15,585 16,744 15,832 19,647 22,265 2,618 13.33% Capital outlays 16,278 16,985 707 4.34% 400 Group insurance 30,258 7030 Equipment - - - 4,200 - (4,200) -100.00% Total capital outlays - - - 4,200 - (4,200) -100.00% Miscellaneous: 9900 Transfers out to General Fund 56,611 58,309 60,058 61,860 80,446 18,586 30.05% 9900 Transfers out to Vehicle Fund 53,000 42,000 38,000 48,000 52,000 4,000 8.33% Total miscellaneous 109,611 100,309 98,058 109,860 132,446 22,586 20.56% Total Billing 185,033 195,369 180,216 188,993 209,198 20,205 10.69% 12,480 960 8.33% 113,890 133,757 154,761 13,746 13,077 Infrastructure & Equip Maintenance (4823): Personnel services 100 Salaries, regular 187,913 186,137 172,986 204,946 213,332 8,386 4.09% 110 Salaries, overtime 5,326 5,370 5,057 8,012 8,705 693 8.65% 150 Salaries, part-time 8,318 4,637 5,458 11,520 12,480 960 8.33% 300 Social security 14,237 13,746 13,077 17,173 17,941 768 4.47% 321 PERA 14,010 14,330 12,975 16,278 16,985 707 4.34% 400 Group insurance 30,258 32,087 28,430 40,268 41,578 1,310 3.25% 500 Workers compensation 10,183 7,349 8,001 6,866 9,238 2,372 34.55% Total personnel services 270,245 263,656 245,984 305,063 320,259 15,196 4.98% 48 Fund: 730 Department: 4820 Billing Services Account Description 2016 2017 2018 2019 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 7,889 8,036 8,183 8,346 24.5% of audit (2019 - $34,065, 2020 - $34,745, 2021 - $35,440) 7,889 8,036 8,183 8,346 3300 Postage 3,136 800 3,072 800 480 3,072 800 480 3,072 800 480 3200 bills X $0.48 postage X 4 billings X 1/2 cost Inserting & mailing bills (moved from 3030) Late notices: 500 bills X $0.48 postage X 4 billings X 1/2 cost 4,352 4,352 4,352 3430 Printing 450 450 450 450 450 450 Envelopes Utility bills (1/2 cost) 900 900 900 3630 Training P3,866 1,500 1,500 2,400 Seminars on new regulations, software updates, etc. INCODE training 1,500 1,500 2,400 5130 Repairs, equipment 4,060 - 475 408 4,264 - 448 4,264 305 1,250 448 Incode software support (30%)(5% annual increase per agreement) Neptune reader maintenance (1/2 in water)(2019 first year $610) Neptune software maintenance (1/2 in water)(every 3 years)(2019)($2500) Handheld interface support for meter readers (50% water 50% sewer)(Incode) 4,729 4,943 4,712 6,267 7030 Capital, equipment - - 4,200 - Meter reader (1/2 water 1/2 sewer) - - 4,200 - 9900 Transfers out 58,309 42,000 60,058 38,000 61,860 48,000 80,446 52,000 Transfer to General Fund for admin costs Transfer to Vehicle & Equipment Fund for vehicle use 100,309 98,058 109,860 132,446 119,803 117,839 135;/J"/ 1J4,/61 49 2019 Budget Summary 2015 2016 2017 2018 2019 Chanize from 2018 Actual Actual Actual Budget Request Dollar Percent Sanitary Sewer (Fund 730): Materials & supplies 3030 Other professional services 1,341 4,075 2,591 24,200 1210 Supplies, bldg & grnds - - - 200 200 - 0.00% 1220 Supplies, vehicles 244 2,925 4,815 1,575 1,575 - 0.00% 1230 Supplies, equipment 4,963 6,214 3,093 8,350 8,350 - 0.00% 1240 Supplies, streets - 1,307 - 2,500 2,500 - 0.00% 1250 Supplies, utilities 904 163 - 1,400 1,400 - 0.00% 1260 Supplies, traffic control - 335 150 300 300 - 0.00% 1600 Supplies, operating 3,732 1,250 3,713 10,550 10,550 - 0.00% 1700 Motor fuels 5,061 2,307 2,980 4,550 4,680 130 2.86% 2400 Uniforms 1,007 1,162 1,292 1,169 1,169 - 0.00% 2410 Mats & towels 697 714 547 728 728 - 0.00% Total materials & supplies 16,608 16,377 16,590 31,322 31,452 130 0.42% Contractual services 3030 Other professional services 1,341 4,075 2,591 24,200 8,200 (16,000) -66.12% 3100 Communications - telephone 1,575 1,736 2,059 2,086 2,086 - 0.00% 3200 Water & sewer 3,335 3,514 3,728 3,300 3,300 - 0.00% 3210 Electricity 1,923 1,883 1,952 2,100 2,100 - 0.00% 3230 Wastewater disposal - MCES 832,084 898,621 912,136 972,249 991,993 19,744 2.03% 3231 Wastewater disposal - Strength chg 5,157 - 3,899 6,000 6,000 - 0.00% 3610 Memberships - - 90 230 290 60 26.09% 3630 Training 1,693 1,951 2,359 4,880 6,880 2,000 40.98% 4010 Equipment rental - 431 - 500 500 - 0.00% 4800 Insurance 7,451 4,796 5,109 7,300 7,300 - 0.00% 5130 Repairs, equipment 3,259 5,507 3,698 11,750 11,750 - 0.00% 5140 Repairs, streets - 141 400 10,000 10,000 - 0.00% 5150 Repairs, utilities 719 13,774 13,964 17,500 17,500 - 0.00% 5155 Utility service repairs - - 3,035 - - - 0.00% 5160 Repairs, maintenance 2,418 4,279 1,348 13,500 13,500 - 0.00% Total contractual services 860,955 940,708 956,368 1,075,595 1,081,399 5,804 0.54% Capital outlays 7030 Equipment - - - - - - 0.00% 7050 Construction - - - 168,000 316,000 148,000 88.10% 7950 Depreciation 151,592 85,388 95,362 85,000 95,000 10,000 11.76% Total capital outlays 151,592 85,388 95,362 253,000 411,000 158,000 62.45% Miscellaneous: 9100 Contingency - - - 15,000 15,000 - 0.00% 9900 Transfer to Street fund 140,000 140,000 - - - - 0.00% Total miscellaneous 140,000 140,000 - 15,000 15,000 - 0.00% 1,068,320 1,374,917 1,538,851 Total infrastructure & equip maint 1,439,400 1,446,129 1,314,304 1,679,980 1,859,110 179,130 10.66% Total expenditures 1,624,433 1,641,498 1,494,520 1,868,973 2,068,308 199,335 10.67% Revenues over (under) expenditures (197,966) (87,623) 130,063 (248,033) (283,690) (35,657) 14.38% Add back: capital outlays - - - 172,200 316,000 143,800 83.51% Change in net assets (197,966) (87,623) 130,063 (75,833) 32,310 108,143 -142.61% Net Assets, beginning of year 4,254,006 3,872,946 3,785,323 3,915,386 3,839,553 (75,833) -1.94% Accounting Change GASB 68 pension (183,094) Net Asset, end of year $ 3,872,946 $ 3,785,323 $ 3,915,386 $ 3,839,553 $ 3,871,863 $ 140,453 3.66% 1,182,210 1,508,674 1,693,612 50 Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance Account Description 2016 2017 2018 2019 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,575 1,575 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 2,000 2,000 2,000 2,000 Camera track and parts (CCTV) 300 300 300 300 Minor repairs 100 100 100 100 Gas detection device parts and supplies 300 4,000 4,000 4,000 Vactor cleaning nozzle parts and supplies (nozzle 2017, hose 2018) 4,650 8,350 8,350 8,350 1240 Supplies, streets 200 200 200 200 Tack coat 300 300 300 300 Dewatering rock/agg. base 2 500 2,000 2,000 2,000 Asphalt mix 3,000 2,500 2,500 2,500 1250 Supplies, utilities 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 750 300 300 300 Manhole covers, adjust rings & bolts 3,350 1,400 1,400 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 1,500 1,500 1,500 First aid supplies, protective equip (add hearing equipment for 2017) 400 400 400 400 CD's, DVD's, software 250 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) 500 500 500 500 Locating supplies (paint, flags, markers, etc.) 10,000 5,000 5,000 5,000 Chemical blocks for lift stations 300 300 300 300 Filter replacement for sewer gas monitors 14,250 10,550 10,550 10,550 1700 Motor fuels & lubs 300 300 300 300 Fluids 600 600 600 600 Motor oil - 100 gallons $6 gal. 1,375 1,150 1,250 1,300 Unleaded fuel 500 gallons @ $2.60 2,600 2,240 2,400 21480 Diesel fuel 800 gallons @ $3.10 4,875 4,290 4,550 4,680 2400 Uniforms 1,169 1,169 1,169 1,169 Uniforms 18.2% of $4,500 and clothing 2.0 FTE x $175 per contract 1,169 1,169 1,169 1,169 2410 Mats & towels 728 728 728 728 Share of floor mats & shop towels (18.2% of $4,000) 728 728 728 728 3030 Other professional services 1,500 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 1,000 Asset management software 2,500 5,000 5,000 5,000 Arcview/GIS base map and engineering consulting - - 16,000 - Comprehensive Sewer Plan 5,700 8,200 24,200 8,200 3100 Communications - telephone 1,785 1,785 1,785 1,785 Cellular phone service (19.4% of $9,200) 240 211 211 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) 2,115 2,086 2,086 2,086 3200 Water & Sewer service 3,000 3,300 3,300 3,300 Estimated annual charge 3,000 3,300 3,300 3,300 3210 2,300 2,100 2,100 2,100 Electricity for lift stations 2,300 2,100 2,100 2,100 JElectricity 47,1-12 40,/425 0.5,VV25 4/,1)25 51 THIS PAGE LEFT BLANK INTENTIONALLY Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance (continued) Account Description 2016 2017 2018 2019 Description 3230 Met Council Environ. Servies MCI 892,571 912,137 972,249 991,993 Annual charge (2.03% increase in 2019) 892,571 912,137 972,249 991,993 3231 MCES Strength charges 5,500 6,000 6,000 6,000 Strength Charge 5,500 6,000 6,000 6,000 3610 Memberships 100 100 100 120 MN Rural Water Assoc. (50%) 50 50 50 70 Suburban Utility Superintendant Association (SUSA)(50% of $100) 80 80 80 100 MN Safety Council (20%) 230 230 230 290 3630 Training 1,400 1,500 1,500 1,800 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,700 Confined space/trench safety alternate years) 120 - - - Pesticide applicators license 300 300 750 1,950 Miscellaneous wastewater training (certified pipe inspector) 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,450 4,430 4,880 6,880 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 - - - Repairs to motors & pumps (in 5150) - 7,782 - - Move omni antenna at groveland lift station 2,500 2,500 8,000 8,000 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 Misc repairs 14,032 11,750 11,750 5140 Repairs, streets 10,000 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 21500 Lift station repairs 15,000 15,000 15,000 V25,000 Sanitary collection system repairs 17,500 17,500 17,500 5160 System maintenance 5,000 5,0005,000 Root control 4,500 4,500 4,500 Lift station maintenance/cleaning/pun service 4,000 4,000 4,000 Sewer debris disposal costs 13,500 13,500 13,500 7030 Capital, equipment > $5000 - - - Generator - Bronson (natural gas)(New to replace mobile generator) - - - =44,750 Electronic rain gauges for SCADA (33%)(total cost $8,250) - - - Grinder station for Bronson lift station - - - 7050 Construction > $25000 250,000 150,000 150,000 150,000 Sewer pipe relining program 18,000 166,000 Upgrade panel Bronson lift station and nat gas generator 250,000 150,000 168,000 316,000 7950 Depreciation 167,000 153,000 85,000 95,000 Estimated depreciation 167,000 153,000 85,000 95,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 - - - Sewer system upgrades in conjunction with major roadway program 140,000 - - - 1,644,2OJ 1,jJU,37 / l,s /4,V I / 1,:)325,8J 1 53 2019 Budget Summary Operating expenses 2015 2016 2017 2018 2019 ChanjZe from 2018 Operations (4416) 35 Actual Actual Actual Budget Request Dollar Percent Street Lighting (Fund 740): 75,000 5,000 7.14% 4800 Insurance 603 591 Revenues 8,430 7,014 5,462 6,286 6,215 (71) -1.13% 3610 Investment income 1,250 1,164 1,480 1,300 1,400 100 7.69% 3716 Penalties 719 728 752 500 500 - 0.00% 3740 Street lighting charges 90,844 97,031 103,472 103,902 103,902 - 0.00% 0400 Group insurance Total revenue 92,813 98,923 105,704 105,702 105,802 100 0.09% Operating expenses 3030 Other professional services Operations (4416) 35 - - - - 0.00% 3210 Electricity 73,907 Personnel services 76,018 70,000 75,000 5,000 7.14% 4800 Insurance 603 591 0100 Salaries, regular 8,430 7,014 5,462 6,286 6,215 (71) -1.13% 0110 Salaries, overtime 115 119 93 - - - 0.00% 0300 Social security 487 494 397 481 475 (6) -1.25% 0321 PERA 504 515 406 396 389 (7) -1.77% 0400 Group insurance 1,132 1,172 963 666 693 27 4.05% 0500 Workers compensation 346 240 230 304 322 18 5.92% Total personnel services 11,014 9,554 7,551 8,133 8,094 (39) -0.48% Materials & supplies 1600 Supplies, operating - 25 1,333 1,000 1,000 - 0.00% Contractual services 3030 Other professional services 796 35 - - - - 0.00% 3210 Electricity 73,907 70,165 76,018 70,000 75,000 5,000 7.14% 4800 Insurance 603 591 574 900 900 - 0.00% 5150 Repairs, utilities 698 - - 3,000 3,000 - 0.00% 5160 Repairs, system maintenance 93,208 - - - - - 0.00% Total contractual services 169,212 70,791 76,592 73,900 78,900 5,000 6.77% Other 8011 Lease payable - principal (ESP) - - 6,923 7,133 7,349 216 3.03% 8021 Lease payable - interest (ESP) 2,335 2,532 2,328 2,119 1,902 (217) -10.24% 9900 Transfer to General Fund 2,536 2,612 2,690 2,771 2,854 83 3.00% Total other 4,871 5,144 11,941 12,023 12,105 82 0.68% 0 Total expenditures 185,097 85,514 97,417 95,056 100,099 5,043 5.31% Revenues over (under) expenditures (92,284) 13,409 8,287 10,646 5,703 (4,943) -46.43% Add back: Capital outlays/Prin on debt - - 6,923 7,133 7,349 216 3.03% Change in net assets (92,284) 13,409 15,210 171779 13,052 (4,727) -26.59% Net assets, beginning year 137,422 45,138 58,547 73,757 91,536 17,779 24.10% Net assets, end of year $ 45,138 $ 58,547 $ 73,757 $ 91,536 $ 104,588 $ 13,052 14.26% 89,866 86,923 92,005 54 Fund: 740 Street Lighting Fund Revenues Account Description 2016 2017 2018 2019 Description 3610 Interest revenue 1,300 1,300 1,300 1,300 1,300 1,300 1,400 Estimated interest earnings at 1%. 1,400 3716 Penalties 500 500 500 500 500 500 500 Estimated late fees on street lighting charges. 500 3740 1 Street lighting charges 97,290 97,290 103,902 103,902 103,902 103,902 103,902 Estimated utility charges for street lighting. 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 78,000 70,000 70,000 75,000 Estimate 78,000 70,000 70,000 75,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 8021 Lease payable (principal) Lease payable (interest) 9,556 - 6,924 2,329 7,133 2,119 7,349 1,902 Energy savings program (LED trail lighting) Interest 9,556 9,253 9,252 9,251 9900 1 Transfer out 2,612 2,690 2,771 2,854 Transfer to General Fund for administrative overhead costs 2,612 2,690 2,771 2,854 95,068 86,843 86,923 92,005 -2.43% -8.65% 0.09% 5.85% 55 Storm Water (Fund 745): Revenues (4415): 3359 Other state grants 3610 Investment income (charges) 3680 Other revenues 3716 Penalties & interest 3718 Impact charges 3730 Surface water charges 3972 Transfer from other funds 0400 Total revenue Operating expenses System Maintenance (4415): Personnel services 0100 Salaries, regular 0110 Salaries, overtime 0150 Salaries, part-time 0300 Social security 0321 PERA 0322 GASB 68 Pension expens 0400 Group insurance 0500 Workers compensation 1,500 Total personnel services Materials & supplies 2019 Budget Summary 2015 2016 2017 2018 2019 Chanefrom 2018 Actual Actual Actual Bud et Request Dollar Percent - 422 29 - - - 0.00% 18,13718,216 1,975 22,208 16,000 16,000 - 0.00% - - 510 - - - 0.00% 1,990 1,918 1,838 1,500 1,500 - 0.00% 848 1,128 20,658 - - - 0.00% 263,254 261,021 263,318 270,000 285,000 15,000 5.56% 210,000 - - - - - 0.00% 494,229 282,705 308,561 287,500 302,500 15,000 5.22% 70,056 72,358 73,983 79,041 81,371 2,330 2.95% 1,975 2,116 2,670 1,420 1,460 40 2.82% 5,452 3,871 6,757 2,640 2,860 220 8.33% 5,629 5,807 6,075 6,357 6,556 199 3.13% 5,109 5,406 5,279 6,035 6,213 178 2.95% 2,648 8,756 4,257 - - - 0.00% 5,137 5,674 3,184 13,800 14,076 276 2.00% 6,652 2,495 2,230 2,599 3,418 819 31.51% 102,658 106,483 104,435 111,892 115,954 4,062 3.63% 1230 Supplies, equipment 1,382 3,981 1,842 2,750 2,750 - 0.00% 1240 Supplies, streets - - 473 - - - 0.00% 1600 Supplies, operating 3,478 1,296 6,320 4,725 4,725 - 0.00% 1700 Motor fuels 3,382 1,951 2,217 2,250 2,250 - 0.00% 2400 Uniforms 577 727 284 470 470 - 0.00% 2410 Mats & towels 293 300 228 292 292 - 0.00% 20,862 Total materials & supplies 9,112 8,255 11,364 10,487 10,487 - 0.00% Contractual services 3030 Other professional services 3100 Telephone 3610 Memberships 3630 Training 4010 Equipment rental 4800 Insurance 5120 Repairs, vehicles 5150 Repairs, utilities - 0.00% Total contractual services Capital outlays 7030 Equipment 7050 Construction 7950 Depreciation Total capital outlays Miscellaneous: 9900 Transfer out Total miscellaneous Total System Maintenance 4,475 8,377 4,355 37,269 12,292 (24,977) -67.02% 949 736 664 872 872 - 0.00% 950 955 1,050 1,045 1,045 - 0.00% 697 500 676 1,695 1,695 - 0.00% - 2,628 3,772 6,000 6,000 - 0.00% 5,613 32 2,552 4,000 4,000 - 0.00% 46 1,838 155 1,500 1,500 - 0.00% 8,132 10,262 40,448 105,000 110,000 5,000 4.76% 20,862 25,328 53,672 157,381 137,404 (19,977) -12.69% - - - 27,920 30,000 2,080 7.45% - - - 75,000 75,000 - 0.00% 44,623 35,353 35,344 32,000 35,000 3,000 9.38% 44,623 35,353 35,344 134,920 140,000 5,080 3.77% 82,383 82,604 7,832 8,067 8,309 242 3.00% 82,383 82,604 7,832 8,067 8,309 242 3.00% 259,638 258,023 212,647 422,747 412,154 (10,593) 0.00% 108,212 310,855 296,200 0.00% W. Fund: 745 Storm Water Revenues Account Description 2016 2017 2018 2019 Description 3610 Interest revenue 15,000 15,000 16,000 16,000 Estimated interest earnings at 1%. 15,000 15,000 16,000 16,000 3716 Penalties - 1,500 1,500 1,500 Estimated late payment fees. - 1,500 1,500 11500 3730 Utility sales 270,000 270,000 270,000 285,000 Estimated surface water charges. 1 270,000 270,000 270,000 285,000 Fund: 745 .Department, 4,415 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,000 1,000 1,000 Filters, brakes, bulbs, wipers, tires, batteries, etc... 500 250 250 250 Hoses & nozzles 3,250 2,750 2,750 2,750 1240 Supplies, streets 300 - - - Bituminous mix 300 1 - - - 1600 Supplies, operating 250 250 250 250 Concrete 3,500 2,000 2,000 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, DVDs, software upgrade for camera van 2,500 2,000 2,000 2,000 Catch basin castings, pipe, approns, etc... 6,725 4,725 4,725 4,725 1700 Motor faels 2,475 2,070 2,250 2,250 900 gallons unleaded @ $2.50 for utility trick 2,475 2,070 2,250 2,250 2100 Books/Periodicals 100 - - - Storm water books/periodicals 100 - - - 2400 Uniforms 470 470 470 470 Uniforms/clothing (7.3% of $4,500,.8 FTE x $175 per contract) 470 470 470 470 2410 Mats & towels 292 292 292 292 Share of floor mats & shop towels (7.3% of $4,000) 292 292 292 292 3030 Other professional services 7,500 25,000 7,500 7,500 Consulting engineers (SWPPP, comp plan, Proj Priority list) 2,500 2,500 2,500 2,500 Arcview/GIS base map consulting 1,000 1,000 1,000 1,000 Asset management software 100 100 100 100 Fire extinguisher inspection/servcie (5 @ $20) 1,127 1,148 1,169 1,192 3.5% of audit (2019 - $34,065, 2020 - $34,745, 2021 - $35,440) - - 25,000 - Surface Water Management Plan 12,227 29,748 37,269 12,292 3100 Communications 782 782 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) 872 872 872 872 3610 Memberships 190 200 200 200 American Public Works Association (APWA)(25% of $800) 800 800 800 800 Minnesota Cities Storm Water Coalition 45 45 45 45 MN Safety Council (11% of $405) 1,035 1,045 1,045 1,045 3630 Training 200 200 200 200 Seminars & training sessions (Stonnwater) 55 55 55 55 Hearing test/R2K (l.l FTE * $50) 350 350 350 350 Safety training 500 500 500 500 NPDES compliance training 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 2,445 1,695 1,695 1,695 4010 Equipment rental 6,000 6,000 6,000 6,000 Rent mini excavater for clean-outs 6,000 6,000 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 44,000 30,000 30,000 30,000 Repair & maintain storm sewers, ponds, basins, and drainage issues - - 50,000 50,000 Arden Ave Storm sewer cleaning - 25,000 25,000 30,000 Storm Sewer slip Tinning improvements 44,000 55,000 105,000 110,000 7030 Equipment > $5000 12,975 - - - Trailer for backhoe - - 27,920 - Salt Brine maker 2,750 - - - Electronic rain gauges for SCADA (33%)(total cost $8,250) - - - 30 000 Silverview pond aerators 15,725 - 27,920 30,000 M Storm Water (Fund 745): Street Sweeping (4417): Personnel services 0100 Salaries, regular 0110 Salaries, overtime 0300 Social security 0321 PERA 0400 Group insurance 0500 Workers compensation Total personnel services Materials & supplies 2019 Budget Summary 2015 2016 2017 2018 2019 Chanize from 2018 Actual Actual Actual Budget Request Dollar Percent 11,787 12,028 12,520 13,128 13,496 368 2.80% 394 416 512 1,420 1,460 40 2.82% 904 921 985 1,113 1,144 31 2.79% 885 900 943 1,092 1,122 30 2.75% 936 952 920 2,400 2,448 48 2.00% 1,623 598 534 632 829 197 31.17% 16,529 15,815 16,414 19,785 20,499 714 3.61% 1230 Supplies, equipment 1,131 749 97 2,500 2,500 - 0.00% 1600 Supplies, operating 2,939 18 2,823 3,500 3,500 - 0.00% 1700 Motor fuels 2,841 1,906 3,379 3,800 3,800 - 0.00% 2400 Uniforms 52 53 51 116 116 - 0.00% 2410 Mats & towels 44 46 42 72 72 - 0.00% Total materials & supplies 7,007 2,772 6,392 9,988 9,988 - 0.00% Contractual services 3030 Other professional services 3530 Disposal 3630 Training 5130 Repairs, equipment 141 - - 4,000 Total contractual services Miscellaneous: 9900 Transfer out Total miscellaneous Total street sweeping Total expenditures Revenues over expenditures 4 6 - - - - 0.00% - - - 50,000 50,000 - 0.00% 6 141 - 280 280 - 0.00% 141 - - 4,000 4,000 - 0.00% 151 147 - 54,280 54,280 - 0.00% 71,000 32,000 32,000 32,000 31,000 (1,000) -3.13% 71,000 32,000 32,000 32,000 31,000 (1,000) -3.13% 94,687 50,734 54,806 116,053 115,767 (286) -0.25% 38,392 96,268 95,268 354,325 308,757 267,453 538,800 527,921 (10,879) -2.02% 139,904 (26,052) 41,108 (251,300) (225,421) 25,879 -10.30% Add back: Capital outlays - - - 102,920 105,000 2,080 2.02% Change in net asssets 139,904 (26,052) 41,108 (148,380) (120,421) 27,959 -18.84% Net assets, beginning year 3,091,341 3,167,772 3,141,720 3,182,828 3,034,448 (148,380) -4.66% Accounting Change GASB 68 pension (63,473) Net assets, end of year $ 3,167,772 $ 3,141,720 $ 3,182,828 $ 3,034,448 $ 2,914,027 $ (120,421) -3.97% 146,604 407,123 391,468 58 Fund: 745 Department: 4417 Street Cleaning 1230 Supplies, equipment < $5000 2,500 2,500 2,500 2,500 Mise. sweeper repairs - belts, pumps, hoses, filters, etc. 2,500 2,500 2,500 2,500 1600 Supplies, operating 2,300 700 100 400 2,300 700 100 400 2,300 700 100 400 2,300 700 100 400 Gutter brooms Belts, pumps, hoses, filters, etc... for sweeper Gloves, hearing protection, etc... 2 dirt shoes 3,500 3,500 3,500 3,500 1700 Motor fuels 3,250 1,000 2,800 1,000 2,800 1,000 2,800 1,000 Diesel fuel - 1000 gallons @ $2.80/gallon Hydraulic oil - 4 changes 4,250 3,800 3,800 3,800 2400 Uniforms 116 116 116 116 Uniforms/clothing (1.8% of $4,500,.2 FTE x $175 per contract) 116 116 116 116 2410 Mats & towels 72 72 72 72 Share of floor mats & shop towels (1.8% of $4,000) 72 72 72 72 3530 Disposal 50,000 50,000 50,000 50,000 Sweeping pile disposal (estimated 5 year project) 50,000 50,000 50,000 50,000 3630 Training 250 30 250 30 250 30 250 30 NPDES compliance training Maintenance Expo 280 280 280 280 5130 Repairs, equipment 4,000 4,000 4,000 410-0-0- Sweeper repairs 4,000 4,000 4,000 4,000 9900 Transfer out to Vehicle & Equip 32,000 32,000 32,000 31,000 Transfer to Vehicle & Equip Fund for future replacements 32,000 32,000 32,000 31,000 96,-/18 Y6,L625 90,ZO6 YJ,206 387,738 321,267 407,123 391,468 -35.69% -17.14% 26.72% -3.85% 59 THIS PAGE LEFT BLANK INTENTIONALLY m J C Each year, NMMA. compiles a list of legislative items that are important to NMMA and its members. The result is the Legislative Action Plan that provides the association's perspective on issues to assist in discussion of legislation impacting our region. NMMA.'s advocates and lobbyists utilize the action plan and the resulting priorities in conversations with legislators throughout the session as well when attending events in the North Metro. Members of NMMA also use the action plan as a tool in their conversations with their local representatives. NMMA is seeking your feedback as it updates the Legislative Action Plan for 2019. For your review, the 2018 Legislative Action Plan with comments on the progress of individual items is attached. Use the following form to provide any ideas you may have regarding the legislative priorities you think should be addressed in 2019. Your ideas will be compiled and may be included in the 2019 Legislative Action Plan. Please keep in mind that NMMA generally seeks priorities that impact the North Metro region or multiple member cities and have membership consensus. Please provide your comments no later than Tuesday, October 16 to ensure early consideration during the action plan development process. Providing answers to the following questions will be helpful to NN%4A lobbyist Troy Olsen as he compiles ideas for presentation to the NNIMA Operating Committee and Board of Directors. Please submit ideas and/or direct any questions to Troy (h•oyo@ewald.com). 1. Please describe the legislative change, priority or idea you wish to share. a. Rule making process used by Watershed Districts 2. Briefly describe the problem or issue your change or idea addresses. a. Watersheds have statutory authority to promulgate rules that can have significant fiscal impacts on development, including city infrastructure projects. The process lacks the same checks and balances that is found in state rulemaking where focus groups are created, rules are published, there is a comment period along with a Statement of Need and Reasonableness (SONAR). Upon publication of intent to adopt, if 25 or more people object in writing it goes to an Administrative Law Judge. b. Watersheds have none of the latter and the Board members are appointed versus being elected, together it results in Cities having unfunded mandates imposed upon on them with little recourse. 3. What do you identify as benefits of your change or idea? a. Rule making has to be more transparent and involved cities, developers and other impacted. b. There should be an appeals process as part of the adoption. c. Possibly look at the make-up of the board selection process 4. List (if any) concerns or potential negatives you recognize with your change or idea. a. None 7c. 5. Please provide your name, email, and phone number and/or any other comments if you would like. a. Nyle Zikmund, nyle.zilanund a,moundsviewmn.org, 612-860-7442 6. Are there items in the 2018 NMMA Legislative Action Plan you wish to see removed? If so, please provide comments. Suggestions for NMMA 2019 Legislative Action Plan Items Each year, NMMA compiles a list of legislative items that are important to NMMA and its members. The result is the Legislative Action Plan that provides the association's perspective on issues to assist in discussion of legislation impacting our region. NMIVIA.'s advocates and lobbyists utilize the action plan and the resulting priorities in conversations with legislators throughout the session as well when attending events in the North Metro. Members of NNDJA also use the action plan as a tool in their conversations with their local representatives. NMMA is seeking your feedback as it updates the Legislative Action Plan for 2019. For your review, the 2018 Legislative Action Plan with comments on the progress of individual items is attached. Use the following form to provide any ideas you may have regarding the legislative priorities you think should be addressed in 2019. Your ideas will be compiled and may be included in the 2019 Legislative Action Plan. Please keep in mind that NMMA generally seeks priorities that impact the North Metro region or multiple member cities and have membership consensus. Please provide your comments no later than Tuesday, October 16 to ensure early consideration during the action plan development process. Providing answers to the following questions will be helpful to NMMA lobbyist Troy Olsen as he compiles ideas for presentation to the NMIVIA Operating Committee and Board of Directors. Please submit ideas and/or direct any questions to Troy (iroyo@ewald.com). 1. Please describe the legislative change, priority or idea you wish to share. a. Workers Compensation Laws/Rules 2. Briefly describe the problem or issue your change or idea addresses. a. Based on a recent/current HR issue, the City has discovered the following; i. Any employee can have PTSD and not have to disclose this condition. ii. An employee can be undergoing treatment for PTSD and not be required to disclose. iii. If the employee is in the public safety department, current law is presumptive that the employer is the cause and the burden of proof is on the employer iv. Current law mandates the employer (City) to cover medical insurance for employee and family until age 65. Thus, an employee (for this example, a member of the public safety division) can claim PTSD because of job related duties, be under care for that condition, not have to disclose the condition or care, then at their determination decide the condition precludes continued employment, claim the disability is permanent with the burden of proof falling on the employer. Employee will receive workers compensation settlement and employer pays health care for employee and family until age 65. State has a fund to reimburse but only covers 25% to 35%. We would propose that a "task force" be formed to review the issues and make recommendations as the current construct appears to weigh more heavily in the employees favor with little to no recourse by the employer. 3. What do you identify as benefits of your change or idea? a. Greater Transparency b. Reduction in liability (potential for great harm if PTSD manifest itself at work resulting in behavior(s) that could lead to property damage or human harm/injury. c. Awareness of this issue. d. Shortfall in state funding for the unfunded state mandate 4. List (if any) concerns or potential negatives you recognize with your change or idea. a. None 5. Please provide your name, email, and phone number and/or any other comments if you would like. a. Nyle Zikmund, nyle.zilunund a,moundsviewmn.org, 612-860-7442 6. Are there items in the 2018 NMNIA Legislative Action Plan you wish to see removed? If so, please provide comments. Nyle, Paperless packets are tricky. Many cities have tried and failed. Other cities continue to try. A few have found success. And there are still many that find paper the most efficient medium for packets and this includes Roseville. One would thin that Roseville would have led the way on paperless packets but our Council (current and past) feel that the potential cost saving of electronic packets (eliminate staff time delivering packets and paper reduction) does not offset the efficiencies of paper. There are just a few components to paperless packets; Creation Distribution Review Annotation Retrieval (at meetings) Creation is the easy part. All current packets are distilled into a PDF document (at least thee should be) to be stored as an electronic record. Roseville's packets are PDF documents going back almost 18 years. Once the packet is finished, it is distributed by posting to the City website and then printed and delivered to each Council member by a CSO. The challenge for Mounds View in going paperless, as you pointed out, is the ability of every Council member to have access to the Internet to receive the packet. The cities that are "paperless" will still deliver a paper version to any Council member that is unable to access the Internet. Review and annotation is the tricky part. The benefit with paper is that many packets will contain detailed maps and diagrams. Some of these maps are printed 11X17 and folded in the packet. Viewing this electronically on a 9" tablet can be difficult for many. Making notations to an electronic document on a tablet requires software that would allow the Council member to add notes, highlight text and bookmark selected pages. These annotations must be saved to allow the Council member to be able to access this during the meeting. Adobe Acrobat (the subscription version) provides this functionality but from my experience, many Council members struggle with this part. It might require that Mounds View enlist a trainer to provide d solid working knowledge of any program you might select to provide the ability to annotate a PDF document. And finally, retrieval at meetings. This is another benefit of paper. It does not require power (obviously). But more importantly, it is the ease of thumbing through pages tagged by the Council member, reading the side notes and highlights. I have watched meetings where the Council member is busy swiping their finger across the tablet, pinching to zoom in and out of a document, trying to find their notes. And rarely looking up at the presenter or public. Roseville Council likes to stay engaged in the discussion and are hesitant about getting bogged down by a technology that requires hand and eye involvement with a tablet. At least this is what I have been told. Any of these potential issues could be overcome with proper training and providing the appropriate device to a Council member. And this is where you might find another problem. Some people abhor tablets (like myself) that find it inefficient to operate a computer without a keyboard. Some of the cities that are paperless have some Council members using an iPad while another prefers Android tablets). An iPad requires the user to have an AppleID. If Mounds View elects to use iPads you would need to have every individual user (including Council) to create their own individual AppleID. Android tablets do not require this but a person can associate their GMail email account to take advantage of personalizing apps. As for staff, I always question why staff would require both their desktop computer and a single purpose device for Council meetings. Roseville Department heads are all assigned notebooks or tablets as their primary working device and these are brought into meetings, be it a Council meeting or department head meeting. There are numerous tablets in the market that run Windows 10 Professional operating system so these can be part of the City network and provide a touch screen tablet interface when going mobile. At the desk, these are connected to a keyboard and multiple monitors to provide the same functionality as a desktop computer. In the end, your biggest challenge is getting an electronic packet in the hands of Council. Having a Council member pickup a device preloaded with a packet sort of defeat one of the efficiencies of paperless and that is the cost of delivering the packets. Now the time will be spent picking up a tablet. And staff would have to load these packets to the tablets. If these are iPads, staff would need to have the PIN that unlocks the tablet. To go paperless needs to have Council to be able to receive via email or download from the City website. This is my "two -cents". We can continue to push through these issues if it is the desire and intent of Council to eliminate paper. The one thing you will need to be aware of is that we (Roseville IT) cannot be involved in any support of this process. It is outside the realm of our responsibilities because we would have to accommodate 33 Councils along with countless commissions if we get involved. Currently any City that is paperless relies on their Council members to be able to understand and support their own technology with assistance from City staff if necessary.