Office of Operations Freight Management and Operations

4. Using FTAT

Figure 1 shows the components in the Freight Technology Assessment Tool.

Freight Technology Assessment Tool flow chart
Figure 1. The Freight Technology Assessment Tool

The tool may be used from two perspectives, either the "Business Process Mapping/Technology Evaluator" perspective or the "Expert Panel" perspective. Each perspective is summarized as follows:

The Business Process Mapping/Technology Evaluator Perspective:

  1. Defines/maps the different parties involved in the process.
  2. Defines the relationship between the different parties.
  3. Defines the business processes of each party.
  4. Defines cost drivers.
  5. Assigns cost drivers to business processes.
  6. Generates a list of the cost drivers associated with the business process.
  7. Inputs the as-is process cost.
  8. Inputs the as-is cost driver value.
  9. Defines qualitative measures.
  10. Assigns qualitative measures to business processes

The Expert Panel Perspective:

  1. Selects a technology to be evaluated or defines a new technology.
  2. Selects business processes that will be affected by the technology.
  3. Rates the technology against the list of qualitative measures generated.
  4. Runs the qualitative analysis using the Quality Function Deployment (QFD).
  5. Inputs the technology cost information.
  6. Inputs the to-be cost driver value.
  7. Inputs technology benefits information.
  8. Generates the output report.

Also, the Technology Evaluator or Expert Panel will have the right to:

  1. Add new processes, assign performance measures to new processes, and assign cost drivers to new processes.
  2. Add new performance metrics and assign new measures to processes.
  3. Add a new cost driver and assign a new cost driver to processes.

The integrated methodology presented in Figure 1 is described below.

4.1 Business Process Analysis

4.1.1 Business Process Mapping

The Business Process Mapping portion enables a user to define and map the end-to-end business process. A user identifies business processes by documenting business units on a geographical map and assigning processes to business units by selecting from a predetermined list of processes or by defining new processes. The business processes can be mapped when users:

  1. Select Geographical Map from the left panel.
  2. Drag and drop a shape that identifies the node in the supply chain from the Supply Chain Stencil.
  3. Select the shape.
  4. Select Edit > Edit Node from the menu after which the Edit Business Processes window will open (Figure 2).

Screen shot of the Edit Business Processes window showing fields for name, basic business process elements applicable to this partner, and process description
Figure 2. Edit Business Processes

  1. Click the Add Process button at the bottom of the window, and the Processes window will appear (Figure 3).

Screen shot of the Process Category tab of the Processes window showing fields for category ID, category name, and definition
Figure 3. Processes – Process Category

  1. Add a Process Category (Figure 3): (The fields will be blank if no processes are added.)
    1. Type Category ID.
    2. Type the Category Name.
    3. Type the Category Definition.
    4. Click Update.
  2. Add a Process
    1. Go to Process tab (shown in Figure 4).
    2. Type Process ID.
    3. Type Process Name.
    4. Select the process Category ID from the drop-down menu.
    5. Type the Process Definition.
    6. Click Update and close window.

Screen shot of the Process tab of the Processes window showing fields for process ID, name, process category ID, and definition
Figure 4. Processes – Process

  1. Click Edit on the toolbar and select Edit Node, after which a window will pop up. The added process will now appear in the screen shown in Figure 2.
  2. Click boxes that apply to the supply chain partner.
  3. Click OK.
  4. Repeat steps 2 through 8 to add processes.
  5. Select two shapes to connect the nodes in the supply chain in their flow order by selecting the first shape then holding the Ctrl key and then selecting the second shape; to establish the connection, click Deliver or Return on the toolbar.
  6. After dragging and dropping all required shapes, select the one that is the focus of the study. Then click Processes on the toolbar or Edit > Edit Node from the menu and check the box next to the name of the process to indicate the node that is the focus of the study. If you don't, the program will select a default focus.

4.1.2 As-Is Processes Cost

The Business Process Mapping/Technology Evaluator user can input the cost of each process. The as-is process cost can be defined when users:

  1. Click As-is Process Cost on the toolbar or select menu Edit > Process Costs.
  2. A Process List is generated based on the business process mapped; the window that will pop up is shown in Figure 5.
  3. Input the Annual Cost of each process.
  4. Click OK.

Screen shot of the Process Costs tab of the Process Costs window showing the instruction to please evaluate process costs for each supply chain partner listed below and showing list headings for SC partner, process, process name, and annual cost
Figure 5. Process Costs

4.1.3 Cost Drivers

The Business Process Mapping/Technology Evaluator user can generate a list of predetermined cost drivers or add a new cost driver. A new cost driver can be added when users:

  1. Click the toolbar and select Edit > Cost Drivers; a window will pop up (as shown in Figure 6).

Screen shot of the Cost Drivers tab of the Processes window showing fields for process ID, cost driver, definition, and selected cost drivers for the process and buttons for delete, add, and close
Figure 6. Cost Drivers

  1. Add a Process Cost Driver:
    1. Select Process ID from the drop-down menu.
    2. Type Cost Driver Name.
    3. Type the Process Definition.
    4. Click Add.
    5. Close window.
    6. Repeat steps 1 and 2 to add other cost drivers.

4.1.4 As-Is Cost Driver Values

Business Process Mapping/Technology Evaluator users can enter the as-is value of a generated list of predefined cost drivers or newly added cost drivers. A cost driver is defined as the value that drives the cost of the process up or down. A cost driver value can be added when users:

  1. Click As-is Process Cost on the toolbar or select menu Edit > Process Cost, then select the Cost Drivers tab (as shown in Figure 7).

Screen shot of the Cost Drivers tab of the Process Costs window showing the instruction to please evaluate process costs for cost drivers for each supply chain partner listed below and showing list headings for SC partner, process, process name, cost driver, as-is value, and units
Figure 7. Cost Drivers

  1. A Cost Drivers list is generated.
  2. Input the "As Is" Value of each process.
  3. Input unit information on the cost driver (e.g., year) by typing in the unit value or by selecting from the drop-down menu.
  4. Click OK.

4.1.5 Performance Measures

Business Process Mapping/Technology Evaluator users can generate a list of predefined performance measures or add a new performance measure when they:

  1. Select Performance Measures from the left panel.
  2. Click the Add button below the right panel to cause a window to pop up (as shown in Figure 8).

Screen shot of the Performance Measure tab of the Performance Measures window showing fields for performance measure name, class, attribute, and definition
Figure 8. Performance Measures

  1. Input the information related to the new performance measure:
    1. Type Performance Measure Name.
    2. Type Performance Measure Class.
    3. Select Performance Measure Attribute from the drop-down menu.
    4. Type Performance Measure Definition.
    5. Click Processes tab.
  2. When users select the Processes tab shown in the window above, a new window will open (as shown in Figure 9).

Screen shot of the Processes tab of the Performance Measures window showing the instruction to select all the processes that are associated to this performance measure and showing fields for processes and selected processes
Figure 9. Performance Measures Processes

  1. Assign Processes that apply to the new performance measure:
    1. Select a Process from the left.
    2. Click (>>) button or double-click the Process.
  2. Click OK.
  3. Repeat steps 1 through 6 to add other performance measures.

4.2 Technology Evaluation

The quantitative analysis is the second phase of the technology evaluation methodology used by the Freight Technology Assessment Tool. The tool enables the user to assess a technology (or a group of technologies) quantitatively by computing a set of financial measures for each technology. The financial measures include the net present value (NPV) of the technology(ies), internal rate of return (IRR), payback period, discounted payback period, and the benefit-cost ratio. To compute these financial measures, the user has to input some financial data for each technology. The inputs include technology costs (initial investment and annual costs), the useful life of the technology, and the required rate of return. The expert panel will add the to-be cost driver value to the technology benefits input (annual anticipated gains and cost reduction) related to processes (as-is process cost and as-is cost driver value during the business process mapping phase). The as-is process cost, the as-is cost driver, and the to-be cost driver will be used to compute the to-be process cost from which the process improvement cost will be computed. The process improvement cost is a direct input to the technology benefits.

4.2.1 Technology Selection/Rating

Expert Panel or Technology Evaluator users can define a new freight technology when they:

  1. Select Technologies from the left panel.
  2. Click the Add button from the toolbar below the right panel, after which a window will pop up (as shown in Figure 10).

Screen shot of the Technology tab of the Technology window showing fields for technology name, class, and definition
Figure 10. Technology

  1. Type Technology Name.
  2. Type Technology Class.
  3. Type Technology Definition.
  4. Click Update.

4.2.2 Select Processes

Users must select processes that a particular technology will impact. To select processes, the user must:

  1. Click Next or select the Processes tab, after which a window will be displayed (as shown in Figure 11).

Screen shot of the Processes tab of the Technology window showing the instruction to select all the processes that are influenced by this technology and showing fields for technology name, class, and definition
Figure 11. Technology – Process

  1. Select Processes to identify what the technology will impact.
    1. Double click the process or click the (>>) button to move it to the right.

4.2.3 Performance Measures Ratings

The Expert Panel or Technology Evaluator user rates the technology with respect to performance measures. The ratings range from -5 to +5 (in increments of 1), where a negative rating indicates the technology downgrades the performance measure, a zero rating indicates the technology does not affect the performance measure, and a positive rating indicates the technology enhances the performance measure.

  1. Click the Rating tab or Next button, after which a window will pop up (as shown in Figure 12):

Screen shot of the Rating tab of the Technology 1 window showing the instruction to please rate this technology against the following performance measures and showing list headings for performance measure and rating
Figure 12. Intermodal Database – Rating

  1. A list of performance measures will be displayed.
  2. The Expert Panel user will select a measure and use the drop-down menu under Rating to rate the performance measure.

The completion of performance measure rankings is the first step toward evaluating a particular technology. The user will repeat the same step for other technologies, then move on to the next step, Quality Function Deployment (QFD), which qualitatively assesses a technology or group of technologies.

4.2.4 Technology Cost Information

The user will select a technology or define a new technology, then enter financial information for each technology as follows:

  1. Click Next or select the Costs tab. A window will pop up with the Cost fields that need to be populated (as shown in Figure 13).

Screen shot of the Costs tab of the Technology window showing fields for initial investment dollars, operating cost per year, maintenance cost per year, other costs per year, useful life, and MARR
Figure 13. Technology – Costs

  1. Under Costs, type in Initial Investment, Operating Cost, Maintenance Cost, Other Costs, and Useful Life.

4.2.5 To-Be Cost Driver Values

The Expert Panel or Technology Evaluator user enters cost driver values based on the as-is process costs and as-is cost drivers defined and entered in the tool by the business process mapping user. To-be cost drivers can be populated when users:

  1. Click Next or select the Drivers tab. A window will pop up (as shown in Figure 14).
  2. Add the To-Be Cost Driver Value for each process

Screen shot of the Drivers tab of the Technology 2 window showing the instruction to please evaluate the financial impact of this technology based on the followng cost drivers and showing list headings for SC partner, process, cost driver, as-is value, to-be value, and units
Figure 14. Intermodal Database – Drivers

4.2.6 Technology Benefits Information

The Expert Panel or Technology Evaluator user will enter the monetary benefits of each technology. Benefits can be populated when users:

  1. Click Next or select the Benefits tab. A window will pop up with the Benefits field to be populated (as shown in Figure 15).

Screen shot of the Benefits tab of the Wireless dispatch window showing fields for process improvement dollars, reduced insurance per year, reduced pilferage per year, reduced customs per year, and other benefits per year
Figure 15. Wireless Dispatch

  1. Add all Benefits: Reduced Insurance, Reduced Pilferage, Reduced Customs, and Other Benefits.

That was the last step to be carried out in the integrated methodology. Up to this point the technologies were evaluated qualitatively and quantitatively. The final output of the methodologies is summarized in a table format with columns representing different technologies and rows representing qualitative criteria (i.e., performance attribute scores and total score) and quantitative criteria (i.e., financial measures such as IRR, NPV, and benefit-cost ratio).

  1. Click Close
  2. Repeat steps in section 4.2.1 through 4.2.6 to evaluate additional technologies.

4.2.7 Quality Function Deployment (QFD)

The QFD portion enables the user to asses a technology qualitatively (or group of technologies) by generating a total score for each technology. The QFD analysis can be executed after defining the business process and rating the technology against the performance measures. The total score is computed automatically for each technology, given that an Expert Panel has rated the technology against the list of performance measures. The QFD (shown in Figure 16) can be executed when users:

  1. Select QFD from the left panel.
  2. Select menu View > Update.

Screen shot of the Quality function deployment matrix, showing rows of performance metrics aligned per performance measures, intermodal database, wireless dispatch, and other technologies
Figure 16. QFD Matrix

The QFD matrix, which consists of performance metrics (rows) grouped by performance attribute and technologies (columns), will be generated; it is populated with the ratings of each metric for each technology. The total score of each technology will be computed below the QFD matrix.

The primary QFD execution gives equal weight to performance attributes. However, relative weights of the seven attributes can be altered to change the focus of the QFD analysis. For example, if the user would like to select a technology that increases the relative weight of security measures, the user would:

  1. Click Attribute Weights from the toolbar in the QFD screen.
  2. A window will pop up with seven attributes, all selected by default and weighted equally (as shown in Figure 17).

Screen shot of the Attribute Weights window showing the instruction to please specify the relative importance of each of the following performance measures atributes and showing sliding tabs next to attributes labeled reliability, responsiveness, flexibility, cost, assets, safety, and security
Figure 17. Attribute Weights

  1. Select required performance attributes; deselect attributes that do not apply whatsoever.
  2. Increase the weight of an attribute relative to all the other selected attributes' weights by moving the scale.

4.2.8 Final Output

The final output includes a summary report of the qualitative and the quantitative analysis of each technology, including its performance score, net-present value, internal rate of return, payback period (years), discounted payback period (years), and benefit-cost ratio.

The output summary can be generated by:

  1. Selecting the output summary from the left panel.
  2. Selecting menu View > Update.

4.2.9 Output Reports

Several output reports may be generated for a project and may be accessed by selecting View > Report, after which a window will pop up like the one shown in Figure 18.

Screen shot of the Main Report tab of the Technology Assessment Reports window showing a list of processes with the ID, name, and definition for each process
Figure 18. Reports

Reports can be generated for:

  • Processes.
  • Performance Measures.
  • Process Costs.
  • Technologies.
  • As-Is Cost Drivers.
  • Technology Ratings.
  • Technology Assessments.

The user can print displayed reports by clicking the printer icon on the toolbar.

4.2.10 Export to Excel

The user can export the QFD worksheet and the output summary to Excel by selecting File > Export to Excel.

previous | next
Office of Operations