Loading...
HomeMy WebLinkAbout10212024 City Council Work Session Packet with laydownsSeward City Council Work Session Packet Topic: Budget FY2025-2026 Motor Pool, Parking, and Water/Sewer Monday, October 21, 2024 City Council Chambers Beginning at 5:30 p.m. This packet has been modified from its original version to include two laydowns that were presented at the work session - City Clerk Dear City Council and Seward Community -- Thank you so much for your continued engagement in this year's budget discussions. It's been great to hear from different community members and stakeholders and answering questions and taking input! Due to a scheduling conflict, we've had to adjust our tentative calendar slightly. We will be discussing the Harbor and Electric on October 28. On October 22, we'll be able to dive into the Wage Study, the hospital fund, as well as continue any discussions from previous evenings, including on the general fund. • Monday, October 21 - Motor Pool, Parking, and Water/Sewer • Tuesday, October 22 -Wage Study, Hospital and continued General Fund and Enterprise Fund • Monday, October 28 - Harbor and Electric Thank you again Kat 2 City of Seward- Motor Pool Information Motor Pool Fund Policy City Charter 5.02.030 The city has established two internal service funds to account for services provided internally to city departments and employees. The motor pool fund's net position is unrestricted but allocated for the replacement of city heavy equipment and vehicles. The motor pool fund has the authority to loan money to other funds, but all amounts must be repaid with interest considered reasonable at the time of the loan. The accrued leave fund's net position is unrestricted but allocated to fund the annual liability of unpaid vacation leave due to all city employees. Motor Pool Fund Purpose: To establish a consistent funding mechanism for the replacement of the City's fleet of heavy equipment, mobile equipment, and vehicles. This mechanism minimizes the fluctuation to the annual operating budget when purchasing replacement equipment, and recognizes the annual cost of this equipment in each department' s budget. The intent is to eventually fund all City vehicles and heavy equipment through this fund. The city has funded and fully utilized the motor pool for 32 years, since 1992. Motor Pool Appropriation Policy Motor Pool reserves should be preserved for the sole intended purpose of replacing city -heavy equipment and vehicles, based on the establishment goals of minimizing fluctuations to annual operating budgets, and exercising fiscal prudence in saving for the replacement of the City's fleet. Loans from the Motor Pool to the other Funds will be repaid with interest to the Motor Pool in order to safeguard the viability of the long-range vehicle and heavy equipment replacement plan. 3 Depreciation Fund Policy The policy of the City shall be to fund a minimum of 100% of the annual depreciation rate, recognizing that failure. To establish adequate reserves for the replacement of plant and equipment shifts the financial burden of such major repairs and replacement, to future generations, creating an imbalance of international equity. Funding depreciation is defined as either placing equivalent cash into the Motor Pool or spending on capital repairs and City departments pay annual lease payments to the Motor Pool Fund for the use of vehicles and heavy equipment, with funds accumulating to finance their replacement. This funding mechanism reduces the need to borrow money to purchase equipment, saving interest costs, and reduces the impact of large purchases on the annual operating budgets by spreading the costs of the assets over their respective useful lives 4 CITY OF SEWARD MOTOR POOL FUND Budgeted Revenue and Expenditures Fiscal Year 2023,2024, 2025 and 2026 2023 2024 2025 2026 Budget Budget Budget Budget Revenue 03000-0000 General Operations $ 484,000 $ 489,000 $ 484,000 $ 489,000 Total: $ 484,000 $ 489,000 $ 484,000 $ 489,000 Non -operating revenue: $ 24,028 $ 19,589 $ 34,028 $ 29,589 Total Revenues $ 508,028 $ 508,589 $ 5I8,028 $ 5I8,589 Expenditures 03000-0000 General Operations $ I,II5,I98 $ 763,200 $ 2,332,345 $ 72I,383 Total: Transfers Out $ - $ - $ - $ - Total Expenditures $ I,I I5,I98 $ 763,200 $ 2,332,345 $ 72I,383 Revenue over expenses: $ (607,I70) $ (254,6II) $ (I,8I4,3I7) $ (202,794) Depreciation Expense: $ 380,I98 $ 386,200 $ 520,9I5 $ 56I,383 Revenue over Expenditures (less depreciation expense): $ (226,972) $ I3I,589 $ (I,293,402) $ 358,589 5 Beginning Cash Balance at I/I/24*: Cash is provided by (used for): Change in net position Add expense items not affecting cash Depreciation Net cash provided by operations Other sources (uses) of cash Loan Repayment - Principal Net increase (decrease) in cash Estimated ending cash balance CITY OF SEWARD MOTOR POOL FUND Budgeted Statement of Cash Flow For Fiscal Year 2023, 2024,2025 and 2026 2023 2024 2025 2026 Budget Budget Budget Budget $ 2,407,598 (607,I70) (324,69I) (I,8I4,3I7) (202,794) 380,I98 386,200 520,9I5 56I,383 -$226,972 $6I,509-$I,293,402 $358,589 $III,348 $II5,566 $I20,005 $I24,676 (II5,624) I77,075 (I,I73,397) 483,265 $2,29I,974 $2,469,049 $I,295,652 $I,778,9I7 * Ties to December 3I, 2023 cash and investment balance per ACFR 6 Motorpool (03000-0000) Operating Budget Revenues: Operating Revenues: 4632 Insurance Recovery 5950 Motor Pool Vehicle Rent Total Operating Revenue: City of Seward Motor Pool Fund (03000-0000) Revenue and Expenditures Prior 3- 2024 YTD Proposed Proposed 2021 2022 2023 Year Actuals 2024 2025 2026 Actual Actual Actual Average (6/30) Budget Budget Budget 10,202 635,989 701,930 484,000 607,306 484,000 489,000 484,000 489,000 $ 635,989 $ 701,930 $ 484,000 $ 607,306 $ 484,000 $ 489,000 $ 484,000 $ 489,000 Non -Operating Revenues: 5899 Miscellanoues Revenue - - 5901 EF Investment Interest 7,383 19,864 90,039 39,095 16,445 10,000 10,000 5904 EF Misc. Interest Revenue 22,252 18,245 14,028 18,175 9,589 14,028 9,589 5910 Gain on Sale of Capital Assets 438 12,305 4,248 10,000 10,000 10,000 Total Non -Operating Revenue: $ 30,073 $ 38,109 $ 116,372 $ 61,518 $ 16,445 $ 19,589 $ 34,028 $ 29,589 Total Revenue: $ 666,062 $ 740,039 $ 600,372 $ 668,824 $ 500,445 $ 508,589 $ 518,028 $ 518,589 Expenditures: Non -Personnel Costs: 7215 Operating Supplies - 7216 Maintenance & Repair - 7216 Depreciation Expense 343,840 380,198 501,647 408,562 - 386,200 520,915 561,383 8001 Unrealized loss of Investments 23,651 72,304 10,035 35,330 - 8103 Capital Equipment 14,339 14,790 1,086,102 371,744 719,898 377,000 1,811,430 160,000 Total Non -Personnel Costs: $ 381,830 $ 467,292 $ 1,597,784 $ 815,635 $ 719,898 $ 763,200 $ 2,332,345 $ 721,383 Total Expenditures: $ 381,830 $ 467,292 $ 1,597,784 $ 815,635 $ 719,898 $ 763,200 $ 2,332,345 $ 721,383 **SGH PERS loan PMYT owed to Motorpool Fund loan matures in 2026. Narrative Motor Pool Fund Revenue and Expense Budget 5904 EF Misc. Interest Revenue Narrative Represents interest on interfund loans 7 Department Project Description New or Replace 2025 2026 City of Seward Capital Improvement Plan - Motorpool 2025 - 2030 Forecasted City Cost 2027 2028 2029 2030 Forecasted Project Cost Source Police $ 1,032,222 Motor Pool Police cruisers with equipment (4) Replace $ 327,430 $ 343,801 $ 360,991 Fire Ladder Truck (Quint) Replace $ 1,300,000 $ 1,300,000 Motor Pool Parks & Rec Campgrounds Tool Cat New $ 80,000 $ 80,000 Motor Pool Parks & Rec Park Maintenance 2007 Ford F150 Replace $ 55,000 $ 55,000 Motor Pool Parks & Rec Sports & Rec Passenger Van New $ 40,000 $ 40,000 Motor Pool Parks & Rec 2010 Gray Ford F150 Truck (214) Replace $ 60,000 $ 60,000 Motor Pool Electric Chevy Van 1981 #514 (not currently in MP) New $ 90,000 $ 90,000 Motor Pool Electric Chevy extended cab (not currently in MP) New $ 50,000 $ 50,000 Motor Pool Electric Small SUV New $ 40,000 $ 40,000 Motor Pool Harbor Whaler 21' - #460 1978 Replace $ 182,000 $ 182,000 Motor Pool Harbor 50 Ton Travelift 2016 Replace $ 559,000 $ 559,000 Motor Pool Harbor Truck #302 2013 Replace $ 60,000 $ 60,000 Motor Pool Harbor Truck #471 2018 Replace $ 60,000 $ 60,000 Motor Pool Harbor Truck# 472 2019 Replace $ 60,000 $ 60,000 Motor Pool Harbor Whaler 25" - 456 1988 Replace $ 185,000 $ 185,000 Motor Pool Public Works Streets L90 loader Replace $ 295,000 $ 295,000 Motor Pool Public Works Pickup Truck w/ plow - Streets Replace $ 85,000 $ - $ 85,000 Motor Pool Public Works Road Grader - Streets Replace $ 650,000 $ 650,000 Motor Pool Public Works Pickup Truck - Water W/W Replace $ 60,000 $ 60,000 Motor Pool Public Works Shop Mechanic Truck Replace $ 75,000 $ 75,000 Motor Pool Public Works End Dump Trucks New $ 190,000 $ 190,000 $ 190,000 $ 570,000 Motor Pool Water/WW "V" Snowplow New $ 18,000 $ 18,000 Motor Pool Water/WW Mower New $ 60,000 $ 6,000 Motor Pool Wastewater Mobile Standby Generator New $ 75,000 $ 75,000 Motor Pool 1,811,430 160,000 1,893,801 905,991 835,000 Motorpool Fund $ 1,811,430 $ 160,000 $ 1,893,801 $ 135,000 $ 905,991 $ 835,000 $ 5,687,222 Motorpool Beginning Cash Balance 1/1/2023 = $2,648,283(Ties to ACFR) Motorpool Ended Cash Balance 12/31/2023 = $2,407,598 (Ties to ACFR) $5,741,222 Total City Projected Cost 8 City of Seward- 2024 Motor Pool Information Dept Equipment Vehicle # Useful Life Purchase Date Cost Net Book Value ? '95 Champion Grader 101 10 12/29/1994 151,054.00 - 1310 1996 Oshkosh Snw Blwr 102 10 12/31/2008 65,950.00 - 1310 '08 IntlWater Truck Veh 103 10 12/31/2009 108,997.00 - 1310 2005 Asphalt Reclaimer 104 8 12/31/2005 57,455.00 - 1310 Cat D6T Dozer 105 10 12/31/2010 326,459.00 - 1310 2006 Volvo Motor Grader 106 10 12/31/2006 297,394.00 - 1310 2011lnt'I 108 10 12/31/2010 172,812.32 - 1310 Henderson 8-Yd sander 108 10 12/31/2010 43,327.00 - 1310 Trailmax Tilt Trailer 109 10 12/31/2010 32,825.00 - 1310 94 GMC Sandtruck 111 10 11/12/1994 130,116.00 - 3000 2000 Volvo Loader 112 10 12/31/2001 174,500.00 - 1310 2001 Volvo Grader 113 10 12/31/2001 183,544.00 - 1310 2010 Flatbed w/Sander 115 10 12/31/2010 37,884.00 - 1310 2009 Volvo Loader Veh 116 10 12/31/2009 210,440.00 - 1310 2009 Volvo Loader Veh 117 10 12/31/2009 219,685.00 - ? 2004 Dodge Quad 121 7 12/31/2004 25,478.00 - 4500 2005 Chev Cube Van 122 7 12/31/2010 14,500.00 - 1310 2010 Intl Dump Truck 129 10 12/31/2010 109,985.00 - 1310 2013 Dump Truck 134 10 12/31/2013 115,225.00 - 1310 2003 Intl Dump Truck 136 10 12/31/2002 72,766.00 - 1310 2000 Volvo Loader 137 10 12/31/2002 89,805.00 - ? 2004 Dodge Quad 156 7 12/31/2004 25,478.00 - 4500 John Deere 4410 159 10 12/31/2004 25,750.00 - 4500 2016 Ford F250 170 7 12/31/2016 37,609.74 - 1400 2000 Ford 15-Passenger Van 211 7 12/31/2002 17,500.00 - 1400 2011 Ford F150 214 7 12/31/2010 15,894.00 - 1400 2009 Ford Econoline Van 217 7 12/31/2009 22,621.00 - ? Bobcat Turbo Toolcat 219 7 12/31/2005 47,300.00 - 1400 Toolcat Repairs 219 1 12/31/2014 3,122.24 - 1400 V-Plow on veh 220 7 12/31/2003 4,445.00 - 1400 2011 Ford F150 221 7 12/31/2010 15,894.00 - 1400 Transmission Repairs 221 4 12/31/2017 2,800.00 - 1400 2009 Ford Econoline4x4 Veh 224 7 12/31/2009 33,121.00 - 1400 2007 Ford F250 225 7 12/31/2010 19,900.00 - 1400 2007 FordF250 transmission repairs 225 4 12/31/2014 10,910.43 - 1400 2015 Bobcat acc for veh 229 5 12/31/2015 3,102.74 - 1210 XTL5000 Mobile VHF Radio 251 7 12/31/2006 5,747.17 - 1210 Emerg Equip-Veh 251 5 12/31/2006 6,420.00 - 1210 XTL5000 Mobile VHF Radio 252 7 12/31/2006 5,747.17 - 1210 Emerg Equip-Veh 252 5 12/31/2006 6,420.00 - ? 2009 Chev Impala Veh 253 5 12/31/2009 32,917.50 - 1210 2010 Chev Impala 254 5 12/31/2010 20,236.00 - 1210 Radio Install 254 5 12/31/2010 1,479.73 - 1210 Safety Equipment 254 5 12/31/2010 11,465.00 - 1210 2010 Chev Impala 255 5 12/31/2010 20,236.00 - 1210 Radio Install 255 5 12/31/2010 1,479.73 - 1210 Safety Equipment 255 5 12/31/2010 11,465.00 - 1210 97 Ford Expedition 256 5 1/16/1997 35,905.00 - 1210 2001 Ford Explorer 257 5 12/31/2001 30,137.80 - 1210 2014 Ford Police Veh 257 5 12/31/2013 25,828.00 - 1210 Safety Equipment 257 5 12/31/2013 14,270.00 - 1210 Tires, Wheels, Sensors 257 5 12/31/2013 1,556.24 - 1210 2009 Chev Impala Veh 259 5 12/31/2009 32,917.50 - 1210 2002 Dodge Durango 260 5 12/31/2002 26,283.19 - ? 2012 Ford Util 5 12/31/2012 26,334.50 - 1210 Safety Equipment 263 5 12/31/2012 7,865.00 - 1210 VHF Radio 263 5 12/31/2012 4,791.35 - ? 2009 Subaru Forester 302 7 12/31/2008 23,251.00 - 1180 2001 Ford Escape 305 5 12/31/2002 16,900.00 - 1220 97 KME Custom Pumper 352 10 12/10/1996 243,539.50 - 1220 2006 Dodge Ram 353 7 12/31/2006 39,559.00 - 1220 Rescue 1 Veh 354 10 12/31/2009 161,877.00 - 1220 2006 Dodge Ram 355 9 7 12/31/2006 39,559.00 - 1220 2010 Fire Eng 357 10 12/31/2010 352,413.43 - 1220 Engine 359 10 12/31/2013 405,768.00 - City of Seward- 2024 Motor Pool Information Dept Equipment Vehicle # Useful Life Purchase Date Cost Net Book Value 1220 96 KME-Rescue Truck 360 10 12/10/1996 176,737.05 - 1220 2005 Jeep Wrangler 367 5 12/31/2005 23,002.00 - ? 2001 Chev F/B w/Crane 455 5 12/31/2001 34,837.00 - 2000 2014 Ford Escape - City Manager Vehicl 457 7 12/31/2013 22,887.00 - ? 2011 Chev PU 462 7 12/31/2011 34,806.00 - ? 2004 Dodge Ram 502 5 12/31/2004 31,101.00 - ? 2003 Dodge 3500 504 7 12/31/2004 31,222.70 - 3000 2008 Case Backhoe 512 10 12/31/2011 83,978.00 - 3000 2006 Chev Ext Cab PU 513 7 12/31/2006 29,906.00 - 3000 2011 Chev Silverado 518 7 12/31/2011 42,360.00 - 3000 2006 Intl Boom Truck 522 7 12/31/2006 119,946.00 - 3000 2009 Intl Bucket Trk 524 7 12/31/2009 232,066.38 - 3000 2012 Ford Escape 532 7 12/31/2012 22,085.00 - 3000 Digger/Derrick Model DM47-TR 1-521 10 12/31/2005 183,818.00 - 1400 Box van (used) 2-533 3 12/31/2014 4,642.50 - 1312 Hofmann3850 Truck Tire Machine 7 12/31/2006 9,977.00 - ? XTL 5000 VHF Mobile Radio 5 12/31/2009 5,399.05 - ? XTL 5000 VHF Mobile Radio 5 12/31/2009 5,399.05 - ? 8.5' V-Plow 5 12/31/2011 6,137.32 - ? Box van (used) 3 12/31/2014 14,032.67 - 3000 Box Van (used) - Electric 3 12/31/2014 6,180.00 - 1310 2015 grader wing 3 12/31/2015 28,560.00 - ? Flat-bed Pickup (used) 3 12/31/2015 13,867.50 - 5,700,965.50 - 10 City of Seward- 2024 Motor Pool Information Unrestricted Net Position as of 12/31/23 (2024 Estimated Beginning Balance)* : $ 2,407,598 2023 Appropriations Motor Pool Rcs. 2023 017 Purchase Wing Blade for Loader $ 23,266.00 Rcs.2023 019 Purchase Chevy Truck for Electric $ 60,073-90 Res. 2023-106 Purchase of the Plow Truck $ 394,887.90 Rcs. 2023 110 Purchase of the new Utility Tractor $ 183,233.13 Rcs. 2023 111 Long Bcd Ram 2500 single cab $ 53,7gs..00 Rcs. 2023 121 Chevy Silvcrado flatbed and cranc for Harbor $ 83,186.31 Res. 2023-123 Purchase of 4 Chevrolet Tahoe $ 311,838.20 Res. 2023-137 Purchase for the second Police responder. $ 72,859.00 Total $ 1,185,127.54 Subtotal: $ 2,002,055.56 2024 Appropriations Motor Pool Res. 2024-017 Purchase John Deere Gator for P&R $ 26,362.03 Res. 2024-019 Purchase of John Deere road grader for PW $ 499,498.00 $ 525,860.03 Subtotal: $ 1,476,195.53 Contribution to the Motor Pool (for replacement vehicles): City Manager $ 4,500.00 Police Department $ 10,000.00 Fire Department $ 60,000.00 Building Department $ 4,000.00 Street Operations $ 140,000.00 City Shop $ 8,000.00 Parks Maintenance $ 15,000.00 Campgrounds $ 9,500.00 TYC $ 11,000.00 Harbor $ 64,000.00 SMIC $ 50,000.00 Parking $ 13,000.00 Electric $ 85,000.00 Water $ 5,000.00 Wastewater $ 5,000.00 Total Contribution FY24: $ 484,000.00 **Projected Unrestricted Net Position as of 12/31/24 (Ending Balance): $ 1,960,195.53 *(Ties to ACFR) Motor Pool Interfund Loan History Balance as of Loan Purpose: Loan Date Amount Interest Rate Term Annual Payments 12/31/2024 Seward General Hospital PERS Unfunded Liability 10/4/2006 $ 1,250,000.00 5.25% 2007-2026 $ 98,576.00 $ 182,647 Animal Shelter 12/31/2021 $ 930,500.00 0.00% 2022-2051 $ 31,016.67 $ 527,283 11 Revenue 13000-2900 Expenditures 13000-0900 13000-2900 Depreciation Expense: Motor Pool Rent: Total Expenditures Less Depreciation & Motor Pool: Parking - Revenue & Expenditures General Operations 2023 2024 $ 339,920 $ 346,705 Total: $ 339,920 $ 346,705 Non -operating revenue: $ 1,500 $ 1,500 $ 338,420 $ 345,205 Debt Service General Operations Tota I : $ $ $ 161,755 161,755 Transfers Out: $ 25,689 Total Expenditures: $ 187,444 Revenue over expenses: $ 152,476 $ $ $ 27,000 13,000 112,476 164,862 164,862 26,191 191,053 155,652 27,500 13,000 115,152 Revenue over Expenditures (less depreciation expense and Motor Pool Rent): $ 227,444 $ 231,553 2025 2026 $ 429,173 $ 435,960 $ 429,173 $ 435,960 $ 429,173 $ 435,960 227,966 227,966 33,934 261,900 167,273 35,000 8,965 123,308 $ $ $ $ $ $ $ 212,835 212,835 $ 34,477 $ 247,312 188,648 25,000 8,965 154,683 305,865 $ 281,277 12 CITY OF SEWARD PARKING ENTERPRISE FUND Budgeted Statement of Cash Flow For Fiscal Year 2023,2024,2025 and 2026 2023 2024 2025 2026 Budget Budget Budget Budget Beginning Cash Balance at I/I/24*: 9I3,627 Cash is provided by (used for): Change in net position $152,476 $155,652 $167,273 $155,652 Add expense items not affecting cash Depreciation 27,000 27,500 35,000 27,500 Net cash provided by operations $179,476 $183,152 $202,273 $183,152 Other uses of cash None Net increase (decrease) in cash $179,476 $183,152 $202,273 $183,152 Estimated ending cash balance $1,093,103 $1,276,255 $1,478,528 $1,661,680 * Ties to December 3I, 2023 cash and investment balance per ACFR 13 Parking Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 2024 YTD Proposed Parking - General (13000-2900) 2021 2022 2023 Actuals 2024 2024 Budget 2024 Budget 2025 2026 Expense Budget Actual Actual Actual (6/30) Budget Revision Final Budget Budget Narrative Revenue: Operating Revenue 5200 5. Harbor Lot 152,841 137,627 128,864 40,291 117,932 18,000 135,932 144,088 146,393 5201 N. Harbor Lot 183,439 165,225 104,649 42,602 118,985 - 118,985 126,124 128,142 5202 NE Ramp Lot 30,481 13,579 36,809 4,625 33,608 15,000 48,608 51,524 52,348 5204 S. Harbor Uplands Lot 21,738 19,136 21,392 6,978 19,517 19,517 20,688 21,019 5205 Slip Holder Parking Passes 21,211 20,234 12,991 17,149 26,656 - 26,656 28,255 28,707 5206 Employee Passes 1,729 3,178 1,262 1,050 7,475 - 7,475 7,924 8,051 5207 Miscellaneous Parking Fees - 2,069 765 1 251 - 251 - x 5208 SW Harbor Lot 1,280 - - - - 5209 Company Vehicle Pass 327 327 327 - 327 347 353 5210 Vehicle w/ Trailer 8,785 9,533 6,544 18,660 15,833 - 15,833 16,783 17,052 5211 Visitor Parking Permits 6,916 4,206 2,991 9,793 3,821 3,821 4,050 4,115 x 5212 Fines - Parking Tickets 2,318 935 22,875 2,301 - 2,301 24,390 24,780 x 5899 Miscellaneous Revenue (260) (50) - - - - Total Operating Revenue: 430,806 375,998 316,267 164,023 346,706 33,000 379,706 424,173 430,960 Non -Operating Revenue: 5901 EF Investment Interest 3,002 4,094 31,114 3,632 1,500 9,000 10,500 5,000 5,000 5904 EF Misc Interest Revenue - 16,321 15,980 - Total Non -Operating Revenue: 3,002 20,415 47,095 3,632 1,500 9,000 10,500 5,000 5,000 Total Revenue: $ 433,808 $ 396,413 $ 363,361 $ 167,655 $ 348,206 $ 42,000 $ 390,206 $ 429,173 $ 435,960 Expenditures: Personnel Costs: 6000 Salaries 3,072 9,922 17,337 20,788 53,253 - 53,253 85,020 88,400 6001 Overtime 43 0 - 237 500 500 750 750 6100 Medicare 56 631 900 1,008 500 500 4,000 4,160 6101 Unemployment Insurance (153) - 290 290 - 6102 Workers' Compensation 44 37 64 830 500 168 668 2,500 2,550 6200 Leave Time (278) 1,476 359 - - 6201 Retirement Benefits 659 8,122 8,530 2,045 4,290 4,290 12,000 12,450 6202 Health Insurance 2,393 5,058 8,597 6,476 10,612 10,612 12,500 13,000 6210 Air Ambulance Benefit - - - - 230 230 6211 Met Life - Life Benefit - 5 5 5 Total Personnel Costs: 5,836 25,245 35,787 31,388 69,945 168 70,113 117,005 121,545 Non -Personnel Costs: 7001 Communications 994 818 666 614 1700 - 1,700 1751 1779 7002 Postage and Freight 359 265 211 551 - 551 568 577 7003 Bank and Credit Card Fees 17,347 11,949 22,875 1,384 12,071 12,071 12,433 12632 7004 Insurance 1,719 1,173 833 278 1,395 209 1,604 2,085 2118 7006 Legal 786 - 2,000 2,000 2,060 2093 7009 Contracted Services 7,603 5,800 19,287 9,918 4,500 10,000 14,500 14,935 15174 7015 Utilities 851 852 852 426 939 939 967 982 14 Parking Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 7211 Gas & Lube 826 - - 0 7212 Uniform Allowance - 251 937 230 400 - 400 412 419 7213 Safety Equipment - - - 73 - - - 0 7215 Operating Supplies 5,444 9,876 4,166 4,369 10,000 10,000 10,300 10465 7216 Maintenance & Repair 4,903 4,000 4,300 1,107 6,300 6,300 6,489 6593 7217 Small Tools & Equipment 37 2,480 - - 1,000 1,000 1,030 1046 7221 Operating Materials - 77 50 - 0 7300 Advertising - - 300 300 309 314 7301 Subscriptions & Dues 87 2,475 661 - 500 500 515 523 7307 General Fund Administrative Fee 11,675 12,025 12,385 6,380 12,760 12,760 13,142 13,353 7900 Depreciation Expense 25,240 26,641 40,521 - 27,500 27,500 35,000 25,000 8001 Unrealized Loss on Investments 11,195 14,843 2,595 1,242 8103 Capital Equipment 18,217 - - 8104 Motor Pool Rent 12,744 13,000 13,000 6,500 13,000 13,000 8,965 8,965 Total Non -Personnel Costs: 100,984 106,447 123,154 51,825 94,916 10,209 105,125 110,961 91,290 Total Expenditures: $ 106,820 131,692 $ 158,941 $ 83,213 $ 164,861 $ 10,376 $ 175,237 $ 227,966 $ 212,835 Note: Due to changes with GL coding for this fund, actual and budgeted revenues and expenditures for some line items in 2021 and 2023 are a combination of 13000 0000 and 13000 2900 15 CITY OF SEWARD WATER ENTERPRISE FUND Budgeted Revenue and Expenditures Fiscal Year 2023,2024, 2025 and 2026 2023 2024 2025 2026 Budget Budget Budget Budget Revenue I7000-0000 General Operations $ I,504,839 $ I,534,934 $ 2,052,094 $ 2,084,927 Total: $ I,504,839 $ I,534,934 $ 2,052,094 $ 2,084,927 Non -operating revenue: $ 7,500 $ 8,000 $ 3I,000 $ 3I,000 $ I,5I2,339 $ I,542,934 $ 2,083,094 $ 2,II5,927 Expenditures I7000-4000 General Operations $ I,366,642 $ I,40I,I90 $ I,499,4I6 $ I,544,20I I7000-0900 Debt Service Interest $ 9,070 $ 6,890 $ 6,85I $ 4,602 I7000-4002 SMIC $ I58,II2 $ I64,I67 $ 82,32I $ 83,638 Total: $ I,533,824 $ I,572,247 $ I,588,588 $ I,632,440 Transfers Out $ I42,575 $ I44,983 $ I64,I67 $ I66,794 Total Expenditures $ I,676,399 $ I,7I7,230 $ I,752,755 $ I,799,234 Revenue over expenses: $ (I64,060) $ (I74,296) $ 330,338 $ 3I6,693 Depreciation Expense: $ 4I6,000 $ 4I7,000 $ 405,000 $ 425,000 Motor Pool Rent: $ 5,000 $ 5,000 $ 3,550 $ 5,000 1 Expenditures Less Depreciation & Motor Pool: $ 42I,000 $ 422,000 $ 408,550 $ 430,000 (less depreciation expense and Motor Pool Rent): $ 256,940 $ 247,704 $ 738,888 $ 746,693 16 10/21/24 LAYDOWN from Finance Dept - Intended to Replace Page 17 of the WS packet for Water Enterprise Fund Cash Flow CITY OF SEWARD WATER ENTERPRISE FUND Budgeted Statement of Cash Flow For Fiscal Year 2023, 2024 ,2025 and 2026 2023 2024 2025 2026 Budget Budget Budget Budget Beginning Cash Balance at I / I /24*: $ 4,054,847 Cash is provided by (used for): Change in net position Add expense items not affecting cash: Depreciation Net cash provided by (used for) operations Other sources (uses) of cash Debt principal payments (SI45,592) (SI47,776) Net increase (decrease) in cash ($ I64,060) ($ I74,296) $330,338 $3I6,693 4I6,000 4I7,000 4I6,000 4I7,000 $25I,940 $242,704 $746,338 $733,693 ( I49,993) (SI52,243) $I06,348 $94,928 $596,346 $58I,450 Estimated ending cash balance: $4,I6I,I95 $4,256,I23 $4,852,469 $5,433,919 Ties to December 3I, 2023 cash and investment balance per ACFR 17 Water Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 2024 YTD Proposed Proposed Water - Revenue (17000-0000) 2021 2022 2023 Actuals 2024 2024 Budget 2024 Budget 2025 2026 Expense Budget Actual Actual Actual (6/30) Budget Revision Final Budget Budget Narrative Revenue: Operating Revenue 5300 Residential 519,329 468,271 473,458 243,653 542,461 542,461 558,735 567,675 5310 SG Service 183,729 269,649 276,228 140,366 172,809 - 172,809 177,993 180,841 5320 LG Service 415,556 541,264 518,837 150,988 818,801 818,801 843,365 856,859 5330 SMICSales 35,556 47,291 55,576 31,969 51,639 51,639 53,188 54,039 5340 Special Contracts 206,381 135,195 138,834 18,115 207,256 207,256 213,474 216,889 5801 Turn -on Fees 14,262 16,715 9,851 9,014 16,518 16,518 17,014 17,286 5804 Work Order Revenue 232 - - - 5806 Ship Water 2,288 39,930 47,910 3,367 40,082 40,082 41,284 41,945 5807 Hydrant Rentals 133,962 138,323 138,713 68,201 140,208 140,208 144,414 146,725 5899 Miscellaneous 12,462 22,138 9,510 30,095 2,550 - 2,550 2,627 2,669 Total Operating Revenue: 1,523,758 1,678,777 1,668,918 695,768 1,992,324 1,992,324 2,052,094 2,084,927 Non -Operating Revenue 5900 EF Investment Interest 5,453 29,172 161,857 16,064 7,000 50,000 57,000 30,000 30,000 5905 EF Penalties and Interest 443 622 484 1,252 1,000 - 1,000 1,000 1,000 Total Non -Operating Revenue: 5,896 29,794 162,341 17,317 8,000 50,000 58,000 31,000 31,000 Total Revenue: $ 1,529,654 $ 1,708,571 $ 1,831,259 $ 713,084 $ 2,000,324 $ 50,000 $ 2,050,324 $ 2,083,094 $ 2,115,927 18 Water Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 2024 YTD Proposed Water - Expenses (17000-4000) 2021 2022 2023 Actuals 2024 2024 Budget 2024 Budget 2025 Proposed 2026 Expense Budget Actual Actual Actual (6/30) Budget Revision Final Budget Budget Narrative Revenue: Non -Operating Revenue 5920 PERS on behalf paid by SOA 22,174 (6,662) 4,019 - - - Total Revenue: $ 22,174 $ (6,662) $ 4,019 Expenditures: Personnel Costs: 6000 Salaries 173,872 205,007 195,043 102,064 164,080 164,080 178,750 185,900 6001 Overtime 13,827 15,246 19,381 4,998 8,200 8,200 10,000 10,000 6002 Standby Time 6,542 14,987 14,760 7,484 11,600 11,600 15,000 15,000 6100 Medicare 2,893 3,289 3,479 1,660 2,560 2,560 3,250 3,380 6102 Workers' Compensation 8,188 7,196 7,497 3,680 6,080 6,080 6,500 6,630 6200 Leave Time 31,694 5,404 (4,946) - - - - - 6201 Retirement Benefits (20,059) 45,050 56,366 24,733 36,100 36,100 41,525 43,185 6202 Health Insurance 77,721 133,010 110,052 61,005 104,356 104,356 100,000 104,000 6210 Air Ambulance Benefit 51 505 - - - 345 345 6211 Met Life - Life Benefit 57 - 125 125 Total Personnel Costs: 294,678 429,188 401,683 206,187 332,976 332,976 355,495 368,565 Non -Personnel Costs: 7001 Communications 7,349 8,203 7,430 8,489 7,500 7,500 10,000 10,160 7002 Postage and Freight 2,122 3,582 4,789 1,666 2,572 2,572 2,649 2,691 7003 Bank and Credit Card Fees 12,491 12,322 12,874 2,336 12,000 - 12,000 12,360 12,558 7004 Insurance 24,070 29,187 35,616 19,245 29,095 1,846 30,941 31,869 32,379 7006 Legal 786 - - - 5,000 - 5,000 5,150 5,232 7009 Contracted Services 15,772 19,160 19,738 523 21,000 21,000 21,630 21,976 7010 Engineering - 14,999 7,370 10,000 10,000 10,300 10,465 7011 Testing 6,320 9,265 206 4,470 2,000 - 2,000 1,000 1,016 7015 Utilities 187,145 194,654 210,493 111,868 190,481 63,000 253,481 261,085 265,262 7016 Heating Fuel 2,195 3,811 3,838 2,376 5,076 - 5,076 5,228 5,312 7022 Software/SAS Subscriptions - 700 700 721 733 7023 Inspection and Testing 11,808 5,150 5,150 8,000 8,128 7210 Vehicle Supplies - - 150 150 155 157 7211 Gas & Lube 4,949 8,644 5,129 3,454 5,971 5,971 6,150 6,248 7212 Uniform Allowance - 118 - - - 7213 Safety Equipment 658 930 1,318 77 800 800 824 837 7215 Operating Supplies 17,876 47,783 18,132 8,479 18,000 18,000 15,000 15,240 7216 Maintenance & Repair 20,138 12,721 23,270 13,438 13,000 13,000 16,000 16,256 7217 Small Tools & Equipment 783 1,751 4,266 1,691 5,000 5,000 5,150 5,232 7221 Operating Materials 25 21 - - - 7300 Advertising 375 350 350 361 367 7301 Subscriptions & Dues 1,590 1,323 511 1,228 1,110 1,110 1,143 1,161 7302 Travel & Subsistence 632 333 1,372 248 2,500 2,500 2575 2,616 7303 Education & Training 468 1,595 1,200 950 1,944 1,944 2,002 2,034 7307 GF Administrative Fee 269,340 277,420 285,743 147,158 294,315 294,315 303,144 307,995 7808 Bad Debt Expense 82 (985) 24,780 2,219 12,500 12,500 12,875 13,081 7810 Miscellaneous Expense 100 85 47 - - - 19 Water Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 7900 Depreciation Expense 8001 Unrealized Loss on Investments 8104 Motor Pool Rent 8105 Improvements other than Buildings Total Non -Personnel Costs: Total Expenditures: 417,881 403,219 407,398 19,552 79,713 16,265 5,509 5,048 5,150 5,000 2,500 3,544 - 417,000 - 417,000 5,000 - 5,000 405,000 425,000 3,550 3,500 1,017,721 1,134,865 1,112,279 337,944 1,068,214 64,846 1,133,060 1,143,921 1,175,636 $ 1,312,398 $ 1,564,053 $ 1,513,962 $ 544,130 $ 1,401,190 $ 64,846 $ 1,466,036 $ 1,499,416 $ 1,544,201 20 Water Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 Water Fund - SMIC (17000-4002) Expense Budget Expenditures: Personnel Costs: 6000 Salaries 6001 Overtime 6002 Standby Time 6100 Medicare 6102 Workers' Compensation 6201 Retirement Benefits 6202 Health lnsurance Total Personnel Costs: 2024 YTD Proposed Proposed 2021 2022 2023 Actuals 2024 2024 Budget 2024 Budget 2025 2026 Actual Actual Actual (6/30) Budget Revision Final Budget Budget Narrative 920 13 56 56 172 1,217 (78) 41,020 - 41,020 1,640 - 1,640 2,320 - 2,320 512 - 512 1,520 - 1,520 9,025 - 9,025 30,290 - 30,290 (78) 86,327 86,327 Non -Personnel Costs: 7002 Postage and Freight - 25 7004 lnsurance 2,602 1,913 1,867 963 3,150 409 3,559 3,666 3,725 7009 Contracted Services 1,910 910 1,200 - 2,000 - 2,000 2,060 2,093 7011 Testing 1,085 845 - 2,730 800 - 800 824 837 7015 Utilities 51,238 57,058 57,220 34,352 96,284 (27,000) 69,284 71,363 72,505 7023 Inspection & Testing - - 2,045 - - - - - - 7211 Gas & Lube 85 95 97 - 100 - 100 103 105 7213 Safety Equipment - - 26 - - - - - 7215 Operating Supplies 1,905 4,282 2,269 - 2,000 - 2,000 2,060 2,093 7216 Maintenance & Repair 110 1,253 595 70 1,500 - 1,500 1,545 1,570 7217 Small Tools & Equipment - 150 43 - 150 - 150 200 203 7222 Computer Hardware - - - - 500 500 500 508 7301 Subscriptions & Dues 100 1,536 - 7302 Travel & Subsistence - - 11 7900 Depreciation Expense - 12,675 - Total Non -Personnel Costs: 59,035 80,742 65,373 38,115 106,484 (26,591) 79,893 82,321 83,638 Total Expenditures: $ 60,252 $ 80,742 $ 65,295 $ 38,115 $ 192,811 $ (26,591) $ 166,220 $ 82,321 $ 83,638 21 Water Fund Debt Service For Fiscal Year 2025 and 2026 2024 YTD Proposed Proposed Water Debt Service (17000-0900) 2021 2022 2023 Actuals 2024 2024 Budget 2024 Budget 2025 2026 Expense Budget Actual Actual Actual (6/30) Budget Revision Final Budget Budget Narrative Expenditures: Personnel Costs: 6201 Retirement Benefits 34,002 (54,379) (26,086) - - - 6209 PERS DC Forfeitures (233) - - - - - Total Personnel Costs: 34,002 (54,379) (26,086) (233) Non -Personnel Costs: 8012 Debt Service Interest 13,904 11,760 9,584 9,068 6,890 0 6,890 6,851 4,602 8300 Debt Service Principal 147,776 147,776 - 147,776 149,993 152,243 Total Non -Personnel Costs: 13,904 11,760 9,584 156,844 154,666 - 154,666 156,844 156,844 Total Expenditures: $ 47,906 $ (42,619) $ (16,502) $ 156,611 $ 154,666 $ - $ 154,666 $ 156,844 $ 156,844 22 10/21/24 LAYDOWN from Finance Dept - Intended to Replace Page 1 of the Laydown for Wastewater Enterprise Fund CITY OF SEWARD WASTEWATER ENTERPRISE FUND Budgeted Statement of Cash Flow For Fiscal Year 2023, 2024, 2025 and 2026 2023 2024 2025 2026 Budget Budget Budget Budget Beginning Cash Balance at I / I /24*: 4,054,644 Cash is provided by (used for): Change in net position Add expense items not affecting cash Depreciation Net cash provided by (used for) operations Other uses of cash Debt principal payments (a) Net increase (decrease) in cash Estimated ending cash balance: 'k Ties to December 31, 2023 cash and investment balance per ACFR (a) Sewer Lagoon new loans (20I6-2035) ($118,632) ($I08,465) ($457,38I) ($487,556) 349,340 349,340 340,000 360,000 $230,708 $240,875 ($ I I7,38I) ($ I27,556) ( 59,885) ( 60,785) (67,444) (68,456) $I70,823 $I80,090 ($I84,825) ($I96,0II) $3,7I9,538 $3,899,628 $3,7I4,803 $3,5I8,792 23 CITY OF SEWARD WASTEWATER ENTERPRISE FUND Budgeted Revenue and Expenditures For Fiscal Year 2023, 2024, 2025 and 2026 2023 2024 2025 2026 Budget Budget Budget Budget Revenue I8000-0000 General Operations $ I,274,794 $ I,309,29I $ I,323,094 $ I,344,263 Total: $ I,274,794 $ I,309,29I $ I,323,094 $ I,344,263 Non -operating revenue: $ 7,700 $ 8,250 $ 20,000 $ 20,000 $ I,282,494 $ I,3I7,54I $ I,343,094 $ I,364,263 Transfers In: $ I6,000 $ I6,000 $ 26,000 $ 26,000 Total Revenues: $ I,298,494 $ I,333,54I $ I,369,094 $ I,390,263 Expenditures I8000-0000 General Operations $ I,II3,908 $ I,I32,928 $ I,579,828 $ I,628,829 I8000-0900 Debt Service Interest $ 11,595 $ I0,695 $ I2,002 $ I0,990 I8000-4502 SMIC $ I70,249 $ I75,025 $ IO2,253 $ I03,890 Total: $ I,295,752 $ I,3I8,648 $ I,694,083 $ I,743,709 Transfers Out: $ I2I,374 $ I23,358 $ I32,392 $ I34,I I0 Total Expenditures: $ I,4I7,I26 $ I,442,006 $ I,826,475 $ I,877,8I9 Revenue over expenses: $ (II8,632) $ (I08,465) $ (457,38I) $ (487,556) Depreciation Expense: $ 349,340 $ 349,340 $ 340,000 $ 360,000 Motor Pool Rent: $ 5,000 $ 5,000 $ 3,550 $ 3,550 Total Motor Pool Rent & Depreciation Expense: $ 354,340 $ 354,340 $ 343,550 $ 363,550 Revenue over Expenditures (less depreciation expense and Motor Pool Rent): $ 235,708 $ 245,875 $ (113,831) $ (I24,006) 24 2024 YTD Proposed Proposed Wastewater - Revenue (18000-0000) 2021 2022 2023 Actuals 2024 2024 Budget 2024 Budget 2025 2026 Expense Budget Actual Actual Actual (6/30) Budget Revision Final Budget Budget Narrative Revenue: Operating Revenue 5300 Residential 699,909 624,466 629,276 322,820 697,951 - 697,951 718,890 730,392 5310 SG Service 237,878 375,661 336,370 191,304 315,000 - 315,000 324,450 329,641 5320 LG Service 256,567 231,278 218,659 97,361 244,292 - 244,292 251,621 255,647 5330 SMIC Sales 26,487 27,267 28,730 14,137 27,314 - 27,314 28,133 28,584 5801 Turn -on Fees 14,819 13,796 12,798 16,355 18,745 - 18,745 19,307 19,616 5808 Sewer - Inspection - - - (5) - - 5809 Water/Sewer Misc. Service 1,408 3,870 5,057 5,989 - 5,989 6,169 6,267 Total Operating Revenue: 1,237,067 1,276,338 1,225,834 647,029 1,309,291 1,309,291 1,323,094 1,344,263 Non -Operating Revenue 5901 EF Investment Interest 6,500 29,398 162,695 16,029 7,000 50,000 57,000 20,000 20,000 5905 EF Penalties and Interest 604 1,049 654 1,978 1,250 - 1,250 - - Total Non -Operating Revenue: 7,104 30,447 163,349 18,007 8,250 50,000 58,250 20,000 20,000 Total Revenue: $ 1,244,171 $ 1,306,785 $ 1,389,183 $ 665,035 $ 1,317,541 $ 50,000 $ 1,367,541 $ 1,343,094 $ 1,364,263 25 Wastewater Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 2024 YTD Proposed Proposed Wastewater (18000-4500) 2021 2022 2023 Actuals 2024 2024 Budget 2024 Budget 2025 2026 Expense Budget Actual Actual Actual (6/30) Budget Revision Final Budget Budget Narrative Revenue: 5920 PERS on behalf paid by SOA 20,587 (6,299) 4,298 5804 Work order Revenue - - 5,265 Total Revenue: $ 20,587 $ (6,299) $ 9,563 Expenditures: Personnel Costs: 6000 Salaries 161,843 183,703 201,520 114,908 164,080 - 164,080 244,500 254,300 6001 Overtime 8,920 11,890 20,069 13,199 8,200 - 8,200 22,000 22,000 6002 Standby Time 10,767 22,837 27,549 14,977 11,600 11,600 30,000 30,000 6100 Medicare 2,635 3,132 3,721 2,074 2,560 2,560 4,300 4,475 6102 Workers' Compensation 7,406 7,002 8,256 4,109 6,080 6,080 9,000 9,180 6200 Leave Time 8,094 1,558 - - 6201 Retirement Benefits (23,024) 35,506 59,642 27,389 36,100 36,100 63,000 65,520 6202 Health Insurance 77,017 103,683 106,146 60,756 104,356 104,356 105,000 109,200 6210 Air Ambulance Benefit - 51 - - 345 345 6211 Met Life - Life Benefit 55 - 145 145 Total Personnel Costs: 253,658 369,309 426,954 237,468 332,976 332,976 478,290 495,165 Non -Personnel Costs: 7001 Communications 5,502 6,126 5,241 348 6,790 6,790 6,994 7,106 7002 Postage and Freight 4,013 4,467 3,729 2,954 4,812 4,812 4,956 5,035 7003 Bank and Credit Card Fees 16,128 15,441 15,810 3,162 12,572 12,572 12,949 13,156 7004 lnsurance 6,512 7,189 8,317 4,457 11,655 698 12,353 12,724 12,928 7006 Legal 786 - 500 500 515 523 7009 Contracted Services 117,565 36,852 14,940 2,506 159,726 159,726 164,518 167,150 7010 Engineering - 14,999 7,370 - 10,609 10,609 10,927 11,102 7011 Testing 16,445 17,695 - 5,230 4,000 4,000 4,120 4,186 7015 Utilities 133,406 174,290 174,332 102,506 52,629 200,000 252,629 259,837 263,994 7016 Heating Fuel 149 - - 7022 Software/ SaaS Subscriptions - - 700 7023 Inspection and Testing 13,475 - 20,354 - 20,354 20,965 21,300 7210 Vehicle Supplies - - - - 7211 Gas & Lube 10,950 10,465 9,661 2,836 10,821 - 10,821 11,145 11,323 7212 Uniform Allowance 90 150 257 - - - - 7213 Safety Equipment 1,519 18 1,096 811 1,000 - 1,000 1,030 1,046 7214 Janitorial Supplies 52 - - - - - 7215 Operating Supplies 39,445 36,598 25,727 24,187 27,000 - 27,000 27,810 28,255 7216 Maintenance & Repair 23,141 12,095 16,876 13,567 10,600 10,600 10,918 11,093 7217 Small Tools & Equipment 1,704 1,703 7,373 454 2,500 - 2,500 2,575 2,616 7221 Operating Materials - - 217 - 3,500 3,500 3,605 3,663 7301 Subscriptions & Dues 87 8,633 128 - 16,282 16,282 16,770 17,038 7302 Travel & Subsistence 115 - 2,516 - 108 108 2,000 2,032 7303 Education & Training 300 509 1,600 - 300 720 1,020 1,051 1,068 7307 GF Administrative Fee 164,483 169,425 172,805 88,130 176,270 176,270 181,549 184,454 26 Wastewater Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 7808 Bad Debt Expense 586 156 23,476 3,157 1,000 - 1,000 1,030 1,046 7810 Miscellaneous Expense 60 153 90 7,920 - - - - - 7900 Depreciation Expense 349,339 346,843 - 349,340 - 349,340 340,000 360,000 8001 Unrealized Loss on Investments 21,432 83,956 16,390 5,538 8103 Capital Equipment - - 3,207 12,087 8104 Motor Pool Rent 5,048 5,150 5,000 2,500 5,000 - 5,000 3,550 3,550 Total Non -Personnel Costs: 569,467 955,577 876,527 282,350 888,068 201,418 1,088,786 1,101,538 1,133,664 Total Expenditures: $ 823,125 $ 1,324,886 $ 1,303,481 $ 519,818 $ 1,221,044 $ 201,418 $ 1,421,762 $ 1,579,828 $ 1,628,829 27 Wastewater Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 2024 YTD Proposed Proposed Wastewater Fund - SMIC (18000-4502) 2021 2022 2023 Actuals 2024 2024 Budget 2024 Budget 2025 2026 Expense Budget Actual Actual Actual (6/30) Budget Revision Final Budget Budget Narrative Expenditures: Personnel Costs: 6000 Salaries - - 41,020 - 41,020 6001 Overtime 852 1 1,640 1,640 6002 Standby Time - - 2,320 - 2,320 6100 Medicare 13 - 512 512 6102 Workers' Compensation 50 - (75) 1,520 - 1,520 6201 Retirement Benefits 53 9,025 9,025 6202 Health Insurance 267 - - - 30,290 - 30,290 Total Personnel Costs: 1,236 1 (75) 86,327 86,327 Non -Personnel Costs: 7002 Postage and Freight 25 1,037 260 - 2,001 2,001 2,061 2,094 7004 Insurance 2,341 1,995 1,819 917 3,465 476 3,941 4,060 4,125 7009 Contracted Services 38,582 6,942 8,162 1,400 11,200 11,200 11,536 11,721 7011 Testing 10,665 8,735 - 5,410 2,000 2,000 2,060 2,093 7015 Utilities 39,491 42,262 43,094 25,594 42,530 10,000 52,530 54,106 54,972 7016 Heating Fuel 281 - 857 - - 7023 Inspection & Testing - 7,295 - 8,200 - 8,200 8,446 8,581 7211 Gas & Lube 162 530 100 100 103 105 7213 Safety Equipment 588 - - - 100 - 100 103 105 7215 Operating Supplies 9,049 12,108 3,928 1,294 5,000 5,000 5,150 5,232 7216 Maintenance & Repair 750 1,165 1,292 445 1,500 - 1,500 1,545 1,570 7217 Small Tools & Equipment - 456 500 500 515 523 7221 Operating Materials - - - 3,500 3,500 3,605 3,663 7301 Subscriptions & Dues 7,960 8,282 8,282 8,530 8,666 7303 Education & Training - - - - 420 - 420 433 440 7810 Miscellaneous Expense 7,920 - - Total Non -Personnel Costs: 101,935 82,204 67,693 42,980 88,798 10,476 99,274 102,253 103,890 Total Expenditures: 103,171 $ 82,204 $ 67,619 $ 42,980 $ 175,125 $ 10,476 $ 185,601 $ 102,253 $ 103,890 28 Wastewater Fund Debt Service For Fiscal Year 2025 and 2026 2024 YTD Proposed Proposed Wastewater Debt Service (18000-0900) 2021 2022 2023 Actuals 2024 2024 Budget 2024 Budget 2025 2026 Expense Budget Actual Actual Actual (6/30) Budget Revision Final Budget Budget Narrative Expenditures: Personnel Costs: 6201 Retirement Benefits 35,966 (43,951) (5,463) 6209 PERS DC Forfeitures - - - (313) Total Personnel Costs: 35,966 (43,951) (5,463) (313) Non -Personnel Costs: 8012 Debt Service Interest 13,924 13,347 12,458 10,695 10,695 12,002 10,990 8300 Debt Service Principal - - - - 60,785 - 60,785 67,444 68,456 Total Non -Personnel Costs: 13,924 13,347 12,458 71,480 71,480 79,446 79,446 Total Expenditures: $ 49,890 $ (30,604) $ 6,995 $ (313) $ 71,480 $ $ 71,480 $ 79,446 $ 79,446 29