Memorandum of Understanding Introduction

W
Description

Memorandum of Understanding Introduction document sample

Shared by: sge21080
Categories
Tags
-
Stats
views:
4
posted:
3/21/2011
language:
English
pages:
23
Document Sample
scope of work template
							                                  include drop-down lists and radio buttons. These allow the user to select varios options or
                                  the bottom of each calculator is a hyperlink that when clicked will open your web browser a
                                  website page with information on the BMP's coverage requirement. This will only work if (1
                                  Excel recognizes and (2) you have an internet service provider. ANY CHANGES YOU MAK
                                  UNLESS YOU SAVE YOUR CHANGES TO THE FILE. SAVE YOUR FILE OFTEN TO AV
                                  LOSS.


                                  Your Agency's Base Year
                                  The calculator for BMP 1 requires you to enter the number of single-family and multi-family
                                  Base Year. Similarly, the calculator for BMP 9 requires you to enter the number of CII aco
                                  Year. Your agency's Base Year is as follows:

                                  Agencies signing MOU Prior to 1997: Base Year = 1997
                                  Agencies signing MOU After 1997: Base Year = Year Agency Signed MOU

                                  BMP Calculator Instructions
Go to BMP 1 Coverage Calculator




Go to BMP 2 Coverage Calculator
Go to BMP 4 Coverage Calculator




Go to BMP 5 Coverage Calculator




Go to BMP 9 Coverage Calculator




Go to BMP 9 CII ULFT Coverage Calc
Go to BMP 14 Coverage Calculator




                                   4. Enter the number of single-family and multi-family housing units in your service area con
                                   5. Enter the annual rate of housing demolition for the pre1992 housing stock.
                                   6. Enter the percent of pre1992 housing units that were constructed before 1/1/1980.
                                   7. Enter the average number of persons per household.
                                   8. Enter the average number of toilets per household.
                                   9. Enter the average rate of toilet replacement, as a percent of the existing stock of high-flo

                                   The calculator will determine the total acre-feet your ULFT program must save to be consid
                                   Retrofit-On-Resale requirement using the methodology presented in Exhibit 6 of the MOU.
                                   effectiveness of a Retrofit-On-Resale requirement by year can be printed by clicking the "P
                                   bottom of the calculator.
ABOUT THIS TOOL...
What is this?
This is a tool to help a water supplier calculate the coverage requirements for BMPs 1,2,4,5,9, and 14 according to the
Requirements set forth in Exhibit 1 of the Memorandum of Understanding Regarding Urban Water Conservation in
California (MOU). These calculators were developed by the California Urban Water Conservation Council.


What this is not.
These calculators are not designed to estimate an agency's BMP implementation relative to the coverage requirement.
They only show the coverage requirement, given agency-determined parameters for each BMP. The results, however, can
be used to determine if an agency's implementation of a BMP is on schedule to meet the coverage requirement within the
time specified by Exhibit 1 of the MOU.


General comments about using the calculators
You can only enter data in cells with white backgrounds. Cells with yellow backgrounds are calculation cells determined
by spreadsheet formulas. You cannot enter data into these cells, nor can you alter their contents. Some calculators also
include drop-down lists and radio buttons. These allow the user to select varios options or settings for the calculator. At
the bottom of each calculator is a hyperlink that when clicked will open your web browser and take you to the CUWCC
website page with information on the BMP's coverage requirement. This will only work if (1) you have a web browser that
Excel recognizes and (2) you have an internet service provider. ANY CHANGES YOU MAKE TO THIS FILE WILL BE LOST
UNLESS YOU SAVE YOUR CHANGES TO THE FILE. SAVE YOUR FILE OFTEN TO AVOIDED UNEXPECTED DATA
LOSS.


Your Agency's Base Year
The calculator for BMP 1 requires you to enter the number of single-family and multi-family housing units for your agency's
Base Year. Similarly, the calculator for BMP 9 requires you to enter the number of CII acounts for your agency's Base
Year. Your agency's Base Year is as follows:

Agencies signing MOU Prior to 1997: Base Year = 1997
Agencies signing MOU After 1997: Base Year = Year Agency Signed MOU

BMP Calculator Instructions
BMP 1
1. Use the spinner to the right of "Year Agency Signed MOU" to set the year your agency signed the MOU. The calculator
will then determine the latest year BMP 1 implementation is expected to commence.
2. Enter the number of single-family and multi-family housing units in your service area for the Base Year.

The calculator will determine the number of surveys your agency is expected to complete within 10 years from the date
implementation is expected to commence. The calculator will also show the number of surveys that must be completed
by each reporting period for your agency to be considered on schedule to meet the coverage requirement within 10 years.

BMP 2
1. Use the spinner to the right of "Year Agency Signed MOU" to set the year your agency signed the MOU. The calculator
will then determine the latest year BMP 2 implementation is expected to commence.
2. Enter the number of single-family and multi-family housing units in your service area constructed prior to 1992.
3. Indicate whether an enforceable ordinance requiring the replacement of high-flow showerheads with low-flow
showerheads is in effect in your agency's service area.
4. Indicate whether your agency has determined that 75% of the single-family and/or multi-family housing units in your
service area are fitted with low-flow showerheads.

The calculator will indicate if and how many low-flow showerheads your agency is required to distribute each reporting period.

BMP 4
1. Use the spinner to the right of "Year Agency Signed MOU" to set the year your agency signed the MOU. The calculator
will then determine the latest year BMP 4 implementation is expected to commence.
2. Enter the number of unmetered accounts in your service area as of the year indicated.

The calculator will determine the minimum number of meter retrofits required each reporting period to be considered on
schedule to meet the coverage requirement in 10 years.

BMP 5
1. Use the spinner to the right of "Year Agency Signed MOU" to set the year your agency signed the MOU. The calculator
will then determine the latest year BMP 5 implementation is expected to commence.
2. Enter the number of CII accounts with dedicated landscape meters as of the year indicated. The calculator will
determine the number of accounts your agency is to provide ETo-based water use budgets by the year indicated.
3. Indicate if agency has program to retrofit mixed-use CII accounts with irrigation meters.
4. Enter the number of CII accounts with mixed-use meters for the year indicated. The calculator will determine the
number of landscape surveys to be offered to these accounts each reporting period, and will calculate the number of
surveys to be completed by each reporting period for your agency to be considered on schedule to meet the coverage
requirement within 10 years.

BMP 9
1. Use the spinner to the right of "Year Agency Signed MOU" to set the year your agency signed the MOU. The calculator
will then determine the latest year BMP 9 implementation is expected to commence.
2. Choose the compliance option and enter the requested data.

This calculator will determine the coverage requirement for each BMP 9 compliance option. NOTE THAT THE MOU
DOES NOT REQUIRE AN AGENCY TO COMPLY WITH BOTH OPTIONS. An agency can select different options for
different CII sectors or to combine the two options for the same sector. THE CALCULATOR ONLY DETERMINES THE
COVERAGE UNDER THE SIMPLE CASE WHERE AN AGENCY SELECTS ONE OR THE OTHER OPTION FOR ALL CII
ACCOUNTS. Clicking the button at the bottom of the calculator will give the user additional information about combining
the coverage options.

BMP 9 - CII ULFT Coverage
This is a prototype calculator based on the draft Exhibit 8. Agencies can use this calculator to determine the implications
of Exhibit 8 as currently proposed. You will need a count of high-flow toilets by CII subsector to use this calculator. Zip-code
level toilet counts by CII subsector can be obtained from the CUWCC for $10 per zip code. You can use the zip-code level
counts to develop a count for your service area. Contact the CUWCC if you require assistance doing this. If you are
providing your own count using Exhibit 8 tables, exclude post-1994 construction. Exhibit 8 assumes CII facilities
constructed after 1994 have ULFTs. If these facilities are included in the count, the calculator will over estimate Total
Savings Potential. Don't adjust the toilet count for natural replacement of toilets between the year of the count and the
year your agency would need to start implementing the BMP. The calculator does this automatically. If you also do it, the
calculator will under estimate Total Savings Potential. Total Savings Potential is based on the ULFT savings estimates
presented in the draft Exhibit 8. Savings for the Retail/Wholesale sector is the average of the savings estimate for retail
establishments and the savings estimate for wholesale establishment. Similarly, savings for the Gov't sector is the average
of the four government sectors listed in Table 5 of Exhibit 8.



BMP 14
1. Use the spinner to the right of "Year Agency Signed MOU" to set the year your agency signed the MOU. The calculator
will then determine the latest year BMP 14 implementation is expected to commence.
2. Indicate whether the calculator should use water savings estimates derived from Exhibit 6 of the MOU or your own
estimates. If you select the "User Supplied" radio button, a dialog box will appear asking you to provide the estimates. If
you later wish to change these estimates, select the "User Supplied" radio button again (even if it is already selected) and
the dialog boxes will appear again.
3. Indicate whether the calculator should use county-average resale rate estimates or user provided estimates. If you select
the "User Supplied" radio button, a dialog box will appear asking you to provide the estimates. If you later wish to change
these estimates, select the "User Supplied" radio button again (even if it is already selected) and the dialog boxes will
appear again. If you select "County Average" you must choose the county using the drop-down list to the right of the radio
button. Estimates are not available for every county. If an estimate is not available for your county, you can choose a
neighboring county or use the state average.
4. Enter the number of single-family and multi-family housing units in your service area constructed prior to 1/1/1992.
5. Enter the annual rate of housing demolition for the pre1992 housing stock.
6. Enter the percent of pre1992 housing units that were constructed before 1/1/1980.
7. Enter the average number of persons per household.
8. Enter the average number of toilets per household.
9. Enter the average rate of toilet replacement, as a percent of the existing stock of high-flow toilets.

The calculator will determine the total acre-feet your ULFT program must save to be considered "At least as effective as" a
Retrofit-On-Resale requirement using the methodology presented in Exhibit 6 of the MOU. A schedule showing the
effectiveness of a Retrofit-On-Resale requirement by year can be printed by clicking the "Print Schedule" button at the
bottom of the calculator.
                            Grey Text
                            BlackText




 14 according to the
 Conservation in




 verage requirement.
 he results, however, can
e requirement within the




ation cells determined
 Some calculators also
s for the calculator. At
 you to the CUWCC
ave a web browser that
THIS FILE WILL BE LOST
 UNEXPECTED DATA




g units for your agency's
your agency's Base




 e MOU. The calculator




0 years from the date
at must be completed
 rement within 10 years.


 e MOU. The calculator
d prior to 1992.
 with low-flow

ousing units in your


bute each reporting period.


 e MOU. The calculator




d to be considered on




 e MOU. The calculator

e calculator will
year indicated.

will determine the
late the number of
 meet the coverage




 e MOU. The calculator




E THAT THE MOU
t different options for
Y DETERMINES THE
 R OPTION FOR ALL CII
 ation about combining




ermine the implications
e this calculator. Zip-code
  n use the zip-code level
 ing this. If you are
es CII facilities
over estimate Total
 of the count and the
  ly. If you also do it, the
 T savings estimates
ngs estimate for retail
 ov't sector is the average




 e MOU. The calculator

 MOU or your own
ovide the estimates. If
s already selected) and

 d estimates. If you select
ou later wish to change
he dialog boxes will
t to the right of the radio
, you can choose a

d prior to 1/1/1992.




At least as effective as" a
 dule showing the
hedule" button at the
            BMP 1 Coverage Calculator                                  Instructions


            Agency Name                                                   Lost Drops MWD


            Year Agency Signed MOU                                                       1995
            Latest Year BMP 1 Implementation to Commence                                 1998

                                                                         Single        Multi
                                                                         Family       Family
                                                                          Units        Units
            Number of Housing Units in Service Area in 1997              200,000      150,000

                                                                         Single        Multi
            Number of surveys Lost Drops MWD is to complete by 2008      Family       Family
                                                                          Units        Units
            Cumulative Total (15% of Base Year Housing Units)             30,000       22,500
            10-Year Annual Average                                          3,000       2,250

            Lost Drops MWD is on schedule to satisfy coverage            Single        Multi
            requirement if it has completed the indicated number of      Family       Family
            surveys for each year shown                                   Units        Units
                                                                2000        3,000       2,250
                                                                2002        7,200       5,400
                                                                2004       12,600       9,450
                                                                2006       19,200      14,400
                                                                2008       27,000      20,250




3/21/2011                                                         CUWCC Coverage Calculator     Version: 5d9f3c2f-333a-4fef-97a3-df64c36145a8.xls
            BMP 2 Coverage Calculator                                     Instructions


            Agency Name                                                         Agency Name


            Year Agency Signed MOU                                                              1991
            Latest Year BMP 2 Implementation to Commence                                        1998

                                                                            Single         Multi
                                                                            Family        Family
                                                                             Units         Units
            Housing Units in Service Area Constructed Before 1/1/1992       200,000       100,000


            Is an Enforceable Retrofit Ordinance in Effect in Service Area?No            No


            Has Agency Demonstrated 75% Saturation?                       No             No


                                                                            Single         Multi
                                                                            Family        Family
                                                                             Units         Units
            Number of low-flow showerheads Agency Name expected
                                                                                20,000        10,000
            to distribute each report period. (10% of Pre1992 Housing)

            Average Annual Number of Showerheads                                10,000         5,000




3/21/2011                                                           CUWCC Coverage Calculator          Version: 5d9f3c2f-333a-4fef-97a3-df64c36145a8.xls
            BMP 4 Coverage Calculator                                    Instructions


            Agency Name                                                      Lost Drops MWD


            Year Agency Signed MOU                                                          1991
            Latest Year BMP 4 Implementation to Commence                                    1999



            Number of Unmetered Accounts as of 1999                                       10,000

            Average Annual Number Retrofits Necessary to Meet Coverage
                                                                                           1,000
            Requirement



            Lost Drops MWD is on schedule to satisfy coverage requirement if it has retrofitted
            the indicated number of unmetered accounts by year indicated

                                                                             2001          1,000
                                                                             2003          2,400
                                                                             2005          4,200
                                                                             2007          6,400
                                                                             2009          9,000




3/21/2011                                                           CUWCC Coverage Calculator      Version: 5d9f3c2f-333a-4fef-97a3-df64c36145a8.xls
            BMP 5 Coverage Calculator                                   Instructions


            Agency Name                                                       Agency Name


            Year Agency Signed MOU                                                           1991
            Latest Year BMP 5 Implementation to Commence                                     1999

            Accounts with Irrigation Meters
            Number of CII Accounts with Dedicated Irrigation Meters in 1997                 4,500


            Number of CII Accounts with Dedicated Irrigation Meters Expected to
                                                                                            4,050
            have ETo-Based Water Use Budgets by 2003


            Accounts with Mixed Use Meters
            Does your agency have a program to retrofit mixed-use accounts with
            dedicated landscape accounts, or a program giving mixed-use accounts       No
            ETo-based budgets for irrigation uses?



            Number of CII Accounts with Mixed Use or No Meter as of 1997                    5,000


            Number of Landscape Water Use Surveys to be Offered Each Report                 1,000
            Period
            Average Annual Number of Landscape Water Use Surveys to be Offered               500


            Agency Name is on schedule to satisfy coverage requirement if it has surveyed the
            indicated number of CII accounts with Mixed-Use Meters or Unmetered by year
            indicated                                                       2001            75
                                                                            2003           180
                                                                            2005           315
                                                                            2007           480
                                                                            2009           675




3/21/2011                                                                         CUWCC Coverage Calculator   Version: 5d9f3c2f-333a-4fef-97a3-df64c36145a8.xls
            BMP 9 Coverage Calculator                                     Instructions


            Agency Name                                                                   Agency Name


            Year Agency Signed MOU                                                                              1991
            Latest Year BMP 9 Implementation to Commence                                                        1999



            CII SURVEY AND INCENTIVE PROGRAM OPTION                        Commercial       Industrial Institutional
                                                                            Accounts        Accounts     Accounts
            Number of CII Accounts in Service Area in 1997                      5,000            3,000        1,000

                                                                           Commercial       Industrial Institutional
            Number of surveys Agency Name is to complete by 2009
                                                                            Accounts        Accounts     Accounts
            Cumulative Total (10% of Base Year Accounts)                         500               300          100
            10-Year Annual Average                                                   50             30            10

            Agency Name is on schedule to satisfy the coverage
                                                                           Commercial       Industrial   Institutional
            requirement for the survey option if it has completed the
                                                                            Accounts        Accounts       Accounts
            shown number of surveys by year indicated
                                                                 2001                50             30            10
                                                                 2003              120              72            24
                                                                 2005              210             126            42
                                                                 2007              320             192            64
                                                                 2009              450             270            90




3/21/2011                                                               CUWCC Coverage Calculator                        Version: 5d9f3c2f-333a-4fef-97a3-df64c36145a8.xls
            BMP 9 Coverage Calculator                                   Instructions

            PERFORMANCE TARGET OPTION

                                   Water Use by CII Accounts in 1997 (AF)                              45,000



            Agency Name is on schedule to satisfy the coverage requirement for the Performance Target Option
            if its CII programs have generated savings (AFY) greater than or equal to the amount shown for the
            year indicated.
                                                                                          2001             450
                                                                                          2003           1,080
                                                                                          2005           1,890
                                                                                          2007           2,880
                                                                                          2009           4,050




3/21/2011                                                           CUWCC Coverage Calculator                    Version: 5d9f3c2f-333a-4fef-97a3-df64c36145a8.xls
            BMP 9 ULFT Coverage Calculator                                                           Instructions


            Agency Name


            Year Agency Signed MOU
            Latest Year CII ULFT Implementation to Commence                                                 2001


            ENTER CII TOILET CENSUS RESULTS

            Year of CII ULFT Census for Agency Service Area                                                 1992

                                                                                                  Number of
            CII Subsector
                                                                                                    Toilets
            Offices
            Retail/Wholesale
            Hotels
            Health
            Other
            Industrial
            Schools: K to 12
            Eating
            Government
            Churches
            Total                                                                                            -


            Estimated Rate of CII Toilet Turnover (percent of remaining stock per year)              4.0%




3/21/2011                                                                                 CUWCC Coverage Calculator   Version: 5d9f3c2f-333a-4fef-97a3-df64c36145a8.xls
            BMP 9 ULFT Coverage Calculator                                                   Instructions


            DETERMINE CII ULFT TOTAL SAVINGS POTENTIAL
            School Subsector Savings (gallons per day per ULFT)   Click for Explanation 18

                                                                                        10-Year Total
                                                                                           Savings
                                                                                       Potential: 2001 -
            CII Subsector                                                                   2010
            Offices                                                                                  -
            Retail/Wholesale                                                                         -
            Hotels                                                                                   -
            Health                                                                                   -
            Other                                                                                    -
            Industrial                                                                               -
            Schools: K to 12                                                                         -
            Eating                                                                                   -
            Government                                                                               -
            Churches                                                                                 -
            Total                                                                                    -

                                              Based on Exhibit 8 Data and Methods.




3/21/2011                                                                       CUWCC Coverage Calculator   Version: 5d9f3c2f-333a-4fef-97a3-df64c36145a8.xls
            BMP 9 ULFT Coverage Calculator                                             Instructions
            CALCULATE CII ULFT COVERAGE REQUIREMENT

            CII ULFT Coverage Requirement (3% of Total Savings Potential)                     -




3/21/2011                                                                   CUWCC Coverage Calculator   Version: 5d9f3c2f-333a-4fef-97a3-df64c36145a8.xls
            BMP 9 ULFT Coverage Calculator                                                      Instructions
            ESTIMATE AVERAGE ANNUAL NUMBER OF TOILET
            INSTALLATIONS TO SATISFY NET COVERAGE REQUIREMENT
            Note: This calculation is based on average savings of 0 gallons per day per ULFT.
            It may be possible to reduce the number of toilets required to meet the coverage by targeting toilets to
            the CII sectors with the highest estimated savings and by installing more toilets early in the program.

                                                                         Avg. # of      Annual      Cumulative
                                                              Program    Installed      Savings       Savings
            INSTRUCTIONS:                                       Year      Toilets        (AF/Yr)       (AF)
            1. Click the button to calculate the                2001             85        0.0          0.0
            average annual number of toilet                     2002             85        0.0          0.0
            installations between 2001 and 2003                 2003             85        0.0          0.0
            needed to satisfy the proposed coverage.            2004                       0.0          0.0
                                                                2005                       0.0          0.0
                       Calculate Table                          2006                       0.0          0.0
                                                                2007                       0.0          0.0
                                                                2008                       0.0          0.0
            2. WARNING: This is an upper-bound estimate of 2009                            0.0          0.0
            the number of toilets your agency would need to     2010                       0.0          0.0
            replace each year. An agency could lower this Total Toilets     255
            number by targeting toilets to those sectors with
            the highest estimated savings and by installing             Cumulative Savings Equals Net Coverage
            more toilets early in the program. Use the table
            below to see how this can be done.

            3-YEAR INTERIM PROGRAM SAVINGS TRACKER

            Use the table below to record the number of toilets replaced in each CII subsector during each year of the 3-year interim program.
            The table will track the cumulative savings and compare it to the coverage requirement schedule. Note, you can also use this table to
            examine how targeting particular CII subsectors or frontloading replacements can reduce the total number of toilets needed to meet
            the interim coverage requirement. By the end of 2003/04 10-Year Cumulative savings need to be greater than or equal to 3.0% of Total




3/21/2011                                                                           CUWCC Coverage Calculator                                   Version: 5d9f3c2f-333a-4fef-97a3-df64c36145a8.xls
            BMP 14 Coverage Calculator                                                                  Instructions


            Agency Name                                                                       Lost Drops MWD


            Year Agency Signed MOU                                                                                1991
            Latest Year BMP 14 Implementation to Commence                                                         1998


              User Selection - ULFT Savings
                        Use Exhibit 6 Estimates             User Supplied


              User Selection - Resale Rate
                         Use County Average STANISLAUS

                         User Supplied                                                    Single        Multi Family
                                                                                        Family Units       Units
            1. Number Housing Units in Service Area Constructed Before
                                                                                                  500             500
            1/1/1992
            2. Estimated annual rate of housing demolition (or conversion)                     0.50%            0.50%

            3. Percent of Pre1992 Housing Units Constructed Prior to 1/1/1980                     50%             50%

            4. Average Number of Persons Per Household                                           3.00             3.00
            5. Average Number of Toilets Per Household                                           2.00             2.00
            6. Average rate of toilet replacement due to toilet failure or remodeling          4.00%            4.00%
            7. Average rate of resale                                                          3.71%            6.24%


            Estimated Housing Units with 3.5+ gpf Toilets in 1998                                 392             392
            Estimated Savings per Housing Unit (gallons per day)                                38.28           54.73


                               Lost Drops MWD Coverage Requirement by 2008 is 75 AF.



            CALCULATE CREDIT FOR AGENCY-ASSISTED ULFT REPLACEMENTS
            OCCURING PRIOR TO ADOPTION OF REVISED BMP 14 IMPLEMENTATION SCHEDULE
            Intructions: Click the button below to create a table that will calculte how much progress your agency has made towards meeting
            the coverage requirement for BMP 14. You will also be able to estimate the number of toilets your agency would need to replace
            in the future to fully satisfy the coverage requirement. Beware, however, that this estimate does not optimize the toilet replacement schedule.




3/21/2011                                                                                                 CUWCC Coverage Calculator                           Version: 5d9f3c2f-333a-4fef-97a3-df64c36145a8.xls
                                                     BMP 14 Coverage Schedule for Lost Drops MWD
                                                                                  Single Family Multi Family
        1992 housing stock                                                                 500           500
        Average rate of natural replacement (% of remaining stock)                        4.0%          4.0%
        Average rate of housing demolition (% of remaining stock)                        0.50%         0.50%
        Estimated Housing Units with 3.5+ gpf Toilets in 1998                              392           392
        Average resale rate                                                               3.7%          6.2% <-- Based on 1996 - 1998 Avg. Resale Rate for STANISLAUS County.
        Average persons per unit                                                          3.00          3.00
        Average toilets per unit                                                          2.00          2.00
        Percent of 1992 housing stock with pre 1980 toilets                                50%           50%
        Average savings per home (gpd)                                                   38.28         54.73 <-- Based on Exhibit 6 Data and Methods

Single Family Units
                                         Retrofit Resale Ordinace In Effect                                      Natural Replacement Only
         Remaining                                               Sold and                        Gross water     Remaining       NOC                        Cumulative
        unretrofitted                               Sold and      already         Unsold and       savings      unretrofitted   Savings        Net Savings Net Savings
 Year       units       Units sold   Units unsold retrofitted    retrofitted       retrofitted      (AFY)           units        (AFY)            (AFY)     (AF)
 1998            392                                                                                     4.64             392        4.64               -              -
 1999            362            14           375            14           -                  15              6             376            5                1               1
 2000            335            14           374            13                1             14              7             361            6                1               2
 2001            310            14           372            12                2             13              8             347            7                2               3
 2002            287            14           370            11                3             12              9             333            7                2               5
 2003            265            14           368            11                4             11             10             320            8                2               8
 2004            245            14           366            10                4             10             11             307            8                3              10
 2005            227            14           364             9                5              9             12             295            9                3              13
 2006            210            14           362             8                6              9             12             283            9                3              16
 2007            194            14           361             8                6              8             13             272           10                3              20
 2008            179            14           359             7                7              7             14             261           10                4              23
 2009            166            14           357             7                7              7             14             251           11                4              27
 2010            153            14           355             6                8              6             15             241           11                4              31
 2011            142            14           354             6                8              6             15             231           12                4              34
 2012            131            14           352             5                8              5             16             222           12                4              38
 2013            121            13           350             5                9              5             16             213           12                4              42
 2014            112            13           348             4                9              5             17             205           13                4              46
 2015            104            13           347             4                9              4             17             196           13                4              50
 2016              96           13           345             4                9              4             17             189           13                4              54
 2017              89           13           343             4               10              4             18             181           14                4              58
 2018              82           13           341             3               10              3             18             174           14                4              62
 2019              76           13           340             3               10              3             18             167           14                4              66
 2020              70           13           338             3               10              3             18             160           15                4              70
 2021              65           13           336             3               10              3             19             154           15                4              74




3/21/2011                                                                                    CUWCC Coverage Calculator                                    Version: 5d9f3c2f-333a-4fef-97a3-df64c36145a8.xls
                                                     BMP 14 Coverage Schedule for Lost Drops MWD
                                                                                  Single Family Multi Family
        1992 housing stock                                                                 500           500
        Average rate of natural replacement (% of remaining stock)                        4.0%          4.0%
        Average rate of housing demolition (% of remaining stock)                        0.50%         0.50%
        Estimated Housing Units with 3.5+ gpf Toilets in 1998                              392           392
        Average resale rate                                                               3.7%          6.2% <-- Based on 1996 - 1998 Avg. Resale Rate for STANISLAUS County.
        Average persons per unit                                                          3.00          3.00
        Average toilets per unit                                                          2.00          2.00
        Percent of 1992 housing stock with pre 1980 toilets                                50%           50%
        Average savings per home (gpd)                                                   38.28         54.73 <-- Based on Exhibit 6 Data and Methods

Multi Family Units
                                         Retrofit Resale Ordinace In Effect                                      Natural Replacement Only
         Remaining                                               Sold and                        Gross water     Remaining       NOC                        Cumulative
        unretrofitted                               Sold and      already         Unsold and       savings      unretrofitted   Savings        Net Savings Net Savings
 Year       units       Units sold   Units unsold retrofitted    retrofitted       retrofitted      (AFY)           units        (AFY)            (AFY)     (AF)
 1998            392                                                                                        7             392            7              -              -
 1999            353            24           366            24           -                  15              9             376            8                1               1
 2000            318            24           364            22                2             13             11             361            9                3               4
 2001            286            24           362            20                4             12             13             347            9                4               8
 2002            258            24           360            18                6             11             15             333           10                5              12
 2003            232            24           358            16                8             10             16             320           11                5              18
 2004            209            24           357            14                9              9             18             307           12                6              24
 2005            188            24           355            13               11              8             19             295           13                7              30
 2006            170            24           353            12               12              7             20             283           13                7              37
 2007            153            23           351            11               13              6             21             272           14                7              45
 2008            137            23           349             9               14              6             22             261           15                8              52
 2009            124            23           348             9               15              5             23             251           15                8              60
 2010            112            23           346             8               15              5             24             241           16                8              68
 2011            100            23           344             7               16              4             24             231           16                8              76
 2012              90           23           343             6               17              4             25             222           17                8              84
 2013              81           23           341             6               17              3             26             213           18                8              92
 2014              73           23           339             5               18              3             26             205           18                8           100
 2015              66           22           337             5               18              3             27             196           19                8           108
 2016              59           22           336             4               18              2             27             189           19                8           116
 2017              54           22           334             4               19              2             27             181           20                8           124
 2018              48           22           332             3               19              2             28             174           20                8           132
 2019              43           22           331             3               19              2             28             167           20                8           139
 2020              39           22           329             3               19              2             28             160           21                7           147
 2021              35           22           327             2               19              1             28             154           21                7           154




3/21/2011                                                                                    CUWCC Coverage Calculator                                    Version: 5d9f3c2f-333a-4fef-97a3-df64c36145a8.xls
                                                    BMP 14 Coverage Schedule for Lost Drops MWD
                                                                               Single Family Multi Family
       1992 housing stock                                                               500           500
       Average rate of natural replacement (% of remaining stock)                      4.0%          4.0%
       Average rate of housing demolition (% of remaining stock)                      0.50%         0.50%
       Estimated Housing Units with 3.5+ gpf Toilets in 1998                            392           392
       Average resale rate                                                             3.7%          6.2% <-- Based on 1996 - 1998 Avg. Resale Rate for STANISLAUS County.
       Average persons per unit                                                        3.00          3.00
       Average toilets per unit                                                        2.00          2.00
       Percent of 1992 housing stock with pre 1980 toilets                              50%           50%
       Average savings per home (gpd)                                                 38.28         54.73 <-- Based on Exhibit 6 Data and Methods
Total Units
                                       Retrofit Resale Ordinace In Effect                                        Natural Replacement Only
        Remaining                                              Sold and                          Gross water     Remaining       NOC                       Cumulative
       unretrofitted                              Sold and      already        Unsold and          savings      unretrofitted   Savings      Net Savings Net Savings
 Year      units       Units sold Units unsold retrofitted     retrofitted      retrofitted         (AFY)           units        (AFY)          (AFY)      (AF)
 1998           784            -           -              -             -                 -                11             784           11            -               -
 1999           715              39        741              39          -                   30             15             753           13               2               2
 2000           653              39        737              35             3                27             18             723           14               4               6
 2001           596              38        734              32             6                25             21             694           16               5              11
 2002           544              38        730              29             9                23             24             666           17               7              18
 2003           497              38        726              27            11                21             26             640           19               8              25
 2004           454              38        723              24            14                19             29             614           20               9              34
 2005           415              38        719              22            16                17             31             590           21               9              44
 2006           379              37        715              20            17                16             33             566           23              10              54
 2007           346              37        712              18            19                14             34             544           24              11              64
 2008           317              37        708              17            20                13             36             522           25              11              75
 2009           290              37        705              15            22                12             37             501           26              11              87
 2010           265              37        701              14            23                11             39             481           27              12              99
 2011           242              37        698              13            24                10             40             462           28              12           110
 2012           222              36        694              11            25                 9             41             444           29              12           122
 2013           203              36        691              10            26                 8             42             426           30              12           134
 2014           185              36        687              10            26                 8             43             409           31              12           146
 2015           170              36        684               9            27                 7             44             393           32              12           158
 2016           155              36        680               8            28                 6             44             377           32              12           170
 2017           142              35        677               7            28                 6             45             362           33              12           182
 2018           130              35        674               7            29                 5             46             348           34              12           194
 2019           119              35        670               6            29                 5             46             334           35              11           205
 2020           109              35        667               5            29                 5             47             321           35              11           216
 2021           100              35        664               5            30                 4             47             308           36              11           228




3/21/2011                                                                                   CUWCC Coverage Calculator                                   Version: 5d9f3c2f-333a-4fef-97a3-df64c36145a8.xls

						
Related docs
Other docs by sge21080
Memorandum Private Security Agency
Views: 34  |  Downloads: 0
Memorandum of Understanding Espada
Views: 1  |  Downloads: 0
Memorandum of Postpone the Class
Views: 77  |  Downloads: 0
Memorandum of Partnership
Views: 37  |  Downloads: 0
Memorandum of Promting Someone
Views: 53  |  Downloads: 0