Spreadsheet: jeffrey_a_shankman__14011__dwr purchases analysis MEF3
Sheet: prices by public-private

 |  | JANUARY |  |  | FEBRUARY |  |  | [NAME] |  |  | TOTAL
 |  | MWh | $$ | Avg. Price | MWh | $$ | Avg. Price | MWh | $$ | Avg. Price | MWh | $$ | Avg. Price
City of Seattle | SCL1 | 3765 | 2390850 | 635.0199203187251 | 105 | 63375 | 603.5714285714286 | 0 | 0 | 0 | 3870 | 2454225 | 634.1666666666666 | Public
[NAME] | MID1 | 0 | 0 | 0 | 175 | 87500 | 500 | 0 | 0 | 0 | 175 | 87500 | 500 | Public
Powerex | PWRX | 162716 | 77185725 | 474.3585449494825 | 359167 | 183583504 | 511.1368917523046 | 282418.72 | 139664793 | 494.5309326520565 | 804301.72 | 400434022 | 497.8654304009197 | Public
Tacoma Power | TPWR | 246 | 127075 | 516.5650406504066 | 2818 | 1202285 | 426.6447835344215 | 2825 | 1470425 | 520.5044247787611 | 5889 | 2799785 | 475.4262183732382 | Public
Eugene Water & Electric Board | EWEB | 44322 | 22041125 | 497.2953612201616 | 65473 | 29465125 | 450.0347471476792 | 42055 | 14149375 | 336.4492925930329 | 151850 | 65655625 | 432.3715837998024 | Public
[NAME] PUD | GCPD | 2500 | 1170000 | 468 | 29125 | 9984000 | 342.7982832618026 | 59584 | 20602940 | 345.7797395273899 | 91209 | 31756940 | 348.1777017618875 | Public
WAPA | WAPA | 0 | 0 | 0 | 5369 | 2213120 | 412.2033898305085 | 9388 | 2680925 | 285.5693438432041 | 14757 | 4894045 | 331.6422714643898 | Public
SMUD | SMUD | 75 | 14250 | 190 | 12495 | 4861375 | 389.0656262505002 | 34985 | 10833600 | 309.6641417750465 | 47555 | 15709225 | 330.3380296498791 | Public
City of Glendale | GLEN | 14400 | 5400000 | 375 | 0 | 0 | 0 | 12925 | 3535050 | 273.504835589942 | 27325 | 8935050 | 326.9917657822507 | Public
BPA | BPA1 | 0 | 0 | 0 | 100838 | 30633830 | 303.7925186933497 | 360306 | 109849580 | 304.8785754331041 | 461144 | 140483410 | 304.6410882500911 | Public
LADWP | LDWP | 205673 | 53023046 | 257.8026576167022 | 456974 | 137185915 | 300.2050773129325 | 142832 | 45220236 | 316.5973731376722 | 805479 | 235429197 | 292.2847113332564 | Public
City of Santa Clara | SNCL | 400 | 116000 | 290 | 0 | 0 | 0 | 0 | 0 | 0 | 400 | 116000 | 290 | Public
City of Burbank | BURB | 860 | 249400 | 290 | 7935 | 2425075 | 305.6175173282924 | 20145 | 5230050 | 259.620253164557 | 28940 | 7904525 | 273.1349343469247 | Public
MSR Public Power Agency | MSR | 52 | 10400 | 200 | 13 | 6175 | 475 | 0 | 0 | 0 | 65 | 16575 | 255 | Public
West Area Lower Colorado | WALC | 0 | 0 | 0 | 75 | 4500 | 60 | 665 | 183500 | 275.9398496240602 | 740 | 188000 | 254.0540540540541 | Public
Turlock Irrigation District | TID | 220 | 27177 | 123.5318181818182 | 5180 | 1357950 | 262.1525096525097 | 5275 | 1148160 | 217.660663507109 | 10675 | 2533287 | 237.3102576112412 | Public
WAPA | WAMP | 0 | 0 | 0 | 0 | 0 | 0 | 552 | 116080 | 210.2898550724638 | 552 | 116080 | 210.2898550724638 | Public
CDWR | CDWR | 81301.9 | 18050264 | 222.0152788557217 | 116352 | 23679438 | 203.5155218646865 | 89800 | 17271124 | 192.3287750556793 | 287453.9 | 59000826 | 205.253176248435 | Public
Com. de Federale Electricidad | CFE1 | 2802 | 644460 | 230 | 26350 | 5474250 | 207.7514231499051 | 21600 | 3672000 | 170 | 50752 | 9790710 | 192.9127916141236 | Public
City of Riverside | RVSD | 0 | 0 | 0 | 330 | 62700 | 190 | 0 | 0 | 0 | 330 | 62700 | 190 | Public
NCPA | NCPA | 6190 | 1585150 | 256.0823909531503 | 5584 | 1040210 | 186.2840257879656 | 15398 | 2452400 | 159.2674373295233 | 27172 | 5077760 | 186.8747239805682 | Public
EBMUD | EBMU | 0 | 0 | 0 | 0 | 0 | 0 | 1424 | 246352 | 173 | 1424 | 246352 | 173 | Public
Salt River Project | SRP1 | 14705 | 2705275 | 183.9697381842911 | 60691 | 10013925 | 164.9985170783147 | 4680 | 827625 | 176.8429487179487 | 80076 | 13546825 | 169.1745966331985 | Public
City of Vernon | VERN | 525 | 82875 | 157.8571428571429 | 9789 | 1734847 | 177.2241291245275 | 11831 | 1762567 | 148.9787000253571 | 22145 | 3580289 | 161.6748250169339 | Public
City of Anaheim | ANHM | 2647 | 461280 | 174.2652058934643 | 22558 | 3454610 | 153.1434524337264 | 8327 | 1201233 | 144.2575957727873 | 33532 | 5117123 | 152.6041691518549 | Public
Portland General Electric | PGE1 | 475 | 318071 | 669.6231578947369 | 0 | 0 | 0 | 0 | 0 | 0 | 475 | 318071 | 669.6231578947369 | Private
Avista Energy | AEI1 | 180 | 90000 | 500 | 0 | 0 | 0 | 0 | 0 | 0 | 180 | 90000 | 500 | Private
(New Century Energies | PSCO | 50 | 25000 | 500 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 25000 | 500 | Private
Coral Power, L.L.C | CRLP | 62645 | 33602570 | 536.3966797030888 | 34606 | 15848650 | 457.9740507426458 | 22282 | 8108815 | 363.9177362893815 | 119533 | 57560035 | 481.5409552173876 | Private
Sempra Energy Trading | SETC | 145622 | 63770165 | 437.9157338863633 | 395939 | 183795865 | 464.2024781595145 | 198282 | 74011547 | 373.2640733904237 | 739843 | 321577577 | 434.6565109083954 | Private
Puget Sound Energy | PSE1 | 100 | 40000 | 400 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 40000 | 400 | Private
Sierra Pacific Power | SPPC | 3930 | 1390900 | 353.9185750636132 | 2600 | 1064750 | 409.5192307692308 | 0 | 0 | 0 | 6530 | 2455650 | 376.0566615620214 | Private
Trans Canada Power | TCPTC | 0 | 0 | 0 | 22595 | 8712520 | 385.5950431511396 | 42275 | 14901922 | 352.4996333530455 | 64870 | 23614442 | 364.0271620163404 | Private
PacifiCorp | PAC1 | 12400 | 4362000 | 351.7741935483871 | 1563 | 508450 | 325.3039027511197 | 0 | 0 | 0 | 13963 | 4870450 | 348.8111437370193 | Private
Avista Energy | AVST | 475 | 217500 | 457.8947368421053 | 3100 | 1007500 | 325 | 0 | 0 | 0 | 3575 | 1225000 | 342.6573426573427 | Private
AEP Services | AEPS | 10324 | 4647500 | 450.1646648585819 | 13215 | 3376250 | 255.4861899356792 | 0 | 0 | 0 | 23539 | 8023750 | 340.8704702833595 | Private
TransAlta | TEMU | 10568 | 5656425 | 535.240821347464 | 13586 | 4663500 | 343.2577653466804 | 227954 | 74652305 | 327.4884625845565 | 252108 | 84972230 | 337.0469402002316 | Private
Mieco, Inc. | MIEC | 63366.8 | 25052130 | 395.3510355580524 | 16200 | 4774000 | 294.6913580246913 | 90800 | 26478000 | 291.6079295154185 | 170366.8 | 56304130 | 330.4876889159156 | Private
Avista | WWPC | 425 | 131750 | 310 | 3297 | 1043600 | 316.5301789505611 | 0 | 0 | 0 | 3722 | 1175350 | 315.7845244492208 | Private
PG&E | PGAE | 400 | 162000 | 405 | 1494 | 373865 | 250.2443105756359 | 0 | 0 | 0 | 1894 | 535865 | 282.9276663146779 | Private
[NAME] | WESC | 39320 | 9366300 | 238.207019328586 | 371814 | 121627650 | 327.1196081911924 | 707935 | 180334966 | 254.7337905316166 | 1119069 | 311328916 | 278.2035030905154 | Private
Cargill | CARG | 0 | 0 | 0 | 800 | 220000 | 275 | 0 | 0 | 0 | 800 | 220000 | 275 | Private
BP Energy | BPEC | 1200 | 272000 | 226.6666666666667 | 38725 | 12966380 | 334.8322788896062 | 46812 | 8789052 | 187.7521148423481 | 86737 | 22027432 | 253.9565813897183 | Private
PS of New Mexico | PNMM | 11942 | 3443050 | 288.3143527047396 | 57138 | 17331125 | 303.3204697399279 | 199661 | 46670090 | 233.7466505727208 | 268741 | 67444265 | 250.9638090205812 | Private
Dynegy | ECH1 | 47380 | 14763600 | 311.599831152385 | 216564 | 62886259 | 290.3818686392937 | 617802 | 133639070 | 216.3137542448875 | 881746 | 211288929 | 239.6256166741896 | Private
APX | APX1 | 0 | 0 | 0 | 15959 | 3785080 | 237.1752616078702 | 54 | 6480 | 120 | 16013 | 3791560 | 236.7801161556235 | Private
Reliant | NES1 | 43385 | 6846000 | 157.7964734355192 | 264186 | 60459790 | 228.8531186361124 | 141393.82 | 38782230 | 274.285184458557 | 448964.82 | 106088020 | 236.2947279477265 | Private
Merrill Lynch Capital | MERL | 49560 | 12360300 | 249.4007263922518 | 109310 | 25266240 | 231.1429878327692 | 176628 | 38637897 | 218.7529553638155 | 335498 | 76264437 | 227.3171136638668 | Private
Mirant | MAEM | 239155 | 64842275 | 271.1307520227468 | 1103212 | 242614135 | 219.916149389238 | 1797133 | 398852963 | 221.9384781204285 | 3139500 | 706309373 | 224.9751148272018 | Private
Calpine | [NAME] | 1400 | 381000 | 272.1428571428572 | 59336 | 13399640 | 225.8264797087771 | 4224 | 729600 | 172.7272727272727 | 64960 | 14510240 | 223.371921182266 | Private
Pinnacle West | PWEPW | 21700 | 5261500 | 242.4654377880184 | 75902 | 18163350 | 239.3000184448368 | 104186 | 20907785 | 200.6774902578082 | 201788 | 44332635 | 219.6990653557199 | Private
El Paso Power Services | EPPS | 12929 | 3672830 | 284.0768814293449 | 51154 | 10053985 | 196.5434765609727 | 165956 | 34171371 | 205.9062100797802 | 230039 | 47898186 | 208.2176761331774 | Private
Strategic Energy, Ltd. | SEL1 | 0 | 0 | 0 | 5535 | 1052340 | 190.1246612466125 | 4251 | 833407 | 196.0496353799106 | 9786 | 1885747 | 192.6984467606785 | Private
PG&E Energy Trading | PGET | 14980 | 3935644 | 262.7265687583445 | 25485 | 3502364 | 137.4284481067295 | 86990 | 16975319 | 195.141039199908 | 127455 | 24413327 | 191.5446785139853 | Private
Nevada Power Company | NVPM | 4638 | 1015260 | 218.9003880983182 | 55782 | 12249600 | 219.5977196945251 | 66525 | 10216700 | 153.5768508079669 | 126945 | 23481560 | 184.9742802000866 | Private
Enron Power Marketing | EPMI | 13200 | 4950000 | 375 | 82400 | 12403000 | 150.5218446601942 | 151200 | 27399600 | 181.2142857142857 | 246800 | 44752600 | 181.3314424635332 | Private
San Diego Gas & Electric | SDG3 | 4962 | 1040830 | 209.7601773478436 | 5315 | 1060950 | 199.6142991533396 | 8800 | 1256000 | 142.7272727272727 | 19077 | 3357780 | 176.0119515647114 | Private
Sempra Energy Solutions | SES | 0 | 0 | 0 | 1603 | 286826 | 178.930754834685 | 1830 | 313170 | 171.1311475409836 | 3433 | 599996 | 174.7730847655112 | Private
Tucson Electric Power | TEP | 250 | 47500 | 190 | 10635 | 1852075 | 174.1490362012224 | 38637 | 6718000 | 173.8747832388643 | 49522 | 8617575 | 174.0150842049998 | Private
California PX | PXC1 | 29200.4 | 5071897 | 173.6927233873509 | 0 | 0 | 0 | 0 | 0 | 0 | 29200.4 | 5071897 | 173.6927233873509 | Private
Commonwealth Energy | CEEA | 6620 | 948000 | 143.202416918429 | 17210 | 2530110 | 147.0139453805927 | 40857 | 7284385 | 178.2897667474362 | 64687 | 10762495 | 166.3780203132005 | Private
Allegheny Energy Trading | AETS | 0 | 0 | 0 | 0 | 0 | 0 | 166027 | 26098697 | 157.195498322562 | 166027 | 26098697 | 157.195498322562 | Private
Duke | DETM | 69847 | 20527850 | 293.8973756925852 | 214165 | 22758440 | 106.265916466276 | 524746 | 74412038 | 141.8058222454292 | 808758 | 117698328 | 145.5297233535866 | Private
New Energy | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 3150 | 143.1818181818182 | 22 | 3150 | 143.1818181818182 | Private
Morgan Stanley Capital | MSCG | 0 | 0 | 0 | 16800 | 1604400 | 95.5 | 37998 | 3790600 | 99.75788199378914 | 54798 | 5395000 | 98.45249826636008 | Private
Constellation | CPSC | 0 | 0 | 0 | 15200 | 1390800 | 91.5 | 10860 | 995925 | 91.70580110497238 | 26060 | 2386725 | 91.58576362240983 | Private