Wastewater Treatment Plant LCC Example V2007

Document Sample
Wastewater Treatment Plant LCC Example V2007 Powered By Docstoc
					           LIFE CYCLE COST CALCULATOR
                    Version 2007




The Province of Nova Scotia is pleased to provide the attached Life Cycle
Costing Analysis (LCCA) Tool. This was developed in partnership with
Service Nova Scotia and Municipal Relations and the Municipal Finance
Corporation, with the assistance of a large number of Public Works officials
over a two year period.

This Tool is intended for use by Nova Scotia Municipalities to assist in
management of municipal infrastructure capital assets by enhancing long-
term planning and informed decision-making.

Useful application of this software may include:

 comparative review of alternatives
 assist in capital planning/supports decision-making
 identifies real costs
 identifies future cash flow requirements/maintenance budget planning
 support for Federal/Provincial capital financing applications

The third party using this product shall be solely responsible for and shall
save harmless and indemnify Nova Scotia, its Ministers, officers, employees
and agents from and against all claims, liabilities and demands of any kind.
                           Wastewater Treatment Plant Life Cycle Cost Calculator
                                               Version 2007
                                        Last Updated: October 31, 2007
                                         New Town, Nova Scotia
                                             INSTRUCTIONS
                                                   *Warning: New Version Available!*
This spreadsheet-based life cycle costing (LCC) tool is designed to assist municipalities with planning future infrastructure projects. The various worksheet
components of this tool can be accessed using the worksheet tabs located at the bottom of this page or by clicking the buttons on the bottom left of this current
worksheet.


           LCC Tool Legend:                         Value to be entered by user.

                                                    Value calculated based on input data

Please provide the general information requested below.

            PROJECT NAME: Wastewater Treatment Plant                                               *Upon completion of LCCA, please provide a brief
                                                                                                   explanation outlining the source of input data for the
                  LOCATION: New Town, Nova Scotia                                                  operations and maintenance costs provided (i.e.; historical
                                                                                                   costs, industry guidelines, local supplier).*
                DATE & TIME: 8/7/2012 3:11

            COMPLETED BY: PJL

             ORGANIZATION: Dillon Consulting

      TELEPHONE NUMBER: (902) 450-4000

               FAX NUMBER: (902) 450-2008

           CONTACT EMAIL: plewis@dillon.ca



         LCC Results Summary
         LCC Results Summary                        This worksheet provides a one page summary of the input data and LCC results.


              LCC Input Data
              LCC Input Data                        Enter data as required. This is the only worksheet which requires data entry.


                  LCC Help
                  LCC Help                          This worksheet serves as a guidance document for the input data requirements.

       LCC Results Calculator
       LCC Results Calculator                       This worksheet performs the LCC operations and shows the annual output of this calculator.

  PVF and Inflation Factor data
  PVF and Inflation Factor data                     This worksheet computes a Present Value Factor (PVF) and Inflation factor based on historical data.


     Net Present Value Profile
     Net Present Value Profile                      Use this Figure to help interpret the results of the LCC Calculator.


 Annual Present Value Cash Flow
 Annual Present Value Cash Flow                     Use this Figure to help interpret the results of the LCC Calculator.
            Profile
             Profile


          Population Profile
          Population Profile                        Use this Figure to project future population levels
      Wastewater Treatment Plant Life Cycle Cost Calculator
                    New Town, Nova Scotia
                   LCC RESULTS SUMMARY
 GENERAL DATA

 Project Name:                                      Wastewater Treatment Plant
 Location:                                          New Town, Nova Scotia
 Date &Time:                                        8/7/2012 3:11
 Completed by:                                      PJL
 Organization:                                      Dillon Consulting
 Telephone Number:                                  (902) 450-4000
 Fax Number:                                        (902) 450-2008
 Contact email:                                     plewis@dillon.ca

 Year of Construction:                              2013
 Life Cycle Period in years:                        30
 Applicable present value factor (%):               4.64%
 General price inflation factor (%):                2.20%



INVESTMENT DATA

 Installed Capital Cost (Present Day $)             $4,985,200
 Service life of investment in years                30
 Annual Energy costs                                $120,000
 Annual Operations costs (excluding Energy costs)   $132,000
 Annual Maintenance Costs                           $33,000
 Total Non-Annual Replacement or Repair Costs       $100,000



LCC RESULTS SUMMARY

 Net Present Value                                  $10,986,812
 Cost/Benefit Metrics
           NPV/person                               $8,451
           NPV/IGD                                  $3
           Capital Cost/person                      $3,835
                                     Wastewater Treatment Plant Life Cycle Cost Calculator
                                                   New Town, Nova Scotia
                                                      LCC INPUT DATA
PROJECT INFORMATION                                                                                                                                                    Present day
                                                                                                                   Yearly Population Growth or Decline in Percentage
       Year of Construction:                             2013                  2007                                               Year 1 to 5:               2.00%                   2
       Life Cycle Period in years:                                             30                                                Year 5 to 10:              1.00%
       Applicable present value factor (%):                                    4.64%                                            Year 10 to 15:              2.00%

       General price inflation factor (%):                                     2.20%                                            Year 15 to 20:              1.00%
       Plant Capacity (L/D):                                                   3,400,000                                       Year 20 and on:              1.00%
       Population Served by New Infrastructure:                                1,300                                                Comment:



CAPITAL COSTS

                                                                                    Total Cost ($)

   Engineering Design Services:                                                        $600,000


       Building                                                                        $230,000
       Screens                                                                         $10,000
   W astewater Treatment Plant:

   Note: The applicant shall furnish upon request a detailed breakdown of the pre-packaged treatment plant equipment.

                  Treatment Plant Process Equipment                                        $0

   * Please note the opportunity is presented below to highlight major components of the system if preferred.*

   Do not place a lump sum value in the "Treatment Plant Process Equipment" cell above, if you are filling in the form enclosed in this box.

                     Process Equipment

                                             Screens/ Grit Removal Equipment           $270,000

                                             Rotating Biological Contactors            $800,000
                                             Primary Clarifiers                        $350,000
                                             Secondary Clarifiers                      $420,000
                                             Digesters                                 $325,000

                                             Ultraviolet Treatment                     $90,000
                                             Equalization Tank                         $380,000

                                             Other
                                             Other
                                             Other

                     Pumps
                                             Equalization Tank Pumps                   $35,000
                                             Sludge Pumps                              $60,000

                                             Digester Pumps                            $70,000
                                             Other

                                             Other
                     Instrumentation, Controls and Software                            $100,000
                     Miscellaneous Appurtenances                                       $20,000

   Pumping Station:                                                                    $200,000

   Electrical:
                  Process Electrical                                                   $100,000

                  Other                                                                    $0
   Mechanical:
                  HVAC                                                                 $80,000
                  Other                                                                    $0
                                     Wastewater Treatment Plant Life Cycle Cost Calculator
                                                   New Town, Nova Scotia
                                                      LCC INPUT DATA
   Site W orks:

                     Site Access, Grading/ Gravels                              $40,000

                     Fencing                                                    $20,000
                     Site Services                                              $20,000
                     Other                                                        $0

                     Other                                                        $0
   Piping:
                     Yard Piping                                               $150,000
                     Plant Piping                                               $60,000
                     Forcemain Extension                                        $25,000

                     Air Piping                                                 $20,000

                     Water                                                      $10,000
                     Outfall                                                    $25,000
                     Other
                     Other

   Staff Appurtenances:
                     Office                                                     $15,000

                     Washroom Fixtures and Tank                                 $7,000
                     Other
                     Other

   Other
   Other
   Contingency                              10.00%                             $453,200

   Total Capital Costs                                                         $4,985,200



ANNUAL OPERATING COSTS

          Item                                           Total Cost ($)

          Energy                                            $120,000
          Labour                                            $60,000

          Supplies                                          $10,000
          Monitoring and Testing                             $7,000
          Overhead                                           $5,000

          Sludge Disposal                                   $50,000
          Other
          Other

          Total Operating Costs                             $252,000



ANNUAL MAINTENANCE AND REPAIR COSTS
   Item                                              Total Cost per Item ($)

          Building Maintenance                               $1,000
          Process Electrical Maintenance                     $2,000

          Process Mechanical Maintenance                    $30,000
          Other
          Other

   Total Annual Maintenance Costs                           $33,000
                                Wastewater Treatment Plant Life Cycle Cost Calculator
                                              New Town, Nova Scotia
                                                 LCC INPUT DATA

NON-ANNUAL REPLACEMENT OR UPGRADE COSTS


      Items in year X                   Total Replacement       Year Incurred (X)
                                        Cost ($)
1     Other                                      $70,000                   10

2     Other                                        $30,000                 15
3     Other
4     Other

5     Other
6     Other
7     Other

8     Other
9     Other

9     Other
10    Other
11    Other
12    Other
13    Other

14    Other
15    Other
16    Other
17    Other
18    Other

19    Other

20    Other
21    Other
22    Other
23    Other

24    Other
25    Other

      Total                                        $100,000



COST/ BENEFIT METRICS

      Item                              Quantity               Output
      Population                                    1,300      NPV/person

      Plant Capacity (IGD)                         3,400,000   NPV/IGD
      Total Households Served                                  NPV/household

      Population                                    1,300      Capital Cost/person
      Other                                                    NPV/other
      Other                                                    NPV/other
                     Wastewater Treatment Plant Life Cycle Cost Calculator
                                   New Town, Nova Scotia
                                         LCC HELP
                         Item                                                 Help Comment

                                            If the year of construction is less than the current year or greater than the current
Year of Construction
                                            year plus 1, then this value will default to the current year plus one.

                                            Based on the most recent Debenture Interest Rate from the Nova Scotia Municipal
Applicable Present Value Factor (PVF) (%)   Finance Corporation. This number is excerpted from the Interest & Inflation Rate
                                            Data sheet attached.

                                            Based on the Consumer price Index (CPI) averaged over the past five years. This
General Price Inflation Factor (%)
                                            number is excerpted from the Interest & Inflation Rate Data sheet attached.


Capital Cost Total Costs                    This column includes the total lump sum construction costs for each item listed.


                                            Includes supply and install of the all treatment equipment, pumps, I&C work,
Treatment Plant Process Equipment           software, programming, miscellaneous appurtenances and commissioning. Do not
                                            enter a value in this cell if you fill in the detailed input box below this cell.

                                            Includes all costs associated with the supply and installation of the miscellaneous
Miscellaneous Appurtenances
                                            appurtenances such as valves, fittings, etc.

                                            Includes all costs associated with the supply and installation of the building
Building                                    envelope such as substructure/ foundation, superstructure, electrical work, misc.
                                            metals, etc.

                                            This column includes the total annual energy requirements associated with all plant
Energy
                                            operations (i.e. electric and fuel costs).


Labour                                      Includes typical annual operator wages.


                                            Includes typical annual material costs required for operations (administration
Supplies
                                            supplies, oils, grease, etc.)

                                            Includes monitoring and testing programs to ensure the plant is operating within
Monitoring and Testing
                                            applicable effluent water quality parameters.

                                            Such costs include travel, vehicles, safety equipment, telephone, training, etc.
Overhead                                    Includes all costs associated with the upkeep of the exterior property such as
                                            landscaping, repaving, clean-up, fencing and garbage removal.

                                            Includes all preventative maintenance and testing activities, based on the
Process Electrical Maintenance
                                            manufacturer’s recommendations and specifications for equipment.

                                            Includes all preventative maintenance and testing activities, based on the
Process Mechanical Maintenance
                                            manufacturer’s recommendations and specifications for equipment.

                                            Enter the present day value of replacement cost, price will automatically be inflated
Total Replacement Cost ($)
                                            in output.


Year Incurred                               Multiple non-annual replacements are possible within same year.


                                            Any additional cost/benefit measurement metrics added by the user will not be
Other
                                            displayed on the LCC Summary page.

                                            Calculator assumes initial capital expenditure occurs at beginning of year 1 and
Initial Capital Expenditure
                                            cost/payments accrue at end of year.

                                            Includes site investigation, construction management and design services
Engineering Design Services
                                            associated with the new infrastructure.

                                            Please insert the percentage typically used for contingency into the box provided
Contingency
                                            and the contingency will be calculated and added to the total capital costs.
                    Wastewater Treatment Plant Life Cycle Cost Calculator
                                  New Town, Nova Scotia
                                        LCC HELP
                     Item                                                  Help Comment

                                          Please insert the present day population or future population that is to be served by
Population Served                         the new infrastructure. If future population provide information on percentage of
                                          growth in comment box.


                                          Is the expected life span of infrastructure prior to complete replacement. Typical
Life Cycle Period
                                          Wastewater Treatment Plant lifespan is 30-40 years.
                                                                                                    Wastewater Treatment Plant Life Cycle Cost Calculator
                                                                                                                  New Town, Nova Scotia
                                                                                                               LCC RESULTS CALCULATOR
                                                         Project Initiation year                    2013
                                                     Present Value Factor (%)                      4.64%
                                                    General Price Inflation (%)                    2.20%
                                                         Study Period (years)                          30

                               Initial Capital
                                                                                                                                                                                                                                                   Present Value                                 Cumulative Cash Flow
                                Expenditure                                            Annual Fuel or           Annual Maintenance        Replacement Costs
  Year        Population                              Annual Operating Costs                                                                                         Replacement Costs         Cash Flow               Present Value Factor         (Cash Flow             Net Present Value       (without present
                                                                                        Energy Costs                   Costs              (Present Day Value)
                                                                                                                                                                                                                                                     per year)                                       value factor)

          0     1300       $            4,985,200                                                                                                                                         $            4,985,200                      1.0000   $           4,985,200   $             4,985,200   $          4,985,200
2013      1     1326                                  $               132,000      $             120,000    $                33,000   $                      -   $                    -   $              285,000                      0.9557   $             272,362   $             5,257,562   $          5,270,200
2014      2     1353                                  $               134,904      $             122,640    $                33,726   $                      -   $                    -   $              291,270                      0.9133   $             266,011   $             5,523,574   $          5,561,470
2015      3     1380                                  $               137,872      $             125,338    $                34,468   $                      -   $                    -   $              297,678                      0.8728   $             259,809   $             5,783,382   $          5,859,148
2016      4     1407                                  $               140,905      $             128,096    $                35,226   $                      -   $                    -   $              304,227                      0.8341   $             253,750   $             6,037,133   $          6,163,375
2017      5     1435                                  $               144,005      $             130,914    $                36,001   $                      -   $                    -   $              310,920                      0.7971   $             247,833   $             6,284,966   $          6,474,295
2018      6     1450                                  $               147,173      $             133,794    $                36,793   $                      -   $                    -   $              317,760                      0.7618   $             242,054   $             6,527,020   $          6,792,055
2019      7     1464                                  $               150,411      $             136,737    $                37,603   $                      -   $                    -   $              324,751                      0.7280   $             236,410   $             6,763,431   $          7,116,806
2020      8     1479                                  $               153,720      $             139,745    $                38,430   $                      -   $                    -   $              331,895                      0.6957   $             230,898   $             6,994,328   $          7,448,701
2021      9     1494                                  $               157,102      $             142,820    $                39,275   $                      -   $                    -   $              339,197                      0.6648   $             225,513   $             7,219,842   $          7,787,898
2022     10     1509                                  $               160,558      $             145,962    $                40,140   $                 70,000   $               87,018   $              433,677                      0.6354   $             275,543   $             7,495,384   $          8,221,575
2023     11     1539                                  $               164,090      $             149,173    $                41,023   $                      -   $                    -   $              354,286                      0.6072   $             215,119   $             7,710,503   $          8,575,861
2024     12     1569                                  $               167,700      $             152,455    $                41,925   $                      -   $                    -   $              362,080                      0.5803   $             210,103   $             7,920,606   $          8,937,941
2025     13     1601                                  $               171,390      $             155,809    $                42,847   $                      -   $                    -   $              370,046                      0.5545   $             205,204   $             8,125,810   $          9,307,987
2026     14     1633                                  $               175,160      $             159,237    $                43,790   $                      -   $                    -   $              378,187                      0.5299   $             200,419   $             8,326,229   $          9,686,174
2027     15     1666                                  $               179,014      $             162,740    $                44,753   $                 30,000   $               41,580   $              428,087                      0.5064   $             216,803   $             8,543,032   $         10,114,261
2028     16     1682                                  $               182,952      $             166,320    $                45,738   $                      -   $                    -   $              395,010                      0.4840   $             191,181   $             8,734,213   $         10,509,271
2029     17     1699                                  $               186,977      $             169,979    $                46,744   $                      -   $                    -   $              403,700                      0.4625   $             186,723   $             8,920,936   $         10,912,971
2030     18     1716                                  $               191,091      $             173,719    $                47,773   $                      -   $                    -   $              412,582                      0.4420   $             182,369   $             9,103,305   $         11,325,553
2031     19     1733                                  $               195,295      $             177,540    $                48,824   $                      -   $                    -   $              421,659                      0.4224   $             178,116   $             9,281,421   $         11,747,212
2032     20     1750                                  $               199,591      $             181,446    $                49,898   $                      -   $                    -   $              430,935                      0.4037   $             173,963   $             9,455,385   $         12,178,147
2033     21     1768                                  $               203,982      $             185,438    $                50,996   $                      -   $                    -   $              440,416                      0.3858   $             169,907   $             9,625,291   $         12,618,563
2034     22     1786                                  $               208,470      $             189,518    $                52,117   $                      -   $                    -   $              450,105                      0.3687   $             165,945   $             9,791,236   $         13,068,667
2035     23     1804                                  $               213,056      $             193,687    $                53,264   $                      -   $                    -   $              460,007                      0.3523   $             162,075   $             9,953,311   $         13,528,674
2036     24     1822                                  $               217,743      $             197,948    $                54,436   $                      -   $                    -   $              470,127                      0.3367   $             158,296   $            10,111,607   $         13,998,802
2037     25     1840                                  $               222,534      $             202,303    $                55,633   $                      -   $                    -   $              480,470                      0.3218   $             154,605   $            10,266,212   $         14,479,272
2038     26     1858                                  $               227,429      $             206,754    $                56,857   $                      -   $                    -   $              491,040                      0.3075   $             151,000   $            10,417,212   $         14,970,312
2039     27     1877                                  $               232,433      $             211,302    $                58,108   $                      -   $                    -   $              501,843                      0.2939   $             147,479   $            10,564,691   $         15,472,156
2040     28     1896                                  $               237,546      $             215,951    $                59,387   $                      -   $                    -   $              512,884                      0.2808   $             144,040   $            10,708,730   $         15,985,040
2041     29     1914                                  $               242,772      $             220,702    $                60,693   $                      -   $                    -   $              524,167                      0.2684   $             140,681   $            10,849,411   $         16,509,207
2042     30     1934                                  $               248,113      $             225,557    $                62,028   $                      -   $                    -   $              535,699                      0.2565   $             137,401   $            10,986,812   $         17,044,906
2043     31     1953                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.2451   $                 -     -                         -
2044     32     1972                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.2342   $                 -     -                         -
2045     33     1992                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.2239   $                 -     -                         -
2046     34     2012                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.2139   $                 -     -                         -
2047     35     2032                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.2044   $                 -     -                         -
2048     36     2053                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.1954   $                 -     -                         -
2049     37     2073                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.1867   $                 -     -                         -
2050     38     2094                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.1784   $                 -     -                         -
2051     39     2115                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.1705   $                 -     -                         -
2052     40     2136                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.1630   $                 -     -                         -
2053     41     2157                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.1557   $                 -     -                         -
2054     42     2179                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.1488   $                 -     -                         -
2055     43     2201                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.1422   $                 -     -                         -
2056     44     2223                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.1359   $                 -     -                         -
2057     45     2245                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.1299   $                 -     -                         -
2058     46     2267                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.1241   $                 -     -                         -
2059     47     2290                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.1186   $                 -     -                         -
2060     48     2313                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.1134   $                 -     -                         -
2061     49     2336                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.1083   $                 -     -                         -
2062     50     2359                                  $                   -        $                 -      $                   -     $                      -   $                    -   $                    -                      0.1035   $                 -     -                         -

                                                                                                                                                                                                   NPV             $             10,986,812                                           Cost/Benefit Metrics
                                                                                                                                                                                               5 yr life span      $              6,284,966                            NPV/person                                $8,451
                                                                                                                                                                                              10 yr life span      $              7,495,384                            NPV/IGD                                       $3
                                                                                                                                                                                              15 yr life span      $              8,543,032                            NPV/household                     #DIV/0!
                                                                                                                                                                                              20 yr life span      $              9,455,385                            Capital Cost/person                       $3,835
                                                                                                                                                                                              25 yr life span      $             10,266,212                            NPV/other                         #DIV/0!
                                                                                                                                                                                              30 yr life span      $             10,986,812                            NPV/other                         #DIV/0!
                                                                                                                                                                                              35 yr life span      -
                                                                                                                                                                                              40 yr life span      -
                                                                                                                                                                                              45 yr life span      -
                                                                                                                                                                                              50 yr life span      -
Wastewater Treatment Plant Life Cycle Cost
        New Town, Nova Scotia
     INTEREST & INFLATION DATA

Most Recent Debenture Interest Rate   4.64%
(Municipal Finance Corporation)

    Average Inflation Rate
                   Average
     Year        CPI/Inflation
                     Rate
     2002           2.20%
     2003           2.80%
     2004           1.80%
     2005           2.20%
     2006            2.00%
5 Year Average      2.20%
                                  Wastewater Treatment Plant Life Cycle Cost Calculator
                                          Figure 1: Net Present Value Profile

                    $12,000,000                                                           2500




                    $10,000,000
                                                                                          2000



                     $8,000,000
Net Present Value




                                                                                          1500




                                                                                                 Population
                     $6,000,000


                                                                                          1000

                     $4,000,000



                                                                                          500
                     $2,000,000




                            $-                                                            0

                                                                                                          Net Present Value

                                                       Month                                              Population
                                     Wastewater Treatment Plant Life Cycle Cost Calculator
                                       Figure 2: Annual Present Value Cash Flow Profile


                          $300,000
                                           *Note: Initial Capital Expenditure in Year 1 is not displayed on chart.


                          $250,000




                          $200,000
Present Value Cash Flow




                          $150,000




                          $100,000




                           $50,000




                               $-



                                                                       Year
                    Wastewater Treatment Plant Life Cycle Cost Calculator
                                    Figure 3: Population


             2500




             2000




             1500
Population




             1000




              500




                0



                                            Year

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:60
posted:8/7/2012
language:English
pages:14