Spreadsheet: james_steffes__12981__Savings_Analysis
Sheet: Savings_Final

Long-term Contracts & Spot Market Purchases |  |  |  |  |  |  |  |  |  |  |  |  | Long-term Contracts & Spot Market Purchases |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contracts for Energy Requirement
Monthly Analysis | 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 | TOTAL (Billions) |  |  | Annual Analysis | May00-May01 | May01-Dec01 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 |  |  |  | Annual Analysis | May00-May01 | May01-Dec01 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | TOTAL (Billions)
Net Short (MWHs 000s) | 6582 | 6064 | 4750 | 5589 | 6508 | 6868 | 5685 | 5081 | 5103 |  |  |  | Net Short (MWHs 000s) | 79717 | 72755 | 71272 | 78689 | 87873 | 91027 | 95976 | 101224 | 106682 | 110411 | 114436
Total Contracted for DWR (MWHs 000s) | 1200 | 1592 | 1990 | 2472 | 2740 | 2791 | 2703 | 2442 | 2438 |  |  |  | MAY00-MAY01 (MWHs 000s) | 10000 | 19167 | 45213 | 68000 | 87000 | 83000 | 84000 | 81000 | 81000 | 81000 | 80000 |  |  |  | Annual Projected Requ (MWHs 000s) | 189983 | 196797 | 200524 | 204360 | 208015 | 210500 | 214448 | 218688 | 223263 | 226848 | 230927
Price paid ($/MWh) | 130 | 130 | 130 | 138 | 138 | 138 | 142 | 142 | 142 |  |  |  | Price paid (Billion $) | 187.975472727827 |  |  |  |  |  |  |  |  |  |  |  |  |  | Price paid  ($/MWh) | 187.975472727827
Cost, 1 month strips |  |  | C | O | S | T | S |  |  |  |  |  | Cost, 1 yr strips |  | C | O | S | T | S |  |  |  |  |  |  |  |  | Cost, 1 yr strips |  | C | O | S | T | S
Avg. Future Spot Price Curve ($/MWh), 6/28/2000 |  |  |  |  |  |  |  |  |  |  |  |  | Avg. Future Spot Price Curve ($/MWh) |  | 105.416666517034 | 62.24999993449691 | 41.87499995715913 | 40.41666663407035 | 40.41666663407035 | 33.33333334264653 | 33.33333334264653 | 33.33333334264653 | 33.33333334264653 | 33.33333334264653 |  |  |  | Avg. Future Spot Price Curve ($/MWh) |  | 105.416666517034 | 62.24999993449691 | 41.87499995715913 | 40.41666663407035 | 40.41666663407035 | 33.33333334264653 | 33.33333334264653 | 33.33333334264653 | 33.33333334264653 | 33.33333334264653
Avg. Future Spot Price Curve ($/MWh), 7/20/2000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S | A | V | I | N | G | S | $ Billion) |  |  |  |  |  |  |  | S | A | V | I | N | G | S | (Billion $)
 |  | S | A | V | I | N | G | S | ($ Billion) |  |  |  | Future Spot Price (Avg. SP15 & NP15) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Future Spot Price (Avg. SP15 & NP15)
Average Future Spot Price |  |  |  |  |  |  |  |  |  |  |  |  | Fixed price $45/MWh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fixed price $45/MWh
2000-06-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Fixed price $50/MWh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fixed price $50/MWh
2000-07-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Fixed price $55/MWh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fixed price $55/MWh
Fixed price $45/MWh
Fixed price $50/MWh
Fixed price $55/MWh |  |  |  |  |  |  |  |  |  |  |  |  | Demand Elasticity and Conservation Measures
 |  |  |  |  |  |  |  |  |  |  |  |  |  | May00-Apr01 | May01-Dec01 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | TOTAL SAVINGS (BILLIONS) |  |  | San Diego Gas and Electric | 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 | Total/Average
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Energy Purchased ('000 MWh) | 744 | 720 | 744 | 720 | 744
 |  |  |  |  |  |  |  |  |  |  |  |  | Load reduction scenarios (2000) '000 [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Price Paid ($/MWh) | 147.98 | 103.11 | 85.63 | 128.28 | 169
Qualifying Facilities (MWs) |  |  |  |  |  |  |  |  |  |  |  |  | A. Conservation 4%, Demand Elasticity 3%
 | Total Installed Capacity in State  53810 ;  Total QF Capacity  10793 ; Share  20% (Source: California Energy Commission Database, 2001) |  |  |  |  |  |  |  |  |  |  |  | B. Conservation 3%, Demand Elasticity 2.5% |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Savings ($ Million)
 | 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
Approx. MWs of QFs out of service |  |  |  |  |  |  |  |  |  |  |  |  | Price paid ($/MWh) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] contract @ fixed price $55/MWh
Scenario 1 | 1800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] contract @ fixed price $60/MWh
Scenario 2 | 2000 |  |  |  |  |  |  |  |  |  |  |  |  |  | S | A | V | I | N | G | S | ($ Billion) |  |  |  |  |  | [NAME] contract @ fixed price $70/MWh
 |  |  |  |  |  |  |  |  |  |  |  |  | Scenario A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] contract @ fixed price $80/MWh
Assuming an 85% Load Factor, MWHs of QFs out of Service |  |  |  |  |  |  |  |  |  |  |  |  | Scenario B
Scenario 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | San Diego Gas and Electric | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006
Scenario 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Energy Purchased ('000 MWh)
Avg. Spot Prices ($/MWh) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Price Paid ($/MWh) | 107
Rate Charged by QFs $/MWh | 125 | 125 | 125 | 125 | 125 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Future Price Curve (SP15-Flat) | 90 | 67.17072867429575 | 49.28565449530088 | 38.19665466947782 | 36.33490500008279 | 36.33639695759725 | 36.54224010489801 | SDG&E | State
 |  | S | A | V | I | N | G | S | (S Billion) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Savings ($ Billion)
Savings from contracts with QFs |  |  |  |  |  |  |  |  |  | TOTAL SAVINGS (BILLIONS) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Future Price Curve Purchases
Scenario 1
Scenario 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fixed price $45/MWh
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fixed price $50/MWh
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fixed price $55/MWh