Transport Partnership
U.S. ENVIRONMENTAL PROTECTION AGENCY
Logistics Partner 2.O.II Tool:
Data Collection Overview and
Workbook ^^^S^
2011 Data Year - United States Version
Part 2 MM
&EPA
United States
Environmental Protection
Agency
-------
Transport Partnership
U.S. ENVIRONMENTAL PROTECTION AGENCY
Logistics Partner 2.O.II Tool:
Data Collection Overview and
Workbook
2011 Data Year - United States Version
Part 2
Transportation and Climate Division
Office of Transportation and Air Quality
U.S. Environmental Protection Agency
United States Office ofTransportation and Air Quality
Environmental Protection pp/\ /ion R 19
-------
Introduction to Part 2: DATA COLLECTION OVERVIEW AND
WORKBOOK
This guide is Part 2 of a three-part series to help logistics companies participate in the SmartWay
Transport Partnership.
In this guide you will learn about:
1. The general organization of the SmartWay Logistics Partner FLEET Tool, and
2. Data needs for each section of the tool.
You will also have the opportunity to collect your data using our data collection worksheets in
preparation for the data entry step (Part 3).
Please review this guide carefully BEFORE attempting to use the tool or enter data. Understanding the
data requirements and gathering all data in advance will save considerable time and frustration while
completing your tool submission.
If you wish to explore the Logistics Partner FLEET tool in preparation for joining the program, please
review Part 3: Data Entry Guide and return to this workbook to prepare for gathering your data.
Please note that each business unit that you operate will be characterized separately. If you have
multiple business units with different operations modes, or you contract segments of your freight
operations to other companies, you may need to complete additional tools (e.g., Truck FLEET and/or
Multi-modal FLEET) to accurately assess your operations.
In the event that you have a question about any of the data collection activities, you can contact
SmartWay Email Support at smartway transport@epa.gov and a member of our SmartWay Partner
Support Team will assist you.
WARNING!
Completing the Logistics Partner FLEET tool requires a considerable amount of information
about your company and business units that are joining SmartWay. There are multiple
sections and screens to complete for each business unit that you operate.
While you will have the ability to save your tool along the way and return to it at anytime, we
STRONGLY ENCOURAGE you to review Part 1 to understand key information about joining the
partnership. Then, use Part 2 of this series to learn about the data requirements and gather your data
BEFORE attempting to use Part 3 to complete the tool.
Logistics Partner Fleet Tool Users Guide Part 2 | Page 3
-------
Overview of Data Collection Requirements
The SmartWay Logistics Partner FLEET tool is the data collection and calculation system for logistics
companies that join the SmartWay Transport Partnership. There are three sections of the SmartWay
Logistics Partner FLEET Tool that require data about your company's operations:
1. Enter Company and Contact Information
2. Characterize Your Logistics Business Units
3. Enter Activity Information for Each of Your Business Units
This guide will explore the data required for completing these three sections. Part 3 of the three-part
user guide series explains more about the structure of the tool and the data entry process; this guide
will focus primarily on what you need to do to prepare for completing the tool.
NOTE: Before beginning your data collection, select the last calendar year for which you
have full annual (12 months) data. This means that you have data from January of the
calendar year through December of the same year. If you are a new SmartWay partner and
do not have a full year of operational data, please collect a minimum of three months' data
for input into the SmartWay tool. In your next update year, you will be required to submit a
full year's data.
Section 1: Enter Company and Contact Information
SmartWay needs complete company information for correspondence, web posting, press releases, and
awards and recognition (where applicable). The SmartWay tool asks for:
• General company information (e.g., name, location, web address, etc.)
• A primary contact1 for any questions about your company's participation and tool submissions
• An executive contact2 for participation in awards and recognition events
• Additional contacts (optional): Additional contacts may include your press/media contact, your
business unit manager, etc.—anyone who is not the primary contact for tool and participation
issues but may be involved in your involvement with SmartWay.
Please use Worksheet #1 in this guide to prepare for filling out the Contact Information Screen in the
Logistics Partner FLEET Tool.
The primary contact is the individual designated by the Executive Contact to directly interface with SmartWay regarding specific tasks
involved in the timely submission of the tool. The Primary Contact is responsible for coordinating the assembly of information to
complete/update company data; completing and updating the tool itself; maintaining direct communication with SmartWay; and keeping
interested parties within the company apprised of relevant developments with SmartWay.) NOTE: To ensure that emails from SmartWay/EPA
are not blocked, new primary contacts may need to add SmartWay/EPA to their preferred list of trusted sources.)
The executive contact is the company executive who is responsible for agreeing to the requirements in the SmartWay Partnership
Agreement, overseeing the Primary Contact (as appropriate), and ensuring the timely submission of the tool to SmartWay. The executive
contact also represents the company at awards/recognition events. This person should be a Vice President or higher level representative for
the company.
Logistics Partner Fleet Tool Users Guide Part 2 | Page 4
-------
Section 2: Characterize Your Logistics Business Units
The SmartWay Logistics Partner FLEET Tool allows you to characterize your operations at the business
unit level. In the Logistics Partner FLEET tool, a business unit is defined as any unit that a customer has
discretion to hire. For example, if your customers can hire your truckload dry van fleet separately from
your flatbed fleet, you will need to enter each as a separate business unit.
NOTE: You may enter multiple business units into a single tool submission.
SmartWay highly recommends developing your list of business units offline using a company
organization chart or perhaps a customer interface webpage. The best strategy is to have a clear idea of
how to define your business units before filling out the tool.
Your company's name and your business unit(s) will be listed on the SmartWay website to indicate your
participation in the SmartWay Transport Partnership. Your shipper and logistics customers can also use
the SmartWay Online Database to search for your company by the name you submit in the tool, your
SCAC codes, Motor Carrier Number(s), and/or your US DOT Number(s).
^ Therefore, it is critical that you identify your company and business unit(s) names in the
tool as you would have them appear on the SmartWay website.
The "Business Unit Characterization" section of the tool has five subsections:
1. Identify Logistics Business Units
2. Logistics Business Unit Details
3. Business Focus
4. Operation Categories
5. Body Types
Please use the Worksheet #2 provided in this guide to prepare for filling out these sections in the
Logistics Partner FLEET Tool.
NOTE: You may wish to print multiple copies of Worksheet #2 if you have multiple business units.
Data Requirements for "Identify Logistics Business Units" Screen
For each logistics business unit, you will need to specify:
• Company Name: On the SmartWay website, each of your business unit names will begin with
the name of your company. This "prefix" will be whatever you enter in the Company Name field
on the Identify Logistics Business Units screen. By default, the Company Name for your first
business unit on the Identify Logistics Business Units screen is automatically populated with the
first 50 characters of the Partner Name that was entered on the Home screen. You should
specify the Company Name so that it appears EXACTLY as it you want it to show within each
business unit name. (For example, if your company's name includes "Inc." or "Ltd.", you may
choose not to include that in your fleet names.) Please pay special attention to proper
capitalization, abbreviations, and punctuation. Remember that this name will be automatically
inserted at the start of each of your business unit names on the SmartWay website.
Logistics Partner Fleet Tool Users Guide Part 2 | Page 5
-------
Business Unit Identifier: Please make sure to specify each business unit identifier exactly as you
want it displayed on the SmartWay website, including proper capitalization, any abbreviations,
and punctuation. Remember that it will automatically be combined with your Company Name.
NOTE: If you have only one business unit, you may leave the Business Unit Identifier field blank,
in which case your business unit name will simply be your Company Name.
NOTE: Define your business units based on the ability of your customers to choose them. If
a business unit includes a mix of TL and LTL, you will indicate the percentages of each. If
customers can choose to hire your TL business unit, your LTL business unit, or your dray
business unit separately, then each should be regarded as a separate business unit.
Data Requirements for "Logistic Business Unit Details" Screen
For each business unit, you will need to specify:
• Standard Carrier Alpha Codes (SCACs): The Standard Carrier Alpha Code is a unique 2-4
alphabetic character code used by the transportation industry to identify transportation
companies. If you cannot remember your SCACs, please contact the National Motor Freight
Traffic Association before proceeding (see http://www.nmfta.org/Pages/ContactUs.aspx.) You
can enter multiple SCACs by separating them with commas in the tool. This field is optional and
may be left blank in the Logistics Tool.
• Motor Carrier Numbers (MCNs): The Motor Carrier Number is a 6 or 7 digit number provided
by the Federal Motor Carrier Safety Administration. This field is optional and may be left blank
in the Logistics Tool.
• US DOT Number: This number is assigned to commercial vehicles hauling cargo in interstate
commerce by the Federal Motor Carrier Safety Administration. DOT numbers are strictly
numeric and can be up to 7 digits in length. This field is optional and may be left blank in the
Logistics Tool.
• Business Unit Type: Business Unit Type is defined as the service type for your business unit.
There are two options accepted by the tool—"For-Hire" and "Private/Dedicated." If your
company has only one business unit, your "Type" selection will reflect your company's
operations as a whole. If there are multiple business units, define each unit's type separately.
• Business Unit Contact: This contact should be one of the contacts you already identified in the
Contact Information section as the contact for each business unit. NOTE: A drop-down menu in
the tool will supply this information; if there is a contact for the business unit that is not already
listed in the Contacts worksheet, you will need to go back to that screen to add the required
contact information.
Data Requirements for "Business Focus" Screen
For each business unit, you will need to specify the percent of overall activity for each Business Focus
Category:
Logistics Partner Fleet Tool Users Guide Part 2 | Page 6
-------
• Logistics Provider: Logistics providers are non-asset based third parties that provide multiple,
bundled logistics services. They may be involved in material management, transportation
management, inbound and outbound freight, inventory management, 4PL activities,
warehousing, cross dock, kitting, packaging, and sub assembly processes.
• Freight Forwarder: Freight forwarders are documentation specialists and consolidators of
freight such as LTL (less than truckload) and LCL (less than container load). Freight forwarders
normally provide pickup and delivery for domestic and international shipments, and provide the
property transportation for a compensation or fee basis.
• Freight Broker: A freight broker buys and sells transportation services and normally works on
behalf of a carrier or shipper.
• Truck Carrier: Truck carriers operate their own managed fleet (owned or leased). These fleets
can be for-hire or private/dedicated. Refer to "Choosing the Right Tool for your Business Units"
in Part I of this guide to determine if you should complete the SmartWay Truck Tool for the
Truck Carrier portion of your operations.
Data Requirements for "Operation Categories" Screen
For each business unit you will need to specify:
• Operation Category: Determine the percent of each operation type based on overall activity for
the reporting year. The percentages for each business unit must sum to 100%. This percentage
calculation does not need to be exact but should be reasonably reflective of your business unit
operations. Operation categories include:
o Truckload (TL) - Truckload shipping is the movement of large amounts of homogeneous
cargo, generally the amount necessary to fill an entire semi-trailer or intermodal
container. A truckload carrier is a company that generally contracts an entire trailer-load
to a single customer.
o Less-than-truckload (LTL) - Less-than-truckload carriers collect freight from various
shippers and consolidate that freight onto enclosed trailers for line-haul to the
delivering terminal or to a hub terminal where the freight will be further sorted and
consolidated for additional line-hauls.
o Dravage (Drav) - Predominantly associated with port, or rail head connections where
freight is picked up, and moved to another transfer facility or transport mode terminal.
Often these moves are short in nature, but can be longer depending on specific
situations.
o Package delivery (PD) - Covers operations characterized by residential or business
package delivery/pickup consisting primarily of single or small groups of
packages. It does not include larger scale pickup delivery operations that are more
properly characterized as LTL operations. Common examples of this type of operation
are the brown UPS and white FedEx delivery vehicles.
o Expedited - Includes time-sensitive shipments, with trucks typically on stand-by.
Data Requirements for "Body Types" Screen
For each business unit you will need to specify:
Logistics Partner Fleet Tool Users Guide Part 2 | Page 7
-------
Body Type (by percentage of vehicles): Determine the percent of each body type represented
in the business unit. Percentages can be approximate, based on overall activity, but must sum
to 100%. Body type categories include:
o Dry van/box van
o Refrigerated (Reefer)
o Flatbed
o Tanker
o Intermodal chassis containers (pooled and owned)
o Heavy/Bulk
o Auto carrier
o Moving
o Utility
o Special hauler (e.g., Hopper, Livestock, and other specialized carriers)
NOTE: Again, define your business units based on the ability of your customers to choose
them. If customers can choose to hire your dry van business unit, or your reefer business
unit, or your flatbed business unit, then create each as a separate business unit. The
percentages for each business unit must sum to 100%.
Once you have defined your logistics business units, you will need to enter detailed information
regarding vehicles and activity levels.
Logistics Partner Fleet Tool Users Guide Part 2 | Page 8
-------
Section 3: Enter Data for Each of Your Logistics Business Units
Now that you have defined your logistics business units, you will be asked to provide additional
information for EACH business unit separately.
Data Requirements for "Select Carrierfsl" Screen
Please use the Worksheet #3A provided in this guide to prepare for filling out the Select Carrier(s)
section in the Logistics Partner FLEET Tool (make one copy for each business unit).
To begin, you will need to identify the carriers included in each logistics business unit. Two options are
available for identifying your carriers. If you have a large number of carriers (e.g., as a large 3PL), you
may wish to develop your carrier details separately and upload your data in a single file using the Data
Import method. Alternatively, if your logistics business unit has a limited number of carriers, you may
choose to specify your carriers one at a time using the Manual Entry method. These two methods are
described in detail in the Logistics Partner FLEET Tool User Guide Part 3.
Regardless of the method you choose, you will need to first identify the mode of transport for the
carrier. Four carrier mode selections are available, including:
• Rail
• Truck
• Multi-modal
• Logistics
(Note: By selecting "AN" on the Tool's Select Carrier(s) screen, you may search across all carriers,
regardless of mode.)
Next, you may also specify a carrier bin category for the Truck mode. Truck bin categories include:
• TL Dry Van
• LTL Dry Van
• Refrigerated
• Flatbed
• Tanker
• Dray
• Heavy/Bulk
• Package
• Auto Carrier
• Moving
• Utility
• Specialized
• Mixed
• Expedited
Bin category selections are not currently available for other modes but may be added in the future.
(Note: Multi-modal selections list "Truck/Rail" as the bin category.)
Logistics Partner Fleet Tool Users Guide Part 2 | Page 9
-------
After identifying the mode (and bin category if available), you should identify each carrier's specific fleet
name, as listed in the SmartWay Carrier Data file, along with any associated SCACs and MCNs. The
Carrier data file can be downloaded from the SmartWay website by selecting the button under Step 4 on
the Logistics Tool Home screen and viewed on the Select Carrier(s) screen or offline using Microsoft®
Excel.
In certain cases, a carrier may have multiple fleets associated with its operations. In the case of
trucking, multi-modal and logistics partners, you may use the SCAC list in the Carrier Data file to select
among multiple fleets. The Select Carrier(s) screen also allows you to filter carrier fleets by SCAC and
MCN if needed.3
If one or more carriers in your business unit are not SmartWay Partners, you should specify "Non-
SmartWay" for the given mode - for example, Non-SmartWay Truck Carrier or Non-SmartWay Multi-
modal Carrier. If you have any non-SmartWay carriers in your list, then you must also specify the
number of non-SmartWay carriers utilized for each mode, but only include carriers used during the
reporting year.
Data Requirements for "Activity Data" Screen
Please use the Worksheet #3B provided in this guide to prepare for filling out the Activity Data section
in the Logistics Partner FLEET Tool (make one copy for each business unit).
First provide a detailed text Data Source Description for the sources used to estimate your mileage and
ton-mile data for your carriers. Be sure to indicate how you calculated the values, and where this data
was obtained. For example, you may use PC Miler, carrier reports, or accounting/purchasing records to
determine miles. Payload and ton-mile estimates may be based on bills of lading or other internal
records.
Next you must specify a Data Availability option for each carrier. There are seven Data Availability
options, as summarized below.
1. Enter ton-miles and miles (preferred option)
2. Enter ton-miles and average payload
3. Enter ton-miles, density, and load fraction
4. Enter ton-miles only
5. Enter miles and average payload
6. Enter miles, density, and load fraction
7. Enter miles only
If you have the necessary data, select Option 1 to provide estimates for both ton-miles and total miles.
If only one of these values is known, the other value can be calculated using a combination of your
average freight density, your average load percentage (e.g., 100% for truckload), and/or your average
payload in tons. Although dependent on industry type and product mix, Option 2 is generally preferred
to Option 3 in terms of data quality, while Option 3 is preferred to Option 4. Similarly, Option 5 is
generally preferred to Option 6 in terms of data quality, while Option 6 is preferred to Option 7.
3 SmartWay is now collecting US DOT numbers as well. Carriers may be searched for using DOT numbers beginning next year.
Logistics Partner Fleet Tool Users Guide Part 2 | Page 10
-------
If your company uses LTL or Package Delivery carriers you should choose ton-miles as the
calculation metric if possible. Data Availability Option #7 (miles only) requires additional off-
line calculation to account for partial loads. For example, consider one pallet on a truck: If you
base your calculations on miles x the g/mile factor for that truck carrier, and the truck carries
22 pallets and only one is yours, your carbon allocation would be overstated a factor of 22 (as
there are 21 other pallets on the truck belonging to other companies.) The same calculation
for one package on a truck carrying 300 packages would overstate the carbon by a factor of
300. Therefore to account for carbon properly using Option #7 the company would need to
determine "truckload-equivalents" and reduce the mileage entered accordingly. For example if
there are 100 trips at 1,000 miles each with 1 pallet per truck on trucks carrying 22 pallets, this
would be the equivalent of a full truck travelling (l,OOOxlOO)/22 miles.
Providing ton-mile data (Options 2, 3, and 4) is generally preferable to simple mileage data for most
modes. For example, when shipping bulk commodities by rail, ton-mile estimates are often available
and will result in a more precise estimate of mass emissions (when combined with gram per ton-mile
metrics for each carrier) than relying on gram per mile metrics. Ton-mile estimates are also most
appropriate for LTL truck shipments, given the uncertainty in cargo volume utilization. Ton-miles are
also more appropriate for heavier TL shipments. Alternatively, mileage activity measures are most
appropriate for light truckload shipments. However, for all calculations, where precise estimates of
weight are often unknown, and distance estimates are highly reliable, mileage activity measures may be
the better metric.
Guidance regarding payload, density, and load percentage data is provided below.
Ideally, when entering information for a carrier, you should use Data Availability Option 1. If
this is not possible, please choose the method that uses the most accurate data at your
disposal. In this way the tool will utilize the most accurate data available for the ton-mile and
mile comparison metrics as well as for the emissions footprint calculations.
After specifying the Data Availability options, you must then pick the preferred metric (Inventory
Calculation Metric) for calculating mass emissions for each of your carriers. Options include:
• grams per (truck) mile;
• grams per railcar-mile, and;
• grams per ton-mile (all modes).
Select the metric most appropriate for characterizing your carrier activity. You should select g/mile
metrics for estimating mass emissions for lighter weight truck freight, while g/ton-mile should generally
be used for rail and heavier truck freight.
After specifying the Inventory Calculation Metric, record the total Ton-Miles and Total Miles data for
each carrier. If the carrier mode is rail, record total railcar-miles, otherwise specify total truckload-miles.
Enter the data to the nearest whole number.
Data Availability Option 1 - Enter both total annual miles and ton-miles for the given carrier.
Logistics Partner Fleet Tool Users Guide Part 2 | Page 11
-------
Data Availability Option 2 - Enter total ton-miles along with your estimated average payload (per truck
or railcar, as appropriate) in short tons (2,000 Ibs).
Data Availability Option 3 - Enter your total ton-miles. Next, you must estimate your freight density
using the Average Density Calculator on the Activity Data screen. The calculator allows you to specify
the fraction of shipments that fall into various commodity groupings. Each grouping has an associated
average density, expressed in pounds per cubic foot of available cargo space. The densities for a given
commodity category vary for rail and truck modes, since utilized container space varies by mode.4
For each carrier, record the percentage distribution (as a fraction of total miles) for each of the
Commodity Groupings, as shown in Worksheet 3B.
Next you will need to estimate the number of loads (truck or railcar) by load fraction category. The
Logistics Tool hasten load categories:
• 1/10 truckload (or railcar-load)
• 2/10 truckload (or railcar-load)
•
• 9/10 truckload (or railcar-load)
• Full truckload (or railcar-load)
Record the annual number of loads for each of these categories, for each carrier, matching your
estimates to the most appropriate (closest) category. Load estimates can be volume-based (with full
truckload equivalent to cubing out) or weight-based (with full truckload equivalent to weighing out).
Data Availability Option 4 - Enter total ton-miles.
Data Availability Option 5 - Enter total miles along with your estimated average payload (per truck or
railcar, as appropriate) in short tons (2,000 Ibs).
Data Availability Option 6 -Enter total miles, then record the commodity type distributions and load
fraction information as described for Option 3 above.
Data Availability Option 7 - Enter total miles.
Correctly calculating Ton-Miles is critically important for the accurate determination of your
|\ carbon foot-print. You can calculate your business unit's ton-miles as follows.
Enter the ton-miles hauled per year attributable to each carrier. A ton-mile is one ton moving
one mile. DO NOT ESTIMATE TON-MILES BY SIMPLY MULTIPLYING TOTAL MILES BY TOTAL TONS
- this calculation effectively assumes your entire tonnage is transported on EACH AND EVERY
truck, and will clearly overstate your ton-miles.
Many companies track their ton-miles and can report them directly without further calculation.
For example, logistics company systems are typically set up to associate a payload with the
mileage traveled on each trip by carrier, and are then summed at the end of the year. If such
4 The density categories for Logistics and Multi-modal carriers are assumed to be the same as for Truck carriers.
Logistics Partner Fleet Tool Users Guide Part 2 | Page 12
-------
information is not available, there are two ways to calculate ton-miles:
1) Companies can determine their average payload per carrier, multiply the average payload by
the total miles per carrier, and sum the results for all carriers for the reporting year; or
(total miles per carrier x total tons per carrier)
2) Set Ton-miles per carrier =
total # of trips per carrier
NOTE: Empty miles are not included in the ton-mile calculation, but the fuel used to move those
empty miles are included in the overall g/ton-mile calculations.
To check your estimate, divide ton-miles by miles. The result is your fleet-average payload. If
this number is not reasonable, please check your calculations.
Logistics Partner Fleet Tool Users Guide Part 2 | Page 13
-------
Worksheets for Data Collection
List of Worksheets
#1: Company and Contact Worksheet 15
#2: Logistics Business Unit Characterization Worksheet 16
#3A: Select Carriers Worksheet 17
#3B: Activity Data Worksheet 18
Logistics Partner Fleet Tool Users Guide Part 2 | Page 14
-------
Worksheet #1: Company and Contact Information
#1. Enter your Contact Information:
General Company Contact Information
Company Name
Headquarters
Mailing Address
City
Main Phone
Number
Primary Contact Information
Primary Contact Name
Primary Contact Mailing
Address
City
Primary Contact Phone
Number
Toll-free
Number
State/Province
Cell
number
Zip Country
Web Address
State/Province
Email
Address
Zip Country
Executive Contact Information
Executive Contact Name
Executive Contact Mailing
Address
City
Executive Contact Phone
Number
State/Province
Email
Address
Zip Country
Other Contact Information
Executive Contact Name
Executive Contact Mailing
Address
City
Executive Contact Phone
Number
Contact's role in program
State/Province
Email
Address
Zip Country
Logistics Partner Fleet Tool Users Guide Part 2 | Page 15
-------
Worksheet #2: Logistics Business Unit Characterization
Complete this worksheet for each logistics business unit you will be submitting in the Logistics Partner
FLEET Tool.
#2: Define your Logistics Business Units
Business Unit Name (Company Name followed by Business Unit Identifier name)
SCAC: MCN: DOT:
BUSINESS UNIT TYPE: (for hire, private/dedicated)
Business Unit Contact:
Business Unit Focus (activity %s):
Logistics Provider Freight Forwarder Freight Broker Truck Carrier _
Operation Category (activity %s):
Truckload LTL Drayage Package Delivery Expedited
Body Type (activity %s):
Dry Van Reefer Flatbed Tanker Chassis
Heavy/Bulk Auto Carrier Moving Utility Special Hauler_
Logistics Partner Fleet Tool Users Guide Part 2 | Page 16
-------
Worksheet #3A: Select Carrier(s)
Complete the following for each logistics business unit you will be submitting in the Logistics Partner
FLEET Tool. Make multiple copies of the table below to enter all carriers in the business unit if
needed.
#3A: Identify your Logistics Business Units
Logistics Business Unit Name
Carrier Name*
ModeA
Bin Category
**
#Non-
SmartWay
CarriersAA
* Exactly as it appears in SmartWay Carrier data file
A Truck, Rail, Logistics, Multi-modal
** Truck bin categories include:
TL Dry Van; LTL Dry Van;
Refrigerated; Flatbed;
Tanker; Dray;
Package; Specialized; Mixed
AA If applicable, for current reporting year only
Logistics Partner Fleet Tool Users Guide Part 2 | Page 17
-------
Worksheet #3B: Activity Data (page 1 of 5)
Complete the following for each logistics business unit you will be submitting in the Logistics Partner
FLEET Tool. Make multiple copies of the tables if needed to enter all carriers in the business unit.
#3B: Enter Activity Data
Logistics Business Unit Name:
Provide Data Source Description:
Logistics Partner Fleet Tool Users Guide Part 2 | Page 18
-------
Worksheet #3B: Enter Activity Data (page 2 of 5)
Data Availability Option, Inventory Calculation Metric, Miles, Ton-Miles, and Average Payload
Carrier Name
Data
Availability
Option (1-7)*
Inventory
Calculation
MetricA
Ton-miles
Miles
Average
Payload**
* Options include
1 = (Preferred) I know both Ton-miles and Total Miles.
2 = I know Ton-miles and Average Payload.
3 = I know Ton-miles and have general information about number of loads and cargo density.
4 = I know Ton-miles only.
5 = I know Total miles and Average Payload.
6 = I know Total Miles and have general information about number of loads and cargo density.
7 = I know Total Miles only.
A g/ton-mile; g/mile; g/railcar-mile
** For Options 2 and 5 only
Logistics Partner Fleet Tool Users Guide Part 2 | Page 19
-------
Worksheet #3B: Enter Activity Data (page 3 of 5)
Complete the following for each truck, logistics, and multi-modal carrier in the logistics business unit.
Only required for Data Availability Options 3 and 6.
Make multiple copies of the tables as needed to enter all carriers in the business unit.
Commodity Distribution (for Average Density Calculator)
Carrier Fleet Name:
Truck/Logistics/Multi-modal Carrier Commodity Distribution
Commodity
Group
1
2
3
4
5
6
7
8
Description
Pharmaceutical products
Electronic and electrical equipment; furniture,
mattresses, lamps, etc; machinery; mail and courier
parcels; misc. manufactured products; mixed freight;
non-powered tools; plastic and rubber; powered tools;
precision instruments and apparatus; printed products;
vehicles, including parts.
Alcoholic beverages; all other agricultural products; all
other prepared foodstuff; all other transportation
equipment; articles of base metal; bakery and milled
grains; base metal -finished or semi-finished; live
animals and fish; meat, seafood and their preparation;
paper and paperboard articles; pulp, newsprint, paper
or paperboard; recyclable products; textile, leather,
and related products; tobacco products; wood
products.
All other waste and scrap; animal feed or products of
animal origin; hazardous waste; misc/other;
monumental or building stones; non-metallic mineral
products.
All other chemical products; all other coal and refined
petroleum; base chemicals; crude petroleum; fertilizers
and fertilizer materials.
All other non-metallic minerals; cereal grains; logs and
other wood in rough; metallic ores and concentrates;
natural sand.
Coal; fuel oils; gasoline and aviation turbine.
Gravel and crushed stones
Avg Ibs/cu ft
7.8
9.3
11.3
13.2
14.1
16.3
17.2
18.3
% of Carrier
Freight*
mileage basis - must sum to 100
Logistics Partner Fleet Tool Users Guide Part 2 | Page 20
-------
Worksheet #3B: Enter Activity Data (page 4 of 5)
Complete the following for each rail/intermodal carrier in the logistics business unit. Only required
for Data Availability Options 3 and 6.
Make multiple copies of the table as needed to enter all carriers in the business unit.
Commodity Distribution (for Average Density Calculator)
Carrier Fleet Name:
Rail Carrier Commodity Distribution
Commodity
Group
1
2
3
4
5
6
7
Description
Electrical equipment; furniture; live animals and fish;
textiles and leather; vehicles.
Mixed freight
Machinery; tobacco products; transportation
equipment
Logs and rough wood; meat, fish, seafood; misc.
manufacturing; paper products; products of
petroleum
Alcoholic beverages; animal feed; fabricated base
metals; fats and oils; fuel oils; gasoline and fuel;
milled grain products; other agricultural products;
pulp and paper; waste and scrap; wood products
Base metal; basic chemicals; building stone; cereal
grains; chemical products; fertilizers; gravel and
crushed stone; metallic ores; natural sands; non-
metallic minerals; plastics and rubber
Coal
Avg Ibs/cu ft
7.7
16.1
22.6
34.6
42.0
48.3
54.3
%of
Carrier
Freight*
mileage basis - must sum to 100
Logistics Partner Fleet Tool Users Guide Part 2 | Page 21
-------
Worksheet #3B: Enter Activity Data (page 5 of 5)
Complete the following for each carrier in the logistics business unit. Only required for Data
Availability Options 2 and 5.
Make multiple copies of the table as needed to enter all carriers in the business unit.
Load Distribution (for Average Load Calculator)
Carrier Fleet Name:
Carrier Load Distribution
Load Fraction*
1/10
2/10
3/10
4/10
5/10
6/10
7/10
8/10
9/10
Full
# Loads/yr
* Truckload or railcar-load, depending on mode
Logistics Partner Fleet Tool Users Guide Part 2 | Page 22
-------
Next Steps
Now that you understand the data collection requirements for the SmartWay Logistics Partner FLEET
Tool, and you have collected the data you need in the worksheets, you are ready to download the tool
and begin the data entry process. Part 3 of the user guide series will guide you through the tool screens,
and help you enter the data and troubleshoot any problems you may have with your submission. Please
visit http://www.epa.gov/smartway/partnership/logistics.htm to download Part 3: Data Entry Guide
and the Logistics Partner FLEET Tool if you haven't already.
Logistics Partner Fleet Tool Users Guide Part 2 | Page 23
------- |