Spreadsheet: jeff_dasovich__14043__COS & Rates Workpapers for GA II 12-20-2000 Proposal
Sheet: Cost_Rate_summary

Privileged and Confidential - Attorney-Client Privilege
Pacific Gas & Electric Company
Gas Accord II Cost Allocation and Backbone Rate Design
12-20-2000 Settlement Proposal
 |  | [NAME] AND STORAGE BASE RRQ (in millions)
 |  | By Unbundled Cost Categories |  |  |  |  |  |  |  |  |  | By [NAME] |  |  |  |  |  |  |  |  | RATE @ 100% CONTRACT $/Dth |  |  |  |  |  |  |  | TOTAL LT + BB |  |  |  |  | Core
 |  |  |  | sto- | L400 | Ln. | Oth | So. | Gat- | Local |  |  | Redwood |  | L401 |  | Silv/ | Stor C | Local |  | Redwood |  |  |  | Silv/ | LT |  |  | Core |  | Noncore |  |  | Stor
 |  | TOTAL |  | rage | & L2 | 401 | BB | BB | her. | Trans |  | TOTAL | Core | Nonc | G-XF | Baja | Misn | +@ risk | Trans |  | Core | NonC | G-XF | Baja | Misn | Core | NonC |  | Redwd | Baja | Redwd | Baja |  | $/Dth
 |  | (A) |  | (B) | (C) | (D) | (E) | (F) | (G) | (H) |  | (I) | (J) | (K) | (L) | (M) | (N) | (O) | (P) |  | (Q) | (R) | (S) | (T) | (U) | (V) | (W) |  | (X) | (Y) | (Z) | (AA) |  | (AB)
 | 2002 Gas Accord | 416.5865024 |  | 50.128 | 26.607 | 101.967 | 18.992 | 50.217 | 14.787 | 153.8885024 |  | 416.589 | 24.539 | 66.185 | 54.934 | 65.468 | 7.397 | 44.176 | 153.89 |  | 0.1248 | 0.2692 | 0.3354 | 0.1745 | 0.1158 |  |  |  | 0.412 | 0.4617 | 0.4178 | 0.3231 |  | 0.152599835336613
 | 2003 | 424.7311827154489 |  | 57.10867640042692 | 30.74230040625156 | 89.55335708483507 | 23.03590111847628 | 68.44373031144698 | 10.71753285690976 | 145.1296845371024 |  | 424.7311827154462 | 24.3703954460346 | 102.4114283260261 | 9.545218363936335 | 77.13531430004282 | 9.242966034331621 | 57.10867640042692 | 144.9171838446478 |  | 0.1409 | 0.2867 | 0.2488 | 0.2423 | 0.2193 |  |  |  | 0.4455 | 0.5468999999999999 | 0.3884 | 0.344 |  | 0.1698090753226123
 | 2004 | 439.5967741104896 |  | 59.10748007444186 | 31.81828092047036 | 92.68772458280428 | 23.84215765762295 | 70.83926087234762 | 11.0926465069016 | 150.2092234959009 |  | 439.5967741104868 | 25.22335928664581 | 105.995828317437 | 9.879301006674098 | 79.83505030054431 | 9.566469845533227 | 59.10748007444186 | 149.9892852792104 |  | 0.1458 | 0.2967 | 0.2616 | 0.2509 | 0.2269 |  |  |  | 0.461 | 0.5661 | 0.402 | 0.3562 |  | 0.1757523929589037
 | 2005 | 469.5026519825381 |  | 75.6962326552286 | 32.93192075268681 | 95.93179494320243 | 24.67663317563975 | 73.3186350028798 | 11.48088913464316 | 155.4665463182575 |  | 469.502651982535 | 27.3517929588721 | 112.277741858136 | 10.22507654190771 | 84.92036419979208 | 10.20481021696879 | 69.28395594287566 | 155.2389102639827 |  | 0.1581 | 0.3143 | 0.2493 | 0.2668 | 0.2421 |  |  |  | 0.4843999999999999 | 0.5931 | 0.4232 | 0.3757 |  | 0.2100954821340338
 | 2006 | 484.7689272292678 |  | 77.17928322550264 | 34.08453797903085 | 99.28940776621451 | 25.54031533678715 | 75.8847872279806 | 11.88272025435567 | 160.9078754393964 |  | 484.7689272292647 | 28.20905166499842 | 116.0008622752508 | 10.58295422087447 | 87.70854549297596 | 10.53759883436698 | 71.05764261757602 | 160.6722721232221 |  | 0.1631 | 0.3247 | 0.2404 | 0.2756 | 0.2499 |  |  |  | 0.5008 | 0.6133 | 0.4375 | 0.3884 |  | 0.2151843227385843
 | 2007 | 500.7521578301298 |  | 78.89687628623281 | 35.27749680829694 | 102.764537038032 | 26.43422637357469 | 78.54075478095989 | 12.29861546325812 | 166.5396510797753 |  | 500.7521578301266 | 29.1119820623649 | 119.8866438444807 | 10.95335761860508 | 90.62313093541341 | 10.88585271910352 | 72.99538900262408 | 166.2958016475349 |  | 0.1683 | 0.3356 | 0.2344 | 0.2848 | 0.2582 |  |  |  | 0.5178 | 0.6343 | 0.4523 | 0.4015 |  | 0.220805874939043
 | Rate Design Assumptions:
 |  | Redwood path - phase-in: 868.86 MMcf/d of L401 capacity in year 2003. Core vintage rate on L400.
 |  | Baja path - status quo.
 |  | Silverado path cost allocation - 60 MDth/d of L400, L401, L2 and L300 costs; 150 MDth/d of other backbone transmission costs.
 |  | No cost allocation to Mission path.  The rates are the same as Silverado except for As-available, where [NAME]'s rate is zero.
 |  | Rate design load factor for 2003 - 77% for [NAME] AFT (annual firm transmission) service; 77% for Baja AFT; and 77% for Silverado AFT.
 |  | Gathering O&M are in other backbone transmission.  RO related to gathering rate base additions are included in local transmission and recovered in LT rates.
 |  | COS RO adjusted for L401 original plant to $736 million.
 |  | The noncore LT rate above is the average of ALL noncore customers
 |  | Rate Design Scenario = Status Quo
 |  | Base RRQ excludes carrying cost of gas in inventory and customer access charge distribution RRQ