Spreadsheet: joe_parks__14759__Plant-ENA Gas Recon
Sheet: Plant-ENA Recon

Ponderosa Pine Energy Partners, Ltd. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amounts Due PPEP
Gas Cost Reconciliation
 |  | Estimated Amounts Paid to ENA by PPEP (a) |  |  |  |  |  | Actual Amounts Owed Vendors
Gas Month |  | Commodity (Plant Use) | Commodity (Resale) | Transport [NOTE (b)] | Agency Fees | Reconciling Adjustment | Total Paid ENA | Apache (Supply) | [NAME] (Supply) | Spot Purchases (Supply) | Lone Star (Transport) | Lone Star (Adjustment) | Resale | Agency Fees | Prior Year Adjustments | Other Adjustments | Actual Invoices | Reconciling Adjustment
Column |  | (A) | (B) | (C) | (D) | (E) | (F) | (G) | (H) | (I) | (J) | (K) | (L) | (M) | (N) | (O) | (P) | (Q)
 |  |  |  |  |  | = | = |  |  |  |  |  |  |  |  |  | = | =
 |  |  |  |  |  | (Q) | (A+B+C+D+E) |  |  |  |  |  |  |  |  |  | (G+H+I+J+K+ | (P) - (A+B+C+D)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L+M+N+O)
2001-01-01 00:00:00 |  | 3115183.92 |  |  | 55800 |  |  |  |  |  |  |  |  |  |  |  |  | 555889.53
2001-02-01 00:00:00 |  | 3687860.64 |  |  | 55800 |  |  | 1488620 | 2208877.21 |  | 132633.97 |  |  | 57180.39 |  | 0
2001-03-01 00:00:00 |  |  |  |  | 50400 |  |  | 1344560 | 2011450 |  | 82294.95 |  |  | 50475.44 |  | 21
2001-04-01 00:00:00 |  |  | -1152796.02 |  | 55800 |  |  | 1488620 | 2190714.19 |  | 80637.9 |  | -1152796.02 | 44373.5 |  | 0
2001-05-10 00:00:00 |  |  |  | 108223.3 | 54000 |  |  | 1440600 | 2085419.78 |  | 108223.3 | -7442.22 | -780518.53 | 54000 |  | 8807.399999999441
2001-06-01 00:00:00 |  |  | -1641482.42 | 81661.24 |  |  |  | 1488620 | 2097548.35 |  | 81661.24 | -3228.43 | -1750832.42 | 53945.99 |  | 16930.41999999993
2001-07-01 00:00:00 |  |  |  | 111232.24 |  | -3228.43 |  | 1440600 | 2191027.5 | 523555 | 111232.24 | -18807.54 | -688157.24 | 64480 | 128339 | 0
2001-08-01 00:00:00 |  |  |  | 138105 | 56400 | 49459.49 |  | 1488620 | 2226962.5 | 49000 | 138105 | -18420.39 |  | 54734.8 |  | -983.8299999996088
2001-09-01 00:00:00 |  |  |  | 119684.61 |  |  |  | 1488620 | 2226962.5 | 284657 | 119684.61 | -2726.54 |  | 60179.68 |  | -17951.16000000015
2001-10-01 00:00:00 |  |  |  | 89387.2 |  |  |  | 1440600 | 2155125 |  | 89387.2 | -14792.76 | -823500.74 | 54000 |  | 0
2001-11-01 00:00:00 |  |  | -739766.98 |  |  |  |  | 1488620 | 2226962.5 |  | 108405 | -12564.1 | -739766.98 | 55800 |  | 0
2001-12-01 00:00:00 |  |  | -600377.5 | 77388.46 | 54000 |  |  | 1440600 | 2155125 |  | 77388.46 |  |  | 54000 |  | 22.47999999998137
2002-01-01 00:00:00 |  |  |  | 81707.95 | 47400 |  |  | 984410 | 2230408.2 |  | 81707.95 |  |  | 47400 |  | -22.47999999998137
(a) | Amounts paid each month are for the prior month's activity - invoices are settled on 25th of succeeding month (i.e. Jan-02 amounts are for Dec-01 activity)
(b) | Transportation invoices are paid on a lag.  Accordingly, Lone Star invoices were not originally part of the estimated costs paid to ENA each month for gas service but were included in monthly true-up amounts paid.  ENA changed its billing practice with the April invoice and charged the plant an estimated transportation cost each month with a true-up the following month for the actual expenses.  Coinciding with this change, ENA had a personnel change.  Payments for the Apr-01 through Sep-01 gas months were not made to Lone Star despite the fact that estimated payments were made by PPEP each month to ENA for Lone Star transportation charges.  Below is a reconciliation of 2001 Lone Star activity:
 |  |  | Contract 1671 |  |  | Contract 1856 |  |  |  |  |  | Per Above |  |  | Per Left
 |  | Month | Invoice Amount Due | Payment Amount | Amount Owed LS | Invoice Amount Due | Payment Amount | Amount Owed LS | Total Amount Owed LS |  | Gas Month |  |  |  | # 1671 Invoice Amount Due | #1856 Invoice Amount Due |  | Difference
 |  | Column | (R) | (S) | (T) | (U) | (V) | (W) | (X) |  |  | (Y) | (Z) | (AA) | (AB) | (AC) | (AD) | (AE)
 |  |  |  |  | = |  |  | = | = |  |  | = | = | = | = | = | = | =
 |  |  |  |  | (R+S) |  |  | (U+V) | (T+W) |  |  | (J) | (K) | (J+K) | (T) | (W) | (AB+AC) | (AB-AD)
 |  | 2000-12-01 00:00:00 |  |  |  |  |  |  | 2627.21
 |  | 2001-01-01 00:00:00 | 26481.05 | 15880 |  | 0 | 0
 |  | 2001-02-01 00:00:00 | 126054.28 | 125267.76 |  | 0 | 0
 |  | 2001-03-01 00:00:00 | 116795.07 | 116115.3 |  | 15838.9 | 15838.9
 |  | 2001-04-01 00:00:00 | 82294.95 |  |  | 0 | 0
 |  | 2001-05-10 00:00:00 |  | 80236.72 |  | 0 | 0
 |  | 2001-06-01 00:00:00 |  | 0 |  | 40051.1 | 40051.1
 |  | 2001-07-01 00:00:00 |  | 0 |  | 29231.95 | 0
 |  | 2001-08-01 00:00:00 | 92424.7 | 0 |  | 0 | 0
 |  | 2001-09-01 00:00:00 | 118584.61 | 0 |  | 1100 | 0
 |  | 2001-10-01 00:00:00 | 107572.87 | 0 |  | 9385.2 | 0
 |  | 2001-11-01 00:00:00 | 74594.44 | 0 |  | 0 | 0
 |  | 2001-12-01 00:00:00 | 95840.9 | 95840.9 |  | 0 | 0
 |  | 2002-01-01 00:00:00 | 77388.46 |  |  | 0 | 0
 |  |  |  |  |  |  | SUMMARY OF AMOUNTS DUE PPEP
 |  |  |  |  |  |  | Lone Star Invoices Outstanding for Apr-01 through Sep-01 (Estimated Amounts Paid by PPEP)
 |  |  |  |  |  |  | Estimated Oct-01 Lone Star Invoice Paid to Enron in Nov-01 (Paid Again by PPEP in Dec-01)
 |  |  |  |  |  |  | Gas Sales made by [NAME] in November (Revenue Not Remitted to PPEP)
 |  |  |  |  |  |  | Total receivable balance between Enron and plant