Create an LTL tariff – suggested workflow

The following is a suggested workflow for creating an LTL tariff using data that is described exclusively within Transportation Manager. Note that not all required fields are mentioned.

This example does not include set-up requirements for Fuel Surcharges. See "Fuel Surcharges – Initial Set-Up" for information on set-up requirements for Fuel Surcharges:

  1. Create Range Code for Standard LTL Tariffs (if necessary). This step is only required prior to creating the first LTL tariff using these standard weight breaks.

    Range ID for Standard LTL Tariff

    Range ID

    Description

    LTL

    Standard LTL Weight Breaks

    Range for Range ID of LTL

    Range To

    Charge Type

    499.9999

    Per-Unit Rate

    999.9999

    Per-Unit Rate

    1999.9999

    Per-Unit Rate

    4999.9999

    Per-Unit Rate

    9999.9999

    Per-Unit Rate

    19999.9999

    Per-Unit Rate

    29999.9999

    Per-Unit Rate

    39999.9999

    Per-Unit Rate

    99999.9999

    Per-Unit Rate

  2. Create Master Service for LTL (if necessary). This step is only required before creating the first LTL tariff.

    Service ID

    Description

    Transit Mode

    LTL

    Less Than Truckload

    LTL

  3. Create Master Condition for Weight Multi-Class (if necessary). This step is only required prior to creating the first LTL tariff.

    Charge ID

    Description

    Unit Type

    Condition

    Multi-Freight Class

    WGTM

    Weight (Multi-Class)

    Weight

    Yes

    Yes

  4. Create Delivery Schedule. See "Create a delivery schedule for the LTL tariff – suggested workflow".
  5. Create LTL Carrier. This step is only required prior to creating the first tariff for this carrier.
  6. Create Required Zones. This step is only required if the zones used by this tariff have not yet been established. In this example, LTL tariff will use zones corresponding to the first three digits of selected zip codes used in the United States.

    Example:

    Zone ID

    Country Code

    From Zip/Postal Code

    To Zip/Postal Code

    002

    USA

    00200

    00299

    005

    USA

    00500

    00599

    006

    USA

    00600

    00699

    008

    USA

    00800

    00899

    009

    USA

    00900

    00999

    010

    USA

    01000

    01099

    etc.

     

     

     

  7. Create LTL Tariff

    Tariff Attribute

    Carrier ID

    Unit of Measure

    Currency

    Carrier Specific Tariff

    [SCAC as per Step 5]

    Imperial

    USD

    Service ID

    Allow Stops

    Scheduling Method

    Delivery Schedule

    LTL

    No

    System Delivery Schedule

    [Delivery Schedule as per Step 4]

    Service ID

    Maximum Weight

    LTL

    45000.0000

    Charge ID

    WGTM

    Range ID

    LTL

    Unit Adjustment Factor

    100

    Unit Adjustment Factor Operation

    Divide Input Units by Factor

    Unit Adjustment Factor Timing

    Apply Factor After Look-Up

    Look Ahead/Back

    Look Ahead to Next Break

    Freight Class

    Rate As Freight Class

    45

    50

    50

    50

    55

    50

    60

    50

    65

    77.5

    70

    77.5

    77.5

    77.5

    85

    77.5

    92.5

    100

    100

    100

    110

    100

    etc.

     

    Status

    Active

    Service ID

    LTL

    Origin Zone

    [for example, 330 representing zip codes starting with 330]

    Destination Zone

    [for example, 100 representing zip codes starting with 100]

    Rate Code Control

    Create Using Specified Value

    Rate Code

    [for example, 300100]

    Create lanes for all valid combinations of origin and destination zones.

    Note: Lanes can be copied from another Tariff Service combination using the Duplicate Tariff Elements operation.

    Service ID

    LTL

    Charge ID

    WGTM

    Freight Class

    50

    Rate Code Control

    Use Existing

    Rate Code

    [for example, 300100]

    Minimum Charge

    50.00

    Rate Ranges for Multi-Class Weight Condition

    Range From

    Range To

    Charge Type

    Rate

    0

    499.9999

    Per-Unit Rate

    35.00

    500

    999.9999

    Per-Unit Rate

    33.00

    1000

    1999.9999

    Per-Unit Rate

    31.00

    2000

    4999.9999

    Per-Unit Rate

    28.00

    5000

    9999.9999

    Per-Unit Rate

    26.00

    10000

    19999.9999

    Per-Unit Rate

    24.00

    20000

    29999.9999

    Per-Unit Rate

    23.00

    30000

    39999.9999

    Per-Unit Rate

    22.00

    40000

    99999.9999

    Per-Unit Rate

    21.00

    Create rates for all valid combinations of Freight Classes enabled for rating and Rate Code. Freight Classes enabled for rating are those referenced in the Rate As Freight Class column in the table in section Create Condition for Tariff Service.

    Service ID

    LTL

    Charge ID

    WGTM

    Percentage

    30.00-

See Also

Tariff examples