Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2022 Final Budget
Adopted 2021 to 2018 2019 2020 2021 Actual 2021 2022 Proposed 2022Account Number Description Actual Actual Actual Adopted 6/30/2021 Projected Proposed Percent Change Comments General Fund Revenues: Taxes101-410-1320-31010 Current Ad Valorem Taxes 2,216,047 2,738,122 3,250,895 3,522,782 1,156,373 3,522,782 4,689,073 33.11% 101-410-1320-31020 Delinquent Ad Valorem Taxes 15,785 11,702 20,115 15,000 26,221 26,221 15,000 0.00% 101-410-1320-31030 Delinquent Mobile Home Tax 16,079 18,680 16,819 15,000 2,913 2,913 15,000 0.00% 101-410-1320-31040 Fiscal Disparities 148,090 194,300 245,389 271,597 162,978 271,597 294,401 8.40% 101-410-1320-31520 30% Rental - County - 2,551 - - 4,420 4,420 - #DIV/0! 101-410-1320-31910 Penalty & Interest on Taxes 719 1,038 1,162 500 43 64 100 -80.00% 101-000-0000-33620 Gravel Tax - - 3,370 - 3,603 - - #DIV/0! Total Taxes 2,396,720$ 2,966,392$ 3,537,749$ 3,824,879$ 1,356,552$ 3,827,998$ 5,013,574$ 31.08% Licenses and Permits 101-410-1320-32110 Liquor License 8,700 12,600 9,342 8,300 - 10,000 10,000 20.48% 101-410-1320-32180 Wastehauler License - 840 120 720 - 720 720 0.00% 101-410-1320-32181 General Contractor License - 350 100 150 300 300 300 100.00% 101-410-1320-32183 Heating Contractor License - - - - - - - #DIV/0! 101-420-2400-32210 Building Permits 1,046,758 780,104 1,137,150 800,000 908,643 1,029,854 800,000 0.00%Residential only. 250 new homes 101-430-3100-32211 Driveway Permits 17,570 13,705 16,255 12,000 13,700 17,500 12,500 4.17% 101-420-2400-32212 Fireplace Permits 5,580 15,780 19,319 16,000 14,940 16,833 16,000 0.00% 101-420-2400-32220 Heating Permits 79,657 74,367 80,489 60,000 92,388 114,374 70,000 16.67% 101-420-2400-32230 Plumbing Permits 82,254 91,576 99,846 75,000 116,238 144,619 80,000 6.67% 101-420-2400-32232 Pool Permits 150 1,050 1,725 1,000 1,650 1,860 1,500 50.00% 101-420-2400-32213 Siding Permits - 4,706 3,303 5,000 5,691 5,927 4,000 -20.00% 101-420-2400-32214 Roof Permits - 12,309 15,475 10,000 24,942 20,200 15,000 50.00% 101-430-3100-32250 Utility Permits 61,620 36,898 34,974 21,600 33,708 30,000 30,000 38.89% 101-420-2220-32260 Burning Permit 2,050 1,585 1,550 1,500 1,445 1,740 1,700 13.33% 101-410-1320-32270 Massage Therapy Licenses 300 300 25 100 100 150 150 50.00%101-420-2400-32275 Fire Suppression Permits 700 6,980 5,467 2,000 13,636 15,000 5,000 150.00% 101-420-2400-32278 Fire Permit Plan Check Fee 1,151 1,400 100 - 5,460 6,000 1,000 #DIV/0!Fire Alarm Systems 101-410-1320-32281 Golf Cart Operation Permit - 30 30 30 90 30 30 0.00% 101-410-1320-32282 Miscellaneous Permits 25 100 175 100 88 100 100 0.00% 101-420-2400-32282 Miscellaneous Permits 3,790 3 100 - - - - #DIV/0! Total Licenses and Permits 1,310,304$ 1,055,038$ 1,425,544$ 1,013,500$ 1,233,018$ 1,415,207$ 1,048,000$ 3.40% Intergovernmental 101-430-3100-33418 MSA - Maintenance 144,502 153,963 173,566 151,755 163,776 163,776 168,689 11.16% 101-420-2220-33420 State Fire Aid 64,533 68,975 76,608 64,000 - 64,000 76,608 19.70%Sept - Nov receipt for Relief Association 101-410-1320-33426 Coronavirus Aid - - - - - - - #DIV/0! 101-410-1930-33426 Miscellaneous State Grants - - - - 1,521 - - #DIV/0! 101-420-2220-33426 Miscellaneous State Grants 7,128 6,323 5,858 - - - 3,500 #DIV/0!Gear Washer matching grant 101-450-5200-33426 Miscellaneous State Grants 5,664 6,394 3,192 4,820 2,676 4,820 4,820 0.00%DNR/Sunfish Lake Trail Grooming 101-410-1320-33623 Payment in Lieu of Taxes 31,500 149,944 66,201 34,097 - 34,097 34,779 2.00%ISD 916 Service Fee Due in Dec. - 2% incr./yr. End in 2026 101-430-3100-33630 Grant Revenue - 4,327 - - - - #DIV/0!S Washing Cty Watershed grant agreement 101-420-2220-33525 Other County Grants and Aids 4,190 2,889 - - - 3,400 - #DIV/0! 101-410-1320-33521 Recycling Grant - 16,534 - - - 11,951 10,000 #DIV/0! Total Intergovernmental 261,635$ 415,882$ 330,010$ 256,172$ 167,973$ 282,044$ 298,396$ 16.48% Charges for Services 101-410-1910-34103 Zoning & Subdivision Fees 93,785 81,695 48,517 40,000 40,980 45,000 45,000 12.50% 101-420-2400-34104 Plan Check Fees 567,035 460,523 701,220 520,000 597,470 669,405 520,000 0.00% 101-410-1320-34105 Sale of Copies, Books, Maps 40 - - 50 - - - -100.00% 101-410-1520-34107 Assessment Searches - 810 2,010 2,000 2,780 2,820 2,500 25.00%101-420-2400-34207 Building Code Surcharges 60,740 - 5,067 - 61,572 - - #DIV/0!Pass Thru - not budgeted 101-450-5200-34710 Rent 12 12 - - - - - #DIV/0! 101-410-1450-34111 Cable Operation Reimbursement - 4,315 3,185 5,000 - 5,000 5,000 0.00%Offset with Cable Operators charge in Communications 101-420-2400-34112 Planning & Zoning Review Fee 29,400 26,600 34,200 20,000 27,834 30,000 25,000 25.00%$100 every new review charged 101-430-3100-34114 Street Light Fee 4,902 1,161 4,338 1,000 2,580 1,935 1,500 50.00%Developer Agreements 101-410-1910-34115 Base Map Upgrading Fee 8,200 3,050 6,775 3,000 7,700 6,200 6,200 106.67%$25/lot created 101-420-2400-34203 Day Care Inspections 50 - - - - - - #DIV/0! 101-410-1910-36206 Escrow Administration Fee 27,300 27,200 37,200 20,000 27,087 25,000 25,000 25.00%$100 every new escrow is charged. Based on 250 new homes. Total Charges for Services 791,464$ 605,366$ 842,512$ 611,050$ 768,003$ 785,360$ 630,200$ 3.13% Fines and Forfeits 101-410-2100-35100 Fines 50,857 36,696 33,584 35,000 31,595 35,000 35,000 0.00% Total Fines and Forfeits 50,857$ 36,696$ 33,584$ 35,000$ 31,595$ 35,000$ 35,000$ 0.00% Investment Earnings 101-410-1320-36210 Interest Earnings 83,217 118,299 44,816 77,000 - 77,000 38,500 -50.00%Projected market is falling. This will be adjusted at EOY. Finance will estimate! Total Investment Earnings 83,217$ 118,299$ 44,816$ 77,000$ -$ 77,000$ 38,500$ -50.00% Miscellaneous 101-410-1320-31811 Cable Franchise Revenue - 103,692 94,841 85,000 81,019 81,019 50,000 -41.18%Declining revenues do to fewer member cities and new franchise 101-410-1320-36100 Special Assesments - - - - 520 - - #DIV/0!clean up charges 101-410-1320-36200 Miscellaneous Revenue 1,845 15,730 21,710 3,000 154 3,000 3,000 0.00%misc. accts. Receivable, LMCIT dividend, misc. one-tiome revenues 101-420-2220-36200 Miscellaneous Revenue - 23,783 2,574 - 4,673 - - #DIV/0! 101-430-3100-36200 Miscellaneous Revenue - 25,403 24,059 500 2,831 2,500 500 0.00%Public Surplus Auction Rev 101-410-1910-36200 Miscellaneous Revenue - - 14,725 15,000 14,285 100 100 -99.33%AUAR101-450-5200-36200 Miscellaneous Revenue - 1,418 812 - 25 25 500 #DIV/0! 101-410-1320-36207 MCMA Grant - - - - 3,500 3,500 - #DIV/0!Intern for Admin 101-410-1910-36236 Conservation Easement Fee 20,000 - - 20,000 - - - -100.00% 101-420-2220-36204 Reimbursements - Fire 20 - 5,150 - 24,391 15,627 5,000 #DIV/0!2021 : $4400 original reimbursement, $11,227 additional one time reallocation from MBFTE 101-420-2220-36230 Donations-Fire - 1,500 370 - - 1,000 1,000 #DIV/0! 101-410-1320-36230 Donations 14,036 15,000 14,100 10,000 9,000 9,000 10,000 0.00%pull tabs from Jaycees sales at TP, NKT? 101-410-1320-34120 Tower Rent 53,531 129,587 113,316 112,517 83,942 112,517 114,767 2.00%Estimated from contracts. Sprint not yet received for 2021! Total Miscellaneous 89,433$ 316,112$ 291,658$ 246,017$ 224,340$ 228,288$ 184,867$ -24.86% Prior Period Adjustments 32,332 Total General Fund Revenues:5,015,962$ 5,513,784$ 6,505,872$ 6,063,618$ 3,781,480$ 6,650,897$ 7,248,537$ 19.54% General Fund Expenditures: 1110 Mayor & Council Personnel 101-410-1110-41030 Part-time Salaries 25,690 25,690 25,690 25,690 12,845 25,690 25,690 0.00% 101-410-1110-41220 FICA Contributions 1,593 1,599 1,593 1,593 796 1,593 1,593 0.00% 101-410-1110-41230 Medicare Contributions 373 373 373 373 186 373 373 0.00% 101-410-1110-41510 Workers Compensation 237 119 136 130 118 130 150 15.00%15% over 2021 Actual Total Personnel 27,892$ 27,781$ 27,792$ 27,786$ 13,945$ 27,786$ 27,806$ 0.07% Materials and Supplies 101-410-1110-42000 Office Supplies - 78 212 125 70 125 125 0.00%business cards, name tags, etc 101-410-1110-42001 Computer Reimbursement 1,000 1,000 - 3,000 2,859 2,859 - -100.00%e/o year exp 101-410-1110-43310 Mileage - - - 300 - 300 300 0.00% 101-410-1110-43185 IT Support - 1,134 1,248 1,332 902 1,332 1,322 -0.78%Allcoation for 2022 has changed!!! Includes all the Rosville bill ( IT Support, Software, and Telephone) 101-410-1110-42002 IT Hardware - - - - - - - #DIV/0! 101-410-1110-43190 Software Programs - - - - - - - #DIV/0! Total Materials and Supplies 1,000$ 2,213$ 1,460$ 4,757$ 3,831$ 4,616$ 1,747$ -63.28% Charges and Services101-410-1110-44300 Miscellaneous 164 6,910 5,295 7,250 1,785 7,250 7,500 3.45%YSB, misc 101-410-1110-44330 Dues & Subscriptions 12,850 14,119 14,699 16,500 15,514 16,500 18,150 10.00%LMC, MC, MA 101-410-1110-44370 Conferences & Training - 450 - 1,000 175 500 1,000 0.00% Total Charges and Services 13,014$ 21,479$ 19,994$ 24,750$ 17,474$ 24,250$ 26,650$ 7.68% 1110 Total Mayor & Council 41,906$ 51,473$ 49,246$ 57,293$ 35,250$ 56,652$ 56,202$ -1.90% 1320 Administration Personnel 101-410-1320-41010 Full-time Salaries 214,777 260,732 163,213 169,407 124,203 169,407 176,559 4.22% 101-410-1320-41030 Part-time Salaries - - - - - - - #DIV/0! 101-410-1320-41020 Overtime - - - - - - - #DIV/0! 101-410-1320-41040 Temporary Employees - - 4,780 - 1,532 1,532 - #DIV/0!No interns in 2022 101-410-1320-41210 PERA Contributions 16,114 18,358 19,774 12,706 9,490 12,706 13,242 4.22% 101-410-1320-41216 MSRS Contributions - City Adminstration - - - 1,649 921 1,649 1,540 -6.61% 101-410-1320-41220 FICA Contributions 12,528 14,198 15,391 10,503 7,580 10,503 10,947 4.22% 101-410-1320-41230 Medicare Contributions 2,805 3,344 3,711 2,456 1,773 2,456 2,560 4.24% 101-410-1320-41300 Insurance 44,869 36,341 34,880 31,837 17,503 31,837 34,278 7.67% 101-410-1320-41325 Life Insurance 381 852 156 127 85 127 127 0.13% 101-410-1320-41330 STD/LTD 1,536 1,178 2,172 905 619 905 927 2.46% 101-410-1320-41420 Unemployment Benefits 461 - - - - - - #DIV/0! 101-410-1320-41510 Workers Compensation 2,005 2,149 1,912 2,103 1,538 2,103 2,313 10.00%10% over 2021 Actual Total Personnel 295,477$ 337,152$ 245,989$ 231,693$ 165,244$ 233,225$ 242,493$ 4.66% Materials and Supplies101-410-1320-42000 Office Supplies 3,211 2,640 1,870 3,200 900 3,200 3,200 0.00% 101-410-1320-42030 Printed Forms - - - 100 - 100 100 0.00% Total Materials and Supplies 3,211$ 2,640$ 1,870$ 3,300$ 900$ 3,300$ 3,300$ 0.00% Charges and Services 101-410-1320-43100 Assessing Services 7,983 85,831 91,773 97,625 100,475 100,475 107,388 10.00%Wash Co bills June for previous year 101-410-1320-43040 Legal Services 132,928 80,390 120,251 87,500 37,337 87,500 87,500 0.00% 101-410-1320-43150 Contract Services 3,109 2,155 821 3,000 592 3,000 45,000 1400.00%Op Audit, Job Comp/Class Study, Shred it, misc 101-410-1320-43185 IT Support 7,291 6,936 7,574 7,350 5,475 7,350 5,262 -28.40%Allcoation for 2022 has changed!!! Includes all the Rosville bill ( IT Support, Software, and Telephone) 101-410-1320-42002 IT Hardware - 34 568 600 - - 1,200 100.00%two computers 101-410-1320-43190 Software Programs 2,011 3,000 - 2,540 - 2,540 - -100.00% 1 additional license $1000. Allcoation for 2022 has changed!!! 101-410-1320-43210 Telephone 1,852 2,076 792 2,664 1,423 2,744 2,200 -17.42%Sprint/Verizon 101-410-1320-43220 Postage 1,157 1,283 2,294 2,500 2,709 3,599 3,600 44.00%more project mailings 101-410-1320-43310 Mileage 772 539 32 1,100 - 500 1,100 0.00% 101-410-1320-43510 Legal Publishing 1,608 9,962 9,515 2,000 3,305 2,511 2,500 25.00% 101-410-1320-43610 Insurance 25,565 32,212 40,970 45,067 41,177 41,177 45,294 10.00%10% inc over 2021 actual 101-410-1320-44330 Dues & Subscriptions 1,919 1,746 1,731 2,200 1,413 2,000 2,200 0.00% 101-410-1320-44370 Conferences & Training 2,637 1,394 600 5,000 550 1,150 5,000 0.00% 101-410-1320-44371 Allocation to Building Inspections - - - (2,810) - (2,987) (2,606) -7.24%Allocation of overhead charges to Bulding Dept Total Charges and Services 188,832$ 227,558$ 276,921$ 256,336$ 194,456$ 251,559$ 305,638$ 19.23% Miscellaneous 101-410-1320-44300 Miscellaneous 1,156 2,972 899 1,500 1,000 1,500 3,750 150.00%Eagle Point Business Park Easement billing, employee recognition, etc Total Miscellaneous 1,156$ 2,972$ 899$ 1,500$ 1,000$ 1,500$ 3,750$ 150.00% 1320 Total Administration 488,675$ 570,322$ 525,678$ 492,829$ 361,600$ 489,584$ 555,181$ 12.65% 1410 Elections Personnel 101-410-1410-41030 Part-time Salaries 6,397 795 9,655 - - - 8,500 #DIV/0! 101-410-1410-41510 Workers Compensation - - - - - - - #DIV/0! Total Personnel 6,397$ 795$ 9,655$ -$ -$ -$ 8,500$ #DIV/0! Charges and Services 101-410-1410-43310 Travel Expense 44 25 - - - - 50 #DIV/0! 101-410-1410-42000 Office Supplies - - 295 - - - 300 #DIV/0! 101-410-1410-43510 Legal Notices Publishing 20 - 379 - - - 350 #DIV/0! 101-410-1410-43150 Contract Services 1,660 1,660 1,660 3,150 3,100 3,100 3,195 1.43%Wash. Cty. charges for elections Total Charges and Services 1,724$ 1,685$ 2,334$ 3,150$ 3,100$ 3,100$ 3,895$ 23.65% Capital Outlay 101-480-8000-45800 Other Equipment - - - - - - - #DIV/0! Total Capital Outlay -$ -$ -$ -$ -$ -$ -$ #DIV/0! Miscellaneous 101-410-1410-44300 Miscellaneous 630 159 1,054 - - - 1,000 #DIV/0!Food & beverages for judges on election day Total Miscellaneous 630$ 159$ 1,054$ -$ -$ -$ 1,000$ #DIV/0! #DIV/0! 1410 Total Elections 8,751$ 2,639$ 13,043$ 3,150$ 3,100$ 3,100$ 13,395$ 325.24% 1450 Communications Personnel 101-410-1450-41010 Full-time Salaries 29,159 27,051 25,988 27,128 19,408 27,128 28,778 6.08% 101-410-1450-41030 Part-time Salaries - - - - - - - #DIV/0! 101-410-1450-41020 Overtime - - - - - - - #DIV/0! 101-410-1450-41040 Temporary Employees - - - - - - - #DIV/0! 101-410-1450-41210 PERA Contributions 2,187 1,907 2,046 2,035 1,444 2,035 2,158 #REF! 101-410-1450-41220 FICA Contributions 1,792 1,543 1,692 1,682 1,194 1,682 1,784 #REF! 101-410-1450-41230 Medicare Contributions 419 359 396 393 279 393 417 6.18% 101-410-1450-41300 Insurance 4,604 5,462 2,676 6,909 2,084 6,909 7,438 7.66% 101-410-1450-41325 Life Insurance 60 99 17 28 20 28 28 -1.45% 101-410-1450-41330 STD/LTD 131 105 89 145 104 145 158 9.31% 101-410-1450-41510 Workers Compensation 262 298 279 307 259 307 338 10.00% Total Personnel 38,613$ 36,824$ 33,183$ 38,627$ 24,792$ 38,627$ 41,100$ 6.40% Charges and Services 101-410-1450-43090 Newsletter 2,870 3,179 1,122 1,200 615 1,291 1,400 16.67%printing only (Split with Water and Sewer) 101-410-1450-43185 IT Support 36,861 2,619 3,778 2,789 438 2,789 1,134 -59.33%Allcoation for 2022 has changed!!! Includes all the Rosville bill ( IT Support, Software, and Telephone) 101-410-1450-42002 IT Hardware - - - - - - - #DIV/0! 101-410-1450-43190 Software Programs 2,550 - - - - - 700 #DIV/0!101-410-1450-43210 Telephone - - - - - - - #DIV/0! 101-410-1450-43220 Postage 1,330 1,461 1,526 1,650 822 1,726 642 -61.09%newsletter postage 101-410-1450-43310 Mileage - - - - - - - #DIV/0! 101-410-1450-43510 Public Notices - - - - - - - #DIV/0! 101-410-1450-43152 Cable Operations 5,050 4,645 3,295 5,000 1,870 5,000 5,000 0.00% 101-410-1450-44370 Conferences and Training - - - 500 - - - -100.00% Total Charges and Services 48,661$ 11,904$ 9,722$ 11,139$ 3,745$ 10,806$ 8,876$ -20.31% 1450 Total Communications 87,274$ 48,728$ 42,905$ 49,766$ 28,538$ 49,433$ 49,976$ 0.42% 1520 Finance Personnel 101-410-1520-41010 Full-time Salaries 69,526 95,690 12,149 74,290 49,127 74,290 79,358 6.82%higher paid position, more acct time in finance 101-410-1520-41030 Part-time Salaries 5,636 - - - - - - #DIV/0! 101-410-1520-41020 Overtime - - - - - - - #DIV/0! 101-410-1520-41040 Temporary Employees - 5,568 - 7,102 6,026 - - -100.00%No Intern in 2022 101-410-1520-41210 PERA Contributions 5,215 6,860 1,153 5,572 3,653 5,572 5,952 6.82% 101-410-1520-41220 FICA Contributions 4,397 5,730 903 5,046 3,298 4,606 4,920 -2.49%No Intern in 2022 101-410-1520-41230 Medicare Contributions 1,028 1,335 211 1,180 771 1,077 1,151 -2.48%No Intern in 2022 101-410-1520-41300 Insurance 6,851 3,922 (64) 13,589 8,270 13,589 14,631 7.67% 101-410-1520-41325 Life Insurance 86 321 9 54 15 54 54 0.52% 101-410-1520-41330 STD/LTD 41 490 45 457 127 457 468 2.37% 101-410-1520-41420 Unemployment Benefits 5,537 - - - - - - #DIV/0! 101-410-1520-41510 Workers Compensation 244 1,006 851 935 710 710 781 -16.47% Total Personnel 98,561$ 120,921$ 15,256$ 108,225$ 71,997$ 100,355$ 107,315$ -0.84% Materials and Supplies 101-410-1520-42000 Office Supplies 1,299 297 258 800 224 800 880 10.00% 101-410-1520-42030 Printed Forms 1,039 1,301 - 1,000 153 1,000 1,670 67.00%Check and deposit book costs Total Materials and Supplies 2,338$ 1,597$ 258$ 1,800$ 377$ 1,800$ 2,550$ 41.67% #DIV/0! Charges and Services #DIV/0! 101-410-1520-43010 Audit Services 29,820 9,246 9,105 8,227 8,608 8,227 8,706 5.82% split GF, Water, Sewer, SW 101-410-1520-43150 Contract Services 79,620 1,750 43,155 10,000 14,209 17,951 30,000 200.00%$5,000 Misc - Consulting for new GASB implementations (GASB 87) 25K operational Audit 101-410-1520-43185 IT Support 1,680 3,893 4,446 4,157 3,096 4,157 2,266 -45.48%Allocation for 2022 has changed!!! Includes all the Rosville bill ( IT Support, Software, and Telephone) 101-410-1520-42002 IT Hardware 18 505 - 1,500 - - - -100.00% 101-410-1520-43190 Software Programs 18,973 3,419 5,743 2,919 1,080 2,919 7,192 146.40%Accela support (slit with W, S, SW $9226)/Banyon/Credit Card Services, Roseville 101-410-1520-43210 Telephone 580 528 - 613 - 613 - -100.00%No additional Phone. Budgeted with 43185 101-410-1520-43310 Mileage 168 - - 500 - 100 200 -60.00% 101-410-1520-44330 Dues & Subscriptions 2,071 1,294 650 2,300 720 1,000 1,470 -36.09%GFOA and CAFR 101-410-1520-44370 Conferences & Training 642 455 - 3,200 230 500 1,600 -50.00% 101-410-1520-44371 Allocation to Building Inspections - - - (2,324) - (1,152) (1,751) -24.64%Allocation charge for Building Dept. Total Charges and Services 133,573$ 21,090$ 63,099$ 31,092$ 27,943$ 34,315$ 49,683$ 59.79% #DIV/0! Miscellaneous #DIV/0! #DIV/0! 101-410-1520-44300 Miscellaneous 2,141 1,119 1,008 5,000 315 3,500 3,500 -30.00%Bank Fees, Wire Transfer Fees, Excise Tax, Penalties, County charges, Health Partners, Ind Health Svs Network Total Miscellaneous 2,141$ 1,119$ 1,008$ 5,000$ 315$ 3,500$ 3,500$ -30.00% #DIV/0! 1520 Total Finance 236,614$ 144,727$ 79,621$ 146,117$ 100,633$ 139,970$ 163,049$ 11.59% 1910 Planning & Zoning Personnel 101-410-1910-41010 Full-time Salaries 148,529 161,971 152,276 163,494 121,816 163,494 223,805 36.89%Added Code Enforcement Officer 80% Planning 101-410-1910-41030 Part-time Salaries 4,626 - 5,915 - - - - #DIV/0! 101-410-1910-41020 Overtime - - - - - - - #DIV/0! 101-410-1910-41040 Temporary Employees - 4,096 - 7,102 6,975 - - -100.00%No Intern in 2022 101-410-1910-41210 PERA Contributions 10,784 11,523 11,819 12,262 8,767 12,262 16,785 36.89% 101-410-1910-41220 FICA Contributions 9,424 9,833 10,088 10,577 7,870 10,137 13,876 31.19% 101-410-1910-41230 Medicare Contributions 2,204 2,290 2,359 2,474 1,841 2,371 3,245 31.17% 101-410-1910-41300 Insurance 6,582 10,726 20,632 32,222 14,409 32,222 48,925 51.84%Code enforcement Officer allocation 101-410-1910-41325 Life Insurance 294 340 53 129 36 129 182 40.70% 101-410-1910-41330 STD/LTD 972 330 843 935 548 935 1,268 35.62% 101-410-1910-41510 Workers Compensation 1,424 1,273 1,581 1,739 1,563 1,739 1,913 10.00% Total Personnel 184,839$ 202,382$ 205,567$ 230,934$ 163,823$ 223,288$ 309,999$ 34.24% Materials and Supplies 101-410-1910-42000 Office Supplies 752 62 110 150 158 200 250 66.67% Total Materials and Supplies 752$ 62$ 110$ 150$ 158$ 200$ 250$ 66.67% Charges and Services101-410-1910-43020 Comprehensive Planning 50,885 7,796 744 400 - - - -100.00%Comp Plan complete, line item for consulting if needed 101-410-1910-43030 Engineering Services 11,170 16,450 10,255 12,000 2,494 10,000 10,000 -16.67% 101-410-1910-43150 Contract Services 2,249 11,675 11,543 21,000 19,954 21,000 10,000 -52.38% 101-410-1910-43185 IT Support - 7,360 6,239 6,160 4,511 6,160 5,291 -14.11%Roseville 101-410-1910-42002 IT Hardware - 505 - - - - 480 #DIV/0!Code Enforcement Officer Computer at 80% 101-410-1910-43190 Software Programs 623 973 - 1,514 - 1,500 500 -66.97%Roseville, Comp Plan Software 101-410-1910-43210 Telephone 724 528 - 600 - 600 680 13.33%Cell for Code Enforcement Officer at 80% 101-410-1910-43220 Postage 79 - - 150 - 100 100 -33.33% 101-410-1910-43310 Mileage 158 271 40 100 - 50 300 200.00%Conferences 101-410-1910-43510 Legal Publishing 2,185 1,091 1,374 1,200 604 700 700 -41.67% 101-410-1910-44330 Dues & Subscriptions 170 354 372 500 - 500 500 0.00%ULI, AICP memberships 101-410-1910-44370 Conferences & Training 273 20 100 500 - 500 1,000 100.00%APA Conference Total Charges and Services 68,515$ 47,023$ 30,667$ 44,124$ 27,563$ 41,110$ 29,551$ -33.03% Miscellaneous 101-410-1910-44300 Miscellaneous 76 - - 200 - 100 100 -50.00% Total Miscellaneous 76$ -$ -$ 200$ -$ 100$ 100$ -50.00% 1910 Total Planning & Zoning 254,182$ 249,467$ 236,344$ 275,408$ 191,545$ 264,698$ 339,900$ 23.42% 1930 Engineering Services Charges and Services 101-410-1930-43030 Engineering Services 31,770 38,482 30,000 40,000 20,000 30,000 35,000 -12.50% 101-410-1930-43210 Telephone - - - - - - - #DIV/0! Total Charges and Services 31,770$ 38,482$ 30,000$ 40,000$ 20,000$ 30,000$ 35,000$ -12.50% Capital Outlay 101-480-8000-45900 Construction Projects - - - - - - - #DIV/0! Total Capital Outlay -$ -$ -$ -$ -$ -$ -$ #DIV/0! 1930 Total Engineering Services 31,770$ 38,482$ 30,000$ 40,000$ 20,000$ 30,000$ 35,000$ -12.50% 1940 City Hall Materials and Supplies 101-410-1940-42110 Cleaning Supplies - 97 17 100 - 100 200 100.00%increase for moving staff back to 3800 101-410-1940-42230 Building Repair Supplies 801 124 107 800 87 800 1,000 25.00% Total Materials and Supplies 801$ 221$ 124$ 900$ 87$ 900$ 1,200$ 33.33% Charges and Services 101-410-1940-43185 IT Support - 5,244 5,769 6,039 4,171 6,039 1,322 -78.12%Allcoation for 2022 has changed!!! Includes all the Rosville bill ( IT Support, Software, and Telephone) 101-410-1940-42002 IT Hardware - 505 - - - - - #DIV/0! 101-410-1940-43190 Software Programs - - - - - - - #DIV/0! 101-410-1940-43210 Telephone 870 893 - 903 - 903 - -100.00% 101-410-1940-43810 Electric Utility 3,686 3,506 3,033 4,555 3,033 4,555 17,592 286.21%xcel-increase for moving staff back to 3800, brookfield and temp trailer 101-410-1940-43840 Refuse 1,402 1,783 1,608 1,648 1,168 1,648 1,697 3.00% 101-410-1940-44010 Repairs/Maint Contractual Bldg 11,353 5,984 5,855 6,600 5,982 6,600 13,200 100.00%cintas and cleaning, increase every week cleaning rather than e/o 101-410-1940-44040 Repairs/Maint Contractual Eqpt 14,434 11,577 10,795 16,000 7,852 16,000 16,000 0.00% 101-410-1940-44120 Rentals - Building 7,998 - - - (2,666) - - #DIV/0! 101-410-1940-44371 Allocation to Building Inspections - - - (15,482) - (15,482) (32,623) 110.72%Allocation to Building Inspection department Total Charges and Services 39,745$ 29,583$ 27,151$ 20,263$ 19,541$ 20,263$ 17,188$ -15.18% Miscellaneous 101-410-1940-44300 Miscellaneous 1,286 1,276 828 1,800 849 1,800 30,000 1566.67%includes security cameras for new city center ($13k) and final year of taxes on 3880 ($15k) Total Miscellaneous 1,286$ 1,276$ 828$ 1,800$ 849$ 1,800$ 30,000$ 1566.67% 1940 Total City Hall 41,832$ 31,079$ 28,103$ 22,963$ 20,477$ 22,963$ 48,388$ 110.72% 2100 Police Charges and Services 101-420-2100-43150 Law Enforcement Contract 665,309 702,403 761,969 920,183 460,725 920,183 946,410 2.85% 101-420-2100-44300 Misc. - Community Event 1,800 - - 1,800 - 1,800 1,800 0.00% Total Charges and Services 667,109$ 702,403$ 761,969$ 921,983$ 460,725$ 921,983$ 948,210$ 2.84% 2100 Total Police 667,109$ 702,403$ 761,969$ 921,983$ 460,725$ 921,983$ 948,210$ 2.84% 2150 Prosecution Charges and Services 101-420-2150-43045 Attorney Criminal 42,164 46,434 48,392 51,000 29,232 51,000 51,000 0.00%est as contract ends 2021 Total Charges and Services 42,164$ 46,434$ 48,392$ 51,000$ 29,232$ 51,000$ 51,000$ 0.00% 2150 Total Prosecution 42,164$ 46,434$ 48,392$ 51,000$ 29,232$ 51,000$ 51,000$ 0.00% 2220 Fire Personnel 101-420-2220-41010 Full-time Salaries 85,800 82,175 73,917 169,562 99,014 169,562 344,251 103.02%Add 2 FT Firefighter's 101-420-2220-41030 Part-time Salaries 114,980 186,057 178,775 191,527 77,201 101,778 94,240 -50.80%PT adjustments based on 2 FT staff. 101-420-2220-41035 Paid On Call Salaries 73,656 59,412 48,447 75,000 67,684 91,484 94,229 25.64%Reflects increased training, all call response, EM Responder pay, FFI/II class pay 101-420-2220-41210 PERA Contributions 31,340 37,736 28,053 42,012 31,337 42,012 72,932 73.60% 101-420-2220-41220 FICA Contributions 10,945 14,185 14,323 27,038 3,784 22,495 33,029 22.16% 101-420-2220-41230 Medicare Contributions 3,709 4,408 4,733 6,323 3,467 5,261 7,724 22.16% 101-420-2220-41300 Insurance 14,878 15,126 9,883 31,726 16,813 31,726 69,741 119.82%addl full time fire fighters 101-420-2220-41325 Life Insurance 120 312 - 120 30 120 252 110.10% 101-420-2220-41330 STD/LTD 528 484 579 1,108 345 1,108 2,286 106.31% 101-420-2220-41420 Unemployment Benefits 20 2,431 653 2,500 - - - -100.00% 101-420-2220-41510 Workers Compensation 31,635 41,977 47,294 52,023 39,378 39,378 43,316 -16.74% Total Personnel 367,612$ 444,303$ 406,656$ 598,939$ 339,053$ 504,925$ 762,000$ 27.23% Materials and Supplies 101-420-2220-42000 Office Supplies 1,136 1,413 920 1,000 769 836 1,000 0.00% 101-420-2220-42080 EMS Supplies 236 2,317 4,066 2,400 1,033 2,400 2,400 0.00% 101-420-2220-42090 Fire Prevention 332 651 1,710 2,000 991 1,900 2,000 0.00% 101-420-2220-42120 Fuel, Oil and Fluids 13,252 13,948 7,683 14,000 8,459 11,770 14,000 0.00%101-420-2220-42400 Small Tools & Equipment 27,785 16,076 15,261 24,679 23,120 29,422 25,419 3.00% Total Materials and Supplies 42,741$ 34,405$ 29,640$ 44,079$ 34,371$ 46,328$ 44,819$ 1.68% Charges and Services 101-420-2220-43050 Physicals 8,796 8,878 4,883 8,300 6,352 8,678 8,500 2.41%2 FT, 4 POC - Annual Physicals not done 2020 (COVID), resume in 2021 101-420-2220-43150 Contract Services 1,000 11,115 41,635 3,500 2,550 3,500 3,500 0.00%Actuarial Fees for Relief Association $1000. Risk Assessment, might increase. 101-420-2220-43185 IT Support - 21,605 20,550 18,843 14,856 18,843 19,418 3.05%Allcoation for 2022 has changed!!! Includes all the Rosville bill ( IT Support, Software, and Telephone) 101-420-2220-42002 IT Hardware - 2,554 - 1,200 - 1,200 3,400 183.33%CAD Units for CV1 and T1. No Computer Replacement in 2022 per Dustin. 101-420-2220-43190 Software Programs - 341 - - - - 3,730 #DIV/0!Moved out of Dues / Subscriptions - Staff scheduling software 101-420-2220-43210 Telephone 3,798 3,274 4,657 4,674 3,134 4,440 4,660 -0.30%Verizon: CAD and Cell Data plans - add 2 more devices in 2022. Sprint bill out 101-420-2220-43230 Radio 18,928 18,200 19,525 20,000 8,531 21,200 21,499 7.50%Pager replacement/ additions. Does not include any radio replacements. 101-420-2220-43310 Mileage 370 178 190 500 - 500 500 0.00% 101-420-2220-43630 Insurance 7,195 7,825 9,515 10,467 9,563 10,467 11,514 10.00% 101-420-2220-43810 Electric Utility 12,756 13,441 11,002 15,450 9,658 15,450 15,914 3.00% 101-420-2220-43840 Refuse 586 746 707 1,030 579 1,030 1,061 3.00% 101-420-2220-44010 Repairs/Maint Bldg 14,543 10,688 7,077 9,000 9,260 10,520 9,000 0.00%Station #2 Septic Pumping 101-420-2220-44040 Repairs/Maint Eqpt 48,372 57,265 50,901 43,920 39,154 40,960 43,920 0.00% 101-420-2220-44170 Uniforms 8,615 8,133 7,696 10,000 8,810 10,000 10,000 0.00%New hire uniform needs 101-420-2220-44330 Dues & Subscriptions 4,285 3,998 2,779 6,330 5,931 6,330 3,450 -45.50%NFPA Code Subscription service 101-420-2220-44350 Books - 1,400 1,064 1,000 942 1,000 1,000 0.00% 101-420-2220-44370 Conferences & Training 17,743 14,174 23,427 20,580 7,459 25,276 24,568 19.38%4 POC New Hires, New Officer training / Continuing Education Total Charges and Services 146,988$ 183,814$ 205,773$ 174,794$ 126,789$ 179,394$ 185,633$ 6.20% Capital Outlay 101-420-2220-47200 Transfer to Vehicle Replacement Fund - Fire 51,537 101-480-8000-45800 Equipment - - - - - - 92,286 #DIV/0!Turnout gear replacements and radio grant match Total Capital Outlay -$ -$ -$ -$ -$ -$ 143,823$ #DIV/0! Miscellaneous 101-420-2220-44300 Miscellaneous 1,524 1,492 439 2,000 1,270 - 2,000 0.00% Total Miscellaneous 1,524$ 1,492$ 439$ 2,000$ 1,270$ -$ 2,000$ 0.00% #DIV/0! 2220 Total Fire 558,866$ 664,014$ 642,509$ 819,812$ 501,484$ 730,647$ 1,138,275$ 38.85% 2250 Fire Relief Charges and Services 101-420-2250-44920 Fire State Aid 64,533 68,975 76,608 64,000 - 64,000 76,608 19.70%Relief Assoc. pass through Total Charges and Services 64,533$ 68,975$ 76,608$ 64,000$ -$ 64,000$ 76,608$ 19.70% 2250 Total Fire Relief 64,533$ 68,975$ 76,608$ 64,000$ -$ 64,000$ 76,608$ 19.70% 2400 Building Inspection Personnel 101-420-2400-41010 Full-time Salaries 210,186 214,668 245,057 400,707 210,906 305,834 427,111 6.59%Continue to budget for B.O. Added Code Enforcement Officer 20% Building 101-420-2400-41030 Part-time Salaries - - - - - - - #DIV/0! 101-420-2400-41020 Overtime - 2,996 - - - - - #DIV/0! 101-420-2400-41040 Temporary Employees - - - - - - - #DIV/0! 101-420-2400-41210 PERA Contributions 15,769 14,824 16,888 30,053 16,511 22,938 32,033 6.59% 101-420-2400-41216 MSRS Contributions -City Admin - - - 504 310 504 519 2.94% 101-420-2400-41220 FICA Contributions 12,619 12,481 13,347 24,844 11,883 18,962 26,481 6.59% 101-420-2400-41230 Medicare Contributions 2,951 2,907 3,195 5,810 2,901 4,435 6,193 6.59% 101-420-2400-41300 Insurance 28,792 23,088 35,196 81,179 36,045 81,179 90,962 12.05% 101-420-2400-41325 Life Insurance 297 635 124 331 138 331 344 3.94% 101-420-2400-41330 STD/LTD 1,136 668 822 2,341 871 2,341 2,473 5.64% 101-420-2400-41510 Workers Compensation 2,567 2,070 4,377 4,815 4,222 4,222 4,644 -3.55% Total Personnel 274,318$ 274,337$ 319,008$ 550,584$ 283,787$ 440,745$ 590,760$ 7.30% Materials and Supplies 101-420-2400-42000 Office Supplies 865 558 698 1,750 301 1,000 1,750 0.00%new staff supplies 101-420-2400-42030 Printed Forms - - - 350 - 350 350 0.00% 101-420-2400-42120 Fuel, Oil and Fluids 2,841 1,976 2,123 3,600 2,451 3,600 4,000 11.11% Total Materials and Supplies 3,706$ 2,534$ 2,821$ 5,700$ 2,752$ 4,950$ 6,100$ 7.02% Charges and Services 101-420-2400-43030 Engineering - 3,548 245 5,000 - 5,000 5,000 0.00% 101-420-2400-43150 Inspector Contract Services - 142,283 755,966 319,300 577,917 866,530 328,879 3.00%MnSPECT (or equivalent of 3 FTEs) Incl contract for op audit 101-420-2400-43185 IT Support 4,312 6,667 9,688 6,820 4,633 6,820 13,378 96.16%Allcoation for 2022 has changed!!! Includes all the Rosville bill ( IT Support, Software, and Telephone) 101-420-2400-42002 IT Hardware - 1,480 - 700 546 546 2,520 260.00%Computer Desktops 3. Also added 20% computer cost for Code Enforcement Officer 101-420-2400-43190 Software Programs - 986 395 1,100 1,495 3,280 3,500 218.18%i-pads and PermitWorks,Roseville 101-420-2400-43210 Telephone 3,579 3,323 3,242 3,760 2,443 4,100 6,170 64.10%Sprint, verizon card costs. One additional phone for new staff and Code Enforcement officer 101-420-2400-43630 Insurance 3,566 2,790 3,387 4,962 3,404 3,404 5,458 10.00% 101-420-2400-44040 Repairs/Maint Eqpt 1,012 2,000 1,717 1,500 1,415 1,500 1,500 0.00% 101-420-2400-44170 Uniforms 560 260 190 800 90 500 1,200 50.00%Jackets, shirts, ID's 101-420-2400-44330 Dues & Subscriptions 65 260 130 500 65 130 500 0.00% 101-420-2400-44350 Books 231 1,168 595 600 317 600 1,800 200.00% 101-420-2400-44370 Conferences & Training 2,885 2,705 791 3,200 900 1,700 4,000 25.00% Total Charges and Services 16,209$ 167,470$ 776,346$ 348,242$ 593,225$ 894,110$ 373,905$ 7.37% Capital Outlay 101-420-2400-47200 Transfer Out to Vehicle Replacement - Building 9,539 101-480-2400-45500 - - - - - - - #DIV/0! Total Capital Outlay -$ -$ -$ -$ -$ -$ 9,539$ #DIV/0! Miscellaneous 101-420-2400-44371 Allocations from Admin, Finance, City Hall - - - 20,616 - 19,620 36,981 79.38% 101-420-2400-44300 Miscellaneous - 266 152 1,000 325 1,000 1,000 0.00% Total Miscellaneous -$ 266$ 152$ 21,616$ 325$ 20,620$ 37,981$ 75.71% 2400 Total Building Inspection 294,233$ 444,607$ 1,098,326$ 926,142$ 880,088$ 1,360,425$ 1,018,285$ 9.95% 2500 Emergency Communications Charges and Services 101-420-2500-43150 Contract Services 900 1,933 900 3,350 1,254 - 20,136 501.07%Increse due to repair/replace siren pole. Total Charges and Services 900$ 1,933$ 900$ 3,350$ 1,254$ -$ 20,136$ 501.07% 2500 Total Emergency Communications 900$ 1,933$ 900$ 3,350$ 1,254$ -$ 20,136$ 501.07% 2700 Animal Control Charges and Services 101-420-2700-43150 Contract Services 10,930 19,902 13,066 13,000 6,939 13,000 13,000 0.00% Total Charges and Services 10,930$ 19,902$ 13,066$ 13,000$ 6,939$ 13,000$ 13,000$ 0.00% 2700 Total Animal Control 10,930$ 19,902$ 13,066$ 13,000$ 6,939$ 13,000$ 13,000$ 0.00% 3100 Streets Personnel 101-430-3100-41010 Full-time Salaries 357,436 382,736 344,197 412,315 238,523 412,315 386,752 -6.20%Reallocated based upon 2020 YTD actual re: time allocation. New Assistant Director split with other departments. 101-430-3100-41030 Part-time Salaries - - 126 - - - - #DIV/0! 101-430-3100-41020 Overtime 4,676 12,217 22,670 6,000 5,904 9,464 9,748 62.47%On call and overtime. Based on actuals 101-430-3100-41040 Temporary Employees 2,550 4,527 - 12,500 4,871 7,000 18,000 44.00%40h x 15weeks x 2 = 18,000. Increased pay to $15h 101-430-3100-41210 PERA Contributions 26,793 28,848 28,634 31,374 18,202 31,633 29,738 -5.22% 101-430-3100-41220 FICA Contributions 21,864 23,455 22,644 26,711 14,764 26,584 25,699 -3.79% 101-430-3100-41230 Medicare Contributions 5,113 5,463 5,322 6,247 3,453 6,217 6,010 -3.79% 101-430-3100-41300 Insurance 63,766 79,988 73,684 92,920 49,255 92,920 86,942 -6.43% 101-430-3100-41325 Life Insurance 536 1,706 320 427 216 427 379 -11.28% 101-430-3100-41330 STD/LTD 1,750 1,496 3,075 2,267 1,278 2,267 2,166 -4.44% 101-430-3100-41600 Safety Clothing Allowance 160 515 277 600 - 600 800 33.33%Boots ($200 per person allocated by Salary Allocation) 101-430-3100-41420 Unemployment Benefits 3,636 - - - - - - #DIV/0! 101-430-3100-41510 Workers Compensation 23,593 31,402 37,462 41,208 49,530 49,530 54,483 32.21% Total Personnel 511,872$ 572,353$ 538,412$ 632,569$ 385,996$ 638,959$ 620,717$ -1.87% Materials and Supplies 101-430-3100-42000 Office Supplies 443 1,368 247 500 245 500 500 0.00% 101-430-3100-42120 Fuel, Oil and Fluids 41,006 17,663 20,358 21,000 14,179 21,000 22,000 4.76%more roads to maintain101-430-3100-42150 Operating Supplies 5,606 16,628 9,998 9,500 6,127 9,500 9,500 0.00% Contract Service ROW - - - - - - - #DIV/0! 101-430-3100-42210 Repair/Maint. Supplies 28,270 12,678 6,131 10,000 6,871 9,000 10,000 0.00% 101-430-3100-42212 Repair/Maint. Supplies S&I 228 8,834 9,484 10,000 6,301 10,000 10,000 0.00% 101-430-3100-42240 Street Maintenance & Landscaping - Materials 31,198 50,356 22,135 39,000 27,181 33,000 35,000 -10.26%Sealcoat and Crackseal materials - potholes, landscape fixes, etc, 101-430-3100-42250 Street Maintenance 6,371 146 - - - - - #DIV/0! 101-430-3100-42260 Street Signs 8,944 3,287 4,020 4,000 717 4,000 4,000 0.00% 101-430-3100-42290 Sand/Salt S&I 125,999 129,492 111,880 85,000 53,325 53,325 62,000 -27.06%Ordered 800 tons of regular, have 700 tons of treated and 500 tons of regular on hand 101-430-3100-42400 Small Tools & Minor Equipment 6,166 16,188 3,095 4,500 2,667 4,500 4,500 0.00% 101-430-3100-44375 Personal Protection Equipment 1,188 800 1,411 1,200 59 1,200 1,200 0.00% Total Materials and Supplies 255,419$ 257,439$ 188,759$ 184,700$ 117,672$ 146,025$ 158,700$ -14.08% Charges and Services 101-430-3100-43030 Engineering Services 7,844 13,178 12,938 14,000 7,743 14,000 14,000 0.00%ROW permits 101-430-3100-43090 Sealcoating & Crack Sealing 115,018 795,917 552,506 565,000 437,608 565,000 1,015,000 79.65%Sealcoat, crack seal -catching us up through 2019 constructed roads- no M/O scheduled for 2022- this will drop significantly in 2023. Trunk Highway 36 Manning Interchange 101-430-3100-43150 Contract Services (3,461) 20,364 18,572 24,000 9,821 20,000 24,000 0.00%Striping, guard rail repair, tree trimming, mowing, etc. 101-430-3100-43185 IT Support 6,191 15,869 11,185 12,976 6,555 12,976 17,309 33.40%Allocation for 2022 has changed!!! Includes all the Rossville bill ( IT Support, Software, and Telephone) 101-430-3100-42002 IT Hardware 37 513 - 750 - - 750 0.00%1 Computer 101-430-3100-43190 Software Programs - 1,540 3,662 1,750 5,344 6,000 8,263 372.14%BeHIve Asset Mgmt-added sign modual $2500 and goodpoint 101-430-3100-43210 Telephone 6,156 3,946 3,840 5,500 3,260 5,000 5,000 -9.09%Sprint, TDS, Verizon , Comcast 101-430-3100-43230 Radio 24,117 4,091 4,001 5,000 2,120 4,700 6,750 35.00%Wash Co. fees. Add Radio 101-430-3100-43310 Mileage - 280 - 250 - - 100 -60.00% 101-430-3100-43510 Public Notices - 212 134 212 - 212 212 0.00% 101-430-3100-43630 Insurance 17,740 19,293 23,443 25,787 23,562 25,787 28,366 10.00% 101-430-3100-43810 Electric Utility 65,937 25,795 31,544 25,000 17,861 27,000 30,000 20.00%US Solar Subsription/Traffic Signals/PW Electric. Add square footage101-430-3100-43811 Street Lights - 39,576 41,778 39,000 36,076 45,000 45,000 15.38% 101-430-3100-43840 Refuse 5,998 7,420 5,294 4,600 3,831 5,500 5,500 19.57% 101-430-3100-44010 Repairs/Maint Bldg.35,637 21,541 4,488 12,000 2,847 10,000 12,000 0.00% 101-430-3100-44030 Repairs/Maint Imp Other Than Bldg.2,955 298 2,848 650 579 750 850 30.77% 101-430-3100-44040 Repairs/Maint Equip 27,429 28,422 9,971 29,500 7,008 20,000 20,000 -32.20% 101-430-3100-44041 Repairs/Maint Equip S&I 1,182 19,872 13,504 14,000 2,220 12,000 13,000 -7.14% 101-430-3100-44130 Equipment Rental 2,500 163 1,845 2,000 - 1,250 1,250 -37.50% 101-430-3100-44170 Uniforms 8,047 5,605 5,531 5,700 3,451 5,600 5,700 0.00%Allocate to all dept 101-430-3100-44330 Dues & Subscriptions 661 606 614 750 323 750 750 0.00% 101-430-3100-44370 Conferences & Training 2,956 6,043 463 4,500 780 3,500 4,175 -7.22% Total Charges and Services 326,945$ 1,030,568$ 748,240$ 792,925$ 570,990$ 785,025$ 1,257,975$ 58.65% Capital Outlay 101-430-3100-47200 Transfer to Vehicle Replacement Fund - Streets 86,963 101-480-3100-45500 - 256,350 #DIV/0!Patching trailer and median. $186,350 to the street landscape budget for 2022 for the 5th St medians Total Capital Outlay -$ -$ -$ -$ -$ -$ 343,313$ #DIV/0! Miscellaneous 101-430-3100-44300 Miscellaneous 559 1,866 689 1,000 461 461 475 -52.50% Total Miscellaneous 559$ 1,866$ 689$ 1,000$ 461$ 461$ 475$ -52.50% 3100 Total Streets 1,094,795$ 1,862,226$ 1,476,101$ 1,611,194$ 1,075,118$ 1,570,470$ 2,381,180$ 47.79% 5200 Parks & Recreation Personnel 101-450-5200-41010 Full-time Salaries 64,831 80,410 93,671 72,988 61,660 72,988 91,652 25.57%Reallocated based upon 2020 YTD actual re: time allocation. New Assistant Director split with other departments. 101-450-5200-41030 Part-time Salaries - 47 8,378 - - - - #DIV/0! 101-450-5200-41020 Overtime - 97 315 - - - - #DIV/0! 101-450-5200-41040 Temporary Employees 9,311 4,725 605 10,000 5,054 7,000 10,500 5.00%Seasonal Workers/Park Summer-Ice Rink Winter 101-450-5200-41210 PERA Contributions 4,977 5,628 7,366 5,474 4,589 5,474 6,874 25.57% 101-450-5200-41220 FICA Contributions 4,493 4,886 6,443 5,145 3,980 4,959 6,333 23.10% 101-450-5200-41230 Medicare Contributions 1,051 1,138 1,510 1,203 931 1,160 1,481 23.13% 101-450-5200-41300 Insurance 5,590 11,314 18,768 15,415 11,811 15,415 19,748 28.11% 101-450-5200-41325 Life Insurance 57 322 82 67 50 67 81 21.16% 101-450-5200-41330 STD/LTD 181 241 713 401 316 401 514 28.19% 101-450-5200-41600 Safety Clothing Allowance - 175 240 350 335 270 270 -22.86%Boots ($200 per person allocated by Salary Allocation) 101-450-5200-41420 Unemployment Benefits - - - - - - - #DIV/0! 101-450-5200-41510 Workers Compensation 22,078 8,772 9,910 10,901 4,145 10,901 11,991 10.00% Total Personnel 112,569$ 117,752$ 148,000$ 121,944$ 92,871$ 118,635$ 149,445$ 22.55% Materials and Supplies 101-450-5200-42000 Office Supplies 394 408 43 450 126 450 450 0.00% 101-450-5200-42120 Fuel, Oil and Fluids - 7,839 4,702 5,500 5,092 6,000 6,250 13.64%Allocated to all PW departments101-450-5200-42150 Operating Supplies 989 672 444 750 611 750 750 0.00% 101-450-5200-42160 Chemicals 579 201 201 - - - - #DIV/0! 101-450-5200-42210 Repair/Maint. Supplies 5,107 6,969 9,479 6,000 4,703 6,000 7,250 20.83% 101-450-5200-42230 Building Repair Supplies 63 69 - 500 360 500 500 0.00% 101-450-5200-42250 Landscaping Materials - 135 562 550 456 650 650 18.18% 101-450-5200-42400 Small Tools & Minor Equipment 1,570 784 4,752 4,550 1,564 4,550 4,550 0.00%small aluminum trailer $1500 Total Materials and Supplies 8,701$ 17,076$ 20,184$ 18,300$ 12,911$ 18,900$ 20,400$ 11.48% Charges and Services 101-450-5200-43030 Engineering Services 123 - - - - - - #DIV/0! 101-450-5200-43150 Contracted Services 63,562 51,108 77,697 56,000 29,128 56,000 74,500 33.04%Mowing $50k, $15k Fertilizer, $7k misc ( additions for mowing/ fertilizing /irrigating fields and $2500 for sunfish prairie maintenance) 101-450-5200-43185 IT Support 2,620 5,019 5,844 5,500 4,221 5,500 2,909 -47.12%Allcoation for 2022 has changed!!! Includes all the Rosville bill ( IT Support, Software, and Telephone) 101-450-5200-42002 IT Hardware - 505 - - - - - #DIV/0! 101-450-5200-43190 Software Programs - 340 - - - - - #DIV/0! 101-450-5200-43210 Telephone 1,085 1,770 1,290 1,750 676 1,750 1,750 0.00%Sprint 101-450-5200-43510 Public Notices - - - - - - - #DIV/0! 101-450-5200-43630 Insurance 5,403 5,876 7,144 7,858 7,180 7,858 8,644 10.00% 101-450-5200-43810 Electric Utility 7,314 8,622 8,707 10,815 7,584 10,815 11,139 3.00% 101-450-5200-43820 Water Utility - 184 - - - - - #DIV/0! 101-450-5200-43840 Refuse 2,609 4,564 3,166 4,000 2,556 4,000 4,000 0.00% 101-450-5200-44010 Repairs/Maint Bldg 2,074 6,289 4,570 3,000 1,763 2,500 3,000 0.00% 101-450-5200-44030 Repairs/Maint Imp Not Bldgs 5,434 3,063 4,480 3,200 2,071 3,000 3,200 0.00% 101-450-5200-44040 Repairs/Maint Eqpt 5,200 17,669 1,688 14,000 3,478 12,500 14,000 0.00% 101-450-5200-44120 Rentals - Buildings 6,294 5,489 6,712 7,000 6,842 7,000 7,000 0.00%porta-potties at new parks 101-450-5200-44170 Uniforms - 837 930 1,100 695 1,100 1,100 0.00%Allocated from Streets101-450-5200-44301 Events 482 524 544 - - - 550 #DIV/0!Tree Give Away 101-450-5200-44302 Lakes 9,934 12,570 14,956 15,000 5,000 15,000 15,000 0.00%Grant to treat Invasive Species 101-450-5200-44330 Dues & Subscriptions - - 60 - - - - #DIV/0! 101-450-5200-44370 Conferences & Training 1,495 2,137 2,828 3,000 815 2,000 3,000 0.00% 101-450-5200-44130 Equipment Rental 650 797 415 1,000 - 500 750 -25.00% 101-450-5200-44375 Personal Protection Equipment 1,262 229 435 400 - 400 400 0.00% Total Charges and Services 115,539$ 127,590$ 141,466$ 133,623$ 72,009$ 129,923$ 150,942$ 12.96% Capital Outlay 101-450-5200-47200 Transfer Out to Vehicle Replacement - PW - Park & Rec 1,961 101-900-5200-45500 Capital Purchases - - - - - - - #DIV/0! Total Capital Outlay -$ -$ -$ -$ -$ -$ 1,961$ #DIV/0! Miscellaneous 101-450-5200-44300 Miscellaneous 958 1,555 416 1,000 - 650 750 -25.00% Total Miscellaneous 958$ 1,555$ 416$ 1,000$ -$ 650$ 750$ -25.00% 5200 Total Parks & Recreation 237,768$ 263,973$ 310,067$ 274,867$ 177,791$ 268,108$ 323,498$ 17.69% 9000 Transfers Transfers 101-900-9000-47205 Operating Transfer to EDA 25,225 30,000 30,000 30,000 - 30,000 - -100.00%city lease space 2019-2021 transfer to Brookfield - Budget here but JE will be a transfer See below 101-900-9000-47201 Transfer to Project Fund - - 15,661 - 30,000 - 17,254 #DIV/0!Inwood & 5th St Stop Light 101-900-9000-47285 Transfer to Debt Service - 67,859 - - - - - #DIV/0! 101-900-9000-47250 Transfer to Vehicle Replacement Fund - 570,076 903,847 125,000 - - - -100.00%101-900-9000-47200 Transfer to Vehicle Replacement Fund - 75,000 100,000 135,746 - - - -100.00% Total Transfers 25,225$ 742,935$ 1,049,508$ 290,746$ 30,000$ 30,000$ 17,254$ -94.07% 9000 Total Transfers 25,225$ 742,935$ 1,049,508$ 290,746$ 30,000$ 30,000$ 17,254$ -94.07% 9000 Contingency Reserve Contingency Reserve Reserve for possible Insurance Increase - - - - - - - #DIV/0! Total Contingency Reserve -$ -$ -$ -$ -$ -$ -$ #DIV/0! 9000 Contingency Reserve -$ -$ -$ -$ -$ -$ -$ #DIV/0! Prior Period Adjustments (52,015)$ Total General Fund Expenditures:4,135,510$ 5,954,319$ 6,482,385$ 6,063,620$ 3,923,774$ 6,066,034$ 7,248,538$ 19.54% Total Gen Fund Revs. Over/(Under) Expenditures:880,452$ (440,535)$ 23,487$ (2)$ (142,293)$ 584,863$ (0)$ -85.98%Use of Fund Balance if negative 601 Water Fund Water Fund Revenues: 601-000-0000-36100 Special Assessments 41,737 - 762 10,740 52,208 - - -100.00%This account should zero out at year end since revenues are recognized 100% as they are issued/earned and adjusted through Receivables deferred 601-000-0000-36101 Delinquent Special Assessments 563 - (675) - - - - #DIV/0! 601-000-0000-36102 Special Assessments Penalties & Interest 190 96 1 - 71 - - #DIV/0! 601-000-0000-36103 Prepaid Special Assessments - - - - - - - #DIV/0! 601-000-0000-36200 Miscellaneous 82 - - - - - - #DIV/0! 601-000-0000-36206 Smart Controller Pilot Program - 875 (3,375) - - - - #DIV/0! 601-000-0000-36210 Interest on Investments 43,477 183,387 128,678 39,928 - 65,379 32,689 -18.13%50% of CY. Rates have gone down 601-000-0000-36212 Interest on Assessments - 11,872 10,950 - - - - #DIV/0! 601-000-0000-36220 Rent - 10,010 26,000 26,000 8,000 16,000 - -100.00%Rent on Land from 3M 601-000-0000-37100 Water Sales 763,475 849,564 1,046,893 1,029,177 546,776 - 1,147,441 11.49%Estimate from utility proforma 601-000-0000-37120 Bulk Water 1,122 1,394 3,381 1,000 710 2,000 2,000 100.00% 601-000-0000-37130 Water Lat Benefit Fee 26,100 5,800 5,800 - 5,800 - - #DIV/0! 601-000-0000-37140 Water Access Revenue 818,000 475,000 1,205,000 1,617,000 1,532,000 1,437,000 1,104,000 -31.73% 601-000-0000-37150 Water Connections - Municipal 489,000 500,900 522,000 451,000 437,000 416,000 456,000 1.11% 601-000-0000-37160 Penalties - - 10,830 - - - - #DIV/0! 601-000-0000-37170 Meter Sales 115,036 97,342 155,831 95,000 113,114 146,937 130,600 37.47%Includes sale of meters for Hamlet and 38/39th 601-000-0000-37180 Tower Rent - - - - - - - #DIV/0! 601-000-0000-39200 Transfer In - - - - - - - #DIV/0! Total Water Fund Revenues:2,298,782$ 2,136,239$ 3,112,076$ 3,269,845$ 2,695,678$ 2,083,316$ 2,872,730$ -12.14% Water Fund Expenses: Personnel601-494-9400-41010 Full-time Salaries 126,525 151,029 211,891 217,707 205,189 217,707 309,664 42.24%Reallocated based upon 2020 YTD actual re: time allocation 20% of admin time. New Assistant Director and UB full Time 601-494-9400-41030 Part-time Salaries - - 7,383 13,992 - - - -100.00%new utility billing clerk in 2020 601-494-9400-41020 Overtime - 2,931 1,024 6,000 5,677 8,150 8,395 39.91%On call pay should go here 601-494-9400-41040 Temporary Employees - - - - - - - #DIV/0! 601-494-9400-41210 PERA Contributions 1,131 17,702 14,164 17,827 15,720 16,939 23,854 33.81% 601-494-9400-41216 MSRS Contributions -City Admin - - - 461 379 461 634 37.42% 601-494-9400-41220 FICA Contributions 7,402 8,899 11,334 14,737 12,431 14,003 19,720 33.81% 601-494-9400-41230 Medicare Contributions 1,703 2,075 2,666 3,447 2,907 3,275 4,612 33.79% 601-494-9400-41300 Insurance 19,842 25,225 37,591 44,902 41,523 44,902 68,291 52.09% 601-494-9400-41325 Life Insurance 236 635 183 197 162 197 251 27.64% 601-494-9400-41330 STD/LTD 571 560 1,301 1,177 1,031 1,177 1,755 49.10% 601-494-9400-41420 Unemployment Benefits 897 - - - - - - #DIV/0! 601-494-9400-41600 Safety Clothing Allowance - 465 370 400 - 400 665 66.25%Boots ($200 per person allocated by Salary Allocation) 601-494-9400-41510 Workers Compensation 7,744 5,859 6,984 7,682 7,853 7,853 8,638 12.45% Total Personnel 166,050$ 215,380$ 294,891$ 328,529$ 292,871$ 315,065$ 446,479$ 35.90% Materials and Supplies 601-494-9400-42000 Office Supplies 396 770 676 800 364 700 750 -6.25% 601-494-9400-42120 Fuel, Oil and Fluids - 8,623 6,282 9,000 5,414 9,000 9,000 0.00%Allocated to all PW Departments 601-494-9400-42030 Printed Forms 167 432 610 750 391 782 850 13.33% 601-494-9400-42150 Operating Supplies 876 2,133 2,276 3,500 1,791 3,000 3,200 -8.57%Lab Tests Baterial 601-494-9400-42160 Chemicals 7,511 4,260 5,089 11,000 6,442 11,000 12,000 9.09% 601-494-9400-42210 Repair/Maint. Supplies 12,808 9,865 6,072 16,000 2,826 12,000 12,000 -25.00% 601-494-9400-42270 Utility System Maintenance 805 564 - - - - - #DIV/0! 601-494-9400-42300 Water Meters & Supplies 138,652 85,217 157,615 145,000 159,016 155,000 205,600 41.79%Water meters601-494-9400-44375 Personal Protective Equipment 866 606 801 800 - 800 900 12.50% 601-494-9400-42400 Small Tools & Minor Equipment 6,924 7,452 4,840 9,800 2,798 7,500 7,500 -23.47% Total Materials and Supplies 169,005$ 119,922$ 184,259$ 196,650$ 179,042$ 199,782$ 251,800$ 28.04% Charges and Services 601-494-9400-43030 Engineering Services (17,911) 40,064 7,073 25,000 6,258 25,000 25,000 0.00% 601-494-9400-43040 Legal Services 132,919 1,556,524 - - 8,704 20,000 40,000 #DIV/0!legal/lobbyist for WBL approp issue 601-494-9400-43010 Audit Services - 9,246 9,105 8,227 8,608 8,227 8,706 5.82% split GF, Water, Sewer, SW 601-494-9400-43090 Newsletter - - 1,122 1,100 571 1,199 1,300 18.18%printing only (split with Communications and sewer) 601-494-9400-43150 Contract Services 54,608 39,809 45,352 30,000 34,976 45,000 40,000 33.33%New well, additional water mains, hydrants, valves etc 601-494-9400-43185 IT Support 30,331 7,761 8,860 8,027 6,400 9,746 9,817 22.30%Allcoation for 2022 has changed!!! Includes all the Rosville bill ( IT Support, Software, and Telephone) 601-494-9400-42002 IT Hardware - 505 1,030 1,000 - 1,000 1,350 35.00%New scada monitor (1/2 sewer) and two new computers (split streets/water/sewer) 601-494-9400-43190 Software Programs - 8,909 11,875 9,900 4,067 9,900 12,670 27.98%Banyon, Accela-Springbrook support, Springbrook subscription, Beehive, Sensus, Misc 601-494-9400-43210 Telephone 1,141 1,991 1,508 2,000 836 2,000 2,600 30.00%TDS. Assistant PW Director 601-494-9400-43220 Postage 3,509 2,580 2,259 4,000 1,414 3,500 4,142 3.55% 601-494-9400-43310 Mileage 558 306 65 200 - 200 200 0.00% 601-494-9400-43610 Insurance 7,981 8,680 10,552 11,607 10,605 11,607 12,768 10.00% 601-494-9400-43810 Electric Utility 76,286 66,432 59,223 80,000 70,066 75,747 78,020 -2.48% 601-494-9400-43820 Water Utility 29,736 14,312 27,432 23,000 16,818 25,000 28,000 21.74%Water Connection Fees MDH. 601-494-9400-44030 Repairs/Maint Imp Not Bldgs 106,871 51,564 11,900 45,000 5,535 35,000 45,000 0.00% 601-494-9400-44040 Repairs/Maint. Equip.10,222 16,958 4,877 7,500 130 7,000 8,500 13.33% 601-494-9400-44010 Repairs/Maint Imp Bldgs 1,005 3,363 4,130 4,000 1,563 4,000 18,000 350.00%Plumb a fill station at shop 601-494-9400-44150 Equipment Rental - 807 800 1,000 - 1,000 1,000 0.00%valve exerciser 601-494-9400-44170 Uniforms - 965 851 1,000 644 1,000 1,000 0.00% 601-494-9400-44330 Dues & Subscriptions - 310 360 400 300 400 400 0.00%601-494-9400-44370 Conferences & Training 1,178 1,510 142 2,500 1,040 2,500 2,450 -2.00% 601-494-9400-44377 Credit Card Fees 740 6,397 9,017 7,262 7,373 9,523 9,809 35.07%PSN CC fees 601-494-9400-44386 Real Estate Taxes - 12,282 23,084 23,777 23,474 23,474 16,119 -32.21%Taxes on 180 acres from 3M Settlement Total Charges and Services 439,174$ 1,851,273$ 240,617$ 296,500$ 209,382$ 322,024$ 366,850$ 23.73% Capital Outlay 601-494-9400-45300 Improvements Other Than Bldgs 45,854 - - 658,844 15,425 - 6,236,219 846.54%Meters. 75K Add CIP items Total Capital Outlay 45,854$ -$ -$ 658,844$ 15,425$ -$ 6,236,219$ 846.54% Miscellaneous and Non-operating 601-494-9400-44300 Miscellaneous 1,086 0 908 2,000 540 2,000 2,000 0.00% 601-494-9400-46010 Bond Principal - - - 790,000 585,000 790,000 880,000 11.39% 601-494-9400-46110 Bond Interest 345,940 271,907 244,340 252,402 219,580 252,402 235,572 -6.67% 601-494-9400-46200 Fiscal Agent Fees - Bond Payments 1,740 495 495 - 165 - - #DIV/0! 601-494-9400-46250 Fiscal Agent Fees - Bond Issuance - - - - - - - #DIV/0! 601-494-9400-46350 Bond Issuance Costs - - - - - - - #DIV/0! 601-494-9400-47200 Transfer Out - - - - - - - #DIV/0! Total Misc. and Non-operating 348,766$ 272,402$ 245,743$ 1,044,402$ 805,285$ 1,044,402$ 1,117,572$ 7.01% Prior Period Adjustments 271,735 Total Water Fund Expenses:1,168,849$ 2,458,977$ 965,511$ 2,524,925$ 1,502,005$ 1,881,273$ 8,418,920$ 233.43% Total Water Fund Revs. Over/(Under) Expenses:1,129,933$ (322,738)$ 2,146,566$ 744,920$ 1,193,673$ 202,043$ (5,546,190)$ -844.53% 602 Sewer Fund Sewer Fund Revenues: 602-000-0000-36100 Special Assessments 239,246 - (10,254) 162,570 130,849 162,570 - -100.00%This account should zero out at year end since revenues are recognized 100% as they are issued/earned and adjusted through Receivables deferred 602-000-0000-36101 Delinquent Special Assessments - - - - - - - #DIV/0! 602-000-0000-36102 Special Assessments Penalties & Interest 344 624 1,710 - 212 - - #DIV/0!602-000-0000-36200 Miscellaneous Water - - 58,350 - - - - #DIV/0! 602-000-0000-36210 Interest on Investments 65,325 190,342 142,328 39,812 (39,106) 73,667 36,834 -7.48%50% of CY. Rates have gone down 602-000-0000-36212 Interest on Assessments - 109,320 91,772 - - - - #DIV/0! 602-000-0000-37160 Penalties - - 1,911 - - - - #DIV/0! 602-000-0000-37200 Sewer Sales 208,908 299,779 354,947 466,378 262,190 466,378 544,013 16.65%Estimate from utility pro forma 602-000-0000-37220 SAC Early Pay Discount/Revenue 7,803 5,308 17,375 7,500 6,312 8,529 8,500 13.33% 602-000-0000-37230 Sewer Lat Benefit Fee - 11,000 48,800 - 25,000 - - #DIV/0! 602-000-0000-37240 Sewer Connecton Fee Revenue (SAC)767,500 505,732 1,256,997 1,359,000 1,479,000 1,359,000 727,500 -46.47% 602-000-0000-37250 Sewer Connection Fees Regional - - - - - - - #DIV/0!Pass-through 602-000-0000-37260 Sewer Connection Fees Municipal 506,050 510,001 533,500 389,000 432,000 389,000 367,000 -5.66% Total Sewer Fund Revenues:1,795,175$ 1,632,106$ 2,497,435$ 2,424,260$ 2,439,056$ 2,459,144$ 1,683,847$ -30.54% Sewer Fund Expenses: Personnel 602-495-9450-41010 Full-time Salaries 54,674 58,207 87,537 82,123 69,843 82,123 132,323 61.13%Reallocated based upon 2020 YTD actual re: time allocation. New Assistant Director and UB full Time 602-495-9450-41020 Overtime - 2,978 108 6,000 5,327 7,453 7,676 27.94%On call pay 602-495-9450-41040 Temporary Employees - - - - - - - #DIV/0! 602-495-9450-41210 PERA Contributions (11,709) 5,925 5,261 7,527 5,562 6,718 10,500 39.50% 602-495-9450-41216 MSRS Contributions -City Admin - - - 308 189 308 317 2.84%City Administrator Deferred Comp included here 602-495-9450-41220 FICA Contributions 3,191 3,499 4,197 6,223 4,387 5,554 8,680 39.48% 602-495-9450-41230 Medicare Contributions 803 817 991 1,455 1,026 1,299 2,030 39.52% 602-495-9450-41300 Insurance 5,036 10,677 11,983 16,435 13,819 16,435 30,046 82.82% 602-495-9450-41325 Life Insurance 72 290 50 69 49 69 95 37.26% 602-495-9450-41330 STD/LTD 180 240 420 440 319 440 727 65.18%602-495-9450-41600 Safety Clothing Allowance - 470 - 140 - 140 140 0.00%Boots ($200 per person allocated by Salary Allocation) 602-495-9450-41420 Unemployment Insurance 555 - - - - - - #DIV/0! 602-495-9450-41510 Workers Compensation 4,626 3,442 4,197 4,617 2,716 4,000 4,000 -13.36% Total Personnel 57,427$ 86,545$ 121,205$ 137,580$ 103,238$ 124,538$ 196,533$ 42.85% Materials and Supplies 602-495-9450-42210 Repair/Maint. Supplies - 1,561 880 3,500 19 2,500 10,000 185.71%$25,000 Bioxide chemical at lisbon lift every 3-5 yrs 602-495-9450-42000 Office Supplies 1,425 426 163 600 284 350 400 -33.33% 602-495-9450-42030 Printed Forms 167 613 451 600 294 588 650 8.33% 602-495-9450-42120 Fuel, Oil and Fluids - 7,426 6,863 8,200 5,408 7,500 8,000 -2.44%Allocated to all PW Departments 602-495-9450-42150 Operating Suppies 471 921 959 1,500 231 1,000 1,250 -16.67% 602-495-9450-42270 Repair/Maint. Supplies 280 - 7,612 - - - - #DIV/0! 602-495-9450-44375 Personal Protective Equipment 1,157 716 466 350 - 350 450 28.57% 602-495-9450-42400 Small Tools & Minor Equipment 5,110 102 2,480 2,500 1,655 2,500 2,500 0.00% Total Materials and Supplies 8,610$ 11,765$ 19,874$ 17,250$ 7,891$ 14,788$ 23,250$ 34.78% Charges and Services 602-495-9450-43030 Engineering Services 4,605 6,768 6,950 15,000 1,274 12,500 12,500 -16.67% 602-495-9450-43010 Audit Services - 9,246 9,105 8,227 8,608 8,227 8,706 5.82% split GF, Water, Sewer, SW 602-495-9450-43090 Newsletter - - 1,122 1,100 571 1,199 1,300 18.18%printing only (split with Comunnications and Water) 602-495-9450-43150 Contract Services 89,754 22,289 36,059 50,000 21,293 40,000 50,000 0.00% 602-495-9450-43185 IT Support 31,306 4,406 5,170 4,684 3,732 4,684 4,558 -2.68%Allcoation for 2022 has changed!!! Includes all the Rosville bill ( IT Support, Software, and Telephone) 602-495-9450-42002 IT Hardware - 505 821 650 - 650 1,350 107.69%New scada monitor (1/2 sewer) and two new computers (split streets/water/sewer) 602-495-9450-43190 Software Programs - 8,459 9,925 9,305 4,942 9,305 12,670 36.16%Banyon, Accela-Springbrook support, Springbrook subscription, Beehive, Sensus, Misc 602-495-9450-43210 Telephone 1,726 2,504 2,436 2,500 1,748 2,500 3,100 24.00%TDS, T-Mobile. New phone new staff602-495-9450-43220 Postage 3,500 2,569 2,251 3,500 1,076 2,600 3,392 -3.09% 602-495-9450-43310 Mileage - 90 - 100 - 100 100 0.00% 602-495-9450-43610 Insurance 3,187 3,466 4,212 4,633 4,234 4,633 6,000 29.51% 602-495-9450-43810 Electric Utility 11,782 14,813 14,889 15,500 12,947 15,500 16,500 6.45%New lift Station 602-495-9450-43820 Sewer Utility - Met Council 98,575 169,359 229,887 265,011 220,843 265,011 421,861 59.19%Per Met Council 602-495-9450-44010 Repairs/Maint Imp Bldgs - 1,471 - 1,000 893 1,000 1,000 0.00%split building expenses between all depts 602-495-9450-44040 Repairs/Maint. Equip.3,838 12,301 3,689 4,500 651 4,500 4,500 0.00% 602-495-9450-44150 Equipment Rental - 7 6,500 8,000 - 8,000 8,000 0.00%rent vac truck for 2 weeks 602-495-9450-44170 Uniforms - 448 487 600 411 600 600 0.00%Allocated from Streets 602-495-9450-44030 Repairs\Maint Imp Not Bldgs 1,683 16,942 7,804 4,000 3,670 4,500 4,500 12.50% 602-495-9450-44370 Conferences & Training 1,163 3,447 1,826 3,500 964 2,500 2,700 -22.86% 602-495-9450-44377 Credit Card Fees 25 4,787 9,017 7,262 7,373 9,523 9,809 35.07%PSN CC Fees Total Charges and Services 251,119$ 283,878$ 352,150$ 409,072$ 295,229$ 397,533$ 573,146$ 40.11% Capital Outlay 602-495-9450-45300 Improvements Other Than Bldgs 34,668 - - 275,760 - - 22,438 -91.86%Sewer Oversizing and Sewer to 180 Acres Total Capital Outlay 34,668$ -$ -$ 275,760$ -$ -$ 22,438$ -91.86% Miscellaneous and Non-operating 602-495-9450-44300 Miscellaneous Expenses 300 20 790 1,000 - 500 500 -50.00% 602-495-9450-46010 Bond Principal - - - 470,000 465,000 470,000 475,000 1.06% 602-495-9450-46110 Bond Interest 203,380 179,590 165,205 169,822 172,279 169,822 161,519 -4.89% 602-495-9450-46300 Bond Issuance Costs - (11,469) - - - - - #DIV/0! 602-495-9450-46200 Fiscal Agent Fees - - - - 165 - - #DIV/0! Total Misc. and Non-operating 203,680$ 168,140$ 165,996$ 640,822$ 637,444$ 640,322$ 637,019$ -0.59% Prior Period Adjustment 136,324$ Total Sewer Fund Expenses:691,829$ 550,327$ 659,225$ 1,480,484$ 1,043,802$ 1,177,181$ 1,452,386$ -1.90% Total Sewer Fund Revs. Over/(Under) Expenses:1,103,346$ 1,081,779$ 1,838,211$ 943,776$ 1,395,254$ 1,281,963$ 231,460$ -75.48% 603 Storm Water Fund Storm Water Fund Revenues: 603-000-0000-36100 Special Assessments 37,537 - 25,578 - 16,416 - - #DIV/0! 603-000-0000-36101 Delinquent Special Assessments 837 - - - - - - #DIV/0! 603-000-0000-36102 Special Assessment Penalties/Interest 497 241 - - - - - #DIV/0! 603-000-0000-36210 Interest on Investment 23,831 37,479 15,344 4,574 (5,364) 8,925 4,463 -2.44%50% of CY. Rates have gone down603-000-0000-37160 Penalties - - 8,350 - (225) - - #DIV/0! 603-000-0000-37300 Surface Water Utility Sales 199,691 344,211 314,959 385,155 9,451 385,155 464,080 20.49%Estimate from pro forma 603-000-0000-34113 SW Review Fee Revenue 36,925 35,545 46,380 35,000 38,823 38,000 39,375 12.50% Total Storm Water Fund Revenues:299,318$ 417,475$ 410,611$ 424,729$ 59,100$ 432,080$ 507,918$ 19.59% Storm Water Fund Expenses: Personnel 603-496-9500-41010 Full-time Salaries 30,103 35,071 46,070 43,133 42,065 43,133 81,316 88.52%Reallocated based upon 2020 YTD actual re: time allocation. New Assistant Director and UB full Time 603-496-9500-41020 Overtime - - 169 1,000 427 853 1,000 0.00%Spring culvert drainage 603-496-9500-41040 Temporary Employees - - - - - - - #DIV/0! 603-496-9500-41210 PERA Contributions (10,147) 3,361 2,856 3,966 3,157 3,299 6,174 55.66% 603-496-9500-41216 MSRS Contributions -City Admin - - - 154 95 154 158 2.84% 603-496-9500-41220 FICA Contributions 1,767 2,057 2,305 3,278 2,482 2,727 5,104 55.69% 603-496-9500-41230 Medicare Contributions 346 480 545 767 581 638 1,194 55.62% 603-496-9500-41300 Insurance 4,885 4,163 5,750 8,599 9,119 8,599 18,616 116.49% 603-496-9500-41325 Life Insurance 44 102 21 36 27 36 55 53.08% 603-496-9500-41330 STD/LTD 87 86 197 230 195 230 477 107.28% 603-496-9500-41600 Safety Clothing Allowance - - - 125 125 125 125 0.00%Boots ($200 per person allocated by Salary Allocation) 603-496-9500-41420 Unemployment Insurance 555 - - - - - - #DIV/0! 603-496-9500-41510 Workers' Compensation 1,626 1,685 2,029 2,232 1,060 2,232 2,455 10.00% Total Personnel 29,265$ 47,007$ 64,557$ 72,265$ 59,331$ 62,026$ 116,673$ 61.45% Materials and Supplies 603-496-9500-42000 Office Supplies 224 387 129 450 54 350 350 -22.22%603-496-9500-42120 Fuel, Oil and Fluids - 2,731 3,460 3,500 1,081 3,500 3,750 7.14%Allocated to all PW Departments 603-496-9500-42030 Printed Forms 167 177 513 600 294 600 500 -16.67%more postcard stock as parcel # inc 603-496-9500-42270 Repair/Maint. Maint Supplies 2,338 1,597 34 2,250 836 2,250 2,500 11.11% 603-496-9500-42150 Operating Supplies 70 588 68 1,000 - 750 750 -25.00% 603-496-9500-44375 Personal Protective Equipment 866 579 508 500 - 300 500 0.00% 603-496-9500-42400 Small Tools & Minor Equipment 2,478 163 3,004 2,500 250 2,500 2,500 0.00% Total Materials and Supplies 6,144$ 6,220$ 7,715$ 10,800$ 2,515$ 10,250$ 10,850$ 0.46% Charges and Services 603-496-9500-43030 Engineering Services 2,563 17,685 5,954 10,000 9,998 11,000 12,000 20.00% 603-496-9500-43010 Audit Services - 9,246 9,105 8,227 8,608 8,227 8,706 5.82% split GF, Water, Sewer, SW 603-496-9500-43040 Legal Services - 403 - - - - - #DIV/0! 603-496-9500-43150 Contract Services 10,259 5,458 12,639 6,500 5,188 6,500 6,700 3.08% 603-496-9500-43185 IT Support 9,825 4,021 5,047 4,620 3,409 4,620 2,163 -53.19%Roseville 603-496-9500-42002 IT Hardware - 505 430 600 - 600 600 0.00%Computer 603-496-9500-43190 Software Programs - 7,484 9,728 8,232 3,967 8,000 11,955 45.22%Banyon, Accela-Springbrook support, Springbrook subscription, Beehive, Misc 603-496-9500-43210 Telephone 65 1,063 947 1,100 676 1,100 1,100 0.00% 603-496-9500-44377 Credit Card Fees - - - 500 - 500 500 0.00% 603-496-9500-43220 Postage 1,000 1,267 1,249 1,650 1,437 1,650 1,750 6.06% 603-496-9500-43510 Legal Publishing - 58 - 60 - 60 75 25.00% 603-496-9500-43610 Insurance 5,001 5,439 6,615 7,277 6,647 7,277 8,005 10.00% 603-496-9500-44010 Street Sweeping 29,859 19,989 19,866 28,000 14,040 22,000 25,000 -10.71% 603-496-9500-44040 Repairs/Maint Equip 99 3,082 - 2,500 616 1,500 2,500 0.00% 603-496-9500-44015 Repairs/Maint Bldg - 47 - 100 - 100 100 0.00% 603-496-9500-44030 Repairs/Maint Not Bldg 32,790 250 16,787 25,000 - 20,000 25,000 0.00%603-496-9500-44150 Equipment Rental 1,080 237 500 1,000 - 750 1,000 0.00%Vac truck/sumps 603-496-9500-44170 Uniforms - 201 196 250 126 250 250 0.00%Allocated from Streets 603-496-9500-44370 Conferences & Training 1,285 787 675 2,000 854 1,250 1,425 -28.75% Total Charges and Services 93,824$ 77,230$ 89,736$ 107,616$ 55,566$ 95,384$ 108,828$ 1.13% Capital Outlay 603-496-9500-45300 Improvements Other Than Bldgs - - - - 24,185 - - #DIV/0! Total Capital Outlay -$ -$ -$ -$ 24,185$ -$ -$ #DIV/0! Miscellaneous and Non-operating 603-496-9500-44300 Miscellaneous Expenses 666 866 83 5,000 780 5,000 5,000 0.00%New MPCA MS4 fee 603-496-9500-46010 Bond Principal - - - 200,000 200,000 200,000 205,000 2.50% 603-496-9500-46110 Bond Interest 68,916 53,733 54,015 54,771 79,932 54,771 52,713 -3.76% 603-496-9500-46200 Fiscal Agent Fees - - - - - - - #DIV/0! 603-496-9500-46300 Bond Issuance Costs - (5,737) - - - - - #DIV/0! Total Misc. and Non-operating 69,582$ 48,861$ 54,098$ 259,771$ 280,712$ 259,771$ 262,713$ 1.13% Prior Period Adjustment (74,348)$ Total Storm Water Fund Expenses:124,467$ 179,319$ 216,107$ 450,452$ 422,310$ 427,431$ 499,064$ 10.79% Total Storm Water Fund Revs. Over/(Under) Expenses:174,851$ 238,157$ 194,505$ (25,723)$ (363,209)$ 4,649$ 8,854$ -134.42% 404 Park Dedication Park Dedication Fund Revenues: 404-000-0000-36210 Interest on Investments 9,173 19,943 24,505 - - - - #DIV/0! 404-000-0000-36230 Donations - - - - - - - #DIV/0! 404-410-1910-36235 Park Dedication 502,802 123,500 714,558 132,280 1,845,371 1,845,371 215,825 63.16%Bruggerman OP-PUD and Launch Properties. 1 mill from Royall Golf in 2021 Total Park Dedication Fund Revenues:511,975$ 143,443$ 739,063$ 132,280$ 1,845,371$ 1,845,371$ 215,825$ 63.16% Park Dedication Fund Expenses: Capital Outlay 404-480-8000-43030 Engineering Services 174 - - - - - - #DIV/0! 404-480-8000-43040 Legal Services - - - - - - - #DIV/0! 404-480-8000-43050 Other Park Ded Prof Services 96,753 - - - - - - #DIV/0! 404-480-8000-43510 Legal Publishing - - - - - - - #DIV/0! 404-480-8000-44010 Repairs/Maint Contractual Bldg - - - - - - - #DIV/0! 404-480-8000-44030 Repairs/Maint Imp Not Bldgs 23,488 - - - - - - #DIV/0! 404-480-8000-44040 Repairs/Maint Contractual Eqpt - - - - - - - #DIV/0! 404-480-8000-45200 Buildings and Structures 94,474 6,762 - - - - - #DIV/0!404-480-8000-45300 Improv Other than Bldgs - 401 111,562 200,000 13,732 200,000 331,430 65.72%trail connections in 2022 404-480-8000-45805 Other Project Costs 4,485 222,478 166,569 - 4,054 - - #DIV/0! Total Capital Outlay 219,375$ 229,641$ 278,132$ 200,000$ 17,786$ 200,000$ 331,430$ 65.72% Miscellaneous and Non-operating 404-480-8000-44300 Miscellaneous 2,854 - - - - - - #DIV/0! Total Misc. and Non-operating 2,854$ -$ -$ -$ -$ -$ -$ #DIV/0! Total Park Dedication Fund Expenses:222,229$ 229,641$ 278,132$ 200,000$ 17,786$ 200,000$ 331,430$ 65.72% Total Park Dedication Fund Revs. Over/(Under) Expenses:289,745$ (86,198)$ 460,932$ (67,720)$ 1,827,584$ 1,645,371$ (115,605)$ 70.71% Park Dedication Fund Balance Year Revenues Expense Fund Balance 2020 1,193,853.00 Funnd Balance Jan 1 2021 1,845,370.58 200,000.00 2,839,223.58 Fund Balance Dec 31 2022 215,825.00 331,430.00 2,723,618.58 410 Vehicle Replacement Vehicle Replacement Fund Revenues: 410-000-0000-36210 Interest on Investments 7,139 33,975 33,576 - - - - #DIV/0!Will be recorded at year end 410-000-0000-39101 Sale of Capital Assets 8,991 44,927 13,806 - - - - #DIV/0! 410-000-0000-39210 Transfer from General Fund 29,667 645,076 1,003,847 260,746 - 260,746 150,000 -42.47%Transfer at end of year 410-000-0000-39310 Bond Proceeds 940,000 698,984 - - - - - #DIV/0! 410-420-2220-36230 Donations 12,000 - - - - - - #DIV/0! Total Vehicle Replacement Fund Revenues:997,797$ 1,422,963$ 1,051,228$ 260,746$ -$ 260,746$ 150,000$ -42.47% Vehicle Replacement Fund Expenses: Capital Outlay 410-420-2220-45500 Public Safety Vehicles 7,837 722,238 297,090 710,000 259,641 710,000 - -100.00%brush rig, engine repalcements 410-420-2400-45500 Building Vehicles - 6,111 - 30,000 - 30,000 - -100.00%inspector vehicle 410-430-8000-45500 Public Works Vehicles 121,236 316,886 299,319 70,000 109,884 70,000 409,000 484.29%Parks and PW/parks dump truck Total Capital Outlay 129,073$ 1,045,235$ 596,408$ 810,000$ 369,525$ 810,000$ 409,000$ -49.51% Miscellaneous and Non-operating 410-000-0000-46300 Fiscal Agent Fees 4,500 - - - - - - #DIV/0! 410-480-8000-46300 Bond Issuance Costs - 12,328 - - - - - #DIV/0! Total Misc. and Non-operating 4,500$ 12,328$ -$ -$ -$ -$ -$ #DIV/0! Total Vehicle Replacement Expenses:133,573$ 1,057,563$ 596,408$ 810,000$ 369,525$ 810,000$ 409,000$ -49.51% Total Vehicle Replacement Fund Revs. Over/(Under) Expenses:864,224$ 365,399$ 454,820$ (549,254)$ (369,525)$ (549,254)$ (259,000)$ -52.85% Vehicle Replacement Fund Balance Year Revenues Expense Fund Balance 2020 1,716,283.00 Funnd Balance Jan 1 2021 260,746.00 1,067,326.00 909,703.00 Fund Balance Dec 31 2022 150,000.00 409,000.00 650,703.00