Spreadsheet: lisa_gang__22336__purchase summary March - May
Sheet: April Purchase Summary

ENA Positions |  | APRIL
 |  |  |  |  |  |  |  |  |  |  | Price |  |  |  | Dollars |  |  |  | MWHs
 |  | Position to fill |  |  |  |  |  |  | Source |  | 416 |  | 303
Zone |  | Peak |  |  | Off-Peak |  |  |  |  |  | Peak |  | Off-Peak |  | Peak | Off-Peak | Total |  | Peak | Off-Peak
PV |  | 100 | 37.55 | Allegheny |  |  |  |  |  |  | 37.55 |  | 0 |  | 1562080 | 0 | 1562080 |  | 41600 | 0
 |  | 100 | 38 | Avista | 75 | 28 | Avista |  |  |  | 38 |  | 28 |  | 1580800 | 636300 | 2217100 |  | 41600 | 22725
 |  | 155 | 38 | Sempra |  |  |  |  |  |  | 38 |  | 0 |  | 2450240 | 0 | 2450240 |  | 64480 | 0
SP15 |  | 75 | 38.2 | Allegheny | 50 | 29.25 | Allegheny |  |  |  | 38.2 |  | 29.25 |  | 1191840 | 443137.5 | 1634977.5 |  | 31200 | 15150
 |  | 37 | 38.25 | AEP | 76 | 29.5 | AEP |  |  |  | 38.25 |  | 29.5 |  | 588744 | 679326 | 1268070 |  | 15392 | 23028
NP 15 |  | 94 | 38.25 | Sempra | 115 | 30.5 | Sempra |  |  |  | 38.25 |  | 30.5 |  | 1495728 | 1062772.5 | 2558500.5 |  | 39104 | 34845
Mid - C |  | 100 | 32 | Allegheny | 50 | 27.25 | Allegheny |  |  |  | 32 |  | 27.25 |  | 1331200 | 412837.5 | 1744037.5 |  | 41600 | 15150
 |  | 50 | 32.5 | Sempra |  |  |  |  |  |  | 32.5 |  | 0 |  | 676000 | 0 | 676000 |  | 20800 | 0
 |  | 50 | 32.5 | AEP |  |  |  |  |  |  | 32.5 |  | 0 |  | 676000 | 0 | 676000 |  | 20800 | 0
 |  | 125 | 32.5 | Avista | 200 | 27.5 | Avista |  |  |  | 32.5 |  | 27.5 |  | 1690000 | 1666500 | 3356500 |  | 52000 | 60600
 |  | 53 | 32.5 | Avista | 53 | 27.5 | Avista |  |  |  | 32.5 |  | 27.5 |  | 716560 | 441622.5 | 1158182.5 |  | 22048 | 16059
COB/mid spread |  | -125 | 35 | Avista | -200 | 28.75 | Avista |  |  |  | 35 |  | 28.75 |  | -1820000 | -1742250 | -3562250 |  | -52000 | -60600
Mead |  | 75 | 39.25 | AEP |  |  |  |  |  |  | 39.25 |  | 0 |  | 1224600 | 0 | 1224600 |  | 31200 | 0
 |  | 50 | 38.85 | Allegheny |  |  |  |  |  |  | 38.85 |  | 0 |  | 808080 | 0 | 808080 |  | 20800 | 0
Pinnacle Peak |  | 25 | 41 | AEP |  |  |  |  |  |  | 41 |  | 0 |  | 426400 | 0 | 426400 |  | 10400 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 401024 | 126957
* Hanson was purchased through EES |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Purchases |  | 18198518
 |  |  |  |  |  |  |  |  |  |  |  |  | EPMI Summary |  |  |  |  | Net
 |  |  |  |  |  |  |  |  |  |  |  | x | Sempra |  | 4621968 | 1062772.5 | 5684740.5 | 6350142.234656085
 |  |  |  |  |  |  |  |  |  |  |  | x | Allegheny |  | 4893200 | 855975 | 5749175 | 8071543.41931217
 |  |  |  |  |  |  |  |  |  |  |  | x | AEP |  | 2915744 | 679326 | 3595070 | 5800926.334656085
 |  |  |  |  |  |  |  |  |  |  |  | x | Avista |  | 2167360 | 1002172.5 | 3169532.5 | 7107772.921375662
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18198518
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Receivables | Northwest | 10256495.26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cal and SW | 35276195.15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45532690.41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net | 27334172.41
EES Positions |  |  |  | April
 |  |  |  |  |  |  |  |  |  |  | Price |  |  |  | Dollars |  |  |  | MWHs
 |  | Position to fill |  |  |  |  |  |  | Source |  | 416 |  | 303
Zone |  | Peak |  |  | Off-Peak |  |  |  |  |  | Peak |  | Off-Peak |  | Peak | Off-Peak | Total |  | Peak | Off-Peak
NP 15 |  | 400 | 40 | Allegheny | 325 | 31.3 | Allegheny |  |  |  | 40 |  | 31.3 |  | 6656000 | 3082267.5 | 9738267.5 |  | 166400 | 98475
 |  | 150 | 37.5 | Avista | 100 | 30 | Avista |  |  |  | 37.5 |  | 30 |  | 2340000 | 909000 | 3249000 |  | 62400 | 30300
SP15 |  | 550 | 40 | Allegheny | 200 | 31.3 | Allegheny |  |  |  | 40 |  | 31.3 |  | 9152000 | 1896780 | 11048780 |  | 228800 | 60600
 |  | 150 | 38 | Avista | 100 | 30 | Avista |  |  |  | 38 |  | 30 |  | 2371200 | 909000 | 3280200 |  | 62400 | 30300
 |  |  |  |  | 175 | 30.75 | AEP |  |  |  |  |  | 30.75 |  |  | 1630518.75 | 1630518.75 |  | 0 | 53025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28946766.25 |  | 520000 | 272700