Spreadsheet: michelle_lokay__26833__SEPT00 AR QTRLY MEETING
Sheet: DETAILED SUMMARY 8 31 2000

 |  | NORTHERN NATURAL GAS COMPANY & TRANSWESTERN PIPELINE COMPANY
 |  | OUTSTANDING ACCOUNTS RECEIVABLES FOR REIMBURSABLE WORK ORDERS
 |  | 2000-09-26 00:00:00
 |  | NORTHERN NATURAL GAS |  |  |  |  |  |  |  |  |  |  | DATE |  |  |  |  |  | # DAYS | DAYS |  |  |  |  | $
CO | [NAME] | CUSTOMER NAME | MARKETER | INVOICE NO. | C WO | WO DESCRIPTION | DESCRIPTION_2 | WO_BAL | APPROVED | WO# | WORK_ORDER | STATUS | INVOICED | OPEN_TYPE | D | OPEN AMOUNT | BILLING DATE | GL DATE | PAST DUE | CURRENT | 31-60 | 61-90 | 91 + | Total | Received
 |  | ALLIANT ENERGY | CHRIS SEBESTA | W1799910305 | CN7525 |  |  |  |  |  |  |  | 1999-11-30 00:00:00 |  |  |  |  |  |  |  |  |  | 4554.32
 |  | ALLIANT ENERGY  Total
 |  | ALTURA ENERGY LTD. | CHRIS SEBESTA | W17900020354 | CN9490 |  |  |  |  |  |  |  | 2000-03-05 00:00:00 |  |  |  |  |  |  |  |  |  | 39784.18
 |  | ALTURA ENERGY LTD. Total
 |  | AMEREDA HESS | B.BURLESON | W17900030363 | CN9494 |  |  |  |  |  |  |  | 2000-03-21 00:00:00 |  |  |  |  |  |  |  |  |  | 14787
 |  | AMEREDA HESS  TOTAL
 |  | CITY OF SUNRAY | D. TRAYER | W17900020353 | CN9420 |  |  |  |  |  |  |  | 2000-03-17 00:00:00 |  |  |  |  |  |  |  |  |  | 29869
 |  | CITY OF SUNRAY
NN | 0000M990004618 | KN ENERGY INC. | MIKE ULLOM | W17999120320 | C46573 | UNIT DEL TO SUNRAY |  | 0 | 29869 | C44653 | C44653 | 1 | 1999-12-10 00:00:00 | I |  | 29869 | 1996-04-29 00:00:00 | 1996-06-30 00:00:00 |  |  |  |  | 126434.57
 |  | KN ENERGY INC.  TOTAL
NN | 0000M990004618 | KN INTERSTATE GAS TRANS. | MIKE ULLOM | W17999120316-319 | CN8460, CN8332,CN8340 | UNIT DEL TO SUNRAY |  | 0 | 29869 | C44653 | C44653 | 1 | 1999-12-10 00:00:00 | I |  | 29869 | 1996-04-29 00:00:00 | 1996-06-30 00:00:00 |  |  |  |  | 72428.26
 |  | KN INTERSTATE GAS TRANS.  TOTAL
NN | 0000M990004593 | IOWA DEPT. OF TRANSPORTATION | D. TRAYER | W17997-98000 | [NAME] | 90% PAYMENT/10% BAL DUE | REV #1 | 0 |  | C43392 | C43392 | 1 |  | I | D43392 | 28863.12 | 1996-03-29 00:00:00 | 1996-03-31 00:00:00 |  |  |  |  | 28863
 |  | IOWA DEPT. OF TRANSPORTATION | D. TRAYER | W17999100303 |  |  |  |  |  |  |  |  | 1999-11-10 00:00:00 |  |  |  |  |  |  |  |  |  | 25245.15
 |  | IOWA DEPT. OF TRANSPORTATION | D. TRAYER | W17998120193 | CN8260 |  |  |  |  |  |  |  | 1998-12-31 00:00:00 |  |  | 19646.12 |  | 1998-12-31 00:00:00
 |  | IOWA DEPT. OF TRANSPORTATION   Total
NN | 0000M990004624 | LAND OF LAKES RESEARCH FARM | F. SIEMAN | W17999010209 | C43145 | LOWRY MN TBS UPGRAD |  | 0 | 13500 | C43145 | C43145 | 1 | 1999-02-08 00:00:00 | I |  | 6062.2 | 1996-09-30 00:00:00 | 1996-09-30 00:00:00 |  |  |  |  | 2432.35
 |  | LAND OF LAKES RESEARCH FARM Total
 |  | NORTHERN STATES POWER | BOB STEVENS | W17997080130 | C45171 |  |  |  |  |  |  |  | 1997-08-19 00:00:00 |  |  |  |  |  |  |  |  |  | 4025.97
 |  | NORTHERN STATES POWER |  | [NAME] | CN0010 |  |  |  |  |  |  |  | 2000-03-05 00:00:00 |  |  |  |  |  |  |  |  |  | 57800
 |  | NORTHERN STATES POWER       Total
NN | 0000M990004462 | PLYMOUTH COUNTY | RAY SMITH | W17999060246 | CN8276 | KN/OXY SUB COMP | FINNEY CO. | -22434.42 | 25000 | CN7489 | CN7489 | 0 | 1999-06-23 00:00:00 | I |  | 52196.43 | 1998-04-28 00:00:00 | 1998-10-31 00:00:00 |  |  |  |  | 38786.98 |  | PAYMENT 3/20/98
 |  | PLYMOUTH COUNTY Total
NN | 0000M990004596 | UTILICORP UNITED, INC. | LOREN PENKAVA | W17998050082 | CN7506 | CAVILLAN UPGRADE | REV.#1/POLK CO | 10087.45 | 1525 | S45622 | S45622 | 1 | 1998-06-12 00:00:00 | I |  | 5450.56 | 1998-05-19 00:00:00 | 1998-05-31 00:00:00 |  |  |  |  | -3100.85
 |  | UTILICORP UNITED, INC.         Total
NN | 0000M990004614 | STATE OF NEBRASKA | D. TRAYER | W17996040036 | C45615/17 | NE HWY 51 NEB TBS2 | BURT CO. | 6482.7 | 24000 | C45615 | C45615 | 0 | 1996-06-29 00:00:00 | I | D45615 | 3489 | 1996-04-26 00:00:00 | 1996-04-30 00:00:00 |  |  |  |  |  |  | RECEIVED 90%..
NN | 0000M990004614 | STATE OF NEBRASKA | D. TRAYER | W17998010003 | D46466 | WILBER/HWY 41 RELOC. |  |  | 7819 |  |  |  | 1998-12-12 00:00:00 |  |  | 5405 | 1998-01-28 00:00:00 | 1998-01-31 00:00:00 |  |  |  |  |  |  | RECEIVED 90%
 |  | STATE OF NEBRASKA | D. TRAYER | W17998100161 | CN8053 |  |  |  | 104445 |  |  |  | 1998-12-12 00:00:00 |  |  | 5523 | 1998-07-01 00:00:00 | 1998-11-04 00:00:00
NN | 0000M990004614 | STATE OF NEBRASKA | D. TRAYER | W17997080140 | C46428 | HWY RELOCATOON | REV#1/SALINE CTY. | 36064.74 | 216605 | C46428 | C46428 | 0 | 1997-12-12 00:00:00 | I | [NAME] | 7835.7 | 1997-08-21 00:00:00 | 1997-08-31 00:00:00 |  |  |  |  |  |  | RECEIVED 90%
NN | 0000M990004614 | STATE OF NEBRASKA | D. TRAYER | W17998010003 | D46466 | WILBER/HWY 41 RELOC. |  |  | 7819 |  |  |  | 1999-11-10 00:00:00 |  |  | 5405 | 1998-01-28 00:00:00 | 1998-01-31 00:00:00 |  |  |  |  |  |  | RECEIVED 90%
 |  | STATE OF NEBRASKA | D. TRAYER | W17998100161 | CN8094 |  |  |  | 104445 |  |  |  | 1999-11-10 00:00:00 |  |  | 5523 | 1998-07-01 00:00:00 | 1998-11-04 00:00:00 |  |  |  |  | 35718.96
 |  | STATE OF NEBRASKA              Total
NN | 0000M990004350 | STATE OF MINNESOTA | G. BIERMAN | W17999010205 | C46493 |  | REV#1/DALLAS CTY. | 37969.2 | 31000 |  | C46493 | 0 | 2000-02-08 00:00:00 | I | D46493 | 30265.56 | 1997-12-02 00:00:00 | 1999-02-08 00:00:00 |  |  |  |  | 17986.64
 |  | STATE OF MINNESOTA | D. TRAYER | W17998040060 | CN7217 | MINNESOTA DOT |  |  | 89500 |  |  |  | 1997-10-22 00:00:00 |  |  | 11107.01 | 1998-07-02 00:00:00 | 1998-06-30 00:00:00
 |  | STATE OF MINNESOTA | D. TRAYER | W17997120096 | C43599 | MINNESOTA DOT |  |  | 60635 |  |  |  | 1997-05-09 00:00:00 |  |  | 1764 | 1997-11-07 00:00:00 | 1997-10-31 00:00:00 |  |  |  |  | 2523
 |  | STATE OF MINNESOTA | D. TRAYER | W17999100307 | CN7569 |  |  |  |  |  |  |  | 1999-11-30 00:00:00
 |  | STATE OF MINNESOTA | D. TRAYER | W17998120194 | CN8394 | MINNESOTA DOT |  |  | 10000 |  |  |  | 1998-11-30 00:00:00 |  |  | 4757.58 | 1997-11-07 00:00:00 | 1999-01-20 00:00:00 |  |  |  |  | 4757.58
 |  | STATE OF MINNESOTA             Total
 |  | WEST TEXAS GAS |  | W17999100306 | DN8715 | [NAME] CHIEN UPGRADE |  |  | 9600 |  |  |  | 1999-11-05 00:00:00 |  |  | 19635.08 | 1998-03-27 00:00:00 | 1998-04-30 00:00:00 |  |  |  |  | 719.01
 |  | WEST TEXAS GAS   TOTAL
 |  | WISCONSIN ELECTRIC POWER CO. | D. TRAYER | W17998030041 | CN7452 | [NAME] CHIEN UPGRADE |  |  | 9600 |  |  |  | 1997-12-31 00:00:00 |  |  | 19635.08 | 1998-03-27 00:00:00 | 1998-04-30 00:00:00 |  |  |  |  | 19635
 |  | WISCONSIN ELECTRIC POWER CO. Total
 |  | KANSAS DEPT. OF TRANSPORT. |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | -16752.98 | 1996-1997
 |  | KANSAS DEPT. OF TRANSPORT. Total
 |  | DOUGLAS COUNTY SID 363 | UNKNOWN | W17996040040 |  |  |  |  |  |  |  |  | 1996-04-01 00:00:00 |  |  | -25981.36 | 1996-04-30 00:00:00 | 1996-04-30 00:00:00 |  |  |  |  | -25981.36
 |  | DOUGLAS COUNTY SID 363 Total
 |  | NORTHERN NATURAL GAS TOTAL
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  | DATE |  |  |  |  |  | # DAYS | DAYS |  |  |  |  | $
CO | [NAME] | CUSTOMER NAME | MARKETER | INVOICE NO. | C WO | WO DESCRIPTION | DESCRIPTION_2 | WO_BAL | APPROVED | WO# | WORK_ORDER | STATUS | INVOICED | OPEN_TYPE | D | OPEN AMOUNT | BILLING DATE | GL DATE | PAST DUE | CURRENT | 31-60 | 61-90 | 91 + | Total | Received
 |  | PHILLIPS PETROLEUM |  | W06098070044 |  |  |  |  |  |  |  |  | 1998-07-21 00:00:00 |  |  | -8500 | 1998-08-12 00:00:00 | 1998-08-31 00:00:00 |  |  |  |  | -8500
 |  | PHILLIPS PETROLEUM Total
 |  | STATE OF ARIZONA |  | W06000050162 |  |  |  |  |  |  |  |  | 2000-06-05 00:00:00 |  |  |  |  |  |  |  | 17584
 |  | STATE OF ARIZONA    TOTAL |  |  |  |  |  |  |  |  |  |  | 2000-06-05 00:00:00
 |  | [NAME] TOTAL
 |  | NNG & TW  GRAND TOTAL