Supplemental Tables

In BrokerWare, you have many options for maintaining the correct Fuel Surcharge per carrier and customers. You can set a standard FSC on both profiles. This would be best used for carriers that do not change their FSC rates based off the weekly updates from the Department of Energy.

For the carriers that do base their rates off of the national average, you can use the "Supplemental Tables". These Tables can be used for any supplemental you deem, but you will find these most useful for Fuel. These tables can be entered by hand or can be uploaded from a file. There are no limits as to how many customers and carriers you link these to. You can use these tables for both your cost and billed. These tables can also be protected.

Building a Table: Go to "Supplemental Charges" on your home page. From there Click on "Supplemental Schedules" You should start first by creating a "Schedule Type". The Type is going to reflect the current rate. This is the value of which the schedule decides to use for the correct range, within the table.

Next you can build the table. Click on "Create New Schedule". You will be required to give the schedule a name, select the "Supplemental Type", and the "Cost Type". The Cost Type is how the amount on the table is calculated for the additional charge. (i.e.; Percentage= will calculate the % from the cost of the shipment. Flat Dollar = will add on a flat dollar amount.)

You must select "Save" before you can begin building the table itself.

You can upload a table with out having to hand enter in every range. There are specific file requirements before this can be completed. See instructions for uploading below.

Once the Schedule has been save you will notice a new field appeared below. This is where you will enter the range and the amount to use for it. Place the bottom amount in the "Low" column, and the Top amount in the "High" column. The cost column is the amount to use for this row.

Once you have the table built you can now attach it to a "Supplemental Charge"

To add the Table to a supplemental charge you need to be in the "Supplemental Charge" Change the "Type" to "Schedule" for either the cost or billed or both. Once the type has been changed you will notice the field to the left change accordingly. Select the schedule you want to associate with the supplemental charge. The Display for the supplemental will remain the same as for all supplemental charges.

To upload an Excel File into the tables:

The file to be uploaded must be have the following done to it before loading.

1. Remove column names. The file must have the data only, no names or labeling.
2. The columns must be in the following order(Low, High, and Value)
3. Save the file as a CSV. From Excel, once the above has been completed, go to File, select "Save As," (the file name does not have to be specific). Change the "Save Type as" field to CSV. You will get some notifications about the style changing, this is ok. Save the file somewhere handy for quick loading.
4. Once the file has been saved you can now upload it to your BrokerWare using the Upload feature in the Schedule, by clicking on "Browse" search for the correct file, and upload.