Applicable Product: Shipper
Applicable Module: Manage
Applicable SKU: All accounts that have the Manage module enabled will be able to access the Data Manager and add materials.


Use the Base Fuel Rate(BFR) master to create and maintain fuel rate contracts between Shippers and Transporters along with the dedicated fuel rates for each lane.


The BFR master 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 fuel rate and unit for every contract, maintenance of a proper Base Fuel Rate is essential.


Table of contents


Product workflow


Accessing Base Fuel Rate in Pando

To access the list of all BFR contracts  in Pando, go to Data Manager and select Base Fuel Rate from the drop down. This brings up the list of all rates that have been added to your Pando account.




Creating a BFR contract in Pando

BFR contracts can be created in bulk through XLSX uploads. 

Bulk:

You can create contracts in bulk by uploading them in an .xlsx file. 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 BFR fields values to this file and upload it back to Pando by clicking Bulk Upload and selecting the updated file.


Once the upload is completed, you will be presented with the Success notification that indicates the completion of the operation and the number of contracted fuel rates 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 the fuel contracts into Pando.


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


Field Glossary

Field

Field Purpose

Sample Upload File name

Source

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


For example, it could be a city like Sacremento, or a depot for Walmart inside Sacramento, say, WAL-SAC-10

Source*

Source Type

The type of the source. One of the following source types are usually used— warehouse, depot, city, state, or region

Source Type*

City Reference

The name of the city who's fuel prices will be used as the base for computing the fuel rate

City Reference*

Transporter

The reference ID of the Transporter with whom this BFR contract has been signed. This reference ID will be matched with the reference ID created under the Transporter Master

Transporter Reference ID*

Current BFR

The current or active Base Fuel Rate that has been agreed upon under the contract terms. This value will be used in the Rate Matrix and will also be used to calculate fuel costs for the lane

Base Fuel Rate*

Min BFR Threshold

The percentage/value of price rise/drop post which the fuel pegging comes into effect.

Min BFR Threshold

Max BFR Factor

The maximum percentage or absolute value that will be added or deducted to the base freight if the fuel rate increases or decreases

Max BFR Factor

Rate Factor

The percentage of Base Freight that will get added as the Fuel component when fuel price changes

Rate Factor

Updated BFR

The updated Base Fuel Rate which is picked up at a predetermined time-interval.

Updated Base Fuel Rate

Frequency

The days of the month on which the BFR scraping occurs and the pegging happens. 


For example, if the field is set as 10, then the fuel pegging runs the 10th of every month and the freight rate is updated in line with the change of the fuel price. 


The pricing for the fuels are taken from the following sources:


Effect From

The date from which the Base Fuel Rate charges are valid


Updated Date

The recent date when the Base Fuel Rate was updated


BFR Label

The reference label of a given BFR charge. The BFR label is used as a look-up for a lane in the Rate Matrix and the Dedicated Truck Master. The BFR label can be a string value.


Additional Factor

Additional charges that will be added or subtracted from the fuel component to accommodate other charges such as taxes and tolls. Additional factor can be added as either percentage values or absolute values. It accepts both positive and negative values.