Spreadsheet: louise_kitchen__22662__full year forecast without orig
Sheet: GrossMargin

Enron North America
Gross Margin by Quarter
Full Year Forecast
(Without Origination Margin Plan 4Q)
Business Team |  | Margin [NAME] |  |  |  | Total
 |  | 1Q Actual | 2Q Actual | 3Q Actual | 4Q Plan + known variances | YTD Margin | Full Year Plan | [NAME]
 |  | 29328 | 124775 | 16103 | 12500 |  | 50000
 |  | 9710 | -225 | 304 | 0 |  | 30000
 |  | 782 | 125001 | -31008 | 12500 |  | 50000
 |  | 1627 | 3252 | 307 | 0 |  | 30000
 |  | 9837 |  | -2750 | 7500 |  | 50000
 |  |  | 428 | 1696 | 0 |  | 30000
 |  | 3099 | 2911 | 21305 | 4375 |  | 17500
 |  | 203 | 2189 | 18070 | 0 |  | 17500
 |  | -54 | 22157 | 1764 | 0 |  | 0
 |  | -2347 | 80975 | -34244 | 1250 |  | 5000
 |  | 0 | 1190 | 214 | 0 |  | 0
 |  | 5711 | 8484 | 2580 | 6000 |  | 24000
 |  | 10955 | 3276 | -5677 | 20000 |  | 80000
 |  | 0 | 0 | 0 |  |  | 0
Total East Power |  |  |  | -11336 |  |  | 384000
 |  | 360460 | 215662 | 156011 | 62501 |  | 250000
 |  | 0 | 0 | 0 | 0 |  | 0
 |  | 10647 | 26994 | 14774 | 0 |  | 50000
 |  | 733 | 38361 | 5328 | 0 |  | 62988
 |  | -5195 | 10500 | 755 | 5250 |  | 14000
 |  | 0 | 56895 | -454 | -1001 |  | 46000
 |  | 0 | 0 | 0 | 0 |  | 0
Total West Power |  |  |  | 176414 |  |  | 422988
 |  | -56221 | 62960 | 8391 | 15000 |  | 60000
 |  | 4714 | 4075 | 822 | 0 |  | 20000
 |  | -3182 | 174031 | 26978 | 15750 |  | 63000
 |  | 1487 |  | 2457 | 0 |  | 17000
 |  | 56708 | 71976 | 33353 | 10000 |  | 40000
 |  | 0 | 0 | 1 | 0 |  | 0
 |  | 344226 | -429416 | -134389 | 26500 |  | 20000
 |  | 7108 | 33451 | 9012 | 0 |  | 106000
 |  | 230802 | 399775 | 116324 | 31250 |  | 125000
 |  | 9510 | 10919 | 7763 | 6250 |  | 25000
 |  | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0
 |  | -40000 | -207000 | 501000 | 0 |  | 0
Total Natural Gas |  |  |  | 571712 |  |  | 476000
 |  | -26713 |  | 775 |  |  | 25000
 |  | 6872 | 5351 | 1753 | 0 |  | 25000
 |  | 2886 | 4568 | 317 |  |  | 20000
 |  | 87417 | 82154 | 67767 |  |  | 77500
 |  | 26010 | 3339 | 50198 | 0 |  | 77500
 |  | 0 | -712 | 481 |  |  | 50000
 |  | 1112 | 199 | 0 |  |  | 10000
Total Canada |  |  |  | 121291 |  |  | 285000
 |  | 4277 | 12950 | -3729 | 7506 |  | 40546
 |  | 4703 | -185 | -4498 | 2909 |  | 11637
 |  |  |  | 1692 |  |  | 21103
 |  | 65 | 1885 | 1449 |  |  | 60000
 |  | 10729 | 7357 | 1168 | 25917 |  | 51643
 |  | 4599 | 3742 | 3597 | 0 |  | 0
 |  | 0 | 3000 | 0 | 5000 |  | 20000
 |  | -3592 | -2816 | 0 | 0 |  | 27812
 |  | 0 | 0 | 0 | 0 |  | 5000
 |  |  | 408798 | 19979 | 0 |  | -12065
 |  | -16596 | 37722 | -22394 | 0 |  | 0
 |  | -23432 | 611 | 0 |  |  | -108268
 |  | 0 | 0 | 0 | 0 |  | 0
 |  | -18675 | 4410 | 17 | 0 |  | -18500
Total Commercial
 |  |  |  | 0
Business Analysis & Reptg (Colwell) |  | 0 | 0 | 0 | 0 |  | 0
Transaction Support (Colwell) |  | 0 | 0 | 0 | 0 |  | 0
Canada Support (Milnthorp) |  | 0 | 0 | 0 | 0 |  | 0
Energy Operations (Beck) |  | 0 | 0 | 0 | 0 |  | 0
Human Resources (Oxley) |  | 0 | 0 | 0 | 0 |  | 0
Legal (Haedicke) |  | 0 | 0 | 0 | 0 |  | 0
Public Relations (Thoede) |  | 0 | 0 | 0 | 0 |  | 0
Tax ([NAME]) |  | 0 | 0 | 0 | 0 |  | 0
Research (Kaminski) |  | 0 | 0 | 0 | 0 |  | 0
Competitive Analysis (Tholan) |  | 0 | 0 | 0 | 0 |  | 0
Treasury (Deffner) |  | 0 | 0 | 0 | 0 |  | 0
Technical Services (Redmond)) |  | 0 | 0 | 0 | 0 |  | 0
Information Technology (Pickering) |  | 0 | 0 | 0 | 0 |  | 0
Corp Charges and Non-Allocable |  | 0 | 0 | 0 | 0 |  | 0
Total Group |  |  |  | 0
 |  | 0 | 0 | -21600 | 0 |  | 0
 |  | 49140 | 40486 | 31751 | 28610 |  | 118538
 |  | -24207 | -12781 | -10589 | -13000 |  | -52000
 |  | 0 | 5195 | 2773 | 0 |  | 0
North America Margin
South America Margin |  | 9364 | 18780 | 0 | 0 |  | 38100
Americas Margin
* LT Fundamentals, Special Assets