Elec by dandanhuanghuang

VIEWS: 7 PAGES: 24

									Purpose: This is a temporary worksheet designed to note the Department's first round of adjustments to the Bill Impact Working Group's Electric Model

Previous Worksheets              Adjustment
General Input                    Similar information, added simple calculations and removed some information
Rates Input                      Deleted - included as part of General Input worksheet
Savings Input                    Includes Sales and Cumulative Savings information; worksheet renamed to Sales & Savings
Bill Impact-Cur vs. Inc          Same information, streamlined presentation
Bill Impact-NP vs. P             Deleted - captured in Long Term BI worksheet
2010 - 2012 BI                   Deleted - included as part of new Long Term BI worksheet
Rate Impact                      Deleted - included as part of new Long Term BI and Rate Adjustment worksheets
Rate Adjustments                 Same information, streamlined presentation; Complying with RGGI has been removed since included in Avoided Cost Study
Rate Forecast                    Content is the same, just streamlined; worksheet renamed to Rate Forecast & Decoupling
Sales                            Deleted - included as part of Sales & Savings
Cum Savings                      Deleted - included as part of Sales & Savings
EE Progr Funding                 Deleted - included as part of General Input worksheet
LBR                              Uses LBR rate and savings within the worksheet to determine 2010-2012 LBR/decoupling; worksheet renamed to Rate Forecast & Decoupling
LI Allocation                    Deleted - included as part of General Input worksheet
T&D Avoided Cost                 Combined with the DRIPE worksheet; worksheet renamed to T&D assumes that T&D benefits are realized in 2010-2012
DRIPE                            Part of the DRIPE Calc worksheet; DRIPE calculation has been adjusted to be more specific to each PA.
Ben Calc (Current)               Information now part of Rate Forecast, T&D, and DRIPE Calc worksheets
Ben Calc (Incremental)           Information now part of Rate Forecast, T&D, and DRIPE Calc worksheets
Data for Charts                  Deleted
Chart 1                          Deleted - included as part of 3Yr Bill Impacts worksheet
Chart 2                          Deleted - included as part of 3Yr Bill Impacts worksheet
Chart 3a                         Deleted
Chart 3b                         Deleted
Elec. Funding Sum                Untouched - PAs will need to change Carryover in 2011 and 2012 from "N/A" to "0". Instead, provide a footnote that the information is not available at time of filing.
Elec - SBC                       Untouched
Elec - FCM                       Deleted - included as part of Elec. Funding Sum worksheet
Elec - RGGI                      Deleted - included as part of Elec. Funding Sum worksheet
Elec - Other Funding             Deleted - included as part of Elec. Funding Sum worksheet
Carryover Funds                  Deleted - included as part of Elec. Funding Sum worksheet
Elec - EERF                      Untouched
Savings Summary                  Untouched

New Worksheets                   Purpose
Year-to-Year BI                  Shows the impact of energy efficiency related rate and bill adjustments over the three-years the plan is in effect in relation to a customer's total bill
Long-Term BI                     Provides a long-term analysis of the Bill Impacts, with costs incurred during the years of the three-year plan, and benefits continuing for the average measure life
Participation                    Provides an estimate of the number of "participants" in each efficiency case over the three-year period of the plan and the long-term
DRIPE Calc                       DRIPE calculation adjusted to be more specific to each PA.
Executive Summary Workbook       A separate workbook that combines information from each customer type to provide an overview of the bill impacts due to energy efficiency
Notes                            Provides a description for each worksheet and general conventions used throughout the workbook

General Adjustments              Description
                                 Instead of looking at each rate, this model will have a separate workbook for the Average Residential, the MassSAVE Residential, Low-Income, Small C&I and Large
Rate vs. Sector
                                 C&I customer types.
EE Cases                         The model now compares (1) the Total Efficiency Case to the No EERF Case, and (2) the Total Efficiency Case to the Zero Efficiency Case
Purpose/Notation                 Explanations were added where appropriate, and more are expected to be added after the subcommittee reviews the first round of edits
Graphs                           Visual analysis was provided where appropriate
Electric Model Input Variables
Information specific to each PA from which the model is based on.
Company                                          NSTAR Electric
Customer Type                                    Average Residential
Year 1 of Three-Year Plans                       2010


1. SALES                                              UNITS              2010                2011               2012                           SOURCE                                                        COMMENTS

Customer Type's Net Annual Sales                       kWh              5,255,992,747      5,301,271,966      5,415,930,714    Table IV.B.3.1
PA's Total Annual Sales                                kWh             19,875,225,902     20,065,687,558     20,416,813,696    Table IV.B.3.2
Total Statewide Annual Sales                           kWh             48,085,745,272     48,592,727,179     49,319,635,896    PA to Provide Source Information        From the statewide three-year plan for this model example.
PA's Percent of Total Statewide Sales                   %                         41%                41%                41%    Calculation                             (PA's Total Annual Sales) / (Total Statewide Annual Sales)

2. SAVINGS                                            UNITS              2010                2011               2012                           SOURCE                                                        COMMENTS

Annual Energy Savings                                 kWh                 46,243,530         57,309,485         64,277,894     Table IV.D.3.2.i, Total Annual MWh
Annual Summer Capacity Savings                         kW                      7,107              8,842             10,268     Table IV.D.3.2.i, Annual Summer Peak
Annual Winter Capacity Savings                         kW                      9,286             11,353             12,820     Table IV.D.3.2.i, Annual Winter Peak
Lifetime Energy Savings                               MWh                    381,733            469,888            535,340     Table IV.D.3.2.i, Lifetime Energy
                                                                                                                                                                       Adjust the most recent number of customers available to determine the value for 2010,
Total Customers                                         ?                     811,449                                          PA to Provide Source Information
                                                                                                                                                                       using the Annual Average Customer Growth Rate. The value here is from 2006.
Annual Average Customer Growth Rate                     %                       0.5%                                           PA to Provide Source Information
Participants                                             ?                   169,844            197,053            247,654     Table IV.D.3.2.i, # of Participants
Historical Monthly Consumption                         kWh                       600                600                600     PA to Provide Source Information
Typical Savings for Participant                        kWh                       30.0                 0.0                0.0   PA to Provide Source Information
Average Measure Life                                    Yrs                       8.0                8.0                8.0    PA to Provide Source Information        Must be whole numbers
Savings Load Shape - Winter Peak Energy                 %                        13%                                           Table IV.D.3.2.i                        Winter Peak Savings (MWH) divided by Total Savings (MWH)
Savings Load Shape - Winter Off-Peak Energy             %                        20%                                           Table IV.D.3.2.i                        Winter Off-Peak Savings (MWH) divided by Total Savings (MWH)
Savings Load Shape - Summer Peak Energy                 %                        27%                                           Table IV.D.3.2.i                        Summer Peak Savings (MWH) divided by Total Savings (MWH)
Savings Load Shape - Summer Off-Peak Energy             %                        40%                                           Table IV.D.3.2.i                        Summer Off-Peak Savings (MWH) divided by Total Savings (MWH)

3. COST RECOVERY                                      UNITS              2010                2011               2012                           SOURCE                                                        COMMENTS

Program Budget                                          $                $35,704,274        $42,219,241        $48,960,273     Table IV.B.3.6, Total Budget            Excludes LBR cost recovery
Low-Income EERF Allocation                              $                 $3,237,182         $4,631,088         $5,794,352     Table IV.B.3.6, Low Income Allocation
LBR / Decoupling Proxy                                  $                 $2,089,629         $4,679,301         $7,583,858     Rate Forecast & Decoupling              See Note on LBR / Decoupling Table
Total Cost Recovery                                     $                $41,031,085        $51,529,630        $62,338,483     Calculation                             Program Budget + Low-Income Allocation + LBR/Decoupling Proxy

4. PROGRAM FUNDING                                    UNITS              2010                2011               2012                           SOURCE                                                        COMMENTS

System Benefit Charge                                   $                $13,139,982        $13,253,180        $13,539,827     Table IV.B.1
Forward Capacity Market                                 $                 $1,456,989         $1,443,440         $1,427,201     Table IV.B.1
Regional Greenhouse Gas Initiative                      $                 $5,622,434         $5,712,724         $4,291,703     Table IV.B.1
Other Funding + Carryover                               $                ($1,800,348)                $0                 $0     Table IV.B.1
                                                                                                                                                                       Total Cost Recovery - (SBC + FCM + RGGI + Other); also note, this may differ from what
Energy Efficiency Reconciliation Factor                 $                $22,612,028        $31,120,286        $43,079,752 Calculation
                                                                                                                                                                       the PA has filed because of LBR calculation
Total Funding                                           $                $41,031,085        $51,529,630        $62,338,483 Calculation                                 SBS + FCM + RGGI + Other + EERF
No EERF % of Total Funding                              %                      44.9%              39.6%              30.9% Calculation                                 (SBC + FCM + RGGI + Other) / (SBC + FCM + RGGI + Other + EERF)

5. RATES                                              UNITS              2010           EFFECTIVE DATE                                         SOURCE                                                        COMMENTS

Class                                                  n/a             BECO R1                                                 PA to Provide Source Information
Customer Charge                                         $               $6.43                       Jan-09                     PA to Provide Source Information
All-in Delivery Rate                                    $              $0.07206                     Jan-09                     PA to Provide Source Information
Supply Rate                                             $              $0.12707                     Jan-09                     PA to Provide Source Information
LBR Rate                                                $              $0.04519                                                PA to Provide Source Information
Discount Rate                                          %                 2.0%                                                  PA to Provide Source Information
NSTAR Electric
Average Residential
Rate Adjustments
This worksheet shows the impact of each energy efficiency component on delivery and supply rates.

                                                                                            TOTAL EFFICIENCY CASE
                                              Costs in Delivery Rates                    Delivery     Supply                       Delivery Rate Adjustments                     Supply Rate
                    Sales                                                                                                                                                                        TOTAL
                                                                                         Benefits     Benefits                                                                   Adjustments
       Year                                                                                                      EE Funding                 Low-Income                 Total     DRIPE Price
                                                                           Low-Income                 DRIPE                       LBR/                   Avoided
                  Net Annual            EERF      LBR /                                                          Adjustment                    EERF                  Delivery    Effect - Total Total Rate
                             SBC Funds                                        EERF      Avoided T&D (Energy &                  Decoupling                   T&D
                    Sales              Required Decoupling                                                         (SBC +                    Allocation                Rate      Supply Rate Adjustment
                                                                            Allocation               Capacity)                 Adjustment               Adjustment
                                                                                                                    EERF)                   Adjustment              Adjustment    Adjustment
        Unit ->     (GWh)       ($ Million)    ($ Million)   ($ Million)    ($ Million)  ($ Million) ($ Million)   ($/kWh)      ($/kWh)       ($/kWh)    ($/kWh)     ($/kWh)        ($/kWh)      ($/kWh)
     Column ->         A             B              C             D              E            F           G            H            I             J          K           L             M             N
     Formula->       Input         Input          Input         Input          Input        Input       Input     ((B+C)/A)      (D/A)          (E/A)      (-F/A)   (H+I+J+K)        (-G/A)        (L+M)
       2010            5,256         13.14         22.61           2.09            3.24         0.74      1.45       0.00680     0.00040        0.00062   (0.00014)    0.00768       (0.00028)     0.00740
       2011            5,301         13.25         31.12           4.68            4.63         1.66      3.60       0.00837     0.00088        0.00087   (0.00031)    0.00981       (0.00068)     0.00913
       2012            5,416         13.54         43.08           7.58            5.79         2.73      6.63       0.01045     0.00140        0.00107   (0.00050)    0.01242       (0.00122)     0.01120
       2013            5,472                                       7.58                         2.73      6.69           -       0.00139             -    (0.00050)    0.00089       (0.00122)    (0.00034)
       2014            5,528                                       7.58                         2.73      6.76           -       0.00137             -    (0.00049)    0.00088       (0.00122)    (0.00034)
       2015            5,585                                       7.58                         2.73      6.83           -       0.00136             -    (0.00049)    0.00087       (0.00122)    (0.00035)
       2016            5,643                                       7.58                         2.73      6.90           -       0.00134             -    (0.00048)    0.00086       (0.00122)    (0.00036)
       2017            5,701                                       7.58                         2.73      6.97           -       0.00133             -    (0.00048)    0.00085       (0.00122)    (0.00037)
       2018            5,806                                       5.49                         1.99      7.10           -       0.00095             -    (0.00034)    0.00060       (0.00122)    (0.00062)
       2019            5,922                                       2.90                         1.07      7.25           -       0.00049             -    (0.00018)    0.00031       (0.00122)    (0.00091)



                                                                                                    NO EERF CASE
                                              Costs in Delivery Rates                         Supply
                                                                                         Delivery                                  Delivery Rate Adjustments                   Supply Rate
                    Sales                                                                                                                                                                      TOTAL
                                                                                             Benefits
                                                                                         Benefits                                                                              Adjustments
       Year                                                                                              EE Funding                         Low-Income                 Total   DRIPE Price
                                                                    Low-Income                DRIPE                               LBR/                   Avoided
                  Net Annual                  EERF        LBR /                                          Adjustment                            EERF                  Delivery  Effect - Total Total Rate
                               SBC Funds                               EERF     Avoided T&D (Energy &                          Decoupling                   T&D
                    Sales                   Required Decoupling                                            (SBC +                            Allocation                Rate    Supply Rate Adjustment
                                                                     Allocation              Capacity)                         Adjustment               Adjustment
                                                                                                            EERF)                           Adjustment              Adjustment Adjustment
        Unit ->     (GWh)       ($ Million) ($ Million) ($ Million) ($ Million)  ($ Million) ($ Million)   ($/kWh)              ($/kWh)       ($/kWh)    ($/kWh)     ($/kWh)      ($/kWh)      ($/kWh)
     Column ->         A             B           C           D            E           F           G            H                    I             J          K           L           M             N
     Formula->       Input         Input       Input       Input        Input       Input       Input     ((B+C)/A)              (D/A)          (E/A)      (-F/A)   (H+I+J+K)      (-G/A)        (L+M)
       2010            5,256         13.14      10.15         0.94          -           0.33      1.57       0.00443             0.00018             -    (0.00006)    0.00455     (0.00030)     0.00425
       2011            5,301         13.25      12.33         1.96          -           0.70      3.64       0.00483             0.00037             -    (0.00013)    0.00506     (0.00069)     0.00438
       2012            5,416         13.54      13.31         2.86          -           1.03      5.96       0.00496             0.00053             -    (0.00019)    0.00530     (0.00110)     0.00419
       2013            5,471                                  2.86                      1.03      6.02           -               0.00052             -    (0.00019)    0.00034     (0.00110)    (0.00077)
       2014            5,526                                  2.86                      1.03      6.09           -               0.00052             -    (0.00019)    0.00033     (0.00110)    (0.00077)
       2015            5,582                                  2.86                      1.03      6.15           -               0.00051             -    (0.00018)    0.00033     (0.00110)    (0.00077)
       2016            5,638                                  2.86                      1.03      6.21           -               0.00051             -    (0.00018)    0.00033     (0.00110)    (0.00078)
       2017            5,695                                  2.86                      1.03      6.27           -               0.00050             -    (0.00018)    0.00032     (0.00110)    (0.00078)
       2018            5,774                                  1.92                      0.69      6.36           -               0.00033             -    (0.00012)    0.00021     (0.00110)    (0.00089)
       2019            5,855                                  0.90                      0.33      6.45           -               0.00015             -    (0.00006)    0.00010     (0.00110)    (0.00100)



                                                                                             ZERO EFFICIENCY CASE
                                              Costs in Delivery Rates                         Supply
                                                                                         Delivery                                  Delivery Rate Adjustments                    Supply Rate
                    Sales                                                                                                                                                                       TOTAL
                                                                                             Benefits
                                                                                         Benefits                                                                               Adjustments
       Year                                                                                              EE Funding                         Low-Income                  Total   DRIPE Price
                                                                    Low-Income                DRIPE                               LBR/                   Avoided
                  Net Annual                  EERF        LBR /                                          Adjustment                            EERF                   Delivery  Effect - Total Total Rate
                               SBC Funds                               EERF     Avoided T&D (Energy &                          Decoupling                  T&D
                    Sales                   Required Decoupling                                            (SBC +                            Allocation                 Rate    Supply Rate Adjustment
                                                                     Allocation              Capacity)                         Adjustment               Adjustment
                                                                                                            EERF)                           Adjustment               Adjustment Adjustment
        Unit ->     (GWh)       ($ Million) ($ Million) ($ Million) ($ Million)  ($ Million) ($ Million)   ($/kWh)              ($/kWh)       ($/kWh)    ($/kWh)      ($/kWh)      ($/kWh)      ($/kWh)
     Column ->         A             B           C           D            E           F           G           H                     I             J          K            L           M            N
     Formula->       Input         Input       Input       Input        Input       Input       Input     ((B+C)/A)              (D/A)          (E/A)     (-F/A)     (H+I+J+K)      (-G/A)       (L+M)
       2010            5,256            -          -            -           -             -         -           -                     -              -         -             -            -           -
       2011            5,301            -          -            -           -             -         -           -                     -              -         -             -            -           -
       2012            5,416            -          -            -           -             -         -           -                     -              -         -             -            -           -
       2013            5,470                                    -                         -         -           -                     -              -         -             -            -           -
       2014            5,525                                    -                         -         -           -                     -              -         -             -            -           -
       2015            5,580                                    -                         -         -           -                     -              -         -             -            -           -
       2016            5,636                                    -                         -         -           -                     -              -         -             -            -           -
       2017            5,692                                    -                         -         -           -                     -              -         -             -            -           -
       2018            5,749                                    -                         -         -           -                     -              -         -             -            -           -
       2019            5,807                                    -                         -         -           -                     -              -         -             -            -           -
NSTAR Electric
Average Residential
Rate Adjustments
This worksheet shows the impact of each energy efficiency component on delivery and supply rates.

    DATA FOR GRAPHS
                  Rate Impact - Breakdown of Charges                                                                                                       Rate Impacts - Breakdown of Charges
              System
                        Reconciling LI EERF      FCM                                        RGGI                                                    1.40
      Year    Benefits
                         Charge     Allocation Revenues                                    Revenues
              Charge
                                                                                                                                                    1.20
      2010        0.25        0.43       0.06        0.03                                        0.11




                                                                                                                          Change in Rates (c/kWh)
      2011        0.25        0.59       0.09        0.03                                        0.11                                               1.00                                                     RGGI Revenues
      2012        0.25        0.80       0.11        0.03                                        0.08
                                                                                                                                                    0.80                                                     FCM Revenues

                                                                                                                                                    0.60                                                     LI EERF Allocation
                                                                                                                                                                                                             Reconciling Charge
                                                                                                                                                    0.40
                                                                                                                                                                                                             System Benefits Charge
                                                                                                                                                    0.20

                                                                                                                                                      -
                                                                                                                                                            2010                2011          2012


    Total Efficiency Case
                                                                   Rate Impact - All Impacts, Include Price Reductions
                                                                                                                        Low-
                                          System
                                                       Reconciling LI EERF      FCM         RGGI                      Income Supply Price                          Avoided
          Year                            Benefits                                                      Decoupling
                                                        Charge     Allocation Revenues     Revenues                    EERF     Mitigation                          T&D
                                          Charge
                                                                                                                     Allocation
          2010                                0.25          0.43          0.06      0.03         0.11      0.04         0.06     (0.03)                             (0.01)
          2011                                0.25          0.59          0.09      0.03         0.11      0.09         0.09     (0.07)                             (0.03)
          2012                                0.25          0.80          0.11      0.03         0.08      0.14         0.11     (0.12)                             (0.05)
          2013                                 -             -             -                               0.14         0.00     (0.12)                             (0.05)
          2014                                 -             -             -                               0.14         0.00     (0.12)                             (0.05)
          2015                                 -             -             -                               0.14         0.00     (0.12)                             (0.05)
          2016                                 -             -             -                               0.13         0.00     (0.12)                             (0.05)
          2017                                 -             -             -                               0.13         0.00     (0.12)                             (0.05)
          2018                                 -             -             -                               0.09         0.00     (0.12)                             (0.03)
          2019                                 -             -             -                               0.05         0.00     (0.12)                             (0.02)


                                                                                 Rate Impacts - All Impacts, Including Price Reductions
                                 1.60                                                                                                                                                                       Avoided T&D

                                 1.40                                                                                                                                                                       Supply Price Mitigation

                                 1.20                                                                                                                                                                       Low-Income EERF
                                                                                                                                                                                                            Allocation
                                 1.00                                                                                                                                                                       Decoupling
       Change in Rates (c/kWh)




                                 0.80                                                                                                                                                                       RGGI Revenues

                                 0.60                                                                                                                                                                       FCM Revenues

                                 0.40

                                 0.20

                                    -

                                 (0.20)

                                 (0.40)
                                                2010               2011            2012             2013                 2014                              2015              2016      2017          2018                 2019
NSTAR Electric
Average Residential
Three-Year Bill Impacts
Compares the bills of a participant, a non-participant, and the total customer type in the Total Case to: (1) the No EERF case; and (2) the Zero Case.

    Total Efficiency Case vs. Zero Efficiency Case
                                                 Rates                                       Participant                         Non-Participant                Total Customer Type
     Year / Efficiency Case                                                      Monthly Energy Average Monthly           Monthly Energy Average Monthly      Monthly Energy Average Monthly
                                   Supply         Delivery     Total Rate
                                                                                  Consumption         Bill                 Consumption         Bill            Consumption         Bill
                      Units ->     ($/kWh)         ($/kWh)       ($/kWh)             kWh               $                      kWh               $                 kWh               $
    2010
    Zero Efficiency Case
    Monthly Service Charge           ----            ----                                                    $6.43                                    $6.43                           $6.43
    Volumetric Component             $0.12707       $0.07206     $0.19913              600                 $119.48              600                 $119.48        600              $119.48
    Total                                                                                                  $125.91                                  $125.91                         $125.91

    Total Efficiency Case
    Monthly Service Charge           ----           ----                                                     $6.43                                    $6.43                           $6.43
    Volumetric Component            $0.12679       $0.07974      $0.20653              570                 $117.72              600                 $123.92        595              $122.84
    Total                                                                                                  $124.15                                  $130.35                         $129.27

    Differences
    In Units                      (0.00028)       0.00768         0.01                (30.00)            (1.76)                0.00              4.44             (5.23)         3.36
    %                              -0.22%          10.65%         3.72%               -5.00%            -1.39%                 0.00%             3.53%           -0.87%          2.67%
    2011
    Zero Efficiency Case
    Monthly Service Charge           ----            ----                                                    $6.43                                    $6.43                           $6.43
    Volumetric Component             $0.13444       $0.07206     $0.20650              600                 $123.90              600                 $123.90        600              $123.90
    Total                                                                                                  $130.33                                  $130.33                         $130.33

    Total Efficiency Case
    Monthly Service Charge           ----           ----                                                     $6.43                                    $6.43                           $6.43
    Volumetric Component            $0.13376       $0.08187      $0.21564              570                 $122.91              600                 $129.38        589              $126.90
    Total                                                                                                  $129.34                                  $135.81                         $133.33

    Differences
    In Units                      (0.00068)       0.00981         0.01                (30.00)            (0.99)                0.00              5.48            (11.50)         3.00
    %                              -0.51%          13.62%         4.42%               -5.00%            -0.76%                 0.00%             4.21%           -1.92%          2.30%
    2012
    Zero Efficiency Case
    Monthly Service Charge           ----            ----                                                    $6.43                                    $6.43                           $6.43
    Volumetric Component             $0.14249       $0.07206     $0.21455              600                 $128.73              600                 $128.73        600              $128.73
    Total                                                                                                  $135.16                                  $135.16                         $135.16

    Total Efficiency Case
    Monthly Service Charge           ----           ----                                                     $6.43                                    $6.43                           $6.43
    Volumetric Component            $0.14127       $0.08448      $0.22575              570                 $128.68              600                 $135.45        582              $131.38
    Total                                                                                                  $135.11                                  $141.88                         $137.81

    Differences
    In Units                      (0.00122)       0.01242         0.01                (30.00)            (0.05)                0.00              6.72            (18.03)         2.65
    %                              -0.86%          17.24%         5.22%               -5.00%            -0.04%                 0.00%             4.97%           -3.01%          1.96%
NSTAR Electric
Average Residential
Three-Year Bill Impacts
Compares the bills of a participant, a non-participant, and the total customer type in the Total Case to: (1) the No EERF case; and (2) the Zero Case.

    DATA FOR GRAPHS
                % Impact on Monthly Bills - Total vs. Zero
    Customer                    2010            2011              2012                                                                     Percent Impact on Monthly Bills
    Participant                   -1.39%           -0.76%          -0.04%
    Non-Participant                3.53%            4.21%           4.97%                                                                 Total Efficiency vs. Zero Efficiency
    Customer Total                 2.67%            2.30%           1.96%
                                                                                                                        6.0%                     Participant   Non-Participant      Customer Total
                                                                                                                                                                                                               4.97%
                                                                                                                        5.0%
                                                                                                                                                                           4.21%
                                                                                                                        4.0%             3.53%




                                                                                              Monthly Bill Impact (%)
                                                                                                                        3.0%                     2.67%
                                                                                                                                                                                   2.30%
                                                                                                                                                                                                                       1.96%
                                                                                                                        2.0%

                                                                                                                        1.0%

                                                                                                                        0.0%
                                                                                                                                                                                                      -0.04%
                                                                                                                        -1.0%
                                                                                                                                                                 -0.76%
                                                                                                                        -2.0%   -1.39%
                                                                                                                                         2010                              2011                                2012


                 $ Impact on Monthly Bills - Total vs. Zero
    Customer                     2010            2011             2012                                                                     Dollar Impact on Monthly Bills
    Participant                      -$1.76          -$0.99         -$0.05
    Non-Participant                   $4.44           $5.48          $6.72                                                                Total Efficiency vs. Zero Efficiency
    Customer Total                    $3.36           $3.00          $2.65
                                                                                                                        $8.00                    Participant   Non-Participant       Customer Total
                                                                                                                                                                                                               $6.72
                                                                                                                        $7.00
                                                                                                                        $6.00                                              $5.48
                                                                                    Monthly Bill Impact ($)




                                                                                                                        $5.00            $4.44
                                                                                                                        $4.00                    $3.36
                                                                                                                                                                                   $3.00
                                                                                                                        $3.00                                                                                          $2.65

                                                                                                                        $2.00
                                                                                                                        $1.00
                                                                                                                        $0.00
                                                                                                                  -$1.00                                                                              -$0.05
                                                                                                                                                                  -$0.99
                                                                                                                  -$2.00
                                                                                                                                -$1.76
                                                                                                                  -$3.00
                                                                                                                                         2010                              2011                                 2012
NSTAR Electric
Average Residential
Three-Year Bill Impacts
Compares the bills of a participant, a non-participant, and the total customer type in the Total Case to: (1) the No EERF case; and (2) the Zero Case.

    Total Efficiency Case vs. No EERF Case
                                                  Rates                                        Participant                        Non-Participant                    Total Customer Type
      Year / Efficiency Case                                                      Monthly Energy Average Monthly           Monthly Energy Average Monthly          Monthly Energy Average Monthly
                                    Supply         Delivery     Total Rate
                                                                                   Consumption         Bill                 Consumption         Bill                Consumption         Bill
                       Units ->     ($/kWh)         ($/kWh)       ($/kWh)             kWh               $                      kWh               $                     kWh               $
    2010
    No EERF Case
    Monthly Service Charge            ----            ----                                                     $6.43                                       $6.43                           $6.43
    Volumetric Component              $0.12677       $0.07661      $0.20338              587                 $119.29             600                     $122.03        598              $121.55
    Total                                                                                                    $125.72                                     $128.46                         $127.98

    Total Efficiency Case
    Monthly Service Charge            ----            ----                                                     $6.43                                       $6.43                           $6.43
    Volumetric Component             $0.12679        $0.07974      $0.20653              570                 $117.72             600                     $123.92        595              $122.84
    Total                                                                                                    $124.15                                     $130.35                         $129.27

    Differences
    In Units                       0.00002         0.00313         0.00                (16.53)            (1.57)                0.00              1.89                 (2.87)         1.29
    %                               0.02%           4.08%          1.55%               -2.82%            -1.25%                 0.00%             1.47%               -0.48%          1.01%
    2011
    No EERF Case
    Monthly Service Charge            ----            ----                                                     $6.43                                       $6.43                           $6.43
    Volumetric Component              $0.13375       $0.07712      $0.21088              587                 $123.69             600                     $126.53        595              $125.50
    Total                                                                                                    $130.12                                     $132.96                         $131.93

    Total Efficiency Case
    Monthly Service Charge            ----            ----                                                     $6.43                                       $6.43                           $6.43
    Volumetric Component             $0.13376        $0.08187      $0.21564              570                 $122.91             600                     $129.38        589              $126.90
    Total                                                                                                    $129.34                                     $135.81                         $133.33

    Differences
    In Units                       0.00001         0.00475         0.00                (16.53)            (0.77)                0.00              2.85                 (6.62)         1.40
    %                               0.01%           6.16%          2.26%               -2.82%            -0.60%                 0.00%             2.15%               -1.11%          1.06%
    2012
    No EERF Case
    Monthly Service Charge            ----            ----                                                     $6.43                                       $6.43                           $6.43
    Volumetric Component              $0.14139       $0.07736      $0.21874              587                 $128.30             600                     $131.25        593              $129.73
    Total                                                                                                    $134.73                                     $137.68                         $136.16

    Total Efficiency Case
    Monthly Service Charge            ----            ----                                                     $6.43                                       $6.43                           $6.43
    Volumetric Component             $0.14127        $0.08448      $0.22575              570                 $128.68             600                     $135.45        582              $131.38
    Total                                                                                                    $135.11                                     $141.88                         $137.81

    Differences
    In Units                       (0.00012)       0.00712         0.01                (16.53)           0.38                   0.00              4.20                (11.10)         1.65
    %                               -0.09%          9.21%          3.20%               -2.82%            0.28%                  0.00%             3.05%               -1.87%          1.21%
NSTAR Electric
Average Residential
Three-Year Bill Impacts
Compares the bills of a participant, a non-participant, and the total customer type in the Total Case to: (1) the No EERF case; and (2) the Zero Case.

    DATA FOR GRAPHS
                % Impact on Monthly Bills - Total vs. No EERF
    Customer
    Participant
                                  2010
                                     -1.25%
                                                   2011
                                                      -0.60%
                                                                    2012
                                                                      0.28%
                                                                                                                                   Percent Impact on Monthly Bills
    Non-Participant                   1.47%            2.15%          3.05%                                                          Total Efficiency vs. No EERF
    Customer Total                    1.01%            1.06%          1.21%
                                                                                                                                        Participant   Non-Participant      Customer Total

                                                                                                              3.5%                                                                                  3.05%
                                                                                                              3.0%
                                                                                                              2.5%                                                2.15%




                                                                                    Monthly Bill Impact (%)
                                                                                                              2.0%
                                                                                                                                1.47%
                                                                                                              1.5%                                                        1.06%                             1.21%
                                                                                                                                        1.01%
                                                                                                              1.0%
                                                                                                              0.5%                                                                          0.28%
                                                                                                              0.0%
                                                                                                              -0.5%
                                                                                                              -1.0%                                     -0.60%
                                                                                                              -1.5%    -1.25%
                                                                                                                                2010                              2011                              2012


                $ Impact on Monthly Bills - Total vs. No EERF
    Customer                       2010             2011            2012                                                               Dollar Impact on Monthly Bills
    Participant                       -$1.57           -$0.77         $0.38
    Non-Participant                     $1.89           $2.85         $4.20                                                             Total Efficiency vs. No EERF
    Customer Total                      $1.29           $1.40         $1.65
                                                                                                                                        Participant   Non-Participant      Customer Total

                                                                                                              $5.00
                                                                                                                                                                                                    $4.20
                                                                                                              $4.00
                                                                                    Monthly Bill Impact ($)




                                                                                                                                                                  $2.85
                                                                                                              $3.00
                                                                                                                                $1.89
                                                                                                              $2.00                                                                                         $1.65
                                                                                                                                        $1.29                             $1.40
                                                                                                              $1.00                                                                         $0.38
                                                                                                              $0.00

                                                                                                              -$1.00
                                                                                                                                                         -$0.77
                                                                                                              -$2.00   -$1.57
                                                                                                                                 2010                             2011                              2012
NSTAR Electric
Average Residential
Year-to-Year Bill Impacts
This worksheet shows the impact of energy efficiency related rate and bill adjustments in relation to a customer's total bill.

    Total Efficiency Case
                                                 COMPONENTS OF RATE INCREASE
                                                              System                                                              Total
                    Customer     Distribution                            Reconciling LI EERF    Decoupling
        Year                                  Supply Rate    Benefits                                                           Efficiency Grand Total
                     Charge         Rate                                   Charge    Allocation Adjustment
                                                              Charge                                                            Charges
      2009               1.07          7.21         12.71         0.25          -            -         -                               0.25     21.23
      2010               1.07          7.19         12.68         0.25         0.43        0.06       0.04                             0.78     21.72
      2011               1.07          7.17         13.38         0.25         0.59        0.09       0.09                             1.01     22.64
      2012               1.07          7.16         14.13         0.25         0.80        0.11       0.14                             1.29     23.65
    NOTE: Distribution includes T&D Benefits; Supply includes DRIPE Benefits (except for 2009)
    NOTE: For a non-participant -- i.e., does not include efficiency savings

                     Percent Increase in Component
                                            Efficiency       Total Rate
                                                                                                                    Components of Rate Increase
        Year       Distribution Supply Rate
                                            Charges          Increases                                      25
        2010         -0.20%       -0.22%    212.62%            2.31%
        2011         -0.24%        5.49%     29.57%            4.19%
        2012         -0.27%        5.61%     27.63%            4.47%
                                                                                                            20

               Absolute Differences in Component (c/kWh)

                                                                                Electric Rate (cents/kWh)
                                                                                                                                                     Decoupling Adjustment
                                           Efficiency Total Rate
        Year      Distribution Supply Rate                                                                                                           LI EERF Allocation
                                           Charges    Increases                                             15
        2010         -0.01        -0.03       0.53       0.49                                                                                        Reconciling Charge
        2011         -0.02         0.70       0.23       0.91
        2012         -0.02         0.75       0.28       1.01                                                                                        System Benefits Charge
                                                                                                            10                                       Supply Rate

         Percent of Total Rate Increase Caused by Component                                                                                          Distribution Rate
                                           Efficiency Total Rate                                                                                     Customer Charge
        Year     Distribution Supply Rate
                                           Charges    Increases                                              5
        2010         -3%          -6%        108%       100%
        2011         -2%          77%         25%       100%
        2012         -2%          74%         28%       100%
                                                                                                             0
                                                                                                                 2009   2010   2011      2012
NSTAR Electric
Average Residential
Year-to-Year Bill Impacts
This worksheet shows the impact of energy efficiency related rate and bill adjustments in relation to a customer's total bill.

    Total Efficiency Case
                               COMPONENTS OF RATE INCREASE - Supply Rate Held Constant
                                                              System                                                                  Total
                    Customer     Distribution                            Reconciling LI EERF    Decoupling
        Year                                  Supply Rate    Benefits                                                               Efficiency Grand Total
                     Charge         Rate                                   Charge    Allocation Adjustment
                                                              Charge                                                                Charges
      2009               1.07          7.21         12.71         0.25          -            -         -                                   0.25     21.23
      2010               1.07          7.19         12.68         0.25         0.43        0.06       0.04                                 0.78     21.72
      2011               1.07          7.17         12.64         0.25         0.59        0.09       0.09                                 1.01     21.90
      2012               1.07          7.16         12.58         0.25         0.80        0.11       0.14                                 1.29     22.10
    NOTE: Distribution includes T&D Benefits; Supply includes DRIPE Benefits (except for 2009)
    NOTE: For a non-participant -- i.e., does not include efficiency savings

                     Percent Increase in Component
                                            Efficiency       Total Rate
                                                                                                                   Components of Rate Increase - Supply
        Year       Distribution Supply Rate
                                            Charges          Increases                                                    Rate Held Constant
        2010         -0.20%       -0.22%    212.62%            2.31%
        2011         -0.24%       -0.32%     29.57%            0.80%                                          25
        2012         -0.27%       -0.43%     27.63%            0.94%

                                                                                                              20
               Absolute Differences in Component (c/kWh)
                                           Efficiency Total Rate

                                                                                  Electric Rate (cents/kWh)
        Year      Distribution Supply Rate                                                                                                           Decoupling Adjustment
                                           Charges    Increases
        2010         -0.01        -0.03       0.53       0.49                                                                                        LI EERF Allocation
                                                                                                              15
        2011         -0.02        -0.04       0.23       0.17                                                                                        Reconciling Charge
        2012         -0.02        -0.05       0.28       0.21
                                                                                                                                                     System Benefits Charge
                                                                                                              10                                     Supply Rate
         Percent of Total Rate Increase Caused by Component
                                                                                                                                                     Distribution Rate
                                           Efficiency Total Rate
        Year     Distribution Supply Rate
                                           Charges    Increases                                                                                      Customer Charge
        2010          -3%          -6%       108%       100%                                                   5
        2011         -10%         -23%       133%       100%
        2012          -9%         -26%       136%       100%
                                                                                                               0
                                                                                                                    2009   2010   2011    2012
NSTAR Electric
Average Residential
Long-Term Bill Impacts
Provides monthly bill impacts over the life of energy efficiency measures, with costs incurred during the years of the three-year plan. Compares the Total Case to: (1) the Zero EERF Case; and (2) the No EERF Case.

    Total Efficiency Case vs. Zero Efficiency Case
                          Rates - All Customers                                                     Participant                                                                                  Non-Participant                                                          Total Customer Type
                    Zero      Total         Difference                      Zero Efficiency       Total Efficiency        Difference                 Zero Efficiency                              Total Efficiency             Difference               Zero Efficiency      Total Efficiency        Difference
       Year       Average Average                                                   Average                Average                                           Average                                           Average                                          Average               Average
                                        Change Change                     Usage                  Usage                 Change Change               Usage                                         Usage                     Change Change              Usage                 Usage                Change Change
                    Rate       Rate                                               Monthly Bill            Monthly Bill                                     Monthly Bill                                       Monthly Bill                                    Monthly Bill          Monthly Bill
         Unit -> (c/kWh)     (c/kWh) (c/kWh)        (%)                   (kWh)        ($)       (kWh)        ($)        ($)        (%)            (kWh)        ($)                              (kWh)            ($)         ($)       (%)           (kWh)        ($)      (kWh)        ($)        ($)       (%)
       2010         19.9       20.7       0.74        3.6%                 600        119.5       570        117.8      -1.76     -1.5%             600        119.5                              600           124.0        4.44      3.7%            600        119.5      595       122.9       3.36      2.8%
       2011         20.7       21.6       0.91        4.2%                 600        124.0       570        123.0      -0.99     -0.8%             600        124.0                              600           129.4        5.48      4.4%            600        124.0      589       127.0       3.00      2.4%
       2012         21.5       22.6       1.12        5.0%                 600        128.8       570        128.7      -0.05      0.0%             600        128.8                              600           135.5        6.72      5.2%            600        128.8      582       131.4       2.65      2.1%
       2013         22.3       22.3      -0.03       -0.2%                 600        133.9       570        127.0      -6.88     -5.1%             600        133.9                              600           133.7       -0.20     -0.2%            600        133.9      582       129.7      -4.18     -3.1%
       2014         22.5       22.5      -0.03       -0.2%                 600        135.1       570        128.2      -6.95     -5.1%             600        135.1                              600           134.9       -0.21     -0.2%            600        135.1      582       130.9      -4.18     -3.1%
       2015         22.7       22.7      -0.04       -0.2%                 600        136.3       570        129.3      -7.01     -5.1%             600        136.3                              600           136.1       -0.21     -0.2%            600        136.3      582       132.1      -4.18     -3.1%
       2016         23.1       23.0      -0.04       -0.2%                 600        138.6       570        131.4      -7.13     -5.1%             600        138.6                              600           138.4       -0.22     -0.2%            600        138.6      583       134.4      -4.21     -3.0%
       2017         23.7       23.7      -0.04       -0.2%                 600        142.4       570        135.1      -7.33     -5.1%             600        142.4                              600           142.2       -0.22     -0.2%            600        142.4      583       138.2      -4.29     -3.0%
       2018         24.3       24.2      -0.06       -0.3%                 600        145.8       600        145.4      -0.37     -0.3%             600        145.8                              600           145.4       -0.37     -0.3%            600        145.8      588       142.4      -3.35     -2.3%
       2019         24.6       24.5      -0.09       -0.4%                 600        147.6       600        147.0      -0.55     -0.4%             600        147.6                              600           147.0       -0.55     -0.4%            600        147.6      594       145.5      -2.13     -1.4%
    Levelized - Low Discount Rate                                           ---       112.2        ---       109.0      -3.23     -3.0%              ---       112.2                               ---          113.5        1.32      1.2%             ---       112.2       ---      110.9      -1.35     -1.2%

                                                                                                                                                                          DATA FOR GRAPH
                                                            Percent Impact on Monthly Bill : Long -Term                                                                      Customer                            2010       2011       2012        Long-Term Levelized
                                      6.0%
                                                            Total Efficiency Case vs. Zero Efficiency Case                                                                Participant                           -1.5%      -0.8%       0.0%               -3.0%
                                                                                                                                                                          Non-Participant                        3.7%       4.4%       5.2%                1.2%
                                                                                      Participant       Non-Participant   Total Customer Type                             Total Customer                         2.8%       2.4%       2.1%               -1.2%

                                      4.0%
                                                                                                                                                                                                           Percent Impact on Monthly Bills: Including Long-Term Levelized
                                                                                                                                                                                                                     Total Efficiency Case vs. Zero Efficiency Case
            Monthly Bill Impact (%)




                                                                                                                                                                                                  6.0%
                                      2.0%
                                                                                                                                                                                                  5.0%




                                                                                                                                                                            Percent Impact (%)
                                                                                                                                                                                                  4.0%
                                      0.0%                                                                                                                                                        3.0%

                                                                                                                                                                                                  2.0%

                                                                                                                                                                                                  1.0%
                                      -2.0%
                                                                                                                                                                                                  0.0%

                                                                                                                                                                                                  -1.0%
                                      -4.0%
                                                                                                                                                                                                  -2.0%

                                                                                                                                                                                                  -3.0%            Participant   Non-Participant   Total Customer
                                      -6.0%                                                                                                                                                       -4.0%
                                              2010   2011          2012           2013           2014            2015         2016              2017                                                            2010                   2011                   2012         Long-Term Levelized
NSTAR Electric
Average Residential
Long-Term Bill Impacts
Provides monthly bill impacts over the life of energy efficiency measures, with costs incurred during the years of the three-year plan. Compares the Total Case to: (1) the Zero EERF Case; and (2) the No EERF Case.

    Total Efficiency Case vs. No EERF Case
                          Rates - All Customers                                                        Participant                                                                                Non-Participant                                                         Total Customer Type
                  No EERF     Total        Difference                          No EERF               Total Efficiency         Difference                 No EERF                                   Total Efficiency            Difference                  No EERF           Total Efficiency        Difference
       Year       Average Average                                                  Average                    Average                                        Average                                            Average                                        Average                Average
                                       Change Change                     Usage                      Usage                 Change Change            Usage                                          Usage                     Change Change            Usage                  Usage                Change Change
                    Rate       Rate                                               Monthly Bill               Monthly Bill                                   Monthly Bill                                       Monthly Bill                                   Monthly Bill          Monthly Bill
         Unit -> (c/kWh)     (c/kWh) (c/kWh)       (%)                   (kWh)       ($)            (kWh)        ($)         ($)        (%)        (kWh)       ($)                                (kWh)            ($)        ($)       (%)          (kWh)       ($)        (kWh)        ($)        ($)       (%)
       2010         20.3       20.7      0.32       1.5%                  587       119.4            570        117.8      -1.57      -1.3%         600       122.1                                600           124.0       1.89      1.5%           598       121.6        595       122.9       1.29      1.1%
       2011         21.1       21.6      0.48       2.2%                  587       123.8            570        123.0      -0.77      -0.6%         600       126.6                                600           129.4       2.85      2.3%           595       125.6        589       127.0       1.40      1.1%
       2012         21.9       22.6      0.70       3.1%                  587       128.4            570        128.7       0.38       0.3%         600       131.3                                600           135.5       4.20      3.2%           593       129.8        582       131.4       1.65      1.3%
       2013         22.2       22.3      0.04       0.2%                  587       130.5            570        127.0      -3.43      -2.6%         600       133.4                                600           133.7       0.26      0.2%           593       131.9        582       129.7      -2.19     -1.7%
       2014         22.4       22.5      0.04       0.2%                  587       131.6            570        128.2      -3.47      -2.6%         600       134.7                                600           134.9       0.25      0.2%           593       133.1        582       130.9      -2.19     -1.6%
       2015         22.6       22.7      0.04       0.2%                  587       132.8            570        129.3      -3.50      -2.6%         600       135.8                                600           136.1       0.25      0.2%           593       134.3        582       132.1      -2.19     -1.6%
       2016         23.0       23.0      0.04       0.2%                  587       135.0            570        131.4      -3.57      -2.6%         600       138.1                                600           138.4       0.25      0.2%           593       136.6        583       134.4      -2.21     -1.6%
       2017         23.7       23.7      0.04       0.2%                  587       138.8            570        135.1      -3.68      -2.6%         600       142.0                                600           142.2       0.24      0.2%           593       140.4        583       138.2      -2.26     -1.6%
       2018         24.2       24.2      0.03       0.1%                  600       145.2            600        145.4       0.16       0.1%         600       145.2                                600           145.4       0.16      0.1%           596       144.2        588       142.4      -1.76     -1.2%
       2019         24.5       24.5      0.01       0.0%                  600       147.0            600        147.0       0.05       0.0%         600       147.0                                600           147.0       0.05      0.0%           598       146.5        594       145.5      -1.03     -0.7%
    Levelized - Low Discount Rate                                          ---      110.6             ---       109.0      -1.61      -1.5%          ---      112.6                                 ---          113.5       0.91      0.8%            ---      111.6         ---      110.9      -0.74     -0.7%

                                                                                                                                                                           DATA FOR GRAPH
                                                           Percent Impact on Monthly Bill : Long -Term                                                                        Customer                           2010        2011        2012     Long-Term Levelized
                                     4.0%
                                                              Total Efficiency Case vs. No EERF Case                                                                       Participant                          -1.3%       -0.6%        0.3%            -1.5%
                                                                                                                                                                           Non-Participant                       1.5%        2.3%        3.2%             0.8%
                                                                                      Participant       Non-Participant   Total Customer Type                              Total Customer                        1.1%        1.1%        1.3%            -0.7%
                                     3.0%
                                                                                                                                                                                                              Percent Impact on Monthly Bill : Including Long-Term Levelized
                                                                                                                                                                                                                          Total Efficiency Case vs. No EERF Case
           Monthly Bill Impact (%)




                                     2.0%                                                                                                                                                              4.0%




                                                                                                                                                                             Percent Impact (%)
                                                                                                                                                                                                       3.0%
                                     1.0%

                                                                                                                                                                                                       2.0%
                                     0.0%

                                                                                                                                                                                                       1.0%
                                     -1.0%

                                                                                                                                                                                                       0.0%

                                     -2.0%
                                                                                                                                                                                                      -1.0%
                                                                                                                                                                                                                           Participant    Non-Participant   Total Customer
                                     -3.0%
                                             2010   2011          2012           2013            2014            2015          2016             2017                                                  -2.0%
                                                                                                                                                                                                                    2010                   2011                 2012         Long-Term Levelized
NSTAR Electric
Average Residential
Participation
Provides an estimate of the number of "participants" in the Total Case and No EERF Case over the three-year period of the plan and the long-term.

                                                                              PARTICIPATION RATES
                                           Annual Participation Rates                                                      Cumulative Participation Rates
                              Number of Participants               % of Total Customers          Total       Cumulative Number of Parts          % of Total Customers
          Year
                         No EERF       Total      Difference No EERF     Total     Difference  Customers   No EERF     Total   Difference No EERF       Total    Difference
          2010               76,244     169,844       93,600     9.4%      20.9%         11.5%     811,449   76,244 169,844        93,600      9.4%       20.9%       11.5%
          2011               78,047     197,053      119,006     9.6%      24.2%         14.6%     815,506 154,291 366,897        212,606     18.9%       45.0%       26.1%
          2012               76,510     247,654      171,144     9.3%      30.2%         20.9%     819,584 230,800 614,551        383,751     28.2%       75.0%       46.8%
          2013               76,510     247,654      171,144     9.3%      30.1%         20.8%     823,682 230,800 614,551        383,751     28.0%       74.6%       46.6%
          2014               76,510     247,654      171,144     9.2%      29.9%         20.7%     827,800 230,800 614,551        383,751     27.9%       74.2%       46.4%
          2015               76,510     247,654      171,144     9.2%      29.8%         20.6%     831,939 230,800 614,551        383,751     27.7%       73.9%       46.1%
          2016               76,510     247,654      171,144     9.2%      29.6%         20.5%     836,099 230,800 614,551        383,751     27.6%       73.5%       45.9%
          2017               76,510     247,654      171,144     9.1%      29.5%         20.4%     840,279 230,800 614,551        383,751     27.5%       73.1%       45.7%
          2018               76,510     247,654      171,144     9.1%      29.3%         20.3%     844,481 230,800 614,551        383,751     27.3%       72.8%       45.4%
          2019               76,510     247,654      171,144     9.0%      29.2%         20.2%     848,703 230,800 614,551        383,751     27.2%       72.4%       45.2%

        Customer Information
    Total Customers     811,449
    Growth Rate            0.5%                                                                             Program Participation - All Residential Programs
                                                                                               50%
                                                                                                              Cumulative Participation Rates
                                                                  Percent of Total Customers
    DATA FOR GRAPH                                                                             45%
              Program Participation                                                                           Annual Participation Rates
                     Cumulative     Annual                                                     40%
         Year       Participation Participation
                                                                                               35%
                        Rate          Rate
         2010              11.5%         11.5%                                                 30%
         2011              26.1%         14.6%
         2012              46.8%         20.9%                                                 25%

                                                                                               20%

                                                                                               15%

                                                                                               10%

                                                                                               5%

                                                                                               0%
                                                                                                     2010                                  2011                2012
NSTAR Electric
Average Residential
Sales & Savings
Provides analysis on sales, cumulative savings, and participant savings over the long-term.

                                                                                                 SALES & SAVINGS
                                            Sales                                                      Cumulative Savings                                   Participant Monthly Savings
       Year                  Cumulative                                                                                                              Historical
                                                 Net Annual       Net Sales /         2010 Savings 2011 Savings 2012 Savings    Cumulative
               Annual Sales Annual Energy                                                                                                        Consumption (Non-   Typical Savings        Consumption
                                                   Sales         Annual Sales            Stream       Stream       Stream        Savings
                              Savings                                                                                                               Participant)
       Unit ->   (GWh)         (GWh)                (GWh)             (%)                (kWh)        (kWh)        (kWh)          (kWh)               (kWh)          (kWh)       (%)          (kWh)
    Total Efficiency Case
       2010             5,302           46.24            5,256               99%        46,243,530                                46,243,530                  600        30       5.0%                570
       2011             5,405          103.55            5,301               98%        46,243,530   57,309,485                  103,553,014                  600        30       5.0%                570
       2012             5,584          167.83            5,416               97%        46,243,530   57,309,485   64,277,894     167,830,908                  600        30       5.0%                570
       2013             5,640          167.83            5,472               97%        46,243,530   57,309,485   64,277,894     167,830,908                  600        30       5.0%                570
       2014             5,696          167.83            5,528               97%        46,243,530   57,309,485   64,277,894     167,830,908                  600        30       5.0%                570
       2015             5,753          167.83            5,585               97%        46,243,530   57,309,485   64,277,894     167,830,908                  600        30       5.0%                570
       2016             5,810          167.83            5,643               97%        46,243,530   57,309,485   64,277,894     167,830,908                  600        30       5.0%                570
       2017             5,869          167.83            5,701               97%        46,243,530   57,309,485   64,277,894     167,830,908                  600        30       5.0%                570
       2018             5,927          121.59            5,806               98%                 0   57,309,485   64,277,894     121,587,379                  600         0       0.0%                600
       2019             5,987           64.28            5,922               99%                 0            0   64,277,894      64,277,894                  600         0       0.0%                600
       2020             6,046            0.00            6,046              100%                 0            0            0               0                  600         0       0.0%                600
       2021             6,107            0.00            6,107              100%                 0            0            0               0                  600         0       0.0%                600
       2022             6,168            0.00            6,168              100%                 0            0            0               0                  600         0       0.0%                600
    No EERF Efficiency Case
       2010             5,277           20.76            5,256              100%        20,758,949                                20,758,949                  600        13       2.2%                587
       2011             5,345           43.46            5,301               99%        20,758,949   22,698,571                   43,457,520                  600        13       2.2%                587
       2012             5,479           63.32            5,416               99%        20,758,949   22,698,571   19,857,889      63,315,409                  600        13       2.2%                587
       2013             5,534           63.32            5,471               99%        20,758,949   22,698,571   19,857,889      63,315,409                  600        13       2.2%                587
       2014             5,589           63.32            5,526               99%        20,758,949   22,698,571   19,857,889      63,315,409                  600        13       2.2%                587
       2015             5,645           63.32            5,582               99%        20,758,949   22,698,571   19,857,889      63,315,409                  600        13       2.2%                587
       2016             5,702           63.32            5,638               99%        20,758,949   22,698,571   19,857,889      63,315,409                  600        13       2.2%                587
       2017             5,759           63.32            5,695               99%        20,758,949   22,698,571   19,857,889      63,315,409                  600        13       2.2%                587
       2018             5,816           42.56            5,774               99%                 0   22,698,571   19,857,889      42,556,460                  600         0       0.0%                600
       2019             5,874           19.86            5,855              100%                 0            0   19,857,889      19,857,889                  600         0       0.0%                600
       2020             5,933            0.00            5,933              100%                 0            0            0               0                  600         0       0.0%                600
       2021             5,993            0.00            5,993              100%                 0            0            0               0                  600         0       0.0%                600
       2022             6,052            0.00            6,052              100%                 0            0            0               0                  600         0       0.0%                600
    Zero Efficiency Case
       2010             5,256             0.00           5,256              100%                 0                                           0                600            0         0%             600
       2011             5,301             0.00           5,301              100%                 0            0                              0                600            0         0%             600
       2012             5,416             0.00           5,416              100%                 0            0             0                0                600            0         0%             600
       2013             5,470             0.00           5,470              100%                 0            0             0                0                600            0         0%             600
       2014             5,525             0.00           5,525              100%                 0            0             0                0                600            0         0%             600
       2015             5,580             0.00           5,580              100%                 0            0             0                0                600            0         0%             600
       2016             5,636             0.00           5,636              100%                 0            0             0                0                600            0         0%             600
       2017             5,692             0.00           5,692              100%                 0            0             0                0                600            0         0%             600
       2018             5,749             0.00           5,749              100%                 0            0             0                0                600            0         0%             600
       2019             5,807             0.00           5,807              100%                 0            0             0                0                600            0         0%             600
       2020             5,865             0.00           5,865              100%                 0            0             0                0                600            0         0%             600
       2021             5,923             0.00           5,923              100%                 0            0             0                0                600            0         0%             600
       2022             5,983             0.00           5,983              100%                 0            0             0                0                600            0         0%             600
NSTAR Electric
Average Residential
Rate Forecast & Decoupling
Forecast of supply rates and a projected decoupling proxy.

                                                      Basic Service Rate Forecast                                              Total Rate Forecast                      LBR / DECOUPLING
                                                               Average Avoided Electric Energy Cost
                     Basic Service                                                                                                                                                              Proxy Decoupling
          Year                                                                                                                  Year        Rate        Year      LBR Rate        Savings
                         Rate      Winter Peak    Winter Off-Peak Summer Peak Summer Off-Peak          Ann Avg    Year over                                                                        Revenues
                                      Energy           Energy          Energy         Energy            Price    Year Change
       2009         0.12707                $0.076           $0.059          $0.079          $0.058    $ 0.066                   2009                  Total Efficiency Case
       2010         0.12707                $0.076           $0.059          $0.079          $0.058    $ 0.066          0.00%    2010        0.19913     2010      $   0.04519     46,243,530    $       2,089,629
       2011         0.13444                $0.081           $0.064          $0.084          $0.060    $ 0.070          5.80%    2011        0.20650     2011      $   0.04519    103,553,014    $       4,679,301
       2012         0.14249                $0.088           $0.068          $0.087          $0.064    $ 0.074          5.99%    2012        0.21455     2012      $   0.04519    167,830,908    $       7,583,858
       2013         0.15101                $0.089           $0.073          $0.090          $0.070    $ 0.079          5.98%    2013        0.22307     2013      $   0.04519    167,830,908    $       7,583,858
       2014         0.15304                $0.091           $0.075          $0.092          $0.071    $ 0.080          1.35%    2014        0.22510     2014      $   0.04519    167,830,908    $       7,583,858
       2015         0.15496                $0.091           $0.076          $0.094          $0.071    $ 0.081          1.25%    2015        0.22702     2015      $   0.04519    167,830,908    $       7,583,858
       2016         0.15879                $0.092           $0.077          $0.097          $0.073    $ 0.083          2.48%    2016        0.23085     2016      $   0.04519    167,830,908    $       7,583,858
       2017         0.16524                $0.095           $0.080          $0.100          $0.077    $ 0.086          4.06%    2017        0.23730     2017      $   0.04519    167,830,908    $       7,583,858
       2018         0.17076                $0.099           $0.083          $0.102          $0.080    $ 0.089          3.34%    2018        0.24282     2018      $   0.04519    121,587,379    $       5,494,229
       2019         0.17382                $0.100           $0.086          $0.105          $0.080    $ 0.091          1.80%    2019        0.24588     2019      $   0.04519     64,277,894    $       2,904,557
       2020         0.17393                $0.100           $0.085          $0.105          $0.081    $ 0.091          0.06%    2020        0.24599   No EERF Efficiency Case
       2021         0.17151                $0.098           $0.084          $0.103          $0.080    $ 0.089         -1.39%    2021        0.24357     2010      $   0.04519     20,758,949    $         938,045
       2022         0.17424                $0.100           $0.086          $0.104          $0.081    $ 0.091          1.59%    2022        0.24630     2011      $   0.04519     43,457,520    $       1,963,736
       2023         0.17870                $0.102           $0.087          $0.108          $0.083    $ 0.093          2.56%    2023        0.25076     2012      $   0.04519     63,315,409    $       2,861,065
       2024         0.18714                $0.107           $0.090          $0.113          $0.088    $ 0.098          4.72%    2024        0.25920     2013      $   0.04519     63,315,409    $       2,861,065
    NOTE: Gray shaded areas will need to be updated with each new avoided cost study.                                                                   2014      $   0.04519     63,315,409    $       2,861,065
                                                                                                                                                        2015      $   0.04519     63,315,409    $       2,861,065
     Delivery Rate                                      Energy Savings Load Shape                                                                       2016      $   0.04519     63,315,409    $       2,861,065
        0.07206                        Winter Peak   Winter Off-Peak Summer Peak Summer Off-Peak                                                        2017      $   0.04519     63,315,409    $       2,861,065
                                                0.13             0.20        0.27            0.40                                                       2018      $   0.04519     42,556,460    $       1,923,020
                                                                                                                                                        2019      $   0.04519     19,857,889    $         897,328
                                                                                                                                                      Zero Efficiency Case
                                                                                                                                                        2010      $   0.04519             -     $              -
                                                                                                                                                        2011      $   0.04519             -     $              -
                                                                                                                                                        2012      $   0.04519             -     $              -
                                                                                                                                                        2013      $   0.04519             -     $              -
                                                                                                                                                        2014      $   0.04519             -     $              -
                                                                                                                                                        2015      $   0.04519             -     $              -
                                                                                                                                                        2016      $   0.04519             -     $              -
                                                                                                                                                        2017      $   0.04519             -     $              -
                                                                                                                                                        2018      $   0.04519             -     $              -
                                                                                                                                                        2019      $   0.04519             -     $              -

                                                                                                                                                      NOTE: This calculation of LBR/Decoupling provides a
                                                                                                                                                      simplified proxy. There are a number of ways to calculate
                                                                                                                                                      LBR/Decoupling, and the proxy provided here will likely vary
                                                                                                                                                      from the Program Administrator's actual calculations of LBR
                                                                                                                                                      and Decoupling that have or will be deemed appropriate by
                                                                                                                                                      the Department in EERF proceedings and base rate cases.
NSTAR Electric
Average Residential
T&D & DRIPE
Forecast of avoided T&D benefits included in delivery rates and summary of DRIPE benefits included in supply rates.

                                                    AVOIDED T&D
                         Annual Summer Capacity Savings            Avoided Cost of Avoided Cost Total Avoided
         Year
                         2010        2011         2012              Transmission of Distribution Cost of T&D
    Total Efficiency Case
         2010            7,107                                     $        123,990    $     614,980    $     738,970
         2011            7,107          8,842                      $        278,248    $   1,380,090    $   1,658,338
         2012            7,107          8,842          10,268      $        457,376    $   2,268,551    $   2,725,927
         2013            7,107          8,842          10,268      $        457,376    $   2,268,551    $   2,725,927
         2014            7,107          8,842          10,268      $        457,376    $   2,268,551    $   2,725,927
         2015            7,107          8,842          10,268      $        457,376    $   2,268,551    $   2,725,927
         2016            7,107          8,842          10,268      $        457,376    $   2,268,551    $   2,725,927
         2017            7,107          8,842          10,268      $        457,376    $   2,268,551    $   2,725,927
         2018              0            8,842          10,268      $        333,386    $   1,653,570    $   1,986,957
         2019              0              0            10,268      $        179,128    $     888,461    $   1,067,589
         2020              0              0               0        $              -    $           -    $           -
    No EERF Case
         2010            3,190                                     $         55,660    $    276,068     $     331,727
         2011            3,190          3,502                      $        116,757    $    579,105     $     695,862
         2012            3,190          3,502           3,172      $        172,096    $    853,584     $   1,025,680
         2013            3,190          3,502           3,172      $        172,096    $    853,584     $   1,025,680
         2014            3,190          3,502           3,172      $        172,096    $    853,584     $   1,025,680
         2015            3,190          3,502           3,172      $        172,096    $    853,584     $   1,025,680
         2016            3,190          3,502           3,172      $        172,096    $    853,584     $   1,025,680
         2017            3,190          3,502           3,172      $        172,096    $    853,584     $   1,025,680
         2018              0            3,502           3,172      $        116,437    $    577,516     $     693,953
         2019              0              0             3,172      $         55,339    $    274,479     $     329,819
         2020              0              0               0        $              -    $          -     $           -
    Zero Efficiency Case
         2010              0               0              0        $               -   $            -   $             -
         2011              0               0              0        $               -   $            -   $             -
         2012              0               0              0        $               -   $            -   $             -
         2013              0               0              0        $               -   $            -   $             -
         2014              0               0              0        $               -   $            -   $             -
         2015              0               0              0        $               -   $            -   $             -
         2016              0               0              0        $               -   $            -   $             -
         2017              0               0              0        $               -   $            -   $             -
         2018              0               0              0        $               -   $            -   $             -
         2019              0               0              0        $               -   $            -   $             -
         2020              0               0              0        $               -   $            -   $             -

                 Avoided T&D Factors
                     Avoided Cost Line Losses
             Units->     $/kW          %
    Transmission        $15.97       9.24%
    Distribution        $79.21       9.24%

    NOTE: The light blue shaded values in the
    "Avoided T&D Factors" table are PA-specific
    inputs NOT included in the INPUTS
    worksheet.
NSTAR Electric
Average Residential
DRIPE Calculation
Calculates DRIPE over the long-term for the Total Case and the No EERF Case.

                                                                                                            Total Efficiency Case                                                                                                          No EERF Case
                                 Energy & Capacity DRIPE Factors                                                                             Annual DRIPE Benefits - Total Efficiency Case                                                                                   Annual DRIPE Benefits - No EERF Case
                      Capacity DRIPE                             Energy DRIPE                                              Capacity                                         Energy DRIPE                                                             Capacity                                        Energy DRIPE
           Year                                                                   Summer       Summer          Year                                          Winter Off-                     Summer Off-      Total Energy   TOTAL DRIPE     Year                                     Winter Off-                     Summer Off-      Total Energy   TOTAL DRIPE
                          ($/kW)            Winter Peak       Winter Off-Peak                                               DRIPE        Winter Peak                        Summer Peak                                                               DRIPE        Winter Peak                       Summer Peak
                                                                                   Peak        Off Peak                                                        Peak                             Peak             DRIPE                                                                  Peak                             Peak             DRIPE
    2010                                                                                                    2010                                                                                                                           2010
           2010                   $0.00             $0.057              $0.044       $0.063        $0.033      2010                 $0       $894,913          $1,011,110       $2,050,511       $1,512,614     $5,469,149    $5,469,149     2010             $0      $971,940          $1,098,139       $2,227,003       $1,642,808     $5,939,890    $5,939,890
           2011                   $0.00             $0.059              $0.045       $0.064        $0.033      2011                 $0       $917,787          $1,051,936       $2,083,584       $1,512,614     $5,565,922    $5,565,922     2011             $0      $996,783          $1,142,479       $2,262,923       $1,642,808     $6,044,992    $6,044,992
           2012                   $0.00             $0.064              $0.049       $0.067        $0.035      2012                 $0       $998,717          $1,137,616       $2,182,803       $1,607,152     $5,926,288    $5,926,288     2012             $0     $1,084,679         $1,235,533       $2,370,681       $1,745,483     $6,436,376    $6,436,376
           2013                  $55.84             $0.032              $0.025       $0.034        $0.018      2013         $1,013,783       $492,458           $590,079        $1,091,401        $850,845      $3,024,784    $4,038,567     2013     $1,101,042      $534,845           $640,868        $1,185,340        $924,079      $3,285,133    $4,386,175
           2014                  $68.38             $0.027              $0.022       $0.029        $0.016      2014         $1,241,431       $419,176           $505,815         $926,037         $756,307      $2,607,336    $3,848,767     2014     $1,348,284      $455,256           $549,352        $1,005,743        $821,404      $2,831,755    $4,180,039
           2015                  $41.03             $0.024              $0.019       $0.026        $0.014      2015          $744,896        $367,902           $448,900         $859,892         $661,769      $2,338,462    $3,083,358     2015      $809,011       $399,569           $487,537         $933,905         $718,728      $2,539,739    $3,348,749
           2016                   $0.00             $0.021              $0.017       $0.023        $0.012      2016                 $0       $324,058           $400,484         $760,674         $567,230      $2,052,446    $2,052,446     2016             $0      $351,950           $434,955         $826,146         $616,053      $2,229,104    $2,229,104
           2017                   $0.00             $0.018              $0.015       $0.020        $0.011      2017                 $0       $284,463           $354,075         $661,455         $519,961      $1,819,954    $1,819,954     2017             $0      $308,947           $384,551         $718,388         $564,715      $1,976,602    $1,976,602
           2018                   $0.00             $0.016              $0.013       $0.017        $0.009      2018                 $0       $244,689           $300,609         $562,237         $425,423      $1,532,958    $1,532,958     2018             $0      $265,750           $326,483         $610,630         $462,040      $1,664,902    $1,664,902
           2019                   $0.00             $0.013              $0.011       $0.014        $0.008      2019                 $0       $196,485           $246,629         $463,019         $378,153      $1,284,286    $1,284,286     2019             $0      $213,397           $267,857         $502,872         $410,702      $1,394,828    $1,394,828
           2020                   $0.00             $0.009              $0.008       $0.010        $0.006      2020                 $0       $145,484           $182,896         $330,728         $283,615       $942,722      $942,722      2020             $0      $158,006           $198,638         $359,194         $308,026      $1,023,864    $1,023,864
           2021                   $0.00             $0.006              $0.005       $0.007        $0.004      2021                 $0        $94,968           $120,214         $231,509         $189,077       $635,768      $635,768      2021             $0      $103,142           $130,561         $251,436         $205,351       $690,490      $690,490
           2022                   $0.00             $0.003              $0.003       $0.003        $0.002      2022                 $0        $48,129             $61,311          $99,218          $94,538      $303,197      $303,197      2022             $0        $52,271            $66,588        $107,758         $102,675       $329,294      $329,294
           2023                   $0.00             $0.000              $0.000       $0.000        $0.000      2023                 $0             $0                  $0               $0               $0             $0        $0         2023             $0             $0                 $0               $0               $0             $0        $0
           2024                   $0.00             $0.000              $0.000       $0.000        $0.000      2024                 $0             $0                  $0               $0               $0             $0        $0         2024             $0             $0                 $0               $0               $0             $0        $0
    2011                                                                                                    2011                                                                                                                           2011
           2010                                                                                                2010                                                                                                                          2010
           2011                   $0.00             $0.059              $0.045       $0.064        $0.033      2011                 $0      $1,331,252         $1,525,835       $3,022,243       $2,194,049     $8,073,379    $8,073,379     2011             $0     $1,276,878         $1,463,514       $2,898,802       $2,104,436     $7,743,630    $7,743,630
           2012                   $0.00             $0.064              $0.049       $0.067        $0.035      2012                 $0      $1,448,641         $1,650,114       $3,166,159       $2,331,177     $8,596,091    $8,596,091     2012             $0     $1,389,472         $1,582,717       $3,036,840       $2,235,963     $8,244,992    $8,244,992
           2013                   $0.00             $0.032              $0.025       $0.034        $0.018      2013                 $0       $714,312           $855,910        $1,583,079       $1,234,153     $4,387,454    $4,387,454     2013             $0      $685,136           $820,951        $1,518,420       $1,183,745     $4,208,253    $4,208,253
           2014                  $55.84             $0.027              $0.022       $0.029        $0.016      2014         $1,471,416       $608,016           $733,686        $1,343,219       $1,097,025     $3,781,945    $5,253,361     2014     $1,411,317      $583,182           $703,719        $1,288,357       $1,052,218     $3,627,476    $5,038,793
           2015                  $95.73             $0.024              $0.019       $0.026        $0.014      2015         $2,522,504       $533,643           $651,130        $1,247,275        $959,897      $3,391,944    $5,914,448     2015     $2,419,475      $511,847           $624,535        $1,196,331        $920,691      $3,253,403    $5,672,878
           2016                  $68.38             $0.021              $0.017       $0.023        $0.012      2016         $1,801,827       $470,046           $580,903        $1,103,358        $822,768      $2,977,076    $4,778,903     2016     $1,728,233      $450,848           $557,177        $1,058,293        $789,163      $2,855,481    $4,583,714
           2017                  $41.03             $0.018              $0.015       $0.020        $0.011      2017         $1,081,150       $412,614           $513,586         $959,442         $754,204      $2,639,847    $3,720,997     2017     $1,036,991      $395,761           $492,610         $920,255         $723,400      $2,532,025    $3,569,016
           2018                   $0.00             $0.016              $0.013       $0.017        $0.009      2018                 $0       $354,922           $436,034         $815,526         $617,076      $2,223,558    $2,223,558     2018             $0      $340,425           $418,225         $782,216         $591,872      $2,132,739    $2,132,739
           2019                   $0.00             $0.013              $0.011       $0.014        $0.008      2019                 $0       $285,002           $357,735         $671,609         $548,512      $1,862,860    $1,862,860     2019             $0      $273,362           $343,124         $644,178         $526,109      $1,786,773    $1,786,773
           2020                   $0.00             $0.009              $0.008       $0.010        $0.006      2020                 $0       $211,024           $265,291         $479,721         $411,384      $1,367,420    $1,367,420     2020             $0      $202,405           $254,455         $460,127         $394,582      $1,311,569    $1,311,569
           2021                   $0.00             $0.006              $0.005       $0.007        $0.004      2021                 $0       $137,751           $174,371         $335,805         $274,256       $922,183      $922,183      2021             $0      $132,125           $167,249         $322,089         $263,054       $884,517      $884,517
           2022                   $0.00             $0.003              $0.003       $0.003        $0.002      2022                 $0         $69,811            $88,932        $143,916         $137,128       $439,787      $439,787      2022             $0        $66,960            $85,300        $138,038         $131,527       $421,825      $421,825
           2023                   $0.00             $0.000              $0.000       $0.000        $0.000      2023                 $0              $0                 $0               $0               $0             $0        $0         2023             $0             $0                 $0               $0               $0             $0        $0
           2024                   $0.00             $0.000              $0.000       $0.000        $0.000      2024                 $0              $0                 $0               $0               $0             $0        $0         2024             $0             $0                 $0               $0               $0             $0        $0
    2012                                                                                                    2012                                                                                                                           2012
           2010                                                                                                2010                                                                                                                          2010
           2011                                                                                                2011                                                                                                                          2011
           2012                   $0.00             $0.064              $0.049       $0.067        $0.035      2012                 $0      $1,762,042         $2,007,102       $3,851,131       $2,835,508    $10,455,782   $10,455,782     2012             $0     $1,314,981         $1,497,865       $2,874,032       $2,116,090     $7,802,969    $7,802,969
           2013                   $0.00             $0.032              $0.025       $0.034        $0.018      2013                 $0       $868,847          $1,041,079       $1,925,565       $1,501,151     $5,336,642    $5,336,642     2013             $0      $648,405           $776,939        $1,437,016       $1,120,283     $3,982,644    $3,982,644
           2014                   $0.00             $0.027              $0.022       $0.029        $0.016      2014                 $0       $739,555           $892,412        $1,633,813       $1,334,357     $4,600,137    $4,600,137     2014             $0      $551,917           $665,992        $1,219,286        $995,807      $3,433,002    $3,433,002
           2015                  $55.84             $0.024              $0.019       $0.026        $0.014      2015         $1,779,461       $649,092           $791,996        $1,517,112       $1,167,562     $4,125,762    $5,905,223     2015     $1,327,981      $484,406           $591,053        $1,132,194        $871,331      $3,078,985    $4,406,965
           2016                  $95.73             $0.021              $0.017       $0.023        $0.012      2016         $3,050,597       $571,737           $706,577        $1,342,061       $1,000,767     $3,621,142    $6,671,739     2016     $2,276,608      $426,677           $527,306        $1,001,557        $746,855      $2,702,395    $4,979,003
           2017                  $68.38             $0.018              $0.015       $0.020        $0.011      2017         $2,179,044       $501,879           $624,697        $1,167,009        $917,370      $3,210,955    $5,390,000     2017     $1,626,183      $374,544           $466,200         $870,919         $684,617      $2,396,280    $4,022,463
           2018                  $41.03             $0.016              $0.013       $0.017        $0.009      2018         $1,307,492       $431,706           $530,366         $991,958         $750,576      $2,704,605    $4,012,097     2018      $975,758       $322,175           $395,803         $740,281         $560,142      $2,018,400    $2,994,158
           2019                   $0.00             $0.013              $0.011       $0.014        $0.008      2019                 $0       $346,660           $435,128         $816,906         $667,178      $2,265,874    $2,265,874     2019             $0      $258,707           $324,729         $609,643         $497,904      $1,690,982    $1,690,982
           2020                   $0.00             $0.009              $0.008       $0.010        $0.006      2020                 $0       $256,677           $322,684         $583,505         $500,384      $1,663,250    $1,663,250     2020             $0      $191,554           $240,814         $435,459         $373,428      $1,241,254    $1,241,254
           2021                   $0.00             $0.006              $0.005       $0.007        $0.004      2021                 $0       $167,553           $212,094         $408,453         $333,589      $1,121,690    $1,121,690     2021             $0      $125,042           $158,282         $304,822         $248,952       $837,097      $837,097
           2022                   $0.00             $0.003              $0.003       $0.003        $0.002      2022                 $0         $84,914          $108,172         $175,051         $166,795       $534,932      $534,932      2022             $0        $63,370            $80,727        $130,638         $124,476       $399,210      $399,210
           2023                   $0.00             $0.000              $0.000       $0.000        $0.000      2023                 $0              $0                 $0               $0               $0             $0        $0         2023             $0             $0                 $0               $0               $0             $0        $0
           2024                   $0.00             $0.000              $0.000       $0.000        $0.000      2024                 $0              $0                 $0               $0               $0             $0        $0         2024             $0             $0                 $0               $0               $0             $0        $0

                                                                                                                               Total PA Savings                                                                                                            Total PA Savings
    NOTE: Gray shaded areas will need to be updated with each new avoided cost study.
                                                                                                              Year      Annual MWh       Summer kW         Winter kW                                                                         Year   Annual MWh    Summer kW           Winter kW
                                                                                                              2010            258,386            40,209         24,973                                                                       2010       115,991          18,050            11,211
                                    PA's Sales                                                                2011            375,146            58,416         34,894                                                                       2011       148,584          23,137            13,821
    Sales                   2010               2011                2012                                       2012            455,167            70,469         41,605                                                                       2012       140,618          21,770            12,853
    Sales               19,875,225,902     20,065,687,558      20,416,813,696                               NOTE: These savings values are from the Savings Summary worksheet.
    % of SW Sales                  41%                41%                 41%
                                                                                                                                                         PA's DRIPE Values ($/kWh)                                                                                                PA's DRIPE Values ($/kWh)
                                        Energy Factors                                                                                                      2010          2011                    2012                                                                               2010          2011                    2012
                                                                                  Summer
        Factor          Winter Peak       Winter Off-Peak     Summer Peak                                                                    Rate        $       0.00028    $     0.00068    $     0.00122                                                            Rate        $       0.00030    $     0.00069    $     0.00110
                                                                                  Off-Peak
    Line Loss
                                12.60%               8.63%             12.60%        8.63%
    Factors
    Savings Load
                                   0.13                0.20                0.27         0.40
    Shape

                                   Capacity Factors
         Factor        Summer Gen.     Winter Gen.                Trans.          Distrib.
    Line Loss
                                 9.24%               9.24%              9.24%        9.24%
    Factors

    NOTE: The light blues haded values in the "Energy Factors" and "Capacity Factor" tables
    are PA-specific inputs that are NOT included in the INPUTS worksheet.
NSTAR Electric
Average Residential
Executive Summary
Information to be copied into the Executive Summary Workbook.
INSTRUCTIONS: When filling in this worksheet, copy and paste special only the values from the Executive Summary workshe

    2. Average Residential Executive Summary Inputs
                  Inputs                  2010            2011              2012
    Average Measure Life                         8.0             8.0                  8.0
    Program Costs                       $35,704,274     $42,219,241          $48,960,273
    Lifetime Savings (MWh)                 381,733         469,888              535,340
    Annual Savings (MWh)                46,243,530      57,309,485           64,277,894
    Total Percent Increase in
                                             2.31%            0.80%                0.94%
    Components of Rate Increase
    Cumulative Participation Rate            11.5%           26.1%                46.8%
    Annual Participation Rate                11.5%           14.6%                20.9%
    Total Customers                         811,449         815,506              819,584
    Annual Participants - Total Case        169,844         197,053              247,654

    Year-to-Year Bill Impact
                                                                   COMPONENTS OF RATE INCREASE - Supply Rate He
                                        Customer
                Year                                 Distribution Rate       Supply Rate
                                         Charge
                2009                            1.07              7.21                  12.71
                2010                            1.07              7.19                  12.68
                2011                            1.07              7.17                  12.64
                2012                            1.07              7.16                  12.58
    NOTE: Average Residential is the only customer type that needs this table in the Executive Summary

                                            Percent Increase in Component
                  Year                 Distribution    Supply Rate   Efficiency Charges
                  2010                   -0.20%          -0.22%            212.62%
                  2011                   -0.24%          -0.32%             29.57%
                  2012                   -0.27%          -0.43%             27.63%

    Long-Term Bill Impact
                           Percent Impact on Monthly Bills: Including Long-Term Levelized
                Customer                    2010          2011             2012
    Total Efficiency Case vs. Zero Efficiency Case
    Participant                            -1.5%         -0.8%             0.0%
    Non-Participant                         3.7%          4.4%             5.2%
    Total Customer                          2.8%          2.4%             2.1%
    Total Efficiency Case vs. No EERF Case
    Participant                            -1.3%         -0.6%             0.3%
    Non-Participant                         1.5%          2.3%             3.2%
    Total Customer                          1.1%          1.1%             1.3%
lues from the Executive Summary worksheet within each customer type's bill impact workbook.



                     Notes




           Year-to-Year BI
           Worksheet; Supply Rate
           Held Constant
           Participation worksheet
           Participation worksheet
           Participation worksheet
           Participation worksheet


S OF RATE INCREASE - Supply Rate Held Constant
                                                           LI EERF       Decoupling     Total Efficiency    Grand
            System Benefits Charge Reconciling Charge
                                                           Allocation    Adjustment        Charges          Total
                                0.25                0.00          0.00           0.00                0.25     21.23
                                0.25                0.43          0.06           0.04                0.78     21.72
                                0.25                0.59          0.09           0.09                1.01     21.90
                                0.25                0.80          0.11           0.14                1.29     22.10
e Executive Summary


              Total Rate Increases
                     2.31%
                     0.80%
                     0.94%


erm Levelized
             Long-Term Levelized

                      -3.0%
                       1.2%
                      -1.2%

                      -1.5%
                       0.8%
                      -0.7%
The purpose of this worksheet is to provide a description for each worksheet and general conventions used throughout the workbook.
    Information within
Average Residential this workbook is for the average residential customer.

    Worksheet                          Description                                                                                                         Notes
    INPUTS                             Information specific to each PA from which the model is based on.                                                   Will need to be updated for each PA and each customer type.
    Rate Adjustments                   This worksheet shows the impact of each energy efficiency component on delivery and supply rates.
                                       Compares the bills of a participant, a non-participant, and the total customer type in the Total Case to: (1) the
    Three-Year Bill Impacts
                                       No EERF case; and (2) the Zero Case.
                                       This worksheet shows the impact of energy efficiency related rate and bill adjustments in relation to a
    Year-to-Year Bill Impacts
                                       customer's total bill.
                                       Provides monthly bill impacts over the life of energy efficiency measures, with costs incurred during the years
    Long-Term Bill Impacts
                                       of the three-year plan. Compares the Total Case to: (1) the Zero EERF Case; and (2) the No EERF Case.
                                       Provides an estimate of the number of "participants" in the Total Case and No EERF Case over the three-
    Participation
                                       year period of the plan and the long-term.
    Sales & Savings                    Provides analysis on sales, cumulative savings, and participant savings over the long-term.
                                                                                                                                                           The rate forecast will need to be updated with each new avoided
    Rate Forecast & Decoupling         Forecast of supply rates and a projected decoupling proxy.
                                                                                                                                                           cost study.
                                       Forecast of avoided T&D benefits included in delivery rates and summary of DRIPE benefits included in
    T&D & DRIPE
                                       supply rates.
                                                                                                                                                           The DRIPE Factors will need to be updated with each new
    DRIPE Calculation                  Calculates DRIPE over the long-term for the Total Case and the No EERF Case.                                        avoided cost study. This worksheet will be identical for each
                                                                                                                                                           customer type.
                                                                                                                                                           This will need to be copied and pasted into the Executive
    Executive Summary                  Information to be copied into the Executive Summary Workbook.
                                                                                                                                                           Summary Workbook.
                                       The purpose of this worksheet is to provide a description for each worksheet and general conventions used
    Notes
                                       throughout the workbook.
    Elec. Funding Sum                  Taken directly from Program Administrator's 08-50 Tables.
    Elec - SBC                         Taken directly from Program Administrator's 08-50 Tables.
    Elec - EERF                        Taken directly from Program Administrator's 08-50 Tables.
    Savings Summary                    Taken directly from Program Administrator's 08-50 Tables.


    Conventions used in this workbook
    Font Coloring:
    Maroon font indicates that the data is input by hand.

    Worksheet Coloring:
    Gray worksheets indicate that the worksheet has been pulled from the 08-50 tables.
NSTAR Electric
IV.B. Electric PA Funding Sources
1. Summary Table
                                                                      Allocation of Funding Sources, 2010
            Sector                       SBC (1)                FCM (2)              RGGI (3)           Other (4)        Carryover (5)     EERF (6)       TOTAL
Residential                                $13,139,982             $1,456,989         $5,622,434                    $0      ($1,800,348)    $22,099,027        $40,518,084
  % of Residential                                 32%                     4%                14%                    0%              -4%             55%               100%
Low Income                                    $707,645                $78,465           $302,793                    $0        ($613,245)       $174,336           $649,994
  % of Low Income                                 109%                    12%                47%                    0%             -94%             27%               100%
Commercial & Industrial                    $35,840,438             $3,974,063        $15,335,675                    $0      ($4,136,931)    $34,533,913        $85,547,158
  % of Commercial & Industrial                     42%                     5%                18%                    0%              -5%             40%               100%
            TOTAL                          $49,688,065             $5,509,517        $21,260,902                    $0      ($6,550,525)    $56,807,277       $126,715,236
          % of Total                               39%                     4%                17%                    0%               -5%            45%               100%


                                                                      Allocation of Funding Sources, 2011
            Sector                       SBC (1)                FCM (2)              RGGI (3)           Other (4)        Carryover (5)     EERF (6)       TOTAL
Residential                                $13,253,180             $1,443,440         $5,712,724                    $0               $0     $29,569,890        $49,979,234
  % of Residential                                 27%                     3%                11%                    0%               n/a            59%               100%
Low Income                                    $714,035                $77,768           $307,782                    $0               $0        $249,507         $1,349,091
  % of Low Income                                  53%                     6%                23%                    0%               n/a            18%               100%
Commercial & Industrial                    $36,197,004             $3,942,315        $15,602,556                    $0               $0     $90,957,796       $146,699,671
  % of Commercial & Industrial                     25%                     3%                11%                    0%               n/a            62%               100%
            TOTAL                          $50,164,219             $5,463,523        $21,623,061                    $0               n/a   $120,777,193       $198,027,996
          % of Total                               25%                     3%                11%                    0%               n/a            61%               100%


                                                                      Allocation of Funding Sources, 2012
            Sector                       SBC (1)                FCM (2)              RGGI (3)           Other (4)        Carryover (5)     EERF (6)       TOTAL
Residential                                $13,539,827             $1,427,201         $4,291,703                    $0               $0     $41,152,375        $60,411,107
  % of Residential                                 22%                     2%                 7%                    0%               n/a            68%               100%
Low Income                                    $729,974                $76,945           $231,379                    $0               $0        $312,392         $1,350,690
  % of Low Income                                  54%                     6%                17%                    0%               n/a            23%               100%
Commercial & Industrial                    $36,772,233             $3,876,074        $11,655,653                    $0               $0    $135,795,910       $188,099,870
  % of Commercial & Industrial                     20%                     2%                 6%                    0%               n/a            72%               100%
            TOTAL                          $51,042,034             $5,380,220        $16,178,735                    $0               n/a   $177,260,677       $249,861,667
          % of Total                               20%                     2%                 6%                    0%               n/a            71%               100%


                                                                  Allocation of Funding Sources, 2010-2012
            Sector                       SBC (1)                FCM (2)              RGGI (3)           Other (4)        Carryover (5)     EERF (6)       TOTAL
Residential                                $39,932,989             $4,327,630        $15,626,861                    $0      ($1,800,348)    $92,821,293       $150,908,425
  % of Residential                                 26%                     3%                10%                    0%              -1%             62%               100%
Low Income                                  $2,151,655               $233,178           $841,953                    $0        ($613,245)       $736,235         $3,349,775
  % of Low Income                                  64%                     7%                25%                    0%             -18%             22%               100%
Commercial & Industrial                   $108,809,675            $11,792,452        $42,593,884                    $0      ($4,136,931)   $261,287,620       $420,346,700
  % of Commercial & Industrial                     26%                     3%                10%                    0%              -1%             62%               100%
            TOTAL                         $150,894,318            $16,353,260        $59,062,698                    $0      ($6,550,525)   $354,845,148       $574,604,899
          % of Total                               26%                     3%                10%                    0%               -1%            62%               100%

Notes:
(1) See Table IV.B.3.1
(2) See Table IV.B.3.2
(3) See Table IV.B.3.3
(4) See Table IV.B.3.4
(5) See Table IV.B.3.5
(6) See Table IV.B.3.6

For the low income sector, explain the qualification for participating in low income programs




Elec. Funding Sum                                                                       Page 21 of 24                                                              10/22/2011
NSTAR Electric
IV.B. Electric PA Funding Sources
3.1. System Benefit Charge Funds
                                                           SBC Funds, 2010
                                                Energy Efficiency                    % Collections of                     % Allocation of
             Sector            kWh Sales                              Collections                          Allocation
                                                    Charge                                Total                                Total
Residential (1)                5,255,992,747                0.0025     $13,139,982              26.4%       $13,139,982            26.4%
Low Income (2)                   283,058,111                0.0025        $707,645               1.4%          $707,645               1.4%
Commercial & Industrial (3)   14,336,175,044                0.0025     $35,840,438              72.1%       $35,840,438            72.1%
          TOTAL               19,875,225,902                           $49,688,065               100%       $49,688,065              100%

                                                         SBC Collections, 2011
                                                Energy Efficiency                    % Collections of                     % Allocation of
             Sector            kWh Sales                              Collections                          Allocation
                                                    Charge                                Total                                Total
Residential (1)                5,301,271,966                0.0025     $13,253,180              26.4%       $13,253,180            26.4%
Low Income (2)                   285,613,975                0.0025        $714,035               1.4%          $714,035               1.4%
Commercial & Industrial (3)   14,478,801,616                0.0025     $36,197,004              72.2%       $36,197,004            72.2%
          TOTAL               20,065,687,558                           $50,164,219               100%       $50,164,219              100%

                                                         SBC Collections, 2012
                                                Energy Efficiency                    % Collections of                     % Allocation of
             Sector            kWh Sales                              Collections                          Allocation
                                                    Charge                                Total                                Total
Residential (1)                5,415,930,714                0.0025     $13,539,827              26.5%       $13,539,827            26.5%
Low Income (2)                   291,989,756                0.0025        $729,974               1.4%          $729,974               1.4%
Commercial & Industrial (3)   14,708,893,225                0.0025     $36,772,233              72.0%       $36,772,233            72.0%
          TOTAL               20,416,813,696                           $51,042,034               100%       $51,042,034              100%

                                                     SBC Collections, 2010-2012
                                                Energy Efficiency               % Collections of                          % Allocation of
             Sector            kWh Sales                           Collections                             Allocation
                                                    Charge                           Total                                     Total
Residential (1)               15,973,195,428                0.0025  $39,932,989            26.5%            $39,932,989            26.5%
Low Income (2)                   860,661,842                0.0025   $2,151,655             1.4%             $2,151,655               1.4%
Commercial & Industrial (3)   43,523,869,886                0.0025 $108,809,675            72.1%           $108,809,675            72.1%
          TOTAL               60,357,727,155                       $150,894,318             100%           $150,894,318              100%

Notes:
(1) kWh Sales is the sum of sales from the following rate classes:
                             Beco                R-1, R-3, R-4
                             Celco               R-1, R-3, R-5, R-6
                             Comel               R-1, R-3, R-5, R-6
(2) kWh Sales is the sum of sales from the following rate classes:
                             Beco                R-2
                             Celco               R-2, R-4
                             Comel               R-2, R-4
(3) kWh Sales is the sum of sales from the following rate classes:
                             Beco                G-1, G-2, G-3, T-1, T-2, WR, S-1, S-2, S-3, SB-G3, SB-T2
                             Celco               G-0, G-1, G-2, G-3, G-4, G-5, G-6, SB-1, MS-1, SS-1, SB-G2, SB-G3
                             Comel               G-1, G-2, G-3, G-4, G-5, G-6, G-7, SB-G3, SB-G2, S-1, S-2,




Elec - SBC                                                     Page 22 of 24                                                    10/22/2011
NSTAR Electric
IV.B. Electric PA Funding Sources
3.6. EERF
                                      Calculation of Energy Efficiency Reconciliation Factor Funds, 2010 (1)
                                                                 SBC + FCM + RGGI +                              % of Total
                                                  Lost Base                                 EERF Funding                    Low Income EERF Funding
         Sector             Total Budget (2)                       Other Funds +                                 Company
                                                 Revenue (3)                                 Required (4)                   Allocation (6) Allocation (7)
                                                                     Carryover                                    kWh (5)
Residential                     $35,704,274         $1,576,628           $18,419,057              $18,861,845         26.4%    $3,237,182    $22,099,027
Low Income                      $12,695,580            $21,290             $475,658               $12,241,212          1.4%     $174,336        $174,336
Commercial & Industrial         $73,316,420         $3,401,045           $51,013,245              $25,704,220         72.1%    $8,829,694    $34,533,913
         TOTAL                 $121,716,273         $4,998,963           $69,907,960              $56,807,277       100.0%   $12,241,212     $56,807,277

                                      Calculation of Energy Efficiency Reconciliation Factor Funds, 2011 (1)
                                                                                                                 % of Total
                                                  Lost Base      SBC + FCM + RGGI +         EERF Funding                    Low Income EERF Funding
         Sector             Total Budget (2)                                                                     Company
                                                 Revenue (3)        Other Funds              Required (4)                   Allocation (6) Allocation (7)
                                                                                                                  kWh (5)
Residential                     $42,219,241         $3,128,905             $20,409,344            $24,938,803         26.4%    $4,631,088    $29,569,890
Low Income                      $18,574,653            $53,923              $1,099,584            $17,528,993          1.4%     $249,507        $249,507
Commercial & Industrial        $124,310,039         $9,741,234             $55,741,875            $78,309,398         72.2%  $12,648,398     $90,957,796
         TOTAL                 $185,103,933        $12,924,063             $77,250,803           $120,777,193       100.0%   $17,528,993    $120,777,193

                                      Calculation of Energy Efficiency Reconciliation Factor Funds, 2012 (1)
                                                                                                                 % of Total
                                                  Lost Base      SBC + FCM + RGGI +         EERF Funding                    Low Income EERF Funding
         Sector             Total Budget (2)                                                                     Company
                                                 Revenue (3)        Other Funds              Required (4)                   Allocation (6) Allocation (7)
                                                                                                                  kWh (5)
Residential                     $48,960,273         $5,656,481             $19,258,731            $35,358,023         26.5%    $5,794,352    $41,152,375
Low Income                      $22,785,117            $96,556              $1,038,298            $21,843,375          1.4%     $312,392        $312,392
Commercial & Industrial        $153,850,851        $18,512,388             $52,303,960           $120,059,279         72.0%  $15,736,631    $135,795,910
         TOTAL                 $225,596,241        $24,265,426             $72,600,990           $177,260,677       100.0%   $21,843,375    $177,260,677

                                   Calculation of Energy Efficiency Reconciliation Factor Funds, 2010-2012 (1)
                                                                                                                 % of Total
                                                  Lost Base      SBC + FCM + RGGI +         EERF Funding                    Low Income EERF Funding
         Sector             Total Budget (2)                                                                     Company
                                                 Revenue (3)        Other Funds              Required (4)                   Allocation (6) Allocation (7)
                                                                                                                  kWh (5)
Residential                    $126,883,789        $10,362,014             $58,087,132            $79,158,671         26.5%  $13,659,126     $92,817,797
Low Income                      $54,055,350          $171,770               $2,613,540            $51,613,579          1.4%     $735,976        $735,976
Commercial & Industrial        $351,477,310        $31,654,667            $159,059,080           $224,072,897         72.1%  $37,218,477    $261,291,374
         TOTAL                 $532,416,448        $42,188,451            $219,759,752           $354,845,148       100.0%   $51,613,579    $354,845,148

Notes:
(1) See Section IV.I.2 Calculation of EERF and V.E. Energy Efficiency Reconciliation Factor for more information
(2) Budget - See Budget Summary Table IV.C.1.
(3) LBR - See LBR Calculation Table IV.G.1.
(4) EERF Revenue Required = (Total Budget + LBR) - (SBC + FCM + RGGI + Other Funds + Carryover)
(5) See Elec - SBC Table IV.B. 3.1
(6) Column F x Low Income EERF Funding Required
(7) Residetial = EERF Funding Required for Residential + Low Income Allocation for Residential; Low Income = Low Income Allocation;
    Commercial & Industrial = EERF Funding Required for C&I + Low Income Allocation for C&I
EERF needs to include Carry Over (deferral w/interest and Interst on Deferral)




Elec - EERF                                                             Page 23 of 24                                                          10/22/2011
NSTAR Electric
IV.D. Cost Effectiveness
3.2.i. Savings Summary Table
                                                                                                                             Electric Savings, 2010                                                                                        Non Electric Resources, 2010
                                                             # of                  Capacity (kW)                                                     Energy (MWh)                                                                              MMBTU                                          Gallons
                          Program
                                                         Participants           Annual                                   Summer (Annual)          Winter (Annual)            Total Annual                    Avoided           No. 2         No. 4
                                                                                                 Lifetime                                                                                    Lifetime                                                Propane         Wood        Kerosene      Water
                                                                            Summer    Winter                             Peak    Off Peak         Peak     Off Peak             MWh                         Natural Gas       Distillate    Fuel Oil
Residential (total)                                            169,844            7,107          9,286         92,745      12,486      18,497         6,012          9,249        46,244          381,733          19,645        92,408           0         5,147           0           0    10,369,975
Residential New Construction & Major Renovation                    686              559            325         13,041         319         472           153            236         1,180           15,280           1,047           469           0         4,397           0           0        65,170
Residential Cooling & Heating Equipment                          3,515              655             87          8,788         203         301            98            150           752           12,427          -1,209             0           0             0           0           0             0
Multi-Family Retrofit                                            5,000              309            954          3,518       1,086       1,609           523            804         4,022           35,043               0             0           0             0           0           0     2,556,435
MassSAVE                                                         9,000            2,448          2,310         42,459       3,164       4,687         1,523          2,343        11,717           95,372          19,807        91,939           0           750           0           0     7,748,370
O Power                                                  n/a               n/a            n/a            n/a            n/a         n/a         n/a       n/a        n/a                    n/a         n/a         n/a                    n/a        n/a           n/a         n/a         n/a
ENERGY STAR Lighting                                           129,068            2,406          4,900      18,813          6,152       9,115       2,962      4,557      22,787                176,805           0          0                    0            0            0           0             0
ENERGY STAR Appliances                                          22,575              731            708       6,127          1,562       2,314         752      1,157       5,786                 46,805           0          0                    0            0            0           0             0
Low Income (total)                                               9,508              777          1,269      11,831          1,986       2,942         956      1,471       7,355                 95,136         754     25,867                    0          452            0           0       825,853
Low-Income Residential New Construction                            495              125             47       2,936             59          87          28         44         219                  2,659         754         19                    0          452            0           0         4,455
Low-Income 1 to 4 Family Retrofit                                3,400              337            543       5,066            805       1,192         387        596       2,980                 43,054           0      7,151                    0            0            0           0       821,398
Low-Income MuiltiFamily Retrofit                                 5,613              315            678       3,829          1,122       1,663         540        831       4,157                 49,423           0     18,697                    0            0            0           0             0
Commercial & Industrial (total)                                  2,686           32,325         14,419     437,469         61,436      28,670      83,963     30,718     204,787             2,767,512      -36,609          0                    0            0            0           0             0
C&I New Construction and Major Renovation                          401            8,147          2,504     134,584         13,500       6,300      18,450      6,750      44,999                759,490       2,103          0                    0            0            0           0             0
C&I New Construction and Major Renovation - Government         n/a               n/a            n/a            n/a      n/a         n/a         n/a       n/a        n/a                    n/a         n/a         n/a                    n/a        n/a           n/a         n/a         n/a
C&I Large Retrofit                                                   602         17,842          9,009     222,201         38,801      18,107      53,028     19,401     129,337             1,621,703       -9,655          0                    0            0            0           0             0
Large C&I Retrofit - Government                                n/a               n/a            n/a            n/a      n/a         n/a         n/a       n/a        n/a                    n/a         n/a         n/a                    n/a        n/a           n/a         n/a         n/a
C&I Small Retrofit                                               1,683            6,336          2,906         80,684       9,135       4,263      12,485      4,568      30,452                386,319     -29,057          0                    0            0            0           0             0
C&I Small Retrofit - Government                                n/a               n/a            n/a            n/a      n/a         n/a         n/a       n/a        n/a                    n/a         n/a         n/a                    n/a        n/a           n/a         n/a         n/a
                          GRAND TOTAL                          182,038           40,209         24,973     542,045         75,908      50,110      90,931     41,438     258,386             3,244,381      -16,210    118,275                    0         5,599           0           0    11,195,828

                                                                                                                             Electric Savings, 2011                                                                                        Non Electric Resources, 2011
                                                             # of                  Capacity (kW)                                                     Energy (MWh)                                                                              MMBTU                                          Gallons
                          Program
                                                         Participants           Annual                                   Summer (Annual)          Winter (Annual)            Total Annual                    Avoided           No. 2         No. 4
                                                                                                 Lifetime                                                                                    Lifetime                                                Propane         Wood        Kerosene      Water
                                                                            Summer    Winter                             Peak    Off Peak         Peak     Off Peak             MWh                         Natural Gas       Distillate    Fuel Oil
Residential (total)                                            197,053            8,842         11,353      114,610    15,474          22,924         7,450         11,462        57,309          469,888          24,020       112,916           0         6,417           0           0    12,013,297
Residential New Construction & Major Renovation                    858              700            407       16,310       398             590           192            295         1,476           19,112           1,309           586           0         5,500           0           0        81,510
Residential Cooling & Heating Equipment                          4,707              877            130       11,455       274             406           132            203         1,014           16,622          -1,477             0           0             0           0           0             0
Multi-Family Retrofit                                            6,250              391          1,197        4,493     1,362           2,018           656          1,009         5,046           44,156               0             0           0             0           0           0     3,408,580
MassSAVE                                                        11,000            2,945          2,647       51,566     3,673           5,441         1,768          2,721        13,603          111,541          24,188       112,330           0           917           0           0     8,523,207
O Power                                                  n/a               n/a            n/a            n/a        n/a             n/a         n/a       n/a        n/a                    n/a         n/a                  n/a           n/a        n/a           n/a         n/a         n/a
ENERGY STAR Lighting                                           143,488            2,941          5,991       22,674     7,561          11,201       3,640      5,600      28,002                214,855           0                   0           0            0            0           0             0
ENERGY STAR Appliances                                          30,750              990            980        8,112     2,206           3,267       1,062      1,634       8,169                 63,602           0                   0           0            0            0           0             0
Low Income (total)                                              14,152            1,097          1,751       16,269     2,975           4,407       1,432      2,204      11,018                140,037         910              39,747           0          546            0           0     1,160,247
Low-Income Residential New Construction                            597              150             56        3,541        71             105          34         53         263                  3,202         910                  23           0          546            0           0       256,710
Low-Income 1 to 4 Family Retrofit                                4,150              444            685        6,859     1,048           1,553         505        776       3,881                 57,814           0               9,104           0            0            0           0       903,537
Low-Income MuiltiFamily Retrofit                                 9,405              502          1,010        5,868     1,856           2,749         894      1,375       6,874                 79,022           0              30,620           0            0            0           0             0
Commercial & Industrial (total)                                  4,120           48,476         21,791      652,040    92,046          42,955     125,796     46,023     306,819             4,122,169      -71,290                   0           0            0            0           0             0
C&I New Construction and Major Renovation                          538           11,170          3,433      184,534    18,510           8,638      25,297      9,255      61,700             1,041,372        2,883                   0           0            0            0           0             0
C&I New Construction and Major Renovation - Government         n/a               n/a            n/a          n/a    n/a             n/a         n/a       n/a        n/a                    n/a         n/a                  n/a           n/a        n/a           n/a         n/a         n/a
C&I Large Retrofit                                                   890         26,945         13,605      335,559    58,596          27,345      80,081     29,298     195,319             2,449,032      -26,655                   0           0            0            0           0             0
Large C&I Retrofit - Government                                n/a               n/a            n/a          n/a    n/a             n/a         n/a       n/a        n/a                    n/a         n/a                  n/a           n/a        n/a           n/a         n/a         n/a
C&I Small Retrofit                                               2,692           10,361          4,753      131,947    14,940           6,972      20,418      7,470      49,799                631,765     -47,518                   0           0            0            0           0             0
C&I Small Retrofit - Government                                n/a               n/a            n/a          n/a    n/a             n/a         n/a       n/a        n/a                    n/a         n/a                  n/a           n/a        n/a           n/a         n/a         n/a
                          GRAND TOTAL                          215,325           58,416         34,894      782,919 110,494            70,286     134,678     59,688     375,146             4,732,094      -46,360             152,663           0         6,963           0           0    13,173,544

                                                                                                                             Electric Savings, 2012                                                                                        Non Electric Resources, 2012
                                                             # of                  Capacity (kW)                                                     Energy (MWh)                                                                              MMBTU                                          Gallons
                          Program
                                                         Participants           Annual                                   Summer (Annual)          Winter (Annual)            Total Annual                    Avoided           No. 2         No. 4
                                                                                                 Lifetime                                                                                    Lifetime                                                Propane         Wood        Kerosene      Water
                                                                            Summer    Winter                             Peak    Off Peak         Peak     Off Peak             MWh                         Natural Gas       Distillate    Fuel Oil
Residential (total)                                            247,654           10,268         12,820      135,936    17,355          25,711         8,356         12,856        64,278          535,340          28,325       121,599           0         7,592           0           0    14,855,059
Residential New Construction & Major Renovation                  1,004              819            476       19,086       466             691           224            345         1,727           22,364           1,532           686           0         6,436           0           0        95,380
Residential Cooling & Heating Equipment                          6,387            1,282            210       17,048       377             559           182            280         1,398           22,794          -1,793             0           0             0           0           0             0
Multi-Family Retrofit                                            7,800              496          1,504        5,795     1,713           2,538           825          1,269         6,346           55,877               0             0           0             0           0           0     4,686,798
MassSAVE                                                        13,000            3,442          2,982       60,673     4,180           6,192         2,012          3,096        15,480          127,482          28,586       120,913           0         1,156           0           0    10,072,881
O Power                                                  n/a               n/a            n/a            n/a        n/a             n/a         n/a       n/a        n/a                    n/a         n/a                  n/a           n/a        n/a           n/a         n/a         n/a
ENERGY STAR Lighting                                           182,563            3,206          6,530       25,138     8,298          12,293       3,995      6,146      30,732                242,436           0                   0           0            0            0           0             0
ENERGY STAR Appliances                                          36,900            1,023          1,117        8,196     2,321           3,438       1,117      1,719       8,596                 64,388           0                   0           0            0            0           0             0
Low Income (total)                                              17,787            1,398          2,133       20,996     3,642           5,395       1,753      2,698      13,488                174,704       1,093              53,228           0          655            0           0     1,753,970
Low-Income Residential New Construction                            717              178             57        4,228        74             109          36         55         274                  3,466       1,093                  27           0          655            0           0       308,310
Low-Income 1 to 4 Family Retrofit                                6,720              725          1,112       11,231     1,709           2,531         823      1,266       6,328                 94,645           0              15,859           0            0            0           0     1,445,660
Low-Income MuiltiFamily Retrofit                                10,350              495            963        5,537     1,859           2,755         895      1,377       6,886                 76,593           0              37,342           0            0            0           0             0
Commercial & Industrial (total)                                  4,515           58,803         26,651      787,531 113,220            52,836     154,734     56,610     377,401             5,047,193      -79,898                   0           0            0            0           0             0
C&I New Construction and Major Renovation                          604           12,823          3,941      211,832    21,248           9,916      29,039     10,624      70,828             1,195,422        3,310                   0           0            0            0           0             0
C&I New Construction and Major Renovation - Government         n/a               n/a            n/a          n/a    n/a             n/a         n/a       n/a        n/a                    n/a         n/a                  n/a           n/a        n/a           n/a         n/a         n/a
C&I Large Retrofit                                               1,131           35,036         17,690      436,320    76,191          35,556     104,127     38,095     253,969             3,184,422      -33,014                   0           0            0            0           0             0
Large C&I Retrofit - Government                                n/a               n/a            n/a          n/a    n/a             n/a         n/a       n/a        n/a                    n/a         n/a                  n/a           n/a        n/a           n/a         n/a         n/a
C&I Small Retrofit                                               2,780           10,945          5,020      139,379    15,781           7,365      21,568      7,891      52,604                667,348     -50,194                   0           0            0            0           0             0
C&I Small Retrofit - Government                                n/a               n/a            n/a          n/a    n/a             n/a         n/a       n/a        n/a                    n/a         n/a                  n/a           n/a        n/a           n/a         n/a         n/a
                          GRAND TOTAL                          269,956           70,469         41,605      944,462 134,217            83,942     164,844     72,163     455,167             5,757,237      -50,480             174,827           0         8,247           0           0    16,609,029

                                                                                                                          Electric Savings, 2010-2012                                                                                 Non Electric Resources, 2010-2012
                                                             # of                  Capacity (kW)                                                     Energy (MWh)                                                                              MMBTU                                          Gallons
                          Program
                                                         Participants           Annual                                   Summer (Annual)          Winter (Annual)            Total Annual                    Avoided           No. 2         No. 4
                                                                                                 Lifetime                                                                                    Lifetime                                                Propane         Wood        Kerosene      Water
                                                                            Summer    Winter                             Peak    Off Peak         Peak     Off Peak             MWh                         Natural Gas       Distillate    Fuel Oil
Residential (total)                                            614,551           26,217         33,459      343,290    45,314     67,132           21,818           33,566       167,831     1,386,961             71,990       326,923           0     19,156              0           0    37,238,331
Residential New Construction & Major Renovation                  2,548            2,078          1,208       48,436     1,183      1,753              570              876         4,382         56,756             3,888         1,741           0     16,333              0           0       242,060
Residential Cooling & Heating Equipment                         14,609            2,813            428       37,291        854     1,265              411              633         3,163         51,844            -4,479             0           0           0             0           0             0
Multi-Family Retrofit                                           19,050            1,196          3,655       13,805     4,162      6,166            2,004            3,083        15,414        135,076                 0             0           0           0             0           0    10,651,813
MassSAVE                                                        33,000            8,834          7,939      154,698    11,016     16,320            5,304            8,160        40,800        334,395            72,581       325,182           0       2,823             0           0    26,344,458
O Power                                                  n/a               n/a            n/a            n/a        n/a        n/a              n/a           n/a        n/a                n/a             n/a              n/a           n/a        n/a           n/a         n/a         n/a
ENERGY STAR Lighting                                           455,119         8,553            17,422       66,624    22,011     32,609           10,598         16,304       81,521           634,096                  0            0           0           0             0           0             0
ENERGY STAR Appliances                                          90,225         2,744             2,806       22,435     6,089      9,020            2,932          4,510       22,550           174,795                  0            0           0           0             0           0             0
Low Income (total)                                              41,447         3,272             5,152       49,096     8,602     12,744            4,142          6,372       31,861           409,877              2,757      118,842           0       1,653             0           0     3,740,070
Low-Income Residential New Construction                          1,809           453               160       10,706        204       302               98            151          755             9,326              2,757           69           0       1,653             0           0       569,475
Low-Income 1 to 4 Family Retrofit                               14,270         1,507             2,340       23,156     3,561      5,276            1,715          2,638       13,189           195,513                  0       32,114           0           0             0           0     3,170,595
Low-Income MuiltiFamily Retrofit                                25,368         1,312             2,652       15,234     4,837      7,167            2,329          3,583       17,917           205,038                  0       86,659           0           0             0           0             0
Commercial & Industrial (total)                                 11,321       139,604            62,861    1,877,039 266,702 124,461               364,493       133,351       889,007       11,936,874            -187,797            0           0           0             0           0             0
C&I New Construction and Major Renovation                        1,543        32,140             9,878      530,950    53,258     24,854           72,786         26,629      177,527        2,996,284               8,296            0           0           0             0           0             0
C&I New Construction and Major Renovation - Government         n/a               n/a            n/a          n/a        n/a    n/a              n/a           n/a        n/a                n/a             n/a              n/a           n/a        n/a           n/a         n/a         n/a
C&I Large Retrofit                                               2,623           79,823         40,304      994,079 173,588       81,008          237,236         86,794      578,625        7,255,158             -69,324            0           0           0             0           0             0
Large C&I Retrofit - Government                                n/a               n/a            n/a          n/a    n/a        n/a              n/a           n/a        n/a                n/a             n/a              n/a           n/a        n/a           n/a         n/a         n/a
C&I Small Retrofit                                               7,155           27,642         12,679      352,010    39,856     18,600           54,470         19,928      132,854        1,685,432            -126,769            0           0           0             0           0             0
C&I Small Retrofit - Government                                n/a               n/a            n/a          n/a    n/a        n/a              n/a           n/a        n/a                n/a             n/a              n/a           n/a        n/a           n/a         n/a         n/a
                          GRAND TOTAL                          667,319       169,093        101,472       2,269,425 320,619 204,338               390,453       173,289     1,088,698       13,733,712            -113,050      445,765           0     20,809              0           0    40,978,401




Savings Summary                                                                                                                             Page 24 of 24                                                                                                                                                 10/22/2011

								
To top