Spreadsheet: phillip_m_love__31095__Consumers Recon
Sheet: 2001

Consumers Gas Reconciliation
2001
 | Consumers' Invoice |  |  |  | Enron's Numbers
 |  |  |  |  | Deal # | Unify |  |  | Paid | Pay Date | Comments
2001-01-01 00:00:00 | 5030-82-66 | 58353 | 0.21 | 12254.19 | 435102 | 55574 | 0.21 |  | 0 |  | open sale due Consumers
 | 5050-82-69 | 500002 | 0.055 | 27500.1 | 499639 | 500002 | 0.055 |  | 27500.11 | 2001-02-27 00:00:00
 | 5030-82-71 |  |  | 41984.04 | 569538 | 446914 |  | 41933.95 | 41933.95 | 2001-02-27 00:00:00
Sub-Total
GST |  |  |  | 5721.683 |  |  |  | 5718.01 | 4860.38
Total |  |  |  |  |  |  |  |  |  | 2001-02-27 00:00:00
2001-01-01 00:00:00 | 5030-82-67 | 785315 | 0.01 | 7853.15 | 551292 | 744330 | 0.01 |  | 7443.3 | 2001-02-27 00:00:00
Canadian$$ | 5030-82-70 | 21819 | 0.01 | 218.19 | 551248 | 20681 | 0.01 | 141.92 | 141.92 | 2001-02-27 00:00:00
Sub-Total
GST |  |  |  | 564.99 |  |  |  | 530.96 | 530.96
Total |  |  |  |  |  |  |  |  |  | 2001-02-27 00:00:00
2001-01-01 00:00:00 |  |  |  |  | 387756 | 310000 | -0.125 |  | 0 |  | open sale due ENA
[NAME]
 |  |  |  |  |  |  |  | -2712.5
2001-02-01 00:00:00 | 5040-82-42 | 500000 | 0.0175 | 8750 |  |  |  |  | 0
 | 5040-82-42 |  |  | 24493.69 | 618840 | 500001 |  | 24493.69 | 24493.69 | 2001-03-29 00:00:00
 | 5040-82-52 | 150000 | 0.035 | 5250 | 352028 | 149998 | 0.035 |  | 5249.93 | 2001-03-26 00:00:00
 | 5040-82-53 | 155000 | 0.07 | 10850 | 352038 | 154995 | 0.07 |  | 10849.65 | 2001-03-26 00:00:00
 | 5030-82-66 | 52706 | 0.21 | 11068.3 | 435102 | 52696 | 0.21 |  | 11066.16 | 2001-03-26 00:00:00
 | 5030-82-71 |  |  | 54757.67 | 596062 | 502006 |  | 53957.68 | 53957.68 | 2001-03-26 00:00:00
 | 5030-82-72 | 182216 | 0.01 | 1822.16 | 596860 | 182224 | 0.01 |  | 1822.24 | 2001-03-26 00:00:00
 | 5030-82-73 | 27574 | 0.01 | 275.74 | 596819 | 27580 | 0.01 |  | 275.8 | 2001-03-26 00:00:00
 | 5030-82-75 | 4479 | 0.06 | 268.76 | 633142 | 4479 | 0.06 |  | 268.74 | 2001-03-26 00:00:00
 |  |  |  |  | 244662 | 154995 | -0.0495 |  | 0 |  | open sale due ENA
Sub-Total
GST |  |  |  | 8227.54 |  |  |  | 7021.81 | 7558.87
Total
2001-02-01 00:00:00 | 5040-82-33 |  |  | 7750.35 | 636507 | 310014 | -0.025 |  | 0 |  | open-wrong sign on price
Canadian $$ | 5040-82-35 |  |  | 365.93 | 636515 | 14637 | -0.025 |  | 0 |  | open-wrong sign on price
Sub-Total
GST |  |  |  | 568.14 |  |  |  | -568.14
Total |  |  |  |  |  |  |  |  | 0
2001-02-01 00:00:00 |  |  |  |  | 387756 | 280000 | -0.125 |  | 0 |  | open sale due ENA
[NAME]
 |  |  |  |  |  |  |  | -2450
2001-03-01 00:00:00 | 5040-82-39 | 434801 | 0.1875 | 81525.12 | 664776 | 434802 | 0.2175 |  | 94569.44 | 2001-04-25 00:00:00
 | 5040-82-39 | 434801 | 0.03 | 13044.03 |  |  |  |  | 0 |  | no deal
 | 5040-82-47 | 310000 | 0.15375 | 47662.5 | 266980 | 309988 | 0.15375 |  | 47660.66 | 2001-04-25 00:00:00
 | 5030-82-59 | 310000 | 0.085 | 26350 |  |  |  |  | 0 |  | no deal
 | 5030-82-66 | 58353 | 0.21 | 12254.19 | 435102 | 58342 | 0.21 |  | 12251.82 | 2001-04-25 00:00:00
 | 5030-82-73 | 30558 | 0.01 | 305.58 | 646648 | 30566 | 0.01 |  | 305.66 | 2001-04-25 00:00:00
 | 5040-82-74 | 93000 | 0.42 | 39060 | 618986 | 93005 | 0.42 | 39060 | 39060 | 2001-04-25 00:00:00
Sub-Total
GST |  |  |  | 15414.1 |  |  |  | 13569.34 | 13569.34
Total |  |  |  |  |  |  |  |  |  | 2001-04-25 00:00:00
2001-04-01 00:00:00 | 5040-82-39 | 9127 | 0.1875 | 1711.4 | 664842 | 60960 | -0.1875 |  | -11430 | 2001-05-25 00:00:00
 |  |  |  |  | 229639 | 70080 | 0.1875 |  | 13140 | 2001-05-25 00:00:00 | sale
 | 5070-82-60 |  |  | 5683.33 | 810064 |  |  | 5683.33 | 5683.33 | 2001-05-25 00:00:00 | sale
 | 5030-82-76 | 29174 | 0.02 | 583.48 | 705987 | 29160 | 0.02 |  | 583.2 | 2001-05-25 00:00:00
 | 5030-82-77 | 229580 | 0.02 | 4591.6 | 705197 | 229590 | 0.02 |  | 4591.8 | 2001-05-25 00:00:00
 | 5030-82-78 | 134 | 0.04 | 5.35 | 735257 | 134 | 0.04 |  | 5.36 | 2001-05-25 00:00:00 | Consumers Energy
 | 5030-82-79 | 53842 | 0.04 | 2153.67 | 742957 | 53843 | 0.04 |  | 2153.72 | 2001-05-25 00:00:00 | Consumers Energy
Sub-Total
GST |  |  |  | 1031.02 |  |  |  | 1030.54 | 1030.54
Total |  |  |  |  |  |  |  |  |  | 2001-05-25 00:00:00
2001-05-01 00:00:00 | 5040-82-39 | 9432 | 0.1875 | 1768.45 | 664842 | 62992 | -0.1875 |  | -11811 | 2001-06-22 00:00:00
 |  |  |  |  | 229639 | 72416 | 0.1875 |  | 13578 | 2001-06-25 00:00:00 | sale
 | 5040-82-51 | 310000 | 0.045 | 13950 | 775629 | 300002 | 0.045 |  | 13500.09 | 2001-06-25 00:00:00 | sale
 | 5070-82-60 |  |  | 5683.33 | 810064 |  |  | 5683.33 | 5683.33 | 2001-06-25 00:00:00 | sale
 | 5030-82-80 | 81756 | 0.045 | 3679.01 | 762288 | 81756 | 0.045 |  | 3679.02 | 2001-06-25 00:00:00
 | 5050-82-81 | 300000 | 0.045 | 13500.01 | 305671 | 309987 | 0.045 |  | 13949.42 | 2001-06-22 00:00:00
 | 5030-82-82 | 3221 | 0.01 | 32.21 | 818758 | 3221 | 0.01 |  | 32.21 | 2001-06-25 00:00:00
Sub-Total
GST |  |  |  | 2702.91 |  |  |  | 2702.03 | 2702.03
Total |  |  |  |  |  |  |  |  |  | 2001-06-25 00:00:00
2001-06-01 00:00:00 | 5040-82-39 | 9127 | 0.1875 | 1711.4 | 664842 | 60960 | -0.1875 |  | -11430 | 2001-07-25 00:00:00
 |  |  |  |  | 229639 | 70080 | 0.1875 |  | 13140 | 2001-07-25 00:00:00 | sale
 | 5040-82-58 | 310000 | 0.28 | 86799.9 | 396222 | 309997 | 0.14 |  | 43399.58 | 2001-07-25 00:00:00 | Consumers Energy
 | 5070-82-60 |  |  | 5683.33 | 810064 |  |  | 5683.33 | 5683.33 | 2001-07-25 00:00:00 | sale
 | 5030-82-82 | 12889 | 0.01 | 128.89 | 860944 | 12889 | 0.01 |  | 128.89 | 2001-07-25 00:00:00
 | 5030-82-83 |  |  | 72217.84 | 821693 | 287000 |  | 37995.5 | 37995.5 | 2001-07-25 00:00:00
 |  |  |  |  | 840634 | 272000 |  | 34222.5 | 34222.5 | 2001-07-25 00:00:00
 | 5030-82-84 | 164781 | 0.04 | 6591.23 | 823708 | 164780 | 0.04 |  | 6591.2 | 2001-07-25 00:00:00
 | 5050-82-85 | 310000 | 0.0225 | 6974.99 | 838763 | 310001 | -0.0225 |  | -6975.02 | 2001-07-25 00:00:00 | wrong sign on price?
 | 5030-82-86 | 1440000 | 0.025 | 36000 | 847117 | 1214131 | 0.025 |  | 30353.28 | 2001-07-25 00:00:00
 | 5040-82-88 | 34874 | 0.04 | 1394.96 | 886615 | 34874 | 0.02 |  | 697.48 | 2001-07-25 00:00:00
 | 5040-82-90 | 65665 | 0.05 | 3283.24 | 888990 | 65665 | 0.025 |  | 1641.63 | 2001-07-25 00:00:00
 |  |  |  |  | 819040 | 64003 | 0.11 |  | 0 |  | open sale due Consumers
Sub-Total
GST |  |  |  | 15455.01 |  |  |  | 6853.54 | 6360.71
Total |  |  |  |  |  |  |  |  |  | 2001-07-25 00:00:00
2001-07-01 00:00:00 | 5040-82-39 | 9432 | 0.1875 |  | 664842 | 62992 | -0.1875 | -11811 |  | 2001-08-24 00:00:00
 |  |  |  |  | 229639 | 72416 | 0.1875 | 13578 |  | 2001-08-24 00:00:00 | sale
 | 5070-82-60 |  |  | 5683.33 | 810064 |  |  | 5683.33 |  | 2001-08-24 00:00:00 | sale
 | 5030-82-84 | 6493 | 0.04 |  | 893024 | 6492 | 0.04 | 259.68 |  | 2001-08-24 00:00:00
 | 5030-82-89 | 3689000 | 0.04 |  | 889201 | 1870149 |  | 147559.96 |  | 2001-08-24 00:00:00
 | 5030-82-91 | 144298 | 0.01 |  | 893017 | 144396 | 0.01 | 1443.96 |  | 2001-08-24 00:00:00
 | 5040-82-92 | 100000 | 0.05 |  | 939664 | 100000 | 0.05 | 5000 |  | 2001-08-24 00:00:00
 | 5040-82-93 | 100000 | 0.05 |  | 936112 | 100000 | 0.05 | 5000 |  | 2001-08-24 00:00:00
Sub-Total
GST |  |  |  | 11670.01 |  |  |  | 1341.38 | 1341.38 |  | billed GST on Mich Con gas
Total |  |  |  |  |  |  |  |  |  | 2001-08-24 00:00:00
2001-08-01 00:00:00 | 5040-82-39 | 9432 | 0.1875 | 1768.45 | 664842 | 62992 | -0.1875 |  | -11811 | 2001-09-25 00:00:00
 |  |  |  |  | 229639 | 72416 | 0.1875 |  |  | 2001-09-25 00:00:00 | sale
 | 5040-82-51 | 310000 | 0.045 | 13949.98 | 305678 | 309987 | 0.045 |  |  | 2001-09-25 00:00:00 | sale
 | 5070-82-60 |  |  | 5683.33 | 810064 |  |  | 5683.33 |  | 2001-09-25 00:00:00 | sale
 | 5030-82-82 | 17500 | 0.01 | 175 | 975392 | 17499 | 0.01 |  |  | 2001-09-25 00:00:00
 | 5030-82-83 | 10000 | 0.11 | 1100 | 985366 | 10000 | 0.11 |  |  | 2001-09-25 00:00:00
 | 5030-82-83 | 27000 | 0.14 | 3780 | 985366 | 27000 | 0.14 |  |  | 2001-09-25 00:00:00
 | 5030-82-84 | 17885 | 0.04 | 715.41 | 967378 | 17885 | 0.04 |  |  | 2001-09-25 00:00:00
 | 5050-82-85 | 310000 | 0.0225 | 6974.99 | 838774 | 309987 | 0.0225 |  |  | 2001-09-25 00:00:00
 | 5030-82-91 | 239133 | 0.01 | 2391.33 | 958435 | 239148 | 0.01 |  |  | 2001-09-25 00:00:00
 | 5030-82-94 | 624898 | 0.015 |  | 954465 | 610334 | 0.035 |  |  | 2001-09-25 00:00:00
 |  | 610331 | 0.02
 |  |  |  |  | 958436 | 1008 | 0.01 |  | 0 |  | open
 |  |  |  |  | 889006 | 65654 | 0.025 |  | 0 |  | open sale due Consumers
Sub-Total
GST |  |  |  | 4068.3 |  |  |  | 3456.11 | 3341.22
Total |  |  |  |  |  |  |  |  |  | 2001-09-25 00:00:00
2001-09-01 00:00:00 | 5040-82-39 | 9127 | 0.1875 |  | 664842 | 60960 | -0.1875 |  |  | 2001-10-25 00:00:00
 |  |  |  |  | 229639 | 70080 | 0.1875 |  |  | 2001-10-25 00:00:00 | sale
 | 5050-82-81 | 300013 | 0.045 |  | 775742 | 300000 | 0.045 |  |  | 2001-10-25 00:00:00
 | 5030-82-95 | 4589 | 0.02 |  | 1029566 | 4589 | 0.01 |  |  | 2001-10-25 00:00:00
 |  |  |  |  | 1029516 | 4589 | 0.01 |  |  | 2001-10-25 00:00:00 | sale
 | 5070-82-60 |  |  | 5683.33 | 810064 |  |  | 5683.33 |  | 2001-10-25 00:00:00
Sub-Total
GST |  |  |  | 1469.1 |  |  |  | 1468.96 | 1468.96
Total |  |  |  |  |  |  |  |  |  | 2001-10-25 00:00:00