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:

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

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

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

Create Delivery Schedule. See Create a delivery schedule for the LTL tariff – suggested workflow.
Create LTL Carrier. This step is only required prior to creating the first tariff for this carrier.
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.

Create LTL Tariff

Create Tariff Header

Tariff Attribute	Carrier ID	Unit of Measure	Currency
Carrier Specific Tariff	[SCAC as per Step 5]	Imperial	USD

Create Service for Tariff

Service ID	Allow Stops	Scheduling Method	Delivery Schedule
LTL	No	System Delivery Schedule	[Delivery Schedule as per Step 4]

Define Restrictions for Tariff Service. Restrictions define the operational minimums and maximums for freight being picked up or delivered.

Service ID	Maximum Weight
LTL	45000.0000

Create Multi-Class Weight Condition for Tariff Service

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

Create Freight Class Cross Reference for Tariff Service Condition

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.

Create Lanes for Tariff Service

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.

Create Rates for Tariff Service Condition. Example:

Rate Setup for Multi-Class Weight Condition

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.

Create Discounts for Tariff Service Condition

If carrier offers 30% of all listed rates, create Surcharge/Discount at Tariff Service Condition (Charges) level:

Service ID	LTL
Charge ID	WGTM
Percentage	30.00-