Target Calculator by tam26166

VIEWS: 24 PAGES: 11

									                                                                                                                   5th Plan Conser
Introduction: The purpose of this calculator is to provide utilities with a simple means to compute "their share" of the Northwes
"approximation" of the level of conservation they should target in order to be consistent with the Council's regional goals. The C
through utility integrated resource planning processes which can better account for local conditions and legal requirements. Ne
completes its own integrated resource plan or other similar process.
Instructions: Select utility from the pull-down menu in row 12. Three options are provided to calculate individual utility shares
industrial sectors reasonably match those of the entire region. Option 2 is best suited for any utility regardless of size that does
service territory of interest. Option 3 requires that the user enter the utility's 2005 retail sales to the irrigated agriculture sector (c
across sectors. The results for Option 3 are not valid unless a utility's irrigation sector retail sales have been entered by the use
                           Version Number =>           1_7                      Utility Shares Based on EIA Data for =>
                                                                                                 Option 1 - Target Based on Uti
Select Utility Service Area                                                                                                              Annua

 Central Lincoln People's Ut Dt - OR
                          7
                                                           2005          2006           2007            2008           2009
Total - All Sectors                                        1.10          1.14           1.19            1.23           1.27


                                                                                                                                         Annua
                                                          2005          2006           2007           2008            2009
Total - All Sectors                                    9,639.2      10,010.0       10,380.7       10,751.5        11,122.2

                                                                                         Option 2 - Target Based on Utility S


                                                                                                                                         Annua
Year                                                       2005          2006           2007            2008           2009
Residential                                                0.30          0.32           0.34            0.36           0.37
Commercial                                                 0.16          0.17           0.18            0.19           0.20
Industrial and Irrigated Agriculture                       0.75          0.75           0.75            0.75           0.75
Total - All Sectors                                        1.22          1.24           1.27            1.30           1.32



                                                                                                                                         Annua
Year                                                      2005          2006           2007           2008            2009
Residential                                            2,671.7       2,820.1        2,968.5        3,117.0         3,265.4
Commercial                                             1,413.4       1,501.8        1,590.1        1,678.4         1,766.8
Industrial and Irrigated Agriculture                   6,560.2       6,560.2        6,560.2        6,560.2         6,560.2
Total - All Sectors                                   10,645.3      10,882.0       11,118.8       11,355.6        11,592.3


                                                            Option 3 - Target Based on Utility Reported Share of To

                                                                                EIA includes irrigation sales in its industrial sector total. In o
                                                             Share of   adjust for this, please enter your utility's 2006 retail sales in
                                                 2006 Retail Regional irrigation below in row 38. The industrial sector sales will up
Sector                                           Sales (MWH) Sales      automatically so that the total still agrees with EIA data.
Residential                                          428,622      0.68%                   Combined Ind & Irrig Sales (MWh)=>
Commercial                205,124   0.40%                Net Industrial Sales (MWh) =>
Industrial                675,643   1.94%             Enter 2006 Irrigation Sales (MWh) =>
Irrigated Agriculture         -     0.00%
Total - All Sectors     1,309,389   0.85%

                                                                                       Annua


Year                        2005     2006     2007         2008         2009
Residential                0.305    0.322    0.339        0.356        0.373
Commercial                 0.161    0.171    0.182        0.192        0.202
Industrial                 0.677    0.677    0.677        0.677        0.677
Irrigated Agriculture        -        -        -            -            -
Total - All Sectors        1.144    1.171    1.198        1.225        1.252


                                                                                       Annua

Year                        2005      2006     2007        2008         2009
Residential                2,672     2,820    2,969       3,117        3,265
Commercial                 1,413     1,502    1,590       1,678        1,767
Industrial                 5,935     5,935    5,935       5,935        5,935
Irrigated Agriculture        -         -        -           -            -
Total - All Sectors       10,020    10,257   10,493      10,730       10,967
     5th Plan Conservation Target Calculator
"their share" of the Northwest Power and Conservation Council 5th Plan's regional conservation target. This calculator is intended to provide
uncil's regional goals. The Council does not formally assign individual utility targets in its planning process. Individual utility conservation go
 and legal requirements. Nevertheless, the results of this calculator can be used as rough guidance for utility conservation program planning


 late individual utility shares of the 5th Plan's conservation target. Option 1 is best suited for larger utilities whose retail sales across residenti
regardless of size that does not have significant retail sales to irrigated agriculture. Options 1 and 2 do not require any input data. Users only
irrigated agriculture sector (cell i38). Option 3 is the is preferred approach since it best accounts for differences in both the resource potentia
ave been entered by the user. Note: Utilities that serve multiple states must add each states results together to determine their totals.
 EIA Data for =>                  2006                                      Last Revised =>
 - Target Based on Utility Share of Total Regional Retail Sales
                          Annual Conservation Target (aMW)

                        2010           2011          2012      2013          2014             2015          2016           2017
                        1.31           1.35          1.40      1.44          1.48             1.52          1.48           0.93


                        Annual Conservation Target (MWH)
                       2010      2011        2012        2013               2014             2015          2016            2017
                   11,492.9  11,863.7    12,234.4    12,605.2           12,975.9         13,346.6      12,975.9         8,156.3

get Based on Utility Share of Total Regional Retail Sales by Sector


                          Annual Conservation Target (aMW)
                        2010       2011        2012      2013                2014             2015          2016           2017
                        0.39       0.41        0.42      0.44                0.46             0.51          0.53           0.37
                        0.21       0.24        0.25      0.24                0.25             0.26          0.27           0.20
                        0.75       0.67        0.67      0.75                0.75             0.67          0.50           0.08
                        1.35       1.31        1.34      1.43                1.46             1.44          1.30           0.66



                        Annual Conservation Target (MWH)
                       2010       2011       2012        2013               2014             2015          2016            2017
                    3,413.8    3,562.2    3,710.7     3,859.1            4,007.5          4,452.8       4,601.2         3,265.4
                    1,855.1    2,120.1    2,208.5     2,120.1            2,208.5          2,296.8       2,385.1         1,766.8
                    6,560.2    5,831.3    5,831.3     6,560.2            6,560.2          5,831.3       4,373.4           728.9
                   11,829.1  11,513.6    11,750.4    12,539.4           12,776.1         12,580.9      11,359.8         5,761.1


 Reported Share of Total Regional Retail Sales by Sector - Adjusted for Irrigation Sales
                              EIA 2005
                                               Reported
 in its industrial sector total. In order to   Industrial
your utility's 2006 retail sales in MWH for    and
he industrial sector sales will update         Irrigated
al still agrees with EIA data.                 Agriculture
nd & Irrig Sales (MWh)=>                          675,643
strial Sales (MWh) =>                 675,643
rrigation Sales (MWh) =>                  -




                     Annual Conservation Target (aMW)


                   2010       2011       2012       2013    2014     2015     2016     2017
                  0.390      0.407      0.424      0.441   0.457    0.508    0.525    0.373
                  0.212      0.242      0.252      0.242   0.252    0.262    0.272    0.202
                  0.677      0.677      0.677      0.774   0.774    0.774    0.581    0.097
                    -          -          -          -       -        -        -        -
                  1.279      1.326      1.353      1.457   1.484    1.545    1.378    0.671


                     Annual Conservation Target (MWH)

                   2010       2011       2012       2013     2014     2015     2016    2017
                  3,414      3,562      3,711      3,859    4,008    4,453    4,601   3,265
                  1,855      2,120      2,208      2,120    2,208    2,297    2,385   1,767
                  5,935      5,935      5,935      6,782    6,782    6,782    5,087     848
                    -          -          -          -        -        -        -       -
                 11,204     11,617     11,854     12,762   12,998   13,532   12,073   5,880
calculator is intended to provide utilities with an
Individual utility conservation goals are best established
 conservation program planning until such time as a utility


hose retail sales across residential, commercial and
 equire any input data. Users only need to select the utility
ces in both the resource potential and the 5th Plan's targets
r to determine their totals.
                                 12/4/2008



                                               Average
                            Total 2005 -     Annual Target
                       2018    2024           2005 - 2024
                       0.85         17.7               1.29

                                               Average
                           Total 2005 -      Annual Target
                      2018    2024            2005 - 2024
                   7,414.8   154,969.4           11,307.58




                                               Average
                            Total 2005 -     Annual Target
                       2018    2024           2005 - 2024
                       0.30          5.5                0.4
                       0.20          3.0                0.2
                       0.08          8.7                0.7
                       0.59         17.2                1.3


                                               Average
                           Total 2005 -      Annual Target
                      2018    2024            2005 - 2024
                   2,671.7    48,387.0             3,339.6
                   1,766.8    26,678.2             1,846.3
                     728.9    75,806.4             6,414.4
                   5,167.4   150,871.6            11,600.3


ales
                         Average
        Total 2005 -   Annual Target
 2018      2024         2005 - 2024
0.305            0.5              0.4
0.202            0.3              0.2
0.097            0.8              0.7
  -              -                -
0.603            1.5              1.3


                         Average
      Total 2005 -     Annual Target
 2018    2024           2005 - 2024
2,672        4,453           3,339.6
1,767        2,297           1,846.3
  848        6,782           6,104.2
  -            -                  -
5,286      13,532           11,290.1
Intructions: The purpose of this worksheet is to provide utilities with an estimate of the annual budget that may be required to
Northwest Power and Conservation Council 5th Plan's regional conservation target. It is not intended to set minumum expendit
formally assign individual utility targets or minimum expenditures in its planning process. Individual utility conservation goals are
integrated resource planning processes which can better account for local conditions and legal requirements. Nevertheless, the
used as rough guidance for utility conservation program planning until such time as a utility completes its own integrated resour
"Utility First Year Acquistion Cost/aMW" shown under the "Default" heading are based in 2006 savings and expenditures report
Select First Year Acquisition Cost/aMW Assumption                   Default


Utility First Year Cost of Savings (million 2007$/aMW)              Default    Planned
                                                  Residential       $     2.66 $      1.75
                                                 Commercial         $     2.39 $      1.75
                                                    Industrial      $     1.56 $      1.75
                                         Agriculture/Irrigation     $     1.54 $      1.75
                                                   All Sectors      $     2.10 $      1.75

                                                                                                                         Option 1 -


                                                                               2005     2006       2007       2008
                                                    Residential
                                                   Commercial
                                                      Industrial
                                           Agriculture/Irrigation
                                                     All Sectors              1.100    1.143     1.185       1.227


                                                                                                                         Option 2 -
                                                                               2005     2006      2007        2008
                                                     Residential              0.305    0.322     0.339       0.356
                                                    Commercial                0.161    0.171     0.182       0.192
                                 Industrial/Irrigated Agriculture             0.749    0.749     0.749       0.749
                                                      All Sectors             1.215    1.242     1.269       1.296

                                                                                                                         Option 3 -

                                                                               2005     2006      2007        2008
                                                    Residential               0.305    0.322     0.339       0.356
                                                   Commercial                 0.161    0.171     0.182       0.192
                                                      Industrial              0.677    0.677     0.677       0.677
                                           Agriculture/Irrigation               -        -         -           -
                                                     All Sectors              1.144    1.171     1.198       1.225
dget that may be required to acquire "their share" of the
ed to set minumum expenditure levels. The Council does not
 utility conservation goals are best established through utility
uirements. Nevertheless, the results of this calculator can be
tes its own integrated resource plan or other similar process. The
ngs and expenditures reported to the RTF for savings acquired




                 Option 1 - Annual Conservation Target (aMW)


                  2009      2010      2011        2012       2013     2014    2015    2016    2017    2018




                1.270     1.312      1.354      1.397       1.439    1.481   1.524   1.481   0.931   0.846


                 Option 2 - Annual Conservation Target (aMW)
                 2009      2010     2011      2012      2013          2014    2015    2016    2017    2018
                0.373    0.390     0.407    0.424      0.441         0.457   0.508   0.525   0.373   0.305
                0.202    0.212     0.242    0.252      0.242         0.252   0.262   0.272   0.202   0.202
                0.749    0.749     0.666    0.666      0.749         0.749   0.666   0.499   0.083   0.083
                1.323    1.350     1.314    1.341      1.431         1.458   1.436   1.297   0.658   0.590

                 Option 3 - Annual Conservation Target (aMW)

                 2009      2010       2011       2012        2013     2014    2015    2016    2017    2018
                0.373     0.390      0.407      0.424       0.441    0.457   0.508   0.381   0.373   0.305
                0.202     0.212      0.242      0.252       0.242    0.252   0.262   0.211   0.202   0.202
                0.677     0.677      0.677      0.677       0.774    0.774   0.774   0.697   0.097   0.097
                  -         -          -          -           -        -       -       -       -       -
                1.252     1.279      1.326      1.353       1.457    1.484   1.545   1.289   0.671   0.603
                                           Estimated Annual Acquisition Budget Requirements (millions y
Total
2005 -
 2018         2005       2006       2007       2008       2009       2010       2011




17.691    $   2.32   $   2.40   $   2.49   $   2.58   $   2.67   $   2.76   $   2.85

Total
2005 -                                      Estimated Annual Acquisition Budget Requirements (millions y
 2018         2005       2006       2007       2008      2009      2010      2011
  5.524   $   0.81   $   0.86   $   0.90   $   0.95 $    0.99 $    1.04 $    1.08
  3.045   $   0.39   $   0.41   $   0.43   $   0.46 $    0.48 $    0.51 $    0.58
  8.654   $   1.17   $   1.17   $   1.17   $   1.17 $    1.17 $    1.17 $    1.04
 17.223   $   2.56   $   2.61   $   2.67   $   2.73 $    2.78 $    2.84 $    2.77

Total                                      Estimated Annual Acquisition Budget Requirements (millions y
2005 -
 2018         2005       2006       2007       2008       2009       2010       2011
  5.380   $   0.81   $   0.86   $   0.90   $   0.95   $   0.99   $   1.04   $   1.08
  2.984   $   0.39   $   0.41   $   0.43   $   0.46   $   0.48   $   0.51   $   0.58
  8.633   $   1.06   $   1.06   $   1.06   $   1.06   $   1.06   $   1.06   $   1.06
    -     $    -     $    -     $    -     $    -     $    -     $    -     $    -
 16.997   $   2.41   $   2.46   $   2.52   $   2.58   $   2.63   $   2.69   $   2.79
n Budget Requirements (millions year 2006$)

                                                                                          Total 2005 -
                 2012       2013       2014       2015       2016       2017       2018      2018




            $   2.94    $   3.03   $   3.12   $   3.21   $   3.12   $   1.96   $   1.78   $      37.23


n Budget Requirements (millions year 2006$)                                                Total 2005 -
                2012       2013       2014        2015       2016       2017       2018       2018
            $   1.13 $    1.17 $      1.22 $      1.35   $   1.40   $   0.99   $   0.81   $       14.71
            $   0.60 $    0.58 $      0.60 $      0.63   $   0.65   $   0.48   $   0.48   $        7.28
            $   1.04 $    1.17 $      1.17 $      1.04   $   0.78   $   0.13   $   0.13   $       13.51
            $   2.82 $    3.01 $      3.07 $      3.02   $   2.73   $   1.38   $   1.24   $       36.24

n Budget Requirements (millions year 2006$)
                                                                                           Total 2005 -
                2012        2013       2014       2015       2016       2017       2018       2018
            $   1.13    $   1.17   $   1.22   $   1.35   $   1.02   $   0.99   $   0.81   $       14.33
            $   0.60    $   0.58   $   0.60   $   0.63   $   0.50   $   0.48   $   0.48   $        7.14
            $   1.06    $   1.21   $   1.21   $   1.21   $   1.09   $   0.15   $   0.15   $       13.47
            $    -      $    -     $    -     $    -     $    -     $    -     $    -     $         -
            $   2.85    $   3.07   $   3.12   $   3.25   $   2.71   $   1.41   $   1.27   $       35.77
                            1

                  Default
                  Planned




  Average
Annual Target
 2005 - 2018




$         2.66

  Average
Annual Target
 2005 - 2018




$         2.59

   Average
Annual Target
  2005 - 2018
$          1.02
$          0.50
$          1.09
$           -
$          2.55

								
To top