Loading...
HomeMy WebLinkAboutAgenda Packets - 2018/12/03CITY OF MOUNDS VIEW CITY COUNCIL WORK SESSION AGENDA MOUNDS VIEW CITY HALL Monday, December 3, 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. 2019 Draft Municipal Budget 2. Electronic Handicap Controls for Public Works facility — Verbal Report 3. Splash Pad Update — Verbal Report 4. Live Broadcast experiment update — Verbal Report 5. Kennel License — Fostering — Verbal Report Next Work Session: Monday, January 7, 2019 at 6:30 pm Next City Council Meeting: Monday, December 10, 2018 at 6:30 pm THIS PAGE LEFT BLANK INTENTIONALLY MOLtNDEv 1 Item No: ,Z Meeting Date: December 3, 2018 Type of Business: Work Sessio Administrator Review: To: Honorable Mayor and City Council From: Mark Beer, Finance Director Item Title/Subject: 2019 Draft Municipal Budget Attached is the 2019 Draft Municipal Budget. The City Council has reviewed various portions of the municipal budget throughout the summer and fall and this is one last opportunity before considering final approval at the December 10, 2018 City Council meeting. The City Council adopted a preliminary General Fund levy increase of $218,856 or 4.4%, reestablished a street improvement levy of $150,000 or 3.02%, adopted debt service levy increase of $70,035 or 1.40% and the Police Officer referendum levy increased $14,800 or 0.3%. There was no increase in the EDA levy. The total levy increase proposed is $453,691 or 9.12%. Staff welcomes any comments or questions. R spectfully Submitted, L Mark Beer City of Mounds View 2019 Budget Summary Expenditures: 2015 2016 2017 2018 2019 Change from 2018 General Fund: Actual Actual Actual Budizet Request Dollar Percent Revenues: City Council 47,115 47,213 55,479 60,881 60,752 (129) Property taxes - Base levy 3,651,411 3,700,381 3,809,842 4,025,429 4,244,285 218,856 5.44% Special tax levies, Bonds 154,119 154,119 90,835 99,177 165,800 66,623 67.18% Special tax levies, Operations 226,145 233,145 244,145 334,345 349,145 14,800 4.43% Franchise tax 309,039 296,173 309,303 290,000 295,000 5,000 1.72% Other taxes 47,877 27,556 31,610 29,000 29,000 - 0.00% Hotel/motel tax 69,109 67,408 68,666 65,000 65,000 - 0.00% Licenses and permits 204,845 184,499 310,965 183,172 183,372 200 0.11% Intergovernmental 1,03 8,060 1,090,100 1,093,163 1,054,754 1,166,972 112,218 10.64% Charges for services 18,942 40,988 17,144 16,825 16,625 (200) -1.19% Fines & forfeitures 36,338 29,278 26,810 36,600 33,300 (3,300) -9.02% Interest 112,669 104,985 127,086 115,000 115,000 - 0.00% Miscellaneous 321,188 342,547 382,536 282,696 293,834 11,138 3.94% Transfers: Parks, Recreation & Forestry: DARE Fund 4,643 - - - - - 0.00% Water Fund - - - 78,103 80,446 2,343 3.00% Sewer Fund 56,611 58,309 60,058 61,860 80,446 18,586 30.05% Storm Water Fund 7,383 7,604 7,832 8,067 8,309 242 3.00% Street Light Fund 2,536 2,612 2,690 2,771 2,854 83 3.00% Vehicle & Equipment Fund 21,000 22,000 21,600 22,000 23,000 1,000 4.55% Debt proceeds 246,729 - 172,427 - - - 0.00% Total revenues 6,528,644 6,361,704 6,776,712 6,704,799 7,152,388 447,589 6.68% Expenditures: Legislative Services: City Council 47,115 47,213 55,479 60,881 60,752 (129) -0.21% Advisory Commissions 8,720 15,520 14,375 17,000 15,500 (1,500) -8.82% Subtotal 55,835 62,733 69,854 77,881 76,252 (1,629) -2.09% Administrative Services: City Administrator 271,314 282,476 314,338 285,610 309,806 24,196 8.47% Elections 22,222 47,279 32,575 24,500 26,832 2,332 9.52% Finance 246,268 255,786 261,574 271,256 274,306 3,050 1.12% Central Services 216,482 237,713 259,406 282,474 280,773 (1,701) -0.60% Subtotal 756,286 823,254 867,893 863,840 891,717 27,877 3.23% Community Development 353,381 320,413 324,265 458,347 477,389 19,042 4.15% Police 2,710,054 2,719,071 2,814,764 2,970,719 3,157,389 186,670 6.28% Fire 567,934 592,181 685,187 603,383 684,378 80,995 13.42% Public Works Administration 113,779 135,670 129,775 148,962 156,818 7,856 5.27% Parks, Recreation & Forestry: Recreation 112,429 109,358 109,071 118,849 122,042 3,193 2.69% Parks 333,043 322,085 280,083 337,519 359,752 22,233 6.59% Forestry 34,478 29,474 11,887 42,173 49,203 7,030 16.67% Subtotal 479,950 460,917 401,041 498,541 530,997 32,456 6.51% Fleet Services: Building & Grounds Mtnce 391,909 116,217 118,555 130,876 137,922 7,046 5.38% Vehicle & Equipment Mtnce 84,331 86,966 108,818 113,448 122,813 9,365 8.25% Subtotal 476,240 203,183 227,373 244,324 260,735 16,411 6.72% Streets: Pavement Management 203,268 185,346 192,701 231,743 233,930 2,187 0.94% Snow & Ice Control 134,936 131,951 107,680 148,117 151,259 3,142 2.12% Sign Maintenance 40,315 37,082 44,676 67,248 66,450 (798) -1.19% Subtotal 378,519 354,379 345,057 447,108 451,639 4,531 1.01% Other Convention & Visitor's Bureau 65,654 64,038 65,233 61,750 61,750 - 0.00% Social Service Coordination 20,178 20,259 20,461 20,748 21,329 581 2.80% Miscellaneous/contingency 4,975 5,061 5,238 6,500 6,500 - 0.00% Transfers to other funds 496,000 745,000 765,000 565,000 601,000 36,000 6.37% Debt service 20,268 24,495 24,495 24,496 24,495 (1) 0.00% Subtotal 607,075 858,853 880,427 678,494 715,074 36,580 5.39% Total expenditures 6,499,053 6,530,654 6,745,636 6,991,599 7,402,388 410,789 5.88% Net change in fund balance 29,591 (168,950) 31,076 (286,800) (250,000) 36,800 Beginning Fund Balance 9,584,822 9,614,413 9,445,463 9,476,539 9,189,739 Ending Fund Balance 9,614,413 9,445,463 9,476,539 9,189,739 8,939,739 36,800 00 C C N F V1 CT 110 O O N O �O N kn 0� V1 O o rn 0000 d h � N 69 N t� Vi NM d• --� zt 00 d oc N M 00 t- d' to m t- 6s3 O 1 CT CD O 00 64 d' M 00 k,n — ti fA _ 00 00 M oc C 00 kf) �O N kn N O 00 kn d 69 6A ol ' .0-� Lr) 64 fA O M CA \1O O �c 00 000 N Qi M M M M 64 O 00 N M 00 N O O 0, 1 0 0 0 O oo r M " 00 "C M o0 Vl C O vl [l- C (� cl� N C 00 N vi 11C �o " r N 00 �o C N N M c O CT O C Q\ N o � �r Ln \,o C N 00 \�o c r oo t- c N C\ � V1 M c d O C rn V) .-a 00 00 r O 't 00rn ^O (all o � C � R (01\ 00 00 Ln i` 00 N O --� O U U +'' ON � A � 69 Cq 0 0 (` O O ON M o ami R fU. ;t4 v) 00 U a u a �UE� N� a �D 69 3 0 0 d 00 Q d rn C M 00 N 00 69 0 0 0� Ln rn - � rt Vn CD O � 4 01 M U � 000 'n o �a M M 0 U c V1 CT 110 O O N O �O N kn 0� V1 O o rn 0000 d h � N 69 N t� Vi NM d• --� zt 00 d oc N M 00 t- d' to m t- 6s3 O 1 CT CD O 00 64 d' M 00 k,n — ti fA _ 00 00 M oc C 00 kf) �O N kn N O 00 kn d 69 6A ol ' .0-� Lr) 64 fA O M CA \1O O �c 00 000 N Qi M M M M 64 O 00 N M 00 N O O 0, 1 0 0 0 O oo r M " 00 "C M o0 Vl C O vl [l- C (� cl� N C 00 N vi 11C �o " r N 00 �o C N N M c O CT O C Q\ N o � �r Ln \,o C N 00 \�o c r oo t- c N C\ � V1 M c d O C rn V) .-a 00 00 r O 't 00rn ^O (all o 00 M (01\ 00 00 Ln i` 00 N O --� O U U +'' ON r � 69 Cq 0 0 (` O O ON M o ami R fU. ;t4 v) 00 U a u a �UE� N� a �D 69 3 0 0 d 00 Q d rn C M 00 N 00 69 0 0 0� Ln rn - � rt Vn CD 06 m 01 M 000 'n o M M N m o 0 M O � O 00 6A rn o 0 00 t C)" 0 00 'ct O 1p �O 00 M N 64 00 o t` N o 00 Ln M O 06 cl d 66] 4t l— �1O Om 00 6y" ,--i CD N 00 N 64 M r �h N N O �--� � m •--• M •--� N � N 69 00 0 0 O 00 cn V) Ln 00 m M � N M 69 o � o v� N m O 00 N ol� 00 \O O ^O � U •C. ~ SCO+ U U +'' N bA Q toL4 Cq w O A o ami R fU. ;t4 00 U a u a �UE� N� a 3 City of 1Mlounds View 2019 Budget Summary ii u 2015 2016 2017 2018 2019 Change from 2018 General Fund: Actual Actual Actual Budget Request Dollar Percent Capital Outlays Legislative Services: City Council - - - - - - 0.00% Advisory Commissions - - - - - - 0.00% Subtotal - - - - - - 0.00% Administrative Services: City Administrator - - - - - - 0.00% Elections - 28,112 - - - - 0.00% Central Services - - - - - - 0.00% Finance - - - - - - 0.00% Subtotal - 28,112 - - - - 0.00% Community Development - - - - - - 0.00% Police - - - - - - 0.00% Fire 38,925 55,059 213,082 65,036 59,761 (5,275) -8.11% Public Works Administration - - - - - - 0.00% Parks, Recreation & Forestry: Recreation - - - - - - 0.00% Parks 14,124 - - - - - 0.00% Forestry - - - - - - 0.00% Subtotal 14,124 - - - - - 0.00% Fleet Services: Building & Grounds Mtnce 246,729 - - - - - 0.00% Vehicle & Equipment Mtnce - - - - - - 0.00% Subtotal 246,729 - - - - - 0.00% Streets: Pavement Management - - - - - - 0.00% Snow & Ice Control - - - - - - 0.00% Sign Maintenance - - - - - - 0.00% Subtotal - - - - - - 0.00% Other Convention & Visitor's Bureau - - - - - - 0.00% Social Service Coordination - - - - - - 0.00% Miscellaneous/contingency - - - - - - 0.00% Transfers to other funds - - - - - - 0.00% Debt service - Fire Bonds - - - - - - 0.00% Subtotal - - - - - - 0.00% Total expenditures 299,778 83,171 213,082 65,036 59,761 (5,275) -8.11% ii u General Fund: Operating Expenditures: Legislative Services: City Council Advisory Commissions Subtotal Administrative Services: City Administrator Elections Central Services Finance Subtotal Community Development Police Fire Public Works Administration Parks, Recreation & Forestry: Recreation Parks Forestry Subtotal Fleet Services: Building & Grounds Mtnce Vehicle & Equipment Mtnce Subtotal Streets: Pavement Management Snow & Ice Control Sign Maintenance Subtotal City of Mounds View 2019 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Budj4et Actual Budget Request Dollar Percent 47,115 47,213 55,479 60,881 60,752 (129) -0.21% 8,720 15,520 14,375 17,000 15,500 (1,500) -8.82% 55,835 62,733 69,854 77,881 76,252 (1,629) -2.09% 271,314 282,476 314,338 285,610 309,806 24,196 8.47% 22,222 19,167 32,575 24,500 26,832 2,332 9.52% 216,482 237,713 259,406 282,474 280,773 (1,701) -0.60% 246,268 255,786 261,574 271,256 274,306 3,050 1.12% 756,286 795,142 867,893 863,840 891,717 27,877 3.23% 353,381 320,413 324,265 458,347 477,389 19,042 4.15% 2,710,054 2,719,071 2,814,764 2,970,719 3,157,389 186,670 6.28% 529,009 537,122 472,105 538,347 624,617 86,270 16.02% 113,779 135,670 129,775 148,962 156,818 7,856 5.27% 112,429 109,358 109,071 118,849 122,042 3,193 2.69% 318,919 322,085 280,083 337,519 359,752 22,233 6.59% 34,478 29,474 11,887 42,173 49,203 7,030 16.67% 465,826 460,917 401,041 498,541 530,997 32,456 6.51 145,180 116,217 118,555 130,876 137,922 7,046 5.38% 84,331 86,966 108,818 113,448 122,813 9,365 8.25% 229,511 203,183 227,373 244,324 260,735 16,411 6.72% 203,268 185,346 192,701 231,743 233,930 2,187 0.94% 134,936 131,951 107,680 148,117 151,259 3,142 2.12% 40,315 37,082 44,676 67,248 66,450 (798) -1.19% 378,519 354,379 345,057 447,108 451,639 4,531 1.01% Other Convention & Visitor's Bureau 65,654 64,038 65,233 61,750 61,750 - 0.00% Social Service Coordination 20,178 20,259 20,461 20,748 21,329 581 2.80% Miscellaneous/contingency 4,975 5,061 5,238 6,500 6,500 - 0.00% Transfers to other funds 496,000 745,000 765,000 565,000 601,000 36,000 6.37% Debt service - Lease payable 20,268 24,495 24,495 24,496 24,495 (1) 0.00% Subtotal 607,075 858,853 880,427 678,494 715,074 36,580 5.39% Total expenditures 6,199,275 6,447,483 6,532,554 6,926,563 7,342,627 416,064 6.01% General Fund Revenue Detail - 2019 Budget Acct 2015 2016 2017 2018 2019 Change from 2018 # Description Actual Actual Actual Budget Request Dollar Percent Taxes 3211 3101 Current ad valorem property tax 3,651,411 3,700,381 3,809,842 4,025,429 4,244,285 218,856 5.44% 3101 Fire bonds 154,119 154,119 90,835 99,177 165,800 66,623 67.18% 3101 PERA rate increase property tax 39,145 39,145 39,145 39,145 39,145 - 0.00% 3101 Police Officer market rate tax 187,000 194,000 205,000 295,200 310,000 14,800 5.01% 3102 Delinquent ad valorem prop tax 17,266 - - - - - 0.00% 3111 Manufact home tax - current 21,331 18,966 18,341 20,000 20,000 - 0.00% 3112 Manufact home tax - delinquent 9,280 8,590 13,269 9,000 9,000 - 0.00% 3180 Franchise tax on utilities 309,039 296,173 309,303 290,000 295,000 5,000 1.72% 3195 Hotel/Motel tax 69,109 67,408 68,666 65,000 65,000 - 0.00% 204 Total taxes 4,457,700 4,478,782 4,554,401 4,842,951 5,148,230 305,279 6.30% Licenses and Permits 3211 Liquor on -sale 16,800 17,290 18,540 16,800 16,800 - 0.00% 3212 Liquor off -sale 1,477 2,095 1,370 800 800 - 0.00% 3214 Sunday liquor sales - - - - - 0.00% 3215 Malt on -sale license - 115 - - - - 0.00% 3216 Malt off -sale - 135 - 100 100 - 0.00% 3221 Tobacco license 3,300 3,300 2,970 3,300 3,300 - 0.00% 3223 Amusement devices 720 704 688 700 700 - 0.00% 3231 Bowling alley 672 672 672 672 672 - 0.00% 3232 Garbage hauling 2,558 3,373 3,840 3,000 3,200 200 6.67% 3233 Gasoline station 850 850 675 850 850 - 0.00% 3234 Used car sales 204 204 204 200 200 - 0.00% 3235 Kennel 426 488 395 200 200 - 0.00% 3236 Restraurant licenses 3,806 3,641 3,068 3,200 3,200 - 0.00% 3238 Transient & solicitor 2,666 2,130 1,979 2,200 2,200 - 0.00% 3239 Apartment 28,967 25,715 16,751 26,000 26,000 - 0.00% 3240 Rental conversion 1,335 2,500 1,350 1,000 1,000 - 0.00% 3241 Dog license 1,428 7,119 1,135 1,400 1,400 - 0.00% 3242 Massage therapy 899 - 734 - - - 0.00% 3243 Chickens and bees 440 350 290 100 100 - 0.00% 3250 General contractor 760 1,400 1,201 1,100 1,100 - 0.00% 3251 HVAC contractor 5,050 4,840 3,610 4,400 4,400 - 0.00% 3252 Cement contractor - 40 - 100 100 - 0.00% 3253 Asphalt contractor 180 120 - 100 100 - 0.00% 3254 Excavating contractor - - 60 50 50 - 0.00% 3255 Sign & billboard contractor 60 100 - 100 100 - 0.00% 3256 Sewer & water contractor 100 - 60 - - - 0.00% 3257 Other contractor 3,430 2,800 2,440 2,000 2,000 - 0.00% 325-8 License check 2,058 2,132 1,619 1,800 1,800 - 0.00% 3260 Fire permits 950 1,780 2,700 900 900 - 0.00% Subtotal licenses 79,136 83,893 66,351 71,072 71,272 200 0.28% General Fund Revenue Detail - 2019 Budget Acct # Description 2015 Actual 2016 Actual 2017 Actual 2018 Budget 2019 Request Change from 2018 Dollar Percent 3268 Plan check fee 23,141 13,751 55,763 18,000 18,000 - 0.00% 3270 Building permits 53,481 39,681 117,308 50,000 68,500 18,500 37.00% 3271 Fixed fee - building permits 18,421 20,146 30,654 18,500 - (18,500) -100.00% 3273 HVAC permits 15,341 14,483 19,032 13,500 13,500 - 0.00% 3274 Plumbing permits 6,904 5,655 12,978 6,500 6,500 - 0.00% 3275 Non -building permits 7,679 5,314 5,900 5,000 5,000 - 0.00% 3278 Interim use permits - 500 - - - - 0.00% 3279 Conditional use permits 400 800 2,000 600 600 - 0.00% 3280 Building surcharge 1,052 99 135 - - - 0.00% 3281 Fixed fee building surcharge (921) (3) 594 - - - 0.00% 3282 Mechanical/commercial surchar; (38) 8 250 - - - 0.00% 3283 HVAC surcharge 60 33 (173) - - - 0.00% 3284 Plumbing surcharge 27 130 (135) - - - 0.00% 3285 Fire inspection surcharge - - 63 - - - 0.00% 3286 Water & sewer surcharge 158 3 104 - - - 0.00% 3287 Commercial plmb surcharge 4 6 141 - - - 0.00% 0.00% Subtotal permits 125,709 100,606 244,614 112,100 112,100 - 0.00% 0.00% Total licenses & permits 204,845 184,499 310,965 183,172 183,372 200 0.11% 7 Intergovernmental: 3318 Federal grant 350 2,902 - - - - 0.00% 3341 Local Government Aid 655,531 666,792 671,508 662,783 665,501 2,718 0.41% 3345 Performance Aid 1,742 1,821 1,843 1,800 1,800 - 0.00% 3346 PERA Aid 8,671 8,671 8,671 8,671 8,671 - 0.00% 3351 Street Aid - MSA maintenance 122,280 121,641 121,119 125,000 128,000 3,000 2.40% 3355 Police Aid 141,567 152,973 145,553 145,000 149,000 4,000 2.76% 3356 Police training 5,664 5,628 5,405 9,500 12,000 2,500 26.32% 3357 State police grant 389 455 - - - - 0.00% 3359 Other state grants 36,522 31,298 50,587 32,000 32,000 - 0.00% 3370 Other local government revenue 1,230 593 10,305 - - - 0.00% 3371 IDS # 621 - SRO 64,114 75,839 78,172 70,000 170,000 100,000 142.86% 3375 State pension contribution - 21,487 - - - - 0.00% Total intergovernmental 1,038,060 1,090,100 1,093,163 1,054,754 1,166,972 112,218 10.64% Charges for services 3410 Advertising revenue 205 530 - 500 500 - 0.00% 3415 Housing inspections 190 1,771 63 100 100 - 0.00% 3418 HRA inspections - - - 200 200 - 0.00% 3419 Investigations 2,806 200 100 200 200 - 0.00% 3421 Police reports 1,165 1,742 1,118 1,200 1,200 - 0.00% 3422 Documents / copies 351 262 39 150 150 - 0.00% 3423 Customer service 595 525 819 300 500 200 66.67% 3425 Book sales - various - 43 9 - - - 0.00% 3426 Reimbursed staff time - - - 200 100 (100) -50.00% 3430 Right-of-way 8,310 24,712 8,895 9,000 9,000 - 0.00% 3431 Street opening fee 200 - 1,600 - - - 0.00% 3432 Tree removal charges 2,670 8,353 2,001 2,000 2,000 - 0.00% 3433 Overload permits - 200 250 - - - 0.00% 3458 Zoning letter 150 500 150 75 75 - 0.00% 3461 Subdivision - 1,050 700 1,000 1,000 - 0.00% 3462 Variance 1,800 1,100 600 1,000 1,000 - 0.00% 3463 Rezoning 500 - 800 200 200 - 0.00% 3464 Development - non refund - - - 350 200 (150) -42.86% 3467 PUD amendment - - - 350 200 (150) -42.86% Total charges for services 18,942 40,988 17,144 16,825 16,625 (200) -1.19% 7 THIS PAGE LEFT BLANK INTENTIONALLY General Fund Revenue Detail - 2019 Budget Acct 2015 2016 2017 2018 2019 Change from 2018 # Description Actual Actual Actual Budget Request Dollar Percent Fines and Forfeitures 3510 Ramsey County municipal courl 3515 Mn Highway Patrol 3520 Administrative offenses 3525 False alarm charges Total fines & forfeitures Other Revenue 3550 Special assessments 3610 Investment income (charge) 3630 Billboard Lease 3631 Water tower rental 3634 Equipment and space rental 3639 Security 3650 Donations 3651 Donations - K9 3652 Donations - Parks 3654 COPS events 3656 Tree sales 3665 Park site permit 3679 Vending machine commissions 3680 Other revenue 3685 Insurance reimbursements 3911 Sale of assets 3912 Resale of materials Total other revenue Transfers & Debt proceeds 3972 Transfers: Vehicle & Equip replacemen DARE fund Water Sewer Storm Water Street light 3993 Debt proceeds Total Transfers & Debt 32,019 25,527 26,275 32,000 30,000 (2,000) -6.25% 50 - - 200 - (200) -100.00% 2,144 801 185 2,100 1,000 (1,100) -52.38% 2,125 2,950 350 2,300 2,300 - 0.00% 36,338 29,278 26,810 36,600 33,300 (3,300) -9.02% 4,195 3,706 3,895 3,000 3,000 - 0.00% 112,669 104,985 127,086 115,000 115,000 - 0.00% 105,303 112,562 114,889 119,889 122,394 2,505 2.09% 101,639 110,529 114,950 90,807 94,440 3,633 4.00% 5,454 1,194 1,230 1,150 1,150 - 0.00% 3,782 1,509 2,304 - - - 0.00% 5,100 4,080 5,991 - - - 0.00% 1,247 1,330 1,418 750 1,000 250 33.33% - - - - - 0.00% - - 7,150 5,000 5,000 - 0.00% - 204 204 - - - 0.00% 14,940 14,613 16,071 14,000 18,750 4,750 33.93% - 76 - 100 100 - 0.00% 10,584 20,812 49,530 11,000 11,000 - 0.00% 40,145 57,995 43,634 30,000 30,000 - 0.00% 28,338 12,513 7,075 5,000 5,000 - 0.00% 461 1,424 14,195 2,000 2,000 - 0.00% 433,857 447,532 509,622 397,696 408,834 11,138 2.80% 21,000 22,000 21,600 22,000 23,000 1,000 4.55% 4,643 - - - - - 0.00% - - - 78,103 80,446 2,343 3.00% 56,611 58,309 60,058 61,860 80,446 18,586 30.05% 7,383 7,604 7,832 8,067 8,309 242 3.00% 2,536 2,612 2,690 2,771 2,854 83 3.00% 246,729 - 172,427 - - - 0.00% 338,902 90,525 264,607 172,801 195,055 22,254 12.88% Total 6,528,644 6,361,704 6,776,712 6,704,799 7,152,388 447,589 6.68% 2019 Budget Summary 10 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budget Request Dollar Percent City Council (100 - 4100): Personnel services 0100 Salaries, regular 29,292 29,292 32,999 34,596 34,596 - 0.00% 0300 Social Security 1,129 1,129 1,315 2,647 2,647 - 0.00% 0321 PERA 885 885 970 1,730 1,730 - 0.00% 0500 Workers compensation 148 132 135 142 213 71 50.00% Total personnel services 31,454 31,438 35,419 39,115 39,186 71 0.18% Materials & supplies 1600 Supplies, operating 1,635 2,239 2,372 2,600 3,500 900 34.62% Total materials & supplies 1,635 2,239 2,372 2,600 3,500 900 34.62% Contractual services 3030 Other professional services 6,154 5,882 6,491 9,200 6,200 (3,000) -32.61% 3610 Memberships 5,161 5,429 5,681 5,716 5,716 - 0.00% 3630 Training & conferences 2,208 1,765 5,070 3,600 5,500 1,900 52.78% 4800 Bonding & insurance 503 460 446 650 650 - 0.00% Total contractual services 14,026 13,536 17,688 19,166 18,066 (1,100) -5.74% 0.00% Total City Council 47,115 47,213 55,479 60,881 60,752 (129) -0.21% 15,661 15,775 20,060 21,766 21,566 Advisory Commissions (100-4110): Materials & supplies 1600 Supplies, operating 41 - - 200 200 - 0.00% 2100 Books & periodicals - - - 100 100 - 0.00% Total materials & supplies 41 - - 300 300 - 0.00% Contractual services 3030 Other professional services 2,227 2,641 2,258 4,500 4,500 - 0.00% 3630 Training & conferences - - 65 200 200 - 0.00% 3900 Festival 6,452 12,879 12,052 12,000 10,500 (1,500) -12.50% Total contractual services 8,679 15,520 14,375 16,700 15,200 (1,500) -8.98% 0.00% Total Advisory Commissions 8,720 15,520 14,375 17,000 15,500 (1,500) -8.82% 10 Fund: 100 Department: 4100 Department: 4110 City Council Account Description 2016 2017 2018 2019 Description 1600 Supplies, operating 1,000 600 1,000 1,000 600 1,000 1,000 600 1,000 1,200 1,300 1 000 Employee awards luncheon Strategic planning sessions Plaques and gift certificates for employee length -of -service awards 2,600 2,600 2,600 3,500 3030 Other professional services - 6,200 - 6,200 3,000 6,200 - 6,200 Strategic planning session(s) facilitator Contractual minutes for Council mtgs ( $225 x 24 reg, + 3 special) 6,200 6,200 9,200 6,200 3610 Memberships 30 5,570 30 5,651 30 5,686 30 5,686 Mn Mayor's Association North Metro Mayors (Evaluate for value and effectiveness) 5,600 5,681 5,716 5,716 3630 Conferences 3,200 3,200 3,600 5,500 Council training, LMC conference, RCCLG dinners & NLC conference 3,200 3,200 3,600 5,500 4800 Bonds & insurance 700 700 650 650 General property & liability 700 1 700 650 650 18,300 18,381 21,766 21,566 -8.16% 0.44% 18.42% -0.92% Fund: 100 Department: 4110 Advisory Commissions Account Description 2016 2017 2018 2019 Description 1600 Supplies, operating 60 140 60 140 60 140 60 140 Misc supplies for various commissions. Copies for Charter Commission 200 200 200 200 2100 Books & periodicals 100 100 100 100 Misc periodicals - Comp plan review, Ordinance revisions. 100 100 100 100 3030 Other professional services 500 2,000 2,500 500 1,750 2,250 500 1,750 2,250 500 1,750 2,250 Misc. consultant services. Charter commission legal fees Planning Commission meeting minutes 5,000 4,500 4,500 4,500 3630 Training 150 150 75 125 75 125 75 125 Misc training & conferences. Planning Commissioner training & conferences 300 200 200 200 3900 Festival in the Park 4,500 - 5,000 5,500 - 5,000 5,500 1,500 5,000 5,500 - 5 000 City Festival in the Park (personnel, supplies) 60th Anniversery Fireworks 9,500 10,500 12,000 10,500 1s,1uu l.-),wu ri,uuu 12),Duu 0.00% 2.65% 9.68% -8.82% 11 2019 Budget Summary Materials & supplies 1230 Supplies, equipment 1600 Supplies, operating 2100 Books & periodicals Total materials & supplies Contractual services 3030 2015 2016 2017 2018 2019 Change from 2018 Training & conferences 3800 Actual Actual Actual Budget Request Dollar Percent Office of the City Administrator (100 - 4130): 3,709 1,490 1,549 2,650 2,650 - 0.00% Personnel services - 190 375 300 (75) -20.00% 4,638 13,216 0100 Salaries, regular 212,471 216,175 209,967 200,898 212,827 11,929 5.94% 0110 Salaries, over -time - - - 909 783 (126) -13.86% 0150 Salaries, part-time - - 10,885 16,903 23,416 6,513 38.53% 0300 Social Security 15,417 15,115 14,606 16,540 17,298 758 4.58% 0321 PERA 15,622 15,518 11,822 14,948 15,204 256 1.71% 0400 Group insurance 20,649 20,981 20,364 27,090 30,500 3,410 12.59% 0500 Workers compensation 2,325 1,471 1,321 1,347 1,878 531 39.42% Total personnel services 266,484 269,260 268,965 278,635 301,906 23,271 8.35% Materials & supplies 1230 Supplies, equipment 1600 Supplies, operating 2100 Books & periodicals Total materials & supplies Contractual services 3030 Other professional services 3100 Communications 3610 Memberships 3630 Training & conferences 3800 Mileage - 0.00% Total contractual services Total City Administrator Elections (100 - 4140): Contractual services 3030 Other professional services Total contractual services 7030 Capital outlays Total Elections 179 - 526 1,200 1,200 - 0.00% 13 - 349 75 75 - 0.00% - - - 35 35 - 0.00% 192 - 875 1,310 1,310 - 0.00% - 10,447 41,164 - - - 0.00% 741 1,078 1,350 1,300 1,300 - 0.00% 188 201 245 1,340 2,340 1,000 74.63% 3,709 1,490 1,549 2,650 2,650 - 0.00% - - 190 375 300 (75) -20.00% 4,638 13,216 44,498 5,665 6,590 925 16.33% 271,314 282,476 314,338 285,610 309,806 24,196 8.47% 4,830 13,216 45,373 6,975 7,900 22,222 19,167 32,575 24,500 26,832 2,332 9.52% 22,222 19,167 32,575 24,500 26,832 2,332 9.52% - 28,112 - - - - 0.00% 22,222 47,279 32,575 24,500 26,832 2,332 9.52% 12 Fund: 100 Department: 4130 Office of the City, Administrator Account Description 2016 2017 2018 2019 Description 1230 Supplies, equipment < $5000 825 1,200 1,200 1,200 Equipment and phones under the $5,000 capitalization threshold 825 1,200 1,200 1,200 1600 Supplies, Operating 75 75 75 75 Miscellaneous supplies 75 75 75 75 2100 Books & Periodicals 35 35 35 35 Miscellaneous reference books 35 35 35 35 3100 Communications 1,300 1,300 1,300 1,300 Cell phone service (2) employees 1,300 1,300 1,300 1,300 3610 Memberships - - 150 - 40 50 1,100 150 - 40 50 1,100 150 - 40 50 1,100 150 1,000 40 MAMA - (Administrator) Metro Area Manager's Association ICMA- International City Manager's Association Mn City County Managers Association New Brighton/Mounds View Rotary Club dues (administrator) Municipal Clerks & Finance Officers Association 190 1,340 1,340 2,340 3630 Training & conferences 100 500 100 1,000 850 100 - 100 500 100 1,000 850 100 3,200 100 500 100 1,000 850 100 - 100 500 100 1,000 850 100 - MAMA meetings LMC / miscellaneous training Chamber lunches LMC annual conference (2 attendees)(one every other year) Mn City County Managers Assoc conference Mn Clerks and Finance Officers Association (MCFOA) institute training National ICMA or NLC conference (City Administrator)(every other year) 2,650 5,850 2,650 2,650 3800 Mileage 375 375 375 300 Miscellaneous mileage @ IRS rate. 375 375 375 300 5,450 1U,1"/5 6,Y/5 /'9UU -28.85% 86.70% -31.45% 13.26% Fund: 100 Department: 4140 Elections' Account Description 2016 2017 2018 2019 Description 3030 Other professional services 23,200 22,000 22,000 22,332 - 10,500 - - 2,500 2,500 2,500 4,500 Ramsey County elections contract ($5583 per quarter) Special election (2020 state primary election) Voting equip. maint. Costs (2018 - $4,350 due to early voting) 25,700 35,000 24,500 26,832 7030 JEquipment 29,000 - - - Voting equipment 29,000 - - - 54; /UU i5,Uuu 24,JUU Lb,25jL -7.60% -36.01% -30.00% 9.52% 13 Finance (100 - 4150): Personnel services 0100 Salaries, regular 0300 Social Security 0321 PERA 0400 Group insurance 0500 Workers compensation 0990 Severence Subtotal Subtotal Materials & supplies 1230 Supplies, equipment 1600 Supplies, operating 2100 Books & periodicals 22,858 Subtotal Contractual services 3030 Other professional 3100 Communications 3430 Printing 3610 Memberships 3630 Training 5130 Repairs & maint., equipment 0.17% Subtotal Total Financial Services 2019 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budtet Request Dollar Percent 177,754 186,467 190,826 192,483 192,801 318 0.17% 12,751 13,092 13,387 14,725 14,750 25 0.17% 13,050 13,676 14,006 14,436 14,460 24 0.17% 21,860 22,311 22,858 26,910 27,981 1,071 3.98% 1,850 1,415 1,263 1,367 1,711 344 25.16% - - - - - - 0.00% 227,265 236,961 242,340 249,921 251,703 1,782 0.71% - - 95 175 900 725 414.29% - - - 75 50 (25) -33.33% 185 227 170 350 300 (50) -14.29% 185 227 265 600 1,250 650 108.33% 9,738 9,519 9,671 9,780 9,963 183 1.87% 480 480 480 480 600 120 25.00% 551 735 404 700 700 - 0.00% 970 995 1,015 1,040 1,070 30 2.88% 2,477 2,037 2,326 3,050 3,050 - 0.00% 4,602 4,832 5,073 5,685 5,970 285 5.01% 18,818 18,598 18,969 20,735 21,353 618 2.98% 246,268 255,786 261,574 271,256 274,306 3,050 1.12% 14 Fund: 100 Department: 4150 Finance Account Description 2016 2017 2018 2019 Description 1230 Supplies, equitpment < $5000 200 200 175 900 Furniture or equip. under the $5,000 capitalization threshold (phone $750) 200 200 175 900 1600 Supplies, operating 75 75 75 50 Misc supplies - planners, plaques, folders, files, etc. 75 75 75 50 2100 Books & periodicals 450 450 350 300 Misc computer & finance books & periodicals 450 450 350 300 3030 Other professional services 9,660 435 60 100 9,020 435 60 100 9,185 435 60 100 9,368 435 60 100 27.5% of audit (2019 - $34,065, 2020 - $34,745, 2021 - $35,440) GFOA financial reporting fee Safety deposit box rental Ramsey County overlapping debt, principal taxpayer reports 10,255 9,615 9,780 9,963 3100 Communications 480 480 480 600 cell phone ($50 month) 480 480 480 600 3430 Printing 350 350 350 350 350 350 350 350 Accts Payable & payroll checks & envelopes Invoices, receipts, & bank deposit slips 700 700 700 700 3610 Memberships 350 120 250 275 350 120 250 275 370 120 260 290 370 120 270 310 Government Finance Officer's Association (GFOA) Mn GFOA (2) AICPA Am. Institute of Certified Public Accts MNCPA Mn Society of Certified Public Accountants 995 995 1,040 11070 3630 Training & conferences 75 1,600 - 650 250 50 1,700 - 650 300 50 21000 - 700 300 50 2,000 - 700 300 Mn GFOA monthly meetings Seminars & training GFOA National conference (Defer)($2500) Accounting and software training Mileage 2,575 1 2,700 1 3,050_1 3,050 5130 JEquipment repairs 5,156 5,414 1 5,685 5,970 40% software support chgs. (30% each in Water, Sewer)(5% increase) 5,156 5,414 1 5,685 5,970 20,886 20,629 21,335 22,603 2.63% -1.23% 3.42% 5.94% 15 2019 Budget Summary Contractual services 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budeet Request Dollar Percent Central Services (100 - 4160): - 0.00% 3030 Other professional services 9,643 22,423 Materials & supplies 21,100 15,220 (5,880) -27.87% 3100 Telephone 0322 Pension expense GASB 68 - 2,031 - - - - 0.00% 1110 Stationery - 436 508 750 750 - 0.00% 1120 Copy materials 830 1,799 1,501 1,500 1,500 - 0.00% 1230 Supplies, equipment 21,316 22,102 20,230 22,391 23,000 609 2.72% 1600 Supplies, operating 12,662 12,670 12,429 14,500 14,500 - 0.00% 2100 Books & periodicals 169 169 169 340 340 - 0.00% Total materials & supplies 34,977 39,207 34,837 39,481 40,090 609 1.54% Contractual services 3010 General legal 45,489 41,364 41,551 44,000 44,000 - 0.00% 3030 Other professional services 9,643 22,423 38,524 21,100 15,220 (5,880) -27.87% 3100 Telephone 6,160 2,613 1,816 2,200 2,200 - 0.00% 3300 Postage 8,273 4,238 6,186 7,800 7,800 - 0.00% 3410 Legal notices 4,168 3,499 3,441 3,000 3,000 - 0.00% 3420 Advertising 2,634 2,739 692 2,500 2,500 - 0.00% 3430 Printing 7,945 8,601 9,788 12,600 12,600 - 0.00% 3610 Memberships 191253 20,049 20,226 20,752 20,770 18 0.09% 3630 Training & conferences 1,167 498 1,027 22,000 16,000 (6,000) -27.27% 4010 Rental, equipment 1,407 1,424 1,510 2,050 2,050 - 0.00% 4800 Insurance & bonds 15,212 14,453 30,659 18,000 18,000 - 0.00% 5100 Repairs & maint, computers 56,507 76,605 69,149 86,391 95,943 9,552 11.06% 5130 Repairs, equipment 3,647 - - 600 600 - 0.00% Total contractual services 181,505 198,506 224,569 242,993 240,683 (2,310) -0.95% Total central services 216,482 237,713 259,406 282,474 280,773 (1,701) -0.60% 16 Fund: 100 Department: 4160 Central Services' Account Description 2016 2017 2018 2019 Description 1110 Stationery 1,000 1,000 750 750 Envelopes, labels, letterhead, etc. 1,000 1,000 750 750 1120 Copy materials 1,500 1,500 1,500 1,500 Copy paper 1,500 1,500 1,500 11500 1230 Supplies, equipment < $5000 20,000 21,600 22,391 23,000 Comp & security equip under $5,000, pc's, software, switches, cameras.... 20,000 21,600 22,391 23,000 Replace pc's @ $800 4 yr replacement cycle 1600 Supplies, operating 15,400 14,000 14,000 14,000 Toner, rug service, paper, pens, staples, desk supplies, etc. 500 500 500 500 Misc operating supplies 15,900 14,500 14,500 14,500 2100 Books & periodicals 175 175 150 150 Employment handbooks/publications 190 190 190 190 Star Tribune - $190 365 365 340 340 3010 General legal 24,000 24,000 24,000 24,000 Retainer for legal services 20,000 20,000 20,000 20,000 Legal fees outside scope of retainer. 44,000 44,000 44,000 44,000 3030 Other professional services 5,700 5,700 12,000 6,000 General labor assistance and staff development - 10,000 - - Personnel market study - 3,086 3,100 3,100 Western Bank monthly fees - 360 400 400 US Bank positive pay service 1,500 1,200 1,200 1,200 Section 125 (flex spending plan) & COBRA administration 1,000 1,000 2,000 2,000 Human resources items 1,100 1,100 2,400 2,520 Web hosting (Revize) (5% annual increase) 9,300 22,446 21,100 15,220 3100 Telephone 7,400 2 400 2,200 2,200 Basic telephone (analog for alarms) 7,400 2,400 2,200 2,200 3300 Postage 300 300 300 300 Courier charges (delivery services) 7,500 7,500 7,500 7,500 General postage includes PW mailings for street projects. 7,800 7,800 7,800 7,800 3410 Legal notices 900 900 900 900 Truth in taxation notices and Ramsey County fees. 2,100 2 100 2,100 2 100 Legal notices and legal publications. 3,000 3,000 3,000 3,000 3420 Advertising 2,500 2,500 2,500 2,500 Job opening advertisements for vacant positions 2,500 2,500 2,500 2,500 3430 Printing 6,800 6,800 12,000 12,000 4 newsletters and postage, YMCA in Comm Ctr Fund. 200 200 200 200 Miscellaneous printing 400 400 400 400 City guides, directories & miscellaneous 7,400 7,400 12,600 12,600 3610 Memberships 600 625 625 625 Ramsey County League of Local Governments (RCLLG) 2,850 2,850 2,850 2,850 I-35W Corridor Coalition 4,835 4,901 5,097 5,115 Metro Cities (0.35% increase for 2019) 11,637 12,180 12,180 12,180 League of Mn Cities (No increase 2018, 2019) 19,922 20,556 20,752 20,770 3630 Training & conferences 1,000 1,000 1,000 1,000 League training & seminars - - 20,000 14,000 Staff development training (Martin-McAllister) 800 800 800 800 OSHA and blood borne pathogen training 200 200 200 200 Information technology training 2,000 2,000 22,000 16,000 Misc 4010 Rental, equipment 150 150 150 150 1,600 1,600 1,900 1,900 Postage machine and scale rental 1,750 1,750 2,050 2,050 4800 Bonding & insurance 19,000 17,000 15,000 15,000 Insurance policy premiums 3,000 3,000 3,000 3,000 Allowance for insurance policy deductibles 22,000 20,000 18,000 18,000 5100 Repairs, computer 64,000 69,600 72,100 80,305 Computer, phone, network & technology assistance - City of Roseville 2,609 2,688 2,688 2,755 Laserfiche annual maintenance and storage - - - 1,280 Adobe annual license (13) - - 1,603 1,603 Denial of Service protection contract (1.687% of $95,000) 5,750 5,750 6,000 61000 Computer, printer, and networks repairs. 4,190 4,190 4,000 4,000 Copier maintenance + overages 76,549 82,228 86,391 95,943 5130 Repairs, equipment 600 600 600 600 Postage meter, copy machine, fax, misc. 600 600 600 600 242,986 255,645 282,474 280,773 3.03% 5.21% 10.49% -0.60% 17 2019 Budget Summary Contractual services 2015 2016 2017 2018 2019 Change from 2018 3030 Other professional Actual Actual Actual Budget Request Dollar Percent Community Development (100 - 4180): 822 1,575 13,481 3,000 3,000 - 0.00% Personnel services Telephone 1,365 1,550 1,375 1,421 2,664 1,243 0100 Salaries, regular 259,655 236,428 225,355 280,198 305,995 25,797 9.21% 0110 Overtime, regular - - 99 699 727 28 4.01% 0150 Salaries, part time 1,226 1,238 293 1,482 10,792 9,310 628.21% 0300 Social Security 18,069 16,801 16,875 21,602 24,292 2,690 12.45% 0321 PERA 18,504 16,701 16,261 21,067 23,814 2,747 13.04% 0322 Pension expense GASB 68 - 1,604 - - - - 0.00% 0400 Group insurance 35,975 28,371 19,315 53,640 49,680 (3,960) -7.38% 0500 Workers comp 2,859 1,660 1,434 1,632 2,500 868 53.19% 0600 Unemployment - - 654 - - - 0.00% Total personnel services 336,288 302,803 280,286 380,320 417,800 37,480 9.85% Materials & supplies 1230 Supplies, equipment - 62 125 500 500 - 0.00% 1600 Supplies, operating 110 48 143 300 1,400 1,100 366.67% 1700 Motor fuels & lubricants 1,745 732 691 2,000 1,560 (440) -22.00% 2100 Books & periodicals 498 321 199 375 725 350 93.33% 2400 Uniforms - 82 66 200 300 100 50.00% Total materials & supplies 2,353 1,245 1,224 3,375 4,485 1,110 32.89% Contractual services 3030 Other professional 9,431 11,749 24,215 65,706 42,360 (23,346) -35.53% 3040 Consultants, development review 822 1,575 13,481 3,000 3,000 - 0.00% 3100 Telephone 1,365 1,550 1,375 1,421 2,664 1,243 87.47% 3430 Printing 543 510 - 900 900 - 0.00% 3610 Memberships 1,180 120 1,658 1,200 1,460 260 21.67% 3630 Training and conferences 1,393 657 1,945 2,325 4,620 2,295 98.71% 3800 Mileage 6 204 81 100 100 - 0.00% Total contractual services 14,740 16,365 42,755 74,652 55,104 (19,548) -26.19% Total Community Development 353,381 320,413 324,265 458,347 477,389 19,042 4.15% 18 Fund: 100 Department: 4180 Community Development Account Description 2016 2017 2018 2019 Description 1230 Supplies, equipment < $5000 825 500 500 500 Miscellaneous equipment & computer peripherals 825 500 500 500 1600 Supplies, operating 100 100 100 600 Presentation supplies - 600 ARC GIS License 200 200 200 200 Office supplies 300 300 300 11400 1700 Motor fuels & lubs 2,200 1 840 2,000 11-56-0- Unleaded fuel: 600 gallons @ $2.60 (Gas for Comm Devlopment) 2,200 1,840 2,000 1,560 2100 Books & periodicals 100 100 100 450 Reference materials 100 100 100 100 Intl. Code Council Manuals and Code Updates 175 175 175 175 Manuals, pamphlets, etc. 375 375 375 725 2400 Uniforms 200 200 200 300 Clothing for inspections staff 200 200 200 300 3030 Other professional 1,300 1,300 1,300 1,300 Ramsey County JPA (geographic information system) 4,620 4,485 5,080 5,080 Permit Works system annual software support (includes busi. lic. mod) - - - 4,995 Permit Works code enf. module (one-time)(annual maintenance $1,495) - - - 1,495 Permit Works code enforcement module software support 1,595 - 1,020 1,990 Permit works mobile inspector (2) - - - 1,500 Permit works implementation and training 2,040 1,020 - - Roseville Net Motion VPN 2 factor authentication 500 500 500 500 Filing fees (Ramsey County increased fees from $29 to $48) 2,110 2,195 2,306 - Comcate Code Enforcement Mgr license (5% annual) 1,987 1,200 1,200 - Comcate mobile access (5% annual) 500 500 500 500 GIS assistance - - 5,000 1,000 Consulting Building Official services - 12,000 44,800 20,000 Comp plan assistance (carryover) 4,000 4,000 4,000 4,000 Abatements of nuisance properties 18,652 27,200 65,706 42,360 3040 Consulting - Development 750 750 750 750 Environmental reviews Review (reimbursable) 750 750 750 750 City attorney services 750 750 750 750 Development case reviews 750 750 750 750 Engineering services 3,000 3,000 3,000 3,000 3100 Telephone 1,300 1,000 11000 1,823 Verizon Cell Accounts (2) for inspectors, Reimb. Director $50/mo 481 961 421 841 network cards for biding. Insp. and code enforcement (2 cards @ $35.01) 1,781 1,961 1,421 2,664 3430 Printing 1,000 900 900 900 Forms, flyers, etc. 1,000 900 900 900 3610 Memberships 300 245 265 320 American Planning Association (APA) - National (1) - 50 50 50 American Planning Association (APA-MN) - State (1) - 135 135 155 American Institute of Certified Planners (AICP) - 750 300 350 Sensible Land Use Coalition (monthly lunches (6 @ $58) 120 - - 200 Assoc. of MN Building Officials (2) 125 140 140 140 International Code Council (ICC) 95 100 100 100 1O Lakes Chapter of ICC 100 105 105 - MN Assoc. Housing Code Officials (MARCO) 100 105 105 105 MN Building Permit Technicians Association (MBPTA) - - - 40 840 1,630 1,200 1,460 3630 Training & conferences 600 800 850 850 APA state conference (one attendee) - 225 225 400 ICC code seminars - - - 1,200 Tuition reimbursement - - - 600 Leadership Growth 300 300 300 400 Other software training 300 500 950 1,170 Other staff training & seminars 1,200 1,825 2,325 41620 3800 Mileage 100 100 100 100 Misc. use of personal automobiles 100 100 100 100 30,473 39,831 78,027 59,589 16.57% 30.71% 95.90% -23.63% 19 Police (100 - 4200): Personnel services: 0100 Salaries, regular 0110 Overtime 0150 Salaries, part-time 0300 Social Security 0321 PERA 0322 Pension expense GASB 68 0400 Group insurance 0500 Workers compensation - Total personnel services Materials & Supplies 1210 Supplies, buildings & grounds 1230 Supplies, equipment 1600 Supplies, operating 1700 Motor, fuels & lubricants 2100 Books & periodicals 2400 Uniforms & clothing 10.56% Total materials & supplies Contractual services 2019 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budtet Request Dollar Percent 1,570,903 1,631,402 1,656,857 1,773,491 1,875,193 101,702 5.73% 80,112 96,684 108,971 66,941 74,008 7,067 10.56% - - 5,034 - - - 0.00% 27,501 29,230 31,259 34,650 35,124 474 1.37% 254,166 256,686 268,652 299,812 319,932 20,120 6.71% - 14,949 - - - - 0.00% 220,722 231,125 254,141 284,520 293,580 9,060 3.18% 78,193 73,788 65,080 74,990 116,118 41,128 54.84% 2,231,597 2,333,864 2,389,994 2,534,404 2,713,955 179,551 7.08% - - 345 - - - 0.00% 35,038 23,114 8,941 13,100 6,100 (7,000) -53.44% 7,664 5,706 9,824 9,700 10,700 1,000 10.31% 39,643 24,716 30,915 36,750 38,220 1,470 4.00% 1,031 723 217 300 300 - 0.00% 15,168 20,682 18,761 20,820 22,070 1,250 6.00% 98,544 74,941 69,003 80,670 77,390 (3,280) -4.07% 3020 Legal, prosecuting attorney 72,774 74,226 74,136 78,690 75,000 (3,690) -4.69% 3030 Other professional services 3,183 3,115 2,456 3,690 3,690 - 0.00% 3050 Dispatching 108,058 106,425 107,131 106,714 94,793 (11,921) -11.17% 3055 Information systems fees 2,565 4,907 2,055 4,955 4,955 - 0.00% 3070 COPS events 802 1,731 6,498 6,000 6,000 - 0.00% 3080 Veternarian services 5,449 1,199 586 2,000 2,000 - 0.00% 3100 Telephone 2,879 4,720 6,656 8,882 10,077 1,195 13.45% 3210 Electricity 280 289 356 320 320 - 0.00% 3430 Printing 149 168 115 400 400 - 0.00% 3610 Memberships 1,495 2,171 1,845 1,856 1,656 (200) -10.78% 3630 Training 11,387 15,045 15,813 17,770 22,770 5,000 28.14% 4010 Rental, equipment - - 445 - - - 0.00% 4800 Insurance & bonds 42,602 52,324 81,179 54,500 59,500 5,000 9.17% 5100 Technology maintenance 121,539 39,937 52,236 60,028 77,043 17,015 28.35% 5130 Maintenance, equipment 6,751 4,009 4,260 9,840 7,840 (2,000) -20.33% Total contractual services 379,913 310,266 355,767 355,645 366,044 10,399 2.92% Total police 2,710,054 2,719,071 2,814,764 2,970,719 3,157,389 186,670 6.28% 20 Fund: 100 Department: 4200 Police Account Description 2016 2017 2018 2019 Description 1210 Supplies, bldgs & grounds 800 500 - - Carpet cleaning & misc maintenance items 800 500 - - 1230 Supplies, equipment < $5000 4,500 3,000 3,000 3,000 Miscellaneous office equipment 800 1,000 - - SLR camera for Investigations add PSO camera $200 2,000 - - - Shredder 3,000 - - - Rifle mounts (10@$300 each) 4,000 - - - Bicycles and racks for park patrol (3) - 800 800 800 Alco -sensor portable breath test (PBT's) ($800 each) 10,300 9,300 9,300 2,300 (3) squad computer in 460, light bar $2,300 24,600 14,100 13,100 6,100 1600 Supplies, operating 3,400 3,000 3,000 3,000 Photo print supplies, fire extinguishers, gloves, inkjet cartridges, toner, etc. 700 600 1,200 1,200 K9 Food 500 500 500 500 Portable radio batteries (10) @ $50 2,500 5,000 5,000 6,000 Batteries, breathalyzer parts, DVD's & CD's, disinfectant, simulation ammo ammunition, crime scene tape, emergency blankets, etc. 7,100 9,100 9,700 10,700 1700 Motor, fuels, & lubs - 38,775 32,430 35,250 36,660 Unleaded gas 14,100 gallons @ $2.60/gal. 1,032 863 1,500 1,560 K9 take home car gas 600 gallons @ $2.60 39,807 33,293 36,750 38,220 2100 Books & periodicals 900 900 300 300 Traf law, crim. law, HR, employ. law, school year books, & misc. books 900 900 300 300 2400 Uniforms & clothing 710 775 775 775 Chief 710 775 775 775 Deputy Chief 4,000 4,000 4,000 4,000 Initial officer set-ups replacing up to two retiring officers 12,070 13,175 13,190 14,800 16 officers @ $775, 3 sgts @ $780 - 2018, $800 - 2019 1,080 1,080 1,080 720 Administrative assistant, Clerk -typist, 2@$360 1,000 1,000 1,000 1,000 Traffic vests, Taser holsters, & misc items 19,570 20,805 20,820 22,070 3020 Legal, prosecuting attorney 76,398 78,690 78,690 75,000 Retainer ($6,125 per month)(misc charges $1,500) 76,398 78,690 78,690 75,000 3030 Other professional services 700 900 900 900 Tobacco compliance project 150 150 150 150 Hazardous material disposal fee 1,500 1,400 1,400 1,400 Lab fees, blood tests, physical tests, video, misc. 240 240 240 240 Automated Pawn service 1,000 1,000 1,000 1,000 Civil Service and medical testing for new officers 3,590 3,690 3,690 3,690 3050 Dispatching 106,426 107,131 106,714 94,793 Ramsey County dispatching 106,426 107,131 106,714 94,793 3055 Informational systems fees 2,101 2,080 2,080 2,080 State service fee - CJDN ($510 per quarter) - 2,350 2,350 2,350 BCA connectivity charge thru Ramsey Cty for CAD (new) 525 525 525 525 IACP.net ($525 annual) 2,626 4,955 4,955 4,955 3070 COPS events 700 1,000 6,000 6,000 National night out, town hall meeting, child ID, stickers, shop, bowl, other outs 700 1,000 6,000 6,000 3080 Veterinarian services 4,500 1,000 1,000 1,000 Veterinary impound services 1,000 500 1,000 1,000 K9 vet services 5,500 1,500 2,000 2,000 3100 Telephone 6,420 6,420 5,100 5,875 Verizon cell phones (12 phones)(8 smart, 4 basic) - - 3,782 4,202 Air cards for squads CAD (10) at $35.01 per month (moved from 5100) 6,420 6,420 8,882 10,077 3210 Electricity 320 320 320 320 Civil defense siren's electricity 320 320 320 320 21 THIS PAGE LEFT BLANK INTENTIONALLY 22 Fund: 100 Department: 4200 Police Account Description 2016 2017 2018 2019 Description 3430 Printing 500 500 400 400 Dept manual, Emergency management manual, business cards, 500 500 400 400 3610 Memberships 50 50 - - FBI/LEEDA Law Enfor. Execu. Devel. Assoc. 2@ $50 75 75 75 75 Tri -County Investigator Association 45 45 45 45 Mn Crime Prevention Association 130 130 - - MN Emergency Managers Assoc. 420 420 420 420 Mn Police chiefs 129 150 150 150 IACP (International Association of Chief of Police) 36 36 36 36 MN Sex Crime Investigators Assoc. 30 30 30 30 Natl. Assoc. School Resource Officers 100 100 200 200 K9 memberships 200 200 200 - Notary commission (3 year due in 2021)($120+$20) 630 630 630 630 POST license reimbursement 7 a $90 30 35 35 35 Prof. Law Enforcement Admin. Assoc. 35 35 35 35 National Association of Town Watch 1,910 1,936 1,856 1,656 3630 Training 600 710 710 710 MN Chiefs conference 2@$355 200 400 400 400 BCA/CJDN training (new records tech) 320 450 450 450 Intox certification (6@$75) 1,000 1,000 1,000 1,000 Range Rental 400 400 400 400 MN Sex Crimes Investigators Assoc Conference 3,000 2,000 2,000 2,000 Tuition reimbursement 1,200 1,400 3,000 3,000 Supervisor training 1,400 1,400 2,800 2,800 K9 training 600 600 600 600 Emergency Management training 1,700 1,700 4,000 5,000 Employee development courses - - - 4,000 Ramsey County SWAT Training and Equipment (New for 2019) 1,615 1,615 1,615 1,615 Patrol on-line program 795 795 795 795 Post training for officers at Century College (1 officers) 12,830 12,470 17,770 22,770 4800 Insurance & bonds 25,000 25,000 25,000 25,000 Liability and automotive insurance 14,100 14,100 14,500 14,500 Insurance per MN Statute 299A.465 25,000 15,000 15,000 20,000 Allowance for insurance policy deductibles 64,100 54,100 54,500 59,500 5100 Technology - maintenance 2,000 2,000 2,000 - Computer network & technology assistance - City of Roseville (consolidated bi agreements & support 1,800 1,000 1,000 1,000 Copier maintenance + overages 2,000 2,000 4,000 4,000 Automatic License plate reader maintenance - - 2,500 2,500 Taser Maintenance - - 2,500 2,500 Watch Guard body camera maintenance - - 2,000 2,000 Body Camera Server maintenance 3,840 3,782 - - Air cards for squad CAD (9) at $35.01 per month (move to 3100) 2,500 3,500 5,185 7,345 Milestone video maintenance and licenses 2,428 3,110 3,777 3,777 NetMotion 2 factor authentication (state required) - 313 313 313 CAD interface (Zuercher) 12,500 15,780 17,380 30,044 IT support for squad computers and other technology (Roseville) 20,355 21,373 21 373 23,564 Operating costs of police records management system and ticket writer (5%) 47,423 52,858 62,028 77,043 5130 Repairs, equipment 3,000 3,000 2,579 2,579 Misc. equipment repair - defibs, cameras, recorders, fax, printers. 450 400 800 800 Fire extinguisher recharging and inspection 1,000 1,000 1,000 1,000 Civil Defense siren repair & maint. (all 3 have been upgraded 17, 18) 4,000 2,000 2,000 2,000 Radio repair (one-time reprogramming fee $50) 1,440 1,440 1,461 1,461 800 MHZ radio licenses fees 39 @ 3.12 per month 9,890 7,840 7,840 7,840 436,410 412,108 436,315 443,434 -21.15% -5.57% 5.87% 1.63% 23 2019 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budget Request Dollar Percent Recreation (100 - 4350): Contractual services: 3036 Contractual recreation 111,289 108,241 107,987 117,349 120,542 3,193 2.72% 4800 Bonding & insurance 1,140 1,117 1,084 1,500 1,500 - 0.00% Total contractual services 112,429 109,358 109,071 118,849 122,042 3,193 2.69% Total Recreation 112,429 109,358 109,071 118,849 122,042 3,193 2.69% 26 Fund: 100 Department: 4350 Recreation Account Description 2016 2017 2018 2019 Description 3036 Contractual recreation 103,713 105,787 110,349 114,542 9,000 8 000 7,000 6 000 YMCA Mgt contract (39.5% of $289,980)(est. inflation + 1.5%)(use 3.8%) Ice Skating supervision 112,713 113,787 117,349 1201542 [4800 Bonding & insurance 1,700 1,700 1,500 1,500 Insurance & bonding cost. 1,700 1,700 1,500 1,500 114,413 11J,425/ 116,64Y 1/-/,v4/- 1.61% 0.94% 2.91% 2.69% 27 2019 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budtet Request Dollar Percent Parks (100 - 4360): Personnel services Supplies, Bldgs & grnds 6,456 11,681 5,876 10,600 12,600 2,000 0100 Salaries, regular 116,799 121,805 122,664 122,184 132,393 10,209 8.36% 0110 Overtime, regular 8,569 11,190 12,486 4,970 5,403 433 8.71% 0150 Salaries, part-time 29,448 24,469 22,025 33,180 35,945 2,765 8.33% 0300 Social Security 11,318 11,479 11,758 12,265 13,290 1,025 8.36% 0321 PERA 9,376 9,917 9,445 9,537 10,335 798 8.37% 0322 Pension expense GASB 68 - 1,194 - - - - 0.00% 0400 Group insurance 20,899 21,399 11,821 24,399 24,881 482 1.98% 0500 Workers compensation 9,129 8,864 7,915 8,270 12,031 3,761 45.48% 0600 Unemployment 3,275 3,806 - - - - 0.00% 4,884 Total personnel services 208,813 214,123 198,114 214,805 234,278 19,473 9.07% Materials & supplies: 1210 Supplies, Bldgs & grnds 6,456 11,681 5,876 10,600 12,600 2,000 18.87% 1220 Supplies, vehicles & mowers 4,321 - 367 6,500 6,500 - 0.00% 1230 Supplies, equipment 6,693 6,583 4,114 6,250 6,250 - 0.00% 1600 Supplies, operating 14,461 9,788 6,391 10,900 10,500 (400) -3.67% 1700 Motor fuels & lubs 11,692 6,609 4,819 8,200 8,510 310 3.78% 2400 Uniforms & clothing 1,046 1,241 1,299 1,370 1,370 - 0.00% 2410 Mats & towels 609 704 537 728 728 - 0.00% 3630 Total materials & supplies 45,278 36,606 23,403 44,548 46,458 1,910 4.29% Contractual services: 3030 Other professional services 9,744 10,456 8,670 10,300 10,300 - 0.00% 3100 Telephone 1,575 2,014 1,363 2,056 2,056 - 0.00% 3200 Water & sewer 5,442 3,928 3,091 6,500 6,500 - 0.00% 3210 Electricity 10,214 9,711 8,435 10,000 10,000 - 0.00% 3220 Natural gas 4,546 4,057 4,306 4,800 4,800 - 0.00% 3530 Refuse collection - 87 - - 0.00% 3610 Memberships - 40 60 90 90 - 0.00% 3630 Training & conferences 913 736 386 1,670 2,520 850 50.90% 3900 Grants & subsidies 11,500 11,500 11,500 11,500 11,500 - 0.00% 4010 Rental, equipment 1,096 705 102 2,000 2,000 - 0.00% 4030 Portable restrooms 4,884 6,306 7,122 5,000 5,000 - 0.00% 4800 Bonding & insurance 10,729 10,659 10,322 15,000 15,000 - 0.00% 5110 Repairs, bldg & grounds 4,185 9,567 3,209 9,250 9,250 - 0.00% 5130 Repairs, equipment - 1,590 - - - - 0.00% Total contractual services 64,828 71,356 58,566 78,166 79,016 850 1.09% Capital outlays 7030 Equipment 14,124 - - - - - 0.00% Total capital outlays 14,124 - - - - - 0.00% Total Parks 333,043 322,085 280,083 337,519 359,752 22,233 6.59% 110,106 107,962 81,969 122,714 125,474 28 Fund: 100 Department: 4360 Parks Account Description 2016 2017 2018 2019 Description 1210 Supplies, bldgs & grounds 200 200 200 200 Replace bleacher parts 200 200 200 200 Repair hockey boards, gates 300 300 300 300 Sod 2,000 2,000 2,000 2,000 County 10 trailway landscaping mulch, shrubs, and plants 500 500 500 500 Janitorial supplies 150 150 150 150 Snow shovels 200 200 200 200 Ice melt 500 500 500 500 Round up 500 500 500 500 Perennial flowers for park signs 1,500 1,500 1,500 1,500 Damaged building components (windows, locks, etc.) 300 300 300 300 Graffiti remover 250 250 250 250 Goose repellent 2,000 2,000 2,000 2,000 Replace irrigation heads - 2,000 - 2,000 City Hall Park sign (estimate) 2,000 2,000 2,000 2,000 Seed, fertilizer 10,600 12,600 10,600 12,600 1220 Supplies, vehicles 7,000 6,000 3,500 3,500 Oil filters, mower blades, tires, vehicle registration fees, 3,000 2,000 3 000 3,000 Miscellaneous repairs 10,000 8,000 61500 6,500 1230 Supplies, equipment < $5000 250 250 250 250 Drinking fountain parts 250 250 250 250 Field Lights 250 250 250 250 Park signage 1,000 1,000 1,000 1,000 Bases, jox boxes, etc. 2,000 - - - Drag for ball fields - 1,750 - - Gutter broom attachment - 500 - - Chain saw (emergency only)(every 2 years) 2,500 4,500 4,500 4,500 Replace park equipment, fixtures and misc parts 6,250 8,500 6,250 6,250 1600 Supplies, operating 2,000 2,500 2,500 2,500 Fiber fill for play lots & courts 200 200 200 200 Tri mix 2,000 2,000 2,000 2,000 Wood chips for trees 500 500 500 500 Ag -lime for fields 500 500 500 300 Surface drying compound 400 800 800 800 Nets 3,100 3,100 3,100 3,100 Field paint & chalk (partially reimb by school district) 800 800 800 700 Landscaping materials 500 500 500 400 Hand tools 10,000 10,900 10,900 10,500 1700 Motor fuels & lubes 4,500 5,060 5,500 5,720 2,200 gallons of unleaded gas @ $2.60 3,150 2,520 2,700 2,790 900 gallons of diesel fuel @ $3.10 7,650 7,580 8,200 8,510 2400 Uniforms & clothing 350 350 350 350 Clothing allowance 2.0 FTE 820 820 820 820 Uniforms 18.2% of $4,500 200 200 200 200 Safety glasses, masks, ear protection, etc. 1,370 1,370 1,370 1,370 2410 Mats & towels 728 728 728 728 Share of floor mats and shop towels 18.2% of $4,000 728 728 728 728 3030 Other professional services 240 240 240 240 Fire extinguisher inspection/maint. (2@ $120) 600 600 600 600 HVAC maintenance 840 960 960 960 Fire sprinkler testing (4@ $210) 120 120 120 120 Backflow prevention testing (2@ $60) 8,500 8,380 8,380 8 380 Broadleaf control 10,300 10,300 10,300 10,300 29 THIS PAGE LEFT BLANK INTENTIONALLY 30 Fund: 100 Department: 4360 Parks (continued) Account Description 2016 2017 2018 2019 Description 3100 Telephone 1,206 850 1,206 850 1,206 850 1,206 850 Cellular phones (13.1% of $9,200) GPS units for mowers (split with dept 4472) 2,056 2,056 2,056 2,056 3200 Water & wastewater 7,000 6,500 6 500 6,500 Parkland irrigation & park bathrooms 7,000 6,500 61500 6,500 3210 Electricity 7,200 10-10- 0- 0- 10,000 10,000 Est. 5 park buildings, park sec. lighting, court & field lighting & misc. 7,200 10,000 10,000 10,000 3220 Natural gas 4,800 4,800 418-0-0- 4,800 Heating cost for Random, Hillview, Groveland, & Lambert Park bidgs. 4,800 4,800 4,800 4,800 3610 Memberships 40 50 40 50 - 40 50 - 40 50 - Minnesota Safety Council Playground inspector license Pesticide license renewal (every 2 years) 90 90 90 90 3630 Training & conferences 75 100 60 110 750 375 200 75 100 60 110 750 375 200 75 100 60 110 750 375 200 75 100 60 110 1,600 375 200 Computer classes Hearing tests/RTN training (2@$50) Maintenance EXPO Loss control workshops Playground inspection training (Certified Playground Safety Inspector CPSI) Equipment training (18.2% of $2,050) Pesticide application class (every 2 years) 1,670 1,670 1,670 2,520 3900 Grants & subsidies 11,500 11,500 11,500 11,500 Lakeside Park share of operating costs 11,500 11,500 11,500 11,500 4010 Rental, equipment 2,900 3 900 2,000 2,000 Tools and equipment (sod cutter, chipper, concrete mixer, etc...) 2,900 3,900 2,000 2,000 4030 Portable restrooms 4,850 5,000 5,000 5,000 For May thr11 Oct, plus special events such as tournaments, & extra cleanings and insurance 4,850 5,000 5,000 5,000 4800 Bonding & insurance 12,000 4,000 12,000 4,000 11,000 4,000 11,000 4,000 Insurance policy premiums Allowance for insurance policy deductibles 16,000 16,000 15,000 15,000 5110 Repairs, bldgs & grounds 750 - 1,000 7,750 1,000 2,500 2,500 750 4,000 1,000 1,500 1,000 2,500 2,500 750 - 1,000 1,500 1,000 2,500 2,500 750 - 1,000 1,500 1,000 2,500 2,500 Windows, doors, & lock repairs Sandblast trash cans and paint Building exterior repairs Irrigation system repairs (Silver View Park irrigation vault $6,250) Field light repairs Repairs to playground equipment Repairs to furnaces, plumbing, phones, electrical, etc 15,500 13,250 9,250 9,250 7030 Capital, equipment > $5000 - 6,000 - - Trencher (irrigation repairs and oak wilt treatments) - 6,000 - - 130,464 14U,"/44 122,/14 1/---),4/4 9.74% 7.88% -12.81% 2.25% 31 2019 Budget Summary Materials & supplies 1200 Supplies, landscaping 1,944 1,949 520 4,400 9,400 5,000 113.64% Total materials & supplies 1,944 1,949 520 4,400 9,400 5,000 113.64% Contractual services 2015 2016 2017 2018 2019 Change from 2018 1,577 Actual Actual Actual Budget Request Dollar Percent Forestry (100 - 4380): 25,000 25,000 - 0.00% 3630 Training & conferences 170 428 125 900 Personnel services Total contractual services 28,474 23,133 7,697 33,900 35,700 1,800 5.31% 0100 Salaries, regular 2,820 3,006 2,948 2,721 2,861 140 5.15% 0110 Overtime, regular 118 185 92 - - - 0.00% 0300 Social Security 203 219 219 208 219 11 5.29% 0321 PERA 221 238 193 204 215 11 5.39% 0400 Group insurance 530 584 74 600 612 12 2.00% 0500 Workers compensation 168 160 144 140 196 56 40.00% Total personnel services 4,060 4,392 3,670 3,873 4,103 230 5.94% 0.00% Materials & supplies 1200 Supplies, landscaping 1,944 1,949 520 4,400 9,400 5,000 113.64% Total materials & supplies 1,944 1,949 520 4,400 9,400 5,000 113.64% Contractual services 3030 Professional services 1,577 6,740 4,772 8,000 9,000 1,000 12.50% 3520 Tree removal 26,727 15,965 2,800 25,000 25,000 - 0.00% 3630 Training & conferences 170 428 125 900 1,700 800 Total contractual services 28,474 23,133 7,697 33,900 35,700 1,800 5.31% Total Forestry 34,478 29,474 11,887 42,173 49,203 7,030 16.67% 30,418 25,082 8,217 38,300 45,100 479,950 460,917 401,041 498,541 530,997 32,456 6.51% 32 Fund: 100 Department: 4380 Forestry Account Description 2016 2017 2018 2019 Description 1200 Supplies, landscaping 400 400 400 400 Landscaping materials 1,000 2,000 1,500 1,500 Small trees to replace damaged trees 2,000 3,000 2,500 2,500 Large trees - storm damage replacement 5,000 - - 5,000 Ash tree replacement trees (EAB) 500 500 - - EAB treatment supplies 8,900 5,900 4,400 9,400 2400 Uniforms & Clothing - - - - Uniform7lothing allowance 3030 Professional services 5,000 5,000 5,000 5,000 Tree trimming 500 500 500 500 Asset mgt. software 15,000 5,000 2,500 1,500 Forestry consulting 1,000 1,000 - 2,000 Tree injections (Ash every 2 years) 21,500 11,500 8,000 9,000 3520 Tree removal 25,000 7,500 25,000 - 25,000 - 25,000 - Remove or treat diseased trees Ash tree removal (MN DNR grant) 32,500 25,000 25,000 25,000 3630 Training & memberships 800 800 800 800 Tree Inspector training - - - 600 Arborist Test 100 100 100 300 Tree Inspector license 900 900 900 1,700 63,800 43,300 38,300 45,100 -23.41% -32.13% -11.55% 17.75% 33 2019 Budget Summary 34 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budget Request Dollar Percent Public Works Administration (100-4410): Personnel services: 0100 Salaries, regular 86,232 101,413 93,650 109,738 117,203 7,465 6.80% 0110 Salaries, overtime - - 877 - - - 0.00% 0300 Social Security 5,856 7,223 6,643 8,395 8,966 571 6.80% 0321 PERA 5,843 7,562 6,820 8,230 8,790 560 6.80% 0400 Group insurance 11,422 14,579 12,531 17,483 16,065 (1,418) -8.11% 0500 Workers compensation 1,885 1,215 1,099 1,213 1,891 678 55.89% Total personnel services 111,238 131,992 121,620 145,059 152,915 7,856 5.42% Materials & supplies: 1600 Operating supplies 300 45 536 230 230 - 0.00% 2400 Uniforms & clothing 56 180 257 200 200 - 0.00% Total materials and supplies 356 225 793 430 430 - 0.00% Contractual services: 3030 Other professional services 336 1,073 5,934 900 900 - 0.00% 3100 Telephone 616 709 581 773 773 - 0.00% 3610 Memberships 430 507 435 755 755 - 0.00% 3630 Training & conferences 600 1,164 412 895 895 - 0.00% 3800 Mileage reimbursement 203 - - 150 150 - 0.00% Total contractual services 2,185 3,453 7,362 3,473 3,473 - 0.00% Total public works administration 113,779 135,670 129,775 148,962 156,818 7,856 5.27% 2,541 3,678 8,155 3,903 3,903 34 Fund: 100 Department: 4410 Public Works Adminstration Account Description 2016 2017 2018 2019 Description 1600 Operating Supplies 230 230 230 230 Office supplies 70 70 - - National Public Works Week posters 300 300 230 230 2400 Uniforms & clothing 400 400 200 200 33% of Supervisor's uniform cost. 400 400 200 200 3030 Other professional services 100 100 100 100 Physicals & drug testing - new employee 500 500 500 500 Asset mgt software 300 300 300 300 Drug & alcohol testing - federal mandate 900 900 900 900 3100 Telephone 773 773 773 773 Cellphone (8.4% of $9,200) 773 773 773 773 3610 Memberships/license fee 375 400 400 400 American Public Works Association memb. (APWA) (1/2 of $800) 60 60 60 60 City Engineer's Association of MN (CEAM) 30 30 30 30 MN Safety Council 265 - 265 265 MN Board of AELSLAGID (PE Renewal even years) 730 490 755 755 3630 Training & conferences 1,500 500 500 500 CEAM / APWA conferences 50 50 50 50 Computer classes/Web training 15 15 15 15 $50) Hearing tests/RTN training (.34 FTE@$50) 30 30 30 30 Maintenance Expo 200 200 200 200 Required continuing education seminars 100 100 100 100 Supervisor training 1,895 895 895 895 3800 Mileage reimbursement 300 300 150 150 vehicle mileage reimbursement 300 300 150 150 5,298 4,U58 j,9U_i 3,9U.S 33.96% -23.41% -3.82% 0.00% 35 2019 Budget Summary Materials & supplies: 1210 2015 2016 2017 2018 2019 Change from 2018 Supplies, operating 2400 Actual Actual Actual Budget Request Dollar Percent Building & Grounds Maintenance (100 - 4460): Insurance 5110 Repairs, Bldgs & grounds 5130 Repairs, equipment 1,000 23.26% Personnel services: 132 74 117 117 - 0.00% 750 1,295 0100 Salaries, regular 13,885 14,106 9,112 11,481 12,171 690 6.01% 0110 Salaries, overtime 382 447 360 757 815 58 7.66% 0300 Social Security 1,052 1,065 591 936 993 57 6.09% 0321 PERA 1,053 1,071 558 918 974 56 6.10% 0400 Group insurance 2,413 2,468 670 2,850 3,123 273 9.58% 0500 Workers compensation 1,153 828 739 628 1,095 467 74.36% 106,525 Total personnel services 19,938 19,985 12,030 17,570 19,171 1,601 9.11% Materials & supplies: 1210 Supplies, building & grounds 1220 Supplies, vehicles 1230 Supplies, equipment 1600 Supplies, operating 2400 Uniforms & clothing 2410 Mats & towels 3630 Total materials & supplies Contractual services: 3030 Other professional services 3100 Telephone 3200 Water & sewer 3210 Electricity 3220 Natural gas 3530 Refuse collection 3630 Training & conferences 4010 Rental, equipment 4800 Insurance 5110 Repairs, Bldgs & grounds 5130 Repairs, equipment 1,000 23.26% Total contractual services Capital outlays 7030 Equipment Total capital outlays Total buildings & grounds 3,762 2,065 4,651 2,000 3,400 1,400 70.00% 68 - - - - - 0.00% 209 90 192 1,000 1,000 - 0.00% 3,570 3,077 3,034 4,300 5,300 1,000 23.26% 91 132 74 117 117 - 0.00% 750 1,295 664 1,000 1,000 - 0.00% 8,450 6,659 8,615 8,417 10,817 2,400 28.51% 31,200 27,483 29,256 35,960 36,905 945 2.63% 97 117 105 129 129 - 0.00% 786 949 353 1,000 1,000 - 0.00% 27,793 26,149 21,579 20,000 22,000 2,000 10.00% 17,502 12,446 16,352 17,000 17,000 - 0.00% 7,611 7,954 8,154 8,500 8,500 - 0.00% 10 19 - - - - 0.00% - - - 200 200 - 0.00% 4,694 4,598 4,465 7,000 7,000 - 0.00% 24,920 3,129 15,281 10,100 10,200 100 0.99% 2,179 6,729 2,365 5,000 5,000 - 0.00% 116,792 89,573 97,910 104,889 107,934 3,045 2.90% 125,242 96,232 106,525 113,306 118,751 246,729 - - - - - 0.00% 246,729 - - - - - 0.00% 391,909 116,217 118,555 130,876 137,922 7,046 5.38% 36 Fund: 100 Department: 4460 Building & Ground Maintenance Account Description 2016 2017 2018 2019 Description 1210 Supplies, bldgs & grounds 2,000 2 000 2,000 3 400 Bldg repairs, cleaning/heating supplies, batteries 2,000 21000 2,000 3,400 1230 Supplies, equipment < $5000 1,300 1,300 1,000 1,000 Repair parts, filters, hoses, etc., office furniture 1,300 1,300 1,000 1,000 1600 Supplies, operating 1,500 1,500 1,500 1,700 Cleaning supplies 150 150 150 150 Lumber & fasteners 300 300 300 300 Repair items & hardware 100 100 100 300 First aid supplies 200 200 200 200 Light bulbs & ballasts 750 750 750 950 Paper supplies 400 400 400 600 Mechanical items, fans, motors, etc 200 200 200 400 Office supplies 700 700 700 700 Paint & supplies - parking lot & building 4,300 4,300 4,300 5,300 2400 Uniforms & clothing 81 81 81 81 Uniforms (1.8% of $4,500) 36 36 36 36 Clothing & boot allowance (.20 @$175) 117 117 117 117 2410 Mats & towels 90 90 90 90 Share of floor mats and shop towels (1.8% of $5,000) 540 540 910 910 Floor mats at CH ($45/month) 630 630 1,000 1,000 3030 Other professional services 180 180 180 180 Backflow prevention testing (3@$60) 60 60 60 60 Boiler & pressure vessel registration program 5,520 5,520 5,520 10,165 HVAC maintenance (City Hall & PW facilities) 19,500 19,500 19,500 19,900 City Hall cleaning contract (renews in ?) 3,500 3,500 3,500 3,000 Carpet cleaning, floor striping & waxing (2 times) 680 680 680 1,800 Alarm testing and monitoring 1,320 1,320 1,320 1,200 Pest control (12@$100) 200 200 - - MDH Monitoring well maint. permit - PW bldg. (wells sealed) - 4,500 4,500 - Service contract for generator 600 600 600 600 Fire extingiusher inspection/service (30@$20) 31,560 36,060 35,860 36,905 3100 Telephone 129 129 129 129 Cellphone (1.6% of $7,500)($9,200) 129 129 129 129 3200 Water & Sewer 1,400 1,000 1,000 1,000 Service at City Hall and Public Works buildings 1,400 1,000 1,000 1,000 3210 Electricity 14,000 14,000 20,000 22,000 Electricity at City Hall and Public Works buildings 14,000 14,000 20,000 22,000 3220 Natural gas 20,000 19,000 17,000 17,000 Natural gas at City Hall and Public Works buildings 20,000 19,000 17,000 17,000 3530 Refuse collection 1,630 1,030 196 196 Hazardous waste disposal, Lamps $100, batteries $30 264 264 264 264 Hazardous waste annual fee (State of MN PCA) 90 90 90 90 Hazardous waste generator license fee (Ramsey County) 150 150 150 150 Used oil filters ($100 in vehicle maint.) 7,200 7,800 7,800 7,800 Facility dumpsters, city hall, public works 9,334 9,334 8,500 8,500 4010 Rental, equipment 200 200 200 200 Misc. rentals 200 200 200 200 4800 Bonding & insurance 5,500 5,500 5,500 5,500 Insurance policy premiums 1,500 1,500 1,500 1,500 Allowance for insurance policy deductibles 7,000 7,000 7,000 7,000 5110 Repairs, bldgs & grounds 2,500 2,500 1,500 1,500 Door & gate opener repairs 2,500 2,500 2,500 2,500 Building repairs 750 750 750 750 Elevator maintenance & repairs 100 100 100 100 MN DOL operating permit - elevator 350 350 350 350 Fire sprinklers & alarm repairs 5,000 5,000 5,000 5,000 General building & ground maintenance 11,200 11,200 10,200 10,200 5130 Repairs, equipment 5,000 5,000 5,000 5,000 HVAC, plumbing & electrical repairs 5,000 5,000 5,000 5,000 1U25,1'/U 111,2/U 113,3Vo 1125,/31 -11.60% 2.87% 1.83% 4.81% 37 2019 Budget Summary Materials & supplies: 1220 2015 2016 2017 2018 2019 Change from 2018 Motor fuels & lubricants - unlead 1701 Actual Actual Actual Budeet Request Dollar Percent Vehicle & Equipment Maintenance (100 - 4465): 1,350 29.03% 2,074 3,359 4,802 3,260 Personnel services: - 0.00% 85 - - - - 0100 Salaries, regular 34,939 29,313 36,642 39,916 41,462 1,546 3.87% 0110 Salaries, overtime - - 1,166 605 629 24 3.97% 0300 Social Security 2,540 2,133 2,741 3,099 3,220 121 3.90% 0321 PERA 2,579 2,188 2,825 3,038 3,157 119 3.92% 0400 Group insurance 45635 4,767 7,392 7,650 8,019 369 4.82% 0500 Workers compensation 2,487 1,648 1,396 1,593 2,364 771 48.40% Total personnel services 47,180 40,049 52,162 55,901 58,851 2,950 5.28% Materials & supplies: 1220 Supplies, vehicles 1230 Supplies, equipment 1600 Supplies, operating 1700 Motor fuels & lubricants - unlead 1701 Motor fuels & lubricants - diesel 2400 Uniforms & clothing 2410 Mats & towels 5130 Total materials & supplies Contractual services: 3030 Other professional services 3100 Telephone 3530 Refuse collection 3610 Memberships 3630 Training 4010 Rental, equipment 5120 Repairs, vehicles 5130 Repairs, equipment 4,650 Total contractual services Capital outlays 7030 Equipment Total capital outlays Total vehicle & equipment maintenance 9,522 f 17,722 14,854 19,950 22,950 3,000 15.04% 5,027 4,378 10,479 5,500 7,500 2,000 36.36% 6,404 6,065 6,328 4,650 6,000 1,350 29.03% 2,074 3,359 4,802 3,260 3,260 - 0.00% 85 - - - - - 0.00% 878 654 241 375 375 - 0.00% 185 190 156 220 220 - 0.00% 24,175 32,368 36,860 33,955 40,305 6,350 18.70% 17 25 - - 0.00% 228 268 273 387 387 - 0.00% - - 269 100 100 - 0.00% - - 30 80 120 40 50.00% 54 203 391 625 650 25 4.00% - - - 100 100 - 0.00% 6,872 7,114 18,157 16,800 16,800 - 0.00% 5,805 6,939 676 5,500 5,500 - 0.00% 12,976 14,549 19,796 23,592 23,657 65 0.28% 0.00% 0.00% 84,331 86,966 108,818 113,448 122,813 9,365 8.25% 37,151 46,917 56,656 57,547 63,962 38 Fund: 100 Department: 4465 Vehicle & Equipment Maintenance Account Description 2016 2017 2018 2019 Description 1220 Supplies, vehicles 200 200 200 200 Brake fluid 700 700 700 700 Misc parts, fastners 500 500 500 500 Anti freeze 300 300 300 300 Air conditioning gas 500 500 500 500 Headlamps, spots, & bulbs 800 800 800 1,000 Tune up items 500 500 500 500 Wiper blades & fluid 1,950 1,950 1,950 2,250 Minor repairs, rebuilds 1,500 1,500 1,500 2,000 Automotive parts 2,000 2,000 2,000 2,500 Filters: oil, air, fuel, transmission 2,000 2,000 2,000 2,500 Brake pads & shoes 9,000 9,000 9,000 10,000 Tires & batteries 19,950 19,950 19,950 22,950 1230 Supplies, equipment < $5000 200 200 1,000 3,000 Small equipment tune up items, hand tools 400 400 1,000 1,000 Filters belts & hoses 1,000 1,000 1,000 1,000 Hydraulic system repairs 2,500 2,500 2,500 2,500 Vehicle Asset Management software 3,700 - - - Tire mounting machine (defer to 2016)(bought code scanner in 2015) 2,000 - - - Tires 9,800 4,100 5,500 7,500 1600 Supplies, operating 1,200 1,200 1,000 1,000 Battery charger, Load tester 350 350 350 550 Welding supplies 100 100 500 750 Chains, clevises, & hitch pins 700 700 700 900 Equipment & vehicle cleaning supplies 500 500 500 700 Steel for repairs & fabrication 350 350 350 550 License tabs 500 500 750 950 Solvents & degreasers 500 500 500 600 Fastners & electrical supplies 4,200 4,200 4,650 6,000 1700 Motor fuels & lubricants 60 60 60 60 Gear lube 200 200 200 200 ATF - 7 cases 500 500 500 500 Aftermarket additives 2,500 2,500 2,500 2,500 Engine oil: 150 gallons (synthetic) 3,260 3,260 3,260 3,260 2400 Uniforms & clothing 249 270 270 270 Uniforms 6% of $4,500) 105 105 105 105 Clothing and boot allowance (.6@$175) 354 375 375 375 2410 Mats & towels 220 220 220 220 Share of floor mats and shop towels (5.5% of $4,000) 220 220 220 220 3100 Communications 387 387 387 387 Cellular telephone (4.1% of $9,200) 387 387 387 387 3530 Refuse collection 100 100 100 100 Oil filter recycling ($150 in 4460-3530) 100 100 100 100 3610 Memberships 60 60 60 100 Vehicle inspection license renewal (DOT required) 20 20 20 20 Minnesota Safety Council (6% of $465) 80 80 80 120 3630 Training 30 30 30 30 Hearing test/RTN training (.6@$50) 30 30 30 30 Maintenance Expo 200 495 200 200 Misc training 175 175 175 200 ASE certification 190 190 190 190 Vehicle inspection recertification (DOT required) 625 920 625 650 4010 Rental, equipment 100 100 100 100 Specialty tool & equipment rental 100 100 100 100 5120 Repairs, vehicles 8,000 8,000 8,000 8,000 Accident repairs 750 750 750 750 Alignments 1,000 1,000 1,000 1,000 Glass replacement 400 400 400 400 Radiator repairs, replacement 2,000 1,960 1,960 1,960 Tire repairs 950 950 950 950 Ignition scanner software update 1,700 1,740 1,740 1,740 Mitchell On Demand Software 2,000 2,000 2,000 2,000 Transmission repairs 16,800 16,800 16,800 16,800 5130 Repairs, equipment 500 500 500 500 Accident repairs 3,000 3,000 3,000 3,000 Mechanical repairs 2,000 2000 2,000 2,000 Motor repairs 5,500 5,500 5,500 5,500 7030 Capital, equipment> $5000 1 -+ - - Hoist adaptor (31,3 /6 )J)'992 --)/,--)4/ 03,90L 0.64% -8.77% 2.78% 11.15% 39 2019 Budget Summary Materials & supplies: 1230 Supplies, equipment 2015 2016 2017 2018 2019 Change from 2018 66.67% 1240 Actual Actual Actual Budget Request Dollar Percent Street Pavement Management (100 - 4470): 1260 Supplies, traffic control - 1,375 687 1,600 Personnel services: (700) -43.75% 1600 Supplies, operating 2,250 1,479 2,873 0100 Salaries, regular 114,727 116,046 114,198 118,912 121,462 2,550 2.14% 0110 Salaries, overtime 3,154 2,982 4,949 3,487 3,593 106 3.04% 0150 Salaries, part-time 5,452 3,872 6,757 7,488 8,112 624 8.33% 0300 Social Security 8,938 8,935 8,935 9,936 10,188 252 2.54% 0321 PERA 8,541 8,465 8,227 9,180 9,379 199 2.17% 0322 Pension expense GASB 68 - 1,709 - - - - 0.00% 0400 Group insurance 13,953 14,585 10,031 19,832 19,953 121 0.61% 0500 Workers compensation 10,532 8,359 7,451 8,335 10,420 2,085 25.01% 255 Total personnel services 165,297 164,953 160,548 177,170 183,107 5,937 3.35% Materials & supplies: 1230 Supplies, equipment 469 30 2,145 1,500 2,500 1,000 66.67% 1240 Supplies, streets 5,411 2,193 6,291 7,500 6,500 (1,000) -13.33% 1260 Supplies, traffic control - 1,375 687 1,600 900 (700) -43.75% 1600 Supplies, operating 2,250 1,479 2,873 1,000 2,000 1,000 100.00% 1700 Motor fuels & lubricants 6,391 4,356 5,756 8,250 7,410 (840) -10.18% 2400 Uniforms & clothing 820 1,394 399 701 701 - 0.00% 2410 Mats & towels 397 399 311 436 436 - 0.00% Total materials & supplies 15,738 11,226 18,462 20,987 20,447 (540) -2.57% Contractual services: 3030 Other professional services 11,975 2,486 4,406 18,450 16,450 (2,000) -10.84% 3100 Telephone 641 718 709 966 966 - 0.00% 3610 Memberships 190 195 250 255 255 - 0.00% 3630 Training & conferences 760 838 110 1,115 1,005 (110) -9.87% 4010 Rental, equipment 4,500 850 3,700 6,100 5,000 (1,100) -18.03% 4800 Insurance 4,157 4,073 3,955 6,200 6,200 - 0.00% 5130 Repairs, equipment 10 7 561 500 500 - 0.00% Total contractual supplies 22,233 9,167 13,691 33,586 30,376 (3,210) -9.56% Total street pavement management 203,268 185,346 192,701 231,743 233,930 2,187 0.94% 37,971 20,393 32,153 54,573 50,823 40 Fund: 100 Department: 4470 Pavement Managements Account Description 2016 2017 2018 2019 Description 1230 Supplies, equipment < $5000 500 500 500 750 Safety vests and other safety equipment - 1,000 1,000 1,000 Radio/hearing protection - 500 - - Push mower - 450 - - Chainsaw - 500 - 750 Backpack blower 500 2,950 1,500 2,500 1240 Supplies, street repair 20,000 7,500 5,000 4,000 Asphalt & concrete for street patching & curb repair 1,000 1,000 1,000 1,000 Disposal 1,500 1,500 1,500 1,500 Bituminous tack coat/crack fill material 22,500 10,000 7,500 6,500 1260 Supplies, traffic control 400 250 725 400 Traffic cones/baracades 600 500 875 500 portable signs (traffic control) 1,000 750 1,600 900 1600 Supplies, operating 650 850 850 1,350 Asphalt hand tools, rakes, etc. 100 150 150 650 Batteries, shop supplies, etc. 750 1,000 1,000 2,000 1700 Motor fuels & lubricants 5,250 4,200 4,500 4,030 Diesel fuel: 1300 gallons @ $3.10 4,125 3,450 3,750 3,380 Unleaded fuel: 1300 gallons @ $2.60 9,375 7,650 8,250 7,410 2400 Uniforms & clothing 491 210 491 210 491 210 491 210 Uniforms (10.9% of $4,500) Clothing and boot allowance (1.2@$175) 701 701 701 701 2410 Mats & towels 436 436 436 436 Share of floor mats and shop towels (10.9% of $4,000) 436 436 436 436 3030 Other professional services 1,800 1,800 1,800 1,800 Pavement Mgmt software annual maintenance. 2,500 2,500 2,500 5,000 Engineering services. 500 500 500 500 Asset management software annual maintenance 650 650 650 650 ROW weed control 1,500 1,500 - - Material dump charges 2,000 2,000 1,000 2,500 Sidewalk joint corrections - 12,000 12,000 6,000 CSAH 10 Planter Maintenance 8,950 20,950 18,450 16,450 3100 Communications 966 966 966 966 Cellular telephones (10.5% of $9,200) 966 966 966 966 3610 Memberships 190 200 200 200 American Public Works Association memb. (APWA) (1/4 of $800) 15 15 15 15 Pesticide license renewal (TF) 40 40 40 40 MN Safety Council 245 255 255 255 3630 Training & conferences 50 50 50 50 Computer classes 200 200 200 150 Electronics updates, other classes 60 60 60 60 Hearing test/RTN training (1.16 a$50) 60 60 60 60 Maintenance Expo 150 150 150 150 APWA/MN conferences. 250 250 250 250 Pavement, sealcoating, patching & sealcoating seminars. 210 210 210 150 Equipment operator training 60 60 60 60 Vehicle inspection license renewal 75 75 75 75 Vehicle inspection recertification _ - - - Work zone traffic control (every 3 years) 1,115 1,115 1,115 1,005 4010 Rentals, equipment 2,800 2,500 3,600 2,500 3,600 2,500 2,500 2,500 Annual trade-in of skidsteer loaders (no trade-in during 2017) Specialized equip rental (chipper, crack sealing,) 5,300 6,100 6,100 5,000 4800 Bonding & insurance 4,800 1,400 4,800 1,400 4,800 1,400 4,800 1,400 Insurance policy premiums Allowance for insurnace policy deductibles 6,200 6,200 6,200 6,200 5130 Repairs, equipment 500 500 500 500 Misc. equipment repairs 500 500 500 500 -)25,).925 Dv,:) /.j J4,:) /3 7u,aGJ -6.01% 1.77% -8.39% -6.87% 41 2019 Budget Summary Contractual services: 3030 Other professional services 3100 Telephone and data cards 3610 Memberships 3630 Training & conferences 5130 Repairs, equipment Total contractual supplies Capital outlays 7030 Equipment Total capital outlays Total streets snow & ice control 1,321 1,400 2015 2016 2017 2018 2019 Change from 2018 1,096 1,179 Actual Actual Actual Budeet Request Dollar Percent Street Snow & Ice Control (100 - 4472): 118 185 45 285 285 - 0.00% 22 Personnel services: 1,890 2,500 5,500 3,000 120.00% 3,174 3,313 4,521 0100 Salaries, regular 60,902 62,061 65,851 62,355 64,240 1,885 3.02% 0110 Salaries, overtime 7,711 9,926 7,386 8,609 8,858 249 2.89% 0300 Social Security 5,016 5,164 5,319 5,429 5,592 163 3.00% 0321 PERA 4,852 5,431 5,262 5,323 5,482 159 2.99% 0400 Group insurance 75972 8,513 8,496 12,000 12,366 366 3.05% 0500 Workers compensation 8,074 6,538 5,833 6,381 8,026 1,645 25.78% Total personnel services 94,527 97,633 98,147 100,097 104,564 4,467 4.46% Materials & supplies: 1230 Supplies, equipment 8,185 1,942 636 7,400 2,900 (4,500) -60.81% 1600 Supplies, operating 24,726 25,005 2,467 31,175 31,175 - 0.00% 1700 Motor fuels & lubricants 3,586 3,215 1,304 3,180 3,280 100 3.14% 2400 Uniforms & clothing 397 487 343 528 528 - 0.00% 2410 Mats & towels 341 356 262 328 328 - 0.00% Total materials & supplies 37,235 31,005 5,012 42,611 38,211 (4,400) -10.33% Contractual services: 3030 Other professional services 3100 Telephone and data cards 3610 Memberships 3630 Training & conferences 5130 Repairs, equipment Total contractual supplies Capital outlays 7030 Equipment Total capital outlays Total streets snow & ice control 1,321 1,400 1,410 1,375 1,450 75 5.45% 1,713 907 1,096 1,179 1,179 - 0.00% - - 80 70 70 - 0.00% 118 185 45 285 285 - 0.00% 22 821 1,890 2,500 5,500 3,000 120.00% 3,174 3,313 4,521 5,409 8,484 3,075 56.85% 0.00% 0.00% 134,936 131,951 107,680 148,117 151,259 3,142 2.12% 40,409 34,318 9,533 48,020 46,695 42 Fund: 100 Department: 4472 Snow & Ice Control Account Description 2016 2017 2018 2019 Description 1230 Supplies, equipment < $5000 250 - - - 1,800 500 3,000 4,000 - 2,000 500 4,500 - 400 2,000 500 - - 400 2,000 Filters Skidsteer broom Snow blower for skid steer Chloride Tank Cutting edges, plow shoes 2,050 9,500 7,400 2,900 1600 Supplies, operating 800 2,250 28,125 800 2,250 28,125 800 2,250 28,125 800 2,250 28,125 Welding supplies, steel stock, sod for boulevards, etc. Liquid Mg Chloride: 1,500 gallons @ $1.50 per gallon. Salt: 375 tons @ $75 per ton. 31,175 31,175 31,175 31,175 1700 Motor fuels & lubricants 180 3,500 180 2 800 180 3,000 180 3 100 Engine oil: 30 gallons @ $6.00 per gallon. Diesel fuel: 1,000 gallons @ $3.10 per gallon. 3,680 2,980 3,180 3,280 2400 Uniforms & clothing 370 158 370 158 370 158 370 158 Uniforms (8.2% of $4,500) Clothes & boots allowance (.9@$175) 528 528 528 528 2410 Mats & towels 328 328 328 328 Cost share of mats & towels (8.2% of $4,000) 328 328 328 328 3030 Other professional services 1,200 1,325 1,375 1,450 Weather service reports 1,200 1,325 1,375 1,450 3100 Telephone 579 1,680 579 600 579 600 579 600 Cellphone (6.3% of $7,500)($9,200) GPS data cards 2,259 1,179 1,179 1,179 3610 Memberships 70 70 70 70 Minnesota Safety Council 70 70 70 70 3630 Training 75 400 85 200 85 200 85 200 Hearing tests/RTN training (1.1 (cb,$Y-X) Defensive Driving class (2 staff) 475 285 285 285 5130 Repairs, equipment 2,500 2,500 2,500 5,500 Plow, blower, salt spreader repairs, paint plow assemblies 2,500 2,500 2,500 5,500 7030 Capital, equipment > $5000 - - - - - Plow control update (#445) GPS equipment for plow trucks 44,26 4`J,2s /U 46,UGU 40,OYD -21.99% 12.66% -3.71% -2.76% 43 2019 Budget Summary 44 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Bud1jet Request Dollar Percent Street Sign Maintenance (100 - 4475): Personnel services: 0100 Salaries, regular 18,442 18,377 18,573 18,333 18,565 232 1.27% 0110 Salaries, overtime 657 547 569 872 898 26 2.98% 0150 Salaries, part-time - - - 2,496 2,704 208 8.33% 0300 Social Security 1,399 1,365 1,353 1,661 1,696 35 2.11% 0321 PERA 1,399 1,369 1,325 1,441 1,460 19 1.32% 0400 Group insurance 2,526 2,467 1,789 3,600 3,672 72 2.00% 0500 Workers compensation 1,966 1,561 1,390 1,500 1,860 360 24.00% Total personnel services 26,389 25,686 24,999 29,903 30,855 952 3.18% Materials & supplies: 1600 Supplies, operating 10,570 4,502 16,253 28,500 22,750 (5,750) -20.18% 2400 Uniforms & clothing 143 147 103 435 435 - 0.00% 2410 Mats & towels 122 125 81 160 160 - 0.00% Total materials & supplies 10,835 4,774 16,437 29,095 23,345 (5,750) -19.76% Contractual services: 3030 Other professional services 11 3,762 - 4,500 8,500 4,000 88.89% 3100 Telephone 157 183 304 230 230 - 0.00% 3250 Electricity - traffic signals 2,906 2,647 2,366 3,000 3,000 - 0.00% 3630 Training & conferences 17 30 - 20 20 - 0.00% 5130 Repairs, equipment - - 570 500 500 - 0.00% Total contractual supplies 3,091 6,622 3,240 8,250 12,250 4,000 48.48% Total street sign maintenance 40,315 37,082 44,676 67,248 66,450 (798) -1.19% 44 Fundi 100 Department: 4475 Street Sign Maintenance Account Description 2016 2017 2018 2019 Description 1600 Supplies, operating 17,500 7,500 1,750 500 500 750 17,500 7,500 1,750 500 500 750 17,500 7,500 1,750 500 500 750 15,000 5,000 1,750 500 500 - Signs, posts, sign hardware, and supplies Street name sign panels, posts, hardware Pavement marking paint (moved from 4470) Shop supplies - fastners, degreasers, etc Graffitti remover (3) Traffic counters 28,500 28,500 28,500 22,750 2400 Uniforms & clothing 81 354 81 354 81 354 81 354 Uniforms (1.8% of $4,500) Clothes and boot allowance (.2@$175) 435 435 435 435 2410 Mats & towels 160 160 160 160 Cost share of mats & towels (4% of $4,000) 160 160 160 160 3030 Other professional services 5,000 500 - 500 4,000 500 8,000 500 Contract pavement marking (Ramsey Co)(moved from 4470) Asset management software annual maintenance 5,500 500 4,500 82500 3100 Telephone 230 230 230 230 Cellphone (2.5% of $8,000)($9,200) 230 230 230 230 3250 Electricity - traffic signals 2,000 3,000 3 000 3 000 Electricity for traffic signals 2,000 3,000 3,000 3,000 3630 Training & conferences 80 20 80 20 - 20 - 20 Equipment operator training Hearing test/RTN trainging (.4@$50) 100 100 20 20 5130 Repairs, equipment 500 500 500 500 Traffic signal repairs & maintenance 500 500 500 500 3 /,4GJ »,4GJ .3 I'D,+-) »,-»-1 1.63% -10.69% 11.73% -4.69% Grand Total all PW Departments 315,072 314,188 314,694 319,729 -8.18% -0.28% 0.16% 1.60% 45 Convention & Visitor's Bureau (100-4653) Contractual services 3045 N Metro Convention Bureau Total contractual services Total Convention & Visitor's Bureau Miscellaneous (100 - 4700): 2019 Budget Summary 2015 2016 2017 Actual Actual Actual 2018 2019 Change from 2018 Budtet Request Dollar Percent 65,654 64,038 65,233 61,750 61,750 - 0.00% 65,654 64,038 65,233 61,750 61,750 - 0.00% 65,654 64,038 65,233 61,750 61,750 - 0.00% Personnel services 0300 Social security 210 171 232 - - - 0.00% 0321 PERA 388 439 399 - - - 0.00% 0400 Group insurance 488 540 467 - - - 0.00% 0750 Fitness program 3,889 3,911 4,140 6,500 6,500 - 0.00% Total personnel services 4,975 5,061 5,238 6,500 6,500 - 0.00% Contractual services 3065 Family & youth social services 20,178 20,259 20,461 20,748 21,329 581 2.80% Total contractual services 20,178 20,259 20,461 20,748 21,329 581 2.80% Miscellaneous 9900 Transfers - EDA 16,000 50,000 50,000 50,000 50,000 - 0.00% 9900 Transfers - Vehicle & Equip. Funi 110,000 150,000 250,000 250,000 286,000 36,000 14.40% 9900 Transfers - Special Projects 200,000 375,000 275,000 75,000 75,000 - 0.00% 9900 Community Center 170,000 170,000 190,000 190,000 190,000 - 0.00% Total miscellaneous 496,000 745,000 765,000 565,000 601,000 36,000 6.37% 0.00% Total miscellaneous 521,153 770,320 790,699 592,248 628,829 36,581 6.18% Debt Service (100 - 4750): Debt Service ESP 8011 Lease payable 20,268 17,791 17,791 18,887 19,459 572 3.03% 8021 Interest - 6,704 6,704 5,609 5,036 (573) -10.22% Total debt service 20,268 24,495 24,495 24,496 24,495 (1) 0.00% 46 Fund: 100 Department: 4653 Convention & Visitor's Bureau Account Description 2016 2017 2018 2019 Description 3045 N Metro Convention Bureau 60,800 61,750 61,750 61,750 Payment of 95% of hotel/motel tax collections to (3% tax on gross receipts) support the promotion of tourism. (City retains 5% for administration) 60,800 61,750 61,750 61,750 Fund: 100 Department: 4700 Miscellaneous Account Description 2016 2017 2018 2019 Description 0750 Fitness program 6,500 6,500 6,500 6,500 Fitness program (maximum $55/month paid with employee sick leave time). 6,500 6,500 6,500 6,500 3065 Family & youth social services 20,783 20,461 20,748 21,329 Northeast Youth and Family Services (NYFS)(2.8% - 2019) 20,783 20,461 20,748 21,329 9900 Transfers - miscellaneous 50,000 75,000 50,000 75,000 50,000 75,000 50,000 75,000 Transfer to Economic Development Authority (EDA) Transfer to Special Projects fund 125,000 125,000 125,000 125,000 9900 Transfers - miscellaneous 150,000 175,000 250,000 286,000 Transfer to Vehicle & Equipment Fund 150,000 175,000 250,000 286,000 9990 Community Center 170 000 175,000 190,000 190,000 Subsidy for Community Center operating costs 170,000 175,000 190,000 190,000 Total Transfers 445,000 475,000 565,000 601,000 472,283 501,961 592,248 628,829 Fund: 100 Department: 4750 Debt Service Account Description 2016 2017 2018 2019 Description 8011 8021 Lease payable Interest 24,323 - 18,331 6,165 18,887 5,609 19,459 Lease payable Energy Savings Program 5,036 Interest 24,323 24,496 24,496 24,495 47 THIS PAGE LEFT BLANK INTENTIONALLY 48 CITY OF MOUNDS VIEW, MINNESOTA Special Revenue Funds 2019 Budgets Combining Statement of Revenues and Expenditures and Net Changes in Fund Balances 49 Cable Community Lakeside Recycling TIF Total TV Forfeiture EDA Center Park Grant District #5 2019 2018 Revenues: Taxes 128,000 - 100,000 - - - 1,711,275 1,939,275 1,900,873 Intergovernmental: County grants - - - - - 31,545 - 31,545 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 128,000 2,000 100,000 312,362 23,700 31,545 1,714,275 2,311,882 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,383 - 12,383 14,026 Supplies - - - - - 500 - 500 500 Contractual services - - - - - 18,662 - 18,662 16,929 Culture and recreation: Personal services 94,503 - - 51,340 4,215 - - 150,058 144,464 Supplies 3,750 - - 21,970 2,500 - - 28,220 26,677 Contractual services 45,492 - - 356,876 16,995 - - 419,363 389,380 Capital outlay 105,000 - - - - - - 105,000 207,545 Debt Service - - - 53,120 - - - 53,120 53,120 Economic development Personal services - - 125,424 - - - - 125,424 108,665 Supplies - - 600 - - - - 600 700 Contractual services - - 121,822 - - - 1,611,824 1,733,646 1,695,316 Capital outlay - - 50,000 - - - - 50,000 50,000 Total expenditures 248,745 3,200 297,846 483,306 23,710 31,545 1,611,824 2,700,176 2,714,422 Surplus of revenues over (under) expenditures (120,745) (1,200) (197,846) (170,944) (10) - 102,451 (388,294) (495,830) Other financing sources (uses) Transfers in - - 135,215 190,000 - - - 325,215 323,543 Transfers out - - - - - - (85,563) (85,563) (83,543) Total other financing sources (uses) - - 135,215 190,000 - - (85,563) 239,652 240,000 Net change in fund balance (120,745) (1,200) (62,631) 19,056 (10) - 16,888 (148,642) (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 20,061 (3,488) 235,526 176,602 9,469 28,360 863,717 1,330,247 1,217,457 49 2019 Budget Summary Operating expenses 2015 2016 2017 2018 2019 Change from 2018 $ 20,061 $ (120,745) -85.75% Actual Actual Actual Budl4et Request Dollar Percent Cable TV (Fund 210): 4,188 Personnel services 3630 Training & conferences 200 313 Revenues 950 1,000 0100 Salaries, regular 65,002 66,948 68,323 3180 Franchise fee 126,182 134,883 135,353 130,000 128,000 (2,000) -1.54% 3680 Other revenue 2,400 1,200 - - - - 0.00% Total revenue 128,582 136,083 135,353 130,000 128,000 (2,000) -1.54% Operating expenses 360,792 365,282 140,806 (224,476) -61.45% Fund balance, end of year $ 347,809 $ 360,792 $ 365,282 $ 140,806 $ 20,061 $ (120,745) -85.75% Operations (4350) Other professional services 3,900 5,714 5,829 8,012 12,200 4,188 Personnel services 3630 Training & conferences 200 313 680 950 1,000 0100 Salaries, regular 65,002 66,948 68,323 69,769 70,725 956 1.37% 0300 Social security 4,813 4,884 4,995 5,338 5,410 72 1.35% 0321 PERA 4,850 4,975 4,914 5,233 5,304 71 1.36% 0400 Group insurance 10,747 11,099 11,355 12,600 12,780 180 1.43% 0500 Workers compensation 508 399 357 212 284 72 33.96% Total personnel services 85,920 88,305 89,944 93,152 94,503 1,351 1.45% Materials & supplies 1230 Supplies, equipment 428 - 5,085 3,000 2,500 (500) -16.67% 1600 Supplies, operating - - 19 1,250 1,250 - 0.00% Total materials & supplies 428 - 5,104 4,250 3,750 (500) -11.76% Contractual services 360,792 365,282 140,806 (224,476) -61.45% Fund balance, end of year $ 347,809 $ 360,792 $ 365,282 $ 140,806 $ 20,061 $ (120,745) -85.75% 3030 Other professional services 3,900 5,714 5,829 8,012 12,200 4,188 52.27% 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,242 (275) -0.90% 5130 Repairs, equipment - - - 10,000 2,000 (8,000) -80.00% Total contractual services 32,668 34,795 35,815 49,529 45,492 (4,037) -8.15% Capital 7030 Equipment - - - 207,545 105,000 (102,545) -49.41% Total capital outlays - - - 207,545 105,000 (102,545) -49.41% Total expenditures 119,016 123,100 130,863 354,476 248,745 (105,731) -29.83% Net change in fund balance 9,566 12,983 4,490 (224,476) (120,745) 103,731 -46.21% 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 $ 20,061 $ (120,745) -85.75% 34,795 40,919 261,324 154,242 50 Fund: 210 Cable TV Department: 4350 Revenues Operations Account Description 2016 2017 2018 2019 Description 3180 Franchise fee revenue 122,000 126,000 130,000 122,000 126,000 130,000 128,000 Estimated collections 128,000 3680 Other revenue 1 21400 - - - Lease revenue from Library fiber connection Fund: 210 Department: 4350 Operations 1230 Supplies, equipment < $5000 3,000 3,000 3,000 2,500 Equipment costing less than $5,000 per item 3,000 3,000 3,000 2,500 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 6200 6,000 12,200 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,242 Share of costs of North Suburban Cable Commission 29,826 29,628 30,517 30,242 5130 Repairs, equipment 10,000 10,000 10,000 2,000 Repair and maintenance of equipment 10,000 10,000 10,000 2,000 7030 Capital, equipment > $5000 - - - - - 10,000 - - - - - 8,300 8,850 190,000 395 - - - 105,000 - Supplemental duct work/air conditioning Video Camera Video storage (NAS) Control room/Council chambers replacement Bulletin Board - 10,000 1 207,545 105,000 51,926 60,678 261,324 154,242 1.24% 16.85% 330.67% 40.98% 51 2019 Budget Summary 2015 2016 2017 2018 2019 Chance 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% Operating expenses (4200): 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 10,240 21,665 - 5,500 - (5,500) -100.00% Total capital outlays 10,240 21,665 - 5,500 - (5,500) -100.00% Total expenses 20,520 43,783 24,113 7,100 3,200 (3,900) -54.93% Net change in fund balance (6,772) (37,378) (7,086) (5,100) (1,200) 3,900 -76.47% Fund balance, beginning year 54,048 47,276 9,898 2,812 (2,288) (5,100) -181.36% Fund balance, end of year 47,276 9,898 2,812 (2,288) (3,488) (1,200) 52.45% 52 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 - 40,UVU 12S,/UU /,IUV 3,000 33.72% -59.35% -62.03% -54.93% 53 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 Change 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 7,155 7,459 7,674 81,726 95,853 14,127 17.29% 49,964 53,006 54,826 - - - 0.00% 4,302 4,511 4,671 6,252 7,333 1,081 17.29% 4,272 4,511 4,638 6,130 7,189 1,059 17.28% 9,705 9,812 10,166 14,106 14,310 204 1.45% 626 465 415 451 739 288 63.86% 76,024 79,764 82,390 108,665 125,424 16,759 15.42% Materials & supplies 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 297,846 16,692 5.94% Net change in fund balance (1,106) 33,064 137,090 (47,611) (62,631) (15,020) 31.55% 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 235,526 (62,631) -21.01% 54 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 Fund: 230 Department: 4650 Rousing and Economic Develo ment 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 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 11`),ZS14 1 /2,4255 1 /Z,4LL 35.04% 438.73% 43.96% -0.04% i�� THIS PAGE LEFT BLANK INTENTIONALLY 56 2019 Budget Summary 57 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 135,550 9,611 7.63% Net Banquet Center (31,392) (36,968) (33,926) (33,439) (41,050) (7,611) 22.76% 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,486 35,265 15.66% Net YMCA (158,212) (163,128) (102,251) (158,021) (183,286) (25,265) 15.99% 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,236 611 13.21% Net Office/Chamber space 1,315 2,930 3,976 3,737 3,126 (611) -16.35% 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,914 (5,341) -15.59% Net Creative Kids 44,618 49,586 53,817 55,097 103,086 47,989 87.10% 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 483,306 40,146 9.06% Net change in fund balance (10,506) (30,299) 58,993 4,554 19,056 14,502 318.45% 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 176,602 19,056 12.10% (continued) 57 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 Reclues 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,836 1,234 77.03% 999 Allocation of salaries (61,042) (61,113) (31,234) (47,160) (51,340) (4,180) 8.86% 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) 58 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 11150 1230 Supplies, equipment < $5000 800 - 800 - 800 - 800 31500 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 470 2410 Mats & towels 1,000 250 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,250 1,750 11750 3030 Other professional services 800 200 11,000 1,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 & interne t 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 9,000 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 12163 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% 59 2019 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budget Request Dollar Pei -cent 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 revenut 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,268 836 8.86% 63,944 Total personnel services 12,208 12,223 6,385 9,432 10,268 836 8.86% Materials & supplies 379 500 500 - 0.00% 3430 Printing - 1210 Supplies, buildings & grounds 1,586 - - - - - 0.00% 1230 Supplies, equipment 79 2,745 165 2,500 4,500 2,000 80.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 8,832 2,000 29.27% 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 125,282 Capital 7030 Equipment - - - - - - 0.00% Total capital outlays - - - - - - 0.00% Total banquet center exp 120,327 127,718 124,418 125,939 135,550 9,611 7.63% Total Banquet Center net (31,392) (36,968) (33,926) (33,439) (41,050) (7,611) 22.76% (continued) 60 Fund: 252 Community Center - 4730 Banquet Center Expenditures Account Description 2016 2017 2018 2019 Description 1230 Supplies, equipment 2,500 - 2,500 - 2,500 - 2,500 2,000 Tables, mirrors, microphones, projectors, etc. for Banquet Room Ice machine 2,500 2,500 2,500 4,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 125,283 -7.81% 4.96% 10.53% 7.53% 61 2019 Budget Summary YMCA Expenditures Personnel services - 0999 Allocation of salaries 42,119 42,168 21,551 32,540 35,425 2,885 8.86% Total personnel services 42,119 42,168 21,551 32,540 35,425 2,885 8.86% 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 Budjzet Request 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 35,425 2,885 8.86% Total personnel services 42,119 42,168 21,551 32,540 35,425 2,885 8.86% 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,486 35,265 15.66% Total YMCA net (158,212) (163,128) (102,251) (158,021) (183,286) (25,265) 15.99% (continued) 62 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 71735 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 Z 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 -31-50-0- 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 12,885 181,246 184,910 192,681 225,061 -7.61% 2.02% 4.20% 16.80% 63 THIS PAGE LEFT BLANK INTENTIONALLY 64 2019 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budget Re uest Dollar Percent Office space (4734); Office space revenues 3633 Lease - Office/Chamber space 7,450 8,500 8,795 8,362 8,362 - 0.00% Total office space revenues 7,450 8,500 8,795 8,362 8,362 - 0.00% Office space expenditures Personnel services 0999 Allocation of salaries Total personnel services Materials & supplies 2999 Allocation of supplies Total materials & supplies 1,831 1,833 937 1,415 1,540 125 8.85% 1,831 1,833 937 1,415 1,540 125 8.85% 360 340 385 464 464 0 0.02% 360 340 385 464 464 0 0.02% Contractual services 3999 Allocation of utilities 3,116 2,709 2,760 1,973 2,459 486 24.61% 5999 Allocation of repairs 828 688 737 773 773 0 0.01% Total contractual services 3,944 3,397 3,497 2,746 3,232 486 17.68% 1,400 1,400 - 0.00% 5999 Allocation of repairs 5,241 0 Total office space exp 6,135 5,570 4,819 4,625 5,236 611 13.21% Total office space net 1,315 2,930 3,976 3,737 3,126 (611) -16.35% (continued) 2019 Budget Summary 2015 2016 2017 2018 2019 Chanize from 2018 Actual Actual Actual Budget Request 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,107 334 8.86% Total personnel services 4,883 4,889 2,499 3,773 4,107 334 8.86% 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,914 (5,341) -15.59% Total child care net 44,618 49,586 53,817 55,097 103,086 47,989 87.10% 65 Lakeside Park (Fund 255): Revenues 11,500 3370 Spring Lake Pk contribution 3370 Mounds View contribution 3610 Investment income 3665 Park site permit - 0.00% Total revenue Operating expenses (4350): Personnel services 0150 Salaries, part-time 0300 Social security 0500 Workers compensation Total personnel services 2019 Budget Summary 2015 2016 2017 2018 2019 Chanize from 2018 Actual Actual Actual Budget Reclues Dollar Percent 11,500 11,500 11,500 11,500 11,500 - 0.00% 11,500 11,500 11,500 11,500 11,500 - 0.00% 132 142 226 300 200 (100) -33.33% 921 789 1,231 250 500 250 100.00% 24,053 23,931 24,457 23,550 23,700 150 0.64% 2,079 2,805 1,785 3,680 3,680 - 0.00% 159 214 137 282 282 - 0.00% 202 189 196 190 253 63 33.16% 2,440 3,208 2,118 4,152 4,215 63 1.52% 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 20,596 19,675 23,036 23,550 23,710 160 0.68% Net change in fund balance 3,457 4,256 1,421 - (10) (10) #DIV/0i Fund balance, beginning year 345 3,802 8,058 9,479 9,479 - 0.00% Fund balance, end of year 3,802 8,058 9,479 9,479 9,469 (10) -0.11% 66 Fund: 255 Lakeside Park ' 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,500 1,357 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 Estimated water & sewer charges 1,600 1,800 1,800 11,500 11,500 11,500 11,500 3610 Interest revenue 300 300 300 250 Estimated interest earnings at 1.25%. 3530 Refuse collection 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 2,400 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 31616 3,616 21920 lg,-/6"/ 19,M1 19'-19ZS 1y,4VD 0.00% -1.14% -0.73% 0.50% 67 2019 Budget Summary 68 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budget Request Dollar Percent Recycling (Fund 290): Revenues 3360 Other County grants 31,877 20,202 33,345 31,455 31,545 90 0.29% 3610 Investment income 51 3 3 - - - 0.00% Total revenue 31,928 20,205 33,348 31,455 31,545 90 0.29% Operating expenses Operations (4420) Personnel services 0100 Salaries, regular 10,036 8,997 8,206 10,583 9,121 (1,462) -13.81% 0110 Salaries, overtime 281 350 - - - - 0.00% 0300 Social security 772 636 611 810 698 (112) -13.83% 0321 PERA 734 600 616 794 684 (110) -13.85% 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,383 (1,643) -11.71% 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,962 1,733 14.17% Total contractual services 12,420 16,470 8,118 16,929 18,662 1,733 10.24% Total expenses 24,868 27,563 19,199 31,455 31,545 90 0.29% 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,162 68 Fund: 290 Recycling Grant Revenues' Account Description 2016 2017 2018 2019 Description 3360 Other grants & aid 30,220 32,284 31,455 31,545 Estimated Ramsey County recycling grant 30,220 32,284 31,455 31,545 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 500 1,000 2,000 2,000 Articles in City newsletter Clean-up Day and Organics printing of direct mailing items 1,000 1,500 2,500 21500 3530 Refuse collection 9,751 11,484 12,229 13,962 Recycling collections CH, CC, and Parks, Clean-up Days, shredding event 9,751 11,484 12,229 13,962 16,751 18,484 17,429 19,10Z -13.16% 10.35% -5.71% 9.94% 69 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 243 4.80% 8010 Developer PAG, principal 231,283 309,984 416,419 3101 Taxcollections 1,441,945 1,555,581 1,630,140 1,670,873 1,711,275 40,402 2.42% 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,714,275 40,402 2.41% Operating expenses (4650): Contractual services 3030 Other professional 2;924 5,095 3,216 5,060 5,303 243 4.80% 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,521 38,054 2.43% 9900 Transfers out to EDA 72,863 75,331 79,498 83,543 85,563 2,020 2.42% Total contractual services 1,432,937 1,504,251 1,595,931 1,657,070 1,697,387 40,317 2.43% Net change in fund balance 11,746 53,665 37,256 16,803 16,888 85 0.51% 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 863,717 16,888 1.99% 70 Fund: 450 TIF District #5 Revenues Account Description 2016 2017 2018 2019 Description 3101 Tax increment collections 1,555,982 1,631 162 1,670,873 1,711,275 Estimated collections of incremental taxes on properties in the district 1,555,982 1,631,162 1,670,873 1,711,275 3610 Investment income 4,000 3,000 3,000 3,000 Estimated interest earnings at 1.00%. 1 :1 4,000 3,000 3,000 3,000 Fund: 430 Department: 4650 Economic Development 3030 Other professional services 3,420 3,420 3,420 3,600 1,580 1,640 1,640 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,303 8010 Pay-as-you-go principal 1,431 290 1,513,894 1,568,467 1,60 521 Principal on a revenue note issued to promote a development. (Medtronic) 1,431,290 1,513,894 1,568,467 1,606,521 9900 Transfer out to EDA Fund 75,331 79,498 83,543 85,563 Transfer to cover the EDA operating budget. 75,331 79,498 83,543 85,563 71 THIS PAGE LEFT BLANK INTENTIONALLY 72 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): 8020 Debt, interest Revenues 166,895 (44,524) -21.06% 8030 Paying agent 475 475 3101 Property taxes 415,034 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 5415518 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 2111419 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% 73 THIS PAGE LEFT BLANK INTENTIONALLY 74 Revenue: Taxes Franchise fees Special assessments Intergovernmental: State County Miscellaneous: Investment income Other Total revenue Expenditures: General government Public safety Streets and highways Culture and recreation Total expenditures Excess (deficiency) of revenue over expenditures Other financing sources (uses) Operating transfers Bonds issued Transfers in Transfers out Total other financing sources (uses) Net change in fund balance CITY OF MOUNDS VIEW, MINNESOTA Capital Project Funds 2019 Budgets Combining Statement of Revenues and Expenditures Park Vehicle and Special Street Total Budget Dedication Equipment Projects Improvement 2019 2018 $ - $ - $ - $ 150,000 $ 150,000 $ - 295,000 295,000 290,000 15,000 15,000 20,000 275,000 275,000 275,000 1,000 - 2,000 8,000 11,000 19,000 3,000 - - - 3,000 3,000 4,000 - 2,000 743,000 749,000 607,000 $ 2,085,156 - 20,500 419,358 - 439,858 40,000 - 111,000 - - 111,000 84,600 - 63,000 143,340 1,118,000 1,324,340 2,542,000 83,500 105,500 - - 189,000 320,000 83,500 300,000 562,698 1,118,000 2,064,198 2,986,600 (79,500) (300,000) (560,698) (375,000) (1,315,198) (2,379,600) - 436,000 75,000 - 511,000 471,000 - (123,000) - - (123,000) (148,284) 4,142,040 - 313,000 75,000 - 388,000 322,716 Fund balance, December 31 (79,500) 13,000 (485,698) (375,000) (927,198) (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 $ 91,647 $ 678,752 $ 2,384,451 $ 2,085,156 75 2018 Budget Summary Operating expenses Operations (4350): Materials & supplies 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% Contractual services 3030 Other professional services - 23,307 - - - - 0.00% 5110 Repairs, Buildings & Grounds - 23,707 - - - - 0.00% Total contractual services - 47,014 - - - - 0.00% Capital 2015 2016 2017 2018 2019 Change from 2018 7050 Construction 67,380 Actual Actual Actual Budget Request Dollar Percent Park Dedication (Fund 451): 67,380 - 32,700 320,000 83,500 (236,500) Revenues Total expenses 67,380 50,987 69,130 320,000 83,500 (236,500) 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 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% Contractual services 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% 76 Fund: 451 Park Dedication Fund Revenues Account Description 2016 2017 2018 2019 Description 3610 Investment income 2,000 2,000 2,000 1,000 Estimated interest earnings at 1%. 2,000 2,000 2,000 1,000 3652 Park dedication fees 6,000 3,000 3,000 3,000 Developer payments 6,000 3,000 3,000 3,000 Fund: 451 Department: 4470 Expenditures 7050 Constriction > $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 Silverview 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 77 2018 Budget Summary Expenditures Central Services (4160): Capital 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 2015 2016 2017 2018 2019 Chance from 2018 Capital 21,000 Actual Actual Actual Budtet Request Dollar Percent Vehicle & Equipment (Fund 460): 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% 9900 Transfer out - Sewer Revenues 60,000 - - 100,000 100,000 0.00% 9900 Transfer out - Storm Water 210,000 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% 289,400 Total revenue 234,000 224,000 320,000 396,000 436,000 40,000 10.10% Expenditures Central Services (4160): Capital 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 21,000 22,000 21,600 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% 78 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 - - - 201500 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 Pavement Management 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 79 2018 Budget Summary 2015 2016 2017 2018 2019 ChanIze from 2018 Actual Actual Actual Budget Request Dollar Percent Special Projects (Fund 480): - - - - 29,300 29,300 Revenues 5130 Repairs; Equipment - 3,679 - - - 3553 Spec assessmt penalty & intere - 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 - - - - 29,300 29,300 0.00% 5130 Repairs; Equipment - 3,679 - - - - 0.00% Total contractual services - 3,679 - - 29,300 29,300 0.00% Capital (4160) 9900 Transfer out - - - 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) 1,258,284 562,698 (695,586) -55.28% 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 - 44,462 116,677 66,000 - (66,000) -100.00% 7050 Construction 79,600 407,896 19,498 726,000 - (726,000) -100.00% Total capital outlays 79,600 452,358 136,175 792,000 - (792,000) -100.00% Capital (4470) 7030 Capital equipment - - - - 143,340 143,340 0.00% 7050 Construction - - 5,415,082 300,000 - (300,000) -100.00% Total capital outlays - - 5,415,082 300,000 143,340 (156,660) -52.22% Other 8050 Issuance costs - debt service - - 86,805 - - - 0.00% 9900 Transfer out - - - 126,284 - (126,284) -100.00% Total other - - 86,805 126,284 - (126,284) -100.00% Total expenses 86,196 659,074 5,709,588 1,258,284 562,698 (695,586) -55.28% Net change in fund balance 126,287 (272,647) 714,270 (1,181,284) (485,698) 695,586 -58.88% 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 91,647 (485,698) -84.13% 80 Fund: 480 Special Projects Revenues`i Account Description 2016 2017 2018 2019 Description 3610 Investment income 6,000 4,000 2,000 2,000 Estimated interest earnings at I%. 6,000 4,000 2,000 2,000 3972 Transfers in 75,000 75,000 75,000 75,000 Transfer from General Fund 75,000 75,000 75,000 75,000 3993 JBond proceeds - 7,500,000 - - G.O. Bonds for PW facility - 7,500,000 - - Fund: 480 Department: 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 - - - 14,300 CC Dividers (carryover $6,300) - - 10,000 - Roof management survey - - - 15,000 Trench Drian PW Shop - - - - Interior painting Police Department - 31,000 40,000 29,300 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 (RTU4,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 - 81 2018 Budget Summary 2015 2016 2017 2018 2019 Chance from 2018 Actual Actual Actual Budget Request 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 1,286,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% 82 Fund: 485 Street Improvement 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 8,000 3972 Transfer in 240,000 - - - Transfers from utility funds (water 25,000, sewer 140,000, storm 75,000) 240,000 - - - 1,214,30U 964,.JUU 6UV,VVU 74.5,000 Fund: 485 Department: 4470 Expenditures 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 CSAR 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 1 175,000 - 1 188 000 Seal coat projects (2004 Project Area, Area E) 5,650,000 1 2,662,000 1,450,000 1 1,118,000 83 THIS PAGE LEFT BLANK INTENTIONALLY 84 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 1,155,660 1,663,618 104,402 286,500 3,210,180 3,081,018 65,000 - - - 65,000 60,000 2,000 - - - 2,000 2,000 1,222,660 1,663,618 104,402 286,500 3,277,180 3,143,018 383,374 373,503 8,060 135,905 900,842 874,243 77,949 31,502 1,000 20,475 130,926 149,976 231,623 103,819 3,900 191,684 531,026 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,446 1,934,917 87,960 488,064 45086,387 3,456,549 (352,786) (271,299) 16,442 (201,564) (809,207) (313,531) Investment income 1,000 21,000 1,400 1600 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 - 100,000 - - 100,000 - Transfers out (147,447) (132,446) (2,854) (39,309) (322,056) (296,801) Revenues over (under) expenditures (499,233) (282,745) 5,737 (224,873) (1,001,114) (580,784) Add back: Capital outlays 500,000 316,000 - 105,000 921,000 379,320 Principal on debt - - 7,349 - 7,349 7,133 Net income (loss) 767 33,255 13,086 (119,873) (72,765) (194,331) Net assets (deficit), January 1 3,951,668 3,839,553 91,536 3,034,448 10,917,204 11,157,537 Net assets (deficit), December 31 $3,952,435 $3,872,808 $ 104,622 $2,914,575 $10,844,439 $10,963,206 85 Water (Fund 700): Revenues 90 3375 State pension contribution 3551 Spec assessments -current 3552 Spec assessments -delinquent 3553 Spec assess. -penalty & interest 3610 Investment income 3680 Other revenues 3710 Water sales 3714 Water service insurance 3715 Utility connections 3716 Penalties 3913 Meter sales 3917 WAC/SWM charges 3972 Transfers - Vehicle & Equip (648) Total revenue Operating expenses Billing Services (4820): Personnel services 0100 Salaries, regular 0300 Social security 0321 PERA 0322 GASB 68 Pension Exp 0400 Group insurance 0500 Workers compensation Total personnel services Materials & supplies 1600 Supplies, operating Total materials & supplies Contractual services 3030 Other professional services 3300 Postage 3430 Printing 3630 Training 5130 Repairs, equipment Total contractual services Capital outlays 7030 Equipment Total capital outlays Miscellaneous: 9900 Transfers out to General Fund 9900 Transfers out to Vehicle Fund Total capital outlays Total Billing 2019 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budizet Re uest Dollar Percent - 1,300 90 - - - 0.00% 63,729 82,620 68,276 60,000 65,000 5,000 8.33% 3,212 7,972 10,194 2,500 2,500 - 0.00% 415 762 1,745 - - - 0.00% (1,995) (648) 1,595 500 1,000 500 100.00% 2,598 2,344 2,041 2,000 2,000 - 0.00% 783,857 866,184 896,826 1,009,676 1,060,160 50,484 5.00% 83,413 87,775 88,165 85,000 85,000 - 0.00% 4,050 2,150 3,952 2,000 2,000 - 0.00% 8,649 8,967 8,574 6,000 6,000 - 0.00% 3,208 1,564 5,896 - - - 0.00% 6,000 3,000 26,500 - - - 0.00% - - 35,000 - - - 0.00% 957,136 1,063,990 1,148,854 1,167,676 1,223,660 55,984 4.87% 42,117 43,284 43,698 42,806 41,961 (845) -1.97% 3,055 3,071 3,043 3,274 3,210 (64) -1.95% 3,039 3,105 2,940 3,211 3,147 (64) -1.99% 8,173 26,980 13,118 - - - 0.00% 3,286 3,325 3,114 5,652 5,882 230 4.07% 437 310 277 289 363 74 25.61% 60,107 80,075 66,190 55,232 54,563 (669) -1.21% - - - 50 50 - 0.00% - - - 50 50 - 0.00% 8,040 3,430 271 - 4,264 8,008 3,513 - - 5,223 8,519 3,238 218 - 4,232 8,583 4,352 900 1,500 4,712 8,746 4,600 900 2,400 6,267 163 248 - 900 1,555 1.90% 5.70% 0.00% 60.00% 33.00% 16,005 16,744 16,207 20,047 22,913 2,866 14.30% - - - 4,200 - (4,200) -100.00% - - - 4,200 - (4,200) 0.00% - - - - - - 78,103 66,000 80,447 67,000 2,344 1,000 3.00% 1.52% - - - 144,103 147,447 3,344 2.32% 76,112 96,819 82,397 223,632 224,973 1,341 0.60% 16,207 164,200 170,410 86 Fund: 700 De artment: ;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 400 8,036 400 8,183 400 8,346 400 24.5% of audit (2019 - $34,065, 2020 - $34,745, 2021 - $35,440) County special assessment maintenance fee 8,289 8,436 8,583 8,746 3300 Postage 3,136 800 441 3,072 800 480 3,072 800 480 3,300 800 500 3300 bills X $0.50 postage X 4 billings X 1/2 cost Inserting & mailing bills (moved from 3030) Late notices: 500 bills X $0.50 postage X 4 billings X 1/2 cost 4,377 4,352 4,352 41600 3430 Printing 450 450 450 450 450 450 450 450 Utility bills (1/2 cost) 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 - 475 388 4,060 - - 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 sewer)(2019 first year $610) Neptune software maintenance (1/2 in sewer)(every 3 years)(2019)($2500) Handheld interface support for meter readers (1/2 in sewer)(hlcode) 4,729 4,468 4,712 6,267 7030 Capital, equipment - - 4,200 - Meter reader (1/2 water 1/2 sewer) - - 4,200 - 9900 Transfers out 73,619 64,000 75,828 64,000 78,103 66,000 80,447 67,000 Transfer to General Fund for administrative overhead costs Transfer to Vehicle & Equipment Fund to fund future purchases 137,619 139,828 144,103 147,447 1 /,404 1�9,J.34 1()6,4uu 1/U,41U 87 2019 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budget 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,074 600 1.69% 0500 Workers compensation 9,304 6,886 6,128 6,667 8,371 1,704 25.56% Total personnel services 261,622 252,230 230,459 280,835 289,563 8,728 3.11% 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,280,973 400,798 45.54% 454,315 599,340 991,410 88 Fund: 700 Department: 4823 Water Infrastructure & Equipment 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 Mise. 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 a $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, fuel, & 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 & luubs 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 11100 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 89 THIS PAGE LEFT BLANK INTENTIONALLY r•� 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 (501/o) 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 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 92 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 0o0 1,800 Utility truck 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 3,500 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 - - 3/4 ton pick-up 133,708 127,640 50,000 50,000 7050 Construction > $25000 80,000 - - - Wells #6 building repairs (int. and exterior repairs) - 12,000 - - Well #5 repairs (design in 2017)($90,000 defer to 2018) - - - 400,000 Water treatment plant engineering and design 25,000 - - - Water system upgrades wells #1,2 - 1 45,000 50,000 50,000 Well pump rehabilitation project (well no. 6) 105,000 1 57,000 50,000 450,000 91 2019 Budget Summary M 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual BudSet 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,400 72 1.35% 0500 Workers compensation 1,688 1,224 1,093 1,189 1,344 155 13.04% Total personnel services 36,278 38,211 48,705 38,067 39,248 1,181 3.10% 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 216,947 14,981 7.42% 152,600 163,899 177,699 Total expenditures 1,011,893 1,000,746 968,476 1,305,773 1,722,893 417,120 31.94% Revenues over (under) expenditures (54,757) 63,244 180,378 (138,097) (499,233) (361,136) 261.51% 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) 767 34,664 -102.26% 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,952,435 $ 767 0.02% 927,439 1,339,519 M Fund: 700Department: 4823 Water Infrastructure & Equipment Maintenance; 7950 Depreciation 255,000 270,000 241,000 238,000 Estimated depreciation 2017 2018 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 out 25,000 - - - Water system upgrades in conjunction with major roadway program Sulfiu dioxide: 25 150# cylinders @ $1.10 per pound 25,000 1 - - I 10,400 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 Sulfiu 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 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 permits (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 1628,464 168,UZ54 16.J'6VV 1 / /,DVV 1,081,682 1,018,557 931,639 1,339,519 -3.43% -5.84% -8.53% 43.78% 93 2019 Budget Summary 2015 2016 2017 2018 2019 Change from 2018 Actual Actual Actual Budget Request 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): Other professional services 7,620 8,008 8,144 8,183 8,346 163 Personnel services 3300 Postage 3,430 3,513 3,238 4,352 4,600 0100 Salaries, regular 42,139 43,284 43,698 42,806 41,961 (845) -1.97% 0300 Social security 3,059 3,071 3,588 3,274 3,210 (64) -1.95% 0321 PERA 3,042 3,105 3,386 3,211 3,147 (64) -1.99% 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,882 230 4.07% 0500 Workers compensation 437 314 281 293 365 72 24.57% Total personnel services 59,837 78,316 66,326 55,236 54,565 (671) -1.21% Materials & supplies 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,600 248 5.70% 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% 16,985 Total contractual services 15,585 16,744 15,832 19,647 22,513 2,866 14.59% Capital outlays 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,574 20,581 10.89% 300 Social security 14,237 13,746 113,890 133,757 155,009 768 4.47% 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 40,736 468 1.16% 500 Workers compensation 10,183 7,349 8,001 6,866 8,759 1,893 27.57% Total personnel services 270,245 263,656 245,984 305,063 318,938 13,875 4.55% 94 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 490 3,072 800 480 3,072 800 480 3,300 800 500 3300 bills X $0.50 postage X 4 billings X 1/2 cost Inserting & mailing bills (moved from 3030) Late notices: 500 bills X $0.50 postage X 4 billings X 1/2 cost 4,426 4,352 4,352 4,600 3430 Printing 450 450 450 450 450 450 450 450 Envelopes Utility bills (1/2 cost) 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 - 475 388 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,639 133,7x/ 1JJ,Uuv AR 2019 Budget Summary 2015 2016 2017 2018 2019 Chanize from 2018 Actual Actual Actual Budget Re nest 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,857,789 177,809 10.58% Total expenditures 1,624,433 1,641,498 1,494,520 1,868,973 2,067,363 198,390 10.61% Revenues over (under) expenditures (197,966) (87,623) 130,063 (248,033) (282,745) (34,712) 13.99% Add back: capital outlays - - - 172,200 316,000 143,800 83.51% Change in net assets (197,966) (87,623) 130,063 (75,833) 33,255 109,088 -143.85% 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,872,808 $ 142,343 3.71% 1,182,210 1,508,674 1,693,860 96 Fund: 730 Department: 4823 Wastewater Infrastructure & Equi went 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, DVDs, 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 f iel 500 gallons @ $2.60 2,600 2,240 2,400 2,480 Diesel fuel 800 gallons @ $3.10 4,875 4,290 4,550 4,680 2400 Uniforms 1,169 1-11-6-9 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 728 728 728 728 Share of floor mats & shop towels (18.2% of $4,000) 728 728 728 728 IMats&towels 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 17000 Asset management software 27500 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 Electricity 2,300 2,100 2,100 2 100 Electricity for lift stations 2,300 2,100 2,100 2,100 4/,Z1Z 40,/48 O3,VV6 4/,1.5a 97 THIS PAGE LEFT BLANK INTENTIONALLY 98 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 250 Misc repairs 8,750 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 10,000 5150 Repairs, utilities 2,500 2,500 2,500 2,500 Lift station repairs 15,000 15,000 15,000 15,000 Sanitary collection system repairs 17,500 17,500 17,500 17,500 5160 System maintenance 25,000 5,000 5,000 5,000 Root control 4,500 4,500 4,500 4,500 Lift station maintenance/cleaning/pump service 4,000 4,000 4,000 4,000 Sewer debris disposal costs 33,500 13,500 13,500 13,500 7030 Capital, equipment > $5000 30,000 - - - Generator - Bronson (natural gas)(New to replace mobile generator) 2,750 - - - Electronic rain gauges for SCADA (33%)(total cost $8,250) 12,000 - - - Grinder station for Bronson lift station 44,750 - - - 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,263 1,3.)U,3 / / 1'.J /4,!) 1 / 17JJZS,25D 1 2019 Budget Summary Operating expenses Other professional services 2015 2016 2017 2018 2019 Chanize from 2018 Operations (4416) 73,907 Actual Actual Actual Budget Request Dollar Percent Street Lighting (Fund 740): 574 900 900 - 0.00% 5150 Repairs, utilities 698 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 Other professional services 796 35 - - - - 0.00% 3210 Operations (4416) 73,907 70,165 76,018 70,000 75,000 5,000 7.14% 4800 Insurance Personnel services 591 574 900 900 - 0.00% 5150 Repairs, utilities 698 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 675 9 1.35% 0500 Workers compensation 346 240 230 304 306 2 0.66% Total personnel services 11,014 9,554 7,551 8,133 8,060 (73) -0.90% 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% 11,941 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,065 5,009 5.27% Revenues over (under) expenditures (92,284) 13,409 8,287 10,646 5,737 (4,909) -46.11% 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 17,779 13,086 (4,693) -26.40% 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,622 $ 13,086 14.30% 89,866 86,923 92,005 100 Fund: 740 Street Lighting Fund Department: 4416 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 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% 101 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 Chan2efrom 2018 Actual Actual Actual Budget Request Dollar Percent - 422 29 - - - 0.00% 18,137 18,216 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 2,986 387 14.89% 102,658 106,483 104,435 111,892 115,522 3,630 3.24% 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 411,722 (11,025) 0.00% 108,212 310,855 296,200 0.00% 102 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. 270,000 270,000 270,000 285,000 Fund: 745 Department: 4415 System Maintenance 1230 Supplies, equipment < $5000 1,500 1,500 1,500 1,500 Miscellaneous equipment & parts (AEBI parts, pole camera parts) 1,250 1,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 - - 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 fuels 2,475 2 070 2,250 2,250 900 gallons unleaded @ $2.50 for utility truck 2,475 21070 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 n $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 a $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 (Stormwater) 55 55 55 55 Hearing test/R2K (1.1 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 1 4800 Insurance 2,500 2,500 2,500 2,500 Share of property/liability insurance 1,500 1,500 1,500 1500 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 507000 Arden Ave Storm sewer cleaning - 25,000 25,000 30,000 Storm Sewer slip linning 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 (331/o)(total cost $8,250) - - - 30,000 Silverview pond aerators 15,725 - 27,920 30,000 103 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 Budeet Re uest 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 713 81 12.82% 16,529 15,815 16,414 19,785 20,383 598 3.02% 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,651 (402) -0.35% 38,392 96,268 95,268 354,325 308,757 267,453 538,800 527,373 (11,427) -2.12% 139,904 (26,052) 41,108 (251,300) (224,873) 26,427 -10.52% Add back: Capital outlays - - - 102,920 105,000 2,080 2.02% Change in net asssets 139,904 (26,052) 41,108 (148,380) (119,873) 28,507 -19.21% 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,575 $ (119,873) -3.95% 146,604 407,123 391,468 104 Fund: 745 Department: 4415 System Maintenance 7050 Construction > $25000 50,000 - - - 25,000 75,000 75,000 75,000 2255 Lambert (pipe ditch)(possible matching grant from Rice Creek WSD) Storm water projects (Weir at Silverview Pond (carryover to 2019) 75,000 75,000 75,000 75,000 7950 Depreciation 32,000 32,000 32,000 35,000 Estimated depreciation 32,000 32,000 32,000 35,000 9900 Transfer out 75,000 - - - 7,604 7,832 8,067 8,309 Storm water system upgrades in conjunction with major roadway program General Fund 82,604 7,832 8,067 8,309 291.020 224.999 310.855 296.200 Fund: 745 Department: 4417 Street Cleaning 1230 Supplies, equipment < $5000 2,500 2,500 2,500 2,500 Misc. sweeper repairs - belts, pumps, hoses, filters, etc. 2,500 2,500 2,500 2,500 1600 Supplies, operating 2,300 700 100 400 2,300 700 100 400 2,300 700 100 400 21300 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 n $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 4,000 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,718 96,268 96,268 95,268 387,738 321,267 407,123 391,468 -35.69% -17.14% 26.72% -3.85% 105 THIS PAGE LEFT BLANK INTENTIONALLY 106