Loading...
HomeMy WebLinkAbout2009-0921 Document Submitted at Meeting ELECTRIC FUND #690 Revenues IntergovemmenlaJRevenue Charges for Services Fees Surcharge Intereslonlnvestments Miscellaneous Revenues Other Financing Proceeds lnlerfund loan Proceeds Total Revenues AduaJ%ofFillaJBudget Operational Expenditures Conservalion-PersonalServires Conservation-Materials & Services Conservation-Project SPA Supply power costs Supply-Materials & Services Supply-Capitalou~ay Distribution- Personal Services Distribution. Materials & Services Distribution.CapitaIOu~ay Distribution M&S - Payment for Technology debt. Franchise fee SPA Transmission power costs Transmission-Materials & Services Dperating Transfers Out CRES Debt Service 2009 - 2014 Operating Conlingency Total Expenditures Aclua/%ofFina1Budget AauaJ % ofFrlaJBudgetmRwS Cootingeocy Revenues Over (Under) Expenditures Working Capital Carryover Operating Ending Fund Balance Fund Balance Policy Requirement Fund Balance and Conlingency Excess (Deficiency) L <2JI.. llA./'-L- \Q IU"";}- OS LJo""':,11-<A ss q I )"l/cx;., "*' ~'Y 2009 2004 2005 2006 2007 2008 Amended 2009 2010 Actual Actual Actual Actual Actual Budget Actual Calculated $ 7,165 $ 42,656 $ 36,042 $ 32,233 $ 67,620 $ 110,000 $ 47,121 $ 48,000 10,316,614 10,841,140 10,781,669 10,941,631 11,081,322 12,481,700 11,530,672 11,838,300 93,054 151,145 69,117 232,160 169,848 214,100 158,004 150,000 1,329,577 1,266,655 1,135,060 1,111,676 1,009,060 292 6,502 32,540 54,293 90,007 55,827 70,900 13,298 20,000 69,001 54,066 63,800 97,346 155,330 101,000 329,426 100,000 304,000 311,000 148,961 375,000 11,821,913 12,763,202 12,139,981 12,505,053 12,843,007 13,288,700 12,227,774 12,156,300 100.45" 100.07% 94.2~ 98.38" 93.90% 92.02" 109,137 112,814 136,640 141,242 142,840 159,200 146,652 155,500 165,622 262,755 265,957 318,011 259,016 368,3S<l - ._=l4?,547 366,500 676,610 5,506,320 5,640,786 5,730,855 5,769,848 5,458,025 5,260,000 4,657,861 !!"~" 5,165,000 I 242,861 238,900 296,050 312,915 399,107 400,204 396,307 385,204 13,241 7,222 152,031 200,000 163,071 1,537,845 1,552,417 1,727,177 1,789,161 1,916,307 2,001,144 1,906,063 2,020,400 2,184,200 2,221,169 2,386,680 2,573,892 2,583,913 2.654,326 1,429,584 1,472,500 675,938 580,749 535,884 647,970 825,471 667,000 557,994 505,000 22,337 252,300 252,300 252,300 252,300 1,205,809 1,215,600 942,442 956,625 971,899 886,288 886,638 900,000 861,105 I};,;l '875,0001 5,031 2,100 3,000 3,600 3,600 200,000 500,000 375,000 ~ 25,600 25,326 25,108 399,000 , ',I: I 11,779,974 11,775,538 12,551,142 12,442,327 13,552,258 13,290,724 12,047,619 12,441,712 93.54" 93.99'-' 89.67" 87.91" 96.56% 90.65" 94.10% 94.75" 92.21" 90.34% 97.60% 93045" 41,939 987,664 (411,161) 62,726 (709,251) (2,024) 180,155 -T28~~12): 1,497,827 1,539,766 2,527,430 2,116,269 2,178,995 2,127,569 1,469.144 1,649,899 $ 1,539,766 $ 2,527,430 $ 2,116,269 $ 2,178,995 $ 1,469,744 $ 2,125,545 $ 1,649,899 $ 1,364,487 1,418,630 1,914.166 496,136 1,458,760 1,364,487 (94,273) 1,486,580 2,527,430 1,040,850 1,456,800 2,116,269 659,469 1,500,610 2,178,995 678,385 1,504,680 1,469,744 134,9361 1,557,320 2,524,545 967,225 1,449,460 1,649,899 2~,~~~_ H:\Rate Models\2010 Long Term Budget Adopted. electric revised 9-21-09 Electric 9/21/20093:57 PM ELECTRIC FUND 2011 2012 2013 2014 2015 Long-tenn #690 Projection Projection Projection Projection Projection Comments Percent Revenues IntergovemmentaJRevenue $ 48,000 $ 48,000 $ 48,000 $ 48,000 $ 48,000 100.0% ChargeslorSelVices 12,371,000 12,927,700 13,509,400 14,117,400 14,752,700;__ - -....-..- - '-----;:";;";;;;;1 -,--~- ___--!:.~__.!!l6.0~ Fees 154,500 159,100 163,900 168,800 173,900 2012 wholesale contracl renewal. 103,0% Surcharge 711108 BPA surcharge absorbed Into re9ularrates 103.0% Interest on Investments 20,000 20,000 20,000 20,000 20,000 103.0% Miscellaneous Revenues 101,000 102,000 103,000 104,000 105,000 101.0% Other Financing Proceeds BETCrevenue InterfundLoanProceeds Total Revenu9S 12,694,500 13,256,800 13,844,300 14,458,200 15,099,600 Actua/%ofFina/Budget Operational Expenditures Conservalion-PersonalServices 248,900 263,800 279,600 296,400 Increased Conservation Staffing lor Council Goal 106.0% Conservation-Materials & Services 566,500 566,500 566.500 566,500 Increased Conservation M&S costs for Council Goal 100.0% Conservation-Project 100.0% 8PASupplYIXlWllrcosts 5,165,000 5,200,000 5,356,000 5,516,700 5,682,200 Estimated I 1030%1 Supply - Materials & SelVices 396,800 408,700 421,000 433,600 446,600 103.0% Supply-CapilaJOutlay 100.0% Distribution-PersonalServices 2,141,600 2,270,100 2,406,300 2,550,700 2,703,700 106.0% Distribution-Materials & Services 1,516,700 1,562,200 1,609,100 1,657,400 1,707,100 103.0% Distribution-Capital Outlay 505,000 505,000 505,000 505,000 505,000 100.0% Distribution M&S. Payment for Technology debt. 252,300 252,300 252,300 252,300 252,300 Additional amount lor AFN Debt may be required Franchise lee 1,269,500 1,325,700 1,384,400 1,445,800 1,510,000 Calculated 10%0f total revenue BPA Transmission powercosls 875,000 901,300 928,300 956,100 984,800 Estimated I,. 103.0%1 Transmission-Materials & Services 4,000 4,000 4,000 4,100 4,200 Operating TranslersOut CREB Debt Service 2009 - 2014 24,836 24,565 24,293 24,022 23,750 100.0% OperalingContingency V~;./, '-i' , co ~> ~ ' ;1,~1 ;' "~~',,tii' l :,":' ::'11 3% Contingency is removed lor modeling Total Expenditures 12,952,036 13,269,265 13,720,993 14,191,822 14,682,550 Acluaf% ofRnalBudgel Average use ofConlingency Aclu81 % ofFin8lBudgelminus Confillgency in recent history is und6r SO". Revenues Over (Under) Expenditures ( ~(~5!~36): (12~4S5): 123,307 266,378 417,050 Working Capital Carryover 1,364,487 1,106,951 1,094,486 1,217.793 1,484,171 Operating Ending Fund Balance 1,106,951 1,094,486 1,217,793 1,484,171 1,901,221 Fund Balance Policy Requirement 1,523,340 1,590,820 1,661,320 1,734,980 1,811,950 Policy is 12% of Annual Revenues Fund Balance and Contingency 1,106,951 1,094,486 1,217,793 1,464,171 1,901,221 Excess (DefICiency) L.::!.::1i1.!:!2!_1496;3341_'<43;'27JI' (25O,809~ 89,271 H:\Rate Models\201 0 Long Term Budget Adopted - electric revised 9-21-09 Electric 9/21/20093:57 PM