Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2020 Budget Master
CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 1 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments General Fund Revenues: (0.00) Surplus/(Deficit) in Rev over Expenditures Taxes 101-410-1320-31010 Current Ad Valorem Taxes 1,643,358$ 2,216,047$ 2,963,905$ 1,456,329$ 2,963,905$ 3,537,317$ 19.35% 101-410-1320-31020 Delinquent Ad Valorem Taxes 18,313 15,785 15,000 13,543 15,000 15,000 0.00% 101-410-1320-31030 Mobile Home Tax 17,547 16,079 15,000 3,584 15,000 15,000 0.00% 101-410-1320-31030 Delinquent Mobile Home Tax #DIV/0! 101-410-1320-31040 Fiscal Disparities 159,325 148,090 199,221 121,319 199,221 249,327 25.15% 101-410-1320-31045 Delinquent Fiscal Disparities #DIV/0! 101-410-1320-31050 Tax Abatement #DIV/0! 101-410-1320-31520 30% Rental - County 2,551 2,551 #DIV/0! 101-410-1320-31910 Penalty & Interest on Taxes 2,400 719 500 1,076 1,076 500 0.00% 101-410-1320-31920 Forfeited Tax Sale Apportionment 269 - - - - - #DIV/0! Total Taxes 1,841,212$ 2,396,720$ 3,193,626$ 1,598,403$ 3,196,753$ 3,817,144$ 19.52% Licenses and Permits 101-410-1320-32110 Liquor License 8,300 17,000 8,300 6,150 8,300 8,300 0.00% 101-410-1320-32180 Wastehauler License 1,000 600 625 -37.50% 101-410-1320-32181 General Contractor License 50 - 300 150 150 #DIV/0! 101-410-1320-32183 Heating Contractor License 900 - #DIV/0! 101-410-1320-32184 Blacktopping Contractor License 300 #DIV/0! 101-420-2400-32210 Building Permits 1,146,350 1,044,126 800,000 648,662 800,000 800,000 0.00% 101-430-3100-32211 Driveway Permits 19,390 17,570 15,000 11,345 11,500 10,000 -33.33% 101-420-2400-32212 Fireplace Permits 5,580 16,000 12,840 16,000 16,000 0.00% 101-420-2400-32220 Heating Permits 135,814 79,657 60,000 63,172 64,000 60,000 0.00% 101-420-2400-32230 Plumbing Permits 107,948 82,254 60,000 78,673 79,000 60,000 0.00% 101-420-2400-32232 Pool Permits 150 1,000 1,050 1,050 1,000 0.00% 101-420-2400-32213 Siding Permits 12,500 4,159 12,500 12,500 0.00% 101-420-2400-32214 Roof Permits 50,000 11,865 25,000 50,000 0.00% 101-410-1320-32240 Animal License 1,875 1,325 - #DIV/0!Discontinued in 2019 101-430-3100-32250 Utility Permits 43,393 61,620 27,000 31,247 31,500 27,000 0.00% 101-420-2220-32260 Burning Permit 1,575 2,050 2,000 1,370 2,000 1,700 -15.00% 101-410-1320-32270 Massage Therapy Licenses 100 300 100 275 100 100 0.00% 101-420-2400-32275 Fire Suppression Permits 700 2,500 6,980 7,000 2,500 0.00% 101-420-2400-32278 Fire Permit Plan Check Fee 12,273 1,151 1,500 1,300 1,500 1,500 0.00%Fire Alarm Systems 101-410-1320-32281 Golf Cart Operation Permit 30 30 #DIV/0! 101-410-1320-32282 Miscellaneous Permits 25 100 100 #DIV/0! 101-410-1910-32282 Miscellaneous Permits 355 355 #DIV/0! 101-420-2400-32282 Miscellaneous Permits - 3,790 - 3 3 - #DIV/0! Total Licenses and Permits 1,477,918$ 1,317,647$ 1,056,900$ 880,475$ 1,060,088$ 1,051,375$ -0.52% Intergovernmental 101-430-3100-33418 MSA - Maintenance 122,883 144,502 151,727 153,963 153,963 158,582 4.52%From City Engrineer used 3% over 2019 amount 101-410-1320-33402 Market Value Credit-Ag 3,968 2,015 2,015 #DIV/0! 101-410-1320-33403 Ag Reserve Credit 151 #DIV/0! 101-420-2220-33420 State Fire Aid 61,147 64,533 60,000 68,975 68,975 64,000 6.67%Sept - Nov receipt for Relief Association 101-410-1320-33422 PERA Aid 2,749 2,749 2,749 1,375 2,749 - -100.00%Ends in 2019 101-410-1930-33426 Miscellaneous State Grants #DIV/0! 101-430-3100-33630 Miscellaneous State Grants 5,000 #DIV/0!S Washing Cty Watershed grant agreement 101-420-2220-33426 Miscellaneous State Grants 7,128 6,323 6,323 #DIV/0! 101-450-5200-33426 Miscellaneous State Grants 19,406 5,664 4,820 840 840 4,820 0.00%DNR/Sunfish Lake Trail Grooming 101-410-1320-33623 Payment in Lieu of Taxes 31,500 32,773 32,773 33,428 2.00%ISD 916 Service Fee Due in Dec. - 2% incr./yr. End in 2026 101-430-3100-33630 Grant Revnue 4,327 4,327 #DIV/0! 101-420-2220-33525 Other County Grants and Aids 4,190 2,889 2,889 #DIV/0! 101-410-1320-33521 Recycling Grant - - 15,766 16,534 16,534 16,000 1.48% CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 2 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments Total Intergovernmental 206,185$ 264,384$ 267,835$ 257,240$ 291,388$ 281,830$ 5.23% Charges for Services 101-410-1910-34103 Zoning & Subdivision Fees 54,956 93,710 45,000 70,125 70,125 45,000 0.00% 101-420-2400-34104 Plan Check Fees 580,817 566,532 525,000 380,634 525,000 525,000 0.00% 101-410-1320-34105 Sale of Copies, Books, Maps 27 40 200 50 50 -75.00% 101-410-1520-34107 Assessment Searches 1,140 1,170 1,400 690 1,400 1,400 0.00% 101-420-2400-34207 Building Code Surcharges 12 #DIV/0!Pass Thru - not budgeted 101-450-5200-34710 Rent 12 12 12 12 #DIV/0! 101-410-1450-34111 Cable Operation Reimbursement 2,104 5,000 5,000 1,015 5,000 5,000 0.00%Offset with Cable Operators charge in Communications 101-420-2400-34112 Planning & Zoning Review Fee 69,524 29,300 25,000 21,900 25,000 25,000 0.00%$100 every new review charged 101-430-3100-34114 Street Light Fee 4,902 1,161 1,500 1,500 #DIV/0!Developer Agreements 101-410-1910-34115 Base Map Upgrading Fee 8,200 3,050 3,000 3,000 #DIV/0!$25/lot created 101-420-2400-34203 Day Care Inspections 50 101-410-1910-36206 Escrow Administration Fee 30,000 27,300 25,000 122,800 122,800 25,000 0.00%$100 every new escrow is charged Total Charges for Services 738,592$ 736,216$ 626,600$ 601,387$ 753,887$ 630,950$ 0.69% Fines and Forfeits 101-420-2100-35100 Fines 41,418 48,253 49,000 28,216 49,000 50,000 2.04%Based on averages 101-420-2100-35130 Forfeitures 950 Total Fines and Forfeits 41,418$ 49,202$ 49,000$ 28,216$ 49,000$ 50,000$ 2.04% Investment Earnings 101-410-1320-36210 Interest Earnings 27,665 78,634 40,000 - 80,000 80,000 100.00%Projected same as 2019 projected as market is falling Total Investment Earnings 27,665$ 78,634$ 40,000$ -$ 80,000$ 80,000$ 100.00% Miscellaneous 101-410-1320-31811 Cable Franchise Revenue 67,178 81,581 85,000 103,692 103,000 100,000 17.65% 101-410-1320-36100 Special Assesments 21,116 #DIV/0! 101-410-1320-36200 Miscellaneous Revenue 78,241 1,806 29,900 11,388 13,000 3,000 -89.97% misc. accts. Receivable, LMCIT dividend, misc. one-tiome revenues 101-420-2220-36200 Miscellaneous Revenue 4,543 4,543 #DIV/0!LMC Ins Claim on Sewer Backup FD Station #2 101-430-3100-36200 Miscellaneous Revenue 795 795 #DIV/0!Public Surplus Auction Rev 101-410-1910-36200 Miscellaneous Revenue 28,000 #DIV/0!AUAR 101-420-2400-36202 Central MN Jobs Grant 1,553 1,553 #DIV/0! 101-410-1320-36207 MCMA Grant 3,500 #DIV/0!Intern for Admin 101-410-1910-36236 Conservation Easement Fee 20,000 - #DIV/0! 101-420-2220-36204 Reimbursements - Fire 9,940 20 - 4,543 4,920 #DIV/0!Training reimbursement from MBFTE 101-420-2220-36230 Donations-Fire 1,500 1,500 AED Donation 101-410-1320-36230 Donations 17,837 14,036 10,000 15,000 15,000 10,000 0.00% 101-410-1320-34120 Tower Rent 47,084 53,531 108,148 117,289 117,289 110,311 2.00%Based on contracts. Total Miscellaneous 220,280$ 192,091$ 233,048$ 255,760$ 261,223$ 259,731$ 11.45% Prior Period Adjustments 32,332 Total General Fund Revenues:4,553,270$ 5,067,227$ 5,467,009$ 3,621,481$ 5,692,339$ 6,171,030$ 12.88% General Fund Expenditures: 1110 Mayor & Council Personnel 101-410-1110-41030 Part-time Salaries 25,690 25,690 25,690 12,845 25,690 25,690 0.00% 101-410-1110-41220 FICA Contributions 1,593 1,593 1,593 796 1,593 1,593 0.00% 101-410-1110-41230 Medicare Contributions 373 373 373 186 373 373 0.00% 101-410-1110-41510 Workers Compensation 67 237 237 57 119 130 -45.15%2019 Prem $119, Refund from 2018 $62 Total Personnel 27,723$ 27,892$ 27,893$ 13,885$ 27,775$ 27,786$ -0.38% Materials and Supplies CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 3 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments 101-410-1110-42000 Office Supplies 114 125 78 125 125 0.00%business cards, name tags, etc 101-410-1110-42001 Computer Reimbursement 1,911 1,000 2,000 1,000 1,000 - -100.00% 101-410-1110-43310 Mileage - 300 300 300 0.00% 101-410-1110-43185 IT Support 1,101 1,040 1,101 1,211 9.99%Council Email Support (Roseville) 101-410-1110-42002 IT Hardware #DIV/0! 101-410-1110-43190 Software Programs - - - - - - #DIV/0! Total Materials and Supplies 2,025$ 1,000$ 3,526$ 2,118$ 2,526$ 1,636$ -53.60% Charges and Services 101-410-1110-44300 Miscellaneous 6,568 5,414 7,000 6,904 7,000 7,140 2.00%YSB, misc 101-410-1110-44330 Dues & Subscriptions 16,045 12,850 12,800 14,019 14,019 15,000 17.19%LMC, MC, MA 101-410-1110-44370 Conferences & Training 180 - 1,000 480 500 1,000 0.00% Total Charges and Services 22,793$ 18,264$ 20,800$ 21,403$ 21,519$ 23,140$ 11.25% 1110 Total Mayor & Council 52,540$ 47,156$ 52,219$ 37,406$ 51,820$ 52,562$ 0.66% 1320 Administration Personnel 101-410-1320-41010 Full-time Salaries 240,650 214,777 222,374 216,598 222,374 169,642 -23.71% Allocation Change (Deputy Clerk and City Clerk) and allocation to Building Inspection Dept 101-410-1320-41030 Part-time Salaries #DIV/0! 101-410-1320-41020 Overtime #DIV/0! 101-410-1320-41040 Temporary Employees 17,733 7,000 #DIV/0!Intern - offset with Grant from MCMA 101-410-1320-41210 PERA Contributions 18,049 16,114 16,678 16,088 16,678 14,324 -14.11%Allocation Change (Deputy Clerk and City Clerk) and allocation to Building Inspection Dept 101-410-1320-41216 MSRS Contributions -City Admin 1,601 #DIV/0!City Administrator Deferred Comp per contract 101-410-1320-41220 FICA Contributions 18,694 15,458 17,012 15,338 20,923 12,978 -23.71% Allocation Change (Deputy Clerk and City Clerk) and allocation to Building Inspection Dept 101-410-1320-41230 Medicare Contributions #DIV/0! 101-410-1320-41300 Insurance 39,840 48,241 39,114 31,097 344 29,723 -24.01% Allocation Change (Deputy Clerk and City Clerk) and allocation to Building Inspection Dept 101-410-1320-41325 Life Insurance 381 344 152 1,198 354 3.00% 101-410-1320-41330 STD/LTD 1,654 1,198 1,085 1,234 3.00% 101-410-1320-41420 Unemployment Benefits 461 #DIV/0! 101-410-1320-41510 Workers Compensation 818 2,005 2,005 758 758 1,846 -7.93%2019 Prem $2149, Refund from 2018 $1391 Total Personnel 335,784$ 299,091$ 298,725$ 281,118$ 262,275$ 238,702$ -20.09% Materials and Supplies 101-410-1320-42000 Office Supplies 4,683 3,211 4,250 2,406 4,250 4,250 0.00% 101-410-1320-42030 Printed Forms 84 100 100 100 0.00% 101-410-1320-43090 Newsletter/Website 2,091 - - - - - #DIV/0!Move all to Communications in 2019 Total Materials and Supplies 6,858$ 3,211$ 4,350$ 2,406$ 4,350$ 4,350$ 0.00% Charges and Services 101-410-1320-43100 Assessing Services 51,646 7,983 81,500 85,831 81,762 88,750 8.90%Wash Co bills June for previous year 101-410-1320-43040 Legal Services 140,883 136,215 90,000 60,960 90,000 87,500 -2.78% 101-410-1320-43150 Contract Services 15,921 3,109 3,100 2,018 3,100 3,193 3.00%Shred it, misc 101-410-1320-43180 Information Technology/Web 909 3,831 #DIV/0! 101-410-1320-43185 IT Support 6,682 6,363 6,682 6,682 0.01%Roseville 101-410-1320-42002 IT Hardware 1,500 34 1,500 1,500 0.00%One computer (laptop) 101-410-1320-43190 Software Programs 2,601 2,011 1,309 2,732 1,309 2,309 76.39% laser fiche, adobe, etc (Roseville), 1 additional license $1000 101-410-1320-43210 Telephone 1,585 1,852 2,511 1,915 2,511 2,586 2.99%Roseville, Sprint 101-410-1320-43220 Postage (87) 1,157 3,000 1,283 2,000 2,000 -33.33% 101-410-1320-43310 Mileage 832 772 1,100 332 1,100 1,100 0.00% 101-410-1320-43510 Legal Publishing 2,655 1,608 10,000 4,662 2,000 10,200 2.00%Recodification 101-410-1320-43610 Insurance 27,130 25,565 35,649 32,212 32,212 39,214 10.00% CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 4 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments 101-410-1320-43152 Cable Operation Expense #DIV/0! 101-410-1320-44330 Dues & Subscriptions 1,227 1,919 2,000 1,746 2,045 2,060 3.00% 101-410-1320-44370 Conferences & Training 1,453 2,637 3,000 1,108 1,500 5,000 66.67%City Administrator ICMA conference added 101-410-1320-44371 Allocation to Building Inspections - - - - - (2,715) #REF!Allocation of overhead charges to Bulding Dept Total Charges and Services 246,755$ 188,658$ 241,351$ 201,197$ 227,721$ 249,379$ 3.33% Miscellaneous #DIV/0! 101-410-1320-44300 Miscellaneous 534 1,156 1,791 1,210 1,500 1,500 -16.23% Total Miscellaneous 534$ 1,156$ 1,791$ 1,210$ 1,500$ 1,500$ -16.23% 1320 Total Administration 589,931$ 492,116$ 546,217$ 485,931$ 495,846$ 493,931$ -9.57% 1410 Elections Personnel 101-410-1410-41030 Part-time Salaries 6,397 - 795 795 7,250 #DIV/0! 101-410-1410-41510 Workers Compensation - - - - - - #DIV/0! Total Personnel -$ 6,397$ -$ 795$ 795$ 7,250$ #DIV/0! Charges and Services 101-410-1410-43310 Travel Expense 44 25 25 50 101-410-1410-43510 Legal Notices Publishing 20 101-410-1410-43150 Contract Services 1,660 1,660 1,660 1,660 1,660 2,000 20.48%Wash. Cty. charges for elections Total Charges and Services 1,660$ 1,724$ 1,660$ 1,685$ 1,685$ 2,050$ 23.49% Capital Outlay 101-480-8000-45800 Other Equipment - - - - - #DIV/0! Total Capital Outlay -$ -$ -$ -$ -$ -$ #DIV/0! Miscellaneous 101-410-1410-44300 Miscellaneous - 630 - 159 159 700 #DIV/0! Total Miscellaneous -$ 630$ -$ 159$ 159$ 700$ #DIV/0! 1410 Total Elections 1,660$ 8,751$ 1,660$ 2,639$ 2,639$ 10,000$ 502.41% 1450 Communications Personnel 101-410-1450-41010 Full-time Salaries 7,759 29,159 30,800 22,429 30,800 25,775 -16.31% 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 582 2,187 2,310 1,654 2,310 1,933 -16.32% 101-410-1450-41220 FICA Contributions 589 2,211 2,356 1,641 2,708 1,972 -16.30% 101-410-1450-41230 Medicare Contributions #DIV/0! 101-410-1450-41300 Insurance 933 5,101 7,243 4,513 7,243 6,287 -13.20% 101-410-1450-41325 Life Insurance 60 63 19 63 65 3.00% 101-410-1450-41330 STD/LTD 146 157 105 157 162 3.00% #DIV/0! 101-410-1450-41510 Workers Compensation - 262 262 116 116 306 16.87%2019 Prem $298, Refund from 2018 $182 Total Personnel 9,863$ 39,125$ 43,191$ 30,476$ 43,397$ 36,500$ -15.49% Charges and Services 101-410-1450-43090 Newsletter 2,870 3,000 1,552 3,000 1,100 -63.33%printing only (Split with Water and Sewer) 101-410-1450-43180 Information Technology/Web 58,147 40,061 1,800 2,018 2,422 2,000 11.11%Website,Constant Contact, Not Form 101-410-1450-43185 IT Support 535 505 535 535 0.00%Roseville CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 5 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments 101-410-1450-42002 IT Hardware #DIV/0! 101-410-1450-43190 Software Programs 2,550 #DIV/0! 101-410-1450-43210 Telephone #DIV/0! 101-410-1450-43220 Postage 1,330 1,450 1,461 1,461 1,500 3.45%newsletter postage 101-410-1450-43310 Mileage #DIV/0! 101-410-1450-43510 Public Notices #DIV/0! 101-410-1450-43152 Cable Operations 6,035 5,050 5,000 4,070 5,000 5,000 0.00% 101-410-1450-44370 Conferences and Training 1,314 - - - - 500 #DIV/0! Total Charges and Services 65,496$ 51,860$ 11,785$ 9,606$ 12,418$ 10,635$ -9.76% 1450 Total Communications 75,359$ 90,986$ 54,976$ 40,082$ 55,815$ 47,135$ -14.26% 1520 Finance Personnel 101-410-1520-41010 Full-time Salaries 68,372 69,526 97,334 80,158 97,334 71,821 -26.21%Allocation change for Building Dept 101-410-1520-41030 Part-time Salaries #DIV/0! 101-410-1520-41020 Overtime #DIV/0! 101-410-1520-41040 Temporary Employees 5,874 5,636 6,760 5,568 6,760 6,963 3.00%Intern 101-410-1520-41210 PERA Contributions 1,833 5,215 7,300 6,012 7,300 5,387 -26.21%Allocation change for Building Dept 101-410-1520-41220 FICA Contributions 5,504 5,425 7,963 6,232 7,963 6,027 -24.31%FT $5494, Intern $533, allocation change for Building Dept 101-410-1520-41230 Medicare Contributions #DIV/0! 101-410-1520-41300 Insurance 7,572 7,586 15,211 6,386 15,211 10,863 -28.58%Allocation change for Building Dept 101-410-1520-41325 Life Insurance 86 125 56 125 129 3.00% 101-410-1520-41330 STD/LTD 89 638 450 638 657 3.00% 101-410-1520-41420 Unemployment Benefits 3,220 5,537 #DIV/0! 101-410-1520-41510 Workers Compensation 440 244 440 869 869 864 96.29%2019 Prem $1006, Refund from 2018 $137 Total Personnel 92,814$ 99,344$ 135,771$ 105,731$ 136,200$ 102,710$ -24.35% Materials and Supplies 101-410-1520-42000 Office Supplies 621 1,299 800 171 800 800 0.00% 101-410-1520-42030 Printed Forms - 1,039 375 1,301 1,301 1,000 166.67%Check and deposit book costs Total Materials and Supplies 621$ 2,338$ 1,175$ 1,472$ 2,101$ 1,800$ 53.19% Charges and Services 101-410-1520-43010 Audit Services 26,575 29,820 7,987 7,913 7,913 7,987 0.01% split GF, Water, Sewer, SW 101-410-1520-43150 Contract Services 187,453 79,620 3,000 3,000 3,060 2.00%Finance Consultant 101-410-1520-43185 IT Support 2,120 3,779 3,569 3,779 3,779 0.01%Roseville 101-410-1520-42002 IT Hardware 718 1,200 505 700 - -100.00% 101-410-1520-43190 Software Programs 6,400 18,973 2,752 3,419 3,419 2,834 3.00% Accela support (slit with W, S, SW $9226)/Banyon/Credit Card Services, Roseville 101-410-1520-43210 Telephone 881 580 585 484 585 595 1.71%Roseville IT Phone 101-410-1520-43310 Mileage - 168 500 50 500 0.00%Mileage for training and conferences. 101-410-1520-44330 Dues & Subscriptions 330 2,071 2,000 1,044 2,100 2,100 5.00% GFOA, MNGFOA, GFOA Program Fees, Select Acct, Ins Prog Fees 101-410-1520-44370 Conferences & Training 34 642 3,000 455 500 3,000 0.00% MNGFOA Confr (2 people) and Govt. Acctg. Courses, OSA Training, Public Finance Training, Monthly MnGFOA Mtgs 101-410-1520-44371 Allocation to Building Inspections - - - - - (1,959) #REF!Allocation charge for Building Dept. Total Charges and Services 221,673$ 134,713$ 24,802$ 17,388$ 22,046$ 21,896$ -11.71% Miscellaneous 101-410-1520-44300 Miscellaneous 46,172 2,141 5,000 1,055 5,000 4,750 -4.99% Bank Fees, Wire Transfer Fees, Excise Tax, Penalties, County charges, Health Partners, Ind Health Svs Network Total Miscellaneous 46,172$ 2,141$ 5,000$ 1,055$ 5,000$ 4,750$ -4.99% CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 6 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments 1520 Total Finance 361,279$ 238,536$ 166,748$ 125,646$ 165,347$ 131,157$ -21.34% 1910 Planning & Zoning Personnel 101-410-1910-41010 Full-time Salaries 168,582 148,529 148,632 136,836 148,632 160,011 7.66%Salary Allocation Permit Technician/Deputy Clerk 101-410-1910-41030 Part-time Salaries 4,626 #DIV/0! 101-410-1910-41020 Overtime #DIV/0! 101-410-1910-41040 Temporary Employees 6,760 4,096 6,760 6,963 3.00%Intern 101-410-1910-41210 PERA Contributions 12,612 10,784 11,147 10,156 11,147 12,001 7.66%FT $12001, Intern $0 101-410-1910-41220 FICA Contributions 12,319 11,628 11,887 10,724 11,887 12,774 7.46%FT $12241, Intern $533 101-410-1910-41230 Medicare Contributions #DIV/0! 101-410-1910-41300 Insurance 30,840 6,684 30,422 8,316 28,000 29,322 -3.62%Salary Allocation Permit Technician/Deputy Clerk 101-410-1910-41325 Life Insurance 294 288 61 28 297 3.00% 101-410-1910-41330 STD/LTD 1,015 805 304 805 829 3.00% 101-410-1910-41510 Workers Compensation 783 1,424 1,424 585 585 1,308 -8.15%2019 Prem $1273, Refund from 2018 $688 Total Personnel 225,136$ 184,984$ 211,365$ 171,077$ 207,844$ 223,505$ 5.74% Materials and Supplies 101-410-1910-42000 Office Supplies 336 752 500 53 53 200 -60.00% 101-410-1910-42030 Printed Forms - - - - - - #DIV/0! Total Materials and Supplies 336$ 752$ 500$ 53$ 53$ 200$ -60.00% Charges and Services 101-410-1910-43020 Comprehensive Planning 44,058 50,885 5,000 7,796 7,796 -100.00% Comp Plan: $5000 in 2019 left over to use for any last minute changes to Comp Plan from adjacent jurisdictional review for SHC and /or Engr 101-410-1910-43030 Engineering Services 6,608 11,170 15,000 15,367 15,500 15,000 0.00% 101-410-1910-43150 Contract Services 5,964 2,249 5,500 7,118 7,500 6,000 9.09%Codification 2020 101-410-1910-43180 Information Technology/Web 406 #DIV/0! 101-410-1910-43185 IT Support 5,505 5,199 5,500 5,600 1.73%Roseville 101-410-1910-42002 IT Hardware 2,000 505 600 -100.00% 101-410-1910-43190 Software Programs 407 623 1,383 973 1,000 1,376 -0.51%Roseville, Comp Plan Software 101-410-1910-43210 Telephone 738 724 678 484 680 600 -11.44%Roseville 101-410-1910-43220 Postage 220 79 100 100 150 50.00% 101-410-1910-43310 Mileage 344 158 350 248 300 350 0.00% 101-410-1910-43510 Legal Publishing 1,410 2,185 1,400 720 1,400 1,500 7.14% 101-410-1910-44330 Dues & Subscriptions 170 800 354 400 650 -18.75%ULI, AICP 101-410-1910-44350 Books - #DIV/0! 101-410-1910-44370 Conferences & Training 405 273 1,500 20 1,000 1,000 -33.33%APA Confr Total Charges and Services 60,559$ 68,515$ 39,215$ 38,784$ 41,776$ 32,226$ -17.82% Miscellaneous 101-410-1910-44300 Miscellaneous 10 76 200 - - 200 0.00% Total Miscellaneous 10$ 76$ 200$ -$ -$ 200$ 0.00% 1910 Total Planning & Zoning 286,042$ 254,327$ 251,280$ 209,914$ 249,673$ 256,131$ 1.93% 1930 Engineering Services Charges and Services 101-410-1930-43030 Engineering Services 44,332 31,770 39,000 25,365 35,000 40,000 2.56% 101-410-1930-43210 Telephone 178 - - - - - #DIV/0! Total Charges and Services 44,510$ 31,770$ 39,000$ 25,365$ 35,000$ 40,000$ 2.56% Capital Outlay 101-480-8000-45900 Construction Projects - - 35,000 49,620 49,620 - -100.00%Keats Ave turn lane 2019 CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 7 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments Total Capital Outlay -$ -$ 35,000$ 49,620$ 49,620$ -$ -100.00% 1930 Total Engineering Services 44,510$ 31,770$ 74,000$ 74,985$ 84,620$ 40,000$ -45.95% 1940 City Hall Materials and Supplies 101-410-1940-42110 Cleaning Supplies 97 100 #DIV/0! 101-410-1940-42230 Building Repair Supplies 550 801 800 124 500 800 0.00% Total Materials and Supplies 550$ 801$ 800$ 124$ 500$ 800$ 0.00% Charges and Services 101-410-1940-43180 Information Technology/Web 185 400 400 400 0.00% 101-410-1940-43185 IT Support 5,462 4,807 5,245 5,090 -6.81%Roseville 101-410-1940-42002 IT Hardware 505 505 #DIV/0! 101-410-1940-43190 Software Programs #DIV/0! 101-410-1940-43210 Telephone 691 870 877 827 865 877 0.03%Roseville 101-410-1940-43810 Utilities 3,840 3,686 4,500 2,989 4,020 4,422 -1.73%xcel, water, sewer 101-410-1940-43840 Refuse 1,561 1,402 1,600 1,329 1,600 1,600 0.00% 101-410-1940-44010 Repairs/Maint Contractual Bldg 9,735 11,353 6,000 3,864 6,000 6,000 0.00%cintas and cleaning 101-410-1940-44040 Repairs/Maint Contractual Eqpt 12,346 14,434 16,000 10,758 15,000 15,000 -6.25%copier leases 101-900-9000-47205 Rentals - Building 31,992 10,664 - - - - #DIV/0! city lease space 2019 and 2020 transfer to Brookfield - Budget here but JE will be a transfer See below 101-410-1940-44371 Allocation to Building Inspections - - - - - (14,493) #REF!Allocation to Building Inspection department Total Charges and Services 60,348$ 42,411$ 34,839$ 25,079$ 33,635$ 18,896$ -45.76% Miscellaneous #DIV/0! 101-410-1940-44300 Miscellaneous 568 1,286 1,800 1,043 1,800 1,800 0.00% Total Miscellaneous 568$ 1,286$ 1,800$ 1,043$ 1,800$ 1,800$ 0.00% 1940 Total City Hall 61,466$ 44,498$ 37,439$ 26,246$ 35,935$ 21,496$ -42.58% 2100 Police Charges and Services 101-420-2100-43150 Law Enforcement Contract 615,054 665,309 701,768 351,518 701,768 773,255 10.19%Additional officer for part of the year 101-420-2100-44301 Misc. - Community Event 1,800 1,800 1,000 - - 1,800 80.00% Total Charges and Services 616,854$ 667,109$ 702,768$ 351,518$ 701,768$ 775,055$ 10.29% 2100 Total Police 616,854$ 667,109$ 702,768$ 351,518$ 701,768$ 775,055$ 10.29% 2150 Prosecution Charges and Services 101-420-2150-43045 Attorney Criminal 42,874 42,164 45,792 38,802 45,792 49,000 7.01%2020 rate is $3995/mth Total Charges and Services 42,874$ 42,164$ 45,792$ 38,802$ 45,792$ 49,000$ 7.01% 2150 Total Prosecution 42,874$ 42,164$ 45,792$ 38,802$ 45,792$ 49,000$ 7.01% 2220 Fire Personnel 101-420-2220-41010 Full-time Salaries 82,258 85,800 90,636 74,624 90,636 88,274 -2.61%Allocation change for Building Dept 101-420-2220-41030 Part-time Salaries 124,580 114,980 172,649 145,188 172,649 178,636 3.47%Witter $26052 plus 152,584 for Part-time Fire Fighters 101-420-2220-41035 Paid On Call Salaries 73,656 71,400 44,682 71,400 73,364 2.75% 101-420-2220-41210 PERA Contributions 20,713 31,340 30,594 33,291 30,594 32,236 5.37% GM/NW $20236 Police/Fire rate incr for 2020, Part-time $12000 CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 8 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments 101-420-2220-41220 FICA Contributions 10,782 14,654 18,669 16,335 18,669 19,308 3.42%GM/NW $1993, other $17,315 101-420-2220-41230 Medicare Contributions #DIV/0! 101-420-2220-41300 Insurance 14,619 16,072 14,487 11,945 14,487 13,834 -4.51%Allocation change for Building Dept 101-420-2220-41325 Life Insurance 120 500 55 500 515 3.00% 101-420-2220-41330 STD/LTD 572 1,715 440 1,715 1,766 3.00% 101-420-2220-41420 Unemployment Benefits 20 2,431 2,431 101-420-2220-41510 Workers Compensation 19,249 31,635 31,635 23,910 23,910 32,505 2.75%2019 Prem $41977, Refund from 2018 $18067 Total Personnel 272,201$ 368,851$ 432,285$ 352,902$ 426,991$ 440,438$ 1.89% Materials and Supplies 101-420-2220-42000 Office Supplies 1,494 1,136 500 1,076 1,076 500 0.00% 101-420-2220-42080 EMS Supplies 4,074 236 3,750 2,143 3,750 2,800 -25.33%Replace Medical and Trauma Bags 101-420-2220-42090 Fire Prevention 2,741 332 3,000 651 3,000 2,000 -33.33% 101-420-2220-42120 Fuel, Oil and Fluids 8,804 13,252 8,000 9,579 10,000 9,400 17.50%Incresed call volume and PT FF's out more. 101-420-2220-42400 Small Tools & Equipment 5,280 27,785 22,675 15,465 17,000 30,175 33.08%3 hires and purchase gear dryer to replace 2 failed units Total Materials and Supplies 22,394$ 42,741$ 37,925$ 28,914$ 34,826$ 44,875$ 18.33% Charges and Services 101-420-2220-43050 Physicals 5,186 8,796 8,198 7,762 8,198 8,296 1.20%3 hires, FIT test cost up. 101-420-2220-43150 Contract Services 1,000 11,115 11,500 18,085 #DIV/0! Actuarial Fees for Relief Association $1000, $17,085 Fire Dept Audit 1/3 cost 2019 and 2/3 of cost in 2020 101-420-2220-43180 Information Technology/Web (440) 880 #DIV/0! 101-420-2220-43185 IT Support 18,130 17,123 18,130 17,130 -5.51%Roseville 101-420-2220-42002 IT Hardware 7,000 2,554 7,000 -100.00% 101-420-2220-43190 Software Programs 341 341 341 341 0.00%Roseville 101-420-2220-43210 Telephone 4,435 3,798 4,063 2,814 4,063 4,000 -1.55%Sprint, TDS, Verizon, Roseville 101-420-2220-43230 Radio 20,676 18,928 25,636 14,389 20,000 25,636 0.00%Replace 2 portables 101-420-2220-43310 Mileage 220 370 500 142 500 500 0.00% 101-420-2220-43630 Insurance 7,571 7,195 8,274 7,825 8,274 9,101 10.00% 101-420-2220-43810 Utility 13,231 12,756 16,000 10,893 16,000 15,000 -6.25% 101-420-2220-43840 Refuse 3,890 586 4,000 557 4,000 1,000 -75.00% 101-420-2220-44010 Repairs/Maint Bldg 11,134 14,543 7,000 9,693 7,000 8,440 20.57%Station #2 tank pumping. 101-420-2220-44040 Repairs/Maint Eqpt 43,613 48,372 30,896 38,157 38,157 33,920 9.79%Even year ladder maint., Increse in inspection costs. 101-420-2220-44170 Uniforms 4,550 8,615 9,821 3,944 4,000 10,321 5.09%3 hires, replace stat. coats and polo's. 101-420-2220-44330 Dues & Subscriptions 3,044 4,935 5,980 3,998 5,980 6,330 5.85% 101-420-2220-44350 Books 180 440 440 440 0.00% 101-420-2220-44370 Conferences & Training 14,110 17,743 22,944 11,164 22,944 20,580 -10.30%Switched from Century to Make the Move. Total Charges and Services 131,401$ 148,518$ 169,222$ 142,470$ 176,527$ 179,120$ 5.85% Capital Outlay 101-480-8000-45500 Vehicle 64 #DIV/0! 101-480-8000-45800 Equipment 2,538 - - #DIV/0! 101-900-9000-47200 Transfer to Vehicle Replacement Fund - - - - - - #DIV/0!Transfer to Vehicle Replacement Fund - See below Total Capital Outlay 2,602$ -$ -$ -$ -$ -$ #DIV/0! Miscellaneous 101-420-2220-44300 Miscellaneous 1,391 1,524 2,000 1,288 2,000 2,000 0.00% Total Miscellaneous 1,391$ 1,524$ 2,000$ 1,288$ 2,000$ 2,000$ 0.00% 2220 Total Fire 429,990$ 561,634$ 641,432$ 525,573$ 640,344$ 666,433$ 3.90% 2220 Fire Relief Charges and Services 101-420-2220-44920 Fire State Aid 61,147 64,533 60,000 68,975 68,975 64,000 6.67%Relief Assoc. pass through CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 9 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments Total Charges and Services 61,147$ 64,533$ 60,000$ 68,975$ 68,975$ 64,000$ 6.67% 2250 Total Fire Relief 61,147$ 64,533$ 60,000$ 68,975$ 68,975$ 64,000$ 6.67% 2400 Building Inspection Personnel 101-420-2400-41010 Full-time Salaries 217,052 210,186 219,756 170,083 219,756 369,167 67.99%1 additional Bldg Insp in 2020, moved costs from Admin & Finance to more accurately reflect costs 101-420-2400-41030 Part-time Salaries 30,690 - -100.00%added Part-time for 2019 Bldg Insp not filled 101-420-2400-41020 Overtime 2,996 3,000 #DIV/0!authorized as postion not filled in 2018 101-420-2400-41040 Temporary Employees #DIV/0! 101-420-2400-41210 PERA Contributions 16,241 15,769 21,085 12,435 21,085 28,960 37.35% MSRS Contributions -City Admin 489 #DIV/0!City Administrator Deferred Comp included here 101-420-2400-41220 FICA Contributions 12,881 15,570 21,507 12,975 21,507 27,654 28.58% 101-420-2400-41230 Medicare Contributions 3,012 #DIV/0! 101-420-2400-41300 Insurance 49,757 31,118 46,357 18,103 25,000 73,872 59.35% Salary Allocation Permit Technician/Deputy Clerk, added additional Bldg Insp 101-420-2400-41325 Life Insurance 297 500 112 500 600 20.00% 101-420-2400-41330 STD/LTD 1,230 1,500 614 1,500 2,000 33.33% 101-420-2400-41510 Workers Compensation 919 2,567 2,567 898 898 3,532 37.59% 2019 Prem $2071, Refund from 2018 $1172, added additional person Total Personnel 299,862$ 276,738$ 343,962$ 218,217$ 293,246$ 506,274$ 47.19% Materials and Supplies 101-420-2400-42000 Office Supplies 1,722 865 1,750 480 1,000 1,750 0.00% 101-420-2400-42030 Printed Forms 350 350 350 0.00% 101-420-2400-42120 Fuel, Oil and Fluids 198 2,841 3,600 1,411 3,600 3,600 0.00% Total Materials and Supplies 1,920$ 3,706$ 5,700$ 1,890$ 4,950$ 5,700$ 0.00% Charges and Services 101-420-2400-43030 Engineering 248 1,000 3,525 3,525 3,000 200.00% 101-420-2400-43150 Inspector Contract Services 126,322 126,322 5,000 #DIV/0!MnSPECT 101-420-2400-43180 Information Technology/Web 6,114 4,552 #DIV/0!See below separated out for 2019 101-420-2400-43185 IT Support 5,654 5,340 5,654 6,200 9.67%Roseville, added costs for additional Insp 101-420-2400-42002 IT Hardware 1,800 1,480 1,500 600 -66.67%Computer Desktops 1 101-420-2400-43190 Software Programs 8,126 718 8,126 8,900 9.52%i-pads and PermitWorks,Roseville, costs for addln Insp 101-420-2400-43210 Telephone 3,208 3,579 3,325 2,994 3,325 3,650 9.78%Roseville , Sprint, verizon card costs 101-420-2400-43510 Legal Publishing 141 #DIV/0! 101-420-2400-43630 Insurance 185 3,566 4,101 2,790 3,000 4,511 10.00% 101-420-2400-44040 Repairs/Maint Eqpt 786 1,012 1,000 1,311 1,311 1,500 50.00% 101-420-2400-44170 Uniforms 986 560 800 260 500 800 0.00%Jackets, shirts, ID's 101-420-2400-44330 Dues & Subscriptions 310 65 740 260 740 500 -32.43% 101-420-2400-44350 Books 345 231 500 1,168 500 500 0.00% 101-420-2400-44370 Conferences & Training 1,066 2,885 3,200 1,085 3,200 3,200 0.00% 101-420-2400-44380 Building Code Surcharges - - - #DIV/0!Not budgeted as pass thru Total Charges and Services 13,389$ 16,449$ 30,245$ 147,253$ 157,703$ 38,361$ 26.83% Capital Outlay 101-480-2400-45500 Vehicle - - 24,000 24,000 24,000 - -100.00%Vehicle for new inspector Total Capital Outlay -$ -$ 24,000$ 24,000$ 24,000$ -$ -100.00% Miscellaneous 101-420-2400-44371 Allocations from Admin, Finance, City Hall 19,167 #DIV/0! 101-420-2400-44300 Miscellaneous 3,833 - 1,000 266 1,000 1,000 0.00% Total Miscellaneous 3,833$ -$ 1,000$ 266$ 1,000$ 20,167$ 1916.69% CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 10 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments 2400 Total Building Inspection 319,004$ 296,893$ 404,907$ 391,626$ 480,899$ 570,502$ 40.90% 2500 Emergency Communications Charges and Services 101-420-2500-43150 Contract Services 2,729 900 1,780 1,933 2,000 3,350 88.20%Increse due to repair/replace siren pole. Total Charges and Services 2,729$ 900$ 1,780$ 1,933$ 2,000$ 3,350$ 88.20% 2500 Total Emergency Communications 2,729$ 900$ 1,780$ 1,933$ 2,000$ 3,350$ 88.20% 2700 Animal Control Charges and Services 101-420-2700-43150 Contract Services 11,448 10,930 9,000 13,997 14,000 11,000 22.22% Total Charges and Services 11,448$ 10,930$ 9,000$ 13,997$ 14,000$ 11,000$ 22.22% 2700 Total Animal Control 11,448$ 10,930$ 9,000$ 13,997$ 14,000$ 11,000$ 22.22% 3100 Streets Personnel 101-430-3100-41010 Full-time Salaries 317,102 357,436 290,012 321,383 290,012 307,899 6.17% 101-430-3100-41030 Part-time Salaries #DIV/0! 101-430-3100-41020 Overtime 4,676 6,000 9,330 11,000 9,000 50.00%On call and overtime 101-430-3100-41040 Temporary Employees 5,240 2,550 9,360 4,527 9,360 10,764 15.00%Seasonals ($13-$14/hr) 101-430-3100-41210 PERA Contributions 23,647 26,793 21,751 25,138 21,751 23,542 8.23%Full time $23092, OT $450 101-430-3100-41220 FICA Contributions 23,964 26,977 22,186 25,222 22,186 24,836 11.94%Full time $23554, OT & Seasonals$1282 101-430-3100-41230 Medicare Contributions #DIV/0! 101-430-3100-41300 Insurance 46,887 70,328 75,728 63,093 75,728 77,834 2.78% 101-430-3100-41325 Life Insurance 536 819 299 819 844 3.00% 101-430-3100-41330 STD/LTD 1,951 2,049 1,372 2,049 2,110 3.00% 101-430-3100-41600 Safety Clothing Allowance 160 744 515 600 600 -19.35%Boots ($200 per person allocated by Salary Allocation) 101-430-3100-41420 Unemployment Benefits 3,636 101-430-3100-41510 Workers Compensation 17,290 23,593 23,593 6,794 6,794 32,266 36.76%2019 Prem $31402, Refund from 2018 $24608 Total Personnel 434,130$ 518,635$ 452,242$ 457,673$ 440,299$ 489,695$ 8.28% Materials and Supplies 101-430-3100-42000 Office Supplies 658 443 800 1,316 1,350 650 -18.75% 101-430-3100-42120 Fuel, Oil and Fluids 33,536 41,006 15,000 14,324 17,000 17,000 13.33%Split all PW departments 101-430-3100-42150 Operating Supplies 3,009 5,606 2,500 13,829 14,000 4,400 76.00% Contract Service ROW #DIV/0! 101-430-3100-42210 Repair/Maint. Supplies 4,250 28,270 10,000 12,345 13,000 10,000 0.00% 101-430-3100-42212 Repair/Maint. Supplies S&I 5,448 228 10,000 8,338 9,500 10,000 0.00% 101-430-3100-42240 Street Maintenance & Landscaping - Materials 17,453 37,568 20,000 50,267 50,267 39,864 99.32% Sealcoat and Crackseal materials - potholes, landscape fixes, etc 101-430-3100-42250 Street Maintenance #DIV/0! 101-430-3100-42260 Street Signs 5,631 8,944 5,000 3,287 3,300 4,500 -10.00% 101-430-3100-42290 Sand/Salt S&I 74,202 125,999 80,000 96,111 107,000 153,363 91.70%400(times $76) tons untreated 1400 *x$91) unteated 101-430-3100-42400 Small Tools & Minor Equipment 3,777 6,166 20,500 14,926 15,000 4,500 -78.05%small aluminum trailer $1500 101-430-3100-44375 Personal Protection Equipment 1,828 1,188 2,800 854 900 1,400 -50.00% Total Materials and Supplies 149,793$ 255,419$ 166,600$ 215,598$ 231,317$ 245,677$ 47.47% Charges and Services 101-430-3100-43030 Engineering Services 6,311 12,289 4,800 11,720 12,000 6,000 25.00%Misc 101-430-3100-43090 Sealcoating & Crack Sealing 411,254 120,732 590,000 826,192 826,192 565,000 -4.24%Sealcoat, crackseal, mill/overlay 101-430-3100-43150 Contract Services 32,636 25,501 24,500 14,101 24,000 24,000 -2.04%Striping, guard rail repair, tree trimming, mowing, etc. 101-430-3100-43180 Information Technology/Web 3,601 4,441 250 #DIV/0! CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 11 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments 101-430-3100-43185 IT Support 1,750 7,482 9,306 11,782 11,782 57.48%Roseville/Comcast 101-430-3100-42002 IT Hardware 37 1,200 513 1,200 1,200 0.00%2 computers 101-430-3100-43190 Software Programs 1,604 1,540 1,604 1,700 5.99%Roseville, BeHIve Asset Mgmt 101-430-3100-43151 Snow Removal Contract Services #DIV/0! 101-430-3100-44050 Tree Program #DIV/0! 101-430-3100-43210 Telephone 7,278 6,156 5,930 3,327 5,930 6,200 4.56%Roseville, Sprint, TDS, Verizon 101-430-3100-43230 Radio 1,200 24,117 7,000 3,091 7,000 5,000 -28.57%Wash Co. fees 101-430-3100-43310 Mileage 280 245 250 #DIV/0! 101-430-3100-43510 Public Notices 152 212 212 212 #DIV/0! 101-430-3100-43630 Insurance 15,688 17,740 20,401 19,293 19,293 22,441 10.00% 101-430-3100-43810 Utilities 18,427 22,111 19,698 22,458 24,000 24,000 21.84% US Solar Subsription/Traffic Signals/PW Electric 101-430-3100-43811 Street Lights 31,677 43,826 33,000 32,710 33,000 36,000 9.09% 101-430-3100-43840 Refuse 2,343 5,998 3,000 5,997 6,300 4,500 50.00% 101-430-3100-44010 Repairs/Maint Bldg.11,438 35,637 21,000 21,011 21,011 15,000 -28.57%new garage doors/openers at PW 101-430-3100-44030 Repairs/Maint Imp Other Than Bldg.1,203 2,955 1,500 9 25 500 -66.67% 101-430-3100-44040 Repairs/Maint Equip 36,570 27,429 20,000 26,612 27,000 25,000 25.00% 101-430-3100-44041 Repairs/Maint Equip S&I 4,928 1,182 14,000 15,553 16,000 14,000 0.00% 101-430-3100-44130 Equipment Rental 2,500 2,000 73 150 2,000 0.00% 101-430-3100-44170 Uniforms 7,118 8,047 5,578 4,486 5,578 5,625 0.84%Allocate to all dept 101-430-3100-44330 Dues & Subscriptions 531 661 800 606 750 700 -12.50% 101-430-3100-44370 Conferences & Training 2,242 2,956 4,800 6,043 6,043 3,000 -37.50% 101-430-3100-44380 Clean-up Days 14,256 - - - - - #DIV/0! Total Charges and Services 608,853$ 366,067$ 788,292$ 1,025,381$ 1,049,315$ 774,110$ -1.80% Capital Outlay 101-900-9000-47200 Transfer to Vehicle Replacement Fund #DIV/0!Transfer to Vehicle Replacement Fund - See below 101-480-3100-45500 Capital Purchases - 57,443 - - - - #DIV/0! Total Capital Outlay -$ 57,443$ -$ -$ -$ -$ #DIV/0! Miscellaneous 101-430-3100-44300 Miscellaneous 631 559 1,000 1,846 1,900 1,000 0.00% Total Miscellaneous 631$ 559$ 1,000$ 1,846$ 1,900$ 1,000$ 0.00% 3100 Total Streets 1,193,407$ 1,198,122$ 1,408,134$ 1,700,498$ 1,722,831$ 1,510,482$ 7.27% 5200 Parks & Recreation Personnel 101-450-5200-41010 Full-time Salaries 56,356 64,831 132,127 66,242 75,000 141,559 7.14% 101-450-5200-41030 Part-time Salaries #DIV/0! 101-450-5200-41020 Overtime 97 97 #DIV/0!On call pay 101-450-5200-41040 Temporary Employees 24,543 9,311 14,000 4,582 8,000 10,000 -28.57%Seasonal Workers/Park Summer-Ice Rink Winter 101-450-5200-41210 PERA Contributions 4,583 4,977 9,910 4,941 9,910 10,617 7.13%Full time $10617 101-450-5200-41220 FICA Contributions 5,979 5,544 10,108 5,329 10,108 11,900 17.73%Full time $10829, Seasonals $1071 101-450-5200-41230 Medicare Contributions #DIV/0! 101-450-5200-41300 Insurance 19,091 6,248 34,493 8,928 34,493 36,229 5.03% 101-450-5200-41325 Life Insurance 57 200 56 200 206 3.00% 101-450-5200-41330 STD/LTD 202 544 215 544 560 3.00% 101-450-5200-41600 Safety Clothing Allowance 315 315 350 11.11%Boots ($200 per person allocated by Salary Allocation) 101-450-5200-41420 Unemployment Benefits 1,367 #DIV/0! 101-450-5200-41510 Workers Compensation 4,206 22,078 22,078 7,354 7,354 9,013 -59.18%2019 Prem $8772, Refund from 2018 $1418 Total Personnel 116,124$ 113,248$ 223,775$ 97,744$ 146,021$ 220,435$ -1.49% Materials and Supplies 101-450-5200-42000 Office Supplies 611 394 800 368 400 650 -18.75% 101-450-5200-42120 Fuel, Oil and Fluids 2,000 6,792 7,500 6,250 212.50%Allocated to all PW departments 101-450-5200-42150 Operating Supplies 182 989 1,000 617 750 750 -25.00% CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 12 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments 101-450-5200-42160 Chemicals 577 579 2,000 201 300 1,000 -50.00% 101-450-5200-42210 Repair/Maint. Supplies 1,153 5,107 7,000 5,838 6,000 5,500 -21.43%Combined with Landscaping materials 101-450-5200-42230 Building Repair Supplies 100 63 500 - 500 0.00% 101-450-5200-42250 Landscaping Materials 2,593 135 #DIV/0! 101-450-5200-42400 Small Tools & Minor Equipment 2,548 1,570 5,000 709 1,000 4,550 -9.00%small aluminum trailer $1500 Total Materials and Supplies 7,762$ 8,701$ 18,300$ 14,659$ 15,950$ 19,200$ 4.92% Charges and Services 101-450-5200-43030 Engineering Services 123 #DIV/0! 101-450-5200-43150 Contracted Services 7,592 63,562 80,000 48,535 50,000 64,500 -19.38% Sunfish MgmtK, Mowing $45k, $13k Fertilizer, $9k misc (2 addditional parks) 101-450-5200-43185 IT Support 2,620 4,636 4,523 4,636 4,636 0.01%Roseville 101-450-5200-42002 IT Hardware 505 505 250 #DIV/0! 101-450-5200-43190 Software Programs 340 340 340 340 0.00%Roseville 101-450-5200-43210 Telephone 948 1,085 993 1,533 1,600 1,750 76.29%Roseville, Sprint 101-450-5200-43510 Public Notices 66 #DIV/0! 101-450-5200-43630 Insurance 3,198 5,404 6,214 5,876 5,876 6,835 10.00% 101-450-5200-43810 Utilities 10,641 7,314 10,500 6,964 10,500 10,500 0.00%Water costs added in. US Solar 101-450-5200-43840 Refuse 1,991 2,609 1,000 3,732 4,000 4,000 300.00% 101-450-5200-44010 Repairs/Maint Bldg 130 2,074 5,000 5,619 5,619 2,500 -50.00% 101-450-5200-44030 Repairs/Maint Imp Not Bldgs 9,113 5,434 3,200 3,063 3,200 3,200 0.00% 101-450-5200-44040 Repairs/Maint Eqpt 1,170 5,200 3,200 15,239 16,000 14,975 367.97% 101-450-5200-44120 Rentals - Buildings 7,627 6,294 8,000 4,379 6,250 7,000 -12.50%porta-potties at new parks 101-450-5200-44130 Equipment Rental 797 #DIV/0! 101-450-5200-44170 Uniforms 58 1,078 620 1,078 1,078 0.00%Allocated from Streets 101-450-5200-44301 Events 450 482 500 524 524 550 10.00%Tree Give Away 101-450-5200-44302 Lakes 7,499 9,934 15,000 12,570 15,000 15,000 0.00%Grant to treat Invasive Species 101-450-5200-44370 Conferences & Training 1,495 1,200 2,137 2,137 800 -33.33% 101-450-5200-44130 Equipment Rental 650 1,200 450 1,000 -16.67% 101-450-5200-44375 Personal Protection Equipment 1,521 1,262 800 229 350 400 -50.00% Total Charges and Services 52,003$ 115,540$ 142,860$ 117,186$ 128,065$ 139,314$ -2.48% Capital Outlay 101-900-9000-47200 Transfer to Vehicle Replacement Fund #DIV/0!Transfer to Vehicle Replacement Fund-See below 101-900-5200-45500 Capital Purchases - 21,003 - - - - #DIV/0! Total Capital Outlay -$ 21,003$ -$ -$ -$ -$ #DIV/0! Miscellaneous 101-450-5200-44300 Miscellaneous (1,434) 958 1,000 1,535 1,459 1,000 0.00% Total Miscellaneous (1,434)$ 958$ 1,000$ 1,535$ 1,459$ 1,000$ 0.00% 5200 Total Parks & Recreation 174,455$ 259,450$ 385,935$ 231,124$ 291,495$ 379,949$ -1.55% - 9000 Transfers Transfers 101-900-9000-47200 Transfer to Washington County (Library)7,966 #DIV/0! 101-900-9000-47205 Operating Transfer to EDA 25,225 30,000 30,000 30,000 30,000 0.00%Transfer for City Hall to EDA 101-900-9000-47201 Transfer to Project Fund 25,000 #DIV/0!Transfer to Lake Elmo Ave Phase 3 Project Fund 101-900-9000-47201 Transfer to Project Fund 30,000 #DIV/0!Transfer to Project Fund Kwik Trip Stoplight 101-900-9000-47201 Transfer to Project Fund 117,820 #DIV/0! 101-900-9000-47285 Transfer to Debt Service 67,859 67,859 67,859 -100.00% 101-900-9000-47200 Transfer to Vehicle Replacement Fund 470,076 470,076 470,076 903,847 92.28% Additional available for transfer to Equpment Replacement Fund 101-900-9000-47200 Transfer to Vehicle Replacement Fund 75,000 75,000 75,000 100,000 33.33%Budgeted Transfer for Fire, Streets, Parks Equipment 101-900-9000-47200 Transfer to Vehicle Replacement Fund - - 100,000 100,000 100,000 - -100.00%Fund Balance transfer for Equipment Total Transfers 7,966$ 143,045$ 742,935$ 742,935$ 742,935$ 1,088,847$ 46.56% CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 13 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments 9000 Total Transfers 7,966$ 143,045$ 742,935$ 742,935$ 742,935$ 1,088,847$ 46.56% 9000 Contingency Reserve Contingency Reserve Reserve for possible Insurance Increase - - 3,788 - - - -100.00% Total Contingency Reserve -$ -$ 3,788$ -$ -$ -$ -100.00% 9000 Contingency Reserve -$ -$ 3,788$ -$ -$ -$ -100.00% Prior Period Adjustments (52,015)$ Total General Fund Expenditures:4,332,661$ 4,400,905$ 5,591,009$ 5,069,832$ 5,852,734$ 6,171,030$ 10.37% Total Gen Fund Revs. Over/(Under) Expenditures:220,609$ 666,321$ (124,000)$ (1,448,351)$ (160,395)$ (0)$ -100.00%Use of Fund Balance if negative (0.00) CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 14 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments 601 Water Fund Water Fund Revenues: 601-000-0000-33422 PERA Pension Revenue 38 704 #DIV/0! 601-000-0000-33426 Miscellaneouse State Grants 67,698 124,191 #DIV/0! 601-000-0000-36100 Special Assessments 21,137 34,837 108,550 32,549 21,776 21,776 -79.94%Per Northland schedule 601-000-0000-36101 Delinquent Special Assessments 368 #DIV/0! 601-000-0000-36102 Special Assessments Penalties & Interest 13,905 44 #DIV/0! 601-000-0000-36103 Prepaid Special Assessments 5,220 #DIV/0! 601-000-0000-36200 Miscellaneouse 82 #DIV/0! 601-000-0000-36206 Smart Controller Pilot Program 875 #DIV/0! 601-000-0000-36205 Refunds and Reimbursements 1,902 #DIV/0! 601-000-0000-36210 Interest on Investments 18,096 31,305 20,000 60,000 60,000 200.00% 601-000-0000-36220 Rent 10,010 #DIV/0!Rent on Land from 3M 601-000-0000-36267 Litigation Settlement 2,700,000 #DIV/0!$2,700,000 Cash, $1,800,000 Land 601-000-0000-37100 Water Sales 883,610 834,042 937,421 757,209 937,421 1,149,997 22.68%Faster build out than estimated, no rate increase for 2020 601-000-0000-37120 Bulk Water 3,184 1,122 106 #DIV/0! 601-000-0000-37130 Water Lat Benefit Fee 25,100 26,100 #DIV/0! 601-000-0000-39250 Contribution of Capital Assets 137 #DIV/0! 601-000-0000-37140 Water Access Revenue 1,425,000 818,000 960,000 469,000 469,000 800,000 -16.67%Per Northland schedule 601-000-0000-37150 Water Connections - Municipal 172,000 489,000 320,000 454,900 454,900 320,000 0.00%Per Northland schedule 601-000-0000-37160 Penalties 1,703 601-000-0000-37170 Meter Sales 118,052 115,036 90,000 81,480 90,000 95,000 5.56% 601-000-0000-37180 Tower Rent - #DIV/0! 601-000-0000-39200 Transfer In - 840 - - - - #DIV/0! Total Water Fund Revenues:2,735,954$ 2,366,676$ 2,435,971$ 4,635,952$ 2,033,097$ 2,446,773$ 0.44% Water Fund Expenses: Personnel 601-494-9400-41010 Full-time Salaries 111,772 126,525 166,020 119,920 166,020 184,555 11.16% 601-494-9400-41030 Part-time Salaries #DIV/0! 601-494-9400-41020 Overtime - 6,000 2,931 4,500 6,000 0.00%On call pay should go here 601-494-9400-41040 Temporary Employees #DIV/0! 601-494-9400-41210 PERA Contributions 15,925 1,131 12,452 8,988 12,452 14,740 18.37%Full time $14290, OT $450 MSRS Contributions -City Admin 448 #DIV/0!City Administrator Deferred Comp included here 601-494-9400-41220 FICA Contributions 8,457 9,104 12,701 8,853 12,701 14,946 17.68%Full time $14487, OT $459 601-494-9400-41230 Medicare Contributions #DIV/0! 601-494-9400-41300 Insurance 19,044 21,453 38,620 19,937 38,620 43,548 12.76%Salary Allocation Chg City Clerk/Deputy Clerk 601-494-9400-41325 Life Insurance 236 237 112 237 244 3.00% 601-494-9400-41330 STD/LTD 614 685 521 685 706 3.00% 601-494-9400-41415 OPEB Expense 1,080 601-494-9400-41301 Unemployment Insurance - 897 #DIV/0! 601-494-9400-41600 Safety Clothing Allowance 289 295 325 400 38.41%Boots ($200 per person allocated by Salary Allocation) 601-494-9400-41510 Workers Compensation 3,980 7,744 7,029 3,197 3,197 6,020 -14.35%2019 Prem $5859, Refund from 2018 $2662 Total Personnel 159,177$ 168,784$ 244,033$ 164,753$ 238,737$ 271,607$ 11.30% Materials and Supplies 601-494-9400-42000 Office Supplies 975 396 800 770 800 800 0.00% 601-494-9400-42120 Fuel, Oil and Fluids 4,500 8,097 9,000 9,000 100.00%Allocated to all PW Departments 601-494-9400-42030 Printed Forms 247 167 750 432 500 750 0.00% 601-494-9400-42150 Operating Supplies - 876 1,000 1,984 2,500 3,500 250.00%Lab Tests Baterial 601-494-9400-42160 Chemicals 5,992 8,316 13,000 3,004 9,000 11,000 -15.38% 601-494-9400-42210 Repair/Maint. Supplies 3,614 12,808 26,000 9,374 12,500 16,000 -38.46% 601-494-9400-42270 Utility System Maintenance 564 #DIV/0! 601-494-9400-42300 Water Meters & Supplies 124,127 138,652 135,000 83,099 90,000 145,000 7.41%Water meters CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 15 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments 601-494-9400-44375 Personal Protective Equipment 262 866 800 500 800 0.00% 601-494-9400-42400 Small Tools & Minor Equipment 2,218 6,924 10,800 1,918 2,500 9,800 -9.26% Total Materials and Supplies 137,435$ 169,005$ 192,650$ 109,242$ 127,300$ 196,650$ 2.08% Charges and Services 601-494-9400-43030 Engineering Services 50,457 33,187 20,000 44,767 20,000 20,000 0.00% 601-494-9400-43040 Legal Services 118,260 181,188 200,000 1,604,793 1,675,000 10,000 -95.00% 601-494-9400-43010 Audit Services 7,987 7,913 7,987 7,987 0.01% split GF, Water, Sewer, SW 601-494-9400-43090 Newsletter 1,100 #DIV/0!printing only (split with Communications and sewer) 601-494-9400-43150 Contract Services 73,154 40,461 31,000 12,264 20,000 30,000 -3.23%new SCADA agreement, Mowing Computers #DIV/0! 601-494-9400-43180 Software Support 31,126 601-494-9400-43185 IT Support 6,289 7,297 7,037 7,297 7,297 0.01%Roseville 601-494-9400-42002 IT Hardware 1,800 505 1,800 1,000 -44.44% Computer Replacements PW + $1200 Meter Reading Computer in Finance 601-494-9400-43190 Software Programs 3,274 8,909 9,000 9,000 174.91%Roseville, Banyon, Accela 601-494-9400-43210 Telephone 687 1,141 987 1,682 1,900 2,000 102.70%Roseville, TDS 601-494-9400-44377 Credit Card Fees 382 1,972 4,333 4,500 5,000 153.55% 601-494-9400-43220 Postage 2,178 3,509 2,000 2,580 2,850 3,500 75.00% 601-494-9400-43310 Mileage 558 200 184 150 200 0.00% 601-494-9400-43610 Insurance 9,322 7,981 9,178 8,680 8,680 10,096 10.00% 601-494-9400-43810 Electric Utility 54,894 76,286 45,000 57,570 75,000 75,000 66.67%Electric & US Solar 601-494-9400-43820 Water Utility 242,929 29,736 7,755 11,000 15,000 #DIV/0!Water Connection Fees MDH 601-494-9400-44030 Repairs\Maint Imp Not Bldgs 17,363 94,233 20,000 45,363 47,000 45,000 125.00%Prairie Ridge Water Break 601-494-9400-44040 Repairs/Maint. Equip.- 10,222 12,000 10,098 12,000 7,500 -37.50%Well 2 PLC & Screen 601-494-9400-44010 Repairs\Maint Imp Bldgs - 48,535 2,000 3,313 3,500 4,000 100.00% 601-494-9400-44150 Equipment Rental - 1,000 807 900 1,000 0.00% 601-494-9400-44170 Uniforms 984 767 1,000 1,000 1.63%Allocated from Streets 601-494-9400-44330 Dues & Subscriptions 196 310 350 400 #DIV/0! 601-494-9400-44370 Conferences & Training 1,880 1,178 2,000 1,510 1,510 1,600 -20.00% 601-494-9400-44386 Real Estate Taxes - - - 12,282 12,650 25,300 #DIV/0!Taxes on 180 acres from 3M Settlement Total Charges and Services 577,608$ 559,725$ 368,678$ 1,843,420$ 1,924,074$ 282,980$ -23.24% Capital Outlay 601-494-9400-45300 Improvments Other Than Bldgs - - 358,000 519,752 358,000 545,000 52.23% CIP (Half of Utility Van 35,000, , E village truck line 132,000, well and pump house 240,000, Streety & Utility improvements 50,000 water meter change out 50,000, watermain oversizing 38,000)Total Capital Outlay -$ -$ 358,000$ 519,752$ 358,000$ 545,000$ 52.23% Miscellaneous and Non-operating 601-494-9400-43320 Depreciation Expense 808,865 902,049 #DIV/0! 601-494-9400-44300 Miscellaneous 38,696 1,086 2,000 2,000 2,000 0.00% 601-494-9400-46010 Bond Principal - 810,000 590,427 820,000 820,000 1.23% 601-494-9400-46110 Bond Interest 295,328 265,789 292,041 136,105 292,041 344,370 17.92%Per Northland schedule 601-494-9400-46200 Fiscal Agent Fees - Bond Payments 675 1,740 11,000 2,000 2,000 -81.82% 601-494-9400-46250 Fiscal Agent Fees - Bond Issuance #DIV/0! 601-494-9400-46220 Deferred Charges Amort (6,599) #DIV/0! 601-494-9400-46350 Bond Issuance Costs 11,262 12,000 12,000 12,000 0.00% 601-494-9400-47200 Transfer Out - - - - - - #DIV/0! Total Misc. and Non-operating 1,148,226$ 1,170,664$ 1,127,041$ 726,532$ 1,128,041$ 1,180,370$ 4.73% Prior Period Adjustments 271,735 Total Water Fund Expenses:2,022,445$ 2,339,912$ 2,290,402$ 3,363,699$ 3,776,152$ 2,476,607$ 8.13% Total Water Fund Revs. Over/(Under) Expenses:713,509$ 26,764$ 145,569$ 1,272,253$ (1,743,055)$ (29,834)$ -120.49% CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 16 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments 602 Sewer Fund Sewer Fund Revenues: 602-000-0000-33422 PERA Pension Revenue 9 168 #DIV/0! 602-000-0000-36100 Special Assessments 1,229,699 1,331,400 141,799 145,320 137,250 137,250 -3.21%Per Northland schedule 602-000-0000-36101 Delinquent Special Assessments 602-000-0000-36102 Special Assessments Penalties & Interest 96,164 602-000-0000-36103 Prepaid Special Assessments 123,268 602-000-0000-36210 Interest on Investments 20,362 48,217 20,000 (5,100) 40,000 40,000 100.00% 602-000-0000-37160 Penalties 428 602-000-0000-37200 Sewer Sales 267,130 244,383 339,840 268,315 339,840 300,000 -11.72%Per Northland schedule - 1% increase in fees 602-000-0000-37220 SAC Early Pay discount/revenue 8,474 7,803 4,672 7,000 7,500 #DIV/0!Based on averages 602-000-0000-37230 Sewer Lat Benefit Fee 11,000 31,050 11,000 -100.00% 602-000-0000-39250 Contribution of Capital Assets 71,269 #DIV/0! 602-000-0000-37240 Sewer Connecton Fee Revenue (SAC)1,450,165 767,500 901,500 470,192 470,192 900,000 -0.17%Per Northland schedule 602-000-0000-37250 Sewer Connection Fees Regional 21,000 #DIV/0!Pass-through of approx $21K 602-000-0000-37260 Sewer Connection Fees Municipa 677,980 565,180 339,500 455,001 455,001 320,000 -5.74%Per Northland schedule Total Sewer Fund Revenues:3,757,088$ 3,061,244$ 1,773,689$ 1,472,668$ 1,449,283$ 1,704,750$ -3.89% Sewer Fund Expenses: Personnel 602-495-9450-41010 Full-time Salaries 23,073 54,674 79,409 46,361 65,000 97,613 22.92% 602-495-9450-41030 Part-time Salaries #DIV/0! 602-495-9450-41020 Overtime - 6,000 2,978 4,000 6,200 3.33%On call pay 602-495-9450-41040 Temporary Employees #DIV/0! 602-495-9450-41210 PERA Contributions 3,807 (11,709) 5,956 3,475 5,956 8,085 35.75%Full time $7620, OT $465 MSRS Contributions -City Admin 299 #DIV/0!City Administrator Deferred Comp included here 602-495-9450-41220 FICA Contributions 1,985 3,993 6,075 3,441 6,075 7,942 30.73%Full time $7467, OT $475 602-495-9450-41230 Medicare Contributions #DIV/0! 602-495-9450-41300 Insurance 8,429 5,434 17,825 8,271 17,825 22,116 24.07%Salary Allocation Chg City Clerk/Deputy Clerk 602-495-9450-41325 Life Insurance 72 125 50 125 129 3.00% 602-495-9450-41330 STD/LTD 194 491 218 491 506 3.00% 602-495-9450-41415 OPEB Expense 572 602-495-9450-41600 Safety Clothing Allowance 140 120 140 140 0.00%Boots ($200 per person allocated by Salary Allocation) 602-495-9450-41301 Unemployment Insurance - 555 #DIV/0! 602-495-9450-41510 Workers Compensation 2,004 4,626 3,911 2,488 2,488 3,537 -9.57%2019 Prem $3442, Refund from 2018 $954 Total Personnel 39,299$ 58,411$ 119,932$ 67,402$ 102,100$ 146,566$ 22.21% Materials and Supplies 602-495-9450-42210 Repair/Maint. Supplies 1,724 280 4,000 1,559 4,630 28,130 603.25%$25,000 Bioxide chemical at lisbon lift 602-495-9450-42000 Office Supplies 73 1,425 800 410 500 600 -25.00% 602-495-9450-42030 Printed Forms 167 613 600 600 #DIV/0! 602-495-9450-42120 Fuel, Oil and Fluids 4,500 6,900 8,000 8,000 77.78%Allocated to all PW Departments 602-495-9450-42150 Operating Suppies - 471 1,000 833 1,000 1,500 50.00% 602-495-9450-42270 Repair/Maint. Supplies 602-495-9450-44375 Personal Protective Equipment 262 1,157 800 716 716 350 -56.25% 602-495-9450-42400 Small Tools & Minor Equipment 2,462 5,110 4,500 70 70 2,500 -44.44% Total Materials and Supplies 4,521$ 8,610$ 15,600$ 11,101$ 15,516$ 41,680$ 167.18% Charges and Services 602-495-9450-43030 Engineering Services 5,310 4,605 20,000 6,683 20,000 15,000 -25.00% 602-495-9450-43010 Audit Services 7,987 7,913 7,987 7,987 0.01% split GF, Water, Sewer, SW 602-495-9450-43090 Newsletter 1,100 #DIV/0!printing only (split with Comunnications and Water) 602-495-9450-43150 Contract Services 291,285 20,951 30,400 19,450 30,000 57,000 87.50% new SCADA agreement $6k/Mowing $3000, $20,000 tank pumping 602-495-9450-43185 IT Support 5,989 4,041 3,962 4,258 4,258 5.38%Roseville CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 17 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments 602-495-9450-42002 IT Hardware 800 505 505 -100.00%Computer Replacements 602-495-9450-43180 Software Support 31,306 602-495-9450-43190 Software Programs 3,010 8,459 8,459 8,459 181.05%Roseville, Banyon, Accela, Sensus 602-495-9450-43210 Telephone 1,146 1,726 1,707 2,080 2,500 2,500 46.48%Roseville, TDS, T-Mobile 602-495-9450-44377 Credit Card Fees 382 1,972 2,599 2,800 3,000 52.13% 602-495-9450-43220 Postage 2,500 3,500 1,175 2,569 2,569 3,500 197.87% 602-495-9450-43310 Mileage - 90 90 90 #DIV/0! 602-495-9450-43610 Insurance 603 3,187 3,665 3,466 3,665 4,032 10.00% 602-495-9450-43810 Electric Utility 5,739 11,782 9,000 12,528 13,000 15,000 66.67% 602-495-9450-43820 Sewer Utility - Met Council 83,809 92,140 169,359 155,246 169,359 229,887 35.74%Per Met Council 35.74% increase in 2020 602-495-9450-44010 Repairs/Maint Imp Bldgs 1,160 1,200 1,000 #DIV/0!split building expenses between all depts 602-495-9450-44040 Repairs/Maint. Equip.1,148 3,838 4,500 5,675 7,000 4,500 0.00% 602-495-9450-44150 Equipment Rental - 1,000 7 7 1,000 0.00% 602-495-9450-44170 Uniforms 563 335 563 600 6.57%Allocated from Streets 602-495-9450-44030 Repairs\Maint Imp Not Bldgs 1,683 15,000 13,998 15,000 2,000 -86.67%Pave Lisbon Lift Station 602-495-9450-44370 Conferences & Training 3,718 1,163 2,000 3,447 3,447 2,500 25.00% Total Charges and Services 401,246$ 176,264$ 276,178$ 250,171$ 292,409$ 363,413$ 31.59% Capital Outlay 602-495-9450-45300 Improvements Other Than Bldgs - 20,634 345,000 83,950 345,000 210,000 -39.13%CIP (Sewer Oversizing - $35k, Hamlet-$140k Half of Utility van $35,000 ) Total Capital Outlay -$ 20,634$ 345,000$ 83,950$ 345,000$ 210,000$ -39.13% Miscellaneous and Non-operating 602-495-9450-43320 Depreciation Expense 350,903 414,735 - #DIV/0! 602-495-9450-44300 Miscellaneous Expenses 50,873 300 300 300 -100.00% 602-495-9450-46010 Bond Principal - 470,000 335,358 470,000 435,000 -7.45%Per Northland schedule 602-495-9450-46110 Bond Interest 168,587 167,079 208,454 88,500 208,454 198,516 -4.77%Per Northland schedule 602-495-9450-46220 Deferred Charges Amort (3,811) #DIV/0! 602-495-9450-46350 Bond Issuance Costs 18,437 20,000 20,000 20,000 0.00% 602-495-9450-46200 Fiscal Agent Fees 16,000 2,000 2,000 -87.50% 602-495-9450-47200 Transfer Out - - - - - - #DIV/0! Total Misc. and Non-operating 584,989$ 582,114$ 714,754$ 423,858$ 700,754$ 655,516$ -8.29% Prior Period Adjustment 136,324$ Total Sewer Fund Expenses:1,030,056$ 982,357$ 1,471,464$ 836,481$ 1,455,779$ 1,417,175$ -3.69% Total Sewer Fund Revs. Over/(Under) Expenses:2,727,033$ 2,078,887$ 302,225$ 636,187$ (6,496)$ 287,575$ -4.85% 603 Storm Water Fund Storm Water Fund Revenues: 603-000-0000-33422 PERA Pension Revenue 5 84 #DIV/0! 603-000-0000-36100 Special Assessments 21,451 #DIV/0!Delinquent S/A's for '17 and estimate for '18 603-000-0000-36101 Delinquent Special Assessments 419 603-000-0000-36102 Special Assessment Penalties/Interest 360 54 603-000-0000-36210 Interest on Investment 8,247 16,902 7,000 25,000 25,000 257.14% 603-000-0000-39250 Contribution of Capital Assets (18) #DIV/0! 603-000-0000-36232 Developer Contributions 100,000 #DIV/0! 603-000-0000-37300 Surface Water Utility Sales 251,025 285,775 337,303 221,238 337,303 361,793 7.26%Per Northland schedule - ($5 incr per Residential lot) 603-000-0000-34113 SW Review Fee Revenue 38,350 36,925 29,051 29,275 - 30,000 3.27% Total Storm Water Fund Revenues:397,609$ 340,046$ 373,354$ 272,436$ 362,303$ 416,793$ 11.63% Storm Water Fund Expenses: Personnel 603-496-9500-41010 Full-time Salaries 12,962 30,103 54,068 29,163 50,000 61,586 13.90% 603-496-9500-41030 Part-time Salaries - #DIV/0! CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 18 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments 603-496-9500-41020 Overtime 1,500 #DIV/0!Spring culvert drainage 603-496-9500-41040 Temporary Employees #DIV/0! 603-496-9500-41210 PERA Contributions 1,909 (10,147) 4,055 2,178 4,055 4,881 20.37%Full time $4768, OT $113 MSRS Contributions -City Admin 149 #DIV/0!City Administrator Deferred Comp included here 603-496-9500-41220 FICA Contributions 975 2,113 4,136 2,146 4,136 4,826 16.68%Full time $4711, OT $115 603-496-9500-41230 Medicare Contributions #DIV/0! 603-496-9500-41300 Insurance 5,276 5,175 12,318 3,260 12,318 14,199 15.27%Salary Allocation Chg City Clerk/Deputy Clerk 603-496-9500-41325 Life Insurance 44 81 17 81 83 3.00% 603-496-9500-41330 STD/LTD 97 263 79 263 271 3.00% 603-496-9500-41415 OPEB Expense 318 603-496-9500-41600 Safety Clothing Allowance 88 88 125 42.05%Boots ($200 per person allocated by Salary Allocation) 603-496-9500-41301 Unemployment Insurance - 555 #DIV/0! 603-496-9500-41510 Workers' Compensation 1,150 1,626 1,626 1,037 1,037 1,731 6.48%2019 Prem $1685, Refund from 2018 $648 Total Personnel 22,272$ 29,883$ 76,635$ 37,880$ 71,978$ 89,352$ 16.59% Materials and Supplies 603-496-9500-42000 Office Supplies 428 224 800 387 450 450 -43.75% 603-496-9500-42120 Fuel, Oil and Fluids 400 2,651 3,000 3,000 650.00%Allocated to all PW Departments 603-496-9500-42030 Printed Forms 247 167 177 177 185 #DIV/0! 603-496-9500-42270 Repair/Maint. Maint Supplies 135 2,338 2,000 1,597 1,597 2,000 0.00% 603-496-9500-42150 Operating Supplies - 70 1,000 523 650 1,000 0.00% 603-496-9500-44375 Personal Protective Equipment 866 800 - 500 -37.50% 603-496-9500-42400 Small Tools & Minor Equipment 1,241 2,478 3,500 163 250 2,500 -28.57% Total Materials and Supplies 2,051$ 6,144$ 8,500$ 5,498$ 6,124$ 9,635$ 13.35% Charges and Services 603-496-9500-43030 Engineering Services 6,311 2,563 20,000 17,624 20,000 10,000 -50.00% 603-496-9500-43010 Audit Services 7,987 7,913 7,987 7,987 0.01% split GF, Water, Sewer, SW 603-496-9500-43040 Legal Services 403 403 603-496-9500-43150 Contract Services 18,116 10,259 6,000 4,633 4,633 5,000 -16.67% 603-496-9500-43180 Software Support 603-496-9500-43185 IT Support 3,558 3,668 3,609 3,609 3,778 3.01%Roseville 603-496-9500-42002 IT Hardware 1,000 505 505 200 -80.00%Ipad for Pond Insp 603-496-9500-43190 Software Programs 9,825 3,010 7,484 7,484 7,484 148.65%Roseville, Banyon Accela 603-496-9500-43210 Telephone 65 351 874 900 900 156.63%Roseville 603-496-9500-44377 Credit Card Fees 360 400 11.11% 603-496-9500-43220 Postage - 1,000 2,000 1,267 2,000 1,500 -25.00% 603-496-9500-43510 Legal Publishing 58 58 60 603-496-9500-43610 Insurance - 5,001 5,751 5,439 5,439 6,326 10.00% 603-496-9500-43810 Utilities 8 8 18 603-496-9500-44010 Street Sweeping 20,958 15,873 30,000 12,876 30,000 30,000 0.00% more streets with development includes contracting hauling out sweepings 603-496-9500-44040 Repairs/Maint Equip - 99 1,000 2,474 2,474 2,500 150.00% 603-496-9500-44015 Repairs/Maint Bldg 27 27 100 603-496-9500-44030 Repairs/Maint Not Bldg 32,790 33,500 250 500 25,473 -23.96% 603-496-9500-44150 Equipment Rental - 1,080 1,000 237 237 1,000 0.00% 603-496-9500-44170 Uniforms 234 155 234 250 6.84%Allocated from Streets 603-496-9500-44370 Conferences & Training 1,875 1,285 2,500 387 387 2,000 -20.00% Total Charges and Services 50,819$ 79,838$ 118,360$ 66,220$ 86,885$ 104,976$ -11.31% Capital Outlay 603-496-9500-45300 Improvements Other Than Bldgs - - 40,000 9,611 40,000 - -100.00%Storm Water Comp Plan Update Total Capital Outlay -$ -$ 40,000$ 9,611$ 40,000$ -$ -100.00% Miscellaneous and Non-operating 603-496-9500-43320 Depreciation Expense 56,298 149,901 #DIV/0! CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 19 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments 603-496-9500-44300 Miscellaneous Expenses 21,157 666 2,000 866 -100.00% 603-496-9500-46010 Bond Principal - 175,000 201,367 201,367 205,000 17.14%Per Northland schedule 603-496-9500-46110 Bond Interest 62,781 49,537 54,500 27,827 54,500 58,750 7.80%Per Northland schedule 603-496-9500-46220 Deferred Charges Amort (3,193) #DIV/0! 603-496-9500-46200 Fiscal Agent Fees 900 900 900 0.00% 603-496-9500-46300 Bond Issuance Costs 1,064 - - - - #DIV/0! Total Misc. and Non-operating 138,107$ 200,104$ 232,400$ 230,060$ 256,767$ 264,650$ 13.88% Prior Period Adjustment (74,348)$ Total Storm Water Fund Expenses:213,249$ 241,621$ 475,895$ 349,269$ 461,754$ 468,613$ -1.53% Total Storm Water Fund Revs. Over/(Under) Expenses:184,360$ 98,426$ (102,541)$ (76,833)$ (99,451)$ (51,820)$ -49.46% CITY OF LAKE ELMO 2020 PROPOSED BUDGET Master Worksheet - All Budgets - REVISED 1/8/20208:47 AM 20 Adopted 2019 to 2017 2018 2019 2019 2019 2020 Proposed 2020 Account Number Description Actual Actual Adopted YTD - Nov 15 2019 Projected Proposed Percent Change Comments 221 EDA Brookfield Building Fund EDA Brookfield Bldg Fund Revenues: 221-000-0000-34110 Tenant Rents 78,573 108,852 91,218 98,207 74,451 -31.60% 221-000-0000-36210 Interest Income 419 221-000-0000-39300 Bond Proceeds 926,000 #DIV/0! 221-000-0000-39201 Transfer from City Hall Budget 25,225 30,000 30,000 30,000 30,000 0.00% - - - - - - #DIV/0! Total EDA Brookfield Building Fund Revenues:-$ 1,030,217$ 138,852$ 121,218$ 128,207$ 104,451$ -24.78% EDA Brookfield Bldg Fund Expenses: Materials and Supplies 221-460-6301-42110 Repair/Maint. Maint Supplies 2,208 5,000 1,855 5,000 5,000 0.00% 221-460-6301-42150 Operating Supplies 36 100 105 100 100 0.00% - - - - - - #DIV/0! Total Materials and Supplies -$ 2,244$ 5,100$ 1,959$ 5,100$ 5,100$ 0.00% Charges and Services 221-460-6301-43150 Contract Services 11,798 9,480 22,696 25,000 10,000 5.49%HVAC, cleaning, pest control, misc 221-460-6301-44386 Real Estate Taxes 15,811 16,825 14,656 14,656 16,854 0.17% 221-460-6301-43810 Utilities 13,027 21,000 15,942 20,000 21,000 0.00%Xcel, w&s 221-460-6301-43840 Refuse 2,070 6,000 4,043 6,000 6,600 10.00% 221-460-6301-43610 Insurance 1,500 1,500 1,500 1,500 0.00% 221-460-6301-44040 Repairs/Maint Equip 2,754 1,500 2,371 3,500 7,500 400.00% 221-460-6301-44030 Repairs/Maint Not Bldg 1,301 1,500 #DIV/0! - - - - - - #DIV/0! Total Charges and Services -$ 45,460$ 56,305$ 62,508$ 72,156$ 63,454$ 12.70% Capital Outlay 221-460-6301-45200 Buildings 901,670 221-460-6301-45300 Improvements Other Than Bldgs - - - - - - #DIV/0! Total Capital Outlay -$ 901,670$ -$ -$ -$ -$ #DIV/0! Miscellaneous and Non-operating #DIV/0! 221-460-6301-44300 Miscellaneous Expenses 1,000 1,000 1,000 0.00% 221-900-9000-47285 Transfer to Debt Service 44,038 45,338 44,038 86,058 Bond Principal, Interest and Fiscal Agent Fees 221-460-6301-46010 Bond Principal #DIV/0!Budget but will be a transfer 221-460-6301-46110 Bond Interest #DIV/0!Budget but will be a transfer 221-460-6301-46220 Deferred Charges Amort #DIV/0! 221-460-6301-46200 Fiscal Agent Fees #DIV/0!Budget but will be a transfer 221-460-6301-46300 Bond Issuance Costs - 21,583 - - - - #DIV/0! Total Misc. and Non-operating -$ 21,583$ 45,038$ 45,338$ 45,038$ 87,058$ 93.30% Total EDA Brookfield Bldg Fund Expenses:-$ 970,956$ 106,443$ 109,805$ 122,294$ 155,612$ 46.19% Total EDA Brookfield Bldg Fund Revs. Over/(Under) Expenses:-$ 59,261$ 32,409$ 11,412$ 5,913$ (51,161)$ -257.86%