Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
2.1b Budget - Targets Calendar Revenue Estimating
2023Budget Study Session May 9, 2022 2023 Budget Calendar/2023 Target Fund Balances/2023 Revenue Estimating/ Budget Goals Staff Budget tasks Completed to date: Directed staff to budget to 2022 Budget numbers ► Departments provided itemized lists of line item requests greater than $5,000 and including multiple purposes (ie... Other Contractual) Departments submitted Operational, CIP and Sub-CIP requests Need to complete: Finance/City Manager meet will all departments to review requests Receive Pay Plan ► City Commission Report and Recommended Approach ► Finalize Personnel Calculations ► Finalize Revenue Estimates ► Net Income (Loss) analysis for each fund Mill Rate Deliberations Balance Budget 2023 Budget City Commission Calendar Statutory Dates 6/15/22 County provides Valuations to City 7/20/22 City notifies County regarding intent of Revenue Neutral Rate If exceeding Revenue Neutral Rate: 9/10/22 Place notice of Tax Rate and Budget Public Hearing in newspaper 9/20/22 Last date to conduct Tax Rate and Budget Public Hearing 10/1/22 Certify Budget to County Clerk If not exceeding Revenue Neutral Rate: 8/05/22 Place notice of Public Hearing in newspaper 8/15/22 Last date for Public Hearing 8/25/22 Certify Budget to County Clerk 5/9/22 Study Session: Calendar, Fund Balances Et Target Fund Balances, Revenue Estimating Discussion 5/16/22 Study Session: Pay Plan/Personnel 6/6/22 Study Session: CIP, Sub-CIP, Comprehensive Fee Schedule, Revenue Estimates 6/13/22 Study Session: Outside Agencies, 2023 Preliminary Budget Numbers 6/27/22 Study Session: Issues and Options 7/11/22 Study Session: Draft 2023 Budget City Commission Action: establish maximum mill rate 7/18/22 or 8/22/22 City Commission Action: Set Public Hearing Date 8/15/22 or 9/19/22 City Commission Action: Hold Budget Public Hearing or Tax Rate and Budget Public Hearing 8/22/22 or 9/26/22 City Commission Action: Adopt Budget Fund Balance (Reserves) Purpose (Financial Policy adopted 01 /03/2022) Maintain Working Capital 1. Meet cash flow requirements. 2. Provide contingencies for unpredictable revenue sources. 3. Provide contingencies for emergencies (such as natural disasters) and unpredictable expenditures. Fund Capital Asset Replacement and Debt Retirement 4. Provide funding for capital asset replacement. 5. Meet debt reserve covenants/ requirements. 6. Prepay outstanding debt. 7. Secure and Maintain Investment Grade Credit Ratings Per Financial Policy - "to maintain a minimum reserve between 5% and 10% of budgeted annual expenditures for the following funds: Arts and Humanities Fund Sales Tax Capital Fund Sales Tax Economic Development Fund Special Parks and Recreation Fund Special Gas Fund Sanitation Fund Solid Waste Fund Golf Fund Workers' Compensation Fund* Central Garage Fund The following funds are not required to maintain a reserve: Business Improvement District Fund Tourism and Convention Fund Special Alcohol Fund Neighborhood Parks Fund Tony's Pizza Event Center Fund Former Schilling Airforce Base Environmental Fund" Resolution No. 22-8025 (2/28/22) established Workers' Compensation Fund Management Policy 2021 Results 2023 Target Fund Balances 100 -General Fund Beginning Fund Balance Revenue Expense Prior Year Adjustments Net Income(Loss) 100 -General Fund Ending Fund Balance 500 -Bond and Interest Beginning Fund Balance Revenue Expense Net Income(Loss) 500 -Bond and Interest Fund Ending Fund Balance 200 -Arts and Humanities Beginning Fund Balance Revenue Expense Net Income(Loss) 200 -Arts and Humanities Ending Fund Balance 210 -Sales Tax Capital Beginning Fund Balance Revenue Expense Net Income(Loss) 210 -Sales Tax Capital Ending Fund Balance 220 -Sales Tax Economic Development Beginning Fund Balance Revenue Expense Net Income(Loss) 220 -Sales Tax Economic Development Ending Fund Balance 230 -Business Improvement District Beginning Fund Balance Revenue Expense Net Income(Loss) 230 -Business Improvement District Ending Fund Balance 2019 Actual 4, 615, 726.15 43,953,627.04 41, 551,143.10 1,066.24 2,402,483.94 7,019,276.33 1, 801, 968.01 6,237,205.73 6, 949, 849.42 (712,643.69) 1,089,324.32 2020 Actual 7,019, 276.33 43, 538,168.08 37, 671, 245.91 608.57 5, 866, 922.17 12, 886, 807.07 1,089, 324.32 7, 659, 054.31 7, 082, 778.73 576, 275.58 1, 665, 599.90 2021 2022 Target Fund Actual Budget Balance 12,886,807.07 18,518,328.56 45,393,367.76 45,064,539.18 39,639,373.50 45,039,563.06 (122,472.77) 993,016.55 5,753,994.26 24,976.12 18, 518, 328.56 18, 543, 304.68 10, 000, 000 1, 665, 599.90 13, 279, 510.78 13, 414, 879.11 (135, 368.33) 1, 530, 231.57 1, 530, 231.57 7, 210, 694.00 6, 701, 000.00 509,694.00 2, 039, 925.57 1,705.77 49, 763.67 100, 065.80 151, 407.88 1, 040, 274.04 544, 327.71 908, 875.93 1, 008, 500.00 992,216.14 494,025.58 857,533.85 993,016.55 48,057.90 50,302.13 51,342.08 15,483.45 49, 763.67 100, 065.80 151, 407.88 166, 891.33 100,000 1, 366, 528.93 8,481,164.51 8,172,408.59 308, 755.92 1,675,284.85 1, 675, 284.85 8,857,133.78 4,875,160.75 3, 981, 973.03 5, 670, 747.76 5, 670, 747.76 9,639,452.49 7, 091, 002.25 2, 548, 450.24 8, 290, 979.72 8, 290, 979.72 9, 020, 000.00 11,413,850.00 (2, 393, 850.00) 5, 968, 911.44 750,000 897,484.85 708,563.28 715,686.21 97,354.76 344, 975.89 351, 837.48 391,195.26 1,116, 000.00 533, 897.46 344, 714.55 1, 009, 526.71 1, 045, 000.00 (188,921.57) 7,122.93 (618,331.45) 71,000.00 708, 563.28 715, 686.21 97, 354.76 168, 354.76 750,000 6,160.68 83, 700.78 85, 200.78 (1,500.00) 4,660.68 4,660.68 79, 532.54 73,175.99 6,356.55 11,017.23 11,017.23 95, 808.63 103, 425.63 (7,617.00) 3,400.23 3,400.23 90, 000.00 90, 000.00 3,400.23 2022 Beginning Fund Balance 2019 2020 2021 Balance 852.64 Actual Actual Actual 1,657,669.22 1,916,000.00 1, 754, 000.00 Expense 1,348,775.26 852.64 1,306,632.33 Goat to _ for Beginning Fund Balance 852.64 852.64 852.64 542,381.51 FAnnuat Ptayground Revenue 1,895,818.41 1,294,360.48 1,895,800.00 351,036.89 Reptacement Expense 1,895,818.41 1, 294, 360.48 1, 895, 800.00 2,330,508.35 1,373,315.35 Net Income(Loss) - - - 233.69 240 -Tourism and Convention Ending Fund Balance 852.64 852.64 852.64 Special Parks and Recreation Fund - KSA 17-41a04 250 -Special Parks and Recreation Sec. 36-81 - for acquisition and improvement of Revenue 4,500.00 5,070.00 10,300.00 - Liquor Drink Tax - for the purchase, Beginning Fund Balance 128,181.58 348,865.79 465,772.43 establishment, maintenance or expansion of park Revenue 227,304.46 171,981.61 227,126.99 and recreational services, programs and Expense 6,620.25 55,074.97 447,704.49 facilities. Net Income(Loss) 220,684.21 116,906.64 (220,577.50) J90-TPEC 250 -Special Parks and Recreation Ending Fund Balance 348,865.79 465,772.43 245,388.32 Special Alcohol Fund - KSA 17-41a04 - Liquor 260 -Special Alcohol 97,680.92 199,982.59 Drink Tax - for the purchase, establishment, Beginning Fund Balance 233.69 233.69 233.69 maintenance or expansion of services or programs Revenue 227,304.46 171,981.61 227,126.99 whose principal purpose is alcoholism and drug Expense 227,304.46 171,981.61 227,126.99 abuse prevention, education, detoxification or Net Income(Loss) - - - intervention 260 -Special Alcohol Ending Fund Balance 233.69 233.69 233.69 2022 Beginning Fund Balance Target Fund Budget 1,437,089.95 I Balance 852.64 Revenue 2,019,141.41 1, 754, 000.00 1,657,669.22 1,916,000.00 1, 754, 000.00 Expense 1,348,775.26 852.64 1,306,632.33 2,873,193.00 245, 388.32 Prior Year Adjustments 174,000.00 542,381.51 174,000.00 Net Income(Loss) 670,366.15 245,511.77 351,036.89 50,000 233.69 270 -Special Gas Ending Fund Balance 1,794,474.21 174,000.00 2,330,508.35 1,373,315.35 174,000.00 280 -Neighborhood Park Development 233.69 Neighborhood Park Fund - City Ordinance 36.111 Beginning Fund Balance Special Gas Fund - KSA 79-3425c - Gas Tax - for Beginning Fund Balance 1,124,108.06 1,794,474.21 I 1,437,089.95 I 2,330,508.35 the construction, reconstruction, alteration, Revenue 2,019,141.41 2,231,335.84 1,657,669.22 1,916,000.00 repair and maintenance of streets and highways Expense 1,348,775.26 2,571,504.66 1,306,632.33 2,873,193.00 Prior Year Adjustments 542,381.51 Net Income(Loss) 670,366.15 (340,168.82) 351,036.89 (957,193.00) 270 -Special Gas Ending Fund Balance 1,794,474.21 1,437,089.95 2,330,508.35 1,373,315.35 280 -Neighborhood Park Development Neighborhood Park Fund - City Ordinance 36.111 Beginning Fund Balance 24,250.51 28,750.51 33,820.51 44,120.51 Sec. 36-81 - for acquisition and improvement of Revenue 4,500.00 5,070.00 10,300.00 5,000.00 neighborhood park in park service are in which Expense - - - 10,000.00 fee was collected Net Income(Loss) 4,500.00 5,070.00 10,300.00 (5,000.00) 280 -Neighborhood Park Development Ending Fund Balance 28,750.51 33,820.51 44,120.51 39,120.51 J90-TPEC Beginning Fund Balance 97,680.92 199,982.59 132,954.27 643,173.22 Revenue 765,915.94 646,376.28 736,873.92 _710,400.00 Expense 663,614.27 713,404.60 701,823.33 _925,000.00 Net Income(Loss) 102,301.67 (67,028.32) 35,050.59 (214,600.00) 290-TPEC Ending Reserved Fund Balance 175,000.00 474,671.40 299,671.40 290-TPEC Ending Unreserved Fund Balance 199,982.59 132,954.27 168,501.82 128,901.82 295-FormerSAFB Environmental Beginning Fund Balance - - - 61,607,416.49 Revenue - - 67,958,791.79 25,000.00 Expense - 6,351,375.30 60,000,000.00 Net Income(Loss) 29 F SAF. EI E d; B I - - 61,607,416.49 61 607 416 A. (59,975,000.00) 1 632 416 49 5- ormer nvironmenta n ing a ance - -I I I I - Beginning Fund Balance Revenue Expense Net Income(Loss) 300 -Sanitation Ending Fund Balance 320 -Solid Wast Beginning Fund Balance Revenue Expense Net Income(Loss) 320 -Solid Waste Ending Fund Balance 340 -Golf Beginning Fund Balance Revenue Expense Net Income(Loss) 340 -Golf Ending Fund Balance Beginning Fund Balance Revenue Expense Prior Year Adjustme Net Income(Loss) 370-Water/Wastewat 410 -Workers' Compensation Beginning Fund Balance Revenue Expense Net Income(Loss) 410 -Workers' Compensation Ending Fund 420 -Health Insurance Beginning Fund Balance Revenue Expense Net Income(Loss) 420 -Health Insurance Ending Fund 2019 Actual 1,468,134.37 3, 233, 700.50 2,970,965.72 262, 734.78 4,018,544.67 3,489,732.79 2,995,683.86 494,048.93 4,512,593.60 50,211.24 907,198.30 935, 700.47 (28, 502.17) 21, 709.07 2020 2021 2022 Actual Actual Budget 1 MII i 1, 730, 869.15 2,154, 860.13 974, 391.40 3,292,549.64 3,408,713.66 3,229,000.00 2, 868, 558.66 4,589,182.39 3, 392, 575.68 423,990.98 (1,180,468.73) (163,575.68) 2.154.860.13 974.391.40 .810.815.72 4,512,593.60 1 5,416,652.99 3, 322, 294.37 L 3, 570, 863.77 2,439,871.33 2,762,185.88 882,423.04 808,677.89 5,416,652.99 6,225,330.88 21,709.07 45,761.05 780,055.79 888,051.82 752, 553.81 852, 914.58 27, 501.98 35,137.24 45,761.05 80,898.29 6,225,330.88 3,093,000.00 3,025,408.20 67,591.80 6,292,922.68 80,898.29 882,000.00 850,109.81 31,890.19 112,788.48 21,911,511.97 Lu,3ul, LLl.1/ LL,4/0,74/.41 Lu, 7325, 713. L0 20,113,100.00 18,780,904.31 17,352,810.07 16,811,149.40 24,310,071.89 nts 13,040.10 1,520,316.86 5,124,137.34 4,127,763.86 (4,196,971.89) er Ending Fund 12,599,495.67 17,770,708.01 21,911,511.97 17,714,540.08 450 -Central Garage Target Fund Balance 500,000 O ° 500,000 100,000 5,000,000 957,863.12 933,943.31 1,013,032.04 942,222.76 312,960.50 6,572,257.16 449,926.00 251,279.15 250,100.00 336,880.31 5,815,054.29 370,837.27 322,088.43 430,418.00 (23,919.81) 182,199.00 79,088.73 (70,809.28) (180,318.00) 933,943.31 80,686.86 1,013,032.04 942,222.76 761,904.76 750,000 3,112,407.26 2,188,453.03 3,216,150.31 3,853,725.26 6,104,975.55 6,572,257.16 6,452,629.24 7,318,499.00 7,028,929.78 5, 544, 559.88 5,815,054.29 7,136,300.00 (923,954.23) 1,027,697.28 637,574.95 182,199.00 2,188, 453.03 3,216,150.31 3, 853, 725.26 4, 035, 924.26 2,000,000 Beginning Fund Balance 54,128.13 154,658.64 313,738.79 394,425.65 Revenue 1,574,530.43 1,353,229.75 1,628,625.99 1,514,400.00 Expense _ 1,473,999.92 1,194,149.60 1,547,939.13 1,504,199.79 Net Income(Loss) 100,530.51 159,080.15 80,686.86 10,200.21 450 -Central Garage Ending Fund Balance 154,658.64 313,738.79 394,425.65 404,625.86 100,000 REVENUES Motor Vehicle Tax 3% Municipal Court 2% Interfund Franchise Fees 3% Fees & Charges 3% Interfund Service Transfers 8% EMS 7% Franchise Fees Exter 12% Property Tax Stabilization 2% Property Tax 25% Sales & Use Tax 35% Top 83% of General Fund Revenue EMS, 2,976,174.09 Interfund Service Transfers, 3,366,550.00 Franchise Fees Exter, 5,201,051.62 ■ Sales & Use Tax ■ Sales & Use Tax ■ Property Tax ■ Franchise Fees Exter Interfund Service Transfers ■ EMS ■ Fees & Charges ■ Interfund Franchise Fees ■ Motor Vehicle Tax ■ Municipal Court ■ Property Tax Stabilization 2021 Top 10 General Fund Revenues by Type > $1M each (97% of Total Revenue) Property Tax, 10,820,523.99 Property Tax Franchise Fees Exter Sales & Use Tax, 15,314,663.69 Interfund Service Transfers ■ EMS General Fund 40% Debt Kenwood Cove Maint $1,773,145 ja 1 $68,350 City Sales Tax 1.25% Sales Tax Capital Fund 60% Sales Tax Capital Fund 96.1 Capital Spending $1,549,200 Parks Maint $890,900 Sales Tax Economic Development Fund 3.9%4M Streets $3,200,000 Tax Stabilization $1,000,000 County (Jail Project) 1 County Sales Tax 1.5% Split by Population Et Prope Tax Levy City of Salina (-z60%) General Fund (100%) General Fund Sales Tax Revenue History 10,000,000.00 9,000,000.00 8,000,000.00 7,000,000.00 6,000,000.00 5,000,000.00 4,000,000.00 4020 - Sales Tax -Co 3,000,000.00 4022 - Sales Tax -Cit 2,000,000.00 1,000,000.00 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 4020 -Sales Tax -Countywide 6,924,075. 6,932,831. 7,133,378. 7,272,266. 7,226,044. 7,256,208. 7,372,045. 7,521,719. 7,714,199. 8,627,565. 4022 - Sales Tax -City 5,241,205. 5,326,723. 5,555,601. 5,658,545. 5,554,846. 5,649,823. 5,745,497. 5,897,023. 6,052,082. 6,687,098. 14.00% 12.00% 10.00% 8.00% 6.00% 4.00% 2.00% 0.00% -2.00% -4.00% % Growth General Fund Sales Tax Revenue Avg Co. 2.53% W, City 2.�9% 2012 2013 2014 2015 2016 2017 2018 2019 • Growth County Sales Tax 0.13% 2.89% 1.95% -0.64% 0.42% 1.60% 2.03% • Growth City Sales Tax 1.63% 4.30% 1.85% -1.83% 1.71% 1.69% 2.64% 2020 2021 2022 To Date 2.56% 11.84% 12.92% 2.63% 10.49% 12.59% % Growth County Sales Tax % Growth City Sales Tax General Fund Sales Tax Revenue was not affected by increase in 2016. That increase only affected Sales Tax Capital Fund Possible effects to Future Sales Tax Collections: • Housing Starts • Employer Expansions • Broader Economic Forecast 13 40.00% 35.00% 30.00% 25.00% 20.00% 15.00% 10.00% 5.00% 0.00% ' Jan Feb Mar I I -5.00 -10.00% 11 ' Apr 1 201 Total City Sales Tax Growth by Month Rate change 2022 Year End Projection = 10% Assumes growth is maintained 2023 Budget 2% growth on 202 *see 2021 actual on slide 12 Property Tax General Fund $ 10, 712, 234 Bond Et Interest $ 370557923 Fund `Maximum allowable Property Tax Revenue without Tax Rate Hearing What are SB 13 and HB 2104? During the 2021 legislative session, the tax lid was removed and the legislature enacted SB 13 and HB 2104. This legislation establishes new notice and public hearing requirements if the proposed budget will exceed the property tax levy's revenue neutral rate. These requirements take effect this year (2021), for a city's 2022 budget. What is a Revenue Neutral Rate (RNR)? The tax rate in mills that would generate the same property tax revenue in dollars as levied the previous tax year using the current tax year's total assessed valuation. How is the Revenue Neutral Rate Calculated? To calculate the revenue neutral rate, the County Clerk shall divide the property tax revenue for such taxing subdivision levied for the previous tax year by the total of all taxable assessed valuation in such taxing subdivision for the current tax year, and then multiplythe quotient by 1,000 to express the rate in mills. (5B 13 Sec. 1(e)(2)) What is a Tax Rate Hearing? A Tax Rate Hearing is a hearing to exceed the Revenue Neutral Rate (RNR). RNR = Last year's total property tax raised in dollars This year's assessed valuation as of June 15 Year -to -Year RNR Sample Calculation 2021 Budget - City Levied $900,000 in property tax • Assessed Valuation of property = $29,000,000 Value of one mill = $29,000 • Mill Rate=( $900,000 31.034 mills $29,000,000 } x 1,000 x 1,000 2022 Budget In 2021 budget, City levied $900,000 • Assessed Valuation changes to $31,440,400 - Value of one Mill = $31,000 x 1,000 • Revenue Neutral $900,000 Rate = 29.032 Mills ( $31,400,000 } 2022 City of Salina 1 Mill = $4521800 City's Total Mill Rate = 30.452 Fiscal (Budget) Year 1 City of Salina County 2013 26.190 34.823 2014 26.927 37.895 2015 27.080 38.047 2016 27.311 38.275 2017 27.603 37.508 2018 26.129 37.321 2019 28.394 38.437 2020 29.719 41.097 2021 30.650 40.606 2022 30.452 39.782 160.000 140.000 120.000 100.000 80.000 60.000 40.000 20.000 Total Mill Rate History 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 State of Kansas 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 ■ Library ■ USD 305 1 Salina Airport Authority ■ Extension District State of Kansas ■ County ■ City of Salina Extension District Salina Airport Authority USD 305 1.176 4.007 58.649 1.176 4.504 58.116 1.285 4.486 55.605 1.502 4.396 56.12 1.51 4.396 55.743 1.475 4.992 56.501 1.476 4.998 57.522 1.198 5.372 55.508 1.206 5.037 55.454 1.196 4.838 54.903 35.000 30.000 25.000 20.000 15.000 10.000 5.000 0.000 Library Total 5.452 131.797 5.761 135.879 6.034 134.037 5.895 134.999 5.893 134.153 in 5.989 133.907 6.014 138.341 5.913 140.307 5.88 140.333 6.028 138.699 City of Salina Mill Rate History 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 ■ Debt Service Millage 5.948 6.388 6.388 7.361 5.909 5.790 6.109 6.812 6.803 6.759 0 General Fund Millage 20.242 20.539 20.692 19.950 21.694 20.339 22.285 22.907 23.847 23.693 % Growth in Assessed Valuation by Budget Year 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Tax Stabilization Transfers (General Fund and Debt Service) Total Mill Rate Levied by City Total Assessed Valuation Mill Rate Increase Averted by Tax Stabilization Transfer 2013 2,150,000 26.190 402,597,689.000 5.34 2014 1,710,000 26.927 404,905,202.000 4.22 Fiscal (Budget) lGeneral Fund Debt Service Year Millage Millage Total City Millage Imill 2010 20.082 5.773 25.855 2011 19.236 6.786 26.022 2012 20.326 5.946 26.272 2013 20.242 5.948 26.190 2014 20.539 6.388 26.927 2015 20.692 6.388 27.080 2016 19.950 7.361 27.311 2017 21.694 5.909 27.603 2018 20.339 5.790 26.129 2019 22.285 6.109 28.394 2020 22.907 6.812 29.719 2021 23.847 6.803 30.65 2022 23.693 6.759 30.452 Increase Since 2016 2015 2016 2017 2018 2019 1,710,000 2,360,000 2,500,000 2,500,000 2,500,000 27.080 27.311 27.603 26.129 28.394 407,875,142.000 416,174,805.000 422,390,632.000 427,687,062.000 430,868,298.000 4.19 5.67 5.92 5.85 5.80 ry Increase A 0.65% 0.96% -0.31% 2.81% 0.57% 0.85% 1.07% -5.34% 8.67% 4.67% 3.13% -0.65% 11.50% 2020 2,736,000 29.719 446,561,516.000 6.13 1.47% -1.60% 1.56% 0.57% 0.73% 2.03% 1.49% 1.25% 0.74% 3.64% 0.67% 0.72% 8.80% 2021 2,625,000 30.65 449,553,340.000 5.84 im 2022 2,625,000 30.452 452,800,226.000 5.80 Franchise Fees Franchise Fees -Gas 1,200,000.00 1,000,000.00 800,000.00 600,000.00 400,000.00 200,000.00 0.00 2016 2017 2018 2019 Franchise Fees -Gas 799,288.01 869,623.13 954,683.67 971,803.07 5 yr avg growth: 6.19% Budget 2% growth over 2021 5 yr avg growth: +6.19% 2020 2021 863, 516.05 1, 050, 868.05 3,900,000.00 3,800,000.00 3,700,000.00 3,600,000.00 3,500,000.00 3,400,000.00 3,300,000.00 Franchise Fees - Electric 3,200,000.00 2016 2017 2018 2019 2020 2021 Franchise Fees- Electric 3,650,651.37 3,701,498.19 3,834,073.22 3,485,366.09 3,439,056.03 3,549,439.84 5 yr avg growth: -.45% Budget 0% growth over 2021 Iij Franchise Fees - Cable 560,000.00 550,000.00 540,000.00 . 530,000.00 \ 520,000.00 510,000.00 500,000.00 490,000.00 480,000.00 470,000.00 460,000.00 2016 ,Franchise Fees - Cable 531,028.42 5 yr avg growth: -1.47% Budget 0% growth over 2021 .................. 2017 2018 2019 2020 2021 522,107.02 547,630.43 529,075.05 515,175.68 491,790.64 Interfund Transfers 7,000,000 6,000,000 6118181118181f, 4,000,000 t 111 88t 1,000,000 ■ Water/Wastewater Solid Waste ■ Sanitation ■ Sales Tax Capital Fund 0 2017 3,400,000 380,000 346,500 500,000 Interfund Transfers to General Fund 2018 3,600,000 480,000 461,500 500,000 No change to 2023 budget 2019 3,600,000 480,000 461,500 1,908,000 2020 2021 3,839,750 31839,750 499,200 499,200 467,350 467,350 1,000,000 11000,000 I Water/Wastewater Solid Waste Sanitation Sales Tax Capital Fund Transfer Types: Overhead PILOT - payment in lieu of taxes Computer Technology Franchise Fee Risk Management Tax Stabilization EMS Total EMS Revenue 3,000,000.00 2,500,000.00 2,000,000.00 1,500,000.00 1,000,000.00 500,000.00 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 —Total EMS Revenue 2,058,957.08 2,246,047.89 2,205,636.35 2,069,971.36 2,608,846.86 2,266,903.24 2,436,042.80 2,527,249.21 2,406,230.72 2,396,652.23 10 yr avg growth: 2.23% Budget average $ collection over past 5 years Unspent project funds from sales tax capital fund Parks Streets V&E B&F CIP 2021 Budget 500, 000.00 3, 200, 000.00 930, 000.00 270, 500.00 100, 000.00 5, 000, 500.00 2021 Actual $ 109, 034.00 $ 3, 223, 860.21 $ 859, 090.14 $ 142, 667.90 $ 63, 000.00 $ 4, 397, 652.25 Parks Maintenance Reserve Fund Buildings Et Facilities Reserve Fund Remaining $ 390, 966.00 $ (23, 860.21) $ 70, 909.86 $ 127, 832.10 $ 37, 000.00 $ 602,8 $ 2519,934 934 $ 390X0 $ 870500 $ 127, 800 Vehicle Et Equipment Reserve Fund $ 500,000 $ 70,900 2023 Budget Initiatives • Transfer 2021 unspent funds from Sales Tax Capital fund for • Parks $ 390,900 • Building and Facilities $ 127,800 • Vehicles and Equipment $ 70,900 • Address the Pay Plan Study From 2022 Budget Discussions: Available Fund Balance Organizational Increase General Fund Target Balance Agenda Mgmt SINN City Web site Time & Attendance S/W and H/W Temporary Grant Coordinator Pay Plan Implementation Facility Audit Replenish Eco/Devo Fund Subtotal After In -House Costs * Require future recurring expenses $492009000 (1,500,000) (50,000)* (50,000)* (100,000)* (30,000) (1,000,000)* (50,000) (250,000) $ 670,000 Operational Available Fund Balance Vehicles & Equipment Parks Master Plan River Renewal Project* Debt Service Reserve Fire Station #4 Station Alerting Facility Audit Implementation /Childcare Proposed Projects/Initiatives Baseball Enterprise Subtotal Housing - Infill Housing Infrastructure Hotel Grant Proposal (Chamber) Remaining Available *May partially qualify under Category D **Debt Financed ***Assumes Transient Guest Tax supports $2,500,000 $ 7,061,942.49 (500,000) (500,000) (500,000) (500,000) .r nnn nnn. (500,000) (1,000,000) TBD (155005000)*** (1,000,000) (1,000,000) to Qnn nnn. , V. VWV. mmm l .p iZ,.r7VV,VVV (A n n n"'7 I[' 7 1 1 ,`kJO,UU 1 .:J 1) $7,000,000 $ 61, 942.49 2022 Year End Projections City of Salina Mar -22 Updated as of 03/01/2022 Fund: 100- General Fund Montl- Revenues: Property Taxes Motor Vehicle Tax Sales and Use Tax Franchise Fees Rev Other Taxes Grants Investment Income EMS Municipal Court Fees and Charges Licenses and Permits Interfund Transfers Rev Other Revenues Total Revenues: Expenditures: Personnel Services Employee Benefits - Health & WC Commodities Contractual Services Capital Outlay Interfund Transfers Exp Other Expenses Contingency Total Expenditures: Net Income (Loss): Beginning Fund Balance: Net Income (Loss): Fund Balance Adj: Ending Fund Balance: 2022 2021 YTD Actual YTD Actual YTD Difference 3 3 3 6,275,854.07 6,330,545.17 (54,691.10) 348,970.55 336,190.04 12,780.51 4,211,889.80 3,716,783.07 495,106.73 1, 496, 025.99 1,316,114.96 179, 911.03 59,901.03 50,460.04 9,440.99 6,310.63 74,200.66 (67,890.03) 3,578.13 15,122.55 (11,544.42) 941,920.65 764,627.74 177,292.91 261,497.54 281,000.17 (19,502.63) 312,087.97 279,863.39 32,224.58 115,922.95 171,847.13 (55,924.18) 217,526.48 89,834.84 127,691.64 14,251,485.79 13,426,589.76 824,896.03 6,116,068.31 5,881,839.33 234, 228.98 875,755.00' 889,237.77 (13,482.77) 518,862.46 397,768.25 121,094.21 1,336,333.39 1,501,148.42 (164,815.03) 118,128.10 244,538.26 (126,410.16) 1,755,336.37 5,906.89 1,749,429.48 (108.00) (108.00) 17,800.00 10,720,375.63 8,920,330.92 1,800,044.71 3,531,110.16 4,506,258.84 (975,148.68) 18,518,328.56 (34,319,187.43) 24,976.12 3,531,110.16 18,518,328.56 22,049,438.72 24,976.12 Increased Sales Tax Collection High Vacancy Rates 2021 Actual (Unaudited) 10,820,523.99 1,258,271.49 15,314,663.69 6,640,801.62 227,126.99 122,530.01 84,500.57 2,976,174.09 1,037,609.74 1,459,149.13 714,274.72 4,366,550.00 371,191.72 45,393,367.76 26,042,070.49 3,744,414.48 1,949,719.43 6,197,221.86 644,071.92 943,877.56 3,713.76 114,284.00 39,639,373.50 5,753,994.26 12,742,990.17 5,753,994.26 21,344.13 18,518,328.56 2022 % of 2022 Budget Budg (2022 2022 YTD Actual (Original) YTD/2022) 2022 Budg 10,859,513.18 57.8% (4,583,659.11) 1,256,306.00 27.8% (907,335.45) 14,322,000.00 29.4% (10,110,110.20) 6,681,750.00 22.4% (5,185,724.01) 174,000.00 34.4% (114,098.97) - F #DIV/0! 6,310.63 300,000.00 1.2% (296,421.87) 3,319,000.00 28.4% (2,377,079.35) 1,146,000.00 22.8% (884,502.46) 1,630,810.00 19.1% (1,318,722.03) 603,610.00 19.2% (487,687.05) 4,366,550.00 0.0% (4,366,550.00) 405,000.00 53.7% (187,473.52) 45,064,539.18 31.6% (30,813,053.39) 27,817,264.92 22.0% (21,701,196.61) 4,362,203.69 20.1% (3,486,448.69) 2,153,683.00 24.1% (1,634,820.54) 7,648,748.45 17.5% (6,312,415.06) 780,013.00 15.1% (661,884.90) 1,684,850.00 104.2% 70,486.37 17,800.00 0.0% (17,800.00) 575,000.00 0.0% (575,108.00) 45,039,563.06 23.8% (34,319,187.43) 24,976.12 18,518,328.56 24,976.12 18, 543, 304.68 3 yr avg 58.29% 27.26% 24.67% 25.00% 24.79% 40.08% 91.67% 27.27% 27.97% 25.93% 20.54% 0.00% 26.20% 2022 Year End Projection 3 yr avg col I to date 10, 766, 692.68 1,280,064.41 17,071,569.14 5,984,103.96 241,631.16 15, 747.03 3,903.27 3,453,930.15 934,859.77 1,203,423.11 564, 365.92 4,366,550.00 830, 341.73 46,717,182.33 26,504,022.84 4,045,090.14 2,153, 683.00 7, 648, 748.45 780,013.00 1,684,850 "" 17,80( 575,00( 43,409,20, 3,307,97 18,518,32E 3,307,97' 21,826,30- (92,820.50) 23,758.41 2,749,569.14 (697,646.04) 67,631.16 15,747.0 (296,096.7 134,930.15 (211,140.23) (427,386.89) (39,244.08) 425,341.73 1,652,643.15 (1,313,242.08) (317,113.55) Pay Plan Study (Future Study Session) • Currently being finalized • Expect Significant added annual cost $1M - $2M spread across all funds • Staffing level adjustments through attrition • Set aside $1M from 2020 General Fund Balance for implementation • 12/31/2021 $8M excess General Fund Balance of which $3.53M had previously been targeted for one time use • Leaves approximately $4.5M in excess General Fund balance Questions/comments/direction