Spreadsheet: tracy_geaccone__40432__PLAN_FORECAST_DESIGN_MASTER
Sheet: Out Years Data Input

Transwestern Pipeline Company |  | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2002 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003 | 2003
Other Data Needed |  | January |  |  | February |  |  | March |  |  | April |  |  | May |  |  | June |  |  | July |  |  | August |  |  | September |  |  | October |  |  | November |  |  | December |  |  | January |  |  | February |  |  | March |  |  | April |  |  | May |  |  | June |  |  | July |  |  | August |  |  | September |  |  | October |  |  | November |  |  | December
DATA INPUT SCREEN
 |  | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues | [NAME] | Rates | Revenues
Number of Days |  |  |  | 31 |  |  | 28 |  |  | 31 |  |  | 30 |  |  | 31 |  |  | 30 |  |  | 31 |  |  | 31 |  |  | 30 |  |  | 31 |  |  | 30 |  |  | 31 |  |  | 31 |  |  | 28 |  |  | 31 |  |  | 30 |  |  | 31 |  |  | 30 |  |  | 31 |  |  | 31 |  |  | 30 |  |  | 31 |  |  | 30 |  |  | 31
Unhedged Monthly Index Price
Hedged Price
Hedged volume
Fuel used percentage
UAF percentage
REVENUE DIFFERENCE FOR NEGOTIATED RATE DEALS
Negociated Rate Deal Diff. - East to West
Negociated Rate Deal Diff. - San Juan to West
Negociated Rate Deal Diff. - Ignacio  (to El Paso)
Negociated Rate Deal Diff. - Ignacio to Blanco
Negociated Rate Deal Diff. - East to East
Negociated Rate Deal Diff. - San Juan to East
"COPY/PASTE" FROM DEMAND SUMMARY TAB
INPUTS FOR DEMAND REVENUES AND [NAME] |  | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand
Demand Summary
EAST           EOT -EOT | FTS-1 | 532214 | 0.0377 | 621991.936 | 532214 | 0.0377 | 561799.168 | 522214 | 0.0375 | 606491.936 | 522214 | 0.0375 | 586927.68 | 523827 | 0.0375 | 608992.086 | 508047 | 0.0365 | 556677.18 | 512617 | 0.0366 | 582316.586 | 489391 | 0 | 561816.286 | 483047 | 0.0369 | 534177.18 | 479714 | 0.0368 | 546816.936 | 479714 | 0.0368 | 529177.68 | 444000 | 0.0314 | 431675
EAST           IG - EOT | FTS-1
EAST           SJ - EOT | FTS-1 | 80000 | 0.145 | 359600 | 80000 | 0.145 | 324800 | 80000 | 0.145 | 359600 | 80000 | 0.145 | 348000 | 80000 | 0.145 | 359600 | 80000 | 0.145 | 348000 | 80000 | 0.145 | 359600 | 80000 | 0 | 359600 | 80000 | 0.145 | 348000 | 80000 | 0.145 | 359600 | 80000 | 0.145 | 348000 | 80000 | 0.15 | 372000
EAST           THOR- EOT | FTS-1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EAST           WOT -EOT | FTS-1 | 80000 | 0.025 | 62000 | 80000 | 0.025 | 56000 | 80000 | 0.025 | 62000 | 80000 | 0.025 | 60000 | 80000 | 0.025 | 62000 | 80000 | 0.025 | 60000 | 80000 | 0.025 | 62000 | 80000 | 0 | 62000 | 80000 | 0.025 | 60000 | 80000 | 0.025 | 62000 | 80000 | 0.025 | 60000 | 80000 | 0.025 | 62000
Total EAST           DEMAND |  | 692214 |  | 1043591.936 | 692214 |  | 942599.168 | 682214 |  | 1028091.936 | 682214 |  | 994927.68 | 683827 |  | 1030592.086 | 668047 |  | 964677.18 | 672617 |  | 1003916.586 | 649391 |  | 983416.286 | 643047 |  | 942177.18 | 639714 |  | 968416.936 | 639714 |  | 937177.68 | 604000 |  | 865675
IGNACIO        EL PASO BLANCO | FTS-1 | 311000 | 0.052 | 501502.5 | 311000 | 0.052 | 452970 | 311000 | 0.052 | 501502.5 | 311000 | 0.052 | 485325 | 311000 | 0.052 | 501502.5 | 311000 | 0.052 | 485325 | 311000 | 0.052 | 501502.5 | 311000 | 0 | 501502.5 | 311000 | 0.052 | 485325 | 311000 | 0.052 | 501502.5 | 311000 | 0.052 | 485325 | 311000 | 0.052 | 501502.5
Total IGNACIO        DEMAND |  | 311000 |  | 501502.5 | 311000 |  | 452970 | 311000 |  | 501502.5 | 311000 |  | 485325 | 311000 |  | 501502.5 | 311000 |  | 485325 | 311000 |  | 501502.5 | 311000 |  | 501502.5 | 311000 |  | 485325 | 311000 |  | 501502.5 | 311000 |  | 485325 | 311000 |  | 501502.5
IGN_BLANCO | FTS-1 | 229000 | 0.045 | 319300 | 229000 | 0.045 | 288400 | 229000 | 0.045 | 319300 | 229000 | 0.045 | 309000 | 229000 | 0.045 | 319300 | 229000 | 0.045 | 309000 | 229000 | 0.045 | 319300 | 229000 | 0 | 319300 | 229000 | 0.045 | 309000 | 229000 | 0.045 | 319300 | 229000 | 0.045 | 309000 | 229000 | 0.045 | 319300
Total IGN_BLANCO     DEMAND |  | 229000 |  | 319300 | 229000 |  | 288400 | 229000 |  | 319300 | 229000 |  | 309000 | 229000 |  | 319300 | 229000 |  | 309000 | 229000 |  | 319300 | 229000 |  | 319300 | 229000 |  | 309000 | 229000 |  | 319300 | 229000 |  | 309000 | 229000 |  | 319300
SAN JUAN       SJ - SJ | FTS-1
SAN JUAN       SJ - THOR | FTS-1 | 497500 | 0.105 | 1566833 | 497500 | 0.105 | 1415204 | 477500 | 0.105 | 1501609 | 477500 | 0.105 | 1453170 | 477500 | 0.105 | 1501609 | 477500 | 0.105 | 1453170 | 477500 | 0.105 | 1501609 | 477500 | 0 | 1501609 | 477500 | 0.105 | 1453170 | 477500 | 0.105 | 1501609 | 456000 | 0.1051 | 1453170 | 456000 | 0.1051 | 1501609
Total SAN JUAN       DEMAND |  | 497500 |  | 1566833 | 497500 |  | 1415204 | 477500 |  | 1501609 | 477500 |  | 1453170 | 477500 |  | 1501609 | 477500 |  | 1453170 | 477500 |  | 1501609 | 477500 |  | 1501609 | 477500 |  | 1453170 | 477500 |  | 1501609 | 456000 |  | 1453170 | 456000 |  | 1501609
WEST           EOT- WOT | FTS-1 | 550500 | 0.2586 | 4412412.9 | 530500 | 0.2552 | 3790917.2 | 530500 | 0.2552 | 4197086.9 | 522500 | 0.259 | 3997245 | 522500 | 0.259 | 4130486.5 | 522500 | 0.259 | 3997245 | 522500 | 0.259 | 4130486.5 | 522500 | 0 | 4130486.5 | 522500 | 0.259 | 3997245 | 522500 | 0.259 | 4130486.5 | 440000 | 0.272 | 3590220 | 440000 | 0.272 | 3709894
WEST           IG - WOT | FTS-1 | 60000 | 0.18 | 334800 | 60000 | 0.18 | 302400 | 60000 | 0.18 | 334800 | 60000 | 0.18 | 324000 | 60000 | 0.18 | 334800 | 60000 | 0.18 | 324000 | 60000 | 0.18 | 334800 | 60000 | 0 | 334800 | 60000 | 0.18 | 324000 | 60000 | 0.18 | 334800 | 60000 | 0.18 | 324000 | 60000 | 0.18 | 334800
WEST           SJ - WOT | FTS-1 | 211100 | 0.2105 | 1377609 | 211100 | 0.2105 | 1244292 | 231100 | 0.2241 | 1605707 | 231100 | 0.2397 | 1662150 | 231100 | 0.2397 | 1717555 | 231100 | 0.2397 | 1662150 | 231100 | 0.2397 | 1717555 | 231100 | 0 | 1717555 | 231100 | 0.2397 | 1662150 | 231100 | 0.2397 | 1717555 | 252600 | 0.2507 | 1899445.5 | 252600 | 0.2507 | 1962760.35
WEST           THOR - WOT | FTS-1 | 265000 | 0.2592 | 2128956 | 265000 | 0.2592 | 1922928 | 245000 | 0.2584 | 1962672 | 245000 | 0.2584 | 1899360 | 245000 | 0.2584 | 1962672 | 245000 | 0.2584 | 1899360 | 245000 | 0.2584 | 1962672 | 245000 | 0 | 1962672 | 245000 | 0.2584 | 1899360 | 245000 | 0.2584 | 1962672 | 245000 | 0.2584 | 1899360 | 245000 | 0.2584 | 1962672
WEST           WOT - WOT | FTS-1 | 1300 | 0.2289 | 9224.67 | 1300 | 0.2289 | 8331.96 | 1300 | 0.2289 | 9224.67 | 1300 | 0.2289 | 8927.1 | 1300 | 0.2289 | 9224.67 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total WEST          DEMAND |  | 1087900 |  | 8263002.57 | 1067900 |  | 7268869.16 | 1067900 |  | 8109490.57 | 1059900 |  |  | 1059900 |  |  | 1058600 |  |  | 1058600 |  |  | 1058600 |  |  | 1058600 |  |  | 1058600 |  |  | 997600 |  | 7713025.5 | 997600 |  | 7970126.35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
INPUT FROM NEW CONTRACTS TAB | INPUT
ADDITIONAL DEMAND (LFT, Daily Firms, etc.) | on TAB
Demand Summary
EAST           EOT -EOT | FTS-1
EAST           IG - EOT | FTS-1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EAST           SJ - EOT | FTS-1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EAST           THOR- EOT | FTS-1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EAST           WOT -EOT | FTS-1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total EAST           DEMAND
IGNACIO        EL PASO BLANCO | FTS-1
Total IGNACIO        DEMAND
IGN_BLANCO | FTS-1
Total IGN_BLANCO     DEMAND
SAN JUAN       SJ - SJ | FTS-1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
SAN JUAN       SJ - THOR | FTS-1
Total SAN JUAN       DEMAND
WEST           EOT- WOT | FTS-1
WEST           IG - WOT | FTS-1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
WEST           SJ - WOT | FTS-1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
WEST           THOR - WOT | FTS-1
WEST           WOT - WOT | FTS-1
Total WEST          DEMAND
COMMODITY VOLUME LOAD FACTORS | INPUT
EAST :  From EOT, WOT & Thoreau |  | 0.44 |  |  | 0.44 |  |  | 0.44 |  |  | 0.56 |  |  | 0.57 |  |  | 0.56 |  |  | 0.53 |  |  | 0.53 |  |  | 0.49 |  |  | 0.52 |  |  | 0.53 |  |  | 0.55 |  |  | 0.44
EAST :  From IG & SJ |  | 0.71 |  |  | 0.76 |  |  | 0.71 |  |  | 0.92 |  |  | 0.85 |  |  | 0.85 |  |  | 0.92 |  |  | 0.81 |  |  | 0.91 |  |  | 0.73 |  |  | 0.82 |  |  | 0.81 |  |  | 0.85
IGNACIO:  To El Paso Blanco |  | 0.89 |  |  | 0.98 |  |  | 1 |  |  | 0.82 |  |  | 0.85 |  |  | 1 |  |  | 0.66 |  |  | 0.96 |  |  | 0.71 |  |  | 0.75 |  |  | 0.93 |  |  | 1.2 |  |  | 0.6
IGNACIO_BLANCO:  To Blanco Hub |  | 0.81 |  |  | 0.78 |  |  | 0.77 |  |  | 0.73 |  |  | 0.78 |  |  | 0.74 |  |  | 0.84 |  |  | 0.76 |  |  | 0.85 |  |  | 0.84 |  |  | 0.82 |  |  | 0.66 |  |  | 0.6
THOREAU:  From SJ |  | 0.96 |  |  | 0.98 |  |  | 0.95 |  |  | 0.92 |  |  | 0.86 |  |  | 0.85 |  |  | 0.95 |  |  | 0.9 |  |  | 0.91 |  |  | 0.92 |  |  | 0.91 |  |  | 0.92 |  |  | 0.85
WEST:  From EOT |  | 0.65 |  |  | 0.63 |  |  | 0.6 |  |  | 0.54 |  |  | 0.54 |  |  | 0.69 |  |  | 0.7 |  |  | 0.67 |  |  | 0.7 |  |  | 0.71 |  |  | 0.76 |  |  | 0.7 |  |  | 0.7
WEST:  From IG & SJ |  | 0.86 |  |  | 0.87 |  |  | 0.94 |  |  | 0.82 |  |  | 0.87 |  |  | 0.92 |  |  | 0.91 |  |  | 0.94 |  |  | 0.87 |  |  | 0.94 |  |  | 0.98 |  |  | 0.99 |  |  | 0.9
WEST:  From Thoreau & WOT |  | 1.61 |  |  | 1.65 |  |  | 1.6 |  |  | 1.52 |  |  | 1.46 |  |  | 1.5 |  |  | 1.49 |  |  | 1.6 |  |  | 1.58 |  |  | 1.5 |  |  | 1.12 |  |  | 1.25 |  |  | 1.1
CALCULATION  - ONLY INPUT COMMODITY RATES |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Commodity | Commodity               Commodity |  |  | Commodity               Commodity |  |  | Commodity               Commodity |  |  | Commodity               Commodity
FTS-1 COMMODITY REVENUE AND VOLUMES |  | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity
EAST           EOT to EOT | FTS-1 |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093
EAST           IG to EOT | FTS-1 |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104
EAST           SJ to EOT | FTS-1 |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0103 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104
EAST           Thor to EOT | FTS-1 |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093
EAST           WOT to EOT | FTS-1 |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0092 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093
Total EAST
IGNACIO        IG to EL PASO BLANCO | FTS-1 |  | 0.0032 |  |  | 0.0032 |  |  | 0.0032 |  |  | 0.0032 |  |  | 0.0032 |  |  | 0.0032 |  |  | 0.0032 |  |  | 0.0032 |  |  | 0.0032 |  |  | 0.0032 |  |  | 0.0032 |  |  | 0.0032 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033
Total IGNACIO
IGN_BLANCO     IG to BLANCO HUB | FTS-1 |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011
Total IGN_BLANCO
SAN JUAN       SJ to SJ | FTS-1 |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011
SAN JUAN       SJ to THOR | FTS-1 |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0013 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011
Total SAN JUAN
WEST           EOT to WOT | FTS-1 |  | 0.0285 |  |  | 0.0285 |  |  | 0.0285 |  |  | 0.0285 |  |  | 0.0285 |  |  | 0.0285 |  |  | 0.0285 |  |  | 0.0285 |  |  | 0.0285 |  |  | 0.0285 |  |  | 0.0285 |  |  | 0.0285 |  |  | 0.0286 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246
WEST           IG to WOT | FTS-1 |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186
WEST           SJ to WOT | FTS-1 |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0185 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186
WEST           THOR to WOT | FTS-1 |  | 0.0208 |  |  | 0.0208 |  |  | 0.0208 |  |  | 0.0208 |  |  | 0.0208 |  |  | 0.0208 |  |  | 0.0208 |  |  | 0.0208 |  |  | 0.0208 |  |  | 0.0208 |  |  | 0.0208 |  |  | 0.0208 |  |  | 0.021 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175
WEST           WOT to WOT | FTS-1 |  | 0.0174 |  |  | 0.0174 |  |  | 0.0174 |  |  | 0.0174 |  |  | 0.0174 |  |  | 0.0174 |  |  | 0.0174 |  |  | 0.0174 |  |  | 0.0174 |  |  | 0.0174 |  |  | 0.0174 |  |  | 0.0174 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175
Total WEST
INPUT AND CALCULATION |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Commodity | Commodity               Commodity |  |  | Commodity               Commodity |  |  | Commodity               Commodity |  |  | Commodity               Commodity
ITS-1 COMMODITY REVENUE AND VOLUMES |  | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity | Commodity
EAST           EOT to EOT | ITS-1 | 35200 | 0.03 |  | 23900 | 0.03 |  | 26400 | 0.03 |  | 23900 | 0.03 |  | 20000 | 0.03 |  | 23900 | 0.03 |  | 22800 | 0.03 |  | 12200 | 0.03 |  | 20200 | 0.03 |  | 10600 | 0.03 |  | 13800 | 0.03 |  | 27300 | 0.03
EAST           IG to EOT | ITS-1
EAST           SJ to EOT | ITS-1 | 1900 | 0.02 |  | 1800 | 0.02 |  | 2500 | 0.02 |  | 8000 | 0.02 |  | 7000 | 0.02 |  | 20600 | 0.02 |  | 1900 | 0.02 |  | 1800 | 0.02 |  | 2500 | 0.02 |  | 8000 | 0.02 |  | 7000 | 0.02 |  | 20600 | 0.02 |  | 0 | 0 |  | 0 | 0
EAST           Thor to EOT | ITS-1
EAST           WOT to EOT | ITS-1
Total EAST
IGNACIO        IG to EL PASO BLANCO | ITS-1 | 129800 | 0.015 |  | 53200 | 0.015 |  | 55600 | 0.015 |  | 85000 | 0.05 |  | 116400 | 0.05 |  | 148000 | 0.05 |  | 114000 | 0.05 |  | 107800 | 0.05 |  | 86000 | 0.05 |  | 26000 | 0.05 |  | 26000 | 0.015 |  | 102100 | 0.015
Total IGNACIO
IGN_BLANCO     IG to BLANCO HUB | ITS-1 | 8700 | 0.015 |  | 6700 | 0.015 |  | 14100 | 0.015 |  | 12800 | 0.05 |  | 29400 | 0.05 |  | 22700 | 0.05 |  | 5000 | 0.05 |  | 7600 | 0.05 |  | 7200 | 0.05 |  | 43000 | 0.05 |  | 43000 | 0.015 |  | 11700 | 0.015
Total IGN_BLANCO
SAN JUAN       SJ to SJ | ITS-1
SAN JUAN       SJ to THOR | ITS-1
Total SAN JUAN
WEST           EOT to WOT | ITS-1
WEST           IG to WOT | ITS-1
WEST           SJ to WOT | ITS-1
WEST           THOR to WOT | ITS-1
WEST           WOT to WOT | ITS-1
Total WEST
Separated for FINAL DEMAND REVENUE Calculation | INPUT
TWO-PART or MAX RATE DEMAND VOLUME BREAKOUT Summary
EAST           EOT -EOT | FTS-1 | 375000 |  |  | 375000 |  |  | 375000 |  |  | 375000 |  |  | 375000 |  |  | 375000 |  |  | 375000 |  |  | 375000 |  |  | 375000 |  |  | 375000 |  |  | 375000 |  |  | 375000 |  |  | 375000 |  |  | 375000 |  |  | 375000 |  |  | 5000 |  |  | 5000 |  |  | 5000 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
EAST           IG - EOT | FTS-1 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
EAST           SJ - EOT | FTS-1 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
EAST           THOR- EOT | FTS-1
EAST           WOT -EOT | FTS-1 | 80000 |  |  | 80000 |  |  | 80000 |  |  | 80000 |  |  | 80000 |  |  | 80000 |  |  | 80000 |  |  | 80000 |  |  | 80000 |  |  | 80000 |  |  | 80000 |  |  | 80000 |  |  | 80000 |  |  | 80000 |  |  | 80000 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
Total EAST           DEMAND
IGNACIO        EL PASO BLANCO | FTS-1 | 89500 |  |  | 89500 |  |  | 89500 |  |  | 89500 |  |  | 89500 |  |  | 89500 |  |  | 89500 |  |  | 89500 |  |  | 89500 |  |  | 89500 |  |  | 89500 |  |  | 89500 |  |  | 12500 |  |  | 12500 |  |  | 12500 |  |  | 12500 |  |  | 12500 |  |  | 12500 |  |  | 12500 |  |  | 12500 |  |  | 12500 |  |  | 12500 |  |  | 12500 |  |  | 12500
Total IGNACIO        DEMAND
IGN_BLANCO | FTS-1
Total IGN_BLANCO     DEMAND
SAN JUAN       SJ - SJ | FTS-1
SAN JUAN       SJ - THOR | FTS-1 | 497500 |  |  | 497500 |  |  | 477500 |  |  | 477500 |  |  | 477500 |  |  | 477500 |  |  | 477500 |  |  | 477500 |  |  | 477500 |  |  | 477500 |  |  |  |  |  | 456000 |  |  | 477500 |  |  | 477500 |  |  | 477500 |  |  | 477500 |  |  | 477500 |  |  | 477500 |  |  | 477500 |  |  | 477500 |  |  | 477500 |  |  | 477500 |  |  | 477500 |  |  | 477500
Total SAN JUAN       DEMAND
WEST           EOT- WOT | FTS-1 | 334000 |  |  | 314000 |  |  | 314000 |  |  | 328000 |  |  | 328000 |  |  | 328000 |  |  | 328000 |  |  | 328000 |  |  | 328000 |  |  | 328000 |  |  | 314000 |  |  | 314000 |  |  | 314000 |  |  | 314000 |  |  | 314000 |  |  | 306000 |  |  | 306000 |  |  | 306000 |  |  | 306000 |  |  | 306000 |  |  | 306000 |  |  | 306000 |  |  | 306000 |  |  | 306000
WEST           IG - WOT | FTS-1
WEST           SJ - WOT | FTS-1 | 27500 |  |  | 27500 |  |  | 47500 |  |  | 47500 |  |  | 47500 |  |  | 47500 |  |  | 47500 |  |  | 47500 |  |  | 47500 |  |  | 47500 |  |  | 69000 |  |  | 69000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000
WEST           THOR - WOT | FTS-1 | 265000 |  |  | 265000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000 |  |  | 245000
WEST           WOT - WOT | FTS-1 | 1300 |  |  | 1300 |  |  | 1300 |  |  | 1300 |  |  | 1300 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 1300 |  |  | 1300 |  |  | 1300 |  |  | 1300 |  |  | 1300 |  |  | 1300 |  |  | 1300 |  |  | 1300 |  |  | 1300 |  |  | 1300 |  |  | 1300 |  |  | 1300
Total WEST          DEMAND
Separated for FINAL DEMAND REVENUE Calculation | CALC
ONE-PART RATE DEMAND CONTRACTS VOLUMES
EAST           EOT -EOT | FTS-1
EAST           IG - EOT | FTS-1
EAST           SJ - EOT | FTS-1
EAST           THOR- EOT | FTS-1
EAST           WOT -EOT | FTS-1
Total EAST           DEMAND
IGNACIO        EL PASO BLANCO | FTS-1
Total IGNACIO        DEMAND
IGN_BLANCO | FTS-1
Total IGN_BLANCO     DEMAND
SAN JUAN       SJ - SJ | FTS-1
SAN JUAN       SJ - THOR | FTS-1
Total SAN JUAN       DEMAND
WEST           EOT- WOT | FTS-1
WEST           IG - WOT | FTS-1
WEST           SJ - WOT | FTS-1
WEST           THOR - WOT | FTS-1
WEST           WOT - WOT | FTS-1
Total WEST          DEMAND
Separated for FINAL DEMAND REVENUE Calculation | CALC
ONE-PART RATE CONTRACTS - DEMAND COMMODITY CREDIT
EAST           EOT -EOT | FTS-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093
EAST           IG - EOT | FTS-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104
EAST           SJ - EOT | FTS-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104 |  |  | 0.0104
EAST           THOR- EOT | FTS-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093
EAST           WOT -EOT | FTS-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093 |  |  | 0.0093
Total EAST           DEMAND
IGNACIO        EL PASO BLANCO | FTS-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033 |  |  | 0.0033
Total IGNACIO        DEMAND
IGN_BLANCO | FTS-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011
Total IGN_BLANCO     DEMAND
SAN JUAN       SJ - SJ | FTS-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011
SAN JUAN       SJ - THOR | FTS-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011 |  |  | 0.0011
Total SAN JUAN       DEMAND
WEST           EOT- WOT | FTS-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246 |  |  | 0.0246
WEST           IG - WOT | FTS-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186
WEST           SJ - WOT | FTS-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186 |  |  | 0.0186
WEST           THOR - WOT | FTS-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175
WEST           WOT - WOT | FTS-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175 |  |  | 0.0175
Total WEST          DEMAND
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -16000
CALCULATION
FINAL DEMAND REVENUES AND [NAME] |  | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand | Demand
Demand Summary
EAST           EOT -EOT | FTS-1
EAST           IG - EOT | FTS-1
EAST           SJ - EOT | FTS-1
EAST           THOR- EOT | FTS-1
EAST           WOT -EOT | FTS-1
Total EAST           DEMAND
IGNACIO        EL PASO BLANCO | FTS-1
Total IGNACIO        DEMAND
IGN_BLANCO | FTS-1
Total IGN_BLANCO     DEMAND
SAN JUAN       SJ - SJ | FTS-1
SAN JUAN       SJ - THOR | FTS-1
Total SAN JUAN       DEMAND
WEST           EOT- WOT | FTS-1
WEST           IG - WOT | FTS-1
WEST           SJ - WOT | FTS-1
WEST           THOR - WOT | FTS-1
WEST           WOT - WOT | FTS-1
Total WEST          DEMAND