Loading...
HomeMy WebLinkAboutAgenda Packets - 2021/12/06CITY OF MOUNDS VIEW CITY COUNCIL WORK SESSION AGENDA MOUNDS VIEW CITY HALL Monday, December 6, 2021 6:30 p.m. ROLL CALL: Mueller, Hull, Meehlhause, Bergeron, Cermak Council Workshops are informal gatherings of the council at which no final decisions are made, rather consensus discussion to direct staff on council decision items. PUBLIC COMMENT Citizens may speak to issues not on tonight's agenda. Before speaking, please share your full name and address. Also, please limit your comments to three minutes. AGENDA ITEMS DISCUSSED BY CONSENSUS 1. 2022 Draft Municipal Budget - Mark 2. Storm Water RFP - Don 3. Affirmative Action Plan — Bob Alsop, HR Attorney, Kennedy and Graven 4. Water Meter Replacement Program - Don 5. CUP's - Nyle 6. Charitable Gaming Funds - Nyle 7. City Attorney Contract - Nyle 8. Charter Commission — Nyle verbal update 9. 2022 Staff -Council Retreat and Town Hall Meeting Dates - Nyle NEXT COUNCIL WORK SESSION: Monday, January 3, 2022 at 6:30 pm NEXT COUNCIL MEETING: Monday, December 13, 2021 at 6:30 pm THIS PAGE LEFT BLANK INTENTIONALLY Item No: 1 Meeting Date: December 6, 2021 NMU-NM1tSVVttW Type of Business: Work Session Administrator Review: City of Mounds View Staff Report To: Honorable Mayor and City Council From: Mark Beer, Finance Director Item Title/Subject: 2022 Draft Municipal Budget Attached is the 2022 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 13, 2021 City Council meeting. The City Council adopted a preliminary General Fund Base Levy of $4,960,174 an increase of $293,315, a Street Improvement Fund levy of $150,000, no change over 2021, adopted a preliminary debt service levy increase of $2,407 and the Police Officer referendum levies increased $55,000 to $385,000. There was no increase in the EDA levy. The total levy increase proposed was $350,722 or 5.98% consistent with the Charter Levy Cap. Staff is recommending that we reduce the General Fund levy by .65% or $38,131 as a result of better insurance rates. This would mean an overall increase of 5.33% or $312,591. Respectfully Submitted, Mark Beer, Finance Director City of Mounds View 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2020 General Fund: Actual Actual Actual Budget Reauest Dollar Percent Revenues: Property taxes - Base levy 4,082,924 4,245,901 4,516,708 4,666,859 4,922,043 255,184 5.47% Special tax levies, Bonds 90,835 165,800 171,190 166,291 165,916 (375) -0.23% Special tax levies, Operations 244,145 349,145 369,145 369,145 424,145 55,000 14.90% Franchise tax 338,919 308,835 301,755 305,000 305,000 - 0.00% Other taxes 23,046 26,477 29,309 26,000 26,000 0.00% Hotel/moteltax 77,115 71,957 29,264 50,000 50,000 0.00% Licenses and permits 312,047 348,201 269,447 245,872 252,872 7,000 2.85% Intergovernmental 1,229,019 1,303,053 2,419,722 956,075 1,267,202 311,127 32.54% Charges for services 23,736 38,007 60,384 24,625 49,625 25,000 101.52% Fines & forfeitures 35,800 46,098 25,596 33,750 33,750 - 0.00% Interest 157,074 316,381 196,579 60,000 80,000 20,000 33.33% Miscellaneous 304,719 323,497 310,601 298,162 274,221 (23,941) -8.03% Transfers: Water Fund 78,103 80,446 82,859 85,345 87,905 2,560 3.00% Sewer Fund 61,860 80,446 82,859 85,345 87,905 2,560 3.00% Storm Water Fund 8,067 8,309 8,558 8,815 9,079 264 2.99% Street Light Fund 2,771 2,854 2,940 3,028 3,119 91 3.01% Vehicle & Equipment Fund - - - 25,000 26,000 1,000 4.00% Debt proceeds 175,191 - - - - - 0.00% Total revenues 7,245,371 7,715,407 8,876,916 7,409,312 8,064,782 655,470 8.85% Expenditures: Legislative Services: City Council 58,903 58,013 50,168 62,239 61,953 (286) -0.46% Advisory Commissions 15,352 39,379 3,900 26,000 24,850 (1,150) -4.42% Subtotal 74,255 97,392 54,068 88,239 86,803 (1,436) -1.63% Administrative Services: City Administrator 286,882 305,115 307,051 310,722 339,624 28,902 9.30% Elections 33,460 26,954 27,023 36,265 37,750 1,485 4.09% Finance 268,325 274,866 282,535 294,777 306,457 11,680 3.96% Central Services 261,610 298,124 252,163 312,459 321,430 8,971 2.87% Subtotal 850,277 905,059 868,772 954,223 1,005,261 51,038 5.35% Community Development 435,152 441,676 417,362 477,040 504,002 26,962 5.65% Police 2,969,790 3,325,570 3,258,674 3,442,885 3,637,988 195,103 5.67% Fire 802,223 693,855 685,219 635,221 731,098 95,877 15.09% Public Works Administration 149,353 153,706 118,975 123,606 129,566 5,960 4.82% Parks, Recreation & Forestry: Recreation 123,961 125,940 96,795 - - - 0.00% Parks 286,911 342,429 399,410 467,094 493,517 26,423 5.66% Forestry 36,836 44,185 64,092 54,213 78,144 23,931 44.14% Subtotal 447,708 512,554 560,297 521,307 571,661 50,354 9.66% Fleet Services: Building & Grounds Mtnce 144,415 143,343 171,071 153,709 137,507 (16,202) -10.54% Vehicle & Equipment Mtnce 124,811 113,381 136,106 132,526 144,608 12,082 9.12% Subtotal 269,226 256,724 307,177 286,235 282,115 (4,120) -1.44% Streets: Pavement Management 205,269 234,368 218,179 226,268 238,426 12,158 5.37% Snow & Iee Control 168,529 177,992 161,346 154,884 163,180 8,296 5.36% Sign Maintenance 47,325 47,318 42,676 68,283 70,476 2,193 3.21% Subtotal 421,123 459,678 422,201 449,435 472,082 22,647 5.04% Other Convention & Visitor's Bureau 73,260 65,455 29,314 47,500 47,500 - 0.00% Social Service Coordination 20,748 35,329 57,054 51,656 53,206 1,550 3.00% Miscellaneous/contingency 3,766 3,662 3,574 6,500 6,500 - 0.00% Transfers to other funds 640,000 690,000 1,374,000 774,000 775,000 1,000 0.13% Debt service 24,495 24,495 166,468 - - - 0.00% Subtotal 762,269 818,941 1,630,410 879,656 882,206 2,550 0.29% Total expenditures 7,181,376 7,665,155 8,323,155 7,857,847 8,302,782 444,935 5.66% Net change in fund balance 63,995 50,252 553,761 (448,535) (238,000) 210,535 Beginning Fund Balance 9,476,539 9,445,463 9,476,539 10,030,300 9,581,765 Ending Fund Balance 9,540,534 9,4959715 10,0309300 9,5819765 9,3439765 2109535 L G �a A ICI O � N £' C £' a U � avooa o0000 0 vi O M O Vi N ON ON O 00 W1 ' O h 00 01 00 M m N r- � M l- O� M M 0o N M 69 69 l— m V1 ' v'1 O N O O N l— l— 01 7 O C1 00 01 'n N �O O N 'n O M O� 7 00 �O N M V 6s 69 M �O C1 00 N O, M O 7 00 M m N 7 O O, �O O 10 r- �O 00 O 1 00 O� 7 yr l� N r r 00 7 00 l� O V1 V 00 69 69 1 O O 0 O O 8 �n N 10 O O r� oNo O N O r n oo r oo 69 69 cq 0 O o0 00 lo l— l� l- 00 N Ito0 In oo omo omo V N n CO 00 oo N 69 69 l� o0 lO ' ' ' l— -,I- C) �n O m vri v�i N �n N N 'n O �O oo l� o V1 w) M 7 Ol N N o0 O GD GD m m o0 Ol o0 7 M M 01 69 69 N ' ' ' o0 V1 M o v1 V1 00 00 oo oo O l� V �O o0 cl O� o0 N n vl 69 69 M 7 'n m N ' ' ' N o N o NO O CO O 0 bs v3 v o0 7 7 V rn oo o0 7 oo N N N o0 N N M M M 69 69 Ol O oo h ' ' ' r O o O N 7 7 r oo �c oo N p O cD O .--i M N 69 69 W 00 r- O M O M M � M rq O o6 G7 M M MI6 It M M 69 69 r O lo ' m0 MO 01 �O o 22 M M M --i � � N V "O Oi m 7 m 7 lO 00 `O oo o " ^' v� Gos C R •y F N V >r ate+ y N i •D y N S = 15 R �, o ac4 y w c4 u pa A u C R N V 2 General Fund Revenue Detail - 2019 Budget Acct 2018 2019 2020 2021 2022 Change from 2020 # Description Actual Actual Actual Budget Request Dollar Percent 3101 3101 3101 3101 3111 3112 3180 3195 3211 3212 3214 3216 3221 3223 3231 3232 3233 3234 3235 3236 3238 3239 3240 3241 3242 3243 3250 3251 3252 3253 3254 3255 3256 3257 3258 3260 Taxes Current ad valorem property tax 4,082,924 4,245,901 4,516,708 4,666,859 4,922,043 255,184 5.47% Fire bonds 90,835 165,800 171,190 166,291 165,916 (375) -0.23% PERA rate increase property tax 39,145 39,145 39,145 39,145 39,145 - 0.00% Police referendum mkt rate tax 205,000 310,000 330,000 330,000 385,000 55,000 16.67% Manufact home tax - current 16,702 18,767 19,351 18,000 18,000 - 0.00% Manufact home tax - delinquent 6,344 7,710 9,958 8,000 8,000 - 0.00% Franchise tax on utilities 338,919 308,835 301,755 305,000 305,000 - 0.00% Hotel/Motel tax 77,115 71,957 29,264 50,000 50,000 - 0.00% Total taxes 4,856,984 5,168,115 5,417,371 5,583,295 5,893,104 309,809 5.55% Licenses and Permits Liquor on -sale Liquor off -sale Sunday liquor sales Malt off -sale Tobacco license Amusement devices Bowling alley Garbage hauling Gasoline station Used car sales Kennel Restraurant licenses Transient & solicitor Apartment Rental conversion Dog license Massage therapy Chickens and bees General contractor HVAC contractor Cement contractor Asphalt contractor Excavating contractor Sign & billboard contractor Sewer & water contractor Other contractor License check Fire permits Subtotal licenses 17,700 17,600 125 17,000 17,000 - 0.00% 1,050 520 260 1,000 1,000 - 0.00% - 600 - - 0.00% 150 200 510 100 100 - 0.00% 3,300 2,970 1,650 3,300 3,300 - 0.00% 416 640 - 400 400 - 0.00% 672 672 - 672 672 - 0.00% 4,040 3,770 3,670 3,800 3,800 - 0.00% 900 900 1,560 850 850 - 0.00% 204 204 225 200 200 - 0.00% 575 360 333 200 200 - 0.00% 2,742 2,815 345 3,200 3,200 - 0.00% 3,702 4,284 2,244 2,200 2,200 - 0.00% 51,819 54,477 81,953 52,000 55,000 3,000 5.77% 4,213 6,225 1,325 1,000 1,000 - 0.00% 3,087 965 2,987 1,400 1,400 - 0.00% 407 357 5 - - - 0.00% 190 306 390 100 100 - 0.00% 1,980 1,140 1,620 1,100 1,100 - 0.00% 6,480 2,280 3,180 4,400 4,400 - 0.00% - - 60 100 100 - 0.00% - - - 100 100 - 0.00% - - - 50 50 - 0.00% - - - 100 100 - 0.00% - - 480 - - - 0.00% 3,600 2,280 2,430 2,000 2,000 - 0.00% 1,265 1,592 1,380 1,800 1,800 - 0.00% 2,150 1,235 1,025 900 900 - 0.00% 110,642 106,392 107,757 97,972 100,972 3,000 3.06% 3 General Fund Revenue Detail - 2019 Budget Acct 2018 2019 2020 2021 2022 Change from 2020 # Description Actual Actual Actual Budget Request Dollar Percent 3268 Plan check fee 47,222 55,736 23,830 30,000 30,000 - 0.00% 3270 Building permits 109,544 143,735 94,351 90,000 90,000 - 0.00% 3271 Fixed fee - building permits 540 300 550 - - - 0.00% 3272 Wetland buffer permit 30 148 - - - - 0.00% 3273 HVAC permits 25,674 26,635 22,805 15,000 18,000 3,000 20.00% 3274 Plumbing permits 12,658 10,486 14,510 7,500 9,000 1,500 20.00% 3275 Non -building permits 5,030 4,380 4,175 5,000 4,500 (500) -10.00% 3278 Interim use permits - - - - - - 0.00% 3279 Conditional use permits 200 400 1,000 400 400 - 0.00% 3280 Building surcharge 258 (50) 95 - - - 0.00% 3281 Fixed fee building surcharge 40 (47) (27) - - - 0.00% 3282 Mechanical/commercial surchar 896 756 802 - - - 0.00% 3283 HVAC surcharge (796) (804) (762) - - - 0.00% 3284 Plumbing surcharge (518) (248) (525) - - - 0.00% 3285 Fire inspection surcharge 59 88 175 - - - 0.00% 3286 Water & sewer surcharge 23 39 143 - - - 0.00% 3287 Commercial plmb surcharge 545 255 568 - - - 0.00% Subtotal permits 201,405 241,809 161,690 147,900 151,900 4,000 2.70% Total licenses & permits 312,047 348,201 269,447 245,872 252,872 7,000 2.85% Intergovernmental: 3318 Federal police grant 1,440 - 14,191 - 50,000 50,000 0.00% 3319 Other federal - - 1,004,135 - - - 0.00% 3341 Local Government Aid 736,425 739,446 820,801 422,209 765,336 343,127 81.27% 3345 Performance Aid 1,866 1,866 1,892 1,866 1,866 - 0.00% 3346 PERA Aid 8,671 8,671 - - - - 0.00% 3351 Street Aid - MSA maintenance 135,526 135,960 147,096 120,000 135,000 15,000 12.50% 3355 Police Aid 160,952 172,505 196,897 148,000 175,000 27,000 18.24% 3356 Police training 19,140 19,883 18,818 12,000 18,000 6,000 50.00% 3357 State police grant 514 3,793 - - - - 0.00% 3359 Other state grants 22,205 33,686 22,285 77,000 25,000 (52,000) -67.53% 3370 Other local government revenue 15,577 20,563 36,137 10,000 15,000 5,000 50.00% 3371 IDS # 621 - SRO's 126,703 166,680 157,470 165,000 82,000 (83,000) -50.30% Total intergovernmental 1,229,019 1,303,053 2,419,722 956,075 1,267,202 311,127 32.54% Charges for services 3410 Advertising revenue - - - 500 500 - 0.00% 3414 Fire inspections 150 - 431 - - - 0.00% 3415 Housing inspections - 63 822 100 100 - 0.00% 3418 HRA inspections - 63 - 200 200 - 0.00% 3419 Investigations 100 - - 200 200 - 0.00% 3420 DHS fire inspections - 150 100 - - - 0.00% 3421 Police reports 1,940 1,578 1,088 1,200 1,200 - 0.00% 3422 Documents / copies 8 - - 150 150 - 0.00% 3423 Customer service 275 55 10 500 500 - 0.00% 3425 Book sales - various 35 48 30 - - - 0.00% 3426 Reimbursed staff time - - 2,145 100 100 - 0.00% 3430 Right-of-way 8,601 10,776 7,380 9,000 9,000 - 0.00% 3431 Street opening fee - 600 800 - - - 0.00% 3432 Tree removal charges 10,652 18,350 44,778 10,000 35,000 25,000 250.00% 3433 Overload permits 75 - - - - - 0.00% 3458 Zoning letter 450 300 200 75 75 - 0.00% 3461 Subdivision 350 700 - 1,000 1,000 - 0.00% 3462 Variance 300 900 1,200 1,000 1,000 - 0.00% 3463 Rezoning - 1,250 - 200 200 - 0.00% 3464 Development - non refund 800 2,774 1,000 200 200 - 0.00% 3465 Code appeal - 400 - - - - 0.00% 3467 PUD amendment - - 400 200 200 - 0.00% Total charges for services 23,736 38,007 60,384 24,625 49,625 25,000 101.52% THIS PAGE LEFT BLANK INTENTIONALLY General Fund Revenue Detail - 2019 Budget Acct 2018 2019 2020 2021 2022 Change from 2020 # Description Actual Actual Actual Budget Request Dollar Percent Fines and Forfeitures 3510 Ramsey County municipal court 32,060 42,640 23,916 32,000 32,000 - 0.00% 3520 Administrative offenses 3,040 2,633 1,230 1,000 1,000 - 0.00% 3525 False alarm charges 700 825 450 750 750 - 0.00% Total fines & forfeitures 35,800 46,098 25,596 33,750 33,750 - 0.00% Other Revenue 3550 Special assessments 2,123 5,788 5,141 3,000 3,000 - 0.00% 3610 Investment income (charge) 157,074 316,381 196,579 60,000 80,000 20,000 33.33% 3630 Billboard Lease 122,286 124,754 127,297 129,916 132,613 2,697 2.08% 3631 Water tower rental 90,808 94,440 98,218 102,146 76,908 (25,238) -24.71% 3634 Equipment and space rental - - 1,344 - - - 0.00% 3639 Security 4,266 380 784 - - - 0.00% 3650 Donations 12,253 50 1,400 - - - 0.00% 3651 Donations - K9 1,270 1,425 1,625 1,000 600 (400) -40.00% 3652 Donations - parks 230 - - - - - 0.00% 3654 COPS events 100 4,540 4,550 5,000 5,000 - 0.00% 3665 Park site permit 26,099 22,864 5,624 15,000 15,000 - 0.00% 3679 Vending machine commissions - - - 100 100 - 0.00% 3680 Other revenue 29,276 31,695 6,131 15,000 15,000 - 0.00% 3685 Insurance reimbursements 5,654 35,078 35,792 20,000 20,000 - 0.00% 3911 Sale of assets 9,548 1,182 22,462 5,000 5,000 - 0.00% 3912 Resale of materials 806 1,301 233 2,000 1,000 (1,000) -50.00% Total other revenue 461,793 639,878 507,180 358,162 354,221 (3,941) -1.10% Transfers & Debt proceeds 3972 Transfers: Vehicle & Equip replacemen - - - 25,000 26,000 1,000 4.00% Water 78,103 80,446 82,859 85,345 87,905 2,560 3.00% Sewer 61,860 80,446 82,859 85,345 87,905 2,560 3.00% Storm Water 8,067 8,309 8,558 8,815 9,079 264 2.99% Street light 2,771 2,854 2,940 3,028 3,119 91 3.01% 3993 Debt proceeds 175,191 - - - - - 0.00% Total Transfers & Debt 325,992 172,055 177,216 207,533 214,008 61475 3.12% Total 7,245,371 7,715,407 8,876,916 7,409,312 8,064,782 655,470 8.85% 2022 Budget Summary City Council (100 - 4100): Personnel services 0100 Salaries, regular 0300 Social Security 0321 PERA 0500 Workers compensation Total personnel services Materials & supplies 1600 Supplies, operating Total materials & supplies Contractual services 3030 Other professional services 3610 Memberships 3630 Training & conferences 4800 Bonding & insurance Total contractual services Total City Council Y-T-D 2018 2019 2020 2021 11/30/2020 2022 Change from 2020 Actual Actual Actual Budget Actual Request Dollar Percent 34,596 34,596 34,596 34,596 34,596 - 0.00% 1,338 1,338 1,338 2,647 2,647 - 0.00% 1,050 1,050 1,050 1,730 1,730 - 0.00% 114 178 160 200 194 (6) -3.00% 37.098 37.162 37.144 39.173 - 39.167 (6) -0.02% 3,629 1,857 1,654 3,300 3,300 - 0.00% 3,629 1,857 1,654 3,300 - 3,300 - 0.00% 5,847 6,336 5,222 6,400 6,400 - 0.00% 5,716 5,716 5,602 5,716 5,436 (280) -4.90% 6,165 6,466 - 7,000 7,000 - 0.00% 448 476 546 650 650 - 0.00% 18,176 18,994 11,370 19,766 - 19,486 (280) -1.42% 0.00% 58,903 58,013 50,168 62,239 - 61,953 (286) -0.46% 21,805 20,851 13,024 23,066 22,786 Advisory Commissions (100-4110): Materials & supplies 1600 Supplies, operating 14 23 64 200 100 (100)-50.00% 2100 Books & periodicals - - - 100 - 50 (50)-50.00% Total materials & supplies 14 23 64 300 - 150 (150)-50.00% Contractual services 3030 Other professional services 3,448 21,906 3,836 10,000 9,000 (1,000)-10.00% 3630 Training & conferences 107 - - 200 - 200 - 0.00% 3900 Festivities Commission 11,783 17,450 - 15,500 15,500 - 0.00% Total contractual services 15,338 39,356 3,836 25,700 - 24,700 (1,000) -3.89% 0.00% Total Advisory Commissions 15,352 39,379 3,900 26,000 - 24,850 (1,150) -4.42% 7 Fund: 100 Department: 4100 City Council Account Description 2019 2020 2021 2022 Description 1600 Supplies, operating 1,200 1,300 1,000 1,200 1,300 1,000 1,200 1,100 1,000 1,200 1,100 1,000 Employee awards luncheon (R9275) Strategic planning sessions Plaques and gift certificates for employee length -of -service awards 3,500 3,500 3,300 3,300 3030 Other professional services - 6,200 - 6,200 - 6,400 - 6,400 Strategic planning session(s) facilitator Contractual minutes for Council rings ( $225 x 24 reg, + 3 special) 6,200 6,200 6,400 6,400 3610 Memberships 30 5,686 30 5,686 30 5,686 30 5,406 Mn Mayor's Association North Metro Mayors 5,716 5,716 5,716 5,436 3630 Conferences 5,500 7,000 7,000 7,000 Council training, LMC conference, LMC meetings/training, RCLLG, Other 5,500 7,000 7,000 7,000 4800 Bonds & insurance 650 650 1 650 650 1 General property & liability 650 650 1 650 1 650 21,566 23,066 23,066 22,786 -0.92% 6.96% 6.96% -1.21% 10 yr avg 10 yr avg 10 yr avg 18,288 18,288 18,881 Fund: 100 Department: 4110 Account Description 2019 2020 2021 Advisory Commissions 2022 Description 1600 Supplies, operating 60 140 60 140 60 140 40 60 Misc supplies for various commissions. Copies for Charter Commission 200 200 200 100 2100 Books & periodicals 100 100 100 50 Misc periodicals - Comp plan review, Ordinance revisions. 100 100 100 50 3030 Other professional services 500 1,750 2,250 500 7,000 3,500 500 6,000 3,500 500 5,000 3,500 Misc. consultant services. Charter commission legal fees Planning Commission and charter meeting minutes 4,500 11,000 10,000 9,000 3630 Training 75 125 75 125 75 125 75 125 Misc training & conferences. Planning Commissioner training & conferences 200 200 200 200 3900 Festival in the Park 5,500 4,000 5,000 7,500 3,000 5,000 7,500 3,000 5,000 7,500 3,000 5,000 City Festival in the Park (personnel, supplies, restrooms, stage, tables) Music in the Park (statutory limit is $3,000) Fireworks 14,500 15,500 15,500 15,500 19,500 27,000 26,000 24,850 14.71% 38.46% 33.33% -7.96% 10 yr avg 10 yr avg 10 yr avg 13,620 13,620 15,130 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2020 Actual Actual Actual Budget Request Dollar Percent Office of the City Administrator (100 - 4130): Personnel services 0100 Salaries, regular 198,144 207,990 200,604 206,345 224,593 18,248 8.84% 0110 Salaries, over -time - - - 1,004 1,087 83 8.27% 0150 Salaries, part-time 30,293 34,587 49,643 32,458 34,268 1,810 5.58% 0300 Social Security 16,194 16,746 17,440 17,512 19,052 1,540 8.79% 0321 PERA 7,404 6,558 5,398 14,733 16,109 1,376 9.34% 0400 Group insurance 26,171 30,398 26,922 27,729 32,058 4,329 15.61% 0500 Workers compensation 1,082 1,445 1,305 1,771 1,887 116 6.55% Total personnel services 279,288 297,724 301,312 301,552 329,054 27,502 9.12% Materials & supplies 1230 Supplies, equipment 1,413 1,081 156 1,200 1,200 - 0.00% 1600 Supplies, operating - - 68 75 75 - 0.00% 2100 Books & periodicals 118 - - 35 35 - 0.00% Total materials & supplies 1,531 1,081 224 1,310 1,310 - 0.00% Contractual services 3030 Other professional services - 290 585 - - - 0.00% 3100 Communications 891 400 1,069 1,300 1,300 - 0.00% 3610 Memberships 1,468 956 359 1,610 1,610 - 0.00% 3630 Training & conferences 3,212 4,329 3,502 4,650 6,050 1,400 30.11% 3800 Mileage 492 335 - 300 300 - 0.00% Total contractual services 6,063 6,310 5,515 7,860 9,260 1,400 17.81% Total City Administrator 286,882 305,115 307,051 310,722 339,624 28,902 9.30% 7,594 7,391 5,739 9,170 10,570 Elections (100 - 4140): Contractual services 3030 Other professional services 33,460 26,954 27,023 36,265 37,750 1,485 4.09% Total contractual services 33,460 26,954 27,023 36,265 37,750 1,485 4.09% 7030 Capital outlays - - - - - - 0.00% Total Elections 33,460 26,954 27,023 36,265 37,750 1,485 4.09% Fund: 100 Department: 4130 Office of the City Administrator Account Description 2019 2020 2021 2022 Description 1230 Supplies, equipment < $5000 1,200 1,200 1,200 1,200 Equipment and phones under the $5,000 capitalization threshold 1,200 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 50 50 50 50 MAMA - (Administrator) Metro Area Manager's Association 1,100 - - - ICMA - International City Manager's Association 150 150 150 150 Mn City County Managers Association - - 210 210 Society for Human Resource Managers (SHRM) - - 110 110 International Institute of Municipal Clerks (IIMC) 1,000 1,000 1,000 1,000 New Brighton/Mounds View Rotary Club dues (administrator) 40 40 90 90 Municipal Clerks & Finance Officers Association (MCFOA)(2) 2,340 1,240 1,610 1,610 3630 Training & conferences 100 100 100 100 MAMA meetings 500 650 650 650 LMC / miscellaneous training 100 100 100 100 Chamber lunches - - - 1,400 Compass Peer Group/Craig Rapp - Administrator 1,000 1,000 1,000 1,000 LMC annual conference - 900 1,800 2,700 MN Clerks and Finance Officers Annual Conference (MCFOA)(3) 850 900 900 - Mn City County Managers Assoc conference 100 100 100 100 Mn Clerks and Finance Officers Association (MCFOA) institute training 2,650 3,750 4,650 6,050 3800 Milcagc 300 300 300 300 Miscellaneous mileage @ IRS rate. 300 300 300 300 7,900 7,900 9,170 10,570 13.26% 0.00% 16.08% 15.27% 10 yr avg 10 yr avg 10 yr avg 6,697 6,697 7,191 Fund: 100 Department: 4140 Elections Account Description 2019 2020 2021 2022 Description 3030 Other professional services 22,332 23,004 31,265 32,750 Ramsey County elections contract ($7,816.20 per quarter) - 9,000 - - Special election (2020 state primary election) 4,500 4,500 5,000 5,000 Voting equip. maint. Costs (2020, 2019 - $4,479) 26,832 36,504 36,265 37,750 26,832 36,504 36,265 37,750 9.52% 36.05% 35.16% 4.09% 10 yr avg 10 yr avg 10 yr avg 31,901 31,901 38,550 10 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2020 Actual Actual Actual Budget Request Dollar Percent Finance (100 - 4150): Personnel services 0100 Salaries, regular 195,824 195,513 202,758 209,018 215,276 6,258 2.99% 0300 Social Security 13,161 13,411 13,742 15,749 16,221 472 3.00% 0321 PERA 14,081 14,466 15,288 15,440 15,902 462 2.99% 0400 Group insurance 23,636 28,202 28,923 29,404 33,872 4,468 15.20% 0500 Workers compensation 1,098 1,317 1,355 1,718 1,738 20 1.16% Subtotal 247,800 252,909 262,066 271,329 283,009 11,680 4.30% Materials & supplies 1230 Supplies, equipment 98 750 - 900 900 - 0.00% 1600 Supplies, operating - 11 - 50 50 - 0.00% 2100 Books & periodicals 144 112 116 200 200 - 0.00% Subtotal 242 873 116 1,150 1,150 - 0.00% Contractual services 3030 Other professional 9,842 10,048 9,604 9,835 9,835 - 0.00% 3100 Communications 480 600 600 600 600 - 0.00% 3430 Printing 1,108 732 942 700 700 - 0.00% 3610 Memberships 1,015 1,035 1,010 1,180 1,180 - 0.00% 3630 Training 2,511 3,076 2,324 3,400 3,400 - 0.00% 5130 Repairs & maint., equipment 5,327 5,593 5,873 6,583 6,583 - 0.00% Subtotal 20,283 21,084 20,353 22,298 22,298 - 0.00% Total Financial Services 268,325 274,866 282,535 294,777 306,457 11,680 3.96% 20,525 21,957 20,469 23,448 23,448 Fund: 100 Department: 4150 Account Description 2019 2020 2021 manj 2022 Description 1230 Supplies, equitpment < $5000 900 1,000 900 900 equip. under the $5,000 capitalization threshold (cell phone $800) 900 1,000 900 900 1600 Supplies, operating 50 50 50 50 Misc supplies - planners, plaques, folders, files, etc. 50 50 50 50 2100 Books & periodicals 300 300 200 200 Misc computer & finance books & periodicals 300 300 200 200 3030 Other professional services 9,368 435 60 100 9,034 460 60 100 9,215 460 60 100 9,215 460 60 100 26% of audit (22-35,440, 23-36,145, 24-36,870, 25-37,605, 26-38,360) GFOA financial reporting fee Safety deposit box rental Ramsey County overlapping debt, principal taxpayer reports 9,963 9,654 9,835 9,835 3100 Communications 600 600 600 600 cell phone ($50 month) 600 600 600 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 370 120 270 310 400 120 300 340 400 140 300 340 400 140 300 340 Government Finance Officer's Association (GFOA) Mn GFOA (2) AICPA Am. Institute of Certified Public Accts MNCPA Mn Society of Certified Public Accountants 1,070 1,160 1,180 1,180 3630 Training & conferences 50 2,000 - 700 300 50 2,000 - 1,000 350 50 2,000 - 1,000 350 50 2,000 - 1,000 350 Mn GFOA monthly meetings Seminars & training GFOA National conference (Defer)($2800) Accounting and software training Mileage 3,050 3,400 1 3,400 1 3,400 5130 Equipment repairs 5,970 61269 6,583 6,583 40% software support chgs. (30% each in Water, Sewer)(5% increase) 5,970 6,269 6,583 6,583 22,603 23,133 23,448 23,448 5.94% 2.34% 3.74% 0.00% 10 yr avg 10 yr avg 10 yr avg 19,736.90 20,329.60 20,930.60 12 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2020 Actual Actual Actual Budget Request Dollar Percent Central Services (100 - 4160): Materials & supplies 1110 Stationery 4,349 1,122 849 750 1,250 500 66.67% 1120 Copy materials 831 880 726 1,500 1,500 - 0.00% 1230 Supplies, equipment 23,319 18,160 15,279 25,000 26,000 1,000 4.00% 1600 Supplies, operating 7,769 10,240 7,146 12,500 11,500 (1,000) -8.00% 2100 Books & periodicals 169 169 182 340 340 - 0.00% Total materials & supplies 36,437 30,571 24,182 40,090 40,590 500 1.25% Contractual services 3010 General legal 49,492 65,124 37,818 50,000 48,000 (2,000) -4.00% 3030 Other professional services 31,704 20,956 25,855 23,260 25,510 2,250 9.67% 3100 Telephone 1,902 2,021 1,774 2,200 660 (1,540) -70.00% 3300 Postage 4,218 5,166 7,194 6,500 6,500 - 0.00% 3410 Legal notices 1,938 2,738 2,916 2,600 2,600 - 0.00% 3420 Advertising 1,482 191 227 2,500 2,500 - 0.00% 3430 Printing 10,164 11,018 11,717 12,600 12,600 - 0.00% 3610 Memberships 19,776 19,344 19,564 18,353 19,327 974 5.31% 3630 Training & conferences 2,368 27,732 2,750 17,500 17,000 (500) -2.86% 3800 Mileage - - 84 - - - 0.00% 4010 Rental, equipment 2,453 1,820 1,820 2,050 2,050 - 0.00% 4800 Insurance & bonds 12,644 13,314 15,114 18,000 18,000 - 0.00% 5100 Repairs & maint, computers 87,032 98,029 100,060 116,306 125,593 9,287 7.98% 5110 Rep, bldg & grounds - - 1,088 - - 0.00% 5130 Repairs, equipment - 100 - 500 500 - 0.00% Total contractual services 225,173 267,553 227,981 272,369 280,840 8,471 3.11% Total central services 261,610 298,124 252,163 312,459 321,430 8,971 2.87% 13 und: 100 Department: 4160 Central Services Account Description 2019 2020 2021 2022 Description 1110 Stationery 750 750 750 1,250 Envelopes, labels, letterhead, etc. 750 750 750 1,250 1120 Copy materials 1,500 1,500 1,500 1,500 Copy paper 1,500 1,500 1,500 1,500 1230 Supplies, equipment < $5000 23,000 24,000 25,000 26,000 Comp & security equip under $5,000, pc's, software, switches, cameras.... 23,000 24,000 25,000 26,000 Replace pc's @ $800 4 yr replacement cycle 1600 Supplies, operating 14,000 12,000 12,000 11,000 Toner, rug service, paper, pens, staples, desk supplies, etc. 500 500 500 500 Misc operating supplies 14,500 12,500 12,500 11,500 2100 Books & periodicals 150 150 150 150 Employment handbooks/publications 190 190 190 190 Star Tribune - $190 340 340 340 340 3010 General legal 24,000 24,000 24,000 24,000 Retainer for legal services 20,000 26,000 26,000 24,000 Legal fees outside scope of retainer. 44,000 50,000 50,000 48,000 3030 Other professional services 6,000 6,000 6,000 6,000 General labor assistance - - 4,500 - Federal Single Audit ARPA Grant (if needed) - 3,000 1,500 1,500 Laserfiche assistance 3,100 3,100 3,000 3,000 Western Bank monthly fees 400 400 400 400 US Bank positive pay service 1,200 1,200 1,800 1,800 Section 125 (flex spending plan) & COBRA administration - - - 1,650 Open Enrollment/Benefits platform 4,000 - 4,500 Actuary services for GASB 45/78 (every 2 years) 1,800 400 1,000 Codification service 2,000 2,000 2,000 2,000 Human resources items 2,520 2,520 3,660 3,660 Web hosting (Revize) (5% annual increase)($2760 + $900 forms) 15,220 24,020 23,260 25,510 3100 Telephone 2,200 2,200 2,200 660 Basic telephone (analog for alarms) 2,200 2,200 2,200 660 3300 Postage 300 200 200 200 Courier charges (delivery services) 7,500 6,300 6,300 6,300 General postage includes PW mailings for street projects. 7,800 6,500 6,500 6,500 3410 Legal notices 900 900 900 900 Truth in taxation notices and Ramsey County fees. 2,100 1,700 1,700 1,700 Legal notices and legal publications. 3,000 2,600 2,600 2,600 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 12,000 12,000 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 12,600 12,600 12,600 12,600 3610 Memberships 625 625 625 625 Ramsey County League of Local Governments (RCLLG) 2,850 - - - I-35W Corridor Coalition - - - 475 Twin Cities North Chamber of Commerce 5,115 5,243 5,243 5,243 Metro Cities (0.35% increase for 2019) 12,180 12,485 12,485 12,984 League of Mn Cities dues 20,770 18,353 18,353 19,327 3630 Training & conferences 1,000 1,000 1,000 1,000 League training & seminars - 1,500 1,500 1,000 Laserfiche training and certification - 1,500 1,500 Gallup Team Grid Software (annual) - 3,525 Gallup Annual Summit (out-of-state)(annual) 5,300 1,775 Gallup Training 2,600 - Strength Finder assessment 14,000 10,000 1,600 5,200 Staff development training - 4,000 3,000 2,000 Administrator 360 review 800 800 800 800 OSHA and blood borne pathogen training 200 200 200 200 Information technology training 16,000 17,500 17,500 17,000 Misc 4010 Rental, equipment 150 150 150 150 1,900 1,900 1,900 1,900 Postage machine and scale rental (lease thru 9/22) 2,050 2,050 2,050 2,050 4800 Bonding & insurance 15,000 15,000 15,000 15,000 Insurance policy premiums 3,000 3,000 3,000 3,000 Allowance for insurance policy deductibles 18,000 18,000 18,000 18,000 5100 Repairs, computer 80,305 88,691 93,126 111,602 Computer, phone, network & technology assistance - Metro I -Net 2,755 4,611 5,999 7,871 Laserfiche annual maintenance and storage 1,280 1,410 1,410 1,120 Adobe annual license (15@$67) 1,603 1,771 1,771 - Denial of Service protection (moved to Metro I -Net line) 6,000 8,000 9,000 - Computer, printer, and networks repairs. (moved to Metro I -Net line) 4,000 5,000 5,000 5,000 Copier maintenance + overages 95,943 109,483 116,306 125,593 5130 Repairs, equipment 600 600 500 500 Postage meter, copy machine, fax, misc. 600 600 500 500 1 280,773 305,496 312,459 321,430 -0.60% 8.81% 2.28% 2.87% 14 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2020 Actual Actual Actual Budget Request Dollar Percent Community Development (100 - 4180): Personnel services 0100 Salaries, regular 287,739 313,634 305,246 329,375 347,802 18,427 5.59% O110 Overtime, regular 375 - - 768 791 23 2.99% 0300 Social Security 21,237 23,226 20,496 21,202 22,302 1,100 5.19% 0321 PERA 21,112 22,996 26,523 31,431 33,326 1,895 6.03% 0400 Group insurance 30,106 29,224 28,347 49,020 54,480 5,460 11.14% 0500 Workers comp 1,311 1,924 1,956 2,446 2,523 77 3.15% 0600 Unemployment 1,666 - 693 - - - 0.00% Total personnel services 363,546 391,004 383,261 434,242 461,224 26,982 6.21% Materials & supplies 1230 Supplies, equipment 1,269 355 249 500 1,000 500 100.00% 1600 Supplies, operating 578 246 89 700 200 (500) -71.43% 1700 Motor fuels & lubricants 1,421 1,093 717 1,380 1,375 (5) -0.36% 2100 Books & periodicals 112 - 754 800 700 (100) -12.50% 2400 Uniforms 215 89 19 450 450 - 0.00% Total materials & supplies 3,595 1,783 1,828 3,830 3,725 (105) -2.74% Contractual services 3030 Other professional 60,076 38,466 26,973 23,930 26,435 2,505 10.47% 3040 Consultants, development review 435 1,794 210 3,000 3,000 - 0.00% 3100 Telephone 1,956 2,393 2,332 2,568 2,568 - 0.00% 3430 Printing 1,183 - - 900 500 (400) -44.44% 3610 Memberships 857 1,169 1,681 1,500 1,500 - 0.00% 3630 Training and conferences 3,504 5,058 855 6,970 4,950 (2,020) -28.98% 3800 Mileage - 9 222 100 100 - 0.00% Total contractual services 68,011 48,889 32,273 38,968 39,053 85 0.22% Total Community Development 435,152 441,676 417,362 477,040 504,002 26,962 5.65% 71,606 50,672 34,101 42,798 42,778 15 Fund: 100 Department: 4180 Community Development Account Description 2019 2020 2021 2022 Description 1230 Supplies, equipment < $5000 500 500 500 1,000 Miscellaneous equipment & computer peripherals 500 500 500 1,000 1600 Supplies, operating 600 600 500 - Presentation supplies 600 600 - - ARC GIS License 200 200 200 200 Office supplies 1,400 1 1,400 700 200 1700 Motor fuels & lubs 1,560 1,650 1,380 1,375 Unleaded fuel: 500 gallons @ $2.75 (Gas for Conlin Devlopment) 1,560 1,650 1,380 1,375 2100 Books & periodicals 450 450 500 200 Reference materials 100 100 300 500 Intl. Code Council Manuals and Code Updates 175 175 - - Manuals, pamphlets, etc. 725 725 800 700 2400 Uniforms 300 450 450 450 Clothing for inspections staff 300 450 450 450 3030 Other professional 1,300 1,300 1,300 1,300 Ramsey County JPA (geographic information system) 5,080 5,080 5,235 5,235 Permit Works system annual software support (includes busi. lic. mod) 4,995 4,995 - - Permit Works code enf. module (one-time) 1,495 1,495 1,540 1,540 Permit Works code enforcement module software support 1,990 1,990 1,855 1,860 Permit works mobile inspector (2) 1,500 Permit works implementation and training 500 500 500 500 Filing fees (Ramsey County increased fees from $29 to $48) 500 500 500 - GIS assistance 1,000 Consulting Planning Services 1,000 1,000 1,000 1,000 Consulting Building Official services 8,000 8,000 10,000 Consulting Code Enforcement SBM employee (2 days wk x 10 months) 20,000 Comp plan assistance (carryover) 4,000 4,000 4,000 4,000 Abatements of nuisance properties 42,360 28,860 23,930 26,435 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,823 1,608 1,608 1,608 Verizon Cell Accounts (2) for inspectors, Reimb. Director $50/mo 841 960 960 960 network cards for blding. Insp. and code enforcement (2 cards @ $40) 2,664 2,568 2,568 2,568 3430 Printing 900 900 900 500 Forms, flyers, etc. 900 900 900 500 3610 Memberships 320 320 320 400 American Planning Association (APA) - National (1) 50 50 50 100 American Planning Association (APA-MN) - State (1) 155 155 155 200 American Institute of Certified Planners (AICP) 200 200 200 250 Assoc. of MN Building Officials (2) 40 40 80 80 Fire Marshal's Assoc. of MN 140 140 140 145 International Code Council (ICC) 100 100 100 100 1 OK Lakes Chapter of ICC - - 125 MN Assoc. Housing Code Officials (MAHCO) 105 105 105 100 MN Building Permit Technicians Association (MBPTA) 1,110 1,110 1,150 1,500 3630 Training & conferences 850 850 850 850 APA state conference (one attendee) 350 350 350 350 Sensible Land Use Coalition (monthly lunches (6 @ $58) 400 400 400 500 ICC code seminars - 100 ICC Ed of Code Administration 1,200 1,200 - - Tuition reimbursement 600 600 600 600 Leadership Growth 400 400 400 400 Other software training 550 1,550 Fire Inspector I & 11 training 3,000 - Building Inspection Technology Certificate - 600 Crime Prevention through Environmental Design 1,170 1,170 1,170 - Other staff training & seminars 4,970 4,970 7,320 4,950 3800 Mileage 100 100 100 100 Misc. use of personal automobiles 100 100 100 100 59,589 46,233 42,798 42,778 -23.63%-22.41% -7.43% -0.05% 10 yr avg 10 yr avg 10 yr avg 36,688 38,440 40,348 16 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2020 Actual Actual Actual Budget Request Dollar Percent Police (100 - 4200): Personnel services: 0100 Salaries, regular 1,771,402 1,955,445 1,926,211 1,997,152 2,097,474 100,322 5.02% 0110 Overtime 122,299 116,105 121,184 95,816 99,700 3,884 4.05% 0150 Salaries, part-time 1,007 - - - - - 0.00% 0300 Social Security 32,650 32,805 33,849 36,743 38,797 2,054 5.59% 0321 PERA 290,392 330,848 352,162 359,931 377,488 17,557 4.88% 0400 Group insurance 276,573 287,279 291,574 312,060 357,720 45,660 14.63% 0500 Workers compensation 60,414 89,376 96,319 159,476 156,273 (3,203) -2.01% 0600 Unemployment - - 656 - - - 0.00% Total personnel services 2,554,737 2,811,858 2,821,955 2,961,178 3,127,452 166,274 5.62% Materials & Supplies 1230 Supplies, equipment 14,785 7,083 4,872 6,100 6,100 - 0.00% 1600 Supplies, operating 11,556 10,976 11,577 10,700 12,200 1,500 14.02% 1700 Motor, fuels & lubricants 40,987 33,828 34,496 37,030 44,275 7,245 19.57% 2100 Books & periodicals 70 185 143 300 300 - 0.00% 2400 Uniforms & clothing 23,534 22,140 23,486 22,940 23,780 840 3.66% Total materials & supplies 90,932 74,212 74,574 77,070 86,655 9,585 12.44% Contractual services 3020 Legal, prosecuting attorney 73,500 73,500 73,500 75,000 75,000 - 0.00% 3030 Other professional services 7,150 4,263 5,461 4,850 9,850 5,000 103.09% 3050 Dispatching 106,714 94,793 96,808 102,053 99,274 (2,779) -2.72% 3055 Information systems fees 2,550 2,830 1,795 4,955 4,955 - 0.00% 3070 COPS events 5,243 9,332 5,260 6,000 15,000 9,000 150.00% 3080 Veternarian services 2,179 2,685 906 2,000 2,000 - 0.00% 3100 Telephone 10,653 12,373 15,885 18,590 18,590 - 0.00% 3210 Electricity 422 436 434 450 450 - 0.00% 3430 Printing - 108 - 400 400 - 0.00% 3610 Memberships 887 2,045 2,551 1,656 1,656 - 0.00% 3630 Training 14,391 20,574 22,843 31,870 31,870 - 0.00% 4800 Insurance & bonds 40,297 147,549 57,482 59,500 59,500 - 0.00% 5100 Technology maintenance 55,109 64,339 76,267 89,473 95,496 6,023 6.73% 5130 Maintenance, equipment 5,026 4,673 2,953 7,840 9,840 2,000 25.51% Total contractual services 324,121 439,500 362,145 404,637 423,881 19,244 4.76% Total police 2,969,790 3,325,570 3,258,674 3,442,885 3,637,988 195,103 5.67% 415,053 513,712 436,719 481,707 510,536 17 Fund: 100 Department: 4200 Police Account Description 2019 2020 2021 2022 Description 1230 Supplies, equipment < $5000 3,000 3,000 3,000 3,000 Miscellaneous office equipment 800 800 800 800 Alco-sensor portable breath test (PBT's) ($800 each) 2,300 2,300 2,300 2,300 light bar $2,300 6,100 6,100 6,100 6,100 1600 Supplies, operating 3,000 3,000 3,000 3,000 Photo print supplies, fire extinguishers, gloves, inkjet cartridges, toner, etc. 1,200 1,200 1,200 1,200 K9 Food 500 500 500 500 Portable radio batteries (10) @ $50 6,000 6,000 6,000 7,500 Batteries, breathalyzer parts, DVD's & CD's, disinfectant, simulation ammo ammunition, crime scene tape, emergency blankets, etc. 10,700 10,700 10,700 12,200 1700 Motor, fuels, & lubs - 36,660 41,600 35,650 42,625 Unleaded gas 15,500 gallons @ $2.75/gal. 1,560 1,650 1,380 1,650 K9 take home car gas 600 gallons @ $2.75 38,220 43,250 37,030 44,275 2100 Books & periodicals 300 300 300 300 Traf, law, crim. law, HR, employ. law, school year books, & misc. books 300 300 300 300 2400 Uniforms & clothing 775 800 820 860 Chief 775 800 820 860 Deputy Chief 4,000 4,000 4,000 4,000 Initial officer set-ups replacing up to two retiring officers 14,800 15,200 15,580 16,340 16 officers @ $820, 3 sgts @ $820 - 2020 ($840-2021, $860-2022) 720 720 720 720 Admin. assistant, Records tech, 2@$360 1,000 1,000 1,000 1 1,000 Traffic vests, Taser holsters, & misc items 22,070 22,520 22,940 23,780 3020 Legal, prosecuting attorney 75,000 75,000 75,000 75,000 Retainer ($6,125 per month)(misc charges $1,500) 75,000 75,000 75,000 75,000 3030 Other professional services 900 900 900 900 Tobacco compliance project 150 150 150 150 Hazardous material disposal fee 1,400 1,400 1,400 1,400 Lab fees, blood tests, physical tests, video, misc. - - - 5,000 Mental Health Service (annual) 240 240 1,400 1,400 Automated Pawn service 1,000 1,000 1,000 1 1,000 Civil Service and medical testing for new officers 3,690 3,690 4,850 9,850 3050 Dispatching 94,793 96,808 102,053 99,274 Ramsey County dispatching (5% estimated increase) 94,793 96,808 102,053 99,274 3055 Informational systems fees 2,080 2,080 2,080 2,080 State service fee - CJDN ($510 per quarter) 2,350 2,350 2,350 2,350 BCA connectivity charge thru Ramsey Cty for CAD 525 525 525 525 IACP.net ($525 annual) 4,955 4,955 4,955 4,955 3070 COPS events/outreach 6,000 6,000 6,000 15,000 NNO, child ID, stickers, shop, bowl, other outreach, COP House ($9,000) 6,000 6,000 6,000 15,000 3080 Veterinarian services 1,000 1,000 1,000 1,000 Veterinary impound services 1,000 1,000 1,000 1,000 K9 vet services 2,000 2,000 2,000 2,000 3100 Telephone 5,875 12,348 12,348 12,348 Cell phones (increase from 14 to 21 phones$49 per)(all smart) 4,202 6,242 6,242 6,242 Air cards for squads CAD (13) at $40.01 per month 10,077 18,590 18,590 18,590 3210 Electricity 320 320 450 450 Civil defense siren's electricity 320 320 450 450 W THIS PAGE LEFT BLANK INTENTIONALLY 19 Fund: 100 Department: 4200 Police Account Description 2019 2020 2021 2022 Description 3430 Printing 400 400 400 400 Dept manual, Emergency management manual, business cards, 400 400 400 400 3610 Memberships 75 75 75 75 Tri-County Investigator Association 45 45 45 45 Mn Crime Prevention Association 420 420 420 420 Mn Police chiefs 150 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 200 200 200 200 K9 memberships - - - - Notary commission (3 year due in 2021)($120+$20) 630 630 630 630 POST license reimbursement 7 @ $90 35 35 35 35 Prof. Law Enforcement Admin. Assoc. 35 35 35 35 National Association of Town Watch 1,656 1,656 1,656 1,656 3630 Training 710 710 710 710 MN Chiefs conference 2@$355 400 400 400 400 BCA/CJDN training (new records tech) 450 450 450 450 Intox certification (6@$75) 1,000 1,000 1,500 1,500 Range Rental 400 400 400 400 MN Sex Crimes Investigators Assoc Conference 2,000 2,000 2,000 2,000 Tuition reimbursement 3,000 3,000 3,000 3,000 Supervisor training - - 9,400 9,400 New K9 (If the foundation does not fund) 2,800 2,800 2,000 2,000 K9 training 600 600 600 600 Emergency Management training 5,000 5,000 5,000 5,000 Employee development courses 4,000 4,000 4,000 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) 22,770 22,770 31,870 31,870 4800 Insurance & bonds 25,000 25,000 25,000 25,000 Liability and automotive insurance 14,500 14,500 14,500 14,500 Insurance per MN Statute 299A.465 (disability pension eligible employees) 20,000 20,000 20,000 20,000 Allowance for insurance policy deductibles 59,500 59,500 59,500 59,500 5100 Technology - maintenance - - - - Computer network & technology assistance - Roseville (consolidated below) agreements & support 1,000 1,000 1,000 1,000 Copier maintenance + overages 4,000 4,000 2,000 2,000 Automatic License plate reader maintenance 2,500 2,500 2,500 2,500 Taser Maintenance 2,500 5,000 5,000 5,000 Watch Guard body camera maintenance 2,000 2,500 2,500 2,500 Body Camera Server maintenance 7,345 7,396 9,582 10,378 Milestone video maintenance and licenses 3,777 5,552 5,253 6,340 NetMotion 2 factor authentication 30,044 33,598 35,278 38,100 IT support for squad computers and other technology (Roseville) 313 362 380 399 CAD interface (Tritech)(5%)($344 - 2019) 23,564 24,742 25,980 27,279 Records mgt system and ticket writer annual maintence (Tritech)(5%) 77,043 86,650 89,473 95,496 5130 Repairs, equipment 2,579 2,579 2,579 2,579 Misc. equipment repair - defibs, cameras, recorders, fax, printers. - - - 2,000 Rockwall replacement cables 800 800 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) 2,000 2,000 2,000 2,000 Radio repair (one-time reprogramming fee $50) 1,461 1 1,461 1 1,461 1,461 800 MHz radio licenses fees 39 @ 3.12 per month 7,840 1 7,840 1 7,840 9,840 443,434 469,049 481,707 510,536 1.63% 5.78% 2.70% 5.98% 20 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2020 Actual Actual Actual Budget Request Dollar Percent Fire (100 - 4210): Contractual services 3030 Fire inspection services 6,725 6,175 2,050 2,000 2,000 - 0.00% 3032 Contractual fire services 420,148 451,352 463,476 461,824 480,656 18,832 4.08% 3050 Dispatching 5,000 10,455 5,463 5,465 5,796 331 6.06% Total contractual services 431,873 467,982 470,989 469,289 488,452 19,163 4.08% Capital outlays: 7040 Vehicles & equipment 240,227 59,761 51,194 7,560 84,630 77,070 1019.44% Total capital outlays 240,227 59,761 51,194 7,560 84,630 77,070 1019.44% Debt Service: 8010 Principal 91,054 133,793 144,782 144,150 148,025 3,875 2.69% 8020 Interest 39,069 32,319 18,254 14,222 9,991 (4,231)-29.75% Total debt service 130,123 166,112 163,036 158,372 158,016 (356) -0.22% Total Fire 802,223 693,855 685,219 635,221 731,098 95,877 15.09% 2013 Fire Improvement Refunding Bonds will be retired in 2025 2017 Equipment Certificates will be retired in 2022 2018 Equipment Certificates will be retired in 2023 21 Fund: 100 Department: 4210 Account Description 2019 2020 2021 2022 Description 3030 Fire inspection services 2,000 2,000 2,000 2,000 Contractual fee for Fire Marshalling services (SBM) 2,000 2,000 2,000 2,000 3032 Contractual fire services 451,351 464,451 461,824 480,656 Share joint fire dept. costs (fixed @ 15.50%) 451,351 464,451 461,824 480,656 3050 Dispatching 5,150 5,305 5,465 5,796 Anoka County dispatching fee R8810 annual 3% increases 5,150 5,305 5,465 5,796 7040 Capital, vehicles & equipment 59,761 77,430 7,560 84,630 Share of joint fire department's capital costs 59,761 77,430 7,560 84,630 8010 8020 Principal - Fire bond - Blaine Principal - Equip Certs - SLP Principal - Equip Certs - Blaine Interest - Fire bond - Blaine Interest - Equip Certs - SLP Interest - Equip Certs - Blaine 76,954 34,384 31,928 11,527 4,348 1 6,975 76,791 35,196 32,796 9,759 3,240 1 5,256 75,950 34,875 33,325 7,967 2,116 1 4,139 77,500 35,650 34,875 6,448 1,070 2,473 15.500% of prin pymt on 2013 refunding Fire bonds 15.500% ofprin pymt on 2017 Equip Certs 15.500% of prin pymt on 2018 Equip Certs 15.500% of int pymt on 2013 refunding Fire bonds 15.500% of int pymt on 2017 Equip Certs 15.500% of int pymt on 2018 Equip Certs 166,116 1 163,038 1 158,372 158,016 Using 15.500% 684,378 712,224 635,221 731,098 13.42% 4.07%-10.81% 15.09% 22 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2020 Actual Actual Actual Budeet Request Dollar Percent Recreation (100 - 4350): Materials & supplies: 1600 Supplies, operating - - 266 - - - #DIV/0! Total materials & supplies - - 266 - - - #DIV/0! Contractual services: 3036 Contractual recreation 122,927 124,843 95,269 - - - 0.00% 4800 Bonding & insurance 1,034 1,097 1,260 - - - 0.00% Total contractual services 123,961 125,940 96,529 - - - 0.00% Total Recreation 123,961 125,940 96,795 - - - 0.00% 23 Fund: 100 Department: 4350 Recreation Account Description 2019 2020 2021 2022 Description 3036 Contractual recreation 114,542 6,000 127,271 6,000 YMCA Mgt contract (42% of $311,512)*(est. inflation + 1.3%)(use 2.8%) Ice Skating supervision 120,542 133,271 rMoo— Bonding & insurance 1,500 1,500 Insurance & bonding cost. 1,500 1,500 122,042 134,771 2.69% 10.43%-100.00% #DIV/0! 10 yr avg 10 yr avg 10 yr avg 114,019 114,936 103,976 24 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2020 Actual Actual Actual Budeet Request Dollar Percent Parks Maintenance (100 - 4360): Personnel services 0100 Salaries, regular 109,413 130,553 161,400 207,675 217,131 9,456 4.55% 0110 Overtime, regular 10,213 14,277 9,475 8,820 9,308 488 5.53% 0150 Salaries, part-time 18,353 25,933 32,265 33,180 35,392 2,212 6.67% 0300 Social Security 10,386 12,943 15,349 19,100 20,029 929 4.86% 0321 PERA 8,550 10,627 12,224 16,237 16,983 746 4.59% 0400 Group insurance 16,732 21,992 21,933 37,524 42,480 4,956 13.21% 0500 Workers compensation 6,642 9,261 12,354 16,284 16,670 386 2.37% Total personnel services 180,289 225,586 265,000 338,820 357,993 19,173 5.66% Materials & supplies: 1210 Supplies, bldgs & grnds 9,626 12,955 12,252 12,600 12,600 - 0.00% 1220 Supplies, vehicles & mowers 2,324 4,611 7,224 6,500 6,500 - 0.00% 1230 Supplies, equipment 3,019 13,572 14,042 6,850 13,250 6,400 93.43% 1600 Supplies, operating 11,269 6,774 8,074 11,000 11,000 - 0.00% 1700 Motor fuels & lubs 9,391 6,761 7,794 7,670 9,020 1,350 17.60% 2400 Uniforms & clothing 1,405 1,238 2,637 1,050 1,050 - 0.00% 2410 Mats & towels 610 608 629 728 728 - 0.00% Total materials & supplies 37,644 46,519 52,652 46,398 54,148 7,750 16.70% Contractual services: 3030 Other professional services 9,367 10,001 9,845 10,260 10,260 - 0.00% 3100 Telephone 1,443 1,409 1,636 2,056 1,206 (850) -41.34% 3200 Water & sewer 5,913 7,734 9,307 6,500 6,500 - 0.00% 3210 Electricity 9,077 9,849 9,657 12,000 10,500 (1,500) -12.50% 3220 Natural gas 5,531 6,144 4,904 4,800 5,200 400 8.33% 3610 Memberships 10 - - 50 100 50 100.00% 3630 Training & conferences 1,351 2,395 220 2,520 3,420 900 35.71% 3900 Grants & subsidies 11,500 11,500 11,573 11,500 11,500 - 0.00% 4010 Rental, equipment - 1,195 2,628 2,000 2,000 - 0.00% 4030 Portable restrooms 5,178 5,354 5,256 5,500 6,000 500 9.09% 4800 Bonding & insurance 10,346 10,974 14,118 15,000 15,000 - 0.00% 5110 Repairs, bldg & grounds 9,262 3,769 12,270 9,690 9,690 - 0.00% 5130 Repairs, equipment - - 344 - - - 0.00% Total contractual services 68,978 70,324 81,758 81,876 81,376 (500) -0.61% Total Parks 286,911 342,429 399,410 467,094 493,517 26,423 5.66% 106,622 116,843 134,410 128,274 13 5, 524 25 Fund: 100 Department: 4360 Parks Account Description 2019 2020 2021 2022 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 2,000 2,000 City Hall Park sign (estimate) 2,000 2,000 2,000 2,000 Seed, fertilizer 12,600 12,600 12,600 12,600 1220 Supplies, vehicles 3,500 3,500 3,500 3,500 Oil filters, mower blades, tires, vehicle registration fees, 3,000 3,000 3,000 3,000 Miscellaneous repairs 6,500 6,500 6,500 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. - 600 700 700 Chain saw (emergency only)(every 2 years)(weed whip) - - 2,000 Replace trash cans ($397 each) - - - 4,400 Grills (CH, Silver View) Ash recepticles (Groveland, Hillview, CH, Random) 4,500 4,500 4,400 4,400 Replace park equipment, fixtures and raise parts 6,250 6,850 6,850 13,250 1600 Supplies, operating 2,500 3,000 2,800 2,800 Fiber fill for play lots & courts 200 200 300 300 Herbicide 2,000 2,000 1,800 1,800 Wood chips for trees 500 500 700 700 Ag-lime, black dirt, seed, and surface drying compound for fields 300 300 500 500 Surface drying compound 800 800 800 800 Nets 3,100 3,100 2,900 2,900 Field paint & chalk (partially reimb by school district) 700 700 700 700 Landscaping materials 400 400 500 500 Hand tools (batteries for hand tools) 10,500 11,000 11,000 11,000 1700 Motor fuels & lubes 5,720 6,050 5,060 6,050 2,200 gallons of unleaded gas @ $2.75 2,790 2,925 2,610 2,970 900 gallons of diesel fuel @ $3.30 8,510 8,975 7,670 9,020 2400 Uniforms & clothing 350 350 350 350 Clothing allowance 2.0 FTE 820 500 500 500 Uniforms 18.2% of $4,500 200 200 200 200 Safety glasses, masks, ear protection, etc. 1,370 1,050 1,050 1,050 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 - - - HVAC maintenance (in Buildings & Grounds) 960 1,400 1,400 1,400 Fire sprinkler testing 120 120 240 240 Backflow prevention testing (3@ $80) 8,380 8,380 8,380 8,380 Broadleaf control 10,300 10,140 10,260 10,260 26 THIS PAGE LEFT BLANK INTENTIONALLY 27 Fund: 100 Department: 4360 Parks (continued) Account Description 2019 2020 2021 2022 Description 3100 Telephone 1,206 1,206 1,206 1,206 Cellular phones (13. 1 % of $9,200) 850 850 850 - GPS units for mowers (split with dept 4472) 2,056 2,056 2,056 1,206 3200 Water & wastewater 6,500 6,500 6,500 6,500 Parkland irrigation & park bathrooms 6,500 6,500 6,500 6,500 3210 Electricity 10,000 12,000 12,000 10,500 Est. 5 park buildings, park sec. lighting, court & field lighting & splash pad 10,000 12,000 12,000 10,500 3220 Natural gas 4,800 4,800 4,800 5,200 Heating cost for Random, Hillview, Groveland, & Lambert Park bldgs. 4,800 4,800 4,800 5,200 3610 Memberships 50 50 50 100 Playground inspector license (2) 50 50 50 100 3630 Training & conferences 75 75 75 75 Computer classes 100 100 100 100 Hearing tests/RTN training (2@$50) 60 60 60 60 Maintenance EXPO 110 110 110 110 Loss control workshops 1,600 1,600 1,600 1,900 Playground inspection training (Certified Playground Safety Inspector CPSI) 375 375 375 375 Equipment training (18.2% of $2,050) - - - 600 Green Expo 200 200 200 200 Pesticide application class (every 2 years) 2,520 2,520 2,520 3,420 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,000 2,000 2,000 2,000 Tools and equipment (sod cutter, chipper, concrete mixer, etc...) 2,000 2,000 2,000 2,000 4030 Portable restrooms 5,000 5,500 5,500 6,000 For May thrn Oct, plus special events such as tournaments, & extra cleanings and insurance 5,000 5,500 5,500 6,000 4800 Bonding & insurance 11,000 11,000 11,000 11,000 Insurance policy premiums 4,000 4,000 4,000 4,000 Allowance for insurance policy deductibles 15,000 15,000 15,000 15,000 5110 Repairs, bldgs & grounds 750 750 750 750 Windows, doors, & lock repairs 1,000 1,000 1,000 1,000 Building exterior repairs 1,500 1,500 1,500 1,500 Irrigation system repairs 1,000 1,000 750 750 Field light repairs 2,500 2,500 3,000 3,000 Repairs to playground equipment 2,500 1,500 1,250 1,250 Repairs to furnaces, plumbing, phones, electrical., etc 1,440 1,440 1,440 HVAC preventive maintenance agreement (4 park buildings) 9,250 9,690 9,690 9,690 125,434 129,459 128,274 135,524 2.22% 3.21% -0.92% 5.65% 10 yr avg 10 yr avg 10 yr avg 115,597 118,510 121,786 W. 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2020 Actual Actual Actual Budeet Request Dollar Percent Forestry (100 - 4380): Personnel services 0100 Salaries, regular 1,781 2,773 3,647 6,448 6,985 537 8.33% 0110 Overtime, regular 47 202 135 - - - 0.00% 0300 Social Security 138 225 286 493 534 41 8.32% 0321 PERA 128 226 289 484 524 40 8.26% 0400 Group insurance 293 561 516 1,272 1,440 168 13.21% 0500 Workers compensation 112 151 315 416 441 25 6.01% Total personnel services 2,499 4,138 5,188 9,113 9,924 811 8.90% 0.00% Materials & supplies 1200 Supplies, landscaping 2,588 5,287 5,488 9,400 9,400 - 0.00% 1210 Supplies, bldgs & grnds 1,489 - - - - - 0.00% Total materials & supplies 4,077 5,287 5,488 9,400 9,400 - 0.00% Contractual services 3030 Professional services 10,458 6,476 5,000 9,000 9,000 - 0.00% 3520 Tree removal (offset by charges) 19,312 28,284 48,216 25,000 48,000 23,000 92.00% 3630 Training & conferences 490 - 200 1,700 1,820 120 Total contractual services 30,260 34,760 53,416 35,700 58,820 23,120 64.76% Total Forestry 36,836 44,185 64,092 54,213 78,144 23,931 44.14% 34,337 40,047 58,904 45,100 68,220 Fund: 100 Department: 4380 Account Description 2019 2020 2021 2022 Description 1200 Supplies, landscaping 400 400 400 400 Landscaping materials 1,500 1,500 1,500 1,500 Small trees to replace damaged trees 2,500 2,500 2,500 2,500 Large trees - storm damage replacement - 800 800 800 Forestry equipment (saw, chaps, chains) 5,000 4,200 4,200 4,200 Ash tree replacement trees (EAB) 9,400 9,400 9,400 9,400 3030 Professional services 5,000 5,000 5,000 5,000 Tree trimming 500 500 500 500 Asset mgt. software 1,500 1,500 1,500 1,500 Forestry consulting/testing 2,000 2,000 2,000 2,000 Tree injections (Ash every 2 years) 9,000 9,000 9,000 9,000 3520 Tree removal 25,000 25,000 25,000 1 48,000 Remove or treat diseased trees (offset by charges 100-3432) 25,000 25,000 25,000 48,000 3630 Training & memberships 800 800 800 800 Tree Inspector training - - - 120 ISA membership 600 600 600 600 Arborist Test 300 300 300 300 Tree Inspector license 1,700 1,700 1 1,700 1,820 45,100 45,100 45,100 68,220 17.75% 0.00% 0.00% 51.26% 10 yr avg 10 yr avg 10 yr avg 62,075 60,440 59,450 W 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2020 Actual Actual Actual Budget Request Dollar Percent Public Works Administration (100-4410): Personnel services: 0100 Salaries, regular 108,326 118,944 89,909 92,558 95,331 2,773 3.00% 0110 Salaries, overtime 2,861 2,577 1,110 - - - 0.00% 0300 Social Security 7,773 8,684 6,769 6,853 7,060 207 3.02% 0321 PERA 8,107 8,845 6,816 6,719 6,920 201 2.99% 0400 Group insurance 9,305 9,800 11,059 12,516 14,340 1,824 14.57% 0500 Workers compensation 974 1,456 802 682 687 5 0.73% Total personnel services 137,346 150,306 116,465 119,328 124,338 5,010 4.20% Materials & supplies: 1600 Operating supplies 1,052 2400 Uniforms & clothing - 2410 Mats & towels - Total materials and supplies 1,052 Contractual services: 3030 Other professional services 9,083 3100 Telephone 847 3610 Memberships 410 3630 Training & conferences 615 3800 Mileage reimbursement - 176 262 800 800 - 0.00% 134 105 150 150 - 0.00% 46 48 - - - 0.00% 356 415 950 950 - 0.00% 805 976 900 900 - 0.00% 719 579 773 773 - 0.00% 550 400 660 1,610 950 143.94% 970 140 895 895 - 0.00% - - 100 100 - 0.00% Total contractual services 10,955 3,044 2,095 3,328 4,278 950 28.55% Total public works administration 149,353 153,706 118,975 123,606 129,566 5,960 4.82% 12,007 3,400 2,510 4,278 5,228 31 Fund: 100 Department: 4410 Public Works Adminstration Account Description 2019 2020 2021 2022 Description 1600 Operating Supplies 230 600 800 800 Office supplies 230 600 800 800 2400 Uniforms & clothing 200 150 150 150 33% of Supervisor's uniform cost. 200 150 150 150 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 400 400 400 400 American Public Works Association memb. (APWA) (1/2 of $800) 60 60 60 60 City Engineer's Association of MN (CEAM) - 200 200 200 Safe Assure - - 500 Minnesota Parks & Recreation Association (MPRA) - 450 National Rereations &Parks Association (NRPA) 265 - MN Board of AELSLAGID (PE Renewal even years) 725 660 660 1,610 3630 Training & conferences 500 500 500 500 CEAM / APWA conferences 50 50 50 50 Computer classes/Web training 15 15 15 15 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 895 895 895 895 3800 Mileage reimbursement 150 150 100 100 vehicle mileage reimbursement 150 150 100 100 3,873 4,128 4,278 5,228 -0.77% 6.58% 3.63% 22.21% 10 yr avg 10 yr avg 10 yr avg 3,925 3,927 4,049 32 2022 Budget Summary 2018 Actual Building & Grounds Maintenance (100 - 4460): Personnel services: 0100 Salaries, regular 10,222 0110 Salaries, overtime 1,512 0300 Social Security 881 0321 PERA 831 0400 Group insurance 435 0500 Workers compensation 504 2019 2020 2021 2022 Change from 2020 Actual Actual Budget Request Dollar Percent 9,931 11,882 13,338 13,703 365 2.74% 1,145 880 842 864 22 2.61% 826 966 1,084 1,115 31 2.86% 818 921 1,064 1,093 29 2.73% 1,893 174 2,862 3,240 378 13.21% 843 847 766 767 1 0.13% Total personnel services 14,385 15,456 15,670 19,956 20,782 826 4.14% Materials & supplies: 1210 Supplies, building & grounds 1220 Supplies, vehicles 1230 Supplies, equipment 1600 Supplies, operating 1700 Motor fuels & lubricants 2400 Uniforms & clothing 2410 Mats & towels Total materials & supplies Contractual services: 3030 Other professional services 3100 Telephone 3200 Water & sewer 3210 Electricity 3220 Natural gas 3530 Refuse collection 4010 Rental, equipment 4800 Insurance 5110 Repairs, bldgs & grounds 5130 Repairs, equipment Total contractual services Capital outlays 7030 Equipment Total capital outlays 2,970 5,950 2,551 3,400 11,172 7,772 228.59% 118 - - - - - 0.00% 617 1,114 784 2,000 2,000 - 0.00% 9,907 7,513 11,621 5,300 5,300 - 0.00% 379 356 - - - - 0.00% 72 509 36 117 117 - 0.00% 60 75 16 1,000 1,000 - 0.00% 14,123 15,517 15,008 11,817 19,589 7,772 65.77% 28,019 29,634 44,297 40,772 15,972 (24,800) -60.83% 159 202 1,294 129 129 - 0.00% 722 416 1,091 1,000 1,000 - 0.00% 29,889 29,325 30,422 23,500 23,500 - 0.00% 21,348 19,818 19,501 17,000 17,000 - 0.00% 11,169 10,867 10,181 8,880 8,880 - 0.00% 130 237 - 200 200 - 0.00% 4,828 5,121 5,878 7,000 7,000 - 0.00% 11,172 6,742 21,476 17,455 17,455 - 0.00% 8,471 10,008 6,253 6,000 6,000 - 0.00% 115,907 112,370 140,393 121,936 97,136 (24,800) -20.34% 130,030 127,887 155,401 133,753 116,725 0.00% - - - - - - 0.00% Total buildings & grounds 144,415 143,343 171,071 153,709 137,507 (16,202)-10.54% 33 Fund: 100 Department: 4460 Building & Ground Maintenance Account Description 2019 2020 2021 2022 Description 1210 Supplies, bldgs & grounds 3,400 3,400 3,400 3,400 Bldg repairs, cleaning/heating supplies, batteries 7,772 Genesis Air bulbs (HVAC) 3,400 3,400 3,400 11,172 1230 Supplies, equipment < $5000 1,000 2,000 2,000 2,000 Repair parts, filters, hoses, etc., office furniture 1,000 2,000 2,000 2,000 1600 Supplies, operating 1,700 1,700 1,700 1,700 Cleaning supplies 150 150 150 150 Lumber & fasteners 300 300 300 300 Repair items & hardware 300 300 300 300 First aid supplies 200 200 200 200 Light bulbs & ballasts 950 950 950 950 Paper supplies 600 600 600 600 Mechanical items, fans, motors, etc 400 400 400 400 Office supplies 700 700 700 700 Paint & supplies - parking lot & building 5,300 5,300 5,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) 910 910 910 910 Floor mats at CH ($45/month) 1,000 1,000 1,000 1,000 3030 Other professional services 180 180 400 400 Backflow prevention testing (5@$80) 60 60 60 60 Boiler & pressure vessel registration program 10,165 6,212 6,212 6,212 HVAC maintenance (City Hall & PW facilities) 19,900 20,400 20,400 - City Hall cleaning contract (renews in 2019)(moved in house) - 4,400 4,400 - PW cleaning contract (new)(moved in house) 3,000 3,500 3,500 3,500 Carpet cleaning, floor striping & waxing (2 times) 1,800 1,800 1,800 1,800 Alarm testing and monitoring 1,200 1,200 1,200 1,200 Pest control (12@$100) - - 1,800 1,800 Service contract for generator 600 600 1,000 1,000 Fire extingiusher inspection/service (30@$20) Toxalet testing 36,905 38,352 40,772 15,972 3100 Telephone 129 129 129 129 Cellphone (1.6% of $7,500)($9,200) 129 129 129 129 3200 Water & Sewer 1,000 1,000 1,000 1,000 Service at City Hall and Public Works buildings 1,000 1,000 1,000 1,000 3210 Electricity 22,000 23,500 23,500 23,500 Electricity at City Hall and Public Works buildings 22,000 23,500 23,500 23,500 3220 Natural gas 17,000 17,000 17,000 17,000 Natural gas at City Hall and Public Works buildings 17,000 17,000 17,000 17,000 3530 Refuse collection 196 196 196 196 Hazardous waste disposal, Lamps $100, batteries $30 264 264 264 264 Hazardous waste annual fee (State of MN PCA) 90 470 470 470 Hazardous waste generator license fee (Ramsey County) 150 150 150 150 Used oil filters ($100 in vehicle maint.) 7,800 7,800 7,800 1 7,800 Facility dumpsters, city hall, public works 8,500 8,880 8,880 8,880 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 1,500 1,500 1,500 1,500 Door & gate opener repairs 2,500 4,755 4,755 4,755 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 1 10,000 10,000 10,000 General building & ground maintenance 10,200 17,455 1 7,455 1 17,455 5130 Repairs, equipment 5,000 6,000 6,000 6,000 HVAC, plumbing & electrical repairs 5,000 6,000 6,000 6,000 118,751 131,333 133,753 116,725 4.81% 10.60% 1.84%-12.73% 10 yr avg 10 yr avg 10 yr avg 114,433 115,651 117,372 34 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2020 Actual Actual Actual Budget Request Dollar Percent Vehicle & Equipment Maintenance (100 - 4465): Personnel services: 0100 Salaries, regular 38,359 42,045 43,851 44,447 45,779 1,332 3.00% 0110 Salaries, overtime 2,918 1,903 2,140 664 684 20 3.01% 0300 Social Security 2,822 2,994 3,043 3,451 3,554 103 2.98% 0321 PERA 3,083 3,278 3,478 3,384 3,484 100 2.96% 0400 Group insurance 9,011 7,847 8,183 8,850 10,224 1,374 15.53% 0500 Workers compensation 1,279 1,820 1,875 2,048 2,061 13 0.63% Total personnel services 57,472 59,887 62,570 62,844 65,786 2,942 4.68% Materials & supplies: 1220 Supplies, vehicles 33,268 14,535 31,027 22,950 27,450 4,500 19.61% 1230 Supplies, equipment 9,487 5,739 4,798 7,500 11,000 3,500 46.67% 1600 Supplies, operating 6,302 7,133 7,818 7,400 7,500 100 1.35% 1700 Motor fuels & lubricants - unleadf 4,529 3,649 3,431 3,260 3,300 40 1.23% 1701 Motor fuels & lubricants - diesel - - - - - - 0.00% 2400 Uniforms & clothing 220 584 711 305 305 - 0.00% 2410 Mats & towels 184 198 205 220 220 - 0.00% Total materials & supplies 53,990 31,838 47,990 41,635 49,775 8,140 19.55% Contractual services: 3030 Other professional services - - 71 - 0.00% 3100 Telephone 406 407 416 387 387 - 0.00% 3530 Refuse collection 50 - 50 100 100 - 0.00% 3610 Memberships 20 1,728 16 100 100 - 0.00% 3630 Training 1,278 50 130 810 1,810 1,000 123.46% 4010 Rental, equipment 422 - - 100 100 - 0.00% 5120 Repairs, vehicles 10,042 17,016 21,330 17,050 17,050 - 0.00% 5130 Repairs, equipment 1,131 2,455 3,533 9,500 9,500 - 0.00% Total contractual services 13,349 21,656 25,546 28,047 29,047 1,000 3.57% Total vehicle & equipment maintenance 124,811 113,381 136,106 132,526 144,608 12,082 9.12% 67,339 53,494 73,536 69,682 78,822 35 Fund: 100 Department: 4465 Vehicle & Equipment Maintenance Account Description 2019 2020 2021 2022 Description 1220 Supplies, vehicles 200 200 200 200 Brake fluid 700 700 700 1,300 Misc parts, fastners 500 500 500 500 Anti freeze 300 300 300 300 Air conditioning gas 500 500 500 1,100 Headlamps, spots, & bulbs 1,000 1,000 1,000 1,600 Tune up items 500 500 500 500 Wiper blades & fluid 2,250 2,250 2,250 2,850 Minor repairs, rebuilds 2,000 2,000 2,000 2,600 Automotive parts 2,500 2,500 2,500 2,900 Filters: oil, air, fuel, transmission 2,500 2,500 2,500 3,100 Brake pads & shoes 10,000 10,000 10,000 10,500 Tires & batteries 22,950 22,950 22,950 27,450 1230 Supplies, equipment < $5000 3,000 3,000 3,000 3,000 Small equipment tune up items, hand tools 1,000 1,000 1,000 1,000 Filters belts & hoses 1,000 1,000 1,000 1,000 Hydraulic system repairs - - - 3,500 Band saw 2,500 2,500 2,500 2,500 Vehicle Asset Management software 7,500 7,500 7,500 11,000 1600 Supplies, operating 1,000 2,000 2,000 2,000 Battery charger, Load tester 550 550 550 600 Welding supplies 750 750 750 800 Chains, clevises, & hitch pins 900 900 900 900 Equipment & vehicle cleaning supplies 700 700 700 700 Steel for repairs & fabrication 550 550 550 550 License tabs 950 950 950 950 Solvents & degreasers 600 1,000 1,000 1,000 Fastners & electrical supplies 6,000 7,400 7,400 7,500 1700 Motor fuels & lubricants 60 60 60 100 Gear Tube 200 200 200 200 ATE - 7 cases 500 500 500 500 Aftermarket additives 2,500 2,500 2,500 2,500 Engine oil: 280 gallons (synthetic) 3,260 3,260 3,260 3,300 2400 Uniforms & clothing 270 200 200 200 Uniforms 6% of $4,500) 105 105 105 105 Clothing and boot allowance (.6@$175) 375 305 305 305 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 100 100 100 100 Vehicle inspection license renewal (DOT required) 100 100 100 100 3630 Training 30 30 30 30 Hearing test/RTN training (.6@$50) 30 30 30 30 Maintenance Expo 200 300 300 300 Misc training 200 200 200 1,200 ASE certifications 190 250 250 1 250 Vehicle inspection recertification (DOT required) 650 810 810 1,810 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 1,960 1,960 1,960 1,960 Tire repairs 950 1,200 1,200 1,200 Ignition scanner software update 1,740 1,740 1,740 1,740 Mitchell On Demand Software 2,000 2,000 2,000 2,000 Transmission repairs 16,800 17,050 17,050 17,050 5130 Repairs, equipment 500 500 500 500 Accident repairs - 4,000 4,000 4,000 Oil testing 3,000 3,000 3,000 3,000 Mechanical repairs 2,000 2,000 2,000 2,000 Motor repairs 5,500 9,500 9,500 9,500 63,942 69,682 69,682 78,822 11.11% 8.98% 0.00% 13.12% 10 yr avg 10 yr avg 10 yr avg 52,830.40 55,477.10 57,952.30 109 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2020 Actual Actual Actual Budget Request Dollar Percent Street Pavement Management (100 - 4470): Personnel services: 0100 Salaries, regular 111,253 125,650 121,924 118,148 124,493 6,345 5.37% 0110 Salaries, overtime 4,552 5,222 6,128 3,414 3,657 243 7.12% 0150 Salaries, part-time 7,012 7,451 4,560 9,360 9,984 624 6.67% 0300 Social Security 8,982 10,195 9,488 9,979 10,531 552 5.53% 0321 PERA 8,687 9,220 9,170 9,081 9,574 493 5.43% 0400 Group insurance 11,123 12,980 13,933 16,854 19,080 2,226 13.21% 0500 Workers compensation 7,264 8,020 8,622 9,639 9,909 270 2.80% 0600 Unemployment 2,470 - - - - - 0.00% Total personnel services 161,343 178,738 173,825 176,475 187,228 10,753 6.09% Materials & supplies: 1230 Supplies, equipment 2,408 6,205 1,242 1,650 1,950 300 18.18% 1240 Supplies, streets 2,431 4,840 5,627 6,500 6,500 - 0.00% 1260 Supplies, traffic control 868 992 - 900 900 - 0.00% 1600 Supplies, operating 4,212 1,103 559 2,000 2,000 - 0.00% 1700 Motor fuels & lubricants 13,771 9,465 8,003 6,760 7,865 1,105 16.35% 2400 Uniforms & clothing 556 1,765 1,627 1,211 1,211 - 0.00% 2410 Mats & towels 359 364 376 436 436 - 0.00% Total materials & supplies 24,605 24,734 17,434 19,457 20,862 1,405 7.22% Contractual services: 3030 Other professional services 11,137 19,225 13,405 16,450 16,450 - 0.00% 3100 Telephone 1,115 1,128 1,353 966 966 - 0.00% 3610 Memberships 250 210 200 215 215 - 0.00% 3630 Training & conferences 865 170 285 1,005 1,005 - 0.00% 4010 Rental, equipment 422 3,981 2,046 5,000 5,000 - 0.00% 4800 Insurance 5,532 4,536 5,206 6,200 6,200 - 0.00% 5130 Repairs, equipment - 1,646 4,425 500 500 - 0.00% Total contractual supplies 19,321 30,896 26,920 30,336 30,336 - 0.00% Total street pavement management 205,269 234,368 218,179 226,268 238,426 12,158 5.37% 43,926 55,630 44,354 49,793 51,198 37 Fund: 100 Department: 4470 Pavement Management Account Description 2019 2020 2021 2022 Description 1230 Supplies, equipment < $5000 750 750 750 750 Safety vests and other safety equipment 1,000 1,000 500 - Radio/hearing protection - - - 800 Chainsaw 750 400 400 Backpack blower 2,500 1,750 1,650 1,950 1240 Supplies, street repair 4,000 4,000 4,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 6,500 6,500 6,500 6,500 1260 Supplies, traffic control 400 400 400 400 Traffic cones/baracades 500 500 500 500 portable signs (traffic control) 900 900 900 900 1600 Supplies, operating 1,350 1,350 1,350 1,350 Asphalt hand tools, rakes, etc. 650 650 650 650 Batteries, shop supplies, etc. 2,000 2,000 2,000 2,000 1700 Motor fuels & lubricants 4,030 4,225 3,770 4,290 Diesel fuel: 1300 gallons @ $3.30 3,380 3,575 2,990 3,575 Unleaded fuel: 1300 gallons @ $2.75 7,410 7,800 6,760 7,865 2400 Uniforms & clothing 491 1,001 1,001 1,001 Uniforms (10.9% of $4,500) 210 210 210 210 Clothing and boot allowance (1.2@$175) 701 1,211 1,211 1,211 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. 5,000 5,000 5,000 5,000 Engineering services. 500 500 500 500 Asset management software annual maintenance 650 650 650 650 ROW weed control 2,500 2,500 2,500 2,500 Sidewalk joint corrections 6,000 6,000 6,000 1 6,000 CSAH 10 Planter Maintenance 16,450 16,450 16,450 16,450 3100 Communications 966 966 966 966 Cellular telephones (10.5% of $9,200) 966 966 966 966 3610 Memberships 200 200 200 200 American Public Works Association memb. (APWA) (1/4 of $800) 15 15 15 15 Pesticide license renewal (TF) 215 215 215 215 3630 Training & conferences 50 50 50 50 Computer classes 150 150 150 150 Electronics updates, other classes 60 60 60 60 Hearing test/RTN training (1.16@$50) 60 60 60 60 Maintenance Expo 150 150 150 150 APWA/MN conferences. 250 250 250 250 Pavement, sealcoating, patching & sealcoating seminars. 150 150 150 150 Equipment operator training 60 60 60 60 Vehicle inspection license renewal 75 75 75 75 Vehicle inspection recertification 1,005 1,005 1,005 1,005 4010 Rentals, equipment 2,500 2,500 2,500 2,500 Annual trade-in of skidsteer loaders (no trade-in during 2017) 2,500 2,500 2,500 2,500 Specialized equip rental (chipper, crack sealing,) 5,000 5,000 5,000 5,000 4800 Bonding & insurance 4,800 4,800 4,800 4,800 Insurance policy premiums 1,400 1,400 1,400 1,400 Allowance for insurance policy deductibles 6,200 6,200 6,200 6,200 r3130 Repairs, equipment 500 500 500 500 Misc. equipment repairs 500 500 500 500 50,783 50,933 49,793 51,198 -6.94% 0.30% -2.24% 2.82% 10 yr avg 10 yr avg 10 yr avg 59,995 58,978 58,319 2022 Budget Summary Street Snow & Ice Control (100 - 4472): Personnel services: 0100 Salaries, regular 0110 Salaries, overtime 0300 Social Security 0321 PERA 0400 Group insurance 0500 Workers compensation Total personnel services Materials & supplies: 1230 Supplies, equipment 1600 Supplies, operating 1700 Motor fuels & lubricants 2400 Uniforms & clothing 2410 Mats & towels Total materials & supplies 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 2018 2019 2020 2021 2022 Change from 2020 Actual Actual Actual Budget Request Dollar Percent 65,692 72,027 67,450 66,544 70,288 3,744 5.63% 23,455 24,759 18,155 7,726 7,958 232 3.00% 6,386 7,025 6,169 5,664 5,955 291 5.14% 6,222 7,320 6,243 5,553 5,839 286 5.15% 10,532 11,077 8,551 10,494 11,880 1,386 13.21% 5,125 6,178 6,507 6,898 7,105 207 3.00% 117,412 128,386 113,075 102,879 109,025 6,146 5.97% 11,043 8,536 9,597 7,900 7,900 - 0.00% 31,128 30,405 30,830 31,175 31,175 - 0.00% 3,482 5,104 3,295 3,080 3,480 400 12.99% 338 573 540 458 458 - 0.00% 281 302 316 328 328 - 0.00% 46,272 44,920 44,578 42,941 43,341 400 0.93% 1,225 1,277 1,464 1,450 1,450 - 0.00% 1,538 1,459 882 1,329 3,079 1,750 131.68% 70 - - - - - 0.00% 85 - 85 285 285 - 0.00% 1,927 1,950 1,262 6,000 6,000 - 0.00% 4,845 4,686 3,693 9,064 10,814 1,750 19.31% - 0.00% - - - - - - 0.00% Total streets snow & ice control 168,529 177,992 161,346 154,884 163,180 8,296 5.36% 51,117 49,606 48,271 52,005 54,155 Fund: 100 Department: 4472 Snow & Ice Control Account Description 2019 2020 2021 2022 Description 1230 Supplies, equipment < $5000 500 - 400 2,000 500 5,000 400 2,000 500 5,000 400 2,000 500 5,000 400 2,000 Filters Skidsteer broom Chloride Tank Cutting edges, plow shoes 2,900 1 7,900 7,900 7,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,100 180 3,250 180 2,900 180 3,300 Engine oil: 30 gallons @ $6.00 per gallon. Diesel fuel: 1,000 gallons @ $3.30 per gallon. 3,280 3,430 3,080 3,480 2400 Uniforms & clothing 370 158 300 158 300 158 300 158 Uniforms (8.2% of $4,500) Clothes & boots allowance (.9@$175) 528 458 458 458 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,450 1,450 1,450 1,450 Weather service reports 1,450 1,450 1,450 1,450 3100 Telephone 579 600 579 750 579 750 579 2,500 Cellphone (6.3% of $7,500)($9,200) GPS data cards (Precise) 1,179 1,329 1,329 3,079 3630 Training 85 200 85 200 85 200 85 1 200 Hearing tests/RTN training (1.1(d$XX) Defensive Driving class (2 staff) 285 1 285 285 285 5130 1 Repairs, equipment 5,500 6,000 6,000 6,000 Plow, blower, salt spreader repairs, paint plow assemblies 5,500 6,000 6,000 6,000 46,625 52,355 52,005 54,155 -2.91% 12.29% -0.67% 4.13% 10 yr avg 10 yr avg 10 yr avg 45,108.20 45,705.40 46,887.60 40 2022 Budget Summary Street Sign Maintenance (100 - 4475): Personnel services: 0100 Salaries, regular 0110 Salaries, overtime 0150 Salaries, part-time 0300 Social Security 0321 PERA 0400 Group insurance 0500 Workers compensation Total personnel services Materials & supplies: 1600 Supplies, operating 2400 Uniforms & clothing 2410 Mats & towels Total materials & supplies Contractual services: 3030 Other professional services 3100 Telephone 3250 Electricity - traffic signals 3630 Training & conferences 5130 Repairs, equipment Total contractual supplies Total street sign maintenance 2018 2019 2020 2021 2022 Change from 2020 Actual Actual Actual Budget Request Dollar Percent 17,528 19,773 20,766 20,234 21,470 1,236 6.11% 781 983 1,003 854 914 60 7.03% - - - 3,120 3,328 208 6.67% 1,331 1,523 1,554 1,852 1,968 116 6.26% 1,330 1,526 1,555 1,582 1,679 97 6.13% 2,058 2,642 2,739 3,180 3,600 420 13.21% 1,205 1,431 1,539 1,866 1,922 56 3.00% 24,233 27,878 29,156 32,688 34,881 2,193 6.71% 19,602 8,800 4,059 22,750 22,750 - 0.00% 74 211 255 435 435 - 0.00% 60 61 63 160 160 - 0.00% 19,736 9,072 4,377 23,345 23,345 - 0.00% 328 6,822 6,050 8,500 8,500 - 0.00% 209 120 - 230 230 - 0.00% 2,799 2,884 3,073 3,000 3,000 - 0.00% 20 - 20 20 20 - 0.00% - 542 - 500 500 - 0.00% 3,356 10,368 9,143 12,250 12,250 - 0.00% 47,325 47,318 42,676 68,283 70,476 2,193 3.21% 23,092 19,440 13,520 35,595 35,595 327,511 309,457 337,592 345,106 341,723 41 Fund: 100 Department: 4475 Street Sign Maintenance Account Description 2019 2020 2021 2022 Description 1600 Supplies, operating 15,000 5,000 1,750 500 500 15,000 5,000 1,750 500 500 15,000 5,000 1,750 500 500 15,000 5,000 1,750 500 500 Signs, posts, sign hardware, and supplies, mail boxes & posts Street name sign panels, posts, hardware Pavement marling paint (moved from 4470) Shop supplies - fastners, degreasers, etc Graffitti remover 22,750 22,750 22,750 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 8,000 500 8,000 500 8,000 500 8,000 500 Contract pavement marking (Ramsey Co)(moved from 4470) Asset management software annual maintenance 8,500 8,500 8,500 8,500 3100 Telephone 230 230 230 230 Cellphone (2.5% of $8,000)($9,200) 230 230 230 230 3250 Electricity - traffic signals 3,000 3,000 3,000 3,000 Electricity for traffic signals 3,000 3,000 3,000 3,000 3630 Training & conferences 20 20 20 20 Hearing teSURTN trainging (.4@$50) 20 20 20 20 5130 Repairs, equipment 500 1 500 1 500 1 500 1 Traffic signal repairs & maintenance 500 1 500 1 500 1 500 35,595 35,595 35,595 35,595 -4.69% 0.00% 0.00% 0.00% 10 yr avg 10 yr avg 10 yr avg 22,390 25,128 27,891 Grand Total all PW Departments 319,569 344,026 345,106 341,723 1.55% 7.65% 0.31% -0.98% 42 2022 Budget Summary Y-T-D 2018 2019 2020 2021 11/30/2020 2022 Change from 2020 Actual Actual Actual BudEet Actual Request Dollar Percent Convention & Visitor's Bureau (100-4653) Contractual services 3045 N Metro Convention Bureau 73,260 65,455 29,314 47,500 47,500 - 0.00% Total contractual services 73,260 65,455 29,314 47,500 - 47,500 - 0.00% Total Convention & Visitor's Bureau 73,260 65,455 29,314 47,500 - 47,500 - 0.00% Miscellaneous (100 - 4700): Personnel services 0300 Social security 158 144 74 - - - 0.00% 0321 PERA 280 287 395 - - - 0.00% 0400 Group insurance 408 377 383 - - - 0.00% 0750 Fitness program 2,920 2,854 2,722 6,500 6,500 - 0.00% Total personnel services 3,766 3,662 3,574 6,500 - 6,500 - 0.00% Contractual services 3065 Family & youth social services 20,748 35,329 22,054 51,656 53,206 1,550 3.00% 3900 Family & youth social services - - 35,000 - - - 0.00% Total contractual services 20,748 35,329 57,054 51,656 - 53,206 1,550 3.00% Miscellaneous 9100 Contingency - - - - - 0.00% 9900 Transfers - EDA 50,000 50,000 50,000 50,000 - 50,000 - 0.00% 9900 Transfers - Vehicle & Equip. Funi 300,000 325,000 299,000 299,000 - 300,000 1,000 0.33% 9900 Transfers - Special Projects 100,000 125,000 475,000 75,000 - 75,000 - 0.00% 9900 Community Center 190,000 190,000 550,000 350,000 - 350,000 - 0.00% Total miscellaneous 640,000 690,000 1,374,000 774,000 - 775,000 1,000 0.13% 0.00% Total miscellaneous 664,514 728,991 1,434,628 832,156 - 834,706 2,550 0.31% Debt Service (100 - 4750): Debt Service ESP 8011 Lease payable 18,886 19,459 157,885 - - - 0.00% 8021 Interest 5,609 5,036 8,583 - - - 0.00% Total debt service 24,495 24,495 166,468 - - - - 0.00% 43 Fund: 100 Department: 4653 Convention & Visitor's Bureau Account Description 2019 2020 2021 2022 Description 3045 N Metro Convention Bureau 61,750 64,600 47,500 47,500 Payment of 95% of hotel/motel tax collections to (3% tax on gross receipts) support the promotion of tourism. (City retains 5% for administration) 61,750 64,600 47,500 47,500 Fund: 100 Department: 4700 Account Description 2019 Miscellaneous 2020 2021 2022 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 21,329 5,000 22,779 14,000 26,656 25,000 28,206 25,000 Northeast Youth and Family Services (NYFS)(2.8% - 2019)(6.8% for 2020) NYFS Mental health case management (assist police) 26,329 1 36,779 51,656 53,206 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 286,000 299,000 299,000 300,000 Transfer to Vehicle & Equipment Fund 286,000 299,000 299,000 300,000 9990 Community Center 190,000 200,000 350,000 350,000 Subsidy for Community Center and Park & Rec operating costs 190,000 200,000 350,000 350,000 Total Transfers 601,000 624,000 774,000 775,000 633,829 667,279 832,156 834,706 Fund: 100 Department: 4750 Debt Service Account Description 2019 2020 2021 2022 Description 8011 8021 Lease payable Interest 19,459 20,049 - - Lease payable Energy Savings Program (matures 2-23-27) 5,036 4,446 - Interest 24,495 24,495 44 THIS PAGE LEFT BLANK INTENTIONALLY 45 CITY OF MOUNDS VIEW, MINNESOTA Special Revenue Funds 2022 Budgets Combining Statement of Revenues and Expenditures and Net Changes in Fund Balances Cable Community Lakeside Recycling TIF TIF TV Forfeiture EDA Center Park Grant District #5 District #6 Total 2022 2021 Revenues: Taxes 116,000 - 100,000 - - - 1,829,694 81,491 2,127,185 2,085,711 Intergovernmental: County grants - - - - - 32,631 - - 32,631 31,539 Other local govt. - - 23,000 - 23,000 23,000 Charges for services: Culture and recreation - 421,000 - 421,000 330,100 Miscellaneous: Fines - 2,000 - - 2,000 2,000 Investment income - - 300 25 - 1,500 200 2,025 2,025 Other - - - - 500 - - - 500 500 Total revenues 116,000 2,000 100,000 421,300 23,525 32,631 1,831,194 81,691 2,608,341 2,474,875 Expenditures: Public safety Supplies - 4,200 - - - - - - 4,200 7,900 Contractual services - 500 - 500 500 Sanitation Personal services - - 16,284 16,284 14,908 Supplies - 500 500 500 Contractual services - 15,847 15,847 16,131 Culture and recreation: Personal services 58,493 538,973 4,215 - 601,681 544,399 Supplies 2,710 28,570 2,500 - 33,780 27,070 Contractual services 54,603 - 263,323 16,810 - 334,736 258,606 Economic development Personal services - - 156,168 - - - 156,168 149,694 Supplies - - 350 - - 350 350 Contractual services - - 62,733 - - 1,726,541 73,954 1,863,228 1,799,454 Capital outlay - - 30,000 - - - - - 30,000 30,000 Total expenditures 115,806 4,700 249,251 830,866 23,525 32,631 1,726,541 73,954 3,057,274 2,849,512 Surplus of revenues over (under) expenditures 194 (2,700) (149,251) (409,566) - 0 104,653 7,737 (448,933) (374,637) Other financing sources (uses) Transfers in - 149,633 350,000 - - - - 499,633 496,679 Transfers out - - - - - (91,484) (8,149) (99,633) (96,679) Total other financing sources (uses) - - 149,633 350,000 - (91,484) (8,149) 400,000 400,000 Net change in fund balance 194 (2,700) 382 (59,566) - 0 13,169 (412) (48,933) 25,363 Fund balance, January 1: 159,936 2,852 1,240,612 317,951 17,430 30,609 907,087 35,596 2,712,073 2,686,710 Fund balance, December 31 160,130 152 1,240,994 258,385 17,430 30,610 920,256 35,184 2,663,140 2,712,073 46 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Budget Request Dollar Percent Cable TV (Fund 210): Revenues 3180 Franchise fee 122,269 117,649 116,730 112,000 116,000 4,000 3.57% Total revenue 122,269 117,649 116,730 112,000 116,000 4,000 3.57% Operating expenses Operations (4350) Personnel services 0100 Salaries, regular 68,888 68,926 37,650 39,309 42,784 3,475 8.84% 0110 Salaries, over -time - 1,096 - - - - 0.00% 0300 Social security 4,941 3,865 2,532 3,007 3,272 265 8.81% 0321 PERA 4,721 4,080 2,853 2,948 3,208 260 8.82% 0400 Group insurance 12,743 10,424 7,485 7,679 8,878 1,199 15.61% 0500 Workers compensation 170 218 255 328 351 23 7.01% Total personnel services 91,463 88,609 50,775 53,271 58,493 5,222 9.80% Materials & supplies 1230 Supplies, equipment 12,261 978 - 2,000 2,000 - 0.00% 1600 Supplies, operating - 5 - 1,000 710 (290)-29.00% Total materials & supplies 12,261 983 - 3,000 2,710 (290) -9.67% Contractual services 3030 Other professional services 8,023 9,258 27,103 22,500 22,500 - 0.00% 3630 Training & conferences 882 199 - 300 - (300) -100.00% 3800 Mileage & parking 8 3 - 25 - (25) -100.00% 3900 Grants & subsidies 29,361 29,256 29,494 31,167 30,603 (564) -1.81% 5130 Repairs, equipment - - - 1,500 1,500 - 0.00% Total contractual services 38,274 38,716 56,597 55,492 54,603 (889) -1.60% Capital 7030 Equipment 76,632 107,921 - - - - 0.00% Total capital outlays 76,632 107,921 - - - - 0.00% Total expenditures 218,630 236,229 107,372 111,763 115,806 4,043 3.62% Net change in fund balance (96,361) (118,580) 9,358 237 194 (43)-18.14% Fund balance, beginning year 365,282 268,921 150,341 159,699 159,936 237 0.15% Fund balance, end of year $ 268,921 $ 150,341 $ 159,699 $ 159,936 $ 160,130 $ 194 0.12% 50,535 39,699 56,597 58,492 57,313 47 Fund: 210 Cable TV Revenues Account Description 2019 2020 2021 2022 Description 3180 Franchise fee revenue 128,000 116,000 112,000 116,000 Estimated collections 128,000 116,000 112,000 116,000 Fund: 210 Department: 4350 Operations 1230 Supplies, equipment < $5000 2,500 2,000 2,000 2,000 Equipment costing less than $5,000 per item 2,500 2,000 2,000 2,000 1600 Supplies, operating 400 850 200 800 200 800 200 510 Recording media - tapes, DVD's Batteries, cables, bulbs, tapes, misc 1,250 1,000 1,000 710 3030 Other professional services 6,200 6,000 12,200 6,500 6,500 6,500 Web streaming meetings $501 per month. (current $1502/qtr) Broadcast and Video Production support 23,000 16,000 16,000 29,500 22,500 22,500 3630 Training & conferences 350 650 500 - 300 - Attendance at local training ACM National Conference (free registration)(1/2 paid by Little Canada) 1,000 500 300 3800 Mileage & parking 50 50 25 Mileage 50 50 25 3900 Grants & subsidies 30,242 30,259 31,167 30,603 Share of costs of North Suburban Cable Commission 30,242 30,259 31,167 30,603 5130 Repairs, equipment 2,000 1,500 1,500 1,500 Repair and maintenance of equipment 2,000 1,500 1,500 1,500 7030 Capital, equipment > $5000 - 105,000 - - - Supplemental duct work/air conditioning Control room/Council chambers replacement 105,000 154,242 64,809 58,492 57,313 -40.98%-57.98% -9.75% -2.02% .N 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Budget Request Dollar Percent Forfeiture (Fund 225): Revenues 3514 Forfeitures 16,731 20,312 22,816 2,000 2,000 0.00% Total revenue 16,731 20,312 22,816 2,000 2,000 - 0.00% Operating expenses (4200): Materials & supplies 1230 Supplies, equipment 7,638 2,305 13,961 7,700 4,000 (3,700) -48.05% 1600 Supplies, operating 785 280 6,900 200 200 - 0.00% Total materials & supplies 8,423 2,585 20,861 7,900 4,200 (3,700) -46.84% Contractual services 3030 Other professional services 7,846 8,313 5,391 500 500 - 0.00% Total contractual services 7,846 8,313 5,391 500 500 - 0.00% Capital 7030 Equipment - - - - - - 0.00% Total capital outlays - - - - - - 0.00% Total expenses 16,269 10,898 26,252 8,400 4,700 (3,700) -44.05% Net change in fund balance 462 9,414 (3,436) (6,400) (2,700) 3,700 -57.81 % Fund balance, beginning year 2,812 3,274 12,688 9,252 2,852 (6,400) -69.17% Fund balance, end of year 3,274 12,688 9,252 2,852 152 (2,700) -94.67% 49 Fund: 225 Forfeiture Revenues Account Description 2019 2020 2021 2022 1 Description 3514 Forfeitures 2,000 2,000 2,000 2,000 1000 2,000 Sale of forfeited vehicles at auction. 1000 2,000 Fund: 225 Department: 4200 Operations NEL- 1230 Supplies - equipment < $5000 7,600 (2) radios 5,000 (2) light bars 500 Crime scene kit - - 6,000 Evidence tracking system (barcode) 2,500 - 4,000 Miscellaneous vehicle equipment - - - Portable Breath Tester (PBT) 1,200 Replacement Glock pistols (2) 2,500 12,600 7,700 4,000 1600 Supplies - operating 200 200 200 200 Supplies to prepare vehicles for auction. (tows, title fees, batteries) 200 200 200 200 3030 Other professional services 500 500 500 500 Share of auction costs. 500 500 500 500 7030 Equipment > $5000 - Camera 3,200 13,300 8,400 4,700 -54.93% 315.63%-36.84%-44.05% 411 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Budget Request Dollar Percent EDA (Fund 230): Revenues 3101 Tax collections 100,215 93,170 100,774 100,000 100,000 - 0.00% 3610 Investment income - - - - - - 0.00% 3615 Interest received on notes 558 309 45 - - - 0.00% 3680 Otherrevenue - 1,654 - - - - 0.00% 3972 Transfers 133,543 135,563 839,036 146,679 149,633 2,954 2.01% Total revenue 234,316 230,696 939,855 246,679 249,633 2,954 1.20% Operating expenses Housing and Economic Development (4650): Personnel services 0100 Salaries, regular 60,860 91,694 114,465 116,178 119,753 3,575 3.08% 0150 Salaries, part-time 21,245 12,719 - - - - 0.00% 0300 Social security 5,721 6,884 7,694 8,888 9,161 273 3.07% 0321 PERA 6,018 7,676 8,560 8,714 8,981 267 3.06% 0400 Group insurance 13,822 14,249 14,616 15,073 17,426 2,353 15.61% 0500 Workers compensation 362 569 666 841 847 6 0.71% Total personnel services 108,028 133,791 146,001 149,694 156,168 6,474 4.32% Materials & supplies 1600 Supplies, operating 45 - 751 200 200 - 0.00% 2100 Book & periodicals 139 - - 150 150 - 0.00% Total materials & supplies 184 - 751 350 350 - 0.00% Contractual services 3030 Other professional services 20,186 33,461 30,563 32,472 32,472 - 0.00% 3100 Telephone - 550 600 600 600 - 0.00% 3420 Advertisements 780 780 - 1,500 1,500 - 0.00% 3430 Printing - - - 500 500 - 0.00% 3610 Memberships 720 940 110 1,010 950 (60) -5.94% 3630 Training & conferences 2,407 2,647 351 3,430 3,490 60 1.75% 3800 Mileage 156 1,790 247 350 350 - 0.00% 4750 Real estate taxes - 19,993 - - - - 0.00% 4800 Insurance 447 475 754 649 649 - 0.00% 5210 Housing improvement 2,341 2,570 1,524 23,000 22,222 (778) -3.38% Total contractual services 27,037 63,206 34,149 63,511 62,733 (778) -1.22% Capital outlays 9300 Business subsidies - - - 30,000 30,000 - 0.00% Total expenditures 135,249 196,997 180,901 243,555 249,251 5,696 2.34% Net change in fund balance 99,067 33,699 758,954 3,124 382 (2,742) -87.77% Fund balance, beginning year 345,768 444,835 478,534 1,237,488 1,240,612 3,124 0.25% Adj for land held for resale Fund balance, end of year 444,835 478,534 1,237,488 1,240,612 1,240,994 382 0.03% 51 Fund: 230 FDA Revenues Account Description 2019 2020 2021 2022 Description 3101 Tax revenue 100,000 100,000 100,000 100,000 EDA/HRA Levy 100,000 100,000 100,000 100,000 3972 Transfers 85,563 - 50,000 88,036 - 50,000 701,000 89,690 6,989 50,000 91,484 8,149 50,000 - Transfers from TIF 5 Transfers from TIF 6 Transfers from General Fund Transfer from Street Improvement 135,563 1 839,036 146,679 1 149,633 235.563 939,036 246,679 249.633 Fund: 230 Department: 4650 1600 Supplies, operating 400 360 200 Housing and Economic Development 200 Misc office supplies 200 400 360 200 2100 Books & periodicals 200 200 150 150 Misc. reports & periodicals (Finance & Commerce) 200 200 150 150 3030 Other professional services 4,000 5,000 14,500 1,703 4,500 7,000 4,000 5,000 14,500 1,738 4,500 1,000 4,000 5,000 14,500 1,772 4,500 2,700 4,000 5,000 14,500 1,772 4,500 1 2,700 Legal fees for development reviews Financial consultant fees (Ehlers) Special project consultant fees 5% of audit (22-35,440, 23-36,145, 24-36,870, 25-37,605, 26-38,360) Loan Program and Energy Audit Consultant (CEE) Marketing Consultant fees 36,703 30,738 32,472 32,472 3100 Telephone 600 600 600 Cell phone - 600 600 600 3420 Advertising 1,500 1,500 1,500 1,500 Targeted advertisements. 1,500 1,500 1,500 1,500 3430 Printing 400 100 400 100 400 100 400 100 Property ad printing Misc printing 500 500 500 500 3610 Mcmbcrships 400 250 - 60 400 250 - 60 400 250 300 60 400 250 300 - Economic Development Assoc of MN (EDAM) Twin Cities North Chamber of Commerce dues Mn Real Estate Exchangers (MREE) MN Assoc. of Govt. Communicators (MAGC) 710 710 1,010 950 3630 Training & conferences 535 275 600 2,000 535 275 600 2,007 535 275 600 2,020 535 275 1,200 1,480 IEDC Conference Minneapolis Ehlers Finance Seminar EDAM spring/summer conferences Other miscellaneous training 3,410 9,417 3,430 3,490 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 23,000 23,000 22,222 Housing Improvement programs 50,000 23,000 23,000 22,222 5220 Highway 10 redevelopment 28,000 - Trailways & lighting in highway corridor, Gateway Signage 28,000 - - - 9300 Business loans/subsidies/grants 50,000 25,000 30 000 30,000 Business improvement partnership loans/subsidies/grants 50,000 25,000 30,000 30,000 172,422 93,024 93,861 93,083 -0.04%-46.05% 0.90% -0.83% 52 THIS PAGE LEFT BLANK INTENTIONALLY 53 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Budget Request Dollar Percent Community Center (Fund 252): Building overhead (4350) Building overhead revenues 191,726 193,449 553,459 150,300 300 - 0.00% Building overhead expenditures 53,119 53,119 360,996 - - - 0.00% Net Building Overhead Operations 138,607 140,330 192,463 150,300 300 - 0.00% Banquet Center (4730): Banquet revenues 111,320 117,585 18,577 64,500 104,500 40,000 62.02% Banquet Center expenditures 119,095 126,953 90,694 143,047 160,535 17,488 12.23% Net Banquet Center (7,775) (9,368) (72,117) (78,547) (56,035) 22,512 -28.66% Recreation (4732): Recreation revenues 114,986 114,155 24,926 319,200 516,500 197,300 61.81% Recreation expenditures 247,527 279,654 213,172 511,477 626,139 114,662 22.42% Net Recreation (132,541) (165,499) (188,246) (192,277) (109,639) 82,638 -42.98% Office/Chamber space (4734): Office/Chamber revenues 8,196 8,196 5,053 14,400 18,000 3,600 25.00% Office/Chamber expenditures 5,670 5,470 5,388 6,386 6,981 93 1.45% Net Office/RISE space 2,526 2,726 (335) 8,014 11,019 3,507 43.76% Creative Kids Child Care Center (4736): Creative Kids revenues 107,183 132,000 132,000 132,000 132,000 - 0.00% Creative Kids expenditures 34,993 29,800 27,817 33,875 37,211 3,336 9.85% Net Creative Kids 72,190 102,200 104,183 98,125 94,789 (3,336) -3.40% Total revenue 533,411 565,385 734,015 680,400 771,300 240,900 35.41% Total expenditures 460,404 494,996 698,067 694,785 830,866 135,578 19.51% Net change in fund balance 73,007 70,389 35,948 (14,385) (59,566) 105,322 -732.16% Fund balance, beginning year 152,992 225,999 296,388 332,336 317,951 (14,385) -4.33% Fund balance, end of year 225,999 296,388 332,336 317,951 258,385 (59,566) -18.73% (continued) 54 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Budget Request Dollar Percent Community Center (continued): Building overhead (4350) Building revenues: 3610 Investment income 600 3,370 2,755 300 300 - 0.00% 3680 Miscellaneous 1,126 79 704 - - - 0.00% 3972 Transfers 190,000 190,000 550,000 150,000 - (150,000)-100.00% Total building overhead revenue; 191,726 193,449 553,459 150,300 300 - 0.00% Operating expenses Personnel services 0100 Salaries, regular 0110 Salaries,overtime 0300 Social Security 0321 PERA 0400 Group insurance 0500 Workers compensation 999 Allocation of salaries Total personnel services 32,131 22,102 43,948 49,190 51,669 2,479 5.04% 1,556 626 357 1,203 1,234 31 2.58% 2,530 1,674 3,365 3,855 4,046 191 4.95% 2,351 1,706 3,195 3,780 3,968 188 4.97% 879 6,779 142 11,574 12,600 1,026 8.86% 1,287 2,183 2,397 2,874 2,889 15 0.52% (40,734) (35,070) (53,404) (72,476) (76,406) (3,930) 5.42% 0.00% Materials & supplies 1210 Supplies, buildings & grounds 3,570 3,165 901 1,500 1,500 0.00% 1230 Supplies, equipment 1,389 4,708 294 4,300 800 (3,500) -81.40% 1600 Supplies, operating 9,023 7,680 7,855 7,800 9,300 1,500 19.23% 2400 Uniforms 448 578 801 470 470 - 0.00% 2410 Mats & towels 1,625 2,494 1,640 2,500 2,500 - 0.00% 2999 Allocation of supplies (16,055) (18,625) (11,491) (16,570) (14,570) 2,000 -12.07% Total materials & supplies - - - - - - 0.00% Contractual services 3030 Other professional services 20,777 15,384 11,193 16,900 16,900 0.00% 3100 Telephone 4,320 4,755 5,163 3,500 3,500 0.00% 3200 Water & sewer 8,441 6,977 10,611 8,600 8,600 0.00% 3210 Electricity 47,515 46,201 41,922 47,000 47,000 0.00% 3220 Natural gas 15,451 16,299 13,155 17,000 17,000 - 0.00% 3530 Refuse collection 3,720 3,480 4,376 4,576 4,720 144 3.15% 3630 Training & conferences - - - - 1,000 1,000 #DIV/0! 3999 Allocation of utilities & Ins (100,224) (93,095) (86,420) (97,576) (98,720) (1,144) 1.17% 4010 Rental, equipment 130 - - 0.00% 4800 Insurance (liability) - - - - 8,200 8,200 #DIV/0! 5110 Repairs, building & grounds 15,790 13,200 11,917 9,770 9,770 - 0.00% 5130 Repairs, equipment 17,487 24,205 18,121 19,991 28,547 8,556 42.80% 5999 Allocation of repairs (33,407) (37,406) (30,038) (29,761) (46,517) (16,756) 56.30% Total contractual services 0.00% Capital 7030 Equipment - 0.00% Total capital outlays - - - - 0.00% Debt service 8011 Lease payable -principal 40,957 42,198 342,385 - - 0.00% 8021 Lease payable - interest 12,162 10,921 18,611 - - 0.00% Total debt service 53,119 53,119 360,996 - - 0.00% Total Building overhead exp 53,119 53,119 360,996 - - - 0.00% Total Building Overhead Net 138,607 140,330 192,463 150,300 300 - 0.00% 143,907 159,807 (continued) 55 Fund: 252 Department: 4350 Community Center Building Overhead Account Description 2019 2020 2021 Expenditures 2022 Description 1210 Supplies, bldgs & grounds 1,150 1,282 1,500 1,500 Lights, signs, fertilizer 1,150 1,282 1,500 1,500 1230 Supplies, equipment < $5000 800 3,500 800 3,500 800 3,500 800 - Small tools & equipment Drinking fountains 4,300 4,300 4,300 800 1600 Supplies, operating 7,800 7,800 7,800 9,300 Batteries, soap, paper towels, cleaning supplies for bathrooms Paper cups, plates, etc. for lounge & customer service events 7,800 7,800 7,800 9,300 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,500 250 1,500 250 2,250 250 2,250 250 Floor mats and cleaning towels to provide better protection of carpets Special events 1,750 1,750 2,500 2,500 3030 Other professional services 800 200 11,000 1,750 600 500 14,500 1,300 600 500 14,500 1,300 600 500 14,500 1,300 Backflow inspection, alarm inspection, Sprinkler inspections Custodial services: 12 months $xxx Commercial carpet cleaning service (twice annually) 13,750 16,900 16,900 16,900 3100 Telephone & internet 3,200 3,200 3,500 3,500 Office & customer phones, interact, maintenance agreements, & repairs 3,200 3,200 3,500 3,500 3200 Water & Wastewater 9,000 8,600 8,600 8,600 Water & sewer charges for community center 9,000 8,600 8,600 8,600 3210 Electricity 40,000 47,000 47,000 47,000 Estimated electrice charges 40,000 47,000 47,000 47,000 3220 Natural gas 15,000 15,000 17,000 17,000 Estimated natural gas charges 15,000 15,000 17,000 17,000 3530 Refuse collection 3,804 400 3,804 400 4,176 400 4,320 400 Dumpsters $360 x 12 months Extra garbage pick-up charges 4,204 4,204 4,576 4,720 3630 Training - - - 1,000 Misc training 1,000 4800 Bonding & insurance 8,200 Insurance & bonding cost. 8,200 5110 Repairs, building & grounds 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 1,200 4,500 770 1,500 1,300 500 Repair floor tiles Exterior/Interior building maintenance Exterminator: 12 months X 64.02 Fire alarm system service Parking lot & grounds maintenance Security system service 9,770 9,770 9,770 9,770 5130 Repairs, equipment 11,500 - 3,000 1,500 11,991 - 5,000 1,500 11,991 - 6,000 2,000 11,991 8,556 6,000 2,000 HVAC system maintenance contract Genesis Air bulbs (HVAC) HVAC repairs Plumbing, electrical, & misc. interior maintenance 16,000 1 18,491 1 19,991 28,547 8011 8021 Lease payable (ESP) Interest 42,199 10,921 43,478 9,642 Lease payable for energy savings program (matures 2-23-27) 53,120 53,120 1 - -4 179,514 191,887 143,907 159,807 12.31% 6.89%-25.00% 11.05% 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Budget Request Dollar Percent Community Center (continued): Banquet Center (4730): Banquet Revenues 3634 Equipment rental 4,956 4,756 404 4,500 4,500 - 0.00% 3645 Rental - banquet facility 106,364 112,829 18,173 60,000 100,000 40,000 66.67% 0.00% Total banquet center revenue 111,320 117,585 18,577 64,500 104,500 40,000 62.02% Banquet Expenditures Personnel services 0100 Salaries, regular 370 45,362 50,308 4,946 10.90% 0110 Salaries, overtime 27 - - - 0.00% 0150 Salaries, part time regular pay 48 7,280 8,320 1,040 14.29% 0300 Social Security - - 4,027 4,484 457 11.35% 0321 PERA - 3,949 4,397 448 11.34% 0400 Group insurance - 11,694 13,512 1,818 15.55% 0500 Workers compensation - 440 481 41 9.32% 0999 Allocation of salaries 8,147 7,014 10,681 14,495 15,281 786 5.42% Total personnel services 8,147 7,014 11,126 87,247 96,783 9,536 10.93% 81,502 Materials & supplies 1210 Supplies, buildings & grounds - - 2 - - - 0.00% 1230 Supplies, equipment 1,570 767 1,509 3,000 5,000 2,000 66.67% 1600 Supplies, operating - - - - - - 0.00% 2999 Allocation of supplies 4,459 5,215 3,217 4,640 4,080 (560) -12.08% Total materials & supplies 6,029 5,982 4,728 7,640 9,080 1,440 18.84% Contractual services 3030 Other professional services 66,787 72,511 38,463 5,636 5,636 - 0.00% 3100 Telephone - - - - 500 500 #DIV/0! 3420 Advertising ill 438 500 1,500 1,000 200.00% 3430 Printing - - - 250 250 - 0.00% 3999 Allocation of utilities 26,055 24,456 22,889 27,041 27,362 321 1.19% 4800 Bonding & insurance 1,449 1,536 1,763 2,100 2,100 - 0.00% 5110 Repairs, building & grounds 1,235 3,431 1,628 2,700 2,700 0.00% 5130 Repairs, equipment 39 1,439 1,248 1,600 1,600 - 0.00% 5999 Allocation of repairs 9,354 10,473 8,411 8,333 13,025 4,692 56.30% Total contractual services 104,919 113,957 74,840 48,160 54,672 6,512 13.52% 55,800 63,752 Total banquet center exp 119,095 126,953 90,694 143,047 160,535 17,488 12.23% Total Banquet Center net (7,775) (9,368) (72,117) (78,547) (56,035) 22,512-28.66% (continued) 57 Fund: 252 Community Center - 4730 Banquet Center Account Description 2019 2020 2021 Expenditures 2022 Description 1230 Supplies, equipment 2,500 - 2,000 2,500 - 2,000 3,000 - 3,000 2,000 - Tables, mirrors, microphones, projectors, etc. for Banquet Room Override upgrade to AudioNisual system Ice machine 4,500 4,500 3,000 5,000 2999 Allocation of supplies 4,332 4,369 4,640 4,080 28% Allocation from overall building support 4,332 4,369 4,640 4,080 3030 Other professional services 852 2,500 60,896 1,750 12,000 500 869 2,500 48,485 1,750 12,000 500 886 2,500 - 1,750 - 500 886 2,500 - 1,750 - 1 500 2.5% of audit (22-35,440, 23-36,145, 24-36,870, 25-37,605, 26-38,360) Miscellaneous professional services (linen service) Banquet facility management (16% of 3l l,512) Carpet cleaning 2 x year Extra staff for large events Legal costs 78,498 66,104 5,636 5,636 3100 Telephone/Internet - 500 Cell phone - - - 500 3420 Advertising & marketing 500 500 500 1,500 Website and traditional advertising, marketing 500 500 500 1,500 3430 Printing 250 250 250 250 Brochures, flyers, etc. 250 250 250 250 3999 Allocation of utilities 23,587 25,547 27,041 27,362 28% Allocation from overall building utilities 23,587 25,547 27,041 27,362 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 1,200 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 2,700 2,700 2,700 5130 Repairs, equipment 1,600 1,600 1,600 1,600 Repairs to kitchen, audio system, and other banquette equipment 1,600 1,600 1,600 1,600 5999 Allocation of repairs 7,216 7,913 8,333 13,025 28% Allocation from overall building repairs 7,216 7,913 8,333 13,025 125,283 115,583 55,800 63,753 7.53% -7.74%-51.72% 14.25% 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Budget Request Dollar Percent Community Center (continued): Recreation (4732): Recreation Revenues 3405 Recreation profit 68,292 53,141 - - - 0.00% 3406 Recreation program fees - - - 101,000 121,000 20,000 19.80% 3660 Gym & meeting room rental 19,868 33,844 22,704 10,000 25,000 15,000 150.00% 3661 Open gym participant fees 24,200 26,429 1,765 7,000 20,000 13,000 185.71% 3679 Commissions - vending 2,626 741 457 1,200 500 (700) -58.33% 3972 Transfers - - - 200,000 350,000 150,000 75.00% Total Recration revenues 114,986 114,155 24,926 319,200 516,500 197,300 61.81% Recreation Expenditures Personnel services 0100 Salaries, regular 1,684 129,347 137,834 8,487 6.56% 0110 Salaries,overtime - - - - 0.00% 0150 Salaries,part-time - 145,600 166,400 20,800 14.29% 0300 Social security 123 21,034 23,274 2,240 10.65% 0321 Pensions 218 20,621 22,817 2,196 10.65% 0400 Group insurance 22,788 26,208 3,420 15.01% 0500 Workers compensation 2,295 4,532 2,237 97.47% 0999 Allocation of salaries 28,205 24,198 36,849 50,008 52,720 2,712 5.42% Total personnel services 28,205 24,198 38,874 391,693 433,785 42,092 10.75% 381,065 Materials & supplies 1230 Supplies, equipment 38 - 1,466 2,000 9,000 7,000 350.00% 2999 Allocation of supplies 7,962 9,313 5,746 8,285 7,285 (1,000) -12.07% Total materials & supplies 8,000 9,313 7,212 10,285 16,285 6,000 58.34% Contractual services 3030 Other professional services 120,555 151,079 101,009 2,658 58,528 55,870 2101.96% 3100 Telephone - - - - 1,000 1,000 #DIV/0! 3430 Printing 3,492 2,474 1,003 7,200 7,200 - 0.00% 3999 Allocation of utilities 55,038 50,579 46,511 49,838 50,410 572 1.15% 4010 Rental, equipment 9,367 15,035 - 20,297 20,297 - 0.00% 4800 Bonding & insurance 2,776 2,944 3,380 4,025 4,025 0.00% 5110 Repairs, building & grounds 3,390 5,329 164 5,000 5,000 0.00% 5130 Repairs, equipment - - - 6,350 6,350 - 0.00% 5999 Allocation of repairs 16,704 18,703 15,019 14,131 23,259 9,128 64.59% Total contractual services 211,322 246,143 167,086 109,499 176,069 66,570 60.79% 119,784 192,354 Total Recreation exp 247,527 279,654 213,172 511,477 626,139 114,662 22.42% Total Recreation net (132,541) (165,499) (188,246) (192,277) (109,639) 82,638 -42.98% (continued) Wel Fund: 252 Community Center - 4732 Recreation Expenditures Account Description 2019 2020 2021 2022 Description 1230 Supplies, equipment 2,000 2,000 2,000 - Miscellaneous - - - 2,500 Explore More supplies 1,000 Fitness equipment 3,500 Youth sports 1,000 Senior programs 1,000 Teen/Enrichment 2,000 2,000 2,000 9,000 2999 Allocation of supplies 7,735 7,801 8,285 7,285 50% Allocation from overall building support 7,735 7,801 8,285 7,285 3030 Other professional services 114,542 127,271 - - YMCA mgt. contract (other half of fee in recreation)(42% of $311,512) - - 30,000 Partner payments - Happy Feet Dance, Pure Intennsity Athletics, Hall of Fame, Elementary track use, Explore More field trips & transportation, and Senior trips & transportation 25,870 Rec Software (2nd yr $9,933) 5% inflator after yr 2 (2024) - 23,000 - Senior Program Coordinator 2,935 2,935 - Copier ($2,100) Computer ($835) per agreement 2,555 2,606 2,658 2,658 7.5% of audit (22-35,440, 23-36,145, 24-36,870, 25-37,605, 26-38,360) 120,032 155,812 2,658 58,528 3100 Telephone - 1,000 Cell phones (2) - - - 1,000 3430 Printing 7,200 7,200 7,200 7,200 50% of the cost of printing and mailing the Mounds View Matters newsletter 7,200 7,200 7,200 7,200 3999 Allocation of utilities 43,537 48,412 49,838 50,410 50% Allocation from overall building utilities 43,537 48,412 49,838 50,410 4010 Rental, equipment 250 250 250 250 Scissor lift rental 20,047 20,047 20,047 20,047 Fitness equipment 20,297 20,297 20,297 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 1,500 1,500 1,500 1,500 General building repairs 1,000 1,000 1,000 1,000 Interior improvements 3,500 3,500 2,500 2,500 Gym floor resurfacing & maintenance 6,000 6,000 5,000 5,000 5130 Repairs, equipment 500 500 500 500 Registration system support - - 4,000 4,000 IT support - - 1,000 1,000 Copier annual maintenance 850 850 850 850 Repairs to other equipment 1,350 1,350 6,350 6,350 5999 Allocation of repairs 12,885 14,131 14,131 23,259 50% Allocation from overall building repairs 12,885 14,131 14,131 23,259 225,061 267,028 119,784 192,354 16.80% 18.65%-55.14% 60.58% THIS PAGE LEFT BLANK INTENTIONALLY 61 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Budget Request Dollar Percent Office space (RISE)(4734): Office space revenues 3633 Lease - Office/Chamber space 8,196 8,196 5,053 14,400 18,000 3,600 25.00% Total office space revenues 8,196 8,196 5,053 14,400 18,000 3,600 25.00% Office space expenditures Personnel services 0999 Allocation of salaries 1,226 1,052 1,602 2,174 2,292 118 5.44% Total personnel services 1,226 1,052 1,602 2,174 2,292 118 5.44% Materials & supplies 2999 Allocation of supplies 478 559 345 497 437 (60) -12.05% Total materials & supplies 478 559 345 497 437 (60) -12.05% Contractual services 3999 Allocation of utilities 2,964 2,737 2,540 2,822 2,857 35 1.23% 5999 Allocation of repairs 1,002 1,122 901 893 1,396 503 56.27% Total contractual services 3,966 3,859 3,441 3,715 4,252 35 0.93% 0 Total office space exp 5,670 5,470 5,388 6,386 6,981 93 1.45% Total office space net 2,526 2,726 (335) 8,014 11,019 3,507 43.76% (continued) 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Budget Request Dollar Percent Creative Kids Child Care (4736): Child Care Revenues 3632 Lease - Child Care 107,183 132,000 132,000 132,000 132,000 - 0.00% Lease ends 7-31-23 Total child care revenues 107,183 132,000 132,000 132,000 132,000 - 0.00% Child Care Ed Expenditures (19%) Personnel services 0999 Allocation of salaries 3,259 2,806 4,272 5,798 6,112 314 5.42% Total personnel services 3,259 2,806 4,272 5,798 6,112 314 5.42% Materials & supplies 1600 Supplies, operating - - - - - - 0.00% 2999 Allocation of supplies 3,050 3,539 2,183 3,148 2,768 (380) -12.06% Total materials & supplies 3,050 3,539 2,183 3,148 2,768 (380) -12.06% Contractual services 3999 Allocation of utilities 16,168 15,324 14,479 17,874 18,092 218 1.22% 4750 Taxes, licenses, & fees 5,203 - - - - - 0.00% 4800 Bonding & insurance 966 1,024 1,176 1,400 1,400 - 0.00% 5999 Allocation of repairs 6,347 7,107 5,707 5,655 8,838 3,183 56.29% Total contractual services 28,684 23,455 21,362 24,929 28,330 3,401 13.64% Total child care exp 34,993 29,800 27,817 33,875 37,211 3,336 9.85% Total child care net 72,190 102,200 104,183 98,125 94,789 (3,336) -3.40% 62 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Budget Request Dollar Percent Lakeside Park (Fund 255): Revenues 3370 Spring Lake Pk contribution 11,500 11,500 11,500 11,500 11,500 - 0.00% 3370 Mounds View contribution 11,500 11,500 11,500 11,500 11,500 - 0.00% 3610 Investment income 298 622 353 25 25 - 0.00% 3665 Park site permit 826 599 255 500 500 - 0.00% Total revenue 24,124 24,221 23,608 23,525 23,525 - 0.00% Operating expenses (4350): Personnel services 0150 Salaries, part-time 3,141 2,297 - 3,680 3,680 - 0.00% 0300 Social security 240 176 - 282 282 - 0.00% 0500 Workers compensation 153 156 - 253 253 - 0.00% Total personnel services 3,534 2,629 - 4,215 4,215 - 0.00% Materials & supplies 1210 Supplies, bldgs & grounds - 74 61 1,700 800 (900) -52.94% 1600 Supplies, operating 1,187 1,677 1,300 800 1,700 900 112.50% Total materials & supplies 1,187 1,751 1,361 2,500 2,500 - 0.00% Contractual services 3200 Water & sewer 3,223 2,480 4,126 2,400 2,400 - 0.00% 3210 Electricity 1,356 1,203 1,379 1,300 1,300 - 0.00% 3530 Refuse collection - - - 75 75 - 0.00% 4010 Equipment Contribution SLP 5,276 5,276 5,276 5,276 5,276 - 0.00% 4030 Satellites 359 380 327 550 550 - 0.00% 4800 Insurance 4,705 4,995 5,504 5,504 6,055 551 10.01% 5130 Repairs, equipment 4,796 2,879 - 1,705 1,154 (551) -32.32% Total contractual services 19.715 17.213 16.612 16.810 16.810 - 0.00% Total expenses 24,436 21,593 17,973 23,525 23,525 0.00% Net change in fund balance (312) 2,628 5,635 - - 0.00% Fund balance, beginning year 9,479 9,167 11,795 17,430 17,430 - 0.00% Fund balance, end of year 9,167 11,795 17,430 17,430 17,430 - 0.00% 19,310 19,310 63 Fund: 255 Lakeside Park Revenues Account Description 2019 2020 2021 2022 Description 3370 Contributions 11,500 11,500 11,500 11,500 Spring Lake Park contribution for half of cost for joint park 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 11,500 11,500 11,500 11,500 3610 Interest revenue 210 210 25 25 Estimated interest earnings at 0.35%. 210 1 210 25 25 3665 Park site rental 500 500 500 500 Rental of the park by groups or individuals 500 500 500 500 nd: 255 Department: 4350 1210 Supplies, bldgs & grounds Expenditures 1,700 1,700 1,700 800 Paper, sand, etc. 1,700 1,700 1,700 800 1600 Supplies, operating 800 800 800 1,700 Fertilizer & pesticides 800 800 800 1,700 3200 Water & sewer 2,400 2,400 2,400 2,400 Estimated water & sewer charges 21400 2,400 2,400 2,400 3210 Electricity 1,300 1,300 1,300 1,300 Estimated electric charges 1,300 1,300 1,300 1,300 3530 Refuse collection 75 75 75 75 Six months service 75 75 75 75 4010 Equipment, capital charge 4,800 4,800 5,276 5,276 Capital charge for usage of SLP city equipment 4,800 4,800 5,276 5,276 4030 Satellites 700 700 550 550 Five months service 700 700 1 550 550 4800 Insurance & bonds 4,800 4,800 5,504 6,055 Property & liability insumace 4,800 4,800 5,504 6,055 5130 Repairs, equipment 2,920 2,920 1,705 1,154 Repair of equipment at the park 2,920 2,920 1,705 1,154 19,495 19,495 19,310 19,310 0.50% 0.00% -0.95% 0.00% 64 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Budget Request Dollar Percent Recycling (Fund 290): Revenues 3360 Other County grants 21,885 31,059 24,110 31,539 32,631 1,092 3.46% 3610 Investment income - - - - - - 0.00% Total revenue 21,885 31,059 24,110 31,539 32,631 1,092 3.46% Operating expenses Operations (4420) Personnel services 0100 Salaries, regular 14,012 9,440 10,539 11,137 12,057 920 8.26% 0110 Salaries, overtime 174 195 - - - - 0.00% 0300 Social security 1,050 668 735 852 922 70 8.22% 0321 PERA 1,046 722 801 835 904 69 8.26% 0400 Group insurance 2,524 2,805 2,772 1,991 2,302 311 15.60% 0500 Workers compensation 60 63 70 93 99 6 6.45% Total personnel services 18,866 13,893 14,917 14,908 16,284 1,376 9.23% Materials & supplies 1600 Supplies, operating 1,276 37 500 500 - 0.00% Contractual services 3300 Postage 902 977 - 2,200 2,200 - 0.00% 3420 Advertisements - - - - - - 0.00% 3430 Printing 913 3,461 1,822 2,500 2,500 - 0.00% 3530 Refuse collection 6,018 6,028 5,695 11,431 11,147 (284) -2.48% Total contractual services 7,833 10,466 7,517 16,131 15,847 (284) -1.76% Total expenses 27,975 24,396 22,434 31,539 32,631 1,092 3.46% Net change in fund balance (6,090) 6,663 1,676 - 0 0 #DIV/0! Fund balance, beginning year 28,360 22,270 28,933 30,609 30,609 - 0.00% Fund balance, end of year 22,270 28,933 30,609 30,609 30,610 0 0.00% 16,631 16,347 65 Fund: 290 Recycling Gra Revenues Account Description 2019 2020 2021 2022 Description 3360 Other grants & aid 31,545 31,545 31,545 31,545 31,539 32,631 Estimated Ramsey County recycling grant 31,539 32,631 und: 290 Department: 4420 1600 Supplies, operatin 500 500 500 Expenditures 500 500 500 500 500 3300 Postage 2,200 2,200 2,200 2,200 City wide mailing for Cleanup Day, Newsletter, organics 2,200 2,200 2,200 2,200 3430 Printing 500 2,000 500 2,000 500 2,000 500 2,000 Articles in City newsletter Clean-up Day and Organics printing of direct mailing items 2,500 1 2,500 1 2,500 1 2,500 3530 Refuse collection 13,968 12,491 11,431 11,147 Recycling collections CH, CC, and Parks, Clean-up Days, shredding event 13,968 12,491 11,431 11,147 19,168 17,691 16,631 16,347 9.98% -7.71% -5.99% -1.71% W 2022 Budget Summary Y-T-D 2018 2019 2020 2021 09/30/2021 2022 Change from 2021 Actual Actual Actual Budget Actual Request Dollar Percent TIF # 5 (Fund 450): Revenues 3101 Tax collections 1,670,422 1,707,400 1,760,668 1,793,817 1,829,694 35,877 2.00% 3610 Investment income 4,023 8,175 5,126 1,500 1,500 - 0.00% Total revenue 1,674,445 1,715,575 1,765,794 1,795,317 1,831,194 35,877 2.00% Operating expenses (4650): Contractual services 3030 Other professional 3,927 5,306 4,655 5,372 5,372 - 0.00% 8010 Developer PAG, principal 492,935 555,066 626,473 - - - 0.00% 8020 Developer PAG, interest 1,074,832 1,049,399 1,020,860 1,688,413 1,721,169 32,756 1.94% 9900 Transfers out to EDA 83,543 85,563 88,036 89,690 91,484 1,794 2.00% Total contractual services 1,655,237 1,695,334 1,740,024 1,783,475 - 1,818,025 34,550 1.94% Net change in fund balance 19,208 20,241 25,770 11,842 - 13,169 1,327 11.21% Fund balance, beginning year 830,026 849,234 869,475 895,245 895,245 907,087 11,842 1.32% Fund balance, end of year 849,234 869,475 895,245 907,087 895,245 920,256 13,169 1.45% 67 Fund: 450 TIF District #5 Account Description 2019 2020 2021 Revenues 2022 Description 3101 Tax increment collections 1,711,275 1,760,734 1,793,817 1,829,694 Estimated collections of incremental taxes on properties in the district 1,711,275 1,760,734 1,793,817 1,829,694 3610 Investment income 3,000 3,000 1,500 1,500 Estimated interest earnings 3,000 3,000 1,500 1,500 ,Fund: 430 Department: 4650 3030 Other professional services 3,600 1,703 5,303 3,600 1,738 3,600 1,772 Economic Development 3,600 TIF administration and reporting fees 1,772 5% of audit (22-35,440, 23-36,145, 24-36,870, 25-37,605, 26-38,360) 5,372 5,338 5,372 8010 Pay-as-you-go principal 1,606,521 1,647,364 1,688,413 1,721,169 Principal on a revenue note issued to promote a development. (Medtronic) 1,606,521 1,647,364 1,688,413 1,721,169 9900 Transfer out to EDA Fund 85,563 88,036 89,690 91,484 Transfer to cover the EDA operating budget. 85,563 1 88,036 1 89,690 91,484 1,697,387 1,740,738 1,783,475 1,818,025 2.43% 2.55% 2.46% 1.94% Statutory decertification date: December 31, 2033 ?: 2022 Budget Summary 2020 2021 2022 Change from 2021 Actual Budget Request Dollar Percent TIF # 6 (Fund 441): Revenues 3101 Tax collections 10,828 79,894 81,491 1,597 2.00% 3102 Tax collections - delinquent - - - - 0.00% 3610 Investment income 10 200 200 - 0.00% Total revenue 10,838 80,094 81,691 1,597 1.99% Operating expenses (4650): Contractual services 3030 Other professional 1,316 1,332 1,332 - 0.00% 8010 Developer PAG, principal - 40,826 72,622 31,796 77.88% 8020 Developer PAG, interest 4,873 - - - 0.00% 9900 Transfers out to EDA - 6,989 8,149 1,160 16.60% Total contractual services 6,189 49,147 82,103 32,956 67.06% Net change in fund balance 4,649 30,947 (412) (31,359) -101.33% Fund balance, beginning year - 4,649 35,596 30,947 665.67% Fund balance, end of year 4,649 35,596 35,184 (412) -1.16% Fund: 441 TIF District #6 Revenues Account Description 2019 2020 2021 2022 Description 3101 Tax increment collections 10,522 79,894 81,491 Estimated collections of incremental taxes on properties in the district 10,522 79,894 81,491 3610 Investment income 40 200 200 Estimated interest earnings at 1.00%. 40 200 200 ,Fund: 441 Department: 4650 3030 Other professional services 425 522 947 800 532 Economic Development 800 TIF administration and reporting fees 532 1.5% of audit (22-35,440, 23-36,145, 24-36,870, 25-37,605, 26-38,360) 1,332 1,332 8010 Pay-as-you-go principal 4,735 40,826 72,622 Principal on a revenue note issued to promote a development. (MAT) 4,735 40,826 72,622 8020 Pay-as-you-go interest Interest on a revenue note issued to promote a development. (Medtronic) 9900 Transfer out to EDA Fund 6,989 8,149 Transfer to cover the EDA operating budget. 6,989 8,149 5,682 49,147 82,103 #DIV/0! 764.96% 67.06% Fro THIS PAGE LEFT BLANK INTENTIONALLY 71 Revenue: Taxes Franchise fees Special assessments Intergovernmental: State 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 Transfers in Transfers out Total other financing sources (uses) Net change in fund balance Fund balance, January 1 Fund balance, December 31 CITY OF MOUNDS VIEW, MINNESOTA Capital Project Funds 2022 Budgets Combining Statement of Revenues and Expenditures Park Vehicle and Special Street Total Budget Dedication Equipment Proiects Improvement 2022 2021 $ - $ - $ - $ 150,000 $ 150,000 $ 150,000 - 305,000 305,000 305,000 - 15,000 15,000 15,000 - 405,000 405,000 275,000 500 - 1,000 5,000 6,500 19,500 3,000 - - - 3,000 3,000 3,500 - 1,000 880,000 884,500 767,500 - - 75,000 - 75,000 639,830 - 81,000 - - 81,000 152,000 - - 18,000 2,910,000 2,928,000 572,260 206,000 - 226,000 - 432,000 225,500 206,000 81,000 319,000 2,910,000 3,516,000 1,589,590 (202,500) (81,000) (318,000) (2,030,000) (2,631,500) (822,090) - 460,000 75,000 - 535,000 532,000 - (61,000) - - (61,000) (185,000) - 399,000 75,000 - 474,000 347,000 (202,500) 318,000 (243,000) (2,030,000) (2,157,500) (475,090) 62,377 1,777,247 805,771 2,263,654 4,909,049 5,384,138 $ (140,123) $ 2,095,247 $ 562,771 $ 233,654 $ 2,751,549 $ 4,909,048 72 Park Dedication (Fund 451): Revenues 3610 hivestment income 3652 Park dedication fees Total revenue Operating expenses Operations (4350): Materials & supplies 1230 Supplies, equip. < $5,000 1600 Supplies, operating Total materials & supplies 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Budget Request Dollar Percent 4,555 5,091 3,194 500 500 0.00% 38,576 114,972 - 3,000 3,000 0.00% 43,131 120,063 3,194 3,500 3,500 0.00% - 748 0.00% 7,016 - 0.00% 7,016 748 0.00% Contractual services 5110 Repairs, Buildings & Grounds 3,478 1,167 0.00% Total contractual services 3,478 1,167 0.00% Capital 7050 Construction Total capital outlays Total expenses Net change in fund balance Fund balance, beginning year Fund balance, end of year 231,742 75,599 125,500 206,000 80,500 64.14% 231,742 75,599 125,500 206,000 80,500 64.14% 235,220 82,615 1,915 125,500 206,000 80,500 64.14% (192,089) 37,448 1,279 (122,000) (202,500) (80,500) 65.98% 337,739 145,650 183,098 184,377 62,377 (122,000)-66.17% $ 145,650 $ 183,098 $ 184,377 $ 62,377 $(140,123) $(202,500)-324.64% 73 Fund: 451 Park Dedication Fund Account Description 2019 2020 2021 Revenues 2022 Description 3610 Investment income 1,000 1,000 500 500 Estimated interest earnings at 1%. 1,000 1,000 500 500 3652 Park dedication fees 3,000 3,000 3,000 3,000 Developer payments 3,000 3,000 3,000 3,000 und: 451 Department: 4470 Expenditures 7050 Construction > $25000 45,000 Irrigation & landscaping improvements City Hall Park 58,500 Restroom enclosures, roof, hockey lighting - 60,000 136,000 Random Park Playground 40,000 50,000 Lambert Park Hockey Boards 13,000 20,000 Netting Silver View Park 12,500 - T-Ball field City Hall Park 58,500 - 2 park shelters (splash pad) 25,000 - Silver View Park Shelter remodel 83,500 i 103,500 1 125,500 206,000 74 Vehicle & Equipment (Fund 460): Revenues 3680 Miscellaneous revenue 3972 Transfers in - General fund 3972 Transfers in - Water 3972 Transfers in - Sewer 3972 Transfers in - Storm Water Total revenue Expenditures Central Services (4160): Materials & supplies 1230 Supplies, equipment < $5,000 Capital 7030 Equipment Total Central Services Police (4200): Materials & supplies 1230 Supplies, equip < $5,000 3030 Other professional services 5120 Repairs, vehicles Capital 7030 Equipment 7040 Vehicles Total Police Park and rec (4360): Capital 7030 Equipment 7040 Vehicles Total Park and rec PW Streets (4470): Materials & supplies 1230 Supplies, equip < $5,000 Capital 7030 Equipment 7040 Vehicles Total PW Streets Other (4160): 9900 Transfer out - General Fund 9900 Transfer out - Water 9900 Transfer out - Sewer Total other Total expenditures Net change in fund balance Fund balance, beginning year Fund balance, end of year 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Budget Request Dollar Percent 57,253 13,289 - - - - 0.00% 300,000 325,000 299,000 299,000 300,000 1,000 0.33% 66,000 67,000 67,000 70,000 70,000 - 0.00% 48,000 52,000 55,000 55,000 55,000 - 0.00% 32,000 31,000 33,000 33,000 35,000 2,000 6.06% 503,253 488,289 454,000 457,000 460,000 3,000 0.66% - 6,502 - - - - 0.00% - 7,601 - - - - 0.00% - 14,103 - - - - 0.00% 10,107 43,109 10,263 - - 0.00% 7,240 - - 0.00% - 255 - - - 0.00% - - - 101,000 25,000 (76,000)-75.25% 107,295 95,645 97,068 51,000 56,000 5,000 9.80% 124,642 138,754 107,586 152,000 81,000 (71,000)-46.71% 48,171 57,043 100,000 (100,000)-100.00% - - - - - 0.00% 48,171 57,043 100,000 - (100,000)-100.00% 2,847 - 6,135 - - - 0.00% - 26,464 181,619 - - - 0.00% - - 49,344 200,000 (200,000)-100.00% 2,847 26,464 237,098 200,000 - (200,000)-100.00% - 25,000 26,000 1,000 4.00% - - 160,000 35,000 (125,000)-78.13% 100,000 - - - - 0.00% - 100,000 - 185,000 61,000 (124,000) -67.03% 127,489 327,492 401,727 637,000 142,000 (495,000) -77.71% 375,764 160,797 52,273 (180,000) 318,000 498,000 -276.67% 1,368,413 1,744,177 1,904,974 1,957,247 1,777,247 (180,000) -9.20% 1,744,177 1,904,974 1,957,247 1,777,247 2,095,247 318,000 17.89% 327,492 401,727 637,000 142,000 75 Fund: 460 Vehicle & Equipment Fund Revenues Account Description 2019 2020 2021 2022 Description 3961 Transfers in 286,000 299,000 299,000 300,000 From General Fund ($259,000 5yr Fin Plan) 67,000 67,000 70,000 70,000 From Water Fund 52,000 55,000 55,000 55,000 From Sanitary Sewer Fund 31,000 33,000 33,000 35,000 From Storm Water Fund 436,000 454,000 457,000 460,000 Fund: 460 Department: 4160 Central Services Operations 7030 Equipment > $5000 20,500 - Copiers (3) add pw in 2024 20,500 Fund: 460 Department: 4200 Police Operations 7030 Equipment > $5000 Radar trailer 14,100 - Squad mobile computers, mounts, and antennas (3) - 12,500 Miscellaneous Equipment for Squads - - 25,000 Watchgurard server upgrade 101,000 (25) 800 Mhz radios ($101,000 in 2021) 14,100 12,500 101,000 25,000 7040 Vehicles 96,900 97,400 51,000 56,000 (1) Squad $39,000, (1) setup $17,000 96,900 97,400 51,000 56,000 Fund: 460 Department: 4360 Parks Operations 7030 Equipment > $5000 40,000 - - - Utility cart (Drag, paint arm, brush attachment) - 100,000 Replace AEBI tractor 11,500 CH & CC mower ($13,500 Walker MTGHS mower move to 2019?) 51,500 100,000 7040 Vehicles 54,000 54,000 Parks maint 1 ton pick-up (carryover to 2020) 54,000 54,000 Fund: 460 Department: 4470 Pavement Management Operations 1230 Supplies, equip < $5,000 6,200 Refurbish 2 trailers 6,200 7030 Equipment > $5000 25,000 Overhaul Loader extend replacement 10 more years 13,000 Sweeper/Scrubber (new item) 13,000 25,000 7040 Vehicles 50,000 50,000 - Street maint 1 ton pick-up (carryover to 2020) 200,000 Dump truck ($220,000 net of trade-in $20,000) 50,000 50,000 200,000 9900 Transfers out 23,000 24,000 25,000 26,000 Various equipment purchases general fund 100,000 - - - Sewer Televising equipment - - 125,000 Water - Booster station generator 35,000 35,000 35,000 Water - (1/2 ton truck 4x4 ($35,000) Move to 2022 123,000 1 59,000 1 185,000 1 61,000 423,000 304,100 637,000 142,000 296.81%-28.11% 109.47%-77.71% W. Special Projects (Fund 480): Revenues 3553 Spec assessmt penalty & intere 3610 Investment income 3680 Other revenue 3972 Transfers in 3993 Bond sales Total revenue 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Budget Request Dollar Percent 225 1,371 635 - - 0.00% 27,852 39,980 18,796 4,000 1,000 (3,000)-75.00% 24,522 827,280 - - - 0.00% 100,000 125,000 475,000 75,000 75,000 0.00% - - - - - 0.00% 152,599 993,631 494,431 79,000 76,000 (3,000) -3.80% Operating expenses Operations (4160): Materials & supplies 1230 Supplies, equipment < $5,000 8,550 10,208 32,700 (32,700)-100.00% Total materials & supplies 8,550 10,208 32,700 (32,700)-100.00% Contractual services (4160) 3030 Other professional services 14,300 2,090 12,600 171,030 205,000 33,970 19.86% 5130 Repairs; Equipment - - - - - - 0.00% Total contractual services 14,300 2,090 12,600 171,030 205,000 33,970 19.86% Capital (4160) 7030 Capital equipment - - 22,316 406,100 96,000 (310,100) (1) 7050 Construction 667 222,143 337,543 30,000 18,000 (12,000) (0) Total capital outlays 667 222,143 359,859 436,100 114,000 (322,100) (1) Contractual services (4180) 3030 Other professional services 28,107 - 540 - - 0.00% 5130 Repairs; Equipment - 3,000 - 0.00% Total contractual services 28,107 3,000 540 0.00% Capital (4180) 7030 Capital equipment 32,915 34,110 0.00% 7050 Construction 24,724 20,337 0.00% Total capital outlays 57,639 54,447 0.00% Capital (4470) 7030 Capital equipment - 50,849 - - 0.00% 7050 Construction 676,844 365,062 14,500 25,000 (25,000)-100.00% Total capital outlays 676,844 415,911 14,500 25,000 (25,000)-100.00% Other 8050 Issuance costs - debt service - - - - 0.00% 9900 Transfer out 126,284 0.00% Total other 126,284 - - - 0.00% Total expenses 912,391 697,591 397,707 664,830 319,000 (345,830)-52.02% Net change in fund balance (759,792) 296,040 96,724 (585,830) (243,000) 342,830-58.52% Fund balance, beginning year 1,758,629 998,837 1,294,877 1,391,601 805,771 (585,830)-42.10% Fund balance, end of year 998,837 1,294,877 1,391,601 805,771 562,771 (243,000)-30.16% 77 LFanadj:A Account I Special Projects Description 2019 2020 2021 Revenues 1 2022 Description 3610 Investment income 2,000 8,000 4,000 1,000 Estimated interest earnings at 1%. 2,000 8,000 4,000 1,000 3972 Transfers in 75,000 75,000 75,000 75,000 Transfer from General Fund 75,000 75,000 75,000 75,000 und: 480 Department: 4160 Expenditures 1230 Supplies, equipment 7,700 Bullet Proof vests (7 officers @ $1,100 each) 25,000 CommCtr funiture 32,700 3030 Other professional services 29,000 - CommCtr upgrades (4 more cameras, ADA imp, door locks, garbage encl.) - 35,000 35,000 CommCtr painting (carryover to 2022) - 15,000 CommCtr front counter upgrades - 10,000 CommCtr Repair Skylights 15,124 - CommCtr intrusion system update 14,300 - - CommCtr Dividers (carryover $6,300) - 70,000 Consultants for CC expansion (R9484, R9485) 15,000 - Trench Drian PW Shop - 21,000 - - Codification of City Code 60,000 60,000 75,000 Finance/Payroll/Utility Billing software upgrade (place holder) 29,300 110,000 110,124 205,000 7030 Capital, equipment > $5000 20,000 - - - Purchase copiers (3) Main copier, police, comm dev/finance (replace 2019) - 15,000 - - CommCtr Basketball hoops - - 60,906 86,000 CommCtr Banquet Ctr carpet (carryover to 2022) 10,000 10,000 10,000 10,000 Park building video and door lock improvements 24,950 - - - Automatic Transfer switch (CH generator)(defer to 2019) 43,340 PW Bldg cameras, floor sealing, security system 100,000 City monument sign County H round -about gateway 396,100 - HVAC upgrades - CH, CC, PW 198,290 25,000 467,006 96,000 7050 Construction > $25000 - 25,000 25,000 18,000 PW floor sealing and ADA Doors (Carryover to 2022) 43,553 43,553 - - CommCtr HVAC Improvements (RTU-4,7 and VAV's)(carryover to 2020) 8,555 8,555 DP swithches CH & CC (carryover to 2020) - 128,000 - CommCtr. divider wall replacement & front counter gate 26,000 30,000 30,000 CommCtr restrooms in gym locker rooms - 120,000 - CH Conf room, rubber flooring, dais & other misc. imp. (R9487 11-8-21) 257,000 175,000 Remodel PD and CH Basement (carryover from 2019) 335,108 530,108 55,000 18,000 562,698 665,108 664,830 319,000 -55.28% 18.20% -0.04%-52.02% Street Improvement (Fund 485): Revenues 3101 Property taxes 3180 Franchise fee 3352 MSA street construction 3550 Spec assessmt prepayment 3610 Investment income 3680 Other revenue Total revenue Operating expenses Operations (4470): Contractual services 3030 Other professional services Total contractual services Capital 7050 Construction Total capital outlays Other 9900 Transfer out Total other Total expenses Net change in fund balance Fund balance, beginning year Fund balance, end of year 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Budget Re nest Dollar Percent - 139,666 151,111 150,000 150,000 0.00% 338,760 308,835 301,756 305,000 305,000 0.00% 406,576 407,880 484,789 275,000 405,000 130,000 47.27% 19,699 17,017 26,042 15,000 15,000 - 0.00% 33,159 60,850 42,740 15,000 5,000 (10,000)-66.67% - - 1,924 - - - 0.00% 798,194 934,248 1,008,362 760,000 880,000 120,000 15.79% 6,692 236,424 24,706 0.00% 6,692 236,424 24,706 0.00% 952,364 292,940 579,516 347,260 2,910,000 2,562,740 737.99% 952,364 292,940 579,516 347,260 2,910,000 2,562,740 737.99% - - 701,000 - - - 0.00% - - 701,000 - - - 0.00% 959,056 529,364 1,305,222 347,260 2,910,000 2,562,740 737.99% (160,862) 404,884 (296,860) 412,740 (2,030,000) (2,442,740)-591.84% 1,903,752 1,742,890 2,147,774 1,850,914 2,263,654 412,740 22.30% $1,742,890 $2,147,774 $1,850,914 $2,263,654 $ 233,654 $(2,030,000)-89.68% 79 Fund: 485 Street Improvement Revenues Account Description 2019 2020 2021 2022 Description 3101 Property taxes 150,000 150,000 150,000 150,000 General tax levy for streets 150,000 150,000 150,000 150,000 3180 Franchise fee 295,000 302,500 305,000 305,000 Half of the 4% franchase fee on gas & electric utilities 295,000 302,500 305,000 305,000 3352 MSA Street Construction 275,000 275,000 275,000 405,000 State aid funds 275,000 1 275,000 1 275,000 1 405,000 3550 Special assessments 15,000 22,000 15,000 15,000 Special assessments on private improvements 15,000 22,000 15,000 15,000 3610 Investment income 8,000 20,000 15,000 5,000 Estimated interest earnings 8,000 20,000 15,000 5,000 743,000 769,500 760,000 880,000 Fund: 485 Department: 4470 Expenditures 7050 Construction > $25000 75,000 - 2018 Program Avenue CSAH 10 to CR H2 700,000 20,000 2019 Woodale Dr. Closeout 55,000 316,000 50,000 - 2020 Quincy Street (costruction) in TIF #3 - 75,000 75,000 2,465,000 2022 Pleasant View and Spring Lake Road (construction phase) - - 225,000 2023 Spring Lake Road S of MV Blvd (design phase) - 50,000 75,000 Trailway development and ADA transition project (2021 - 2023) 100,000 - - Mill and overlay Silver View parking lot (Carryover to 2019) 188,000 98,500 172,260 145,000 Seal coat projects (Area C, H) 1,118,000 509,500 347,260 2,910,000 9900 Transfer out i 701,000 EDA - 701,000 :1 THIS PAGE LEFT BLANK INTENTIONALLY .mil CITY OF MOUNDS VIEW, MINNESOTA Enterprise Funds 2022 Budgets Combining Statement of Revenues and Expenses 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): Investment income Principal payment on debt (ESP Lease) Interest on debt (ESP Lease) Interest expense Bond fees / discounts Total non -operating Transfers and other financing sources Transfers in Transfers out Bonds issued Total transfers and other financing sour( Revenues over (under) expenditures Less: Bond proceeds Add back: Capital outlays Principal on debt Net income (loss) Net assets (deficit), January 1 Net assets (deficit), December 31 Sanitary Street Storm Water Sewer Lighting Water Total 2022 2021 1,320,128 1,936,673 105,112 402,000 3,763,913 3,416,540 80,500 - - - 80,500 69,500 2,000 - - - 2,000 2,000 1,402,628 1,936,673 105,112 402,000 3,846,413 3,488,040 496,868 453,419 12,402 166,770 1,129,460 1,008,449 78,042 33,462 1,000 21,400 133,904 126,876 234,300 126,647 3,850 278,684 643,481 557,132 136,500 2,100 82,500 - 221,100 217,100 - 1,088,918 - - 1,088,918 1,030,104 15,000 15,000 - - 30,000 30,000 220,000 100,000 - 35,000 355,000 375,000 2,305,000 530,000 - 75,000 2,910,000 3,829,104 3,485,710 2,349,546 99,752 576,854 6,511,863 7,173,765 (2,083,082) (412,873) 5,360 (174,854) (2,665,450) (3,685,725) 2,000 20,000 1,400 16,000 39,400 49,400 - - - - - (7,572) (335,000) - - - (335,000) (1,680) (71,971) - - - (71,971) - (2,950) - - - (2,950) - (407,921) 20,000 1,400 16,000 (370,521) 40,148 35,000 - - - (157,905) (142,905) (3,119) (43,815) (122,905) (142,905) (3,119) (43,815) (2,613,908) (535,778) 35,000 35,000 (347,744) (332,216) - 6,000,000 (312,744) 5,702,784 3,641 (202,669) (3,348,715) 2,057,207 (6,000,000) 2,305,000 530,000 - 75,000 2,910,000 3,829,104 335,000 - - - 335,000 7,572 26,092 (5,778) 3,641 (127,669) (103,715) (106,117) 4,318,729 4,492,657 112,856 3,246,515 12,170,756 11,907,761 $ 4,344,820 $4,486,878 $ 116,497 $3,118,846 $12,067,041 $11,801,644 2022 Budget Summary 2018 2019 2020 2021 2022 Changefrom 2021 Actual Actual Actual Budp_et Request Dollar Percent Water (Fund 700): Revenues 3375 State pension contribution 478 649 - - - 0.00% 3424 Meter charge - - 1 - - - 0.00% 3550 Spec assessments -prepayments - - 1,594 - - - 0.00% 3551 Spec assessments -current 63,346 61,379 70,950 75,000 75,000 - 0.00% 3552 Spec assessments -delinquent 8,652 6,070 8,692 5,000 5,000 - 0.00% 3553 Spec assess. -penalty & interest 1,448 1,408 6,328 500 500 - 0.00% 3610 Investment income 7,370 21,328 6,257 1,000 2,000 1,000 100.00% 3680 Otherrevenues 2,105 2,219 4,706 2,000 2,000 - 0.00% 3710 Water sales 1,041,422 954,847 1,168,083 1,067,805 1,219,128 151,323 14.17% 3714 Water service insurance 88,775 89,385 93,774 92,000 92,000 - 0.00% 3715 Utility connections 2,600 3,150 3,750 2,000 2,000 - 0.00% 3716 Penalties 9,567 11,777 5,560 7,000 7,000 - 0.00% 3913 Meter sales 4,601 3,675 660 - - - 0.00% 3917 WAC/SWM charges 34,500 69,500 1,500 - - - 0.00% 3972 Transfers - Vehicle & Equip - - - 160,000 35,000 (125,000) -78.13% 3993 Bonds issued - - - - - - 0.00% Total revenue 1,264,386 1,225,216 1,372,504 1,412,305 1,439,628 27,323 1.93% Operating expenses Billing Services (4820): Personnel services 0100 Salaries, regular 43,847 43,377 45,907 47,336 49,625 2,289 4.84% 0300 Social security 2,844 3,060 3,091 3,621 3,796 175 4.83% 0321 PERA 2,524 2,719 2,922 3,551 3,721 170 4.79% 0322 GASB 68 Pension Exp (8,232) 194 5,831 - - - 0.00% 0400 Group insurance 3,598 7,238 7,460 7,158 7,361 203 2.84% 0500 Workers compensation 232 279 296 384 394 10 2.60% Total personnel services 44,813 56,867 65,507 62,050 64,897 2,847 4.59% Materials & supplies 1600 Supplies, operating - - - 50 50 - 0.00% Total materials & supplies - - - 50 50 - 0.00% Contractual services 3030 Other professional services 8,629 8,732 8,616 9,083 9,083 - 0.00% 3300 Postage 2,200 2,474 2,680 4,600 4,600 - 0.00% 3430 Printing - 880 900 900 900 - 0.00% 3630 Training - 1,176 - 2,400 2,400 - 0.00% 5130 Repairs, equipment 4,444 4,978 4,899 8,571 8,832 261 3.05% Total contractual services 15,273 18,240 17,095 25,554 25,815 261 1.02% Debt Service: 8010 Principal - - - - 335,000 335,000 0.00% 8020 Interest - 42,000 71,971 29,971 71.36% 8030 Paying agent fees - 450 450 - 0.00% 8040 Continuing disclosure - 2,500 2,500 - 0.00% 8050 Issuance costs - 100,764 - - - 0.00% Total debt service 100,764 44,950 409,921 364,971 811.95% Miscellaneous: 9800 Loss on disposal of asset - - - - - 0.00% 9900 Transfers out to General Fund 78,103 80,446 82,859 85,345 87,905 2,560 3.00% 9900 Transfers out to Vehicle Fund 66,000 67,000 67,000 70,000 70,000 - 0.00% Total capital outlays 144,103 147,446 149,859 155,345 157,905 2,560 1.65% Total Billing 204,189 222,553 333,225 287,949 658,588 370,639 128.72% 159,376 165,686 267,718 225,899 593,691 Fund: 700 Department: 4820 Account Description 2019 2020 2021 Billing Services 2022 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 8,346 400 8,513 400 8,683 400 8,683 400 24.5% of audit (22-35,440, 23-36,145, 24-36,870, 25-37,605, 26-38,360) County special assessment maintenance fee 8,746 8,913 9,083 9,083 3300 Postage 3,300 800 500 3,300 800 500 3,300 800 500 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,600 4,600 4,600 4,600 3430 Printing 450 450 450 450 450 450 450 450 Utility bills (1/2 cost) Envelopes 900 900 900 900 3630 Training 2,400 2,400 2,400 2,400 Seminars on new regulations, software updates, etc. INCODE training 2,400 2,400 2,400 2,400 5130 Repairs, equipment 4,264 - 305 1,250 448 4,477 - 330 1,800 495 4,701 1,200 350 1,800 520 4,936 1,200 350 1,800 546 Incode software support (30%)(5% annual increase per agreement) Incode UB support Neptune reader maintenance (1/2 in sewer)(2019 first year $610) Neptune software maintenance (1/2 in sewer) Handheld interface support for meter readers (1/2 in sewer)(Incode) 6,267 7,102 8,571 8,832 8010 Principal 335,000 Principal due on bonds - 335,000 8020 Interest 42,000 71,971 Interest due on 2020 A Bonds 42,000 71,971 8030 Paying agent fees 450 450 Paying agent fees on bond issues 450 450 8040 Continuing Disclosure 2,500 2,500 Annual debt disclosure requirements and Ramsey county sp. Assmt. Fees 2,500 2,500 9900 Transfers out 80,446 67,000 82,859 67,000 85,345 70,000 87,905 70,000 Transfer to General Fund for administrative overhead costs Transfer to Vehicle & Equipment Fund to fund future purchases 147,446 149,859 155,345 157,905 170,409 173,824 225,899 593,691 2022 Budget Summary 2018 2019 2020 2021 2022 Changefrom 2021 Actual Actual Actual Budp_et Request Dollar Percent Water (Fund 700): Infrastructure & Equip Maintenance (4823): Personnel services 0100 Salaries, regular 154,740 208,795 248,078 253,968 272,184 18,216 7.17% 0110 Salaries, overtime 13,360 10,051 15,330 11,127 11,460 333 2.99% 0150 Salaries, part-time 3,190 3,884 4,082 7,800 8,320 520 6.67% 0300 Social security 12,057 15,201 18,186 20,838 22,296 1,458 7.00% 0321 PERA 12,655 14,347 18,793 19,844 21,238 1,394 7.02% 0400 Group insurance 25,581 28,470 38,276 39,582 45,510 5,928 14.98% 0500 Workers compensation 5,354 6,444 6,954 7,163 7,297 134 1.87% 0600 Unemployment 2,964 - - - - - 0.00% Total personnel services 229,901 287,192 349,699 360,322 388,305 27,983 7.77% Materials & supplies 1210 Supplies, bldg & grnds 701 171 2,160 2,750 2,750 0.00% 1220 Supplies, vehicles 3,600 951 1,637 1,500 1,500 - 0.00% 1230 Supplies, equipment 13,678 9,840 2,836 2,625 2,625 - 0.00% 1240 Supplies, streets 5,847 4,286 5,657 4,500 4,500 - 0.00% 1250 Supplies, utilities 31,684 8,853 8,521 13,950 13,950 - 0.00% 1260 Supplies, traffic control - 132 211 200 200 - 0.00% 1600 Supplies, operating 6,348 6,461 10,356 7,000 7,000 - 0.00% 1700 Motor fuels 5,271 5,331 5,458 4,020 5,593 1,573 39.13% 2400 Uniforms 881 1,558 1,335 1,100 1,100 - 0.00% 2410 Mats & towels 520 515 445 620 620 - 0.00% Total materials & supplies 68,530 38,098 38,616 38,265 39,838 1,573 4.11% Contractual services 3030 Other professional services 16,380 26,556 15,613 19,476 19,696 220 1.13% 3100 Communications - telephone 4,167 3,097 5,209 3,884 3,884 - 0.00% 3200 Water & wastewater charges 7,293 4,326 6,347 7,200 7,200 - 0.00% 3220 Natural gas 10,472 8,771 5,864 8,500 8,500 - 0.00% 3610 Memberships 366 325 150 360 360 - 0.00% 3630 Training 1,364 2,791 1,225 5,530 5,530 - 0.00% 4010 Equipment rental 1,245 4,663 629 4,500 4,500 - 0.00% 4800 Insurance 8,950 7,484 8,590 10,230 10,230 - 0.00% 5110 Repairs, bldgs & grnds 3,509 5,040 1,983 10,540 10,540 - 0.00% 5120 Repairs, vehicles - 1,014 - 1,000 1,000 - 0.00% 5130 Repairs, equipment 6,443 14,409 17,180 7,000 6,000 (1,000) -14.29% 5140 Repairs, streets 17,399 9,700 15,107 10,000 10,000 - 0.00% 5150 Repairs, utilities 15,562 20,432 13,941 17,500 17,500 - 0.00% 5155 Water service repair 94,754 62,764 94,981 90,000 90,000 - 0.00% 5160 Repairs, system maintenance - - 875 3,500 3,500 - 0.00% Total contractual services 187,904 171,372 187,694 199,220 198,440 (780) -0.39% Capital outlays 7030 Equipment - - - 210,000 1,425,000 1,215,000 578.57% 7050 Construction - - - 3,896,000 880,000 (3,016,000) -77.41% 7950 Depreciation 240,717 230,683 198,159 240,000 220,000 (20,000) -8.33% Total capital outlays 240,717 230,683 198,159 4,346,000 2,525,000 (1,821,000) -41.90% Miscellaneous: 9100 Contingency 15,000 15,000 - 0.00% Total miscellaneous - 15,000 15,000 - 0.00% Total infrastructure & equip maint 727,052 727,345 774,168 4,958,807 3,166,583 (1,792,224)-36.14% 497,151 440,153 424,469 4,598,485 2,778,278 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance Account Description 2019 2020 2021 2022 Description 1210 Supplies, Bldgs & grounds 100 100 100 100 Mops, buckets, brooms 500 500 500 500 Light tubes & ballasts 200 200 200 200 Paper products 200 200 200 200 Paint, thinner, & brushes 750 750 750 750 Black dirt & sod/seed, landscaping materials 500 500 500 500 Misc. cleaners for well houses & % of shop 500 500 500 500 Irrigation parts 2,750 2,750 2,750 2,750 1220 Supplies, vehicles 300 300 300 300 Air, oil, fuel, & transmission filters 100 100 100 100 Fluids 400 400 400 400 Batteries and tires 50 50 50 50 Paint sealant 150 150 150 150 Tune ups 500 500 500 500 Misc repairs 1,500 1,500 1,500 1,500 1230 Supplies, equipment < $5000 100 100 100 100 Tune ups 100 100 100 100 Grounds maintenance equipment 100 100 100 100 Blades, suction hoses, filter screens 175 175 175 175 Hydraulic fluid: 35 gallons @ $4.80 / gallon 200 200 200 200 Solvents & cleaning fluids 200 200 200 200 Air compressor & dehumidifier parts 1,500 1,500 1,500 1,500 Chemical equipment parts (fluoride pumps) 250 250 250 250 Air, oil, fuel, & trans filters (emergency generator) 2,625 2,625 2,625 2,625 1240 Supplies, streets 4,500 4,500 4,500 4,500 Asphalt/concrete/sod/seed for patching minor street, curb, driveway repairs. 4,500 4,500 4,500 4,500 1250 Supplies, utilities 2,500 2,500 2,500 5,000 Paint & sandblasting materials for hydrants 500 500 500 500 Copper, steel & PVC pipe 1,500 1,500 1,500 1,250 Valve box risers, main repair clamps 1,000 1,000 1,000 750 Hydrant markers 1,050 - - - De -chlorinator 3,450 3,450 3,450 3,000 Hydrant parts (hydrant pump $450 - 2017) 5,000 5,000 5,000 3,450 Meter supplies, etc. (move from account 1600) 15,000 13,950 13,950 13,950 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 1,850 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 1,500 Additional & replacement hand tools 7,000 7,000 7,000 7,000 1700 Motor fuels & lubs 620 620 580 1,568 Diesel fuel - 475 gallons @ $3.30 450 450 450 450 Oil 3,380 3,380 2,990 3,575 Unleaded fuel: 1,300 gallons @ $2.75 4,450 4,450 4,020 5,593 2400 Uniforms 1,100 1,100 1,100 1,100 Uniforms 15.5% of $4,500 and clothing 1.7 FTE x $175 per contract 1,100 1,100 1,100 1,100 2410 Mats & towels 620 620 620 620 Share of floor mats & shop towels (15.5% of $4,000) 620 620 620 620 3030 Other professional services 180 180 180 400 Backflow prevention testing (3 @ $60 per test) 3,500 3,500 3,500 3,500 Water system leak survey (every 2 years)(not done in 2019) - 850 850 850 Annual inspections heating units in all water buildings - 1,496 1,496 1,496 Annual inspection generator units 7,700 - - - Inspection of water tower and ground reservoir roof 500 500 500 500 Broadleaf control 1,000 1,000 6,000 6,000 Asset management software 250 250 250 250 Fire sprinkler inspections/testing 200 200 200 200 Fire extinguisher inspection/service(10 @ $20) 750 750 750 750 Gopher State One -call locates 2,750 2,750 2,750 2,750 Safety Data Service (1/3 Sewer, 1/3 Storm Water) 3,000 3,000 3,000 3,000 ArcView/GIS base map and engineering consulting 19,830 14,476 19,476 19,696 3100 Communications - telephone 400 400 400 400 Service & repair 1,954 1,954 1,954 1,954 Cellular phone service (20.06% of $9,200) 631 631 1,440 1,440 Data cards for SCADA (4)(75%)(40.01 per card) balance in Sewer 90 90 90 90 800 MHz license fee (33%)(5 radios @ $4.48 per month) 3,075 3,075 3,884 3,884 3200 Water and wastewater charges 7,200 7,200 7,200 7,200 7,200 7,200 7,200 7,200 THIS PAGE LEFT BLANK INTENTIONALLY Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance Account Description 2019 2020 2021 2022 Description 3220 Natural gas 8,500 8,500 8,500 8,500 Heating fuel 8,500 8,500 8,500 8,500 3610 Memberships 120 120 120 120 MN Rural Water Association (50%) 100 100 100 100 MN Safety Council 60 60 60 60 Suburban Utility Superintendent Association (SUSA)(50% of $100) 80 80 80 80 Pressurized vessel license 360 360 360 360 3630 Training 250 150 150 150 Computer training/webinars 1,700 1,200 1,200 1,200 Trench safety/confined space alternate years/inspection safety - 1,000 1,000 1,000 Class A license 110 110 110 110 Hearing test/R2K (2.15 FTE * $50) 60 60 60 60 Maintenance Expo 1,500 2,000 2,000 2,000 Water operator class/exam/certificate ($xxx per person) 200 100 100 100 Misc. training seminars 390 300 300 300 Equipment operator training 200 150 150 150 MRWA workshops 560 400 400 400 Tuition reimbursement 60 60 60 60 Work zone safety seminar (every 3 years) 5,030 5,530 5,530 5,530 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 1,000 1,000 1,000 Door & lock repairs 1,000 1,000 1,000 1,000 Roof & wall repairs 7,540 7,540 7,540 7,540 Electrical & mechanical repairs (well #2 in 17 well #4 in 18 $4540) 1,000 1,000 1,000 1,000 Site repairs (pavement, fence, irrigation, etc...) 11,540 10,540 10,540 10,540 5120 Repairs, vehicles 1,800 1,000 1,000 1 1,000 Utility truck repairs 1,800 1,000 1,000 1,000 5130 Repairs, equipment 1,500 900 900 900 Well and water treatment plant repairs 1,500 500 500 500 Miscellaneous repairs (Backhoe, Skid steer) 3,000 1,000 1,000 - Repair boiler @ main plant - 12,000 - Backhoe overhall extend life 10 more years - 3,100 - Refurbish trailer 3,500 1,000 1,000 1,000 Generator service - Onan 2,500 1,500 1,500 1,500 VFD service 1,500 1,000 1,000 1,000 Meter and valve repairs 2,000 1,000 1,000 1,000 SCADA repairs 100 100 100 100 Radio repairs 15,600 22,100 7,000 6,000 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 75,000 75,000 75,000 Contractor repairs to residential water services. 15,000 15,000 15,000 15,000 Pavement & curb repairs 80,000 90,000 90,000 90,000 5160 System maintenance 3,500 3,500 3,500 3,500 Water system maintenance & repair items 3,500 3,500 3,500 3,500 7030 Capital, equipment > $5000 15,000 15,000 15,000 15,000 Gate valves - 35,000 35,000 1,375,000 Commercial/Residentional meter replacements 35,000 - - - Booster station (pressure valve) - - 125,000 - Generator WTP #1 and booster station 35,000 35,000 35,000 3/4 ton pick-up 50,000 1 85,000 210,000 1,425,000 7050 Construction > $25000 400,000 3,159,104 3,816,000 800,000 Water treatment plant engineering, design, construction 50,000 150,000 80,000 80,000 Well pump rehabilitation project (well no. 4 & 5) 450,000 3,309,104 3,896,000 880,000 7950 Depreciation 238,000 240,000 240,000 220,000 Estimated depreciation 238,000 240,000 240,000 220,000 9100 Contingency 15,000 15,000 15,000 15,000 Contingency 15,000 15,000 15,000 15,000 991,410 3,896,310 4,598,485 2,778,278 2022 Budget Summary 2018 2019 2020 2021 2022 Changefrom 2021 Actual Actual Actual Budp_et Request Dollar Percent Water (Fund 700): Water Production (4825): Personnel services 0100 Salaries, regular 37,091 40,474 29,625 30,205 31,096 891 2.95% 0110 Salaries, overtime 3,521 3,142 1,649 - - - 0.00% 0300 Social security 2,806 3,052 2,195 2,280 2,348 68 2.98% 0321 PERA 2,989 2,997 2,240 2,235 2,302 67 3.00% 0400 Group insurance 6,905 6,898 5,351 5,688 6,576 888 15.61% 0500 Workers compensation 955 1,034 1,054 1,336 1,344 8 0.60% Total personnel services 54,267 57,597 42,114 41,744 43,666 1,922 4.60% Materials & supplies 1600 Supplies, operating 25,408 18,439 13,848 37,775 37,775 - 0.00% 2400 Uniforms 144 374 615 235 235 0.00% 2410 Mats & towels 120 196 241 144 144 0.00% Total materials & supplies 25,672 19,009 14,704 38,154 38,154 - 0.00% Contractual services 3030 Other professional services 1,414 7,612 5,896 18,545 18,545 - 0.00% 3210 Electricity 128,111 118,330 110,253 128,000 128,000 - 0.00% 5150 Repairs, utilities - 538 - - - - 0.00% Total contractual services 129,525 126,480 116,149 146,545 146,545 - 0.00% Total water production 209,464 203,086 172,967 226,443 228,365 1,922 0.85% 155,197 145,489 130,853 184,699 184,699 Total expenditures 1,140,705 1,152,984 1,280,360 5,473,199 4,053,536 (1,419,663) -25.94% Revenues over (under) expenditures 123,681 72,232 92,144 (4,060,894) (2,613,908) 1,446,986 -35.63% Less: Bond Proceeds - - - - - - 0.00% Add back: capital outlays 4,106,000 2,305,000 (1,801,000) -43.86% principal payment on debt - 335,000 335,000 0.00% Change in net assets 123,681 72,232 92,144 45,106 26,092 (19,014) -42.15% Net Assets, beginning year 3,985,566 4,109,247 4,181,479 4,273,623 4,318,729 45,106 1.06% Net Assets, end of year $ 4,109,247 $ 4,181,479 $ 4,273,623 $ 4,318,729 $ 4,344,820 $ 26,092 0.60% 811,724 751,328 823,040 5,009,083 3,556,668 Fund: 700 Department: 4825 Water Production Account Description 2019 2020 2021 2022 Description 1600 Supplies, operating 550 550 550 550 Computer supplies 800 800 800 800 Testing reagents 4,125 4,125 4,125 4,125 Sulfur dioxide: 25150#cylinders @$1.1Oper pound 10,400 10,400 10,400 10,400 Chlorine: 8 - 1 ton cylinders @ .65 per pound 10,350 10,350 10,350 10,350 Chlorine: 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 37,775 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 2,000 2,000 2,000 2,000 Bacteria tests (10*$15*12 months)(+$200 Health Dept Rule) 800 800 800 800 Computer maintenance 5,500 5,500 5,500 5,500 DNR water permit fee (ann. surcharge)(14 - $3826, 15 - $4462, 16 - $4532) 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,425 1,425 1,425 1,425 MCES discharge permits (3*$475) 300 300 300 300 MNDPS - EPCRA program ($100/WTP) 5,000 5,000 5,000 5,000 Water Supply Plan 18,545 18,545 18,545 18,545 3210 Electricity 121,000 128,000 128,000 128,000 Electricity for wells, tower & rescrvoir 121,000 128,000 128,000 128,000 177,699 184,699 184,699 184,699 1,339,518 4,254,833 5,009,083 3,556,668 43.78% 217.64% 17.73%-29.00% y1 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Bud et Request Dollar Percent Sanitary Sewer (Fund 730): Revenues 3375 State pension contribution 1,362 447 586 0.00% 3551 Spec. Assessments 968 668 594 - - 0.00% 3610 Investment income 31,077 65,558 39,503 20,000 20,000 - 0.00% 3680 Other revenues - - - - - 0.00% 3716 Penalties 10,924 13,871 6,673 10,000 10,000 - 0.00% 3719 Sewer inspection charge - - 24,900 - - 0.00% 3720 Utility sales 1,662,537 1,716,803 1,825,212 1,861,520 1,926,673 65,153 3.50% 3721 SAC charges 1,839 3,752 (2,485) - - - 0.00% 3725 Utility connections 1,000 2,000 11,400 - - - 0.00% 3726 Penalties & interest 896 1,004 442 - - - 0.00% 3940 Capital Contributions - 43,059 - - - 0.00% 3972 Transfers from Vehicle Fund - 100,000 - - - - 0.00% Total revenue 1,710,603 1,947,162 1,906,825 1,891,520 1,956,673 65,153 3.44% Operating expenses Billing Services (4820): Personnel services 0100 Salaries, regular 43,847 43,377 45,907 47,336 49,625 2,289 4.84% 0300 Social security 2,298 2,913 3,333 3,621 3,796 175 4.83% 0321 PERA 2,078 2,718 2,922 3,551 3,721 170 4.79% 0322 GASB 68 Pension expense (7,694) 101 (2,108) - - - 0.00% 0400 Group insurance 3,597 7,237 7,460 6,204 6,281 77 1.25% 0500 Workers compensation 235 281 299 387 398 11 2.84% Total personnel services 44,361 56,627 57,813 61,099 63,821 2,722 4.46% Materials & supplies 1600 Supplies, operating - 50 50 0.00% Total materials & supplies 50 50 0.00% Contractual services 3030 Other professional services 8,296 8,457 8,616 8,683 8,683 - 0.00% 3300 Postage 2,200 2,474 3,174 4,600 4,600 - 0.00% 3430 Printing - 880 4,798 900 900 - 0.00% 3630 Training - 1,176 - 2,400 2,400 - 0.00% 5130 Repairs, equipment 4,444 4,978 4,899 8,571 8,832 261 3.05% Total contractual services 14,940 17,965 21,487 25,154 25,415 261 1.04% Miscellaneous: 9900 Transfers out to General Fund 61,860 80,446 82,859 85,345 87,905 2,560 3.00% 9900 Transfers out to Vehicle Fund 48,000 52,000 55,000 55,000 55,000 - 0.00% Total miscellaneous 109,860 132,446 137,859 140,345 142,905 2,560 1.82% Total Billing 169,161 207,038 217,159 226,648 232,191 5,543 2.45% 124,800 150,411 159,346 165,549 168,370 Infrastructure & Equip Maintenance (4823): Personnel services 100 Salaries, regular 180,628 206,001 245,524 239,795 263,829 24,034 10.02% 110 Salaries, overtime 7,846 7,081 6,813 8,857 9,597 740 8.35% 150 Salaries, part-time 3,190 3,884 4,082 9,300 9,920 620 6.67% 300 Social security 13,812 15,449 18,422 19,734 21,675 1,941 9.84% 321 PERA 14,311 15,413 18,506 18,648 20,509 1,861 9.98% 400 Group insurance 29,872 32,202 38,829 41,640 47,874 6,234 14.97% 500 Workers compensation 5,514 6,742 13,566 15,311 16,194 883 5.77% 600 Unemployment 2,964 - - - - - 0.00% Total personnel services 258,137 286,772 345,742 353,285 389,598 36,313 10.28% Fund: 730 Department: 4820 Account Description 2019 2020 2021 Billing Services 2022 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 8,346 8,513 8,683 8,683 24.5% of audit (22-35,440, 23-36,145, 24-36,870, 25-37,605, 26-38,360) 8,346 8,513 8,683 8,683 3300 Postage 3,300 800 500 3,300 800 500 3,300 800 500 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,600 4,600 4,600 4,600 3430 Printing 450 450 450 450 450 450 450 450 Envelopes Utility bills (1/2 cost) 900 900 900 900 3630 Training 2,400 2,400 2,400 2,400 Seminars on new regulations, software updates, etc. INCODE training 2,400 2,400 2,400 2,400 5130 Repairs, equipment 4,264 - 305 1,250 448 4,477 - 330 1,800 495 4,701 1,200 350 1,800 520 4,936 1,200 350 1,800 546 Incode software support (30%)(5% annual increase per agreement) Incode UB support Neptune reader maintenance (1/2 in water)(2019 first year $610) Neptune software maintenance (1/2 in water) Handheld interface support meter readers (50% water 50% sewer)(Incode) 6,267 1 7,102 8,571 8,832 7030 Capital, equipment - Meter reader (1/2 water 1/2 sewer) 9900 Transfers out 80,446 52,000 82,859 55,000 85,345 55,000 87,905 55,000 Transfer to General Fund for admin costs Transfer to Vehicle & Equipment Fund for vehicle use 132,446 137,859 140,345 142,905 155,009 161,424 165,549 168,370 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Bud et Request Dollar Percent Sanitary Sewer (Fund 730): Materials & supplies 1210 Supplies, bldg & gmds 23 - 133 200 200 - 0.00% 1220 Supplies, vehicles 10,865 6,103 4,072 1,575 5,000 3,425 217.46% 1230 Supplies, equipment 7,999 5,805 2,713 5,350 5,350 - 0.00% 1240 Supplies, streets - 62 - 2,500 2,000 (500) -20.00% 1250 Supplies, utilities 3,936 2,821 509 1,400 2,900 1,500 107.14% 1260 Supplies, traffic control - 132 133 300 300 - 0.00% 1600 Supplies, operating 6,472 5,062 4,785 10,350 8,850 (1,500) -14.49% 1700 Motor fuels 4,356 1,868 2,884 4,680 5,915 1,235 26.39% 2400 Uniforms 1,147 1,391 1,755 1,169 2,169 1,000 85.54% 2410 Mats & towels 611 682 942 728 728 - 0.00% Total materials & supplies 35,409 23,926 17,926 28,252 33,412 5,160 18.26% Contractual services 3030 Other professional services 13,702 19,664 21,922 9,306 26,006 16,700 179.45% 3100 Communications - telephone 2,379 1,931 3,129 2,356 2,356 - 0.00% 3200 Water & sewer 5,558 7,107 4,384 3,300 3,300 - 0.00% 3210 Electricity 1,908 2,406 2,357 2,100 2,100 - 0.00% 3230 Wastewater disposal - MCES 972,248 991,993 1,026,404 1,025,643 1,082,918 57,275 5.58% 3231 Wastewater disposal - Strength chi 2,550 761 - 6,000 6,000 - 0.00% 3610 Memberships 310 425 150 1,690 1,690 - 0.00% 3630 Training 2,684 2,471 861 8,680 7,530 (1,150) -13.25% 4010 Equipment rental 993 168 - 500 500 - 0.00% 4800 Insurance 6,335 5,341 6,129 7,300 7,300 - 0.00% 5130 Repairs, equipment 8,786 7,089 7,237 12,550 12,550 - 0.00% 5140 Repairs, streets - - - 10,000 10,000 - 0.00% 5150 Repairs, utilities 7,551 2,601 - 17,500 17,500 - 0.00% 5160 Repairs, maintenance 13,416 2,754 5,127 13,500 12,500 (1,000) -7.41% Total contractual services 1,038,420 1,044,711 1,077,700 1,120,425 1,192,250 71,825 6.41% Capital outlays 7030 Equipment - - - - - - 0.00% 7050 Construction - - - 205,000 530,000 325,000 158.54% 7950 Depreciation 101,597 97,841 113,690 100,000 100,000 - 0.00% Total capital outlays 101,597 97,841 113,690 305,000 630,000 325,000 106.56% Miscellaneous: 9100 Contingency - - - 15,000 15,000 - 0.00% Total miscellaneous - - - 15,000 15,000 - 0.00% 1,175,426 1,166,478 1,209,316 1,468,677 1,870,662 Total infrastructure & equip maint 1,433,563 1,453,250 1,555,058 1,821,962 2,260,260 438,298 24.06% Total expenditures 1,602,724 1,660,288 1,772,217 2,048,610 2,492,451 443,841 21.67% Revenues over (under) expenditures 107,879 286,874 134,608 (157,090) (535,778) (378,688) 241.06% Add back: capital outlays - - - 205,000 530,000 325,000 158.54% Change in net assets 107,879 286,874 134,608 47,910 (5,778) (53,688)-112.06% Net Assets, beginning of year 3,915,386 4,023,265 4,310,139 4,444,747 4,492,657 47,910 1.08% Net Asset, end of year $ 4,023,265 $ 4,310,139 $ 4,444,747 $ 4,492,657 $ 4,486,878 $ (59,467) -1.32% 1,300,226 1,316,889 1,368,662 1,634,226 2,039,032 Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance Account Description 2019 2020 2021 2022 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 925 Fluids 125 125 125 2,500 Repair & replacement parts 600 600 600 1,500 Tires & batteries 1,575 1,575 1,575 5,000 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 1,000 1,000 1,000 Camera track and parts (CCTV) 300 300 300 300 Minor repairs 100 100 100 100 Gas detection device parts and supplies 4,000 2,000 2,000 2,000 Vactor cleaning nozzle parts and supplies (nozzle 2017, hose 2018) 8,350 5,350 5,350 5,350 1240 Supplies, streets 200 200 200 200 Tack coat 300 300 300 300 Dewatering rock/agg. base 2,000 2,000 2,000 1,500 Asphalt mix 2,500 2,500 2,500 2,000 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 300 300 300 300 Manhole covers, adjust rings & bolts 1,400 1,400 1,400 2,900 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 1,500 1,500 1,500 1,500 First aid supplies, protective equip (add hearing equipment for 2017) 400 200 200 200 CD's, DVD's, software 250 250 250 250 Engineering supplies 700 700 700 700 Shop supplies, fastners, soap, degreasers, steet, batteries 500 500 500 500 Pipe, fittings, and accessories (connectors) 500 500 500 500 Locating supplies (paint, flags, markers, etc.) 5,000 5,000 5,000 3,500 Chemical blocks for lift stations 300 300 300 300 Filter replacement for sewer gas monitors 10,550 10,350 10,350 8,850 1700 Motor fuels & lubs 300 300 300 300 Fluids 600 600 600 600 Motor oil - 100 gallons $6 gal. 1,300 1,300 1,300 1,375 Unleaded fuel 500 gallons @ $2.75 2,480 2,480 2,480 3,640 Diesel fuel 800 gallons @ $3.30 4,680 4,680 4,680 5,915 2400 Uniforms 1,169 1,169 1,169 2,169 Uniforms 18.2% of $9,995 and clothing 2.0 FTE x $175 per contract 1,169 1,169 1,169 2,169 2410 Mats & towels 728 728 728 728 Share of floor mats & shop towels (18.2% of $4,000) 728 728 728 728 3030 Other professional services 750 750 750 750 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,106 1,106 1,106 Annual generator service/inspection 1,000 1,000 1,000 1,000 Asset management software 3,000 3,000 3,000 3,000 Arcview/GIS base map and engineering consulting 2,750 2,750 2,750 2,750 Safety Data Service (1/3 Water, 1/3 Storm Water) 12,000 16,700 Sewer I&I monitoring 20,200 9,306 9,306 26,006 3100 Communications - telephone 1,785 1,785 1,785 1,785 Cellular phone service (19.4% of $9,200) 211 211 481 481 Data cards for SCADA (4)(25%) bal. in Water (40.01 per card per month) 90 90 90 90 800 Mhz radio license fee (33%)(5 radios @ $4.48 per month) 2,086 2,086 2,356 2,356 3200 Water & Sewer service 3,300 3,300 3,300 3,300 Estimated annual charge 3,300 3,300 3,300 3,300 [7775- Electricity 2,100 2,100 2,100 2,100 Electricity for lift stations 2,100 2,100 2,100 2,100 59,138 45,044 45,314 67,174 AI, THIS PAGE LEFT BLANK INTENTIONALLY Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance (continued) Account Description 2019 2020 2021 2022 Description 3230 Met Council Environ. Servies MCI 991,993 1,024,104 1,025,643 1,082,918 Annual charge (0.15% increase in 2021) 991,993 1,024,104 1,025,643 1,082,918 3231 MCES Strength charges 6,000 6,000 6,000 6,000 Strength Charge 6,000 6,000 6,000 6,000 3610 Memberships 120 120 120 120 MN Rural Water Assoc. (50%) - 1,400 1,400 1,400 Wincam membership 70 70 70 70 Suburban Utility Superintendant Association (SUSA)(50% of $100) 100 100 100 100 MN Safety Council (20%) 290 1,690 1,690 1,690 3630 Training 1,800 1,800 1,800 1,500 Collection operators training/renewal ($300 per person) 560 400 400 400 Tuition reimbursement (PW Mgt. Class - North Hennepin CC) 250 150 150 150 Computer training/webinars 110 110 110 110 Hearing test/R2K (2.15 FTE * $50) 1,700 1,200 1,200 900 Confined space/trench safety alternate years) - 2,400 2,400 2,100 DACP Training - 1,200 1,200 1,200 Class A license 1,950 1,000 1,000 750 Miscellaneous wastewater training (certified pipe inspector) 60 60 60 60 Maintenance Expo 390 300 300 300 Equipment operator training 60 60 60 60 Work zone safety seminar (every 3 years next 2020) 6,880 8,680 8,680 7,530 4010 Rental, equipment 500 500 500 500 Barricades & signs 500 500 500 500 4800 Insurance 7,300 7,300 7,300 7,300 Share ofproperty/liability insurance 7,300 7,300 7,300 7,300 5130 Repairs, equipment 8,000 8,000 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 1,050 1 1,050 Misc repairs 11,750 11,750 12,550 12,550 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 5,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 3,000 Sewer debris disposal costs 13,500 13,500 13,500 12,500 7050 Construction > $25000 138,000 175,000 175,000 500,000 Sewer pipe relining program - 25,000 30,000 30,000 Manhole lining 166,000 130,000 Upgrade Bronson lift station and nat gas generator (carryover from 2019) 304,000 330,000 205,000 530,000 7950 Depreciation 95,000 100,000 100,000 100,000 Estimated depreciation 95,000 100,000 100,000 100,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 1,538,851 1,591,068 1,468,677 1,870,662 y• 2022 Budget Summary 2018 2019 2020 2021 2022 Change from 2021 Actual Actual Actual Budget Request Dollar Percent Street Lighting (Fund 740): Revenues 3610 Investment income 1,921 4,085 2,269 1,400 1,400 - 0.00% 3716 Penalties 826 966 492 700 700 - 0.00% 3740 Street lighting charges 103,496 103,901 103,917 104,412 104,412 - 0.00% Total revenue 106,243 108,952 106,678 106,512 106,512 - 0.00% Operating expenses Operations (4416) Personnel services 0100 Salaries, regular 5,335 6,714 10,556 9,056 9,638 582 6.43% 0110 Salaries, overtime 179 216 467 - - - 0.00% 0300 Social security 422 509 740 692 737 45 6.50% 0321 PERA 424 512 754 605 643 38 6.28% 0400 Group insurance 936 1,239 1,579 890 1,008 118 13.26% 0500 Workers compensation 244 254 273 339 376 37 10.91% Total personnel services 7,540 9,444 14,369 11,582 12,402 820 7.08% Materials & supplies 1600 Supplies, operating 90 - - 1,000 1,000 - 0.00% Contractual services 3210 Electricity 76,685 74,287 85,607 78,500 82,500 4,000 5.10% 4800 Insurance 621 658 756 900 900 - 0.00% 5150 Repairs, utilities 111 1,402 1,508 2,950 2,950 - 0.00% 5160 Repairs, system maintenance - - 21431 - - - 0.00% Total contractual services 77,417 76,347 90,302 82,350 86,350 4,000 4.86% Other 8011 Lease payable -principal (ESP) - - - - - - 0.00% 8021 Lease payable - interest (ESP) 2,118 1,902 3,232 - - - 0.00% 9900 Transfer to General Fund 2,771 2,854 2,940 3,028 3,119 91 3.01% Total other 4,889 4,756 6,172 3,028 3,119 91 3.01% 0 Total expenditures 89,936 90,547 110,843 97,960 102,871 4,911 5.01% Revenues over (under) expenditures 16,307 18,405 (4,165) 8,552 3,641 (4,911) -57.43% Add back: Capital outlays/Prin on debt - - - - - - 0.00% Change in net assets 16,307 18,405 (4,165) 8,552 3,641 (4,911)-57.43% Net assets, beginning year 73,757 90,064 108,469 104,304 112,856 8,552 8.20% Net assets, end of year $ 90,064 $ 108,469 $ 104,304 $ 112,856 $ 116,497 $ 3,641 3.23% 82,396 81,103 96,474 86,378 90,469 97 Fund: 740 Street Lighting Fund Revenues Account Description 2019 2020 2021 2022 Description 3610 Interest revenue 1,400 1,400 1,400 1,400 Estimated interest earnings at 1%. 1,400 1,400 1,400 1,400 3716 Penalties 500 700 700 700 Estimated late fees on street lighting charges. 500 700 700 700 3740 Street lighting charges 103,902 104,412 104,412 104,412 Estimated utility charges for street lighting. 103,902 104,412 104,412 104,412 und: 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 75,000 78,500 78,500 82,500 Estimate 75,000 78,500 78,500 82,500 4900 Insurance 900 900 900 900 Share of property/liability insurance 900 900 900 900 5150 Repairs, utilities 3,000 2,950 2,950 1 2,950 Repairs to street and trail lighting. 3,000 2,950 2,950 2,950 8011 8021 Lease payable (principal) Lease payable (interest) 7,349 1,902 7,572 1,680 - - Energy savings program (LED trail lighting) Interest 9,251 9,252 9900 Transfer out 2,854 2,940 3,028 3,119 Transfer to General Fund for administrative overhead costs 2,854 2,940 3,028 31119 92,005 95,542 86,378 90,469 5.85% 3.84% -9.59% 4.74% y i 2022 Budget Summary 2018 2019 2020 2021 2022 Changefrom 2021 Actual Actual Actual Budget Request Dollar Percent Storm Water (Fund 745): Revenues 3359 Other state grants 473 155 218 - - - 0.00% 3610 Investment income (charges) 27,352 56,980 34,677 16,000 16,000 - 0.00% 3716 Penalties & interest 2,144 2,683 1,502 1,500 1,500 - 0.00% 3718 Impact charges 3,196 10,716 1,250 - - - 0.00% 3730 Surface water charges 287,091 314,351 340,809 320,000 400,500 80,500 25.16% Total revenue 320,256 384,885 378,456 337,500 418,000 80,500 23.85% Operating expenses System Maintenance (4415): Personnel services 0100 Salaries, regular 73,985 81,732 97,585 93,884 97,984 4,100 4.37% 0110 Salaries, overtime 1,345 2,429 3,355 1,422 1,465 43 3.02% 0150 Salaries, part-time 7,012 7,451 4,560 3,300 10,240 6,940 210.30% 0300 Social security 6,089 6,814 7,666 7,542 8,392 850 11.27% 0321 PERA 5,377 6,033 6,762 7,148 7,459 311 4.35% 0322 GASB 68 Pension expens (2,671) 218 4,495 - - - 0.00% 0400 Group insurance 3,020 4,378 6,317 15,197 17,218 2,021 13.30% 0500 Workers compensation 2,087 2,298 2,521 2,865 3,192 327 11.41% 600 Unemployment 1,482 - - - - - 0.00% Total personnel services 97,726 111,353 133,261 131,358 145,950 14,592 11.11% Materials & supplies 1230 Supplies, equipment 6,064 7,189 5,372 6,750 2,750 (4,000)-59.26% 1240 Supplies, streets - 50 - - - - 0.00% 1600 Supplies, operating 6,093 1,578 6,007 4,925 4,925 - 0.00% 1700 Motor fuels 602 1,547 1,951 2,340 2,475 135 5.77% 2400 Uniforms 292 972 482 470 470 - 0.00% 2410 Mats & towels 245 245 241 292 292 - 0.00% Total materials & supplies 13,296 11,581 14,053 14,777 10,912 (3,865)-26.16% Contractual services 3030 Other professional services 42,071 29,757 30,171 12,292 162,292 150,000 1220.31% 3100 Telephone 913 1,015 1,007 872 872 - 0.00% 3610 Memberships 1,030 1,033 1,055 1,045 1,045 - 0.00% 3630 Training 1,393 555 161 1,695 1,695 - 0.00% 4010 Equipment rental 485 - 5,165 3,000 3,000 - 0.00% 4800 Insurance 2,759 2,926 3,359 4,000 4,000 - 0.00% 5120 Repairs, vehicles 1,246 96 490 1,500 1,500 - 0.00% 5150 Repairs, utilities 4,220 40,959 90,461 90,000 90,000 - 0.00% Total contractual services 54,117 76,341 131,869 114,404 264,404 150,000 131.11% Capital outlays 7030 Equipment - - - 15,000 - (15,000)-100.00% 7050 Construction - - 35,910 75,000 75,000 - 0.00% 7950 Depreciation 39,016 36,566 35,916 35,000 35,000 - 0.00% Total capital outlays 39,016 36,566 71,826 125,000 110,000 (15,000)-12.00% Miscellaneous: 9900 Transfer out 81067 8,309 8,558 8,815 8,815 - 0.00% Total miscellaneous 8,067 8,309 8,558 8,815 8,815 - 0.00% Total System Maintenance 212,222 244,150 359,567 394,354 540,081 145,727 0.00% 114,496 132,797 226,306 262,996 394,131 0.00% y. 5 Storm Water Accoant Description 2019 2020 2021 Revenues 2022 Description 3610 Interest revenue 16,000 16,000 16,000 16,000 Estimated interest earnings at 1 %. 16,000 16,000 16,000 16,000 3716 Penalties 1,500 1,500 1,500 1,500 Estimated late payment fees. 1,500 1,500 1,500 1,500 3730 Utility sales 285,000 285,000 320,000 340,000 Estimated surface water charges. 285,000 285,000 320,000 340,000 Fund: 745 Department: 4415 System Maintenance 1230 Supplies, equipment < $5000 1,500 1,000 250 1,500 1,000 250 1,500 1,000 250 4,000 1,500 1,000 250 - Miscellaneous equipment & parts (AEBI parts, pole camera parts) Filters, brakes, bulbs, wipers, tires, batteries, etc... Hoses & nozzles Drone 2,750 2,750 6,750 2,750 1600 Supplies, operating 250 2,000 175 150 150 2,000 450 2,000 175 150 150 2,000 450 2,000 175 150 150 2,000 450 2,000 175 150 150 2,000 Concrete Rain Garden mix, riprap, topsoil, seed and sod Concrete adjustment rings Hand tools CD's, DVD's, software upgrade for camera van 1 Catch basin castings, pipe, approns, etc... 4,725 4,925 4,925 4,925 1700 Motor fuels 2,250 2,250 2,340 2,475 900 gallons unleaded @ $2.75 for utility truck 2,250 2,250 2,340 2,475 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 1 292 3030 Other professional services 5,750 - 1,500 1,000 100 1,192 2,750 5,750 - 1,500 1,000 100 1,192 2,750 5,750 - 1,500 1,000 100 1,192 2,750 5,750 150,000 1,500 1,000 100 1,192 2,750 Consulting engineers (LGU) Storm water system maintenance study Arcview/GIS base map consulting Asset management software Fire extinguisher inspection/servcie (5 @ $20) 3.5% of audit (22-35,440, 23-36,145, 24-36,870, 25-37,605, 26-38,360) Safety Data Service (1/3 Water, 1/3 Sewer) 12,292 12,292 12,292 162,292 3100 Communications 782 90 782 90 782 90 782 90 Cell Phone (8.5% of $9,200) 800 Mhz radio license fee (33%)(5 radios @ $4.48 per month) 872 872 872 872 3610 Memberships 200 800 45 200 800 45 200 800 45 200 800 45 American Public Works Association (APWA)(25% of $800) Minnesota Cities Storm Water Coalition MN Safety Council 1,045 1,045 1,045 1,045 3630 Training 200 55 350 500 270 220 100 200 55 350 500 270 220 100 200 55 350 500 270 220 100 200 55 350 500 270 220 100 Seminars & training sessions(Stormwater) Hearing test/R2K (LI FTE * $50) Safety training NPDES compliance training Erosion & Stormwater Maint. Certification Equipment operator training Computer/webinar training 1,695 1,695 1,695 1,695 4010 Equipment rental 6,000 6,000 3,000 3,000 Rent mini excavater for clean -outs 6,000 6,000 3,000 3,000 4800 Insurance 2,500 1500 2,500 1500 2,500 1500 2,500 1,500 Share of property/liability insurance 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 30,000 50,000 30,000 30,000 60,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 Repair & maintain storm sewers, ponds, basins, and drainage issues Storm sewer cleaning Storm Sewer slip Tinning improvements 110,000 120,000 90,000 90,000 7030 Equipment > $5000 30,000 30,000 15,000 - Silverview pond aerators 30,000 30,000 15,000 1 - 7050 Construction > $25000 75,000 75,000 75,000 75,000 Storm water projects 75,000 75,000 75,000 75,000 7950 Depreciation 35,000 35,000 35,000 35,000 Estimated depreciation 35,000 35,000 35,000 35,000 9900 Transfer out 8,309 8,558 8 815 8 815 General Fund 8,309 8,558 8,815 8,815 296,200 306,649 262,996 394,131 100 2022 Budget Summary 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 1230 Supplies, equipment 1600 Supplies, operating 1700 Motor fuels 2400 Uniforms 2410 Mats & towels Total materials & supplies Contractual services 3030 Other professional services 3530 Disposal 3630 Training 5130 Repairs, equipment Total contractual services Miscellaneous: 9900 Transfer out Total miscellaneous Total street sweeping Total expenditures Revenues over expenditures Add back: Capital outlays Change in net asssets Net assets, beginning year Accounting Change GASB 68 pension Net assets, end of year 2018 2019 2020 2021 2022 Changefrom 2021 Actual Actual Actual Budget Request Dollar Percent 12,920 13,366 13,830 13,150 13,544 394 3.00% 374 402 707 1,422 1,465 43 3.02% 982 1,018 1,080 1,115 1,148 33 2.96% 958 992 1,064 1,093 1,126 33 3.02% 856 866 910 2,544 2,880 336 13.21% 507 549 515 654 657 3 0.46% 16,597 17,193 18,106 19,978 20,820 842 4.21% 1,635 8 - 2,500 2,500 - 0.00% 983 279 2,850 3,500 3,500 - 0.00% 3,390 3,147 2,776 3,800 4,300 500 13.16% 67 102 70 116 116 - 0.00% 57 58 56 72 72 - 0.00% 6,132 3,594 5,752 9,988 10,488 500 5.01% 424 8,688 - - - 0.00% - - 25,000 10,000 (15,000)-60.00% 30 - - 280 280 - 0.00% 6,657 1,608 - 4,000 4,000 - 0.00% 7,111 10,296 - 29,280 14,280 (15,000)-51.23% 32,000 31,000 33,000 33,000 35,000 2,000 6.06% 32,000 31,000 33,000 33,000 35,000 2,000 6.06% 61,840 62,083 56,858 92,246 80,588 (11,658)-12.64% 45,243 44,890 38,752 72,268 59,768 274,062 306,233 416,425 486,600 620,669 134,069 27.55% 46,194 78,652 (37,969) (149,100) (202,669) (53,569) 35.93% 910 90,000 75 -16.67% 46,194 78,652 (2,059) (59,100) (127,669) (68,569) 116.02% 3,182,828 3,229,022 3,307,674 3,305,615 3,246,515 (59,100) -1.79% $ 3,229,022 $ 3,307,674 $ 3,305,615 $ 3,246,515 $ 3,118,846 $ (127,669) -3.93% 159,739 177,687 265,058 335,264 453,899 101 5 Department: 4417 1230 Supplies, equipment < $5000 2,500 2,500 2,500 Street Cleaning 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 2,300 700 100 400 Gutter brooms Belts, pumps, hoses, filters, etc... for sweeper Gloves, hearing protection, etc... 2 dirt shoes 3,500 3,500 3,500 3,500 1700 Motor fuels 2,800 1,000 2,800 1,000 2,800 1,000 3,300 1,000 Diesel fuel- 1000 gallons @ $3.30 Hydraulic oil - 4 changes 3,800 3,800 3,800 4,300 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 1 72 Share of floor mats & shop towels (1.8% of $4,000) 72 72 72 72 3530 Disposal 50,000 50,000 25,000 10,000 Sweeping pile disposal (estimated 5 year project) 50,000 50,000 25,000 10,000 3630 Training 250 30 250 30 250 30 250 30 NPDES compliance training Maintenance Expo 280 280 1 280 280 5130 Repairs, equipment 4,000 4,000 4,000 1 4,000 Sweeper repairs 4,000 4,000 4,000 4,000 9900 1 Transfer out to Vehicle & Equip 31,000 33,000 33,000 35 000 Transfer to Vehicle & Equip Fund for future replacements 31,000 33,000 33,000 35,000 95,268 97,268 72,268 59,768 391,468 403,917 335,264 453,899 -3.85% 3.18%-17.00% 35.39% 102 THIS PAGE LEFT BLANK INTENTIONALLY 103 MoUNns ViEw MEMORANDUM To: Mounds View City Council From: Don Peterson, Director of Public Works/Parks and Recreation Nyle Zikmund, City Administrator RE: December 6, 2021 Work Session — Storm Water Management RFP Purpose of Work Session: 1. Achieve consensus on issuance of RFP for assessment of system. Background: At the July 6, 2021 Work Session the Council reviewed information on the Storm Water infrastructure including a review on the following: • Regulations • Local Surface Water Management Plan (LSWMP) • Sub -Districts • Past Assessments • RFP Process • Funding for Storm Water Management • Future Needs At the conclusion of the discussion Council gave consensus to have Staff move forward with the RFP process. RFP Process: Staff prepared the Storm Water RFP assessment and sent this to Stantec Services, Barr Engineering, and AE2S. Staff received two proposals, from Stantec and AE2S. (Barr Engineering elected to not submit a proposal.) The cost proposal from AE2S is $75,500.00, and the cost proposal from Stantec is $154,215.00. Upon reviewing the proposals, Staff met with Stantec to discuss their proposal and associated costs. Staff also meet with AE2S to further understand the low bid amount. Stantec provided a much more detailed proposal and it was determined that not all of the fees would be applied to each individual storm water pond. These savings will vary from $13,000 to $20,000. Stantec also focused on the Capital Improvement portion in the proposal which will assist the City to develop a Capital Project Plan and budget for the Storm Water department. Stantec will also assist Staff to develop maintenance needs and schedule, for each storm water pond. Staff as well as Stantec will be in attendance at the Work Session to discuss this proposal with the City Council and determine how the City Council would like to proceed with the Storm Water Management Pond Assessment and Rehabilitation RFP. MOUNDS VIEW of Mounds View Staff R1 Item No: XX Meeting Date: Sept 7, 2021 Type of Business: WS Administrator Review: To: Honorable Mayor and City Council From: Don Peterson, Director of Public Works/Parks and Recreation Item Title/Subject: Water Meter Replacement Program Background/Discussion: One of the most important services provided by Public Works is a reliable source of drinking water for the community. The cost associated with doing this is significant with over $55 million invested by the City of Mounds View in the infrastructure (tower, mains, wells, and treatment plants), an additional $6.2 million in calendar years 2021-2022 to upgrade and rehabilitate our three water treatment plants, and yearly operational costs of just over $500,000. The City knows exactly how much water is pumped out of the ground based on data from the meters at each well. The ability to validate or reconcile how much water use or loss there may be is accomplished thru metering on the user end. We are able to accurately estimate unmetered flows as they are typically limited to hydrant flushing and fire suppression. All remainder water use should go through a water meter. We also know the current difference between our measured pumping and our metered billing is greater than the estimated unmetered flow, the difference can only be inaccurate meters and leaks in the line. Commercial meters are, in most cases, from their initial installation and are over 40 years old; multi -family meters would fall under the same category and should also be compound meters in which most are not. The average "life" of a meter is between 20-25 years. Water meters were last replaced in 1996 — 1997 therefore they will be 26 years old. In 2007 - 2008 the meter readers were replaced due to the result of losing 1,300 readings in one year. Staff has researched the new meter and reader technology and selected the Muller water meter with the AMI radio reading system. Staff in coordination with the City Attorney, developed a Request for Proposal (RFP) for the meter replacement program. In the RFP the vendor would be required to supply and replace all the residential meters, while Public Works Staff would replace the Commercial water meters. The RFP also includes new radio reading technology with the potential of fixed antenna(s) to read the meters. This would eliminate the need for Public Works Staff to drive the City and collect the readings off the water meters. The Mounds View Vision A Thriving Desirable Community Winwater the primary vendor for the proposed new water meters and reading system, contacted Staff to propose a partnership with a local City business on new reading technology. Staff met with Winwater, Mueller Meter Systems and MultiTech on November 22, 2021 to learn more about the new reading technology and potential opportunity to partner with these vendors for the City of Mounds View water meter replacement program. Multi -Tech has a developed a reading radio reading system called LoRaWAN, this reading technology has been in use in Europe for over 8 years and has been utilized in the Natural Gas and Oil Industry for several years. Multi -Tech believes this could be used with local communities with the drinking water system. This system can also have other potential uses for the City such as connecting the lift stations and water treatment plants to the SCADA system, along with the connecting the park Shelter Buildings to the electronic door lock system. Winwater, Muller Meter Systems, and Multi -Tech have provided a proposal to the City of Mounds View to partner with them in installing and testing this new reading technology. The proposal includes discounts on gateways, antennas, readers and reduced labor costs for the installation. Staff will be in attendance at the Work Session to discuss this proposal with the City Council and determine how the City Council would like to proceed with the water meter replacement program. Respectfully Don Peterson Director of Public Works/Parks and Recreation The Mounds View Vision A Thriving Desirable Community MOUNDitsm—EW of Mounds View Staff R To: Honorable Mayor and City Council From: Nyle Zikmund, City Administrator Item Title/Subject: CUP's Feedback Introduction: Item No: 5 Meeting Date: December 6, 2021 Type of Business: Council Workshop City Administrator Review: Development/redevelopment issues challenge staff and council equally. The challenge of striving for the highest and best use simultaneous with neighborhood acceptance (or opposition) result in numerous dynamics. Staff has discussed moving the initial discussion on proposals to workshop given the informal nature of the meeting allowing for a more robust, free flowing discussion. Handling it as part of a council item, absent some opportunity to discuss in depth; is not ideal - but sometimes required due to 60 day requirement. The property owner also can become frustrated (as well as the applicant) and provides further cause to explore options in a more suitable setting. On that note, the property owners of the former Fedors Market are now requesting feedback specific to a Flea Market to include outside sales weather permitting. The owner of the building is an aggressive marketer and will continue to bring proposals forward. Does council have a specific vision for the property/area and what might fit that vision? Note — the owner has made significant repairs to the property suggesting tear down/removal is not an option. The challenge will be balancing what is ideal from the City perspective with the reality of what the market will bring. Staff is looking for some discussion on process and feedback on the Flea Market proposal. Respectfully submitted, Nyle Zikmund City Administrator The Mounds View Vision A Thriving Desirable Community THIS PAGE LEFT BLANK INTENTIONALLY • y, of Mounds View Staff R To: Honorable Mayor and City Council From: Nyle Zikmund, City Administrator Item Title/Subject: Charitable Gambling Funds Introduction: Item No: 6 Meeting Date: December 6, 2021 Type of Business: Council Workshop City Administrator Review: In 2019 Council took action to utilize state statute regarding charitable gambling licenses which provides for the regulating municipality to "collect/impose" a administrative fee/assessment on the proceeds. The law details that amount not to exceed 10% of the net profit. 2020 was the first full year the policy was in place. Historically we have had two locations, Moe's and the Mermaid with Charitable Gambling. Until recently, there were two licenses but now a third has been added with two at the Mermaid. Revenue based on the statute/ordinance has been received and tallies just under $5,000. State Statute 349.12 sets forth most of the regulations with subdivision 25 detailing authorized expenditures from proceeds/revenue collected. The list is rather exhaustive with 26 sub -categories, many of them having multiple applications within them such as #1 which states any 501 (c) 3, or festival organization .... Attachment A is a copy of the entire section. Collections for 2021 will occur shortly after the first of the year and we expect to have those received sometime in the first quarter. Next Steps: A recent request (YMCA Youth in Government) has resulted in Staff seeking input from Council on how distributions are made. Options include: 1. Deal with on case -by -case basis. 2. Allocate shortly after receiving to desired entities 3. Allocate a set portion but leave a remainder for case by case situations. Action Requested: 1. Provide staff general direction for development of a policy/administration. 2. Act on request from YMCA to cover busing cost for transportation youth to St. Paul to participate in Government for a Day. Request is in the amount of $279.72 Respectfully submitted, Nyle Zikmund City Administrator The Mounds View Vision A Thriving Desirable Community MINNESOTA STATUTES 2021 349.12 349.12 DEFINITIONS. Subdivision 1. Scope. As used in sections 349.11 to 349.23 the terms in this section have the meanings given them. Subd. 2. Active member. "Active member" means a member: (1) who has paid all dues to the organization; (2) who is 18 years of age or older; (3) who has equal voting rights with all other members; (4) who has equal opportunity to be an elected officer; (5) who has equal right and responsibilities of attendance at the regularly scheduled meetings of the organization; (6) whose name and membership origination date appear with the member's knowledge and consent on a list of members of the organization; and (7) who has been a member of the organization for at least the most recent 90 days. Subd. 3. Affiliate. "Affiliate" is any person or entity directly or indirectly controlling, controlled by, or under common control or ownership with a licensee of the board or any officer or director of a licensee of the board. Subd. 3a. Allowable expense. "Allowable expense" means the percentage of the total cost incurred by the organization in the purchase of any good, service, or other item which corresponds to the proportion of the total actual use of the good, service, or other item that is directly related to conduct of lawful gambling. Subd. 3b. Bar operation. "Bar operation" means a method of selling and redeeming disposable gambling equipment by an employee of the lessor within a leased premises which is licensed for the on -sale of alcoholic beverages. Subd. 3c. Bar bingo. "Bar bingo" is a bingo occasion conducted at a permitted premises in an area where on -sale intoxicating liquor or on -sale 3.2 percent malt beverages are sold and where a licensed organization conducts another form of lawful gambling and consents to the conduct of bar bingo on the premises. Bar bingo does not include bingo games linked to other permitted premises. Subd. 4. Bingo. "Bingo" means a game where each player has a bingo hard card, bingo paper sheet, or facsimile of a bingo paper sheet when used in conjunction with an electronic bingo device, for which a consideration has been paid, and played in accordance with this chapter and with rules of the board for the conduct of bingo. "Bingo" also includes a linked bingo game. Subd. 5. Bingo occasion. "Bingo occasion" means a single gathering or session at which a series of one or more successive bingo games is played. There is no limit on the number of games conducted during a bingo occasion. A bingo occasion must not last longer than eight consecutive hours, except that linked bingo games played on electronic bingo devices may be played during regular business hours of the permitted premises, and all play during this period is considered a bingo occasion for reporting purposes. For permitted premises where the primary business is bingo, regular business hours shall be defined as the hours between 8:00 a.m. and 2:00 a.m. Subd. 6. Board. "Board" is the Gambling Control Board. Official Publication of the State of Minnesota Revisor of Statutes 349.12 MINNESOTA STATUTES 2021 2 Subd. 6a. Booth operation. "Booth operation" means a method of selling and redeeming disposable gambling equipment by an employee of a licensed organization in a premises the organization leases or owns. Subd. 7. Capital assets. "Capital assets" means property, real or personal, except gambling equipment, with an expected useful life of at least two years and a minimum value of $2,000. Subd. 7a. Charitable contribution. "Charitable contribution" means one or more of the lawful purposes expenditures under subdivision 25, paragraph (a), clauses (1) to (7), (10) to (15), and (19). Subd. 8. Checker. "Checker" means a person who records the number of bingo hard cards purchased and played during each game and records the prizes awarded to the recorded hard cards, but does not collect the payment for the hard cards. Subd. 8a. Continuation raffle. "Continuation raffle" means the selection of winning entries from previously selected winning entries until a final selection of winning entries is determined and no additional consideration is required beyond the initial consideration to enter the raffle. A continuation raffle may be conducted over a period of time but cannot exceed 12 months. Subd. 9. Deal. "Deal" means each separate package, or series of packages, consisting of one game of pull -tabs or tipboards with the same serial number. Subd. 10. Director. "Director" is the director of the Gambling Control Board. Subd. 11. Distributor. "Distributor" is a person who sells gambling equipment for use within the state to licensed organizations, or to organizations conducting excluded or exempt activities under section 349.166. Subd. 11 a. Distributor salesperson. "Distributor salesperson" means a person who in any manner receives orders for gambling equipment or who solicits a licensed, exempt, or excluded organization to purchase gambling equipment from a licensed distributor. Subd. 12. [Repealed, 1991 c 233 s 110] Subd. 12a. Electronic bingo device. "Electronic bingo device" means a handheld and portable electronic device that: (1) is used by a bingo player to: (i) monitor bingo paper sheets or a facsimile of a bingo paper sheet purchased and played at the time and place of an organization's bingo occasion, or to play an electronic bingo game that is linked with other permitted premises; (ii) activate numbers announced or displayed, and to compare the numbers to the bingo faces previously stored in the memory of the device; (iii) identify a winning bingo pattern or game requirement; and (iv) play against other bingo players; (2) limits the play of bingo faces to 36 faces per game; (3) requires coded entry to activate play but does not allow the use of a coin, currency, or tokens to be inserted to activate play; (4) may only be used for play against other bingo players in a bingo game; Official Publication of the State of Minnesota Revisor of Statutes MINNESOTA STATUTES 2021 349.12 (5) has no additional function as an amusement or gambling device other than as an electronic pull -tab game defined under section 349.12, subdivision 12c; (6) has the capability to ensure adequate levels of security internal controls; (7) has the capability to permit the board to electronically monitor the operation of the device and the internal accounting systems; and (8) has the capability to allow use by a player who is visually impaired. Subd. 12b. Electronic pull -tab device. "Electronic pull -tab device" means a handheld and portable electronic device that: (1) is used to play one or more electronic pull -tab games; (2) requires coded entry to activate play but does not allow the use of coin, currency, or tokens to be inserted to activate play; (3) requires that a player must activate or open each electronic pull -tab ticket and each individual line, row, or column of each electronic pull -tab ticket; (4) maintains information pertaining to accumulated win credits that may be applied to games in play or redeemed upon termination of play; (5) has no spinning reels or other representations that mimic a video slot machine; (6) has no additional function as a gambling device other than as an electronic -linked bingo game played on a device defined under section 349.12, subdivision 12a; (7) may incorporate an amusement game feature as part of the pull -tab game but may not require additional consideration for that feature or award any prize, or other benefit for that feature; (8) may have auditory or visual enhancements to promote or provide information about the game being played, provided the component does not affect the outcome of a game or display the results of a game; (9) maintains, on nonrescttable meters, a printable, permanent record of all transactions involving each device and electronic pull -tab games played on the device; (10) is not a pull -tab dispensing device as defined under subdivision 32a; and (11) has the capability to allow use by a player who is visually impaired. Subd. 12c. Electronic pull -tab game. 'Electronic pull -tab game" means a pull -tab game containing: (1) facsimiles of pull -tab tickets that are played on an electronic pull -tab device; (2) a predetermined, finite number of winning and losing tickets, not to exceed 7,500 tickets; (3) the same price for each ticket in the game; (4) a price paid by the player of not less than 25 cents per ticket; (5) tickets that are in conformance with applicable board rules for pull -tabs; (6) winning tickets that comply with prize limits under section 349.211; Official Publication of the State of Minnesota Revisor of Statutes 349.12 MINNESOTA STATUTES 2021 (7) a unique serial number that may not be regenerated; 4 (8) an electronic flare that displays the game name; form number; predetermined, finite number of tickets in the game; and prize tier; and (9) no spinning reels or other representations that mimic a video slot machine. Subd. 12d. Electronic pull -tab game system. "Electronic pull -tab game system" means the equipment leased from a licensed distributor and used by a licensed organization to conduct, manage, and record electronic pull -tab games, and to report and transmit the game results as prescribed by the board and the Department of Revenue. The system must provide security and access levels sufficient so that internal control objectives are met as prescribed by the board. The system must contain a point of sale station. Subd. 12e. Electronic raffle selection system. "Electronic raffle selection system" means a system which uses a random number generator to select winning raffle numbers and includes raffle sales devices. Subd. 13. Face value. "Face value" means the price per ticket printed on the ticket or the flare. Subd. 14. [Repealed, 2002 c 386 art 1 s 12] Subd. 15. 501(c)(3) organization. "501(c)(3) organization" is an organization exempt from the payment of federal income taxes under section 501(c)(3) of the Internal Revenue Code. Subd. l 5a. MS 2010 [Renumbered subd 15c] Subd. 15b. 501(c)(19) organization. "501(c)(19) organization" is an organization exempt from the payment of federal income taxes under section 501(c)(19) of the Internal Revenue Code. Subd. 15c. Festival organization. "Festival organization" is an organization conducting a community festival that is exempt from the payment of federal income taxes under section 501(c)(4) of the Internal Revenue Code. Subd. 16. Flare. "Flare" is the posted display, with registration stamp affixed or bar code imprinted or affixed, that sets forth the rules of a particular game of pull -tabs or tipboards and that is associated with a specific deal of pull -tabs or grouping of tipboards. Subd. 16a. Fraternal organization. "Fraternal organization" means a nonprofit organization which is a branch, lodge, or chapter of a national or state organization registered by the Internal Revenue Service as a 501(c)8 or a 501(c)10 nonprofit organization and exists for the common business, fraternal, or other interests of its members. The term does not include college and high school fraternities and sororities. Subd. 17. Free play. "Free play" means a winning ticket that is labeled as a free play or its equivalent. Subd. 18. Gambling equipment. "Gambling equipment" means gambling equipment that is either disposable or permanent gambling equipment. (a) Disposable gambling equipment includes the following: (1) bingo hard cards or paper sheets, including linked bingo paper sheets; (2) paper and electronic pull -tabs; (3) jar tickets; (4) paddle tickets and paddle ticket cards; Official Publication of the State of Minnesota Revisor of Statutes MINNESOTA STATUTES 2021 349.12 (5) tipboards and tipboard tickets; (6) promotional tickets that mimic a pull -tab or tipboard; (7) application software and those computer programs provided by a licensed manufacturer in the production, play, and reporting of board -approved electronic pull -tab games or electronic bingo games; (8) raffle boards; and (9) a disposable sealed placard, containing all 75 randomly placed bingo letter and number combinations, that, when opened, is used to select the bingo numbers in a single game of bingo. (b) Permanent gambling equipment includes the following: (1) devices for selecting bingo numbers; (2) electronic bingo devices; (3) electronic pull -tab devices; (4) pull -tab dispensing devices; (5) programmable electronic devices that have no effect on the outcome of a game and are used to provide a visual or auditory enhancement of a game; (6) paddlewheels; (7) paddlewheel tables; and (8) electronic raffle selection systems. Subd. 19. Gambling manager. "Gambling manager" means a person who has been designated by the organization to supervise the lawful gambling conducted by it, has been an active member of the organization for at least the most recent 90 days at the time of the application for a gambling manager license, and meets other qualifications as prescribed by the board by rule. Subd. 20. Gross profit. "Gross profit" means the gross receipts collected from lawful gambling, less reasonable sums necessarily and actually expended for prizes. Subd. 21. Gross receipts. "Gross receipts" means all receipts derived from lawful gambling activity including, but not limited to, the following items: (1) gross sales of bingo hard cards, paper sheets, facsimiles of bingo paper sheets when used in conjunction with an electronic bingo device, and rental of electronic bingo devices before reduction for prizes, expenses, shortages, free plays, or any other charges or offsets; (2) the ideal gross of pull -tab and tipboard deals or games less the value of unsold and defective tickets and before reduction for prizes, expenses, shortages, free plays, or any other charges or offsets; (3) gross sales of raffle tickets and paddle tickets before reduction for prizes, expenses, shortages, free plays, or any other charges or offsets; (4) admission, commission,- cover, or other charges imposed on participants in lawful gambling activity as a condition for or cost of participation; and Official Publication of the State of Minnesota Revisor of Statutes 349.12 MINNESOTA STATUTES 2021 (5) interest, dividends, annuities, profit from transactions, or other income derived from the accumulation or use of gambling proceeds. Gross receipts does not include rental proceeds froni premises owned by an organization and leased to one or more other organizations for the purposes of conducting lawful gambling. Subd. 21 a. Hot -ball bingo prize. "Hot -ball bingo prize" is an additional prize awarded for a winning bingo face for which the last bingo number called in the bingo game matches a previously designated bingo number announced to all players immediately prior to the beginning of the bingo game or the bingo occasion. Subd. 22. Ideal gross. "Ideal gross" means the total amount of receipts that would be received if every individual ticket in the pull -tab or tipboard deal was sold at its face value. In the calculation of ideal gross and prizes, a free play ticket shall be valued at face value. Subd. 23. Ideal net. "Ideal net" means the pull -tab or tipboard deal's ideal gross, as defined under subdivision 22, less the total predetermined prize amounts available to be paid out. When the prize is not entirely a monetary one, the ideal net is 50 percent of the ideal gross. Subd. 24. Lawful gambling. "Lawful gambling" is the operation, conduct or sale of bingo, raffles, paddlewheels, tipboards, and pull -tabs. Subd. 25. Lawful purpose. (a) "Lawful purpose" meads one or more of the following: (1) any expenditure by or contribution to a 501(c)(3) or festival organization, as defined in subdivision 15c, provided that the organization and expenditure or contribution are in conformity with standards prescribed by the board under section 349.154, which standards must apply to both types of organizations in the same manner and to the same extent; (2) a contribution to or expenditure for goods and services for an individual or family suffering from poverty, homelessness, or disability, which is used to relieve the effects of that suffering; (3) a contribution to a program recognized by the Minnesota Department of Human Services for the education, prevention, or treatment of problem gambling; (4) a contribution to or expenditure on a public or private nonprofit educational institution registered with or accredited by this state or any other state; (5) a contribution to an individual, public or private nonprofit educational institution registered with or accredited by this state or any other state, or to a scholarship fund of a nonprofit organization whose primary mission is to award scholarships, for defraying the cost of education to individuals where the funds are awarded through an open and fair selection process; (6) activities by an organization or a government entity which recognize military service to the United States, the state of Minnesota, or a community, subject to rules of the board, provided that the rules must not include mileage reimbursements in the computation of the per diem reimbursement limit and must impose no aggregate annual limit on the amount of reasonable and necessary expenditures made to support: (i) members of a military marching or color guard unit for activities conducted within the state; (ii) members of an organization solely for services performed by the members at funeral services; Official Publication of the State of Minnesota Revisor of Statutes MINNESOTA STATUTES 2021 349.12 (iii) members of military marching, color guard, or honor guard units may be reimbursed for participating in color guard, honor guard, or marching unit events within the state or states contiguous to Minnesota at a per participant rate of up to $50 per diem; or (iv) active military personnel and their immediate family members in need of support services; (7) recreational, community, and athletic facilities and activities, intended primarily for persons under age 21, provided that such facilities and activities do not discriminate on the basis of gender and the organization complies with section 349.154, subdivision 3a; (8) payment of local taxes authorized under this chapter, taxes imposed by the United States on receipts from lawful gambling, the taxes imposed by section 297E.02, subdivisions 1, 5, and 6, and the tax imposed on unrelated business income by section 290.05, subdivision 3; (9) payment of real estate taxes and assessments on permitted gambling premises owned by the licensed organization paying the taxes, or wholly leased by a licensed veterans organization under a national charter recognized under section 501(c)(19) of the Internal Revenue Code; (10) a contribution to the United States, this state or any of its political subdivisions, or any agency or instrumentality thereof other than a direct contribution to a law enforcement or prosecutorial agency; (11) a contribution to or expenditure by a nonprofit organization which is a church or body of communicants gathered in common membership for mutual support and edification in piety, worship, or religious observances; (12) an expenditure for citizen monitoring of surface water quality by individuals or nongovernmental organizations that is consistent with section 115.06, subdivision 4, and Minnesota Pollution Control Agency guidance on monitoring procedures, quality assurance protocols, and data management, provided that the resulting data is submitted to the Minnesota Pollution Control Agency for review and inclusion in the state water quality database; (13) a contribution to or expenditure on projects or activities approved by the commissioner of natural resources for: (i) wildlife management projects that benefit the public at large; (ii) grant-in-aid trail maintenance and grooming established under sections 84.83 and 84.927, and other trails open to public use, including purchase or lease of equipment for this purpose; and (iii) supplies and materials for safety training and educational programs coordinated by the Department of Natural Resources, including the Enforcement Division; (14) conducting nutritional programs, food shelves, and congregate dining programs primarily for persons who are age 62 or older or disabled; (15) a contribution to a community arts organization, or an expenditure to sponsor arts programs in the community, including but not limited to visual, literary, performing, or musical arts; (16) an expenditure by a licensed fraternal organization or a licensed veterans organization for payment of water, fuel for heating, electricity, and sewer costs for: (i) up to 100 percent for a building wholly owned or wholly leased by and used as the primary headquarters of the licensed veteran or fraternal organization; or Official Publication of the State of Minnesota Revisor of Statutes 349.12 MINNESOTA STATUTES 2021 8 (ii) a proportional amount subject to approval by the director and based on the portion of a building used as the primary headquarters of the licensed veteran or fraternal organization; (17) expenditute by a licensed veterans organization of up to $5,000 in a calendar year in net costs to the organization for meals and other membership events, limited to members and spouses, held in recognition of military service. No more than $5,000 can be expended in total per calendar year under this clause by all licensed veterans organizations sharing the same veterans post home; (18) payment of fees authorized under this chapter imposed by the state of Minnesota to conduct lawful gambling in Minnesota; (19) a contribution or expenditure to honor an individual's humanitarian service as demonstrated through philanthropy or volunteerism to the United States, this state, or local community; (20) a contribution by a licensed organization to another licensed organization with prior board approval, with the contribution designated to be used for one or more of the following lawful purposes under this section: clauses (1) to (7), (11) to (15), (19), and (25); (21) an expenditure that is a contribution to a parent organization, if the parent organization: (i) has not provided to the contributing organization within one year of the contribution any money, grants, property, or other thing of value, and (ii) has received prior board approval for the contribution that will be used for a program that meets one or more of the lawful purposes under subdivision 7a; (22) an expenditure for the repair, maintenance, or improvement of real property and capital assets owned by an organization, or for the replacement of a capital asset that can no longer be repaired, with a fiscal year limit of five percent of gross profits from the previous fiscal year, with no carryforward of unused allowances. The fiscal year is July 1 through June 30. Total expenditures for the fiscal year may not exceed the limit unless the board has specifically approved the expenditures that exceed the limit due to extenuating circumstances beyond the organization's control. An expansion of a building or bar -related expenditures are not allowed under this provision. (i) The expenditure must be related to the portion of the real property or capital asset that must be made available for use free of any charge to other nonprofit organizations, community groups, or service groups, and is used for the organization's primary mission or headquarters. (ii) An expenditure may be made to bring an existing building that the organization owns into compliance with the Americans with Disabilities Act. (iii) An organization may apply the amount that is allowed under item (ii) to the erection or acquisition of a replacement building that is in compliance with the Americans with Disabilities Act if the board has specifically approved the amount. The cost of the erection or acquisition of a replacement building may not be made from gambling proceeds, except for the portion allowed under this item; (23) an expenditure for the acquisition or improvement of a capital asset with a cost greater than $2,000, excluding real property, that will be used exclusively for lawful purposes under this section if the board has specifically approved the amount; (24) an expenditure for the acquisition, erection, improvement, or expansion of real property, if the board has first specifically authorized the expenditure after finding that the real property will be used exclusively for lawful purpose under this section; Official Publication of the State of Minnesota Revisor of Statutes 9 MINNESOTA STATUTES 2021 349.12 (25) an expenditure, including a mortgage payment or other debt service payment, for the erection or acquisition of a comparable building to replace an organization -owned building that was destroyed or made uninhabitable by fire or catastrophe or to replace an organization -owned building that was taken or sold under an eminent domain proceeding. The expenditure may be only for that part of the replacement cost not reimbursed by insurance for the fire or catastrophe or compensation not received from a governmental unit under the eminent domain proceeding, if the board has first specifically authorized the expenditure; or (26) a contribution to a 501(c)(19) organization that does not have an organization license under section 349.16 and is not affiliated with the contributing organization, and whose owned or leased property is not a permitted premises under section 349.165. The 501(c)(19) organization may only use the contribution for lawful purposes under this subdivision or for the organization's primary mission. The 501(c)(19) organization may not use the contribution for expansion of a building or for bar -related expenditures. A contribution may not be made to a statewide organization representing a consortia of 501(c)(19) organizations. (b) Expenditures authorized by the board under paragraph (a), clauses (24) and (25), must be 51 percent completed within two years of the date of board approval; otherwise the organization must reapply to the board for approval of the project. "Fifty-one percent completed" means that the work completed must represent at least 51 percent of the value of the project as documented by the contractor or vendor. (c) Notwithstanding paragraph (a), "lawful purpose" does not include: (1) any expenditure made or incurred for the purpose of influencing the nomination or election of a candidate for public office or for the purpose of promoting or defeating a ballot question; (2) any activity intended to influence an election or a governmental decision -making process; (3) a contribution to a statutory or home rule charter city, county, or town by a licensed organization with the knowledge that the governmental unit intends to use the contribution for a pension or retirement fund; or (4) a contribution to a 501(c)(3) organization or other entity with the intent or effect of not complying with lawful purpose restrictions or requirements. Subd. 25a. Linked bingo game. "Linked bingo game" means a bingo game played at two or more locations where licensed organizations are authorized to conduct bingo, where there is a common prize pool and a common selection of numbers or symbols conducted at one location, and where the results of the selection are transmitted to all participating locations by satellite, telephone, or other means by a linked bingo game provider. Subd. 25b. Linked bingo game provider. "Linked bingo game provider" means any person who provides the means to link bingo games, who provides linked bingo prize management, and who provides the linked bingo game system. Subd. 25c. Linked bingo game system. "Linked bingo game system" means the equipment used by the linked bingo provider to conduct, transmit, and track a linked bingo game. The system must be approved by the board before its use in this state and it must have the capability to permit the board to electronically monitor its operation remotely. For linked electronic bingo games, the system includes electronic bingo devices. Subd. 25d. Linked bingo prize pool. "Linked bingo prize pool" means the total of all prize money that each participating organization has contributed to a linked bingo game prize and includes any portion of the prize pool that is carried over from one game to another in a progressive linked bingo game. Official Publication of the State of Minnesota Revisor of Statutes 349.12 MINNESOTA STATUTES 2021 10 Subd. 26. Manufacturer. "Manufacturer" means a person or entity who assembles from raw materials or subparts a completed piece of gambling equipment, and who sells or furnishes the equipment for resale or for use in the state. The term includes a person who converts, modifies, adds to, or removes parts or a portion from an item, device, or assembly to further its promotion, sale, or use as gambling equipment in this state. A person only adding or modifying promotional flares to advise the public of the prizes available, the rules of play, and the consideration required is not a manufacturer. Subd. 26a. Master flare. "Master flare" is the posted display, with registration stamp affixed or bar code imprinted or affixed, that is used in conjunction with sealed groupings of 100 or fewer sequentially numbered paddle ticket cards. Subd. 27. Net profit. "Net profit" means gross profit less reasonable sums actually expended for allowable expenses. Subd. 28. Organization. "Organization" means any fraternal, religious, veterans, or other nonprofit organization. Subd. 28a. Paddle ticket. "Paddle ticket" means a preprinted ticket that can be used to place wagers on the spin of a paddlewheel. Subd. 28b. Paddle ticket card. "Paddle ticket card" means a card to which detachable paddle tickets are attached. Subd. 28c. Paddle ticket card number. "Paddle ticket card number" means the unique serial number preprinted by the manufacturer on the stub of a paddle ticket card and the paddle tickets attached to the card. Subd. 29. Paddlewheel. "Paddlewheel' means a vertical wheel marked off into sections containing one or more numbers, and which, after being turned or spun, uses a pointer or marker to indicate winning chances, and may only be used to determine a winning number or numbers matching a winning paddle ticket purchased by a player. A paddlewheel may be an electronic device that simulates a paddlewheel. Subd. 30. Person. "Person" is an individual, organization, firm, association, partnership, limited liability company, corporation, trustee, or legal representative. Subd. 30a. Profit carryover. "Profit carryover" means cumulative net profit less cumulative lawful purpose expenditures. Subd. 31. Promotional ticket. A paper pull -tab ticket or paper tipboard ticket created and printed by a licensed manufacturer with the words "no purchase necessary" and "for promotional use only" and for which no consideration is given is a promotional ticket. Subd. 32. Pull -tab. "Pull -tab" means a single folded or banded paper ticket, multi -ply card with perforated break -open tabs, or a facsimile of a paper pull -tab ticket used in conjunction with an electronic pull -tab device, the face of which is initially covered to conceal one or more numbers or symbols, and where one or more of each set of tickets, cards, or facsimiles has been designated in advance as a winner. Subd. 32a. Pull -tab dispensing device. "Pull -tab dispensing device" means a mechanical device that dispenses paper pull -tabs and has no additional function as an amusement or gambling device. A pull -tab dispensing device may have as a component an auditory or visual enhancement to promote or provide information about a game being dispensed, provided the component does not affect the outcome of a game or display the results of a game or an individual ticket. Official Publication of the State of Minnesota Revisor of Statutes 11 MINNESOTA STATUTES 2021 349.12 Subd. 33. Raffle. "Raffle" means a game in which a participant buys a ticket or other certificate of participation in an event where the prize determination is based on a method of random selection and all entries have an equal chance of selection. Subd. 33a. Raffle board. "Raffle board" means a placard with up to 200 squares whereby participants in the raffle write their names to indicate entry. Subd. 33b. Raffle sales device. "Raffle sales device" is an attendant -operated cashier station used as a point of sale for raffle tickets from which a raffle participant may purchase a raffle ticket to participate in an electronic raffle selection system. Subd. 33c. Share the pot raffle. "Share the pot raffle" means a raffle in which the prize amount is a percentage of the raffle's gross receipts. Subd. 34. Tipboard. "Tipboard" means a board, placard or other device containing a seal that conceals the winning number or symbol, and that serves as the game flare for a tipboard game. A sports-thcmed tipboard is a board, placard, or other device that contains a grid of predesignated numbers for which the winning numbers are determined in whole or in part by the numerical outcome of one or more professional sporting events, serves as the game flare for player registration, but is not required to contain a seal. For a sports-themed tipboard, the winning numbers must be determined solely by the numerical outcome. Subd. 35. Tipboard ticket. "Tipboard ticket" is a single folded or banded ticket, or multi -ply card, the face of which is initially covered or otherwise hidden from view to conceal a number, symbol, or set of symbols, some of which have been designated in advance and at random as prize winners. For a sports-themed tipboard, the tipboard ticket contains a set of numbers used to determine the winner based on the numerical outcome of a professional sporting event. Subd. 36. Veterans post home. "Veterans post home" means a building, or portion of a building, that is leased or owned by one or more licensed veterans organizations, and that is considered the post home for all licensed veterans organizations at that site. Subd. 37. Wholly leased building. "Wholly leased building" means a building that is leased in its entirety by a licensed organization, and no part or portion of the building is subleased to any other entity or licensed organization. Subd. 38. Wholly owned building. "Wholly owned building" means a building that is owned in its entirety by a licensed organization, and no part or portion of the building is subleased to any other entity or licensed organization. History: 1976 c 261 s 2; 1984 c 502 art 12 s 3; 1986 c 444; 1986 c 467 s 4-6; 1987 c 327 s 2-5; 1988 c 596 s 1; 1988 c 719 art 9 s 1-3; 1989 c 203 s 1; 1989 c 334 art 2 s 2-15,51; ISp1989 c l art 13 s 1-6; 1990 c 590 art 1 s 4-9; 1991 c 199 art 2 s 1; 1991 c 233 s 100; 1991 c 336 art 2 s 10-12; 1993 c 244 art 5 s 1; 1994 c 633 art 2 s 19; art 5 s 1-20; 1995 c 186 s 68; 1995 c 261 s 20,21; 1995 c 264 art 9 s 9; 1997 c 155 s 2,3; 1998 c 322 s 1; 2000 c 300 s 1,2; 2000 c 336 s 3; 2001 c 96 s 6; 2002 c 377 art 12 s 14; 2002 c 386 art 3 s 1; 2003 c 110 s 1-13; 1 Sp2003 c I art 2 s 84, 85; 2005 c 146 s 50; 2005 c 166 art 1 s 1-6; 2006 c 205 s 2-6; 2006 c 212 art 3 s 31; 2007 c 145 s 1-3; 2008 c 260 s 1,2; 2009 c 124 s 3-12; 2010 c 389 art 10 s 4; 2012 c 242 s 1; 2012 c 299 art 4 s 13-31; 2015 c 45 s 1-4; 2015 c 52 s 1,2; 2016 c 139 s 1-6; 2016 c 158 art 1 s 177; 2019 c 50 art 1 s 105; ISp2019 c 10 art 7 s 1; 2020 c 83 art I s 82 Official Publication of the State of Minnesota Revisor of Statutes • y, of Mounds View Staff R To: Honorable Mayor and City Council From: Nyle Zikmund, City Administrator Item Title/Subject: City Attorney Contract Item No: 7 Meeting Date: December 6, 2021 Type of Business: Council Workshop City Administrator Review: Introduction: Our agreement with Kennedy and Graven for legal services expires at the end of the year. Included in the packet is a letter/proposal from them proposing no changes in the retainer fee and a 2% increase on those items billed on an hourly rate. Staff and Council are very familiar with Kennedy and Graven as they have served as legal counsel for nearly 3 decades. Action Requested: Provide direction to staff — move forward with proposal or issue RFP for services. Respectfully submitted, Nyle Zikmund City Administrator The Mounds View Vision A Thriving Desirable Community Offices in Fifth Street Towers 150 South Fifth Street, Suite 700 Minneapolis Minneapolis, MN 55402 (612) 337-9300 telephone Saint Paul (612) 337-9310 fax St. Cloud kennedy-graven.com C H A R T E R E D Affirmative Action, Equal Opportunity Employer ScoTT J. RIGGS Attomey at Law Direct Dial (612) 337-9260 email: srie2s2kennedy-graven.com November 9, 2021 City of Mounds View City Council c/o Nyle Zikmund City Administrator 2401 Mounds View Boulevard Mounds View, MN 55112 RE: 2022-2024 Rates for Legal Services Dear Honorable Mayor and Council Members: I am writing to thank you for allowing me the opportunity to serve as legal counsel for the City of Mounds View and in reference to proposed rates for legal services. In follow-up to my previous rate letter for the years 2019 through 2021, I am proposing that legal rates for the years 2022 through 2024 for the City of Mounds View would be as follows: A. For all usual and customary legal services for the City in accordance with past practice established between the City and the city attorney, the city attorney agrees to perform such services pursuant to a monthly retainer in the amount of $2,000.00. B. For all other matters not included within the monthly retainer amount, the city attorney agrees to perform such services in accordance with past practice established between the City and the city attorney pursuant to the hourly rates as follows: $211.00 per hour for litigation, $211.00 per hour for general city development projects, including real estate, cable and telecommunication related matters, and employment matters, and $250.00 per hour for reimbursable/developer pass through matters (e.g., projects for which the City is to be reimbursed for legal costs by a developer). At the beginning of each new year, the above -referenced rates shall increase by an amount equal to two percent (2%) rounded to the nearest whole dollar amount. C. Rates for bond work would be charged in accordance with our regular governmental rates for this type of work. These are the same rates that I will be generally charging to other clients that I serve as the city attorney. I have thoroughly enjoyed both being involved in the growth and development of the City and working with the city council and staff members. Thank you once again for allowing me to continue to serve the City as legal counsel. Sincerely, KENNEDY & GRAVEN, CHARTERED Scott WSRA. Mounds View City Attorney DOCSOPEN\MU 125\l 1\761417.v2-1 l /9/21