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
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.
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.