Fuel surcharge
How it works and what it costs
Fuel surcharge programs are widely used in truck transportation, from parcel to full truckload
This is the Event calculation and how to activate it...
A fuel surcharge is an extra fee charged by haulage companies (or third parties) to cover the fluctuating cost of fuel. It is calculated as a percentage of base rate and is usually added to a shipper's freight bill to cover the cost of operations.
The Fuel surcharge configuration in Event
Types of Fuel Surcharge
1. UK fuel index (Portlands / Platts / EU)
2. US fuel index (EIA US)
The Event fuel calculation
(((C-A)/A)*B%)*100)
Where:
A- Calculate base fuel rate with haulier
B- Agree surcharge fuel % with haulier
C- Get current fuel price from the haulier preferred fuel index
Example...
Invoice cost = £1500
A- 0.900
B- 33.33%
C- 0.9412
(((0.9412-0.90)/0.90)*33.33%)*100)
Fuel surcharge % = 1.526%
Fuel surcharge for Invoice (1.526% of 1500) = £22.89
The Event fuel options
To activate fuel surcharge, you need to add the following information and make the following choices.
The Fuel wizard will guide you through the process...
-
Select the correct fuel index to get the starting fuel price
Select the index to use from the dropdown list. The Event primary index is 'PLATTS'
-
Confirm the correct baseline cost
This will be set to the current fuel cost when 1st activated.
It is an editable field and so can be updated as required
-
Add the agreed fuel surcharge %
This is added as a percentage based on 1 in 3 or 1 in 4 .
Each fuel price % variance allows a rate % variance.
Example: 33.33%, 25%
-
Rounding to nearest
Select to round up or down to the nearest decimal.
You can select to round to the nearest whole number. For example rounding down 2.98% = 2%
-
Rounding
Select to round to the nearest decimal.
You can select to round to the selected decimal places
-
Truncating
Select to remove all the digits after your chosen number of places
For example, 3.14159265... can be truncated to 3.1415. Note: If 3.14159265...were rounded to the same decimal place, the approximation would be 3.1416.
-
Allow negative fuel surcharge
Fuel surcharge is not always a positive number. In periods of low fuel cost, a surcharge can mean a route rate is reduced.
This function will show a negative fuel surcharge as zero.
-
Activate fuel surcharge
Switch it on or off.
Fuel is calculated per invoice, at 01:00 Sunday morning. At this point we make the calculation.
Activating Fuel Surcharge
What it is and how to use it...
This guide will step through setting up a fuel surcharge for a carrier
For a carrier to be available in Event, they must have a rate for the destination. The rate can be 0.00. Use the template provided below.
Select VITALS from your menu
On save, we will show and show you the user and date this screen was last updated.
For a carrier to be available in Event, they must have a rate for the destination. The rate can be 0.00. Use the template provided below.
When is fuel updated
-
Calculated on a weekly invoice for the complete invoice cost at 01:00 Sunday
-
Does not include VAT
-
Includes additional costs
De-activating or editing a carriers fuel surcharge during a week will not have a negative effect as the process will look for the agreed rules only at 01:00 on Sunday morning
EU Fuel Surcharge
This fuel surcharge is only visible for accounts that are EU countries
note:
CONNECT
How carriers see fuel surcharge...
-
The fuel cost
We show the fuel surcharge cost on the invoice so you can see the breakdown. Rollover over the fuel cost line to see the breakdown
CONNECT fuel
How and where to find fuel
This guide will step through how fuel is added to an invoice and how to check it
At the end of a week, when all routes for collection in that week have been approved, an invoice will show as ready. Click on the invoice widget...
The Invoice screen gives you the ability to upload an invoice for the amount on the screen, the amount you approved....
The total includes any additional costs including fuel surcharge. We show this separately so you can see the breakdown. Rollover the fuel information to see your breakdown.
At the end of a week, when all routes for collection in that week have been approved, an invoice will show as ready. Click on the invoice widget...
If an invoice is ready for upload, a fuel surcharge will be calculated. If the invoice is not uploaded and the fuel surcharge is changed, overnight the next index will be used and the invoice re-costed.
US Fuel Surcharge
We use the EIA US fuel surcharge
How does this fuel surcharge work?
-
The fuel index is updated and stored every Monday.
-
The carrier is activated for the fuel
-
A template is created and upload by the user for a rate per mile based on the current fuel indes cost.
-
The new fuel index cost can de configured as to when it can be used and between what period of time
Set the carrier to the correct fuel index from dropdown. Download the fuel index file.
Complete template that shows range and cost per mile for that range.
The carrier will show as now having a fuel calculation file uploaded. Activate carrier now at bottom of screen.
Set the carrier to the correct fuel index from dropdown. Download the fuel index file.
The fuel surcharge table.
This table allows the user to dictate the correct price per mile to use in the calculation based on the EIA index price
Fuel Surcharge table
17/09/2021
-
FROMBAND
-
This is the range from
-
Can be to 3 decimal places
-
-
TOBAND
-
This is the range to
-
Can be to 3 decimal places
-
-
DISTANCE
-
This is the if KMS or Miles
-
-
COST PER DISTANCE
-
This is cost related to the range in points 1 and 2
-
Can be to 2 decimal points i.e. 0.98
-
-
CURRENCY
-
the currancy
-
Must be ISO currency USD / CAD
-
-
CALCULATION PERIOD FROM
-
This is the day when the fuel cost will be used from
-
This will be a day of the week in format MON, MONDAY
-
-
CALCULATION PERIOD TO
-
This is the day when the fuel cost will be used to
-
This will be a day of the week in format MON, MONDAY
-
-
DAYS DELAY
-
This is the number of days from the receipts of the fuel to its use
-
For example in this case received on Monday used 10 days later on WED until the next TUES
-