Spreadsheet: jeff_dasovich__14043__COS & Rates Workpapers for GA II 12-20-2000 Proposal
Sheet: O&M Summary

 | Gas Transmission, Storage and Production/Gathering Expense Forecast
 | Test Year 2002 Forecast
 | Forecast Summary
 |  |  |  |  |  | Recorded | Adjustments | Adjusted | 2000 | Forecast | 2001 | Forecast | 2002 | Forecast
 |  |  |  |  |  | 1999 |  | 1999 | Adjustments | 2000 | Adjustments | 2001 | Adjustments | 2002
 | Transmission Excluding 401
 |  | OPERATION: |  |  | Labor | 15596.99270636562 | 0 | 15596.99270636562 | 0 | 15596.99270636562 | 21 | 15617.99270636562 | -277 | 15319.99270636562
 |  |  |  |  | M&S | 16518.94622363438 | -4737.22902 | 11781.71720363438 | 687.8847886002691 | 12469.60199223465 | 8415.758142593095 | 20197.47534622747 | 4373.069914058075 | 16154.78711769246
 |  |  |  |  | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total | 32115.93893 | -4737.22902 | 27378.70991 | 687.8847886002691 | 28066.59469860027 | 8436.758142593095 | 35815.46805259309 | 4096.069914058075 | 31474.77982405807
 |  | [NAME]: |  |  | Labor | 9132.051098341168 | -314.75 | 8817.301098341168 | 291.45 | 9108.751098341168 | 231.4 | 9048.70109834117 | 171.1 | 8988.401098341168
 |  |  |  |  | M&S | 6892.404811658828 | -872.4625 | 6019.942311658829 | 2339.094956146233 | 8359.037267805063 | 2407.2 | 8427.142311658828 | 2784.85 | 8804.792311658828
 |  |  |  |  | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total | 16024.45591 | -1187.2125 | 14837.24341 | 2630.544956146233 | 17467.78836614623 | 2638.6 | 17475.84341 | 2955.95 | 17793.19341
 |  | TOTAL |  |  | Labor | 24729.04380470679 | -314.75 | 24414.29380470679 | 291.45 | 24705.74380470678 | 252.4 | 24666.69380470679 | -105.9 | 24308.39380470679
 |  |  |  |  | M&S | 23411.35103529321 | -5609.691519999999 | 17801.65951529321 | 3026.979744746503 | 20828.63926003972 | 10822.9581425931 | 28624.6176578863 | 7157.919914058075 | 24959.57942935129
 |  |  |  |  | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total | 48140.39483999999 | -5924.441519999999 | 42215.95332 | 3318.429744746502 | 45534.3830647465 | 11075.3581425931 | 53291.31146259309 | 7052.019914058075 | 49267.97323405807
 | Transmission - Line 401
 |  | OPERATION: |  |  | Labor | 647.3180805034997 | 0 | 647.3180805034997 | 0 | 647.3180805034997 | 21 | 668.3180805034997 | 0 | 647.3180805034997
 |  |  |  |  | M&S | 809.1424594965002 | 0 | 809.1424594965002 | 75.11521139973094 | 884.2576708962312 | 1455.241857406904 | 2264.384316903404 | 479.9300859419244 | 1289.072545438425
 |  |  |  |  | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total | 1456.46054 | 0 | 1456.46054 | 75.11521139973094 | 1531.575751399731 | 1476.241857406904 | 2932.702397406904 | 479.9300859419244 | 1936.390625941924
 |  | [NAME]: |  |  | Labor | 163.094373862873 | -16.25 | 146.844373862873 | 2.55 | 149.394373862873 | -15.4 | 131.444373862873 | -23.1 | 123.744373862873
 |  |  |  |  | M&S | 95.26717613712697 | -45.0775 | 50.18967613712696 | 7.15 | 57.33967613712696 | -1.2 | 48.98967613712696 | -1.85 | 48.33967613712695
 |  |  |  |  | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total | 258.36155 | -61.3275 | 197.03405 | 9.7 | 206.73405 | -16.6 | 180.43405 | -24.95 | 172.08405
 |  | TOTAL |  |  | Labor | 810.4124543663727 | -16.25 | 794.1624543663727 | 2.55 | 796.7124543663726 | 5.6 | 799.7624543663727 | -23.1 | 771.0624543663728
 |  |  |  |  | M&S | 904.4096356336272 | -45.0775 | 859.3321356336272 | 82.26521139973094 | 941.5973470333581 | 1454.041857406904 | 2313.373993040531 | 478.0800859419244 | 1337.412221575551
 |  |  |  |  | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total | 1714.82209 | -61.3275 | 1653.49459 | 84.81521139973094 | 1738.309801399731 | 1459.641857406904 | 3113.136447406904 | 454.9800859419244 | 2108.474675941924
 | Transmission - Total
 |  | OPERATION: |  |  | Labor | 16244.31078686912 | 0 | 16244.31078686912 | 0 | 16244.31078686912 | 42 | 16286.31078686912 | -277 | 15967.31078686912
 |  |  |  |  | M&S | 17328.08868313088 | -4737.22902 | 12590.85966313088 | 763 | 13353.85966313088 | 9871 | 22461.85966313088 | 4853 | 17443.85966313088
 |  |  |  |  | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total | 33572.39947 | -4737.22902 | 28835.17045 | 763 | 29598.17045 | 9913 | 38748.17045 | 4576 | 33411.17045
 |  | [NAME]: |  |  | Labor | 9295.145472204042 | -331 | 8964.145472204042 | 294 | 9258.145472204042 | 216 | 9180.145472204042 | 148 | 9112.145472204042
 |  |  |  |  | M&S | 6987.671987795955 | -917.54 | 6070.131987795956 | 2346.244956146234 | 8416.37694394219 | 2406 | 8476.131987795956 | 2783 | 8853.131987795956
 |  |  |  |  | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total | 16282.81746 | -1248.54 | 15034.27746 | 2640.244956146234 | 17674.52241614623 | 2622 | 17656.27746 | 2931 | 17965.27746
 |  | TOTAL |  |  | Labor | 25539.45625907316 | -331 | 25208.45625907316 | 294 | 25502.45625907316 | 258 | 25466.45625907316 | -129 | 25079.45625907316
 |  |  |  |  | M&S | 24315.76067092684 | -5654.76902 | 18660.99165092684 | 3109.244956146234 | 21770.23660707307 | 12277 | 30937.99165092684 | 7636 | 26296.99165092684
 |  |  |  |  | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total | 49855.21693 | -5985.76902 | 43869.44791 | 3403.244956146234 | 47272.69286614623 | 12535 | 56404.44791 | 7507 | 51376.44791
 | Storage
 |  | OPERATION: |  |  | Labor | 2248.089652173539 | 0 | 2248.089652173539 | 0 | 2248.089652173539 | 0 | 2248.089652173539 | 0 | 2248.089652173539
 |  |  |  |  | M&S | 3644.418867826462 | -886 | 2758.418867826462 | 0 | 2758.418867826462 | 0 | 2758.418867826462 | 0 | 2758.418867826462
 |  |  |  |  | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total | 5892.508520000001 | -886 | 5006.508520000001 | 0 | 5006.508520000001 | 0 | 5006.508520000001 | 0 | 5006.508520000001
 |  | [NAME]: |  |  | Labor | 1883.288144653154 | 0 | 1883.288144653154 | 0 | 1883.288144653154 | 0 | 1883.288144653154 | 0 | 1883.288144653154
 |  |  |  |  | M&S | 1935.859745346846 | 0 | 1935.859745346846 | 433 | 2368.859745346846 | 433 | 2368.859745346846 | 433 | 2368.859745346846
 |  |  |  |  | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total | 3819.14789 | 0 | 3819.14789 | 433 | 4252.14789 | 433 | 4252.14789 | 433 | 4252.14789
 |  | TOTAL |  |  | Labor | 4131.377796826693 | 0 | 4131.377796826693 | 0 | 4131.377796826693 | 0 | 4131.377796826693 | 0 | 4131.377796826693
 |  |  |  |  | M&S | 5580.278613173307 | -886 | 4694.278613173307 | 433 | 5127.278613173308 | 433 | 5127.278613173308 | 433 | 5127.278613173308
 |  |  |  |  | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total | 9711.65641 | -886 | 8825.65641 | 433 | 9258.656410000001 | 433 | 9258.656410000001 | 433 | 9258.656410000001
 | Production/Gathering
 |  | OPERATION: |  |  | Labor | 4096.572306818238 | 0 | 4096.572306818238 | 0 | 4096.572306818238 | 0 | 4096.572306818238 | 0 | 4096.572306818238
 |  |  |  |  | M&S | 3330.302883181763 | -19 | 3311.302883181763 | 0 | 3311.302883181763 | 0 | 3311.302883181763 | -780 | 2531.302883181763
 |  |  |  |  | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total | 7426.875190000001 | -19 | 7407.875190000001 | 0 | 7407.875190000001 | 0 | 7407.875190000001 | -780 | 6627.875190000001
 |  | [NAME]: |  |  | Labor | 1448.173375228394 | -238.197311691167 | 1209.976063537227 | 0 | 1209.976063537227 | 0 | 1209.976063537227 | -315 | 894.9760635372267
 |  |  |  |  | M&S | 16897.9057247716 | -14715.70529830883 | 2182.200426462772 | 0 | 2182.200426462772 | 0 | 2182.200426462772 | -53 | 2129.200426462772
 |  |  |  |  | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total | 18346.0791 | -14953.90261 | 3392.176489999999 | 0 | 3392.176489999999 | 0 | 3392.176489999999 | -368 | 3024.176489999999
 |  | TOTAL |  |  | Labor | 5544.745682046631 | -238.197311691167 | 5306.548370355465 | 0 | 5306.548370355465 | 0 | 5306.548370355465 | -315 | 4991.548370355465
 |  |  |  |  | M&S | 20228.20860795337 | -14734.70529830883 | 5493.503309644535 | 0 | 5493.503309644535 | 0 | 5493.503309644535 | -833 | 4660.503309644535
 |  |  |  |  | Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Total | 25772.95429 | -14972.90261 | 10800.05168 | 0 | 10800.05168 | 0 | 10800.05168 | -1148 | 9652.05168