Freight and Fuel Transportation Optimization Tool Quick ...

Freight and Fuel Transportation Optimization Tool

Quick Start Scenarios Documentation

FTOT 2019.3 Public Release Version

DOT-VNTSC-FAA-19-07 DOT/FAA/AEE/2020-02

October 31, 2019

Prepared for: Federal Aviation Administration Office of Environment and Energy Washington, DC

Notice

This document is disseminated under the sponsorship of the Department of Transportation in the interest of information exchange. The United States Government assumes no liability for the contents or use thereof.

The United States Government does not endorse products or manufacturers. Trade or manufacturers' names appear herein solely because they are considered essential to the objective of this report.

Overview

2

REPORT DOCUMENTATION PAGE

Form Approved OMB No. 0704-0188

Public reporting burden for this collection of information is estimated to average 1 hour per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Washington Headquarters Services, Directorate for Information Operations and Reports, 1215 Jefferson Davis Highway, Suite 1204, Arlington, VA 22202-4302, and to the Office of Management and Budget, Paperwork Reduction Project (0704-0188), Washington, DC 20503.

1. AGENCY USE ONLY (Leave blank)

2. REPORT DATE October 31, 2019

3. REPORT TYPE AND DATES COVERED Document, 9/2018-9/2019

4. TITLE AND SUBTITLE

5a. FUNDING NUMBERS

Freight and Fuel Transportation Optimization Tool Quick Start Documentation: FTOT 2019.3 Public Release Version

FB48CS/SG287 and SG291

6. AUTHOR(S) Matthew Pearlson, Alexander Oberg, Olivia Gillham, Amy Vogel, Kristin C. Lewis, Scott Smith, Gary Baker

7. PERFORMING ORGANIZATION NAME(S) AND ADDRESS(ES) Volpe National Transportation Systems Center, 55 Broadway, Cambridge, MA 02142

9. SPONSORING/MONITORING AGENCY NAME(S) AND ADDRESS(ES) Federal Aviation Administration, 800 Independence Ave, SW, Washington, DC 20591

11. SUPPLEMENTARY NOTES

5b. CONTRACT NUMBER 693KA9-18-N-00022

8. PERFORMING ORGANIZATION REPORT NUMBER DOT-VNTSC-FAA-19-07

10. SPONSORING/MONITORING AGENCY REPORT NUMBER

DOT/FAA/AEE/2020-02

12a. DISTRIBUTION/AVAILABILITY STATEMENT

12b. DISTRIBUTION CODE

13. ABSTRACT (Maximum 200 words)

Volpe created the Freight and Fuel Transportation Optimization Tool (FTOT) to support the FAA, DOE, and the U.S. Navy's Office of Naval Research to assess optimal transport options for freight and fuel supply chains. FTOT is a flexible scenario-testing tool that optimizes the transportation of materials for future energy and freight scenarios. FTOT models and tracks commodity-specific information and can take into account conversion of raw materials to products (e.g., crude oil to jet fuel/diesel) and fulfillment of downstream demand. This report documents the Quick Start Scenarios developed to help the user explore the functionality of the FTOT public release 2019.3.

14. SUBJECT TERMS Freight, fuel, geospatial information systems, GIS, network analysis, transportation optimization.

15. NUMBER OF PAGES 49

16. PRICE CODE

17. SECURITY CLASSIFICATION OF REPORT

18. SECURITY CLASSIFICATION OF THIS PAGE

19. SECURITY CLASSIFICATION OF ABSTRACT

20. LIMITATION OF ABSTRACT

NSN 7540-01-280-5500

Standard Form 298 (Rev. 2-89) Prescribed by ANSI Std. 239-18

298-102

Overview

3

Quick Start Documentation

Overview

Assuming you've got FTOT installed (installation wiki is here: ), this is the place to learn how to run FTOT scenarios and view the results. After downloading the Quick Start scenarios, the directory and file path should look like this:

Figure 1: FTOT Quick Start Folder Structure

The Quick Start series is a set of simple scenarios designed to introduce supply chain modeling in FTOT. The first scenario (Quick Start 1) is the simplest. Each subsequent scenario demonstrates a different aspect of FTOT functionality. The seven Quick Start (QS) scenarios are summarized in the table below.

# Summary 1 Simple supply chain with no intermediate processing 2 Simple supply chain with intermediate processing 3 Candidate processing facilities are generated for the supply chain by FTOT 4 Supply chain with two intermediate processing steps; storage followed by conversion 5 Road network is excluded from the optimization, forcing FTOT To find alternative solutions 6 National supply chain with no road network 7 Processor takes two input commodities

Table 1: Quick Start scenarios summaries and complexity rating.

Complexity Low Low Med Med Low Med Low

Getting Started

? FTOT scenarios are stored C:\FTOT\scenarios\quick_start folder. Within this directory, each default scenario and exercise includes its own dedicated subfolder for storing the scenario configuration and outputs.

? FTOT is a command line tool that runs in a sequence of steps. ? Each scenario (e.g. qs1_rmp_to_dest\Default) contains a batch script file called run_v5_1.bat.* ? The batch script files are included in each of the Quick Start scenario folders to automate each step

required. ? You can run the batch script by double clicking it or manually executing it in the Command Prompt.

Overview

4

*If you were unable to install the ArcGIS 64-bit background geoprocessing, you should run FTOT in 32-bit by using the batch script files called run_v5_ 1_32bit.bat. This 32-bit option is not available for Quick Start 6.

During the Run

? Informational logging is available in the command shell during the run. Detailed logging is available in the .\logs folder.

? The logs are prefixed with a letter and timestamp indicating the FTOT step and time the log was generated.

? The user is encouraged to read the logs to familiarize themselves with the FTOT operations occurring during each step.

Results

? FTOT generates results in the .\Reports and .\Maps folders of the scenario. The reports and maps are also timestamped.

? The report is found in the .\Reports directory of the scenario. It is generated in the D step of the FTOT sequence. The FTOT report shows a summary of the results for each step in the analysis. The report is broken into the following sections: run time summary of each step, intermediate calculations and optimal results, configurations, warnings, and errors.

? A Tableau Dashboard (tableau_dashboard.twbx) can also be found in a timestamped tableau_dashboard folder within the .\Reports directory of the scenario. This can be opened in Tableau Reader.

? The map files can be found in the .\Maps directory of the scenario. The maps for the scenario are generated in the M step at the end of the FTOT scenario sequence. FTOT generates a series of maps for each FTOT step to help the user see what happens during the scenario.

For more information on interpreting results, see the complete FTOT Documentation, which can be found in the documentation folder you downloaded from (FTOT_Documentation_2019_3.pdf).

More information

The complete Quick Start documentation details the nuances of each run and provides brief overviews of the main results. Additional exercises are suggested at the end of some chapters. The user is encouraged to complete these exercises to become familiar with modifying a scenario before creating their own. It is highly recommended that the user read through the documentation for Quick Start 1, as that contains the most detail. The documentation for subsequent scenarios is more focused on highlighting the differences among scenarios and demonstrating various FTOT features.

Trouble Shooting

See the troubleshooting guide at the end of FTOT_Documentation_2019_3.pdf for tips on how to resolve common issues like runtime dependency errors (missing software), missing input data, and missing base maps.

Overview

5

Contents

Overview .....................................................................................................................................................................4 Table of Figures and Tables ....................................................................................................................................8

Executive Summary ................................................................................................................................................. 10 Quick Start 1 (QS1) - RMP to Destination................................................................................................................ 11

Purpose................................................................................................................................................................ 11 Input Data............................................................................................................................................................ 11

Geospatial Data ............................................................................................................................................... 11 Facility-Commodity Data ................................................................................................................................. 12 Running a Scenario .............................................................................................................................................. 12 Scenario XML File ............................................................................................................................................ 12 Run.bat Script .................................................................................................................................................. 13 Viewing Results.................................................................................................................................................... 14 FTOT Report..................................................................................................................................................... 14 Tableau Dashboard.......................................................................................................................................... 15 Maps ................................................................................................................................................................ 16 Exercises .............................................................................................................................................................. 17 Quick Start 2 (QS2) - RMP to Processor to Destination........................................................................................... 18 Purpose................................................................................................................................................................ 18 Input Data............................................................................................................................................................ 18 Geospatial Data ............................................................................................................................................... 18 Facility-Commodity Data ................................................................................................................................. 18 Running a Scenario .............................................................................................................................................. 20 Scenario XML File ............................................................................................................................................ 20 Run.bat Script .................................................................................................................................................. 20 QS2 Results .......................................................................................................................................................... 20 FTOT Report..................................................................................................................................................... 20 Tableau Dashboard.......................................................................................................................................... 21 Maps ................................................................................................................................................................ 22 Exercises .............................................................................................................................................................. 23 Quick Start 3 (QS3) - RMP to Candidate Processor to Destination ......................................................................... 24 Purpose................................................................................................................................................................ 24 Input Data............................................................................................................................................................ 24 Geospatial Data ............................................................................................................................................... 24

Overview

6

Facility-Commodity Data ................................................................................................................................. 24 Running a Scenario .............................................................................................................................................. 25

Run.bat Script .................................................................................................................................................. 25 Scenario XML File ............................................................................................................................................ 26 QS3 Results .......................................................................................................................................................... 27 FTOT Report..................................................................................................................................................... 27 Tableau Dashboard.......................................................................................................................................... 27 Maps ................................................................................................................................................................ 28 Quick Start 4 (QS4) - RMP to Processor 1 to Processor 2 to Destination................................................................ 30 Purpose................................................................................................................................................................ 30 Input Data............................................................................................................................................................ 30 Geospatial Data ............................................................................................................................................... 30 Facility-Commodity Data ................................................................................................................................. 30 Running a Scenario .............................................................................................................................................. 31 Run.bat Script .................................................................................................................................................. 31 Scenario XML File ............................................................................................................................................ 31 QS4 Results .......................................................................................................................................................... 32 FTOT Report..................................................................................................................................................... 32 Tableau Dashboard.......................................................................................................................................... 32 Maps ................................................................................................................................................................ 33 Quick Start 5 (QS5) - RMP to Destination, No Road ................................................................................................ 34 Purpose................................................................................................................................................................ 34 Input Data............................................................................................................................................................ 34 Running a Scenario .............................................................................................................................................. 34 Run.bat Script .................................................................................................................................................. 34 Scenario XML File ............................................................................................................................................ 35 QS5 Results .......................................................................................................................................................... 35 FTOT Report..................................................................................................................................................... 35 Tableau Dashboard.......................................................................................................................................... 36 Maps ................................................................................................................................................................ 37 Comparison of QS5 and QS1 ........................................................................................................................... 38 Quick Start 6 (QS6) - RMP to Processor to Destination, National Level, No Road .................................................. 39 Purpose................................................................................................................................................................ 39 Input Data............................................................................................................................................................ 39

Overview

7

Running a Scenario .............................................................................................................................................. 39 Run.bat Script .................................................................................................................................................. 39 Scenario XML File ............................................................................................................................................ 40

QS6 Results .......................................................................................................................................................... 40 FTOT Report..................................................................................................................................................... 40 Tableau Dashboard.......................................................................................................................................... 41 Maps ................................................................................................................................................................ 42

Exercises .............................................................................................................................................................. 44 Quick Start 7 (QS7) - RMP to Processor (multiple inputs) to Destination............................................................... 45

Purpose................................................................................................................................................................ 45 Input Data............................................................................................................................................................ 45 Running a Scenario .............................................................................................................................................. 45

Run.bat Script .................................................................................................................................................. 45 Scenario XML File ............................................................................................................................................ 46 QS7 Results .......................................................................................................................................................... 46 FTOT Report..................................................................................................................................................... 46 Tableau Dashboard.......................................................................................................................................... 46 Maps ................................................................................................................................................................ 48 Exercises .............................................................................................................................................................. 49 Acknowledgements ................................................................................................................................................. 50

Table of Figures and Tables

Table 1: Quick Start scenarios summaries and complexity rating.

4

Figure 1: FTOT Quick Start Folder Structure

4

Figure 2: Example Geodatabase (GDB). The structure of the GDB (left) and an example of the records in the rmp attribute

table (right) are shown.

11

Figure 3: QS1 raw material supplier input commodity file (rmp.csv) example entry

12

Figure 4: QS1 destination input commodity file (dest.csv) example entry

12

Figure 5: QS1 Tableau Dashboard

15

Figure 6: QS1 Optimal Solution

16

Figure 7: QS2 raw material supplier input commodity file (rmp.csv)

18

Figure 8: QS2 processor input commodity file (proc.csv)

18

Figure 9: QS2 destination input commodity file (dest.csv)

19

Figure 10: QS2 Tableau Dashboard

21

Figure 11: QS2 Optimal Solution

22

Figure 12: QS3 raw material supplier input commodity file (rmp.csv)

24

Figure 13: QS3 Candidate processor commodity file (cand_proc.csv)

25

Figure 14: QS3 destination input commodity file (dest.csv)

25

Overview

8

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download