Create a CWT Rate Tariff

A previous article showed DVU users how to create a basic rate tariff. This article builds on that knowledge and shows users how to:

• create a rate tariff using the cost per hundred weight (CWT) formula

• configure a shipment/load with a CWT rate tariff

About CWT rates

CWT rates are based on three inputs:

• a rate per 100-pound unit (excluding accessorials, FSC, and service class charges)

• the freight weight (in pounds)

• the number of units (weight divided by 100)

Creating a CWT record

The first step is to create a table with a CWT rate.

1. Go to Home > Transportation > Rate Tariffs.

2. Click the plus icon to create a new record.

3. On the General page, click the Type field and select a CWT option. (see below)

4. Enter a description.

5. Fill in the remaining fields as needed.

6. Click Save.

Type options

The Type drop-down menu has three CWT options:

• LTL, CWT city to city

• LTL, CWT zip code to zip code

• FTL, CWT city to city

Adding table details

Next, create one or more routes and enter CWT rates.

1. Click the Table Detail link on the side menu.

2. Click the plus icon to create a row.

3. Enter a Start and End point for the route. Use a format (e.g. city or zip code) that matches the Type option selected above.

4. Enter a Max Weight (required).

5. Enter a figure in the Rate column (dollars per CWT unit).

6. Click Save.

7. Repeat the steps to add another route.

Deleting records

To remove a row from the table:

1. Click the grey area of a row. It becomes blue.

2. Click the minus icon.

3. Click OK in the confirmation popup window.

Configuring a shipment/load

This step shows DVU users how to apply the CWT rate in a shipment/load or pending quote.

1. Open or create a shipment/load or pending quote.

2. On the General page, click the Rate Tariff field and select the CWT rate tariff file for this route.

3. Click Commodities on the side menu.

4. Click the plus icon to create a new record or open an existing record.

In the side panel:

1. Add a description.

2. Enter a shipment/load weight. This field is required, and the value must be greater than zero.

3. Click Save.

DVU creates/updates a record.

Managing records

1. Double-click a record to update information.

2. Click the minus icon to delete a record.

Checking the calculation

Return to the General page. DVU dynamically pulls the CWT rate for this route from the Rate Tariffs table and the weight from the Commodities page.

Based on these figures, DVU calculates the Total Revenue.

• (12,000 pounds / 100 = 120 CWT units x $25 rate = 3000)