Applicable Product: Shipper
Applicable Module: Manage
Rate Matrix is a core module. All active Pando accounts that have the manage module will need Rate Matrix to operate.


ARTICLE NAVIGATION

Use the Rate Matrix to create and maintain all contracts between Shippers and Transporters along with the dedicated freight rates for each lane.


Rate Matrix maintains freight rates for every single lane along with the unit price, accepted Vehicle types, SLAs, and so. The data from Rate Matrix feeds into Optima and allows Pando to create contracted indents that are of the lowest price and assign them to the transporters that are best equipped to address the requirement— be it based on vehicle type or fleet availability and so on.


In order to pick the correct rate and unit for every indent, maintenance of a proper Rate matrix is essential.


Product workflow


Accessing Rate Matrix in Pando

To access the list of all the contracts in Pando, go to Data Manager and select Rate Matrix from the drop down. This brings up the list of all contracts that are currently available on your Pando account.


Creating a Lane/Contract in Pando

Shippers can create lanes through bulk in Pando by uploading them in an .xlsx file. 


To bulk upload contracts, click the UPLOAD dropdown and download the Sample format file. This file contains all the fields— mandatory and optional— in the format that needs to be uploaded. Add the lane fields values to this file and upload it back to Pando by clicking Bulk Upload and selecting the updated file. For rate matrix, you can upload the following files:

  • Lanes

  • Vehicles Excluded

  • Surge Threshold


Once the upload is completed, you will be presented with the Success notification that indicates the completion of the operation and the number of lane records that have been created and the ones that have been rejected.


To identify the files that have failed and to understand the reason behind their failure, click . This downloads the rejection list. The rejection list file contains the reason for rejection of a record. Fix the reason behind the import failure and upload the file back to Pando to finish uploading all material into Pando.


To understand details about all fields that are covered under material, check the 
Field glossary at the end of the article.


Field Glossary

Field

(Fields Marked * are mandatory)

Field Purpose

Field Type

Type*

The type of movement for which this contract is being configured. This is determined based on Source and Destination. There are several types of movements. However, they are all determined on the basis of one of the following:


- Point

- City

- State

- Region


Using the aforementioned Source/Destinations, your movement can follow a pattern similar to State-City, City-Point, State-Region, Point-City, Point-Region etc.

Alphanumeric

Source*

The location from where the shipment is dispatched. A source can be anything— a warehouse, depot, city, state, or even a region

Alphanumeric

Destination*

The location to where the shipment is bound. The destination is where the shipment will be delivered. A destination can be anything— a warehouse, depot, city, state, or even a region.

Alphanumeric


Vehicle Name*


(Vehicle Type*)

The name (or type) of the vehicle that is part of the contract

Alphanumeric


Distance

The distance that needs to be travelled by the truck between source and destination. This used for calculating the freight cost per km.

Number


Transporter Reference ID*

Reference ID of the transporter. This field is mapped to the Transporter Reference ID defined under the transporter master. If the reference ID provided here doesn't match with any reference ID created under the Transporter master, then the upload will be rejected.

Alphanumeric

Mapped to:Transporter Reference ID (Vehicle Master)

Transporter Name

Name of the Transporter. This field is mapped to the Transporter name field defined under the transporter master. If the name provided here doesn't match with any name created under the Transporter master, then the upload will be rejected.

Alphanumeric


Transit Days*

Number of days required for transit between source and destination as agreed upon in the contract. This is used for the calculation of the Arrival SLA and Detention. Once the number of days is exceeded, transit delay charges kick in.

Number


Detention Group

Detention group is used to combine several detention charges under a single head in order to make it easy for selecting and applying detention charges or waiving off detention charges

Alphanumeric

Mapped to:
Detention Group (Detention Master)

Valid From

The date from which the contract kicks in

Date

valid To

The date till which the contract is valid

Date

Rate

The rate at which the contract is being executed. This is also called the Base Freight Rate and invoices will be generated based on this rate.

Number

The unit that will be used for the application of the rate.

The following units are offered:


- Per Km

- Per Trip

- Per KG

- Per case

Text


Updated by

The recent user who updated the contract

System Generated Field

Updated date

The date when the contract was updated

System Generated Field

Minimum Rate

The Minimum value to be charged under this contract for generating an invoice. This is usually set as any value lower than this is usually not economically viable for the transporter and hence the minimum rate is agreed upon in the contract for every time an indent is accepted and an invoice generated for the transporter.

Number

Multiplying Factor

For volumetric weights, CFT (cubic feet) is converted to kilograms by multiplying it with a constant that is defined. This constant is called the Multiplying Factor.


*Volumetric Weight is a weight-measurement technique where the weight of a package is calculated as the product of its length, breadth, & height multiplied by a specific constant. This volumetric weight is then weighed against the dimensional weight of the package to find the higher of the two, and then, apply the rate to that value.

Number

Route Exclude


Trip Count


Fixed Rate

Charge that will add on top of freight rate. Could include toll charges, driver fees, etc.

Number

Additional Charge %

Charge that will add on top of freight rate. Could include toll charges, driver fees, etc. Calculated as a percentage of base freight

Number


Hilly Region Addition %

Charge that will add on top of freight rate. Could include toll charges, driver fees, etc. Calculated as a percentage of base freight

Number

Oda Rate

Out of Delivery area. unit Rate charged

Unit

Oda Unit

Per Unit. Could be KM. Trip etc


Minimum Oda

Minimum ODA rate to be charged for generating invoice


Drop Point Charges

Drop-off charge refers to the charge levied by the transporter for delivering the consignment at the location. Drop-off charges are usually applied when the destination is in the heart of the city or in a remote location that requires additional logistics.


Mapped to:Drop-off charges

Is Dedicated (truck)

YES/NO. Trucks liased with the Shipper.


(Dedicated) Truck Count

Number of dedicated vehicles available for operation on a given lane under the contract.


Running Count

Number of dedicated vehicles under operation or transit on a given lane under the contract.


Is Round Trip Eligible

YES/NO. Trucks


Return Round Trip

Return Freight Rate


Pickup Point Charges

Pickup point charges: when multiple pickup points are there, we add these in the charges


BFR Label

The reference label of a given BFR (Base Fuel Rate) charge. The BFR label is looked up from the BFR master.

Alphanumeric



SURGE THRESHOLD



Source*

The location from where the shipment is dispatched. A source can be anything— a warehouse, depot, city, state, or even a region


Destination*

The location to where the shipment is bound. The destination is where the shipment will be delivered. A destination can be anything— a warehouse, depot, city, state, or even a region.


Transporter Reference Id*

Reference ID of the transporter. This field is mapped to the Transporter Reference ID defined under the transporter master. If the reference ID provided here doesn't match with any reference ID created under the Transporter master, then the upload will be rejected.


Vehicle Type*

The name (or type) of the vehicle that is part of the contract


Surge Threshold*

Minimum number of vehicles transporter is expected to make available per day. If threshold exceeds, SLA charges will be waived.





VEHICLE EXCLUDE



Source

The location from where the shipment is dispatched. A source can be anything— a warehouse, depot, city, state, or even a region


Destination

The location to where the shipment is bound. The destination is where the shipment will be delivered. A destination can be anything— a warehouse, depot, city, state, or even a region.


Vehicle Type

The name (or type) of the vehicle that is part of the contract


Exclude


Trip Count

Number of trips that are contracted for the dedicated truck





INSIDE INDIVIDUAL CONTRACTS



Product Category

Select the material category to which this material belongs to. This is to help aggregate different materials under a category that can used for prioritization in Optima


Min Slab Range

For slab-wise contracts where the tariff applied depends on the range of weight that the product falls between slab range is determined capturing the different slab rates, helps enforce the contract better, For example, in some contracts, for a range of weight between say 1.5 tons to 5 tons, a particular unit pricing needs to be applied, then shippers can assign the minimum and maximum slab range inside that particular contract.


Max Slab Range