Spreadsheet: benjamin_rogers__1132__New Albany 00 through Sept
Sheet: New Albany 2000 Exp

New Albany
Expense Analysis Summary
Actuals / Current Estimate (Monthly)
2000-09-30 00:00:00
 | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Flash | CE | CE |  | CE |  | Actuals | Actuals | CE | CE |  | CE
 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 |  | Total |  | 1st Qtr | 2nd Qtr | [NAME] | [NAME] |  | Total
Mobilization | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Operations & Maintenance:
O&M Expenses
Aux Fuel System (Liquid Fuel) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fuel Handling System (Gas) | 0 | 0 | 0 | 0 | 0 | 18499 | 2650 | 463 | 9413 | 580 | 543 | 542
Aux Boiler System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Steam T/G System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Condensate System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Feedwater System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Air Pollution Control System | 0 | 0 | 15137 | 637 | 0 | 4495 | 1596 | 3842 | 5990 | 10733 | 0 | 0
Combustion Air System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fire Protection System | 0 | 3844 | 106 | 0 | 0 | 89 | 2120 | 1690 | 23 | 107 | 458 | 462
Wastewater System | 0 | 0 | 0 | 0 | 0 | 1773 | 3165 | 198 | 397 | 0 | 86 | 84
Recirculating Water System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 857 | 858
Chemical Feed System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Bldg. Utilities & HVAC System | 0 | 0 | 214 | 5036 | 625 | 0 | 0 | 0 | 0 | 1041 | 333 | 337
Elect Distribution System | 0 | 7404 | 575 | 14101 | 34291 | 1872 | 0 | 4771 | 75 | 19450 | 833 | 837
Steam Distribution System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Distributed Control System | 0 | 47 | 0 | 0 | 82 | 1951 | 0 | 0 | 140 | 0 | 600 | 600
Plant Consumable Sypplies | 0 | 1464 | 15912 | 4080 | 947 | 14175 | 9276 | 6768 | 7174 | 11052 | 3208 | 3212
Plant Gen & Administrative | 23664 | 23165 | 42964 | 105361 | 103393 | 39526 | 183861 | 99564 | 107631 | 199537 | 8953 | 8942
Reimbursable Labor | 53459 | 77921 | 65581 | 68267 | 105614 | 96276 | 80228 | 62444 | 74522 | 98967 | 83297 | 83301
Tools & Equipment | 0 | 10615 | 7369 | 6646 | 3062 | 4562 | 10932 | 20891 | 15223 | 21008 | 4075 | 4075
Potable Water | 0 | 507 | 1369 | 990 | 887 | 1549 | 425 | 297 | 203 | 1482 | 500 | 500
Gas | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cell Phones & Pagers | 0 | 534 | 636 | 1098 | 760 | 668 | 926 | 701 | 1218 | 2622 | 500 | 500
Garbage Removal | 0 | 97 | 200 | 0 | 0 | 1022 | 631 | 941 | 1910 | 633 | 500 | 500
Phone Service | 0 | 1516 | 2541 | 8496 | 6721 | 11967 | 3774 | 3957 | 3673 | 5731 | 3500 | 3500
Instrument / Service Air | 0 | 0 | 42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 146 | 144
Gas T/G System | 0 | 1830 | 4561 | 1763 | 32325 | 55757 | 101579 | 48218 | 98075 | 87214 | 11143 | 11142
HRSG System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Non-Scope Costs | 12222 | 1232 | 0 | 34645 | 17415 | 0 | 0 | 242515 | -11281 | 15059 | 0 | 0
Subtotal Other O&M
Owner's Expense:
Insurance | 18518 | 18518 | 38518 | 21667 | 21667 | 21666 | 21667 | 21667 | 21666 | 21667 | 21667 | 21666
Interconnection Fees | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8583 | 8583 | 8583
Gas Pipeline Metering Cost | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Misc | 0 | 2650 | -50786 | -1842 | 12431 | 3655 | 6106 | 324636 | 360 | 0 | 6438 | 6438
Subtotal - Owner's Expense
Taxes
Property Taxes | 54000 | 44182 | 44182 | 44182 | 37782 | 37782 | 37782 | 37731 | 37782 | 37782 | 37782 | 37780
Franchise Taxes | 0 | 0 | 0 | 0 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subtotal - Taxes
Total Fixed O&M
Variable O&M
Demineralized Water System | 0 | 0 | 0 | 0 | 0 | 310 | 1349 | 20451 | 2557 | 30061 | 86 | 84
Electricity | 15767 | 24229 | 26866 | 29646 | 16334 | 20200 | 27809 | 32270 | 25348 | 57699 | 17595 | 17595
Subtotal Variable O&M
Total O&M
Budget (Monthly)
 | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget |  | Budget |  | Budget | Budget | Budget | Budget |  | Budget
 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 |  | Total |  | 1st Qtr | 2nd Qtr | [NAME] | [NAME] |  | Total
Mobilization | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Operations & Maintenance:
O&M Expenses
Aux Fuel System (Liquid Fuel) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fuel Handling System (Gas) | 543 | 543 | 543 | 543 | 1140 | 1140 | 1140 | 1140 | 1140 | 543 | 543 | 542
Aux Boiler System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Steam T/G System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Condensate System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Feedwater System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Air Pollution Control System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Combustion Air System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fire Protection System | 458 | 458 | 458 | 458 | 458 | 458 | 458 | 458 | 458 | 458 | 458 | 462
Wastewater System | 86 | 86 | 86 | 86 | 180 | 180 | 180 | 180 | 180 | 86 | 86 | 84
Recirculating Water System | 857 | 857 | 857 | 857 | 1800 | 1800 | 1800 | 1800 | 1800 | 857 | 857 | 857
Chemical Feed System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Bldg. Utilities & HVAC System | 333 | 333 | 333 | 333 | 333 | 333 | 333 | 333 | 333 | 333 | 333 | 337
Elect Distribution System | 833 | 833 | 15833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 833 | 837
Steam Distribution System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Distributed Control System | 600 | 600 | 600 | 600 | 9660 | 9660 | 9660 | 9660 | 9660 | 600 | 600 | 600
Plant Consumable Sypplies | 3208 | 3208 | 3208 | 3208 | 4748 | 4748 | 4748 | 4748 | 4748 | 3208 | 3208 | 3212
Plant Gen & Administrative | 8953 | 8953 | 8953 | 8953 | 24268 | 9268 | 9268 | 9268 | 9268 | 8953 | 8953 | 8942
Reimbursable Labor | 83297 | 83297 | 83297 | 83297 | 100212 | 100212 | 100212 | 100212 | 100212 | 83297 | 83297 | 83301
Tools & Equipment | 4075 | 4075 | 4075 | 4075 | 4075 | 4075 | 4075 | 4075 | 4075 | 4075 | 4075 | 4075
Potable Water | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
Gas | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
Cell Phones & Pagers | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
Garbage Removal | 150 | 150 | 150 | 900 | 150 | 150 | 150 | 150 | 150 | 150 | 600 | 150
Phone Service | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500
Instrument / Service Air | 146 | 146 | 146 | 146 | 146 | 146 | 146 | 146 | 146 | 146 | 146 | 144
Gas T/G System | 11143 | 11143 | 11143 | 11143 | 23400 | 23400 | 23400 | 23400 | 23400 | 11143 | 11143 | 11142
HRSG System | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Non-Scope Costs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subtotal Other O&M
Owner's Expense:
Insurance | 20888 | 20888 | 20888 | 20888 | 20888 | 21513 | 21513 | 21513 | 21513 | 21513 | 21513 | 21513
Interconnection Fees | 8333 | 8333 | 8333 | 8333 | 8333 | 8583 | 8583 | 8583 | 8583 | 8583 | 8583 | 8583
Gas Pipeline Metering Cost | 2500 | 2500 | 2500 | 2500 | 2500 | 2575 | 2575 | 2575 | 2575 | 2575 | 2575 | 2575
Misc | 6250 | 6250 | 6250 | 6250 | 6250 | 6438 | 6438 | 6438 | 6438 | 6438 | 6438 | 6438
Subtotal - Owner's Expense
Taxes
Property Taxes | 0 | 0 | 0 | 0 | 0 | 61291 | 61291 | 61291 | 61291 | 61291 | 61291 | 61291
Franchise Taxes | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subtotal - Taxes
Total Fixed O&M
Variable O&M
Demineralized Water System | 86 | 86 | 86 | 5086 | 12180 | 12180 | 12180 | 12180 | 12180 | 5086 | 86 | 84
Electricity | 17080 | 17080 | 17080 | 17080 | 17080 | 17595 | 17595 | 17595 | 17595 | 17595 | 17595 | 17595
Subtotal Variable O&M
Total O&M
[NAME] (Monthly)
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME]
 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 |  | Total |  | 1st Qtr | 2nd Qtr | [NAME] | [NAME] |  | Total
Mobilization
Operations & Maintenance:
O&M Expenses
Aux Fuel System (Liquid Fuel)
Fuel Handling System (Gas)
Aux Boiler System
Steam T/G System
Condensate System
Feedwater System
Air Pollution Control System
Combustion Air System
Fire Protection System
Wastewater System
Recirculating Water System
Chemical Feed System
Bldg. Utilities & HVAC System
Elect Distribution System
Steam Distribution System
Distributed Control System
Plant Consumable Sypplies
Plant Gen & Administrative
Reimbursable Labor
Tools & Equipment
Potable Water
Gas
Cell Phones & Pagers
Garbage Removal
Phone Service
Instrument / Service Air
Gas T/G System
HRSG System
Non-Scope Costs
Subtotal Other O&M
Owner's Expense:
Insurance
Interconnection Fees
Gas Pipeline Metering Cost
Misc
Subtotal - Owner's Expense
Taxes
Property Taxes
Franchise Taxes
Subtotal - Taxes
Total Fixed O&M
Variable O&M
Demineralized Water System
Electricity
Subtotal Variable O&M
Total O&M