Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
06. 2025 Draft Final Budget Report
Staff Report Date of Meeting: November 6, 2024 For: Honorable Mayor and Council From: Kyle Morell, City Administrator Subject: 2025 Final Draft Budget Discussion Background: The Capital Investment Committee met three 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 2024 spending as guides for future revenue and expense projections. Staff prepared a 2025 Preliminary Budget presentation outlining the recommendations of the CIP Committee, detailed the 2025 revenues and expenses for each CIP fund, and outlined the assumptions made in assembling the preliminary budget. The 2025 Preliminary Budget, individual CIP Fund documents, and a Summary Budget document that shows the complete levy picture and the proposed 2025 tax rate are also included. The first draft of the budget presented at the August 7 Work Session showed a total city budget of $3,390,434, a $393,582 increase over 2024. This resulted in a project tax rate of 30.535%, 3.902% higher than 2024, or a 14.65% increase in the tax rate. Public attendance at this meeting was high, and it was explained that this was the first draft of the budget. Increases in contracted services and insurance were estimated to be higher than in past increases. Fire Department wages were also increased by 23% to reflect better actual past amounts. Changes would be made to the budget as we progressed in the budget cycle to reduce the levy and tax rate. Councilmember Benson pointed out that the proposed rate was similar to the 2022 tax rate before the Council lowered the rate in 2023. At the September 4 Work Session, the budget presented to the Council showed a levy of $3,300,330, $90,105 less than in August. The proposed 2025 tax rate has also been reduced to 29.549%, or a 10.95% increase over the 2024 tax rate of 26.633%. Discussion at the September 17 Regular Meeting centered around the appropriate use of the ARPA funding. After a good discussion, the Council directed staff to apply the ARPA funding to purchase the new fire engine slated for later this year. Doing so reduced the equipment certificate amount needed for the engine by $460,000, from $800,000 to $340,000, thereby reducing the levy needed to pay off the certificate by $55,000. Staff also adjusted the levy amount for the 2024 GO Bond payment. Using project savings and interest earned from bond proceeds, the levy amount was reduced by $100,000 from $219,569 to $119,569. September interest earnings further reduced the 2024 GO Bond payment levy to $115,703. Once October interest numbers are available, the amount will be further reduced. The City received notice from its insurance company that property insurance and workers' compensation rates are decreasing. Without knowing the exact reduction, we budget flat rates across these line items, removing the 10% increase we had previously applied. The City’s General Fund budget shows total 2025 expenditures at $2,362.729, with revenues projected to be $2,399,449, providing the budget a cushion of $36,770. The primary expense increase is due to the accurate budgeting of fire department wages, which have been under- budgeted in past years. 2025 saw a 23% increase in fire department wages. The budget includes a full-time Treasurer and a three-month overlap with our current Treasurer. 2025 health insurance renewals came in for City staff, and the monthly premium was reduced by 5.1%. This has been reflected in the 2025 budget numbers. The total General Fund levy is $1,893,907, a $27,989 increase (1.5%) over 2024. The City added debt service payments in 2024 with the bonding for the 2024 Street Reconstruction and Seal Coating and Crack Filling Projects. The scheduled debt service payment for that bond is $359,887.50. I have reduced that obligation to $115,703 in 2025 by applying $44,185 in interest earnings and $200,000 in project savings towards that levy amount. Total project savings are expected to be between $450,000 and $480,000. The remaining amount has been applied to the 2026 bond payment to help reduce the 2026 levy. The City will issue a $340,000 equipment certificate to pay for the new fire department engine before the end of 2024. ARPA funding and cash will be used to cover the remaining balance. This adds $37,000 to our debt service levy in 2025(down from $89,000 without the use of ARPA funds). The budget also shows the issuance of $515,510 in equipment certificates in 2025, with payments beginning in 2026. These certificates are for the new plow truck and fire department tanker. The City continues to make payments on the 2018 road bond, which is $343,166 in 2025. The total debt service levy is $497,866, $152,232 more than in 2024. The CIP Fund documents have been adjusted since our last meeting. The 401 shows a reduction in the levy amount for 2025. Excess fund balance allowed for this reduction in revenue while still planning for six project expenditures in 2025. The 404 Fund shows the transfer of $125,000 in excess fund balance and the $150,000 transfer from the 401 Fund to pay for the tennis court reconstruction. The 406 Fund shows the issuance of a $340,000 equipment certificate to pay for the new fire department engine delivered in late 2024. The 408 Fund levy amount has been increased at the recommendation of the CIP Committee. The total CIP levy is $730,000, $55,300 less than in 2024. The proposed preliminary 2025 levy amount is $3,121,773. This represents a $124,921 increase (4.17%) over the final 2024 amount. If this amount were approved as the City’s final levy, the 2025 tax rate would be 27.867%, 1.163% points higher than 2024, or a 4.35% increase. As these expenses are clarified between now and the December Truth-in-Taxation hearing, they and the final levy amount will be adjusted. Sewer Budgets The 2025 sewer budgets have been completed. We have split the Bliss and Anderson Erickson sewer systems into two separate funds. This allows us to understand better the cost of operating each system and ensure the residents only pay for the operation of the system they live on. The Wastewater Committee meets on Wednesday, October 30, 2024, to discuss the 2025 budget. Out of that discussion came a decision to change how the City bills for sewer service. We will continue to have a user fee, but we will begin charging for services related to tank pumping, pump replacement, and after-hours calls. This will allow us to reduce the user fee and bill those residents for services provided as they are needed. This should eliminate concern over how frequently some people's tanks are pumped versus others. I will also attempt to implement a seasonal user fee. With this change, the committee hopes we can finally get to a place where those who use the system the most contribute to it the most. I plan to present this new billing system to the Council at the November 19 regular meeting. The Bliss and A&E expense budgets will not change, but the revenue line items will change as we add revenue from the service provided. The Uptown System continues to operate within its means. The reopening of the Café will help with revenue. The projected revenue does cover the cost of operations, but it does not cover depreciation. Currently, the users can expect a 25% increase in user fees. We will continue to monitor revenues and expenses and adjust accordingly. Recommendation: No action is needed at this time. Attachments: 2025 Preliminary Budget Presentation 2025 Preliminary Budget 401 CIP Fund 404 CIP Fund 406 CIP Fund 408 CIP Fund Summary Budget Worksheet 2025 Preliminary Budget November 6, 2024 Discussion Items Capital Improvement Committee Recommendations. Review of CIP and budget impacts Brief Introduction to the proposed 2025 General Fund Budget Council is encouraged to ask questions, offer comments, and suggest changes at anytime Capital Investment Committee Recommendations Establish consistent annual levy-supported cash contributions to all Capital Improvement Funds Increase levy amount in 408 Road Improvement Fund by 10% from the proposed 2024 amount ($400,000 to $440,000) Utilize additional road rating technology to rate roads in 2025 Create a public input plan to engage the public in discussion about the appropriate amount of money for annual road maintenance Capital Investment Committee Recommendations cont. Consider a change to driveway culvert policy, returning ownership and maintenance to residents – Staff will bring model language forward at a later date Consider adopting additional development fees, including seal coating and stormwater fees – These will be included in the 2025 fee schedule Issue equipment certificates for fire department vehicle purchases 2025 Capital Improvement Fund – 401 General Fund Beginning Fund Balance includes a $150,000 transfer out to 404 Park CIP to support the Tennis Court project in 2024 $125,000 tax levy to support recommended projects Six projects totaling $ 358,041 Fund Balance will be used to make up the shortage Ending Fund Balance of $454,826 $686,867 Beginning Fund Balance Revenue $125,000 Levy $1,000 Interest $126,000 Total Expenses $30,0002025 LCCMR – Gateway Trail $92,000Broadband $17,548 Fire Dept Radios $40,945Jaws of Life $17,548Lucas CPR Device $160,000Cold Storage Building $358,041 Total ($232,041)Revenue Over/(Under)Expenses $454,826 Ending Fund Balance 2025 Capital Improvement Fund – 404 Park Fund 2024 - Transfer of $125,000 in Unassigned Fund Balance and a Transfer from 401 of $150,000 will provide a one-time revenue increase for 2024/2025 projects $40,000 tax levy to support recommended projects One project totaling $ 150,000 Ending Fund Balance of $13,058 $122,993 Beginning Fund Balance Revenue $40,000 Levy $66 Interest $40,066Total Expenses $150,000Tennis Court Improvements $150,000Total ($109,934)Revenue Over/(Under)Expenses $13,058 Ending Fund Balance 2025 Capital Improvement Fund – 406 Equipment Fund $125,000 tax levy to support recommended projects Two purchases totaling $592,296 Equipment Certificate issued for $515,510 to pay for tanker New debt levy of approximately $66,400, starting in 2026 until 2036, for the plow truck and 2040 for the tanker Ending Fund Balance of $61,826 $10,694 Beginning Fund Balance Revenue $125,000 Levy $1,061 Interest $126,061 Total Expenses $286,787 2003 Tanker 2 Replacement $305,5092011 Snow Plow Replacements $592,296 Total ($466,225)Revenue Over/(Under)Expenses Other $515,510Bond Proceeds $61,826 Ending Fund Balance 2025 Capital Improvement Fund – 408 Street Improvement Fund $440,000 tax levy to support recommended projects One street reconstruction project totaling $ 665,000 Ending Fund Balance of $299,377 $514,377 Beginning Fund Balance Revenue $440,000 Levy $10,000Interest $450,000Total Expenses $665,0002025 Local Road Improvement $665,000Total ($205,000)Revenue Over/(Under)Expenses $299,377 Ending Fund Balance 2025 Preliminary Budget - Revenues The General Fund levy is projected to be $1,893,907, a $27,989 increase over 2024, or a 1.5% increase. Licenses and Permits have been increased slightly to reflect fees collected from new cannabis registrations. Interest earning has been increased to reflect the increased rates available to the City’s money market account. Total General Fund Revenue is $2,399,499. This is a 3.15% increase over 2024. 2025 Preliminary Budget - Expenses All personnel wages have been increased by 3.5% following the negotiated union wage increase. Council wages have been increased, estimated to be at 3.5%. The actual increase is based on the 12-month CPI from November 2023 to November 2024 Budget includes a full-time Treasurer Fire Department wages have been increased by 23% to better reflect actual wages paid Public Works includes $175,000 for contractual road maintenance and repair. This is in addition to the CIP projects 2025 Preliminary Budget - Expenses The following percentage increases are assumptions. Actual numbers will not be available until later in the year. All Health and Dental Insurance line items have been decreased by 5.1% Property and workers comp insurance line items are budgeted flat due to overall premium reduction from The League Insurance Trust Bolton & Menk services have been increased by 5% Policing services have been increased by 5.91% per 2025 Agreement Total expenses are $2,362,729. This is a 3.32% increase over 2024 General Fund Budget Summary Difference2025 Preliminary 2024 Actual 73,376$2,399,499$2,326,123Total General Fund Revenue $75,907$2,362,729*$2,286,822Total General Fund Expenses ($2,531)$36,770$39,301Revenues Over / (Under) Expenses (0.2%)59.2%59.4%Estimated Fund Balance** * Current expenses have been reduced by $19,288 from August Presentation **Shows Fund Balance as an estimated percentage of next year’s projected expenses Tax Levy Summary Difference2025 Preliminary 2024 Actual $27,989$1,893,907$1,865,918General Fund Levy $152,232$497,866*$345,634Debt Service Levy ($55,300)$730,000$785,300CIP Funds Levy $0$0$5,300EDA Levy $124,921$3,121,773$2,996,852Total Levy ($15,822)($123,679)**($107,857)Less Fiscal Disparities $109,099$2,998,094***$2,888,995Total Net Levy * $244,185 in interest and project savings are being used to reduce the levy amount of the 2024 Road Project Bond, and applying ARPA funds to fire engine purchase reduced the levy amount by $55,000 **Actual 2025 Amount *** The current Net Levy has been reduced by $271,049 from the budget presented in August Tax Rate Summary Difference2025 Preliminary 2024 Actual ($59,898)$10,758,518$10,818,416Estimated Tax Capacity $109,099$2,998,094$2,888,995Net Levy 1.163%27.867%26.704%Tax Rate * Tax Rate at August presentation was 30.535% Historic Tax Rate Summary % ChangeTax Rate 35.124%2017 -2.37%34.293%2018 -7.83%31.607%2019 -2.62%30.777%2020 -11.85%27.129%2021 9.24%29.636%2022 -10.72%26.460%2023 0.93%26.704%2024 4.35%27.867%2025 9 Year Average – 29.955% Estimated 2025 Tax Impact – City Portion Percent Difference 2025 Tax Amount2024 Tax AmountHome Value 4.7%$1,351.57$1,289.82$487,100 4.9%$1,390.64$1,324.01$500,000 5.4%$1,743.88$1,652.47$600,000 5.4%$2,092.65$1,983.60$700,000 5.4%$2,441.43$2,314.20$800,000 Looking Forward Staff will continue to update projected numbers with actual numbers when they come in. Multiple budget documents can be prepared to show various scenarios if the Council wishes to evaluate multiple levy and spending options. The next budget discussion is scheduled for the Truth-In-Taxation Hearing at Council’s Work Session on December 4, 2024. 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments Revenues FUND 101 GENERAL FUND Taxes Revenue 101-41000-31000 Washington Cty. Tax Settlement 1,261,913$ 1,441,883$ 1,733,913$ 1,479,236$ 1,865,918$ 1,003,106$ 1,893,907$ 101-41000-31040 Fiscal Disparities 124,112$ 132,738$ 122,682$ 126,511$ 107,857$ 76,018$ 123,679$ 101-41000-31701 Gravel Taxes 27,751$ 24,044$ 15,146$ 22,314$ 20,000$ -$ 20,000$ 101-41000-31830 Solar Energy Production Tax 6,965$ 4,115$ 5,874$ 5,651$ 5,500$ 2,000$ 5,500$ 101-41000-31900 Penalties & Interest Delinquent Tax 2,475$ 235$ -$ 903$ 1,000$ -$ -$ 1,423,217$ 1,603,015$ 1,877,615$ 1,634,615$ 2,000,275$ 1,081,125$ 2,043,086$ Licenses and Permits Revenues 101-41000-32150 ROW-Utility Permits 6,450$ 5,700$ 4,800$ 5,650$ 5,000$ 2,100$ 5,000$ 101-41000-32180 Tobacco and Liquor Licenses 12,585$ 11,357$ 12,660$ 12,201$ 11,000$ 1,150$ 15,000$ 101-41000-32190 Other City Permits 2,959$ 3,225$ 2,670$ 2,951$ 3,000$ 1,419$ 3,000$ 101-41000-32210 Building Permits 196,155$ 162,113$ 175,019$ 177,762$ 160,000$ 107,434$ 160,000$ 101-41000-32260 Gambling Permits 130$ 245$ 45$ 140$ 100$ 130$ 100$ 218,279$ 182,640$ 195,194$ 198,704$ 179,100$ 112,233$ 183,100$ Intergovernmental Revenues 101-41000-33401 LGA/MVHC/AG/PERA Aid 6,853$ 13,823$ 14,409$ 11,695$ 7,000$ -$ 7,000$ 101-41000-33420 Fire Relief State PERA 39,178$ 40,474$ 47,148$ 42,267$ 40,474$ -$ 42,000$ This is a pass through offset in expenditures. 101-41000-33422 Other State Grants & Aids 10,763$ 2,390$ 14,053$ 9,069$ 6,000$ 13,493$ 6,000$ 101-41000-33423 Other Local Grants & Aids -$ -$ 6,234$ 2,078$ -$ -$ 101-41000-33428 Payments In Lue of Taxes (PILT) 6,086$ 8,242$ 8,165$ 7,498$ 6,000$ 3,283$ 6,000$ 101-41000-33620 Recycling Grant 13,062$ 13,188$ -$ 8,750$ 11,000$ 8,164$ 8,000$ 101-41000-33630 Local Govt Grants & Aids -$ -$ -$ -$ 10,228$ -$ 101-41000-33640 Other Grants 724$ -$ -$ 241$ 1,200$ -$ -$ 76,667$ 78,117$ 90,008$ 81,597$ 71,674$ 35,168$ 69,000$ Charges for Services Revenue 101-41000-34103 Zoning and Planning 12,736$ 176$ 7,742$ 6,885$ 5,000$ 4,800$ 6,000$ 101-41000-34106 Engineering Fees 1,299$ -$ 433$ -$ -$ -$ 101-41000-34107 Assessment Search Fees 20$ 20$ 5$ 15$ 20$ -$ 20$ 101-41000-34109 Water Usage 140$ 110$ 165$ 138$ 100$ -$ 150$ 101-41000-34202 Fire Protection Services 30,710$ 31,493$ 32,300$ 31,501$ 38,308$ 35,816$ 36,443$ May contract 2024-2026 101-41000-34301 Restitution 24,432$ -$ -$ 8,144$ -$ 3,070$ -$ 101-41000-34303 Dust Control 2,666$ 3,180$ 3,524$ 3,124$ 2,746$ 2,673$ 2,700$ 101-41000-34304 Reimbursement for Services 5,400$ 3,600$ 2,700$ 3,900$ 1,000$ 900$ 3,600$ LATV bookkeeping 101-41000-34305 Other Street Services 2,077$ -$ -$ 692$ -$ -$ -$ EXHIBIT A Page 1 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 101-41000-34730 Ad Revenue 2,600$ 2,400$ 900$ 1,967$ 1,000$ 450$ 1,000$ 101-41000-34750 Facilities Rental 6,808$ 12,256$ 10,270$ 9,778$ 7,400$ 4,561$ 7,400$ 101-41000-34760 Cleaning Fees 100$ -$ -$ 33$ -$ -$ -$ 101-41000-34790 Recreation Programs 1,125$ 1,955$ 1,793$ 1,624$ 1,500$ 1,189$ 1,500$ 90,112$ 55,191$ 59,399$ 68,234$ 57,074$ 53,460$ 58,813$ Fines and Forfeits Revenues 101-41000-35101 Fines & Forfeitures 6,899$ 6,027$ 7,133$ 6,686$ 7,000$ 2,646$ 6,000$ 6,899$ 6,027$ 7,133$ 6,686$ 7,000$ 2,646$ 6,000$ Miscellaneous Revenues 101-41000-36210 Interest Income 3,133$ 5,459$ 29,798$ 12,797$ -$ 64,286$ 30,000$ 101-41000-36230 Donations 8,936$ 4,841$ 6,092$ 6,623$ 5,000$ 1,352$ 4,000$ 101-41000-36240 Insurance Dividend 7,281$ 4,927$ 1,509$ 4,572$ 4,000$ -$ 4,000$ 101-41000-36250 Misc. Refund 2,769$ 1,284$ 4,076$ 2,710$ 2,000$ 266$ 1,500$ 101-41000-39200 Interfund Operating Transfer -$ -$ -$ -$ -$ -$ 0 22,119$ 16,511$ 41,476$ 26,702$ 11,000$ 65,904$ 39,500$ Transfers Between Funds Revenues 101-49000-39200 Interfund Transfer -$ -$ -$ -$ -$ -$ 101-49000-39204 Money Market Transfer -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 3.15% Total General Fund Revenues 1,837,293$ 1,941,502$ 2,270,824$ 647,365$ 2,326,123$ 1,350,536$ 2,399,499$ increase/(decrease) over 2023 Page 2 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A Expenditures ADMINISTRATION & FINANCE EXPENDITURES 101-41000-101 Regular Wages & Salaries 171,309$ 199,153$ 141,676$ 170,713$ 196,713$ 95,678$ 213,000$ 101-41000-121 PERA Coord. Employer Contribu. 12,676$ 15,000$ 8,034$ 11,903$ 13,801$ 7,813$ 15,000$ 101-41000-122 FICA Employer Contribution 10,975$ 11,817$ 7,923$ 10,238$ 12,196$ 6,159$ 13,200$ 101-41000-126 MEDICARE Employer Contribution 2,643$ 2,216$ 2,585$ 2,481$ 2,852$ 1,570$ 3,100$ 101-41000-131 Employer Paid Health 31,493$ 24,287$ 34,589$ 30,123$ 46,482$ 24,374$ 53,400$ 101-41000-132 Dental Insurance -$ 887$ 1,242$ 710$ 1,990$ 1,023$ 2,400$ 101-41000-134 Employer Paid Life 704$ 480$ 560$ 581$ 643$ 399$ 700$ 101-41000-135 Employer Paid Disability 1,299$ 503$ 844$ 882$ 960$ 573$ 900$ 101-41000-151 Worker s Comp Insurance Prem 1,462$ 1,776$ 1,651$ 1,630$ 1,214$ 1,874$ 1,874$ 101-41000-200 Office Supplies 1,367$ 1,112$ 596$ 1,025$ 738$ 420$ 1,000$ 101-41000-203 Printed Forms & Papers 1,911$ 2,264$ 2,590$ 2,255$ 1,947$ 1,874$ 2,000$ 101-41000-210 Operating Supplies 108$ 1,012$ 616$ 578$ 935$ 329$ 600$ 101-41000-301 Auditing and Accounting Services 20,200$ 21,600$ 29,090$ 23,630$ 27,000$ 32,050$ 28,700$ 101-41000-304 Legal Services 46,888$ 30,828$ 57,086$ 44,934$ 65,000$ 20,294$ 50,000$ 101-41000-306 Personal Testing & Recruit -$ -$ -$ -$ -$ -$ -$ 101-41000-308 Other Professional Services 1,081$ 17,838$ 816$ 6,578$ 5,000$ 1,747$ 2,500$ Ehlers Financial Assistance 101-41000-309 Software Support & Maintenance 18,156$ 21,204$ 18,457$ 19,272$ 12,093$ 7,519$ 20,219$ 101-41000-316 Conferences & Seminars -$ 1,049$ 390$ 480$ 280$ 20$ 300$ 101-41000-317 Employee Training 271$ -$ -$ 90$ 721$ -$ 500$ 101-41000-319 Other Services 1,309$ 155$ 50,158$ 17,208$ 700$ 235$ 150$ 101-41000-321 Telephone 4,721$ 5,020$ 5,210$ 4,983$ 5,100$ 3,083$ 6,000$ 101-41000-322 Postage 2,393$ 2,508$ 2,322$ 2,408$ 2,200$ 1,305$ 2,600$ 101-41000-331 Travel Expenses 36$ 1,557$ 1,305$ 966$ 1,000$ 245$ 1,000$ 101-41000-351 Legal Notices Publishing 1,134$ 979$ 1,647$ 1,253$ 1,500$ 1,318$ 2,000$ 101-41000-361 Liability/Property Ins 4,628$ 4,568$ 10,967$ 6,721$ 4,797$ 9,166$ 9,166$ 101-41000-365 Insurance Claims -$ -$ 1,000$ 333$ 1,000$ -$ -$ 101-41000-381 Utilities-Electric & Gas 10,925$ 10,739$ 11,596$ 11,087$ 12,000$ 4,677$ 12,000$ Sunscription SSI MN TRANCHE 101-41000-413 Equipment Rental 1,953$ 1,852$ 1,805$ 1,870$ 1,800$ 784$ 1,800$ 101-41000-430 Recycling 26,803$ 27,846$ 30$ 18,226$ -$ 20$ -$ 101-41000-433 Dues and Subscriptions 5,634$ 5,562$ 5,056$ 5,417$ 5,000$ 90$ 7,230$ LMC dues $5,200 ($7,148), newspaper 37, MET Area Mgr $45, 101-41000-434 Youth Service Bureau 5,500$ 5,500$ 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 512$ -$ -$ 171$ -$ 7$ -$ 101-41000-438 Misc. Contractual 3,632$ 3,562$ 1,336$ 2,843$ 8,539$ 2,198$ 3,000$ Abdo Treasurer assistance 101-41000-439 Refunds Issued 159$ -$ -$ 53$ 163$ -$ -$ 101-41000-560 Furniture and Fixtures -$ -$ -$ 233$ -$ 101-41000-570 Office Equipment 4,709$ 4,244$ 1,983$ 3,646$ 1,500$ 34$ 10,000$ Office Asst computer & Server in 2025? 396,590$ 427,117$ 408,661$ 410,789$ 441,364$ 227,112$ 469,839$ CITY COUNCIL EXPENDITURES 101-41110-101 Regular Wages & Salaries 17,946$ 17,946$ 20,772$ 18,888$ 20,772$ 10,386$ 21,500$ 101-41110-122 FICA Employer Contribution 212$ 213$ 238$ 221$ 1,288$ 185$ 1,300$ 101-41110-126 MEDICARE Employer Contribution 40$ 260$ 301$ 200$ 301$ 99$ 300$ 101-41110-127 PERA Defined 727$ 726$ 847$ 766$ 703$ 370$ 700$ 101-41110-151 Worker s Comp Insurance Prem 76$ 3$ 95$ 58$ 100$ 52$ 52$ Page 3 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 101-41110-308 Other Professional Services 30$ 30$ 30$ 30$ -$ -$ -$ 101-41110-316 Conferences & Seminars -$ 398$ 350$ 249$ 350$ 30$ 400$ 101-41110-331 Travel Expenses -$ -$ 562$ 187$ -$ -$ 600$ 101-41110-439 Refunds Issued (Liquor License refunds)8,800$ -$ -$ 2,933$ -$ -$ -$ 101-41110-560 Furniture and Fixtures -$ -$ -$ -$ -$ -$ -$ 101-41110-570 Office Equipment 166$ -$ -$ 55$ -$ -$ -$ 27,995$ 19,575$ 23,195$ 23,588$ 23,513$ 11,121$ 24,852$ ELECTION EXPENDITURES 101-41410-199 Election Judge -$ 3,900$ -$ 1,300$ 5,400$ 1,750$ -$ 101-41410-200 Office Supplies -$ 54$ -$ 18$ 50$ 28$ -$ 101-41410-203 Printed Forms & Papers -$ -$ -$ -$ -$ -$ -$ 101-41410-210 Operating Supplies -$ 576$ -$ 192$ 750$ 304$ -$ 101-41410-351 Legal Notices Publishing -$ 182$ -$ 61$ 200$ 15$ -$ 101-41410-413 Equipment Rental 1,470$ 1,515$ 1,515$ 1,500$ 1,660$ 1,672$ 1,839$ 1,470$ 6,227$ 1,515$ 3,071$ 8,060$ 3,769$ 1,839$ Page 4 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A PLANNING & BUILDING EXPENDITURES 101-41910-101 Regular Wages & Salaries 18,685$ 51,096$ 63,181$ 44,321$ 60,010$ 34,386$ 62,100$ Share of Administration wages & benefits 101-41910-121 PERA Coord. Employer Contribu.1,401$ 3,833$ 3,667$ 2,967$ 4,263$ 2,577$ 4,400$ 101-41910-122 FICA Employer Contribution 1,159$ 3,000$ 3,409$ 2,523$ 3,721$ 2,023$ 3,900$ 101-41910-126 MEDICARE Employer Contribution 269$ 692$ 795$ 586$ 870$ 497$ 900$ 101-41910-131 Employer Paid Health -$ 11,998$ 14,969$ 8,989$ 17,353$ 10,425$ 15,500$ 101-41910-132 Dental Insurance -$ 459$ 585$ 348$ 724$ 439$ 700$ 101-41910-134 Employer Paid Life -$ 173$ 160$ 111$ 173$ 115$ 200$ 101-41910-135 Employer Paid Disability -$ 402$ 372$ 258$ 416$ 277$ 400$ 101-41910-203 Printed Forms & Papers -$ 254$ -$ 85$ 100$ -$ -$ 101-41910-311 Contract Permit Inspections 81,881$ 72,908$ 69,429$ 74,739$ 60,000$ 29,886$ 60,000$ Building (City of Hugo) & Electrical (Joseph Wheaton) Inspections 101-41910-312 Planning Services 40,305$ 35,388$ 76,634$ 50,776$ 60,000$ 25,894$ 60,000$ Planner rate $140 to $141/hr. 101-41910-313 Committee & Commission Reimbur 4,400$ 4,950$ 4,450$ 4,600$ 5,200$ 2,600$ 5,200$ 101-41910-316 Conferences & Seminars -$ -$ -$ -$ -$ 30$ -$ 101-41910-319 Other Services -$ -$ 123$ 41$ -$ -$ -$ 101-41910-361 Liability/Property Ins 756$ 2,006$ 5,401$ 2,721$ 778$ 4,937$ 4,937$ 101-41910-438 Misc. Contractual 6,069$ 6,444$ 5,277$ 5,930$ 5,000$ 2,391$ 5,000$ State Building Permit Surcharges 101-41910-439 Refunds Issued 186$ (515)$ 600$ 90$ -$ -$ -$ 155,112$ 193,088$ 249,052$ 199,084$ 218,607$ 116,477$ 223,237$ ASSESSOR EXPENDITURES 101-41950-300 Assessor 22,077$ 21,678$ 21,959$ 21,904$ 23,200$ 13,260$ 23,200$ Assessor contract w/Patrick Pauscek renews May $2,000/mo 22,077$ 21,678$ 21,959$ 21,904$ 23,200$ 13,260$ 23,200$ POLICE EXPENDITURES 101-42100-318 Police Contract 144,337$ 150,414$ 168,499$ 154,417$ 183,442$ 91,721$ 194,293$ 2025 Contract 101-42100-319 Other Services 309$ 309$ 959$ 526$ 960$ 309$ 1,000$ Code Red notification service; Taco Daze security 144,647$ 150,723$ 169,458$ 154,943$ 184,402$ 92,030$ 195,293$ FIRE DEPT EXPENDIDTURES 101-42200-101 Regular Wages & Salaries 124,411$ 136,717$ 185,805$ 148,978$ 160,554$ 105,218$ 198,800$ 101-42200-121 PERA Coord. Employer Contribu. 7,854$ -$ -$ 2,618$ -$ -$ 9,300$ 101-42200-122 FICA Employer Contribution 5,453$ 6,697$ 10,463$ 7,538$ 9,954$ 6,583$ 12,300$ 101-42200-124 Police & Fire PERA -$ 8,954$ 9,286$ 6,080$ 8,983$ 5,788$ 2,900$ 101-42200-126 MEDICARE Employer Contribution 2,281$ 1,918$ 2,867$ 2,355$ 2,328$ 1,162$ -$ 101-42200-134 Employer Paid Life 192$ 192$ 192$ 192$ 192$ 128$ 200$ 101-42200-135 Employer Paid Disability -$ -$ -$ -$ -$ -$ -$ 101-42200-141 Unemployment Compensation -$ -$ -$ -$ -$ Page 5 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 101-42200-151 Worker s Comp Insurance Prem 9,948$ 13,008$ 11,617$ 11,524$ 12,000$ 6,249$ 6,250$ 101-42200-200 Office Supplies 358$ 165$ 204$ 242$ 200$ 150$ 300$ 101-42200-203 Printed Forms & Papers 406$ -$ -$ 135$ -$ -$ 200$ 101-42200-209 Medical Supplies 1,245$ 2,804$ 4,845$ 2,965$ 3,500$ 447$ 3,000$ Inflation 101-42200-210 Operating Supplies 12,614$ 2,103$ 7,428$ 7,382$ 8,800$ 1,401$ 8,800$ Inflation 101-42200-211 Cleaning Supplies 66$ 44$ 51$ 54$ 100$ -$ 100$ 101-42200-212 Fuel 3,590$ 5,468$ 5,834$ 4,964$ 4,000$ 2,405$ 4,800$ 101-42200-217 Uniforms & Safety Equipment 3,497$ 550$ 5,192$ 3,080$ 10,000$ 16,704$ 15,000$ New member gear and uniforms 101-42200-221 Equipment Parts 828$ 290$ 294$ 471$ 1,500$ -$ 1,500$ 101-42200-222 Tires -$ 1,540$ -$ 513$ -$ -$ -$ 101-42200-223 Structure Repair & Supplies 461$ 441$ 400$ 434$ 800$ 6$ 800$ 101-42200-240 Small Tools and Minor Equip 5,755$ 10,085$ 1,455$ 5,765$ 10,000$ 14,286$ 8,000$ Add $12,195 for dive gear 101-42200-305 Medical Services 4,357$ 7,330$ 4,610$ 5,432$ 5,600$ 5,630$ 6,000$ Annual testing 101-42200-306 Personal Testing & Recruit 2,025$ 1,205$ 1,391$ 1,541$ 500$ -$ 500$ Anticipating 2 new members 101-42200-309 Software Support & Maintenance 18,531$ 17,912$ 17,495$ 17,980$ 17,000$ 8,841$ 17,700$ Laserfiche user fee, 800Mhz Radios user fee, Managed IT, Pager Repair Page 6 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 101-42200-310 Medical Training 102$ -$ 12,000$ 4,034$ 2,000$ 50$ 1,000$ Mhealth Supplied 101-42200-316 Conferences & Seminars -$ -$ -$ -$ 250$ -$ 250$ 101-42200-317 Employee Training 19,663$ 1,808$ 5,764$ 9,078$ 12,000$ 2,505$ 5,000$ MBFTE Funding 101-42200-319 Other Services 2,981$ 548$ 889$ 1,473$ 500$ 105$ 500$ Fire Extinguishers 101-42200-321 Telephone 7,561$ 6,698$ 6,366$ 6,875$ 7,000$ 3,124$ 6,500$ 8 computer air cards for County CDA 101-42200-322 Postage 7$ -$ -$ 2$ -$ 18$ -$ 101-42200-324 State of MN-Fire Relief 39,178$ 40,474$ 47,148$ 42,267$ 40,474$ -$ 40,474$ Pass through to PERA 101-42200-325 City Match-Fire Relief -$ -$ -$ -$ -$ -$ -$ 101-42200-331 Travel Expenses 50$ -$ 1,693$ 581$ 2,000$ 1,818$ 2,500$ Sectional Schools 101-42200-334 Licenses & Permits 175$ 250$ 536$ 320$ 500$ -$ 500$ 101-42200-340 Advertising -$ -$ -$ -$ -$ -$ -$ 101-42200-361 Liability/Property Ins 8,102$ 6,685$ 6,989$ 7,259$ 7,019$ 7,208$ 7,208$ 101-42200-381 Utilities-Electric & Gas 2,718$ 7,067$ 5,742$ 5,175$ 8,000$ 2,814$ 6,000$ 101-42200-384 Refuse/Garbage Disposal 974$ 1,139$ 1,043$ 1,052$ -$ -$ -$ 101-42200-385 Sewer Pumping & Maintenance 270$ 550$ 304$ 374$ 550$ 526$ 550$ 101-42200-401 Building Maintenance/Repairs 3,722$ 3,620$ 4,514$ 3,952$ 3,500$ 1,481$ 3,500$ Pest C ontrol $530; Cleaning Service $1800 101-42200-403 Improvements Other Than Bldgs -$ -$ -$ -$ -$ -$ -$ 101-42200-404 Repair Machinery/Equipment 13,858$ 8,595$ 18,562$ 13,672$ 8,500$ 6,325$ 10,000$ 101-42200-407 Well Repair & Maintenance -$ -$ -$ -$ -$ -$ -$ 101-42200-433 Dues and Subscriptions 2,203$ 2,350$ 3,215$ 2,589$ 3,200$ 3,245$ 3,500$ IamResponding $700; /check-It $1,300 101-42200-438 Misc. Contractual 2,205$ 2,985$ 3,716$ 2,969$ 3,500$ -$ 4,000$ Compressor, Lucas, Tornado siren & Zoll Service 101-42200-440 Events 807$ 1,157$ 1,196$ 1,053$ 1,000$ 148$ 1,000$ Taco Daze, Fire Prevention, Safe Halloween 101-42200-520 Capital Improvements to Bldgs -$ -$ 6,264$ 2,088$ -$ -$ -$ 101-42200-530 Capital Impr Other Than Bldgs -$ 1,178$ -$ 393$ -$ -$ -$ 101-42200-540 Heavy Machinery Capital -$ -$ -$ -$ -$ -$ -$ 101-42200-560 Furniture and Fixtures 220$ -$ 236$ 152$ 500$ 51$ 500$ Training room chairs 101-42200-570 Office Equipment 928$ -$ 180$ 369$ 900$ 379$ 900$ Computer replacement 309,597$ 302,528$ 395,787$ 335,971$ 357,405$ 204,795$ 390,332$ ANIMAL CONTROL EXPENDITURES 101-42700-314 Animal Control 7,502$ 5,604$ 6,778$ 6,628$ 6,000$ 4,007$ 7,000$ 10% increase 7,502$ 5,604$ 6,778$ 6,628$ 6,000$ 4,007$ 7,000$ Page 7 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A PUBIC WORKS EXPENDITURES 101-43000-101 Regular Wages & Salaries 222,975$ 219,892$ 224,993$ 222,620$ 252,092$ 157,908$ 271,100 101-43000-102 OT Regular Wages 5,260$ 8,866$ 6,237$ 6,787$ 5,014$ 2,572$ 5,000 101-43000-104 Temporary Employee Wages 1,842$ 4,434$ 4,163$ 3,480$ 2,262$ 338$ 2,300$ 101-43000-121 PERA Coord. Employer Contribu. 16,763$ 17,155$ 17,325$ 17,081$ 19,283$ 11,375$ 20,700$ 101-43000-122 FICA Employer Contribution 12,702$ 14,413$ 13,754$ 13,623$ 16,081$ 8,881$ 17,300$ 101-43000-126 MEDICARE Employer Contribution 3,181$ 3,237$ 3,263$ 3,227$ 3,761$ 2,229$ 4,000$ 101-43000-131 Employer Paid Health 49,845$ 55,964$ 57,146$ 54,318$ 66,939$ 39,246$ 64,600$ Union deduction notice in March 101-43000-132 Dental Insurance -$ 915$ 1,058$ 657$ 1,164$ 708$ 1,200$ 101-43000-133 Union Training Center -$ -$ 1,872$ 936$ 1,872$ $.30/hr Union Training Benefit 101-43000-134 Employer Paid Life 656$ 741$ 701$ 699$ 698$ 474$ 700$ 101-43000-135 Employer Paid Disability 2,022$ 1,737$ 1,563$ 1,774$ 1,365$ 930$ 1,400$ 101-43000-141 Unemployment Compensation 1,456$ -$ -$ 485$ -$ -$ -$ 101-43000-151 Worker s Comp Insurance Prem 17,049$ 23,018$ 26,477$ 22,181$ 27,000$ 22,615$ 22,615$ 101-43000-200 Office Supplies 364$ -$ 54$ 139$ 50$ -$ 600$ 101-43000-210 Operating Supplies 6,213$ 9,068$ 8,550$ 7,944$ 8,500$ 4,250$ 8,500$ Daily use items, hardwares, misc. items 101-43000-212 Fuel 16,768$ 28,319$ 29,707$ 24,931$ 25,000$ 11,954$ 24,000$ 101-43000-217 Uniforms & Safety Equipment 1,899$ 1,393$ 2,519$ 1,937$ 2,300$ 1,095$ 2,300$ Uniform allowance, PPE 101-43000-221 Equipment Parts 14,906$ 14,071$ 19,409$ 16,129$ 17,000$ 6,797$ 14,500$ P.M. parts, Replacement Parts 101-43000-222 Tires 4,941$ 7,385$ 1,288$ 4,538$ 7,500$ -$ 7,500$ 101-43000-223 Structure Repair & Supplies -$ -$ 56$ 19$ 2,000$ -$ 2,200$ 101-43000-224 Materials for Road Maintenance 4,757$ 11,809$ 10,662$ 9,076$ 7,000$ 16,310$ 26,000$ Hot/Cold mix, cement, culverts, gravel, and base material 101-43000-226 Sign Replacement & Repair -$ 3,063$ 174$ 1,079$ 750$ -$ 500$ 101-43000-228 Gravel 7,383$ 1,830$ 6,863$ 5,359$ 10,000$ 330$ -$ Move funds to Materials for Road Mintenance 101-43000-229 Salt 16,085$ 21,305$ 17,914$ 18,435$ 22,000$ 12,375$ 22,000$ Winter Road Salt Untreated/Treated 101-43000-240 Small Tools and Minor Equip 1,132$ 3,195$ 5,967$ 3,431$ 8,000$ 6,422$ 8,000$ Hand tools, attachments 101-43000-302 Surveying -$ -$ -$ -$ -$ *Admin Cost- remove line item from PW 101-43000-303 Engineering Fees 11,909$ 8,394$ 12,793$ 11,032$ 53$ 6,743$ 11,000$ 5% increase 101-43000-304 Legal Services -$ -$ -$ -$ -$ -$ 101-43000-305 Medical Services 408$ 874$ 286$ 523$ 1,000$ -$ 1,200$ First Aid supplies 101-43000-309 Software Support & Maintenance 682$ 4,684$ 13,198$ 6,188$ 6,000$ 200$ 8,000$ PW Data Tracking Software $5,000 ; GIS map updates 101-43000-317 Employee Training 120$ 799$ 1,315$ 745$ 1,500$ 459$ 1,700$ 101-43000-319 Other Services 6,619$ 6,104$ 6,045$ 6,256$ 7,000$ 4,127$ 7,000$ Pest control, Janitorial service 101-43000-321 Telephone 4,630$ 5,253$ 4,227$ 4,703$ 4,000$ 2,487$ 4,000$ City isued cell/data service 101-43000-331 Travel Expenses 583$ -$ -$ 194$ 500$ 291$ 550$ 101-43000-334 Licenses & Permits 68$ 183$ 192$ 148$ 500$ -$ 550$ 101-43000-361 Liability/Property Ins 14,068$ 10,362$ 8,348$ 10,926$ 10,880$ 9,713$ 9,713$ 101-43000-365 Insurance Claims -$ -$ -$ -$ -$ -$ -$ 101-43000-381 Utilities-Electric & Gas 2,096$ 5,094$ 4,214$ 3,801$ 6,000$ 1,982$ 4,500$ 101-43000-384 Refuse/Garbage Disposal 705$ 1,155$ 861$ 907$ -$ -$ 700$ 101-43000-385 Sewer Pumping & Maintenance 270$ 1,006$ 304$ 526$ 1,500$ 2,285$ 1,800$ PW/Fire shop drain holding tank pumping 101-43000-387 Street Light Utilities 3,689$ 4,577$ 5,112$ 4,459$ 4,682$ 1,784$ 5,000$ Street light Maintenance/Replacement 101-43000-401 Building Maintenance/Repairs 3,235$ 10,173$ 4,239$ 5,882$ 6,000$ 2,049$ 8,000$ 101-43000-403 Improvements Other Than Bldgs 1,575$ -$ -$ 525$ -$ -$ -$ Misc. small improvements 101-43000-404 Repair Machinery/Equipment 33,518$ 19,808$ 27,204$ 26,843$ 25,000$ 5,115$ 20,000$ Outsourced equipment repair 101-43000-405 Contractual Road Maint/Repair 44,144$ 91,930$ 119,461$ 85,178$ 200,000$ 75,179$ 175,000$ Striping, Calium Chloride Application, Patching, Culvert Repair 101-43000-407 Well Repair & Maintenance -$ -$ -$ -$ 500$ -$ 1,000$ RPZ testing, repair, maintenance Page 8 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 101-43000-413 Equipment Rental 646$ 2,276$ 111$ 1,011$ 4,000$ 26$ 4,000$ 101-43000-417 Uniform Rental 1,282$ 975$ 1,105$ 1,121$ 1,200$ 519$ 1,300$ Full-time staff work uniforms 101-43000-433 Dues and Subscriptions -$ -$ -$ -$ 200$ -$ 200$ 101-43000-438 Misc. Contractual 17,894$ 6,797$ 11,380$ 12,024$ 16,000$ -$ 16,000$ 101-43000-439 Refunds Issued 400$ -$ -$ 133$ -$ -$ 101-43000-530 Capital Impr Other Than Bldgs -$ 1,178$ -$ 393$ 9,900$ -$ 9,900$ building/equipment improvement 101-43000-550 Motor Vehicles Capital -$ -$ -$ -$ -$ -$ 101-43000-560 Furniture and Fixtures 821$ 2,921$ -$ 1,248$ 1,000$ -$ 500$ Office/Break Room amenities 101-43000-570 Office Equipment -$ -$ 407$ 136$ -$ 487$ -$ 0 557,563$ 636,351$ 680,641$ 624,852$ 815,044$ 421,191$ 820,500$ Page 9 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A PARKS & RECREATION REVENUE 101-45000-101 Regular Wages & Salaries 19,299$ 10,181$ 8,508$ 12,663$ 11,201$ 6,330$ 19,700$ 101-45000-104 Temporary Employee Wages 19,299$ 12,691$ 19,368$ 17,120$ 39,985$ 10,130$ 40,000$ 101-45000-121 PERA Coord. Employer Contribu.1,484$ 764$ 636$ 961$ 840$ 474$ 1,500$ 101-45000-122 FICA Employer Contribution 2,242$ 1,397$ 1,684$ 1,774$ 3,174$ 997$ 3,700$ 101-45000-126 MEDICARE Employer Contribution 532$ 316$ 414$ 421$ 742$ 240$ 900$ 101-45000-131 Employer Paid Health -$ 2,441$ 2,020$ 1,487$ 2,562$ 1,366$ 6,800$ 101-45000-132 Dental Insurance -$ 33$ 38$ 24$ 42$ 22$ 300$ 101-45000-134 Employer Paid Life -$ 144$ 27$ 57$ 27$ 18$ 100$ 101-45000-135 Employer Paid Disability -$ 373$ 55$ 142$ 76$ 36$ 200$ 101-45000-141 Unemployment Compensation -$ 119$ -$ 40$ -$ -$ -$ 101-45000-151 Worker s Comp Insurance Prem 1,711$ 1,971$ 2,615$ 2,099$ 2,700$ 2,251$ 2,251$ 101-45000-200 Office Supplies -$ -$ -$ -$ 100$ -$ 100$ 101-45000-203 Printed Forms & Papers 285$ 78$ -$ 121$ 200$ -$ 200$ 101-45000-210 Operating Supplies 1,868$ 821$ 893$ 1,194$ 1,000$ 522$ 1,200$ Daily use items, hardwares, misc. items 101-45000-212 Fuel 243$ 604$ 251$ 366$ 1,000$ 138$ 1,500$ 101-45000-221 Equipment Parts 242$ 971$ 1,817$ 1,010$ 2,500$ 588$ 2,500$ 101-45000-223 Structure Repair & Supplies (451)$ 389$ 1,124$ 354$ 2,500$ 138$ 2,500$ 101-45000-240 Small Tools and Minor Equip 150$ 360$ 324$ 278$ 500$ -$ 600$ Hand tools, string trimmers, ect. 101-45000-312 Planning Services -$ -$ -$ -$ -$ -$ -$ 101-45000-313 Committee & Commission Reimbur 1,380$ 1,140$ 960$ 1,160$ -$ 480$ -$ 101-45000-319 Other Services 898$ 1,861$ 1,392$ 1,383$ 1,750$ 1,019$ 2,000$ Janitorial service, pest control, Portable toilet service 101-45000-322 Postage -$ -$ -$ -$ -$ -$ -$ 101-45000-340 Advertising -$ 180$ -$ 60$ -$ 275$ 250$ 101-45000-353 Sales& Use Tax 37$ 2$ -$ 13$ -$ -$ -$ 101-45000-361 Liability/Property Ins 4,817$ 7,911$ 3,323$ 5,350$ 5,058$ 5,333$ 5,333$ 101-45000-381 Utilities-Electric & Gas 4,148$ 7,632$ 5,258$ 5,679$ 6,500$ 1,552$ 6,000$ Page 10 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 101-45000-384 Refuse/Garbage Disposal 4,553$ 5,079$ 5,510$ 5,047$ 5,000$ 2,158$ 500$ 101-45000-385 Sewer Pumping & Maintenance 378$ 595$ 1,044$ 673$ 1,250$ 191$ 1,250$ Warming House 101-45000-401 Building Maintenance/Repairs 1,208$ 4,148$ 4,370$ 3,242$ 6,000$ 4,151$ 6,000$ 101-45000-403 Improvements Other Than Bldgs -$ 4,961$ 421$ 1,794$ 2,500$ 716$ 1,000$ 101-45000-404 Repair Machinery/Equipment 203$ 690$ 397$ 430$ 1,000$ 380$ 1,000$ Outsourced equipment repair 101-45000-406 Grounds Care 764$ 2,728$ 3,724$ 2,405$ 4,000$ 1,237$ 4,000$ Plant material, mulch, landscape material 101-45000-438 Misc. Contractual 4,913$ 3,253$ 6,955$ 5,040$ 8,000$ 3,723$ 8,000$ Herbicide/Fertilizer Application 101-45000-439 Refunds Issued -$ -$ 565$ 188$ -$ -$ -$ 101-45000-440 Events 5,744$ 9,838$ 5,354$ 6,979$ 7,000$ 1,384$ -$ 101-45000-490 Financial Assistance -$ -$ -$ -$ -$ -$ -$ 101-45000-530 Capital Impr Other Than Bldgs 1,505$ 4,994$ 4,500$ 3,666$ 9,900$ 1,800$ 6,000$ Building/Equipment Improvements 77,453$ 88,664$ 83,544$ 83,220$ 127,107$ 47,650$ 125,384$ COMMUNITY CENTER EXPENDITURES 101-45180-101 Regular Wages & Salaries 2,956$ 14,407$ 14,401$ 10,588$ 16,327$ 9,301$ 17,200$ 7.50% of PW time 101-45180-104 Temporary Employee Wages -$ -$ -$ -$ -$ -$ -$ 101-45180-121 PERA Coord. Employer Contribu.204$ 1,044$ 1,042$ 764$ 1,225$ 697$ 1,300$ 101-45180-122 FICA Employer Contribution 181$ 850$ 850$ 627$ 1,012$ 541$ 1,100$ 101-45180-126 MEDICARE Employer Contribution 35$ 199$ 199$ 144$ 237$ 136$ 300$ 101-45180-131 Employer Paid Health -$ 2,709$ 2,628$ 1,779$ 3,692$ 1,849$ 3,700$ 101-45180-134 Employer Paid Life -$ 47$ 41$ 29$ 43$ 29$ -$ 101-45180-135 Employer Paid Disability -$ 137$ 107$ 81$ 95$ 69$ -$ 101-45180-151 Worker s Comp Insurance Prem -$ -$ -$ -$ -$ 152$ 152$ 101-45180-210 Operating Supplies 1,912$ 2,609$ 2,968$ 2,496$ 2,900$ 896$ 3,000$ Daily use items, hardwares, misc. items 101-45180-223 Structure Repair & Supplies 343$ 118$ 173$ 211$ 4,000$ 236$ 2,500$ 101-45180-334 Licenses & Permits 874$ 777$ 792$ 814$ 1,000$ 955$ 1,000$ 101-45180-361 Liability/Property Ins 2,172$ 2,563$ 796$ 1,844$ 2,691$ 801$ 801$ 101-45180-381 Utilities-Electric & Gas 6,018$ 10,716$ 9,546$ 8,760$ 9,198$ 3,560$ 10,000$ Page 11 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 101-45180-384 Refuse/Garbage Disposal 1,889$ 1,923$ 3,578$ 2,463$ -$ 124$ 500$ 101-45180-385 Sewer Pumping & Maintenance 2,549$ 4,243$ 4,609$ 3,800$ 4,000$ 1,260$ 4,000$ Community Center holding tank pumping 101-45180-401 Building Maintenance/Repairs 10,685$ 15,904$ 17,592$ 14,727$ 15,000$ 5,888$ 15,000$ 101-45180-404 Repair Machinery/Equipment 2,471$ 332$ 2,726$ 1,843$ 5,000$ 125$ 5,000$ Kitchen/HVAC repair and maintenance 101-45180-406 Grounds Care 260$ 520$ 1,255$ 678$ 1,300$ 117$ 1,300$ Plant material, mulch, landscape material 101-45180-407 Well Repair & Maintenance -$ 13,675$ -$ 4,558$ 1,000$ -$ 1,000$ Community Well (Com. Center, Church, Gammelgarden) 101-45180-438 Misc. Contractual 1,995$ 669$ 2,165$ 1,610$ 3,500$ 1,500$ 3,500$ 101-45180-439 Refunds Issued -$ -$ 450$ 150$ -$ -$ -$ 101-45180-520 Capital Improvements to Bldgs.3,464$ 9,779$ 7,476$ 6,906$ 9,900$ -$ 9,900$ Building/Equipment Improvements 101-45180-530 Capital Impr Other Than Bldgs 2,555$ -$ -$ 852$ -$ -$ -$ 101-45180-570 Office Equipment 1,319$ -$ -$ 440$ -$ -$ -$ 41,884$ 83,220$ 73,391$ 66,165$ 82,120$ 28,235$ 81,253$ Transfers Between Funds RevenuesExpenditures 101-49000-720 Operating Transfers Total General Fund Expenditures 1,741,889$ 1,934,776$ 2,113,980$ 1,930,215$ 2,286,822$ 1,169,646$ 2,362,729$ increase/(decrease) over 2024 Revenues over (Expenses)95,404$ 6,726$ 156,844$ 2,684$ 39,301$ 180,890$ 36,770$ Page 12 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A AMERICAN RESCUE PLAN REVENUES Revenues 203-46200-33150 Federal Grant 228,181$ 228,181$ -$ -$ -$ 203-46200-36210 Interest Income 10,059$ -$ 203-46200-39200 Interfund Transfer In 2,690$ -$ 230,872$ 228,181$ 10,059$ -$ -$ -$ -$ AMERICAN RESCUE PLAN EXPENDITURES Expenditures 203-46200-720 Transfers to Other Funds -$ -$ -$ 466,000$ -$ transfer to Vehicle Equipment Fund -$ -$ -$ 466,000$ -$ -$ EDA REVENUE Revenues 225-46500-31000 Washington Cty. Tax Settlement 5,000$ 8,000$ 5,300$ 6,100$ 5,300$ 2,650$ -$ Fund from cash balance of $40k 225-46500-33640 Other Grants -$ -$ -$ -$ -$ -$ -$ 225-46500-34750 Facilities Rental 750$ 800$ 517$ -$ -$ -$ 225-46500-36210 Interest Income 85$ 1,366$ 735$ 729$ 100$ -$ 750$ 225-46500-36230 Donations -$ 300$ 300$ 200$ -$ 310$ -$ 225-46500-39203 Transfer from Other Funds 2,776$ -$ -$ 925$ -$ -$ -$ 7,861$ 10,416$ 8,471$ 5,400$ 2,960$ 750$ EDA EXPENDITURES Expenditures 225-46500-210 Operating Supplies 890$ 176$ -$ 355$ 300$ 23$ 50$ 225-46500-303 Engineering Fees -$ -$ -$ -$ -$ -$ -$ 225-46500-304 Legal Services -$ -$ -$ -$ -$ -$ -$ 225-46500-308 Other Professional Services 69$ -$ -$ 23$ 100$ -$ -$ 225-46500-340 Advertising -$ 75$ 1,487$ 521$ 1,500$ -$ -$ 255-46500-433 Dues and Subscriptions 1,795$ 1,653$ 873$ 1,440$ 1,849$ 364$ 879$ $190, MNRural Broadband Coalition $1,000 in 2021 & 2022? 225-46500-440 Events -$ 2,808$ 2,110$ 1,639$ 1,500$ 310$ 2,000$ Scandia Holiday Market 255-46500-720 Transfer Out 2,776$ -$ -$ 925$ -$ 33,356$ -$ JE to balance EDA checking account 5,530$ 4,712$ 4,470$ 4,904$ 5,249$ 34,053$ 2,929$ Page 13 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A CABLE TV FUND REVENUES Revenues 226-41950-36210 Interest Income 96$ 242$ 303$ 214$ 100$ -$ 300$ 226-41950-36260 Sale of Equipment -$ -$ 300$ 100$ -$ -$ -$ 226-41950-38050 Cable TV Franchise Rebates 18,062$ 18,988$ 20,126$ 19,059$ 16,700$ 10,410$ 20,819$ 226-41950-38051 PEG Fees 5,131$ 5,209$ 5,405$ 5,248$ 4,400$ 2,170$ 4,340$ 23,290$ 24,439$ 24,621$ 21,200$ 12,580$ 25,460$ CABLE TV FUND EXPENDITURES Expenditures 226-41950-240 Small Tools and Minor Equip 285$ 498$ 604$ 463$ 300$ -$ 300$ 226-41950-309 Software Support & Maintenance 2,631$ 3,004$ 3,652$ 3,096$ 3,500$ 2,353$ 3,760$ Boxcast $1600 + 180/mo 226-41950-438 Misc. Contractual 2,760$ 7,519$ 7,749$ 6,009$ 7,750$ 3,170$ 7,750$ LATV filming meetings $5,750; Zoom $2,000 226-41950-570 Office Equipment 230$ 41,512$ 4,129$ 15,290$ -$ -$ 1,000$ 5,907$ 52,533$ 16,134$ 24,858$ 11,550$ 5,523$ 12,810$ GATEWAY TRAIL FUND REVENUES Revenues 230-45000-36230 Donations 3,400$ -$ -$ -$ -$ -$ 3,400$ -$ -$ -$ -$ -$ GATEWAY TRAIL FUND EXPENDITURES Expenditures 230-45000-308 Other Professional Services 3,575$ -$ -$ -$ -$ -$ 3,575$ -$ -$ -$ -$ -$ PUBLIC SAFETY AID FUND REVENUES Revenues 240-42300-33422 Other State Grants & Aid 176,529$ -$ -$ -$ 176,529$ -$ -$ 63,082$ -$ PUBLIC SAFETY AID FUND EXPENDITURES Expenditures 240-42300-540 Heavy Machinery Capital -$ -$ -$ 239,610$ Fire Truck? -$ -$ -$ -$ -$ -$ 239,610$ Page 14 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 2013 EQUIPMENT CERTIFICATE FUND REVENUES Revenues 313-47000-31000 Washington Cty. Tax Settlement 68,220$ 67,000$ 64,000$ 66,407$ -$ -$ -$ PAID OFF 2023 313-47000-36210 Interest Income 48$ -$ 16$ -$ -$ -$ 68,220$ 67,048$ 64,000$ 66,423$ -$ -$ -$ 2013 EQUIPMENT CERTIFICATE FUND EXPENDITURES Expenditures 313-47000-304 Legal Services 313-47000-601 Long Term Debt Principal 60,000$ 60,000$ 60,000$ 60,000$ -$ -$ PAID OFF IN 2023 313-47000-611 Long Term Debt Interest 7,140$ 2,790$ 930$ 3,620$ -$ -$ 313-47000-620 Fiscal Agent s Fees 495$ 495$ 330$ -$ -$ 67,635$ 63,285$ 63,950$ -$ -$ -$ 2017 EQUIPMENT CERTIFICATE FUND REVENUES Revenues 317-47000-31000 Washington Cty. Tax Settlement 35,909$ 34,524$ 23,478$ 35,909$ 34,524$ 23,478$ -$ -$ -$ 2017 EQUIPMENT CERTIFICATE FUND EXPENDITURES Expenditures 317-47000-601 Long Term Debt Principal 32,000$ 32,000$ 21,333$ PAID OFF IN 2022 317-47000-611 Long Term Debt Interest 1,728$ 880$ 869$ 317-47000-620 Fiscal Agent s Fees 435$ -$ 145$ 34,163$ 32,880$ 22,203$ -$ -$ -$ 2018 G.O. STREET RECONSTRUCTION FUND REVENUE Revenues 318-47000-31000 Washington Cty. Tax Settlement 341,456$ 344,531$ 342,536$ 342,841$ 346,120$ 172,817$ 343,166$ Payoff 2033 318-47000-36210 Interest Income 145$ 1,291$ 479$ -$ -$ -$ First Call Date for Refinancing 12/15/2025 318-47000-39203 Transfer from Other Funds 24,869$ -$ 8,290$ -$ -$ -$ 341,456$ 344,531$ 343,827$ 342,841$ 346,120$ 172,817$ 343,166$ Expenditures 2018 G.O. STREET RECONSTRUCTION FUND EXPENDITURES 318-47000-601 Long Term Debt Principal 220,000$ 230,000$ 235,000$ 228,333$ 245,000$ -$ 250,000$ $3,835,000 original issue 318-47000-611 Long Term Debt Interest 104,725$ 98,125$ 91,225$ 98,025$ 84,175$ 42,088$ 76,825$ 318-47000-620 Fiscal Agent Fees 495$ 495$ 495$ 495$ 495$ 1,045$ 500$ increase for arbitrage report 2028 325,220$ 328,620$ 326,853$ 329,670$ 43,133$ 327,325$ Page 15 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 2024 G.O. STREET RECONSTRUCTION FUND REVENUES 324-47000-31000 Washington Cty. Tax Settlement -$ 115,703$ $4,000,000 original issue; levy reduced by bond interest 324-47000-36210 Interest Income 40,319$ -$ 324-47000-39310 Bond Proceeds-GO Bond 3,868,542$ -$ -$ -$ -$ -$ -$ 3,908,861$ 115,703$ 2024 G.O. STREET RECONSTRUCTION FUND EXPENDITURES 324-47000-601 Long Term Debt Principal 180,000$ $4,000,000 original issue 324-47000-611 Long Term Debt Interest 159,150$ 324-47000-620 Fiscal Agents Fees 495$ 500$ 2029 increase for arbitrage report -$ -$ -$ -$ 495$ -$ 339,650$ 2025 EQUIPMENT BOND REVENUES 325-47000-31000 Washington Cty. Tax Settlement -$ 38,997$ 325-47000-36210 Interest Income -$ 325-47000-39310 Bond Proceeds-GO Bond 340,000$ 515,510$ -$ -$ -$ -$ 340,000$ -$ 554,507$ 2025 EQUIPMENT BOND EXPENDITURES 325-47000-601 Long Term Debt Principal 37,140$ 325-47000-611 Long Term Debt Interest -$ -$ -$ -$ -$ -$ -$ 37,140$ Total Debt Service Fund Revenues 445,585$ 446,103$ 407,827$ 432,741$ 346,120$ 4,081,678$ 1,013,376$ Total Debt Service Fund Expenditures 461,676$ 458,160$ 495$ 435,704$ 331,210$ 43,633$ 704,115$ Page 16 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A GENERAL CAPITAL INVESTMENT FUND REVENUE 401-48000-31000 Washington Cty. Tax Settlement 102,198$ 217,336$ 293,790$ 204,441$ 235,000$ 117,500$ 125,000$ 401-48000-33422 Other State Grants & Aids 102,198$ -$ 56,232$ 52,810$ 34,110$ 401-48000-33640 Other Grants -$ -$ -$ -$ 401-48000-36210 Interest Income 2,941$ 3,126$ 15,886$ 7,318$ 3,000$ -$ 1,000$ 401-48000-36230 Donations 6,089$ -$ 2,030$ -$ -$ 401-48000-39200 Interfund Operating Transfer -$ -$ -$ -$ Total Capital Investment Fund Revenues 213,426$ 220,462$ 365,908$ 266,599$ 238,000$ 151,610$ 126,000$ CAPITAL INVESTMENT FUND EXPENDITURES Administration 401-41000-312 Planning Services 13,712$ 5,771$ 6,495$ -$ -$ -$ 401-41000-520 Administration Capital to Bldgs 12,750$ 4,250$ -$ -$ -$ 401-41000-530 Administration Capital 19,389$ 236,700$ 92,500$ 116,196$ 250,000$ -$ 92,000$ IAC request & Gateway Trail Fire Improvements 401-42200-520 Fire Capital to Bldgs 90,034$ 30,011$ -$ 73,775$ 75,000$ 401-42200-530 Fire Capital Other than Buildings 236,793$ 78,931$ -$ -$ 76,041$ Fire Radios, Jaws of Life, Luca CPR device Public Works 401-43000-520 Public Works Capital to Bldgs -$ -$ -$ 75,000$ 401-43000-530 Public Works Capital -$ -$ -$ -$ 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 17,815$ 16,609$ 11,475$ 67,548$ -$ -$ 401-45180-530 Community Center Capital 11,024$ 3,675$ -$ -$ -$ General Improvements401-48000-101 Regular Wages & Salaries -$ -$ -$ -$ 401-48000-303 Engineering Fees 20,859$ 6,953$ -$ 30,743$ 30,000$ Gateway Trail 401-48000-308 Other Professional Services 31,200$ 10,400$ -$ 4,800$ -$ Lobbying 401-48000-312 Planning Services -$ -$ -$ -$ 401-48000-435 Misc. Expense 12,000$ 4,000$ -$ -$ -$ 401-48000-438 Misc. Contractual -$ -$ -$ -$ 401-48000-520 Capital Improvements to Bldgs. -$ -$ -$ -$ 401-48000-530 Capital Imp Other Than Bldgs. 237,250$ 7,800$ 81,683$ 160,000$ -$ 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 -$ -$ -$ -$ Total Capital Investment Fund Expenditures 535,983$ 285,859$ 234,593$ 347,574$ 477,548$ 109,318$ 348,041$ Page 17 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A PARK INVESTMENT FUND REVENUES Revenues 404-48000-31000 Washington Cty. Tax Settlement 10,000$ 20,000$ 20,000$ 16,667$ 60,000$ 30,000$ 40,000$ 404-48000-33422 Other State Grants & Aids 5,243$ 10,125$ 101,250$ 38,873$ -$ 101,250$ 404-48000-33640 Other Grants -$ -$ -$ -$ 404-48000-34780 Park Dedication Fees 3,000$ 30,000$ 11,000$ -$ -$ -$ 404-48000-36210 Interest Income 493$ 620$ 3,146$ 1,419$ 66$ -$ 66$ 404-48000-36230 Donations 7,949$ 10,000$ 5,983$ -$ 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$ 48,873$ -$ Total Park Investment Fund Revenues 18,735$ 38,694$ 311,016$ 122,815$ 60,066$ 141,250$ 40,066$ PARK INVESTMENT FUND EXPENDITURES Expenditures 404-48000-210 Operating Supplies -$ -$ -$ -$ 404-48000-302 Surveying -$ -$ -$ -$ 404-48000-303 Engineering Fees -$ -$ 44,926$ -$ 404-48000-304 Legal Services -$ -$ -$ -$ 404-48000-308 Other Professional Services -$ -$ 410$ -$ 404-48000-312 Planning Services 1,050$ 4,500$ 1,850$ -$ -$ -$ 404-48000-381 Utilities-Electric & Gas -$ -$ -$ -$ 404-48000-384 Refuse/Garbage Disposal -$ -$ -$ -$ 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. 18,345$ 37,613$ 345,445$ 133,801$ 300,000$ 2,686$ 150,000$ Tennis Court/Pickle Ball Courts 404-48000-720 Operating Transfers -$ -$ -$ -$ Total Park Investment Fund Expenditures 18,345$ 38,663$ 349,945$ 135,651$ 300,000$ 48,022$ 150,000$ Page 18 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A EQUIPMENT REPLACEMENT FUND REVENUE Revenues 406-48500-31000 Washington Cty. Tax Settlement 130,000$ 87,800$ -$ 72,600$ 110,000$ 55,000$ 125,000$ 406-48500-36210 Interest Income 657$ 821$ 3,958$ 1,812$ 1,045$ -$ 1,061$ 406-48500-36230 Donations -$ -$ -$ -$ -$ 406-48000-33422 Other State Grants & Aids -$ -$ -$ -$ -$ 406-48500-36250 Misc. Refund -$ -$ -$ -$ -$ 406-48500-36260 Sale of Equipment 42,038$ 18,851$ 20,296$ -$ -$ -$ 406-48500-39200 Interfund Operating Transfer -$ -$ 466,000$ -$ -$ 406-48500-39350 Certificate of Indebtedness -$ -$ -$ -$ -$ Total Equipmnt Replacement Fund Revenues 172,695$ 88,621$ 22,809$ 94,708$ 577,045$ 55,000$ 126,061$ 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 204,506$ 73,019$ 92,508$ 867,000$ 165,745$ 592,296$ 406-48500-550 Motor Vehicles Capital 40,073$ 13,358$ 84,356$ 119,516$ 406-48500-560 Furniture and Fixtures -$ -$ -$ -$ 406-48500-570 Office Equipment -$ -$ -$ -$ 406-48500-720 Operating Transfers -$ -$ -$ -$ Total Equipmnt Replacement Fund Expenditures 40,073$ 204,506$ 73,019$ 105,866$ 951,356$ 285,261$ 592,296$ LOCAL ROAD IMPROVEMENT FUND REVENUES Revenues 408-43100-31000 Washington Cty. Tax Settlement 438,539$ 216,860$ 212,012$ 289,137$ 375,000$ 187,500$ 440,000$ 408-43100-33422 Other State Grants & Aids 89,362$ 17,744$ 35,702$ -$ 63,082$ small cities assistance grant 408-43100-34304 Reimbursement for Services -$ -$ -$ 408-43100-36100 Special Assessments 197$ 66$ -$ -$ 408-43100-36210 Interest Income 4,298$ 4,655$ 11,889$ 6,947$ 10,705$ -$ 15,795$ 408-43100-39203 Transfer from Other Funds 80,000$ 26,667$ -$ -$ 408-43100-39310 Proceeds-Gen Obligation Bond -$ 4,000,000$ -$ 408-43100-36250 Misc. Refund -$ -$ -$ -$ Total Local Road Improvement Fund Revenues 612,199$ 239,259$ 224,098$ 358,519$ 4,385,705$ 250,582$ 455,795$ Page 19 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A LOCAL ROAD IMPROVEMENT FUND EXPENDITURES Expenditures 408-43100-303 Engineering Fees 160,493$ 141,479$ 186,534$ 162,835$ 120,000$ 169,617$ -$ 408-43100-319 Other Services -$ 375$ -$ 408-43100-351 Legal Notices Publishing -$ 59$ 408-43100-530 Capital Impr Other Than Bldgs. 799,606$ 453,591$ 834,301$ 695,833$ 3,575,000$ 1,358,646$ 665,000$ 408-43100-720 Operating Transfers -$ -$ -$ -$ -$ -$ -$ Total Local Road Improvement Fund Expenditures 960,100$ 595,070$ 1,020,835$ 858,668$ 3,695,000$ 1,528,697$ 665,000$ Total Levy Washington City. Tax Settlement 2,393,235$ 2,437,934$ 2,671,551$ 2,500,906$ 2,997,338$ 1,568,573$ 3,121,773$ increase/(decrease) over 2024 Page 20 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 79 Users BLISS SEWER FUND REVENUES YTD 10/31/24 Revenues 602-43210-31951 Special Assessments Principal 2,887$ -$ 962$ -$ 2,652$ -$ 602-43210-31952 SA Penalties & Interest 624$ 579$ 403$ 535$ 420$ 318$ 400$ 602-43210-33422 Other State Grants & Aids 25$ 74$ 20$ 40$ -$ -$ -$ 602-43210-34401 Sewer User Fees 98,531$ 106,717$ 139,546$ 114,931$ 125,230$ 67,602$ 126,400$ $1,608 per year, $133.34 per month, 4% increase 602-43210-34402 Sewer Connection Fee 8,000$ 8,000$ 8,000$ 8,000$ -$ -$ -$ 602-43210-36100 Special Assessments -$ -$ -$ 47$ -$ 602-43210-36102 Penalties & Interest 183$ 61$ -$ 138$ -$ 602-43210-36210 Interest Income 181$ 301$ 1,380$ 621$ 210$ -$ 200$ 602-43210-36250 Misc. Refund -$ -$ -$ -$ -$ 602-43210-39200 Interfund Tranfers In -$ -$ -$ -$ -$ Total Bliss Sewer Fund Revenues 107,361$ 118,557$ 149,532$ 125,150$ 125,860$ 70,757$ 127,000$ Expenditures BLISS SEWER FUND EXPENDITURES YTD 10/31/24 E 602-43210-101 Regular Wages & Salaries602-43210-101 Regular Wages & Salaries 11,014$ 21,714$ 20,576$ 17,768$ 17,458$ 14,839$ 16,700$ E 602-43210-120 Pension Expense602-43210-120 Pension Expense (1,438)$ (693)$ 7,430$ 1,766$ -$ -$ -$ E 602-43210-121 PERA Coord. Employer Contribu.602-43210-121 PERA Coord. Employer Contribu. 806$ 1,629$ 1,542$ 1,326$ 1,309$ 1,112$ 1,300$ E 602-43210-122 FICA Employer Contribution602-43210-122 FICA Employer Contribution 684$ 1,284$ 1,216$ 1,061$ 1,082$ 867$ 1,000$ E 602-43210-126 MEDICARE Employer Contribution602-43210-126 MEDICARE Employer Contribution 156$ 299$ 284$ 246$ 253$ 217$ 200$ E 602-43210-131 Employer Paid Health602-43210-131 Employer Paid Health -$ -$ -$ -$ -$ -$ -$ E 602-43210-210 Operating Supplies602-43210-151 Worker s Comp Insurance Prem 422$ 1,215$ 736$ 791$ 525$ 783$ 800$ E 602-43210-240 Small Tools and Minor Equip602-43210-200 Office Supplies 109$ 128$ 48$ 95$ 91$ 102$ 100$ E 602-43210-303 Engineering Fees602-43210-210 Operating Supplies 558$ 680$ 1,823$ 1,020$ 700$ 32$ 500$ Daily use items, hardwares, misc. items E 602-43210-304 Legal Services602-43210-240 Small Tools and Minor Equip -$ 217$ -$ 72$ 420$ -$ 500$ Hand tools, septic/water sample tools E 602-43210-308 Other Professional Services602-43210-303 Engineering Fees 13,277$ (1,538)$ 1,409$ 4,383$ 8,880$ 74,633$ 5,000$ E 602-43210-309 Software Support & Maintenance602-43210-304 Legal Services -$ 6,000$ 18$ 2,006$ -$ -$ E 602-43210-317 Employee Training602-43210-308 Other Professional Services 3,376$ 5,814$ 7,773$ 5,654$ 3,500$ 15,841$ 20,400$ Water/Wastewater analytical testing, Lobbying E 602-43210-321 Telephone602-43210-309 Software Support & Maintenance 716$ 756$ 529$ 667$ 910$ -$ 700$ SCADA & Utility Billing E 602-43210-322 Postage 602-43210-317 Employee Training 868$ 925$ 336$ 710$ 980$ 598$ 500$ Wastewater training E 602-43210-331 Travel Expenses602-43210-321 Telephone 2,413$ 1,751$ 2,656$ 2,273$ 1,750$ 1,492$ 1,200$ SCADA dialers E 602-43210-334 Licenses & Permits602-43210-322 Postage -$ 200$ 200$ 133$ 420$ -$ 150$ E 602-43210-361 Liability/Property Ins602-43210-331 Travel Expenses 8$ 158$ 633$ 266$ 525$ 78$ 250$ E 602-43210-381 Utilities-Electric & Gas602-43210-334 Licenses & Permits 1,180$ 824$ 729$ 911$ 1,400$ 505$ 750$ Wastewater Certification/Permit Renewal E 602-43210-385 Sewer Pumping & Maintenance602-43210-361 Liability/Property Ins 1,039$ 1,003$ 3,449$ 1,830$ 764$ 2,383$ 2,500$ E 602-43210-386 Operation & Maintenance602-43210-381 Utilities-Electric & Gas 1,862$ 3,473$ 3,936$ 3,090$ 2,100$ 934$ 3,000$ E 602-43210-404 Repair Machinery/Equipment602-43210-385 Sewer Pumping & Maintenance 5,364$ 11,410$ 4,695$ 7,156$ 14,000$ 1,820$ 10,000$ Residential holding tank pumping E 602-43210-413 Equipment Rental602-43210-386 Operation & Maintenance 1,574$ 2,888$ 2,639$ 2,367$ 3,500$ -$ 2,000$ E 602-43210-420 Depreciation Expense602-43210-404 Repair Machinery/Equipment 4,375$ 5,857$ 12,101$ 7,444$ 11,200$ 2,611$ 7,000$ Pump and control repair/replacement E 602-43210-438 Misc. Contractual602-43210-413 Equipment Rental -$ -$ -$ -$ 700$ -$ 500$ E 602-43210-439 Refunds Issued602-43210-420 Depreciation Expense 48,667$ 50,174$ 50,428$ 49,756$ 40,600$ -$ 40,000$ approximate E 602-43210-530 Capital Impr Other Than Bldgs602-43210-438 Misc. Contractual 3,775$ 2,550$ 2,660$ 2,995$ 7,000$ 1,470$ 4,000$ Emergency or additional holding tank pumping and maintenance, Lift station inspection/pump testing E 602-43210-720 Operating Transfers602-43210-439 Refunds Issued -$ -$ -$ -$ -$ 602-43210-530 Capital Impr Other Than Bldgs 3,278$ (8,448)$ (1,723)$ 6,930$ -$ 5,000$ Pump replacement 602-43210-720 Operating Transfers -$ 17,584$ -$ Total Bliss Sewer Fund Expenditures 100,803$ 121,995$ 119,398$ 114,065$ 126,997$ 137,902$ 124,050$ Page 21 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 9 Users UPTOWN SEWER FUND REVENUES YTD 10/31/24 Revenues 612-43210-33422 Other State Grants & Aids 7$ 29$ 1$ 12$ -$ -$ -$ 612-43210-34401 Sewer User Fees 15,132$ 17,442$ 22,166$ 18,247$ 22,400$ 11,142$ 28,000$ 25% increase 612-43210-34402 Sewer Connection Fee -$ -$ -$ -$ 612-43210-36210 Interest Income 64$ 55$ 326$ 148$ 50$ -$ 50.00$ 612-43210-36250 Misc. Refund -$ -$ -$ -$ 612-43210-39203 Transfer from Other Funds -$ -$ -$ -$ Total Uptown Sewer Fund Revenues 15,203$ 17,526$ 22,493$ 18,407$ 22,450$ 11,142$ 28,050$ UPTOWN SEWER FUND EXPENDITURES YTD 10/31/24 Expenditures 612-43210-101 Regular Wages & Salaries 3,673$ 9,282$ 8,559$ 7,171$ 10,725$ 5,971$ 8,900$ 612-43210-120 Pension Expense (630)$ 1,164$ 3,619$ 1,384$ -$ -$ -$ 612-43210-121 PERA Coord. Employer Contribu. 259$ 697$ 642$ 532$ 804$ 447$ 700$ 612-43210-122 FICA Employer Contribution 219$ 550$ 505$ 425$ 665$ 348$ 600$ 612-43210-126 MEDICARE Employer Contribution 50$ 126$ 118$ 98$ 156$ 88$ 100$ 612-43210-151 Worker s Comp Insurance Prem 218$ 304$ 316$ 279$ 300$ 522$ 522$ 612-43210-200 Office Supplies 4$ -$ -$ 1$ 100$ -$ 100$ billing 612-43210-210 Operating Supplies -$ 500$ 320$ 273$ 500$ -$ 500$ Daily use items, hardwares, misc. items 612-43210-221 Equipment Parts -$ -$ -$ -$ 500$ -$ 500$ 612-43210-303 Engineering Fees 7,272$ -$ -$ 2,424$ 630$ -$ 1,000$ 5% increase 612-43210-308 Other Professional Services 192$ 884$ 733$ 603$ 750$ 310$ 900$ Wastewater Analytical testing 612-43210-309 Software Support & Maintenance 80$ 84$ 84$ 83$ 84$ -$ 87$ 612-43210-317 Employee Training 275$ -$ -$ 92$ 200$ 1,138$ 200$ 612-43210-319 Other Services -$ -$ -$ -$ 1,500$ -$ -$ 612-43210-322 Postage 18$ -$ -$ 6$ -$ -$ 100$ 612-43210-334 Licenses & Permits 209$ 217$ 247$ 224$ 250$ 231$ 250$ 612-43210-361 Liability/Property Ins 283$ 334$ 478$ 365$ 351$ 464$ 464$ 612-43210-381 Utilities-Electric & Gas 522$ 697$ 863$ 694$ 1,000$ 265$ 1,000$ 612-43210-385 Sewer Pumping & Maintenance (260)$ 327$ 1,800$ 622$ 1,500$ 1,484$ 1,000$ 612-43210-386 Operation & Maintenance -$ 462$ -$ 154$ 1,000$ 30$ 500$ 612-43210-404 Repair Machinery/Equipment 767$ 465$ -$ 411$ 2,000$ -$ 1,000$ 612-43210-420 Depreciation Expense 4,876$ 4,877$ 4,876$ 4,876$ 4,900$ -$ 4,900$ 612-43210-438 Misc. Contractual 100$ 548$ 140$ 263$ 1,500$ 589$ 1,500$ Lift Station Inspection/Pump Testing 612-43210-530 Capital Impr Other Than Bldgs 1,456$ -$ -$ 485$ 9,900$ 5,000$ Pump Replacement 612-43210-570 Office Equipment -$ -$ -$ -$ -$ 612-43210-720 Operating Transfers -$ -$ -$ 2,640$ 2,640$ Total Uptown Sewer Fund Expenditures 19,582$ 21,516$ 23,299$ 21,466$ 41,955$ 11,886$ 32,463$ Page 22 of 23 11/1/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 3-Yr Avg 2024 Budget 7/31/2024 2025 Actual Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 33 Users ANDERSON-ERICKSON SEWER FUND REVENUES YTD 10/31/24 Revenues 624-43210-31951 Special Assessments Principal 2,887$ 962$ -$ -$ 624-43210-31952 SA Penalties & Interest 624$ 579$ 401$ 180$ 200$ 624-43210-33422 Other State Grants & Aids 25$ 74$ 33$ -$ -$ 624-43210-34401 Sewer User Fees 98,531$ 106,717$ 68,416$ 53,670$ 28,623$ 52,800$ $1,608 per year, $133.34 per month, 4% increase 624-43210-34402 Sewer Connection Fee 8,000$ 8,000$ 5,333$ -$ -$ -$ 624-43210-36100 Special Assessments -$ -$ -$ 624-43210-36102 Penalties & Interest -$ -$ 40$ -$ 624-43210-36210 Interest Income 181$ 301$ 161$ 90$ 100$ 624-43210-36250 Misc. Refund -$ -$ -$ 624-43210-39200 Interfund Tranfers In -$ -$ 17,584$ -$ Total Anderson-Erickson Sewer Fund Revenues 107,361$ 118,557$ -$ 75,306$ 53,940$ 46,247$ 53,100$ Expenditures ANDERSON-ERICKSON SEWER FUND EXPENDITURES YTD 10/31/24 624-43210-101 Regular Wages & Salaries -$ -$ 7,482$ -$ 5,100$ 624-43210-121 PERA Coord. Employer Contribu. -$ -$ 561$ -$ 400$ 624-43210-122 FICA Employer Contribution -$ -$ 464$ -$ 300$ 624-43210-126 MEDICARE Employer Contribution -$ -$ 108$ -$ 100$ 624-43210-151 Worker s Comp Insurance Prem -$ -$ 225$ -$ 250$ 624-43210-200 Office Supplies -$ -$ 39$ -$ $50 624-43210-210 Operating Supplies -$ -$ 300$ -$ $250 Daily use items, hardwares, misc. items 624-43210-240 Small Tools and Minor Equip -$ -$ 180$ 44$ $150 Hand tools, septic/water sample tools 624-43210-303 Engineering Fees 320$ 107$ -$ -$ $4,000 624-43210-304 Legal Services -$ -$ -$ -$ $0 624-43210-308 Other Professional Services -$ -$ 1,500$ -$ $1,500 Water/Wastewater analytical testing 624-43210-309 Software Support & Maintenance -$ -$ 390$ 310$ $300 SCADA & Utility Billing 624-43210-317 Employee Training 227$ 76$ 420$ -$ $350 Wastewater training 624-43210-321 Telephone -$ -$ 750$ 109$ $550 SCADA dialers 624-43210-322 Postage 253$ 84$ 180$ 705$ $100 624-43210-331 Travel Expenses 80$ 27$ 225$ -$ $225 624-43210-334 Licenses & Permits -$ -$ 600$ 78$ $500 Wastewater Certification/Permit Renewal 624-43210-361 Liability/Property Ins -$ -$ -$ 231$ $1,000 624-43210-381 Utilities-Electric & Gas -$ -$ 900$ 985$ $1,000 624-43210-385 Sewer Pumping & Maintenance 43$ 14$ 6,000$ 358$ $4,000 Residential holding tank pumping 624-43210-386 Operation & Maintenance -$ -$ 1,500$ -$ $1,000 624-43210-404 Repair Machinery/Equipment -$ -$ 4,800$ -$ $3,000 Pump and control repair/replacement 624-43210-413 Equipment Rental 408$ 136$ 300$ 1,289$ $300 624-43210-420 Depreciation Expense -$ -$ 17,400$ -$ $10,000 approximate 624-43210-438 Misc. Contractual -$ -$ 3,000$ 4,508$ $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 2,990$ 997$ 2,970$ -$ $3,000 Pump replacement 624-43210-570 Office Equipment -$ -$ -$ -$ 624-43210-720 Operating Transfers -$ -$ -$ -$ Total Anderson-Erickson Sewer Fund Expenditures -$ -$ 4,320$ 1,440$ 50,294$ 8,617$ 40,425$ Page 23 of 23 CITY OF SCANDIA SUMMARY BUDGET 6/20/2023 Inflation Assumptions 677,171 810,813 800,388 826,955 851,764 877,317 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.00% 3.00% 3.00% 3.00% 3.00% 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,893,907 1,969,663 2,028,753 2,089,616 2,152,304 2,216,873 2,283,379 2 Other taxes 4,115 149,697 134,357 149,179 152,163 155,206 158,310 161,476 164,706 168,000 3 Intergovernmental 69,875 61,000 71,674 69,000 70,380 71,788 73,223 74,688 76,182 77,705 4 Grants 11,700 5 Franchise fees - 6 Licenses and Permits 182,640 161,100 179,100 183,100 186,762 190,497 194,307 198,193 202,157 206,200 7 Charges for Services 53,383 53,000 57,074 58,813 59,989 61,189 62,413 63,661 64,934 66,233 8 Fines & Forfeits 6,027 7,400 7,000 6,000 6,180 6,365 6,556 6,753 6,956 7,164 9 Interest Earnings 5,459 12,100 30,000 30,900 31,827 32,782 33,765 34,778 35,822 10 Miscellaneous Revenues 13,452 9,900 11,000 9,500 9,785 10,079 10,381 10,692 11,013 11,343 11 - - - - - - - - - - 12 Total Revenue 1,942,093 2,331,815 2,326,123 2,399,499 2,485,822 2,555,704 2,627,588 2,701,533 2,777,599 2,855,847 EXPENSES 13 Current 14 General Government 667,685 754,700 714,744 742,967 765,256 788,214 811,860 836,216 861,303 887,142 15 Public Safety 458,856 504,399 547,807 592,625 610,403 628,715 647,577 667,004 687,014 707,625 16 Public Works 636,351 732,450 815,044 820,500 845,115 870,468 896,583 923,480 951,184 979,720 17 Park and Recreation 171,884 175,060 209,226 206,637 212,836 219,221 225,798 232,572 239,549 246,735 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,286,822 2,362,729 2,433,611 2,506,619 2,581,818 2,659,272 2,739,050 2,821,222 26 Revenues Over / (Under) Expenses 7,317 15,206 39,301 36,770 52,211 49,085 45,770 42,261 38,549 34,625 38 Ending General Fund Balance (FB) 1,349,787 1,364,993 1,404,294 1,441,064 1,493,275 1,542,360 1,588,130 1,630,391 1,668,940 1,703,565 39 Restricted - - - - - - - - - - 40 Unassigned 1,349,787 1,364,993 1,404,294 1,441,064 1,493,275 1,542,360 1,588,130 1,630,391 1,668,940 1,703,565 41 Fund Balance as a % of Next Year's Expenditures (net of contingency) 58.3% 59.7% 59.4% 59.2% 59.6% 59.7% 59.7% 59.5% 59.2% #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,893,907 1,969,663 2,028,753 2,089,616 2,152,304 2,216,873 2,283,379 42 Annual Increase 16.3% 16.1% 0.0% 1.5% 4.0% 3.0% 3.0% 3.0% 3.0% 3.0% ANNUAL DEBT LEVIES BY BOND ISSUE-FUTURE 43 44 BONDS ISSUED 3,635,000 45 EQUIPMENT CERTIFICATES 340,000 515,510 - 250,000 - 250,000 300,000 - 46 47 - 48 Total Annual Debt Issuance - - 3,975,000 515,510 - 250,000 - 250,000 300,000 - OTHER SPECIAL TAX LEVIES 49 Debt service 50 2025 Certificates 67,000 64,000 51 2024 Certificates 52 2024 GO Bonds 34,524 115,703 162,828 285,098 357,158 359,258 355,688 357,158 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 - 38,997 107,617 104,553 132,403 129,519 157,409 180,914 56 Local road improvement Debt Levy 57 Total Annual Debt Levies 446,055 406,536 345,634 497,866 610,985 732,659 834,721 830,525 856,525 882,865 ANNUAL CAPITAL PROJECTS LEVIES 58 Capital Improvement 217,336 293,791 235,000 125,000 130,000 135,200 140,608 146,232 152,082 158,165 59 Park Improvement 20,000 20,000 60,000 40,000 40,000 40,000 50,000 50,000 50,000 50,000 60 Equipment Replacement 87,800 - 110,000 125,000 131,250 137,813 144,703 151,938 159,535 167,512 61 Local Road Improvement 216,860 212,012 375,000 440,000 473,000 508,475 546,611 584,873 625,815 669,622 62 63 EDA 8,000 5,300 5,300 - 64 65 Total Other Special Levies 549,996 531,103 785,300 730,000 774,250 821,488 881,922 933,044 987,431 1,045,298 66 67 Total Tax Levy 2,603,193 2,803,557 2,996,852 3,121,773 3,354,898 3,582,899 3,806,259 3,915,873 4,060,830 4,211,543 68 Increase/(Decrease) in Total Tax Levy 14.67% 7.70% 6.89% 4.17% 7.47% 6.80% 6.23% 2.88% 3.70% 3.71% 69 Less: Fiscal Disparities (132,739) (123,279) (107,857) (123,679) (109,722) (118,764) (125,522) (132,050) (134,404) (138,089) 70 Net Levy to Taxpayers 2,470,454 2,680,278 2,888,995 2,998,094 3,245,177 3,464,135 3,680,736 3,783,823 3,926,425 4,073,454 71 Levy % Change 15.11% 8.49% 7.79% 3.78% 72 Existing Tax Base 8,336,001 10,129,722 10,818,416 10,758,518 10,758,518 10,866,103 10,974,764 11,084,512 11,195,357 11,307,311 82 5.37% 21.52% 6.80% -0.55% 83 New Net Tax Capacity 0 0 0 0 0 0 0 0 0 0 84 Total Net Tax Capacity 8,336,001 10,129,722 10,818,416 10,758,518 10,758,518 10,866,103 10,974,764 11,084,512 11,195,357 11,307,311 85 Tax Rate on Tax Capacity 29.636% 26.460% 26.704% 27.867% 30.164% 31.880% 33.538% 34.136% 35.072% 36.025% 86 Tax Rate % Change 9.24063% -10.72% 0.93% 4.35% 8.24% 5.69% 5.20% 1.78% 2.74% 2.72%