Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
10212021 City Council Work Session LAYDOWN - Electric MotorPool and CIP
Electric - Revenue & Expenditures Revenue 15000-3000 General Operations 15000-3007 Work Orders Expenditures 15000-0900 Debt Service 15000-3000 General Operations 15000-3001 Admin 15000-3002 Standby Generation 15000-3003 Substation Operations 15000-3004 Transmission Operations & Maintenance 15000-3005 Distribution Operations & Maintenance 15000-3006 Wholesale Power Costs 15000-3007 Work Orders $ 14,239,943.61 $ 1,500.00 Total: $ 14,241,443.61 $ 365,353.00 $ 5,817,813.02 $ 845,772.42 $ 183,939.00 $ 345,545.00 $ 575,836.00 $ 109,742.40 $ 5,922,950.00 $ 126,267.00 Total: $ 14,293,217.85 Transfers Out $ 1,518,020.84 Total Expenditures $ 15,811,238.69 Motor Pool Rent: $ 299,780.00 Depreciation Expense: $ 2,571,610.53 Total Motor Pool Rent & Depreciation Expense: $ 2,871,390.53 Total expenditures (less depreciation and Motor Pool Rent): $ 12,939,848.16 Revenue over Expenditures (less depreciation expense and Motor Pool Rent): $ 1,301,595.45 Note: anticipated bond payment: $ 1,100,000.00 Projected revenue over expenses after bond payment: $ 201,595.45 Electric - Debt Service Expenditures (15000-0900) Electric Debt Service (15000-0900) Expense Budget 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended Budget 2021 YTD Actuals 2022 Proposed Notes/Comments Expenditures: Personnel Costs: 6201 Retirement Benefits 0 0 0 -465,787 20,882 52,266 13,989 0 6209 PERS DC Forfeitures 0 0 0 0 -180 0 0 0 6201 Retirement Benefits 44,059 47,290 40,998 0 0 0 0 0 6209 PERS DC Forfeitures 0 0 -7,771 -591 0 0 0 0 Total Personnel Costs: $44,059 $47,290 $33,227 -$466,378 $20f7O2 $52,266 $13,989 $0 Non -Personnel Costs: 8012 Debt Service Interest Expense 0 0 0 176,803 171,950 163,450 163,450 154,450 8014 Debt Service Amortization of Bond Issue Costs 0 0 0 0 0 20,903 0 20,903 8300 Debt Service Principal 0 0 0 0 170,000 180,000 180,000 190,000 8011 Bonding Expense 73,458 41,137 0 0 0 0 0 0 8012 Debt Service Interest Expense 185,626 192,344 184,242 0 0 0 0 0 8013 Amortize Deferred Loss on Bonds 0 20,903 20,903 20,903 0 0 0 0 8014 Amortization of Bond Issue Costs 0 0 0 0 0 0 0 0 8300 Debt Service Principal 240,000 150,000 160,000 0 0 0 0 0 Total Non -Personnel Costs: $499,083 $404,384 $365,146 $197,707 $341,950 $364,353 $343,450 $365,353 Total Expenditures: $543,143 $451,675 $398,373 -$268,672 $362,652 $416,619 $357,439 $365,353 Electric - General Operations Revenue and Expenditures (15000-3000) Electric General Operations (15000-3000) Revenue and Expense Budget 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended Budget 2021 YTD Actuals 2022 Proposed Notes/Comments Revenues: Operating Revenue: 5923 Spec.Proj.Other Rev. 0 475,914 0 0 0 0 0 0 5300 Residential 1,952,352 2,072,006 1,517,626 1,560,795 1,620,502 1,428,243 1,187,440 1,810,000 5302 Residential fuel factor 818,728 1,068,739 1,247,069 1,446,779 1,572,977 1,415,915 1,031,047 1,565,129 5303 Residential customer charge 491,087 503,864 519,020 532,922 537,941 514,725 317,229 481,553 5310 SG Service 1,087,722 1,105,833 862,705 891,121 949,500 891,273 667,849 1,050,000 5312 SG fuel factor 408,643 520,371 631,499 748,381 756,268 636,568 542,328 830,000 5313 SG Customer Charge 215,252 226,855 241,554 256,587 168,533 230,574 159,005 242,000 5320 LG Service 1,930,492 1,916,749 1,091,555 954,374 1,178,426 1,391,272 1,117,649 1,200,000 5322 LG fuel factor 1,184,352 1,436,201 1,688,124 1,970,753 2,235,192 1,851,640 1,485,574 1,889,500 5323 LG customer charge 44,673 46,327 47,062 46,457 47,766 46,901 27,365 45,260 5324 LG demand charge 1,390,664 1,384,044 1,316,334 1,640,879 1,613,997 1,455,485 948,968 1,526,645 5326 Alternate Energy -505 0 -145 0 0 0 0 0 5327 RES Alternate Energy 0 0 0 0 -24 0 -50 0 5340 Spec. Contract Energy 177,930 285,470 347,979 353,492 197,844 497,910 143,842 0 5342 Special Contract fuel factor 402,817 547,322 493,290 472,661 318,992 505,829 125,171 0 5343 Spec. Contract customer charge 988 1,010 1,290 1,572 525 1,090 309 0 5345 Special Contract Demand 411,577 439,898 417,577 527,732 237,264 434,000 130,115 0 5350 Harbor Fund Power Sales 308,846 276,617 212,669 170,706 189,105 285,000 137,314 191,500 5352 Harbor power fuel factor 108,693 117,926 153,716 140,681 159,892 112,640 109,872 161,900 5360 Street & Yard 65,660 65,522 70,096 73,270 76,209 71,680 50,438 77,200 5362 Yard Light Fuel 3,862 4,646 5,897 6,659 6,589 4,096 3,725 5,900 5370 Industrial Service 0 0 0 0 0 0 0 499,500 5371 Industrial Customer Charge 0 0 0 0 0 0 0 1,600 5372 Industrial Demand Charge 0 0 0 0 0 0 0 675,200 5373 Industrial Fuel Factor 0 0 0 0 0 0 0 905,150 5800 Labor & Services 0 0 0 0 0 0 267 0 5801 Turn on Fees 19,776 17,833 27,779 23,745 18,243 20,480 15,568 21,800 5802 Equipment Rental 19,660 47,189 11,893 12,458 0 20,480 1,350 2,125 5803 Joint Pole Use 9,984 10,152 10,776 10,776 10,776 10,240 0 10,800 5804 Work Order Revenue 36,159 21,021 21,865 16,528 121,668 20,480 8,149 30,000 Note: 2019 & 2020 work orders are combined 5805 Chugach Coop Divid. 251,370 92,359 23,616 302,329 53,936 0 0 0 5890 Collection of Doubtful Accounts 1,400 0 868 129 0 800 604 550 5899 Miscellaneous Revenue 5,880 0 9,199 26,749 126,588 5,120 1,269 0 Total Operating Revenue: $11,348,061 $12,683,868 $10,970,911 $12,188,534 $12,198,708 $11,852,441 $8,212,396 $13,223,312 Non -Operating Revenue: 5901 EF Investment Interest 6,074 69,101 86,204 203,644 179,082 30,000 22,761 11,150 5905 EF Penalties and Interest 50,585 48,333 27,752 41,201 6,685 40,000 13,436 23,950 5919 Contra PERS On -Behalf paid by SOA -2,463 4,931 0 0 0 0 0 0 5919 Contra PERS On -Behalf paid by SOA 39,731 28,811 -5,583 0 0 0 0 0 5920 PERS On -Behalf paid by SOA 0 0 0 -66,947 10,385 0 0 0 5940 Amort. of CIA - General 775,741 981,212 990,369 983,351 984,193 975,887 0 967,531 5941 Amort.Bond Premium 13,834 13,834 13,834 13,834 0 14,000 0 14,000 5990 Surplus Sales 200 0 0 0 0 0 0 0 Total Non -Operating Revenue: $883,703 $1,146,223 $1,112,576 $1,175,083 $1,180,345 $1,059,887 $36,198 $1,016,631 Total Revenues: 12,231,764 13,830,092 12,083,488 13,363,617 13,379,053 12,912,328 8,248,594 14,239,944 Electric - General Operations Revenue and Expenditures (15000-3000) 2021 Electric General Operations (15000-3000) 2016 2017 2018 2019 2020 Amended 2021 YTD 2022 Revenue and Expense Budget Actual Actual Actual Actual Actual Budget Actuals Proposed Notes/Comments Expenditures: Personnel Costs: 6000 Salaries 6001 Overtime 6002 Standby Time 6100 Medicare 6101 Unemployment Insurance 6102 Workers' Compensation 6200 Leave Time 6201 Retirement Benefits 6202 Health Insurance 6204 Electric Meal Allowance 6205 Electric Union Benefits 6209 Contra -Retirement PERS DC Forfeitures Total Personnel Costs: Non -Personnel Costs: 7000 Audit 7001 Communications 7002 Postage and Freight 7003 Bank and Credit Card Fees 7004 Insurance 7005 CY Insurance Recovery 7006 Legal 7009 Contracted Services 7010 Engineering 7011 Testing 7012 Other Special Services 7013 State Lobbying Fees 7015 Utilities 7016 Heating Fuel 7017 Rents & Leases 7019 Contracted Services - Healthcare Providers 7020 CHC Recruitment/ Retention 7100 General Power for Resale 7103 Fuel for Generators 7210 Vehicle Supplies 7211 Gas & Lube 7212 Uniform Allowance 7213 Safety Equipment 7214 Janitorial Supplies 7215 Operating Supplies 7216 Maintenance & Repair 7217 Small Tools & Equipment 7218 Inmate Meals 7220 CHC Medications 7300 Advertising 7301 Subscriptions & Dues 7302 Travel & Subsistence CARES Funding See Below 381,709 411,769 444,032 469,146 488,066 439,981 318,601 490,750 Includes Gen Ops & Meter Service 34,890 84,490 71,274 52,312 12,621 20,330 30,223 49,600 93,285 93,999 95,317 110,618 131,267 100,626 126,949 155,000 8,737 11,270 10,445 10,903 10,093 7,240 8,025 16,871 594 7,968 698 0 -31 0 0 0 33,860 76,082 52,348 51,128 40,435 47,548 20,277 35,826 49,079 52,309 55,380 60,107 76,889 74,649 41,994 0 448,111 -15,709 102,056 131,428 107,564 104,210 79,094 165,053 104,689 114,425 121,442 138,657 125,664 107,310 103,161 180,048 7,085 12,596 5,264 5,694 7,809 7,373 1,347 6,898 9,094 17,056 1,256 1,872 12,318 21,504 7,222 13,523 0 0 0 -2,516 0 0 0 0 $1,171,134 $866,255 $959,511 $1,029,348 $1,012,695 $930f771 $736,892 $1,113,569 0 0 0 0 0 0 2,585 7,156 6,172 6,200 11,158 7,680 6,266 9,400 10,426 18,590 13,244 14,449 18,747 16,384 4,821 13,750 59,292 68,829 77,500 100,268 105,020 92,938 50,911 115,522 58,949 58,375 64,657 74,346 82,925 66,560 44,909 91,218 0 0 0 0 0 0 0 51,468 19,964 13,745 39,897 11,732 46,080 8,588 45,000 147,030 156,018 250,402 175,347 82,396 175,689 133,652 280,000 Combined w/Gen Ops, Admin, Substations 995 11,461 1,470 2,866 9,987 60,000 24,061 70,000 1,587 4,505 3,210 2,826 4,055 0 0 10,000 9,159 1,358 2,651 2,985 11,186 0 4,601 5,700 0 0 0 0 0 0 0 0 4,972 3,568 4,375 4,578 5,234 4,608 4,750 8,000 7,924 12,397 25,917 12,310 22,032 12,288 7,374 18,000 0 930 125 1,508 2,052 3,072 3,354 2,075 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 997 38,176 6,223 0 0 5,000 32,140 21,105 12,059 25,315 8,755 10,240 13,480 19,950 12,835 22,555 20,750 21,780 27,653 28,160 13,746 28,200 0 0 426 24,191 6,009 17,000 5,043 12,000 2,839 1,031 6,919 36,478 8,592 5,120 1,020 9,575 0 0 0 0 27 0 0 0 216,839 219,867 221,885 73,593 452,779 107,520 150,213 180,295 2,464 33,116 10,238 84,398 25,311 56,200 4,438 25,575 38,172 16,518 12,742 40,878 3,856 15,360 5,726 30,720 0 0 0 0 0 0 0 0 0 0 0 0 0 0 207 0 287 2,143 65 1,071 351 5,120 1,516 5,120 1,669 2,885 2,994 7,305 7,673 5,734 20,451 31,000 2,788 2,656 13,941 4,549 1,130 8,192 1,608 5,000 Electric - General Operations Revenue and Expenditures (15000-3000) Electric General Operations (15000-3000) Revenue and Expense Budget 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended Budget 2021 YTD Actuals 2022 Proposed Notes/Comments 7303 Education & Training 1,862 462 5,504 10,792 3,482 8,192 133 5,550 7304 Equipment Rent 0 0 0 30,127 0 5,120 1,013 5,120 Non -Personnel Costs: 7307 GF Administrative Fee 888,535 909,860 938,293 953,306 964,747 976,185 976,322 1,005,612 3% increase over combined total 7320 Harbor Overhead 0 0 0 0 0 0 0 0 7324 Gen Fund Indirect Costs 0 0 0 0 0 0 0 0 7330 P.I.L.T. 902,861 973,193 874,797 969,027 976,606 948,131 482,526 1,129,271 7331 Reclass PILTto Transfer-Out -902,861 -973,193 -874,797 -969,027 -976,606 -948,131 -482,526 -1,129,271 7805 Promotion 0 0 0 0 0 0 0 0 7808 Bad Debt Expense 3,686 8,297 52,844 57,679 -26,454 20,480 35,983 32,175 7810 Miscellaneous Expense 2,730 36,957 557 1,233 2,032 20,480 3,148 3,150 7900 Depreciation Expense 1,437,196 1,573,002 1,619,279 1,581,445 1,564,187 1,598,522 0 2,560,132 8000 Loss on Disposal 0 0 0 216,068 0 0 0 0 8001 Unrealized Loss on Investments 0 0 0 0 0 0 0 0 8010 Utility Deposit Interest 1,232 1,300 1,324 1,105 258 1,229 207 925 8011 Bonding Expense 0 0 0 0 0 0 0 0 8100 Land 0 0 0 0 0 0 0 0 8101 Infrastructure 0 0 0 0 0 143,360 0 20,480 8102 Buildings 0 0 0 0 5,000 0 0 0 8103 Capital Equipment 0 0 63,268 0 5,265 46,080 44,063 50,000 Tilt trailer for small excavator 8104 Motor Pool Rent 97,200 90,000 90,000 0 90,000 0 0 0 8105 Improvements other than Buildings 0 0 3,450 0 0 0 0 0 8200 Work Order Sal/Benefit credits 0 0 0 0 -28,638 0 -705 0 8201 Work Order Operating Supply credits 0 0 0 0 -95,284 0 -1,640 0 Total Non -Personnel Costs: $3,096,860 $3,304,907 $3,541,003 $3,647,072 $3,399,478 $3,563,593 $1,569,257 $4,704,244 Total Expenditures: $4,267,994 $4,171,162 $4,500,514 $4,676,420 $4,412,173 $4,494,364 $2,306,150 $5,817,813 This combines Revenues, Expenses, Standby, Meter Service and System improvements together CARES Funding Applied to 2020 Personnel Salaries $ 10,756.35 Overtime $ 174.13 Standby $ 564.29 Medicare $ 188.77 Unemployment Insurance $ 30.94 Workers Comp $ 525.48 Leave Time $ 1,073.38 Retirement Benefits $ 2,367.66 Health Insurance $ 2,549.14 Meal Allowance $ 5.26 Union Benefits $ 41.27 Total Funding Applied to Personnel: $ 18,276.67 Electric - Administration Expenditures (15000-3001) Electric Administration (15000-3001) Expense Budget 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended Budget 2021 YTD Actuals 2022 Proposed Notes/Comments Expenditures: CARES Funding - Personnel Costs: See Below 6000 Salaries 225,401 219,329 187,333 155,636 206,217 294,066 104,365 235,623 6001 Overtime 1,661 1,387 32 28 0 750 -37 1,102 6002 Standby Time 49 0 0 0 0 0 0 0 6100 Medicare 4,789 3,842 3,956 2,358 3,146 4,508 1,993 4,774 6101 Unemployment Insurance 0 0 6,188 0 370 0 0 0 6102 Workers' Compensation 2,727 3,352 2,099 1,512 965 2,579 575 0 6200 Leave Time 31,000 35,031 32,136 28,181 3,012 32,211 13,750 0 6201 Retirement Benefits 27,615 24,053 16,520 34,756 17,112 16,137 12,268 63,635 6202 Health Insurance 88,906 90,919 76,855 75,875 73,908 133,200 67,244 122,973 6203 In Lieu of FICA 0 0 0 0 0 0 0 0 6204 Electric Meal Allowance 0 0 0 0 0 0 0 0 6205 Electric Union Benefits 0 0 0 0 167 0 48 0 Total Personnel Costs: $382,148 $377,912 $325,120 $298,347 $304,897 $483,451 $200,206 $428,107 Non -Personnel Costs: 7001 Communications 10,628 16,090 10,101 9,450 2,776 10,240 404 11,600 7002 Postage and Freight 345 11 550 9 30 500 374 275 7003 Bank and Credit Card Fees 0 38 0 0 1 0 0 0 7004 Insurance 160 307 140 202 217 0 56 260 7006 Legal 11,899 1,925 0 0 0 5,000 0 0 7007 Legal Settlement 852 0 0 0 0 0 0 0 7009 Contracted Services 5,928 57,770 92,667 13,290 43,370 81,920 6,248 0 Moved to general cps 7010 Engineering 1,199 0 0 0 0 0 0 0 7011 Testing 168 307 1,398 1,307 123 1,000 0 550 7012 Other Special Services 12,755 12,131 10,000 10,000 10,000 15,360 10,000 10,000 7016 Heating Fuel 0 0 0 0 0 0 143 0 7017 Rents & Leases 0 2,080 0 0 0 0 6,341 7,000 7210 Vehicle Supplies 1,161 0 0 0 0 0 0 0 7211 Gas & Lube 2,100 18,464 5,333 0 36 3,072 877 4,550 7212 Uniform Allowance 0 43 1,356 472 104 0 0 3,000 7213 Safety Equipment 0 0 329 320 0 500 0 400 7215 Operating Supplies 8,381 9,442 8,115 16,771 1,106 10,240 7,345 10,240 7216 Maintenance & Repair 0 0 0 1,142 338 0 0 300 7217 Small Tools & Equipment 0 1,797 0 20,034 435 10,240 0 4,450 7300 Advertising 307 6,275 1,324 666 409 1,024 855 5,000 7301 Subscriptions & Dues 44,402 7,175 27,760 2,187 1,661 31,920 14,587 27,800 7302 Travel & Subsistence 18,970 25,684 23,266 17,942 4,511 20,000 1,814 21,500 7303 Education & Training 3,161 14,672 6,214 2,874 0 15,360 0 6,750 7304 Equipment Rent 2,552 2,552 5,037 0 0 3,072 0 2,575 7810 Miscellaneous Expense 0 341 3,214 0 0 0 200 650 7900 Depreciation Expense 7,430 5,104 5,104 5,104 0 0 0 985 8103 Capital Equipment 0 0 0 0 4,925 10,240 14,500 0 8104 Motor Pool Rent 194,400 85,000 180,000 270,000 270,000 276,480 271,029 299,780 Truck Total Non -Personnel Costs- $326,798 $267,206 $381,908 $371,769 $340,040 $496,168 $334,773 $417,665 Total Expenditures: $708,946 $645,118 $707,028 $670,116 $644,937 $979,619 $534,979 $845,772 CARES Funding Applied to 2020 Personnel Salaries $ 541.24 Overtime $ Standby $ Medicare $ 7.85 Unemployment Insurance $ Workers Comp $ 2.81 Leave Time $ 41.61 Retirement Benefits $ 94.41 Health Insurance $ 997.80 Meal Allowance $ Union Benefits $ Total Funding Applied to Personnel: $ 1,685.72 Electric - Standby Generation Expenditures (15000-3002) Electric Standby Generation (15000- 3002)Expense Budget 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended Budget 2021 YTD Actuals 2022 Notes/Comments Proposed Expenditures: Personnel Costs: 6000 Salaries 4,928 9,548 7,295 6,136 6,294 7,035 4,885 8,773 6001Overtime 972 2,610 1,924 6,240 13,190 967 1,541 3,266 6002 Standby Time 0 0 0 0 0 0 0 0 6100 Medicare 117 234 142 190 341 102 99 240 6102 Workers' Compensation 681 1,154 1,001 1,089 1,222 813 338 527 6200 Leave Time 0 0 0 0 0 0 0 0 6201 Retirement Benefits 1,268 2,186 1,497 1,957 3,474 884 1,190 2,165 6202 Health Insurance 1,252 2,241 2,018 2,072 4,314 1,260 1,273 2,413 6203 In Lieu of FICA 0 0 0 0 0 0 0 0 6204 Electric Meal Allowance 66 0 40 120 0 0 69 100 6205 Electric Union Benefits 20 55 16 42 22 0 19 50 Total Personnel Costs: $9,305 $18,028 $13,933 $17,846 $28,857 $11,061 $9,414 $17,534 Non -Personnel Costs: 7002 Postage and Freight 248 601 15 0 79 500 0 175 7009 Contracted Services 0 2,481 2,366 2,585 0 0 0 0 7010 Engineering 0 174 0 0 0 0 0 0 7015 Utilities 13,139 15,302 14,490 14,145 14,550 17,408 9,834 18,000 7016 Heating Fuel 83 0 0 0 0 0 0 0 7103 Fuel for Generators 24,731 17,037 24,164 11,874 34,618 51,200 0 130,000 moved from substation 7211 Gas & Lube 5,418 0 5,293 0 0 7,680 0 7,680 7213 Safety Equipment 0 9,573 0 0 0 0 0 0 7215 Operating Supplies 16,585 23,115 438 8,976 4,822 5,120 370 0 7216 Maintenance & Repair 1,484 1,920 1,504 58,263 0 30,720 0 10,550 7217 Small Tools & Equipment 109 0 0 0 0 0 0 0 7301 Subscriptions & Dues 0 5 0 0 0 0 0 0 7302 Travel & Subsistence 0 0 0 90 0 0 0 0 7303 Education & Training 0 0 0 0 0 5,120 0 0 7810 Miscellaneous Expense 0 0 0 0 0 15,360 0 0 8103 Capital Equipment 0 0 0 0 214,833 53,478 40,307 0 Total Non -Personnel Costs: $61,798 $70,209 $48,269 $95,932 $268,903 $186,586 $50,511 $166,405 Total Expenditures: $71,103 $88,236 $62,202 $113,778 $297,760 $197,647 $59,925 $183,939 Electric - Substation Operations Expenditures (15000-3003) Electric Substation Operations (15000- 3003)Expense Budget 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended Budget 2021 YTD Actuals 2022 Proposed Notes/Comments Expenditures: Personnel Costs: 6000 Salaries 79,117 64,759 70,189 66,896 52,493 72,896 53,866 78,584 6001 Overtime 5,791 3,955 4,475 6,605 5,546 2,073 2,201 5,000 6002 Standby Time 0 0 0 0 0 0 0 0 6100 Medicare 1,328 1,090 1,161 1,149 925 825 884 1,212 6102 Workers' Compensation 9,798 7,510 8,986 7,853 4,246 10,196 2,862 3,661 6200 Leave Time 0 0 0 0 0 0 0 0 6201 Retirement Benefits 15,561 13,346 13,183 13,460 11,259 10,697 10,614 15,613 6202 Health Insurance 19,674 15,822 18,182 18,430 11,442 18,054 13,266 19,731 6203 In Lieu of FICA 0 0 0 0 0 0 0 0 6204 Electric Meal Allowance 0 0 0 0 0 0 0 0 6205 Electric Union Benefits 266 219 215 207 177 0 151 225 Total Personnel Costs: $131,534 $106,701 $116,392 $114,600 $86,087 $114,741 $83,844 $124,026 Non -Personnel Costs: 7001 Communications 3,854 3,828 3,713 3,842 5,517 4,096 3,380 4,325 7002 Postage and Freight 2,430 2,363 269 0 0 2,500 338 950 7009 Contracted Services 425 9,472 21,570 5,546 13,407 15,360 0 10,000 7010 Engineering 9,204 8,584 3,365 1,909 0 5,000 13,785 12,000 7015 Utilities 106,474 140,196 125,373 144,163 151,714 120,000 104,794 162,000 7016 Heating Fuel 10,698 7,634 3,566 -49 1,125 6,144 963 7,650 7103 Fuel for Generators 0 0 0 5,893 45,512 51,200 7,212 0 moved to general operations 7211 Gas & Lube 7,486 66 0 0 0 0 116 0 7213 Safety Equipment 1,519 0 697 0 0 0 0 0 7215 Operating Supplies 13,873 8,966 26,889 16,389 32 10,240 2,985 9,000 7216 Maintenance & Repair 17,569 6,386 5,114 6,434 424 5,120 0 5,000 7217 Small Tools & Equipment 2,268 340 0 182 0 0 0 0 7301 Subscriptions & Dues 0 26 0 0 0 0 0 0 7302 Travel & Subsistence 0 0 125 0 0 0 0 0 7304 Equipment Rent 0 0 0 0 0 3,072 0 0 7810 Miscellaneous Expense 0 0 0 251 0 0 0 100 7900 Depreciation Expense 2,096 7,343 7,343 8,309 0 8,309 0 10,494 8103 Capital Equipment 0 0 21,895 0 10,924 284,656 72,276 0 Total Non -Personnel Costs: $177,895 $195,203 $219,919 $192,870 $228,655 $515,697 $205,847 $221,519 Total Expenditures: $309,429 $301,904 $336,310 $307,469 $314,742 $630,438 $289,692 $345,545 Electric - Transmission Operations & Maintenance Expenditures (15000-3004) Electric Transmission OP & Maint. (15000-3004)Expense Budget 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended Budget 2021 YTD Actuals 2022 Proposed Notes/Comments Expenditures: Personnel Costs: 6000 Salaries 12,723 25,310 7,665 23,096 6,529 14,244 5,500 21,261 6001 Overtime 30,363 23,032 11,240 24,236 198 9,676 1,434 15,175 6100 Medicare 830 1,474 291 707 108 444 116 890 6102 Workers' Compensation 4,080 4,345 1,786 4,172 453 3,437 406 1,596 6200 Leave Time 0 0 0 0 0 0 0 0 6201 Retirement Benefits 7,066 9,269 2,616 6,994 1,238 3,931 1,226 6,876 6202 Health Insurance 5,033 4,878 2,496 6,913 1,770 3,461 2,526 3,288 6203 In Lieu of FICA 0 0 0 0 0 0 0 0 6204 Electric Meal Allowance 103 198 0 0 0 0 0 0 6205 Electric Union Benefits 116 279 46 89 11 0 19 50 Total Personnel Costs: $60,315 $68,786 $26,140 $66,206 $10,307 $35,193 $11,227 $49,136 Non -Personnel Costs: 7009 Contracted Services 19,536 800 0 1,919 7,900 503,600 244,842 500,000 7010 Engineering 2,438 22,679 36,680 15,121 1,146 0 0 0 7017 Rents & Leases 21,605 14,623 21,752 29,297 24,186 20,480 16,467 24,700 7101 Chugach Power Purchases 0 0 0 220,045 0 0 0 0 7102 Power Fuel Costs 0 0 0 301,971 0 0 0 0 7211 Gas & Lube 0 275 0 0 0 0 0 0 7215 Operating Supplies 165 5,878 0 7,295 0 2,048 0 0 7216 Maintenance & Repair 0 3,084 2,583 6,704 0 5,120 0 2,000 7217 Small Tools & Equipment 649 183 0 0 0 0 0 0 7301 Subscriptions & Dues 0 19 0 0 0 0 0 0 7304 Equipment Rent 0 29,613 0 0 0 20,000 0 0 8101 Infrastructure 0 -2,613 0 0 0 0 0 0 Total Non -Personnel Costs: $44,392 $74,540 $61,015 $582,850 $33,231 $551,248 $261,309 $526,700 Total Expenditures: $104,707 $143,325 $87,155 $649,056 $43,538 $586,441 $272,535 $575,836 Electric - Distribution Operating & Maintenance Expenditures (15000-3005) Electric Distribution OP & Maint. (15000-3005)Expense Budget 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended Budget 2021 YTD Actuals 2022 Proposed Notes/Comments Expenditures: Personnel Costs: 6000 Salaries 6,791 11,385 9,440 9,389 10,355 9,106 3,029 12,335 6001 Overtime 28,772 34,138 27,888 24,623 70,223 17,193 31,948 38,250 6002 Standby Time 0 185 0 140 411 0 0 0 6100 Medicare 639 942 585 541 1,291 609 596 832 6102 Workers' Compensation 3,636 4,177 3,473 2,851 4,303 4,113 1,794 2,216 6200 Leave Time 0 0 0 0 0 0 0 0 6201 Retirement Benefits 6,261 7,913 4,522 5,303 11,947 3,810 6,314 10,293 6202 Health Insurance 3,926 5,311 4,991 4,715 11,165 3,735 6,254 9,861 6203 In Lieu of FICA 0 0 0 0 0 0 0 0 6204 Electric Meal Allowance 1,973 1,370 569 1,562 2,567 0 1,368 2,030 6205 Electric Union Benefits 61 127 112 84 100 0 53 100 Total Personnel Costs: $52,058 $65,548 $51,580 $49,210 $112,362 $38,566 $51,355 $75,917 Non -Personnel Costs: 7009 Contracted Services 0 0 18,352 0 0 0 0 0 7211 Gas & Lube 0 0 0 0 234 0 0 0 7215 Operating Supplies 2,130 1,277 2,147 170,947 72,423 1,024 36,818 33,825 7216 Maintenance & Repair 1,240 0 0 0 0 0 0 0 7301 Subscriptions & Dues 0 18 100 0 0 0 0 0 7304 Equipment Rent 0 0 0 0 0 4,096 0 0 8101 Infrastructure 0 2,613 0 0 0 0 0 0 Total Non -Personnel Costs: $3,370 $3,908 $20,599 $170,947 $72,657 $5,120 $36,818 $33,825 Total Expenditures: $55,428 $69,456 $72,179 $220,156 $185,019 $43,686 $88,173 $109,742 Electric Wholesale Power Costs (15000-3006)Expense Budget Expenditures: Non -Personnel Costs: 7101 Chugach Power Purchases 7102 Power Fuel Costs Total Non -Personnel Costs: Total Expenditures: Electric - Wholesale Power Costs Expenditures (15000-3006) 2021 2016 2017 2018 2019 2020 Amended 2021 YTD 2022 Actual Actual Actual Actual Actual Budget Actuals Proposed Notes/Comments 2,165,628 2,163,292 1,890,465 2,087,299 2,286,776 2,300,400 2,057,790 2,322,950 2,807,634 3,722,365 3,334,521 3,221,656 3,430,244 2,982,359 1,338,955 3,600,000 $4,973,262 $5,885,657 $5,224,986 $5,308,955 $5,717,020 $5,282,759 $3,396,745 $5,922,950 $4,973,262 $5,885,657 $5,224,986 $5,308,955 $5,717,020 $5,282,759 $3,396,745 $5,922,950 Electric - Work Orders Expenditures (15000-3007) Electric Work Orders (15000-3007) Expense Budget 2016 Actual 2017 Actual 2018 Actual 2019 Actual 2020 Actual 2021 Amended Budget 2021 YTD Actuals 2022 Notes/Comments Proposed Revenues: Operating Revenue 5802 Equipment Rental 0 0 0 0 4,133 0 4,190 1,400 5804 Work Order Revenue 0 0 0 0 0 0 283 100 Total Operating Revenue: $0 $0 $0 $0 $4,133 $0 $4,473 $1,500 Total Revenues: 0 0 0 0 $4,133 0 $4,473 $1,500 Expenditures: Personnel Costs: 6000 Salaries 51,015 93,492 101,156 74,533 64,234 72,844 45,668 119,041 6001Overtime -7,968 98,283 29,167 13,964 3,852 11,969 3,131 23,650 6100 Medicare 2,608 4,592 2,048 1,364 1,087 2,617 733 3,023 6102 Workers' Compensation 11,441 16,103 9,174 5,747 3,975 15,315 1,415 6,250 6201 Retirement Benefits 22,834 32,821 17,619 13,568 13,294 18,485 9,272 46,288 6202 Health Insurance 26,059 29,157 34,175 21,673 14,563 31,852 11,284 32,390 6204 Electric Meal Allowance 946 92 480 439 0 0 0 350 6205 Electric Union Benefits 271 719 224 152 163 0 132 300 Total Personnel Costs: $107,205 $275,259 $194,042 $131,440 $101,168 $153,082 $71,635 $231,292 Non -Personnel Costs: 7009 Contracted Services 0 0 14,852 0 175 0 0 0 7010 Engineering 0 0 0 38,370 11,425 0 4,833 0 7012 Other Special Services -122 2,571 1,200 0 90 0 0 0 7211 Gas & Lube 0 3,870 0 0 0 0 0 0 7215 Operating Supplies -17,585 19,239 6,803 0 1,134 51,200 1,838 10,000 7301 Subscriptions & Dues 0 81 0 0 0 0 60 0 7810 Miscellaneous Expense 300 200 0 0 0 0 0 0 8200 Work Order Sal/Benefit credits -121,632 -200,428 -47,340 -56,144 -1,398 -70,000 -19,164 -73,825 8201 Work Order New Service/Upgrade cred -82,479 -62,987 -36,960 -54,784 -2,705 -40,000 -9,668 -41,200 8202 Work Order Operating Supply credits 0 0 0 0 0 0 10,648 0 Total Non -Personnel Costs: -$221,518 -$237,454 -$61,446 -$72,557 $8,721 -$58,800 -$11,453 -$105,025 Total Expenditures: -$114,313 $37,804 $132,597 $58,883 $109,889 $94,282 $60,182 $126,267 General Ops (15000-3000) 6000 Salaries 6001 Overtime 6002 Standby Time 6100 Medicare 6101 Unemployment Insurance 6102 Workers' Compensation 6200 Leave Time 6201 Retirement Benefits 6202 Health Insurance 6204 Electric Meal Allowance 6205 Electric Union Benefits 6209 Contra -Retirement PERS DC Forfeitures Total Personnel Costs: Meter Service 6000 Salaries 6001 Overtime 6002 Standby Time 6100 Medicare 6101 Unemployment Insurance 6102 Workers' Compensation 6200 Leave Time 6201 Retirement Benefits 6202 Health Insurance 6203 In Lieu of FICA 6204 Electric Meal Allowance 6205 Electric Union Benefits Total Personnel Costs: Electric (General Operations & Meter Service) Personnel Comparison Information 2016 2017 2018 2019 2020 2021 Amended Actual Actual Actual Actual Actual Budget 2022 Proposed 381,709 411,769 444,032 469,146 488,066 439,981 490,750 34,890 84,490 71,274 52,312 12,621 20,330 49,600 2022 Proposed Budget 93,285 93,999 95,317 110,618 131,267 100,626 155,000 includes Meter Service 8,737 11,270 10,445 10,903 10,093 7,240 16,871 personnel line items. 5,550 7,968 698 0 -31 0 0 33,860 76,082 52,348 51,128 40,435 47,548 35,826 49,079 52,309 55,380 60,107 76,889 74,649 0 448,111 -15,709 102,056 131,428 107,564 104,210 165,053 104,689 114,425 121,442 138,657 125,664 107,310 180,048 7,085 12,596 5,264 5,694 7,809 7,373 6,898 9,094 17,056 1,256 1,872 12,318 21,504 13,523 0 0 0 -2,516 0 0 0 $1,176,089 $866,255 $959,512 $1,029,349 $1,012,695 $930f771 $1,113,569 2016 2017 2018 2019 2020 2021 Amended Actual Actual Actual Actual Actual Budget 2022 Proposed 19,941 30,909 38,427 32,683 7,614 26,411 0 2,836 2,580 6,967 3,292 1,255 1,560 0 2022 Proposed Budget 0 303 0 0 0 0 0 moves Meter Service to 415 609 1,535 1,647 139 277 0 Streets personnel line 0 0 0 0 0 0 0 items. 2,402 2,985 3,162 1,805 574 2,248 0 0 0 0 0 0 0 0 4,252 5,434 4,200 2,876 1,564 2,614 0 4,286 6,012 5,944 3,583 2,011 3,321 0 0 0 0 0 0 0 0 0 0 133 0 0 0 0 64 106 64 46 19 0 0 $34,196 $48,938 $60f432 $45,932 $13,176 $36,431 $0 2016 2017 2018 2019 2020 2021 Amended Actual Actual Actual Actual Actual Budget 2022 Proposed Total Personnel Costs: $1,210,285 $915,193 $1,019,944 $1,075,281 $1,025,871 $967,202 $1,113,569 General - Motor Pool Revenue & Expenditures (03000-0000) 2021 General - Motor Pool (03000.0000) 2016 2017 2018 2019 2020 Amended 2021 YTD 2021 2022 Revenue & Expense Budget Actual Actual Actual Actual Actual Budget Actuals Projections Proposed Notes/Comments Revenues: Operating Revenue: 4362 Insurance Recovery 2598 0 0 0 0 0 0 0 0 5899 Micellaneous Revenue 0 0 0 0 46890 0 0 0 0 Total Operating Revenue: $2,598 $0 $0 $0 $46,890 $0 $0 $0 $0 Non -Operating Revenue: 5901 EF Investment Interest 1,470 17,199 22,887 67,720 66,928 15,000 2,492 3,738 7,075 5904 EF Misc. Interest Revenue 39,481 36,379 33,113 29,677 26,059 26,059 0 0 27,875 Projection based on history 5910 Gain on Sale of FA 9,000 638 6,954 34,478 0 0 0 0 0 5950 Motor Pool Vehicle Rent 291,600 175,000 357,000 357,000 732,000 635,990 476,992 715,488 387,080 Motor pool rent expense from enterprise funds 5990 Surplus Sales 0 0 0 0 6,515 0 440 660 29,000 Total Operating Revenue: $341,551 $229,216 $419,954 $488,875 $831,502 $677,049 $479,924 $719,886 $451,030 Total Revenues: $344,149 $229,216 $419,954 $488,875 $831,502 $677,049 $479,924 $719,886 $451,030 Expenditures: Non -Personnel Costs: 7009 Contracted Services 1,430 0 0 0 0 0 0 0 0 7215 Operating Supplies 6,055 0 0 76 0 0 0 0 0 7216 Maintenance & Repair 0 0 4,700 0 0 0 0 0 0 7217 Small Tools & Equipment 1,032 935 4,155 0 0 0 0 0 0 7303 Education & Training 0 9,574 0 0 0 0 0 0 0 7900 Depreciation Expense 450,049 425,878 392,366 398,971 405,767 420,000 0 0 349,745 Projection reports from foxed asset system 8000 Loss on Sale of Foxed Assets 0 6,534 0 0 0 0 0 0 0 8103 Capital Equipment 0 0 411,052 0 10,675 455,000 118,514 177,771 1,194,675 Total Non -Personnel Costs: $458,566 $442,921 $812,273 $399,047 $416,442 $875,000 $118,514 $177,771 $1,544,420 Total Expenditures: $458,566 $442,921 $812,273 $399,047 $416,442 $875,000 $118,514 $177,771 $1,544,420 'Dept head estimates of salvage value - sale of two Fire command trucks, four Police patrol vehicles, and one PW loader Purchases Include Electric 60,000 Truck replacement 60,000 Truck replacement 288,671 Excavator (Already approved by Council but will need to be re -appropriated in 2022 budget for payment) 35,000 Trailer (these two trailers will need a transfer of cash from Electric for initial Motor Pool purchase since they are new items 38,000 Trailer not currently in the Motor Pool) Fire $ 62,000 Command truck replacement $ 62,000 Command truck replacement Police Authorized in 2021 - reappropriated for 2022 $ 58,500 Patrol car replacement $ 58,500 Patrol car replacement $ 58,500 Patrol car replacement $ 58,500 Patrol car replacement Public Works $ 100,000 (used) replace steamer truck $ 255,000 Loader replacement $ 1,194,671 City of Seward Capital Improvement Plan Enterprise Funds 2022 - 2027 New or Forecasted Funding Source Deoartment Proiect Description ReDlace 2022 2023 2024 2025 2026 2027 Proiect Cost Citv Portion Other Source Source Harbor NE Launch Ramp Replace X $ 2,500,000 $ 625,000 $ 1,875,000 City/Fed/State Harbor K, L & G float replacement Replace X $ 3,600,000 $ 1,800,000 $ 1,800,000 City/State/Facility Grant Harbor Replace Anodes on concrete floats Replace X $ 220,000 $ 220,005 $ - City Harbor 50 Ton wash down Pad New X $ 500,000 $ - $ 500,000 Fed infrastructure grant Harbor Electric on X-Float New X X $ 800,000 $ 400,000 $ 400,000 City/State Harbor 5 ton crane on I -dock New X $ 500,000 $ - $ 500,000 Fed infrastructure grant Harbor Float Extension Z-Float New X X $ 5,000,000 $ 2,500,000 $ 2,500,000 City/State/Facility Grant SMIC Additional Water Service New X $ 20,000 $ 20,000 $ - City SMIC Improve Drainage New I X $ 1,000,000 $ 1,000,000 $ - City SMIC Fence Storage area New X $ 500,000 $ 1,000,000 $ - City SMIC Additional power stalls New X $ 500,000 $ 500,000 $ - City SMIC Pave City owned SMIC Roads New X $ 1,500,000 $ 1,500,000 $ - City SMIC Finish North Dock Paving New X $ 1,000,000 $ 1,000,000 $ - City Water Double wall fuel tank water Replace X X $ 25,000 $ 25,000 $ - $25K each Water Design-Hypochorite Generator -SMIC New X $ 37,500 $ 37,500 $ 37,500 Rural Water loan Water Construction-Hypochorite Gener. -SMIC New X $ 200,000 $ 200,000 $ 200,000 Rural Water loan Water Water Meter Program - with auto -readers New X X $ 250,000 $ 250,000 $ - Infrastructure Water Liftstation #1 mobile standby generator New X $ 150,000 $ 150,000 $ - Water Distribution Piping upgrades ductile iron pipe) Replace X $ 3,000,000 $ - $ 3,000,000 Infr. Grant Water Lowell Canyon 200K gallon Tank with 500K gallon tank Replace X X $ 1,000,000 $ - $ 1,000,000 Infr. Grant Water Gateway Tank Roof New X $ 150,000 $ 150,000 $ 150,000 Rural Water loan Water Replace water lines - Elm Street Replace X $ 200,000 $ - $ 200,000 Infr. Grant Water Well abandonment - Fort Raymond Property New X $ 45,000 $ 45,000 $ 45,000 Water Refurbish #4 production well Replace X $ 50,000 $ 50,000 $ - Water Rep ace 10 and 14 AC water line btwn Phoenix and Sea Lion Replace X $ 250,000 $ 250,000 $ 250,000 Loan, grant, ? Wastewater Manhole refurbishment Replace X $ 120,000 $ 120,000 $ - Wastewater SMIC lower lift station (engineering only) New X 1 $ 75,000 $ 75,000 $ - Wastewater Two double wall fuel tanks. 25k in 2023-2025 Replace X X $ 25,000 $ 25,000 $ - $25K each Wastewater SMIC lower lift station construction New $ 225,000 $ 225,000 $ - Wastewater SMIC DiDing for bypass design & constr New X X $ 150,000 $ 150,000 $ - Wastewater Wastewater Lagoon sludge removal Replace X $ 2,000,000 $ 2,000,000 $ - Infr. Grant Wastewater Water Meter Program - with auto -readers New x X $ 250,000 $ 250,000 $ - Infrastructure Wastewater Mobile Standby Generator New X $ 150,000 $ 150,000 $ - Wastewater Replace infrastructure past useful life Replace X $ 330,000 $ 330,000 $ - Electric Nash Road Project Replace X $ 3,410,955 $ 3,410,955 $ - Revenue Bond Electric Seward Highway Transmission Upgrade Replace X $ 426,184 $ 426,184 $ - Revenue Bond Electric Substation Voltage Conversions Replace X $ 5,581,873 $ 5,581,873 $ - Revenue Bond Electric Spring Creek Substation Refurbishment Replace X $ 3,498,655 $ 3,498,655 $ - Revenue Bond Electric New Harbor Substation New X $ 2,104,077 $ 2,104,077 $ - Revenue Bond Electric New Transformers (7) Replace X $ 4,360,000 $ 4,360,000 $ - Revenue Bond Electric Stoney Creek Cable Replace X $ 200,000 $ 200,000 $ - Electric Old Mill #3 - Cable Replace X $ 200,000 $ 200,000 $ - Electric Quests Woods -Cable Replace X $ 100,000 $ 100,000 $ - New or Forecasted Department Proiect Description ReDlace 2022 2023 2024 2025 2026 2027 Project Cost Source Citv Portion Other Source Source Electric Gateway Upper & Lower - Cable Replace X $ 190,000 $ 190,000 $ - Electric Securi Cameras - Fort Raymond R lace X $ 185,000 $ 185,000 $ - Electric Radiator Hoods - Fort Raymond Plant R lace X $ 200,000 $ 200,000 $ - Parking Replace Panting Kiosks Replace X $ 100,000 $ 100,000 IParking Reserves Yearly Total:1 $ 11,/29,639 1 $ 22,bb9,bUS 1 $ 3,31U,000 1 $ 3,S6S,000 1 $ b,SUU,000 1 $ b,33U,000 1 Total Project Cost: $ 46,879,244 Total City Portion: $ 35,604,244 Total Other Portion: $ 12,457,500 New or Department Project Description Replace 2022 2023 City of Seward Capital Improvement Plan General Fund 2022 - 2027 2024 2025 2026 Forecasted Project Funding Source 2027 Cost Citv Portion Other Source Source Public Works Sidewalk and ADA ramp repairs Replace X $ 75,000 $ 75,000 $ - GF "yearly" Public Works ADA Compliant Public Entr Modification Replace X X X $ 300,000 $ 300,000 $ - $100,000 per year Public Works City Hall Parking Lot and Retaining Wall Replace X $ 55,000 $ 55,000 $ - Public Works Pub. Works Bldg Design & Engineering New X $ 125,000 $ 125,000 $ - Public Works Public Works Building Construction Replace X $ 8,000,000 $ 8,000,000 $ - Library Library Emergency Exit Doors New X $ 15,000 $ 15,000 $ - Public Works Lowell Creek Rood Control Diversion Tunnel New X $ 185,000,000 $ - $ 185,000,000 Public Works Lowell Point Road FLAP Grant safety study Replace I X $ 80,00 $ 80,000 $ 2,750,000 Library Library Cameras New X $ 25,000 $ 25,000 $ - IT IT Dept- City Phone System Replace X $ 250,000 $ 250,000 $ - Fire Feasibility & Design Engineer Fire Station Replace X $ 250,000 $ 250,000 $ - Fire & Police Public Safety Radios Replace X $ 280,000 $ 280,000 $ - Police Feasibility & Design Engineer Police Department New X $ 250,000 $ 250,000 $ - Police Public Safety or Police Building New X $ 15,000,000 $ 15,000,000 $ - Campground Additional Campground Utility Sites New X $ 400,000 $ 400,000 $ - GF Reserves Cam round Resurface Campgrounds Replace X $ 200,000 $ 200,000 $ - Parks & Rec Resurface Playgrounds Replace X $ 300,000 $ 300,000 $ - Parks & Rec Replace N. Ballaine Playground Equipment Replace X $ 300,000 $ 300,000 $ - Parks & Rec Construct Wellington Pavilion New X $ 400,000 $ 400,000 $ - Parks & Rec Evaluate/Rebuild Lagoon Boardwalk Replace X $ 240,000 $ 240,000 $ - Parks & Rec TYC Facility Renovation Replace X $ 75,000 $ 75,000 $ - Yearly Total: 1 $ 680,000 1 $ 9,970,000 1 $ 15,470,000 1 $ 500,000 1 $ 185,000,000 1 $ - Total Project Cost: $ 211,620,000 Total City Portion: $ 26,620,000 Total Other Source: $ 187,750,000