Spreadsheet: james_steffes__12842__CTCanalysis3
Sheet: PG&E

Utility Risk Management Analysis of PG&E 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
E19-P |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
E19-S |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
E-20T |  |  | 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
E19-P | 0.25
E19-S | 0.45
E-20T | 0.3
TARIFFS
E19-P 500 kW | 50% LF | Bun Rate | 79.47076148121981 | 80.273122506278 | 81.36384386413667 | 78.22999544627233 | 69.75075849090047 | 68.10788324598441 | 64.0405556801697 |  | 57.04270443771156 | 57.40146123825139 |  |  |  | 137.2543657995235 | 135.8213424895526 | 138.8521107855237 | 136.8361621081342 | 125.329156825231 | 94.72923674416317 | 94.75878228716306 | 90.98288984324938 | 91.3416466437892 | 94.22855545368012
Bundled less Surcharges |  |  | 79.47076148121981 | 80.273122506278 | 81.36384386413667 | 78.22999544627233 | 69.75075849090047 | 68.10788324598441 | 64.0405556801697 | 47.04270443771156 | 47.04270443771156 | 47.40146123825139 | 50.28837004814232 | 50.44633534449351 | 81.6265610897573 | 81.11929860128248 | 80.73896637724305 | 81.4519345079304 | 81.29127042019533 | 68.25368480248747 | 50.03923674416318 | 50.06878228716306 | 46.29288984324938 | 46.6516466437892 | 49.53855545368012
Non-Gen (T&D plus Other) |  |  | 8.891564997003792 | 8.891564997003794 | 8.891564997003792 | 8.891564997003794 | 8.891564997003792 | 8.891564997003794 | 8.891564997003794 | 19.88695618018017 | 19.88695618018017 | 19.88695618018017 | 19.88695618018017 | 19.88695618018017 | 19.88695618018017 | 19.88695618018017 | 19.88695618018018 | 19.88695618018017 | 19.88695618018017 | 19.88695618018017 | 19.88695618018017 | 19.88695618018017 | 19.13714158571798 | 19.13714158571798 | 19.13714158571798
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
[NAME] 500 kW | 50% LF | Bun Rate | 118.8672823049723 | 116.9178399090477 | 119.0232033004519 | 118.5648241031416 | 68.52568061202342 | 68.21580184206802 | 69.08895878908113 |  | 63.21841247517285 | 63.72236397158741 |  |  |  | 153.3097049686269 | 151.0090339802313 | 155.3249337083261 | 152.649318062315 | 139.0129012940304 | 102.4415481579599 | 101.9748255330198 | 97.28379236722921 | 97.78085913876555 | 101.6963520441972
Bundled less Surcharges |  |  | 118.8672823049723 | 116.9178399090477 | 119.0232033004519 | 118.5648241031416 | 68.52568061202342 | 68.21580184206802 | 69.08895878908113 | 53.21841247517285 | 53.21841247517285 | 53.72236397158741 | 57.74362062124408 | 57.97661082943361 | 99.13868509332161 | 98.14692972514827 | 97.06560102887187 | 98.67473195923262 | 98.34202949427566 | 82.74922058397993 | 57.37616256713716 | 57.41974063371489 | 52.35868727556921 | 52.86263877198377 | 56.88389542164046
Non-Gen (T&D plus Other) |  |  | 13.01826988567189 | 13.01826988567189 | 13.01826988567189 | 13.01826988567189 | 13.01826988567189 | 13.01826988567189 | 13.01826988567189 | 28.91742543029898 | 28.91742543029898 | 28.91742543029899 | 28.91742543029898 | 28.91742543029898 | 28.91742543029898 | 28.91742543029899 | 28.91742543029898 | 28.91742543029898 | 28.91742543029898 | 28.91742543029899 | 28.91742543029899 | 28.91742543029898 | 28.05770023069535 | 28.05770023069535 | 28.05770023069535
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
E20-S 1000 kW | 65% LF | Bun Rate | 81.92343107879368 | 80.46867423344366 | 81.90754409696198 | 81.5714497028236 | 59.11133478925521 | 58.85082281679678 | 59.68893871794208 |  | 57.21253555264886 | 57.40681011250423 |  |  |  | 116.0616431437628 | 114.9131274925197 | 117.0630760310143 | 115.2443027238234 | 112.6883996754262 | 93.0357765457012 | 93.16150341094938 | 91.86928129907142 | 92.0635558589268 | 92.82753537182998
Bundled less Surcharges |  |  | 81.92343107879368 | 80.46867423344366 | 81.90754409696198 | 81.5714497028236 | 59.11133478925521 | 58.85082281679678 | 59.68893871794208 | 47.21253555264886 | 47.21253555264886 | 47.40681011250423 | 48.17078962540744 | 48.23004453675555 | 60.31786477676417 | 60.30528734016059 | 59.84358256441425 | 60.33048088787704 | 60.23343081554981 | 56.13332333912301 | 47.8457765457012 | 47.97150341094938 | 46.67928129907142 | 46.87355585892681 | 47.63753537182998
Non-Gen (T&D plus Other) |  |  | 11.89069860580702 | 11.89069860580702 | 11.89069860580702 | 11.89069860580702 | 11.89069860580702 | 11.89069860580702 | 11.89069860580702 | 11.41725904789974 | 11.41725904789974 | 11.41725904789974 | 11.41725904789974 | 11.41725904789974 | 11.41725904789974 | 11.41725904789974 | 11.41725904789974 | 11.41725904789974 | 11.41725904789974 | 11.41725904789974 | 11.41725904789974 | 11.41725904789974 | 10.8840047943223 | 10.8840047943223 | 10.8840047943223
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
NP-15 Wholesale MCP/Fwd Price |  |  | 155.1680504854407 | 115.2441920645118 | 167.6137897582072 | 109.5264884732541 | 88.94017943682708 | 134.4293126108998 | 228.5035927442246 | 200.2125185859965 | 200.2125185859965 | 231.0859636115896 | 199.5943639739078 | 219.3599915915566 | 180.5962429583926 | 55.16018069234681 | 43.46930629873904 | 49.82258064516129 | 45.99333333333333 | 44.96129032258064 | 42.52 | 51.04677419354839 | 47.62440860215053 | 41.44142857142857 | 36.88827956989248
Ancillary Services (%) |  |  | 0.1013720795314537 | 0.06447745692153244 | 0.09531319558181894 | 0.1076844573909755 | 0.05179460480776593 | 0.06554041211772776 | 0.2338544852665019 |  |  |  |  |  |  |  |  | 0.1075218468569231 | 0.09552459320273399 | 0.05450903308271871 | 0.05829544859890784 | 0.07378121159786594 | 0.06307260232653676 | 0.0523469502431376 | 0.05816784263736138
Ancillary Services ($/MWH) |  |  | 12.31361963799699 | 12.31361963799699 | 12.31361963799699 | 12.31361963799699 | 12.31361963799699 | 12.31361963799699 | 12.31361963799699 | 12.57162454804973 | 12.57162454804973 | 12.58309335335633 | 11.8402504515297 | 16.74564946971407 | 11.90772869271234 | 8.56677774472768 | 5.714009376858463
Other Adders | losses | weight
Line Losses - P | 0.02
[NAME] | 0.07
Line Losses - T | 0
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)
PG&E COST of PROCURED POWER
Utility Retained Generation
Percent of Load |  |  | PX | PX | PX | PX | PX | PX | PX | 0.2997827456205258 | 0.2997827456205258 | 0.3037620590091127 | 0.3034175211157515 | 0.2815972206562155 | 0.2713937254396569 | 0.315577313580728 | 0.3130809886624578 | 0.3146489046603562 | 0.3090672877956037 | 0.3067476945122318 | 0.3037151897173254 | 0.3061194469162934 | 0.3200551001242778 | 0.3271028892190486 | 0.3318045295600313
Average Cost |  |  | PX | PX | PX | PX | PX | PX | PX | 42.44071126967267 | 42.44071126967267 | 41.44000759534953 | 40.43348029282333 | 39.45102438270892 | 38.45424137920445 | 37.40328622430507 | 36.76167476847971 | 37.02812056072524 | 37.12008957386436 | 37.01655281692035 | 36.69682900533773 | 36.76517473844113 | 36.88162539924835 | 36.6950935144201 | 36.5471778469731
QF Contracts |  |  | PX | PX | PX | PX | PX | PX | PX | 0
Percent of Load |  |  | PX | PX | PX | PX | PX | PX | PX | 0.07470655331651734 | 0.07470655331651734 | 0.07322176226417296 | 0.07335031880931049 | 0.08149207185010077 | 0.2480867940408626 | 0.2039032058997914 | 0.2063995308180616 | 0.2048316148201632 | 0.2104132316849158 | 0.2127328249682877 | 0.2157653297631941 | 0.2133610725642261 | 0.1994254193562417 | 0.1923776302614708 | 0.1876759899204881
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 | 0
Percent of Load |  |  | PX | PX | PX | PX | PX | PX | PX | 0.6255107010629568 | 0.6255107010629568 | 0.6230161787267143 | 0.623232160074938 | 0.6369107074936838 | 0.4805194805194805 | 0.4805194805194805 | 0.4805194805194805 | 0.4805194805194805 | 0.4805194805194806 | 0.4805194805194806 | 0.4805194805194805 | 0.4805194805194805 | 0.4805194805194806 | 0.4805194805194805 | 0.4805194805194806
Average Cost, PG&E Method |  |  | PX | PX | PX | PX | PX | PX | PX | 54.71 | 54.71 | 54.71 | 54.71 | 54.71 | 54.71 | 54.71 | 54.71 | 54.71 | 54.71 | 54.71 | 54.71 | 54.71 | 54.71 | 54.71 | 54.71
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
 |  | Total DA Loads |  |  |  |  |  |  |  | 255320.5983000921 | 184398.2098833999 | 37746.09155699999 | 41566.25547799998 | 40028.6578834333 | 42423.91427630191 | 34869.1736602567 | 62822.92904696555 | 332150.2820501024 | 451655.1820462149 | 503981.1752716395 | 462657.9500536539 | 448363.0795417919 | 414747.9253858249 | 387638.4729091073 | 418100.4198075086