Loading...
HomeMy WebLinkAbout07.12.21 Work Session Packet CITY OF Meeting Location: FARMINGTONFarmington City Hall 430 Third Street 77 Farmington, MN 55024 CITY COUNCIL WORK SESSION MEETING AGENDA July 12, 2021 5:00 PM 1. CALL TO ORDER 2. APPROVE AGENDA 3. DISCUSSION ITEMS (a) 2022/2023 Draft Budget Discussion (60 Minutes) (b) Emergency Management and City Council Role(45 Minutes) 4. CITY ADMINISTRATOR UPDATE S. ADJOURN CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-280-6800 ISI Farmington MN.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: 2022/2023 Draft Budget Discussion (60 Minutes) DATE: July 12, 2021 INTRODUCTION The draft 2022/2023 General Fund summary budget information is included for your first in-depth review. Department heads submitted initial budget requests that I reviewed over the past month. I have made a number of changes to those requests that are reflected in the draft included with this memo. As expected,those requests were much higher then the version you are seeing with this packet. DISCUSSION Before we get into the details of the proposed 2022/2023 budget, I need to state for anyone reviewing this information that this information is a draft of the 2022/2023 budget. City staff clearly understands that the draft tax levy that is included is not realistic and it will change before the city council considers both the preliminary and final tax levies for 2022. We share the current status of the draft budget to be transparent and start discussion items with the city council as we plan for the future of our community. City staff has done an excellent job of submitting what they believe are the needs of their departments for the next two years. My approach to adjusting the budget was to prioritize the city council priorities set earlier this year. These priorities include: • Developing dedicated financial benchmarks for capital replacements in the annual budget. • Developing dedicated financial benchmarks for infrastructure support and facilities in the annual budget. • Developing a staffing plan for inclusion in the annual budget and financial plan. 2022/2023 Draft Budget City staff continues to work to plan for the future with realistic budgets and follow the five/ten year financial plan that you reviewed in June. A copy of the financial plan is attached again for your review. It has not been updated from the plan you reviewed earlier this year. The current version of the 2022/2023 budget stands as follows: 2021 Budget 2022 Draft Budget Increase/(Decrease) Revenues $3,298,344 $3,577,333 8.46% Expenditures $13,832,464 $15,870,719 16.7% Fiscal Disparities . $2,277,659 $2,277,659 0.00% Gen Fund Levy $8,256,461 $10,015,727 21.31% Debt Levy $3,012,093 $2,265,788 (17.32)% Net Tax Levy $11,268,554 $12,281,515 8.99% Revenues Proposed non-property tax related revenues are up 8.46%over the 2021 budget. This is a much higher than normal number compared to previous years budgets. The revenue changes by area are detailed below. License/Permits This area includes the most significant changes from the 2021 budget. While most of the line items remain relatively consistent with 2021, staff is projecting that building permit revenue will increase by $210,000 from the 2021 budgeted number. This number lines up with what we are experiencing in 2021. 1 ntergovernmental This area remains relatively flat from 2021 to 2022. The total intergovernmental aid will increase from $663,587 in 2021 to$672,087 in 2022. Charges for Service This revenue category will see a slight increase in 2022. The biggest area of change comes in the fire charges area. This is the revenue we receive from the three townships for services provided by the city. Two of the townships have a set revenue number for 2022 based upon contracts we have agreed upon. Empire Township continues to be charged based off of an old formula that is used. The total revenue in this category for 2022 is$602,460. Fines and Forfeitures There is no change proposed in this category for 2022. The revenue will remain at the 2021 revenue number of$49,000. 1 nvestment I ncome I nvestment income will see a healthy increase in 2022. The city only accounts for investments that are non-callable in the next budget year. The amount in this category is the General Fund's portion of the investment income and does not reflect all of the income received. The 2022 budget includes$41,600 in investment income. Miscellaneous Revenue This category is down significantly from 2021. The amount of miscellaneous revenue for 2021 was reduced to reflect the reality of our budget for 2022. The total amount of revenue included for 2022 is $50,878. Operating Transfers In A detailed breakdown of the transfers in and out of the 2022 budget is included as a separate exhibit in the packet. The transfers into the General Fund are from the Enterprise Funds to reimburse the General Fund for human resource and administrative costs which benefit the Enterprise Funds. Expenditures I n comparing the current draft of the 2022 budget to the approved 2021 budget, expenditures are proposed to increase$2,038,255 or 14.74%. Of this amount, approximately$717,854 is attributed to human resources costs. This number is consistent with the estimated increase for 2021 with the addition of the Assistant City Administrator position in the 2022 budget. The estimated cost of wages and benefits for this position is approximately$150,000. The majority of the remaining proposed increases can be accounted for in the Transfers Budget. Human Resources Costs All of the budgets include human resources costs based on estimates created by the Human Resources Department. All of our union contracts expire at the end of 2021 and none have been settled at this point. We have also included estimated increases for health insurance, other employee benefits and workers compensation premiums. There was only one request for additional positions in 2022. The Police Department did request the addition of a Community Service Officer in both 2022 and 2023. While there is a legitimate need for these types of positions in the department,the 2022 budget is not at a point to include the request at this point. Transfers Budget The Transfers Budget accounts for a significant portion of the proposed increase for 2022. This is the budget where the increases associated with the 2021/2022 city council priorities are included. Please see the following points that address each of the significant increases in the Transfers Budget- • Future Vehicle Cl P Cash-The draft 2022 budget includes $475,000 for our Vehicle Cl P. For the sake of the budget, this amount has been split into two numbers at this point, $299,000 for General Capital Equipment and $176,000 for General Capital Equipment-Police. The$475,000 amount is an increase of S331,486 over the amount included in the 2021 budget for this area. Our five and ten year Cl P in this area requires additional funding each year than we are allocating in 2022. The city has used a band aid approach to this area in the past and must start to include a significant amount of funding each year to pay cash for these purchases. We still have significant needs in this area including a replacement Vac Truck, additional snowplows, a loader and more. Our target annual funding amount in this area is$800,000. • Sealcoat-The draft 2022 budget includes $650,000 in the sealcoat line item. I n reality,these are dollars that will be used to mill and overlay the remaining portion of Akin Road in 2022. This is an increase of 8318,792 over 2021. Our target annual funding amount in this area is $875,000. • Street Maintenance-The Transfer Budget includes $175,000 for the first debt repayment for the 2022 Spruce Street/Division Street Reconstruction project. This amount is an estimated at this point. Staff has moved including the collection of the first payment in the same year as project construction to ensure we have money in the bank to pay the first payment that will be due in 2023. For many years the city waited a year to collect the first payment for one year which had a negative impact on our cash management. This item is a S175,000 increase over 2021. • Trail Maintenance-This item includes$85,000 in tax levy dollars for trail maintenance in 2022. This is a $65,000 increase over 2021. There is also$50,000 of Local Government Aid dollars identified for trail maintenance. This is a S65,000 increase in tax dollars over 2021. Our target annual funding amount in this area is$510,000. Due to the current state of the 2022 budget, I removed two items from the Transfers Budget that I think are important. We originally had$220,000 included in the budget to start to collect dollars to replace Engine 1 in 2026. This was/is going to be an annual collection amount to have cash available to pay for a new fire engine replacement every five years. I n addition,we removed $20,000 from this budget to go towards Compensated Absences payouts. Although I support its inclusion,we cannot afford this addition in 2022. 1 should point out that the Transfers Budget accounts for the use of the$105,587 in Local Government Aid dollars we receive from the State of Minnesota. We have these funds earmarked for trail maintenance($50,000), our EAB program ($10,000) and Building Maintenance($45,587). Fiscal Disparities This amount will be finalized in August 2021. The current draft 2022 budget includes the same amount that we received in 2021, $2,277,659. As a reminder, Fiscal Disparities is a metro-wide program that shares the commercial/industrial growth in the metro area between cities. Because Farmington has not developed at the same rate as other metro cities in the commercial/industrial area,we are a net"gainer" of revenue in this area. Debt Service Funds Levy The Debt Service Funds budget provides funding for scheduled debt principle and interest payment obligations, as well as ongoing trustee, assessments, arbitrage and post-issuance compliance fees related to the city's debt. The levy includes both General Obligation bonds and interfund loans. The net debt levy for 2022 reflects a decrease of$746,305 from the 2021 budget. The decrease is associated with the payoff of the Ash/Spruce/Hill Dee projects from 2007 and the payoff of the police station project from 2002. The debt associated with the 2022 Spruce/Division Street project will be moved to this budget with the 2023 budget. Additional Notes There are numerous factors that brought the proposed 2022 tax levy to where it stands today. These include- • Honest and transparent budgeting of city needs by staff. • Estimated cost of living and wage adjustment for staff. • The addition of one staff position in the Administration Department. • Inclusion of funding progress on city council goals in 2022 budget. it should be noted that the use of the funding from 2020 liquor store profits ($130,000) has not yet been incorporated into the 2022 budget. I n addition,the use of the American Rescue Plan funding the city will receive is not included as a part of the 2022 budget at this point. BUDGET IMPACT The establishment of the 2022 budget will set the framework for our financial health and work plan for next year. ACTION REQUESTED Review the information on the 2022/2023 budget, ask any questions you may have and provide city staff with direction on how to move forward on the draft budget. ATTACHMENTS: Type Description D Cover Memo General Fund Budget Summary 2022 D Cover Memo General Fund Budget Revenues 2022 D Cover Memo General Fund Budget Expenditures 2022 © Cover Memo Debt Levy Breakdown 2022 D Cover Memo 2022 5/10 Year Financial Plan City of Farmington Budget and Tax Levy 2021 Budget,2022 Proposed and 2023 Proposed j Company 2021 2022 Budget% 2023 Budget o/o Budget Proposed Change Proposed Change Non-Property Tax Revenues ) _._.... Licenses and permits ! 517,076' 733,450 4185%i 714,850 (2.54)%j Intergovernmental Revenuo667,912672,Q87 0.63%1 677,087; 0.74%1 Charge for Service 576,197' 602,460; 4.56%1 583,804' (3.10)% Fines and Forfeitures 49,000 49,000; 0.00%i 49,000; 0.00% , Investment Income29,100, 41,600 42.96% 27,700 (33.41)% Miscellaneous j 79,370; 50,878; (35.90)%i 50,878; 0.00% _. i Transfers In 1,379,689 1,427,858 3.49%' 1,484,973 4.00% Total Revenues 3,298,344; 3,577,333; 8.46%1 3,588,292; 0.31% Expenditures Administration i 902,915: 1,101,749; 22.02%; 1,099,267; (0.23)% Human Resource 361,658: 402,112 11.19% 403,181 0,27%' Dakota Broadband 37,500 45,500 21.33% 55,500; 21.98%' Finance and Risk Mgmt 776,287; 818,759' 5.47% 843,271 2.99%' Police4,845,796: 5,285,810: 9.08% 5,626,633's 6.45% _ . Fire 1,435,6851 1,604,646- 11.77% 1,603,221 (0.09)% Community Development 1,007,849' 1,059,182: 5.09%= 1,101,722; 4.02% Engineering 813,895; 853,411; 4.86% 878,268; 2,91% Municipal Services 1,511,187 1,615,704; 6.92% 1,739,967: 7.69% Parks and Recreation 1,317,341 1,341,237, 1.81%' 1,381,762: 3.02%'; Transfers Out 822,351; 1,742,609; 111.91% 2,756,609 58.19%' Total Expenditures 13,832,464 15,870,719: 14.74%i 17,489,401' 10.20%' Revenues Over(Under)Expenditures (10,534,120) (12,293,386) 16.70%; (13,901,109)' 13,08%'; Fiscal Disparities 2,277,659' 2,277,659 0.00%., 2,277,659; 0.00%. {General Fund Levy8,256,461 10,015,7271 21.31%j 11,623,450: 16,05%; Debt Levy Bonds2,444,840; 2,099,788; (14.11)%; 1,707,263' (18.69)% 20050 Loan Repay-Storm Water Tr Adv 275,000: 166,000; (39.64)% 166,000: 0,00% 2010A Loan Repay-Storm Water Tr Adv 292,253: 0 (100.00)% 201 OD Loan Repay-Storm Water Tr Adv 0 0 Total Debt Levy 3,012,093; 2,265,788! (24.78)%`: 1,873,263, (17.32)%j Use of Fund Balance to Lower Debt Levy 0 Net Debt Levy 3,012,093, 2,265,788; (24.78)%! 1,873,283; (17.32)%` Farmington Net Tax Levy 11,268,554' 12,281,515' 8.99%' 13,496,713: 9.89% i i i i i i General Fund Detailed Nott-Property Tax Revenue Summary 2020 Budget,2021 Budget, 2022 Proposed and 2023 Proposed Object 2020 2021 2022 2023 Account Budget Budget Proposed Proposed ...... ......:.-... . LIQUOR LICENSES 41,7001 40,0001 37,000- 37,0001 BEER&WINE LICENSES 1,1001 1,100' 550 550; CLUB LICENSES 500; 500; 500; 500; MASSAGE LICENSE 350; 300; 50 501 1 GAMBLING LICENSE/PERMIT 450! 250` 150, 15011 OTHER LICENSE&PERMIT 1,900, 1,700 1,400; 1,400; ANIMAL LICENSES 4,080; 2,5001 2,000; 1,700; Licenses 50,080; 46,350; 41,650; 41,350' _ . . . 1 BUILDING PERMITS 330,000: 380,876; 590,0001 572,250' REINSPECTION FEES 1,000: 1,500, 1,200. 1,200; CODE ENFORCEMENT FEES 2,600 1,500; 900 900, PLUMBING&HEATING PERMITS 52,500' 50,000; 60,000; 60,000; SEWER PERMITS 5,000 0, 0 0 ELECTRIC PERMITS 16,000; 16,000; 20,000; 20,000: ISIS PERMITS 300; 3001 2501 250; UTILITY PERMITS 6,420 10,500; 10,500; 10,000; SIGN PERMITS 790' 800; 700: 7001 BURNING PERMITS 1,425! 1,250 1,2501 1,2001 OTHER PERMITS 7,000 8,000: 7,000; 7,000: Permits 423,035' 470,726' 691,800; 673,5001 Licenses and Permits 473,115. 517,076 733,450.% ..714,850; FEDERAL GRANT 5,000 5,000; 5,000 5,000: FEDERAL AID LOCAL GOVERNMENT AID 328,374 105,587 105,587; 105,587 MSA MAINTENANCE 215,000 184,000; 184,0001 184,000; POLICE AID 198,500' 198,000 205,000; 205,000; POST TRAINING 15,160! 15,160; 15,000; 15,000. FIRE AID 137,9101 142,490 150,0001 155,000: STATE GRANT 9,000; 01 , MARKET VALUE CREDIT 0: 0 COUNTY MISCELLANEOUS 13,3501 13,350, 7,500; 7,5001 :`Intergovernmental _... 922,294 663,587 672,087. '` 677,087, CUSTOMER SERVICE TAXABLE I 1 CUSTOMER SERVICES NONTAXABLE 200 2101 135; 1351 . ..... ZONING&SUBDIVISION FEES 3,050! 2,600. 3,000; 3,000 ADMINISTRATION FEES-PROJECTS 4,500; 4,000, 4,000; 4,000, FIRE CHARGES 237,1721, 239,227; 258,940; 264,177; POLICE SERVICE CHARGES 78,030' 78,810: 80,3851 81,992' ENGINEERING FEES-PROJECTS 1 EROSION&SEDIMENT CONTROL 8,100: 8,100; 9,500; 9,000; RECREATION FEES-GENERAL 85,000, 75,000; 75,0001 75,0001 RECREATION FEES-SENIOR CTR 19,000; 15,000; 17,0001 17,000; MEMBERSHIP FEES-SENIOR CTR 8,000 6,000 7,500. 7,500. MOBILE MEALS-SENIOR CTR 1 ADVERTISING 950; 750; 500; 5001 ADVERTISING 1,800 1,500' 1,5001 1,50011 FRANCHISE FEE 120,0001 145,000; 145,000; 120,0001 Charges For Services :566,802 576,197-. 602,460..: :.:583,804: COURT FINES 49,000; 49,000' 49,000; 49,000; Page 1 of 2 i General Fund Detailed Non-Property Tax Revenue Summary 2020 Budget,2021 Budget, 2022 Proposed and 2023 Proposed Object 2020 2021 2022 2023 Account Budget Budget Proposed Proposed Fines&Forfeitures 49,000 '49,000 49,000 49,000; i INTEREST ON INVESTMENTS 38,800' 29,100' 41,600; 27,7001 GAIN/LOSS INVEST MKT VALUE ! j Investment Income 38,800 29,100 41,600 .27,700: MISCELLANEOUS REVENUE 1,500; 31,700: 4,200' 4,200; CASH OVER&SHORT RENTAL INCOME-RRC 20,880: 18,000; 18,000; 18,000' RENTAL INCOME 31,700 29,670; 28,678' 28,678; DONATIONS 500 0 Misc Revenue 54,580 - 79,370 $0,878 ' ` 50,878 OPERATING TRANSFERS 1,307,570; 1,379,689; 1,427,8581 1,484,973'i Transfers in .1,307,570 1,379,689 1,427,858 1,484,973: Total Revenues $3,411,161. $3,294,019 :`$3,577,333_ .43,588,292; I i I i I Page 2 of 2 I General Fund Expenditure Detail Stttntnary 2020 Budget,2021 Budget 2022 Proposed and 2023 Proposed Company 2020 2021 2022 2023 Budget Budget Proposed Proposed ........... ..... ......._...._ . . ._._..... ... .... .:.....:... Expenditures Administration Legislative(1005) 87,772' 87,3921 87,7591 91,483 Administration(1014) 302,068 321,712: 469,6411 486,372; Elections(1013) 44,124: 9,351; 47,948; 8,250 Communications(1014) 108,537: 114,900. 132,916' 136,582 City Hal!(1015) 364,661. 369,560 363,485; 376,580: Administration 907,162 902,915 1,101,749 1,099,267 Human Resources 349,226 361,658. 402,112 403,181 Human Resource(1011) 349,226; 361,658. 402,112; 403,181. Human Resources 349,226 361,658 402,112 403,181. Dakota Broadband 24,489, 37,500 45,500; 55,500: Dakota Broadband 24,489: 37,500. 45,5001 55,5001 PakOta.Broadband. 24,489_ 37,500 45,500 55,500; Finance and Risk Management Finance(1021) 609,079' 603,097 648,309; 670,161; Risk Management(1022) 169,810; 173,190; 170,450; 173,1101 Finance and Risk Management 778,889 776,287 618,759 843,271 Police Police Administration(1050) 1,235,377. 1,263,014; 1,361,642 1,377,9071 Patrol Services(1051) 2,538,727: 2,639,752 2,930,249; 3,234,168 Investigations(1052) 892,059 926,430: 974,019 993,158 Emergency Management(1054) 11,650. 16,600 19,900 21,400; Police 4,677,813 4,845,796 5,285,810 5,626,633 Fire Fire(10 60) 1,445,410 1,435,685; 1,604,646. 1,603,221' Fire 1,445,410 1,435,685 1,604,646 1,603,221 Community Development 1,014,867. 1,007,849 1,059,182. 1,101,722: Planning(1030) 591,133' 567,681 624,475; 648,368. Building Inspection(1031) 423,734 444,168: 434,707' 453,354; Community Development 1,014,867 1,007,849 1,059,182 1,101,722. Engineering Engineering(1070) 665,173 694,134' 725,8161 746,721 Natural Resources(1076) ! 129,462: 119,761 127,595; 131,547 Engineering ` ` 794,635 813,895 853,411 878,268 Municipal Services j Streets(1072) 1,197,200 1,268,832 1,358,489; 1,472,837 Snow Removal(1073) 241,878 242,355: 257,215; 267,130 Municipal Services 1,439,078 1,511,187 1,815,704 1,739,967 Parks and Recreation Park Maintenance(1090) 700,111: 733,607 680,974; 694,448; Rambling River Center(1093) 190,822 185,054: 231,2311 260,583; Park&Rec Admin(1094) 287,925. 304,383; 326,745 321,093' Recreation Programs(1095) 1 99,718 94,297 102,287; 105,638! Parks and Recreation 1,278,576 1,317,341 1,341,237 1,381,762 Transfers Out 932,207.00. 822,351,00; 1,742,609.00 2,756,609.00' `Transfers Out, X932,207,00 822,351.00 1,742,609.00 2,756,609.00 Total Expenditures 13,642,352 13,832,464 15,870,719 17,489,401: 7/1/2021 8:15:18 AM Page 1 of 1 2022 Proposed Debt Service 2022 Proposed 2022 Proposed 2022 2022 Proposed 2022 2022 Proposed 2022 Proposed Object 2005C(3130)Storm 2019A GD 2020A FIRE 2013A(3091)Rd& Proposed 2016A(3094)Rd Proposed Account Water Trunk Loan Br Fund 2015A(3093) &Br Fund 20166(3136) CAPITAL_IMP EQUIPMENT 2-1-16 BONA CERT .............m.., _.... . 4000-REVENUE AND EXPENDITU 4001 -REVENUES 4011 -CURRENT PROPERTY TA 166,000; 0 335,500; 624,750; 640,000; 231,5251 268,013' Property Taxes 166,000i 0 335,5001 624,750. 640,000; 231,5251 266,013' 4110-SPEC ASSESS CURRENT 0; 276,197: Special Assessments 0! 276,197: 4955-INTEREST ON INVESTM 1001 4,100; 2,200; 5,900; 2,700; 1,100; 800: Investment Income 1001 4,1001 2,200! 5,9001 2,700; 1,1001 800; Total Revenues $166,100 $4,100 .:' $337,700 $906,847.." ..$642,700.,: .` `$232,625..: ;$268,813. 6001 -EXPENDITURES 7110-DEBT PRINCIPAL 520,0001 220,0001 535,0001 525,000: 190,000: 200,000' 7120-DEBT INTEREST 5,2001 49,000: 21,1501 100,825; 25,250; 50,2501 7130-FISCAL AGENT FEES 4,950 ... .. .. .................. ';. 2,950 i 5,915 2,950: 2,9501 2,9501 7140-LEGAL&FISCAL.FEES 1,3001 11200; Debt Service 531,4501 271,950; 563,2651 628,7751 218,200; 253,2001 j Total Exp 531,450' 271,9501 563,265; 628,7751 218,200] 253,2001 7310-OPERATING TRANSFERS 166,000: ' 306,9001 ; 1 Transfers Out 166,000 306,900' Other Financing Sources (166,000); (306,900); Net Change In Fund Balance $100 ($527,350) $65,750 $36,682. $13,925 $14,425 $15,613' Location: DocumentsTARMINGTOMBUdget 2022-2023\Debt Detail for 2021-Updated Teah's Page 1 of 1 CITY OF FARMINGTON 1� Five/Ten Year Financial Plan May 2021 The City of Farmington has been working to improve its financial health over the past decade. This work has produced positive results including meeting the city council General Fund balance goal, obtaining two bond-rating upgrades,the downward trend of the city tax rate since 2013 and the implementation of long and short-range capital improvement plans in a number of areas. This Five/Ten Year Financial Plan is meant to be a framework for the city council to track all of the important financial information in a summary form that city staff is aware of at this point. This is a framework, information will change and nothing in the document should be construed as set in stone until the city council votes on the budget and tax levy each year. The financial goals that this plan is based upon are listed below. These goals change periodically as well. ✓ Maintain our AA+bond rating ✓ Work towards a AAA bond rating ✓ Transition from funding large projects from debt to a combination of debt and cash to eventually all cash ✓ Transition to shorter bond repayment lengths ✓ Balance future tax levy increases to acceptable levels ✓ Work to achieve annual street/trail maintenance/projects funding targets ✓ Purchase all future fire apparatus with cash ✓ Review city council fund balance reserve goal This document is meant to tell a story so the city council,staff and residents can see the big picture of the next five and ten years of city finances. This plan focuses primarily on the General Fund but also includes financial plans and capital improvement plans for our utility funds as well. This document includes a summary of the next five years (2022-2026)which is followed by individual financial plans in a number of areas. City staff does have a ten year plan as well (2027-2031) but thought it is important to focus on the first five years of the plan. A number of important factors are highlighted and explained to show potential future projects and funding changes. The plans and changes are only proposals at this time and should not be considered official until they are approved by the city council. —y— CITYOF FARMINGTON 1� Summary Page and Summary Page with Items of Note CITY OF FARMINGTON _ 5/10 YEAR FINANCIAL PLAN SUMMARY _ 2021 2022 2023 2024 2025 2026 ANNUAL HUMAN RESOURCES COSTS $10,159,442 $10,565,820 $10,988,453 $11,427,991 $11,885,110 $12,360,515 BASE NON-HR COSTS $2,850,671 $2,936,191 $2,965,553 $3,024,864 $3,115,610 $3,209,078 NEW HR COSTS $0 $100,000 $175,000 $175,000 $100,000 $100,000 EXISTING DEBT $3,012,093 $2,275,250 $1,883,250 $1,566,250 $1,440,750 $1,123,250 FUTURE STREET CIP DEBT $0 $297,000 $582,000 $763,000 $888,000 $888,000 FUTURE STREET CIP CASH $0 $0 $0 $0 $0 $0 FUTURE VEHICLE CIP CASH $143,989 $475,000 $550,000 $630,000 $624,000 $680,000 TRANSFER PROJECT-TAX LEVY $572,775 $1,227,022 $1,267,022 $1,262,747 $1,419,725 $1,651,725 TRANSFER PROJECT-LGA $105,587 $105,587 $105,587 $105,587 $105,587 $105,587 PROJECTS-TAX LEVY $0 $0 $0 $0 $0 $0 PROJECTS-DEBT PAYMENTS $0 $0 $252,000 $252,000 $504,000 $504,000 PARK IMPROVEMENT FUND CIP Y $0 $0 $0 $100,000 $100,000 $100,000 TOTAL OPERATING/DEBTEXPENDITURES $16,844,557 $17,981,870 $18,768,865 $19,307,439 $20,182,782 $20,722,155 OTHER REVENUES(1%INCREASE ANNUALLY) $3,298,344 $3,331,327 $3,364,641 $3,398,287 $3,432,270 $3,466,593 FISCAL DISPARITIES $2,277,659 $2,277,659 $2,277,659 $2,277,659 $2,277,659 $2,277,659 TOTAL REVENUES $5,576,003 $5,608,986 $5,642,300 $5,675,946 $5,709,929 $5,744,252 SUMMARY BASE BUDGET LEVY $13,010,113 $13,602,011 $14,129,006 $14,627,855 $15,100,720 $15,669,593 CIP/TRANSFER/LGA LEVY $678,362 $1,332,609 $1,372,609 $1,468,334 $1,625,312 $1,857,312 EXISTING DEBT LEVY $3,012,093 $2,275,250 $1,883,250 $1,566,250 $1,440,750 $1,123,250 FUTURE DEBT LEVY $0 $297,000 $834,000 $1,015,000 $1,392,000 $1,392,000 PAY AS WE GO LEVY $143,989 $475,000 $550,000 $630,000 $624,000 $680,000 TOTAL EXPENDITURES $16,844,557 $17,981,870 $18,768,865 $19,307,439 $20,182,782 $20,722,155 OTHER REVENUES $3,298,344 $3,331,327 $3,364,641 $3,398,287 $3,432,270 $3,466,593 FISCAL DISPARITIES $2,277,659 $2,277,659 $2,277,659 $2,277,659 $2,277,659 $2,277,659 TOTAL REVENUES $5,576,003 $5,608,986 $5,642,300 $5,675,946 $5,709,929 $5,744,252 TOTAL TAX LEVY $11,268,554 $12,372,883 $13,126,565 $13,631,493 $14,472,853 $14,977,903 PROJECTED%CHANGE 4.90% 9.80% 6.09% 3.85% 6.17% 3.49% PROJECTED$CHANGE $526,000 $1,104,329 $753,681 $504,928 $841,361 $505,050 ENDING FUND BALANCE $6,092,605 $6,092,605 $6,092,605 $6,092,605 $6,092,605 $6,092,605 FUND BALANCE AS A%OF ANNUAL EXPENSES 44.51% 40.52% 38.86% 37.68% 36.43% 34.76% 5/11/2021 -3- 2030 Financial Plan Info.xlsx2030 Financial Plan Info.xlsx CITY OF FARMINGTON 5/10 YEAR FINANCIAL PLAN SUMMARY 2021 2022 2023 2024 2025 2026 ANNUAL HUMAN RESOURCES COSTS $10,159,442 $10,565,820 $10,988,453 $11,427,991 $11,885,110 $12,360,515 BASE NON-HR COSTS $2,850,671 $2,936,191 $2,965,553 $3,024,864 $3,115,610 $3,209,078 NEW HR COSTS $0 $100,000 $175,000 $175,000 $100,000 $100,000 EXISTING DEBT $3,012,093 $2,275,250 $1,883,250 $1,566,250 $1,440,750 $1,123,250 FUTURE STREET CIP DEBT $0 $297,000 $582,000 $763,000 $888,000 $888,000 FUTURE STREET CIP CASH $0 $0 $0 $0 $0 $0 FUTURE VEHICLE CIP CASH $143,989 $475,0001 $550,000 $630,000 $624,000 $680,000 TRANSFER PROJECT-TAX LEVY $572,775 $1,227,022 $1,267,022 $1,262,747 $1,419,725 $1,651,725 TRANSFER PROJECT-LGA $105,587 $105,587 $105,587 $105,587 $105,587 $105,587 PROJECTS-TAX LEVY $0 $0 $0 $0 $0 $0 PROJECTS-DEBT PAYMENTS $0 $0 $252,000 $252,000 $504,000 $504,000 PARK IMPROVEMENT FUND CIP $0 $0 $0 $100,000 $100,0004 $100,000 TOTAL OPERATING/DEBT EXPENDITURES $16,844,557 $17,981,870 $18,768,865 $19,307,439 $20,182,782 $20,722,155 OTHER REVENUES(1%INCREASE ANNUALLY) $3,298,344 $3,331,327 $3,364,641 $3,398,287 $3,432,270 $3,466,593 FISCAL DISPARITIES $2,277,659 $2,277,659 $2,277,659 $2,277,659 $2,277,659 $2,277,659 TOTAL REVENUES $5,576,003 $5,608,986 $5,642,300 $5,675,946 $5,709,929 $5,744,252 SUMMARY BASE BUDGET LEVY $13,010,113 $13,602,011 $14,129,006 $14,627,855 $15,100,720 $15,669,593 CIP/TRANSFER/LGA LEVY $678,362 $1,332,609 $1,372,609 $1,468,334 $1,625,312 $1,857,312 EXISTING DEBT LEVY $3,012,093 $2,275,250 $1,883,250 $1,566,250 $1,440,750 $1,123,250 FUTURE DEBT LEVY $0 $297,000 $834,000 $1,015,000 $1,392,000 $1,392,000 PAY AS WE GO LEVY $143,989 $475,000 $550,000 $630,000 $624,000 $680,000 TOTAL EXPENDITURES $16,844,557 $17,981,870 $18,768,865 $19,307,439 $20,182,782 $20,722,155 OTHER REVENUES $3,298,344 $3,331,327 $3,364,641 $3,398,287 $3,432,270 $3,466,593 FISCAL DISPARITIES $2,277,659 $2,277,659 $2,277,659 $2,277,659 $2,277,659 $2,277,659 TOTAL REVENUES $5,576,003 $5,608,986 $5,642,300 $5,675,946 $5,709,929 $5,744,252 I TOTAL TAX LEVY $11,268,554 $12,372,883 $13,126,565 $13,631,493 $14,472,853 $14,977,903 PROJECTED%CHANGE 4.90% 9.80% 6.09% 3.85% 6.17% 3.49% PROJECTED$CHANGE $526,000 $1,104,329 $753,681 $504,928 $841,361 $505,050 ENDING FUND BALANCE $6,092,605 $6,092,605 $6,092,605 $6,092,605 $6,092,605 $6,092,605 FUND BALANCE AS A%OF ANNUAL EXPENSES 44,51% 40.52% 38.86% 37.68% 36.43% 34.76% 5/11/2021 -4- 2030 Financial Plan Info.XISx2030 Financial Plan Info.xlsx Items of Note 1. One of the last major hurdles in our financial planning is a consistent and dedicated funding source for General Fund vehicles. The 2022 budget is the first year we make a concentrated effort to get this line item into the financial plan. The 2022 dollar amount at this point is$475,000. 2. The Transfers Project Tax Levy sees a significant increase in 2022. The main reasons for this increase include a significant increase in pavement management dollars to try to reach the appropriate funding level each year. In addition, 2022 is the first year we start to collect dollars to replace Engine 1 in 2026 paid for with all cash. The other impacts on this area include the transfer of a number of items previously funded through Local Government Aid dollars. In 2021,our LGA funding was reduced by approximately 60%. 3. This item reflects potential debt the city would incur and start to pay back for a potential locker rooms project at Schmitz-Maki Arena. This item is placed in here knowing it may change with a potential parks and recreation related bond referendum in 2022. 4. This item is added as a placeholder to create city council discussion on a dedicated tax levy line item to increase the funding for park improvement projects. The Parks Improvement CIP includes a negative fund balance starting in 2026. 5. This item is added as a placeholder to create city council discussion on a potential city facility related project. I have listed the project as an expansion of the police department at this time as it will likely be a need shortly. Other Plan Assumptions The plan includes a number of other assumptions at this point. A reminder,that these are assumptions and would not be confirmed until a city council vote on future budgets. ✓ The plan includes one new position per year starting in 2022 to cover future staffing needs. The amount of$100,000 is used annual at this point to cover wages, benefits, etc. ✓ A 1% increase in "other revenues" is used to account for increased income from permits, etc. ✓ The amount used for Fiscal Disparities is kept constant at the most recent approved number. In this plan,the amount from the 2021 budget is used for all ten years of the plan. —5— { I ✓ Increased human resources costs in terms of wages, cost of living adjustment and benefit cost increases are assumed in the plan. i 's 2022 Items Summary There are a number of large items affecting 2022. For simplicity,these items are summarized below. 1. First Year Collection for Engine 1 Replacement in 2026-$220,000 2. Increase in Annual Pavement Management Funding-$319,000 3. Increase for Vehicle CIP Cash-$331,000 4. Addition of Bond Payments for 2022 Street Projects-$297,000 i -6- {i 1i 1 CITY QF FARMINGTON ExeistoingDebt This CIP tracks the repayment of existing debt in the General Fund. Any new debt issued is moved to this plan once it is issued. —7— CITY OF FARMINGTON 5/10 YEAR FINANCIAL PLAN EXISTING GENERAL FUND DEBT ROAD AND BRIDGE FUND 2021 2022 2023 2024 2025 2026 2013A(ASH/SPRUCE/HILL DEE) $443,000 2016A(ELM/195TH/WALNUT) $574,327 $624,750 $276,750 $271,750 $181,750 $181,750 TOTAL ROAD AND BRIDGE FUND DEBT $1,017,327 I $624,750 $276,750 $271,750 $181,750 $181,750 NON ROAD AND BRIDGE FUND 2021 2022 2023 2024 2025 2026 2010A(POLICE STATION) $292,253 2005C(FIRE STATION 2) $275,000 $166,000 $166,000 $96,000 $49,000 2016B(CITY HALL) $635,000 $640,000 $638,000 $636,000 $647,500 $648,000 2015A(195TH ST) $293,500 $335,500 $293,500 $293,500 $293,500 $293,500 2019A(WESTVIEW ACRES) $231,000 $240,000 $240,000 2020A(LADDER ONE) $268,013 $269,000 $269,000 $269,000 $269,000 TOTAL NON ROAD AND BRIDGE DEBT $1,994,766 $1,650,500 $1,606,500 $1,294,500 $1,259,000 $941,500 1 1 1 1 1 TOTAL EXISTING DEBT $3,012,093 $2,275,250 $1,883,250 $1,566,250 $1,440,750 $1,123,250 5/11/2021 -8- 2030 Financial Plan Info.xlsx CITY OF FARMINGTON _ 5/10 YEAR FINANCIAL PLAN EXISTING/FUTURE GENERAL FUND DEBT ROAD AND BRIDGE FUND 2021 2022 2023 2024 2025 2026 2013A(ASH/SPRUCE/HILL DEE) $443,000 2016A(ELM/195TH/WALNUT) $574,327 $624,750 $276,750 $271,750 $181,750 $181,750 TOTAL ROAD AND BRIDGE FUND DEBT $1,017,327 $624,750 $276,750 $271,750 $181,750 $181,750 NON ROAD AND BRIDGE FUND 2021 2022 2023 2024 2025 2026 2010A(POLICE STATION) $292,253 2005C(FIRE STATION 2) $275,000 $166,000 $166,000 $96,000 $49,000 20168(CITY HALL) $635,000 $640,000 $638,000 $636,000 $647,500 $648,000 2015A(195TH ST) $293,500 $335,500 $293,500 $293,500 $293,500 $293,500 2019A(WESTVIEW ACRES) $231,000 $240,000 $240,000 2020A(LADDER ONE) $269,000 $269,000 $269,000 $269,000 $269,000 2022 STREET PROJECTS $0 $297,000 $297,000 $297,000 $297,000 $297,000 2023 STREET PROJECTS $0 $0 $285,000 $285,000 $285,000 $285,000 PROJECTS-ARENA LOCKER ROOMS $0 $0 $252,000 $252,000 $252,000 $252,000 2024 STREET PROJECTS $0 $0 $0 $181,000 $181,000 $181,000 2025 STREET PROJECTS $0 $0 $0 $0 $125,000 $125,000 PROJECTS-POLICE DEPARTMENT EXP $0 $0 $0 $0 $252,000 $252,000 TOTAL NON ROAD AND BRIDGE DEBT $1,995,753 $1,947,500 $2,440,500 $2,309,500 $2,651,000 $2,333,500 TOTAL EXISTING DEBT $3,013,080 $2,572,250 $2,717,250 $2,581,250 $2,832,750 $2,515,250 ITALIZED ITEMS ARE ASSUMPTIONS AND HAVE NOT BEEN APPROVED BY THE CITY COUNCIL 5/11/2021 -9- 2030 Financial Plan Info.xlsx 1 CITY QF FARMINGTON Street Projects CIP This CIP tracks upcoming street construction and reconstruction projects over the next five years. E —10— CITY OF FARMINGTON 5/10 YEAR FINANCIAL PLAN STREET PROJECTS CIP STREETS CAPITAL IMPROVEMENT PLAN PROJECT 2021 2022 2023 2024 2025 2026 HWY 3 TRAIL THROUGH LPP $275,000 CR 66/HWY 3 ROUNDABOUT $103,809 HWY 3 TRAILTHROUGH LPP EAST SIDE $216,797 TURN LANES AT 225TH STREET $158,664 9TH STREET BACKAGE ROAD $2,206,222 SPRUCE STREET(RR TRACKS TO DENMARK) $2,189,867 DIVISION STREET $1,013,134 WILLOW/LINOON STREETS $2,627,587 PINE STREET $1,967,833 BACKAGE ROAD,CARVER LANE $896,844 FIRST/OAK STREETS $3,995,670 SIXTH STREET $2,027,630 TOTAL STREET CIP EXPENDITURES $0 $6,584,858 $4,174,055 $4,892,514 $2,027,630 $0 STREET CIP FUNDING/FUND BALANCE 2021 2022 2023 2024 2025 2026 STARTING BALANCE $0 $150,000 $150,000 $150,001 $150,002 $150,003 TOTALANNUAL EXPENDITURES $0 $6,584,858 $4,174,OS5 $4,892,514 $2,027,630 $0 TOTALANNUALTAX LEVY(CASH) $0 $0 $0 $0 $0 $0 BONDED DEBT REVENUE $0 $2,351,841 $2,264,715 $1,429,912 $986,415 $0 WATER FUND CONTRIBUTION $0 $1,146,105 $635,157 $1,053,685 $401,873 $0 STORM WATER FUND CONTRIBUTION $0 1 $741,143 $491,646 $533,313 $292,271 $0 SANITARY SEWER FUND CONTRIBUTION $0 $720,769 $782,538 $760,605 $347,072 $0 TRANSFERS FROM R/8 FUND $0 $0 $0 $0 $0 $1,000,000 MSA CONTRIBUTIONS $0 $1,350,000 $0 $1,115,000 $0 $0 OTHERSOURCES $0 $275,000 $0 $0 $0 $0 YEAR ENDING BALANCE $150,000 $150,000 $150,001 $150,002 $150,003 $1,150,003 FUTURE CIP DEBT REPAYMENTS 2021 2022 2023 2024 2025 2026 2022 PROJECT(10 YEARS) $297,000 $297,000 $297,000 $297,000 $297,000 2023 PROJECTS(10 YEARS) $285,000 $285,000 $285,000 $285,000 2024 PROJECTS(10 YEARS) - $181,000 $181,000 $181,000 2025 PROJECTS(10 YEARS) $125,000 $125,000 TOTAL FUTURE STREET CIP DEBT $0 $297,000 $582,000 $763,000 $888,000 $888,000 ASSUMPTIONS _ DEBT PAID BACK AT 120%OF BOND DEBTTYPICALLY PAID BACK OVER 10 YEARS ANNUAL PAYMENT AT 105% NO STREET PROJECTS IN 2026 WITH WATER METER REPLACEMENT COSTS OCCURING THAT YEAR. 5/11/2021 -1 1- 2030 Financial Plan Info.xlsx CITY©F FARMINGTON Street Magintenance CIP This CIP tracks the planned street maintenance work including sealcoating, crack sealing and mill and overlay projects. —12— STREET MAINTENANCE FUND 5/10 YEAR FINANCIAL PLAN STREET MAINTENANCE CIP 2021 2022 2023 2024 2025 2026 STARTING CASH BALANCE $164,628 $163,396 $140,436 $174,236 $217,271 $280,612 REVENUES $1,009,408 $742,000 $753,200 $767,000 $792,000 $812,000 TAX LEVY $331,208 $650,000 $675,000 $675,000 $700,000 $720,000 OTHER REVENUE $200,000 $0 $0 $0 $0 $0 RETRO TRANSFERS $400,000 $0 $0 $0 $0 $0 MSA $78,200 $92,000 $78,200 $92,000 $92,000 $92,000 TOTAL REVENUES $1,009,408 $742,000 $753,200 $767,000 $792,000 $812,000 EXPENSES CRACK SEALING $35,640 $36,960 $38,280 $39,600 $40,920 $40,920 SEAL COATING/OTHER $75,000 $78,000 $81,120 $84,365 $87,739 $87,739 MILL AND OVERLAY $450,000 $650,000 $600,000 $600,000 $600,000 $600,000 PARKING LOT PROJECTS _ $450,000 $0 $0 $0 $0 $0 TOTALEXPENSES $1,010,640 $764,960 $719,400 $723,965 $728,659 $728,659 ENDING BALANCE $163,396 $140,436 $174,236 $217,271 $280,612 $363,953 IDEAL MAINTENANCE FUNDING PAVEMENT MANAGEMENT $871,000 5/11/2021 -1 3- 2030 Financial Plan Info.xlsx CITY OF FARMINGTON Vehelcles CIP This CIP tracks the purchase/replacement plan for vehicles from General Fund departments. —14— CITY OF FARMINGTON 5/10 YEAR FINANCIAL PLAN GENERAL FUND VEHICLE CIP SUMMARY 2021 2022 2023 2024 2025 2026 COMMUNITY DEVELOPMENT $0 $0 $34,500 $0 $0 $0 ENGINEERING $0 $34,880 $37,950 $0 $0 $0 FIRE $0 $121,550 $126,500 $436,600 $432,350 $117,800 MUNICIPAL SERVICES $225,000 $49,410 $252,450 $153,400 $254,100 $0 NATURAL RESOURCES $0 $39,200 $0 $0 $0 $0 PARKS $0 $340,380 $56,350 $123,900 $0 $167,400 POLICE $143,989 $213,920 $118,785 $105,138 $173,030 $212,040 TOTAL $368,989 $799,340 $626,535 $819,038 $859,480 $497,240 VEHICLE CIP FUNDING/FUND BALANCE 2021 2022 2023 2024 2025 2026 STARTING BALANCE $127,148 $127,148 -$197,192 -$273,727 -$462,765 -$698,245 TOTAL ANNUAL EXPENDITURES $368,989 $799,340 $626,535 $819,038 $859,480 $497,240 TAX LEVY REVENUE $143,989 $475,000 $550,000 $630,000 $624,000 $680,000 USE OF FUND BALANCE $225,000 $0 $0 $0 $0 $0 LGA $0 $0 $0 $0 $0 $0 OTHER REVENUE $0 $0 $0 $0 $0 $0 YEAR ENDING BALANCE $127,148 -$197,192 -$273,727 -$462,765 -$698,245 -$515,485 FUTURE CIP DEBT REPAYMENTS 2021 2022 2023 2024 2025 2026 FUTURE DEBT $0 $0 $0 $0 $0 $0 TOTAL FUTURE CIP DEBT $0 $0 $0 $0 $0 $0 L 2022 PURCHASES TBD TOTAL 5/11/2021 -15- 2030 Financial Plan Info.xlsx CITY OF FARMINGTON _ 5/10 YEAR FINANCIAL PLAN _ VEHICLE CIP SUMMARY CAPITAL EQUIPMENT-OTHER FUNDS 2021 2022 2023 2024 2025 2026 WATER $228,900 $64,400 $0 $0 $78,650 $0 SANITARY SEWER $430,550 $0 $241,500 $230,100 $96,800 $0 STORMWATER $0 $0 $227,700 $247,800 $48,400 $0 SOLID WASTE $0 $0 $478,240 $0 $387,040 $0 FLEET $0 $0 $0 $0 $0 $0 TOTAL $659,450 $64,400 $947,440 $477,900 $610,890 $0 VEHICLE CIP FUNDING/FUND BALANCE 2021 2022 2023 2024 2025 2026 STARTING BALANCE $0 $0 $0 $0 $0 $0 TOTAL ANNUAL EXPENDITURES $659,450 $64,400 $947,440 $477,900 $610,890 $0 WATER REVENUES $228,900 $64,400 $0 $0 $78,650 $0 SANITARY SEWER REVENUES $430,550 $0 $241,500 $230,100 $96,800 $0 STORMWATER REVENUES $0 $0 $227,700 $247,800 $48,400 $0 SOLID WASTE REVENUES $0 $0 $478,240 $0 $387,040 $0 YEAR ENDING BALANCE $0 $0 $0 $0 $0 $0 FUTURE CIP DEBT REPAYMENTS 2021 2022 2023 2024 2025 2026 NONE $0 $0 $0 $0 $0 $0 TOTAL FUTURE CIP DEBT $0 $0 $0 $0 $0 $0 5/11/2021 -16- 2030 Financial Plan Info.xlsx CITY OF FARMINGTON Human Resources I This CIP tracks potential added staff positions needed due to work volumes and increased population. —17— CITY OF FARMINGTON 5/10 YEAR FINANCIAL PLAN _ i NEW POSITIONS CIP POTENTIAL NEW POSITIONS 2021 2022 2023 2024 2025 2026 ADMINISTRATION ASSISTANT CITY ADMINISTRATOR $100,000 PUBLIC WORKS MAINTENANCE WORKER $100,000 FIRE ADMINISTRATIVE SUPPORT $75,000 DUTY CREWS HR/IT IT POSITION $100,000 COMMUNICATIONS SPECIALIST $75,000 PARKS/RECREATION PARK MAINTENANCE $100,000 POLICE PATROL OFFICER $100,000 CSO TOTAL $0 $100,000 $175,000 $175,000 $100,000 $100,000 5/11/2021 —1 $— 2030 Financial Plan Info.xlsx j CITY OF FARMINGTO I N Transfers CIP This CIP tracks specific expenditures that staff or the city council have asked be noted over time. There are two funding sources in this plan, the tax levy and the use of local government aid dollars. —19— CITY OF FARMINGTON 5/10 YEAR FINANCIAL PLAN TRANSFERS CIP TAX LEVY PROJECTS 2021 2022 2023 2024 2025 2026 EDATRANSFER $0 $50,000 $50,000 $50,000 $50,000 $50,000 ENGINE ONE REPLACEMENT(2026) $0 $220,000 $220,000 $220,000 $220,000 $222,000 FIRE ENGINE REPLACEMENT $0 $0 $0 $0 $0 $0 ARENA CAPITAL PROJECTS $0 $20,000 $20,000 $20,000 $20,000 $20,000 POLICE EQUIPMENT CIP $75,000 $110,000 $55,000 $30,725 $30,725 $30,725 FIRE EQUIPMENT CIP $91,545 $25,000 $70,000 $60,000 $80,000 $160,000 PAVEMENT MANAGEMENT $331,208 $650,000 $675,000 $675,000 $700,000 $720,000 TRAIL MAINTENANCE CIP $20,000 $85,000 $100,000 $120,000 $170,000 $200,000 BUILDING MAINTENANCE CIP $42,000 $5,000 $15,000 $25,000 $100,000 $200,000 TOWNSHIP ROAD MAINTENANCE $0 $9,000 $9,000 $9,000 $9,000 $9,000 EMPLOYEE EXPENSE FUND $13,022 $13,022 $13,022 $13,022 $0 $0 PROPERTY/CASUALTY DEDUCTIBLE $0 $20,000 $20,000 $20,000 $20,000 $20,000 COMPENSATED ABSENCES FUND $0 $20,000 $20,000 $20,000 $20,000 $20,000 TOTAL TAX LEVY PROJECTS $572,775 $1,227,022 $1,267,022 $1,262,747 $1,419,725 $1,651,725 LGA PROJECTS 2021 2022 2023 2024 2025 2026 BUILDING MAINTENANCE $15,786 $45,587 $45,587 $45,587 $45,587 $45,587 EDA TRANSFER $40,000 $0 $0 $0 $0 $0 EMERALD ASH BORER $10,825 $10,000 $10,000 $10,000 $10,000 $10,000 TRAIL MAINTENANCE $30,000 $50,000 $50,000 $50,000 $50,000 $50,000 TOWNSHIP ROAD MAINTENANCE $3,000 $0 $0 $0 $0 $0 PROPERTY INSURANCE $5,976 $0 $0 $0 $0 $0 TOTAL LGA PROJECTS $105,587 $105,587 $105,587 $105,587 $105,587 $105,587 TOTAL TRANSFERS PROJECTS $678,362 $1,332,609 $1,372,609 $1,368,334 $1,525,312 $1,757,312 FUNDING TARGETS BUILDING MAINTENANCE $300,000 EMERALD ASH BORER $50,000 TRAIL MAINTENANCE $510,000 PARK IMPROVEMENT FUND $100,000 PAVEMENT MANAGEMENT $810,000 i 7t 5/11/2021 -20- 2030 Financial Plan Info.xlsx CITY OF FARMINGTON , 77 Projeects CIP This CIP tracks potential projects the city may undertake in the future. These larger scale projects may include building and or facility projects. —21— I CITY OF FARMINGTON j 5/10 YEAR FINANCIAL PLAN FUTURE GENERAL FUND PROJECTS CIP 2021 2022 2023 2024 2025 2026 ARENA LOCKER ROOMS $0 $0 $2,000,000 $0 $0 $0 SIDEWALKS $300,000 $0 $0 $0 $0 $0 FUEL STATION $0 $0 $150,000 $0 $0 $0 SALT SHED $0 $0 $250,000 $0 $0 $0 PARKING LOTS $400,000 $0 $0 $0 $0 $0 LIQUOR STORE $0 $0 $0 $0 $0 $0 POLICE DEPARTMENT EXPANSION $0 $0 $0 $0 $2,000,000 $0 TOTAL $700,000 $0 $2,400,000 $0 $2,000,000 $0 REVENUE STARTING BALANCE $0 $0 $0 $0 $0 $0 TOTAL ANNUAL EXPENDITURES $700,000 $0 $2,400,000 $0 $2,000,000 $0 LIQUOR STORE FUNDS $0 $0 $0 $0 $0 $0 TAX LEVY $0 $0 1 $0 $0 $0 $0 DEBT $0 $0 $2,000,000 $0 $2,000,000 $0 OTHER SOURCES $700,000 $0 $400,000 $0 $0 $0 TOTAL REVENUES $700,000 $0 $2,400,000 $0 $2,000,000 $0 YEAR END BALANCE $0 $0 $0 $0 $0 $0 FUTURE CIP DEBT REPAYMENTS 2021 2022 2023 2024 2025 2026 ARENA LOCKER ROOMS(10 YEARS) $252,000 $252,000 $252,000 $252,000 POLICE DEPARTMENT(10 YEARS) $252,000 $252,000 BOND PAYMENTS $0 $0 $252,000 $252,000 $504,000 $504,000 ASSUMPTIONS DEBT PAID BACK AT 120%OF BOND DEBT TYPICALLY PAID BACK OVER 15 YEARS ANNUAL PAYMENT AT 105% 5/11/2021 —22— 2030 Financial Plan Info.xlsx CITY OF FARMINGTON Park Improvement CIP This CIP tracks planned park build outs and improvements to the city's park system. —23— CITY OF FARMINGTON 2030 FINANCIAL PLAN PARK IMPROVEMENT CIP PROJECT 2021 2022 2023 2024 2025 2026 DAKOTA ESTATES PARK DAISY KNOLL PARK DEPOT WAY ARTS PARK r$200,000 EVERGREEN KNOLL PARK FAIR HILLS PARK FARMINGTON PRESERVE PARK FLAGSTAFF MEADOW $7,500 $100,000 HILL DEE PARK HILLVIEW PARK JIM BELL PARK AND PRESERVE $250,000 $250,000 LAKE JULIA PARK MARIGOLD PARK MEADOWVIEW PARK $85,000 MIDDLE CREEK PARK NORTH CREEK PARK PINE KNOLL PARK $7,500 PRAIRIE PINES PARK PRAIRIE VIEW PARK PRAIRIE WATERWAY RAMBLING RIVER PARK $12,000 $150,000 $40,000 $25,000 $50,000 _ SILVER SPRINGS PARK _ $100,000 TAMARACK PARK $95,000 TROY HILL PARK VERMILLION GROVE PARK VRC TOWN SQUARE WESTVIEW ACRES PARK TOTAL $12,000 $157,500 $232,500 $275,000 $145,000 $550,000 FUNDING/FUND BALANCE 2021 2022 2023 2024 2025 2026 STARTING BALANCE $389,974 $486,377 $437,280 $313,340 $238,340 $278,340 ANNUAL PROJECT COSTS $12,000 $157,500 $232,500 $275,000 $145,000 $550,000 TAX LEVY $0 $0 $0 $100,000 $100,000 $100,000 FARM LEASE $8,403 $8,403 $8,560 $0 $0 $0 PARK DEDICATION/PARK DEV FEES $25,000 $25,000 $25,000 $25,000 $10,000 $25,000 LIQUOR STORE FUNDING $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 YEAR END BALANCE $486,377 $437,280 $313,340 $238,340 $278,340 -$71,660 FUNDING TARGETS PARK IMPROVEMENT FUND 5/11/2021 -24- 2030 Financial Plan Info.xlsx FUNDING RESTRICTED _ FLAGSTAFF MEADOW $31,680 JIM BELL $35,116 MYSTIC $106,197 PINE KNOLL $1,596 PRAIRIE VIEW $12,040 _ WESTVIEW $10,892 SAPPHIRE $52,007 TOTAL $249,528 5/11/2021 —25— 2030 Financial Plan Info.xlsx a CITY OF FARMINGTON 0 6 Plans Iint e Transfers CIP This CIP tracks a number of expenditures included in the Transfers CIP including fire equipment, police equipment and building maintenance. —26— CITY OF FARMINGTON 5/10 YEAR FINANCIAL PLAN FIRE EQUIPMENT CIP - - 2021 2022 2023 2024 2025 2026 SOBA $149,800 $0 $0 $0 $0 $0 PORTABLE RADIOS $240,000 $0 $0 $0 $0 $0 RADIO BATTERIES $0 $8,000 $0 $8,000 $0 $0 MOBILE RADIOS $0 $9,750 $9,750 $9,750 $9,750 $0 EXTRACTION TOOLS $0 $0 $40,000 $0 $0 $0 THERMAL IMAGING CAMERA $7,500 $5,000 $0 $0 $7,500 $0 j RAD 57 CO MONITOR $0 $7,000 $0 $0 $8,000 $0 STATION COMPRESSOR $0 $0 $0 $50,000 $0 $0 HOSE $11,000 $7,500 $11,000 $7,500 $9,000 $500 GAS MONITORS $8,000 $0 $9,000 $0 $0 $2,500 TOTAL $416,300 $37,250 $69,750 $75,250 $34,250 $3,000 2021 2022 2023 2024 2025 2026 STARTING BALANCE -$13,817 -$98,572 -$110,822 -$110,572 -$125,822 -$80,072 EXPENDITURES $416,300 $37,250 $69,750 $75,250 $34,250 $3,000 TAX LEVY $91,545 $25,000 $70,000 $60,000 $80,000 $160,000 RETRO TRANSFERS $240,000 $0 $0 $0 $0 $0 ENDING BALALNCE -$98,572 -$110,822 -$110,572 -$125,822 -$80,072 $76,928 5/11/2021 -27- 2030 Financial Plan Info.xlsx CITY OF FARMINGTON 5/10 YEAR FINANCIAL PLAN POLICE EQUIPMENT CIP 20212022 2023 2024 2025 2026 AEDS $9,800 $0 $0 $0 $0 $0 RADIOS $73,901 $73,901 $0 $0 $0 $0 HANDGUNS $0 $0 $0 $0 $0 $0 RIFLES $0 $0 $0 $0 $0 $0 TASERS $0 $0 $0 $0 $22,000 $0 BODY CAMERAS $13,452 $13,452 $13,452 $13,452 $13,452 $13,452 SQUAD CAMERAS $14,706 $14,706 $14,706 $16,188 $16,188 $16,188 GUN CAMERAS $0 $0 $0 $0 $0 $0 THERMAL IMAGING $0 $0 $0 $0 $0 $0 FINGERPRINT MACHINE $18,000 $0 $0 $0 $0 $0 SPEED TRAILER $17,000 $0 $0 $0 $0 $0 TOTAL $146,859 $102,059 $28,158 $29,640 $51,640 $29,640 2021 2022 2023 2024 2025 2026 STARTING BALANCE $73,091 $18,232 $26,173 $53,015 $54,100 $33,185 ANNUAL EXPENDITURES $146,859 $102,059 $28,158 $29,640 $51,640 $29,640 TAX LEVY $75,000 $110,000 $55,000 $30,725 $30,725 $30,725 RETRO TRANSFERS $17,000 $0 $0 $0 $0 $0 ENDING BALANCE $18,232 $26,173 $53,015 $54,100 $33,185 $34,270 5/11/2021 -28- 2030 Financial Plan Info.xlsx CITY OF FARMINGTON 2030 FINANCIAL PLAN _ TRAIL MAINTENANCE CIP REVENUES 2021 2022 2023 2024 2025 2026 TAX LEVY $20,000 $85,000 $100,000 $120,000 $170,000 $200,000 LOCAL GOVERNMENT AID $30,000 $50,000 $50,000 $50,000 $50,000 $50,000 OTHER $0 $0 $0 $0 $0 $0 TOTAL $50,000 $135,000 $150,000 $170,000 $220,000 $250,000 EXPENDITURES 2021 2022 2023 2024 2025 2026 BEGINNING BALALNCE $87,912 $14,752 $25,712 $792 -$5,008 $38,312 FOG SEALING $15,600 $16,200 $16,800 $17,400 $18,000 $18,600 CRACK SEALING $7,560 $7,840 $8,120 $8,400 $8,680 $8,984 PAVEMENT REPLACEMENT $100,000 $100,000 $150,000 $150,000 $150,000 $200,000 RECONSTRUCTION $0 $0 $0 $0 $0 $0 TOTAL EXPENDITURES $123,160 $124,040 $174,920 $175,800 $176,680 $227,584 YEAR END BALANCE $14,752 $25,712 $792 -$5,008 $38,312 $60,728 FUNDING TARGET TRAIL MAINTENANCE TARGET $510,000 5/11/2021 -29- 2030 Financial Plan Info.xlsx CITY OF FARMINGTON 2030 FINANCIAL PLAN BUILDING CIP SCHEDULE SUMMARY BY BUILDING 2021 2022 2023 2024 2025 2026 CITY HALL $7,500 $0 $0 $0 $0 $0 FIRE STATION#1 $0 $0 $0 $0 $0 $0 FIRE STATION#2 $0 1 $0 $0 $0 $0 $0 SCHMITZ-MAKI ARENA $0 $0 $0 $0 -$o $0 FIRST STREET GARAGE $0 $0 $0 $0 $0 $0 MAINTENANCE FACILITY $7,500 $0 $0 $0 $0 $0 POLICE STATION $0 $0 $0 $0 $0 $45,000 RAMBLING RIVER CENTER $0 $0 $0 $0 $0 $0 FEES(7.5%) $0 $0 $0 $0 $0 $0 TOTAL EXPENDITURES $15,000 $0 $0 $0 $0 $45,000 2021 2022 2023 2024 2025 2026 STARTING BALANCE $130,426 $188,212 $238,799 $299,386 $369,973 $515,560 EXPENDITURES $15,000 $0 $0 $0 $0 $45,000 LGA FUNDING $15,786 $45,587 $45,587 $45,587 $45,587 $45,587 RETRO TRANSFERS $15,000 $0 $0 $0 $0 $0 TAX LEVY FUNDING $42,000 $5,000 $15,000 $25,000 $100,000 $200,000 ENDING BALANCE $188,212 $238,799 $299,386 $369,973 $515,560 $716,147 FUNDING TARGET BUILDING MAINTENANCE 2022 PROJECTS PROJECTS BUILDING BALANCE FOR LARGER PROJECTS TOTAL 5/11/2021 -30- 2030 Financial Plan Info.xlsx CITY OF FARMINGTON 1� City Tax Rate History and Dakota County Cities Comparison FARMINGTON CITY TAX RATE BY YEAR 80 ji 70 66,82 65.87 63.09 61.45 60 59.23 58.76 57.16 55.7 54.37 50.97 49.2 48.98 50 - 40 30 20 10 0 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 -32- Dakota County City Tau Rates 80.00 70.00 60.00 v x 50.00 x 40.00 30.00 20.00 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 -APPLE VALLEY 39.86 42.38 44.11 49.21 47.89 45.27 44.72 44.47 42.47 39.58 38.71 38.16 -BURNSVILLE 38.56 42.59 43.21 47.02 46.67 44.79 46.52 46.55 43.55 43.57 43.02 42.69 -EAGAN 30.4 33.67 34.55 38.27 38.25 36.52 37.09 37.38 36.37 35.19 35.54 36.25 -FARMINGTON 49.27 55.73 63.09 66.82 65.87 61.45 59.23 58.76 57.16 54.37 50.97 48.98 -HASTINGS 52.67 55.19 66.08 68.54 66.24 62.58 63.57 62.51 60.86 59.55 57.34 57.25 ---INVER GROVE HEIGHTS 41.75 43.16 44.88 46.31 46.12 48.13 49.26 51.64 51.11 54.61 51.28 50.8 -LAKEVILLE 36.62 38.25 39.05 41.23 40.69 38.94 38.66 37.51 36.41 35.93 34.84 34.52 -MENDOTA HEIGHTS 29.69 31.27 33.46 35.98 34.73 34.96 35.24 38.1 39.64 41.1 40.19 39.21 -ROSEMOUNT 43.35 44.66 46.99 48.86 47.67 45.15 43.14 41.83 40.96 39.66 38.72 36.81 -SOUTH ST.PAUL 41.42 48.37 56.46 63.28 60.9 60.4 64.69 63.85 64.04 65.33 60.89 63.21 -WEST ST.PAUL 50.87 56.07 62.2 69.44 71.24 70.64 69.79 71.41 69.28 72.6 72.01 69.67 ! CITY OF FARMINGTON NEW TAX CAPACITY GROWTH PERCENTAGE 2.50% 2.00% 1.93% 1.50% - 1.47% _ 1.49% 1.30% i 1.21% 1.19% 1.22% c S 1.12% i 1.00% 0.97% - E i '• 0.87% 0.85% s I � 0.57% 0.56% 1 i � 0.50% _ ( I f 0.00% 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Five Year Rolling Average -33- Tax Rates 2021 140 120 1.8 100 .3.2 0,4 16.7 3.2 80 6 23.9 Y Lu 6. 3.8 1.8 � 0.0 0.0 .1.8 Y f0 x f0 ~ 60 - W SCHOOL TAX RATE o COUNTY TAX RATE ❑CITY TAX RATE 26 40 _ 20 0 WZ W H z W Q Q z S O J z CL > J Ln 0 = J E„ F N W z Z ui W W Y to = S W j N J Q g Q m 0 a o 3 0 oc W a o tn W z W. CW uj u C z City —34— r 1 CITY OF FARMINGTON Utellity Funds CIP This CIP tracks the four utility funds. These funds stand on their own and are funded by fees paid by users. —35— CITY OF FARMINGTON -- - ----------- 2030 FINANCIAL PLAN WATER FUND _ FUND 6500 SERVICE DETAILS 2021 2022 2023 2024 2025 2026 POPULATION 24,700 25,100 25,500 25,900 26,300 26,700 AVG DAY PER CAPITA(GALLONS) 80 80 80 80 80 80 CONNECTIONS 7,309 _7,447_ 7,585 7,723 7,861 8,000 NEW HOUSEHOLDS 138 138 138 138 138 138 AMOUNT METERED(GALLONS) 721,240,000 732,920,000 744,600,000 756,280,000 767,960,000 780,000,000 WATER RATES 2021 2022 2023 2024 2025 2026 BASE CHARGE 15 _15.6 16.22 16.87 17.56 18.26 TIER 1 WATER RATE(UNDER 20,000 GALLONS) 1.66 1.73 1.8 1.87 1.94 2.02 TIER 2 WATER RATE(20,000-40,000 GALLONS) 2.49 2.59 2.69 2.8 2.91 3.03 TIER 3 WATER RATE(OVER 40,000 GALLONS) 3.32 3.45 3.59 3.73 3.88 4.04 BASE RATE PERCENT INCREASE 0.00% 4.00% 4.00% 4.00% 4.00% 4.00% VOLUME RATE PERCENT INCREASE 0.00% 4.00% 4.00% 4.00% 4.00% 4.00% REVENUES STARTING FUND BALANCE _ $6,759,543 $7,073,313 $1,410,565 $1,127,893 $517,321 $581,250 ENTERPRISE SALES $2,055,444 $2,156,589 $2,279,832 $2,409,484 $2,545,861 $2,673,154 REVENUE FROM DEBT $0 $2,461,488 $0 $0 $0 $0 TRUNK FUND CONTRIBUTIONS $0 $280,229_ $0 $0 $0 $0 OTHER REVENUES(INTEREST,METERS,ETC.) $0 $0 $0 $0 $0 $0 TOTAL REVENUE $2,055,444 $4,898,306 $2,279,832 $2,409,484 $2,545,861 $2,673,154 EXPENSES OPERATING EXPENSES $853,237 $870,301 $887,707 $905,462 $923,571 $942,042 TRANSFERS OPERATING(PERSONNEL) $444,037 $461,798 $480,270 $499,481 $519,460 $540,238 POTENTIAL HR STAFF ALLOCATION SHIFT $10,000 $10,400 $10,816 $11,249 $11,699 $12,167 CAPITAL IMPROVEMENT PLAN $343,350 $9,125,505 $635,157 $1,053,685 $480,523 $2,246,732 DEBT PAYMENTS_ $91,050 $93,050 $548,554 $550,179 $546,679 $548,054 TOTAL EXPENSES $ 1,741,674 $ 10,561,054 $ 2,562,504 $ 3,020,056 $ 2,481,932 $ 4,289,234 ANNUAL SURPLUS/DEFICIT $313,770 -$5,662,748 -$282,672 -$610,572 $63,929 -$1,616,080 ENDING FUND BALANCE 1 $7,073,313 $1,410,565 $1,127,893 $517,321 $581,250 -$1,034,830 MINIMUM FUND BALANCE GOAL $417,368 $426,075 $890,548 $901,415 $907,437 $921,666 THREE MONTHS OPERATING $324,318 $333,025 $341,994 $351,236 $360,758 $373,612 DEBT PAYMENTS $93,050 $93,050 $548,554 $550,179 $546,679 $548,054 CAPITAL IMPROVEMENT PLAN 2021 2022 2023 2024 2025 2026 ROUTINE MAINTENANCE $87,200 $2,246,732 FLEET $228,900 $64,400 $78,650 SEAL AND ARAN DON $27,250 WATERMAIN REPLACEMENT WITH STREET PROJECT $1,146,105 $635,157 $1,053,685 $401,873 WATER TOWER $7,915,000 TOTAL $343,350 $9,125,505 $635,157 $1,053,685 $480,523 $2,246,732 5/11/2021 -36- 2030 Financial Plan Info.xlsx i ( CITY OF FARMINGTON , 2030 FINANCIAL PLAN SANITARY SEWER FUND FUND 6200 SERVICE DETAILS _ _ 2021 2022 2023 2024 2025 2026 POPULATION 24,700 25,100 25,500_ 25,900 26,300 26,700 AVG DAY PER CAPITA(GALLONS) 0 0 0 0 0 0 RESIDENTIAL CONNECTIONS 7,043 7,181 7,319 7,457 7,595 7,746 COMMERCIAL CONNECTIONS 222 223 225 226 227 230 NEW HOUSEHOLDS _ 138 138 138 138 138 138 AMOUNT METERED(GALLONS) 315,542,500 320,652,500 325,762,500 330,782,500 335,982,500 341,022,238 SANITARY SEWER CHARGES 2021 2022 2023 2024 2025 2026 RESIDENTIAL BASE CHARGE 38.94 40.5 42.11 43.8 45.55 47.37 - - _.-- - RESIDENTIALVOLUMERATE 3.89 4.05 4.21 4.38 4.56 4.74 C_OMMECIAL BASE CHARGE 83.93 87.29 90.78 94.41 98.19 102.11 COMMERICAL VOLUME RATE 4.2 4.36 4.54 4.72 4.91 5.11 BASE RATE PERCENTAGE INCREASE 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% VOLUME RATE PERCENT INCREASE 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% REVENUES STARTING FUND BALANCE $3,175,552 $2,714,978 $1,993,004 $1,148,535 $370,229 $23,743 ENTERPRISE SALES $2,399,462 $2,538,821 $2,685,493 $2,839,838 $3,002,236 $3,173,363 REVENUE FROM DEBT $0 $0 $0 $0 $0 $0 _ TRUNK FUND CONTRIBUTIONS $0 $0 $0 $0 $0 $0 OTHER REVENUES(INTEREST,METERS,ETC.) $25,758 $26,015 $26,275 $26,538 $26,803 ---$26,803 TOTALREVENUE $2,425,220 $2,564,836 $2,711,768 $2,866,376 $3,029,039 $3,200,166 I EXPENSES OPERATING EXPENSES $197,537 $207,414 $217,785 $228,674 $240,107 $252,112 TRANSFERS OPERATING(PERSONNEL) $330,603 $343,827 $357,580 $371,883 $386,759 $402,229 POTENTIAL HR STAFF ALLOCATION SHIFT $116,000_ $120,640 $125,466 $130,484 $135,704 $141,132 MCES FEES $1,661,104 $1,744,160 $1,831,368 $1,922,936 $2,019,083 $2,120,03_7_ CAPITAL IMPROVEMENT PLAN $580,550 $870,769 $1,024,038 $990,705 $593,872 $250,000 DEBT PAYMENTS $0 $0 $0 $0 $0 $0 _ TOTAL EXPENSES $ 2,885,794 $ 3,286,810 $ 3,556,237 $ 3,644,682 $ 3,375,525 $3,165,510 ANNUAL SURPLUS/DEFICIT -$460,574 -$721,974 -$844,469 -$778,306 $346,486 $34,656 ENDING FUND BALANCE $2,714,978 $1,993,004 $1,148,535 $370,229 $23,743 $581399 MINIMUM FUND BALANCE GOAL $1,710,489 $1,796,013 $1,885,514 $1,980,105 $2,079,110 $2,183,065 THREE MONTHS OPERATING $49,384 $51,853 $54,446 $57,168 $60,027 $63,028 MCES PAYMENTS $1,661,104 $1,744,160 $1,831,368 $1,922,936 $2,019,083 $2,120,037 I CAPITAL IMPROVEMENT PLAN 2021 2022 2023 2024 2025 2026 SANITARY SEWER LINING $150,000 $150,000 $150,000 $150,000 SEWER REPLACEMENTS WITH STREET PROJECTS $720,769 $782,538 $760,605 $347,072 $0 FLEET $430,550 $241,500 $230,100 $96,800 $100,000 TOTAL $580,550 $870,769 $1,024,038 $990,705 $593,872 $250,000 2030 Financial Plan Info.xlsx CITY OF FARMINGTON 2030 FINANCIAL PLAN STORMWATER FUND FUND 6400 SERVICE DETAILS 2021 2022 2023 2024 2025 2026 POPULATION 24,700 25,100 25,500 25,900 26,300 26,700 NEW HOUSEHOLDS 138 138 138 138 138 138 SINGLE FAMILY 6,296 6,434 6,572 6,710 6,848 6,945 COMMERCIAL/INDUSTRIAL/MULTI FAMILY REU UNITS 7,882 _ 7,960 8,040 8,120 _8,202 8,284 TOTAL REU'S CITY WAIDE 14,178 14,395 14,612 14,830 15,050 15,276 STORMWATER RATES 2021 2022 2023 2024 2025 2026 QUARTERLY RATES PER REU 21.25 22.1 22.98 23.9 24.86 1 25.85 REVENUES STARTING FUND BALANCE $1,712,781 $1,807,857 $1,176,114 $743,775 $279,071 -$13,897 ENTERPRISE SALES $1,205,120 $1,260,250 $1,330,466 $1,404,360_ $1,482,115 $1,563,631 REVENUE FROM DEBT $0 $0 $0 $0 $0 $0 TRUNK FUND CONTRIBUTIONS $0 $0 $0 $0 $0 $0 OTHER REVENUES(INTEREST,METERS,ETC.) $11,032 $11,474 $11,933 $12,410 $12,906_ $13,035 TOTAL REVENUE $1,216,152 $1,271,724 $1,342,399 $1,416,770 $1,495,021 $1,576,666 EXPENSES -_ ------_-_'_--- _ OPERATING EXPENSES _ $340,500 $357,525 $375,401 $394,171 $413,880 $434,574 TRANSFERS OPERATING(PERSONNEL) $402,576 _$418,679 $435,426 $452,843 _$470,957 $489,795 CAPITAL IMPROVEMENT PLAN $175,000 $916,143 $744,346 $806,113 $665,671 $290,000 POTENTIAL HR STAFF ALLOCATION SHIFT $203,000 _$211,120 $219,565 $228,347 $_237,481 $246,980 TOTAL EXPENSES $ 1,121,076 $ 11903,467 $ 1,774,738 $ 1,881,474 $ 1,787,989 $ 1,461,349 ANNUAL SURPLUS/DEFICIT $95,076 -$631,743 -$432,339 -$464,704 -$292,968 $115,317 ENDING FUND BALANCE $1,807,857 $1,176,114 $743,775 $279,071 -$13,897 $101,420 MINIMUM FUND BALANCE GOAL $135,875 $142,161 $148,741 $155,630 $162,840 $108,643 THREE MONTHS OPERATING $135,875 $142,161 $148,741 $1.55,630 $162,840 $108,643 DEBT PAYMENTS $0 $0 $0 $0 $0 $0 2020 CIP 2021 2022 2023 2024 2025 2026 POND CAPACITY IMPROVEMENTS $150,000 $150,000 $300,000 $215,000 VEGETATION MANAGEMENT $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 STORM SYSTEM IMPROVEMENTS WITH STREET PROJECTS $741,143 $491,646 $533,313 $292,271 $0 FLEET REPLACEMENT $227,700 $247,800 $48,400 $50,000 TOTAL $175,000 $916,143 $744,346 $806,113 $665,671 $290,000 5/12/2021 2030 Financial Plan Info.xlsx CITY OF FARMINGTON 2030 FINANCIAL PLAN SOLID WASTE ENTERPRISE FUND FUND 6300 SERVICE DETAILS,,-- 2021 2022 2023 2024 2025 2026 POPULATION 24,700 25,100 25,500 25,900 26,300 26,700 NEW HOUSEHOLDS 138 138 138 138 138 138 SOLID WASTE GENERATED TONS 8,167 8,310 8,456 8,604 8,754 8,903 ROLLOFF PICKUPS 460 468 476 484 493 497 ROLLOFF TONS DISPOSED 312 317 323 329 334 339 DISPOSAL COSTS$PER TON $128 $132 $136 $140 $145 $149 RATES BY CONTAINER SIZE 30 $62.16 $71.49 $74.35 $77,32 $80.41 $83.63 60 $77.03 $88.58 $92.12 $95.81 $99.64 $103.63 90 $90.54 $104.12 $108.29 $112.62 $117.12 $121.80 120 $108.78 $125.10 $130.11 $135.31 $140.72 $146.35 150 $122.30 $140.64 $146.27 $152.12 $158.20 $164.53 180 $137.16 $157.74 $164.05 $170.61 $177.43 $184.53 210 $153.38 $176.38 $183.44 $190.78 $198.41 $206.35 240 $165.54 $190.37 $197.99 $205.91 $214.14 $222.71 270 $179.05 $205.91 $214.15 $222.71 $231.62 $240.88 300 $217.57 $250.20 $260.21 $270.62 $281.44 $292.70 600 $377.03 $433.58 $450.92 $468.96 $487.72 $507.23 900 $536.49 $616.96 $641.64 $667.30 $693.99 $721.75 1200 $695.95 $800.34 $832.35 $865.64 $900.27 $936.28 1500 $855.40 $983.72 $1,023.03 $1,063.99 $1,106.55 $1,150.81 1800 $1,014.86 $1,167.09 $1,213.78 $1,262.33 $1,312.82 $1,365.33 ROLLOFF PICKUP CHARGE $150.15 $172.67 $179.58 $186.76 1 $194.23 $202.00 DISPOSAL FEE FOR ROLLOFFS,PER TON $128.00 $132.14 $136.28 $140.41 $144.55 $150.33 REVENUES STARTING FUND BALANCE $977,558 $753,418 $383,826 $557,824 $416,049 $738,859 ENTERPRISE SALES $2,581,185 $3,020,065 $3,194,638 $3,378,344 $3,571,636 $3,775,219 COUNTY COMMUNITY FUNDING $30,603 $30,909 $31,218 $31,530 $31,846 $32,164 OTHER REVENUES(INTEREST,PERMITS,ADVERTISING) $10,821 $11,146 $11,480 $11,825 $12,179 $12,544 TOTAL REVENUE $2,622,609 $3,062,120 $3,237,336 $3,421,699 $3,615,661 $3,819,927 EXPENSES OPERATING EXPENSES $905,153 $932,309 $960,277 $989,085 $1,018,758 $1,049,320 TRANSFERS OPERATING(PERSONNEL) $113,563 $116,970 $120,479 $124,093 $127,816 $131,650 POTENTIAL HR STAFF ALLOCATION SHIFT $43,000 $44,290 $45,619 $46,987 $48,397 $49,848 DISPOSAL COSTS(TIPPING FEE) $1,045,401 $1,098,082 $1,152,287 $1,208,053 $1,265,418 $1,324,892 CONTRACT RECYCLING $739,632 $761,821 $784,676 $808,216 $832,462 $857,435 CAPITAL IMPROVEMENT PLAN $0 $478,240 $0 $387,040 $0 TOTAL EXPENSES 2,846,749 $ 3,431,712 $ 3,063,338 $ 3,563,474 $ 3,292,851 $ 3,413,145 ANNUAL SURPLUS/DEFICIT -$224,140 -$369,592 $173,998 -$141,775 $322,810 $406,782 ENDING FUND BALANCE $753,418 $383,826 $557,824 $416,049 $738,859 $1,145,641 MINIMUM FUND BALANCE GOAL $711,687 $738,368 $765,834 $794,109 $823,213 $839,456 THREE MONTHS OPERATING- ---$711o874 $738,368 $765,834 $794,109 $823,213 $839,456 FUND BALANCE 26.47% 11.18%-- 18.21% 11.6896 22.44% 33.57% 2020 CIP 2021 2022 2023 2024 2025 2026 TBD $0 $478,240 $0 $387,040 $0 $0 TOTAL $0 $478,240 $0 $387,040 $0 $0 IRATE INCREASES PER YEAR 5% 15% 4% -4% 4% 4% 5/12/2021 2030 Financial Plan Info.xlsx CITVOF FARMINGTON 00000-'�-,�'mw I ftft%., meow Utility Funds Current and Future Debt CITY OF FARMINGTON_ 2,030 FINANCIAL PLAN DEBT-UTILITY FUNDS EXISTING DEBT WATER FUND 2021 2022 2023 2024 2025 2026 2019A(WATER TOWER REFURBISH) $91,050 $93,050 _ $88,175 $89,800 $86,300 $87,675 TOTAL WATER FUND DEBT $91,050 $93,050 $88,175 $89,800 $86,300 $87,675 TOTAL EXISTING DEBT $91,050 $93,050 $88,175 $89,800 $86,300 $87,675 I +WATER FUND FUTURE DEBT WATER FUND 2021 2022 2023 2024 2025 2026 2022 IFL(NEW WATER TOWER) $0 $0 $271,379 $271,379 $271,379 $271,379 2022 BONDED DEBT(WATER TOWER) $0 $0 $189,000 $189,000 $189,000 $189,000 TOTAL FUTURE DEBT $0 $0 $460,379 $460,379 $460,379 $460,379 TOTAL EXISTING/FUTURE DEBT $91,050 $93,050 $548,554 $550,179 $546,679 $548,054 5/11/2021 -41- 2030 Financial Plan Info.xlsx CITY OF 0 430 Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: David McKnight, City Administrator SUBJECT: Emergency Management and City Council Role(45 Minutes) DATE: July 12, 2021 INTRODUCTION A few of you have asked for a discussion on the city council role when issues arise that require city attention. The work session will be used to discuss how we approach these types of issues. DISCUSSION Chief Rutherford, Chief Elvestad and I will be a part of the discussion with the city council on how we approach issues that require immediate city action. Events like natural disasters,gas leaks, pandemics and more have and will create situations where we need to be prepared. Recent events throughout the country have showed that local governments cannot avoid these types of situations forever. We want to spend some time discussion with you the role of the mayor, city council and city staff when this type of issue occurs in Farmington. No two events are alike,so a broad discussion of how we approach emergency management will be the best use of our discussion time. BUDGET IMPACT NA ACTION REQUESTED Discuss any issues related to the city approach to emergency management.