Spreadsheet: tracy_geaccone__40429__Red Rock Cashflow thru October
Sheet: Cashflow

TW Red Rock Expansion
Summary Cashflow Report
Status Thru:  October 31, 2001
[NAME] | Month Ending |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  | Total | Total
DIRECT COSTS | 2001-02-28 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | Year 2001 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | Year 2002 | Project
Station One
Compressor & Driver |  |  |  |  | 875279 |  |  | 2687010 |  |  | 1312920 |  |  | 437640 | 54781 | 43750 | 43750 | 43750 |  |  |  |  |  |  | 9000000
Bulk Material |  |  |  |  |  |  |  | 8064 | 293871 | 375000 | 425000 |  | 821000 | 775000 | 482726 | 460000 | 200500 | 150000 | 36646
Taxes (On Material) |  |  |  |  |  |  |  |  |  | 40687 | 59000 |  | 175554 | 237992 | 89769 | 33048 | 30000 | 20000 | 10000 |  |  |  |  |  | 696050
Freight (Pipe & Fittings) |  |  |  |  |  |  |  |  |  |  | 49675 |  | 100000 | 179278 | 97604 | 39652 | 10425 |  |  |  |  |  |  |  | 476634
Installation |  |  |  |  |  |  |  |  |  |  | 110500 |  | 710000 | 717836 | 890000 | 765000 | 660000 | 457000 | 444594 | 145070 |  |  |  |  | 4900000
SUB-TOTAL DIRECT COSTS
Station Two
Compressor & Driver |  |  |  |  | 875279 |  |  | 2687010 |  |  | 1312920 |  |  |  | 43750 | 43750 | 43750 | 43750 |  |  |  |  |  |  | 8900000
Bulk Material |  |  |  |  |  |  |  | 8064 | 293871 | 375000 | 425000 |  | 828621 | 775000 | 482726 | 560000 | 200500 | 250000 | 45355
Taxes (On Material) |  |  |  |  |  |  |  |  |  | 40687 | 59000 |  | 175554 | 237992 | 89769 | 33048 | 30000 | 20000 | 10000 |  |  |  |  |  | 696050
Freight (Pipe & Fittings) |  |  |  |  |  |  |  |  |  |  | 49675 |  | 100000 | 179278 | 97604 | 39652 | 10425 |  |  |  |  |  |  |  | 476634
Installation |  |  |  |  |  | 5424 | 4794 | 9000 |  |  | 110500 |  | 710836 | 792000 | 965000 | 865000 | 660000 | 448335 | 403259 | 125852 |  |  |  |  | 5100000
SUB-TOTAL DIRECT COSTS
Station Three
Compressor & Driver |  |  |  |  | 875279 |  |  | 2686618 |  |  |  |  |  |  | 43750 | 43750 | 43750 | 43750 |  |  |  |  |  |  | 8900000
Bulk Material |  |  |  |  |  |  |  | 8064 | 293871 | 375000 | 525000 |  | 821000 | 799062 | 482726 | 560000 | 300500 | 250000 | 45355
Taxes (On Material) |  |  |  |  |  |  |  |  |  | 40683 | 59000 |  | 175554 | 237992 | 89769 | 33048 | 30000 | 20000 | 10000 |  |  |  |  |  | 696046
Freight (Pipe & Fittings) |  |  |  |  |  |  |  |  |  |  | 49675 |  | 100000 | 179278 | 97604 | 39652 | 10425 |  |  |  |  |  |  |  | 476634
Installation |  |  |  |  | 25983 |  |  |  |  |  | 110500 |  | 510836 | 592000 | 865000 | 765000 | 660000 | 448335 | 403259 | 119087 |  |  |  |  | 4500000
SUB-TOTAL DIRECT COSTS
TOTAL DIRECT COSTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53517288
INDIRECT COSTS
Environmental |  |  | 15440 | 19817 | 19560 | 32670 | 10500 | 1075 | 14 | 5000 | 10000 |  | 25000 | 25000 | 25000 | 15000 | 15000 | 15000 | 7589 |  |  |  |  |  | 241665
Construction Management |  |  |  | 876 | 1746 | 34662 | 7984 | 11578 | 10704 | 20000 | 50000 |  | 95000 | 90270 | 80000 | 85338 | 85338 | 85338 | 85338 | 12488 |  |  |  |  | 756660
Engineering/P.M./Dist. Labor | 29242 | 58669 | 36730 | 94337 | 109418 | 253369 | 132991 |  |  | 300000 | 200000 |  | 300000 | 360582 | 350000 | 300000 | 300000 | 300000 | 273037 | 185126 | 192757 |  |  |  | 4453661
TW Overheads |  |  | 17893 | 15584 | 386362 | 6231 | 0 | -341669 | 23985 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1791000
AFUDC |  | 109 | 954 | 1860 | 5548 | 0 | 33279 | -99 | -3165 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3687000
Contingency |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 740664 | 840664 | 840664 | 840664 | 256774 |  |  |  |  | 3519430
TOTAL INDIRECT COSTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18482712.48768118
PERIOD TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72000000.48768118
CUMULATIVE TOTAL
 | 2001-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  | Year 2001 |  |  |  |  |  |  |  |  |  |  | Year 2002
Original Plan |  | 104475.936 | 445311.743488 | 1808874.237435904 | 3414388.577 | 4163289.297039 | 14959932.32211827 | 23727099.8483731 | 27007114.54731171 | 36309293.34914289 | 40701539.40258689 | 40701539.40258689 | 48641562.40870371 | 53033177.41482052 | 57745909.19544058 | 62387921.11960284 | 65904531.89305138 | 68904395.54877664 | 70617759.8188387 | 72000000.14812526 | 72000000.14812526 | 72000000.14812526
Actual | 29242
Forecast
 |  |  |  |  |  | 725902.742 | 10797026.061194 | 8752127.243622359 | 3305295.134327714 | 9252636.200268008 | 4327663.653669884 | 40652757.03508197 | 8073705.920728032 | 4401879.920728032 | 4663317.594395089 | 4592668.565848112 | 3466926.457249438 | 3099838.87035379 | 1876373.662908812 | 1172531.551114253