Spreadsheet: james_steffes__12842__CTCanalysis3
Sheet: SCE

Utility Risk Management Analysis of Southern California Edison Book
 |  |  | Period of Minimal Dispute (?) |  |  |  | Possible FERC Recalc of PX Prices |  |  | Jan 1 - Jan 18 | Jan 19 - Aug 31 |  |  |  |  |  |  |  | Sep 1 - Mar 31 2002 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PG&E
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enron
 |  |  |  |  |  |  |  |  |  | 1/1-1/18 | 1/19-1/31
 |  |  | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 |  | 1/1-1/18 | 1/19-8/31 | 9/1-3/31 | 1/19-3/31
[NAME]
DA Load as of June 01
E19-P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1597.781647923518 | 1488.15780314999 | 1475.833427827779 | 1355.764257570915 | 1297.854613198121 | 1298.467436875015 | 1222.934716222218 | 1332.292397849034
E19-S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2662.969413205864 | 2480.263005249983 | 2459.722379712966 | 2259.607095951525 | 2163.091021996869 | 2164.112394791692 | 2038.224527037029 | 2220.48732974839
E-20T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1065.187765282346 | 992.1052020999931 | 983.8889518851864 | 903.8428383806099 | 865.2364087987476 | 865.6449579166767 | 815.2898108148119 | 888.1949318993562
ReDASR'd [NAME] |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
E19-P |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
E19-S |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
E-20T |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
New Deals |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
E19-P |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
E19-S |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 86436.45923045302 | 88361.55268758065 | 84576.79518077183 | 79857.16822304417 | 77102.00722248423 | 73033.61789246862 | 72553.31390773268 | 74574.24358585452
E-20T |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6399.946741713788 | 6398.565275286219 | 6395.518023340587 | 6380.154578270584 | 6582.586190535209 | 6574.95445315274 | 5983.616729979216 | 6384.502286541585
Total DA Load excl New Deals | weight |  | 138992.7032466584 | 154222.1930125084 | 162086.2648371584 | 152376.7256255084 | 152708.8813555084 | 144481.7559155085 | 146545.6923635085
GS-2S 150 kW | 0.2
TOU-8P | 0.65
I-6 P 1000kW | 0.15
TARIFFS
GS-2S 150 kW | 70% LF | Bun Rate | 79.47076148121981 | 80.273122506278 | 81.36384386413667 | 78.22999544627233 | 69.75075849090047 | 68.10788324598441 | 64.0405556801697 |  | 79.15066368715182 | 79.57776726252361 | 76.26536565233368 |  |  | 129.2107614812198 | 130.013122506278 | 131.1038438641367 | 127.9699954462723 | 119.4907584909005 | 117.8478832459844 | 113.7805556801697 | 114.5128483401828 | 114.9399519155546 | 111.6275503053647
Bundled less Surcharges |  |  | 79.47076148121981 | 80.273122506278 | 81.36384386413667 | 78.22999544627233 | 69.75075849090047 | 68.10788324598441 | 64.0405556801697 | 69.15066368715182 | 69.15066368715182 | 69.57776726252361 | 66.26536565233368 | 66.97869690175679 | 69.67412785977452 | 79.47076148121981 | 80.273122506278 | 81.36384386413667 | 78.22999544627233 | 69.75075849090047 | 68.1078832459844 | 64.04055568016972 | 64.77284834018278 | 65.19995191555456 | 61.88755030536467
Non-Gen (T&D plus Other) |  |  | 8.891564997003792 | 8.891564997003794 | 8.891564997003792 | 8.891564997003794 | 8.891564997003792 | 8.891564997003794 | 8.891564997003794 | 24.5427614237632 | 24.5427614237632 | 24.5427614237632 | 24.5427614237632 | 24.5427614237632 | 24.5427614237632 | 24.5427614237632 | 24.5427614237632 | 24.5427614237632 | 24.5427614237632 | 24.5427614237632 | 24.5427614237632 | 24.5427614237632 | 20.16494607679417 | 20.16494607679416 | 20.16494607679417
PX Price ("Credit") |  |  |  |  |  |  |  |  |  |  | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX
Jan '01 Surcharge |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Mar '01 Surcharge |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35.19 | 46.36019639670486 | 45.16636027822455 | 44.77437071078739 | 46.07553731308469 | 44.21785805747118 | 46.15661437198259 | 35.19 | 35.19 | 35.19 | 35.19 | 35.19
TOU-8P | 60% LF | Bun Rate | 118.8672823049723 | 116.9178399090477 | 119.0232033004519 | 118.5648241031416 | 68.52568061202342 | 68.21580184206802 | 69.08895878908113 |  | 77.30307539197747 | 77.70052788988062 | 79.2004018810658 |  |  | 177.1888297099924 | 174.4840164495017 | 178.3548533386444 | 176.2294260315391 | 115.6041087008521 | 115.3472003244646 | 116.3142465897566 | 111.5372085270665 | 111.9362040616251 | 113.4668283102663
Bundled less Surcharges |  |  | 118.8672823049723 | 116.9178399090477 | 119.0232033004519 | 118.5648241031416 | 68.52568061202342 | 68.21580184206802 | 69.08895878908113 | 67.30307539197747 | 67.30307539197747 | 67.70052788988062 | 69.2004018810658 | 69.53390804995968 | 69.39520042701041 | 118.8672823049723 | 116.9178399090477 | 119.023203300452 | 118.5648241031416 | 68.52568061202342 | 68.215801842068 | 69.08895878908113 | 64.39635087660899 | 64.79380337451212 | 66.29367736569733
Non-Gen (T&D plus Other) |  |  | 13.01826988567189 | 13.01826988567189 | 13.01826988567189 | 13.01826988567189 | 13.01826988567189 | 13.01826988567189 | 13.01826988567189 | 25.02298192169864 | 25.02298192169864 | 25.02298192169864 | 25.02298192169864 | 25.02298192169864 | 25.02298192169864 | 25.02298192169864 | 25.02298192169864 | 25.02298192169864 | 25.02298192169864 | 25.02298192169864 | 25.02298192169864 | 25.02298192169864 | 22.11625740633016 | 22.11625740633016 | 22.11625740633016
PX Price ("Credit") |  |  |  |  |  |  |  |  |  |  | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX
Jan '01 Surcharge |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Mar '01 Surcharge |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 37.12497252464603 | 37.04489098933111 | 48.32154740502012 | 47.56617654045401 | 49.33165003819247 | 47.66460192839754 | 37.07842808882869 | 37.13139848239658 | 37.22528780067542 | 37.14085765045752 | 37.14240068711296 | 37.17315094456898
I-6 P 1000kW | 65% LF | Bun Rate | 81.92343107879368 | 80.46867423344366 | 81.90754409696198 | 81.5714497028236 | 59.11133478925521 | 58.85082281679678 | 59.68893871794208 |  | 68.15996621199409 | 68.51078202092762 | 69.76740963178364 |  |  | 141.4867419206379 | 139.3723109192533 | 142.4088152977695 | 140.4169932696883 | 108.5595555987577 | 108.2964799449527 | 109.1303424737005 | 104.6299355801862 | 104.9807129447429 | 106.2357508721578
Bundled less Surcharges |  |  | 81.92343107879368 | 80.46867423344366 | 81.90754409696198 | 81.5714497028236 | 59.11133478925521 | 58.85082281679678 | 59.68893871794208 | 58.15996621199409 | 58.15996621199409 | 58.51078202092762 | 59.76740963178364 | 59.96463171643714 | 59.63310339846349 | 81.9234310787937 | 80.46867423344364 | 81.907544096962 | 81.5714497028236 | 59.11133478925522 | 58.85082281679678 | 59.68893871794208 | 55.18450860114265 | 55.53532441007619 | 56.79195202093221
Non-Gen (T&D plus Other) |  |  | 11.89069860580702 | 11.89069860580702 | 11.89069860580702 | 11.89069860580702 | 11.89069860580702 | 11.89069860580702 | 11.89069860580702 | 23.85982901236945 | 23.85982901236945 | 23.85982901236944 | 23.85982901236945 | 23.85982901236944 | 23.85982901236945 | 23.85982901236944 | 23.85982901236944 | 23.85982901236944 | 23.85982901236944 | 23.85982901236945 | 23.85982901236944 | 23.85982901236944 | 20.88437140151801 | 20.88437140151801 | 20.88437140151801
PX Price ("Credit") |  |  |  |  |  |  |  |  |  |  | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX | no PX
Jan '01 Surcharge |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Mar '01 Surcharge |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 39.44590259744251 | 39.44914686653966 | 49.56331084184419 | 48.90363668580968 | 50.50127120080751 | 48.84554356686471 | 39.44822080950247 | 39.44565712815594 | 39.44140375575839 | 39.44542697904355 | 39.44538853466673 | 39.44379885122558
Total [NAME] (T&D plus Other)
Total Wtd Avg Tariff (w/o Surcharges)
Total Wtd Avg Tariff (w/ Surcharges)
MARKET PRICE
SP-15 Wholesale MCP/Fwd Price |  |  | 155.1680504854407 | 115.2441920645118 | 167.6137897582072 | 109.5264884732541 | 88.94017943682708 | 134.4293126108998 | 228.5035927442246 | 169.5542011266863 | 169.5542011266863 | 186.5186869736937 | 187.5628386849041 | 140.5292083773621 | 137.5944223546402 | 46.21488353575018 | 34.25687481303213 | 38.07174913112857 | 42.739 | 37.21135 | 37.2511 | 37.2168 | 38.47855 | 38.5125 | 35.9347
Ancillary Services (%) |  |  | 0.1013720795314537 | 0.06447745692153244 | 0.09531319558181894 | 0.1076844573909755 | 0.05179460480776593 | 0.06554041211772776 | 0.2338544852665019 | 0.07262350066334591 | 0.07262350066334591 | 0.06070850434155709 | 0.07006615913561368 | 0.09260161467258987 | 0.07596055525741145 | 0.170811562850168 | 0.1358792501409935 | 0.1010922918939125 | 0.0863625071361957 | 0.06102940029919161 | 0.07357130295475325 | 0.09049315930947861 | 0.07262350066334591 | 0.06070850434155709 | 0.07006615913561368
Ancillary Services ($/MWH) |  |  | 12.31361963799699 | 12.31361963799699 | 12.31361963799699 | 12.31361963799699 | 12.31361963799699 | 12.31361963799699 | 12.31361963799699 | 12.31361963799699
Other Adders | losses | weight
Line Losses - P | 0.03
[NAME] | 0.06
Line Losses - T | 0.01
Block to Shape |  |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
IntraZonal Congestion |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
[NAME] |  |  | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5
ISO Charges |  |  | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65 | 1.65
Total Retail Gen Price (w/o Surcharges)
SCE COST of PROCURED POWER
Utility Retained Generation
Percent of Load |  |  | PX | PX | PX | PX | PX | PX | PX |  | 0.2363281284999056 | 0.2366693251911391 | 0.2183520004360053 | 0.1979229155690102 | 0.2525749612152067 | 0.2570088500758501 | 0.2525467612569714 | 0.2519531825570057 | 0.2493262244860426 | 0.2461420195103212 | 0.2428764674126326 | 0.2429624616845003 | 0.2475997857200987 | 0.2513362973009587 | 0.2532322009429852
Average Cost |  |  | PX | PX | PX | PX | PX | PX | PX |  | 59.84165805535494 | 57.76072449562623 | 55.67895055196001 | 53.78977782876067 | 51.83015166353046 | 49.19036047430716 | 47.57570835981806 | 47.54222649065173 | 47.37808013356842 | 47.01305429620681 | 46.37383889284836 | 46.31425487984003 | 46.27839749402394 | 46.09686311933341 | 45.95242976203248
QF Contracts |  |  | PX | PX | PX | PX | PX | PX | PX
Percent of Load |  |  | PX | PX | PX | PX | PX | PX | PX |  | 0.1335318955743006 | 0.1333591026226486 | 0.1426355835854736 | 0.1529815276242451 | 0.2669055582653128 | 0.2624716694046694 | 0.2669337582235481 | 0.2675273369235138 | 0.2701542949944769 | 0.2733384999701983 | 0.2766040520678869 | 0.2765180577960192 | 0.2718807337604208 | 0.2681442221795609 | 0.2662483185375343
Average Cost |  |  | PX | PX | PX | PX | PX | PX | PX | 130.7 | 130.7 | 69 | 69 | 69 | 81 | 58 | 57 | 55 | 65 | 65 | 65 | 65 | 65 | 65 | 65
DWR Spot Purchases & LT Contracts |  |  | PX | PX | PX | PX | PX | PX | PX
Percent of Load |  |  | PX | PX | PX | PX | PX | PX | PX |  | 0.6301399759257938 | 0.6299715721862122 | 0.639012415978521 | 0.6490955568067447 | 0.4805194805194805 | 0.4805194805194805 | 0.4805194805194806 | 0.4805194805194806 | 0.4805194805194805 | 0.4805194805194806 | 0.4805194805194806 | 0.4805194805194805 | 0.4805194805194806 | 0.4805194805194806 | 0.4805194805194806
Average Cost, PG&E Method |  |  | PX | PX | PX | PX | PX | PX | PX | 62.77 | 62.77 | 62.77 | 62.77 | 62.77 | 62.77 | 62.77 | 62.77 | 62.77 | 62.77 | 62.77 | 62.77 | 62.77 | 62.77 | 62.77 | 62.77
Total Wtd Avg Cost of Procured Pwr
(1) Using PG&E Method for DWR Purchases |  |  | PX | PX | PX | PX | PX | PX | PX
CTC CALCULATIONS
Scenario 1: SCE Method
Bundled Rate less Surcharges
Jan. [NAME]
Mar. [NAME]
Bundled Rate plus Surcharges
PX Credit
Net Bill (T&D&Other)
Volume
Total Amount Due To (Owed By) ENE
 | TOTAL
Scenario 2A: PG&E Method, Using PG&E DWR Costs
Bundled Rate less Surcharges
Jan. [NAME]
Mar. [NAME] |  |  |  |  |  |  |  |  |  | none | none | none | none | none | none | none | none | none | none | none | none | none | none | none | none
Bundled Rate plus Surcharges
PX Credit
Net Bill
Volume
Total Amount Due To (Owed By) ENE
 | TOTAL
Scenario 2B: PG&E Method, Using PG&E Adjusted PX Credit
Bundled Rate less Surcharges
Jan. [NAME]
Mar. [NAME] |  |  |  |  |  |  |  |  |  | none | none | none | none | none | none | none | none | none | none | none | none | none | none | none | none
Bundled Rate plus Surcharges
PX Credit |  |  |  |  |  |  |  |  |  |  | 213 | 196 | 159 | 102 | 40 | 38 | 35 | 35 | 35
Net Bill
Volume
Total Amount Due To (Owed By) ENE
 | TOTAL
Scenario 3: Enron Method
Bundled Rate less Surcharges
Jan. [NAME]
Mar. [NAME] |  |  |  |  |  |  |  |  |  |  | none | none | none | none | none | none | none | none | none | none | none | none | none | none | none
Bundled Rate plus Surcharges
PX Credit
Net Bill
Volume
Total Amount Due To (Owed By) ENE
 | TOTAL
Scenario 4: Hybrid Method
Total Amount Due To (Owed By) ENE
 | TOTAL
Bundled Rate plus Surcharges
PX Credit
Net Bill
 |  |  |  |  |  |  |  |  |  | 146825.8597724975 |  | 196850.7115157581 | 20496.7333726973 | 4462.922385341031 | 5680.877242225323 | 3704.233288312298 | 55344.34228791157 | 167970.359766191 | 257011.1742243069 | 284926.7399938427 | 263621.2880514165 | 250121.0443110752 | 239454.8298874169 | 227804.9829348276 | 246980.2211807431