SEASONAL CAPACITY BErr0tPRODUCT CONTRACT

JANUARY t4,2020

Staff Recommendat¡on

Þ Contract with Morgan Stanley Capital Group lnc. (MSCG) topurchase a seasonal capacity product for:

> 75MW heavy load hours (HLH) JulylAugust> 25MW HLH December{anuarylFebruary

Þ Term: December 2022 through August 2025

2

Recom mendat¡on Bacl

Recommendat¡on Bacl

Recom mendat¡on Bacl

Recom mendation Bacl

IPrici g and Annual Cost

Þ Capacity Charge:

Þ Energy Charge:

peak lndex + $0.70

Þ Term

, through August 2025

Seasonal Capacity ProductAnnual Cost

$7

TM

$ 1,000

-9oooØ

$e00

$800

$700

$600

$s00$400

$300

$200

$ r00

$-2022 2023 2024 2025

r Capacity Charge I lncremental Energy Charge*

Total Cost Range: $2.53M to $2.73M

$844 $844$7s0

Remaining average annual net cost: $4.2 million

=g 7.00 per kW month (12 months)=$ 17.00 per kW month (5 months)

*lncremental Energy Charge is the $0.70 premium to market price for the energy as part of the proposed contract 7

Add itional Contract Attri butes> Addresses physical risk only

Þ Available to dispatch when power is not available in the market or market is tight> Unspecified resource purchase

Þ ldentified as resource within Grant PUDs Balancing Authority Area (BAA)Þ No environmental attributes associated with powe[ even if carbon free generation

Þ Resource Adequacy (RA) languageÞ Added language to assist with complying with potential future RA voluntary standard

To the exteflt a resource o,r capacity obligaúon is defined in thePacific Northr¡nst region by a regulatorl'or industry body- such as the

i f^mnC¡WgCC or the Northwest Porver Pool (NWPÞ)= Seller sh¡lf upoaany request from. h¡rcbasef,, usef, SeJler=s coanmercially reaso¡able effo'rts(including, ifrequested by Purchaser, provision of a Seller attes,tatiod tozubstantiate that the capacity and energy that are the subject of thisConfirnation a.re not allocated or corunitted to afly other resor¡rce adequacyor ca¡racit¡r traasactions- Bo].o and Seller shall make coooaerciallyreasonable efforts to maintaiathe spirit aud intent af the tra¡sactioru thæare the srbject ofthis Cmfirmatioqr. includùrg tåe economic value to bothparties for use as orieiffillv intended-

I

Associated Risl F¡nancial hedges will be utilized to mitigate risk

> CreditÞ Currently MSCG is rated A+ by S&P and TEA's internal credit analysis

> RAVoluntary Standard ComplianceÞ Language built into the contract to work toward complianceÞ Contract may not count toward compliance ¡f RA standard is specified source

Þ Transm ission Avai labi I ityÞ Currently low probability of curtailment for power coming from Grant PUD BAA

to Benton's System> BPA Persistent Deviation Charges

Þ Reduces risk for BPA persistent deviation by having an available resource to call on s

Timing of Contract

CETARequirement:

100% Carbon FreeResources

2045

CETARequirement:Carbon Neutral

80/20 Rule

2030

BPA Contract:Current Contract

Expiration

2028

CETARequirement:

No Coal

FredericksonContract Expires

BPA Contract:Post 2028 Contract Discussions

2020

Recommended MSCG SeasonalCapacity Product Contract

t0

Staff Recommendat¡on

Þ Contract with Morgan Stanley Capital Group lnc. (MSCG) topurchase a seasonal capacity product for:

> 75MW heavy load hours (HLH) July/August

> 25 MW H LH Decemberlanuary lFebruary

Þ Term: December 2022 through August 2025

il

Finonciol Forecost Updote

Jonuory 14, 2O2O

ffi

Reco p: December Finoncio I Forecost*2020, MTM v. 25'h Percentile for Net Power Costs

E

December

December

Projected Rate lncrease

Days Cash on Hand

Net lncome

Projected Rate lncrease

Days Cash on Hand

Net lncome

Oct t

2.9%

105

($o.tM)94

it.gM

8l

5rr.4M

105

$r o.5M

123

$r.8M

131

$r o.oM

Oct t

2.9%

105

(go.tM)93

5t.+M

88

$rz.6M

110

$rz.oM

132

$r3.3M

145.

$rr.6M

BEtro¡t

4Y-A-n

MTM

2O195oth2021

DescrÍption

Sig nifico nl U ncerloi nty

MTM

2020

Apr t

2.9%

MTM

2019z5th

20205oth2021

5oth2022

5oth2023

5oth2O2+

Descríption

Apr t

4.1%

ñrìi*Forecast details located in the Appendíx to thís presentation

J onuo ry Finqncio I Forecost*2O2O, MTM v. 25'h Percentile for Net Power Costs

101

2O19 Lower: Timing of copitol expenditures,doesn't chonge overoll forecost

Apr t

2.9%

95 89 ro8 125 134Higher: lmproved2O2O woterforecost

Significont U ncertoÍnty

MTM

2O195oth

20215oth2022

5oth2O23

5oth

zo24MTM

2020

JanuaryProjected Rate lncrease

Days Cash on Hand

Net lncome

Oct r

z.g%

($o.3nn¡ $8.6M $rr.7M $ro.6M $fi.7M $ro.3MMTM

2019z5th

20205oth

20215oth2022

5oth

2O235oth

2O24Descríptíon

Projected Rate lncrease

Days Cash on Hand 1O1 92 88 111 132Net rncome ($o.3nn¡ Ð.+M grz.8M grz.rM gr3.zM

*Forecast detaíls located in the Appendix to thís presentatíon

Oct r

2.9%

Apr t

4.1%January

146

$rr.9MBEtfat

4Y-A-O ffi

2O19 Updotes

oo Updates to zorg:oo Revenues & Expenses (íncorporates YTD actuals)oo Capital: Estimatíng -$3.5M underrun (December Forecast had -$+.5M)

oo Estimating $1.5M permanent savings (No change from December)oo $t.3M BPA project savings (Southrídge lnterconnectíon / McNary tt5 kV)oo go.zM various project savings

oo Estimating $z.oM zo19 carryover to zozo (December Forecast had g3.oM)

oo Does not change overall multi-year forecast compared to December forecastoo Affects DCOH at end of zotg only (slightly lower than December forecast)

DErrot

ä-a-o E

Jqnuqry Net Power Cost Forecost Updotes

oo 2o2o Net Power Cost Budgetoo Budget set @ z5tn percentile: 984.o millionoo For reference: 5oth percentíle was g8z.o million

oo Current Net Power Cost Projectionsoo 2o2o water year forecast has improved since last forecast (December to)

December I O, 2O19 Jonuory l4,2O2O

Woter forecost ( Percentile)

2O2O Net Power Cost

-25'n percentile

$gS.S millíon

-40th percentile

$gZ.A million

,Ê¡:Íi:nry

2O2O Woter Yeor Proiection (still eorly)

(f('}

(f,c{

()

VlfY2020 JAiI.JUL Runoff Forecast @TDA

2019.11-01 20't9.12-41

Forecast Dale

äB

()(')

()(o

or\

2019.10.01 2020.01"0r

BEflTOT

zY'A'D

TEAs wqler forecosl(80% TR & 20% ESP)

Thomson Reuler(TR) woter forecqsl 91 .2 MAF

ESP (Federol Government okqNOAA) Woler Forecosl

ESPFSP RoftrgTR ECTR EC RoerçfËA OfÍoalTEAPIOIPgOErpected - BPA Sludy

Expected Wolerper BPA Study

I04 MAF

98.2 MAF

Very unusuol to hqveESP forecost obove TR

forecosl

ffi

2O2O Woter Yeor Proiection Short Term

Jonuory qnd Februory still qt or below the lOrhpercentile (no moior chonge since December)

\

cErrotär.a.L

JAII¡û*

FEËrulr ü* ¡slÊ ?Ëfi

flsoü rÞû0 tû00 Ðû0û It0t0 ffioü t0,00 tÞ000 t?000

ffi *Monthly water distríbutíons for all of zozo included in Appendíx

2O2O Woter Yeor Proiection Short TermOn 12/3/19, Moy, June, Jul¡ ond August were below 40th percentile

I\

tÐstTÀY

35i 40li 6{1¡ ¡sri Êc!t r0!6¡ul

?514 ¡04å 6t5{ ?5!6 Sü-t6

8úfô r û40c t¡Ë,ût,

A[6?51È .0rË ãg!{ ?59Ê.

JUt?5* .C* ÊôX Ìttå s{t:È

Ês{û gilts 100ût 1¡ts0 lûôtt I ¡000$dûÊ 4c{û

I &tÊ

Êc']{l

BEtrat

4Y-A-D

1099 sd!{

rct0 gûÒû 6{ûô 7t{û üôco süû0 tcoûû

/\

\/ \

\

I/ \

\

ffi *Monthly water distributíons for all of zo2o included ín Appendix

2O2O Woter Yeor Proiection Short TermNow, Moy, June, Jul¡ ond August ore ot or greoter thon the 40th percentile

I \\

TAYr0!a ?5q( 60*

JUTro!. ?57 ô0!( 90r

JÜItoa x.¡ 60tr 90't

¡0û0 6000 8ô00 t0000 t?000

90!r

6ô00 t¡00 t0cô0 t1000 6000

t0!t

ôt'00 r00ô0

75r¡

r?000

At640tt

.000 5000 6000 7000 8000 t'000 10000

/

IàËfffihffi *Monthly water dístríbutíons for all of zo2o íncluded ín Appendix

Current Forecost Expected Slice98.2 MAFr

50

40

30

zo

10

o

-10

-20

-30

Slice Only

Red bqrs were expected slice os of December Forecost

=G

oc!oc{oof\¡fn

oc{c)r\¡sl

oNoñ¡ø

oc{oa\¡

o

Jonuory Forecost Updotes

Net Power Cost NPC lncrease from December to Januaryln millions

December

Jonuory

lncreose

$er.4

$e2.2

$0.8

$s3.5

$82.8

$9t.4

$81.2

($0.2)

$s3.3

$83.3

$0.o

$82.O

$82.r

$0.1

$84.o

$83.2

($0.3)

$50s.ó

$s05.3

Summory of lncreose

Nov NPC Acluqls

Mqrket Conditions

Tolql

$0.5M

($0.8M)

($0.3M)

RETJÍOTJ

æ.U.D

2019 & 2020 ot MT qll other eors of 5Oth ercentileForecqst 2019 2020 2021 2022 2023 2024 Totql

($o.z) ($0.3)

'ffi

Sensitivity Anolysisr

tr What if some of the variables change?n Staff has created 3 different scenarios

tr Net Revenue reductionss All years presented at 5oth percentileScenorio 2019 2020 2021 2022 2023 2024 Totol

I

2

3

$o.o¡n

$o.o¡n

$o.o¡n

$t.0M

$z.om

$¡.om

$1.0M

$2.01*

$3.0m

$1.0M

$2.Olvt

$3.0¡n

$1.0M

$z.o¡n

$s.o^^

$l.om

$2.0¡n

$3.01*

$5.0M

$ I 0.0M

$ r 5.0M

nEflÍON

æü-D *ã

Sensitivity Anolysis Scenorios *

r

Scenarío I($5.oM Total)

Scenario z($1o.oM Total)

Scenarío 3($t5.oM Total)

Projected Ratelncrease

Days Cash on Hand

Net lncome

Projected Ratelncrease

Days Cash on Hand

Net lncome

Projected Ratelncrease

Days Cash on Hand

Net lncome

Oct r

2.9%

101

($o.¡wt)

Oct t

2.9%

101

(so.3nn¡

Oct t

2.9%

101

92

$7.6M

Oct t

2.9%

9'l

$z.sM

Apr t

2.9%

93

$8.5M

Apr t

4.3%

86

$rz.oM

Apr t

2.9%

88

$13.4M

Apr t

2.9%

B8

$rz.4M

107

$rr.3M

"tz6

$rz.4M

137

$rt.rM

111 133$lz.zM' $r3.3M

146

$rz.oM

ro8

$rr.zM

127

$rz.3M

137

$ro.9M($o.3nn;

MTM

2O195oth

20205oth2021

5oth2022

5oth2023

5oth

2024DescrÍption

Significont Uncertointy

BEflîOT

æüÐ#!#r*Forecast details Iocated ín the Appendíx to this presentatíon

Discussion

ütI

àÊfffibffi

End of Presentotion

#trom

frEïr0t

ìF,U,OFINANCIAL STATEMENTS

November 2019(Unaudited)

Table of Contents

Monthly Financial Highlights

Statement of Revenues, Expenses and Ghanges in Net AssetsCurrent MonthYear-to-Date2019 Monthly Activity

Gomparative Balance Sheet

Energy Statistical DataCurrent MonthYear-to-DatekWh Sales - Monthly Activity

Plant Additions and RetirementsCurrent MonthYear-to-Date

Statement of Cash Flows

Weather Statistics

Broadband Summary

Paqe

6-7

1213

14

15

16

2

345

II

10-11

Payroll Report 17

Issile dak: L'6i20

Financial HighlightsNovember 2019

Retail RevenuesÞ Novembefs temperature was 3.O degrees below the s-year average while

prec¡pitat¡on wås 8870 below the s-year average of O.75 ¡nches. Heat¡ngdegree days were 137o above the s-year average. With cooler thannormal October and November temperatures, th¡s helped reta¡l revenuesto be about $80ok above budget est¡mates.

Þ Retail revenues year to date are sl¡ghtly above budget estimates.Net Power Expense (NPE)

> NPE was $6.5M for the month.> Slice generation was l06 aMW's for November.> Sales ¡n the secondary market returned about $'1.4M-Þ Net Power Expense YTD of $85.3M is $4OOk above amended budget.

Net Margin/Net Pos¡tionÞ Net position is slightly better than budget est¡mates and net margin is

about $228k below budget estimates.Capital

> Capital expenditures for the year are $16.3M of the $20.3M net budget.O&M Expense

> November's O&M expenses, before NESC, were $1 .7M or 9olo belowamended budget.

> O&M expenses YTD, before NESC, were $20.5M or 5olo below amendedbudget.

Net Power ExpenseRetail Revenues

s798

sL42

{Ssoo}Nowmber YTD

Over/(Under) Budget* (thousands)

s370s114Hry

(S1,ooo)

YTDNovember

å40

8eo

s-

st20)

lNet Power {NPC)

.92.2,

BiÉUEt - -- - - --fr/lo/¿oþl -2019Orlginal

- --e¡d¡ièt---fNov,2or8l

Position/Net Margin YTD Over/(Undèr) Budget

5s6

(9zza¡

Net MarginNet Pos¡t¡on

(s1,000)

(in thousands)

F o ctors olfecti ng Reve n ue s

o%4r%

November YTDCDD November YTD Prèc¡p

(% over s-year average)&

15

oiJl

(5)

Novèmber YTD

Load Ovêr/(under) Budget* (in

I F M A M J J A S O N DYID

r Budget 5

So

I Average S

47

Merket Price v,

Foctors afiectíng Net Power Expense

Water Flow Pro¡ect¡on % of Normal Runoff

89% 92%

o%

2019Jan-Jul 2019

Slice Generation Over/(Under) Budget* lin aMWl

(2)

YTD

(1)

{10}November

Secondary Market Sales Over/(Underl Budget+ (91

-3%

-50%

November WD

Other Statistics

Days Cash On Hand - Current

Days Cash On Hand - Forecast

Debt serv¡ce coveragè

Fixed Charge Coverage

Act¡ve Serv¡ce LocatÌons

YTD Net lncrease (November - 121)

New Services Net - YID (897 New, 160 Retired!November (101 New, 14 Ret¡redl

lnact¡ve Servíces

106

101

3.53

7.43

54887

75L737

87

57t

'iqr¡lt1$þ3ilr)

6lir! €{pe-cl g¡nellåblllly lSt.SMl0l¡¿ CG lnn¡fo¡me¡¡ ($2,7M1

DlsL Curtomèr Grolflrth ($1.9M)

Dlst Repeh/Replåcemsnt ($2.4M)

Trãnsml$lon {$2.3M1

8ro¡db¿nd (91.4M1

G€nårål Plânt (92.4M1

lr (90.7M1

C¡rryovêr (SO,7Ml

'

l

O% ZOY¡ 40% 60% 9OY. 70o%

Ì q} Budgatr Q¿ Sudgêt" Q3 Budget

r q4 BudgêtlYlD Actuel

O&M Expense before NESC Compliance and Cap¡tal txpend¡tures

Câpital

November YTD

(s164)

(S1,1se)

(S4,ooo)o&M

Novêmber YTD

S vro18.21M

8.82M

2.33M

2.tgM

1.16M

0.67M

0.93M

L,42M

0.68M

OM

the amended bu the commission onas ?4,20t9. 2

PUBLIC UTILITY DISTRICT NO,l OF BENTON COUNTYSTATEMENT OF REVENUES, EXPENSES, AND CHANGE IN NET POSITIOI{

ilovEllñBER 2019

1ll30n9

OPERATING REVENUESEnergy Sales - RetailCity Occupation TaxesBad Debt ExpenseEnergy Secondary Market SalesTransmission of Power for OthersBroadband RevenueOther Revenue

TOTAL OPERATII{G REVEI{UES

OPERATING EXPENSES

Purchased PowerPurchased Transmission & Ancillary ServicesConservation Program

Total Power Supply

Transmiss¡on Operation & MaintenanceDistribution Operation & MaintenanceBroadband ExpenseCustomer Accounting, Collection & lnformat¡onAdministrative & General

Subtotal before NESC Compliance / Public SafetyNESC Compliance (Net Distr¡ct Expense)

Subtotal before Taxes & DepreciationTaxesDepreciation & Amortization

Total Other Operating Expenses

TOTAL OPERATING EXPEiISES

oPERATTiTG TNCOME (LOSS)

NO}IOPERATING REVEN U ES & EXPEiISESlnterest lncomeOther lncomeOther Expenselnterest ExpenseDebt DiscounuPremium Amortization & Loss on Defeased DebtMtM Gain(Loss) on lnvestments

TOTAL NONOPERATING REVENUES & EXPEiTSES

tNcoi/rE (Loss) BEFoRE cAPTTAL CONTRIBUTTOT{S

CAPITAL COi¡TRIBUTIONS

GHANGE Ii¡ ilET POSITION

9,913,517517,099(r 6,700)

1,356,980188,702219,059't13,208

9,1 15,023524,659(19,543)

1,963,80975,000

208,914108,431

9o/o

-,lo/o

-15o/o

-31%152o/o

5%4o/o

-'182o/o

1',U30t18

9,487,434462,863(15,000)

4,842,458166,792't92,162't45,032

4o/o

12Yo

11o/o

-72o/o

13Yo

14%-22o/o

-260/o

9o/o

-60%

-23o/o

-57o/o'lo/o

'l5o/o

-22%-12o/o

-9%>-200o/o

-5o/o

9o/o

2%

1o/o

-17o/o

-58o/o

12,291,866

6,865,8021,178,732

50,491

't1,976,292

7,315,5381,173,973

(21,7401

9,272,7501,082,786

125,233

'60/o

0%>-200o/o

4o/o

-13o/o'lo/o

20o/o

-14o/o

-21o/o

-9o/o

43o/o

-8o/o

8%8%

0%

-3o/o

>-200o/o

>-200o/o

-27o/o

nla-10o/o

-'120/o

n/a

>200%

3a/o 15,281,711 .20%

8,095,025

25,28872',t,920120,680344,599509,353

8,467,772

29,',t017',t4382100,584400,558641,041

10,480,769

59,467712,871105,363443,684577,428

1,721 ,84062,705

1,885,66643,8't4

1,898,813(27,524)

1,784,5451,108,762

84s,127

1,929,4801,030,104

780,857

't,871,2891,012,928

830,213

3,738,434 3.740,442 3,7'14,430

1f,833,459

158,407

( 1 67,1 53)22,97'l

(183,619)34,318

141

12,208,211

(231,9211

99,97731,339

(204,012)38,841

14,195,199

1,086,5,12

't13,14034,763

(224,006)38,',127

15,643

>-200%-34o/o

nla-'t8%-'t0%-99%

>200o/o(33,855) (22,3331

165,065

122,160

(265,776)

't86,272

1,064,209

484,603

-81o/o

-34o/o -75o/o

_______287,225_ __(79,999L >-200o/o _1_,518,812_ -81o/o

ACTUAL ACTUALAMENDEDBUDGET

PCTVAR

PCTVAR

PAGE 3

UNAUDITED STATEMENTS

PUBLIC UTILITY DISTR|CT NO,1 OF BENTON COUiITYSTATEMENT OF REVENUES, EXPEI{SES, AiID CHAiIGE IN iIET POSITIOI{

YEAR TO DATE

't tr30rt9

OPERAT¡T{G REVENUESEnergy Sales - RetailCity Occupation TaxesBad Debt ExpenseEnergy Secondary Market SalesTransmission of Power for OthersBroadband RevenueOther Revenue

TOTAL OPERATING REVENUES

OPERATil{G EXPEilSES

Purchâsed PowerPurchased Transmission & Ancillary ServicesConservation Program

Total Power Supply

Transmission Operation & MaintenanceD¡stribution Operation & MaintenanceBroadband ExpenseCustomer Account¡ng, Collection & lnformationAdministrative & General

Subtotal before NESC Compl¡ance / Public SafetyNESC Compliance (Net District Expense)

Subtotal before Taxes & DepreciationTaxesDepreciation & Amort¡zation

Total Other Operat¡ng Expenses

TOTAL OPERAT¡T{G EXPET{SES

oPERATD¡G r{COi'lE (LOSS)

NONOPERATING REVENUES & EXPEilSESlnterest lncomeOther lncomeOther Expense

. lnterest ExpenseDebt DiscounlPremium Amortization & Loss on Defeased DebtMtM Gain(Loss) on lnvestments

TOTAL iIONOPERATIIIG REVEilUES & EXPENSES

INCOME (LOSS) BEFORE CAPTTAL CONTRTBUTTONS

CAPITAL COIITRIBUTIOiIS

GHANGE IN I{ET POSIÏOil

TOTAL T{ET POSITION, BEGIilNING OF YEAR

TOTAL iIET POSITION, END OF YEAR

147,729,786 117,870,767

117,283/055,620,590(209,600)

19,885,9341,372,'t962,256,3981,520,862

117,141,3715,622,082(233,364)

20,597,9531,099,4512,20'1,3421,441,932

11t30t18

113,481,5955,407,738

(1 96,000)19,017,433

1,309,9322,055,8471.638,642

3%4o/o

7o/o

5o/o

5o/o

'l0o/o

-7o/o

't4%0o/o

>200%

13o/o

(586,746) (461,48r)

Qo/o

0o/o

-10o/o

-3%25%

3%5%

0o/o

0o/o

0%-49%

0o/o

-33o/o

-8o/o

10o/o

-3o/o

-5%

-5o/o

47o/o

-4o/o

-1o/o

1o/o

-2%

-1o/o

-27o/o

-13o/o

'lo/o

nla-2o/o

-9o/o

nla

27o/o

-21o/o

-27olo

-5o/o

0o/o

0,10/o

-34o/o

-2o/o

10o/o

1%1o/o

0%21%

0o/o

3%4%

2o/o

9%

-145o/o

-8o/o

0o/o

nla-11o/o

-10o/o

-31o/o

-2'lo/o

142,715,187 1o/o

93,557j8212,677,612

385,768

93,193,77612,675,490

762,218

81,777,73'l12,618,145

59,524

106,620,542

109,4058,773,240

953,9034,136,6256,558,381

106,631,483

164,'t789,498,736

8ô9,7314,25'1,7936,906,402

94,455,400

165,0008,947,435

870,2824,095,3136,516,470

20,531,555709,73',1

21,690,840481,959

20,594,500586,206

21,241,28612,967,9579,338,316

22,',t72,79913,151,1679,267,778

21,180,70612,614,0999,022,116

43,547,559 44,591 .744 42,816,921

150,'168,'101

(2,¡[38,3r6)

954,071348,586

(2,286,481)377,499

19,580

'151,223,228

(3,352,460)

1,099,743344,731

(2,322,460\416,505

137,272,321

5,¡f42,866

1,032,126349,623

(2,574,085)419,393

28,573

___j,066,1931133,899,577

_J1r1!2,057L133,899,577

6,656,370

(3,025,062)

1,958,929

(3,813,941)

2,691,883

4,698,496

1,957,871

-161%

0o/o

-1160/o

-2o/o

4o/o

124,155.023

132,833,4¡15 132,777,520 130,811,393

ACTUAL ACTUALAMENDEDBUDGET

PCTVAR

PCTVAR

PAGE 4

UNAUDITED STATEMENTS

PUBLIC UTILITY DISTRICT NO. 1 OF BENTON COUNTYSTATEMENT OF REVENUE$, EXPENSES, AND CHANGE IN NET POSITION

2OI9 MONTHLY ACTIVITY

OPERATING REVENUES

Energy Sales - Reta¡l

City Occupat¡on TaesBad Debt Expense

Energy Secondary Market Sales

Transm¡ss¡on of Power for Others

Broadband Revenue

Other Electric Revenue

TOTALOPERATING REVENUES

OPERAÏING EXPENSES

Purchased Power

Purchased Transm¡ss¡on & Anc¡llary Serv¡ces

Conservation Progrâm

Total Power Supply

Transm¡ss¡on Operat¡on & Ma¡ntenance

Distr¡bution Operat¡on & Maintenance

Broadband Expense

Customer Amunt¡ng, Collection & lnformat¡onAdm¡n¡strative & General

Subtotal before NESC Complianæ / Publ¡c Safety

NESC Compl¡anæ (Net Distr¡ci Expense)

Subtotal before Taxes & Depreciat¡on

Taxes

Depræ¡ation & Amortization

Total Other Operating Expênsês

TOTAL OPERATING EXPENSES

oPERATTNG TNCOME (LOSSI

NONOPERATING REVENUES & EXPENSES

lnterest lncome

Other lncome

Other Expense

Interest Expense

Debt D¡sæunt & Expense Amort¡zation

MtM Ga¡n/(Loss) on lnvestments

Loss ¡n Joint Venlures/Special Assessments

TOTAL NONOPERATING REV/EXP

tNcoME (LOSS) BEFORE CAPTTAL CONTRTBUÌ|ONS

CAPITAL CONTRIBUTIONS

CHANGE IN NET POSITION $314.796 t$413.240) t$3.632.4341 t$830.254) $188.119 $2.778.983 $1.389.594

14,476,666 17,O10,O74 15,777,432 10,735,711 11,105,7'11 13,858,740 14,685,004 14,352,749 11,945,357 11,490,475 12,291,866

$10,133,264

593,823

(1E,000)

2,876,O41

120,920

197,64572 714

8,553,731

1,27't,434ffi774

4,2't4

862,A21

62,443

343,229

424.147

2,164,985

1,266,090

435 933

't4,18't,946

294,720

11.l,424

3't,355

(197,1s1 )34,318

14,636

(5,O16)

249,704

25,O92

$1 1,448,330

640,507(19,300)

4,541,244't'18,076

192,965aaz^a

12,329,908'1,105,891

/^t ÃÃaì

8,005

784,791

77,297

æ5,2Þþ

493.822

1,776,919

1,345,720951 764

17,447,653

(437,579)

$10,205,388

634,083(19,200)

4,529,241

'160,172

192,18275 566

14,214,595't,162,591

(tÃaaa\

7,142

958,348

107,542

365,108

506.736

'1,917,997

1,333,331

a)7 aaî

19,431,606

(3,654,174)

$8,518,369

469,094

(18,400)

1,310,249

152,687

195,468

1o,4 r44

6,703,472

1,093,605

8,562

808,402

83,823

344,241

655.791

1,973,675

1,053,217

826 Asq

11,657,450

(921,739',)

$9,721,347

393,51 0(19,100)

577,536't 18,562

201,443112 Áa?

5,770,619

1,147,657aa 477

9,690

797j0469,111

412,069

846.480

2,286,370

1,004,354

430 cl7

1 t,089,894

15,817

$12,317,339,148,919

(21,4OO\

750,725

77,614

196,480a9 05q

6,932,747

1,148,724q2 ?q?

5,069

697,568

69,530

377,650

51 0.459

1,741,291

1,'185,274

a3t f)¿,¡

'I 1,892,469

1,966,271

100,515

35,205

(222,398)

34,318

10,'t35

'1,924,046

854,937

$1 3,080,433

464,926(21,300)

81 8,436

51,4 t 9

214,20276 ARR

$1 2,531,51 I527,692

(22,3OO',)

948,271

67,063

217,424ß3 na8

9,007,998

't,146,844Rl ÃnÂ

8,753daa aaa

85,7'13

374,388

457.979

2,O20,06'l

1,309,513â¿q qqs

14,4't5,9't9

(63,170)

$9,946,01 I505,250

(1 8,300)

1,O79,476

M4,2112 1 3,905

7t\ 797

7,1A6,547

1,1 00,0841q %t

9,1't'l

775,295

92,204

360,961

524.227

1,756,149

1.146.'t21

A¿q o35

't2,o54,678

(109,321 )

$9,467,888425,648

, (15,600)

1,097,691

168,768

2'15,404,130 Â3Â

7,631,292

1,147,3Æ7q 1L7

14,764

876,955

76,369

429,153

598.832

2,O71,614

976,574

^ ãgt

12,748,O25

(1,2s7,550)

$9,913,517

517,099(16,700)

1,356,980

188,702

219,059113 2r)9

6,86s,802

1,178,732(n áqt

25,288

72'1,920

120,680

344,599

509.353

1,744,U5

1,108,762

445 1)7

1 1,833,459

458,407

$117,243,404

5,620,591

(209,600)

't9,885,934

1,372,194

2,256,396

I 520 8,62

147,729,745

93,557,'161

12,677,614cÂq 7AR

'106,620,543

109,404

8,773,240

953,903

4,1 ,6256,558,382

20,531,554a^4741

21,241,245

12,967,958

c 338 31â

43 547 559

'150,168,102

(2,438,317t

954,069

348,587

(2,286,480t

377,498'19,581

(586.74s)

(3,025,062)

1,958,930

9,914,938 13,373,2Æ 15,352,443 7,803,699 6,968,253 8,'133,864 9,586,467 10,236,350 8,302,473 8,853,785 8,095,025

125,340

35,099

(20s,39e)

34,318

9,528

(æe,693)

25,453

109,726

32,988

(2't9,U7)

34,318

1 3,833

(3,683,156)

50,722

1 1 5,854

24,104

(2O3,872\

34,318

(951,331)

't21,O77

168,180

31,339

(2o3,162)

34,318

(44,O49)

2,443

'185,676

8,360,450

1,174,706q1 ?11

8,806

510,6ô4

109,19t

377,961

630.556

1,747,679

1,239,OO2

841.855

13,415,003

1,270,OO1

10'l,365

31,34',1

(212,760\

34,318

1,443

1,225,708

163,886

94,966

31,538

(212,060)

34,318

(276\

(1 1 4,684)

166,785

106,065

35,115

(218,376)

34,318

9,431

(142,768)

177.O't3

a7,347

37,52A

(2O7,8341

34,31 I4,757

(1 ,301,394)

66,129

(167,1 53)

22,971

(1 83,621 )34,318

141

165,063

122.160

2,136,854 1,731,181 't,944,A76 1,904,819 2,134,454 1,660,276 1,637,178 1,899,205 1,764,798 1,996,073 1,721,440151 8t

4.267.00A 4.074407 4079'163 3853751 4121 641 3758605 3828536 ¿179s6C 375?205 3s94)40 373A434

(1,114\ (28,982) (29,5921 (13,374) (42.225\ (44.293\ (51,514) (33.447\ (43.U4\ (293.344\

PAGE 5UNAUDITED STATEMENTS

$52.101 934.245 t$1.235.265) 52A7.223 $0 r1.066.132)

ASSETS

CURRENT ASSETS

Cash & Cash Equ¡valents

Unrestricted Cash & Cash Equ¡valents

Restricted Construction Account

lnvestments

Designated Debt Serv¡ce Rèserve Fund

Designated Power Market Voltly

Designated Special Cap¡tal Rsv

Designated Customer Deposits

Accounts Receivable, nel

Noles Receivaþle

BPA Prepay Rece¡vable

Accrued lnlerest Rece¡vable

Wholesale Power Rec€ivable

Accrued Unbilled Revenue

lnventory Materials & Supplies

Prepaid Expenses I Option PremiumsTotal Cunent Asgets

NONCURRENT ASSETS

Restrictgd Bond Reserve Fund

Other Receivables

Preliminary Surveys

BPA Prepay Recelvaþle

Defered Purchâsôd Power Costs

Util¡ty Plant

Land and lntang¡ble PlantElectr¡c Plant in Service

Construciion Work in Progress

Accumulated Depreciation

Nst Utility Plant

Total Noncurrent Assets

Total AssoG

DEFERRED OUTFLOWS OF RËSOURCES

Unamortized Loss on Defeased Debt

Pension Defered Outflow

Accumulated Decrease ¡n Fair Value of Hedg¡ng Derivatives

Total Deferred Outflows of Resourceg

TOTAL ASSETS & DEFERRED OUTFLOWS OF RESOURCES

PUBLIC UTILITY DISTRICT NO. 1 OF BENTON COUNTYCOMPARATIVE STATEMENT OF NÊT POSITION

ASSETS AND DEFERRED OUTFLOWS OF RESOURCES

32,603,538

2,746,919

2,612,152

3,ô79,1 28

1,900,000

8,210,743

85,256

600,000

9,785

s42,628

4,519,000

5,699,483

379,765

24,335,168

10,64ã,098

2,ø12,'152

3,850,000

12,511,793

1,600,000

7,315,389

600,000

169,1 r 7

1,805,482

3,800,000

5,476,431

379,622

$8,268,370

(7,898,180)

0

(17O,872'

(12,51 1,793)

300,000

895,354

85,256

(159,332)

(862,854)

719,000

223,O52

143

63,9E8,397

1,107,865

152,498

34,591

4,700,000

5,584,094

75,100,252

1,107,865

97,007

124,338

5,300,000

5,610,622

(11,111,865) -15o/o

0

55,491

(8e,747)

(600,000)

(26,525)

11,879,047

3,848,789332,295,817

10,780,533

(206,034,0ô0)

12,239,832

3,530,2303'18,464,934

5,838,000

(1 96,351,108)

(60,785) -5o/o

3r8,55913,830,883

4,942,533(9,682,952)

140,891,079 131,¡182,056 9,¿109,023 7%

152,470,126 1¡l{},721,888 8,7ß,238 60/ø

216,/t58,523 2',t8,822,140

(30,402)

1,425,O22

536.409

(2,363,617) -1o/o

1,180,507

1,620,733

30,402(248,51 5)

1,084,324

2,801,240

219,259,763

1,935,029

220,757,199

866,211

(1,497,¡106) -1o/o

PAGE 6

UNAUDITED STATEMENTS

.11,30120i91 1/30/2018

lncrease/(DecreaseiAmounl Percent

LIABILITIES

CURRENT LIABILITIES

Wanants Outstanding

Accounts Payable

Customer Dèpos¡ts

Accrued Taxes Payable

Other Cunent & Accrued Liabil¡tles

Accrued lnterest Payable

Revenue Bonds, Current Portion

Total Currènt L¡abll¡t¡es

NONCURRENT LIABILITIES

2010 Bond lssue

201 I Bond lssue2016 Bond lssue

Unamort¡zed Premium & D¡scounl

Pens¡on Liab¡lity

Defened Revenue

BPA Prepay lncentive Credit

Other Liabilities

Total Noncurrent L¡ab¡l¡ties

Totel Liab¡lit¡ès

DEFERRED INFLOWS OF RESOURCES

Unamorlized Gain on Defeasêd DeþtPension DeferÌed lnflowAcÆumulated lncrease in Fair Value of Hedging Derivatives

Total Defenod lnflows of Resources

NET POS¡TION

Net lnvestment ¡n Capital Assets

Restric{ed for Dsbt Serv¡ceUnrestricted

Total Net Po6¡t¡on

TOTAL NET POSITION, LIABILITIES AND

DEFERRED INFLOWS OF RESOURCES

CURRENT RATIO:

(Current Assets / currênt Liabillties)

WORKING CAPITAL:

(Current Assets less Current Llab¡lities)

PUBLIC UTILITY DISTRICT NO. 1 OF BENTON COUNTYCOMPARATIVE STATEMENT OF NET POSITION

LIABILITIES AND DEFERRED INFLOWS OF RESOURCES

'10,099,628

2,'t23,398

3,161 ,989

3,009,326

2'15,332

3,940,000

8,944,535

2,028,939

2,915,1 13

2,817,538

230,957

3,750,000

$o

1,155,093

94,459

246,876

1 91,788

(1s,625)

190,000

22,549,974

17,345,000

5,830,000

22,470,000

3,483,369

6,852,561

549,628

1,424,459

1,994,855

20,487,082

17,345,000

9,770,000

22,470,O00

3,904,906

9,884,887

1,039,637

1,585,715

987,392

't,862,592 9Vo

(3,940,000)

(421,537)

(3,032,326)

(490,009)

(161,256)

'I,007,463

59.949,872 66,987,537 (3,097.665ì

40,'121't,06

'622551,872

-11o/o

4o/o

73o/"

82,499,54ô 87,674,619

1,866,ô03404.554

(r,23s,073)

40,1212,930,225

956,426

3,926,772 2,271,',t57 1.655.615

87,782,588

1,107,86543,942,991

74,211,748

1,1 07,86555,49't,780

13,570,840

(1 1,548,78e)

132,833,¿145 130,811,393 2,022,052 20/6

2't9,259,763 220,f57,199 (1,¡197,406) -1o/o

2.84t1

4'.t,438,f23

PAGE 7

UNAUDITED STATEMENTS

3.63:1

$54,413,170 ($12,574,471 -AYo

1 1'30/2019 11t30t20'18lncrease/(Dêcrease)Amou¡rt Percenl

PUBLIC UTILITY DISTRICT NO. 1 OF BENTON COUNTYENERGY STATISTICAL DATA

CURRENT MONTH

1 1/30120t9

ENERGY SALES RETAIL. REVENUERes¡dential

Small General ServiceMed¡um General ServiceLarge General ServiceLarge lndustrialSmall lnigatlonLarge ¡nigat¡onStreet LightsSecurity L¡9htsUnmetered Accounls

B¡llod Revenues Before Taxès & Unb¡lled RevenueUnbilled Revenue

Energy Sâles Retâll subtotãlC¡ty Occupation TaxesBad Debt Expense (0.i6% of Þrâ¡tstes)

TOTAL SALES - REVENUE

ENERGY SALES RETAIL - KWhResidentialSmall General ServiceMedium General ServiceLarge General Serv¡ceLarge lndustrialSmall lnigationLarge ln¡gationStreet LightsSecurity LightsUnmetered Accounts

TOTAL KWh BILLED

NET POWER COSTBPA Power Costs

Sl¡ceBlock

SuþtotalOther Power PurchasesFredericksonTransmissionAncillaryConservation Program

Gross Power CostsLess Secondary Market Sales-EnergyLess Secondary Market Sales-GasLess Transm¡ss¡on of Power for Others

NET POWER COSTS

NET POWER. KWhBPA Power

SliceBlock

SublotalOther Power PurchasesFrederickson

Gross Power kwhLess Secondary Market SalesLess Transmission Losses/lmbalance

NET POWER - KWh

COST PER MWh: {dollars)Gross Power Cost (average)Net Power CostBPA Power CostSecondary Market Sales

ACTIVE SERVICE LOCATIONS:Residenl¡alStrrall Ge0eral SérviùeMedium General ServiceLarge General Serv¡ceLarge lndustrialSmall lnigationLarge lrigationStreet LightsSecurity LightsUnmetered Accounts

TOTAL

aMW61,894,953 86.0 51,897,85710,080,963 14.0 9,014,9ô215,651,915 2't.7 15,049,46219,184,900 26.6 19,793,3745,555,880 7.7 5,650,557

99,643 0.1 8702,489,215 3.5 2,688,332212,'t28 0.3 208,07879,051 0.1 8ô,135

254,791 0.4 255,524115,503,439 160.4 104,6¡t5,152

$9,328,5r8585,000

$8,530,023585,000

4,614,862689,477

1 ,163,1 501,346,136

289,25713,852

314,388't7,82321,88016.608

$8,487,4331,000,000

s9,467,433462,863(15,000)

$9,935,296

53,123,3659,191,224

15,499,97820,269,12'l

5,498,280't24j27

3,048,5452'11,640

82,782245,945

____1!Z¿9!r9¡_

$5,400,239770,438

1,178,2431,343,141

294,93712,435

271,023I 8,32321,70518,034

$4,646,31 2694,032

1,138,1771,356,885

303,6502,791

327,O901 8,26624,74'l1 8,080

160/o

11%4Vo

-1Vo

-3o/o>200o/o

-17o/o

0o/o

-12o/o

oo/u

90/o

Oo/o

gVo

-1Yø

-150k80/o

-13o/o

Oo/o

-8o/o

84o/o

-390/0

3o/o

-12'/">-2OOo/o

-40/,-560/o

nla152o/o

2o/o

17o/o

12o/o

10kovo

2o/o

-1Oo/o

-14o/o

3o/o

-1o/o

10o/o

420/0

4%12o/o

1 1o/o

5%

't20/ø

8o/o

1Oo/o

-48o/o

-61o/o

9o/o

60/o

-59%-23þ/o

-36o/o

-86%'l3o/o

20%

-1o/o

0o/o

Qo/o

-55o/o

nla-1o/o

90o/o

z%

-22o/o

17%

1 1o/o

-18o/o

$9,91 3,!1t517,099

62.510,4422,033,664

$9,1 r5,023524,659

$2,880,2382,033,67ô

AMW72.112.520.927.5

7.80.0

0.30.1o.4

145.3

AMW107.787.3

195.032.750.1

AMW73,812.821.528.2

0.24.20.30.10.3

149.0

17o/o

1Oo/o

1o/o

-5o/o

1o/o

-2oY'-18o/o

0o/o

-5o/o

4o/o

8o/o

7.6

19o/o

12o/o

40/o

-3%-2o/o

>2000/0

-7o/o

2o/o

-8%Oo/o

10o/o

4,544,106'1,281,613

1,040,084977,691195,09350,490

4,9't3,914696,958

1,704,667952,070221,904(21,740',)

92,237,0481,889,3704,'t26,4182,458,6632,687,669

898,202184,5851 24,336

10,479,873('t,349,471)(3,492,987)

(166,792\

______9,47!,623_

AMW76,904,000 106.862,908,000 87.4

139,812,000 194.214,849,000 20.6

10.023,564,80236,050,000

199,999,899 277.8175,472,239) (104.8)

(2,721,356) (3.8)'t29,957,000 180.5 121,806,304 169.2

8,089,077(864,746)(492,234\

0,651,0007,200.000

8,467,772(1,963,809)

701

AMW76,441,000 106.2 77,520,869ô2,804,000 87.3 02,864,229

139,305,000 193.5 140,385,098

-10/o

Qo/o

-1o/o

-7?o/o

-8Oo/o

-23o/o

-73./,-8o/o

7%

25o/o

-5o/o

-7o/o

61%

9.2

153,156,000 212.7(20,701,000) (28.8)(2,498,000) (3.5)

154,661,000(26,398,000)

(1,315,000)

-----t!,948,q99-

$67.76$43.09$29.51$51.12

214.8(36.7)

(1.8)176.3

$52.82$50.35$32.ô2$41.77

45,0295,073

820167

5531

438v

1,838377

ç42.34$52.78935.00$26.02

44,8914p84

812164

5532437

91,869

2%2%1o/o

2o/o

OVo

Qo/o

Oo/o

0o/o

-2o/o

2o/o

2o/"54,887370

54,073

ACTUAL ACTUALAMENOEDBUDGET

PCïVAR

PCTVAR

Page I

PUBLIC UTILITY DISTRICT NO. 1 OF BENTON COUNTYENERGY STATISTICAL DATA

YEAR TO DATE

ENERGY SALES RETAIL - REVENUEResidentialSmall Gene16l Serv¡ceMedium General ServiceLarge General ServiceLarge lndustrialSmall lnigationLarge lnigalionStreet LightsSecurity L¡ghtsUnmetered Accounts

Billed Revenues Before Taxes & Unbilled RevenueUnb¡lled Revenue

Energy Sales Reta¡l SubtotalCity Occupation TaxesBad Debt Expense (0.16010 ot reraitstes)

TOTAL SALES - REVENUE

ENERGY SALES RETAIL. KWhResident¡alSmall General Serv¡ceMedium General ServiceLarge General ServiceLarge lndustrialSmall lnigâtionLarge lnigationStreet L¡ghtsSecurity LightsUnmetèred Accounts

TOTAL KWh BILLED

NET POWER COSTBPA Power Costs

Sl¡ceBlock

SubtotalOther Power PurchasesFredericksonTransm¡ssionAncillaryConservation Progaam

Gross Power CostsLess Secondary Market Sales-EnergyLèss Secondary Market Sales-GasLess Transmission of Power for Others

NET POWER COSTS

NET POWER. KWhBPA Power

SliceBlock

SubtotalOther Power PurchasesFrederickson

Gross Power kVVlLess Secondary Market SalesLess Transmission Losses/lmþalance

NET POWER. KWh

COSï PER MWh: (dollars)Gross Power Cost (average)Net Power CostBPA Power CostSecondary Market Sales

AVERAGE ACTIVE SERVICE LOCATIONS:ResidentialSmall General ServiceMedium General ServiceLarge General ServiceLarge lndustrialSmall ln¡gationLarge lnigationStreet LightsSecurity LightsUnmetered Accounls

TOTAL

(209,600) (233,364)$122,69¡1,397 122,530,089

$'t17,264,4O519,000

117,122,37119,000

57,145,7024,662,374

12,020,421'13,506,698

3,092,375894,802

21,324,031196,929236,20'l184,872

56,710,5528,631,545

't2,149,5*13,756,1473,100,456

907,62621,176,935

254,923248,4481 86,1 74

1o/o

Oo/o

-'t%-2%0%

-1o/o

1o/o

-23o/o

-5o/o

-1o/o

0%Oo/o

0o/o

Oo/o

-10%Oolo

2o/o

1o/o

0o/o

-1o/o

1ô/o

-2%-2%

'lo/o

-3o/o

0%00/o

-1o/o

Oo/o

-1V'6o/a

-4o/o

Qo/o

-2o/o

-49o/o

oo/o

-60/o

4o/o

25o/o

0o/o

-2o/o

0o/o

-10/o

-70%-13%-160/o

-51%3%

-1%

AMW83.814.621.126.5

'1.6

48.'l

0.30.1

AMW82.414.521.126.8

7.3't.7

49.00.30.10.3

203.5

AMW109.0104.5213.560.032.0

305.5(e0.2)

(3.3)?12.0

AMW77.514.220.927.4

1.951.0

0.30.10.3

201.3

AMW't30.7102.7233.3

25.410.3

275.O(65.3)

(3.4)20ô.3

70/o

3%1o/o

-2'/"-2o/o

-'l2o/o

-50/o

1o/o

-3o/o

1o/o

2o/o

-102o/o

3o/o

4%7o/o

30/o

8o/o

3Vo

1o/o

-3o/o

-3o,/o

-14o/o

-69/o

0o/o

-60/o

0o/o

't%

0o/o

2o/o

1%630/o

190/o

Oo/o

2o/o

>20Oo/o

13o/o

'lo/o

'l4o/o

5o/o

15o/o

-'l8o/o

2o/o

-9o/o

-28o/o

71%-60/o

-33o/o

-1o/o

2%

53,257,1198,401,020

1 1,86'l ,1981 3,803,3923,143,142't,021,515

22,37't,9201 95,857244,169182,262

$114,481,594(1,000,000)

$113,/l81,5945,407,738

(196,000)

___!11!,99!.9!?_

621,327,353114,112,448167,774,943219,735,927

60,271,92015,265,188

409,030,2322,325,530

944,9282,728,923

1,615,5',t7,432

$31,295,01 I23,958,574

$55,253,59214,221,22812,302,91310,317,3352,300,809

58,161

$94,454,038(14,274,627)

(4,742,8O8)(1,309,933)

$74,12ô,670

1,O47,417,OO0823,030,000

1,870,447,000203,793,000130,351,000

2,204,591,000(523,1 24,000)

(27,60ô,000)1,653,8ôr,000

$1 17,283,¡105

5,620,592

671,660,928117,410,383169,359,739212,740,287

58,645,28013,145,651

385,692,5662,333,686

890,702

$31 ,371,85324,386,266

117 ,14't,3f 'l5,622,082

660,288,2011 16,551,5891 ô9,284,663214,477,981

58,265,37813,372,312

393,132,7532,321,689

916,616

$31 ,741,65024,386,384

$55,758,1 1 I23,1 98,59ô14,600,44910,272,3452,343,826

385,767

$56,128,0342'l,841,44615,224,29610,282,7ü2,391,663

760,230$10ô,559,102

(14,460,481)(s,425,453)

859,526,000837.778,000

$1 06,628,433(15,397,953)

(5,200,000)

873,375,922837,778,262

AMW107.2104.5

1,697,304,00014ô,04'f ,000223,'t47,000

1,711j#J84480,607,600256,850,000

2't1.718.227.8

2,066,492,000(352,5r9,000)

$s1.57$50.57$32.85$4r.02

257 .8 2,448,61 1,850(44.0) (722,927,670)

$43.55$49.98$32.80$21.30

18o/o

1o/o

0%93o/o

20o/o

130/o

11o/o

500/0

w2.84t44.82$29.54s27.29

44,5't44,970

802162

5547437

I1,889

373

2o/o

2o/o

2%2o/o

0o/o

-1o/o

0o/o

0o/o

-20/o

0o/o

2o/o

45,2875,053

820166

5543437

91,855

374

ACTUAL ACTUALAMENDEDBUDGET

PCTVAR

PCTVAR

s4,548

Page I

53,708

PUEIIC UÍUTY USTRICT NO.1 OF BENTON COUNWKWH SALES

MONTHTY ACTIVITY

1!neÂp¡r1r",1 ir I h lot¿llr rly ÂìlqL6l Sê|tember 0c,Oher Nover¡ber Dec¡rrrberlJúrrJr1 [,:hlr,lr'¡]

Res¡dential2015

20L62017201820r.9

Large lrr¡gat¡on20r.5

2016

20L7

20182019

8t,753,25r89,934,474

Lr4,O89,92390,52L,667

80,76s,20t

2I4,53222t,3L2200,892

233,t65292,485

70,842,4O7

72,255,049

97,473,61.869,963,306

92,696,s29

10,444,066to,6t5,42412,326,759

r0,6Qo,544t2,539,989

15,058,r-82

t5,r29,40L15,406,899L4,4L2,7731s,984846

L7,2t2,7L7

t7Ã45,84017,299,88918344,67LL7,721,024

5,394,485

5306,745s,319,8305,L58,240

5,300,040

32,98344,733

2ro,5g379,r79229,629

494,L43

218,680

5r,t95,4t753,460,88172,629,07864,L97,600

91.,330,363

8,399,9638,804,253

tL,375,2L99,492,590

rL,753,4r7

13,124,396

12,982,30815,083,r.30L3,22Q,L77

15,084933

L6,2L3,065

L6,492,L2018,510,883L7,025,842L7,O4L,004

5,337,365

5,715,9805,953,1605,695,840

5,994,520

648,290469,477

277,7tO!43,892

62,383

L4,636,6339,247,9841,485,633

10,909,657

r,056,287

43,964,172

45,886,79950,897,6085t,994,46253,9s6,825

8,630,5639,093,5178,459,5819,262,4329,33t,425

L3,6tL,24213,939,68113,953,993

13,836,65314,008,8¿18

L7,278,183L7,360342L7,69r,033L8,279,97L17,834,7L3

5,784,3305,547,175

s,9s9,9205,195,640

5,381,800

1,48L,2a6t,6o7,439

434,783846,58150L,057

39,362,24245,29t,45517,886,279

22,783,855

t9,869,269

38,845,198

38,72r34r40,4s4,5024t,172,29839,558,0s2

9,005,7889,2t7,5r48,9t4,5579,403,5799,O44,O84

14,078,88313,879,726L4,t57,Ot5L4,453,7L8L4,OO]-,OZ5

t7,939,803t7,583,7t2t8,24L,93rt9,674,682L7,972,240

5,632,3404,192,375

4,34?,2804,t57,8405,244,640

2,159,6162,203,347

L,70t,6062,!45,730L,949,657

61,259,90566,290,38254,086,389

64,6L6,t8055,855,505

48,99s,5s9

44,464,304

45,Or4,24846,00s,59446,696,925

ro,6L6,996LO,063,7t7r.0,148,595L0A08,t32ro,3L2,727

15,970,931!4,686,79715,250,364

15,432,46915,589,947

19,59s,384

t8,r40,663L8,951,19119,988,53519,710,360

5,678,570s,666,470

5,566,0805,739,O40

5,136,200

2,668,7822,637 8872,s0sJ092,676Fgs2,49spsg

LO3,84236988,901¡9993,753ß2886,922,059

94,826810

62,7sO,OOA

49,566,5ß55,425,63L52,40L,79t50,o87,72t

t2,060,700ro,760,436tL,42L,88011,068,45sto,626,4LO

L6ps7,56315,574,7OO

15,663,861

16,006,913L5,234,640

20,93s,183

18,545,91920,5!t,7L420,624,40720,089,880

4,98t,6205,704,8405,565,400

5,964,8403,46L,920

3,2L3,0862,835,670

3,L47,6733,29s,4762,65L,LOz

98,850,19088,434390

103,188,520

LOz,t95,462

90,606,935

58,699,674

57,564,3U62,752,408

63,971,76859,216,433

11,955,37011,863,201L2,O37,97812,734,5937r,945,446

L6,576,44016,5L6,30717,906,763

L7,702,795L6,761,798

20,741,66320,497,27L2r,497,99323,332,3t622,490,O40

6,77L,6955,9Ð8,980

6,072,640s,s36,080

5,9Ð9,720

3,002,6632,948,6082,79L,7532,9L6,3732,629,92L

67,471,44570,085,65970,975,O01

68,988,5il7t,725,rt2

48,136,350

49,472,576

53,038,58548,545,38653,t44,737

L0,809,84510,839,759L1,357,363r0,9L2,920tL,300,764

15,990,s72

l.6,093,62916,s09,9s416,o75,867

16,480,805

2],fos,r4019,923,65820,970,96021,583,3962L,740,520

5,623,8204,427,850

5,753,4405,3s3,960

5,492,600

2,O75,7842,005,457

1,809,7692,133,836L,79t,5rA

37,832,47233,735,65629,243,746

32,455,6L4

30,406,t37

37,850,154

38,810,55140,359,813

39,430,05642,3t3,L89

9,065,r979,285,2769,O27,734

8,908,3279,068,416

15,576,15415,538,49114,75L,4U15,031,084t5,o77,499

20,558,0202r,L79,80t20,501,0842L,498,12620,373,620

s,s98,5405,998,320

s,962,7605,976,320

5,818,520

r,r72302889,198928,403858,7694s2,470

24,467,38614,740,237

18,136,316

t6,382,99818,346,036

46,905,42I46,586,6454,793,49653,123,3e561,894,953

8,719,7478,652,1t39,272,7t99,t9t,224

10,080,9€.3

t4,712,9e4t4,7rr,rz7r5,o37,t;015,499,9i815,651,915

L8,687,46019,314,5i819,370,20420,269,12L19,184,900

5,408,7605,625,690

5,314,800s,498,280

5,555,880

2,8L6

L23,750r24,L27

99,6¿3

3,4L4,78L2,O22,639

2,582,79r3,O48,545

2,489,2t5

7556s,8ss75,018,Ls7

72,,-04,99775,,"79,7].5

10,515,898ro,807,22010,819,539

LO,75t,929

15,213,00475,377,85275,264,344

t5,349,864

L7,AI9,40018,¿195,415

18,s03,50918,470,O90

5,732,8654,?74,520

6,154,920s,724,800

?t4,ro9238,007281,800

268,713

665,504,166

66t,74t,688759,633,907697,LO7,L08

67L,660,928

L2L,497,780rzL,868,245tz9,o54,006124,864,3771L7,410,383

r82,6tO,322t80,466,703186,155,255

t83,t24,807169,359,739

226,t74,929223,267,9L9230,674,409238,606,0L72t2,740,287

66,941,88564,6L2,25t67,084,71065,996,720

s8,645,280

16,424,66415,597,288

!3,754,35415,311,53313,145,651

45t,777,rlg419,588,399

392,O50,824409,298,945

385,692,566

Small General Seruice2015 LL,273,6472016 11,865,34520!7 t3,896,O422018 12,129,6522Ot9 1L,4LO,702

M€d¡um General Seruice2015 L5,7L9,99L20L6 16,032,68420t7 L7,r70,3282018 16,103,0162Ot9 15,483,483

large General Seru¡ce2015 17,88&9r.12Q16 18,188,600zo17 1,4,624,01.82018 19,110,86020t9 18,581,986

LaÌge lndustr¡al20L5 5,597,495

.20L6 5,743,30620t7 5,118,88020L8 5,995,8402019 5,349,440

Small lrr¡gat¡on

2015201620L7

201820L9 64,!.08

91812Ð

(4)

;43,80246,34550,52ã

PAGE 10

PUBTIC UTIUTY DISTRICT NO. 1 OF BENTON COUNTYKWH SALES

MONTHLY ACTIVITV

Street Lights

2015

20!6201720182019

S€curlty Lights

20L520L62QL7

2018

20L9

Unmetered201520t6zoLT20LA20t9

Total2015

zoL620L72018

20t9

225,624

225,024

ztt,349¿lt,o46¿LL,760

LL4,45LLr3,273100,963

85,LL2

82,4s4

249,106257,045253,915242,8U245,945

133,037,008

14¿581,083169,666,306144,683,688

L32,487,564

225,624

224,8782rL,25321L,337

211,838

LL4,408113,196100,920

90,490

81,,7L5

249,106757,O45253,915254,423246,L54

t19,751,954t2r,827,338t48,622,7t2119,563,310

145,049,552

225,624

224,878

zLL,253zLL,343212,534

LL4,Q73

113,239

91,650

90,L4481,981

z49,LO6257,O45253,715255,332246,223

LLO,L44,332

LO7,768,L65L25,87L,43rL2L,242,4L7L42,863,æO

225,672

274,494zLL,253zlL,3tO212,284

1L3,696113,180

91,545

89,927

8t,924

248,9L9257,045253,7L5255,332246,223

130,700,305

!39,32t,L67115,839,710r22,756,163!2I,424,368

725,672

?LL,?352Lt,253zLr3LO¿L2,278

113,531101,3829t,42485,656

81,362

248,919257,O45

253,7L5

245,6U246,485

149,509,655

152,658,059142,450,672t56,2rO,t77t44,161328

22s,6722LL,L87

zLL,253zrL3rO212,3L2

113,488LOL,4Z5

9L,L3484,953aL,210

248,9t9257,O452$,715245,6U246,879

207,957,270

185,130,994t9L,745,5t7r87,7L4,77L

195,308,529

224,480

zLL,L87zLt,253zLt3rO2L2,3tO

113,488101,382

90,78284,383

81,090

248,9t9258,341253,715245,684246,956

220,335,637

t9L,997,4L32r5,480,4292t2,098,72t193,298,964

224,880

zLr,t872Lt,253¿LL,6342LZ,t34

Lt3,445101,409

90,860

84,206

80,347

254,930259,637253,7L5245,745246,964

185,2]..2,205

185,956,623194,580,3ilr95,724,064!9t,2r7,955

224,928

zLt,L872!1,253211,6502I2,IO7

Lt3,402101,36690,850

83,941

80,026

254,845259,637253,7t5245,945242,539

t42,367,t58L37,O70,775

L39,239,635L37,602,5L5

r40,89t,753

22s,O24

211-,L87

21r,2382u,6402I2,00r

113,359tot,t94

90,827

83,33479,542

255,749254,365253,7t5245,945256,297

114,881,885to7,008,6201L0,223,374108,626,599

tL2,397,590

225,024

zLL,3492lt,t252!r,6402t?,t28

113,359101,108

90,504

82,78279,051

257,045254,365253,926245,945254,79r

98,467,807

97,479,643L07,050,475r07,29s,007115,503,439

225,024

zLL,349ztL,0462lt,75t

113,309101,108

90,659

82,681

257,O45

254,365252,929245,945

125,6s6,509t25,277,997t24,327,545r27,33L,833

2,703,648

2,589,L422,534,7422,537,28t2,333,686

t,364,OO9t,263,2621,1t2,!18L,O27,609

890,702

3,022,6083,082,9803,044,40s2,974,8682,725,460

1,738,O2r,729

!,694,077,8771,785,O98,!70t,740,849,26st,634,604,682

PAGÊ 11

PUBLIC UT¡LITY DISTRICT NO. 1 OF BENTON COUNTYCAPITAL ADDITIONS AND RETIREMENTS

CURRENT MONTH

ADDITIONS RETIREMENTSBALANCE10t31120't9

BALANCE1 1 /30/20r I

INTANGIBLE PLANT:OrganizationsFranchises & ConsentsMiscellaneous & lntangible PlantTOTAL

GENERATION PLANT:Land & Land RightsStructures & lmprovementsFuel Holders & AccessoriesOther Electric GenerationAccessory Electric EquipmentMiscellaneous Power Plant EquipmentTOTAL

TRANSMISSION PLANT:Land & Land RightsClearing Land & Right Of WaysTransmission Station EquipmentTowers & FixturesPoles & FifuresOverhead Conductor & Devices

TOTAL

DISTRIBUTION PLANT:Land & Land RightsStructures & lmprovementsStation EquipmentPoles, Towers & FixturesOverhead Conductor & DevicesUnderground ConduitUnderground Conductor & DevicesLine TransformersServices-OverheadServices-UndergroundMetersSecurity LightingStreet LightingSCADA System

TOTAL

GENERAL PLANT:Land & Land RightsStructures & lmprovementslnformation Systems & TechnologyTransportation EquipmentStores EquipmentTools, Shop & Garage EquipmentLaboratory EquipmentCommunication EquipmentBroadband EquipmentMiscellaneous EquipmentOther Capitalized Costs

TOTAL

TOTAL ELECTRIC PLANT ACCOUNTS

PLANT HELD FOR FUTURE USE

CONSTRUCTION WORK IN PROGRESS

(3,138)

2¡14,209,863 535,098 (13,746) 244,73',1,215

1,130,759 1,130,75918,75s,144 130,863 - 18,886,0079,715,412 9,715,4128,663,790 4,820 - 8,668,610

54,108 54,108521,852 521,852561,798 561,798

2,542,694 2,542,69423,459,743 34,497 - 23,494,2401,141,835 1,141,835

11,977,249 31,713 - 12,008,96278,524,384 201,893 - 78,726,277

335,032,771 736,991 (13,746) 335,756,016

388,589 388,589

7,860,371 2,920,162 - 10,780,533

343,281,73',t 3,657,153

$28,37910,02229.078

$0 $0 $28,37910,02229,078

$67,¡179

1,141,911

770,459

67,479

1,141,911

770,459

1,912,370

156,40025,544

832,047256,175

4,998,4524,050,057

1,912,370

156,40025,544

832,04725q175

4,998,4524,050,057

t 0,318,675

1,795,430295,502

44,179,25621 ,969,1 9814,630,54938,946,32350,047,90'l33,216,436

3,02s,63621,324,64610,628,818

861,379788,261

2,500,528

284,587

(282,122)70,681

1,36384,50476,78076,81111,72063,720

9,351442190

137,071

(9,543)(1,065)

10,318,675

2,080,017295,502

43,897,13422,030,33614,630,84739,030,827s0,124,68133,293,247

3,037,3s621,388,36610,638,169

858,683788,451

2,637,s99

;2.166.590 Budqet

TOTAL CAPITAL

PAGE 12

($r3,746) $346,925,138

PUBLIC UTILITY DISTRICT NO. 1 OF BENTON COUNTYCAPITAL ADDITIONS AND RETIREMENTS

YEAR TO DATE

ADDITIONS RETIREMENTSBALANCE't2t31t2018

BALANCE11t3U2419

INTANGIBLE PLANT:OrganizationsFranchises & ConsentsMiscellaneous & lntangible PlantTOTAL

GENERATION PLANT:Land & Land RightsStructures & lmprovementsFuel Holders & AccessoriesOther Electric GenerationAccessory Electric EquipmentMiscellaneous Power Plant EquipmentTOTAL

TRANSMISSION PLANT:Land & Land RightsClearing Land & Right Of WaysTransmission Station EquipmentTowers & FiXuresPoles & FixturesOverhead Conductor & Devices

TOTAL

DISTRIBUTION PLANT:Land & Land RightsStructures & lmprovementsStation EquipmentPoles, Towers & FixturesOverhead Conductor & DevicesUnderground ConduitUnderground Conductor & DevicesLine TransformersServices-OverheadServices-UndergroundMetersSecurity LightingStreet LightingSCADA System

TOTAL

GENERAL PLANT:Land & Land RightsStructures & lmprovementslnformation Systems & TechnologyTransportation EquipmentStores EquipmentTools, Shop & Garage EquipmentLaboratory EquipmentCommunication EquipmentBroadband EquipmentMiscellaneous EquipmentOther Capitalized Costs

TOTAL

TOTAL ELECTRIC PLANT ACCOUNTS

PLANT HELD FOR FUTURE USE

CONSTRUCTION WORK ¡N PROGRESS

156,4002s,544

832,047256,175

4,998,4524,050-q57

$28,37910,02229,078

$o $0 $28,379'to,o2229,078

$67,479

1,141,911

770,459

67,479

1 ,141,911

770,459

1,912,370

156,40025,544

832,047256,175

4,998,4524,050,057

'l,912,370

10,318,675

1,762,927295,502

40,769,31321,406,31913,896,48637,654,84648,493,86831,837,633

2,934,21920,638,00710,412,170

867,764781,212

2.470.679

317,090

3,127,821729,',t34790,1s6

1,389,0941,736,4061,577,851

103,137750,359225,999

6,7857,808

166,920

(105,1 17)(55,7e5)(13,1 13)

(105,s93)(122,237)

10,318,675

2,080,01729s,s02

43,897,13422,030,33614,630,84739,030,82750,124,68133,293,247

3,037,35621,388,36610,638,169

858,683788,451

2,637,599

(1s,866)(56e)

1,130,75918,739,8959,288,2928,347,206

54,108487,239489,135

2,528,66121,657,090

1,141,835

146,112427,120534,344

34,61372,66314,033

1 ,837,1 50

234,220,945 10,928,560 (418,290) 244,731,2',15

(212,940)

1 ,130,7s918,886,0079,715,4128,668,610

54,108521,852561,798

2,542,69423,494,240

't,141,835

(ffir,230) 335,756,016

- 388,589

- 10,780.533

11,662,314 346,648 - 12,008,96275,526,534 3,412,683 (212,9401 78,726,277

322,046,003

388,589

6,911,759

14,341,243

3,969,774

329,346,351 18,210,017

21.318.066 Budqet

TOTAL CAPITAL

PAGE 13

($631,230) $346,925,138

PUBLIC UTILITY DISTRICT NO. I OF BENTON COUNrySTATEMENT OF CASH FLOWS

YTD11t34t2019

Monthly1'v30t2019

CASH FLOWS FROM OPERATING ACTIVITIESCash Received from Customers and CounterpartiesCash Paid to Suppliers and CounterpartiesCash Paid to EmployeesTaxes PaidNet Cash Provided by Operating Activities

CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIESOther lnterest ExpenseNet Cash Used by Noncapital Financing Activities

CASH FLOWS FROM CAPITALAND RELATED FINANC¡NG ACTIVITIESAcquisition of Capital AssetsProceeds from Sale of Revenue BondsReimbursement of Bond ExpenseBond Principal PaidBond lnterest PaidCapital ContributionsSale of AssetsNet Gash Used by Capital and Related Financing Activities

CASH FLOWS FROM INVESTING ACTIV¡TIESlnterest lncomeProceeds from Sale of lnvestmentsPurchase of lnvestmentsJoint Venture Net Revenue (Expense)Net Cash Provided by lnvesting Activities

NET TNCREASE (DECREASE) rN CASH

CASH BALANCE, BEGINNING

CASH BALANCE, ENDING

RECONCILIATION OF NET OPERATING INCOME TO NETCASH PROV¡DED BY OPERATING ACT¡VITIES

Net Operating Revenues

Adjustments to reconcile net operating income to net cashprovided by operating activities:

Depreciation & AmortizationUnbilled RevenuesMisellaneous Other Revenue & ReceiptsGASB 68 Pension ExpenseDecrease (lncrease) in Accounts ReceivableDecrease (lncrease) in BPA Prepay ReceivableDecrease (lncrease) in lnventoriesDecrease (lncrease) in Prepaid ExpensesDecrease (lncrease) in Wholesale Power ReceivableDecrease (lncrease) in Miscellaneous AssetsDecrease (lncrease) in Prepaid Expenses and Other ChârgèsDecrease (lncrease) in Deferred Derivative Outflowslncrease (Decrease) in Deferred Derivative lnflowslncrease (Decrease) in Warrants Outstandinglncrease (Decrease) in Accounts Payablelncrease (Decrease) in Accrued Taxes Payablelncrease (Decrease) in Customer Depositslncrease (Decrease) in BPA Prepay lncentive Creditlncrease (Decrease) in Other Current Liabilitieslncrease (Decrease) in Other Credits

$148,824,375(114,509,485)

(13,679,065)(13,471,974j

$11,471,194(8,258,677)(1,191,660)

(69e,50e)7,,l 63,851

(25,333)

1,321,348

(25,333)

(17,818,559)

(3,750,000)(2,418,649)1,958,929

50,757

(3,609,930)

176,410122,160

't,158(21,977,5221

1,125,8037,940,776

(85,2s6)8,991,323

(5,857,681)

$47,760,364

(3,310,2021

78,7242,000,000

2,078,724

89,870

$41,812,813

$41,902,683 $41,902,683

($2,438,316) $458,407

9,338,316(1e,000)27,087

1,113,589550,000(24,740)(2ô,180)756,811101,777

2,112,9083,150,263

(1,582,708)

(1,361,211)(504,017)

87,419(47,e18)225,787

(4,196,116)

845,127(585,000)

3,257

(235,672)50,000

302,251(8,r€)16,761

42896,21572,424

(48,015)

170,979409,252

8,933(13,438)(27,34e)

(195,069)

Net Cash Provided by Operating ActivitiesPAGE 14

$7,163,851 i1,321,348

re807060

850E40gt3

10

Jan Feb March April May June July Aug Sept Oct Nov Dec

E¡Normal l'2019 Ë2018

Average TemperatureYear Jan Feb l/larch April fúlay June July Aug Sept Oct Nov Dec Annual

Historical Avg 33.4 38.2 46.5 53.4 62.1 69.6 77.1 75.8 66.4 53.1 40.5 56.0

201 I 35.1 24.8 37.4 55.5 65.6 7't.'l 75.9 77.3 65.7 48.2 38.1 54.1201 I 37 -7 38.6 45.8 53.8 68.7 69.8 80.6 76.4 65.4 52.4 39.6 57.2S-yr Avg 32.7 38.7 47.9 55.4 65.8 72.5 80.4 78.0 66.6 55.4 41.1 57.7

PUBLIC UTILITY DISTRICT NO. I OF BENTON COUNTYWEATI{ER STATISTICS

November 30,2019

Yea¡ Jan Feb March Apr¡l ifay June Juty ,Aug Sept Oct Nov Dec AnnualH¡storical Avg 0.94 0.70 0.57 0.55 0.51 0.51 0.23 0.18 0.31 0.49 0.95 5.94

2019 1.17 1.65 0.44 0.7'l 0.92 0.30 0.36 2.35 0.27 0.50 0.09 8.76

2018 1 .10 0.35 0.35 1.25 0.81 0.23 0.01 0.93 0.75 5.78

5-yr Avg 1.01 0.79 0.76 0.61 0.62 0.25 0.07 0.19 0.12 1.06 0.75 6.22

Cooling Degree Days (GDDs) for Each Day of Billing Cycle

tnoê()

800700600500400300200100

0Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov

-201712018-201812019@=.!45 YearAvg

Each po¡nt on this graph repr€sents thetotal number of CDDS for the preceding3Gday period, i.e., the cumulative CDDSthat are b¡lled on November 15 occunedbetween October 15 - November 14.

-^--¿q

e-F z--/ v \\úts \\

ãGJ- --l 3\-.

Cooling Degree Days by MonthYear Jan Feb i/larch Apr¡l May June July Aug Sept Oct Nov Dec Total

201 I 2 88 200 337 380 105 't,1122018 6 14'l 165 485 356 6B 1,221

S-yr Avg 6 94 244 476 402 96 7 't,325

Gumulative GDDs in Billing Cycle2019 22 1,019 4,952 7,888 't't,726 8,048 817 34,472

2018 19 1,997 4,305 9,442 15,375 6,163 550 37,851

5-yr Avg 76 1,161 4928 1'.t,5't2 't4,575 7,445 1,338 52 41,087

Heating Degree Days (HDDs) for Each Day of Billing Cycle

øoo4

1,4001,2001,000

800

600400200

0Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov

-2017/2018-2018/20t9*5 Year Avg

Year Jan Feb March Apr¡l May June July Aug Sept Oct Nov Dec Total

2019 923 1,127 857 289 71 18 85 524 807 4,701

2018 843 740 593 344 25 20 2 60 391 761 3,779

S-yr Avg 1,001 741 528 295 69 17 0 49 304 715 3,719

Cumulative HDDs ¡n B¡ll¡n2019 27,518 29,935 36,050 15,003 5,907 1,209 177 318 9,220 20,244 145,581

2018 31,408 20,959 24,003 14,655 5,141 729 215 11 569 7,040 16,205 120,939

5-yr Avq 32,971 25,338 21,317 12,446 5,687 1,129 250 2 519 4,809 14,765 't19,232

PAGE 15

PUBLIC UTILITY DISTRICT NO. 1 OF BENTON COUNTY

BROADBAND SUMMARY

Novembet H¡ghl¡ghß

contract.

l@pt¡'Ðto Dâtê

22,509,963

12,531,872

12 12¡ A)l

24-552-693

l,t,7 12,7291

(6,88s,1¡13)

5,0t4,108

2,232,671

__-_l!,!91¡9Ð"

s3,159,092

14t,346

___s3,309¡38_

l*t,t¡ll,04lI

($9,56C,60St

($6,266,1711

2û79 arf9

AreidêdBsdoet

ACTUALSOrþ¡ufE{dqe{ tã Fá kd tudt Mfl Julv tudusl 9d d k WD

BudgetRMâínind

OPERAÎING REVENUES

Ethenet

Non-Recuûìng Charges - Ethemet

TDM

Wheleslntemet Transpod SeN¡æF¡xed W¡relesAcæs lntemetNon-Recuring Charges - Al

Broadband Revenue - OherSrblo¿a/

l,¡180,953 l¡80,953 s124,1221,500

3,000

3,112

3,141

17,619

$1 18,914

2,000

3,000

26

3,598

3,094

17,73A

$1 18,677

500

3.000

26

22153,074

18,395

1,700&595

$118,81,1 $119,092500 1,500

3,000 3,00026?5

2,233 2,2353,003 2,552

19,5€5 20,2552,000 1,050

¿6 304 51 33¿

$'t 18,463 $128,235

5,300

3,000

26

3,989

1,250

$130,566

1,000

3,000

æ6,174

2,668

22,O91

3,400

$130,680 $130,558 $1 30,1651,450

3,000

26

5,267

2,599

21,807

3250

$1,368,285

1 3.750

33,000

286

41 24631,361

228,559'17,513

I 12,668

(13,750)

3,000

'l¿12,751

10,639

21,111

(l7,sr3)21 6Ã1

36p00

300

54,000

42pOO

250,000

36,000

300

54,000¡r2,000

250,0o0

3,000

ú2,'t89

20,571

913

3,000

5,067

2,621

23,016

1,000

3,000

26

5,169

2,599

23,357

2,2007s0550.OOO 550_OOO & 5E5 4 5C5

2,413,253 2,413.?.s3 197,A64 '192,965 192jA2 195,468 201,443 196,480 214202 217,424 213,905 215,401 219,059 2,256,398

NoaNet Maintenance Revenue

Bad Dêbt Eeeße

Total Opereting Revenues

OPÊRATING ÊXPENSES

2,413,253 2,¡r13,25s 197,864 192,965 192,182 195,468 201,443 196,480 214,202 217,424 213,905 215,404 219,059 $2,256,398 156¡55

Genenl Epensæß)

Other Ma¡ntenanæ

NOc Ma¡ntenanceW¡rdes Maintenaîce

S0b¿o¿a/

61¡071,036

63,198

14,098

1 1 5,540

(¿es8)77,393

6,431

69,028 66,O27

3,503

't 05,268

3,923

74,650 92,241 70,4065,963

109,578

11,102

$904,699

$38,887

10,317

$0

716

1 0,317

9,18,000 948,000 62,443 77297 107,542 83,823 69,1'11 69,530 109,'9î 85,7'13 s2,204 76.369 120,680 $953,903 (5,903)

NoaNet M¿inlenance E¡pense

Deoredafion 775.145 775.145 66 57 66 049 s 10a 66 250 67 333 6q ô37 69 a1) 7õ õ¿1$o

u, ,44

Total Opñing Expenses f85

oPERAT|NG TNCOME (LOSS' 5S,068 690,068 69,054 49,580 18,532 45,3S5 65,000 58,742 35,974 62,399 52,357 69,2î7 28,338 $554,608 135,460

REVENUES & EXPENSESlr¡temal lnterest due b Pmr Business UnitÍ) (39,532) (332,532) 127,465, (27,383) (27,387) (27,166) (26,917J 126,8231 Q6:t11] (26,29t) (26,09Ð C26,213t (26,333) ($2s4,849) 37,683

CONTRIBUIIONS

Confibutions in Aid of Broadband

ATOP

1,3E0 573 3,925 476 2302 40,'146 8,368 6,814 $63,9E5 63,985

Membd AssesrenbMenbæh¡p Sepo¡t

EIPEI'¡OIIUffi ¡r¡63,464

$111,799

9ltl,79tt

¡r¡$,,rs¿

$t 1 I,799

$rfi,799

¡52318

$83,677

84,584

$87,650

2E,001

28,592

s90,æ5

f,640)

(r,640)

t36,955

75,166

75,'t 66

$59,654

74,412

74,971

$8,r.59 1

42,360

42,ø

s66,6',32

36,E8 1

38,379

t27,010

143,8't6

141,U7

¡55.514 Í97.020

6s,926 (49,617)

66,187 (49.6,t7)

st35.6t I

(30,,r17)

(30,417)

$893,069

$468,565

$473311

3.¡60¡85

3s6¡66(royFRo¡f BRoADBANOeI

FOyFROM BROA|BANO(Exclt¡d¡ng N@Net cosb)

Itd€s RætuâblêNoþs ReceiEble

Beghn¡lg Balæ Ênd¡ng Balenæ4s256.4185,256

(1) lnternal ¡nterst budget ¡s 6lifrated based on cash flow projedioF (an ¡nterest raÞ of 3.53% ¡s beìng usd).(2) lndudes ex€s of revenuæ over opeÊting cosb, capi¡al expendibres and NoaNet ass6sments; dc¡udes depreciat¡on and intemal intere$ to Eledric S!6tem(3) The March general expeßæwere updated b refedlhe amodizaton ofa City of Richland build, thatws p6ted âlterthe Mard broadband ¡nformat¡on was prepared.

PAGE 1 6

,ernræ-a-0

Payroll ReportPay Period Ending November 24, 2019

zglcAmended

Budqet2019

Actual

uver (unoe4Actual toBudqet

2019OriginalBudoetDirectorate Deoartment

Executive Admin¡stration

(1.00)

1.00

(1.00)

(1.00)

(1.00)

1.00

1.00

4.004.002.OO

4.004.002.OO

4.004.002.OO

1 8.005.00

1 8.005.00

17.O05.00

2.OO

3.006.003.00

2.003.007.003.00

2.003.006.003.00

7.009.003.007.OO

7.009.003.007.00

7.009.003.007.00

6.0033.00

2.OO

5.006.004.007.00

6.0033.00

2.OO

5.006.004.007.00

7.OO

32.002.006.006.004.00

6.00

7.00'I 1.00

7.00I'1.00

6.00'11.00

General ManagerHuman ResourcesCommunicat¡ons & Governmental Affairs

Customer Programs & ServicesCustomer ServiceProsser Customer Service

F¡nance & Business ServicesDirector of FinanceTreasury & Risk ManagementAccountingContracts & Purchasing

Eng¡neer¡ngEngineeringCustomer EngineeringPower ManagementEnergy Programs

OperationsOperationsSupt. Of Trânsmission & DistributionSupt. of OperationsMeter ShopTransformer ShopAutomotive ShopSupport Services

lnformation TechnologylT lnfrastructurelT ADÞlications

Position Department20't9

Budqet '1112412019ActualYTD

% YTDto

BudqetNECA Lineman/MetermanSummer lntemStudent WorkerlnternTemporary Records ClerkCSR On-Call - ProsserCSR On-Call - Kennewick

OperationsEngineeringWarehouseITExecutive AdministrationProsser BranchCustomer Service

3,120520

2,335502353408138

1,l652,229

75o/o

96%

2,0802,600 33

56%860/o

Totel Âll Cônllndent Pôßltlons 8.320 33 7.13ü Bd/oCônt¡nûent Ym Full TImè Eou¡vålentß ÍFTEI 4.00 3.43

Hours

* All Paid Leave includes personal Ieave, holidays, sltort-term disability, L&1,jury duty poy, and military leøe pay.

83.3% thtoughthe War

As of 1 1/30/2019

2015Am€nded2019

Labor YTDActual %s14,123,697

688.517$14,023,696 $12,525,242

788.517 724.57989.3%

91.9o/o

Regular

Ovêrtime14,812,214 14,812,213 13,249,821 89.5%Subtotal

Less: Mutual Aid

Îôtâl 314.812,213 $13.249.821 89.570

oovenime lAll Pa¡d Leave' lRegular

Annual 201811t24119

100o/o

75o/o

5Oo/o

25o/o

Qo/o

Pay Period Ending YTD 2019

PAGE 17