The URL can be used to link to this page

Home My WebLink About2024 Budget & Levy STAFF REPORT DATE: December 5, 2023 TO: Mayor & Council FROM: Clarissa Hadler, Finance Director AGENDA ITEM: 2024 Budget Information – General, Debt Service, and Enterprise Funds & Tax Levy REVIEWED BY: Kristina Handt, City Administrator BACKGROUND: In preparation for adoption of the final tax levy, the City Council needs to hold a Truth-N-Taxation hearing. Following the hearing, the Council is asked to adopt the final budgets and property tax levy. ISSUE BEFORE COUNCIL: 1. What changes, if any, should be made to the draft budget? 2. What Final Property Tax Levy would the City Council like to set for certification to Washington County for Payable 2024? At the September 19th Council meeting, Council adopted a preliminary levy of $ 8,922,042, which would result in a slight increase over the 2023 tax rate equal to 2% of the current rate; from 24.064% to 24.547%. Tax Impacts are discussed further on page 4 of this report. Since the September meeting, the city has received the non-union employee insurance renewal rates for 2024. Rates saw a slight decrease for 2024. The budget has been updated to reflect the actual changes in benefits. The savings seen over the projected insurance rates were reallocated to the Vehicle Fund Transfer to maintain the Levy and rate as set at the September 19 meeting. LONG-TERM PLANNING: Staff has updated the Long-Term Financial Management Plan to reflect projected expenditure levels and account for the updated 10-year CIP. There were two strategies set in previous council discussions that staff was attempting to hold true in updating that plan; • Maintain a minimum $200,000 transfer to the Vehicle Fund each year. This amount does not fully fund Vehicle Acquisition & Replacement and should be supplemented with additional dollars as available. • Maintain a 2% increase in the tax rate each year. Under current budget and development assumptions, the city may be unable to maintain the 2% increase for the years 2025 and 2026 without the use of cash reserves. Current estimates indicate the next 2 years will see tax rate increases closer to 5% over the prior year rate. However, these projections are subject to numerous variables, including the pace of development, actual budgets, property valuations, fiscal disparity distributions, etc. Staff will continue to update these plans as more information becomes available. OPERATING BUDGETS: Attachment #1 includes the entire General Fund Budget. Below are a number of points that provide brief context for changes within department budgets. Salary and Benefits The 2024 preliminary budget is currently being prepared with assumptions of moving staff to the next step of the pay plan on January 1, 2024, including a proposed 3% COLA increase. For new or vacant positions, they are budgeted at the midpoint of the range. While medical benefits are budgeted to increase by 14%, they will actually decrease slightly. General Fund Revenue is expected to decrease from the 2023 Budget in Licenses and Permits and Charges for Services due to effects of a changing housing market. We are currently projecting 250 new homes, with a larger percentage of those being townhomes, which bring lower permit fees. Total taxes for the operating budget are planned to increase by 17%. That increase will be covered largely by the increase in total tax capacity caused by new development and increased property values, with an increase to the tax rate of 2% over 2023; from 24.064% to 24.547%. Overall, general government expense budgets are proposed to increase due to continued staffing changes (new/reclassified positions, class and comp implementation 1/1/23, etc.), the added costs of the new City Center facility, and increasing costs such as insurance and IT expenses as the city and the organization continues to grow. To continue to simplify the city’s chart of accounts, we are closing two budgetary “departments”; communications and city hall. The communications expenses will be incorporated into the administration department. City Center expenses will be allocated to city departments based largely on a formula calculated using square footage of those departments within the building. City Center expenses will also be increasing due to the additional space compared to the old city hall. The city council budget will increase by 10% due largely to proposed additional conference attendance and tentative increases in LMC dues. The Administrator is encouraging Council to attend the LMC Conference in Rochester in 2024. The administration department increases are due to the aforementioned combination of departments. The overall “Admin plus Communications” budget will decrease by over 5%. The elections department will increase due to the presidential election in 2024. The finance department increase is due to full implementation of the staffing model, added training and IT expenses for new positions. The planning and zoning department increases are due to full implementation of the staffing model recommended in the department audit of 2021 and increasing costs for landscape architect services. The sheriff’s contract budget is increasing as they are recommending an additional deputy starting in 2024. The fire department is increasing due to paid-on-call salaries related to scheduled duty crew staffing and department training. A clerical error inadvertently kept some other payroll expenses low in 23 when full- time fire fighters were added. Property insurance costs have increased due to the increased value of newer apparatus. Due to the amount of space they have in the City Center, the fire department takes a relatively large portion of those new expenses. IT replacement costs are higher than in 2023. The building inspections department is increasing due in part to some additional allocations of other departments’ staff time, as well as new proposed software and tablets for web-based applications and on-site inspections. Public works is comprised of Streets (General Fund), Parks (General Fund), Water, Sewer and Storm Water. Staff time, and many expenses, are allocated across those functions. The streets department 2024 budget is holding steady with just a 1% increase. The Sealcoating & Crack Sealing budget will be removed to a new Street Maintenance Fund, so the amount that was budgeted as a Charges & Services expense will now be reflected as a Transfer to that fund. Parks & Recreation will increase nominally in part to a change in allocation of insurance. There is an additional transfer of $167,328 to the vehicle replacement fund in order to address the anticipated deficit in the fund in 2027. This amount was increased since the Sept 19 meeting utilizing the savings from health insurance premiums. This transfer is in addition to the $200,000 proposed from the building, fire, streets and parks departments. Details regarding Capital expenses and Transfers can be found in the 2024-2033 Draft CIP. Summary of Expenditure Changes by Department 2023 Budget 2024 Budget % Change 1110 Mayor & Council 59,960 66,121 10% 1320 Administration 620,040 660,504 7% 1410 Elections 3,200 16,658 421% 1450 Communications 81,098 - -100% 1520 Finance 266,403 280,813 5% 1910 Planning & Zoning 404,476 473,189 17% 1930 Engineering Services 35,000 35,000 0% 1940 City Hall 66,819 - -100% 2100 Police 1,049,784 1,310,573 25% 2150 Prosecution 50,000 50,000 0% 2220 Fire 1,540,881 1,642,953 7% 2250 Fire Relief 80,000 - -100% 2400 Building Inspection 932,259 1,114,889 20% 2500 Emergency Communications 4,500 4,500 0% 2700 Animal Control 13,000 14,500 12% 3100 Streets 1,797,064 1,812,018 1% 5200 Parks & Recreation 431,038 455,204 6% 9000 Transfers 250,000 167,328 -33% 9001 Contingency Reserve 35,000 35,000 0% 7,720,521 8,139,250 5.42% Summary of Changes by General Fund Category and Function Changes by Category 2023 Budget 2024 Proposed $ Change % Change Personnel 3,432,290 3,861,290 429,000 14% Materials & Supplies 322,830 328,093 5,263 2% Charges & Services 3,181,813 2,832,186 (349,627) -11% Capital Outlay 230,000 101,500 (128,500) -56% Miscellaneous 93,588 13,853 (79,735) -85% Transfers 425,000 967,328 542,328 112% Contingency Reserve 35,000 35,000 - 0% TOTAL 7,720,521 8,139,250 418,728 5.42% The large increase in Transfers is due to the new Transfer to Street Maintenance Fund, which correlates to a decrease in Charges & Services. Miscellaneous decreased due to reallocation of city hall and building dept. expenses. Capital Outlay is a Category that varies significantly year-to-year as we make larger purchases and pay for projects out of the General Fund. Personnel expenses continue to increase as we move toward full staffing according to recent organizational studies and developing our public safety departments to meet the needs of a growing community. Changes by Function 2023 Budget 2024 Proposed $ Change % Change General Government 1,536,996 1,532,285 (4,711) 0% Public Safety 3,383,405 3,966,202 582,796 17% Public Works 1,681,381 1,084,960 (596,420) -35% Culture & Recreation 428,739 451,975 23,236 5% Capital Outlay 230,000 101,500 (128,500) -56% Transfers 425,000 967,328 542,328 128% Contingency Reserve 35,000 35,000 - 0% TOTAL 7,720,521 8,139,250 418,729 5.42% Debt Service The total tax levy is comprised of the General Fund Levy as well as the Debt Levy. The city issued new debt in 2023 which we will begin paying on in 2024. The 2024 levies necessary to pay for existing debt are as follows: 2023 2024 Change % Change 2010B 206,656 205,884 -772 2014A 200,091 103,597 -96,494 2016A 193,409 187,529 -5,880 2017A 342,660 340,954 -1,706 2018A 123,569 125,984 2,415 2019A 297,138 298,661 1,523 2021A 1,025,930 1,025,510 -420 2022A 287,685 283,998 -3,687 2023A 0 351,713 351,713 Total 2,677,138 2,923,830 246,692 9.21% Despite some decreases in existing debt payments, the addition of the 2023A bond will cause the overall increase in the debt service levy to be 9.21%. Tax Impact The total tax capacity for Lake Elmo increased by $4,197,258 or 13.14%. Fiscal Disparities decreased by $43,168. In order to remain within the 2% rate increase per the long-term financial management plan, the city would levy a total of $ 8,922,042, including General Fund and Debt Service levies. This would be an increase of $1,123,639 over 2023, or 14.4%; due largely to capturing the increased tax capacity caused by new development and increased property values. 2023 2024 General Fund Levy 5,121,265 5,998,212 Debt Service Levy 2,677,138 2,923,830 TOTAL LEVY $ 7,798,403 $ 8,922,042 In the attached Tax Impact Worksheet, the County utilizes a comparison that calculates the median increase in home value. The median increase of residential values was 3.9%. If you had a median value home worth $554,500 and it increased in value by 3.9%, your tax would increase by approximately $94. 2023 2024 Home Value $ 554,400 (MVH) $ 576,022 (3.9% incr.) Tax Rate City Taxes Due 24.064% (2023) $ 1,367 $ 1,432 24.545% (proposed 2024) $ 1,394 $ 1,461 $ 94 increase Lake Elmo remains in the bottom half for tax rate compared to other Washington County communities for tax rates set in 2023. Rank Taxing Authority 2023 (%) Rank Taxing Authority 2023 (%) 1 Landfall 58.843 18 Scandia 26.46 2 Hastings 53.267 19 Lakeland 26.189 3 Newport 49.69 20 Lake Elmo 24.064 4 Stillwater 49.39 21 White Bear Lake 24.054 5 Oak Park Heights 48.985 22 Birchwood 21.27 6 Willernie 46.245 23 Lakeland Shores 20.742 7 Marine on St. Croix 42.75 24 St. Mary's Point 18.287 8 Oakdale 38.217 25 Stillwater Township 17.56 9 St. Paul Park 36.93 26 Dellwood 15.72 10 Hugo 36.371 27 Grey Cloud Island 14.81 11 Forest Lake 34.45 28 Baytown Township 14.29 12 Mahtomedi 34.41 29 Denmark Township 11.68 13 Cottage Grove 33.898 30 West Lakeland Twp 11.44 14 Lake St. Croix Beach 31.126 31 Grant 11.054 15 Bayport 28.964 32 May Township 9.82 16 Woodbury 28.599 33 Pine Springs 7.484 17 Afton 27.111 Utility Funds The Utility Fund Budgets (Water, Sanitary Sewer, and Storm Sewer) have been updated with sales and expense projections from the Utility Rate Study recently completed by Northland. Changes by Category 2023 Budget 2024 Proposed $ Change % Change Personnel 851,018 873,331 22,314 3% Materials & Supplies 287,843 281,550 (6,293) -2% Charges & Services 1,212,370 1,442,216 229,847 19% Capital Outlay 1,375,880 5,694,977 4,319,097 314% Miscellaneous 3,086,920 3,195,770 108,850 4% TOTAL 6,814,030 11,487,845 4,673,815 69% Changes by Function 2023 Budget 2024 Proposed $ Change % Change Water 3,791,452 7,451,932 3,660,480 97% Sanitary Sewer 2,519,848 2,721,910 202,062 8% Stormwater 502,730 1,314,003 811,273 161% TOTAL 6,814,030 11,487,845 4,673,815 69% The significant increase in the water and stormwater funds are due to the scheduled capital projects. Excluding Capital Outlay the Utility Funds as a whole would have an overall increase of 7%. Beyond Capital expenses, the much of the projected increases overall fall in the Charges & Services category; including Met Council sewer fees due to new connections, insurance, and utilities. NEW STATE LAWS: Minnesota Laws 2023, Regular Session, Chapter 64 included the following changes to Minn. Stat. § 275.065 regarding Truth in Taxation notices; • Notice of proposed property taxes. Article 3, section 22 amends Minn. Stat. § 275.065, subd. 3, by requiring that the notice of proposed truth in taxation statement include the website of each local jurisdiction listed on the statement. If a jurisdiction does not have a website, this information is not required. Effective beginning with taxes levied in 2023 for property taxes payable in 2024. • Notice of proposed property taxes required supplemental information. Article 3, section 23 amends Minn. Stat. § 275.065, subd. 3b by modifying the contents of the supplemental information included in the truth in taxation statement. This section removes the parcel budget information and the governmental revenues categories from the statement and require it only include the levy change for the county, each city in the county, and each school district in the county. Effective beginning with taxes levied in 2023 for property taxes payable in 2024. • Costs. Article 3, section 24 amends Minn. Stat. § 275.065, subd. 4 by allowing counties the option to require local jurisdictions to reimburse the county for costs related to preparing and mailing the proposed property tax statement that are not reimbursed by the Department of Revenue if the county chooses to do so. Under current law, local jurisdictions must reimburse the county for these costs. Effective beginning with taxes levied in 2023 for property taxes payable in 2024. OPTIONS: 1) Adopt Resolution 2023-123 Approving the 2024 Property Tax Levy and 2024 General Fund Budget. 2) Adopt Resolution 2023-124, Adopting the 2024 Water, Sewer and Storm Water Fund Budgets 3) Amend and then adopt either Resolution. 4) Do not adopt budget resolutions. RECOMMENDATION: Hold Public Hearing. AND “Motion to approve Resolution 2023-123 Approving the 2024 General Fund Budget, 2024 Property Tax Levy” AND “Motion to approve Resolution 2023-124 Approving the 2024 Utility Budgets” ATTACHMENTS 1) 2024 General Fund Budget 2) 2024 Utility Fund Budgets 3) Long-Term Financial Management Plan 4) Tax Impact Work Sheet from Washington County 5) Resolution 2023-123 Approving the Approving the 2024 General Fund Budget and 2024 Property Tax Levy 6) Resolution 2023-124 Approving the 2024 Utility Budgets Proposed Pay 2024 Property Tax Impact Worksheet Taxing District: STEP 1 - Calculate the Taxing District's Tax Rate: Actual Proposed % Item Pay 2023 Pay 2024 Change (A)(B)(C) 1.Levy before reduction for state aids $7,798,403 $8,922,042 14.4% 2.State Aids - $0 $0 0.0% 3.Certified Property Tax Levy = $7,798,403 $8,922,042 14.409% 4.Fiscal Disparity Portion of Levy - $433,046 $389,878 -10.0% 5.Local Portion of Levy = $7,365,357 $8,532,164 15.8% 6.Local Taxable Value 2024 is an ESTIMATE ÷ 30,606,781 $34,758,875 13.6% 7.Local Tax Rate = 24.064%24.547%2.0% 8.Market Value Referenda Levy $0 $0 0.0% 9.Fiscal Disparity Portion of Levy (SD only)- $0 $0 0.0% 10.Local Portion of Levy = $0 $0 0.0% 11.Referenda Market Value 2024 is an ESTIMATE ÷ 0 0 0.0% 12.Market Value Referenda Rate = 0.00000%0.00000%0.0% STEP 2 - Calculate the Impact of the Taxing District's Rate on Residential Homestead Taxes: 13.Assumes a 3.9%change in market value from 2023 to 2024, which is the city median change. (D)(E)(F)(G)(H) Market Homestead Taxing Value Market Taxable District Before Value Market Tax Portion of Exclusion Exclusion Value Capacity Tax Actual Pay 2023 Pay 2023 76,000 @40%500,000@1.0%(A7 x G) + MV - rem @ 9%(D) - (E)rem @ 1.25%(A12 X D) 14.554,400 0 554,400 5,680 $1,366.86 15.240,600 15,600 225,000 2,250 $541.45 16.288,700 11,300 277,400 2,774 $667.55 17.336,900 6,900 330,000 3,300 $794.13 18.385,000 2,600 382,400 3,824 $920.23 Proposed Pay 2024 Pay 2024 MV 76,000 @40%500,000@1.0%(B7 x G) + X 1.039 - rem @ 9%(D) - (E)rem @ 1.25%(B12 x D) 19.576,000 0 576,000 5,950 $1,460.55 20.250,000 14,700 235,300 2,353 $577.59 21.300,000 10,200 289,800 2,898 $711.37 22.350,000 5,700 344,300 3,443 $845.15 23.400,000 1,200 398,800 3,988 $978.93 Percentage Change from 2023 to 2024 24.3.9%0.0%3.9%4.8%6.9% 25.3.9%-5.8%4.6%4.6%6.7% 26.3.9%-9.7%4.5%4.5%6.6% 27.3.9%-17.4%4.3%4.3%6.4%28.3.9%-53.8%4.3%4.3%6.4% 0800 Lake Elmo City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes General Fund Revenues: Taxes 101-410-1320-31010 Current Ad Valorem Taxes 3,250,895$ 3,547,612$ 4,685,850$ 4,651,926$ 1,209,861$ 26.0%4,651,926 5,566,834 20% 101-410-1320-31020 Delinquent Ad Valorem Taxes 20,115 23,518 23,692 18,445 17,822 96.6%18,445 19,000 3% 101-410-1320-31030 Mobile Home Tax 16,819 17,745 22,171 17,748 1,458 8.2%17,748 22,000 24%101-410-1320-31040 Fiscal Disparities 245,389 269,390 294,157 433,046 255,530 59.0%433,046 389,878 -10% 101-410-1320-31520 30% Rental - County 1,721 - #DIV/0!- - #DIV/0! 101-410-1320-31910 Penalty & Interest on Taxes 1,162 79 944 100 468 467.9%100 500 400% Total Taxes 3,534,380$ 3,858,344$ 5,028,535$ 5,121,265$ 1,485,139$ 29.0%5,121,265.00$ 5,998,212$ 17% Licenses and Permits 101-410-1320-32110 Liquor License 9,342 12,050 14,100 12,000 - 0.0%12,000 13,400 12%101-410-1320-32180 Wastehauler License 120 1,200 1,200 1,320 110.0%1,320 1,320 10% 101-410-1320-32181 General Contractor License 100 300 500 300 500 166.7%300 350 17% 101-420-2400-32210 Building Permits 1,137,150 1,087,376 888,486 1,000,000 613,729 61.4%750,000 750,000 -25%Based on 250 homes at $3,000 per (single family and townhomes - more townhomes in 2024)) Decrease from prior year corrects accounting error. 101-430-3100-32211 Driveway Permits 16,255 16,510 12,825 13,000 9,100 70.0%7,000 7,000 -46% 101-420-2400-32212 Fireplace Permits 19,319 17,940 9,780 12,000 4,920 41.0%9,000 6,000 -50%Supply issues, some going to alternative appliances 101-420-2400-32220 Heating Permits 80,489 104,870 64,928 60,000 57,526 95.9%41,000 45,000 -25%Based on 250 homes at $180 per 101-420-2400-32230 Plumbing Permits 99,846 134,602 76,332 80,000 61,004 76.3%42,000 45,000 -44%Based on 250 homes at $180 per 101-420-2400-32232 Pool Permits 1,725 1,650 1,650 1,500 600 40.0%1,000 1,000 -33% 101-420-2400-32213 Siding Permits 3,303 6,023 37,730 4,000 28,231 705.8%35,000 4,000 0%Generally a slow item unless a storm event 101-420-2400-32214 Roof Permits 15,475 30,372 488,840 15,000 146,842 978.9%100,000 15,000 0%Generally a slow item unless a storm event 101-430-3100-32250 Utility Permits 34,974 51,647 34,713 42,500 34,675 81.6%30,000 30,000 -29%These permits slow as development starts to slow. 101-420-2220-32260 Burning Permit 1,550 1,695 2,105 1,700 1,690 99.4%2,100 1,700 0% 101-410-1320-32270 Massage Therapy Licenses 25 350 - 150 325 216.7%150 150 0%101-420-2400-32275 Fire Suppression Permits 5,467 14,635 - 7,900 - 0.0%7,900 8,000 1% 101-420-2400-32278 Fire Permit Plan Check Fee 100 5,460 - 5,135 - 0.0%3,500 5,500 7%101-410-1320-32281 Golf Cart Operation Permit 30 90 90 60 - 0.0%60 60 0%101-410-1320-32282 Miscellaneous Permits 175 88 100 50 100 200.0%50 100 100% Total Licenses and Permits 1,425,545$ 1,485,658$ 1,633,379$ 1,256,495$ 960,562$ 76.45%1,042,380.00$ 933,580.00$ -26% Intergovernmental 101-430-3100-33418 MSA - Maintenance 173,566 163,776 198,154 173,750 202,220 116.4%200,000 208,287 20% 101-420-2220-33420 State Fire Aid 76,608 80,470 99,778 80,000 - 0.0%99,778 - -100%FRA moving to SVF plan. 101-420-2220-33426 Miscellaneous State Grants 5,858 165 4,709 3,500 2,000 57.1%3,500 3,500 0% 101-450-5200-33426 Miscellaneous State Grants 3,192 2,676 4,784 4,850 2,438 50.3%4,850 4,800 -1% 101-410-1320-33623 Payment in Lieu of Taxes 66,201 34,097 34,779 35,475 - 0.0%35,475 36,212 2%101-410-1320-33521 Recycling Grant 11,951 14,004 14,000 16,756 119.7%14,000 16,756 20% Total Intergovernmental 325,425$ 296,638$ 360,870$ 311,574$ 223,414$ 71.71%357,602.29$ 269,555$ -13% #DIV/0! Charges for Services #DIV/0!101-410-1910-34103 Zoning & Subdivision Fees 48,517 50,215 115,965 65,000 67,415 103.7%70,710 93,000 43% 101-420-2400-34104 Plan Check Fees 701,220 711,920 574,075 650,000 395,757 60.9%550,000 487,000 -25%65% of Building Permits101-410-1520-34107 Assessment Searches 2,010 3,540 2,340 3,000 1,215 40.5%2,000 2,500 -17% 101-410-1450-34111 Cable Operation Reimbursement 3,185 2,635 - 5,000 - 0.0%5,000 5,000 0% 101-420-2400-34112 Planning & Zoning Review Fee 34,200 33,434 21,400 - 200 #DIV/0!200 - #DIV/0!discontinued in 2023. 101-430-3100-34114 Street Light Fee 4,338 2,580 816 1,500 516 34.4%2,000 2,000 33% 101-410-1910-34115 Base Map Upgrading Fee 3,775 7,700 1,025 5,125 1,075 21.0%1,075 2,500 -51% 101-410-1910-36206 Escrow Administration Fee 37,200 31,987 20,700 25,000 15,100 60.4%22,400 25,000 0% Total Charges for Services 834,445$ 844,011$ 742,281$ 754,625$ 524,733$ 69.54%653,385.00$ 617,000.00$ -18% #DIV/0! Fines and Forfeits #DIV/0! 101-420-2100-35100 Fines 33,584 45,749 2,966 30,000 32,171 107.2%30,000 30,000 0% 101-420-2100-35130 Forfeitures - 93 #DIV/0!500 - #DIV/0! Total Fines and Forfeits 33,584$ 45,749$ 2,966$ 30,000$ 32,263$ 107.54%30,500.00$ 30,000.00$ 0% #DIV/0!Investment Earnings #DIV/0! 1 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 101-410-1320-36210 Interest Earnings 44,816 (9,833) 35,000 150,974 431.4%35,000 80,000 129%interest allocations across funds occur at year end. Total Investment Earnings 44,816$ (9,833)$ (81,535)$ 35,000$ 150,974$ 431.35%35,000.00$ 80,000.00$ 129% #DIV/0! Miscellaneous #DIV/0! 101-410-1320-31811 Cable Franchise Revenue 94,841 81,019 77,694 70,000 68,884 98.4%65,000 65,000 -7%101-410-1320-36200 Miscellaneous Revenue (Admin)21,710 20,486 15,955 5,000 3,656 73.1%5,000 5,000 0% 101-420-2220-36200 Miscellaneous Revenue (Fire)2,574 7,725 6,155 2,051 #DIV/0!- - #DIV/0! 101-430-3100-36200 Miscellaneous Revenue (PW)24,871 4,080 9,203 3,500 7,225 206.4%4,000 4,500 29% 101-410-1910-36200 Miscellaneous Revenue (Planning)14,725 14,285 - - - #DIV/0!- - #DIV/0! 101-410-1320-36207 MCMA Grant 3,500 - - #DIV/0!- - #DIV/0! 101-450-5200-36200 Miscellaneous Revenue (Parks)812 37 1,312 #DIV/0!1,000 1,000 #DIV/0! 101-420-2220-36204 Reimbursements - Fire 5,150 27,616 25,535 5,000 15,047 300.9%23,000 5,000 0%101-420-2220-36230 Donations-Fire 370 2,185 1,000 - 0.0%1,500 1,000 0% 101-410-1320-36230 Donations 14,100 9,000 12,000 10,000 10,000 100.0%10,000 10,000 0% 101-410-1320-34120 Tower Rent 113,316 103,631 48,006 117,062 100,789 86.1%117,000 119,403 2% Total Miscellaneous 292,469$ 271,342$ 196,769$ 211,562$ 208,964$ 98.77%226,500.00$ 210,903.00$ 0%Prior Period Adjustments #DIV/0! #DIV/0! General Fund Revenue Summary #DIV/0!Taxes 5,028,535 5,121,265 1,485,139 29.0%5,121,265 5,998,212 17% Licenses and Permits 1,633,379 1,256,495 960,562 76.4%1,042,380 933,580 -26% Intergovernmental 360,870 311,574 223,414 71.7%357,602 269,555 -13% Charges for Services 742,281 754,625 524,733 69.5%653,385 617,000 -18% Fines and Forfeits 2,966 30,000 32,263 107.5%30,500 30,000 0% Investment Earnings (81,535) 35,000 150,974 431.4%35,000 80,000 129% Miscellaneous 196,769 211,562 208,964 98.8%226,500 210,903 0%#DIV/0! Total General Fund Revenues:6,490,664$ 6,791,909$ 7,883,265$ 7,720,521$ 3,586,050$ 46.45%7,466,632$ 8,139,250$ 5% 2 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 7,883,265$ 3,586,050$ General Fund Expenditures: 1110 Mayor & Council Personnel 101-410-1110-41030 Part-time Salaries 25,690 25,690 25,690 25,690 12,845 50.0%25,690 25,690 0% 101-410-1110-41220 FICA Contributions 1,593 1,593 1,593 1,593 796 50.0%1,593 1,593 0% 101-410-1110-41230 Medicare Contributions 373 373 373 373 186 49.9%373 373 0% 101-410-1110-41510 Workers Compensation 136 118 86 110 66.49 60.4%66 93 -15%Total Personnel 27,792$ 27,774$ 27,741$ 27,766$ 13,894$ 50.0%27,722$ 27,749$ 0% Materials and Supplies 101-410-1110-42000 Office Supplies 212 70 64 125 67 53.4%125 125 0% 101-410-1110-42001 Computer Reimbursement 2,859 - 2,000 2,000 100.0%2,000 - -100%no computers until 2025. 101-410-1110-43185 IT Support 1,248 1,203 1,322 1,269 849 66.9%1,269 1,394 10% 101-410-1110-43310 Mileage 191 300 37 12.3%300 955 218%LMC conference in Rochester Total Materials and Supplies 1,460$ 4,132$ 1,577$ 3,694$ 2,952$ 79.9%3,694$ 2,474$ -33% Charges and Services 101-410-1110-44300 Miscellaneous 5,295 7,035 5,412 7,500 7,329 97.7%6,165 6,165 -18%101-410-1110-44330 Dues & Subscriptions 14,699 15,514 17,092 19,500 18,389 94.3%19,500 22,758 17%LMC Dues (max 4.5% incr.+pop. growth), MN Mayors Assoc, Metro Cities ($5008) 101-410-1110-44370 Conferences & Training 175 1,301 1,500 594 39.6%1,500 6,975 365%LMC annual conference and hotel Total Charges and Services 19,994$ 22,724$ 23,805$ 28,500$ 26,312$ 92.3%27,165$ 35,898$ 26% 1110 Total Mayor & Council 49,246$ 54,630$ 53,123$ 59,960$ 43,158$ 72.0%58,581$ 66,121$ 10% 3 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 1320 Administration Personnel 101-410-1320-41010 Full-time Salaries 163,213 175,445 161,134 208,445 129,883 62.3%207,372 261,516 25%Communications budget has been incorporated into Admin. 101-410-1320-41030 Part-time Salaries - - #DIV/0!- #DIV/0! 101-410-1320-41040 Temporary Employees 4,780 1,532 - - #DIV/0!- #DIV/0!101-410-1320-41210 PERA Contributions 19,774 13,224 11,924 15,633 9,742 62.3%12,442 19,614 25% 101-410-1320-41216 MSRS Contributions -City Admin 1,355 1,540 1,598 1,126 70.5%1,515 1,704 7% 101-410-1320-41220 FICA Contributions 15,391 10,485 9,365 12,924 7,691 59.5%9,851 16,214 25% 101-410-1320-41230 Medicare Contributions 3,711 2,463 2,220 3,022 1,798 59.5%2,304 3,792 25% 101-410-1320-41300 Insurance 34,880 24,381 22,409 35,829 18,793 52.5%22,752 41,897 17% 101-410-1320-41325 Life Insurance 156 123 110 127 71 55.5%91 168 32% 101-410-1320-41330 STD/LTD 2,172 878 804 927 590 63.7%757 1,399 51%101-410-1320-41420 Unemployment Benefits - - #DIV/0!- - #DIV/0! 101-410-1320-41510 Workers Compensation 1,912 1,538 1,179 1,510 1,045 69.2%1,510 1,385 -8% Total Personnel 245,989$ 231,424$ 210,686$ 280,015$ 170,740$ 61.0%258,595$ 347,688$ 24% Materials and Supplies 101-410-1320-42000 Office Supplies 1,870 1,160 754 3,000 1,444 48.1%3,000 3,200 7% 101-410-1320-42030 Printed Forms - 100 - 0.0%100 100 0%101-410-1320-42110 Cleaning Supplies 70 #DIV/0! 101-410-1320-42230 Building Repair Supplies 210 #DIV/0! Total Materials and Supplies 1,870$ 1,160$ 754$ 3,100$ 1,444$ 46.6%3,100$ 3,580$ 15% Charges and Services 101-410-1320-42002 IT Hardware 568 868 1,139 6,575 4,966 75.5%6,575 4,600 -30%Council Chamber, Deputy Clerk Laptop 101-410-1320-43040 Legal Services 120,251 49,351 41,985 83,331 22,445 26.9%83,331 80,000 -4% 101-410-1320-43090 Newsletter - 1,533 1,610 #DIV/0! 101-410-1320-43100 Assessing Services 91,773 102,847 107,874 145,315 6,493 4.5%110,000 112,959 -22% 101-410-1320-43150 Contract Services 821 1,045 33,472 30,000 12,721 42.4%30,000 25,000 -17% 101-410-1320-43152 Cable Operation Expense - - #DIV/0!5,000 #DIV/0!101-410-1320-43185 IT Support 7,574 7,300 5,262 5,033 3,355 66.7%5,033 7,830 56% 101-410-1320-43210 Telephone 792 2,372 569 1,600 401 25.1%1,600 1,002 -37% 101-410-1320-43220 Postage 2,294 3,379 3,876 3,730 3,684 98.8%3,730 4,504 21% 101-410-1320-43310 Mileage 32 409 499 1,500 322 21.4%750 2,055 37% 101-410-1320-43510 Legal Publishing 9,515 5,290 1,286 2,500 179 7.1%1,300 1,500 -40% 101-410-1320-43610 Insurance 40,970 41,177 43,543 47,897 36,273 75.7%26,087 -46% 101-410-1320-43810 Electric Utility - 4,200 #DIV/0!101-410-1320-43830 Gas Utility - 1,050 #DIV/0! 101-410-1320-43840 Refuse - 210 #DIV/0! 101-410-1320-44010 Repairs/Maint Contractual Bldg 41 2,331 #DIV/0! 101-410-1320-44040 Repairs/Maint Contractual Eqpt 3,071 2,750 #DIV/0! 101-410-1320-44330 Dues & Subscriptions 1,731 1,413 1,557 3,128 1,321 42.2%- 3,800 21% 101-410-1320-44370 Conferences & Training 600 1,085 2,377 7,000 2,459 35.1%- 11,285 61% 101-410-1320-44371 Allocation to Building Inspections (1,998) (3,184) - 0.0%(3,184) - -100%no longer used.Total Charges and Services 276,921$ 216,863$ 241,441$ 334,425$ 97,730$ 29.2%248,668$ 305,773$ -9% Capital Outlay 101-410-1320-45800 Other Equipment - - - #DIV/0!- - Total Capital Outlay -$ -$ -$ -$ -$ Miscellaneous101-410-1320-44300 Miscellaneous 899 1,436 1,352 2,500 990 39.6%- 3,463 39% Total Miscellaneous 899$ 1,436$ 1,352$ 2,500$ 990$ 39.6%-$ 3,463$ 39% 1320 Total Administration 525,679$ 450,883$ 454,233$ 620,040$ 270,904$ 43.7%510,362$ 660,504$ 7%-5.80% 1410 Elections Personnel 101-410-1410-41030 Part-time Salaries 9,655 1,606 8,649 - - - 11,008 #DIV/0! 4 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 101-410-1410-41510 Workers Compensation - - - - #DIV/0!Total Personnel 9,655$ 1,606$ 8,649$ -$ -$ 11,008$ #DIV/0! #DIV/0! Charges and Services #DIV/0! 101-410-1410-43310 Travel Expense - - - 75 #DIV/0!101-410-1410-42000 Office Supplies 295 - - - 300 #DIV/0! 101-410-1410-43510 Legal Notices Publishing 379 712 - - 500 #DIV/0! 101-410-1410-43150 Contract Services 1,660 3,100 3,195 3,200 3,525 110.2%3,200 3,525 10% Total Charges and Services 2,334$ 3,100$ 3,907$ 3,200$ 3,525$ 3,200$ 3,200$ 4,400$ 38% #DIV/0! Miscellaneous #DIV/0! 101-410-1410-44300 Miscellaneous 1,054 406 1,214 - - - 1,250 #DIV/0!Total Miscellaneous 1,054$ 406$ -$ -$ - 1,250$ #DIV/0! 1410 Total Elections 13,043$ 5,112$ 12,556$ 3,200$ 3,525$ 3,200$ 3,200$ 16,658$ 421% 1450 Communications Personnel101-410-1450-41010 Full-time Salaries 25,988 27,460 11,931 51,459 18,737 36.4%51,459$ -100%Communications Dept goes away in 2024, 101-410-1450-41210 PERA Contributions 2,046 2,048 845 3,859 1,405 36.4%3,859$ -100%but will show for comparison to whole budget. 101-410-1450-41220 FICA Contributions 1,692 1,693 739 3,190 1,089 34.1%3,190$ -100% 101-410-1450-41230 Medicare Contributions 396 396 173 746 255 34.1%746$ -100% 101-410-1450-41300 Insurance 2,676 2,937 1,778 7,775 3,201 41.2%7,775$ -100% 101-410-1450-41325 Life Insurance 17 28 287 28 - 0.0%28$ -100% 101-410-1450-41330 STD/LTD 89 146 54 158 - 0.0%158$ -100%101-410-1450-41510 Workers Compensation 279 259 189 242 256 105.5%242$ -100% Total Personnel 33,183$ 34,967$ 15,997$ 67,458$ 24,943$ 37.0%67,458$ -$ -100% #DIV/0! Charges and Services #DIV/0! 101-410-1450-43090 Newsletter 1,122 1,231 709 1,550 2,316 149.4%1,550$ -100% 101-410-1450-43185 IT Support 3,778 585 849 1,086 972 89.5%1,086$ -100% 101-410-1450-42002 IT Hardware - 700 - 0.0%700$ -100%101-410-1450-43190 Software Programs 1,629 4,000 1,350 33.8%4,000$ -100% 101-410-1450-43220 Postage 1,526 1,967 309 704 349 49.6%704$ -100% 101-410-1450-43310 Mileage - 100 - 0.0%100$ -100% 101-410-1450-43152 Cable Operations 3,295 2,745 3,485 5,000 2,892 57.8%5,000$ -100% 101-410-1450-44370 Conferences and Training - 500 - 0.0%500$ -100% Total Charges and Services 9,721$ 9,475$ 6,981$ 13,640$ 7,879$ 57.8%13,640$ -$ -100% - - 1450 Total Communications 42,904$ 44,442$ 22,978$ 81,098$ 32,822$ 40.5%81,098$ -$ -100% 5 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 1520 Finance Personnel 101-410-1520-41010 Full-time Salaries 12,149 71,096 42,139 147,055 43,683 29.7%52,875 160,980 9% 101-410-1520-41040 Temporary Employees 6,026 - 10,200 - 0.0%- - -100%No intern in Finance. 101-410-1520-41210 PERA Contributions 1,153 5,301 3,034 11,029 3,276 29.7%3,172 12,074 9%101-410-1520-41220 FICA Contributions 903 4,600 2,512 9,750 2,606 26.7%2,562 9,981 2% 101-410-1520-41230 Medicare Contributions 211 1,076 588 2,280 609 26.7%599 2,334 2% 101-410-1520-41300 Insurance (64) 10,750 8,929 24,928 8,547 34.3%7,809 30,282 21% 101-410-1520-41325 Life Insurance 9 386 308 109 17 15.7%22 121 11% 101-410-1520-41330 STD/LTD 45 288 295 542 109 20.0%136 1,044 93% 101-410-1520-41420 Unemployment Benefits 414 - - - #DIV/0! 101-410-1520-41510 Workers Compensation 851 710 517 662 734 110.9%662 852 29%Total Personnel 15,257$ 100,233$ 58,735$ 206,556$ 59,581$ 28.8%67,837$ 217,669$ 5% Materials and Supplies 101-410-1520-42000 Office Supplies 258 697 760 1,000 457 45.7%1,000 1,000 0% 101-410-1520-42110 Cleaning Supplies 70 #DIV/0! 101-410-1520-42230 Building Repair Supplies 210 #DIV/0! 101-410-1520-42030 Printed Forms 980 1,052 1,750 1,009 57.7%1,750 1,500 -14%Total Materials and Supplies 258$ 1,677$ 1,811$ 2,750$ 1,467$ 53.3%2,750$ 2,780$ 1% Charges and Services 101-410-1520-42002 IT Hardware 1,774 - 2,140 - 0.0%2,140 6,900 222%Finance Coord, A/P Clerk Laptop, UB Clerk Laptop 101-410-1520-43010 Audit Services 9,105 8,608 8,244 8,967 9,825 109.6%8,967 11,425 27% 101-410-1520-43150 Contract Services 43,155 15,834 39,493 30,000 42,541 141.8%30,000 10,000 -67% 101-410-1520-43185 IT Support 4,446 4,128 2,266 4,287 3,029 70.7%4,287 4,287 0% 101-410-1520-43190 Software Programs 5,743 4,383 4,018 7,408 800 10.8%7,408 7,000 -6%101-410-1520-43310 Mileage - 200 - 0.0%200 300 50% 101-410-1520-43610 Insurance - 886 2,206 #DIV/0!new allocation to Finance Dept. 101-410-1520-43810 Electric Utility - - 4,200 #DIV/0! 101-410-1520-43830 Gas Utility - - 1,050 #DIV/0! 101-410-1520-43840 Refuse - - 210 #DIV/0! 101-410-1520-44010 Repairs/Maint Contractual Bldg - 41 2,331 #DIV/0! 101-410-1520-44040 Repairs/Maint Contractual Eqpt - - 2,750 #DIV/0!101-410-1520-44330 Dues & Subscriptions 650 720 530 1,500 720 48.0%520 1,040 -31% 101-410-1520-44370 Conferences & Training 681 - 1,600 250 15.6%1,600 5,095 218%MNGFOA conference - registration & hotel (FD and FC), LMC conference (FD) 101-410-1520-44371 Allocation to Building Inspections (1,231) (2,905) - 0.0%(2,905) -100%no longer used. Total Charges and Services 63,099$ 36,128$ 53,319$ 53,197$ 58,093$ 109.2%52,217$ 58,794$ 11% Miscellaneous 101-410-1520-44300 Miscellaneous 1,008 2,773 1,234 3,900 270 6.9%1,500 1,570 -60%Total Miscellaneous 1,008$ 2,773$ 1,234$ 3,900$ 270$ 6.9%1,500$ 1,570$ -60% 1520 Total Finance 79,622$ 140,811$ 115,100$ 266,403$ 119,411$ 44.8%124,304$ 280,813$ 5% 6 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 1910 Planning & Zoning Personnel 101-410-1910-41010 Full-time Salaries 152,276 153,262 190,130 250,900 46,069 18.4%62,940 291,923 16% 101-410-1910-41040 Temporary Employees 5,915 9,341 390 10,200 4,522 44.3%1,734 9,620 -6% 101-410-1910-41210 PERA Contributions 11,819 11,125 14,260 18,817 3,411 18.1%4,633 21,894 16%101-410-1910-41220 FICA Contributions 10,088 9,947 11,471 16,188 3,018 18.6%3,847 18,696 15% 101-410-1910-41230 Medicare Contributions 2,359 2,326 2,683 3,786 706 18.6%900 4,372 15% 101-410-1910-41300 Insurance 20,632 12,497 18,703 52,069 7,430 14.3%10,018 61,162 17% 101-410-1910-41325 Life Insurance 53 751 664 271 47 17.2%62 245 -9% 101-410-1910-41330 STD/LTD 843 579 739 1,195 225 18.8%298 1,600 34% 101-410-1910-41510 Workers Compensation 1,581 1,563 1,138 1,457 1,260 86.4%1,457 1,610 10% Total Personnel 205,566$ 201,391$ 240,176$ 354,883$ 66,688$ 18.8%85,888$ 411,122$ 16% Materials and Supplies 101-410-1910-42000 Office Supplies 110 323 574 1,000 262 26.2%1,000 1,000 0% 101-410-1910-42110 Cleaning Supplies 40 #DIV/0!101-410-1910-42230 Building Repair Supplies 120 #DIV/0! 101-410-1910-42120 Fuel, Oil and Fluids - 2,000 270 13.5%2,000 2,000 0% 101-410-1910-42030 Printed Forms - 600 51 8.5%600 600 0% Total Materials and Supplies 110$ 323$ 574$ 3,600$ 583$ 16.2%3,600.00$ 3,760.00$ 4% Charges and Services 101-410-1910-43020 Comprehensive Planning 744 - - #DIV/0!- - #DIV/0! 101-410-1910-43030 Engineering Services 10,255 4,671 6,175 13,000 2,050 15.8%5,000 5,000 -62% 101-410-1910-43150 Contract Services 11,543 86,121 17,216 10,000 60,645 606.4%41,519 15,000 50%landscape architect 101-410-1910-43185 IT Support 6,014 5,291 11,273 7,686 68.2%11,273 11,273 0% 101-410-1910-42002 IT Hardware 1,769 2,091 2,300 - 0.0%2,300 9,200 300%Planner laptop, CEO laptop, Sr Planner laptop, intern/extra 101-410-1910-43190 Software Programs 268 936 1,700 - 0.0%1,700 1,700 0%101-410-1910-43810 Electric Utility - - 2,400 #DIV/0! 101-410-1910-43830 Gas Utility - - 600 #DIV/0! 101-410-1910-43840 Refuse - - 120 #DIV/0! 101-410-1910-44010 Repairs/Maint Contractual Bldg - 24 1,332 #DIV/0! 101-410-1910-44040 Repairs/Maint Contractual Eqpt - - 2,750 #DIV/0! 101-410-1910-43210 Telephone 191 720 80 11.1%720 126 -82% 101-410-1910-43220 Postage 80 200 - 0.0%200 200 0%101-410-1910-43310 Mileage 40 380 600 - 0.0%200 600 0% 101-410-1910-43510 Legal Publishing 1,374 770 1,775 700 913 130.4%1,825 1,825 161% 101-410-1910-44330 Dues & Subscriptions 372 698 1,700 - 0.0%425 2,000 18% 101-410-1910-44370 Conferences & Training 100 2,032 3,200 285 8.9%1,000 3,500 9%Total Charges and Services 30,667$ 99,613$ 37,213$ 45,393$ 71,682$ 158%66,161.53$ 57,666.11$ 27% Miscellaneous 101-410-1910-44300 Miscellaneous 348 600 335 55.8%600 640 7% Total Miscellaneous 348$ 600$ 335$ 56%600.00$ 640.00$ 7% # IV/0! 1910 Total Planning & Zoning 236,343$ 301,327$ 278,311$ 404,476$ 139,288$ 34.4%156,250$ 473,189$ 17% 7 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 1930 Engineering Services Charges and Services 101-410-1930-43030 Engineering Services 30,000 30,000 30,975 35,000 22,785 65.1%35,000 35,000 0% 101-410-1930-43210 Telephone - - #DIV/0!- - #DIV/0! Total Charges and Services 30,000$ 30,000$ 30,975$ 35,000$ 22,785$ 65.1%35,000$ 35,000$ 0%#DIV/0! 1930 Total Engineering Services 30,000$ 30,000$ 30,975$ 35,000$ 22,785$ 65.1%35,000$ 35,000$ 1940 City Hall Materials and Supplies 101-410-1940-42110 Cleaning Supplies 17 40 345 1,000 - 0.0%1,000 - -100%City Hall Dept goes away in 2024, 101-410-1940-42230 Building Repair Supplies 107 87 491 2,000 232 11.6%2,000 - -100%but will show for comparison to whole budget. Total Materials and Supplies 124$ 127$ 835$ 3,000$ 232$ 7.7%3,000$ -$ -100%Costs will be allocated across departments using City Hall. - #DIV/0! Charges and Services - #DIV/0! 101-410-1940-43185 IT Support 5,769 5,561 1,322 1,269 849 66.9%1,269 - -100% 101-410-1940-42002 IT Hardware - 600 - 0.0%600 - -100% 101-410-1940-43810 Utilities 3,033 4,519 25,083 38,000 36,478 96.0%38,000 - -100% 101-410-1940-43840 Refuse 1,608 1,898 1,968 3,000 1,341 44.7%3,000 - -100%101-410-1940-44010 Repairs/Maint Contractual Bldg 5,855 9,060 14,855 26,000 10,411 40.0%26,000 - -100% 101-410-1940-44040 Repairs/Maint Contractual Eqpt 10,795 7,852 2,840 10,000 993 9.9%10,000 - -100% 101-410-1940-44371 Allocation to Building Inspections (26,476) (45,050) - 0.0%(45,050) - -100% Total Charges and Services 27,060$ 28,890$ 19,841$ 33,819$ 50,071$ 148.1%33,819$ -$ -100% Miscellaneous 101-410-1940-44300 Miscellaneous 828 996 25,320 30,000 2,525 8.4%30,000 - -100%Total Miscellaneous 828$ 996$ 25,320$ 30,000$ 2,525$ 8.4%30,000$ -$ -100% - - 1940 Total City Hall 28,012$ 30,013$ 45,996$ 66,819$ 52,828$ 79.1%66,819$ -$ 8 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 2100 Police Materials and Supplies 101-420-2100-42110 Cleaning Supplies 140 #DIV/0! 101-420-2100-42230 Building Repair Supplies 420 #DIV/0!Total Materials and Supplies 560$ #DIV/0! Charges and Services 101-420-2100-43150 Law Enforcement Contract 761,969 901,120 947,044 1,047,984 524,626 50.1%1,047,984 1,289,478 23%adding additional deputy. 101-420-2100-43610 Insurance 3,013 #DIV/0!new allocation. 101-420-2100-43810 Electric Utility 8,400 #DIV/0!new building expenses. 101-420-2100-43830 Gas Utility 2,100 #DIV/0!101-420-2100-43840 Refuse 420 #DIV/0! 101-420-2100-44010 Repairs/Maint Contractual Bldg 4,662 #DIV/0! 101-420-2100-44040 Repairs/Maint Contractual Eqpt - #DIV/0! 101-420-2100-44300 Misc. Building Exp. 140 #DIV/0! 101-420-2100-44301 Misc. - Community Event - 1,800 - 0.0%1,800 1,800 0% Total Charges and Services 761,969$ 901,120$ 947,044$ 1,049,784$ 524,626$ 50.0%1,049,784$ 1,310,013$ 25% - - 2100 Total Police 761,969$ 901,120$ 947,044$ 1,049,784$ 524,626$ 50%1,049,784$ 1,310,573$ 25% 2150 Prosecution Charges and Services 101-420-2150-43045 Attorney Criminal 48,392 50,212 48,141 50,000 32,841 65.7%50,000 50,000 0% Total Charges and Services 48,392$ 50,212$ 48,141$ 50,000$ 32,841$ 65.7%50,000$ 50,000$ 0% - - 2150 Total Prosecution 48,392$ 50,212$ 48,141$ 50,000$ 32,841$ 66%50,000$ 50,000$ 0% 9 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 2220 Fire Personnel 101-420-2220-41010 Full-time Salaries 73,917 149,818 249,451 588,112 232,397 39.5%374,150 623,384 6% 101-420-2220-41030 Part-time Salaries 178,775 112,497 61,057 19,429 4,498 23.1%7,556 7,500 -61% 101-420-2220-41035 Paid On Call Salaries 48,447 102,555 75,897 167,280 98,674 59.0%117,169 196,859 18%101-420-2220-41210 PERA Contributions 28,053 46,654 51,347 107,535 41,665 38.7%66,225 111,666 4% 101-420-2220-41220 FICA Contributions 14,323 6,211 5,145 10,371 6,672 64.3%8,367 12,205 18% 101-420-2220-41230 Medicare Contributions 4,733 5,195 5,389 11,235 4,884 43.5%6,246 12,002 7% 101-420-2220-41300 Insurance 9,883 24,745 31,967 71,037 30,111 42.4%38,690 131,818 86% 101-420-2220-41325 Life Insurance 233 145 516 149 29.0%172 529 2% 101-420-2220-41330 STD/LTD 579 611 1,104 1,104 1,141 103.4%1,366 2,850 158% 101-420-2220-41420 Unemployment Benefits 653 6,652 - #DIV/0!- - #DIV/0!101-420-2220-41510 Workers Compensation 47,294 39,378 28,673 36,726 57,030 155.3%36,726 66,882 82% Total Personnel 406,657$ 487,897$ 516,825$ 1,013,345$ 477,222$ 47.1%656,665$ 1,165,696$ 15% Materials and Supplies 101-420-2220-42000 Office Supplies 920 835 1,119 1,000 691 69.1%1,000 1,000 0% 101-420-2220-42110 Cleaning Supplies 540 #DIV/0! 101-420-2220-42230 Building Repair Supplies 1,620 #DIV/0!101-420-2220-42080 EMS Supplies 4,066 2,422 968 2,400 2,064 86.0%2,400 2,400 0% 101-420-2220-42090 Fire Prevention 1,710 991 1,860 2,000 130 6.5%2,000 2,000 0% 101-420-2220-42120 Fuel, Oil and Fluids 7,683 13,230 25,109 25,200 11,747 46.6%27,000 29,700 18% 101-420-2220-42400 Small Tools & Equipment 15,261 31,521 37,573 25,419 22,477 88.4%25,419 25,419 0%Total Materials and Supplies 29,640$ 48,999$ 66,629$ 56,019$ 37,108$ 66.2%57,819$ 62,679$ 12% Charges and Services101-420-2220-42002 IT Hardware 1,200 1,715 3,000 2,529 84.3%3,000 8,920 197%3 gen. use, Chief, Asst. Ch. laptop 101-420-2220-43050 Physicals 4,883 8,052 9,764 11,500 4,610 40.1%11,500 11,500 0% 101-420-2220-43150 Contract Services 41,635 2,550 1,100 2,650 - 0.0%2,650 1,150 -57% 101-420-2220-43185 IT Support 20,550 19,808 19,824 22,443 15,102 67.3%22,443 23,513 5%101-420-2220-43190 Software Programs 3,730 14,000 14,005 100.0%14,000 15,324 9% 101-420-2220-43210 Telephone 4,657 4,332 3,983 4,800 2,634 54.9%4,800 4,800 0% 101-420-2220-43230 Radio 19,525 22,959 16,555 17,500 9,365 53.5%17,500 17,500 0% 101-420-2220-43310 Mileage 190 286 180 500 - 0.0%500 600 20% 101-420-2220-43630 Insurance 9,515 9,563 10,112 11,123 22,157 199.2%15,325 21,950 97% 101-420-2220-43810 Utility 11,002 14,168 16,820 15,914 10,374 65.2%- 32,400 104% 101-420-2220-43830 Gas Utility - 8,100 #DIV/0!separating utilities moving forward. 101-420-2220-43840 Refuse 707 898 227 700 128 18.3%- 1,620 131% 101-420-2220-44010 Repairs/Maint Bldg 7,077 11,018 6,737 9,000 7,548 83.9%9,000 17,982 100%101-420-2220-44040 Repairs/Maint Eqpt 50,901 49,485 54,027 43,920 39,054 88.9%43,920 43,920 0% 101-420-2220-44170 Uniforms 7,696 12,698 7,532 10,000 10,499 105.0%10,000 10,000 0% 101-420-2220-44330 Dues & Subscriptions 2,779 6,841 2,766 3,450 3,426 99.3%3,450 4,845 40% 101-420-2220-44350 Books 1,064 942 185 1,000 1,173 117.3%1,000 1,000 0% 101-420-2220-44370 Conferences & Training 23,427 21,715 23,015 25,905 28,178 108.8%25,905 27,000 4% Total Charges and Services 205,608$ 186,515$ 178,273$ 197,406$ 170,784$ 86.5%184,994$ 252,124$ 28% Capital Outlay 101-420-2220-47200 Transfer to Vehicle Replacement Fund 51,537 67,112 - 0.0%67,112 94,914 41%See CIP for future purchases. 101-480-2220-45800 Equipment 65,000 SCBA Fill Station & Compressor 101-480-8000-45800 Equipment 78,628 205,000 16,554 8.1%205,000 - -100%use account above. Total Capital Outlay 130,165$ 272,112$ 16,554$ 6.1%272,112$ 159,914$ -41% Miscellaneous 101-420-2220-44300 Miscellaneous 439 2,259 1,854 2,000 1,057 52.8%2,000 2,540 27% Total Miscellaneous 439$ 2,259$ 1,854$ 2,000$ 1,057$ 52.8%2,000$ 2,540$ 27% #DIV/0! 2220 Total Fire 642,344$ 725,670$ 893,746$ 1,540,881$ 702,725$ 45.6%1,173,590$ 1,642,953$ 7% 10 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 2220 Fire Relief Charges and Services 101-420-2220-44920 Fire State Aid 76,608 80,470 - 80,000 - 80,000 - -100%FRA moving to SVF. State aid will go directly to the FRA. Total Charges and Services 76608 80470 0 80,000$ 0 0.0%80,000.00$ -$ -100% 2250 Total Fire Relief 76608 80470 0 80,000$ 0 0.0%80,000$ -$ -100% 11 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 2400 Building Inspection Personnel 101-420-2400-41010 Full-time Salaries 245,057 320,305 343,456 516,834 249,446 48.3%335,582 648,216 25% 101-420-2400-41210 PERA Contributions 16,888 25,186 27,061 38,763 20,096 51.8%53,786 55,388 43%101-420-2400-41216 MSRS Contributions -City Admin 457 519 538 379 70.5%538 574 7% 101-420-2400-41220 FICA Contributions 13,347 18,077 19,246 32,044 14,014 43.7%8,367 40,189 25% 101-420-2400-41230 Medicare Contributions 3,195 4,422 4,760 7,494 3,471 46.3%6,246 9,399 25% 101-420-2400-41300 Insurance 35,196 53,549 64,027 88,232 45,840 52.0%38,690 133,765 52% 101-420-2400-41325 Life Insurance 124 389 239 398 173 43.4%172 536 35% 101-420-2400-41330 STD/LTD 822 1,348 1,439 2,254 1,283 56.9%1,366 3,790 68% 101-420-2400-41510 Workers Compensation 4,377 4,222 3,074 3,937 2,258.09 57.4%2,258 8,172 108%Total Personnel 319,006$ 427,955$ 463,821$ 690,494$ 336,960$ 48.8%447,005$ 900,028$ 30% Materials and Supplies 101-420-2400-42000 Office Supplies 698 849 1,067 13,420 12,059 89.9%13,420 4,000 -70% 101-420-2400-42030 Printed Forms - 350 - 0.0%350 350 0% 101-420-2400-42110 Cleaning Supplies - - 140 #DIV/0! 101-420-2400-42120 Fuel, Oil and Fluids 2,123 3,574 5,424 7,500 5,738 76.5%7,500 7,500 0%101-420-2400-42230 Building Repair Supplies - - 420 #DIV/0! Total Materials and Supplies 2,821$ 4,423$ 6,491$ 21,270$ 17,797$ 83.7%21,270$ 12,410$ -42% Charges and Services 101-420-2400-42002 IT Hardware 1,413 174 5,000 - 0.0%- 15,500 210%Bldg Official, Bldg Insp., 2 rugged laptops for onsite inspect., Bldg off laptop, Inspec. Laptop, clerk laptop. 101-420-2400-43030 Engineering 245 488 24 5,000 - 0.0%3,000 3,000 -40% 101-420-2400-43150 Inspector Contract Services 755,966 769,930 274,617 96,000 63,110 65.7%80,000 80,000 -17% 101-420-2400-43185 IT Support 9,688 7,962 13,378 17,365 11,574 66.6%17,365 23,030 33% 101-420-2400-43190 Software Programs 395 1,495 3,416 4,500 3,280 72.9%4,500 25,000 456%Looking at new Web-based permitting software to replace Permit Works, still receiving quotes of $20,000 or less. 101-420-2400-43210 Telephone 3,242 3,209 1,760 3,024 1,551 51.3%3,024 2,442 -19% 101-420-2400-43630 Insurance 3,387 3,404 3,600 3,960 7,939 200.5%3,960 7,207 82% 101-420-2400-43810 Electric Utility - - 8,400 #DIV/0! 101-420-2400-43830 Gas Utility - - 2,100 #DIV/0! 101-420-2400-43840 Refuse - - 420 #DIV/0! 101-420-2400-44010 Repairs/Maint Contractual Bldg - 83 4,662 #DIV/0! 101-420-2400-44040 Repairs/Maint Eqpt 1,717 7,479 7,322 7,500 4,243 56.6%6,000 7,750 3%101-420-2400-44170 Uniforms 190 326 468 2,100 37 1.7%1,000 1,000 -52% 101-420-2400-44330 Dues & Subscriptions 130 290 60 1,000 675 67.5%1,000 1,500 50% 101-420-2400-44350 Books 595 430 256 2,000 - 0.0%1,000 1,000 -50% 101-420-2400-44370 Conferences & Training 791 1,848 2,224 5,000 183 3.7%3,000 5,000 0%Total Charges and Services 776,346$ 798,274$ 307,297$ 152,449$ 92,675$ 60.8%123,849$ 188,011$ 23% Capital Outlay101-420-2400-47200 Transfer to Vehicle Replacement 9,539 - #DIV/0! 101-480-2400-47200 Transfer to Vehicle Replacement - - 14,907 - 0.0%14,907 11,300 #REF!4 vehicles, 6 year rotation Total Capital Outlay -$ -$ 14,907$ -$ 0.0%14,907$ 11,300$ -24% Miscellaneous 101-420-2400-44371 Allocations from Admin, Finance, City Hall 29,706 51,138 - 0.0%51,138 - -100%no longer used starting in 2024. 101-420-2400-44300 Miscellaneous 152 868 1,205 2,000 453 22.7%2,000 3,140 57% Total Miscellaneous 152$ 868$ 30,911$ 53,138$ 453$ 0.9%53,138$ 3,140$ -94% 2400 Total Building Inspection 1,098,325$ 1,231,520$ 808,520$ 932,259$ 447,885$ 48.0%660,169$ 1,114,889$ 20% 12 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 2500 Emergency Communications Charges and Services 101-420-2500-43150 Contract Services 900 1,514 20,501 4,500 3,537 78.6%4,500 4,500 0% Total Charges and Services 900$ 1,514$ 20,501$ 4,500$ 3,537$ 78.6%4,500$ 4,500$ 0% - - 2500 Total Emergency Communications 900$ 1,514$ 20,501$ 4,500$ 3,537$ 78.6%4,500$ 4,500$ 0% 2700 Animal Control Charges and Services 101-420-2700-43150 Contract Services 13,066 14,161 13,550 13,000 9,885 76.0%14,391.90$ 14,500 12% Total Charges and Services 13,066$ 14,161$ 13,550$ 13,000$ 9,885$ 76.0%14,392$ 14,500$ 12% 2700 Total Animal Control 13,066$ 14,161$ 13,550$ 13,000$ 9,885$ 76.0%14,392$ 14,500$ 12% 13 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 3100 Streets Personnel 101-430-3100-41010 Full-time Salaries 344,197 338,210 375,049 393,363 296,625 75.4%445,584 389,266 -1% 101-430-3100-41020 Overtime 126 8,605 11,431 13,634 8,042 59.0%11,955 19,689 44% 101-430-3100-41040 Temporary Employees 22,670 4,871 9,585 15,300 21,408 139.9%13,000 19,240 26%101-430-3100-41210 PERA Contributions 28,634 25,853 28,899 30,525 22,850 74.9%34,316 29,195 -4% 101-430-3100-41220 FICA Contributions 22,644 20,862 23,414 26,182 19,353 73.9%28,079 26,548 1% 101-430-3100-41230 Medicare Contributions 5,322 4,879 5,476 6,123 4,526 73.9%6,567 6,209 1% 101-430-3100-41300 Insurance 73,684 69,021 75,099 79,948 61,140 76.5%88,942 81,029 1% 101-430-3100-41325 Life Insurance 320 305 334 341 249 72.8%364 378 11% 101-430-3100-41330 STD/LTD 3,075 1,806 1,929 1,984 1,682 84.8%2,422 2,145 8% 101-430-3100-41600 Safety Clothing Allowance 277 225 800 662 82.8%800 800 0%101-430-3100-41420 Unemployment Benefits - 2,005 #DIV/0!- - #DIV/0! 101-430-3100-41510 Workers Compensation 37,462 49,530 36,194 46,193 25,184 54.5%46,193 22,806 -51% Total Personnel 538,411$ 523,942$ 567,633$ 614,393$ 463,725$ 75.5%678,220$ 597,306$ -3% Materials and Supplies 101-430-3100-42000 Office Supplies 247 171 500 500 55 11.0%500 500 0% 101-430-3100-42120 Fuel, Oil and Fluids 20,358 21,203 41,375 44,000 37,219 84.6%50,000 48,000 9%2023 hauling material to city hall & excessive snow101-430-3100-42150 Operating Supplies 9,998 9,192 8,586 9,000 6,246 69.4%9,000 9,000 0% 101-430-3100-42210 Repair/Maint. Supplies 6,131 9,453 5,481 11,000 8,150 74.1%11,000 11,000 0% 101-430-3100-42212 Repair/Maint. Supplies S&I 9,484 11,004 10,414 11,000 5,636 51.2%11,000 11,000 0% 101-430-3100-42240 Street Maintenance & Landscaping - Materials 22,135 46,643 12,635 30,000 25,853 86.2%26,000 26,000 -13%less pothole filling as we redo streets. 101-430-3100-42260 Street Signs 4,020 3,422 4,254 4,000 350 8.8%4,000 4,000 0% 101-430-3100-42290 Sand/Salt S&I 111,880 55,575 57,401 62,000 67,773 109.3%67,773 97,000 56%$20 increase per ton 101-430-3100-42400 Small Tools & Minor Equipment 3,095 3,784 4,223 25,040 16,064 64.2%25,000 5,000 -80%purchased trailers in 2023, none planned for 24. 101-430-3100-44375 Personal Protection Equipment 1,411 312 746 1,200 285 23.7%1,200 1,200 0% Total Materials and Supplies 188,759$ 160,759$ 145,613$ 197,740$ 169,550$ 85.7%205,473$ 212,700$ 8% Charges and Services101-430-3100-43030 Engineering Services 12,938 10,044 9,934 14,000 21,250 151.8%15,000 16,000 14% 101-430-3100-43090 Sealcoating & Crack Sealing 552,506 592,656 817,304 600,000 2,788 0.5%600,000 - -100%moved to a Transfer to Street Maint Fund. 101-430-3100-43150 Contract Services 18,572 28,255 14,139 $43,399 23,334 53.8%32,000 45,000 4%2023 lack of rain, minimal mowing 101-430-3100-43185 IT Support 11,185 8,886 18,509 13,231 9,418 71.2%15,273 15% 101-430-3100-42002 IT Hardware 743 - - #DIV/0!- 2,032 #DIV/0!SCADA, Jim, Rick, 2 gen. use. -- spread across 5 PW depts. 101-430-3100-43190 Software Programs 3,662 6,544 4,297 8,400 12,958 154.3%8,400 8,400 0%Precise and Fuel Cloud 101-430-3100-43210 Telephone 3,840 4,472 4,413 4,800 1,790 37.3%4,800 2,599 -46%improved accuracy in allocations.101-430-3100-43230 Radio 4,001 4,121 6,834 6,750 2,200 32.6%6,750 6,750 0% 101-430-3100-43310 Mileage - 125 - 0.0%125 125 0% 101-430-3100-43510 Public Notices 134 - 212 - 0.0%200 200 -6% 101-430-3100-43630 Insurance 23,443 23,562 24,915 27,407 12,336 45.0%11,525 -58% 101-430-3100-43810 Utilities 31,544 24,891 31,704 37,500 21,571 57.5%37,500 39,000 4% 101-430-3100-43811 Street Lights 41,778 54,087 59,005 49,000 37,829 77.2%60,000 65,000 33%expected increase in elect. Prices. 101-430-3100-43840 Refuse 5,294 9,121 7,584 6,450 4,886 75.7%6,500 7,000 9%101-430-3100-44010 Repairs/Maint Bldg.4,488 6,313 9,883 12,000 5,361 44.7%9,500 9,750 -19% 101-430-3100-44030 Repairs/Maint Imp Other Than Bldg.2,848 579 - 900 - 0.0%950 950 6% 101-430-3100-44040 Repairs/Maint Equip 9,971 14,598 18,128 20,000 6,634 33.2%17,500 20,000 0% 101-430-3100-44041 Repairs/Maint Equip S&I 13,504 7,699 11,789 13,000 3,934 30.3%11,000 13,000 0% 101-430-3100-44130 Equipment Rental 1,845 1,065 1,250 3,317 265.4%3,500 1,250 0% 101-430-3100-44170 Uniforms 5,531 4,783 4,521 5,200 3,733 71.8%5,200 5,200 0% 101-430-3100-44330 Dues & Subscriptions 614 323 482 750 1,712 228.3%1,100 1,200 60% 101-430-3100-44370 Conferences & Training 463 1,529 3,057 4,175 2,389 57.2%4,000 4,000 -4% Total Charges and Services 748,161$ 803,206$ 1,047,563$ 868,548$ 177,440$ 20.4%824,025$ 274,254$ -68% Capital Outlay101-430-3100-47200 Transfer to Vehicle Replacement Fund 86,963 90,683 - 0.0%90,683 90,558 0%See CIP for future purchases. 101-430-3100-47NEW Transfer to Street Maintenance Fund (New Fund)- 600,000 #DIV/0!establish account to Transfer to new Street Maintenance Fund. 101-480-3100-45500 Capital Purchases - 53,038 25,000 75,316 301.3%25,000 36,500 #REF!PW generator (split allocation), Loader Grapple Total Capital Outlay -$ 140,001$ 115,683$ 75,316$ 65.1%115,683$ 727,058$ 528% 14 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes Miscellaneous 101-430-3100-44300 Miscellaneous 689 541 1,929 700 497 71.1%700 700 0% Total Miscellaneous 689$ 541$ 1,929$ 700$ 497$ 71.1%700$ 700$ 0% - - 3100 Total Streets 1,476,020$ 1,488,448$ 1,902,740$ 1,797,064$ 886,528$ 49.3%1,824,102$ 1,812,018$ 1% - - 15 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 5200 Parks & Recreation Personnel 101-450-5200-41010 Full-time Salaries 93,671 86,833 95,997 114,660 69,120 60.3%80,756 123,425 8% 101-450-5200-41040 Temporary Employees 605 5,054 9,803 15,300 288 1.9%10,000 9,620 -37%101-450-5200-41210 PERA Contributions 7,366 6,473 7,195 8,599 5,171 60.1%6,032 9,257 8% 101-450-5200-41220 FICA Contributions 6,443 5,483 6,255 8,058 4,121 51.1%4,833 8,249 2% 101-450-5200-41230 Medicare Contributions 1,510 1,282 1,462 1,884 964 51.2%1,130 1,929 2% 101-450-5200-41300 Insurance 18,768 16,471 19,281 24,031 9,959 41.4%12,530 24,995 4% 101-450-5200-41325 Life Insurance 82 69 352 96 42 43.5%51 111 15% 101-450-5200-41330 STD/LTD 713 443 461 617 314 50.9%395 657 7% 101-450-5200-41600 Safety Clothing Allowance 240 350 320 270 100 37.0%270 270 0%101-450-5200-41420 Unemployment Benefits 952 - #DIV/0!- - #DIV/0! 101-450-5200-41510 Workers Compensation 9,910 4,145 3,018 3,866 4,171 107.9%3,866 4,512 17% Total Personnel 148,001$ 126,603$ 145,142$ 177,381$ 94,251$ 53.1%119,862$ 183,024$ 3% - Materials and Supplies - 101-450-5200-42000 Office Supplies 43 126 457 450 160 35.6%450 450 0% 101-450-5200-42120 Fuel, Oil and Fluids 4,702 8,178 11,444 9,000 9,902 110.0%9,500 10,800 20%101-450-5200-42150 Operating Supplies 444 643 964 800 558 69.8%750 800 0% 101-450-5200-42160 Chemicals 201 - 750 56 7.5%500 500 -33% 101-450-5200-42210 Repair/Maint. Supplies 9,479 7,055 11,334 8,600 6,977 81.1%8,600 8,600 0% 101-450-5200-42230 Building Repair Supplies 360 760 500 - 0.0%450 500 0% 101-450-5200-42250 Landscaping Materials 562 456 2,392 2,000 1,086 54.3%2,000 2,000 0% 101-450-5200-42400 Small Tools & Minor Equipment 4,752 1,980 3,597 9,557 6,593 69.0%9,557 3,500 -63% Total Materials and Supplies 20,183$ 18,798$ 30,948$ 31,657$ 25,333$ 80.0%31,807$ 27,150$ -14% Charges and Services 101-450-5200-43030 Engineering Services - - - #DIV/0!- - #DIV/0! 101-450-5200-43150 Contracted Services 77,697 49,494 46,300 $142,465 68,346 48.0%120,000 152,000 7%101-450-5200-43185 IT Support 5,844 5,774 4,108 3,830 3,149 82.2%382960.0%5,097 33% 101-450-5200-42002 IT Hardware - - - #DIV/0!- 544 #DIV/0!SCADA, Jim, Rick, 2 gen. use. -- spread across 5 PW depts. 101-450-5200-43190 Software Programs - - - #DIV/0!- - #DIV/0! 101-450-5200-43210 Telephone 1,290 878 631 1,750 713 40.8%1,750 2,039 17% 101-450-5200-43630 Insurance 7,144 7,180 7,593 8,352 22,890 274.1%2289019.0%23,717 184% 101-450-5200-43810 Utilities 8,707 10,529 11,754 11,555 6,736 58.3%11,555 12,500 8%added Fire2 gas and electric 101-450-5200-43840 Refuse 3,166 3,887 3,580 4,250 2,717 63.9%4,250 4,250 0%101-450-5200-44010 Repairs/Maint Bldg 4,570 2,125 3,439 3,000 1,665 55.5%3,000 3,000 0% 101-450-5200-44030 Repairs/Maint Imp Not Bldgs 4,480 2,071 964 4,000 2,021 50.5%3,000 3,000 -25% 101-450-5200-44040 Repairs/Maint Eqpt 1,688 6,292 1,082 10,000 3,595 36.0%5,500 6,500 -35% 101-450-5200-44120 Rentals - Buildings 6,712 8,909 8,203 8,850 6,124 69.2%- 8,880 0% 101-450-5200-44170 Uniforms 930 953 930 1,200 820 68.3%1,200 1,200 0% 101-450-5200-44301 Events 544 482 550 537 97.6%537 550 0% 101-450-5200-44302 Lakes 14,956 15,000 15,000 15,000 5,000 33.3%15,000 15,000 0%101-450-5200-44330 Dues & Subscriptions 60 - - 167 #DIV/0!19 75 #DIV/0! 101-450-5200-44370 Conferences & Training 2,828 815 317 3,000 930 31.0%2,500 2,000 -33% 101-450-5200-44130 Equipment Rental 415 73 882 750 850 113.3%500 650 -13% 101-450-5200-44375 Personal Protection Equipment 435 136 400 78 19.5%250 250 -38%Total Charges and Services 141,466$ 113,980$ 105,401$ 218,952$ 126,338$ 57.7%195,781$ 241,251$ 10% Capital Outlay101-450-5200-47200 Transfer to Vehicle Replacement Fund 1,961 2,298 - 0.0%2,298 3,228 40% Total Capital Outlay -$ 1,961$ 2,298$ -$ 0.0%2,298$ 3,228$ 40% Miscellaneous 101-450-5200-44300 Miscellaneous 416 309 1,300 750 4,003 533.8%700 550 -27% Total Miscellaneous 416$ 309$ 1,300$ 750$ 4,003$ 533.8%700$ 550$ -27% - - 5200 Total Parks & Recreation 310,066$ 259,690$ 284,752$ 431,038$ 249,926$ 58.0%350,448$ 455,204$ 6% 16 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 9000 Transfers Transfers 101-900-9000-47205 Operating Transfer to EDA 30,000 30,000 - - #DIV/0!#DIV/0! 101-900-9000-47201 Transfer to Project Fund 15,661 30,000 102,074 16,902 #DIV/0!#DIV/0! 101-900-9000-47200 Transfer to Vehicle Replacement Fund 903,847 - - #DIV/0!#DIV/0!manu 101-900-9000-47250 Transfer to Vehicle Replacement Fund 100,000 150,000 - 250,000 - 0.0%167,328 -33%manu Total Transfers 1,049,508$ 210,000$ 102,074$ 250,000$ 16,902$ #DIV/0!250,000$ 167,328$ -33% 9000 Total Transfers 1,049,508$ 210,000$ 102,074$ 250,000$ 16,902$ 6.8%250,000$ 167,328$ -33% 9001 Contingency Reserve Contingency Reserve Reserve - 35,000 - 0.0%35,000$ 0% Total Contingency Reserve - 35,000$ - 0.0%-$ 35,000$ 0% 9001 Total Contingency Reserve -$ 35,000$ -$ 0.0%-$ 35,000$ 0% General Fund Expenditure Summary 2020 Actual 2021 Actual 2022 Actual 2023 Budget Q3 % to Budget 2023 Projected 2024 Budget 1110 Mayor & Council 49,246$ 54,630$ 53,123$ 59,960$ 43,158$ 72%58,581$ 66,121$ 10% 1320 Administration 525,679$ 450,883$ 454,233$ 620,040$ 270,904$ 44%510,362$ 660,504$ 7% 1410 Elections 13,043$ 5,112$ 12,556$ 3,200$ 3,525$ 110%3,200$ 16,658$ 421% 1450 Communications 42,904$ 44,442$ 22,978$ 81,098$ 32,822$ 40%81,098$ -$ -100% 1520 Finance 79,622$ 140,811$ 115,100$ 266,403$ 119,411$ 45%124,304$ 280,813$ 5%1910 Planning & Zoning 236,343$ 301,327$ 278,311$ 404,476$ 139,288$ 34%156,250$ 473,189$ 17% 1930 Engineering Services 30,000$ 30,000$ 30,975$ 35,000$ 22,785$ 65%35,000$ 35,000$ 0% 1940 City Hall 28,012$ 30,013$ 45,996$ 66,819$ 52,828$ 79%66,819$ -$ -100% 2100 Police 761,969$ 901,120$ 947,044$ 1,049,784$ 524,626$ 50%1,049,784$ 1,310,573$ 25% 2150 Prosecution 48,392$ 50,212$ 48,141$ 50,000$ 32,841$ 66%50,000$ 50,000$ 0% 2220 Fire 642,344$ 725,670$ 893,746$ 1,540,881$ 702,725$ 46%1,173,590$ 1,642,953$ 7% 2250 Fire Relief 76,608$ 80,470$ -$ 80,000$ -$ 0%80,000$ -$ -100% 2400 Building Inspection 1,098,325$ 1,231,520$ 808,520$ 932,259$ 447,885$ 48%660,169$ 1,114,889$ 20% 2500 Emergency Communications 900$ 1,514$ 20,501$ 4,500$ 3,537$ 79%4,500$ 4,500$ 0% 2700 Animal Control 13,066$ 14,161$ 13,550$ 13,000$ 9,885$ 76%14,392$ 14,500$ 12% 3100 Streets 1,476,020$ 1,488,448$ 1,902,740$ 1,797,064$ 886,528$ 49%1,824,102$ 1,812,018$ 1%5200 Parks & Recreation 310,066$ 259,690$ 284,752$ 431,038$ 249,926$ 58%350,448$ 455,204$ 6% 9000 Transfers 1,049,508$ 210,000$ 102,074$ 250,000$ 16,902$ 7%250,000$ 167,328$ -33% 9001 Contingency Reserve -$ -$ -$ 35,000$ -$ 0%-$ 35,000$ 0% 6,482,047$ 6,020,023$ 6,034,340$ 7,720,521$ 3,559,574$ 46%6,492,599$ 8,139,250$ 5.42% #DIV/0! Total General Fund Expenditures:6,482,047$ 6,020,023$ 6,034,340$ 7,720,521$ 3,559,574$ 46.1%6,492,599$ 8,139,250$ 5% 8,139,250 Total Gen Fund Revs. Over/(Under) Expenditures:8,617$ 771,886$ 1,848,925$ -$ 26,476$ 974,034$ (0)$ 17 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 601 Water Fund Water Fund Revenues:601-000-0000-36100 Special Assessments 762 56,024 58,029 92,493 #DIV/0!- - #DIV/0! 601-000-0000-36101 Delinquent Special Assessments (932) - #DIV/0!- - #DIV/0! 601-000-0000-36102 Special Assessments Penalties & Interest (675) 386 547 66 #DIV/0!- - #DIV/0! 601-000-0000-36103 Prepaid Special Assessments 1 - - #DIV/0!- - #DIV/0! 601-000-0000-36210 Interest on Investments 128,678 (11,572) (66,764) 32,000 0%32,000 32,000 0%interest allocated at end of year. 601-000-0000-36211 Non-Cash Interest Allocations new account to record non-cash interest allocations 601-000-0000-37100 Water Sales 1,046,893 1,537,606 1,634,375 1,276,703 671,727 53%1,613,499 1,962,564 54%601-000-0000-37120 Bulk Water 3,381 710 - 2,000 - 0%2,000 33,455 1573% 601-000-0000-37130 Water Lat Benefit Fee 5,800 23,200 12,400 - 13,200 #DIV/0!13,200 - #DIV/0!none planned 601-000-0000-37140 Water Access Revenue 1,205,000 1,566,000 685,000 1,707,000 304,000 18%1,707,000 1,695,000 -1% 601-000-0000-37150 Water Connections - Municipal 522,000 515,000 383,000 458,000 192,000 42%458,000 605,000 32%601-000-0000-37170 Meter Sales 155,831 149,944 113,708 100,000 110,302 110%100,000 155,675 56%Total Water Fund Revenues:3,104,501$ 3,858,796$ 2,775,000$ 3,575,703$ 1,291,229$ 36.1%3,925,699$ 4,483,694$ 25% Water Fund Expenses: Personnel 601-494-9400-41010 Full-time Salaries 211,891 284,850 290,353 362,767 211,995 58%362,767 367,310 1% 601-494-9400-41020 Overtime 1,024 7,619 7,979 8,805 10,389 118%8,805 9,040 3% 601-494-9400-41210 PERA Contributions 14,164 26,490 64,026 27,868 16,677 60%27,868 27,548 -1%601-494-9400-41216 MSRS Contributions - City Admin 557 634 657 463 70%657 701 7% 601-494-9400-41220 FICA Contributions 11,334 16,906 17,069 23,038 13,229 57%23,038 23,334 1% 601-494-9400-41230 Medicare Contributions 2,666 3,958 4,003 5,388 3,095 57%5,388 5,457 1% 601-494-9400-41300 Insurance 37,591 57,711 57,068 73,313 43,857 60%73,313 74,341 1% 601-494-9400-41325 Life Insurance 183 231 243 270 162 60%270 299 11% 601-494-9400-41330 STD/LTD 1,301 1,429 1,514 1,802 1,146 64%1,802 2,008 11% 601-494-9400-41301 Unemployment Insurance - - #DIV/0!- - #DIV/0!601-494-9400-41600 Safety Clothing Allowance 370 546 675 665 207 31%665 665 0% 601-494-9400-41510 Workers Compensation 6,984 7,853 5,718 7,324 9,833.01 134%9,833 6,692 -9% Total Personnel 294,891$ 408,150$ 453,261$ 511,897$ 311,053$ 60.8%514,406$ 517,395$ 1% Materials and Supplies #DIV/0! 601-494-9400-42000 Office Supplies 676 476 954 800 76 10%800 800 0% 601-494-9400-42120 Fuel, Oil and Fluids 6,282 8,878 10,272 9,500 7,090 75%9,250 10,500 11%601-494-9400-42030 Printed Forms 610 958 1,504 850 335 39%850 850 0% 601-494-9400-42150 Operating Supplies 2,276 3,572 763 3,000 1,516 51%2,500 2,500 -17% 601-494-9400-42160 Chemicals 5,089 8,429 14,307 12,000 11,331 94%12,000 12,000 0% 601-494-9400-42210 Repair/Maint. Supplies 6,072 5,512 11,170 10,000 8,890 89%9,000 10,000 0%601-494-9400-42300 Water Meters & Supplies 157,615 179,885 160,718 200,000 71,794 36%125,000 200,000 0%waiting for backordered 2023 mxus and meters yet 601-494-9400-44375 Personal Protective Equipment 801 378 297 800 - 0%650 650 -19% 601-494-9400-42400 Small Tools & Minor Equipment 4,840 3,886 3,779 10,572 4,696.64 44%9,500 4,500 -57% Total Materials and Supplies 184,261$ 211,974$ 203,766$ 247,522$ 105,730$ 42.7%169,550$ 241,800$ -2% Charges and Services #DIV/0! 601-494-9400-43030 Engineering Services 7,073 7,119 3,430 25,000 26,342 105%25,000 25,000 0%601-494-9400-43040 Legal Services 12,804 12,521 40,000 23,901 60%21,796 80,000 100%add lobbyist 601-494-9400-43010 Audit Services 9,105 8,608 8,244 8,967 9,825 110%11,425 11,425 27% 601-494-9400-43090 Newsletter 1,122 1,187 709 1,550 - 0%1,533 1,610 4% 601-494-9400-43150 Contract Services 45,352 38,785 45,472 46,000 65,827 143%46,000 50,000 9% 601-494-9400-43185 IT Support 8,860 8,680 10,417 11,558 8,301 72%11,558 13,190 14% 601-494-9400-42002 IT Hardware 1,030 - 268 - 0%- 2,520 842%SCADA, Jim, Rick, 2 gen. use. -- spread across 5 PW depts. 601-494-9400-43190 Software Programs 11,875 7,897 10,354 13,000 6,251 48%13,000 13,500 4%banyon, Fuel Cloud, .. 601-494-9400-43210 Telephone 1,508 1,603 1,925 2,200 1,434 65%2,200 2,709 23% 601-494-9400-43220 Postage 2,259 1,972 3,397 2,723 2,020 74%3,500 3,675 35% 601-494-9400-43310 Mileage 65 51 200 94 47%189 200 0% 1 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 601-494-9400-43610 Insurance 10,552 10,605 11,215 12,337 25,923 210%25,923 24,996 103% 601-494-9400-43810 Electric Utility 59,223 108,409 138,488 95,000 87,114 92%138,488 150,000 58%601-494-9400-43820 Water Utility 27,432 30,057 36,393 35,000 23,280 67%36,000 43,850 25%MDH + DNR Fee increase 601-494-9400-44030 Repairs\Maint Imp Not Bldgs 11,900 15,028 66,291 45,000 24,986 56%30,000 35,000 -22% 601-494-9400-44040 Repairs\Maint. Equip.4,877 1,464 4,443 8,000 750 9%5,000 7,000 -13% 601-494-9400-44010 Repairs\Maint Imp Bldgs 4,130 3,136 14,224 18,000 4,321 24%13,000 15,000 -17% 601-494-9400-44150 Equipment Rental 800 1,600 800 1,600 1,600 100%2,400 2,400 50%3wks valve excersizer 601-494-9400-44170 Uniforms 851 880 873 1,000 762 76%1,000 1,000 0% 601-494-9400-44330 Dues & Subscriptions 360 300 450 400 170 43%400 400 0%601-494-9400-44370 Conferences & Training 142 3,964 3,676 4,000 1,891 47%2,000 2,500 -38%utilizing more free classes and less staff needing new licenses 601-494-9400-44377 Credit Card Fees 9,017 10,931 11,223 12,381 6,541 53%12,381 12,500 1% 601-494-9400-44386 Real Estate Taxes 23,084 23,474 15,416 - - #DIV/0!- - #DIV/0! Total Charges and Services 240,617$ 299,478$ 400,131$ 393,999$ 321,334$ 81.6%402,792$ 498,474$ 27% Capital Outlay #DIV/0! 601-494-9400-45300 Improvments Other Than Bldgs - 15,425 - 1,066,778 25,800.00 2.4%- 4,605,875 332%debt issuanceTotal Capital Outlay -$ 15,425$ -$ 1,066,778$ 25,800$ 2.4%-$ 4,605,875$ 332% #DIV/0! Miscellaneous and Non-operating #DIV/0! 601-494-9400-43320 Depreciation Expense 1,868,224 - #DIV/0!#DIV/0! 601-494-9400-44300 Miscellaneous 908 542 1,139 2,000 1,592 80%2,000 -100% 601-494-9400-46010 Bond Principal 825,000 1,240,000 900,000 73%1,200,000 1,120,000 -10%Not operating cost > Decrease in Liabilities 601-494-9400-46110 Bond Interest 244,340 219,564 271,308 329,256 348,670 106%376,643 374,262 14% 601-494-9400-46350 Bond Issuance Costs - - #DIV/0!- 94,125 #DIV/0! Total Misc. and Non-operating 245,743$ 220,766$ 1,097,942$ 1,571,256$ 1,250,262$ 79.6%1,578,643$ 1,588,387$ 1% Prior Period Adjustments - - Total Water Fund Expenses:965,512$ 1,155,793$ 2,155,099$ 3,791,452$ 2,014,178$ 53%2,665,390.75$ 7,451,931.69$ 97% Net Water Fund Revs. Over/(Under) Expenses:2,138,989$ 2,703,003$ 619,901$ (215,749)$ (722,949)$ (0)$ 1,260,308$ (2,968,238)$ 1276% 2 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 602 Sewer Fund Sewer Fund Revenues: 602-000-0000-36100 Special Assessments (10,254) 1,545,648 1,458,154 291,368 #DIV/0!#DIV/0! 602-000-0000-36101 Delinquent Special Assessments 2,628 - #DIV/0!- - #DIV/0! 602-000-0000-36102 Special Assessments Penalties & Interest 1,710 594 684 270 #DIV/0!- - #DIV/0!602-000-0000-36103 Prepaid Special Assessments 171,577 - 39,300 #DIV/0!- - #DIV/0! 602-000-0000-36210 Interest on Investments 142,328 (7,335) (138,866) 36,000 259,065 720%2,500 2,500 -93% 602-000-0000-37200 Sewer Sales 354,947 539,130 671,283 621,476 370,394 60%767,375 843,721 36% 602-000-0000-37220 SAC Early Pay discount/revenue 17,375 8,996 8,599 8,500 7,132 84%8,500 -100% 602-000-0000-37230 Sewer Lat Benefit Fee 48,800 25,000 13,100 - 13,700 #DIV/0!- - #DIV/0! 602-000-0000-37240 Sewer Availability Charges (SAC)1,256,997 1,491,000 477,500 1,450,350 314,500 22%940,500 1,678,500 16% 602-000-0000-37260 Sewer Connection Fees Municipa 533,500 482,000 310,500 344,500 199,500 58%365,000 611,000 77% 602-000-0000-39200 Transfer In 100,000 Total Sewer Fund Revenues:2,347,314$ 4,258,051$ 1,342,307$ 2,460,826$ 1,164,291$ 47.3%2,083,875$ 3,235,721$ 31% Sewer Fund Expenses: Personnel 602-495-9450-41010 Full-time Salaries 87,537 104,267 131,072 155,383 103,070 66%155,383 161,099 4% 602-495-9450-41020 Overtime 108 7,265 8,581 9,569 7,041 74%9,569 8,402 -12%602-495-9450-41210 PERA Contributions 5,261 (10,523) 30,413 12,371 8,258 67%12,371 12,082 -2% 602-495-9450-41216 MSRS Contributions -City Admin 279 317 329 231 70%329 351 7% 602-495-9450-41220 FICA Contributions 4,197 6,619 8,013 10,227 6,568 64%10,227 10,509 3% 602-495-9450-41230 Medicare Contributions 991 1,550 1,881 2,392 1,535 64%2,392 2,458 3% 602-495-9450-41300 Insurance 11,983 21,870 27,098 33,171 21,362 64%33,171 33,348 1% 602-495-9450-41325 Life Insurance 50 83 115 104 73 70%104 115 11% 602-495-9450-41330 STD/LTD 420 496 738 754 522 69%754 876 16%602-495-9450-41600 Safety Clothing Allowance - 140 225 161%140 140 0% 602-495-9450-41301 Unemployment Insurance - - #DIV/0!- - #DIV/0! 602-495-9450-41510 Workers Compensation 4,197 2,716 1,978 2,533 4,104.36 162%4,104 2,586 2% Total Personnel 114,744$ 134,622$ 211,487$ 226,973$ 152,990$ 67.4%228,544$ 231,965$ 2% #DIV/0! Materials and Supplies #DIV/0! 602-495-9450-42210 Repair/Maint. Supplies 880 2,689 10,435 12,000 750 6%6,000 12,000 0% 602-495-9450-42000 Office Supplies 163 438 490 450 241 54%400 400 -11% 602-495-9450-42030 Printed Forms 451 594 600 650 335 52%600 600 -8% 602-495-9450-42120 Fuel, Oil and Fluids 6,863 8,871 11,742 9,000 7,427 83%9,500 10,750 19% 602-495-9450-42150 Operating Suppies 959 663 412 1,000 250 25%750 750 -25%602-495-9450-42270 Repair/Maint. Supplies 7,612 77 396 - #DIV/0!- - #DIV/0! 602-495-9450-44375 Personal Protective Equipment 466 193 538 450 45 10%400 400 -11% 602-495-9450-42400 Small Tools & Minor Equipment 2,480 2,117 1,821 7,071 3,799.16 54%6,500 5,000 -29% Total Materials and Supplies 19,874$ 15,642$ 26,434$ 30,621$ 12,847$ 42.0%24,150$ 29,900$ -2% #DIV/0! Charges and Services #DIV/0! 602-495-9450-43030 Engineering Services 6,950 1,875 894 12,500 210 2%12,000 12,000 -4%602-495-9450-43010 Audit Services 9,105 8,608 8,244 8,967 9,825 110%8,967 11,425 27% 602-495-9450-43090 Newsletter 1,122 1,187 709 1,550 - 0%1,533 1,610 4% 602-495-9450-43150 Contract Services 36,059 35,264 34,367 52,500 47,792 91%47,000 52,500 0% 602-495-9450-43185 IT Support 5,170 5,123 5,158 5,015 3,937 79%5,015 6,006 20% 602-495-9450-42002 IT Hardware 821 - 134 128 96%- 2,520 1784%SCADA, Jim, Rick, 2 gen. use. -- spread across 5 PW depts. 602-495-9450-43190 Software Programs 9,925 8,772 8,404 12,670 4,301 34%10,000 11,000 -13%Beehive, Fuel cloud, Banyon 602-495-9450-43210 Telephone 2,436 2,597 1,965 3,150 1,133 36%3,150 2,065 -34%602-495-9450-43220 Postage 2,251 1,448 2,222 3,500 2,020 58%3,500 3,675 5% 602-495-9450-43310 Mileage - - - - #DIV/0!- - #DIV/0! 602-495-9450-43610 Insurance 4,212 4,234 4,477 4,925 15,790 321%15,790 16,372 232% 602-495-9450-43810 Electric Utility 14,889 19,630 24,076 18,750 15,786 84%24,557 30,000 60% 602-495-9450-43820 Sewer Utility - Met Council 229,887 265,011 422,284 526,216 438,939 83%526,216 644,326 22%22.45% increase 3 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 602-495-9450-44010 Repairs/Maint Imp Bldgs 1,181 591 1,000 1,000 100%950 1,000 0%602-495-9450-44040 Repairs/Maint. Equip.3,689 3,387 6,699 4,500 3,777 84%4,500 4,500 0% 602-495-9450-44150 Equipment Rental 6,500 7,000 9,063 8,250 11,500 139%8,250 1,500 -82%purchase vac truck 2024 so no rental 602-495-9450-44170 Uniforms 487 546 458 600 502 84%600 600 0% 602-495-9450-44030 Repairs\Maint Imp Not Bldgs 7,804 5,282 14,785 4,500 11,247 250%12,500 6,500 44%602-495-9450-44370 Conferences & Training 1,826 1,600 2,919 3,500 2,472 71%2,500 2,500 -29% 602-495-9450-44377 Credit Card Fees 9,017 10,931 11,223 12,381 6,540.61 53%12,381 13,000 5% Total Charges and Services 352,150$ 383,676$ 558,537$ 697,277$ 576,899$ 82.7%699,409$ 823,098$ 18% #DIV/0! Capital Outlay #DIV/0! 602-495-9450-45300 Improvements Other Than Bldgs - - 3,208 309,102 30,335.00 10%- 289,102 -6% Total Capital Outlay -$ -$ 3,208$ 309,102$ 30,335$ 9.8%-$ 289,102$ -6%#DIV/0! Miscellaneous and Non-operating #DIV/0! 602-495-9450-44300 Miscellaneous Expenses 790 70 500 87 17%350 350 -30% 602-495-9450-46010 Bond Principal - 995,000 915,000 92%915,000 950,000 -5%Not operating expense > Decrease in Liability 602-495-9450-46110 Bond Interest 165,205 134,538 257,775 260,376 350,080 134%350,080 397,495 53% Total Misc. and Non-operating 165,995$ 134,703$ 257,845$ 1,255,876$ 1,265,167$ 100.7%1,265,430$ 1,347,845$ 7% Prior Period Adjustment - - Total Sewer Fund Expenses:652,763$ 668,643$ 1,057,512$ 2,519,848$ 2,038,238$ 80.9%2,217,534$ 2,721,910$ 8% Net Sewer Fund Revs. Over/(Under) Expenses:1,694,551$ 3,589,408$ 284,795$ (59,022.47)$ (873,947.39)$ (133,658.77)$ 513,810.82$ -971% 4 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 603 Stormwater Fund Stormwater Fund Revenues: 603-000-0000-36100 Special Assessments 25,578 124 (904) 15,868 #DIV/0!- - #DIV/0!603-000-0000-36101 Delinquent Special Assessments 904 - #DIV/0!- - #DIV/0! 603-000-0000-36102 Special Assessment Penalties/Interest 78 253 30 #DIV/0!- - #DIV/0! 603-000-0000-36210 Interest on Investment 15,344 (2,038) (15,423) 4,400 29,314 666%4,400 4,400 0% 603-000-0000-37300 Surface Water Utility Sales 314,959 457,517 507,204 551,984 189,549 34%551,984 597,622 8% 603-000-0000-34113 SW Review Fee Revenue 46,380 46,520 33,528 35,000 26,773 76%35,000 36,050 3% Total Stormwater Fund Revenues:402,261$ 502,201$ 525,869$ 591,384$ 261,534$ 44.2%591,384$ 638,072$ 8% Stormwater Fund Expenses: Personnel 603-496-9500-41010 Full-time Salaries 46,070 57,921 77,290 80,283 45,634 57%80,283 89,117 11% 603-496-9500-41030 Part-time Salaries - - #DIV/0!- - #DIV/0! 603-496-9500-41020 Overtime 169 427 - 500 - 0%500 - -100% 603-496-9500-41040 Temporary Employees - - #DIV/0!- - #DIV/0!603-496-9500-41210 PERA Contributions 2,856 (10,903) 17,472 6,059 3,424 57%6,059 6,684 10% 603-496-9500-41216 MSRS Contributions -City Admin 139 159 164 116 70%164 175 7% 603-496-9500-41220 FICA Contributions 2,305 3,557 4,432 5,009 2,731 55%5,009 5,525 10% 603-496-9500-41230 Medicare Contributions 545 833 1,039 1,171 639 55%1,171 1,292 10% 603-496-9500-41300 Insurance 5,750 13,475 16,087 17,406 9,806 56%17,406 18,601 7% 603-496-9500-41325 Life Insurance 21 44 67 50 25 51%50 59 18% 603-496-9500-41330 STD/LTD 197 282 421 392 207 53%392 488 24%603-496-9500-41415 OPEB Expense 812 - #DIV/0!- - #DIV/0! 603-496-9500-41600 Safety Clothing Allowance 125 125 125 125 100%125 125 0% 603-496-9500-41301 Unemployment Insurance - - #DIV/0!- - #DIV/0! 603-496-9500-41510 Workers' Compensation 2,029 1,060 772 989 5,294.31 535%989 1,904 93%Total Personnel 59,942$ 66,960$ 118,676$ 112,148$ 68,002$ 60.6%112,148$ 123,971$ 11% #DIV/0! Materials and Supplies #DIV/0!603-496-9500-42000 Office Supplies 129 54 357 350 - 0%350 300 -14% 603-496-9500-42120 Fuel, Oil and Fluids 3,460 1,444 4,397 3,850 1,139 30%3,850 4,500 17% 603-496-9500-42030 Printed Forms 513 594 600 550 177 32%550 550 0% 603-496-9500-42270 Repair/Maint. Maint Supplies 34 3,413 1,265 2,450 708 29%2,000 2,500 2%603-496-9500-42150 Operating Supplies 68 9 - - #DIV/0!- - #DIV/0! 603-496-9500-44375 Personal Protective Equipment 508 (200) 411 - - #DIV/0!- - #DIV/0! 603-496-9500-42400 Small Tools & Minor Equipment 3,004 250 2,457 2,500 1,400.00 56%2,000 2,000 -20% Total Materials and Supplies 7,716$ 5,555$ 9,495$ 9,700$ 3,424$ 35.3%8,750$ 9,850$ 2% #DIV/0! Charges and Services #DIV/0! 603-496-9500-43030 Engineering Services 5,954 10,616 4,677 12,500 7,695 62%12,500 12,500 0%603-496-9500-43010 Audit Services 9,105 8,608 8,244 8,967 9,825 110%8,967 11,425 27% 603-496-9500-43040 Legal Services - - - #DIV/0!- - #DIV/0! 603-496-9500-43150 Contract Services 12,639 7,903 5,650 8,000 7,833 98%7,500 7,500 -6% 603-496-9500-43180 Software Support - - #DIV/0!- - #DIV/0! 603-496-9500-43185 IT Support 5,047 4,698 3,362 2,584 2,314 90%2,584 3,021 17% 603-496-9500-42002 IT Hardware 430 - 134 - 0%- 624 367%SCADA, Jim, Rick, 2 gen. use. -- spread across 5 PW depts. 603-496-9500-43190 Software Programs 9,728 7,797 8,059 12,000 4,297 36%12,000 12,000 0%603-496-9500-43210 Telephone 947 1,018 572 1,200 282 23%1,200 441 -63% 603-496-9500-44377 Credit Card Fees 3,053 4,952 3,539 71%4,952 5,200 5% 603-496-9500-43220 Postage 1,249 5,173 2,000 (1,445) -72%2,000 2,100 5% 603-496-9500-43510 Legal Publishing - - - #DIV/0!- - #DIV/0! 603-496-9500-43610 Insurance 6,615 6,647 7,029 7,732 3,728 48%7,732 3,793 -51% 603-496-9500-43810 Utilities - - #DIV/0!- - #DIV/0! 603-496-9500-44010 Street Sweeping 19,866 17,230 33,421 30,000 27,168 91%36,000 32,000 7%more chip seal to sweep up in 2023, less to sweep in 2024603-496-9500-44040 Repairs/Maint Equip 616 1,949 2,500 - 0%2,000 2,500 0% 5 City of Lake Elmo 2024 Final Budget compare to budget pdf! 2020 2021 2022 2023 2023 Q3 YTD 2023 2024 % Change BudgetAccount Number Description Actual Actual Actual Adopted Q3 % of Budget Projected Proposed vs. 23 Adopted Notes 603-496-9500-44030 Repairs/Maint Not Bldg 16,787 - 25,000 - 0%5,500 25,000 0%no issues found yet with minimal rain603-496-9500-44150 Equipment Rental 500 3,500 1,813 1,500 3,500 233%1,500 750 -50%vac truck addition will reduce rental 603-496-9500-44170 Uniforms 196 180 185 225 140 62%225 225 0% 603-496-9500-44330 Dues & Subscriptions 780 800 831 104%900 915 14% 603-496-9500-44370 Conferences & Training 675 854 1,664 1,000 - 0%500 650 -35%Total Charges and Services 89,738$ 69,667$ 85,629$ 121,094$ 69,707$ 57.6%106,060$ 120,644$ 0% #DIV/0! Capital Outlay #DIV/0! 603-496-9500-45300 Improvements Other Than Bldgs 24,185 - - - #DIV/0!- 800,000 #DIV/0! Total Capital Outlay 24,185$ -$ -$ -$ #DIV/0!-$ 800,000$ #DIV/0! #DIV/0! Miscellaneous and Non-operating #DIV/0!603-496-9500-43320 Depreciation Expense 691,840 - #DIV/0!- - #DIV/0! 603-496-9500-44300 Miscellaneous Expenses 83 780 538 1,500 - 0%750 800 -47% 603-496-9500-46010 Bond Principal - 210,000 210,000 100%210,000 215,000 2% 603-496-9500-46110 Bond Interest 54,015 49,359 45,005 48,288 48,288 100%48,288 43,738 -9%Total Misc. and Non-operating 54,098$ 50,139$ 737,382$ 259,788$ 258,288$ 99.4%259,038$ 259,538$ 0% Prior Period Adjustment #DIV/0! Total Stormwater Fund Expenses:211,494$ 216,506$ 951,183$ 502,730$ 399,421$ 79.5%485,996$ 1,314,003$ Net Stormwater Fund Revs. Over/(Under) Expenses:190,767$ 285,695$ (425,314)$ 88,654$ (137,887)$ 105,388$ (675,931)$ 6 CITY OF LAKE ELMO WASHINGTON COUNTY STATE OF MINNESOTA RESOLUTION NO. 2023-123 RESOLUTION ADOPTING THE 2024 GENERAL FUND BUDGET AND SETTING THE 2024 PROPERTY TAX LEVY WHEREAS, The City of Lake Elmo is required by State law to approve a resolution setting forth an annual property tax levy to the Washington County Auditor; and WHEREAS, Minnesota Statutes currently in force require approval of a property tax levy and a budget in December of each year; and WHEREAS, the City Council has received the budget documents; NOW THEREFORE BE IT RESOLVED by the City Council of the City of Lake Elmo, that the 2024 General Fund Budget shall be as follows: 2024 Adopted General Fund Revenues: Property Taxes $ 5,998,212 Licenses and Permit 933,580 Intergovernmental 269,555 Charges for Services 617,000 Fines and Forfeits 30,000 Interest on Investments 80,000 Miscellaneous 210,903 Total General Fund Revenues $ 8,139,250 General Fund Expenditures: Personnel $3,432,290 Materials and Supplies 322,830 Charges and Services 3,181,813 Capital Outlay 405,000 Miscellaneous 128,588 Transfers 250,000 Contingency Reserve 35,000 Total General Fund Expenditures $ 8,139,250 BE IT FURTHER RESOLVED that the Public Hearing was held on Tuesday December 5, 2023 at 7:00 p.m.; and BE IT FURTHER RESOLVED that the City Council of the City of Lake Elmo, Washington County, Minnesota, that the following sums of money be levied for collection in 2024 upon the taxable property in said City of Lake Elmo for the following purposes: 2024 Levy General Levy $ 5,998,212 Debt Service Levy 2,923,830 TOTAL LEVY $ 8,922,042 And BE IT FURTHER RESOLVED that the Finance Director is hereby authorized and directed to transmit this information to the County Auditor of Washington County, Minnesota and the Minnesota Department of Revenue, if applicable, in the format requested as required by law. ADOPTED, by the Lake Elmo City Council on the 5th day of December, 2023. ______________________________ Charles Cadenhead Mayor ATTEST: __________________________________ Julie Johnson City Clerk CITY OF LAKE ELMO WASHINGTON COUNTY STATE OF MINNESOTA RESOLUTION NO. 2023-124 RESOLUTION ADOPTING 2024 WATER, SEWER AND STORM WATER FUND BUDGETS WHEREAS, The City of Lake Elmo is to approve a resolution setting forth an annual budget for the Water, Sewer and Storm Water Funds; and WHEREAS, the City Council has received the budget document; NOW THEREFORE BE IT RESOLVED by the City Council of the City of Lake Elmo, that the 2024 Water, Sewer and Storm Water Fund Budgets shall be as follows: 2024 Water 2024 Sewer 2024 Storm Adopted Adopted Adopted Fund Revenues: Charges for Services $ 1,996,019 $ 843,721 $ 633,672 Connections 2,300,000 2,289,500 - Miscellaneous 155,675 100,000 - Interest on Investments 32,000 2,500 4,400 Total Fund Revenues $ 4,483,694 $ 3,235,721 $ 638,072 Fund Expenses: Personnel $ 517,395 $231,965 $ 123,971 Materials and Supplies 241,800 29,900 9,850 Charges and Services 498,474 823,098 120,644 Capital Outlay 4,605,875 289,102 800,000 Miscellaneous 1,588,387 1,347,845 259,538 Total Fund Expenses $ 7,451,932 $ 2,518,848 $ 1,314,003 ADOPTED, by the Lake Elmo City Council on the 5th day of December, 2023. ______________________________ Charles Cadenhead Mayor ATTEST: __________________________________ Julie Johnson City Clerk 11/28/2023CITY OF LAKE ELMO Financial Management Plan Clarissa's BudgetLong Range Budget Projections Column. Inflation Assumptions 1,901,616 2,032,729 2,541,182 Links to master budget. Need to open that file. 2,694,265 2,764,032 2,871,718 2,951,153 3,118,170 1 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% 2 Interest Earnings 1.50%1.50%1.50%1.50%1.50%1.58%1.65%1.74%4.00%4.00%4.00%4.00%4.00%4.20%3 Expenses 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4 CIP Inflation Factor 0.00%0.00%0.00%0.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% Budget e Proposed GENERAL FUND 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 REVENUE4General Property Tax 2,771,055 3,288,076 3,595,695 4,731,713 4,688,119 5,607,834 5,934,040 6,308,834 6,785,175 7,499,471 8,251,869 8,985,095 9,517,146 9,301,965 9,723,767 10,512,207 5 Fiscal Disparities 194,300 245,389 269,390 294,157 433,046 389,878 347,997 362,208 380,979 388,599 396,371 404,299 412,385 420,633 429,046 437,627 6 Penalties and Interest on Taxes 1,038 1,162 79 944 100 500 500 500 500 500 500 500 500 500 500 500 7 Special Assessments - - 930 - - - - - - - - - - - - - 8 Intergovernmental 269,907 273,194 267,180 360,870 311,574 269,555 274,946 280,445 286,054 291,775 297,610 303,562 309,634 315,826 322,143 328,586 9 Licenses and Permits 1,055,038 1,425,695 1,485,658 1,633,379 1,256,495 933,580 952,252 761,801 777,037 792,578 808,430 824,598 841,090 857,912 875,070 892,572 10 Charges for Services 884,885 1,022,028 1,064,375 742,281 754,625 617,000 629,340 641,927 654,765 667,861 681,218 694,842 708,739 722,914 737,372 752,120 11 Fines & Forfeits 36,696 33,584 45,749 2,966 30,000 30,000 30,600 31,212 31,836 32,473 33,122 33,785 34,461 35,150 35,853 36,570 12 Investment Income 118,298 164,236 (13,605) (81,535) 35,000 80,000 113,104 114,885 116,785 118,813 123,565 128,508 133,648 138,994 144,554 150,625 13 Miscellaneous Revenues 192,494 183,711 177,000 196,769 211,562 210,903 215,121 219,423 223,812 228,288 232,854 237,511 242,261 247,106 252,049 257,090 14 Total Revenue 5,523,711 6,637,075 6,892,451 7,883,265 7,720,521 8,139,250 8,497,899 8,721,235 9,256,944 10,020,357 10,825,539 11,612,700 12,199,864 12,041,001 12,520,354 13,367,896 EXPENSES 15 Current 16 General Government 1,136,908 1,005,254 1,056,983 1,013,272 1,536,996 1,532,285 1,593,576 1,657,319 1,723,612 1,792,556 1,864,259 1,938,829 2,016,382 2,097,037 2,180,919 2,268,156 17 Public Safety 1,948,269 2,641,770 3,003,677 2,591,798 3,383,405 3,966,202 4,124,850 4,289,844 4,461,438 4,639,895 4,825,491 5,018,511 5,219,251 5,428,021 5,645,142 5,870,947 18 Public Works 1,869,082 1,476,099 1,488,448 1,762,738 1,681,381 1,084,960 1,128,359 1,173,493 1,220,433 1,269,250 1,320,020 1,372,821 1,427,734 1,484,843 1,544,237 1,606,006 19 Culture and Recreation 263,979 310,066 258,690 282,791 428,739 451,975 470,054 488,856 508,411 528,747 549,897 571,893 594,769 618,559 643,302 669,034 20 NEW Public Works Position - 50% General Fund - - 47,500 49,400 51,376 53,431 55,568 57,791 60,103 62,507 65,007 67,607 NEW Deputy in 2026 - $100K (adj. for inflation)108,160 112,486 116,986 121,665 126,532 131,593 136,857 142,331 148,024 NEW Detective in 2029 - $115K (adj. for infl.)139,915 145,512 151,332 157,385 163,681 170,228 NEW Deputy in 2033 - $100K (adj. for infl.)142,331 148,024 21 NEW Operating Costs - - 27,560 28,662 29,809 31,001 32,241 33,531 34,872 36,267 37,718 39,226 22 NEW Operating Costs - One Time - - 4,500 23 Capital Outlay - - 24 General Government - - 25 Public Safety 24,000 78,628 205,000 65,000 215,000 65,000 43,264 - - - - - - - 26 Public Works 53,038 25,000 36,500 86,500 36,500 54,080 - - - - - - - 27 Culture and Recreation - - 28 Total Expenses 5,242,238 5,433,189 5,807,798 5,782,266 7,260,521 7,136,922 7,697,899 7,897,235 8,204,908 8,431,867 8,909,056 9,265,419 9,636,035 10,021,477 10,564,667 10,987,254 29 Revenues Over / (Under) Expenses 281,473 1,203,886 1,084,653 2,100,999 460,000 1,002,328 800,000 824,000 1,052,036 1,588,490 1,916,482 2,347,281 2,563,829 2,019,524 1,955,686 2,380,642 OTHER FINANCING SOURCES / (USES)30 Transfers In 765,079 - negative numbers are Contingent -- positive numbers are Use of Reserves << Using this to get to the 2% tax rate growth. 31 Contingency - (35,000) (35,000) 32 Sale of Fixed Assets - 33 Bond Proceeds - 34 Transfer Out to Vehicle Acquisition (645,076) (1,003,847) (260,746) - (250,000) (167,328) (200,000) (200,000) (403,076) (913,572) (1,214,567) (1,617,290) (1,804,638) (1,229,965) (1,134,545) (1,526,655) 35 Transfer Out to Vehicle Acquisition - PS (61,076) (82,019) (106,214) no inflation built into these yet! 36 Transfer Out to Vehicle Acquisition - PW (86,963) (90,683) (90,558) 37 Transfer Out to Vehicle Acquisition - CR (1,961) (2,298) (3,228) 38 Transfer Out to 2017A Improvement Bonds (47,766) - - 39 Transfer Out to 2018A Equipment Cert.(20,093) - - - 40 Transfer Out to EDA (30,000) (30,000) (30,000) - 41 Transfer Out to Infrastructure Reserve - (15,661) - - 42 Transfer Out to Inwood and 79th Street Stoplight - - (30,000) - 43 Transfer Out to Village Fund - - (378,736) - 44 Transfer Out to Project Fund (102,074) 45 Transfer Out (2024 - to new Street Maint Fund)- (600,000) (600,000) (624,000) (648,960) (674,918) (701,915) (729,992) (759,191) (789,559) (821,141) (853,987) 46 Total Other Sources / (Uses)(742,935) (284,429) (699,482) (252,074) (460,000) (1,002,328) (800,000) (824,000) (1,052,036) (1,588,490) (1,916,482) (2,347,281) (2,563,829) (2,019,524) (1,955,686) (2,380,642) 0 Test - Total GF Expenditures (as in Budget Doc)6,034,340 Test - Total Rev Over/(Under) Exp (as in Budget doc)1,848,925 47 Prior Period Adjustments 72,502 48 Ending General Fund Balance (FB)4,314,184 5,233,641 5,618,812 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 49 Restricted - - - - - - - - - - - - - 50 Unassigned 4,314,184 5,233,641 5,618,812 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 7,540,239 51 Fund Balance as a % of Next Year's Expenditures 79%90%97%104%102%98%95%92%89%85%81%78%75%71%69% 52 General Fund Operating Tax Levy 2,963,905 3,537,317 3,824,879 5,013,574 5,121,265 5,998,212 6,282,537 6,671,542 7,166,654 7,888,570 8,648,740 9,389,893 9,930,032 9,723,099 10,153,313 10,950,334 53 Annual Increase 19.3%8.1%2.1%17.1%4.7%6.2%7.4%10.1%9.6%8.6%5.8%-2.1%4.4%7.8% Actual Budget Amounts Used GENERAL FUND BUDGETActual Projected 11/28/2023CITY OF LAKE ELMO Financial Management Plan Clarissa's BudgetLong Range Budget Projections Column. Inflation Assumptions 1,901,616 2,032,729 2,541,182 Links to master budget. Need to open that file. 2,694,265 2,764,032 2,871,718 2,951,153 3,118,170 1 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% 2 Interest Earnings 1.50%1.50%1.50%1.50%1.50%1.58%1.65%1.74%4.00%4.00%4.00%4.00%4.00%4.20%3 Expenses 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4 CIP Inflation Factor 0.00%0.00%0.00%0.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% Budget e Proposed GENERAL FUND 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 Actual Budget Amounts Used Actual Projected OTHER SPECIAL/DEBT TAX LEVIES652009B Improvement Bonds 43,580 - - - - - - - - - - - - - 66 2010A Improvement Bonds 59,356 57,151 - - - - - - - - - - - - 67 2010B CIP Bonds 205,989 206,908 207,338 207,076 206,656 205,884 - - - - - - - - - - 68 2011A Improvement Bonds 76,719 74,828 - - - - - - - - - - - - - - 69 2012B Improvement Bonds 65,275 63,669 67,313 65,417 - - - - - - - - - - - - 70 2014A Improvement Bonds 203,885 199,370 205,117 200,394 200,091 103,597 183,304 183,829 178,946 179,314 179,314 - - - - - 71 2015A Improvement Bonds 25,113 21,543 12,722 14,508 - - - - - - - - - - - - 72 2016A Improvement Bonds 189,419 194,564 188,999 193,934 193,409 187,529 186,899 186,164 - - - - - - - - 73 2017A Improvement/Equipment Bonds 346,598 340,691 339,904 344,104 342,660 340,954 338,985 342,004 307,879 - - - - - - - 74 2018A Equipment Certificate - 128,996 123,848 126,404 123,569 125,984 128,258 125,139 127,270 124,010 - - - - - - 75 2019A Improvement/Equipment Bonds - 124,786 293,148 295,301 297,138 298,661 294,618 290,419 296,560 296,981 200,801 - - - - - 76 2021A City Hall/Fire Bonds - - - 733,323 744,758 751,111 746,333 746,491 751,426 745,231 743,971 747,488 747,423 747,173 746,740 746,740 77 2021A Improvement Bonds - - - 274,713 281,172 274,399 276,551 273,139 274,819 276,184 271,984 272,876 272,338 276,958 276,144 276,144 78 2022A Improvement/Abatement Bonds - - - 287,685 283,998 279,523 279,509 272,948 266,111 263,984 255,047 245,323 243,065 234,492 234,492 79 2023A Street Debt Levy 351,713 353,288 354,075 354,075 353,288 351,713 354,600 351,188 352,238 356,438 356,438 80 Debt Levy - NEW Projects - - - - - 515,919 1,201,047 1,744,729 2,025,668 2,246,403 2,662,024 2,952,050 3,968,947 4,400,826 4,555,061 81 82 83 Total Other Special Levies 1,215,934 1,412,506 1,438,389 2,455,174 2,677,138 2,923,830 3,303,678 3,981,816 4,308,652 4,266,787 4,258,170 4,292,036 4,568,321 5,588,380 6,014,639 6,168,875 84 85 Total Tax Levy 4,179,839 4,949,823 5,263,268 7,468,748 7,798,403 8,922,042 9,586,214 10,653,358 11,475,307 12,155,357 12,906,910 13,681,929 14,498,353 15,311,479 16,167,953 17,119,20986Increase/(Decrease) in Total Tax Levy 18.42%6.33%50.89%4.41%14.41%7.44%11.13%7.72%5.93%6.18%6.00%5.97%5.61%5.59%5.88% 87 Fiscal Disparity Distribution (199,047)(249,326)(271,597)(294,157)(433,060)(389,878)(347,997)(362,208)(380,979)(388,599)(396,371)(404,299)(412,385)(420,633)(429,046)(437,627) 88 Net Levy to Taxpayers after Fiscal Disparities 3,980,792 4,700,497 4,991,671 7,174,591 7,365,343 8,532,164 9,238,218 10,291,150 11,094,328 11,766,758 12,510,539 13,277,630 14,085,968 14,890,846 15,738,907 16,681,582 8990 Existing Tax Base 17,361,919 20,021,726 21,116,953 23,487,099 30,606,781 30,606,781 34,758,875 36,158,669 38,295,216 40,474,494 42,085,889 43,868,800 45,645,694 47,475,023 49,203,642 50,986,16791Inflationary Impact on Existing Tax Base 695,178 723,173 765,904 809,490 841,718 877,376 912,914 949,500 984,073 1,019,7239293(actual - new + infla)94 New Net Tax Capacity from Development 0 0 0 0 0 4,152,094 704,616 1,413,374 1,413,374 801,905 941,193 899,517 916,416 779,119 798,451 974,42095Total Net Tax Capacity 17,361,919 20,021,726 21,116,953 23,487,099 30,606,781 34,758,875 36,158,669 38,295,216 40,474,494 42,085,889 43,868,800 45,645,694 47,475,023 49,203,642 50,986,167 52,980,310 TC Growth 13.57%4.03%19.30%11.94%9.90%8.39%8.46%8.22%7.79%7.40%7.68% 96 Tax Rate on Tax Capacity 22.928%23.477%23.638%30.547%24.064%24.547%25.549%26.873%27.411%27.959%28.518%29.089%29.670%30.264%30.869%31.486% 97 Tax Rate % Change 2.39%0.69%29.23%-21.22%2.00%4.08%5.18%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% 184,942.62 311,385.69 (0.00) 0.00 (0.00) 0.00 (0.00) (0.00) - (0.00) 98 City Taxes on $553,500 Residential Homestead 1,300 1,331 1,340 1,398 1,460 1,557 1,677 1,751 1,829 1,910 1,994 2,083 2,174 2,270 2,36999$ Tax Increase/(Decrease)31$ 9$ (334)$ 63$ 96$ 120$ 75$ 78$ 81$ 84$ 88$ 92$ 96$ 100$ 100 % Tax Increase / (Decrease)2.39%0.69%-19.29%4.48%6.60%7.70%4.45%4.43%4.45%4.41%4.43%4.40%4.40%4.39% 101 Existing Tax Base Inflation / (Deflation)0.0%0.0%0.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0%2.0% 102 Total Tax Base Increase 15%5%30%14%13%6%6%4%4%4%4%4%4%4%103 % from New Growth 0%0%0%14%2%4%4%2%2%2%2%2%2%2%PROPERTY TAX LEVY AND TAX IMPACT