Loading...
HomeMy WebLinkAbout08122024 City Council Laydown - Electric FinancialsLAYDOWN from Finance Dept August 12, 2024 7 pages COS - 15000 Budget to Actual Electric Fund July 31, 2024 Y-T-D Y-T-D % of Annual Actual Budget YTDBudget Budget Revenues 15000 5300 Residential 1,488,621.42 1,166,669 128% 2,569,667 15000 5302 Residential fuel factor 1,212,506.93 1,058,862 115% 1,815,187 15000 5303 Residential customer charge 324,053.80 118,237 274% 541,942 15000 5310 SG Service 889,704.52 606,193 147% 1,526,601 15000 5312 SG fuel factor 687,707.57 558,313 123% 957,112 15000 5313 SG Customer Charge 169,631.52 71,267 238% 254,712 15000 5320 LG Service 1,062,272.66 961,408 110% 1,923,902 15000 5322 LG fuel factor 1,341,489.85 1,256,486 107% 2,153,973 15000 5323 LG customer charge 24,699.39 27,755 89% 47,574 15000 5324 LG demand charge 779,030.34 274,127 284% 1,565,309 15000 5350 Harbor Fund Power Sales 176,063.98 163,821 107% 442,873 15000 5352 Harbor power fuel factor 131,306.16 156,471 84% 459,930 15000 5360 Street & Yard 46,702.32 45,430 103% 77,877 15000 5362 Yard Light Fuel 5,319.08 4,431 120% 7,592 15000 5370 Industrial Service 392,330.98 500,794 78% 858,500 15000 5371 Industrial Customer Charge 2,100.00 441 476% 758 15000 5372 Industrial Demand Charge 338,166.63 73,647 459% 126,252 15000 5373 Industrial Fuel Factor 632,639.86 621,572 102% 1,065,550 15000 5800 Labor & Services 409.06 0 0% 0 15000 5801 Turn on Fees 4,715.15 10,654 44% 18,258 15000 5802 Equipment Rental 0.00 3,199 0% 5,484 15000 5803 Joint Pole Use 0.00 6,020 0% 10,314 15000 5804 Work Order Revenue 0.00 17,500 0% 257,691 15000 5899 Miscellaneous Revenue 10,704.44 0 0% 0 15000 5901 EF Investment Interest 22,124.40 20,419 108% 195,000 15000 5905 EF Penalties and Interest 34,771.86 15,631 222% 26,800 15000 5941 Amort.Bond Premium 0.00 32,515 0% 55,741 15000 5945 ERO- SURCHARGE 19,024.25 0 0% 0 Total Revenues 9,796,096.17 7,771,862.0 126% 16,964,597 Expenditures Personnel Costs: 15000 6000 Salaries 421,519.65 648,452 65% 1,111,633 15000 6001 Overtime 81,579.11 61,292 133% 105,090 15000 6002 Standby Time 142,672.68 82,600 173% 141,595 15000 6100 Medicare 9,456.82 8,687 109% 14,881 15000 6102 Workers' Compensation 13,088.74 23,401 56% 24,082 15000 6201 Retirement Benefits 107,126.56 121,415 88% 208,147 15000 6202 Health Insurance 149,194.52 192,514 77% 330,033 15000 6203 In Lieu of FICA 0.00 2,975 0% 5,100 15000 6204 Meal Allowance 5,342.97 4,158 128% 7,128 15000 6205 Electric Union Benefits 1,297.50 4,970 26% 8,520 15000 6210 Air Ambulance Benefit 1,079.00 0 0% 0 15000 6211 Met Life - Life Benefit 22.60 0 0% 0 Total Personnel Costs: 932,380.15 1,150,464 81% 1,956,209 Non -Personnel Costs: 15000 7001 Communications 7,286.99 11,466 64% 19,650 15000 7002 Postage and Freight 6,542.88 10,171 64% 17,436 15000 7003 Bank and Credit Card Fees 25,475.42 21,429 119% 150,000 15000 7004 Insurance 74,179.62 67,942 109% 124,403 15000 7006 Legal 35,489.50 52,500 68% 90,000 15000 7009 Contracted Services 222,091.90 200,081 111% 1,193,000 15000 7010 Engineering 11,669.09 29,750 39% 51,000 15000 7011 Testing 3,273.69 10,556 31% 18,100 1 15000 7012 Other Special Services 20.00 2,625 1% 4,500 15000 7015 Utilities 104,869.90 116,620 90% 220,920 15000 7016 Heating Fuel 15,181.56 21,420 71% 36,720 15000 7017 Rents & Leases 23,444.54 9,464 248% 16,222 15000 7022 Software/SaaS Subscriptions 629.05 8,869 7% 15,200 15000 7101 Chugach Power Purchases 1,799,682.82 1,395,919 129% 4,491,916 15000 7102 Power Fuel Costs 1,541,130.69 2,163,000 71% 3,819,176 15000 7103 Fuel for Generators 16,775.90 107,919 16% 185,000 15000 7210 Vehicle Supplies 14,540.11 11,669 125% 20,000 15000 7211 Gas & Lube 8,876.01 20,825 43% 35,700 15000 7212 Uniform Allowance 3,945.74 7,413 53% 12,700 15000 7213 Safety Equipment 1,936.61 13,650 14% 23,400 15000 7215 Operating Supplies 33,786.81 50,169 67% 357,221 15000 7216 Maintenance & Repair 1,232.00 23,569 5% 40,400 15000 7217 Small Tools & Equipment 10,842.69 13,713 79% 23,500 15000 7221 Operating Materials 101,097.95 175,000 58% 387,311 15000 7300 Advertising 4,139.20 5,831 71% 10,000 15000 7301 Subscriptions & Dues 27,507.98 47,544 58% 81,500 15000 7302 Travel & Subsistence 358.92 14,287 3% 24,500 15000 7303 Education & Training 2,975.63 8,316 36% 14,250 15000 7304 Equipment Rent 0.00 3,794 0% 6,500 15000 7307 GF Administrative Fee 622,332.10 622,335 100% 1,066,855 15000 7311 RRC - ERO Surcharge 15,492.97 0 0% 0 15000 7330 P.I.L.T. 663,852.00 0 0% 0 15000 7331 Reclass PILT to Transfer -Out (663,852.00) 0 0% 0 15000 7808 Bad Debt Expense 30,494.04 14,581 209% 25,000 15000 7810 Miscellaneous Expense 2,825.08 0 0% 0 15000 7900 Depreciation Expense 0.00 924,581 0% 1,585,000 15000 8001 Unrealized Loss on Investments 6,099.68 0 0% 0 15000 8010 Utility Deposit Interest 92.72 875 11% 1,500 15000 8012 Debt Service Interest Expense 355,825.00 336,406 106% 576,700 15000 8013 Amortization of Deferred Loss on Bonds 0.00 12,194 0% 20,903 15000 8014 Amortization of Bond Issue Costs 0.00 2,625 0% 4,500 15000 8103 Capital Equipment 2,624.34 0 0% 0 15000 8104 Motor Pool Rent 49,583.35 49,588 100% 85,000 15000 8300 Debt Service Principal 205,000.00 119,581 171% 205,000 Total Non -Personnel Costs: 5,389,352.48 6,686,848 81% 15,060,683 Total Expenditures 6,321,732.63 7,837,312.00 81% 17,016,892.00 Excess Revenue Over (Under) Expenditures 3,474,363.54 (65,450.00) 45% (52,295.00) Notes: PILT expenses from July are not recorded. Chugach expenses for July have not been received. COS - 15001 - Electric MRRF Fund July 31, 2024 15001 - Electric MRRF Fund Assets 1099 Due To/From Other Funds - Central Treasury Total Assets Fund Balance/Net Assets 3400 Unassigned Fund Balance 3700 Transfers -In 3710 Transfers -Out 3720 Elimination Transfers -In Total Fund Balance/Net Assets Revenues 5900 EF Interest Revenue 5904 EF Misc. Interest Revenue Total Revenues Expenditures/Expenses Personnel Costs: Total Personnel Costs: Non -Personnel Costs: 7009 Contracted Services 8101 Infrastructure 8102 Buildings Total Non -Personnel Costs: Total Expenditures/Expenses Variance Last Year This Year This Year (Over)/Under Balance Budget Balance Budget 957,301.76 452,117.00 957,301.76 452,117.00 957,301.76 (800,026.60) 0.00 650,000.00 0.00 0.00 0.00 0.00 1,607,301.76 1,155,184.76 1,607,301.76 1,155,184.76 957,301.76 650,000.00 0.00 0.00 (1,757,328.36) 0.00 0.00 0.00 957,301.76 (150,026.60) 1,607,301.76 (1,757,328.36) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 159,800.00 0.00 159,800.00 0.00 159,800.00 Res.2024-029 Yukon Fire Sistem for the Utility Generation Facilities- $159,800 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 (159,800.00) 0.00 (159,800.00) 0.00 (159,800.00) 3 COS - 15310 - Transmission Line -City Funding July 31, 2024 15310 - Transmission Line -City Funding Variance Last Year This Year This Year (Over)/Under Balance Budget Balance Budget Assets 1099 Due To/From Other Funds - Central Treasury 0.00 0.00 184,640.38 184,640.38 Total Assets 0.00 0.00 184,640.38 184,640.38 Liabilities 2000 A/P Trade 2001 Accrued A/P 2010 Reserve for Encumbrance Total Liabilities Fund Balance/Net Assets 3400 Unassigned Fund Balance 3700 Transfers -In 3710 Transfers -Out Total Fund Balance/Net Assets Revenues Total Revenues Expenditures/Expenses Non -Personnel Costs: 7009 Contracted Services Total Non -Personnel Costs: Total Expenditures/Expenses 0.00 72,354.85 0.00 0.00 0.00 0.00 72,354.85 0.00 0.00 0.00 0.00 0.00 423,550.00 0.00 37,808.68 0.00 0.00 (37,808.68) 0.00 0.00 37,808.68 (37,808.68) (72,354.85) 423,550.00 0.00 72,354.85 0.00 0.00 0.00 423,550.00 351,195.15 72,354.85 0.00 0.00 72,354.85 423,550.00 72,354.85 423,550.00 72,354.85 423,550.00 0.00 0.00 204,363.45 (219,186.55) 204,363.45 (219,186.55) 204,363.45 (219,186.55) Res. 2023-138 Chugach Electric and the City of Seward share easement maintenance. -$423,550 4 COS - 15340 - Electric Critical Infrastructure Project - City Funding July 31, 2024 Variance (Over)/Unde 15340 - Electric Critical Infrastructure Project • Last Year This Year This Year r City Funding Assets 1099 Due To/From Other Funds - Central Treasury Total Assets Liabilities 2000 A/P Trade 2001 Accrued A/P 2010 Reserve for Encumbrance Total Liabilities Fund Balance/Net Assets 3400 Unassigned Fund Balance - Electric Critical 3700 Transfers -In 3710 Transfers- Out - None Total Fund Balance/Net Assets Balance Budget Balance Budget 7,868.33 0.00 7,868.33 0.00 30,081.35 112,398.70 0.00 0.00 0.00 0.00 142,480.05 0.00 1,972,328.95 796,905.00 (2,895,536.36) (126,302.41) (209,827.00) 830,760.00 0.00 620,933.00 (3,850.71) (3,850.71) (3,850.71) (3,850.71) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,964,019.64 1,299,426.26 (2,895,536.36) 367,909.54 (2,173,846.64) (468,666.26) 2,895,536.36 253,023.46 Revenues Total Revenues 0.00 0.00 0.00 0.00 Expenditures/Expenses 7000 Audit 7001 Communications 7002 Postage and Freight 7009 Contracted Services 7010 Engineering 7017 Rents & Leases 7215 Operating Supplies 7304 Equipment Rent 8100 Land 8101 Infrastructure - Electric Critical Infrastructure 8103 Capital Equipment - Electric Critical Total Non -Personnel Costs: Total Expenditures/Expenses 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 29,870.00 29,870.00 6,337.71 0.00 95,727.26 95,727.26 0.00 0.00 0.00 0.00 1,230.00 0.00 0.00 0.00 0.00 0.00 1,505.98 1,505.98 741.60 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 33,855.00 244,657.01 210,802.01 8,309.31 33,855.00 371,760.25 337,905.25 8,309.31 33,855.00 371,760.25 337,905.25 15340 - Electric Critical Infrastructure Project - City Funding - $33,855 5 COS - 15351 - Electric Nash Road Infrastructure Project July 31, 2024 15351 - Electric Nash Road Infrastructure Project Assets 1099 Due To/From Other Funds - Central Treasury 1218 A/R - Miscellaneous A/R 1700 Construction in Progress Liabilities 2000 A/P Trade 2001 Accrued A/P 2010 Reserve for Encumbrace Variance (Over)/Unde Last Year This Year This Year r Balance Budget Balance Budget 1,242,256.57 17,802.29 0.00 Total Assets 1,260,058.86 Total Liabilities Fund Balance/Net Assets 3400 Unassigned Fund Balance 3700 Transfers - In - None 3710 Transfers - Out - None Total Fund Balance/Net Assets 71,364.65 343,147.24 0.00 0.00 0.00 0.00 253,955.13 17,802.29 58,043.69 253,955.13 17,802.29 58,043.69 0.00 329,801.11 329,801.11 0.00 0.00 0.00 414,511.89 0.00 5,374,288.46 3,595,106.62 (7,806,278.61) 1,163,116.47 (3,595,106.62) 3,595,106.62 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5,056,718.96 3,595,106.62 (8,163,771.80) 488,053.78 (8,651,825.58) 0.00 8,163,771.80 (488,053.78) Revenues 5922 State Project Funds 0.00 0.00 0.00 0.00 5923 Spec.Proj.Other Rev. 0.00 0.00 0.00 0.00 Total Revenues 0 0 0 0 Expenditures/Expenses Personnel Costs: Total Personnel Costs Non -Personnel Costs: 7000 Audit 7001 Communications 7002 Postage and Freight 7004 Insurance 7009 Contracted Services 7010 Engineering 7017 Rents & Leases 7103 Fuel for Generators 7210 Vehicle Supplies 7211 Gas & Lube 7213 Safety Equipment 7215 Operating Supplies 0 0 0 0 0.00 0.00 4,970.00 2,632.76 0.00 0.00 1,145.00 117,821.42 432.66 7,497.05 2,534.00 5,796.03 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 87,002.67 87,002.67 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6 7302 Travel & Subsistence 7304 Equipment Rent 7810 Miscellaneous Expense 8100 Land 8101 Infrastructure - Electric Nash Road 8103 Capital Equipment - Electric Nash Road Total Non -Personnel Costs: Total Expenditures/Expenses 947.66 173,792.92 0.00 0.00 0.00 0.00 317,569.50 317,569.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 71,250.00 71,250.00 0.00 158, 252.67 158, 252.67 0.00 158,252.67 158,252.67 7