Home

IWRPS User`s Guide

1. 3 10 ES LAS por H Planning Set 1 Editor y RE H EX wi Pl Po qa E Vi x Import from MS Excel A Excel Spreadshett Browse For Spreadsheet File ki Planning Set Name Planning Set 1 Select an Import Format Import Solutions and Variables Rows are variables columns are solutions C Rows are solutions columns are variables Plan level Import C Rows are plans columns are variables Example of Selected Format 1 Solution Aerate A Dredge D Dredge D 2 Scale 1 1 2 3 TotalCost Ai 101 6 122 7 4 FishHU s 22 Figure 69 Plan Editor Toolbar Components Select Excel Datafile to Import From Look ir E My Documents amp E Size Type 14KE Microsoft Excel worksheet Date Mo 4113 200 My Recent Documents E Desktop My Documents My Computer e My Network File name Places ImportRowsolColar xls hi Excel Spreadsheet ad Lance Figure 70 Select Datafile to Import Files of tupe Section 5 Software Terms and Procedures Import Solutions and Variables Rows are variables columns are solutions An example of an Excel spreadsheet in this format would look like this Figure 71 ES Microsoft Excel ImportRowVarColSol xls File Edit wiew Insert Format Tools Data Aerate Dredge Dredge Scale 1 1 2 ar 101 6 122 7 Zo 24 28 qq ar a a E Figure 71 Row Variables m Rows are solutions columns are var
2. The Intersection report displays all plans that are consistently cost effective or Best Buy plans in each of the planning sets selected For either cost effective or Best Buy plans user selects the report shows the plan combination code the total output total cost and average cost by planning set for each plan The Union report shows all plans that are cost effective or Best Buy plans in any of the selected planning sets For either cost effective or Best Buy plans user selects the report shows for each planning set the plan combination code total output total cost and average cost by plan For Graphs either of two types of results can be selected Intersection and Union m The Intersection graph displays the cost effective or Best Buy plans in common to each of the planning sets selected Since the selected planning sets may use different cost and output parameters the axes are merely labeled y axis variable for the specified cost parameters and x axis variable for the specified output parameters Each plan is plotted by its total cost and total output The Union graph shows all plans that are cost effective or Best Buy plans in any of the selected planning sets Since the selected planning sets may use different cost and output parameters the axes are merely labeled y axis variable for the specified cost parameters and x axis variable for the specified output parameters Each plan is plotted by its total cost and tot
3. In channel Wetlands I 58 Flow Regulation Wetlands F Flow Regulation Wetlands F AND Overbank Wetlands O AND Remove Salt Cedar S Remove Salt Cedar S Remove Salt Cedar S Section 5 Software Terms and Procedures Combinability Relationships Next we will define the combinability relationships Combinability relationships occur between solutions when the implementation of one solution cannot be combined with the implementation of one or more other solutions Click the Combinability relationship type radio button in order to specify non combinable relationships for the solution currently displayed on the form Figure 34 Step 1 And relationships for example A is not combinable with B and C together are entered across rows in the sub form either or relationships are entered using multiple rows The Add button is pressed to add new rows Figure 34 Step 2 However if no solutions are combinable with each other for El Solution Relationships example each solution represents Relationship Type a fully formulated discrete Combinability Dependency C No Solutions are Combinable alternative plan a shortcut to o ls Not Combinable with specifying individual non Flows Regula wetlands low Regulation Wetlands e In channel Wetlands channel Wetlands combinability relationships Op EN Open Water Riparian Corridors Remove Salt Cedar between Solutions is to click on the checkbox in
4. A cannot stand alone and cannot be a plan Similarly if B is only included because of the existence of A then B cannot stand alone as a plan Here only the combination A B is a viable plan In cases where we have mutual dependency it is best to group the two measures together and think of them as a single measure for the purposes of analysis For example in this case we could group management measures A and B together as anew measure C such that Management Measure C Planting amp Irrigating A different type of dependency is where some measure s are dependent upon other measure s but the relationship is not reciprocal We will refer to this type of dependency as path dependency Understanding path dependency relationships can help to assure that time and resources are not wasted evaluating plans that could not be implemented because they fail to meet a dependency path requirement For example consider a case where we have five management measures A B C D and E In this example we must implement A before implementing B if A and B are both present we can then add C Also D must be present before we can add E Recognizing dependency relationships among management measures can assist in screening out plans that are not feasible because they fail to meet dependency requirements when using the all combinations of management measures approach to plan formulation In our example there are 32 possible combinations of the m
5. Excel Planning Set Note that graphs are exportable separately from the graphics export option available by right clicking the mouse on a desired graph Use Export to export a planning set to an Excel spreadsheet file Select Export gt Excel Spreadsheet Figure 80 to display the Excel export dialog Figure 81 Enter the name you would like the spreadsheet file to have and press OK The entire active planning set will be exported to the spreadsheet file Optimize Database Choose File Optimize Database see Figure 83 W IWR Plan Planning Study My Plann ing S tudy from the main menu to de fragment repair and So File Edit view Window Analyze Results E compact existing database files This is an optional operation However periodic compacting repairing of data files is recommended to speed processing times and reduce file sizes Save Os Import Export When selected the database is closed and optimized and the following dialog is shown when optimization is completed see Figure 84 Page Setup Print Preview Print Figure 83 Optimize Database Section 5 Software Terms and Procedures Database Optimized The database Ci Devel ess IWR Plan Wet 2005 PlanEditor bini Debug DatabaselMy Planning Study mdb has been optimized Figure 84 Database Optimized The database is then automatically re opened so that you can continue working in it Page Setup When F
6. i Remove inefficient plans during plan generation a Figure 42 Plan Generator Options This option is of value in cases where numerous solutions and scales have been defined which would result in an extremely large set of solution combinations which may exceed the limits of the database When this option is selected plan generation only saves cost effective plans to the database Further detail on what constitutes a cost effective plan definition may be found in the description of the CE ICA component Constraints Constraints may be defined within the plan editor to filter a planning set to only those plan alternatives that meet a set of predefined criteria The criteria are minimum and maximum acceptable values for a particular variable Note that as in previous versions of IWR Plan constraints may not be applied to derived variables To constrain a planning set a planning set name is entered along with one or more variables to be constrained and a minimum and maximum acceptable value for each variable The application of constraints to a planning set will generate a new planning set containing only the plan alternatives that meet the constraining criteria Constraints can be defined to limit the a planning set s alternatives to only those plan alternatives from a parent planning set that meet the criteria defined by the constraints In defining a constrained planning set the user can select any non derived variables for inclu
7. in lieu of benefit cost analysis the evaluation and ranking of restoration alternatives should be based upon a framework of incremental cost analysis Continually questioning the value of restoration by asking whether an action is worth its cost is the most practical way to decide how much restoration is enough NRC 1992 As an example the National Research Council cites the Corps approach where a justifiable level of output is chosen in recognition of the incremental costs of increasing output levels and as part of a negotiation process with effected interests and other federal agencies NRC 1992 Although cost effectiveness and incremental cost analyses will not like benefit cost analysis usually lead us to a single solution they will at the very least help us make more informed decisions And with some care and thought in interpreting and communicating the results they may help us make better informed decisions In the long term we hope that this will bring about better decisions about today s actions that will effect the environment of future generations Applicability The plan formulation and cost effectiveness and incremental cost analyses procedures in this manual were developed for both restoration and mitigation planning They are useful for a wide range of problem and project sizes and can be used for scoping solutions even at the Section 1 Introduction earliest stages of planning In addition although these procedur
8. report or graph is chosen for display the user will be asked to select the appropriate parameters such as filtering by cost effective plans needed to generate the report or graph Available reports include an average cost report an incremental cost analysis report an Is it worth it report and an All Variables report Graph types include graphs of All Plans cost effective plans and best buy plans All plans and cost effective plans may also be graphed in a differentiated format i e differentiated between non cost effective cost effective and best buy plans The best buy plans graph is viewable as a Cartesian x y coordinates graph as a box graph and other formats including three dimensional visualization graphs Single Planning Set Results Once at least one planning set has been analyzed you may view the analysis results Such results are called Single Planning Set Results Navigate to the Single Planning Set result dialogs by clicking the Single Planning Set toolbar Icon and selecting the Report option to generate reports of analysis results or the Graph option to graph analysis results Figure 57 15 IWR Plan Planning Study Salt River CEICA Analysis 6 CE ICA mef a l File Edit view Window Analyze Results Generator Help amp xX may y El CEICA Analysis 6 CE ICA vil con Es A Es T E Graph Y ane Effec y Plan of Int Y yi Name Y Cost
9. 3 fo fo ma oo ot se Ja as ofa races 62 e o p mees ETS EI CO o e os tor 975 e o ern oo Figure 26 Scaled Solution Effects on Variables Data Entry Table A 53 Section 5 Software Terms and Procedures Table 9 below defines the solutions and scales that are used in this case study Repeat the procedure above for the 28 remaining solution scales now 54 TABLE 9 SOLUTIONS AND EFFECTS CW Open Costs Wetlands Riparian Water Code Description 1000 AAHU s AAHU s AAHU s No Action i O O F 1 lAs STO 2 100 Acres F 3 i 50Acres aj _ 10 0 O 0 No Action 0 0 0 1 5 Acres 2125 0 2 75Aces 62 6875 0 3 100Acres TT 0 W 4 400 Acres 722 0 0 260 pot 0 NoAction _ 0f 0 0 I 1 1t0Acres S 1088 0 I 2 240Aces 8S 26 0 1 3 360Acres D e ee ae ee ee l 4 480 Acres a 2 O I 5 600Acres IO ET Section 5 Software Terms and Procedures Note that specific solutions may be filtered for ease of data entry To select which solutions will appear in the data entry editing matrix Figure 27 click on the Funnel shaped Filter Icon Solutions and Scales Solutions Solution Code Scales Overbank Wetlands OVERBANE Rene Stal e ae ET 1 CIN Scaled Solution Effects on Variables Code hd Scale Y Name Tr Costs We Wetlands nese T vee vr All Mo Acton gt a E e C CIR CIA CES Ank an BO me
10. Computing Incremental Cost Per Unit Note Figures 5 6 and 7 refer to the incremental cost incremental output and incremental cost per unit respectively of Solution B While saying these incremental values correspond to one solution simplifies the discussion the incremental values in these formulas actually apply to the decision to implement Solution B over Solution A Examining the changes in incremental cost per unit across solutions is in other words examining how the cost per unit or average cost of incremental output changes as the level of output changes Returning again to the pond example the incremental cost per unit of the 50 acre ponds is 7 500 per habitat unit based on the following calculation 1 75 000 cost of 50 acre pond 7 1 00 000 cost of 40 acre pond 75 000 7 500 HU 10 HU 30 HU output of 50 acre pond 20 HU output of 40 acre pond This tells us that the 10 extra habitat units that the 50 acre pond can provide over the 20 units provided by the 40 acre pond cost 7 500 each Using the average cost equation in Figure 4 we find that the 20 habitat units provided by the 40 acre pond cost 5 000 each This information tells us that we can get the first 20 habitat units for 5 000 each if we want more we can get 10 additional units but those will cost 7 500 each Now we have our cost and output data ina format that facilitates answering the is it worth it question Specifically are 20 habitat unit
11. EE N E E TEAS TINEST 29 Solution 1 Diurnal Flow Regulation Wetlands oonconnccnocanocanocnnonnconnconncnnnonnnnrnnnconncnnccnnncrnncrnos 29 Solution 2 Overbank Wetland cccccsecccssccceccccecccessccescccccccsccceucccescccsceneseceucceeeccesecensseeuess 29 Solution 3 Remove Salt Cedars from River Channel c cccccccsecccccecccccccccccccaccccascceaeseens 30 Solution 4 Cottonwood Willow Riparian Corridors 0 ces eeseeseeceseeeeseceeeesseeeseeeeeeesaeeeseeens 30 Solution 5 Create Open Water Areas in River Chanel ee ceeeeseecsseeeseeceseeeseeeeeeesaeeeseeens 30 Solution 6 Create Riverine and Fringe Wetlands Within River Channel eee 31 Costsianda UPS E da 31 A ii Contents Section o Software Termsan d Procedures nac 35 cs A Pee ye renner mr ces eer ee mE Un erm aren sere Teeny 35 E AEE aici h cee ren T ter ere ene Den err N O N en errr Tm ren weet re rer 35 E A n E E A E 36 Parotid renne a r T a teases 36 Pan Alternative Varia e camenee etree N E N S 37 PARAE A EN OF ADULTES A o base Ne eee ee Becca meen ec tlesea ae eceics Seca Meee 37 Distinguishing between a variable and an attribute 00 eee eeeeesecereeeeeeseeeseeesesseeeeeeaeenaes 37 PATIO LV CARV ONY SU 38 A entre Ae errr N ieee nr ee a ee 38 Pan G ener A dons atc sanaa cescpertcasehaay 39 A E EE EEE EAE E EEEE EAE 40 Opemne O least TE E EEA 40 Creatine a New Flan StU oh eee e N A eee E 42 Wotane WPNE SES i ion 43 Remoyme Platine
12. Ele E E El El El E E E E E E J CO at ay OOO td ey a Ca 0 Copa Gry ory Al af mop my Gay ody ae te PA E ESTE E Seek SL CER SE Sep El sty Oy oy ee Ol ey ey Ol Ol OlO Ol Ol Ol Ol Cr C9 09 Ga Ga CO Co G9 CA Ga CO CO 09 CO Go CO eI So co cy ee oy oy ey ey Ol ey ey Ol Ol Ol Ol ho Se es es I olol J 2 oO o ola SE EE Ts Oo ro Dj Co CA o s s Po oo a Solutions and 193 Planz Os Seales 117 3072004 Figure 10 Plan Generator Toolbar Components Use Software Procedures Opening the Plan Editor You will be working within the IWR Planning Suite Plan Editor throughout the example scenario The Plan Editor maintains a Plan Study containing planning sets and all IWR Planning Suite functions are performed within Plan Studies To open the plan editor click on the Windows Start button to open up the Start Menu with your name listed at the top of the menu see Figure 11 Recycle Bin e Jonathon Planni h Internet Internet Explorer E me Microsoft Office Outl a MSN gt Windows Media Playe 3 Windows Messenger Tour Windows XP Snaglt 6 por All Programs E New Office Document 53 Open Office Document Program Updates Set Program Access and Defaults Windows Catalog Windows Update T Accessories A Dell Dell Accessories mm Games E Lotus SmartSuite T Microsoft Office Microsoft Office Too
13. However attribute values may be different for a particular plan alternative in any planning set in a plan study For example Plan A s Cost Effective attribute may be Yes in one planning set and No in another because different analysis parameters may have been used to generate the two planning sets Application Suite IWR Planning Suite is an Application Suite of software Components It is composed of the base Plan Editor component to which other components can be readily added or removed The modular plug and play ability to add or remove new components without re installing IWR Planning Suite lends itself to a more flexible architecture where you can pick and choose the modules that suit your needs Current modules include a Plan Editor Component which includes CE ICA analysis and reporting and a Plan Generator Component A Multi Criteria Decision Matrix MCDM module is being developed along with new reporting and graphing capabilities New modules are easy to add to IWR Planning Suite as needed All of the functionality of all modules is dynamically integrated into and available from within the Plan Editor multi document interface MDI window Plan Editor The Plan Editor is a Windows based MDI Multiple Document Interface application It is the Frame for other components Other modules such as the Plan Generator can be Plugged Into it and enabled or disabled at will by the user The plan editor a
14. IWR Plan Planning Study Salt River Generated Set 2 Generated AE a te L File Edit View Window Analyze Results Generator Help nan a Le a e E E FIOOR4AST OS ode 364 rh 0 1321 W Figure 47 Plan of Interest Checkbox yy To find a particular plan to mark as of interest in a large planning set select the Custom filter by clicking on the filter icon of the plan name in the plan editor table and enter the name of the plan to find and press OK see Figure 48 Wi IWR Plan Planning Study Salt River Generated Set 2 Generated gl File Edit view Window Analyze Results Generator Help F YA T aa e A Y Name Y Costs v Wetlands Y CWRiparia Y OpenWatev TotalQutp Y Plan of Interev a Custom gt FODROS O OID pial Generated Set 2 Generated Y Figure 48 Custom Filter Sensitivity Sensitivity values can be entered at one of two levels variable sensitivity and solution sensitivity Variable sensitivity allows the user to enter uniform coefficients for computing all high and low values for a given variable for example evaluate all cost estimates by 20 Variable sensitivity is a function of the Plan Editor module and can be changed by clicking on the Variable Sensitivity icon on the tool bar see Figure 49 i IWR Plan Planning Study Salt River Generated Set 2 Generated gL File Edit view Window Analyze Results Generator Help E Viele TL Name Y Costs Y
15. Once this set of all possible plans TABLE 3 ALL COMBINATIONS OF MANAGEMENT MEASURES with shading over plans which do not meet dependency path requirements A AE ABD CDE III II VI VAR C BD ACD ABCE O o gt e e E CD ADE ACDE Section 2 Plan Formulation has been identified they can be evaluated using the cost effectiveness and incremental cost analyses procedures The results of plan formulation management measures alternative plans and programs must be both output friendly you can estimate what outcomes or outputs you get from it and cost friendly you can also estimate its costs What s an Output As we use it in this manual the term output means an intended beneficial nonmonetary effect Cost effectiveness and incremental cost analyses examine how output levels and their respective costs vary across different solutions An output is the means by which we measure how well we achieve a planning objective Usually we identify one type of output for each objective For example you may decide to measure progress in restoring a wetland in terms of changes in its habitat quality and quantity In some cases it may be important to look at more than one aspect of an objective and therefore you may use multiple outputs for a single objective for example habitat quality and the presence of a keystone species In addition if your study is addressing more than one planning objective then yo
16. Section 5 Software Terme and Procedures Plan Studies To open the plan editor click on the 2 Software Terminology Windows Start button to open up the Start Menu QE Software Procedures with your name listed at the top of the menu E 2 Opening the Plan Editor 7 Creating Few Plan Study F working with Planning Sets E Costs and Outputs Lg File Menu Extras AA f k f f E f Em Si EA A E i a A A AA 4 31422006 Figure 95 IWR Plan Help Section 5 Software Terms and Procedures IWR Planning Suite Help System The Help menu also includes a Help About dialog providing version release and system information that can be accessed by selecting About IWR Planning Suite from the Help Menu Figure 96 98 About IWR Planning Suite iene A EEE 0 dd PEMA TA ya at e Shae TERNIS ii 3 ENAN y ni j gt Mos Aas Chink Ed y y LoS US Ar i As ads of E ae Aet hakk E E E A eee la Mer TY ja y HA l phd UPME dy SBA Ty ai TA Yo Lip Sti E AAA la 4 Figure 96 The Help About Dialog Appendix Glossary Appendix 100 Glossary Attribute Derived Variable Plan alternative Planning set Plan study schema Planning study Scale Scenario Sensitivity Solution Variable Appendix A value or hierarchical structure of values associated with a plan alternative which identifies a characteristic of the entire alternative In IWR
17. TGN enaa a cia 60 Figure 37 Defining Automated Editing Functions ocooccnocnocnnonconananonncononononnonanonnonn cnn nonnona non ncnn cnn ncnnonns 61 Piguite os Generate Plans COM iii aa 64 HetresoGenerate lan Dial 64 Hetire 40 Generate l lan rOetess Dak sisas 65 Pered Generator Men DIO iaa dto 65 Figure 42 Plan Generator O Ou OMs sit dan 66 Figure 45 Constraints Dialog nd 67 Figures Pour CAs Constante Coni 67 Figure do Constrained plantines tii teen aee 67 Bt Fe AG Plat SEU yO nda di ion lada 68 Pioure A Plan Or interest Checkbox aiian n a E A E 69 Figure 46 Custom Fiter andara 69 Hietire 49 SOlLULOM Sens ICO ES A TERE 69 Pip ure o0 V aria ble sensitiva CON A AAA AA 70 Eretire Ol Vanable Sensitivities POr adi dsndy decane 70 Figure 52 Soluti ns Sensitivities COST CLONES iia iii iestessaiistaanaieoasianveuusageientonneielannatende 71 Peur oo He Men losicinnao coa acaiaata 12 Pieure o4 Save Plan Std AS neryo e ba e e 73 Mete CECA Generated Tanning elude A 74 Figure 56 CE ICA Analysis Output arameo 75 BiGUre o7 oinele Tanning Set Reportar 76 Fie ures Selecting Report Iy De usar lia 77 Figure os Selec Graph OPHION ona anin R EAE T A E OR 78 Pigure 60 Selectine Graph Vy De acacia SR 78 Heure or Grae 91 0 Font Data a A A 79 FiIeure 62 Cost Elective Pins Graphicsin a a 79 Piere 09 Be ct ob Vil gt lt a Sra to EN A EEE 80 Figure od Plan Bortor TOO Dal iaa aan 80 Figure 65 Display Appropriate Graph or Report ooconnccnnocinoncno
18. Wetland Y CWRiparr T penwWa Y TotalOutp Y Plan of Interest Y a Figure 49 Variable Sensitivity Icon wi Generated Set 2 Generated Y Solution sensitivity allows the user to enter uniform coefficients for computing all high and low values for a given variable and solution combination for example evaluate all cost estimates A 69 Section 5 Software Terms and Procedures for the solution dredging at 20 but all cost estimates for the solution aquatic plant harvesting at 40 Solution sensitivity is a function of the Plan Generator module and can be changed by clicking on the Solution Sensitivity icon on the tool bar see Figure 50 iM IWR Plan Planning Study Salt River Generated Set 2 Generated L File Edit View Window Analyze Results Generator Help eee man ay x Y Es EE Generated Set 2 Generated W FEA y M El NA atl Name vy Costs Y Wetland Y CWRipar Y OpenWat Y TotalOutp Y Plan ofin ENTE ET E Fr EEE pn cr Figure 50 Solution Sensitivity Icon Variable Sensitivity For variable sensitivity the high and low variable values entered are uniform coefficients used for computing the high and low values for the selected variable This creates a value range result for that variable If Variable Sensitivities is selected the Variable Sensitivities form will be opened Figure 51 Next you will enter uniform coefficients for computing all high and low values for the correspo
19. and feeding sites for several Neo tropical migratory species of birds Another sign of the degraded ecosystem is the virtual disappearance of riverine wetlands and open water areas within the study area Again due to reduced surface water flows the open water sections of the channel have been reduced to a few seasonal pools a loss of approximately 600 acres while approximately 400 acres of former riverine and fringe wetlands in the floodplain have dried up Much of the former river channel and riverine wetlands have been replaced by exposed rock cobble and sand The loss of these ecosystems has resulted in the loss of habitat for such aquatic and wetland species as the snail darter leopard frog and blue heron Section 4 Case Study Yet another manifestation of the degraded ecological conditions in the study area is the rampant erowth of an exotic tree species called salt cedar Salt cedar a salt and drought tolerant invasive species has thrived in dry Salt River riverbed out competing and in many areas replacing native vegetation The leaves of salt cedar trees exude a noxious compound that upon decomposition in the soil increases the salinity of the soil thereby inhibiting the growth of other plant species Stands of salt cedar therefore tend to be dense and monotypic providing very low habitat values for native birds and mammals In addition to their negative impacts on habitat quality the density and roughness of salt cedar fo
20. creates a value range result for that solution When a planning set is then generated to the plan study hidden high and low value variables are added for each variable of each plan alternative in the generated planning set When the Solution Sensitivity icon is clicked the Solution Sensitivity dialog will be opened Figure 52 Solution Sensitivity Solution Sensitivity Coeficiente C Solution Y Variable Y Low Coefficient 4 High Coefficient r Fy Flow Regulation Wetlands O Overbark Wetlands fts O Overbark Wetlands Weter EIC EN E EIC ECN O o p e Remesi wei Td F Faran Conis toss CO E EEE wees O E EOS a E EC O ICE fes E o oew wees IS o DIET fewn oo oo wf OrenWater__ Orenwate o o rowe fe ooo o DECI EE IN o DECI IN O E T iechannelWatinds a cnet A PEF Figure 52 Solution Sensitivity Coefficients Section 5 Software Terms and Procedures Through this dialog you may enter uniform coefficients for computing all high and low values for any and every given variable and solution combination As with variable coefficients low coefficients must always be a real number less than or equal to one including negative numbers and high coefficients must be a real number greater than or equal to 1 Once the coefficients have been defined click the OK button will save the coefficients Figure 52 Clicking the Cancel button will discard any changes and close the form For this case study two variable and solu
21. dilemma Many of our nation s valued watersheds ecosystems and habitats are degraded or threatened At the same time dwindling budgets at all levels of government are forcing some hard choices about how tax dollars can best be invested When it comes to making decisions about how to invest limited dollars in solving increasingly critical problems decision makers must answer some very tough questions How much can we afford to invest in an environmental project Is it worth potentially doubling a project s cost for example to get a small increase in environmental benefits What level of environmental benefits is worth it Traditional benefit cost analysis is not enough or even useful in answering many of these kinds of questions While the costs of environmental investments can still be measured in dollars there is no universally acceptable method to measure environmental benefits using a single metric dollars or otherwise However other tools such as cost effectiveness and incremental cost analyses can be used to give decision makers better information in making such choices Purpose of Manual This manual was developed to serve as a practical guide for applying and interpreting cost effectiveness and incremental cost analyses in environmental planning It describes the analyses data requirements step by step instructions for conducting the analyses examples of the analyses application in different planning settings decision mak
22. e CI CIA CI rowrea A Cae e DA rea a eene o fo fe fo w E fo oie Si on Figure 27 Data Entry Edit Matrix above the Code Header and select the solutions you would like to display Figure 28 After all desired Solutions have been selected click on the OK Button and the selected solutions will populate the data entry editing matrix Enter filter criteria for Code Operator Operand And conditions to FLOWREG v O Or conditions E guals to w OVERBANK J Add a condition Cancel Code FLOWREG OR Code OYERBANK Figure 28 Filter Criteria For Code Section 5 Software Terms and Procedures This does not delete any Solution or any associated effects data from the database it simply will not appear in the data entry editing matrix on the Solutions and Effects form until the filter is turned off by selecting All from the filter icon combo box Solutions and Scales At this point solutions may be added or deleted by Solutions clicking the Add button on the Solutions and Scales form TE Figure 25 or selecting a solution and pressing the Delete key on your keyboard Deleting will display a Overban IIA confirmation dialog as shown in Figure 29 Clicking Yes sd ARO Choose Yes to delete the row or No to ext will delete the solution and clicking No will cancel the action Code FLOWREG 0 No Action 0 FLOWREG 5 Scales may be added to or removed from a solution by entering a new number
23. for applicable solution and scale combinations Next we will define automated edits Clicking the Automated Edits Icon on the Main Menu Toolbar Figure 35 will open the Automated Editing form Figure 36 1 IWR Plan Planning Study Salt River Planning Set 1 a l File Edit view Window Analyze Results Generator Help 77 aV Oe KF gale Y Costs Y Wetlands v CW Riparian v TET e ee Figure 35 Automated Edits Icon i a Automated E dis Mame Conditions Function Ke Costiaving FLOWREG Or INCHANM NPFLOWREG MINE ren Figure 36 Automated Editing The automated editing feature allows users to automatically account for the fact that all plan effects may not be additive IWR Planning Suite s default assumption when individual 60 Section 5 Software Terms and Procedures solutions are combined Alternatively the user has the ability to edit the effects of plan combinations manually on a plan by plan basis directly within the Plan Editor planning set table Automated editing can make the editing process more efficient and time saving by enabling the user to specify multiple non additive effects when the edit can be described by some logical statement such as When solution A and solution B are combined reduce the sum of the cost of A B by 1000 These edits to account for non additive effects will take place as plan combinations are being built To perform an automated edi
24. in the Scales column of the Solutions table of the Solutions and Scales dialog Figure 30 Figure 29 Confirmation Dialog Solutions Solution Code H Scales F Flow Regulation Wetlands FLUWREL d 7 Fiaien Cordos RIPARIAN fe eee eee 1 ee A Cf TC HAM Figure 30 Solutions Table If the Delete action was selected deleted scale s will no longer appear on the Solutions and Scales form Solution Relationships The set of rules regarding which solution and scale combinations are dependent upon one another also known as dependency relationships may be defined as appropriate before plan generation These relationships occur between solutions when the implementation of one solution is dependent on the implementation of one or more other solutions Dependencies are entered by stating the dependent solution and the set of solutions upon which it depends The rules for defining combinability relationships between solutions may also be defined as appropriate Such relationships occur between solutions when the implementation of one solution cannot be combined with the implementation of other solutions Combinability is declared by selecting the solution and selecting those solutions with which it is not combinable 56 A Section 5 Software Terms and Procedures Dependency and combinability relationships may be defined at this time by clicking the Relationships Icon on the Plan Editor Toolbar Figure 31 This will open
25. of 2003 a complete redesign to incorporate desired features and new technologies was initiated culminating in the current IWR Planning Suite This newly redesigned IWR Planning Suite encapsulates the following fundamental design concepts One concept is to consider plan descriptions as discrete entities as opposed to the concept of a plan alternative solely as a derived aspect of a set of solution combinations The planning set editor and plan descriptions database represent this concept Yet another fundamental modification of the tool structure is a move from a single application to a modular approach consisting of an integrated suite of component modules Such modules include a plan editor plan generator reporting tools and analysis modules These concepts are further explained in Section 5 of this User s Guide in Software terms and Procedures Section 2 Plan Formulation Let us assume that a planning investigation has been initiated concerning for example the degradation of a particular floodplain s ecosystem Various problems and potential opportunities have been characterized and identified during the initial stages of the investigation The objectives of the investigation and the constraints that are imposed upon it have been derived from the characterized problems and opportunities Further during the investigation s information gathering process the historic existing and future conditions of the site have been evaluated
26. of an exotic species which allows it to be replaced with higher value native species These wetlands riparian and open water areas provide habitat for a variety of aquatic wetland terrestrial and bird species Rather than attempting to measure ecosystem outputs on a species by species basis the interdisciplinary study team in this case decided to quantify outputs in terms of the acres and quality of those acres for each cover type or habitat produced by each solution The output categories were therefore defined as wetland habitat cottonwood willow riparian habitat and open water habitat The quality of these habitat types was estimated by the biologists on the study team using available ecological models and best professional judgment Quality Index values of 0 0 to 1 0 similar to Habitat Suitability Index HSI values were estimated for each parcel of cover type to describe its overall quality for a variety of species habitats under without project and with project conditions Table 5 displays the acreage of various cover types produced by each of the solutions and scales as well as the difference in Quality Index values between without project and with project conditions i e the Quality Index value shown is the improvement or lift in habitat quality effected by implementation of a given solution These quality index values were then multiplied by the acreage of each cover type restored or created to provide a quantity and quality m
27. planning study or Cancel to stop the import and avoid overwriting the current IWR Planning Suite data file Import from IWR Planning Suite Version 3 33 To import previously saved IWR Planning Suite data files created with the previous version of IWR Planning Suite Version 3 in Version 4 of IWR Planning Suite go to File on the main menu bar and Select Import gt IWR Planning Suite Version 3 Figure 77 iM IWR Plan Planning Study My Plann ing tudy Planning Set 1 a File Edit View Window Analyze Results Generator Help ev tee ifs i Save AS Export b Optimize Database Page Setup Print Preview Print Figure 77 Import from IWR Plan Version 3 Select the folder in which the old data files are located then click on Open Select the appropriate file to convert and then click on Open again IWR Planning Suite will import variables solutions and scaled effects from the old IWR Planning Suite database The dialog Select IWR Planning Suite Version 3 33 Database for Import will display Navigate to the appropriate database and press the Open button to import data from that database into IWR Planning Suite version 4 88 A Section 5 Software Terms and Procedures Select IWR PLAN Version 3 33 Database For Import Look in 6 Data do ai Bussey mdb My Recent Documents Desktop My Documents My Computer Places Files of type Access Databa
28. properties dialog The costs and outputs associated with the study are determined and defined These variables are the categories used for comparative purposes during analysis For example if a given planning set was to be used as input data for subsequent CE ICA analyses then a cost and an output variable would need to be defined for that planning set Variables are defined with a variable name description and unit of measure Additional types of variables would be needed for other kinds of analyses such as multi variable efficiency analysis To define these variables navigate to the Variables form by selecting the Planning Study icon as shown in Figure 20 H IWR Plan Planning Study Planning Study 1 Planning Set 1 Editor BL File Edit view Window Analyze Results Generator Help f x AAV Fee KE 2 eee awe Planning Set 1 Editor v Wan Planning Study Cost Y Output TE E Eo a m l Figure 20 Planning Study Icon This will open the Planning Study form Figure 21 which contains a Variables data entry table to allow for the addition modification and deletion of variables Initially this form displays default Cost and Output variables for your use These default variables can be removed or renamed at your discretion to suit the needs of a particular Planning Study As variables are defined they will be added to the collection of variables and will be available for review or modificati
29. report type may display For example the Average Cost report by default displays All Plans but checking the appropriate Filter By checkbox can allow you to report only on Cost Effective Plans or Best Buy Plans Once all of the desired options have been set clicking the OK button will display the report Graph Single Planning Set Results Navigate to the Single Planning Set graphing dialog by clicking the Single Planning Set toolbar Icon and selecting the Graph option to graph analysis results Figure 59 A 77 Section 5 Software Terms and Procedures 8 IWR Plan Planning Study Salt River CEICA Analysis 6 CE ICA a l File Edit view Window Analyze Results Generator Help E c CEICA Analysis 6 CEJICA 7i Man BREA A Man hj MLT Name Y Costs Y Wetlan Y CWRiparv Open Y Cost Effecv Plan of Int v7 a Fa02R0S0WV0l 146 163 75 0 0 E FIOSROSOWOl 147 125 0 0 E Figure 59 Selecting Graph Option The first step in selecting a graph to view is to specify which analysis planning set to graph To do this select the desired planning set from the Report on dropdown list Figure 60 Next the user must specify which type of graph to view by clicking the corresponding Graph Type For some reports the user may also select a subset of analysis results to graph by clicking appropriate options in the Plan Alternatives to Graph group For some reports the Differentiated checkbox ma
30. required to be entered and can be made up of any combination of alphanumeric or punctuation characters up to 15 characters in length Enter Costs in the space provided for the variable s name now The description field describes the variable throughout the IWR Planning Suite specifically in reporting This field can be up to 50 characters in length Enter Average Annual Equivalent Cost in the space provided for the description now The units field or units of measure is a quantitative representation of the unit used for each variable and can be up to 15 characters in length Enter 1000 in the space provided for units The derived checkbox will determine if this variable is a derived variable or not A Derived Variable is a formulaic combination of two or more other variables already entered into the database Derived Variables will be discussed later in this section You may leave the Hidden checkbox unmarked for all of the variables you will be entering It is highly recommended that the optional fields units and description be defined as they will be used throughout the IWR Planning Suite in reports and graphs To add more variables Section 5 Software Terms and Procedures simply click the Add button and repeat the procedure above The table below describes the four variables used in this case study TABLE 7 VARIABLE NAMES DESCRIPTIONS AND UNITS Variable Name Description _ _ _ Unit
31. s values and the constant of 0 indicates that no additional constant will be added to the solutions values thereby adhering to the program s additive assumption To edit the default function the user can change the coefficients as appropriate by clicking in the Coefficient column and typing in a new value and can change the constant as appropriate by clicking in the Constant field and typing in a new value Solution values are multiplied by coefficients to divide a solution value a decimal coefficient lt 1 must be used in the Coefficient column Similarly constants are added to solution values to subtract a constant a negative value must be typed in the Constant field For this edit group all the solution coefficients remain as 1 however we will add a constant of 800 As described above this will actually subtract 800 from the combination of solutions values 5 Conditions Not required but usually necessary In this field the user specifies under what conditions i e where the editing function is to be performed on the variable to be edited The default function that first appears in the Where field is under all conditions or for all action plan combinations Unless you want the automated edit function to be applied to all plan combinations you will need to change the statement in this field To change the Where conditions first click on the Clear button to delete the default statement in the
32. the Dependency and Combinability Relationships form Figure 32 A IWR Plan Planning Study Salt River Planning Set 1 aH File Edit view Window Analyze Results Generator Help Figure 31 Plan Editor Toolbar Solution Relationships Relationship Type Combinability C Dependency C No Solutions are Combinable Solution ls Mot Combinable with Flow Regulation Wetlands Flow Regulation Wetlands n channel Wetlands k channel Wetlands pen Water Open Water Overbank Wetlands Riparian Corridors Riparian Corridors Remove Salt Cedar Remove Salt Cedar Solution Is Not Combinable With Mame r Relationship r Pe Overbank We Flow Regulation Wetlands add Figure 32 Relationship Form Dependencies First we will define dependency relationships Dependency relationships occur between solutions when the implementation of one solution is dependent on the implementation of one or more other solutions Click the Dependency radio button under the Relationship Type group A 57 Section 5 Software Terms and Procedures box in order to specify dependency relationships for the solution currently displayed on the form Figure 33 Step 1 And relationships for example A is dependent on B AND C are entered across rows in the table either or relationships are entered using multiple rows While a default dependency row is provided for your first row subsequent rows are defined by
33. them in context For example planning sets will include the name A 63 Section 5 Software Terms and Procedures of the planning study to which they belong They will also include the name and version of the component and function that created them Examples of the created by attribute of a planning set might be IWR Planning Suite Planning Set Generator Component 1 0 Plan Editor 1 0 Manual Entry or Plan Editor 1 0 Constraint Group To generate plans click on the Generate Plans Icon in the toolbar Figure 38 18 IWR Plan Planning Study Salt River Generated Set 2 Generated Seles BL File Edit view Window Analyze Results Generator Help Y ol ste chy PA Y OpenWat v TotalQutp Y CEA Figure 38 Generate Plans Icon This will bring up the Generate Planning Set dialog Generate Planning Set Planning Set Name Generated Set E Description Generated planning set generated from a set of solution and scale combinations Created By Exclude Solutions Solution Sensitivity Flow Regulation Wetlands Low Overbank Wetlands Riparian Corridors Expected Remove Salt Cedar Open Water High L Hig n channel Wetlands Figure 39 Generate Plan Dialog You may take the default settings of this dialog and just press OK and plans will be generated You may if you wish define the planning set s name description solution sensitivities to be generated and any solutions you w
34. Down Output 663 5 Cost 604 400 600 S00 Output Figure 61 Graph Point Data EE Planning Set Graph Planning Set CEICA Analysis 6 Cost and Output All Plan Alternatives Differentiated by Cost Effectiveness Q J Cost Effective Best Buy Figure 62 Cost Effective Plans Graph 79 Section 5 Software Terms and Procedures The Incremental Cost Box Graph option allows the user to display the Best Buy plans see Figure 63 resulting from incremental cost analyses ES Planning Set Graph Planning Set Bussey Lake CEICA Incremental Cost and Output Best Buy Plan Alternatives S amp we ta TITTAT rtm IFTTT TTT IFTTT Incremental Cost Per Unit w Choose an Incremental Cost Graph View i C Default Multicolor Grayscale Print Close Figure 63 Best Buy Box Graph Multiple Planning Set Results Reporting may be performed across multiple planning sets An intersection report will display all plans that are cost effective or best buy plans in common to the various planning sets selected A union report shows all plans that are cost effective or best buy in any one of the selected planning sets Intersection and union graphs will also be available for viewing similar in graphical representation to the text reports just described When at least two CE ICA analysis planning sets have been processed you may view the result
35. Economic and Environmental Principles and Guidelines for Water and Related Land Resources Implementation Studies U S Water Resources Council 1983 referred to as the P amp G The P amp G provides the instructions and rules for Federal water resource planning The P amp G require that in developing alternative plans Federal planners should include only increments that provide net NED National Economic Development benefits for flood damage reduction navigation and other traditional benefit categories Increments that do not provide net NED benefits may be included if they are cost effective For environmental planning where traditional benefit cost analysis is not possible because costs and benefits are expressed in different units cost effectiveness and incremental cost analyses offer plan evaluation approaches that are consistent with the P amp G paradigm Cost effectiveness analysis is conducted to ensure that the least cost plan alternative is identified for each possible level of environmental output and that for any level of investment the maximum level of output is identified Subsequent incremental cost analysis of the cost effective plans is conducted to reveal changes in costs as output levels are increased Section 1 Introduction In the absence of a common measurement unit for comparing the non monetary benefits with the monetary costs of environmental plans cost effectiveness and incremental cost analyses are valuable
36. Planning Suite a text label with a textual or numeric value associated with it A variable associated with a plan alternative and described by formulae applied to component variables Mathematical functions are applied to component variables to define a derived variable A set of one or more management measures activities of particular scales Comprised to address planning objectives Any group of plan alternatives A named set of variable and attribute definitions held in common by a planning study Within IWR Planning Suite describes a particular planning study The plan alternatives and analysis results maintained in planning sets used to evaluate candidate plans for a specific planning task A related group of planning sets derived from a common set of plan alternatives A discrete feature magnitude or level of activity applied to a solution A specific analysis to be performed upon a planning set or the results of that analysis A basic method of indicating the analytic uncertainty of a plan alternative variable through the mechanism of assigning low and high values to describe the variable s value as a range A feature or activity that can be implemented to address one or more planning objectives A planning task management measure One of the constituent components of a plan alternative A category used for comparative purposes during analysis A representation of the combined measures of a study such as
37. Riparian Corridors G 104 Riparian Corridors S _ 15 O E In Channel Wetlands In Channel Wetlands 6 6 In Channel Wetlands BLO PO A Go PO A Co PO al EL AM ET A E e ajA P W N 33 Section 4 Case Study 34 Section 5 Software Terms and Procedures The following sections describe terminology and procedures for using the IWR Planning Suite software Software Terminology IWR Planning Suite uses terms that have specific meanings within the context of the application to refer to various aspects of the planning process and to refer to different entities associated with the planning investigation Commonly used terms you will need to know in order to easily work through the example follow These include such concepts as m Plan Alternatives m Planning Sets m Plan Studies m Variables and Attributes Application Suite m Plan Editor m Plan Generator There is also a glossary at the end of this guide which may be used as a quick reference for many common terms Plan Alternative A Plan Alternative which may just be referred to as a plan or an alternative is a set of one or more solutions activities of particular scales Plan alternatives are created to address planning objectives Each plan has a cost and one or more resulting outputs Within IWR Planning Suite a plan consists of a plan name a set of variables and a set of attributes Plan alternatives are discrete entiti
38. Set Parent set Created By Parameters Parameter FF VWanable Y For Y Value Y es Figure 16 Planning Set Properties Dialog In the case of an imported planning set file an example would be Imported Planning Set myplanningset xls If the planning set were generated from the active planning set by an analysis module or by a constraint group the parent planning set would be the name of the active planning set For example if a constraint is defined and performed on the planning set base plans the new planning set generated for example constrained plan 1 would have a parent set value of base plans You will be able to determine the contextual meaning of a planning set from this information whether it is an initially generated plan a scenario variation on that plan or the results of an analysis Removing Planning Sets Planning sets other than the default Plan Editor planning set may be deleted or removed from the plan study by clicking the Delete Planning Set icon of the toolbar see Figure 17 or as an item under the main menu View menu H IWR Plan Planning Set 1 0 File Edit view Window Analyze Results Generator Help El Planning Set 1 Name Y Figure 17 Delete Planning Set Icon 44 a LOST e Section 5 Software Terms and Procedures This will cause the Delete Planning Set dialog to appear Figure 18 Delete Plan
39. Sets nasales 44 Cost and OUP LES eies a e is 45 Derived Variables pi 49 Solutions dnd Scaled Edecanes a nacsausesys Guat oi i e E i a 50 SOON Cla ONS ID a er UE COCER EE E R 56 Automated ENC GO sosu E AT a E 99 Pan oh 9 Co ers 1 0 19 eaten ee errr E en are ee nr reer eee eee rere 63 Meticient Elan Removal asa et rrer E E erree err 65 CO ISLE ALTIUS asc is 66 Plane Or DETE S pee eee eet o la di 68 ENS ASA A AAA AAA 69 SAVE A A da 72 AnaS RESUS POS POCO 0 E E a E E e e me 75 FIeMenu Eria cenne e 82 POV A E E E E E EE A E EE E EE E EE E EE E E aemtcemamtems 82 Djo E a PAE AAA AAA Ai 83 A O 83 DVS ANA 83 IMPOR 83 Export la SS e A A A E ry er a 90 Opinie ir A A A O 91 Base et srta ett 92 ON 93 O A 94 PA sa 99 E EME O 95 Nimndows Menta A E T torr ener a toetenrerery ce 96 Help MET ee A E E E E E E O E E EE a 97 WR Plannine Suite Help Sy Sten tics scisc aca she esnt sat A a ad 98 Appendix GOSS SAE iran EA AAT 99 List of Figures Figure 1 Examples of Typical Cost Effectiveness and Incremental Cost Graphs eee 3 Figure 2 Economic Analysis Decision Making ToolS conncnncnoconoconononancnnanononanonncnnaranonnonn crono e 4 Figure 3 Computing the Total Cost of a Plan Alternative oo eee eseeseceseeseeseeeseeaeesseeseeeeeaeens 21 PICUTE 4 Compune average COSE eiie E cdo 23 Figure Computne Inecremental COSt isscxcicasitenies ida iii bosuanenieiaeusasansodoiesen ealeaemeenic 24 Figure Computne Incrementa OU 24 Pietire Computn
40. T Wetiend an Figure 23 Adding Derived Variables Section 5 Software Terms and Procedures The Formula Editor contains a blank field in which the user defines the derived variable Figure 23 Step 3 The user cannot type information manually into the field rather the user must select by clicking numbers operators functions and variables in sequence to define the derived variable formulation Figure 23 Step 3 Add a new variable by pressing the Variables table Add button For the Name enter TotalOutput Enter AAHU and Total output of all habitat variables as the unit and description Now proceed to click on the derived checkbox for the variable and click in the following field with the header Derived in order to enable the ellipses button Click on this button step 2 Enter the variable formula for TotalOutput now by using the sub form At this point the user can click on the Validate button to confirm that the formula is logically valid from a mathematical perspective not a scientific one Alternatively when the user clicks OK on the Formula Editor dialog the WR Planning Suite will automatically check validate the derived variable for logical consistency Note that since the values of derived variables are not entered by the user but rather are calculated directly by the IWR Planning Suite derived variables do not appear in the Effects on Variables columns on the Solutions and Sc
41. Through this process the problems and opportunities have become more fully and accurately described as have the costs of various alternatives protected resources and other items deemed relevant to the investigation At a relatively early stage it will be possible to formulate plans and perform analyses which can then be fed back into another more detailed iteration of the planning cycle The specifics of the information needed to initially proceed with plan formulation and evaluation vary with each investigation but will always include at least three kinds of data needed to formulate and evaluate plans These types of information are 1 Solutions 2 The output of each solution and 3 The cost of each solution This chapter provides an overview of solutions outputs and costs and discusses how output and cost data can be manipulated to extract the types of information needed to support decision making What s a Solution A solution is a way to achieve in whole or in part one or more planning objectives Every solution will provide some level of output at some cost Cost effectiveness and incremental cost analyses examine the different cost and output levels provided by different solutions Solution is an umbrella term for three more familiar terms management measure alternative plan and program Throughout the remainder of this text whenever we use the term solution 1t implies that the discussion applies to measures p
42. U S Army Corps of Engineers Institute for Water Resources IWR Planning Suite User s Guide November 2006 Views opinion and or findings contained in this report are those of the author s and should not be construed as an official Department of the Army position policy or decision unless so designated by other official documentation Microsoft Windows MS DOS Access Excel NET XML Visual Basic Visual Studio Visual C and Visual C are either registered trademarks or trademarks of Microsoft Corporation in the United States and or other countries 2002 Microsoft Corporation All rights reserved This case study is for informational purposes only MICROSOFT MAKES NO WARRANTIES EXPRESS OR IMPLIED IN THIS SUMMARY Microsoft Visual Studio and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and or other countries The names of actual companies and products mentioned herein may be the trademarks of their respective owners IWR Planning Suite User s Guide by Cory Rogers and Michael Robinson CDM 1050 North Reed Station Road Suite D Carbondale IL 62902 618 351 4530 and L Leigh Skaggs and Shana Heisey U S Army Corps of Engineers Institute for Water Resources Casey Building 7701 Telegraph Road Alexandria VA 22315 3868 703 428 9068 November 2006 Contents OCS PP acedats ob hay halos E N O V o E AEP ET E AASE A EAN EO AA AT L EAN I TA EEEE
43. Where field Then double click on the appropriate solution code in the Solution Description box to insert that solution code into the Where condition field Next choose a Boolean operator AND or OR NOT may be used in conjunction with AND or OR by clicking on the appropriate button to place that operator after the first solution code in the Where condition statement Next select another solution code by double clicking on the appropriate code to place it in the Where field statement Repeat this process of selecting solution codes and Boolean operators until the desired conditions appropriate to the automated edit function are specified in the Where field Use the parentheses buttons as appropriate In defining Where condition statements those specified within parentheses are performed first Operations are performed in the following order of precedence NOT statements first followed by AND statements then OR statements If you make a mistake use the backspace button lt to delete the preceding term or use the Clear button to start over Click on the Validate button to validate the logical consistency of the Where condition statement The IWR Planning Suite will automatically verify the validity of the Where condition statement when the user presses OK to close the Automated Edits form For this edit group the where condition is INCHANNEL And OPENWATER Enter this now by pressing the Clear button then enteri
44. al output A 81 Section 5 Software Terms and Procedures ES IWR Planning Suite Multi Planning Set Graphs Multiple Planning Set Graph Intersection A a CEICA Analysis 6 CEICA Analysis 7 ac ES Les Figure 66 Multi scenario Graph The other option in the Options group box the user must specify is the selection of either the Cost Effective or Best Buy subset as the result set to view Finally clicking the OK button will display JB the appropriate multi planning set graph or report E L An example multi planning set graph is shown L File Edit View Window Analyze Resul Save As File Menu Extras El IWR Planning Suite provides many additional features that can be found under the File menu Mes Figure 67 Import Export Optimize Database Page Setup New Use File New Figure 67 to create a new IWR Planning Suite database and planning study The current study will be saved and closed and a new empty default database will be created for you to FOOORSSOWO 37 0 begin working in You may choose to start entering Print Preview Print Figure 67 File Menu Extras 82 A Section 5 Software Terms and Procedures data manually through the plan editor or import data from another source Open Use File Open Figure 67 to open an existing IWR Planning Suite database and planning study A
45. ales form Derived variables are automatically calculated by the program and can be selected as either Cost or Output Parameters to conduct cost effectiveness and incremental cost analyses To see the calculated values of derived variables for a planning set select the Planning Set in the Planning Sets combo box in the Plan Editor Derived variables are labeled as such and their values are displayed Solutions and Scaled Effects The next step in performing incremental cost analyses is to define solutions and their effects on each variable Solutions and their scaled effects are defined through a Solutions and Scales dialog see Figure 24 for the icon on the toolbar A solution is a management measure or activity and there usually are many levels or sizes for a given solution These different solution sizes are the scales at which the solution can be implemented A solution description solution code and a number of action scales for the solution are entered to define each solution and scale W IWR Plan Planning Study Salt River Planning Set 1 Editor aO File Edit view Window Analyze Results Generator Help El 2 a i pS y Mar E Y yt Name Y Costs Y Wetlands Y CWRiparian Y No Action Plan 0 0 0 0 0 Man y a ee wa Planning Set 1 Editor Y l Solutions and Scales otalOutput Y Figure 24 Solutions and Scales Dialog Solutions and scales may be added edited or deleted t
46. an easily change the active planning set to another planning set at any time allowing a variety of planning sets to be operated on simultaneously Plan Study A Plan Study or Planning Study refers to a single database or data file in IWR Planning Suite It is a related group of planning sets derived from a common set of plan alternatives It contains all of the plan alternatives and analysis results used to evaluate candidate plans for a specific planning task In some cases it may be considered to represent the plan formulation and analysis portion of the planning investigation In other cases it may represent one portion or one iteration of these parts of a particular planning investigation 36 A Section 5 Software Terms and Procedures Plan Alternative Variable A Plan Alternative Variable is a category used for comparative purposes in analyses A variable describes some characteristic of the alternatives or management measures comprising those alternatives in a planning study Some examples of variables are cost output habitat units and other effects Variables are the constituent components of derived variables A Derived Variable is a variable the value of which has been derived via a user defined mathematical formula from the values of other variables in the plan alternative Derived variables are described by formulae applied to component variables Mathematical functions such as the additive multiplicati
47. anagement measures A E However many of these possible combinations are not functionally feasible because they violate the dependency requirements Table 3 includes all combinations with shading over those plans that are not feasible because they do not meet dependency path requirements Out of the initial 32 possible plans only 12 meet dependency path requirements and are functionally feasible 16 A Section 2 Plan Formulation Situations may arise where we are faced with either or dependencies Either or dependencies occur when a common measure may be added to more than one dependency path For example consider that on a common plot of land we have two measures G to plant one type of vegetation and T to plant a second type of vegetation Assume that we could plant either alone or both in combination If we were to add to either G or T or both planting measures a new measure F to fertilize we would then put the same measure in two dependency paths Now we can add measure F fertilize if either G or T is present Similarly F could be added if both G and T are present In this case we might only incur the cost of fertilizing once but the effect of fertilizing on the planting may vary depending upon whether one or two types of planting are being affected In such cases the potential for improper estimates either of cost output or both is high In situations where either or dependencies occur between management measures
48. and would also improve the channel s capability to handle and pass flood flows It was determined that removing all 1 000 acres would be required to effect any significant improvement in the local ecosystem Complete removal would prevent the rapid re population of salt cedar stands which is able to out compete native species due to its tolerance for high salt concentrations in the soil Therefore only 1 scale would be considered for this solution This solution is required before any of the other solutions involving re vegetation of native species can be considered i e solutions 4 5 and 6 are dependent on solution 3 No specific outputs are associated with the removal of salt cedar per se Rather this solution is a pre requisite to the implementation of solutions 4 6 and the associated riparian open water and wetland habitats they would provide Solution 4 Cottonwood Willow Riparian Corridors These 500 to 1 000 yard long corridors of planted cottonwood and willow trees would extend southwesterly from outflow points along the overbank wetlands extending down the river bank toward the river channel itself Water from the wetlands would feed excavated shallow ditches descending in elevation toward the river with the banks along both sides of the ditches planted with cottonwood and willow trees and native bushes Surface water and groundwater flow through the trench corridors would provide the required quantity of soil moisture to support tr
49. annual equivalent amount by economists presented in 1000 in Table 4 below TABLE 4 COSTS OF SOLUTIONS AND SCALES enema ste toni om Number Solution Description Scale Number Scale Acres Costs 1 000 Flow Regulation Wetlands pT eel Wetang JO Flow Regulation Wetlands _ _ 3 J Oo 849 Overbank Wetlands ST Overbank Wetlands 82 Overbank Wetlands 00S Overbank Wetlands 5 aoo Remove Salt Cedar 008480 Riparian Corridors tT Riparian Corridors _ _ 2 _ _ ___27 Riparian Corridors___________ __3___ _____4 370 Riparian Corridors 4489 Riparian Corridors tO 560 Riparian Corridors eH Open Water 002150 Open Water 2008780 Open Water 800577 Open Water _4 0 7220 In channel Wetlands e887 In channel Wetlands 8158 In channel Wetlands 8D 4200 In channel Wetlands___________ __4___ ____480Y 593 6 _ In channel Wetlands TO SSCS e Note Costs are expressed on an average annual equivalent basis iat al O0O N AJO0O N 4 _ a 6 6 6 oye Section 4 Case Study In this study the outputs of the proposed solutions are the changes in ecosystem values derived from the habitats produced by each solution Some of the solutions use treated wastewater as a water source to produce wetlands and riparian habitats Other solutions yield open water and wetlands habitats in the river channel while another involves removal of a low quality habitat associated with monotypic stands
50. arious reports and graphics as well as to differentiate and keep track of different plan studies it is useful to define plan studies with meaningful names Enter CombinedOutput in the space provided for the plan study name now The final step in saving a plan study is confirming the new name by clicking the Save button Click the Save button to confirm this name now Figure 54 Note if the Cancel button is clicked no new plan study will be added Save Plan Study As lal PlanningStudy 1 mdb Al SaltRiver mdb My Recent 2l SaltRiver_PG mdb Documents E Desktop My Documents ds My Computer z My Network File name CombinedO utput mdb ha Places save as type Access Databases Cancel Figure 54 Save Plan Study As Once a new plan study has been added using the Save As the new plan study will be displayed in the Plan Study properties form CE ICA Analysis Cost Effectiveness and Incremental Cost Analysis is described in detail in Section II Plan Analysis Here is an overview of how it is applied within the IWR Planning Suite application Cost Effectiveness is a method of identifying least cost solutions for different levels of outputs or benefits It is utilized in planning situations where dollar values are not used to measure outputs In the absence of economic valuation of effects then it can lead to more informed and supportable decisions than might cost oblivious decision making In a planning set co
51. at a particular stream site you could create a calm slackwater area by either excavating the channel or by constructing a dam across the channel you can do one or the other at the same site m Function where two different measures may work against one another For example at Site A it probably would not make sense to both build a retaining dike to hold water at the site and install drains to speed the removal of water from the site m Nested measures where one measure is actually a smaller scale or a subset of another measure For example you could not combine a 4 acre wetland with a 5 acre wetland to produce a 9 acre wetland if the two wetlands are not physically separate and any part of the 4 acres is physically included or nested in the 5 acres While measures may or may not be combinable alternative plans are mutually exclusive within a single planning study and decision makers must ultimately select one plan Within a single study selection of a plan will preclude the selection of any other plan However at the program level alternative plans or projects may or may not be mutually exclusive Again it is the property of combinability that at the program level allows us to develop different total programs based on different mixes of plans or projects In addition to being combinable many measures may be dependent on other measures in order to be implemented Dependency relationships between two measures
52. ated W F A Name Y Costs v Wetlands v CWRiparia y OpenWate Y TotalOutp v Plan of Interev a F302R0S0WOI0 146 183 75 0 0 FIO3ROSOWAOIO 147 125 0 0 Figure 55 CE ICA Generated Planning Set The description field is an optional field that allows the user to give a better description of the Plan Study Note that the description can be up to 50 characters in length Enter CE ICA run 74 A Section 5 Software Terms and Procedures on Combined Output of All Cover Types in the space provided for the Plan Study description now Figure 56 The cost parameter field is a drop down list populated with the defined variables IWR Planning Suite will use the selected cost variable as the Y axis variable for all analyses The cost parameter is what is used in all cost effectiveness and incremental cost calculations Select Cost as the cost parameter now As with the cost parameter the output parameter field is a drop down list populated with the defined variables IWR Planning Suite will use the selected variable as the X axis variable for all analyses The output parameter is also used in all cost effectiveness and incremental cost incremental cost per unit of output calculations Select TotalOutput as the output parameter now Figure 56 Perform CEFICA Analysis Name CEICA Analysis 6 Description CECA run on Combined Output of All Cover Types Parent set Created By LEICA Analysis Y arlablez Lost Costs Out
53. ble opportunities to consider new and different solutions that deliver more for less Herein you will find detailed step by step instructions in the procedures encoded into the software program Understanding the procedures and the examples presented in the following chapters will assist analysts in achieving a comfort level with applying the analyses History and Background Benefit cost analysis incremental cost analysis and cost effectiveness analysis have long been integral to Federal water resources planning Requirements for these types of economics based analyses can be traced from the first Federal guidance in the Green Book 1950 1958 through Senate Document 97 1962 to the Principles and Standards 1973 1980 Traditionally these requirements have focused on projects monetary costs and monetary benefits Cost effectiveness analysis has been used to identify the least costly means to achieve a range of project benefits subsequent incremental cost analysis has been used to scale project size by judging whether increasing economic benefits are worth their additional costs The evolution of economic analyses in Federal water resources planning was paralleled by the development of requirements and technologies for environmental evaluation As the nation s first comprehensive environmental legislation the National Environmental Policy Act of 1969 mandated in Section 102 2 B All agencies of the Federal Government shall ide
54. combination of two or more other variables already entered into the database Within a derived variable formula other variables may be added subtracted multiplied divided or raised to a power Square roots natural logs and absolute values may also be performed Derived variables are also added to the planning study through the plan study properties dialog and described in terms of a variable name description measurement units and a calculation formula To indicate that a variable is a derived variable if the planning study properties dialog has been closed re open the plan study properties dialog by clicking the planning study properties toolbar icon Clicking on the Derived checkbox on a variable s row Figure 23 Step 1 will mark the checkbox and enable the ellipses button in the Derived Function field Clicking on the ellipses button will cause the Formula Editor to appear with which to define the formula for computing a derived variable Figure 23 Step 3 ad Planning Study a Editor Variables ies EE Name w Units W Descripti P lt z a Derived Wer Derived Funchon w Hidden Costs 1000 Average Annual a Equ id all oran Open Water Habia No A r Taba OE W A wetlands Tes er re Editor Derived Variable e TotalOutput w etlande CWR iparian 0 penWater o L Valdtted Select Variables eee IO EE S p Cost Effective iE Cw Riparian me 0 e ay aa
55. cost and output The constituent components of a derived variable 101
56. ction scales now Figure 25 Step 3 This scale will also be used in the plan code automatically generated by the Plan Generator module to represent which scale of action is being administered Take the plan F204R0S1W2I14 for example the F represents the Flow Regulation Wetlands solutions Solutions and Scales Solutions Solution H Scales Flow Regulation Wetlands Pp Overbank Wetlands Scaled Solution Effects on Yarables Mame Wr Costs Wer CWhRipantan Wer OpernVfater Wr Wetlands O T O e Fe fo CI E PTE CI o TE CO EMI O CI CI o oew CI CI PETT CI ME Figure 25 Solutions And Scales Form A 91 Section 5 Software Terms and Procedures Considering the example plan above the F2 portion indicates that the second action scale for Flow Regulation Wetlands is being used for this alternative plan Once a solution or set of solutions are entered clicking the OK button will validate and save the new solutions Figure 25 Step 5 If the OK button is not clicked the solutions are not saved The Cancel button will close the form Figure 25 Table 8 below represents the solutions that are used in this case study The first solution has just been defined for Flow Regulation Wetlands Enter the five remaining solutions now Note that up to 52 solutions can be defined per data file Up to 20 scales including No Action can be defined per solution TABLE 8 SOLUTIONS Solution Description Number o
57. dobe POF Status ESE Mame HP Lasenet 4050 Seres PS Properties Type HP LaserJet 4050 Series FS Where Comment S5naglt 6 Network Microsoft Office Document Image Writer Microsoft Office Live Meeting Document writer Figure 87 Page Setup Printer Selection Print Preview The File Print Preview option see Figure 88 displays a preview of how the current planning set will appear when it is printed out to the selected printer IWR Plan Planning Study Planning Study 8 a File Edit Import Export wiew Window Analyze Results shad Save Os Optimize Database Figure 88 Print Preview 93 Section 5 Software Terms and Procedures The Print preview dialog see Figure 89 allows the user to then print the planning set to the printer to zoom in on the print image or to select several different single or multi page views of the printed planning set Pressing the Close button will close the preview dialog without printing the planning set EN Print preview j Hame Ma Acian Plan Figure 89 Print Preview Dialog Print Selecting File Print will print the current planning set to the default printer or to the printer that has been defined through the File Page Setup dialog During the printing process the page being printed will be displayed in a dialog with the option to cancel the printing process see Figure 90 Prin
58. e Ineremental Cost Per Unit screwed italia it 25 Fre ure o Sample ody ATCA cdo oo ios ia it clica 28 Pisure 9 Plan Editor Toolbar Components valid 39 Fig re 10 Plan Editor Toolbar components Use ia 40 Pieure Li Opening Tie 1Wk Plants Suite ld 41 Prise 2 IWR Default Rania DEt eitea irai E Ai aicia 41 Figure 13 Creatine A New Stel y Ea nesi E 42 Pore TEN ew eN aE oa A 43 Pigure 15 Plannine Set Properties OPON usaran 43 Figure 16 Plannin Sets roperues DIO iia 44 Moure t7 Delete Panning etico in 44 Figure 18 Delete Planning Set Dalai dida 45 Foure 19 Rlaname set Removal Dial eoir ornar a 45 Prietire 20 Blantine study CON as sai 46 Figure 21 Plannine Study POLI qsiiiaa iaa tico 47 Figure 22 Delete conima onnenn a A 48 Moure 2 Addino Derived Varna ole A TT 49 Pic ure 24 Solutions and Scales Dial susra a aaa E TTA 50 FPICUTE 29 SOU tons And Scales PF OLIN serino ne T E O an s 51 Figure 26 Scaled Solution Effects on Variables Data Entry Table on ooconncnicincninononnononanconcnnnnnncnnonos 53 Houte 27 Data Eni y EA Mat A A AN 55 Pipures 29 Merc iternd FOr C odesa N O T AR 55 Fewe29 CO Tire Tey OTL Diallo S a A E ar deabian a aseacdece 56 PISULE S0 oou ons able aliadas 56 heures Han Editor Tool Akene en ta 57 Pie uresa Relations Mp TO ees A T A A A 97 Hibur oy solution Relationships adi a e T 58 Figure 34 Combina y Rela HOSS seipi a E AS E A ca iyesdeaeued 59 Figure op Automated Bits 16On citeinuisusie e A a aad 60 PIO ULE 90 Attomeated E
59. e proposed ecosystem restoration solutions make use of the wastewater treatment plant outflow The individual sites and management measures explained below can be employed individually or in combination with each other to contribute to ecosystem restoration Solution 1 Diurnal Flow Regulation Wetlands Diurnal flow regulation wetlands would be created on the north bank of the Salt River and just west and downstream from the treatment plan outfall They would be constructed at bank level above the 100 year floodplain A pump would be required to move water from the wastewater treatment plant outflow discharge to the wetlands site The wetlands would help to control and attenuate the diurnal pulses of water released from the plant evening out the flows to more closely emulate a natural system The wetlands would help to polish the effluent thereby further improving water quality as well as creating valuable habitat for the Yuma clapper rail blue heron and other bird species It was estimated that a minimum of 50 acres would be required to handle and regulate the flow from the treatment plant Therefore 50 acres was considered the minimum scale for this solution However land is available to accommodate larger areas of diurnal flow regulation wetlands these could be built linearly and further west of the initial 50 acre site Larger wetland acreages of 100 and 150 acres would therefore be considered corresponding to scales 2 and 3 of this f
60. e selected and modified to change the individual values of a specific plan alternative in the planning set In other words values may be typed directly in each cell of the new row to enter the values for the plan attribute Individual plan alternatives may also be inserted into or removed from the active planning set Plan Generator The Plan Generator is a wholly separate module which runs fully integrated within the IWR Planning Suite Editor It uses the previously described Solutions and Scales approach to plan generation to generate planning sets which may then be subjected to analysis A diagram of the various toolbar components of the Plan Generator and their use is shown below Figure 10 You may use it as a quick reference while going through the example scenario below A 39 Section 5 Software Terms and Procedures Solutions And Scales Solution Sensitivity EJ IWR Plan Planning Study Bussey Lake Study Bussey Lake Plans Generated E Dx A File Edit View Window Analyze Results Generator Help a a a Ef E m o A 1 i a T AA oY ARREA Ela Solutions and Scales jourpur y Y 7 Scales E elationships MW Automated Edits Solutions No Action Solution Aerate A 1 ewe CONAN EAS JN IA ES Scaled Solution Effects on Varnables Cy Ar Mame Yr COST We OUTPUT 4 0 No Action omas i 140 000 cu Yds 01 6 185 000 eu ds Aaa Pr
61. e types of financial costs that are incurred for other project purposes including costs for preconstruction engineering and design real estate construction ongoing operation maintenance repair and rehabilitation and monitoring Benefits for mitigation are more problematic since unlike flood control navigation and other developmental purposes mitigation benefits are not measured monetarily The analytical difficulty that this presents to justifying environmental projects is so pervasive that the Water Resources Development Act of 1986 sought to legislate a solution Section 907 of that Act directs that In the evaluation by the Secretary of the Army of benefits and costs of a water resources project the benefits attributable to measures included in a project for the purpose of environmental quality shall be deemed to be at least equal to the costs of such measures Not withstanding the intent of the Act there remains no universally acceptable method to express environmental benefits in exclusively monetary or economic terms Mitigation of environmental damage can however be expressed in other metrics ranging from simple numbers of acres of a given habitat to more sophisticated indicators like habitat units Therefore although a traditional benefit cost analysis cannot be conducted without monetary benefits the costs of mitigation plans can be compared with their non monetary effects Such comparison is at the heart of cost effectiv
62. easure and a program may contain only one scale of each component plan Many of the variables used in habitat based evaluation procedures see below can be used to define scales of management measures For example if percent herbaceous canopy cover is a variable for a target species and if planting herbaceous vegetation is being considered as a measure then the measure could be sized in increments of the variable such as 30 percent herbaceous canopy cover 40 percent herbaceous canopy cover 50 percent herbaceous canopy cover and so forth Section 2 Plan Formulation How Many Scales The number of possible solutions and consequently the number of output and cost estimates will rapidly increase as we consider increasing numbers of scales of measures Therefore the numbers of measures and their scales should be kept to a reasonable number to minimize study cost and time There are no universal rules for determining the proper number of scales that should be considered in every case the number that should be defined is a matter of judgment In reaching that judgment it is helpful to think about scales that are m Meaningful For example scales of a fenced in area in increments of 0 01 of an acre or in increments of 10 000 acres are probably not correctly sized and would result in too many or too few solutions for most analyses Also there is no reason beyond ease of comparisons and symmetry that increments must be identical in
63. easurement of the ecological output of each solution and scale see Table 6 below These net outputs are the output quantities to use for CE ICA The outputs displayed were calculated on an average annual basis over the 50 year project life The cost information from Table 4 and the output information from Table 6 for the various solutions and scales will be used in the IWR Planning Suite software example in the following sections 32 A Section 4 Case Study TABLE 5 OUTPUTS ACRES AND QUALITY INDEX VALUES OF SOLUTIONS AND SCALES W rian Description Number Ac Ac al Overbank Wetlands 1 23 25 Overbank Wetlands 4 150 150 15 7 7 75 Number Solution Scale Scale Wetlands Ripa Water Ac al 2 Riparian Corridors Ma Riparian Corridors 4 Riparian Corridors L 75 Note Ac Acres QI Quality Index Quality Index values shown are the difference improvement in QI between with project and without project conditions TABLE 6 COMPOSITE OUTPUTS ACRES X QUALITY INDEX VALUES kh 1 Flow Regulation Wetlands E PERES 1 Flow Regulation Wetlands O 80 Flow Regulation Wetlands O 3 120 y O pC Overbank Wetlands S OAD O Overbank Wetlands oo 2 Overbank Wetlands O J 3 BH Overbank Wetlands 4 S O75 O p CC Remove Salt Cedar JJ oO O Riparian Corridors O l CC gt Riparian Corridors O o OC 27 O Riparian Corridors O l o 3 _ 47 Riparian Corridors o 4 O 5 O
64. ee growth The cottonwood willow riparian vegetative cover provides very high habitat values to a variety of bird and mammalian species Enough water discharging from the overbank wetlands would be available to support up to six riparian corridors of approximately 50 to 100 yard widths and 500 to 1 000 yard lengths These riparian corridors would correspond to scales 1 6 for this solution category scale 1 construct 1 riparian corridor scale 2 construct 2 riparian corridors scale 3 construct 3 riparian corridors and so on Because the cottonwood willow corridors solution 4 are dependent on water flows from the overbank wetlands solution 2 solution 4 is dependent on solution 2 Likewise the establishment of cottonwoods and willows is dependent on the removal of salt cedar so solution 4 is also dependent on solution 3 Solution 5 Create Open Water Areas in River Channel This solution would consist of excavating and grading depressions or pits in the riverbed that would serve as deep water pools and open water areas to capture water from flood flows and some of the wastewater treatment plant outflow The open water areas would provide habitat for various aquatic species as well as provide food and water sources for various bird and terrestrial species Various sizes and configurations of open water areas could be constructed Four scales would be considered 100 200 300 and 400 acres Before this solution can be implemented the exi
65. eness and incremental cost analyses and is the basis for their application in environmental planning Initial Corps guidance on the application of incremental cost analysis in environmental planning presented in engineering circular number 1105 2 185 U S Army Corps of Engineers 1988 included Incremental cost analysis is an investigation and characterization of how the costs of extra units of output increase as the level of output increases In mitigation planning such analyses will result in an array of implementable mitigation plan increments ranked from most to least cost effective This guidance was subsequently incorporated into the Corps engineering regulation number 1105 2 100 Guidance for Conducting Civil Works Planning Studies U S Army Corps of Engineers 1990 This regulation referred to as the Planning Guidance Notebook and revised in 2000 requires that An incremental cost analysis shall be performed for all recommended mitigation plans The purpose of incremental cost analysis is to discover and display variation in costs and to identify and describe the least cost plan Section 1 Introduction The requirement of incremental cost analysis for the mitigation of adverse project impacts was extended to the restoration of fish and wildlife resources through Policy Guidance Letter 24 U S Army Corps of Engineers 1991 In June 1995 the Corps released engineering circular number 1105 2 210 Ecosystem Restoration in
66. es and need not necessarily be derived from a fixed set of solution and scale combinations With such a configuration the planner gains a great deal of leverage in the ability to define their own plan alternatives and scenario sets and to edit combine or remove plans from both planning sets produced by the Plan Generator Module and those that they enter themselves The same plan alternative can be a member of and shared by more than one planning set in a plan study simultaneously This capability gives planners complete control over the planning sets used for analysis and removes any restrictions that would be imposed by a planning set generator that is tied directly to a plan scenario analysis Prior to analysis the plan alternatives Section 5 Software Terms and Procedures can be described in exactly the format and subset most appropriate for the analysis that is to be undertaken Planning Set A planning set or plan set is a grouping of individual plan alternatives There are different kinds of planning sets in IWR Planning Suite all having their own special use and purpose There are generated planning sets user defined planning sets constrained planning sets and analysis planning sets A description of each follows The user may think of planning sets as similar to the term scenario as used under the IWR PLAN version 3 33 nomenclature Generated Planning Set A set of plan alternatives created with a plan generator from s
67. es were developed to meet Corps needs in restoration and mitigation planning focusing on fish and wildlife habitat and watershed or ecosystem related studies they should be equally useful in addressing many other planning applications both within and outside the Corps For example the procedures may be useful to address problems of dredged material disposal natural resource management and mitigation banking Environmental planning and management applications outside the Corps might include studies addressing water and air pollution hazardous waste cultural resources or mitigation planning in transportation alternatives analysis Ultimately applicability is limited only by analysts ability to define and measure the output and cost of solutions to planning problems How Do the Analyses Fit in the Planning Process Federal water resources planning is a formal choice process that integrates many perspectives Engineering economic environmental social and political concerns are brought to the table and traded off as a number of alternative plans are formulated and evaluated The P amp G planning process consists of a series of steps that provide an orderly and systematic approach to selecting a recommended plan The P amp G planning process consists of the following major steps 1 Identify problems and opportunities 2 Inventory and forecast without project conditions 3 Formulate alternative plans 4 Evaluate effects of alternative p
68. esults which may be filtered down to a preferred set of plans The CE ICA analysis module is capable of processing plans from any of the planning sets in the current plan study in the IWR Planning Suite database Results may be generated as a planning set directly to the WR Planning Suite database from which they may be edited reported on or graphed printed used as input to additional analyses or exported to a file The CE ICA analysis dialog will accept active planning sets in the IWR Planning Suite database those generated by the plan generator or plan editor or by any other means such as export and will allow the user to perform subsequent analysis of the planning set The analysis results will be output as an active planning set to the IWR Planning Suite database from which it may be exported if desired The default Cost Effective attribute is made visible in the resulting planning set to indicate the cost effectiveness or best buy status of each of the plan alternatives from the analyzed planning set Open the CE ICA Analysis form now Figure 55 to generate a new analysis planning set from the current generated planning set The same steps may be followed to perform an analysis on a planning set manually entered through the plan editor or imported from a file 18 IWR Plan Planning Study Salt River Generated Set 5 Generated eQ File Edit View Window Analyze Results Generator Help wai Generated Set 5 Gener
69. f Action Scales Overbank Wetlands a Riparian Corridors 6 In channel Wetlands A OOOO For reporting purposes solutions are displayed in the Solutions and Scales form in the order they will be used to generate plan alternatives By default each new solution is given the next consecutive position for its order Solutions may be dragged and dropped to change the solution order To create a new solution simply click the Add button which will add a new row into which the solution information may be entered Clicking the Delete key on the keyboard after selecting a solution will permanently remove the current existing solution Figure 25 The OK or Cancel button Figure 25 Step 5 will allow this form to be closed gt 92 Section 5 Software Terms and Procedures The Solutions and Scales dialog will also allow the entry of quantitative effects on each variable for every solution and scale through the Scaled Solution Effects on Variables data entry table Figure 26 The first two columns of the data entry matrix make up the solution code The first column is the designator code for the respective solution provided by the user the second column is the scale counter These code columns in the Scaled Solution Effects on Variables table are generated by the program and are not editable The third column is for entering a description for each solution scale This default description is editable The entry of a descriptio
70. hrough the solutions and scales editor Any solution and scale to be excluded from the set of generated plans may be removed through this editor The editor automatically generates a No Action scale for each solution in the same fashion that solutions and scales were generated for the IWR PLAN version 3 33 functionality 50 A Section 5 Software Terms and Procedures To define solutions navigate to the Solutions and Scales dialog Figure 24 Once the Solutions and Scales form is loaded Figure 25 solutions can be defined by pressing the Add button and entering the information The solution description is a description of what action or measure is to be taken Enter Flow Regulation Wetlands in the space provided for the solution description now Figure 25 Step 1 The solution code is a multi letter code of up to ten characters that represents this solution This code will be used in place of the description when a plan is generated Now enter F in the space provided for the code for the solution Flow Regulation Wetlands Figure 25 Step 2 The last field on this form represents the number of action scales this solution has By default a zero scale is added to each solution and represents no action taken For example Flow Regulation Wetlands has three action scales This means that there are three possible scales at which Flow Regulation Wetlands can be implemented Enter 3 in the space provided for the number of a
71. iables An example of an Excel spreadsheet in this format would look like this Figure 72 Ed Microsoft Excel ImportRowSolColVar xls St File Edit View Insert Format Tools Data Window Hr DAA AAA aan fx s Scale a FishHU s BirdHll s H serate 1 9 7 22 O EN Dredge 1 102 my 24 5 Harvest 1 AF 2 0 16 21 Figure 72 Row Solutions Section 5 Software Terms and Procedures Plan level Import Rows are complete fully formulated plans columns are variables An example of an Excel spreadsheet in this format would look like this Figure 73 ES Microsoft Excel ImportRowPlanColVar xls E Fie Edit wiew Insert Format Tools Data wf MES EEEE ES gt XV 46 1 o OJ Aa B Ooo Cost Output No Action Plan 0 0 Plan 1 15 5 16 2 4 Plan 2 aahei mm Plan 3 34 12 9 Figure 73 Row Plans Choose the format appropriate to your Excel spreadsheet and select one of the options from the dialog Select an Import Format section by clicking the appropriate radio button l owe an Import Forma Import Solutions and Yarnables Rows are vanablez columns are solutions O Rows are solutions slumns are Varlables i Plan level Import O Rows are plans columns are variables a E Figure 74 Select Import Format Dialog 86 Section 5 Software Terms and Procedures Once the Import Format is selected Press the OK button to initiate the importation of data from the Excel spread
72. iew Window Analyze Results Generator Help LZ may AER op Sp enerated Set 3 Generated W del B8 E Lar J gt E hue UN Export Planning Set to Excel PR Save in My Planning Sets ex EA A Bussey Lake xls E salt River xls My Recent E my Plan Set Jan 16 2006 xls Documents E No Action Plan AIDOHOSO A2DOHOSO ADD1HOSO ADD2H0S0 ADD3HOSO A1D01H0S0 A2D1H0S0 A1D2H0SO0 A2D2H0S0 A1D3H0S0 A2D3HOSO ADDOH1S0 My Network File name New Jackson Study Plan Set May 1 2006 4 y ADDOH250 Places h type X ance ANDOH3S0 ave as type Excel Spreadsheets ANDOHASI y ma so L Figure 81 Excel Export Dialog Select the directory you wish to save the exported planning set to in the Save In dropdown list In the File Name entry field enter the name of the new file to which you wish to export the current planning set The file will be created and the current planning set will exported as a sheet in an Excel spreadsheet file You can then open up the exported planning set in Microsoft Excel see Figure 82 90 A Section 5 Software Terms and Procedures EJ Microsoft Excel New Jackson Study Plan Set May 1 2006 xls Sele AE File Edit View Insert Format Tools Data Window Help Adobe PDF Sed ts ABRA REFE BO Ge ESN O Ad fe Name ee e a ey eee Cost Output 4 A2DOHOSO NOS o o cam y rt 11 A2D2H0S0 41 00 M 4 gt Mh Sheetl lt Ready Figure 82
73. ile Page Setup option is selected from the main menu see Figure 85 a standard Windows page setup dialog similar to ones used in Microsoft Office products is displayed see Figure 86 W IWR Plan Planning Study Planning Sty Page Setup a File Edit View Window Analyze Results Save As Import TEEI Size z Source Automatically Select Export Optimize Database Orientation Marging inches le Portrait Left 1 Bight 1 Landscape Top i Bottom 1 Cancel Printer Figure 85 Figure 86 Page Setup Option Page Setup Dialog The Page Setup option allows the user to specify the printing configuration for documents to be printed through IWR Planning Suite The paper size printer paper source landscape or portrait mode and print margins may all be defined through this dialog Press OK to accept any modifications made Press Cancel to leave the dialog without applying any page setup changes 92 A Section 5 Software Terms and Procedures Pressing the Printer button on the Page Setup dialog will allow you to select the printer that you wish to print to if you do not wish to print to the default printer setup in your Windows configuration To do so select the desired printer from the drop down printer Name list see Figure 87 and press the OK button Pressing the Cancel button exits the Printer Page Setup dialog without changing the currently selected printer Page Setup Printer A
74. ing studies the program can be useful in planning studies addressing a wide variety of problems IWR Planning Suite can assist with plan formulation by combining solutions to planning problems and calculating the additive effects of each combination or plan IWR Planning Suite can assist with plan comparison by conducting cost effectiveness and incremental cost analyses CE ICA identifying the plans which are the best financial investments and displaying the effects of each on a range of decision variables The software is available for download via the IWR Planning Suite website http www pmcl com iwrplan IWR Planning Suite builds upon previous MS Access based versions of IWR Plan and upon the basic plan formulation and comparison framework of the DOS program ECO EASY Cost Effectiveness and Incremental Cost Analyses for Environmental Planning developed within the Corps Evaluation of Environmental Investments Research Program IWR Plan transformed ECO EASY to a Windows operating environment while IWR Planning Suite adds new functionality flexibility and reporting tools Development of IWR Planning Suite has been carried out within the Corps Decision Methodologies Research Program conducted at IWR The Corps and the Social Sciences Institute of the NRCS cosponsor IWR Planning Suite development A xiii Executive Summary XIV Section 1 Introduction Audience Today s environmental decision makers are faced with a complex
75. ing using the analyses results a case study and instructions in the use of the program IWR Planning Suite The IWR Planning Suite software was developed to perform the routine and often time consuming number crunching required by the analyses thereby freeing planners to focus on the identification of solutions the estimation of their environmental and economic effects and the communication of information to support decision making While economists may be most comfortable with the procedures of cost effectiveness and incremental cost analyses biologists ecologists and other environmental scientists will typically determine the environmental variables to be analyzed and the methods by which changes in those variables will be measured and communicated as environmental outputs Staff from plan formulation engineering environmental and other areas will formulate alternative plans to effect changes in those variables Similarly cost engineers real estate specialists economists and others must combine their expertise to estimate the financial and economic costs of those alternative plans It is important that all members of a study team regardless of their discipline understand how their respective inputs are used in the analyses and provide decision makers with their unique insights in interpreting the analyses results Section 1 Introduction Just as the manual is intended for readers from varied backgrounds it is also intended fo
76. irst solution Solution 2 Overbank Wetlands Overbank wetlands would be created further west and downstream of the regulation wetlands and located not in the Salt River channel itself but at bank level These wetlands would be supplied with water from the regulation wetlands Their purpose is to provide similar habitat to what had historically existed for various aquatic bird amphibian reptilian and mammalian species The overbank wetlands would also provide source water for downstream and downhill or downbank cottonwood and willow riparian corridors Various scales and configurations of overbank wetlands are possible but their general shape would be roughly linear along the top of the river bank between approximately 100 to 200 yards wide and covering areas of 25 to 150 acres 25 acres corresponding to scale 1 75 acres to scale 2 100 acres to scale 3 and 150 acres to scale 4 Because the overbank wetlands solution 2 are supplied water through the diurnal flow regulation wetlands solution 1 solution 2 is dependent on solution 1 Section 4 Case Study Solution 3 Remove Salt Cedars from River Channel This solution would entail removing all 1 000 acres of invasive salt cedar trees from the Salt River riverbed and the area between the overbank wetlands and the riverbed The trees would be bulldozed uprooted and removed Removing invasive salt cedar is a prerequisite to enabling native plant species to re vegetate the area
77. ish to exclude 64 A Section 5 Software Terms and Procedures When you press OK the planning set is generated If there are many solutions and scales defined this may take from several minutes to many hours A progress bar at the bottom of the IWR Planning Suite window will display the percentage of plans that have been generated Name So Action Plan Generate Planning Set Alanning Set Name Generated Set E Description Generated plar solution and 24 Created By r Solution Sensitivity gt C Low Expected Figure 40 Generate Plan Progress Bar Inefficient Plan Removal Inefficient Plan Removal the filtering of all plans except cost effective plan alternatives may be applied as an option when generating the planning set To enable inefficient plan removal select the Options Menu item from the Generator Dialog on the main menu check the box to Remove inefficient plans and press OK as shown in the examples below see Figures 41 and 42 IWR Plan Planning Study Planning Study 8 Planning Set 1 Editor col File Edit View Window Analyze Results Generator Help Solution Sensitivities Relationships Name Generate Plans Mo Action Plan Automated Edits T i ooo foe f Figure 41 Generator Menu Dialog A 65 Section 5 Software Terms and Procedures IWR Plan Generator Options Optimize the Plan Generator Database Optimize DB
78. it is important to check the validity of the cost and output estimates of all combinations that include those measures to assure that costs or benefits are not being double counted Where Do Solutions Come From The process of building alternative plans from management measures and programs from plans is called plan formulation Plan formulation occurs in three very general phases identification of management measures formulation of alternatives and reformulation In every study these phases will overlap and be repeated or iterated again and again For additional discussions about the plan formulation process see the Planning Manual IWR Report 96 R 21 There are many plan formulation approaches such as ask an expert considering plans of others and using brainstorming HEP models and checklists see the Planning Manual While any of these approaches may be used to develop solutions a formulation approach known as all possible combinations is a viable approach frequently used during planning investigations This approach begins with a list of individual management measures defines combinability and dependency relationships among the measures and finally derives every possible combination of the measures given the defined relationships The resulting set of combinations is the entire set of alternative plans that can be generated from the measures under consideration every plan possible will have been formulated
79. ix ACKNOW Od Semen IS oain E EE E E E E O R xi Er cave oA ahaa a NaN xiii Section INTO UCA a aa a aa Ai 1 A E NENEN EEEE aes E TENTENE SE ESEE EE A AAE ENEE EE EEEE EE 1 Purpose or IVI AIT AM ics ge erica CORR OS 1 What Are Cost Effectiveness and Incremental Cost Analysis oooooccnconocinocnoononnnnoncnnncnnnonnnonncnnnnnos 2 nerementat Cost AM aly SIS ceda dali 3 Why Conduct Cost Effectiveness and Incremental Cost Analyses ooooconnccncnocinoccnoncnanconoroncnnncnos 3 APPIA Iii iii 4 How Do the Analyses Pit in the Planning Process vesical illes laico ciclo Di eoicabidsl 5 Cost Effectiveness and Incremental Cost Analyses What They Are Not eesse 6 History and BACK OVO ING iii 7 Secon a lancer OFM Ula OM siaia cs e ets tao de Oe eee ch ee Oe at eects 11 WAV TVS o o A A 11 elos O A A 13 How Many cales tati 14 Interrelationships of Solutions Combinability and Dependency sssseesseeeseeeeeseeerererrrerresresss 15 Where Do Solutions Come From tu iba 17 Wha san OUMU in ELO O E E A EN A ee teemmaseds 18 Measutine OQUE na e 18 AAA a a ects enc a uote EE e ee eee N 20 IREE SE EA E AA AET OE ET II IS 21 Secon o Fan Analy Sl eein AE E E E E 23 Borre O e a e TO Se a Seen ROR ACE 23 A E A sep cade A E E Maem an O E E 23 What san crement iii idisiiabiale 24 Incremental Costand Incremental Output na 24 Incremental Cost Per Unit e de dde oda dla oca A BOL 25 econ EC ASE OI tepepan iria 27 A A O a 27 Study Area CINO a al 27 A A TE INNE A ILEA
80. lans 5 Compare alternative plans and 6 Selecta plan Though the numbering of the planning steps indicates the basic order in which they are conducted planning is a dynamic process the steps of which may be repeated or iterated one or more times as steps of the process uncover new information new alternatives are developed or as objectives are reevaluated The cost effectiveness and incremental cost analyses procedures in this manual can contribute to a planning study in a number of ways both early on and later in the planning process Cost effectiveness and incremental cost analyses can be useful tools during even the earliest iterations of the planning process As experience will show the analyses can help you quickly formulate a very wide range and number of alternatives during reconnaissance or other early phases of work Cost effectiveness and incremental cost analyses are comparisons of the effects of alternative plans more specifically they involve comparisons between the outputs and costs of different solutions As such you must first develop at least preliminary information about alternative plans planning step 3 and their effects planning step 4 in order to conduct the cost effectiveness and incremental cost comparisons planning step 5 In this sense cost A 5 Section 1 Introduction effectiveness and incremental cost analyses may be thought of as being late in the six step planning process Cost Effec
81. lans and programs A management measure or simply measure is either a feature or an activity or some combination of the two that can be implemented at a specific geographic site to achieve desired effects A feature is generally a structural element that requires site construction for example a levee On the other hand an activity is generally a nonstructural action for example vegetative planting An activity might be a one time occurrence like planting or it may be ongoing continuing or periodic such as harvesting aquatic vegetation A site is a place on land or water at above or below the surface in which there is a legal interest through outright A 11 Section 2 Plan Formulation ownership or a right to use or act on it flowage easement grazing rights etc for implementation of features or activities Examples of management measures that may be used for restoration and mitigation are listed in Table 1 EXAMPLES OF ENVIRONMENTAL MANAGEMENT MEASURES aerators detention basins revetments algaecide application dredging rock piles TABLE1 bank overhangs fencing rock shoals bank stabilization fish ladders rootwads boulder deflectors fish screens rototilling breakwaters fish stocking sedimentation basins brush bundles gabion baskets stake beds brush mattresses gravel traps stormwater treatment areas brush piles harvesting substrate improvement bulkheads jetties tree layering chemical preci
82. lected a minimum and maximum value must be entered To Constrained Planning Set Name Constrained Plan 2 have multiple variables constrained simply keep performing these steps for Cancel the other variables Constrain Active Planning Set Variable Minimum Value MMasimurn Value Figure 45 Constrained Planning Set Section 5 Software Terms and Procedures Plans of Interest Plans of interest are defined as plans that are deemed interesting and therefore the user desires to keep track of them for some purpose Certain different types of variables or attributes must be associated with a planning alternative and given values either during the manual creation of the planning set or by the planning set generator before the set may be subjected to subsequent analysis For example in order to be processed by the CE ICA module each plan alternative must have variables which represent the cost and output measures of the plan The CE ICA analysis will allow the user to specify which variables of the planning set represent the cost and output measures for analysis purposes In the planning study editor attributes applicable to the analysis may be defined such as a plan of interest attribute to be used by reporting and visualization modules Then once the rows of the planning set are created individual plans of interest may be chosen To do so the plan of interest attribute of the row is marked in the planning set editor At this
83. llows you to create sets of plan alternatives individually without the need to invoke the Plan Generator However it is also able to accept generated planning sets from the Generator module Planning Sets are grouped into a Planning Study within the Plan editor A diagram of the various toolbar components of the Plan Editor and their use is shown below Figure 9 You may use it as a quick reference while going through the example scenario below 38 A Section 5 Software Terms and Procedures 18 IWR Plan ranning atun pussey Lake NG Bussey CEZ A Anz lysis LESILA 7 ay JAF w J eho OUTF UT gst Effective Best Buy A A vts Pianina Plan Study Planning Set 40D1H0S0 101 6 241 Reports amp Graphs Select Planning Set to ADD HOSO 227 2 48 E perform actions upon A1D1H0S0 WES 46 A1D2H0S0 132 4 gt e AIDTHOSI a CI DCI E CI AE IE ADD1H550 132 4 76 Plans AMANDA Planning Sets List 11 30 2004 Figure 9 Plan Editor Toolbar Components The Plan Editor is the primary user interface for IWR Planning Suite because planning sets are the principal documents that IWR Planning Suite works with The plan editor module has the intrinsic ability to edit import and export sets of planning alternatives or planning sets The plan editor module allows the active planning set to be edited The individual values in a plan alternative may be edited Individual row cells representing variable or attribute values may b
84. lly exclusive properties of a solution Scales are most typically thought of as different sizes but they also apply to other dimensions A management measure may be scaled by several different properties such as a Physical properties including different sizes amounts counts etc For example size of a site 30 acres 40 acres 50 acres etc number of plantings per acre percent canopy cover of vegetation water depth discharge capacity of a pump Composition including different materials and methods that would accomplish the same purpose For example a fence may be constructed as a chain link fence or a barbed wire fence or a wooden slat fence For the purpose of developing alternative plans the different materials may be thought of as different scales of a fence Locations including different sites for the same solution Timing and duration including different start and stop times and durations for the same solution For example low flow releases could be scheduled to last 6 8 or 12 hours An alternative plan may be scaled in terms of the measures that make up the plan which measures are included in the plan and in what order would they be implemented A program may be similarly scaled in terms of the alternative plans or projects that make up the program Scales are mutually exclusive for example we must decide upon one channel depth Therefore a plan may contain only one scale of a given characteristic of a m
85. ls 7 Planning Documents E QuickTime Real Startup E Winzip E WordPerfect Office 12 Adobe Acrobat 6 0 Professional Internet Explorer gm IWR Planning Suite r A 4 Microsoft Project wi msn A Outlook Express Opening the IWR Planning Suite Program 1 IWR Plan Planning Study Planning Study 8 E a9 Fie Edit View Window Analyze Results Generator Help may e WNN ON S E AA AM O O AN E e Remote Assistance Windows Media Player 8 Windows Messenger Select IWR Plannin q Suite to start the Plan Edito Wi IWR Planning Suite h Figure 11 Planning Set 1 Within the Start Menu move the arrow cursor to highlight All Programs programs and folders will be displayed You will see an icon labeled IWR Planning Suite Move the mouse arrow over IWR Planning Suite to highlight it and left click The IWR Planning Suite Editor will open with a default planning set that you can start entering plan alternatives into immediately see Figure 12 Section 5 Software Terms and Procedures 0 Plans start i IWR Plan Planning St Figure 12 IWR Plan Default Planning Set 2 27 2006 2 56 PM and a list of 41 Section 5 Software Terms and Procedures The Plan Editor module allows the active planning set to be edited The individual values in a plan alternative may be edited Individual plan alternatives may also be inserted into or removed from the active planning set The
86. may exist for several reasons including m Necessary to function For example the survival of willow tree plantings may be dependent upon an irrigation system without irrigation the plantings will die In this case irrigation is necessary for the willows to function m Reduce risk or uncertainty For example we may wish to establish 50 willow trees per stream mile However because previous planting programs in the area have shown that about one third of willow plants will not survive the first critical growing year we elect to plant 75 trees per stream mile to account for the survival risk The 50 trees per mile that we expect to survive are actually dependent on the additional 25 trees per mile that experience has shown are not likely to survive Section 2 Plan Formulation a Improve performance For example we may also elect to improve the growth rate of willow plantings by fertilizing them The fertilizer is not necessary for the plants to function nor will it reduce any risks or uncertainties of survival However it will improve the willows performance by producing more mature trees faster Dependencies can occur in at least two different ways Mutual dependency exists where two or more measures must be implemented in combination or not at all For example consider the following two measures m Management Measure A Vegetative Planting m Management Measure B Irrigation System If A will not work without B then
87. ment is used in a design sense to mean the size of a management measure or the composition or size of an alternative plan For example a levee s height may be sized in one foot increments 4 feet high 5 feet high 6 feet high etc Increments of a plan usually refer to additions of new measures to the plan a levee plan a levee and channel plan a levee channel and drop structure plan etc or different sizes of a particular measure included in a plan a levee and 2 000 foot channel plan a levee and 2 500 foot channel plan a levee and 3 000 foot channel plan etc A last added increment is the final size or measure included in a plan In this manual we use the term scale to mean this design sense of increment Incremental Cost and Incremental Output When we use the term increment or incremental in discussing incremental cost analysis we are using the term in its economic sense to mean a difference or change between two solutions The types of changes we are interested in are differences in cost and differences in output between solutions these differences are referred to as incremental cost and incremental output Incremental Cost is the difference in total cost between two solutions expressed in dollars For example if a 40 acre pond costs 100 000 and a 50 acre pond costs 175 000 the increment of cost or change in cost between the two ponds is 75 000 This incremental cost information simply tells us that the 50 ac
88. mprised of many plan alternatives cost effectiveness can support decision making by filtering out and eliminating many plan alternatives that are ineffective and inefficient Plan alternatives that cost the same amount or more compared to plan alternatives that produce the same or more outputs can be reasonably discarded thereby significantly Section 5 Software Terms and Procedures reducing the number of plan alternative options to a more manageable subset from which the most viable plan alternative may be chosen Incremental Cost Analysis is performed by determining the incremental cost per unit between successively larger 1 e more output plan alternatives and identifying best buy plans as those plans for which the incremental cost per unit is lowest for a particular output level Incremental cost per unit is defined as the plan alternative s incremental cost divided by its incremental output Incremental Cost is the difference in cost between the costs of two plan alternatives It is determined by subtracting the cost of the less expensive plan alternative from the cost of the more expensive plan alternative Incremental output is the difference between the outputs of two plan alternatives It is determined by subtracting the output of the smaller output plan alternative from the output of the larger plan alternative The CE ICA module performs CE ICA on an active plan set The existing planning set data will be evaluated to generate r
89. n is not required but is recommended The description may be included in reports and is particularly useful for differentiating different scales of a given solution Descriptions can be made up of any combination of alphanumeric or punctuation characters and can be up to 30 characters in length For example F1 is described as Flow Regulation Wetlands on 50 acres Therefore 50 acres will be the description for F1 Enter 50 Acres in the space provided for the description of F1 now Figure 26 Step 1 This particular action will cost 661 000 and result in 40 habitat units of wetlands habitat being generated These values are entered as follows the Costs field has a value of 661 since the Costs variable is measured in 1000 Enter 661 in the space provided for the Costs of F1 now Figure 26 Step 2 The Wetlands field has a value of 40 for this solution and scale Enter 40 in the space provided for Wetlands now Figure 26 Step 3 In this case the solution F1 does not have any output for CW Riparian Figure 26 Step 4 or Open Water Figure 26 Step 5 so these fields may remain 0 This is how the effects that each solution and scale have on each variable are entered into IWR Planning Suite EX Solutions and Scales Solutions Solution b Flow Regulation Wetlands Scaled Solution Effects on Yarnables Cod Y Name Wer Cost Wer Wetlands Wr CwWRipanan Wr Operfater Wr E Mo Acton F
90. nalyze Results Generator Help E New IWR Plan Planning Study Look in E Databaze 7 de E EF Ed E Planninastudy1 mdb May Recent Documents E Desktop My Documents My Computer My Network File name SaltRivel gt Places La Files of type Access Databases Cancel pi Figure 14 New File Name SaltRiver In this case study the name SaltRiver is used as the file name Working with Planning Sets A default planning set that may be edited through the Plan Editor is created for each new Plan Study Other planning sets of a plan study may be created through several methods including importing constraints plan generation and plan analysis Planning set properties see Figure 15 for the icon on the toolbar as shown in the planning set properties dialog see Figure 16 include the title of the parent planning set from which they are derived iM IWR Plan Planning Study Planning Planning Set 1 7e O eta a A MISLI rhim Ar LAI Ar F T e ak pa Hu i it View Window 4n lts Generator Help E PS EA a B m man gt 5 a ma ERE fate ae j aS a le pF we eee SIA i Planning Set i F E aa ES Es ESA xT tt z ml Name Planning Set Properties Cost orl No Action Pian CO LE Figure 15 Planning Set Properties Option Section 5 Software Terms and Procedures EN Planning Set Properties Name Planning Set Description Default Planning
91. nding variable Note that low coefficients must always be a real number less than or equal to one including negative numbers and high coefficients must be a real number greater than or equal to 1 Once the coefficients have been defined simply click the OK button to save the coefficients Figure 51 Clicking the Cancel button will simply discard any changes and close the form Variable Sensitivities Ed Variable Low Coefficient High Coethiciert Losts ee Figure 51 Variable Sensitivities Form Variable Sensitivity causes two hidden derived variables a high value and low value to be added to the planning study for each variable In the resulting planning set these new variables 70 A Section 5 Software Terms and Procedures are filled with the respective high and low values indicating the sensitivity range for the variable In addition to this ability to set all the plan alternative variable sensitivities in a study at one time by using high and low coefficients the capability exists through the plan study variables editor to make the low and high values of any individual plan alternative visible They can then be edited so that every plan alternative could potentially have custom sensitivity values Solution Sensitivity Similar to variable sensitivity the high and low values entered for solution sensitivity are uniform coefficients used for computing the high and low values for the selected solution combination This
92. nefits and costs Between these two extremes the economic tools of cost effectiveness analysis and incremental cost analysis can provide information to support decision making Yoe 1992 Section 1 Introduction Cost Benefit Oblivious Increased Information Cost Decision For Decision Making Analysis Making Cost Incremental Effectiveness Cost Analysis Analysis Figure 2 Economic Analysis Decision Making Tools Benefit cost analysis is generally considered the best case scenario for Federal water resources decision making In benefit cost analysis the monetary cost of a plan is subtracted from the monetary value of the benefits to be provided by that plan to compute net dollar benefits When there is a range of alternative plans the plan that provides the most net benefits is considered optimal and is typically the recommended plan When project benefits are not measured in dollars cost effectiveness and incremental cost analyses offer next best approaches While the cost effectiveness and incremental cost analyses of alternative plans may not identify a unique or optimal solution they can lead to more informed choices from among alternatives by elevating the decision making process above cost oblivious decision making Yoe 1992 The value of this approach to environmental planning is recognized in the National Research Council s National Strategy for the Restoration of Aquatic Ecosystems The Council s strategy states that
93. ng the where conditions 62 A Section 5 Software Terms and Procedures Table 11 below defines the other automated editing function that is used in this case study Repeat the procedure above for the remaining automated editing function now AUTOMATED EDITING FUNCTION Ser eaten tt Name Where Condition ae 1 O 2 R 1 S 1 E OR 1 OR O OR R OR S OR W Default Notice that the new edit group name is Modoutput and that the automated editing function being applied is a reduction of In channel wetlands AAHU s by 50 percent and a doubling of Riparian Corridors AAHU s These output modifications will occur under all conditions so the where condition statement does not need to be modified from the default condition You may add or delete groups at this time by clicking the Add button or selecting an automated edit and pressing the Delete key on the keyboard respectively Clicking the OK button will save the automated edits you have defined Plan Generation Once a planning study comprised of variables derived variables and attributes has been defined by the user with the plan editor the plan generation module is used to populate a new planning set with plan alternatives The plan generation module is used only to define those items that relate to solutions and scales rather than to variables and attributes Items like cost and value variables and plans of interest are defined through the plan editor rather
94. ning Set Select Planning Set to Delete Generated Set 2 Figure 18 Delete Planning Set Dialog You may select the planning set you wish to delete from the list of available plan sets and press OK to remove it from the planning study permanently Please be aware that the operation cannot be undone once OK is pressed and the planning set selected will be deleted and will not be recoverable by any means Press Cancel to exit the form without removing any planning sets from the planning study If no planning sets exist other than the default plan editor planning set which cannot be deleted the following dialog Figure 19 will appear indicating that no planning sets are available to be removed in the current planning study No planning sets to delete E There are currently no deleteable planning sets Figure 19 Planning Set Removal Dialog Planning Set removal may become necessary if a planning set analysis is performed with the incorrect cost and output variables for example or if a planning set is generated with an incorrect set of parameters It may also be helpful to delete planning sets when the planning study has become cluttered with too many that are no longer current or no longer applicable Costs and Outputs The first step in performing incremental cost analyses for our sample ecosystem restoration study is to determine and define the costs and outputs to be used Within the IWR Planning Suite we
95. nning Suite Windows Menu Items 96 A Section 5 Software Terms and Procedures Help Menu Elements of the IWR Planning Suite Help System can be chosen by clicking on the Main Help menu entry and selecting the appropriate item Figure 94 iM IWR Plan Planning Set 1 Editor gt oH File Edit wiew Window Analyze Results Generator Help ea El a l IMW R Plan Help bn About IMW R Plan k Name 7 COST Y Figure 94 The IWR Planning Suite Help System Menu The Help system is a full featured Windows format Help System including much of the information available in this User s Manual arranged in an electronic Help System Format which is fully indexed and completely searchable see Figure 95 The IWR Planning Suite Help System can be accessed at any time by selecting IWR Planning Suite Help from the Help menu or pressing the F1 function key on your keyboard nm ea li IWR Plan Planning Set 1 Editor Sele iaa Bile Edit View Window Analyze Results Generator Help f X BEE E 8 Hide Back Print Options Contents Index Search Glossary FAA Opening the Plan Editor Ho Action Pla 12 Acknowledgements x mall You will be working within the IW R Plan Editor Me Fst Plan throughout the example scenario The Plan Editor maintains a Plan Study containing planning sets and all WRE Plan functions are performed within Ly
96. nononanncnnnnnonnncnnncnnncnnnnnnnnrno nono nono ncnnncnnnos 81 Pre Uke OG Makiscena Ora Plinio AA 82 Meurs File A dev notancaceadadeusbatenaarbacedeteastsoasessest 82 PIG Ure 6o Import Data 83 Figure 69 Select Data File fo Ipod 84 Moure 70 Import Fron Excel Dial ist od aia anes 84 brete 1 ROW Vandal Sutton d online oil circa 85 PACU LC 7 2IKOW SO UNS sin 85 Figure 3 ROWE LADS adi 86 Pieure 74 Select import Format DIOS a Aaa 86 Heure ZO Mue TIN POL la lO tano Ion ie AA OIR 87 Piate O COVER Wite OP tdt iii 87 Figure 77 Import iron IWR Plan Versiono iodo eee 88 Figure 7o WW RAL lan Versio 00 DialOS iia 89 Figure 79 Import Complete Message DO is aii 89 TIS UES OU EXPORT Vienna ito 90 Figure Ol Export Dialo BOX sta csnend vasaatssseaecl teanianiee 90 Figure o2 Excel Plants Seta ca aaa toners nature eee ene rede aaa 91 Pieure 2 Optiniize Database cra al lis 91 Poue ot Database OPUMIZE la aaa 92 Figure OO Fage Setup Opos 22 Figure so Page Setup Dilge reena dnd 92 Hretite 97 Pace octu Printer oelet a E amelie Ses 93 Me ure oo LUMEN Wi 93 PISULeO Print review DIalOS iaruinn pa A 94 PESO DO Print Dialog ia 94 vi A Figures Pa i 0 BOX Sere ieee E E E E E EE atau E T E ai ue E eau T E enemas sone sacle E EE 95 Pere IZ Ed Men a a a S 95 Preure 93 IWR nnne Sute Windows MEMS ainar R a 96 Figure 94 The IWR Planning Suite Help System Menu esessesesseseereererrsrrerrsrrrerresresresrerenresresresreersees 97 Figure Io TWR Planning Sui
97. ntify and develop methods and procedures in consultation with the Council on Environmental Quality established by Title II of the Act which will ensure that presently unquantified environmental amenities and values may be given appropriate consideration in decision making along with economic and technical considerations In 1983 the U S Water Resources Council replaced the Principles and Standards with the Principles and Guidelines P amp G providing the instructions and rules for Federal water resources planning The P amp G requires that In general in the formulation of alternative plans an effort is made to include only increments that provide net National Economic Development NED benefits after accounting for appropriate mitigation costs Increments that do not provide net NED benefits may be included except in the NED plan if they are cost effective measures for addressing specific concerns paragraph 1 6 2 b While the P amp G places emphasis on plans to achieve NED benefits it does leave the door open for cost effective plans to achieve other benefits such as environmental benefits A 7 Section 1 Introduction In the mid 1980 s the Corps adopted the principles of cost effectiveness and incremental cost analyses for use in planning and justifying mitigation for fish and wildlife habitat losses caused by projects for flood control navigation and other developmental purposes Costs for mitigation are essentially the sam
98. ny currently open plan study and database will be saved and closed and the existing database will be opened in IWR Planning Suite ready for editing or analysis Close The File Close menu item Figure 67 when selected will close the current planning study and database Many menu items will become unavailable when the plan study is closed because there is no open plan study for them to act upon The New and Open items will remain available so that another planning study may be created or opened for editing and analysis Save As Select File Save As to give anew name to any existing database file The currently open database file is the file to be renamed The Save Plan Study As dialog will appear then type in a new name in the File name form Click on Save to rename the database File Edit View Window Analyze Results Generator Help Mew Open Close Save As Export F Optimize Database Page Setup Print Preview Prine Exit Figure 68 Import Data Import Use File Import Figure 68 to import a data file from an existing Excel spreadsheet file or an existing IWR Planning Suite Version 3 33 database file Import Excel Spreadsheet The import utility will automatically populate variable names solution and scale codes and Solutions and Effects data within an IWR Planning Suite data file from the source spreadsheet file The advantage of this
99. of the selected unit Selecting the technique first will by definition select the measurement unit which may or may not be the best indicator for the output Analysts should recognize linkages among outputs units and techniques in developing measurement frameworks for their studies Appendix C of Corps engineering circular 1105 2 210 June 1 1995 provides a good summary of current ecological measurement methods Section 2 Plan Formulation What s a Cost Cost is a sacrifice that must be made in order to do or acquire something Cost is frequently characterized as a monetary value for the purposes of planning investigations The costs of environmental planning solutions have three components implementation costs opportunity costs and incidental benefits While all three components are discussed below only implementation costs are to be included in the cost calculations for CE ICA per Corps policy Opportunity costs and incidental benefits if applicable may be displayed in the comparison of alternative plans for trade off analysis purposes but are not to be included in CE ICA procedures Implementation costs are what economists might refer to as explicit costs they are the out of pocket cash outlays for producing environmental outputs Examples of implementation costs include outlays for preconstruction engineering and design real estate construction OMRR amp R operation maintenance repair relocation and rehabilitation and m
100. olutions management measures and scales User Defined Planning Set A set of plan alternatives entered by a user through the Plan Editor Planners gain a great deal of leverage in the ability to define their own plan alternatives and scenario sets and to edit combine or remove plans from both planning sets produced by IWR Planning Suite s plan generation capabilities and those produced by other means Constrained Planning Set A set of plan alternatives created by applying limiting criteria to an existing planning set Constraints may be defined within the plan editor to filter the planning set to only those plan alternatives that meet a set of predefined criteria The criteria are minimum and maximum acceptable values for a particular variable Derived variables explained below are not available for use by a constraint group To define a constrained planning set the planning set name is entered along with one or more variables to constrain it by a minimum and maximum acceptable value for each variable The application of a constraint to a planning set will generate a new planning set containing only the plan alternatives that meet the constraining criteria Analysis Planning Set A set of plan alternatives created by performing an analysis on an existing planning set Active Planning Set The planning set that is currently selected and visible in the Plan Editor The active planning set is the one that component modules act upon The user c
101. on New variables may be defined by clicking the Add button under the Variables table on the Planning Study form Figure 21 Doing so will create a new row in the table where you may enter properties in six fields that define the variable These properties are the variable s name units of measurement description whether it is a derived variable the derived variable formula and whether the field is to be hidden when displaying planning sets in the Plan Editor 46 A Section 5 Software Terms and Procedures 3 IWR Plan Planning Study Salt River Planning Set 1 Editor Sele fol File Edit view Window Analyze Results Generator Help X al E Man foo E f Man H ee SET E y Japan pir TEG S E cra Planning Set 1 Editor EA oS es Fria oy Ea Pa eT 2 ae ry y a ae q z i Ln ae E s ET z TaN ME _ a _ de EA HE Planning Study El Study Name Sat Rire Description Salt River floodplain ecosystem restoration Mo Action Plan Yanables Mame Ye Units Y Description We De Denved T T Costs 1000 Average 4nnual Equivalent Cost E Mame Y Type Y Description Y Hidden Y p Cost Effective Humber Non Cost Effective Cos Plan of Interest Plan of Interest sa OR Cancel T iF e 4 Figure 21 Planning Study Form The variable name gives a name to the variable that the IWR Planning Suite can use in analysis and reporting This property is
102. onitoring Implementation costs include what are typically thought of as the cost estimate and the real estate appraisal The level of detail appropriate for cost estimates and real estate appraisals will vary through different phases of planning For the purposes of these analyses a Corps M CACES Microcomputer Aided Cost Estimating System cost estimate and a real estate appraisal may not be needed especially during early phases of planning Professional judgment is needed in determining a level of detail that is appropriate for the phase of planning project scale and the level of detail in output measurements Moreover communication is required to inform staff from cost engineering and real estate about what types of decisions their estimates will support for example preliminary scoping of measures so they can be comfortable with the appropriate level of detail Opportunity costs of foregone benefits are what economists might refer to as implicit costs they don t cost us money we already have in pocket but rather they cost us the opportunity to have done something else For example restoration of a riparian corridor may require removal of a levee which would reduce flood damage reduction benefits provided by the levee In Federal water resources planning opportunity costs typically refer to foregone National Economic Development NED benefits The P amp G specifies the following goods and services as NED benefits m Municipal and ind
103. option is that the user will in most cases already have developed data that is to be processed in IWR Planning Suite If the data can be transferred to an Excel A 83 Section 5 Software Terms and Procedures spreadsheet file having the proper format the user can avoid having to re type the same information within IWR Planning Suite First the user must select the spreadsheet file to import from by pressing the ellipses button next to the Excel Spreadsheet entry field Figure 69 This will bring up the standard Windows file navigation dialog entitled Select Excel Datafile to Import From Figure 70 Navigate to the appropriate Excel file and press the Open button to select the spreadsheet file to import from Once the spreadsheet file has been selected please enter a name for the planning set to be imported in the entry field labeled Planning Set Name After entering the new planning set name the import format of the Excel spreadsheet to be imported should be selected IWR Planning Suite accepts three different format variations for imported Excel files two formats for importing management measure solutions and variables and one format for importing fully formulated plan alternatives and variables These are 84 Ey IWR Plan Planning Study Planning Study 7 Planning Set 1 Editor iol File Edit View Window Analyze Results Generator Help Man TY Ge o 3 may HA
104. ormation from the cost and output data Perhaps the simplest such calculation is that of total cost Average Cost Average cost is calculated by dividing total cost by total output The formula for this computation is shown in Figure 4 Average cost is altogether different than the concept of average annual cost The average cost for a particular level of output is the cost per unit of output for that level If a solution provides 100 units of output at a total cost of 1000 the average cost is 10 per unit for that alternative Average costs can facilitate the comparison of production efficiencies across alternatives by placing each alternative plan in a common metric dollars per unit of output For example a solution which produces output at 10 per unit would be considered more efficient in production than a solution producing the same type of output at 20 per unit Total f Solution A Average Cost A AL Cost per Unit Output of Solution A Total Output of Solution A Figure 4 Computing Average Cost Section 3 Plan Analysis What s an Increment If you ve been involved in planning studies you ve probably heard people talk about increments Unfortunately like many other words in our business the term increment has several different meanings each of which are correct when used in the right context In general increment is used in two different ways in Corps planning First and perhaps most commonly incre
105. other decision making criteria for example significance of outputs acceptability completeness effectiveness risk and uncertainty reasonableness of costs to help the planning team select and recommend a particular plan Early Corps field applications of cost effectiveness and incremental cost analyses to environmental planning problems frequently consisted of an intuitive calculation and display of A 9 Section 1 Introduction the average cost per unit of environmental output benefit for a set of alternative plans Ina 1989 survey of Corps planning staff titled Effectiveness of Incremental Analysis for Mitigation Planning many respondents reported that incremental cost analysis was perceived as a hindrance to plan formulation and selection The most common criticisms pointed to the analyses time intensive nature and to a lack of clear procedural guidance for their implementation Reese 1989 To address these criticisms Corps Headquarters tasked the Institute for Water Resources to better define how cost effectiveness and incremental cost analyses could be accomplished This resulted in an overview entitled Economic and Environmental Considerations for Incremental Cost Analysis in Mitigation Planning Greeley Polhemus Group 1991 and a draft manual titled Incremental Cost Analysis Primer for Environmental Resources Planning Yoe 1992 These studies provided background research that evolved into Cost Effectiveness Analysis for Envi
106. outputs and costs A cost effectiveness curve or an incremental cost graph reflecting only two points is usually not revealing and therefore not helpful for decision making m Reasonable The number of scales should strike a reasonable balance between the needs and constraints of the analysis and the burdens cost time and understanding imposed by large numbers of scales that are not sufficiently differentiated to make a difference in decision making In many cases only a few will be reasonable Additional scales should not be artificially created simply for the sake of analysis The most important consideration in defining scales is that changes in scale should result in changes in output or cost or both 14 A Section 2 Plan Formulation Interrelationships of Solutions Combinability and Dependency The ability to make plans from measures and programs from plans is governed by two types of relationships combinability and dependency In a typical Corps study management measures may or may not be mutually exclusive and it is the property of combinability that allows you to mix and match measures into different plans Conversely some measures may preclude others and this will limit your ability to mix and match them In thinking about combinability you should consider whether two measures might be mutually exclusive because of m Location where two different measures cannot occupy the same space at the same time For example
107. pitation mowing water dilution concrete block piles new channels water pumps contouring planting weirs reservoirs wing walls chemical injection log deflectors water control structures dams retention ponds wood reefs Management measures are the building blocks of alternative plans An alternative plan or simply plan is one or more management measures A management measure may or may not be able to stand alone as a plan it depends on the characteristics of the measure Most alternative plans are made up of more than one measure And just as management measures can be combined to form plans so too can plans be combined to form programs As we use it in this manual a program is a set of one or more plans or projects usually located over a large geographic area Some of the Corps current environmental programs are listed in Table 2 12 A Section 2 Plan Formulation TABLE 2 EXAMPLES OF CURRENT CORPS ENVIRONMENTAL PROGRAMS National Programs e Section 1135 Program Project Modifications for Improvement of the Environment e Coastal America Program e North American Waterfowl Management Plan Regional Programs e Upper Mississippi River System Environmental Management Program e Coastal Wetlands Planning Protection and Restoration Act Program Breaux Bill currently implemented in coastal Louisiana e Comprehensive Everglades Restoration Plan CERP Scales of Solutions Scales are different and mutua
108. pressing the Add Figure 33 Step 2 For example to define the dependency relationship for Overbank Wetlands click on the Overbank Wetlands solution in the Solution list box Figure 33 Step 3 Next select the Flow Regulation Wetlands checkbox Figure 33 Step 4 The solution Overbank Wetlands is now dependent on Flow Regulation Wetlands Note if there were multiple solutions required they would all be checked and would appear across the first row of the Solution Is Dependent Upon table EE Solution Relationships Relationship Type C Combinability Dependency i 1 i Solution Flow Regulation Wetlands n channel Wetlands Open Water Overbank Wetlands Riparian Corridors Remove Salt Cedar Open Water Riparian Corridors Remove Salt Cedar Solution Is Dependent Upon Name Relationship he Overbank We Flow Regulation Wetlands Figure 33 Solution Relationships You will notice that when a dependency is defined by pressing the Add button a new row appears below the current row This will allow the either or dependency relationships to be defined Table 10 below defines the dependency relationships that are used in this case study Repeat the procedure above for the 3 remaining dependency relationships now TABLE 10 DEPENDENCY RELATIONSHIPS Solution Dependent On Overbank Wetlands O Riparian Corridors R Open Water W
109. put TotalOutpul OR I Cancel Figure 56 CE ICA Analysis Output Parameter As soon as an analysis planning set has been built it will become the active planning set The active planning set is indicated in the planning sets selection dropdown on the plan editor toolbar For all previously analyzed planning sets IWR Planning Suite only retains the data related to each analysis planning set s cost effective and best buy plans A particular analysis module will usually require certain variables or attributes such as cost and value attributes which are prerequisite components of every plan alternative in the planning set A default Cost and Output variable are automatically created for new plan studies to support the intrinsic CE ICA analysis module Analysis Results The Analysis Results function of IWR Planning Suite provides a variety of graphical and textual reports for the planner to assist in the evaluation of plan alternatives Reports can be generated A 75 Section 5 Software Terms and Procedures from the IWR Planning Suite database of the active planning set or selected from the entire set of analysis results for multi planning set reports The reporting and graphing capabilities are intended to be performed on the results of a CE ICA analysis However these reports are more broadly applicable to any analytic technique that associates appropriate output variables and attributes to the plan alternatives When a
110. r readers with varied interests Environmental restoration and mitigation planning studies will typically involve non Corps parties This manual may provide an understanding of the rationale for and application of cost effectiveness and incremental cost analyses in planning to interested representatives of other groups and agencies as well as to local cost sharing partners It should be noted by non economist readers that a learning curve lies ahead in gaining an understanding about cost effectiveness and incremental cost analyses and their uses in planning The analyses require some of us to think about some new things and to think about some familiar things in different ways We have tried to help you through this learning curve with the explanations and examples provided throughout the manual For some readers the best way to really become familiar with the analyses may be to do a simple example application that can be worked out with a calculator pencil and paper For others the IWR Planning Suite software can be a valuable educational tool for working through example applications at the computer In either case you may wish to use the example exercise included in this manual to work through a test problem and develop your skills in doing the analyses What Are Cost Effectiveness and Incremental Cost Analysis The cost effectiveness and incremental cost procedures presented in this manual are based upon the planning framework established in
111. re pond costs 75 000 more than the 40 acre pond Figure 5 contains the formula for incremental cost Incremental Cost of Solution B Total Cost of Solution B Total Cost of Solution A Figure 5 Computing Incremental Cost Incremental Output is the difference in output between two solutions expressed in the output s unit of measurement Continuing with the pond example if the 40 acre pond would produce 20 habitat units and the 50 acre pond would produce 30 habitat units the increment of output between the two ponds is 10 habitat units In other words the 50 acre pond provides 10 more habitat units than the 40 acre pond Figure 6 contains the formula for incremental output Incremental Output of Solution B Total Output of Solution B Total Output of Solution A Figure 6 Computing Incremental Output Section 3 Plan Analysis Incremental Cost Per Unit Incremental cost analysis is an examination of the changes in both cost and output across alternative solutions We can make this two dimensional variation more apparent helping us to make comparisons across solutions by combining the concepts of incremental cost and average cost to compute incremental cost per unit one number that reflects both types of change Figure 7 contains the formula for incremental cost per unit I tal Cost of Solution B Incremental Cost per Unit of Solution B Incremental Cost of Solution B Incremental Output of Solution B Figure 7
112. rests in the Salt River riverbed also contribute to flooding problems during episodic flash flood events the trees retard passage of flood flows and contribute to increased sediment deposition An estimated 1 000 acres of salt cedar now cover the floodplain in the study area An illustration of our sample study area is shown in Figure 8 Note that this figure shows proposed solutions for the study area A figure of the study area itself would not actually show proposed features only existing conditions Flow Regulation Water Wetlands 3 AAN Orerbank Wetlands 4 g Figure 8 Sample Study Area 28 A Section 4 Case Study Solutions In cooperation with the local sponsor state resource agencies other Federal agencies and local stakeholders the Corps District office developed several solutions various management measures at various sites to the problem of degraded riparian and riverine ecosystems in the Salt River floodplain Since lack of surface water in the Salt River channel was considered fundamental to all associated environmental problems finding a source of water was a critical prerequisite to all proposed solutions Fortunately an underutilized source of water was available and acceptable to all the concerned parties outflow from a nearby municipal wastewater treatment plant Effluent from the plant is treated with secondary treatment processes meeting all state water quality and EPA discharge criteria All th
113. rogram is Harry Kitch Deputy Planning Community of Practice L Leigh Skaggs and Shana Heisey of IWR manage IWR Planning Suite development CDM is providing software engineering services under contract with IWR The authors wish to express their gratitude to Dr Richard Males of RMM Technical Services for his invaluable insight and assistance with the design of IWR Planning Suite The authors also wish to thank the following individuals for their help suggestions and constructive criticism in beta testing the software Beth Brandreth Philadelphia District David Bucaro Chicago District Darlene Guinto Northwestern Division Cynthia Irvin Jacksonville District Camie Knollenberg Rock Island District Mark McKevitt Office of the Assistant Secretary of the Army Civil Works Jodi Staebell Rock Island District Frank Veraldi Chicago District and Danny Maher of G E C Inc The IWR Planning Suite development team consists of members from the Federal government the private sector and academia The development team can be broken into three main categories planning software engineering and testing review Acknowledgements xii Executive Summary The US Army Corps of Engineers Institute for Water Resources has developed IWR Planning Suite Decision Support Software to assist with the formulation and comparison of alternative plans While IWR Planning Suite was initially developed to assist with environmental restoration and watershed plann
114. role in plan selection Total Cost Summing all implementation costs produces the total cost of a solution to be used as the cost element in CE ICA procedures The formula for this calculation is shown in Figure 3 Total Cost Implementation Costs Figure 3 Computing the Total Cost of a Plan Alternative Section 2 Plan Formulation 22 Section 3 Plan Analysis Before You Start Cost effectiveness and incremental cost analyses are tools for comparing alternative solutions to planning problems The analyses should not require any additional data than what would otherwise be generated in a typical planning study They examine how costs vary at different levels of output In cost effectiveness and incremental cost analyses output values are added subtracted and divided Therefore ordinal units of measurement 1st 2nd 3rd cannot be used in these analyses However cardinal units of output measurement such as population counts and habitat units can be used Since the analyses are tools for making comparisons across alternative solutions it is important to convert all data to comparable values Specifically all costs must be discounted to reflect the time value of money and if costs are converted to average annual equivalent costs outputs should also be computed on an average annual basis The remainder of this chapter will discuss calculations that are made in cost effectiveness and incremental cost analyses to extract inf
115. ronmental Planning Nine EASY Steps Orth 1994 Concurrent with this work IWR supported a field demonstration to test the applicability of the Nine EASY Steps procedures and the resultant report Bussey Lake Demonstration Study of Incremental Cost Analysis in Environmental Planning Carlson 1993 was produced In May 1995 Evaluation of Environmental Investments Procedures Manual Interim Cost Effectiveness and Incremental Cost Analyses Robinson et al 1995 was released for review and comment Accompanying the manual was the software ECO EASY the predecessor to IWR Plan and IWR Planning Suite In 2002 IWR also published Lessons Learned from Cost Effectiveness and Incremental Cost Analyses Brandreth and Skaggs 2002 to document how well the procedures were being applied to Corps ecosystem restoration planning efforts and lessons learned that might improve their application The conversion of the approach to a Windows operating system platform and the addition of many new features was carried out through the development of IWR Plan starting in July of 1996 As IWR Plan became a standard tool for performing this type of analysis within USACE a wealth of additional features were considered for incorporation within IWR Plan The underlying approaches identified by these explorations were kept in mind by the IWR Planning Suite development and maintenance team for incorporation into the current design where appropriate Beginning in November
116. s Costs 1000 OpenWater Open Water Habitat AAHU s The first variable that has just been defined is the cost variable for this study The three remaining variables will be used as the output measures Enter the three output variables defined in Table 7 now by following the above procedure Existing variables may be modified or deleted by clicking on the variable s row in the grid to select it When a specific variable is selected it may either be modified or deleted To modify the current variable simply tab to and change the appropriate fields Pressing the Delete or Del key on your keyboard will delete the current existing variable Figure 22 Planning Study Study Name SA Description j River floodplain ecosystem restoration Variables Mame Y Units Wer Description Wr E Tr Derived Function Tr E Costs 1000 Average Annual ita iw i E a CA Ripan Acres oat Acs open TED A EEES petete Rows aaa O You have selected 1 row For deletion i Choose Yes bo delete the row or Mo to exit Attributes Hame l Hidden p Cost Effective Non Cost Effective Cost El Figure 22 Delete Confirmation 48 A Section 5 Software Terms and Procedures Clicking the OK button will save your changes and close the Plan Study form while clicking the Cancel button will close the form without saving any changes Figure 21 Derived Variables Next we will define a derived variable A derived variable is a formulaic
117. s worth 5 000 each if so are 10 more worth 7 500 each The concepts of incremental cost incremental output and incremental cost per unit are not difficult but may be new especially to non economists And because they are unfamiliar they are sometimes confused with average cost Both types of cost measurements incremental and average play a role in our analyses but they are different and cannot be used interchangeably Section 3 Plan Analysis 26 Section 4 Case Study Introduction In order to demonstrate how cost effectiveness and incremental cost analyses can be performed using IWR Planning Suite software the following case study is presented Although the case study is based on an actual Corps ecosystem restoration feasibility study the actual solutions costs and environmental outputs have been modified in this manual for illustration purposes None of the cost and output figures used in this example represent real data from the feasibility study Study Area Setting The City of Phoenix and the Corps are studying means of restoring degraded riparian and riverine ecosystems in a seven mile segment of the Salt River floodplain in the Phoenix metropolitan area The Salt River channel downstream and south of the city is dry during most of the year but the river and surrounding floodplain are subject to infrequent flood flows resulting from periodic flash flood events The primary objective of the potential ecosystem restora
118. s Clipboard into the current planning set location selected This would include pasting values from an Excel spreadsheet into the planning set The shortcut key for Paste is lt CTRL gt V Edit Delete will remove the selected value from the planning set You may also press the Delete key on your keyboard to perform this operation Edit Undo will undo only the last edit operation performed on the current cell either Cut Copy Paste or Delete The shortcut key for Undo is lt CTRL gt Z An advanced feature of the Windows clipboard edit capability of IWR Planning Suite can be attained by using the shortcut keys described above Using these shortcut keys it is possible to select an entire range of values a grid of values to copy or cut from the active planning set and you may also paste an entire range of values from the Windows clipboard into the active planning set Windows Menu The IWR Planning Suite Windows menu provides the standard set of windows arrangement functions familiar across all standard Microsoft Windows Applications These include the ability to Arrange Icons Cascade windows Close All Windows Tile Windows Horizontally or Vertically or minimize all windows as well as including a list of windows that can be selected from Figure 93 Arrange Icons Cascade Close All Windows h Tile Horizontally Tile Vertically Minimize All Windows 1 Planning Set 1 Editor Figure 93 IWR Pla
119. s Y Wetlan Y CWRipar v Open Fa02RUS0WOl 146 183 75 i a 154 Fane 57 Single Planning Set Report 76 A Section 5 Software Terms and Procedures The Single Planning Set Reports form allows the user to select an analysis planning set formerly known as a scenario in IWR Plan version 3 33 and how to view the results of that analysis Planning Set The drop down list Figure 58 contains all the CE ICA analyses that have been performed Select the way in which report data is to be sorted from the Sort by dropdown list for example sorting the reported plans in order of their Cost or Output Single Scenario Reports Report on LEICA Analysis 6 Sort bye Output Report Type Filter By Total amp Average Cost E Incremental Cost es e it worth it All Variables Figure 58 Selecting Report Type The first step in selecting a report to view is to specify which of the planning set analyses to report on To do this simply select the name of the analysis planning set from the Report on dropdown list Next Reports may be sorted in different ways Simply select the desired sort in the Sort by dropdown list to sort the results on the desired field Next specify which type of report to view by clicking the corresponding Report Type Some reports have the option of displaying multiple sets or subsets of data The Filter By checkboxes will allow selection of the possible sets of data that the selected
120. s and incremental cost analyses for every application Planners and analysts need to look at each planning problem and determine the best way to proceed The procedures in this manual provide a basic framework for plan formulation and evaluation This framework is flexible enough to handle necessary modifications for its application to a wide variety of planning situations The following chapters provide a number of examples using the same analytical concepts in a variety of different planning applications Again once the learning curve has been overcome and with some practice the insights required to determine the best way to proceed will come with greater ease The development of the IWR Planning Suite software may lead some to think of the analysis as a black box where data is input and then without requiring any knowledge of the analytical 6 A Section 1 Introduction procedures being conducted an answer is provided Planners must recognize that uninformed dependence on the software s analysis results is inappropriate and misguided The capability to perform reality checks on the software s output the insight required to use the software to handle different planning scenarios and the ability to interpret results are important aspects of effectively utilizing IWR Planning Suite But they may all be applied for naught without a critical understanding of the procedures behind the software Such an understanding will also provide valua
121. s for a combination of analysis planning sets Such results are called Multiple Planning Set Results Navigate to the Multiple Planning Set Results form by clicking the Multiple Planning Set icon on the Plan Editor Toolbar Figure 64 ki IWR Planning Suite Planning Study Salt River CEICA Analysis 6 CESICA va File Edit View Window Analyze Results Generator Help AE Mar gia CEICA Analysis 6 CE ICA E A Ga m Y gt Name T 7 Cost Y Agen TEWRAT Openw v E y nm rr at Figure 64 Plan Editor Toolbar 80 A Section 5 Software Terms and Procedures The Multi Planning Set Results dialog displays all of the CE ICA Planning Sets in the Planning Sets Planning Sets list box Figure 65 Desired CEICA Analysis 6 planning sets can be selected using OE the lt Shift gt Click to select sets contiguous to one another in the list and lt Control gt Click to select non contiguous sets separated in the list from one another by one or more intervening sets Multi Planning Set Results Options Display Type Next select the Display Type Intersection Graphs Figure 65 to view either Graphs or Reports Cost Effective S beth Uk Cancel Selecting the various result Options is the next step in viewing multiple analysis results In the Options group box dropdown list two types of Reports can be selected Intersection or Union C Reports Figure 65 Display Appropriate Graph or Report
122. same plan alternative can be a member of and shared by more than one planning set in a plan study simultaneously This capability gives the planner complete control over the planning sets used for analysis and removes any restrictions that would be imposed by a planning set generator that is tied directly to a plan scenario analysis Within this open environment where planning sets may be created manually or may be imported from an export file planning sets are not limited to a fixed set of solution and scale combinations as they were in IWR PLAN version 3 33 Generated planning sets are now open such that plan alternatives can be added to or deleted from them or edited in the planning set manually Creating a New Plan Study To follow along with the case study described in the previous chapter simply create a new file and follow the procedures below To create a new file select New from the File menu and provide a name for the file as shown in Figures 13 and 14 Alternatively you may use the default Plan Study that IWR Planning Suite automatically creates the first time you start it H IWR Plan Planning Study Planning Study 1 Planning Set 1 gL File Edit view Window Analyze Results Generator Help Save OS Import Export Optimize Database Page Setup Print Preview Print Figure 13 Creating A New Study Plan 42 A Section 5 Software Terms and Procedures tt WR Plan Seti E Ele Edt Yew Window A
123. sen To do so the plan of interest attribute of the row is marked in the planning set editor At this time if the planning set was generated by the Plan Generator Module a more appropriate name for the plan say for example than A1B0C4D2 may be entered and associated with a specific plan alternative For example for a proposed Civil Works project there may exist a locally preferred plan which is a plan that is preferred by a non Federal sponsor of a Civil Works project In such a case it would be desirable during analysis to take particular note of this plan and its relationship to various plan alternatives during analysis This would be a case where designating the locally preferred plan as a plan of interest would be useful Distinguishing between a variable and an attribute Here are some useful tips to help you to remember what a variable is used for as opposed to the use of an attribute As previously stated a variable is an intrinsic characteristic of a plan alternative while an attribute identifies a characteristic that may change for a given alternative between different planning sets A 37 Section 5 Software Terms and Procedures The result of this distinction is that variable values are the same for a particular plan alternative in any planning set in a plan study For example in the planning study My Plan Study in all planning sets that use Plan A the Cost variable of Plan A will have the same value
124. ses Cancel My Network File name Bussey mdb ae Figure 78 IWR Plan Version 3 33 Dialog When the importation process is complete an informational message box displays indicating SUCCESS Select IWR PLAN Version 3 33 Database For Import My Recent Documents Desktop IWR Plan Version 3 33 Import Complete E f y Solutions Scales Effects and Variables have been imported Fram y database CA IWRPLON DataBusseyD1 mdb My Documents EL hy Computer My Network File name Bussey01 mdb Open Places Files of type Access Databases Cancel Figure 79 Import Complete Message Box Section 5 Software Terms and Procedures Export Planning Set To export IWR Planning Suite data to other programs and file formats navigate to the Export popup menu from the main menu File popup menu see Figure 80 W IWR Plan Planning Study Planning Study 7 Planning Set 1 a File Edit view Window Analyze Results MCDM Help E Man gt Ed l 1 La Mbt a OO Save Os Cost Import Y Optimize Database Excel Spreadsheet k Page Setup po Print Figure 80 Export to Excel Then select the format in which you wish to export currently only Excel file formats are supported from the Export function An Export dialog will appear see Figure 81 El IWR Plan Planning Study Planning Study 1 Generated Set 3 Generated i aQ File Edit v
125. sheet into the IWR Planning Suite planning study Figure 75 Clicking the Cancel button will close this dialog without importing solutions plans or variables into IWR Planning Suite Import from MS Excel Excel Spreadsheet Planning Set Hame Imported 5 preadsheet M Select an Import Format Import Solutions and Variables Rows are variables columns are solutions Rows are solutions columns are variables Plan level Import Rows are plans columns are variables Example of Selected Format Ay l C 1 Solution Scale Gost FishHU s BirdHLs 2 Aerate 4 1 397 22 3 Dredge D 1 102 24 4 Harvest H 1 af 0 Figure 75 Initiate Importation Please note that the import procedure will overwrite any existing data in the currently open IWR Planning Suite file see warning message in Figure 76 Overwrite Planning Study with Import E One or more generated or analysis plan sets exist Select Yes to overwrite the current planning study Select Mo to create a new planning study to import into Select Cancel to cancel the import Figure 76 Overwrite Option Section 5 Software Terms and Procedures To avoid overwriting existing data first open a new IWR Planning Suite data file from the main menu before beginning the Import procedure If analysis plan sets exist you will be prompted by the dialog above asking whether you want to overwrite the current plan study Click Yes to overwrite it click No to create a new
126. sion in the group from the pull down pick list The user then can enter in minimum and maximum acceptable values for each variable Note that IWR Planning Suite automatically provides a minimum value for each variable of 0 and a maximum value for each variable of 9 999 999 999 The user must edit these values as appropriate 66 A Section 5 Software Terms and Procedures To define a constrained planning set navigate to the Constraints dialog Figure 43 by clicking constraints on the toolbar Figure 44 Constrain Active Planning Set Variable Minimum ale Masinurn value Costs 3999999999 39999999595 3999999999 93399999999 9999999999 9999999999 9999999999 9999999999 9999999999 9999999999 Constrained Planning Set Name Constrained Plan 2 Figure 43 Constraints Dialog 1 IWR Plan Planning Study Salt River Planning Set 1 a l File Edit view Window Analyze Results Generator Help o amp Xx s Y CW Riparian Y OpenWater Y TotalOutput Y bo Action Plan I O O O Figure 44 Constraints Icon When defining constraints you must first specify a name to be used for the constrained planning set Figure 45 The name can be comprised of any combination of alphanumeric or 2 0 A punctuation characters and can be up SS 33343973 to 15 characters in length Next you E JIJ would select the variable to be 3333333333 3999999999 constrained After the variable has 3333333393 3933399993 been se
127. size For example a scale of 10 25 50 and 100 units may be used in the same analysis if it makes sense to do so m Practical Some solutions may be implementable over very few scales Some measures may be elther or measures that are not possible or reasonable to size and there is only one scale to consider For example although different sized areas may be considered natural revegetation may be a single scale measure either it does or it doesn t naturally revegetate Administrative actions such as requiring a permit or a license may also be single scale measures for example either a license is required or it isn t Equipment is often available in only a single size or relatively few sizes for example water pumps with fixed pumping capacities Minimum and maximum sizes could be a basis to bound a range of scales For example a bird may require a deciduous shrub cover between 1 0 foot and 3 0 feet in height Planting schemes that would provide lesser or greater cover heights would not meet the requirement and need not be considered Where a large number of scales is possible the analyses could be initially limited to analyzing only the largest and smallest sizes high low analysis or high middle low sizes to bound and scope the range of costs and outputs subsequent iterations could then be conducted for the more promising scales m Revealing The number of scales should be adequate to reveal significant changes in
128. sting stands of salt cedar must be removed so solution 5 is dependent on solution 3 Creation of open water areas will also inhibit the re establishment of salt cedar in the area 30 A Section 4 Case Study Solution 6 Create Riverine and Fringe Wetlands Within River Channel This solution would entail excavation and grading of sand and cobble areas to appropriate elevations within the river channel adjacent to open water areas and along the edge of the river channel to create riverine and fringe wetland areas Water would be supplied from nearby open water areas and residual flow from riparian corridors Wetland plants would be planted These wetland areas would provide habitat for various aquatic bird amphibian reptilian and mammalian species One to 5 wetland areas of 120 acres each would correspond to scales of 120 240 360 480 and 600 acres Before this solution can be implemented the existing stands of salt cedar must be removed so solution 6 is dependent on solution 3 Creation of wetlands within the river channel area will also inhibit the re establishment of salt cedar Costs and Outputs The important variables that must be considered in any cost effectiveness and incremental cost analyses CE ICA are the costs and outputs of the proposed solutions In this study the implementation and operation and maintenance costs in dollars of each proposed solution and scale were calculated by cost estimators and converted to an average
129. t See Figure 36 Steps 1 4 and Figure 37 Steps 5 6 the user must complete the following information on the Automated Editing form Automated Edits Tey OFENWAT _ Uverbank OVERBAN _ Validated Whee A Or ACi n At Acfon Siar atau dani And DFPE Nw ATER Automated Edits Name Conditions Function Ke Costsawng FLOWREG Or INCHANN FLOW REG MINE Figure 37 Defining Automated Editing Functions 1 Edit Group Name Required The user must provide a unique edit group name up to 15 characters in length for each individual automated edit he she wishes to perform Enter CostSaving2 as the edit group name now 2 Variable Required The user must specify the variable on which the automated editing will be performed by clicking to select from the pull down list next to the variable field Select cost from the pull down list Section 5 Software Terms and Procedures 3 Add a new edit Press this button to add a new automated edit 4 Function Required In this field the user specifies the editing function to be performed on the variable The default function that first appears in the Function field displays IWR Planning Suite s additive assumption 1 e each solution s value for that variable is added together to yield that combination of solutions value for that variable In the default case the 1 s indicate that a coefficient of 1 will be multiplied by each of the solution
130. te Help untada 97 Figure g0 he Help A DOUL DIO ES AS A AAA 98 A vii Figures viii List of Tables Table 1 Examples of Environmental Management Measures cccocccoccnoncnonconnnnncnnncnnnonncnnnonnnonnnonncnnnons 12 Table 2 Examples of Current Corps Environmental Programs ce ceeeeseeseeeeeeseeeseceeeeseeeseenaeeeeees 13 Table 3 All Combinations of Management Measures ce eeeescssecseeseesseceseceeeeeessecesecseeeseesaeeneees 17 Table 4 Costs and Outputs of Solutions and Scales 00 0 eee eeeeeseceseeeeeeeseeeseessceceeeceaeeeaeeeseeeseeeseeesees 31 Table 5 Outputs Acres and Quality Index Values of Solutions and Scales eeeeeeeeeee 33 Table 6 Composite Outputs Acres X Quality Index Values ooooonnconncninonoccnocononconncnnnnoncnnncnnnonncnnnons 33 Table 7 Variable Names Descriptions and Unii 10 does 48 Tables SOON lll oia gas 52 Table 9 Solu OMS and Edesa 54 Table TO Dependency Relatl ONSMPS spa 58 Table 11 Antomated Edtins FANCHON anres aa da E 63 Table 12 Variable and Solution Combination Sensitivity eee eeesseeceseeseeeseeceeecsseceseeeseeeseeeseeeeees V2 Tables Acknowledgements IWR Planning Suite is being developed within the US Army Corps of Engineers Corps Decision Methodologies Research Program conducted by the Corps Institute for Water Resources IWR Darrell Nolton directs the research program Bob Pietrowsky is the Director of IWR The Headquarters program monitor and advisor for the research p
131. ted to evaluate the effects of alternative plans First it must be shown through cost effectiveness analysis that an alternative restoration plan s output cannot be produced more cost effectively by another alternative Cost effective means that for a given level of non monetary output no other plan costs less and no other plans yields more output for less money Subsequently through incremental cost analysis a variety of implementable alternatives and various sized alternatives are evaluated to arrive at a best level of output within the limits of both the sponsor s and the Corps capabilities The subset of cost effective plans are examined sequentially by increasing scale and increment of output to ascertain which plans are most efficient in the production of environmental benefits Those most efficient plans are called Best Buys They provide the greatest increase in output for the least increases in cost They have the lowest incremental costs per unit of output In most analyses there will be a series of Best Buy plans in which the relationship between the quantity of outputs and the unit cost is evident As the scale of Best Buy plans increases in terms of output produced average costs per unit of output and incremental costs per unit of output will increase as well Usually the incremental analysis by itself will not point to the selection of any single plan The results of incremental analysis must be synthesized with
132. th it analysis are equally valid for problems related to water and air quality hazardous and toxic wastes aesthetic resources cultural resources and any other type of resource So long as the basic measurement requirements are met any non monetary output should be amenable to the essential analyses of these procedures Measuring Outputs Every output is measured using a technique that measures changes in terms of a metric or measurement unit There is no single universal all purpose unit of environmental output 18 A Section 2 Plan Formulation nor is there a single universal all purpose measurement technique Traditional metrics for measuring environmental outputs have included m Physical dimensions such as acres miles days etc m Population counts of a species or guild number of wading birds for example a Habitat units are a product of the Habitat Evaluation Procedures U S Fish and Wildlife Service 1980 also referred to as HEP as well as several other habitat based evaluation methodologies similar to HEP While the original HEP applications focused on single species recent HEP like procedures focus on communities and may measure community units or similar metrics Other less commonly used metrics include measurements of biodiversity productivity and risk Again there is no one way to measure environmental outputs that will apply in all cases Each study must determine the best
133. than through the plan generation component because they apply to variables and attributes not to individual solutions and scales Of course both modules can be used simultaneously on the plan study s active planning set through the common user interface of the plan editor infrastructure so that the user s current workflow is retained The plan generation module will automatically generate a Planning Set from a set of solutions and scales using the same mechanisms available in the current The IWR Planning Suite application It generates a planning set directly to the IWR Planning Suite database and like all the default IWR Planning Suite modules this active planning set in the database is associated with the current plan study A plan study may contain many planning sets derived from the generated planning set by various mechanisms such as an analysis applied to a planning set but it may contain only one planning set that has been created by the plan generator The solutions scales combinability and dependency relationships which together determine the full set of plan alternatives which may be generated are defined by the user Additionally automated edits constraint groups and solution sensitivities are defined The complete process which corresponds closely to the existing IWR Planning Suite interface workflow follows Generated planning sets will be displayed with some information that will assist planners in managing them and keeping
134. the Civil Works Program This guidance underscores the importance of cost effectiveness and incremental cost analysis in ecosystem restoration planning The circular states that Cost effectiveness analysis and incremental cost analysis are fundamental concepts in project formulation and evaluation These analyses provide ways of thinking about outputs resulting from the various levels of expenditures Ecosystem restoration studies differ from traditional studies only in that not all benefits are monetized A cost effectiveness analysis is conducted to ensure that least cost alternatives are identified for various levels of environmental output After the cost effectiveness of the alternatives has been established subsequent incremental cost analysis is conducted to reveal and evaluate changes in cost for increasing levels of environmental output Although incremental cost analysis does not provide a discrete decision criterion such as the maximizing of net benefits in NED analysis it provides for the explicit comparison of the relevant changes in costs and outputs on which such decisions should be made The Planning Guidance Notebook ER 1105 2 100 was revised in 2000 and contains the Corps current policy regarding the requirement to conduct cost effectiveness and incremental cost analyses for ecosystem restoration projects Paragraph E 36 states Cost effectiveness and incremental cost analyses are two distinct analyses that must be conduc
135. the upper right hand corner of the Solution Solution Is Not Combinable With Relationships form marked No Name Relationship Solutions Are Combinable EA CE e R S Figure 34 Step 1 When this box is checked the IWR Planning Suite will automatically prevent any solution from being combined with another As with dependency relationships click Remove Salt Cedar the solution you want to define a NF cance non combinability relationship for Figure 34 step 3 check the Figure 34 solutions it is not combinable Combinality Relationships with Figure 34 step 4 and when done press the OK button Figure 34 step 5 No combinability relationships will be entered at this point in the tutorial When finished defining relationships click the OK button to save the defined relationships Automated Editing Automated editing is a feature which allows the planner to automatically account for the fact that a group of plan effects to be generated may not be a matter of simple addition of solution effects A mathematical function is entered to describe complex additive effects for a set of solution combinations To define an automated edit an edit group name applicable variable additive function and logical condition for application of the edit are entered in an automated Section 5 Software Terms and Procedures edit group entry form During plan generation the automated edit entries are used in place of simple addition
136. time if the planning set was generated a more appropriate name for the plan of interest may be entered and associated with a specific plan alternative Plans of interest are defined by marking the Plan of Interest checkbox in the plan editor for each plan deemed to be interesting Each Plan alternative has a Plan of Interest attribute but this attribute is hidden by default It may be displayed by bringing up the Plan Study dialog and clicking the Hidden property of the Plan of Interest Attribute thereby Planning Study un checking it in the Plan Study Name Ear Study Attributes table R Description Salt River floodplain ecosystem restoration Figure 46 The Plans of Interest Yanables checkbox allows the user to Mame We Unt we Des Y Derr Denved Function Y Hidden Y specify particular plans as 1000 O O plans of interest Initially CwRiparian Acres Cotton FJ O dada ewa Acres fow O o cid ceca O Co displays a planning set the wams Aces weld EJ Plan of Interest column will appear blank since no plans of interest have yet Attributes been defined e Y Type Y Description 7 Cost Effective Number Non Cost Effective Cost Effe To enter a plan as a plan of 7 ACCES NEON LS AI AE interest click the Plan of Interest Checkbox on the Cada plan alternative deemed to be of interest see Figure 47 Figure 46 Plan Study Attributes 68 A Section 5 Software Terms and Procedures i
137. ting Page 1 of document Figure 90 Print Dialog 94 A Section 5 Software Terms and Procedures Exit To quit the IWR Planning Suite application select the File Exit option from the File menu as shown in Figure 91 iM IWR Plan Planning Study Planning Stu a File Edit View Window Analyze Results Save AS Import Export Optimize Database Page Setup Print Preview Print EMMAA Ml m had ce re i f a 1 l b Figure 91 Exit Edit Menu The Edit Menu is used to modify values in a planning set A value is selected in a planning set and a menu item is selected from the Edit menu to perform an edit operation on that selected value see Figure 92 8 IWR Plan Planning Set 1 oH File Edit View Window Analyze Results Generator et me Figure 92 Edit Menu Section 5 Software Terms and Procedures Edit Cut will remove the value and place it in the Windows Clipboard from which it can then be pasted into another location in the planning set The shortcut key for Cut is lt CTRL gt X Le pressing the Control key on the keyboard and the letter X at the same time Edit Copy will copy the value into the Windows Clipboard from which it can be pasted into another location in the planning set The shortcut key for Copy is lt CTRL gt C Edit Paste will paste any value in the Window
138. tion combinations have sensitivity that need to be defined Enter the coefficients from Table 12 below now by the methods described above TABLE 12 VARIABLE AND SOLUTION COMBINATION SENSITIVITY Solution Code Variable Low Coefficient High Coefficient F Cost 1 D Cost Save Plan Study Now that we have fully defined variables and solutions we are ready to save a basic plan study The Save As form allows the user to save a plan study To save a plan study navigate to and click on the Save As form on the File menu of the main menu bar Figure 53 If any plan studies currently exist clicking Open under the File menu loads the Plan Study i WR Plan Planning Study Salt River Generated Set 2 Gene L File Edit View Window Analyze Results Generator Help ma fi A A L sts vWetlandsv CW Ripari aimee gt gt fo a Export d fe 0 Optimize Database E e as po meee fe fo porte es Jo fers sa F2O 1 ROSOW Ol 119 101 25 0 Figure 53 File Menu The Save Plan Study As dialog Figure 53 will allow a Plan Study to be saved in two steps The first step is to give the plan study a name The Plan Study name is required and can be made up of any combination of alphanumeric characters up to 15 characters in length spaces 72 A Section 5 Software Terms and Procedures are not allowed in the name however Since IWR Planning Suite will use plan study names in the titles of v
139. tion project is to restore the degraded ecological resources of the Salt River and associated floodplain Incidental recreation benefits are expected A planning constraint is that the proposed restoration measures should not increase flood damages to nearby residences and farms if possible the measures should contribute to the reduction of flood damages There are several manifestations of the degraded environment in this part of the Salt River floodplain Riparian vegetation including cottonwood willow and mesquite vegetative covers both native to the riparian zones of the study area has been greatly reduced in aerial extent during the last 50 years This is due primarily to the reduction of surface water flow volumes in the Salt River channel Upstream water diversions and consumption are primarily responsible for the reduction in surface water flows in the study area Reduced flow volumes have negatively impacted the availability of surface and groundwater to support the cottonwood willow and mesquite vegetative cover types As a result approximately 1 000 acres of the previously mentioned cover types have been lost in the study area in the last 50 years Both cottonwood willow and mesquite riparian woodlands provide valuable habitat for many native Sonoran Desert bird and mammal species including the Yuma clapper rail a state listed sensitive species and the cactus wren The former and existing riparian corridors also provide important resting
140. tiveness and Incremental Cost Analyses What They Are Not Prior to elaboration of what cost effectiveness and incremental cost analyses are consider some things that the analyses are not For example cost effectiveness and incremental cost analyses are Not the planning process but you have to understand the planning process to understand the role of the analyses Not a technique to measure or forecast environmental outputs the analyses do not measure or forecast the environmental effects of plans but that information provided through other techniques is required to conduct the analyses Not a technique for monetizing environmental outputs the analyses will not place monetary values on measurements of environmental outputs but rather the analyses will compare monetary costs against non monetary outputs across solutions Not a way to reduce or eliminate environmental requirements rather the analyses can show how to meet requirements and keep costs down or how to maximize output for a given expenditure level and Not a method that identifies a single right or optimal solution unlike benefit cost analysis no single plan like a National Economic Development NED plan will emerge as the optimal selection however the analyses provide the types of information that will support the selection of a single plan And a final disclaimer There is no single right way to conduct cost effectivenes
141. tools to assist in decision making The results of the analyses which can be displayed as graphs of outputs against costs permit decision makers to progressively compare alternative levels of environmental outputs and ask if the next level is worth it In other words is the additional environmental output in the next attainable level worth the additional cost Typical examples of cost effectiveness and incremental cost graphs are included in Figure 1 Total Cost Incremental Cost 0 0 0 E Figure 1 Cost Effectiveness Analysis Incremental Cost Analysis Incremental Cost Analysis Why Conduct Cost Effectiveness and Incremental Cost Analyses The planning paradigm in the P amp G provides a rational and deliberate approach to solving problems and making decisions Such decision making requires information for example information about future environmental conditions with and without the implementation of each alternative plan under consideration The cost effectiveness and incremental cost analyses procedures in this manual are intended to organize and communicate the types of information needed to support the decision making process Figure 2 shows some tools of economic analysis that can be used to provide varying levels of information to support decision making This decision support continuum ranges from cost oblivious decision making ignore all information about costs to benefit cost analysis a mathematical comparison of be
142. u may use a different type of output for each objective Using multiple outputs will complicate but not necessarily overwhelm your analysis See Chapter Five for a discussion about how you can handle the apples and oranges problem of multiple outputs called commensuration Outputs are the intended results of implementing solutions In this sense they are the analytical equivalent of traditional economic benefits Outputs like traditional dollar benefits are a special type of what many of us refer to as environmental impacts The difference is that outputs are the desired and intended effects of solutions we re trying to create them while impacts usually refer to the full range of effects both undesirable and desirable and unintended and intended Note that although our primary concern here is with environmental outputs the full range of effects including other environmental and social impacts must be assessed for environmental restoration and mitigation solutions For example the impacts of a wetland restoration project on lost upland habitat displaced upland wildlife relocated structures and utilities and other impacts should also be assessed Although we have focused our discussions on fish and wildlife and ecosystem related outputs the procedures described in this manual can be applied to a wide range of other outputs The basic questions posed in these procedures culminating in the Is it wor
143. use the term variables to denote these costs and outputs Variables are the categories upon which the effects of alternative plans will be compared and upon which cost effective and incremental cost analyses will be performed A minimum of two variables must be defined for A 45 Section 5 Software Terms and Procedures cost effectiveness and incremental cost analyses a cost variable and an output variable Examples of output variables might include habitat units acres of wetlands stream miles restored number of salmon diversity indices etc Due to processing time considerations it is recommended that no more than ten variables be defined in an IWR Planning Suite data file The IWR Planning Suite also allows for the definition of derived variables which are included in the recommended count of ten or fewer variables Derived variables will be discussed in more detail later in this chapter Plan variables may be created or removed from all the planning sets in a plan study through a planning study structure editor in the Planning Study Properties dialog which displays the available variables and attributes of the planning sets in the study Once new attributes or variables have been added and defined via the planning study dialog the new variable and attribute values may be edited to insert values manually through the planning set editor To begin the process variables and derived variables for an analysis are defined within the plan study
144. ustrial water supply m Agricultural floodwater erosion and sedimentation reduction m Agricultural drainage m Agricultural irrigation Urban flood damage reduction Hydropower m Inland navigation 20 A Section 2 Plan Formulation Deep draft navigation Recreation Commercial fishing and Other categories of benefits See ER 1105 2 100 for a discussion of procedures for estimating these NED benefits Additional Corps guidance for estimating many of these benefits can be found in the Corps National Economic Development Procedures Manual Series see references Incidental benefits are monetary benefits that occur as unintended consequences of an environmental planning solution and incur no additional implementation costs In some ways they can be thought of as the opposite of opportunity costs Incidental NED benefits are incidental benefits in the same eleven categories listed above For example restoration of a wetland upstream from an urban center may provide incidental flood damage reduction benefits to the urban area Although incidental benefits are not costs to be included in cost effectiveness and incremental cost analyses they may nonetheless represent pertinent information for decision making If a solution provides significant incidental benefits these benefits should be displayed in the comparison of alternative plans A particular restoration alternative s incidental benefits may play an important
145. ve or exponential functions may be applied to these component variables along with many other standard mathematical operations They are thus added to the planning study and described in terms of a variable name description measurement units and a calculation formula Plan Alternative Attributes The plan alternative representation is enhanced by the ability to internally associate data items other than solutions scales costs and outputs with plan alternatives This new kind of plan alternative association is called a plan attribute An Attribute is a value or hierarchical structure of values associated with a plan alternative It is distinguished from a variable in that it identifies a characteristic of the entire plan alternative rather than being an intrinsic part of the plan alternative An attribute is connected to a plan alternative associated with a particular planning set In other words two attributes of the same name connected to the same plan alternative may have two different values in two different planning sets In IWR Planning Suite an attribute is a named label with a textual or numeric value associated with it Some examples of attributes are Cost Effective Plan of Interest and Rank Attributes applicable to the analysis may be defined such as a plan of interest attribute to be used by reporting and visualization modules Then once the rows of the planning set are created individual plans of interest may be cho
146. way to measure outputs to meet its unique decision making needs Current Corps guidance provides flexibility in the measurement of outputs but states that outputs that measure ecosystem value and productivity are preferred According to ER 1105 2 100 paragraph 3 5 c 1 Ecosystem restoration outputs must be clearly identified and quantified in appropriate units Although it is possible to evaluate various physical chemical and or biological parameters that can be modified by management measures that would result in an increase in ecosystem quantity and quality in the project area the use of units that measure an increase in ecosystem value and productivity are preferred Some examples of possible metrics which may be used include habitat units acres of increased spawning habitat for anadromous fish stream miles restored to provide fish habitat increases in numbers of breeding birds increases in target species and diversity indices Alternate measures of ecosystem value and productivity may be used upon approval by CECW P Monetary gains e g incidental recreation or flood damage reduction and losses e 2 flood damage reduction or hydropower associated with the project shall also be identified Ideally we should first define the output to be measured based on a planning objective then define the unit in which we will measure change in the output and finally select the measurement technique that will provide values in terms
147. y also be checked indicating that non cost effective cost effective and best buy plans will be indicated on the graph by different symbols and colors Once the analysis set graph type and the other desired options have been selected clicking the OK button will display the graph An example of a Cartesian x y All Plans Differentiated graph for a CE ICA analysis planning set is shown below Figure 62 In this example all plans are graphed by Cost and Output with the cost effectiveness Single Planning Set Graphs Report on Graph Type Cartesian x 4 graph Incremental Cost Box Graph rl Dual Asis Overlay f 3D Surface Plot f 3D Scatter Plot Plan Alternatives to Graph i All C Cost Effective l T ele 0 Best Buy fe eget A Figure 60 Selecting Graph Type i Differentiated status of each plan alternative differentiated by different colors and symbols The graphing tool allows the user many ways to customize the way in which the data is displayed The user may zoom in by holding the left mouse button down and dragging the rectangle to the area of interest Likewise the user may click on a point on the graph to see the data pertaining to that point Figure 61 The graph tool also allows the user to pick many different styles of viewing by right clicking on the graph The user may experiment with these options at his or her convenience 78 Section 5 Software Terms and Procedures Table Drill

IWRPS User`s Guide

Contents

Download Pdf Manuals

Related Search

Related Contents