Benton PUD Credit Exposure by sector as of February 2g, zolg I Bank - - PowerPoint PPT Presentation
Benton PUD Credit Exposure by sector as of February 2g, zolg I Bank 52,458,490 I lntegrated Oil & Gas Companies 528,551 r IOU Affiliate S37,735 rou s33,10s I Marketer/Merchant $9,727 I Muni/Coop 5L25,25L RTO so s% 2o/o 9L% Benton's total
Benton PUD Credit Exposure by sector as of February 2g, zolg
I Bank 52,458,490
rou s33,10s
I Marketer/Merchant $9,727
RTO so
I lntegrated Oil & Gas Companies 528,551 r IOU Affiliate S37,735 I Muni/Coop 5L25,25L
s% 9L%
2o/o
Benton's total exposure (principal and agent) ¡s 52,692,959
Benton PUD credit Exposure by sector as of January gL,2otg
r Bank 57,660 r IOU AffiliateStlJtA
RTo $o
r lntegrated Oil & Gas Companies $0 r Marketer/Merchant $2,673,938
tou S9o,78o
r Muni/Coop SS6O,gqZ
tI%
3% L%
8s% Benton's total exposure (principal and agent) is 53,150,937
þleort Fqiåure Foct Sheel
Heorl foilure. olso colled Congestive HeorÍ Foiiure (CHF), hoppens when ihe heort
connot pump enough blood ond oxygen io support other orgons in your body. Heort
foilure is o serious condition, but it does noT meon Ihot the heort hos stopped beoting
Heort Fqilure in the United Stotes
. AbouT 5.7 million odults in the United Slotes
hove heorl foilure.
. One in I deqlhs includecl heort foilure os
conlributing couse.
. About holf of people who develop heort
foilure die within 5 yeors of diognosis.
. Heort foilure cosTs the noTion on esiimoted
$30.7 billion eoch yeor. This ioiol includes
the cosi of heollh core services, missed doys
Signs qnd Symplorns of l-leqrt Foilure
Heort Foilure Symploms
. Shortness of breoth during normol
exercising.
. Generolweokness ond fotigue. . Chest poin ond Heort polpilofions. . Unusuol blood pressure or heort rote . Foínting otiocks (syncope). . Edemo, {swelling) of feet, onkles,
lanc rvvJ.
. lightheqdedness ono oizziness.
Healthy Hearr ¿m¡
HÉflnn¡rda
pnçùtod
¡rFe úcuf¡h
¡ h..lürtùrt
Heart Faìlure
¡ul¡
nbHhllt
m¡gdraru
n¡¡r¡¡uffr
ôloodhÞt
¡r1¡thd
Dú|rlat
iðcrs|lûB
hhôlnlllütL
Heorl Fqilure Stotisfics
Approximotely 550,000 new coses
Heort foilure is responsible for 11 million physicion visits eoch yeor,
forms of concer combined. Sudden deqth is common in poTients wilh CHF, occurring oi o
rote of six to nine times Ihoi of the generol populotion.
a a
Prevent Heorl Foilure by Moinloining Heolthy Living Hqbit
lcfroosing heolfhy meol ond snock options con help you ovoid heort diseose ond its
lifestyle, you con help keep your blood pressure, cholesterol, ond sugor normol ond lower your risk for heort diseose ond heort oitock. A heollhy lifestyle includes the
following:
. MoinToining o heolthy weighl. . Getting enough physicol octivity. .
EoTing o heolthy diet including dork
chocolote, nuts, ond fish.
.
Limíiing sodium.
.
Limiting olcohol use.
'- rue n gæl natE zoNes
. Getting enough sleep. .
Brushíng your teeth.
. Getting regulor heolth screenings. . Not smoking or using other forms of
tobocco.
. Being your own besl odvocote!
Weor o F¡tb¡l or olher Heorl Rote Moniloring Device - lf could jusl sove your life!
tRÉsÍilc Hgtr urE
77 or.
56 mln 46 min
11 hr 52 mln CUSOM ZONEiÈj A ¡:;.i çç
! 10 À1,1,1¡ l:_
t*^.,ro,\t.þ' L'
EEilTOf
Business Agenda Second Reading Consent Agenda
I nfo On ly/P ossi b I e Acti o n
lnfo Only COMMISSION MEETING AGENDA ¡TEM
Motion for Commission Consideration: Motion approving the temporary suspension of lhe I% late fee assessed to the past due electric
balance and to allow L month's past due balance to be included in the budget plan calcufation
from March L2, 20tg to April 13, 2OL9.
Recommendation/Background The extreme cold weather in February and March caused customer usage to be up substantíally
from normal levels resulting in large increases in customer bills as compared to earlierthis wínter and to prior years. Customer Service staff will assist customers by establishing payment
arrangements for ionger than normal periods and by enrolling customers in the budget plan who do not have a zero balance on their electric account. Summarv The ability to establish longer than normal pay arrangements, set up the budget plan with one month's past due balance and waive late fees for a short period of time will help customers through this period of high bílls that resulted from the extreme cold temperatures.
Fiscal lmpact Subject:
Waiver of Late Fees and Adjustment of Budget plan Calculation Agenda ltem No: Meeting Date: March L2,2OL9 Presented by: Christie McAloon ¿rrt1 Staff Presenting ltem Approved by (dept)
Chad Bartram
Dírector/Manager Approved for
Commission review: Chad Bartram {yüdt General Manager/Asst GM The estimated fiscal impact for one month's late fees is approximately 520,000
FINANCIAL STATEMENTS
January 2019
(Unaudited)
Table of Contents
Monthly Financial Highlights Statement of Revenues, Expenses and Ghanges in Net Assets
Current Month
Comparative Balance Sheet Energy Statistical Data
Current Month kWh Sales - Monthly Activity Plant Additions and Retirements Current Month
Statement of Cash Flows Weather Statistics Broadband Summary
Paoe
4-5
7 -8 10
11
12 2 3
6
I
Payroll Report
13
.,d?,ll,0
lssile dare: 3,'1119
etIT{ilÍ
,
F in æn ci al r?:grft ffgf:fs
January 2019
Reta¡l Revênues
> January's tempêrature was 2.4 degrees above the s-year average and heating
degreê days were 89,/o below the five year average, reta¡l revenues were g percent below budget estimates in part to December and January þeing warmer than average.
> Rêtail revenues yearto date are 97o undêr budget amounts.
Net Power Expense
> Lower than normal water flow and snow pack in December 201 I and January 201 I
has resulted in decreased excess generation and decreased secondary market sales than budget estimates.
> Look¡ng forward, February had record snowfall for the region. > Net Power Expense was $6.9M for the year about $1 3Ok below budget.
Net Margin/Net lncome
> W¡th the warmer winter start Nel margin and net income are tracking below budgei
about $1 .1 M and $900k respectively. Capitel
> Capital expenditures forthe yearare $1.8M of the 918.1M budget.
O&M Expense
> January's O&M expense was $2.2M ot 2o/o above budget. > O&M Expenses were over the budget þy approximately g35k in part due to 60% of
the Dues and Assessments being paid in January.
Retail Revenues Net Power Expense
{sr.026i Over/(Under) Budget
YTD Januâry
i 6¡i(&
(51,s0Û)
Over/(Under! Budget (thousandsl
January YTIJ
r f51,æol
I
¡Net Power (NPC)
bs.r
I
w
fao
I Retäll Revenues
ñ¡et æf9 O4fi¡ú Buôd
{ilq.ro¡3l
hcome/Net Margín YTD Over/(Under) Budget
Net Posil¡on Net
(S8eo)
(s1,118)
, ($2,oool
(in thousands)
Føctors alfecting Reve n ues
Degree Days &
January HOD YTD HDD January Prec¡p YTÞ Precip
Billed toad Over/{Under} Budget {in aMW}
{25}
II
i
lre)
(19) YTD Jæuãry 33
r Budgêt S ¡ Avemge S
rÉ
So
Fdctors affectíng Net Power Expense
Water Flow Projection % of Normal Jan-Jut Runoff
87% ú% I Jan-rul Runoff Forecæt
Generation Budget (in aMWl
(1s) January (1s) (301 YTD Secondary Market Sales Over/{Under} Budget ($}
toty,
Januãry YTD Days Cash On Hand - Current Debt Service Coverage Fixed Charge Coverage
Active Service Locat¡ons YTD lncrease ln Servíce Locatíons New Serv¡ces 79 118 Other 54215
5%
rc%
4% 3%
2tEteeææeh¡lâmtdtu@
?ord{$l!,rfrÁ]
!ûn C.F.e&at0cf¡Sttç (t?.G,i
Olr¿ Curtdrlc €r.o{rtù {${"otrÁl OBL R€pâf/Rêpl@írc0t {Sz.¿nt}
lrm'¡tùrlonl9.7M) 8rdùô${t(91.0Mt Genc''l Plrñt (9t.2Ml
rlgl,M'
s rÍp
r.77M 0.61M 0.69M 0.11M
0.05M 0.06M
OM OM
O&M Expense before NESC Compliance and Cap¡tal Expenditures
Capltal
8%
2r% S37 537
152?3't
(Ssool ú/. 20% 40% 60%
YTD YTD January .lanua ry
2
80%
LOO/.
PUBLIC UTILITY DISTRICT I{O.1 OF BEI¡TON COUNTY STATEMENT OF REVEi¡UES, EXPEI{SES, AND CHAilGE IN NET POSITION JAI{UARY 2019
1t31t19
1t31t18 OPERATING REVEI{UES Energy Sales - Retail City Occupation Taxes Bad Debt Expense Energy Secondary Market Sales Transmission of Power for Others Broadband Revenue Other Revenue TOTAL OPERATIIIG REVENUES OPERATING EXPE]ISES Purchased Power Purchased Transmission & Ancillary Services Conservation Program Total Power Supply Transmission Operation & Maintenance D¡stribut¡on Operation & Maintenance Broadband Expense Customer Account¡ng, Collection & lnformat¡on Administrative & General Subtotal before NESC Compliance / Public Safety NESC Compliance (Net District Expense) Subtotal before Taxes & Depreciat¡on Taxes Depreciation & Amortization Total Other Operat¡ng Expenses TOTAL OPERATIÍ{G EXPEHSES
NOI{OPERATITIG REVETIUES & EXPEI{SES lnterest lncome Other lncome Other Expense lnterest Expense Debt DiscounlPremium Amortization & Loss on Defeased Debt MtM Gain(Loss) on lnvestments TOTAL I{OIìIOPERATII{G REVEI{UES & EXPEI{SES
¡¡tcoltrE (Loss) BEFoRE CAP|TAL COilTRIBUTIONS
CAPITAL COI¿TRIBUTIOIIS CHAHGE IN ]IET POSITIO]I 10,133,264 593,823 (18,000) 2,876,08'l 120,920 197,864
572,7'14 11,159,142 683,400 (24,549\ 2,117,909 75,000 190,930 527,986 10,476,299 645,112
(1 9,000)
2,013,000 140,137 188,237
603,1 53
43o/o
5%
3o/o
360/o 61o/o
4% 8%
2,136,853 28,13',| 2,084,316 43,814 14,476,665 8,553,731 1,271,434 89,773 1,1,729,819 7,989,671 1,147,747 103,056 l¡t,046,938 6,997,524
1 ,110,17 195,599 22%
15o/o
21%
3o/o '8o/o
37%
3o/o
4%
12% J9o/o 64%
7o/o
nla
9,914,937 4,214 862,821 62,443 383,229 824,147 9,240,473 8,824 897,236 48,389 344,015 785,852 7%
1 1o/o7%
29o/o
11% 5% 3%
2%
1o/o
924/o
0%
nla
'60/o
nla
8,203,294 5,734 835,848 67,753 410,400 953,338 2,273,073 20,599 2,164,984 1,266,090 835,933 2,128,131 1,379,903 848,079 2,293,672 1,346,727 813,688 4,267,007 4,356,112 4.454.087 1{,181,944 291,721 13,596,586 1,133,233 58,310 31,339 (209,646) 37,647 111,824 31,355
(1 97,1 51 )
34,318 14,638 12,657,381 r,389,557 68,157 29,299 (235,205) 38,'t27 (27,135) (5,016) (82,350) (126,7571 289,705 25,092 1,050,884 381,957 r,262,800 293,142
1,555,542 -80%
314,797 1,432,841
PAGE 3 UNAUDITED STATEMENTS
ASSETS CURRENT ASSETS Cash & Cash Equivalents Unrestrlcted Cash & Cash Equivalenls Restricted Construction Account lnvestments Designated Debt Service Resêrve Fund Designated Power Market Voltly Des¡gnated Special Cap¡tal Rsv Designated Customer Depos¡ts Accounts Rece¡vaþle, net BPA Prep¿y Rece¡v¿Þle Accrued lnterest Receivaþle Wholesale Power Rece¡vable Accrued Unbilled Revenue lnventory Materials & Supplies Prepaid Expenses & Option Prem¡ums Total Current AsseG NONCURRENT ASSElS Restricted Bond Resêrve Fund Other Rece¡vables Prel¡m¡nary Surveys BPA Prepay Rece¡vable Defened Purchased Power Costs Utility Plant Land and lntang¡ble Plant Electric Plant ¡n Service Construc{¡on Work in Progress Accumulated Depreciation Net Utility Plant Total Noncurrent Assets Total Assets DEFERRED OUTFLOWS OF RESOURCES Unamortized Loss on Defeased Debt Pension Defened Outflow Accumulated Decrease in Fair Value of Hedging Derivat¡ves Totel Deferred Outfloìftr of Resources TOTAL ASSETS & DEFERRED OUTFLOWS OF RESOURCES PUBLIC UTILITY DISTRICT NO. 1 OF BENTON COUNTY COMPARATIVE STATEMENT OF NET POSITION ASSETS AND DEFERRED OUTFLOWS OF RESOURCES 26,078,554 10,668,1 1 5 2,612,152 3,850,000 12,511,793 1,600,000 9,355,67'1 000,000
181 ,517
1,699,439 4,500,000 5,674,743 353,585 22,77O J.A8 $3,308,386 (1,948,410) 550,000 (1,596,823) 200,000 776,043 12,616,525 2,612,152 3,300,000 14,108,616 1,400,000 8,579,628 000,000 59,654
1,407 ,401
4,800,000 5,544,372 491,064 121,863 292,038 (300,000) 130,371 (137,479\ 79,685,569
't ,107,865163,01 1
1 25,8555,250,000 7,697,002 78,289,580 1,107,865 96,778 ô4,007 5,850,000 6,877.223 1,395,989
2Yo66,233 6r,848 (600,000) 819 779 947,859
2o/o14,343,732 3,531,699 318,902,897 6,911,759 (197,',t48.520\ 13,995,873 3,493,642 305,931,424 4,599,287 (188.357.607) 38,057 't2,971,473 2,312,472 (8,790,91 3)
132,1 97,835
125,666,746 6,531,089 5%
5o/o 4o/o146,541,567 226,227,136 2'.t7,952,'.t99 1,429,022 8,274,937 (24rì,515) 3,6¿18,154 3,399,639 11.674.576 6,878.948 1,180,507 4,770,99A
5,951,503 232,175,639 2,551,864 220,504,063 5% PAGE 4
UNAUDITED STATEMENTS
rr3 rr¿û18
USlttzol'
I rì creås er{ ÞecreaselAmóunt
Pêrcênl
LIABILITIES CURRENT LIABILITIES Wanants Outstanding Accounts Payable Cuslomer Deposts Accrued Taxes Payable Other Cunent & Accrued L¡abilit¡es Accrued lnterest Payable Revenue Bonds, Cunent Portion Totel Current L¡âbilities NONCURRENT LIABILITIES 2010 Bond lssue 201 1 Bond lssue 2016 Bond lssue Unamort¡zed Prem¡um & Discount Pens¡on Liabil¡ty Defened Revenue BPA Prepay lncentive Credit Other Liab¡lities Total Noncurrent L¡aþ¡l¡tiês Total Liab¡llties DEFERRED INFLOWS OF RESOURCES Unamortized Gain on Defeased Debt Pèns¡on Delened lnflow .Accumulated lncrease in Fa¡r Value of Hedg¡ng Dêrivat¡ves Total Defêrred lnfloì¡rrs of Resources NET POSITION Net lnvestment ¡n Capital Assets Restricted for Ðebt Service Unrestricted Total Nât Position TOTAL NET POSITION, LIABILITIES AND DEFERRED INFLOWS OF RESOURCES CURRENT RATIO: (Current Assets / Current Líab¡lit¡es) WORKING CAPITAL: (Current Assets less Current L¡ab¡llt¡es) PUBLIC UTILITY DISTRICT NO. 1 OF BENTON COUNTY COMPARATIVE STATEMENT OF NET POSITION LIABILITIES AND DEFERRED INFLOWS OF RESOURCES
1 l,460,8392,035,979 3,666,006 2,783,539 461,914 3,750,000 24,158,277 9,922,995 1,667,840 3,652,729
1 ,569,510491,664 3,570,000 $0 1,5ir7,844 368,139 13,277 1,214,029 (29,750) 180,000 17,345,000 9,770,000 22,470,000 3,869,778 6,852,561 1,504,549 1,572,277 5,236,050 20,874,738 17,345,000 16,565,000 19,425,000 4,336,311 9,884,887 473,595 1,733,533 2,685,029
3,283,539
160/o(6,795,000) 3,045,000 (466,534) (3,032,326) 't,030,954 (161,256) 2,551,021 68,620,2',t4 72,448,355 (78,1411
92,778,491 31,212 2,930,226 2,539,134 93,323,093 3,205,398 18,389 1,866,603 1,140,955 12,823 1,063,623
1 ,398,1 795,500,572 3,025,947
2,474,625 82%
74,961,846
1,1 07,86557,829,865 64,407,045 1,107,865 58,640,1 1 3
1 0,554,801(810,248',) 133,899,576 124,165,023 220,504.063 9,744,553
8o/o't1,674,il6
5o/o232,178,6t9
3.3O: l 55,527,292
PAGE 5 UNAUDITED STATEMENTS 3.75:1 ç57,414,842
(s1,887,550) -3o/o
lFcrêase4Dsúeasê) 1t3lr2A19 1tslru018 Amounl Fercent
PUBLIC UTILITY DISTRICT NO. I OF BENTON COUNTY ENERGY STATISTICAL DATA CURRENT MONTH
1t3lnug
1t31t2018 ENERGY SALES RETAIL. REVENUE Resident¡al Small General Serv¡ce Medium Generãl Seruice Large General Serv¡ce Largê lndustrial Small lnigation Large lnigat¡on Street Lights Security Lights Unmetered Accounts B¡lled Revenues Before Taxês & Unbilled Revenue Unb¡lled Revenue Energy Sales Retail Subtotal Cily Occupation Taxos Bad Debt Expense (o.t67o of reraìt sates) TOT/qL SALES - REVENUE ENERGY SALES RETAIL - KWh Residentiaf Small General Service Medium General Serv¡c€ Laige General Service Largè lndustrial Small lnigation Large lffigation Street L¡ghls Security L¡ghts Unmetered Accounts TOTAL KWh BILLED NET POWER COST BPA Power Costs Sl¡ce Block Subtotal Other Power Purchãses Frederickson Transm¡ss¡on Ancillary Conservation Program Gross Pourer Costs Less Secondary Market Sales-Energy Less Secondary Market Sales-Gas Less Transm¡ss¡on of Power for Olhers NET POWER COSTS NET POWER - KWh BPA PoWeT Slice Block Subtotal Other Power Purchases Frederickson Gross Power kwh Less Secondary Market Sales Less Transm¡ssion Losses/lmþalance NET POWER - KWh COST PER MWh: {dollars) Gross Power Cost (average) Net Power Cost BPA Power Cost Secondary Market Sales ACTIVE SERVICE LOCATIONS: Residential Small General Service Medium General Service Large Generaf Service Large lndustrial Small lnigation Large lnigat¡on Street Lights Security L¡ghts Unmetered Accounts TOTAL
16,608
17,210
$10,233,263
$11,259,142
(100,000)
(100,000)
$10,133,2ô3
$11,159,142
593,823
683,400
167,259,000 224.8
8,285,000 11.1 37,200,000 50.0
178,225,308 24,523,883 37,200,000 7,311,763 878,014
1, I 66,9551.235,770 305,125 6,839
1 14,38017,792 22,526 lô,535 $11,076,299 (600,000) $10,476,299 645,112
(1 9,000) $1 1,102,41 l90,521,067 12,129,652 '16,103,016
p,110,860
5,995,840 50,526 233,165 2'11,046 85,112 242,804
___lgÉË,q!g_
2,905,797 2,ô46,735 5,552,532 634,913 810,080 913,685 19ô,480 95,598 8,203,294 (1,972,390) (40,610) (140,137) $ô,050,157
1 14,914,00078,568,000 193,482,000 16,792,000 4.800.000 215,074,000 (77,766,000) (2,653,000)
_].g$!qpgq_
$38.14
$¿14.93
$28.70 $25.36 6,597,062 832,063 1,131,401 1,211,889 280,534 7,389
1 1 6,699 1 7,83321,7A5 80,765,201 11,410,702 15,483,483 18,581,986 5,349,,140 64,108 292,485 211,760
82¿U
$7 ,597,743
872,969 1,176,150
1,1 39,570296,692 3,O24
1 13,85717,810 24,'t17 94,354,312 't1,979,544 16,268,420
17 ,477,6115,785,523 6 279,121 212,039 95,756 97,998,595 80,230,713 aMW 126.8
'16.1
21.9 23.5 7.8 0,0 0.4 0.3 0.'t 0.3 197.2
40/o
60/o144o/o 2o/o 0o/o
>200o/o 5o/o 0o/o
4%
1o/¡ AMW 108.6 15.3 20.8 25.0 7.2 0.1 0.4 0.3 0.1 AMW '121.7 '16.3 21.6 25.7 8.1 0.1 0.3 0.3 0.1 0.3 194.5
4o/o
ao/" $2,905,797 $2,938,702
2,692,124
2,659,131
5,597,921
5,597,893
1,125,222
957,628
1,830,588
1,434,150
931,623
930,774
339,81'1
216,973
89,772
103,056
9,914,937
9,240,474
' (2,362,101)
(2,117,e09)
(51 3,980)
1%
Oo/o 18o/o 28o/o 0o/o 57o/onla
61o/o 0o/o 2o/o 1o/o 77o/o 1260/o 2o/o 73o/o21Vo 29o/o >2O00/o
14%
675o/o
3% 87,028,000 80,231,000
_s%
21o/o 8o/o7%
3OVo44,212 4,915 782 160 5 545 434 9 1,927 45,O20 4,998 817 164 5 527 434 9 1,871 AMW 117.0 107.8 AMW 131.7 't07.8 239.6 33.0 50.0 322.5 (112.0) (4 4) 206.2 AMW 154.5 105.ô 260.1 22.6 6.5 289.1 (104.5) (3 6) 181.0
212,744,000 285.9 (71,403,000) (96.0)
$4ô.01 $49.71 $33.47 $33.08 239,953,191 (83,315,624) $38.51 $45.95 $31.41 $25.42
22o/o 1 1o/o 17o/o 30o/o381 53,370 370
54,215
2o/o 2o/o 4o/o 3o/o Oo/o0%
PUBLIC UÍITIIY DISTRICT NO. 1OF BENTON COU'{TY K\A'H SATES MONTHTY ACfIVITY Residential 2015 20L6
20t7
2018 2019 large lrr¡tat¡on 2015 2016
20t7 2018 20t9
8r.,753,251 89,934,474 rL4,O89,923 90,52L,667 80,765,20r 2L4,532 22t,3L2 200,892 233,165 292,485 70,442,807 72,255,O49
97 A73,618
69,963,306 L0,444,066 10,6L5,824 12,?26,759 10.600,544 15,058,182 L5,r29,40L 15,406,899 14,4L2,773 17,2L2,717 r7,545,844 17,299,489
r4344,67L
5,394,485 5306,745 5,319,830 5,L58,240 2L0,554 379,r79 229,629 494,L43 5L,r95,At7 53,460,88r. 72,629,O78 64,L97,600 8,399,963 8,804253
rL375,2L9 9,492,590 13,r24,396
12,982,308 15,083,L30 L3,220,L77 16,213,065 t6,492,t2O 18,5L0,883 L7,025,842 5,337,36s 5,715,980 5,953,160 s,695,840 64&290 469,477 277,7rO t43,492 14,636,633 9,247,984 1,48s,633 10 909,657 43,964,172 45,886,799 50,897,608 51,994,462 8,630,563 9,O93,5t7 8,459,581 9,262,432 13,6tL,242 13,939,681 r-3,9s3,993 13,836,653 t7,278,L83 17360,382 !7,69L,O33
t8,279,97t
5,784,330 5,547,L75 5,959,920 5,195,640 r,48L,286 L,607,439 434,743 846,581 39,362,24? 45,29t,455 17,886,279 22,783,855 38,845.198 38,72L,34L 40,454,502 4L,t72,298 9,005,788 9,217,5t4 8,910,557 9,403,579 14078,883 L3,879,726 14,157,015 L4,453,2t8 17,939,803 L7,543,712 L8,24r,93L t9,678,642 5,632,340 4,L92.,375 4,342,280 4,L57,84O 2,L59,6!6 2,203,347 1.,70L,606 2,t85,730 6L,259,905 66,290,382 54,086,389 64,616,LBO 48,995,659 44,464,304 45,Ot4,248 46,005,694 10,616,996 LO,063,7L7 10,148,595 to,408,132 L5,970,93r rA,686,797 15,250,364 L5,432,469 1.9,595,384 r8,140,663 18,951,19L 19,988,535 5,678,570 5,666,470 5,566,080 5,739,O40 2,668,782 2,637,887 2,505,109 2,676,495 r03,842,869 88,901,499 93,753,828 86,922,O59 62,7sO,OOA 49,566,548 5s,425,63L
52,40t,79t
L2,060,700 r0,760,436 Lr,42L,880 1!.,068,455 r6,9s7,563 L5,578,70O 1s,663,861 16,006,913 20,93s,183 18,545 919 20,5L!,714 20,624,407 4,981,620
5,704¡40
5,565,400 5,964,840 3,213,086 2,835,670 3,r47,673 3,295,476 98,850,190 88,434390 103,188,520 1o2,L95,462 s4,699,674 57,564,364 62,752,408 63,97L,768 11,955,370 r.r.,863,20r" t2,o37,978 12,734,593 t6,576,440 t 6,516,307 L7,906,763 L7,702,795 48,136,350 49,472,576 53,038,585 48,s45,386 10,809,845 10,8397s9
Lr3i7,363
L0,9L2,920 t5,990,572 16,093,629 16,509,954 t6,o75,867 37,850,!54 38,810,551 40,359,813 39,430,056 9,065,t97 9,285,276 9,027,734 8908,327 L5,576,754 15,538,491
14,75r,4U
15,031,084 20,558,020 21,179,401 20,501,084 21,494,L26 5,598,540 s,998,320 5,962,760 5,976,320 L,172É02 889,198 928,403 858,769 24,467,386 L4,740,237 18,r.36 316 t6,382,998 46,905,821 46,586,æ4 54,793,496 53,123,365 8,719,747 8,652,183 9,272,759 9,19L,224 L4,732,964 L4,7r1,r27
t5,o37,r20 \5,499,978 t8,687,460
19,3r.4538 L9,370,204 20,269,tzL 5,408,760 s,625,690 s,314800 5,498,240 2,846 t23,750 L24,L27 3,4L4,78L 2,O22,639 2,542,79t 3,048,545 75,565,855 75,018,157 72,704,997 75,779,7]-5 10,515,898 ].0,807,220 10,819,539 LO,j5L,929 t5,2L3,O04 15,377,852 t5,264,344 L5,349,864
!7,8t9,400
18,495,41,5 18,503,509 18,870,090 s,732,865 4,774,520 6,L54,920 5,724,800 4 43,802 46,345 2t4,LOg 238,007 281,800
268,7t3 665,504,766 661,74L,688 759,633,907 697,107,t08 80,76s,20L !21,497,780 121,868,245 129,054,006 t24,864,377 1r,470,702 1A2,6tO,322 t80,466,703 186,155,255 t83,t24,807 15,483,483 226,174,929 223,267,9t9 230,674,409
238,606,OL7 18,581,986 66,941,885
64,6!2,25r 67,084,t10 65,996,720 5,349,440 t6,424,664 t5,s97,288
ß,7s4354
15,311,533 64,L08 45r,777,178 419,588,399 392,050,824 409,298,945 292,485 Small General Service
2015
1L,273,647
20L6
11,865,345
2017
13,896,042
2018
L2,L29,6s2
2019
LL,4LO,702 Medium General Seru¡ce
2015
t5,7L9,99L
2016
t6,O32,6U
2or7
L7,t70,328
2018
16,103,016
2019
L5,483,483 Large General seruice
2015
r.7,888,911
2016
18,188,600
2Ot7
18,624018
2018
19,110,860
2Ot9
L&58L,986 Large lndustrial
2015
5,597,495
20L6
s,743,306
2077
5,118,880
2018
5,99s,840
2OL9
5,349,440 Small lrrigation 20!.5 2016 2017 2018 2019 64,108 9 L81 20,74!,663 20,497,27t 2r,497,993 23,332,3L6 6,L7L,695 5,908,980 6,O72,640 5,536,080 3,002,663 2,948,608 2,78L,753 2,9t6,373 67,47t,M5 70,085,659 70,975,OOt 68,988,554 2L,305,740 19,923,658 20,970,960 2r.,583,396 5,623,820 4,427,850 5,753,440 s,3s3,960 2,O75,784 2,OO5,457 1,809,769 2,t33,a36 37,832,472 33,73s,6s6 29,243,746 32,455,614 20
(41
32,983 50,526 PAGE 7
PUBLIC UTILITY DISTRICT NO. 1 OF BENTOT{ COUNTY KWH SALES MONTHI.Y ACTIVITY
Street L¡ghts 2015 2016 20L7 2018 2019 Security L¡ghts 2015 2016 20t7 2018 20t9 225,624 ?'25,024
2úp49 2tl,046 2tt,760
Lt4,45L 7t3,273 100,963 85,112 82,454 249,LO6 257,O45 253,91s 242,8U 245,945 133,037,008 142,581,083 169,666,306 f.¿9,683,688 L32,487,564 225,624 224,878 2LL,253 2tI,337 L14,408 113,196 100,920 90,490 249,LO6 257,O45 253,9L5 254,823 119,751,958 LZL,&Z7,338 t48,622,7t2 119,563,3L0 225,624 224,878 zrL,253
21,L,343
tl4,o73
113,239 91,650 90,!44 249,LO6 257,O45 253,715 255,332
tro,L44,332
107,768,165
t25,47L,43! !2L,242,4t7
275,672 724,494
2!r,253 2Lt,310
113,696 113,180 91,545 89,927 248,9r9 257,O45 253,7rs 255,33? 130 700,305 r39,32L,t67 115,839,710 r22,756,L63 225,672 2LI,235 zLr,253
2tt,3to
113,531 LOr382 9!,424 85,656 248,9!9 257,O45 253,715 245,684 149,509,655 15¿658,059 L42,450,672 Ls6,2rO,t77 725,672
2tt,!87
2rr,253 2L!,3tO
113,¿188
tor,125
91,134 849s3 244,9t9 257,O45 253,7L5 245,6A4 207,957,270 185,130,994
r9\745,5L7
L87,7L4,771 224,880
21t,I87 2r!,253 ztt,3LO
113,488 101,382 90,782 84,383 24A,9t9 258,34L 253,715
24s,6U
220,335,637
t9t,997,4L3
2L5,480,429 2L2,O98,72r 224,8A0
2Lt,t87 2rr,253 2!1,634 t!3,445
101,409 90,860 44,206 254,930 ?s9,637 253,715 245,745 L85,212,205 185,956,623 194s80,364 L95,724,064 224,928 2!7,L87 2rL,253 211,650
tt3,402
101,366 90,8s0 83,947 254,845 259,637 253,715 245,945 L42,367,1s8 137,O70,775 r39,239,635 137,602,515 225,024
ztt,t87
27L,238 ztL,64Ð 113,359 LOr,!94 90,827 83,334 255,749 2s436s 251,7L5 245,945 114881,885 to7,008,620 Lt0,223,374 108,626,599
22t024
2U"349
2r\r2s
271,640 113,3s9 101.108 90,504
84782
257,445 25436s 253"926 241945 98,467,807 97,479,643 r07,050',475 to7,295,OO7 225,024 21t,349 21t,046 21,r,75L 113,309 101,108 90,659 82,68L 257,O45 254,365 252,929 245,945 125,656,s09 L25,277,997 124,327,545 127,33L,833 2,703,648 2,589,L42 2,534,782 2,537,28L
2rt,760 1,364009 r,263,262
1,112,118 r,o27,609 82,4s4 3,022,608 3,082,980 3,O44,405 2,974,868 245,945 L,738,021,729 L,694,O77,A77 t,785,O98,L70 r,740.849,265 L32,4A7,564 Unmetered 2015 2016
20t7
2018
20t9 Total
2015 20L6 20L7 2018 2019 PAGE 8
PUBL¡C UTILITY DISTRICT NO.1 OF BENTON COUNTY CAPITAL ADDITIONS AND RETIREMENTS YEARTO DATE
ADDITIONS RETIREMENîS
BALÂNCE 12t31t2018 BALANCE 1U31r2017 INTANGIBLE PLANT: Organizations Franchises & Consents Miscellaneous & lntangible Plant TOTAL GENERATION PLANT: Land & Land R¡ghts Structures & lmprovements Fuel Holders & Accessories Other Electric Generation Accessory Electric Equipment Miscellaneous Power Plant Equipment TOTAL TRAT{SMISSION PLANT: Land & Land Rights Clearing Land & Right Of Ways Transmission Station Equipment Towers & Fixtures Poles & Fixtures Overhead Conductor & Devices TOTAL DISTRIBUTIOH PLANT: Land & Land Rights Structures & lmprovements Station Equipment Poles, Towers & Fixtures Overhead Conductor & Devices Underground Conduit Underground Conductor & Devices Line Transformers Services-Overhead Services-Underground Meters Security Lighting Street Lighting SCADA System TOTAL GENERAL PLAI.IT: Land & Land Rights Structures & lmprovements lnformation Systems & Technology Transportation Equipment Stores Equipment Tools, Shop & Garage Equipment Laboratory Equipment Communication Equipment Broadband Equipment Miscellaneous Equipment Other Capitalized Costs TOTAL TOTAL ELECTRIC PLANT ACCOUNTS PLANT HELD FOR FUTURE USE CONSTRUCTION WORK IN PROGRESS
234,220,945 435,071
(8,025) 234,647,991
1 ,130,759
18,739,895 9,427,330 8,382,054 54,1 08 487,239 489,13s 2,540,624 21,675,471 1,141,835
11
(8,025) 322,700,863
I,017,248 $28,379 10,022
29 078 $67 1,141,911 770,459 $o $o $28,379 10,022 29 078 67,479
1 ,141,911770,459 1,912,370 156,400 25,544 832,047 256,175 4,998,452 4,050,057 1,912,370 156,400 25,544 832,047 256,175 4,998,452 4,0s0,057 10,318,675 1,762,927 295,502 40,769,313 21,406,319 13,896,486 37,654,846 48,493,868 31,837,633 2,934,219 20,638,007 10,412,170 867,764 781,212 2,470,679 1,406 29,504 215 54,971 133,762 132,624 8,853 66,670 6,745 321 (4,801) (1,386) (635) (1,203) 10,318,675 1,764,333 295,502 40,769,313 21,431,022 13,896,701 37,708,431 48,626,99s 31,970,257 2,943,072 20,704,677 10,418,915 866,882 781,212 2,470,679 't,130,759 18,739,895 9,288,292 8,347,206 54,'t08 487,239 489,135 2,528,661 21,657,090 1,141,835
11
14 7
322,046,003 662,885
388,589
6,911 ,759
1,105,489 139,038 34,848 11,963 18,381
329,346,351 1,768,374
$2,040,936 Budset TOTÀL CAPITAL
PAGE 9
($8,025) $331,r06,700
PUBLIC UTILITY DISTRICT NO. f OF BENTOI¡ COUNTY STATEMENT OF CASH FLOWS
YT.f) 1t31t2ø19
CASH FLOWS FROM OPERATING ACTIV¡TIES Cash Received from Customers and Counterparties Cash Paid to Suppliers and Counterparties Cash Paid to Employees Taxes Paid Net Cash Provided by Operating Activities CASH FLOWS FROi,I NOI{CAPITAL FINANCING ACTIVITIES Other lnterest Expense Net Cash Provided by Noncapital Financing Activities CASH FLOWS FROTI CAPITAL AND RELATED F¡NANCING ACTIVIT¡ES Acquisition of Capital Assets Proceeds from Sale of Revenue Bonds Reimbursement of Bond Expense Bond Principal Paid Bond lnterest Paid Capital Contributions Sale of Assets Ì{et Cash (Used) by Gapital and Related Financing Activities CASH FLOWS FROilI IilVESTING ACTIVITIES lnterest lncome Proceeds from Sale of lnvestments Purchase of lnvestments Joint Venture Net Revenue (Expense)
ìlet Gash Provided by Investing Activities
NET D{GREASE (DECREASE) h¡ CÀSH CASH BALANCE, BEGIilNII{G CASH BALAIICE, E¡IDI]I¡G RECOI{CILIATIOII OF I{ET OPÊRATIT{G IIICOTUIE TO NET CASH PROVIDED BY OPERATII{G ACTIVITIES Net Operating Revenues Adjustments to reconcile net operating income to net cash proüided by operating activities: Depreciation & Amortization Unbilled Revenues Misellaneous Other Revenue & Receipts GASB 68 Pension Expense Decrease (lncrease) in Accounts Receivable Decrease (lncrease) in BPA Prepay Receivable Decrease (lncrease) in lnventories Decrease (lncrease) in Prepaid Expenses Decrease (lncrease) in Wholesale Power Receivable Decrease (lncrease) in Miscellaneous Assets Decrease (lncrease) in Prepaid Expenses and Other Charges Decrêase (lncrease) in Deferred Derivative Outflows lncrease (Decrease) in Deferred Derivative lnflows lncrease (Decrease) in Warrants Outstanding lncrease (Decrease) in Accounts Payable lncrease (Decrease) in Accrued Taxes Payable lncrease (Decrease) in Customer Deposits lncrease (Decrease) in BPA Prepay lncentive Credit lncrease (Decrease) in Other Current Liabílities lncrease (Decrease) in Other Credits $14,992,6s1 794,673 (14,330,905) (986,944) 469,475
14,222 10,222 (1,734,583)
25,092 10,356 (l,699,135) 99,299 99,299 (1,r20,139)
$294,721 835,933 100,000 16 415,986 50,000 4,384 (159,995) (558,915) (e71) 572,719 760,511 (524,518) (555,282) 279,146 (5,896) (13,438) 37,460 (1,062,386) $469,475 Net Gash Provided by Operating Activities
PAGE 1O
E¡Normal ø2019 !2018 i*
80 70 60
850 940
gt3
'10
Jan
Feb March April May June July Aug Sept Oct Nov
Dec
Average Temperaturc
Year Jan Feb
tarch
Apr¡l
llay
June July Aug Sept Oct Irlov Dec Annual Historical Avg 33.4 53.9 2019
35.1 35.1 2018 37.7 37.7 s-yr Avg 32.7 32.7
PUBLIC UTILITYDISTRICT NO. 1 OF BET{TON COUNTY WEATHER STATÍSTICS January 31, 2019
Precipitation
Year Jan Feb
tlarch April
May June July Aug Sept Oct Hov Dec Annual Historical Avg 0.s4 0.94 2019
1.17 1.17 2018 1.10 1.10 5-yr Avg 1.01 1.01
Cooling Degree Days (CDDs) for Each Day of Bílling Gycle
700 600 500 400 300 200 100
Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan
':: 'J .r ;i1,
,\:
.,r ,
.'i"i:i}¡
Each point on th¡s graph represents the total number of CDDS for the preceding
3$day period, i.e.,lhe cumulative CDDS that are b¡lled on November 15 occuned between Oclober 15 - Novemþer 14.
;'
''4
'-.
ñr4
Cooling Degreo Days by lllonth
Year
Jan Fcb ftarch April f,lay June July Aug Sept Oct
tov
Dec Totel
201 I 201 B
5-yr Avg
Cumulat¡ve CDD8 in E¡ll¡n
2019 2018
S-yr Avg
5-Yr Avg 1,400 1,200 1,000 800 600 400 200
Heating Degrce Days (HDDs) for Each Day of Billing Cycle
Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Jan
Year Jan Feb
tarch
Apr¡l
ilay
June July Auq Sept Oct Nov Dec Total 2019 923 923 20't8 843
843 5-yr Avq 1,001 1,001
Cumulat¡ve HDD9 ¡n B¡ll¡n
2019 27,518 27,518
201 I
31,408 31,408 5-yr Avg 32,971 32,971
PAGE 11
PUBLIC UTILITY DIS¡TRICT NO. 1 OF BENTON COUNTY BROAOBAND SUMMARY
January Hîghlights There were two new Access lntemet connections and three new Ethernet Transport customers.
lncept¡on to Oate 20,8s1,429 11,640,112 rt-¿39 301
23 07S 7{3 12,228,2841 {6,617,759} 4,951,503 2,2E2,671_1L911999t
s3,159.092 137,407 t3,296199 ¡2ir,100,f9|t (s9,951,498) 2019 Bcdset Jan Fêb Mårch
tudt
kv June
AClUALS
July Aug$t
Sept Oct Nov Dæ Y1Ð Budget Vafiance REVENUES Elhemet Non-Recuring Charges - Ethernet TDM Wireless lnternet Transport Service
F¡xed W¡relessA@ss lnleftet
Non-Reourring Charges - Al Brcadband Revenue - other Subtotal 1,480,953 $124,122 1,500 3,000 26 3,112 3,t41 17,619 750
$124j22
1,500 3,000 26 3,112 3,141 17,ô19 750 t,356.831 36,000 300 54,000 42,OOO 250,000 33,0û0 271 50,888 38,859232,3t1 (750)
2,413,253 197,864
197,864 Maintenance Revenue Total OpeÊt¡ng Revenues
2,413,253 197.664
$197,864 2,215,38t'
TING EXPENSES General Expenses Other Ma¡ntenanæ NOC Ma¡ntenance 61,407 1,036 $6'1,407 $1,036 Subtotâl Maintenance Expense
948,000 62,443
$62,443 885,55/ Total Openl¡ng Expenæs
690,06E 69,054
$69,054 Ê21,011 REVENUES & EXPENSES lntemål lnterest due to Power Business Unit(1)
(33¿s32) (27,465)
($27,465)
305,06? CONTRIBUfIONS ContriÞutions in Aid of Broadband BTOP 1,3E0 $1,380 't,380
cosïs
MmbeEfiip Support
cåpflÂt E¡PÊr[o¡Tt Res
NET CASH (TOYFROM BROADEAND{,)
¡t '3É13'¡ßt4
61 fi,799 $5?,218 $83,677 852,218 $83,677$t,301,r3
128,1z1 (1) lntemalinterestbudgetisest¡matedbasedoncashflowp@ject¡ons(an¡nterestrateofS.53To¡sbeingused). (2) Includes excess of revenues over opeGt¡ng @sts, €p¡tal expendilures and NoaNet assessments; excludes depreciation and ¡ntemal ìnterest to Electric System
PAGE 12 üF*'7'#tr
';F.II.TT
Payroll Report
Pay Period Ending January 20, 2019
lbdcounl
Directorate Department
2019 Budqet 2019 Actual 9ver (Under) Actual to Budqêt Executive Adm¡nistration General Manager Human Resources Communications & Govemmental Affa¡rs 4.00 4.00 2.00 4.00 4.00 2.00 Customer Programs & Services Customer Service Prosser Customer Service
i e.oo
r 8.00
4.00 (1.00) 4.00 Finance & Business Services D¡rector of F¡nance Treasury & R¡sk Management Accounting Contracts & Purchasing 2.00 3.00 6.00 3.00 2.00 3.00 6.00 3.00 Engineering Englneering Customer Eng¡neering Power Management Energy Programs 6.00 9.00 4.00 7.00 6.00 9.00 3.00 7.00 (1.00) Operations Operations
Meter Shop Transformer Shop Automotive Shop Warehouse 6.00 33.00 2.00 5.00 6.00 4.00 7.00 6.00 31.00 2.00 5.00 6.00 4.00 7.00 (2.00) lnformation Technology lT lnfrastructure lT Applications
fdffir"
7 00 00 7.00
1 1.00rÊt
1 1{ll¡
Conti Positions
2019 Actual YTD 1t20t2019 Hours Position DeDartment 2019
Budoet
% YTD to
Budoet NECA Lineman/Meterman Summer lntern lntern CSR On-Call/LA - Prosser CSR On-Call - Kennewick Operations Engineering
IT Prosser Branch Customer Serv¡ce 118 53 8
B
224
121
B1
72 7%
0o/o 4o/o 3o/o
3,120 2.600 520 2,080 Totaf All Coñt¡ndêôt Posiüons 8.320 186
498
6o/o
Cônlinoênt YTD Full Tìme Ëouivalents IFTEI
4.00 4.24
2019 Labor
8.3% through the year
As of 1/31/2019 YTD Actual 2019
914,123,697 $1,188,617
8.4o/o
10.2% Regular 688 517 70 150 Less: M Aid Oovertime lAll Paid Lave' lRegu¡ar
t.aÁ
1,19t
'lOOo/o 75o/oAnnual 2018
50o/o8.5%
1t20t19 Pay Period Énd¡ng YTD 2019
25o/o a All Paid Leave includes personal leave, holidays, shortterm disability, L&1,jury duty pay, and military leave ptry. PAGE 13