Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
10.e Resolution 12-19-23-12 Approving 2024 Budget and Certifying Final Levy
Staff Report Date of Meeting: December 19, 2023 For: Honorable Mayor and Council From: Kyle Morell, City Administrator Subject: 2024 Final Budget Discussion Background: Staff presented the preliminary 2024 budget for Council review at their July 5 Work Session. The Capital Investment Committee met twice to review the CIP funds and discuss future projects. Their recommendations have been included in the CIP fund budgets. The General Fund budget was prepared using past revenue and expense practices and a six-month review of 2023 spending as guides for future revenue and expense projections. At the August 2 Work Session, Councilmember Benson asked for a 2024 budget that kept the City’s tax rate similar to the rate established in 2023. Staff accomplished this by reducing the proposed funding for Broadband expansion within the 401 CIP fund. After that meeting, the proposed 2024 tax rate was 26.449%, a reduction of 0.010% from the final 2023 rate. At the September 6 Work Session, the Council approved the replacement of the hockey rink boards, removing that project from the 2024 Park CIP budget. Council also heard from Bob Wilmers, Chairman of the Internet Action Committee, about the proposed reduction in broadband funding. At Council’s direction, the broadband funding has been restored to its original request level of $250,000 in 2024 and 2025. Staff has also made minor adjustments to various line items within the budget to reflect rate increases from contracted services. At the September 19 Regular Council Meeting, Resolution 09 19 23 10 was approved, certifying a preliminary levy of $3,021,852.00. This represented a $218,295 increase over 2023 (7.79%). This levy amount provided a tax rate of 26.864%, a .404% increase of the final 2023 tax rate. At our November 21 meeting, the Council wanted to reduce the tax rate to as close to the 2023 rate as possible. Staff reduced spending in the CIP 401 Fund, lowering the tax rate to 26.633%, or 0.174% above the 2023 rate. Discussion: Wages were estimated in the preliminary budget but are now known. The City has a tentative agreement with the union, which provides union employees with a 6% market adjustment and a 3.5% cost-of-living adjustment, effective January 1, 2024. The preliminary budget estimated a 10% increase. This agreement does not adversely affect the 2024 budget. The Negotiating Committee recommended similar adjustments and increases for non-union staff, in line with past practice. The final budget allocates a 3.5% cost of living adjustment for all non-union staff and a market adjustment for office staff. The budget provides non-union staff with cost-of-living adjustments on January 1, 2024, in line with union staff. Department head positions are not budgeted for a market adjustment, only a cost-of-living adjustment, since the positions have received market adjustments as part of the 2019 wage study. Councilmember Lubke asked how wages for those positions compare to similar positions. While the Fire Chief position is comparable paid relative to similar positions in other Cities, the Director of Public Works position is more complicated. Compared to other communities within the Metro with similar populations, the position is underpaid by more than $20,000 annually, with the metro average of the position between $112,000 and $116,000. Compared to communities with similar populations across the State, the position is paid a relatively average wage, approximately $96,500. If the Council wishes to bring the position’s wage more in line with other metro communities, staff recommends applying the 6% market increase to the position. This would increase the position wage by $5,600 and other general fund expenses by $400 (a total increase of $6,000), effective January 1, 2024. Total 2024 General Fund revenues are $2,328,250, a .15% reduction ($3,565) from 2023. Expenses are $2,303,051, a 0.59% reduction ($13,558) from 2023. As presented, the General Fund shows a surplus of $25,199 for 2024. The CIP Fund documents have been adjusted since our last meeting. The 401 Fund reflects the restoration of the broadband funding. The Internet Action Committee has been unable to define its funding request better and continues working with Midco to bring a more accurate number to the Council. The 404 Fund shows the change in project year for the hockey rink board replacement and the fund balance transfer to cover the board replacement. The 406 Fund has been updated to reflect the actual cost of Tender 2 replacement, which reduced the 2024 project costs by $25,000. The 408 Funds remain unchanged. The 2024 Draft Final Budget, Budget Presentation, and Summary Budget have been updated to reflect the revised 2024 numbers. We are adding a new fund in 2024. The Big Marine Sewer Fund is being divided into two funds, Bliss (602) and Anderson/Erickson (624). We are working on updated rate sheets for the three sewer funds and should have those by next week. The preliminary 2024 levy amount is $3,021,852. This represents a $218,295 increase over 2023 (7.79%). The City cannot levy higher than this amount. As presented, the Final Budget levy amount is $2,996,852, a 6.89% increase over 2023 and a $25,000 reduction from the preliminary levy amount. The 2024 tax rate is projected to be 26.633%, a 0.174% increase over 2023. Options: 1) Approve Resolution 12-19-23-12 Adopting the 2024 Citywide Budget and Certifying Property Tax Levy Payable in 2024. 2) Approve Resolution 12-19-23-01 Employee 2024 Pay Rates 3) Table discussion for further consideration Recommendation: Options 1 and 2 Attachments: Resolution 12-19-23-12 Adopting the 2024 Citywide Budget and Certifying Property Tax Levy Payable in 2024 Exhibit A – 2024 Final Budget Exhibit B – 2024 CIP Funds Resolution 12-19-23-01 Employee 2024 Pay Rates 2024 Final Budget Presentation Summary Budget Worksheet 2024 Tax Impact Worksheet RESOLUTION 12-19-23-12 CITY OF SCANDIA, MINNESOTA RESOLUTION ADOPTING THE 2024 BUDGET AND CERTIFYING PROPERTY TAX LEVY PAYABLE IN 2024 WHEREAS, The City of Scandia has prepared a budget for the fiscal year commencing January 1, 2024, and WHEREAS, the budget requires money to be raised from property taxes on taxable property in the City of Scandia, NOW, THEREFORE, BE IT HEREBY RESOLVED BY THE CITY COUNCIL OF THE CITY OF SCANDIA, WASHINGTON COUNTY, MINNESOTA, that the 2024 Budget as provided in “Exhibit A” is hereby approved, and that the following sums of money shall be certified to the County Auditor of Washington County to be raised by property tax payable in 2024: 2024 Property General Purpose Tax Levy General Fund $1,865,918 Debt Service Funds $345,634 Capital Improvement Fund $235,000 Park Investment Fund $60,000 Equipment Replacement Fund $110,000 Local Road Improvement Fund $375,000 Economic Development Authority $5,300 Total Property Tax Levy $2,996,852 FURTHER, BE IT RESOLVED that the 2024 through 2028 Capital Improvement Plan (CIP) as presented in the 2024 budget is hereby approved and that the document made part of this resolution as “Exhibit B.” Adopted by the Scandia City Council on the 19th day of December, 2023. Christine Maefsky, Mayor ATTEST: Kyle Morell, City Administrator 12/15/2023 City of Scandia 2024 Proposed Budget 3-Yr Avg 2023 Budget 11/27/2023 2024 Actual Approved YTD Actual Budget-5 Revenues FUND 101 GENERAL FUND Comments Taxes Revenue 101-41000-31000 Washington Cty. Tax Settlement 1,360,037$ 1,865,918$ 989,521$ 1,865,918$ 0% increase 101-41000-31040 Fiscal Disparities 129,454$ 123,297$ 86,949$ 107,857$ 101-41000-31701 Gravel Taxes 18,970$ 20,000$ 3,329$ 20,000$ 101-41000-31830 Solar Energy Production Tax 5,527$ 6,000$ 5,874$ 5,500$ 101-41000-31900 Penalties & Interest Delinquent Tax 1,774$ 400$ 52$ 1,000$ 1,515,761$ 2,015,615$ 1,085,725$ 2,000,275$ Licenses and Permits Revenues 101-41000-32150 Utility Permits 5,387$ 3,000$ 4,500$ 5,000$ 101-41000-32180 Tobacco and Liquor Licenses 11,226$ 10,000$ 744$ 11,000$ 101-41000-32190 Other City Permits 2,915$ 3,000$ 2,470$ 3,000$ 101-41000-32210 Building Permits 162,877$ 145,000$ 155,307$ 160,000$ 101-41000-32260 Gambling Permits 130$ 100$ 45$ 100$ 182,534$ 161,100$ 163,066$ 179,100$ Intergovernmental Revenues 101-41000-33401 LGA/MVHC/AG/PERA Aid 11,228$ 7,000$ 6,959$ 7,000$ 101-41000-33420 Fire Relief State PERA 39,045$ 37,000$ 47,148$ 40,474$ This is a pass through offset in expenditures. 101-41000-33422 Other State Grants & Aids 6,169$ 11,000$ 9,053$ 6,000$ 101-41000-33428 Payments In Lue of Taxes (PILT) 6,757$ 6,000$ 3,108$ 6,000$ 101-41000-33620 Recycling Grant 11,417$ 10,500$ 8,165$ 11,000$ 101-41000-33630 Local Govt Grants & Aids -$ -$ -$ 101-41000-33640 Other Grants 1,241$ 1,200$ -$ 1,200$ 75,857$ 72,700$ 74,433$ 71,674$ Charges for Services Revenue 101-41000-34103 Zoning and Planning 5,730$ 6,700$ 7,742$ 5,000$ 101-41000-34106 Engineering Fees 415$ 500$ -$ -$ 101-41000-34107 Assessment Search Fees 47$ -$ 5$ 20$ 101-41000-34109 Water Usage 83$ 100$ -$ 100$ 101-41000-34201 Impound Fees 198$ -$ -$ -$ 101-41000-34202 Fire Protection Services 32,896$ 32,300$ 32,300$ 33,915$ to be negotiated with Town of May-new 3 year contract 101-41000-34301 Restitution 8,144$ -$ -$ -$ 101-41000-34303 Dust Control 2,778$ 2,700$ 3,524$ 3,630$ 101-41000-34304 Reimbursement for Services 3,600$ 3,000$ 1,800$ 1,000$ 101-41000-34305 Other Street Services 692$ -$ -$ -$ 101-41000-34730 Ad Revenue 1,667$ -$ 900$ 1,000$ 101-41000-34750 Facilities Rental 7,464$ 5,500$ 7,584$ 7,400$ 101-41000-34760 Cleaning Fees 100$ 100$ -$ -$ 101-41000-34790 Recreation Programs 1,707$ 2,100$ 1,728$ 1,500$ 65,520$ 53,000$ 55,583$ 53,565$ Fines and Forfeits Revenues 101-41000-35101 Fines & Forfeitures 6,720$ 7,400$ 5,644$ 7,000$ 6,720$ 7,400$ 5,644$ 7,000$ Miscellaneous Revenues 101-41000-36210 Interest Income 16,697$ 12,100$ 20,966$ 5,636$ 101-41000-36230 Donations 9,181$ 2,000$ 9,141$ 5,000$ 101-41000-36240 Insurance Dividend 5,158$ 4,100$ -$ 4,000$ 101-41000-36250 Misc. Refund 1,967$ 3,800$ 4,076$ 2,000$ 101-41000-39200 Interfund Operating Transfer 0 -$ -$ 33,003$ 22,000$ 34,183$ 16,636$ Transfers Between Funds Revenues 101-49000-39200 Interfund Transfer -$ -$ 2,173,000$ -$ 101-49000-39204 Money Market Transfer 0 1,225,000$ -$ -$ -$ 3,398,000$ -$ -0.15% Total General Fund Revenues 647,365$ 2,331,815$ 1,418,634$ 2,328,250$ increase/(decrease) over 2023 Page 1 of 13 12/15/2023 City of Scandia 2024 Proposed Budget 3-Yr Avg 2023 Budget 11/27/2023 2024 Actual Approved YTD Actual Budget-5 Expenditures ADMINISTRATION & FINANCE EXPENDITURES 101-41000-101 Regular Wages & Salaries 174,473$ 192,700$ 120,577$ 196,535$ 101-41000-121 PERA Coord. Employer Contribu. 13,064$ 13,400$ 6,440$ 13,788$ 101-41000-122 FICA Employer Contribution 10,742$ 11,900$ 6,549$ 12,185$ 101-41000-126 MEDICARE Employer Contribution 2,375$ 2,700$ 2,393$ 2,850$ 101-41000-131 Employer Paid Health 24,849$ 47,300$ 33,785$ 46,482$ PEIP & HSA 2.2% decrease 101-41000-132 Dental Insurance 296$ 3,400$ 1,242$ 1,990$ 101-41000-134 Employer Paid Life 592$ 600$ 511$ 643$ 101-41000-135 Employer Paid Disability 812$ 900$ 844$ 960$ 101-41000-151 Worker s Comp Insurance Prem 1,472$ 1,300$ 1,651$ 1,339$ 101-41000-200 Office Supplies 1,065$ 1,100$ 432$ 1,133$ 101-41000-203 Printed Forms & Papers 2,022$ 1,900$ 2,590$ 1,957$ 101-41000-210 Operating Supplies 676$ 800$ 575$ 824$ 101-41000-301 Auditing and Accounting Services 20,717$ 23,500$ 28,500$ 27,000$ Schlenner Wenner & c/o agreement through 2022 101-41000-304 Legal Services 39,403$ 55,000$ 49,749$ 65,000$ 6% increase 101-41000-306 Personal Testing & Recruit -$ -$ -$ -$ 101-41000-308 Other Professional Services 9,391$ 1,000$ 816$ 5,000$ Ehlers Financial Assistance 101-41000-309 Software Support & Maintenance 17,033$ 18,200$ 16,980$ 18,746$ 101-41000-316 Conferences & Seminars 440$ 700$ 60$ 721$ 101-41000-317 Employee Training 324$ 200$ -$ 206$ 101-41000-319 Other Services 675$ 46,700$ 50,158$ 700$ 101-41000-321 Telephone 4,165$ 3,700$ 4,606$ 5,100$ 101-41000-322 Postage 2,318$ 2,200$ 2,277$ 2,200$ 101-41000-331 Travel Expenses 625$ 600$ 1,033$ 1,000$ 101-41000-351 Legal Notices Publishing 1,022$ 1,200$ 1,530$ 1,500$ 101-41000-361 Liability/Property Ins 4,216$ 7,100$ 10,967$ 11,516$ 5% increase 101-41000-365 Insurance Claims -$ -$ 1,000$ 1,000$ 101-41000-381 Utilities-Electric & Gas 10,581$ 13,000$ 10,839$ 12,000$ Sunscription SSI MN TRANCHE $985/mo 101-41000-413 Equipment Rental 1,869$ 1,900$ 1,744$ 1,800$ 101-41000-430 Recycling 27,498$ 30,100$ -$ -$ 101-41000-433 Dues and Subscriptions 5,418$ 6,100$ 5,056$ 5,000$ LMC dues $4,900, newspaper 37, MET Area Mgr $45 101-41000-434 Youth Service Bureau 5,500$ 5,500$ 5,500$ 5,500$ Support for program for rehabilitation of youth offenders dba Lakes Center for Youth & Families 101-41000-435 Misc Expense 171$ 500$ -$ -$ 101-41000-438 Misc. Contractual 5,161$ 4,000$ 1,336$ 4,120$ Abdo financial assistance 101-41000-439 Refunds Issued 685$ -$ -$ -$ 101-41000-560 Furniture and Fixtures -$ -$ -$ -$ 101-41000-570 Office Equipment 6,164$ 5,500$ 1,983$ 1,500$ Office Asst computer & Server in 2025 395,814$ 504,700$ 371,724$ 450,295$ CITY COUNCIL EXPENDITURES 101-41110-101 Regular Wages & Salaries 16,360$ 18,100$ 15,579$ 20,772$ 101-41110-122 FICA Employer Contribution 211$ 1,100$ 238$ 1,288$ 101-41110-126 MEDICARE Employer Contribution 73$ 300$ 174$ 301$ 101-41110-127 PERA Defined 648$ 600$ 587$ 703$ 101-41110-151 Worker s Comp Insurance Prem 50$ 100$ 95$ 100$ 101-41110-308 Other Professional Services 20$ 30$ -$ 101-41110-316 Conferences & Seminars 169$ 700$ 350$ 350$ 101-41110-331 Travel Expenses -$ 562$ -$ 101-41110-439 Refunds Issued (Liquor License refunds)2,933$ -$ -$ 101-41110-560 Furniture and Fixtures -$ -$ -$ 101-41110-570 Office Equipment 55$ -$ -$ 20,519$ 20,900$ 17,615$ 23,513$ ELECTION EXPENDITURES 101-41410-199 Election Judge 3,124$ -$ 5,400$ 101-41410-200 Office Supplies 26$ -$ 50$ 101-41410-203 Printed Forms & Papers -$ -$ -$ 101-41410-210 Operating Supplies 898$ 200$ -$ 750$ 101-41410-351 Legal Notices Publishing 114$ -$ 200$ 101-41410-413 Equipment Rental 1,272$ 850$ 1,515$ 1,700$ 5,434$ 1,050$ 1,515$ 8,100$ Page 2 of 13 12/15/2023 City of Scandia 2024 Proposed Budget 3-Yr Avg 2023 Budget 11/27/2023 2024 Actual Approved YTD Actual Budget-5 PLANNING & BUILDING EXPENDITURES 101-41910-101 Regular Wages & Salaries 29,160$ 59,600$ 57,485$ 59,941$ Share of Administration wages & benefits 101-41910-121 PERA Coord. Employer Contribu.2,187$ 4,200$ 3,238$ 4,258$ 101-41910-122 FICA Employer Contribution 1,751$ 3,700$ 3,051$ 3,716$ 101-41910-126 MEDICARE Employer Contribution 408$ 900$ 736$ 869$ 101-41910-131 Employer Paid Health 4,350$ 20,000$ 14,631$ 17,353$ 101-41910-132 Dental Insurance 153$ 1,500$ 585$ 724$ 101-41910-134 Employer Paid Life 58$ 200$ 146$ 173$ 101-41910-135 Employer Paid Disability 134$ 500$ 372$ 416$ 101-41910-203 Printed Forms & Papers 96$ 600$ -$ 100$ 101-41910-311 Contract Permit Inspections 68,346$ 50,000$ 60,504$ 60,000$ Building (City of Hugo) & Electrical (Joseph Wheaton) Inspections 101-41910-312 Planning Services 31,707$ 50,000$ 70,568$ 60,000$ 101-41910-313 Committee & Commission Reimbur 4,767$ 5,000$ 3,150$ 5,200$ 101-41910-316 Conferences & Seminars -$ 50$ -$ -$ 101-41910-319 Other Services 8$ 123$ -$ 101-41910-361 Liability/Property Ins 920$ 4,900$ 5,401$ 5,563$ assume 3% increase 101-41910-438 Misc. Contractual 6,032$ 5,000$ 3,756$ 5,000$ State Building Permit Surcharges 101-41910-439 Refunds Issued 389$ 200$ 600$ -$ 150,466$ 206,350$ 224,345$ 223,312$ ASSESSOR EXPENDITURES 101-41950-300 Assessor 21,718$ 21,600$ 20,159$ 23,200$ Assessor contract w/Patrick Pauscek renews May $2,000/mo 21,718$ 21,600$ 20,159$ 23,200$ POLICE EXPENDITURES 101-42100-318 Police Contract 115,172$ 168,499$ 84,250$ 183,442$ 8.9% Increase per 07/25/23 notice 101-42100-319 Other Services 337$ 500$ 959$ 960$ Code Red notification service; Taco Daze security 115,508$ 168,999$ 85,209$ 184,402$ FIRE DEPT EXPENDIDTURES 101-42200-101 Regular Wages & Salaries 98,372$ 147,200$ 151,756$ 160,554$ 101-42200-121 PERA Coord. Employer Contribu. 4,973$ -$ -$ 101-42200-122 FICA Employer Contribution 5,263$ 9,100$ 8,850$ 9,954$ 101-42200-124 Police & Fire PERA 2,985$ 3,600$ 8,365$ 8,983$ 101-42200-126 MEDICARE Employer Contribution 1,903$ 2,100$ 1,982$ 2,328$ 101-42200-134 Employer Paid Life 133$ 200$ 176$ 192$ 101-42200-135 Employer Paid Disability -$ 700$ -$ -$ 101-42200-141 Unemployment Compensation -$ -$ 101-42200-151 Worker s Comp Insurance Prem 10,418$ 9,500$ 11,617$ 12,000$ They will send estimate before year end 101-42200-200 Office Supplies 273$ 400$ 198$ 200$ 101-42200-203 Printed Forms & Papers 157$ 150$ -$ -$ 101-42200-209 Medical Supplies 1,630$ 3,000$ 4,662$ 3,500$ Inflation 101-42200-210 Operating Supplies 7,120$ 8,000$ 7,136$ 8,800$ Inflation 101-42200-211 Cleaning Supplies (221)$ 100$ 51$ 100$ 101-42200-212 Fuel 3,752$ 3,500$ 5,094$ 4,000$ 101-42200-217 Uniforms & Safety Equipment 489$ 10,000$ 4,944$ 10,000$ New member gear and uniforms 101-42200-221 Equipment Parts 483$ 3,000$ 294$ 1,500$ 101-42200-222 Tires 513$ -$ -$ 101-42200-223 Structure Repair & Supplies 413$ 2,000$ 400$ 800$ 101-42200-240 Small Tools and Minor Equip 10,127$ 9,000$ 1,339$ 10,000$ 101-42200-305 Medical Services 5,257$ 3,500$ 4,610$ 5,600$ Annual testing 101-42200-306 Personal Testing & Recruit 1,338$ 1,300$ 1,391$ 500$ We are at full staff, 1 possible future opening 101-42200-309 Software Support & Maintenance 17,622$ 17,000$ 13,987$ 17,000$ Page 3 of 13 12/15/2023 City of Scandia 2024 Proposed Budget 3-Yr Avg 2023 Budget 11/27/2023 2024 Actual Approved YTD Actual Budget-5 101-42200-310 Medical Training 2,301$ 2,000$ 12,000$ 2,000$ No new hires planned in 2024 101-42200-316 Conferences & Seminars -$ 250$ -$ 250$ 101-42200-317 Employee Training 7,339$ 15,000$ 5,764$ 12,000$ FF 1 & 2 for 6 training paid by MBFTE grant 101-42200-319 Other Services 1,246$ 500$ -$ 500$ 101-42200-321 Telephone 5,512$ 6,800$ 5,528$ 7,000$ $305.84 Mobile data, $223.67 Midco per month 101-42200-322 Postage 9$ -$ -$ 101-42200-324 State of MN-Fire Relief 39,046$ 35,300$ 47,148$ 40,474$ Pass through from state $40,474 estimate 101-42200-325 City Match-Fire Relief -$ -$ -$ 101-42200-331 Travel Expenses 17$ 1,500$ 1,693$ 2,000$ week-end fire schools 101-42200-334 Licenses & Permits 200$ 200$ 536$ 500$ MN Brd of FF Training $300; FF Certs $200 101-42200-340 Advertising -$ -$ -$ 101-42200-361 Liability/Property Ins 7,524$ 6,500$ 6,989$ 7,339$ 5 % increase 101-42200-381 Utilities-Electric & Gas 4,611$ 8,000$ 4,669$ 8,000$ Based on 1/2 year 101-42200-384 Refuse/Garbage Disposal 971$ 1,100$ 847$ -$ Not sure what new contract will cover 101-42200-385 Sewer Pumping & Maintenance 273$ 700$ -$ 550$ 101-42200-401 Building Maintenance/Repairs 3,503$ 2,500$ 4,500$ 3,500$ Pest C ontrol $530; Cleaning Service $1800 101-42200-403 Improvements Other Than Bldgs -$ -$ -$ 101-42200-404 Repair Machinery/Equipment 10,579$ 8,000$ 17,937$ 8,500$ 101-42200-407 Well Repair & Maintenance 45$ -$ -$ 101-42200-433 Dues and Subscriptions 1,996$ 2,400$ 3,215$ 3,200$ IamResponding $700; /check-It $1,300 101-42200-438 Misc. Contractual 2,884$ 4,100$ 2,685$ 3,500$ Compressor, Lucas, Tornado siren & Zoll Service 101-42200-440 Events 704$ 800$ 1,196$ 1,000$ Taco Daze, Fire Prevention, Safe Halloween 101-42200-520 Capital Improvements to Bldgs -$ -$ 6,264$ -$ 101-42200-530 Capital Impr Other Than Bldgs 393$ -$ -$ 101-42200-540 Heavy Machinery Capital -$ -$ -$ 101-42200-560 Furniture and Fixtures 2,678$ 500$ 236$ 500$ Training room chairs 101-42200-570 Office Equipment 1,027$ 900$ 180$ 900$ Computer replacement 265,857$ 330,400$ 348,239$ 357,724$ ANIMAL CONTROL EXPENDITURES 101-42700-314 Animal Control 5,616$ 5,000$ 6,335$ 6,000$ 5,616$ 5,000$ 6,335$ 5,600$ Page 4 of 13 12/15/2023 City of Scandia 2024 Proposed Budget 3-Yr Avg 2023 Budget 11/27/2023 2024 Actual Approved YTD Actual Budget-5 PUBIC WORKS EXPENDITURES 101-43000-101 Regular Wages & Salaries 207,728$ 229,700$ 198,336$ 250,392$ 101-43000-102 OT Regular Wages 6,554$ 5,000$ 5,520$ 5,014$ 101-43000-104 Temporary Employee Wages 2,511$ 2,300$ 4,163$ 2,262$ 101-43000-121 PERA Coord. Employer Contribu. 15,979$ 17,600$ 15,259$ 19,155$ 101-43000-122 FICA Employer Contribution 12,655$ 14,600$ 12,007$ 15,975$ 101-43000-126 MEDICARE Employer Contribution 3,029$ 3,400$ 3,006$ 3,736$ 101-43000-131 Employer Paid Health 53,794$ 70,900$ 56,658$ 66,939$ 2.2% decrease, Union deduction notice in March 101-43000-132 Dental Insurance 305$ 2,300$ 1,058$ 1,164$ 101-43000-133 Union Training Center -$ 1,872$ $.30/hr Union Training Benefit 101-43000-134 Employer Paid Life 695$ 700$ 642$ 698$ 101-43000-135 Employer Paid Disability 2,046$ 1,700$ 1,563$ 1,365$ 101-43000-141 Unemployment Compensation 485$ -$ -$ -$ 101-43000-151 Worker s Comp Insurance Prem 18,154$ 19,500$ 26,477$ 27,000$ 101-43000-200 Office Supplies 187$ 600$ 54$ 50$ 101-43000-210 Operating Supplies 7,034$ 8,400$ 8,296$ 8,500$ Daily use items, hardwares, misc. items 101-43000-212 Fuel 19,099$ 20,000$ 25,069$ 25,000$ 101-43000-217 Uniforms & Safety Equipment 1,689$ 2,200$ 2,194$ 2,300$ Uniform allowance, PPE 101-43000-221 Equipment Parts 12,678$ 14,000$ 16,952$ 17,000$ P.M. parts, Replacement Parts 101-43000-222 Tires 6,594$ 7,500$ 1,288$ 7,500$ 101-43000-223 Structure Repair & Supplies 539$ 2,200$ 56$ 2,000$ 101-43000-224 Materials for Road Maintenance 11,067$ 16,500$ 3,588$ 7,000$ Hot/Cold mix, cement, culverts, base material 101-43000-226 Sign Replacement & Repair 2,937$ -$ 174$ 750$ 101-43000-228 Gravel 8,645$ 10,000$ 6,863$ 10,000$ Class 2 shoulder material, gravel 101-43000-229 Salt 13,974$ 20,000$ 28,069$ 22,000$ Winter Road Salt Untreated/Treated 101-43000-240 Small Tools and Minor Equip 1,442$ 8,000$ 3,876$ 8,000$ Hand tools, attachments 101-43000-302 Surveying 2,818$ -$ -$ *Admin Cost- remove line item from PW 101-43000-303 Engineering Fees 6,784$ 10,000$ 13,704$ 10,500$ 5% increase 101-43000-304 Legal Services 127$ -$ -$ -$ 101-43000-305 Medical Services 1,033$ 1,200$ 286$ 1,000$ First Aid supplies 101-43000-309 Software Support & Maintenance 1,789$ 2,000$ 13,198$ 6,000$ PW Data Tracking Software $5,000 ; GIS map updates 101-43000-317 Employee Training 976$ 1,700$ 1,210$ 1,500$ 101-43000-319 Other Services 5,469$ 13,600$ 6,022$ 7,000$ Pest control, Janitorial service 101-43000-321 Telephone 3,311$ 3,000$ 3,745$ 4,000$ City isued cell/data service 101-43000-331 Travel Expenses 301$ 500$ -$ 500$ 101-43000-334 Licenses & Permits 3,919$ 500$ 10$ 500$ 101-43000-361 Liability/Property Ins 8,143$ 9,000$ 8,348$ 8,766$ 5% increase 101-43000-365 Insurance Claims 926$ -$ -$ -$ 101-43000-381 Utilities-Electric & Gas 2,628$ 4,000$ 3,421$ 6,000$ 101-43000-384 Refuse/Garbage Disposal 620$ 1,000$ 731$ -$ 101-43000-385 Sewer Pumping & Maintenance 1,504$ 1,600$ -$ 1,500$ PW/Fire shop drain holding tank pumping 101-43000-387 Street Light Utilities 4,945$ 4,200$ 3,636$ 4,200$ Street light Maintenance/Replacement 101-43000-401 Building Maintenance/Repairs 4,469$ 8,000$ 3,823$ 6,000$ 101-43000-403 Improvements Other Than Bldgs 2,617$ -$ -$ -$ Misc. small improvements 101-43000-404 Repair Machinery/Equipment 60,657$ 15,500$ 25,588$ 25,000$ Outsourced equipment repair 101-43000-405 Contractual Road Maint/Repair 45,358$ 157,500$ 119,461$ 200,000$ Striping, Calium Chloride Application, Patching, Culvert Repair 101-43000-407 Well Repair & Maintenance 273$ -$ -$ 500$ RPZ testing, repair, maintenance 101-43000-413 Equipment Rental 1,265$ 4,000$ 4,000$ 101-43000-417 Uniform Rental 752$ 1,100$ 951$ 1,200$ Full-time staff work uniforms 101-43000-433 Dues and Subscriptions 2,412$ 200$ -$ 200$ 101-43000-438 Misc. Contractual 8,230$ 15,750$ 7,276$ 16,000$ 101-43000-439 Refunds Issued 133$ -$ -$ 101-43000-530 Capital Impr Other Than Bldgs 393$ -$ -$ 9,900$ building/equipment improvement 101-43000-550 Motor Vehicles Capital -$ -$ -$ 101-43000-560 Furniture and Fixtures 1,311$ 1,000$ -$ 1,000$ Office/Break Room amenities 101-43000-570 Office Equipment -$ -$ 407$ -$ 0 582,986$ 732,450$ 632,984$ 820,937$ Page 5 of 13 12/15/2023 City of Scandia 2024 Proposed Budget 3-Yr Avg 2023 Budget 11/27/2023 2024 Actual Approved YTD Actual Budget-5 PARKS & RECREATION REVENUE 101-45000-101 Regular Wages & Salaries 18,436$ 10,200$ 7,365$ 11,126$ 101-45000-104 Temporary Employee Wages 14,869$ 40,200$ 19,368$ 39,985$ 101-45000-121 PERA Coord. Employer Contribu.1,395$ 800$ 549$ 834$ 101-45000-122 FICA Employer Contribution 1,975$ 3,300$ 1,610$ 3,169$ 101-45000-126 MEDICARE Employer Contribution 466$ 800$ 404$ 741$ 101-45000-131 Employer Paid Health 814$ 2,700$ 2,003$ 2,562$ 101-45000-132 Dental Insurance 11$ 100$ 38$ 42$ 101-45000-134 Employer Paid Life 48$ -$ 25$ 27$ 101-45000-135 Employer Paid Disability 124$ 1,000$ 55$ 76$ 101-45000-141 Unemployment Compensation 40$ -$ -$ -$ 101-45000-151 Worker s Comp Insurance Prem 1,660$ 1,800$ 2,615$ 2,700$ 101-45000-200 Office Supplies 15$ 310$ -$ 100$ 101-45000-203 Printed Forms & Papers 121$ 930$ -$ 200$ 101-45000-210 Operating Supplies 1,088$ 930$ 729$ 1,000$ Daily use items, hardwares, misc. items 101-45000-212 Fuel 468$ 1,650$ 251$ 1,000$ 101-45000-221 Equipment Parts 924$ 2,100$ 1,373$ 2,500$ 101-45000-223 Structure Repair & Supplies 1,417$ 2,100$ 1,096$ 2,500$ 101-45000-240 Small Tools and Minor Equip 253$ 400$ 324$ 500$ Hand tools, string trimmers, ect. 101-45000-312 Planning Services -$ -$ -$ -$ 101-45000-313 Committee & Commission Reimbur 1,200$ 1,200$ 720$ -$ 101-45000-319 Other Services 1,508$ -$ 1,381$ 1,750$ Janitorial service, pest control, Portable toilet service 101-45000-322 Postage -$ -$ -$ -$ 101-45000-340 Advertising 120$ 209$ -$ -$ 101-45000-353 Sales& Use Tax 13$ -$ -$ -$ 101-45000-361 Liability/Property Ins 6,698$ 3,300$ 3,323$ 3,489$ 5% increase 101-45000-381 Utilities-Electric & Gas 5,069$ 4,500$ 4,630$ 6,500$ 101-45000-384 Refuse/Garbage Disposal 4,047$ 2,500$ 5,212$ 5,000$ 101-45000-385 Sewer Pumping & Maintenance 435$ 700$ 876$ 1,250$ Warming House 101-45000-401 Building Maintenance/Repairs 2,037$ 4,800$ 4,123$ 6,000$ 101-45000-403 Improvements Other Than Bldgs 1,878$ -$ 421$ 2,500$ 101-45000-404 Repair Machinery/Equipment 782$ 750$ 397$ 1,000$ Outsourced equipment repair 101-45000-406 Grounds Care 1,200$ 4,000$ 3,724$ 4,000$ Plant material, mulch, landscape material 101-45000-438 Misc. Contractual 8,189$ 3,300$ 2,830$ 8,000$ Herbicide/Fertilizer Application 101-45000-439 Refunds Issued -$ -$ 565$ -$ 101-45000-440 Events 5,846$ 7,000$ 5,354$ 7,000$ 101-45000-490 Financial Assistance -$ -$ -$ -$ 101-45000-530 Capital Impr Other Than Bldgs 2,277$ 10,000$ -$ 9,900$ Building/Equipment Improvements 85,424$ 111,579$ 71,360$ 125,451$ COMMUNITY CENTER EXPENDITURES 101-45180-101 Regular Wages & Salaries 7,036$ 15,000$ 12,510$ 16,601$ 101-45180-104 Temporary Employee Wages -$ 1,100$ -$ -$ 101-45180-121 PERA Coord. Employer Contribu.510$ 900$ 918$ 1,245$ 101-45180-122 FICA Employer Contribution 417$ 200$ 729$ 1,029$ 101-45180-126 MEDICARE Employer Contribution 96$ 3,700$ 180$ 241$ 101-45180-131 Employer Paid Health 903$ -$ 2,628$ 3,692$ 101-45180-132 Dental Insurance -$ -$ -$ -$ 101-45180-134 Employer Paid Life 16$ 200$ 37$ 43$ 101-45180-135 Employer Paid Disability 46$ -$ 107$ 95$ 101-45180-151 Worker s Comp Insurance Prem 5$ -$ -$ -$ 101-45180-210 Operating Supplies 1,859$ 2,900$ 2,844$ 2,900$ Daily use items, hardwares, misc. items 101-45180-223 Structure Repair & Supplies 1,022$ 6,500$ 173$ 4,000$ 101-45180-334 Licenses & Permits 818$ 1,000$ 792$ 1,000$ 101-45180-361 Liability/Property Ins 2,605$ 800$ 796$ 835$ 5% increase 101-45180-381 Utilities-Electric & Gas 6,821$ 11,200$ 7,983$ 9,135$ 101-45180-384 Refuse/Garbage Disposal 1,813$ 1,900$ 3,095$ -$ 101-45180-385 Sewer Pumping & Maintenance 3,061$ 3,700$ 3,408$ 4,000$ Community Center holding tank pumping 101-45180-401 Building Maintenance/Repairs 13,225$ 15,000$ 13,193$ 15,000$ 101-45180-404 Repair Machinery/Equipment 1,121$ 5,000$ 2,435$ 5,000$ Kitchen/HVAC repair and maintenance 101-45180-406 Grounds Care 276$ 690$ 1,255$ 1,300$ Plant material, mulch, landscape material 101-45180-407 Well Repair & Maintenance 4,558$ 1,000$ -$ 1,000$ Community Well (Com. Center, Church, Gammelgarden) 101-45180-438 Misc. Contractual 1,555$ 2,700$ 2,057$ 3,500$ 101-45180-439 Refunds Issued -$ -$ 450$ -$ 101-45180-520 Capital Improvements to Bldgs.4,415$ 6,000$ 7,476$ 9,900$ Building/Equipment Improvements 101-45180-530 Capital Impr Other Than Bldgs 852$ -$ -$ -$ 101-45180-570 Office Equipment 440$ -$ -$ -$ 53,467$ 79,490$ 63,065$ 80,516$ Transfers Between Funds RevenuesExpenditures 101-49000-720 Operating Transfers 150,000$ 146,620$ Transfer to Parks Cap 404 for rink boards Total General Fund Expenditures 1,702,810$ 2,332,518$ 1,209,566$ 2,303,051$ increase/(decrease) over 2023 Page 6 of 13 12/15/2023 City of Scandia 2024 Proposed Budget 3-Yr Avg 2023 Budget 11/27/2023 2024 Actual Approved YTD Actual Budget-5 Revenues over (Expenses)2,684$ (703)$ 209,068$ 25,199$ AMERICAN RESCUE PLAN REVENUES Revenues 203-46200-33150 Federal Grant 255,814$ -$ -$ 203-46200-36210 Interest Income 8,233$ 203-46200-39200 Interfund Transfer In 897$ 256,711$ -$ 8,233$ -$ AMERICAN RESCUE PLAN EXPENDITURES Expenditures 203-46200-720 Transfers to Other Funds -$ -$ -$ -$ -$ -$ -$ EDA REVENUE Revenues 225-46500-31000 Washington Cty. Tax Settlement 5,878$ 5,300$ 2,650$ 5,300$ 225-46500-33640 Other Grants -$ -$ -$ -$ 225-46500-34750 Facilities Rental 250$ -$ 825$ -$ 225-46500-36210 Interest Income 484$ 200$ 602$ 100$ 225-46500-36230 Donations 100$ -$ 300$ -$ 225-46500-39203 Transfer from Other Funds 925$ -$ 3,525$ -$ JE to balance EDA checking account 7,637$ 5,500$ 7,902$ 5,400$ EDA EXPENDITURES Expenditures 225-46500-210 Operating Supplies 355$ 500$ 3,525$ 300$ 225-46500-303 Engineering Fees -$ -$ -$ -$ 225-46500-304 Legal Services 25$ -$ -$ -$ 225-46500-308 Other Professional Services 246$ 300$ -$ 100$ 225-46500-340 Advertising 25$ 2,000$ 1,487$ 1,500$ 255-46500-433 Dues and Subscriptions 1,149$ 1,700$ 1,168$ 1,203$ $325 EDAM Dues; $325 FLA Chamber; MNRural Broadband Coalition 225-46500-440 Events 936$ 800$ 1,542$ 1,500$ Scandia Holiday Market 255-46500-720 Transfer Out 925$ -$ -$ -$ 3,662$ 5,300$ 7,722$ 4,603$ CABLE TV FUND REVENUES Revenues 226-41950-36210 Interest Income 113$ 100$ 240$ 100$ 226-41950-36260 Sale of Equipment -$ -$ 300$ -$ 226-41950-38050 Cable TV Franchise Rebates 17,320$ 16,200$ 16,839$ 16,700$ 226-41950-38051 PEG Fees 4,596$ 4,200$ 4,515$ 4,400$ 22,028$ 20,500$ 21,894$ 21,200$ CABLE TV FUND EXPENDITURES Expenditures 226-41950-240 Small Tools and Minor Equip 261$ 300 604$ 300$ 226-41950-309 Software Support & Maintenance 2,497$ 3,500$ 3,124$ 3,500$ Boxcast of meetings & storage 226-41950-438 Misc. Contractual 3,886$ 5,300$ 6,369$ 7,750$ LATV filming meetings $5,750; Zoom $2,000 226-41950-570 Office Equipment 13,914$ -$ 4,129$ -$ 20,559$ 9,100$ 14,226$ 11,550$ GATEWAY TRAIL FUND REVENUES Revenues 230-45000-36230 Donations 1,133$ -$ -$ -$ 1,133$ -$ -$ GATEWAY TRAIL FUND EXPENDITURES Expenditures 230-45000-308 Other Professional Services 1,192$ -$ -$ -$ 1,192$ -$ -$ -$ Page 7 of 13 12/15/2023 City of Scandia 2024 Proposed Budget 3-Yr Avg 2023 Budget 11/27/2023 2024 Actual Approved YTD Actual Budget-5 PUBLIC SAFETY AID FUND REVENUES Revenues 240-42300-33422 Other State Grants & Aid -$ -$ -$ -$ -$ -$ -$ -$ PUBLIC SAFETY AID FUND EXPENDITURES Expenditures 240-42300-540 Heavy Machinery Capital -$ -$ -$ -$ -$ -$ -$ -$ 2013 EQUIPMENT CERTIFICATE FUND REVENUES Revenues 313-47000-31000 Washington Cty. Tax Settlement 67,578$ 65,000$ -$ -$ PAID OFF 2023 313-47000-36210 Interest Income 16$ -$ -$ -$ 67,594$ 65,000$ -$ -$ 2013 EQUIPMENT CERTIFICATE FUND EXPENDITURES Expenditures 313-47000-304 Legal Services 313-47000-601 Long Term Debt Principal 60,000$ 60,000$ 60,000$ -$ PAID OFF IN 2023 313-47000-611 Long Term Debt Interest 5,330$ 3,047$ 930$ -$ 313-47000-620 Fiscal Agent s Fees 495$ 500$ -$ -$ 65,825$ 63,547$ 60,930$ -$ 2015 EQUIPMENT CERTIFICATE FUND REVENUES Revenues 315-47000-31000 Washington Cty. Tax Settlement 14,112$ 14,112$ -$ -$ 2015 EQUIPMENT CERTIFICATE FUND EXPENDITURES Expenditures 315-47000-601 Long Term Debt Principal 495$ PAID OFF IN 2020 315-47000-611 Long Term Debt Interest 495$ 990$ -$ -$ 2017 EQUIPMENT CERTIFICATE FUND REVENUES Revenues 317-47000-31000 Washington Cty. Tax Settlement 34,816$ 34,816$ -$ -$ 2017 EQUIPMENT CERTIFICATE FUND EXPENDITURES Expenditures 317-47000-601 Long Term Debt Principal 32,000$ PAID OFF IN 2022 317-47000-611 Long Term Debt Interest 1,717$ 317-47000-620 Fiscal Agent s Fees 145$ 33,717$ -$ -$ 2018 G.O. STREET RECONSTRUCTION FUND REVENUE Revenues 318-47000-31000 Washington Cty. Tax Settlement 334,812$ 342,546$ 171,268$ 345,634$ Payoff 2033 318-47000-36210 Interest Income 48$ -$ 1,053$ -$ First Call Date for Refinancing 12/15/2025 318-47000-39203 Transfer from Other Funds 8,290$ -$ -$ -$ 334,812$ 342,546$ 172,321$ 345,634$ Expenditures 2018 G.O. STREET RECONSTRUCTION FUND EXPENDITURES 318-47000-601 Long Term Debt Principal 221,667$ 250,000$ 235,000$ 245,000$ $3,835,000 original issue 318-47000-611 Long Term Debt Interest 104,675$ 91,225$ 91,225$ 84,175$ 318-47000-620 Fiscal Agent s Fees 495$ 500$ 495$ 495$ 326,837$ 341,725$ 326,720$ 329,670$ 2024 G.O. STREET RECONSTRUCTION FUND EXPENDITURES 318-47000-601 Long Term Debt Principal $4,000,000 original issue 318-47000-611 Long Term Debt Interest 318-47000-620 Fiscal Agents Fees 495$ -$ -$ 495$ Total Debt Service Fund Revenues 451,334$ 407,546$ 172,321$ 345,634$ Total Debt Service Fund Expenditures 461,086$ 405,272$ 387,650$ 330,165$ Page 8 of 13 12/15/2023 City of Scandia 2024 Proposed Budget 3-Yr Avg 2023 Budget 11/27/2023 2024 Actual Approved YTD Actual Budget-5 GENERAL CAPITAL INVESTMENT FUND REVENUE 401-48000-31000 Washington Cty. Tax Settlement 106,511$ 293,791$ 146,895$ 235,000$ 401-48000-33422 Other State Grants & Aids 41,752$ -$ 56,232$ 401-48000-33640 Other Grants -$ 401-48000-36210 Interest Income 2,022$ 2,300$ 12,932$ 3,000$ 401-48000-36230 Donations 2,030$ 401-48000-39200 Interfund Operating Transfer 66,667$ Total Capital Investment Fund Revenues 218,982$ 296,091$ 216,059$ 238,000$ CAPITAL INVESTMENT FUND EXPENDITURES Administration 401-41000-312 Planning Services 6,495$ -$ -$ -$ 401-41000-520 Administration Capital to Bldgs 5,329$ -$ -$ -$ 401-41000-530 Administration Capital 85,363$ 169,500$ -$ 250,000$ IAC request Fire Improvements 401-42200-520 Fire Capital to Bldgs -$ 65,000$ 90,034$ -$ 401-42200-530 Fire Capital Other than Buildings 78,931$ -$ -$ -$ Public Works 401-43000-520 Public Works Capital to Bldgs -$ -$ -$ -$ 401-43000-530 Public Works Capital 23,659$ -$ -$ -$ Streets & Roads 401-43100-530 Streets and Roads -$ -$ -$ -$ Park Improvement 401-45000-520 Park Capital to Buildings -$ -$ -$ -$ 401-45000-530 Park Capital Other than Buildings -$ -$ -$ -$ Community Center 401-45180-520 Community Center Building Impr 11,475$ -$ -$ 67,548$ Comm. Ctr. locks & office/equip room remodel 401-45180-530 Community Center Capital 3,675$ -$ -$ -$ General Improvements401-48000-101 Regular Wages & Salaries -$ -$ -$ -$ 401-48000-303 Engineering Fees -$ -$ 9,818$ -$ Gateway Trail 401-48000-308 Other Professional Services -$ -$ 26,400$ -$ Lobbying 401-48000-312 Planning Services -$ -$ -$ -$ 401-48000-435 Misc. Expense 4,000$ -$ -$ -$ 401-48000-438 Misc. Contractual -$ -$ -$ -$ 401-48000-520 Capital Improvements to Bldgs. 10,332$ -$ -$ -$ 401-48000-530 Capital Imp Other Than Bldgs. 136,231$ 100,000$ -$ 160,000$ new estimate per engineer & watershed per 6/16 email 401-48000-540 Heavy Machinery Capital -$ -$ -$ -$ 401-48000-550 Motor Vehicles Capital -$ -$ -$ -$ 401-48000-560 Furniture and Fixtures -$ -$ -$ -$ 401-48000-570 Office Equipment -$ -$ -$ -$ 401-48000-720 Operating Transfers 5,900$ -$ -$ -$ Total Capital Investment Fund Expenditures 364,894$ 334,500$ 126,252$ 477,548$ PARK INVESTMENT FUND REVENUES Revenues 404-48000-31000 Washington Cty. Tax Settlement 19,270$ 20,000$ 10,000$ 60,000$ 404-48000-33422 Other State Grants & Aids 8,249$ -$ -$ -$ 404-48000-33640 Other Grants -$ 112,500$ -$ -$ 404-48000-34730 Ballfield Ad Revenue -$ -$ -$ -$ 404-48000-34780 Park Dedication Fees 1,000$ 21,000$ 24,000$ -$ 404-48000-36210 Interest Income 371$ 66$ 2,702$ 66$ 404-48000-36230 Donations 2,917$ -$ 10,000$ -$ 404-48000-36260 Sale of Equipment -$ -$ -$ -$ 404-48000-39101 Sales of General Fixed Assets -$ -$ -$ -$ 404-48000-39203 Transfer from Other Funds -$ -$ 146,620$ -$ Total Park Investment Fund Revenues 31,807$ 153,566$ 193,322$ 60,066$ PARK INVESTMENT FUND EXPENDITURES Expenditures 404-48000-210 Operating Supplies 206$ -$ -$ -$ 404-48000-302 Surveying 700$ -$ -$ -$ 404-48000-303 Engineering Fees -$ -$ -$ -$ 404-48000-304 Legal Services -$ -$ -$ -$ 404-48000-308 Other Professional Services 403$ -$ -$ -$ 404-48000-312 Planning Services 350$ -$ 4,500$ -$ 404-48000-381 Utilities-Electric & Gas -$ -$ -$ -$ 404-48000-384 Refuse/Garbage Disposal 312$ -$ -$ -$ 404-48000-510 Capital Outlay-Land -$ -$ -$ -$ 404-48000-512 Easement Acquisition -$ -$ -$ -$ 404-48000-520 Capital Improvements to Bldgs. -$ -$ -$ -$ 404-48000-530 Capital Impr Other Than Bldgs. 27,346$ 85,125$ 191,937$ 150,000$ Tennis Courts 404-48000-720 Operating Transfers -$ -$ -$ -$ Total Park Investment Fund Expenditures 29,317$ 85,125$ 196,437$ 150,000$ Page 9 of 13 12/15/2023 City of Scandia 2024 Proposed Budget 3-Yr Avg 2023 Budget 11/27/2023 2024 Actual Approved YTD Actual Budget-5 EQUIPMENT REPLACEMENT FUND REVENUE Revenues 406-48500-31000 Washington Cty. Tax Settlement 81,870$ -$ 110,000$ 406-48500-36210 Interest Income 493$ 1,030$ 3,293$ 1,045$ 406-48500-36230 Donations -$ -$ -$ 406-48000-33422 Other State Grants & Aids -$ -$ 406-48500-36250 Misc. Refund -$ -$ -$ 406-48500-36260 Sale of Equipment 18,513$ 35,000$ -$ -$ 406-48500-39200 Interfund Operating Transfer -$ -$ -$ 406-48500-39350 Certificate of Indebtedness -$ 816,500$ -$ 350,000$ Total Equipmnt Replacement Fund Revenues 100,875$ 852,530$ 3,293$ 461,045$ EQUIPMENT REPLACEMENT FUND EXPENDITURES Expenditures 406-48500-304 Legal Services -$ -$ -$ -$ 406-48500-319 Other Services -$ -$ -$ -$ 406-48500-340 Advertising -$ -$ -$ -$ 406-48500-540 Heavy Machinery Capital 99,335$ 325,000$ 63,019$ 867,000$ 406-48500-550 Motor Vehicles Capital 13,358$ 189,500$ 12,717$ 84,356$ 406-48500-560 Furniture and Fixtures -$ -$ -$ -$ 406-48500-570 Office Equipment -$ -$ -$ -$ 406-48500-720 Operating Transfers -$ -$ -$ -$ Total Equipmnt Replacement Fund Expenditures 112,692$ 514,500$ 75,736$ 951,356$ LOCAL ROAD IMPROVEMENT FUND REVENUES Revenues 408-43100-31000 Washington Cty. Tax Settlement 336,353$ 212,012$ 106,006$ 375,000$ 408-43100-33422 Other State Grants & Aids 35,702$ -$ -$ -$ 408-43100-34304 Reimbursement for Services -$ -$ -$ -$ 408-43100-36100 Special Assessments -$ -$ -$ -$ 408-43100-36210 Interest Income 2,984$ 12,115$ 10,325$ 10,705$ 408-43100-39203 Transfer from Other Funds 26,667$ -$ -$ -$ 408-43100-39310 Proceeds-Gen Obligation Bond -$ -$ -$ 4,000,000$ 408-43100-36250 Misc. Refund -$ -$ -$ -$ Total Local Road Improvement Fund Revenues 401,706$ 224,127$ 116,331$ 4,385,705$ LOCAL ROAD IMPROVEMENT FUND EXPENDITURES Expenditures 408-43100-303 Engineering Fees 115,061$ 20,000$ 97,262$ 120,000$ 408-43100-530 Capital Impr Other Than Bldgs. 536,168$ 973,000$ 821,832$ 3,575,000$ 408-43100-720 Operating Transfers -$ -$ -$ -$ Total Local Road Improvement Fund Expenditures 651,228$ 993,000$ 919,094$ 3,695,000$ Total Levy Washington City. Tax Settlement 2,361,237$ 2,804,567$ 1,426,340$ 2,996,852$ increase/(decrease) over 2023 Page 10 of 13 12/15/2023 City of Scandia 2024 Proposed Budget 3-Yr Avg 2023 Budget 11/27/2023 2024 Actual Approved YTD Actual Budget-5 BLISS SEWER FUND REVENUES Revenues 602-43210-31951 Special Assessments Principal 962$ 2,066$ -$ 602-43210-31952 SA Penalties & Interest 1,593$ 600$ 282$ 420$ 602-43210-33422 Other State Grants & Aids 15,754$ -$ -$ -$ 602-43210-34401 Sewer User Fees 93,212$ 140,700$ 96,374$ 125,230$ 602-43210-34402 Sewer Connection Fee 5,333$ -$ 8,000$ -$ 602-43210-36100 Special Assessments -$ -$ -$ -$ 602-43210-36102 Penalties & Interest -$ -$ 132$ -$ 602-43210-36210 Interest Income 161$ 400$ 1,143$ 210$ 602-43210-36250 Misc. Refund 183$ -$ -$ -$ 602-43210-39200 Interfund Tranfers In -$ -$ -$ -$ Total Bliss Sewer Fund Revenues 117,198$ 141,700$ 107,997$ 125,860$ Expenditures BLISS SEWER FUND EXPENDITURES 602-43210-101 Regular Wages & Salaries 17,118$ 22,500$ 18,272$ 16,968$ 602-43210-102 OT Regular Wages 35$ -$ -$ 602-43210-120 Pension Expense (710)$ 1,368$ -$ 602-43210-121 PERA Coord. Employer Contribu. 1,280$ 1,700$ 1,273$ 602-43210-122 FICA Employer Contribution 1,019$ 1,400$ 1,067$ 1,052$ 602-43210-126 MEDICARE Employer Contribution 238$ 300$ 264$ 246$ 602-43210-151 Worker s Comp Insurance Prem 830$ 700$ 736$ 525$ 602-43210-200 Office Supplies 79$ 200$ -$ 91$ 602-43210-210 Operating Supplies 664$ 2,500$ 1,491$ 700$ Daily use items, hardwares, misc. items 602-43210-240 Small Tools and Minor Equip 110$ 600$ -$ 420$ Hand tools, septic/water sample tools 602-43210-303 Engineering Fees 7,940$ 10,500$ 69,333$ 7,718$ 5% increase 602-43210-304 Legal Services 2,000$ 18$ -$ 602-43210-308 Other Professional Services 3,947$ 2,500$ 6,905$ 3,500$ Water/Wastewater analytical testing 602-43210-309 Software Support & Maintenance 729$ 1,300$ -$ 910$ SCADA 602-43210-317 Employee Training 767$ 1,400$ 336$ 980$ Wastewater training 602-43210-321 Telephone 2,075$ 2,400$ 2,395$ 1,750$ SCADA dialers 602-43210-322 Postage 149$ 600$ -$ 420$ 602-43210-331 Travel Expenses 55$ 200$ 633$ 525$ 602-43210-334 Licenses & Permits 919$ 1,600$ 729$ 1,400$ Wastewater Certification/Permit Renewal 602-43210-361 Liability/Property Ins 1,031$ 3,000$ 3,449$ 2,535$ 5% increase 602-43210-381 Utilities-Electric & Gas 2,318$ 2,500$ 3,619$ 2,100$ 602-43210-385 Sewer Pumping & Maintenance 8,925$ 15,000$ 4,395$ 14,000$ Residential holding tank pumping 602-43210-386 Operation & Maintenance 2,363$ 5,000$ 2,639$ 3,500$ 602-43210-404 Repair Machinery/Equipment 8,804$ 16,000$ 12,101$ 11,200$ Pump and control repair/replacement 602-43210-413 Equipment Rental -$ 400$ -$ 700$ 602-43210-420 Depreciation Expense 32,947$ 54,300$ -$ 40,600$ approximate 602-43210-438 Misc. Contractual 4,578$ 10,000$ 930$ 7,000$ Emergency or additional holding tank pumping and maintenance, Lift station inspection/pump testing 602-43210-439 Refunds Issued -$ -$ 602-43210-530 Capital Impr Other Than Bldgs 35,426$ 9,800$ -$ 6,930$ Pump replacement 602-43210-570 Office Equipment -$ -$ -$ 602-43210-720 Operating Transfers -$ -$ -$ Total Bliss Sewer Fund Expenditures 135,637$ 166,400$ 130,678$ 127,042$ Page 11 of 13 12/15/2023 City of Scandia 2024 Proposed Budget 3-Yr Avg 2023 Budget 11/27/2023 2024 Actual Approved YTD Actual Budget-5 UPTOWN SEWER FUND REVENUES Revenues 612-43210-33422 Other State Grants & Aids 12$ -$ -$ -$ 612-43210-34401 Sewer User Fees 13,012$ 22,300$ 16,995$ 22,400$ 612-43210-34402 Sewer Connection Fee -$ -$ -$ -$ 612-43210-36210 Interest Income 40$ 200$ 263$ 50$ 612-43210-36250 Misc. Refund -$ -$ -$ -$ 612-43210-39203 Transfer from Other Funds -$ -$ -$ -$ Total Uptown Sewer Fund Revenues 13,063$ 22,500$ 17,258$ 22,450$ UPTOWN SEWER FUND EXPENDITURES Expenditures 612-43210-101 Regular Wages & Salaries 5,991$ 9,700$ 7,615$ 10,502$ 612-43210-102 OT Regular Wages -$ -$ -$ 612-43210-120 Pension Expense 178$ -$ -$ 612-43210-121 PERA Coord. Employer Contribu. 444$ 700$ 570$ 788$ 612-43210-122 FICA Employer Contribution 353$ 600$ 444$ 651$ 612-43210-126 MEDICARE Employer Contribution 82$ 100$ 110$ 152$ 612-43210-131 Employer Paid Health -$ -$ -$ -$ 612-43210-134 Employer Paid Life -$ -$ -$ -$ 612-43210-135 Employer Paid Disability -$ -$ -$ -$ 612-43210-151 Worker s Comp Insurance Prem 205$ 200$ 316$ 300$ 612-43210-200 Office Supplies 1$ 100$ -$ 100$ billing 612-43210-210 Operating Supplies 167$ 300$ -$ 500$ Daily use items, hardwares, misc. items 612-43210-221 Equipment Parts 46$ 300$ -$ 500$ 612-43210-303 Engineering Fees 2,624$ 1,000$ -$ 1,050$ 5% increase 612-43210-308 Other Professional Services 531$ 500$ 733$ 750$ Wastewater Analytical testing 612-43210-309 Software Support & Maintenance 81$ -$ 84$ 612-43210-317 Employee Training 130$ -$ 200$ 612-43210-319 Other Services -$ -$ 1,500$ 612-43210-322 Postage 6$ -$ -$ 612-43210-334 Licenses & Permits 228$ 247$ 250$ 612-43210-361 Liability/Property Ins 312$ 400$ 478$ 502$ 5% increase 612-43210-381 Utilities-Electric & Gas 567$ 1,700$ 668$ 1,000$ 612-43210-385 Sewer Pumping & Maintenance 22$ 1,500$ 1,500$ 1,500$ 612-43210-386 Operation & Maintenance 154$ 700$ -$ 1,000$ 612-43210-404 Repair Machinery/Equipment 411$ 2,000$ -$ 2,000$ 612-43210-420 Depreciation Expense 3,251$ 5,100$ -$ 4,900$ 612-43210-438 Misc. Contractual 216$ 1,300$ 140$ 1,500$ Lift Station Inspection/Pump Testing 612-43210-530 Capital Impr Other Than Bldgs 485$ 4,500$ -$ 9,900$ Pump Replacement 612-43210-570 Office Equipment -$ -$ -$ -$ 612-43210-720 Operating Transfers -$ -$ -$ -$ Total Uptown Sewer Fund Expenditures 16,487$ 30,700$ 12,820$ 39,628$ Page 12 of 13 12/15/2023 City of Scandia 2024 Proposed Budget 3-Yr Avg 2023 Budget 11/27/2023 2024 Actual Approved YTD Actual Budget-5 ANDERSON-ERICKSON SEWER FUND REVENUES Revenues 624-43210-31951 Special Assessments Principal 962$ 2,066$ -$ 624-43210-31952 SA Penalties & Interest 1,593$ 600$ 282$ 180$ 624-43210-33422 Other State Grants & Aids 15,754$ -$ -$ -$ 624-43210-34401 Sewer User Fees 93,212$ 140,700$ 96,374$ 53,670$ 624-43210-34402 Sewer Connection Fee 5,333$ -$ 8,000$ -$ 624-43210-36100 Special Assessments -$ -$ -$ -$ 624-43210-36102 Penalties & Interest -$ -$ 132$ -$ 624-43210-36210 Interest Income 161$ 400$ 1,143$ 90$ 624-43210-36250 Misc. Refund 183$ -$ -$ -$ 624-43210-39200 Interfund Tranfers In -$ -$ -$ -$ Total Anderson-Erickson Sewer Fund Revenues 117,198$ 141,700$ 107,997$ 53,940$ Expenditures ANDERSON-ERICKSON SEWER FUND EXPENDITURES 624-43210-101 Regular Wages & Salaries 17,118$ 22,500$ 18,272$ 7,272$ 624-43210-102 OT Regular Wages 35$ -$ -$ 624-43210-120 Pension Expense (710)$ 1,368$ -$ 624-43210-121 PERA Coord. Employer Contribu. 1,280$ 1,700$ 545$ 624-43210-122 FICA Employer Contribution 1,019$ 1,400$ 1,067$ 451$ 624-43210-126 MEDICARE Employer Contribution 238$ 300$ 264$ 105$ 624-43210-131 Employer Paid Health -$ -$ -$ 624-43210-134 Employer Paid Life -$ -$ -$ 624-43210-135 Employer Paid Disability -$ -$ -$ 624-43210-151 Worker s Comp Insurance Prem 830$ 700$ 736$ 225$ 624-43210-200 Office Supplies 79$ 200$ -$ 39$ 624-43210-210 Operating Supplies 664$ 2,500$ 1,491$ 300$ Daily use items, hardwares, misc. items 624-43210-240 Small Tools and Minor Equip 110$ 600$ -$ 180$ Hand tools, septic/water sample tools 624-43210-303 Engineering Fees 7,940$ 10,500$ 69,333$ -$ 5% increase 624-43210-304 Legal Services 2,000$ 18$ -$ 624-43210-308 Other Professional Services 3,947$ 2,500$ 6,905$ 1,500$ Water/Wastewater analytical testing 624-43210-309 Software Support & Maintenance 729$ 1,300$ -$ 390$ SCADA 624-43210-317 Employee Training 767$ 1,400$ 336$ 420$ Wastewater training 624-43210-321 Telephone 2,075$ 2,400$ 2,395$ 750$ SCADA dialers 624-43210-322 Postage 149$ 600$ -$ 180$ 624-43210-331 Travel Expenses 55$ 200$ 633$ 225$ 624-43210-334 Licenses & Permits 919$ 1,600$ 729$ 600$ Wastewater Certification/Permit Renewal 624-43210-361 Liability/Property Ins 1,031$ 3,000$ 3,449$ 1,086$ 5% increase 624-43210-381 Utilities-Electric & Gas 2,318$ 2,500$ 3,619$ 900$ 624-43210-385 Sewer Pumping & Maintenance 8,925$ 15,000$ 4,395$ 6,000$ Residential holding tank pumping 624-43210-386 Operation & Maintenance 2,363$ 5,000$ 2,639$ 1,500$ 624-43210-404 Repair Machinery/Equipment 8,804$ 16,000$ 12,101$ 4,800$ Pump and control repair/replacement 624-43210-413 Equipment Rental -$ 400$ -$ 300$ 624-43210-420 Depreciation Expense 32,947$ 54,300$ -$ 17,400$ approximate 624-43210-438 Misc. Contractual 4,578$ 10,000$ 930$ 3,000$ Emergency or additional holding tank pumping and maintenance, Lift station inspection/pump testing 624-43210-439 Refunds Issued -$ -$ 624-43210-530 Capital Impr Other Than Bldgs 35,426$ 9,800$ -$ 2,970$ Pump replacement 624-43210-570 Office Equipment -$ -$ -$ 624-43210-720 Operating Transfers -$ -$ -$ Total Anderson-Erickson Sewer Fund Expenditures 135,637$ 166,400$ 130,678$ 51,139$ Page 13 of 13 Inflation Assumptions 1 Revenue (Non-property tax) 0.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2 Interest Earnings 0.00% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3 Expenses 0.00% 4 CIP Inflation Factor 0.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 2022 2023 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 ACTUAL ACTUAL Projected REVENUE 5 Property taxes 217,336 293,791 235,000 242,050 251,732 261,801 272,273 283,164 294,491 306,270 318,521 6 Intergovernmental - - - - - - - - 7 Capital Improvement Debt Levy - - - - - - - - 8 Special assessments - - - - - - - - - - - 9 Investment Income 3,126 2,300 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 10 Refunds and Reimbursements 11 Park Dedication Fees 12 Rental and lease income - - - - - - - - - - - 13 Miscellaneous Revenue - - - - - - - - - - 14 Total Revenue 220,462 296,091 238,000 245,050 254,732 264,801 275,273 286,164 297,491 309,270 321,521 EXPENSES 15 Total Current - - - - - - - - - - - 16 Payables internet - - - - - - - - - - - 17 Debt service - - - - - - - - - - - 18 Total Capital Projects 296,733 224,459 477,548 603,001 185,072 364,185 230,000 112,072 208,135 169,859 618,083 19 Total Expenses 296,733 224,459 477,548 603,001 185,072 364,185 230,000 112,072 208,135 169,859 618,083 20 Revenue Over / (Under) Expenses (76,271) 71,632 (239,548) (357,951) 69,660 (99,384) 45,273 174,092 89,356 139,411 (296,562) OTHER FINANCING SOURCES / (USES) 21 Bond Proceeds 22 Transfers In - 8,000 - - - - - - - - - 23 Transfers Out to Sewer Fund (2,640) 24 Transfers Out- 25 Total Other Sources / (Uses) - 5,360 - - - - - - - - - 26 accounts payable 27 Prior Period Adjustments 28 Ending Fund Balance 564,735 641,727 402,179 44,228 113,888 14,504 59,778 233,870 323,226 462,637 487,596 CITY OF SCANDIA CITY OF SCANDIA Capital Improvement Plan Capital Improvement Plan Capital Improvement Fund 401 Capital Improvement Fund 401 CASH FLOW ANALYSIS 2022 2023 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Capital Project Name Year ACTUAL ACTUAL PROJECTED 29 12,000 30 Broadband Development Grants to MIDCO 2022 236,700 31 Development Code Update 2022 5,771 32 Community Center Improvements-Doors & security 2022 16,609 33 Council Chambers remodel 2022 5,103 7,476 34 Gateway Trail 2025 225,000 35 Broadband Development Grants to MIDCO 2023 12,750 119,500 250,000 250,000 36 County Ped & Bicycle Accomodations 2023 50,000 37 Wall Panel Joint Replacement Fire Hall-leaking 2023 16,250 38 Council Chambers remodel 2023 12,309 39 Security Improvements CCTV for Park 2024 14,000 40 Bliss Additions Stormwater plan 2023 160,000 139,185 41 new Exhaust removal system for truck bays 2024 58,399 42 new Warning Sirens 2025 31,633 43 Arts & Heritage Center Amphitheater 2027 - 44 Arts & Heritage Center Sidewalk and Walkways 2027 225,000 45 CC AC Condenser Replacement 2025 37,960 46 Lobbying 2025 26,400 47 Fire/PW Potable Well Pump (2000) Replacement 2026 11,699 48 2010 Fire Radios Replace 3 unspupported radios 2030 17,548 24,016 49 2010 Homatro Cutter Twin Line R-1(Jaws of Life)2030 40,945 56,036 50 2015 Lucas CPR Device-replacement 2030 17,548 24,016 51 Cold Storage Building 2030 112,072 52 Additional Comm Cent Elec Locks 2030 17,548 24,016 53 Large Hall and Heritage Room Carpeting 2030 80,052 54 2000 Station Bay floor epoxy coating-maintenance 2031 21,900 31,171 55 2010 Washer/Extractor-replacement 2031 9,125 12,988 56 2012 UTV & Trailer replacement-off road rescue 2031 42,583 60,609 57 2017 Thermal Imaging Cameras (1of3) find hot spots 2031 9,733 13,853 58 Zoll Monitor/Defib 2031 51,239 59 Second Fire Station 2032 230,000 337,136 60 Community Center Design & Planning 2032 280,947 61 Air Containment Unit 2033 62 Community Center Improvements-Front Office + Equip Room 50,000 63 CIP placeholder - SERVER REPLACEMENT 2035 7,800 Total Capital Projects 296,733 7,476 224,459 477,548 603,001 185,072 364,185 230,000 112,072 208,135 169,859 618,083 PROJECTED NEW DEBT TERMS Updated KHM As of Date:6/27/2023 1 Par Amount (Line 14) - - - - - - - - - - - 2 Number of Years 15 15 15 15 15 15 15 15 15 15 15 3 Interest Rate 0 0 0 0 0 0 0 0 0 0 0 4 New Debt Levy - - - - - - - - - - - Capital Project OutlayCapital Project OutlayProject CITY OF SCANDIA Financial Management Plan Park Capital Improvement Fund Inflation Assumptions 4 CIP Inflation Factor 4.00% 0.00% 2.00% 4.00% 4.00% 4.00%4.00% 4.00% 4.00% 4.00% 4.00% 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 ACTUAL Proposed REVENUE 5 Property taxes 20,000 20,000 60,000 62,400 64,896 67,492 70,192 72,999 75,919 78,956 82,114 6 Intergovernmental 10,125 112,500 7 Charges for services 8 Investment Income 620 66 66 66 66 66 66 66 66 66 66 9 Sale of capital assets 10 Park Dedication Fees 24,000 - - - - - - - - 11 Rental and lease income - - - - - - - - - - - Transfer from General Fund 150,000 12 Miscellaneous Revenue 7,949 8,068 13 Total Revenue 38,694 314,634 60,066 62,466 64,962 67,557 70,257 73,065 75,985 79,021 82,180 EXPENSES 14 Total Current 15 Debt service 16 Total Capital Projects 48,113 333,739 150,000 49,000 128,009 64,042 - - 17 Total Expenses 48,113 333,739 150,000 49,000 128,009 64,042 - - - - - 18 Revenue Over / (Under) Expenses (9,419) (19,105) (89,934) 13,466 (63,047) 3,516 70,257 73,065 75,985 79,021 82,180 OTHER FINANCING SOURCES / (USES) 19 Bond Proceeds 20 Transfers In 21 Transfers Out 8,000 22 Transfers Out- 22 Total Other Sources / (Uses)- 8,000 - - - - - - - - - 23 Prior Period Adjustments 24 Ending Fund Balance 138,798 111,692 21,758 35,223 (27,824)(24,308)45,949 119,013 194,998 274,019 356,199 CITY OF SCANDIA Financial Management Plan Park Capital Improvement Fund 404 CASH FLOW ANALYSIS 2021 2016 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Capital Project Name Year Costs ACTUAL Proposed 25 25 Park Planning 2022 15000 10,500 4,500 26 Community Center Park-concrete, grill, table, benches 2022 112500 33,488 27 Playground Equipment - Community Center Park 2022 122500 180,319 28 Lilleskogen Park Picnic Shelter 2024 43700 3,000 29 Gateway Trail Improvements @ Annex 2024 0 50,000 30 Hay Lake Park - sign 2023 8653 1,500 31 Park signage at Orwell Park (Liten)2023 8653 800 32 Replace rink boards 2024 134984 146,620 33 Lilleskogen Praire/Wetland Restoration Project 2025 12878 1,125 34 Nature park trails 2025 42700 49,000 35 Playground Equipment - Erickson ballfield 2025 66682 78,009 36 Tennis Court/Pickle Ball - repaint 2024 60533 150,000 37 Expanded Pleasure Rink 2027 12653 16,010 38 Hay Lake Park Shelter water & doors 2027 101226 128,083 39 New Ballfield to Replace South Ball Field 2027 44286 56,036 40 Settlers MonutPossible Reloc/Imp 2027 37960 48,032 41 CIP Place Holder 2031 50000 42 Total Capital Projects 874,908 - 48,113 333,739 150,000 49,000 128,009 64,042 128,083 56,036 - - - PROJECTED NEW DEBT TERMS 43 Par Amount (Line 19) - - - - - - - - - - - - 44 Number of Years 10 10 10 10 10 10 10 10 10 10 10 10 45 Interest Rate 2.00% 2.50% 3.00% 3.00% 3.00% 3.00%3.00% 3.00% 3.00% 3.00% 3.00% 46 New Debt Levy 0 0 0 0 0 0 0 0 0 0 0 0CAPITAL OUTLAYProject CAPITAL OUTLAY Inflation Assumptions 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 Interest Earnings 1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3 Expenses 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 4 CIP Inflation Factor 0.00%0.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Budget Projected REVENUE 5 Property taxes 87,800 - 110,000 114,400 118,976 123,735 128,684 133,832 139,185 144,752 150,543 156,564 6 Debt service levy - 43,082 92,319 178,483 215,411 215,411 295,421 295,421 295,421 295,421 7 Intergovernmental - - - - - - - - - - - - 8 Sale of capital assets 19,500 - - - - - - - - - 9 Investment Income 1,015 1,030 1,045 1,061 1,077 1,093 1,109 1,126 1,143 1,160 1,177 1,195 10 Refunds and Reimbursements 11 Park Dedication Fees 12 Rental and lease income - - - - - - - - - - - - 13 Miscellaneous Revenue - 176,000 14 Total Revenue 88,815 196,530 111,045 158,543 212,372 303,311 345,204 350,369 435,749 441,333 447,140 453,180 EXPENSES 15 Total Current - - - - - - - - - - - 16 Debt service - - - 41,031 87,923 169,984 205,153 205,153 281,353 281,353 281,353 281,353 17 Total Capital Projects 198,500 208,750 526,356 524,871 850,000 478,999 57,901 446,166 449,767 699,128 - - 18 Total Expenses 198,500 208,750 526,356 565,902 937,923 648,983 263,054 651,319 731,120 980,481 281,353 281,353 19 Revenue Over / (Under) Expenses (109,685) (12,220) (415,311) (407,358) (725,551) (345,672) 82,150 (300,950) (295,371) (539,148) 165,787 171,827 OTHER FINANCING SOURCES / (USES) 20 Bond Proceeds 350,000 400,000 700,000 300,000 650,000 - 21 Transfers In 22 Transfers Out 23 Transfers Out- 24 Total Other Sources / (Uses)- - 350,000 400,000 700,000 300,000 - 650,000 - - - - 25 Prior Period Adjustments 26 Ending Fund Balance 206,748 194,528 129,217 121,858 96,307 50,636 132,786 481,836 186,465 (352,683)(186,896)(15,069) CITY OF SCANDIA Capital Improvement Plan Equipment Replacement Fund 406 CASH FLOW ANALYSIS 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Capital Project Name First Year Last Year Costs Budget Projected 27 312-08 Asphalt Patching Equipment Trailer (2008) 2025 39000 45,624 28 2000 Engine 1 - 5176 Replacement 2026 650000 850,000 29 2003 Tanker 5178 Tender 2 Replacement 2025 292000 10,000 390,000 30 201-14 Mack Single Axle w/Plow (2014) 2029 275000 375,000 31 202-17 Western Star Single Axle Truck/Plow (2017) 2027 350000 478,999 32 203-11 Mack Dump Truck/Plow Replacement (2011) 2023 325000 325,000 33 301-98 John Deere Motor Grader (1998) 2031 480000 607,353 34 302-22 JD-6410 Tractor w/flail attachments (2022) 2022 198500 198,500 35 308-12 New Holland Skid Steer (2012) 2024 65000 90,000 36 Motor Grader 2022 0 37 Wall Panel Joint Replacement Fire Hall-leaking 2023 16250 16,250 37 101-18 Chev 1/2 ton pickup (2018) 2028 44000 57,901 38 102-19 Dodge 3500 SRW w/plow (2019) 2029 52000 71,166 39 103-21 Dodge 2500 w/plow (2021) 2031 62000 91,775 40 104-13 Ford F550 w/sander, plow mount, compressor 2024 75000 84,356 41 1995 Utility 1misc purpose truck - replacement 2023 86500 68,500 42 2003 Boat & Trailer - water rescues 2023 38000 51,000 43 303-17 Kubota F39000 Mower w/Broom & Blower (2017) 2023 65000 63,000 44 303-17 Kubota F39000 Mower w/Broom & Blower (2017) 2030 75000 106,748 45 304-21 Kubota UTV (2021) 2030 16000 22,773 46 Addition Vehicle (truck for addl FT or PT staff) 2025 50500 60,000 47 Equipment Attachments (fit skid, loader, tractor) 2024 10000 27,000 48 PJ Skid Trailer 14,000 lbs (2012) 2025 17000 19,888 49 Rescue 5179 Replacement 2030 225000 320,245 50 Utility Trailer 3,500 lbs (1998)2025 8000 9,359 52 Total Capital Projects 3,514,750 198,500 208,750 526,356 524,871 850,000 478,999 57,901 446,166 449,767 699,128 - - PROJECTED NEW DEBT TERMS KHM As of Date:6/27/2023 53 Par Amount (Line 14)- - 350,000 400,000 700,000 300,000 - 650,000 - - - - 54 Number of Years 10 10 10 10 10 10 10 10 10 10 10 10 55 Interest Rate 2.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 56 New Debt Levy 0 0 0 43,082 92,319 178,483 215,411 215,411 295,421 295,421 295,421 295,421Capital Equipment OutlayProject CITY OF SCANDIA CAPITAL IMPROVEMENT PLAN LOCAL ROAD IMPROVEMENT FUND 408 Inflation Assumptions 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 Interest Earnings 1.50%3.50%3.50%3.50%3.50%3.50%1.50%1.50%1.50%1.50%1.50% 3 Expenses 3.00%3.00%3.00%3.00%3.00% 4 CIP Inflation Factor 0.00%4.00%4.00%4.00%4.00%4.00%3.00%4.00%4.00%4.00%4.00% 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Actual Projected REVENUE 5 Property taxes 216,860 212,012 375,000 375,000 390,000 405,600 421,824 438,697 456,245 474,495 493,474 6 Debt levy - 384,386 384,386 789,023 789,023 789,023 1,060,983 1,060,983 1,060,983 7 Special assessments 8 Investment Income 4,655 12,115 10,705 34,880 12,248 (9,950) 10,820 (733) (12,290) 10,235 (605) 9 Refunds and Reimbursements 10 Intergovermental 17,744 11 Rental and lease income - - - - - - - - - - - 12 Miscellaneous Revenue - - - - - - - - - - - 13 Total Revenue 239,259 224,127 385,705 794,266 786,634 1,184,673 1,221,667 1,226,988 1,504,938 1,545,713 1,553,853 EXPENSES 14 Total Current 15 Debt service 366,082 366,082 366,082 751,451 751,451 751,451 1,010,460 1,010,460 16 Principal 17 Interest 18 Total Capital Projects 595,069 815,000 3,695,000 1,074,800 1,054,792 3,812,984 1,240,383 1,245,998 1,251,838 1,257,912 1,364,228 19 Total Expenses 595,069 815,000 3,695,000 1,440,882 1,420,874 4,179,065 1,991,834 1,997,449 2,003,289 2,268,372 2,374,688 20 Revenue Over / (Under) Expenses (355,810) (590,873) (3,309,295) (646,616) (634,239) (2,994,392) (770,167) (770,461) (498,351) (722,659) (820,836) OTHER FINANCING SOURCES / (USES) 21 Bond Proceeds 4,000,000 1,000,000 22 Bond premium 23 Transfers In 24 Transfers Out 25 Transfers Out- 25 Total Other Sources / (Uses)- - 4,000,000 - - 4,000,000 - - 2,000,000 - - 26 Prior Period Adjustments 27 Ending Fund Balance 896,739 305,866 996,571 349,955 (284,284) 721,324 (48,843)(819,304)682,345 (40,314)(861,150) CITY OF SCANDIA Financial Management Plan Local Road Improvement Fund 408 CASH FLOW ANALYSIS Project Multiple 2022 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Capital Project Name Number Year?First Year Last Year Costs Actual Proposed Est. 28 1,200,000 28 Soil Borings for 2024 & 2025 PW-061 2023 20000 25,000 29 Soil Borings for 2026 & 2027 PW-062 2025 20000 25,000 30 Soil Borings for 2028 & 2029 PW-069 2027 20000 28,000 31 Engineering Fees PW-070 100000 120,000 124,800 129,792 134,984 140,383 145,998 151,838 157,912 164,228 32 2022 Local Road Improvement Project PW-043 2022 707200 707,200 33 2023 Local Road Improvement Project PW-043 2023 790000 671,745 34 2023 Seal Coat & Crack Filling Project PW-050 2023 183000 168,374 35 2024 Local Road Improvement Project PW-056 2024 815000 3,575,000 36 2025 Local Road Improvement Project PW-053 2025 540000 750,000 37 2025 Seal Coat & Crack Filling PW-052 2025 252000 175,000 38 2026 Local Road Improvement Project PW-035 2027 870000 750,000 39 2026 Seal Coat & Crack Filling Project PW-051 2027 335000 175,000 40 2027 Local Road Improvement Project PW-057 2028 900000 3,500,000 41 2027 Seal Coat & Crack Filling PW-060 2028 78000 150,000 42 2028 Local Road Improvement Project PW-036 2029 1000000 1,100,000 43 2029 Local Road Improvement Project PW-060 2030 860000 - 1,100,000 44 2030 Local Road Improvement Project PW-072 2031 880000 - 1,100,000 45 2031 Local Road Improvement Project PW-073 2032 1000000 - 1,100,000 46 Total Capital Projects 9,370,200 - 707,200 865,119 3,695,000 1,074,800 1,054,792 3,812,984 1,240,383 1,245,998 1,251,838 1,257,912 1,364,228 PROJECTED NEW DEBT TERMS 47 Par Amount (Line 14)- - - 4,000,000 - - 4,000,000 - - 2,000,000 - - 48 Number of Years 9 15 15 15 15 15 15 15 15 10 15 15 49 Interest Rate 2.00%2.50%4.25%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00% 50 New Debt Levy 0 0 0 0 384,386 384,386 384,386 789,023 789,023 789,023 1,060,983 1,060,983Local Road Project OutlayProject 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% 1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.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% 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 513,213 533,742 555,092 577,295 600,387 624,403 649,379 675,354 702,368 730,463 759,681 790,068 821,671 1,060,983 1,324,848 1,324,848 1,324,848 1,324,848 1,324,848 940,462 668,502 668,502 263,865 263,865 263,865 - (12,917) (22,655) (10,273) (23,654) (14,403) (4,667) 5,575 10,580 17,461 28,736 34,532 46,634 59,373 - - - - - - - - - - - - - - - - - - - - - - - - - - 1,561,279 1,835,935 1,869,667 1,878,489 1,910,832 1,944,583 1,595,416 1,354,436 1,388,332 1,023,064 1,058,078 1,100,567 881,044 1,010,460 1,010,460 1,261,760 1,261,760 1,261,760 1,261,760 1,261,760 895,678 636,669 636,669 251,300 251,300 251,300 1,200,000 3,000,000 1,500,000 - - - - - - - - - - 2,210,460 4,010,460 2,761,760 1,261,760 1,261,760 1,261,760 1,261,760 895,678 636,669 636,669 251,300 251,300 251,300 (649,181) (2,174,525) (892,093) 616,729 649,072 682,823 333,656 458,758 751,663 386,395 806,778 849,267 629,744 - 3,000,000 - - - - - - - - - - - (1,510,330)(684,856)(1,576,949)(960,220)(311,148)371,675 705,331 1,164,089 1,915,752 2,302,147 3,108,925 3,958,192 4,587,937 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 1,200,000 3,000,000 1,500,000 1,200,000 3,000,000 1,500,000 - - - - - - - - - - - 3,000,000 - - - - - - - - - - - 15 15 15 15 15 15 15 15 15 15 15 15 15 5.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 1,060,983 1,060,983 1,324,848 1,324,848 1,324,848 1,324,848 1,324,848 940,462 668,502 668,502 263,865 263,865 263,865 RESOLUTION 12-19-23-01 A RESOLUTION ESTABLISHING EMPLOYEE PAY RATES FOR 2024 WHEREAS, The City of Scandia has established a step compensation plan for regular, part-time and full-time positions for non-represented employees on April 21, 2020; and, WHEREAS, this compensation plan does not supersede wages set by a collective bargaining agreement. Where such agreement is applicable, said agreement shall prevail; and, WHEREAS, The City sets wages for seasonal part-time employees, based on market conditions as consistent with the set compensation plan; and, WHEREAS, The Council approved the hiring of the part-time seasonal plow drivers and the seasonal ice rink workers at the September 19, 2023, October 17, 2023, and November 21, 2023; and, WHEREAS, The Council adopted Resolution No. 2022-40 on November 15, 2022 establishing Fire Department compensation effective January 1, 2023. NOW, THEREFORE, BE IT HEREBY RESOLVED BY THE CITY COUNCIL OF THE CITY OF SCANDIA, WASHINGTON COUNTY, MINNESOTA, that it should and hereby does approve the following pay rates for 2024 as shown to be applied January 1, 2024. Seasonal, Part-time Positions: 2023 Pay Rate 2024 Pay Rate Recreation Program Teacher $12.85 $12.85 Ice Rink Lead Attendant $15.50 $15.75 Ice Rink Maintenance Worker $15.50 $17.50 Park Attendant (Ice Rink) $13.50 - $13.75 $13.75 - $13.75 Maintenance Worker, Seasonal (Snow Plowing Class A license) $18.00 - $19.10 $18.00 - $19.10 Maintenance Worker, Seasonal (Parks/Grounds Maintenance) $15.00 -$17.50 $15.00 - $17.50 Maintenance Worker, Seasonal (Public Works/ Summer) $15.00 - $17.50 $15.00 - $17.50 Head Election Judge $13.00 $14.00 Election Judge $11.00 $12.00 Community Center Attendant $120 (per event) $120 (per event) Community Center Cleaner $150 (per event) $150 (per event) Regular Full-Time and Part-time Positions: 2023 Pay Rate 2024 Pay Rate Administrative Assistant & Park & Recreation Coordinator $20.94 $22.03 City Treasurer $24.03 $26.31 City Clerk $30.55 $33.45 Public Works Director $44.84 $46.41 Fire Chief $44.58 $46.14 City Administrator $55.28 $57.22 Resolution No. 12-19-23-01 Page 2 of 2 Scandia Fire and Rescue Department Hourly (Paid in Half -Hour Increments): Pay Rate: Probationary Firefighter/ Base Pay: $16.00 Non -probationary Firefighter: $17.00 Emergency Medical Technician: + $1.00 Firefighter II: + $1.00 Officer: + $1.00 Other Compensation: Fire Chief In separate policy Assistant Chief $300.00 / mo. Fire Captain $200.00 / mo. Fire Engineer $150.00 / mo. Certification as Emergency Medical Technician $150.00 Certification as Firefighter II $150.00 Attendance at Minnesota State Sectional Fire School $75.00 / Training Adopted by the Scandia City Council this 19th day of December, 2023. ________________________________ Christine Maefsky, Mayor ATTEST: ___________________________________ Kyle Morell, Administrator CITY OF SCANDIA SUMMARY BUDGET 6/20/2023 Inflation Assumptions 677,171 810,813 806,068 830,250 855,157 880,812 Revenue (Non-property tax) 1.00% 1.00% 1.00% 1.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% Interest Earnings 3.25% 3.25% 3.25% 3.25% 3.25% 3.25% 3.25% 3.25% 3.25% 3.25% Expenses 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% Audited Budgeted Budgeted Projected Projected Projected Projected Projected Projected Projected GENERAL FUND 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 REVENUE 1 General Property Tax-Current 1,607,142 1,865,918 1,865,918 1,921,896 1,979,552 2,038,939 2,100,107 2,163,110 2,228,004 2,294,844 2 Other taxes 4,115 149,697 134,357 135,701 138,415 141,183 144,007 146,887 149,824 152,821 3 Intergovernmental 69,875 61,000 71,674 72,391 73,839 75,315 76,822 78,358 79,925 81,524 4 Grants 11,700 5 Franchise fees - 6 Licenses and Permits 182,640 161,100 179,100 180,891 184,509 188,199 191,963 195,802 199,718 203,713 7 Charges for Services 53,383 53,000 53,565 54,101 55,183 56,287 57,412 58,560 59,732 60,926 8 Fines & Forfeits 6,027 7,400 7,000 7,070 7,282 7,501 7,726 7,957 8,196 8,442 9 Interest Earnings 5,459 12,100 5,636 5,819 5,994 6,174 6,359 6,550 6,746 6,949 10 Miscellaneous Revenues 13,452 9,900 11,000 11,358 11,698 12,049 12,411 12,783 13,166 13,561 11 - - - - - - - - - - 12 Total Revenue 1,942,093 2,331,815 2,328,250 2,389,226 2,456,471 2,525,646 2,596,806 2,670,008 2,745,312 2,822,779 EXPENSES 13 Current 14 General Government 667,685 754,700 728,420 750,273 772,781 795,964 819,843 844,438 869,772 895,865 15 Public Safety 458,856 504,399 547,726 564,158 581,083 598,515 616,471 634,965 654,014 673,634 16 Public Works 636,351 732,450 820,937 845,565 870,932 897,060 923,972 951,691 980,242 1,009,649 17 Park and Recreation 171,884 175,060 205,968 212,147 218,511 225,066 231,818 238,773 245,936 253,314 18 Applied to Federal Grant 19 Federal fund returned 20 Capital Outlay - 150,000 21 - 22 - 23 - 24 - 25 Total Expenses 1,934,776 2,316,609 2,303,051 2,372,142 2,443,307 2,516,606 2,592,104 2,669,867 2,749,963 2,832,462 26 Revenues Over / (Under) Expenses 7,317 15,206 25,199 17,083 13,165 9,040 4,702 141 (4,651) (9,683) 38 Ending General Fund Balance (FB) 1,349,787 1,364,993 1,390,192 1,407,275 1,420,440 1,429,480 1,434,182 1,434,322 1,429,671 1,419,988 39 Restricted - - - - - - - - - - 40 Unassigned 1,349,787 1,364,993 1,390,192 1,407,275 1,420,440 1,429,480 1,434,182 1,434,322 1,429,671 1,419,988 41 Fund Balance as a % of Next Year's Expenditures (net of contingency) 58.3% 59.3% 58.6% 57.6% 56.4% 55.1% 53.7% 52.2% 50.5% #DIV/0! Preliminary Projected Levy by Type 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 41 General Fund Operating Tax Levy 1,607,142 1,865,918 1,865,918 1,921,896 1,979,552 2,038,939 2,100,107 2,163,110 2,228,004 2,294,844 42 Annual Increase 16.3% 16.1% 0.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% ANNUAL DEBT LEVIES BY BOND ISSUE-FUTURE 43 44 BONDS ISSUED 4,000,000 4,000,000 2,000,000 45 EQUIPMENT CERTIFICATES 350,000 900,000 400,000 300,000 600,000 46 47 - 48 Total Annual Debt Issuance - - 4,350,000 900,000 400,000 4,300,000 - 600,000 2,000,000 - OTHER SPECIAL TAX LEVIES 49 Debt service 50 2013 Certificates 67,000 64,000 51 2015 Certificates 52 2017 Certificates 34,524 53 2018 GO Bonds 344,531 342,536 345,634 343,166 340,541 343,009 345,161 341,749 343,429 344,794 54 Capital Improvement Debt Levy 55 Equipment Replacement Debt Levy - 43,082 92,319 178,483 215,411 215,411 295,421 295,421 56 Local road improvement Debt Levy 384,386 384,386 789,023 789,023 789,023 1,060,983 1,060,983 57 Total Annual Debt Levies 446,055 406,536 345,634 770,634 817,246 1,310,516 1,349,596 1,346,183 1,699,833 1,701,198 ANNUAL CAPITAL PROJECTS LEVIES 58 Capital Improvement 217,336 293,791 235,000 242,050 251,732 261,801 272,273 283,164 294,491 306,270 59 Park Improvement 20,000 20,000 60,000 62,400 64,896 67,492 70,192 72,999 75,919 78,956 60 Equipment Replacement 87,800 - 110,000 114,400 118,976 123,735 128,684 133,832 139,185 144,752 61 Local Road Improvement 216,860 212,012 375,000 375,000 390,000 405,600 421,824 438,697 456,245 474,495 62 63 64 EDA 8,000 5,300 5,300 5,300 5,300 5,300 5,300 5,300 5,300 5,300 65 66 67 Total Other Special Levies 549,996 531,103 785,300 799,150 830,904 863,928 898,273 933,992 971,140 1,009,774 68 Total Tax Levy 2,603,193 2,803,557 2,996,852 3,491,680 3,627,702 4,213,383 4,347,976 4,443,286 4,898,976 5,005,815 69 Increase/(Decrease) in Total Tax Levy 14.67% 7.70% 6.89% 16.51% 3.90% 16.14% 3.19% 2.19% 10.26% 2.18% 70 Less: Fiscal Disparities (132,739) (123,279) (107,857) (104,864) (117,080) (116,692) (130,936) (129,598) (127,470) (135,575) 71 Net Levy to Taxpayers 2,470,454 2,680,278 2,888,995 3,386,816 3,510,623 4,096,691 4,217,041 4,313,688 4,771,507 4,870,240 72 73 Existing Tax Base 8,336,001 10,129,722 10,847,248 11,389,610 11,845,194 12,319,002 12,811,762 13,324,232 13,857,201 14,411,489 83 5.37% 21.52% 7.08% 84 New Net Tax Capacity 0 0 0 0 0 0 0 0 0 0 85 Total Net Tax Capacity 8,336,001 10,129,722 10,847,248 11,389,610 11,845,194 12,319,002 12,811,762 13,324,232 13,857,201 14,411,489 86 Tax Rate on Tax Capacity 29.636% 26.460% 26.633% 29.736% 29.638% 33.255% 32.915% 32.375% 34.433% 33.794% 87 Tax Rate % Change 9.24063% -10.72% 0.66% 11.65% -0.33% 12.21% -1.02% -1.64% 6.36% -1.86% 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 $2,803,556 $3,021,852 7.8% 2.State Aids - $0 $0 0.0% 3. Certified Property Tax Levy = $2,803,556 $3,021,852 7.786% 4.Fiscal Disparity Portion of Levy - $123,297 $107,857 -12.5% 5.Local Portion of Levy = $2,680,259 $2,913,995 8.7% 6.Local Taxable Value 2024 is an ESTIMATE ÷ 10,129,722 $10,847,248 7.1% 7. Local Tax Rate = 26.459% 26.864% 1.5% 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.1%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.465,100 0 465,100 4,651 $1,230.62 15.500,000 0 500,000 5,000 $1,322.97 16.600,000 0 600,000 6,250 $1,653.71 17.700,000 0 700,000 7,500 $1,984.45 18.388,000 2,300 385,700 3,857 $1,020.54 Proposed Pay 2024 Pay 2024 MV 76,000 @40% 500,000@1.0% (B7 x G) + X 1.031 - rem @ 9% (D) - (E) rem @ 1.25% (B12 x D) 19.479,500 0 479,500 4,795 $1,288.13 20.515,500 0 515,500 5,194 $1,395.32 21.618,600 0 618,600 6,483 $1,741.59 22.721,700 0 721,700 7,771 $2,087.60 23.400,000 1,200 398,800 3,988 $1,071.34 Percentage Change from 2023 to 2024 24.3.1% 0.0% 3.1% 3.1% 4.7% 25.3.1% 0.0% 3.1% 3.9% 5.5% 26.3.1% 0.0% 3.1% 3.7% 5.3% 27.3.1% 0.0% 3.1% 3.6% 5.2% 28.3.1%-47.8%3.4%3.4%5.0% 0400 Scandia Instructions for Calculating a Residential Homestead Property Tax: D.Market Value of Residential Homestead Assumes that the Pay 2024 market value changed from Pay 2023 by 3.1%. Countywide, the median change in market value from Pay 2023 to Pay 2024 is 8.1%. E.Calculate the Homestead Market Value Exclusion 40% of the first 76,000 of market value (D), reduced by 9% on the market value over 76,000 The exclusion decreases as the market value over 76,000 increases, until a 413,300 home receives 0 exclusion. F.Calculate Taxable Market Value Market Value before Exclusion (D) - Homestead Market Value Exclusion (E). G.Calculate the Net Tax Capacity of a Residential Homestead Pay 2023: 1st 500,000 of (F) Taxable Market Value @ 1.00%, remainder @ 1.25% Pay 2024: 1st 500,000 of (F) Taxable Market Value @ 1.00%, remainder @ 1.25% H.Calculate the Taxing District's portion of the Tax Pay 2023: multiply the Pay 2023 net tax capacity (G) by the Pay 2023 tax capacity local tax rate (A7), plus multiply the Pay 2023 market value before exclusion (D) by the Pay 2023 market value tax rate (A12) Pay 2024: multiply the Pay 2024 net tax capacity (G) by the Pay 2024 tax capacity local tax rate (B7) , plus multiply the Pay 2024 market value before exclusion (D) by the Pay 2024 market value tax rate (B12) 19-23.Line 19 will default to the median residential homestead value for the taxing authority for taxes payable in 2024. 24-28.Calculate the % increase/decrease from 2023 to 2024 (2024 -2023) / 2023 There is no longer a homestead credit. The market value homestead credit was eliminated starting with taxes payable in 2012 and was replaced with a market value exclusion for homestead property.