The National Academies Press

Currently Skimming:

Pages 63-98

The Chapter Skim interface presents what we've algorithmically identified as the most significant single chunk of text within every page in the chapter.
Select key terms on the right to highlight them within pages of the chapter.

From page 63... ... 63 This section details two tools developed to support agencies implementing cross-asset resource allocation approaches: a spreadsheet tool that implements the NCHRP Report 806 framework outlined in Chapter 2, and a web-based tool that demonstrates implementation of a web service for automating DEA analysis and helping visualize cross-asset allocation results. Cross-Asset Resource Allocation Spreadsheet Tool This section provides step-by-step guidance for using the Cross-Asset Resource Allocation Spreadsheet Tool (CARATS) Read the entire page →
From page 64... ... 64 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation Using the Tool This section explains the input requirements, flow of the tool, and a step-by-step process of using the tool. Explanatory screenshots of the tool are shown throughout. Read the entire page →
From page 65... ... Tools for Supporting Cross-Asset Resource Allocation 65 in the Scoring worksheet and can obtain optimization results by adding inputs of user-based constraints in the Optimization worksheet. Home Figure 5-2 presents the home screen of the tool. Read the entire page →
From page 66... ... 66 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation c. After selecting an objective, select the preferred format of performance measure transformation (total or percentage) Read the entire page →
From page 67... ... Tools for Supporting Cross-Asset Resource Allocation 67 4. Prepare Decision Model: a. Read the entire page →
From page 68... ... 68 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation Figure 5-5. Project impacts worksheet with sample data. Read the entire page →
From page 69... ... Tools for Supporting Cross-Asset Resource Allocation 69 Custom Weighting If the user has pre-defined custom weights for the performance measures, the Custom Weighting worksheet is used to enter the weights. Figure 5-7 presents a screenshot of the Custom Weighting worksheet. Read the entire page →
From page 70... ... 70 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation Scaling The Scaling worksheet is used to normalize the performance impacts of projects on each measure. By default, the project impact values of each measure are scaled linearly from 0 to 1. Read the entire page →
From page 71... ... Tools for Supporting Cross-Asset Resource Allocation 71 Scoring The Scoring worksheet is a results worksheet that presents the ranking of projects based on different measures. The table has three project information columns, two overall score columns and one column for every performance measure score. Read the entire page →
From page 72... ... 72 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation Follow the flowchart [input] to redevelop the model. Read the entire page →
From page 73... ... Tools for Supporting Cross-Asset Resource Allocation 73 Figure 5-11. Resource allocation based on investment areas. Read the entire page →
From page 74... ... 74 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation to be built. The projects with No Build in this column in red are suggested not to build. Read the entire page →
From page 75... ... Tools for Supporting Cross-Asset Resource Allocation 75 higher, and thus the range of project costs may be much greater, varying by one or more orders of magnitude. It is assumed that all these projects impact the four measures consistent with what is intuitive. Read the entire page →
From page 76... ... 76 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation Step 2: Enter Project Data The second step is to input project details and their impacts on different performance measures in the Project Impacts worksheet. Add the project names, cost, and their investment areas in the first three columns. Read the entire page →
From page 77... ... Tools for Supporting Cross-Asset Resource Allocation 77 Project Name Fatal & Serious Injury Crashes No Build Build Project 1 10 0 Project 2 10 0 Project 3 9 7 Project 4 7 0 Project 5 9 2 Project 6 1 1 Project 7 1 1 Project 8 8 6 Project 9 1 1 Project 10 10 0 Project Name Fatal & Serious Injury Crashes No Build Build Project 11 8 8 Project 12 5 0 Project 13 7 1 Project 14 7 0 Project 15 8 2 Project 16 5 2 Project 17 9 2 Project 18 6 0 Project 19 8 1 Project 20 7 1 Table 5-3. Project impacts sample data -- fatal & serious injury crashes. Read the entire page →
From page 78... ... 78 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation Project Name Annual Toll-Fare Revenue No Build Build Project 1 0 137694 Project 2 0 145132 Project 3 0 132468 Project 4 0 130863 Project 5 0 0 Project 6 0 149161 Project 7 0 139322 Project 8 0 129650 Project 9 0 140653 Project 10 0 0 Project Name Annual Toll-Fare Revenue No Build Build Project 11 0 141715 Project 12 0 123755 Project 13 0 0 Project 14 0 0 Project 15 0 26097 Project 16 0 134800 Project 17 0 25669 Project 18 0 45698 Project 19 0 0 Project 20 0 0 Table 5-6. Project impacts sample data -- annual toll-fare revenue. Read the entire page →
From page 79... ... Tools for Supporting Cross-Asset Resource Allocation 79 Step 3: Add Weights The third step is to input relative weights of the performance measures. This can be done in two possible ways: if the agency does not have pre-defined weights for the measures, it can use the pairwise priority weights survey in the Weighting worksheet to get the tool-generated weights for the measures. Read the entire page →
From page 80... ... 80 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation Step 4: Scale the Impacts The fourth step is to scale the impact values for different measures for the overall analysis in the Scaling worksheet. This is done to normalize the different units of performance measures in the inputs. Read the entire page →
From page 81... ... Tools for Supporting Cross-Asset Resource Allocation 81 Step 5: Generate Scores The fifth step is to click the Scoring button on the Scoring worksheet. This prompts the tool to calculate the overall score, overall score/cost, and scores for each performance measure for each project and rank the projects based on overall score. Read the entire page →
From page 82... ... 82 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation Figure 5-21. Resource Allocation based on performance measures. Read the entire page →
From page 83... ... Tools for Supporting Cross-Asset Resource Allocation 83 Figure 5-22. Application of must fund constraint. Read the entire page →
From page 84... ... 84 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation Figure 5-23. Change in maximum allocation of one investment area. Read the entire page →
From page 85... ... Tools for Supporting Cross-Asset Resource Allocation 85 Figure 5-24. Change in minimum allocation of one investment area. Read the entire page →
From page 86... ... 86 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation Figure 5-25. Change in Upper Bound of one program objective. Read the entire page →
From page 87... ... Tools for Supporting Cross-Asset Resource Allocation 87 Figure 5-26. Change in lower bound of one program objective. Read the entire page →
From page 88... ... 88 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation Figure 5-27. Very Low overall budget with must-fund constraints. Read the entire page →
From page 89... ... Tools for Supporting Cross-Asset Resource Allocation 89 Figure 5-28. Very low overall budget with no must fund constraints. Read the entire page →
From page 90... ... 90 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation Figure 5-29. Very high overall budget. Read the entire page →
From page 91... ... Tools for Supporting Cross-Asset Resource Allocation 91 Tool Components The tool is composed of the following sections: • CARAT Home Page: Provides a basic outline of the tool and navigation buttons for other pages. • Load: Allows user to import project input data file. Read the entire page →
From page 92... ... 92 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation Figure 5-31. CARAT load page. Read the entire page →
From page 93... ... Tools for Supporting Cross-Asset Resource Allocation 93 Figure 5-32. CARAT edit page. Read the entire page →
From page 94... ... 94 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation Figure 5-34. Entering a budget. Read the entire page →
From page 95... ... Tools for Supporting Cross-Asset Resource Allocation 95 Visualize Page Figure 5-36 shows the Visualize page of CARAT. This page provides access to different graphical representations of the analysis results. Read the entire page →
From page 96... ... 96 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation the diagram are the different projects, and on the right side are the different goals or objectives. The proportion of the impact of each project on each goal is visualized by the width of the flow arrow from the project to the goal. Read the entire page →
From page 97... ... Tools for Supporting Cross-Asset Resource Allocation 97 Projects and Goals Percentage Contribution The Projects and Goals Percentage Contribution visualization is a bar chart that presents the contribution of each goal to the project's total score, shown as a percentage. The bars are coded for each measure and each stacked bar represents one project. Read the entire page →
From page 98... ... 98 Case Studies in Implementing Cross-Asset, Multi-Objective Resource Allocation Figure 5-40. Projects and goals actual contribution. Read the entire page →

From page 63...

... 63 This section details two tools developed to support agencies implementing cross-asset resource allocation approaches: a spreadsheet tool that implements the NCHRP Report 806 framework outlined in Chapter 2, and a web-based tool that demonstrates implementation of a web service for automating DEA analysis and helping visualize cross-asset allocation results. Cross-Asset Resource Allocation Spreadsheet Tool This section provides step-by-step guidance for using the Cross-Asset Resource Allocation Spreadsheet Tool (CARATS)