Loading...
HomeMy WebLinkAbout08.10.20 Work Session Packet CITY OF Meeting Location: FARMINGTONFarmington City Hall 0u 430 Third Street Farmington, MN 55024 CITY COUNCIL WORK SESSION MEETING AGENDA August 10, 2020 6:00 PM 1. CALL TO ORDER 2. APPROVE AGENDA 3. DISCUSSION ITEMS (a) 2021 Draft Budgets (b) Law Enforcement Reform Legislation 4. CITY ADMINISTRATOR UPDATE 5. ADJOURN CITY OF O 43o Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 FarmingtonMN.gov TO: Mayor, Councilmembers and City Administrator FROM: Teah Malecha, Finance Director SUBJECT: 2021 Draft Budgets DATE: August 10, 2020 INTRODUCTION This work session will provide an update on the General Fund budget discussed at your July 13, 2020 work session. The preliminary General Fund budget and tax levy will be adopted at your September 21, 2020 city council meeting. Attached for your review are the summary pages of the 2021 draft General Fund and Debt Service Funds budgets after revisions. Also included are the Special Revenue Funds budgets. DISCUSSION General Fund At the July 13, 2020 work session, staff presented city council with a 12.85 percent levy. It has since been decreased to 6 percent as shown below: 2020 Budget 2021 Proposed Increase Budget Revenues $3,411,161 $3,417,096 0.17% Expenditures 13,642,352 14,086,581 3.26% Fiscal Disparities 2,294,024 2,294,024 0.00% General Fund Levy 7,937,167 8,375,461 5.52% Debt Levy 2,805,387 3,012,093 7.37% Net Tax Levy $10,742,554 $11,387,554 6.00% Most of the changes that were made were done within the transfers budget. The changes that were made to decrease the levy include: • EDA funding was decreased from $70,000 to$40,000. • Fleet replacement has been reduced from $380,000 to$143,989 for police vehicles only. No other vehicle replacements are accounted for. • Sealcoat was reduced $200,000 for the property tax levy. That amount will come from liquor store proceeds. • The extension of 202nd Street into Farmington from Lakeville at the north end of Farmington High School was removed resulting in a $200,000 decrease to the property tax levy. • Trail maintenance was decreased from $80,000 to $50,000. • A portion of the franchise fee revenue that is transferred to the General Fund has been increased $25,000 to$145,000 for 2021. • The building permit revenue has been increased $14,763. The General Fund budget summary and operating transfers are included for your review. Debt Service Funds Levy The Debt Service Fund budget provides funding for scheduled debt principle and interest repayment obligations, as well as ongoing trustee, assessments, arbitrage, and post-issuance compliance fees related to the city's debt. The 2021 debt levy is $206,706 higher than 2020. Ladder One accounts for $268,013 of the debt levy. The Ladder One costs are new expenditures for the 2021 budget. The city's debt shows a decline starting in 2022 in the Financial Plan attached. Special Revenue Funds EDA Fund -The EDA fund includes the Dakota Broadband Board's Executive Director expenses and reimbursements which net zero. This results in no change to the overall EDA Fund. Park Improvement Fund -The Park Improvement Fund's purpose is to invest and reinvest into the Farmington park system. The main source of funding for this budget has been park dedication fees that come with development and liquor store proceeds. The 2021 budget includes $25,000 in park development fees and $75,000 in liquor store profits along with rental income of$8,400 and investment income of$2,800. The budget includes resurfacing the tennis courts at Rambling River Park for$15,000. 1 ce Arena Fund -The I ce Arena Fund's budget has been similar year-to-year. The conservative budget has the arena producing a minimal gain at the end of the year. There is a proposed increase of fees included in the budget. Any increased usage or reduction in spending will result in better financial performance. The preliminary General Fund budget and tax levy will be adopted at your September 21, 2020 city council meeting. Once the preliminary levy is adopted it can be decreased, but it cannot be increased. BUDGET IMPACT All information is related to the development of the 2021 city budget and tax levy. ACTION REQUESTED Discuss the preliminary tax levy and ask questions of the proposed budgets. Provide staff with direction on any needed revisions. ATTACHMENTS: Type Description ❑ Backup Material 2021 General Fund Budget Summary ❑ Backup Material 2021 General Fund Budget Revenues ❑ Backup Material 2021 General Fund Budget Expenditures ❑ Backup Material 2021 Operating Transfers ❑ Backup Material 2021 Debt Service Funds ❑ Backup Material 2021 Special Revenue Funds Summary Budget ❑ Backup Material 2021 EDA Fund Budget ❑ Backup Material 2021 Park Improvement Fund Budget ❑ Backup Material 2021 Ice Arena Fund Budget Backup Material Financial Plan City of Farmington Budget and Tax Levy 2020 Budget, 2021 Proposed and 2022 Proposed Company 2020 2021 Budget% 2022 Budget o/o Budget Proposed Change Proposed Change Non-Property Tax Revenues Licenses and Permits 473,115 446,773 (5.57)% 453,600 1.53% Intergovernmental Revenue 922,294 886,967 (3.83)% 886,967 0.00% Charge for Service 565,802 576,197 1.84% 589,285 2.27% Fines and Forfeitures 49,000 49,000 0.00% 49,000 0.00% Investment Income 38,800 24,100 (37.89)% 15,400 (36.10)% Miscellaneous 54,580 79,370 45.42% 53,170 (33.01)% Transfers In 1,307,570 1,354,689 3.60% 1,408,874 4.00% Total Revenues 3,411,161 3,417,096 0.17% 3,456,296 1.15% Expenditures Administration 907,162 887,182 (2.20)% 1,087,554 22.59% Human Resource 349,226 366,149 4.85% 391,562 6.94% Dakota Broadband 24,489 37,500 53.13% 40,500 8.00% Finance and Risk Mgmt 778,889 795,346 2.11% 827,793 4.08% Police 4,677,813 4,927,801 5.34% 5,321,877 8.00% Fire 1,445,410 1,470,719 1.75% 1,573,473 6.99% Community Development 1,014,867 1,036,599 2.14% 1,104,537 6.55% Engineering 794,635 841,247 5.87% 889,172 5.70% Municipal Services 1,439,078 1,541,843 7.14% 1,630,813 5.77% Parks and Recreation 1,278,576 1,320,648 3.29% 1,454,246 10.12% Transfers Out 932,207 861,547 (7.58)% 3,381,534 292.50% Total Expenditures 13,642,352 14,086,581 3.26% 17,703,061 25.67% Revenues Over(Under)Expenditures (10,231,191) (10,669,485) 4.28% (14,246,765) 33.53% Fiscal Disparities 2,294,024 2,294,024 0.00% 2,294,024 0.00% General Fund Levy 7,937,167 8,375,461 5.52% 11,952,741 42.71% Debt Levy Bonds 2,222,950 2,444,840 9.98% 2,099,788 (14.11)% 2005C Loan Repay-Storm Water Tr Adv 166,000 275,000 65.66% 166,000 (39.64)% 2010A Loan Repay-Storm Water Tr Adv 400,000 292,253 (26.94)% 0 (100.00)%' 2010D Loan Repay-Storm Water Tr Adv 16,437 0 (100.00)% Total Debt Levy 2,805,387 3,012,093 7.37% 2,265,788 (24.78)% Use of Fund Balance to Lower Debt Levy 0 Net Debt Levy 2,805,387 3,012,093 7.37% 2,265,788 (24.78)% Farmington Net Tax Levy 10,742,554 11,387,554 6.00%' 14,218,529' 24.86% General Fund Detailed Non-Property Tax Revenue Summary 2019 Budget,2020 Budget, 2021 Proposed and 2022 Proposed Object 2019 2020 2021 2022 Account Budget Budget Proposed Proposed LIQUOR LICENSES 42,000 41,700 40,000 37,000 BEER&WINE LICENSES 1,750 1,100 1,100 850 CLUB LICENSES 500 500 500 500 MASSAGE LICENSE 150 350 300 100 GAMBLING LICENSE/PERMIT 250 450 250 250 OTHER LICENSE&PERMIT 1,700 1,900 1,700 1,500 ANIMAL LICENSES 4,000 4,080 2,500 3,000 Licenses 50,350 50,080 46,350 43,200 BUILDING PERMITS 272,400 330,000 314,573 325,000 REINSPECTION FEES 1,000 1,000 1,500 1,000 CODE ENFORCEMENT FEES 1,000 2,600 1,500 1,500 PLUMBING&HEATING PERMITS 35,000 52,500 50,000 50,000 SEWER PERMITS 5,000 5,000 0 0 ELECTRIC PERMITS 18,000 16,000 16,000 16,000 ISTS PERMITS 250 300 300 300 UTILITY PERMITS 6,130 6,420 7,500 7,500 SIGN PERMITS 570 790 800 800 BURNING PERMITS 1,710 1,425 1,250 1,300 OTHER PERMITS 5,000 7,000 7,000 7,000 Permits 346,060 423,035 400,423 410,400 Licenses and Permits 396,410 473,115 446,773 453,600 FEDERAL GRANT 0 5,000 5,000 5,000 LOCAL GOVERNMENT AID 314,725 328,374 328,967 328,967 MSA MAINTENANCE 215,000 215,000 184,000 184,000 POLICE AID 196,000 198,500 198,000 198,000 POST TRAINING 15,160 15,160 15,160 15,160 FIRE AID 137,910 137,910 142,490 142,490 STATE GRANT 0 9,000 MARKET VALUE CREDIT 0 0 COUNTY MISCELLANEOUS 13,470 13,350 13,350 13,350 Intergovernmental 892,265 922,294 886,967 886,967 CUSTOMER SERVICE TAXABLE CUSTOMER SERVICES NONTAXABLE 250 200 210 210 ZONING&SUBDIVISION FEES 2,000 3,050 2,600 2,600 ADMINISTRATION FEES-PROJECTS 4,000 4,500 4,000 4,000 FIRE CHARGES 225,780 237,172 239,227 260,940 POLICE SERVICE CHARGES 77,000 78,030 78,810 80,385 ENGINEERING FEES-PROJECTS EROSION&SEDIMENT CONTROL 9,900 8,100 8,100 8,100 RECREATION FEES-GENERAL 90,000 85,000 75,000 85,000 RECREATION FEES-SENIOR CTR 18,000 19,000 15,000 18,000 MEMBERSHIP FEES-SENIOR CTR 9,000 8,000 6,000 7,500 MOBILE MEALS-SENIOR CTR ADVERTISING 750 950 750 750' ADVERTISING 2,200 1,800 1,500 1,800 FRANCHISE FEE 120,000 120,000 145,000 120,000 Charges For Services 558,880 565,802 576,197 589,285 COURT FINES 42,000 49,000 49,000 49,000 CODE VIOLATIONS&ADMIN FINES 0 0 Paae 1 of General Fund Detailed Non-Property Tax Revenue Summary 2019 Budget, 2020 Budget, 2021 Proposed and 2022 Proposed Object 2019 2020 2021 2022 Account Budget Budget Proposed Proposed Fines&Forfeitures 42,000 49,000 49,000 49,000 INTEREST ON INVESTMENTS 21,900 38,80024,100 15,400 GAIN/LOSS INVEST MKT VALUE Investment Income 21,900 38,800 24,100 15,400 MISCELLANEOUS REVENUE 5,000 1,500 31,700 1,500 CASH OVER&SHORT RENTAL INCOME-RRC 22,000 20,880 18,000 20,000 RENTAL INCOME 16,775 31,700 29,670 31,670 DONATIONS 0 500 DAKOTA BROADBAND HUMAN RESOURCE 0 Misc Revenue 43,775 54,580 79,370 53,170 OPERATING TRANSFERS 1,244,256 1,307,570 1,354,689 1,408,874 Transfers in 1,244,256 1,307,570 1,354,689 1,408,874 Total Revenues $3,199,486 $3,411,161 $3,417,096 $3,456,296 Pape 2 of General Fund Expenditure Detail Summary 2019 Budget,2020 Budget 2021 Proposed and 2022 Proposed Company 2019 2020 2021 2022 Budget Budget Proposed Proposed Expenditures Administration Legislative(1005) 96,447 87,772 89,494 89,642 Administration(1010) 295,214 302,068 312,964 454,221 Elections(1013) 35,867 44,124 10,351 47,454 Communications(1014) 99,650 108,537 116,850 124,057 City Hall(1015) 354,144 364,661 357,523 372,180 Administration 881,322 907,162 887,182 1,087,554 Human Resources 336,447 349,226 366,149 391,562 Human Resource(1011) 336,447 349,226 366,149 391,562 Human Resources 336,447 349,226 366,149 391,562 Dakota Broadband 24,489 37,500 40,500 Dakota Broadband 24,489 37,500 40,500 Dakota Broadband 24,489 37,500 40,500 Finance and Risk Management Finance(1021) 569,926 609,079 622,156 651,953 Risk Management(1022) 169,810 169,810 173,190 175,840 Finance and Risk Management 739,736 778,889 795,346 827,793 Police Police Administration(1050) 873,339 1,235,377 1,304,537 1,426,510 Patrol Services(1051) 2,738,524 2,538,727 2,669,898 2,880,295 Investigations(1052) 856,544 892,059 936,766 998,472 Emergency Management(1054) 11,650 11,650 16,600 16,600 Police 4,480,057 4,677,813 4,927,801 5,321,877 Fire Fire(1060) 1,267,885 1,445,410 1,470,719 1,573,473 Fire 1,267,885 1,445,410 1,470,719 1,573,473 Community Development 908,890 1,014,867 1,036,599 1,104,537 Planning(1030) 521,062 591,133 589,031 629,388 Building Inspection(1031) 387,828 423,734 447,568 475,149 Community Development 908,890 1,014,867 1,036,599 1,104,537 Engineering Engineering(1070) 624,587 665,173 706,708 749,555 Natural Resources(1076) 122,583 129,462 134,539 139,617 Engineering 747,170 794,635 841,247 889,172 Municipal Services Streets(1072) 1,146,492 1,197,200 1,289,488 1,367,910' Snow Removal(1073) 227,064 241,878 252,355 262,903 Municipal Services 1,373,556 1,439,078 1,541,843 1,630,813 Parks and Recreation Park Maintenance(1090) 671,357 700,111 733,720 780,897 Rambling River Center(1093) 182,287 190,822 186,911 218,149 Park&Rec Admin(1094) 271,145 287,925 305,720 347,473 Recreation Programs(1095) 106,804 99,718 94,297 107,727 Parks and Recreation 1,231,593 1,278,576 1,320,648 1,454,246 Transfers Out 1,041,138.00 932,207.00 861,547.00 3,381,534.00 Transfers Out 1,041,138.00 932,207.00 861,547.00 3,381,53470 Total Expenditures 13,007,794 13,642,352 14,086,581 17,703,061 B C D E F H M N F7 O P Q R S T U 1 2021 OPERATING TRANSFERS 2 TRANSFERS IN (5205) General Capital General General General Equipment Capital Capital Storm Capital Fund Equip Fund Equip Fund General Water Arena Cap Equip Fund (Police (Police (Fire 3 Fund EDA Park Imp Trunk Pro'Fd Vehicles Vehicles) Equi Equi Sealcoat Street Main Trail Mair 51 Fund 1000 2000 2300 4400 4503 5600 5600.5 - 5600.5 5600.6 5701 5711 5721 6 388,591 1000 Tax Levy 1,024 75,000 91,545 175,000 20,00( 7 328,967 1000LGA 40,000 8,976 156,208 30,00( 8 _ 1000 Future Street CIP Debt 9 _ 1000 Future Street CIP Cash 10 143,989 1000 Future Vehicle CIP Cash 143,989 11 - 1000 Projects CIP Cash _ 12 _ 1000 Projects CIP Debt _ 13 - 2000 EDA 14 r - 2500 Arena 15 ti 6,900 3094-2016A 6,900 16 292,253 3097-2010A 292,253 17 _ 3099-2011A 18 O 275,000 3130-2005C 275,000 19 3136-2016B 20 W _ 3137-2016C 21 IL _ 3300-2010D 22 Z - 3139-2020A 23 340,410 6100 Admin(GF) 63,910 75,000 200,000 - 24 89,411 6202 Admin(GF) 86,911 25 243,692 6202 HR 236,880 26 87,411 6302 Admin(GF) 86,911 27 61,848 6302 HR 61,848 28 86,911 6402 Admin(GF) 86,911 29 315,665 6402 HR 308,853 30 86,911 6502 Admin(GF) 86,911 31 357,126 6502 HR 335,554 32 3,105,085 1,354,689 40,000 75,000 574,153 10,000 - 143,989 75,000 91,545 531,208 - 50,00( 33 310,534 34 - - - - - - - - - - Cell:F6 Comment:Teah Malecha: Reduced$10k 7/13/2020 Cell:S6 Comment:Teah Malecha: Reduced$400k 6/30/2020,moved$200k to liquor proceeds 7/13/20 Cell:U6 Comment:Teah Malecha: Reduced$40k 6/30/2020,reduced$30k 8/4/2020 Cell:Z6 Comment:Teah Malecha: Employer portion of T Daus's insurance premium Cell:AA6 Comment:Teah Malecha: Budgeted transfer for insurance deductible. Reduced by$10k 6/30/2020 Cell:F7 Comment:Teah Malecha: Reduced$20k 7/13/2020 Cell:W7 Comment:Teah Malecha: Reduced$60k to$82,958 6/30/2020 Cell:T8 Comment:Teah Malecha: debt payment for backage road-Moved$126k to 2022 Cell:T9 Comment:Teah Malecha: moved$350k to 2022,update to$300k per David 6/17/2020 202nd St.Move$100k to liquor store proceeds 6/30/2020,removed$200k per council 7/13 Cell:010 Comment:Teah Malecha: Reduced$100k 6/30/2020.Reduced to PD only per 4/20 CIP 8/4/2020 Cell:T11 Comment:Teah Malecha: Sidewalks-reduced to$100k_Moved to liquor store proceeds 6/30/2020 Cell:N12 Comment:Teah Malecha: Arena Phase 2-moved$252k to 2022 Cell:M15 Comment:Teah Malecha: 2016A interest pymt for interfund loan,attributed to 2010C,but to minimize special assessment prepayment risk for 2016A bonds Cell:M16 Comment:Teah Malecha: Represents annual debt service for 2010A which is used to repay Storm Water Trunk interfund loan. Actually doesn't flow through operating transfers,but is shown that way for budget purposes.Final pmt 2021 Budgeted transfer for insurance deductible-Insurance Deductible Spreadsheet Cell:E24 Comment:Teah Malecha: Approx 4%increase rounded to be evenly divided by 12(i.e.monthly transfers) Cell:AA24 Comment:Teah Malecha: Budgeted transfer for insurance deductible-Insurance Deductible Spreadsheet Cell:E25 Comment:Teah Malecha: Amounts per worksheet in @H Drive-Budget 2021 Updated 2020 Salary Distribution Cell:Y25 Comment:Teah Malecha: Amounts per worksheet in @H Drive-Budget 2021 Updated 2020 Salary Distribution Cell:E26 Comment:Teah Malecha: Approx 4%increase rounded to be evenly divided by 12(i.e.monthly transfers) Cell:AA26 Comment:Teah Malecha: Budgeted transfer for insurance deductible-Insurance Deductible Spreadsheet Cell:E27 Comment:Teah Malecha: Amounts per worksheet in @H Drive-Budget 2021 Updated 2020 Salary Distribution Cell:E28 Comment:Teah Malecha: Approx 4%increase rounded to be evenly divided by 12(i.e.monthly transfers) Cell:E29 Comment:Teah Malecha: Amounts per worksheet in @H Drive-Budget 2021 Updated 2020 Salary Distribution Cell:Y29 Comment:Teah Malecha: Amounts per worksheet in @H Drive-Budget 2021 Updated 2020 Salary Distribution Cell:E30 Comment:Teah Malecha: Approx 4%increase rounded to be evenly divided by 12(i.e.monthly transfers) Cell:E31 Comment:Teah Malecha: Amounts per worksheet in @H Drive-Budget 2021 Updated 2020 Salary Distribution Cell:Y31 Comment:Teah Malecha: Amounts per worksheet in @H Drive-Budget 2021 Updated 2020 Salary Distribution 2021 Proposed Debt Service Object Fire Station 2 Police Station Refunding Ash St., Refunding of ElmSpruce St.,&Hill 195th Street St.,195th St.,8 City Hall&First St Westview Area Ladder One Account Dee Walnut St Garage 4000-REVENUE AND EXPENDITU 4001 -REVENUES 4011 -CURRENT PROPERTY TA 275,000 292,253 443,000 293,500 574,327 635,000 231,000 268,013 Property Taxes 275,000 292,253 443,000 293,500 574,327 635,000 231,000 268,013 4110-SPEC ASSESS CURRENT 58,926 286,149 Special Assessments 58,926 286,149 4955-INTEREST ON INVESTM 3,100 1,400 5,300 300 500 Investment Income 3,100 1,400 5,300 300 500 Total Revenues $275,000 $292,253 $505,026 $294,900 $865,776 $635,300 $231,500 $268,013 6001 -EXPENDITURES 7110-DEBT PRINCIPAL 720,000 210,000 540,000 505,000 180,000 7120-DEBT INTEREST 17,600 55,450 31,900 116,275 34,500 80,113 7130-FISCAL AGENT FEES 2,950 2,950 5,915 2,950 2,950 2,950 7140-LEGAL&FISCAL FEES 1,100 1,100 Debt Service 741,650 268,400 578,915 624,225 217,450 83,063 Total Exp 741,650 268,400 578,915 624,225 217,450 83,063 7310-OPERATING TRANSFERS 275,000 292,253 6,900 Transfers Out 275,000 292,253 6,900 Other Financing Sources (275,000) (292,253) (6,900) Net Change in Fund Balance $0 $0 ($236,624) $26,500 $279,961 $11,075 $14,050 $184,950 Special Revenue Funds Budget Summary 2019 Actual, 2020 Budget, 2021 Proposed and 2022 Proposed Company 2019 2020 2021 2022 Actual Budget Proposed Proposed Revenues EDA(2000) 75,832 165,611 182,574 194,196 TIF-Trident(2054) 147,996 146,410 146,310 Police Donations&Forfeitures(2100) 4,063 1,300 3,050 3,000 Park Improvement Fund(2300) 84,188 36,745 36,200 35,200 Ice Arena(2500) 367,717 368,200 380,000 384,900 Total Revenues 679,795 571,856 748,234 763,606 Expenditures EDA(2000) 130,270 201,641 219,851 231,559 TIF-Trident(2054) 132,995 2,850 134,439 134,439 Police Donations&Forfeitures(2100) 1,790 3,100 2,000 2,000 Park Improvement Fund(2300) 328,100 39,000 15,000 160,000 Ice Arena(2500) 380,836 368,200 379,981 395,725 Total Expenditures 973,991 614,791 751,271 923,723 Transfers Transfers In 127,850 115,000 115,000 116,085 Transfers Out (12,639) 0 Total Transfers 115,211 115,000 115,000 116,085 Change in Fund Balance (178,984) 72,065 111,963 (44,032) Busineca Object Subsi Actual Actual Actual Actual Budget Proposed Pro Company Unit Account diary Subledger Line Item Detail 2017 2018 2019 2020 2020 2021 2021 Proposed Budget Comments 2022 2022 2022 Proposed Budget Comments IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 1010-CASH (11,069) (11,069) (11,069)• (11,069) IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 1010-CASH A.00009 308,405 277,521. 208,155 210,773 IRAIECONOMI 2000-HRAIECONOMIC DEVELOPMEN 1010-CASH 04 35,000 35,000 35,000 35,000 IRAIECONOMI 2000-HRAIECONOMIC DEVELOPMEN 1011-PREMIUM/DISCOUNT ON 1 (186) (181) (38) 0 IRA/ECONOMI 2000-HRAIECONOMIC DEVELOPMEN 1095-ACCRUED INTEREST INVE 846 636 566 0 IRAIECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 1305-ACCOUNTS RECEIVABLE 0 0 0 43,539 IRAIECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 1305-ACCOUNTS RECEIVABLE 1 0 0 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 1315-LOANS RECEIVABLE 0 0 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 1345-DUE FROM OTHER FUNDS 0 0 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 1346-INTERFUND LOANS RECEI 0 0 0 0 IRAIECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 1351-DUE FROM FEDERAL 0 0 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 1353-DUE FROM COUNTY 0 0 65,398 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 1505-PREPAID EXPENSES 595 595 300 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 2010-ACCOUNTS PAYABLE 0 0 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 2010-ACCOUNTS PAYABLE 1 (21,887) (3,140) (6,238). 0 IRA/ECONOMI .2000-HRA/ECONOMIC DEVELOPMEN 2205-DEFERRED REVENUE 0 0 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 2255-DEPOSITS PAYABLE 0 0 0 0 IRAIECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 2310-INTERFUND LOANS PAYAB 0 0 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 2415-MN SALES TAX DUE 0 0 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 3510-UNRESERVED FUND BALA (340,219) (311,703) (299,362) (292,074) IRAIECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 4011-CURRENT PROPERTY TAX 0 0 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 4020-TAX INCREMENT EXCESS 0 0 0 0 IRAIECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 4404-FEDERAL GRANT (10,225) (21,809) 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 4460-COUNTY MISCELLANEOUS 0 0 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 4516-ADMINISTRATION FEES- 0 0 0 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 4955-INTEREST ON INVESTMEN (4,046) (5,242). (6,661) (2,644) (2,700) (2,100)TM 4-29-2020 (1,400)TM 4-29-2020 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 4960-GAINILOSS INVEST MKT VA 888 1,054 (3,773) 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 4975-RENTAL INCOME 0 0 0 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 5005-LAND SALES 0 0 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 5010-SALES OF ASSETS 0 0. 0 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 5205-OPERATING TRANSFERS (40,000) (30,000) (50,000) (23,333) (40,000) (40,000)See Operating Transfers spreadsheet (41,085)Per Operating Transfers spreadsheet in in Finance/Operating Transfers By Finance/Operating Transfers By Year Year folder folder IRAIECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 5350-MISCELLANEOUS REVENU 0 0 0 0 0 IRA/ECONOMI 2000-HRAIECONOMIC DEVELOPMEN 5360-REFUNDS&REIMBURSEM 20 (65,398) (78,959) (162,911) (180,474)DBB Reimbursement for CK TM (192,796)DBB Reimbursement for CK TM 5-22-2020 5-22-2020 IRAIECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6110-FULL TIME SALARIES 50,129 68,114 122,761 129,430 JG 5/15/2020 136,512 JG 5/15/2020 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6110-FULL TIME SALARIES S.00019 115 IRAIECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6152-FICA/MEDICARE 3,644 4,946 9,392 10,030 JG 5/15/2020 10,579 JG 5/15/2020 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6152-FICAIMEDICARE S.00019 8 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6154-PERA 3,760 5,108 9,208 9,707 JG 5/15/2020 10,638 JG 5/15/2020 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6154-PERA S.00019 9 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6158-EMPLOYEE BENEFITS 7,866. 10,913 21,550 23,705 JG 06/03/2020 27,260 JG 06/032020 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6159-WORKERS COMP 106 790 TM 5-22-2020 833 TM 5.22-2020 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6210-OFFICE SUPPLIES 0 0 0 0 IRAIECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6220-EQUIP SUPPLIES&PARTS 0 0 0 0 IRAIECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6250-OTHER SUPPLIES&PARTS 0 0 0 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6280-BOOKS&SUBSCRIPTIONS 85 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6280-BOOKS&SUBSCRIPTIONS 20 64 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6401-PROFESSIONAL SERVICES 1,369 12,116 9,513 495 12,000 11,650 Downtown/Hwy 3 implementation+ 11,650 Downtown/Hwy 3 implementation+ Board/Commission stipends($1,650) Board/Commission stipends($1,650) IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6401-PROFESSIONAL SERVICES S.10001 1,897 0 0 IRA/ECONOMI 2000-HRAIECONOMIC DEVELOPMEN 6403-LEGAL 4,548 911 853 0 2,500 2,000 2,000 Company Buslnesa Object Subsi Subledger Line item Detail Actual Actual Actuei Actual Budget Proposed 2021 Proposed Budget Comments Proposed 2022 Proposed Budget Comments Unit Account diary 2017 2010 2019 2020 2020 2021 2022 IRAIECONOMI 2000-HRAIECONOMIC DEVELOPMEN 6404-IT SERVICES 8,075 8,297 8,317 5,114 8,767 9,474 This line item is for the chargeback of 9,522 This line item is for the chargeback of each area's share of internal IT each area's share of internal IT charges. charges.531-2020 TM 5-31-2020 TM IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6412-CELLULAR SERVICES 20 298 540 DBB TM 522-2020 540 DBB TM 5.22-2020 IRAIECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6421-MUNICIPAL SERVICES 0 0 0 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6422-ELECTRIC 244 240 2081 143 300 300 EDA sign 300:EDA sign IRA/ECONOMI 2000-HRAIECONOMIC DEVELOPMEN 6423-NATURAL GAS 0 0." 0 0 0 IRA/ECONOMI 2000-HRAIECONOMIC DEVELOPMEN 6426-INSURANCE 121 153 143 71 130 130 This is for property and liability 130 This is for property and liability insurance premiums.Offset is insurance premiums.Offset is 7100.5360 7100.5360 TM 5-22-2020 TM 5-22-2020 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6445-POSTAGE 0 0 0 0 IRAIECONOMI 2000-HRAIECONOMIC DEVELOPMEN 6450-OUTSIDE PRINTING 0 0 0 0 500 500 BR&E cards and collateral 500 BR&E cards and collateral IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6455-LEGAL NOTICES 22 0 0 0 IRAIECONOMI 2000-HRAIECONOMIC DEVELOPMEN 6460-MEMBER DUES&LICENSU 1,153 1,095 1,820 795 2,000 2,000 Staff dues 2,000 Staff dues IRA/ECONOMI 2000-HRAIECONOMIC DEVELOPMEN 6470-TRAINING&SUBSISTANCE 1,734 1,982 2,898 1,752 4,000 3,500 Training and conferences 3,000 Training and conferences IRA/ECONOMI 2000-HRAIECONOMIC DEVELOPMEN 6470-TRAINING&SUBSISTANCE 20 320 5,000 DBB Per CK TM 5-22-2020 5,000 DBB Per CK TM 5-22-2020 IRA/ECONOMI 2000-HRAIECONOMIC DEVELOPMEN 6485-MILEAGE REWBURSEMEN 1,086 243 391. 21 800 400 400 IRA/ECONOMI 2000-HRAIECONOMIC DEVELOPMEN 6492-ADVERTISING 0 0 0 0 0 2,500 2,500 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6505-EQUIPMENT REPAIRIMAIN 0 0 0 0 0 IRAIECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6505-EQUIPMENT REPAIR/MAIN 20 231 195 DBB Adobe TM 5.22-2020 195 DBB Adobe 5-22-2020 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6515-BUILDING REPAIRIMAINTE 0 0 0 0 0 IRAIECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6550-DEVELOPER PAYMENTS 37,034 25,978 9,500 10,000 IRA/ECONOMI 2000-HRAIECONOMIC DEVELOPMEN 6570-PROGRAMMING EXPENSE 9,680 12,575 31,229 10,059 7,733 8,000 Open to Business,Real estate 8,000 database IRA/ECONOMI 2000-HRAIECONOMIC DEVELOPMEN 6910-LAND 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 6915-BUILDING&STRUCTURE 0 0 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 7310-OPERATING TRANSFERS 16,832 2,850 2,850 0 0 IRA/ECONOMI 2000-HRA/ECONOMIC DEVELOPMEN 7420-OTHER 0 0 0 0 0 Total 2000-HRA/ECONOMIC.DEVEL 0 0 0 0 (3,970) (2,723) (3,722) IRA/ECONOMI 2001-HRA/ECON DEVELP REVENUE 5205-OPERATING TRANSFERS 0 Total 2001-HRA/ECON DEVELP REV 0 IRA/ECONOMI 2002-INDUSTRIAL PARK EXPANSION 6401-PROFESSIONAL SERVICES 0 0 0 0 0 IRAIECONOMI 2002-INDUSTRIAL PARK EXPANSION 6403-LEGAL 0 0 0 0 0 IRA/ECONOMI 2002-INDUSTRIAL PARK EXPANSION 6450-OUTSIDE PRINTING 0 IRA/ECONOMI 2002-INDUSTRIAL PARK EXPANSION 6470-TRAINING&SUBSISTANCE 0 IRA/ECONOMI 2002-INDUSTRIAL PARK EXPANSION 6485-MILEAGE REIMBURSEMEN 0 0 0 0 IRA/ECONOMI 2002-INDUSTRIAL PARK EXPANSION 7420-OTHER 0 Total 2002 INDUSTRIAL PARK EXPA 0 0 0 0 0 :RAND TOTAL 0 0 0 0 (3,970) (2,723) (3,722) Business Object subs[ Actual Actual Actual Actual Budget Proposed Proposed Company Unit Account diary Subledger Line Item Detail 2017 2019 2019 2020 2020 2021 2021 Proposed Budget Comments 2022 2022 Proposed Budget Comments 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 1010-CASH 6,893 6,893 6,893 6,893 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 1010-CASH A.00009 250,546 460,755 287,210 342,376 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 1011-PREMIUM/DISCOUNT ON 1 (144) (309) (40) 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 1095-ACCRUED INTEREST INVE 655. 1,083 588 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 1105-TAXES REC UNREMITTED 0 0 0 0' 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 1205-SA UNREMITTED 0'. 0 0 0'. 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 1210-SA DELINQUENT 0'. 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 1215-SA DEFERRED 0 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 1305-ACCOUNTS RECEIVABLE 0 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 1305-ACCOUNTS RECEIVABLE 1 0 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 1345-DUE FROM OTHER FUNDS 0' 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 1352-DUE FROM STATE 3,773 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 2010-ACCOUNTS PAYABLE 0 0 0 0 'ARK IMPROVE 2300.PARK IMPROVEMENT FUND 2010-ACCOUNTS PAYABLE 1 0' (8,633) 0 0. 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 2205-DEFERRED REVENUE 0 0 0 0'. 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 2415-MN SALES TAX DUE 0 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 3510-UNRESERVED FUND BALA (290,218) (257,950) (463,562) (294,650) 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 4110-SPEC ASSESS CURRENT (287) 0 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 4115-DELINQUENT SPECIAL AS 0' 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 4120-SPEC ASSESS COUNTY PR 0 (17) 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 4125-SPEC ASSESS PREPAID TO 0 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 4130-SPEC ASSESS PENALTIES/ 0 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 4444-STATE GRANT 0 (8,633) (23,367) 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 4460-COUNTY MISCELLANEOUS 0 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 4480-OTHER MISCELLANEOUS 0 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 4955-INTEREST ON INVESTMEN (3,249) (7,000). (9,527) (3,031) (3,500) (2,800)TM 4-29.2020 (1,800)TM 4-29-2020 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 4960-GAIN/LOSS INVEST MKT VA 688 1,794 (3,917) 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 4975-RENTAL INCOME (7,773) (8,245) (8,245) (8,400)Farm leases RD 5/11/20 (8,400) 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 5010-SALES OF ASSETS 0 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 5045-PARK DEDICATION FEES (17,500) (85,600) 0 0 (25,000) (25,000)development fees RD 5/11120 (25,000) 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 5205-OPERATING TRANSFERS (40,000). (85,000) (75,000) (43,750) (75,000) (75,000)See Operating Transfers spreadsheet (75,000)Per Operating Transfers spreadsheet in In Finance/Operating Transfers By Finance/Operating Transfers By Year Year folder folder 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 5205-OPERATING TRANSFERS S.61001 (9,712) 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 5350-MISCELLANEOUS REVENU 0 0 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 5355-DONATIONS (150) 0 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 6220-EQUIP SUPPLIES&PARTS 0 0 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 6250-OTHER SUPPLIES&PARTS 0 0 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 6401-PROFESSIONAL SERVICES 0 8,633 23,367 1,716 0 Create master plan for Flagstaff 10,000 Create master plan for Flagstaff Meadow Meadow Park Park RD 5/11/20 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 6403-LEGAL 0'. 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 6430-INSURANCE DEDUCTIBLE 0'. 0 0 0 'ARK IMPROVE 2300.PARK IMPROVEMENT FUND 6492-ADVERTISING 0 0 0 0 'ARK IMPROVE '..2300-PARK IMPROVEMENT FUND 6560-CONTRACTUAL SERVICES 36,000 15,000 resurface tennis courts in Rambling 160,000 Feely Fields parking lot reconstruction, River Park RD 5/1120 replace field#2 outfield fence and Rambling River Park east parking lot reconstruction 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 6915-BUILDING&STRUCTURE 0 0 0 0 3,000 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 6950-MACHINERY,EQUIPMENT 0 0 0 1,037 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 7010-CONSTRUCTION CONTRAC 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 7020-OTHER CONSTRUCTION C 0'. 0 0 0 0 'ARK IMPROVE '..2300-PARK IMPROVEMENT FUND 7140-LEGAL&FISCAL FEES 0'. 0 0 0 Page 1 of Business Object Subs] Actual Actual Actual Actual Budget Proposed Proposed company Unit Account diary Su6letlger Line Item Detail 2017 2015 2019 2020 2020 2021 2021 Proposed Butlget Comments 2022 2022 Proposed Budget Comments 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 7310-OPERATING TRANSFERS 768 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 7310-OPERATING TRANSFERS S.61001 0 0 0 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 7410-ADMINISTRATION CHARGE 0 'ARK IMPROVE 2300-PARK IMPROVEMENT FUND 7420-OTHER 0'. 0 0 8 Total 2300-PARK IMPROVEMENT FU (101,708) 29,788 (265,128) 2,353 (72,745) (96,200) 49,800 ;RAND TOTAL (101,706) 29,788 (265,128) 2,353 (72,745) (96,200) 49,800 Page 2 of Business Object Bubas Actual Actual Actual Actual Budget Proposed Proposed Company Unit Account diary Subledger Lina Item Detail 2017 2018 2019 2020 2020 2021 2021 Proposed Budget Comments 2022 2022 Proposed Budget Comments ,E ARENA2500-ICE ARENA 1010-CASH 277,449 277,449 277,449 277,449 ,E ARENA 2500-ICE ARENA 1010-CASH A.00009 (240,699) (233,073)'. (247,704), (250,057) ,E ARENA 2500-ICE ARENA 1011-PREMIUM/DISCOUNT ON I (21) (27). (4): 0 ,E ARENA2500-ICE ARENA 1020-PETTY CASH 300 300 300 300 ,E ARENA 2500-ICE ARENA 1025-DISHONORED CHECKS 0 0'. 0 0 ,E ARENA2500-ICE ARENA 1095-ACCRUED INTEREST INVE 94 93 57 0 ,E ARENA 25DO-ICE ARENA 1305-ACCOUNTS RECEIVABLE 84,647 54,626. 65,125 20,642 ,E ARENA 2500-ICE ARENA 1305-ACCOUNTS RECEIVABLE 1 1,075 2,769 898 0 ,E ARENA 2500-ICE ARENA1310-ACCOUNTS RECEIVABLE U 0 0 0 ,E ARENA 2500-ICE ARENA 1320-CREDIT CARDS 111 179 295 48 ,E ARENA 2500-ICE ARENA 1405-INVENTORY 0 0 0 0 ,E ARENA 2500-ICE ARENA 1505-PREPAID EXPENSES 0 0 0 0 ,E ARENA 2500-ICE ARENA 2010-ACCOUNTS PAYABLE (149) (65) 00 ,E ARENA 2500-ICE ARENA 2010-ACCOUNTS PAYABLE 1 (10,868) (12,451) (16,787). 0 ,E ARENA 2500-ICE ARENA 2255-DEPOSITS PAYABLE (2,409) (6,360) (9,309) (5,433) ,E ARENA 2500-ICE ARENA 2305-DUE TO OTHER FUNDS 0 0 0 0 ,E ARENA 2500-ICE ARENA 2415-MN SALES TAX DUE (338) (628) (648) (1,126) ,E ARENA 2500-ICE ARENA 2416-TRANSIT SALES TAX DUE 0 0 0 0 ,E ARENA 2500-ICE ARENA 3510-UNRESERVED FUND GALA (80,025) (109,191). (82,792) (69,673) ,E ARENA 2500-ICE ARENA 4955-INTEREST ON INVESTMEN 0 0 0 0 Total 2500-ICE ARENA 29,166 (26,399) (13,119) (27,850) ,E ARENA 2501-ICE ARENA REVENUE 4512-CUSTOMER SERVICES NO 0 0 0 D 0 ,E ARENA 2501-ICE ARENA REVENUE 4668-CONCESSIONS 0 0 0 0 0 ,E ARENA 2501-ICE ARENA REVENUE 4810-ICE RENTAL (294,953) (288,220) (293,829) (137,170) (305,000) (310,000)proposed$5.00 hr rental increase RD (315,000). 5/11/20 ,E ARENA 2501-ICE ARENA REVENUE 4815-LESSONS (21,794) (22,733) (26,683) (10,480) (21,000) (25,000)Increased based on historical numbers (25,000) RD 5/11120 ,E ARENA 2501-ICE ARENA REVENUE 4820-OPEN SKATE (10,768) (20,775) (17,987) (9,593) (15,000) (18,000)Increased based on historical numbers (18,000) RD 5111/20 ,E ARENA 2501-ICE ARENA REVENUE 4822-SKATE RENTAL (1,279) (1,485) (1,427) (763) (1,500) (1,500) (1,500) ,E ARENA 2501-ICE ARENA REVENUE 4825-ADMISSIONS 0 0 0 0 0 ,E ARENA 2501-ICE ARENA REVENUE 4830-SKATE SHARPENING (2,709) (2,823) (3,442) (1,540) (3,000) (3,000) (3,000) ,E ARENA 2501-ICE ARENA REVENUE 4835-ADVERTISING (12,845) (12,119). (12,643) 0 (12,000) (12,000) (12,000) ,E ARENA 2501•ICE ARENA REVENUE 4840-SKATE SHOW 0 0 0 0 0 ,E ARENA 2501-ICE ARENA REVENUE 4845-MERCHANDISE SOLD (1,050) (973) (1,097) (510) (1,200) (1,200) (1,200) ,E ARENA 2501-ICE ARENA REVENUE 4955-INTEREST ON INVESTMEN (728) (883) (1,114) (583) (500) (300)TM 4-29-2020 (200)TM 4-29-2020 ,E ARENA2501•ICE ARENA REVENUE 4960-GAIN/LOSS INVEST MKT VA 98 154 (377) 0 ,E ARENA 2501-ICE ARENA REVENUE 4973-RENTAL INCOME-ARENA T (2,429) (1,860) (1,880) 0 (2,500) (2,500) (2,500) ,E ARENA 2501-ICE ARENA REVENUE 4975-RENTAL INCOME (564) (536) (B66) 0 (500) (500) (500) ,E ARENA 2501-ICE ARENA REVENUE 5010-SALES OF ASSETS 0 0 0 0 0 ,E ARENA 2501-ICE ARENA REVENUE 5205-OPERATING TRANSFERS 0 D 0 0 0 ,E ARENA 2501•ICE ARENA REVENUE 5350-MISCELLANEOUS REVENU (1,270) (1,104) (1,173) 0 (1,000) (1,000) (1,000) ,E ARENA 2501-ICE ARENA REVENUE 5355-DONATIONS (5,000) (5,000) (5,000). (5,000) (5,000) (5,000) (5,000) ,E ARENA 2501-ICE ARENA REVENUE 5370-CASH OVER 8 SHORT 0 0 0 (4) - Total 2501'-ICE ARENA REVENUE (355,289) (358,355) (367,717) (165,641) (368,200) (380,000) (384,900) ,E ARENA 2502-ICE ARENA OPERATIONS EXP 5502-COST OF GOODS SOLD 2,540 174 0 0 750 750 750 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6110•FULL TIME SALARIES 92,782 124,464 131,799 70,021 113,924 118,250 JG 06/03/2020 124,600 JG 06/0312020 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6110-FULL TIME SALARIES S.00019 5,703 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6112-FULL TIME OVERTIME 479 1,181 1,151 0 600 700 JG 5/15/2020 800 JG 5/15/2020 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6120-PART TIME SALARIES 55,400 63,250 56,962 23,426 59,605 61,393 JG 5!14/2020 62,928 JG 5/1412020 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6122•PART TIME OVERTIME 0' ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6130•COMPENSATORY TIME PAY 1,355 1,518 1,953' 0 1,500 1,500 JG 5/15/2020 1,600'JG 5/1512020 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6135-OTHER PAY 1,397 1,375 1,130 399 1,550 1,550 JG 5/15/2020 1,550 JG 5/15@020 Company Business Object Subsi Subledger Line item Detail Actual Actual Actual Actual Budget Proposed 2021 Proposed Budget Comments Proposed 2042 Proposed Budget Comments Link Account diary 2017 2018 2019 2020 2020 2021 2022 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6152-FICA/MEDICARE 11,745 14,683 14,768 7,131 13,608 14,750 JG 06/03/2020 15,000..JG 06/03/2020 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6152-FICAIMEDICARE S.00019 433 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6154-PERA 8,489 13,667 11,374 5,562 9,112 8,900 JG 06/03/2020 9,500 JG 0 6103/2 02 0 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6154-PERA S.00019 428 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6156.HCSP 630 645'. 78'. 0 700 1,200 JG 5/15/2020 1,300 JG 5/15/2020 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6158-EMPLOYEE BENEFITS 9,150 13,598 21,689 12,174 24,400 26,840 JG 6/341020 30,866 JG 6/32020 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6159-WORKERS COMP 5,095 2,851 3,659 4,177 7,539 11,100 JG 5/152020 11,900 JG 5/152020 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6220-EQUIP SUPPLIES&PARTS 2,617 2,671 4,275. 1,407 3,500 3,500 - 3,500 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6240-BUILDING SUPPLIES&PAR 7,471 5,101 3,359 2,818 6,000 6,000 6,000 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6242-CLEANING SUPPLIES 0 191 693 530 500 1,000 COVID 19 RD 5/11/20 1,000 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6250-OTHER SUPPLIES&PARTS 332 92 0 0 500 0 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6255-LANDSCAPING MATERIALS 0 0 0 0 0 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6272-FUEL 80 68' 0 0 50 50 50 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6260-BOOKS&SUBSCRIPTIONS 121'. 122 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6290-UNIFORMS&CLOTHING 1,076 350. 375 387 500 500 500 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6401-PROFESSIONAL SERVICES 2,502 7,613 1,080' 660 1,500 1,500 1,500 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6403-LEGAL 0 0 0 0 0 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6404.IT SERVICES 17,607 14,874 15,844 11,219 19,232 20,518 This line Rem is for the chargeback of 22,071 This line item is for the chargeback of each area's share of internal IT each area's share of internal IT charges. charges.5-31-2020 TM 5-31-2020 TM ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6411-TELEPHONE/CABLE SERVI 802 943 826 604 900 900 900 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6412-CELLULAR SERVICES 0 ,E ARENA 2602-ICE ARENA OPERATIONS EXP 6421-MUNICIPAL SERVICES 6,566 6,658 9,846' 3,903 6,500 8,000 Increased based on historical spending 8,000 and increased rates RD 511120 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6422-ELECTRIC 54,729 57,770 52,346 19,840 56,160 55,000 Decreased due to historical spending 55,000 RD 5/11/20 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6423-NATURAL GAS 13,792 17,227 15,461 6,695 17,000 16,000 Decreased based on historical 16,000 spending RD 511120 8-4-2020 RD ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6426-INSURANCE 4,474 4,610 4,793 3,148 4,820 5,480 This is for property and liability 5,560 This is for property and liability insurance premiums.Offset is insurance premiums.Offset is 7100.5360 7100.5360 TM 5-22-2020 TM 5-22-2020 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6450-OUTSIDE PRINTING 0 0 0 0 0 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6455-LEGAL NOTICES 0 0 0 0 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6460-MEMBER DUES&LICENSU 594 962 793 705 1,000 750 84-2020 RD 750 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6465-PERMIT FEES see 6564 0 0 0 0 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6470-TRAINING&SUBSISTANCE 859 781 560 70 1,000 500 8.4-2020 RD 500 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6485-MILEAGE REIMBURSEMEN 113 65 53 0 250 100 8-4-2020 RD 100 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6492-ADVERTISING 0 0 0 0 0 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6505-EQUIPMENT REPAIRWAIN 17,872 3,750'. 11,964 7,411 5,000 6,000 Increased based on historical spending 6,000 RD 5/11/20 8.4-2020 RD ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6515-BUILDING REPAIR/MAINTE 3,148 847 7,142 1,319 4,000 2,500 84-2020 RD 2,500 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6555-RENTAL OF EQUIPMENT 0 0' 0 16 500 250 8.42020 RD 500 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6560-CONTRACTUAL SERVICES 5,000 2,500 842020 RD 2,500 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6564-PERMIT FEES 25 0 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6570-PROGRAMMING EXPENSE 1,473 2,081 4,323 0 1,000 1,500 Increased based on historical spending 1,500 5/1120 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6915-BUILDING&STRUCTURE 0 0 0 1,954 0 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6950-MACHINERY,EQUIPMENT 932 694 1,965 415 0 500 Increased based on historical spending 500 RD 5/1120 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 6960-FURNITURE,OFFICE EQUIP 431 615 0 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 7310-OPERATING TRANSFERS 0 20,000 O'. 0 0 ,E ARENA 2502-ICE ARENA OPERATIONS EXP 7420-OTHER 0 0'. 0 0 Total 2502-ICE ARENA OPERATIONS. :326,123 384,764 380,836 193,491 368,200 379,981 395,725 Company Business Object Subsi Subledger Line It..Detail Actual Actual Actual Actual Budget Proposed 2021 Proposed Budget Comments Proposed 2022 Unit Account diary 2017 2018 2019 2020 2020 2021 Y022 Proposed Budget Comments ;RAND TOTAL 0 0 0 0 0 (1 g) 10,825 . CITY OF FARMINGTON Five/Ten Year Financial Plan April 2020 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 ✓ Balance future tax levy increases to acceptable levels ✓ Work to achieve annual street/trail maintenance/projects funding targets ✓ Purchase all future fire engines 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 (2021-2025)which is followed by individual financial plans in a number of areas. City staff does have a ten year plan as well (2026-2030) 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. CITY OF FARMINGTON Summary Page and Summary Page with Items of Note CITY OF FARMINGTON 2030 FINANCIAL PLAN SUMMARY 2020 2021 2022 2023 2024 2025 ANNUAL HUMAN RESOURCES COSTS $9,696,605 $10,159,442 $10,565,820 $10,988,453 $11,427,991 $11,885,110 BASE NON-HR COSTS $3,176,451 $2,668,584 $2,748,642 $2,776,128 $2,831,650 $2,916,600 NEW HR COSTS $0 $0 $100,000 $200,000 $100,000 -$100,000 EXISTING DEBT $2,805,387 $3,013,080 $2,275,250 $1,883,250 $1,566,250 $1,440,750 FUTURE STREET CIP DEBT $0 $126,000 $261,000 $261,000 $421,000 $421,000 FUTURE STREET CIP CASH $0 $350,000 $435,000 $960,000 $653,000 $634,000 FUTURE VEHICLE CIP CASH $0 $480,000 $542,000 $542,000 $630,000 $624,000 TRANSFER PROJECT-TAX LEVY $603,240 $1,157,567 $1,172,567 $1,177,567 I $1,203,292 $1,420,270 TRANSFER PROJECT-LGA $328,967 $328,967 $328,967 $328,967 $328,967 $314,725 PROJECTS-TAX LEVY $0 $300,000 $325,000 $0 $0 $0 PROJECTS-DEBT PAYMENTS $0 $252,000 $252,000 $252,000 $252,000 $252,000 PARK IMPROVEMENT FUND CIP $0 $0 $0 $0 $100,000 $100,000 TOTAL OPERATING/DEBT EXPENDITURES $16,610,650 $18,835,640 $19,006,245 $19,369,365 $19,514,i5O $20,108,455 OTHER REVENUES(1%INCREASE ANNUALLY) $3,574,072 $3,609,813 $3,645,911 $3,682,370 $3,719,194 $3,756,386 FISCAL DISPARITIES $2,294,024 $2,294,024 $2,294,024 $2,294,024 $2,294,024 $2,294,024 TOTAL REVENUES $5,868,096 $5,903,837 $5,939,935 $5,976,394 $6,013,218 $6,050,410 SUMMARY BASE BUDGET LEVY _ $12,873,056 $12,828,026 $13,414,461 $13,964,581 $14,359,641 $14,901,710 CIP/TRANSFER/LGA LEVY - $932,207 $1,786,534 I $1,826,534 $1,506,534 $1,632,259 $1,834,995 EXISTING DEBT LEVY $2,805,387 $3,013,080 $2,275,250 $1,883,250 $1,566,250 $1,440,750 FUTURE DEBT LEVY $0 $378,000 $513,000 $513,000 $673,000 $673,000 PAY AS WE GO LEVY $0 $830,000 $977,000 $1,502,000 $1,283,000 $1,258,000 TOTAL EXPENDITURES $16,610,650 $18,835,640 $19,006,245 $19,369,365 $19,514,150 $20,108,455 OTHER REVENUES $3,574,072 $3,609,813 $3,645,911 $3,682,370 $3,719,194 $3,756,386 FISCAL DISPARITIES $2,294,024 $2,294,024 $2,294,024 I $2,294,024 $2,294,024 $2,294,024 TOTAL REVENUES $5,868,096 $5,903,837 $5,939,935 $5,976,394 $6,013,218 $6,050,410 TOTAL TAX LEVY $10,742,554 $12,931,803 $13,066,310 $13,392,971 $13,500,933 $14,058,046 PROJECTED%CHANGE -0.49% 20.38% 1.041Y. 2.50% 0.81% 4.13% PROJECTED$CHANGE -$53,211 $2,189,249 $134,5071$326,660 $107,962 $557,113 ENDING FUND BALANCE $5,325,270 $5,325,270 $5,325,270 $5,325,270 $5,325,270 $5,325,270 FUND BALANCE AS A%OF ANNUAL EXPENSES 38.57% 37.20% 35.46% 33.98% 33.30% 31.82% i 4/13/2020 2030 Financial Plan Info2030 Financial Plan Info 4/13/2020 2O3OFinancial Plan|nho2O3OFinancial Plan Info Items of Note 1. The Existing Debt CIP includes the first year repayment of the debt issued to purchase Ladder 1. The annual debt payment on this purchase is approximately$270,000. This is a five-year debt issuance. 2. A potential project to be completed in 2021 is included in the plan. The project is the Highway 3 Backage Road to be built between Willow Street and 2091h Street over time. This project would require debt to be issued in the amount of$1,000,000. The first debt repayment is included in 2021 for now in the amount of$126,000. This is a ten-year debt issuance. 3. A potential project to be completed in 2021 is included in the plan. The project is the extension of 202nd Street into Farmington from Lakeville at the north end of Farmington High School. This one-time cash funding is included in the 2021 plan in the amount of $350,000. 4. This item is the annual purchase of city vehicles that restarted with the 2020 budget. The 2021 plan has$480,000 planned for the purchase of General Fund vehicles and equipment. 5. This item includes a significant increase in the tax levy portion of the Transfers CIP to include funding to mill and overlay Akin Road in 2021. The increase in this line item is $450,000. There is also an increase in tax levy supported trail maintenance in the amount of$55,327. 6. The Projects CIP includes $300,000 in cash for sidewalk replacement in the downtown area in 2021. 7. The Phase Two Schmitz/Maki Arena project is included in 2021 in the Projects CIP. This project will create dedicated locker rooms for the facility and build a new lobby area for the facility. This project is estimated at$2,000,000 and will require debt to be issued. The plan has the first repayment of the project occurring in 2021 at an annual cost of $252,000. This is a ten-year debt issuance. 8. The plan in 2022 includes the start of the collection of dollars to replace Engine 1 in 2027. The annual amount collected is$220,000. With four fire engines,the collection of cash on an annual basis will be a recurring item to enable the city to replace one engine every five years without issuing debt. 9. The plan includes the collection of tax dollars to help fund the Park Improvement CIP starting in 2024. 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 2020 budget is used for all ten years of the plan. ✓ Increased human resources costs in terms of wages, cost of living adjustment and benefit cost increases are assumed in the plan. 2021 Items Summary There are a number of large items that are affecting 2021. For simplicity,these items are summarized below. 1. Ladder 1 Debt Payment-$270,000 2. Highway 3 Backage Road Debt Payment-$126,000 3. 202nd Street One-Time Cash Collection-$350,000 4. Vehicle CIP Cash Collection-$480,000 5. Akin Road Mill and Overlay Cash Collection-$450,000 6. Downtown Sidewalks Cash Collection-$300,000 7. Schmitz-Maki Arena Debt Payment-$252,000 CITY OF FARMINGTON EXISt 'iOng CIP 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. CITY OF FARMINGTON 2030 FINANCIAL PLAN EXISTING DEBT ROAD AND BRIDGE FUND 2020 2021 2022 2023 2024 2025 2013A(ASH/SPRUCE/HILL DEE) $669,000 $443,000 _ 2016A(ELM/195TH/WALNUT) $352,000 $574,327 $624,750 $276,750 $271,750 $181,750 TOTAL ROAD AND BRIDGE FUND DEBT $1,021,000 $1,017,327 $624,750 $276,750 $271,750 $181,750 __ ____--- ______ _-I-,,,,----- 111--,----]- J 1 1 1 1 NON ROAD AND BRIDGE FUND 2020 2021 2022 2023 2024 2025 2010D(ARENA IMPROVEMENTS) $16,437 2010A(POLICE STATION) $400,000 $292,253 2005C(FIRE STATION 2) $166,000 $275,000 $166,000 $166,000 $96,000 $49,000 2016B(CITY HALL) $665,000 $635,000 $640,000 $638,000 $636,000 $647,500 2015A(195TH ST) $307,000 $293,500 $335,500 $293,500 $293,500 $293,500 2019A(WESTVIEW ACRES) $229,950 $231,000 $240,000 $240,000 2020A(LADDER ONE) $269,000 $269,000 $269,000 $269,000 $269,000 TOTAL NON ROAD AND BRIDGE DEBT $1,784,387 $1,995,753 $1,650,500 $1,606,500 ( $1,294,500 $1,259,000 TOTAL EXISTING DEBT $2,805,387 $3,013,080 $2,275,250 $1,883,250 $1,566,250 $1,440,750 4/13/2020 2030 Financial Plan Info CITY OF FARMINGTON 01'0- Street Projects CIP This CIP tracks upcoming street construction and reconstruction projects over the next five years. � / ' / ) � 4/13/2020 2O3DFinancial Plan Info CITY OF FARMINGTON Street CIP This CIP tracks the planned street maintenance work including sealcoating, crack sealing and mill and overlay projects. STREET MAINTENANCE FUND 2030 FINANCIAL PLAN STREET MAINTENANCE CIP 2020 2021 2022 2023 2024 2025 STARTING CASH BALANCE $70,977 $129,055 $110,023 $63,938_ -$39,267 -$159,592 REVENUES $967,398 $1,023,208 $753,275 $803,275 $793,275 $949,033 TAX LEVY $400,000 $850,000 $600,000 $630,000 $660,000 $690,000 LOCAL GOVERNMENT AID $117,033 $81,208 $61,275 $81,275 $41,275 $167,033 OTHER REVENUE $358,365 $0 $0 $0 $0 $0 MSA $92,000 $92,000 $92,000 $92,000 $92,000 $92,000 EXPENSES $909,320 $1,042,240 $799,360 $906,480 $913,600 $920,720 CRACK SEALING $34,320 $35,640 $36,960 $38,280 $39,600 $40,920 SEAL COATING $75,000 $156,600 $162,400 $168,200 $174,000 _$179,800 MILL AND OVERLAY $800,000 $850,000 $600,000 $700,000 $700,000 $700,000 ENDING BALANCE $129,055 $110,023 $63,938 -$39,267 -$159,592 -$131,279 IDEAL MAINTENANCE FUNDING PAVEMENT MANAGEMENT __t_$810,000 4/13/2020 2030 Financial Plan Info CITY OF FARMINGTON uuououuuuui� — "rr�w" Veh 'icles This CIP tracks the purchase/replacement plan for vehicles from General Fund departments. CITY OF FARMINGTON 2030 FINANCIAL PLAN, VEHICLE CIP SUMMARY 2020 2021 2022 2023 2024 2025 COMMUNITY DEVELOPMENT $32,860 $0 $0 $34,500 so $0 ENGINEERING $37,100 $34,880 $0 $37,950 $0 $0 FIRE $37,100 $59,950 $61,600 $126,500 $436,600 $432,350 MUNICIPAL SERVICES $89,040 $264,870 $248,640 $17,250 $153,400 $254,100 NATURAL RESOURCES $0 $0 $39,200 $0 $0 $0 PARKS $368,880 $207,100 $133,280 $56,350 $123,900 $0 POLICE,--,- $92,180 $143,989 $213,920 $118,785 $105,138 __$173,030 $657,160 $710,789 $696,640 $391,335 $819,038 $859,480 VEHICLE CIP-FUNDING/FUND BALANCE 2020 2021 _____'___2022 2023 20241---- 2025 STARTING BALANCE $748,605 $91,445 -$139,344 -$293,984 -$143,319 -$332,357 TOTAL ANNUAL EXPENDITURES $657,160 $710,789 $696,640 $391,335 $819,038 $859,480 TAX LEVY REVENUE(CASH) $0 $480,000 $542,000 $542,000 $630,000 $624,000 USE OF FUND BALANCE $0 $0 so $0 $0 $0 L G A so $0 so so $0 so OTHER REVENUE $0 $0 so so so so YEAR ENDING BALANCE $91,445 -$139,344 -$293,984 -$143,319 -$332,357 -$S67,837 FUTURE CIP DEBT REPAYMENTS 2020 2021 2022 2023 2024 2025 FUTURE DEBT $0 $0 $0 $0 $0 $0 TOTAL FUTURE CIP DEBT $0 $0 $0 $0 $0 $0 2021 PURCHASES TBD $710,789 TOTAL $710,789 4/14/2020 2030 Financial Plan Info CITY OF FARMINGTON 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. CITY OF FARMINGTON 2030 FINANCIAL PLAN TRANSFERS CIP TAX LEVY PROJECTS v 2020 2021 2022 2023 2024 2025 EDA TRANSFER $0 $0 $0 $0 $0 $40,000 ENGINE ONE(2027) $0 $0 $220,000 $220,000 $220,000 $220,000 ARENA CAPITAL PROJECTS $10,000 $10,000 $20,000 $20,000 $20,000 $20,000 POLICE EQUIPMENT CIP $51,000 $75,000 $110,000 $55,000 $30,725 $30,725 FIRE EQUIPMENT CIP $91,545 $91,545 $91,545 $111,545 $111,545 $126,545 PAVEMENT MANAGEMENT $400,000 $850,000 $_600,000 $630,000 $660,000 $690,000 TRAIL MAINTENANCE CIP $34,673 $90,000 $90,000 $100,000 $120,000 $170,000 BUILDING MAINTENANCE CIP $0 $5,000 $5,000 $5,000 $5,000 $100,000 TOWNSHIP ROAD MAINTENANCE $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 EMPLOYEE EXPENSE FUND $13,022 $13,022 $13,022 $13,022 $13,022 $0 PROPERTY/CASUALTY DEDUCTIBLE $0 $20,000 - $20,000 $20,000 $20,000 $20,000 TOTAL TAX LEVY PROJECTS $603,240 $1,157,567 $1,172,567 $1,177,567 $1,203,292 $1,420,270 LGA PROJECTS 2020 2021 2022 2023 2024 2025 BUILDING MAINTENANCE $86,607 $137,958 $166,607 $136,607 $186,607 $136,607 EDATRANSFER _ $40,000 $68,976 $41,085 $41,085 $41,085 $0 EMERALD ASH BORER-� $10,000 $10,825 $10,000 $10,000 $10,000 $10,000 TRAIL MAINTENANCE _ $75,327 $30,000 $50,000 $60,000 $50,000 $1,085 PAVEMENT MANAGEMENT $117,033 $81,208 $61,275 $81,275 $41,275 $167,033 TOTAL LGA PROJECTS $328,967 $328,967 $328,967 $328,967 $328,967 $314,72S TOTAL TRANSFERS PROJECTS $932,207 $1,486,534 $1,501,534 $1,506,534 $1,532,259 $1,734,995 FUNDING TARGETS BUILDING MAINTENANCE _ $300,000 EMERALD ASH BORER -$50,000 TRAIL MAINTENANCE $510,000 PARK IMPROVEMENT FUND $100,000 PAVEMENT MANAGEMENT $810,000 - 4/14/2020 2030 Financial Plan Info CITY OF FARMINGTON Plansint e Transfers CIP This CIP tracks a number of expenditures included in the Transfers CIP including fire equipment, police equipment and building maintenance. CITY OF FARMINGTON 2030 FINANCIAL PLAN FIRE EQUIPMENT CIP 2020 2021 2022 2023 2024 2025 $149,800 $0 $0 $0 $0 SCBA $0 PORTABLE RADIOS $45,000 $45,000 $45,000 -.-- $45,000* $45,000 RADIO BATTERIES $6,000 -----$0----$8,000 $0 $8,000 $0 MOBILE RADIOS $0 $0 $9,750 $9,750 $9,750 $9,750 EXTRACTION TOOLS $0 $0 $0 $40,000 $0 $0 THERMAL IMAGING CAMERA $0 $7,500 $5,000 $0- $0 $7,500 RAD 57 CO,MONITOR $0 $0 $7,000 $0 $0 $8,000 STATION COMPRESSOR $0 $0 $0 $50,000 $0- HOSE $7,500 $11,000 $7,500 $11,000 $7,500 $9,000 GAS MONITORS $8,000 $9,000 $0 $0 TOTAL $13,500 $221,300 $82,250 $114,750 $120,250 $79,250 2020 2021 2022 2023 2024 2025 STARTING BALANCE $88,606 $166,651 $36,896 $46,191 $42,986 $34,281 EXPENDITURES $13,500 $221,300 $82,250 $114,750 $120,250 $79,250 TAX LEVY $91,545 $91,545 $91,545 $111,545 $111,545 $126,545 ENDING BALALNCE $166,651 $36,896 $46,191 $42,986 $34,281 $81,576 4/14/2020 2030 Financial Plan Info CITY OF FARMINGTON 2030 FINANCIAL PLAN POLICE EQUIPMENT CIP 2020 2021 2022 2023 2024 2025 AEDS _ $0 $9,800 $0 $0 $0 $0 RADIOS $73,901 $73,901 $73,901 $0 $0 $0 _ HANDGUNS $0 $0 $0 $0 $0 $0 RIFLES $0 $0 $0 $0 $0 $0 TASERS _ $0 $0 $0 $0 $0 $22,000 BODY CAMERAS $13,452 $13,452 $13,452 $13,452 $13,452 $13,452 SQUAD CAMERAS $28,398 $14,706 $14,706 $14,706 $16,188 $16,188 GUN CAMERAS $0 $0 $0 $0 $0 $0 THERMAL IMAGING $10,000 $0 $0 $0 $0 $0� FINGERPRINT MACHINE $0 $18,000 $0 $0 $0 $0 SPEED TRAILER $0 $16,000 $0 $0 $0 $0 TOTAL $125,751 $145,859 $102,059 $28,158 $29,640 $51,640 -----�_ -- 2020 _ _______2021 2022 2023-� 2024 2025 - STARTING BALANCE $118,435 I $43,684 $6,825 $14,766 $41,608 $42,693 ANNUAL EXPENDITURES $125,751 $145,859 $102,059 $28,158 $29,640 $51,640 TAX LEVY $51,000 $75,000 $110,000 $_55,000 $30,725 -$30,725 LIQUOR STORE FUNDS `- _ $0 $34,000 $0 $0 $0 $0 ENDING BALANCE $43,684 $6,825 $14,766 $41,608 $42,693 $21,778 4/14/2020 2030 Financial Plan Info CITY OF FARMINGTON 2030 FINANCIAL PLAN TRAIL MAINTENANCE CIP REVENUES 2020 2021 2022 2023 2024 2025 TAX LEVY $34,673 $90,000 $90,000 $100,000 $120,000 $170,000 LOCAL GOVERNMENT AID $75,327 $30,000 $50,000 $60,000 $50,000 $1,085 OTHER $0 $0 $0 $O $O $0 TOTAL $110,000 $120,000 $140,000 $160,000 $170,000 $171,085 EXPENDITURES 2020 2021 2022 2023 2024 2025 BEGINNING BALALNCE $12,847 $9,967 $6,207 $21,567 $6,047 -$353 FOG SEALING $15,600,------,--$16,200 $16,800 $17,400 $18,000 $9,055 CRACK SEALING $7,280 $7,560 $7,840 $8,120 $8,400 $8,350 PAVEMENT REPLACEMENT $901000 $100,000 $100,000 $150,000 $150,000 $150,000 RECONSTRUCTION $0 $0� $0 $0 $0 $0 TOTAL EXPENDITURES l $112,880 $123,760 $124,640 $175,520 I $176,400 I $167,405 YEAR END BALANCE $9,967 $6,207 $21,567 $6,047 -$353 $3,327 FUNDING TARGET TRAIL MAINTENANCE $510,000 4/14/2020 2030 Financial Plan Info CITY OF FARMINGTON _ 2030 FINANCIAL PLAN BUILDING CIP SCHEDULE SUMMARY BY BUILDING 2020 2021 2022 2023 2024 2025 CITY HALL $0 $0 $0 $0 $0 $0 FIRE STATION#1 $103,000 $0 $0 $0 $0 $0 FIRE STATION#2 $0 $0 $0 $0 $0 $0 SCHMITZ-MAKI ARENA $0 $0 $0 $0 $0 $0 FIRST STREET GARAGE $D $0 $0 $0 $0 $0 MAINTENANCE FACILITY $0 $0 $0 $0 $0 $0 POLICE STATION $0 $0 $0 $0 $0 $0 RAMBLING RIVER CENTER $48,000 $0 $0 $0 $0 $0 FEES(7.5%) $11,325 $0 $O $0 $0 $0 TOTAL EXPENDITURES $162,325 $0 $0 $0 $0 $0 2020 2021 2022 2023 2024 2025 STARTING BALANCE $94,289 $18,571 $161,529 $333,136.. . $474,743 $666,350 EXPENDITURES $162,325 _ $0 $0 $0 $0 $0 LGA FUNDING _ $86,607 $137,958 $166,607 $136,607 $186,607 $136,607 LIQUOR STORE FUNDING $0 $0 F $0 $D $0 $0 TAX LEVY FUNDING v $0 $5,000 $5,000 $5,000 $5,000 f $100,000 ENDING BALANCE $18,571 $161,529 $333,136 $474,743 $666,350 $902,957 FUNDING TARGET BUILDING MAINTENANCE 2020 PROJECTS FIRE STATION#1 TBD $0 RAMBLING RIVER CENTER y FEES _ TOTAL $O 4/14/2020 2030 Financial Plan Info CITY OF FARMINGTON goo -ago 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. CITY OF FARMINGTON 2030 FINANCIAL PLAN FUTURE PROJECTS CIP --._._...._._.._.____._...._...... __ 2020 2021 2022 2023 2024 2025 ARENA PHASE ONE $280,000 $0 $0 $0 $0 $0 ARENA PHASE TWO $0 $2,000,000 $0 $0 $0 $0 SIDEWALKS $0 $300,000 $0 _$0 $0 $0 FUEL STATION _$0 $150,000 $0 $0� $0 $0 SALT SHED $0 $250,000 $0 $0_ $0 $0 PARKING LOTS $0 $0 $325,000 '$0 $0 $0 LIQUOR STORE $0 $0 $0 $1,500,000 $0 $0 TOTAL $280,000 $2,700,000 $325,000 $1,500,000 $0 $0 REVENUE _ STARTING BALANCE $0 $0 $0 $0 _ $0 $0 TOTAL ANNUAL EXPENDITURES $280,000 $2,700,000 $325,000 $1,500,000 $0 $0 LIQUOR STORE FUNDS $280,000 $0 $0 $750,000 $0 $0 TAX LEVY $0 $300,000 $325,000 $0 $0 $0 DEBT _ $0 $2,000,000 $0 $750,000 $0 $0 OTHER SOURCES $0 $400,000 $0 $0 $0 $0 YEAR END BALANCE $0 $0 $0 $0 $0 $0 FUTURE CIP DEBT REPAYMENTS 2020 2021 2022 2023 2024 2025 ARENA PHASE TWO $252,000 $252,000 $252,000 $252,000 $252,000 LIQUOR STORE $189,000 $189,000 $189,000 BOND PAYMENTS $252,000 1 $252,000 1 $252,000 1 $252,000 1 $252,000 4/14/2020 2030 Financial Plan Info CITY OF FARMINGTON Park mprovement CIP This CIP tracks planned park build outs and improvements to the city's park system. CITY OF FARMINGTON 2030 FINANCIAL PLAN PARK IMPROVEMENT CIP PROJECT 2020 2021 2022 2023 2024 2025 DAKOTA ESTATES PARK DAISY KNOLL PARK DEPOT WAY ARTS PARK _ EVERGREEN KNOLL PARK _$325,000 FAIR HILLS PARK FARMINGTON PRESERVE PARK FLAGSTAFF MEADOW T T $7,500 $100,000 HILL DEE PARK HILLVIEW PARK JIM BELL PARK AND PRESERVE $250,000 T LAKE JULIA PARK MARIGOLD PARK MEADOWVIEW PARK $100,000 MIDDLE CREEK PARK NORTH CREEK PARK PINE KNOLL PARK $5,000 PRAIRIE PINES PARK PRAIRIE VIEW PARK I _ PRAIRIE WATERWAY $3,000 RAMBLING RIVER PARK $30,000 $20,000 $40,000 $25,000 $195,000 SILVER SPRINGS PARK TAMARACK PARK TROY HILL PARK VERMILLION GROVE PARK VRC TOWN SQUARE $10,000 WESTVIEW ACRES PARK $6,000 TOTAL $39,000 $7,500 $120,000 $145,000 $275,000 $530,000 FUNDING/FUND BALANCE 2020 2021 2022 2023 2024 2025 STARTING BALANCE $292,582 '$361,827 $462,730 $451,133 $414,693 $339,693 ANNUAL PROJECT COSTS $39,000 $7,500 $120,000 $145,000 $275,000 $530,000 TAX LEVY $0 $0 $0 $0 $100,000 $100,000 FARM LEASE $8,245 $8,403 $8,403 $8,560 $0 $0 PARK DEDICATION/PARK DEV FEES $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 LIQUOR STORE FUNDING $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 YEAR END BALANCE $361,827 $462,730 $451,133 $414,693 $339,693 $9,693 FUNDING TARGETS PARK IMPROVEMENT FUND 4/14/2020 2030 Financial Plan Info CITY OF FARMINGTON Hu an Resources CIP This CIP tracks potential added staff positions needed due to work volumes and increased population. 4/14/3020 2030 Financial Plan Info CITY OF FARMINGTON City Tax Rate History and Dakota County Cities Comparison FARMINGTON CITY TAX RATE BY YEAR 80 70 66.82 65.87 63.09 61.45 60 59.23 58.76 57.16 55.7 54.37 50.73 49.2 50 40 30 20 10 0 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Dakota County City Tax Rates 80.00 70.00 60.00 v Y 50.00 X0-00 _ 40.00 30.00 20.00 2010 2011 2012 2013 2014 2015 2016 APPLE VALLEY 39.86 42.38 44.11 49.21 47.89 45.27 44.72 BURNSVILLE 38.56 42.59 43.21 47.02 46.67 44.79 46.52 CITY OF FARMINGTON Ut '11 *1ty CIP This CIP tracks the four utility funds. These funds stand on their own and are funded by fees paid by users. QTY OF FARMINGTON Utility Funds Current and Future Debt CITY OF 0 430 Third St., Farmington, MN 55024 FARMINGTON © 651-28o-6800 'I O Farmington M N.gov TO: Mayor, Councilmembers and City Administrator FROM: Gary Rutherford, Chief of Police SUBJECT: Law Enforcement Reform Legislation DATE: August 10, 2020 INTRODUCTION The death of George Floyd while in the custody of officers with the Minneapolis Police Department prompted the State Legislature to pass a number of new laws intended to reform Minnesota Law Enforcement. DISCUSSION Chief Rutherford will provide the city council with a summary of the new laws and their anticipated impact on Farmington Police Department operations. BUDGET IMPACT None of the new laws appear to have any local budget impact. ACTION REQUESTED Presentation is being provided for information and discussion purposes only. Ask any questions you may have. No other action is required or requested.