Spreadsheet: craig_dean__4381__MDEA P&L Report
Sheet: May12

Profit Sharing Summary
Operation Day: |  | 2001-05-12 00:00:00
 |  | 2001-05-12 00:00:00 |  | Gen Cost Reference |  |  | Gross Savings |  | Net Share of Savings (Per Agreement) |  |  |  | Costs by each party |  |  |  |  | Net Profit/Savings Summary
 | Day-Ahead Transactions |  |  |  |  |  | MDEA Gross Savings | MDEA Gross Savings | EPMI Share | MDEA Share | EPMI Share | MDEA Share | Per Mwh |  | Cost * Mwh
 |  |  |  | Day-Ahead | Day-Ahead | Day-Ahead Gen | (BEFORE EPMI Share) | (BEFORE EPMI Share) | 40% Pk,$1 OffPk | 60% Share Pk* | 40% Share Pk | 60% Share Pk |  |  |  | (EPMI to bill MDEA) |  | EPMI | MDEA
Date | Hour | Qty | Delivered Market Price | Gas Cdale | Gas Yazoo City | Gen Cost | [NAME] vs. [NAME] (per Mwh) | Per Mwh Savings * Mwhs | Per Mwh | Per Mwh | Per Mwh Savings * Mwhs | Per Mwh Savings * Mwhs | EPMI | MDEA | EPMI | MDEA |  | (Profit) | (Savings)
2001-05-12 00:00:00 | 1 | 0 | 0 | 4.5 | 4.5 | 63.23
2001-05-12 00:00:00 | 2 | 0 | 0 | 4.5 | 4.5 | 63.23
2001-05-12 00:00:00 | 3 | 0 | 0 | 4.5 | 4.5 | 63.23
2001-05-12 00:00:00 | 4 | 0 | 0 | 4.5 | 4.5 | 63.23
2001-05-12 00:00:00 | 5 | 0 | 0 | 4.5 | 4.5 | 63.23
2001-05-12 00:00:00 | 6 | 0 | 0 | 4.5 | 4.5 | 63.23
2001-05-12 00:00:00 | 7 | 0 | 0 | 4.5 | 4.5 | 63.23
2001-05-12 00:00:00 | 8 | 0 | 0 | 4.5 | 4.5 | 63.23
2001-05-12 00:00:00 | 9 | 0 | 0 | 4.5 | 4.5 | 63.23
2001-05-12 00:00:00 | 10 | 0 | 0 | 4.5 | 4.5 | 63.23
2001-05-12 00:00:00 | 11 | 20 | 35.5 | 4.5 | 4.5 | 63.23 | 27.73 | 554.6 | 11.092 | 16.638 | 221.84 | 332.76 | 35.5 | 46.592 | 710 | 931.84 |  | 221.84 | 332.76
2001-05-12 00:00:00 | 12 | 25 | 35.5 | 4.5 | 4.5 | 63.23 | 27.73 | 693.25 | 11.092 | 16.638 | 277.3 | 415.95 | 35.5 | 46.592 | 887.5 | 1164.8 |  | 277.3 | 415.95
2001-05-12 00:00:00 | 13 | 25 | 35.5 | 4.5 | 4.5 | 63.23 | 27.73 | 693.25 | 11.092 | 16.638 | 277.3 | 415.95 | 35.5 | 46.592 | 887.5 | 1164.8 |  | 277.3 | 415.95
2001-05-12 00:00:00 | 14 | 25 | 35.5 | 4.5 | 4.5 | 63.23 | 27.73 | 693.25 | 11.092 | 16.638 | 277.3 | 415.95 | 35.5 | 46.592 | 887.5 | 1164.8 |  | 277.3 | 415.95
2001-05-12 00:00:00 | 15 | 25 | 35.5 | 4.5 | 4.5 | 63.23 | 27.73 | 693.25 | 11.092 | 16.638 | 277.3 | 415.95 | 35.5 | 46.592 | 887.5 | 1164.8 |  | 277.3 | 415.95
2001-05-12 00:00:00 | 16 | 25 | 35.5 | 4.5 | 4.5 | 63.23 | 27.73 | 693.25 | 11.092 | 16.638 | 277.3 | 415.95 | 35.5 | 46.592 | 887.5 | 1164.8 |  | 277.3 | 415.95
2001-05-12 00:00:00 | 17 | 25 | 35.5 | 4.5 | 4.5 | 63.23 | 27.73 | 693.25 | 11.092 | 16.638 | 277.3 | 415.95 | 35.5 | 46.592 | 887.5 | 1164.8 |  | 277.3 | 415.95
2001-05-12 00:00:00 | 18 | 25 | 35.5 | 4.5 | 4.5 | 63.23 | 27.73 | 693.25 | 11.092 | 16.638 | 277.3 | 415.95 | 35.5 | 46.592 | 887.5 | 1164.8 |  | 277.3 | 415.95
2001-05-12 00:00:00 | 19 | 25 | 35.5 | 4.5 | 4.5 | 63.23 | 27.73 | 693.25 | 11.092 | 16.638 | 277.3 | 415.95 | 35.5 | 46.592 | 887.5 | 1164.8 |  | 277.3 | 415.95
2001-05-12 00:00:00 | 20 | 25 | 35.5 | 4.5 | 4.5 | 63.23 | 27.73 | 693.25 | 11.092 | 16.638 | 277.3 | 415.95 | 35.5 | 46.592 | 887.5 | 1164.8 |  | 277.3 | 415.95
2001-05-12 00:00:00 | 21 | 25 | 35.5 | 4.5 | 4.5 | 63.23 | 27.73 | 693.25 | 11.092 | 16.638 | 277.3 | 415.95 | 35.5 | 46.592 | 887.5 | 1164.8 |  | 277.3 | 415.95
2001-05-12 00:00:00 | 22 | 25 | 35.5 | 4.5 | 4.5 | 63.23 | 27.73 | 693.25 | 11.092 | 16.638 | 277.3 | 415.95 | 35.5 | 46.592 | 887.5 | 1164.8 |  | 277.3 | 415.95
2001-05-12 00:00:00 | 23 | 20 | 35.5 | 4.5 | 4.5 | 63.23 | 27.73 | 554.6 | 1 | 26.73 | 20 | 534.6 | 35.5 | 36.5 | 710 | 730 |  | 20 | 534.6
2001-05-12 00:00:00 | 24 | 0 | 0 | 4.5 | 4.5 | 63.23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14474.64 |  | 3292.14 | 5442.81
 | match value | 265
 |  |  |  | Gen Cost Reference |  |  | Gross Savings |  | Net Share of Savings (Per Agreement) |  |  |  | Costs by each party |  |  |  |  | Net Profit/Savings Summary
 | Real-Time Transactions |  |  |  |  |  | MDEA Gross Savings | MDEA Gross Savings | EPMI Share | MDEA Share | EPMI Share | MDEA Share | Per Mwh |  | Cost * Mwh
 |  |  |  | Day-Ahead | Day-Ahead | Day-Ahead Gen | (BEFORE EPMI Share) | (BEFORE EPMI Share) | 40% Pk,$1 OffPk | 60% Share Pk* | 40% Share Pk | 60% Share Pk |  |  |  | (EPMI to bill MDEA) |  | EPMI | MDEA
Date | Hour | Qty | Delivered Market Price | Gas Cdale | Gas Yazoo City | Gen Cost | [NAME] vs. [NAME] (per Mwh) | Per Mwh Savings * Mwhs | Per Mwh | Per Mwh | Per Mwh Savings * Mwhs | Per Mwh Savings * Mwhs | EPMI | MDEA | EPMI | MDEA |  | (Profit) | (Savings)
2001-05-12 00:00:00 | 1 | 25 | 18 | 4.5 | 4.5 | 63.23 | 45.23 | 1130.75 | 1 | 44.23 | 25 | 1105.75 | 18 | 19 | 450 | 475 |  | 25 | 1105.75
2001-05-12 00:00:00 | 2 | 24 | 20 | 4.5 | 4.5 | 63.23 | 43.23 | 1037.52 | 1 | 42.23 | 24 | 1013.52 | 20 | 21 | 480 | 504 |  | 24 | 1013.52
2001-05-12 00:00:00 | 3 | 23 | 20 | 4.5 | 4.5 | 63.23 | 43.23 | 994.29 | 1 | 42.23 | 23 | 971.29 | 20 | 21 | 460 | 483 |  | 23 | 971.29
2001-05-12 00:00:00 | 4 | 21 | 20 | 4.5 | 4.5 | 63.23 | 43.23 | 907.83 | 1 | 42.23 | 21 | 886.83 | 20 | 21 | 420 | 441 |  | 21 | 886.83
2001-05-12 00:00:00 | 5 | 20 | 20 | 4.5 | 4.5 | 63.23 | 43.23 | 864.6 | 1 | 42.23 | 20 | 844.6 | 20 | 21 | 400 | 420 |  | 20 | 844.6
2001-05-12 00:00:00 | 6 | 20 | 22 | 4.5 | 4.5 | 63.23 | 41.23 | 824.6 | 1 | 40.23 | 20 | 804.6 | 22 | 23 | 440 | 460 |  | 20 | 804.6
2001-05-12 00:00:00 | 7 | 20 | 22 | 4.5 | 4.5 | 63.23 | 41.23 | 824.6 | 16.492 | 24.738 | 329.84 | 494.76 | 22 | 38.492 | 440 | 769.84 |  | 329.84 | 494.76
2001-05-12 00:00:00 | 8 | 20 | 22 | 4.5 | 4.5 | 63.23 | 41.23 | 824.6 | 16.492 | 24.738 | 329.84 | 494.76 | 22 | 38.492 | 440 | 769.84 |  | 329.84 | 494.76
2001-05-12 00:00:00 | 9 | 20 | 22 | 4.5 | 4.5 | 63.23 | 41.23 | 824.6 | 16.492 | 24.738 | 329.84 | 494.76 | 22 | 38.492 | 440 | 769.84 |  | 329.84 | 494.76
2001-05-12 00:00:00 | 10 | 20 | 26 | 4.5 | 4.5 | 63.23 | 37.23 | 744.6 | 14.892 | 22.338 | 297.84 | 446.76 | 26 | 40.892 | 520 | 817.84 |  | 297.84 | 446.76
2001-05-12 00:00:00 | 11 | 10 | 27 | 4.5 | 4.5 | 63.23 | 36.23 | 362.3 | 14.492 | 21.738 | 144.92 | 217.38 | 27 | 41.492 | 270 | 414.92 |  | 144.92 | 217.38
2001-05-12 00:00:00 | 12 | 7 | 28 | 4.5 | 4.5 | 63.23 | 35.23 | 246.61 | 14.092 | 21.138 | 98.64399999999999 | 147.966 | 28 | 42.092 | 196 | 294.644 |  | 98.64399999999999 | 147.966
2001-05-12 00:00:00 | 13 | 5 | 30 | 4.5 | 4.5 | 63.23 | 33.23 | 166.15 | 13.292 | 19.938 | 66.46 | 99.69 | 30 | 43.292 | 150 | 216.46 |  | 66.46 | 99.69
2001-05-12 00:00:00 | 14 | 10 | 40 | 4.5 | 4.5 | 63.23 | 23.23 | 232.3 | 9.292 | 13.938 | 92.92 | 139.38 | 40 | 49.292 | 400 | 492.92 |  | 92.92 | 139.38
2001-05-12 00:00:00 | 15 | 13 | 38 | 4.5 | 4.5 | 63.23 | 25.23 | 327.99 | 10.092 | 15.138 | 131.196 | 196.794 | 38 |  | 494 | 0 |  | 131.196 | 196.794
2001-05-12 00:00:00 | 16 | 13 | 35 | 4.5 | 4.5 | 63.23 | 28.23 | 366.99 | 11.292 | 16.938 | 146.796 | 220.194 | 35 |  | 455 | 0 |  | 146.796 | 220.194
2001-05-12 00:00:00 | 17 | 13 | 35 | 4.5 | 4.5 | 63.23 | 28.23 | 366.99 | 11.292 | 16.938 | 146.796 | 220.194 | 35 |  | 455 | 0 |  | 146.796 | 220.194
2001-05-12 00:00:00 | 18 | 13 | 35 | 4.5 | 4.5 | 63.23 | 28.23 | 366.99 | 11.292 | 16.938 | 146.796 | 220.194 | 35 | 46.292 | 455 | 601.796 |  | 146.796 | 220.194
2001-05-12 00:00:00 | 19 | 13 | 35 | 4.5 | 4.5 | 63.23 | 28.23 | 366.99 | 11.292 | 16.938 | 146.796 | 220.194 | 35 | 46.292 | 455 | 601.796 |  | 146.796 | 220.194
2001-05-12 00:00:00 | 20 | 10 | 30 | 4.5 | 4.5 | 63.23 | 33.23 | 332.3 | 13.292 | 19.938 | 132.92 | 199.38 | 30 | 43.292 | 300 | 432.92 |  | 132.92 | 199.38
2001-05-12 00:00:00 | 21 | 5 | 30 | 4.5 | 4.5 | 63.23 | 33.23 | 166.15 | 13.292 | 19.938 | 66.46 | 99.69 | 30 | 43.292 | 150 | 216.46 |  | 66.46 | 99.69
2001-05-12 00:00:00 | 22 | 7 | 24 | 4.5 | 4.5 | 63.23 | 39.23 | 274.61 | 15.692 | 23.538 | 109.844 | 164.766 | 24 | 39.692 | 168 | 277.844 |  | 109.844 | 164.766
2001-05-12 00:00:00 | 23 | 9 | 22 | 4.5 | 4.5 | 63.23 | 41.23 | 371.07 | 1 | 40.23 | 9 | 362.07 | 22 | 23 | 198 | 207 |  | 9 | 362.07
2001-05-12 00:00:00 | 24 | 27 | 21 | 4.5 | 4.5 | 63.23 | 42.23 | 1140.21 | 1 | 41.23 | 27 | 1113.21 | 21 | 22 | 567 | 594 |  | 27 | 1113.21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10261.12
 | match value | 265