Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Res2015-096
Sponsored by: Hunt Public Hearing: October 26, 2015 Additional Public Hearing: November 9, 2015 Adoption: November 9, 2015 CITY OF SEWARD,ALASKA RESOLUTION 2015-096 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF SEWARD, ALASKA, ADOPTING THE ELECTRIC ENTERPRISE FUND BIENNIAL BUDGET FOR CALENDAR YEARS 2016 AND 2017 WHEREAS, the city manager has submitted to the City Council a proposed biennial budget for the City of Seward for Calendar Years 2016 and 2017; and WHEREAS, the preliminary biennial budget was reviewed by the City Council in budget work sessions on October 7, 8, 9 and 16, 2015,which were televised to the public; and WHEREAS, a public hearing is scheduled on the proposed budget for October 26 with public hearing and final adoption scheduled for November 9, 2015; and WHEREAS, the 2016 budget includes a 2.3% increase in electric tariff rates to all rate classes with the exception of Small General Service which shall not be increased, plus the implementation of a new seasonal rate schedule and amendments to the two electric special contracts, and WHEREAS, the 2017 budget includes a 2.4% increase in electric tariff rates to all rate classes with the exception of Small General Service which shall not be increased in order to comport with the recent rate classification study, and amendments to the two electric special contracts. NOW THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SEWARD, ALASKA, that: Section 1. The Electric Enterprise Fund budget for Calendar Years 2016 and 2017 which is attached hereto and made a part hereof by reference and which contains estimated revenues and expenses for the period January 1, 2016 - December 31, 2017, is HEREBY ADOPTED, and the necessary funds are hereby appropriated. Section 2. This resolution shall take effect immediately upon adoption. PASSED AND APPROVED by the City Council of the City of Seward, Alaska, this 9th day of November, 2015. CITY OF SEWARD, ALASKA RESOLUTION 2015-096 THE CITY OF SEWARD, ALASKA a/v.) '-f/at22 can Bardarson, Mayor AYES: Keil, Casagranda, Squires, Butts, Altermatt, McClure, Bardarson NOES: None ABSENT: None ABSTAIN: None ATTEST: I, Jo ann. ey, CM Ci' Clerk (City Seal) �•G ••°GO , 'i<%*.O SEAL • •,�F OF ........A ,,.•. ELECTRIC ENTERPRISE FUND Budgeted Statement of Revenues and Expenses And Change in Net Position For Fiscal Years 2016 and 20I7 20I4 2015 20I6 2017 Actual* Budget Budget Budget Operating revenue: Sales: Residential 3233,812 3,329,561 3,406,I41 3,466,449 Small General Service 1,800,254 1,893,594 1,910,000 1,9I0,000 Large General Service 4,575,343 4,832,455 4,70I,349 4,812,600 Harbor Power Sales 300,446 310,958 312,995 320,503 Industrial Sales/Special Contracts I,028,669 93I,573 1,152,089 1,258,587 Street&Yard Lights 74,222 70,000 7I,6I0 73,000 Miscellaneous 84299 73,000 74,679 69,700 Total operating revenue: $11,097,045 $I1,441,141 $11,628,863 $11,910,839 Operating expense: Before depreciation: Salaries 1,000,651 1,060,049 1,104,471 1,135,271 Work order charges(salaries) (208,130) (297,763) (100,000) (100,000) Employee benefits 599,151 587,696 647,055 676,471 Purchased services 757,789 553,422 733,000 718,000 Power for resale 4,9I6,494 4,991,000 5,I00,000 5,100,000 Supplies&maintenance 363,720 503,000 437,500 415,500 Work order charges(supplies) -117,4I6 -50,000 -50,000 -50,000 General&Administrative 1,106,417 I,112,458 I,111,535 1,120,860 Total operating expense: $8,418,676 $8,459,862 $8,983,561 $9,016,102 Operating income before depreciation 2,678,369 2,981,279 2,645,302 2,894,737 Depreciation 1,758,135 1,777,308 1,777,228 1,777,228 Earnings from operations $920,234 $1203,971 $868,074 $1,117,509 Non-operating revenue(expense) Interest income 278,300 72,000 89,000 90,000 Interest expense (286,592) (281,686) (262,486) (257,1I9) Other revenue(expense) 519,984 1,000 1,139 I,139 Total non-operating revenues(expenses) $11,692 (208,686) (172,347) (I65,980) Earnings before contributions and transfers $1,431,926 $995285 $695,727 $95I,529 Capital contributions and special items 1,055,462 0 0 0 Transfers(to)/from other funds (1,119,3I3) (1255,610) (1,262,228) (1,276,519) Change in net position 1,368,075 (260,325) (566,501) (324,990) Beginning net position $22,978,621 $24,346,696 $24,086,371 $23,519,870 Ending net position $24,346,696 * $24,086,371 $23,5I9,870 $23,I94,880 'lies to annual Comprehensive Annual Financial Kepo: CITY OF SEWARD ELECTRIC EN IERPRISE FUND Budgeted Statement of Cash Flow For Fiscal Year 2016 and 2017 2015 2016 20I7 Budget Budget Budget Beginning Cash Balance at I/I/I5(*): $3,I29,380 Cash is provided by(used for): Change in net position (260,325) (566,501) (324,990) Add expense items not affecting cash Depreciation 1,777,308 1,777,228 1,777228 Net cash provided by operations $I,5I6,983 $I,210,727 $I,452,238 Other sources(uses)of cash Loan repayment from General Fund 110,784 0 (a) 0 (a) Debt principal payments (400,000) (130,000) (b) (I35,000) (c) Capital outlay (1,349,422) (891,600) (d) (785,000) (e) Net increase(decrease)in cash -$121,655 $189,127 $532238 Estimated ending cash balance $3,007,725 $3,196,852 $3,729,090 (a)From General Fund to recover payments made to subsidize SMIC enterprise fund. Council imposed 2-year moratorium. (b)$I30K represents Electric generator bond (c)$135K represents Electric generator bond (d)$891,600 represents Infrastructure$440K;Motor pool$291,600; Work orders$I50,000;Equipment$ represents Infrastructure$440K;Motor pool$I75,000;Work orders$150,000;Equipment$20K. City of Seward e 10/13/2015 at 12:36 PM Electric Enterprise Fund Page: 1 Revenue Detail by Line Item For 9/30/2015 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Revenues Residential 1,848,857 1,958,151 2,003,188 2.30 2,043,252 2.00 Residential fuel factor 923,942 873,245 893,330 2.30 911,197 2.00 Residential customer charge 461,013 498,165 509,623 2.30 512,000 0A7 SG Service 1,112,570 1,191,005 1,200,000 0.76 1,200,000 0.00 SG fuel factor 486,393 460,223 470,000 2.12 470,000 0.00 SG Customer Charge 201,291 242,366 240,000 (0.98) 240,000 0.00 LG Service 1,810,905 2,030,049 1,972,903 (2.82) 2,020,000 2.39 LGfuelfactor 1,332,135 1,262,780 1,227,233 (2.81) 1,257,000 2.43 LG customer charge 41,356 45,851 44,560 (2.82) 45,600 2.33 LGdemandcharge 1,391,821 1,497,426 1,455,273 (2.82) 1,490,000 2.39 Electric KVAR rate 0 5,000 5,115 2.30 0 (100.00) Alternate Energy (874) (3,651) (3,735) 2.30 0 (100.00) Spec.Contract Energy 117,751 108,339 131,881 21.73 144,080 925 Special Contract fuel factor 523,408 496,173 586,220 18.15 640,445 9.25 Spec.Contract customer charge 939 966 988 2.28 1,012 2.43 Special Contract Demand 386,570 326,095 433,000 32.78 473,050 9.25 Harbor Fund Power Sales 212,862 216,221 221,194 2.30 226,503 2.40 Harbor power fuel factor 87,583 89,737 91,801 2.30 94,000 2.40 Street&Yard 68,363 70,000 71,610 2.30 73,000 1.94 Yard Light Fuel 5,860 0 0 0.00 6,000 0.00 Turn on Fees 17,270 15,000 15,345 2.30 15,700 2.31 Equipment Rental 16,973 26,000 26,598 2.30 18,000 (32.33) Joint Pole Use 9,984 10,000 10,230 2.30 10,000 (2.25) Work Order Revenue 40,073 20,000 20,460 2.30 20,000 (2.25) Chugach Coop DivId. 0 0 0 0.00 0 0.00 Collection of Doubtful Accounts 4,988 0 0 0.00 0 0.00 Miscellaneous Revenue 0 2,000 2,046 2.30 0 (100.00) EF Investment Interest 51,511 12,000 19,000 58.33 20,000 5.26 EF Penalties and Interest 71,046 60,000 70,000 16.67 70,000 0.00 PERS On-Behalf paid by SOA 174,276 0 0 0.00 0 0.00 Assessment Interest 530 1,000 0 (100.00) 0 0.00 Amort.ofCIA-General 0 1,030,760 1,030,000 (0.07) 1,030,000 0.00 AmortBond Premium 8,366 8,366 1,139 (86.39) 1,139 0.00 Total Revenues $11,407,762 $12,553,267 $12,749,002 $ (15.99) $13,031,978 $(278.33) City of Seward :un:10/13/2015 at 12:36 PM 15000-Electric Enterprise Fund Page: 1 Expense Summary by Line Item For 9/30/2015 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Expenditures!Expenses 15000 6000 Salaries 750,995 906,402 947,592 4.54 973,762 2.76 15000 6001 Overtime 35,354 64,838 67,152 3.57 69,085 2.88 15000 6002 Standby Time 100,771 89,283 89,727 0.50 92,424 3.01 15000 6100 Medicare 14,321 16,182 17,021 5.19 17,473 2.66 15000 6101 Unemployment Insurance 0 3,000 0 (100.00) 0 0.00 15000 6102 Workers'Compensation 46,126 44,658 53,556 19.92 55,331 3.31 15000 6200 Leave Time 90,338 106,216 104,872 (1.27) 113,499 8.23 15000 6201 Retirement Benefits 315,652 168,429 186,866 10.95 193,722 3.67 150006202 Health Insurance 228,002 221,642 261,490 17.98 273,496 4.59 15000 6204 Meal Allowance 345 12,689 3,150 (75.18) 2,700 (14.29) 15000 6205 Electric Union Benefits 12,499 20,000 20,100 0.50 20,250 0.75 15000 7001 Communications 18,108 20,500 25,000 21.95 25,000 0.00 15000 7002 Postage and Freight 14,583 24,000 32,500 35.42 22,000 (32.31) 15000 7003 Bank and Credit Card Fees 53,066 48,000 55,000 14.58 55,500 0.91 15000 7004 Insurance 58,300 65,000 65,000 0.00 65,000 0.00 15000 7006 Legal 9,246 62,000 50,000 (19.35) 50,000 0.00 15000 7009 Contracted Services 174,003 276,000 321,000 16.30 321,000 0.00 15000 7010 Engineering 0 0 26,000 0.00 26,000 0.00 15000 7011 Testing 751 0 0 0.00 0 0.00 15000 7012 Other Special Services 10,406 15,000 20,000 33.33 15,000 (25.00) 15000 7015 Utilities 79,594 101,000 89,500 (11.39) 89,500 0.00 15000 7016 Heating Fuel 8,722 37,000 26,000 (29.73) 26,000 0.00 15000 7017 Rents&Leases 21,136 17,000 23,000 35.29 23,000 0.00 15000 7101 Chugach Power Purchases 1,908,272 1,775,000 2,000,000 12.68 2,000,000 0.00 15000 7102 Power Fuel Costs 2,948,959 3,066,000 3,000,000 (2.15) 3,000,000 0.00 15000 7103 Fuel for Generators 0 150,000 100,000 (33.33) 100,000 0.00 15000 7210 Vehicle Supplies 1,875 5,000 5,000 0.00 3,000 (40.00) 15000 7211 Gas&Lube 24,509 43,000 50,500 17.44 40,500 (19.80) 15000 7213 Safety Equipment 3,350 5,000 5,000 0.00 5,000 0.00 15000 7214 Janitorial Supplies 0 0 0 0.00 0 0.00 15000 7215 Operating Supplies 57,456 275,000 242,000 (12.00) 237,000 (2.07) 15000 7216 Maintenance&Repair 68,388 125,000 105,000 (16.00) 105,000 0.00 15000 7217 Small Tools&Equipment 5,776 50,000 30,000 (40.00) 25,000 (16.67) 15000 7300 Advertising 579 8,000 11,000 37.50 6,000 (45.45) 15000 7301 Subscriptions&Dues 45,939 10,000 82,000 719.99 82,000 0.00 15000 7302 Travel&Subsistence 14,983 30,000 30,000 0.00 28,000 (6.67) 15000 7303 Education&Training 12,633 45,000 30,000 (33.33) 28,000 (6.67) 15000 7304 Equipment Rent 10,529 23,000 24,000 4,35 27,000 12.50 15000 7307 GF Administrative Fee 864,237 868,558 888,535 2.30 909,860 2.40 15000 7330 P.I.L.T, 889,778 915,291 930,309 1.64 953,000 2.44 15000 7331 Redass PILT to Transfer-Out (869,778) (915,291) (930,309) 1.64 (953,000) 2,44 15000 7805 Promotion 0 0 0 0.00 0 0.00 15000 7808 Bad Debt Expense 39,541 30,000 35,000 16.67 30,000 (14.29) 15000 7810 Miscellaneous Expense 285 13,000 11,000 (15.38) 10,000 (9.09) 15000 7900 Depredation Expense 0 1,777,308 1,777,228 0.00 1,777,228 0.00 15000 8010 Utility Deposit Interest 1,179 1,400 1,200 (14.29) 1,200 0.00 15000 8011 Bonding Expense 0 0 0 0.00 0 0.00 15000 8012 Debt Service Interest Expense 290,053 273,261 261,286 (4.38) 255,919 (2.05) 15000 8014 Amortization of Bond Issue Costs 4,904 8,425 0 (100.00) 0 0.00 15000 8101 Infrastructure 0 776,659 440,000 (43.35) 440,000 0.00 15000 8103 Capital Equipment 4,645 50,000 10,000 (80.00) 20,000 100.00 15000 8104 Motor Pool Rent 262,500 175,000 291,600 66.63 175,000 (39.99) 15000 8105 Improvements other than Buildings (185,363) 0 0 0.00 0 0.00 15000 8200 Work Order Sal/Benefit credits (208,130) (297,763) (100,000) (66.42) (100,000) 0.00 15000 8201 Work Order Operating Supply credits (127,580) (50,000) (50,000) 0.00 (50,000) 0.00 15000 8300 Debt Service Principal 380,000 400,000 130,000 (67.50) 135,000 3.85 Total Expenditures/Expenses $ 8,471,837 $ 11,954,687 $ 11,894,875 $335.81€ 11,820,449 $(117.95) Run:1011312015 at 12:53 PM Expenditure Detail by Department Electric Enterprise Fund Electric-General Operations For 913012015 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 323,028 351,718 362,976 3.20 373,887 3.01 15000 6001 Overtime 2,649 3,999 2,142 (46.44) 2,207 3.03 15000 6002 Standby Time 4,274 0 2,466 0.00 2,540 3.00 15000 6100 Medicare 6,125 5,780 6,096 5.47 6,280 3.02 15000 6101 Unemployment Insurance 0 3,000 0 (100.00) 0 0.00 15000 6102 Workers'Compensation 23,664 21,724 27,899 28.43 28,737 3.00 15000 6200 Leave Time 65,996 73,304 71,634 (2.28) 73,788 3.01 15000 6201 Retirement Benefits 58,624 105,000 111,372 6.07 115,827 4,00 15000 6202 Health Insurance 124,629 134,599 142,310 5.73 149,425 5.00 15000 6204 Electric Meal Allowance 345 2,041 300 (85.30) 1,500 400.00 15000 6205 Electric Union Benefits 12,172 20,000 20,000 _ 0.00 20,000 0,00 Total Personnel Costs: $ 621,506 $ 721,165 $ 747,195 $(185.12) $ 774,191 $ 427.07 Non-Personnel Costs: 15000 7001 Communications 6,187 10,000 10,000 0.00 10,000 0,00 15000 7002 Postage and Freight 13,045 20,000 25,000 25.00 15,000 (40.00) 15000 7003 Bank and Credit Card Fees 53,066 48,000 55,000 14.58 55,500 0.91 150007004 Insurance 58,219 65,000 65,000 0.00 65,000 0.00 15000 7006 Legal 8,262 62,000 35,000 (43.55) 35,000 0,00 15000 7009 Contracted Services 48,764 96,000 70,000 (27.08) 70,000 0,00 150007010 Engineering 0 0 26,000 0.00 26,000 0.00 15000 7011 Testing 751 0 0 0.00 0 0,00 15000 7012 Other Special Services 0 0 5,000 0.00 0 (100.00) 15000 7015 Utilities 4,127 4,000 4,500 12.50 4,500 0.00 15000 7016 Heating Fuel 2,183 6,000 6,000 0.00 6,000 0.00 15000 7017 Rents&Leases 3,000 2,000 3,000 50.00 3,000 0.00 15000 7210 Vehicle Supplies 1,875 5,000 5,000 0.00 3,000 (40.00) 15000 7211 Gas&Lube 21,537 40,000 40,000 0.00 30,000 (25.00) 15000 7213 Safety Equipment 3,312 5,000 5,000 0.00 5,000 0.00 15000 7215 Operating Supplies 36,495 80,000 100,000 25.00 95,000 (5.00) 15000 7216 Maintenance&Repair 65,978 50,000 50,000 0.00 50,000 0.00 15000 7217 Small Tools&Equipment 1,637 20,000 20,000 0.00 15,000 (25.00) 15000 7300 Advertising 208 5,000 10,000 100.00 5,000 (50.00) 15000 7301 Subscriptions&Dues 1,294 2,000 2,000 0.00 2,000 0.00 15000 7302 Travel&Subsistence 224 10,000 10,000 0.00 8,000 (20.00) 15000 7303 Education&Training 306 10,000 10,000 0.00 8,000 (20.00) 15000 7304 Equipment Rent 2,675 5,000 5,000 0.00 5,000 0.00 15000 7307 GF Administrative Fee 864,237 868,558 888,535 2.30 909,860 2.40 15000 7330 P.I,L.T, 889,778 915,291 930,309 1.64 953,000 2.44 15000 7331 Reclass PILT to Transfer-Out (889,778) (915,291) (930,309) 1.64 (953,000) 2.44 15000 7805 Promotion 0 0 0 0.00 0 0.00 15000 7508 Bad Debt Expense 39,541 30,000 35,000 16.67 30,000 (14.29) 15000 7810 Miscellaneous Expense 863 10,000 10,000 0.00 10,000 0.00 15000 7900 Depreciation Expense 0 1,774,028 1,774,028 0.00 1,774,028 0.00 15000 8010 Utility Deposit Interest 1,179 1,400 1,200 (14.29) 1,200 0.00 15000 8011 Bonding Expense 0 0 0 0.00 0 0.00 15000 8101 Infrastructure 0 100,000 20,000 (80.00) 320,000 1,500.00 15000 8103 Capital Equipment 4,645 30,000 0 (100.00) 0 0.00 15000 8104 Motor Pool Rent 82,500 90,000 97,200 8.00 90,000 (7.41) 15000 8105 Improvements other than Buildings (185,353) 0 0 0.00 0 0.00 15000 8201 Work Order Operating Supply credits 249 0 0 0.00 0 0.00 Total Non-Personnel Costs: $ 1,140,996 $ 3,448,986 $ 3,387,463 $ (7.59) $ 3,651,088 $,161.49 Total Expenditures $ 1,762,502 $ 4,170,151 $ 4,134,658 $(192.71) $ 4,425,279 9,588.58 . , Run:10/13/2015 at 12:53 PM Expenditure Detail by Department Electric Enterprise Fund Electric-Administration For 9130(2015 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 189,157 270,819 288,882 6.67 295,059 2.14 15000 6001 Overtime 218 750 750 0.00 750 0.00 15000 6100 Medicare 2,922 4,212 4,634 10.02 4,739 2.27 15000 6102 Workers'Compensation 1,558 5,489 1,780 (67.57) 2,000 12.36 15000 6200 Leave Time 24,343 31,851 33,238 4.35 35,372 6.42 15000 6201 Retirement Benefits 22,287 10,951 16,005 46,15 16,338 2.08 15000 6202 Health Insurance 78,617 87,043 106,624 22.50 _ 110,889 4.00 Total Personnel Costs: $ 319,102 $ 411,115 $ 451,913 $ 22.12 $ 465,147 $ 29,27 Non-Personnel Costs: 15000 7001 Communications 8,489 7,000 10,000 42.86 10,000 0.00 15000 7002 Postage and Freight 1,354 1,000 1,000 0.00 1,000 0.00 15000 7004 Insurance 81 0 0 0.00 0 0.00 15000 7006 Legal 984 0 15,000 0.00 15,000 0.00 15000 7009 Contracted Services 62,185 100,000 30,000 (70.00) 30,000 0.00 150007010 Engineering 0 0 0 0.00 0 0,00 15000 7012 Other Special Services 10,406 15,000 15,000 0.00 15,000 0.00 15000 7015 Utilities 1,928 17,000 0 (100.00) 0 0.00 15000 7016 Heating Fuel 2,498 20,000 0 (100.00) 0 0.00 15000 7210 Vehicle Supplies 0 0 0 0.00 0 0.00 15000 7211 Gas&Lube 2,972 3,000 3,000 0.00 3,000 0.00 15000 7214 Janitorial Supplies 0 0 0 0.00 0 0.00 15000 7215 Operating Supplies 8,439 10,000 10,000 0.00 10,000 0.00 15000 7216 Maintenance&Repair 0 0 0 0.00 0 0.00 15000 7217 Small Tools&Equipment 4,139 20,000 10,000 (50.00) 10,000 0.00 15000 7300 Advertising 0 3,000 1,000 (66.67) 1,000 0.00 15000 7301 Subscriptions&Dues 44,645 8,000 80,000 900.00 80,000 0.00 15000 7302 Travel&Subsistence 14,759 20,000 20,000 0,00 20,000 0.00 15000 7303 Education&Training 8,933 25,000 15,000 (40.00) 15,000 0.00 15000 7304 Equipment Rent 3,169 0 0 0.00 3,000 0.00 15000 7808 Bad Debt Expense 0 0 0 0.00 0 0.00 15000 7810 Miscellaneous Expense 22 0 0 0.00 0 0.00 15000 7900 Depreciation Expense 0 3,280 3,200 (2.44) 3,200 0.00 15000 8103 Capital Equipment 0 20,000 10,000 (50.00) 10,000 0.00 15000 8104 Motor Pool Rent - 180,000 85,000 194,400 128.71 85,000 (56.28) Total Non-Personnel Costs: $ 355,003 $ 357,280 $ 417,600 $592.46 $ 311,200 $ (56.28) Total Expenditures $ 674,105 $ 768,395 $ 869,513 $ 614.58 $ 776,347 $ (27.01) Run:1 011 3120 1 5 at 12:53 PM Expenditure Detail by Department Electric Enterprise Fund Electric•Standby Generation For 913012015 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 10,945 1,100 4,536 312.35 4,672 3.00 15000 6001 Overtime 127 4,656 3,343 (28.20) 3,444 3.02 15000 6002 Standby Time 0 0 0 0.00 0 0.00 15000 6100 Medicare 184 90 104 15.56 107 2.88 15000 6102 Workers'Compensation 976 223 497 122.91 512 3.02 15000 6201 Retirement Benefits 155 0 57 0.00 59 3.51 15000 6202 Health Insurance 329 0 94 0.00 100 6.38 15000 6204 Electric Meal Allowance 0 1,182 200 (83.08) 100 (50.00) 15000 6205 Electric Union Benefits 0 0 0 0.00 0 0.00 Total Personnel Costs: $ 12,716 $ 7,251 $ 8,831 $ 339.54 $ 8,994 $ (28.19) Non-Personnel Costs: 15000 7002 Postage and Freight 0 500 1,500 199.98 1,000 (33.33) 15000 7009 Contracted Services 0 5,000 0 (100.00) 0 0.00 15000 7015 Utilities 15,495 20,000 20,000 0.00 20,000 0.00 15000 7016 Heating Fuel 896 3,000 15,000 400.00 15,000 0.00 15000 7103 Fuel for Generators 0 50,000 50,000 0.00 50,000 0,00 15000 7211 Gas&Lube 0 0 7,500 0.00 7,500 0.00 15000 7215 Operating Supplies 0 10,000 5,000 (50.00) 5,000 0.00 15000 7216 Maintenance&Repair 60 45,000 30,000 (33.33) 30,000 0.00 15000 7217 Small Tools&Equipment 0 5,000 0 (100.00) 0 0.00 15000 7302 Travel&Subsistence 0 0 0 0.00 0 0.00 15000 7303 Education&Training 3,395 10,000 5,000 (50.00) - 5,000 0.00 Total Non-Personnel Costs: $ 19,846 $ 148,500 $ 134,000 $ 266.65 $ 133500 $ (33.33) Total Expenditures $ 32,562 $ 155,751 $ 142,831 $ 606.19 $ 142,494 $ (61.52) Run:10/1312015 at 12:53 PM Expenditure Detail by Department Electric Enterprise Fund Electric•Substation Operations For 9130(2015 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 103,572 95,453 119,463 25.15 123,054 3.01 15000 6001 Overtime 1,181 9,133 1,365 (85.05) 1,406 3.00 15000 6100 Medicare 1,528 109 1,501 1,277,57 1,546 3.00 15000 6102 Workers'Compensation 9,387 288 9,549 3,215.63 9,836 3.01 15000 6200 Leave Time 0 0 0 0.00 1,040 0.00 15000 6201 Retirement Benefits 2,329 0 849 0.00 883 4.00 15000 6202 Health Insurance 5,203 0 1,480 0.00 1,554 5.00 15000 6204 Electric Meal Allowance 0 218 150 (31.21) 0 (100.00) 15000 6205 Electric Union Benefits 83 0 0 0.00 50 0.00 Total Personnel Costs: $ 123,283 $ 105,201 $ 134,357 11,402.09 $ 139,369 $ (78.98) Non-Personnel Coats: 15000 7001 Communications 3,432 3,500 5,000 42.86 5,000 0.00 15000 7002 Postage and Freight 121 1,000 5,000 400.02 5,000 0.00 15000 7009 Contracted Services 6,867 5,000 15,000 200.00 15,000 0.00 15000 7015 Utilities 58,043 60,000 65,000 8.33 65,000 0.00 15000 7016 Heating Fuel 3,144 8,000 5,000 (37.50) 5,000 0.00 15000 7103 Fuel for Generators 0 100,000 50,000 (50.00) 50,000 0.00 15000 7211 Gas&Lube 0 0 0 0.00 0 0.00 15000 7215 Operating Supplies 3,052 15,000 20,000 33.33 20,000 0.00 15000 7216 Maintenance&Repair 2,351 20,000 20,000 0.00 20,000 0.00 15000 7217 Small Tools&Equipment 0 5,000 0 (100.00) 0 0.00 15000 7300 Advertising 371 0 0 0.00 0 0.00 15000 7302 Travel&Subsistence 0 0 0 0.00 0 0.00 15000 7304 Equipment Rent 785 1,000 3,000 200.01 3,000 0.00 15000 8101 Infrastructure 0 0 0 0.00 0 0.00 15000 8103 Capital Equipment 0 0 0 0.00 0 0.00 Total Non-Personnel Costs: $ 78,166 $ 218,500 $ 188,000 $697.05 $ 188,000 $ 0.00 Total Expenditures $ 201,449 $ 323,701 $ 322,357 $,099.14 $ 327,369 $ (78.98) Run:10/1312015 at 12:53 PM Expenditure Detail by Department Electric Enterprise Fund Electric-Transmission OP&Maint For 913012015 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 2,518 20,461 20,622 0.79 21242 3.01 15000 6001 Overtime 0 959 2,957 208.33 3,046 3.01 15000 6100 Medicare 37 148 290 96.00 298 2.76 150006102 Workers'Compensation 171 632 1,127 78.31 1,161 3.02 15000 6200 Leave Time 0 1,061 0 (100.00) 76 0.00 15000 6201 Retirement Benefits 81 0 30 0.00 31 3.33 15000 6202 Health Insurance 246 0 73 0.00 73 0.00 15000 6205 Electric Union Benefits 3 0 0 0.00 0 0.00 Total Personnel Costs: $ 3,056 $ 23,261 $ 25,099 $283.43 $ 25,927 $ 15.13 Non-Personnel Costs: 15000 7002 Postage and Freight 0 0 0 0.00 0 0.00 15000 7009 Contracted Services 0 10,000 150,000 1,400.01 150,000 0.00 15000 7017 Rents&Leases 18,136 15,000 20,000 33.33 20,000 0.00 15000 7215 Operating Supplies 0 2,000 2,000 0.00 2,000 0.00 15000 7216 Maintenance&Repair 0 10,000 5,000 (50.00) 5,000 0.00 15000 7304 Equipment Rent 0 12,000 12,000 0.00 12,000 0.00 Total Non-Personnel Costs: $ 18,136 $ 49,000 $ 189,000 $,383.34 $ 189,000 $ 0.00 Total Expenditures $ 21,192 $ 72,261 $ 214,099 $,666.77 $ 214,927 $ 15.13 Run:10/13/2015 at 12:53 PM Expenditure Detail by Department Electric Enterprise Fund Electric-Distribution OP&Maint For 9130/2015 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 30,369 18,549 30,563 64.77 31,481 3.00 15000 6001 Overtime 15,590 30,039 38,845 29.32 40,012 3.00 15000 6002 Standby Time 2,876 0 1,044 0.00 1,075 2.97 15000 6100 Medicare 717 700 862 23.15 888 3.02 15000 6102 Workers'Compensation 2,832 2,458 3,567 45.12 3,674 3.00 15000 6200 Leave Time 0 0 0 0.00 271 0.00 15000 6201 Retirement Benefits 1,333 0 486 0.00 506 4.12 15000 6202 Health Insurance 2,582 0 735 0.00 771 4.90 15000 6204 Electric Meal Allowance 0 3,864 1,500 (61.18) 800 (46.67) 15000 6205 Electric Union Benefits 45 0 0 0.00 0 0.00 Total Personnel Costs: $ 56,344 $ 55,610 $ 77,602 $ 101.18 $ 79,478 $ (22.66) Non-Personnel Costs: 15000 7009 Contracted Services 0 0 0 0.00 0 0.00 15000 7215 Operating Supplies 0 3,000 0 (100.00) 0 0.00 15000 7304 Equipment Rent 3,900 5,000 4,000 (20,00) 4,000 0.00 150008101 Infrastructure 0 465,000 300,000 (35.48) 0 (100.00) 15000 8103 Capital Equipment 0 0 0 0.00 10,000 0.00 Total Non-Personnel Costs: $ 3,900 $ 473,000 $ 304,000 $(155.48) $ 14,000 $(100,00) Total Expenditures $ 60,244 $ 528,610 $ 381,602 $ (54.30) $ 93,478 $(122.66) Run:10/13/2015 at 12:53 PM Expenditure Detail by Department Electric Enterprise Fund Electric-Wholesale Power Costs For 913012015 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: �.. Total Personnel Costs: $ 0 $ 0 $ 0 $ 0.00 $ 0 $ 0,00 Non-Personnel Costs: 15000 7101 Chugach Power Purchases 1,908,272 1,775,000 2,000,000 12.68 2,000,000 0.00 15000 7102 Power Fuel Costs 2,948,959 3,066,000 3,000,000 (2.15) 3,000,000 0.00 Total Non-Personnel Costs: $ 4,857,231 S 4,841,000 $ 5,000,000 $ 10.53 $ 5,000,000 $ 0.00 Total Expenditures $ 4,857,231 $ 4,841,000 $ 5,000,000 $ 10.53 $ 5,000,000 $ 0.00 Run:10113/2015 at 12:53 PM Expenditure Detail by Department Electric Enterprise Fund Electric•Work Orders For 913012015 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 62,358 111,809 87,118 (22.08) 89,737 3.01 150006001 Overtime 6,394 15,120 14,978 (0.94) 15,429 3.01 15000 6100 Medicare 1,033 3,544 1,637 (53.81) 1,686 2.99 15000 6102 Workers'Compensation 3,709 11,823 5691 (51.87) 5,862 3.00 15000 6200 Leave Time 0 0 0 0.00 2,120 0.00 15000 6201 Retirement Benefits 4,514 0 5,439 0.00 5,657 4.01 15000 6202 Health Insurance 10,823 0 8,589 0,00 9,019 5.01 15000 6204 Electric Meal Allowance 0 5,384 1,000 (81.43) 300 (70.00) 15000 6205 Electric Union Benefits 79 0 100 0.00 100 0.00 Total Personnel Costs; $ 88,910 $ 147680 $ 124,552 $(210.13) $ 129,910 $ (48.97) Non-Personnel Costs: 15000 7002 Postage and Freight 0 1,500 0 (100.00) 0 0.00 15000 7009 Contracted Services 0 0 0 0.00 0 0.00 15000 7215 Operating Supplies 4,910 150,000 100,000 (33.33) 100,000 0.00 15000 7810 Miscellaneous Expense (600) 3,000 1,000 (66.67) 0 (100.00) 15000 8200 Work Order Sal/Benefit credits (208,130) (297,763) (100,000) (66.42) (100,000) 0.00 15000 8201 Work Order Operating Supply credits (127,829) (50,000), (50,000) 0.00 (50,000) 0.00 Total Non-Personnel Costs: $ (331,649) $ (193,263) $ (49,000) $(266.42) $ (50,000) $(100.00) Total Expenditures $ (242,739) $ (45,583) $ 75,552 $(476.55) $ 79,910 $(148.97) Run:10/13/2015 at 1253 PM Expenditure Detail by Department Electric Enterprise Fund Electric-Standby For 913012015 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 0 0 0 0.00 193 0.00 15000 6001 Overtime 9,060 0 2551 0.00 2,628 3.02 15000 6002 Standby Time 93,621 89,283 86,217 (3.43) 88,809 3.01 150006100Medicare 1,507 1,122 1,432 27.63 1,476 3.07 15000 6102 Workers'Compensation 2,637 29 692 2282.92 713 3.03 15000 6201 Retirement Benefits 3,550 0 1,295 0.00 1,347 4.02 15000 6202 Health Insurance 4,408 0 1,254 0.00 1,317 5.02 15000 6205 Electric Union Benefits 106 0 0 0.00 100 0.00 Total Personnel Costs: $ 114,889 $ 90,434 $ 93,441 $t,307.12 $ 96,583 $ 21,17 Non-Personnel Costs: Total Non-Personnel Costs: $ 0 $ 0 $ 0 $ 0.00 $ 0 $ 0.00 Total Expenditures $ 114,889 $ 90,434 $ 93,441 $,307.12 $ 96,583 $ 21.17 Run:10113/2015 at 12:53 PM Expenditure Detail by Department Electric Enterprise Fund Electric•Meter Service For 9130/2015 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 15,706 36,493 29,973 (17.87) 30,874 3.01 15000 6001 Overtime 0 182 121 (33.53) 124 2.48 15000 6100 Medicare 233 477 440 (7.76) 453 2.95 15000 6102 Workers'Compensation 1,110 1,992 2,734 37.25 2,816 3.00 15000 6200 Leave Time 0 0 0 0.00 832 0.00 15000 6201 Retirement Benefits 350 0 128 0.00 133 3.91 15000 6202 Health Insurance 922 0 262 0.00 275 4.96 15000 6205 Electric Union Benefits 11 0 0 0.00 0 0.00 Total Personnel Costs: $ 18,332 $ 39,144 $ 33,658 $ (21.91) $ 35,507 $ 20.31 Non-Personnel Costs: 15000 7002 Postage and Freight 63 0 0 0.00 0 0.00 15000 7009 Contracted Services 56,188 60,000 56,000 (6.67) 56,000 0.00 15000 7213 Safety Equipment 38 0 0 0.00 0 0.00 15000 7215 Operating Supplies 360 5,000 5,000 0.00 5,000 0.00 Total Non-Personnel Costs: $ 56,649 $ 65,000 $ 61,000 $ (6.67) $ 61,000 $ 0.00 Total Expenditures $ 74,981 $ 104,144 $ 94,658 $ (28.58) $ 96,507 $ 20.31 Run:10113/2015 at 12:53 PM Expenditure Detail by Department Electric Enterprise Fund Electric-System Improvements For 913012015 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 12,459 0 3,459 0,00 3,563 3.01 15000 6001 Overtime 134 0 100 0.00 39 (61.00) 15000 6100 Medicare 23 0 25 0.00 0 (100.00) 15000 6102 Workers'Compensation 76 0 20 0.00 20 0.00 15000 6201 Retirement Benefits 122 0 44 0.00 46 4.55 15000 6202 Health Insurance 244 0 69 0.00 73 5.80 15000 6205 Electric Union Benefits 0 _ 0 0 0.00 0 0.00 Total Personnel Costs: $ 13,058 $ 0 $ 3,717 $ 0.00 $ 3,741 $(147.64) Non-Personnel Costs: 15000 7215 Operating Supplies 4,199 0 0 0.00 0 0.00 150008101 Infrastructure 0 211,659 120,000 (43.31) 120,000 0.00 Total Non-Personnel Costs: $ 4,199 $ 211,659 $ 120,000 $ (43.31) $ 120,000 $ 0.00 Total Expenditures $ 17,257 $ 211,659 $ 123,717 $ (43.31) $ 123,741 $(147.64) Run:10113/2015 at 12:53 PM Expenditure Detail by Department Electric Enterprise Fund Electric Debt Service For 9/3012015 2016 2017 2014 2015 Budget 2015-16 Budget 2016-17 Actual Budget Request %Chg Request %Chg Total Expenditures Personnel Costs: 15000 6000 Salaries 882 0 0 0.00 0 0.00 15000 6100 Medicare 13 0 0 0.00 0 0.00 15000 6102 Workers'Compensation 7 0 0 0.00 0 0.00 150006201 Retirement Benefits 222,306 52,478 51,161 (2.51) 52,895 3.39 Total Personnel Costs: $ 223,208 $ 52,478 $ 51,161 $ (2.51) $ 52,895 $ 3.39 Non-Personnel Costs: 15000 8012 Debt Service Interest Expense 290,053 273,261 261,286 (4.38) 255,919 (2.05) 15000 8014 Amortization of Bond Issue Costs 4,904 8,425 0 (100.00) 0 0.00 15000 8300 Debt Service Principal 380,000 400,000 130,000 (67.50) 135,000 3.85 Total Non-Personnel Costs: $ 674,957 $ 681,686 $ 391286 $(171.88) $ 390,919 $ 1.80 Total Expenditures $ 898,165 $ 734,164 $ 442,447 $(174.39) $ 443,814 $ 5.19 CITY OF SEWARD ELECTRIC ENTERPRISE FUND 2016 and 2017 Debt Service Schedule Balance 2016 Budget Balance Description Interest Rate @ 1/01/16 Principal Interest Retirement Total @ 12/31/16 Term 2008 Replacement Generators Bond 4.77% 5,245,000 130,000 261,286 391,286 5,115,000 2007-12/2038 PERS Past Service Cost n/a n/a n/a 51,161 51,161 Totals: $5,245,000 $130,000 $261,286 $51,161 $442,447 $5,115,000 Balance 2017 Budget Balance Description Interest Rate @ 1/01/17 Principal Interest Retirement Total @ 12/31/17 Term 2008 Replacement Generators Bond 4.77% 5,115,000 135,000 255,919 390,919 4,980,000 2007-12/2038 PERS Past Service Cost n/a n/a n/a 52,895 52,895 Totals: $5,115,000 $135,000 $255,919 $52,895 $443,814 $4,980,000 Y CITY OF SEWARD ELECTRIC ENTERPRISE FUND Budgeted Interfund Transfers Fiscal Year 2016 and 2017 2016 2017 Transfers- Transfers- Transfers- Transfers- In Out In Out TRANSFERS FROM OTHER FUNDS: General Fund-SMIC deficit loan repayment (a) - General Fund for ASLC Utility Bill 8,400 16,800 TRANSFERS TO OTHER FUNDS: General Fund: Electric system permit fee $300,000 $300,000 Federal and state lobbying 40,319 40,319 Payments-in-Lieu-of-Tax 930,309 953,000 $8,400 $1,270,628 $16,800 $1,293,319