Loading...
HomeMy WebLinkAbout10282024 City Council Work Session Packet - Budget Harbor - ElectricSeward City Council Work Session Packet Topic: Budget FY2025-2026 Harbor and Electric Monday, October 28, 2024 City Council Chambers Beginning at 5:30 p.m. Harbor - Revenue & Expenditures 2023 2024 2025 2026 Revenue 11000-2000 General Operations $ 55,234 $ 56,304 $ 57,993 $ 58,921 11000-2002 Harbor Floats, Wharves & Docks $ 2,035,566 $ 2,076,303 $ 2,137,102 $ 2,164,793 11000-2004 50-ton Boat Lift $ 97,945 $ 99,939 $ 102,913 $ 104,560 11000-2005 Harbor Electric System $ 419,449 $ 427,828 $ 429,474 $ 436,338 Total: $ 2,608,194 $ 2,660,374 $ 2,727,482 $ 2,764,612 Land Rents and Leases 11000-5000 General Operations $ 290,000 $ 295,000 $ 309,750 $ 314,706 11000-5000 Harbor Floats, Wharves & Docks $ 142,000 $ 149,000 $ 156,450 $ 158,953 Land Rents and Leases Total: $ 432,000 $ 444,000 $ 466,200 $ 473,659 Total Revenue and Land Rents and Leases: $ 3,040,194 $ 3,104,374 $ 3,193,682 $ 3,238,271 Non -operating Revenue 11000-5901 General Operations $ 6,000 $ 6,500 $ 15,000 $ 15,000 11000-5905 Harbor Floats, Wharves & Docks $ 10,800 $ 10,800 $ 10,000 $ 10,000 Total non -operating revenue: $ 16,800 $ 17,300 $ 25,000 $ 25,000 Total Revenue: $ 3,056,994 $ 3,121,674 $ 3,218,682 $ 3,263,271 Expenditures 11000-0900 Debt Service Interest $ 48,850 $ 29,600 $ 29,600 $ 4,800 11000-2000 General Operations $ 355,173 $ 349,075 $ 408,493 $ 469,338 11000-2001 Administration $ (142,933) $ (149,738) $ (30,517) $ (19,815) 11000-2002 Harbor Floats, Wharves & Docks $ 3,076,837 $ 3,132,168 $ 3,407,228 $ 3,417,767 11000-2004 50-ton Boat Lift $ 239,489 $ 243,732 $ 240,641 $ 229,972 11000-2005 Harbor Electric System $ 660,200 $ 692,503 $ 655,510 $ 665,750 Total: $ 4,237,616 $ 4,297,340 $ 4,710,956 $ 4,767,813 Transfers Out: $ 469,030 $ 479,205 $ 493,349 $ 501,243 Total Expenditures: $ 4,706,646 $ 4,776,545 $ 5,204,305 $ 5,269,056 Revenue over expenses: $ (1,649,652) $ (1,654,871) $ (1,985,622) $ (2,005,785) Depreciation Expense: $ 1,545,040 $ 1,545,040 $ 1,774,800 $ 1,774,800 Motor Pool Rent: $ 64,000 $ 64,000 $ 50,130 $ 64,000 Total Expenditures Less Depreciation & Motor Pool: $ 3,097,606 $ 3,167,505 $ 3,379,375 $ 3,430,256 Revenue over Expenditures (less depreciation expense and Motor Pool Rent): $ (57,412) $ (63,131) $ (185,692) $ (191,985) 2 CITY OF SEWARD BOAT HARBOR ENTERPRISE FUND Budgeted Statement of Cash Flow For Fiscal Year 2023, 2024, 2025 and 2026 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 Debt principal payments 2023 2024 2025 2026 Budget Budget Budget Budget $4,30I,754 - I,649,652-I,654,87I-I,985,622 $ (2,005,785) I,545,040 I,545,050 I,774,800 $ 1,774,800 - $I04,6I2-$I09,82I-$2I0,822 -$230,985 -370,000 -385,000 -400,000 -320,000 Net increase (decrease) in cash-$474,6I2-$494,82I-$6I0,822 -$550,985 Estimated ending cash balance: $3,827,I42 $3,332,32I $2,72I,499 $2,I70,5I4 * Ties to December 3I, 2023 cash and investment balance per ACFR 3 Harbor Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 Harbor - General (11000-2000) Expense Budget Proposed Proposed 2021 2022 2023 2024 YTD 2024 2024 Budget 2024 Budget 2025 2026 Actual Actual Actual Actuals (6/30) Budget Revision Final Budget Budget Narrative Revenue: Intergovernmental 5920 PERS on behalf paid by SOA Total Intergovernmental: 68,604 (18,207) 12,445 68,604 (18,207) 12,445 Operating Revenue 5150 Shower Fees 16,331 15,647 15,508 6,190 14,533 - 14,533 14,969 15,208 5157 North Harbor Launch Fee 24,851 16,916 19,383 6,922 25,855 - 25,855 26,631 27,057 5158 South Harbor Launch Fee 13,664 17,505 10,748 3,911 14,216 - 14,216 14,642 14,877 5800 Labor & Services 315 105 - 500 - 500 515 523 5899 Misc Revenue 132 3,146 - 1,200 1,200 1,236 1,256 Total Operating Revenue: 55,293 53,320 45,639 17,023 56,304 56,304 57,993 58,921 Non -Operating Revenue 5000 Land Rents & Leases 292,232 189,920 81,927 152,142 295,000 - 295,000 309,750 314,706 5901 EF Investment Interest 8,758 21,660 108,633 13,027 35,000 41,500 15,000 15,000 Total Non -Operating Revenue: 300,990 211,580 190,560 165,169 295,000 35,000 336,500 324,750 329,706 Total Revenue: 424,887 246,694 248,644 182,192 351,304 35,000 392,804 382,743 388,627 Expenditures: Personnel Costs: 6000 Salaries 131,318 202,003 266,949 148,122 172,544 - 172,544 292,200 304,000 6001 Overtime 2,874 6,604 15,330 2,839 5,075 - 5,075 10,000 10,000 6002 Standby Time 14,857 28,703 33,210 16,799 23,000 - 23,000 35,000 35,000 6100 Medicare 2,743 4,077 5,028 2,052 3,200 - 3,200 4,500 4,680 6101 Unemployment Insurance 2,005 2,391 2,118 - - - - 6102 Workers' Compensation 8,361 10,665 16,505 6,211 8,625 6,086 14,711 16,000 16,320 6200 Leave Time 42,286 3,572 1,648 - - - - 6201 Retirement Benefits (154,040) 75,853 73,785 28,413 37,960 - 37,960 82,300 85,600 6202 Health Insurance (11,980) 85,810 105,460 65,270 93,500 - 93,500 105,000 109,200 6210 Air Ambulance Benefit 243 1,848 1,565 1,565 6211 Met Life - Life Benefit 73 175 175 Total Personnel Costs: 38,424 419,679 520,276 271,627 343,904 6,086 349,990 546,740 566,540 Non -Personnel Costs: 7001 Communications 3,456 4,274 4,489 2,255 3,600 - 3,600 4,000 4,064 7002 Postage and Freight 2,468 1,710 563 704 2,550 - 2,550 2,627 2,669 7003 Bank and Credit Card Fees 302 240 14,612 795 800 - 800 4,000 4,064 7004 Insurance 10,422 11,785 14,118 7,604 15,300 1,439 16,739 21,761 22,109 7009 Contracted Services 63,540 55,935 67,977 20,382 90,100 90,100 125,100 127,102 x 7011 Testing 600 407 366 510 - 510 525 534 7015 Utilities 71,246 79,407 67,033 37,965 73,500 7,000 80,500 82,915 84,242 7016 Heating Fuel 7,410 15,294 11,476 5,034 15,326 15,326 15,786 16,038 7211 Gas & Lube 14,719 22,835 19,003 8,451 22,971 - 22,971 23,660 24,039 7213 Safety Equipment 9,407 7,836 6,989 2,824 9,690 - 9,690 9,981 10,140 7214 Janitorial Supplies 10,323 8,656 8,348 4,995 9,792 - 9,792 10,086 10,247 4 Harbor Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 7215 Operating Supplies 6,876 5,370 7,318 1,543 6,000 6,000 6,180 6,279 7216 Maintenance & Repair 20,005 9,866 13,276 7,628 18,000 18,000 18,540 18,837 7217 Small Tools & Equipment 2,516 1,486 4,561 (430) 3,000 3,000 13,100 13,310 7222 Computer Hardware - - 2,500 2,500 2,575 2,616 7300 Advertising 256 587 49 350 350 361 366 7301 Subscriptions & Dues - 87 - - 500 500 515 523 7302 Travel & Subsistence - 432 - 6,372 6,372 6,563 6,668 x 7303 Education & Training - - 235 - - 2,500 2,540 x 7325 Harbor Internal Cost Allocation (583,108) (590,106) (607,810) (313,020) (626,040) (626,040) (644,821) (655,138) 7808 Bad Debt Expense - - - 1,000 1,000 7810 Miscellaneous Expense - - 25 - - - 7900 Depreciation Expense 1,527,006 139,159 183,443 - 160,000 160,000 185,000 185,000 8001 Unrealized Loss on Investments 32,039 99,410 12,884 5,555 - - - - 8104 Motor Pool Rent 23,527 24,000 24,000 12,000 24,000 - 24,000 16,550 16,550 Total Non -Personnel Costs: 1,223,010 (101,707) (146,874) (195,455) (160,179) 8,439 (151,740) (92,497) (97,202) Total Expenditures: 1,261,433 317,972 373,402 76,172 183,725 14,525 198,250 454,243 469,338 5 Harbor Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 2024 YTD Proposed Proposed Harbor - Admin (11000-2001) 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 226,712 206,187 157,543 119,483 225,980 30,000 255,980 295,200 307,000 6001 Overtime 8,422 6,900 10,692 9,592 7,105 7,105 15,000 15,000 x 6100 Medicare 3,549 3,166 2,614 2,266 3,650 3,650 3,750 3,900 6102 Workers' Compensation 6,460 2,475 883 944 4,415 4,415 2,500 2,550 6200 Leave Time 15,498 9,500 1,140 - - 6201 Retirement Benefits 36,469 31,253 41,048 26,908 49,715 49,715 68,200 70,900 6202 Health Insurance 104,116 78,112 59,745 64,354 95,695 95,695 135,000 140,400 6211 Met Life - Life Benefit 66 - 185 185 Total Personnel Costs: 401,225 337,594 273,664 223,612 386,560 30,000 416,560 519,835 539,935 Non -Personnel Costs: 7001 Communications 10,346 12,037 10,350 1,707 11,400 11,400 11,742 11,930 7002 Postage and Freight 976 241 164 44 453 453 467 474 7003 Bank and Credit Card Fees 68,081 74,067 64,621 13,321 69,360 69,360 71,441 72,584 7004 Insurance 6,114 5,278 4,786 1,805 6,800 934 7,734 7,966 8,094 7006 Legal 7,328 300 7,169 1,105 5,000 5,000 5,150 5,232 7009 Contracted Services 6,553 14,852 7,171 15,402 15,000 15,000 15,450 15,697 x 7011 Testing 16 - 200 200 206 209 7022 Software/SAS Subscriptions 613 357 1,700 1,700 1,751 1,779 7211 Gas & Lube 2,055 555 2,000 2,000 2,060 2,093 7212 Uniform Allowance 91 103 108 - 400 400 412 419 7215 Operating Supplies 4138 7,519 6,113 1,984 9,000 9,000 9,270 9,418 7216 Maintenance & Repair 137 - 200 200 206 209 7217 Small Tools & Equipment 1,133 1,544 35 3,000 3,000 3,090 3,139 7222 Computer Hardware - 2,500 2,500 2,575 2,616 7300 Advertising 1,098 308 1,177 150 1,200 1,200 1,236 1,256 7301 Subscriptions & Dues 1,161 1,545 1,276 - 800 800 1,200 1,219 7302 Travel & Subsistence 5,622 13,992 15,209 13,902 13,284 13,284 13,683 13,901 x 7303 Education & Training 1,185 5,550 800 300 1,500 1,500 4,000 4,064 x 7304 Equipment Rent 890 - - 7310 Recording Fees 200 200 206 206 7325 Harbor Internal Cost Allocation (684,770) (655,651) (675,630) (347,950) (695,900) (695,900) (716,777) (728,245) 7808 Bad Debt Expense - - 364 7810 Miscellaneous Expense 33 158 2,509 7900 Depreciation Expense - 8,719.28 - 7,605 7,605 8,800 8,800 8104 Motor Pool Rent 7,842 8,000 8,000 4,000 8,000 8,000 5,515 5,155 Total Non -Personnel Costs: (555,251) (511,144) (534,937) (292,949) (536,298) 934 (535,364) (550,352) (559,750) Total Expenditures: $ (154,026) $ (173,550) $ (261,273) $ (69,337) $ (149,738) $ 30,934 $ (118,804) $ (30,517) $ (19,815) 6 Harbor Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 2024 YTD Proposed Harbor - Floats (11000-2002) 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: Operating Revenue 5100 Transient Moorage 722,523 791,215 817,865 366,920 744,600 - 744,600 766,938 779,209 5101 Moorage 1,184,443 1,179,313 1,195,334 1,216,444 1,232,294 - 1,232,294 1,269,263 1,289,571 5102 Wharfage 47,828 41,888 81,245 49,760 49,760 51,253 52,073 5153 Fuel Pumping Fee 40,347 49,014 57,057 5,199 35,088 35,088 35,088 35,649 5154 Waiting List Fees 11,372 10,836 12,538 1,800 8,160 8,160 8,160 8,291 5155 Towing Fees 788 420 871 201 1,100 1,100 1,100 1,118 5156 Pumping Boats 284 190 200 280 200 200 200 203 5800 Labor and Services 11,509 1,833 11,302 1,675 5,100 5,100 5,100 5,182 5890 Collection of Doubtful Accounts 3,513 - - - - 5899 Miscellaneous Revenue 5,350 3,670 - - - Total Operating Revenue: 2,019,092 2,080,059 2,183,596 1,592,519 2,076,302 2,076,302 2,137,102 2,164,793 Non -Operating Revenue 5000 Land Rents & Leases 132,000 135,220 144,054 37,417 149,000 149,000 156,450 158,953 5901 EF Penalties and Interest 7,798 10,106 14,127 9,404 10,800 10,800 10,000 10,000 Total Non -Operating Revenue: 139,798 145,326 158,182 46,821 159,800 159,800 166,450 168,953 Total Revenue: 2,158,890 2,225,385 2,341,778 1,639,340 2,236,102 2,236,102 2,303,552 2,333,746 Expenditures: Personnel Costs: 6000 Salaries 161,530 166,534 171,500 77,585 157,750 157,750 147,500 153,400 6001 Overtime 6,896 8,100 10,838 5,101 6,600 6,600 10,000 10,000 6002 Standby Time - - 161 - - - - - 6100 Medicare 2,532 2,961 3,088 1,587 2,450 2,450 3,200 3,325 6102 Workers' Compensation 10,430 9,395 10,460 4,821 8,780 8,780 9,500 9,700 6200 Leave Time - 9,875 777 - - - 6201 Retirement Benefits 42,714 40,408 44,522 17,073 32,610 32,610 35,750 37,180 6202 Health Insurance 103,886 80,894 52,443 37,935 103,245 103,245 62,125 64,600 6211 Met Life - Life Benefit - - - 41 - - 85 85 Total Personnel Costs: 327,989 318,166 293,791 144,142 311,435 311,435 268,160 278,290 Non -Personnel Costs: 7002 Postage and Freight 360 478 1,159 1,249 818 - 818 843 856 7004 lnsurance 93,011 113,064 134,799 98,523 161,700 11,814 173,514 178,720 178,720 7009 Contracted Services 4,240 6,572 8,207 1,350 9,300 - 9,300 22,000 10,000 x 7015 Utilities 59,205 60,456 55,812 36,539 71,405 (4,000) 67,405 69,427 70,538 7213 Safety Equipment - 47 - 300 300 309 314 7215 Operating Supplies 427 4,201 3,125 4,362 1,400 1,400 2,500 2,540 7216 Maintenance & Repair 7,156 20,052 21,094 8,543 10,000 10,000 15,000 15,240 7217 Small Tools & Equipment 313 448 1,304 4,500 4,500 14,000 4,500 x 7321 Harbor General Indirect Costs 417,505 422,515 435,190 224,123 448,245 448,245 413,327 419,940 7322 Harbor Admin Indirect Costs 490,283 476,021 490,300 252,505 505,010 505,010 459,450 466,801 7324 Gen Fund Indirect Costs 305,709 382,117 393,585 202,698 405,395 405,395 408,493 415,029 7808 Bad Debt Expense 16,243 18,752 62,345 - 12,400 12,400 - 7810 Miscellaneous Expense 322 - - - - 7900 Depreciation Expense 1,389,801 1,553,533 - 1,355,000 1,355,000 1,555,000 1,555,000 Total Non -Personnel Costs: 1,394,452 2,894,028 3,159,968 831,196 2,985,473 7,814 2,993,287 3,139,068 3,139,477 Total Expenditures: $ 1,722,441 3,212,195 $ 3,453,759 $ 975,338 $ 3,296,908 $ 7,814 $ 3,304,722 $ 3,407,228 $ 3,417,767 7 Harbor Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 2024 YTD Proposed Proposed Harbor - 50-Ton Lift (11000-2004) 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 5103 Boat Lift Fees 95,289 98,663 104,475 54,469 99,139 99,139 102,113 103,747 x 5155 Towing Fees 210 - 134 - - - - - 5800 Labor & Services 761 105 800 - 800 800 813 x Total Operating Revenue: 96,260 98,768 104,609 54,469 99,939 99,939 102,913 104,560 Total Revenue: $ 96,260 $ 98,768 $ 104,609 $ 54,469 $ 99,939 $ $ 99,939 $ 102,913 $ 104,560 Expenditures: Personnel Costs: 6000 Salaries 42,243 61,271 57,651 30,388 55,030 - 55,030 55,400 57,615 6001 Overtime 1,928 918 514 697 1,000 - 1,000 1,500 1,500 6100 Medicare 716 917 863 472 800 800 850 885 6102 Workers' Compensation 2,799 2,817 2,768 1,645 2,450 - 2,450 3,000 3,060 6200 Leave Time 3,135 - - - 6201 Retirement Benefits 12,298 15,661 14,455 6,839 12,165 - 12,165 15,000 15,600 6202 Health Insurance 24,056 26,908 20,699 12,346 22,075 22,075 22,075 22,950 6211 Met Life - Life Benefit - - - 24 - - - 50 50 Total Personnel Costs: 84,039 111,625 96,948 52,409 93,520 93,520 97,875 101,660 Non -Personnel Costs: 7002 Postage and Freight 572 360 - 907 1,326 - 1,326 1,366 1,388 7004 Insurance 7,057 8,577 10,442 5,587 8,550 554 9,104 9,377 9,527 7009 Contracted Services 11,920 620 620 - 1,800 - 1,800 3,740 3,800 7023 Inspection & Testing 1,500 1,500 6,000 x 7211 Gas & Lube 1,479 2,214 1,971 1,009 4,236 - 4,236 4,363 4,433 7215 Operating Supplies 252 280 133 200 200 206 209 7216 Maintenance & Repair 2,743 2,460 458 8,348 9,500 - 9,500 20,000 20,320 x 7217 Small Tools & Equipment 117 48 100 100 103 105 7321 Harbor General Indirect Costs 20,992 21,244 21,880 11,268 22,535 - 22,535 19,801 20,118 7322 Harbor Admin Indirect Costs 24,653 20,388 21,000 10,815 21,630 21,630 22,011 22,363 7324 Gen Fund Indirect Costs 27,791 28,124 28,965 14,918 29,835 - 29,835 19,734 20,050 7900 Depreciation Expense 15,108 19,491 17,000 17,000 20,000 20,000 8104 Motor Pool Rent 31,369 32,000 32,000 16,000 32,000 - 32,000 22,065 22,065 Total Non -Personnel Costs: 128,828 131,492 136,960 68,899 150,212 554 150,766 142,766 128,312 Total Expenditures: $ 212,867 243,117 $ 233,908 $ 121,308 $ 243,732 $ 554 $ 244,286 $ 240,641 $ 229,972 8 Harbor Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 Harbor - Electrical System (11000-2005) Expense Budget Revenue: Operating Revenue 5105 Harbor Power Sales 5800 Labor & Services Total Operating Revenue: Total Revenue: 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 410,734 374,396 431,438 262,675 427,328 72,000 499,328 428,974 435,838 x 333 854 500 500 500 500 411,067 374,396 431,438 263,529 427,828 72,000 499,828 429,474 436,338 Expenditures: Personnel Costs: 6000 Salaries 16,983 26,684 24,482 10,315 21,477 - 21,477 22,500 23,400 6001 Overtime 109 22 128 80 102 - 102 100 100 6100 Medicare 271 404 405 154 305 - 305 325 335 6102 Workers' Compensation 532 836 658 305 825 825 800 815 6200 Leave Time 191 - - - - 6201 Retirement Benefits 3,524 5,703 5,970 2,287 4,725 4,725 4,950 5,150 6202 Health Insurance 10,209 13,639 9,992 3,895 9,805 - 9,805 9,500 9,880 6211 Met Life - Life Benefit 5 - 15 15 Total Personnel Costs: 31,628 47,288 41,827 17,041 37,239 37,239 38,190 39,695 Non -Personnel Costs: 7002 Postage and Freight 1,000 1,000 1,030 1,046 7004 Insurance 669 412 401 224 800 108 908 935 950 7009 Contracted Services 1,908 1,050 2,575 2,700 500 500 1,508 1,532 7022 Software/SAS Subscriptions 1,100 1,100 1,133 1,151 7023 Inspection & Testing 5,000 5,000 5,150 5,232 x 7100 General Power for Resale 285,493 307,440 321,325 218,032 400,000 72,000 472,000 346,564 352,109 7215 Operating Supplies 2,403 44 610 17 2,500 2,500 2,575 2,616 7216 Maintenance & Repair 3,964 4,812 3,376 2,373 4,000 - 4,000 4,120 4,186 7217 Small Tools & Equipment 1,000 1,000 40,000 40,640 x 7221 Operating Materials 4,000 - 4,000 4,120 4,186 7321 Harbor General Indirect Costs 79,303 80,255 82,665 42,573 85,145 85,145 65,857 66,911 7322 Harbor Admin Indirect Costs 93,135 95,812 98,685 50,823 101,645 - 101,645 73,206 74,377 7324 Gen Fund Indirect Costs 40,758 41,247 42,485 21,875 43,750 43,750 65,122 66,164 7900 Depreciation Expense 5,532 4,825 4,825 6,000 6000 Total Non -Personnel Costs: 507,633 531,072 557,653 338,616 655,265 72,108 727,373 617,320 626,055 Total Expenditures: $ 539,261 578,360 $ 599,481 $ 355,657 $ 692,504 $ 72,108 $ 764,612 $ 655,510 $ 665,750 9 Harbor Fund Debt Service For Fiscal Year 2025 and 2026 2024 YTD Proposed Proposed Harbor - Debt Service (11000-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 Non -Operating Revenue 5941 Debt Svc Amort of Bond Premiums 58,257 43,172 43,172 - Total Non -Operating Revenue: 58,257 43,172 43,172 Total Revenue: $ 58,257 $ 43,172 $ 43,172 $ $ $ - $ - $ $ Expenditures: Personnel Costs: 6201 Retirement Benefits 6209 PERS DC Forfeitures Total Personnel Costs: 102,343 (156,811) (15,000) (377) 102,343 (156,811) (15,000) (377) Non -Personnel Costs: 8012 Debt Service Interest Expense 105,070 80,475 78,705 24,425 29,600 29,600 29,600 4,800 8013 Amortize Deferred Loss on Bonds 23,567 16,176 16,176 - 8015 Debt Service Interest Expense - 16,321 - 8300 Debt Service Principal - - 385,000 385,000 400,000 320,000 Total Non -Personnel Costs: 128,637 112,972 94,881 24,425 414,600 - 414,600 429,600 324,800 Total Expenditures: $ 230,981 $ (43,839) $ 79,881 $ 24,048 $ 414,600 $ - $ 414,600 $ 429,600 $ 324,800 10 Harbor General (11000-2000) Narrative/Notes 7009 Contracted Services 7302 Travel & Subsistence 7303 Education & Training Harbor Admin (11000 2001 Current custodial contract expiring, adjusted budget to be in line with other city departments CDL certification needed for multiple harbor workers Additional harbor worker training Narrative/Notes 6001 Overtime 7009 Contracted Services 7302 Travel & Subsistence 7303 Education & Training Harbor Floats (11000-2002) Harbor was short staffed in spring/summer of 2024 Higher costs this year with trial of Dockwa software, discontinued in October Travel for all of the positions. Training for office positions Narrative/Notes 7009 Contracted Services 7217 Small tools & Equipment Harbor 50-Ton Lift (11000-2004) $12,000 for antifreeze removal in 2025 2 new snow blowers requested for 2025 Narrative/Notes 7023 Inspection & Testing 7216 Maintenance & Repair Harbor Electrical system (11000- Additional funding for lift inspection, which will be split between Harbor & SMIC Increased based on quotes for necessary repairs Narrative/Notes 7023 Inspection and Testing 7217 Small Tools & Equipment For ground fault inspection Increased to upgrade half of the harbor meters for remote monitoring CITY OF SEWARD SMIC 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#: $280,265 Cash is provided by (used for): Change in Net Position Other Uses - Debt Principal Add expense items not affecting cash Depreciation Net increase (decrease) in cash Estimated ending cash balance: (I,982,34I) (I,964,735) (I,705,290) (I,708,366) 0 0 0 0 1,651,000 1,651,000 I,485,000 I,485,000 (33I,34I) (3I3,736) (220,290) (223,367) -$5I,076-$364,8I2-$585,IO2 -$808,469 ° Ties to December 3I, 2023 cash and investment balance per ACFR 12 SMIC - Revenue & Expenditures Revenue 2023 2024 2025 2026 12000-2500 Operating Revenue $ 291,000 $ 291,000 $ 336,295 $ 296,734 12000-2501 SMIC Basin $ 63,561 $ 65,465 $ 166,586 $ 169,251 12000-2504 SMIC 330-ton lift $ 279,926 $ 287,961 $ 296,237 $ 300,794 12000-2505 SMIC Syncrolift $ 69,650 $ 71,750 $ 77,490 $ 78,730 Total: $ 704,137 $ 716,176 $ 876,608 $ 845,509 Land Rents and Leases 12000-2500 Operating Revenue $ 80,000 $ 80,000 $ 86,400 $ 87,782 12000-2501 SMIC Basin $ 26,448 $ 27,242 $ - $ Land Rents and Leases Total: $ 106,448 $ 107,242 $ 86,400 $ 87,782 Total Revenue and Land Rents and Leases: $ 810,585 $ 823,418 $ 963,008 $ 933,291 Non -operating Revenue 12000-2500 Operating Revenue $ 12000-2501 SMIC Basin $ 1,450 $ - $ 1,450 $ - $ Total non -operating revenue: $ 1,450 $ 1,450 Total Revenue: $ 812,035 $ 1,750 $ 1,750 - $ $ 1,750 $ 1,750 824,868 $ 964,758 $ 935,041 Expenditures 12000-0900 Debt Service $ - $ - $ 12000-2500 Operating $ 1,148,451 $ 1,135,238 $ 1,236,633 $ 1,246,222 12000-2501 SMIC Basin $ 200,420 $ 205,716 $ 192,975 $ 195,454 12000-2504 SMIC 330-ton lift $ 772,027 $ 772,885 $ 618,821 $ 577,570 12000-2505 SMIC Syncrolift $ 533,220 $ 533,265 $ 473,107 $ 473,317 Total: $ 2,654,118 $ 2,647,104 $ 2,521,536 $ 2,492,563 Transfers Out: $ 138,808 $ 141,050 $ 146,762 $ 149,095 Total Expenditures: $ 2,792,926 $ 2,788,154 $ 2,668,298 $ 2,641,658 Revenue over expenses: Depreciation Expense: Motorpool Rent: Total Expenditures Less Depreciation: $ $ $ $ (1,982,341) 1,651,000 50,000 1,091,926 $ $ $ $ (1,964,736) $ (1,705,290) $ (1,708,366) 1,651,000 $ 1,485,000 $ 1,485,000 50,000 $ 50,000 $ 50,000 1,087,154 $ 1,183,298 $ 1,156,658 Revenue over Expenditures (less depreciation expense): $ (281,341) $ (263,736) $ (220,290) $ (223,366) 13 SMIC Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 2024 YTD Proposed Proposed SMIC - General (12000-2500) 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: Intergovernmental Revenue: 5920 PERS on behalf paid by SOA 11,029 (3,151) 1899.4 - 5921 Federal Grant Funds 11,600 32076 - Operating Revenue 5106 SMIC Power Sales 81,897 155,102 37,032 19,678 90,000 - 90,000 60,000 60,000 5104 Storage Fees 276,295 164,670 200,000 - 200,000 276,295 236,734 5800 Labor & Services 50 210 8,333 1,000 - 1,000 5899 Misc Revenue - 9,782 - Total Operating Revenue: 92,976 163,760 365,417 184,348 291,000 - 291,000 336,295 296,734 Non -Operating Revenue 5000 Land Rents & Leases 78,033 42,704 1,780 64,168 80,000 80,000 86,400 87,782 5901 EF Investment Interest 294 2,351 15,588 2,022 1,250 4,500 5,750 1,750 1,750 5905 EF Penalties and Interest 84 200 200 Total Non -Operating Revenue: 78,411 45,055 17,367 66,189 81,450 4,500 85,950 88,150 89,532 Total Revenue: $ 171,387 $ 208,816 $ 382,785 $ 250,538 $ 372,450 $ 4,500 $ 376,950 $ 424,445 $ 386,266 Expenditures: Personnel Costs: 6000 Salaries 20,562 15,896 19,138 31,401 186,230 186,230 78,300 81,450 6001 Overtime 264 1 40 275 275 350 350 6100 Medicare 260 240 329 482 350 350 1,200 1,250 6102 Workers' Compensation 1,077 796 1,059 1,854 1,500 2,008 3,508 4,500 4,590 6200 Leave Time (1,028) 2,220 6201 Retirement Benefits (15,920) 5,955 5,074 6,908 40,970 40,970 17,225 17,900 6202 Health Insurance 7,688 4,761 5,486 8,778 9,040 9,040 14,500 15,000 6210 Air Ambulance Benefit - 275 275 6211 Met Life - Life Benefit 16 40 40 Total Personnel Costs: 13,931 26,620 33,346 49,439 238,365 2,008 240,373 116,390 120,855 Non -Personnel Costs: 7002 Postage and Freight 183 100 9 487 500 500 515 523 7004 Insurance 2,609 2,556 2,954 1,668 2,950 240 3,190 3,285 3,338 7006 Legal 786 2,000 (2,000) 7009 Contracted Services 26,284 54,339 48,172 10,492 27,000 7,988 34,988 36,038 36,615 7015 Utilities 25,900 26,359 24,755 14,247 29,548 29,548 30,434 30,921 7016 Heating Fuel 2,126 2,284 2,286 2,503 2,424 2,424 6,000 6,096 7023 Inspection and Testing 2,000 2,000 2,000 2,032 x 7100 General Power for Resale 43,605 112,788 54,575 29,394 104,850 180,000 284,850 45,000 45,720 7211 Gas & Lube 7,333 3,395 1,619 3,740 6,651 6,651 6,851 6,961 7215 Operating Supplies 2,307 980 2,311 618 1,100 1,100 1,133 1,151 7216 Maintenance & Repair 11,636 11,570 2,435 2,594 8,000 8,000 8,240 8,372 7217 Small Tools & Equipment 424 437 284 1,300 (1,300) 1,300 1,321 14 SMIC Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 7302 Travel & Subsistence - - 3,888 (3,888) - 3,888 3,950 x 7303 Education & Training - - - 800 (800) - 800 813 7321 Harbor General Indirect 0 0 0 0 0 - 55,728 56,620 7322 HarborAdmin Indirect - - - - 61,947 62,938 7324 Gen Fund Indirect Costs - 57,084 57,997 x 7325 Harbor Internal Cost Allocation (137,087) (138,732) (143,045) (73,590) (147,180) - (147,180) - x 7808 Bad Debt Expense - - - 1,000 1,000 7900 Depreciation Expense 1,650,504 849,648 - 850,042 850,042 800,000 800,000 8001 Unrealized Loss on Investments 1,357 6,793 1,497 683 - Total Non -Personnel Costs: (12,539) 1,733,372 847,499 (7,164) 896,873 180,240 1,077,113 1,120,243 1,125,367 Total Expenditures: $ 1,392 1,759,993 $ 880,846 $ 42,275 $ 1,135,238 $ 182,247 $ 1,317,485 $ 1,236,633 $ 1,246,222 Note* It was decided not to continue this internal allocation within the SMIC enterprise fund. Historically, this was done because the SMIC General department did not have revenue, so funds were transferred from the revenue -earning departments into SMIC General to cover operations expenses. SMIC General has substantial revenue now that lease and boat storage is being coded there, so the internal reallocation is no longer necessary 15 SMIC Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 2024 YTD Proposed SMIC - Basin (12000-2501) 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 5101 Moorage 68,281 72,283 83,740 50,030 51,500 20,000 71,500 73,645 74,823 5102 Wharfage 26,214 14,781 103,367 89,671 9,785 50,000 59,785 89,671 91,106 5106 SMIC Power Sales 2,789 7,636 24,118 9,806 1,325 - 1,325 1,325 1,346 5110 Crane Fees 3,188 5,963 2,436 676 1,913 1,913 1,000 1,016 x 5153 Fuel Pumping Fee - 397 1,348 881 842 842 842 855 5800 Labor & Services - 100 - 100 103 105 Total Operating Revenue: 100,472 101,060 215,008 151,063 65,465 70,000 135,465 166,586 169,251 Non -Operating Revenue 5000 Land Rents & Leases Total Non -Operating Revenue: Total Revenue: 51,740 26,305 28,023 27,242 - 27,242 - x 51,740 26,305 28,023 27,242 27,242 $ 152,212 $ 127,365 $ 243,031 $ 151,063 $ 92,707 $ 70,000 $ 162,707 $ 166,586 $ 169,251 Expenditures: Personnel Costs: 6000 Salaries 907 4,628 2,050 917 5,278 - 5,278 5,000 5,200 6001 Overtime 79 64 100 100 100 100 6100 Medicare 16 67 32 13 60 60 60 60 6102 Workers' Compensation 84 173 48 21 200 200 200 205 6200 Leave Time 5,285 - 6201 Retirement Benefits 317 1,211 543 202 1,160 - 1,160 1,000 1,040 6202 Health Insurance 48 1,491 865 794 2,100 - 2,100 2,000 2,080 6211 Met Life - Life Benefit 1 5 5 Total Personnel Costs: 1,450 7,570 8,887 1,948 8,898 8,898 8,365 8,690 Non -Personnel Costs: 7004 Insurance 6,334 8,090 10,180 5,558 7,660 393 8,053 8,295 8,428 7009 Contracted Services 6,108 2,234 5,253 125 5,000 3,888 8,888 5,000 5,080 7023 Inspection & Testing 2,500 - 2,500 2,500 2,540 7216 Maintenance & Repair 1,202 158 107 1,500 - 1,500 1,500 1,524 7302 Travel & Subsistence - 3,888 (3,888) 4,005 4,069 x 7321 Harbor General Indirect 2332 2360 2430 1249.98 2500 - 2,500 36,133 36,711 7322 Harbor Admin Indirect 2,739 2,266 2,645 1,362 2,725 2,725 40,165 40,808 7323 SMIC General Indirect 4,935 4,994 5,150 2,648 5,295 5,295 - 7324 Gen Fund Indirect Costs 53,733 101,993 105,050 54,100 108,200 108,200 37,012 37,604 7900 Depreciation Expense 57,523 57,550 57,550 50,000 50,000 Total Non -Personnel Costs: 77,383 121,937 188,390 65,150 196,818 393 197,211 184,610 186,764 Total Expenditures: $ 78,833 $ 129,507 $ 197,276 $ 67,098 $ 205,716 $ 393 $ 206,109 $ 192,975 $ 195,454 Note: The SMIC Basin GL code is a combination of three historical GL codes (2501 Fisherman's Float, 2502 SMIC North Dock, 2503 SMIC East Dock) that were consolidated in 2022. 2021 actual revenue and expenditure numbers have been generated by adding these three GL codes together, since they were still separate at that time 16 SMIC Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 2024 YTD Proposed SMIC - 330-Ton Lift (12000-2504) 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 5103 Boat Lift Fees 239,450 225,787 277,950 112,103 275,861 275,861 284,137 288,683 5104 Storage Fees 167,272 255,450 - - - 5109 Washdown Pad Fees 15,145 12,686 7,200 1,357 11,400 - 11,400 11,400 5800 Labor & Services 1,076 139 100 700 - 700 700 711 Total Operating Revenue: 422,943 494,062 285,150 113,559 287,961 276,561 296,237 300,794 Total Revenue: Expenditures: Personnel Costs: 6000 Salaries 68,251 83,744 86,021 30,225 79,678 - 79,678 60,200 62,600 6001 Overtime 2,202 3,134 2,242 925 1,500 - 1,500 2,000 2,000 6100 Medicare 1,174 1,305 1,293 473 1,125 - 1,125 1,125 1,175 6102 Workers' Compensation 4,749 4,217 4,412 1,580 4,085 - 4,085 4,000 4,080 6200 Leave Time 5,291 (3,516) 612 - - - - - 6201 Retirement Benefits 19,619 22,068 22,021 6,853 17,530 - 17,530 15,000 15,600 6202 Health Insurance 34,950 30,706 27,667 11,063 27,565 - 27,565 26,500 27,560 6211 Met Life - Life Benefit 21 - 45 45 Total Personnel Costs: 136,236 141,657 144,267 51,140 131,483 131,483 108,870 113,060 Non -Personnel Costs: 7002 Postage and Freight 627 2,157 3,683 1,901 - 1,901 1,958 1,989 7004 Insurance 11,536 11,682 12,243 6,245 13,205 1,301 14,506 14,942 15,181 7009 Contracted Services - 125 4,083 1,200 - 1,200 32,000 32,512 x 7023 Inspection & Testing - 1,500 1,500 5,000 5,080 x 7211 Gas & Lube 1,991 6,425 8,428 2,535 8,653 - 8,653 8,913 9,056 7215 Operating Supplies 1,388 1,058 1,907 32 850 - 850 876 890 7216 Maintenance & Repair 13,195 24,316 28,213 2,132 30,000 - 30,000 52,000 52,832 x 7321 Harbor General Indirect Costs 62,976 63,732 65,645 33,807 67,615 - 67,615 53,975 54,839 7322 Harbor Admin Indirect Costs 73,960 61,164 63,000 32,445 64,890 - 64,890 59,998 60,958 7323 SMIC General Indirect 132,152 133,738 137,895 70,943 141,885 141,885 - - 7324 Gen Fund Indirect Costs 44,683 45,219 46,575 23,985 47,970 - 47,970 55,289 56,174 7900 Depreciation Expense - - 211,635 211,733 - 211,733 175,000 175,000 8104 Motor Pool Rent - - 50,000 25,000 50,000 - 50,000 50,000 50,000 Total Non -Personnel Costs: 342,508 349,616 633,307 197,125 641,402 1,301 642,703 509,951 464,510 Total Expenditures: $ 478,744 $ 491,273 $ 777,574 $ 248,265 $ 772,885 $ 1,301 $ 774,186 $ 618,821 $ 577,570 17 SMIC Fund Proposed Revenue/ Expense by line Item For Fiscal Year 2025 and 2026 SMIC - Syncrolift (12000-2505) Expense Budget Revenue: 2024 YTD Proposed 2021 2022 2023 Actuals 2024 2024 Budget 2024 Budget 2025 2026 Actual Actual Actual (6/30) Budget Revision Final Budget Budget Non -Operating Revenue 5000 Land Rents & Leases 67,600 67,600 67,600 33,800 71,750 - 71,750 77,490 78,730 Total Non -Operating Revenue: 67,600 67,600 67,600 33,800 71,750 71,750 77,490 78,730 Total Revenue: $ 67,600 $ 67,600 $ 67,600 $ 33,800 $ 71,750 $ - $ 71,750 $ 77,490 $ 78,730 Expenditures: Non -Personnel Costs: 7324 Gen Fund Indirect Costs 1,479 1,497 1,545 795 1,590 1,590 13,107 13,317 7900 Depreciation Expense - 531,428 - 531,675 - 531,675 460,000 460,000 Total Non -Personnel Costs: 1,479 1,497 532,973 795 533,265 - 533,265 473,107 473,317 Total Expenditures: $ 1,479 $ 1,497 $ 532,973 $ 795 $ 533,265 $ - $ 533,265 $ 473,107 $ 473,317 18 SMIC General (12000-2500) Narrative/Notes 7023 Inspection and Testing 7302 Travel & Subsistence 7325 Gen Fund Indirect Costs Yukon Fire CDL training/testing Line added for 2025-2026 to adjust SMIC contribution to general fund to more accurately reflect revenue proportions SMIC Basin (12000-2501) Narrative/Notes 5000 Land Rents & Leases 5110 Crane Fees 7302 Travel & Subsistence All lease revenue is now coded to SMIC General 12000-2500 Technical issues with crane reporting software have created a delay in posting charges CDL training/testing SMIC 330-Ton Lift (12000-2500) Narrative/Notes 7009 Contracted Services 7023 Inspection & Testing 7216 Maintenance & Repair Increased based on contractor quotes for necessary repair and maintenance for lift Increased for lift inspection which will be split between Harbor & SMIC Increased based on quotes for necessary repairs and maintenance CITY OF SEWARD ELECTRIC ENTERPRISE FUND Projected Budgeted Statement of Cash Flow For Fiscal Year 2024, 2025 and 2026 Beginning Cash Balance at 0I/0I/2024 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 Infrastructure Projects Acquisitions Debt principal payments Net increase (decrease) in cash Estimated ending cash balance Restricted Available for operations a) Ties to December 3I, 2023 cash and investment balance per ACFR b) Revenue over expenditure and the I/2 of transfers out (PILT) c) Restricted cash to use to fund Infrastructure Project d) Projected cash need it to finalize the Infrastructure Project f) Cash used for Infrastructure Projects as of 6/30/24. Actuals 6/30 $6,286,65I a) ($2,468,856) b) I,585,000 ($883,856) (696,448) f) (205,000) ($ I,785,304) $4,50I,347 $2,053,530 c) $2,447,8I7 2025 Budget $4,50I,347 $0 I,853,433 $I,853,433 2026 Budget $2,484,780 $0 I,879,780 $ I,879,780 (3,500,000) d) (3,500,000) (370,000) (390,000) ($2,0I6,567) $2,484,780 $2,484,780 ($2,0I0,220) $474,560 $474,560 20 Revenue 15000-3000 General Operations Expenditures 15000-0900 15000-3000 15000-3001 15000-3004 15000-3005 15000-3006 15000-3007 Electric - Revenue & Expenditures $ Total: $ Non -operating revenue: $ Total Revenue: $ Debt Service Expense General Operations Admin Transmission Operations & Maintenance Distribution Operations & Maintenance Wholesale Power Costs Work Orders Total: Transfers Out* Total Expenditures Revenue over expenses: Motor Pool Rent: Depreciation Expense: Total Motor Pool Rent & Depreciation Expense: 2025 16,076,824 16,076,824 121,067 16,197,891 947,418 5,892,649 543,226 492,518 252,763 6,535,803 247,368 14,911,745 1,286,146 16,197,891 2026 $ 16,334,053 $ 16,334,053 $ 123,004 $ 16,457,057 $ 951,543 $ 6,006,752 $ 548,611 $ 498,118 $ 253,607 $ 6,640,376 $ 251,326 $ 15,150,333 $ 1,306,724 $ 16,457,057 0 $ 0 206,705 1,646,728 1,853,433 $ 206,705 $ 1,673,075 $ 1,879,780 Revenue over Expenditures (less depreciation expense and Motor Pool Rent): $ 1,853,433 $ *Transfers out: Transfers to General Fund: Transfers to Electric MRRF $ $ $ 1,286,146 $ - $ 1,286,146 $ 1,879,781 1,306,724 1,306,724 21 Electric Revenue (15000-0000) Expense Budget 2024 Proposed 2021 2022 2023 2024 Actuals 2024 Budgeted 2024 Final 2025 Proposed 2026 Actual Actual Actual (6/30) Budget Revision Budget Budget Budget Narrative Revenue: Operating Revenue 5300 Residential 1,681,663 1,678,200 1,742,309 1,270,615 2,000,000 569,667 2,569,667 2,432,200 2,471,115 5302 Residential fuel factor 1,599,022 1,780,206 1,800,307 1,077,886 1,815,187 1,815,187 1,868,660 1,898,559 5303 Residential customer charge 543,619 547,658 547,572 277,326 202,687 339,255 541,942 525,630 534,040 5310 SG Service 952,671 1,010,302 1,053,676 733,837 1,039,185 487,416 1,526,601 1,490,350 1,514,196 5312 SG fuel factor 826,087 1,002,547 1,036,912 592,395 957,112 957,112 1,098,260 1,115,832 5313 SG Customer Charge 275,960 284,413 288,067 145,290 122,176 132,536 254,712 277,460 281,899 5320 LG Service 1,360,301 965,674 908,359 894,941 1,648,129 275,773 1,923,902 1,403,480 1,425,936 5322 LG fuel factor 2,335,894 2,217,909 2,061,105 1,162,497 2,153,973 - 2,153,973 2,270,098 2,306,420 5323 LG customer charge 46,722 41,923 42,186 21,209 47,574 - 47,574 41,305 41,966 5324 LG demand charge 1,740,603 1,451,554 1,379,516 654,075 469,928 1,095,381 1,565,309 1,643,260 1,669,552 5327 RES Alternate Energy (50) (274) (448) - - - - 5340 Spec. Contract Energy 191,051 - - - - - - 5342 Special Contract fuel factor 207,077 - - - 5343 Spec. Contract customer charge 530 - - - - - 5345 Special Contract Demand 223,141 - - - - - 5350 Harbor Fund Power Sales 206,231 223,533 205,765 158,638 280,831 162,042 442,873 280,000 284,480 5352 Harbor power fuel factor 171,062 215,815 192,893 120,396 268,237 191,693 459,930 195,000 198,120 5360 Street & Yard 76,419 76,314 77,803 40,757 77,877 - 77,877 80,775 82,067 5362 Yard Light Fuel 6,401 7,809 8,521 5,115 7,592 7,592 8,900 9,042 5370 Industrial Service - 381,869 381,330 318,771 858,500 - 858,500 458,060 465,389 5371 Industrial Customer Charge 3,372 3,600 1,800 1,065,550 (1,064,796) 754 3,600 3,658 5372 Industrial Demand Charge - 627,413 670,360 275,275 758 125,496 126,254 700,000 711,200 5373 Industrial Fuel Factor - 1,066,628 1,038,470 532,900 126,250 939,300 1,065,550 1,015,095 1,031,337 5800 Labor & Services 267 333 - - - 5801 Turn on Fees 22,936 21,175 13,255 3,713 18,258 18,258 12,000 12,192 5802 Equipment Rental 1,350 14,755 5,484 5,484 5,000 5,080 5803 Joint Pole Use 10,212 10,212 10,212 10,314 - 10,314 10,000 10,160 5804 Work Order Revenue 76,494 816,556 256,927 30,000 227,691 257,691 257,691 261,814 5805 Chugach Coop Divid. 148,682 - - - - - 5890 Collection of Doubtful Accounts 604 142 - 5899 Misc Revenue 2,068 1,278 51,722 10,380 - Total Operating Revenue: 12,707,017 14,432,086 13,785,316 8,298,149 13,205,602 3,481,454 16,687,056 16,076,824 16,334,053 Non -Operating Revenue 5901 EF Investment Interest 17,917 118,977 389,811 22,124 35,000 160,000 195,000 36,050 36,627 5905 EF Penalties and Interest 18,874 23,090 22,572 35,367 26,800 - 26,800 27,604 28,046 5941 Amort. Bond Premium 13,834 13,834 55,741 55,741 - 55,741 57,413 58,332 Total Non -Operating Revenue: 50,625 155,901 468,124 57,491 117,541 160,000 277,541 121,067 123,004 Total Revenue: 12,757,642 14,587,987 14,253,440 8,355,640 13,323,143 3,641,454 16,964,597 16,197,891 16,457,057 22 Electric Operations (15000-3000) Expense Budget 2024 Proposed 2021 2022 2023 2024 Actuals 2024 Budgeted 2024 Final 2025 Proposed 2026 Actual Actual Actual (6/30) Budget Revision Budget Budget Budget Narrative Expenditures: Personnel Costs: 6000 Salaries 541,375 566,483 549,234 265,711 802,990 802,990 640,975 666,615 6001 Overtime 40,553 35,996 45,706 18,945 34,170 - 34,170 55,000 55,000 6002 Standby Time 6,377 5,670 162,191 65,589 141,595 141,595 125,000 125,000 6100 Medicare 9,206 9,354 11,682 5,135 8,706 - 8,706 13,000 13,500 6101 Unemployment Insurance - - 3,751 - - - 0 0 6102 Workers' Compensation 19,694 4,169 18,697 7,549 32,727 (17,616) 15,111 24,307 24,307 6200 Leave Time 55,173 13,692 - - - 0 0 6201 Retirement Benefits 73,861 111,607 128,758 57,694 119,027 - 119,027 154,000 160,150 6202 Health Insurance 117,673 157,644 127,390 71,712 176,751 176,751 148,000 153,900 6203 In Lieu of FICA - - - - 5,100 - 5,100 0 0 6204 Electric Meal Allowance 4,899 3,781 25,106 3,291 6,528 6,528 10,000 10,000 6205 Electric Union Benefits 7,171 1,212 1,352 815 8,025 - 8,025 2,500 2,500 6210 Air Ambulance Benefit - 1,030 1,100 1,100 6211 Met Life - Life Benefit - - - - - - - 0 0 Total Personnel Costs: 875,982 909,610 1,073,867 497,471 1,335,619 (17,616) 1,318,003 1,173,882 1,212,072 Non -Personnel Costs: 7000 Audit - - - - 7001 Communications 9,291 6,559 12,104 6,297 7,650 - 7,650 12,854 13,060 7002 Postage and Freight 15,046 18,356 26,777 6,488 17,136 17,136 28,437 28,892 7003 Bank and Credit Card Fees 113,471 125,488 129,302 25,475 - 150,000 150,000 137,319 139,516 7004 lnsurance 97,260 110,878 136,256 74,025 116,175 7,882 124,057 144,704 147,019 7006 Legal 11,100 16,717 56,837 5,441 45,000 - 45,000 60,361 61,327 7009 Contracted Services 152,741 74,103 85,214 164,469 325,000 850,000 1,175,000 831,784 846,146 7010 Engineering 30,104 426,423 19,980 5,625 51,000 - 51,000 21,219 21,558 7011 Testing 881 4,408 3,274 17,500 17,500 17,500 17,780 7012 Other Special Services 9,235 8,940 - 20 4,500 - 4,500 - - 7015 Utilities 6,034 8,744 182,577 6,457 199,920 (188,000) 11,920 19,310 19,619 7016 Heating Fuel 7,817 19,238 24,190 10,982 36,720 - 36,720 25,690 26,101 7017 Rents & Leases 3,513 4,249 2,689 501 6,222 6,222 2,856 2,901 7022 Software/SaaS - 30 - - - - - - - 7023 Inspection and Testing - - - 7103 Fuel for Generators 755 - 58,508 - 185,000 - 185,000 40,000 40,000 7210 Vehicle Supplies 20,262 25,084 24,978 14,540 20,000 20,000 26,527 26,951 7211 Gas & Lube 22,726 39,263 35,035 6,136 34,000 - 34,000 37,207 37,802 7212 Uniform Allowance 7,290 7,788 16,280 3,946 12,200 12,200 17,289 17,566 7213 Safety Equipment 4,355 13,757 2,200 1,493 22,900 - 22,900 2,336 2,374 7214 Janitorial Supplies - - - - 7215 Operating Supplies 166,385 261,722 22,462 27,792 50,000 67,805 117,805 23,855 24,236 7216 Maintenance & Repair 10,728 4,537 21,344 632 37,400 37,400 22,667 23,030 7217 Small Tools & Equipment 11,766 10,060 4,414 10,238 20,000 - 20,000 10,000 10,160 7221 Operating Materials - 1,144 98,723 300,000 87,311 387,311 411,324 417,905 7222 Computer Hardware - - - - - - - - - 7300 Advertising 2,608 3,921 9,708 4,689 4,500 4,500 23 Electric Operations (15000-3000) Expense Budget 2024 Proposed 2021 2022 2023 2024 Actuals 2024 Budgeted 2024 Final 2025 Proposed 2026 Actual Actual Actual (6/30) Budget Revision Budget Budget Budget Narrative 7301 Subscriptions & Dues 21,417 25,169 29,167 27,508 75,000 75,000 30,975 31,471 7302 Travel & Subsistence 2,651 6,047 4,677 108 8,500 - 8,500 10,000 10,160 7303 Education & Training 292 4,614 2,935 2,066 7,500 7,500 10,000 10,160 7304 Equipment Rent 1,563 - 5,000 - 5,000 - - 7307 GF Administrative Fee 976,322 1,005,612 1,035,780 533,428 1,066,855 1,066,855 1,013,512 1,029,728 7311 RRC - ERO Surcharge 2,221 23,720 12,251 - 25,191 25,594 7808 Bad Debt Expense 56,396 50,172 30,426 25,000 25,000 53,283 54,135 7810 Miscellaneous Expense 4,125 14,679 2,986 - - 7900 Depreciation Expense 1,583,677 1,550,591 - 1,585,000 1,585,000 1,646,728 1,673,075 8001 Unrealized Loss on Investments 1,636 - - - - - 8010 Utility Deposit Intererest 2,461 964 108 68 1,500 1,500 115 117 8103 Capital Equipment 15,977 30,144 33,639 2,624 - - 35,725 36,296 8104 Motor Pool Rent - 50,000 25,000 50,000 50,000 - Total Non -Personnel Costs: 1,785,327 3,845,186 3,671,875 1,113,708 4,337,178 974,998 5,312,176 4,718,767 4,794,681 Total Expenditures: 2,661,309 4,754,796 4,745,742 1,611,179 5,672,797 957,382 6,630,179 5,892,649 6,006,752 24 2024 Proposed Proposed Electric Administration (15000-3001) 2021 2022 2023 2024 Actuals 2024 Budgeted 2024 Final 2025 2026 Expense Budget Actual Actual Actual (6/30) Budget Revision Budget Budget Budget Narrative Expenditures: Personnel Costs: 6000 Salaries 157,736 169,606 132,195 48,009 197,890 197,890 175,183 177,986 Two vacant defunded due to MEA contract. 6001 Overtime (37) 409 6002 Standby Time - - - 6100 Medicare 3,473 2,819 1,967 697 2,875 2,875 2,540 2,581 6101 Unemployment Insurance - - 5,445 - - 6102 Workers' Compensation 674 759 580 219 865 865 754 766 6200 Leave Time 19,417 1,651 6201 Retirement Benefits 30,541 44,425 31,826 10,966 43,560 43,560 38,540 39,157 6202 Health Insurance 98,987 90,185 87,529 38,260 118,962 118,962 96,282 97,822 6205 Electric Union Benefits 100 42 12 72 50 50 6210 Air Ambulance Benefit - 49 - - - - - 6211 Met Life - Life Benefit 23 - TotalPersonnelCosts: 310,891 309,486 259,963 98,295 364,202 - 364,202 313,299 318,312 Non -Personnel Costs: 7001 Communications 1,089 3,953 3,280 81 12,000 12,000 3,483 3,539 7002 Postage and Freight 519 74 26 25 300 300 28 28 7004 Insurance 216 125 114 56 300 46 346 121 123 7006 Legal - 546 55,187 10,568 45,000 45,000 7009 Contracted Services 16,022 19,153 1,922 242 18,000 18,000 - 7011 Testing 600 611 - 600 600 - - 7012Other Special Services 10,000 10,226 30 32 32 7016 Heating Fuel 143 - - - - - 7017 Rents & Leases 6,341 - 7022 Software/SaaS 474 238 5,000 5,000 503 511 7210 Vehicle Supplies 523 - - 7211 Gas & Lube 1,153 1,049 231 - 1,700 1,700 245 249 7212 Uniform Allowance - - - 500 500 7213 Safety Equipment 500 500 7215 Operating Supplies 2,386 2,254 5,223 558 6,000 67,805 73,805 5,547 5,636 7216 Maintenance & Repair 365 - - - 500 500 - - 7217 Small Tools & Equipment - - - 3,500 3,500 - - 7221 Operating Materials - - - - - 7222 Computer Hardware 7300 Advertising 3,272 3,323 106 250 5,500 5,500 113 114 7301 Subscriptions & Dues 14,700 1,906 900 6,500 6,500 956 971 7302 Travel & Subsistence 7,426 6,483 2,207 176 16,000 16,000 5,000 5,080 7303 Education & Training 530 7,748 359 910 6,750 6,750 7,000 7,112 7304 Equipment Rent 405 131 - 1,500 1,500 139 141 7810 Miscellaneous Expense 200 52 (161) 55 56 8103 Capital Equipment - - - - 8104 Motor Pool Rent 271,029 299,780 35,000 17,500 35,000 35,000 206,705 206,705 Total Non -Personnel Costs: 335,991 358,159 105,242 30,443 165,150 67,851 233,001 229,927 230,299 Total Expenditures: 646,882 667,645 365,205 128,738 529,352 67,851 597,203 543,226 548,611 25 Electric Transmissions Operations & Maintenance 2024 Proposed (15000-3004) 2021 2022 2023 2024 Actuals 2024 Budgeted 2024 Final 2025 Proposed 2026 Expense Budget Actual Actual Actual (6/30) Budget Revision Budget Budget Budget Narrative Expenditures: Personnel Costs: 6000 Salaries 5,500 26,883 4,235 1,402 24,918 - 24,918 4,498 4,570 6001 Overtime 3,475 33,681 10,307 648 24,690 24,690 10,946 11,121 6100 Medicare 148 876 211 30 1,220 - 1,220 224 228 6102 Workers' Compensation 462 1,859 354 50 2,325 2,325 376 382 6200 Leave Time - - - 6201 Retirement Benefits 2,004 10,136 2,228 286 16,840 16,840 2,366 2,404 6202 Health Insurance 2,526 9,235 1,250 72 9,645 - 9,645 1,328 1,349 6205 Electric Union Benefits 24 116 33 1 145 145 35 36 6210 Air Ambulance Benefit - - - - - - 6211 Met Life - Life Benefit - - Total Personnel Costs: 14,139 82,786 18,618 2,489 79,783 79,783 19,772 20,088 Non -Personnel Costs: 7002 Postage and Freight - - 7009 Contracted Services 402,390 824,070 249,212 - - 400,000 400,000 7010 Engineering - - 7012 Other Special Services - - 7017 Rents & Leases 16,500 16,633 16,710 16,400 10,000 17,746 18,030 7022 Software/SaaS - - 55,000 60,000 7210 Vehicle Supplies - 106 - - 7211 Gas & Lube - - - - - - 7215 Operating Supplies - 6,445 - 7216 Maintenance & Repair - - - 2,500 - - 7217 Small Tools & Equipment - 7221 Operating Materials - - - - - - - 7301 Subscriptions & Dues 33 - - - - - 7302 Travel & Subsistence - - - - - - - 7304 Equipment Rent - - - - - - 7810 Miscellaneous Expense - - Total Non -Personnel Costs: 418,923 847,254 265,922 16,400 12,500 472,746 478,030 Total Expenditures: 433,062 930,040 284,540 18,889 92,283 492,518 498,118 26 Electric Distribution Operations & Maintenance (15000- 2024 Proposed Proposed 3005) 2021 2022 2023 2024 Actuals 2024 Budgeted 2024 Final 2025 2026 Expense Budget Actual Actual Actual (6/30) Budget Revision Budget Budget Budget Narrative Expenditures: Personnel Costs: 6000 Salaries 5,717 9,369 3,534 1,190 13,515 - 13,515 3,753 3,813 6001 Overtime 49,944 38,178 34,241 18,451 44,705 - 44,705 36,364 36,946 6002 Standby Time - - - - - - - - - 6100 Medicare 918 684 637 285 1,030 - 1,030 676 687 6102 Workers' Compensation 2,393 1,408 994 392 1,650 - 1,650 1,055 1,072 6200 Leave Time - - - - - - - 6201 Retirement Benefits 12,714 7,659 6,423 2,805 12,810 - 12,810 6,821 6,930 6202 Health Insurance 8,879 6,373 3,815 2,259 8,550 - 8,550 4,052 4,116 6204 Electric Meal Allowance 1,921 420 - - 600 - 600 - - 6205 Electric Union Benefits 82 87 40 29 100 - 100 42 43 6210 Air Ambulance Benefit - - - 6211 Met Life - Life Benefit - Total Personnel Costs: 82,568 64,178 49,683 25,411 82,960 82,960 52,763 53,607 Non -Personnel Costs: 7009 Contracted Services 9,434 - - 200,000 200,000 7215 Operating Supplies 36,818 - 26,450 - 30,000 67,805 97,805 - - Total Non -Personnel Costs: 46,252 26,450 30,000 67,805 97,805 200,000 200,000 Total Expenditures: 128,820 64,178 76,133 25,411 112,960 67,805 180,765 252,763 253,607 Electric Distribution Wholesale Power (15000-3006) Expense Budget 2024 Proposed 2021 2022 2023 2024 Actuals 2024 Budgeted 2024 Final 2025 Proposed 2026 Actual Actual Actual (6/30) Budget Revision Budget Budget Budget Narrative Expenditures: Non -Personnel Costs: 7101 Chugach Power Purchases 3,455,322 3,457,916 3,207,089 1,509,274 2,393,004 2,098,916 4,491,920 3,405,929 3,460,423 7102 Power Fuel Costs 2,569,178 2,893,156 2,947,151 1,285,799 3,708,000 111,176 3,819,176 3,129,874 3,179,952 Total Non -Personnel Costs: 6,024,500 6,351,072 6,154,240 2,795,073 6,101,004 2,210,092 8,311,096 6,535,803 6,640,376 Total Expenditures: 6,024,500 6,351,072 6,154,240 2,795,073 6,101,004 2,210,092 8,311,096 6,535,803 6,640,376 28 Electric Distribution Work Orders(15000-3007) Expense Budget 2024 Proposed Proposed 2021 2022 2023 2024 Actuals 2024 Budgeted 2024 Final 2025 2026 Actual Actual Actual (6/30) Budget Revision Budget Budget Budget Narrative Expenditures: Personnel Costs: 6000 Salaries 63,054 98,233 170,084 28,323 72,320 - 72,320 180,629 183,519 6001 Overtime 4,906 5,152 202,376 21,692 1,525 - 1,525 214,924 218,363 6002 Standby Time - - 699 (699) - - - 742 754 6100 Medicare 1,035 1,495 5,450 716 1,050 - 1,050 5,788 5,880 6102 Workers' Compensation 1,915 2,822 9,104 1,055 2,540 2,540 9,668 9,823 6200 Leave Time - - - - - - - - 6201 Retirement Benefits 16,526 18,408 49,858 7,311 15,910 15,910 52,949 53,797 6202 Health Insurance 15,495 21,242 39,196 6,321 16,125 16,125 41,626 42,292 6204 Electric Meal Allowance - - 803 - - - 852 866 6205 Electric Union Benefits 150 205 518 67 200 - 200 551 559 6210 Air Ambulance Benefit - 6211 Met Life - Life Benefit - Total Personnel Costs: 103,081 147,558 478,087 64,786 109,670 109,670 507,729 515,853 Non -Personnel Costs: 7009 Contracted Services 30,740 - 7010 Engineering 5,205 18,039 - 7016 Heating Fuel 400 7017 Rents & Leases 6,510 7103 Fuel for Generators 166,344 7211 Gas & Lube 215 - 997 7215 Operating Supplies 1,838 103,290 1,802 7216 Maintenance & Repair 22,882 7221 Small Tools & Equipment 232 7301 Subscriptions & Dues 60 7302 Travel & Subsistence 178 7810 Miscellaneous Expense 1,520 8200 Work Order Sal/Benefit Credits (19,164) 22,500 8201 Work Order Operating Supply Credits (9,668) - 13,487 8202 Work Order New Service/Upgrade Credits 10,648 - 1,914 1,944 24,301 24,689 246 250 189 192 1,614 1,640 23,895 24,277 (312,520) (317,520) Total Non -Personnel Costs: (10,681) 152,284 228,945 7,507 Total Expenditures: 92,400 299,842 707,032 72,293 109,670 (260,361) (264,527) 109,670 247,368 251,326 2024 YTD Proposed Electric - Debt Service (15000-0900) 2021 2022 2023 Actuals 2024 2025 2026 Expense Budget Actual Actual Actual (6/30) Budget Budget Budget Narrative Expenditures: Personnel Costs: 6201 Retirement Benefits 20,086 (728,470) (98,698) Total Personnel Costs: 20,086 (728,470) (98,698) Non -Personnel Costs: 8012 Debt Service Interest Expense 159,700 465,852 582,533 24,425 576,700 561,242 545,367 8013 Amortize Deferred Loss on Bonds - - 16,176 16,176 16,176 8014 Bond Issue Costs - 90,380 - - - - 8300 Debt Service Principal - - 205,000 370,000 390,000 Total Non -Personnel Costs: 159,700 556,232 598,709 24,425 781,700 947,418 951,543 Total Expenditures: $ 179,786 $ (172,238) $ 500,011 $ 24,425 $ 781,700 $ 947,418 $ 951,543