Transport Sheets

These sheets cover information related to transportation modes, costs, and trip data.

Mode of Transport

Purpose: List all transportation modes and enter details for each transport mode.

Instructions: Enter the name and details for each transport mode, like:

1. Speed (Transport Attributes)

2. Wiggle factor (Transport Attributes)

3. Roundtrip: this attribute should be set to 1 if the transport mode is used for roundtrip (Transport Attributes)

4. Maximum Road Distance To Retrieve: When a lane is using a mode of transport for which maximum road distance to retrieve has been specified and the straight line distance between two points for the lane is greater than the maximum road distance to retrieve, then the ‘Retrieve Distance’ flag will automatically be set to 0 for those lanes, and straight line distances will be used instead. (Transport Attributes)

Mode of Transport Groups

Purpose: For each transport mode, you can determine which group it belongs to.

Instructions: Assign transport modes to their respective groups by filling in the Transport Mode column with the appropriate group and entering the warehouse that belongs to that group in the Sub Transport Mode column. Each sub transport mode must be in a different row and the Active column must be set to 1.

Transport Cost

Purpose: Define lanes you want to use in the model.

Instructions: Enter details for each lane you want use, like:

1. Availability (Available)

2. Retrieve Distance (Transport Attributes)

3. Average Load Size (Transport Attributes)

4. Capacity data (Capacity Attributes)

5. Cost data (Cost Attributes)

6. Base Case data (Transport Attributes)

7. Opening/Closing data (Open/Close Attributes)

8. Load Consolidation data: Minimum/Maximum Load Size and Minimum/Maximum # of Trips (Load Consolidation Attributes)

9. Custom Objectives data (How to use Custom Objectives?)

Lead Time Offset

Purpose: Define the lead time as in number of periods, between the departure from the from location and the arrival of the to location.

Instructions: Specifies the lead time, in number of periods, for this lane. The product becomes available in period p+n and the capacity is used in period p, where n is the Period Offset. You can read more about the Period Offset attribute in Lead Time Offset Attributes.

How the Lead Time Offset works in SC Navigator?

The following sheets include attribute “Period Offset”.

• Supplier Product

• Production Routing

• Transport Cost

Supplier Lead Time Offset

Supplier	Location	Product	Step	Period	Period Offset
Raw Material Supplier	Seattle	Processed Wood	1	January	2

Capacity is consumed in January. Products are available to be shipped out in March.

Production Lead Time Offset

Bill of Material	Production	Location	Period	Period Offset
Bookcase	Los Angeles Site	Los Angeles	March	1

Capacity is consumed in March. Products are made available in April.

Transport Lead Time Offset

Mode of Transport	Product	From Location	To Location	Period	Period Offset
Container Ship	Bookcase	Los Angeles	Yokohama	April	2

Capacity is consumed in April. Arrival period of this lane is in June.

Lead Time Offset and Cost To Serve

Due to activities need to happen during lead time periods, there may not be demand fulfilled during those periods. The following cost is calculated in the periods when activities occur and included in the system cost category:

• Supplier: Fixed/Variable Cost

• Supplier Product: Fixed/Variable Cost

• Production: Fixed/Variable Cost

• Production Routing: BOM FixedVariable cost

• Transport Cost: Cost related attributes

Below is the Cost To Serve solution in a dataset with demand from February to December. The Period Offset is 1 for Supply, Production, and Transport from warehouse to customer.

• In January, there is no demand. The cost accumulated from Supply/Production/Warehouse/Transport activities falls in System Cost category.

• In December, there is no cost, because there is no activities occurred to meet demand in that period: Transport cost incurred 1 period ahead.

Rate Cards

Purpose: Enter details for rate card.

Instructions: If you want to use location/lane/customer rate cards, you should enter the rate card bands for transport modes and other details on that sheet. You can specify data, including:

1. Drop Size Lower/Upper (Rate Card Attributes)

2. Distance Lower/ Upper (Rate Card Attributes)

3. Rate Card From/To (Rate Card Attributes)

4. Cost data (Cost Attributes)

5. Custom Objective data (How to use Custom Objectives?)

To configure rate card data, you must first define Drop Size values for each band. In addition to Drop Size, you can define rate cards using the following methods:

• Zone-based rate cards: Specify the locations using the fields Rate Card From and Rate Card To.

• Distance-based rate cards: Specify the distance range using Distance Lower and Distance Upper bounds.

For increased flexibility, you may also combine zone-based and distance-based rate cards within the same configuration.

Stepwise Transport Cost

Purpose: Define stepwise transport costing.

Instructions: If you want to use stepwise costing (cost data that varies with quantity) on a lane you should define the steps for lanes on that sheet. You can specify data, including:

1. Availability (Available)

2. Minimum/Maximum Capacity data: you can specify steps with different capacity bounds and different cost for lanes. The capacity bounds will determine which step’s costing will be applied for the lane. (Capacity Attributes)

3. Cost data (Cost Attributes)

4. Opening/Closing data (Open/Close Attributes)

5. Custom Objective data (How to use Custom Objectives?)

Transport Trip Data

Purpose: Enter data for transport trips.

Instructions: Fill in details about transport trips for each lane, including:

1. Distance: The travel distance (miles or km depending on the input) for this lane (Transport Attributes)

2. Duration: The travel duration (in hour) for this lane (Transport Attributes)

3. Max Difference: The maximum transported volume difference from the other roundtrip lanes of the transport type (Transport Attributes)

4. Transportation Lead Time (End-to-End (E2E) Lead Time Attributes)

You can read more about the different types of attributes in Transport Attributes.

Transport Ratio

Purpose: You can set ratio constraints related to tranportation.

Instructions: Fill in the first 10 columns and define the Minimum/Maximum ratio or both. You can read more about ratio constraints in Ratio Constraints, and see the attribute details at Ratio Constraint Attributes.