Loading...
HomeMy WebLinkAbout2018-Adopted-BudgetCITY OF LAKE ELMO 2018 PROPOSED BUDGET General Fund - December 5, 2017 1 Adopted 2017 to 2015 2016 2017 2017 2017 2018 Proposed 2018 Account Number Description Actual Actual Adopted YTD - Sept. 30 Projected Proposed Percent Change General Fund Revenues: Taxes 101-000-0000-31010 Current Ad Valorem Taxes 2,206,350$ 2,019,331$ 1,629,875$ 896,685$ 1,629,875$ 2,202,698$ 35.15% 101-000-0000-31020 Delinquent Ad Valorem Taxes 22,467 13,546 15,000 12,410 15,000 15,000 0.00% 101-000-0000-31030 Mobile Home Tax 18,874 14,366 12,000 3,017 12,000 15,000 25.00% 101-000-0000-31040 Fiscal Disparities 179,607 157,096 161,272 111,967 161,272 149,615 -7.23% 101-000-0000-31910 Penalty & Interest on Taxes 725 185 700 423 700 500 -28.57% Total Taxes 2,428,022$ 2,204,523$ 1,818,847$ 1,024,502$ 1,818,847$ 2,382,813$ 31.01% Licenses and Permits 101-000-0000-32110 Liquor License 8,350 7,025 9,000 8,300 8,300 8,300 -7.78% 101-000-0000-32180 Wastehauler License 480 1,560 1,000 - 1,000 1,000 0.00% 101-000-0000-32181 General Contractor License 50 150 150 - - - -100.00% 101-000-0000-32183 Heating Contractor License 3,901 3,450 2,850 800 1,200 - -100.00% 101-000-0000-32210 Building Permits 421,941 902,690 808,157 866,465 900,000 800,000 -1.01% 101-000-0000-32211 Driveway Permits 250 10,190 - 14,045 17,500 17,500 #DIV/0! 101-000-0000-32220 Heating Permits 34,359 128,558 44,820 112,435 122,000 60,000 33.87% 101-000-0000-32230 Plumbing Permits 42,662 92,752 44,820 84,505 90,000 60,000 33.87% 101-000-0000-32240 Animal License 2,116 1,900 1,720 1,605 2,000 2,000 16.28% 101-000-0000-32250 Utility Permits 59,033 60,234 33,000 30,196 33,000 33,000 0.00% 101-000-0000-32260 Burning Permit 1,530 2,035 3,750 1,405 3,750 2,500 -33.33% 101-000-0000-32270 Massage Therapy Licenses 200 75 100 - 100 100 0.00% 101-000-0000-35101 Fire Sprinkler Alarm Fees - - 15,000 10,835 15,000 8,500 -43.33% 101-000-0000-35102 Fire Alarm Fees - - - - - 1,500 #DIV/0! Total Licenses and Permits 574,871$ 1,210,619$ 964,367$ 1,130,591$ 1,193,850$ 994,400$ 3.11% Intergovernmental 101-000-0000-33418 MSA - Maintenance 119,464 123,433 130,838 122,883 122,883 135,561 3.61% 101-000-0000-33420 State Fire Aid 58,166 59,136 47,000 - 47,000 47,000 0.00% 101-000-0000-33422 PERA Aid 2,749 2,749 2,749 1,375 2,749 2,749 0.00% 101-000-0000-33426 Miscellaneous State Grants 26,285 8,367 4,820 541 4,820 4,820 0.00% 101-000-0000-33621 Recycling Grant 15,688 15,688 15,688 15,688 15,688 15,766 0.50% Total Intergovernmental 222,352$ 209,373$ 201,095$ 140,486$ 193,140$ 205,896$ 2.39% Charges for Services 101-000-0000-34103 Zoning & Subdivision Fees 29,035 33,490 23,000 44,308 50,000 55,000 139.13% 101-000-0000-34104 Plan Check Fees 242,970 500,965 513,002 487,470 509,822 525,000 2.34% 101-000-0000-34105 Sale of Copies, Books, Maps 116 213 280 9 125 200 -28.57% 101-000-0000-34107 Assessment Searches 3,030 4,905 1,395 885 1,000 1,395 0.00% 101-000-0000-34110 Rent - - - 12 12 - #DIV/0! 101-000-0000-34111 Cable Operation Reimbursement 71,912 1,600 4,000 1,710 4,000 5,000 25.00% 101-000-0000-36206 Escrow Administration Fee - 2,800 24,900 22,800 25,000 25,000 0.40% Total Charges for Services 347,063$ 543,973$ 566,577$ 557,194$ 589,959$ 611,595$ 7.95% Fines and Forfeits 101-000-0000-35100 Fines 48,739 49,505 46,500 30,557 49,000 49,000 5.38% Total Fines and Forfeits 48,739$ 49,505$ 46,500$ 30,557$ 49,000$ 49,000$ 5.38% Investment Earnings 101-000-0000-36210 Interest Earnings 23,501 20,437 40,000 - 25,000 40,000 0.00% Total Investment Earnings 23,501$ 20,437$ 40,000$ -$ 25,000$ 40,000$ 0.00% Miscellaneous CITY OF LAKE ELMO 2018 PROPOSED BUDGET General Fund - December 5, 2017 2 Adopted 2017 to 2015 2016 2017 2017 2017 2018 Proposed 2018 Account Number Description Actual Actual Adopted YTD - Sept. 30 Projected Proposed Percent Change 101-000-0000-33622 Cable Franchise Revenue - 98,218 72,000 67,178 94,178 68,000 -5.56% 101-000-0000-36200 Miscellaneous Revenue 2,438 28,205 4,000 28,923 32,900 29,900 647.50% 101-000-0000-36204 Reimbursements - Fire - 1,500 500 - - - -100.00% 101-000-0000-36207 ISD Service Fee In Lieu of Tax - - 31,500 - 31,500 32,130 2.00% 101-000-0000-36230 Donations - 10,000 10,000 11,400 11,400 10,000 0.00% 101-000-0000-37180 Tower Rent - - 46,000 42,644 51,000 53,000 15.22% 101-000-0000-38000 Use of Fund Balance - - 150,000 - 101,361 194,000 29.33% Total Miscellaneous 2,438$ 137,924$ 314,000$ 150,145$ 322,340$ 387,030$ 23.26% Total General Fund Revenues:3,646,987$ 4,376,355$ 3,951,386$ 3,033,475$ 4,192,136$ 4,670,734$ 18.20% 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 9 - 300 67 198 198 -34.00% Total Personnel 27,664$ 27,655$ 27,956$ 13,895$ 27,854$ 27,854$ -0.36% Materials and Supplies 101-410-1110-42000 Office Supplies - 72 - 114 120 30 #DIV/0! 101-410-1110-42001 Computer Reimbursement - - - 1,911 3,000 - #DIV/0! 101-410-1110-43310 Mileage 169 - 375 - 100 300 -20.00% Total Materials and Supplies 169$ 72$ 375$ 2,025$ 3,220$ 330$ -12.00% Charges and Services 101-410-1110-44300 Miscellaneous 8,764 15,691 5,250 6,568 6,750 6,750 28.57% 101-410-1110-44330 Dues & Subscriptions 11,519 11,986 11,813 3,622 11,813 12,470 5.56% 101-410-1110-44370 Conferences & Training 1,000 520 1,500 180 335 1,000 -33.33% Total Charges and Services 21,283$ 28,197$ 18,563$ 10,370$ 18,898$ 20,220$ 8.93% 1110 Total Mayor & Council 49,116$ 55,924$ 46,894$ 26,290$ 49,972$ 48,404$ 3.22% 1320 Administration Personnel 101-410-1320-41010 Full-time Salaries 232,992 195,150 153,083 134,052 180,359 217,946 42.37% 101-410-1320-41030 Part-time Salaries - 5,613 - 6,005 6,240 - #DIV/0! 101-410-1320-41210 PERA Contributions 12,638 14,378 11,481 12,592 16,004 16,346 42.37% 101-410-1320-41220 FICA Contributions 13,922 11,823 9,491 11,314 12,851 13,146 38.51% 101-410-1320-41230 Medicare Contributions 3,273 2,765 2,220 2,656 2,952 3,160 42.34% 101-410-1320-41300 Insurance 44,554 28,335 26,787 26,178 34,902 42,456 58.49% 101-410-1320-41510 Workers Compensation 6,717 6,252 6,300 693 1,437 1,678 -73.37% Total Personnel 314,096$ 264,317$ 209,362$ 193,490$ 254,745$ 294,732$ 40.78% Materials and Supplies 101-410-1320-42000 Office Supplies 5,538 5,113 5,500 3,546 5,000 4,500 -18.18% 101-410-1320-42030 Printed Forms 1,888 771 700 84 775 785 12.14% 101-410-1320-43040 Legal Services 100,075 322,842 170,000 91,403 100,000 100,000 -41.18% 101-410-1320-43090 Newsletter/Website - - 8,000 90 90 100 -98.75% Total Materials and Supplies 107,500$ 328,727$ 184,200$ 95,123$ 105,865$ 105,385$ -42.79% Charges and Services 101-410-1320-43100 Assessing Services 46,659 52,049 38,000 29,126 50,318 53,350 40.39% CITY OF LAKE ELMO 2018 PROPOSED BUDGET General Fund - December 5, 2017 3 Adopted 2017 to 2015 2016 2017 2017 2017 2018 Proposed 2018 Account Number Description Actual Actual Adopted YTD - Sept. 30 Projected Proposed Percent Change 101-410-1320-43150 Contract Services 1,100 1,019 - 15,080 16,000 3,000 #DIV/0! 101-410-1320-43180 Information Technology/Web 5,967 470 - 609 1,500 4,500 #DIV/0! 101-410-1320-43190 Software Programs - 2,338 - 2,601 3,000 3,750 #DIV/0! 101-410-1320-43210 Telephone 1,388 1,574 1,500 1,135 1,718 1,770 17.97% 101-410-1320-43220 Postage 4,541 3,741 3,000 (312) 1,000 4,000 33.33% 101-410-1320-43310 Mileage 70 418 348 517 750 1,000 187.36% 101-410-1320-43510 Legal Publishing 6,513 8,003 7,088 2,330 7,500 13,000 83.41% 101-410-1320-43610 Insurance 16,386 26,121 28,000 27,630 28,500 29,400 5.00% 101-410-1320-43620 Cable Operation Expense - - 31,400 - 31,400 - -100.00% 101-410-1320-44330 Dues & Subscriptions 1,713 1,877 2,500 1,227 1,800 2,250 -10.00% 101-410-1320-44370 Conferences & Training 2,511 844 2,170 1,346 1,700 2,000 -7.83% Total Charges and Services 86,848$ 98,454$ 114,006$ 81,289$ 145,186$ 118,020$ 3.52% Miscellaneous 101-410-1320-44300 Miscellaneous 1,210 538 600 212 600 600 0.00% Total Miscellaneous 1,210$ 538$ 600$ 212$ 600$ 600$ 0.00% 1320 Total Administration 509,653$ 692,035$ 508,168$ 370,114$ 506,396$ 518,737$ 2.08% 1410 Elections Personnel 101-410-1410-41030 Part-time Salaries 1,280 7,037 - - - 7,500 #DIV/0! 101-410-1410-41510 Workers Compensation - - - - - - #DIV/0! Total Personnel 1,280$ 7,037$ -$ -$ -$ 7,500$ #DIV/0! Charges and Services 101-410-1410-43150 Contract Services 600 1,200 1,200 1,660 1,660 1,660 38.33% Total Charges and Services 600$ 1,200$ 1,200$ 1,660$ 1,660$ 1,660$ 38.33% Capital Outlay 101-410-1410-45800 Other Equipment - 20 - - - - #DIV/0! Total Capital Outlay -$ 20$ -$ -$ -$ -$ #DIV/0! Miscellaneous 101-410-1410-44300 Miscellaneous - 835 - - - 1,000 #DIV/0! Total Miscellaneous -$ 835$ -$ -$ -$ 1,000$ #DIV/0! 1410 Total Elections 1,880$ 9,092$ 1,200$ 1,660$ 1,660$ 10,160$ 746.67% 1450 Communications Personnel 101-410-1450-41010 Full-time Salaries 11,191 - - 423 7,953 28,434 #DIV/0! 101-410-1450-41030 Part-time Salaries - - - - - - #DIV/0! 101-410-1450-41210 PERA Contributions 664 - - 32 596 2,133 #DIV/0! 101-410-1450-41220 FICA Contributions 680 - - 26 493 1,763 #DIV/0! 101-410-1450-41230 Medicare Contributions 159 - - 6 115 412 #DIV/0! 101-410-1450-41300 Insurance 3,672 - - - 1,907 7,659 #DIV/0! 101-410-1450-41510 Workers Compensation 213 - - - 61 219 #DIV/0! Total Personnel 16,578$ -$ -$ 487$ 11,125$ 40,620$ #DIV/0! Charges and Services 101-410-1450-43090 Newsletter 4,711 - - - 2,000 5,000 #DIV/0! 101-410-1450-43180 Information Technology/Web 35,507 50,580 67,396 37,084 38,800 35,500 -47.33% 101-410-1450-43210 Telephone 876 308 - - - - #DIV/0! 101-410-1450-43220 Postage 1,208 - - - - 1,000 #DIV/0! CITY OF LAKE ELMO 2018 PROPOSED BUDGET General Fund - December 5, 2017 4 Adopted 2017 to 2015 2016 2017 2017 2017 2018 Proposed 2018 Account Number Description Actual Actual Adopted YTD - Sept. 30 Projected Proposed Percent Change 101-410-1450-43310 Mileage 57 - - - - - #DIV/0! 101-410-1450-43510 Public Notices 1,586 - - - - - #DIV/0! 101-410-1450-43620 Cable Operations 3,849 3,955 - 4,580 5,000 5,000 #DIV/0! 101-410-1450-44370 Conferences and Training 360 - - - - - #DIV/0! Total Charges and Services 47,795$ 54,843$ 67,396$ 41,664$ 45,800$ 46,500$ -31.00% 1450 Total Communications 64,733$ 54,843$ 67,396$ 42,151$ 56,925$ 87,120$ 29.27% 1520 Finance Personnel 101-410-1520-41010 Full-time Salaries 60,494 63,053 59,561 47,423 64,231 14,664 -75.38% 101-410-1520-41030 Part-time Salaries - 12,702 10,000 16,148 16,500 6,760 -32.40% 101-410-1520-41210 PERA Contributions 4,537 5,281 4,835 1,784 1,438 1,100 -77.25% 101-410-1520-41220 FICA Contributions 3,545 4,500 3,997 1,702 1,647 1,328 -66.78% 101-410-1520-41230 Medicare Contributions 829 1,052 935 398 395 311 -66.74% 101-410-1520-41300 Insurance 10,010 10,938 11,994 5,758 6,800 3,831 -68.06% 101-410-1520-41420 Unemployment Benefits - - - - 8,742 5,464 #DIV/0! 101-410-1520-41510 Workers Compensation 472 204 600 315 315 165 -72.50% Total Personnel 79,886$ 97,731$ 91,922$ 73,527$ 100,068$ 33,623$ -63.42% Materials and Supplies 101-410-1520-42000 Office Supplies 818 338 600 446 750 600 0.00% 101-410-1520-42030 Printed Forms 137 1,117 375 - 300 375 0.00% Total Materials and Supplies 955$ 1,456$ 975$ 446$ 1,050$ 975$ 0.00% Charges and Services 101-410-1520-43010 Audit Services 28,270 29,345 29,500 26,575 29,500 30,425 3.14% 101-410-1520-43150 Contract Services 7,786 114 101 111,738 139,493 108,150 106979.21% 101-410-1520-43190 Software Programs 5,379 - - 6,400 6,400 19,433 #DIV/0! 101-410-1520-43210 Telephone 408 427 900 690 850 875 -2.78% 101-410-1520-43310 Mileage - - 50 - 100 250 400.00% 101-410-1520-44330 Dues & Subscriptions 420 170 670 170 500 500 -25.37% 101-410-1520-44370 Conferences & Training - - 500 254 500 750 50.00% Total Charges and Services 42,263$ 30,056$ 31,721$ 145,827$ 177,343$ 160,383$ 405.61% Miscellaneous 101-410-1520-44300 Miscellaneous 1,632 1,627 220 1,052 1,400 1,625 638.64% Total Miscellaneous 1,632$ 1,627$ 220$ 1,052$ 1,400$ 1,625$ 638.64% 1520 Total Finance 124,737$ 130,869$ 124,838$ 220,852$ 279,861$ 196,606$ 57.49% 1910 Planning & Zoning Personnel 101-410-1910-41010 Full-time Salaries 135,788 149,034 145,407 125,119 145,619 146,468 0.73% 101-410-1910-41030 Part-time Salaries - - - - 6,240 6,760 #DIV/0! 101-410-1910-41210 PERA Contributions 9,546 11,211 10,906 9,353 10,921 10,985 0.72% 101-410-1910-41220 FICA Contributions 7,919 9,075 9,015 7,367 9,415 9,500 5.38% 101-410-1910-41230 Medicare Contributions 1,852 2,122 2,109 1,723 2,202 2,222 5.36% 101-410-1910-41300 Insurance 29,145 23,249 25,772 22,969 30,625 26,803 4.00% 101-410-1910-41510 Workers Compensation 938 415 750 658 1,181 1,192 58.93% Total Personnel 185,188$ 195,105$ 193,959$ 167,189$ 206,203$ 203,930$ 5.14% Materials and Supplies 101-410-1910-42000 Office Supplies 1,661 810 1,800 186 350 800 -55.56% CITY OF LAKE ELMO 2018 PROPOSED BUDGET General Fund - December 5, 2017 5 Adopted 2017 to 2015 2016 2017 2017 2017 2018 Proposed 2018 Account Number Description Actual Actual Adopted YTD - Sept. 30 Projected Proposed Percent Change 101-410-1910-42030 Printed Forms 958 - 500 - 750 - -100.00% Total Materials and Supplies 2,619$ 810$ 2,300$ 186$ 1,100$ 800$ -65.22% Charges and Services 101-410-1910-43020 Comprehensive Planning - - - 26,530 54,000 36,000 #DIV/0! 101-410-1910-43030 Engineering Services 16,328 18,688 12,000 6,541 13,000 15,000 25.00% 101-410-1910-43150 Contract Services 25,467 25,133 113,500 5,826 10,000 10,000 -91.19% 101-410-1910-43190 Software Programs - - - 407 500 100 #DIV/0! 101-410-1910-43210 Telephone 761 775 1,020 546 1,000 1,100 7.84% 101-410-1910-43220 Postage 35 6 150 59 - 25 -83.33% 101-410-1910-43310 Mileage 95 342 150 103 300 300 100.00% 101-410-1910-43510 Legal Publishing - - - 840 1,000 500 #DIV/0! 101-410-1910-44330 Dues & Subscriptions 120 617 390 - 1,000 1,115 185.90% 101-410-1910-44350 Books - - 175 - - - -100.00% 101-410-1910-44370 Conferences & Training 555 1,520 1,560 375 1,500 2,500 60.26% Total Charges and Services 43,361$ 47,081$ 128,945$ 41,227$ 82,300$ 66,640$ -48.32% Miscellaneous 101-410-1910-44300 Miscellaneous 31 31 300 10 200 200 -33.33% Total Miscellaneous 31$ 31$ 300$ 10$ 200$ 200$ -33.33% 1910 Total Planning & Zoning 231,199$ 243,027$ 325,504$ 208,612$ 289,803$ 271,570$ -16.57% 1930 Engineering Services Charges and Services 101-410-1930-43030 Engineering Services 32,942 34,034 36,000 18,097 34,500 36,000 0.00% 101-410-1930-43210 Telephone 204 195 - 107 200 216 #DIV/0! Total Charges and Services 33,146$ 34,229$ 36,000$ 18,204$ 34,700$ 36,216$ 0.60% 1930 Total Engineering Services 33,146$ 34,229$ 36,000$ 18,204$ 34,700$ 36,216$ 0.60% 1940 City Hall Materials and Supplies 101-410-1940-42110 Cleaning Supplies - - 50 - -100.00% 101-410-1940-42230 Building Repair Supplies 478 4 300 550 750 800 166.67% Total Materials and Supplies 478$ 4$ 350$ 550$ 750$ 800$ 128.57% Charges and Services 101-410-1940-43180 Information Technology/Web - - - 185 370 389 #DIV/0! 101-410-1940-43210 Telephone 772 614 900 438 900 900 0.00% 101-410-1940-43810 Utilities 6,968 3,851 6,500 2,583 6,500 6,500 0.00% 101-410-1940-43840 Refuse 1,490 1,129 1,355 1,074 1,500 1,325 -2.21% 101-410-1940-44010 Repairs/Maint Contractual Bldg 9,139 21,350 6,000 6,683 7,000 6,000 0.00% 101-410-1940-44040 Repairs/Maint Contractual Eqpt 10,820 11,365 15,540 8,978 14,000 18,000 15.83% 101-410-1940-44120 Rentals - Building 29,532 30,147 31,992 26,660 31,992 33,223 3.85% Total Charges and Services 58,721$ 68,457$ 62,287$ 46,601$ 62,262$ 66,337$ 6.50% Miscellaneous 101-410-1940-44300 Miscellaneous 1,802 1,981 1,016 501 1,016 1,016 0.00% Total Miscellaneous 1,802$ 1,981$ 1,016$ 501$ 1,016$ 1,016$ 0.00% 1940 Total City Hall 61,000$ 70,442$ 63,653$ 47,652$ 64,028$ 68,153$ 7.07% 2100 Police CITY OF LAKE ELMO 2018 PROPOSED BUDGET General Fund - December 5, 2017 6 Adopted 2017 to 2015 2016 2017 2017 2017 2018 Proposed 2018 Account Number Description Actual Actual Adopted YTD - Sept. 30 Projected Proposed Percent Change Charges and Services 101-420-2100-43150 Law Enforcement Contract 527,462 536,330 618,357 290,876 618,357 664,675 7.49% 101-420-2100-44300 Misc. - Community Event - - 1,000 1,800 1,800 1,000 0.00% Total Charges and Services 527,462$ 536,330$ 619,357$ 292,676$ 620,157$ 665,675$ 7.48% 2100 Total Police 527,462$ 536,330$ 619,357$ 292,676$ 620,157$ 665,675$ 7.48% 2150 Prosecution Charges and Services 101-420-2150-43045 Attorney Criminal 55,710 44,144 43,200 25,169 43,200 44,996 4.16% Total Charges and Services 55,710$ 44,144$ 43,200$ 25,169$ 43,200$ 44,996$ 4.16% 2150 Total Prosecution 55,710$ 44,144$ 43,200$ 25,169$ 43,200$ 44,996$ 4.16% 2220 Fire Personnel 101-420-2220-41010 Full-time Salaries 70,680 71,918 72,970 59,802 82,597 85,515 17.19% 101-420-2220-41030 Part-time Salaries 105,487 96,663 97,724 67,638 129,502 228,179 133.49% 101-420-2220-41210 PERA Contributions 14,829 14,699 11,821 12,463 23,020 39,180 231.44% 101-420-2220-41220 FICA Contributions 5,681 6,038 6,059 4,194 4,340 4,340 -28.37% 101-420-2220-41230 Medicare Contributions 2,532 2,364 2,475 1,780 2,400 1,015 -58.99% 101-420-2220-41300 Insurance 14,275 13,673 14,993 12,336 16,448 17,093 14.01% 101-420-2220-41510 Workers Compensation 20,966 12,879 15,000 16,687 17,219 26,481 76.54% Total Personnel 234,449$ 218,234$ 221,042$ 174,900$ 275,526$ 401,803$ 81.78% Materials and Supplies 101-420-2220-42000 Office Supplies 1,373 1,444 1,850 1,298 1,500 500 -72.97% 101-420-2220-42080 EMS Supplies 453 888 5,800 3,819 5,800 1,200 -79.31% 101-420-2220-42090 Fire Prevention 142 722 3,000 - 3,000 3,000 0.00% 101-420-2220-42120 Fuel, Oil and Fluids 10,015 7,644 11,000 4,748 7,500 8,000 -27.27% 101-420-2220-42400 Small Tools & Equipment 20,734 10,539 11,700 5,942 11,700 22,675 93.80% Total Materials and Supplies 32,717$ 21,237$ 33,350$ 15,807$ 29,500$ 35,375$ 6.07% Charges and Services 101-420-2220-43050 Physicals 5,199 4,221 2,400 3,180 4,300 8,075 236.46% 101-420-2220-43210 Telephone 4,316 3,682 4,200 2,868 4,200 4,200 0.00% 101-420-2220-43230 Radio 20,446 18,917 22,018 12,625 22,018 21,616 -1.83% 101-420-2220-43310 Mileage 578 814 500 - 500 500 0.00% 101-420-2220-43630 Insurance 5,469 7,290 8,300 7,571 8,300 8,549 3.00% 101-420-2220-43810 Utility 14,161 9,520 15,500 9,996 15,500 15,500 0.00% 101-420-2220-43840 Refuse 3,455 2,948 2,400 2,531 3,200 3,200 33.33% 101-420-2220-44010 Repairs/Maint Bldg 5,960 17,938 7,800 7,519 7,800 7,000 -10.26% 101-420-2220-44040 Repairs/Maint Eqpt 25,224 41,975 22,967 35,543 37,000 25,896 12.75% 101-420-2220-44170 Uniforms 1,862 5,255 2,500 3,750 4,000 9,821 292.84% 101-420-2220-44330 Dues & Subscriptions 3,303 3,275 3,733 2,955 3,500 3,955 5.95% 101-420-2220-44350 Books - 230 220 180 280 440 100.00% 101-420-2220-44370 Conferences & Training 8,775 17,663 19,891 10,504 16,000 22,514 13.19% Total Charges and Services 98,750$ 133,727$ 112,429$ 99,223$ 126,598$ 131,266$ 16.75% Capital Outlay 101-420-2220-45500 Vehicle - - - 64 64 - #DIV/0! Total Capital Outlay -$ -$ -$ 64$ 64$ -$ #DIV/0! Miscellaneous 101-420-2220-44300 Miscellaneous 2,721 2,290 2,000 1,125 2,000 2,000 0.00% CITY OF LAKE ELMO 2018 PROPOSED BUDGET General Fund - December 5, 2017 7 Adopted 2017 to 2015 2016 2017 2017 2017 2018 Proposed 2018 Account Number Description Actual Actual Adopted YTD - Sept. 30 Projected Proposed Percent Change Total Miscellaneous 2,721$ 2,290$ 2,000$ 1,125$ 2,000$ 2,000$ 0.00% 2220 Total Fire 368,637$ 375,488$ 368,821$ 291,118$ 433,688$ 570,444$ 54.67% 2250 Fire Relief Charges and Services 101-420-2250-44920 Fire State Aid 58,166 59,136 47,000 - 47,000 47,000 0.00% Total Charges and Services 58,166$ 59,136$ 47,000$ -$ 47,000$ 47,000$ 0.00% 2250 Total Fire Relief 58,166$ 59,136$ 47,000$ -$ 47,000$ 47,000$ 0.00% 2400 Building Inspection Personnel 101-420-2400-41010 Full-time Salaries 99,174 167,498 232,801 199,023 265,364 272,754 17.16% 101-420-2400-41210 PERA Contributions 7,250 12,102 15,132 14,927 19,902 20,457 35.19% 101-420-2400-41220 FICA Contributions 5,834 10,062 14,434 12,340 16,453 16,911 17.16% 101-420-2400-41230 Medicare Contributions 1,365 2,353 3,376 2,886 3,848 3,955 17.15% 101-420-2400-41300 Insurance 18,264 24,554 42,432 40,555 54,074 53,002 24.91% 101-420-2400-41510 Workers Compensation 2,828 1,260 4,800 794 2,091 2,149 -55.23% Total Personnel 134,714$ 217,830$ 312,975$ 270,525$ 361,732$ 369,228$ 17.97% Materials and Supplies 101-420-2400-42000 Office Supplies 690 1,602 1,750 1,641 1,750 1,750 0.00% 101-420-2400-42030 Printed Forms 154 - 350 - 350 350 0.00% 101-420-2400-42120 Fuel, Oil and Fluids 1,014 521 3,600 2,086 3,000 3,600 0.00% Total Materials and Supplies 1,858$ 2,122$ 5,700$ 3,727$ 5,100$ 5,700$ 0.00% Charges and Services 101-420-2400-43030 Engineering 6,289 2,465 6,000 248 1,500 1,000 -83.33% 101-420-2400-43180 Information Technology/Web 3,875 6,010 - 5,674 8,500 7,405 #DIV/0! 101-420-2400-43210 Telephone 758 1,912 1,800 1,911 2,100 2,500 38.89% 101-420-2400-43630 Insurance 136 178 400 185 400 400 0.00% 101-420-2400-44040 Repairs/Maint Eqpt 1,253 965 1,000 786 1,000 1,000 0.00% 101-420-2400-44170 Uniforms 241 80 1,200 684 1,200 1,200 0.00% 101-420-2400-44330 Dues & Subscriptions 385 185 740 310 740 740 0.00% 101-420-2400-44350 Books 1,692 870 500 345 500 500 0.00% 101-420-2400-44370 Conferences & Training 1,095 2,596 4,825 870 3,500 4,825 0.00% Total Charges and Services 15,726$ 15,261$ 16,465$ 11,013$ 19,440$ 19,570$ 18.86% Capital Outlay 101-420-2400-45500 Vehicle - - - - - 24,000 #DIV/0! Total Capital Outlay -$ -$ -$ -$ -$ 24,000$ #DIV/0! Miscellaneous 101-420-2400-44300 Miscellaneous 1,564 266 845 3,793 3,900 1,000 18.34% Total Miscellaneous 1,564$ 266$ 845$ 3,793$ 3,900$ 1,000$ 18.34% 2400 Total Building Inspection 153,862$ 235,479$ 335,985$ 289,057$ 390,172$ 419,498$ 24.86% 2500 Emergency Communications Charges and Services 101-420-2500-43150 Contract Services 3,745 4,945 5,395 900 5,395 1,780 -67.01% Total Charges and Services 3,745$ 4,945$ 5,395$ 900$ 5,395$ 1,780$ -67.01% CITY OF LAKE ELMO 2018 PROPOSED BUDGET General Fund - December 5, 2017 8 Adopted 2017 to 2015 2016 2017 2017 2017 2018 Proposed 2018 Account Number Description Actual Actual Adopted YTD - Sept. 30 Projected Proposed Percent Change 2500 Total Emergency Communications 3,745$ 4,945$ 5,395$ 900$ 5,395$ 1,780$ -67.01% 2700 Animal Control Charges and Services 101-420-2700-43150 Contract Services 5,725 3,086 7,725 6,112 7,725 7,725 0.00% Total Charges and Services 5,725$ 3,086$ 7,725$ 6,112$ 7,725$ 7,725$ 0.00% 2700 Total Animal Control 5,725$ 3,086$ 7,725$ 6,112$ 7,725$ 7,725$ 0.00% 3100 Public Works Personnel 101-430-3100-41010 Full-time Salaries 134,875 253,303 238,857 218,227 299,044 325,079 36.10% 101-430-3100-41030 Part-time Salaries 2,429 - 9,680 3,395 7,200 9,360 -3.31% 101-430-3100-41210 PERA Contributions 10,351 18,494 18,640 16,232 22,303 24,081 29.19% 101-430-3100-41220 FICA Contributions 8,081 15,066 13,312 13,381 18,987 20,735 55.76% 101-430-3100-41230 Medicare Contributions 1,890 3,524 3,604 3,130 4,441 4,849 34.54% 101-430-3100-41300 Insurance 36,238 44,655 42,141 47,064 62,752 62,796 49.01% 101-430-3100-41510 Workers Compensation 19,017 12,028 14,000 14,990 18,455 19,749 41.06% 101-430-3100-41600 Safety Clothing Allowance - - - - 971 971 #DIV/0! Total Personnel 212,880$ 347,071$ 340,234$ 316,419$ 434,153$ 467,620$ 37.44% Materials and Supplies 101-430-3100-42000 Office Supplies 350 1,666 2,000 598 2,000 800 -60.00% 101-430-3100-42120 Fuel, Oil and Fluids 26,146 24,049 30,000 20,296 27,000 28,500 -5.00% 101-430-3100-42150 Operating Supplies 2,151 2,431 3,000 2,017 2,800 2,000 -33.33% 101-430-3100-42210 Repair/Maint. Supplies 6,308 3,964 10,350 6,980 9,000 12,750 23.19% 101-430-3100-42240 Street Maintenance & Landscaping - Materials 20,203 16,112 445,000 - 20,000 20,000 -95.51% 101-430-3100-42250 Street Maintenance 185,950 258,223 - 219,004 425,000 425,000 #DIV/0! 101-430-3100-42260 Street Signs 378 2,389 3,000 3,404 3,500 5,000 66.67% 101-430-3100-42290 Sand/Salt 73,780 49,616 65,000 74,202 74,202 75,000 15.38% 101-430-3100-42400 Small Tools & Minor Equipment 5,634 2,788 3,000 3,633 3,800 8,000 166.67% 101-430-3100-44375 Personal Protection Equipment - 1,465 2,400 1,498 2,000 2,800 16.67% Total Materials and Supplies 320,900$ 362,703$ 563,750$ 331,632$ 569,302$ 579,850$ 2.86% Charges and Services 101-430-3100-43030 Engineering Services 10,384 4,676 4,800 1,886 2,500 4,800 0.00% 101-430-3100-43150 Contract Services 20,098 24,156 24,350 16,584 22,000 24,500 0.62% 101-430-3100-43210 Telephone 7,344 7,347 7,800 4,942 6,800 7,800 0.00% 101-430-3100-43230 Radio 1,236 1,236 1,300 600 1,300 24,000 1746.15% 101-430-3100-43630 Insurance 11,914 15,105 17,000 15,688 17,000 19,000 11.76% 101-430-3100-43810 Utilities 46,717 34,935 54,400 38,367 54,400 52,000 -4.41% 101-430-3100-43840 Refuse 2,811 2,407 2,625 1,395 2,800 3,000 14.29% 101-430-3100-44010 Repairs/Maint Bldg.5,604 10,996 4,000 8,143 10,000 21,000 425.00% 101-430-3100-44030 Repairs/Maint Imp Other Than Bldg.590 165 500 1,203 1,500 1,500 200.00% 101-430-3100-44040 Repairs/Maint Equip 27,514 25,364 20,900 9,369 26,000 34,000 62.68% 101-430-3100-44130 Equipment Rental - - - - - 2,000 #DIV/0! 101-430-3100-44170 Uniforms 3,095 5,886 5,000 4,925 6,500 7,500 50.00% 101-430-3100-44330 Dues & Subscriptions 275 294 600 498 750 600 0.00% 101-430-3100-44370 Conferences & Training 3,187 3,889 4,800 2,092 4,000 4,800 0.00% 101-430-3100-44380 Clean-up Days 5,564 9,557 10,212 14,256 14,256 - -100.00% Total Charges and Services 146,332$ 146,012$ 158,287$ 119,948$ 169,806$ 206,500$ 30.46% Capital Outlay 101-430-3100-45500 Capital Purchases - - - - - 145,000 #DIV/0! Total Capital Outlay -$ -$ -$ -$ -$ 145,000$ #DIV/0! CITY OF LAKE ELMO 2018 PROPOSED BUDGET General Fund - December 5, 2017 9 Adopted 2017 to 2015 2016 2017 2017 2017 2018 Proposed 2018 Account Number Description Actual Actual Adopted YTD - Sept. 30 Projected Proposed Percent Change Miscellaneous 101-430-3100-44300 Miscellaneous 2,534 762 1,450 631 1,200 1,800 24.14% Total Miscellaneous 2,534$ 762$ 1,450$ 631$ 1,200$ 1,800$ 24.14% 3100 Total Public Works 682,647$ 856,548$ 1,063,721$ 768,630$ 1,174,461$ 1,400,770$ 31.69% 5200 Parks & Recreation Personnel 101-450-5200-41010 Full-time Salaries 129,189 70,421 77,429 43,048 63,533 99,036 27.91% 101-450-5200-41030 Part-time Salaries 21,629 30,934 48,000 20,969 25,000 28,080 -41.50% 101-450-5200-41210 PERA Contributions 9,666 5,798 6,162 3,351 4,571 7,428 20.55% 101-450-5200-41220 FICA Contributions 8,964 6,027 7,777 3,835 6,794 7,857 1.03% 101-450-5200-41230 Medicare Contributions 2,096 1,410 1,819 897 1,595 1,843 1.32% 101-450-5200-41300 Insurance 18,135 18,232 19,992 16,197 21,596 18,481 -7.56% 101-450-5200-41510 Workers Compensation 5,391 3,735 4,000 3,956 5,018 7,419 85.48% 101-450-5200-41600 Safety Clothing Allowance - - - - 236 236 #DIV/0! Total Personnel 195,071$ 136,556$ 165,179$ 92,253$ 128,343$ 170,380$ 3.15% Materials and Supplies 101-450-5200-42000 Office Supplies 172 60 900 304 800 800 -11.11% 101-450-5200-42150 Operating Supplies 1,575 1,338 - 140 1,000 1,000 #DIV/0! 101-450-5200-42160 Chemicals 679 1,057 1,500 576 800 2,000 33.33% 101-450-5200-42210 Repair/Maint. Supplies 4,156 4,505 6,000 3,654 6,000 7,000 16.67% 101-450-5200-42230 Building Repair Supplies 140 619 500 100 500 500 0.00% 101-450-5200-42400 Small Tools & Minor Equipment 2,753 2,365 2,150 2,415 2,500 2,500 16.28% Total Materials and Supplies 9,475$ 9,944$ 11,050$ 7,188$ 11,600$ 13,800$ 24.89% Charges and Services 101-450-5200-43150 Contract Services - - - 600 1,000 13,000 #DIV/0! 101-450-5200-43210 Telephone 1,283 1,358 1,200 720 1,000 1,200 0.00% 101-450-5200-43630 Insurance 2,301 3,079 3,800 3,198 4,500 5,000 31.58% 101-450-5200-43810 Utilities 8,935 6,446 9,600 6,338 9,000 10,500 9.38% 101-450-5200-43840 Refuse - 20 1,000 1,106 1,200 1,000 0.00% 101-450-5200-44010 Repairs/Maint Bldg 1,294 63 1,800 130 750 2,800 55.56% 101-450-5200-44030 Repairs/Maint Imp Not Bldgs 3,114 2,959 3,000 6,281 8,000 3,200 6.67% 101-450-5200-44040 Repairs/Maint Eqpt 804 2,235 1,500 184 1,000 3,200 113.33% 101-450-5200-44120 Rentals - Buildings 7,232 6,476 6,000 4,384 5,900 7,000 16.67% 101-450-5200-44130 Equipment Rental - - - - - 1,000 #DIV/0! 101-450-5200-44170 Uniforms 136 67 - 58 100 100 #DIV/0! 101-450-5200-44301 Events - - 5,000 450 2,500 500 -90.00% 101-450-5200-44302 Lakes - - 40,000 4,578 10,000 15,000 -62.50% 101-450-5200-44370 Conferences & Training - - - - - 1,200 #DIV/0! 101-450-5200-44375 Personal Protection Equipment - 341 1,200 1,209 1,300 800 -33.33% Total Charges and Services 25,099$ 23,044$ 74,100$ 29,236$ 46,250$ 65,500$ -11.61% Capital Outlay 101-450-5200-45500 Vehicles - - - - - 25,000 #DIV/0! Total Capital Outlay -$ -$ -$ -$ -$ 25,000$ #DIV/0! Miscellaneous 101-450-5200-44300 Miscellaneous 889 521 1,200 266 800 1,200 0.00% Total Miscellaneous 889$ 521$ 1,200$ 266$ 800$ 1,200$ 0.00% 5200 Total Parks & Recreation 230,533$ 170,065$ 251,529$ 128,943$ 186,993$ 275,880$ 9.68% CITY OF LAKE ELMO 2018 PROPOSED BUDGET General Fund - December 5, 2017 10 Adopted 2017 to 2015 2016 2017 2017 2017 2018 Proposed 2018 Account Number Description Actual Actual Adopted YTD - Sept. 30 Projected Proposed Percent Change 9000 Compensation Adjustment Personnel 101-460-9000-41010 Compensation Adjustment - - 35,000 - - - -100.00% Total Personnel -$ -$ 35,000$ -$ -$ -$ -100.00% 9000 Total Compensation Adjustment -$ -$ 35,000$ -$ -$ -$ -100.00% Total General Fund Expenditures:3,161,952$ 3,575,683$ 3,951,386$ 2,738,139$ 4,192,136$ 4,670,734$ 18.20% Total Gen Fund Revs. Over/(Under) Expenditures:485,035$ 800,672$ -$ 295,336$ (0)$ (0)$ #DIV/0!